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
109679 HI     school 1500030 1   Hawaii Department of Education 150003000301 552 KAU LEARNING ACAD-PCS charter Regular School Yes 1 03 6 2016   grade_7                                                   0.0                                             0
128682 HI     school 1500030 1   Hawaii Department of Education 150003000301 552 KAU LEARNING ACAD-PCS charter Regular School Yes Elementary 03 7 2017   grade_7                                                   16.0                                             16
2781501 HI     school 1500030 1   Hawaii Department of Education 150003000301 552 Kau Learning Academy charter Regular School Yes Middle 03 7 2018   grade_7                                                   19.0                                             19
109668 HI     school 1500030 1   Hawaii Department of Education 150003000275 546 HAKIPU'U LEARNING CTR-PCS charter Regular School Yes 4 04 12 2016   grade_7                                                   4.0                                             4
109669 HI     school 1500030 1   Hawaii Department of Education 150003000270 540 HALAU KU MANA-PCS charter Regular School Yes 4 04 12 2016   grade_7                                                   15.0                                             15
128671 HI     school 1500030 1   Hawaii Department of Education 150003000275 546 HAKIPU'U LEARNING CTR-PCS charter Regular School Yes Other 04 12 2017   grade_7                                                   7.0                                             7
128672 HI     school 1500030 1   Hawaii Department of Education 150003000270 540 HALAU KU MANA-PCS charter Regular School Yes Other 04 12 2017   grade_7                                                   17.0                                             17
279657 HI     school 1500030 1   Hawaii Department of Education 150003000270 540 HALAU KU MANA-PCS charter Regular School Yes 4 04 12 2015   grade_7                                                   15.0                                             15
279663 HI     school 1500030 1   Hawaii Department of Education 150003000275 546 HAKIPU'U LEARNING CTR-PCS charter Regular School Yes 4 04 12 2015   grade_7                                                   6.0                                             6
2430776 HI     school 1500030 1   Hawaii Department of Education 150003000275 546 Hakipuu Learning Ctr PCS charter Regular School Yes Other 04 12 2020   grade_7                                                   5.0                                             5
2430777 HI     school 1500030 1   Hawaii Department of Education 150003000270 540 Halau Ku Mana NCPCS charter Regular School Yes Other 04 12 2020   grade_7                                                   15.0                                             15
2455466 HI     school 1500030 1   Hawaii Department of Education 150003000270 540 Halau Ku Mana NCPCS charter Regular School Yes Other 04 12 2021   grade_7                                                   16.0                                             16
2736447 HI     school 1500030 1   Hawaii Department of Education 150003000270 540 Halau Ku Mana NCPCS charter Regular School Yes Other 04 12 2019   grade_7                                                   17.0                                             17
2736452 HI     school 1500030 1   Hawaii Department of Education 150003000275 546 Hakipuu Learning Ctr PCS charter Regular School Yes Other 04 12 2019   grade_7                                                   7.0                                             7
2781487 HI     school 1500030 1   Hawaii Department of Education 150003000275 546 Hakipuu Learning Ctr PCS charter Regular School Yes Other 04 12 2018   grade_7                                                   3.0                                             3
2781488 HI     school 1500030 1   Hawaii Department of Education 150003000270 540 Halau Ku Mana NCPCS charter Regular School Yes Other 04 12 2018   grade_7                                                   20.0                                             20
2455465 HI     school 1500030 1   Hawaii Department of Education 150003000275 546 Hakipuu Academy PCS charter Regular School Yes High 05 12 2021   grade_7                                                   5.0                                             5
109411 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 DOLE MID   Regular School No 2 06 8 2016   grade_7                                                   239.0                                             239
109418 HI     school 1500030 1   Hawaii Department of Education 150003000211 116 KAIMUKI MID   Regular School No 2 06 8 2016   grade_7                                                   311.0                                             311
109420 HI     school 1500030 1   Hawaii Department of Education 150003000164 118 KALAKAUA MID   Regular School No 2 06 8 2016   grade_7                                                   289.0                                             289
109431 HI     school 1500030 1   Hawaii Department of Education 150003000192 139 NIU VALLEY MID   Regular School No 2 06 8 2016   grade_7                                                   282.0                                             282
109438 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 CENTRAL MID   Regular School No 2 06 8 2016   grade_7                                                   115.0                                             115
109440 HI     school 1500030 1   Hawaii Department of Education 150003000218 110 JARRETT MID   Regular School No 2 06 8 2016   grade_7                                                   79.0                                             79
109446 HI     school 1500030 1   Hawaii Department of Education 150003000205 126 KAWANANAKOA MID   Regular School No 2 06 8 2016   grade_7                                                   248.0                                             248
109461 HI     school 1500030 1   Hawaii Department of Education 150003000184 148 STEVENSON MID   Regular School No 2 06 8 2016   grade_7                                                   201.0                                             201
109462 HI     school 1500030 1   Hawaii Department of Education 150003000180 152 WASHINGTON MID   Regular School No 2 06 8 2016   grade_7                                                   264.0                                             264
109495 HI     school 1500030 1   Hawaii Department of Education 150003000256 238 MILILANI MID   Regular School No 2 06 8 2016   grade_7                                                   578.0                                             578
109500 HI     school 1500030 1   Hawaii Department of Education 150003000143 230 WAHIAWA MID   Regular School No 2 06 8 2016   grade_7                                                   259.0                                             259
109504 HI     school 1500030 1   Hawaii Department of Education 150003000137 237 WHEELER MID   Regular School No 2 06 8 2016   grade_7                                                   243.0                                             243
109517 HI     school 1500030 1   Hawaii Department of Education 150003000259 291 KAPOLEI MID   Regular School No 2 06 8 2016   grade_7                                                   407.0                                             407
109589 HI     school 1500030 1   Hawaii Department of Education 150003000053 385 WAIAKEA INT   Regular School No 2 06 8 2016   grade_7                                                   247.0                                             247
109600 HI     school 1500030 1   Hawaii Department of Education 150003000235 390 KEALAKEHE INT   Regular School No 2 06 8 2016   grade_7                                                   237.0                                             237
109603 HI     school 1500030 1   Hawaii Department of Education 150003000267 366 KOHALA MID   Regular School No 2 06 8 2016   grade_7                                                   55.0                                             55
109606 HI     school 1500030 1   Hawaii Department of Education 150003000252 376 KONAWAENA MID   Regular School No 2 06 8 2016   grade_7                                                   162.0                                             162
109613 HI     school 1500030 1   Hawaii Department of Education 150003000040 370 KEAAU MID   Regular School No 2 06 8 2016   grade_7                                                   193.0                                             193
109621 HI     school 1500030 1   Hawaii Department of Education 150003000059 404 IAO INT   Regular School No 2 06 8 2016   grade_7                                                   264.0                                             264
109623 HI     school 1500030 1   Hawaii Department of Education 150003000233 420 KALAMA INT   Regular School No 2 06 8 2016   grade_7                                                   263.0                                             263
109629 HI     school 1500030 1   Hawaii Department of Education 150003000238 430 LOKELANI INT   Regular School No 2 06 8 2016   grade_7                                                   168.0                                             168
109632 HI     school 1500030 1   Hawaii Department of Education 150003000241 428 MAUI WAENA INT   Regular School No 2 06 8 2016   grade_7                                                   378.0                                             378
109643 HI     school 1500030 1   Hawaii Department of Education 150003000068 413 LAHAINA INT   Regular School No 2 06 8 2016   grade_7                                                   208.0                                             208
109653 HI     school 1500030 1   Hawaii Department of Education 150003000266 448 KAMAKAHELEI MID   Regular School No 2 06 8 2016   grade_7                                                   281.0                                             281
109656 HI     school 1500030 1   Hawaii Department of Education 150003000255 447 KAPAA MID   Regular School No 2 06 8 2016   grade_7                                                   211.0                                             211
109663 HI     school 1500030 1   Hawaii Department of Education 150003000092 464 WAIMEA CANYON   Regular School No 2 06 8 2016   grade_7                                                   111.0                                             111
109694 HI     school 1500030 1   Hawaii Department of Education 150003000298 567 SEEQS charter Regular School Yes 2 06 8 2016   grade_7                                                   49.0                                             49
109698 HI     school 1500030 1   Hawaii Department of Education 150003000268 394 WAIMEA MID-PCCS charter Regular School Yes 2 06 8 2016   grade_7                                                   89.0                                             89
109699 HI     school 1500030 1   Hawaii Department of Education 150003000265 399 WEST HI EXPLOR ACAD-PCS charter Regular School Yes 4 06 12 2016   grade_7                                                   37.0                                             37
128414 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 DOLE MID   Regular School No Middle 06 8 2017   grade_7                                                   255.0                                             255
128421 HI     school 1500030 1   Hawaii Department of Education 150003000211 116 KAIMUKI MID   Regular School No Middle 06 8 2017   grade_7                                                   314.0                                             314
128423 HI     school 1500030 1   Hawaii Department of Education 150003000164 118 KALAKAUA MID   Regular School No Middle 06 8 2017   grade_7                                                   324.0                                             324
128434 HI     school 1500030 1   Hawaii Department of Education 150003000192 139 NIU VALLEY MID   Regular School No Middle 06 8 2017   grade_7                                                   273.0                                             273
128441 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 CENTRAL MID   Regular School No Middle 06 8 2017   grade_7                                                   113.0                                             113
128443 HI     school 1500030 1   Hawaii Department of Education 150003000218 110 JARRETT MID   Regular School No Middle 06 8 2017   grade_7                                                   64.0                                             64
128449 HI     school 1500030 1   Hawaii Department of Education 150003000205 126 KAWANANAKOA MID   Regular School No Middle 06 8 2017   grade_7                                                   249.0                                             249
128464 HI     school 1500030 1   Hawaii Department of Education 150003000184 148 STEVENSON MID   Regular School No Middle 06 8 2017   grade_7                                                   197.0                                             197
128465 HI     school 1500030 1   Hawaii Department of Education 150003000180 152 WASHINGTON MID   Regular School No Middle 06 8 2017   grade_7                                                   265.0                                             265
128498 HI     school 1500030 1   Hawaii Department of Education 150003000256 238 MILILANI MID   Regular School No Middle 06 8 2017   grade_7                                                   555.0                                             555
128503 HI     school 1500030 1   Hawaii Department of Education 150003000143 230 WAHIAWA MID   Regular School No Middle 06 8 2017   grade_7                                                   257.0                                             257
128507 HI     school 1500030 1   Hawaii Department of Education 150003000137 237 WHEELER MID   Regular School No Middle 06 8 2017   grade_7                                                   242.0                                             242
128520 HI     school 1500030 1   Hawaii Department of Education 150003000259 291 KAPOLEI MID   Regular School No Middle 06 8 2017   grade_7                                                   432.0                                             432
128592 HI     school 1500030 1   Hawaii Department of Education 150003000053 385 WAIAKEA INT   Regular School No Middle 06 8 2017   grade_7                                                   256.0                                             256
128603 HI     school 1500030 1   Hawaii Department of Education 150003000235 390 KEALAKEHE INT   Regular School No Middle 06 8 2017   grade_7                                                   183.0                                             183
128606 HI     school 1500030 1   Hawaii Department of Education 150003000267 366 KOHALA MID   Regular School No Middle 06 8 2017   grade_7                                                   49.0                                             49
128609 HI     school 1500030 1   Hawaii Department of Education 150003000252 376 KONAWAENA MID   Regular School No Middle 06 8 2017   grade_7                                                   184.0                                             184
128616 HI     school 1500030 1   Hawaii Department of Education 150003000040 370 KEAAU MID   Regular School No Middle 06 8 2017   grade_7                                                   218.0                                             218
128624 HI     school 1500030 1   Hawaii Department of Education 150003000059 404 IAO INT   Regular School No Middle 06 8 2017   grade_7                                                   284.0                                             284
128626 HI     school 1500030 1   Hawaii Department of Education 150003000233 420 KALAMA INT   Regular School No Middle 06 8 2017   grade_7                                                   270.0                                             270
128632 HI     school 1500030 1   Hawaii Department of Education 150003000238 430 LOKELANI INT   Regular School No Middle 06 8 2017   grade_7                                                   194.0                                             194
128635 HI     school 1500030 1   Hawaii Department of Education 150003000241 428 MAUI WAENA INT   Regular School No Middle 06 8 2017   grade_7                                                   354.0                                             354
128646 HI     school 1500030 1   Hawaii Department of Education 150003000068 413 LAHAINA INT   Regular School No Middle 06 8 2017   grade_7                                                   203.0                                             203
128656 HI     school 1500030 1   Hawaii Department of Education 150003000266 448 KAMAKAHELEI MID   Regular School No Middle 06 8 2017   grade_7                                                   299.0                                             299
128659 HI     school 1500030 1   Hawaii Department of Education 150003000255 447 KAPAA MID   Regular School No Middle 06 8 2017   grade_7                                                   201.0                                             201
128666 HI     school 1500030 1   Hawaii Department of Education 150003000092 464 WAIMEA CANYON   Regular School No Middle 06 8 2017   grade_7                                                   124.0                                             124
128697 HI     school 1500030 1   Hawaii Department of Education 150003000298 567 SEEQS charter Regular School Yes Middle 06 8 2017   grade_7                                                   46.0                                             46
128701 HI     school 1500030 1   Hawaii Department of Education 150003000268 394 WAIMEA MID-PCCS charter Regular School Yes Middle 06 8 2017   grade_7                                                   67.0                                             67
128702 HI     school 1500030 1   Hawaii Department of Education 150003000265 399 WEST HI EXPLOR ACAD-PCS charter Regular School Yes Other 06 12 2017   grade_7                                                   39.0                                             39
279392 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 DOLE MID   Regular School No 2 06 8 2015   grade_7                                                   292.0                                             292
279399 HI     school 1500030 1   Hawaii Department of Education 150003000211 116 KAIMUKI MID   Regular School No 2 06 8 2015   grade_7                                                   307.0                                             307
279401 HI     school 1500030 1   Hawaii Department of Education 150003000164 118 KALAKAUA MID   Regular School No 2 06 8 2015   grade_7                                                   360.0                                             360
279412 HI     school 1500030 1   Hawaii Department of Education 150003000192 139 NIU VALLEY MID   Regular School No 2 06 8 2015   grade_7                                                   276.0                                             276
279419 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 CENTRAL MID   Regular School No 2 06 8 2015   grade_7                                                   108.0                                             108
279421 HI     school 1500030 1   Hawaii Department of Education 150003000218 110 JARRETT MID   Regular School No 2 06 8 2015   grade_7                                                   71.0                                             71
279427 HI     school 1500030 1   Hawaii Department of Education 150003000205 126 KAWANANAKOA MID   Regular School No 2 06 8 2015   grade_7                                                   261.0                                             261
279442 HI     school 1500030 1   Hawaii Department of Education 150003000184 148 STEVENSON MID   Regular School No 2 06 8 2015   grade_7                                                   174.0                                             174
279443 HI     school 1500030 1   Hawaii Department of Education 150003000180 152 WASHINGTON MID   Regular School No 2 06 8 2015   grade_7                                                   229.0                                             229
279476 HI     school 1500030 1   Hawaii Department of Education 150003000256 238 MILILANI MID   Regular School No 2 06 8 2015   grade_7                                                   550.0                                             550
279481 HI     school 1500030 1   Hawaii Department of Education 150003000143 230 WAHIAWA MID   Regular School No 2 06 8 2015   grade_7                                                   245.0                                             245
279485 HI     school 1500030 1   Hawaii Department of Education 150003000137 237 WHEELER MID   Regular School No 2 06 8 2015   grade_7                                                   258.0                                             258
279497 HI     school 1500030 1   Hawaii Department of Education 150003000259 291 KAPOLEI MID   Regular School No 2 06 8 2015   grade_7                                                   433.0                                             433
279569 HI     school 1500030 1   Hawaii Department of Education 150003000053 385 WAIAKEA INT   Regular School No 2 06 8 2015   grade_7                                                   294.0                                             294
279580 HI     school 1500030 1   Hawaii Department of Education 150003000235 390 KEALAKEHE INT   Regular School No 2 06 8 2015   grade_7                                                   198.0                                             198
279583 HI     school 1500030 1   Hawaii Department of Education 150003000267 366 KOHALA MID   Regular School No 2 06 8 2015   grade_7                                                   48.0                                             48
279586 HI     school 1500030 1   Hawaii Department of Education 150003000252 376 KONAWAENA MID   Regular School No 2 06 8 2015   grade_7                                                   164.0                                             164
279593 HI     school 1500030 1   Hawaii Department of Education 150003000040 370 KEAAU MID   Regular School No 2 06 8 2015   grade_7                                                   190.0                                             190
279601 HI     school 1500030 1   Hawaii Department of Education 150003000059 404 IAO INT   Regular School No 2 06 8 2015   grade_7                                                   292.0                                             292
279603 HI     school 1500030 1   Hawaii Department of Education 150003000233 420 KALAMA INT   Regular School No 2 06 8 2015   grade_7                                                   239.0                                             239
279609 HI     school 1500030 1   Hawaii Department of Education 150003000238 430 LOKELANI INT   Regular School No 2 06 8 2015   grade_7                                                   165.0                                             165
279612 HI     school 1500030 1   Hawaii Department of Education 150003000241 428 MAUI WAENA INT   Regular School No 2 06 8 2015   grade_7                                                   342.0                                             342
279623 HI     school 1500030 1   Hawaii Department of Education 150003000068 413 LAHAINA INT   Regular School No 2 06 8 2015   grade_7                                                   199.0                                             199
279633 HI     school 1500030 1   Hawaii Department of Education 150003000266 448 KAMAKAHELEI MID   Regular School No 2 06 8 2015   grade_7                                                   276.0                                             276
279636 HI     school 1500030 1   Hawaii Department of Education 150003000255 447 KAPAA MID   Regular School No 2 06 8 2015   grade_7                                                   183.0                                             183
279643 HI     school 1500030 1   Hawaii Department of Education 150003000092 464 WAIMEA CANYON   Regular School No 2 06 8 2015   grade_7                                                   128.0                                             128