U.S. Public Schools Database

Explore public schools and their education agencies Work with 100,168 operational school records from the 2025-26 preliminary directory, linked to 18,374 education agencies. Coverage spans a...

Ready for your workflow

Flexible data delivery

Delivered files
UTF-8 CSV, JSON, SQLite, schemas, samples, statistics, documentation, and tier-specific ZIP bundles.
Updates
Current release 2.0.1 dated September 5, 2026. Update eligibility follows the selected license.
Preview sample data
Choose your licensePurchase once. Download immediately.
Secure checkout
School DirectorySchool Directory with 3 connected tables in matching CSV, JSON and SQLite, with documented reference years and value availability.
$75.00
Complete School ResearchComplete School Research with 8 connected tables in matching CSV, JSON and SQLite, with documented reference years and value availability.
$300.00
U.S. Public Schools Database List

U.S. Public Schools Database v.2.0.1

100,168 Public schools

U.S. Public Schools Database catalog icon U.S. Public Schools Database Download

License Database Purchase Options

Pick the right license SCHOOL DIRECTORY
USAGE LICENSE
$75.00
 SCHOOL OPERATIONS
PUBLICATION LICENSE
$150.00
 COMPLETE SCHOOL RESEARCH
MASTER LICENSE
$300.00
Data Modification
Importing
Exporting
Merge
Web Usage
Multiple PC's or Websites
Mobile Development
Updates Available
Included file formats CSV, JSON, SQLite CSV, JSON, SQLite CSV, JSON, SQLite
Custom File Formats
Distribution
Copyright Endorsement
  BUY NOW BUY NOW BUY NOW

Explore public schools and their education agencies

Work with 100,168 operational school records from the 2025-26 preliminary directory, linked to 18,374 education agencies. Coverage spans all 50 states, Washington, DC, five U.S. territories and federally reported schools.

Choose the tables your project needs

School Directory includes schools, education agencies and available address-matched geographic detail. School Operations adds dated enrollment totals, teacher full-time equivalents and school-program information. Complete School Research adds grade and demographic breakdowns plus clearly dated historical program facts for matched schools.

Use connected, documented data

Each tier provides matching CSV, JSON and SQLite files with stable identifiers, schemas, field definitions, samples and coverage statistics. Postal codes retain leading zeros. Related rows describe the included schools and do not inflate the school count.

Keep the reference years in view

The directory describes 2025-26. Enrollment, staffing, program and geographic detail describe 2024-25 and may be unavailable for newer schools. Historical program facts are dated 2011 and are not verified current. Directory status and contact details are reported snapshots, not live checks.

Missing and suppressed values stay blank. Teacher values measure full-time equivalents, not headcounts. Statistical coverage varies by state and field, and preschool coverage is incomplete in some states. Meal-program counts overlap and are not poverty estimates.

Preview each table

Compare table samples, field coverage and tier contents before choosing the package for your directory, mapping or research project.

100,168 Public schools Records
SAMPLE DATA TABLE STRUCTURE RECORD INFO
Colleges Private Schools School Districts Junior Colleges Technical Schools

Table Schema Database Field Statistics

Release structure

U.S. Public Schools Database

Review the published tables, record coverage, and field names included with release 2.0.1.

Database
#39
Version
2.0.1
Format
XML schema

Data dictionary

Tables and fields

Release-defined structure
TableRecordsFields
agencies18374agency_id, name, address, city, state_code, postal_code, postal_extension, mailing_address, mailing_city, mailing_state, mailing_postal_code, mailing_postal_extension, phone, website, school_year, operational_status, start_year_status, status_effective_date, lowest_grade, highest_grade, level, grades_offered, agency_type, charter_agency_status
schools100168school_id, agency_id, name, address, city, state_code, postal_code, postal_extension, mailing_address, mailing_city, mailing_state, mailing_postal_code, mailing_postal_extension, phone, website, school_year, operational_status, start_year_status, status_effective_date, lowest_grade, highest_grade, level, grades_offered, school_type, charter_status, reporting_jurisdiction, geographic_scope
school_geography96472school_id, geography_school_year, latitude, longitude, county_code, county_name, locale_code, metro_area_code, metro_area_name, metro_area_type, combined_area_code, combined_area_name, congressional_district, state_lower_district, state_upper_district
school_metrics100168school_id, school_year, enrollment_total, enrollment_total_status, nonadult_enrollment, nonadult_enrollment_status, teacher_fte, teacher_fte_status, nonadult_students_per_teacher_fte
school_programs100168school_id, school_year, characteristics_record_status, shared_time_status, virtual_instruction_status, meal_program_status, free_reduced_eligible, free_reduced_eligible_status, free_eligible, free_eligible_status, reduced_eligible, reduced_eligible_status, direct_certified, direct_certified_status
enrollment_by_grade671813school_id, school_year, grade, student_count, value_status
enrollment_demographics1473375school_id, school_year, race_ethnicity, sex, nonadult_student_count, value_status
historical_school_facts120585school_id, field, historical_value, historical_release_date, value_status

