crash_reports

Table actions

1 row where dcc = "["Over-steering"]", intersection = 0 and keywords contains "Ems"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)

Case number:
22000602
Date:
2022-07-06
Time:
19:18
Address:
1243 WALNUT ST
Speed limit:
25
Violation cited:
no
Narrative:
OP1 of MV1 was traveling westbound on Rt. 9. MV1 was headed toward the Centre Street exit of RT. 9. The Centre Street exit on Rt. 9 has been closed due to ongoing construction. MV1 did not realize the exit was closed. In an attempt to avoid driving through the detour signs, MV1 made an abrupt turn off of Rt. 9 onto Walnut Street. As MV1 abruptly turned onto Walnut Street (Northbound), OP1 had no control over MV1. MV1 continued onto the curb, through the grass, and through the drive away. MV1 then crashed into the front porch of 1243 Walnut Street. MV1 sustained heavy front end damage. MV1 was towed by Todys. A towed inventory sheet was completed. OP1 was transported to BI Boston by Fallon Ambulance. Dispatch notified Building Inspector. Photos of Crash were taken and turned into IT.
Keywords:
Crash, Ems, Pictures
Dcc:
Over-steering
Report url:
report
Image url:
image
Latitude:
 
Longitude:
 
Location:
None

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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);