crash_reports
1 row where "date" is on date 2019-02-01 and dcc = "["Failed to yield", "Inattention"]"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-02-01
Time:
20:12
Address:
ELIOT AVE & WATERTOWN ST
Speed
limit:
30
Violation
cited:
no
Narrative:
MV#1 Stated while traveling Westbound on Watertown St at the intersection of Eliot Ave his vehicle was struck on the driver side by MV#2. MV#1 stated MV#2 was attempting to cross Watertown St from Eddy St when MV#2 entered his lane of travel.MV#1 had heavy front and driver side damage following the collision. MV#2 Stated while traveling Northbound on Eddy St she attempted to cross Watertown St and on to Eliot Ave. MV#2 stated MV#1 had dim headlights and appeared to be traveling at a high rate of speed. MV#2 stated the front passenger side of her vehicle struck MV#1 on the driver side. Both MV#1 and MV#2 were towed from the scene due to heavy damage to both vehicles. All parties signed a medical refusal on scene and stated the were not injured at this time.
Keywords:
Speed
Dcc:
Failed to yield, Inattention
Report
url:
Image
url:
Latitude:
42.3526115
Longitude:
-71.217724
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);