crash_reports
1 row where dcc_code = "[6]" and "retrieved" is on date 2022-06-04
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2022-05-18
Time:
11:47
Address:
721 WASHINGTON ST
Speed
limit:
35
Violation
cited:
no
Narrative:
On May 18th, 2022 at approximately 11:47 hours while assigned to N491 I responded to a report of a MV crash in the area of #727 Washington St, Newtonville. On my arrival to the scene there was a MSP trooper on scene that happened to be driving by. Vehicle #1 was a gray 2018 Hyundai Electra, MA plate 3VMR89, operated by Paula R. Lima with heavy damage. Ms Lima stated she was parked facing W/B on Washington St near #721 when she attempted to make a U-Turn to go E/B when she was struck by vehicle #2. Vehicle #2 was a 2016 Jeep Compass, MA. reg 298XH9, operated by a Jevon D. Foster. He stated he was going W/B on Washington St when vehicle #1 pulled out in front of him from a parked position causing him to crash into her vehicle. Both vehicles were towed by Todys and there were no reported injuries.
Keywords:
Crash
Dcc:
Improper turn
Report
url:
Image
url:
Latitude:
42.3527483
Longitude:
-71.2031248
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);