DAAF-Contribution-Community/daaf / .claude/skills/education-data-source-edfacts
education-data-source-edfacts
VerifiedEDFacts — K-12 outcomes: assessment proficiency, ACGR graduation rates, ESSA accountability at school/district level (2009-2020). Within-state trends and subgroup gaps. Complements CCD with outcome data. Cannot compare across states — use NAEP.
| File | Kind | Size |
|---|---|---|
| SKILL.md | skill md | 21.1 KB |
| references/accountability-context.md | markdown | 9.6 KB |
| references/assessment-data.md | markdown | 15.5 KB |
| references/data-quality.md | markdown | 17.7 KB |
| references/graduation-rates.md | markdown | 18.4 KB |
| references/subgroup-reporting.md | markdown | 21.1 KB |
| references/variable-definitions.md | markdown | 23.8 KB |
references/variable-definitions.md
View on GitHub# Variable Definitions
Detailed definitions for key EDFacts variables, suppression codes, special values, and data handling.
## Contents
- [Missing and Suppressed Data Codes](#missing-and-suppressed-data-codes)
- [Range and Midpoint Variables](#range-and-midpoint-variables)
- [Assessment Variables](#assessment-variables)
- [Graduation Rate Variables](#graduation-rate-variables)
- [Participation Variables](#participation-variables)
- [Subgroup Codes](#subgroup-codes)
- [Geographic Identifiers](#geographic-identifiers)
- [Handling Special Values](#handling-special-values)
## Missing and Suppressed Data Codes
EDFacts uses specific numeric codes to indicate missing or suppressed data:
### Standard Missing Data Codes
| Code | Meaning | When Used |
|------|---------|-----------|
| `-1` | Missing/not reported | Value missing or not reported |
| `-2` | Not applicable | Data element not applicable to this entity |
| `-3` | Suppressed | Data suppressed for privacy |
| `-9` | Not found in Portal data | See "`-9` (not found in Portal data)" below |
The `-1`/`-2`/`-3` labels follow the Portal varlist for the EDFacts assessment and graduation-rate value columns: `"-1" : "Missing/not reported","-2" : "Not applicable","-3" : "Suppressed data"` (live varlist for `schools/edfacts/assessments`, checked 2026-10-28; the generated `education-data-explorer` dictionary carries the same labels for the grad-rate columns). It is the Portal's generic sentinel legend, not EDFacts-specific semantics: the assessment varlist declares the same string on 20 of its 26 variables, including `year`, `school_name` and `leaid`.
Observed on the pinned mirror (HF revision `0ad00ce0`, school files, probed 2026-10-28): assessment value columns carry only `-3` and `-2`, grad-rate value columns carry only `-3`, and `-1` does not occur. District files were not probed.
### Understanding Each Code
#### `-1` (Missing/Not Reported)
The value is missing or was not reported:
- State-level reporting issue
- Data collection problem
- Indicator not collected that year
```python
# Example (illustrative): a graduation-rate value coded -1
# grad_rate_midpt = -1 (missing/not reported)
```
```r
# Example (illustrative): a graduation-rate value coded -1
# grad_rate_midpt = -1 (missing/not reported)
```
#### `-2` (Not Applicable)
Data does not apply to this record:
- School doesn't serve tested grades
- Indicator not applicable to school type
- Data element doesn't exist for this entity
```python
# Example (illustrative): a proficiency value coded -2
# read_test_pct_prof_midpt = -2 (not applicable)
```
```r
# Example (illustrative): a proficiency value coded -2
# read_test_pct_prof_midpt = -2 (not applicable)
```
#### `-3` (Suppressed for Privacy)
Data suppressed to protect student privacy:
- Small cell sizes
- Complementary suppression
- FERPA compliance
```python
# Example: Small subgroup, exact value would reveal individuals
# math_test_pct_prof_midpt = -3 (suppressed)
```
```r
# Example: Small subgroup, exact value would reveal individuals
# math_test_pct_prof_midpt = -3 (suppressed)
```
#### `-9` (not found in Portal data)
Earlier versions of this skill listed `-9` as "rounds to zero"; no source for that code was found. The Portal varlist corpus does not contain it (explorer `variable-codes.md`), and no pinned-mirror school-level assessment (2009-2018, 2020) or graduation-rate (2010-2019) value column contains it (HF revision `0ad00ce0`, probed 2026-10-28; district files were not probed). Filters below that drop `-9` together with `-1`/`-2`/`-3` are harmless.
### Filtering Missing Data
```python
import polars as pl
# Remove all missing/suppressed values
clean_df = df.filter(
(pl.col("read_test_pct_prof_midpt") >= 0)
)
# Or explicitly check for each code
clean_df = df.filter(
~pl.col("read_test_pct_prof_midpt").is_in([-1, -2, -3, -9])
)
```
```r
library(dplyr)
# Remove all missing/suppressed values
clean_df <- df |> filter(read_test_pct_prof_midpt >= 0)
# Or explicitly check for each code
clean_df <- df |> filter(!read_test_pct_prof_midpt %in% c(-1, -2, -3, -9))
```
## Range and Midpoint Variables
### Why Ranges Are Reported
When exact values could identify individual students (small cell sizes), EDFacts reports ranges instead:
| Exact Value | Would Reveal | Solution |
|-------------|--------------|----------|
| 33.3% | 1 of 3 students | Report range |
| 100% | All passed | Report range |
| 0% | None passed | Report range |
### Variable Naming Convention
| Suffix | Meaning | Example |
|--------|---------|---------|
| `_low` | Lower bound of range | `read_test_pct_prof_low` |
| `_high` | Upper bound of range | `read_test_pct_prof_high` |
| `_midpt` | Midpoint of range | `read_test_pct_prof_midpt` |
### Midpoint Calculation
```
midpt = (low + high) / 2
```
Example:
- `_low` = 30%
- `_high` = 40%
- `_midpt` = 35%
### Standard Range Widths
EDFacts uses standard range bands:
| Range | Width | Example |
|-------|-------|---------|
| Very narrow | 2-3 points | 48-50% |
| Standard | 5 points | 45-50% |
| Wider | 10 points | 40-50% |
### Best Practices for Ranges
1. **Always use `_midpt` for analysis**
```python
# Correct
avg_prof = df["read_test_pct_prof_midpt"].mean()
# Not useful alone
avg_low = df["read_test_pct_prof_low"].mean()
```
```r
# Correct
avg_prof <- mean(df$read_test_pct_prof_midpt, na.rm = TRUE)
# Not useful alone
avg_low <- mean(df$read_test_pct_prof_low, na.rm = TRUE)
```
2. **Document uncertainty from ranges**
```python
# Calculate uncertainty
df = df.with_columns(
(pl.col("read_test_pct_prof_high") - pl.col("read_test_pct_prof_low"))
.alias("range_width")
)
avg_uncertainty = df["range_width"].mean()
```
```r
# Calculate uncertainty
df <- df |> mutate(range_width = read_test_pct_prof_high - read_test_pct_prof_low)
avg_uncertainty <- mean(df$range_width, na.rm = TRUE)
```
3. **Report range width in findings**
## Assessment Variables
### Proficiency Variables
| Variable | Description | Type |
|----------|-------------|------|
| `read_test_pct_prof_low` | Reading % proficient, lower bound | Percentage |
| `read_test_pct_prof_high` | Reading % proficient, upper bound | Percentage |
| `read_test_pct_prof_midpt` | Reading % proficient, midpoint | Percentage |
| `math_test_pct_prof_low` | Math % proficient, lower bound | Percentage |
| `math_test_pct_prof_high` | Math % proficient, upper bound | Percentage |
| `math_test_pct_prof_midpt` | Math % proficient, midpoint | Percentage |
### Test Count Variables
| Variable | Description | Type |
|----------|-------------|------|
| `read_test_num_valid` | Number of valid reading test scores | Integer |
| `math_test_num_valid` | Number of valid math test scores | Integer |
### Using Test Counts
Test counts are useful for:
- Determining sample size
- Weighting averages
- Identifying suppression likelihood
```python
# Weight average by number of test-takers
weighted_avg = (
df.filter(pl.col("read_test_num_valid") > 0)
.select(
(pl.col("read_test_pct_prof_midpt") * pl.col("read_test_num_valid")).sum() /
pl.col("read_test_num_valid").sum()
)
)
```
```r
library(dplyr)
# Weight average by number of test-takers
weighted_avg <- df |>
filter(read_test_num_valid > 0) |>
summarise(
weighted_avg = sum(read_test_pct_prof_midpt * read_test_num_valid) /
sum(read_test_num_valid)
)
```
## Graduation Rate Variables
### Rate Variables
> **Empirically verified** from 2019 grad rate data. Note that `grad_rate_midpt` is **Int64** (not Float64 like assessment midpoints).
| Variable | Description | Portal Type |
|----------|-------------|-------------|
| `grad_rate_low` | Graduation rate, lower bound (null when exact) | Int64 |
| `grad_rate_high` | Graduation rate, upper bound (null when exact) | Int64 |
| `grad_rate_midpt` | Graduation rate, midpoint or exact value | Int64 |
### Cohort Variable
| Variable | Description | Portal Type |
|----------|-------------|-------------|
| `cohort_num` | Adjusted cohort size | Int64 |
> **Note:** The variable is `cohort_num`, NOT `cohort_count`. There is no `grad_count` column in the Portal data.
### Extended Rate Variables
Extended graduation rate variables (`grad_rate_5yr_midpt`, `grad_rate_6yr_midpt`) are not observed in the current Portal datasets. If your analysis requires extended rates, verify column availability empirically before proceeding.
## Participation Variables
The Portal's EDFacts assessment files carry no participation-rate variable: the live varlist for `schools/edfacts/assessments` (26 variables, checked 2026-10-28) and the mirror dictionary list only `read_/math_test_num_valid` and `read_/math_test_pct_prof_{low,midpt,high}`. `*_test_num_valid` counts students who completed the test and were assigned a proficiency level; it is not a participation rate. For participation (including ESSA's 95% requirement), use ED's EDFacts participation files (SY 2012-13 onward), which are outside the Portal.
## Subgroup Codes
> **Portal Encoding Warning:** The Urban Institute Education Data Portal converts NCES string codes to integers. The documentation below shows NCES string codes in parentheses but **actual data uses integers**.
### Race/Ethnicity Codes (Portal Integer Encoding)
> **Empirically verified** from 2018 assessment data, and confirmed in all 42 mirror files with `race` (assessments and grad rates, every year; pinned-mirror probe 2026-10-30). Only these values appear in the `race` column.
| Portal Code | NCES Code | Description |
|-------------|-----------|-------------|
| `1` | WH | White |
| `2` | BL | Black or African American |
| `3` | HI | Hispanic/Latino of any race |
| `4` | AS | Asian |
| `5` | AM | American Indian/Alaska Native |
| `7` | MR | Two or more races |
| `99` | — | Total |
> **Note:** Code `6` (NH/PI), `8` (Nonresident alien), `9` (Unknown), `20` (Other) are NOT observed in EDFacts data. Negative codes (-1, -2, -3) are also not present in the `race` column -- suppression is applied to the *value* columns, not the subgroup filter columns.
### Special Population Codes (Portal Integer Encoding)
EDFacts uses **filter columns** for special populations. Each column has:
- `1` = Yes (student is in this subgroup)
- `99` = Total (all students)
| Column | NCES Code | Description |
|--------|-----------|-------------|
| `lep` | LEP | Limited English proficient students |
| `disability` | CWD | Students with disabilities (see disability codes below) |
| `homeless` | HOM | McKinney-Vento identified homeless students |
| `foster_care` | FCS | Students in foster care system |
| `migrant` | MIG | Migrant education program participants |
| `econ_disadvantaged` | ECODIS | Economically disadvantaged students |
| `military_connected` | MIL | Students from military families |
### Disability Codes (Portal Integer Encoding)
> **Empirically verified** from 2018 assessment and 2019 grad rate data. Only `1` and `99` are observed.
| Code | Description |
|------|-------------|
| `1` | Students with disabilities (IDEA-eligible) |
| `99` | Total (all students) |
> **Note:** The expanded disability codes (0-4) documented in other Portal sources are NOT present in EDFacts datasets. EDFacts uses a simple binary: `1` = students with disabilities, `99` = total.
### Sex Codes (Portal Integer Encoding)
| Code | Description |
|------|-------------|
| `1` | Male |
| `2` | Female |
| `9` | Unknown |
| `99` | Total |
### Filtering by Subgroup
```python
# Get data for students with disabilities (IDEA)
# Portal uses integer 1, NOT string "CWD"
cwd_data = df.filter(pl.col("disability") == 1)
# Get total row (all students)
all_students = df.filter(pl.col("race") == 99)
# Get Black students only
black_students = df.filter(pl.col("race") == 2)
# Get LEP students
lep_data = df.filter(pl.col("lep") == 1)
# Compare race groups
race_comparison = (df
.filter(pl.col("race").is_in([1, 2, 3, 99])) # White, Black, Hispanic, Total
.group_by("race")
.agg(pl.col("read_test_pct_prof_midpt").mean())
)
```
```r
library(dplyr)
# Get data for students with disabilities (IDEA)
# Portal uses integer 1, NOT string "CWD"
cwd_data <- df |> filter(disability == 1)
# Get total row (all students)
all_students <- df |> filter(race == 99)
# Get Black students only
black_students <- df |> filter(race == 2)
# Get LEP students
lep_data <- df |> filter(lep == 1)
# Compare race groups
race_comparison <- df |>
filter(race %in% c(1, 2, 3, 99)) |>
group_by(race) |>
summarise(avg_prof = mean(read_test_pct_prof_midpt, na.rm = TRUE))
```
## Geographic Identifiers
> **Portal Data Types:** All identifiers are **Int64** in the Portal parquet files. The NCES source format (zero-padded strings) is described below for reference, but you will encounter integer values when working with the data.
### School-Level (Assessment datasets: 26 cols, Grad rate datasets: 18 cols)
| Variable | Description | Portal Type | NCES Source Format |
|----------|-------------|-------------|-------------------|
| `ncessch` | NCES school ID | Int64 | 12-char zero-padded |
| `ncessch_num` | School ID (same as ncessch) | Int64 | — |
| `school_name` | School name | String | — |
### District-Level (Assessment datasets: 23 cols, Grad rate datasets: 15 cols)
| Variable | Description | Portal Type | NCES Source Format |
|----------|-------------|-------------|-------------------|
| `leaid` | NCES district/LEA ID | Int64 | 7-char zero-padded |
| `leaid_num` | District ID (same as leaid) | Int64 | — |
| `lea_name` | LEA/district name | String | — |
### State-Level
| Variable | Description | Portal Type |
|----------|-------------|-------------|
| `fips` | State FIPS code | Int64 |
> **Note:** `state_name` and `state_abbrev` columns are NOT present in EDFacts datasets. Only `fips` is available. Join with CCD directory data to get state names.
### ID Format Reference (NCES Source)
```python
# NCESSCH logical format: SSLLLLLNNNNN (12 digits)
# SS = State FIPS (2 digits)
# LLLLL = LEA ID (5 digits)
# NNNNN = School ID within LEA (5 digits)
#
# In Portal data, this is stored as Int64 (no leading zeros):
# California example: ncessch = 60000100001 (Int64)
# NCES source: ncessch = "060000100001" (12-char string)
```
```r
# NCESSCH logical format: SSLLLLLNNNNN (12 digits)
# SS = State FIPS (2 digits)
# LLLLL = LEA ID (5 digits)
# NNNNN = School ID within LEA (5 digits)
#
# In Portal data, this is stored as integer (no leading zeros):
# California example: ncessch = 60000100001 (integer)
# NCES source: ncessch = "060000100001" (12-char string)
```
### CSV Fallback: Force-String + Pad-and-Assert (2019 truncated-ID trap)
> **Field-confirmed, HIGH impact.** When the parquet mirror is unavailable and a fetch
> falls back to the CSV source, EDFacts `ncessch`/`leaid` need more than a force-string
> read. In a native R-mode pipeline run, the **2019 grad-rate CSVs delivered 11-character
> `ncessch`** for single-digit-FIPS states (FIPS 1, 2, 4, 5, 6, 8, 9), versus 12-character
> in 2015-2018 — the source file had *already* lost the leading zero. Forcing string on
> read did not restore it (there was nothing to restore). Only pad-to-width plus a width
> assertion recovers and verifies these IDs. In that run the fix repaired 43,223 short
> IDs, all localized to 2019, and prevented a split join key for terminal-year ACGR.
Canonical widths: `ncessch` → 12, `leaid` → 7. Two defenses, applied in order, on every CSV-fallback read:
1. **Force-string on read** (preserves zeros the file still has).
2. **Pad-and-assert after read** (recovers zeros the file already dropped, and fails loudly on any unexpected width).
```python
import polars as pl
# INTENT: enforce canonical EDFacts ID widths after a CSV fallback read.
# REASONING: force-string keeps what the file holds, but 2019 grad-rate CSVs ship
# 11-char ncessch for single-digit-FIPS states; only pad-to-width recovers them.
# ASSUMES: defense 1 (schema_overrides={"ncessch": pl.Utf8, "leaid": pl.Utf8}) applied;
# a value wider than the target width is a genuine anomaly, not a pad candidate.
df = df.with_columns(
pl.col("ncessch").cast(pl.Utf8).str.zfill(12),
pl.col("leaid").cast(pl.Utf8).str.zfill(7),
)
assert (df["ncessch"].str.len_chars() == 12).all(), "ncessch width != 12 after pad"
assert (df["leaid"].str.len_chars() == 7).all(), "leaid width != 7 after pad"
```
```r
library(stringr)
# INTENT: enforce canonical EDFacts ID widths after a CSV fallback read.
# REASONING: col_character() keeps what the file holds, but 2019 grad-rate CSVs ship
# 11-char ncessch for single-digit-FIPS states; only str_pad recovers them.
# ASSUMES: defense 1 (col_types = cols(ncessch = col_character(), leaid =
# col_character())) applied; do the pad+assert immediately after each read,
# BEFORE any bind_rows/join, so a split key never enters a downstream frame.
df <- df |>
mutate(
ncessch = str_pad(ncessch, 12, pad = "0"),
leaid = str_pad(leaid, 7, pad = "0")
)
stopifnot(all(nchar(df$ncessch) == 12), all(nchar(df$leaid) == 7))
```
> The parquet mirror stores these as Int64 (no leading zeros) but round-trips them
> losslessly, so parquet reads are unaffected — this recipe is specifically for the
> CSV fallback. See `education-data-query` → `fetch-patterns.md` § Format Handling
> ("Zero-padded ID columns") for the cross-source version of this pattern.
## Handling Special Values
### Complete Data Cleaning Function
```python
import polars as pl
def clean_edfacts_data(df, value_cols):
"""
Clean EDFacts data by handling special values.
Parameters:
-----------
df : polars.DataFrame
Raw EDFacts data
value_cols : list
Columns containing numeric values to clean
Returns:
--------
polars.DataFrame with cleaned data
"""
# Define missing value codes
missing_codes = [-1, -2, -3, -9]
for col in value_cols:
# Replace missing codes with null
df = df.with_columns(
pl.when(pl.col(col).is_in(missing_codes))
.then(None)
.otherwise(pl.col(col))
.alias(col)
)
return df
```
```r
library(dplyr)
# Clean EDFacts data by replacing special values with NA
# value_cols: character vector of columns to clean
missing_codes <- c(-1, -2, -3, -9)
df <- df |>
mutate(across(all_of(value_cols), ~ if_else(.x %in% missing_codes, NA_real_, .x)))
```
### Documenting Suppression
```python
def suppression_report(df, value_col):
"""Generate suppression report for a variable."""
total = len(df)
suppression_counts = {
"total_records": total,
"valid": (df[value_col] >= 0).sum(),
"missing_not_reported": (df[value_col] == -1).sum(),
"not_applicable": (df[value_col] == -2).sum(),
"suppressed": (df[value_col] == -3).sum(),
}
suppression_counts["pct_valid"] = suppression_counts["valid"] / total * 100
suppression_counts["pct_suppressed"] = suppression_counts["suppressed"] / total * 100
return suppression_counts
```
```r
# Generate suppression report for a variable
# value_col: column name as a string (df$value_col would look up a column
# literally named "value_col" and silently return 0 counts — use df[[value_col]])
value_col <- "read_test_pct_prof_midpt"
total <- nrow(df)
valid <- sum(df[[value_col]] >= 0, na.rm = TRUE)
missing_not_reported <- sum(df[[value_col]] == -1, na.rm = TRUE)
not_applicable <- sum(df[[value_col]] == -2, na.rm = TRUE)
suppressed <- sum(df[[value_col]] == -3, na.rm = TRUE)
cat("Total records:", total, "\n")
cat("Valid:", valid, sprintf("(%.1f%%)", valid / total * 100), "\n")
cat("Missing/not reported (-1):", missing_not_reported, "\n")
cat("Not applicable (-2):", not_applicable, "\n")
cat("Suppressed (-3):", suppressed, sprintf("(%.1f%%)", suppressed / total * 100), "\n")
```
### Working with Ranges
```python
def add_range_metrics(df, var_prefix):
"""Add range-related metrics to dataframe."""
low_col = f"{var_prefix}_low"
high_col = f"{var_prefix}_high"
midpt_col = f"{var_prefix}_midpt"
return df.with_columns([
# Range width
(pl.col(high_col) - pl.col(low_col)).alias(f"{var_prefix}_range_width"),
# Is exact (range width = 0)?
(pl.col(high_col) == pl.col(low_col)).alias(f"{var_prefix}_is_exact"),
# Relative uncertainty
pl.when(pl.col(midpt_col) > 0)
.then((pl.col(high_col) - pl.col(low_col)) / pl.col(midpt_col) * 100)
.otherwise(None)
.alias(f"{var_prefix}_relative_uncertainty")
])
```
```r
library(dplyr)
# Add range-related metrics to dataframe
# Example for read_test_pct_prof prefix
df <- df |>
mutate(
range_width = read_test_pct_prof_high - read_test_pct_prof_low,
is_exact = (read_test_pct_prof_high == read_test_pct_prof_low),
relative_uncertainty = if_else(
read_test_pct_prof_midpt > 0,
(read_test_pct_prof_high - read_test_pct_prof_low) / read_test_pct_prof_midpt * 100,
NA_real_
)
)
```
## EDFacts Data in the Portal
### Fetching EDFacts Data
EDFacts data is fetched via the mirror-based bulk download system. See `fetch-patterns.md` for the `fetch_yearly_from_mirrors()` function.
```python
import polars as pl
# School-level assessments (yearly dataset)
df = fetch_yearly_from_mirrors(
path_template="edfacts/schools_edfacts_assessments_{year}",
years=[2017, 2018],
)
# Filter to California, grade 4
ca_grade4 = df.filter(
(pl.col("fips") == 6) & (pl.col("grade_edfacts") == 4)
)
# School-level graduation rates (yearly dataset)
grad_df = fetch_yearly_from_mirrors(
path_template="edfacts/schools_edfacts_grad_rates_{year}",
years=[2018, 2019],
)
```
```r
library(arrow)
library(dplyr)
# fetch_yearly_from_mirrors() is a Python helper; in R, build the URL from the
# mirror root. Mirror failover: see
# `education-data-query/references/fetch-patterns.md` (R pattern)
mirror <- yaml::read_yaml("mirrors.yaml")$mirrors[[1]]
# NOTE: the plain read_parquet() calls below are illustrative only. EDFacts
# mirror files are Polars-written with string_view columns — a plain read fails
# under R arrow with "cannot handle Array of type <utf8_view>". Real fetch
# scripts must use the view-safe parquet read from
# `education-data-query/references/fetch-patterns.md`.
# School-level assessments (yearly dataset)
df <- read_parquet(paste0(mirror$root_url, "/", mirror$vintage$hf_revision, "/",
"edfacts/schools_edfacts_assessments_2018", ".", mirror$format))
# Filter to California, grade 4
ca_grade4 <- df |>
filter(fips == 6, grade_edfacts == 4)
# School-level graduation rates (yearly dataset)
grad_df <- read_parquet(paste0(mirror$root_url, "/", mirror$vintage$hf_revision, "/",
"edfacts/schools_edfacts_grad_rates_2019", ".", mirror$format))
```
### Codebook Authority
> **Truth Hierarchy:** This file summarizes variable definitions for convenience. When this file contradicts observed data or the live codebook, trust the higher-priority source. See the Truth Hierarchy in SKILL.md.
>
> Assessment codebooks: `get_codebook_url("edfacts/codebook_schools_edfacts_assessments")`
>
> Graduation rate codebooks: `get_codebook_url("edfacts/codebook_schools_edfacts_graduation")`
### Available EDFacts Datasets
| Level | Dataset | Path Pattern |
|-------|---------|-------------|
| Schools | Assessments | `edfacts/schools_edfacts_assessments_{year}` |
| Schools | Grad Rates | `edfacts/schools_edfacts_grad_rates_{year}` |
| Districts | Assessments | `edfacts/districts_edfacts_assessments_{year}` |
| Districts | Grad Rates | `edfacts/districts_edfacts_grad_rates_{year}` |
## Best Practices Summary
### Do
- Use `_midpt` variables for analysis
- Filter out missing values appropriately
- Document suppression rates
- Consider range width in interpretation
- Use test counts for weighting
### Don't
- Treat `-3` as 0% or ignore it
- Compare exact values to midpoints
- Assume missing means zero
- Ignore range uncertainty
- Use `_low` or `_high` alone for analysis
Related skills
| Skill | Stars | Updated | Works with | Status | Install |
|---|---|---|---|---|---|
| slack-gif-creatoranthropics/skillsKnowledge and utilities for creating animated GIFs optimized for Slack. Provides constraints, validation tools, and animation concepts. Use when users request animated GIFs for Slack like "make me a GIF of X doing Y for Slack." | Stars: 197k | Updated | Claude CodeCodex | Verified | Install |
| ponytailDietrichGebert/ponytailLazy senior dev mode for any coding task: the smallest change that fully solves it, and a reply a busy human understands in one read. | Stars: 194k | Updated | Claude CodeCodex | Verified | Install |
| ponytail-debtDietrichGebert/ponytailHarvest every shortcut: comment into one debt ledger, so deferrals get tracked instead of forgotten. One-shot report. | Stars: 194k | Updated | Claude CodeCodex | Verified | Install |
| ponytail-debtDietrichGebert/ponytailList every `shortcut:` comment (and older `ponytail:` ones) as a debt ledger. One-shot report, changes nothing. Use for "ponytail debt", "what did ponytail defer", "list the shortcuts", /ponytail-debt. | Stars: 194k | Updated | Claude CodeCodex | Verified | Install |