crash_reports
2 rows where dcc contains "Too fast for conditions" and longitude = "-71.1727828"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-02-21
Time:
08:35
Address:
BEACON ST & HAMMOND ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Oper of Veh # 1 stated he was going WB on Beacon Street and wasn't able to stop at red light due to the icy roads. He struck Veh # 2 in the middle of the intersection. Oper of Veh 2 stated she had a green light when she was going through intersection and saw veh # 1 go through intersection and hit her. Veh # 1 had a plow equipped was unable to put that in diagram. No Injuries, No Tows
Keywords:
Ice
Dcc:
Too fast for conditions
Report
url:
Image
url:
Latitude:
42.3328654
Longitude:
-71.1727828
Location:
Case
number:
Date:
2020-01-18
Time:
22:25
Address:
BEACON ST & HAMMOND ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Vehicle #1 stated they were stopped at the traffic lights on beacon st facing westbound when they were struck in the rear by Vehicle #2. Vehicle #2 stated they were traveling westbound on beacon st and attempted to stop for the red light. Vehicle #2 stated they started to slide due to the snow and was unable to stop and struck Vehicle #1 in the rear. Vehicle #1 had major damage to the rear and was unable to be driven. Vehicle #2 had major damage to the front and was unable to be driven. Both vehicle were towed away by tody's towing. Both operators and passenger were asked if they were injured and all parties stated they were not injured and refused any medical treatment.
Keywords:
Snow
Dcc:
Too fast for conditions
Report
url:
Image
url:
Latitude:
42.3328654
Longitude:
-71.1727828
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);