crash_reports
2 rows where "datetime" is on date 2021-09-24, dcc contains "Inattention" and intersection = 0
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-09-24
Time:
17:07
Address:
11 COMMONWEALTH AVE
Speed
limit:
30
Violation
cited:
no
Narrative:
MV 1 was parked westbound on Commonwealth Ave in front of 11 Commonwealth Ave when MV 2 side swiped MV 1. The operator of MV 1 was making a delivery to the business at 11 Comm Ave. MV 1 sustained zero damage from the side swipe. The operator of MV 2 was operating westbound on Comm Ave and did not realize how close she was to MV 1. MV 2 sideswiped MV 1 causing moderate damage to the right side of MV 2. Both windows of the passenger side of MV 2 were disabled from the collision. The operator of MV 2 was not injured and signed a patient refusal with Fallon medics. MV 2 was towed by triple A per the owners request.
Keywords:
Bus, Moderate
Dcc:
Followed too closely, Inattention
Report
url:
Image
url:
Latitude:
42.3400585
Longitude:
-71.1672359
Location:
Case
number:
Date:
2021-09-24
Time:
20:21
Address:
29 MELVILLE AVE
Speed
limit:
20
Violation
cited:
no
Narrative:
The owner of Vehicle #1 stated that her parked vehicle was struck by Vehicle #2 as he attempted to back out of his driveway. I observed fresh damage to the rear passenger door as a result of the collision. The operator of Vehicle #2 stated that as he was backing out of his driveway he struck Vehicle #1 with the rear bumper on the passenger side. He stated that there was little to no observed damage to his vehicle. Neither party complained of injury, and both parties exchanged information.
Keywords:
[]
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3615134
Longitude:
-71.2072562
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);