Gas Contract and Capacity Release Source Documents

Provenance and content hashes for original public shipper-contract, firm, interruptible, capacity-release and offer reports, including advertised historical Algonquin and Texas Eastern archives and each individual archive member.

Native record
pipeline x source URL x archive member x observation
Daily source checks and publisher-listed historical backfills publication cadence
Evidence
Reference data
Stable context used to interpret other datasets
Time basis
Point-in-time records
UTC · event_time

Overview

The SQL table holds document metadata and original blob pointers, not extracted award economics or PDF text. Individual reports are separately indexed for document search. ZIP containers, overlapping monthly/full-year archives and repeated observations must not be counted as separate commercial transactions. observed_at is capture time; historical publication labels remain native text in titles and source records.

Query contract

Count distinct sha256 for distinct original bytes, with content_type='application/zip' treated separately as archive containers. Keep source_url and source_member for citation; neither document rows nor content hashes are transaction counts.

Analysis rules

  • Group only after preserving the declared grain: event_time, pipeline_slug, source_url, source_member.

Interpretation

  • event_time and observed_at are capture clocks, not inferred historical report dates. Archives overlap and advertised history does not guarantee continuous calendar coverage. SQL exposes metadata, not PDF contents.

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

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

Schema14

Column
Type
event_timeDateTime64(6, 'UTC')
observed_atDateTime64(6, 'UTC')
pipeline_slugString
source_urlString
source_memberString
report_kindString
titleString
published_time_rawString
source_recordString
object_pathString
content_typeString
size_bytesInt64
sha256String
ingested_atDateTime64(6, 'UTC')

Sample data

