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
2779281 HI     school 1500030 1   Hawaii Department of Education 150003000135 251 Barbers Point Elem   Regular School No Elementary PK 5 2018   kindergarten                                                   86.0                                             86
107476 HI     school 1500030 1   Hawaii Department of Education 150003000134 252 CAMPBELL HI   Regular School No 3 09 12 2016   kindergarten                                                   0.0                                             0
126479 HI     school 1500030 1   Hawaii Department of Education 150003000134 252 CAMPBELL HI   Regular School No High 09 12 2017   kindergarten                                                   0.0                                             0
277464 HI     school 1500030 1   Hawaii Department of Education 150003000134 252 CAMPBELL HI   Regular School No 3 09 12 2015   kindergarten                                                   0.0                                             0
107519 HI     school 1500030 1   Hawaii Department of Education 150003000100 301 CASTLE HI   Regular School No 3 09 12 2016   kindergarten                                                   0.0                                             0
126522 HI     school 1500030 1   Hawaii Department of Education 150003000100 301 CASTLE HI   Regular School No High 09 12 2017   kindergarten                                                   0.0                                             0
277506 HI     school 1500030 1   Hawaii Department of Education 150003000100 301 CASTLE HI   Regular School No 3 09 12 2015   kindergarten                                                   0.0                                             0
107408 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 CENTRAL MID   Regular School No 2 06 8 2016   kindergarten                                                   0.0                                             0
126411 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 CENTRAL MID   Regular School No Middle 06 8 2017   kindergarten                                                   0.0                                             0
277396 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 CENTRAL MID   Regular School No 2 06 8 2015   kindergarten                                                   0.0                                             0
107636 HI     school 1500030 1   Hawaii Department of Education 150003000262 396 CONNECTIONS-PCS charter Regular School Yes 4 KG 12 2016   kindergarten                                                   17.0                                             17
126639 HI     school 1500030 1   Hawaii Department of Education 150003000262 396 CONNECTIONS-PCS charter Regular School Yes Other KG 12 2017   kindergarten                                                   19.0                                             19
277628 HI     school 1500030 1   Hawaii Department of Education 150003000262 396 CONNECTIONS-PCS charter Regular School Yes 4 KG 12 2015   kindergarten                                                   14.0                                             14
2428562 HI     school 1500030 1   Hawaii Department of Education 150003000134 252 Campbell High   Regular School No High 09 12 2020   kindergarten                                                   0.0                                             0
2453243 HI     school 1500030 1   Hawaii Department of Education 150003000134 252 Campbell High   Regular School No High 09 12 2021   kindergarten                                                   0.0                                             0
2734232 HI     school 1500030 1   Hawaii Department of Education 150003000134 252 Campbell High   Regular School No High 09 12 2019   kindergarten                                                   0.0                                             0
2779282 HI     school 1500030 1   Hawaii Department of Education 150003000134 252 Campbell High   Regular School No High 09 12 2018   kindergarten                                                   0.0                                             0
2428605 HI     school 1500030 1   Hawaii Department of Education 150003000100 301 Castle High   Regular School No High 09 12 2020   kindergarten                                                   0.0                                             0
2453287 HI     school 1500030 1   Hawaii Department of Education 150003000100 301 Castle High   Regular School No High 09 12 2021   kindergarten                                                   0.0                                             0
2734275 HI     school 1500030 1   Hawaii Department of Education 150003000100 301 Castle High   Regular School No High 09 12 2019   kindergarten                                                   0.0                                             0
2779325 HI     school 1500030 1   Hawaii Department of Education 150003000100 301 Castle High   Regular School No High 09 12 2018   kindergarten                                                   0.0                                             0
2428494 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 Central Middle   Regular School No Middle 06 8 2020   kindergarten                                                   0.0                                             0
2453175 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 Central Middle   Regular School No Middle 06 8 2021   kindergarten                                                   0.0                                             0
2734164 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 Central Middle   Regular School No Middle 06 8 2019   kindergarten                                                   0.0                                             0
2779214 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 Central Middle   Regular School No Middle 06 8 2018   kindergarten                                                   0.0                                             0
2428723 HI     school 1500030 1   Hawaii Department of Education 150003000262 396 Connections NCPCS charter Regular School Yes Other KG 12 2020   kindergarten                                                   19.0                                             19
2453405 HI     school 1500030 1   Hawaii Department of Education 150003000262 396 Connections NCPCS charter Regular School Yes Other KG 12 2021   kindergarten                                                   11.0                                             11
2734397 HI     school 1500030 1   Hawaii Department of Education 150003000262 396 Connections NCPCS charter Regular School Yes Other KG 12 2019   kindergarten                                                   17.0                                             17
2779442 HI     school 1500030 1   Hawaii Department of Education 150003000262 396 Connections NCPCS charter Regular School Yes Other KG 12 2018   kindergarten                                                   21.0                                             21
107548 HI     school 1500030 1   Hawaii Department of Education 150003000027 351 DE SILVA   Regular School No 1 PK 6 2016   kindergarten                                                   57.0                                             57
126551 HI     school 1500030 1   Hawaii Department of Education 150003000027 351 DE SILVA   Regular School No Elementary PK 6 2017   kindergarten                                                   54.0                                             54
277535 HI     school 1500030 1   Hawaii Department of Education 150003000027 351 DE SILVA   Regular School No 1 PK 6 2015   kindergarten                                                   51.0                                             51
107381 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 DOLE MID   Regular School No 2 06 8 2016   kindergarten                                                   0.0                                             0
126384 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 DOLE MID   Regular School No Middle 06 8 2017   kindergarten                                                   0.0                                             0
277369 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 DOLE MID   Regular School No 2 06 8 2015   kindergarten                                                   0.0                                             0
2428467 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 Dole Middle   Regular School No Middle 06 8 2020   kindergarten                                                   0.0                                             0
2453148 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 Dole Middle   Regular School No Middle 06 8 2021   kindergarten                                                   0.0                                             0
2734137 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 Dole Middle   Regular School No Middle 06 8 2019   kindergarten                                                   0.0                                             0
2779187 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 Dole Middle   Regular School No Middle 06 8 2018   kindergarten                                                   0.0                                             0
2428724 HI     school 1500030 1   Hawaii Department of Education 150003000305 568 DreamHouse Ewa Beach charter Regular School Yes Middle 06 6 2020   kindergarten                                                   0.0                                             0
2453406 HI     school 1500030 1   Hawaii Department of Education 150003000305 568 DreamHouse Ewa Beach charter Regular School Yes Middle 06 7 2021   kindergarten                                                   0.0                                             0
107637 HI     school 1500030 1   Hawaii Department of Education 150003000273 543 EDUC LAB: A HAWAII NC-PCS charter Regular School Yes 4 KG 12 2016   kindergarten                                                   10.0                                             10
126640 HI     school 1500030 1   Hawaii Department of Education 150003000273 543 EDUC LAB: A HAWAII NC-PCS charter Regular School Yes Other KG 12 2017   kindergarten                                                   10.0                                             10
277637 HI     school 1500030 1   Hawaii Department of Education 150003000273 543 EDUC LAB: A HAWAII NC-PCS charter Regular School Yes 4 KG 12 2015   kindergarten                                                   10.0                                             10
107620 HI     school 1500030 1   Hawaii Department of Education 150003000081 451 ELEELE   Regular School No 1 PK 5 2016   kindergarten                                                   76.0                                             76
126623 HI     school 1500030 1   Hawaii Department of Education 150003000081 451 ELEELE   Regular School No Elementary PK 5 2017   kindergarten                                                   93.0                                             93
277607 HI     school 1500030 1   Hawaii Department of Education 150003000081 451 ELEELE   Regular School No 1 PK 5 2015   kindergarten                                                   71.0                                             71
107535 HI     school 1500030 1   Hawaii Department of Education 150003000001 302 ENCHANTED LAKE   Regular School No 1 PK 6 2016   kindergarten                                                   56.0                                             56
126538 HI     school 1500030 1   Hawaii Department of Education 150003000001 302 ENCHANTED LAKE   Regular School No Elementary PK 6 2017   kindergarten                                                   58.0                                             58
277522 HI     school 1500030 1   Hawaii Department of Education 150003000001 302 ENCHANTED LAKE   Regular School No 1 PK 6 2015   kindergarten                                                   51.0                                             51
107477 HI     school 1500030 1   Hawaii Department of Education 150003000132 254 EWA BEACH EL   Regular School No 1 PK 6 2016   kindergarten                                                   119.0                                             119
126480 HI     school 1500030 1   Hawaii Department of Education 150003000132 254 EWA BEACH EL   Regular School No Elementary PK 6 2017   kindergarten                                                   91.0                                             91
277465 HI     school 1500030 1   Hawaii Department of Education 150003000132 254 EWA BEACH EL   Regular School No 1 PK 6 2015   kindergarten                                                   61.0                                             61
107478 HI     school 1500030 1   Hawaii Department of Education 150003000133 253 EWA EL   Regular School No 1 PK 6 2016   kindergarten                                                   149.0                                             149
126481 HI     school 1500030 1   Hawaii Department of Education 150003000133 253 EWA EL   Regular School No Elementary PK 6 2017   kindergarten                                                   157.0                                             157
277466 HI     school 1500030 1   Hawaii Department of Education 150003000133 253 EWA EL   Regular School No 1 PK 6 2015   kindergarten                                                   104.0                                             104
107479 HI     school 1500030 1   Hawaii Department of Education 150003000296 296 EWA MAKAI MID   Regular School No 2 07 8 2016   kindergarten                                                   0.0                                             0
126482 HI     school 1500030 1   Hawaii Department of Education 150003000296 296 EWA MAKAI MID   Regular School No Middle 07 8 2017   kindergarten                                                   0.0                                             0
277467 HI     school 1500030 1   Hawaii Department of Education 150003000296 296 EWA MAKAI MID   Regular School No 2 07 8 2015   kindergarten                                                   0.0                                             0
2428706 HI     school 1500030 1   Hawaii Department of Education 150003000081 451 Eleele Elem   Regular School No Elementary PK 5 2020   kindergarten                                                   67.0                                             67
2453388 HI     school 1500030 1   Hawaii Department of Education 150003000081 451 Eleele Elem   Regular School No Elementary PK 5 2021   kindergarten                                                   46.0                                             46
2734376 HI     school 1500030 1   Hawaii Department of Education 150003000081 451 Eleele Elem   Regular School No Elementary PK 5 2019   kindergarten                                                   70.0                                             70
2779426 HI     school 1500030 1   Hawaii Department of Education 150003000081 451 Eleele Elem   Regular School No Elementary PK 5 2018   kindergarten                                                   76.0                                             76
2428621 HI     school 1500030 1   Hawaii Department of Education 150003000001 302 Enchanted Lake Elem   Regular School No Elementary PK 6 2020   kindergarten                                                   50.0                                             50
2453303 HI     school 1500030 1   Hawaii Department of Education 150003000001 302 Enchanted Lake Elem   Regular School No Elementary PK 6 2021   kindergarten                                                   22.0                                             22
2734291 HI     school 1500030 1   Hawaii Department of Education 150003000001 302 Enchanted Lake Elem   Regular School No Elementary PK 6 2019   kindergarten                                                   36.0                                             36
2779341 HI     school 1500030 1   Hawaii Department of Education 150003000001 302 Enchanted Lake Elem   Regular School No Elementary PK 6 2018   kindergarten                                                   59.0                                             59
2428563 HI     school 1500030 1   Hawaii Department of Education 150003000132 254 Ewa Beach Elem   Regular School No Elementary PK 6 2020   kindergarten                                                   101.0                                             101
2453244 HI     school 1500030 1   Hawaii Department of Education 150003000132 254 Ewa Beach Elem   Regular School No Elementary PK 5 2021   kindergarten                                                   96.0                                             96
2734233 HI     school 1500030 1   Hawaii Department of Education 150003000132 254 Ewa Beach Elem   Regular School No Elementary PK 6 2019   kindergarten                                                   108.0                                             108
2779283 HI     school 1500030 1   Hawaii Department of Education 150003000132 254 Ewa Beach Elem   Regular School No Elementary PK 6 2018   kindergarten                                                   103.0                                             103
2428564 HI     school 1500030 1   Hawaii Department of Education 150003000133 253 Ewa Elem   Regular School No Elementary PK 6 2020   kindergarten                                                   137.0                                             137
2453245 HI     school 1500030 1   Hawaii Department of Education 150003000133 253 Ewa Elem   Regular School No Elementary PK 5 2021   kindergarten                                                   139.0                                             139
2734234 HI     school 1500030 1   Hawaii Department of Education 150003000133 253 Ewa Elem   Regular School No Elementary PK 6 2019   kindergarten                                                   144.0                                             144
2779284 HI     school 1500030 1   Hawaii Department of Education 150003000133 253 Ewa Elem   Regular School No Elementary PK 6 2018   kindergarten                                                   146.0                                             146
2428565 HI     school 1500030 1   Hawaii Department of Education 150003000296 296 Ewa Makai Middle   Regular School No Middle 06 8 2020   kindergarten                                                   0.0                                             0
2453246 HI     school 1500030 1   Hawaii Department of Education 150003000296 296 Ewa Makai Middle   Regular School No Middle 06 8 2021   kindergarten                                                   0.0                                             0
2734235 HI     school 1500030 1   Hawaii Department of Education 150003000296 296 Ewa Makai Middle   Regular School No Middle 07 8 2019   kindergarten                                                   0.0                                             0
2779285 HI     school 1500030 1   Hawaii Department of Education 150003000296 296 Ewa Makai Middle   Regular School No Middle 07 8 2018   kindergarten                                                   0.0                                             0
107382 HI     school 1500030 1   Hawaii Department of Education 150003000221 106 FARRINGTON HI   Regular School No 3 09 12 2016   kindergarten                                                   0.0                                             0
126385 HI     school 1500030 1   Hawaii Department of Education 150003000221 106 FARRINGTON HI   Regular School No High 09 12 2017   kindergarten                                                   0.0                                             0
277370 HI     school 1500030 1   Hawaii Department of Education 150003000221 106 FARRINGTON HI   Regular School No 3 09 12 2015   kindergarten                                                   0.0                                             0
107383 HI     school 1500030 1   Hawaii Department of Education 150003000220 107 FERN   Regular School No 1 PK 5 2016   kindergarten                                                   53.0                                             53
126386 HI     school 1500030 1   Hawaii Department of Education 150003000220 107 FERN   Regular School No Elementary PK 5 2017   kindergarten                                                   39.0                                             39
277371 HI     school 1500030 1   Hawaii Department of Education 150003000220 107 FERN   Regular School No 1 PK 5 2015   kindergarten                                                   42.0                                             42
2428468 HI     school 1500030 1   Hawaii Department of Education 150003000221 106 Farrington High   Regular School No High 09 12 2020   kindergarten                                                   0.0                                             0
2453149 HI     school 1500030 1   Hawaii Department of Education 150003000221 106 Farrington High   Regular School No High 09 12 2021   kindergarten                                                   0.0                                             0
2734138 HI     school 1500030 1   Hawaii Department of Education 150003000221 106 Farrington High   Regular School No High 09 12 2019   kindergarten                                                   0.0                                             0
2779188 HI     school 1500030 1   Hawaii Department of Education 150003000221 106 Farrington High   Regular School No High 09 12 2018   kindergarten                                                   0.0                                             0
2428469 HI     school 1500030 1   Hawaii Department of Education 150003000220 107 Fern Elem   Regular School No Elementary PK 5 2020   kindergarten                                                   39.0                                             39
2453150 HI     school 1500030 1   Hawaii Department of Education 150003000220 107 Fern Elem   Regular School No Elementary PK 5 2021   kindergarten                                                   32.0                                             32
2734139 HI     school 1500030 1   Hawaii Department of Education 150003000220 107 Fern Elem   Regular School No Elementary PK 5 2019   kindergarten                                                   49.0                                             49
2779189 HI     school 1500030 1   Hawaii Department of Education 150003000220 107 Fern Elem   Regular School No Elementary PK 5 2018   kindergarten                                                   41.0                                             41
107549 HI     school 1500030 1   Hawaii Department of Education 150003000028 352 HAAHEO   Regular School No 1 PK 6 2016   kindergarten                                                   22.0                                             22
126552 HI     school 1500030 1   Hawaii Department of Education 150003000028 352 HAAHEO   Regular School No Elementary PK 6 2017   kindergarten                                                   26.0                                             26
277536 HI     school 1500030 1   Hawaii Department of Education 150003000028 352 HAAHEO   Regular School No 1 PK 6 2015   kindergarten                                                   24.0                                             24
107384 HI     school 1500030 1   Hawaii Department of Education 150003000219 108 HAHAIONE   Regular School No 1 PK 5 2016   kindergarten                                                   74.0                                             74
126387 HI     school 1500030 1   Hawaii Department of Education 150003000219 108 HAHAIONE   Regular School No Elementary PK 5 2017   kindergarten                                                   77.0                                             77
277372 HI     school 1500030 1   Hawaii Department of Education 150003000219 108 HAHAIONE   Regular School No 1 PK 5 2015   kindergarten                                                   79.0                                             79
107590 HI     school 1500030 1   Hawaii Department of Education 150003000057 401 HAIKU   Regular School No 1 PK 5 2016   kindergarten                                                   70.0                                             70
126593 HI     school 1500030 1   Hawaii Department of Education 150003000057 401 HAIKU   Regular School No Elementary PK 5 2017   kindergarten                                                   75.0                                             75