crash_reports
1 row where "datetime" is on date 2021-06-18 and intersection = 0
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), dcc (array)
Case
number:
Date:
2021-06-18
Time:
15:24
Address:
1121 WASHINGTON ST
Speed
limit:
35
Violation
cited:
no
Narrative:
Operator 1 of MV 1 was traveling W/B on Washington St when a vehicle in the right lane was stopped. Operator 1 continued in their lane when MV2 drove across the right lane into the left lane (closest to the double yellow line) to attempt a turn left (E/B) on Washington St. MV 1 could not stop in time and collided with MV2. Mv1 had major damage to the front of the vehicle and it was towed by Todys towing. No injuries to Operator 1 or Passenger 1. Operator 2 of MV 2 was pulling out of the parking lot at 1121 Washington St. A vehicle had stopped to allow her to turn left (e/b) onto Washington st. Operator 2 did not see MV 1 traveling in the left lane ( w/b on Washington St) lane and collided with their vehicle. Major damage to MV2 and it was towed by todys towing. No injuries to Operator 2.
Keywords:
[]
Dcc:
Failed to yield
Report
url:
Image
url:
Latitude:
42.3498471
Longitude:
-71.2194379
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);