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
127505 HI     school 1500030 1   Hawaii Department of Education 150003000091 461 NIIHAU   Regular School No Other PK 12 2017   grade_3                                                   1.0                                             1
128578 HI     school 1500030 1   Hawaii Department of Education 150003000098 475 OLOMANA   Alternative School No High 07 12 2017   grade_7                                                   1.0                                             1
129535 HI     school 1500030 1   Hawaii Department of Education 150003000091 461 NIIHAU   Regular School No Other PK 12 2017   grade_10                                                   1.0                                             1
129553 HI     school 1500030 1   Hawaii Department of Education 150003000294 565 KAWAIKINI-PCS charter Regular School Yes Other KG 12 2017   grade_10                                                   1.0                                             1
130115 HI     school 1500030 1   Hawaii Department of Education 150003000091 461 NIIHAU   Regular School No Other PK 12 2017   grade_12                                                   1.0                                             1
130158 HI     school 1500030 1   Hawaii Department of Education 150003000096 470 HSDB   Special Education School No Other PK 12 2017   pre_kindergarten                                                   1.0                                             1
130200 HI     school 1500030 1   Hawaii Department of Education 150003000189 142 PALOLO   Regular School No Elementary PK 5 2017   pre_kindergarten                                                   1.0                                             1
130267 HI     school 1500030 1   Hawaii Department of Education 150003000124 258 MAKAHA   Regular School No Elementary PK 6 2017   pre_kindergarten                                                   1.0                                             1
130316 HI     school 1500030 1   Hawaii Department of Education 150003000019 321 MAUNAWILI   Regular School No Elementary PK 6 2017   pre_kindergarten                                                   1.0                                             1
130329 HI     school 1500030 1   Hawaii Department of Education 150003000042 372 KEAUKAHA   Regular School No Elementary PK 6 2017   pre_kindergarten                                                   1.0                                             1
130377 HI     school 1500030 1   Hawaii Department of Education 150003000292 433 POMAIKAI   Regular School No Elementary PK 5 2017   pre_kindergarten                                                   1.0                                             1
130395 HI     school 1500030 1   Hawaii Department of Education 150003000083 453 KALAHEO   Regular School No Elementary PK 5 2017   pre_kindergarten                                                   1.0                                             1
126619 HI     school 1500030 1   Hawaii Department of Education 150003000074 419 MAUNALOA   Regular School No Elementary PK 6 2017   kindergarten                                                   2.0                                             2
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
127801 HI     school 1500030 1   Hawaii Department of Education 150003000275 546 HAKIPU'U LEARNING CTR-PCS charter Regular School Yes Other 04 12 2017   grade_4                                                   2.0                                             2
127809 HI     school 1500030 1   Hawaii Department of Education 150003000269 466 KANAKA-PCS charter Regular School Yes Other KG 12 2017   grade_4                                                   2.0                                             2
128085 HI     school 1500030 1   Hawaii Department of Education 150003000091 461 NIIHAU   Regular School No Other PK 12 2017   grade_5                                                   2.0                                             2
128091 HI     school 1500030 1   Hawaii Department of Education 150003000275 546 HAKIPU'U LEARNING CTR-PCS charter Regular School Yes Other 04 12 2017   grade_5                                                   2.0                                             2
128395 HI     school 1500030 1   Hawaii Department of Education 150003000280 556 KE KULA NIIHAU KEKAHA-PCS charter Regular School Yes Other KG 12 2017   grade_6                                                   2.0                                             2
128684 HI     school 1500030 1   Hawaii Department of Education 150003000278 549 KE ANA LA'AHANA-PCS charter Regular School Yes High 07 12 2017   grade_7                                                   2.0                                             2
128969 HI     school 1500030 1   Hawaii Department of Education 150003000269 466 KANAKA-PCS charter Regular School Yes Other KG 12 2017   grade_8                                                   2.0                                             2
129843 HI     school 1500030 1   Hawaii Department of Education 150003000294 565 KAWAIKINI-PCS charter Regular School Yes Other KG 12 2017   grade_11                                                   2.0                                             2
130133 HI     school 1500030 1   Hawaii Department of Education 150003000294 565 KAWAIKINI-PCS charter Regular School Yes Other KG 12 2017   grade_12                                                   2.0                                             2
130156 HI     school 1500030 1   Hawaii Department of Education 150003000220 107 FERN   Regular School No Elementary PK 5 2017   pre_kindergarten                                                   2.0                                             2
130159 HI     school 1500030 1   Hawaii Department of Education 150003000216 113 KAEWAI   Regular School No Elementary PK 5 2017   pre_kindergarten                                                   2.0                                             2
130227 HI     school 1500030 1   Hawaii Department of Education 150003000139 235 WEBLING   Regular School No Elementary PK 6 2017   pre_kindergarten                                                   2.0                                             2
130280 HI     school 1500030 1   Hawaii Department of Education 150003000122 260 MANANA   Regular School No Elementary PK 6 2017   pre_kindergarten                                                   2.0                                             2
130334 HI     school 1500030 1   Hawaii Department of Education 150003000032 358 HOLUALOA   Regular School No Elementary PK 5 2017   pre_kindergarten                                                   2.0                                             2
130350 HI     school 1500030 1   Hawaii Department of Education 150003000049 382 PAAUILO EL & INT   Regular School No Other PK 9 2017   pre_kindergarten                                                   2.0                                             2
130376 HI     school 1500030 1   Hawaii Department of Education 150003000076 422 PAIA   Regular School No Elementary PK 5 2017   pre_kindergarten                                                   2.0                                             2
130403 HI     school 1500030 1   Hawaii Department of Education 150003000089 459 KILAUEA   Regular School No Elementary PK 6 2017   pre_kindergarten                                                   2.0                                             2
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
126925 HI     school 1500030 1   Hawaii Department of Education 150003000091 461 NIIHAU   Regular School No Other PK 12 2017   grade_1                                                   3.0                                             3
127199 HI     school 1500030 1   Hawaii Department of Education 150003000074 419 MAUNALOA   Regular School No Elementary PK 6 2017   grade_2                                                   3.0                                             3
127406 HI     school 1500030 1   Hawaii Department of Education 150003000025 326 WAIAHOLE   Regular School No Elementary PK 6 2017   grade_3                                                   3.0                                             3
127795 HI     school 1500030 1   Hawaii Department of Education 150003000091 461 NIIHAU   Regular School No Other PK 12 2017   grade_4                                                   3.0                                             3
127815 HI     school 1500030 1   Hawaii Department of Education 150003000280 556 KE KULA NIIHAU KEKAHA-PCS charter Regular School Yes Other KG 12 2017   grade_4                                                   3.0                                             3
128381 HI     school 1500030 1   Hawaii Department of Education 150003000275 546 HAKIPU'U LEARNING CTR-PCS charter Regular School Yes Other 04 12 2017   grade_6                                                   3.0                                             3
128961 HI     school 1500030 1   Hawaii Department of Education 150003000275 546 HAKIPU'U LEARNING CTR-PCS charter Regular School Yes Other 04 12 2017   grade_8                                                   3.0                                             3
128975 HI     school 1500030 1   Hawaii Department of Education 150003000280 556 KE KULA NIIHAU KEKAHA-PCS charter Regular School Yes Other KG 12 2017   grade_8                                                   3.0                                             3
129265 HI     school 1500030 1   Hawaii Department of Education 150003000280 556 KE KULA NIIHAU KEKAHA-PCS charter Regular School Yes Other KG 12 2017   grade_9                                                   3.0                                             3
129549 HI     school 1500030 1   Hawaii Department of Education 150003000269 466 KANAKA-PCS charter Regular School Yes Other KG 12 2017   grade_10                                                   3.0                                             3
129551 HI     school 1500030 1   Hawaii Department of Education 150003000289 564 KANUIKAPONO-PCS charter Regular School Yes Other KG 12 2017   grade_10                                                   3.0                                             3
130129 HI     school 1500030 1   Hawaii Department of Education 150003000269 466 KANAKA-PCS charter Regular School Yes Other KG 12 2017   grade_12                                                   3.0                                             3
130135 HI     school 1500030 1   Hawaii Department of Education 150003000280 556 KE KULA NIIHAU KEKAHA-PCS charter Regular School Yes Other KG 12 2017   grade_12                                                   3.0                                             3
130206 HI     school 1500030 1   Hawaii Department of Education 150003000178 200 AIEA EL   Regular School No Elementary PK 6 2017   pre_kindergarten                                                   3.0                                             3
130269 HI     school 1500030 1   Hawaii Department of Education 150003000118 262 NANAKULI EL   Regular School No Elementary PK 6 2017   pre_kindergarten                                                   3.0                                             3
130388 HI     school 1500030 1   Hawaii Department of Education 150003000070 415 LANAI HI & EL   Regular School No Other PK 12 2017   pre_kindergarten                                                   3.0                                             3
128105 HI     school 1500030 1   Hawaii Department of Education 150003000280 556 KE KULA NIIHAU KEKAHA-PCS charter Regular School Yes Other KG 12 2017   grade_5                                                   4.0                                             4
128389 HI     school 1500030 1   Hawaii Department of Education 150003000269 466 KANAKA-PCS charter Regular School Yes Other KG 12 2017   grade_6                                                   4.0                                             4
128679 HI     school 1500030 1   Hawaii Department of Education 150003000269 466 KANAKA-PCS charter Regular School Yes Other KG 12 2017   grade_7                                                   4.0                                             4
128685 HI     school 1500030 1   Hawaii Department of Education 150003000280 556 KE KULA NIIHAU KEKAHA-PCS charter Regular School Yes Other KG 12 2017   grade_7                                                   4.0                                             4
129259 HI     school 1500030 1   Hawaii Department of Education 150003000269 466 KANAKA-PCS charter Regular School Yes Other KG 12 2017   grade_9                                                   4.0                                             4
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
129839 HI     school 1500030 1   Hawaii Department of Education 150003000269 466 KANAKA-PCS charter Regular School Yes Other KG 12 2017   grade_11                                                   4.0                                             4
129841 HI     school 1500030 1   Hawaii Department of Education 150003000289 564 KANUIKAPONO-PCS charter Regular School Yes Other KG 12 2017   grade_11                                                   4.0                                             4
129845 HI     school 1500030 1   Hawaii Department of Education 150003000280 556 KE KULA NIIHAU KEKAHA-PCS charter Regular School Yes Other KG 12 2017   grade_11                                                   4.0                                             4
129846 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_11                                                   4.0                                             4
130131 HI     school 1500030 1   Hawaii Department of Education 150003000289 564 KANUIKAPONO-PCS charter Regular School Yes Other KG 12 2017   grade_12                                                   4.0                                             4
130134 HI     school 1500030 1   Hawaii Department of Education 150003000278 549 KE ANA LA'AHANA-PCS charter Regular School Yes High 07 12 2017   grade_12                                                   4.0                                             4
130153 HI     school 1500030 1   Hawaii Department of Education 150003000227 100 AINA HAINA   Regular School No Elementary PK 5 2017   pre_kindergarten                                                   4.0                                             4
130167 HI     school 1500030 1   Hawaii Department of Education 150003000210 122 KALIHI-UKA   Regular School No Elementary PK 5 2017   pre_kindergarten                                                   4.0                                             4
130171 HI     school 1500030 1   Hawaii Department of Education 150003000204 127 KOKO HEAD   Regular School No Elementary PK 5 2017   pre_kindergarten                                                   4.0                                             4
130213 HI     school 1500030 1   Hawaii Department of Education 150003000104 217 MOANALUA EL   Regular School No Elementary PK 6 2017   pre_kindergarten                                                   4.0                                             4
130244 HI     school 1500030 1   Hawaii Department of Education 150003000142 231 WAIALUA EL   Regular School No Elementary PK 6 2017   pre_kindergarten                                                   4.0                                             4
130279 HI     school 1500030 1   Hawaii Department of Education 150003000126 268 LEHUA   Regular School No Elementary PK 6 2017   pre_kindergarten                                                   4.0                                             4
130282 HI     school 1500030 1   Hawaii Department of Education 150003000116 264 PALISADES   Regular School No Elementary PK 6 2017   pre_kindergarten                                                   4.0                                             4
130297 HI     school 1500030 1   Hawaii Department of Education 150003000236 331 KAHUKU EL   Regular School No Elementary PK 6 2017   pre_kindergarten                                                   4.0                                             4
130299 HI     school 1500030 1   Hawaii Department of Education 150003000013 313 KANEOHE   Regular School No Elementary PK 6 2017   pre_kindergarten                                                   4.0                                             4
130305 HI     school 1500030 1   Hawaii Department of Education 150003000024 325 SUNSET BEACH   Regular School No Elementary PK 6 2017   pre_kindergarten                                                   4.0                                             4
130319 HI     school 1500030 1   Hawaii Department of Education 150003000022 324 POPE   Regular School No Elementary PK 6 2017   pre_kindergarten                                                   4.0                                             4
130384 HI     school 1500030 1   Hawaii Department of Education 150003000062 407 KAUNAKAKAI   Regular School No Elementary PK 6 2017   pre_kindergarten                                                   4.0                                             4
130418 HI     school 1500030 1   Hawaii Department of Education 150003000240 275 KAMAILE ACADEMY charter Regular School Yes Other PK 12 2017   pre_kindergarten                                                   4.0                                             4
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
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
128069 HI     school 1500030 1   Hawaii Department of Education 150003000074 419 MAUNALOA   Regular School No Elementary PK 6 2017   grade_5                                                   5.0                                             5
128099 HI     school 1500030 1   Hawaii Department of Education 150003000269 466 KANAKA-PCS charter Regular School Yes Other KG 12 2017   grade_5                                                   5.0                                             5
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
129266 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_9                                                   5.0                                             5
129555 HI     school 1500030 1   Hawaii Department of Education 150003000280 556 KE KULA NIIHAU KEKAHA-PCS charter Regular School Yes Other KG 12 2017   grade_10                                                   5.0                                             5
129844 HI     school 1500030 1   Hawaii Department of Education 150003000278 549 KE ANA LA'AHANA-PCS charter Regular School Yes High 07 12 2017   grade_11                                                   5.0                                             5
130121 HI     school 1500030 1   Hawaii Department of Education 150003000275 546 HAKIPU'U LEARNING CTR-PCS charter Regular School Yes Other 04 12 2017   grade_12                                                   5.0                                             5
130194 HI     school 1500030 1   Hawaii Department of Education 150003000195 135 LUNALILO   Regular School No Elementary PK 5 2017   pre_kindergarten                                                   5.0                                             5
130231 HI     school 1500030 1   Hawaii Department of Education 150003000169 210 ILIAHI   Regular School No Elementary PK 5 2017   pre_kindergarten                                                   5.0                                             5
130271 HI     school 1500030 1   Hawaii Department of Education 150003000111 270 WAIANAE EL   Regular School No Elementary PK 6 2017   pre_kindergarten                                                   5.0                                             5
130306 HI     school 1500030 1   Hawaii Department of Education 150003000025 326 WAIAHOLE   Regular School No Elementary PK 6 2017   pre_kindergarten                                                   5.0                                             5
130308 HI     school 1500030 1   Hawaii Department of Education 150003000001 302 ENCHANTED LAKE   Regular School No Elementary PK 6 2017   pre_kindergarten                                                   5.0                                             5
130320 HI     school 1500030 1   Hawaii Department of Education 150003000026 327 WAIMANALO EL & INT   Regular School No Elementary PK 8 2017   pre_kindergarten                                                   5.0                                             5
130338 HI     school 1500030 1   Hawaii Department of Education 150003000035 363 HOOKENA   Regular School No Elementary PK 5 2017   pre_kindergarten                                                   5.0                                             5
130347 HI     school 1500030 1   Hawaii Department of Education 150003000044 375 KONAWAENA EL   Regular School No Elementary PK 5 2017   pre_kindergarten                                                   5.0                                             5
130432 HI     school 1500030 1   Hawaii Department of Education 150003000046 377 LAUPAHOEHOE COMMUNITY - PCS charter Regular School Yes Other PK 12 2017   pre_kindergarten                                                   5.0                                             5
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
127986 HI     school 1500030 1   Hawaii Department of Education 150003000025 326 WAIAHOLE   Regular School No Elementary PK 6 2017   grade_5                                                   6.0                                             6
128355 HI     school 1500030 1   Hawaii Department of Education 150003000065 410 KILOHANA   Regular School No Elementary PK 6 2017   grade_6                                                   6.0                                             6
129760 HI     school 1500030 1   Hawaii Department of Education 150003000287 378 KE KULA O EHUNUIKAIMALINO   Regular School No Other PK 12 2017   grade_11                                                   6.0                                             6
130122 HI     school 1500030 1   Hawaii Department of Education 150003000270 540 HALAU KU MANA-PCS charter Regular School Yes Other 04 12 2017   grade_12                                                   6.0                                             6
130168 HI     school 1500030 1   Hawaii Department of Education 150003000209 123 KALIHI-WAENA   Regular School No Elementary PK 5 2017   pre_kindergarten                                                   6.0                                             6
130187 HI     school 1500030 1   Hawaii Department of Education 150003000165 117 KAIULANI   Regular School No Elementary PK 5 2017   pre_kindergarten                                                   6.0                                             6
130190 HI     school 1500030 1   Hawaii Department of Education 150003000203 128 KUHIO   Regular School No Elementary PK 5 2017   pre_kindergarten                                                   6.0                                             6
130192 HI     school 1500030 1   Hawaii Department of Education 150003000200 131 LIKELIKE   Regular School No Elementary PK 5 2017   pre_kindergarten                                                   6.0                                             6
130198 HI     school 1500030 1   Hawaii Department of Education 150003000191 140 NOELANI   Regular School No Elementary PK 5 2017   pre_kindergarten                                                   6.0                                             6