crash_reports
1 row where "datetime" is on date 2020-01-19 and keywords contains "Ice"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array)
Case
number:
Date:
2020-01-19
Time:
07:33
Address:
CRAFTS ST & WALTHAM ST
Speed
limit:
30
Violation
cited:
no
Narrative:
ON 1-19-2020 AT APPROX. 0733HRS. WHILE WORKING N492 I TOOK A REPORT FOR MOTOR VEHICLE ACCIDENT. UPON ARRIVAL AT THE INTERSECTION OF WALTHAM ST AND CRAFT ST. I SPOKE TO THE OPERATOR OF VEHICLE #1. DRIVER STATES SHE WAS TRAVELING S-BOUND ON WALTHAM HEADING ONTO CRAFT. SHE STATES AT THE INTERSECTION SHE SLID ON THE ICY SURFACE AND WAS UNABLE TO REGAIN CONTROL OF HER VEHICLE. HER VEHICLE SLIPPED INTO A UTILITY POLE ON THE ISLAND AT THE INTERSECTION OF CRAFT AND WALTHAM. I CHECKED THE AREA WHERE SHE STATED SHE BEGAN HER SLIDE AND IT WAS SLIPPERY FROM THE COMBINATION O F FALLING SNOW AND FREEZING TEMPERATURE. VEHICLE #1 HAD EXTENSIVE FRONT END DAMAGE, A FLAT RIGHT FRONT TIRE, AND AIRBAG DEPLOYMENT. VEHICLE #1 WAS TOWED BY TODYS. OPERATOR OF VEHICLE #1 REPORTED NO INJURIES AND SIGNED A PATIENT REFUSAL. DRIVER ADVISED TO CONTACT HER INSURANCE COMPANY. CLEARED AREA WITHOUT FURTHER INCIDENT.
Keywords:
Airbag, Crash, Ice, Severe, Snow
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3602838
Longitude:
-71.2220498
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);