crash_reports
2 rows where keywords = "["Pictures"]" and "retrieved" is on date 2022-05-04
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2022-04-27
Time:
10:24
Address:
45 BEECHER TER
Speed
limit:
20
Violation
cited:
no
Narrative:
The operator of MV#1 stated she accelerated once within the driveway of 45 Beecher Ter. causing her to collide into the front right corner of the home. It appears the vehicle then slid approx. 5-10 feet into the fence which runs adjacent to the driveway causing damage to both the fence and retaining wall. Damage observed to the front right corner of 45 Beecher Ter. MV#1 sustained heavy damage to its front end and was towed by its owner. No injuries reported. Homeowner of 45 Beecher Ter. on scene and took photographs of damage to his property.
Keywords:
Pictures
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3216877
Longitude:
-71.1823438
Location:
Case
number:
Date:
2022-04-28
Time:
18:57
Address:
WASHINGTON ST & CHERRY STREET
Speed
limit:
25
Violation
cited:
no
Narrative:
Operator of Vehicle #1 was stopped in heavy traffic on Cherry Street near the intersection with Washington Street. NPD Cruiser 502 was responding to an emergency with lights and sirens activated. Vehicle #1 was moving towards the shoulder of the road to yield to the emergency vehicle. Cruiser 502 struck the driver side rear panel and bumper. Operator #1 was not injured. Operator of Vehicle #2 was responding to an emergency with lights and sirens activated. While attempting to navigate through congested traffic, Vehicle #2 struck Vehicle #1. Vehicle #2 sustained damage to the passenger side doors. Operator of Vehicle #2 was not injured. Both vehicles were driven from the scene. Photographs taken and submitted to IT Bureau for filing.
Keywords:
Pictures
Dcc:
Over-steering, Inattention
Report
url:
Image
url:
Latitude:
42.3490417
Longitude:
-71.2281633
Location:
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "crash_reports" ( [case_number] TEXT PRIMARY KEY, [datetime] TEXT, [date] TEXT, [time] TEXT, [address] INTEGER, [street1] TEXT, [street2] TEXT, [intersection] INTEGER, [speed_limit] INTEGER, [hit_run] INTEGER, [violation_cited] INTEGER, [narrative] TEXT, [keywords] TEXT, [dcc] TEXT, [dcc_code] TEXT, [report_url] TEXT, [image_url] TEXT , [geocoded_address] TEXT, [latitude] TEXT, [longitude] TEXT, [manual_geocode] INTEGER, [retrieved] TEXT);