crash_reports
2 rows where keywords contains "Distracted" and "retrieved" is on date 2022-06-14
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2022-05-13
Time:
14:00
Address:
CHERRY ST & WASHINGTON ST
Speed
limit:
25
Violation
cited:
no
Narrative:
The operator of MV#1 stated he was stopped facing eastbound at the stop light on Washington St. by Cherry St. The operator of MV#2 stated she became distracted looking at the vehicle in he rearview mirror as she approached the stop light on Washington St. by Cherry St. Operator of MV#2's inattention caused MV#2 to rear end MV#1. Damage to both vehicles consistent with a rear end collision. No injuries reported and no tows needed.
Keywords:
Distracted
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3490417
Longitude:
-71.2281633
Location:
Case
number:
Date:
2022-06-06
Time:
19:45
Address:
60 HIGHLAND ST
Speed
limit:
25
Violation
cited:
no
Narrative:
The operator of MV#1 stated he was traveling northbound on Highland St. when he became distracted attempting to locate the street sign to input into his GPS. The driver's lack of attention to the roadway resulted in his vehicle rear ending MV#2 (unoccupied) which was parked facing northbound in front of 60 Highland St. MV#1 then continued into the parking lot of 60 Highland St. MV#1 sustained heavy front end damage including deployment of both front and side airbags. The operator of MV#1 was later transported to the hospital and his vehicle towed from the scene. MV#2 which sustained a flat rear tire and apparent damage to its axle was also towed from the scene, as it was obstructing the flow of traffic. Attempts to make contact with the owner of MV#2, were unsuccesfull.
Keywords:
Airbag, Distracted, Hospital
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3473066
Longitude:
-71.2259351
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);