crash_reports
2 rows where "datetime" is on date 2019-07-29, dcc = "["Inattention"]" and keywords contains "Moderate"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-07-29
Time:
11:13
Address:
138 NEEDHAM ST
Speed
limit:
15
Violation
cited:
no
Narrative:
On 07/29/19 at 11:13 hours, I responded to the Dunkin Donuts parking lot located at 138 Needham Street for a three car motor vehicle accident. Operator of MV1 stated at first she could not recall what occurred during the accident due to lightheadedness at the time. After, she then stated after pulling in to the Dunkin Donuts lot she was attempting to back in to a parking spot in the back of the lot. While backing up, she attempted to hit the brake pedal but must have pushed the gas pedal instead. The vehicle then struck parked/unoccupied MV2 and MV2 was then pushed in to parked/unoccupied MV3. The operator was checked out by Cataldo Ambulance and signed a patient refusal. MV1 sustained moderate driver's side rear bumper area damage but it was still driveable. MV2 sustained damage along both sides of the vehicle and a rear broken axle and it was towed by Tody's. MV3 sustained scrapes and dents to the entire driver's side but the vehicle was driveable.
Keywords:
Crash, Ems, Moderate
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3128381
Longitude:
-71.212082
Location:
Case
number:
Date:
2019-07-29
Time:
18:08
Address:
212 SUMNER ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Operator of MV1 stated she was traveling Westbound on Beacon St. then turned Northbound onto Sumner St. Operator of MV1 then stated as she turned onto Sumner St. MV2 collided with her vehicle in front of 212 Sumner St. Operator of MV2 stated he was attempting to turn out of his parking spot in front of 212 Sumner St. when he stated he looked, waited for a vehicle to pass him then proceeded to nose out into Sumner St. but observed MV1 at the last second and collided with MV1. No injuries. MV1 sustained moderate front and rear passenger door damage. MV2 sustained moderate left front end damage. No vehicles towed.
Keywords:
Moderate
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.330882
Longitude:
-71.1920797
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);