crash_reports

Table actions

2 rows where dcc = "["Over-steering", "Inattention"]", intersection = 0 and keywords contains "Moderate"

✎ View and edit SQL

This data as json, CSV (advanced)

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

Case number:
1900001240
Date:
2019-12-02
Time:
22:24
Address:
WASHINGTON ST
Speed limit:
30
Violation cited:
no
Narrative:
Operator of MV1 stated he was traveling Eastbound on Washington St. when MV2 turned left in front of his vehicle colliding with him. Operator of MV2 stated he was traveling in the right hand land on Washington St. traveling Eastbound when he attempted to make a U-turn to travel Westbound onto Washington St. Operator of MV2 stated he first attempted to change lanes, however collided with MV1. No injuries. MV1 sustained minor damage to the right front end. MV2 sustained moderate damage to the left front end. Todys responded and towed MV2. A towed motor vehicle form was filled out in regards and placed on file.
Keywords:
Moderate
Dcc:
Over-steering, Inattention
Report url:
report
Image url:
image
Latitude:
42.3498391
Longitude:
-71.2179998
Location:
Washington St, Newton, MA, USA
Case number:
2100000505
Date:
2021-07-12
Time:
19:30
Address:
65 ELLIS ST
Speed limit:
25
Violation cited:
no
Narrative:
Operator of MV1 was traveling Northbound on Ellis Street when she stated she itched a sun burn, lost control of her vehicle and struck a utility pole near 65 Ellis Street. MV1 sustained moderate right fender and tire damage. MV1 was towed by AAA at owners request. No injuries. No damage to utility pole.
Keywords:
Moderate, Solar
Dcc:
Over-steering, Inattention
Report url:
report
Image url:
image
Latitude:
42.3146544
Longitude:
-71.2258307
Location:
65 Ellis St, Newton, MA 02464, 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);