crash_reports
4 rows where "datetime" is on date 2021-09-24 and intersection = 0
This data as json, CSV (advanced)
Suggested facets: violation_cited, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-09-24
Time:
10:25
Address:
860 WALNUT ST
Speed
limit:
25
Violation
cited:
yes
Narrative:
Mv#1 came to a stop on Walnut St S/B opposite #860 before reaching the Walgreen's driveway opening to allow a Mv to exit the parking lot. At that time, Mv#2 was travelling behind #1 and rear ended #1. No injuries. #2 front end tow hitch struck #1 rear end causing light rear end two hitch impression damage. #2 operator was determined to be unlicensed. #2 issued citation #T2080653 for C.O. 19/71 Following too close and 90/10 Unlicensed Operation.
Keywords:
Citation
Dcc:
Followed too closely
Report
url:
Image
url:
Latitude:
42.3318259
Longitude:
-71.2070233
Location:
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:
Case
number:
Date:
2021-09-24
Time:
21:51
Address:
28 AUSTIN ST
Speed
limit:
15
Violation
cited:
no
Narrative:
The operator of MV1 stated as she was pulling out of the parking garage at 28 Austin Street she struck MV2 while it was parked in a parking spot. The operator of MV1 was involved in a domestic during this accident with the operator of MV2. After striking MV2 the operator drove out of the parking garage to the NPD to report the incident. MV1 sustained minor damage to the driver side front head light. The operator of MV2 and the vehicle have not been found and spoken too in regards to the accident, unknown damage at this time.
Keywords:
Crash
Dcc:
Emotional
Report
url:
Image
url:
Latitude:
42.3500754
Longitude:
-71.2082101
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);