crash_reports
2 rows where date = "2022-05-14" 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:
Case
number:
Date:
2022-05-14
Time:
06:56
Address:
CENTRE ST & COMMONWEALTH AVE
Speed
limit:
30
Violation
cited:
no
Narrative:
MV-1 stated she proceeded N/B Center Street through the green light at Commonwealth Avenue and Centre Street. MV-2 stated he was proceeding W/B Commonwealth Avenue through a green light at Centre Street. MV-1 and MV-2 collided in the center of the intersection. Both parties stated they had the green light. Operator MV1 transported to NWH. Operator and passenger MV2 transported to Beth Israel Hospital Both vehicles towed via Tody's
Keywords:
Hospital
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3365124
Longitude:
-71.1932597
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);