Implement XBRL conversion on subset of tables to test conversion process

catalyst-cooperative / pudl

The Public Utility Data Liberation Project provides analysis-ready energy system data to climate advocates, researchers, policymakers, and journalists.

https://catalyst.coop/pudl

MIT License

468 stars 107 forks source link

Implement XBRL conversion on subset of tables to test conversion process #1531

Closed zschira closed 2 years ago

zschira commented 2 years ago

To integrate XBRL based FERC filings with historical data, we have decided to attempt to recreate the SQLite db created by ferc1_to_sqlite. We will first attempt this conversion process on a subset of tables and validate their data.

Tables mapped

[ ] f1_respondent_id
[ ] f1_gnrt_plant
[x] f1_steam
[x] f1_fuel
[x] f1_plant_in_srvce
[ ] f1_hydro
[ ] f1_pumped_storage
[ ] f1_purchased_pwr

zschira commented 2 years ago

Decided against creating all of these tables, as doing so on an individual basis in a somewhat ad-hoc way seemed like wasted work. Going to close and track each status of individual tables in separate issues.