enrollments
Data source: Big Local News · About: Big Local
2,040 rows where grade = "grade_6" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
279354 | 279354 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000092 | 464 | WAIMEA CANYON | Regular School | No | 2 | 06 | 8 | 2015 | grade_6 | 115.0 | 115 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
279361 | 279361 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000268 | 394 | WAIMEA MID-PCCS | charter | Regular School | Yes | 2 | 06 | 8 | 2015 | grade_6 | 88.0 | 88 | |||||||||||||||||||||||||||||||||||||||||||||||||||
279365 | 279365 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000265 | 399 | WEST HI EXPLOR ACAD-PCS | charter | Regular School | Yes | 4 | 06 | 12 | 2015 | grade_6 | 30.0 | 30 | |||||||||||||||||||||||||||||||||||||||||||||||||||
279390 | 279390 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000298 | 567 | SEEQS | charter | Regular School | Yes | 2 | 06 | 8 | 2015 | grade_6 | 53.0 | 53 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2430225 | 2430225 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000222 | 105 | Dole Middle | Regular School | No | Middle | 06 | 8 | 2020 | grade_6 | 201.0 | 201 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2430232 | 2430232 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000211 | 116 | Kaimuki Middle | Regular School | No | Middle | 06 | 8 | 2020 | grade_6 | 344.0 | 344 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2430234 | 2430234 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000164 | 118 | Kalakaua Middle | Regular School | No | Middle | 06 | 8 | 2020 | grade_6 | 370.0 | 370 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2430245 | 2430245 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000192 | 139 | Niu Valley Middle | Regular School | No | Middle | 06 | 8 | 2020 | grade_6 | 258.0 | 258 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2430252 | 2430252 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000223 | 104 | Central Middle | Regular School | No | Middle | 06 | 8 | 2020 | grade_6 | 115.0 | 115 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2430254 | 2430254 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000218 | 110 | Jarrett Middle | Regular School | No | Middle | 06 | 8 | 2020 | grade_6 | 78.0 | 78 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2430260 | 2430260 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000205 | 126 | Kawananakoa Middle | Regular School | No | Middle | 06 | 8 | 2020 | grade_6 | 242.0 | 242 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2430275 | 2430275 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000184 | 148 | Stevenson Middle | Regular School | No | Middle | 06 | 8 | 2020 | grade_6 | 241.0 | 241 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2430276 | 2430276 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000180 | 152 | Washington Middle | Regular School | No | Middle | 06 | 8 | 2020 | grade_6 | 248.0 | 248 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2430309 | 2430309 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000256 | 238 | Mililani Middle | Regular School | No | Middle | 06 | 8 | 2020 | grade_6 | 546.0 | 546 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2430314 | 2430314 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000143 | 230 | Wahiawa Middle | Regular School | No | Middle | 06 | 8 | 2020 | grade_6 | 213.0 | 213 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2430318 | 2430318 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000137 | 237 | Wheeler Middle | Regular School | No | Middle | 06 | 8 | 2020 | grade_6 | 261.0 | 261 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2430323 | 2430323 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000296 | 296 | Ewa Makai Middle | Regular School | No | Middle | 06 | 8 | 2020 | grade_6 | 433.0 | 433 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2430331 | 2430331 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000259 | 291 | Kapolei Middle | Regular School | No | Middle | 06 | 8 | 2020 | grade_6 | 450.0 | 450 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2430403 | 2430403 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000053 | 385 | Waiakea Int | Regular School | No | Middle | 06 | 8 | 2020 | grade_6 | 246.0 | 246 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2430414 | 2430414 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000235 | 390 | Kealakehe Int | Regular School | No | Middle | 06 | 8 | 2020 | grade_6 | 260.0 | 260 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2430417 | 2430417 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000267 | 366 | Kohala Middle | Regular School | No | Middle | 06 | 8 | 2020 | grade_6 | 50.0 | 50 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2430420 | 2430420 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000252 | 376 | Konawaena Middle | Regular School | No | Middle | 06 | 8 | 2020 | grade_6 | 234.0 | 234 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2430427 | 2430427 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000040 | 370 | Keaau Middle | Regular School | No | Middle | 06 | 8 | 2020 | grade_6 | 214.0 | 214 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2430435 | 2430435 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000059 | 404 | Iao Int | Regular School | No | Middle | 06 | 8 | 2020 | grade_6 | 309.0 | 309 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2430437 | 2430437 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000233 | 420 | Kalama Int | Regular School | No | Middle | 06 | 8 | 2020 | grade_6 | 290.0 | 290 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2430443 | 2430443 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000238 | 430 | Lokelani Int | Regular School | No | Middle | 06 | 8 | 2020 | grade_6 | 141.0 | 141 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2430446 | 2430446 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000241 | 428 | Maui Waena Int | Regular School | No | Middle | 06 | 8 | 2020 | grade_6 | 384.0 | 384 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2430457 | 2430457 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000068 | 413 | Lahaina Int | Regular School | No | Middle | 06 | 8 | 2020 | grade_6 | 199.0 | 199 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2430467 | 2430467 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000266 | 448 | Kamakahelei Middle | Regular School | No | Middle | 06 | 8 | 2020 | grade_6 | 283.0 | 283 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2430470 | 2430470 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000255 | 447 | Kapaa Middle | Regular School | No | Middle | 06 | 8 | 2020 | grade_6 | 151.0 | 151 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2430477 | 2430477 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000092 | 464 | Waimea Canyon Middle | Regular School | No | Middle | 06 | 8 | 2020 | grade_6 | 158.0 | 158 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2430482 | 2430482 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000305 | 568 | DreamHouse Ewa Beach | charter | Regular School | Yes | Middle | 06 | 6 | 2020 | grade_6 | 77.0 | 77 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2430510 | 2430510 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000298 | 567 | SEEQS PCS | charter | Regular School | Yes | Middle | 06 | 8 | 2020 | grade_6 | 51.0 | 51 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2430515 | 2430515 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000268 | 394 | Waimea Middle PCCS | charter | Regular School | Yes | Middle | 06 | 8 | 2020 | grade_6 | 77.0 | 77 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2430516 | 2430516 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000265 | 399 | West Hawaii Explorations PCS | charter | Regular School | Yes | High | 06 | 12 | 2020 | grade_6 | 35.0 | 35 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2454912 | 2454912 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000222 | 105 | Dole Middle | Regular School | No | Middle | 06 | 8 | 2021 | grade_6 | 121.0 | 121 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2454919 | 2454919 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000211 | 116 | Kaimuki Middle | Regular School | No | Middle | 06 | 8 | 2021 | grade_6 | 267.0 | 267 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2454921 | 2454921 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000164 | 118 | Kalakaua Middle | Regular School | No | Middle | 06 | 8 | 2021 | grade_6 | 285.0 | 285 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2454932 | 2454932 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000192 | 139 | Niu Valley Middle | Regular School | No | Middle | 06 | 8 | 2021 | grade_6 | 195.0 | 195 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2454939 | 2454939 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000223 | 104 | Central Middle | Regular School | No | Middle | 06 | 8 | 2021 | grade_6 | 72.0 | 72 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2454941 | 2454941 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000218 | 110 | Jarrett Middle | Regular School | No | Middle | 06 | 8 | 2021 | grade_6 | 70.0 | 70 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2454947 | 2454947 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000205 | 126 | Kawananakoa Middle | Regular School | No | Middle | 06 | 8 | 2021 | grade_6 | 137.0 | 137 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2454962 | 2454962 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000184 | 148 | Stevenson Middle | Regular School | No | Middle | 06 | 8 | 2021 | grade_6 | 140.0 | 140 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2454963 | 2454963 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000180 | 152 | Washington Middle | Regular School | No | Middle | 06 | 8 | 2021 | grade_6 | 128.0 | 128 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2454996 | 2454996 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000256 | 238 | Mililani Middle | Regular School | No | Middle | 06 | 8 | 2021 | grade_6 | 423.0 | 423 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2455001 | 2455001 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000143 | 230 | Wahiawa Middle | Regular School | No | Middle | 06 | 8 | 2021 | grade_6 | 176.0 | 176 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2455005 | 2455005 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000137 | 237 | Wheeler Middle | Regular School | No | Middle | 06 | 8 | 2021 | grade_6 | 202.0 | 202 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2455010 | 2455010 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000296 | 296 | Ewa Makai Middle | Regular School | No | Middle | 06 | 8 | 2021 | grade_6 | 264.0 | 264 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2455012 | 2455012 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000306 | 297 | Honouliuli Middle | Regular School | No | Middle | 06 | 6 | 2021 | grade_6 | 162.0 | 162 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2455019 | 2455019 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000259 | 291 | Kapolei Middle | Regular School | No | Middle | 06 | 8 | 2021 | grade_6 | 169.0 | 169 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2455091 | 2455091 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000053 | 385 | Waiakea Int | Regular School | No | Middle | 06 | 8 | 2021 | grade_6 | 161.0 | 161 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2455102 | 2455102 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000235 | 390 | Kealakehe Int | Regular School | No | Middle | 06 | 8 | 2021 | grade_6 | 190.0 | 190 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2455105 | 2455105 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000267 | 366 | Kohala Middle | Regular School | No | Middle | 06 | 8 | 2021 | grade_6 | 35.0 | 35 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2455108 | 2455108 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000252 | 376 | Konawaena Middle | Regular School | No | Middle | 06 | 8 | 2021 | grade_6 | 165.0 | 165 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2455115 | 2455115 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000040 | 370 | Keaau Middle | Regular School | No | Middle | 06 | 8 | 2021 | grade_6 | 145.0 | 145 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2455123 | 2455123 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000059 | 404 | Iao Int | Regular School | No | Middle | 06 | 8 | 2021 | grade_6 | 201.0 | 201 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2455125 | 2455125 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000233 | 420 | Kalama Int | Regular School | No | Middle | 06 | 8 | 2021 | grade_6 | 196.0 | 196 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2455131 | 2455131 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000238 | 430 | Lokelani Int | Regular School | No | Middle | 06 | 8 | 2021 | grade_6 | 120.0 | 120 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2455134 | 2455134 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000241 | 428 | Maui Waena Int | Regular School | No | Middle | 06 | 8 | 2021 | grade_6 | 291.0 | 291 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2455145 | 2455145 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000068 | 413 | Lahaina Int | Regular School | No | Middle | 06 | 8 | 2021 | grade_6 | 207.0 | 207 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2455155 | 2455155 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000266 | 448 | Kamakahelei Middle | Regular School | No | Middle | 06 | 8 | 2021 | grade_6 | 226.0 | 226 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2455158 | 2455158 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000255 | 447 | Kapaa Middle | Regular School | No | Middle | 06 | 8 | 2021 | grade_6 | 157.0 | 157 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2455165 | 2455165 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000092 | 464 | Waimea Canyon Middle | Regular School | No | Middle | 06 | 8 | 2021 | grade_6 | 134.0 | 134 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2455170 | 2455170 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000305 | 568 | DreamHouse Ewa Beach | charter | Regular School | Yes | Middle | 06 | 7 | 2021 | grade_6 | 84.0 | 84 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2455198 | 2455198 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000298 | 567 | SEEQS PCS | charter | Regular School | Yes | Middle | 06 | 8 | 2021 | grade_6 | 51.0 | 51 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2455203 | 2455203 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000268 | 394 | Waimea Middle PCCS | charter | Regular School | Yes | Middle | 06 | 8 | 2021 | grade_6 | 70.0 | 70 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2455204 | 2455204 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000265 | 399 | West Hawaii Explorations PCS | charter | Regular School | Yes | High | 06 | 12 | 2021 | grade_6 | 34.0 | 34 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2735889 | 2735889 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000222 | 105 | Dole Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_6 | 218.0 | 218 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2735896 | 2735896 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000211 | 116 | Kaimuki Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_6 | 326.0 | 326 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2735898 | 2735898 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000164 | 118 | Kalakaua Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_6 | 337.0 | 337 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2735909 | 2735909 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000192 | 139 | Niu Valley Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_6 | 272.0 | 272 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2735916 | 2735916 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000223 | 104 | Central Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_6 | 127.0 | 127 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2735918 | 2735918 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000218 | 110 | Jarrett Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_6 | 87.0 | 87 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2735924 | 2735924 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000205 | 126 | Kawananakoa Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_6 | 222.0 | 222 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2735939 | 2735939 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000184 | 148 | Stevenson Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_6 | 219.0 | 219 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2735940 | 2735940 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000180 | 152 | Washington Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_6 | 242.0 | 242 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2735973 | 2735973 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000256 | 238 | Mililani Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_6 | 578.0 | 578 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2735978 | 2735978 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000143 | 230 | Wahiawa Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_6 | 236.0 | 236 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2735982 | 2735982 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000137 | 237 | Wheeler Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_6 | 281.0 | 281 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2735995 | 2735995 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000259 | 291 | Kapolei Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_6 | 430.0 | 430 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2736067 | 2736067 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000053 | 385 | Waiakea Int | Regular School | No | Middle | 06 | 8 | 2019 | grade_6 | 267.0 | 267 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2736078 | 2736078 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000235 | 390 | Kealakehe Int | Regular School | No | Middle | 06 | 8 | 2019 | grade_6 | 203.0 | 203 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2736081 | 2736081 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000267 | 366 | Kohala Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_6 | 51.0 | 51 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2736084 | 2736084 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000252 | 376 | Konawaena Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_6 | 208.0 | 208 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2736091 | 2736091 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000040 | 370 | Keaau Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_6 | 210.0 | 210 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2736099 | 2736099 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000059 | 404 | Iao Int | Regular School | No | Middle | 06 | 8 | 2019 | grade_6 | 340.0 | 340 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2736101 | 2736101 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000233 | 420 | Kalama Int | Regular School | No | Middle | 06 | 8 | 2019 | grade_6 | 273.0 | 273 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2736107 | 2736107 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000238 | 430 | Lokelani Int | Regular School | No | Middle | 06 | 8 | 2019 | grade_6 | 178.0 | 178 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2736110 | 2736110 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000241 | 428 | Maui Waena Int | Regular School | No | Middle | 06 | 8 | 2019 | grade_6 | 345.0 | 345 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2736121 | 2736121 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000068 | 413 | Lahaina Int | Regular School | No | Middle | 06 | 8 | 2019 | grade_6 | 226.0 | 226 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2736131 | 2736131 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000266 | 448 | Kamakahelei Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_6 | 311.0 | 311 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2736134 | 2736134 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000255 | 447 | Kapaa Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_6 | 143.0 | 143 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2736141 | 2736141 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000092 | 464 | Waimea Canyon Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_6 | 172.0 | 172 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2736148 | 2736148 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000268 | 394 | Waimea Middle PCCS | charter | Regular School | Yes | Middle | 06 | 8 | 2019 | grade_6 | 77.0 | 77 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2736152 | 2736152 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000265 | 399 | West Hawaii Explorations PCS | charter | Regular School | Yes | High | 06 | 12 | 2019 | grade_6 | 36.0 | 36 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2736179 | 2736179 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000298 | 567 | SEEQS PCS | charter | Regular School | Yes | Middle | 06 | 8 | 2019 | grade_6 | 61.0 | 61 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2780939 | 2780939 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000222 | 105 | Dole Middle | Regular School | No | Middle | 06 | 8 | 2018 | grade_6 | 219.0 | 219 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2780946 | 2780946 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000211 | 116 | Kaimuki Middle | Regular School | No | Middle | 06 | 8 | 2018 | grade_6 | 318.0 | 318 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2780948 | 2780948 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000164 | 118 | Kalakaua Middle | Regular School | No | Middle | 06 | 8 | 2018 | grade_6 | 342.0 | 342 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2780959 | 2780959 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000192 | 139 | Niu Valley Middle | Regular School | No | Middle | 06 | 8 | 2018 | grade_6 | 238.0 | 238 |
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]);