crash_reports
2 rows where "datetime" is on date 2020-01-22 and dcc contains "Inattention"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2020-01-22
Time:
10:15
Address:
20 VINE ST
Speed
limit:
30
Violation
cited:
no
Narrative:
Owner of vehicle #1 stated her vehicle was parked in front of 20 Vine St. Vehicle #1 was unoccupied when it was struck by an unknown vehicle that left the scene.
Keywords:
[]
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3041129
Longitude:
-71.1749756
Location:
Case
number:
Date:
2020-01-22
Time:
10:09
Address:
2040 COMMONWEALTH AVE
Speed
limit:
25
Violation
cited:
no
Narrative:
Operator of vehicle 1 stated she was parked in a parking spot when vehicle 2 started pulling headfirst in the spot on her drivers side. As vehicle 2 pulled in it made contact with vehicle 1 and operator 1 sounded her horn and tried to notify the other operator. Operator of vehicle 1 stated she got into a verbal argument with the other operator and then vehicle 2 backed out of the spot and parked on the opposite side of the parking lot. Operator of vehicle 1 walked over and again told the other operator she hit her but again a verbal argument started and operator of vehicle 2 walked away in to the market. I was able to find the operator of vehicle 2 inside of the store and she immediately denied any wrong doing and became argumentative when I tried to speak to her. Vehicle 2 had minor damage to its front passenger side consistent with scrapes on the drivers side of vehicle 1. Operator of vehicle 2 stated her damage was old damage and that it was not scrapes on vehicle 1 but dirt and walked over and tried to rub it off with her hand. I had to advise the operator of vehicle 2 several times to return to her vehicle. I advised both operators that I would document the incident with a report and sent them on their way with no further incident. Neither vehicle required a tow and neither operator reported any injuries.
Keywords:
Walk
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3469722
Longitude:
-71.2448227
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);