crash_reports
2 rows where dcc = "["Visibility obstructed"]" and "retrieved" is on date 2021-11-16
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-11-05
Time:
09:13
Address:
CENTRE ST & COMMONWEALTH AVE
Speed
limit:
30
Violation
cited:
no
Narrative:
THE OPERATOR OF MV#1 STATED HE WAS TRAVELING WEST-BOUND ON COMMONWEALTH AVE WITH A GREEN LIGHT WHEN HE STRUCK MV#2. THE OPERATOR OF MV#2 STATED HE WAS TRAVELING NORTH-BOUND ON CENTRE STREET, GOT STUCK IN THE INTERSECTION, OBSTRUCTED BY SOME TYPE OF BUS, WHEN HE STRUCK MV#1. BOTH OPERATORS HAD NO INJURIES. MV#1 HAD DAMAGE TO THE D/S FRONT AND MV#2 HAD DAMAGE TO THE P/S FRONT. MV#2 WAS TOWED BY TODYS TOWING. THERE WAS NO AIRBAG DEPLOYMENT. THERE WERE NO INJURIES DUE TO THIS ACCIDENT.
Keywords:
Airbag, Bus, Crash
Dcc:
Visibility obstructed
Report
url:
Image
url:
Latitude:
42.3365124
Longitude:
-71.1932597
Location:
Case
number:
Date:
2021-11-10
Time:
17:19
Address:
BOYLSTON ST & CHESTNUT ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Operator of MV1 states she was traveling northbound on Chestnut St passing under the overpass bridge to Boylston St in congested traffic when MV2 struck MV1 on the drivers side of the vehicle. MV1 sustained damage to the left side corner panel. No injuries. Operator of MV2 states she was traveling eastbound on the short stretch of road between Quinobequin Rd and Chestnut St. Operator of MV2 states when entering the intersection to turn left onto Chestnut St, MV1 appeared coming from under the over pass bridge causing MV2 to collide with MV1. MV2 sustained front end damage and was towed from the scene. No injuries.
Keywords:
[]
Dcc:
Visibility obstructed
Report
url:
Image
url:
Latitude:
42.3169482
Longitude:
-71.2257627
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);