enrollments
Data source: Big Local News · About: Big Local
4,395 rows where state = "HI" and year = 2020 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2428466 | 2428466 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000227 | 100 | Aina Haina Elem | Regular School | No | Elementary | PK | 5 | 2020 | kindergarten | 59.0 | 59 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2428759 | 2428759 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000227 | 100 | Aina Haina Elem | Regular School | No | Elementary | PK | 5 | 2020 | grade_1 | 77.0 | 77 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2429052 | 2429052 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000227 | 100 | Aina Haina Elem | Regular School | No | Elementary | PK | 5 | 2020 | grade_2 | 68.0 | 68 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2429345 | 2429345 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000227 | 100 | Aina Haina Elem | Regular School | No | Elementary | PK | 5 | 2020 | grade_3 | 91.0 | 91 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2429638 | 2429638 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000227 | 100 | Aina Haina Elem | Regular School | No | Elementary | PK | 5 | 2020 | grade_4 | 72.0 | 72 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2429931 | 2429931 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000227 | 100 | Aina Haina Elem | Regular School | No | Elementary | PK | 5 | 2020 | grade_5 | 60.0 | 60 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2430224 | 2430224 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000227 | 100 | Aina Haina Elem | Regular School | No | Elementary | PK | 5 | 2020 | grade_6 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2430517 | 2430517 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000227 | 100 | Aina Haina Elem | Regular School | No | Elementary | PK | 5 | 2020 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2430810 | 2430810 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000227 | 100 | Aina Haina Elem | Regular School | No | Elementary | PK | 5 | 2020 | grade_8 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2431103 | 2431103 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000227 | 100 | Aina Haina Elem | Regular School | No | Elementary | PK | 5 | 2020 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2431396 | 2431396 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000227 | 100 | Aina Haina Elem | Regular School | No | Elementary | PK | 5 | 2020 | grade_10 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2431689 | 2431689 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000227 | 100 | Aina Haina Elem | Regular School | No | Elementary | PK | 5 | 2020 | grade_11 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2431982 | 2431982 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000227 | 100 | Aina Haina Elem | Regular School | No | Elementary | PK | 5 | 2020 | grade_12 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2432275 | 2432275 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000227 | 100 | Aina Haina Elem | Regular School | No | Elementary | PK | 5 | 2020 | pre_kindergarten | 4.0 | 4 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2432568 | 2432568 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000227 | 100 | Aina Haina Elem | Regular School | No | Elementary | PK | 5 | 2020 | pk_12_total | 31.0 | 462.0 | 31 | 462 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2428491 | 2428491 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000226 | 101 | Ala Wai Elem | Regular School | No | Elementary | PK | 5 | 2020 | kindergarten | 50.0 | 50 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2428784 | 2428784 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000226 | 101 | Ala Wai Elem | Regular School | No | Elementary | PK | 5 | 2020 | grade_1 | 59.0 | 59 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2429077 | 2429077 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000226 | 101 | Ala Wai Elem | Regular School | No | Elementary | PK | 5 | 2020 | grade_2 | 60.0 | 60 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2429370 | 2429370 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000226 | 101 | Ala Wai Elem | Regular School | No | Elementary | PK | 5 | 2020 | grade_3 | 52.0 | 52 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2429663 | 2429663 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000226 | 101 | Ala Wai Elem | Regular School | No | Elementary | PK | 5 | 2020 | grade_4 | 50.0 | 50 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2429956 | 2429956 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000226 | 101 | Ala Wai Elem | Regular School | No | Elementary | PK | 5 | 2020 | grade_5 | 43.0 | 43 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2430249 | 2430249 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000226 | 101 | Ala Wai Elem | Regular School | No | Elementary | PK | 5 | 2020 | grade_6 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2430542 | 2430542 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000226 | 101 | Ala Wai Elem | Regular School | No | Elementary | PK | 5 | 2020 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2430835 | 2430835 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000226 | 101 | Ala Wai Elem | Regular School | No | Elementary | PK | 5 | 2020 | grade_8 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2431128 | 2431128 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000226 | 101 | Ala Wai Elem | Regular School | No | Elementary | PK | 5 | 2020 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2431421 | 2431421 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000226 | 101 | Ala Wai Elem | Regular School | No | Elementary | PK | 5 | 2020 | grade_10 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2431714 | 2431714 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000226 | 101 | Ala Wai Elem | Regular School | No | Elementary | PK | 5 | 2020 | grade_11 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2432007 | 2432007 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000226 | 101 | Ala Wai Elem | Regular School | No | Elementary | PK | 5 | 2020 | grade_12 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2432300 | 2432300 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000226 | 101 | Ala Wai Elem | Regular School | No | Elementary | PK | 5 | 2020 | pre_kindergarten | 13.0 | 13 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2432593 | 2432593 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000226 | 101 | Ala Wai Elem | Regular School | No | Elementary | PK | 5 | 2020 | pk_12_total | 25.0 | 352.0 | 25 | 352 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2428492 | 2428492 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000225 | 102 | Aliiolani Elem | Regular School | No | Elementary | PK | 5 | 2020 | kindergarten | 32.0 | 32 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2428785 | 2428785 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000225 | 102 | Aliiolani Elem | Regular School | No | Elementary | PK | 5 | 2020 | grade_1 | 35.0 | 35 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2429078 | 2429078 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000225 | 102 | Aliiolani Elem | Regular School | No | Elementary | PK | 5 | 2020 | grade_2 | 40.0 | 40 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2429371 | 2429371 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000225 | 102 | Aliiolani Elem | Regular School | No | Elementary | PK | 5 | 2020 | grade_3 | 36.0 | 36 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2429664 | 2429664 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000225 | 102 | Aliiolani Elem | Regular School | No | Elementary | PK | 5 | 2020 | grade_4 | 43.0 | 43 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2429957 | 2429957 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000225 | 102 | Aliiolani Elem | Regular School | No | Elementary | PK | 5 | 2020 | grade_5 | 24.0 | 24 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2430250 | 2430250 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000225 | 102 | Aliiolani Elem | Regular School | No | Elementary | PK | 5 | 2020 | grade_6 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2430543 | 2430543 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000225 | 102 | Aliiolani Elem | Regular School | No | Elementary | PK | 5 | 2020 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2430836 | 2430836 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000225 | 102 | Aliiolani Elem | Regular School | No | Elementary | PK | 5 | 2020 | grade_8 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2431129 | 2431129 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000225 | 102 | Aliiolani Elem | Regular School | No | Elementary | PK | 5 | 2020 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2431422 | 2431422 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000225 | 102 | Aliiolani Elem | Regular School | No | Elementary | PK | 5 | 2020 | grade_10 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2431715 | 2431715 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000225 | 102 | Aliiolani Elem | Regular School | No | Elementary | PK | 5 | 2020 | grade_11 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2432008 | 2432008 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000225 | 102 | Aliiolani Elem | Regular School | No | Elementary | PK | 5 | 2020 | grade_12 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2432301 | 2432301 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000225 | 102 | Aliiolani Elem | Regular School | No | Elementary | PK | 5 | 2020 | pre_kindergarten | 8.0 | 8 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2432594 | 2432594 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000225 | 102 | Aliiolani Elem | Regular School | No | Elementary | PK | 5 | 2020 | pk_12_total | 21.0 | 239.0 | 21 | 239 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2428493 | 2428493 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000246 | 103 | Anuenue | Regular School | No | Other | PK | 12 | 2020 | kindergarten | 54.0 | 54 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2428786 | 2428786 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000246 | 103 | Anuenue | Regular School | No | Other | PK | 12 | 2020 | grade_1 | 72.0 | 72 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2429079 | 2429079 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000246 | 103 | Anuenue | Regular School | No | Other | PK | 12 | 2020 | grade_2 | 52.0 | 52 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2429372 | 2429372 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000246 | 103 | Anuenue | Regular School | No | Other | PK | 12 | 2020 | grade_3 | 48.0 | 48 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2429665 | 2429665 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000246 | 103 | Anuenue | Regular School | No | Other | PK | 12 | 2020 | grade_4 | 51.0 | 51 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2429958 | 2429958 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000246 | 103 | Anuenue | Regular School | No | Other | PK | 12 | 2020 | grade_5 | 32.0 | 32 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2430251 | 2430251 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000246 | 103 | Anuenue | Regular School | No | Other | PK | 12 | 2020 | grade_6 | 47.0 | 47 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2430544 | 2430544 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000246 | 103 | Anuenue | Regular School | No | Other | PK | 12 | 2020 | grade_7 | 39.0 | 39 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2430837 | 2430837 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000246 | 103 | Anuenue | Regular School | No | Other | PK | 12 | 2020 | grade_8 | 38.0 | 38 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2431130 | 2431130 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000246 | 103 | Anuenue | Regular School | No | Other | PK | 12 | 2020 | grade_9 | 23.0 | 23 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2431423 | 2431423 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000246 | 103 | Anuenue | Regular School | No | Other | PK | 12 | 2020 | grade_10 | 24.0 | 24 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2431716 | 2431716 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000246 | 103 | Anuenue | Regular School | No | Other | PK | 12 | 2020 | grade_11 | 18.0 | 18 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2432009 | 2432009 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000246 | 103 | Anuenue | Regular School | No | Other | PK | 12 | 2020 | grade_12 | 17.0 | 17 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2432302 | 2432302 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000246 | 103 | Anuenue | Regular School | No | Other | PK | 12 | 2020 | pre_kindergarten | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2432595 | 2432595 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000246 | 103 | Anuenue | Regular School | No | Other | PK | 12 | 2020 | pk_12_total | 30.0 | 545.0 | 30 | 545 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2428494 | 2428494 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000223 | 104 | Central Middle | Regular School | No | Middle | 06 | 8 | 2020 | kindergarten | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2428787 | 2428787 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000223 | 104 | Central Middle | Regular School | No | Middle | 06 | 8 | 2020 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2429080 | 2429080 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000223 | 104 | Central Middle | Regular School | No | Middle | 06 | 8 | 2020 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2429373 | 2429373 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000223 | 104 | Central Middle | Regular School | No | Middle | 06 | 8 | 2020 | grade_3 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2429666 | 2429666 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000223 | 104 | Central Middle | Regular School | No | Middle | 06 | 8 | 2020 | grade_4 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2429959 | 2429959 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000223 | 104 | Central Middle | Regular School | No | Middle | 06 | 8 | 2020 | grade_5 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2430252 | 2430252 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000223 | 104 | Central Middle | Regular School | No | Middle | 06 | 8 | 2020 | grade_6 | 115.0 | 115 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2430545 | 2430545 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000223 | 104 | Central Middle | Regular School | No | Middle | 06 | 8 | 2020 | grade_7 | 118.0 | 118 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2430838 | 2430838 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000223 | 104 | Central Middle | Regular School | No | Middle | 06 | 8 | 2020 | grade_8 | 118.0 | 118 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2431131 | 2431131 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000223 | 104 | Central Middle | Regular School | No | Middle | 06 | 8 | 2020 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2431424 | 2431424 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000223 | 104 | Central Middle | Regular School | No | Middle | 06 | 8 | 2020 | grade_10 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2431717 | 2431717 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000223 | 104 | Central Middle | Regular School | No | Middle | 06 | 8 | 2020 | grade_11 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2432010 | 2432010 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000223 | 104 | Central Middle | Regular School | No | Middle | 06 | 8 | 2020 | grade_12 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2432303 | 2432303 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000223 | 104 | Central Middle | Regular School | No | Middle | 06 | 8 | 2020 | pre_kindergarten | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2432596 | 2432596 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000223 | 104 | Central Middle | Regular School | No | Middle | 06 | 8 | 2020 | pk_12_total | 48.0 | 399.0 | 48 | 399 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2428467 | 2428467 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000222 | 105 | Dole Middle | Regular School | No | Middle | 06 | 8 | 2020 | kindergarten | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2428760 | 2428760 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000222 | 105 | Dole Middle | Regular School | No | Middle | 06 | 8 | 2020 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2429053 | 2429053 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000222 | 105 | Dole Middle | Regular School | No | Middle | 06 | 8 | 2020 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2429346 | 2429346 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000222 | 105 | Dole Middle | Regular School | No | Middle | 06 | 8 | 2020 | grade_3 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2429639 | 2429639 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000222 | 105 | Dole Middle | Regular School | No | Middle | 06 | 8 | 2020 | grade_4 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2429932 | 2429932 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000222 | 105 | Dole Middle | Regular School | No | Middle | 06 | 8 | 2020 | grade_5 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2430225 | 2430225 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000222 | 105 | Dole Middle | Regular School | No | Middle | 06 | 8 | 2020 | grade_6 | 201.0 | 201 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2430518 | 2430518 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000222 | 105 | Dole Middle | Regular School | No | Middle | 06 | 8 | 2020 | grade_7 | 240.0 | 240 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2430811 | 2430811 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000222 | 105 | Dole Middle | Regular School | No | Middle | 06 | 8 | 2020 | grade_8 | 191.0 | 191 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2431104 | 2431104 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000222 | 105 | Dole Middle | Regular School | No | Middle | 06 | 8 | 2020 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2431397 | 2431397 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000222 | 105 | Dole Middle | Regular School | No | Middle | 06 | 8 | 2020 | grade_10 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2431690 | 2431690 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000222 | 105 | Dole Middle | Regular School | No | Middle | 06 | 8 | 2020 | grade_11 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2431983 | 2431983 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000222 | 105 | Dole Middle | Regular School | No | Middle | 06 | 8 | 2020 | grade_12 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2432276 | 2432276 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000222 | 105 | Dole Middle | Regular School | No | Middle | 06 | 8 | 2020 | pre_kindergarten | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2432569 | 2432569 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000222 | 105 | Dole Middle | Regular School | No | Middle | 06 | 8 | 2020 | pk_12_total | 78.0 | 710.0 | 78 | 710 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2428468 | 2428468 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000221 | 106 | Farrington High | Regular School | No | High | 09 | 12 | 2020 | kindergarten | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2428761 | 2428761 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000221 | 106 | Farrington High | Regular School | No | High | 09 | 12 | 2020 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2429054 | 2429054 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000221 | 106 | Farrington High | Regular School | No | High | 09 | 12 | 2020 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2429347 | 2429347 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000221 | 106 | Farrington High | Regular School | No | High | 09 | 12 | 2020 | grade_3 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2429640 | 2429640 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000221 | 106 | Farrington High | Regular School | No | High | 09 | 12 | 2020 | grade_4 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2429933 | 2429933 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000221 | 106 | Farrington High | Regular School | No | High | 09 | 12 | 2020 | grade_5 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2430226 | 2430226 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000221 | 106 | Farrington High | Regular School | No | High | 09 | 12 | 2020 | grade_6 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2430519 | 2430519 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000221 | 106 | Farrington High | Regular School | No | High | 09 | 12 | 2020 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2430812 | 2430812 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000221 | 106 | Farrington High | Regular School | No | High | 09 | 12 | 2020 | grade_8 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2431105 | 2431105 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000221 | 106 | Farrington High | Regular School | No | High | 09 | 12 | 2020 | grade_9 | 676.0 | 676 |
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]);