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
110187 HI     school 1500030 1   Hawaii Department of Education 150003000049 382 PAAUILO EL & INT   Regular School No 4 PK 9 2016   grade_9                                                   11.0                                             11
129190 HI     school 1500030 1   Hawaii Department of Education 150003000049 382 PAAUILO EL & INT   Regular School No Other PK 9 2017   grade_9                                                   8.0                                             8
280165 HI     school 1500030 1   Hawaii Department of Education 150003000049 382 PAAUILO EL & INT   Regular School No 4 PK 9 2015   grade_9                                                   17.0                                             17
2431300 HI     school 1500030 1   Hawaii Department of Education 150003000049 382 Paauilo El & Int   Regular School No Other PK 9 2020   grade_9                                                   9.0                                             9
2455991 HI     school 1500030 1   Hawaii Department of Education 150003000049 382 Paauilo El & Int   Regular School No Other PK 9 2021   grade_9                                                   8.0                                             8
2736961 HI     school 1500030 1   Hawaii Department of Education 150003000049 382 Paauilo El & Int   Regular School No Other PK 9 2019   grade_9                                                   7.0                                             7
2782011 HI     school 1500030 1   Hawaii Department of Education 150003000049 382 Paauilo El & Int   Regular School No Other PK 9 2018   grade_9                                                   8.0                                             8
2782076 HI     school 1500030 1   Hawaii Department of Education 150003000283 562 Ka Umeke Kaeo PCS charter Regular School Yes Other PK 9 2018   grade_9                                                   5.0                                             5
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
109991 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 DOLE MID   Regular School No 2 06 8 2016   grade_9                                                   0.0                                             0
109998 HI     school 1500030 1   Hawaii Department of Education 150003000211 116 KAIMUKI MID   Regular School No 2 06 8 2016   grade_9                                                   0.0                                             0
110000 HI     school 1500030 1   Hawaii Department of Education 150003000164 118 KALAKAUA MID   Regular School No 2 06 8 2016   grade_9                                                   0.0                                             0
110011 HI     school 1500030 1   Hawaii Department of Education 150003000192 139 NIU VALLEY MID   Regular School No 2 06 8 2016   grade_9                                                   0.0                                             0
110018 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 CENTRAL MID   Regular School No 2 06 8 2016   grade_9                                                   0.0                                             0
110020 HI     school 1500030 1   Hawaii Department of Education 150003000218 110 JARRETT MID   Regular School No 2 06 8 2016   grade_9                                                   0.0                                             0
110026 HI     school 1500030 1   Hawaii Department of Education 150003000205 126 KAWANANAKOA MID   Regular School No 2 06 8 2016   grade_9                                                   0.0                                             0
110041 HI     school 1500030 1   Hawaii Department of Education 150003000184 148 STEVENSON MID   Regular School No 2 06 8 2016   grade_9                                                   0.0                                             0
110042 HI     school 1500030 1   Hawaii Department of Education 150003000180 152 WASHINGTON MID   Regular School No 2 06 8 2016   grade_9                                                   0.0                                             0
110045 HI     school 1500030 1   Hawaii Department of Education 150003000176 201 AIEA INT   Regular School No 2 07 8 2016   grade_9                                                   0.0                                             0
110047 HI     school 1500030 1   Hawaii Department of Education 150003000174 204 ALIAMANU INT   Regular School No 2 07 8 2016   grade_9                                                   0.0                                             0
110052 HI     school 1500030 1   Hawaii Department of Education 150003000156 219 MOANALUA MID   Regular School No 2 07 8 2016   grade_9                                                   0.0                                             0
110075 HI     school 1500030 1   Hawaii Department of Education 150003000256 238 MILILANI MID   Regular School No 2 06 8 2016   grade_9                                                   0.0                                             0
110080 HI     school 1500030 1   Hawaii Department of Education 150003000143 230 WAHIAWA MID   Regular School No 2 06 8 2016   grade_9                                                   0.0                                             0
110084 HI     school 1500030 1   Hawaii Department of Education 150003000137 237 WHEELER MID   Regular School No 2 06 8 2016   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
110092 HI     school 1500030 1   Hawaii Department of Education 150003000129 279 ILIMA INT   Regular School No 2 07 8 2016   grade_9                                                   0.0                                             0
110097 HI     school 1500030 1   Hawaii Department of Education 150003000259 291 KAPOLEI MID   Regular School No 2 06 8 2016   grade_9                                                   0.0                                             0
110110 HI     school 1500030 1   Hawaii Department of Education 150003000229 273 WAIANAE INT   Regular School No 2 07 8 2016   grade_9                                                   0.0                                             0
110112 HI     school 1500030 1   Hawaii Department of Education 150003000131 255 HIGHLANDS INT   Regular School No 2 07 8 2016   grade_9                                                   0.0                                             0
110127 HI     school 1500030 1   Hawaii Department of Education 150003000158 278 WAIPAHU INT   Regular School No 2 07 8 2016   grade_9                                                   0.0                                             0
110138 HI     school 1500030 1   Hawaii Department of Education 150003000016 318 KING INT   Regular School No 2 07 8 2016   grade_9                                                   0.0                                             0
110149 HI     school 1500030 1   Hawaii Department of Education 150003000010 310 KAILUA INT   Regular School No 2 07 8 2016   grade_9                                                   0.0                                             0
110157 HI     school 1500030 1   Hawaii Department of Education 150003000026 327 WAIMANALO EL & INT   Regular School No 1 PK 8 2016   grade_9                                                   0.0                                             0
110161 HI     school 1500030 1   Hawaii Department of Education 150003000030 356 HILO INT   Regular School No 2 07 8 2016   grade_9                                                   0.0                                             0
110163 HI     school 1500030 1   Hawaii Department of Education 150003000036 365 KALANIANAOLE EL & INT   Regular School No 1 PK 8 2016   grade_9                                                   0.0                                             0
110169 HI     school 1500030 1   Hawaii Department of Education 150003000053 385 WAIAKEA INT   Regular School No 2 06 8 2016   grade_9                                                   0.0                                             0
110180 HI     school 1500030 1   Hawaii Department of Education 150003000235 390 KEALAKEHE INT   Regular School No 2 06 8 2016   grade_9                                                   0.0                                             0
110183 HI     school 1500030 1   Hawaii Department of Education 150003000267 366 KOHALA MID   Regular School No 2 06 8 2016   grade_9                                                   0.0                                             0
110186 HI     school 1500030 1   Hawaii Department of Education 150003000252 376 KONAWAENA MID   Regular School No 2 06 8 2016   grade_9                                                   0.0                                             0
110188 HI     school 1500030 1   Hawaii Department of Education 150003000247 393 WAIKOLOA   Regular School No 1 PK 8 2016   grade_9                                                   0.0                                             0
110193 HI     school 1500030 1   Hawaii Department of Education 150003000040 370 KEAAU MID   Regular School No 2 06 8 2016   grade_9                                                   0.0                                             0
110201 HI     school 1500030 1   Hawaii Department of Education 150003000059 404 IAO INT   Regular School No 2 06 8 2016   grade_9                                                   0.0                                             0
110203 HI     school 1500030 1   Hawaii Department of Education 150003000233 420 KALAMA INT   Regular School No 2 06 8 2016   grade_9                                                   0.0                                             0
110209 HI     school 1500030 1   Hawaii Department of Education 150003000238 430 LOKELANI INT   Regular School No 2 06 8 2016   grade_9                                                   0.0                                             0
110212 HI     school 1500030 1   Hawaii Department of Education 150003000241 428 MAUI WAENA INT   Regular School No 2 06 8 2016   grade_9                                                   0.0                                             0
110223 HI     school 1500030 1   Hawaii Department of Education 150003000068 413 LAHAINA INT   Regular School No 2 06 8 2016   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
110233 HI     school 1500030 1   Hawaii Department of Education 150003000266 448 KAMAKAHELEI MID   Regular School No 2 06 8 2016   grade_9                                                   0.0                                             0
110236 HI     school 1500030 1   Hawaii Department of Education 150003000255 447 KAPAA MID   Regular School No 2 06 8 2016   grade_9                                                   0.0                                             0
110243 HI     school 1500030 1   Hawaii Department of Education 150003000092 464 WAIMEA CANYON   Regular School No 2 06 8 2016   grade_9                                                   0.0                                             0
110252 HI     school 1500030 1   Hawaii Department of Education 150003000277 548 INNOVATIONS-PCS charter Regular School Yes 1 KG 8 2016   grade_9                                                   0.0                                             0
110254 HI     school 1500030 1   Hawaii Department of Education 150003000286 545 KA WAIHONA O KA NAAUAO-PCS charter Regular School Yes 1 KG 8 2016   grade_9                                                   0.0                                             0
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
110273 HI     school 1500030 1   Hawaii Department of Education 150003000284 563 NAWAHI IKI LAB-PCS charter Regular School Yes 1 PK 8 2016   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
110275 HI     school 1500030 1   Hawaii Department of Education 150003000281 560 VOLCANO SCH OF A&S-PCS charter Regular School Yes 1 KG 8 2016   grade_9                                                   0.0                                             0
110276 HI     school 1500030 1   Hawaii Department of Education 150003000271 541 VOYAGER-PCS charter Regular School Yes 1 KG 8 2016   grade_9                                                   0.0                                             0
110278 HI     school 1500030 1   Hawaii Department of Education 150003000268 394 WAIMEA MID-PCCS charter Regular School Yes 2 06 8 2016   grade_9                                                   0.0                                             0
128994 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 DOLE MID   Regular School No Middle 06 8 2017   grade_9                                                   0.0                                             0
129001 HI     school 1500030 1   Hawaii Department of Education 150003000211 116 KAIMUKI MID   Regular School No Middle 06 8 2017   grade_9                                                   0.0                                             0
129003 HI     school 1500030 1   Hawaii Department of Education 150003000164 118 KALAKAUA MID   Regular School No Middle 06 8 2017   grade_9                                                   0.0                                             0
129014 HI     school 1500030 1   Hawaii Department of Education 150003000192 139 NIU VALLEY MID   Regular School No Middle 06 8 2017   grade_9                                                   0.0                                             0
129021 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 CENTRAL MID   Regular School No Middle 06 8 2017   grade_9                                                   0.0                                             0
129023 HI     school 1500030 1   Hawaii Department of Education 150003000218 110 JARRETT MID   Regular School No Middle 06 8 2017   grade_9                                                   0.0                                             0
129029 HI     school 1500030 1   Hawaii Department of Education 150003000205 126 KAWANANAKOA MID   Regular School No Middle 06 8 2017   grade_9                                                   0.0                                             0
129044 HI     school 1500030 1   Hawaii Department of Education 150003000184 148 STEVENSON MID   Regular School No Middle 06 8 2017   grade_9                                                   0.0                                             0
129045 HI     school 1500030 1   Hawaii Department of Education 150003000180 152 WASHINGTON MID   Regular School No Middle 06 8 2017   grade_9                                                   0.0                                             0
129048 HI     school 1500030 1   Hawaii Department of Education 150003000176 201 AIEA INT   Regular School No Middle 07 8 2017   grade_9                                                   0.0                                             0
129050 HI     school 1500030 1   Hawaii Department of Education 150003000174 204 ALIAMANU INT   Regular School No Middle 07 8 2017   grade_9                                                   0.0                                             0
129055 HI     school 1500030 1   Hawaii Department of Education 150003000156 219 MOANALUA MID   Regular School No Middle 07 8 2017   grade_9                                                   0.0                                             0
129078 HI     school 1500030 1   Hawaii Department of Education 150003000256 238 MILILANI MID   Regular School No Middle 06 8 2017   grade_9                                                   0.0                                             0
129083 HI     school 1500030 1   Hawaii Department of Education 150003000143 230 WAHIAWA MID   Regular School No Middle 06 8 2017   grade_9                                                   0.0                                             0
129087 HI     school 1500030 1   Hawaii Department of Education 150003000137 237 WHEELER MID   Regular School No Middle 06 8 2017   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
129095 HI     school 1500030 1   Hawaii Department of Education 150003000129 279 ILIMA INT   Regular School No Middle 07 8 2017   grade_9                                                   0.0                                             0
129100 HI     school 1500030 1   Hawaii Department of Education 150003000259 291 KAPOLEI MID   Regular School No Middle 06 8 2017   grade_9                                                   0.0                                             0
129113 HI     school 1500030 1   Hawaii Department of Education 150003000229 273 WAIANAE INT   Regular School No Middle 07 8 2017   grade_9                                                   0.0                                             0
129115 HI     school 1500030 1   Hawaii Department of Education 150003000131 255 HIGHLANDS INT   Regular School No Middle 07 8 2017   grade_9                                                   0.0                                             0
129130 HI     school 1500030 1   Hawaii Department of Education 150003000158 278 WAIPAHU INT   Regular School No Middle 07 8 2017   grade_9                                                   0.0                                             0
129141 HI     school 1500030 1   Hawaii Department of Education 150003000016 318 KING INT   Regular School No Middle 07 8 2017   grade_9                                                   0.0                                             0
129152 HI     school 1500030 1   Hawaii Department of Education 150003000010 310 KAILUA INT   Regular School No Middle 07 8 2017   grade_9                                                   0.0                                             0
129160 HI     school 1500030 1   Hawaii Department of Education 150003000026 327 WAIMANALO EL & INT   Regular School No Elementary PK 8 2017   grade_9                                                   0.0                                             0
129164 HI     school 1500030 1   Hawaii Department of Education 150003000030 356 HILO INT   Regular School No Middle 07 8 2017   grade_9                                                   0.0                                             0
129166 HI     school 1500030 1   Hawaii Department of Education 150003000036 365 KALANIANAOLE EL & INT   Regular School No Elementary PK 8 2017   grade_9                                                   0.0                                             0
129172 HI     school 1500030 1   Hawaii Department of Education 150003000053 385 WAIAKEA INT   Regular School No Middle 06 8 2017   grade_9                                                   0.0                                             0
129183 HI     school 1500030 1   Hawaii Department of Education 150003000235 390 KEALAKEHE INT   Regular School No Middle 06 8 2017   grade_9                                                   0.0                                             0
129186 HI     school 1500030 1   Hawaii Department of Education 150003000267 366 KOHALA MID   Regular School No Middle 06 8 2017   grade_9                                                   0.0                                             0
129189 HI     school 1500030 1   Hawaii Department of Education 150003000252 376 KONAWAENA MID   Regular School No Middle 06 8 2017   grade_9                                                   0.0                                             0
129191 HI     school 1500030 1   Hawaii Department of Education 150003000247 393 WAIKOLOA   Regular School No Elementary PK 8 2017   grade_9                                                   0.0                                             0
129196 HI     school 1500030 1   Hawaii Department of Education 150003000040 370 KEAAU MID   Regular School No Middle 06 8 2017   grade_9                                                   0.0                                             0
129204 HI     school 1500030 1   Hawaii Department of Education 150003000059 404 IAO INT   Regular School No Middle 06 8 2017   grade_9                                                   0.0                                             0
129206 HI     school 1500030 1   Hawaii Department of Education 150003000233 420 KALAMA INT   Regular School No Middle 06 8 2017   grade_9                                                   0.0                                             0
129212 HI     school 1500030 1   Hawaii Department of Education 150003000238 430 LOKELANI INT   Regular School No Middle 06 8 2017   grade_9                                                   0.0                                             0
129215 HI     school 1500030 1   Hawaii Department of Education 150003000241 428 MAUI WAENA INT   Regular School No Middle 06 8 2017   grade_9                                                   0.0                                             0
129226 HI     school 1500030 1   Hawaii Department of Education 150003000068 413 LAHAINA INT   Regular School No Middle 06 8 2017   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
129236 HI     school 1500030 1   Hawaii Department of Education 150003000266 448 KAMAKAHELEI MID   Regular School No Middle 06 8 2017   grade_9                                                   0.0                                             0
129239 HI     school 1500030 1   Hawaii Department of Education 150003000255 447 KAPAA MID   Regular School No Middle 06 8 2017   grade_9                                                   0.0                                             0
129246 HI     school 1500030 1   Hawaii Department of Education 150003000092 464 WAIMEA CANYON   Regular School No Middle 06 8 2017   grade_9                                                   0.0                                             0
129255 HI     school 1500030 1   Hawaii Department of Education 150003000277 548 INNOVATIONS-PCS charter Regular School Yes Elementary KG 8 2017   grade_9                                                   0.0                                             0
129256 HI     school 1500030 1   Hawaii Department of Education 150003000283 562 KA 'UMEKE KA'EO-PCS charter Regular School Yes Elementary PK 8 2017   grade_9                                                   0.0                                             0