home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

2 rows where dcc = "["Speeding"]" and keywords contains "Hospital"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: 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:
2100000340
Date:
2021-05-12
Time:
21:14
Address:
2150 WASHINGTON ST
Speed limit:
25
Violation cited:
yes
Narrative:
The OP. of MV#1 stated while traveling westbound on Washington Street, just passing Beacon Street, his vehicle suddenly struck a curb and he lost control of the vehicle. He ended up on the lawn of the Northland Building at 2150 Washington Street. Based on the accident scene, its appears that MV#1 went over the median on Washington Street, took down a city sign, hit the corner of Neshobe Road and the driveway into 2150 Washington Street which formed a ramp that launched his vehicle into the air. MV#1 spun around somehow and was now facing eastbound before the rear of the vehicle was wedged between a tree and a mound of dirt. Final resting position of MV#1 is approx. 250 feet from the median first struck. The operator of MV1 was transported to Newton-Wellesley Hospital for a head laceration and other unknown injures. Vehicle was towed from the scene by todys with major damage all over the vehicle. After reviewing surveillance video, the OP. of MV#1 was mailed MA. citation #T2014846 for violation of MGL Ch 89 Sec 4A - "Marked lanes violation" and Ch 90 Sec 17 - "Speed greater than reasonable."
Keywords:
Citation, Crash, Hospital, Tree
Dcc:
Speeding
Report url:
report
Image url:
image
Latitude:
42.3291503
Longitude:
-71.2501096
Location:
2150 Washington St, Newton, MA 02462, USA
Case number:
22000184
Date:
2022-02-26
Time:
16:15
Address:
CHESTNUT ST & WOODWARD ST
Speed limit:
25
Violation cited:
no
Narrative:
Vehicle 1 was headed southbound on Chestnut St and had begun to turn left onto Woodward St. Vehicle 2 was headed northbound on Chestnut St at a high rate of speed and was travelling too fast to yield to Vehicle 1. The front end of vehicle 2 collided with the front end of Vehicle 1. Both vehicles were disabled and towed from the scene by Tody's. The operator of Vehicle 2 was transported by ambulance to Brigham Women's Hospital with a large contusion to her forehead.
Keywords:
Ems, Hospital, Speed
Dcc:
Speeding
Report url:
report
Image url:
image
Latitude:
42.3260924
Longitude:
-71.2263534
Location:
Chestnut St & Woodward St, Newton, MA 02468, 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 318.758ms