crash_reports
2 rows where date = "2022-06-04" and "datetime" is on date 2022-06-04
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2022-06-04
Time:
13:25
Address:
22 WOODWARD ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Vehicle 1 was waiting in southbound traffic at the traffic light for the intersection of Woodward St and Boylston St when the operator realized he was in the wrong turn lane. Vehicle 1 then attempted to reverse to give him room between him and the vehicle in front of him so he could change lanes, however he did not notice Vehicle 2 waiting in traffic behind him. Vehicle 1 then backed into Vehicle 2, causing minor damage to the rear bumper of Vehicle 1 and significant damage to the front end of Vehicle 2. Both operators gave similar accounts.
Keywords:
[]
Dcc:
Visibility obstructed, Inattention
Report
url:
Image
url:
Latitude:
42.3193608
Longitude:
-71.2132886
Location:
Case
number:
Date:
2022-06-04
Time:
17:55
Address:
22 LANGLEY RD
Speed
limit:
10
Violation
cited:
no
Narrative:
The operator of MV1 was turning left exiting the parking lot at the rear of 22 Langley Rd onto Lyman St when she struck a fire hydrant and two concrete column's protecting the hydrant. MV1 sustained minor damage to the front drivers side fender and drivers door. Two concrete column's were knocked over as well as the hydrant being dislodged. The operator of MV1 was uninjured. MV1 was able to drive away from the scene. Photos of the damage to the vehicle as well as the hydrant and concrete column's were submitted to the IT Bureau. DPW was notified to replace the hydrant and concrete column's.
Keywords:
Fire, Pictures
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3311629
Longitude:
-71.1933552
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);