Usage & Publication License: database price dollar sign169.00

Directory of 121,845 Schools in US

Addresses, Phone Numbers and Grades of 121,845 Schools in the United States

database structure screenshot of Directory of 121,845 Schools in US

Description: This schools directory database contains 121,845 schools located in 14,180 cities from 51 states in the United States. In table school, each record is comprised of school address, phone number, school grades, state, city and the nature of school (charter, private and public).

Related DBs:

Database Statistics

  • Size: 24.50 MB
  • Tables: 3
  • Records: 121,845
  • Formats: MySQL, CSV, MS Excel, MS Access, XML (See Downloads for sure.)

Database Categories

Database Structure

Table Records Fields
school 121,845
  1. id
  2. state_slug
  3. city_id
  4. title
  5. address
  6. phone
  7. grades
  8. nature
city 14,180
  1. id
  2. state
  3. title
  4. slug
state 51
  1. id
  2. title
  3. education
  4. address
  5. postcode_state
  6. phone
  7. count
  8. slug

Content Scope

Below are the categories / subjects / topics this database contains record entries about and the number of entries under each of them:

state

  • Alabama
  • Alaska
  • Arizona
  • Arkansas
  • California
  • Colorado
  • Connecticut
  • Delaware
  • District of Columbia
  • Florida
  • Georgia
  • Hawaii
  • Idaho
  • Illinois
  • Indiana
  • Iowa
  • Kansas
  • Kentucky
  • Louisiana
  • Maine
  • Maryland
  • Massachusetts
  • Michigan
  • Minnesota
  • Mississippi
  • Missouri
  • Montana
  • Nebraska
  • Nevada
  • New Hampshire
  • New Jersey
  • New Mexico
  • New York
  • North Carolina
  • North Dakota
  • Ohio
  • Oklahoma
  • Oregon
  • Pennsylvania
  • Rhode Island
  • South Carolina
  • South Dakota
  • Tennessee
  • Texas
  • Utah
  • Vermont
  • Virginia
  • Washington
  • West Virginia
  • Wisconsin
  • Wyoming

Miscellaneous

Defects:

  • In table school, there are 120,484 records that have an address field and 121,140 records that have a phone field.
  • In table state, there are 50 records that have a populated education field, 50 records that have a populated address field, 50 records that have a populated postcode_state field and 50 records that have a populated phone field.

Lifetime Updates (fees may apply)

This database is being constantly updated with regards to both data volume and data structure, once every 0.5 - 5 years depending on niche, and you will be notified via our Blog or Twitter when new versions come out.

Other Formats upon Request

We include the most common, popular and usable formats readily accessible on the download page, but should you need the database in other formats such as:

  • Microsoft SQL Server
  • Microsoft SQL Server Compact Edition
  • Oracle
  • PostgreSQL
  • ODBC
  • Interbase / Firebird
  • WordPress
  • Single Table (multiple tables are combined into one)
  • Microsoft Word .DOC
  • PDF

Let us know and we'll see what we can do. Additional fees may apply.


Share This Page:

Follow us at @UsableDatabases to be notified of database (data sets, lists) releases and updates.

We blog as well. Stay tuned by your preferred means so we can keep you posted on what we are working on!

Contact Us

Need assistance? We can't wait to help you find the perfect database or provide for your custom data needs! Use Custom Data Project form for serious project inquiries. Email: info@UsableDatabases.com

  1. We will get back to you at this email.

  2. What is your inquiry?

  3. Which cannot float on water, boat or stone?

    Please answer the question by common sense.

Back to Top

Subscribe to our Data Press feed to be notified when we release new databases!


Be notified when new data sets are released!
You would also receive running promo discounts and updates to current databases.

Worry Free: We use FeedBurner. You may receive periodic emails / posts from us but you can very easily unsubscribe anytime.