Financial Aid and Degree offered by US Higher Education Institutions (2020 - 2024)

This dataset provides a normalized, relational structure for analyzing U.S. higher education institutions. 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). 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)`本数据集提供了用于分析美国高等教育机构的规范化关系型结构。其整合了院校概况、地理数据、教学项目分类（CIP，Classification of Instructional Programs）、年度学位授予情况、财政资助指标以及院校排名数据。此外，本数据集还旨在提供开设人工智能（Artificial Intelligence）与数据科学（Data Science）项目的院校相关详细信息。 本数据集已完成数据清洗，并规范化至第三范式（3NF，Third Normal Form），以减少数据冗余并确保参照完整性。 *数据库模式 本数据集采用关系型结构进行组织，包含以下实体与关联关系： 院校表：院校主列表。 地理位置表：共享地理数据（与院校表关联）。 教学项目表：教学项目主列表（含CIP代码）。 学位授予表：按年度与教学项目划分的学位授予事务记录。 院校排名表：年度院校排名数据。 财政资助表：年度财政指标（含助学金与贷款）。 院校状态表：院校年度运营状态数据。 *文件说明与数据字典 1. INSTITUTIONS.csv `ID`（主键）：院校的唯一IPEDS/UNITID标识符。 `Name`：院校官方名称。 `ADDR`：街道地址。 `LOCATIONID`（代理外键）：关联至`LOCATIONS`表。 2. LOCATIONS.csv `LOCATIONID`（主键）：城市/州/邮编组合的唯一标识符。 `CITY`：城市名称。 `STATE`：州名两字母缩写。 `ZIP`：邮编（以文本格式存储以保留前导零）。 3. PROGRAMS.csv `CIPCODE`（主键）：教学项目分类代码（CIP，Classification of Instructional Programs）。 `CIPTITLE`：教学项目名称。 4. AWARD_CONFERRED.csv `YEAR`、`ID`、`CIPCODE`（复合主键）。 `CTOTALT`：总授予学位数。 `CTOTALM`：授予男性的学位总数。 `CTOTALW`：授予女性的学位总数。 外键：`ID`关联至`Institutions(ID)`，`CIPCODE`关联至`Programs(CIPCODE)`。 5. FINANCIAL_AID.csv `YEAR`、`ID`（复合主键）。 `SCFY2`：全日制本科在校生总人数。 `SCFY1N`：全日制在校生人数。 `UAGRNTN`：获得助学金的本科生人数。 `UAGRNTT`：向本科生发放的助学金总额。 `UAGRNTA`：本科生平均获得的助学金金额。 `UFLOANN`：获得联邦贷款的本科生人数。 `UFLOANT`：向本科生发放的联邦贷款总额。 `UFLOANA`：本科生平均获得的联邦贷款金额。 外键：`ID`关联至`Institutions(ID)`。 6. INSTITUTION_RANKING.csv `YEAR`、`ID`（复合主键）。 `RANKING_VALUE`：年度排名（数值型，未排名则为NULL）。 外键：`ID`关联至`Institutions(ID)`。 7. INSTITUTION_STATUS.csv `YEAR`、`ID`（复合主键）。 `CYACTIVE`：年度运营状态。 外键：`ID`关联至`Institutions(ID)`。