US Public Schools
U.S. · 101,110 locations

Every public school in the United States — 101,110 campuses for the 2024-25 school year, straight from the federal Common Core of Data.

More about this list

Street address, phone and map coordinates on every record and a school website on 68.8%, plus enrolment, enrolment by grade, by sex and by ethnicity, teacher count, student-teacher ratio, grade range, school level, district name and federal district ID, charter and virtual flags, free and reduced-price lunch counts and percentages, locale, metro area and congressional district. The 8,234 charter schools are included and flagged. No contact names — this is a list of schools, not of people. One row is one public school campus at its physical address — 101,110 of them, every school the federal directory lists as operating in the 2024-25 school year (101,110 records, less the 1,068 it marks closed). It is built from the National Center for Education Statistics' Common Core of Data for the 2024-25 school year — the public school directory and school characteristics files, the EDGE public school administrative data layer, and the EDGE public school geocode. US federal government data, public domain. Nothing in it was bought, licensed or taken from another company's product. Measured on every row of this file: a street address on 100.0%, a phone number on 100.0%, a website on 68.8%, map coordinates on 100.0%, enrolment on 98.1% and a teacher count on 95.1%. 88 columns in all, and the page lists the fill rate for each one. Compared with the published field list of PublicSchoolReview, the one vendor in this market that prints both its fields and its price: this file carries 16 of their 17 fields. The one it does not is School Rating and Testing Rank, a rating of their own that no federal source publishes. Title I and magnet status are not in the file because the federal school files for 2024-25 do not publish them.

101,110Locations
56States
88Data Fields
October 7, 2026File built

The file has all 101,110 locations across 56 states in one download. Building the same list by searching one area at a time tends to miss places, and a missed place looks like a gap in coverage that is not really there.

Need just some of them? Ask in your own words.

●Where the rows are

Map of where the US Public Schools are
One dot for every ZIP code with at least one location. Ask above for any part of it: a state, a city, a distance.

≡Sample Data Preview

public-school-list.csvscroll →UTF-8
nameaddresscitystatezipphonewebsiteschool typeaffiliationgrade rangeenrollmentteacherscountynces idlea idstate school idlowest grade offeredhighest grade offeredschool levelschool type detailchartervirtualshared timelunch programstatusstudent teacher ratiofree reduced lunchfree lunchreduced lunchfree lunch pctreduced lunch pctdirect certificationenrollment pre Kenrollment kindergartenenrollment grade1enrollment grade2enrollment grade3enrollment grade4enrollment grade5enrollment grade6enrollment grade7enrollment grade8enrollment grade9enrollment grade10enrollment grade11enrollment grade12enrollment grade13enrollment ungradedenrollment adult edenrollment maleenrollment femalestudents american indianstudents asianstudents blackstudents hispanicstudents pacific islanderstudents two or morestudents whitestudents american indian malestudents american indian femalestudents asian malestudents asian femalestudents black malestudents black femalestudents hispanic malestudents hispanic femalestudents pacific islander malestudents pacific islander femalestudents two or more malestudents two or more femalestudents white malestudents white femalelocalecbsacbsa namecsacsa namecongressional districtstate leg district lowerstate leg district upperreference yeargeo precisioncounty fipsaddress qualitycountrylatitudelongitudesource url
Joann A. Alexie Memorial School101 Village RdAtmautluakAK99559(907) 553-5112http://atmautluak.lksd.org/publicLower Kuskokwim School DistrictPK-121217Bethel Census Area0200001002060200001AK-31-310030PK12OtherRegular SchoolNoSupplemental VirtualNoYes under Community Eligibility Option (CEO)Open17.29123123009218913696101177766673481210000007348000000000000Rural, Remote0200020380200S2024-2025source02050completeUS60.857371-162.276467https://nces.ed.gov/ccd/files.asp
Gardner-Newman Middle School101 S Shannon DrLaGrangeGA30241(706) 883-1535publicTroup County6-896363.2Troup County1300001005931300001GA-741-019168MiddleRegular SchoolNoNot VirtualNoYes under Community Eligibility Option (CEO)Open15.24949949098.503923163183295014620294431581452870019102342097682102025151136Town, Distant29300LaGrange, GA-AL122Atlanta--Athens-Clarke County--Sandy Springs, GA-AL130313136130292024-2025source13285completeUS33.068221-84.984392https://nces.ed.gov/ccd/files.asp
Maya Angelou Academy at New Beginnings formerly Oak Hill8400 River RdLaurelMD20724(202) 299-3227http://www.seeforever.org/publicDYRS7-12459Anne Arundel County1100087002131100087DC-4002-860712HighAlternative Education SchoolNoNot VirtualYes participating without using any Provision or the CEOOpen4.562500171851437400383000000034430000000Rural, Fringe12580Baltimore-Columbia-Towson, MD548Washington-Baltimore-Arlington, DC-MD-VA-WV-PA240524021240212024-2025source24003completeUS39.101153-76.787327https://nces.ed.gov/ccd/files.asp
John Stark Regional High School618 N STARK HWYWeareNH03281(603) 529-7675http://www.jsrhs.netpublicJohn Stark Regional School District9-1261253.9Hillsborough County3300003005003300003NH-275-26380912HighRegular SchoolNoNot VirtualNoYes participating without using any Provision or the CEOOpen11.3593741912.13.115718015212332328902019028563001100109001612296267Rural, Distant31700Manchester-Nashua, NH148Boston-Worcester-Providence, MA-RI-NH330233528330082024-2025source33011completeUS43.127458-71.758368https://nces.ed.gov/ccd/files.asp
Lee High990 Wisacky HighwayBishopvilleSC29010(803) 896-2531publicDept Of Correction N049-1254Lee County4500001000634500001SC-5209-021912HighAlternative Education SchoolNoSupplemental VirtualNoYes participating without using any Provision or the CEOOpen1.25021250005000000005000000000Rural, Distant450545050450292024-2025source45061completeUS34.197587-80.226312https://nces.ed.gov/ccd/files.asp
Five sample rows; the file you buy has all 88 columns.

