crash_reports

Table actions

1 row where "date" is on date 2020-07-22 and keywords contains "Walk"

✎ View and edit SQL

This data as json, CSV (advanced)

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

Case number:
2000000395
Date:
2020-07-22
Time:
01:12
Address:
WATERTOWN ST & BRIDGE ST
Speed limit:
25
Violation cited:
yes
Narrative:
MV1 was operating westbound on Watertown St (public way). MV2 was parked on Watertown St in front of 144 Bridge St (public way). MV1 operator struck and side swiped MV2. MV2 sustained extensive damage. MV1 continued westbound on Watertown St and struck a cross walk sign and Newton Fire Department box which both in front of Coletti-Magni Park, and both were destroyed. MV1 hit and hopped the curb of Watertown St in front of Coletti-Magni Park, drove onto the side walk, and hit the fence of Coletti-Magni Park and damaged much of it. MV1 then came at rest on top of the Coletti-Magni Park fence and sustained extensive damage. MV1 operator stated he was not injured at this time and sign a patient refusal with Newton Medics. MV2 was unoccupied. Both MV1 and MV2 were towed by Todys.
Keywords:
Fire, Severe, Walk
Dcc:
Lane departure, Reckless driving
Report url:
report
Image url:
image
Latitude:
42.3604294
Longitude:
-71.20168
Location:
Bridge St & Watertown 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);