Collections ยท Included with a Data Pass
Every U.S. public school, with enrollment and teachers.
99,088 open public schools in the 50 states and D.C. for 2024-25, from the Department of Education. Each has its district, type, grades, charter status, address, county, coordinates and website, plus enrollment, teachers, students per teacher, and how many students qualify for free or reduced-price lunch.
- Rows
- 99,088
- Columns
- 26
- Formats
- CSV, JSON, XML
As of: The 2024-25 school year, from the Common Core of Data and NCES school locations released in July 2025. The Department of Education publishes each school year's data the following summer.
Preview
A few real rows
| Name | District | Level | LowestGrade | HighestGrade | Enrollment | StudentTeacherRatio |
|---|---|---|---|---|---|---|
| Boulder High School | Boulder Valley School District No. Re2 | High | 9 | 12 | 1939 | 21.3 |
| Fairview High School | Boulder Valley School District No. Re2 | High | 9 | 12 | 1863 | 23.1 |
| Williamsburg Academy of Colorado | EDUCATION REENVISIONED BOCES | High | 6 | 12 | 622 | 30.8 |
| Centennial Middle School | Boulder Valley School District No. Re2 | Middle | 6 | 8 | 598 | 19.4 |
| Southern Hills Middle School | Boulder Valley School District No. Re2 | Middle | 6 | 8 | 502 | 19.3 |
| Nevin Platt Middle School | Boulder Valley School District No. Re2 | Middle | 6 | 8 | 483 | 16.9 |
| Manhattan Middle School of the Arts and Academics | Boulder Valley School District No. Re2 | Middle | 6 | 8 | 482 | 16.9 |
| Foothill Elementary School | Boulder Valley School District No. Re2 | Elementary | K | 5 | 419 | 16.6 |
Field guide
What's in each row
The school
Federal ID, name, district and district ID, type, level, grades served, and whether it is a charter or fully virtual school.
NCESSchoolID Name District NCESDistrictID SchoolType Level LowestGrade HighestGrade IsCharter IsFullyVirtual
Location and contact
Address, county, coordinates, the kind of place it is in, phone and website.
Address City StateCode ZipCode CountyFIPS County Latitude Longitude Locale Phone Website
Students and staff
2024-25 enrollment, full-time-equivalent teachers, students per teacher, and students eligible for free or reduced-price lunch.
Enrollment Teachers StudentTeacherRatio FreeReducedLunch
Good to know
Before you use it
- Only schools open in 2024-25 are included. Names, districts and counts are as each state reports them, so some states use capital letters.
- Teachers are full-time equivalents. StudentTeacherRatio is enrollment divided by teachers, so a virtual school or one that shares teachers can look unusual.
- FreeReducedLunch is the number of students eligible for free or reduced-price lunch, the usual measure of a school's poverty level. Some states don't report it.
- NCESSchoolID and NCESDistrictID are the federal IDs, so you can join this to other Department of Education data.
- In every format, dates are written as yyyy-MM-dd, and yes/no values as true or false. An empty value means nothing was recorded.
Source
U.S. Department of Education, NCES Common Core of Data
Public domain
NCES Education Demographic and Geographic Estimates (EDGE)
Public domain
Where it comes in handy
What you can build with it
- School finders. Search schools by city, ZIP code or district, or put them on a map.
- Real estate. Show the schools near a home, with grades and size.
- Education products. Let teachers and families pick their school from a clean list.
- Research. Compare size, staffing and poverty across districts and states.
Access
Try it free. Get all of it with a pass.
Free sample
- Every 200th school
- A README with the field guide and source
Data Pass $69
- All 99,088 rows of U.S. public schools
- One ZIP in CSV, JSON or XML, with a README
- Also every other collection and the whole dataset catalog, for 365 days
Already have a pass?
Your key is used for this request and is not saved by this page.
Commercial use is allowed, free or paid. Keep using what you download, even after your pass ends.