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
109969 HI     school 1500030 1   Hawaii Department of Education 150003000301 552 KAU LEARNING ACAD-PCS charter Regular School Yes 1 03 6 2016   grade_8                                                   0.0                                             0
128972 HI     school 1500030 1   Hawaii Department of Education 150003000301 552 KAU LEARNING ACAD-PCS charter Regular School Yes Elementary 03 7 2017   grade_8                                                   0.0                                             0
2781793 HI     school 1500030 1   Hawaii Department of Education 150003000301 552 Kau Learning Academy charter Regular School Yes Middle 03 7 2018   grade_8                                                   0.0                                             0
109958 HI     school 1500030 1   Hawaii Department of Education 150003000275 546 HAKIPU'U LEARNING CTR-PCS charter Regular School Yes 4 04 12 2016   grade_8                                                   9.0                                             9
109959 HI     school 1500030 1   Hawaii Department of Education 150003000270 540 HALAU KU MANA-PCS charter Regular School Yes 4 04 12 2016   grade_8                                                   16.0                                             16
128961 HI     school 1500030 1   Hawaii Department of Education 150003000275 546 HAKIPU'U LEARNING CTR-PCS charter Regular School Yes Other 04 12 2017   grade_8                                                   3.0                                             3
128962 HI     school 1500030 1   Hawaii Department of Education 150003000270 540 HALAU KU MANA-PCS charter Regular School Yes Other 04 12 2017   grade_8                                                   15.0                                             15
279946 HI     school 1500030 1   Hawaii Department of Education 150003000270 540 HALAU KU MANA-PCS charter Regular School Yes 4 04 12 2015   grade_8                                                   16.0                                             16
279952 HI     school 1500030 1   Hawaii Department of Education 150003000275 546 HAKIPU'U LEARNING CTR-PCS charter Regular School Yes 4 04 12 2015   grade_8                                                   4.0                                             4
2431069 HI     school 1500030 1   Hawaii Department of Education 150003000275 546 Hakipuu Learning Ctr PCS charter Regular School Yes Other 04 12 2020   grade_8                                                   9.0                                             9
2431070 HI     school 1500030 1   Hawaii Department of Education 150003000270 540 Halau Ku Mana NCPCS charter Regular School Yes Other 04 12 2020   grade_8                                                   13.0                                             13
2455760 HI     school 1500030 1   Hawaii Department of Education 150003000270 540 Halau Ku Mana NCPCS charter Regular School Yes Other 04 12 2021   grade_8                                                   13.0                                             13
2736739 HI     school 1500030 1   Hawaii Department of Education 150003000270 540 Halau Ku Mana NCPCS charter Regular School Yes Other 04 12 2019   grade_8                                                   17.0                                             17
2736744 HI     school 1500030 1   Hawaii Department of Education 150003000275 546 Hakipuu Learning Ctr PCS charter Regular School Yes Other 04 12 2019   grade_8                                                   7.0                                             7
2781779 HI     school 1500030 1   Hawaii Department of Education 150003000275 546 Hakipuu Learning Ctr PCS charter Regular School Yes Other 04 12 2018   grade_8                                                   7.0                                             7
2781780 HI     school 1500030 1   Hawaii Department of Education 150003000270 540 Halau Ku Mana NCPCS charter Regular School Yes Other 04 12 2018   grade_8                                                   15.0                                             15
2455759 HI     school 1500030 1   Hawaii Department of Education 150003000275 546 Hakipuu Academy PCS charter Regular School Yes High 05 12 2021   grade_8                                                   8.0                                             8
109701 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 DOLE MID   Regular School No 2 06 8 2016   grade_8                                                   225.0                                             225
109708 HI     school 1500030 1   Hawaii Department of Education 150003000211 116 KAIMUKI MID   Regular School No 2 06 8 2016   grade_8                                                   294.0                                             294
109710 HI     school 1500030 1   Hawaii Department of Education 150003000164 118 KALAKAUA MID   Regular School No 2 06 8 2016   grade_8                                                   298.0                                             298
109721 HI     school 1500030 1   Hawaii Department of Education 150003000192 139 NIU VALLEY MID   Regular School No 2 06 8 2016   grade_8                                                   266.0                                             266
109728 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 CENTRAL MID   Regular School No 2 06 8 2016   grade_8                                                   106.0                                             106
109730 HI     school 1500030 1   Hawaii Department of Education 150003000218 110 JARRETT MID   Regular School No 2 06 8 2016   grade_8                                                   64.0                                             64
109736 HI     school 1500030 1   Hawaii Department of Education 150003000205 126 KAWANANAKOA MID   Regular School No 2 06 8 2016   grade_8                                                   250.0                                             250
109751 HI     school 1500030 1   Hawaii Department of Education 150003000184 148 STEVENSON MID   Regular School No 2 06 8 2016   grade_8                                                   175.0                                             175
109752 HI     school 1500030 1   Hawaii Department of Education 150003000180 152 WASHINGTON MID   Regular School No 2 06 8 2016   grade_8                                                   225.0                                             225
109785 HI     school 1500030 1   Hawaii Department of Education 150003000256 238 MILILANI MID   Regular School No 2 06 8 2016   grade_8                                                   548.0                                             548
109790 HI     school 1500030 1   Hawaii Department of Education 150003000143 230 WAHIAWA MID   Regular School No 2 06 8 2016   grade_8                                                   233.0                                             233
109794 HI     school 1500030 1   Hawaii Department of Education 150003000137 237 WHEELER MID   Regular School No 2 06 8 2016   grade_8                                                   208.0                                             208
109807 HI     school 1500030 1   Hawaii Department of Education 150003000259 291 KAPOLEI MID   Regular School No 2 06 8 2016   grade_8                                                   445.0                                             445
109879 HI     school 1500030 1   Hawaii Department of Education 150003000053 385 WAIAKEA INT   Regular School No 2 06 8 2016   grade_8                                                   294.0                                             294
109890 HI     school 1500030 1   Hawaii Department of Education 150003000235 390 KEALAKEHE INT   Regular School No 2 06 8 2016   grade_8                                                   192.0                                             192
109893 HI     school 1500030 1   Hawaii Department of Education 150003000267 366 KOHALA MID   Regular School No 2 06 8 2016   grade_8                                                   50.0                                             50
109896 HI     school 1500030 1   Hawaii Department of Education 150003000252 376 KONAWAENA MID   Regular School No 2 06 8 2016   grade_8                                                   166.0                                             166
109903 HI     school 1500030 1   Hawaii Department of Education 150003000040 370 KEAAU MID   Regular School No 2 06 8 2016   grade_8                                                   196.0                                             196
109911 HI     school 1500030 1   Hawaii Department of Education 150003000059 404 IAO INT   Regular School No 2 06 8 2016   grade_8                                                   269.0                                             269
109913 HI     school 1500030 1   Hawaii Department of Education 150003000233 420 KALAMA INT   Regular School No 2 06 8 2016   grade_8                                                   236.0                                             236
109919 HI     school 1500030 1   Hawaii Department of Education 150003000238 430 LOKELANI INT   Regular School No 2 06 8 2016   grade_8                                                   153.0                                             153
109922 HI     school 1500030 1   Hawaii Department of Education 150003000241 428 MAUI WAENA INT   Regular School No 2 06 8 2016   grade_8                                                   318.0                                             318
109933 HI     school 1500030 1   Hawaii Department of Education 150003000068 413 LAHAINA INT   Regular School No 2 06 8 2016   grade_8                                                   194.0                                             194
109943 HI     school 1500030 1   Hawaii Department of Education 150003000266 448 KAMAKAHELEI MID   Regular School No 2 06 8 2016   grade_8                                                   278.0                                             278
109946 HI     school 1500030 1   Hawaii Department of Education 150003000255 447 KAPAA MID   Regular School No 2 06 8 2016   grade_8                                                   194.0                                             194
109953 HI     school 1500030 1   Hawaii Department of Education 150003000092 464 WAIMEA CANYON   Regular School No 2 06 8 2016   grade_8                                                   128.0                                             128
109984 HI     school 1500030 1   Hawaii Department of Education 150003000298 567 SEEQS charter Regular School Yes 2 06 8 2016   grade_8                                                   27.0                                             27
109988 HI     school 1500030 1   Hawaii Department of Education 150003000268 394 WAIMEA MID-PCCS charter Regular School Yes 2 06 8 2016   grade_8                                                   78.0                                             78
109989 HI     school 1500030 1   Hawaii Department of Education 150003000265 399 WEST HI EXPLOR ACAD-PCS charter Regular School Yes 4 06 12 2016   grade_8                                                   39.0                                             39
128704 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 DOLE MID   Regular School No Middle 06 8 2017   grade_8                                                   201.0                                             201
128711 HI     school 1500030 1   Hawaii Department of Education 150003000211 116 KAIMUKI MID   Regular School No Middle 06 8 2017   grade_8                                                   300.0                                             300
128713 HI     school 1500030 1   Hawaii Department of Education 150003000164 118 KALAKAUA MID   Regular School No Middle 06 8 2017   grade_8                                                   270.0                                             270
128724 HI     school 1500030 1   Hawaii Department of Education 150003000192 139 NIU VALLEY MID   Regular School No Middle 06 8 2017   grade_8                                                   274.0                                             274
128731 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 CENTRAL MID   Regular School No Middle 06 8 2017   grade_8                                                   118.0                                             118
128733 HI     school 1500030 1   Hawaii Department of Education 150003000218 110 JARRETT MID   Regular School No Middle 06 8 2017   grade_8                                                   71.0                                             71
128739 HI     school 1500030 1   Hawaii Department of Education 150003000205 126 KAWANANAKOA MID   Regular School No Middle 06 8 2017   grade_8                                                   234.0                                             234
128754 HI     school 1500030 1   Hawaii Department of Education 150003000184 148 STEVENSON MID   Regular School No Middle 06 8 2017   grade_8                                                   194.0                                             194
128755 HI     school 1500030 1   Hawaii Department of Education 150003000180 152 WASHINGTON MID   Regular School No Middle 06 8 2017   grade_8                                                   236.0                                             236
128788 HI     school 1500030 1   Hawaii Department of Education 150003000256 238 MILILANI MID   Regular School No Middle 06 8 2017   grade_8                                                   574.0                                             574
128793 HI     school 1500030 1   Hawaii Department of Education 150003000143 230 WAHIAWA MID   Regular School No Middle 06 8 2017   grade_8                                                   238.0                                             238
128797 HI     school 1500030 1   Hawaii Department of Education 150003000137 237 WHEELER MID   Regular School No Middle 06 8 2017   grade_8                                                   199.0                                             199
128810 HI     school 1500030 1   Hawaii Department of Education 150003000259 291 KAPOLEI MID   Regular School No Middle 06 8 2017   grade_8                                                   400.0                                             400
128882 HI     school 1500030 1   Hawaii Department of Education 150003000053 385 WAIAKEA INT   Regular School No Middle 06 8 2017   grade_8                                                   256.0                                             256
128893 HI     school 1500030 1   Hawaii Department of Education 150003000235 390 KEALAKEHE INT   Regular School No Middle 06 8 2017   grade_8                                                   234.0                                             234
128896 HI     school 1500030 1   Hawaii Department of Education 150003000267 366 KOHALA MID   Regular School No Middle 06 8 2017   grade_8                                                   52.0                                             52
128899 HI     school 1500030 1   Hawaii Department of Education 150003000252 376 KONAWAENA MID   Regular School No Middle 06 8 2017   grade_8                                                   148.0                                             148
128906 HI     school 1500030 1   Hawaii Department of Education 150003000040 370 KEAAU MID   Regular School No Middle 06 8 2017   grade_8                                                   207.0                                             207
128914 HI     school 1500030 1   Hawaii Department of Education 150003000059 404 IAO INT   Regular School No Middle 06 8 2017   grade_8                                                   239.0                                             239
128916 HI     school 1500030 1   Hawaii Department of Education 150003000233 420 KALAMA INT   Regular School No Middle 06 8 2017   grade_8                                                   245.0                                             245
128922 HI     school 1500030 1   Hawaii Department of Education 150003000238 430 LOKELANI INT   Regular School No Middle 06 8 2017   grade_8                                                   168.0                                             168
128925 HI     school 1500030 1   Hawaii Department of Education 150003000241 428 MAUI WAENA INT   Regular School No Middle 06 8 2017   grade_8                                                   349.0                                             349
128936 HI     school 1500030 1   Hawaii Department of Education 150003000068 413 LAHAINA INT   Regular School No Middle 06 8 2017   grade_8                                                   200.0                                             200
128946 HI     school 1500030 1   Hawaii Department of Education 150003000266 448 KAMAKAHELEI MID   Regular School No Middle 06 8 2017   grade_8                                                   272.0                                             272
128949 HI     school 1500030 1   Hawaii Department of Education 150003000255 447 KAPAA MID   Regular School No Middle 06 8 2017   grade_8                                                   224.0                                             224
128956 HI     school 1500030 1   Hawaii Department of Education 150003000092 464 WAIMEA CANYON   Regular School No Middle 06 8 2017   grade_8                                                   107.0                                             107
128987 HI     school 1500030 1   Hawaii Department of Education 150003000298 567 SEEQS charter Regular School Yes Middle 06 8 2017   grade_8                                                   45.0                                             45
128991 HI     school 1500030 1   Hawaii Department of Education 150003000268 394 WAIMEA MID-PCCS charter Regular School Yes Middle 06 8 2017   grade_8                                                   75.0                                             75
128992 HI     school 1500030 1   Hawaii Department of Education 150003000265 399 WEST HI EXPLOR ACAD-PCS charter Regular School Yes Other 06 12 2017   grade_8                                                   39.0                                             39
279681 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 DOLE MID   Regular School No 2 06 8 2015   grade_8                                                   215.0                                             215
279688 HI     school 1500030 1   Hawaii Department of Education 150003000211 116 KAIMUKI MID   Regular School No 2 06 8 2015   grade_8                                                   287.0                                             287
279690 HI     school 1500030 1   Hawaii Department of Education 150003000164 118 KALAKAUA MID   Regular School No 2 06 8 2015   grade_8                                                   256.0                                             256
279701 HI     school 1500030 1   Hawaii Department of Education 150003000192 139 NIU VALLEY MID   Regular School No 2 06 8 2015   grade_8                                                   258.0                                             258
279708 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 CENTRAL MID   Regular School No 2 06 8 2015   grade_8                                                   97.0                                             97
279710 HI     school 1500030 1   Hawaii Department of Education 150003000218 110 JARRETT MID   Regular School No 2 06 8 2015   grade_8                                                   46.0                                             46
279716 HI     school 1500030 1   Hawaii Department of Education 150003000205 126 KAWANANAKOA MID   Regular School No 2 06 8 2015   grade_8                                                   250.0                                             250
279731 HI     school 1500030 1   Hawaii Department of Education 150003000184 148 STEVENSON MID   Regular School No 2 06 8 2015   grade_8                                                   182.0                                             182
279732 HI     school 1500030 1   Hawaii Department of Education 150003000180 152 WASHINGTON MID   Regular School No 2 06 8 2015   grade_8                                                   221.0                                             221
279765 HI     school 1500030 1   Hawaii Department of Education 150003000256 238 MILILANI MID   Regular School No 2 06 8 2015   grade_8                                                   507.0                                             507
279770 HI     school 1500030 1   Hawaii Department of Education 150003000143 230 WAHIAWA MID   Regular School No 2 06 8 2015   grade_8                                                   220.0                                             220
279774 HI     school 1500030 1   Hawaii Department of Education 150003000137 237 WHEELER MID   Regular School No 2 06 8 2015   grade_8                                                   232.0                                             232
279786 HI     school 1500030 1   Hawaii Department of Education 150003000259 291 KAPOLEI MID   Regular School No 2 06 8 2015   grade_8                                                   434.0                                             434
279858 HI     school 1500030 1   Hawaii Department of Education 150003000053 385 WAIAKEA INT   Regular School No 2 06 8 2015   grade_8                                                   231.0                                             231
279869 HI     school 1500030 1   Hawaii Department of Education 150003000235 390 KEALAKEHE INT   Regular School No 2 06 8 2015   grade_8                                                   195.0                                             195
279872 HI     school 1500030 1   Hawaii Department of Education 150003000267 366 KOHALA MID   Regular School No 2 06 8 2015   grade_8                                                   47.0                                             47
279875 HI     school 1500030 1   Hawaii Department of Education 150003000252 376 KONAWAENA MID   Regular School No 2 06 8 2015   grade_8                                                   157.0                                             157
279882 HI     school 1500030 1   Hawaii Department of Education 150003000040 370 KEAAU MID   Regular School No 2 06 8 2015   grade_8                                                   182.0                                             182
279890 HI     school 1500030 1   Hawaii Department of Education 150003000059 404 IAO INT   Regular School No 2 06 8 2015   grade_8                                                   240.0                                             240
279892 HI     school 1500030 1   Hawaii Department of Education 150003000233 420 KALAMA INT   Regular School No 2 06 8 2015   grade_8                                                   220.0                                             220
279898 HI     school 1500030 1   Hawaii Department of Education 150003000238 430 LOKELANI INT   Regular School No 2 06 8 2015   grade_8                                                   147.0                                             147
279901 HI     school 1500030 1   Hawaii Department of Education 150003000241 428 MAUI WAENA INT   Regular School No 2 06 8 2015   grade_8                                                   318.0                                             318
279912 HI     school 1500030 1   Hawaii Department of Education 150003000068 413 LAHAINA INT   Regular School No 2 06 8 2015   grade_8                                                   163.0                                             163
279922 HI     school 1500030 1   Hawaii Department of Education 150003000266 448 KAMAKAHELEI MID   Regular School No 2 06 8 2015   grade_8                                                   283.0                                             283
279925 HI     school 1500030 1   Hawaii Department of Education 150003000255 447 KAPAA MID   Regular School No 2 06 8 2015   grade_8                                                   157.0                                             157
279932 HI     school 1500030 1   Hawaii Department of Education 150003000092 464 WAIMEA CANYON   Regular School No 2 06 8 2015   grade_8                                                   99.0                                             99