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
2428724 HI     school 1500030 1   Hawaii Department of Education 150003000305 568 DreamHouse Ewa Beach charter Regular School Yes Middle 06 6 2020   kindergarten                                                   0.0                                             0
2429017 HI     school 1500030 1   Hawaii Department of Education 150003000305 568 DreamHouse Ewa Beach charter Regular School Yes Middle 06 6 2020   grade_1                                                   0.0                                             0
2429310 HI     school 1500030 1   Hawaii Department of Education 150003000305 568 DreamHouse Ewa Beach charter Regular School Yes Middle 06 6 2020   grade_2                                                   0.0                                             0
2429603 HI     school 1500030 1   Hawaii Department of Education 150003000305 568 DreamHouse Ewa Beach charter Regular School Yes Middle 06 6 2020   grade_3                                                   0.0                                             0
2429896 HI     school 1500030 1   Hawaii Department of Education 150003000305 568 DreamHouse Ewa Beach charter Regular School Yes Middle 06 6 2020   grade_4                                                   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
2430482 HI     school 1500030 1   Hawaii Department of Education 150003000305 568 DreamHouse Ewa Beach charter Regular School Yes Middle 06 6 2020   grade_6                                                   77.0                                             77
2430775 HI     school 1500030 1   Hawaii Department of Education 150003000305 568 DreamHouse Ewa Beach charter Regular School Yes Middle 06 6 2020   grade_7                                                   0.0                                             0
2431068 HI     school 1500030 1   Hawaii Department of Education 150003000305 568 DreamHouse Ewa Beach charter Regular School Yes Middle 06 6 2020   grade_8                                                   0.0                                             0
2431361 HI     school 1500030 1   Hawaii Department of Education 150003000305 568 DreamHouse Ewa Beach charter Regular School Yes Middle 06 6 2020   grade_9                                                   0.0                                             0
2431654 HI     school 1500030 1   Hawaii Department of Education 150003000305 568 DreamHouse Ewa Beach charter Regular School Yes Middle 06 6 2020   grade_10                                                   0.0                                             0
2431947 HI     school 1500030 1   Hawaii Department of Education 150003000305 568 DreamHouse Ewa Beach charter Regular School Yes Middle 06 6 2020   grade_11                                                   0.0                                             0
2432240 HI     school 1500030 1   Hawaii Department of Education 150003000305 568 DreamHouse Ewa Beach charter Regular School Yes Middle 06 6 2020   grade_12                                                   0.0                                             0
2432533 HI     school 1500030 1   Hawaii Department of Education 150003000305 568 DreamHouse Ewa Beach charter Regular School Yes Middle 06 6 2020   pre_kindergarten                                                   0.0                                             0
2432826 HI     school 1500030 1   Hawaii Department of Education 150003000305 568 DreamHouse Ewa Beach charter Regular School Yes Middle 06 6 2020   pk_12_total                                               8.0   85.0                                         8   85
2428752 HI     school 1500030 1   Hawaii Department of Education 150003000298 567 SEEQS PCS charter Regular School Yes Middle 06 8 2020   kindergarten                                                   0.0                                             0
2429045 HI     school 1500030 1   Hawaii Department of Education 150003000298 567 SEEQS PCS charter Regular School Yes Middle 06 8 2020   grade_1                                                   0.0                                             0
2429338 HI     school 1500030 1   Hawaii Department of Education 150003000298 567 SEEQS PCS charter Regular School Yes Middle 06 8 2020   grade_2                                                   0.0                                             0
2429631 HI     school 1500030 1   Hawaii Department of Education 150003000298 567 SEEQS PCS charter Regular School Yes Middle 06 8 2020   grade_3                                                   0.0                                             0
2429924 HI     school 1500030 1   Hawaii Department of Education 150003000298 567 SEEQS PCS charter Regular School Yes Middle 06 8 2020   grade_4                                                   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
2430510 HI     school 1500030 1   Hawaii Department of Education 150003000298 567 SEEQS PCS charter Regular School Yes Middle 06 8 2020   grade_6                                                   51.0                                             51
2430803 HI     school 1500030 1   Hawaii Department of Education 150003000298 567 SEEQS PCS charter Regular School Yes Middle 06 8 2020   grade_7                                                   54.0                                             54
2431096 HI     school 1500030 1   Hawaii Department of Education 150003000298 567 SEEQS PCS charter Regular School Yes Middle 06 8 2020   grade_8                                                   56.0                                             56
2431389 HI     school 1500030 1   Hawaii Department of Education 150003000298 567 SEEQS PCS charter Regular School Yes Middle 06 8 2020   grade_9                                                   0.0                                             0
2431682 HI     school 1500030 1   Hawaii Department of Education 150003000298 567 SEEQS PCS charter Regular School Yes Middle 06 8 2020   grade_10                                                   0.0                                             0
2431975 HI     school 1500030 1   Hawaii Department of Education 150003000298 567 SEEQS PCS charter Regular School Yes Middle 06 8 2020   grade_11                                                   0.0                                             0
2432268 HI     school 1500030 1   Hawaii Department of Education 150003000298 567 SEEQS PCS charter Regular School Yes Middle 06 8 2020   grade_12                                                   0.0                                             0
2432561 HI     school 1500030 1   Hawaii Department of Education 150003000298 567 SEEQS PCS charter Regular School Yes Middle 06 8 2020   pre_kindergarten                                                   0.0                                             0
2432854 HI     school 1500030 1   Hawaii Department of Education 150003000298 567 SEEQS PCS charter Regular School Yes Middle 06 8 2020   pk_12_total                                               28.0   189.0                                         28   189
2428745 HI     school 1500030 1   Hawaii Department of Education 150003000293 566 Kona Pacific PCS charter Regular School Yes Elementary KG 8 2020   kindergarten                                                   12.0                                             12
2429038 HI     school 1500030 1   Hawaii Department of Education 150003000293 566 Kona Pacific PCS charter Regular School Yes Elementary KG 8 2020   grade_1                                                   21.0                                             21
2429331 HI     school 1500030 1   Hawaii Department of Education 150003000293 566 Kona Pacific PCS charter Regular School Yes Elementary KG 8 2020   grade_2                                                   23.0                                             23
2429624 HI     school 1500030 1   Hawaii Department of Education 150003000293 566 Kona Pacific PCS charter Regular School Yes Elementary KG 8 2020   grade_3                                                   18.0                                             18
2429917 HI     school 1500030 1   Hawaii Department of Education 150003000293 566 Kona Pacific PCS charter Regular School Yes Elementary KG 8 2020   grade_4                                                   24.0                                             24
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
2430503 HI     school 1500030 1   Hawaii Department of Education 150003000293 566 Kona Pacific PCS charter Regular School Yes Elementary KG 8 2020   grade_6                                                   17.0                                             17
2430796 HI     school 1500030 1   Hawaii Department of Education 150003000293 566 Kona Pacific PCS charter Regular School Yes Elementary KG 8 2020   grade_7                                                   13.0                                             13
2431089 HI     school 1500030 1   Hawaii Department of Education 150003000293 566 Kona Pacific PCS charter Regular School Yes Elementary KG 8 2020   grade_8                                                   11.0                                             11
2431382 HI     school 1500030 1   Hawaii Department of Education 150003000293 566 Kona Pacific PCS charter Regular School Yes Elementary KG 8 2020   grade_9                                                   0.0                                             0
2431675 HI     school 1500030 1   Hawaii Department of Education 150003000293 566 Kona Pacific PCS charter Regular School Yes Elementary KG 8 2020   grade_10                                                   0.0                                             0
2431968 HI     school 1500030 1   Hawaii Department of Education 150003000293 566 Kona Pacific PCS charter Regular School Yes Elementary KG 8 2020   grade_11                                                   0.0                                             0
2432261 HI     school 1500030 1   Hawaii Department of Education 150003000293 566 Kona Pacific PCS charter Regular School Yes Elementary KG 8 2020   grade_12                                                   0.0                                             0
2432554 HI     school 1500030 1   Hawaii Department of Education 150003000293 566 Kona Pacific PCS charter Regular School Yes Elementary KG 8 2020   pre_kindergarten                                                   0.0                                             0
2432847 HI     school 1500030 1   Hawaii Department of Education 150003000293 566 Kona Pacific PCS charter Regular School Yes Elementary KG 8 2020   pk_12_total                                               14.0   178.0                                         14   178
2428739 HI     school 1500030 1   Hawaii Department of Education 150003000294 565 Kawaikini NCPCS charter Regular School Yes Other KG 12 2020   kindergarten                                                   18.0                                             18
2429032 HI     school 1500030 1   Hawaii Department of Education 150003000294 565 Kawaikini NCPCS charter Regular School Yes Other KG 12 2020   grade_1                                                   20.0                                             20
2429325 HI     school 1500030 1   Hawaii Department of Education 150003000294 565 Kawaikini NCPCS charter Regular School Yes Other KG 12 2020   grade_2                                                   18.0                                             18
2429618 HI     school 1500030 1   Hawaii Department of Education 150003000294 565 Kawaikini NCPCS charter Regular School Yes Other KG 12 2020   grade_3                                                   17.0                                             17
2429911 HI     school 1500030 1   Hawaii Department of Education 150003000294 565 Kawaikini NCPCS charter Regular School Yes Other KG 12 2020   grade_4                                                   16.0                                             16
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
2430497 HI     school 1500030 1   Hawaii Department of Education 150003000294 565 Kawaikini NCPCS charter Regular School Yes Other KG 12 2020   grade_6                                                   12.0                                             12
2430790 HI     school 1500030 1   Hawaii Department of Education 150003000294 565 Kawaikini NCPCS charter Regular School Yes Other KG 12 2020   grade_7                                                   11.0                                             11
2431083 HI     school 1500030 1   Hawaii Department of Education 150003000294 565 Kawaikini NCPCS charter Regular School Yes Other KG 12 2020   grade_8                                                   11.0                                             11
2431376 HI     school 1500030 1   Hawaii Department of Education 150003000294 565 Kawaikini NCPCS charter Regular School Yes Other KG 12 2020   grade_9                                                   2.0                                             2
2431669 HI     school 1500030 1   Hawaii Department of Education 150003000294 565 Kawaikini NCPCS charter Regular School Yes Other KG 12 2020   grade_10                                                   3.0                                             3
2431962 HI     school 1500030 1   Hawaii Department of Education 150003000294 565 Kawaikini NCPCS charter Regular School Yes Other KG 12 2020   grade_11                                                   4.0                                             4
2432255 HI     school 1500030 1   Hawaii Department of Education 150003000294 565 Kawaikini NCPCS charter Regular School Yes Other KG 12 2020   grade_12                                                   5.0                                             5
2432548 HI     school 1500030 1   Hawaii Department of Education 150003000294 565 Kawaikini NCPCS charter Regular School Yes Other KG 12 2020   pre_kindergarten                                                   0.0                                             0
2432841 HI     school 1500030 1   Hawaii Department of Education 150003000294 565 Kawaikini NCPCS charter Regular School Yes Other KG 12 2020   pk_12_total                                               14.0   168.0                                         14   168
2428736 HI     school 1500030 1   Hawaii Department of Education 150003000289 564 Kanuikapono PCS charter Regular School Yes Other KG 12 2020   kindergarten                                                   23.0                                             23
2429029 HI     school 1500030 1   Hawaii Department of Education 150003000289 564 Kanuikapono PCS charter Regular School Yes Other KG 12 2020   grade_1                                                   22.0                                             22
2429322 HI     school 1500030 1   Hawaii Department of Education 150003000289 564 Kanuikapono PCS charter Regular School Yes Other KG 12 2020   grade_2                                                   22.0                                             22
2429615 HI     school 1500030 1   Hawaii Department of Education 150003000289 564 Kanuikapono PCS charter Regular School Yes Other KG 12 2020   grade_3                                                   21.0                                             21
2429908 HI     school 1500030 1   Hawaii Department of Education 150003000289 564 Kanuikapono PCS charter Regular School Yes Other KG 12 2020   grade_4                                                   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
2430494 HI     school 1500030 1   Hawaii Department of Education 150003000289 564 Kanuikapono PCS charter Regular School Yes Other KG 12 2020   grade_6                                                   16.0                                             16
2430787 HI     school 1500030 1   Hawaii Department of Education 150003000289 564 Kanuikapono PCS charter Regular School Yes Other KG 12 2020   grade_7                                                   18.0                                             18
2431080 HI     school 1500030 1   Hawaii Department of Education 150003000289 564 Kanuikapono PCS charter Regular School Yes Other KG 12 2020   grade_8                                                   15.0                                             15
2431373 HI     school 1500030 1   Hawaii Department of Education 150003000289 564 Kanuikapono PCS charter Regular School Yes Other KG 12 2020   grade_9                                                   7.0                                             7
2431666 HI     school 1500030 1   Hawaii Department of Education 150003000289 564 Kanuikapono PCS charter Regular School Yes Other KG 12 2020   grade_10                                                   15.0                                             15
2431959 HI     school 1500030 1   Hawaii Department of Education 150003000289 564 Kanuikapono PCS charter Regular School Yes Other KG 12 2020   grade_11                                                   8.0                                             8
2432252 HI     school 1500030 1   Hawaii Department of Education 150003000289 564 Kanuikapono PCS charter Regular School Yes Other KG 12 2020   grade_12                                                   4.0                                             4
2432545 HI     school 1500030 1   Hawaii Department of Education 150003000289 564 Kanuikapono PCS charter Regular School Yes Other KG 12 2020   pre_kindergarten                                                   0.0                                             0
2432838 HI     school 1500030 1   Hawaii Department of Education 150003000289 564 Kanuikapono PCS charter Regular School Yes Other KG 12 2020   pk_12_total                                               15.0   225.0                                         15   225
2428741 HI     school 1500030 1   Hawaii Department of Education 150003000284 563 Ke Kula Nawahiokalaniopuu Iki Lab PCS charter Regular School Yes Elementary PK 8 2020   kindergarten                                                   49.0                                             49
2429034 HI     school 1500030 1   Hawaii Department of Education 150003000284 563 Ke Kula Nawahiokalaniopuu Iki Lab PCS charter Regular School Yes Elementary PK 8 2020   grade_1                                                   62.0                                             62
2429327 HI     school 1500030 1   Hawaii Department of Education 150003000284 563 Ke Kula Nawahiokalaniopuu Iki Lab PCS charter Regular School Yes Elementary PK 8 2020   grade_2                                                   53.0                                             53
2429620 HI     school 1500030 1   Hawaii Department of Education 150003000284 563 Ke Kula Nawahiokalaniopuu Iki Lab PCS charter Regular School Yes Elementary PK 8 2020   grade_3                                                   61.0                                             61
2429913 HI     school 1500030 1   Hawaii Department of Education 150003000284 563 Ke Kula Nawahiokalaniopuu Iki Lab PCS charter Regular School Yes Elementary PK 8 2020   grade_4                                                   61.0                                             61
2430206 HI     school 1500030 1   Hawaii Department of Education 150003000284 563 Ke Kula Nawahiokalaniopuu Iki Lab PCS charter Regular School Yes Elementary PK 8 2020   grade_5                                                   32.0                                             32
2430499 HI     school 1500030 1   Hawaii Department of Education 150003000284 563 Ke Kula Nawahiokalaniopuu Iki Lab PCS charter Regular School Yes Elementary PK 8 2020   grade_6                                                   42.0                                             42
2430792 HI     school 1500030 1   Hawaii Department of Education 150003000284 563 Ke Kula Nawahiokalaniopuu Iki Lab PCS charter Regular School Yes Elementary PK 8 2020   grade_7                                                   45.0                                             45
2431085 HI     school 1500030 1   Hawaii Department of Education 150003000284 563 Ke Kula Nawahiokalaniopuu Iki Lab PCS charter Regular School Yes Elementary PK 8 2020   grade_8                                                   51.0                                             51
2431378 HI     school 1500030 1   Hawaii Department of Education 150003000284 563 Ke Kula Nawahiokalaniopuu Iki Lab PCS charter Regular School Yes Elementary PK 8 2020   grade_9                                                   0.0                                             0
2431671 HI     school 1500030 1   Hawaii Department of Education 150003000284 563 Ke Kula Nawahiokalaniopuu Iki Lab PCS charter Regular School Yes Elementary PK 8 2020   grade_10                                                   0.0                                             0
2431964 HI     school 1500030 1   Hawaii Department of Education 150003000284 563 Ke Kula Nawahiokalaniopuu Iki Lab PCS charter Regular School Yes Elementary PK 8 2020   grade_11                                                   0.0                                             0
2432257 HI     school 1500030 1   Hawaii Department of Education 150003000284 563 Ke Kula Nawahiokalaniopuu Iki Lab PCS charter Regular School Yes Elementary PK 8 2020   grade_12                                                   0.0                                             0
2432550 HI     school 1500030 1   Hawaii Department of Education 150003000284 563 Ke Kula Nawahiokalaniopuu Iki Lab PCS charter Regular School Yes Elementary PK 8 2020   pre_kindergarten                                                   0.0                                             0
2432843 HI     school 1500030 1   Hawaii Department of Education 150003000284 563 Ke Kula Nawahiokalaniopuu Iki Lab PCS charter Regular School Yes Elementary PK 8 2020   pk_12_total                                               7.0   463.0                                         7   463
2428730 HI     school 1500030 1   Hawaii Department of Education 150003000283 562 Ka Umeke Kaeo PCS charter Regular School Yes Other PK 11 2020   kindergarten                                                   34.0                                             34
2429023 HI     school 1500030 1   Hawaii Department of Education 150003000283 562 Ka Umeke Kaeo PCS charter Regular School Yes Other PK 11 2020   grade_1                                                   27.0                                             27
2429316 HI     school 1500030 1   Hawaii Department of Education 150003000283 562 Ka Umeke Kaeo PCS charter Regular School Yes Other PK 11 2020   grade_2                                                   28.0                                             28
2429609 HI     school 1500030 1   Hawaii Department of Education 150003000283 562 Ka Umeke Kaeo PCS charter Regular School Yes Other PK 11 2020   grade_3                                                   22.0                                             22
2429902 HI     school 1500030 1   Hawaii Department of Education 150003000283 562 Ka Umeke Kaeo PCS charter Regular School Yes Other PK 11 2020   grade_4                                                   26.0                                             26
2430195 HI     school 1500030 1   Hawaii Department of Education 150003000283 562 Ka Umeke Kaeo PCS charter Regular School Yes Other PK 11 2020   grade_5                                                   13.0                                             13
2430488 HI     school 1500030 1   Hawaii Department of Education 150003000283 562 Ka Umeke Kaeo PCS charter Regular School Yes Other PK 11 2020   grade_6                                                   15.0                                             15
2430781 HI     school 1500030 1   Hawaii Department of Education 150003000283 562 Ka Umeke Kaeo PCS charter Regular School Yes Other PK 11 2020   grade_7                                                   19.0                                             19
2431074 HI     school 1500030 1   Hawaii Department of Education 150003000283 562 Ka Umeke Kaeo PCS charter Regular School Yes Other PK 11 2020   grade_8                                                   8.0                                             8
2431367 HI     school 1500030 1   Hawaii Department of Education 150003000283 562 Ka Umeke Kaeo PCS charter Regular School Yes Other PK 11 2020   grade_9                                                   6.0                                             6
2431660 HI     school 1500030 1   Hawaii Department of Education 150003000283 562 Ka Umeke Kaeo PCS charter Regular School Yes Other PK 11 2020   grade_10                                                   2.0                                             2