enrollments
Data source: Big Local News · About: Big Local
2,040 rows where grade = "grade_7" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
279643 | 279643 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000092 | 464 | WAIMEA CANYON | Regular School | No | 2 | 06 | 8 | 2015 | grade_7 | 128.0 | 128 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
279650 | 279650 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000268 | 394 | WAIMEA MID-PCCS | charter | Regular School | Yes | 2 | 06 | 8 | 2015 | grade_7 | 85.0 | 85 | |||||||||||||||||||||||||||||||||||||||||||||||||||
279654 | 279654 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000265 | 399 | WEST HI EXPLOR ACAD-PCS | charter | Regular School | Yes | 4 | 06 | 12 | 2015 | grade_7 | 32.0 | 32 | |||||||||||||||||||||||||||||||||||||||||||||||||||
279679 | 279679 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000298 | 567 | SEEQS | charter | Regular School | Yes | 2 | 06 | 8 | 2015 | grade_7 | 31.0 | 31 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2430518 | 2430518 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000222 | 105 | Dole Middle | Regular School | No | Middle | 06 | 8 | 2020 | grade_7 | 240.0 | 240 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2430525 | 2430525 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000211 | 116 | Kaimuki Middle | Regular School | No | Middle | 06 | 8 | 2020 | grade_7 | 333.0 | 333 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2430527 | 2430527 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000164 | 118 | Kalakaua Middle | Regular School | No | Middle | 06 | 8 | 2020 | grade_7 | 313.0 | 313 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2430538 | 2430538 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000192 | 139 | Niu Valley Middle | Regular School | No | Middle | 06 | 8 | 2020 | grade_7 | 269.0 | 269 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2430545 | 2430545 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000223 | 104 | Central Middle | Regular School | No | Middle | 06 | 8 | 2020 | grade_7 | 118.0 | 118 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2430547 | 2430547 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000218 | 110 | Jarrett Middle | Regular School | No | Middle | 06 | 8 | 2020 | grade_7 | 82.0 | 82 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2430553 | 2430553 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000205 | 126 | Kawananakoa Middle | Regular School | No | Middle | 06 | 8 | 2020 | grade_7 | 212.0 | 212 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2430568 | 2430568 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000184 | 148 | Stevenson Middle | Regular School | No | Middle | 06 | 8 | 2020 | grade_7 | 207.0 | 207 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2430569 | 2430569 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000180 | 152 | Washington Middle | Regular School | No | Middle | 06 | 8 | 2020 | grade_7 | 216.0 | 216 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2430602 | 2430602 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000256 | 238 | Mililani Middle | Regular School | No | Middle | 06 | 8 | 2020 | grade_7 | 563.0 | 563 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2430607 | 2430607 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000143 | 230 | Wahiawa Middle | Regular School | No | Middle | 06 | 8 | 2020 | grade_7 | 253.0 | 253 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2430611 | 2430611 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000137 | 237 | Wheeler Middle | Regular School | No | Middle | 06 | 8 | 2020 | grade_7 | 240.0 | 240 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2430616 | 2430616 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000296 | 296 | Ewa Makai Middle | Regular School | No | Middle | 06 | 8 | 2020 | grade_7 | 442.0 | 442 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2430624 | 2430624 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000259 | 291 | Kapolei Middle | Regular School | No | Middle | 06 | 8 | 2020 | grade_7 | 431.0 | 431 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2430696 | 2430696 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000053 | 385 | Waiakea Int | Regular School | No | Middle | 06 | 8 | 2020 | grade_7 | 283.0 | 283 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2430707 | 2430707 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000235 | 390 | Kealakehe Int | Regular School | No | Middle | 06 | 8 | 2020 | grade_7 | 196.0 | 196 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2430710 | 2430710 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000267 | 366 | Kohala Middle | Regular School | No | Middle | 06 | 8 | 2020 | grade_7 | 55.0 | 55 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2430713 | 2430713 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000252 | 376 | Konawaena Middle | Regular School | No | Middle | 06 | 8 | 2020 | grade_7 | 228.0 | 228 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2430720 | 2430720 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000040 | 370 | Keaau Middle | Regular School | No | Middle | 06 | 8 | 2020 | grade_7 | 220.0 | 220 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2430728 | 2430728 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000059 | 404 | Iao Int | Regular School | No | Middle | 06 | 8 | 2020 | grade_7 | 329.0 | 329 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2430730 | 2430730 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000233 | 420 | Kalama Int | Regular School | No | Middle | 06 | 8 | 2020 | grade_7 | 266.0 | 266 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2430736 | 2430736 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000238 | 430 | Lokelani Int | Regular School | No | Middle | 06 | 8 | 2020 | grade_7 | 184.0 | 184 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2430739 | 2430739 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000241 | 428 | Maui Waena Int | Regular School | No | Middle | 06 | 8 | 2020 | grade_7 | 336.0 | 336 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2430750 | 2430750 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000068 | 413 | Lahaina Int | Regular School | No | Middle | 06 | 8 | 2020 | grade_7 | 228.0 | 228 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2430760 | 2430760 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000266 | 448 | Kamakahelei Middle | Regular School | No | Middle | 06 | 8 | 2020 | grade_7 | 309.0 | 309 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2430763 | 2430763 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000255 | 447 | Kapaa Middle | Regular School | No | Middle | 06 | 8 | 2020 | grade_7 | 166.0 | 166 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2430770 | 2430770 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000092 | 464 | Waimea Canyon Middle | Regular School | No | Middle | 06 | 8 | 2020 | grade_7 | 163.0 | 163 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2430775 | 2430775 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000305 | 568 | DreamHouse Ewa Beach | charter | Regular School | Yes | Middle | 06 | 6 | 2020 | grade_7 | 0.0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2430803 | 2430803 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000298 | 567 | SEEQS PCS | charter | Regular School | Yes | Middle | 06 | 8 | 2020 | grade_7 | 54.0 | 54 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2430808 | 2430808 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000268 | 394 | Waimea Middle PCCS | charter | Regular School | Yes | Middle | 06 | 8 | 2020 | grade_7 | 72.0 | 72 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2430809 | 2430809 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000265 | 399 | West Hawaii Explorations PCS | charter | Regular School | Yes | High | 06 | 12 | 2020 | grade_7 | 36.0 | 36 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2455206 | 2455206 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000222 | 105 | Dole Middle | Regular School | No | Middle | 06 | 8 | 2021 | grade_7 | 198.0 | 198 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2455213 | 2455213 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000211 | 116 | Kaimuki Middle | Regular School | No | Middle | 06 | 8 | 2021 | grade_7 | 321.0 | 321 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2455215 | 2455215 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000164 | 118 | Kalakaua Middle | Regular School | No | Middle | 06 | 8 | 2021 | grade_7 | 349.0 | 349 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2455226 | 2455226 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000192 | 139 | Niu Valley Middle | Regular School | No | Middle | 06 | 8 | 2021 | grade_7 | 260.0 | 260 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2455233 | 2455233 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000223 | 104 | Central Middle | Regular School | No | Middle | 06 | 8 | 2021 | grade_7 | 99.0 | 99 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2455235 | 2455235 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000218 | 110 | Jarrett Middle | Regular School | No | Middle | 06 | 8 | 2021 | grade_7 | 80.0 | 80 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2455241 | 2455241 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000205 | 126 | Kawananakoa Middle | Regular School | No | Middle | 06 | 8 | 2021 | grade_7 | 222.0 | 222 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2455256 | 2455256 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000184 | 148 | Stevenson Middle | Regular School | No | Middle | 06 | 8 | 2021 | grade_7 | 231.0 | 231 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2455257 | 2455257 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000180 | 152 | Washington Middle | Regular School | No | Middle | 06 | 8 | 2021 | grade_7 | 230.0 | 230 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2455290 | 2455290 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000256 | 238 | Mililani Middle | Regular School | No | Middle | 06 | 8 | 2021 | grade_7 | 522.0 | 522 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2455295 | 2455295 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000143 | 230 | Wahiawa Middle | Regular School | No | Middle | 06 | 8 | 2021 | grade_7 | 243.0 | 243 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2455299 | 2455299 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000137 | 237 | Wheeler Middle | Regular School | No | Middle | 06 | 8 | 2021 | grade_7 | 230.0 | 230 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2455304 | 2455304 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000296 | 296 | Ewa Makai Middle | Regular School | No | Middle | 06 | 8 | 2021 | grade_7 | 472.0 | 472 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2455306 | 2455306 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000306 | 297 | Honouliuli Middle | Regular School | No | Middle | 06 | 6 | 2021 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2455313 | 2455313 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000259 | 291 | Kapolei Middle | Regular School | No | Middle | 06 | 8 | 2021 | grade_7 | 432.0 | 432 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2455385 | 2455385 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000053 | 385 | Waiakea Int | Regular School | No | Middle | 06 | 8 | 2021 | grade_7 | 262.0 | 262 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2455396 | 2455396 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000235 | 390 | Kealakehe Int | Regular School | No | Middle | 06 | 8 | 2021 | grade_7 | 244.0 | 244 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2455399 | 2455399 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000267 | 366 | Kohala Middle | Regular School | No | Middle | 06 | 8 | 2021 | grade_7 | 55.0 | 55 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2455402 | 2455402 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000252 | 376 | Konawaena Middle | Regular School | No | Middle | 06 | 8 | 2021 | grade_7 | 236.0 | 236 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2455409 | 2455409 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000040 | 370 | Keaau Middle | Regular School | No | Middle | 06 | 8 | 2021 | grade_7 | 226.0 | 226 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2455417 | 2455417 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000059 | 404 | Iao Int | Regular School | No | Middle | 06 | 8 | 2021 | grade_7 | 290.0 | 290 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2455419 | 2455419 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000233 | 420 | Kalama Int | Regular School | No | Middle | 06 | 8 | 2021 | grade_7 | 287.0 | 287 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2455425 | 2455425 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000238 | 430 | Lokelani Int | Regular School | No | Middle | 06 | 8 | 2021 | grade_7 | 131.0 | 131 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2455428 | 2455428 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000241 | 428 | Maui Waena Int | Regular School | No | Middle | 06 | 8 | 2021 | grade_7 | 368.0 | 368 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2455439 | 2455439 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000068 | 413 | Lahaina Int | Regular School | No | Middle | 06 | 8 | 2021 | grade_7 | 203.0 | 203 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2455449 | 2455449 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000266 | 448 | Kamakahelei Middle | Regular School | No | Middle | 06 | 8 | 2021 | grade_7 | 284.0 | 284 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2455452 | 2455452 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000255 | 447 | Kapaa Middle | Regular School | No | Middle | 06 | 8 | 2021 | grade_7 | 197.0 | 197 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2455459 | 2455459 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000092 | 464 | Waimea Canyon Middle | Regular School | No | Middle | 06 | 8 | 2021 | grade_7 | 155.0 | 155 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2455464 | 2455464 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000305 | 568 | DreamHouse Ewa Beach | charter | Regular School | Yes | Middle | 06 | 7 | 2021 | grade_7 | 90.0 | 90 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2455492 | 2455492 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000298 | 567 | SEEQS PCS | charter | Regular School | Yes | Middle | 06 | 8 | 2021 | grade_7 | 49.0 | 49 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2455497 | 2455497 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000268 | 394 | Waimea Middle PCCS | charter | Regular School | Yes | Middle | 06 | 8 | 2021 | grade_7 | 71.0 | 71 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2455498 | 2455498 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000265 | 399 | West Hawaii Explorations PCS | charter | Regular School | Yes | High | 06 | 12 | 2021 | grade_7 | 36.0 | 36 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2736181 | 2736181 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000222 | 105 | Dole Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_7 | 268.0 | 268 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2736188 | 2736188 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000211 | 116 | Kaimuki Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_7 | 304.0 | 304 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2736190 | 2736190 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000164 | 118 | Kalakaua Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_7 | 336.0 | 336 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2736201 | 2736201 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000192 | 139 | Niu Valley Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_7 | 235.0 | 235 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2736208 | 2736208 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000223 | 104 | Central Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_7 | 125.0 | 125 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2736210 | 2736210 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000218 | 110 | Jarrett Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_7 | 79.0 | 79 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2736216 | 2736216 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000205 | 126 | Kawananakoa Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_7 | 227.0 | 227 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2736231 | 2736231 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000184 | 148 | Stevenson Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_7 | 184.0 | 184 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2736232 | 2736232 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000180 | 152 | Washington Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_7 | 223.0 | 223 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2736265 | 2736265 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000256 | 238 | Mililani Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_7 | 583.0 | 583 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2736270 | 2736270 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000143 | 230 | Wahiawa Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_7 | 262.0 | 262 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2736274 | 2736274 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000137 | 237 | Wheeler Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_7 | 253.0 | 253 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2736287 | 2736287 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000259 | 291 | Kapolei Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_7 | 499.0 | 499 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2736359 | 2736359 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000053 | 385 | Waiakea Int | Regular School | No | Middle | 06 | 8 | 2019 | grade_7 | 263.0 | 263 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2736370 | 2736370 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000235 | 390 | Kealakehe Int | Regular School | No | Middle | 06 | 8 | 2019 | grade_7 | 196.0 | 196 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2736373 | 2736373 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000267 | 366 | Kohala Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_7 | 55.0 | 55 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2736376 | 2736376 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000252 | 376 | Konawaena Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_7 | 218.0 | 218 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2736383 | 2736383 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000040 | 370 | Keaau Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_7 | 205.0 | 205 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2736391 | 2736391 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000059 | 404 | Iao Int | Regular School | No | Middle | 06 | 8 | 2019 | grade_7 | 320.0 | 320 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2736393 | 2736393 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000233 | 420 | Kalama Int | Regular School | No | Middle | 06 | 8 | 2019 | grade_7 | 245.0 | 245 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2736399 | 2736399 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000238 | 430 | Lokelani Int | Regular School | No | Middle | 06 | 8 | 2019 | grade_7 | 159.0 | 159 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2736402 | 2736402 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000241 | 428 | Maui Waena Int | Regular School | No | Middle | 06 | 8 | 2019 | grade_7 | 346.0 | 346 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2736413 | 2736413 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000068 | 413 | Lahaina Int | Regular School | No | Middle | 06 | 8 | 2019 | grade_7 | 231.0 | 231 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2736423 | 2736423 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000266 | 448 | Kamakahelei Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_7 | 280.0 | 280 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2736426 | 2736426 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000255 | 447 | Kapaa Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_7 | 209.0 | 209 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2736433 | 2736433 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000092 | 464 | Waimea Canyon Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_7 | 143.0 | 143 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2736440 | 2736440 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000268 | 394 | Waimea Middle PCCS | charter | Regular School | Yes | Middle | 06 | 8 | 2019 | grade_7 | 77.0 | 77 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2736444 | 2736444 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000265 | 399 | West Hawaii Explorations PCS | charter | Regular School | Yes | High | 06 | 12 | 2019 | grade_7 | 35.0 | 35 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2736471 | 2736471 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000298 | 567 | SEEQS PCS | charter | Regular School | Yes | Middle | 06 | 8 | 2019 | grade_7 | 54.0 | 54 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2781231 | 2781231 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000222 | 105 | Dole Middle | Regular School | No | Middle | 06 | 8 | 2018 | grade_7 | 278.0 | 278 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2781238 | 2781238 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000211 | 116 | Kaimuki Middle | Regular School | No | Middle | 06 | 8 | 2018 | grade_7 | 291.0 | 291 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2781240 | 2781240 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000164 | 118 | Kalakaua Middle | Regular School | No | Middle | 06 | 8 | 2018 | grade_7 | 352.0 | 352 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2781251 | 2781251 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000192 | 139 | Niu Valley Middle | Regular School | No | Middle | 06 | 8 | 2018 | grade_7 | 270.0 | 270 |
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]);