crash_reports
2 rows where dcc contains "Inattention", hit_run = 0 and speed_limit = 24
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-11-22
Time:
09:46
Address:
NAHANTON ST & WELLS AVE
Speed
limit:
24
Violation
cited:
no
Narrative:
Carl Massicotte was operating vehicle #2, stopped on Wells Ave at the Nahanton St red light. Carl states that he was struck from behind by vehicle #1. Salvador Gonzalez was operating vehicle #1. Carl states that he went to pick up an item off the floor and rolled into the back of vehicle #2. No injuries no tows.
Keywords:
[]
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.2971091
Longitude:
-71.2040054
Location:
Case
number:
Date:
2022-07-03
Time:
17:59
Address:
CHESTNUT ST & WASHINGTON ST
Speed
limit:
24
Violation
cited:
yes
Narrative:
MV 1 was traveling straight eastbound on Washington St. When MV 1 approached the intersection of Chestnut St and Washington St he rear ended MV 2. MV 1 sustained major damage to its front end including a fluid leak. The front air bag of MV 1 deployed. There were no injuries to the operator of MV 1, Mr. Million Yifru, and he signed a patient refusal with Fallon medics. Million was given a citation for operating a motor vehicle with an expired license (MGL ch 90-10) in hand. MV 1 was towed by todys due to it being disabled. MV 2 was stopped in traffic at the intersection of Chestnut and Washington St when he was rear ended by MV 1. MV 2 sustained minor damage to its rear bumper. The operator and passenger of MV 2 were not injured and both signed patient refusals. MV 2 was safe to drive from the crash.
Keywords:
Citation, Crash
Dcc:
Followed too closely, 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);