In the high schools database, there are 15,387 records with title, region, description, grades, total enrollment, student teacher ratio, address, college readiness index, ap tested, ap passed, mathematics proficiency, english proficiency, etc. in each. It also contians high school proficiency test with 23,232 records; 8,753 high school rank records with value, remark; 50,709 high school score records; 46,119 high school student economically records; 15,374 high school student enrollment records with grade 9th, grade 10th, grade 11th, grade 12th, total student and high school id in each; 15,374 high school student gender records with female percent in each and 15,374 high school student race records with American Indian Alaskan native, Asian, black, Hawaiian native pacific islander, hispanic, white, more races and total minority in each.
The whole United States high schools database has 13 tables.
| Name | n3_lyz_usnews.com/best_high_schools |
|---|---|
| Data | 100.98M (+ 0B) |
| Tables | 13 (+ 0) |
| Columns | 93 (+ 0) |
| Table Rows | 453,028 (+ 0) |
| Media | 0B (+ 0B) |
| Files | 0 (+ 0) |
Data Samples
Database APIs
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| high_school | 15,387 | title |
100%
|
| region |
100%
|
||
| description |
99.99%
|
||
| grades |
99.99%
|
||
| total_enrollment |
99.99%
|
||
| student_teacher_ratio |
99.99%
|
||
| address |
99.99%
|
||
| telephone |
19.44%
|
||
| webset |
11.93%
|
||
| college_readiness_score |
10.73%
|
||
| total_score |
10.73%
|
||
| college_readiness_index |
50.18%
|
||
| ap_tested |
50.24%
|
||
| ap_passed |
50.2%
|
||
| mathematics_proficiency |
83.02%
|
||
| english_proficiency |
83.02%
|
||
| high_school_proficiency_test | 23,232 | title |
100%
|
| high_school_id |
100%
|
||
| high_school_proficiency_test_detail | 87,863 | title |
99.29%
|
| value |
100%
|
||
| high_school_proficiency_test_id |
100%
|
||
| high_school_rank | 8,753 | title |
100%
|
| value |
100%
|
||
| remark |
51.21%
|
||
| high_school_id |
100%
|
||
| high_school_score | 50,709 | title |
100%
|
| high_school_id |
100%
|
||
| high_school_score_detail | 144,944 | title |
100%
|
| value |
100%
|
||
| high_school_score_id |
100%
|
||
| high_school_student_economically | 46,119 | title |
100%
|
| value |
100%
|
||
| high_school_id |
100%
|
||
| high_school_student_enrollment | 15,374 | grade_9th |
100%
|
| grade_10th |
100%
|
||
| grade_11th |
100%
|
||
| grade_12th |
100%
|
||
| total_student |
100%
|
||
| high_school_id |
100%
|
||
| high_school_student_gender | 15,374 | female_percent |
100%
|
| high_school_id |
100%
|
||
| high_school_student_race | 15,374 | american_indian_alaskan_native |
100%
|
| asian |
100%
|
||
| black |
100%
|
||
| hawaiian_native_pacific_islander |
100%
|
||
| hispanic |
100%
|
||
| white |
100%
|
||
| more_races |
100%
|
||
| total_minority |
100%
|
||
| high_school_id |
100%
|
||
| high_shcool_proficiency_test_2 | 14,461 | mathematic_proficiency_percent_school |
82.31%
|
| mathematic_proficiency_percent_district |
91.76%
|
||
| mathematic_proficiency_percent_state |
100%
|
||
| english_proficiency_percent_school |
80.69%
|
||
| english_proficiency_percent_district |
90.57%
|
||
| english_proficiency_percent_sate |
100%
|
||
| high_school_id |
100%
|
||
| state | 51 | state |
100%
|
| state_x_high_school | 15,387 | state_id |
100%
|
| high_school_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.
