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
109027 HI     school 1500030 1   Hawaii Department of Education 150003000049 382 PAAUILO EL & INT   Regular School No 4 PK 9 2016   grade_5                                                   23.0                                             23
128030 HI     school 1500030 1   Hawaii Department of Education 150003000049 382 PAAUILO EL & INT   Regular School No Other PK 9 2017   grade_5                                                   17.0                                             17
279009 HI     school 1500030 1   Hawaii Department of Education 150003000049 382 PAAUILO EL & INT   Regular School No 4 PK 9 2015   grade_5                                                   21.0                                             21
2430128 HI     school 1500030 1   Hawaii Department of Education 150003000049 382 Paauilo El & Int   Regular School No Other PK 9 2020   grade_5                                                   9.0                                             9
2454815 HI     school 1500030 1   Hawaii Department of Education 150003000049 382 Paauilo El & Int   Regular School No Other PK 9 2021   grade_5                                                   19.0                                             19
2735793 HI     school 1500030 1   Hawaii Department of Education 150003000049 382 Paauilo El & Int   Regular School No Other PK 9 2019   grade_5                                                   20.0                                             20
2780843 HI     school 1500030 1   Hawaii Department of Education 150003000049 382 Paauilo El & Int   Regular School No Other PK 9 2018   grade_5                                                   19.0                                             19
2780908 HI     school 1500030 1   Hawaii Department of Education 150003000283 562 Ka Umeke Kaeo PCS charter Regular School Yes Other PK 9 2018   grade_5                                                   23.0                                             23
2780916 HI     school 1500030 1   Hawaii Department of Education 150003000302 555 Kapolei Charter School charter Regular School Yes Secondary 09 9 2018   grade_5                                                   0.0                                             0
108831 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 DOLE MID   Regular School No 2 06 8 2016   grade_5                                                   0.0                                             0
108838 HI     school 1500030 1   Hawaii Department of Education 150003000211 116 KAIMUKI MID   Regular School No 2 06 8 2016   grade_5                                                   0.0                                             0
108840 HI     school 1500030 1   Hawaii Department of Education 150003000164 118 KALAKAUA MID   Regular School No 2 06 8 2016   grade_5                                                   0.0                                             0
108851 HI     school 1500030 1   Hawaii Department of Education 150003000192 139 NIU VALLEY MID   Regular School No 2 06 8 2016   grade_5                                                   0.0                                             0
108858 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 CENTRAL MID   Regular School No 2 06 8 2016   grade_5                                                   0.0                                             0
108860 HI     school 1500030 1   Hawaii Department of Education 150003000218 110 JARRETT MID   Regular School No 2 06 8 2016   grade_5                                                   0.0                                             0
108866 HI     school 1500030 1   Hawaii Department of Education 150003000205 126 KAWANANAKOA MID   Regular School No 2 06 8 2016   grade_5                                                   0.0                                             0
108881 HI     school 1500030 1   Hawaii Department of Education 150003000184 148 STEVENSON MID   Regular School No 2 06 8 2016   grade_5                                                   0.0                                             0
108882 HI     school 1500030 1   Hawaii Department of Education 150003000180 152 WASHINGTON MID   Regular School No 2 06 8 2016   grade_5                                                   0.0                                             0
108885 HI     school 1500030 1   Hawaii Department of Education 150003000176 201 AIEA INT   Regular School No 2 07 8 2016   grade_5                                                   0.0                                             0
108887 HI     school 1500030 1   Hawaii Department of Education 150003000174 204 ALIAMANU INT   Regular School No 2 07 8 2016   grade_5                                                   0.0                                             0
108892 HI     school 1500030 1   Hawaii Department of Education 150003000156 219 MOANALUA MID   Regular School No 2 07 8 2016   grade_5                                                   0.0                                             0
108915 HI     school 1500030 1   Hawaii Department of Education 150003000256 238 MILILANI MID   Regular School No 2 06 8 2016   grade_5                                                   0.0                                             0
108920 HI     school 1500030 1   Hawaii Department of Education 150003000143 230 WAHIAWA MID   Regular School No 2 06 8 2016   grade_5                                                   0.0                                             0
108924 HI     school 1500030 1   Hawaii Department of Education 150003000137 237 WHEELER MID   Regular School No 2 06 8 2016   grade_5                                                   0.0                                             0
108929 HI     school 1500030 1   Hawaii Department of Education 150003000296 296 EWA MAKAI MID   Regular School No 2 07 8 2016   grade_5                                                   0.0                                             0
108932 HI     school 1500030 1   Hawaii Department of Education 150003000129 279 ILIMA INT   Regular School No 2 07 8 2016   grade_5                                                   0.0                                             0
108937 HI     school 1500030 1   Hawaii Department of Education 150003000259 291 KAPOLEI MID   Regular School No 2 06 8 2016   grade_5                                                   0.0                                             0
108950 HI     school 1500030 1   Hawaii Department of Education 150003000229 273 WAIANAE INT   Regular School No 2 07 8 2016   grade_5                                                   0.0                                             0
108952 HI     school 1500030 1   Hawaii Department of Education 150003000131 255 HIGHLANDS INT   Regular School No 2 07 8 2016   grade_5                                                   0.0                                             0
108967 HI     school 1500030 1   Hawaii Department of Education 150003000158 278 WAIPAHU INT   Regular School No 2 07 8 2016   grade_5                                                   0.0                                             0
108978 HI     school 1500030 1   Hawaii Department of Education 150003000016 318 KING INT   Regular School No 2 07 8 2016   grade_5                                                   0.0                                             0
108989 HI     school 1500030 1   Hawaii Department of Education 150003000010 310 KAILUA INT   Regular School No 2 07 8 2016   grade_5                                                   0.0                                             0
108997 HI     school 1500030 1   Hawaii Department of Education 150003000026 327 WAIMANALO EL & INT   Regular School No 1 PK 8 2016   grade_5                                                   35.0                                             35
109001 HI     school 1500030 1   Hawaii Department of Education 150003000030 356 HILO INT   Regular School No 2 07 8 2016   grade_5                                                   0.0                                             0
109003 HI     school 1500030 1   Hawaii Department of Education 150003000036 365 KALANIANAOLE EL & INT   Regular School No 1 PK 8 2016   grade_5                                                   22.0                                             22
109009 HI     school 1500030 1   Hawaii Department of Education 150003000053 385 WAIAKEA INT   Regular School No 2 06 8 2016   grade_5                                                   0.0                                             0
109020 HI     school 1500030 1   Hawaii Department of Education 150003000235 390 KEALAKEHE INT   Regular School No 2 06 8 2016   grade_5                                                   0.0                                             0
109023 HI     school 1500030 1   Hawaii Department of Education 150003000267 366 KOHALA MID   Regular School No 2 06 8 2016   grade_5                                                   0.0                                             0
109026 HI     school 1500030 1   Hawaii Department of Education 150003000252 376 KONAWAENA MID   Regular School No 2 06 8 2016   grade_5                                                   0.0                                             0
109028 HI     school 1500030 1   Hawaii Department of Education 150003000247 393 WAIKOLOA   Regular School No 1 PK 8 2016   grade_5                                                   70.0                                             70
109033 HI     school 1500030 1   Hawaii Department of Education 150003000040 370 KEAAU MID   Regular School No 2 06 8 2016   grade_5                                                   0.0                                             0
109041 HI     school 1500030 1   Hawaii Department of Education 150003000059 404 IAO INT   Regular School No 2 06 8 2016   grade_5                                                   0.0                                             0
109043 HI     school 1500030 1   Hawaii Department of Education 150003000233 420 KALAMA INT   Regular School No 2 06 8 2016   grade_5                                                   0.0                                             0
109049 HI     school 1500030 1   Hawaii Department of Education 150003000238 430 LOKELANI INT   Regular School No 2 06 8 2016   grade_5                                                   0.0                                             0
109052 HI     school 1500030 1   Hawaii Department of Education 150003000241 428 MAUI WAENA INT   Regular School No 2 06 8 2016   grade_5                                                   0.0                                             0
109063 HI     school 1500030 1   Hawaii Department of Education 150003000068 413 LAHAINA INT   Regular School No 2 06 8 2016   grade_5                                                   0.0                                             0
109068 HI     school 1500030 1   Hawaii Department of Education 150003000290 434 MOLOKAI MID   Regular School No 2 07 8 2016   grade_5                                                   0.0                                             0
109073 HI     school 1500030 1   Hawaii Department of Education 150003000266 448 KAMAKAHELEI MID   Regular School No 2 06 8 2016   grade_5                                                   0.0                                             0
109076 HI     school 1500030 1   Hawaii Department of Education 150003000255 447 KAPAA MID   Regular School No 2 06 8 2016   grade_5                                                   0.0                                             0
109083 HI     school 1500030 1   Hawaii Department of Education 150003000092 464 WAIMEA CANYON   Regular School No 2 06 8 2016   grade_5                                                   0.0                                             0
109092 HI     school 1500030 1   Hawaii Department of Education 150003000277 548 INNOVATIONS-PCS charter Regular School Yes 1 KG 8 2016   grade_5                                                   22.0                                             22
109094 HI     school 1500030 1   Hawaii Department of Education 150003000286 545 KA WAIHONA O KA NAAUAO-PCS charter Regular School Yes 1 KG 8 2016   grade_5                                                   66.0                                             66
109105 HI     school 1500030 1   Hawaii Department of Education 150003000293 566 KONA PACIFIC-PCS charter Regular School Yes 1 KG 8 2016   grade_5                                                   20.0                                             20
109113 HI     school 1500030 1   Hawaii Department of Education 150003000284 563 NAWAHI IKI LAB-PCS charter Regular School Yes 1 PK 8 2016   grade_5                                                   37.0                                             37
109114 HI     school 1500030 1   Hawaii Department of Education 150003000298 567 SEEQS charter Regular School Yes 2 06 8 2016   grade_5                                                   0.0                                             0
109115 HI     school 1500030 1   Hawaii Department of Education 150003000281 560 VOLCANO SCH OF A&S-PCS charter Regular School Yes 1 KG 8 2016   grade_5                                                   16.0                                             16
109116 HI     school 1500030 1   Hawaii Department of Education 150003000271 541 VOYAGER-PCS charter Regular School Yes 1 KG 8 2016   grade_5                                                   34.0                                             34
109118 HI     school 1500030 1   Hawaii Department of Education 150003000268 394 WAIMEA MID-PCCS charter Regular School Yes 2 06 8 2016   grade_5                                                   0.0                                             0
127834 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 DOLE MID   Regular School No Middle 06 8 2017   grade_5                                                   0.0                                             0
127841 HI     school 1500030 1   Hawaii Department of Education 150003000211 116 KAIMUKI MID   Regular School No Middle 06 8 2017   grade_5                                                   0.0                                             0
127843 HI     school 1500030 1   Hawaii Department of Education 150003000164 118 KALAKAUA MID   Regular School No Middle 06 8 2017   grade_5                                                   0.0                                             0
127854 HI     school 1500030 1   Hawaii Department of Education 150003000192 139 NIU VALLEY MID   Regular School No Middle 06 8 2017   grade_5                                                   0.0                                             0
127861 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 CENTRAL MID   Regular School No Middle 06 8 2017   grade_5                                                   0.0                                             0
127863 HI     school 1500030 1   Hawaii Department of Education 150003000218 110 JARRETT MID   Regular School No Middle 06 8 2017   grade_5                                                   0.0                                             0
127869 HI     school 1500030 1   Hawaii Department of Education 150003000205 126 KAWANANAKOA MID   Regular School No Middle 06 8 2017   grade_5                                                   0.0                                             0
127884 HI     school 1500030 1   Hawaii Department of Education 150003000184 148 STEVENSON MID   Regular School No Middle 06 8 2017   grade_5                                                   0.0                                             0
127885 HI     school 1500030 1   Hawaii Department of Education 150003000180 152 WASHINGTON MID   Regular School No Middle 06 8 2017   grade_5                                                   0.0                                             0
127888 HI     school 1500030 1   Hawaii Department of Education 150003000176 201 AIEA INT   Regular School No Middle 07 8 2017   grade_5                                                   0.0                                             0
127890 HI     school 1500030 1   Hawaii Department of Education 150003000174 204 ALIAMANU INT   Regular School No Middle 07 8 2017   grade_5                                                   0.0                                             0
127895 HI     school 1500030 1   Hawaii Department of Education 150003000156 219 MOANALUA MID   Regular School No Middle 07 8 2017   grade_5                                                   0.0                                             0
127918 HI     school 1500030 1   Hawaii Department of Education 150003000256 238 MILILANI MID   Regular School No Middle 06 8 2017   grade_5                                                   0.0                                             0
127923 HI     school 1500030 1   Hawaii Department of Education 150003000143 230 WAHIAWA MID   Regular School No Middle 06 8 2017   grade_5                                                   0.0                                             0
127927 HI     school 1500030 1   Hawaii Department of Education 150003000137 237 WHEELER MID   Regular School No Middle 06 8 2017   grade_5                                                   0.0                                             0
127932 HI     school 1500030 1   Hawaii Department of Education 150003000296 296 EWA MAKAI MID   Regular School No Middle 07 8 2017   grade_5                                                   0.0                                             0
127935 HI     school 1500030 1   Hawaii Department of Education 150003000129 279 ILIMA INT   Regular School No Middle 07 8 2017   grade_5                                                   0.0                                             0
127940 HI     school 1500030 1   Hawaii Department of Education 150003000259 291 KAPOLEI MID   Regular School No Middle 06 8 2017   grade_5                                                   0.0                                             0
127953 HI     school 1500030 1   Hawaii Department of Education 150003000229 273 WAIANAE INT   Regular School No Middle 07 8 2017   grade_5                                                   0.0                                             0
127955 HI     school 1500030 1   Hawaii Department of Education 150003000131 255 HIGHLANDS INT   Regular School No Middle 07 8 2017   grade_5                                                   0.0                                             0
127970 HI     school 1500030 1   Hawaii Department of Education 150003000158 278 WAIPAHU INT   Regular School No Middle 07 8 2017   grade_5                                                   0.0                                             0
127981 HI     school 1500030 1   Hawaii Department of Education 150003000016 318 KING INT   Regular School No Middle 07 8 2017   grade_5                                                   0.0                                             0
127992 HI     school 1500030 1   Hawaii Department of Education 150003000010 310 KAILUA INT   Regular School No Middle 07 8 2017   grade_5                                                   0.0                                             0
128000 HI     school 1500030 1   Hawaii Department of Education 150003000026 327 WAIMANALO EL & INT   Regular School No Elementary PK 8 2017   grade_5                                                   45.0                                             45
128004 HI     school 1500030 1   Hawaii Department of Education 150003000030 356 HILO INT   Regular School No Middle 07 8 2017   grade_5                                                   0.0                                             0
128006 HI     school 1500030 1   Hawaii Department of Education 150003000036 365 KALANIANAOLE EL & INT   Regular School No Elementary PK 8 2017   grade_5                                                   35.0                                             35
128012 HI     school 1500030 1   Hawaii Department of Education 150003000053 385 WAIAKEA INT   Regular School No Middle 06 8 2017   grade_5                                                   0.0                                             0
128023 HI     school 1500030 1   Hawaii Department of Education 150003000235 390 KEALAKEHE INT   Regular School No Middle 06 8 2017   grade_5                                                   0.0                                             0
128026 HI     school 1500030 1   Hawaii Department of Education 150003000267 366 KOHALA MID   Regular School No Middle 06 8 2017   grade_5                                                   0.0                                             0
128029 HI     school 1500030 1   Hawaii Department of Education 150003000252 376 KONAWAENA MID   Regular School No Middle 06 8 2017   grade_5                                                   0.0                                             0
128031 HI     school 1500030 1   Hawaii Department of Education 150003000247 393 WAIKOLOA   Regular School No Elementary PK 8 2017   grade_5                                                   77.0                                             77
128036 HI     school 1500030 1   Hawaii Department of Education 150003000040 370 KEAAU MID   Regular School No Middle 06 8 2017   grade_5                                                   0.0                                             0
128044 HI     school 1500030 1   Hawaii Department of Education 150003000059 404 IAO INT   Regular School No Middle 06 8 2017   grade_5                                                   0.0                                             0
128046 HI     school 1500030 1   Hawaii Department of Education 150003000233 420 KALAMA INT   Regular School No Middle 06 8 2017   grade_5                                                   0.0                                             0
128052 HI     school 1500030 1   Hawaii Department of Education 150003000238 430 LOKELANI INT   Regular School No Middle 06 8 2017   grade_5                                                   0.0                                             0
128055 HI     school 1500030 1   Hawaii Department of Education 150003000241 428 MAUI WAENA INT   Regular School No Middle 06 8 2017   grade_5                                                   0.0                                             0
128066 HI     school 1500030 1   Hawaii Department of Education 150003000068 413 LAHAINA INT   Regular School No Middle 06 8 2017   grade_5                                                   0.0                                             0
128071 HI     school 1500030 1   Hawaii Department of Education 150003000290 434 MOLOKAI MID   Regular School No Middle 07 8 2017   grade_5                                                   0.0                                             0
128076 HI     school 1500030 1   Hawaii Department of Education 150003000266 448 KAMAKAHELEI MID   Regular School No Middle 06 8 2017   grade_5                                                   0.0                                             0
128079 HI     school 1500030 1   Hawaii Department of Education 150003000255 447 KAPAA MID   Regular School No Middle 06 8 2017   grade_5                                                   0.0                                             0
128086 HI     school 1500030 1   Hawaii Department of Education 150003000092 464 WAIMEA CANYON   Regular School No Middle 06 8 2017   grade_5                                                   0.0                                             0
128095 HI     school 1500030 1   Hawaii Department of Education 150003000277 548 INNOVATIONS-PCS charter Regular School Yes Elementary KG 8 2017   grade_5                                                   26.0                                             26
128096 HI     school 1500030 1   Hawaii Department of Education 150003000283 562 KA 'UMEKE KA'EO-PCS charter Regular School Yes Elementary PK 8 2017   grade_5                                                   27.0                                             27