IPEDS 2020 added to our data set


The latest Colleges data will be updated to IPEDS every year. CollegeHippo keeps a track of this data updating and imports the data into our database.

The latest data which is currently available in the IPEDS is 2020.

Till now CollegeHippo was maintaining 2019 data and as of now there is 2020 data available on IPEDS, we have downloaded and imported the latest 2020 data into our database.

CollegeHippo imports only the graduate student’s data from IPEDS like graduate students enrollments count, count of graduate students who got their graduation, graduate student’s in-state and out-state tuition, and many more. A total of 13 tables of data has been imported into our database.

We have now replaced the existing tables data with new IPEDS 2020 data, without changing the table names.

So, what are the tables that we have imported, and for what reasons we have imported these tables?

IPEDS Table NameCollegeHippo Table NameTable Description
C2020_Acompletion_data The table contains the details on the count of students awarded with a graduate degree. We can extract the data for a particular university and program from this table.
C2020_Bcompletion_data2 The table contains the details on the number of students receiving awards/degrees, categorized by race/ethnicity and gender. We can extract the data for a particular university and program from this table.
C2020_Ccompletion_data3 The table contains the details on the number of students receiving awards/degrees, categorized by award level and by gender, race/ethnicity, and age categories. We can extract the data for a particular university and program from this table.
C2020DEPcompletion_data_distanceThis table gives the count of online programs offered by a university and the count of students who completed their graduation through distance education.
EF2020CPenrollments_majorsThis table gives the count of students who got enrolled in the top 5 programs in a university. We can get the count of male and female students enrolled and also international male and females students enrolled.
EFFY2020enrollmentsThis table gives the overall count of students enrolled for a 12-month graduate program in a university. We can get the count of male and female students enrolled and also international male and females students enrolled.
EFIA2020enrollments2This table shows data on instructional activity given by institutions in total credit and/or contact hours over a 12-month period. For both undergraduate and graduate levels, credit hour and contact hour activity data are used to calculate 12-month full-time equivalent (FTE) enrollments.
EF2020A_DISTst_ip_distance_enrollmentThis table contains the details of the graduate students enrolled in distance education. We can get the count of students enrolled exclusively in distance education courses, students enrolled in some but not all distance education courses, and students not enrolled in any distance education courses.
HD2020directory_informationThis table contains directory information of every university, which includes name, address, city, state, zip code, and various URL links to the institution’s home page, admissions, financial aid offices, and the net price calculator. 
IC2020 + ADM2020institute_characteristic1 This table contains information on the institution’s curriculum and award offerings, as well as its control and affiliation. It also includes details about specific educational possibilities, student services, disability services, tuition options, and athletic conference associations.
IC2020_AYinstitute_characteristics_fees This table contains data on student fees for the entire academic year. The average tuition and compulsory fees for both full-time undergraduate and graduate students are included in this data collection, as are per credit hour charges for both part-time undergraduate and graduate students.
SFA1920financial_aid This table gives the count on the number of full-time, first-time degree/certificate-seeking undergraduate students at each institution, as well as all undergraduate students who receive various types of student financial help, such as grants and loans, from various sources.
S2020_OCst_ip_assistatship This table gives the count of total graduate assistantships, teaching assistantships, and research assistantships awarded to students by a university.

How does CollegeHippo extract data from the tables?

We extract the data for the imported table using simple SQL queries. Here is an example of how we extract the required data from the tables. We have listed below the universities that have top 5 grad students enrollments for a program as per new IPEDS 2020 data.

UnitIdCip-familyTotal Enrollment
10065452617
10065426557
10065414405
10065413190
1006544044
100663522347
100663261547
10066313927
10066314507
10066340231

Is there a change in data from IPEDS 2019 to IPEDS 2020?

Yes, the data has all been changed for completion, enrollments, tuition, and financial aid in IPEDS 2020 data than in IPEDS 2019 data.

Here, we have compared the tuition amount of IPEDS 2019 with IPEDS 2020 for some universities.

University NameIPEDS 2019IPEDS 2020
Boston College $30,600 $31,824
The University of Texas at Austin $11,998 $12,028
Northeastern University $24,793 $25,264
Tufts University$52,724 $54,196
Clark University $46,848 $47,650

At last, a question that may raise is IPEDS data is all correct?

To answer your question, check our blog post Is CollegeHippo data better than IPEDS for the Graduate programs?.

Similar Questions


What are the Best Courses Available in Data Analytics?


About Saisha

After completing her undergraduate, Saisha wanted to pursue a career in data analytics. She helps the team with data analysis ad research on the data. An avid chess player and news junkie, she consumes news like no one else on current affairs.

Leave a Reply