enrollments
Data source: Big Local News · About: Big Local
4,410 rows where state = "HI" and year = 2021 sorted by school_state_id
This data as json, CSV (advanced)
Link | rowid | state | county | county_state_id | admin_level | district_nces_id | district_state_id | district_state_type | district | school_nces_id | school_state_id ▼ | school | school_state_type | ccd_school_type | ccd_charter_school | ccd_school_lvl | ccd_school_low_grade | ccd_school_high_grade | year | term | grade | white | black | hispanic | native_american | native_american_alaskan_native | asian | native_hawaiian | asian_pacific_islander | native_hawaiian_pacific_islander | pacific_islander | multiracial | unknown_race | male | female | non_binary | unknown_gender | ell | ell_percent | homeless | homeless_percent | low_income | free_and_reduced | free_and_reduced_percent | disability | section_504 | total | white_int | black_int | hispanic_int | native_american_int | native_american_alaskan_native_int | asian_int | native_hawaiian_int | asian_pacific_islander_int | native_hawaiian_pacific_islander_int | pacific_islander_int | multiracial_int | unknown_race_int | male_int | female_int | non_binary_int | unknown_gender_int | ell_int | homeless_int | low_income_int | free_and_reduced_int | disability_int | section_504_int | total_int |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2453147 | 2453147 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000227 | 100 | Aina Haina Elem | Regular School | No | Elementary | PK | 5 | 2021 | kindergarten | 75.0 | 75 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2453441 | 2453441 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000227 | 100 | Aina Haina Elem | Regular School | No | Elementary | PK | 5 | 2021 | grade_1 | 65.0 | 65 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2453735 | 2453735 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000227 | 100 | Aina Haina Elem | Regular School | No | Elementary | PK | 5 | 2021 | grade_2 | 74.0 | 74 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2454029 | 2454029 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000227 | 100 | Aina Haina Elem | Regular School | No | Elementary | PK | 5 | 2021 | grade_3 | 73.0 | 73 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2454323 | 2454323 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000227 | 100 | Aina Haina Elem | Regular School | No | Elementary | PK | 5 | 2021 | grade_4 | 93.0 | 93 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2454617 | 2454617 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000227 | 100 | Aina Haina Elem | Regular School | No | Elementary | PK | 5 | 2021 | grade_5 | 71.0 | 71 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2454911 | 2454911 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000227 | 100 | Aina Haina Elem | Regular School | No | Elementary | PK | 5 | 2021 | grade_6 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2455205 | 2455205 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000227 | 100 | Aina Haina Elem | Regular School | No | Elementary | PK | 5 | 2021 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2455499 | 2455499 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000227 | 100 | Aina Haina Elem | Regular School | No | Elementary | PK | 5 | 2021 | grade_8 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2455793 | 2455793 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000227 | 100 | Aina Haina Elem | Regular School | No | Elementary | PK | 5 | 2021 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2456087 | 2456087 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000227 | 100 | Aina Haina Elem | Regular School | No | Elementary | PK | 5 | 2021 | grade_10 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2456381 | 2456381 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000227 | 100 | Aina Haina Elem | Regular School | No | Elementary | PK | 5 | 2021 | grade_11 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2456675 | 2456675 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000227 | 100 | Aina Haina Elem | Regular School | No | Elementary | PK | 5 | 2021 | grade_12 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2456969 | 2456969 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000227 | 100 | Aina Haina Elem | Regular School | No | Elementary | PK | 5 | 2021 | pre_kindergarten | 4.0 | 4 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2457263 | 2457263 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000227 | 100 | Aina Haina Elem | Regular School | No | Elementary | PK | 5 | 2021 | pk_12_total | 35.0 | 490.0 | 35 | 490 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2453172 | 2453172 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000226 | 101 | Ala Wai Elem | Regular School | No | Elementary | PK | 5 | 2021 | kindergarten | 57.0 | 57 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2453466 | 2453466 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000226 | 101 | Ala Wai Elem | Regular School | No | Elementary | PK | 5 | 2021 | grade_1 | 51.0 | 51 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2453760 | 2453760 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000226 | 101 | Ala Wai Elem | Regular School | No | Elementary | PK | 5 | 2021 | grade_2 | 56.0 | 56 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2454054 | 2454054 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000226 | 101 | Ala Wai Elem | Regular School | No | Elementary | PK | 5 | 2021 | grade_3 | 60.0 | 60 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2454348 | 2454348 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000226 | 101 | Ala Wai Elem | Regular School | No | Elementary | PK | 5 | 2021 | grade_4 | 50.0 | 50 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2454642 | 2454642 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000226 | 101 | Ala Wai Elem | Regular School | No | Elementary | PK | 5 | 2021 | grade_5 | 43.0 | 43 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2454936 | 2454936 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000226 | 101 | Ala Wai Elem | Regular School | No | Elementary | PK | 5 | 2021 | grade_6 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2455230 | 2455230 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000226 | 101 | Ala Wai Elem | Regular School | No | Elementary | PK | 5 | 2021 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2455524 | 2455524 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000226 | 101 | Ala Wai Elem | Regular School | No | Elementary | PK | 5 | 2021 | grade_8 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2455818 | 2455818 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000226 | 101 | Ala Wai Elem | Regular School | No | Elementary | PK | 5 | 2021 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2456112 | 2456112 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000226 | 101 | Ala Wai Elem | Regular School | No | Elementary | PK | 5 | 2021 | grade_10 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2456406 | 2456406 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000226 | 101 | Ala Wai Elem | Regular School | No | Elementary | PK | 5 | 2021 | grade_11 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2456700 | 2456700 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000226 | 101 | Ala Wai Elem | Regular School | No | Elementary | PK | 5 | 2021 | grade_12 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2456994 | 2456994 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000226 | 101 | Ala Wai Elem | Regular School | No | Elementary | PK | 5 | 2021 | pre_kindergarten | 13.0 | 13 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2457288 | 2457288 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000226 | 101 | Ala Wai Elem | Regular School | No | Elementary | PK | 5 | 2021 | pk_12_total | 33.0 | 363.0 | 33 | 363 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2453173 | 2453173 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000225 | 102 | Aliiolani Elem | Regular School | No | Elementary | PK | 5 | 2021 | kindergarten | 40.0 | 40 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2453467 | 2453467 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000225 | 102 | Aliiolani Elem | Regular School | No | Elementary | PK | 5 | 2021 | grade_1 | 35.0 | 35 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2453761 | 2453761 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000225 | 102 | Aliiolani Elem | Regular School | No | Elementary | PK | 5 | 2021 | grade_2 | 38.0 | 38 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2454055 | 2454055 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000225 | 102 | Aliiolani Elem | Regular School | No | Elementary | PK | 5 | 2021 | grade_3 | 40.0 | 40 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2454349 | 2454349 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000225 | 102 | Aliiolani Elem | Regular School | No | Elementary | PK | 5 | 2021 | grade_4 | 35.0 | 35 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2454643 | 2454643 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000225 | 102 | Aliiolani Elem | Regular School | No | Elementary | PK | 5 | 2021 | grade_5 | 46.0 | 46 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2454937 | 2454937 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000225 | 102 | Aliiolani Elem | Regular School | No | Elementary | PK | 5 | 2021 | grade_6 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2455231 | 2455231 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000225 | 102 | Aliiolani Elem | Regular School | No | Elementary | PK | 5 | 2021 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2455525 | 2455525 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000225 | 102 | Aliiolani Elem | Regular School | No | Elementary | PK | 5 | 2021 | grade_8 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2455819 | 2455819 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000225 | 102 | Aliiolani Elem | Regular School | No | Elementary | PK | 5 | 2021 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2456113 | 2456113 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000225 | 102 | Aliiolani Elem | Regular School | No | Elementary | PK | 5 | 2021 | grade_10 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2456407 | 2456407 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000225 | 102 | Aliiolani Elem | Regular School | No | Elementary | PK | 5 | 2021 | grade_11 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2456701 | 2456701 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000225 | 102 | Aliiolani Elem | Regular School | No | Elementary | PK | 5 | 2021 | grade_12 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2456995 | 2456995 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000225 | 102 | Aliiolani Elem | Regular School | No | Elementary | PK | 5 | 2021 | pre_kindergarten | 10.0 | 10 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2457289 | 2457289 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000225 | 102 | Aliiolani Elem | Regular School | No | Elementary | PK | 5 | 2021 | pk_12_total | 19.0 | 263.0 | 19 | 263 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2453174 | 2453174 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000246 | 103 | Anuenue | Regular School | No | Other | PK | 12 | 2021 | kindergarten | 30.0 | 30 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2453468 | 2453468 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000246 | 103 | Anuenue | Regular School | No | Other | PK | 12 | 2021 | grade_1 | 51.0 | 51 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2453762 | 2453762 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000246 | 103 | Anuenue | Regular School | No | Other | PK | 12 | 2021 | grade_2 | 61.0 | 61 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2454056 | 2454056 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000246 | 103 | Anuenue | Regular School | No | Other | PK | 12 | 2021 | grade_3 | 48.0 | 48 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2454350 | 2454350 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000246 | 103 | Anuenue | Regular School | No | Other | PK | 12 | 2021 | grade_4 | 45.0 | 45 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2454644 | 2454644 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000246 | 103 | Anuenue | Regular School | No | Other | PK | 12 | 2021 | grade_5 | 47.0 | 47 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2454938 | 2454938 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000246 | 103 | Anuenue | Regular School | No | Other | PK | 12 | 2021 | grade_6 | 29.0 | 29 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2455232 | 2455232 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000246 | 103 | Anuenue | Regular School | No | Other | PK | 12 | 2021 | grade_7 | 47.0 | 47 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2455526 | 2455526 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000246 | 103 | Anuenue | Regular School | No | Other | PK | 12 | 2021 | grade_8 | 32.0 | 32 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2455820 | 2455820 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000246 | 103 | Anuenue | Regular School | No | Other | PK | 12 | 2021 | grade_9 | 27.0 | 27 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2456114 | 2456114 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000246 | 103 | Anuenue | Regular School | No | Other | PK | 12 | 2021 | grade_10 | 17.0 | 17 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2456408 | 2456408 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000246 | 103 | Anuenue | Regular School | No | Other | PK | 12 | 2021 | grade_11 | 21.0 | 21 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2456702 | 2456702 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000246 | 103 | Anuenue | Regular School | No | Other | PK | 12 | 2021 | grade_12 | 22.0 | 22 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2456996 | 2456996 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000246 | 103 | Anuenue | Regular School | No | Other | PK | 12 | 2021 | pre_kindergarten | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2457290 | 2457290 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000246 | 103 | Anuenue | Regular School | No | Other | PK | 12 | 2021 | pk_12_total | 30.0 | 507.0 | 30 | 507 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2453175 | 2453175 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000223 | 104 | Central Middle | Regular School | No | Middle | 06 | 8 | 2021 | kindergarten | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2453469 | 2453469 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000223 | 104 | Central Middle | Regular School | No | Middle | 06 | 8 | 2021 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2453763 | 2453763 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000223 | 104 | Central Middle | Regular School | No | Middle | 06 | 8 | 2021 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2454057 | 2454057 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000223 | 104 | Central Middle | Regular School | No | Middle | 06 | 8 | 2021 | grade_3 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2454351 | 2454351 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000223 | 104 | Central Middle | Regular School | No | Middle | 06 | 8 | 2021 | grade_4 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2454645 | 2454645 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000223 | 104 | Central Middle | Regular School | No | Middle | 06 | 8 | 2021 | grade_5 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2454939 | 2454939 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000223 | 104 | Central Middle | Regular School | No | Middle | 06 | 8 | 2021 | grade_6 | 72.0 | 72 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2455233 | 2455233 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000223 | 104 | Central Middle | Regular School | No | Middle | 06 | 8 | 2021 | grade_7 | 99.0 | 99 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2455527 | 2455527 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000223 | 104 | Central Middle | Regular School | No | Middle | 06 | 8 | 2021 | grade_8 | 105.0 | 105 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2455821 | 2455821 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000223 | 104 | Central Middle | Regular School | No | Middle | 06 | 8 | 2021 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2456115 | 2456115 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000223 | 104 | Central Middle | Regular School | No | Middle | 06 | 8 | 2021 | grade_10 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2456409 | 2456409 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000223 | 104 | Central Middle | Regular School | No | Middle | 06 | 8 | 2021 | grade_11 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2456703 | 2456703 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000223 | 104 | Central Middle | Regular School | No | Middle | 06 | 8 | 2021 | grade_12 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2456997 | 2456997 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000223 | 104 | Central Middle | Regular School | No | Middle | 06 | 8 | 2021 | pre_kindergarten | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2457291 | 2457291 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000223 | 104 | Central Middle | Regular School | No | Middle | 06 | 8 | 2021 | pk_12_total | 45.0 | 321.0 | 45 | 321 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2453148 | 2453148 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000222 | 105 | Dole Middle | Regular School | No | Middle | 06 | 8 | 2021 | kindergarten | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2453442 | 2453442 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000222 | 105 | Dole Middle | Regular School | No | Middle | 06 | 8 | 2021 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2453736 | 2453736 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000222 | 105 | Dole Middle | Regular School | No | Middle | 06 | 8 | 2021 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2454030 | 2454030 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000222 | 105 | Dole Middle | Regular School | No | Middle | 06 | 8 | 2021 | grade_3 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2454324 | 2454324 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000222 | 105 | Dole Middle | Regular School | No | Middle | 06 | 8 | 2021 | grade_4 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2454618 | 2454618 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000222 | 105 | Dole Middle | Regular School | No | Middle | 06 | 8 | 2021 | grade_5 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2454912 | 2454912 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000222 | 105 | Dole Middle | Regular School | No | Middle | 06 | 8 | 2021 | grade_6 | 121.0 | 121 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2455206 | 2455206 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000222 | 105 | Dole Middle | Regular School | No | Middle | 06 | 8 | 2021 | grade_7 | 198.0 | 198 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2455500 | 2455500 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000222 | 105 | Dole Middle | Regular School | No | Middle | 06 | 8 | 2021 | grade_8 | 183.0 | 183 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2455794 | 2455794 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000222 | 105 | Dole Middle | Regular School | No | Middle | 06 | 8 | 2021 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2456088 | 2456088 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000222 | 105 | Dole Middle | Regular School | No | Middle | 06 | 8 | 2021 | grade_10 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2456382 | 2456382 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000222 | 105 | Dole Middle | Regular School | No | Middle | 06 | 8 | 2021 | grade_11 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2456676 | 2456676 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000222 | 105 | Dole Middle | Regular School | No | Middle | 06 | 8 | 2021 | grade_12 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2456970 | 2456970 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000222 | 105 | Dole Middle | Regular School | No | Middle | 06 | 8 | 2021 | pre_kindergarten | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2457264 | 2457264 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000222 | 105 | Dole Middle | Regular School | No | Middle | 06 | 8 | 2021 | pk_12_total | 78.0 | 580.0 | 78 | 580 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2453149 | 2453149 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000221 | 106 | Farrington High | Regular School | No | High | 09 | 12 | 2021 | kindergarten | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2453443 | 2453443 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000221 | 106 | Farrington High | Regular School | No | High | 09 | 12 | 2021 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2453737 | 2453737 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000221 | 106 | Farrington High | Regular School | No | High | 09 | 12 | 2021 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2454031 | 2454031 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000221 | 106 | Farrington High | Regular School | No | High | 09 | 12 | 2021 | grade_3 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2454325 | 2454325 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000221 | 106 | Farrington High | Regular School | No | High | 09 | 12 | 2021 | grade_4 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2454619 | 2454619 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000221 | 106 | Farrington High | Regular School | No | High | 09 | 12 | 2021 | grade_5 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2454913 | 2454913 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000221 | 106 | Farrington High | Regular School | No | High | 09 | 12 | 2021 | grade_6 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2455207 | 2455207 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000221 | 106 | Farrington High | Regular School | No | High | 09 | 12 | 2021 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2455501 | 2455501 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000221 | 106 | Farrington High | Regular School | No | High | 09 | 12 | 2021 | grade_8 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2455795 | 2455795 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000221 | 106 | Farrington High | Regular School | No | High | 09 | 12 | 2021 | grade_9 | 674.0 | 674 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "enrollments" ( [state] TEXT, [county] TEXT, [county_state_id] INTEGER, [admin_level] TEXT, [district_nces_id] INTEGER, [district_state_id] TEXT, [district_state_type] TEXT, [district] TEXT, [school_nces_id] INTEGER, [school_state_id] INTEGER, [school] TEXT, [school_state_type] TEXT, [ccd_school_type] TEXT, [ccd_charter_school] TEXT, [ccd_school_lvl] TEXT, [ccd_school_low_grade] TEXT, [ccd_school_high_grade] TEXT, [year] INTEGER, [term] TEXT, [grade] TEXT, [white] TEXT, [black] TEXT, [hispanic] TEXT, [native_american] TEXT, [native_american_alaskan_native] TEXT, [asian] TEXT, [native_hawaiian] TEXT, [asian_pacific_islander] TEXT, [native_hawaiian_pacific_islander] TEXT, [pacific_islander] TEXT, [multiracial] TEXT, [unknown_race] TEXT, [male] TEXT, [female] TEXT, [non_binary] TEXT, [unknown_gender] TEXT, [ell] TEXT, [ell_percent] TEXT, [homeless] TEXT, [homeless_percent] TEXT, [low_income] TEXT, [free_and_reduced] TEXT, [free_and_reduced_percent] TEXT, [disability] TEXT, [section_504] TEXT, [total] TEXT , [white_int] INTEGER, [black_int] INTEGER, [hispanic_int] INTEGER, [native_american_int] INTEGER, [native_american_alaskan_native_int] INTEGER, [asian_int] INTEGER, [native_hawaiian_int] INTEGER, [asian_pacific_islander_int] INTEGER, [native_hawaiian_pacific_islander_int] INTEGER, [pacific_islander_int] INTEGER, [multiracial_int] INTEGER, [unknown_race_int] INTEGER, [male_int] INTEGER, [female_int] INTEGER, [non_binary_int] INTEGER, [unknown_gender_int] INTEGER, [ell_int] INTEGER, [homeless_int] INTEGER, [low_income_int] INTEGER, [free_and_reduced_int] INTEGER, [disability_int] INTEGER, [section_504_int] INTEGER, [total_int] INTEGER); CREATE INDEX [idx_enrollments_state_grade] ON [enrollments] ([state], [grade]); CREATE INDEX [idx_enrollments_grade] ON [enrollments] ([grade]); CREATE INDEX [idx_enrollments_year] ON [enrollments] ([year]); CREATE INDEX [idx_enrollments_state_year] ON [enrollments] ([state], [year]); CREATE INDEX [idx_enrollments_school_nces_id] ON [enrollments] ([school_nces_id]); CREATE INDEX [idx_enrollments_district_nces_id] ON [enrollments] ([district_nces_id]);