crash_reports
2 rows where date = "2019-06-26" and dcc contains "Visibility obstructed"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-06-26
Time:
16:26
Address:
CENTRE ST & HYDE ST
Speed
limit:
25
Violation
cited:
no
Narrative:
MV#1 was traveling north on Centre St. MV#2 was attempting to merge north onto Centre St from east on Hyde St. MV#2 pulled too far into the oncoming lane of traffic causing MV#1 to crash into her. Operator of MV#1 stated he was traveling north on Centre St, and did not see MV#2 until it was to late. Operator of MV#1 stated that he was not able to stop in time and crashed into MV#2. Operator of MV#2 stated that as she was attempting to merge north on Centre St, she was pulling out slowly in an attempt to view the oncoming traffic. Operator of MV#2 stated that she might have pulled to far out, which is why MV#1 struck her. MV#1 was driven off scene, MV#2 was towed away by AAA No injuries occurred.
Keywords:
Crash
Dcc:
Visibility obstructed
Report
url:
Image
url:
Latitude:
42.321832
Longitude:
-71.202843
Location:
Case
number:
Date:
2019-06-26
Time:
21:46
Address:
CENTRE ST & WALNUT ST
Speed
limit:
30
Violation
cited:
no
Narrative:
Operator 1 stated he was responding to an emergency call with lights and sirens heading northbound on Center Street. He stopped at the intersection at a red light before proceeding through. He stated he checked both directions and then proceeded ahead and struck the side of vehicle 2. He stated that he did not see vehicle 2. Operator 2 stated that he was heading northbound on Walnut street and had a green light. He stated that he proceeded through the intersection and did not see vehicle 1 and was struck on the drivers side. Photos taken by Officer Brooks of both vehicles
Keywords:
Pictures
Dcc:
Visibility obstructed
Report
url:
Image
url:
Latitude:
42.3204602
Longitude:
-71.2050785
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);