crash_reports
1 row where keywords contains "Ped" and "retrieved" is on date 2021-04-28
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-04-09
Time:
14:53
Address:
CENTRE ST & NEWTONVILLE AVE
Speed
limit:
30
Violation
cited:
no
Narrative:
On April 9th, 2021 at approximately 14:53 hours while assigned to N491 I responded to a two car MV crash at the intersection of Centre St @ Newtonville Ave with injuries. On my arrival with the NFD I located both vehicles. First was a 2013 Subaru station wagon impreza, ma reg 5LMZ60 with heavy front end damage. The operator was identified as Ann Maria Harle. She reported going S/B on Centre St by Newtonville Ave when vehicle #2 suddenly stopped in front of her. She attempted to stop before crashing into the rear of vehicle#2. Vehicle #2 was a 2020 Jeep Cherokee, MI reg. EHJ9616 with rear end damage. Operator was identified as Lauren Duche. She reported going S/B on Centre St when a vehicle in front of he suddenly stopped due to a pedestrian crossing the street. She was then rear ended by vehicle #1.(cid:31)Vehicle #2 never made contact with the vehicle in front of her after being rear ended. Vehicle #1 was towed by Todys Garage Vehicle #2 was able to drive away. Fallon Ambulance check out all parties from both vehicles but all adults signed patient refusals.
Keywords:
Crash, Ems, Fire, Ped
Dcc:
Followed too closely
Report
url:
Image
url:
Latitude:
42.3515559
Longitude:
-71.1861175
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);