home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

2 rows where dcc contains "Fatigue/Sleep", 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:
1900000644
Date:
2019-06-24
Time:
01:27
Address:
61 PEARL ST
Speed limit:
25
Violation cited:
no
Narrative:
MV1 stated he was travelling w/b on Pearl St when he "fell asleep" subsequently making contact with 4 parked cars. Operator was evaluated by Cataldo Ambulance who cleared with a patient refusal. MV1 was removed from the scene by Tody's Towing after sustaining heavy passenger side & front end damage. MV2 sustained minor drivers side damage. A note was left on the windshield with this report number for the owner. MV3 sustained heavy drivers side damage. A note was left on the windshield with this report number for the owner. MV4 sustained minor drivers side damage. A note was left on the windshield with this report number for the owner. MV5 sustained minor drivers side damage.A note was left on the windshield with this report number for the owner.
Keywords:
Ems
Dcc:
Inattention, Fatigue/Sleep
Report url:
report
Image url:
image
Latitude:
42.358457
Longitude:
-71.1879481
Location:
61 Pearl St, Newton, MA 02458, USA
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

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