Lifetime updates. Come back once in a while to stay updated of new versions of this database.

9,015 US Colleges / Universities Database (910 Majors / Degree Programs)

Database Description:

In 3,201 cities / towns of United States, there are 9,015 colleges / universities / education programs that grant degrees in 910 majors (disciplines or academic areas).

Each college record consists of name, city, state, address, zip code, phone number, website URL, year terms, majors, offered degrees, research classification, enrollment total, enrollment undergraduate total, undergraduate male, undergraduate female, and undergraduate races statistics.

Database Meta:

  • Size: 14.3 MB
  • Last updated: Oct. 27th, 2011
  • Formats Included: MySQL dump .sql text file, CSV, MS Excel
  • Tables: 5

Buy Now & Download: $189.00 (USD)


phpMyAdmin Screenshots:

MySQL Database: 9,015 US Colleges / Universities Database (910 Majors / Degree Programs) for Sale

Table Details (Data Structure / Schema):

  • city
    Records:3,201

    US cities or towns with colleges.

    Data fields

    1. id: int(11)
    2. title: varchar(255)
    3. state_abbr: varchar(255)
    4. state_id: int(11)
  • college
    Records:9,015

    Colleges table containing information of all the US colleges.

    Data fields

    1. id: int(11)
    2. title: varchar(255)
    3. city: varchar(255)
    4. city_id: int(11)
    5. state_abbr: varchar(255)
    6. state_id: int(11)
    7. slug: varchar(255)
    8. address: varchar(255)
    9. zipcode: varchar(255)
    10. phone: varchar(255)
    11. website: varchar(255)
    12. type: varchar(255)
    13. degrees_offered: varchar(255)
    14. majors: text
    15. classification: text
    16. enrollment_total: varchar(255)
    17. enrollment_undergraduate: varchar(255)
    18. undergraduate_male: varchar(255)
    19. undergraduate_female: varchar(255)
    20. undergraduate_races: text
  • college2major
    Records:115,920

    Association table of colleges and majors.

    Data fields

    1. id: int(11)
    2. college_id: int(11)
    3. major_id: int(11)
  • major
    Records:910

    Majors table containing all the majors and programs these colleges offer.

    Data fields

    1. id: int(11)
    2. title: varchar(255)
  • state
    Records:51

    US states table.

    Data fields

    1. id: int(11)
    2. title: varchar(255)
    3. slug: varchar(255)
    4. abbr: varchar(255)

Buy Now & Download: $189.00 (USD)



Download link will be sent to your PayPal email. Please check spam folder in case you didn't see it in your inbox. Do contact us if you didn't receive it 10 minutes after payment. We will manually send you the download details in 24 hours. Our support staff work in the time zone of GMT+8.

Instant download upon payment success, just press return button on PayPal website after finishing payment.

Potential Applications / Usage:

  • US college directory / search site
  • College degrees or online degrees affiliate site
  • US college programs directory / search engine
  • Online education community site / information site enhancement

Other Available Formats:

Some of these formats are available on extra charge, depending on the database.

  • Plain CSV
  • CSV for Microsoft Excel
  • Microsoft Excel .XLS file (2008, 2007, 2003, 2000)
  • Microsoft Word .DOC file (2008, 2007, 2003, 2000)
  • LaTeX
  • Open Document Spreadsheet
  • Open Document Text
  • PDF
  • XML
  • YAML
  • WordPress Category / Post Database
  • Single Table Format

As we frequently enhance our databases for sale, make sure you revisit once in a while to stay updated of the databases you have purchased. Simply by clicking through the same URL we sent to you, you can download updated versions.