Release at a glance

What is inside this database

Review verified record totals, geographic coverage, classifications, and field completeness for U.S. Public Schools Database.

18,374Agencies
100,168Schools
96,472School Geography
100,168School Metrics
100,168School Programs
671,813Enrollment By Grade
1,473,375Enrollment Demographics
120,585Historical School Facts

Table and column statistics

Select a table to review its own schema, record total, fields, distinct values, and missing-value coverage.

agencies18,374 records · 24 fields
agency_id
Distinct
18,374
Missing
0 (0.0%)
name
Distinct
18,050
Missing
0 (0.0%)
address
Distinct
17,767
Missing
0 (0.0%)
city
Distinct
9,291
Missing
0 (0.0%)
state_code
Distinct
56
Missing
0 (0.0%)
postal_code
Distinct
13,130
Missing
0 (0.0%)
postal_extension
Distinct
5,024
Missing
7,296 (39.7%)
mailing_address
Distinct
16,243
Missing
0 (0.0%)
mailing_city
Distinct
9,293
Missing
0 (0.0%)
mailing_state
Distinct
56
Missing
0 (0.0%)
mailing_postal_code
Distinct
13,247
Missing
0 (0.0%)
mailing_postal_extension
Distinct
4,979
Missing
6,788 (36.9%)
phone
Distinct
17,711
Missing
0 (0.0%)
website
Distinct
15,892
Missing
1,856 (10.1%)
school_year
Distinct
1
Missing
0 (0.0%)
operational_status
Distinct
5
Missing
0 (0.0%)
start_year_status
Distinct
6
Missing
0 (0.0%)
status_effective_date
Distinct
203
Missing
0 (0.0%)
lowest_grade
Distinct
16
Missing
105 (0.6%)
highest_grade
Distinct
17
Missing
105 (0.6%)
level
Distinct
8
Missing
105 (0.6%)
grades_offered
Distinct
172
Missing
105 (0.6%)
agency_type
Distinct
8
Missing
0 (0.0%)
charter_agency_status
Distinct
6
Missing
0 (0.0%)

Inspect the data

Representative sample data

Switch tables to review representative fields and rows from every table advertised for this release.