{}What's in each row

FieldWhat it isRows filled
nameThe school's official name as published in the federal school directory.100%
schoolTypeAlways "public" — the kind of school, matching the same column on our private and charter school lists so the three stack.100%
affiliationThe school district (local education agency) the school belongs to, by name.100%
gradeRangeThe grades the school offers, lowest to highest, such as PK-5 or 9-12; PK is pre-kindergarten and KG kindergarten. Blank where the school offers no grades or did not report them.98%
enrollmentTotal students enrolled, as a count; blank where the school did not report, never a guessed zero.98%
teachersClassroom teachers as full-time equivalents, so 43.5 is possible.95%
addressThe street address of the school campus — its physical location, not a mailing address.100%
cityThe city of the campus, corrected during cleanup to the Census spelling for its postcode.100%
stateThe two-letter state or territory code.100%
zipThe five-digit postcode of the campus, kept as text so a leading zero survives.100%
countryUnited States on every row.100%
phoneThe school's main telephone number from the federal directory.100%
websiteThe school's own website as reported to the federal directory, on 68.8% of rows; blank means it reported none.69%
latitudeLatitude of the campus in decimal degrees — the federal government's own geocode of the street address.100%
longitudeLongitude of the campus in decimal degrees — the federal government's own geocode of the street address.100%
countyThe county the campus is in.100%
sourceUrlThe federal page this record comes from, so every row carries its citation.100%
ncesIdThe 12-digit federal school ID, kept as text so the leading zero survives; the key to every other federal school file.100%
leaIdThe 7-digit federal ID of the school's district — the same ID on our US School Districts list.100%
stateSchoolIdThe ID the school's own state uses for it.100%
lowestGradeOfferedThe lowest grade offered: PK, KG, 1 to 13, UG for ungraded or AE for adult education.98%
highestGradeOfferedThe highest grade offered, on the same scale.98%
schoolLevelThe federal school level — Elementary, Middle, High, Secondary, Prekindergarten, Adult Education, Ungraded, Other or Not Applicable. "High schools only" is one filter on this column.99%
schoolTypeDetailRegular, special education, career and technical, or alternative education school.100%
charterYes for a charter school, No for a regular public school, Not applicable in a state with no charter law.100%
virtualWhether instruction is virtual: Not Virtual, Supplemental Virtual, Full Virtual, or Virtual with face to face options.89%
sharedTimeYes when the school serves students who spend part of the day at another school (often career and technical centres).74%
lunchProgramWhether and how the school takes part in the National School Lunch Program, including the Community Eligibility Provision under which every student eats free.96%
statusThe school's status that year: Open, New, Inactive, Future, Added, Reopened or Changed Boundary/Agency.100%
studentTeacherRatioStudents per full-time-equivalent teacher, as published.93%
freeReducedLunchStudents eligible for free or reduced-price lunch, as a count.80%
freeLunchStudents eligible for free lunch, as a count.74%
reducedLunchStudents eligible for reduced-price lunch, as a count.74%
freeLunchPctFree-lunch eligible students as a percentage of enrolment, to one decimal; blank where either figure is missing or the count exceeds enrolment.74%
reducedLunchPctReduced-price-lunch eligible students as a percentage of enrolment, to one decimal.74%
directCertificationStudents directly certified for free meals through other assistance programmes, as a count.49%
enrollmentPreKStudents in pre-kindergarten; blank where the school does not offer it.34%
enrollmentKindergartenStudents in kindergarten; blank where the school does not offer it.53%
enrollmentGrade1Students in grade 1; blank where the school does not offer it.54%
enrollmentGrade2Students in grade 2; blank where the school does not offer it.54%
enrollmentGrade3Students in grade 3; blank where the school does not offer it.54%
enrollmentGrade4Students in grade 4; blank where the school does not offer it.53%
enrollmentGrade5Students in grade 5; blank where the school does not offer it.52%
enrollmentGrade6Students in grade 6; blank where the school does not offer it.37%
enrollmentGrade7Students in grade 7; blank where the school does not offer it.33%
enrollmentGrade8Students in grade 8; blank where the school does not offer it.33%
enrollmentGrade9Students in grade 9; blank where the school does not offer it.28%
enrollmentGrade10Students in grade 10; blank where the school does not offer it.28%
enrollmentGrade11Students in grade 11; blank where the school does not offer it.28%
enrollmentGrade12Students in grade 12; blank where the school does not offer it.28%
enrollmentUngradedStudents the school reports as ungraded.5%
enrollmentMaleStudents reported as male, as a count.98%
enrollmentFemaleStudents reported as female, as a count.98%
studentsAmericanIndianStudents reported as American Indian or Alaska Native, as a count; a real zero stays zero.98%
studentsAsianStudents reported as Asian, as a count; a real zero stays zero.98%
studentsBlackStudents reported as Black or African American, as a count; a real zero stays zero.98%
studentsHispanicStudents reported as Hispanic or Latino, as a count; a real zero stays zero.98%
studentsPacificIslanderStudents reported as Native Hawaiian or other Pacific Islander, as a count; a real zero stays zero.98%
studentsTwoOrMoreStudents reported as two or more races, as a count; a real zero stays zero.98%
studentsWhiteStudents reported as White, as a count; a real zero stays zero.98%
studentsAmericanIndianMaleMale students reported as American Indian or Alaska Native, as a count.98%
studentsAmericanIndianFemaleFemale students reported as American Indian or Alaska Native, as a count.98%
studentsAsianMaleMale students reported as Asian, as a count.98%
studentsAsianFemaleFemale students reported as Asian, as a count.98%
studentsBlackMaleMale students reported as Black or African American, as a count.98%
studentsBlackFemaleFemale students reported as Black or African American, as a count.98%
studentsHispanicMaleMale students reported as Hispanic or Latino, as a count.98%
studentsHispanicFemaleFemale students reported as Hispanic or Latino, as a count.98%
studentsPacificIslanderMaleMale students reported as Native Hawaiian or other Pacific Islander, as a count.98%
studentsPacificIslanderFemaleFemale students reported as Native Hawaiian or other Pacific Islander, as a count.98%
studentsTwoOrMoreMaleMale students reported as two or more races, as a count.98%
studentsTwoOrMoreFemaleFemale students reported as two or more races, as a count.98%
studentsWhiteMaleMale students reported as White, as a count.98%
studentsWhiteFemaleFemale students reported as White, as a count.98%
localeHow urban or rural the campus is, on the federal 12-step scale from City, Large to Rural, Remote.100%
cbsaFederal code of the metropolitan or micropolitan area the campus is in; blank where it is in none.89%
cbsaNameName of that metropolitan or micropolitan area.89%
csaFederal code of the combined statistical area the campus is in; blank where it is in none.73%
csaNameName of that combined statistical area.73%
congressionalDistrictThe congressional district: the two-digit state code followed by the two-digit district number.100%
stateLegDistrictLowerThe state legislative district, lower chamber, as the state code followed by the district number.99%
stateLegDistrictUpperThe state legislative district, upper chamber, as the state code followed by the district number.100%
referenceYearThe school year every figure describes — 2024-2025 on every row.100%
geo_precisionHow the coordinates were arrived at: source where the federal geocode was kept, address or zip centroid on the few rows whose point was re-placed during cleanup.100%
county_fipsThe five-digit federal county code, set during cleanup from the campus coordinates.100%
address_qualityHow usable the street address is: complete, no house number or po box.100%

