crash_reports
1 row where "datetime" is on date 2019-05-09 and keywords contains "Hospital"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (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:
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);