crash_reports
2 rows where dcc contains "Fatigue/Sleep", intersection = 0 and keywords contains "Ems"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
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:
Image
url:
Latitude:
42.358457
Longitude:
-71.1879481
Location:
Case
number:
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:
Image
url:
Latitude:
42.3285764
Longitude:
-71.2262367
Location:
Advanced export
JSON shape: default, array, newline-delimited, object
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);