enrollments
Data source: Big Local News · About: Big Local
2,040 rows where grade = "grade_7" and state = "HI" sorted by school_state_id
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
109410 | 109410 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000227 | 100 | AINA HAINA | Regular School | No | 1 | PK | 5 | 2016 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128413 | 128413 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000227 | 100 | AINA HAINA | Regular School | No | Elementary | PK | 5 | 2017 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
279391 | 279391 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000227 | 100 | AINA HAINA | Regular School | No | 1 | PK | 5 | 2015 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2430517 | 2430517 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000227 | 100 | Aina Haina Elem | Regular School | No | Elementary | PK | 5 | 2020 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2455205 | 2455205 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000227 | 100 | Aina Haina Elem | Regular School | No | Elementary | PK | 5 | 2021 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2736180 | 2736180 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000227 | 100 | Aina Haina Elem | Regular School | No | Elementary | PK | 5 | 2019 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2781230 | 2781230 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000227 | 100 | Aina Haina Elem | Regular School | No | Elementary | PK | 5 | 2018 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
109435 | 109435 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000226 | 101 | ALA WAI | Regular School | No | 1 | PK | 5 | 2016 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128438 | 128438 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000226 | 101 | ALA WAI | Regular School | No | Elementary | PK | 5 | 2017 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
279416 | 279416 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000226 | 101 | ALA WAI | Regular School | No | 1 | PK | 5 | 2015 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2430542 | 2430542 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000226 | 101 | Ala Wai Elem | Regular School | No | Elementary | PK | 5 | 2020 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2455230 | 2455230 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000226 | 101 | Ala Wai Elem | Regular School | No | Elementary | PK | 5 | 2021 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2736205 | 2736205 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000226 | 101 | Ala Wai Elem | Regular School | No | Elementary | PK | 5 | 2019 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2781255 | 2781255 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000226 | 101 | Ala Wai Elem | Regular School | No | Elementary | PK | 5 | 2018 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
109436 | 109436 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000225 | 102 | ALIIOLANI | Regular School | No | 1 | PK | 5 | 2016 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128439 | 128439 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000225 | 102 | ALIIOLANI | Regular School | No | Elementary | PK | 5 | 2017 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
279417 | 279417 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000225 | 102 | ALIIOLANI | Regular School | No | 1 | PK | 5 | 2015 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2430543 | 2430543 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000225 | 102 | Aliiolani Elem | Regular School | No | Elementary | PK | 5 | 2020 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2455231 | 2455231 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000225 | 102 | Aliiolani Elem | Regular School | No | Elementary | PK | 5 | 2021 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2736206 | 2736206 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000225 | 102 | Aliiolani Elem | Regular School | No | Elementary | PK | 5 | 2019 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2781256 | 2781256 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000225 | 102 | Aliiolani Elem | Regular School | No | Elementary | PK | 5 | 2018 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
109437 | 109437 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000246 | 103 | ANUENUE | Regular School | No | 4 | PK | 12 | 2016 | grade_7 | 34.0 | 34 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128440 | 128440 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000246 | 103 | ANUENUE | Regular School | No | Other | PK | 12 | 2017 | grade_7 | 28.0 | 28 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
279418 | 279418 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000246 | 103 | ANUENUE | Regular School | No | 4 | PK | 12 | 2015 | grade_7 | 37.0 | 37 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2430544 | 2430544 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000246 | 103 | Anuenue | Regular School | No | Other | PK | 12 | 2020 | grade_7 | 39.0 | 39 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2455232 | 2455232 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000246 | 103 | Anuenue | Regular School | No | Other | PK | 12 | 2021 | grade_7 | 47.0 | 47 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2736207 | 2736207 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000246 | 103 | Anuenue | Regular School | No | Other | PK | 12 | 2019 | grade_7 | 45.0 | 45 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2781257 | 2781257 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000246 | 103 | Anuenue | Regular School | No | Other | PK | 12 | 2018 | grade_7 | 25.0 | 25 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2430521 | 2430521 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000219 | 108 | Hahaione Elem | Regular School | No | Elementary | PK | 5 | 2020 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2455209 | 2455209 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000219 | 108 | Hahaione Elem | Regular School | No | Elementary | PK | 5 | 2021 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2736184 | 2736184 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000219 | 108 | Hahaione Elem | Regular School | No | Elementary | PK | 5 | 2019 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2781234 | 2781234 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000219 | 108 | Hahaione Elem | Regular School | No | Elementary | PK | 5 | 2018 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
109439 | 109439 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000214 | 109 | HOKULANI | Regular School | No | 1 | PK | 5 | 2016 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128442 | 128442 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000214 | 109 | HOKULANI | Regular School | No | Elementary | PK | 5 | 2017 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
279420 | 279420 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000214 | 109 | HOKULANI | Regular School | No | 1 | PK | 5 | 2015 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2430546 | 2430546 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000214 | 109 | Hokulani Elem | Regular School | No | Elementary | PK | 5 | 2020 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2455234 | 2455234 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000214 | 109 | Hokulani Elem | Regular School | No | Elementary | PK | 5 | 2021 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2736209 | 2736209 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000214 | 109 | Hokulani Elem | Regular School | No | Elementary | PK | 5 | 2019 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2781259 | 2781259 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000214 | 109 | Hokulani Elem | Regular School | No | Elementary | PK | 5 | 2018 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2781260 | 2781260 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000218 | 110 | Jarrett Middle | Regular School | No | Middle | 06 | 8 | 2018 | grade_7 | 69.0 | 69 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
109441 | 109441 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000213 | 111 | JEFFERSON | Regular School | No | 1 | PK | 5 | 2016 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128444 | 128444 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000213 | 111 | JEFFERSON | Regular School | No | Elementary | PK | 5 | 2017 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
279422 | 279422 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000213 | 111 | JEFFERSON | Regular School | No | 1 | PK | 5 | 2015 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2430548 | 2430548 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000213 | 111 | Jefferson Elem | Regular School | No | Elementary | PK | 5 | 2020 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2455236 | 2455236 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000213 | 111 | Jefferson Elem | Regular School | No | Elementary | PK | 5 | 2021 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2736211 | 2736211 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000213 | 111 | Jefferson Elem | Regular School | No | Elementary | PK | 5 | 2019 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2781261 | 2781261 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000213 | 111 | Jefferson Elem | Regular School | No | Elementary | PK | 5 | 2018 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
109442 | 109442 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000217 | 112 | KAAHUMANU | Regular School | No | 1 | PK | 5 | 2016 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128445 | 128445 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000217 | 112 | KAAHUMANU | Regular School | No | Elementary | PK | 5 | 2017 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
279423 | 279423 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000217 | 112 | KAAHUMANU | Regular School | No | 1 | PK | 5 | 2015 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2430549 | 2430549 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000217 | 112 | Kaahumanu Elem | Regular School | No | Elementary | PK | 5 | 2020 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2455237 | 2455237 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000217 | 112 | Kaahumanu Elem | Regular School | No | Elementary | PK | 5 | 2021 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2736212 | 2736212 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000217 | 112 | Kaahumanu Elem | Regular School | No | Elementary | PK | 5 | 2019 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2781262 | 2781262 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000217 | 112 | Kaahumanu Elem | Regular School | No | Elementary | PK | 5 | 2018 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
109416 | 109416 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000216 | 113 | KAEWAI | Regular School | No | 1 | PK | 5 | 2016 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128419 | 128419 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000216 | 113 | KAEWAI | Regular School | No | Elementary | PK | 5 | 2017 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
279397 | 279397 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000216 | 113 | KAEWAI | Regular School | No | 1 | PK | 5 | 2015 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2430523 | 2430523 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000216 | 113 | Kaewai Elem | Regular School | No | Elementary | PK | 5 | 2020 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2455211 | 2455211 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000216 | 113 | Kaewai Elem | Regular School | No | Elementary | PK | 5 | 2021 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2736186 | 2736186 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000216 | 113 | Kaewai Elem | Regular School | No | Elementary | PK | 5 | 2019 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2781236 | 2781236 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000216 | 113 | Kaewai Elem | Regular School | No | Elementary | PK | 5 | 2018 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
109417 | 109417 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000215 | 114 | KAHALA | Regular School | No | 1 | PK | 5 | 2016 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128420 | 128420 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000215 | 114 | KAHALA | Regular School | No | Elementary | PK | 5 | 2017 | 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]);