crash_reports
2 rows where dcc = "["Inattention"]", intersection = 0 and "retrieved" is on date 2021-02-19
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-02-11
Time:
10:07
Address:
155 LEXINGTON ST
Speed
limit:
25
Violation
cited:
no
Narrative:
The operator of MV#1 stated that he was traveling south on Lexington St (#155) when he looked down for a second and his MV stuck MV#2. MV#2 was parked and unoccupied in front of #155 Lexington St at the time of the crash. No injuries, both MV's towed from the scene.
Keywords:
Crash
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3555308
Longitude:
-71.2423822
Location:
Case
number:
Date:
2021-02-12
Time:
14:57
Address:
732 BEACON ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Operator of vehicle 1 states she was traveling westbound on Beacon St and came to a full stop and turned on her left directional to turn into the service station at #732 Beacon St. While waiting to make the left turn she was struck from behind by vehicle 2 and jolted forward and to the left head on into a tree in front of #732 Beacon St. Operator of vehicle 2 states she was traveling westbound on Beacon St and did not see vehicle 1 stopped in front of her until it was to late and rear ended her vehicle. Both operators were seen by medics and signed patient refusals. Both vehicles were towed from the scene by Todys Towing.
Keywords:
Tree
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3304375
Longitude:
-71.1905008
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);