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:

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)

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