crash_reports
3 rows where dcc = "["Unknown"]", keywords contains "Phone" and "retrieved" is on date 2022-07-26
This data as json, CSV (advanced)
Suggested facets: intersection, hit_run, datetime (date), date (date), retrieved (date)
Case
number:
Date:
2022-05-12
Time:
19:53
Address:
COMMONWEALTH AVE & AUBURN ST
Speed
limit:
10
Violation
cited:
no
Narrative:
The operator of Vehicle 1 states that Vehicle 1 was parked at the airpump in the parking lot behind the Speedway gas station at 2370 Commonwealth Ave when Vehicle 2 backed out of a parking space and made contact with the driver-side rear passenger door of Vehicle 1. The operator of Vehicle 1 tried to make contact with the operator of Vehicle 2 and heard her passenger say something along the lines of "go, go! Get out of here!" Vehicle 2 then drove away. The operator of Vehicle 1 was able to take a picture of Vehicle 2 before it left the area. I observed minor scrapes to the driver side rear quarter panel of Vehicle 1. I contacted the operator of Vehicle 2 by phone who states she was attempting to back out of her parking space but was blocked in by Vehicle 1 and asked the operator of Vehicle 1 to move his car so she could get out. The operator of Vehicle 2 states that the operator of Vehicle 1 told her to try and get out anyway and started putting air in his tires. The operator of Vehicle 2 states that she attempted to back out carefully and didn't feel her vehicle make contact with his vehicle so she left the parking lot. Due to the conflicting statements of the operators I was unable to determine who was at fault.
Keywords:
Phone, Pictures, Speed
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3445236
Longitude:
-71.2586295
Location:
Case
number:
Date:
2022-07-07
Time:
13:30
Address:
10 EMERSON ST
Speed
limit:
25
Violation
cited:
no
Narrative:
The witness to the hit and run stated she was inside and heard a bang. She looked out the window and heard MV1 back into the parked MV2. The witness then ran outside and observed the driver, a white male drive away and turn right onto Boyd Street. There was significant damage to the bumper of MV2. MV2's bumper was completely off. The vehicle involved was a white van with a green stripe. The witness got a phone number off the van, 401-827-8800. The phone number belongs to Liberty Mobility of West Warwick Rhode Island. A male party answered and stated he sold the vehicle years ago and has received multiple calls regarding the vehicle. A plate was not provided. The witness is not the owner of the vehicle, she is a neighbor.
Keywords:
Phone
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
Longitude:
Location:
Case
number:
Date:
2022-07-19
Time:
16:40
Address:
64 ELDREDGE ST
Speed
limit:
15
Violation
cited:
no
Narrative:
LE, Chieu (RI OLN 3218891) reported she was parked in the parking lot of 64 Eldredge St. when her vehicle (MV1 - RI Reg JX720) was struck by a vehicle, causing minor damage to the front right bumper. No tow needed. Accident occurred on 7/12/22 between 1400-1800 hrs. KANODE, Amanda (MA OLN S34810658) is a client and stated via e-mail that she backed into MV1 in the parking lot and thought there was no damage. Registered to KANODE is MA Reg 66P630 (MV2). She left her phone number and I left a voicemail to confirm details.
Keywords:
Crash, Phone
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3535048
Longitude:
-71.1834925
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);