home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

2 rows where "datetime" is on date 2022-06-08, intersection = 0 and keywords contains "Airbag"

✎ View and edit SQL

This data as json, CSV (advanced)

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

case_number ▼ date time address speed_limit violation_cited narrative keywords dcc report_url image_url latitude longitude
Case number:
22000504
Date:
2022-06-08
Time:
19:37
Address:
457 WALNUT ST
Speed limit:
25
Violation cited:
no
Narrative:
MV1 was traveling NORTHBOUND on Walnut St just passing Newton North High School when they stopped for pedestrians in the crosswalk at the intersection of Walnut St at Clyde St. MV2 traveling behind MV1 heading NORTHBOUND as well when they rear-ended MV1 not realizing that MV1 had stopped for pedestrians. MV1 sustained damage to its rear bumper and MV2 sustained heavy damage to its passenger front bumper and hood. No airbags deployed and no injuries reported. Tody's towed both vehicles.
Keywords:
Airbag, Crosswalk, Ped, School
Dcc:
Followed too closely
Report url:
report
Image url:
image
Latitude:
42.3451469
Longitude:
-71.2075289
Location:
457 Walnut St, Newton, MA 02460, USA
Case number:
22000505
Date:
2022-06-08
Time:
20:05
Address:
1321 WASHINGTON ST
Speed limit:
25
Violation cited:
no
Narrative:
MV1 and MV2 were traveling WESTBOUND on Washington St when the traffic light turned red and they stopped. MV3 was traveling WESTBOUND behind those vehicles when he looked down at his radio at the same time that they had stopped at the traffic light. Subsequently, MV3 did not stop in time to avoid the collision. MV3 rear-ended MV2 which pushed MV2 forward to hit MV1. MV1 drove away prior to my arrival and did not want to take part in the report as he did not have any damage to his vehicle. MV2 operator still obtained MV1's information because MV2 sustained damage in the front end due to the collision. MV2 sustained damage to its rear-end bumper as well as its front. MV3 sustained damage to its front bumper and hood. No airbags deployed and no injuries reported. No tows were necessary as all vehicles were operable from the scene.
Keywords:
Airbag
Dcc:
[]
Report url:
report
Image url:
image
Latitude:
42.3494467
Longitude:
-71.2276058
Location:
1321 Washington St, Newton, MA 02465, 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 401.987ms