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
109389 HI     school 1500030 1   Hawaii Department of Education 150003000301 552 KAU LEARNING ACAD-PCS charter Regular School Yes 1 03 6 2016   grade_6                                                   21.0                                             21
128392 HI     school 1500030 1   Hawaii Department of Education 150003000301 552 KAU LEARNING ACAD-PCS charter Regular School Yes Elementary 03 7 2017   grade_6                                                   24.0                                             24
2781209 HI     school 1500030 1   Hawaii Department of Education 150003000301 552 Kau Learning Academy charter Regular School Yes Middle 03 7 2018   grade_6                                                   16.0                                             16
109378 HI     school 1500030 1   Hawaii Department of Education 150003000275 546 HAKIPU'U LEARNING CTR-PCS charter Regular School Yes 4 04 12 2016   grade_6                                                   2.0                                             2
109379 HI     school 1500030 1   Hawaii Department of Education 150003000270 540 HALAU KU MANA-PCS charter Regular School Yes 4 04 12 2016   grade_6                                                   15.0                                             15
128381 HI     school 1500030 1   Hawaii Department of Education 150003000275 546 HAKIPU'U LEARNING CTR-PCS charter Regular School Yes Other 04 12 2017   grade_6                                                   3.0                                             3
128382 HI     school 1500030 1   Hawaii Department of Education 150003000270 540 HALAU KU MANA-PCS charter Regular School Yes Other 04 12 2017   grade_6                                                   19.0                                             19
279368 HI     school 1500030 1   Hawaii Department of Education 150003000270 540 HALAU KU MANA-PCS charter Regular School Yes 4 04 12 2015   grade_6                                                   13.0                                             13
279374 HI     school 1500030 1   Hawaii Department of Education 150003000275 546 HAKIPU'U LEARNING CTR-PCS charter Regular School Yes 4 04 12 2015   grade_6                                                   3.0                                             3
2430483 HI     school 1500030 1   Hawaii Department of Education 150003000275 546 Hakipuu Learning Ctr PCS charter Regular School Yes Other 04 12 2020   grade_6                                                   4.0                                             4
2430484 HI     school 1500030 1   Hawaii Department of Education 150003000270 540 Halau Ku Mana NCPCS charter Regular School Yes Other 04 12 2020   grade_6                                                   18.0                                             18
2455172 HI     school 1500030 1   Hawaii Department of Education 150003000270 540 Halau Ku Mana NCPCS charter Regular School Yes Other 04 12 2021   grade_6                                                   14.0                                             14
2736155 HI     school 1500030 1   Hawaii Department of Education 150003000270 540 Halau Ku Mana NCPCS charter Regular School Yes Other 04 12 2019   grade_6                                                   15.0                                             15
2736160 HI     school 1500030 1   Hawaii Department of Education 150003000275 546 Hakipuu Learning Ctr PCS charter Regular School Yes Other 04 12 2019   grade_6                                                   3.0                                             3
2781195 HI     school 1500030 1   Hawaii Department of Education 150003000275 546 Hakipuu Learning Ctr PCS charter Regular School Yes Other 04 12 2018   grade_6                                                   6.0                                             6
2781196 HI     school 1500030 1   Hawaii Department of Education 150003000270 540 Halau Ku Mana NCPCS charter Regular School Yes Other 04 12 2018   grade_6                                                   12.0                                             12
2455171 HI     school 1500030 1   Hawaii Department of Education 150003000275 546 Hakipuu Academy PCS charter Regular School Yes High 05 12 2021   grade_6                                                   3.0                                             3
109121 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 DOLE MID   Regular School No 2 06 8 2016   grade_6                                                   260.0                                             260
109128 HI     school 1500030 1   Hawaii Department of Education 150003000211 116 KAIMUKI MID   Regular School No 2 06 8 2016   grade_6                                                   322.0                                             322
109130 HI     school 1500030 1   Hawaii Department of Education 150003000164 118 KALAKAUA MID   Regular School No 2 06 8 2016   grade_6                                                   338.0                                             338
109141 HI     school 1500030 1   Hawaii Department of Education 150003000192 139 NIU VALLEY MID   Regular School No 2 06 8 2016   grade_6                                                   282.0                                             282
109148 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 CENTRAL MID   Regular School No 2 06 8 2016   grade_6                                                   126.0                                             126
109150 HI     school 1500030 1   Hawaii Department of Education 150003000218 110 JARRETT MID   Regular School No 2 06 8 2016   grade_6                                                   64.0                                             64
109156 HI     school 1500030 1   Hawaii Department of Education 150003000205 126 KAWANANAKOA MID   Regular School No 2 06 8 2016   grade_6                                                   279.0                                             279
109171 HI     school 1500030 1   Hawaii Department of Education 150003000184 148 STEVENSON MID   Regular School No 2 06 8 2016   grade_6                                                   192.0                                             192
109172 HI     school 1500030 1   Hawaii Department of Education 150003000180 152 WASHINGTON MID   Regular School No 2 06 8 2016   grade_6                                                   281.0                                             281
109205 HI     school 1500030 1   Hawaii Department of Education 150003000256 238 MILILANI MID   Regular School No 2 06 8 2016   grade_6                                                   563.0                                             563
109210 HI     school 1500030 1   Hawaii Department of Education 150003000143 230 WAHIAWA MID   Regular School No 2 06 8 2016   grade_6                                                   243.0                                             243
109214 HI     school 1500030 1   Hawaii Department of Education 150003000137 237 WHEELER MID   Regular School No 2 06 8 2016   grade_6                                                   255.0                                             255
109227 HI     school 1500030 1   Hawaii Department of Education 150003000259 291 KAPOLEI MID   Regular School No 2 06 8 2016   grade_6                                                   433.0                                             433
109299 HI     school 1500030 1   Hawaii Department of Education 150003000053 385 WAIAKEA INT   Regular School No 2 06 8 2016   grade_6                                                   229.0                                             229
109310 HI     school 1500030 1   Hawaii Department of Education 150003000235 390 KEALAKEHE INT   Regular School No 2 06 8 2016   grade_6                                                   202.0                                             202
109313 HI     school 1500030 1   Hawaii Department of Education 150003000267 366 KOHALA MID   Regular School No 2 06 8 2016   grade_6                                                   54.0                                             54
109316 HI     school 1500030 1   Hawaii Department of Education 150003000252 376 KONAWAENA MID   Regular School No 2 06 8 2016   grade_6                                                   180.0                                             180
109323 HI     school 1500030 1   Hawaii Department of Education 150003000040 370 KEAAU MID   Regular School No 2 06 8 2016   grade_6                                                   194.0                                             194
109331 HI     school 1500030 1   Hawaii Department of Education 150003000059 404 IAO INT   Regular School No 2 06 8 2016   grade_6                                                   281.0                                             281
109333 HI     school 1500030 1   Hawaii Department of Education 150003000233 420 KALAMA INT   Regular School No 2 06 8 2016   grade_6                                                   248.0                                             248
109339 HI     school 1500030 1   Hawaii Department of Education 150003000238 430 LOKELANI INT   Regular School No 2 06 8 2016   grade_6                                                   199.0                                             199
109342 HI     school 1500030 1   Hawaii Department of Education 150003000241 428 MAUI WAENA INT   Regular School No 2 06 8 2016   grade_6                                                   361.0                                             361
109353 HI     school 1500030 1   Hawaii Department of Education 150003000068 413 LAHAINA INT   Regular School No 2 06 8 2016   grade_6                                                   201.0                                             201
109363 HI     school 1500030 1   Hawaii Department of Education 150003000266 448 KAMAKAHELEI MID   Regular School No 2 06 8 2016   grade_6                                                   299.0                                             299
109366 HI     school 1500030 1   Hawaii Department of Education 150003000255 447 KAPAA MID   Regular School No 2 06 8 2016   grade_6                                                   167.0                                             167
109373 HI     school 1500030 1   Hawaii Department of Education 150003000092 464 WAIMEA CANYON   Regular School No 2 06 8 2016   grade_6                                                   141.0                                             141
109404 HI     school 1500030 1   Hawaii Department of Education 150003000298 567 SEEQS charter Regular School Yes 2 06 8 2016   grade_6                                                   52.0                                             52
109408 HI     school 1500030 1   Hawaii Department of Education 150003000268 394 WAIMEA MID-PCCS charter Regular School Yes 2 06 8 2016   grade_6                                                   69.0                                             69
109409 HI     school 1500030 1   Hawaii Department of Education 150003000265 399 WEST HI EXPLOR ACAD-PCS charter Regular School Yes 4 06 12 2016   grade_6                                                   38.0                                             38
128124 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 DOLE MID   Regular School No Middle 06 8 2017   grade_6                                                   258.0                                             258
128131 HI     school 1500030 1   Hawaii Department of Education 150003000211 116 KAIMUKI MID   Regular School No Middle 06 8 2017   grade_6                                                   305.0                                             305
128133 HI     school 1500030 1   Hawaii Department of Education 150003000164 118 KALAKAUA MID   Regular School No Middle 06 8 2017   grade_6                                                   367.0                                             367
128144 HI     school 1500030 1   Hawaii Department of Education 150003000192 139 NIU VALLEY MID   Regular School No Middle 06 8 2017   grade_6                                                   280.0                                             280
128151 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 CENTRAL MID   Regular School No Middle 06 8 2017   grade_6                                                   138.0                                             138
128153 HI     school 1500030 1   Hawaii Department of Education 150003000218 110 JARRETT MID   Regular School No Middle 06 8 2017   grade_6                                                   74.0                                             74
128159 HI     school 1500030 1   Hawaii Department of Education 150003000205 126 KAWANANAKOA MID   Regular School No Middle 06 8 2017   grade_6                                                   258.0                                             258
128174 HI     school 1500030 1   Hawaii Department of Education 150003000184 148 STEVENSON MID   Regular School No Middle 06 8 2017   grade_6                                                   202.0                                             202
128175 HI     school 1500030 1   Hawaii Department of Education 150003000180 152 WASHINGTON MID   Regular School No Middle 06 8 2017   grade_6                                                   274.0                                             274
128208 HI     school 1500030 1   Hawaii Department of Education 150003000256 238 MILILANI MID   Regular School No Middle 06 8 2017   grade_6                                                   549.0                                             549
128213 HI     school 1500030 1   Hawaii Department of Education 150003000143 230 WAHIAWA MID   Regular School No Middle 06 8 2017   grade_6                                                   237.0                                             237
128217 HI     school 1500030 1   Hawaii Department of Education 150003000137 237 WHEELER MID   Regular School No Middle 06 8 2017   grade_6                                                   287.0                                             287
128230 HI     school 1500030 1   Hawaii Department of Education 150003000259 291 KAPOLEI MID   Regular School No Middle 06 8 2017   grade_6                                                   403.0                                             403
128302 HI     school 1500030 1   Hawaii Department of Education 150003000053 385 WAIAKEA INT   Regular School No Middle 06 8 2017   grade_6                                                   253.0                                             253
128313 HI     school 1500030 1   Hawaii Department of Education 150003000235 390 KEALAKEHE INT   Regular School No Middle 06 8 2017   grade_6                                                   227.0                                             227
128316 HI     school 1500030 1   Hawaii Department of Education 150003000267 366 KOHALA MID   Regular School No Middle 06 8 2017   grade_6                                                   48.0                                             48
128319 HI     school 1500030 1   Hawaii Department of Education 150003000252 376 KONAWAENA MID   Regular School No Middle 06 8 2017   grade_6                                                   186.0                                             186
128326 HI     school 1500030 1   Hawaii Department of Education 150003000040 370 KEAAU MID   Regular School No Middle 06 8 2017   grade_6                                                   184.0                                             184
128334 HI     school 1500030 1   Hawaii Department of Education 150003000059 404 IAO INT   Regular School No Middle 06 8 2017   grade_6                                                   275.0                                             275
128336 HI     school 1500030 1   Hawaii Department of Education 150003000233 420 KALAMA INT   Regular School No Middle 06 8 2017   grade_6                                                   245.0                                             245
128342 HI     school 1500030 1   Hawaii Department of Education 150003000238 430 LOKELANI INT   Regular School No Middle 06 8 2017   grade_6                                                   158.0                                             158
128345 HI     school 1500030 1   Hawaii Department of Education 150003000241 428 MAUI WAENA INT   Regular School No Middle 06 8 2017   grade_6                                                   369.0                                             369
128356 HI     school 1500030 1   Hawaii Department of Education 150003000068 413 LAHAINA INT   Regular School No Middle 06 8 2017   grade_6                                                   237.0                                             237
128366 HI     school 1500030 1   Hawaii Department of Education 150003000266 448 KAMAKAHELEI MID   Regular School No Middle 06 8 2017   grade_6                                                   304.0                                             304
128369 HI     school 1500030 1   Hawaii Department of Education 150003000255 447 KAPAA MID   Regular School No Middle 06 8 2017   grade_6                                                   143.0                                             143
128376 HI     school 1500030 1   Hawaii Department of Education 150003000092 464 WAIMEA CANYON   Regular School No Middle 06 8 2017   grade_6                                                   135.0                                             135
128407 HI     school 1500030 1   Hawaii Department of Education 150003000298 567 SEEQS charter Regular School Yes Middle 06 8 2017   grade_6                                                   47.0                                             47
128411 HI     school 1500030 1   Hawaii Department of Education 150003000268 394 WAIMEA MID-PCCS charter Regular School Yes Middle 06 8 2017   grade_6                                                   84.0                                             84
128412 HI     school 1500030 1   Hawaii Department of Education 150003000265 399 WEST HI EXPLOR ACAD-PCS charter Regular School Yes Other 06 12 2017   grade_6                                                   40.0                                             40
279103 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 DOLE MID   Regular School No 2 06 8 2015   grade_6                                                   220.0                                             220
279110 HI     school 1500030 1   Hawaii Department of Education 150003000211 116 KAIMUKI MID   Regular School No 2 06 8 2015   grade_6                                                   321.0                                             321
279112 HI     school 1500030 1   Hawaii Department of Education 150003000164 118 KALAKAUA MID   Regular School No 2 06 8 2015   grade_6                                                   301.0                                             301
279123 HI     school 1500030 1   Hawaii Department of Education 150003000192 139 NIU VALLEY MID   Regular School No 2 06 8 2015   grade_6                                                   274.0                                             274
279130 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 CENTRAL MID   Regular School No 2 06 8 2015   grade_6                                                   126.0                                             126
279132 HI     school 1500030 1   Hawaii Department of Education 150003000218 110 JARRETT MID   Regular School No 2 06 8 2015   grade_6                                                   88.0                                             88
279138 HI     school 1500030 1   Hawaii Department of Education 150003000205 126 KAWANANAKOA MID   Regular School No 2 06 8 2015   grade_6                                                   271.0                                             271
279153 HI     school 1500030 1   Hawaii Department of Education 150003000184 148 STEVENSON MID   Regular School No 2 06 8 2015   grade_6                                                   188.0                                             188
279154 HI     school 1500030 1   Hawaii Department of Education 150003000180 152 WASHINGTON MID   Regular School No 2 06 8 2015   grade_6                                                   265.0                                             265
279187 HI     school 1500030 1   Hawaii Department of Education 150003000256 238 MILILANI MID   Regular School No 2 06 8 2015   grade_6                                                   567.0                                             567
279192 HI     school 1500030 1   Hawaii Department of Education 150003000143 230 WAHIAWA MID   Regular School No 2 06 8 2015   grade_6                                                   265.0                                             265
279196 HI     school 1500030 1   Hawaii Department of Education 150003000137 237 WHEELER MID   Regular School No 2 06 8 2015   grade_6                                                   275.0                                             275
279208 HI     school 1500030 1   Hawaii Department of Education 150003000259 291 KAPOLEI MID   Regular School No 2 06 8 2015   grade_6                                                   415.0                                             415
279280 HI     school 1500030 1   Hawaii Department of Education 150003000053 385 WAIAKEA INT   Regular School No 2 06 8 2015   grade_6                                                   227.0                                             227
279291 HI     school 1500030 1   Hawaii Department of Education 150003000235 390 KEALAKEHE INT   Regular School No 2 06 8 2015   grade_6                                                   245.0                                             245
279294 HI     school 1500030 1   Hawaii Department of Education 150003000267 366 KOHALA MID   Regular School No 2 06 8 2015   grade_6                                                   53.0                                             53
279297 HI     school 1500030 1   Hawaii Department of Education 150003000252 376 KONAWAENA MID   Regular School No 2 06 8 2015   grade_6                                                   165.0                                             165
279304 HI     school 1500030 1   Hawaii Department of Education 150003000040 370 KEAAU MID   Regular School No 2 06 8 2015   grade_6                                                   180.0                                             180
279312 HI     school 1500030 1   Hawaii Department of Education 150003000059 404 IAO INT   Regular School No 2 06 8 2015   grade_6                                                   269.0                                             269
279314 HI     school 1500030 1   Hawaii Department of Education 150003000233 420 KALAMA INT   Regular School No 2 06 8 2015   grade_6                                                   260.0                                             260
279320 HI     school 1500030 1   Hawaii Department of Education 150003000238 430 LOKELANI INT   Regular School No 2 06 8 2015   grade_6                                                   184.0                                             184
279323 HI     school 1500030 1   Hawaii Department of Education 150003000241 428 MAUI WAENA INT   Regular School No 2 06 8 2015   grade_6                                                   370.0                                             370
279334 HI     school 1500030 1   Hawaii Department of Education 150003000068 413 LAHAINA INT   Regular School No 2 06 8 2015   grade_6                                                   210.0                                             210
279344 HI     school 1500030 1   Hawaii Department of Education 150003000266 448 KAMAKAHELEI MID   Regular School No 2 06 8 2015   grade_6                                                   282.0                                             282
279347 HI     school 1500030 1   Hawaii Department of Education 150003000255 447 KAPAA MID   Regular School No 2 06 8 2015   grade_6                                                   173.0                                             173
279354 HI     school 1500030 1   Hawaii Department of Education 150003000092 464 WAIMEA CANYON   Regular School No 2 06 8 2015   grade_6                                                   115.0                                             115