agenciesDownload this sample CSV
agency_idnameaddresscitystate_codepostal_codepostal_extensionmailing_addressmailing_citymailing_statemailing_postal_codemailing_postal_extensionphonewebsiteschool_yearoperational_statusstart_year_statusstatus_effective_datelowest_gradehighest_gradelevelgrades_offeredagency_typecharter_agency_status
LEA-bc4f824e83340f36c01dAlbertville City8379 US Highway 431AlbertvilleAL3595000258379 US Highway 431AlbertvilleAL359500025(256)891-1183http://www.albertk12.org2025-2026openopen2025-10-01PK12OtherPK; KG; 1; 2; 3; 4; 5; 6; 7; 8; 9; 10; 11; 12Regular public school district that is not a component of a supervisory unionNot a charter district
LEA-a36e8dd59a77024bf2bcCOUNTY LINE SCHOOL DISTRICT12092 W STATE HIGHWAY 22BRANCHAR7292812092 W HWY 22BRANCHAR72928(479)635-2222http://indians.wsc.k12.ar.us2025-2026openopen2025-10-01PK12OtherPK; KG; 1; 2; 3; 4; 5; 6; 7; 8; 9; 10; 11; 12Regular public school district that is not a component of a supervisory unionNot a charter district
LEA-ede0c3d532507d460716Hayward Twin Oaks Montessori District951 Palisade St.HaywardCA945421048951 Palisade St.HaywardCA945421048(510)370-3334http://www.haywardtwinoaks.org2025-2026openopen2025-10-010112Other1; 2; 3; 4; 5; 6; 7; 8; 9; 10; 11; 12Independent charter districtLEA for federal programs
LEA-bdc613a7c4b8f7095064Santa Cruz City High133 Mission Street Ste. 100Santa CruzCA950603747133 Mission Street Ste. 100Santa CruzCA950603747(831)429-3410http://www.sccs.net2025-2026openopen2020-07-07KG12OtherKG; 1; 2; 3; 4; 5; 6; 7; 8; 9; 10; 11; 12Regular public school district that is a component of a supervisory unionNot a charter district
LEA-84bb668db05c05a7fdd9Lanier County247 Hwy 221 SouthLakelandGA31635PO Box 158LakelandGA31635(912)482-39662025-2026openopen2025-10-01PK12OtherPK; KG; 1; 2; 3; 4; 5; 6; 7; 8; 9; 10; 11; 12Regular public school district that is not a component of a supervisory unionNot a charter district
LEA-d1a66e420eefac6316b6Olympia CUSD 16903 E 800 North RdStanfordIL617749612903 E 800 North RdStanfordIL617749612(309)379-6011http://www.olympia.org2025-2026openopen2025-10-01PK12OtherPK; KG; 1; 2; 3; 4; 5; 6; 7; 8; 9; 10; 11; 12Regular public school district that is not a component of a supervisory unionNot a charter district
LEA-45fe166855a8506d5c13Sergeant Bluff-Luton Comm School District201 Port Neal RoadSergeant BluffIA51054201 Port Neal RdSergeant BluffIA51054(712)943-4338http://www.sblschools.com2025-2026openopen2025-10-01PK12OtherPK; KG; 1; 2; 3; 4; 5; 6; 7; 8; 9; 10; 11; 12Regular public school district that is not a component of a supervisory unionNot a charter district
LEA-6a3d9a5608cd19ad3f86Worcester County Public Schools6270 Worcester HighwayNewarkMD218416270 Worcester HighwayNewarkMD21841(410)632-5000http://www.worcesterk12.org2025-2026openopen2025-10-01PK12OtherPK; KG; 1; 2; 3; 4; 5; 6; 7; 8; 9; 10; 11; 12Regular public school district that is not a component of a supervisory unionNot applicable
LEA-a65b90687f13c26a80a4Lakeview Public Schools (Macomb)27575 HARPER AVESAINT CLAIR SHORESMI48081192327575 Harper AveSAINT CLAIR SHORESMI480812181(586)445-4000http://www.lakeviewpublicschools.org/2025-2026openopen2025-10-01PK12OtherPK; KG; 1; 2; 3; 4; 5; 6; 7; 8; 9; 10; 11; 12Regular public school district that is not a component of a supervisory unionNot a charter district
LEA-36192046dd24c5c06244Poplarville School District302 South Julia StreetPoplarvilleMS39470302 South Julia StreetPoplarvilleMS39470(601)795-8477http://www.poplarvilleschools.org2025-2026openopen2025-10-01PK13OtherPK; KG; 1; 2; 3; 4; 5; 6; 7; 8; 9; 10; 11; 12; 13; AERegular public school district that is not a component of a supervisory unionNot a charter district
LEA-06cd2c86420397baceb9Victor K-12 Schools425 4th AvenueVictorMT59875425 4th AvenueVictorMT59875(406)642-3221http://victor.k12.mt.us2025-2026openopen2025-10-01PK12OtherPK; KG; 1; 2; 3; 4; 5; 6; 7; 8; 9; 10; 11; 12Regular public school district that is not a component of a supervisory unionNot applicable
LEA-5eadb383a0e13b7fac06North Hanover Township School District331 Monmouth RoadWrightstownNJ085622127331 Monmouth RoadWrightstownNJ085622127(609)738-2600http://www.nhanover.com2025-2026openopen2025-10-01PK06ElementaryPK; KG; 1; 2; 3; 4; 5; 6Regular public school district that is not a component of a supervisory unionNot a charter district
LEA-76561ce0d20fec0e85bbFRONTIER CENTRAL SCHOOL DISTRICTS 5120 ORCHARD AVEHAMBURGNY140755657S 5120 ORCHARD AVEHAMBURGNY140755657(716)926-1711http://www.frontier.wnyric.org2025-2026openopen2025-10-01PK12OtherPK; KG; 1; 2; 3; 4; 5; 6; 7; 8; 9; 10; 11; 12; UGRegular public school district that is not a component of a supervisory unionNot a charter district
LEA-e2431c6e8bc968cb4d19MADDOCK 9909 1st StMaddockND58348PO Box 398MaddockND583480398(701)438-2531http://www.maddock.k12.nd.us/2025-2026openopen2025-10-01PK12OtherPK; KG; 1; 2; 3; 4; 5; 6; 7; 8; 9; 10; 11; 12Regular public school district that is not a component of a supervisory unionNot applicable
LEA-12b082a82ac74c11a316Vanguard-Sentinel Career & Technology Centers1306 Cedar StFremontOH4342011271306 Cedar StFremontOH434201127(419)332-2626http://vscc.k12.oh.us2025-2026openopen2025-10-010612HighPK; 6; 7; 8; 9; 10; 11; 12Service agencyNot a charter district
LEA-6ba9db51fe465d1e80fcAntonia Pantoja Community CS4101 North American StreetPhiladelphiaPA191404101 North American StreetPhiladelphiaPA19140(215)455-13002025-2026openopen2008-09-05KG08ElementaryKG; 1; 2; 3; 4; 5; 6; 7; 8Independent charter districtLEA for federal programs
LEA-cb33bda9fce025e2f9bdBartlett City Schools5705 Stage RoadBartlettTN381345705 Stage RoadBartlettTN38134(901)202-0855http://www.bartlettschools.org/2025-2026openopen2025-10-01PK12OtherPK; KG; 1; 2; 3; 4; 5; 6; 7; 8; 9; 10; 11; 12Regular public school district that is not a component of a supervisory unionNot a charter district
LEA-1bc2b684477503cb7a50NEEDVILLE ISD16319 HWY 36NEEDVILLETX774610412P O BOX 412NEEDVILLETX774610412(979)793-4308http://www.needvilleisd.com2025-2026openopen2025-10-01PK12OtherPK; KG; 1; 2; 3; 4; 5; 6; 7; 8; 9; 10; 11; 12Regular public school district that is not a component of a supervisory unionNot a charter district
LEA-c32955689bdc3d42a3abGranite Falls School District205 N Alder AvenueGranite FallsWA98252205 N Alder AvenueGranite FallsWA982528908(360)691-7717http://www.gfalls.wednet.edu2025-2026openopen2025-10-01PK12OtherPK; KG; 1; 2; 3; 4; 5; 6; 7; 8; 9; 10; 11; 12Regular public school district that is not a component of a supervisory unionNot a charter district
LEA-0d34ef67d24eee72eeeaSaint Thomas - Saint John School District386 Annas RetreatSaint ThomasVI00802386 Annas RetreatSaint ThomasVI00802(340)775-2250http://www.vide.vi2025-2026openopen2025-10-01PK12OtherPK; KG; 1; 2; 3; 4; 5; 6; 7; 8; 9; 10; 11; 12Regular public school district that is not a component of a supervisory unionNot applicable

Public schools Records Information

18,374 agencies; 100,168 schools; 96,472 school geography; 100,168 school metrics; 100,168 school programs; 671,813 enrollment by grade; 1,473,375 enrollment demographics; 120,585 historical school facts. Schools are the primary count; related rows are not additional schools.

Designed for business research, directory applications, mapping, and market analysis. Review permitted uses.

Build a broader dataset

Extend this dataset around your project

Combine this database with compatible business, location, or specialty records. Oddity can also scope a custom package by geography, fields, format, and intended use.

Related datasetsField selectionCustom geography
Explore compatible data Discuss a custom package

Oddity Data Updates

Know when fresh data arrives.

Receive occasional notices about new and substantially updated database releases. No third-party mailing list.

Oddity Software

Details