crash_reports

1 row where keywords = "["Fatal"]", keywords contains "Fatal" and "retrieved" is on date 2022-05-31

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: datetime (date), date (date), retrieved (date), keywords (array)

case_number ▼	date	time	address	speed_limit	violation_cited	narrative	keywords	dcc	report_url	image_url	latitude	longitude

Case number:

22000442

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:

report

Image url:

image

Latitude:

42.2999309

Longitude:

-71.2079747

Location:

455 Nahanton St, Newton, MA 02459, USA

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);