FERC Form 549B Index of Customers: Every Interstate Gas Pipeline's Firm Contracts

FERC Form 549B, the quarterly Index of Customers, for every interstate natural gas pipeline from the third quarter of 2013, as published on data.ferc.gov: about 146 pipelines and 6,000 shippers across the latest quarters, one row per firm transportation or storage contract and receipt or delivery point as of the first day of the quarter.

FERCInfrastructure data ERCOT market NYISO market CAISO market PJM market MISO market ISO-NE market SPP market

Open in Data Ask the agent

One row per: FERC company x quarter x filing x contract-point row; Quarterly filings; checked daily, reloaded when FERC publishes cadence
Evidence: Reference data; Stable context used to interpret other datasets
Time basis: Date-labelled records; UTC · event_time

Overview

Gives each contract's shipper, rate schedule, contract number, effective and primary-term expiration dates, whether the rate is negotiated, maximum daily quantity (MDQ), agent or asset manager, and the point (name, code, zone) with its own MDQ. Use it to find who holds firm capacity on a pipeline or into a zone, which contracts expire next, and which shippers serve a plant or delivery point. Keyed by FERC company ID (company_id, e.g. C000020 for Tennessee Gas Pipeline). Values are kept as filed: dates and quantities are text, units mix Dth, MMBtu and Mcf, and FERC's own DATA_ERROR flags appear in some cells. A contract appears once per point, and a quarter can hold an original and a revised filing. These are contractual rights, not metered flow, scheduled gas or available capacity. event_time is the quarter's first day. The dataset trails the filings by about a year.

Query contract: A quarter can hold several filings for one company: a revised filing re-files the same contracts. Keep one filing per company and quarter, the one with the latest report date: WITH latest AS (SELECT company_id, report_year, report_quarter, argMax(submission_filename, parseDateTimeBestEffortUSOrZero(report_date_raw)) AS submission_filename FROM gas_pipeline_ebb.ferc_index_of_customers FINAL GROUP BY company_id, report_year, report_quarter) and join on all four columns. Then pin event_time to one quarter. Count contracts with uniqExact(company_id, shipper_id, contract_number) and shippers with uniqExact(company_id, shipper_id).
Analysis rules: Never sum MDQ across rows. transport_mdq_raw and storage_mdq_raw are the contract's total and repeat on every one of its point rows; point_transport_mdq_raw is the point's share. Sum point MDQs only within one contract, and only after reading the unit.Units are per row and mixed (Dth, MMBtu, Mcf, sometimes blank or a DATA_ERROR flag); compare quantities only within one unit. Dates and quantities are text, so parse them before comparing.
Interpretation: Contractual rights as filed, not metered flow, scheduled gas, delivered fuel or available capacity. A contract MDQ is a ceiling, and firm holders may release it.FERC publishes with a lag: the newest quarter is about a year old, so this cannot show today's contract book. Say the quarter when reporting.

Access

Download: Query it in SQL, download it, or read it with an API key. Download data
MCP: Connect an MCP client and load the contract with describe_data before calling query_data.ERCOT MCP CAISO MCP NYISO MCP PJM MCP SPP MCP MISO MCP ISO-NE MCP BPA MCP API reference
HTTP endpoint: POST /api/v1/datasets/gas_pipeline_ebb_ferc_index_of_customers/query
Full history: Delivered to Snowflake, Databricks or your own storage on a schedule by Data services.
More coverage

Schema

44 columns

