Financial Aid averages based on demographic breakdown of post-secondary students since 2004 from the Colorado Department of Higher Education (CDHE).
This dataset has the following 26 columns:
| Column Name | API Column Name | Data Type | Description | Sample Values |
|---|---|---|---|---|
| year | year | number | Year of record. Changes from source: derived by removing the FA- from Data Type field. | 2021 2020 2018 2014 2016 view top 100 |
| institutionName | institutionname | text | The 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. | Colorado State University University of Colorado Denver University of Colorado Boulder University of Northern Colorado University of Colorado Colorado Springs view top 100 |
| institutionLevelId | institutionlevelid | number | Machine readable coded number 2=College or 4=University. Change from source: derived from the original database field InstitutionType. | 4 2 view top 100 |
| institutionLevel | institutionlevel | text | Human 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. | University College view top 100 |
| institutionType | institutiontype | text | Indicates whether the university is public or private. Derived from the CDHE Colleges & Universities database. | Public view top 100 |
| taxType | taxtype | text | Describes whether the institution is a non-profit or has another tax designation. Derived from the CDHE Colleges & Universities database. | Not-for-Profit view top 100 |
| coBased | cobased | text | Describes whether the institution is a based in Colorado or is headquartered in a different state. Derived from the CDHE Colleges & Universities database. | Yes view top 100 |
| division | division | text | Describes the agency aggregating the data. Derived from the CDHE Colleges & Universities database. | DHE view top 100 |
| fafsaComplete | fafsaindicator | number | 1=Yes 0=No ; | 1 0 view top 100 |
| residencyId | residencyid | number | Numerical value associated to Residency. Derived from residency description. | 1 2 4 3 view top 100 |
| residency | residency | text | Values are: In-State, Out-Of-State, Other | In-State Out-Of-State Unclassified Other view top 100 |
| ageDesc | agedesc | text | The age range of sample. | 25-40 21-24 17-20 Over 40 Under 17 view top 100 |
| ageMin | agemin | number | Minimum 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. | 25 21 17 40 view top 100 |
| ageMax | agemax | number | Maximum 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. | 40 24 20 17 view top 100 |
| gender | gender | text | Gender of student. Values are: Male, Female, Unknown | Female Male Unknown No Gender Data view top 100 |
| ethnicity | ethnicity | text | Ethnicity 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 | White, non-Hispanic Unknown Hispanic Asian or Pacific Islander White view top 100 |
| studentLevel | studentlevel | text | Student level as either Undergraduate or Graduate. | Undergraduate Graduate view top 100 |
| enrollmentClassification | enrollmentclassification | text | Values are: Full-time, Less-than-half-time, Half-time. Changes from source: Changed 'Full-Time' to 'Full-time' to be consistent | Full-time Half-time Less-than-half-time view top 100 |
| sumStateAid | sumstateaid | number | Sum of all state aid for the record's cohort. Changes from source: Removed commas and saved values as integers | 0 1000 1500 2000 3000 view top 100 |
| sumFederalPell | sumfederalpell | number | Sum of all Federal Pell Grant aid for the record's cohort. Changes from source: Removed commas and saved values as integers | 0 4050 2025 1013 5550 view top 100 |
| sumFederalLoans | sumfederalloans | number | Sum of all federal aid for the record's cohort. Changes from source: Removed commas and saved values as integers | 0 3500 5500 20500 9500 view top 100 |
| sumOtherFederal | sumotherfederal | number | Sum of all non-Federal Pell Grant aid for the record's cohort. Changes from source: Removed commas and saved values as integers | 0 1000 500 2000 1500 view top 100 |
| sumFederalPLUS | sumfederalplus | number | Sum of all Federal PLUS aid for the record's cohort. Changes from source: Removed commas and saved values as integers | 0 5000 10000 4000 6000 view top 100 |
| sumOtherLoans | sumotherloans | number | Sum of all loan aid for the record's cohort.Changes from source: Removed commas and saved values as integers | 0 5000 10000 6000 3000 view top 100 |
| sumOtherScholarships | sumotherscholarships | number | Sum of all scholarship aid for the record's cohort.Changes from source: Removed commas and saved values as integers | 0 1000 500 1500 2000 view top 100 |
| recordCount | recordcount | number | Record 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. | 1 2 3 4 5 view top 100 |