crash_reports
2 rows where "datetime" is on date 2019-12-09 and dcc contains "Visibility obstructed"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), dcc (array)
Case
number:
Date:
2019-12-09
Time:
07:53
Address:
1659 COMMONWEALTH AVE
Speed
limit:
30
Violation
cited:
no
Narrative:
On 12/9/2019 at approx 0753hrs while assigned to 497 I responded to the area of Commonwealth Av and Temple St for a report of a 2 car collision w/o injury. Upon arrival I observed Ma Reg 692NB8 pulled to the side with flashers on in front of 1650 Commonwealth Av. i spoke with the operator Kai CHEN who stated he was stopped in traffic in front of 1650 Commonwealth Av when the white mini van Ma Reg 7ZB211 backed out of the driveway at 1650 Commonwealth Av striking his car. I spoke with the operator of the mini van , James MURPHY who stated he was backing out of the driveway and did not see CHEN colliding with his car.
Keywords:
[]
Dcc:
Visibility obstructed
Report
url:
Image
url:
Latitude:
42.3397226
Longitude:
-71.2348182
Location:
Case
number:
Date:
2019-12-09
Time:
07:58
Address:
PERKINS ST & WASHINGTON ST
Speed
limit:
30
Violation
cited:
no
Narrative:
The operator of MV1 (MA Reg: 7PS492) stated that he was travelling eastbound on Washington St in the right lane. MV1 stated that as he approached the intersection of Washington and Perkins St, he was cut off by MV2. The operator of MV1 stated MV2 came from his left and he had no time to stop. MV1 stated that he had a green light. The operator of MV2 (MA Reg:429SH8) stated that they were on Washington St over the Mass Pike attempting to turn left onto Washington St. MV2 stated that two lanes of traffic had stopped and waved them on. MV2 stated that they did not see MV1 in the far lane and pulled out into their lane. MV2 stated that they had green light when they attempted to turn. MV1 sustained front end damage. MV2 sustained passenger side damage. All parties were evaluated by medics and signed a patient refusal. MV2 was towed by Tody's towing.
Keywords:
[]
Dcc:
Visibility obstructed
Report
url:
Image
url:
Latitude:
42.3466651
Longitude:
-71.2319942
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);