crash_reports
1 row where dcc contains "Visibility obstructed" and latitude = "42.321832"
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:
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);