Name | n3_lyz_usnews.com/best_colleges |
---|---|
Data | 181.31M (+ 0B) |
Tables | 61 (+ 0) |
Columns | 334 (+ 0) |
Table Rows | 700,773 (+ 0) |
Media | 2.82G (+ 0B) |
Files | 19,011 (+ 0) |
Last Commit | 2023-06-19 18:12:05 (+ 169 d) |
This is a most comprehensive America colleges database of evaluation and ranking information over 51 states. It contains 1,730 colleges with city, overview, description, school type, year founded, religious affiliation, academic calendar, setting, year 2016 endowment, address, telephone, overall score and total score in each.
In the whole US colleges database, there are 1,622 college academic records and details; 1,622 college apply records with tuition, room and board, total enrollment, application deadline, application fee, acceptance rate and description in each; 4,795 college general rank records with rank, remark, rank project in each; 169 college global records with global rank, address, website, description in each and details, indicator, subject; 599 college grad records with description, rank, subject and subject slug; 1,727 college indicator records with description and detail; 1,244 college online records with rank, remark, rank project in each and class size, gender detail, project, project detail, rank detail, retention rate, tuition; 1,206 college paying records with description and detail; college safty with 0 records and detail; 1,730 college services with description, detail and detail value; 1,730 college student life records with total enrollment, live on campus, athletic association, description in each and detail, campus, gender, value; 1,616 descriptions and 7,950 details of grad subject with information, student and tuition. It also comes with 19,011 college images in the US colleges database. It includes 2.82G college images in the media file.
It totally has 61 tables in this whole the United States colleges information and ranking database.
Tables | Rows | Columns | Non-empty |
---|---|---|---|
college | 1,730 | college |
100%
|
city |
100%
|
||
overview |
100%
|
||
description |
100%
|
||
school_type |
100%
|
||
year_founded |
100%
|
||
religious_affiliation |
100%
|
||
academic_calendar |
100%
|
||
setting |
100%
|
||
year_2016_endowment |
100%
|
||
address |
100%
|
||
telephone |
100%
|
||
overall_score |
61.39%
|
||
total_score |
61.39%
|
||
college_academic | 1,622 | description |
100%
|
college_id |
100%
|
||
college_academic_detail | 6,484 | title |
100%
|
college_id |
100%
|
||
college_academic_detail_2 | 19,452 | title |
100%
|
college_academic_detail_id |
100%
|
||
value |
66.67%
|
||
college_academic_detail_3 | 17,818 | value |
99.99%
|
college_academic_detail_2_id |
100%
|
||
college_academic_detail_3s | 4,863 | title |
100%
|
value |
100%
|
||
college_academic_detail_2_id |
100%
|
||
college_apply | 1,622 | tuition |
100%
|
room_and_board |
100%
|
||
total_enrollment |
100%
|
||
application_deadline |
100%
|
||
application_fee |
100%
|
||
acceptance_rate |
100%
|
||
description |
100%
|
||
college_id |
100%
|
||
college_apply_detail | 8,110 | title |
100%
|
college_id |
100%
|
||
college_apply_detail_2 | 47,038 | title |
100%
|
value |
100%
|
||
college_apply_detail_id |
100%
|
||
college_general_rank | 4,795 | rank |
84.69%
|
remark |
50.07%
|
||
rank_project |
100%
|
||
college_id |
100%
|
||
college_global | 169 | global_rank |
99.41%
|
address |
100%
|
||
website |
98.82%
|
||
description |
13.61%
|
||
college_id |
100%
|
||
college_global_detail | 1,823 | title |
100%
|
value |
100%
|
||
college_id |
100%
|
||
college_global_indicator | 2,324 | title |
100%
|
value |
100%
|
||
remark |
90.83%
|
||
college_id |
100%
|
||
college_global_subject | 1,626 | title |
100%
|
value |
100%
|
||
remark |
44.16%
|
||
college_id |
100%
|
||
college_global_subject_detail | 19,512 | title |
100%
|
value |
100%
|
||
remark |
91.67%
|
||
college_global_subject_id |
100%
|
||
college_grad | 599 | college |
100%
|
description |
99.33%
|
||
college_id |
100%
|
||
college_grad_rank | 8,250 | project |
100%
|
rank |
97.15%
|
||
remake |
12.81%
|
||
score |
9.08%
|
||
college_grad_id |
100%
|
||
college_grad_sub_subject | 13,060 | sub_subject |
100%
|
college_grad_subject_id |
100%
|
||
college_grad_subject | 3,077 | subject |
100%
|
college_id |
100%
|
||
college_grad_subject_slug | 3,078 | subject |
100%
|
college_id |
100%
|
||
college_image_slug | 19,011 | college_id |
100%
|
college_indicator | 1,727 | collage |
100%
|
description |
100%
|
||
college_id |
100%
|
||
college_indicator_detail | 20,723 | title |
100%
|
college_id |
100%
|
||
college_indicator_detail_2 | 12,089 | title |
100%
|
value |
100%
|
||
college_indicator_detail_id |
100%
|
||
college_online | 1,244 | rank |
97.27%
|
remark |
70.74%
|
||
rank_project |
100%
|
||
college_id |
100%
|
||
college_online_class_size | 4,564 | size |
100%
|
percent |
100%
|
||
college_online_project_id |
100%
|
||
college_online_gender_detail | 705 | gender |
100%
|
percent |
100%
|
||
college_online_project_detail_id |
100%
|
||
college_online_project | 764 | total_enrollment |
100%
|
application_deadline |
100%
|
||
description |
98.56%
|
||
description_by_school |
94.11%
|
||
college_online_id |
100%
|
||
college_online_project_detail | 3,765 | title |
100%
|
college_online_project_id |
100%
|
||
college_online_project_detail_2 | 25,421 | title |
100%
|
college_online_project_detail_id |
100%
|
||
college_online_project_detail_3 | 131,300 | title |
100%
|
sub_title |
2.07%
|
||
value |
99.46%
|
||
college_online_project_detail_2_id |
100%
|
||
college_online_rank_detail | 5,193 | title |
100%
|
rank |
100%
|
||
college_online_project_id |
100%
|
||
college_online_retention_rate | 2,392 | time |
100%
|
percent |
100%
|
||
college_online_project_id |
100%
|
||
college_online_tuition | 3,056 | name |
100%
|
value |
100%
|
||
college_online_id |
100%
|
||
college_paying | 1,206 | description |
100%
|
college_id |
100%
|
||
college_paying_detail | 6,900 | title |
100%
|
college_id |
100%
|
||
college_paying_detail_2 | 17,827 | title |
100%
|
value |
100%
|
||
college_paying_detail_id |
100%
|
||
college_safety | 10,379 | title |
100%
|
college_id |
100%
|
||
college_safety_detail | 83,027 | title |
100%
|
year_2013 |
100%
|
||
year_2014 |
100%
|
||
year_2015 |
100%
|
||
college_safety_id |
100%
|
||
college_service | 1,730 | college |
100%
|
description |
83.24%
|
||
college_id |
100%
|
||
college_service_detail | 12,096 | title |
100%
|
college_id |
100%
|
||
college_service_detail_2 | 10,368 | title |
100%
|
value |
100%
|
||
college_service_detail_id |
100%
|
||
college_service_detail_2s | 10,368 | title |
100%
|
college_service_detail_id |
100%
|
||
college_service_detail_value | 54,717 | value |
100%
|
college_service_detail_2s_id |
100%
|
||
college_student_life | 1,730 | total_enrollment |
100%
|
live_on_campus |
100%
|
||
athletic_association |
100%
|
||
description |
85.09%
|
||
college_id |
100%
|
||
college_student_life_detail | 6,920 | title |
100%
|
college_id |
100%
|
||
college_student_life_detail_2 | 17,641 | title |
100%
|
value |
100%
|
||
college_student_life_detail_id |
100%
|
||
college_student_life_detail_2s | 4,849 | title |
100%
|
college_student_life_detail_id |
100%
|
||
college_student_life_detail_compus | 3,460 | title |
100%
|
value |
100%
|
||
college_student_life_detail_2s_id |
100%
|
||
college_student_life_detail_gender | 1,389 | title |
100%
|
value |
100%
|
||
college_student_life_detail_2s_id |
100%
|
||
college_student_life_detail_value | 6,554 | value |
100%
|
college_student_life_detail_2s_id |
100%
|
||
grad_subject_description | 1,616 | subject |
100%
|
description |
94.06%
|
||
college_grad_subject_slug_id |
100%
|
||
grad_subject_detail | 7,950 | title |
100%
|
college_grad_subject_slug_id |
100%
|
||
grad_subject_detail_2 | 23,708 | title |
100%
|
value |
79.77%
|
||
grad_subject_detail_id |
100%
|
||
grad_subject_detail_2s | 4,398 | title |
100%
|
grad_subject_detail_id |
100%
|
||
grad_subject_information | 7,126 | title |
75.34%
|
address |
54.62%
|
||
college_grad_subject_slug_id |
100%
|
||
phone |
54.56%
|
||
52.65%
|
|||
websit |
55.4%
|
||
rank |
59.57%
|
||
rank_mark |
91.41%
|
||
grad_subject_student | 2,096 | title |
100%
|
value |
100%
|
||
college_grad_subject_slug_id |
100%
|
||
grad_subject_tuition | 1,931 | title |
100%
|
value |
100%
|
||
college_grad_subject_slug_id |
100%
|
||
state | 51 | state |
100%
|
state_x_college | 1,730 | state_id |
100%
|
college_id |
100%
|
Size (Bytes) | Files |
---|---|
2.82G | 19,011 |
Time | Data | Tables | Columns | Rows | Media | Files |
---|---|---|---|---|---|---|
2023-06-19 (+ 169 d) | 181.31M (+ 0B) | 61 (+ 0) | 334 (+ 0) | 700,773 (+ 0) | 2.82G (+ 0B) | 19,011 (+ 0) |
2023-01-01 (+ 95 d) | 181.31M (+ 0B) | 61 (+ 0) | 334 (+ 0) | 700,773 (+ 0) | 2.82G (+ 0B) | 19,011 (+ 0) |
2022-09-27 (+ 271 d) | 181.31M (+ 0B) | 61 (+ 0) | 334 (+ 0) | 700,773 (+ 0) | 2.82G (+ 0B) | 19,011 (+ 0) |
2021-12-30 (+ 115 d) | 181.31M (+ 0B) | 61 (+ 0) | 334 (+ 0) | 700,773 (+ 0) | 2.82G (+ 0B) | 19,011 (+ 0) |
2021-09-05 (+ 150 d) | 181.31M (+ 0B) | 61 (+ 0) | 334 (+ 0) | 700,773 (+ 0) | 2.82G (+ 0B) | 19,011 (+ 0) |
2021-04-08 (+ 68 d) | 181.31M (+ 0B) | 61 (+ 0) | 334 (+ 0) | 700,773 (+ 0) | 2.82G (+ 0B) | 19,011 (+ 0) |
2021-01-29 (+ 120 d) | 181.31M (+ 0B) | 61 (+ 0) | 334 (+ 0) | 700,773 (+ 0) | 2.82G (+ 0B) | 19,011 (+ 0) |
2020-10-01 (+ 38 d) | 181.31M (+ 0B) | 61 (+ 0) | 334 (+ 0) | 700,773 (+ 0) | 2.82G (+ 0B) | 19,011 (+ 0) |
2020-08-23 (+ 141 d) | 181.31M (+ 0B) | 61 (+ 0) | 334 (+ 0) | 700,773 (+ 0) | 2.82G (+ 0B) | 19,011 (+ 0) |
2020-04-04 (+ 196 d) | 181.31M (+ 0B) | 61 (+ 0) | 334 (+ 0) | 700,773 (+ 0) | 2.82G (+ 0B) | 19,011 (+ 0) |
2019-09-21 (+ 197 d) | 181.31M (+ 0B) | 61 (+ 0) | 334 (+ 0) | 700,773 (+ 0) | 2.82G (+ 0B) | 19,011 (+ 0) |
2019-03-07 (+ 43 d) | 181.31M (+ 0B) | 61 (+ 0) | 334 (+ 0) | 700,773 (+ 0) | 2.82G (+ 0B) | 19,011 (+ 0) |
2019-01-23 (+ 44 d) | 181.31M (+ 0B) | 61 (+ 0) | 334 (+ 0) | 700,773 (+ 0) | 2.82G (+ 0B) | 19,011 (+ 0) |
2018-12-09 (+ 29 d) | 181.31M (+ 2.38M) | 61 (+ 0) | 334 (+ 0) | 700,773 (+ 0) | 2.82G (+ 0B) | 19,011 (+ 0) |
2018-11-09 (+ 27 d) | 178.94M (+ 1.28M) | 61 (+ 0) | 334 (+ 0) | 700,773 (+ 0) | 2.82G (+ 0B) | 19,011 (+ 0) |
2018-10-13 (+ 29 d) | 177.66M (+ 0B) | 61 (+ 0) | 334 (+ 0) | 700,773 (+ 0) | 2.82G (+ 0B) | 19,011 (+ 0) |
2018-09-13 (+ 34 d) | 177.66M (+ 0B) | 61 (+ 0) | 334 (+ 0) | 700,773 (+ 0) | 2.82G (+ 0B) | 19,011 (+ 0) |
2018-08-09 (+ 27 d) | 177.66M (+ 0B) | 61 (+ 0) | 334 (+ 0) | 700,773 (+ 0) | 2.82G (+ 0B) | 19,011 (+ 0) |
2018-07-12 (+ 31 d) | 177.66M (+ 0B) | 61 (+ 0) | 334 (+ 0) | 700,773 (+ 0) | 2.82G (+ 0B) | 19,011 (+ 0) |
2018-06-10 (+ 31 d) | 177.66M (+ 55.84M) | 61 (+ 0) | 334 (+ 0) | 700,773 (+ 186,389) | 2.82G (+ 2.82G) | 19,011 (+ 19,011) |
2018-05-10 (+ 28 d) | 121.81M (+ 74.27M) | 61 (+ 1) | 334 (+ 10) | 514,384 (+ 322,898) | 0B (+ 0B) | 0 (+ 0) |
2018-04-11 | 47.55M | 60 | 324 | 191,486 | 0B | 0 |
Contact us for pricing to download the latest commit / release of this database.
In the same time, you can also access this data set via API.
Select a membership plan and sign up. Return to this page, click Online Query to access the API query maker. Create and open an API call to acquire the data.
The scanning and profiling of data size increments are done separately from those of the number of rows.
Subscribe to be notified of major data releases and updates.
STAY IN THE LOOP.