NYISO logo

P-14B Transmission Outage Schedule

NYISO's public P-14B transmission outage schedule, kept as one row per outage per published version of the list, with equipment PTID, name and type, scheduled out and in times, and status with its status time.

One row per
source_time x outage_id
Irregular revisions, polled hourly cadence
Evidence
Observed market data
Published observations from the named source
Time basis
Point-in-time records
UTC · event_time

Overview

event_time is the scheduled out time; source_time is the version's publication time, so every revision NYISO posts is retained. The current schedule is the rows at the latest source_time; counting one outage_id across versions double-counts it. Status values include UPDATED, EXTENDED, EXT FORCED, FORCED, DENIED, and CANCELLED, so a DENIED or CANCELLED row is not an outage that took place. Distinct from nyiso.outage_schedule, the date-stamped operational feed of generator and transmission outages.

Query contract
Preserve one canonical row per (source_time, outage_id) before aggregating.
Analysis rules
Group only after preserving the declared grain: source_time, outage_id.

Access

Download
Query it in SQL, download it, or read it with an API key. Download data
Full history
Delivered to Snowflake, Databricks or your own storage on a schedule by Data services.
More coverage

Schema

12 columns
ColumnType
event_timeDateTime64(6, 'UTC')
source_timeDateTime64(6, 'UTC')
ptidNullable(Int64)
outage_idLowCardinality(String)
equipment_nameNullable(String)
equipment_typeNullable(String)
scheduled_out_timeDateTime64(6, 'UTC')
scheduled_in_timeNullable(DateTime64(6, 'UTC'))
statusNullable(String)
status_timeNullable(DateTime64(6, 'UTC'))
row_hashString
ingested_atDateTime64(6, 'UTC')

Sample data

