Interstate Gas Pipeline Capacity and Scheduled Flow

Operationally available capacity postings from the electronic bulletin boards that FERC requires interstate natural gas pipelines to publish, covering 34 pipelines including Transco, Texas Eastern, Algonquin, Tennessee, NGPL, El Paso Natural Gas, CIG, Southern Natural and Northwest.

Native record
pipeline x metering location x gas day x nomination cycle x direction
Daily by nomination cycle publication cadence
Evidence
Observed market data
Published observations from the named source
Time basis
Date-labelled records
UTC · event_time

Overview

Each row is one metering location on one pipeline for one gas day and nomination cycle, carrying design capacity, operating capacity, operationally available capacity and scheduled quantity in dekatherms. This is physical capacity and physical flow, not price: scheduled_dth is gas actually nominated to move through that point, and the gap between operating capacity and scheduled quantity is the headroom left on that segment. It is the physical layer underneath gas-driven price formation — constrained takeaway or a full segment into a load pocket is what turns a regional gas price away from the national benchmark — and it is the only view here of gas delivery to individual power plants, with locations tagged by category including power_plant (85,896 rows), citygate (291,891) and storage, processing, production, interconnect, industrial and LNG terminal. Coverage is very uneven by pipeline and must be checked before any cross-pipeline comparison: Transco reaches back to 2018-06-04 and the Enbridge group to 2023-06, but the Kinder Morgan pipelines begin only on 2026-03-04, so a multi-pipeline total over an earlier window silently omits them. 32 of the 34 pipelines are current to within three days. The category column is unlabelled for 81% of rows, so a category filter returns an authoritative subset rather than everything of that kind. Filter on event_time rather than gas_day — the two always hold the same date, but only event_time is indexed, and using it cuts a representative power-plant query from a full scan to three granules. The official source is each pipeline's FERC-mandated electronic bulletin board.

Query contract

Read FINAL: pipelines repost a gas day across cycles and the table retains unmerged copies. Pick one cycle explicitly — quantities from different nomination cycles for the same gas day are successive revisions of the same nomination, not additive.

Analysis rules

  • Filter on event_time, not gas_day. Both always carry the same date, but only event_time is in the primary key and partition key; filtering gas_day forces a full scan.
  • Never sum across cycles for one gas day and location. Choose one cycle (evening and id1 are the densely populated ones; timely is nearly absent here).

Interpretation

  • This is physical capacity and scheduled quantity in dekatherms. It carries no price and cannot establish a gas price, a basis, or a cost.
  • The category column is unlabelled on 81% of rows, so filtering to power_plant or citygate returns an authoritative subset of tagged locations rather than every location of that kind. An empty result does not prove no such delivery exists.

Access

Query from your own tools

Use the guarded HTTP endpoint directly, or connect an MCP client and load the dataset contract with describe_data before calling query_data.

HTTP endpoint
POST /api/v1/datasets/gas_pipeline_ebb_operationally_available_capacity/query

Need the full history of this dataset in Snowflake, Databricks or your own storage? Data services delivers it on a schedule.

Schema15

Column
Type
event_timeDateTime64(6, 'UTC')
observed_atDateTime64(6, 'UTC')
pipeline_slugLowCardinality(String)
pipeline_ferc_codeNullable(String)
gas_dayDate32
cycleLowCardinality(String)
location_idLowCardinality(String)
location_nameNullable(String)
directionLowCardinality(String)
categoryNullable(String)
design_capacity_dthNullable(Float64)
operating_capacity_dthNullable(Float64)
operationally_available_dthNullable(Float64)
scheduled_dthNullable(Float64)
ingested_atDateTime64(6, 'UTC')

Sample data

