crash_reports
1 row where "datetime" is on date 2021-06-22, intersection = 0 and keywords contains "Citation"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-06-22
Time:
15:06
Address:
130 NEEDHAM ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Veh #1 was traveling due West on Needham St. when veh #2 pulled out of #141 Needham St attempting to take a left and collided with veh #1. Veh #2 traveled into #130 Needham St window, Loyal Companion. Both air bags went off on veh #2 and both drivers were checked out by Medics and both signed patent refusals. Operator of veh #2 had a rash on her forearm from the airbag. Both vehicles were towed by Todys (David). Building Inspector Paul Nelson from the City of Newton came down on scene and stated that the damage to the building (#130 Needham St.) didn't effect the structural integrity. The operator of veh#2 admitted to hitting the gas instead of the brake. Operator of veh #2 cited in hand Mass. #T2080855 N.C.O.-Failure to use care in starting. I went inside Loyal Companion and spoke with Manager Micheal Wade. Wade stated no pets were hurt during the accident and he had already notified the buildindgs mainternece company to repsonde and board up the windows.
Keywords:
Airbag, Citation, Crash
Dcc:
Failed to yield
Report
url:
Image
url:
Latitude:
42.3130364
Longitude:
-71.2118267
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);