home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

3 rows where keywords contains "Moderate" and "retrieved" is on date 2021-10-25

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: hit_run, dcc, dcc_code, 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:
2100000797
Date:
2021-10-07
Time:
17:45
Address:
ELM ST & WEBSTER ST
Speed limit:
20
Violation cited:
no
Narrative:
The operator of MV1 stated that they were at the stop sign on Webster St. and took a left onto Elm heading Southbound. Once on Elm St. MV2 which was parked on the right side of the street, pulled out and hit MV1 on the right side. MV1 had moderate damage to the right side of the truck, and a rear flat tire. The operator of MV2 stated that they were parked on Elm St. and when they went to pull out MV1 crashed into them. The operator of MV2 stated that they checked for incoming traffic and did not see MV1 coming down Elm St. There was major damage to the front of MV 2. The operator of MV1 was able to change the flat tire and take the vehcile, Todys took possesion of MV2. Both parties denied medical attention, and were given the report number.
Keywords:
Crash, Moderate
Dcc:
Inattention
Report url:
report
Image url:
image
Latitude:
42.34987
Longitude:
-71.229876
Location:
Elm St & Webster St, Newton, MA 02465, USA
Case number:
2100000813
Date:
2021-10-12
Time:
11:56
Address:
BOYLSTON RD & CENTRE ST
Speed limit:
25
Violation cited:
no
Narrative:
Mv#1 was travelling straight ahead directly behind Mv#2 on Centre St W/B. #1 rear ended #2 as #2 was slowing in traffic for a Mv ahead of it that was turning left S/B onto Boylston Rd. #1 had airbag deployment, significant front end damage and towed by Todys. #2 had moderate rear end damage and was driven away by the operator. #1 and #2 had minor injuries/discomfort, right shin and neck, respectively. Each signed patient refusals.
Keywords:
Airbag, Moderate
Dcc:
Inattention
Report url:
report
Image url:
image
Latitude:
42.3207989
Longitude:
-71.204523
Location:
Boylston Rd & Centre St, Newton, MA 02461, USA
Case number:
2100000833
Date:
2021-10-15
Time:
14:49
Address:
BRACKETT RD & WAVERLEY AVE
Speed limit:
30
Violation cited:
no
Narrative:
The operator of MV#1 stated she was travelling northbound on Waverly Ave and had stopped to let a pedestrian with a dog cross the street when she was struck from behind by MV#2. MV#1 sustained moderate damages to its rear end. There were no reported injuries to the operator of MV#1. The operator of MV#2 stated she was travelling northbound on Waverly Ave (Directly behind MV#1) when MV#1 abruptly stopped. The operator of MV#2 stated she could not stop in time and struck MV#1. MV#2 sustained moderate front end damages and was leaking coolant. MV#2 was parked off to the side of the road and arranged for her own tow company. There were no reported injuries to the operator of MV#2 or its passenger.
Keywords:
Moderate, Ped
Dcc:
Followed too closely
Report url:
report
Image url:
image
Latitude:
42.3432445
Longitude:
-71.182577
Location:
Brackett Rd & Waverley Ave, 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 364.972ms