enrollments
Data source: Big Local News · About: Big Local
2,040 rows where grade = "grade_9" and state = "HI" sorted by school
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2781909 | 2781909 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000135 | 251 | Barbers Point Elem | Regular School | No | Elementary | PK | 5 | 2018 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
110086 | 110086 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000134 | 252 | CAMPBELL HI | Regular School | No | 3 | 09 | 12 | 2016 | grade_9 | 774.0 | 774 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
129089 | 129089 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000134 | 252 | CAMPBELL HI | Regular School | No | High | 09 | 12 | 2017 | grade_9 | 804.0 | 804 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
280065 | 280065 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000134 | 252 | CAMPBELL HI | Regular School | No | 3 | 09 | 12 | 2015 | grade_9 | 826.0 | 826 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
110129 | 110129 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000100 | 301 | CASTLE HI | Regular School | No | 3 | 09 | 12 | 2016 | grade_9 | 257.0 | 257 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
129132 | 129132 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000100 | 301 | CASTLE HI | Regular School | No | High | 09 | 12 | 2017 | grade_9 | 265.0 | 265 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
280107 | 280107 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000100 | 301 | CASTLE HI | Regular School | No | 3 | 09 | 12 | 2015 | grade_9 | 287.0 | 287 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
110018 | 110018 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000223 | 104 | CENTRAL MID | Regular School | No | 2 | 06 | 8 | 2016 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
129021 | 129021 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000223 | 104 | CENTRAL MID | Regular School | No | Middle | 06 | 8 | 2017 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
279997 | 279997 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000223 | 104 | CENTRAL MID | Regular School | No | 2 | 06 | 8 | 2015 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
110246 | 110246 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000262 | 396 | CONNECTIONS-PCS | charter | Regular School | Yes | 4 | KG | 12 | 2016 | grade_9 | 17.0 | 17 | |||||||||||||||||||||||||||||||||||||||||||||||||||
129249 | 129249 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000262 | 396 | CONNECTIONS-PCS | charter | Regular School | Yes | Other | KG | 12 | 2017 | grade_9 | 30.0 | 30 | |||||||||||||||||||||||||||||||||||||||||||||||||||
280229 | 280229 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000262 | 396 | CONNECTIONS-PCS | charter | Regular School | Yes | 4 | KG | 12 | 2015 | grade_9 | 26.0 | 26 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2431199 | 2431199 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000134 | 252 | Campbell High | Regular School | No | High | 09 | 12 | 2020 | grade_9 | 801.0 | 801 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2455889 | 2455889 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000134 | 252 | Campbell High | Regular School | No | High | 09 | 12 | 2021 | grade_9 | 808.0 | 808 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2736860 | 2736860 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000134 | 252 | Campbell High | Regular School | No | High | 09 | 12 | 2019 | grade_9 | 776.0 | 776 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2781910 | 2781910 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000134 | 252 | Campbell High | Regular School | No | High | 09 | 12 | 2018 | grade_9 | 790.0 | 790 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2431242 | 2431242 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000100 | 301 | Castle High | Regular School | No | High | 09 | 12 | 2020 | grade_9 | 252.0 | 252 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2455933 | 2455933 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000100 | 301 | Castle High | Regular School | No | High | 09 | 12 | 2021 | grade_9 | 269.0 | 269 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2736903 | 2736903 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000100 | 301 | Castle High | Regular School | No | High | 09 | 12 | 2019 | grade_9 | 239.0 | 239 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2781953 | 2781953 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000100 | 301 | Castle High | Regular School | No | High | 09 | 12 | 2018 | grade_9 | 280.0 | 280 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2736792 | 2736792 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000223 | 104 | Central Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2781842 | 2781842 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000223 | 104 | Central Middle | Regular School | No | Middle | 06 | 8 | 2018 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2431360 | 2431360 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000262 | 396 | Connections NCPCS | charter | Regular School | Yes | Other | KG | 12 | 2020 | grade_9 | 24.0 | 24 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2456051 | 2456051 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000262 | 396 | Connections NCPCS | charter | Regular School | Yes | Other | KG | 12 | 2021 | grade_9 | 30.0 | 30 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2737025 | 2737025 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000262 | 396 | Connections NCPCS | charter | Regular School | Yes | Other | KG | 12 | 2019 | grade_9 | 27.0 | 27 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2782070 | 2782070 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000262 | 396 | Connections NCPCS | charter | Regular School | Yes | Other | KG | 12 | 2018 | grade_9 | 30.0 | 30 | |||||||||||||||||||||||||||||||||||||||||||||||||||
110158 | 110158 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000027 | 351 | DE SILVA | Regular School | No | 1 | PK | 6 | 2016 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
129161 | 129161 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000027 | 351 | DE SILVA | Regular School | No | Elementary | PK | 6 | 2017 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
280136 | 280136 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000027 | 351 | DE SILVA | Regular School | No | 1 | PK | 6 | 2015 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
109991 | 109991 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000222 | 105 | DOLE MID | Regular School | No | 2 | 06 | 8 | 2016 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128994 | 128994 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000222 | 105 | DOLE MID | Regular School | No | Middle | 06 | 8 | 2017 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
279970 | 279970 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000222 | 105 | DOLE MID | Regular School | No | 2 | 06 | 8 | 2015 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2736765 | 2736765 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000222 | 105 | Dole Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2781815 | 2781815 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000222 | 105 | Dole Middle | Regular School | No | Middle | 06 | 8 | 2018 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2431361 | 2431361 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000305 | 568 | DreamHouse Ewa Beach | charter | Regular School | Yes | Middle | 06 | 6 | 2020 | grade_9 | 0.0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2456052 | 2456052 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000305 | 568 | DreamHouse Ewa Beach | charter | Regular School | Yes | Middle | 06 | 7 | 2021 | grade_9 | 0.0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
110247 | 110247 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000273 | 543 | EDUC LAB: A HAWAII NC-PCS | charter | Regular School | Yes | 4 | KG | 12 | 2016 | grade_9 | 50.0 | 50 | |||||||||||||||||||||||||||||||||||||||||||||||||||
129250 | 129250 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000273 | 543 | EDUC LAB: A HAWAII NC-PCS | charter | Regular School | Yes | Other | KG | 12 | 2017 | grade_9 | 55.0 | 55 | |||||||||||||||||||||||||||||||||||||||||||||||||||
280238 | 280238 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000273 | 543 | EDUC LAB: A HAWAII NC-PCS | charter | Regular School | Yes | 4 | KG | 12 | 2015 | grade_9 | 52.0 | 52 | |||||||||||||||||||||||||||||||||||||||||||||||||||
110230 | 110230 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000081 | 451 | ELEELE | Regular School | No | 1 | PK | 5 | 2016 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
129233 | 129233 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000081 | 451 | ELEELE | Regular School | No | Elementary | PK | 5 | 2017 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
280208 | 280208 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000081 | 451 | ELEELE | Regular School | No | 1 | PK | 5 | 2015 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
110145 | 110145 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000001 | 302 | ENCHANTED LAKE | Regular School | No | 1 | PK | 6 | 2016 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
129148 | 129148 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000001 | 302 | ENCHANTED LAKE | Regular School | No | Elementary | PK | 6 | 2017 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
280123 | 280123 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000001 | 302 | ENCHANTED LAKE | Regular School | No | 1 | PK | 6 | 2015 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
110087 | 110087 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000132 | 254 | EWA BEACH EL | Regular School | No | 1 | PK | 6 | 2016 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
129090 | 129090 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000132 | 254 | EWA BEACH EL | Regular School | No | Elementary | PK | 6 | 2017 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
280066 | 280066 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000132 | 254 | EWA BEACH EL | Regular School | No | 1 | PK | 6 | 2015 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
110088 | 110088 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000133 | 253 | EWA EL | Regular School | No | 1 | PK | 6 | 2016 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
129091 | 129091 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000133 | 253 | EWA EL | Regular School | No | Elementary | PK | 6 | 2017 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
280067 | 280067 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000133 | 253 | EWA EL | Regular School | No | 1 | PK | 6 | 2015 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
110089 | 110089 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000296 | 296 | EWA MAKAI MID | Regular School | No | 2 | 07 | 8 | 2016 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
129092 | 129092 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000296 | 296 | EWA MAKAI MID | Regular School | No | Middle | 07 | 8 | 2017 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
280068 | 280068 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000296 | 296 | EWA MAKAI MID | Regular School | No | 2 | 07 | 8 | 2015 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2431343 | 2431343 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000081 | 451 | Eleele Elem | Regular School | No | Elementary | PK | 5 | 2020 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2456034 | 2456034 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000081 | 451 | Eleele Elem | Regular School | No | Elementary | PK | 5 | 2021 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2737004 | 2737004 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000081 | 451 | Eleele Elem | Regular School | No | Elementary | PK | 5 | 2019 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2782054 | 2782054 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000081 | 451 | Eleele Elem | Regular School | No | Elementary | PK | 5 | 2018 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2431258 | 2431258 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000001 | 302 | Enchanted Lake Elem | Regular School | No | Elementary | PK | 6 | 2020 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2455949 | 2455949 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000001 | 302 | Enchanted Lake Elem | Regular School | No | Elementary | PK | 6 | 2021 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2736919 | 2736919 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000001 | 302 | Enchanted Lake Elem | Regular School | No | Elementary | PK | 6 | 2019 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2781969 | 2781969 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000001 | 302 | Enchanted Lake Elem | Regular School | No | Elementary | PK | 6 | 2018 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2431200 | 2431200 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000132 | 254 | Ewa Beach Elem | Regular School | No | Elementary | PK | 6 | 2020 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2455890 | 2455890 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000132 | 254 | Ewa Beach Elem | Regular School | No | Elementary | PK | 5 | 2021 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2736861 | 2736861 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000132 | 254 | Ewa Beach Elem | Regular School | No | Elementary | PK | 6 | 2019 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2781911 | 2781911 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000132 | 254 | Ewa Beach Elem | Regular School | No | Elementary | PK | 6 | 2018 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2431201 | 2431201 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000133 | 253 | Ewa Elem | Regular School | No | Elementary | PK | 6 | 2020 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2455891 | 2455891 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000133 | 253 | Ewa Elem | Regular School | No | Elementary | PK | 5 | 2021 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2736862 | 2736862 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000133 | 253 | Ewa Elem | Regular School | No | Elementary | PK | 6 | 2019 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2781912 | 2781912 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000133 | 253 | Ewa Elem | Regular School | No | Elementary | PK | 6 | 2018 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2431202 | 2431202 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000296 | 296 | Ewa Makai Middle | Regular School | No | Middle | 06 | 8 | 2020 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2455892 | 2455892 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000296 | 296 | Ewa Makai Middle | Regular School | No | Middle | 06 | 8 | 2021 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2736863 | 2736863 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000296 | 296 | Ewa Makai Middle | Regular School | No | Middle | 07 | 8 | 2019 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2781913 | 2781913 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000296 | 296 | Ewa Makai Middle | Regular School | No | Middle | 07 | 8 | 2018 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
109992 | 109992 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000221 | 106 | FARRINGTON HI | Regular School | No | 3 | 09 | 12 | 2016 | grade_9 | 607.0 | 607 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128995 | 128995 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000221 | 106 | FARRINGTON HI | Regular School | No | High | 09 | 12 | 2017 | grade_9 | 645.0 | 645 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
279971 | 279971 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000221 | 106 | FARRINGTON HI | Regular School | No | 3 | 09 | 12 | 2015 | grade_9 | 647.0 | 647 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
109993 | 109993 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000220 | 107 | FERN | Regular School | No | 1 | PK | 5 | 2016 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128996 | 128996 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000220 | 107 | FERN | Regular School | No | Elementary | PK | 5 | 2017 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
279972 | 279972 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000220 | 107 | FERN | Regular School | No | 1 | PK | 5 | 2015 | grade_9 | 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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2736766 | 2736766 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000221 | 106 | Farrington High | Regular School | No | High | 09 | 12 | 2019 | grade_9 | 652.0 | 652 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2781816 | 2781816 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000221 | 106 | Farrington High | Regular School | No | High | 09 | 12 | 2018 | grade_9 | 585.0 | 585 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2431106 | 2431106 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000220 | 107 | Fern Elem | Regular School | No | Elementary | PK | 5 | 2020 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2455796 | 2455796 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000220 | 107 | Fern Elem | Regular School | No | Elementary | PK | 5 | 2021 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2736767 | 2736767 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000220 | 107 | Fern Elem | Regular School | No | Elementary | PK | 5 | 2019 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2781817 | 2781817 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000220 | 107 | Fern Elem | Regular School | No | Elementary | PK | 5 | 2018 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
110159 | 110159 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000028 | 352 | HAAHEO | Regular School | No | 1 | PK | 6 | 2016 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
129162 | 129162 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000028 | 352 | HAAHEO | Regular School | No | Elementary | PK | 6 | 2017 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
280137 | 280137 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000028 | 352 | HAAHEO | Regular School | No | 1 | PK | 6 | 2015 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
109994 | 109994 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000219 | 108 | HAHAIONE | Regular School | No | 1 | PK | 5 | 2016 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128997 | 128997 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000219 | 108 | HAHAIONE | Regular School | No | Elementary | PK | 5 | 2017 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
279973 | 279973 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000219 | 108 | HAHAIONE | Regular School | No | 1 | PK | 5 | 2015 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
110200 | 110200 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000057 | 401 | HAIKU | Regular School | No | 1 | PK | 5 | 2016 | grade_9 | 0.0 | 0 |
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]);