crash_reports
1 row where "datetime" is on date 2019-01-31, keywords contains "Glare" 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-01-31
Time:
08:56
Address:
DEDHAM ST & WALNUT ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On 01/31/19 at 08:56 hours, I responded to Dedham and Walnut Streets for a two car motor vehicle accident with no injuries. Operator of M/V 1 states he was stopped for the stop sign facing northbound on Dedham St towards Walnut St. He then proceeded straight through and observed M/V 2 coming at him so he tried to speed up but M/V 2 ended up striking him on the driver's side rear quarter panel area. He did state that M/V 2 did stop for the stop sign after him but did not understand why they were attempting to come through the intersection. The vehicle sustained minor damage to the driver's side rear quarter panel area and had a flat tire. The operator waited for Triple AAA for the flat. Operator of M/V 2 states she was stopped at the stop sign facing eastbound on Dedham St attempting to take a left turn on to Walnut St. Due to the bright sun and glare, she did not observe M/V 1 coming through the intersection and struck him. The vehicle sustained front end damage to the grille and bumper but the vehicle was still driveable. At the time, I did observe the sun to be blinding at the accident location and there was a lot of glare.
Keywords:
Crash, Glare, Solar, Speed
Dcc:
Glare
Report
url:
Image
url:
Latitude:
42.3141434
Longitude:
-71.2018581
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);