home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

3 rows where dcc contains "Visibility obstructed", keywords contains "Crash" and "retrieved" is on date 2022-07-26

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: intersection, violation_cited, 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:
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:
22000613
Date:
2022-07-09
Time:
04:35
Address:
WATERTOWN ST & WILDWOOD AVE
Speed limit:
30
Violation cited:
yes
Narrative:
MV 1 was traveling westbound on Watertown St and attempting to make a right turn on Wildwood Ave. The operator of MV 1 stated a vehicle traveling in the opposite directions high beams obstructed his visibility and caused him to make the turn too sharply. MV 1 struck the curb at the intersection of Watertown St and Wildwood Ave with his right front tire. MV 1 sustained significant damage to the right front wheel and tire rendering the vehicle disabled. Tody's responded on scene and towed the vehicle away. The operator of MV 1 was not injured in the accident. The operator, Mr. Manuel Rodrigues, was issued citation T1448398 for MGL ch 90-9 unregistered motor vehicle because the vehicle he was driving did not have an active registration.
Keywords:
Citation, Crash
Dcc:
Visibility obstructed, Inattention
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 374.362ms