crash_reports
1 row where "date" is on date 2022-05-20 and latitude = "42.3472639"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2022-05-20
Time:
20:19
Address:
ELM RD & WALNUT ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Operator of MV1 said he was stopped at the red light and when the light turned green he took his foot off the brake and hit the accelerator. Operator of MV1 said the vehicle in front of him hit it's brake's and he hit the accelerator instead of the brake and struck MV2. Operator of MV2 said he was stopped at the red light and when the light turned green he was struck from behind by MV1 which caused him to strike MV3. Operator of MV3 said he was stopped at the red light and when the light turned green he was struck from behind by MV2. Fallon Medics and Newton Fire responded and evaluated all parties involved. Both occupants inside of MV2 stated they had neck pains but signed a patient refusal. All vehicles were able to drive away from the scene. There was damage done to the front bumper of MV1. There was damage done to the rear bumper, rear driver taillight, and front bumper of MV2. There was damage done to the rear of MV3.
Keywords:
Fire
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3472639
Longitude:
-71.2065995
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);