Ask the Grid

Gas Pipeline Shipper Contracts and Contract Points

Native Index of Customers records from Algonquin, Tennessee, Texas Eastern and Transco, retaining H/D/A/P/F record types, shipper and contract identifiers, effective and expiration text, raw MDQ values and units, point qualifiers and parent row relationships.

FERC EBBInfrastructure dataERCOT marketNYISO marketCAISO marketPJM marketMISO marketISO-NE marketSPP market
Query with the agent
Native record
pipeline x source document/member x native record row x snapshot
Daily source checks; publisher contract snapshots publication cadence
Evidence
Reference data
Stable context used to interpret other datasets
Time basis
Point-in-time records
UTC · event_time

Overview

D records describe contracts; P records describe their points and are not additional contracts. These are contractual rights declarations, not metered gas flow or capacity-release awards. Use the latest snapshot separately for each pipeline and preserve native units before comparing quantities.

Query contract

Select max(observed_at) separately for each pipeline. Filter record_type='D' for contract records and record_type='P' for contract-point records; use parent_source_row to reconstruct native hierarchy within the same source snapshot and document.

Analysis rules

  • Do not sum MDQ across H/D/A/P/F record types, contract points, pipelines with different units, or historical snapshots. Parse raw units and dates explicitly before comparison.

Interpretation

  • Contract MDQ is a declared right, not available capacity, scheduled quantity or delivered fuel. No current assessed gas prices are supplied.

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.

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_rights_records/query

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

Schema39

Column
Type
event_timeDateTime64(6, 'UTC')
observed_atDateTime64(6, 'UTC')
pipeline_slugString
source_urlString
source_memberString
source_rowInt64
parent_source_rowNullable(Int64)
record_typeString
report_quarter_rawNullable(String)
report_date_rawNullable(String)
pipeline_nameNullable(String)
pipeline_idNullable(String)
transport_unit_rawNullable(String)
storage_unit_rawNullable(String)
original_revised_rawNullable(String)
shipper_nameNullable(String)
shipper_idNullable(String)
affiliate_indicatorNullable(String)
rate_scheduleNullable(String)
contract_idNullable(String)
contract_effective_rawNullable(String)
contract_expiration_rawNullable(String)
rollover_rawNullable(String)
negotiated_rate_indicatorNullable(String)
transport_mdq_rawNullable(String)
storage_mdq_rawNullable(String)
agent_nameNullable(String)
agent_affiliate_indicatorNullable(String)
point_roleNullable(String)
point_nameNullable(String)
point_qualifierNullable(String)
point_idNullable(String)
zone_rawNullable(String)
point_transport_mdq_rawNullable(String)
point_storage_mdq_rawNullable(String)
footnote_idNullable(String)
footnote_textNullable(String)
source_recordString
ingested_atDateTime64(6, 'UTC')

Sample data

