Data Sources & Methodology

All students; NAEP official jurisdiction labels. MN:MN average scale score; ALC:AP cumulative percentage at or above NAEP Proficient. Shelby County participated 2017–2022 per NCES TUDA. Large city is a separate benchmark, not a Chamber district. Chamber districts with no TUDA jurisdiction are omitted; no older-year substitution.

Last fetched:

2026-11-01T21:02:32.750836+00:00

Refresh:

Run: python3 scripts/fetch_naep_tuda.py --from-dir data/raw/naep-tuda

Early Childhood indicators are maintained by their dedicated source pipelines. Funded Pre-K seats, actual enrollment, and waitlist counts remain unpublished -- see docs/DATA_GAPS.md -- and stay a declared gap alongside the live indicators above. Verified source pipelines: alice-context, birth-outcomes, childcare-quality.

Last fetched:

2026-09-15T17:28:08+00:00

Refresh:

Run: python3 scripts/process_all.py

Snapshot KPIs are maintained by separate TDOE source pipelines. Verified source pipelines: absenteeism, assessment, cohort, enrollment, growth, postsecondary.

Last fetched:

2026-06-24T21:33:49+00:00

Refresh:

Run: python3 scripts/process_all.py

Assessment, growth, cohort, attendance, and discipline fields are maintained by separate source pipelines. Verified source pipelines: absenteeism, assessment, cohort, discipline, growth.

Last fetched:

2026-06-24T21:33:49+00:00

Refresh:

Run: python3 scripts/process_all.py

Board baseline metrics are maintained by their dedicated source pipelines. Verified source pipelines: absenteeism, assessment, cohort, discipline, educators, finance, growth, postsecondary.

Last fetched:

2026-06-24T21:33:49+00:00

Refresh:

Run: python3 scripts/process_all.py

MSCS and Tennessee peer per-pupil expenditures use the same TDOE district-average finance field. Local revenue allocation remains a separately documented gap.

Last fetched:

2026-02-27T15:12:26+00:00

Refresh:

Run: python3 scripts/fetch_tdoe_finance.py

Published PPCSTOT, Table 18 total current elementary-secondary spending per pupil, current dollars. Census excludes non-elementary-secondary programs and spending for pupils outside fall membership; not total expenditure or TDOE spending. FY2024 is the latest official final file found on 2026-11-01. NCESID joins resolve the named districts, not cities/counties/metropolitan areas. The Census technical documentation excludes nongovernmental charter operators; the lone Orleans Parish district row has only 2,128 fall members, so New Orleans is omitted rather than falsely labeled all-charter. Fiscal-year endpoints vary by state; Census does not adjust them to one calendar.

Last fetched:

2026-11-01T21:07:18.453825+00:00

Refresh:

Run: python3 scripts/fetch_census_f33.py --from-dir data/raw/census-f33

Tracks Memphis-Shelby County Schools (MSCS) graduates enrolled in any postsecondary institution in the summer, fall, or following spring. Completion and persistence remain data gaps.

Last fetched:

2024-12-19T17:11:11+00:00

Refresh:

Run: python3 scripts/fetch_tdoe_postsecondary.py

A hand-curated registry of public goals set for Memphis students — by statewide advocates, by the district itself, and by this project. Every goal quotes a published source document; MSCS comparison values come only from this dashboard's verified TDOE pipelines. Statewide targets are shown next to district values for context, never as if they were district targets.

Last fetched:

2026-07-15T19:30:00+00:00

Refresh:

Edit data/goals.json by hand following docs/GOALS.md; every goal must cite a published source document.

Current Memphis-Shelby County Schools (MSCS) school IDs/names come from the TDOE Profile file. Street addresses and TNSD school types come from the public Tennessee School Directory, joined only on exact school ID. Coordinates are Census Geocoder matches to those addresses; an exact-name OpenStreetMap school-place match is used only when Census has no address match. One maintainer-verified campus coordinate is retained as an explicit ID-keyed override. 0 of 206 schools had no verified geocode and were left absent.

Last fetched:

2026-07-15T07:02:26+00:00

Refresh:

Run: python3 scripts/build_school_lookup.py --directory /path/to/TN-School-Directory.xlsx

Verified sector counts are derived from the exact-ID Memphis-Shelby County Schools (MSCS) school lookup. School-level performance for every MSCS school now has its own section and data file (data/school_performance.json); teacher-workforce measures remain an explicit public-data gap here.

Last fetched:

2026-07-15T07:02:26+00:00

Refresh:

Run: python3 scripts/build_system_structure.py after refreshing data/school_lookup.json

