enrollments
Data source: Big Local News · About: Big Local
2,040 rows where grade = "grade_7" and state = "HI" sorted by school
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2781325 | 2781325 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000135 | 251 | Barbers Point Elem | Regular School | No | Elementary | PK | 5 | 2018 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
109506 | 109506 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000134 | 252 | CAMPBELL HI | Regular School | No | 3 | 09 | 12 | 2016 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128509 | 128509 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000134 | 252 | CAMPBELL HI | Regular School | No | High | 09 | 12 | 2017 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
279487 | 279487 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000134 | 252 | CAMPBELL HI | Regular School | No | 3 | 09 | 12 | 2015 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
109549 | 109549 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000100 | 301 | CASTLE HI | Regular School | No | 3 | 09 | 12 | 2016 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128552 | 128552 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000100 | 301 | CASTLE HI | Regular School | No | High | 09 | 12 | 2017 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
279529 | 279529 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000100 | 301 | CASTLE HI | Regular School | No | 3 | 09 | 12 | 2015 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
109666 | 109666 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000262 | 396 | CONNECTIONS-PCS | charter | Regular School | Yes | 4 | KG | 12 | 2016 | grade_7 | 33.0 | 33 | |||||||||||||||||||||||||||||||||||||||||||||||||||
128669 | 128669 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000262 | 396 | CONNECTIONS-PCS | charter | Regular School | Yes | Other | KG | 12 | 2017 | grade_7 | 38.0 | 38 | |||||||||||||||||||||||||||||||||||||||||||||||||||
279651 | 279651 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000262 | 396 | CONNECTIONS-PCS | charter | Regular School | Yes | 4 | KG | 12 | 2015 | grade_7 | 30.0 | 30 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2430613 | 2430613 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000134 | 252 | Campbell High | Regular School | No | High | 09 | 12 | 2020 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2455301 | 2455301 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000134 | 252 | Campbell High | Regular School | No | High | 09 | 12 | 2021 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2736276 | 2736276 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000134 | 252 | Campbell High | Regular School | No | High | 09 | 12 | 2019 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2781326 | 2781326 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000134 | 252 | Campbell High | Regular School | No | High | 09 | 12 | 2018 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2430656 | 2430656 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000100 | 301 | Castle High | Regular School | No | High | 09 | 12 | 2020 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2455345 | 2455345 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000100 | 301 | Castle High | Regular School | No | High | 09 | 12 | 2021 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2736319 | 2736319 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000100 | 301 | Castle High | Regular School | No | High | 09 | 12 | 2019 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2781369 | 2781369 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000100 | 301 | Castle High | Regular School | No | High | 09 | 12 | 2018 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2781258 | 2781258 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000223 | 104 | Central Middle | Regular School | No | Middle | 06 | 8 | 2018 | grade_7 | 117.0 | 117 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2430774 | 2430774 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000262 | 396 | Connections NCPCS | charter | Regular School | Yes | Other | KG | 12 | 2020 | grade_7 | 28.0 | 28 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2455463 | 2455463 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000262 | 396 | Connections NCPCS | charter | Regular School | Yes | Other | KG | 12 | 2021 | grade_7 | 34.0 | 34 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2736441 | 2736441 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000262 | 396 | Connections NCPCS | charter | Regular School | Yes | Other | KG | 12 | 2019 | grade_7 | 29.0 | 29 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2781486 | 2781486 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000262 | 396 | Connections NCPCS | charter | Regular School | Yes | Other | KG | 12 | 2018 | grade_7 | 34.0 | 34 | |||||||||||||||||||||||||||||||||||||||||||||||||||
109578 | 109578 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000027 | 351 | DE SILVA | Regular School | No | 1 | PK | 6 | 2016 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128581 | 128581 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000027 | 351 | DE SILVA | Regular School | No | Elementary | PK | 6 | 2017 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
279558 | 279558 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000027 | 351 | DE SILVA | Regular School | No | 1 | PK | 6 | 2015 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||||||||
109667 | 109667 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000273 | 543 | EDUC LAB: A HAWAII NC-PCS | charter | Regular School | Yes | 4 | KG | 12 | 2016 | grade_7 | 51.0 | 51 | |||||||||||||||||||||||||||||||||||||||||||||||||||
128670 | 128670 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000273 | 543 | EDUC LAB: A HAWAII NC-PCS | charter | Regular School | Yes | Other | KG | 12 | 2017 | grade_7 | 55.0 | 55 | |||||||||||||||||||||||||||||||||||||||||||||||||||
279660 | 279660 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000273 | 543 | EDUC LAB: A HAWAII NC-PCS | charter | Regular School | Yes | 4 | KG | 12 | 2015 | grade_7 | 56.0 | 56 | |||||||||||||||||||||||||||||||||||||||||||||||||||
109650 | 109650 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000081 | 451 | ELEELE | Regular School | No | 1 | PK | 5 | 2016 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128653 | 128653 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000081 | 451 | ELEELE | Regular School | No | Elementary | PK | 5 | 2017 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
279630 | 279630 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000081 | 451 | ELEELE | Regular School | No | 1 | PK | 5 | 2015 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
109565 | 109565 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000001 | 302 | ENCHANTED LAKE | Regular School | No | 1 | PK | 6 | 2016 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128568 | 128568 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000001 | 302 | ENCHANTED LAKE | Regular School | No | Elementary | PK | 6 | 2017 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
279545 | 279545 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000001 | 302 | ENCHANTED LAKE | Regular School | No | 1 | PK | 6 | 2015 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
109507 | 109507 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000132 | 254 | EWA BEACH EL | Regular School | No | 1 | PK | 6 | 2016 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128510 | 128510 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000132 | 254 | EWA BEACH EL | Regular School | No | Elementary | PK | 6 | 2017 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
279488 | 279488 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000132 | 254 | EWA BEACH EL | Regular School | No | 1 | PK | 6 | 2015 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
109508 | 109508 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000133 | 253 | EWA EL | Regular School | No | 1 | PK | 6 | 2016 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128511 | 128511 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000133 | 253 | EWA EL | Regular School | No | Elementary | PK | 6 | 2017 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
279489 | 279489 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000133 | 253 | EWA EL | Regular School | No | 1 | PK | 6 | 2015 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
109509 | 109509 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000296 | 296 | EWA MAKAI MID | Regular School | No | 2 | 07 | 8 | 2016 | grade_7 | 448.0 | 448 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128512 | 128512 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000296 | 296 | EWA MAKAI MID | Regular School | No | Middle | 07 | 8 | 2017 | grade_7 | 448.0 | 448 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
279490 | 279490 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000296 | 296 | EWA MAKAI MID | Regular School | No | 2 | 07 | 8 | 2015 | grade_7 | 442.0 | 442 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2430757 | 2430757 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000081 | 451 | Eleele Elem | Regular School | No | Elementary | PK | 5 | 2020 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2455446 | 2455446 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000081 | 451 | Eleele Elem | Regular School | No | Elementary | PK | 5 | 2021 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2736420 | 2736420 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000081 | 451 | Eleele Elem | Regular School | No | Elementary | PK | 5 | 2019 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2781470 | 2781470 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000081 | 451 | Eleele Elem | Regular School | No | Elementary | PK | 5 | 2018 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2430672 | 2430672 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000001 | 302 | Enchanted Lake Elem | Regular School | No | Elementary | PK | 6 | 2020 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2455361 | 2455361 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000001 | 302 | Enchanted Lake Elem | Regular School | No | Elementary | PK | 6 | 2021 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2736335 | 2736335 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000001 | 302 | Enchanted Lake Elem | Regular School | No | Elementary | PK | 6 | 2019 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2781385 | 2781385 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000001 | 302 | Enchanted Lake Elem | Regular School | No | Elementary | PK | 6 | 2018 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2430614 | 2430614 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000132 | 254 | Ewa Beach Elem | Regular School | No | Elementary | PK | 6 | 2020 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2455302 | 2455302 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000132 | 254 | Ewa Beach Elem | Regular School | No | Elementary | PK | 5 | 2021 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2736277 | 2736277 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000132 | 254 | Ewa Beach Elem | Regular School | No | Elementary | PK | 6 | 2019 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2781327 | 2781327 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000132 | 254 | Ewa Beach Elem | Regular School | No | Elementary | PK | 6 | 2018 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2430615 | 2430615 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000133 | 253 | Ewa Elem | Regular School | No | Elementary | PK | 6 | 2020 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2455303 | 2455303 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000133 | 253 | Ewa Elem | Regular School | No | Elementary | PK | 5 | 2021 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2736278 | 2736278 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000133 | 253 | Ewa Elem | Regular School | No | Elementary | PK | 6 | 2019 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2781328 | 2781328 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000133 | 253 | Ewa Elem | Regular School | No | Elementary | PK | 6 | 2018 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2736279 | 2736279 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000296 | 296 | Ewa Makai Middle | Regular School | No | Middle | 07 | 8 | 2019 | grade_7 | 422.0 | 422 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2781329 | 2781329 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000296 | 296 | Ewa Makai Middle | Regular School | No | Middle | 07 | 8 | 2018 | grade_7 | 391.0 | 391 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
109412 | 109412 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000221 | 106 | FARRINGTON HI | Regular School | No | 3 | 09 | 12 | 2016 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128415 | 128415 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000221 | 106 | FARRINGTON HI | Regular School | No | High | 09 | 12 | 2017 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
279393 | 279393 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000221 | 106 | FARRINGTON HI | Regular School | No | 3 | 09 | 12 | 2015 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
109413 | 109413 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000220 | 107 | FERN | Regular School | No | 1 | PK | 5 | 2016 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128416 | 128416 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000220 | 107 | FERN | Regular School | No | Elementary | PK | 5 | 2017 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
279394 | 279394 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000220 | 107 | FERN | Regular School | No | 1 | PK | 5 | 2015 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2430519 | 2430519 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000221 | 106 | Farrington High | Regular School | No | High | 09 | 12 | 2020 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2455207 | 2455207 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000221 | 106 | Farrington High | Regular School | No | High | 09 | 12 | 2021 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2736182 | 2736182 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000221 | 106 | Farrington High | Regular School | No | High | 09 | 12 | 2019 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2781232 | 2781232 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000221 | 106 | Farrington High | Regular School | No | High | 09 | 12 | 2018 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2430520 | 2430520 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000220 | 107 | Fern Elem | Regular School | No | Elementary | PK | 5 | 2020 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2455208 | 2455208 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000220 | 107 | Fern Elem | Regular School | No | Elementary | PK | 5 | 2021 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2736183 | 2736183 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000220 | 107 | Fern Elem | Regular School | No | Elementary | PK | 5 | 2019 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2781233 | 2781233 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000220 | 107 | Fern Elem | Regular School | No | Elementary | PK | 5 | 2018 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
109579 | 109579 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000028 | 352 | HAAHEO | Regular School | No | 1 | PK | 6 | 2016 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128582 | 128582 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000028 | 352 | HAAHEO | Regular School | No | Elementary | PK | 6 | 2017 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
279559 | 279559 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000028 | 352 | HAAHEO | Regular School | No | 1 | PK | 6 | 2015 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
109414 | 109414 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000219 | 108 | HAHAIONE | Regular School | No | 1 | PK | 5 | 2016 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128417 | 128417 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000219 | 108 | HAHAIONE | Regular School | No | Elementary | PK | 5 | 2017 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
279395 | 279395 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000219 | 108 | HAHAIONE | Regular School | No | 1 | PK | 5 | 2015 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
109620 | 109620 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000057 | 401 | HAIKU | Regular School | No | 1 | PK | 5 | 2016 | grade_7 | 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]);