enrollments
Data source: Big Local News · About: Big Local
292 rows where grade = "grade_2", state = "HI" and year = 2019 sorted by year
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2734720 | 2734720 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000227 | 100 | Aina Haina Elem | Regular School | No | Elementary | PK | 5 | 2019 | grade_2 | 83.0 | 83 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734721 | 2734721 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000222 | 105 | Dole Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734722 | 2734722 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000221 | 106 | Farrington High | Regular School | No | High | 09 | 12 | 2019 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734723 | 2734723 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000220 | 107 | Fern Elem | Regular School | No | Elementary | PK | 5 | 2019 | grade_2 | 74.0 | 74 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734724 | 2734724 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000219 | 108 | Hahaione Elem | Regular School | No | Elementary | PK | 5 | 2019 | grade_2 | 85.0 | 85 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734725 | 2734725 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000096 | 470 | Hawaii School for the Deaf and Blind | Special Education School | No | Other | PK | 12 | 2019 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734726 | 2734726 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000216 | 113 | Kaewai Elem | Regular School | No | Elementary | PK | 5 | 2019 | grade_2 | 44.0 | 44 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734727 | 2734727 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000215 | 114 | Kahala Elem | Regular School | No | Elementary | PK | 5 | 2019 | grade_2 | 63.0 | 63 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734728 | 2734728 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000211 | 116 | Kaimuki Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734729 | 2734729 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000228 | 154 | Kaiser High | Regular School | No | High | 09 | 12 | 2019 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734730 | 2734730 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000164 | 118 | Kalakaua Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734731 | 2734731 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000163 | 119 | Kalani High | Regular School | No | High | 09 | 12 | 2019 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734732 | 2734732 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000162 | 120 | Kalihi Elem | Regular School | No | Elementary | PK | 5 | 2019 | grade_2 | 36.0 | 36 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734733 | 2734733 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000160 | 121 | Kalihi Kai Elem | Regular School | No | Elementary | PK | 5 | 2019 | grade_2 | 84.0 | 84 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734734 | 2734734 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000210 | 122 | Kalihi Uka Elem | Regular School | No | Elementary | PK | 5 | 2019 | grade_2 | 23.0 | 23 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734735 | 2734735 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000209 | 123 | Kalihi Waena Elem | Regular School | No | Elementary | PK | 5 | 2019 | grade_2 | 80.0 | 80 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734736 | 2734736 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000208 | 155 | Kamiloiki Elem | Regular School | No | Elementary | PK | 5 | 2019 | grade_2 | 63.0 | 63 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734737 | 2734737 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000207 | 124 | Kapalama Elem | Regular School | No | Elementary | PK | 5 | 2019 | grade_2 | 94.0 | 94 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734738 | 2734738 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000204 | 127 | Koko Head Elem | Regular School | No | Elementary | PK | 5 | 2019 | grade_2 | 39.0 | 39 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734739 | 2734739 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000201 | 130 | Liholiho Elem | Regular School | No | Elementary | PK | 5 | 2019 | grade_2 | 77.0 | 77 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734740 | 2734740 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000198 | 133 | Linapuni Elem | Regular School | No | Elementary | PK | 1 | 2019 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734741 | 2734741 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000192 | 139 | Niu Valley Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734742 | 2734742 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000187 | 145 | Puuhale Elem | Regular School | No | Elementary | PK | 5 | 2019 | grade_2 | 34.0 | 34 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734743 | 2734743 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000182 | 150 | Waikiki Elem | Regular School | No | Elementary | PK | 5 | 2019 | grade_2 | 95.0 | 95 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734744 | 2734744 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000179 | 153 | Wilson Elem | Regular School | No | Elementary | PK | 5 | 2019 | grade_2 | 85.0 | 85 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734745 | 2734745 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000226 | 101 | Ala Wai Elem | Regular School | No | Elementary | PK | 5 | 2019 | grade_2 | 52.0 | 52 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734746 | 2734746 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000225 | 102 | Aliiolani Elem | Regular School | No | Elementary | PK | 5 | 2019 | grade_2 | 34.0 | 34 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734747 | 2734747 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000246 | 103 | Anuenue | Regular School | No | Other | PK | 12 | 2019 | grade_2 | 52.0 | 52 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734748 | 2734748 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000223 | 104 | Central Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734749 | 2734749 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000214 | 109 | Hokulani Elem | Regular School | No | Elementary | PK | 5 | 2019 | grade_2 | 63.0 | 63 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734750 | 2734750 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000218 | 110 | Jarrett Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734751 | 2734751 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000213 | 111 | Jefferson Elem | Regular School | No | Elementary | PK | 5 | 2019 | grade_2 | 47.0 | 47 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734752 | 2734752 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000217 | 112 | Kaahumanu Elem | Regular School | No | Elementary | PK | 5 | 2019 | grade_2 | 59.0 | 59 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734753 | 2734753 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000212 | 115 | Kaimuki High | Regular School | No | High | 09 | 12 | 2019 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734754 | 2734754 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000165 | 117 | Kaiulani Elem | Regular School | No | Elementary | PK | 5 | 2019 | grade_2 | 61.0 | 61 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734755 | 2734755 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000206 | 125 | Kauluwela Elem | Regular School | No | Elementary | PK | 5 | 2019 | grade_2 | 70.0 | 70 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734756 | 2734756 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000205 | 126 | Kawananakoa Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734757 | 2734757 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000203 | 128 | Kuhio Elem | Regular School | No | Elementary | PK | 5 | 2019 | grade_2 | 29.0 | 29 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734758 | 2734758 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000202 | 129 | Lanakila Elem | Regular School | No | Elementary | PK | 5 | 2019 | grade_2 | 75.0 | 75 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734759 | 2734759 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000200 | 131 | Likelike Elem | Regular School | No | Elementary | PK | 5 | 2019 | grade_2 | 61.0 | 61 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734760 | 2734760 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000197 | 134 | Lincoln Elem | Regular School | No | Elementary | PK | 5 | 2019 | grade_2 | 51.0 | 51 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734761 | 2734761 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000195 | 135 | Lunalilo Elem | Regular School | No | Elementary | PK | 5 | 2019 | grade_2 | 52.0 | 52 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734762 | 2734762 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000196 | 136 | Maemae Elem | Regular School | No | Elementary | PK | 6 | 2019 | grade_2 | 115.0 | 115 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734763 | 2734763 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000194 | 137 | Manoa Elem | Regular School | No | Elementary | PK | 5 | 2019 | grade_2 | 78.0 | 78 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734764 | 2734764 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000193 | 138 | McKinley High | Regular School | No | High | 09 | 12 | 2019 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734765 | 2734765 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000191 | 140 | Noelani Elem | Regular School | No | Elementary | PK | 5 | 2019 | grade_2 | 74.0 | 74 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734766 | 2734766 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000190 | 141 | Nuuanu Elem | Regular School | No | Elementary | PK | 5 | 2019 | grade_2 | 59.0 | 59 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734767 | 2734767 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000189 | 142 | Palolo Elem | Regular School | No | Elementary | PK | 5 | 2019 | grade_2 | 47.0 | 47 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734768 | 2734768 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000188 | 143 | Pauoa Elem | Regular School | No | Elementary | PK | 5 | 2019 | grade_2 | 40.0 | 40 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734769 | 2734769 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000186 | 146 | Roosevelt High | Regular School | No | High | 09 | 12 | 2019 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734770 | 2734770 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000185 | 147 | Royal Elem | Regular School | No | Elementary | PK | 5 | 2019 | grade_2 | 49.0 | 49 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734771 | 2734771 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000184 | 148 | Stevenson Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734772 | 2734772 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000180 | 152 | Washington Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734773 | 2734773 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000178 | 200 | Aiea Elem | Regular School | No | Elementary | PK | 6 | 2019 | grade_2 | 40.0 | 40 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734774 | 2734774 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000177 | 202 | Aiea High | Regular School | No | High | 09 | 12 | 2019 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734775 | 2734775 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000176 | 201 | Aiea Int | Regular School | No | Middle | 07 | 8 | 2019 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734776 | 2734776 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000175 | 203 | Aliamanu Elem | Regular School | No | Elementary | PK | 6 | 2019 | grade_2 | 82.0 | 82 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734777 | 2734777 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000174 | 204 | Aliamanu Middle | Regular School | No | Middle | 07 | 8 | 2019 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734778 | 2734778 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000170 | 209 | Hickam Elem | Regular School | No | Elementary | PK | 6 | 2019 | grade_2 | 94.0 | 94 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734779 | 2734779 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000107 | 215 | Makalapa Elem | Regular School | No | Elementary | PK | 6 | 2019 | grade_2 | 69.0 | 69 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734780 | 2734780 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000104 | 217 | Moanalua Elem | Regular School | No | Elementary | PK | 6 | 2019 | grade_2 | 81.0 | 81 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734781 | 2734781 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000103 | 218 | Moanalua High | Regular School | No | High | 09 | 12 | 2019 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734782 | 2734782 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000156 | 219 | Moanalua Middle | Regular School | No | Middle | 07 | 8 | 2019 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734783 | 2734783 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000155 | 220 | Mokulele Elem | Regular School | No | Elementary | PK | 6 | 2019 | grade_2 | 42.0 | 42 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734784 | 2734784 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000154 | 221 | Nimitz Elem | Regular School | No | Elementary | PK | 6 | 2019 | grade_2 | 74.0 | 74 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734785 | 2734785 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000153 | 222 | Pearl Harbor Elem | Regular School | No | Elementary | PK | 6 | 2019 | grade_2 | 62.0 | 62 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734786 | 2734786 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000152 | 223 | Pearl Harbor Kai Elem | Regular School | No | Elementary | PK | 6 | 2019 | grade_2 | 63.0 | 63 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734787 | 2734787 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000151 | 243 | Pearl Ridge Elem | Regular School | No | Elementary | PK | 6 | 2019 | grade_2 | 78.0 | 78 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734788 | 2734788 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000150 | 224 | Radford High | Regular School | No | High | 09 | 12 | 2019 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734789 | 2734789 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000149 | 225 | Red Hill Elem | Regular School | No | Elementary | PK | 6 | 2019 | grade_2 | 52.0 | 52 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734790 | 2734790 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000148 | 239 | Salt Lake Elem | Regular School | No | Elementary | PK | 6 | 2019 | grade_2 | 86.0 | 86 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734791 | 2734791 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000147 | 227 | Scott Elem | Regular School | No | Elementary | PK | 6 | 2019 | grade_2 | 66.0 | 66 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734792 | 2734792 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000146 | 228 | Shafter Elem | Regular School | No | Elementary | PK | 6 | 2019 | grade_2 | 53.0 | 53 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734793 | 2734793 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000140 | 233 | Waimalu Elem | Regular School | No | Elementary | PK | 6 | 2019 | grade_2 | 49.0 | 49 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734794 | 2734794 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000139 | 235 | Webling Elem | Regular School | No | Elementary | PK | 6 | 2019 | grade_2 | 57.0 | 57 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734795 | 2734795 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000172 | 206 | Haleiwa Elem | Regular School | No | Elementary | PK | 6 | 2019 | grade_2 | 34.0 | 34 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734796 | 2734796 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000171 | 208 | Helemano Elem | Regular School | No | Elementary | PK | 5 | 2019 | grade_2 | 86.0 | 86 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734797 | 2734797 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000169 | 210 | Iliahi Elem | Regular School | No | Elementary | PK | 5 | 2019 | grade_2 | 60.0 | 60 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734798 | 2734798 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000173 | 207 | Inouye Elem | Regular School | No | Elementary | PK | 5 | 2019 | grade_2 | 99.0 | 99 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734799 | 2734799 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000168 | 211 | Kaala Elem | Regular School | No | Elementary | PK | 5 | 2019 | grade_2 | 74.0 | 74 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734800 | 2734800 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000167 | 212 | Kipapa Elem | Regular School | No | Elementary | PK | 5 | 2019 | grade_2 | 85.0 | 85 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734801 | 2734801 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000108 | 214 | Leilehua High | Regular School | No | High | 09 | 12 | 2019 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734802 | 2734802 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000102 | 216 | Mililani High | Regular School | No | High | 09 | 12 | 2019 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734803 | 2734803 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000285 | 240 | Mililani Ike Elem | Regular School | No | Elementary | PK | 5 | 2019 | grade_2 | 93.0 | 93 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734804 | 2734804 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000099 | 241 | Mililani Mauka Elem | Regular School | No | Elementary | PK | 5 | 2019 | grade_2 | 135.0 | 135 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734805 | 2734805 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000256 | 238 | Mililani Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734806 | 2734806 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000106 | 242 | Mililani Uka Elem | Regular School | No | Elementary | PK | 5 | 2019 | grade_2 | 109.0 | 109 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734807 | 2734807 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000105 | 234 | Mililani Waena Elem | Regular School | No | Elementary | PK | 5 | 2019 | grade_2 | 133.0 | 133 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734808 | 2734808 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000145 | 226 | Solomon Elem | Regular School | No | Elementary | PK | 5 | 2019 | grade_2 | 121.0 | 121 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734809 | 2734809 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000144 | 229 | Wahiawa Elem | Regular School | No | Elementary | PK | 5 | 2019 | grade_2 | 66.0 | 66 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734810 | 2734810 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000143 | 230 | Wahiawa Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734811 | 2734811 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000142 | 231 | Waialua Elem | Regular School | No | Elementary | PK | 6 | 2019 | grade_2 | 70.0 | 70 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734812 | 2734812 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000141 | 232 | Waialua High & Int | Regular School | No | High | 07 | 12 | 2019 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734813 | 2734813 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000138 | 236 | Wheeler Elem | Regular School | No | Elementary | PK | 5 | 2019 | grade_2 | 110.0 | 110 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734814 | 2734814 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000137 | 237 | Wheeler Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734815 | 2734815 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000135 | 251 | Barbers Point Elem | Regular School | No | Elementary | PK | 5 | 2019 | grade_2 | 79.0 | 79 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734816 | 2734816 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000134 | 252 | Campbell High | Regular School | No | High | 09 | 12 | 2019 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734817 | 2734817 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000132 | 254 | Ewa Beach Elem | Regular School | No | Elementary | PK | 6 | 2019 | grade_2 | 90.0 | 90 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734818 | 2734818 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000133 | 253 | Ewa Elem | Regular School | No | Elementary | PK | 6 | 2019 | grade_2 | 155.0 | 155 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2734819 | 2734819 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000296 | 296 | Ewa Makai Middle | Regular School | No | Middle | 07 | 8 | 2019 | grade_2 | 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]);