Public School Districts Database v.1.0.5
17,889 School Districts
AccountWelcome, guestSign in / Register
This database contains a great deal of information regarding all public schools districts in the United States. The structure is designed to allow easy integration with our public schools da...
Ready for your workflow
![]() |
USAGE RIGHTS USAGE LICENSE $25.00 |
PUBLICATION RIGHTS PUBLICATION LICENSE $50.00 |
MASTER RIGHTS MASTER LICENSE $100.00 |
| Data Tracking Seeds | ![]() |
![]() |
![]() |
| Data Modification | ![]() |
![]() |
![]() |
| Importing | ![]() |
![]() |
![]() |
| Exporting | ![]() |
![]() |
![]() |
| Merge | ![]() |
![]() |
![]() |
| Web Usage | ![]() |
![]() |
![]() |
| Multiple PC's or Websites | ![]() |
![]() |
![]() |
| Mobile Development | ![]() |
![]() |
![]() |
| Updates Available | ![]() |
![]() |
![]() |
| All Data File Formats | ![]() |
![]() |
![]() |
| Custom File Formats | ![]() |
![]() |
![]() |
| Distribution | ![]() |
![]() |
![]() |
| Copyright Endorsement | ![]() |
![]() |
![]() |
| BUY NOW | BUY NOW | BUY NOW |
Release structure
Review the published tables, record coverage, and field names included with release 1.0.5.
Data dictionary
| Field | Records | Percent | Type | Comment |
|---|---|---|---|---|
| id | 17,889 | 100% | int(11) | Unique Identifier |
| s_district_id | 17,889 | 100% | varchar(30) | Federal School District ID |
| s_state_id | 17,889 | 100% | varchar(30) | State School District ID |
| district_name | 17,889 | 100% | varchar(150) | School District Name |
| e_address | 17,889 | 100% | varchar(100) | Physical Address |
| e_city | 17,889 | 100% | varchar(50) | Physical Address City |
| e_state | 17,889 | 100% | varchar(20) | Physical Address State / Province |
| e_postal | 17,889 | 100% | varchar(7) | Physical Address Postal Code |
| e_zip_full | 16,487 | 92% | varchar(10) | Zip +4 for US Physical Addresses |
| e_country | 17,889 | 100% | varchar(20) | Physical Address Country |
| loc_county | 17,860 | 100% | varchar(40) | Physical Address County |
| loc_area_code | 17,860 | 100% | varchar(3) | Physical Address Area Code |
| loc_FIPS | 17,860 | 100% | varchar(5) | Federal Information Processing Standard - http://www.epa.gov/enviro/html/codes/state.html |
| loc_MSA | 5,372 | 30% | varchar(5) | Metropolitan Statistical Area - http://www.census.gov/population/www/metroareas/metrodef.html |
| loc_PMSA | 3,964 | 22% | varchar(5) | Primary Metropolitan Statistical Area - http://www.census.gov/epcd/www/g97geo2.htm |
| loc_TZ | 17,860 | 100% | varchar(6) | Location Time Zone |
| loc_DST | 17,889 | 100% | enum('Y','N','U') | Daylight Savings Time (Yes, No, Unknown) |
| loc_LAT_centroid | 17,860 | 100% | varchar(15) | Latitude (Centroid Based) |
| loc_LAT_poly | 17,754 | 99% | varchar(15) | Latitude (Precision Polygon Based) |
| loc_LONG_centroid | 17,860 | 100% | varchar(15) | Longitude (Centroid Based) |
| loc_LONG_poly | 17,754 | 99% | varchar(15) | Longitude (Precision Polygon Based) |
| cnt_students | 16,157 | 90% | bigint(20) | Number of Students in District |
| cnt_teachers | 16,236 | 91% | bigint(20) | Number of Teachers in District |
| cnt_schools | 16,734 | 94% | int(11) | Number of Schools in District |
| info_setting | 17,886 | 100% | varchar(255) | School District Setting |
| ratio_teach | 15,598 | 87% | float(9,3) | Student to Teacher Ratio |
| dist_type | 17,713 | 99% | varchar(255) | School District Type |
| biz_phone | 17,888 | 100% | varchar(20) | Business Phone Number |