Skip to the content.

Data Sources — higher-education-cost

All data used in this project is from authoritative sources. Crowd-edited references (Wikipedia, etc.) are not used as primary sources.

Document every data source here before ingesting it. Include enough detail that someone else could independently locate and verify the original data.


Source Template

Copy and fill in for each source:

[Source Name]


Sources

The URLs and structure below were confirmed live during 01-ingest on 2026-09-30. Two IPEDS collection years (2011-12 and 2021-22) were pulled to support the over-time story; 01-ingest.ipynb narrates every download.

IPEDS — Integrated Postsecondary Education Data System

College Scorecard

BLS Consumer Price Index (CPI-U)

BLS CPI-U sector subindices (REFRAME — “big education” relative inflation)

IPEDS 12-month FTE (EFIA) — re-ingested in 02-clean

Supplemental (validation / context)


Reframe-expansion sources (second wave — ingested 2026-10)

Four more authoritative U.S. federal / public-domain sources, added to answer the reframe’s Suspicion-1 “how dramatic is the long tuition climb?” and Suspicion-2 “is the driver administration?” questions. Each re-enters at 01-ingest.

A. NCES Digest of Education Statistics — Table 330.10 (long tuition history)

B. NCES Delta Cost Project Database 1987-2012 (harmonized spending-by-function)

C. Raw IPEDS Finance tail 2013-2021 (extend the spending mix to the present)

D. IPEDS Human Resources S<year>_OC (admin vs faculty headcount)

⭐ Honest-framing note (Suspicion 2). The spending-mix data (Delta + IPEDS tail) shows non-instructional spending (student services + academic support

⭐ “Admin” is a definitional choice (chart 4 caveat — carried to the README). Chart 4’s “admin” is IPEDS institutional support only, a specific accounting category. Different definitions of administration yield different “bloat” magnitudes, and the choice matters: microdata analyses of administrator headcount — e.g. FIRE / Kay & Honeycutt, 2025 — find MORE administrative growth than the IPEDS spending-share accounting shows. So “admin spending share is roughly flat (~15%)” is true for this accounting measure and does NOT contradict headcount-based findings that administrators grew faster than faculty; the two measure different things (share of dollars vs count of people). Chart 4 and the README state this explicitly so the slopegraph isn’t misread as “admin exploded.”

Plain-English definitions of the four core functional categories (for the README and codebook): instruction = teaching activity (faculty salaries, academic departments, instructional operations); institutional support (= “admin”) = executive management, general administration, finance, HR, legal, and public relations; academic support = libraries, academic computing, museums, deans’ offices, curriculum development, and other support of the instruction/research mission; student services = admissions, the registrar, financial-aid administration, counseling, career services, and student activities.


Harmonization & series-break caveats (settled in 02-clean)

Carried forward into chart footnotes and the _sources methodology / series_breaks columns for the harmonized tables.


Notes on Data Quality


Source Provenance in DuckDB

Every table in data/project.duckdb has a corresponding entry in the _sources metadata table:

SELECT * FROM _sources;