This codebook covers every column in the dashboard's downloads. Each variable lists its name in the file, what it holds in plain words, how it was built, its source, and the numbered decision behind it. The decision numbers (D061 to D074) refer to the MAM census database's decision log.
How the data were built
Every step reads only files whose fingerprint (SHA-256) matches the one recorded when the file was downloaded or made. A step stops if any input does not match, and it never overwrites a file.
- Download.
01_download_acs.shpulls American Community Survey 5-year tables from the Census Data API for Mississippi and Tennessee school districts. The dashboard uses the 2020-2024 estimates. Other downloads: Census TIGER/Line 2024 school district boundaries (04_download_tiger.sh), Tennessee district profiles (05_download_state_files.sh, saved from a browser when the site refused scripted downloads), and, saved from a browser, the Mississippi enrollment file, the Mississippi school meals (CEP) list, the NCES directory, and USDA's SNAP-Authorized Retailer Access Map. - Clean.
10_build_acs_long.Rturns each raw ACS file into a long table with one row per district and variable: the estimate, its 90% margin of error, and any Census special code (D067). - Build. Stata 19 do-files make the dashboard's data (D067):
30_dashboard_districts.do: the 277 districts, their IDs, K-12 enrollment, and who the state counts now.31_dashboard_indicators.do: 17 census indicators with margins of error.32_dashboard_map.do: the simplified district shapes.33_dashboard_food.do: the food access indicator.34_dashboard_neighbors.do: which districts border each other.
- Check. Each product was recomputed separately in Python, cell by cell, before it went on the dashboard.
- Show. The dashboard's files in
data/are exact copies of those products. The index, re-sharing and dollars are worked out in the browser (D071).
Districts and IDs
The dashboard shows the school systems each state's formula pays (D063, D068).
- Mississippi: 137 unified (K-12) districts.
- Tennessee: 140. That is 124 unified districts plus 16 city K-8 systems. The Census also draws 16 "secondary" pieces: county high-school areas inside those cities. Their students are funded through the county system, so they are not shown separately. A county system is described by the census numbers for its own K-12 area only.
- Left off: Fort Campbell Schools (4700078). It is a census district but is not in Tennessee's district profile and is not funded by TISA.
- Census figures describe everyone living in a district's area, not the students enrolled in it.
| Name in file | What it is | How it was built | Source | Decision |
|---|---|---|---|---|
state | State: MS or TN | From the first two digits of the federal ID (28 is Mississippi, 47 is Tennessee). | Census | D063 |
leaid | Federal district ID (NCES LEA ID), 7 digits | The Census school district code, which is the same as the NCES ID. Kept as text so leading digits are never lost. Always included in downloads, so rows can be matched to other files. | Census ACS and TIGER/Line, NCES | D063 |
st_no | State district number | st_leaid without the state prefix and leading zeros. MS-0200 is MDE district 200, TN-00751 is TDOE district 751. | NCES CCD 2024-25 preliminary directory | D068 |
st_leaid | State LEA ID as NCES lists it | As published. | NCES CCD 2024-25 preliminary directory | D068 |
name_census | District name as the Census writes it | As published, with the state name at the end. | Census ACS | D063 |
name_state | District name in the state's file | As published by TDOE or MDE. | TDOE district profile, MDE enrollment | D066 |
name_ccd | District name in the NCES directory | As published. | NCES CCD 2024-25 | D068 |
district_type | Census district type: unified (K-12) or elementary (K-8) | From which Census district file the district comes from. Only Tennessee's 16 city systems are elementary. | Census ACS | D063 |
district | District name (in your results) | The Census name without the state at the end. | Census ACS | D063 |
Margins of error
The ACS is a survey, so every estimate has a margin of error. Each _moe column is the 90% margin of error: the true value is likely within that many points of the estimate. Small districts often have wide margins.
- Published percents: the Census margin of error as published.
- 100 minus a published percent (no broadband, adults without a diploma): keeps the published margin of error.
- Percents we built from counts use the Census Bureau's formulas from Understanding and Using American Community Survey Data:
- sum or difference of counts: the square root of the sum of each margin of error squared
- a share p = numerator / denominator: the square root of (numerator margin squared minus p squared times denominator margin squared), divided by the denominator
- if the number under that square root is negative, the ratio formula is used instead: plus in place of minus. This happened for rent burden in 9 districts.
- Food access has no margin of error. USDA publishes none.
Decision: D069.
Indicators
Each indicator has two columns: _est (the value) and _moe (its margin of error). Seventeen are from the ACS 2020-2024 5-year estimates (D069). Food access is from USDA (D073). Higher means more need for every indicator except median household income, which is flipped so lower income counts as more need. Groups follow the dashboard's domains (D072, D073).
Income and work
| Name in file | What it is | How it was built | Source | Decision |
|---|---|---|---|---|
inc185 | Kids ages 6 to 17 in families below 185% of the poverty line (%). 185% is the reduced-price school meal line. | Built from counts. Numerator: kids 6 to 11 and 12 to 17 with an income-to-poverty ratio under 1.85 (the seven groups from "Under .50" to "1.75 to 1.84", for each age group). Denominator: all kids 6 to 11 plus 12 to 17. Times 100. | ACS B17024_016 to _022 and _029 to _035, over B17024_015 + B17024_028 | D069 |
pov517 | Kids ages 5 to 17 below the poverty line (%) | As published. | ACS S1701_C03_004 | D069 |
unemp | Unemployment rate, people 16 and over (%) | As published. | ACS S2301_C04_001 | D069 |
mhhi | Median household income (2024 dollars) | As published. On the dashboard it is flipped before scaling, so lower income counts as more need. Downloads show the value before flipping. | ACS B19013_001 | D069 |
gini | Gini index of income inequality, 0 (everyone equal) to 1 | As published. It measures how spread out incomes are in the district, not how many families are poor. Higher counts as more need. Users choose whether to use it. | ACS B19083_001 | D069 |
Food
| Name in file | What it is | How it was built | Source | Decision |
|---|---|---|---|---|
foodkids | Kids ages 0 to 17 who live far from a store that takes SNAP (%). Far means more than 1 mile by road in an urban census tract, or more than 10 miles by road in a rural one. | For each tract, kids with low access is the 1-mile count if the tract is urban and the 10-mile count if it is rural. Each tract's kids with low access and all kids are split across districts by the share of the tract's people living in each district, then added up. Value = 100 × kids with low access / all kids. This treats kids as spread like everyone else within a tract. USDA's own "kids share" columns divide by a tract's total population, so they are not used. Driving distance was chosen because straight-line distance puts almost every rural tract at zero. The kids, all-residents and low-income versions are nearly identical within tracts (correlation 1.00), so only kids is used. Six districts are at 0. | USDA ERS SNAP-Authorized Retailer Access Map, July 2026 release (stores as of June 2025, 2020 Census, 2020 tracts): DD_SRAM_lakids1, DD_SRAM_lakids10, TractKids, Urban. Team tract-to-district crosswalk (share_of_tract_pop). | D073 |
snap | Households that received SNAP (food stamps) in the past 12 months (%) | As published. | ACS S2201_C04_001 | D061, D069 |
Health and housing
| Name in file | What it is | How it was built | Source | Decision |
|---|---|---|---|---|
unins | Kids under 19 with no health insurance (%) | As published. | ACS S2701_C05_011 | D069 |
crowd | Households with more than 1 person per room (%) | Built from counts. Numerator: owner and renter households with 1.01 to 1.50, 1.51 to 2.00, or 2.01 or more people per room. Denominator: all occupied housing units. Times 100. | ACS B25014_005, _006, _007, _011, _012, _013, over B25014_001 | D069 |
plumb | Households lacking complete plumbing (%) | Built from counts. Numerator: owner and renter households lacking plumbing facilities. Denominator: all occupied housing units. Times 100. | ACS B25049_004 + _007, over B25049_001 | D069 |
rentburden | Renter households paying 35% or more of income on rent (%) | Built from counts. Numerator: renters paying 35.0 to 39.9%, 40.0 to 49.9%, or 50% or more. Denominator: all renter households minus those whose share could not be computed. Times 100. | ACS B25070_008 + _009 + _010, over B25070_001 minus B25070_011 | D069 |
moved | People 1 and over who lived in a different house a year ago (%) | Built from counts. Numerator: everyone 1 and over minus those in the same house a year ago. Denominator: everyone 1 and over. Times 100. | ACS B07003_001 minus B07003_004, over B07003_001 | D069 |
Getting around and getting online
| Name in file | What it is | How it was built | Source | Decision |
|---|---|---|---|---|
noveh | Households with no vehicle available (%) | As published. | ACS S2504_C02_027 | D069 |
nobb | Households without a broadband internet subscription of any type (%) | 100 minus the published share with broadband of any type. Keeps the published margin of error. | ACS S2801_C02_014 | D069 |
nocomp | Households without a computer (%) | As published. | ACS S2801_C02_011 | D069 |
Family and language
| Name in file | What it is | How it was built | Source | Decision |
|---|---|---|---|---|
nohs | Adults 25 and over without a high school diploma or equivalent (%) | 100 minus the published share who are high school graduates or higher. Keeps the published margin of error. | ACS S1501_C02_014 | D061, D069 |
lep | People 5 and over who speak English less than "very well" (%) | As published. | ACS S1601_C06_001 | D061, D069 |
singlepar | Families with their own children under 18 headed by a single parent (%) | Built from counts. Numerator: male and female householders with no spouse present, with their own children under 18. Denominator: those plus married couples with their own children under 18. Times 100. | ACS B11003_010 + _016, over B11003_003 + _010 + _016 | D069 |
Other
| Name in file | What it is | How it was built | Source | Decision |
|---|---|---|---|---|
kids617 | Children ages 6 to 17 (a count, not an indicator) | Kids 6 to 11 plus kids 12 to 17. Margin of error from the sum formula. Kept for context, not offered as an indicator. | ACS B17024_015 + B17024_028 | D069 |
Funding inputs
Who each state counts now, and the rules in law (D064, D066). Both states fund a year on the prior year's students, so 2024-25 counts feed 2025-26 (Tennessee) and FY26 (Mississippi) money.
| Name in file | What it is | How it was built | Source | Decision |
|---|---|---|---|---|
enroll_k12 | K-12 enrollment, 2024-25 | Tennessee: the K-12 total in the district profile. Mississippi: total enrollment minus Infant/Toddler, Pre-K, Sped Pre-K, Grade 13, Adult Education and Secondary GED. A starred cell among those (fewer than 10 students, hidden by MDE) is counted as 0, so a Mississippi count can be high by up to 9 per starred cell. | TDOE district profile 2024-25, MDE enrollment download | D066 |
base_pct | Share of students the state counts now (%) | Tennessee: the economically disadvantaged percent, which TDOE publishes as a whole number, so a district can be off by up to half a percentage point. Mississippi: the district-wide identified student percentage from the school meals (CEP) list, data as of April 14, 2025. This is the school meals measure, close to but not confirmed identical to the low-income count MSFF uses. | TDOE district profile 2024-25, MDE Office of Child Nutrition CEP list | D066 |
base_count | Students the state counts now | enroll_k12 × base_pct / 100. | Built | D066 |
base_measure | Which measure base_pct is | Text describing the measure and file. | Built | D066 |
enroll_source | Which file enroll_k12 is from | Text describing the file and what was subtracted. | Built | D066 |
ms_starred_cells | Mississippi: hidden enrollment cells counted as 0 | How many of the subtracted groups were starred for the district. Empty for Tennessee. | MDE enrollment download | D066 |
cep_id, cep_name | Mississippi: the district's ID and name in the school meals list | Matched on the MDE district number. West Tallahatchie is listed under meal-program ID 00149 and was matched by name. Empty for Tennessee. | MDE CEP list (PDF, read with pdfplumber) | D066 |
formula, formula_year | The state formula and year | TISA 2025-26 (Tennessee), MSFF FY26 (Mississippi). | State law | D064 |
base_amount | Base amount per student, in law (dollars) | Tennessee $7,295. Mississippi $6,842.61, from George County School District's FY26 budget hearing (July 29, 2025), not yet confirmed in an MDE document. | TISA Overview (April 2026), George County SD FY26 budget hearing | D064 |
poverty_weight | Extra share of the base for each counted student | Tennessee 0.25 (economically disadvantaged). Mississippi 0.30 (low-income). | State law | D064 |
concentration_weight, concentration_line | Mississippi's concentrated poverty rule | Mississippi: 0.10 of the base for each low-income student above 0.35 (35%) of enrollment. Tennessee: 0 in this file. Tennessee's 5% concentrated poverty weight is set school by school, so it is not modeled and stays at its current amount. | State law | D064, D065 |
Your results
Computed in the browser from your choices (D064, D065, D071). Each state is ranked on its own. With both states in one file, each state's rows are still ranked within that state.
| Name in file | What it is | How it was built | Decision |
|---|---|---|---|
val_indicator | The district's value on each indicator you chose | The _est value from the indicators file, before flipping. | D069 |
sc_indicator | That value after scaling | Median household income is flipped first (multiplied by −1). Then, across the state's districts:
| D069, D071 |
w_indicator | Your weight on that indicator | Points out of 100. | D064 |
scaling | The scaling method you chose | rank, minmax or z. | D071 |
index | Your index of need | The sum of weight × scaled value, divided by 100, rounded to 9 decimals so districts with equal scores tie exactly. | D071 |
rank_now | Rank by the share the state counts now | 1 is the highest base_pct in the state. Exact ties go to the district listed first alphabetically. | D065 |
rank_yours | Rank by your index | 1 is the most need. Exact ties go to the district listed first alphabetically. | D071 |
rank_move | Places moved up | rank_now − rank_yours. Positive means the district ranks as higher need on your index than on the state's measure. | D065 |
count_now | Students the state counts now | Same as base_count. | D066 |
count_yours | Students counted after re-sharing by your index |
| D065 |
dollars_now | Poverty-weight dollars now | count_now × poverty weight × base amount. Mississippi adds max(0, count_now − 0.35 × enrollment) × 0.10 × base amount. | D064 |
dollars_yours | Poverty-weight dollars under your index | The same formula with count_yours. In Mississippi the state total can shift a little because the 35% rule is recomputed. In Tennessee the total stays the same. | D064, D065 |
change | Change in poverty-weight dollars | dollars_yours − dollars_now. | D064 |
change_per_student | Change per K-12 student (dollars) | change / enroll_k12. | D064 |
Map and neighbors
- Map shapes (
data/map.geojson): the 277 districts from the 2024 TIGER/Line unified and elementary files. Each boundary is simplified on its own to about 200 meters (0.002 degrees) and coordinates are rounded to 4 decimals, so shared borders can differ slightly up close. Fort Campbell shows as a gap. Shapes only, no data values. Decision D070. - Neighbors (
data/neighbors.csv): two districts border each other if they are in the same state and share at least 0.00001 degrees (about 1 meter) of border in the full 2024 TIGER/Line boundaries. Touching only at a corner does not count. Built from the full boundaries because the simplified map shapes gave 16 wrong pairs out of 655. 655 pairs, and every district has at least one neighbor. Decision D074. - Tract-to-district shares (used for food access): the team's 2024 crosswalk, built from 2020 Census blocks. For each tract and district, the share of the tract's people living in that district. Every tract with people adds up to 1 across districts. Decision D073.
Data files and fingerprints
The files in data/ are exact copies of the database products. A file's fingerprint (SHA-256) changes if even one character changes.
| File | Made by | SHA-256 |
|---|---|---|
districts.csv | 30_dashboard_districts.do | ea7759ca0e7df88ff6144a75b78101f5ac6504cd1da000c3875a6c53f9db0f8c |
indicators.csv | 31_dashboard_indicators.do | 8c870d39bc5a687368738076dbd63eee73402c34c9a0ec67f26b6c155395010b |
map.geojson | 32_dashboard_map.do | 1101a3c55047a759cff6ddda4b04fe54520e19779fc23b4d85456ebddb90cc02 |
food.csv | 33_dashboard_food.do | 09e699a888f049d0f6bae32380924b46135f9444dec8a0bb8c8c63355933f6ef |
neighbors.csv | 34_dashboard_neighbors.do | 06b550f90b61e61bfc12ec76f108aabd5f7dbe9e7cc511350d69a2a27ad19574 |
Full sources, with links, are in the README.