We make the dataset of have assembled available for researchers as a csv file available for download here.
Please cite this project and any use of this data as:

Skiena’s Guide to American Colleges and Universities, www.skiena.guide, 2023.

The meaning of each variable and its original source is described in the table below.

Variable Description
Average SAT Score Average Scholastic Aptitude Test (SAT) score of undergraduate students for 2019. Data collected from College Score Card (https://collegescorecard.ed.gov/data/) .
Average ACT Score Average American College Testing (ACT) score of undergraduate students for 2019. Data collected from College Score Card (https://collegescorecard.ed.gov/data/)
Completion Rate Percentage of students who graduate within 6 years of matriculation. Data for 2019 reporting from College Score Card (https://collegescorecard.ed.gov/data/) .
Web Hits Number of visits to the primary university website observed over a 6 month period ending in August 2022. Data assembled from www.similarweb.com/.
Enrollment Number of undergraduate students enrolled in school in 2019. Data assembled from College Score Card (https://collegescorecard.ed.gov/data/) .
Applicants Number of applicants for undergraduate admission in school in 2019. Data assembled from IPEDS (https://nces.ed.gov/ipeds/use-the-data/download-access-database) .
Admission Rate Percentage of undergraduate applicants offered admission to the school in 2019. Data assembled from College Score Card (https://collegescorecard.ed.gov/data/) .
Cost of Attendance Average annual cost of attendance (including tuition and fees, books and supplies, and living expenses, minus the average grant/scholarship aid) for undergraduate students in 2019. Data assembled from College Score Card (https://collegescorecard.ed.gov/data/) .
Endowment Size of the school's endowment fund in dollars, in 2021. Data assembled from IPEDS (https://nces.ed.gov/ipeds/use-the-data/download-access-database) .
Endowment FT Endowment size divided by the number of full time equivalent students, in 2021. Data assembled from IPEDS (https://nces.ed.gov/ipeds/use-the-data/download-access-database) .
Galloway Score Measure of future college financial security, proposed by Galloway (https://www.profgalloway.com/uss-university/) calculated 2021. Data assembled from IPEDS (https://nces.ed.gov/ipeds/use-the-data/download-access-database) , Niche (https://www.niche.com/),College Score Card (https://collegescorecard.ed.gov/data/) .
Average Family Income The average parental income of attending undergraduate students in 2017. Data assembled from College Score Card (https://collegescorecard.ed.gov/data/) .
Racial Overrepresentation The Jenson-Shannon divergence between the school's racial composition (white, black, asian, hispanic) and the U.S. population at large. Data for 2019 assembled from IPEDS (https://nces.ed.gov/ipeds/use-the-data/download-access-database) .
Gender Balance The percentage of students of the minority gender, so 50% means equal number of male and female students. Data for 2019 assembled from IPEDS (https://nces.ed.gov/ipeds/use-the-data/download-access-database) .
First Generation % The percentage of undergraduate students whose parents did not attend college. Data for 2017 assembled from College Score Card (https://collegescorecard.ed.gov/data/) .
International % The percentage of undergraduate students from outside the United States. Data for 2019 assembled from IPEDS (https://nces.ed.gov/ipeds/use-the-data/download-access-database) .
Student to Faculty Ratio The number of full time equivalent undergraduate students divided by the number of full time equivalent instructional staff , represented as an integer. Data for 2019 assembled from IPEDS (https://nces.ed.gov/ipeds/use-the-data/download-access-database) .
Sports Score For NCAA Division I schools, this represents a collection of the highest conferences. Lower division schools are arranged in tiers (D2, D3, and NIAA), with ties broken by the number of sports they compete in. Data for 2022 assembled from NCAA(https://web3.ncaa.org) and NIAA (https://www.naia.org/schools/index).
Student Life Score from Niche that combines various factors that come from survey data from alumi. Data for 2019 assembled from https://www.niche.com/
Founding Date The year the university was officially founded. Data assembled from https://www.4icu.org/us/.
Instructional Wage FT The average salary for a full time instructor. Data assembled from IPEDS (https://nces.ed.gov/ipeds/use-the-data/download-access-database) .
Research Expenses Total cost of federally-funded research activities in 2019, in dollars. Data assembled from IPEDS (https://nces.ed.gov/ipeds/use-the-data/download-access-database) .
Citations per Faculty A measure of the research visibility of a school's faculty. Data collected in 2022 from https://www.webometrics.info/en.
NPV10 The average net present value (in dollars) of a college degree ten years after graduation, as a function of tuition costs and subsequent salary. Data collected in 2019 from College Score Card (https://collegescorecard.ed.gov/data/) . These were calculated to reflect the georgetown study (https://cew.georgetown.edu/cew-reports/collegeroi/)
NPV20 The average net present value (in dollars) of a college degree twenty years after graduation, as a function of tuition costs and subsequent salary. Data collected in 2019 from College Score Card (https://collegescorecard.ed.gov/data/) . These were calculated to reflect the georgetown study (https://cew.georgetown.edu/cew-reports/collegeroi/)
NPV30 The average net present value (in dollars) of a college degree thirty years after graduation, as a function of tuition costs and subsequent salary. Data collected in 2019 from College Score Card (https://collegescorecard.ed.gov/data/) . These were calculated to reflect the georgetown study (https://cew.georgetown.edu/cew-reports/collegeroi/)
NPV40 The average net present value (in dollars) of a college degree forty years after graduation, as a function of tuition costs and subsequent salary. Data collected in 2019 from College Score Card (https://collegescorecard.ed.gov/data/) . These were calculated to reflect the georgetown study (https://cew.georgetown.edu/cew-reports/collegeroi/)
Social Mobility Rate A measure that the school is admitting and successfully educating students from disadvantaged backgrounds. Specifically, the fraction of graduated students who move to the top 20 income percentile whose parents were in the bottom 20 income percentile. Data collected in 2022 from https://opportunityinsights.org/data/?geographic_level=0&topic=0&paper_id=536#resource-listing.
Social Media Followers Number of followers of the primary college account on Twitter. Data collected in February 6,2023 from wikidata.
Wiki Hits Number of searches for the main university Wikipedia page between 2015 and 2023. Data collected in 2023 from https://pageviews.wmcloud.org/?project=en.wikipedia.org&platform=all-access&agent=user&redirects=1&range=all-time&pages=
Minority % Percentage of Minorities of each school. Data for 2019 assembled from IPEDS (https://nces.ed.gov/ipeds/use-the-data/download-access-database).
Research Ranking Combined research ranking of colleges and universities in North America. Data sourced 2022 from webometrics (https://www.webometrics.info/en/North_america).
UniRank Ranking Ranking of schools from UniRank (https://www.4icu.org/us/) . Data was assembled in 2022.
Wiki Page Rank A rank of interconnectivity between wikipedia pages. Data assembled from https://danker.s3.amazonaws.com/index.html on 11/10/2022 page rank calculation.
PhDs Awarded From IPEDS - research/scholarship (new classification) - A Ph.D. or other doctor's degree that requires advanced work beyond the master’s level, including the preparation and defense of a dissertation based on original research, or the planning and execution of an original project demonstrating substantial artistic or scholarly achievement. Some examples of this type of degree may include Ed.D., D.M.A., D.B.A., D.Sc., D.A., or D.M, and others, as designated by the awarding institution. Data assembled from IPEDS (2021-2022) (https://nces.ed.gov/ipeds/use-the-data/download-access-database) .