crash_reports
2 rows where "datetime" is on date 2019-04-23 and dcc contains "Inattention"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-04-23
Time:
09:02
Address:
27 WALNUT ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Operator of vehicle one stated that while stopped in traffic north bound on Walnut St near number 27 her vehicle was rear ended by vehicle one. Operator of vehicle two stated that while driving north bound on Walnut St near number 27 his foot came off the clutch pedal causing his vehicle to rear end vehicle one. Neither vehicle had damage and both vehicles did not require tows. Neither operator stated that they were injured. I took photos of both vehicles and forward the disk to the NPD's IT bureau. I cited the operator of vehicle two for a violation of City of Newton Ordnance 19/71 , following to close. Walnut St is a public way in the city of Newton.
Keywords:
Citation, Pictures
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3582882
Longitude:
-71.2117107
Location:
Case
number:
Date:
2019-04-23
Time:
21:26
Address:
38 TANGLEWOOD RD
Speed
limit:
25
Violation
cited:
no
Narrative:
MV#1 was parked on the side of the road, in front of 38 Tanglewood Rd. MV#2 was traveling east on Tanglewood Rd, and turning North, continuing on Tanglewood Rd. MV#2 crashed into MV#1. Owner of MV#1 stated that she was not in the vehicle at the time. She stated that the operator of MV#2 came and found her to tell her that she had crashed into her. Operator of MV#2 stated that she was turning from east to north on Tanglewood Rd. Operator MV#2 stated that she did not see MV#1 parked on the side of the road, and crashed into it. MV#1 was towed by AAA. MV#2 was driven off scene. No injuries occurred.
Keywords:
Crash
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3171514
Longitude:
-71.1813173
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);