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
2430978 HI     school 1500030 1   Hawaii Department of Education 150003000027 351 de Silva Elem   Regular School No Elementary PK 6 2020   grade_8                                                   0.0                                             0
2455668 HI     school 1500030 1   Hawaii Department of Education 150003000027 351 de Silva Elem   Regular School No Elementary PK 6 2021   grade_8                                                   0.0                                             0
2736640 HI     school 1500030 1   Hawaii Department of Education 150003000027 351 de Silva Elem   Regular School No Elementary PK 6 2019   grade_8                                                   0.0                                             0
2781690 HI     school 1500030 1   Hawaii Department of Education 150003000027 351 de Silva Elem   Regular School No Elementary PK 6 2018   grade_8                                                   0.0                                             0
2430834 HI     school 1500030 1   Hawaii Department of Education 150003000179 153 Wilson Elem   Regular School No Elementary PK 5 2020   grade_8                                                   0.0                                             0
2455523 HI     school 1500030 1   Hawaii Department of Education 150003000179 153 Wilson Elem   Regular School No Elementary PK 5 2021   grade_8                                                   0.0                                             0
2736496 HI     school 1500030 1   Hawaii Department of Education 150003000179 153 Wilson Elem   Regular School No Elementary PK 5 2019   grade_8                                                   0.0                                             0
2781546 HI     school 1500030 1   Hawaii Department of Education 150003000179 153 Wilson Elem   Regular School No Elementary PK 5 2018   grade_8                                                   0.0                                             0
2431065 HI     school 1500030 1   Hawaii Department of Education 150003000094 463 Wilcox Elem   Regular School No Elementary PK 5 2020   grade_8                                                   0.0                                             0
2455755 HI     school 1500030 1   Hawaii Department of Education 150003000094 463 Wilcox Elem   Regular School No Elementary PK 5 2021   grade_8                                                   0.0                                             0
2736727 HI     school 1500030 1   Hawaii Department of Education 150003000094 463 Wilcox Elem   Regular School No Elementary PK 5 2019   grade_8                                                   0.0                                             0
2781777 HI     school 1500030 1   Hawaii Department of Education 150003000094 463 Wilcox Elem   Regular School No Elementary PK 5 2018   grade_8                                                   0.0                                             0
2430904 HI     school 1500030 1   Hawaii Department of Education 150003000137 237 Wheeler Middle   Regular School No Middle 06 8 2020   grade_8                                                   202.0                                             202
2455593 HI     school 1500030 1   Hawaii Department of Education 150003000137 237 Wheeler Middle   Regular School No Middle 06 8 2021   grade_8                                                   203.0                                             203
2736566 HI     school 1500030 1   Hawaii Department of Education 150003000137 237 Wheeler Middle   Regular School No Middle 06 8 2019   grade_8                                                   203.0                                             203
2781616 HI     school 1500030 1   Hawaii Department of Education 150003000137 237 Wheeler Middle   Regular School No Middle 06 8 2018   grade_8                                                   216.0                                             216
2430903 HI     school 1500030 1   Hawaii Department of Education 150003000138 236 Wheeler Elem   Regular School No Elementary PK 5 2020   grade_8                                                   0.0                                             0
2455592 HI     school 1500030 1   Hawaii Department of Education 150003000138 236 Wheeler Elem   Regular School No Elementary PK 5 2021   grade_8                                                   0.0                                             0
2736565 HI     school 1500030 1   Hawaii Department of Education 150003000138 236 Wheeler Elem   Regular School No Elementary PK 5 2019   grade_8                                                   0.0                                             0
2781615 HI     school 1500030 1   Hawaii Department of Education 150003000138 236 Wheeler Elem   Regular School No Elementary PK 5 2018   grade_8                                                   0.0                                             0
2431102 HI     school 1500030 1   Hawaii Department of Education 150003000265 399 West Hawaii Explorations PCS charter Regular School Yes High 06 12 2020   grade_8                                                   38.0                                             38
2455792 HI     school 1500030 1   Hawaii Department of Education 150003000265 399 West Hawaii Explorations PCS charter Regular School Yes High 06 12 2021   grade_8                                                   36.0                                             36
2736736 HI     school 1500030 1   Hawaii Department of Education 150003000265 399 West Hawaii Explorations PCS charter Regular School Yes High 06 12 2019   grade_8                                                   34.0                                             34
2781813 HI     school 1500030 1   Hawaii Department of Education 150003000265 399 West Hawaii Explorations PCS charter Regular School Yes High 06 12 2018   grade_8                                                   35.0                                             35
2430884 HI     school 1500030 1   Hawaii Department of Education 150003000139 235 Webling Elem   Regular School No Elementary PK 6 2020   grade_8                                                   0.0                                             0
2455573 HI     school 1500030 1   Hawaii Department of Education 150003000139 235 Webling Elem   Regular School No Elementary PK 6 2021   grade_8                                                   0.0                                             0
2736546 HI     school 1500030 1   Hawaii Department of Education 150003000139 235 Webling Elem   Regular School No Elementary PK 6 2019   grade_8                                                   0.0                                             0
2781596 HI     school 1500030 1   Hawaii Department of Education 150003000139 235 Webling Elem   Regular School No Elementary PK 6 2018   grade_8                                                   0.0                                             0
2430862 HI     school 1500030 1   Hawaii Department of Education 150003000180 152 Washington Middle   Regular School No Middle 06 8 2020   grade_8                                                   213.0                                             213
2455551 HI     school 1500030 1   Hawaii Department of Education 150003000180 152 Washington Middle   Regular School No Middle 06 8 2021   grade_8                                                   218.0                                             218
2736524 HI     school 1500030 1   Hawaii Department of Education 150003000180 152 Washington Middle   Regular School No Middle 06 8 2019   grade_8                                                   236.0                                             236
2781574 HI     school 1500030 1   Hawaii Department of Education 150003000180 152 Washington Middle   Regular School No Middle 06 8 2018   grade_8                                                   247.0                                             247
2430947 HI     school 1500030 1   Hawaii Department of Education 150003000158 278 Waipahu Int   Regular School No Middle 07 8 2020   grade_8                                                   578.0                                             578
2455637 HI     school 1500030 1   Hawaii Department of Education 150003000158 278 Waipahu Int   Regular School No Middle 07 8 2021   grade_8                                                   632.0                                             632
2736609 HI     school 1500030 1   Hawaii Department of Education 150003000158 278 Waipahu Int   Regular School No Middle 07 8 2019   grade_8                                                   560.0                                             560
2781659 HI     school 1500030 1   Hawaii Department of Education 150003000158 278 Waipahu Int   Regular School No Middle 07 8 2018   grade_8                                                   570.0                                             570
2430946 HI     school 1500030 1   Hawaii Department of Education 150003000161 277 Waipahu High   Regular School No High 09 12 2020   grade_8                                                   0.0                                             0
2455636 HI     school 1500030 1   Hawaii Department of Education 150003000161 277 Waipahu High   Regular School No High 09 12 2021   grade_8                                                   0.0                                             0
2736608 HI     school 1500030 1   Hawaii Department of Education 150003000161 277 Waipahu High   Regular School No High 09 12 2019   grade_8                                                   0.0                                             0
2781658 HI     school 1500030 1   Hawaii Department of Education 150003000161 277 Waipahu High   Regular School No High 09 12 2018   grade_8                                                   0.0                                             0
2430945 HI     school 1500030 1   Hawaii Department of Education 150003000159 274 Waipahu Elem   Regular School No Elementary PK 6 2020   grade_8                                                   0.0                                             0
2455635 HI     school 1500030 1   Hawaii Department of Education 150003000159 274 Waipahu Elem   Regular School No Elementary PK 6 2021   grade_8                                                   0.0                                             0
2736607 HI     school 1500030 1   Hawaii Department of Education 150003000159 274 Waipahu Elem   Regular School No Elementary PK 6 2019   grade_8                                                   0.0                                             0
2781657 HI     school 1500030 1   Hawaii Department of Education 150003000159 274 Waipahu Elem   Regular School No Elementary PK 6 2018   grade_8                                                   0.0                                             0
2431101 HI     school 1500030 1   Hawaii Department of Education 150003000268 394 Waimea Middle PCCS charter Regular School Yes Middle 06 8 2020   grade_8                                                   73.0                                             73
2455791 HI     school 1500030 1   Hawaii Department of Education 150003000268 394 Waimea Middle PCCS charter Regular School Yes Middle 06 8 2021   grade_8                                                   63.0                                             63
2736732 HI     school 1500030 1   Hawaii Department of Education 150003000268 394 Waimea Middle PCCS charter Regular School Yes Middle 06 8 2019   grade_8                                                   72.0                                             72
2781812 HI     school 1500030 1   Hawaii Department of Education 150003000268 394 Waimea Middle PCCS charter Regular School Yes Middle 06 8 2018   grade_8                                                   74.0                                             74
2431064 HI     school 1500030 1   Hawaii Department of Education 150003000093 462 Waimea High   Regular School No High 09 12 2020   grade_8                                                   0.0                                             0
2455754 HI     school 1500030 1   Hawaii Department of Education 150003000093 462 Waimea High   Regular School No High 09 12 2021   grade_8                                                   0.0                                             0
2736726 HI     school 1500030 1   Hawaii Department of Education 150003000093 462 Waimea High   Regular School No High 09 12 2019   grade_8                                                   0.0                                             0
2781776 HI     school 1500030 1   Hawaii Department of Education 150003000093 462 Waimea High   Regular School No High 09 12 2018   grade_8                                                   0.0                                             0
2431009 HI     school 1500030 1   Hawaii Department of Education 150003000055 387 Waimea Elem   Regular School No Elementary PK 5 2020   grade_8                                                   0.0                                             0
2455699 HI     school 1500030 1   Hawaii Department of Education 150003000055 387 Waimea Elem   Regular School No Elementary PK 5 2021   grade_8                                                   0.0                                             0
2736671 HI     school 1500030 1   Hawaii Department of Education 150003000055 387 Waimea Elem   Regular School No Elementary PK 5 2019   grade_8                                                   0.0                                             0
2781721 HI     school 1500030 1   Hawaii Department of Education 150003000055 387 Waimea Elem   Regular School No Elementary PK 5 2018   grade_8                                                   0.0                                             0
2431063 HI     school 1500030 1   Hawaii Department of Education 150003000092 464 Waimea Canyon Middle   Regular School No Middle 06 8 2020   grade_8                                                   139.0                                             139
2455753 HI     school 1500030 1   Hawaii Department of Education 150003000092 464 Waimea Canyon Middle   Regular School No Middle 06 8 2021   grade_8                                                   166.0                                             166
2736725 HI     school 1500030 1   Hawaii Department of Education 150003000092 464 Waimea Canyon Middle   Regular School No Middle 06 8 2019   grade_8                                                   135.0                                             135
2781775 HI     school 1500030 1   Hawaii Department of Education 150003000092 464 Waimea Canyon Middle   Regular School No Middle 06 8 2018   grade_8                                                   123.0                                             123
2430977 HI     school 1500030 1   Hawaii Department of Education 150003000026 327 Waimanalo El & Int   Regular School No Elementary PK 8 2020   grade_8                                                   65.0                                             65
2455667 HI     school 1500030 1   Hawaii Department of Education 150003000026 327 Waimanalo El & Int   Regular School No Elementary PK 8 2021   grade_8                                                   59.0                                             59
2736639 HI     school 1500030 1   Hawaii Department of Education 150003000026 327 Waimanalo El & Int   Regular School No Elementary PK 8 2019   grade_8                                                   60.0                                             60
2781689 HI     school 1500030 1   Hawaii Department of Education 150003000026 327 Waimanalo El & Int   Regular School No Elementary PK 8 2018   grade_8                                                   71.0                                             71
2430883 HI     school 1500030 1   Hawaii Department of Education 150003000140 233 Waimalu Elem   Regular School No Elementary PK 6 2020   grade_8                                                   0.0                                             0
2455572 HI     school 1500030 1   Hawaii Department of Education 150003000140 233 Waimalu Elem   Regular School No Elementary PK 6 2021   grade_8                                                   0.0                                             0
2736545 HI     school 1500030 1   Hawaii Department of Education 150003000140 233 Waimalu Elem   Regular School No Elementary PK 6 2019   grade_8                                                   0.0                                             0
2781595 HI     school 1500030 1   Hawaii Department of Education 150003000140 233 Waimalu Elem   Regular School No Elementary PK 6 2018   grade_8                                                   0.0                                             0
2431038 HI     school 1500030 1   Hawaii Department of Education 150003000080 425 Wailuku Elem   Regular School No Elementary PK 5 2020   grade_8                                                   0.0                                             0
2455728 HI     school 1500030 1   Hawaii Department of Education 150003000080 425 Wailuku Elem   Regular School No Elementary PK 5 2021   grade_8                                                   0.0                                             0
2736700 HI     school 1500030 1   Hawaii Department of Education 150003000080 425 Wailuku Elem   Regular School No Elementary PK 5 2019   grade_8                                                   0.0                                             0
2781750 HI     school 1500030 1   Hawaii Department of Education 150003000080 425 Wailuku Elem   Regular School No Elementary PK 5 2018   grade_8                                                   0.0                                             0
2431008 HI     school 1500030 1   Hawaii Department of Education 150003000247 393 Waikoloa El & Middle   Regular School No Elementary PK 8 2020   grade_8                                                   71.0                                             71
2455698 HI     school 1500030 1   Hawaii Department of Education 150003000247 393 Waikoloa El & Middle   Regular School No Elementary PK 8 2021   grade_8                                                   62.0                                             62
2736670 HI     school 1500030 1   Hawaii Department of Education 150003000247 393 Waikoloa El & Middle   Regular School No Elementary PK 8 2019   grade_8                                                   69.0                                             69
2781720 HI     school 1500030 1   Hawaii Department of Education 150003000247 393 Waikoloa El & Middle   Regular School No Elementary PK 8 2018   grade_8                                                   55.0                                             55
2430833 HI     school 1500030 1   Hawaii Department of Education 150003000182 150 Waikiki Elem   Regular School No Elementary PK 5 2020   grade_8                                                   0.0                                             0
2455522 HI     school 1500030 1   Hawaii Department of Education 150003000182 150 Waikiki Elem   Regular School No Elementary PK 5 2021   grade_8                                                   0.0                                             0
2736495 HI     school 1500030 1   Hawaii Department of Education 150003000182 150 Waikiki Elem   Regular School No Elementary PK 5 2019   grade_8                                                   0.0                                             0
2781545 HI     school 1500030 1   Hawaii Department of Education 150003000182 150 Waikiki Elem   Regular School No Elementary PK 5 2018   grade_8                                                   0.0                                             0
2430944 HI     school 1500030 1   Hawaii Department of Education 150003000257 290 Waikele Elem   Regular School No Elementary PK 6 2020   grade_8                                                   0.0                                             0
2455634 HI     school 1500030 1   Hawaii Department of Education 150003000257 290 Waikele Elem   Regular School No Elementary PK 6 2021   grade_8                                                   0.0                                             0
2736606 HI     school 1500030 1   Hawaii Department of Education 150003000257 290 Waikele Elem   Regular School No Elementary PK 6 2019   grade_8                                                   0.0                                             0
2781656 HI     school 1500030 1   Hawaii Department of Education 150003000257 290 Waikele Elem   Regular School No Elementary PK 6 2018   grade_8                                                   0.0                                             0
2431037 HI     school 1500030 1   Hawaii Department of Education 150003000079 424 Waihee Elem   Regular School No Elementary PK 5 2020   grade_8                                                   0.0                                             0
2455727 HI     school 1500030 1   Hawaii Department of Education 150003000079 424 Waihee Elem   Regular School No Elementary PK 5 2021   grade_8                                                   0.0                                             0
2736699 HI     school 1500030 1   Hawaii Department of Education 150003000079 424 Waihee Elem   Regular School No Elementary PK 5 2019   grade_8                                                   0.0                                             0
2781749 HI     school 1500030 1   Hawaii Department of Education 150003000079 424 Waihee Elem   Regular School No Elementary PK 5 2018   grade_8                                                   0.0                                             0
2430943 HI     school 1500030 1   Hawaii Department of Education 150003000109 288 Waiau Elem   Regular School No Elementary PK 6 2020   grade_8                                                   0.0                                             0
2455633 HI     school 1500030 1   Hawaii Department of Education 150003000109 288 Waiau Elem   Regular School No Elementary PK 6 2021   grade_8                                                   0.0                                             0
2736605 HI     school 1500030 1   Hawaii Department of Education 150003000109 288 Waiau Elem   Regular School No Elementary PK 6 2019   grade_8                                                   0.0                                             0
2781655 HI     school 1500030 1   Hawaii Department of Education 150003000109 288 Waiau Elem   Regular School No Elementary PK 6 2018   grade_8                                                   0.0                                             0
2430930 HI     school 1500030 1   Hawaii Department of Education 150003000229 273 Waianae Int   Regular School No Middle 07 8 2020   grade_8                                                   394.0                                             394
2455620 HI     school 1500030 1   Hawaii Department of Education 150003000229 273 Waianae Int   Regular School No Middle 07 8 2021   grade_8                                                   369.0                                             369
2736592 HI     school 1500030 1   Hawaii Department of Education 150003000229 273 Waianae Int   Regular School No Middle 07 8 2019   grade_8                                                   404.0                                             404
2781642 HI     school 1500030 1   Hawaii Department of Education 150003000229 273 Waianae Int   Regular School No Middle 07 8 2018   grade_8                                                   378.0                                             378
2430929 HI     school 1500030 1   Hawaii Department of Education 150003000110 272 Waianae High   Regular School No High 09 12 2020   grade_8                                                   0.0                                             0
2455619 HI     school 1500030 1   Hawaii Department of Education 150003000110 272 Waianae High   Regular School No High 09 12 2021   grade_8                                                   0.0                                             0
2736591 HI     school 1500030 1   Hawaii Department of Education 150003000110 272 Waianae High   Regular School No High 09 12 2019   grade_8                                                   0.0                                             0
2781641 HI     school 1500030 1   Hawaii Department of Education 150003000110 272 Waianae High   Regular School No High 09 12 2018   grade_8                                                   0.0                                             0
2430928 HI     school 1500030 1   Hawaii Department of Education 150003000111 270 Waianae Elem   Regular School No Elementary PK 6 2020   grade_8                                                   0.0                                             0