enrollments
Data source: Big Local News · About: Big Local
290 rows where grade = "grade_2", state = "HI" and year = 2017
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127064 | 127064 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000300 | 293 | HOOKELE EL | Regular School | No | Elementary | PK | 5 | 2017 | grade_2 | 64.0 | 64 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127066 | 127066 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000128 | 256 | IROQUOIS POINT | Regular School | No | Elementary | PK | 6 | 2017 | grade_2 | 62.0 | 62 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127067 | 127067 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000127 | 281 | KAIMILOA | Regular School | No | Elementary | PK | 6 | 2017 | grade_2 | 60.0 | 60 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127068 | 127068 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000166 | 282 | KAPOLEI EL | Regular School | No | Elementary | PK | 5 | 2017 | grade_2 | 97.0 | 97 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127071 | 127071 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000291 | 294 | KEONEULA | Regular School | No | Elementary | PK | 6 | 2017 | grade_2 | 98.0 | 98 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127072 | 127072 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000123 | 259 | MAKAKILO | Regular School | No | Elementary | PK | 5 | 2017 | grade_2 | 53.0 | 53 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127073 | 127073 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000121 | 286 | MAUKA LANI | Regular School | No | Elementary | PK | 5 | 2017 | grade_2 | 59.0 | 59 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127074 | 127074 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000112 | 269 | POHAKEA | Regular School | No | Elementary | PK | 6 | 2017 | grade_2 | 58.0 | 58 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127075 | 127075 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000230 | 271 | LEIHOKU | Regular School | No | Elementary | PK | 6 | 2017 | grade_2 | 86.0 | 86 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127076 | 127076 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000125 | 257 | MAILI | Regular School | No | Elementary | PK | 6 | 2017 | grade_2 | 85.0 | 85 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127077 | 127077 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000124 | 258 | MAKAHA | Regular School | No | Elementary | PK | 6 | 2017 | grade_2 | 59.0 | 59 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127078 | 127078 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000119 | 261 | NANAIKAPONO | Regular School | No | Elementary | PK | 6 | 2017 | grade_2 | 78.0 | 78 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127079 | 127079 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000118 | 262 | NANAKULI EL | Regular School | No | Elementary | PK | 6 | 2017 | grade_2 | 33.0 | 33 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127081 | 127081 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000111 | 270 | WAIANAE EL | Regular School | No | Elementary | PK | 6 | 2017 | grade_2 | 48.0 | 48 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127084 | 127084 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000136 | 250 | AHRENS | Regular School | No | Elementary | PK | 6 | 2017 | grade_2 | 132.0 | 132 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127086 | 127086 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000130 | 276 | HONOWAI | Regular School | No | Elementary | PK | 6 | 2017 | grade_2 | 67.0 | 67 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127087 | 127087 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000239 | 287 | KALEIOPUU | Regular School | No | Elementary | PK | 6 | 2017 | grade_2 | 72.0 | 72 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127088 | 127088 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000231 | 283 | KANOELANI | Regular School | No | Elementary | PK | 6 | 2017 | grade_2 | 74.0 | 74 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127089 | 127089 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000126 | 268 | LEHUA | Regular School | No | Elementary | PK | 6 | 2017 | grade_2 | 24.0 | 24 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127090 | 127090 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000122 | 260 | MANANA | Regular School | No | Elementary | PK | 6 | 2017 | grade_2 | 45.0 | 45 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127091 | 127091 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000120 | 285 | MOMILANI | Regular School | No | Elementary | PK | 6 | 2017 | grade_2 | 54.0 | 54 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127092 | 127092 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000116 | 264 | PALISADES | Regular School | No | Elementary | PK | 6 | 2017 | grade_2 | 43.0 | 43 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127093 | 127093 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000113 | 267 | PC HIGHLANDS | Regular School | No | Elementary | PK | 6 | 2017 | grade_2 | 53.0 | 53 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127094 | 127094 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000115 | 265 | PEARL CITY EL | Regular School | No | Elementary | PK | 6 | 2017 | grade_2 | 49.0 | 49 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127096 | 127096 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000109 | 288 | WAIAU | Regular School | No | Elementary | PK | 6 | 2017 | grade_2 | 42.0 | 42 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127097 | 127097 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000257 | 290 | WAIKELE | Regular School | No | Elementary | PK | 6 | 2017 | grade_2 | 57.0 | 57 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127098 | 127098 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000159 | 274 | WAIPAHU EL | Regular School | No | Elementary | PK | 6 | 2017 | grade_2 | 91.0 | 91 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127101 | 127101 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000157 | 335 | AHUIMANU | Regular School | No | Elementary | PK | 6 | 2017 | grade_2 | 31.0 | 31 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127103 | 127103 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000002 | 303 | HAUULA | Regular School | No | Elementary | PK | 6 | 2017 | grade_2 | 42.0 | 42 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127104 | 127104 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000003 | 304 | HEEIA | Regular School | No | Elementary | PK | 6 | 2017 | grade_2 | 35.0 | 35 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127105 | 127105 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000004 | 305 | KAAAWA | Regular School | No | Elementary | PK | 6 | 2017 | grade_2 | 9.0 | 9 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127106 | 127106 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000006 | 306 | KAHALUU | Regular School | No | Elementary | PK | 6 | 2017 | grade_2 | 29.0 | 29 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127107 | 127107 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000236 | 331 | KAHUKU EL | Regular School | No | Elementary | PK | 6 | 2017 | grade_2 | 56.0 | 56 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127109 | 127109 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000013 | 313 | KANEOHE | Regular School | No | Elementary | PK | 6 | 2017 | grade_2 | 61.0 | 61 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127110 | 127110 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000014 | 315 | KAPUNAHALA | Regular School | No | Elementary | PK | 6 | 2017 | grade_2 | 62.0 | 62 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127112 | 127112 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000017 | 319 | LAIE | Regular School | No | Elementary | PK | 6 | 2017 | grade_2 | 88.0 | 88 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127113 | 127113 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000021 | 323 | PARKER | Regular School | No | Elementary | PK | 6 | 2017 | grade_2 | 41.0 | 41 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127114 | 127114 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000023 | 314 | PUOHALA | Regular School | No | Elementary | PK | 6 | 2017 | grade_2 | 23.0 | 23 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127115 | 127115 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000024 | 325 | SUNSET BEACH | Regular School | No | Elementary | PK | 6 | 2017 | grade_2 | 67.0 | 67 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127116 | 127116 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000025 | 326 | WAIAHOLE | Regular School | No | Elementary | PK | 6 | 2017 | grade_2 | 8.0 | 8 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127117 | 127117 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000101 | 300 | AIKAHI | Regular School | No | Elementary | PK | 6 | 2017 | grade_2 | 62.0 | 62 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127118 | 127118 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000001 | 302 | ENCHANTED LAKE | Regular School | No | Elementary | PK | 6 | 2017 | grade_2 | 56.0 | 56 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127119 | 127119 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000005 | 330 | KAELEPULU | Regular School | No | Elementary | PK | 6 | 2017 | grade_2 | 22.0 | 22 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127120 | 127120 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000008 | 308 | KAILUA EL | Regular School | No | Elementary | PK | 6 | 2017 | grade_2 | 44.0 | 44 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127123 | 127123 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000011 | 311 | KAINALU | Regular School | No | Elementary | PK | 6 | 2017 | grade_2 | 48.0 | 48 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127125 | 127125 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000015 | 317 | KEOLU | Regular School | No | Elementary | PK | 6 | 2017 | grade_2 | 8.0 | 8 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127126 | 127126 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000019 | 321 | MAUNAWILI | Regular School | No | Elementary | PK | 6 | 2017 | grade_2 | 36.0 | 36 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127127 | 127127 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000020 | 322 | MOKAPU | Regular School | No | Elementary | PK | 6 | 2017 | grade_2 | 122.0 | 122 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127129 | 127129 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000022 | 324 | POPE | Regular School | No | Elementary | PK | 6 | 2017 | grade_2 | 35.0 | 35 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127130 | 127130 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000026 | 327 | WAIMANALO EL & INT | Regular School | No | Elementary | PK | 8 | 2017 | grade_2 | 34.0 | 34 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127131 | 127131 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000027 | 351 | DE SILVA | Regular School | No | Elementary | PK | 6 | 2017 | grade_2 | 56.0 | 56 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127132 | 127132 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000028 | 352 | HAAHEO | Regular School | No | Elementary | PK | 6 | 2017 | grade_2 | 27.0 | 27 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127135 | 127135 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000031 | 357 | HILO UNION | Regular School | No | Elementary | PK | 6 | 2017 | grade_2 | 40.0 | 40 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127136 | 127136 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000036 | 365 | KALANIANAOLE EL & INT | Regular School | No | Elementary | PK | 8 | 2017 | grade_2 | 26.0 | 26 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127137 | 127137 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000037 | 367 | KAPIOLANI | Regular School | No | Elementary | PK | 6 | 2017 | grade_2 | 33.0 | 33 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127138 | 127138 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000039 | 369 | KAUMANA | Regular School | No | Elementary | PK | 6 | 2017 | grade_2 | 22.0 | 22 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127139 | 127139 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000042 | 372 | KEAUKAHA | Regular School | No | Elementary | PK | 6 | 2017 | grade_2 | 35.0 | 35 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127140 | 127140 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000051 | 384 | WAIAKEA EL | Regular School | No | Elementary | PK | 5 | 2017 | grade_2 | 88.0 | 88 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127143 | 127143 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000054 | 386 | WAIAKEAWAENA | Regular School | No | Elementary | PK | 5 | 2017 | grade_2 | 74.0 | 74 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127144 | 127144 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000032 | 358 | HOLUALOA | Regular School | No | Elementary | PK | 5 | 2017 | grade_2 | 69.0 | 69 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127145 | 127145 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000033 | 359 | HONAUNAU | Regular School | No | Elementary | PK | 5 | 2017 | grade_2 | 17.0 | 17 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127146 | 127146 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000249 | 361 | HONOKAA EL | Regular School | No | Elementary | PK | 6 | 2017 | grade_2 | 36.0 | 36 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127148 | 127148 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000035 | 363 | HOOKENA | Regular School | No | Elementary | PK | 5 | 2017 | grade_2 | 17.0 | 17 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127149 | 127149 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000232 | 371 | KAHAKAI | Regular School | No | Elementary | PK | 5 | 2017 | grade_2 | 120.0 | 120 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127150 | 127150 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000287 | 378 | KE KULA O EHUNUIKAIMALINO | Regular School | No | Other | PK | 12 | 2017 | grade_2 | 26.0 | 26 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127151 | 127151 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000041 | 388 | KEALAKEHE | Regular School | No | Elementary | PK | 5 | 2017 | grade_2 | 147.0 | 147 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127154 | 127154 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000250 | 395 | KOHALA EL | Regular School | No | Elementary | PK | 5 | 2017 | grade_2 | 36.0 | 36 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127157 | 127157 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000044 | 375 | KONAWAENA EL | Regular School | No | Elementary | PK | 5 | 2017 | grade_2 | 56.0 | 56 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127161 | 127161 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000247 | 393 | WAIKOLOA | Regular School | No | Elementary | PK | 8 | 2017 | grade_2 | 86.0 | 86 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127162 | 127162 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000055 | 387 | WAIMEA EL | Regular School | No | Elementary | PK | 5 | 2017 | grade_2 | 72.0 | 72 |
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]);