enrollments
Data source: Big Local News · About: Big Local
290 rows where grade = "grade_7", state = "HI" and year = 2017 sorted by unknown_race_int
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
128513 | 128513 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000248 | 280 | HOLOMUA | Regular School | No | Elementary | PK | 6 | 2017 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128514 | 128514 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000300 | 293 | HOOKELE EL | Regular School | No | Elementary | PK | 5 | 2017 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128515 | 128515 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000129 | 279 | ILIMA INT | Regular School | No | Middle | 07 | 8 | 2017 | grade_7 | 413.0 | 413 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128516 | 128516 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000128 | 256 | IROQUOIS POINT | Regular School | No | Elementary | PK | 6 | 2017 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128517 | 128517 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000127 | 281 | KAIMILOA | Regular School | No | Elementary | PK | 6 | 2017 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128518 | 128518 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000166 | 282 | KAPOLEI EL | Regular School | No | Elementary | PK | 5 | 2017 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128519 | 128519 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000261 | 292 | KAPOLEI HI | Regular School | No | High | 09 | 12 | 2017 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128520 | 128520 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000259 | 291 | KAPOLEI MID | Regular School | No | Middle | 06 | 8 | 2017 | grade_7 | 432.0 | 432 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128521 | 128521 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000291 | 294 | KEONEULA | Regular School | No | Elementary | PK | 6 | 2017 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128522 | 128522 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000123 | 259 | MAKAKILO | Regular School | No | Elementary | PK | 5 | 2017 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128523 | 128523 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000121 | 286 | MAUKA LANI | Regular School | No | Elementary | PK | 5 | 2017 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128524 | 128524 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000112 | 269 | POHAKEA | Regular School | No | Elementary | PK | 6 | 2017 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128525 | 128525 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000230 | 271 | LEIHOKU | Regular School | No | Elementary | PK | 6 | 2017 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128526 | 128526 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000125 | 257 | MAILI | Regular School | No | Elementary | PK | 6 | 2017 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128527 | 128527 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000124 | 258 | MAKAHA | Regular School | No | Elementary | PK | 6 | 2017 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128528 | 128528 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000119 | 261 | NANAIKAPONO | Regular School | No | Elementary | PK | 6 | 2017 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128529 | 128529 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000118 | 262 | NANAKULI EL | Regular School | No | Elementary | PK | 6 | 2017 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128530 | 128530 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000117 | 263 | NANAKULI HI & INT | Regular School | No | High | 07 | 12 | 2017 | grade_7 | 166.0 | 166 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128531 | 128531 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000111 | 270 | WAIANAE EL | Regular School | No | Elementary | PK | 6 | 2017 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128532 | 128532 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000110 | 272 | WAIANAE HI | Regular School | No | High | 09 | 12 | 2017 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128533 | 128533 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000229 | 273 | WAIANAE INT | Regular School | No | Middle | 07 | 8 | 2017 | grade_7 | 404.0 | 404 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128534 | 128534 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000136 | 250 | AHRENS | Regular School | No | Elementary | PK | 6 | 2017 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128535 | 128535 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000131 | 255 | HIGHLANDS INT | Regular School | No | Middle | 07 | 8 | 2017 | grade_7 | 407.0 | 407 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128536 | 128536 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000130 | 276 | HONOWAI | Regular School | No | Elementary | PK | 6 | 2017 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128537 | 128537 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000239 | 287 | KALEIOPUU | Regular School | No | Elementary | PK | 6 | 2017 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128538 | 128538 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000231 | 283 | KANOELANI | Regular School | No | Elementary | PK | 6 | 2017 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128539 | 128539 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000126 | 268 | LEHUA | Regular School | No | Elementary | PK | 6 | 2017 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128540 | 128540 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000122 | 260 | MANANA | Regular School | No | Elementary | PK | 6 | 2017 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128541 | 128541 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000120 | 285 | MOMILANI | Regular School | No | Elementary | PK | 6 | 2017 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128542 | 128542 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000116 | 264 | PALISADES | Regular School | No | Elementary | PK | 6 | 2017 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128543 | 128543 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000113 | 267 | PC HIGHLANDS | Regular School | No | Elementary | PK | 6 | 2017 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128544 | 128544 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000115 | 265 | PEARL CITY EL | Regular School | No | Elementary | PK | 6 | 2017 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128545 | 128545 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000114 | 266 | PEARL CITY HI | Regular School | No | High | 09 | 12 | 2017 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128546 | 128546 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000109 | 288 | WAIAU | Regular School | No | Elementary | PK | 6 | 2017 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128547 | 128547 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000257 | 290 | WAIKELE | Regular School | No | Elementary | PK | 6 | 2017 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128548 | 128548 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000159 | 274 | WAIPAHU EL | Regular School | No | Elementary | PK | 6 | 2017 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128549 | 128549 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000161 | 277 | WAIPAHU HI | Regular School | No | High | 09 | 12 | 2017 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128550 | 128550 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000158 | 278 | WAIPAHU INT | Regular School | No | Middle | 07 | 8 | 2017 | grade_7 | 617.0 | 617 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128551 | 128551 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000157 | 335 | AHUIMANU | Regular School | No | Elementary | PK | 6 | 2017 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128552 | 128552 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000100 | 301 | CASTLE HI | Regular School | No | High | 09 | 12 | 2017 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128553 | 128553 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000002 | 303 | HAUULA | Regular School | No | Elementary | PK | 6 | 2017 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128554 | 128554 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000003 | 304 | HEEIA | Regular School | No | Elementary | PK | 6 | 2017 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128555 | 128555 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000004 | 305 | KAAAWA | Regular School | No | Elementary | PK | 6 | 2017 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128556 | 128556 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000006 | 306 | KAHALUU | Regular School | No | Elementary | PK | 6 | 2017 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128557 | 128557 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000236 | 331 | KAHUKU EL | Regular School | No | Elementary | PK | 6 | 2017 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128558 | 128558 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000007 | 307 | KAHUKU HI | Regular School | No | High | 07 | 12 | 2017 | grade_7 | 208.0 | 208 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128559 | 128559 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000013 | 313 | KANEOHE | Regular School | No | Elementary | PK | 6 | 2017 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128560 | 128560 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000014 | 315 | KAPUNAHALA | Regular School | No | Elementary | PK | 6 | 2017 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128561 | 128561 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000016 | 318 | KING INT | Regular School | No | Middle | 07 | 8 | 2017 | grade_7 | 254.0 | 254 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128562 | 128562 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000017 | 319 | LAIE | Regular School | No | Elementary | PK | 6 | 2017 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128563 | 128563 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000021 | 323 | PARKER | Regular School | No | Elementary | PK | 6 | 2017 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128564 | 128564 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000023 | 314 | PUOHALA | Regular School | No | Elementary | PK | 6 | 2017 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128565 | 128565 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000024 | 325 | SUNSET BEACH | Regular School | No | Elementary | PK | 6 | 2017 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128566 | 128566 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000025 | 326 | WAIAHOLE | Regular School | No | Elementary | PK | 6 | 2017 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128567 | 128567 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000101 | 300 | AIKAHI | Regular School | No | Elementary | PK | 6 | 2017 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128568 | 128568 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000001 | 302 | ENCHANTED LAKE | Regular School | No | Elementary | PK | 6 | 2017 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128569 | 128569 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000005 | 330 | KAELEPULU | Regular School | No | Elementary | PK | 6 | 2017 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128570 | 128570 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000008 | 308 | KAILUA EL | Regular School | No | Elementary | PK | 6 | 2017 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128571 | 128571 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000009 | 309 | KAILUA HI | Regular School | No | High | 09 | 12 | 2017 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128572 | 128572 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000010 | 310 | KAILUA INT | Regular School | No | Middle | 07 | 8 | 2017 | grade_7 | 348.0 | 348 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128573 | 128573 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000011 | 311 | KAINALU | Regular School | No | Elementary | PK | 6 | 2017 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128574 | 128574 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000012 | 312 | KALAHEO HI | Regular School | No | High | 09 | 12 | 2017 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128575 | 128575 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000015 | 317 | KEOLU | Regular School | No | Elementary | PK | 6 | 2017 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128576 | 128576 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000019 | 321 | MAUNAWILI | Regular School | No | Elementary | PK | 6 | 2017 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128577 | 128577 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000020 | 322 | MOKAPU | Regular School | No | Elementary | PK | 6 | 2017 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128578 | 128578 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000098 | 475 | OLOMANA | Alternative School | No | High | 07 | 12 | 2017 | grade_7 | 1.0 | 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128579 | 128579 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000022 | 324 | POPE | Regular School | No | Elementary | PK | 6 | 2017 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128580 | 128580 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000026 | 327 | WAIMANALO EL & INT | Regular School | No | Elementary | PK | 8 | 2017 | grade_7 | 69.0 | 69 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128581 | 128581 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000027 | 351 | DE SILVA | Regular School | No | Elementary | PK | 6 | 2017 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128582 | 128582 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000028 | 352 | HAAHEO | Regular School | No | Elementary | PK | 6 | 2017 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128583 | 128583 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000029 | 355 | HILO HI | Regular School | No | High | 09 | 12 | 2017 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128584 | 128584 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000030 | 356 | HILO INT | Regular School | No | Middle | 07 | 8 | 2017 | grade_7 | 210.0 | 210 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128585 | 128585 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000031 | 357 | HILO UNION | Regular School | No | Elementary | PK | 6 | 2017 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128586 | 128586 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000036 | 365 | KALANIANAOLE EL & INT | Regular School | No | Elementary | PK | 8 | 2017 | grade_7 | 19.0 | 19 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128587 | 128587 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000037 | 367 | KAPIOLANI | Regular School | No | Elementary | PK | 6 | 2017 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128588 | 128588 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000039 | 369 | KAUMANA | Regular School | No | Elementary | PK | 6 | 2017 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128589 | 128589 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000042 | 372 | KEAUKAHA | Regular School | No | Elementary | PK | 6 | 2017 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128590 | 128590 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000051 | 384 | WAIAKEA EL | Regular School | No | Elementary | PK | 5 | 2017 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128591 | 128591 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000052 | 389 | WAIAKEA HI | Regular School | No | High | 09 | 12 | 2017 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128592 | 128592 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000053 | 385 | WAIAKEA INT | Regular School | No | Middle | 06 | 8 | 2017 | grade_7 | 256.0 | 256 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128593 | 128593 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000054 | 386 | WAIAKEAWAENA | Regular School | No | Elementary | PK | 5 | 2017 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128594 | 128594 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000032 | 358 | HOLUALOA | Regular School | No | Elementary | PK | 5 | 2017 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128595 | 128595 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000033 | 359 | HONAUNAU | Regular School | No | Elementary | PK | 5 | 2017 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128596 | 128596 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000249 | 361 | HONOKAA EL | Regular School | No | Elementary | PK | 6 | 2017 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128597 | 128597 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000034 | 360 | HONOKAA HI & INT | Regular School | No | High | 07 | 12 | 2017 | grade_7 | 51.0 | 51 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128598 | 128598 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000035 | 363 | HOOKENA | Regular School | No | Elementary | PK | 5 | 2017 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128599 | 128599 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000232 | 371 | KAHAKAI | Regular School | No | Elementary | PK | 5 | 2017 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128600 | 128600 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000287 | 378 | KE KULA O EHUNUIKAIMALINO | Regular School | No | Other | PK | 12 | 2017 | grade_7 | 20.0 | 20 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128601 | 128601 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000041 | 388 | KEALAKEHE | Regular School | No | Elementary | PK | 5 | 2017 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128602 | 128602 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000254 | 392 | KEALAKEHE HI | Regular School | No | High | 09 | 12 | 2017 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128603 | 128603 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000235 | 390 | KEALAKEHE INT | Regular School | No | Middle | 06 | 8 | 2017 | grade_7 | 183.0 | 183 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128604 | 128604 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000250 | 395 | KOHALA EL | Regular School | No | Elementary | PK | 5 | 2017 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128605 | 128605 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000043 | 373 | KOHALA HI | Regular School | No | High | 09 | 12 | 2017 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128606 | 128606 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000267 | 366 | KOHALA MID | Regular School | No | Middle | 06 | 8 | 2017 | grade_7 | 49.0 | 49 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128607 | 128607 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000044 | 375 | KONAWAENA EL | Regular School | No | Elementary | PK | 5 | 2017 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128608 | 128608 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000045 | 374 | KONAWAENA HI | Regular School | No | High | 09 | 12 | 2017 | grade_7 | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128609 | 128609 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000252 | 376 | KONAWAENA MID | Regular School | No | Middle | 06 | 8 | 2017 | grade_7 | 184.0 | 184 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128610 | 128610 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000049 | 382 | PAAUILO EL & INT | Regular School | No | Other | PK | 9 | 2017 | grade_7 | 16.0 | 16 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128611 | 128611 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000247 | 393 | WAIKOLOA | Regular School | No | Elementary | PK | 8 | 2017 | grade_7 | 57.0 | 57 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
128612 | 128612 | HI | school | 1500030 | 1 | Hawaii Department of Education | 150003000055 | 387 | WAIMEA EL | Regular School | No | Elementary | PK | 5 | 2017 | grade_7 | 0.0 | 0 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "enrollments" ( [state] TEXT, [county] TEXT, [county_state_id] INTEGER, [admin_level] TEXT, [district_nces_id] INTEGER, [district_state_id] TEXT, [district_state_type] TEXT, [district] TEXT, [school_nces_id] INTEGER, [school_state_id] INTEGER, [school] TEXT, [school_state_type] TEXT, [ccd_school_type] TEXT, [ccd_charter_school] TEXT, [ccd_school_lvl] TEXT, [ccd_school_low_grade] TEXT, [ccd_school_high_grade] TEXT, [year] INTEGER, [term] TEXT, [grade] TEXT, [white] TEXT, [black] TEXT, [hispanic] TEXT, [native_american] TEXT, [native_american_alaskan_native] TEXT, [asian] TEXT, [native_hawaiian] TEXT, [asian_pacific_islander] TEXT, [native_hawaiian_pacific_islander] TEXT, [pacific_islander] TEXT, [multiracial] TEXT, [unknown_race] TEXT, [male] TEXT, [female] TEXT, [non_binary] TEXT, [unknown_gender] TEXT, [ell] TEXT, [ell_percent] TEXT, [homeless] TEXT, [homeless_percent] TEXT, [low_income] TEXT, [free_and_reduced] TEXT, [free_and_reduced_percent] TEXT, [disability] TEXT, [section_504] TEXT, [total] TEXT , [white_int] INTEGER, [black_int] INTEGER, [hispanic_int] INTEGER, [native_american_int] INTEGER, [native_american_alaskan_native_int] INTEGER, [asian_int] INTEGER, [native_hawaiian_int] INTEGER, [asian_pacific_islander_int] INTEGER, [native_hawaiian_pacific_islander_int] INTEGER, [pacific_islander_int] INTEGER, [multiracial_int] INTEGER, [unknown_race_int] INTEGER, [male_int] INTEGER, [female_int] INTEGER, [non_binary_int] INTEGER, [unknown_gender_int] INTEGER, [ell_int] INTEGER, [homeless_int] INTEGER, [low_income_int] INTEGER, [free_and_reduced_int] INTEGER, [disability_int] INTEGER, [section_504_int] INTEGER, [total_int] INTEGER); CREATE INDEX [idx_enrollments_state_grade] ON [enrollments] ([state], [grade]); CREATE INDEX [idx_enrollments_grade] ON [enrollments] ([grade]); CREATE INDEX [idx_enrollments_year] ON [enrollments] ([year]); CREATE INDEX [idx_enrollments_state_year] ON [enrollments] ([state], [year]); CREATE INDEX [idx_enrollments_school_nces_id] ON [enrollments] ([school_nces_id]); CREATE INDEX [idx_enrollments_district_nces_id] ON [enrollments] ([district_nces_id]);