crash_reports
1 row where dcc = "["Inattention"]", intersection = 0 and "retrieved" is on date 2021-11-19
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-11-11
Time:
11:21
Address:
76 NEEDHAM ST
Speed
limit:
5
Violation
cited:
no
Narrative:
MV#1 was parked legally in a spot in the driveway of 76 Needham St. A large tractor trailer truck was parked in the parking lot. The truck driver (Safety Kleen Systems) waved to Operator #2 signaling it was safe for her to back up. Operator #2 then backed up into parked MV#1. MV#1 suffered minor damage to the back left and side. MV#2 suffered minor damage to the back left and side as well. The truck driver left the scene prior to my arrival. No injuries reported. Both vehicles were driven from the scene. I spoke with an employee of Needham St Cleaners. She did not have any further information about the truck other than a corporate phone number for Safety Kleen Systems 800-669-5740 out of Texas. She did not witness the accident.
Keywords:
Crash, Phone
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3146837
Longitude:
-71.2106897
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);