enrollments
Data source: Big Local News · About: Big Local
290 rows where grade = "grade_2", state = "HI" and year = 2017 sorted by school_nces_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127241 | 127241 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000018 | 320 | LANIKAI-PCS | charter | Regular School | Yes | Elementary | KG | 6 | 2017 | grade_2 | 45.0 | 45 | |||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127242 | 127242 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000046 | 377 | LAUPAHOEHOE COMMUNITY - PCS | charter | Regular School | Yes | Other | PK | 12 | 2017 | grade_2 | 17.0 | 17 | |||||||||||||||||||||||||||||||||||||||||||||||||||
127168 | 127168 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000047 | 379 | MT VIEW EL | Regular School | No | Elementary | PK | 5 | 2017 | grade_2 | 64.0 | 64 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127169 | 127169 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000048 | 380 | NAALEHU | Regular School | No | Elementary | PK | 6 | 2017 | grade_2 | 45.0 | 45 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127173 | 127173 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000057 | 401 | HAIKU | Regular School | No | Elementary | PK | 5 | 2017 | grade_2 | 82.0 | 82 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127192 | 127192 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000058 | 402 | HANA HI & EL | Regular School | No | Other | PK | 12 | 2017 | grade_2 | 29.0 | 29 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127175 | 127175 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000060 | 405 | KAHULUI | Regular School | No | Elementary | PK | 5 | 2017 | grade_2 | 129.0 | 129 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127194 | 127194 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000062 | 407 | KAUNAKAKAI | Regular School | No | Elementary | PK | 6 | 2017 | grade_2 | 18.0 | 18 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127179 | 127179 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000064 | 409 | KIHEI | Regular School | No | Elementary | PK | 5 | 2017 | grade_2 | 92.0 | 92 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127195 | 127195 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000065 | 410 | KILOHANA | Regular School | No | Elementary | PK | 6 | 2017 | grade_2 | 8.0 | 8 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127240 | 127240 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000066 | 411 | KUALAPUU | charter | Regular School | Yes | Elementary | PK | 6 | 2017 | grade_2 | 27.0 | 27 | |||||||||||||||||||||||||||||||||||||||||||||||||||
127180 | 127180 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000067 | 412 | KULA | Regular School | No | Elementary | PK | 5 | 2017 | grade_2 | 56.0 | 56 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127198 | 127198 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000070 | 415 | LANAI HI & EL | Regular School | No | Other | PK | 12 | 2017 | grade_2 | 32.0 | 32 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127183 | 127183 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000072 | 417 | MAKAWAO | Regular School | No | Elementary | PK | 5 | 2017 | grade_2 | 59.0 | 59 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127199 | 127199 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000074 | 419 | MAUNALOA | Regular School | No | Elementary | PK | 6 | 2017 | grade_2 | 3.0 | 3 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127186 | 127186 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000076 | 422 | PAIA | Regular School | No | Elementary | PK | 5 | 2017 | grade_2 | 51.0 | 51 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127188 | 127188 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000077 | 426 | PUKALANI | Regular School | No | Elementary | PK | 5 | 2017 | grade_2 | 47.0 | 47 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127190 | 127190 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000079 | 424 | WAIHEE | Regular School | No | Elementary | PK | 5 | 2017 | grade_2 | 82.0 | 82 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127191 | 127191 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000080 | 425 | WAILUKU | Regular School | No | Elementary | PK | 5 | 2017 | grade_2 | 80.0 | 80 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127203 | 127203 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000081 | 451 | ELEELE | Regular School | No | Elementary | PK | 5 | 2017 | grade_2 | 63.0 | 63 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127204 | 127204 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000082 | 452 | HANALEI | Regular School | No | Elementary | PK | 6 | 2017 | grade_2 | 44.0 | 44 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127205 | 127205 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000083 | 453 | KALAHEO | Regular School | No | Elementary | PK | 5 | 2017 | grade_2 | 57.0 | 57 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127207 | 127207 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000084 | 454 | KAPAA EL | Regular School | No | Elementary | PK | 5 | 2017 | grade_2 | 164.0 | 164 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127212 | 127212 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000088 | 458 | KEKAHA | Regular School | No | Elementary | PK | 5 | 2017 | grade_2 | 39.0 | 39 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127213 | 127213 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000089 | 459 | KILAUEA | Regular School | No | Elementary | PK | 6 | 2017 | grade_2 | 35.0 | 35 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127214 | 127214 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000090 | 460 | KOLOA | Regular School | No | Elementary | PK | 5 | 2017 | grade_2 | 47.0 | 47 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
127023 | 127023 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000104 | 217 | MOANALUA EL | Regular School | No | Elementary | PK | 6 | 2017 | grade_2 | 60.0 | 60 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
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 |
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]);