crash_reports
2 rows where "date" is on date 2019-05-09 and speed_limit = 35
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-05-09
Time:
16:10
Address:
COMMONWEALTH AVE & LEXINGTON ST
Speed
limit:
35
Violation
cited:
no
Narrative:
I responded to the area of Commonwealth Ave@Lexington st at approx 1610 hrs on 05/09/2019 for a report of a H&R/MVA. I arrived in the area and located Sarah Hamilton. Sarah informed me that she was on Comm. Ave (westbound) stopped attempting to turn left into the Dunkin Donuts parking lot. Sarah stated she was rear ended by a silver sedan operated by a female operator. Sarah spoke with the unidentified woman, who refused to exchange information. The woman returned to her vehicle and left the area. Sarah could not get the license plate, vehicle make /model. Sarah Hamilton complained of neck pain. EMS responded to medically evauate her. Sarah did not want to be transported to the hospital and signed a refusal/waiver with EMS. The only damage I observed to V1 was paint scratches along the rear bumper. The rear bumper was intact free of any dents/creases.
Keywords:
Ems, Hospital
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3478859
Longitude:
-71.247136
Location:
Case
number:
Date:
2019-05-09
Time:
15:45
Address:
320 WASHINGTON ST
Speed
limit:
35
Violation
cited:
no
Narrative:
The operator of vehicle 1 MA REG: 1AB918 stated she was traveling West on Washington Street and did not see vehicle 2 MA REG: 925WP2 at all until she crashed into the rear driver side of it. This caused major damage to vehicle 1 and minor damage to vehicle 2. Both drivers exchanged information and the operator of vehicle 2 left the area. The operator of vehicle 1 remained there to speak with police and wait for a private tow company.
Keywords:
Crash
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3563932
Longitude:
-71.1872752
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);