Rows filled is measured on every row of the delivered file.

✓Where this data comes from

This dataset is built from the federal Common Core of Data for the 2024-25 school year: the NCES EDGE public school administrative layer, which carries every operating campus with its location address, enrolment by grade, sex and ethnicity, staffing, lunch eligibility and the government's own geocode, joined on the school's 12-digit federal ID to the CCD school directory file (website and state school ID), the CCD school characteristics file (shared-time, virtual and lunch programme status) and the NCES EDGE public school geocode (metro area, congressional and state legislative districts). Nothing is taken from a school's own website and nothing from a licensed third-party product. Title I and magnet status are not included: the 2024-25 federal school files do not publish them.

October 7, 2026

File built

88 fields

Columns in the file

Fill measured

On every row of the delivered file

Schools are published as the federal collection holds them. Counts the source did not report are left empty rather than set to zero, the source's placeholder codes are blanked, city spellings are corrected to the Census place name for their postcode, map points that fell outside their own state are re-placed, and every row carries the county, a coordinate-precision flag and an address-quality flag. Each build is reconciled against the live federal count and the federal directory, and a random sample is checked against the live government data before it is published. There are no personal names, job titles or email addresses.

How we build and date every file: methodology.

Using ChatGPT, Claude or an API?

No setup needed. Ask ChatGPT or Claude your question about the US Public Schools and give it this page: it can open https://locationlists.com/find?dataset=public-school-list with the filters you need and show you the count and price.

