crash_reports
1 row where "datetime" is on date 2019-06-12, intersection = 0 and keywords contains "Glare"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-06-12
Time:
18:50
Address:
865 BEACON ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Vehicle #1 stated they were attempting to turn around on beacon St. and turned into the driveway at 865 Beacon St. Vehicle #1 stated they were reversing out into the road and was stopped and shifting into drive when they were struck from the rear by Vehicle #2. Vehicle #2 stated she was traveling westbound on Beacon St. when she lost sight in front of her due to the glare from the sun. Vehicle #2 stated she never saw Vehicle #1 until she struck the vehicle. Vehicle #1 had minor damage to the rear and was able to be driven away. Vehicle #2 had moderate damage to the front and was towed by Tody's Towing. Operator of Vehicle #1 stated she was not hurt in the crash and refused any medical treatment. Operator of Vehicle #2 stated she had chest pain and was evaluated by Medic 1. Operator of Vehicle #2 was cleared by the medics and refused any further treatment.
Keywords:
Crash, Glare, Moderate, Solar
Dcc:
Glare, Unknown
Report
url:
Image
url:
Latitude:
42.3304808
Longitude:
-71.1966736
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);