crash_reports
2 rows where dcc_code = "[13]", intersection = 0 and "retrieved" is on date 2020-10-06
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-02-06
Time:
20:01
Address:
153 CONCORD ST
Speed
limit:
25
Violation
cited:
no
Narrative:
The OP. of MV#1 states he was travelling northbound on Concord Street. He is familiar with the road and the medians but due to the rain and the glare it caused with his eye glasses, he miscalculated the curb of the median and struck it.
Keywords:
Glare, Rain
Dcc:
Glare
Report
url:
Image
url:
Latitude:
42.3280043
Longitude:
-71.262188
Location:
Case
number:
Date:
2020-06-19
Time:
08:28
Address:
216 AUSTIN ST
Speed
limit:
30
Violation
cited:
no
Narrative:
ON 6-19-20 AT APPROX. 0828HRS. WHILE WORKING N492 I TOOK A REPORT FOR MOTOR VEHICLE ACCIDENT. UPON ARRIVAL AT 216 AUSTIN ST. I SPOKE TO THE OPERATOR OF VEHICLE #1. DRIVER STATES HE WAS TRAVELING E-BOUND ON AUSTIN ST. WHEN HE WAS BLINDED BY THE GLARE OF THE RISING SUN. DRIVER STATES HE CRASHED INTO VEHICLE #2 WHILE BLINDED. VEHICLE #2 WAS PARKED IN FRONT OF 216 AUSTIN ST. VEHICLE #1 HAD EXTENSIVE FRONT END DAMAGE WITH AIRBAG DEPLOYMENT AND WAS TOWED BY TODYS. VEHICLE #2 HAD LEFT REAR BUMPER DAMAGE BUT WAS STILL OPERATIONAL. DRIVER OF VEHICLE #1 WAS EXAMINED BY MEDICS AND SIGNED A PATIENT REFUSAL. VEHICLE #2 IS OWNED BY A CONSTRUCTION COMPANY BUT NONE OF THE WORKERS WITNESSED THE ACCIDENT. ALL PARTIES WERE ADVISED TO CONTACT THEIR INSURANCE COMPANIES. CLEARED WITHOUT FURTHER INCIDENT.
Keywords:
Airbag, Crash, Glare, Severe, Solar
Dcc:
Glare
Report
url:
Image
url:
Latitude:
42.349191
Longitude:
-71.2167694
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);