Research question
Which US states invest the most per public-school pupil, and how does per-pupil expenditure correlate with teacher-salary levels and district-size structure across state systems?
Methodology
We queried the PlainTeacher states table at server render time and pulled the columns state_name, avg_per_pupil_expenditure, avg_instructional_salary_per_pupil. The query ranks records by avg_per_pupil_expenditure DESC and returns the top 10. Every numeric value rendered on this page derives from a live SELECT against the production states table -- no figure is hardcoded, and the table refreshes whenever the underlying National Center for Education Statistics dataset is reingested.
Column lineage: each field maps to a typed column in the states table. Identifier columns carry the entity slug or code used elsewhere in PlainTeacher; quantitative columns store values as exported by the National Center for Education Statistics (preserving the original measurement unit). Where the source publishes values in thousands of dollars, we render them via the standard PlainTeacher money formatter that converts to billions or millions depending on magnitude. Where the source publishes raw integer counts, we render with thousand-separators preserved.
The ranking returned by this page reflects the most recent ETL run captured in the portal database. Every page load executes the same SQL against the read-only SQLite snapshot. Cache headers on the response are managed by the portal middleware: edge cache lifetime is bounded so a rebuilt dataset propagates within hours rather than days. The methodology page documents the full ETL pipeline, source vintage, and column lineage for PlainTeacher.
Coverage and exclusions: rows are filtered by the WHERE clause on the primary query to remove null or zero values on the ranking column. National Center for Education Statistics occasionally suppresses values for reasons of confidentiality, sample size, or quality control; suppressed rows are excluded from this ranking by design rather than displayed as zeros. If the underlying source revises a value in a subsequent vintage, the revised value will appear on the next ETL run without changes to this page's source code.
See the methodology page for the complete ETL pipeline, source vintage, and column lineage.
Top 10 US States by Per-Pupil Expenditure
Live data, rendered from a SELECT against the portal database at request time
- Michigan
Michigan
$46,165.155 Per-pupil spending
- New Jersey
New Jersey
$37,319.196 Per-pupil spending
- California
California
$36,710.221 Per-pupil spending
- District of Columbia
District of Columbia
$36,133.998 Per-pupil spending
- Alaska
Alaska
$34,729.488 Per-pupil spending
- New York
New York
$34,316.129 Per-pupil spending
- New Hampshire
New Hampshire
$33,796.969 Per-pupil spending
- Connecticut
Connecticut
$31,054.772 Per-pupil spending
- Pennsylvania
Pennsylvania
$30,260.026 Per-pupil spending
- Massachusetts
Massachusetts
$29,852.493 Per-pupil spending
What this shows High-spending states cluster in the Northeast and along the coasts, where local tax capacity and state-aid formulas support above-average investment per student.
The ranked top 10
Every row below is rendered from a live SELECT against the 10-row result returned by the query in the frontmatter above. Refresh the page after an ETL run to see the latest values.
| # | State | Per-pupil expenditure | Instructional salary / pupil |
|---|---|---|---|
| 1 | Michigan | $46,165 | $7,061 |
| 2 | New Jersey | $37,319 | $9,026 |
| 3 | California | $36,710 | $7,368 |
| 4 | District of Columbia | $36,134 | $10,832 |
| 5 | Alaska | $34,729 | $7,866 |
| 6 | New York | $34,316 | $11,416 |
| 7 | New Hampshire | $33,797 | $8,223 |
| 8 | Connecticut | $31,055 | $9,908 |
| 9 | Pennsylvania | $30,260 | $7,816 |
| 10 | Massachusetts | $29,852 | $9,024 |
Source: National Center for Education Statistics -- NCES F-33 -- State-level per-pupil expenditure and instructional-salary aggregates. Values are queried live from the PlainTeacher SQLite snapshot at request time; the snapshot is refreshed by the portal ETL pipeline. National Center for Education Statistics -- NCES F-33 -- State-level per-pupil expenditure and instructional-salary aggregates. Values are queried live from the PlainTeacher SQLite snapshot at request time; the snapshot is refreshed by the portal ETL pipeline.
Findings
Top entity in the ranking
The top-ranked record in this dataset is Michigan, with a value of $46,165 on the Per-pupil expenditure column. The full top-10 set is rendered in the table above. Every value derives from the underlying states table; no number is hardcoded into this page. When the source agency publishes a revision and our ETL pipeline reingests, the ranking and the prose around it update on the next page load.
Distribution shape
The gap between the top-ranked record ($46,165) and the 10th-ranked record ($29,852) characterizes how concentrated the top of the distribution is. Where the top value is many multiples of the median value of the visible set, the population is highly concentrated. Where the top and bottom of the visible set are close together, the distribution is relatively flat across the top end. The full distribution beyond this top-10 cut is summarized in the aggregate context section below and explored in the linked entity profiles.
Aggregate context
Across the full states population, the aggregate query returns the following summary statistics. These anchors situate the top-10 ranking against the underlying population: how many records exist in total, what the sum of the ranking column is across all qualifying rows, and what the mean per-record value looks like. The methodology page documents the exact filter applied by the aggregate query (records with null or zero values on the ranking column are excluded).
Source provenance
The records in this ranking originate from National Center for Education Statistics, specifically the NCES F-33 State-level per-pupil expenditure and instructional-salary aggregates. PlainTeacher ingests the source vintage published by the agency, transforms it into a normalized SQLite schema, and serves it from a read-only snapshot. Every render of this page is a fresh SELECT against that snapshot.
Why this ranking matters
Rankings like this one let a reader scan a population quickly and identify outliers, concentrations, and patterns that warrant deeper investigation. The detail pages linked from each entity in the table above give the full per-entity context: time-series history where available, related metrics from adjacent tables, and links onward to the underlying source records.
What this analysis cannot tell us
Per-pupil expenditure as reported on the F-33 includes instructional salary, instructional benefits, support services, administration, capital outlay, and debt service -- categories that vary enormously in proportion across states. A state with high per-pupil expenditure may be spending heavily on facilities or pension obligations rather than on classroom teachers; the secondary table (per-pupil instructional salary) isolates the classroom-staff share. Per-pupil figures are nominal dollars and not adjusted for cost of living. State pension-funding posture, special-education incidence, and English-learner enrollment shares all influence the headline per-pupil number without reflecting policy choices about teacher compensation specifically. F-33 fiscal-year lag means this table reflects expenditures from approximately two years prior to data release. Per-pupil rankings change modestly year-to-year; concentrated states (NY, NJ, MA, CT, DC, VT) remain near the top in most years driven by collective-bargaining law, suburban cost-of-living, and state-aid formulas.
Top 10 States by Per-Pupil Instructional Salary
Narrower than total per-pupil spend - isolates the classroom-staff dollar
- New York
New York
$11,416.357 Instructional salary/pupil
- District of Columbia
District of Columbia
$10,831.932 Instructional salary/pupil
- Connecticut
Connecticut
$9,907.644 Instructional salary/pupil
- New Jersey
New Jersey
$9,026.345 Instructional salary/pupil
- Massachusetts
Massachusetts
$9,023.825 Instructional salary/pupil
- Minnesota
Minnesota
$8,308.051 Instructional salary/pupil
- New Hampshire
New Hampshire
$8,223.104 Instructional salary/pupil
- Rhode Island
Rhode Island
$8,168.996 Instructional salary/pupil
- Alaska
Alaska
$7,865.588 Instructional salary/pupil
- Pennsylvania
Pennsylvania
$7,816.309 Instructional salary/pupil
What this shows Per-pupil instructional salary isolates the classroom-teacher share of total spending, a more direct measure of investment in teaching staff than the broader expenditure total.
What per-pupil spending captures
Per-pupil expenditure bundles many cost categories that vary independently across states. State funding-formula weights, federal Title I allocations, and special-education excess-cost reimbursement all raise totals in high-need systems. Capital outlays, transportation, food service, and facilities maintenance add overhead unrelated to classroom instruction, so a high figure does not always translate into higher teacher compensation. Regional labor markets, enrollment density, and the urban-rural mix further separate spending from outcomes. Reading the ranking carefully means distinguishing operating dollars that reach educators from fixed and categorical costs that a district must absorb regardless of its salary schedule.
Sources
- National Center for Education Statistics -- Common Core of Data (CCD) -- https://nces.ed.gov/ccd/
- NCES F-33 Annual Survey of School System Finances -- https://nces.ed.gov/ccd/f33agency.asp
- Education Commission of the States -- State Education Finance reports -- https://www.ecs.org/