crash_reports
1 row where "datetime" is on date 2019-05-11, dcc = "["Failed to yield"]" and intersection = 0
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-05-11
Time:
17:36
Address:
780 BEACON ST
Speed
limit:
30
Violation
cited:
no
Narrative:
Vehicle #1 stated they were traveling east bound on Beacon St. and was attempting to continue through the intersection of Langley Rd. with a green light. Vehicle #1 stated he was struck on the right side by Vehicle #2. Vehicle #2 stated they were pulling out of 780 Beacon St. and was attempting to turn left. When turning they saw Vehicle #1 drive by and was un able to stop in time and struck Vehicle #1 in the side passenger door. Vehicle #1 had moderate damage to the right side of the vehicle and was able to be driven away. Vehicle #2 had moderate damage to the front of the vehicle and was able to be driven away. Both operators were asked if they were injured which they stated they were not hurt and refused any medical evaluation.
Keywords:
Moderate
Dcc:
Failed to yield
Report
url:
Image
url:
Latitude:
42.3301182
Longitude:
-71.1928911
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);