schools

Data source: Big Local News · About: Big Local

Custom SQL query returning 101 rows (hide)

Query parameters

rowidstatecountycounty_state_idadmin_leveldistrict_nces_iddistrict_state_iddistrict_state_typedistrictschool_nces_idschool_state_idschoolschool_state_typeccd_school_typeccd_charter_schoolccd_school_lvlccd_school_low_gradeccd_school_high_gradeyeartermgradewhiteblackhispanicnative_americannative_american_alaskan_nativeasiannative_hawaiianasian_pacific_islandernative_hawaiian_pacific_islanderpacific_islandermultiracialunknown_racemalefemalenon_binaryunknown_genderellell_percenthomelesshomeless_percentlow_incomefree_and_reducedfree_and_reduced_percentdisabilitysection_504totalwhite_intblack_inthispanic_intnative_american_intnative_american_alaskan_native_intasian_intnative_hawaiian_intasian_pacific_islander_intnative_hawaiian_pacific_islander_intpacific_islander_intmultiracial_intunknown_race_intmale_intfemale_intnon_binary_intunknown_gender_intell_inthomeless_intlow_income_intfree_and_reduced_intdisability_intsection_504_inttotal_int
281665 HI     school 1500030 1   Hawaii Department of Education 150003000091 461 NIIHAU   Regular School No 4 PK 12 2015   pk_12_total                                               0.0   9.0                                         0   9
111692 HI     school 1500030 1   Hawaii Department of Education 150003000091 461 NIIHAU   Regular School No 4 PK 12 2016   pk_12_total                                               0.0   4.0                                         0   4
111720 HI     school 1500030 1   Hawaii Department of Education 150003000299 550 MALAMA HONUA PCS charter Regular School Yes 1 KG 3 2016   pk_12_total                                               0.0   63.0                                         0   63
130695 HI     school 1500030 1   Hawaii Department of Education 150003000091 461 NIIHAU   Regular School No Other PK 12 2017   pk_12_total                                               0.0   11.0                                         0   11
2783526 HI     school 1500030 1   Hawaii Department of Education 150003000091 461 Niihau High & Elem   Regular School No Other PK 12 2018   pk_12_total                                               0.0   9.0                                         0   9
2738476 HI     school 1500030 1   Hawaii Department of Education 150003000091 461 Niihau High & Elem   Regular School No Other PK 12 2019   pk_12_total                                               0.0   9.0                                         0   9
2738494 HI     school 1500030 1   Hawaii Department of Education 150003000274 544 Myron Thompson Acad NCPCS charter Regular School Yes Other KG 12 2019   pk_12_total                                               0.0   568.0                                         0   568
2432820 HI     school 1500030 1   Hawaii Department of Education 150003000091 461 Niihau High & Elem   Regular School No Other PK 12 2020   pk_12_total                                               0.0   10.0                                         0   10
2457516 HI     school 1500030 1   Hawaii Department of Education 150003000091 461 Niihau High & Elem   Regular School No Other PK 12 2021   pk_12_total                                               0.0   15.0                                         0   15
281687 HI     school 1500030 1   Hawaii Department of Education 150003000276 547 KE KULA O KAMAKAU LAB-PCS charter Regular School Yes 4 PK 12 2015   pk_12_total                                               1.0   127.0                                         1   127
2783549 HI     school 1500030 1   Hawaii Department of Education 150003000276 547 Ke Kula O Kamakau Lab PCS charter Regular School Yes Other PK 12 2018   pk_12_total                                               1.0   133.0                                         1   133
2783557 HI     school 1500030 1   Hawaii Department of Education 150003000274 544 Myron Thompson Acad NCPCS charter Regular School Yes Other KG 12 2018   pk_12_total                                               1.0   582.0                                         1   582
2432852 HI     school 1500030 1   Hawaii Department of Education 150003000274 544 Myron Thompson Acad NCPCS charter Regular School Yes Other KG 12 2020   pk_12_total                                               1.0   585.0                                         1   585
2457548 HI     school 1500030 1   Hawaii Department of Education 150003000274 544 Myron Thompson Academy NCPCS charter Regular School Yes Other KG 12 2021   pk_12_total                                               1.0   527.0                                         1   527
281690 HI     school 1500030 1   Hawaii Department of Education 150003000299 550 MALAMA HONUA PCS charter Regular School Yes 1 KG 2 2015   pk_12_total                                               2.0   41.0                                         2   41
111713 HI     school 1500030 1   Hawaii Department of Education 150003000276 547 KE KULA O KAMAKAU LAB-PCS charter Regular School Yes 4 PK 12 2016   pk_12_total                                               2.0   142.0                                         2   142
130716 HI     school 1500030 1   Hawaii Department of Education 150003000276 547 KE KULA O KAMAKAU LAB-PCS charter Regular School Yes Other PK 12 2017   pk_12_total                                               2.0   141.0                                         2   141
130724 HI     school 1500030 1   Hawaii Department of Education 150003000274 544 MYRON THOMPSON ACAD-PCS charter Regular School Yes Other KG 12 2017   pk_12_total                                               2.0   685.0                                         2   685
2432844 HI     school 1500030 1   Hawaii Department of Education 150003000276 547 Ke Kula O Kamakau Lab PCS charter Regular School Yes Other PK 12 2020   pk_12_total                                               2.0   124.0                                         2   124
2457541 HI     school 1500030 1   Hawaii Department of Education 150003000280 556 Ke Kula O Niihau Kekaha LPCS charter Regular School Yes Other PK 12 2021   pk_12_total                                               2.0   55.0                                         2   55
281649 HI     school 1500030 1   Hawaii Department of Education 150003000074 419 MAUNALOA   Regular School No 1 PK 6 2015   pk_12_total                                               3.0   55.0                                         3   55
281693 HI     school 1500030 1   Hawaii Department of Education 150003000280 556 KE KULA NIIHAU KEKAHA-PCS charter Regular School Yes 4 KG 12 2015   pk_12_total                                               3.0   44.0                                         3   44
130675 HI     school 1500030 1   Hawaii Department of Education 150003000065 410 KILOHANA   Regular School No Elementary PK 6 2017   pk_12_total                                               3.0   82.0                                         3   82
130712 HI     school 1500030 1   Hawaii Department of Education 150003000301 552 KAU LEARNING ACAD-PCS charter Regular School Yes Elementary 03 7 2017   pk_12_total                                               3.0   96.0                                         3   96
130715 HI     school 1500030 1   Hawaii Department of Education 150003000280 556 KE KULA NIIHAU KEKAHA-PCS charter Regular School Yes Other KG 12 2017   pk_12_total                                               3.0   50.0                                         3   50
130723 HI     school 1500030 1   Hawaii Department of Education 150003000299 550 MALAMA HONUA PCS charter Regular School Yes Elementary KG 4 2017   pk_12_total                                               3.0   85.0                                         3   85
2783545 HI     school 1500030 1   Hawaii Department of Education 150003000301 552 Kau Learning Academy charter Regular School Yes Middle 03 7 2018   pk_12_total                                               3.0   79.0                                         3   79
2738497 HI     school 1500030 1   Hawaii Department of Education 150003000276 547 Ke Kula O Kamakau Lab PCS charter Regular School Yes Other PK 12 2019   pk_12_total                                               3.0   120.0                                         3   120
2457540 HI     school 1500030 1   Hawaii Department of Education 150003000276 547 Ke Kula O Kamakau Lab PCS charter Regular School Yes Other PK 12 2021   pk_12_total                                               3.0   136.0                                         3   136
281541 HI     school 1500030 1   Hawaii Department of Education 150003000120 285 MOMILANI   Regular School No 1 PK 6 2015   pk_12_total                                               4.0   427.0                                         4   427
111712 HI     school 1500030 1   Hawaii Department of Education 150003000280 556 KE KULA NIIHAU KEKAHA-PCS charter Regular School Yes 4 KG 12 2016   pk_12_total                                               4.0   54.0                                         4   54
2783550 HI     school 1500030 1   Hawaii Department of Education 150003000280 556 Ke Kula O Niihau Kekaha LPCS charter Regular School Yes Other PK 12 2018   pk_12_total                                               4.0   54.0                                         4   54
2783556 HI     school 1500030 1   Hawaii Department of Education 150003000299 550 Malama Honua charter Regular School Yes Elementary KG 5 2018   pk_12_total                                               4.0   103.0                                         4   103
2738490 HI     school 1500030 1   Hawaii Department of Education 150003000269 466 Kanaka PCS charter Regular School Yes Other PK 12 2019   pk_12_total                                               4.0   50.0                                         4   50
2738507 HI     school 1500030 1   Hawaii Department of Education 150003000304 558 Alakai O Kauai PCS charter Regular School Yes Elementary KG 5 2019   pk_12_total                                               4.0   123.0                                         4   123
2432836 HI     school 1500030 1   Hawaii Department of Education 150003000269 466 Kanaka PCS charter Regular School Yes Other PK 12 2020   pk_12_total                                               4.0   33.0                                         4   33
2432845 HI     school 1500030 1   Hawaii Department of Education 150003000280 556 Ke Kula O Niihau Kekaha LPCS charter Regular School Yes Other PK 12 2020   pk_12_total                                               4.0   50.0                                         4   50
2457283 HI     school 1500030 1   Hawaii Department of Education 150003000198 133 Linapuni Elem   Regular School No Elementary PK 1 2021   pk_12_total                                               4.0   94.0                                         4   94
2457426 HI     school 1500030 1   Hawaii Department of Education 150003000015 317 Keolu Elem   Regular School No Elementary PK 6 2021   pk_12_total                                               4.0   114.0                                         4   114
281684 HI     school 1500030 1   Hawaii Department of Education 150003000274 544 MYRON THOMPSON ACAD-PCS charter Regular School Yes 4 KG 12 2015   pk_12_total                                               5.0   584.0                                         5   584
281698 HI     school 1500030 1   Hawaii Department of Education 150003000284 563 NAWAHI IKI LAB-PCS charter Regular School Yes 1 KG 8 2015   pk_12_total                                               5.0   294.0                                         5   294
111676 HI     school 1500030 1   Hawaii Department of Education 150003000074 419 MAUNALOA   Regular School No 1 PK 6 2016   pk_12_total                                               5.0   60.0                                         5   60
111709 HI     school 1500030 1   Hawaii Department of Education 150003000301 552 KAU LEARNING ACAD-PCS charter Regular School Yes 1 03 6 2016   pk_12_total                                               5.0   94.0                                         5   94
111710 HI     school 1500030 1   Hawaii Department of Education 150003000294 565 KAWAIKINI-PCS charter Regular School Yes 4 KG 12 2016   pk_12_total                                               5.0   141.0                                         5   141
130463 HI     school 1500030 1   Hawaii Department of Education 150003000198 133 LINAPUNI   Regular School No Elementary PK 1 2017   pk_12_total                                               5.0   160.0                                         5   160
130709 HI     school 1500030 1   Hawaii Department of Education 150003000269 466 KANAKA-PCS charter Regular School Yes Other KG 12 2017   pk_12_total                                               5.0   48.0                                         5   48
2783540 HI     school 1500030 1   Hawaii Department of Education 150003000269 466 Kanaka PCS charter Regular School Yes Other PK 12 2018   pk_12_total                                               5.0   50.0                                         5   50
2738505 HI     school 1500030 1   Hawaii Department of Education 150003000280 556 Ke Kula O Niihau Kekaha LPCS charter Regular School Yes Other PK 12 2019   pk_12_total                                               5.0   52.0                                         5   52
281645 HI     school 1500030 1   Hawaii Department of Education 150003000065 410 KILOHANA   Regular School No 1 PK 6 2015   pk_12_total                                               6.0   65.0                                         6   65
281700 HI     school 1500030 1   Hawaii Department of Education 150003000294 565 KAWAIKINI-PCS charter Regular School Yes 4 KG 12 2015   pk_12_total                                               6.0   136.0                                         6   136
111460 HI     school 1500030 1   Hawaii Department of Education 150003000198 133 LINAPUNI   Regular School No 1 PK 1 2016   pk_12_total                                               6.0   138.0                                         6   138
111723 HI     school 1500030 1   Hawaii Department of Education 150003000284 563 NAWAHI IKI LAB-PCS charter Regular School Yes 1 PK 8 2016   pk_12_total                                               6.0   345.0                                         6   345
130679 HI     school 1500030 1   Hawaii Department of Education 150003000074 419 MAUNALOA   Regular School No Elementary PK 6 2017   pk_12_total                                               6.0   51.0                                         6   51
130713 HI     school 1500030 1   Hawaii Department of Education 150003000294 565 KAWAIKINI-PCS charter Regular School Yes Other KG 12 2017   pk_12_total                                               6.0   150.0                                         6   150
2783544 HI     school 1500030 1   Hawaii Department of Education 150003000302 555 Kapolei Charter School charter Regular School Yes Secondary 09 9 2018   pk_12_total                                               6.0   49.0                                         6   49
2783548 HI     school 1500030 1   Hawaii Department of Education 150003000284 563 Ke Kula Nawahiokalaniopuu Iki Lab PCS charter Regular School Yes Elementary PK 8 2018   pk_12_total                                               6.0   426.0                                         6   426
2738377 HI     school 1500030 1   Hawaii Department of Education 150003000025 326 Waiahole Elem   Regular School No Elementary PK 6 2019   pk_12_total                                               6.0   71.0                                         6   71
2738510 HI     school 1500030 1   Hawaii Department of Education 150003000283 562 Ka Umeke Kaeo PCS charter Regular School Yes Other PK 10 2019   pk_12_total                                               6.0   207.0                                         6   207
2432804 HI     school 1500030 1   Hawaii Department of Education 150003000074 419 Maunaloa Elem   Regular School No Elementary PK 6 2020   pk_12_total                                               6.0   36.0                                         6   36
2432824 HI     school 1500030 1   Hawaii Department of Education 150003000304 558 Alakai O Kauai PCS charter Regular School Yes Elementary KG 6 2020   pk_12_total                                               6.0   149.0                                         6   149
2457500 HI     school 1500030 1   Hawaii Department of Education 150003000074 419 Maunaloa Elem   Regular School No Elementary PK 6 2021   pk_12_total                                               6.0   40.0                                         6   40
2457532 HI     school 1500030 1   Hawaii Department of Education 150003000269 466 Kanaka PCS charter Regular School Yes Other PK 12 2021   pk_12_total                                               6.0   33.0                                         6   33
281434 HI     school 1500030 1   Hawaii Department of Education 150003000198 133 LINAPUNI   Regular School No 1 PK 1 2015   pk_12_total                                               7.0   151.0                                         7   151
111568 HI     school 1500030 1   Hawaii Department of Education 150003000120 285 MOMILANI   Regular School No 1 PK 6 2016   pk_12_total                                               7.0   418.0                                         7   418
111706 HI     school 1500030 1   Hawaii Department of Education 150003000269 466 KANAKA-PCS charter Regular School Yes 4 KG 12 2016   pk_12_total                                               7.0   56.0                                         7   56
130726 HI     school 1500030 1   Hawaii Department of Education 150003000284 563 NAWAHI IKI LAB-PCS charter Regular School Yes Elementary PK 8 2017   pk_12_total                                               7.0   395.0                                         7   395
2783506 HI     school 1500030 1   Hawaii Department of Education 150003000065 410 Kilohana Elem   Regular School No Elementary PK 6 2018   pk_12_total                                               7.0   83.0                                         7   83
2432755 HI     school 1500030 1   Hawaii Department of Education 150003000287 378 Ke Kula o Ehunuikaimalino   Regular School No Other PK 12 2020   pk_12_total                                               7.0   246.0                                         7   246
2432843 HI     school 1500030 1   Hawaii Department of Education 150003000284 563 Ke Kula Nawahiokalaniopuu Iki Lab PCS charter Regular School Yes Elementary PK 8 2020   pk_12_total                                               7.0   463.0                                         7   463
2457451 HI     school 1500030 1   Hawaii Department of Education 150003000287 378 Ke Kula o Ehunuikaimalino   Regular School No Other PK 12 2021   pk_12_total                                               7.0   260.0                                         7   260
2457520 HI     school 1500030 1   Hawaii Department of Education 150003000304 558 Alakai O Kauai PCS charter Regular School Yes Elementary KG 6 2021   pk_12_total                                               7.0   164.0                                         7   164
2457543 HI     school 1500030 1   Hawaii Department of Education 150003000293 566 Kona Pacific PCS charter Regular School Yes Elementary KG 8 2021   pk_12_total                                               7.0   211.0                                         7   211
130706 HI     school 1500030 1   Hawaii Department of Education 150003000283 562 KA 'UMEKE KA'EO-PCS charter Regular School Yes Elementary PK 8 2017   pk_12_total                                               8.0   215.0                                         8   215
130711 HI     school 1500030 1   Hawaii Department of Education 150003000289 564 KANUIKAPONO-PCS charter Regular School Yes Other KG 12 2017   pk_12_total                                               8.0   186.0                                         8   186
2783510 HI     school 1500030 1   Hawaii Department of Education 150003000074 419 Maunaloa Elem   Regular School No Elementary PK 6 2018   pk_12_total                                               8.0   41.0                                         8   41
2783536 HI     school 1500030 1   Hawaii Department of Education 150003000283 562 Ka Umeke Kaeo PCS charter Regular School Yes Other PK 9 2018   pk_12_total                                               8.0   205.0                                         8   205
2738460 HI     school 1500030 1   Hawaii Department of Education 150003000074 419 Maunaloa Elem   Regular School No Elementary PK 6 2019   pk_12_total                                               8.0   38.0                                         8   38
2738487 HI     school 1500030 1   Hawaii Department of Education 150003000264 398 Na Wai Ola NCPCS charter Regular School Yes Elementary PK 6 2019   pk_12_total                                               8.0   146.0                                         8   146
2738500 HI     school 1500030 1   Hawaii Department of Education 150003000299 550 Malama Honua charter Regular School Yes Elementary KG 6 2019   pk_12_total                                               8.0   126.0                                         8   126
2432753 HI     school 1500030 1   Hawaii Department of Education 150003000035 363 Hookena Elem   Regular School No Elementary PK 5 2020   pk_12_total                                               8.0   111.0                                         8   111
2432800 HI     school 1500030 1   Hawaii Department of Education 150003000065 410 Kilohana Elem   Regular School No Elementary PK 6 2020   pk_12_total                                               8.0   71.0                                         8   71
2432826 HI     school 1500030 1   Hawaii Department of Education 150003000305 568 DreamHouse Ewa Beach charter Regular School Yes Middle 06 6 2020   pk_12_total                                               8.0   85.0                                         8   85
2457496 HI     school 1500030 1   Hawaii Department of Education 150003000065 410 Kilohana Elem   Regular School No Elementary PK 6 2021   pk_12_total                                               8.0   67.0                                         8   67
281575 HI     school 1500030 1   Hawaii Department of Education 150003000015 317 KEOLU   Regular School No 1 PK 6 2015   pk_12_total                                               9.0   138.0                                         9   138
281679 HI     school 1500030 1   Hawaii Department of Education 150003000269 466 KANAKA-PCS charter Regular School Yes 4 KG 12 2015   pk_12_total                                               9.0   60.0                                         9   60
281686 HI     school 1500030 1   Hawaii Department of Education 150003000275 546 HAKIPU'U LEARNING CTR-PCS charter Regular School Yes 4 04 12 2015   pk_12_total                                               9.0   63.0                                         9   63
281689 HI     school 1500030 1   Hawaii Department of Education 150003000278 549 KE ANA LA'AHANA-PCS charter Regular School Yes 3 07 12 2015   pk_12_total                                               9.0   45.0                                         9   45
111478 HI     school 1500030 1   Hawaii Department of Education 150003000202 129 LANAKILA   Regular School No 1 PK 5 2016   pk_12_total                                               9.0   382.0                                         9   382
111609 HI     school 1500030 1   Hawaii Department of Education 150003000028 352 HAAHEO   Regular School No 1 PK 6 2016   pk_12_total                                               9.0   182.0                                         9   182
111672 HI     school 1500030 1   Hawaii Department of Education 150003000065 410 KILOHANA   Regular School No 1 PK 6 2016   pk_12_total                                               9.0   80.0                                         9   80
111715 HI     school 1500030 1   Hawaii Department of Education 150003000293 566 KONA PACIFIC-PCS charter Regular School Yes 1 KG 8 2016   pk_12_total                                               9.0   226.0                                         9   226
111721 HI     school 1500030 1   Hawaii Department of Education 150003000274 544 MYRON THOMPSON ACAD-PCS charter Regular School Yes 4 KG 12 2016   pk_12_total                                               9.0   683.0                                         9   683
130571 HI     school 1500030 1   Hawaii Department of Education 150003000120 285 MOMILANI   Regular School No Elementary PK 6 2017   pk_12_total                                               9.0   407.0                                         9   407
130725 HI     school 1500030 1   Hawaii Department of Education 150003000264 398 NA WAI OLA PCS charter Regular School Yes Elementary PK 6 2017   pk_12_total                                               9.0   178.0                                         9   178
2783294 HI     school 1500030 1   Hawaii Department of Education 150003000198 133 Linapuni Elem   Regular School No Elementary PK 1 2018   pk_12_total                                               9.0   147.0                                         9   147
2783427 HI     school 1500030 1   Hawaii Department of Education 150003000025 326 Waiahole Elem   Regular School No Elementary PK 6 2018   pk_12_total                                               9.0   84.0                                         9   84
2783546 HI     school 1500030 1   Hawaii Department of Education 150003000294 565 Kawaikini NCPCS charter Regular School Yes Other KG 12 2018   pk_12_total                                               9.0   147.0                                         9   147
2738244 HI     school 1500030 1   Hawaii Department of Education 150003000198 133 Linapuni Elem   Regular School No Elementary PK 1 2019   pk_12_total                                               9.0   160.0                                         9   160
2738409 HI     school 1500030 1   Hawaii Department of Education 150003000035 363 Hookena Elem   Regular School No Elementary PK 5 2019   pk_12_total                                               9.0   106.0                                         9   106
2738504 HI     school 1500030 1   Hawaii Department of Education 150003000302 555 Kapolei Charter School charter Regular School Yes Secondary 09 10 2019   pk_12_total                                               9.0   89.0                                         9   89
2738511 HI     school 1500030 1   Hawaii Department of Education 150003000284 563 Ke Kula Nawahiokalaniopuu Iki Lab PCS charter Regular School Yes Elementary PK 8 2019   pk_12_total                                               9.0   450.0                                         9   450