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