crash_reports
2 rows where dcc contains "Unknown", keywords contains "Solar" and speed_limit = 10
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-11-19
Time:
16:22
Address:
978 BOYLSTON ST
Speed
limit:
10
Violation
cited:
yes
Narrative:
MV1 operator states she was pulling out of the Sunoco gas station when MV2 began backing up and struck the front driver side door of MV1. I observed damage to MV1 driver side door. MV2 operator states he was going to pull onto Rt.9 but due to size of vehicle, needed to back up to create more space. While backing vehicle, MV2 struck MV1. No injuries reported on scene. No tows needed. Operator of MV2, Luciano Pinheiro was cited for Unlicensed Operation c90s10. See incident report 21048567. A complaint app was filed and submitted. The parking lot is a location in which the public has access as invitees.
Keywords:
Citation, Solar
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3181167
Longitude:
-71.211237
Location:
Case
number:
Date:
2022-01-02
Time:
10:54
Address:
1210 CHESTNUT ST
Speed
limit:
10
Violation
cited:
no
Narrative:
On Sunday 1/2/22 at approximately 1054 hours while assigned to marked unit n498 I was dispatched to the area of 1210 Chestnut Street for a report of a past Hit and Run. Upon arrival I spoke with the damaged vehicle's owner, ODVARKA Joseph, who states last night he parked his vehicle around 4:30pm in his parking spot that runs along a fence bordering the parking lot of Brickfire Pizza and Allstar Liquors (1214 - 1220 Chestnut Street). ODVARKA states between the hours of 4:30pm and 8:30pm last night someone struck the fence on the other side causing it to buckle and do damage to the passenger side of ODVARKA's vehicle. After speaking with ODVARKA I canvassed the area and noticed surveillance cameras at Brickfire Pizza and All Star Liquors. The owner of Brickfire states to the camera only captures footage from the front door and inside the establishment. The owner of All Star Liquor states his cameras only capture footage from the front of the store and the inside and the cameras are real time only and do not record. Businesses across the street were not open and I did not observe any external cameras.
Keywords:
Bus, Night, Solar
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3094396
Longitude:
-71.2213944
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);