crash_reports
1 row where "datetime" is on date 2020-10-28, dcc = "["Improper turn"]" and "retrieved" is on date 2020-12-27
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2020-10-28
Time:
09:00
Address:
24 MAGUIRE CT
Speed
limit:
20
Violation
cited:
yes
Narrative:
On Wednesday October 28, 2020 at approx. 0900 I responded to 24 Maguire Court for a report of a crash with property damage involving a tractor trailer. Upon arrival I met with the operator of the tractor trailer Mr. Williams, he stated he was traveling on Maguire Court delivering equipment to a local business, and while turning into the business parking lot he misjudged the turn and the trailer struck a fence,posts,wall belonging to 24 Maguire Court. I advised the owners son who was on the property of the crash and advised I would have a report. There were no reported injuries and all parties advised of the process. I also conducted a Level one inspection on the truck/trailer. The following below is a list of violations and citations VIOLATIONS C.O. 19-75 FAILURE TO USE CARE IN TURNING 393.47D INSUFFICIENT BRAKE LINING- AXLE 5 RIGHT SIDE BRAKE LINING HAS APPROX. 3 INCH CRACK IN LENGTH. CITATIONS T2016068 C.O. 19-75 FAILURE TO USE CARE IN TURNING $ 20.00 T201069 CHAPTER 90 SECTION 7 BRAKE VIOLATION $ 40.00 All paperwork/inspections/citations were issued to the operator and advised of the process.
Keywords:
Bus, Citation, Crash
Dcc:
Improper turn
Report
url:
Image
url:
Latitude:
42.3544895
Longitude:
-71.2026607
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);