Dazhong Xia

# Overview Doesn't close, but addresses #3581. What problem does this address? What did you change? # Testing How did you make sure this worked? How can a reviewer verify...

Get basic user metrics we technically have access to

1

### Overview We want to be able to see our basic usage metrics: * how many different IPs are accessing our data via Datasette? * how many different IPs are...

WIP - fail a bunch of asset checks

1

# Overview Closes #XXXX. What problem does this address? What did you change? # Testing How did you make sure this worked? How can a reviewer verify this? ```[tasklist] #...

Update XBRL extraction to handle multiple taxonomies per year

3

### Overview Once catalyst-cooperative/pudl-archiver#349 is done, we have to actually use all that fancy metadata to extract the filings correctly! ### Success criteria * [ ] filings extracted using the...

Log datasette access IPs

3

# Overview Relates to #3664 Right now, our datasette instance only logs out the IP of the load balancer it sits behind. Useless! If we shove datasette behind nginx, we...

Split out from #3581 Table 54 has heterogeneous data with a variety of different units, so we'll have to pull those out into multiple different assets. For each, we need...

Update DOI automatically for well-behaved datasets

2

### Overview We don't update the DOI reference immediately upon publishing a new archive, because oftentimes using a new version of a dataset causes problems. Instead we wait until we...

### Overview Details here: https://github.com/catalyst-cooperative/pudl/pull/3741#issuecomment-2257443287 But basically, the CEMS parquet file is pretty big and that's causing a memory issue when trying to convert to DuckDB. ### Success Criteria *...

## Overview Duckdb table names have a character limit of 63. We have four tables that exceed 63 characters: `core_eiaaeo__yearly_projected_fuel_cost_in_electric_sector_by_type`: 66 `core_eiaaeo__yearly_projected_generation_in_electric_sector_by_technology`: 73 `core_eiaaeo__yearly_projected_generation_in_end_use_sectors_by_fuel_type`: 72 `out_eia923__yearly_generation_fuel_by_generator_energy_source_owner`: 67 We should rename...

Add FERC1 validation tests

4

We've add This lets us test things that aren't in `PudlTabl`. # Overview @cmgosnell and I were working through some changes to the FERC1 machinery, related to the 714 work,...