crash_reports
1 row where keywords contains "Moderate" and "retrieved" is on date 2022-06-21
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2022-06-14
Time:
17:00
Address:
CENTRE ST & TRINITY TER
Speed
limit:
25
Violation
cited:
no
Narrative:
Vehicle #1 was traveling northbound on Centre St. and in light traffic when she was approaching the stopped cars ahead when she was blinded by the glare coming over the hill. She saw Vehicle #2 too late due to the glare and was unable to stop in time and struck Vehicle #2 in the rear. Vehicle #2 stated he was traveling northbound on Centre St. and was stopped in traffic at the light when he was struck from behind by Vehicle #1. Vehicle #1 had moderate damage to the front of the vehicle and was unable to be driven and was towed away by Tody's towing. Vehicle #2 had minor damage to the rear bumper and was able to be driven. All parties were asked if they were injured in the accident and all stated they were unhurt and refused any medical treatments.
Keywords:
Crash, Glare, Moderate
Dcc:
Glare
Report
url:
Image
url:
Latitude:
42.3347291
Longitude:
-71.1934077
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);