home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

2 rows where "datetime" is on date 2022-05-24, intersection = 0 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
Case number:
22000443
Date:
2022-05-24
Time:
17:36
Address:
400 CENTRE ST
Speed limit:
30
Violation cited:
no
Narrative:
Operator of MV1 (MA reg BC7929) stated he was traveling EB on Centre Ave across from 400 Centre St when a vehicle in the far left lane attempted to enter his lane. Operator of MV1 stated the other vehicle sped up and upon entering his lane struck the front driver's side panel with the rear passenger side quarter panel. Operator of MV2 (MA reg 2ECX23) stated he was traveling EB on Centre Ave on the far left lane when attempted to enter in the lane to his immediate right. Operator of MV2 stated he noticed a space to safely enter the lane but when he attempted to enter the operator of MV1 sped up and struck his rear passenger side quarter panel. Both vehicles had minor damage mostly paint exchange. Both driver's stated they were not injured and did not require medical attention. Both vehicles were safely able to drive away from the scene.
Keywords:
[]
Dcc:
[]
Report url:
report
Image url:
image
Latitude:
42.3559661
Longitude:
-71.18448
Location:
400 Centre St, Newton, MA 02458, USA

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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);
Powered by Datasette · Queries took 411.757ms