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
2429910 HI     school 1500030 1   Hawaii Department of Education 150003000302 555 Kapolei Charter School charter Regular School Yes Secondary 09 11 2020   grade_4                                                   0.0                                             0
2735584 HI     school 1500030 1   Hawaii Department of Education 150003000302 555 Kapolei Charter School charter Regular School Yes Secondary 09 10 2019   grade_4                                                   0.0                                             0
2780624 HI     school 1500030 1   Hawaii Department of Education 150003000302 555 Kapolei Charter School charter Regular School Yes Secondary 09 9 2018   grade_4                                                   0.0                                             0
127548 HI     school 1500030 1   Hawaii Department of Education 150003000096 470 HSDB   Special Education School No Other PK 12 2017   grade_4                                                   0.0                                             0
127570 HI     school 1500030 1   Hawaii Department of Education 150003000246 103 ANUENUE   Regular School No Other PK 12 2017   grade_4                                                   35.0                                             35
127730 HI     school 1500030 1   Hawaii Department of Education 150003000287 378 KE KULA O EHUNUIKAIMALINO   Regular School No Other PK 12 2017   grade_4                                                   16.0                                             16
127740 HI     school 1500030 1   Hawaii Department of Education 150003000049 382 PAAUILO EL & INT   Regular School No Other PK 9 2017   grade_4                                                   24.0                                             24
127743 HI     school 1500030 1   Hawaii Department of Education 150003000038 368 KAU HI/PAHALA EL   Regular School No Other PK 12 2017   grade_4                                                   13.0                                             13
127772 HI     school 1500030 1   Hawaii Department of Education 150003000058 402 HANA HI & EL   Regular School No Other PK 12 2017   grade_4                                                   23.0                                             23
127778 HI     school 1500030 1   Hawaii Department of Education 150003000070 415 LANAI HI & EL   Regular School No Other PK 12 2017   grade_4                                                   31.0                                             31
127795 HI     school 1500030 1   Hawaii Department of Education 150003000091 461 NIIHAU   Regular School No Other PK 12 2017   grade_4                                                   3.0                                             3
127799 HI     school 1500030 1   Hawaii Department of Education 150003000262 396 CONNECTIONS-PCS charter Regular School Yes Other KG 12 2017   grade_4                                                   20.0                                             20
127800 HI     school 1500030 1   Hawaii Department of Education 150003000273 543 EDUC LAB: A HAWAII NC-PCS charter Regular School Yes Other KG 12 2017   grade_4                                                   10.0                                             10
127801 HI     school 1500030 1   Hawaii Department of Education 150003000275 546 HAKIPU'U LEARNING CTR-PCS charter Regular School Yes Other 04 12 2017   grade_4                                                   2.0                                             2
127802 HI     school 1500030 1   Hawaii Department of Education 150003000270 540 HALAU KU MANA-PCS charter Regular School Yes Other 04 12 2017   grade_4                                                   8.0                                             8
127803 HI     school 1500030 1   Hawaii Department of Education 150003000295 551 HAWAII TECHNOLOGY ACADEMY charter Regular School Yes Other KG 12 2017   grade_4                                                   50.0                                             50
127804 HI     school 1500030 1   Hawaii Department of Education 150003000282 561 HI ACADEMY OF A&S-PCS charter Regular School Yes Other KG 12 2017   grade_4                                                   33.0                                             33
127808 HI     school 1500030 1   Hawaii Department of Education 150003000240 275 KAMAILE ACADEMY charter Regular School Yes Other PK 12 2017   grade_4                                                   90.0                                             90
127809 HI     school 1500030 1   Hawaii Department of Education 150003000269 466 KANAKA-PCS charter Regular School Yes Other KG 12 2017   grade_4                                                   2.0                                             2
127810 HI     school 1500030 1   Hawaii Department of Education 150003000263 397 KANU O KA'AINA-PCS charter Regular School Yes Other KG 12 2017   grade_4                                                   31.0                                             31
127811 HI     school 1500030 1   Hawaii Department of Education 150003000289 564 KANUIKAPONO-PCS charter Regular School Yes Other KG 12 2017   grade_4                                                   17.0                                             17
127813 HI     school 1500030 1   Hawaii Department of Education 150003000294 565 KAWAIKINI-PCS charter Regular School Yes Other KG 12 2017   grade_4                                                   12.0                                             12
127815 HI     school 1500030 1   Hawaii Department of Education 150003000280 556 KE KULA NIIHAU KEKAHA-PCS charter Regular School Yes Other KG 12 2017   grade_4                                                   3.0                                             3
127816 HI     school 1500030 1   Hawaii Department of Education 150003000276 547 KE KULA O KAMAKAU LAB-PCS charter Regular School Yes Other PK 12 2017   grade_4                                                   12.0                                             12
127817 HI     school 1500030 1   Hawaii Department of Education 150003000279 554 KIHEI PC SCHOOL-PCS charter Regular School Yes Other KG 12 2017   grade_4                                                   19.0                                             19
127819 HI     school 1500030 1   Hawaii Department of Education 150003000288 557 KUA O KA LA-PCS charter Regular School Yes Other KG 12 2017   grade_4                                                   17.0                                             17
127822 HI     school 1500030 1   Hawaii Department of Education 150003000046 377 LAUPAHOEHOE COMMUNITY - PCS charter Regular School Yes Other PK 12 2017   grade_4                                                   14.0                                             14
127824 HI     school 1500030 1   Hawaii Department of Education 150003000274 544 MYRON THOMPSON ACAD-PCS charter Regular School Yes Other KG 12 2017   grade_4                                                   72.0                                             72
127832 HI     school 1500030 1   Hawaii Department of Education 150003000265 399 WEST HI EXPLOR ACAD-PCS charter Regular School Yes Other 06 12 2017   grade_4                                                   0.0                                             0
2429643 HI     school 1500030 1   Hawaii Department of Education 150003000096 470 Hawaii School for the Deaf and Blind   Special Education School No Other PK 12 2020   grade_4                                                   0.0                                             0
2429665 HI     school 1500030 1   Hawaii Department of Education 150003000246 103 Anuenue   Regular School No Other PK 12 2020   grade_4                                                   51.0                                             51
2429825 HI     school 1500030 1   Hawaii Department of Education 150003000287 378 Ke Kula o Ehunuikaimalino   Regular School No Other PK 12 2020   grade_4                                                   24.0                                             24
2429835 HI     school 1500030 1   Hawaii Department of Education 150003000049 382 Paauilo El & Int   Regular School No Other PK 9 2020   grade_4                                                   19.0                                             19
2429838 HI     school 1500030 1   Hawaii Department of Education 150003000038 368 Kau High & Pahala Elem   Regular School No Other PK 12 2020   grade_4                                                   15.0                                             15
2429867 HI     school 1500030 1   Hawaii Department of Education 150003000058 402 Hana High & Elem   Regular School No Other PK 12 2020   grade_4                                                   28.0                                             28
2429873 HI     school 1500030 1   Hawaii Department of Education 150003000070 415 Lanai High & Elem   Regular School No Other PK 12 2020   grade_4                                                   45.0                                             45
2429890 HI     school 1500030 1   Hawaii Department of Education 150003000091 461 Niihau High & Elem   Regular School No Other PK 12 2020   grade_4                                                   2.0                                             2
2429895 HI     school 1500030 1   Hawaii Department of Education 150003000262 396 Connections NCPCS charter Regular School Yes Other KG 12 2020   grade_4                                                   23.0                                             23
2429897 HI     school 1500030 1   Hawaii Department of Education 150003000275 546 Hakipuu Learning Ctr PCS charter Regular School Yes Other 04 12 2020   grade_4                                                   2.0                                             2
2429898 HI     school 1500030 1   Hawaii Department of Education 150003000270 540 Halau Ku Mana NCPCS charter Regular School Yes Other 04 12 2020   grade_4                                                   5.0                                             5
2429899 HI     school 1500030 1   Hawaii Department of Education 150003000282 561 Hawaii Academy of Arts & Science PCS charter Regular School Yes Other KG 12 2020   grade_4                                                   37.0                                             37
2429900 HI     school 1500030 1   Hawaii Department of Education 150003000295 551 Hawaii Tech Acad PCS charter Regular School Yes Other KG 12 2020   grade_4                                                   50.0                                             50
2429902 HI     school 1500030 1   Hawaii Department of Education 150003000283 562 Ka Umeke Kaeo PCS charter Regular School Yes Other PK 11 2020   grade_4                                                   26.0                                             26
2429904 HI     school 1500030 1   Hawaii Department of Education 150003000240 275 Kamaile Academy PCS charter Regular School Yes Other PK 12 2020   grade_4                                                   68.0                                             68
2429906 HI     school 1500030 1   Hawaii Department of Education 150003000269 466 Kanaka PCS charter Regular School Yes Other PK 12 2020   grade_4                                                   2.0                                             2
2429907 HI     school 1500030 1   Hawaii Department of Education 150003000263 397 Kanu O Ka Aina NCPCS charter Regular School Yes Other KG 12 2020   grade_4                                                   42.0                                             42
2429908 HI     school 1500030 1   Hawaii Department of Education 150003000289 564 Kanuikapono PCS charter Regular School Yes Other KG 12 2020   grade_4                                                   19.0                                             19
2429911 HI     school 1500030 1   Hawaii Department of Education 150003000294 565 Kawaikini NCPCS charter Regular School Yes Other KG 12 2020   grade_4                                                   16.0                                             16
2429914 HI     school 1500030 1   Hawaii Department of Education 150003000276 547 Ke Kula O Kamakau Lab PCS charter Regular School Yes Other PK 12 2020   grade_4                                                   8.0                                             8
2429915 HI     school 1500030 1   Hawaii Department of Education 150003000280 556 Ke Kula O Niihau Kekaha LPCS charter Regular School Yes Other PK 12 2020   grade_4                                                   5.0                                             5
2429916 HI     school 1500030 1   Hawaii Department of Education 150003000279 554 Kihei Charter School charter Regular School Yes Other KG 12 2020   grade_4                                                   41.0                                             41
2429918 HI     school 1500030 1   Hawaii Department of Education 150003000288 557 Kua O Ka La PCS charter Regular School Yes Other PK 12 2020   grade_4                                                   21.0                                             21
2429920 HI     school 1500030 1   Hawaii Department of Education 150003000046 377 Laupahoehoe Community PCS charter Regular School Yes Other PK 12 2020   grade_4                                                   32.0                                             32
2429922 HI     school 1500030 1   Hawaii Department of Education 150003000274 544 Myron Thompson Acad NCPCS charter Regular School Yes Other KG 12 2020   grade_4                                                   61.0                                             61
2429925 HI     school 1500030 1   Hawaii Department of Education 150003000273 543 University Laboratory School charter Regular School Yes Other KG 12 2020   grade_4                                                   9.0                                             9
2454328 HI     school 1500030 1   Hawaii Department of Education 150003000096 470 Hawaii School for the Deaf and Blind   Special Education School No Other PK 12 2021   grade_4                                                   0.0                                             0
2454350 HI     school 1500030 1   Hawaii Department of Education 150003000246 103 Anuenue   Regular School No Other PK 12 2021   grade_4                                                   45.0                                             45
2454511 HI     school 1500030 1   Hawaii Department of Education 150003000287 378 Ke Kula o Ehunuikaimalino   Regular School No Other PK 12 2021   grade_4                                                   24.0                                             24
2454521 HI     school 1500030 1   Hawaii Department of Education 150003000049 382 Paauilo El & Int   Regular School No Other PK 9 2021   grade_4                                                   23.0                                             23
2454524 HI     school 1500030 1   Hawaii Department of Education 150003000038 368 Kau High & Pahala Elem   Regular School No Other PK 12 2021   grade_4                                                   10.0                                             10
2454553 HI     school 1500030 1   Hawaii Department of Education 150003000058 402 Hana High & Elem   Regular School No Other PK 12 2021   grade_4                                                   25.0                                             25
2454559 HI     school 1500030 1   Hawaii Department of Education 150003000070 415 Lanai High & Elem   Regular School No Other PK 12 2021   grade_4                                                   33.0                                             33
2454576 HI     school 1500030 1   Hawaii Department of Education 150003000091 461 Niihau High & Elem   Regular School No Other PK 12 2021   grade_4                                                   1.0                                             1
2454581 HI     school 1500030 1   Hawaii Department of Education 150003000262 396 Connections NCPCS charter Regular School Yes Other KG 12 2021   grade_4                                                   20.0                                             20
2454584 HI     school 1500030 1   Hawaii Department of Education 150003000270 540 Halau Ku Mana NCPCS charter Regular School Yes Other 04 12 2021   grade_4                                                   5.0                                             5
2454585 HI     school 1500030 1   Hawaii Department of Education 150003000282 561 Hawaii Academy of Arts & Science PCS charter Regular School Yes Other KG 12 2021   grade_4                                                   45.0                                             45
2454586 HI     school 1500030 1   Hawaii Department of Education 150003000295 551 Hawaii Tech Academy PCS charter Regular School Yes Other KG 12 2021   grade_4                                                   41.0                                             41
2454588 HI     school 1500030 1   Hawaii Department of Education 150003000283 562 Ka Umeke Kaeo PCS charter Regular School Yes Other PK 11 2021   grade_4                                                   22.0                                             22
2454590 HI     school 1500030 1   Hawaii Department of Education 150003000240 275 Kamaile Academy PCS charter Regular School Yes Other PK 12 2021   grade_4                                                   80.0                                             80
2454592 HI     school 1500030 1   Hawaii Department of Education 150003000269 466 Kanaka PCS charter Regular School Yes Other PK 12 2021   grade_4                                                   4.0                                             4
2454593 HI     school 1500030 1   Hawaii Department of Education 150003000263 397 Kanu O Ka Aina NCPCS charter Regular School Yes Other KG 12 2021   grade_4                                                   57.0                                             57
2454594 HI     school 1500030 1   Hawaii Department of Education 150003000289 564 Kanuikapono PCS charter Regular School Yes Other KG 12 2021   grade_4                                                   22.0                                             22
2454597 HI     school 1500030 1   Hawaii Department of Education 150003000294 565 Kawaikini NCPCS charter Regular School Yes Other KG 12 2021   grade_4                                                   14.0                                             14
2454600 HI     school 1500030 1   Hawaii Department of Education 150003000276 547 Ke Kula O Kamakau Lab PCS charter Regular School Yes Other PK 12 2021   grade_4                                                   11.0                                             11
2454601 HI     school 1500030 1   Hawaii Department of Education 150003000280 556 Ke Kula O Niihau Kekaha LPCS charter Regular School Yes Other PK 12 2021   grade_4                                                   5.0                                             5
2454602 HI     school 1500030 1   Hawaii Department of Education 150003000279 554 Kihei Charter School charter Regular School Yes Other KG 12 2021   grade_4                                                   36.0                                             36
2454606 HI     school 1500030 1   Hawaii Department of Education 150003000046 377 Laupahoehoe Community PCS charter Regular School Yes Other PK 12 2021   grade_4                                                   41.0                                             41
2454608 HI     school 1500030 1   Hawaii Department of Education 150003000274 544 Myron Thompson Academy NCPCS charter Regular School Yes Other KG 12 2021   grade_4                                                   47.0                                             47
2454611 HI     school 1500030 1   Hawaii Department of Education 150003000273 543 University Laboratory School charter Regular School Yes Other KG 12 2021   grade_4                                                   10.0                                             10
2454612 HI     school 1500030 1   Hawaii Department of Education 150003000281 560 Volcano School of Arts & Sciences PCS charter Regular School Yes Other PK 10 2021   grade_4                                                   23.0                                             23
2735309 HI     school 1500030 1   Hawaii Department of Education 150003000096 470 Hawaii School for the Deaf and Blind   Special Education School No Other PK 12 2019   grade_4                                                   0.0                                             0
2735331 HI     school 1500030 1   Hawaii Department of Education 150003000246 103 Anuenue   Regular School No Other PK 12 2019   grade_4                                                   31.0                                             31
2735491 HI     school 1500030 1   Hawaii Department of Education 150003000287 378 Ke Kula o Ehunuikaimalino   Regular School No Other PK 12 2019   grade_4                                                   24.0                                             24
2735501 HI     school 1500030 1   Hawaii Department of Education 150003000049 382 Paauilo El & Int   Regular School No Other PK 9 2019   grade_4                                                   10.0                                             10
2735504 HI     school 1500030 1   Hawaii Department of Education 150003000038 368 Kau High & Pahala Elem   Regular School No Other PK 12 2019   grade_4                                                   9.0                                             9
2735533 HI     school 1500030 1   Hawaii Department of Education 150003000058 402 Hana High & Elem   Regular School No Other PK 12 2019   grade_4                                                   26.0                                             26
2735539 HI     school 1500030 1   Hawaii Department of Education 150003000070 415 Lanai High & Elem   Regular School No Other PK 12 2019   grade_4                                                   31.0                                             31
2735556 HI     school 1500030 1   Hawaii Department of Education 150003000091 461 Niihau High & Elem   Regular School No Other PK 12 2019   grade_4                                                   1.0                                             1
2735561 HI     school 1500030 1   Hawaii Department of Education 150003000240 275 Kamaile Academy PCS charter Regular School Yes Other PK 12 2019   grade_4                                                   44.0                                             44
2735563 HI     school 1500030 1   Hawaii Department of Education 150003000046 377 Laupahoehoe Community PCS charter Regular School Yes Other PK 12 2019   grade_4                                                   20.0                                             20
2735565 HI     school 1500030 1   Hawaii Department of Education 150003000262 396 Connections NCPCS charter Regular School Yes Other KG 12 2019   grade_4                                                   22.0                                             22
2735566 HI     school 1500030 1   Hawaii Department of Education 150003000263 397 Kanu O Ka Aina NCPCS charter Regular School Yes Other KG 12 2019   grade_4                                                   57.0                                             57
2735570 HI     school 1500030 1   Hawaii Department of Education 150003000269 466 Kanaka PCS charter Regular School Yes Other PK 12 2019   grade_4                                                   5.0                                             5
2735571 HI     school 1500030 1   Hawaii Department of Education 150003000270 540 Halau Ku Mana NCPCS charter Regular School Yes Other 04 12 2019   grade_4                                                   8.0                                             8
2735573 HI     school 1500030 1   Hawaii Department of Education 150003000273 543 University Laboratory School charter Regular School Yes Other KG 12 2019   grade_4                                                   10.0                                             10
2735574 HI     school 1500030 1   Hawaii Department of Education 150003000274 544 Myron Thompson Acad NCPCS charter Regular School Yes Other KG 12 2019   grade_4                                                   48.0                                             48
2735576 HI     school 1500030 1   Hawaii Department of Education 150003000275 546 Hakipuu Learning Ctr PCS charter Regular School Yes Other 04 12 2019   grade_4                                                   1.0                                             1
2735577 HI     school 1500030 1   Hawaii Department of Education 150003000276 547 Ke Kula O Kamakau Lab PCS charter Regular School Yes Other PK 12 2019   grade_4                                                   13.0                                             13
2735581 HI     school 1500030 1   Hawaii Department of Education 150003000295 551 Hawaii Tech Acad PCS charter Regular School Yes Other KG 12 2019   grade_4                                                   47.0                                             47
2735583 HI     school 1500030 1   Hawaii Department of Education 150003000279 554 Kihei Charter School charter Regular School Yes Other KG 12 2019   grade_4                                                   29.0                                             29
2735585 HI     school 1500030 1   Hawaii Department of Education 150003000280 556 Ke Kula O Niihau Kekaha LPCS charter Regular School Yes Other PK 12 2019   grade_4                                                   3.0                                             3