crash_reports
2 rows where dcc contains "Visibility obstructed" and latitude = "42.3312062"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-11-09
Time:
18:02
Address:
CENTRE ST & LANGLEY RD
Speed
limit:
25
Violation
cited:
no
Narrative:
MV #1 was traveling soutbound on Centre St. at the intersection of Langley Rd. MV #2 was positioned northbound on Centre. St and was attempting to turn westbound onto Pleasant st. The operator of MV#2 indicated that there was a significant gap in traffic as he was attempting to turn westbound when the operator of MV #1 collided into his vehicle. Damage was observed to both MV#1 and MV#2's front bumpers. The operator of MV#1 stated she could not see MV#2 due to the lighting prior to her colliding into vehicle. Both parties were treated on scene by Cataldo EMS but declined transport to a hospital. Both vehicles were able to be driven away from the scene.
Keywords:
Ems, Hospital
Dcc:
Visibility obstructed
Report
url:
Image
url:
Latitude:
42.3312062
Longitude:
-71.1946329
Location:
Case
number:
Date:
2019-12-02
Time:
10:01
Address:
PELHAM ST & CENTRE ST
Speed
limit:
25
Violation
cited:
no
Narrative:
MV#1 was stopped southbound on Centre St. attempting to turn right (westbound) on Pelham St. MV#2 was behind MV#1 also facing southbound. As MV#2 attempted to pass MV#1 it sideswiped MV#1's front plow. Damage was observed to MV#2's passenger side front bumper. Minor damage was observed to MV#1's snow plow on the driverside. No injuries were reported and both vehicles were driven from the scene.
Keywords:
Snow
Dcc:
Visibility obstructed, Unknown
Report
url:
Image
url:
Latitude:
42.3312062
Longitude:
-71.1946329
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);