enrollments
Data source: Big Local News · About: Big Local
292 rows where grade = "grade_6", state = "HI" and year = 2019 sorted by total_int descending
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 ▲ |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2735973 | 2735973 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000256 | 238 | Mililani Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_6 | 578.0 | 578 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2735995 | 2735995 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000259 | 291 | Kapolei Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_6 | 430.0 | 430 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2736110 | 2736110 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000241 | 428 | Maui Waena Int | Regular School | No | Middle | 06 | 8 | 2019 | grade_6 | 345.0 | 345 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2736099 | 2736099 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000059 | 404 | Iao Int | Regular School | No | Middle | 06 | 8 | 2019 | grade_6 | 340.0 | 340 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2735898 | 2735898 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000164 | 118 | Kalakaua Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_6 | 337.0 | 337 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2735896 | 2735896 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000211 | 116 | Kaimuki Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_6 | 326.0 | 326 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2736131 | 2736131 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000266 | 448 | Kamakahelei Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_6 | 311.0 | 311 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2735982 | 2735982 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000137 | 237 | Wheeler Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_6 | 281.0 | 281 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2736101 | 2736101 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000233 | 420 | Kalama Int | Regular School | No | Middle | 06 | 8 | 2019 | grade_6 | 273.0 | 273 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2735909 | 2735909 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000192 | 139 | Niu Valley Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_6 | 272.0 | 272 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2736067 | 2736067 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000053 | 385 | Waiakea Int | Regular School | No | Middle | 06 | 8 | 2019 | grade_6 | 267.0 | 267 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2735940 | 2735940 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000180 | 152 | Washington Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_6 | 242.0 | 242 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2735978 | 2735978 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000143 | 230 | Wahiawa Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_6 | 236.0 | 236 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2736121 | 2736121 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000068 | 413 | Lahaina Int | Regular School | No | Middle | 06 | 8 | 2019 | grade_6 | 226.0 | 226 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2735924 | 2735924 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000205 | 126 | Kawananakoa Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_6 | 222.0 | 222 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2735939 | 2735939 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000184 | 148 | Stevenson Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_6 | 219.0 | 219 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2735889 | 2735889 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000222 | 105 | Dole Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_6 | 218.0 | 218 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2736091 | 2736091 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000040 | 370 | Keaau Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_6 | 210.0 | 210 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2736084 | 2736084 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000252 | 376 | Konawaena Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_6 | 208.0 | 208 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2736078 | 2736078 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000235 | 390 | Kealakehe Int | Regular School | No | Middle | 06 | 8 | 2019 | grade_6 | 203.0 | 203 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2736009 | 2736009 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000136 | 250 | August Ahrens Elem | Regular School | No | Elementary | PK | 6 | 2019 | grade_6 | 189.0 | 189 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2736107 | 2736107 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000238 | 430 | Lokelani Int | Regular School | No | Middle | 06 | 8 | 2019 | grade_6 | 178.0 | 178 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2736141 | 2736141 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000092 | 464 | Waimea Canyon Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_6 | 172.0 | 172 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2735986 | 2735986 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000133 | 253 | Ewa Elem | Regular School | No | Elementary | PK | 6 | 2019 | grade_6 | 171.0 | 171 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2735988 | 2735988 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000248 | 280 | Holomua Elem | Regular School | No | Elementary | PK | 6 | 2019 | grade_6 | 165.0 | 165 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2736023 | 2736023 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000159 | 274 | Waipahu Elem | Regular School | No | Elementary | PK | 6 | 2019 | grade_6 | 151.0 | 151 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2736134 | 2736134 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000255 | 447 | Kapaa Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_6 | 143.0 | 143 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2736012 | 2736012 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000239 | 287 | Kaleiopuu Elem | Regular School | No | Elementary | PK | 6 | 2019 | grade_6 | 139.0 | 139 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2735996 | 2735996 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000291 | 294 | Keoneula Elem | Regular School | No | Elementary | PK | 6 | 2019 | grade_6 | 130.0 | 130 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2735916 | 2735916 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000223 | 104 | Central Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_6 | 127.0 | 127 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2735958 | 2735958 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000148 | 239 | Salt Lake Elem | Regular School | No | Elementary | PK | 6 | 2019 | grade_6 | 122.0 | 122 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2736000 | 2736000 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000230 | 271 | Leihoku Elem | Regular School | No | Elementary | PK | 6 | 2019 | grade_6 | 122.0 | 122 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2735985 | 2735985 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000132 | 254 | Ewa Beach Elem | Regular School | No | Elementary | PK | 6 | 2019 | grade_6 | 116.0 | 116 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2736001 | 2736001 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000125 | 257 | Maili Elem | Regular School | No | Elementary | PK | 6 | 2019 | grade_6 | 116.0 | 116 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2736003 | 2736003 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000119 | 261 | Nanaikapono Elem | Regular School | No | Elementary | PK | 6 | 2019 | grade_6 | 105.0 | 105 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2736011 | 2736011 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000130 | 276 | Honowai Elem | Regular School | No | Elementary | PK | 6 | 2019 | grade_6 | 105.0 | 105 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2735948 | 2735948 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000104 | 217 | Moanalua Elem | Regular School | No | Elementary | PK | 6 | 2019 | grade_6 | 102.0 | 102 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2735992 | 2735992 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000127 | 281 | Kaimiloa Elem | Regular School | No | Elementary | PK | 6 | 2019 | grade_6 | 100.0 | 100 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2735944 | 2735944 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000175 | 203 | Aliamanu Elem | Regular School | No | Elementary | PK | 6 | 2019 | grade_6 | 99.0 | 99 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2735947 | 2735947 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000107 | 215 | Makalapa Elem | Regular School | No | Elementary | PK | 6 | 2019 | grade_6 | 95.0 | 95 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2736013 | 2736013 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000231 | 283 | Kanoelani Elem | Regular School | No | Elementary | PK | 6 | 2019 | grade_6 | 91.0 | 91 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2736165 | 2736165 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000295 | 551 | Hawaii Tech Acad PCS | charter | Regular School | Yes | Other | KG | 12 | 2019 | grade_6 | 90.0 | 90 | |||||||||||||||||||||||||||||||||||||||||||||||||||
| 2735918 | 2735918 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000218 | 110 | Jarrett Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_6 | 87.0 | 87 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2736034 | 2736034 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000013 | 313 | Kaneohe Elem | Regular School | No | Elementary | PK | 6 | 2019 | grade_6 | 85.0 | 85 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2735955 | 2735955 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000151 | 243 | Pearl Ridge Elem | Regular School | No | Elementary | PK | 6 | 2019 | grade_6 | 83.0 | 83 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2736022 | 2736022 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000257 | 290 | Waikele Elem | Regular School | No | Elementary | PK | 6 | 2019 | grade_6 | 83.0 | 83 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2736052 | 2736052 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000020 | 322 | Mokapu Elem | Regular School | No | Elementary | PK | 6 | 2019 | grade_6 | 83.0 | 83 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2735991 | 2735991 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000128 | 256 | Iroquois Point Elem | Regular School | No | Elementary | PK | 6 | 2019 | grade_6 | 82.0 | 82 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2736145 | 2736145 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000240 | 275 | Kamaile Academy PCS | charter | Regular School | Yes | Other | PK | 12 | 2019 | grade_6 | 80.0 | 80 | |||||||||||||||||||||||||||||||||||||||||||||||||||
| 2736167 | 2736167 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000279 | 554 | Kihei Charter School | charter | Regular School | Yes | Other | KG | 12 | 2019 | grade_6 | 80.0 | 80 | |||||||||||||||||||||||||||||||||||||||||||||||||||
| 2736035 | 2736035 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000014 | 315 | Kapunahala Elem | Regular School | No | Elementary | PK | 6 | 2019 | grade_6 | 79.0 | 79 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2736159 | 2736159 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000286 | 545 | Ka Waihona o ka Naauao NCPCS | charter | Regular School | Yes | Elementary | KG | 8 | 2019 | grade_6 | 78.0 | 78 | |||||||||||||||||||||||||||||||||||||||||||||||||||
| 2736148 | 2736148 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000268 | 394 | Waimea Middle PCCS | charter | Regular School | Yes | Middle | 06 | 8 | 2019 | grade_6 | 77.0 | 77 | |||||||||||||||||||||||||||||||||||||||||||||||||||
| 2736086 | 2736086 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000247 | 393 | Waikoloa El & Middle | Regular School | No | Elementary | PK | 8 | 2019 | grade_6 | 76.0 | 76 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2736006 | 2736006 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000111 | 270 | Waianae Elem | Regular School | No | Elementary | PK | 6 | 2019 | grade_6 | 75.0 | 75 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2736092 | 2736092 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000244 | 391 | Keonepoko Elem | Regular School | No | Elementary | PK | 6 | 2019 | grade_6 | 75.0 | 75 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2735999 | 2735999 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000112 | 269 | Pohakea Elem | Regular School | No | Elementary | PK | 6 | 2019 | grade_6 | 73.0 | 73 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2736032 | 2736032 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000236 | 331 | Kahuku Elem | Regular School | No | Elementary | PK | 6 | 2019 | grade_6 | 73.0 | 73 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2735952 | 2735952 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000154 | 221 | Nimitz Elem | Regular School | No | Elementary | PK | 6 | 2019 | grade_6 | 72.0 | 72 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2736037 | 2736037 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000017 | 319 | Laie Elem | Regular School | No | Elementary | PK | 6 | 2019 | grade_6 | 72.0 | 72 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2735953 | 2735953 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000153 | 222 | Pearl Harbor Elem | Regular School | No | Elementary | PK | 6 | 2019 | grade_6 | 71.0 | 71 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2736020 | 2736020 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000113 | 267 | Pearl City Highlands Elem | Regular School | No | Elementary | PK | 6 | 2019 | grade_6 | 70.0 | 70 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2736021 | 2736021 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000109 | 288 | Waiau Elem | Regular School | No | Elementary | PK | 6 | 2019 | grade_6 | 70.0 | 70 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2735979 | 2735979 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000142 | 231 | Waialua Elem | Regular School | No | Elementary | PK | 6 | 2019 | grade_6 | 68.0 | 68 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2736002 | 2736002 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000124 | 258 | Makaha Elem | Regular School | No | Elementary | PK | 6 | 2019 | grade_6 | 66.0 | 66 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2735957 | 2735957 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000149 | 225 | Red Hill Elem | Regular School | No | Elementary | PK | 6 | 2019 | grade_6 | 65.0 | 65 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2736017 | 2736017 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000116 | 264 | Palisades Elem | Regular School | No | Elementary | PK | 6 | 2019 | grade_6 | 65.0 | 65 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2736015 | 2736015 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000122 | 260 | Manana Elem | Regular School | No | Elementary | PK | 6 | 2019 | grade_6 | 63.0 | 63 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2736029 | 2736029 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000003 | 304 | Heeia Elem | Regular School | No | Elementary | PK | 6 | 2019 | grade_6 | 63.0 | 63 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2736004 | 2736004 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000118 | 262 | Nanakuli Elem | Regular School | No | Elementary | PK | 6 | 2019 | grade_6 | 61.0 | 61 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2736179 | 2736179 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000298 | 567 | SEEQS PCS | charter | Regular School | Yes | Middle | 06 | 8 | 2019 | grade_6 | 61.0 | 61 | |||||||||||||||||||||||||||||||||||||||||||||||||||
| 2735946 | 2735946 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000170 | 209 | Hickam Elem | Regular School | No | Elementary | PK | 6 | 2019 | grade_6 | 60.0 | 60 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2735962 | 2735962 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000139 | 235 | Webling Elem | Regular School | No | Elementary | PK | 6 | 2019 | grade_6 | 60.0 | 60 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2736071 | 2736071 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000249 | 361 | Honokaa Elem | Regular School | No | Elementary | PK | 6 | 2019 | grade_6 | 58.0 | 58 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2735961 | 2735961 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000140 | 233 | Waimalu Elem | Regular School | No | Elementary | PK | 6 | 2019 | grade_6 | 57.0 | 57 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2735959 | 2735959 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000147 | 227 | Scott Elem | Regular School | No | Elementary | PK | 6 | 2019 | grade_6 | 56.0 | 56 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2736060 | 2736060 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000031 | 357 | Hilo Union Elem | Regular School | No | Elementary | PK | 6 | 2019 | grade_6 | 56.0 | 56 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2736094 | 2736094 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000048 | 380 | Naalehu Elem | Regular School | No | Elementary | PK | 6 | 2019 | grade_6 | 55.0 | 55 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2736157 | 2736157 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000273 | 543 | University Laboratory School | charter | Regular School | Yes | Other | KG | 12 | 2019 | grade_6 | 55.0 | 55 | |||||||||||||||||||||||||||||||||||||||||||||||||||
| 2736048 | 2736048 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000011 | 311 | Kainalu Elem | Regular School | No | Elementary | PK | 6 | 2019 | grade_6 | 54.0 | 54 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2735941 | 2735941 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000178 | 200 | Aiea Elem | Regular School | No | Elementary | PK | 6 | 2019 | grade_6 | 52.0 | 52 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2736018 | 2736018 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000115 | 265 | Pearl City Elem | Regular School | No | Elementary | PK | 6 | 2019 | grade_6 | 52.0 | 52 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2736040 | 2736040 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000024 | 325 | Sunset Beach Elem | Regular School | No | Elementary | PK | 6 | 2019 | grade_6 | 52.0 | 52 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2736081 | 2736081 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000267 | 366 | Kohala Middle | Regular School | No | Middle | 06 | 8 | 2019 | grade_6 | 51.0 | 51 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2736016 | 2736016 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000120 | 285 | Momilani Elem | Regular School | No | Elementary | PK | 6 | 2019 | grade_6 | 50.0 | 50 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2736051 | 2736051 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000019 | 321 | Maunawili Elem | Regular School | No | Elementary | PK | 6 | 2019 | grade_6 | 50.0 | 50 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2736173 | 2736173 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000282 | 561 | Hawaii Academy of Arts & Science PCS | charter | Regular School | Yes | Other | KG | 12 | 2019 | grade_6 | 49.0 | 49 | |||||||||||||||||||||||||||||||||||||||||||||||||||
| 2736056 | 2736056 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000027 | 351 | de Silva Elem | Regular School | No | Elementary | PK | 6 | 2019 | grade_6 | 48.0 | 48 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2736158 | 2736158 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000274 | 544 | Myron Thompson Acad NCPCS | charter | Regular School | Yes | Other | KG | 12 | 2019 | grade_6 | 48.0 | 48 | |||||||||||||||||||||||||||||||||||||||||||||||||||
| 2736055 | 2736055 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000026 | 327 | Waimanalo El & Int | Regular School | No | Elementary | PK | 8 | 2019 | grade_6 | 47.0 | 47 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2736150 | 2736150 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000263 | 397 | Kanu O Ka Aina NCPCS | charter | Regular School | Yes | Other | KG | 12 | 2019 | grade_6 | 47.0 | 47 | |||||||||||||||||||||||||||||||||||||||||||||||||||
| 2736095 | 2736095 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000234 | 381 | Pahoa Elem | Regular School | No | Elementary | PK | 6 | 2019 | grade_6 | 46.0 | 46 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2736146 | 2736146 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000018 | 320 | Kaohao PCS | charter | Regular School | Yes | Elementary | PK | 6 | 2019 | grade_6 | 46.0 | 46 | |||||||||||||||||||||||||||||||||||||||||||||||||||
| 2736064 | 2736064 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000042 | 372 | Keaukaha Elem | Regular School | No | Elementary | PK | 6 | 2019 | grade_6 | 45.0 | 45 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2736119 | 2736119 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000062 | 407 | Kaunakakai Elem | Regular School | No | Elementary | PK | 6 | 2019 | grade_6 | 43.0 | 43 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2736175 | 2736175 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000284 | 563 | Ke Kula Nawahiokalaniopuu Iki Lab PCS | charter | Regular School | Yes | Elementary | PK | 8 | 2019 | grade_6 | 43.0 | 43 | |||||||||||||||||||||||||||||||||||||||||||||||||||
| 2735954 | 2735954 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000152 | 223 | Pearl Harbor Kai Elem | Regular School | No | Elementary | PK | 6 | 2019 | grade_6 | 42.0 | 42 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2736045 | 2736045 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000008 | 308 | Kailua Elem | Regular School | No | Elementary | PK | 6 | 2019 | grade_6 | 42.0 | 42 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2736042 | 2736042 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000101 | 300 | Aikahi Elem | Regular School | No | Elementary | PK | 6 | 2019 | grade_6 | 41.0 | 41 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2736063 | 2736063 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000039 | 369 | Kaumana Elem | Regular School | No | Elementary | PK | 6 | 2019 | grade_6 | 38.0 | 38 |
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]);