crash_reports
1 row where dcc = "["Failed to yield"]", intersection = 0 and keywords contains "Fire"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-08-28
Time:
10:58
Address:
2014 WASHINGTON ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On 8/28/2019 at approx 1058hrs while assigned to 497 I responded to the area of 2014 Washington St for a report of a 2 car crash w/o injuries. Upon arrival I observed the vehicles on opposite sides of Washington St with NFD Lt Bourgeois standing by with his emergency lights activated, Lt Bourgeois stated both operators were shaken up but not injured. I spoke with the operator of Ma Reg 1XM680 Elizabeth CHISOLM who stated she was attempting to take a left onto Washington St, a vehicle in the right hand eastbound lane was turning right into the parking lot, CHISOLM stated she did not see Ma Reg EV3452 being operated by Julien GRANT in the left eastbound travel lane until it was too late colliding with him. I spoke with GRANT who stated he was traveling EB in the left travel lane of Washington St when struck by CHISOLM exiting the hospital.
Keywords:
Crash, Fire, Hospital
Dcc:
Failed to yield
Report
url:
Image
url:
Latitude:
42.3306338
Longitude:
-71.2464373
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);