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
2455894 HI     school 1500030 1   Hawaii Department of Education 150003000306 297 Honouliuli Middle   Regular School No Middle 06 6 2021   grade_9                                                   0.0                                             0
2431361 HI     school 1500030 1   Hawaii Department of Education 150003000305 568 DreamHouse Ewa Beach charter Regular School Yes Middle 06 6 2020   grade_9                                                   0.0                                             0
2456052 HI     school 1500030 1   Hawaii Department of Education 150003000305 568 DreamHouse Ewa Beach charter Regular School Yes Middle 06 7 2021   grade_9                                                   0.0                                             0
2431359 HI     school 1500030 1   Hawaii Department of Education 150003000304 558 Alakai O Kauai PCS charter Regular School Yes Elementary KG 6 2020   grade_9                                                   0.0                                             0
2456050 HI     school 1500030 1   Hawaii Department of Education 150003000304 558 Alakai O Kauai PCS charter Regular School Yes Elementary KG 6 2021   grade_9                                                   0.0                                             0
2737047 HI     school 1500030 1   Hawaii Department of Education 150003000304 558 Alakai O Kauai PCS charter Regular School Yes Elementary KG 5 2019   grade_9                                                   0.0                                             0
2431370 HI     school 1500030 1   Hawaii Department of Education 150003000303 553 Kamalani Academy charter Regular School Yes Elementary PK 8 2020   grade_9                                                   0.0                                             0
2456061 HI     school 1500030 1   Hawaii Department of Education 150003000303 553 Kamalani Academy charter Regular School Yes Elementary PK 8 2021   grade_9                                                   0.0                                             0
2737042 HI     school 1500030 1   Hawaii Department of Education 150003000303 553 Kamalani Academy charter Regular School Yes Elementary PK 8 2019   grade_9                                                   0.0                                             0
2782079 HI     school 1500030 1   Hawaii Department of Education 150003000303 553 Kamalani Academy charter Regular School Yes Elementary PK 8 2018   grade_9                                                   0.0                                             0
2431375 HI     school 1500030 1   Hawaii Department of Education 150003000302 555 Kapolei Charter School charter Regular School Yes Secondary 09 11 2020   grade_9                                                   43.0                                             43
2456066 HI     school 1500030 1   Hawaii Department of Education 150003000302 555 Kapolei Charter School charter Regular School Yes High 09 12 2021   grade_9                                                   42.0                                             42
2737044 HI     school 1500030 1   Hawaii Department of Education 150003000302 555 Kapolei Charter School charter Regular School Yes Secondary 09 10 2019   grade_9                                                   41.0                                             41
2782084 HI     school 1500030 1   Hawaii Department of Education 150003000302 555 Kapolei Charter School charter Regular School Yes Secondary 09 9 2018   grade_9                                                   43.0                                             43
110259 HI     school 1500030 1   Hawaii Department of Education 150003000301 552 KAU LEARNING ACAD-PCS charter Regular School Yes 1 03 6 2016   grade_9                                                   0.0                                             0
129262 HI     school 1500030 1   Hawaii Department of Education 150003000301 552 KAU LEARNING ACAD-PCS charter Regular School Yes Elementary 03 7 2017   grade_9                                                   0.0                                             0
2782085 HI     school 1500030 1   Hawaii Department of Education 150003000301 552 Kau Learning Academy charter Regular School Yes Middle 03 7 2018   grade_9                                                   0.0                                             0
110091 HI     school 1500030 1   Hawaii Department of Education 150003000300 293 HOOKELE EL   Regular School No 1 PK 5 2016   grade_9                                                   0.0                                             0
129094 HI     school 1500030 1   Hawaii Department of Education 150003000300 293 HOOKELE EL   Regular School No Elementary PK 5 2017   grade_9                                                   0.0                                             0
2431204 HI     school 1500030 1   Hawaii Department of Education 150003000300 293 Hookele Elem   Regular School No Elementary PK 5 2020   grade_9                                                   0.0                                             0
2455895 HI     school 1500030 1   Hawaii Department of Education 150003000300 293 Hookele Elem   Regular School No Elementary PK 5 2021   grade_9                                                   0.0                                             0
2736865 HI     school 1500030 1   Hawaii Department of Education 150003000300 293 Hookele Elem   Regular School No Elementary PK 5 2019   grade_9                                                   0.0                                             0
2781915 HI     school 1500030 1   Hawaii Department of Education 150003000300 293 Hookele Elem   Regular School No Elementary PK 5 2018   grade_9                                                   0.0                                             0
110270 HI     school 1500030 1   Hawaii Department of Education 150003000299 550 MALAMA HONUA PCS charter Regular School Yes 1 KG 3 2016   grade_9                                                   0.0                                             0
129273 HI     school 1500030 1   Hawaii Department of Education 150003000299 550 MALAMA HONUA PCS charter Regular School Yes Elementary KG 4 2017   grade_9                                                   0.0                                             0
280245 HI     school 1500030 1   Hawaii Department of Education 150003000299 550 MALAMA HONUA PCS charter Regular School Yes 1 KG 2 2015   grade_9                                                   0.0                                             0
2431386 HI     school 1500030 1   Hawaii Department of Education 150003000299 550 Malama Honua charter Regular School Yes Elementary KG 7 2020   grade_9                                                   0.0                                             0
2456077 HI     school 1500030 1   Hawaii Department of Education 150003000299 550 Malama Honua PCS charter Regular School Yes Elementary KG 8 2021   grade_9                                                   0.0                                             0
2737040 HI     school 1500030 1   Hawaii Department of Education 150003000299 550 Malama Honua charter Regular School Yes Elementary KG 6 2019   grade_9                                                   0.0                                             0
2782096 HI     school 1500030 1   Hawaii Department of Education 150003000299 550 Malama Honua charter Regular School Yes Elementary KG 5 2018   grade_9                                                   0.0                                             0
110274 HI     school 1500030 1   Hawaii Department of Education 150003000298 567 SEEQS charter Regular School Yes 2 06 8 2016   grade_9                                                   0.0                                             0
129277 HI     school 1500030 1   Hawaii Department of Education 150003000298 567 SEEQS charter Regular School Yes Middle 06 8 2017   grade_9                                                   0.0                                             0
280257 HI     school 1500030 1   Hawaii Department of Education 150003000298 567 SEEQS charter Regular School Yes 2 06 8 2015   grade_9                                                   0.0                                             0
2431389 HI     school 1500030 1   Hawaii Department of Education 150003000298 567 SEEQS PCS charter Regular School Yes Middle 06 8 2020   grade_9                                                   0.0                                             0
2456080 HI     school 1500030 1   Hawaii Department of Education 150003000298 567 SEEQS PCS charter Regular School Yes Middle 06 8 2021   grade_9                                                   0.0                                             0
2737055 HI     school 1500030 1   Hawaii Department of Education 150003000298 567 SEEQS PCS charter Regular School Yes Middle 06 8 2019   grade_9                                                   0.0                                             0
2782099 HI     school 1500030 1   Hawaii Department of Education 150003000298 567 SEEQS PCS charter Regular School Yes Middle 06 8 2018   grade_9                                                   0.0                                             0
110216 HI     school 1500030 1   Hawaii Department of Education 150003000297 436 PUU KUKUI   Regular School No 1 PK 5 2016   grade_9                                                   0.0                                             0
129219 HI     school 1500030 1   Hawaii Department of Education 150003000297 436 PUU KUKUI   Regular School No Elementary PK 5 2017   grade_9                                                   0.0                                             0
280194 HI     school 1500030 1   Hawaii Department of Education 150003000297 436 PUU KUKUI   Regular School No 1 PK 5 2015   grade_9                                                   0.0                                             0
2431329 HI     school 1500030 1   Hawaii Department of Education 150003000297 436 Puu Kukui Elem   Regular School No Elementary PK 5 2020   grade_9                                                   0.0                                             0
2456020 HI     school 1500030 1   Hawaii Department of Education 150003000297 436 Puu Kukui Elem   Regular School No Elementary PK 5 2021   grade_9                                                   0.0                                             0
2736990 HI     school 1500030 1   Hawaii Department of Education 150003000297 436 Puu Kukui Elem   Regular School No Elementary PK 5 2019   grade_9                                                   0.0                                             0
2782040 HI     school 1500030 1   Hawaii Department of Education 150003000297 436 Puu Kukui Elem   Regular School No Elementary PK 5 2018   grade_9                                                   0.0                                             0
110089 HI     school 1500030 1   Hawaii Department of Education 150003000296 296 EWA MAKAI MID   Regular School No 2 07 8 2016   grade_9                                                   0.0                                             0
129092 HI     school 1500030 1   Hawaii Department of Education 150003000296 296 EWA MAKAI MID   Regular School No Middle 07 8 2017   grade_9                                                   0.0                                             0
280068 HI     school 1500030 1   Hawaii Department of Education 150003000296 296 EWA MAKAI MID   Regular School No 2 07 8 2015   grade_9                                                   0.0                                             0
2431202 HI     school 1500030 1   Hawaii Department of Education 150003000296 296 Ewa Makai Middle   Regular School No Middle 06 8 2020   grade_9                                                   0.0                                             0
2455892 HI     school 1500030 1   Hawaii Department of Education 150003000296 296 Ewa Makai Middle   Regular School No Middle 06 8 2021   grade_9                                                   0.0                                             0
2736863 HI     school 1500030 1   Hawaii Department of Education 150003000296 296 Ewa Makai Middle   Regular School No Middle 07 8 2019   grade_9                                                   0.0                                             0
2781913 HI     school 1500030 1   Hawaii Department of Education 150003000296 296 Ewa Makai Middle   Regular School No Middle 07 8 2018   grade_9                                                   0.0                                             0
110250 HI     school 1500030 1   Hawaii Department of Education 150003000295 551 HAWAII TECHNOLOGY ACADEMY charter Regular School Yes 4 KG 12 2016   grade_9                                                   95.0                                             95
129253 HI     school 1500030 1   Hawaii Department of Education 150003000295 551 HAWAII TECHNOLOGY ACADEMY charter Regular School Yes Other KG 12 2017   grade_9                                                   144.0                                             144
280246 HI     school 1500030 1   Hawaii Department of Education 150003000295 551 HAWAII TECHNOLOGY ACADEMY charter Regular School Yes 4 KG 12 2015   grade_9                                                   141.0                                             141
2431365 HI     school 1500030 1   Hawaii Department of Education 150003000295 551 Hawaii Tech Acad PCS charter Regular School Yes Other KG 12 2020   grade_9                                                   150.0                                             150
2456056 HI     school 1500030 1   Hawaii Department of Education 150003000295 551 Hawaii Tech Academy PCS charter Regular School Yes Other KG 12 2021   grade_9                                                   158.0                                             158
2737041 HI     school 1500030 1   Hawaii Department of Education 150003000295 551 Hawaii Tech Acad PCS charter Regular School Yes Other KG 12 2019   grade_9                                                   170.0                                             170
2782074 HI     school 1500030 1   Hawaii Department of Education 150003000295 551 Hawaii Tech Acad PCS charter Regular School Yes Other KG 12 2018   grade_9                                                   137.0                                             137
110260 HI     school 1500030 1   Hawaii Department of Education 150003000294 565 KAWAIKINI-PCS charter Regular School Yes 4 KG 12 2016   grade_9                                                   1.0                                             1
129263 HI     school 1500030 1   Hawaii Department of Education 150003000294 565 KAWAIKINI-PCS charter Regular School Yes Other KG 12 2017   grade_9                                                   5.0                                             5
280255 HI     school 1500030 1   Hawaii Department of Education 150003000294 565 KAWAIKINI-PCS charter Regular School Yes 4 KG 12 2015   grade_9                                                   3.0                                             3
2431376 HI     school 1500030 1   Hawaii Department of Education 150003000294 565 Kawaikini NCPCS charter Regular School Yes Other KG 12 2020   grade_9                                                   2.0                                             2
2456067 HI     school 1500030 1   Hawaii Department of Education 150003000294 565 Kawaikini NCPCS charter Regular School Yes Other KG 12 2021   grade_9                                                   6.0                                             6
2737053 HI     school 1500030 1   Hawaii Department of Education 150003000294 565 Kawaikini NCPCS charter Regular School Yes Other KG 12 2019   grade_9                                                   5.0                                             5
2782086 HI     school 1500030 1   Hawaii Department of Education 150003000294 565 Kawaikini NCPCS charter Regular School Yes Other KG 12 2018   grade_9                                                   6.0                                             6
110265 HI     school 1500030 1   Hawaii Department of Education 150003000293 566 KONA PACIFIC-PCS charter Regular School Yes 1 KG 8 2016   grade_9                                                   0.0                                             0
129268 HI     school 1500030 1   Hawaii Department of Education 150003000293 566 KONA PACIFIC-PCS charter Regular School Yes Elementary KG 8 2017   grade_9                                                   0.0                                             0
280256 HI     school 1500030 1   Hawaii Department of Education 150003000293 566 KONA PACIFIC-PCS charter Regular School Yes 1 KG 8 2015   grade_9                                                   0.0                                             0
2431382 HI     school 1500030 1   Hawaii Department of Education 150003000293 566 Kona Pacific PCS charter Regular School Yes Elementary KG 8 2020   grade_9                                                   0.0                                             0
2456073 HI     school 1500030 1   Hawaii Department of Education 150003000293 566 Kona Pacific PCS charter Regular School Yes Elementary KG 8 2021   grade_9                                                   0.0                                             0
2737054 HI     school 1500030 1   Hawaii Department of Education 150003000293 566 Kona Pacific PCS charter Regular School Yes Elementary KG 8 2019   grade_9                                                   0.0                                             0
2782092 HI     school 1500030 1   Hawaii Department of Education 150003000293 566 Kona Pacific PCS charter Regular School Yes Elementary KG 8 2018   grade_9                                                   0.0                                             0
110214 HI     school 1500030 1   Hawaii Department of Education 150003000292 433 POMAIKAI   Regular School No 1 PK 5 2016   grade_9                                                   0.0                                             0
129217 HI     school 1500030 1   Hawaii Department of Education 150003000292 433 POMAIKAI   Regular School No Elementary PK 5 2017   grade_9                                                   0.0                                             0
280192 HI     school 1500030 1   Hawaii Department of Education 150003000292 433 POMAIKAI   Regular School No 1 PK 5 2015   grade_9                                                   0.0                                             0
2431327 HI     school 1500030 1   Hawaii Department of Education 150003000292 433 Pomaikai Elem   Regular School No Elementary PK 5 2020   grade_9                                                   0.0                                             0
2456018 HI     school 1500030 1   Hawaii Department of Education 150003000292 433 Pomaikai Elem   Regular School No Elementary PK 5 2021   grade_9                                                   0.0                                             0
2736988 HI     school 1500030 1   Hawaii Department of Education 150003000292 433 Pomaikai Elem   Regular School No Elementary PK 5 2019   grade_9                                                   0.0                                             0
2782038 HI     school 1500030 1   Hawaii Department of Education 150003000292 433 Pomaikai Elem   Regular School No Elementary PK 5 2018   grade_9                                                   0.0                                             0
110098 HI     school 1500030 1   Hawaii Department of Education 150003000291 294 KEONEULA   Regular School No 1 PK 6 2016   grade_9                                                   0.0                                             0
129101 HI     school 1500030 1   Hawaii Department of Education 150003000291 294 KEONEULA   Regular School No Elementary PK 6 2017   grade_9                                                   0.0                                             0
280076 HI     school 1500030 1   Hawaii Department of Education 150003000291 294 KEONEULA   Regular School No 1 PK 6 2015   grade_9                                                   0.0                                             0
2431211 HI     school 1500030 1   Hawaii Department of Education 150003000291 294 Keoneula Elem   Regular School No Elementary PK 6 2020   grade_9                                                   0.0                                             0
2455902 HI     school 1500030 1   Hawaii Department of Education 150003000291 294 Keoneula Elem   Regular School No Elementary PK 5 2021   grade_9                                                   0.0                                             0
2736872 HI     school 1500030 1   Hawaii Department of Education 150003000291 294 Keoneula Elem   Regular School No Elementary PK 6 2019   grade_9                                                   0.0                                             0
2781922 HI     school 1500030 1   Hawaii Department of Education 150003000291 294 Keoneula Elem   Regular School No Elementary PK 6 2018   grade_9                                                   0.0                                             0
110228 HI     school 1500030 1   Hawaii Department of Education 150003000290 434 MOLOKAI MID   Regular School No 2 07 8 2016   grade_9                                                   0.0                                             0
129231 HI     school 1500030 1   Hawaii Department of Education 150003000290 434 MOLOKAI MID   Regular School No Middle 07 8 2017   grade_9                                                   0.0                                             0
280206 HI     school 1500030 1   Hawaii Department of Education 150003000290 434 MOLOKAI MID   Regular School No 2 07 8 2015   grade_9                                                   0.0                                             0
2431341 HI     school 1500030 1   Hawaii Department of Education 150003000290 434 Molokai Middle   Regular School No Middle 07 8 2020   grade_9                                                   0.0                                             0
2456032 HI     school 1500030 1   Hawaii Department of Education 150003000290 434 Molokai Middle   Regular School No Middle 07 8 2021   grade_9                                                   0.0                                             0
2737002 HI     school 1500030 1   Hawaii Department of Education 150003000290 434 Molokai Middle   Regular School No Middle 07 8 2019   grade_9                                                   0.0                                             0
2782052 HI     school 1500030 1   Hawaii Department of Education 150003000290 434 Molokai Middle   Regular School No Middle 07 8 2018   grade_9                                                   0.0                                             0
110258 HI     school 1500030 1   Hawaii Department of Education 150003000289 564 KANUIKAPONO-PCS charter Regular School Yes 4 KG 12 2016   grade_9                                                   8.0                                             8
129261 HI     school 1500030 1   Hawaii Department of Education 150003000289 564 KANUIKAPONO-PCS charter Regular School Yes Other KG 12 2017   grade_9                                                   4.0                                             4
280254 HI     school 1500030 1   Hawaii Department of Education 150003000289 564 KANUIKAPONO-PCS charter Regular School Yes 4 KG 12 2015   grade_9                                                   10.0                                             10
2431373 HI     school 1500030 1   Hawaii Department of Education 150003000289 564 Kanuikapono PCS charter Regular School Yes Other KG 12 2020   grade_9                                                   7.0                                             7
2456064 HI     school 1500030 1   Hawaii Department of Education 150003000289 564 Kanuikapono PCS charter Regular School Yes Other KG 12 2021   grade_9                                                   9.0                                             9
2737052 HI     school 1500030 1   Hawaii Department of Education 150003000289 564 Kanuikapono PCS charter Regular School Yes Other KG 12 2019   grade_9                                                   15.0                                             15
2782082 HI     school 1500030 1   Hawaii Department of Education 150003000289 564 Kanuikapono PCS charter Regular School Yes Other KG 12 2018   grade_9                                                   5.0                                             5
110266 HI     school 1500030 1   Hawaii Department of Education 150003000288 557 KUA O KA LA-PCS charter Regular School Yes 4 KG 12 2016   grade_9                                                   7.0                                             7