crash_reports
2 rows where date = "2021-06-21" and "retrieved" is on date 2021-07-04
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-06-21
Time:
13:11
Address:
238 GRANT AVE
Speed
limit:
25
Violation
cited:
no
Narrative:
Mv#1 operator stated he came to a stop on Grant Ave N/B at #238 for a vehicle that was backing out of that driveway. #1 stated at that time he was rear ended by Mv#2. #1 operator was outside on the sidewalk when I arrived on scene. #1 stated he had neck and back pain from being rear ended. #1 front seat passenger stated she had neck pain. #1 operator already exchanged #2 operator and vehicle info. #2 left scene prior to my arrival. Both #1 occupants were evaluated and transported by medics to NWH for further evaluation. #1 was towed by Tody's with moderate rear end damage. I responded to #2 operator address to get a statement. #2 was not home. Her statement was taken over the phone. #2 stated she was travelling on Beacon St E/B, turned N/B on Grant Ave then couldn't stop in time and rear ended #1. #2 was not injured and stated she had minor front end damage.
Keywords:
Moderate, Phone
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3317879
Longitude:
-71.1879481
Location:
Case
number:
Date:
2021-06-21
Time:
17:18
Address:
200 BOYLSTON ST
Speed
limit:
20
Violation
cited:
no
Narrative:
Owner of MV2 stated she was parked for work during the hours of 8:00AM and 5:00PM. Owner, Marissa stated when she came out she noticed the damage and observed a napkin on her windshield. The napkin had the other involved vehicle's information on it. MV2 was unoccupied when struck and sustained significant damage on her driver's side rear bumper and quarter panel. I called and spoke to the Opr. of MV1. The Opr, Alexandra stated she was turning left into the parking spot and struck MV2. Alexandra stated her vehicle was not damaged and she left all the information on the windshield of MV2. No injuries reported.
Keywords:
[]
Dcc:
Over-steering
Report
url:
Image
url:
Latitude:
42.3189069
Longitude:
-71.1752159
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);