Column	Type
`event_time`	`DateTime64(6, 'UTC')`
`observed_at`	`DateTime64(6, 'UTC')`
`report_year`	`String`
`report_quarter`	`String`
`submission_filename`	`String`
`filing_row_index`	`String`
`pipeline_name`	`Nullable(String)`
`company_id`	`Nullable(String)`
`quarter_start_raw`	`Nullable(String)`
`report_date_raw`	`Nullable(String)`
`original_revised`	`Nullable(String)`
`contact`	`Nullable(String)`
`transport_unit_detail`	`Nullable(String)`
`storage_unit_detail`	`Nullable(String)`
`transport_unit_point`	`Nullable(String)`
`storage_unit_point`	`Nullable(String)`
`header_footnote_id`	`Nullable(String)`
`header_footnote`	`Nullable(String)`
`shipper_name`	`Nullable(String)`
`shipper_id`	`Nullable(String)`
`shipper_affiliation`	`Nullable(String)`
`rate_schedule`	`Nullable(String)`
`contract_number`	`Nullable(String)`
`contract_effective_raw`	`Nullable(String)`
`contract_expiration_raw`	`Nullable(String)`
`days_to_next_expiration`	`Nullable(String)`
`negotiated_rates`	`Nullable(String)`
`transport_mdq_raw`	`Nullable(String)`
`storage_mdq_raw`	`Nullable(String)`
`detail_footnote_id`	`Nullable(String)`
`detail_footnote`	`Nullable(String)`
`agent_raw`	`Nullable(String)`
`agent_footnote_id`	`Nullable(String)`
`agent_footnote`	`Nullable(String)`
`point_identifier_code`	`Nullable(String)`
`point_name`	`Nullable(String)`
`point_code_qualifier`	`Nullable(String)`
`point_code`	`Nullable(String)`
`zone_name`	`Nullable(String)`
`point_transport_mdq_raw`	`Nullable(String)`
`point_storage_mdq_raw`	`Nullable(String)`
`point_footnote_id`	`Nullable(String)`
`point_footnote`	`Nullable(String)`
`ingested_at`	`DateTime64(6, 'UTC')`

Sample data

