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
278066 HI     school 1500030 1   Hawaii Department of Education 150003000136 250 AHRENS   Regular School No 1 PK 6 2015   grade_2                                                   192.0                                             192
278046 HI     school 1500030 1   Hawaii Department of Education 150003000248 280 HOLOMUA   Regular School No 1 PK 6 2015   grade_2                                                   180.0                                             180
278080 HI     school 1500030 1   Hawaii Department of Education 150003000159 274 WAIPAHU EL   Regular School No 1 PK 6 2015   grade_2                                                   179.0                                             179
2453857 HI     school 1500030 1   Hawaii Department of Education 150003000136 250 Ahrens Elem   Regular School No Elementary PK 6 2021   grade_2                                                   176.0                                             176
2779982 HI     school 1500030 1   Hawaii Department of Education 150003000060 405 Kahului Elem   Regular School No Elementary PK 5 2018   grade_2                                                   175.0                                             175
108081 HI     school 1500030 1   Hawaii Department of Education 150003000136 250 AHRENS   Regular School No 1 PK 6 2016   grade_2                                                   171.0                                             171
278044 HI     school 1500030 1   Hawaii Department of Education 150003000133 253 EWA EL   Regular School No 1 PK 6 2015   grade_2                                                   171.0                                             171
108048 HI     school 1500030 1   Hawaii Department of Education 150003000145 226 SOLOMON   Regular School No 1 PK 5 2016   grade_2                                                   170.0                                             170
2453835 HI     school 1500030 1   Hawaii Department of Education 150003000248 280 Holomua Elem   Regular School No Elementary PK 6 2021   grade_2                                                   169.0                                             169
2734841 HI     school 1500030 1   Hawaii Department of Education 150003000136 250 August Ahrens Elem   Regular School No Elementary PK 6 2019   grade_2                                                   167.0                                             167
108148 HI     school 1500030 1   Hawaii Department of Education 150003000041 388 KEALAKEHE   Regular School No 1 PK 5 2016   grade_2                                                   166.0                                             166
278050 HI     school 1500030 1   Hawaii Department of Education 150003000166 282 KAPOLEI EL   Regular School No 1 PK 5 2015   grade_2                                                   166.0                                             166
127051 HI     school 1500030 1   Hawaii Department of Education 150003000145 226 SOLOMON   Regular School No Elementary PK 5 2017   grade_2                                                   164.0                                             164
127207 HI     school 1500030 1   Hawaii Department of Education 150003000084 454 KAPAA EL   Regular School No Elementary PK 5 2017   grade_2                                                   164.0                                             164
2779905 HI     school 1500030 1   Hawaii Department of Education 150003000159 274 Waipahu Elem   Regular School No Elementary PK 6 2018   grade_2                                                   164.0                                             164
2429152 HI     school 1500030 1   Hawaii Department of Education 150003000248 280 Holomua Elem   Regular School No Elementary PK 6 2020   grade_2                                                   163.0                                             163
2779958 HI     school 1500030 1   Hawaii Department of Education 150003000041 388 Kealakehe Elem   Regular School No Elementary PK 5 2018   grade_2                                                   161.0                                             161
278034 HI     school 1500030 1   Hawaii Department of Education 150003000145 226 SOLOMON   Regular School No 1 PK 5 2015   grade_2                                                   160.0                                             160
2429173 HI     school 1500030 1   Hawaii Department of Education 150003000136 250 August Ahrens Elem   Regular School No Elementary PK 6 2020   grade_2                                                   160.0                                             160
2734821 HI     school 1500030 1   Hawaii Department of Education 150003000300 293 Hookele Elem   Regular School No Elementary PK 5 2019   grade_2                                                   160.0                                             160
2779870 HI     school 1500030 1   Hawaii Department of Education 150003000248 280 Holomua Elem   Regular School No Elementary PK 6 2018   grade_2                                                   160.0                                             160
2429264 HI     school 1500030 1   Hawaii Department of Education 150003000060 405 Kahului Elem   Regular School No Elementary PK 5 2020   grade_2                                                   159.0                                             159
2779878 HI     school 1500030 1   Hawaii Department of Education 150003000291 294 Keoneula Elem   Regular School No Elementary PK 6 2018   grade_2                                                   159.0                                             159
108058 HI     school 1500030 1   Hawaii Department of Education 150003000133 253 EWA EL   Regular School No 1 PK 6 2016   grade_2                                                   158.0                                             158
278163 HI     school 1500030 1   Hawaii Department of Education 150003000071 416 LIHIKAI   Regular School No 1 PK 5 2015   grade_2                                                   158.0                                             158
2779891 HI     school 1500030 1   Hawaii Department of Education 150003000136 250 August Ahrens Elem   Regular School No Elementary PK 6 2018   grade_2                                                   158.0                                             158
2779868 HI     school 1500030 1   Hawaii Department of Education 150003000133 253 Ewa Elem   Regular School No Elementary PK 6 2018   grade_2                                                   156.0                                             156
2453833 HI     school 1500030 1   Hawaii Department of Education 150003000133 253 Ewa Elem   Regular School No Elementary PK 5 2021   grade_2                                                   155.0                                             155
2734818 HI     school 1500030 1   Hawaii Department of Education 150003000133 253 Ewa Elem   Regular School No Elementary PK 6 2019   grade_2                                                   155.0                                             155
108178 HI     school 1500030 1   Hawaii Department of Education 150003000071 416 LIHIKAI   Regular School No 1 PK 5 2016   grade_2                                                   154.0                                             154
108060 HI     school 1500030 1   Hawaii Department of Education 150003000248 280 HOLOMUA   Regular School No 1 PK 6 2016   grade_2                                                   153.0                                             153
2429150 HI     school 1500030 1   Hawaii Department of Education 150003000133 253 Ewa Elem   Regular School No Elementary PK 6 2020   grade_2                                                   153.0                                             153
108095 HI     school 1500030 1   Hawaii Department of Education 150003000159 274 WAIPAHU EL   Regular School No 1 PK 6 2016   grade_2                                                   152.0                                             152
278161 HI     school 1500030 1   Hawaii Department of Education 150003000064 409 KIHEI   Regular School No 1 PK 5 2015   grade_2                                                   152.0                                             152
2779858 HI     school 1500030 1   Hawaii Department of Education 150003000145 226 Solomon Elem   Regular School No Elementary PK 5 2018   grade_2                                                   152.0                                             152
108065 HI     school 1500030 1   Hawaii Department of Education 150003000166 282 KAPOLEI EL   Regular School No 1 PK 5 2016   grade_2                                                   151.0                                             151
108068 HI     school 1500030 1   Hawaii Department of Education 150003000291 294 KEONEULA   Regular School No 1 PK 6 2016   grade_2                                                   151.0                                             151
2453844 HI     school 1500030 1   Hawaii Department of Education 150003000291 294 Keoneula Elem   Regular School No Elementary PK 5 2021   grade_2                                                   151.0                                             151
108172 HI     school 1500030 1   Hawaii Department of Education 150003000060 405 KAHULUI   Regular School No 1 PK 5 2016   grade_2                                                   150.0                                             150
278133 HI     school 1500030 1   Hawaii Department of Education 150003000041 388 KEALAKEHE   Regular School No 1 PK 5 2015   grade_2                                                   150.0                                             150
2779875 HI     school 1500030 1   Hawaii Department of Education 150003000166 282 Kapolei Elem   Regular School No Elementary PK 5 2018   grade_2                                                   150.0                                             150
2429160 HI     school 1500030 1   Hawaii Department of Education 150003000291 294 Keoneula Elem   Regular School No Elementary PK 6 2020   grade_2                                                   149.0                                             149
2429187 HI     school 1500030 1   Hawaii Department of Education 150003000159 274 Waipahu Elem   Regular School No Elementary PK 6 2020   grade_2                                                   149.0                                             149
2779971 HI     school 1500030 1   Hawaii Department of Education 150003000258 353 Keaau Elem   Regular School No Elementary PK 5 2018   grade_2                                                   149.0                                             149
278069 HI     school 1500030 1   Hawaii Department of Education 150003000239 287 KALEIOPUU   Regular School No 1 PK 6 2015   grade_2                                                   148.0                                             148
108073 HI     school 1500030 1   Hawaii Department of Education 150003000125 257 MAILI   Regular School No 1 PK 6 2016   grade_2                                                   147.0                                             147
127151 HI     school 1500030 1   Hawaii Department of Education 150003000041 388 KEALAKEHE   Regular School No Elementary PK 5 2017   grade_2                                                   147.0                                             147
278029 HI     school 1500030 1   Hawaii Department of Education 150003000285 240 MILILANI 'IKE   Regular School No 1 PK 5 2015   grade_2                                                   146.0                                             146
278058 HI     school 1500030 1   Hawaii Department of Education 150003000125 257 MAILI   Regular School No 1 PK 6 2015   grade_2                                                   146.0                                             146
278157 HI     school 1500030 1   Hawaii Department of Education 150003000060 405 KAHULUI   Regular School No 1 PK 5 2015   grade_2                                                   145.0                                             145
278200 HI     school 1500030 1   Hawaii Department of Education 150003000094 463 WILCOX   Regular School No 1 PK 5 2015   grade_2                                                   145.0                                             145
2734820 HI     school 1500030 1   Hawaii Department of Education 150003000248 280 Holomua Elem   Regular School No Elementary PK 6 2019   grade_2                                                   145.0                                             145
2734921 HI     school 1500030 1   Hawaii Department of Education 150003000258 353 Keaau Elem   Regular School No Elementary PK 5 2019   grade_2                                                   145.0                                             145
108161 HI     school 1500030 1   Hawaii Department of Education 150003000258 353 KEAAU EL   Regular School No 1 PK 5 2016   grade_2                                                   144.0                                             144
2429229 HI     school 1500030 1   Hawaii Department of Education 150003000051 384 Waiakea Elem   Regular School No Elementary PK 5 2020   grade_2                                                   144.0                                             144
2429240 HI     school 1500030 1   Hawaii Department of Education 150003000041 388 Kealakehe Elem   Regular School No Elementary PK 5 2020   grade_2                                                   144.0                                             144
2734932 HI     school 1500030 1   Hawaii Department of Education 150003000060 405 Kahului Elem   Regular School No Elementary PK 5 2019   grade_2                                                   144.0                                             144
108204 HI     school 1500030 1   Hawaii Department of Education 150003000084 454 KAPAA EL   Regular School No 1 PK 5 2016   grade_2                                                   143.0                                             143
2429153 HI     school 1500030 1   Hawaii Department of Education 150003000300 293 Hookele Elem   Regular School No Elementary PK 5 2020   grade_2                                                   143.0                                             143
108047 HI     school 1500030 1   Hawaii Department of Education 150003000105 234 MILILANI WAENA   Regular School No 1 PK 5 2016   grade_2                                                   142.0                                             142
2453954 HI     school 1500030 1   Hawaii Department of Education 150003000071 416 Lihikai Elem   Regular School No Elementary PK 5 2021   grade_2                                                   142.0                                             142
2734897 HI     school 1500030 1   Hawaii Department of Education 150003000051 384 Waiakea Elem   Regular School No Elementary PK 5 2019   grade_2                                                   142.0                                             142
108137 HI     school 1500030 1   Hawaii Department of Education 150003000051 384 WAIAKEA EL   Regular School No 1 PK 5 2016   grade_2                                                   140.0                                             140
278122 HI     school 1500030 1   Hawaii Department of Education 150003000051 384 WAIAKEA EL   Regular School No 1 PK 5 2015   grade_2                                                   140.0                                             140
2453837 HI     school 1500030 1   Hawaii Department of Education 150003000300 293 Hookele Elem   Regular School No Elementary PK 5 2021   grade_2                                                   140.0                                             140
2779871 HI     school 1500030 1   Hawaii Department of Education 150003000300 293 Hookele Elem   Regular School No Elementary PK 5 2018   grade_2                                                   140.0                                             140
278175 HI     school 1500030 1   Hawaii Department of Education 150003000061 406 KAMEHAMEHA III   Regular School No 1 PK 5 2015   grade_2                                                   139.0                                             139
2734828 HI     school 1500030 1   Hawaii Department of Education 150003000291 294 Keoneula Elem   Regular School No Elementary PK 6 2019   grade_2                                                   139.0                                             139
2734964 HI     school 1500030 1   Hawaii Department of Education 150003000084 454 Kapaa Elem   Regular School No Elementary PK 5 2019   grade_2                                                   139.0                                             139
2429270 HI     school 1500030 1   Hawaii Department of Education 150003000071 416 Lihikai Elem   Regular School No Elementary PK 5 2020   grade_2                                                   138.0                                             138
2734855 HI     school 1500030 1   Hawaii Department of Education 150003000159 274 Waipahu Elem   Regular School No Elementary PK 6 2019   grade_2                                                   138.0                                             138
2780014 HI     school 1500030 1   Hawaii Department of Education 150003000084 454 Kapaa Elem   Regular School No Elementary PK 5 2018   grade_2                                                   138.0                                             138
2734908 HI     school 1500030 1   Hawaii Department of Education 150003000041 388 Kealakehe Elem   Regular School No Elementary PK 5 2019   grade_2                                                   137.0                                             137
2779988 HI     school 1500030 1   Hawaii Department of Education 150003000071 416 Lihikai Elem   Regular School No Elementary PK 5 2018   grade_2                                                   137.0                                             137
108072 HI     school 1500030 1   Hawaii Department of Education 150003000230 271 LEIHOKU   Regular School No 1 PK 6 2016   grade_2                                                   136.0                                             136
108176 HI     school 1500030 1   Hawaii Department of Education 150003000064 409 KIHEI   Regular School No 1 PK 5 2016   grade_2                                                   136.0                                             136
108035 HI     school 1500030 1   Hawaii Department of Education 150003000173 207 HALE KULA   Regular School No 1 PK 5 2016   grade_2                                                   135.0                                             135
278146 HI     school 1500030 1   Hawaii Department of Education 150003000258 353 KEAAU EL   Regular School No 1 PK 5 2015   grade_2                                                   135.0                                             135
2734804 HI     school 1500030 1   Hawaii Department of Education 150003000099 241 Mililani Mauka Elem   Regular School No Elementary PK 5 2019   grade_2                                                   135.0                                             135
108053 HI     school 1500030 1   Hawaii Department of Education 150003000138 236 WHEELER EL   Regular School No 1 PK 5 2016   grade_2                                                   134.0                                             134
278109 HI     school 1500030 1   Hawaii Department of Education 150003000020 322 MOKAPU   Regular School No 1 PK 6 2015   grade_2                                                   134.0                                             134
2429216 HI     school 1500030 1   Hawaii Department of Education 150003000020 322 Mokapu Elem   Regular School No Elementary PK 6 2020   grade_2                                                   134.0                                             134
2453913 HI     school 1500030 1   Hawaii Department of Education 150003000051 384 Waiakea Elem   Regular School No Elementary PK 5 2021   grade_2                                                   134.0                                             134
2453948 HI     school 1500030 1   Hawaii Department of Education 150003000060 405 Kahului Elem   Regular School No Elementary PK 5 2021   grade_2                                                   134.0                                             134
2734975 HI     school 1500030 1   Hawaii Department of Education 150003000094 463 Wilcox Elem   Regular School No Elementary PK 5 2019   grade_2                                                   134.0                                             134
278057 HI     school 1500030 1   Hawaii Department of Education 150003000230 271 LEIHOKU   Regular School No 1 PK 6 2015   grade_2                                                   133.0                                             133
278172 HI     school 1500030 1   Hawaii Department of Education 150003000079 424 WAIHEE   Regular School No 1 PK 5 2015   grade_2                                                   133.0                                             133
2453871 HI     school 1500030 1   Hawaii Department of Education 150003000159 274 Waipahu Elem   Regular School No Elementary PK 6 2021   grade_2                                                   133.0                                             133
2453924 HI     school 1500030 1   Hawaii Department of Education 150003000041 388 Kealakehe Elem   Regular School No Elementary PK 5 2021   grade_2                                                   133.0                                             133
2734807 HI     school 1500030 1   Hawaii Department of Education 150003000105 234 Mililani Waena Elem   Regular School No Elementary PK 5 2019   grade_2                                                   133.0                                             133
127084 HI     school 1500030 1   Hawaii Department of Education 150003000136 250 AHRENS   Regular School No Elementary PK 6 2017   grade_2                                                   132.0                                             132
2429296 HI     school 1500030 1   Hawaii Department of Education 150003000084 454 Kapaa Elem   Regular School No Elementary PK 5 2020   grade_2                                                   132.0                                             132
2734884 HI     school 1500030 1   Hawaii Department of Education 150003000020 322 Mokapu Elem   Regular School No Elementary PK 6 2019   grade_2                                                   132.0                                             132
2779950 HI     school 1500030 1   Hawaii Department of Education 150003000054 386 Waiakeawaena Elem   Regular School No Elementary PK 5 2018   grade_2                                                   132.0                                             132
2429157 HI     school 1500030 1   Hawaii Department of Education 150003000166 282 Kapolei Elem   Regular School No Elementary PK 5 2020   grade_2                                                   130.0                                             130
2779854 HI     school 1500030 1   Hawaii Department of Education 150003000099 241 Mililani Mauka Elem   Regular School No Elementary PK 5 2018   grade_2                                                   130.0                                             130
108146 HI     school 1500030 1   Hawaii Department of Education 150003000232 371 KAHAKAI   Regular School No 1 PK 5 2016   grade_2                                                   129.0                                             129
108186 HI     school 1500030 1   Hawaii Department of Education 150003000297 436 PUU KUKUI   Regular School No 1 PK 5 2016   grade_2                                                   129.0                                             129
127175 HI     school 1500030 1   Hawaii Department of Education 150003000060 405 KAHULUI   Regular School No Elementary PK 5 2017   grade_2                                                   129.0                                             129
2734950 HI     school 1500030 1   Hawaii Department of Education 150003000061 406 Kamehameha III Elem   Regular School No Elementary PK 5 2019   grade_2                                                   129.0                                             129
2779947 HI     school 1500030 1   Hawaii Department of Education 150003000051 384 Waiakea Elem   Regular School No Elementary PK 5 2018   grade_2                                                   129.0                                             129