crash_reports
2 rows where dcc contains "Swerving" and keywords contains "Ped"
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-02-16
Time:
22:45
Address:
241 CHURCH ST
Speed
limit:
25
Violation
cited:
no
Narrative:
The operator of Vehicle #1 stated that she slid into the fence at 234 Church St as she attempted to navigate the bend in the road. The collision damaged a fence at 234 Church St, as well as a crosswalk sign at the intersection of Church St, and Oakland St. The sign and fence were moved to the side of the pedestrian way as best as it could, and the city was notified to remove the debris. The owner of the property, Mr. Steven Carter, was made aware. The vehicle sustained front end damage. The operator declined medical attention when it was offered.
Keywords:
Crosswalk, Ped
Dcc:
Swerving
Report
url:
Image
url:
Latitude:
42.3549706
Longitude:
-71.1891781
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);