home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

2 rows where "date" is on date 2022-02-15, intersection = 0 and keywords contains "Ems"

✎ 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:
22000152
Date:
2022-02-15
Time:
04:04
Address:
619 CHESTNUT ST
Speed limit:
25
Violation cited:
no
Narrative:
On February 15, 2022 at approximately 0404hrs, Mv1 was traveling Southbound on Chestnut St., when the operator of the vehicle fell asleep at the wheel, causing her vehicle to hop the curb and strike a telephone pole and Federal Mailbox in front of 619 Chestnut St. Operator stated she was returning home late from a friends house and did not realize how tired she was and fell asleep, while driving. Newton Fire Department and Fallon Ambulance Service responded to evaluate the operator. Operator stated she way okay and signed a patient refusal. The telephone pole did not appear to have sustained any damage, but National Grid was made aware in order to later inspect the pole. The U.S. Postal Service was also made aware of the damaged postal box in order to replace it. The vehicle sustained heavy front end damage, consisting also of deployed air bags.Todys Towing Service was notified and arrived on scene to tow the vehicle. Pictures were taken of the scene and have been sent to the IT Bureau to be attached to this report.
Keywords:
Ems, Fire, Pictures
Dcc:
Fatigue/Sleep
Report url:
report
Image url:
image
Latitude:
42.3285764
Longitude:
-71.2262367
Location:
619 Chestnut St, Waban, MA 02468, USA
Case number:
22000156
Date:
2022-02-15
Time:
19:11
Address:
106 AUBURN ST
Speed limit:
25
Violation cited:
yes
Narrative:
On Tuesday, February 15th, 2022 at approximately 1908 hours the operator of Vehicle 1 was travelling Westbound on Auburn St when it crossed over the center double yellow lines, crossed the opposing lane of traffic, and went off the roadway before crashing through the vinyl privacy fence at #106 Auburn St. Vehicle 1 came to rest after colliding with the North-East corner of the residence. The operator of Vehicle 1 then attempted to reverse away from the crash and backed into and destroying more of the residence's privacy fence. The operator was then confronted by the occupants of the residence, including the homeowner. Fire and EMS arrived on scene and conducted patient care on the operator and formed the opinion that she was intoxicated. I arrived and interviewed the operator who stated that she had previously taken oxycodone. The operator was then transported to Newton Wellesley Hospital. The vehicle was towed from the scene by Tody's. The operator was charged with the following violations: C90ss24 OUI- Drugs C90ss24 Neg Op C89ss4A Marked Lanes An incident report was completed for this crash (See Report #22005833).
Keywords:
Alcohol, Crash, Ems, Fire, Hospital
Dcc:
Lane departure, Reckless driving
Report url:
report
Image url:
image
Latitude:
42.3444028
Longitude:
-71.2391844
Location:
106 Auburn St, West Newton, MA 02465, 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 472.76ms