event_time	observed_at	report_year	report_quarter	submission_filename	filing_row_index	pipeline_name	company_id	quarter_start_raw	report_date_raw	original_revised	contact	transport_unit_detail	storage_unit_detail	transport_unit_point	storage_unit_point	header_footnote_id	header_footnote	shipper_name	shipper_id	shipper_affiliation	rate_schedule	contract_number	contract_effective_raw	contract_expiration_raw	days_to_next_expiration	negotiated_rates	transport_mdq_raw	storage_mdq_raw	detail_footnote_id	detail_footnote	agent_raw	agent_footnote_id	agent_footnote	point_identifier_code	point_name	point_code_qualifier	point_code	zone_name	point_transport_mdq_raw	point_storage_mdq_raw	point_footnote_id	point_footnote	ingested_at
2025-04-01 00:00:00.000000	2026-10-31 05:35:57.664858	2025	2	iC0000202504	2779;2780;2781	TENNESSEE GAS PIPELINE COMPANY, L.L.C.	C000020	4/1/2025	4/1/2025	O	Carlos Oblitas (713)420-5771	Dth	Dth	Dth	Dth	∅	∅	VALLEY ENERGY, INC	54086520	N	FT-A	41707-FTATGP	11/15/2002	4/30/2027	∅	N	9717	0	n1	The Contract Primary Term Expiration Date has not passed. Contract may or may not continue under an "evergreen" or "rollover" provision.	UNION ENERGY SERVICES, INC., [N]	∅	∅	M2	STORAGE - NORTHERN	95	460018	ZONE 4	9717	0	∅	∅	2026-10-31 05:35:57.963869
2025-04-01 00:00:00.000000	2026-10-31 05:35:57.664858	2025	2	iC0000202504	2775;2776;2778	TENNESSEE GAS PIPELINE COMPANY, L.L.C.	C000020	4/1/2025	4/1/2025	O	Carlos Oblitas (713)420-5771	Dth	Dth	Dth	Dth	∅	∅	VALLEY ENERGY, INC	54086520	N	FT-A	41706-FTATGP	11/15/2002	4/30/2027	∅	N	1000	0	n1	The Contract Primary Term Expiration Date has not passed. Contract may or may not continue under an "evergreen" or "rollover" provision.	UNION ENERGY SERVICES, INC., [N]	∅	∅	MQ	VALLEY/TGP TOWANDA PA BRADFORD	95	420216	ZONE 4	1000	0	∅	∅	2026-10-31 05:35:57.963869
2025-04-01 00:00:00.000000	2026-10-31 05:35:57.664858	2025	2	iC0000202504	2775;2776;2777	TENNESSEE GAS PIPELINE COMPANY, L.L.C.	C000020	4/1/2025	4/1/2025	O	Carlos Oblitas (713)420-5771	Dth	Dth	Dth	Dth	∅	∅	VALLEY ENERGY, INC	54086520	N	FT-A	41706-FTATGP	11/15/2002	4/30/2027	∅	N	1000	0	n1	The Contract Primary Term Expiration Date has not passed. Contract may or may not continue under an "evergreen" or "rollover" provision.	UNION ENERGY SERVICES, INC., [N]	∅	∅	M2	TRANSCAN/TGP UDP NIAGARA RIVER NIAG	95	410902	ZONE 5	1000	0	∅	∅	2026-10-31 05:35:57.963869
2025-04-01 00:00:00.000000	2026-10-31 05:35:57.664858	2025	2	iC0000202504	2771;2772;2774	TENNESSEE GAS PIPELINE COMPANY, L.L.C.	C000020	4/1/2025	4/1/2025	O	Carlos Oblitas (713)420-5771	Dth	Dth	Dth	Dth	∅	∅	VALLEY ENERGY, INC	54086520	N	FT-A	41705-FTATGP	11/15/2002	10/31/2029	∅	N	1000	0	n1	The Contract Primary Term Expiration Date has not passed. Contract may or may not continue under an "evergreen" or "rollover" provision.	UNION ENERGY SERVICES, INC., [N]	∅	∅	MQ	VALLEY/TGP TOWANDA PA BRADFORD	95	420216	ZONE 4	1000	0	∅	∅	2026-10-31 05:35:57.963869
2025-04-01 00:00:00.000000	2026-10-31 05:35:57.664858	2025	2	iC0000202504	2771;2772;2773	TENNESSEE GAS PIPELINE COMPANY, L.L.C.	C000020	4/1/2025	4/1/2025	O	Carlos Oblitas (713)420-5771	Dth	Dth	Dth	Dth	∅	∅	VALLEY ENERGY, INC	54086520	N	FT-A	41705-FTATGP	11/15/2002	10/31/2029	∅	N	1000	0	n1	The Contract Primary Term Expiration Date has not passed. Contract may or may not continue under an "evergreen" or "rollover" provision.	UNION ENERGY SERVICES, INC., [N]	∅	∅	M2	ENTRPRSE/TGP AGUA DULCE NUECES	95	411306	ZONE 0	1000	0	∅	∅	2026-10-31 05:35:57.963869
2025-04-01 00:00:00.000000	2026-10-31 05:35:57.664858	2025	2	iC0000202504	276;277;279	TENNESSEE GAS PIPELINE COMPANY, L.L.C.	C000020	4/1/2025	4/1/2025	O	Carlos Oblitas (713)420-5771	Dth	Dth	Dth	Dth	∅	∅	HARDEMAN FAYETTE UTILITY DISTRICT	26357020	N	FS	2141-FSMATGP	9/1/1993	10/31/2030	∅	N	0	54024	n1	The Contract Primary Term Expiration Date has not passed. Contract may or may not continue under an "evergreen" or "rollover" provision.	D2 ENERGY, LLC, [N]	∅	∅	IJ	STORAGE - PORTLAND - MA	95	460025	ZONE 1	0	360	∅	∅	2026-10-31 05:35:57.963869
2025-04-01 00:00:00.000000	2026-10-31 05:35:57.664858	2025	2	iC0000202504	2734;;2736	TENNESSEE GAS PIPELINE COMPANY, L.L.C.	C000020	4/1/2025	4/1/2025	O	Carlos Oblitas (713)420-5771	Dth	Dth	Dth	Dth	∅	∅	TOTALENERGIES GAS & POWER NORTH AMERICA, INC.	620059980	N	FT-A	107759-FTATGP	6/1/2013	7/31/2028	∅	N	77500	0	n1	The Contract Primary Term Expiration Date has not passed. Contract may or may not continue under an "evergreen" or "rollover" provision.	∅	∅	∅	MQ	TRNSCO/TGP HEIDELBERG MISSISIPPI JA	95	420291	ZONE 1	76200	0	∅	∅	2026-10-31 05:35:57.963869
2025-04-01 00:00:00.000000	2026-10-31 05:35:57.664858	2025	2	iC0000202504	2763;2764;2770	TENNESSEE GAS PIPELINE COMPANY, L.L.C.	C000020	4/1/2025	4/1/2025	O	Carlos Oblitas (713)420-5771	Dth	Dth	Dth	Dth	∅	∅	VALLEY ENERGY, INC	54086520	N	FT-A	41704-FTATGP	11/15/2002	4/30/2027	∅	N	1500	0	n1	The Contract Primary Term Expiration Date has not passed. Contract may or may not continue under an "evergreen" or "rollover" provision.	UNION ENERGY SERVICES, INC., [N]	∅	∅	MQ	VALLEY/TGP TOWANDA PA BRADFORD	95	420216	ZONE 4	1500	0	∅	∅	2026-10-31 05:35:57.963869
2025-04-01 00:00:00.000000	2026-10-31 05:35:57.664858	2025	2	iC0000202504	2763;2764;2769	TENNESSEE GAS PIPELINE COMPANY, L.L.C.	C000020	4/1/2025	4/1/2025	O	Carlos Oblitas (713)420-5771	Dth	Dth	Dth	Dth	∅	∅	VALLEY ENERGY, INC	54086520	N	FT-A	41704-FTATGP	11/15/2002	4/30/2027	∅	N	1500	0	n1	The Contract Primary Term Expiration Date has not passed. Contract may or may not continue under an "evergreen" or "rollover" provision.	UNION ENERGY SERVICES, INC., [N]	∅	∅	M2	POOLING PT - 800 LEG - ZONE L	95	420998	ZONE L	315	0	∅	∅	2026-10-31 05:35:57.963869
2025-04-01 00:00:00.000000	2026-10-31 05:35:57.664858	2025	2	iC0000202504	2763;2764;2768	TENNESSEE GAS PIPELINE COMPANY, L.L.C.	C000020	4/1/2025	4/1/2025	O	Carlos Oblitas (713)420-5771	Dth	Dth	Dth	Dth	∅	∅	VALLEY ENERGY, INC	54086520	N	FT-A	41704-FTATGP	11/15/2002	4/30/2027	∅	N	1500	0	n1	The Contract Primary Term Expiration Date has not passed. Contract may or may not continue under an "evergreen" or "rollover" provision.	UNION ENERGY SERVICES, INC., [N]	∅	∅	M2	POOLING PT - 500 LEG - ZONE L	95	420999	ZONE L	433	0	∅	∅	2026-10-31 05:35:57.963869
2025-04-01 00:00:00.000000	2026-10-31 05:35:57.664858	2025	2	iC0000202504	2763;2764;2767	TENNESSEE GAS PIPELINE COMPANY, L.L.C.	C000020	4/1/2025	4/1/2025	O	Carlos Oblitas (713)420-5771	Dth	Dth	Dth	Dth	∅	∅	VALLEY ENERGY, INC	54086520	N	FT-A	41704-FTATGP	11/15/2002	4/30/2027	∅	N	1500	0	n1	The Contract Primary Term Expiration Date has not passed. Contract may or may not continue under an "evergreen" or "rollover" provision.	UNION ENERGY SERVICES, INC., [N]	∅	∅	M2	KINETICA/TGP COCODRIE 523 BLUEWATER	95	412883	ZONE L	227	0	∅	∅	2026-10-31 05:35:57.963869
2025-04-01 00:00:00.000000	2026-10-31 05:35:57.664858	2025	2	iC0000202504	2763;2764;2766	TENNESSEE GAS PIPELINE COMPANY, L.L.C.	C000020	4/1/2025	4/1/2025	O	Carlos Oblitas (713)420-5771	Dth	Dth	Dth	Dth	∅	∅	VALLEY ENERGY, INC	54086520	N	FT-A	41704-FTATGP	11/15/2002	4/30/2027	∅	N	1500	0	n1	The Contract Primary Term Expiration Date has not passed. Contract may or may not continue under an "evergreen" or "rollover" provision.	UNION ENERGY SERVICES, INC., [N]	∅	∅	M2	ETP/TGP GILMORE PLANT RESIDUE HIDAL	95	412458	ZONE 0	420	0	∅	∅	2026-10-31 05:35:57.963869
2025-04-01 00:00:00.000000	2026-10-31 05:35:57.664858	2025	2	iC0000202504	2763;2764;2765	TENNESSEE GAS PIPELINE COMPANY, L.L.C.	C000020	4/1/2025	4/1/2025	O	Carlos Oblitas (713)420-5771	Dth	Dth	Dth	Dth	∅	∅	VALLEY ENERGY, INC	54086520	N	FT-A	41704-FTATGP	11/15/2002	4/30/2027	∅	N	1500	0	n1	The Contract Primary Term Expiration Date has not passed. Contract may or may not continue under an "evergreen" or "rollover" provision.	UNION ENERGY SERVICES, INC., [N]	∅	∅	M2	EASTRANS/TGP EAST TX PLANT DEHY PAN	95	410031	ZONE 0	105	0	∅	∅	2026-10-31 05:35:57.963869
2025-04-01 00:00:00.000000	2026-10-31 05:35:57.664858	2025	2	iC0000202504	2760;;2762	TENNESSEE GAS PIPELINE COMPANY, L.L.C.	C000020	4/1/2025	4/1/2025	O	Carlos Oblitas (713)420-5771	Dth	Dth	Dth	Dth	∅	∅	UNITED STATES DEPARTMENT OF ENERGY	361714736	N	FT-A	60658-FTATGP	12/1/2005	11/30/2027	∅	N	3197	0	n1	The Contract Primary Term Expiration Date has not passed. Contract may or may not continue under an "evergreen" or "rollover" provision.	∅	∅	∅	M2	GULFSTH/TGP KILN MISS EXCHANGE HANC	95	420383	ZONE L	3197	0	∅	∅	2026-10-31 05:35:57.963869
2025-04-01 00:00:00.000000	2026-10-31 05:35:57.664858	2025	2	iC0000202504	2760;;2761	TENNESSEE GAS PIPELINE COMPANY, L.L.C.	C000020	4/1/2025	4/1/2025	O	Carlos Oblitas (713)420-5771	Dth	Dth	Dth	Dth	∅	∅	UNITED STATES DEPARTMENT OF ENERGY	361714736	N	FT-A	60658-FTATGP	12/1/2005	11/30/2027	∅	N	3197	0	n1	The Contract Primary Term Expiration Date has not passed. Contract may or may not continue under an "evergreen" or "rollover" provision.	∅	∅	∅	MQ	ETNG/TGP GREENBRIER TN 2 (DUAL ROBE	95	420289	ZONE 1	3197	0	∅	∅	2026-10-31 05:35:57.963869
2025-04-01 00:00:00.000000	2026-10-31 05:35:57.664858	2025	2	iC0000202504	2757;;2759	TENNESSEE GAS PIPELINE COMPANY, L.L.C.	C000020	4/1/2025	4/1/2025	O	Carlos Oblitas (713)420-5771	Dth	Dth	Dth	Dth	∅	∅	UNIPER GLOBAL COMMODITIES NORTH AMERICA LLC	79093350	N	FT-A	392478-FTATGP	4/1/2024	10/31/2025	∅	N	50000	0	n1	The Contract Primary Term Expiration Date has not passed. Contract may or may not continue under an "evergreen" or "rollover" provision.	∅	∅	∅	M2	POOLING PT-100 LEG-ZN 0-SOUTH	95	405345	ZONE 0	50000	0	∅	∅	2026-10-31 05:35:57.963869
2025-04-01 00:00:00.000000	2026-10-31 05:35:57.664858	2025	2	iC0000202504	276;277;278	TENNESSEE GAS PIPELINE COMPANY, L.L.C.	C000020	4/1/2025	4/1/2025	O	Carlos Oblitas (713)420-5771	Dth	Dth	Dth	Dth	∅	∅	HARDEMAN FAYETTE UTILITY DISTRICT	26357020	N	FS	2141-FSMATGP	9/1/1993	10/31/2030	∅	N	0	54024	n1	The Contract Primary Term Expiration Date has not passed. Contract may or may not continue under an "evergreen" or "rollover" provision.	D2 ENERGY, LLC, [N]	∅	∅	WR	STORAGE - PORTLAND - MA	95	460025	ZONE 1	0	1106	∅	∅	2026-10-31 05:35:57.963869
2025-04-01 00:00:00.000000	2026-10-31 05:35:57.664858	2025	2	iC0000202504	2757;;2758	TENNESSEE GAS PIPELINE COMPANY, L.L.C.	C000020	4/1/2025	4/1/2025	O	Carlos Oblitas (713)420-5771	Dth	Dth	Dth	Dth	∅	∅	UNIPER GLOBAL COMMODITIES NORTH AMERICA LLC	79093350	N	FT-A	392478-FTATGP	4/1/2024	10/31/2025	∅	N	50000	0	n1	The Contract Primary Term Expiration Date has not passed. Contract may or may not continue under an "evergreen" or "rollover" provision.	∅	∅	∅	MQ	GULFSTH/TGP COASTAL BEND LNG WHARTO	95	49524	ZONE 0	50000	0	∅	∅	2026-10-31 05:35:57.963869
2025-04-01 00:00:00.000000	2026-10-31 05:35:57.664858	2025	2	iC0000202504	2734;;2737	TENNESSEE GAS PIPELINE COMPANY, L.L.C.	C000020	4/1/2025	4/1/2025	O	Carlos Oblitas (713)420-5771	Dth	Dth	Dth	Dth	∅	∅	TOTALENERGIES GAS & POWER NORTH AMERICA, INC.	620059980	N	FT-A	107759-FTATGP	6/1/2013	7/31/2028	∅	N	77500	0	n1	The Contract Primary Term Expiration Date has not passed. Contract may or may not continue under an "evergreen" or "rollover" provision.	∅	∅	∅	M2	UTICA EO/TGP KENSINGTON DEHY: RIP 2	95	412868	ZONE 4	77500	0	∅	∅	2026-10-31 05:35:57.963869
2025-04-01 00:00:00.000000	2026-10-31 05:35:57.664858	2025	2	iC0000202504	2738;2739;2740	TENNESSEE GAS PIPELINE COMPANY, L.L.C.	C000020	4/1/2025	4/1/2025	O	Carlos Oblitas (713)420-5771	Dth	Dth	Dth	Dth	∅	∅	TRES PORT POWER LLC	118613597	N	FT-A	380124-FTATGP	11/1/2022	10/31/2026	∅	N	8000	0	n1	The Contract Primary Term Expiration Date has not passed. Contract may or may not continue under an "evergreen" or "rollover" provision.	TWIN EAGLE RESOURCE MANAGEMENT, LLC, [N]	∅	∅	MQ	/TGP OLD BLOOMINGTON POWER 1 VICTOR	95	53654	ZONE 0	8000	0	∅	∅	2026-10-31 05:35:57.963869
2025-04-01 00:00:00.000000	2026-10-31 05:35:57.664858	2025	2	iC0000202504	2738;2739;2741	TENNESSEE GAS PIPELINE COMPANY, L.L.C.	C000020	4/1/2025	4/1/2025	O	Carlos Oblitas (713)420-5771	Dth	Dth	Dth	Dth	∅	∅	TRES PORT POWER LLC	118613597	N	FT-A	380124-FTATGP	11/1/2022	10/31/2026	∅	N	8000	0	n1	The Contract Primary Term Expiration Date has not passed. Contract may or may not continue under an "evergreen" or "rollover" provision.	TWIN EAGLE RESOURCE MANAGEMENT, LLC, [N]	∅	∅	M2	BANHUB/TGP BANQUETE TRANSPORT NUECE	95	412062	ZONE 0	8000	0	∅	∅	2026-10-31 05:35:57.963869
2025-04-01 00:00:00.000000	2026-10-31 05:35:57.664858	2025	2	iC0000202504	2742;2743;2744	TENNESSEE GAS PIPELINE COMPANY, L.L.C.	C000020	4/1/2025	4/1/2025	O	Carlos Oblitas (713)420-5771	Dth	Dth	Dth	Dth	∅	∅	TRONOX LLC	8286114	N	FT-A	19883-FTATGP	7/1/1997	12/31/2030	∅	N	11000	0	n1	The Contract Primary Term Expiration Date has not passed. Contract may or may not continue under an "evergreen" or "rollover" provision.	BP ENERGY COMPANY, [N]	∅	∅	MQ	ATMOS-MS/TGP HAMILTON MS LOWNDES	95	420411	ZONE 1	11000	0	∅	∅	2026-10-31 05:35:57.963869
2025-04-01 00:00:00.000000	2026-10-31 05:35:57.664858	2025	2	iC0000202504	2742;2743;2745	TENNESSEE GAS PIPELINE COMPANY, L.L.C.	C000020	4/1/2025	4/1/2025	O	Carlos Oblitas (713)420-5771	Dth	Dth	Dth	Dth	∅	∅	TRONOX LLC	8286114	N	FT-A	19883-FTATGP	7/1/1997	12/31/2030	∅	N	11000	0	n1	The Contract Primary Term Expiration Date has not passed. Contract may or may not continue under an "evergreen" or "rollover" provision.	BP ENERGY COMPANY, [N]	∅	∅	M2	KINETICA/TGP COCODRIE 523 BLUEWATER	95	412883	ZONE L	11000	0	∅	∅	2026-10-31 05:35:57.963869
2025-04-01 00:00:00.000000	2026-10-31 05:35:57.664858	2025	2	iC0000202504	2753;;2756	TENNESSEE GAS PIPELINE COMPANY, L.L.C.	C000020	4/1/2025	4/1/2025	O	Carlos Oblitas (713)420-5771	Dth	Dth	Dth	Dth	∅	∅	UGI UTILITIES INC.	799376595	N	FT-A	362539-FTATGP	11/1/2020	10/31/2026	∅	N	3183	0	n1	The Contract Primary Term Expiration Date has not passed. Contract may or may not continue under an "evergreen" or "rollover" provision.	∅	∅	∅	MQ	UGI UT/TGP MARIENVILLE PA FOREST	95	420173	ZONE 4	1000	0	∅	∅	2026-10-31 05:35:57.963869
2025-04-01 00:00:00.000000	2026-10-31 05:35:57.664858	2025	2	iC0000202504	2746;;2747	TENNESSEE GAS PIPELINE COMPANY, L.L.C.	C000020	4/1/2025	4/1/2025	O	Carlos Oblitas (713)420-5771	Dth	Dth	Dth	Dth	∅	∅	UGI ENERGY SERVICES, LLC	883504581	N	FT-A	41201-FTATGP	4/1/2003	3/31/2028	∅	N	18000	0	n1	The Contract Primary Term Expiration Date has not passed. Contract may or may not continue under an "evergreen" or "rollover" provision.	∅	∅	∅	MQ	CON ED/TGP WHITE PLAINS NY WESTCHES	95	420093	ZONE 5	18000	0	∅	∅	2026-10-31 05:35:57.963869

Coverage

Complete: 1.1%
Gap days: 4,246
Days with data: 47

Show coverage history

Coverage: 1.1%Days with data: 47Gaps: 4,246

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

gaplessmore

Related data

Related infrastructure data
Dataset	Description
FERC Filer to Pipeline System Crosswalk (computed)FERC · Follows the FERC Form 549B load (quarterly filings)	Maps each FERC company ID that files Form 549B (gas_pipeline_ebb.ferc_index_of_customers) to the pipeline system slug used across Ask the Grid's gas data, so a contract book can be joined to that pipeline's nominations, capacity, notices and map. One row per company ID with pipeline_slug, the names the filer used (filed_names), its filed_rows and first and last quarter. The same company files under several IDs (a legacy number, a FERC company identifier such as C000020 from 2016, sometimes both), so one pipeline_slug can appear on several rows. pipeline_slug is set only where a filed name equals a registered system's legal name after case, ampersand and punctuation are normalised; every other filer, and any ID whose names match two systems, has a null pipeline_slug and is not guessed at. Many storage fields, gatherers and renamed filers are unmatched, so a null means unmapped, not not-a-pipeline. FERC's DATA_ERROR and blank IDs are excluded.
Advanced MetersEIA · annual (report year)	EIA-861 advanced metering: AMR, AMI and other meter counts, AMI energy served and customer access, by utility and customer class. Advanced_Meters, one row per utility, state, balancing authority and customer class. customer_class is residential, commercial, industrial, transportation (direct_connected in the distributed generation tables) or EIA's own total, so summing classes without excluding total counts everything twice. event_time is 1 January of the report year. release is final or early_release: EIA posts an early release of a year in August and replaces it with the final file in the autumn, and the mirror keeps the newest row per key. A key cell EIA leaves blank is '' or 0, and duplicate_index numbers rows that still share a key, in workbook order.
AESO Asset ListAESO · daily snapshot	AESO's registry of market assets: asset code, name, pool participant, operating status and asset type (source, sink and others), including retired assets.
Alberta (AESO) Price LocationsAESO · slow-moving dimension, refreshed every 6 hours	Every Alberta (AESO) location that carries a price, as three columns: location_id, name, and kind. 1 rows — system (1). This is the dimension the Alberta (AESO) price, and where applicable constraint, tables join to, and it is the one place a location's type is decided: resolve "which hubs exist", "is this a zone or a node", or "give me the readable name for this id" here rather than inferring a type from a name prefix. For Alberta, the one location_id is SYSTEM: the pool price (aeso.pool_price) and system marginal price (aeso.system_marginal_price) are system-wide and carry no location column. Alberta has no nodal, zonal or hub prices; do not look for one. Generating assets are identified by AESO asset code in aeso.unit_status and aeso.asset_list, not here. The same three columns exist for every market, so the equivalent question in another ISO is the same query against that ISO's table.