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
2453406 HI     school 1500030 1   Hawaii Department of Education 150003000305 568 DreamHouse Ewa Beach charter Regular School Yes Middle 06 7 2021   kindergarten                                                   0.0                                             0
2453700 HI     school 1500030 1   Hawaii Department of Education 150003000305 568 DreamHouse Ewa Beach charter Regular School Yes Middle 06 7 2021   grade_1                                                   0.0                                             0
2453994 HI     school 1500030 1   Hawaii Department of Education 150003000305 568 DreamHouse Ewa Beach charter Regular School Yes Middle 06 7 2021   grade_2                                                   0.0                                             0
2454288 HI     school 1500030 1   Hawaii Department of Education 150003000305 568 DreamHouse Ewa Beach charter Regular School Yes Middle 06 7 2021   grade_3                                                   0.0                                             0
2454582 HI     school 1500030 1   Hawaii Department of Education 150003000305 568 DreamHouse Ewa Beach charter Regular School Yes Middle 06 7 2021   grade_4                                                   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
2455170 HI     school 1500030 1   Hawaii Department of Education 150003000305 568 DreamHouse Ewa Beach charter Regular School Yes Middle 06 7 2021   grade_6                                                   84.0                                             84
2455464 HI     school 1500030 1   Hawaii Department of Education 150003000305 568 DreamHouse Ewa Beach charter Regular School Yes Middle 06 7 2021   grade_7                                                   90.0                                             90
2455758 HI     school 1500030 1   Hawaii Department of Education 150003000305 568 DreamHouse Ewa Beach charter Regular School Yes Middle 06 7 2021   grade_8                                                   0.0                                             0
2456052 HI     school 1500030 1   Hawaii Department of Education 150003000305 568 DreamHouse Ewa Beach charter Regular School Yes Middle 06 7 2021   grade_9                                                   0.0                                             0
2456346 HI     school 1500030 1   Hawaii Department of Education 150003000305 568 DreamHouse Ewa Beach charter Regular School Yes Middle 06 7 2021   grade_10                                                   0.0                                             0
2456640 HI     school 1500030 1   Hawaii Department of Education 150003000305 568 DreamHouse Ewa Beach charter Regular School Yes Middle 06 7 2021   grade_11                                                   0.0                                             0
2456934 HI     school 1500030 1   Hawaii Department of Education 150003000305 568 DreamHouse Ewa Beach charter Regular School Yes Middle 06 7 2021   grade_12                                                   0.0                                             0
2457228 HI     school 1500030 1   Hawaii Department of Education 150003000305 568 DreamHouse Ewa Beach charter Regular School Yes Middle 06 7 2021   pre_kindergarten                                                   0.0                                             0
2457522 HI     school 1500030 1   Hawaii Department of Education 150003000305 568 DreamHouse Ewa Beach charter Regular School Yes Middle 06 7 2021   pk_12_total                                               18.0   192.0                                         18   192
2453434 HI     school 1500030 1   Hawaii Department of Education 150003000298 567 SEEQS PCS charter Regular School Yes Middle 06 8 2021   kindergarten                                                   0.0                                             0
2453728 HI     school 1500030 1   Hawaii Department of Education 150003000298 567 SEEQS PCS charter Regular School Yes Middle 06 8 2021   grade_1                                                   0.0                                             0
2454022 HI     school 1500030 1   Hawaii Department of Education 150003000298 567 SEEQS PCS charter Regular School Yes Middle 06 8 2021   grade_2                                                   0.0                                             0
2454316 HI     school 1500030 1   Hawaii Department of Education 150003000298 567 SEEQS PCS charter Regular School Yes Middle 06 8 2021   grade_3                                                   0.0                                             0
2454610 HI     school 1500030 1   Hawaii Department of Education 150003000298 567 SEEQS PCS charter Regular School Yes Middle 06 8 2021   grade_4                                                   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
2455198 HI     school 1500030 1   Hawaii Department of Education 150003000298 567 SEEQS PCS charter Regular School Yes Middle 06 8 2021   grade_6                                                   51.0                                             51
2455492 HI     school 1500030 1   Hawaii Department of Education 150003000298 567 SEEQS PCS charter Regular School Yes Middle 06 8 2021   grade_7                                                   49.0                                             49
2455786 HI     school 1500030 1   Hawaii Department of Education 150003000298 567 SEEQS PCS charter Regular School Yes Middle 06 8 2021   grade_8                                                   51.0                                             51
2456080 HI     school 1500030 1   Hawaii Department of Education 150003000298 567 SEEQS PCS charter Regular School Yes Middle 06 8 2021   grade_9                                                   0.0                                             0
2456374 HI     school 1500030 1   Hawaii Department of Education 150003000298 567 SEEQS PCS charter Regular School Yes Middle 06 8 2021   grade_10                                                   0.0                                             0
2456668 HI     school 1500030 1   Hawaii Department of Education 150003000298 567 SEEQS PCS charter Regular School Yes Middle 06 8 2021   grade_11                                                   0.0                                             0
2456962 HI     school 1500030 1   Hawaii Department of Education 150003000298 567 SEEQS PCS charter Regular School Yes Middle 06 8 2021   grade_12                                                   0.0                                             0
2457256 HI     school 1500030 1   Hawaii Department of Education 150003000298 567 SEEQS PCS charter Regular School Yes Middle 06 8 2021   pre_kindergarten                                                   0.0                                             0
2457550 HI     school 1500030 1   Hawaii Department of Education 150003000298 567 SEEQS PCS charter Regular School Yes Middle 06 8 2021   pk_12_total                                               23.0   174.0                                         23   174
2453427 HI     school 1500030 1   Hawaii Department of Education 150003000293 566 Kona Pacific PCS charter Regular School Yes Elementary KG 8 2021   kindergarten                                                   31.0                                             31
2453721 HI     school 1500030 1   Hawaii Department of Education 150003000293 566 Kona Pacific PCS charter Regular School Yes Elementary KG 8 2021   grade_1                                                   25.0                                             25
2454015 HI     school 1500030 1   Hawaii Department of Education 150003000293 566 Kona Pacific PCS charter Regular School Yes Elementary KG 8 2021   grade_2                                                   22.0                                             22
2454309 HI     school 1500030 1   Hawaii Department of Education 150003000293 566 Kona Pacific PCS charter Regular School Yes Elementary KG 8 2021   grade_3                                                   25.0                                             25
2454603 HI     school 1500030 1   Hawaii Department of Education 150003000293 566 Kona Pacific PCS charter Regular School Yes Elementary KG 8 2021   grade_4                                                   21.0                                             21
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
2455191 HI     school 1500030 1   Hawaii Department of Education 150003000293 566 Kona Pacific PCS charter Regular School Yes Elementary KG 8 2021   grade_6                                                   20.0                                             20
2455485 HI     school 1500030 1   Hawaii Department of Education 150003000293 566 Kona Pacific PCS charter Regular School Yes Elementary KG 8 2021   grade_7                                                   20.0                                             20
2455779 HI     school 1500030 1   Hawaii Department of Education 150003000293 566 Kona Pacific PCS charter Regular School Yes Elementary KG 8 2021   grade_8                                                   14.0                                             14
2456073 HI     school 1500030 1   Hawaii Department of Education 150003000293 566 Kona Pacific PCS charter Regular School Yes Elementary KG 8 2021   grade_9                                                   0.0                                             0
2456367 HI     school 1500030 1   Hawaii Department of Education 150003000293 566 Kona Pacific PCS charter Regular School Yes Elementary KG 8 2021   grade_10                                                   0.0                                             0
2456661 HI     school 1500030 1   Hawaii Department of Education 150003000293 566 Kona Pacific PCS charter Regular School Yes Elementary KG 8 2021   grade_11                                                   0.0                                             0
2456955 HI     school 1500030 1   Hawaii Department of Education 150003000293 566 Kona Pacific PCS charter Regular School Yes Elementary KG 8 2021   grade_12                                                   0.0                                             0
2457249 HI     school 1500030 1   Hawaii Department of Education 150003000293 566 Kona Pacific PCS charter Regular School Yes Elementary KG 8 2021   pre_kindergarten                                                   0.0                                             0
2457543 HI     school 1500030 1   Hawaii Department of Education 150003000293 566 Kona Pacific PCS charter Regular School Yes Elementary KG 8 2021   pk_12_total                                               7.0   211.0                                         7   211
2453421 HI     school 1500030 1   Hawaii Department of Education 150003000294 565 Kawaikini NCPCS charter Regular School Yes Other KG 12 2021   kindergarten                                                   20.0                                             20
2453715 HI     school 1500030 1   Hawaii Department of Education 150003000294 565 Kawaikini NCPCS charter Regular School Yes Other KG 12 2021   grade_1                                                   18.0                                             18
2454009 HI     school 1500030 1   Hawaii Department of Education 150003000294 565 Kawaikini NCPCS charter Regular School Yes Other KG 12 2021   grade_2                                                   20.0                                             20
2454303 HI     school 1500030 1   Hawaii Department of Education 150003000294 565 Kawaikini NCPCS charter Regular School Yes Other KG 12 2021   grade_3                                                   19.0                                             19
2454597 HI     school 1500030 1   Hawaii Department of Education 150003000294 565 Kawaikini NCPCS charter Regular School Yes Other KG 12 2021   grade_4                                                   14.0                                             14
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
2455185 HI     school 1500030 1   Hawaii Department of Education 150003000294 565 Kawaikini NCPCS charter Regular School Yes Other KG 12 2021   grade_6                                                   13.0                                             13
2455479 HI     school 1500030 1   Hawaii Department of Education 150003000294 565 Kawaikini NCPCS charter Regular School Yes Other KG 12 2021   grade_7                                                   11.0                                             11
2455773 HI     school 1500030 1   Hawaii Department of Education 150003000294 565 Kawaikini NCPCS charter Regular School Yes Other KG 12 2021   grade_8                                                   11.0                                             11
2456067 HI     school 1500030 1   Hawaii Department of Education 150003000294 565 Kawaikini NCPCS charter Regular School Yes Other KG 12 2021   grade_9                                                   6.0                                             6
2456361 HI     school 1500030 1   Hawaii Department of Education 150003000294 565 Kawaikini NCPCS charter Regular School Yes Other KG 12 2021   grade_10                                                   2.0                                             2
2456655 HI     school 1500030 1   Hawaii Department of Education 150003000294 565 Kawaikini NCPCS charter Regular School Yes Other KG 12 2021   grade_11                                                   2.0                                             2
2456949 HI     school 1500030 1   Hawaii Department of Education 150003000294 565 Kawaikini NCPCS charter Regular School Yes Other KG 12 2021   grade_12                                                   3.0                                             3
2457243 HI     school 1500030 1   Hawaii Department of Education 150003000294 565 Kawaikini NCPCS charter Regular School Yes Other KG 12 2021   pre_kindergarten                                                   0.0                                             0
2457537 HI     school 1500030 1   Hawaii Department of Education 150003000294 565 Kawaikini NCPCS charter Regular School Yes Other KG 12 2021   pk_12_total                                               13.0   167.0                                         13   167
2453418 HI     school 1500030 1   Hawaii Department of Education 150003000289 564 Kanuikapono PCS charter Regular School Yes Other KG 12 2021   kindergarten                                                   19.0                                             19
2453712 HI     school 1500030 1   Hawaii Department of Education 150003000289 564 Kanuikapono PCS charter Regular School Yes Other KG 12 2021   grade_1                                                   26.0                                             26
2454006 HI     school 1500030 1   Hawaii Department of Education 150003000289 564 Kanuikapono PCS charter Regular School Yes Other KG 12 2021   grade_2                                                   22.0                                             22
2454300 HI     school 1500030 1   Hawaii Department of Education 150003000289 564 Kanuikapono PCS charter Regular School Yes Other KG 12 2021   grade_3                                                   22.0                                             22
2454594 HI     school 1500030 1   Hawaii Department of Education 150003000289 564 Kanuikapono PCS charter Regular School Yes Other KG 12 2021   grade_4                                                   22.0                                             22
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
2455182 HI     school 1500030 1   Hawaii Department of Education 150003000289 564 Kanuikapono PCS charter Regular School Yes Other KG 12 2021   grade_6                                                   20.0                                             20
2455476 HI     school 1500030 1   Hawaii Department of Education 150003000289 564 Kanuikapono PCS charter Regular School Yes Other KG 12 2021   grade_7                                                   19.0                                             19
2455770 HI     school 1500030 1   Hawaii Department of Education 150003000289 564 Kanuikapono PCS charter Regular School Yes Other KG 12 2021   grade_8                                                   17.0                                             17
2456064 HI     school 1500030 1   Hawaii Department of Education 150003000289 564 Kanuikapono PCS charter Regular School Yes Other KG 12 2021   grade_9                                                   9.0                                             9
2456358 HI     school 1500030 1   Hawaii Department of Education 150003000289 564 Kanuikapono PCS charter Regular School Yes Other KG 12 2021   grade_10                                                   6.0                                             6
2456652 HI     school 1500030 1   Hawaii Department of Education 150003000289 564 Kanuikapono PCS charter Regular School Yes Other KG 12 2021   grade_11                                                   8.0                                             8
2456946 HI     school 1500030 1   Hawaii Department of Education 150003000289 564 Kanuikapono PCS charter Regular School Yes Other KG 12 2021   grade_12                                                   10.0                                             10
2457240 HI     school 1500030 1   Hawaii Department of Education 150003000289 564 Kanuikapono PCS charter Regular School Yes Other KG 12 2021   pre_kindergarten                                                   0.0                                             0
2457534 HI     school 1500030 1   Hawaii Department of Education 150003000289 564 Kanuikapono PCS charter Regular School Yes Other KG 12 2021   pk_12_total                                               15.0   233.0                                         15   233
2453423 HI     school 1500030 1   Hawaii Department of Education 150003000284 563 Ke Kula Nawahiokalaniopuu Iki Lab PCS charter Regular School Yes Elementary PK 8 2021   kindergarten                                                   70.0                                             70
2453717 HI     school 1500030 1   Hawaii Department of Education 150003000284 563 Ke Kula Nawahiokalaniopuu Iki Lab PCS charter Regular School Yes Elementary PK 8 2021   grade_1                                                   45.0                                             45
2454011 HI     school 1500030 1   Hawaii Department of Education 150003000284 563 Ke Kula Nawahiokalaniopuu Iki Lab PCS charter Regular School Yes Elementary PK 8 2021   grade_2                                                   58.0                                             58
2454305 HI     school 1500030 1   Hawaii Department of Education 150003000284 563 Ke Kula Nawahiokalaniopuu Iki Lab PCS charter Regular School Yes Elementary PK 8 2021   grade_3                                                   55.0                                             55
2454599 HI     school 1500030 1   Hawaii Department of Education 150003000284 563 Ke Kula Nawahiokalaniopuu Iki Lab PCS charter Regular School Yes Elementary PK 8 2021   grade_4                                                   60.0                                             60
2454893 HI     school 1500030 1   Hawaii Department of Education 150003000284 563 Ke Kula Nawahiokalaniopuu Iki Lab PCS charter Regular School Yes Elementary PK 8 2021   grade_5                                                   60.0                                             60
2455187 HI     school 1500030 1   Hawaii Department of Education 150003000284 563 Ke Kula Nawahiokalaniopuu Iki Lab PCS charter Regular School Yes Elementary PK 8 2021   grade_6                                                   29.0                                             29
2455481 HI     school 1500030 1   Hawaii Department of Education 150003000284 563 Ke Kula Nawahiokalaniopuu Iki Lab PCS charter Regular School Yes Elementary PK 8 2021   grade_7                                                   42.0                                             42
2455775 HI     school 1500030 1   Hawaii Department of Education 150003000284 563 Ke Kula Nawahiokalaniopuu Iki Lab PCS charter Regular School Yes Elementary PK 8 2021   grade_8                                                   44.0                                             44
2456069 HI     school 1500030 1   Hawaii Department of Education 150003000284 563 Ke Kula Nawahiokalaniopuu Iki Lab PCS charter Regular School Yes Elementary PK 8 2021   grade_9                                                   0.0                                             0
2456363 HI     school 1500030 1   Hawaii Department of Education 150003000284 563 Ke Kula Nawahiokalaniopuu Iki Lab PCS charter Regular School Yes Elementary PK 8 2021   grade_10                                                   0.0                                             0
2456657 HI     school 1500030 1   Hawaii Department of Education 150003000284 563 Ke Kula Nawahiokalaniopuu Iki Lab PCS charter Regular School Yes Elementary PK 8 2021   grade_11                                                   0.0                                             0
2456951 HI     school 1500030 1   Hawaii Department of Education 150003000284 563 Ke Kula Nawahiokalaniopuu Iki Lab PCS charter Regular School Yes Elementary PK 8 2021   grade_12                                                   0.0                                             0
2457245 HI     school 1500030 1   Hawaii Department of Education 150003000284 563 Ke Kula Nawahiokalaniopuu Iki Lab PCS charter Regular School Yes Elementary PK 8 2021   pre_kindergarten                                                   0.0                                             0
2457539 HI     school 1500030 1   Hawaii Department of Education 150003000284 563 Ke Kula Nawahiokalaniopuu Iki Lab PCS charter Regular School Yes Elementary PK 8 2021   pk_12_total                                               10.0   473.0                                         10   473
2453412 HI     school 1500030 1   Hawaii Department of Education 150003000283 562 Ka Umeke Kaeo PCS charter Regular School Yes Other PK 11 2021   kindergarten                                                   28.0                                             28
2453706 HI     school 1500030 1   Hawaii Department of Education 150003000283 562 Ka Umeke Kaeo PCS charter Regular School Yes Other PK 11 2021   grade_1                                                   32.0                                             32
2454000 HI     school 1500030 1   Hawaii Department of Education 150003000283 562 Ka Umeke Kaeo PCS charter Regular School Yes Other PK 11 2021   grade_2                                                   28.0                                             28
2454294 HI     school 1500030 1   Hawaii Department of Education 150003000283 562 Ka Umeke Kaeo PCS charter Regular School Yes Other PK 11 2021   grade_3                                                   23.0                                             23
2454588 HI     school 1500030 1   Hawaii Department of Education 150003000283 562 Ka Umeke Kaeo PCS charter Regular School Yes Other PK 11 2021   grade_4                                                   22.0                                             22
2454882 HI     school 1500030 1   Hawaii Department of Education 150003000283 562 Ka Umeke Kaeo PCS charter Regular School Yes Other PK 11 2021   grade_5                                                   20.0                                             20
2455176 HI     school 1500030 1   Hawaii Department of Education 150003000283 562 Ka Umeke Kaeo PCS charter Regular School Yes Other PK 11 2021   grade_6                                                   14.0                                             14
2455470 HI     school 1500030 1   Hawaii Department of Education 150003000283 562 Ka Umeke Kaeo PCS charter Regular School Yes Other PK 11 2021   grade_7                                                   14.0                                             14
2455764 HI     school 1500030 1   Hawaii Department of Education 150003000283 562 Ka Umeke Kaeo PCS charter Regular School Yes Other PK 11 2021   grade_8                                                   17.0                                             17
2456058 HI     school 1500030 1   Hawaii Department of Education 150003000283 562 Ka Umeke Kaeo PCS charter Regular School Yes Other PK 11 2021   grade_9                                                   4.0                                             4
2456352 HI     school 1500030 1   Hawaii Department of Education 150003000283 562 Ka Umeke Kaeo PCS charter Regular School Yes Other PK 11 2021   grade_10                                                   5.0                                             5