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
111419 HI     school 1500030 1   Hawaii Department of Education 150003000301 552 KAU LEARNING ACAD-PCS charter Regular School Yes 1 03 6 2016   pre_kindergarten                                                   0.0                                             0
130422 HI     school 1500030 1   Hawaii Department of Education 150003000301 552 KAU LEARNING ACAD-PCS charter Regular School Yes Elementary 03 7 2017   pre_kindergarten                                                   0.0                                             0
2783253 HI     school 1500030 1   Hawaii Department of Education 150003000301 552 Kau Learning Academy charter Regular School Yes Middle 03 7 2018   pre_kindergarten                                                   0.0                                             0
111408 HI     school 1500030 1   Hawaii Department of Education 150003000275 546 HAKIPU'U LEARNING CTR-PCS charter Regular School Yes 4 04 12 2016   pre_kindergarten                                                   0.0                                             0
111409 HI     school 1500030 1   Hawaii Department of Education 150003000270 540 HALAU KU MANA-PCS charter Regular School Yes 4 04 12 2016   pre_kindergarten                                                   0.0                                             0
130411 HI     school 1500030 1   Hawaii Department of Education 150003000275 546 HAKIPU'U LEARNING CTR-PCS charter Regular School Yes Other 04 12 2017   pre_kindergarten                                                   0.0                                             0
130412 HI     school 1500030 1   Hawaii Department of Education 150003000270 540 HALAU KU MANA-PCS charter Regular School Yes Other 04 12 2017   pre_kindergarten                                                   0.0                                             0
281391 HI     school 1500030 1   Hawaii Department of Education 150003000270 540 HALAU KU MANA-PCS charter Regular School Yes 4 04 12 2015   pre_kindergarten                                                   0.0                                             0
281397 HI     school 1500030 1   Hawaii Department of Education 150003000275 546 HAKIPU'U LEARNING CTR-PCS charter Regular School Yes 4 04 12 2015   pre_kindergarten                                                   0.0                                             0
2432534 HI     school 1500030 1   Hawaii Department of Education 150003000275 546 Hakipuu Learning Ctr PCS charter Regular School Yes Other 04 12 2020   pre_kindergarten                                                   0.0                                             0
2432535 HI     school 1500030 1   Hawaii Department of Education 150003000270 540 Halau Ku Mana NCPCS charter Regular School Yes Other 04 12 2020   pre_kindergarten                                                   0.0                                             0
2457230 HI     school 1500030 1   Hawaii Department of Education 150003000270 540 Halau Ku Mana NCPCS charter Regular School Yes Other 04 12 2021   pre_kindergarten                                                   0.0                                             0
2738199 HI     school 1500030 1   Hawaii Department of Education 150003000270 540 Halau Ku Mana NCPCS charter Regular School Yes Other 04 12 2019   pre_kindergarten                                                   0.0                                             0
2738204 HI     school 1500030 1   Hawaii Department of Education 150003000275 546 Hakipuu Learning Ctr PCS charter Regular School Yes Other 04 12 2019   pre_kindergarten                                                   0.0                                             0
2783239 HI     school 1500030 1   Hawaii Department of Education 150003000275 546 Hakipuu Learning Ctr PCS charter Regular School Yes Other 04 12 2018   pre_kindergarten                                                   0.0                                             0
2783240 HI     school 1500030 1   Hawaii Department of Education 150003000270 540 Halau Ku Mana NCPCS charter Regular School Yes Other 04 12 2018   pre_kindergarten                                                   0.0                                             0
2457229 HI     school 1500030 1   Hawaii Department of Education 150003000275 546 Hakipuu Academy PCS charter Regular School Yes High 05 12 2021   pre_kindergarten                                                   0.0                                             0
111151 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 DOLE MID   Regular School No 2 06 8 2016   pre_kindergarten                                                   0.0                                             0
111158 HI     school 1500030 1   Hawaii Department of Education 150003000211 116 KAIMUKI MID   Regular School No 2 06 8 2016   pre_kindergarten                                                   0.0                                             0
111160 HI     school 1500030 1   Hawaii Department of Education 150003000164 118 KALAKAUA MID   Regular School No 2 06 8 2016   pre_kindergarten                                                   0.0                                             0
111171 HI     school 1500030 1   Hawaii Department of Education 150003000192 139 NIU VALLEY MID   Regular School No 2 06 8 2016   pre_kindergarten                                                   0.0                                             0
111178 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 CENTRAL MID   Regular School No 2 06 8 2016   pre_kindergarten                                                   0.0                                             0
111180 HI     school 1500030 1   Hawaii Department of Education 150003000218 110 JARRETT MID   Regular School No 2 06 8 2016   pre_kindergarten                                                   0.0                                             0
111186 HI     school 1500030 1   Hawaii Department of Education 150003000205 126 KAWANANAKOA MID   Regular School No 2 06 8 2016   pre_kindergarten                                                   0.0                                             0
111201 HI     school 1500030 1   Hawaii Department of Education 150003000184 148 STEVENSON MID   Regular School No 2 06 8 2016   pre_kindergarten                                                   0.0                                             0
111202 HI     school 1500030 1   Hawaii Department of Education 150003000180 152 WASHINGTON MID   Regular School No 2 06 8 2016   pre_kindergarten                                                   0.0                                             0
111235 HI     school 1500030 1   Hawaii Department of Education 150003000256 238 MILILANI MID   Regular School No 2 06 8 2016   pre_kindergarten                                                   0.0                                             0
111240 HI     school 1500030 1   Hawaii Department of Education 150003000143 230 WAHIAWA MID   Regular School No 2 06 8 2016   pre_kindergarten                                                   0.0                                             0
111244 HI     school 1500030 1   Hawaii Department of Education 150003000137 237 WHEELER MID   Regular School No 2 06 8 2016   pre_kindergarten                                                   0.0                                             0
111257 HI     school 1500030 1   Hawaii Department of Education 150003000259 291 KAPOLEI MID   Regular School No 2 06 8 2016   pre_kindergarten                                                   0.0                                             0
111329 HI     school 1500030 1   Hawaii Department of Education 150003000053 385 WAIAKEA INT   Regular School No 2 06 8 2016   pre_kindergarten                                                   0.0                                             0
111340 HI     school 1500030 1   Hawaii Department of Education 150003000235 390 KEALAKEHE INT   Regular School No 2 06 8 2016   pre_kindergarten                                                   0.0                                             0
111343 HI     school 1500030 1   Hawaii Department of Education 150003000267 366 KOHALA MID   Regular School No 2 06 8 2016   pre_kindergarten                                                   0.0                                             0
111346 HI     school 1500030 1   Hawaii Department of Education 150003000252 376 KONAWAENA MID   Regular School No 2 06 8 2016   pre_kindergarten                                                   0.0                                             0
111353 HI     school 1500030 1   Hawaii Department of Education 150003000040 370 KEAAU MID   Regular School No 2 06 8 2016   pre_kindergarten                                                   0.0                                             0
111361 HI     school 1500030 1   Hawaii Department of Education 150003000059 404 IAO INT   Regular School No 2 06 8 2016   pre_kindergarten                                                   0.0                                             0
111363 HI     school 1500030 1   Hawaii Department of Education 150003000233 420 KALAMA INT   Regular School No 2 06 8 2016   pre_kindergarten                                                   0.0                                             0
111369 HI     school 1500030 1   Hawaii Department of Education 150003000238 430 LOKELANI INT   Regular School No 2 06 8 2016   pre_kindergarten                                                   0.0                                             0
111372 HI     school 1500030 1   Hawaii Department of Education 150003000241 428 MAUI WAENA INT   Regular School No 2 06 8 2016   pre_kindergarten                                                   0.0                                             0
111383 HI     school 1500030 1   Hawaii Department of Education 150003000068 413 LAHAINA INT   Regular School No 2 06 8 2016   pre_kindergarten                                                   0.0                                             0
111393 HI     school 1500030 1   Hawaii Department of Education 150003000266 448 KAMAKAHELEI MID   Regular School No 2 06 8 2016   pre_kindergarten                                                   0.0                                             0
111396 HI     school 1500030 1   Hawaii Department of Education 150003000255 447 KAPAA MID   Regular School No 2 06 8 2016   pre_kindergarten                                                   0.0                                             0
111403 HI     school 1500030 1   Hawaii Department of Education 150003000092 464 WAIMEA CANYON   Regular School No 2 06 8 2016   pre_kindergarten                                                   0.0                                             0
111434 HI     school 1500030 1   Hawaii Department of Education 150003000298 567 SEEQS charter Regular School Yes 2 06 8 2016   pre_kindergarten                                                   0.0                                             0
111438 HI     school 1500030 1   Hawaii Department of Education 150003000268 394 WAIMEA MID-PCCS charter Regular School Yes 2 06 8 2016   pre_kindergarten                                                   0.0                                             0
111439 HI     school 1500030 1   Hawaii Department of Education 150003000265 399 WEST HI EXPLOR ACAD-PCS charter Regular School Yes 4 06 12 2016   pre_kindergarten                                                   0.0                                             0
130154 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 DOLE MID   Regular School No Middle 06 8 2017   pre_kindergarten                                                   0.0                                             0
130161 HI     school 1500030 1   Hawaii Department of Education 150003000211 116 KAIMUKI MID   Regular School No Middle 06 8 2017   pre_kindergarten                                                   0.0                                             0
130163 HI     school 1500030 1   Hawaii Department of Education 150003000164 118 KALAKAUA MID   Regular School No Middle 06 8 2017   pre_kindergarten                                                   0.0                                             0
130174 HI     school 1500030 1   Hawaii Department of Education 150003000192 139 NIU VALLEY MID   Regular School No Middle 06 8 2017   pre_kindergarten                                                   0.0                                             0
130181 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 CENTRAL MID   Regular School No Middle 06 8 2017   pre_kindergarten                                                   0.0                                             0
130183 HI     school 1500030 1   Hawaii Department of Education 150003000218 110 JARRETT MID   Regular School No Middle 06 8 2017   pre_kindergarten                                                   0.0                                             0
130189 HI     school 1500030 1   Hawaii Department of Education 150003000205 126 KAWANANAKOA MID   Regular School No Middle 06 8 2017   pre_kindergarten                                                   0.0                                             0
130204 HI     school 1500030 1   Hawaii Department of Education 150003000184 148 STEVENSON MID   Regular School No Middle 06 8 2017   pre_kindergarten                                                   0.0                                             0
130205 HI     school 1500030 1   Hawaii Department of Education 150003000180 152 WASHINGTON MID   Regular School No Middle 06 8 2017   pre_kindergarten                                                   0.0                                             0
130238 HI     school 1500030 1   Hawaii Department of Education 150003000256 238 MILILANI MID   Regular School No Middle 06 8 2017   pre_kindergarten                                                   0.0                                             0
130243 HI     school 1500030 1   Hawaii Department of Education 150003000143 230 WAHIAWA MID   Regular School No Middle 06 8 2017   pre_kindergarten                                                   0.0                                             0
130247 HI     school 1500030 1   Hawaii Department of Education 150003000137 237 WHEELER MID   Regular School No Middle 06 8 2017   pre_kindergarten                                                   0.0                                             0
130260 HI     school 1500030 1   Hawaii Department of Education 150003000259 291 KAPOLEI MID   Regular School No Middle 06 8 2017   pre_kindergarten                                                   0.0                                             0
130332 HI     school 1500030 1   Hawaii Department of Education 150003000053 385 WAIAKEA INT   Regular School No Middle 06 8 2017   pre_kindergarten                                                   0.0                                             0
130343 HI     school 1500030 1   Hawaii Department of Education 150003000235 390 KEALAKEHE INT   Regular School No Middle 06 8 2017   pre_kindergarten                                                   0.0                                             0
130346 HI     school 1500030 1   Hawaii Department of Education 150003000267 366 KOHALA MID   Regular School No Middle 06 8 2017   pre_kindergarten                                                   0.0                                             0
130349 HI     school 1500030 1   Hawaii Department of Education 150003000252 376 KONAWAENA MID   Regular School No Middle 06 8 2017   pre_kindergarten                                                   0.0                                             0
130356 HI     school 1500030 1   Hawaii Department of Education 150003000040 370 KEAAU MID   Regular School No Middle 06 8 2017   pre_kindergarten                                                   0.0                                             0
130364 HI     school 1500030 1   Hawaii Department of Education 150003000059 404 IAO INT   Regular School No Middle 06 8 2017   pre_kindergarten                                                   0.0                                             0
130366 HI     school 1500030 1   Hawaii Department of Education 150003000233 420 KALAMA INT   Regular School No Middle 06 8 2017   pre_kindergarten                                                   0.0                                             0
130372 HI     school 1500030 1   Hawaii Department of Education 150003000238 430 LOKELANI INT   Regular School No Middle 06 8 2017   pre_kindergarten                                                   0.0                                             0
130375 HI     school 1500030 1   Hawaii Department of Education 150003000241 428 MAUI WAENA INT   Regular School No Middle 06 8 2017   pre_kindergarten                                                   0.0                                             0
130386 HI     school 1500030 1   Hawaii Department of Education 150003000068 413 LAHAINA INT   Regular School No Middle 06 8 2017   pre_kindergarten                                                   0.0                                             0
130396 HI     school 1500030 1   Hawaii Department of Education 150003000266 448 KAMAKAHELEI MID   Regular School No Middle 06 8 2017   pre_kindergarten                                                   0.0                                             0
130399 HI     school 1500030 1   Hawaii Department of Education 150003000255 447 KAPAA MID   Regular School No Middle 06 8 2017   pre_kindergarten                                                   0.0                                             0
130406 HI     school 1500030 1   Hawaii Department of Education 150003000092 464 WAIMEA CANYON   Regular School No Middle 06 8 2017   pre_kindergarten                                                   0.0                                             0
130437 HI     school 1500030 1   Hawaii Department of Education 150003000298 567 SEEQS charter Regular School Yes Middle 06 8 2017   pre_kindergarten                                                   0.0                                             0
130441 HI     school 1500030 1   Hawaii Department of Education 150003000268 394 WAIMEA MID-PCCS charter Regular School Yes Middle 06 8 2017   pre_kindergarten                                                   0.0                                             0
130442 HI     school 1500030 1   Hawaii Department of Education 150003000265 399 WEST HI EXPLOR ACAD-PCS charter Regular School Yes Other 06 12 2017   pre_kindergarten                                                   0.0                                             0
281126 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 DOLE MID   Regular School No 2 06 8 2015   pre_kindergarten                                                   0.0                                             0
281133 HI     school 1500030 1   Hawaii Department of Education 150003000211 116 KAIMUKI MID   Regular School No 2 06 8 2015   pre_kindergarten                                                   0.0                                             0
281135 HI     school 1500030 1   Hawaii Department of Education 150003000164 118 KALAKAUA MID   Regular School No 2 06 8 2015   pre_kindergarten                                                   0.0                                             0
281146 HI     school 1500030 1   Hawaii Department of Education 150003000192 139 NIU VALLEY MID   Regular School No 2 06 8 2015   pre_kindergarten                                                   0.0                                             0
281153 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 CENTRAL MID   Regular School No 2 06 8 2015   pre_kindergarten                                                   0.0                                             0
281155 HI     school 1500030 1   Hawaii Department of Education 150003000218 110 JARRETT MID   Regular School No 2 06 8 2015   pre_kindergarten                                                   0.0                                             0
281161 HI     school 1500030 1   Hawaii Department of Education 150003000205 126 KAWANANAKOA MID   Regular School No 2 06 8 2015   pre_kindergarten                                                   0.0                                             0
281176 HI     school 1500030 1   Hawaii Department of Education 150003000184 148 STEVENSON MID   Regular School No 2 06 8 2015   pre_kindergarten                                                   0.0                                             0
281177 HI     school 1500030 1   Hawaii Department of Education 150003000180 152 WASHINGTON MID   Regular School No 2 06 8 2015   pre_kindergarten                                                   0.0                                             0
281210 HI     school 1500030 1   Hawaii Department of Education 150003000256 238 MILILANI MID   Regular School No 2 06 8 2015   pre_kindergarten                                                   0.0                                             0
281215 HI     school 1500030 1   Hawaii Department of Education 150003000143 230 WAHIAWA MID   Regular School No 2 06 8 2015   pre_kindergarten                                                   0.0                                             0
281219 HI     school 1500030 1   Hawaii Department of Education 150003000137 237 WHEELER MID   Regular School No 2 06 8 2015   pre_kindergarten                                                   0.0                                             0
281231 HI     school 1500030 1   Hawaii Department of Education 150003000259 291 KAPOLEI MID   Regular School No 2 06 8 2015   pre_kindergarten                                                   0.0                                             0
281303 HI     school 1500030 1   Hawaii Department of Education 150003000053 385 WAIAKEA INT   Regular School No 2 06 8 2015   pre_kindergarten                                                   0.0                                             0
281314 HI     school 1500030 1   Hawaii Department of Education 150003000235 390 KEALAKEHE INT   Regular School No 2 06 8 2015   pre_kindergarten                                                   0.0                                             0
281317 HI     school 1500030 1   Hawaii Department of Education 150003000267 366 KOHALA MID   Regular School No 2 06 8 2015   pre_kindergarten                                                   0.0                                             0
281320 HI     school 1500030 1   Hawaii Department of Education 150003000252 376 KONAWAENA MID   Regular School No 2 06 8 2015   pre_kindergarten                                                   0.0                                             0
281327 HI     school 1500030 1   Hawaii Department of Education 150003000040 370 KEAAU MID   Regular School No 2 06 8 2015   pre_kindergarten                                                   0.0                                             0
281335 HI     school 1500030 1   Hawaii Department of Education 150003000059 404 IAO INT   Regular School No 2 06 8 2015   pre_kindergarten                                                   0.0                                             0
281337 HI     school 1500030 1   Hawaii Department of Education 150003000233 420 KALAMA INT   Regular School No 2 06 8 2015   pre_kindergarten                                                   0.0                                             0
281343 HI     school 1500030 1   Hawaii Department of Education 150003000238 430 LOKELANI INT   Regular School No 2 06 8 2015   pre_kindergarten                                                   0.0                                             0
281346 HI     school 1500030 1   Hawaii Department of Education 150003000241 428 MAUI WAENA INT   Regular School No 2 06 8 2015   pre_kindergarten                                                   0.0                                             0
281357 HI     school 1500030 1   Hawaii Department of Education 150003000068 413 LAHAINA INT   Regular School No 2 06 8 2015   pre_kindergarten                                                   0.0                                             0
281367 HI     school 1500030 1   Hawaii Department of Education 150003000266 448 KAMAKAHELEI MID   Regular School No 2 06 8 2015   pre_kindergarten                                                   0.0                                             0
281370 HI     school 1500030 1   Hawaii Department of Education 150003000255 447 KAPAA MID   Regular School No 2 06 8 2015   pre_kindergarten                                                   0.0                                             0
281377 HI     school 1500030 1   Hawaii Department of Education 150003000092 464 WAIMEA CANYON   Regular School No 2 06 8 2015   pre_kindergarten                                                   0.0                                             0