crash_reports
1 row where "datetime" is on date 2019-07-28, dcc = "["Failed to yield"]" 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:
2019-07-28
Time:
12:26
Address:
NEEDHAM ST & TOWER RD
Speed
limit:
25
Violation
cited:
no
Narrative:
On 07/28/19 at approximately 12:26 I responded to a two vehicle crash at the intersection of Needham St and Tower Rd. The operator of veh #1 stated she was driving Southbound on Needham St. when veh #2 pulled out of Tower Rd. from her right and collided with her car. The side airbags went off in veh #1 but the driver stated she wasn't hurt. She was checked out and signed a patient refusal with the Medics. Moderate to heavy damage to veh #1 as it was towed by Tody's towing. The operator of veh#1 has a License and Registration issued by the Department of The State (Brazilian Consulate) and isn't in our in house system to plug into this report. The operator of veh #2 stated she was pulling out of Tower Rd attempting to go left (Northbound) on Needham St. and didn't see veh #1 passing as she turned. Minor damage to veh #2 as the operator was cited in hand Mass. #T1271259 for N.C.O. Failure to Use Care in Turning. All roads traveled/ mentioned in this report are public ways in the City of Newton as they are serviced and maintained by this city.
Keywords:
Airbag, Citation, Crash, Moderate
Dcc:
Failed to yield
Report
url:
Image
url:
Latitude:
42.3107339
Longitude:
-71.2140155
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);