PUMS & OSPI ETL

These indicators are linked explicitly to equity demographic characteristics, so differences/disparities can be directly interpreted, without the caveats that accompany proxy measures. Estimates at both county and regional levels are stored in the table Elmer.equity.indicator_facts and accessed through the view Elmer.equity.v_tracker_indicators. Estimates at geographies smaller than the county level are not available.

ETL Script for PUMS
It's good practice to examine the variable changes and data dictionary for a new year to confirm the names and codes/values line up with the prior year.

ETL script for OSPI
This uses the Socrata API from data.wa.gov, which is great. However, because each year's URL uses a random code rather than a pattern, for years not already captured, you'll need to search for "Report Card WaKids" at https://data.wa.gov/, find the appropriate year and click "API docs", then look for the API target URL to copy and supply as parameter to the get_k_readiness() function.