crash_reports
1 row where date = "2022-05-14", dcc contains "Reckless driving" and "retrieved" is on date 2022-05-23
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2022-05-14
Time:
14:29
Address:
347 WATERTOWN ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On May 14th, 2022 at approximately 14:29 hours while assigned to N491 I responded to a MV crash near #347 Watertown St. On my arrival I located both involved vehicles on Watertown St near Tommy Doyles. Vehicle #1 was parked in front of #354 Watertown St, a 2021 Gray Chevy Trailblazer, MA reg. 831ZY8. Owner Elizabeth Colon. Ms Colon reported she parked her vehicle across the street from Tommy Doyles, #349 Watertown St when vehicle #2 struck her vehicle. Unidentified witness alerted Ms Colon that they observed vehicle #2 hit her vehicle. Vehicle #2 was a RED 2007 Toyota RAV4, MA plate2HRN56, operated by Ana Cardoso Pereira. She stated she was attempting to park behind vehicle #1 when she accidently hit her accelerator instead of her brake causing her vehicle to go forward into the rear drivers side to vehicle #1. Note Ms Colon translated the above statement due to Ms Pereira only speaking Spanish. There were no tows required and no injuries.
Keywords:
Crash
Dcc:
Reckless driving
Report
url:
Image
url:
Latitude:
42.3608628
Longitude:
-71.2006507
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);