101,385 Unique Records for $69.00
Description of Database: Our public school database contains a great deal of information regarding all public schools in the United States. The types of schools found in this database include: Regular School, Special Education School, Vocational School, and Other/Alternative School.
[box type=”info”]Last Update: This database was last updated on November 2, 2011[/box]
List of 40 Database Fields
Unique Identifier
School Name
School District Name
Physical Address
Physical Address City
Physical Address State / Province
Physical Address Postal Code
Phone Number
Physical Address Country
Physical Address County
Physical Address Area Code
Federal Information Processing Standard
Metropolitan Statistical Area
Primary Metropolitan Statistical Area
Location Time Zone
Daylight Savings Time)
Latitude (Centroid Based)
Latitude (Precision Polygon Based)
Longitude (Centroid Based)
Longitude (Precision Polygon Based)
School District ID
Low Grade Level
High Grade Level
Location Description
Charter School Flag
Magnet School Flag
Title 1 Funds Flag
Title 1 Funds Flag (Entire School)
Student Count – Student Enrollment
Teacher Count – Faculty
Student to Teacher Ratio
Count of Male Students (Boys)
Count of Femail Students (Girls)
Count of Native American Students
Count of Asian Students
Count of African American Students
Count of Hispanic Students
Count of White Students
Free Lunch Program Count
Reduced Lunch Program Count
[box type=”download”]Download Sample Data – Contains 30 entries from the database. [/box]
Database Field Breakdown
Below is a breakdown of all the fields in the database. For example, the database has the “School Name” for 100% of the database (or 101,385 entries). The database only has a “Latitude” for 40% of the database.
| Records | Percent | Comment |
|---|---|---|
| 101,385 | 100% | Unique Identifier |
| 101,385 | 100% | School Name |
| 101,385 | 90% | School District Name |
| 101,385 | 100% | Physical Address |
| 101,385 | 100% | Physical Address City |
| 101,385 | 100% | Physical Address State / Province |
| 101,385 | 100% | Physical Address Postal Code |
| 81,410 | 80% | Zip +4 for US Physical Addresses |
| 101,385 | 100% | Physical Address Country |
| 101,385 | 100% | Physical Address County |
| 101,261 | 100% | Physical Address Area Code |
| 101,292 | 100% | Federal Information Processing Standard |
| 39,669 | 39% | Metropolitan Statistical Area |
| 31,760 | 31% | Primary Metropolitan Statistical Area |
| 101,292 | 100% | Location Time Zone |
| 101,385 | 100% | Daylight Savings Time |
| 101,292 | 100% | Latitude (Centroid Based) |
| 40,220 | 40% | Latitude (Precision Polygon Based) |
| 101,292 | 100% | Longitude (Centroid Based) |
| 40,220 | 40% | Longitude (Precision Polygon Based) |
| 101,384 | 100% | Business Phone Number |
| 101,385 | 100% | School District ID |
| 101,385 | 100% | Low Grade Level |
| 101,385 | 100% | High Grade Level |
| 101,285 | 100% | Location Description |
| 101,385 | 100% | Charter School Flag |
| 101,385 | 100% | Magnet School Flag |
| 101,385 | 100% | Title 1 Funds Flag |
| 101,385 | 100% | Title 1 Funds Flag (Entire School) |
| 98,666 | 97% | Student Count - Student Enrollment |
| 97,026 | 96% | Teacher Count - Faculty |
| 94,020 | 93% | Student to Teacher Ratio |
| 98,888 | 98% | Count of Male Students (Boys) |
| 98,888 | 98% | Count of Femail Students (Girls) |
| 98,888 | 98% | Count of Native American Students |
| 98,888 | 98% | Count of Asian Students |
| 98,888 | 98% | Count of African American Students |
| 98,888 | 98% | Count of Hispanic Students |
| 98,888 | 98% | Count of White Students |
| 93,850 | 93% | Free Lunch Program Count |
| 93,852 | 93% | Reduced Lunch Program Count |
Geographic Breakdown
512 Alaska
1,620 Alabama
1,129 Arkansas
31 American Samoa
2,266 Arizona
10,110 California
1,809 Colorado
1,150 Connecticut
229 District Of Columbia
245 Delaware
4,134 Florida
2,519 Georgia
36 Guam
290 Hawaii
1,468 Iowa
735 Idaho
4,403 Illinois
1,973 Indiana
1,428 Kansas
1,534 Kentucky
1,643 Louisiana
1,856 Massachusetts
1,458 Maryland
664 Maine
4,083 Michigan
2,273 Minnesota
2,424 Missouri
1,077 Mississippi
840 Montana
2,568 North Carolina
523 North Dakota
1,127 Nebraska
494 New Hampshire
2,603 New Jersey
854 New Mexico
620 Nevada
4,694 New York
3,875 Ohio
1,796 Oklahoma
1,306 Oregon
3,249 Pennsylvania
1,519 Puerto Rico
328 Rhode Island
1,211 South Carolina
718 South Dakota
1,758 Tennessee
9,056 Texas
1,039 Utah
2,028 Virginia
33 Virgin Islands
327 Vermont
2,321 Washington
2,275 Wisconsin
764 West Virginia
360 Wyoming
