enrollments
Data source: Big Local News · About: Big Local
2,040 rows where grade = "grade_9" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
109990 | 109990 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000227 | 100 | AINA HAINA | Regular School | No | 1 | PK | 5 | 2016 | grade_9 | 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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
279969 | 279969 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000227 | 100 | AINA HAINA | Regular School | No | 1 | PK | 5 | 2015 | grade_9 | 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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2455793 | 2455793 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000227 | 100 | Aina Haina Elem | Regular School | No | Elementary | PK | 5 | 2021 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2736764 | 2736764 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000227 | 100 | Aina Haina Elem | Regular School | No | Elementary | PK | 5 | 2019 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2781814 | 2781814 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000227 | 100 | Aina Haina Elem | Regular School | No | Elementary | PK | 5 | 2018 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
110015 | 110015 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000226 | 101 | ALA WAI | Regular School | No | 1 | PK | 5 | 2016 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
129018 | 129018 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000226 | 101 | ALA WAI | Regular School | No | Elementary | PK | 5 | 2017 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
279994 | 279994 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000226 | 101 | ALA WAI | Regular School | No | 1 | PK | 5 | 2015 | grade_9 | 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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2455818 | 2455818 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000226 | 101 | Ala Wai Elem | Regular School | No | Elementary | PK | 5 | 2021 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2736789 | 2736789 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000226 | 101 | Ala Wai Elem | Regular School | No | Elementary | PK | 5 | 2019 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2781839 | 2781839 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000226 | 101 | Ala Wai Elem | Regular School | No | Elementary | PK | 5 | 2018 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
110016 | 110016 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000225 | 102 | ALIIOLANI | Regular School | No | 1 | PK | 5 | 2016 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
129019 | 129019 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000225 | 102 | ALIIOLANI | Regular School | No | Elementary | PK | 5 | 2017 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
279995 | 279995 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000225 | 102 | ALIIOLANI | Regular School | No | 1 | PK | 5 | 2015 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2431129 | 2431129 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000225 | 102 | Aliiolani Elem | Regular School | No | Elementary | PK | 5 | 2020 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2455819 | 2455819 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000225 | 102 | Aliiolani Elem | Regular School | No | Elementary | PK | 5 | 2021 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2736790 | 2736790 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000225 | 102 | Aliiolani Elem | Regular School | No | Elementary | PK | 5 | 2019 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2781840 | 2781840 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000225 | 102 | Aliiolani Elem | Regular School | No | Elementary | PK | 5 | 2018 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
110017 | 110017 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000246 | 103 | ANUENUE | Regular School | No | 4 | PK | 12 | 2016 | grade_9 | 20.0 | 20 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
129020 | 129020 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000246 | 103 | ANUENUE | Regular School | No | Other | PK | 12 | 2017 | grade_9 | 24.0 | 24 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
279996 | 279996 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000246 | 103 | ANUENUE | Regular School | No | 4 | PK | 12 | 2015 | grade_9 | 16.0 | 16 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2431130 | 2431130 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000246 | 103 | Anuenue | Regular School | No | Other | PK | 12 | 2020 | grade_9 | 23.0 | 23 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2455820 | 2455820 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000246 | 103 | Anuenue | Regular School | No | Other | PK | 12 | 2021 | grade_9 | 27.0 | 27 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2736791 | 2736791 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000246 | 103 | Anuenue | Regular School | No | Other | PK | 12 | 2019 | grade_9 | 24.0 | 24 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2781841 | 2781841 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000246 | 103 | Anuenue | Regular School | No | Other | PK | 12 | 2018 | grade_9 | 24.0 | 24 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
110018 | 110018 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000223 | 104 | CENTRAL MID | Regular School | No | 2 | 06 | 8 | 2016 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
129021 | 129021 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000223 | 104 | CENTRAL MID | Regular School | No | Middle | 06 | 8 | 2017 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
279997 | 279997 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000223 | 104 | CENTRAL MID | Regular School | No | 2 | 06 | 8 | 2015 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2431131 | 2431131 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000223 | 104 | Central Middle | Regular School | No | Middle | 06 | 8 | 2020 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2455821 | 2455821 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000223 | 104 | Central Middle | Regular School | No | Middle | 06 | 8 | 2021 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2736792 | 2736792 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000223 | 104 | Central Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2781842 | 2781842 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000223 | 104 | Central Middle | Regular School | No | Middle | 06 | 8 | 2018 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
109991 | 109991 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000222 | 105 | DOLE MID | Regular School | No | 2 | 06 | 8 | 2016 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128994 | 128994 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000222 | 105 | DOLE MID | Regular School | No | Middle | 06 | 8 | 2017 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
279970 | 279970 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000222 | 105 | DOLE MID | Regular School | No | 2 | 06 | 8 | 2015 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2431104 | 2431104 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000222 | 105 | Dole Middle | Regular School | No | Middle | 06 | 8 | 2020 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2455794 | 2455794 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000222 | 105 | Dole Middle | Regular School | No | Middle | 06 | 8 | 2021 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2736765 | 2736765 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000222 | 105 | Dole Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2781815 | 2781815 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000222 | 105 | Dole Middle | Regular School | No | Middle | 06 | 8 | 2018 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
109992 | 109992 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000221 | 106 | FARRINGTON HI | Regular School | No | 3 | 09 | 12 | 2016 | grade_9 | 607.0 | 607 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128995 | 128995 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000221 | 106 | FARRINGTON HI | Regular School | No | High | 09 | 12 | 2017 | grade_9 | 645.0 | 645 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
279971 | 279971 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000221 | 106 | FARRINGTON HI | Regular School | No | 3 | 09 | 12 | 2015 | grade_9 | 647.0 | 647 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2431105 | 2431105 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000221 | 106 | Farrington High | Regular School | No | High | 09 | 12 | 2020 | grade_9 | 676.0 | 676 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2455795 | 2455795 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000221 | 106 | Farrington High | Regular School | No | High | 09 | 12 | 2021 | grade_9 | 674.0 | 674 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2736766 | 2736766 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000221 | 106 | Farrington High | Regular School | No | High | 09 | 12 | 2019 | grade_9 | 652.0 | 652 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2781816 | 2781816 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000221 | 106 | Farrington High | Regular School | No | High | 09 | 12 | 2018 | grade_9 | 585.0 | 585 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
109993 | 109993 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000220 | 107 | FERN | Regular School | No | 1 | PK | 5 | 2016 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128996 | 128996 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000220 | 107 | FERN | Regular School | No | Elementary | PK | 5 | 2017 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
279972 | 279972 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000220 | 107 | FERN | Regular School | No | 1 | PK | 5 | 2015 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2431106 | 2431106 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000220 | 107 | Fern Elem | Regular School | No | Elementary | PK | 5 | 2020 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2455796 | 2455796 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000220 | 107 | Fern Elem | Regular School | No | Elementary | PK | 5 | 2021 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2736767 | 2736767 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000220 | 107 | Fern Elem | Regular School | No | Elementary | PK | 5 | 2019 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2781817 | 2781817 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000220 | 107 | Fern Elem | Regular School | No | Elementary | PK | 5 | 2018 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
109994 | 109994 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000219 | 108 | HAHAIONE | Regular School | No | 1 | PK | 5 | 2016 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128997 | 128997 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000219 | 108 | HAHAIONE | Regular School | No | Elementary | PK | 5 | 2017 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
279973 | 279973 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000219 | 108 | HAHAIONE | Regular School | No | 1 | PK | 5 | 2015 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2431107 | 2431107 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000219 | 108 | Hahaione Elem | Regular School | No | Elementary | PK | 5 | 2020 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2455797 | 2455797 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000219 | 108 | Hahaione Elem | Regular School | No | Elementary | PK | 5 | 2021 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2736768 | 2736768 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000219 | 108 | Hahaione Elem | Regular School | No | Elementary | PK | 5 | 2019 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2781818 | 2781818 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000219 | 108 | Hahaione Elem | Regular School | No | Elementary | PK | 5 | 2018 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
110019 | 110019 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000214 | 109 | HOKULANI | Regular School | No | 1 | PK | 5 | 2016 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
129022 | 129022 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000214 | 109 | HOKULANI | Regular School | No | Elementary | PK | 5 | 2017 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
279998 | 279998 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000214 | 109 | HOKULANI | Regular School | No | 1 | PK | 5 | 2015 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2431132 | 2431132 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000214 | 109 | Hokulani Elem | Regular School | No | Elementary | PK | 5 | 2020 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2455822 | 2455822 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000214 | 109 | Hokulani Elem | Regular School | No | Elementary | PK | 5 | 2021 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2736793 | 2736793 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000214 | 109 | Hokulani Elem | Regular School | No | Elementary | PK | 5 | 2019 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2781843 | 2781843 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000214 | 109 | Hokulani Elem | Regular School | No | Elementary | PK | 5 | 2018 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
110020 | 110020 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000218 | 110 | JARRETT MID | Regular School | No | 2 | 06 | 8 | 2016 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
129023 | 129023 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000218 | 110 | JARRETT MID | Regular School | No | Middle | 06 | 8 | 2017 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
279999 | 279999 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000218 | 110 | JARRETT MID | Regular School | No | 2 | 06 | 8 | 2015 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2431133 | 2431133 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000218 | 110 | Jarrett Middle | Regular School | No | Middle | 06 | 8 | 2020 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2455823 | 2455823 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000218 | 110 | Jarrett Middle | Regular School | No | Middle | 06 | 8 | 2021 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2736794 | 2736794 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000218 | 110 | Jarrett Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2781844 | 2781844 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000218 | 110 | Jarrett Middle | Regular School | No | Middle | 06 | 8 | 2018 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
110021 | 110021 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000213 | 111 | JEFFERSON | Regular School | No | 1 | PK | 5 | 2016 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
129024 | 129024 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000213 | 111 | JEFFERSON | Regular School | No | Elementary | PK | 5 | 2017 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
280000 | 280000 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000213 | 111 | JEFFERSON | Regular School | No | 1 | PK | 5 | 2015 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2431134 | 2431134 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000213 | 111 | Jefferson Elem | Regular School | No | Elementary | PK | 5 | 2020 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2455824 | 2455824 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000213 | 111 | Jefferson Elem | Regular School | No | Elementary | PK | 5 | 2021 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2736795 | 2736795 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000213 | 111 | Jefferson Elem | Regular School | No | Elementary | PK | 5 | 2019 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2781845 | 2781845 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000213 | 111 | Jefferson Elem | Regular School | No | Elementary | PK | 5 | 2018 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
110022 | 110022 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000217 | 112 | KAAHUMANU | Regular School | No | 1 | PK | 5 | 2016 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
129025 | 129025 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000217 | 112 | KAAHUMANU | Regular School | No | Elementary | PK | 5 | 2017 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
280001 | 280001 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000217 | 112 | KAAHUMANU | Regular School | No | 1 | PK | 5 | 2015 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2431135 | 2431135 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000217 | 112 | Kaahumanu Elem | Regular School | No | Elementary | PK | 5 | 2020 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2455825 | 2455825 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000217 | 112 | Kaahumanu Elem | Regular School | No | Elementary | PK | 5 | 2021 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2736796 | 2736796 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000217 | 112 | Kaahumanu Elem | Regular School | No | Elementary | PK | 5 | 2019 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2781846 | 2781846 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000217 | 112 | Kaahumanu Elem | Regular School | No | Elementary | PK | 5 | 2018 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
109996 | 109996 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000216 | 113 | KAEWAI | Regular School | No | 1 | PK | 5 | 2016 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128999 | 128999 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000216 | 113 | KAEWAI | Regular School | No | Elementary | PK | 5 | 2017 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
279975 | 279975 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000216 | 113 | KAEWAI | Regular School | No | 1 | PK | 5 | 2015 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2431109 | 2431109 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000216 | 113 | Kaewai Elem | Regular School | No | Elementary | PK | 5 | 2020 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2455799 | 2455799 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000216 | 113 | Kaewai Elem | Regular School | No | Elementary | PK | 5 | 2021 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2736770 | 2736770 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000216 | 113 | Kaewai Elem | Regular School | No | Elementary | PK | 5 | 2019 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2781820 | 2781820 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000216 | 113 | Kaewai Elem | Regular School | No | Elementary | PK | 5 | 2018 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
109997 | 109997 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000215 | 114 | KAHALA | Regular School | No | 1 | PK | 5 | 2016 | grade_9 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
129000 | 129000 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000215 | 114 | KAHALA | 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]);