There is a newer version of the record available.

Published December 14, 2025 | Version v2025.12.1
Dataset Open

Public Utility Data Liberation Project (PUDL) Data Release

Description

v2025.12.1 (2025-12-13)

This is a monthly release primarily intended to update the generatores reporting in EIA-860M, with some other minor improvements coming along for the ride. These include another new EIA Form 176 natural gas disposition table, and experimental access to the FERC XBRL derived databases using DuckDB. Details below.

Note: there was a misconfiguration in the build for v2025.12.0 that prevented it from deploying.

Enhancements

  • We are experimenting with distributing the XBRL-derived databases for FERC Forms 1, 2, 6, 60, and 714 using DuckDB, which (unlike SQLite) can be queried remotely when stored in a cloud bucket. This will also let us provide access to this relatively raw but complete FERC data through the PUDL Data Viewer. Note that the XBRL data only covers 2021 to the present. For links and an access example, see Raw FERC XBRL data converted to DuckDB (EXPERIMENTAL). See PR #4782 for this change, which is mostly implemented in the 1.7.x releases of our FERC XBRL Extractor.

New Data

EIA-176

Thanks to open source contributions from SwitchBox and funding from the NSF POSE program we continue to bring in more EIA natural gas data.

Expanded Data Coverage

EIA-860M

  • Updated EIA-860M with monthly data through October 2025. See #4788.

EIA-861

  • Added EIA-861 re-released final release data from 2024. See #4826 and PR #4827.

FERC Form 6

New Data Tests & Validations

  • Added dbt data validations to check the uniqueness of natural primary keys in tables where some elements of the primary key contain NULL values, preventing them from being used explicitly as primary keys in SQLite. This only covers tables where we had already explicitly identified the natural primary key in our metadata notes. See PR #4811.

Bug Fixes

  • Improve the retry logic we use when uploading a PUDL data release to Zenodo: Catch common transient error status codes and retry the upload instead of continuing as if nothing had gone wrong. When retrying, restart the upload from the beginning of the file rather than uploading a zero-length file. Previously both types of errors (missing files and zero-length files) were only caught through manual inspection of draft data releases. See issue #4290 and PR #4778.

  • Remove row with plant ID 68815 and generator ID GAPPV that was erroneously included in the 2024 from the EIA 860 generators data. See #4769 and PR #4824.

Performance Improvements

Quality of Life Improvements

  • Added balancing_authority_code_eia and balancing_authority_name_eia to the set of plant-level attributes that are merged into the denormalized out_eia__monthly_generators and out_eia__yearly_generators tables, as multiple users have requested them. Most recently @sam-hostetter in issue #4772. See #4776.

  • Decouple the publication of Zenodo data releases from the nightly and release builds by creating a zenodo-data-release GitHub Actions workflow that can create a new archive of a PUDL data release from nightly or stable build outputs. This should reduce the idle capacity and runtime of our nightly build VM significantly, and also allow us to retry Zenodo release uploads when Zenodo flakes out. The nightly and release builds will now trigger the zenodo-data-release workflow using curl and the GitHub API. See issue #4775 and PR #4778.

  • Disabled the distribution of build outputs to S3/GCS during workflow_dispatch builds since these uploads are pretty robust, they slow down the build, we delete the outputs right after uploading them, and there are egress fees associated with sending the data to S3. Build artifacts are still uploaded to gs://builds.catalyst.coop. See PR #4778.

  • Reduced the size of our nightly build VM to 8 CPUs & 64GB RAM since that configuration works again after our performance improvements, and it’s cheaper and not that much slower than the bigger VM. See #4778.

  • Replaced fgd_sorbent_consumption_1000_tons with fgd_sorbent_consumption_tons and changed units, consumption tons, to be rounded to nearest 100 tons in the _core_eia923__yearly_fgd_operation_maintenance table. See issue #4301 and PR #4426.

Other PUDL v2025.12.1 Resources

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:

Files

censusdp1tract.sqlite.zip

Files (17.2 GB)

Name Size Download all
md5:9e38d66eb08643dd49a86f54b6ba6c13
15.2 MB Download
md5:cd84e25765b966d7ff51d3fe21e7e841
506.7 MB Preview Download
md5:ea59c744a361897785505ea4176d1539
271.3 MB Preview Download
md5:1553eba5ced721ca96f12aab6e514cae
1.0 GB Download
md5:c039072b0a23f1acf3d4ec1d7f042ad7
190.4 MB Preview Download
md5:3b2f9a0e71a781fa2ab35b0fe2241e3b
2.3 MB Preview Download
md5:02c69518e60b733979671e73d2e12f9f
7.3 MB Preview Download
md5:71381bd76715abec9feadde0674ce843
73.9 MB Preview Download
md5:aa833778708da6a9cf4f48db665b5c15
153.4 MB Download
md5:67c85c53e4866b21fb5d7a6fda355a70
28.2 MB Preview Download
md5:4a7ac2c125b473640805108757b33f81
2.6 MB Preview Download
md5:086bdfaeb6293ed05e3bc6748f0f9e6c
7.2 MB Preview Download
md5:49ae1c1017ba2de2648c56c659833dea
2.9 MB Preview Download
md5:6da125b7ed16f191a891512d4c420eae
52.7 MB Download
md5:2b4a9502e7f7df7011b2641546ecd479
4.4 MB Preview Download
md5:113570794bddf686f6feac1a698ca833
964.8 kB Preview Download
md5:4667b8113e5e6d61af554a6304bf5ebc
1.9 MB Preview Download
md5:9a50032bcf9c4904d7b60ee1a8d1b9d2
43.5 MB Preview Download
md5:10c07b0df82d2b961c50adeb0fe6dfb0
75.0 MB Download
md5:5994326bfc271401b04e4ac73c60e704
22.7 MB Preview Download
md5:ad55f7c5547c41fa7d87e9b5e6131001
1.4 MB Preview Download
md5:22324cdc278878cd884e4caf9971d903
3.0 MB Preview Download
md5:503fb4ec036539489a431ebb85bf63cf
67.4 MB Download
md5:43d7392f01af56246c96d5cae6d5e4eb
193.6 MB Preview Download
md5:bab6f0f6f437b4c264072d0c9d2b69a9
85.4 kB Preview Download
md5:694686904ca1871e1b96f2002d2a136d
192.9 kB Preview Download
md5:ec3e9d323bf7471124e51905049c0107
3.0 GB Preview Download
md5:9dad3a98bc1968e77067e6fdd1af4cde
11.5 GB Preview Download