home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

2 rows where dcc contains "Visibility obstructed" and "retrieved" is on date 2022-06-08

✎ View and edit SQL

This data as json, CSV (advanced)

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

case_number ▼ date time address speed_limit violation_cited narrative keywords dcc report_url image_url latitude longitude
Case number:
22000481
Date:
2022-06-02
Time:
17:29
Address:
BEACON ST & CRESCENT AVE
Speed limit:
25
Violation cited:
no
Narrative:
Operator of MV1 states he was traveling northbound on Crescent Ave approaching the intersection at Beacon Street when he came to a complete stop at the stop sign. Operator of MV1 states he looked both ways on Beacon Street for oncoming traffic and after a motor vehicle passed him traveling eastbound on Beacon Street, he proceeded to cross Beacon Street when he was struck by MV2. The operator of MV1 states his visibility of MV2 was obstructed by the passing vehicle and didn't see MV2 traveling westbound on Beacon Street. MV1 sustained damage to the front right fender and front right passenger door. Tody's towing responded and removed the vehicle from the roadway. No injuries. Operator of MV2 states she was traveling westbound on Beacon Street approaching the intersection at Crescent Ave when MV1 appeared in her lane of travel and she struck MV2 head on. MV1 sustained damage to the front end. No tow required and no injuries.
Keywords:
[]
Dcc:
Visibility obstructed
Report url:
report
Image url:
image
Latitude:
42.3303911
Longitude:
-71.1980873
Location:
Beacon St & Crescent Ave, Newton, MA 02459, USA
Case number:
22000486
Date:
2022-06-04
Time:
13:25
Address:
22 WOODWARD ST
Speed limit:
25
Violation cited:
no
Narrative:
Vehicle 1 was waiting in southbound traffic at the traffic light for the intersection of Woodward St and Boylston St when the operator realized he was in the wrong turn lane. Vehicle 1 then attempted to reverse to give him room between him and the vehicle in front of him so he could change lanes, however he did not notice Vehicle 2 waiting in traffic behind him. Vehicle 1 then backed into Vehicle 2, causing minor damage to the rear bumper of Vehicle 1 and significant damage to the front end of Vehicle 2. Both operators gave similar accounts.
Keywords:
[]
Dcc:
Visibility obstructed, Inattention
Report url:
report
Image url:
image
Latitude:
42.3193608
Longitude:
-71.2132886
Location:
22 Woodward St, Newton Highlands, 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 364.102ms