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
2429806 HI     school 1500030 1   Hawaii Department of Education 150003000027 351 de Silva Elem   Regular School No Elementary PK 6 2020   grade_4                                                   70.0                                             70
2454492 HI     school 1500030 1   Hawaii Department of Education 150003000027 351 de Silva Elem   Regular School No Elementary PK 6 2021   grade_4                                                   67.0                                             67
2735472 HI     school 1500030 1   Hawaii Department of Education 150003000027 351 de Silva Elem   Regular School No Elementary PK 6 2019   grade_4                                                   58.0                                             58
2780522 HI     school 1500030 1   Hawaii Department of Education 150003000027 351 de Silva Elem   Regular School No Elementary PK 6 2018   grade_4                                                   69.0                                             69
2429662 HI     school 1500030 1   Hawaii Department of Education 150003000179 153 Wilson Elem   Regular School No Elementary PK 5 2020   grade_4                                                   86.0                                             86
2454347 HI     school 1500030 1   Hawaii Department of Education 150003000179 153 Wilson Elem   Regular School No Elementary PK 5 2021   grade_4                                                   84.0                                             84
2735328 HI     school 1500030 1   Hawaii Department of Education 150003000179 153 Wilson Elem   Regular School No Elementary PK 5 2019   grade_4                                                   91.0                                             91
2780378 HI     school 1500030 1   Hawaii Department of Education 150003000179 153 Wilson Elem   Regular School No Elementary PK 5 2018   grade_4                                                   95.0                                             95
2429893 HI     school 1500030 1   Hawaii Department of Education 150003000094 463 Wilcox Elem   Regular School No Elementary PK 5 2020   grade_4                                                   115.0                                             115
2454579 HI     school 1500030 1   Hawaii Department of Education 150003000094 463 Wilcox Elem   Regular School No Elementary PK 5 2021   grade_4                                                   130.0                                             130
2735559 HI     school 1500030 1   Hawaii Department of Education 150003000094 463 Wilcox Elem   Regular School No Elementary PK 5 2019   grade_4                                                   108.0                                             108
2780609 HI     school 1500030 1   Hawaii Department of Education 150003000094 463 Wilcox Elem   Regular School No Elementary PK 5 2018   grade_4                                                   131.0                                             131
2429732 HI     school 1500030 1   Hawaii Department of Education 150003000137 237 Wheeler Middle   Regular School No Middle 06 8 2020   grade_4                                                   0.0                                             0
2454417 HI     school 1500030 1   Hawaii Department of Education 150003000137 237 Wheeler Middle   Regular School No Middle 06 8 2021   grade_4                                                   0.0                                             0
2735398 HI     school 1500030 1   Hawaii Department of Education 150003000137 237 Wheeler Middle   Regular School No Middle 06 8 2019   grade_4                                                   0.0                                             0
2780448 HI     school 1500030 1   Hawaii Department of Education 150003000137 237 Wheeler Middle   Regular School No Middle 06 8 2018   grade_4                                                   0.0                                             0
2429731 HI     school 1500030 1   Hawaii Department of Education 150003000138 236 Wheeler Elem   Regular School No Elementary PK 5 2020   grade_4                                                   99.0                                             99
2454416 HI     school 1500030 1   Hawaii Department of Education 150003000138 236 Wheeler Elem   Regular School No Elementary PK 5 2021   grade_4                                                   90.0                                             90
2735397 HI     school 1500030 1   Hawaii Department of Education 150003000138 236 Wheeler Elem   Regular School No Elementary PK 5 2019   grade_4                                                   111.0                                             111
2780447 HI     school 1500030 1   Hawaii Department of Education 150003000138 236 Wheeler Elem   Regular School No Elementary PK 5 2018   grade_4                                                   127.0                                             127
2429930 HI     school 1500030 1   Hawaii Department of Education 150003000265 399 West Hawaii Explorations PCS charter Regular School Yes High 06 12 2020   grade_4                                                   0.0                                             0
2454616 HI     school 1500030 1   Hawaii Department of Education 150003000265 399 West Hawaii Explorations PCS charter Regular School Yes High 06 12 2021   grade_4                                                   0.0                                             0
2735568 HI     school 1500030 1   Hawaii Department of Education 150003000265 399 West Hawaii Explorations PCS charter Regular School Yes High 06 12 2019   grade_4                                                   0.0                                             0
2780645 HI     school 1500030 1   Hawaii Department of Education 150003000265 399 West Hawaii Explorations PCS charter Regular School Yes High 06 12 2018   grade_4                                                   0.0                                             0
2429712 HI     school 1500030 1   Hawaii Department of Education 150003000139 235 Webling Elem   Regular School No Elementary PK 6 2020   grade_4                                                   60.0                                             60
2454397 HI     school 1500030 1   Hawaii Department of Education 150003000139 235 Webling Elem   Regular School No Elementary PK 6 2021   grade_4                                                   56.0                                             56
2735378 HI     school 1500030 1   Hawaii Department of Education 150003000139 235 Webling Elem   Regular School No Elementary PK 6 2019   grade_4                                                   42.0                                             42
2780428 HI     school 1500030 1   Hawaii Department of Education 150003000139 235 Webling Elem   Regular School No Elementary PK 6 2018   grade_4                                                   72.0                                             72
2429690 HI     school 1500030 1   Hawaii Department of Education 150003000180 152 Washington Middle   Regular School No Middle 06 8 2020   grade_4                                                   0.0                                             0
2454375 HI     school 1500030 1   Hawaii Department of Education 150003000180 152 Washington Middle   Regular School No Middle 06 8 2021   grade_4                                                   0.0                                             0
2735356 HI     school 1500030 1   Hawaii Department of Education 150003000180 152 Washington Middle   Regular School No Middle 06 8 2019   grade_4                                                   0.0                                             0
2780406 HI     school 1500030 1   Hawaii Department of Education 150003000180 152 Washington Middle   Regular School No Middle 06 8 2018   grade_4                                                   0.0                                             0
2429775 HI     school 1500030 1   Hawaii Department of Education 150003000158 278 Waipahu Int   Regular School No Middle 07 8 2020   grade_4                                                   0.0                                             0
2454461 HI     school 1500030 1   Hawaii Department of Education 150003000158 278 Waipahu Int   Regular School No Middle 07 8 2021   grade_4                                                   0.0                                             0
2735441 HI     school 1500030 1   Hawaii Department of Education 150003000158 278 Waipahu Int   Regular School No Middle 07 8 2019   grade_4                                                   0.0                                             0
2780491 HI     school 1500030 1   Hawaii Department of Education 150003000158 278 Waipahu Int   Regular School No Middle 07 8 2018   grade_4                                                   0.0                                             0
2429774 HI     school 1500030 1   Hawaii Department of Education 150003000161 277 Waipahu High   Regular School No High 09 12 2020   grade_4                                                   0.0                                             0
2454460 HI     school 1500030 1   Hawaii Department of Education 150003000161 277 Waipahu High   Regular School No High 09 12 2021   grade_4                                                   0.0                                             0
2735440 HI     school 1500030 1   Hawaii Department of Education 150003000161 277 Waipahu High   Regular School No High 09 12 2019   grade_4                                                   0.0                                             0
2780490 HI     school 1500030 1   Hawaii Department of Education 150003000161 277 Waipahu High   Regular School No High 09 12 2018   grade_4                                                   0.0                                             0
2429773 HI     school 1500030 1   Hawaii Department of Education 150003000159 274 Waipahu Elem   Regular School No Elementary PK 6 2020   grade_4                                                   158.0                                             158
2454459 HI     school 1500030 1   Hawaii Department of Education 150003000159 274 Waipahu Elem   Regular School No Elementary PK 6 2021   grade_4                                                   138.0                                             138
2735439 HI     school 1500030 1   Hawaii Department of Education 150003000159 274 Waipahu Elem   Regular School No Elementary PK 6 2019   grade_4                                                   97.0                                             97
2780489 HI     school 1500030 1   Hawaii Department of Education 150003000159 274 Waipahu Elem   Regular School No Elementary PK 6 2018   grade_4                                                   145.0                                             145
2429929 HI     school 1500030 1   Hawaii Department of Education 150003000268 394 Waimea Middle PCCS charter Regular School Yes Middle 06 8 2020   grade_4                                                   0.0                                             0
2454615 HI     school 1500030 1   Hawaii Department of Education 150003000268 394 Waimea Middle PCCS charter Regular School Yes Middle 06 8 2021   grade_4                                                   0.0                                             0
2735564 HI     school 1500030 1   Hawaii Department of Education 150003000268 394 Waimea Middle PCCS charter Regular School Yes Middle 06 8 2019   grade_4                                                   0.0                                             0
2780644 HI     school 1500030 1   Hawaii Department of Education 150003000268 394 Waimea Middle PCCS charter Regular School Yes Middle 06 8 2018   grade_4                                                   0.0                                             0
2429892 HI     school 1500030 1   Hawaii Department of Education 150003000093 462 Waimea High   Regular School No High 09 12 2020   grade_4                                                   0.0                                             0
2454578 HI     school 1500030 1   Hawaii Department of Education 150003000093 462 Waimea High   Regular School No High 09 12 2021   grade_4                                                   0.0                                             0
2735558 HI     school 1500030 1   Hawaii Department of Education 150003000093 462 Waimea High   Regular School No High 09 12 2019   grade_4                                                   0.0                                             0
2780608 HI     school 1500030 1   Hawaii Department of Education 150003000093 462 Waimea High   Regular School No High 09 12 2018   grade_4                                                   0.0                                             0
2429837 HI     school 1500030 1   Hawaii Department of Education 150003000055 387 Waimea Elem   Regular School No Elementary PK 5 2020   grade_4                                                   67.0                                             67
2454523 HI     school 1500030 1   Hawaii Department of Education 150003000055 387 Waimea Elem   Regular School No Elementary PK 5 2021   grade_4                                                   61.0                                             61
2735503 HI     school 1500030 1   Hawaii Department of Education 150003000055 387 Waimea Elem   Regular School No Elementary PK 5 2019   grade_4                                                   72.0                                             72
2780553 HI     school 1500030 1   Hawaii Department of Education 150003000055 387 Waimea Elem   Regular School No Elementary PK 5 2018   grade_4                                                   72.0                                             72
2429891 HI     school 1500030 1   Hawaii Department of Education 150003000092 464 Waimea Canyon Middle   Regular School No Middle 06 8 2020   grade_4                                                   0.0                                             0
2454577 HI     school 1500030 1   Hawaii Department of Education 150003000092 464 Waimea Canyon Middle   Regular School No Middle 06 8 2021   grade_4                                                   0.0                                             0
2735557 HI     school 1500030 1   Hawaii Department of Education 150003000092 464 Waimea Canyon Middle   Regular School No Middle 06 8 2019   grade_4                                                   0.0                                             0
2780607 HI     school 1500030 1   Hawaii Department of Education 150003000092 464 Waimea Canyon Middle   Regular School No Middle 06 8 2018   grade_4                                                   0.0                                             0
2429805 HI     school 1500030 1   Hawaii Department of Education 150003000026 327 Waimanalo El & Int   Regular School No Elementary PK 8 2020   grade_4                                                   29.0                                             29
2454491 HI     school 1500030 1   Hawaii Department of Education 150003000026 327 Waimanalo El & Int   Regular School No Elementary PK 8 2021   grade_4                                                   30.0                                             30
2735471 HI     school 1500030 1   Hawaii Department of Education 150003000026 327 Waimanalo El & Int   Regular School No Elementary PK 8 2019   grade_4                                                   32.0                                             32
2780521 HI     school 1500030 1   Hawaii Department of Education 150003000026 327 Waimanalo El & Int   Regular School No Elementary PK 8 2018   grade_4                                                   31.0                                             31
2429711 HI     school 1500030 1   Hawaii Department of Education 150003000140 233 Waimalu Elem   Regular School No Elementary PK 6 2020   grade_4                                                   49.0                                             49
2454396 HI     school 1500030 1   Hawaii Department of Education 150003000140 233 Waimalu Elem   Regular School No Elementary PK 6 2021   grade_4                                                   39.0                                             39
2735377 HI     school 1500030 1   Hawaii Department of Education 150003000140 233 Waimalu Elem   Regular School No Elementary PK 6 2019   grade_4                                                   35.0                                             35
2780427 HI     school 1500030 1   Hawaii Department of Education 150003000140 233 Waimalu Elem   Regular School No Elementary PK 6 2018   grade_4                                                   61.0                                             61
2429866 HI     school 1500030 1   Hawaii Department of Education 150003000080 425 Wailuku Elem   Regular School No Elementary PK 5 2020   grade_4                                                   102.0                                             102
2454552 HI     school 1500030 1   Hawaii Department of Education 150003000080 425 Wailuku Elem   Regular School No Elementary PK 5 2021   grade_4                                                   92.0                                             92
2735532 HI     school 1500030 1   Hawaii Department of Education 150003000080 425 Wailuku Elem   Regular School No Elementary PK 5 2019   grade_4                                                   89.0                                             89
2780582 HI     school 1500030 1   Hawaii Department of Education 150003000080 425 Wailuku Elem   Regular School No Elementary PK 5 2018   grade_4                                                   111.0                                             111
2429836 HI     school 1500030 1   Hawaii Department of Education 150003000247 393 Waikoloa El & Middle   Regular School No Elementary PK 8 2020   grade_4                                                   83.0                                             83
2454522 HI     school 1500030 1   Hawaii Department of Education 150003000247 393 Waikoloa El & Middle   Regular School No Elementary PK 8 2021   grade_4                                                   76.0                                             76
2735502 HI     school 1500030 1   Hawaii Department of Education 150003000247 393 Waikoloa El & Middle   Regular School No Elementary PK 8 2019   grade_4                                                   82.0                                             82
2780552 HI     school 1500030 1   Hawaii Department of Education 150003000247 393 Waikoloa El & Middle   Regular School No Elementary PK 8 2018   grade_4                                                   97.0                                             97
2429661 HI     school 1500030 1   Hawaii Department of Education 150003000182 150 Waikiki Elem   Regular School No Elementary PK 5 2020   grade_4                                                   92.0                                             92
2454346 HI     school 1500030 1   Hawaii Department of Education 150003000182 150 Waikiki Elem   Regular School No Elementary PK 5 2021   grade_4                                                   88.0                                             88
2735327 HI     school 1500030 1   Hawaii Department of Education 150003000182 150 Waikiki Elem   Regular School No Elementary PK 5 2019   grade_4                                                   93.0                                             93
2780377 HI     school 1500030 1   Hawaii Department of Education 150003000182 150 Waikiki Elem   Regular School No Elementary PK 5 2018   grade_4                                                   97.0                                             97
2429772 HI     school 1500030 1   Hawaii Department of Education 150003000257 290 Waikele Elem   Regular School No Elementary PK 6 2020   grade_4                                                   90.0                                             90
2454458 HI     school 1500030 1   Hawaii Department of Education 150003000257 290 Waikele Elem   Regular School No Elementary PK 6 2021   grade_4                                                   73.0                                             73
2735438 HI     school 1500030 1   Hawaii Department of Education 150003000257 290 Waikele Elem   Regular School No Elementary PK 6 2019   grade_4                                                   55.0                                             55
2780488 HI     school 1500030 1   Hawaii Department of Education 150003000257 290 Waikele Elem   Regular School No Elementary PK 6 2018   grade_4                                                   91.0                                             91
2429865 HI     school 1500030 1   Hawaii Department of Education 150003000079 424 Waihee Elem   Regular School No Elementary PK 5 2020   grade_4                                                   95.0                                             95
2454551 HI     school 1500030 1   Hawaii Department of Education 150003000079 424 Waihee Elem   Regular School No Elementary PK 5 2021   grade_4                                                   101.0                                             101
2735531 HI     school 1500030 1   Hawaii Department of Education 150003000079 424 Waihee Elem   Regular School No Elementary PK 5 2019   grade_4                                                   78.0                                             78
2780581 HI     school 1500030 1   Hawaii Department of Education 150003000079 424 Waihee Elem   Regular School No Elementary PK 5 2018   grade_4                                                   113.0                                             113
2429771 HI     school 1500030 1   Hawaii Department of Education 150003000109 288 Waiau Elem   Regular School No Elementary PK 6 2020   grade_4                                                   69.0                                             69
2454457 HI     school 1500030 1   Hawaii Department of Education 150003000109 288 Waiau Elem   Regular School No Elementary PK 6 2021   grade_4                                                   69.0                                             69
2735437 HI     school 1500030 1   Hawaii Department of Education 150003000109 288 Waiau Elem   Regular School No Elementary PK 6 2019   grade_4                                                   41.0                                             41
2780487 HI     school 1500030 1   Hawaii Department of Education 150003000109 288 Waiau Elem   Regular School No Elementary PK 6 2018   grade_4                                                   54.0                                             54
2429758 HI     school 1500030 1   Hawaii Department of Education 150003000229 273 Waianae Int   Regular School No Middle 07 8 2020   grade_4                                                   0.0                                             0
2454444 HI     school 1500030 1   Hawaii Department of Education 150003000229 273 Waianae Int   Regular School No Middle 07 8 2021   grade_4                                                   0.0                                             0
2735424 HI     school 1500030 1   Hawaii Department of Education 150003000229 273 Waianae Int   Regular School No Middle 07 8 2019   grade_4                                                   0.0                                             0
2780474 HI     school 1500030 1   Hawaii Department of Education 150003000229 273 Waianae Int   Regular School No Middle 07 8 2018   grade_4                                                   0.0                                             0
2429757 HI     school 1500030 1   Hawaii Department of Education 150003000110 272 Waianae High   Regular School No High 09 12 2020   grade_4                                                   0.0                                             0
2454443 HI     school 1500030 1   Hawaii Department of Education 150003000110 272 Waianae High   Regular School No High 09 12 2021   grade_4                                                   0.0                                             0
2735423 HI     school 1500030 1   Hawaii Department of Education 150003000110 272 Waianae High   Regular School No High 09 12 2019   grade_4                                                   0.0                                             0
2780473 HI     school 1500030 1   Hawaii Department of Education 150003000110 272 Waianae High   Regular School No High 09 12 2018   grade_4                                                   0.0                                             0
2429756 HI     school 1500030 1   Hawaii Department of Education 150003000111 270 Waianae Elem   Regular School No Elementary PK 6 2020   grade_4                                                   63.0                                             63