Dataset: US University & College Rankings

About this Dataset

US University & College Rankings

The rankings include the Integrated Postsecondary Education Data System’s ID numbers, making it possible to easily merge them with any of IPEDS’ datasets.

Since 1983, the magazine U.S. News and World Report has been ranking US universities and colleges. While I do not in anyway endorse the specific methodology used to construct these rankings, I know that many academic institutions and scholars use these rankings in their research and institutional assessment. I was in turn frustrated that historical rankings were not easily available anywhere online. The spreadsheets above contain all of the rankings from 1985-present for liberal arts colleges and from 1984-present for universities.

The data for liberal arts colleges were compiled from the actual articles releasing the data each year (any errors in entry are my own). I have included tiers for many years for the liberal arts college rankings, but most were only available online and not in print editions. The second tab lists the information that is still missing. If anyone has any of that information please contact me, I would like to fill in all of the gaps.

The data for universities is incomplete, with some years containing only the top 50 universities and others 150. They were compiled with the help of Akil Bello and Arjun Khandelwal from existing online sources. The second tab of each spreadsheet includes specific notes on the rankings for each year and sources. If anyone has any of the missing data, please contact me, I would like to fill in all of the gaps. Thanks to Melissa Whately for help with the IPEDS numbers.

Andrew G. Reiter, “U.S. News & World Report Historical Liberal Arts College and University Rankings,” available at: http://andyreiter.com/datasets/

Tables

Us News Rankings Liberal Arts Colleges Through 2023

@kaggle.joebeachcapital_university_and_college_rankings_us_news.us_news_rankings_liberal_arts_colleges_through_2023

45.72 KB
361 rows
41 columns


CREATE TABLE us_news_rankings_liberal_arts_colleges_through_2023 (
  "college_name" VARCHAR,
  "state" VARCHAR,
  "ipeds_id" BIGINT,
  "n_2023" VARCHAR,
  "n_2022" VARCHAR,
  "n_2021" VARCHAR,
  "n_2020" VARCHAR,
  "n_2019" VARCHAR,
  "n_2018" VARCHAR,
  "n_2017" VARCHAR,
  "n_2016" DOUBLE,
  "n_2015" DOUBLE,
  "n_2014" VARCHAR,
  "n_2013" VARCHAR,
  "n_2012" VARCHAR,
  "n_2011" DOUBLE,
  "n_2010" DOUBLE,
  "n_2009" DOUBLE,
  "n_2008" VARCHAR,
  "n_2007" VARCHAR,
  "n_2006" VARCHAR,
  "n_2005" VARCHAR,
  "n_2004" VARCHAR,
  "n_2003" VARCHAR,
  "n_2002" DOUBLE,
  "n_2001" VARCHAR,
  "n_2000" VARCHAR,
  "n_1999" VARCHAR,
  "n_1998" VARCHAR,
  "n_1997" VARCHAR,
  "n_1996" VARCHAR,
  "n_1995" VARCHAR,
  "n_1994" VARCHAR,
  "n_1993" VARCHAR,
  "n_1992" VARCHAR,
  "n_1991" VARCHAR,
  "n_1990" DOUBLE,
  "n_1989" DOUBLE,
  "n_1988" DOUBLE,
  "n_1986" DOUBLE,
  "n_1984" DOUBLE
);

Us News Rankings Universities Through 2023

@kaggle.joebeachcapital_university_and_college_rankings_us_news.us_news_rankings_universities_through_2023

38.64 KB
167 rows
41 columns


CREATE TABLE us_news_rankings_universities_through_2023 (
  "university_name" VARCHAR,
  "ipeds_id" BIGINT,
  "state" VARCHAR,
  "n_2023" DOUBLE,
  "n_2022" DOUBLE,
  "n_2021" DOUBLE,
  "n_2020" DOUBLE,
  "n_2019" DOUBLE,
  "n_2018" DOUBLE,
  "n_2017" DOUBLE,
  "n_2016" DOUBLE,
  "n_2015" DOUBLE,
  "n_2014" DOUBLE,
  "n_2013" DOUBLE,
  "n_2012" DOUBLE,
  "n_2011" DOUBLE,
  "n_2010" DOUBLE,
  "n_2009" DOUBLE,
  "n_2008" DOUBLE,
  "n_2007" DOUBLE,
  "n_2006" DOUBLE,
  "n_2005" DOUBLE,
  "n_2004" DOUBLE,
  "n_2003" DOUBLE,
  "n_2002" DOUBLE,
  "n_2001" DOUBLE,
  "n_2000" DOUBLE,
  "n_1999" DOUBLE,
  "n_1998" DOUBLE,
  "n_1997" DOUBLE,
  "n_1996" DOUBLE,
  "n_1995" DOUBLE,
  "n_1994" DOUBLE,
  "n_1993" DOUBLE,
  "n_1992" DOUBLE,
  "n_1991" DOUBLE,
  "n_1990" DOUBLE,
  "n_1989" DOUBLE,
  "n_1988" DOUBLE,
  "n_1986" DOUBLE,
  "n_1984" DOUBLE
);