event_timesource_timeptidoutage_idequipment_nameequipment_typescheduled_out_timescheduled_in_timestatusstatus_timerow_hashingested_at
2031-10-27 05:30:00.0000002026-09-25 06:15:24.00000031389526-12942-4MOTTHAVN_345KV_BTECB / SWITCH2031-10-27 05:30:00.0000002031-10-27 06:00:00.000000∅∅97d5a4389860dbcc2c8bbf550c414776f174ce06abcd96efd0955b15c33a7f4a2026-09-25 06:30:44.830572
2031-10-27 05:30:00.0000002026-09-25 06:15:24.00000031389026-12942-2MOTTHAVN_345KV_2CB / SWITCH2031-10-27 05:30:00.0000002031-10-27 06:00:00.000000∅∅ea4ef4362e5051c1c1c929133573afc1b6e8881a1df96e6622ab671dde2ad01a2026-09-25 06:30:44.830572
2031-10-27 05:30:00.0000002026-09-25 05:15:24.00000031389526-12942-4MOTTHAVN_345KV_BTECB / SWITCH2031-10-27 05:30:00.0000002031-10-27 06:00:00.000000∅∅97d5a4389860dbcc2c8bbf550c414776f174ce06abcd96efd0955b15c33a7f4a2026-09-25 05:30:46.862122
2031-10-27 05:30:00.0000002026-09-25 05:15:24.00000031389026-12942-2MOTTHAVN_345KV_2CB / SWITCH2031-10-27 05:30:00.0000002031-10-27 06:00:00.000000∅∅ea4ef4362e5051c1c1c929133573afc1b6e8881a1df96e6622ab671dde2ad01a2026-09-25 05:30:46.862122
2031-10-27 05:30:00.0000002026-09-25 04:15:23.00000031389526-12942-4MOTTHAVN_345KV_BTECB / SWITCH2031-10-27 05:30:00.0000002031-10-27 06:00:00.000000∅∅97d5a4389860dbcc2c8bbf550c414776f174ce06abcd96efd0955b15c33a7f4a2026-09-25 04:30:44.486885
2031-10-27 05:30:00.0000002026-09-25 04:15:23.00000031389026-12942-2MOTTHAVN_345KV_2CB / SWITCH2031-10-27 05:30:00.0000002031-10-27 06:00:00.000000∅∅ea4ef4362e5051c1c1c929133573afc1b6e8881a1df96e6622ab671dde2ad01a2026-09-25 04:30:44.486885
2031-10-27 05:30:00.0000002026-09-25 03:15:23.00000031389526-12942-4MOTTHAVN_345KV_BTECB / SWITCH2031-10-27 05:30:00.0000002031-10-27 06:00:00.000000∅∅97d5a4389860dbcc2c8bbf550c414776f174ce06abcd96efd0955b15c33a7f4a2026-09-25 03:30:48.516540
2031-10-27 05:30:00.0000002026-09-25 03:15:23.00000031389026-12942-2MOTTHAVN_345KV_2CB / SWITCH2031-10-27 05:30:00.0000002031-10-27 06:00:00.000000∅∅ea4ef4362e5051c1c1c929133573afc1b6e8881a1df96e6622ab671dde2ad01a2026-09-25 03:30:48.516540
2031-10-27 05:30:00.0000002026-09-25 02:15:24.00000031389526-12942-4MOTTHAVN_345KV_BTECB / SWITCH2031-10-27 05:30:00.0000002031-10-27 06:00:00.000000∅∅97d5a4389860dbcc2c8bbf550c414776f174ce06abcd96efd0955b15c33a7f4a2026-09-25 02:30:44.792181
2031-10-27 05:30:00.0000002026-09-25 02:15:24.00000031389026-12942-2MOTTHAVN_345KV_2CB / SWITCH2031-10-27 05:30:00.0000002031-10-27 06:00:00.000000∅∅ea4ef4362e5051c1c1c929133573afc1b6e8881a1df96e6622ab671dde2ad01a2026-09-25 02:30:44.792181
2031-10-27 05:30:00.0000002026-09-25 01:15:24.00000031389526-12942-4MOTTHAVN_345KV_BTECB / SWITCH2031-10-27 05:30:00.0000002031-10-27 06:00:00.000000∅∅97d5a4389860dbcc2c8bbf550c414776f174ce06abcd96efd0955b15c33a7f4a2026-09-25 01:30:44.682110
2031-10-27 05:30:00.0000002026-09-24 13:10:23.00000031389026-12942-2MOTTHAVN_345KV_2CB / SWITCH2031-10-27 05:30:00.0000002031-10-27 06:00:00.000000∅∅ea4ef4362e5051c1c1c929133573afc1b6e8881a1df96e6622ab671dde2ad01a2026-09-24 13:30:44.219791
2031-10-27 05:30:00.0000002026-09-25 00:15:23.00000031389526-12942-4MOTTHAVN_345KV_BTECB / SWITCH2031-10-27 05:30:00.0000002031-10-27 06:00:00.000000∅∅97d5a4389860dbcc2c8bbf550c414776f174ce06abcd96efd0955b15c33a7f4a2026-09-25 00:30:44.367213
2031-10-27 05:30:00.0000002026-09-25 00:15:23.00000031389026-12942-2MOTTHAVN_345KV_2CB / SWITCH2031-10-27 05:30:00.0000002031-10-27 06:00:00.000000∅∅ea4ef4362e5051c1c1c929133573afc1b6e8881a1df96e6622ab671dde2ad01a2026-09-25 00:30:44.367213
2031-10-27 05:30:00.0000002026-09-24 23:15:24.00000031389526-12942-4MOTTHAVN_345KV_BTECB / SWITCH2031-10-27 05:30:00.0000002031-10-27 06:00:00.000000∅∅97d5a4389860dbcc2c8bbf550c414776f174ce06abcd96efd0955b15c33a7f4a2026-09-24 23:30:46.272758
2031-10-27 05:30:00.0000002026-09-24 23:15:24.00000031389026-12942-2MOTTHAVN_345KV_2CB / SWITCH2031-10-27 05:30:00.0000002031-10-27 06:00:00.000000∅∅ea4ef4362e5051c1c1c929133573afc1b6e8881a1df96e6622ab671dde2ad01a2026-09-24 23:30:46.272758
2031-10-27 05:30:00.0000002026-09-24 22:15:23.00000031389526-12942-4MOTTHAVN_345KV_BTECB / SWITCH2031-10-27 05:30:00.0000002031-10-27 06:00:00.000000∅∅97d5a4389860dbcc2c8bbf550c414776f174ce06abcd96efd0955b15c33a7f4a2026-09-24 22:30:44.155306
2031-10-27 05:30:00.0000002026-09-24 22:15:23.00000031389026-12942-2MOTTHAVN_345KV_2CB / SWITCH2031-10-27 05:30:00.0000002031-10-27 06:00:00.000000∅∅ea4ef4362e5051c1c1c929133573afc1b6e8881a1df96e6622ab671dde2ad01a2026-09-24 22:30:44.155306
2031-10-27 05:30:00.0000002026-09-25 01:15:24.00000031389026-12942-2MOTTHAVN_345KV_2CB / SWITCH2031-10-27 05:30:00.0000002031-10-27 06:00:00.000000∅∅ea4ef4362e5051c1c1c929133573afc1b6e8881a1df96e6622ab671dde2ad01a2026-09-25 01:30:44.682110
2031-10-27 05:30:00.0000002026-09-24 17:15:24.00000031389026-12942-2MOTTHAVN_345KV_2CB / SWITCH2031-10-27 05:30:00.0000002031-10-27 06:00:00.000000∅∅ea4ef4362e5051c1c1c929133573afc1b6e8881a1df96e6622ab671dde2ad01a2026-09-24 17:30:51.409827
2031-10-27 05:30:00.0000002026-09-24 16:15:24.00000031389526-12942-4MOTTHAVN_345KV_BTECB / SWITCH2031-10-27 05:30:00.0000002031-10-27 06:00:00.000000∅∅97d5a4389860dbcc2c8bbf550c414776f174ce06abcd96efd0955b15c33a7f4a2026-09-24 16:30:45.693507
2031-10-27 05:30:00.0000002026-09-24 16:15:24.00000031389026-12942-2MOTTHAVN_345KV_2CB / SWITCH2031-10-27 05:30:00.0000002031-10-27 06:00:00.000000∅∅ea4ef4362e5051c1c1c929133573afc1b6e8881a1df96e6622ab671dde2ad01a2026-09-24 16:30:45.693507
2031-10-27 05:30:00.0000002026-09-24 21:15:23.00000031389526-12942-4MOTTHAVN_345KV_BTECB / SWITCH2031-10-27 05:30:00.0000002031-10-27 06:00:00.000000∅∅97d5a4389860dbcc2c8bbf550c414776f174ce06abcd96efd0955b15c33a7f4a2026-09-24 21:30:44.389984
2031-10-27 05:30:00.0000002026-09-24 15:10:23.00000031389026-12942-2MOTTHAVN_345KV_2CB / SWITCH2031-10-27 05:30:00.0000002031-10-27 06:00:00.000000∅∅ea4ef4362e5051c1c1c929133573afc1b6e8881a1df96e6622ab671dde2ad01a2026-09-24 15:30:44.461525
2031-10-27 05:30:00.0000002026-09-24 15:10:23.00000031389526-12942-4MOTTHAVN_345KV_BTECB / SWITCH2031-10-27 05:30:00.0000002031-10-27 06:00:00.000000∅∅97d5a4389860dbcc2c8bbf550c414776f174ce06abcd96efd0955b15c33a7f4a2026-09-24 15:30:44.461525

Coverage

Complete
7.7%
Gap days
5,853
Days with data
490
Show coverage history
Coverage: 7.7%Days with data: 490Gaps: 5,853
2031
2030
2029
2028
2027
2026
2025
2024
2023
2022
2021
2020
2019
2018
2017
2016
2015
2014
gaplessmore