crash_reports

Table actions

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

✎ View and edit SQL

This data as json, CSV (advanced)

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

Case number:
22000593
Date:
2022-07-01
Time:
16:44
Address:
199 BOYLSTON ST
Speed limit:
25
Violation cited:
no
Narrative:
MV1 operator stated she was exiting the Chestnuthill Mall parking area to go onto Hammond Pond Parkway. MV1 operator stated she did not know how but she did not see the curb on her driver side, and struck it. MV1 operator said after striking the curb, her MV jumped the curb, struck a sign and rested onto of bushes. The sign was taken off near the bottom and landed on her driver side door. MV1 sustained heavy front bumper, driver side, and under carriage damage. Only the ankle/lower leg airbags by the pedals deployed. MV1 operator did not report any injuries and refused medical treatment. MV1 was towed by Todys. Chestnuthill Mall Allied Security Officer Gentle responded, and the Mall manager Jim Riccio was notified. Jim will forward estimated damage next week.
Keywords:
Airbag, Bus
Dcc:
Over-steering, Inattention
Report url:
report
Image url:
image
Latitude:
42.3215125
Longitude:
-71.1756718
Location:
199 Boylston St, Chestnut Hill, MA 02467, USA

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