Data · dataset · 2026
Financial Aid and Degree offered by US Higher Education Institutions (2020 - 2024)
Listed in Teesside University Research Data Repository
This dataset provides a normalized, relational structure for analyzing U.S. higher education institutions.
Description
It integrates institutional profiles, geographic data, instructional program classifications (CIP), yearly degree conferrals, financial aid metrics, and institutional rankings. Furthermore, it aims to provide details regarding institutions offering Artificial Intelligence, and Data Science programs.
The data has been cleaned and normalized to 3rd Normal Form (3NF) to reduce redundancy and ensure referential integrity. *Database Schema The dataset is organized into a relational structure with the following entities and relationships: Institutions: Master list of schools. Locations: Shared geographic data (linked to Institutions). Programs: Master list of instructional programs (CIP codes).
Read the rest (6 more)
Award_Conferred: Transactional records of degrees granted per year/program. Institution_Ranking: Yearly institutional rankings. Financial_Aid: Yearly financial metrics (grants and loans).
Institution_Status: Yearly activity status of institutions. *File Descriptions & Data Dictionary 1. INSTITUTIONS.csv `ID` (Primary Key): Unique IPEDS/UNITID identifier for the institution. `Name`: Official name of the institution. `ADDR`: Street address. `LOCATIONID` (Surrogate Foreign Key): Link to the `LOCATIONS` table. 2. LOCATIONS.csv `LOCATIONID` (Primary Key): Unique identifier for a city/state/zip combination. `CITY`: City name. `STATE`: Two-letter state abbreviation. `ZIP`: Zip code (preserved as text to maintain leading zeros). 3.
PROGRAMS.csv `CIPCODE` (Primary Key): Classification of Instructional Programs code. `CIPTITLE`: The name of the instructional program. 4. AWARD_CONFERRED.csv `YEAR`, `ID`, `CIPCODE` (Composite Primary Key). `CTOTALT`: Total awards conferred. `CTOTALM`: Total awards conferred to men. `CTOTALW`: Total awards conferred to women. Foreign Keys: `ID` -> `Institutions(ID)`, `CIPCODE` -> `Programs(CIPCODE)`. 5.
FINANCIAL_AID.csv `YEAR`, `ID` (Composite Primary Key). `SCFY2`: Total number of undergraduates - full-year cohort `SCFY1N`: Number of students in full-year cohort `UAGRNTN`: Number of undergrads receiving grant aid. `UAGRNTT`: Total amount of grant aid awarded to undergrads. `UAGRNTA`: Average amount of grant aid awarded to undergrads. `UFLOANN`: Number of undergrads receiving federal loans. `UFLOANT`: Total amount of federal loans awarded to undergrads. `UFLOANA`: Average amount of federal loans awarded to undergrads.
Foreign Keys: `ID` -> `Institutions(ID)` 6. INSTITUTION_RANKING.csv `YEAR`, `ID` (Composite Primary Key). `RANKING_VALUE`: Yearly ranking (Numeric or NULL for unranked). Foreign Keys: `ID` -> `Institutions(ID)` 7.
INSTITUTION_STATUS.csv `YEAR`, `ID` (Composite Primary Key). `CYACTIVE`: Yearly status. Foreign Keys: `ID` -> `Institutions(ID)`
Links
Where it is published
- DOI doi.org/10.17632/dkh6nnrjvr.1 ↗
DOI / persistent id · from researchdata tees ac uk
Catalogue records · 1
- OAI-PMH record data.mendeley.com/oai?verb=GetRecord&metadataPrefix=oai_dc&identifier=oai%3Adata… ↗
metadata API · from researchdata tees ac uk
Topics
- From keywords
- Earth & Environmental Science · Economics & Finance · Engineering · Humanities · Life Sciences · Social Science
- Inferred from text
- Education systems 71% · Tabular 65% · Text 75%
Provenance · 1 source records, 14 field assertions
| Source | Key | Last seen | Raw |
|---|---|---|---|
| Teesside University Research Data Repository | oai:data.mendeley.com/dkh6nnrjvr.1 | 9 d ago | JSON v1 |
| Field | Assertion | Extractor | Evidence |
|---|---|---|---|
| access_level | source · researchdata tees ac uk | connector:researchdata_tees_ac_uk@1.0.0 | |
| concepts[field].anzsrc:group:3903 | enrichment · researchdata tees ac uk | taxonomy-embedding@1.0.0 | title+keywords+description (71%) |
| concepts[field].local:field:earth-environmental | mapping · researchdata tees ac uk | connector:researchdata_tees_ac_uk@1.0.0 | |
| concepts[field].local:field:economics-finance | mapping · researchdata tees ac uk | connector:researchdata_tees_ac_uk@1.0.0 | |
| concepts[field].local:field:engineering | mapping · researchdata tees ac uk | connector:researchdata_tees_ac_uk@1.0.0 | |
| concepts[field].local:field:humanities | mapping · researchdata tees ac uk | connector:researchdata_tees_ac_uk@1.0.0 | |
| concepts[field].local:field:life-sciences | mapping · researchdata tees ac uk | connector:researchdata_tees_ac_uk@1.0.0 | |
| concepts[field].local:field:social-science | mapping · researchdata tees ac uk | connector:researchdata_tees_ac_uk@1.0.0 | |
| concepts[modality].local:modality:tabular | enrichment · researchdata tees ac uk | keyword-concept-rules@1.0.0 | title+description (65%) |
| concepts[modality].local:modality:text | enrichment · researchdata tees ac uk | keyword-concept-rules@1.0.0 | title+description (75%) |
| description | source · researchdata tees ac uk | connector:researchdata_tees_ac_uk@1.0.0 | /metadata/dc/description |
| license | source · researchdata tees ac uk | connector:researchdata_tees_ac_uk@1.0.0 | /metadata/dc/rights |
| publication_date | source · researchdata tees ac uk | connector:researchdata_tees_ac_uk@1.0.0 | |
| title | source · researchdata tees ac uk | connector:researchdata_tees_ac_uk@1.0.0 | /metadata/dc/title |