Microsoft Access, MySQL, CSV, DBF, SQL Server & Custom

This Database is updated every 120 Days. Master License holders can purchse updates for this database for $18.75.
U.S. Public Schools Database Content
USAGE RIGHTS (read only)
U.S. Public Schools Database Content
U.S. Public Schools Database Content

U.S. Public Schools Database v.1.0.3

101,385 Public Schools

Download U.S. Public Schools Database U.S. Public Schools Database Download

License Database Purchase Options

Pick the right license USAGE
Data Tracking Seeds
Data Modification
Web Usage
Multiple PC's or Websites
Mobile Development
Updates Available
All Data File Formats
Custom File Formats
Copyright Endorsement

This database contains a great deal of information regarding all public schools in the United States. The types of schools found in this database include the following school types.

Regular School:
A public elementary/secondary school that does not focus primarily on vocational, special, or alternative education.

Special Education School:
Public elementary/secondary school that focuses primarily on education of one or more of the following types of students: hard of hearing, deaf, speech-impaired, health-impaired, orthopedically impaired, mentally retarded, seriously emotionally disturbed, multi-handicapped, visually handicapped, or deaf and blind, and adapts curriculum, materials or instructions for students served.

Vocational School:
Public elementary/secondary school that focuses primarily on vocational education, and provides education in one or more semi-skilled technical operations.

Other/Alternative School:
A public elementary/secondary school that addresses the needs of students which typically cannot be met in a regular school, provides nontraditional education, serves as an adjunct to a regular school, and falls outside of the categories of regular, special education, or vocational education.

101,385 Public Schools Records
Colleges Private Schools School Districts Junior Colleges Technical Schools

Table Schema Database Field Statistics

id101,385100%int(11)Unique Identifier
biz_name101,385100%varchar(150)School Name
dist_name101,385100%varchar(150)School District Name
e_address101,385100%varchar(100)Physical Address
e_city101,385100%varchar(50)Physical Address City
e_state101,385100%varchar(20)Physical Address State / Province
e_postal101,385100%varchar(7)Physical Address Postal Code
e_zip_full81,41080%varchar(10)Zip +4 for US Physical Addresses
e_country101,385100%varchar(20)Physical Address Country
school_county101,385100%varchar(40)Physical Address County
loc_area_code101,261100%varchar(3)Physical Address Area Code
loc_FIPS101,292100%varchar(5)Federal Information Processing Standard -
loc_MSA39,66939%varchar(5)Metropolitan Statistical Area -
loc_PMSA31,76031%varchar(5)Primary Metropolitan Statistical Area -
loc_TZ101,292100%varchar(6)Location Time Zone
loc_DST101,385100%enum('Y','N','U')Daylight Savings Time (Yes, No, Unknown)
loc_LAT_centroid101,292100%varchar(15)Latitude (Centroid Based)
loc_LAT_poly40,22040%varchar(15)Latitude (Precision Polygon Based)
loc_LONG_centroid101,292100%varchar(15)Longitude (Centroid Based)
loc_LONG_poly40,22040%varchar(15)Longitude (Precision Polygon Based)
biz_phone101,384100%varchar(20)Business Phone Number
s_district_id101,385100%varchar(30)School District ID
grade_low101,385100%varchar(20)Low Grade Level
grade_high101,385100%varchar(20)High Grade Level
loc_desc101,285100%varchar(50)Location Description
flag_charter101,385100%enum('Y','N','U')Charter School Flag
flag_magnet101,385100%enum('Y','N','U')Magnet School Flag
flag_title101,385100%enum('Y','N','U')Title 1 Funds Flag
flag_title_all101,385100%enum('Y','N','U')Title 1 Funds Flag (Entire School)
cnt_students98,66697%varchar(20)Student Count - Student Enrollment
cnt_teachers97,02696%varchar(20)Teacher Count - Faculty
teach_ratio94,02093%varchar(20)Student to Teacher Ratio
cnt_male98,88898%varchar(20)Count of Male Students (Boys)
cnt_female98,88898%varchar(20)Count of Femail Students (Girls)
cnt_native98,88898%varchar(20)Count of Native American Students
cnt_asian98,88898%varchar(20)Count of Asian Students
cnt_black98,88898%varchar(20)Count of African American Students
cnt_hispanic98,88898%varchar(20)Count of Hispanic Students
cnt_white98,88898%varchar(20)Count of White Students
cnt_freelunch93,85093%varchar(20)Free Lunch Program Count
cnt_reduced93,85293%varchar(20)Reduced Lunch Program Count

Public Schools Records Information

United States Public Schools

512 Alaska Public Schools
1,620 Alabama Public Schools
1,129 Arkansas Public Schools
31 American Samoa Public Schools
2,266 Arizona Public Schools
10,110 California Public Schools
1,809 Colorado Public Schools
1,150 Connecticut Public Schools
229 District Of Columbia Public Schools
245 Delaware Public Schools
4,134 Florida Public Schools
2,519 Georgia Public Schools
36 Guam Public Schools
290 Hawaii Public Schools
1,468 Iowa Public Schools
735 Idaho Public Schools
4,403 Illinois Public Schools
1,973 Indiana Public Schools
1,428 Kansas Public Schools
1,534 Kentucky Public Schools
1,643 Louisiana Public Schools
1,856 Massachusetts Public Schools
1,458 Maryland Public Schools
664 Maine Public Schools
4,083 Michigan Public Schools
2,273 Minnesota Public Schools
2,424 Missouri Public Schools
1,077 Mississippi Public Schools
840 Montana Public Schools
2,568 North Carolina Public Schools
523 North Dakota Public Schools
1,127 Nebraska Public Schools
494 New Hampshire Public Schools
2,603 New Jersey Public Schools
854 New Mexico Public Schools
620 Nevada Public Schools
4,694 New York Public Schools
3,875 Ohio Public Schools
1,796 Oklahoma Public Schools
1,306 Oregon Public Schools
3,249 Pennsylvania Public Schools
1,519 Puerto Rico Public Schools
328 Rhode Island Public Schools
1,211 South Carolina Public Schools
718 South Dakota Public Schools
1,758 Tennessee Public Schools
9,056 Texas Public Schools
1,039 Utah Public Schools
2,028 Virginia Public Schools
33 Virgin Islands Public Schools
327 Vermont Public Schools
2,321 Washington Public Schools
2,275 Wisconsin Public Schools
764 West Virginia Public Schools
360 Wyoming Public Schools
This is NOT an email marketing list
Auto Lamp Replacement Part List