home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

4 rows where dcc = "["Inattention"]", dcc contains "Inattention" and "retrieved" is on date 2021-10-25

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: intersection, speed_limit, hit_run, 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:
2100000752
Date:
2021-09-24
Time:
15:13
Address:
BEACON ST & LAKE AVE
Speed limit:
25
Violation cited:
no
Narrative:
Operator 1 stated, she was traveling Northbound on Lake Ave and stopped at the at the stop sign at the intersection of Lake Ave and Beacon St. Operator 1 stated she tried to cross over Beacon St and thought she had enough time to cross but crashed into vehicle 2 passenger side door, who was traveling Westbound on Beacon St. Operator 2 stated, he was traveling Westbound on Beacon St when Vehicle 1 tried to cross the intersection and crashed into his vehicle. A witness stated that vehicle 1 came to a complete stop at the intersection of Lake Ave and Beacon St then proceeded through the intersection and crashed into vehicle 2 at an angle. There was heavy damage to the front of vehicle 1 and heavy damage to the drivers side door and undercarriage of vehicle 2. Both vehicles were towed by Tody's Towing. Operator 1 and her passengers (all juveniles) notified parents/guardians on scene about the accident and all declined medical attention. Operator 2 also declined medical attention.
Keywords:
Crash
Dcc:
Inattention
Report url:
report
Image url:
image
Latitude:
42.3304598
Longitude:
-71.1988555
Location:
Beacon St & Lake Ave, Newton, MA 02459, USA
Case number:
2100000775
Date:
2021-09-30
Time:
19:43
Address:
BOYLSTON ST
Speed limit:
50
Violation cited:
no
Narrative:
Operator of MV1 said she was on the on ramp located at Winchester Street at Boylston Street. Operator of MV1 said she attempted to merge onto Boylston Street when she struck the rear of MV2 at Boylston Street at Walnut Street. Operator of MV2 said he was traveling eastbound on Boylston St and was attempting to turn right onto Walnut St when he was struck from behind by MV2. Both MV1 and MV2 pulled over to Woodcliff road. There is damage to the rear passenger bumper of MV2. There were no injuries and both vehicles were able to drive away from the scene.
Keywords:
[]
Dcc:
Inattention
Report url:
report
Image url:
image
Latitude:
42.319099
Longitude:
-71.1943518
Location:
Boylston St, Newton, MA, USA
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

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 349.172ms