enrollments
Data source: Big Local News · About: Big Local
4,395 rows where state = "HI" and year = 2020 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2428604 | 2428604 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000157 | 335 | Ahuimanu Elem | Regular School | No | Elementary | PK | 6 | 2020 | kindergarten | 31.0 | 31 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2428897 | 2428897 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000157 | 335 | Ahuimanu Elem | Regular School | No | Elementary | PK | 6 | 2020 | grade_1 | 39.0 | 39 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2429190 | 2429190 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000157 | 335 | Ahuimanu Elem | Regular School | No | Elementary | PK | 6 | 2020 | grade_2 | 33.0 | 33 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2429483 | 2429483 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000157 | 335 | Ahuimanu Elem | Regular School | No | Elementary | PK | 6 | 2020 | grade_3 | 39.0 | 39 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2429776 | 2429776 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000157 | 335 | Ahuimanu Elem | Regular School | No | Elementary | PK | 6 | 2020 | grade_4 | 33.0 | 33 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2430069 | 2430069 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000157 | 335 | Ahuimanu Elem | Regular School | No | Elementary | PK | 6 | 2020 | grade_5 | 34.0 | 34 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2430362 | 2430362 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000157 | 335 | Ahuimanu Elem | Regular School | No | Elementary | PK | 6 | 2020 | grade_6 | 39.0 | 39 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2430655 | 2430655 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000157 | 335 | Ahuimanu Elem | Regular School | No | Elementary | PK | 6 | 2020 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2430948 | 2430948 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000157 | 335 | Ahuimanu Elem | Regular School | No | Elementary | PK | 6 | 2020 | grade_8 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2431241 | 2431241 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000157 | 335 | Ahuimanu Elem | Regular School | No | Elementary | PK | 6 | 2020 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2431534 | 2431534 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000157 | 335 | Ahuimanu Elem | Regular School | No | Elementary | PK | 6 | 2020 | grade_10 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2431827 | 2431827 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000157 | 335 | Ahuimanu Elem | Regular School | No | Elementary | PK | 6 | 2020 | grade_11 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2432120 | 2432120 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000157 | 335 | Ahuimanu Elem | Regular School | No | Elementary | PK | 6 | 2020 | grade_12 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2432413 | 2432413 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000157 | 335 | Ahuimanu Elem | Regular School | No | Elementary | PK | 6 | 2020 | pre_kindergarten | 1.0 | 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2432706 | 2432706 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000157 | 335 | Ahuimanu Elem | Regular School | No | Elementary | PK | 6 | 2020 | pk_12_total | 39.0 | 288.0 | 39 | 288 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2428519 | 2428519 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000178 | 200 | Aiea Elem | Regular School | No | Elementary | PK | 6 | 2020 | kindergarten | 36.0 | 36 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2428812 | 2428812 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000178 | 200 | Aiea Elem | Regular School | No | Elementary | PK | 6 | 2020 | grade_1 | 35.0 | 35 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2429105 | 2429105 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000178 | 200 | Aiea Elem | Regular School | No | Elementary | PK | 6 | 2020 | grade_2 | 42.0 | 42 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2429398 | 2429398 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000178 | 200 | Aiea Elem | Regular School | No | Elementary | PK | 6 | 2020 | grade_3 | 43.0 | 43 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2429691 | 2429691 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000178 | 200 | Aiea Elem | Regular School | No | Elementary | PK | 6 | 2020 | grade_4 | 49.0 | 49 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2429984 | 2429984 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000178 | 200 | Aiea Elem | Regular School | No | Elementary | PK | 6 | 2020 | grade_5 | 33.0 | 33 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2430277 | 2430277 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000178 | 200 | Aiea Elem | Regular School | No | Elementary | PK | 6 | 2020 | grade_6 | 45.0 | 45 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2430570 | 2430570 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000178 | 200 | Aiea Elem | Regular School | No | Elementary | PK | 6 | 2020 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2430863 | 2430863 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000178 | 200 | Aiea Elem | Regular School | No | Elementary | PK | 6 | 2020 | grade_8 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2431156 | 2431156 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000178 | 200 | Aiea Elem | Regular School | No | Elementary | PK | 6 | 2020 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2431449 | 2431449 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000178 | 200 | Aiea Elem | Regular School | No | Elementary | PK | 6 | 2020 | grade_10 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2431742 | 2431742 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000178 | 200 | Aiea Elem | Regular School | No | Elementary | PK | 6 | 2020 | grade_11 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2432035 | 2432035 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000178 | 200 | Aiea Elem | Regular School | No | Elementary | PK | 6 | 2020 | grade_12 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2432328 | 2432328 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000178 | 200 | Aiea Elem | Regular School | No | Elementary | PK | 6 | 2020 | pre_kindergarten | 7.0 | 7 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2432621 | 2432621 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000178 | 200 | Aiea Elem | Regular School | No | Elementary | PK | 6 | 2020 | pk_12_total | 33.0 | 323.0 | 33 | 323 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2428520 | 2428520 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000177 | 202 | Aiea High | Regular School | No | High | 09 | 12 | 2020 | kindergarten | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2428813 | 2428813 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000177 | 202 | Aiea High | Regular School | No | High | 09 | 12 | 2020 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2429106 | 2429106 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000177 | 202 | Aiea High | Regular School | No | High | 09 | 12 | 2020 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2429399 | 2429399 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000177 | 202 | Aiea High | Regular School | No | High | 09 | 12 | 2020 | grade_3 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2429692 | 2429692 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000177 | 202 | Aiea High | Regular School | No | High | 09 | 12 | 2020 | grade_4 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2429985 | 2429985 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000177 | 202 | Aiea High | Regular School | No | High | 09 | 12 | 2020 | grade_5 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2430278 | 2430278 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000177 | 202 | Aiea High | Regular School | No | High | 09 | 12 | 2020 | grade_6 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2430571 | 2430571 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000177 | 202 | Aiea High | Regular School | No | High | 09 | 12 | 2020 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2430864 | 2430864 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000177 | 202 | Aiea High | Regular School | No | High | 09 | 12 | 2020 | grade_8 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2431157 | 2431157 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000177 | 202 | Aiea High | Regular School | No | High | 09 | 12 | 2020 | grade_9 | 257.0 | 257 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2431450 | 2431450 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000177 | 202 | Aiea High | Regular School | No | High | 09 | 12 | 2020 | grade_10 | 208.0 | 208 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2431743 | 2431743 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000177 | 202 | Aiea High | Regular School | No | High | 09 | 12 | 2020 | grade_11 | 188.0 | 188 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2432036 | 2432036 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000177 | 202 | Aiea High | Regular School | No | High | 09 | 12 | 2020 | grade_12 | 218.0 | 218 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2432329 | 2432329 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000177 | 202 | Aiea High | Regular School | No | High | 09 | 12 | 2020 | pre_kindergarten | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2432622 | 2432622 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000177 | 202 | Aiea High | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 129.0 | 1000.0 | 129 | 1000 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2428521 | 2428521 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000176 | 201 | Aiea Int | Regular School | No | Middle | 07 | 8 | 2020 | kindergarten | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2428814 | 2428814 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000176 | 201 | Aiea Int | Regular School | No | Middle | 07 | 8 | 2020 | grade_1 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2429107 | 2429107 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000176 | 201 | Aiea Int | Regular School | No | Middle | 07 | 8 | 2020 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2429400 | 2429400 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000176 | 201 | Aiea Int | Regular School | No | Middle | 07 | 8 | 2020 | grade_3 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2429693 | 2429693 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000176 | 201 | Aiea Int | Regular School | No | Middle | 07 | 8 | 2020 | grade_4 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2429986 | 2429986 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000176 | 201 | Aiea Int | Regular School | No | Middle | 07 | 8 | 2020 | grade_5 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2430279 | 2430279 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000176 | 201 | Aiea Int | Regular School | No | Middle | 07 | 8 | 2020 | grade_6 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2430572 | 2430572 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000176 | 201 | Aiea Int | Regular School | No | Middle | 07 | 8 | 2020 | grade_7 | 273.0 | 273 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2430865 | 2430865 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000176 | 201 | Aiea Int | Regular School | No | Middle | 07 | 8 | 2020 | grade_8 | 279.0 | 279 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2431158 | 2431158 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000176 | 201 | Aiea Int | Regular School | No | Middle | 07 | 8 | 2020 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2431451 | 2431451 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000176 | 201 | Aiea Int | Regular School | No | Middle | 07 | 8 | 2020 | grade_10 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2431744 | 2431744 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000176 | 201 | Aiea Int | Regular School | No | Middle | 07 | 8 | 2020 | grade_11 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2432037 | 2432037 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000176 | 201 | Aiea Int | Regular School | No | Middle | 07 | 8 | 2020 | grade_12 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2432330 | 2432330 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000176 | 201 | Aiea Int | Regular School | No | Middle | 07 | 8 | 2020 | pre_kindergarten | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2432623 | 2432623 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000176 | 201 | Aiea Int | Regular School | No | Middle | 07 | 8 | 2020 | pk_12_total | 53.0 | 605.0 | 53 | 605 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2428620 | 2428620 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000101 | 300 | Aikahi Elem | Regular School | No | Elementary | PK | 6 | 2020 | kindergarten | 84.0 | 84 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2428913 | 2428913 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000101 | 300 | Aikahi Elem | Regular School | No | Elementary | PK | 6 | 2020 | grade_1 | 69.0 | 69 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2429206 | 2429206 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000101 | 300 | Aikahi Elem | Regular School | No | Elementary | PK | 6 | 2020 | grade_2 | 57.0 | 57 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2429499 | 2429499 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000101 | 300 | Aikahi Elem | Regular School | No | Elementary | PK | 6 | 2020 | grade_3 | 68.0 | 68 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2429792 | 2429792 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000101 | 300 | Aikahi Elem | Regular School | No | Elementary | PK | 6 | 2020 | grade_4 | 58.0 | 58 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2430085 | 2430085 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000101 | 300 | Aikahi Elem | Regular School | No | Elementary | PK | 6 | 2020 | grade_5 | 59.0 | 59 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2430378 | 2430378 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000101 | 300 | Aikahi Elem | Regular School | No | Elementary | PK | 6 | 2020 | grade_6 | 69.0 | 69 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2430671 | 2430671 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000101 | 300 | Aikahi Elem | Regular School | No | Elementary | PK | 6 | 2020 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2430964 | 2430964 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000101 | 300 | Aikahi Elem | Regular School | No | Elementary | PK | 6 | 2020 | grade_8 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2431257 | 2431257 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000101 | 300 | Aikahi Elem | Regular School | No | Elementary | PK | 6 | 2020 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2431550 | 2431550 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000101 | 300 | Aikahi Elem | Regular School | No | Elementary | PK | 6 | 2020 | grade_10 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2431843 | 2431843 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000101 | 300 | Aikahi Elem | Regular School | No | Elementary | PK | 6 | 2020 | grade_11 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2432136 | 2432136 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000101 | 300 | Aikahi Elem | Regular School | No | Elementary | PK | 6 | 2020 | grade_12 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2432429 | 2432429 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000101 | 300 | Aikahi Elem | Regular School | No | Elementary | PK | 6 | 2020 | pre_kindergarten | 6.0 | 6 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2432722 | 2432722 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000101 | 300 | Aikahi Elem | Regular School | No | Elementary | PK | 6 | 2020 | pk_12_total | 33.0 | 503.0 | 33 | 503 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2428466 | 2428466 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000227 | 100 | Aina Haina Elem | Regular School | No | Elementary | PK | 5 | 2020 | kindergarten | 59.0 | 59 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2428759 | 2428759 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000227 | 100 | Aina Haina Elem | Regular School | No | Elementary | PK | 5 | 2020 | grade_1 | 77.0 | 77 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2429052 | 2429052 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000227 | 100 | Aina Haina Elem | Regular School | No | Elementary | PK | 5 | 2020 | grade_2 | 68.0 | 68 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2429345 | 2429345 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000227 | 100 | Aina Haina Elem | Regular School | No | Elementary | PK | 5 | 2020 | grade_3 | 91.0 | 91 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2429638 | 2429638 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000227 | 100 | Aina Haina Elem | Regular School | No | Elementary | PK | 5 | 2020 | grade_4 | 72.0 | 72 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2429931 | 2429931 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000227 | 100 | Aina Haina Elem | Regular School | No | Elementary | PK | 5 | 2020 | grade_5 | 60.0 | 60 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2430224 | 2430224 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000227 | 100 | Aina Haina Elem | Regular School | No | Elementary | PK | 5 | 2020 | grade_6 | 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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2430810 | 2430810 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000227 | 100 | Aina Haina Elem | Regular School | No | Elementary | PK | 5 | 2020 | grade_8 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2431103 | 2431103 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000227 | 100 | Aina Haina Elem | Regular School | No | Elementary | PK | 5 | 2020 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2431396 | 2431396 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000227 | 100 | Aina Haina Elem | Regular School | No | Elementary | PK | 5 | 2020 | grade_10 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2431689 | 2431689 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000227 | 100 | Aina Haina Elem | Regular School | No | Elementary | PK | 5 | 2020 | grade_11 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2431982 | 2431982 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000227 | 100 | Aina Haina Elem | Regular School | No | Elementary | PK | 5 | 2020 | grade_12 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2432275 | 2432275 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000227 | 100 | Aina Haina Elem | Regular School | No | Elementary | PK | 5 | 2020 | pre_kindergarten | 4.0 | 4 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2432568 | 2432568 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000227 | 100 | Aina Haina Elem | Regular School | No | Elementary | PK | 5 | 2020 | pk_12_total | 31.0 | 462.0 | 31 | 462 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2428491 | 2428491 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000226 | 101 | Ala Wai Elem | Regular School | No | Elementary | PK | 5 | 2020 | kindergarten | 50.0 | 50 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2428784 | 2428784 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000226 | 101 | Ala Wai Elem | Regular School | No | Elementary | PK | 5 | 2020 | grade_1 | 59.0 | 59 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2429077 | 2429077 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000226 | 101 | Ala Wai Elem | Regular School | No | Elementary | PK | 5 | 2020 | grade_2 | 60.0 | 60 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2429370 | 2429370 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000226 | 101 | Ala Wai Elem | Regular School | No | Elementary | PK | 5 | 2020 | grade_3 | 52.0 | 52 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2429663 | 2429663 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000226 | 101 | Ala Wai Elem | Regular School | No | Elementary | PK | 5 | 2020 | grade_4 | 50.0 | 50 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2429956 | 2429956 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000226 | 101 | Ala Wai Elem | Regular School | No | Elementary | PK | 5 | 2020 | grade_5 | 43.0 | 43 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2430249 | 2430249 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000226 | 101 | Ala Wai Elem | Regular School | No | Elementary | PK | 5 | 2020 | grade_6 | 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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2430835 | 2430835 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000226 | 101 | Ala Wai Elem | Regular School | No | Elementary | PK | 5 | 2020 | grade_8 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2431128 | 2431128 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000226 | 101 | Ala Wai Elem | Regular School | No | Elementary | PK | 5 | 2020 | 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]);