enrollments
Data source: Big Local News · About: Big Local
2,040 rows where grade = "grade_9" and state = "HI" sorted by ccd_school_low_grade
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
280221 | 280221 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000092 | 464 | WAIMEA CANYON | Regular School | No | 2 | 06 | 8 | 2015 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
280228 | 280228 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000268 | 394 | WAIMEA MID-PCCS | charter | Regular School | Yes | 2 | 06 | 8 | 2015 | grade_9 | 0.0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
280232 | 280232 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000265 | 399 | WEST HI EXPLOR ACAD-PCS | charter | Regular School | Yes | 4 | 06 | 12 | 2015 | grade_9 | 36.0 | 36 | |||||||||||||||||||||||||||||||||||||||||||||||||||
280257 | 280257 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000298 | 567 | SEEQS | charter | Regular School | Yes | 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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2431111 | 2431111 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000211 | 116 | Kaimuki Middle | Regular School | No | Middle | 06 | 8 | 2020 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2431113 | 2431113 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000164 | 118 | Kalakaua Middle | Regular School | No | Middle | 06 | 8 | 2020 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2431124 | 2431124 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000192 | 139 | Niu Valley Middle | Regular School | No | Middle | 06 | 8 | 2020 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2431133 | 2431133 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000218 | 110 | Jarrett Middle | Regular School | No | Middle | 06 | 8 | 2020 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2431139 | 2431139 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000205 | 126 | Kawananakoa Middle | Regular School | No | Middle | 06 | 8 | 2020 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2431154 | 2431154 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000184 | 148 | Stevenson Middle | Regular School | No | Middle | 06 | 8 | 2020 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2431155 | 2431155 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000180 | 152 | Washington Middle | Regular School | No | Middle | 06 | 8 | 2020 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2431188 | 2431188 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000256 | 238 | Mililani Middle | Regular School | No | Middle | 06 | 8 | 2020 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2431193 | 2431193 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000143 | 230 | Wahiawa Middle | Regular School | No | Middle | 06 | 8 | 2020 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2431197 | 2431197 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000137 | 237 | Wheeler Middle | Regular School | No | Middle | 06 | 8 | 2020 | 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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2431210 | 2431210 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000259 | 291 | Kapolei Middle | Regular School | No | Middle | 06 | 8 | 2020 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2431282 | 2431282 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000053 | 385 | Waiakea Int | Regular School | No | Middle | 06 | 8 | 2020 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2431293 | 2431293 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000235 | 390 | Kealakehe Int | Regular School | No | Middle | 06 | 8 | 2020 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2431296 | 2431296 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000267 | 366 | Kohala Middle | Regular School | No | Middle | 06 | 8 | 2020 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2431299 | 2431299 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000252 | 376 | Konawaena Middle | Regular School | No | Middle | 06 | 8 | 2020 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2431306 | 2431306 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000040 | 370 | Keaau Middle | Regular School | No | Middle | 06 | 8 | 2020 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2431314 | 2431314 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000059 | 404 | Iao Int | Regular School | No | Middle | 06 | 8 | 2020 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2431316 | 2431316 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000233 | 420 | Kalama Int | Regular School | No | Middle | 06 | 8 | 2020 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2431322 | 2431322 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000238 | 430 | Lokelani Int | Regular School | No | Middle | 06 | 8 | 2020 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2431325 | 2431325 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000241 | 428 | Maui Waena Int | Regular School | No | Middle | 06 | 8 | 2020 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2431336 | 2431336 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000068 | 413 | Lahaina Int | Regular School | No | Middle | 06 | 8 | 2020 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2431346 | 2431346 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000266 | 448 | Kamakahelei Middle | Regular School | No | Middle | 06 | 8 | 2020 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2431349 | 2431349 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000255 | 447 | Kapaa Middle | Regular School | No | Middle | 06 | 8 | 2020 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2431356 | 2431356 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000092 | 464 | Waimea Canyon Middle | Regular School | No | Middle | 06 | 8 | 2020 | 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 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2431389 | 2431389 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000298 | 567 | SEEQS PCS | charter | Regular School | Yes | Middle | 06 | 8 | 2020 | grade_9 | 0.0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2431394 | 2431394 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000268 | 394 | Waimea Middle PCCS | charter | Regular School | Yes | Middle | 06 | 8 | 2020 | grade_9 | 0.0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2431395 | 2431395 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000265 | 399 | West Hawaii Explorations PCS | charter | Regular School | Yes | High | 06 | 12 | 2020 | grade_9 | 40.0 | 40 | |||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2455801 | 2455801 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000211 | 116 | Kaimuki Middle | Regular School | No | Middle | 06 | 8 | 2021 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2455803 | 2455803 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000164 | 118 | Kalakaua Middle | Regular School | No | Middle | 06 | 8 | 2021 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2455814 | 2455814 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000192 | 139 | Niu Valley Middle | Regular School | No | Middle | 06 | 8 | 2021 | 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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2455823 | 2455823 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000218 | 110 | Jarrett Middle | Regular School | No | Middle | 06 | 8 | 2021 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2455829 | 2455829 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000205 | 126 | Kawananakoa Middle | Regular School | No | Middle | 06 | 8 | 2021 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2455844 | 2455844 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000184 | 148 | Stevenson Middle | Regular School | No | Middle | 06 | 8 | 2021 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2455845 | 2455845 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000180 | 152 | Washington Middle | Regular School | No | Middle | 06 | 8 | 2021 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2455878 | 2455878 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000256 | 238 | Mililani Middle | Regular School | No | Middle | 06 | 8 | 2021 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2455883 | 2455883 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000143 | 230 | Wahiawa Middle | Regular School | No | Middle | 06 | 8 | 2021 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2455887 | 2455887 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000137 | 237 | Wheeler Middle | Regular School | No | Middle | 06 | 8 | 2021 | 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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2455894 | 2455894 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000306 | 297 | Honouliuli Middle | Regular School | No | Middle | 06 | 6 | 2021 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2455901 | 2455901 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000259 | 291 | Kapolei Middle | Regular School | No | Middle | 06 | 8 | 2021 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2455973 | 2455973 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000053 | 385 | Waiakea Int | Regular School | No | Middle | 06 | 8 | 2021 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2455984 | 2455984 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000235 | 390 | Kealakehe Int | Regular School | No | Middle | 06 | 8 | 2021 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2455987 | 2455987 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000267 | 366 | Kohala Middle | Regular School | No | Middle | 06 | 8 | 2021 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2455990 | 2455990 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000252 | 376 | Konawaena Middle | Regular School | No | Middle | 06 | 8 | 2021 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2455997 | 2455997 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000040 | 370 | Keaau Middle | Regular School | No | Middle | 06 | 8 | 2021 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2456005 | 2456005 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000059 | 404 | Iao Int | Regular School | No | Middle | 06 | 8 | 2021 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2456007 | 2456007 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000233 | 420 | Kalama Int | Regular School | No | Middle | 06 | 8 | 2021 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2456013 | 2456013 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000238 | 430 | Lokelani Int | Regular School | No | Middle | 06 | 8 | 2021 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2456016 | 2456016 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000241 | 428 | Maui Waena Int | Regular School | No | Middle | 06 | 8 | 2021 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2456027 | 2456027 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000068 | 413 | Lahaina Int | Regular School | No | Middle | 06 | 8 | 2021 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2456037 | 2456037 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000266 | 448 | Kamakahelei Middle | Regular School | No | Middle | 06 | 8 | 2021 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2456040 | 2456040 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000255 | 447 | Kapaa Middle | Regular School | No | Middle | 06 | 8 | 2021 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2456047 | 2456047 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000092 | 464 | Waimea Canyon Middle | Regular School | No | Middle | 06 | 8 | 2021 | 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 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2456080 | 2456080 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000298 | 567 | SEEQS PCS | charter | Regular School | Yes | Middle | 06 | 8 | 2021 | grade_9 | 0.0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2456085 | 2456085 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000268 | 394 | Waimea Middle PCCS | charter | Regular School | Yes | Middle | 06 | 8 | 2021 | grade_9 | 0.0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2456086 | 2456086 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000265 | 399 | West Hawaii Explorations PCS | charter | Regular School | Yes | High | 06 | 12 | 2021 | grade_9 | 51.0 | 51 | |||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2736772 | 2736772 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000211 | 116 | Kaimuki Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2736774 | 2736774 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000164 | 118 | Kalakaua Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2736785 | 2736785 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000192 | 139 | Niu Valley Middle | Regular School | No | Middle | 06 | 8 | 2019 | 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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2736794 | 2736794 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000218 | 110 | Jarrett Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2736800 | 2736800 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000205 | 126 | Kawananakoa Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2736815 | 2736815 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000184 | 148 | Stevenson Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2736816 | 2736816 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000180 | 152 | Washington Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2736849 | 2736849 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000256 | 238 | Mililani Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2736854 | 2736854 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000143 | 230 | Wahiawa Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2736858 | 2736858 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000137 | 237 | Wheeler Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2736871 | 2736871 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000259 | 291 | Kapolei Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2736943 | 2736943 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000053 | 385 | Waiakea Int | Regular School | No | Middle | 06 | 8 | 2019 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2736954 | 2736954 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000235 | 390 | Kealakehe Int | Regular School | No | Middle | 06 | 8 | 2019 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2736957 | 2736957 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000267 | 366 | Kohala Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2736960 | 2736960 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000252 | 376 | Konawaena Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2736967 | 2736967 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000040 | 370 | Keaau Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2736975 | 2736975 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000059 | 404 | Iao Int | Regular School | No | Middle | 06 | 8 | 2019 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2736977 | 2736977 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000233 | 420 | Kalama Int | Regular School | No | Middle | 06 | 8 | 2019 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2736983 | 2736983 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000238 | 430 | Lokelani Int | Regular School | No | Middle | 06 | 8 | 2019 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2736986 | 2736986 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000241 | 428 | Maui Waena Int | Regular School | No | Middle | 06 | 8 | 2019 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2736997 | 2736997 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000068 | 413 | Lahaina Int | Regular School | No | Middle | 06 | 8 | 2019 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2737007 | 2737007 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000266 | 448 | Kamakahelei Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2737010 | 2737010 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000255 | 447 | Kapaa Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2737017 | 2737017 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000092 | 464 | Waimea Canyon Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2737024 | 2737024 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000268 | 394 | Waimea Middle PCCS | charter | Regular School | Yes | Middle | 06 | 8 | 2019 | grade_9 | 0.0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2737028 | 2737028 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000265 | 399 | West Hawaii Explorations PCS | charter | Regular School | Yes | High | 06 | 12 | 2019 | grade_9 | 41.0 | 41 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2737055 | 2737055 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000298 | 567 | SEEQS PCS | charter | Regular School | Yes | 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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2781822 | 2781822 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000211 | 116 | Kaimuki Middle | Regular School | No | Middle | 06 | 8 | 2018 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2781824 | 2781824 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000164 | 118 | Kalakaua Middle | Regular School | No | Middle | 06 | 8 | 2018 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2781835 | 2781835 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000192 | 139 | Niu Valley Middle | Regular School | No | Middle | 06 | 8 | 2018 | 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]);