crash_reports
4 rows where "datetime" is on date 2019-01-30 and keywords contains "Ice"
This data as json, CSV (advanced)
Suggested facets: intersection, speed_limit, keywords, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-01-30
Time:
08:41
Address:
BRIDGE ST & WATERTOWN ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Oper of Veh #1 stated he was stopped for stop sign and was struck by vehicle #2. Oper of veh # 2 stated she was traveling SB on Bridge Street and tried to stop but unable to because of the icy conditions. Skidded into a left turn causing her rear end to hit Veh # 1. The road was a sheet of ice and there were multiple accidents in the area. Passenger of veh # 2 was checked by medics and mom signed a refusal.
Keywords:
Crash, Ice
Dcc:
Swerving
Report
url:
Image
url:
Latitude:
42.3604294
Longitude:
-71.20168
Location:
Case
number:
Date:
2019-01-30
Time:
08:50
Address:
CHRISTINA ST & GODDARD ST
Speed
limit:
30
Violation
cited:
no
Narrative:
MV1 was slowing as she approached the stop sign at Christina St. She began sliding due to the icy roads. MV2 began sliding down the road and rear ended MV1. Goddard St was very icy at the time of the MVA.
Keywords:
Ice
Dcc:
Too fast for conditions
Report
url:
Image
url:
Latitude:
42.3047144
Longitude:
-71.2093949
Location:
Case
number:
Date:
2019-01-30
Time:
07:56
Address:
317 CALIFORNIA ST
Speed
limit:
30
Violation
cited:
no
Narrative:
OPERATOR OF MV 1 WAS TRAVELING WEST ON CALIFORNIA STREET WHEN SHE HIT HER BRAKES. DUE TO THE VERY ICY CONDITIONS OF THE ROADWAY MV 2 WAS UNABLE TO BRAKE IN TIME AND STRUCK MV 1 IN THE REAR. MV 3 WHO WAS TRAVELING BEHIND MV 2 WAS UNABLE TO BRAKE IN TIME AND STRUCK MV 2 IN THE REAR. MV 4 WHO WAS TRAVELING BEHIND MV 3 WAS ABLE TO SWERVE AND MISS MV 3 BUT MV 5 WHO WAS BEHIND MV 4 STRUCK HIM FROM THE REAR. NO INJURIES WERE REPORTED AND MODERATE DAMAGE SUSTAINED.
Keywords:
Ice, Moderate
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3652207
Longitude:
-71.2017789
Location:
Case
number:
Date:
2019-01-30
Time:
11:07
Address:
97 BORDER ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Oper of Veh # 1 stated he was driving WB on Border Street and when he attempted to make the turn at the bend in the road he slid on ice into Veh # 2 which was parked. Oper # 1 dislodged his vehicle from veh # 2 and left it parked on the side of the road until he decided if it needed a tow. I located owner of Veh # 2 and at this time it appears there is little to no damage to the front of his vehicle
Keywords:
Ice
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3486126
Longitude:
-71.2331051
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);