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
281666 HI     school 1500030 1   Hawaii Department of Education 150003000092 464 WAIMEA CANYON   Regular School No 2 06 8 2015   pk_12_total                                               43.0   385.0                                         43   385
281673 HI     school 1500030 1   Hawaii Department of Education 150003000268 394 WAIMEA MID-PCCS charter Regular School Yes 2 06 8 2015   pk_12_total                                               31.0   288.0                                         31   288
281677 HI     school 1500030 1   Hawaii Department of Education 150003000265 399 WEST HI EXPLOR ACAD-PCS charter Regular School Yes 4 06 12 2015   pk_12_total                                               14.0   248.0                                         14   248
281702 HI     school 1500030 1   Hawaii Department of Education 150003000298 567 SEEQS charter Regular School Yes 2 06 8 2015   pk_12_total                                               19.0   126.0                                         19   126
2432569 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 Dole Middle   Regular School No Middle 06 8 2020   pk_12_total                                               78.0   710.0                                         78   710
2432576 HI     school 1500030 1   Hawaii Department of Education 150003000211 116 Kaimuki Middle   Regular School No Middle 06 8 2020   pk_12_total                                               85.0   1059.0                                         85   1059
2432578 HI     school 1500030 1   Hawaii Department of Education 150003000164 118 Kalakaua Middle   Regular School No Middle 06 8 2020   pk_12_total                                               64.0   1065.0                                         64   1065
2432589 HI     school 1500030 1   Hawaii Department of Education 150003000192 139 Niu Valley Middle   Regular School No Middle 06 8 2020   pk_12_total                                               65.0   821.0                                         65   821
2432596 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 Central Middle   Regular School No Middle 06 8 2020   pk_12_total                                               48.0   399.0                                         48   399
2432598 HI     school 1500030 1   Hawaii Department of Education 150003000218 110 Jarrett Middle   Regular School No Middle 06 8 2020   pk_12_total                                               42.0   274.0                                         42   274
2432604 HI     school 1500030 1   Hawaii Department of Education 150003000205 126 Kawananakoa Middle   Regular School No Middle 06 8 2020   pk_12_total                                               59.0   739.0                                         59   739
2432619 HI     school 1500030 1   Hawaii Department of Education 150003000184 148 Stevenson Middle   Regular School No Middle 06 8 2020   pk_12_total                                               59.0   688.0                                         59   688
2432620 HI     school 1500030 1   Hawaii Department of Education 150003000180 152 Washington Middle   Regular School No Middle 06 8 2020   pk_12_total                                               86.0   763.0                                         86   763
2432653 HI     school 1500030 1   Hawaii Department of Education 150003000256 238 Mililani Middle   Regular School No Middle 06 8 2020   pk_12_total                                               182.0   1875.0                                         182   1875
2432658 HI     school 1500030 1   Hawaii Department of Education 150003000143 230 Wahiawa Middle   Regular School No Middle 06 8 2020   pk_12_total                                               126.0   821.0                                         126   821
2432662 HI     school 1500030 1   Hawaii Department of Education 150003000137 237 Wheeler Middle   Regular School No Middle 06 8 2020   pk_12_total                                               77.0   780.0                                         77   780
2432667 HI     school 1500030 1   Hawaii Department of Education 150003000296 296 Ewa Makai Middle   Regular School No Middle 06 8 2020   pk_12_total                                               91.0   1390.0                                         91   1390
2432675 HI     school 1500030 1   Hawaii Department of Education 150003000259 291 Kapolei Middle   Regular School No Middle 06 8 2020   pk_12_total                                               157.0   1487.0                                         157   1487
2432747 HI     school 1500030 1   Hawaii Department of Education 150003000053 385 Waiakea Int   Regular School No Middle 06 8 2020   pk_12_total                                               108.0   903.0                                         108   903
2432758 HI     school 1500030 1   Hawaii Department of Education 150003000235 390 Kealakehe Int   Regular School No Middle 06 8 2020   pk_12_total                                               53.0   711.0                                         53   711
2432761 HI     school 1500030 1   Hawaii Department of Education 150003000267 366 Kohala Middle   Regular School No Middle 06 8 2020   pk_12_total                                               25.0   190.0                                         25   190
2432764 HI     school 1500030 1   Hawaii Department of Education 150003000252 376 Konawaena Middle   Regular School No Middle 06 8 2020   pk_12_total                                               53.0   715.0                                         53   715
2432771 HI     school 1500030 1   Hawaii Department of Education 150003000040 370 Keaau Middle   Regular School No Middle 06 8 2020   pk_12_total                                               103.0   756.0                                         103   756
2432779 HI     school 1500030 1   Hawaii Department of Education 150003000059 404 Iao Int   Regular School No Middle 06 8 2020   pk_12_total                                               101.0   1004.0                                         101   1004
2432781 HI     school 1500030 1   Hawaii Department of Education 150003000233 420 Kalama Int   Regular School No Middle 06 8 2020   pk_12_total                                               150.0   953.0                                         150   953
2432787 HI     school 1500030 1   Hawaii Department of Education 150003000238 430 Lokelani Int   Regular School No Middle 06 8 2020   pk_12_total                                               61.0   540.0                                         61   540
2432790 HI     school 1500030 1   Hawaii Department of Education 150003000241 428 Maui Waena Int   Regular School No Middle 06 8 2020   pk_12_total                                               97.0   1162.0                                         97   1162
2432801 HI     school 1500030 1   Hawaii Department of Education 150003000068 413 Lahaina Int   Regular School No Middle 06 8 2020   pk_12_total                                               58.0   732.0                                         58   732
2432811 HI     school 1500030 1   Hawaii Department of Education 150003000266 448 Kamakahelei Middle   Regular School No Middle 06 8 2020   pk_12_total                                               81.0   964.0                                         81   964
2432814 HI     school 1500030 1   Hawaii Department of Education 150003000255 447 Kapaa Middle   Regular School No Middle 06 8 2020   pk_12_total                                               74.0   602.0                                         74   602
2432821 HI     school 1500030 1   Hawaii Department of Education 150003000092 464 Waimea Canyon Middle   Regular School No Middle 06 8 2020   pk_12_total                                               42.0   502.0                                         42   502
2432826 HI     school 1500030 1   Hawaii Department of Education 150003000305 568 DreamHouse Ewa Beach charter Regular School Yes Middle 06 6 2020   pk_12_total                                               8.0   85.0                                         8   85
2432854 HI     school 1500030 1   Hawaii Department of Education 150003000298 567 SEEQS PCS charter Regular School Yes Middle 06 8 2020   pk_12_total                                               28.0   189.0                                         28   189
2432859 HI     school 1500030 1   Hawaii Department of Education 150003000268 394 Waimea Middle PCCS charter Regular School Yes Middle 06 8 2020   pk_12_total                                               34.0   256.0                                         34   256
2432860 HI     school 1500030 1   Hawaii Department of Education 150003000265 399 West Hawaii Explorations PCS charter Regular School Yes High 06 12 2020   pk_12_total                                               17.0   280.0                                         17   280
2457264 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 Dole Middle   Regular School No Middle 06 8 2021   pk_12_total                                               78.0   580.0                                         78   580
2457271 HI     school 1500030 1   Hawaii Department of Education 150003000211 116 Kaimuki Middle   Regular School No Middle 06 8 2021   pk_12_total                                               73.0   978.0                                         73   978
2457273 HI     school 1500030 1   Hawaii Department of Education 150003000164 118 Kalakaua Middle   Regular School No Middle 06 8 2021   pk_12_total                                               56.0   1004.0                                         56   1004
2457284 HI     school 1500030 1   Hawaii Department of Education 150003000192 139 Niu Valley Middle   Regular School No Middle 06 8 2021   pk_12_total                                               63.0   782.0                                         63   782
2457291 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 Central Middle   Regular School No Middle 06 8 2021   pk_12_total                                               45.0   321.0                                         45   321
2457293 HI     school 1500030 1   Hawaii Department of Education 150003000218 110 Jarrett Middle   Regular School No Middle 06 8 2021   pk_12_total                                               39.0   272.0                                         39   272
2457299 HI     school 1500030 1   Hawaii Department of Education 150003000205 126 Kawananakoa Middle   Regular School No Middle 06 8 2021   pk_12_total                                               64.0   623.0                                         64   623
2457314 HI     school 1500030 1   Hawaii Department of Education 150003000184 148 Stevenson Middle   Regular School No Middle 06 8 2021   pk_12_total                                               55.0   643.0                                         55   643
2457315 HI     school 1500030 1   Hawaii Department of Education 150003000180 152 Washington Middle   Regular School No Middle 06 8 2021   pk_12_total                                               83.0   659.0                                         83   659
2457348 HI     school 1500030 1   Hawaii Department of Education 150003000256 238 Mililani Middle   Regular School No Middle 06 8 2021   pk_12_total                                               173.0   1684.0                                         173   1684
2457353 HI     school 1500030 1   Hawaii Department of Education 150003000143 230 Wahiawa Middle   Regular School No Middle 06 8 2021   pk_12_total                                               118.0   740.0                                         118   740
2457357 HI     school 1500030 1   Hawaii Department of Education 150003000137 237 Wheeler Middle   Regular School No Middle 06 8 2021   pk_12_total                                               70.0   705.0                                         70   705
2457362 HI     school 1500030 1   Hawaii Department of Education 150003000296 296 Ewa Makai Middle   Regular School No Middle 06 8 2021   pk_12_total                                               86.0   1262.0                                         86   1262
2457364 HI     school 1500030 1   Hawaii Department of Education 150003000306 297 Honouliuli Middle   Regular School No Middle 06 6 2021   pk_12_total                                               22.0   184.0                                         22   184
2457371 HI     school 1500030 1   Hawaii Department of Education 150003000259 291 Kapolei Middle   Regular School No Middle 06 8 2021   pk_12_total                                               137.0   1151.0                                         137   1151
2457443 HI     school 1500030 1   Hawaii Department of Education 150003000053 385 Waiakea Int   Regular School No Middle 06 8 2021   pk_12_total                                               105.0   805.0                                         105   805
2457454 HI     school 1500030 1   Hawaii Department of Education 150003000235 390 Kealakehe Int   Regular School No Middle 06 8 2021   pk_12_total                                               48.0   676.0                                         48   676
2457457 HI     school 1500030 1   Hawaii Department of Education 150003000267 366 Kohala Middle   Regular School No Middle 06 8 2021   pk_12_total                                               25.0   172.0                                         25   172
2457460 HI     school 1500030 1   Hawaii Department of Education 150003000252 376 Konawaena Middle   Regular School No Middle 06 8 2021   pk_12_total                                               49.0   651.0                                         49   651
2457467 HI     school 1500030 1   Hawaii Department of Education 150003000040 370 Keaau Middle   Regular School No Middle 06 8 2021   pk_12_total                                               101.0   708.0                                         101   708
2457475 HI     school 1500030 1   Hawaii Department of Education 150003000059 404 Iao Int   Regular School No Middle 06 8 2021   pk_12_total                                               82.0   889.0                                         82   889
2457477 HI     school 1500030 1   Hawaii Department of Education 150003000233 420 Kalama Int   Regular School No Middle 06 8 2021   pk_12_total                                               140.0   899.0                                         140   899
2457483 HI     school 1500030 1   Hawaii Department of Education 150003000238 430 Lokelani Int   Regular School No Middle 06 8 2021   pk_12_total                                               55.0   480.0                                         55   480
2457486 HI     school 1500030 1   Hawaii Department of Education 150003000241 428 Maui Waena Int   Regular School No Middle 06 8 2021   pk_12_total                                               104.0   1100.0                                         104   1100
2457497 HI     school 1500030 1   Hawaii Department of Education 150003000068 413 Lahaina Int   Regular School No Middle 06 8 2021   pk_12_total                                               69.0   704.0                                         69   704
2457507 HI     school 1500030 1   Hawaii Department of Education 150003000266 448 Kamakahelei Middle   Regular School No Middle 06 8 2021   pk_12_total                                               93.0   909.0                                         93   909
2457510 HI     school 1500030 1   Hawaii Department of Education 150003000255 447 Kapaa Middle   Regular School No Middle 06 8 2021   pk_12_total                                               74.0   591.0                                         74   591
2457517 HI     school 1500030 1   Hawaii Department of Education 150003000092 464 Waimea Canyon Middle   Regular School No Middle 06 8 2021   pk_12_total                                               45.0   500.0                                         45   500
2457522 HI     school 1500030 1   Hawaii Department of Education 150003000305 568 DreamHouse Ewa Beach charter Regular School Yes Middle 06 7 2021   pk_12_total                                               18.0   192.0                                         18   192
2457550 HI     school 1500030 1   Hawaii Department of Education 150003000298 567 SEEQS PCS charter Regular School Yes Middle 06 8 2021   pk_12_total                                               23.0   174.0                                         23   174
2457555 HI     school 1500030 1   Hawaii Department of Education 150003000268 394 Waimea Middle PCCS charter Regular School Yes Middle 06 8 2021   pk_12_total                                               30.0   234.0                                         30   234
2457556 HI     school 1500030 1   Hawaii Department of Education 150003000265 399 West Hawaii Explorations PCS charter Regular School Yes High 06 12 2021   pk_12_total                                               11.0   275.0                                         11   275
2738225 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 Dole Middle   Regular School No Middle 06 8 2019   pk_12_total                                               77.0   765.0                                         77   765
2738232 HI     school 1500030 1   Hawaii Department of Education 150003000211 116 Kaimuki Middle   Regular School No Middle 06 8 2019   pk_12_total                                               82.0   989.0                                         82   989
2738234 HI     school 1500030 1   Hawaii Department of Education 150003000164 118 Kalakaua Middle   Regular School No Middle 06 8 2019   pk_12_total                                               75.0   1090.0                                         75   1090
2738245 HI     school 1500030 1   Hawaii Department of Education 150003000192 139 Niu Valley Middle   Regular School No Middle 06 8 2019   pk_12_total                                               75.0   858.0                                         75   858
2738252 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 Central Middle   Regular School No Middle 06 8 2019   pk_12_total                                               44.0   414.0                                         44   414
2738254 HI     school 1500030 1   Hawaii Department of Education 150003000218 110 Jarrett Middle   Regular School No Middle 06 8 2019   pk_12_total                                               45.0   275.0                                         45   275
2738260 HI     school 1500030 1   Hawaii Department of Education 150003000205 126 Kawananakoa Middle   Regular School No Middle 06 8 2019   pk_12_total                                               63.0   710.0                                         63   710
2738275 HI     school 1500030 1   Hawaii Department of Education 150003000184 148 Stevenson Middle   Regular School No Middle 06 8 2019   pk_12_total                                               60.0   660.0                                         60   660
2738276 HI     school 1500030 1   Hawaii Department of Education 150003000180 152 Washington Middle   Regular School No Middle 06 8 2019   pk_12_total                                               84.0   785.0                                         84   785
2738309 HI     school 1500030 1   Hawaii Department of Education 150003000256 238 Mililani Middle   Regular School No Middle 06 8 2019   pk_12_total                                               170.0   1886.0                                         170   1886
2738314 HI     school 1500030 1   Hawaii Department of Education 150003000143 230 Wahiawa Middle   Regular School No Middle 06 8 2019   pk_12_total                                               122.0   826.0                                         122   826
2738318 HI     school 1500030 1   Hawaii Department of Education 150003000137 237 Wheeler Middle   Regular School No Middle 06 8 2019   pk_12_total                                               63.0   800.0                                         63   800
2738331 HI     school 1500030 1   Hawaii Department of Education 150003000259 291 Kapolei Middle   Regular School No Middle 06 8 2019   pk_12_total                                               164.0   1526.0                                         164   1526
2738403 HI     school 1500030 1   Hawaii Department of Education 150003000053 385 Waiakea Int   Regular School No Middle 06 8 2019   pk_12_total                                               93.0   891.0                                         93   891
2738414 HI     school 1500030 1   Hawaii Department of Education 150003000235 390 Kealakehe Int   Regular School No Middle 06 8 2019   pk_12_total                                               61.0   689.0                                         61   689
2738417 HI     school 1500030 1   Hawaii Department of Education 150003000267 366 Kohala Middle   Regular School No Middle 06 8 2019   pk_12_total                                               25.0   183.0                                         25   183
2738420 HI     school 1500030 1   Hawaii Department of Education 150003000252 376 Konawaena Middle   Regular School No Middle 06 8 2019   pk_12_total                                               54.0   660.0                                         54   660
2738427 HI     school 1500030 1   Hawaii Department of Education 150003000040 370 Keaau Middle   Regular School No Middle 06 8 2019   pk_12_total                                               97.0   712.0                                         97   712
2738435 HI     school 1500030 1   Hawaii Department of Education 150003000059 404 Iao Int   Regular School No Middle 06 8 2019   pk_12_total                                               90.0   987.0                                         90   987
2738437 HI     school 1500030 1   Hawaii Department of Education 150003000233 420 Kalama Int   Regular School No Middle 06 8 2019   pk_12_total                                               136.0   900.0                                         136   900
2738443 HI     school 1500030 1   Hawaii Department of Education 150003000238 430 Lokelani Int   Regular School No Middle 06 8 2019   pk_12_total                                               60.0   551.0                                         60   551
2738446 HI     school 1500030 1   Hawaii Department of Education 150003000241 428 Maui Waena Int   Regular School No Middle 06 8 2019   pk_12_total                                               106.0   1155.0                                         106   1155
2738457 HI     school 1500030 1   Hawaii Department of Education 150003000068 413 Lahaina Int   Regular School No Middle 06 8 2019   pk_12_total                                               64.0   760.0                                         64   760
2738467 HI     school 1500030 1   Hawaii Department of Education 150003000266 448 Kamakahelei Middle   Regular School No Middle 06 8 2019   pk_12_total                                               87.0   987.0                                         87   987
2738470 HI     school 1500030 1   Hawaii Department of Education 150003000255 447 Kapaa Middle   Regular School No Middle 06 8 2019   pk_12_total                                               70.0   607.0                                         70   607
2738477 HI     school 1500030 1   Hawaii Department of Education 150003000092 464 Waimea Canyon Middle   Regular School No Middle 06 8 2019   pk_12_total                                               51.0   501.0                                         51   501
2738484 HI     school 1500030 1   Hawaii Department of Education 150003000268 394 Waimea Middle PCCS charter Regular School Yes Middle 06 8 2019   pk_12_total                                               33.0   259.0                                         33   259
2738488 HI     school 1500030 1   Hawaii Department of Education 150003000265 399 West Hawaii Explorations PCS charter Regular School Yes High 06 12 2019   pk_12_total                                               17.0   266.0                                         17   266
2738515 HI     school 1500030 1   Hawaii Department of Education 150003000298 567 SEEQS PCS charter Regular School Yes Middle 06 8 2019   pk_12_total                                               24.0   185.0                                         24   185
2783275 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 Dole Middle   Regular School No Middle 06 8 2018   pk_12_total                                               77.0   784.0                                         77   784
2783282 HI     school 1500030 1   Hawaii Department of Education 150003000211 116 Kaimuki Middle   Regular School No Middle 06 8 2018   pk_12_total                                               85.0   988.0                                         85   988
2783284 HI     school 1500030 1   Hawaii Department of Education 150003000164 118 Kalakaua Middle   Regular School No Middle 06 8 2018   pk_12_total                                               66.0   1075.0                                         66   1075
2783295 HI     school 1500030 1   Hawaii Department of Education 150003000192 139 Niu Valley Middle   Regular School No Middle 06 8 2018   pk_12_total                                               83.0   868.0                                         83   868
2783302 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 Central Middle   Regular School No Middle 06 8 2018   pk_12_total                                               41.0   391.0                                         41   391