pipeline
Classical end-to-end empirical analysis workflow in the traditional Python econometric stack — pandas + numpy + scipy +…
SAIPE — annual Census poverty estimates for school districts (Portal; county/state not in Portal). Use for district poverty, Title I context, or trends. ~18-month lag. No race/ethnicity disaggregation at district level — use ACS 5-year for that.
Claude Code
$ npx -y skills add brycewang-stanford/Auto-Empirical-Research-Skills --skill education-data-source-saipe --agent claude-code
Codex
$ npx skills add brycewang-stanford/Auto-Empirical-Research-Skills --skill education-data-source-saipe -a codex -y
Cursor
$ npx skills add brycewang-stanford/Auto-Empirical-Research-Skills --skill education-data-source-saipe -a cursor -y
Gemini CLI
$ npx skills add brycewang-stanford/Auto-Empirical-Research-Skills --skill education-data-source-saipe -a gemini-cli -y
GitHub Copilot
$ npx skills add brycewang-stanford/Auto-Empirical-Research-Skills --skill education-data-source-saipe -a github-copilot -y
OpenCode
$ npx skills add brycewang-stanford/Auto-Empirical-Research-Skills --skill education-data-source-saipe -a opencode -y
Windsurf
$ npx skills add brycewang-stanford/Auto-Empirical-Research-Skills --skill education-data-source-saipe -a windsurf -y
name: education-data-source-saipe description: >- SAIPE — annual Census poverty estimates for school districts (Portal; county/state not in Portal). Use for district poverty, Title I context, or trends. ~18-month lag. No race/ethnicity disaggregation at district level — use ACS 5-year for that. metadata: audience: any-agent domain: data-source skill-authored: "2026-02-09" skill-last-updated: "2026-02-09"
Census Bureau Small Area Income and Poverty Estimates (SAIPE) — annual model-based poverty estimates for school districts (Portal mirror; county and state data not in Portal). Use when district-level poverty is needed for Title I allocation interpretation, annual poverty trend analysis, or school-age children in poverty estimates. Estimates have ~18-month lag and no race/ethnicity disaggregation at district level — use ACS 5-year for race-disaggregated poverty.
Reference for understanding Census Bureau poverty estimates for school districts, counties, and states. SAIPE is the only annual, district-level poverty source and the legally mandated basis for Title I education funding allocations.
> **CRITICAL: Value Encoding** > > This document describes **Education Data Portal** integer encodings, which differ from Census Bureau raw file formats. The Portal uses integers for FIPS codes and standard missing data conventions. > > | Context | FIPS Alabama | FIPS California | Missing | Suppressed | > |---------|--------------|-----------------|---------|------------| > | **Portal (integers)** | `1` | `6` | `-1` | `-3` | > | Census raw files | `01` (string) | `06` (string) | varies | varies | > > **Key difference:** Portal FIPS codes are integers (no leading zeros), while Census files use 2-character strings. > > See `./references/variable-definitions.md` for complete encoding tables.
SAIPE is the Census Bureau's program for producing **model-based** estimates of income and poverty:
| File | Purpose | When to Read | |------|---------|--------------| | `estimation-methodology.md` | How state/county models work | Understanding model inputs and outputs | | `school-district-estimates.md` | How district estimates are derived | Working with school district data | | `variable-definitions.md` | Variables, codes, population universes | Interpreting specific data fields | | `data-quality.md` | Uncertainty, CV, limitations | Assessing estimate reliability | | `historical-changes.md` | Methodology changes over time | Comparing across years | | `comparison-other-sources.md` | SAIPE vs ACS, FRPL, CPS | Choosing between data sources |
Understanding SAIPE?
├─ How are estimates created?
│ ├─ State/county models → ./references/estimation-methodology.md
│ └─ School district shares → ./references/school-district-estimates.md
├─ What variables are available?
│ └─ Variable definitions → ./references/variable-definitions.md
├─ How reliable are estimates?
│ ├─ Confidence intervals → ./references/data-quality.md
│ └─ Small district uncertainty → ./references/data-quality.md
├─ Comparing data sources?
│ ├─ SAIPE vs FRPL → ./references/comparison-other-sources.md
│ ├─ SAIPE vs ACS → ./references/comparison-other-sources.md
│ └─ Why estimates differ → ./references/comparison-other-sources.md
└─ Year-to-year changes?
├─ Methodology breaks → ./references/historical-changes.md
└─ Safe comparisons → ./references/historical-changes.mdResearch question?
├─ District poverty rate for Title I
│ ├─ Use SAIPE (official source for Title I)
│ └─ Note: rates use different numerator/denominator universes
├─ Compare district poverty over time
│ ├─ Check methodology breaks → ./references/historical-changes.md
│ └─ Cannot compare school districts pre/post 2010
├─ Why doesn't SAIPE match FRPL?
│ └─ Different income thresholds → ./references/comparison-other-sources.md
├─ Poverty by race/ethnicity in districts
│ └─ SAIPE does NOT provide race breakdowns for districts
│ Use ACS 5-year estimates instead
└─ Very small district reliability
└─ Check CV by population size → ./references/data-quality.mdAll SAIPE estimate columns in the Education Data Portal use the `est_` prefix:
| Short Name | Portal Column Name | |------------|-------------------| | `population_total` | `est_population_total` | | `population_5_17` | `est_population_5_17` | | `population_5_17_poverty` | `est_population_5_17_poverty` | | `population_5_17_poverty_pct` | `est_population_5_17_poverty_pct` |
| ID | Format | Level | Example | Notes | |----|--------|-------|---------|-------| | `fips` | Integer | State | `6` | State FIPS code (no leading zeros in Portal) | | `leaid` | String | District | `0100005` | NCES district ID; join key to CCD | | `year` | Integer | Time | `2022` | Estimate reference yea
## 🔥 力荐 · StatsPAI — Stata 与 R 的 Python 平替,为 AI Agent 而生 🔁 Stata / R 平替:reghdfe、csdid、rdrobust、synth、fixest、did 等常用命令在 Python 中一站式替代,一个 import statspai as sp 搞定 DID / RD / IV / SCM / DML / matching 🤖 面向 Agent 设计:结构化结果对象 + 内置 MCP Server,Claude / Codex
Classical end-to-end empirical analysis workflow in the traditional Python econometric stack — pandas + numpy + scipy +…
Use when the user asks to run a full empirical / causal analysis in Python — by default in the style of an applied economics…
Classical end-to-end empirical analysis workflow in the traditional Python econometric stack — pandas + numpy + scipy +…
Classical end-to-end empirical analysis workflow in the traditional Stata ecosystem — native Stata + reghdfe + ivreg2 + csdid +…
Classical end-to-end empirical analysis workflow in the modern tidyverse + econometrics R ecosystem — dplyr + tidyr + haven +…
Systematic writing framework for philosophy and interdisciplinary academic papers from optimized outline to submission-ready…
Direct browser control via CDP for web interaction: automation, scraping, testing, screenshots, and site/app work. Also covers…
Browser automation CLI for AI agents. Use when the user needs to interact with websites, including navigating pages, filling…