pipeline
Classical end-to-end empirical analysis workflow in the traditional Python econometric stack — pandas + numpy + scipy + statsmodels + linearmodels + pyfixest +…
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.
$ npx -y skills add brycewang-stanford/Auto-Empirical-Research-Skills --skill education-data-source-saipe --agent claude-codeHow it fires
How this skill gets triggered: by you, by Claude, or both.
/education-data-source-saipeContext preview
The summary Claude sees to decide when to auto-load this skill.
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.
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
📌 文档结构(2026-07-22 起): 本文件是中文默认入口 —— banner + badges + 信任面 + 9 阶段流水线速览 + 76 行合集总表。 每个合集的完整描述、按用途分组、精确数字、验证方法在 docs/CONTENT_ZH.md(扩展正文,总表行内的 → 直接跳转到对应锚点)。 English version: README-en.md · 中文扩展正文:docs/CONTENT_ZH.md · README-zh-CN.md 已弃用(重定向占位) 🌐 语言: English |
Classical end-to-end empirical analysis workflow in the traditional Python econometric stack — pandas + numpy + scipy + statsmodels + linearmodels + pyfixest +…
Use when the user asks to run a full empirical / causal analysis in Python — by default in the style of an applied economics paper (AER / QJE / JPE / ReStud /…
Classical end-to-end empirical analysis workflow in the traditional Python econometric stack — pandas + numpy + scipy + statsmodels + linearmodels + pyfixest +…
Classical end-to-end empirical analysis workflow in the traditional Stata ecosystem — native Stata + reghdfe + ivreg2 + csdid + did_imputation +…
Classical end-to-end empirical analysis workflow in the modern tidyverse + econometrics R ecosystem — dplyr + tidyr + haven + fixest + sandwich + lmtest +…
Systematic writing framework for philosophy and interdisciplinary academic papers from optimized outline to submission-ready manuscript. Use when users want…