crash_reports
3 rows where "retrieved" is on date 2022-07-26 and speed_limit = 15
This data as json, CSV (advanced)
Suggested facets: hit_run, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2022-06-25
Time:
16:57
Address:
71 NEEDHAM ST
Speed
limit:
15
Violation
cited:
no
Narrative:
MV1 operator states she was inside of 71 Needham St with MV1 parked in the back parking lot around 1700 hours. When she came out, she saw that her vehicle had been hit in the front left of her bumper. I observed fresh light damage to MV1s front left bumper. No security cameras were in view of the incident. No tows or injuries reported.
Keywords:
[]
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3151251
Longitude:
-71.2109914
Location:
Case
number:
Date:
2022-07-07
Time:
13:48
Address:
1000 COMMONWEALTH AVE
Speed
limit:
15
Violation
cited:
no
Narrative:
The operator of MV#1 stated he was travelling southbound at the entrance of 1000 Commonwealth Ave when MV#2 pulled out of her parking spot and struck him. MV#1 sustained moderate damages to its passenger side front and rear door area. There were no reported injuries to the operator of MV#1 or its passengers. The operator of MV#2 stated she was attempting to pull out of her parking spot and did not see MV#1 when she struck it. MV#2 sustained moderate damage to its driver's side front bumper. There were no reported injuries to the operator of MV#2.
Keywords:
Moderate
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3374309
Longitude:
-71.2088565
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);