This is a comprehensive colleges directory of 3,349 4-year colleges and universities across over 59 states in the United States. Each college record is comprised of title, description, phone number, address, size, in state tuition, out of state tuition, undergraduates, school type, varsity athletics, acceptance rate, etc. The US colleges database also contains information such as enrollment statistics with 59 records, 9,684 financial aid and 505 student race ethnicity records. The whole United States colleges and universities data set has 9 tables.
| Name | n3_chennan_college_educationcorner_com |
|---|---|
| Data | 15.69M (+ 0B) |
| Tables | 9 (+ 0) |
| Columns | 60 (+ 0) |
| Table Rows | 58,979 (+ 0) |
| Media | 0B (+ 0B) |
| Files | 0 (+ 0) |
Data Samples
Database APIs
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| college | 3,349 | title |
100%
|
| description |
99.55%
|
||
| phone |
94.33%
|
||
| address |
94.51%
|
||
| institution_type |
4.24%
|
||
| size |
94.36%
|
||
| award_levels |
4.24%
|
||
| in_state_tuition |
94.18%
|
||
| out_of_state_tuition |
94.15%
|
||
| online_degrees |
0.03%
|
||
| student_to_faculty_ratio |
90.12%
|
||
| web_address |
0.03%
|
||
| webiste |
88.35%
|
||
| status |
90.09%
|
||
| faculty |
90.12%
|
||
| school_type |
90.12%
|
||
| affiliation |
89.31%
|
||
| undergraduates |
90.12%
|
||
| setting |
90.12%
|
||
| graduate_students |
90.12%
|
||
| on_campus_housing |
90.12%
|
||
| acceptance_rate |
90.12%
|
||
| varsity_athletics |
90.12%
|
||
| college_x_enrollment_statistics | 6,184 | college_id |
100%
|
| enrollment_statistics_id |
100%
|
||
| college_x_financial_aid | 11,405 | college_id |
100%
|
| financial_aid_id |
100%
|
||
| college_x_student_race_ethnicity | 23,984 | college_id |
100%
|
| student_race_ethnicity_id |
100%
|
||
| enrollment_statistics | 379 | key |
100%
|
| value |
81%
|
||
| financial_aid | 9,684 | title |
100%
|
| percent_receiving_aid |
100%
|
||
| average_amount_received |
100%
|
||
| state | 59 | title |
100%
|
| state_x_college | 3,430 | state_id |
100%
|
| college_id |
100%
|
||
| student_race_ethnicity | 505 | value |
100%
|
Notes:
- Meta columns id and ts are not shown here, but included in columns total.
- Some statistical or memo columns are not shown here, but included in columns total.
- Non-empty percentage indicates the percent of values that are non-empty for that particular column.
Media Sets
No media sets.
