Post-Secondary Financial Aid Demographics in Colorado

data.colorado.gov | Last Updated 26 Sep 2020

Financial Aid averages based on demographic breakdown of post-secondary students since 2004 from the Colorado Department of Higher Education (CDHE).

Tags: bic, gocodecolorado, colorado, cdhe, colorado department of higher education, demographics, post secondary, financial aid, students, fafsa

This dataset has the following 26 columns:

Column NameAPI Column NameData TypeDescriptionSample Values
yearyearnumberYear of record. Changes from source: derived by removing the FA- from Data Type field.
institutionNameinstitutionnametextThe name of the institution. Changes from source: 'Western State University' replaced 'Western State Colorado University' for older years records to maintain consistancy for queries on this university.
institutionLevelIdinstitutionlevelidnumberMachine readable coded number 2=College or 4=University. Change from source: derived from the original database field InstitutionType.
institutionLevelinstitutionleveltextHuman readable column. Changes from source: colum created and populated from the original database field InstitutionType by mapping the number value to 2=College 4=University.
institutionTypeinstitutiontypetextIndicates whether the university is public or private. Derived from the CDHE Colleges & Universities database.
taxTypetaxtypetextDescribes whether the institution is a non-profit or has another tax designation. Derived from the CDHE Colleges & Universities database.
coBasedcobasedtextDescribes whether the institution is a based in Colorado or is headquartered in a different state. Derived from the CDHE Colleges & Universities database.
divisiondivisiontextDescribes the agency aggregating the data. Derived from the CDHE Colleges & Universities database.
fafsaIndicatorfafsaindicatornumberFederal School Code Indicator; 1=Yes 0=No ; Changes from source: Changed 1 = 1 (for yes) and 2 = 0 (for no)
residencyIdresidencyidnumberNumerical value associated to Residency. Derived from residency description.
residencyresidencytextValues are: In-State, Out-Of-State, Other
ageDescagedesctextThe age range of sample.
ageMinageminnumberMinimum age from the age description. Changes from source: derived by splitting the ageDesc field and taking the lower end of the value as the min value.  'Under' is set to null values as an unbounded range, treated as an empty value.
ageMaxagemaxnumberMaximum age from the age description. Changes from source: derived by splitting the ageDesc field and taking the higher end of the value as the max value.  'Over' is set to null values as an unbounded range, and treated as an empty value.
gendergendertextGender of student. Values are: Male, Female, Unknown
ethnicityethnicitytextEthnicity of student. Values are: Asian or Pacific Islander; Black, non-Hispanic; Hispanic; Native American or Alaskan Native; Non-Resident Alien; Unknown Ethnicity; White, non-Hispanic
studentLevelstudentleveltextStudent level as either Undergraduate or Graduate.
enrollmentClassificationenrollmentclassificationtextValues are: Full-time, Less-than-half-time, Half-time. Changes from source: Changed 'Full-Time' to 'Full-time' to be consistent
sumStateAidsumstateaidnumberSum of all state aid for the record's cohort. Changes from source: Removed commas and saved values as integers
sumFederalPellsumfederalpellnumberSum of all Federal Pell Grant aid for the record's cohort. Changes from source: Removed commas and saved values as integers
sumFederalLoanssumfederalloansnumberSum of all federal aid for the record's cohort. Changes from source: Removed commas and saved values as integers
sumOtherFederalsumotherfederalnumberSum of all non-Federal Pell Grant aid for the record's cohort. Changes from source: Removed commas and saved values as integers
sumFederalPLUSsumfederalplusnumberSum of all Federal PLUS aid for the record's cohort. Changes from source: Removed commas and saved values as integers
sumOtherLoanssumotherloansnumberSum of all loan aid for the record's cohort.Changes from source: Removed commas and saved values as integers
sumOtherScholarshipssumotherscholarshipsnumberSum of all scholarship aid for the record's cohort.Changes from source: Removed commas and saved values as integers
recordCountrecordcountnumberRecord Count. Changes from source: Replaced all * values to null values so that the field type can be treated as an integer field for numerical queries.