enrollments
Data source: Big Local News · About: Big Local
290 rows where grade = "grade_2", state = "HI" and year = 2017 sorted by total
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
126964 | 126964 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000222 | 105 | DOLE MID | Regular School | No | Middle | 06 | 8 | 2017 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126965 | 126965 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000221 | 106 | FARRINGTON HI | Regular School | No | High | 09 | 12 | 2017 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126968 | 126968 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000096 | 470 | HSDB | Special Education School | No | Other | PK | 12 | 2017 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126971 | 126971 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000211 | 116 | KAIMUKI MID | Regular School | No | Middle | 06 | 8 | 2017 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126972 | 126972 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000228 | 154 | KAISER HI | Regular School | No | High | 09 | 12 | 2017 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126973 | 126973 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000164 | 118 | KALAKAUA MID | Regular School | No | Middle | 06 | 8 | 2017 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126974 | 126974 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000163 | 119 | KALANI HI | Regular School | No | High | 09 | 12 | 2017 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126983 | 126983 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000198 | 133 | LINAPUNI | Regular School | No | Elementary | PK | 1 | 2017 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126984 | 126984 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000192 | 139 | NIU VALLEY MID | Regular School | No | Middle | 06 | 8 | 2017 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126991 | 126991 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000223 | 104 | CENTRAL MID | Regular School | No | Middle | 06 | 8 | 2017 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126993 | 126993 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000218 | 110 | JARRETT MID | Regular School | No | Middle | 06 | 8 | 2017 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126996 | 126996 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000212 | 115 | KAIMUKI HI | Regular School | No | High | 09 | 12 | 2017 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
126999 | 126999 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000205 | 126 | KAWANANAKOA MID | Regular School | No | Middle | 06 | 8 | 2017 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127007 | 127007 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000193 | 138 | MCKINLEY HI | Regular School | No | High | 09 | 12 | 2017 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127012 | 127012 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000186 | 146 | ROOSEVELT HI | Regular School | No | High | 09 | 12 | 2017 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127014 | 127014 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000184 | 148 | STEVENSON MID | Regular School | No | Middle | 06 | 8 | 2017 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127015 | 127015 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000180 | 152 | WASHINGTON MID | Regular School | No | Middle | 06 | 8 | 2017 | grade_2 | 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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127020 | 127020 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000174 | 204 | ALIAMANU INT | Regular School | No | Middle | 07 | 8 | 2017 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127024 | 127024 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000103 | 218 | MOANALUA HI | Regular School | No | High | 09 | 12 | 2017 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127025 | 127025 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000156 | 219 | MOANALUA MID | Regular School | No | Middle | 07 | 8 | 2017 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127031 | 127031 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000150 | 224 | RADFORD HI | Regular School | No | High | 09 | 12 | 2017 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127044 | 127044 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000108 | 214 | LEILEHUA HI | Regular School | No | High | 09 | 12 | 2017 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127045 | 127045 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000102 | 216 | MILILANI HI | Regular School | No | High | 09 | 12 | 2017 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127048 | 127048 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000256 | 238 | MILILANI MID | Regular School | No | Middle | 06 | 8 | 2017 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127053 | 127053 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000143 | 230 | WAHIAWA MID | Regular School | No | Middle | 06 | 8 | 2017 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127055 | 127055 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000141 | 232 | WAIALUA HI & INT | Regular School | No | High | 07 | 12 | 2017 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127057 | 127057 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000137 | 237 | WHEELER MID | Regular School | No | Middle | 06 | 8 | 2017 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127059 | 127059 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000134 | 252 | CAMPBELL HI | Regular School | No | High | 09 | 12 | 2017 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127062 | 127062 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000296 | 296 | EWA MAKAI MID | Regular School | No | Middle | 07 | 8 | 2017 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127065 | 127065 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000129 | 279 | ILIMA INT | Regular School | No | Middle | 07 | 8 | 2017 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127069 | 127069 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000261 | 292 | KAPOLEI HI | Regular School | No | High | 09 | 12 | 2017 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127070 | 127070 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000259 | 291 | KAPOLEI MID | Regular School | No | Middle | 06 | 8 | 2017 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127080 | 127080 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000117 | 263 | NANAKULI HI & INT | Regular School | No | High | 07 | 12 | 2017 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127082 | 127082 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000110 | 272 | WAIANAE HI | Regular School | No | High | 09 | 12 | 2017 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127083 | 127083 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000229 | 273 | WAIANAE INT | Regular School | No | Middle | 07 | 8 | 2017 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127085 | 127085 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000131 | 255 | HIGHLANDS INT | Regular School | No | Middle | 07 | 8 | 2017 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127095 | 127095 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000114 | 266 | PEARL CITY HI | Regular School | No | High | 09 | 12 | 2017 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127099 | 127099 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000161 | 277 | WAIPAHU HI | Regular School | No | High | 09 | 12 | 2017 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127100 | 127100 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000158 | 278 | WAIPAHU INT | Regular School | No | Middle | 07 | 8 | 2017 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127102 | 127102 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000100 | 301 | CASTLE HI | Regular School | No | High | 09 | 12 | 2017 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127108 | 127108 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000007 | 307 | KAHUKU HI | Regular School | No | High | 07 | 12 | 2017 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127111 | 127111 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000016 | 318 | KING INT | Regular School | No | Middle | 07 | 8 | 2017 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127121 | 127121 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000009 | 309 | KAILUA HI | Regular School | No | High | 09 | 12 | 2017 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127122 | 127122 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000010 | 310 | KAILUA INT | Regular School | No | Middle | 07 | 8 | 2017 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127124 | 127124 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000012 | 312 | KALAHEO HI | Regular School | No | High | 09 | 12 | 2017 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127128 | 127128 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000098 | 475 | OLOMANA | Alternative School | No | High | 07 | 12 | 2017 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127133 | 127133 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000029 | 355 | HILO HI | Regular School | No | High | 09 | 12 | 2017 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127134 | 127134 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000030 | 356 | HILO INT | Regular School | No | Middle | 07 | 8 | 2017 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127141 | 127141 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000052 | 389 | WAIAKEA HI | Regular School | No | High | 09 | 12 | 2017 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127142 | 127142 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000053 | 385 | WAIAKEA INT | Regular School | No | Middle | 06 | 8 | 2017 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127147 | 127147 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000034 | 360 | HONOKAA HI & INT | Regular School | No | High | 07 | 12 | 2017 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127152 | 127152 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000254 | 392 | KEALAKEHE HI | Regular School | No | High | 09 | 12 | 2017 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127153 | 127153 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000235 | 390 | KEALAKEHE INT | Regular School | No | Middle | 06 | 8 | 2017 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127155 | 127155 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000043 | 373 | KOHALA HI | Regular School | No | High | 09 | 12 | 2017 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127156 | 127156 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000267 | 366 | KOHALA MID | Regular School | No | Middle | 06 | 8 | 2017 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127158 | 127158 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000045 | 374 | KONAWAENA HI | Regular School | No | High | 09 | 12 | 2017 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127159 | 127159 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000252 | 376 | KONAWAENA MID | Regular School | No | Middle | 06 | 8 | 2017 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127165 | 127165 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000260 | 354 | KEAAU HI | Regular School | No | High | 09 | 12 | 2017 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127166 | 127166 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000040 | 370 | KEAAU MID | Regular School | No | Middle | 06 | 8 | 2017 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127171 | 127171 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000050 | 383 | PAHOA HI & INT | Regular School | No | High | 07 | 12 | 2017 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127172 | 127172 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000056 | 400 | BALDWIN HI | Regular School | No | High | 09 | 12 | 2017 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127174 | 127174 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000059 | 404 | IAO INT | Regular School | No | Middle | 06 | 8 | 2017 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127176 | 127176 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000233 | 420 | KALAMA INT | Regular School | No | Middle | 06 | 8 | 2017 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127178 | 127178 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000251 | 435 | KEKAULIKE HI | Regular School | No | High | 09 | 12 | 2017 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127182 | 127182 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000238 | 430 | LOKELANI INT | Regular School | No | Middle | 06 | 8 | 2017 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127184 | 127184 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000073 | 418 | MAUI HI | Regular School | No | High | 09 | 12 | 2017 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127185 | 127185 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000241 | 428 | MAUI WAENA INT | Regular School | No | Middle | 06 | 8 | 2017 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127196 | 127196 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000068 | 413 | LAHAINA INT | Regular School | No | Middle | 06 | 8 | 2017 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127197 | 127197 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000069 | 414 | LAHAINALUNA HI | Regular School | No | High | 09 | 12 | 2017 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127200 | 127200 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000075 | 421 | MOLOKAI HI | Regular School | No | High | 09 | 12 | 2017 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127201 | 127201 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000290 | 434 | MOLOKAI MID | Regular School | No | Middle | 07 | 8 | 2017 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127206 | 127206 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000266 | 448 | KAMAKAHELEI MID | Regular School | No | Middle | 06 | 8 | 2017 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127208 | 127208 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000085 | 455 | KAPAA HI | Regular School | No | High | 09 | 12 | 2017 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127209 | 127209 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000255 | 447 | KAPAA MID | Regular School | No | Middle | 06 | 8 | 2017 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127210 | 127210 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000086 | 456 | KAUAI HI | Regular School | No | High | 09 | 12 | 2017 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127215 | 127215 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000091 | 461 | NIIHAU | Regular School | No | Other | PK | 12 | 2017 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127216 | 127216 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000092 | 464 | WAIMEA CANYON | Regular School | No | Middle | 06 | 8 | 2017 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127217 | 127217 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000093 | 462 | WAIMEA HI | Regular School | No | High | 09 | 12 | 2017 | grade_2 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127221 | 127221 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000275 | 546 | HAKIPU'U LEARNING CTR-PCS | charter | Regular School | Yes | Other | 04 | 12 | 2017 | grade_2 | 0.0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
127222 | 127222 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000270 | 540 | HALAU KU MANA-PCS | charter | Regular School | Yes | Other | 04 | 12 | 2017 | grade_2 | 0.0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
127232 | 127232 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000301 | 552 | KAU LEARNING ACAD-PCS | charter | Regular School | Yes | Elementary | 03 | 7 | 2017 | grade_2 | 0.0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
127234 | 127234 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000278 | 549 | KE ANA LA'AHANA-PCS | charter | Regular School | Yes | High | 07 | 12 | 2017 | grade_2 | 0.0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
127247 | 127247 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000298 | 567 | SEEQS | charter | Regular School | Yes | Middle | 06 | 8 | 2017 | grade_2 | 0.0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
127251 | 127251 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000268 | 394 | WAIMEA MID-PCCS | charter | Regular School | Yes | Middle | 06 | 8 | 2017 | grade_2 | 0.0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
127252 | 127252 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000265 | 399 | WEST HI EXPLOR ACAD-PCS | charter | Regular School | Yes | Other | 06 | 12 | 2017 | grade_2 | 0.0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
127220 | 127220 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000273 | 543 | EDUC LAB: A HAWAII NC-PCS | charter | Regular School | Yes | Other | KG | 12 | 2017 | grade_2 | 10.0 | 10 | |||||||||||||||||||||||||||||||||||||||||||||||||||
127056 | 127056 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000138 | 236 | WHEELER EL | Regular School | No | Elementary | PK | 5 | 2017 | grade_2 | 100.0 | 100 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127218 | 127218 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000094 | 463 | WILCOX | Regular School | No | Elementary | PK | 5 | 2017 | grade_2 | 100.0 | 100 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127050 | 127050 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000105 | 234 | MILILANI WAENA | Regular School | No | Elementary | PK | 5 | 2017 | grade_2 | 102.0 | 102 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127005 | 127005 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000196 | 136 | MAEMAE | Regular School | No | Elementary | PK | 6 | 2017 | grade_2 | 103.0 | 103 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127189 | 127189 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000297 | 436 | PUU KUKUI | Regular School | No | Elementary | PK | 5 | 2017 | grade_2 | 105.0 | 105 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127063 | 127063 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000248 | 280 | HOLOMUA | Regular School | No | Elementary | PK | 6 | 2017 | grade_2 | 109.0 | 109 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127160 | 127160 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000049 | 382 | PAAUILO EL & INT | Regular School | No | Other | PK | 9 | 2017 | grade_2 | 11.0 | 11 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127163 | 127163 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000038 | 368 | KAU HI/PAHALA EL | Regular School | No | Other | PK | 12 | 2017 | grade_2 | 11.0 | 11 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127047 | 127047 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000099 | 241 | MILILANI MAUKA | Regular School | No | Elementary | PK | 5 | 2017 | grade_2 | 110.0 | 110 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127181 | 127181 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000071 | 416 | LIHIKAI | Regular School | No | Elementary | PK | 5 | 2017 | grade_2 | 112.0 | 112 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127193 | 127193 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000061 | 406 | KAMEHAMEHA III | Regular School | No | Elementary | PK | 5 | 2017 | grade_2 | 112.0 | 112 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127237 | 127237 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000279 | 554 | KIHEI PC SCHOOL-PCS | charter | Regular School | Yes | Other | KG | 12 | 2017 | grade_2 | 12.0 | 12 |
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]);