crash_reports

Table actions

1 row where address = "WASHINGTON ST & BEACH ST" and "date" is on date 2019-11-22

✎ View and edit SQL

This data as json, CSV (advanced)

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

Case number:
1900001202
Date:
2019-11-22
Time:
16:10
Address:
WASHINGTON ST & BEACH ST
Speed limit:
25
Violation cited:
no
Narrative:
Vehicle 1 was traveling Southbound on Beach St. Vehicle 1 came to a stop at Beach St. and Washington St. before attempting to take a left turn onto Washington St. When Vehicle 1 crossed into the far right westbound travel lane onto Washington St. it was struck by Vehicle 2 on its left driver side. Vehicle 2 was traveling Westbound in the far right travel lane on Washington St. Vehicle 2 while traveling straight ahead when it collided with Vehicle 1 who was attempting to cross the westbound travel lanes and turn east onto Washington St. Vehicle 1 sustained minor damage to it's driver side. Vehicle 2 sustained minor damage to it's front end. The Owner of Vehicle 2 decided to have AAA tow the vehicle from the scene. No drivers or passengers were injured.
Keywords:
[]
Dcc:
Failed to yield
Report url:
report
Image url:
image
Latitude:
42.3523045
Longitude:
-71.2037243
Location:
Beach St & Washington St, Newton, MA 02460, 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);