crash_reports
2 rows where "datetime" is on date 2022-07-12 and "retrieved" is on date 2022-07-26
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2022-07-12
Time:
09:43
Address:
1255 CENTRE ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Mv#2 was parked on side of street in the area of 1255 Centre St S/B. #2 turned left to pull out of the space attempting a U-turn. Mv#1 was travelling straight ahead in the left lane on Centre St S/B. At this time, #2 driver's side front end struck Mv#1 passenger side. #1 and #2 sustained moderate damage to those areas. No injuries.
Keywords:
Moderate
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3304655
Longitude:
-71.1950492
Location:
Case
number:
Date:
2022-07-12
Time:
12:17
Address:
720 DEDHAM ST
Speed
limit:
25
Violation
cited:
no
Narrative:
The operator of MV#1 stated she was travelling northbound on Dedham St in the right side travel lane when she was struck by MV#2 merging from the left travel lane. MV#1 sustained heavy damages to its rear driver's side area. There were no reported injuries to the operator of MV#1. The operator of MV#2 stated he was travelling northbound on Dedham St in the left side travel lane attempting to merge onto the right side travel lane when he struck MV#1. The operator of MV#2 stated MV#1 was in his blind spot and he did not see it (MV#2 is a large commercial dump truck). MV#2 sustained minor non-visible damages to its passenger side front area. There were no reported injuries to the operator of MV#2.
Keywords:
[]
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
Longitude:
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);