crash_reports
1 row where "datetime" is on date 2020-08-18, dcc = "["Inattention", "Unknown"]" and "retrieved" is on date 2020-10-06
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), dcc (array)
Case
number:
Date:
2020-08-18
Time:
14:37
Address:
1365 CENTRE ST
Speed
limit:
30
Violation
cited:
no
Narrative:
Mv#1 operator stated she was travelling straight ahead on Centre St S/B. #1 stated Mv#2 was on Centre St N/B facing her and it appeared to #1 that #2 took a quick left turn into the gas station at 1365 Centre St. #1 acknowledged she struck #2 broadside on the passenger rear door which at the time of the collision, #2 had completed most of its turn. #2 operator stated she was on Centre St N/B and came to a stop waiting for other traffic to clear with her left turn signal on preparing to turn left into the gas station. #2 stated #1 slowed down from the opposite direction allowing #2 to safely turn. #2 stated as she was about to complete the turn, #1 suddenly accelerated and struck her broadside passenger side rear. No injurles. #1 sustained significant front end damage and was towed by AAA. #2 sustained significant passenger side rear door damage and was able to be driven away by the operator.
Keywords:
[]
Dcc:
Inattention, Unknown
Report
url:
Image
url:
Latitude:
42.3275656
Longitude:
-71.1972306
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);