home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

3 rows where dcc contains "Visibility obstructed", intersection = 0 and "retrieved" is on date 2022-07-26

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: speed_limit, 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:
22000552
Date:
2022-06-21
Time:
21:13
Address:
255 CHERRY ST
Speed limit:
30
Violation cited:
no
Narrative:
MV 1 was traveling straight northbound on Cherry St when he rear ended MV 2. The operator of MV 1 (Mr. Richard Antonellis) stated he did not see the parked vehicle due to poor lighting in the roadway. I observed the street light where the crash occurred to be blocked by multiple trees on the side walk. The operator of MV 1 was not injured during the accident and signed a patient refusal with Fallon medics. The passenger of MV 1 sustained a minor cut on her nose and was treated on scene with Fallon medics and signed a refusal to be transported. MV 1 sustained major damage to its front and right side. Front and side airbags also deployed. MV 1 was towed by Tody's due to it being disabled MV 2 was legally parked on the right side of Cherry St facing Northbound. MV 1 rear ended MV 2. MV 2 was unoccupied and parked when the crash occurred. MV 2 sustained major damage to its rear and left side. MV 2 was towed by Tody's due to it being disabled.
Keywords:
Airbag, Crash, Tree, Walk
Dcc:
Visibility obstructed
Report url:
report
Image url:
image
Latitude:
42.355621
Longitude:
-71.2285339
Location:
255 Cherry St, West Newton, MA 02465, USA
Case number:
22000556
Date:
2022-06-22
Time:
19:11
Address:
WASHINGTON STREET
Speed limit:
30
Violation cited:
no
Narrative:
Vehicle #2 was traveling east on Washington St. in the left center travel lane. Vehicle #1 was traveling east on Washington St. in the right center travel lane. Vehicle #1 attempted to pass Vehicle #2 and change lanes into the left center travel lane and side swiped Vehicle #2. There were no injuries reported at the accident. Vehicle #1 sustained minor damage to its back seat driver side door. Vehicle #2 sustained minor damage to its passenger side front quarter panel and front bumper. Both vehicles were able to drive away from the scene.
Keywords:
Crash
Dcc:
Visibility obstructed
Report url:
report
Image url:
image
Latitude:
 
Longitude:
 
Location:
None
Case number:
22000644
Date:
2022-07-18
Time:
12:32
Address:
777 WASHINGTON ST
Speed limit:
35
Violation cited:
no
Narrative:
Vehicle 1 was traveling in the left hand lane of the westbound side of Washington St when Vehicle 2 pulled out of a driveway and struck her rear passenger side. Vehicle 2 was pulling out of 777 Washing St and a large truck was parked in the right lane blocking her view as she exited. As she proceeded she struck the rear passenger side of vehicle 1. No reported injuries. No tows.
Keywords:
[]
Dcc:
Visibility obstructed
Report url:
report
Image url:
image
Latitude:
 
Longitude:
 
Location:
None

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