Using ChatGPT or Claude? Tell it to answer from locationlists.com/find — no account, no connector.

How assistants ask

No connector needed. Any AI assistant can answer from this site with a web link, no connector, no account: open https://locationlists.com/find with the question as query parameters.

If a question needs filtering, distance, drive time, combining lists or a price, open a /find link: either put the question itself in q=, or build the structured link. The answer does not need an API, a connector or an account.

Simplest, the question itself: https://locationlists.com/find?q=<the question in plain words>

Or set the parts yourself: https://locationlists.com/find?dataset=<slug>&state=<ST>&city=<city>&county=<county>&zip=<zip>&near=<place or zip>&radius=<miles>&drive=<minutes>&where=<column>:<op>:<value>&total=<rows>

Leave out what the question does not need. Use radius for straight-line miles or drive for minutes of driving (5 to 60), not both; near can name several places separated by | to reach from any of them. To ask about several lists at once, use datasets with two or more names, or category with a kind of business. To compare two lists, add relate=nearest and the other list with b. in front of its parameters. To count by area, use areas=county (or zip, state, metro). To keep only places whose county, ZIP code, metro area or state meets a Census figure, add area_where (for example county:population>1000000); with areas, per=100000 gives counts per 100,000 residents.

Links an assistant can open, each showing how many rows match, a few preview rows and the price for just that part:

Optional: connect for repeat use or wallet payments:

Read https://locationlists.com/skill.md and follow the instructions to connect LocationLists. Then show me the US Public Schools list.

Your assistant will walk you through setup and show you the price before you pay.

For developers

Every step below has a no-connector equivalent: https://locationlists.com/find?dataset=public-school-list with the same filters as query parameters.

  1. Connect your agent to https://locationlists.com/mcp (no key, no signup).
  2. Call count_locations with dataset: "public-school-list" and any filter — it is free, and returns how many rows match and what they cost.
  3. Fetch the rows with query_locations: $0.30 per 100 rows from this dataset. Above 50,555 rows, buying the whole file is cheaper.

Paid in USDC over x402 — the agent gets an HTTP 402 with the exact price, signs, and retries. Money moves only after rows are delivered, so a failed or empty query costs nothing. Setup for Claude, Cursor and VS Code

?Frequently Asked Questions

What is one row?

One public school campus, located at its physical street address — not its mailing address and not its district office. The map coordinates are the federal government's own geocode of that address, which is what a radius or drive-time filter needs.

