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
126388 HI     school 1500030 1   Hawaii Department of Education 150003000096 470 HSDB   Special Education School No Other PK 12 2017   kindergarten                                                   0.0                                             0
126410 HI     school 1500030 1   Hawaii Department of Education 150003000246 103 ANUENUE   Regular School No Other PK 12 2017   kindergarten                                                   54.0                                             54
126570 HI     school 1500030 1   Hawaii Department of Education 150003000287 378 KE KULA O EHUNUIKAIMALINO   Regular School No Other PK 12 2017   kindergarten                                                   25.0                                             25
126580 HI     school 1500030 1   Hawaii Department of Education 150003000049 382 PAAUILO EL & INT   Regular School No Other PK 9 2017   kindergarten                                                   20.0                                             20
126583 HI     school 1500030 1   Hawaii Department of Education 150003000038 368 KAU HI/PAHALA EL   Regular School No Other PK 12 2017   kindergarten                                                   14.0                                             14
126612 HI     school 1500030 1   Hawaii Department of Education 150003000058 402 HANA HI & EL   Regular School No Other PK 12 2017   kindergarten                                                   25.0                                             25
126618 HI     school 1500030 1   Hawaii Department of Education 150003000070 415 LANAI HI & EL   Regular School No Other PK 12 2017   kindergarten                                                   38.0                                             38
126635 HI     school 1500030 1   Hawaii Department of Education 150003000091 461 NIIHAU   Regular School No Other PK 12 2017   kindergarten                                                   0.0                                             0
126639 HI     school 1500030 1   Hawaii Department of Education 150003000262 396 CONNECTIONS-PCS charter Regular School Yes Other KG 12 2017   kindergarten                                                   19.0                                             19
126640 HI     school 1500030 1   Hawaii Department of Education 150003000273 543 EDUC LAB: A HAWAII NC-PCS charter Regular School Yes Other KG 12 2017   kindergarten                                                   10.0                                             10
126641 HI     school 1500030 1   Hawaii Department of Education 150003000275 546 HAKIPU'U LEARNING CTR-PCS charter Regular School Yes Other 04 12 2017   kindergarten                                                   0.0                                             0
126642 HI     school 1500030 1   Hawaii Department of Education 150003000270 540 HALAU KU MANA-PCS charter Regular School Yes Other 04 12 2017   kindergarten                                                   0.0                                             0
126643 HI     school 1500030 1   Hawaii Department of Education 150003000295 551 HAWAII TECHNOLOGY ACADEMY charter Regular School Yes Other KG 12 2017   kindergarten                                                   31.0                                             31
126644 HI     school 1500030 1   Hawaii Department of Education 150003000282 561 HI ACADEMY OF A&S-PCS charter Regular School Yes Other KG 12 2017   kindergarten                                                   36.0                                             36
126648 HI     school 1500030 1   Hawaii Department of Education 150003000240 275 KAMAILE ACADEMY charter Regular School Yes Other PK 12 2017   kindergarten                                                   90.0                                             90
126649 HI     school 1500030 1   Hawaii Department of Education 150003000269 466 KANAKA-PCS charter Regular School Yes Other KG 12 2017   kindergarten                                                   7.0                                             7
126650 HI     school 1500030 1   Hawaii Department of Education 150003000263 397 KANU O KA'AINA-PCS charter Regular School Yes Other KG 12 2017   kindergarten                                                   30.0                                             30
126651 HI     school 1500030 1   Hawaii Department of Education 150003000289 564 KANUIKAPONO-PCS charter Regular School Yes Other KG 12 2017   kindergarten                                                   18.0                                             18
126653 HI     school 1500030 1   Hawaii Department of Education 150003000294 565 KAWAIKINI-PCS charter Regular School Yes Other KG 12 2017   kindergarten                                                   20.0                                             20
126655 HI     school 1500030 1   Hawaii Department of Education 150003000280 556 KE KULA NIIHAU KEKAHA-PCS charter Regular School Yes Other KG 12 2017   kindergarten                                                   3.0                                             3
126656 HI     school 1500030 1   Hawaii Department of Education 150003000276 547 KE KULA O KAMAKAU LAB-PCS charter Regular School Yes Other PK 12 2017   kindergarten                                                   14.0                                             14
126657 HI     school 1500030 1   Hawaii Department of Education 150003000279 554 KIHEI PC SCHOOL-PCS charter Regular School Yes Other KG 12 2017   kindergarten                                                   12.0                                             12
126659 HI     school 1500030 1   Hawaii Department of Education 150003000288 557 KUA O KA LA-PCS charter Regular School Yes Other KG 12 2017   kindergarten                                                   18.0                                             18
126662 HI     school 1500030 1   Hawaii Department of Education 150003000046 377 LAUPAHOEHOE COMMUNITY - PCS charter Regular School Yes Other PK 12 2017   kindergarten                                                   17.0                                             17
126664 HI     school 1500030 1   Hawaii Department of Education 150003000274 544 MYRON THOMPSON ACAD-PCS charter Regular School Yes Other KG 12 2017   kindergarten                                                   66.0                                             66
126672 HI     school 1500030 1   Hawaii Department of Education 150003000265 399 WEST HI EXPLOR ACAD-PCS charter Regular School Yes Other 06 12 2017   kindergarten                                                   0.0                                             0
126678 HI     school 1500030 1   Hawaii Department of Education 150003000096 470 HSDB   Special Education School No Other PK 12 2017   grade_1                                                   0.0                                             0
126700 HI     school 1500030 1   Hawaii Department of Education 150003000246 103 ANUENUE   Regular School No Other PK 12 2017   grade_1                                                   50.0                                             50
126860 HI     school 1500030 1   Hawaii Department of Education 150003000287 378 KE KULA O EHUNUIKAIMALINO   Regular School No Other PK 12 2017   grade_1                                                   23.0                                             23
126870 HI     school 1500030 1   Hawaii Department of Education 150003000049 382 PAAUILO EL & INT   Regular School No Other PK 9 2017   grade_1                                                   23.0                                             23
126873 HI     school 1500030 1   Hawaii Department of Education 150003000038 368 KAU HI/PAHALA EL   Regular School No Other PK 12 2017   grade_1                                                   19.0                                             19
126902 HI     school 1500030 1   Hawaii Department of Education 150003000058 402 HANA HI & EL   Regular School No Other PK 12 2017   grade_1                                                   33.0                                             33
126908 HI     school 1500030 1   Hawaii Department of Education 150003000070 415 LANAI HI & EL   Regular School No Other PK 12 2017   grade_1                                                   40.0                                             40
126925 HI     school 1500030 1   Hawaii Department of Education 150003000091 461 NIIHAU   Regular School No Other PK 12 2017   grade_1                                                   3.0                                             3
126929 HI     school 1500030 1   Hawaii Department of Education 150003000262 396 CONNECTIONS-PCS charter Regular School Yes Other KG 12 2017   grade_1                                                   19.0                                             19
126930 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_1                                                   10.0                                             10
126931 HI     school 1500030 1   Hawaii Department of Education 150003000275 546 HAKIPU'U LEARNING CTR-PCS charter Regular School Yes Other 04 12 2017   grade_1                                                   0.0                                             0
126932 HI     school 1500030 1   Hawaii Department of Education 150003000270 540 HALAU KU MANA-PCS charter Regular School Yes Other 04 12 2017   grade_1                                                   0.0                                             0
126933 HI     school 1500030 1   Hawaii Department of Education 150003000295 551 HAWAII TECHNOLOGY ACADEMY charter Regular School Yes Other KG 12 2017   grade_1                                                   42.0                                             42
126934 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_1                                                   26.0                                             26
126938 HI     school 1500030 1   Hawaii Department of Education 150003000240 275 KAMAILE ACADEMY charter Regular School Yes Other PK 12 2017   grade_1                                                   82.0                                             82
126939 HI     school 1500030 1   Hawaii Department of Education 150003000269 466 KANAKA-PCS charter Regular School Yes Other KG 12 2017   grade_1                                                   0.0                                             0
126940 HI     school 1500030 1   Hawaii Department of Education 150003000263 397 KANU O KA'AINA-PCS charter Regular School Yes Other KG 12 2017   grade_1                                                   29.0                                             29
126941 HI     school 1500030 1   Hawaii Department of Education 150003000289 564 KANUIKAPONO-PCS charter Regular School Yes Other KG 12 2017   grade_1                                                   18.0                                             18
126943 HI     school 1500030 1   Hawaii Department of Education 150003000294 565 KAWAIKINI-PCS charter Regular School Yes Other KG 12 2017   grade_1                                                   21.0                                             21
126945 HI     school 1500030 1   Hawaii Department of Education 150003000280 556 KE KULA NIIHAU KEKAHA-PCS charter Regular School Yes Other KG 12 2017   grade_1                                                   6.0                                             6
126946 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_1                                                   18.0                                             18
126947 HI     school 1500030 1   Hawaii Department of Education 150003000279 554 KIHEI PC SCHOOL-PCS charter Regular School Yes Other KG 12 2017   grade_1                                                   13.0                                             13
126949 HI     school 1500030 1   Hawaii Department of Education 150003000288 557 KUA O KA LA-PCS charter Regular School Yes Other KG 12 2017   grade_1                                                   17.0                                             17
126952 HI     school 1500030 1   Hawaii Department of Education 150003000046 377 LAUPAHOEHOE COMMUNITY - PCS charter Regular School Yes Other PK 12 2017   grade_1                                                   21.0                                             21
126954 HI     school 1500030 1   Hawaii Department of Education 150003000274 544 MYRON THOMPSON ACAD-PCS charter Regular School Yes Other KG 12 2017   grade_1                                                   71.0                                             71
126962 HI     school 1500030 1   Hawaii Department of Education 150003000265 399 WEST HI EXPLOR ACAD-PCS charter Regular School Yes Other 06 12 2017   grade_1                                                   0.0                                             0
126968 HI     school 1500030 1   Hawaii Department of Education 150003000096 470 HSDB   Special Education School No Other PK 12 2017   grade_2                                                   0.0                                             0
126990 HI     school 1500030 1   Hawaii Department of Education 150003000246 103 ANUENUE   Regular School No Other PK 12 2017   grade_2                                                   30.0                                             30
127150 HI     school 1500030 1   Hawaii Department of Education 150003000287 378 KE KULA O EHUNUIKAIMALINO   Regular School No Other PK 12 2017   grade_2                                                   26.0                                             26
127160 HI     school 1500030 1   Hawaii Department of Education 150003000049 382 PAAUILO EL & INT   Regular School No Other PK 9 2017   grade_2                                                   11.0                                             11
127163 HI     school 1500030 1   Hawaii Department of Education 150003000038 368 KAU HI/PAHALA EL   Regular School No Other PK 12 2017   grade_2                                                   11.0                                             11
127192 HI     school 1500030 1   Hawaii Department of Education 150003000058 402 HANA HI & EL   Regular School No Other PK 12 2017   grade_2                                                   29.0                                             29
127198 HI     school 1500030 1   Hawaii Department of Education 150003000070 415 LANAI HI & EL   Regular School No Other PK 12 2017   grade_2                                                   32.0                                             32
127215 HI     school 1500030 1   Hawaii Department of Education 150003000091 461 NIIHAU   Regular School No Other PK 12 2017   grade_2                                                   0.0                                             0
127219 HI     school 1500030 1   Hawaii Department of Education 150003000262 396 CONNECTIONS-PCS charter Regular School Yes Other KG 12 2017   grade_2                                                   17.0                                             17
127220 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_2                                                   10.0                                             10
127221 HI     school 1500030 1   Hawaii Department of Education 150003000275 546 HAKIPU'U LEARNING CTR-PCS charter Regular School Yes Other 04 12 2017   grade_2                                                   0.0                                             0
127222 HI     school 1500030 1   Hawaii Department of Education 150003000270 540 HALAU KU MANA-PCS charter Regular School Yes Other 04 12 2017   grade_2                                                   0.0                                             0
127223 HI     school 1500030 1   Hawaii Department of Education 150003000295 551 HAWAII TECHNOLOGY ACADEMY charter Regular School Yes Other KG 12 2017   grade_2                                                   39.0                                             39
127224 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_2                                                   31.0                                             31
127228 HI     school 1500030 1   Hawaii Department of Education 150003000240 275 KAMAILE ACADEMY charter Regular School Yes Other PK 12 2017   grade_2                                                   50.0                                             50
127229 HI     school 1500030 1   Hawaii Department of Education 150003000269 466 KANAKA-PCS charter Regular School Yes Other KG 12 2017   grade_2                                                   5.0                                             5
127230 HI     school 1500030 1   Hawaii Department of Education 150003000263 397 KANU O KA'AINA-PCS charter Regular School Yes Other KG 12 2017   grade_2                                                   35.0                                             35
127231 HI     school 1500030 1   Hawaii Department of Education 150003000289 564 KANUIKAPONO-PCS charter Regular School Yes Other KG 12 2017   grade_2                                                   20.0                                             20
127233 HI     school 1500030 1   Hawaii Department of Education 150003000294 565 KAWAIKINI-PCS charter Regular School Yes Other KG 12 2017   grade_2                                                   20.0                                             20
127235 HI     school 1500030 1   Hawaii Department of Education 150003000280 556 KE KULA NIIHAU KEKAHA-PCS charter Regular School Yes Other KG 12 2017   grade_2                                                   5.0                                             5
127236 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_2                                                   14.0                                             14
127237 HI     school 1500030 1   Hawaii Department of Education 150003000279 554 KIHEI PC SCHOOL-PCS charter Regular School Yes Other KG 12 2017   grade_2                                                   12.0                                             12
127239 HI     school 1500030 1   Hawaii Department of Education 150003000288 557 KUA O KA LA-PCS charter Regular School Yes Other KG 12 2017   grade_2                                                   15.0                                             15
127242 HI     school 1500030 1   Hawaii Department of Education 150003000046 377 LAUPAHOEHOE COMMUNITY - PCS charter Regular School Yes Other PK 12 2017   grade_2                                                   17.0                                             17
127244 HI     school 1500030 1   Hawaii Department of Education 150003000274 544 MYRON THOMPSON ACAD-PCS charter Regular School Yes Other KG 12 2017   grade_2                                                   79.0                                             79
127252 HI     school 1500030 1   Hawaii Department of Education 150003000265 399 WEST HI EXPLOR ACAD-PCS charter Regular School Yes Other 06 12 2017   grade_2                                                   0.0                                             0
127258 HI     school 1500030 1   Hawaii Department of Education 150003000096 470 HSDB   Special Education School No Other PK 12 2017   grade_3                                                   0.0                                             0
127280 HI     school 1500030 1   Hawaii Department of Education 150003000246 103 ANUENUE   Regular School No Other PK 12 2017   grade_3                                                   48.0                                             48
127440 HI     school 1500030 1   Hawaii Department of Education 150003000287 378 KE KULA O EHUNUIKAIMALINO   Regular School No Other PK 12 2017   grade_3                                                   17.0                                             17
127450 HI     school 1500030 1   Hawaii Department of Education 150003000049 382 PAAUILO EL & INT   Regular School No Other PK 9 2017   grade_3                                                   21.0                                             21
127453 HI     school 1500030 1   Hawaii Department of Education 150003000038 368 KAU HI/PAHALA EL   Regular School No Other PK 12 2017   grade_3                                                   12.0                                             12
127482 HI     school 1500030 1   Hawaii Department of Education 150003000058 402 HANA HI & EL   Regular School No Other PK 12 2017   grade_3                                                   16.0                                             16
127488 HI     school 1500030 1   Hawaii Department of Education 150003000070 415 LANAI HI & EL   Regular School No Other PK 12 2017   grade_3                                                   53.0                                             53
127505 HI     school 1500030 1   Hawaii Department of Education 150003000091 461 NIIHAU   Regular School No Other PK 12 2017   grade_3                                                   1.0                                             1
127509 HI     school 1500030 1   Hawaii Department of Education 150003000262 396 CONNECTIONS-PCS charter Regular School Yes Other KG 12 2017   grade_3                                                   25.0                                             25
127510 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_3                                                   9.0                                             9
127511 HI     school 1500030 1   Hawaii Department of Education 150003000275 546 HAKIPU'U LEARNING CTR-PCS charter Regular School Yes Other 04 12 2017   grade_3                                                   0.0                                             0
127512 HI     school 1500030 1   Hawaii Department of Education 150003000270 540 HALAU KU MANA-PCS charter Regular School Yes Other 04 12 2017   grade_3                                                   0.0                                             0
127513 HI     school 1500030 1   Hawaii Department of Education 150003000295 551 HAWAII TECHNOLOGY ACADEMY charter Regular School Yes Other KG 12 2017   grade_3                                                   56.0                                             56
127514 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_3                                                   48.0                                             48
127518 HI     school 1500030 1   Hawaii Department of Education 150003000240 275 KAMAILE ACADEMY charter Regular School Yes Other PK 12 2017   grade_3                                                   105.0                                             105
127519 HI     school 1500030 1   Hawaii Department of Education 150003000269 466 KANAKA-PCS charter Regular School Yes Other KG 12 2017   grade_3                                                   0.0                                             0
127520 HI     school 1500030 1   Hawaii Department of Education 150003000263 397 KANU O KA'AINA-PCS charter Regular School Yes Other KG 12 2017   grade_3                                                   44.0                                             44
127521 HI     school 1500030 1   Hawaii Department of Education 150003000289 564 KANUIKAPONO-PCS charter Regular School Yes Other KG 12 2017   grade_3                                                   20.0                                             20
127523 HI     school 1500030 1   Hawaii Department of Education 150003000294 565 KAWAIKINI-PCS charter Regular School Yes Other KG 12 2017   grade_3                                                   20.0                                             20
127525 HI     school 1500030 1   Hawaii Department of Education 150003000280 556 KE KULA NIIHAU KEKAHA-PCS charter Regular School Yes Other KG 12 2017   grade_3                                                   2.0                                             2
127526 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_3                                                   19.0                                             19
127527 HI     school 1500030 1   Hawaii Department of Education 150003000279 554 KIHEI PC SCHOOL-PCS charter Regular School Yes Other KG 12 2017   grade_3                                                   17.0                                             17
127529 HI     school 1500030 1   Hawaii Department of Education 150003000288 557 KUA O KA LA-PCS charter Regular School Yes Other KG 12 2017   grade_3                                                   13.0                                             13