crash_reports
1 row where "date" is on date 2021-03-17 and speed_limit = 40
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), dcc (array)
Case
number:
Date:
2021-03-17
Time:
17:39
Address:
721 WASHINGTON ST
Speed
limit:
40
Violation
cited:
no
Narrative:
MV1 was traveling WESTBOUND on Washington St in the middle westbound lane when it was struck by MV2 exiting a parking lot. MV1 was t-boned on its passenger side by MV2. MV1 sustained heavy damage to its passenger door and rear passenger wheel, deeming it unsafe to drive. MV2 was exiting the parking lot of 723 Washington St, did not see MV1 coming and struck the vehicle, damaging his driver's side front. No injuries reported. Tody's towed MV1.
Keywords:
[]
Dcc:
Failed to yield
Report
url:
Image
url:
Latitude:
42.3527483
Longitude:
-71.2031248
Location:
Advanced export
JSON shape: default, array, newline-delimited, object
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);