crash_reports
1 row where "date" is on date 2019-06-13, intersection = 0 and keywords contains "Ems"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array)
Case
number:
Date:
2019-06-13
Time:
12:55
Address:
140 BRANDEIS RD
Speed
limit:
10
Violation
cited:
no
Narrative:
Operator of MV1 (MA reg 986EW5) stated she was backing out of her parking spot when her vehicle was struck on the rear passenger side bumper. Operator of MV2 (MA reg 9PP698) stated she was traveling straight ahead and did not see MV1 backing out when she struck the vehicle. Both vehicles sustained minor damage and did not require a tow. The operator of MV1 was complaining of some neck pain so I called for an ambulance to evaluate the party. The driver and passenger and MV2 did not state they had any injuries. Engine 10 and ambulance 1 arrived on scene to speak with the injured party. The injured party signed a medical refusal. Both parties were able to drive away from the scene without any incident.
Keywords:
Ems
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3135234
Longitude:
-71.1865424
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);