jared ed9658d267 feat(sql): add gov_population_yearly view ...

Exposes one row per (year, canonical_govid) drawn from long.population.
Used by per-capita denominators and peer matching.

2026-04-29 15:12:53 -04:00

..

10-long.sql

feat: view registration from inst/sql/

2026-04-23 10:21:36 -04:00

20-spending_long.sql

feat: view registration from inst/sql/

2026-04-23 10:21:36 -04:00

21-revenue_long.sql

feat: view registration from inst/sql/

2026-04-23 10:21:36 -04:00

30-canonical_fips_xwalk.sql

feat: view registration from inst/sql/

2026-04-23 10:21:36 -04:00

31-summary_categories.sql

feat: view registration from inst/sql/

2026-04-23 10:21:36 -04:00

32-gov_population_yearly.sql

feat(sql): add gov_population_yearly view

2026-04-29 15:12:53 -04:00

40-spending_annotated.sql

feat: view registration from inst/sql/

2026-04-23 10:21:36 -04:00

41-revenue_annotated.sql

feat: view registration from inst/sql/

2026-04-23 10:21:36 -04:00