crash_reports
2 rows where "datetime" is on date 2022-04-10, dcc contains "Inattention" and "retrieved" is on date 2022-04-21
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), dcc (array)
Case
number:
Date:
2022-04-10
Time:
12:43
Address:
CENTRE ST & WASHINGTON ST
Speed
limit:
25
Violation
cited:
no
Narrative:
The operator of MV1 stated she was stopped at the corner of Centre street and Washington Street, waiting for it to be safe to merge onto Washington Street. While stopped MV2 attempted to go around and struck the rear driver side of the vehicle. The operator of MV2 stated traffic was clear and while he attempted to merge onto Washington Street, MV1 stopped and he struck MV1. All parties involved were not injured. MV1 had damage to the rear bumper. MV2 had damage to the front passenger side head light and side.
Keywords:
[]
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3557988
Longitude:
-71.1865324
Location:
Case
number:
Date:
2022-04-10
Time:
15:47
Address:
246 CALIFORNIA ST
Speed
limit:
25
Violation
cited:
no
Narrative:
MV#1 Was Eastbound on California St when he collided with MV#2 & MV#3 that were parked facing Eastbound. OPMV#1 Stated he doesn't know what happened and he possibly fell asleep as he was driving. No injuries. MV#1 & MV#3 were towed by Todys Towing. Uninvolved vehicle owners were notified on scene.
Keywords:
[]
Dcc:
Inattention, Fatigue/Sleep
Report
url:
Image
url:
Latitude:
42.3646329
Longitude:
-71.1985301
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);