School-level TCAP ELA/Math proficiency (fetch_tdoe_school_performance.py) and TVAAS literacy-and-numeracy growth composites (this script) for every Memphis-Shelby County Schools (MSCS) school (traditional zone and charter, distinguished by operatorType) plus Memphis's three alternative-LEA authorizers. TN Public Charter School Commission (system 987) is filtered to six verified Memphis school IDs; its statewide aggregate is never used. Suppressed cells remain null and are never estimated. 2020-21 TVAAS is recorded as not rated (value null, not suppressed) per the same project spec fetch_tdoe_growth.py applies at district level, even though TDOE publishes a composite file for that year. No 2020 assessment or 2026 school file exists; series ends in 2024-25.

Last fetched:

2025-09-05T16:44:10+00:00

Refresh:

Run: python3 scripts/fetch_tdoe_school_performance.py && python3 scripts/fetch_tdoe_school_performance_growth.py

October 1 enrollment (membership) headcounts for every Memphis-Shelby County Schools (MSCS) school on the current roster, from TDOE's School Profile files, with traditional-vs-charter totals. A school with fewer than 10 students is published by TDOE as text and shown here as suppressed, never zero. Totals sum only schools on the current MSCS roster: schools that closed or left MSCS before 2024-25 are not included, so 2022-23 and 2023-24 undercount by roughly 1%; 2024-25 covers every roster school. These are October 1 counts and will not match the 40th-day counts in MSCS's authorizer report. Source files are kept in data/raw/tdoe-school-enrollment/ because tn.gov blocks the pipeline server's downloads.

Last fetched:

2025-12-18T20:13:14+00:00

Refresh:

Run: python3 scripts/fetch_tdoe_school_enrollment.py --from-dir, then python3 scripts/build_data_files.py

Per-program results from the Tennessee State Board of Education's Educator Preparation Report Card, joined to where each program's new teachers first taught. Read these limits before quoting a figure: (1) Each Report Card edition covers three completer cohorts (edition 2025 = cohorts 2022-2024), so a placement count is a three-cohort window total, not one year's hiring, and consecutive editions overlap by two cohorts. (2) Placement is the first Tennessee district a teacher worked in; it counts new graduates of Tennessee programs and says nothing about experienced, out-of-state or uncertified hires. (3) Retention means still teaching in any Tennessee public school, not staying in Memphis. (4) The 2025 edition changed scoring (80 points instead of 90 and a different candidate-assessment metric), so ratings are shown per edition and never trended across 2024/2025. (5) Values for fewer than 10 people are withheld by the State Board and shown as suppressed, never zero. Programs are joined across files by name (the placement files carry no program code). Source files are kept in data/raw/tn-sbe-educator-prep/ because tn.gov blocks the pipeline server's downloads.

Last fetched:

2026-02-13T16:05:58+00:00

Refresh:

Run: python3 scripts/fetch_tn_sbe_educator_prep.py --from-dir, then python3 scripts/build_data_files.py

Community Conditions indicators are maintained by their dedicated source pipelines (Census ACS/SAIPE/SAHIE, TN DoH vital statistics, United For ALICE). Prenatal care timing has no reproducible Shelby-grain source today -- see docs/PROJECT_NOTES.md. Verified source pipelines: alice-context, birth-outcomes, census-child-context.

Last fetched:

2024-12-31T00:00:00+00:00

Refresh:

Run: python3 scripts/process_all.py

Ten district-grain metrics across all seven Shelby County public LEAs (MSCS plus the six municipal districts that split off in 2014), plus an enrollment/cohort-weighted county aggregate for every metric except the TVAAS growth composite (deliberately not averaged -- see module docstring). A subgroup comparison (Black, Economically Disadvantaged, White, Hispanic, and Students with Disabilities ELA/Math proficiency, district by district) rides alongside the district-total table -- added 2026-09-22 in response to a direct equity-framing concern that an All-Students-only comparison could read as MSCS underperforming rather than showing that its own subgroups score below the same subgroups everywhere else in the county. Lakeland (797) has no graduation-rate row: it operates no high school, a structural absence, not a TDOE suppression. Distinct from data/peer_comparisons.json, which compares MSCS to other Tennessee districts, not its own county neighbors.

Last fetched:

2026-08-25T18:55:01+00:00

Refresh:

Run: python3 scripts/build_shelby_county_comparisons.py

Per-building facility condition for 149 Memphis-Shelby County Schools (MSCS) zone buildings: Facility Condition Index (3/5/10-year), immediate / 1-2 year / 20-year repair needs, replacement value, building age. Republished by Memphis Education Fund from MSCS's Blueprint for Greatness capital-planning assessments; the assessment vendor, date and FCI definition are not stated in the export and are unconfirmed. Charter schools (which mostly occupy buildings they do not get from MSCS) are not covered. 7 buildings could not be tied to a TDOE school id and carry schoolId null; Hollis F. Price Middle College High has no assessment values in the export.

Last fetched:

2026-10-06T19:17:53+00:00

Refresh:

Manual snapshot: ask the maintainer for a refreshed export, then run python3 scripts/load_facility_conditions.py --csv <export>. Replace with a direct Blueprint for Greatness pull if the primary-source reports prove machine-readable.