crash_reports
1 row where "datetime" is on date 2022-06-02, dcc contains "Visibility obstructed" and intersection = 1
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), dcc (array)
Case
number:
Date:
2022-06-02
Time:
17:29
Address:
BEACON ST & CRESCENT AVE
Speed
limit:
25
Violation
cited:
no
Narrative:
Operator of MV1 states he was traveling northbound on Crescent Ave approaching the intersection at Beacon Street when he came to a complete stop at the stop sign. Operator of MV1 states he looked both ways on Beacon Street for oncoming traffic and after a motor vehicle passed him traveling eastbound on Beacon Street, he proceeded to cross Beacon Street when he was struck by MV2. The operator of MV1 states his visibility of MV2 was obstructed by the passing vehicle and didn't see MV2 traveling westbound on Beacon Street. MV1 sustained damage to the front right fender and front right passenger door. Tody's towing responded and removed the vehicle from the roadway. No injuries. Operator of MV2 states she was traveling westbound on Beacon Street approaching the intersection at Crescent Ave when MV1 appeared in her lane of travel and she struck MV2 head on. MV1 sustained damage to the front end. No tow required and no injuries.
Keywords:
[]
Dcc:
Visibility obstructed
Report
url:
Image
url:
Latitude:
42.3303911
Longitude:
-71.1980873
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);