Why 101,110, and not the figure I have seen elsewhere?

The federal school directory for 2024-25 holds 101,110 records. 1,068 of them are schools the directory itself marks as closed for the year; they are left out, and what remains — 101,110 — is every public school operating that year. Every row carries a status column, so the 872 new schools, the 372 that were due to open and the 501 that were temporarily inactive can be kept or dropped with one filter.

Are charter schools included?

Yes. 8,234 rows are charter schools, flagged Yes in the charter column — exactly the same schools, by federal school ID, as our US Charter Schools list, so there is no need to buy both. 3,707 schools are in states with no charter law and read "Not applicable".

How complete are the contact details?

Street address, city, state, postcode and map coordinates on every row. A phone number on 100.0%. A school website on 68.8% — the website is what the school reported to the federal directory, and a blank means it reported none.

Can I count students in particular grades?

Yes. Enrolment is broken out by grade, from pre-kindergarten to grade 13, plus ungraded and adult education, so "how many 9th to 12th graders are within 20 miles" is a sum of four columns. A blank grade means the school does not offer that grade or did not report it — never zero students.

How are the free-lunch percentages worked out?

The federal file publishes counts: students eligible for free lunch, for reduced-price lunch, and the two together. We ship the counts and divide each by the school's enrolment for the two percentage columns, to one decimal place. Where a count was not reported, or where the free-lunch count is larger than enrolment (344 schools, an inconsistency in what the state reported), the percentage is left blank rather than shown above 100. The lunch programme column says when a school serves every student free under the Community Eligibility Provision, which is why some schools show very high eligibility.

Can I cut it by metro area or congressional district?

Yes. Every school carries the federal code and name of the metropolitan or micropolitan area it sits in, the combined statistical area, its congressional district and both state legislative districts, from the government's own school geocode. A blank metro means the school is in no metro area at all — 11,128 schools are.

What was cleaned up before you sold it?

Before selling it, we unified 1,548 city names that were written more than one way inside the same postcode, corrected 78 misspelled city names, standardised the capitalisation on 39,130 more, re-placed 7 map points that fell outside their own state, and kept 99 schools that share a name and an address with another but have their own federal school ID — separate schools on one campus, which a plain duplicate check would have deleted. Every row also carries an address quality flag (complete, missing house number, or PO box) and a coordinate quality flag.

Why are some cells empty?

Because the federal source says so, and an empty cell is easier to work with than a code you have to decode. The source writes the letter N for "not applicable", M for "missing" and -1, -2 or -9 for counts that were not reported or not applicable; all of those are empty here. An empty count means not reported, never none: a real zero stays a zero. In this build we replaced 119,682 such codes across 10 text columns with empty cells, so a completeness figure means what it says.

Can I match this to the school districts?

Yes. Every row carries its federal district ID (leaId), the same ID on every row of our US School Districts list, so the two join directly with no name matching.

How often is it updated?

File built on October 7, 2026. It is not on an automatic refresh schedule, so check the build date above before you buy.

Where exactly does it come from?

All of it is United States federal government data, in the public domain: the National Center for Education Statistics' Common Core of Data for the 2024-25 school year — the public school directory and school characteristics files, the EDGE public school administrative data layer, and the EDGE public school geocode. Nothing in the file was bought, licensed or taken from another company's product. Before publishing we checked 25 randomly chosen schools against the government's live data and an independent copy of the same collection and found 0 disagreements.

Does this include the principal's or athletic director's name or email?

No. There are no personal names, job titles or email addresses anywhere in this file. The federal school collection does not publish any person at school level, and we do not guess names or invent email patterns. If you need a named contact you will need a contact database on top of this — which is why this file costs a fraction of one.

Does it include Title I or magnet school status?

No. The federal school files for 2024-25 do not publish a Title I field or a magnet field — we checked every one of the five school-level files the government releases. We left both columns out rather than fill them from another source or another year. The free and reduced-price lunch counts and the lunch programme column are the current federal measures of a school's need.

Does it include test scores, ratings or rankings?

No. Test results are published state by state, not in the federal school collection, and school ratings are other companies' own scores. Nothing in this file is a rating.

Does it include private schools?

No. This is every public school, charter schools included. Private schools are collected by a separate federal survey and sold as their own list, US Private Schools. The two never overlap, so they can be stacked without removing duplicates.

↔Other k-12 schools lists