event_timeobserved_atpipeline_slugsource_urlsource_memberreport_kindtitlepublished_time_rawsource_recordobject_pathcontent_typesize_bytessha256ingested_at
2026-10-19 03:29:16.5775172026-10-19 03:29:16.577517wmb_transcohttps://www.1line.williams.com/portal-service/api/portal-service/v1/public/pdf-proxy?url=H1q8kQLsvgAytQgUFhZldXHFHgDBZPxL_yrkfPhvQFLcV7Bfd30CO6kop0u065MV9KXeQsJQv0AZ95QYm4dv3vIPKgCGqwPPDWEJXlkV2plz4b9qO6KwQuLsS78RpPaq&filename=Transactional+Contracts+-+Interruptible.pdf&fileName=Transactional+Contracts+-+Interruptible.pdftransaction_14Transactional Contracts - Interruptible10/18/2026 18:45:43 CDT{"postDate": "10/18/2026 18:45:43 CDT", "description": "Transactional Contracts - Interruptible", "networkPath": "H1q8kQLsvgAytQgUFhZldXHFHgDBZPxL_yrkfPhvQFLcV7Bfd30CO6kop0u065MV9KXeQsJQv0AZ95QYm4dv3vIPKgCGqwPPDWEJXlkV2plz4b9qO6KwQuLsS78RpPaq", "networkPathExcel": null, "buttonLabel": ".pdf", "dataButtonLabel": null, "buId": 0, "pipeId": null, "pageTitle": null, "dtc": null, "pre": null, "category": null, "format": ".pdf"}ea/ea7448401362c73886efd61edfc1a3537db22cbd7d0bab95c9018977fec56d44application/pdf105100ea7448401362c73886efd61edfc1a3537db22cbd7d0bab95c9018977fec56d442026-10-19 03:29:16.934934
2026-10-19 03:29:15.8810512026-10-19 03:29:15.881051wmb_transcohttps://www.1line.williams.com/portal-service/api/portal-service/v1/public/document-list?buId=80&category=Transaction&dtc=14document_listingTransco Transaction 14 listing{}83/833d311ca0aa9de9447624db49ea893ccc52eaeea83018c4f1577e2facea1403application/json37385833d311ca0aa9de9447624db49ea893ccc52eaeea83018c4f1577e2facea14032026-10-19 03:29:16.228103
2026-10-19 03:29:05.0710802026-10-19 03:29:05.071080wmb_transcohttps://www.1line.williams.com/portal-service/api/portal-service/v1/public/pdf-proxy?url=H1q8kQLsvgAytQgUFhZldXHFHgDBZPxL_yrkfPhvQFLcV7Bfd30CO6kop0u065MVDOLb7AOV2jjwIh8gVKpojBce3Fr8NvwRNyIRftwV7OWy81JhBW9SBhxNw4N3191t&filename=Transactional+Contracts-+Firm+-+No+Updated+Data.pdf&fileName=Transactional+Contracts-+Firm+-+No+Updated+Data.pdftransaction_11Transactional Contracts- Firm - No Updated Data10/18/2026 18:45:42 CDT{"postDate": "10/18/2026 18:45:42 CDT", "description": "Transactional Contracts- Firm - No Updated Data", "networkPath": "H1q8kQLsvgAytQgUFhZldXHFHgDBZPxL_yrkfPhvQFLcV7Bfd30CO6kop0u065MVDOLb7AOV2jjwIh8gVKpojBce3Fr8NvwRNyIRftwV7OWy81JhBW9SBhxNw4N3191t", "networkPathExcel": null, "buttonLabel": ".pdf", "dataButtonLabel": null, "buId": 0, "pipeId": null, "pageTitle": null, "dtc": null, "pre": null, "category": null, "format": ".pdf"}80/800dd9732d82aef0dbb5ea2f7498138c6b03f5bc08e16f767f47bc3f036a5f3capplication/pdf46745800dd9732d82aef0dbb5ea2f7498138c6b03f5bc08e16f767f47bc3f036a5f3c2026-10-19 03:29:05.409019
2026-10-19 03:29:04.4049542026-10-19 03:29:04.404954wmb_transcohttps://www.1line.williams.com/portal-service/api/portal-service/v1/public/document-list?buId=80&category=Transaction&dtc=11document_listingTransco Transaction 11 listing{}ef/ef3368107942d6a5a60e5087341b665b882f7c38542e5f70b34ba27075da8c30application/json37212ef3368107942d6a5a60e5087341b665b882f7c38542e5f70b34ba27075da8c302026-10-19 03:29:04.794632
2026-10-19 03:28:54.0046232026-10-19 03:28:54.004623wmb_transcohttps://www.1line.williams.com/portal-service/api/portal-service/v1/public/pdf-proxy?url=H1q8kQLsvgAytQgUFhZldXHFHgDBZPxL_yrkfPhvQFLcV7Bfd30CO6kop0u065MVdkUhvGEo6K-JfzFCC9A07RzkwXMS8rwjUXLMOAgvq5ey81JhBW9SBhxNw4N3191t&filename=Transactional+Contracts-+Capacity+Release+-+No+Updated+Data.pdf&fileName=Transactional+Contracts-+Capacity+Release+-+No+Updated+Data.pdftransaction_15Transactional Contracts- Capacity Release - No Updated Data10/18/2026 18:45:42 CDT{"postDate": "10/18/2026 18:45:42 CDT", "description": "Transactional Contracts- Capacity Release - No Updated Data", "networkPath": "H1q8kQLsvgAytQgUFhZldXHFHgDBZPxL_yrkfPhvQFLcV7Bfd30CO6kop0u065MVdkUhvGEo6K-JfzFCC9A07RzkwXMS8rwjUXLMOAgvq5ey81JhBW9SBhxNw4N3191t", "networkPathExcel": null, "buttonLabel": ".pdf", "dataButtonLabel": null, "buId": 0, "pipeId": null, "pageTitle": null, "dtc": null, "pre": null, "category": null, "format": ".pdf"}0b/0b24b1b45415f6ebf9b40e691a0a726004eb96a0a1df70cbda731abaf88bed7eapplication/pdf474470b24b1b45415f6ebf9b40e691a0a726004eb96a0a1df70cbda731abaf88bed7e2026-10-19 03:28:54.309310
2026-10-19 03:28:53.4201382026-10-19 03:28:53.420138wmb_transcohttps://www.1line.williams.com/portal-service/api/portal-service/v1/public/document-list?buId=80&category=Transaction&dtc=15document_listingTransco Transaction 15 listing{}a8/a8b5790afbb97668d93fdfb36470b364c580c5f6a9e05bcfc264769dea05cc9eapplication/json37556a8b5790afbb97668d93fdfb36470b364c580c5f6a9e05bcfc264769dea05cc9e2026-10-19 03:28:53.754892
2026-10-19 03:27:55.4884372026-10-19 03:27:55.488437lnk_tehttps://infopost.enbridge.com/api/gotolink-document?Pipe=10076&DocumentType=OFFERLISTREPORT&Environment=Production&DocumentId=8a9cae90a151ffa901a151ffdc6d010ecapacity_offersCapacity Available Through Capacity Release [NO DATA]10/18/2026{"PostingDate": "10/18/2026", "Name": "Capacity Available Through Capacity Release [NO DATA]", "Identifier": "8a9cae90a151ffa901a151ffdc6d010e"}4c/4ca61cee3a58ce6aa304e90728362cb7c71d8617ed3eb93fb8cabfc801b8d10dapplication/pdf76204ca61cee3a58ce6aa304e90728362cb7c71d8617ed3eb93fb8cabfc801b8d10d2026-10-19 03:27:55.845008
2026-10-19 03:27:54.4969182026-10-19 03:27:54.496918lnk_tehttps://infopost.enbridge.com/api/offer-list?businessUnit=TE&fileName=OFFERS_Tetco.jsondocument_listinglnk_te capacity offer listing{}82/8254ebcff1d230c5a7bff0a3de46a4f035e3fc2b424d10edda36f9a65776ffa1application/json122608254ebcff1d230c5a7bff0a3de46a4f035e3fc2b424d10edda36f9a65776ffa12026-10-19 03:27:54.875991
2026-10-19 03:27:14.9620572026-10-19 03:27:14.962057lnk_tehttps://infopost.enbridge.com/api/gotolink-document?Pipe=10076&DocumentType=TRANSACTIONALREPORT&Environment=Production&RefId=8a9cae90a151ffa901a151ffc38b005ainterruptibleTransactional Reports - Interruptible [NO DATA]10/18/2026{"PostingDate": "10/18/2026", "Name": "Transactional Reports - Interruptible [NO DATA]", "Identifier": "8a9cae90a151ffa901a151ffc38b005a"}04/0444aeadaa20a91731ae110874583b0932502855ff160a4e3f5431d6287b58bcapplication/pdf76160444aeadaa20a91731ae110874583b0932502855ff160a4e3f5431d6287b58bc2026-10-19 03:27:15.313297
2026-10-19 03:27:14.0774962026-10-19 03:27:14.077496lnk_tehttps://infopost.enbridge.com/api/transactional-report?businessUnit=TE&reportType=Interruptible&fileName=TR_Tetco_Interruptible.jsondocument_listinglnk_te interruptible listing{}f1/f1a63a4619ba41c7c0b215d32ba9157f59d981f157cb1a5680ee48b1bbe0dee9application/json11973f1a63a4619ba41c7c0b215d32ba9157f59d981f157cb1a5680ee48b1bbe0dee92026-10-19 03:27:14.455426
2026-10-19 03:26:35.1918272026-10-19 03:26:35.191827lnk_tehttps://infopost.enbridge.com/api/gotolink-document?Pipe=10076&DocumentType=TRANSACTIONALREPORT&Environment=Production&RefId=8a9cae90a151ffa901a151ffcfbb00b4firmTransactional Reports - Firm [NO DATA]10/18/2026{"PostingDate": "10/18/2026", "Name": "Transactional Reports - Firm [NO DATA]", "Identifier": "8a9cae90a151ffa901a151ffcfbb00b4"}f0/f0695e66f09ab0d8fe299ef8ca8259e1344747142e749df4ac900f7f51eed493application/pdf7610f0695e66f09ab0d8fe299ef8ca8259e1344747142e749df4ac900f7f51eed4932026-10-19 03:26:35.590028
2026-10-19 03:26:34.1765252026-10-19 03:26:34.176525lnk_tehttps://infopost.enbridge.com/api/transactional-report?businessUnit=TE&reportType=Firm&fileName=TR_Tetco_Firm.jsondocument_listinglnk_te firm listing{}5a/5afa8f1195f9e62dcce5999ccf112b0338f56834624339a04a3b66f2003390d2application/json111845afa8f1195f9e62dcce5999ccf112b0338f56834624339a04a3b66f2003390d22026-10-19 03:26:34.565795
2026-10-19 03:25:53.2465832026-10-19 03:25:53.246583lnk_tehttps://infopost.enbridge.com/api/gotolink-document?Pipe=10076&DocumentType=TRANSACTIONALREPORT&Environment=Production&RefId=8a9cae90a151ffa901a151ffa90a0000capacity_releaseTransactional Reports - Capacity Release [NO DATA]10/18/2026{"PostingDate": "10/18/2026", "Name": "Transactional Reports - Capacity Release [NO DATA]", "Identifier": "8a9cae90a151ffa901a151ffa90a0000"}7b/7bc1f8398b8804d5ea52ff1c0bed005d07d24fe264901768704f130e385329e4application/pdf76217bc1f8398b8804d5ea52ff1c0bed005d07d24fe264901768704f130e385329e42026-10-19 03:25:53.567508
2026-10-19 03:25:52.3652552026-10-19 03:25:52.365255lnk_tehttps://infopost.enbridge.com/api/transactional-report?businessUnit=TE&reportType=CapRel&fileName=TR_Tetco_CapRel.jsondocument_listinglnk_te capacity_release listing{}d0/d00e4e7cea95a1a93f797fb4bb73db6137f0c1655a8daa32981c5113e3fb1048application/json11896d00e4e7cea95a1a93f797fb4bb73db6137f0c1655a8daa32981c5113e3fb10482026-10-19 03:25:52.739881
2026-10-19 03:25:14.4123282026-10-19 03:25:14.412328lnk_aghttps://infopost.enbridge.com/api/gotolink-document?Pipe=10004&DocumentType=OFFERLISTREPORT&Environment=Production&DocumentId=8a9cae90a151ffbe01a151ffef78010ecapacity_offersCapacity Available Through Capacity Release [NO DATA]10/18/2026{"PostingDate": "10/18/2026", "Name": "Capacity Available Through Capacity Release [NO DATA]", "Identifier": "8a9cae90a151ffbe01a151ffef78010e"}6d/6d9dafd7470a0f39e4550ef107c2daeff4e500830ec6c35a5810e2f6aee57f00application/pdf76216d9dafd7470a0f39e4550ef107c2daeff4e500830ec6c35a5810e2f6aee57f002026-10-19 03:25:14.731855
2026-10-19 03:25:13.4658012026-10-19 03:25:13.465801lnk_aghttps://infopost.enbridge.com/api/offer-list?businessUnit=AG&fileName=OFFERS_Agt.jsondocument_listinglnk_ag capacity offer listing{}ea/ea21ec382c7840892249311901cf6a618ee0eb6965da368fe8bb6f7a109fcb7fapplication/json12550ea21ec382c7840892249311901cf6a618ee0eb6965da368fe8bb6f7a109fcb7f2026-10-19 03:25:13.846963
2026-10-19 03:24:34.5938392026-10-19 03:24:34.593839lnk_aghttps://infopost.enbridge.com/api/gotolink-document?Pipe=10004&DocumentType=TRANSACTIONALREPORT&Environment=Production&RefId=8a9cae90a151ffbe01a151ffd57e005ainterruptibleTransactional Reports - Interruptible [NO DATA]10/18/2026{"PostingDate": "10/18/2026", "Name": "Transactional Reports - Interruptible [NO DATA]", "Identifier": "8a9cae90a151ffbe01a151ffd57e005a"}53/53817809fbaea8b4099b3ad361782b2bf86a3b2774d21652acf431f8a77a1d52application/pdf761953817809fbaea8b4099b3ad361782b2bf86a3b2774d21652acf431f8a77a1d522026-10-19 03:24:34.939979
2026-10-19 03:24:33.6911842026-10-19 03:24:33.691184lnk_aghttps://infopost.enbridge.com/api/transactional-report?businessUnit=AG&reportType=Interruptible&fileName=TR_Agt_Interruptible.jsondocument_listinglnk_ag interruptible listing{}72/72154fdf96b98fb4db385dc7ce39f0cedb278549e37c5f0469298a0ab3a27f7dapplication/json1214372154fdf96b98fb4db385dc7ce39f0cedb278549e37c5f0469298a0ab3a27f7d2026-10-19 03:24:34.092540
2026-10-19 03:23:51.1022302026-10-19 03:23:51.102230lnk_aghttps://infopost.enbridge.com/api/gotolink-document?Pipe=10004&DocumentType=TRANSACTIONALREPORT&Environment=Production&RefId=8a9cae90a151ffbe01a151ffe23a00b4firmTransactional Reports - Firm [NO DATA]10/18/2026{"PostingDate": "10/18/2026", "Name": "Transactional Reports - Firm [NO DATA]", "Identifier": "8a9cae90a151ffbe01a151ffe23a00b4"}cf/cf43ba7322c08f10d70eb44d2eb9e4003ffcbd18e0a8125268596a2cf489e131application/pdf7614cf43ba7322c08f10d70eb44d2eb9e4003ffcbd18e0a8125268596a2cf489e1312026-10-19 03:23:51.431021
2026-10-19 03:23:50.1613762026-10-19 03:23:50.161376lnk_aghttps://infopost.enbridge.com/api/transactional-report?businessUnit=AG&reportType=Firm&fileName=TR_Agt_Firm.jsondocument_listinglnk_ag firm listing{}47/479c364b1d0e93448ed405f4a26359a15049f0edb5c1ebaa71fb3f934b3b0132application/json11294479c364b1d0e93448ed405f4a26359a15049f0edb5c1ebaa71fb3f934b3b01322026-10-19 03:23:50.522975
2026-10-19 03:23:09.7522482026-10-19 03:23:09.752248lnk_aghttps://infopost.enbridge.com/api/gotolink-document?Pipe=10004&DocumentType=TRANSACTIONALREPORT&Environment=Production&RefId=8a9cae90a151ffbe01a151ffbeef0000capacity_releaseTransactional Reports - Capacity Release [NO DATA]10/18/2026{"PostingDate": "10/18/2026", "Name": "Transactional Reports - Capacity Release [NO DATA]", "Identifier": "8a9cae90a151ffbe01a151ffbeef0000"}a3/a39dd8ee69de2fd271c6d003245b4da26d1e07fa3b4c5f177623f9a17205e08fapplication/pdf7619a39dd8ee69de2fd271c6d003245b4da26d1e07fa3b4c5f177623f9a17205e08f2026-10-19 03:23:10.076527
2026-10-19 03:23:07.5356852026-10-19 03:23:07.535685lnk_aghttps://infopost.enbridge.com/api/transactional-report?businessUnit=AG&reportType=CapRel&fileName=TR_Agt_CapRel.jsondocument_listinglnk_ag capacity_release listing{}66/66bcb4c9115f2c6fba3568b421ef9a79e25163b5bb5034a6a29c8c9aa56374c0application/json1176666bcb4c9115f2c6fba3568b421ef9a79e25163b5bb5034a6a29c8c9aa56374c02026-10-19 03:23:09.187931
2026-10-19 00:16:24.4326692026-10-19 00:16:24.432669lnk_aghttps://infopost.enbridge.com/api/historical-transactional/download?pipelineCode=AGT&reportType=CR&year=2023&fileName=Full+Year+2023.zipAGT_TR_CapRel-12-31-2023_Run5.pdfcapacity_release_archiveAGT_TR_CapRel-12-31-2023_Run5.pdf2026-08-20T19:25:05Z{"FileName": "Full Year 2023.zip", "Year": "2023", "SizeInBytes": 69370378, "LastModified": "2026-08-20T19:25:05Z", "DisplayName": "Full Year 2023"}3c/3cf4e4133b353f58aa9fa07dc2c19e59030e8139d0300b692a8a4de747d8dfb2application/pdf76223cf4e4133b353f58aa9fa07dc2c19e59030e8139d0300b692a8a4de747d8dfb22026-10-19 00:16:24.701671
2026-10-19 00:16:23.9798532026-10-19 00:16:23.979853lnk_aghttps://infopost.enbridge.com/api/historical-transactional/download?pipelineCode=AGT&reportType=CR&year=2023&fileName=Full+Year+2023.zipAGT_TR_CapRel-12-31-2023_Run4.pdfcapacity_release_archiveAGT_TR_CapRel-12-31-2023_Run4.pdf2026-08-20T19:25:05Z{"FileName": "Full Year 2023.zip", "Year": "2023", "SizeInBytes": 69370378, "LastModified": "2026-08-20T19:25:05Z", "DisplayName": "Full Year 2023"}cf/cf1fdc066149007241018c450725d1cd6cb80ee9d174b86148b889984e527348application/pdf7624cf1fdc066149007241018c450725d1cd6cb80ee9d174b86148b889984e5273482026-10-19 00:16:24.270321
2026-10-19 00:16:23.5584002026-10-19 00:16:23.558400lnk_aghttps://infopost.enbridge.com/api/historical-transactional/download?pipelineCode=AGT&reportType=CR&year=2023&fileName=Full+Year+2023.zipAGT_TR_CapRel-12-31-2023_Run3.pdfcapacity_release_archiveAGT_TR_CapRel-12-31-2023_Run3.pdf2026-08-20T19:25:05Z{"FileName": "Full Year 2023.zip", "Year": "2023", "SizeInBytes": 69370378, "LastModified": "2026-08-20T19:25:05Z", "DisplayName": "Full Year 2023"}b1/b1053fc4c40cabb3206501f6559855354a5de7576f42a34ef9ad5b3d5317a7ccapplication/pdf7625b1053fc4c40cabb3206501f6559855354a5de7576f42a34ef9ad5b3d5317a7cc2026-10-19 00:16:23.872313

Coverage

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