crash_reports
2 rows where "datetime" is on date 2022-07-03 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-03
Time:
15:37
Address:
MILL ST & MORTON ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Operator of MV1 said she was traveling Eastbound on Mill Street. Operator of MV1 said she looked down for a second then when she looked up she did not have enough time to stop and struck the Utility pole (Pole 28/23). There was very minor damage to the Utility pole. There was air bag deployment and Fallon Medics came and evluated Operator of MV1. Operator of MV1 signed a patient refusal. There was heavy front end damage to MV1 and MV1 was towed away by Todys. I filled out a towed motor vehicle sheet and took pictures of the Utility pole.
Keywords:
Pictures
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
Longitude:
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);