Public Utility Data Liberation Project (PUDL) Data Release
Authors/Creators
- 1. Catalyst Cooperative
Description
v2026.6.1 (2026-06-19)
This is a monthly PUDL data release, primarily motivated by updating the EIA-860M monthly data through February 2026. As usual, it also includes all of the other changes that have accumulated on main since our last release.
This month, we have the belated EPA CEMS update for 2026Q1, the annual update for FERC 1, some great community contributions for RUS7 and EIA-176, and an assortment of datapackage, Dagster, and deployment notification improvements.
Enhancements
-
Overhauled PUDL’s Frictionless Data Package output to conform to the v2 spec. The
pudl_datapackageDagster asset now generatesdatapackage.jsondirectly during the ETL, including full column types, constraints, and foreign key relationships for every Parquet table. The descriptor is distributed aspudl_parquet_datapackage.jsonat the top level of the S3 bucket and on Zenodo, allowing potential users to browse the PUDL schema without downloading any data. Thepudl_parquet.ziparchive also contains adatapackage.jsondescriptor so it can be used as a self-describing Frictionless package after extraction. A reusablevalid_datapackage_check()factory is now available inpudl.dagster.asset_checksto add frictionless v2 validation as an asset check on any datapackage output. See issues #5122, #5237 and PR #5270, #5343. Also makes progress towards catalyst-cooperative/agent-skills#14 -
Added a bare-bones datapackage for DBF SQLite outputs. See issue #5200 and PR #5275.
New Data
EIA-176
-
Added core_eia176__yearly_gas_supply, which contains cleaned company-level natural and supplemental gas supply data from Part 4 of the EIA-176 survey. See #4711 and #5227.
-
Added core_eia176__yearly_liquefied_natural_gas_inventory, a new table containing annual LNG storage volume and capacity reported by operators on EIA Form 176 Part 5. Data covers 2002-2024 and includes LNG terminal and marine terminal records. See issue #4695 and PR #5219.
Expanded Data Coverage
EIA-191
EIA-860M
FERC 1
-
Added 2025 data from FERC form 1. This update includes several new renewable and energy storage fields in several tables. See issue #5214 and PRs #5236, #5325.
EIA Electricity API
-
Updated the bulk EIA Electricity API data used to fill in redacted fuel prices. See PR #5292.
EPA CEMS
FERC Forms 2 & 6
-
Updated the raw FERC Form 2 and 6 archives to include 2025 data. This data is converted to SQLite, but not deeply integrated into PUDL. See PR #5292.
Documentation
-
Added a data source page for EIA-191. See PR #5267 and issue #4756.
-
Updated the EIA-930 column descriptions to note that starting in 2024Q3 EIA began reporting more granular renewable energy source categories, differentiating wind and solar plants with and without energy storage, splitting pumped hydro from conventional hydro, and adding new battery storage and geothermal categories. See issue #5335 and PR #5336.
New Data Tests & Validations
-
Added validations to RUS7 service interruption tables to ensure subcomponents sum to the total for annual observation periods. See issue #5285 and PR #5286.
Bug Fixes & Data Cleaning
-
Renamed the
fuel_consumed_mmbtucolumn in theout_eia923__fuel_receipts_costs,out_eia923__monthly_fuel_receipts_costs, andout_eia923__yearly_fuel_receipts_coststables. This column is the result of dividingtotal_fuel_costbyfuel_received_mmbtu. The namefuel_consumed_mmbtuwas misleading because the fuel received in these tables is not necessarily consumed in the same month, and the fuel cost is not necessarily associated with fuel received in the same month. The new name,fuel_received_mmbtu, more accurately reflects what the column actually contains. See PR #5294. -
Fixed a bug in the Zenodo Data Release script which was not actually skipping top-level directories when deciding what to upload to Zenodo, which caused release failures once we started leaving the
ferc*_xbrldirectories on the filesystem. See PR #5254.
Quality of Life Improvements
-
Refactored Dagster-managed path handling to use a dedicated
pudl_pathsresource instead of constructingpudl.workspace.setup.PudlPathsdirectly throughout assets, IO managers, and tests. This makes path resolution more explicit in Dagster contexts and allows interactive definitions to overridepudl_inputandpudl_outputdirectly when callingpudl.dagster.build.build_interactive_defs(). See PR #5261, #5288. -
Added a PUDL devcontainer configuration to make it easier for contributors to get up and running, and to enable the safe use of coding agents in YOLO mode. See PRs #5260, #5287.
-
Cleaned up PUDL’s default Dagster wiring by separating default resources from IO managers, giving shared data-config resources clearer defaults, and simplifying the FERC SQLite IO manager and provenance stack. Consolidated the FERC EQR deployment helper assets with the rest of the Dagster package layout. Created a new Dagster definition builder for use in notebooks and other interactive environments outside of a
dg-spawned environment:pudl.dagster.build.build_interactive_defs(). See issue #5118 and PR #5242. -
Migrated build and deployment notifications from Slack to Zulip. All GitHub Actions workflows that previously posted to Slack now send notifications to the Catalyst Cooperative Zulip instance via the
zulip/github-actions-zulipaction. A newZulipNotificationResourceDagster resource was added to send Zulip stream messages from within assets, with best-effort error handling. The FERC EQR deployment helpers inpudl.dagster.assets.deploy.ferceqrwere updated to use it. Notification coverage was also expanded to include community activity (issues, discussions, comments, and pull requests from non-Catalyst contributors). See PRs #5298, #5328, #5331. -
FERC provenance metadata (Zenodo DOIs, data years, XBRL extractor version) is now stored in the FERC SQLite datapackage files rather than only in Dagster asset metadata. The
ferc_to_sqliteasset can now optionally download and reuse pre-built FERC SQLite outputs from the most recent nightly build, skipping expensive re-extraction when the inputs haven’t changed. SetPUDL_FERC_FORCE_EXTRACT=trueto force re-extraction regardless. See issue #5220 and PR #5264. -
Migrated hashtag-prefixed comments from soon-to-be-machine-generated dbt schema files into their corresponding human-editable schema input files (
dbt/schema_inputs/**/schema.human.yml) to preserve their content, since any regenerated schemas will forcibly strip out hashtag comments. See PR #5310.
Other PUDL v2026.6.1 Resources
- PUDL v2026.6.1 Data Dictionary
- PUDL v2026.6.1 Documentation
- PUDL in the AWS Open Data Registry
- PUDL v2026.6.1 in a free, public AWS S3 bucket: s3://pudl.catalyst.coop/v2026.6.1/
- PUDL v2026.6.1 in a requester-pays GCS bucket: gs://pudl.catalyst.coop/v2026.6.1/
- Zenodo archive of the PUDL GitHub repo for this release
- PUDL v2026.6.1 release on GitHub
Contact Us
If you're using PUDL, we would love to hear from you! Even if it's just a note to let us know that you exist, and how you're using the software or data. Here's a bunch of different ways to get in touch:
- Follow us on GitHub
- Use the PUDL Github issue tracker to let us know about any bugs or data issues you encounter
- GitHub Discussions is where we provide user support.
- Watch our GitHub Project to see what we're working on.
- Email us at hello@catalyst.coop for private communications.
- On Mastodon: @CatalystCoop@mastodon.energy
- On BlueSky: @catalyst.coop
- Connect with us on LinkedIn
- Play with our data and notebooks on Kaggle
- Combine our data with ML models on HuggingFace
- Learn more about us on our website: https://catalyst.coop
- Subscribe to our announcements list for email updates.
Files
censusdp1tract.sqlite.zip
Files
(18.3 GB)
| Name | Size | |
|---|---|---|
|
md5:cf06f6d5dd7c9acce3b03f6c4103cd75
|
8.6 MB | Download |
|
md5:bfbb6b8007031849dd126ed1726cc563
|
506.7 MB | Preview Download |
|
md5:71e67877ac3fcf5ba8a4e8b0ad268118
|
271.3 MB | Preview Download |
|
md5:948860d5c3a68c490b74cddfc12c1d86
|
269.1 kB | Preview Download |
|
md5:ab63733565d1a44cf0bfef5a033119ff
|
1.2 GB | Download |
|
md5:fdeb4e62394efbb806ce396b36ada8bc
|
235.2 MB | Preview Download |
|
md5:5139f4bd484be513b68a22a27ec8ff50
|
202.7 MB | Preview Download |
|
md5:e62bbcfbc0c6ddec5238a4cfc5f1b5dc
|
2.3 MB | Preview Download |
|
md5:ee5c7f18d569c58f3f008b96a16bedff
|
8.5 MB | Preview Download |
|
md5:571d11467b052fee3a2460e9fe5c3ba5
|
73.9 MB | Preview Download |
|
md5:8acb59b41a8fbc7eeae29029b06b6cb4
|
215.6 kB | Preview Download |
|
md5:3dd69bf724d6fccd7d83ba311a211cab
|
162.8 MB | Download |
|
md5:111886d358bd994d876b51b6782b0376
|
35.0 MB | Preview Download |
|
md5:5235bd400c44a4416b945b4534ceb60c
|
23.1 MB | Preview Download |
|
md5:eac803906048ee8bef84e9c779eedd24
|
2.3 MB | Preview Download |
|
md5:bd09d11e1a79a1623b3d9789bf336c9e
|
7.2 MB | Preview Download |
|
md5:69d888fef0dd8dd9b00908c627a7e9b2
|
2.9 MB | Preview Download |
|
md5:f0fb3e7308b24d7c52e5be707032f966
|
70.1 kB | Preview Download |
|
md5:64a228a81497f701cc108dac8b571aa1
|
57.7 MB | Download |
|
md5:c7ec1feb331be390222b2fa22f805f2b
|
5.3 MB | Preview Download |
|
md5:3aa58de0f8cb4105117bea68849aec52
|
6.6 MB | Preview Download |
|
md5:f5740fdad8d27d86516a591c02e7fa43
|
978.1 kB | Preview Download |
|
md5:ba679325b7ae96c87b6fa5584cfae491
|
2.0 MB | Preview Download |
|
md5:643ae3e5d611e72db1c148cd5539a0d0
|
43.5 MB | Preview Download |
|
md5:ba025e5836b40f3836787687cefe7412
|
124.5 kB | Preview Download |
|
md5:eae67a0efef5efc72dfea0b6ec310738
|
81.3 MB | Download |
|
md5:6992a1a7ca634cfcaa7dc858fa1fd3f3
|
28.5 MB | Preview Download |
|
md5:4b64786e5bb55f1dec8e04880e1f9321
|
15.1 MB | Preview Download |
|
md5:355155f1a556a54690a2b6dfe5e6466e
|
1.3 MB | Preview Download |
|
md5:240ab648e9b6fb13f2540b217638676e
|
3.0 MB | Preview Download |
|
md5:06ed7c4741cc8e2742eb20bd1d70b973
|
65.8 MB | Download |
|
md5:35434c8ea136c98b568e1a271f6811b8
|
193.6 MB | Preview Download |
|
md5:5411d3ca444467f625ce1348494a3479
|
35.5 MB | Preview Download |
|
md5:98ff55e119abbf56171a90478efacc7d
|
65.7 kB | Preview Download |
|
md5:694686904ca1871e1b96f2002d2a136d
|
192.9 kB | Preview Download |
|
md5:0de7d3163e114d825675592a096502b1
|
3.2 GB | Preview Download |
|
md5:1362949c518c6f341a54c9c13231a659
|
11.7 GB | Preview Download |
|
md5:211996da2e0908ee672fae01cbc118b9
|
4.4 MB | Preview Download |