US Colleges / Universities

US Colleges / Universities Database (910 Majors / Degree Programs)

Data Structure

city [3,201]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ title (100%)
varchar(255)
+ state_abbr (100%)
bigint(20) unsigned
+ state_id (100%)
college [9,015]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ title (100%)
varchar(255)
+ city (100%)
bigint(20) unsigned
+ city_id (100%)
varchar(255)
+ state_abbr (100%)
bigint(20) unsigned
+ state_id (100%)
varchar(255)
+ slug (100%)
varchar(255)
+ address (99.8%)
varchar(255)
+ zipcode (100%)
varchar(255)
+ phone (98.8%)
varchar(255)
+ website (61%)
varchar(255)
+ type (99.8%)
varchar(255)
+ degrees_offered (99.4%)
text
+ majors (68.7%)
text
+ classification (41.4%)
varchar(255)
+ enrollment_total (68.7%)
varchar(255)
+ enrollment_undergraduate (68.7%)
varchar(255)
+ undergraduate_male (68.7%)
varchar(255)
+ undergraduate_female (68.7%)
text
+ undergraduate_races (68.7%)
college2major [115,920]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
bigint(20) unsigned
+ college_id (100%)
bigint(20) unsigned
+ major_id (100%)
major [910]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ title (100%)
state [51]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ title (100%)
varchar(255)
+ slug (100%)
varchar(255)
+ abbr (100%)

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.

Data Profile

Size 32.31M
Tables 5
Last Commit 2016-12-07 00:35:52

Updates / Commits

Time Size Tables Columns Rows
2016-12-07 00:35:52 32.31M 5 38 129097
2016-08-25 02:15:49 32.31M 5 38 129097

Pricing

All prices are in Datactory Credits.

TableRowsPrice per Row (Credits)Subtotal (Credits)
city 3,201 .001 3.201
college 9,015 .001 9.015
college2major 115,920 .001 115.92
major 910 .001 0.91
state 51 .001 0.051
Total Credits 129.097 Credits (1) (2)
(1). Plus cost by query time at 0.1 credits per second. A typical query takes about 0.001 seconds which would then charge you 0.0001 credits.
(2). This is the total amount of credits required for ALL rows in these tables. You are free to query for only a selected part of them, even a single row, and pay only for that.

How to Access

Click to see how to access this dataset.