event_timeobserved_atpipeline_slugsource_urlsource_membersource_rowparent_source_rowrecord_typereport_quarter_rawreport_date_rawpipeline_namepipeline_idtransport_unit_rawstorage_unit_raworiginal_revised_rawshipper_nameshipper_idaffiliate_indicatorrate_schedulecontract_idcontract_effective_rawcontract_expiration_rawrollover_rawnegotiated_rate_indicatortransport_mdq_rawstorage_mdq_rawagent_nameagent_affiliate_indicatorpoint_rolepoint_namepoint_qualifierpoint_idzone_rawpoint_transport_mdq_rawpoint_storage_mdq_rawfootnote_idfootnote_textsource_recordingested_at
2026-10-18 22:21:22.4611562026-10-18 22:21:22.461156lnk_tehttps://infopost.enbridge.com/api/ioc?businessUnit=TE&type=IOC&customerType=IOCiocFootNotes/993000∅F∅10/01/2026Texas Eastern Transmission, LPTETT∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅XNo primary receipt points are designated; secondary points are available in the following zones: STX, ETX, WLA, ELA{"iocDataType": "F", "businessUnitID": "10076", "footnoteId": 100, "footnoteItemId": "X", "footnoteText": "No primary receipt points are designated; secondary points are available in the following zones: STX, ETX, WLA, ELA", "reportId": 203}2026-10-18 22:21:24.484410
2026-10-18 22:21:22.4611562026-10-18 22:21:22.461156lnk_tehttps://infopost.enbridge.com/api/ioc?businessUnit=TE&type=IOC&customerType=IOCiocFootNotes/982999∅F∅10/01/2026Texas Eastern Transmission, LPTETT∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅XNo primary receipt points are designated; secondary points are available in the following zones: ETX, M1{"iocDataType": "F", "businessUnitID": "10076", "footnoteId": 99, "footnoteItemId": "X", "footnoteText": "No primary receipt points are designated; secondary points are available in the following zones: ETX, M1", "reportId": 203}2026-10-18 22:21:24.484410
2026-10-18 22:21:22.4611562026-10-18 22:21:22.461156lnk_tehttps://infopost.enbridge.com/api/ioc?businessUnit=TE&type=IOC&customerType=IOCiocFootNotes/972998∅F∅10/01/2026Texas Eastern Transmission, LPTETT∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅LOriginal contract effective date: 01/01/2019{"iocDataType": "F", "businessUnitID": "10076", "footnoteId": 98, "footnoteItemId": "L", "footnoteText": "Original contract effective date: 01/01/2019", "reportId": 203}2026-10-18 22:21:24.484410
2026-10-18 22:21:22.4611562026-10-18 22:21:22.461156lnk_tehttps://infopost.enbridge.com/api/ioc?businessUnit=TE&type=IOC&customerType=IOCiocFootNotes/962997∅F∅10/01/2026Texas Eastern Transmission, LPTETT∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅LOriginal contract effective date: 12/01/2015{"iocDataType": "F", "businessUnitID": "10076", "footnoteId": 97, "footnoteItemId": "L", "footnoteText": "Original contract effective date: 12/01/2015", "reportId": 203}2026-10-18 22:21:24.484410
2026-10-18 22:21:22.4611562026-10-18 22:21:22.461156lnk_tehttps://infopost.enbridge.com/api/ioc?businessUnit=TE&type=IOC&customerType=IOCiocFootNotes/952996∅F∅10/01/2026Texas Eastern Transmission, LPTETT∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅LOriginal contract effective date: 11/20/2015{"iocDataType": "F", "businessUnitID": "10076", "footnoteId": 96, "footnoteItemId": "L", "footnoteText": "Original contract effective date: 11/20/2015", "reportId": 203}2026-10-18 22:21:24.484410
2026-10-18 22:21:22.4611562026-10-18 22:21:22.461156lnk_tehttps://infopost.enbridge.com/api/ioc?businessUnit=TE&type=IOC&customerType=IOCiocFootNotes/942995∅F∅10/01/2026Texas Eastern Transmission, LPTETT∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅OVarying MDQ quantities as follows: 23580 dth - Nov 1-Mar 31, 0 dth - Apr 1-Oct 31{"iocDataType": "F", "businessUnitID": "10076", "footnoteId": 95, "footnoteItemId": "O", "footnoteText": "Varying MDQ quantities as follows: 23580 dth - Nov 1-Mar 31, 0 dth - Apr 1-Oct 31", "reportId": 203}2026-10-18 22:21:24.484410
2026-10-18 22:21:22.4611562026-10-18 22:21:22.461156lnk_tehttps://infopost.enbridge.com/api/ioc?businessUnit=TE&type=IOC&customerType=IOCiocFootNotes/932994∅F∅10/01/2026Texas Eastern Transmission, LPTETT∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅LOriginal contract effective date: 11/01/1997{"iocDataType": "F", "businessUnitID": "10076", "footnoteId": 94, "footnoteItemId": "L", "footnoteText": "Original contract effective date: 11/01/1997", "reportId": 203}2026-10-18 22:21:24.484410
2026-10-18 22:21:22.4611562026-10-18 22:21:22.461156lnk_tehttps://infopost.enbridge.com/api/ioc?businessUnit=TE&type=IOC&customerType=IOCiocFootNotes/922993∅F∅10/01/2026Texas Eastern Transmission, LPTETT∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅OVarying MDQ quantities as follows: 31225 dth - Dec 1-Apr 30, 10500 dth - May 1-Nov 30{"iocDataType": "F", "businessUnitID": "10076", "footnoteId": 93, "footnoteItemId": "O", "footnoteText": "Varying MDQ quantities as follows: 31225 dth - Dec 1-Apr 30, 10500 dth - May 1-Nov 30", "reportId": 203}2026-10-18 22:21:24.484410
2026-10-18 22:21:22.4611562026-10-18 22:21:22.461156lnk_tehttps://infopost.enbridge.com/api/ioc?businessUnit=TE&type=IOC&customerType=IOCiocFootNotes/912992∅F∅10/01/2026Texas Eastern Transmission, LPTETT∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅LOriginal contract effective date: 12/01/1998{"iocDataType": "F", "businessUnitID": "10076", "footnoteId": 92, "footnoteItemId": "L", "footnoteText": "Original contract effective date: 12/01/1998", "reportId": 203}2026-10-18 22:21:24.484410
2026-10-18 22:21:22.4611562026-10-18 22:21:22.461156lnk_tehttps://infopost.enbridge.com/api/ioc?businessUnit=TE&type=IOC&customerType=IOCiocFootNotes/902991∅F∅10/01/2026Texas Eastern Transmission, LPTETT∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅LOriginal contract effective date: 11/01/2008{"iocDataType": "F", "businessUnitID": "10076", "footnoteId": 91, "footnoteItemId": "L", "footnoteText": "Original contract effective date: 11/01/2008", "reportId": 203}2026-10-18 22:21:24.484410
2026-10-18 22:21:22.4611562026-10-18 22:21:22.461156lnk_tehttps://infopost.enbridge.com/api/ioc?businessUnit=TE&type=IOC&customerType=IOCiocFootNotes/92910∅F∅10/01/2026Texas Eastern Transmission, LPTETT∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅XNo primary receipt points are designated; secondary points are available in the following zones: M3{"iocDataType": "F", "businessUnitID": "10076", "footnoteId": 10, "footnoteItemId": "X", "footnoteText": "No primary receipt points are designated; secondary points are available in the following zones: M3", "reportId": 203}2026-10-18 22:21:24.484410
2026-10-18 22:21:22.4611562026-10-18 22:21:22.461156lnk_tehttps://infopost.enbridge.com/api/ioc?businessUnit=TE&type=IOC&customerType=IOCiocFootNotes/892990∅F∅10/01/2026Texas Eastern Transmission, LPTETT∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅LOriginal contract effective date: 07/01/1995{"iocDataType": "F", "businessUnitID": "10076", "footnoteId": 90, "footnoteItemId": "L", "footnoteText": "Original contract effective date: 07/01/1995", "reportId": 203}2026-10-18 22:21:24.484410
2026-10-18 22:21:22.4611562026-10-18 22:21:22.461156lnk_tehttps://infopost.enbridge.com/api/ioc?businessUnit=TE&type=IOC&customerType=IOCiocFootNotes/882989∅F∅10/01/2026Texas Eastern Transmission, LPTETT∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅LOriginal contract effective date: 11/17/1995{"iocDataType": "F", "businessUnitID": "10076", "footnoteId": 89, "footnoteItemId": "L", "footnoteText": "Original contract effective date: 11/17/1995", "reportId": 203}2026-10-18 22:21:24.484410
2026-10-18 22:21:22.4611562026-10-18 22:21:22.461156lnk_tehttps://infopost.enbridge.com/api/ioc?businessUnit=TE&type=IOC&customerType=IOCiocFootNotes/872988∅F∅10/01/2026Texas Eastern Transmission, LPTETT∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅LOriginal contract effective date: 10/01/2015{"iocDataType": "F", "businessUnitID": "10076", "footnoteId": 88, "footnoteItemId": "L", "footnoteText": "Original contract effective date: 10/01/2015", "reportId": 203}2026-10-18 22:21:24.484410
2026-10-18 22:21:22.4611562026-10-18 22:21:22.461156lnk_tehttps://infopost.enbridge.com/api/ioc?businessUnit=TE&type=IOC&customerType=IOCiocFootNotes/862987∅F∅10/01/2026Texas Eastern Transmission, LPTETT∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅LOriginal contract effective date: 05/01/2004{"iocDataType": "F", "businessUnitID": "10076", "footnoteId": 87, "footnoteItemId": "L", "footnoteText": "Original contract effective date: 05/01/2004", "reportId": 203}2026-10-18 22:21:24.484410
2026-10-18 22:21:22.4611562026-10-18 22:21:22.461156lnk_tehttps://infopost.enbridge.com/api/ioc?businessUnit=TE&type=IOC&customerType=IOCiocFootNotes/852986∅F∅10/01/2026Texas Eastern Transmission, LPTETT∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅OVarying MDQ quantities as follows: 400 dth - Nov 1-Mar 31, 0 dth - Apr 1-Oct 31{"iocDataType": "F", "businessUnitID": "10076", "footnoteId": 86, "footnoteItemId": "O", "footnoteText": "Varying MDQ quantities as follows: 400 dth - Nov 1-Mar 31, 0 dth - Apr 1-Oct 31", "reportId": 203}2026-10-18 22:21:24.484410
2026-10-18 22:21:22.4611562026-10-18 22:21:22.461156lnk_tehttps://infopost.enbridge.com/api/ioc?businessUnit=TE&type=IOC&customerType=IOCiocFootNotes/842985∅F∅10/01/2026Texas Eastern Transmission, LPTETT∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅OVarying MDQ quantities as follows: 2000 dth - Nov 1-Mar 31, 0 dth - Apr 1-Oct 31{"iocDataType": "F", "businessUnitID": "10076", "footnoteId": 85, "footnoteItemId": "O", "footnoteText": "Varying MDQ quantities as follows: 2000 dth - Nov 1-Mar 31, 0 dth - Apr 1-Oct 31", "reportId": 203}2026-10-18 22:21:24.484410
2026-10-18 22:21:22.4611562026-10-18 22:21:22.461156lnk_tehttps://infopost.enbridge.com/api/ioc?businessUnit=TE&type=IOC&customerType=IOCiocFootNotes/832984∅F∅10/01/2026Texas Eastern Transmission, LPTETT∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅LOriginal contract effective date: 11/01/2005{"iocDataType": "F", "businessUnitID": "10076", "footnoteId": 84, "footnoteItemId": "L", "footnoteText": "Original contract effective date: 11/01/2005", "reportId": 203}2026-10-18 22:21:24.484410
2026-10-18 22:21:22.4611562026-10-18 22:21:22.461156lnk_tehttps://infopost.enbridge.com/api/ioc?businessUnit=TE&type=IOC&customerType=IOCiocFootNotes/822983∅F∅10/01/2026Texas Eastern Transmission, LPTETT∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅LOriginal contract effective date: 10/01/1998{"iocDataType": "F", "businessUnitID": "10076", "footnoteId": 83, "footnoteItemId": "L", "footnoteText": "Original contract effective date: 10/01/1998", "reportId": 203}2026-10-18 22:21:24.484410
2026-10-18 22:21:22.4611562026-10-18 22:21:22.461156lnk_tehttps://infopost.enbridge.com/api/ioc?businessUnit=TE&type=IOC&customerType=IOCiocFootNotes/812982∅F∅10/01/2026Texas Eastern Transmission, LPTETT∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅LOriginal contract effective date: 12/01/2024{"iocDataType": "F", "businessUnitID": "10076", "footnoteId": 82, "footnoteItemId": "L", "footnoteText": "Original contract effective date: 12/01/2024", "reportId": 203}2026-10-18 22:21:24.484410
2026-10-18 22:21:22.4611562026-10-18 22:21:22.461156lnk_tehttps://infopost.enbridge.com/api/ioc?businessUnit=TE&type=IOC&customerType=IOCiocFootNotes/802981∅F∅10/01/2026Texas Eastern Transmission, LPTETT∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅LOriginal contract effective date: 03/01/2025{"iocDataType": "F", "businessUnitID": "10076", "footnoteId": 81, "footnoteItemId": "L", "footnoteText": "Original contract effective date: 03/01/2025", "reportId": 203}2026-10-18 22:21:24.484410
2026-10-18 22:21:22.4611562026-10-18 22:21:22.461156lnk_tehttps://infopost.enbridge.com/api/ioc?businessUnit=TE&type=IOC&customerType=IOCiocFootNotes/82909∅F∅10/01/2026Texas Eastern Transmission, LPTETT∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅LOriginal contract effective date: 09/01/1994{"iocDataType": "F", "businessUnitID": "10076", "footnoteId": 9, "footnoteItemId": "L", "footnoteText": "Original contract effective date: 09/01/1994", "reportId": 203}2026-10-18 22:21:24.484410
2026-10-18 22:21:22.4611562026-10-18 22:21:22.461156lnk_tehttps://infopost.enbridge.com/api/ioc?businessUnit=TE&type=IOC&customerType=IOCiocFootNotes/792980∅F∅10/01/2026Texas Eastern Transmission, LPTETT∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅LOriginal contract effective date: 03/01/2024{"iocDataType": "F", "businessUnitID": "10076", "footnoteId": 80, "footnoteItemId": "L", "footnoteText": "Original contract effective date: 03/01/2024", "reportId": 203}2026-10-18 22:21:24.484410
2026-10-18 22:21:22.4611562026-10-18 22:21:22.461156lnk_tehttps://infopost.enbridge.com/api/ioc?businessUnit=TE&type=IOC&customerType=IOCiocFootNotes/782979∅F∅10/01/2026Texas Eastern Transmission, LPTETT∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅XNo primary receipt points are designated; secondary points are available in the following zones: M2, M3{"iocDataType": "F", "businessUnitID": "10076", "footnoteId": 79, "footnoteItemId": "X", "footnoteText": "No primary receipt points are designated; secondary points are available in the following zones: M2, M3", "reportId": 203}2026-10-18 22:21:24.484410
2026-10-18 22:21:22.4611562026-10-18 22:21:22.461156lnk_tehttps://infopost.enbridge.com/api/ioc?businessUnit=TE&type=IOC&customerType=IOCiocFootNotes/772978∅F∅10/01/2026Texas Eastern Transmission, LPTETT∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅∅LOriginal contract effective date: 07/01/2020{"iocDataType": "F", "businessUnitID": "10076", "footnoteId": 78, "footnoteItemId": "L", "footnoteText": "Original contract effective date: 07/01/2020", "reportId": 203}2026-10-18 22:21:24.484410

Coverage

100.0% complete0 gap days1 days with data
Show coverage history
Coverage: 100.0%Days with data: 1Gaps: 0
2026
gaplessmore