crash_reports
2 rows where dcc contains "Unknown" and dcc_code = "[11, 99]"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2020-06-17
Time:
19:00
Address:
COPLEY ST & WASHINGTON ST
Speed
limit:
30
Violation
cited:
no
Narrative:
MV1 stated he was travelling straight on Washington St when MV2 "pulled out from the side street into my lane so I swerved to avoid him, hit the crosswalk sign and scratched my side mirror." MV2 stated he was stopped at the stop sign on Copley St to allow pedestrians to cross and never pulled out onto Washington St until after MV1 passed and had nothing to do with the collision. No tows required or injuries reported.
Keywords:
Crosswalk, Ped
Dcc:
Swerving, Unknown
Report
url:
Image
url:
Latitude:
42.3547671
Longitude:
-71.1769439
Location:
Case
number:
Date:
2021-01-26
Time:
20:08
Address:
BEACON ST & WASHINGTON ST
Speed
limit:
25
Violation
cited:
no
Narrative:
MV#1 Was traveling straight on Washington St when he lost control of the vehicle at the intersection of Beacon St and Washington St and struck the utility pole. OPMV#1 Stated he lost control of his vehicle while making the turn and collided with the utility pole. Vehicle was towed by Tody's Towing. Verizon utility pole with minor damage to the base of the pole.
Keywords:
[]
Dcc:
Swerving, Unknown
Report
url:
Image
url:
Latitude:
42.3300068
Longitude:
-71.2484874
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);