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
2454718 HI     school 1500030 1   Hawaii Department of Education 150003000306 297 Honouliuli Middle   Regular School No Middle 06 6 2021   grade_5                                                   0.0                                             0
2430189 HI     school 1500030 1   Hawaii Department of Education 150003000305 568 DreamHouse Ewa Beach charter Regular School Yes Middle 06 6 2020   grade_5                                                   0.0                                             0
2454876 HI     school 1500030 1   Hawaii Department of Education 150003000305 568 DreamHouse Ewa Beach charter Regular School Yes Middle 06 7 2021   grade_5                                                   0.0                                             0
2430187 HI     school 1500030 1   Hawaii Department of Education 150003000304 558 Alakai O Kauai PCS charter Regular School Yes Elementary KG 6 2020   grade_5                                                   16.0                                             16
2454874 HI     school 1500030 1   Hawaii Department of Education 150003000304 558 Alakai O Kauai PCS charter Regular School Yes Elementary KG 6 2021   grade_5                                                   25.0                                             25
2735879 HI     school 1500030 1   Hawaii Department of Education 150003000304 558 Alakai O Kauai PCS charter Regular School Yes Elementary KG 5 2019   grade_5                                                   16.0                                             16
2430198 HI     school 1500030 1   Hawaii Department of Education 150003000303 553 Kamalani Academy charter Regular School Yes Elementary PK 8 2020   grade_5                                                   14.0                                             14
2454885 HI     school 1500030 1   Hawaii Department of Education 150003000303 553 Kamalani Academy charter Regular School Yes Elementary PK 8 2021   grade_5                                                   21.0                                             21
2735874 HI     school 1500030 1   Hawaii Department of Education 150003000303 553 Kamalani Academy charter Regular School Yes Elementary PK 8 2019   grade_5                                                   35.0                                             35
2780911 HI     school 1500030 1   Hawaii Department of Education 150003000303 553 Kamalani Academy charter Regular School Yes Elementary PK 8 2018   grade_5                                                   20.0                                             20
2430203 HI     school 1500030 1   Hawaii Department of Education 150003000302 555 Kapolei Charter School charter Regular School Yes Secondary 09 11 2020   grade_5                                                   0.0                                             0
2454890 HI     school 1500030 1   Hawaii Department of Education 150003000302 555 Kapolei Charter School charter Regular School Yes High 09 12 2021   grade_5                                                   0.0                                             0
2735876 HI     school 1500030 1   Hawaii Department of Education 150003000302 555 Kapolei Charter School charter Regular School Yes Secondary 09 10 2019   grade_5                                                   0.0                                             0
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
109099 HI     school 1500030 1   Hawaii Department of Education 150003000301 552 KAU LEARNING ACAD-PCS charter Regular School Yes 1 03 6 2016   grade_5                                                   29.0                                             29
128102 HI     school 1500030 1   Hawaii Department of Education 150003000301 552 KAU LEARNING ACAD-PCS charter Regular School Yes Elementary 03 7 2017   grade_5                                                   23.0                                             23
2780917 HI     school 1500030 1   Hawaii Department of Education 150003000301 552 Kau Learning Academy charter Regular School Yes Middle 03 7 2018   grade_5                                                   15.0                                             15
108931 HI     school 1500030 1   Hawaii Department of Education 150003000300 293 HOOKELE EL   Regular School No 1 PK 5 2016   grade_5                                                   34.0                                             34
127934 HI     school 1500030 1   Hawaii Department of Education 150003000300 293 HOOKELE EL   Regular School No Elementary PK 5 2017   grade_5                                                   106.0                                             106
2430032 HI     school 1500030 1   Hawaii Department of Education 150003000300 293 Hookele Elem   Regular School No Elementary PK 5 2020   grade_5                                                   77.0                                             77
2454719 HI     school 1500030 1   Hawaii Department of Education 150003000300 293 Hookele Elem   Regular School No Elementary PK 5 2021   grade_5                                                   144.0                                             144
2735697 HI     school 1500030 1   Hawaii Department of Education 150003000300 293 Hookele Elem   Regular School No Elementary PK 5 2019   grade_5                                                   130.0                                             130
2780747 HI     school 1500030 1   Hawaii Department of Education 150003000300 293 Hookele Elem   Regular School No Elementary PK 5 2018   grade_5                                                   94.0                                             94
109110 HI     school 1500030 1   Hawaii Department of Education 150003000299 550 MALAMA HONUA PCS charter Regular School Yes 1 KG 3 2016   grade_5                                                   0.0                                             0
128113 HI     school 1500030 1   Hawaii Department of Education 150003000299 550 MALAMA HONUA PCS charter Regular School Yes Elementary KG 4 2017   grade_5                                                   0.0                                             0
279089 HI     school 1500030 1   Hawaii Department of Education 150003000299 550 MALAMA HONUA PCS charter Regular School Yes 1 KG 2 2015   grade_5                                                   0.0                                             0
2430214 HI     school 1500030 1   Hawaii Department of Education 150003000299 550 Malama Honua charter Regular School Yes Elementary KG 7 2020   grade_5                                                   18.0                                             18
2454901 HI     school 1500030 1   Hawaii Department of Education 150003000299 550 Malama Honua PCS charter Regular School Yes Elementary KG 8 2021   grade_5                                                   16.0                                             16
2735872 HI     school 1500030 1   Hawaii Department of Education 150003000299 550 Malama Honua charter Regular School Yes Elementary KG 6 2019   grade_5                                                   9.0                                             9
2780928 HI     school 1500030 1   Hawaii Department of Education 150003000299 550 Malama Honua charter Regular School Yes Elementary KG 5 2018   grade_5                                                   13.0                                             13
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
128117 HI     school 1500030 1   Hawaii Department of Education 150003000298 567 SEEQS charter Regular School Yes Middle 06 8 2017   grade_5                                                   0.0                                             0
279101 HI     school 1500030 1   Hawaii Department of Education 150003000298 567 SEEQS charter Regular School Yes 2 06 8 2015   grade_5                                                   0.0                                             0
2430217 HI     school 1500030 1   Hawaii Department of Education 150003000298 567 SEEQS PCS charter Regular School Yes Middle 06 8 2020   grade_5                                                   0.0                                             0
2454904 HI     school 1500030 1   Hawaii Department of Education 150003000298 567 SEEQS PCS charter Regular School Yes Middle 06 8 2021   grade_5                                                   0.0                                             0
2735887 HI     school 1500030 1   Hawaii Department of Education 150003000298 567 SEEQS PCS charter Regular School Yes Middle 06 8 2019   grade_5                                                   0.0                                             0
2780931 HI     school 1500030 1   Hawaii Department of Education 150003000298 567 SEEQS PCS charter Regular School Yes Middle 06 8 2018   grade_5                                                   0.0                                             0
109056 HI     school 1500030 1   Hawaii Department of Education 150003000297 436 PUU KUKUI   Regular School No 1 PK 5 2016   grade_5                                                   80.0                                             80
128059 HI     school 1500030 1   Hawaii Department of Education 150003000297 436 PUU KUKUI   Regular School No Elementary PK 5 2017   grade_5                                                   82.0                                             82
279038 HI     school 1500030 1   Hawaii Department of Education 150003000297 436 PUU KUKUI   Regular School No 1 PK 5 2015   grade_5                                                   94.0                                             94
2430157 HI     school 1500030 1   Hawaii Department of Education 150003000297 436 Puu Kukui Elem   Regular School No Elementary PK 5 2020   grade_5                                                   100.0                                             100
2454844 HI     school 1500030 1   Hawaii Department of Education 150003000297 436 Puu Kukui Elem   Regular School No Elementary PK 5 2021   grade_5                                                   108.0                                             108
2735822 HI     school 1500030 1   Hawaii Department of Education 150003000297 436 Puu Kukui Elem   Regular School No Elementary PK 5 2019   grade_5                                                   120.0                                             120
2780872 HI     school 1500030 1   Hawaii Department of Education 150003000297 436 Puu Kukui Elem   Regular School No Elementary PK 5 2018   grade_5                                                   130.0                                             130
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
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
278912 HI     school 1500030 1   Hawaii Department of Education 150003000296 296 EWA MAKAI MID   Regular School No 2 07 8 2015   grade_5                                                   0.0                                             0
2430030 HI     school 1500030 1   Hawaii Department of Education 150003000296 296 Ewa Makai Middle   Regular School No Middle 06 8 2020   grade_5                                                   0.0                                             0
2454716 HI     school 1500030 1   Hawaii Department of Education 150003000296 296 Ewa Makai Middle   Regular School No Middle 06 8 2021   grade_5                                                   0.0                                             0
2735695 HI     school 1500030 1   Hawaii Department of Education 150003000296 296 Ewa Makai Middle   Regular School No Middle 07 8 2019   grade_5                                                   0.0                                             0
2780745 HI     school 1500030 1   Hawaii Department of Education 150003000296 296 Ewa Makai Middle   Regular School No Middle 07 8 2018   grade_5                                                   0.0                                             0
109090 HI     school 1500030 1   Hawaii Department of Education 150003000295 551 HAWAII TECHNOLOGY ACADEMY charter Regular School Yes 4 KG 12 2016   grade_5                                                   76.0                                             76
128093 HI     school 1500030 1   Hawaii Department of Education 150003000295 551 HAWAII TECHNOLOGY ACADEMY charter Regular School Yes Other KG 12 2017   grade_5                                                   64.0                                             64
279090 HI     school 1500030 1   Hawaii Department of Education 150003000295 551 HAWAII TECHNOLOGY ACADEMY charter Regular School Yes 4 KG 12 2015   grade_5                                                   90.0                                             90
2430193 HI     school 1500030 1   Hawaii Department of Education 150003000295 551 Hawaii Tech Acad PCS charter Regular School Yes Other KG 12 2020   grade_5                                                   53.0                                             53
2454880 HI     school 1500030 1   Hawaii Department of Education 150003000295 551 Hawaii Tech Academy PCS charter Regular School Yes Other KG 12 2021   grade_5                                                   45.0                                             45
2735873 HI     school 1500030 1   Hawaii Department of Education 150003000295 551 Hawaii Tech Acad PCS charter Regular School Yes Other KG 12 2019   grade_5                                                   66.0                                             66
2780906 HI     school 1500030 1   Hawaii Department of Education 150003000295 551 Hawaii Tech Acad PCS charter Regular School Yes Other KG 12 2018   grade_5                                                   60.0                                             60
109100 HI     school 1500030 1   Hawaii Department of Education 150003000294 565 KAWAIKINI-PCS charter Regular School Yes 4 KG 12 2016   grade_5                                                   9.0                                             9
128103 HI     school 1500030 1   Hawaii Department of Education 150003000294 565 KAWAIKINI-PCS charter Regular School Yes Other KG 12 2017   grade_5                                                   16.0                                             16
279099 HI     school 1500030 1   Hawaii Department of Education 150003000294 565 KAWAIKINI-PCS charter Regular School Yes 4 KG 12 2015   grade_5                                                   9.0                                             9
2430204 HI     school 1500030 1   Hawaii Department of Education 150003000294 565 Kawaikini NCPCS charter Regular School Yes Other KG 12 2020   grade_5                                                   17.0                                             17
2454891 HI     school 1500030 1   Hawaii Department of Education 150003000294 565 Kawaikini NCPCS charter Regular School Yes Other KG 12 2021   grade_5                                                   15.0                                             15
2735885 HI     school 1500030 1   Hawaii Department of Education 150003000294 565 Kawaikini NCPCS charter Regular School Yes Other KG 12 2019   grade_5                                                   13.0                                             13
2780918 HI     school 1500030 1   Hawaii Department of Education 150003000294 565 Kawaikini NCPCS charter Regular School Yes Other KG 12 2018   grade_5                                                   11.0                                             11
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
128108 HI     school 1500030 1   Hawaii Department of Education 150003000293 566 KONA PACIFIC-PCS charter Regular School Yes Elementary KG 8 2017   grade_5                                                   19.0                                             19
279100 HI     school 1500030 1   Hawaii Department of Education 150003000293 566 KONA PACIFIC-PCS charter Regular School Yes 1 KG 8 2015   grade_5                                                   17.0                                             17
2430210 HI     school 1500030 1   Hawaii Department of Education 150003000293 566 Kona Pacific PCS charter Regular School Yes Elementary KG 8 2020   grade_5                                                   25.0                                             25
2454897 HI     school 1500030 1   Hawaii Department of Education 150003000293 566 Kona Pacific PCS charter Regular School Yes Elementary KG 8 2021   grade_5                                                   26.0                                             26
2735886 HI     school 1500030 1   Hawaii Department of Education 150003000293 566 Kona Pacific PCS charter Regular School Yes Elementary KG 8 2019   grade_5                                                   26.0                                             26
2780924 HI     school 1500030 1   Hawaii Department of Education 150003000293 566 Kona Pacific PCS charter Regular School Yes Elementary KG 8 2018   grade_5                                                   21.0                                             21
109054 HI     school 1500030 1   Hawaii Department of Education 150003000292 433 POMAIKAI   Regular School No 1 PK 5 2016   grade_5                                                   92.0                                             92
128057 HI     school 1500030 1   Hawaii Department of Education 150003000292 433 POMAIKAI   Regular School No Elementary PK 5 2017   grade_5                                                   85.0                                             85
279036 HI     school 1500030 1   Hawaii Department of Education 150003000292 433 POMAIKAI   Regular School No 1 PK 5 2015   grade_5                                                   71.0                                             71
2430155 HI     school 1500030 1   Hawaii Department of Education 150003000292 433 Pomaikai Elem   Regular School No Elementary PK 5 2020   grade_5                                                   73.0                                             73
2454842 HI     school 1500030 1   Hawaii Department of Education 150003000292 433 Pomaikai Elem   Regular School No Elementary PK 5 2021   grade_5                                                   106.0                                             106
2735820 HI     school 1500030 1   Hawaii Department of Education 150003000292 433 Pomaikai Elem   Regular School No Elementary PK 5 2019   grade_5                                                   84.0                                             84
2780870 HI     school 1500030 1   Hawaii Department of Education 150003000292 433 Pomaikai Elem   Regular School No Elementary PK 5 2018   grade_5                                                   107.0                                             107
108938 HI     school 1500030 1   Hawaii Department of Education 150003000291 294 KEONEULA   Regular School No 1 PK 6 2016   grade_5                                                   116.0                                             116
127941 HI     school 1500030 1   Hawaii Department of Education 150003000291 294 KEONEULA   Regular School No Elementary PK 6 2017   grade_5                                                   129.0                                             129
278920 HI     school 1500030 1   Hawaii Department of Education 150003000291 294 KEONEULA   Regular School No 1 PK 6 2015   grade_5                                                   140.0                                             140
2430039 HI     school 1500030 1   Hawaii Department of Education 150003000291 294 Keoneula Elem   Regular School No Elementary PK 6 2020   grade_5                                                   106.0                                             106
2454726 HI     school 1500030 1   Hawaii Department of Education 150003000291 294 Keoneula Elem   Regular School No Elementary PK 5 2021   grade_5                                                   156.0                                             156
2735704 HI     school 1500030 1   Hawaii Department of Education 150003000291 294 Keoneula Elem   Regular School No Elementary PK 6 2019   grade_5                                                   161.0                                             161
2780754 HI     school 1500030 1   Hawaii Department of Education 150003000291 294 Keoneula Elem   Regular School No Elementary PK 6 2018   grade_5                                                   139.0                                             139
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
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
279050 HI     school 1500030 1   Hawaii Department of Education 150003000290 434 MOLOKAI MID   Regular School No 2 07 8 2015   grade_5                                                   0.0                                             0
2430169 HI     school 1500030 1   Hawaii Department of Education 150003000290 434 Molokai Middle   Regular School No Middle 07 8 2020   grade_5                                                   0.0                                             0
2454856 HI     school 1500030 1   Hawaii Department of Education 150003000290 434 Molokai Middle   Regular School No Middle 07 8 2021   grade_5                                                   0.0                                             0
2735834 HI     school 1500030 1   Hawaii Department of Education 150003000290 434 Molokai Middle   Regular School No Middle 07 8 2019   grade_5                                                   0.0                                             0
2780884 HI     school 1500030 1   Hawaii Department of Education 150003000290 434 Molokai Middle   Regular School No Middle 07 8 2018   grade_5                                                   0.0                                             0
109098 HI     school 1500030 1   Hawaii Department of Education 150003000289 564 KANUIKAPONO-PCS charter Regular School Yes 4 KG 12 2016   grade_5                                                   17.0                                             17
128101 HI     school 1500030 1   Hawaii Department of Education 150003000289 564 KANUIKAPONO-PCS charter Regular School Yes Other KG 12 2017   grade_5                                                   18.0                                             18
279098 HI     school 1500030 1   Hawaii Department of Education 150003000289 564 KANUIKAPONO-PCS charter Regular School Yes 4 KG 12 2015   grade_5                                                   19.0                                             19
2430201 HI     school 1500030 1   Hawaii Department of Education 150003000289 564 Kanuikapono PCS charter Regular School Yes Other KG 12 2020   grade_5                                                   20.0                                             20
2454888 HI     school 1500030 1   Hawaii Department of Education 150003000289 564 Kanuikapono PCS charter Regular School Yes Other KG 12 2021   grade_5                                                   18.0                                             18
2735884 HI     school 1500030 1   Hawaii Department of Education 150003000289 564 Kanuikapono PCS charter Regular School Yes Other KG 12 2019   grade_5                                                   16.0                                             16
2780914 HI     school 1500030 1   Hawaii Department of Education 150003000289 564 Kanuikapono PCS charter Regular School Yes Other KG 12 2018   grade_5                                                   17.0                                             17
109106 HI     school 1500030 1   Hawaii Department of Education 150003000288 557 KUA O KA LA-PCS charter Regular School Yes 4 KG 12 2016   grade_5                                                   15.0                                             15