enrollments
Data source: Big Local News · About: Big Local
2,040 rows where grade = "grade_4" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
278776 | 278776 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000092 | 464 | WAIMEA CANYON | Regular School | No | 2 | 06 | 8 | 2015 | grade_4 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
278783 | 278783 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000268 | 394 | WAIMEA MID-PCCS | charter | Regular School | Yes | 2 | 06 | 8 | 2015 | grade_4 | 0.0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
278787 | 278787 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000265 | 399 | WEST HI EXPLOR ACAD-PCS | charter | Regular School | Yes | 4 | 06 | 12 | 2015 | grade_4 | 0.0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
278812 | 278812 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000298 | 567 | SEEQS | charter | Regular School | Yes | 2 | 06 | 8 | 2015 | grade_4 | 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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2429646 | 2429646 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000211 | 116 | Kaimuki Middle | Regular School | No | Middle | 06 | 8 | 2020 | grade_4 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2429648 | 2429648 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000164 | 118 | Kalakaua Middle | Regular School | No | Middle | 06 | 8 | 2020 | grade_4 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2429659 | 2429659 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000192 | 139 | Niu Valley Middle | Regular School | No | Middle | 06 | 8 | 2020 | grade_4 | 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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2429668 | 2429668 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000218 | 110 | Jarrett Middle | Regular School | No | Middle | 06 | 8 | 2020 | grade_4 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2429674 | 2429674 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000205 | 126 | Kawananakoa Middle | Regular School | No | Middle | 06 | 8 | 2020 | grade_4 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2429689 | 2429689 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000184 | 148 | Stevenson Middle | Regular School | No | Middle | 06 | 8 | 2020 | grade_4 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2429690 | 2429690 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000180 | 152 | Washington Middle | Regular School | No | Middle | 06 | 8 | 2020 | grade_4 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2429723 | 2429723 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000256 | 238 | Mililani Middle | Regular School | No | Middle | 06 | 8 | 2020 | grade_4 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2429728 | 2429728 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000143 | 230 | Wahiawa Middle | Regular School | No | Middle | 06 | 8 | 2020 | grade_4 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2429732 | 2429732 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000137 | 237 | Wheeler Middle | Regular School | No | Middle | 06 | 8 | 2020 | grade_4 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2429737 | 2429737 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000296 | 296 | Ewa Makai Middle | Regular School | No | Middle | 06 | 8 | 2020 | grade_4 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2429745 | 2429745 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000259 | 291 | Kapolei Middle | Regular School | No | Middle | 06 | 8 | 2020 | grade_4 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2429817 | 2429817 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000053 | 385 | Waiakea Int | Regular School | No | Middle | 06 | 8 | 2020 | grade_4 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2429828 | 2429828 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000235 | 390 | Kealakehe Int | Regular School | No | Middle | 06 | 8 | 2020 | grade_4 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2429831 | 2429831 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000267 | 366 | Kohala Middle | Regular School | No | Middle | 06 | 8 | 2020 | grade_4 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2429834 | 2429834 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000252 | 376 | Konawaena Middle | Regular School | No | Middle | 06 | 8 | 2020 | grade_4 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2429841 | 2429841 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000040 | 370 | Keaau Middle | Regular School | No | Middle | 06 | 8 | 2020 | grade_4 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2429849 | 2429849 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000059 | 404 | Iao Int | Regular School | No | Middle | 06 | 8 | 2020 | grade_4 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2429851 | 2429851 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000233 | 420 | Kalama Int | Regular School | No | Middle | 06 | 8 | 2020 | grade_4 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2429857 | 2429857 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000238 | 430 | Lokelani Int | Regular School | No | Middle | 06 | 8 | 2020 | grade_4 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2429860 | 2429860 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000241 | 428 | Maui Waena Int | Regular School | No | Middle | 06 | 8 | 2020 | grade_4 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2429871 | 2429871 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000068 | 413 | Lahaina Int | Regular School | No | Middle | 06 | 8 | 2020 | grade_4 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2429881 | 2429881 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000266 | 448 | Kamakahelei Middle | Regular School | No | Middle | 06 | 8 | 2020 | grade_4 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2429884 | 2429884 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000255 | 447 | Kapaa Middle | Regular School | No | Middle | 06 | 8 | 2020 | grade_4 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2429891 | 2429891 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000092 | 464 | Waimea Canyon Middle | Regular School | No | Middle | 06 | 8 | 2020 | grade_4 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2429896 | 2429896 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000305 | 568 | DreamHouse Ewa Beach | charter | Regular School | Yes | Middle | 06 | 6 | 2020 | grade_4 | 0.0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2429924 | 2429924 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000298 | 567 | SEEQS PCS | charter | Regular School | Yes | Middle | 06 | 8 | 2020 | grade_4 | 0.0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2429929 | 2429929 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000268 | 394 | Waimea Middle PCCS | charter | Regular School | Yes | Middle | 06 | 8 | 2020 | grade_4 | 0.0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2429930 | 2429930 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000265 | 399 | West Hawaii Explorations PCS | charter | Regular School | Yes | High | 06 | 12 | 2020 | grade_4 | 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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2454331 | 2454331 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000211 | 116 | Kaimuki Middle | Regular School | No | Middle | 06 | 8 | 2021 | grade_4 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2454333 | 2454333 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000164 | 118 | Kalakaua Middle | Regular School | No | Middle | 06 | 8 | 2021 | grade_4 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2454344 | 2454344 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000192 | 139 | Niu Valley Middle | Regular School | No | Middle | 06 | 8 | 2021 | grade_4 | 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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2454353 | 2454353 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000218 | 110 | Jarrett Middle | Regular School | No | Middle | 06 | 8 | 2021 | grade_4 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2454359 | 2454359 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000205 | 126 | Kawananakoa Middle | Regular School | No | Middle | 06 | 8 | 2021 | grade_4 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2454374 | 2454374 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000184 | 148 | Stevenson Middle | Regular School | No | Middle | 06 | 8 | 2021 | grade_4 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2454375 | 2454375 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000180 | 152 | Washington Middle | Regular School | No | Middle | 06 | 8 | 2021 | grade_4 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2454408 | 2454408 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000256 | 238 | Mililani Middle | Regular School | No | Middle | 06 | 8 | 2021 | grade_4 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2454413 | 2454413 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000143 | 230 | Wahiawa Middle | Regular School | No | Middle | 06 | 8 | 2021 | grade_4 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2454417 | 2454417 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000137 | 237 | Wheeler Middle | Regular School | No | Middle | 06 | 8 | 2021 | grade_4 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2454422 | 2454422 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000296 | 296 | Ewa Makai Middle | Regular School | No | Middle | 06 | 8 | 2021 | grade_4 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2454424 | 2454424 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000306 | 297 | Honouliuli Middle | Regular School | No | Middle | 06 | 6 | 2021 | grade_4 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2454431 | 2454431 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000259 | 291 | Kapolei Middle | Regular School | No | Middle | 06 | 8 | 2021 | grade_4 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2454503 | 2454503 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000053 | 385 | Waiakea Int | Regular School | No | Middle | 06 | 8 | 2021 | grade_4 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2454514 | 2454514 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000235 | 390 | Kealakehe Int | Regular School | No | Middle | 06 | 8 | 2021 | grade_4 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2454517 | 2454517 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000267 | 366 | Kohala Middle | Regular School | No | Middle | 06 | 8 | 2021 | grade_4 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2454520 | 2454520 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000252 | 376 | Konawaena Middle | Regular School | No | Middle | 06 | 8 | 2021 | grade_4 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2454527 | 2454527 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000040 | 370 | Keaau Middle | Regular School | No | Middle | 06 | 8 | 2021 | grade_4 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2454535 | 2454535 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000059 | 404 | Iao Int | Regular School | No | Middle | 06 | 8 | 2021 | grade_4 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2454537 | 2454537 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000233 | 420 | Kalama Int | Regular School | No | Middle | 06 | 8 | 2021 | grade_4 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2454543 | 2454543 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000238 | 430 | Lokelani Int | Regular School | No | Middle | 06 | 8 | 2021 | grade_4 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2454546 | 2454546 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000241 | 428 | Maui Waena Int | Regular School | No | Middle | 06 | 8 | 2021 | grade_4 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2454557 | 2454557 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000068 | 413 | Lahaina Int | Regular School | No | Middle | 06 | 8 | 2021 | grade_4 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2454567 | 2454567 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000266 | 448 | Kamakahelei Middle | Regular School | No | Middle | 06 | 8 | 2021 | grade_4 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2454570 | 2454570 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000255 | 447 | Kapaa Middle | Regular School | No | Middle | 06 | 8 | 2021 | grade_4 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2454577 | 2454577 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000092 | 464 | Waimea Canyon Middle | Regular School | No | Middle | 06 | 8 | 2021 | grade_4 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2454582 | 2454582 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000305 | 568 | DreamHouse Ewa Beach | charter | Regular School | Yes | Middle | 06 | 7 | 2021 | grade_4 | 0.0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2454610 | 2454610 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000298 | 567 | SEEQS PCS | charter | Regular School | Yes | Middle | 06 | 8 | 2021 | grade_4 | 0.0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2454615 | 2454615 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000268 | 394 | Waimea Middle PCCS | charter | Regular School | Yes | Middle | 06 | 8 | 2021 | grade_4 | 0.0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2454616 | 2454616 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000265 | 399 | West Hawaii Explorations PCS | charter | Regular School | Yes | High | 06 | 12 | 2021 | grade_4 | 0.0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2735305 | 2735305 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000222 | 105 | Dole Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_4 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2735312 | 2735312 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000211 | 116 | Kaimuki Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_4 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2735314 | 2735314 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000164 | 118 | Kalakaua Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_4 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2735325 | 2735325 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000192 | 139 | Niu Valley Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_4 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2735332 | 2735332 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000223 | 104 | Central Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_4 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2735334 | 2735334 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000218 | 110 | Jarrett Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_4 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2735340 | 2735340 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000205 | 126 | Kawananakoa Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_4 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2735355 | 2735355 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000184 | 148 | Stevenson Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_4 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2735356 | 2735356 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000180 | 152 | Washington Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_4 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2735389 | 2735389 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000256 | 238 | Mililani Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_4 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2735394 | 2735394 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000143 | 230 | Wahiawa Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_4 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2735398 | 2735398 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000137 | 237 | Wheeler Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_4 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2735411 | 2735411 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000259 | 291 | Kapolei Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_4 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2735483 | 2735483 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000053 | 385 | Waiakea Int | Regular School | No | Middle | 06 | 8 | 2019 | grade_4 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2735494 | 2735494 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000235 | 390 | Kealakehe Int | Regular School | No | Middle | 06 | 8 | 2019 | grade_4 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2735497 | 2735497 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000267 | 366 | Kohala Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_4 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2735500 | 2735500 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000252 | 376 | Konawaena Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_4 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2735507 | 2735507 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000040 | 370 | Keaau Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_4 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2735515 | 2735515 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000059 | 404 | Iao Int | Regular School | No | Middle | 06 | 8 | 2019 | grade_4 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2735517 | 2735517 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000233 | 420 | Kalama Int | Regular School | No | Middle | 06 | 8 | 2019 | grade_4 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2735523 | 2735523 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000238 | 430 | Lokelani Int | Regular School | No | Middle | 06 | 8 | 2019 | grade_4 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2735526 | 2735526 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000241 | 428 | Maui Waena Int | Regular School | No | Middle | 06 | 8 | 2019 | grade_4 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2735537 | 2735537 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000068 | 413 | Lahaina Int | Regular School | No | Middle | 06 | 8 | 2019 | grade_4 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2735547 | 2735547 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000266 | 448 | Kamakahelei Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_4 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2735550 | 2735550 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000255 | 447 | Kapaa Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_4 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2735557 | 2735557 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000092 | 464 | Waimea Canyon Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_4 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2735564 | 2735564 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000268 | 394 | Waimea Middle PCCS | charter | Regular School | Yes | Middle | 06 | 8 | 2019 | grade_4 | 0.0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2735568 | 2735568 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000265 | 399 | West Hawaii Explorations PCS | charter | Regular School | Yes | High | 06 | 12 | 2019 | grade_4 | 0.0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2735595 | 2735595 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000298 | 567 | SEEQS PCS | charter | Regular School | Yes | Middle | 06 | 8 | 2019 | grade_4 | 0.0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2780355 | 2780355 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000222 | 105 | Dole Middle | Regular School | No | Middle | 06 | 8 | 2018 | grade_4 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2780362 | 2780362 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000211 | 116 | Kaimuki Middle | Regular School | No | Middle | 06 | 8 | 2018 | grade_4 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2780364 | 2780364 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000164 | 118 | Kalakaua Middle | Regular School | No | Middle | 06 | 8 | 2018 | grade_4 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2780375 | 2780375 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000192 | 139 | Niu Valley Middle | Regular School | No | Middle | 06 | 8 | 2018 | grade_4 | 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]);