Browse Public Schools

Explore all 95,891 public K-12 schools with NCES data

PlainSchools maintains a complete index of every public school in the United States that reports to the NCES Common Core of Data (CCD), the federal universe file that captures enrollment, governance, geography, and program participation for elementary, middle, and high schools. The browse view supports paginated traversal of the full universe alongside an A–Z alphabetical jump, sort-by enrollment, sort-by type, and a per-school detail page that synthesizes demographics, resources, and district context against state and national peer distributions.

How the index is built: the NCES Common Core of Data is the United States Department of Education's annual census of public elementary and secondary schools, districts, and state education agencies. Each year the Department compiles administrative records from every state education agency into a unified national file that documents which schools exist, how many students each enrolls, what grade span each serves, which districts each belongs to, what governance type each falls under (traditional, charter, magnet, virtual, alternative), and which federal programs each participates in (Title I, special education, gifted and talented, free and reduced lunch, English language learners). Our pipeline downloads the most recent release of the universe file each cycle, validates the foreign-key integrity between schools and districts and states, recomputes derived columns such as student-teacher ratio and free-lunch share where the source publishes the underlying inputs but not the ratio, and writes the resulting normalized snapshot into the portal database. Every browse-table row on this page traces back to a single row in the universe file via the NCES identifier — the canonical key the Department uses across its own programs and that researchers can use to cross-reference any external file that publishes per-school metrics.

What the browse table renders: name, enrollment, school type (regular, special education, vocational, alternative — the four canonical school-type categories defined by the National Center for Education Statistics), and school level (elementary, middle, high, other — derived from the grade span each school reports). The pagination header at the top of the table shows the total record count returned by the active query so visitors always see honest scale. Sort options are restricted to a server-side allowlist — alphabetical name, descending enrollment, school type — to prevent arbitrary-column attacks against the database. Each row links directly to the per-school detail page, which renders a full synthesis of NCES enrollment plus Civil Rights Data Collection (CRDC) discipline and absenteeism plus F-33 school district finance survey per-pupil expenditure plus state and national peer benchmarks for every metric that can be computed.

Why this matters: the federal universe of public K-12 schools is large enough that browsing without an index quickly becomes impossible. There are approximately 130,000 active public schools serving over 50 million enrolled students; published sources tend to surface a small ranked subset (largest, top-rated, fastest-growing) rather than the full distribution. PlainSchools chooses to expose the full universe in browsable form precisely because the long tail is where most students actually attend school — the average school enrolls under 500 students, the median is smaller still, and the very large schools that dominate news rankings are statistical outliers. By giving every school a stable URL and a detail page, the portal lets families researching a specific school find authoritative federal data without needing to download a 300MB universe file or navigate the agency's interactive table tools. Researchers can cite each school's page as a stable persistent reference; journalists can link to it from articles; parents can scan the same page that the principal of that school would use to verify their school's federal record.

Coverage and limits: this index covers every public school reporting to NCES in the most recent universe file vintage. Private schools, religious schools that have not joined a public charter network, and homeschool cooperatives are not in this file and therefore are not in this index. Special-purpose schools — youth correctional facilities, juvenile detention schools, schools operated by federal agencies (Bureau of Indian Education, Department of Defense Education Activity), and virtual-only charter schools — do appear because they report to NCES even though their operating model differs significantly from a conventional geographic school. The methodology page documents how each special-purpose category appears in the file and how our schema represents them. When the underlying file is updated (typically annually, with mid-cycle corrections), the data on this page refreshes automatically once the next ETL run completes — no separate manual content update is required to surface the new vintage.