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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
109679 | 109679 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000301 | 552 | KAU LEARNING ACAD-PCS | charter | Regular School | Yes | 1 | 03 | 6 | 2016 | grade_7 | 0.0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
128682 | 128682 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000301 | 552 | KAU LEARNING ACAD-PCS | charter | Regular School | Yes | Elementary | 03 | 7 | 2017 | grade_7 | 16.0 | 16 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2781501 | 2781501 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000301 | 552 | Kau Learning Academy | charter | Regular School | Yes | Middle | 03 | 7 | 2018 | grade_7 | 19.0 | 19 | |||||||||||||||||||||||||||||||||||||||||||||||||||
109668 | 109668 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000275 | 546 | HAKIPU'U LEARNING CTR-PCS | charter | Regular School | Yes | 4 | 04 | 12 | 2016 | grade_7 | 4.0 | 4 | |||||||||||||||||||||||||||||||||||||||||||||||||||
109669 | 109669 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000270 | 540 | HALAU KU MANA-PCS | charter | Regular School | Yes | 4 | 04 | 12 | 2016 | grade_7 | 15.0 | 15 | |||||||||||||||||||||||||||||||||||||||||||||||||||
128671 | 128671 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000275 | 546 | HAKIPU'U LEARNING CTR-PCS | charter | Regular School | Yes | Other | 04 | 12 | 2017 | grade_7 | 7.0 | 7 | |||||||||||||||||||||||||||||||||||||||||||||||||||
128672 | 128672 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000270 | 540 | HALAU KU MANA-PCS | charter | Regular School | Yes | Other | 04 | 12 | 2017 | grade_7 | 17.0 | 17 | |||||||||||||||||||||||||||||||||||||||||||||||||||
279657 | 279657 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000270 | 540 | HALAU KU MANA-PCS | charter | Regular School | Yes | 4 | 04 | 12 | 2015 | grade_7 | 15.0 | 15 | |||||||||||||||||||||||||||||||||||||||||||||||||||
279663 | 279663 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000275 | 546 | HAKIPU'U LEARNING CTR-PCS | charter | Regular School | Yes | 4 | 04 | 12 | 2015 | grade_7 | 6.0 | 6 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2430776 | 2430776 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000275 | 546 | Hakipuu Learning Ctr PCS | charter | Regular School | Yes | Other | 04 | 12 | 2020 | grade_7 | 5.0 | 5 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2430777 | 2430777 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000270 | 540 | Halau Ku Mana NCPCS | charter | Regular School | Yes | Other | 04 | 12 | 2020 | grade_7 | 15.0 | 15 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2455466 | 2455466 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000270 | 540 | Halau Ku Mana NCPCS | charter | Regular School | Yes | Other | 04 | 12 | 2021 | grade_7 | 16.0 | 16 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2736447 | 2736447 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000270 | 540 | Halau Ku Mana NCPCS | charter | Regular School | Yes | Other | 04 | 12 | 2019 | grade_7 | 17.0 | 17 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2736452 | 2736452 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000275 | 546 | Hakipuu Learning Ctr PCS | charter | Regular School | Yes | Other | 04 | 12 | 2019 | grade_7 | 7.0 | 7 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2781487 | 2781487 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000275 | 546 | Hakipuu Learning Ctr PCS | charter | Regular School | Yes | Other | 04 | 12 | 2018 | grade_7 | 3.0 | 3 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2781488 | 2781488 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000270 | 540 | Halau Ku Mana NCPCS | charter | Regular School | Yes | Other | 04 | 12 | 2018 | grade_7 | 20.0 | 20 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2455465 | 2455465 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000275 | 546 | Hakipuu Academy PCS | charter | Regular School | Yes | High | 05 | 12 | 2021 | grade_7 | 5.0 | 5 | |||||||||||||||||||||||||||||||||||||||||||||||||||
109411 | 109411 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000222 | 105 | DOLE MID | Regular School | No | 2 | 06 | 8 | 2016 | grade_7 | 239.0 | 239 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
109418 | 109418 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000211 | 116 | KAIMUKI MID | Regular School | No | 2 | 06 | 8 | 2016 | grade_7 | 311.0 | 311 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
109420 | 109420 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000164 | 118 | KALAKAUA MID | Regular School | No | 2 | 06 | 8 | 2016 | grade_7 | 289.0 | 289 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
109431 | 109431 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000192 | 139 | NIU VALLEY MID | Regular School | No | 2 | 06 | 8 | 2016 | grade_7 | 282.0 | 282 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
109438 | 109438 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000223 | 104 | CENTRAL MID | Regular School | No | 2 | 06 | 8 | 2016 | grade_7 | 115.0 | 115 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
109440 | 109440 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000218 | 110 | JARRETT MID | Regular School | No | 2 | 06 | 8 | 2016 | grade_7 | 79.0 | 79 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
109446 | 109446 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000205 | 126 | KAWANANAKOA MID | Regular School | No | 2 | 06 | 8 | 2016 | grade_7 | 248.0 | 248 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
109461 | 109461 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000184 | 148 | STEVENSON MID | Regular School | No | 2 | 06 | 8 | 2016 | grade_7 | 201.0 | 201 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
109462 | 109462 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000180 | 152 | WASHINGTON MID | Regular School | No | 2 | 06 | 8 | 2016 | grade_7 | 264.0 | 264 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
109495 | 109495 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000256 | 238 | MILILANI MID | Regular School | No | 2 | 06 | 8 | 2016 | grade_7 | 578.0 | 578 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
109500 | 109500 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000143 | 230 | WAHIAWA MID | Regular School | No | 2 | 06 | 8 | 2016 | grade_7 | 259.0 | 259 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
109504 | 109504 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000137 | 237 | WHEELER MID | Regular School | No | 2 | 06 | 8 | 2016 | grade_7 | 243.0 | 243 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
109517 | 109517 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000259 | 291 | KAPOLEI MID | Regular School | No | 2 | 06 | 8 | 2016 | grade_7 | 407.0 | 407 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
109589 | 109589 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000053 | 385 | WAIAKEA INT | Regular School | No | 2 | 06 | 8 | 2016 | grade_7 | 247.0 | 247 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
109600 | 109600 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000235 | 390 | KEALAKEHE INT | Regular School | No | 2 | 06 | 8 | 2016 | grade_7 | 237.0 | 237 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
109603 | 109603 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000267 | 366 | KOHALA MID | Regular School | No | 2 | 06 | 8 | 2016 | grade_7 | 55.0 | 55 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
109606 | 109606 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000252 | 376 | KONAWAENA MID | Regular School | No | 2 | 06 | 8 | 2016 | grade_7 | 162.0 | 162 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
109613 | 109613 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000040 | 370 | KEAAU MID | Regular School | No | 2 | 06 | 8 | 2016 | grade_7 | 193.0 | 193 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
109621 | 109621 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000059 | 404 | IAO INT | Regular School | No | 2 | 06 | 8 | 2016 | grade_7 | 264.0 | 264 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
109623 | 109623 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000233 | 420 | KALAMA INT | Regular School | No | 2 | 06 | 8 | 2016 | grade_7 | 263.0 | 263 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
109629 | 109629 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000238 | 430 | LOKELANI INT | Regular School | No | 2 | 06 | 8 | 2016 | grade_7 | 168.0 | 168 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
109632 | 109632 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000241 | 428 | MAUI WAENA INT | Regular School | No | 2 | 06 | 8 | 2016 | grade_7 | 378.0 | 378 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
109643 | 109643 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000068 | 413 | LAHAINA INT | Regular School | No | 2 | 06 | 8 | 2016 | grade_7 | 208.0 | 208 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
109653 | 109653 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000266 | 448 | KAMAKAHELEI MID | Regular School | No | 2 | 06 | 8 | 2016 | grade_7 | 281.0 | 281 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
109656 | 109656 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000255 | 447 | KAPAA MID | Regular School | No | 2 | 06 | 8 | 2016 | grade_7 | 211.0 | 211 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
109663 | 109663 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000092 | 464 | WAIMEA CANYON | Regular School | No | 2 | 06 | 8 | 2016 | grade_7 | 111.0 | 111 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
109694 | 109694 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000298 | 567 | SEEQS | charter | Regular School | Yes | 2 | 06 | 8 | 2016 | grade_7 | 49.0 | 49 | |||||||||||||||||||||||||||||||||||||||||||||||||||
109698 | 109698 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000268 | 394 | WAIMEA MID-PCCS | charter | Regular School | Yes | 2 | 06 | 8 | 2016 | grade_7 | 89.0 | 89 | |||||||||||||||||||||||||||||||||||||||||||||||||||
109699 | 109699 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000265 | 399 | WEST HI EXPLOR ACAD-PCS | charter | Regular School | Yes | 4 | 06 | 12 | 2016 | grade_7 | 37.0 | 37 | |||||||||||||||||||||||||||||||||||||||||||||||||||
128414 | 128414 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000222 | 105 | DOLE MID | Regular School | No | Middle | 06 | 8 | 2017 | grade_7 | 255.0 | 255 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128421 | 128421 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000211 | 116 | KAIMUKI MID | Regular School | No | Middle | 06 | 8 | 2017 | grade_7 | 314.0 | 314 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128423 | 128423 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000164 | 118 | KALAKAUA MID | Regular School | No | Middle | 06 | 8 | 2017 | grade_7 | 324.0 | 324 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128434 | 128434 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000192 | 139 | NIU VALLEY MID | Regular School | No | Middle | 06 | 8 | 2017 | grade_7 | 273.0 | 273 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128441 | 128441 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000223 | 104 | CENTRAL MID | Regular School | No | Middle | 06 | 8 | 2017 | grade_7 | 113.0 | 113 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128443 | 128443 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000218 | 110 | JARRETT MID | Regular School | No | Middle | 06 | 8 | 2017 | grade_7 | 64.0 | 64 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128449 | 128449 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000205 | 126 | KAWANANAKOA MID | Regular School | No | Middle | 06 | 8 | 2017 | grade_7 | 249.0 | 249 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128464 | 128464 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000184 | 148 | STEVENSON MID | Regular School | No | Middle | 06 | 8 | 2017 | grade_7 | 197.0 | 197 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128465 | 128465 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000180 | 152 | WASHINGTON MID | Regular School | No | Middle | 06 | 8 | 2017 | grade_7 | 265.0 | 265 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128498 | 128498 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000256 | 238 | MILILANI MID | Regular School | No | Middle | 06 | 8 | 2017 | grade_7 | 555.0 | 555 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128503 | 128503 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000143 | 230 | WAHIAWA MID | Regular School | No | Middle | 06 | 8 | 2017 | grade_7 | 257.0 | 257 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128507 | 128507 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000137 | 237 | WHEELER MID | Regular School | No | Middle | 06 | 8 | 2017 | grade_7 | 242.0 | 242 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128520 | 128520 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000259 | 291 | KAPOLEI MID | Regular School | No | Middle | 06 | 8 | 2017 | grade_7 | 432.0 | 432 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128592 | 128592 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000053 | 385 | WAIAKEA INT | Regular School | No | Middle | 06 | 8 | 2017 | grade_7 | 256.0 | 256 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128603 | 128603 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000235 | 390 | KEALAKEHE INT | Regular School | No | Middle | 06 | 8 | 2017 | grade_7 | 183.0 | 183 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128606 | 128606 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000267 | 366 | KOHALA MID | Regular School | No | Middle | 06 | 8 | 2017 | grade_7 | 49.0 | 49 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128609 | 128609 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000252 | 376 | KONAWAENA MID | Regular School | No | Middle | 06 | 8 | 2017 | grade_7 | 184.0 | 184 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128616 | 128616 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000040 | 370 | KEAAU MID | Regular School | No | Middle | 06 | 8 | 2017 | grade_7 | 218.0 | 218 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128624 | 128624 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000059 | 404 | IAO INT | Regular School | No | Middle | 06 | 8 | 2017 | grade_7 | 284.0 | 284 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128626 | 128626 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000233 | 420 | KALAMA INT | Regular School | No | Middle | 06 | 8 | 2017 | grade_7 | 270.0 | 270 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128632 | 128632 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000238 | 430 | LOKELANI INT | Regular School | No | Middle | 06 | 8 | 2017 | grade_7 | 194.0 | 194 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128635 | 128635 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000241 | 428 | MAUI WAENA INT | Regular School | No | Middle | 06 | 8 | 2017 | grade_7 | 354.0 | 354 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128646 | 128646 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000068 | 413 | LAHAINA INT | Regular School | No | Middle | 06 | 8 | 2017 | grade_7 | 203.0 | 203 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128656 | 128656 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000266 | 448 | KAMAKAHELEI MID | Regular School | No | Middle | 06 | 8 | 2017 | grade_7 | 299.0 | 299 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128659 | 128659 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000255 | 447 | KAPAA MID | Regular School | No | Middle | 06 | 8 | 2017 | grade_7 | 201.0 | 201 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128666 | 128666 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000092 | 464 | WAIMEA CANYON | Regular School | No | Middle | 06 | 8 | 2017 | grade_7 | 124.0 | 124 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128697 | 128697 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000298 | 567 | SEEQS | charter | Regular School | Yes | Middle | 06 | 8 | 2017 | grade_7 | 46.0 | 46 | |||||||||||||||||||||||||||||||||||||||||||||||||||
128701 | 128701 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000268 | 394 | WAIMEA MID-PCCS | charter | Regular School | Yes | Middle | 06 | 8 | 2017 | grade_7 | 67.0 | 67 | |||||||||||||||||||||||||||||||||||||||||||||||||||
128702 | 128702 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000265 | 399 | WEST HI EXPLOR ACAD-PCS | charter | Regular School | Yes | Other | 06 | 12 | 2017 | grade_7 | 39.0 | 39 | |||||||||||||||||||||||||||||||||||||||||||||||||||
279392 | 279392 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000222 | 105 | DOLE MID | Regular School | No | 2 | 06 | 8 | 2015 | grade_7 | 292.0 | 292 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
279399 | 279399 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000211 | 116 | KAIMUKI MID | Regular School | No | 2 | 06 | 8 | 2015 | grade_7 | 307.0 | 307 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
279401 | 279401 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000164 | 118 | KALAKAUA MID | Regular School | No | 2 | 06 | 8 | 2015 | grade_7 | 360.0 | 360 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
279412 | 279412 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000192 | 139 | NIU VALLEY MID | Regular School | No | 2 | 06 | 8 | 2015 | grade_7 | 276.0 | 276 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
279419 | 279419 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000223 | 104 | CENTRAL MID | Regular School | No | 2 | 06 | 8 | 2015 | grade_7 | 108.0 | 108 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
279421 | 279421 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000218 | 110 | JARRETT MID | Regular School | No | 2 | 06 | 8 | 2015 | grade_7 | 71.0 | 71 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
279427 | 279427 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000205 | 126 | KAWANANAKOA MID | Regular School | No | 2 | 06 | 8 | 2015 | grade_7 | 261.0 | 261 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
279442 | 279442 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000184 | 148 | STEVENSON MID | Regular School | No | 2 | 06 | 8 | 2015 | grade_7 | 174.0 | 174 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
279443 | 279443 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000180 | 152 | WASHINGTON MID | Regular School | No | 2 | 06 | 8 | 2015 | grade_7 | 229.0 | 229 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
279476 | 279476 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000256 | 238 | MILILANI MID | Regular School | No | 2 | 06 | 8 | 2015 | grade_7 | 550.0 | 550 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
279481 | 279481 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000143 | 230 | WAHIAWA MID | Regular School | No | 2 | 06 | 8 | 2015 | grade_7 | 245.0 | 245 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
279485 | 279485 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000137 | 237 | WHEELER MID | Regular School | No | 2 | 06 | 8 | 2015 | grade_7 | 258.0 | 258 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
279497 | 279497 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000259 | 291 | KAPOLEI MID | Regular School | No | 2 | 06 | 8 | 2015 | grade_7 | 433.0 | 433 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
279569 | 279569 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000053 | 385 | WAIAKEA INT | Regular School | No | 2 | 06 | 8 | 2015 | grade_7 | 294.0 | 294 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
279580 | 279580 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000235 | 390 | KEALAKEHE INT | Regular School | No | 2 | 06 | 8 | 2015 | grade_7 | 198.0 | 198 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
279583 | 279583 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000267 | 366 | KOHALA MID | Regular School | No | 2 | 06 | 8 | 2015 | grade_7 | 48.0 | 48 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
279586 | 279586 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000252 | 376 | KONAWAENA MID | Regular School | No | 2 | 06 | 8 | 2015 | grade_7 | 164.0 | 164 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
279593 | 279593 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000040 | 370 | KEAAU MID | Regular School | No | 2 | 06 | 8 | 2015 | grade_7 | 190.0 | 190 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
279601 | 279601 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000059 | 404 | IAO INT | Regular School | No | 2 | 06 | 8 | 2015 | grade_7 | 292.0 | 292 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
279603 | 279603 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000233 | 420 | KALAMA INT | Regular School | No | 2 | 06 | 8 | 2015 | grade_7 | 239.0 | 239 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
279609 | 279609 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000238 | 430 | LOKELANI INT | Regular School | No | 2 | 06 | 8 | 2015 | grade_7 | 165.0 | 165 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
279612 | 279612 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000241 | 428 | MAUI WAENA INT | Regular School | No | 2 | 06 | 8 | 2015 | grade_7 | 342.0 | 342 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
279623 | 279623 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000068 | 413 | LAHAINA INT | Regular School | No | 2 | 06 | 8 | 2015 | grade_7 | 199.0 | 199 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
279633 | 279633 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000266 | 448 | KAMAKAHELEI MID | Regular School | No | 2 | 06 | 8 | 2015 | grade_7 | 276.0 | 276 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
279636 | 279636 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000255 | 447 | KAPAA MID | Regular School | No | 2 | 06 | 8 | 2015 | grade_7 | 183.0 | 183 |
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]);