Manually uploaded a couple of years of processed FERC EQR data if anybody would like to play with it. Working on the automated builds now. There are 4 directories, one for each EQR table under this path:

s3://pudl.catalyst.coop/ferceqr/

Each directory contains one Parquet file per quarter of data.

#Electricity #Energy #OpenData #FERC #Markets #ClimateChange

Hey nerds, we're experimenting with publishing our complete (but raw!) XBRL-derived #FERC data using @duckdb so you can, for example:

ATTACH 's3://pudl.catalyst.coop/nightly/ferc1_xbrl.duckdb' AS ferc1_xbrl (READ_ONLY);
SELECT * FROM ferc1_xbrl.transmission_lines_added_during_year_424_duration;

#SQL #OpenData #Electricity #Energy

Hey nerds, we're experimenting with publishing our complete (but raw!) XBRL-derived #FERC data using @duckdb so you can, for example:

ATTACH 's3://pudl.catalyst.coop/nightly/ferc1_xbrl.duckdb' AS ferc1_xbrl (READ_ONLY);
SELECT * FROM ferc1_xbrl.transmission_lines_added_during_year_424_duration;

#SQL #OpenData #Electricity #Energy