crash_reports
2 rows where dcc = "[]", intersection = 0 and keywords contains "Fatal"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array)
Case
number:
Date:
2020-11-12
Time:
17:45
Address:
210 NAHANTON ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On Thursday 11/12/20 at approximately 1745 hours while working marked unit n499 I was dispatched to the area of 210 Nahanton Street for a report of a vehicle striking a deer. Upon arrival I observed a deceased deer in the breakdown lane of the westbound side of Nahanton Street diagonally across from 210 Nahanton Street. Parked in the entrance to 210 Nahanton Street was a Hyundai Sante Fe bearing Mass registration 7HZ286 operated by NATHANSON Lucas. Lucas stated to me he was travelling eastbound on Nahanton Street when a deer came on to the road from the woods on the westbound side of the road. he states the deer ran in front of his vehicle causing him to strike the deer. The collision caused damage to the front drivers side of the vehicle as well as to the hood. Lucas was uninjured, however the deer was deceased. The deer was removed from the road by a good Samaritan.
Keywords:
Fatal
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.2967953
Longitude:
-71.1969289
Location:
Case
number:
Date:
2022-05-24
Time:
08:39
Address:
455 NAHANTON ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On Tuesday 5/24/22 at approximately 0839 hours while assigned to marked unit n498 I was dispatched to the area of 455 Nahanton Street for a car that struck a deer. Upon arrival I spoke with the operator, PAUL Gelny, of motor vehicle #1 (1YJV68), who states he was travelling eastbound on Nahanton Street. PAUL further states while travelling eastbound a deer ran in front of his vehicle from the woods on the westbound side of Nahanton Street near the entrance to 455 causing him to strike the deer. Deer was deceased and laying in the shoulder of the road. Newton Dispatch notified the city to pick up the deceased deer. Deer strike cause damage to the front of PAUL's vehicle.
Keywords:
Fatal
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.2999309
Longitude:
-71.2079747
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);