enrollments
Data source: Big Local News · About: Big Local
2,040 rows where grade = "grade_1" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
277909 | 277909 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000092 | 464 | WAIMEA CANYON | Regular School | No | 2 | 06 | 8 | 2015 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
277916 | 277916 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000268 | 394 | WAIMEA MID-PCCS | charter | Regular School | Yes | 2 | 06 | 8 | 2015 | grade_1 | 0.0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
277920 | 277920 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000265 | 399 | WEST HI EXPLOR ACAD-PCS | charter | Regular School | Yes | 4 | 06 | 12 | 2015 | grade_1 | 0.0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
277945 | 277945 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000298 | 567 | SEEQS | charter | Regular School | Yes | 2 | 06 | 8 | 2015 | grade_1 | 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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2428767 | 2428767 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000211 | 116 | Kaimuki Middle | Regular School | No | Middle | 06 | 8 | 2020 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2428769 | 2428769 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000164 | 118 | Kalakaua Middle | Regular School | No | Middle | 06 | 8 | 2020 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2428780 | 2428780 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000192 | 139 | Niu Valley Middle | Regular School | No | Middle | 06 | 8 | 2020 | grade_1 | 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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2428789 | 2428789 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000218 | 110 | Jarrett Middle | Regular School | No | Middle | 06 | 8 | 2020 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2428795 | 2428795 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000205 | 126 | Kawananakoa Middle | Regular School | No | Middle | 06 | 8 | 2020 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2428810 | 2428810 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000184 | 148 | Stevenson Middle | Regular School | No | Middle | 06 | 8 | 2020 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2428811 | 2428811 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000180 | 152 | Washington Middle | Regular School | No | Middle | 06 | 8 | 2020 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2428844 | 2428844 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000256 | 238 | Mililani Middle | Regular School | No | Middle | 06 | 8 | 2020 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2428849 | 2428849 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000143 | 230 | Wahiawa Middle | Regular School | No | Middle | 06 | 8 | 2020 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2428853 | 2428853 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000137 | 237 | Wheeler Middle | Regular School | No | Middle | 06 | 8 | 2020 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2428858 | 2428858 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000296 | 296 | Ewa Makai Middle | Regular School | No | Middle | 06 | 8 | 2020 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2428866 | 2428866 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000259 | 291 | Kapolei Middle | Regular School | No | Middle | 06 | 8 | 2020 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2428938 | 2428938 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000053 | 385 | Waiakea Int | Regular School | No | Middle | 06 | 8 | 2020 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2428949 | 2428949 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000235 | 390 | Kealakehe Int | Regular School | No | Middle | 06 | 8 | 2020 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2428952 | 2428952 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000267 | 366 | Kohala Middle | Regular School | No | Middle | 06 | 8 | 2020 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2428955 | 2428955 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000252 | 376 | Konawaena Middle | Regular School | No | Middle | 06 | 8 | 2020 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2428962 | 2428962 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000040 | 370 | Keaau Middle | Regular School | No | Middle | 06 | 8 | 2020 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2428970 | 2428970 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000059 | 404 | Iao Int | Regular School | No | Middle | 06 | 8 | 2020 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2428972 | 2428972 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000233 | 420 | Kalama Int | Regular School | No | Middle | 06 | 8 | 2020 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2428978 | 2428978 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000238 | 430 | Lokelani Int | Regular School | No | Middle | 06 | 8 | 2020 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2428981 | 2428981 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000241 | 428 | Maui Waena Int | Regular School | No | Middle | 06 | 8 | 2020 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2428992 | 2428992 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000068 | 413 | Lahaina Int | Regular School | No | Middle | 06 | 8 | 2020 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2429002 | 2429002 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000266 | 448 | Kamakahelei Middle | Regular School | No | Middle | 06 | 8 | 2020 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2429005 | 2429005 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000255 | 447 | Kapaa Middle | Regular School | No | Middle | 06 | 8 | 2020 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2429012 | 2429012 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000092 | 464 | Waimea Canyon Middle | Regular School | No | Middle | 06 | 8 | 2020 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2429017 | 2429017 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000305 | 568 | DreamHouse Ewa Beach | charter | Regular School | Yes | Middle | 06 | 6 | 2020 | grade_1 | 0.0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2429045 | 2429045 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000298 | 567 | SEEQS PCS | charter | Regular School | Yes | Middle | 06 | 8 | 2020 | grade_1 | 0.0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2429050 | 2429050 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000268 | 394 | Waimea Middle PCCS | charter | Regular School | Yes | Middle | 06 | 8 | 2020 | grade_1 | 0.0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2429051 | 2429051 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000265 | 399 | West Hawaii Explorations PCS | charter | Regular School | Yes | High | 06 | 12 | 2020 | grade_1 | 0.0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2453442 | 2453442 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000222 | 105 | Dole Middle | Regular School | No | Middle | 06 | 8 | 2021 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2453449 | 2453449 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000211 | 116 | Kaimuki Middle | Regular School | No | Middle | 06 | 8 | 2021 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2453451 | 2453451 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000164 | 118 | Kalakaua Middle | Regular School | No | Middle | 06 | 8 | 2021 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2453462 | 2453462 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000192 | 139 | Niu Valley Middle | Regular School | No | Middle | 06 | 8 | 2021 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2453469 | 2453469 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000223 | 104 | Central Middle | Regular School | No | Middle | 06 | 8 | 2021 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2453471 | 2453471 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000218 | 110 | Jarrett Middle | Regular School | No | Middle | 06 | 8 | 2021 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2453477 | 2453477 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000205 | 126 | Kawananakoa Middle | Regular School | No | Middle | 06 | 8 | 2021 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2453492 | 2453492 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000184 | 148 | Stevenson Middle | Regular School | No | Middle | 06 | 8 | 2021 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2453493 | 2453493 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000180 | 152 | Washington Middle | Regular School | No | Middle | 06 | 8 | 2021 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2453526 | 2453526 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000256 | 238 | Mililani Middle | Regular School | No | Middle | 06 | 8 | 2021 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2453531 | 2453531 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000143 | 230 | Wahiawa Middle | Regular School | No | Middle | 06 | 8 | 2021 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2453535 | 2453535 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000137 | 237 | Wheeler Middle | Regular School | No | Middle | 06 | 8 | 2021 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2453540 | 2453540 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000296 | 296 | Ewa Makai Middle | Regular School | No | Middle | 06 | 8 | 2021 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2453542 | 2453542 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000306 | 297 | Honouliuli Middle | Regular School | No | Middle | 06 | 6 | 2021 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2453549 | 2453549 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000259 | 291 | Kapolei Middle | Regular School | No | Middle | 06 | 8 | 2021 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2453621 | 2453621 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000053 | 385 | Waiakea Int | Regular School | No | Middle | 06 | 8 | 2021 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2453632 | 2453632 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000235 | 390 | Kealakehe Int | Regular School | No | Middle | 06 | 8 | 2021 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2453635 | 2453635 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000267 | 366 | Kohala Middle | Regular School | No | Middle | 06 | 8 | 2021 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2453638 | 2453638 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000252 | 376 | Konawaena Middle | Regular School | No | Middle | 06 | 8 | 2021 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2453645 | 2453645 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000040 | 370 | Keaau Middle | Regular School | No | Middle | 06 | 8 | 2021 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2453653 | 2453653 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000059 | 404 | Iao Int | Regular School | No | Middle | 06 | 8 | 2021 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2453655 | 2453655 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000233 | 420 | Kalama Int | Regular School | No | Middle | 06 | 8 | 2021 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2453661 | 2453661 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000238 | 430 | Lokelani Int | Regular School | No | Middle | 06 | 8 | 2021 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2453664 | 2453664 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000241 | 428 | Maui Waena Int | Regular School | No | Middle | 06 | 8 | 2021 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2453675 | 2453675 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000068 | 413 | Lahaina Int | Regular School | No | Middle | 06 | 8 | 2021 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2453685 | 2453685 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000266 | 448 | Kamakahelei Middle | Regular School | No | Middle | 06 | 8 | 2021 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2453688 | 2453688 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000255 | 447 | Kapaa Middle | Regular School | No | Middle | 06 | 8 | 2021 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2453695 | 2453695 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000092 | 464 | Waimea Canyon Middle | Regular School | No | Middle | 06 | 8 | 2021 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2453700 | 2453700 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000305 | 568 | DreamHouse Ewa Beach | charter | Regular School | Yes | Middle | 06 | 7 | 2021 | grade_1 | 0.0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2453728 | 2453728 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000298 | 567 | SEEQS PCS | charter | Regular School | Yes | Middle | 06 | 8 | 2021 | grade_1 | 0.0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2453733 | 2453733 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000268 | 394 | Waimea Middle PCCS | charter | Regular School | Yes | Middle | 06 | 8 | 2021 | grade_1 | 0.0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2453734 | 2453734 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000265 | 399 | West Hawaii Explorations PCS | charter | Regular School | Yes | High | 06 | 12 | 2021 | grade_1 | 0.0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2734429 | 2734429 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000222 | 105 | Dole Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734436 | 2734436 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000211 | 116 | Kaimuki Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734438 | 2734438 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000164 | 118 | Kalakaua Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734449 | 2734449 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000192 | 139 | Niu Valley Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734456 | 2734456 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000223 | 104 | Central Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734458 | 2734458 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000218 | 110 | Jarrett Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734464 | 2734464 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000205 | 126 | Kawananakoa Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734479 | 2734479 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000184 | 148 | Stevenson Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734480 | 2734480 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000180 | 152 | Washington Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734513 | 2734513 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000256 | 238 | Mililani Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734518 | 2734518 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000143 | 230 | Wahiawa Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734522 | 2734522 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000137 | 237 | Wheeler Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734535 | 2734535 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000259 | 291 | Kapolei Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734607 | 2734607 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000053 | 385 | Waiakea Int | Regular School | No | Middle | 06 | 8 | 2019 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734618 | 2734618 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000235 | 390 | Kealakehe Int | Regular School | No | Middle | 06 | 8 | 2019 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734621 | 2734621 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000267 | 366 | Kohala Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734624 | 2734624 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000252 | 376 | Konawaena Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734631 | 2734631 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000040 | 370 | Keaau Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734639 | 2734639 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000059 | 404 | Iao Int | Regular School | No | Middle | 06 | 8 | 2019 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734641 | 2734641 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000233 | 420 | Kalama Int | Regular School | No | Middle | 06 | 8 | 2019 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734647 | 2734647 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000238 | 430 | Lokelani Int | Regular School | No | Middle | 06 | 8 | 2019 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734650 | 2734650 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000241 | 428 | Maui Waena Int | Regular School | No | Middle | 06 | 8 | 2019 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734661 | 2734661 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000068 | 413 | Lahaina Int | Regular School | No | Middle | 06 | 8 | 2019 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734671 | 2734671 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000266 | 448 | Kamakahelei Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734674 | 2734674 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000255 | 447 | Kapaa Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734681 | 2734681 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000092 | 464 | Waimea Canyon Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734688 | 2734688 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000268 | 394 | Waimea Middle PCCS | charter | Regular School | Yes | Middle | 06 | 8 | 2019 | grade_1 | 0.0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2734692 | 2734692 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000265 | 399 | West Hawaii Explorations PCS | charter | Regular School | Yes | High | 06 | 12 | 2019 | grade_1 | 0.0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2734719 | 2734719 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000298 | 567 | SEEQS PCS | charter | Regular School | Yes | Middle | 06 | 8 | 2019 | grade_1 | 0.0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2779479 | 2779479 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000222 | 105 | Dole Middle | Regular School | No | Middle | 06 | 8 | 2018 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2779486 | 2779486 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000211 | 116 | Kaimuki Middle | Regular School | No | Middle | 06 | 8 | 2018 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2779488 | 2779488 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000164 | 118 | Kalakaua Middle | Regular School | No | Middle | 06 | 8 | 2018 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2779499 | 2779499 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000192 | 139 | Niu Valley Middle | Regular School | No | Middle | 06 | 8 | 2018 | grade_1 | 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]);