crash_reports

Table actions

1 row where date = "2021-11-10" and dcc contains "Inattention"

✎ View and edit SQL

This data as json, CSV (advanced)

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

Case number:
2100000933
Date:
2021-11-10
Time:
19:06
Address:
527 WASHINGTON ST
Speed limit:
35
Violation cited:
no
Narrative:
Operator of MV1 stated he was traveling on Adams street southbound when MV2 began tapping the breaks. When both vehicles turned left onto Washington Street, eastbound, MV2 began tapping on the breaks again. Operator of MV1 attempted to go around MV2 and while checking if he was clear to change lanes, MV2 hit the breaks again and MV1 rear ended MV2. The operator of MV2 stated while traveling eastbound on Washington Street, she stated she hit the breaks because she drives slow. When MV2 hit the breaks, MV1 rear ended her vehicle. MV1 did have air bag deployment and both operators were evaluated by the medics and signed a refusal. Both vehicles were inoperable and todys was notified for a tow.
Keywords:
[]
Dcc:
Inattention
Report url:
report
Image url:
image
Latitude:
42.3553951
Longitude:
-71.1947475
Location:
527 Washington St, 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);