crash_reports
2 rows where address = "NAHANTON ST & WELLS AVE" and "date" is on date 2019-11-22
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-11-22
Time:
08:09
Address:
NAHANTON ST & WELLS AVE
Speed
limit:
25
Violation
cited:
no
Narrative:
The operator of Veh#1 was traveling North on Nahanton St. when he was stopped and was preparing to take a right onto Wells Ave. Veh #2 then struck him in the rear. Heavy damage to Veh#1 and the operator was transported to N.W.H. due to complaint of neck and back pain. The rear passenger of Veh#1 was checked out and cleared by Medics. The operator of Veh#2 stated he was traveling due North on Nahanton St. when he looked down far a second and Veh#1 had stopped. Operator of Veh#2 stated he didn't have time to stop and struck the rear of Veh #1. The airbag disabled light came on his vehicle so this vehicle along with Veh#1 was towed by Tody's Towing. The operator of Veh#2 was cited in hand Mass# T2079214 for N.C.O. 19/75-Failure to use care in stopping.
Keywords:
Airbag, Citation
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.2971091
Longitude:
-71.2040054
Location:
Case
number:
Date:
2019-11-22
Time:
09:46
Address:
NAHANTON ST & WELLS AVE
Speed
limit:
24
Violation
cited:
no
Narrative:
Carl Massicotte was operating vehicle #2, stopped on Wells Ave at the Nahanton St red light. Carl states that he was struck from behind by vehicle #1. Salvador Gonzalez was operating vehicle #1. Carl states that he went to pick up an item off the floor and rolled into the back of vehicle #2. No injuries no tows.
Keywords:
[]
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.2971091
Longitude:
-71.2040054
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);