Public Utility Data Liberation Project (PUDL) Data Release
Authors/Creators
- 1. Catalyst Cooperative
Description
v2026.8.0 (2026-08-07)
This is a regular quarterly PUDL release with a bunch of dataset updates. We've also added a new raw EPA MATS dataset, and Puerto Rico is now included in our EIA-860/860M data thanks to first-time contributor @bsousa22. We also tracked down and fixed a longstanding bug that had FERC Form 714 balancing authority data crossed between the Desert Southwest and Upper Great Plains West regions. See below for all the details.
New Data
EIA-860M
-
Added Puerto Rico EIA-860M data into EIA 860 tables. See issue #4352 and PR #5360. Shoutout to @bsousa22 for making his first PUDL contribution!
EPA MATS
-
Added the EPA Mercury and Air Toxics Standards (MATS) dataset, extracted into a raw table with additional records through end of June 2026. This data is not yet deeply integrated into PUDL. See issue #5358 and PRs #5389, #5464. Also a contribution from @bsousa22.
Expanded Data Coverage
EIA-191
EIA-860M
EIA-923
-
Added early release data for EIA-923 2025. See issue #5372 and PR #5391.
-
Added EIA-923M data for April and May 2026. See issue #5460 and PRs #5391, #5468.
EIA-930
FERC-714
EIA Electricity API
-
Updated the bulk EIA Electricity API data used to fill in redacted fuel prices. See PRs #5441, #5464.
EPA CEMS
PHMSA Natural Gas data
-
Updated the PHMSA natural gas data. See PR #5464.
FERC Form 6
-
Updated the raw FERC Form 6 archives to include additional 2025 data. This data is converted to SQLite, but not deeply integrated into PUDL. See PR #5441.
Documentation
-
Added LLM use guidelines and best practices to the contributor guide and dev guide. See PR #5395.
-
Set up the sphinx_llm Sphinx extension to generate a Markdown version of the PUDL documentation, suitable for consumption by LLMs, based on the llms.txt convention. Each page now advertises its Markdown counterpart via a
<link rel="alternate" type="text/markdown">tag, and the site footer links directly tollms.txt, so that agents browsing the rendered HTML docs can discover and prefer the Markdown versions. See PRs #5381, #5393.
Bug Fixes & Data Cleaning
-
Fixed incorrectly mapped Western Area Power Authority BA codes in FERC 714 data - previously, the Upper Great Plains West region FERC respondent was mapped to the Desert Southwest region EIA balancing authority information, and vice versa. See #4644 and #5408.
-
Fixed an exact-float merge bug in FERC1 "exploded tables" corrections. The
add_sizable_minority_corrections()method matched correction candidates by merging directly on floating point columns. Exact float equality is extremely brittle, and moving from 32- to 64-bit floats changed which utility/year pairs matched, producing extra rows and differentending_balancesums in out_ferc1__yearly_detailed_balance_sheet_assets and out_ferc1__yearly_rate_base. These were real matches being lost due to the limited precision of 32-bit floats, on top of the brittleness of of merging on floating point numbers. These are now being captured deterministically by merging on values within a fixed tolerance of $5. See PR #5350. -
Fixed the Dagster asset graph for EIA-860 to correctly depend on EIA-860M, so selecting the
raw_eia860masset group and its downstream assets now also captures the EIA-860 assets that rely on it, instead of silently leaving them stale. See #4327 and PR #5409.
Performance Improvements
-
Switched from using
pl.Enumto unconstrainedpl.Categoricaltypes to preserve lazy execution inget_parquet_table_polars(). This allows running schema checks on large tables, and Pandera's Polars backend never actually enforced data content checks onpl.LazyFrameassets (99% of assets in PUDL). See PR #5434. Implementing efficient content validation forpl.LazyFrameassets is left to PR #5432. -
The fast ETL now processes only two representative EIA-861 years instead of the entire time series, bringing it in line with how every other dataset is already handled and speeding up both local development and CI. Processing all years was originally a workaround for discontinued columns and data validation tests that couldn't tolerate partial coverage; those limitations have since been resolved. This change surfaced an implicit assumption in the FERC-714 outputs that all EIA-861 years were always available, in the logic that repairs known-bad balancing authority/utility associations by copying data from a known-good year. That repair logic has been rewritten as an explicit, validated mapping of per-year fixes, so it degrades gracefully when only a subset of years is present, and is substantially easier to read, test, and extend than the compact form it replaces. See #2628 and #4568.
Developer Experience
-
Standardized numeric dtypes to always use 64-bit values, and datetime types to use microsecond resolution in
pudl.metadata.dtypes. The unusedcompactargument toto_pandas_dtype()was retired. See PR #5350. -
Sanitized the batch job IDs used by the deploy and build workflows so they always meet Google Batch's naming requirements, fixing failures we had previously worked around by making the IDs more generic. See #5411 and PR #5429.
Other PUDL v2026.8.0 Resources
- PUDL v2026.8.0 Data Dictionary
- PUDL v2026.8.0 Documentation
- PUDL in the AWS Open Data Registry
- PUDL v2026.8.0 in a free, public AWS S3 bucket: s3://pudl.catalyst.coop/v2026.8.0/
- PUDL v2026.8.0 in a requester-pays GCS bucket: gs://pudl.catalyst.coop/v2026.8.0/
- Zenodo archive of the PUDL GitHub repo for this release
- PUDL v2026.8.0 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
(19.4 GB)
| Name | Size | |
|---|---|---|
|
md5:78ac3ef9c9f1416c03872fe5e01736d1
|
506.7 MB | Preview Download |
|
md5:1817707a712667ea014df73f265bf367
|
318.9 kB | Preview Download |
|
md5:89f8955b0dea62683b23dc7e932a2293
|
275.0 MB | Preview Download |
|
md5:0ecf747e17e1d5f889df2f5ddc2be564
|
202.9 MB | Preview Download |
|
md5:29844081496a20c597f2e9b4bc3fdcc1
|
274.6 kB | Preview Download |
|
md5:c945e6074cb749c23a313392e32cd4b8
|
1.2 GB | Download |
|
md5:098c43c911b99038363719aa3a8e6f63
|
239.1 MB | Preview Download |
|
md5:96a512a9d745d7799abf8d99da707f77
|
202.7 MB | Preview Download |
|
md5:99c36284f17d54c92f83010d66c4ec37
|
2.3 MB | Preview Download |
|
md5:ee5c7f18d569c58f3f008b96a16bedff
|
8.5 MB | Preview Download |
|
md5:068f8a2cc954d62bd15ec802b77513fa
|
74.7 MB | Preview Download |
|
md5:049e4ce464a30965f6b5397a5891eaef
|
48.3 MB | Preview Download |
|
md5:a960c24fb19d18a40b1900814b1d4149
|
221.2 kB | Preview Download |
|
md5:e9b2da970d8ed3a82cda20a416a23890
|
147.6 MB | Download |
|
md5:698974426e18540130be988de69988b4
|
35.7 MB | Preview Download |
|
md5:07aa46157f6a2eba9a163493856be9b0
|
23.1 MB | Preview Download |
|
md5:563f75f73de2b5ac66ab8be86412324e
|
2.3 MB | Preview Download |
|
md5:bd09d11e1a79a1623b3d9789bf336c9e
|
7.2 MB | Preview Download |
|
md5:7bdff5e1d46fd3a97079fb21df4601d4
|
2.9 MB | Preview Download |
|
md5:39d5a23a7ca5a019ce35592d5a4083ba
|
2.8 MB | Preview Download |
|
md5:3df82b31f14e1572773ab54457a99bb3
|
72.2 kB | Preview Download |
|
md5:33bc9f7f7ca33339d6b477fb8570d27b
|
50.9 MB | Download |
|
md5:cdbe12a5a5c779a2458af6eab5f5a4aa
|
5.4 MB | Preview Download |
|
md5:eb5e4e06b73d19e509662a3503b72da5
|
6.6 MB | Preview Download |
|
md5:74174a5bc6f7ae24c000d54f09c1d3ef
|
978.1 kB | Preview Download |
|
md5:ba679325b7ae96c87b6fa5584cfae491
|
2.0 MB | Preview Download |
|
md5:8b6d561967f06f824e21c5eda857ab0d
|
44.0 MB | Preview Download |
|
md5:420e1a2c399d0dba0d8b2d08d8eb88ae
|
27.2 MB | Preview Download |
|
md5:a9ea4d54551c4231be7f22b5190c05ef
|
127.9 kB | Preview Download |
|
md5:17ea5dd9d31fc6f0f3dfbcb6253a8bc7
|
72.4 MB | Download |
|
md5:d0559e91b363c83ffd15d00be1671d5f
|
29.1 MB | Preview Download |
|
md5:7c95b6e8d95d00b0348b95345c23072b
|
15.1 MB | Preview Download |
|
md5:41ea40c78248d93a5242940e4eb391f4
|
1.3 MB | Preview Download |
|
md5:240ab648e9b6fb13f2540b217638676e
|
3.0 MB | Preview Download |
|
md5:47a4fc4f5bf4cfca5c68e12c7c3d2b64
|
81.8 MB | Download |
|
md5:2db0546fcf1ad0672c1d0836da2e678c
|
243.1 MB | Preview Download |
|
md5:65495228a48cd03393104c9f73639bd9
|
43.4 MB | Preview Download |
|
md5:96cf0bf5e63f8f626fe18b85903534f9
|
65.7 kB | Preview Download |
|
md5:83bcf37029395440c6a0efb7ce49ee8e
|
192.9 kB | Preview Download |
|
md5:02e54a1e2a351c497b1a24576238c79b
|
3.4 GB | Preview Download |
|
md5:8347db91ea9afbf0fcfec2ae1cbd206b
|
12.3 GB | Preview Download |
|
md5:106562157fb6947cd22d652fac083fce
|
4.4 MB | Preview Download |
|
md5:9262b92851cabeff58861e9bbaefabe3
|
42 Bytes | Download |
Additional details
Related works
- Is documented by
- https://docs.catalyst.coop/pudl/en/v2026.8.0/ (URL)
- Is supplemented by
- Software: 10.5281/zenodo.21839890 (DOI)
- Software: https://github.com/catalyst-cooperative/pudl/releases/tag/v2026.8.0 (URL)