This is a vast collection of over 4,000 the United States colleges with 23 tables in multi-fields. The colleges data has a total of 4,210 records from 50 states in America. Each record is comprised of title, address, phone number, email, full time percentage, part time percentage, female percentage, male percentage, etc. The US colleges and universities database not only contains the colleges list but also comes with admission, campus life, majors and degrees, and even more related information.
| Name | n3_chennan_college_petersons_com |
|---|---|
| Data | 32.27M (+ 0B) |
| Tables | 23 (+ 0) |
| Columns | 97 (+ 0) |
| Table Rows | 181,001 (+ 0) |
| Media | 0B (+ 0B) |
| Files | 0 (+ 0) |
Data Samples
Database APIs
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| admission | 11 | title |
100%
|
| admission_1 | 26,051 | key |
100%
|
| value |
65.26%
|
||
| admission_x_admission_1 | 26,051 | admission_id |
100%
|
| admission_1_id |
100%
|
||
| campus_life | 5 | title |
100%
|
| campus_life_1 | 2,354 | value |
100%
|
| campus_life_x_campus_life_1 | 2,354 | campus_life_id |
100%
|
| campus_life_1_id |
100%
|
||
| college | 4,210 | title |
99.95%
|
| address |
65.32%
|
||
| phone |
48.79%
|
||
| fax |
37.79%
|
||
|
44.89%
|
|||
| total_faculty |
50.26%
|
||
| full_time_percentage |
50.26%
|
||
| part_time_percentage |
50.26%
|
||
| female_percentage |
50.26%
|
||
| male_percentage |
50.26%
|
||
| faculty_ratio |
50.26%
|
||
| college_x_admission | 10,522 | college_id |
100%
|
| admission_id |
100%
|
||
| college_x_campus_life | 12,905 | college_id |
100%
|
| campus_life_id |
100%
|
||
| college_x_majors_and_degrees | 36,904 | college_id |
100%
|
| majors_and_degrees_id |
100%
|
||
| college_x_student_body | 7,728 | college_id |
100%
|
| student_body_id |
100%
|
||
| college_x_tuition_and_fee | 8,841 | college_id |
100%
|
| tuition_and_fee_id |
100%
|
||
| majors_and_degrees | 45 | title |
100%
|
| majors_and_degrees_1 | 1,965 | key |
100%
|
| value |
45.14%
|
||
| majors_and_degrees_x_majors_and_degrees_1 | 1,965 | majors_and_degrees_id |
100%
|
| majors_and_degrees_1_id |
100%
|
||
| state | 50 | title |
100%
|
| state_x_college | 4,210 | state_id |
100%
|
| college_id |
100%
|
||
| student_body | 4 | title |
100%
|
| student_body_1 | 10,698 | value |
100%
|
| student_body_x_student_body_1 | 10,713 | student_body_id |
100%
|
| student_body_1_id |
100%
|
||
| tuition_and_fee | 3 | title |
100%
|
| tuition_and_fee_1 | 6,706 | key |
100%
|
| value |
99.85%
|
||
| tuition_and_fee_x_tuition_and_fee_1 | 6,706 | tuition_and_fee_id |
100%
|
| tuition_and_fee_1_id |
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.