event_timeobserved_atpipeline_slugpipeline_ferc_codegas_daycyclelocation_idlocation_namedirectioncategorydesign_capacity_dthoperating_capacity_dthoperationally_available_dthscheduled_dthingested_at
2026-10-12 00:00:00.0000002026-10-12 04:21:23.978490et_fepFEP2026-10-12timely78560WOOLLY HOLLOWreceiptunknown12000012000012000002026-10-12 04:21:25.204223
2026-10-12 00:00:00.0000002026-10-12 04:21:25.180804et_fepFEP2026-10-12evening78560WOOLLY HOLLOWreceiptunknown12000012000012000002026-10-12 04:21:25.204223
2026-10-12 00:00:00.0000002026-10-12 04:21:23.978490et_fepFEP2026-10-12timely78558TWIN GROVEreceiptunknown15000015000015000002026-10-12 04:21:25.204223
2026-10-12 00:00:00.0000002026-10-12 04:21:25.180804et_fepFEP2026-10-12evening78558TWIN GROVEreceiptunknown15000015000015000002026-10-12 04:21:25.204223
2026-10-12 00:00:00.0000002026-10-12 04:21:23.978490et_fepFEP2026-10-12timely78557BHP/CENTER RIDGEreceiptunknown10000010000010000002026-10-12 04:21:25.204223
2026-10-12 00:00:00.0000002026-10-12 04:21:25.180804et_fepFEP2026-10-12evening78557BHP/CENTER RIDGEreceiptunknown10000010000010000002026-10-12 04:21:25.204223
2026-10-12 00:00:00.0000002026-10-12 04:21:23.978490et_fepFEP2026-10-12timely78556PRAIRIE CREEKreceiptunknown10000010000010000002026-10-12 04:21:25.204223
2026-10-12 00:00:00.0000002026-10-12 04:21:25.180804et_fepFEP2026-10-12evening78556PRAIRIE CREEKreceiptunknown10000010000010000002026-10-12 04:21:25.204223
2026-10-12 00:00:00.0000002026-10-12 04:21:23.978490et_fepFEP2026-10-12timely78526BHP/LITTLE CREEKreceiptunknown40000040000040000002026-10-12 04:21:25.204223
2026-10-12 00:00:00.0000002026-10-12 04:21:25.180804et_fepFEP2026-10-12evening78526BHP/LITTLE CREEKreceiptunknown40000040000040000002026-10-12 04:21:25.204223
2026-10-12 00:00:00.0000002026-10-12 04:21:23.978490et_fepFEP2026-10-12timely78525TRUNKLINE PANOLAdeliveryunknown89062589062589062502026-10-12 04:21:25.204223
2026-10-12 00:00:00.0000002026-10-12 04:21:25.180804et_fepFEP2026-10-12evening78525TRUNKLINE PANOLAdeliveryunknown89062589062589062502026-10-12 04:21:25.204223
2026-10-12 00:00:00.0000002026-10-12 04:21:23.978490et_fepFEP2026-10-12timely78524ANR QUITMANdeliveryunknown12875001287500128750002026-10-12 04:21:25.204223
2026-10-12 00:00:00.0000002026-10-12 04:21:25.180804et_fepFEP2026-10-12evening78524ANR QUITMANdeliveryunknown12875001287500128750002026-10-12 04:21:25.204223
2026-10-12 00:00:00.0000002026-10-12 04:21:23.978490et_fepFEP2026-10-12timely78523TEXAS GAS LULAdeliveryunknown62000062000062000002026-10-12 04:21:25.204223
2026-10-12 00:00:00.0000002026-10-12 04:21:25.180804et_fepFEP2026-10-12evening78523TEXAS GAS LULAdeliveryunknown62000062000062000002026-10-12 04:21:25.204223
2026-10-12 00:00:00.0000002026-10-12 04:21:23.978490et_fepFEP2026-10-12timely78522NGPL RUSSELLdeliveryunknown50000050000050000002026-10-12 04:21:25.204223
2026-10-12 00:00:00.0000002026-10-12 04:21:25.180804et_fepFEP2026-10-12evening78522NGPL RUSSELLdeliveryunknown50000050000050000002026-10-12 04:21:25.204223
2026-10-12 00:00:00.0000002026-10-12 04:21:23.978490et_fepFEP2026-10-12timely78521SWN/TIGERreceiptunknown20000023500023500002026-10-12 04:21:25.204223
2026-10-12 00:00:00.0000002026-10-12 04:21:25.180804et_fepFEP2026-10-12evening78521SWN/TIGERreceiptunknown20000023500023500002026-10-12 04:21:25.204223
2026-10-12 00:00:00.0000002026-10-12 04:21:23.978490et_fepFEP2026-10-12timely78520SWN/MIDGE #2receiptunknown15000015000015000002026-10-12 04:21:25.204223
2026-10-12 00:00:00.0000002026-10-12 04:21:25.180804et_fepFEP2026-10-12evening78520SWN/MIDGE #2receiptunknown15000015000015000002026-10-12 04:21:25.204223
2026-10-12 00:00:00.0000002026-10-12 04:21:23.978490et_fepFEP2026-10-12timely78519SWN/MIDGE #1receiptunknown15000015000015000002026-10-12 04:21:25.204223
2026-10-12 00:00:00.0000002026-10-12 04:21:25.180804et_fepFEP2026-10-12evening78519SWN/MIDGE #1receiptunknown15000015000015000002026-10-12 04:21:25.204223
2026-10-12 00:00:00.0000002026-10-12 04:21:23.978490et_fepFEP2026-10-12timely78518CENTERPOINT/ROSE BUDreceiptcitygate20000020000020000002026-10-12 04:21:25.204223

Coverage

100.0% complete3 gap days8,983 days with data
Show coverage history
Coverage: 100.0%Days with data: 8,983Gaps: 3
2026
2025
2024
2023
2022
2021
2020
2019
2018
2017
2016
2015
2014
2013
2012
2011
2010
2009
2008
2007
2006
2005
2004
2003
2002
gaplessmore