enrollments
Data source: Big Local News · About: Big Local
4,350 rows where state = "HI" and year = 2017 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
126504 | 126504 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000136 | 250 | AHRENS | Regular School | No | Elementary | PK | 6 | 2017 | kindergarten | 167.0 | 167 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126794 | 126794 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000136 | 250 | AHRENS | Regular School | No | Elementary | PK | 6 | 2017 | grade_1 | 159.0 | 159 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127084 | 127084 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000136 | 250 | AHRENS | Regular School | No | Elementary | PK | 6 | 2017 | grade_2 | 132.0 | 132 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127374 | 127374 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000136 | 250 | AHRENS | Regular School | No | Elementary | PK | 6 | 2017 | grade_3 | 171.0 | 171 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127664 | 127664 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000136 | 250 | AHRENS | Regular School | No | Elementary | PK | 6 | 2017 | grade_4 | 184.0 | 184 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127954 | 127954 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000136 | 250 | AHRENS | Regular School | No | Elementary | PK | 6 | 2017 | grade_5 | 173.0 | 173 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128244 | 128244 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000136 | 250 | AHRENS | Regular School | No | Elementary | PK | 6 | 2017 | grade_6 | 196.0 | 196 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128534 | 128534 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000136 | 250 | AHRENS | Regular School | No | Elementary | PK | 6 | 2017 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128824 | 128824 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000136 | 250 | AHRENS | Regular School | No | Elementary | PK | 6 | 2017 | grade_8 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
129114 | 129114 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000136 | 250 | AHRENS | Regular School | No | Elementary | PK | 6 | 2017 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
129404 | 129404 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000136 | 250 | AHRENS | Regular School | No | Elementary | PK | 6 | 2017 | grade_10 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
129694 | 129694 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000136 | 250 | AHRENS | Regular School | No | Elementary | PK | 6 | 2017 | grade_11 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
129984 | 129984 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000136 | 250 | AHRENS | Regular School | No | Elementary | PK | 6 | 2017 | grade_12 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
130274 | 130274 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000136 | 250 | AHRENS | Regular School | No | Elementary | PK | 6 | 2017 | pre_kindergarten | 7.0 | 7 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
130564 | 130564 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000136 | 250 | AHRENS | Regular School | No | Elementary | PK | 6 | 2017 | pk_12_total | 80.0 | 1269.0 | 80 | 1269 | ||||||||||||||||||||||||||||||||||||||||||||||||||
126521 | 126521 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000157 | 335 | AHUIMANU | Regular School | No | Elementary | PK | 6 | 2017 | kindergarten | 42.0 | 42 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126811 | 126811 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000157 | 335 | AHUIMANU | Regular School | No | Elementary | PK | 6 | 2017 | grade_1 | 44.0 | 44 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127101 | 127101 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000157 | 335 | AHUIMANU | Regular School | No | Elementary | PK | 6 | 2017 | grade_2 | 31.0 | 31 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127391 | 127391 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000157 | 335 | AHUIMANU | Regular School | No | Elementary | PK | 6 | 2017 | grade_3 | 40.0 | 40 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127681 | 127681 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000157 | 335 | AHUIMANU | Regular School | No | Elementary | PK | 6 | 2017 | grade_4 | 35.0 | 35 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127971 | 127971 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000157 | 335 | AHUIMANU | Regular School | No | Elementary | PK | 6 | 2017 | grade_5 | 31.0 | 31 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128261 | 128261 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000157 | 335 | AHUIMANU | Regular School | No | Elementary | PK | 6 | 2017 | grade_6 | 38.0 | 38 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128551 | 128551 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000157 | 335 | AHUIMANU | Regular School | No | Elementary | PK | 6 | 2017 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128841 | 128841 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000157 | 335 | AHUIMANU | Regular School | No | Elementary | PK | 6 | 2017 | grade_8 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
129131 | 129131 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000157 | 335 | AHUIMANU | Regular School | No | Elementary | PK | 6 | 2017 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
129421 | 129421 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000157 | 335 | AHUIMANU | Regular School | No | Elementary | PK | 6 | 2017 | grade_10 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
129711 | 129711 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000157 | 335 | AHUIMANU | Regular School | No | Elementary | PK | 6 | 2017 | grade_11 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
130001 | 130001 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000157 | 335 | AHUIMANU | Regular School | No | Elementary | PK | 6 | 2017 | grade_12 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
130291 | 130291 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000157 | 335 | AHUIMANU | Regular School | No | Elementary | PK | 6 | 2017 | pre_kindergarten | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
130581 | 130581 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000157 | 335 | AHUIMANU | Regular School | No | Elementary | PK | 6 | 2017 | pk_12_total | 39.0 | 300.0 | 39 | 300 | ||||||||||||||||||||||||||||||||||||||||||||||||||
126436 | 126436 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000178 | 200 | AIEA EL | Regular School | No | Elementary | PK | 6 | 2017 | kindergarten | 49.0 | 49 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126726 | 126726 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000178 | 200 | AIEA EL | Regular School | No | Elementary | PK | 6 | 2017 | grade_1 | 54.0 | 54 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127016 | 127016 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000178 | 200 | AIEA EL | Regular School | No | Elementary | PK | 6 | 2017 | grade_2 | 33.0 | 33 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127306 | 127306 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000178 | 200 | AIEA EL | Regular School | No | Elementary | PK | 6 | 2017 | grade_3 | 44.0 | 44 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127596 | 127596 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000178 | 200 | AIEA EL | Regular School | No | Elementary | PK | 6 | 2017 | grade_4 | 61.0 | 61 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127886 | 127886 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000178 | 200 | AIEA EL | Regular School | No | Elementary | PK | 6 | 2017 | grade_5 | 48.0 | 48 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128176 | 128176 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000178 | 200 | AIEA EL | Regular School | No | Elementary | PK | 6 | 2017 | grade_6 | 39.0 | 39 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128466 | 128466 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000178 | 200 | AIEA EL | Regular School | No | Elementary | PK | 6 | 2017 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128756 | 128756 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000178 | 200 | AIEA EL | Regular School | No | Elementary | PK | 6 | 2017 | grade_8 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
129046 | 129046 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000178 | 200 | AIEA EL | Regular School | No | Elementary | PK | 6 | 2017 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
129336 | 129336 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000178 | 200 | AIEA EL | Regular School | No | Elementary | PK | 6 | 2017 | grade_10 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
129626 | 129626 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000178 | 200 | AIEA EL | Regular School | No | Elementary | PK | 6 | 2017 | grade_11 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
129916 | 129916 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000178 | 200 | AIEA EL | Regular School | No | Elementary | PK | 6 | 2017 | grade_12 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
130206 | 130206 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000178 | 200 | AIEA EL | Regular School | No | Elementary | PK | 6 | 2017 | pre_kindergarten | 3.0 | 3 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
130496 | 130496 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000178 | 200 | AIEA EL | Regular School | No | Elementary | PK | 6 | 2017 | pk_12_total | 42.0 | 373.0 | 42 | 373 | ||||||||||||||||||||||||||||||||||||||||||||||||||
126437 | 126437 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000177 | 202 | AIEA HI | Regular School | No | High | 09 | 12 | 2017 | kindergarten | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126727 | 126727 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000177 | 202 | AIEA HI | Regular School | No | High | 09 | 12 | 2017 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127017 | 127017 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000177 | 202 | AIEA HI | Regular School | No | High | 09 | 12 | 2017 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127307 | 127307 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000177 | 202 | AIEA HI | Regular School | No | High | 09 | 12 | 2017 | grade_3 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127597 | 127597 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000177 | 202 | AIEA HI | Regular School | No | High | 09 | 12 | 2017 | grade_4 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127887 | 127887 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000177 | 202 | AIEA HI | Regular School | No | High | 09 | 12 | 2017 | grade_5 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128177 | 128177 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000177 | 202 | AIEA HI | Regular School | No | High | 09 | 12 | 2017 | grade_6 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128467 | 128467 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000177 | 202 | AIEA HI | Regular School | No | High | 09 | 12 | 2017 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128757 | 128757 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000177 | 202 | AIEA HI | Regular School | No | High | 09 | 12 | 2017 | grade_8 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
129047 | 129047 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000177 | 202 | AIEA HI | Regular School | No | High | 09 | 12 | 2017 | grade_9 | 262.0 | 262 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
129337 | 129337 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000177 | 202 | AIEA HI | Regular School | No | High | 09 | 12 | 2017 | grade_10 | 241.0 | 241 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
129627 | 129627 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000177 | 202 | AIEA HI | Regular School | No | High | 09 | 12 | 2017 | grade_11 | 218.0 | 218 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
129917 | 129917 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000177 | 202 | AIEA HI | Regular School | No | High | 09 | 12 | 2017 | grade_12 | 172.0 | 172 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
130207 | 130207 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000177 | 202 | AIEA HI | Regular School | No | High | 09 | 12 | 2017 | pre_kindergarten | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
130497 | 130497 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000177 | 202 | AIEA HI | Regular School | No | High | 09 | 12 | 2017 | pk_12_total | 138.0 | 1031.0 | 138 | 1031 | ||||||||||||||||||||||||||||||||||||||||||||||||||
126438 | 126438 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000176 | 201 | AIEA INT | Regular School | No | Middle | 07 | 8 | 2017 | kindergarten | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126728 | 126728 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000176 | 201 | AIEA INT | Regular School | No | Middle | 07 | 8 | 2017 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127018 | 127018 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000176 | 201 | AIEA INT | Regular School | No | Middle | 07 | 8 | 2017 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127308 | 127308 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000176 | 201 | AIEA INT | Regular School | No | Middle | 07 | 8 | 2017 | grade_3 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127598 | 127598 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000176 | 201 | AIEA INT | Regular School | No | Middle | 07 | 8 | 2017 | grade_4 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127888 | 127888 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000176 | 201 | AIEA INT | Regular School | No | Middle | 07 | 8 | 2017 | grade_5 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128178 | 128178 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000176 | 201 | AIEA INT | Regular School | No | Middle | 07 | 8 | 2017 | grade_6 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128468 | 128468 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000176 | 201 | AIEA INT | Regular School | No | Middle | 07 | 8 | 2017 | grade_7 | 258.0 | 258 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128758 | 128758 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000176 | 201 | AIEA INT | Regular School | No | Middle | 07 | 8 | 2017 | grade_8 | 261.0 | 261 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
129048 | 129048 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000176 | 201 | AIEA INT | Regular School | No | Middle | 07 | 8 | 2017 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
129338 | 129338 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000176 | 201 | AIEA INT | Regular School | No | Middle | 07 | 8 | 2017 | grade_10 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
129628 | 129628 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000176 | 201 | AIEA INT | Regular School | No | Middle | 07 | 8 | 2017 | grade_11 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
129918 | 129918 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000176 | 201 | AIEA INT | Regular School | No | Middle | 07 | 8 | 2017 | grade_12 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
130208 | 130208 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000176 | 201 | AIEA INT | Regular School | No | Middle | 07 | 8 | 2017 | pre_kindergarten | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
130498 | 130498 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000176 | 201 | AIEA INT | Regular School | No | Middle | 07 | 8 | 2017 | pk_12_total | 67.0 | 586.0 | 67 | 586 | ||||||||||||||||||||||||||||||||||||||||||||||||||
126537 | 126537 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000101 | 300 | AIKAHI | Regular School | No | Elementary | PK | 6 | 2017 | kindergarten | 74.0 | 74 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126827 | 126827 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000101 | 300 | AIKAHI | Regular School | No | Elementary | PK | 6 | 2017 | grade_1 | 64.0 | 64 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127117 | 127117 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000101 | 300 | AIKAHI | Regular School | No | Elementary | PK | 6 | 2017 | grade_2 | 62.0 | 62 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127407 | 127407 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000101 | 300 | AIKAHI | Regular School | No | Elementary | PK | 6 | 2017 | grade_3 | 63.0 | 63 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127697 | 127697 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000101 | 300 | AIKAHI | Regular School | No | Elementary | PK | 6 | 2017 | grade_4 | 59.0 | 59 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127987 | 127987 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000101 | 300 | AIKAHI | Regular School | No | Elementary | PK | 6 | 2017 | grade_5 | 61.0 | 61 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128277 | 128277 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000101 | 300 | AIKAHI | Regular School | No | Elementary | PK | 6 | 2017 | grade_6 | 43.0 | 43 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128567 | 128567 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000101 | 300 | AIKAHI | Regular School | No | Elementary | PK | 6 | 2017 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128857 | 128857 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000101 | 300 | AIKAHI | Regular School | No | Elementary | PK | 6 | 2017 | grade_8 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
129147 | 129147 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000101 | 300 | AIKAHI | Regular School | No | Elementary | PK | 6 | 2017 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
129437 | 129437 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000101 | 300 | AIKAHI | Regular School | No | Elementary | PK | 6 | 2017 | grade_10 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
129727 | 129727 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000101 | 300 | AIKAHI | Regular School | No | Elementary | PK | 6 | 2017 | grade_11 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
130017 | 130017 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000101 | 300 | AIKAHI | Regular School | No | Elementary | PK | 6 | 2017 | grade_12 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
130307 | 130307 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000101 | 300 | AIKAHI | Regular School | No | Elementary | PK | 6 | 2017 | pre_kindergarten | 6.0 | 6 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
130597 | 130597 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000101 | 300 | AIKAHI | Regular School | No | Elementary | PK | 6 | 2017 | pk_12_total | 35.0 | 467.0 | 35 | 467 | ||||||||||||||||||||||||||||||||||||||||||||||||||
126383 | 126383 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000227 | 100 | AINA HAINA | Regular School | No | Elementary | PK | 5 | 2017 | kindergarten | 85.0 | 85 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126673 | 126673 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000227 | 100 | AINA HAINA | Regular School | No | Elementary | PK | 5 | 2017 | grade_1 | 71.0 | 71 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126963 | 126963 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000227 | 100 | AINA HAINA | Regular School | No | Elementary | PK | 5 | 2017 | grade_2 | 51.0 | 51 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127253 | 127253 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000227 | 100 | AINA HAINA | Regular School | No | Elementary | PK | 5 | 2017 | grade_3 | 74.0 | 74 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127543 | 127543 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000227 | 100 | AINA HAINA | Regular School | No | Elementary | PK | 5 | 2017 | grade_4 | 86.0 | 86 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127833 | 127833 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000227 | 100 | AINA HAINA | Regular School | No | Elementary | PK | 5 | 2017 | grade_5 | 80.0 | 80 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128123 | 128123 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000227 | 100 | AINA HAINA | Regular School | No | Elementary | PK | 5 | 2017 | grade_6 | 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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128703 | 128703 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000227 | 100 | AINA HAINA | Regular School | No | Elementary | PK | 5 | 2017 | grade_8 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128993 | 128993 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000227 | 100 | AINA HAINA | Regular School | No | Elementary | PK | 5 | 2017 | grade_9 | 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]);