crash_reports

Table actions

1 row where keywords contains "Bus" and "retrieved" is on date 2021-01-08

✎ View and edit SQL

This data as json, CSV (advanced)

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

Case number:
2100000001
Date:
2021-01-01
Time:
16:24
Address:
17 ST JAMES TER
Speed limit:
25
Violation cited:
no
Narrative:
MV1 stated she was attempting to manuever around vehicles to exit the street when "I stepped on the gas and not the brake" while in reverse subsequently going backwards, over a curb, across the lawn, and into the bushes of 17 St James Ter sustaining heavy damage throughout the vehicle. The homeowner of the residence reported damage to his curb, lawn, bushes and electrical conduit (Newton Fire checked the residence prior to clearing). Todys Towing responded and removed the vehicle from the lawn and leaving it on the street as the owner wanted AAA to respond. Due to airbag deployment, Fallon Ambulance responded to the scene, however the driver refused to be evaluated (also refused to sign a refusal).
Keywords:
Airbag, Bus, Ems, Fire
Dcc:
Inattention
Report url:
report
Image url:
image
Latitude:
42.3591861
Longitude:
-71.1802388
Location:
17 St James Terrace, Newton, MA 02458, 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);