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
126667 HI     school 1500030 1   Hawaii Department of Education 150003000298 567 SEEQS charter Regular School Yes Middle 06 8 2017   kindergarten                                                   0.0                                             0
126957 HI     school 1500030 1   Hawaii Department of Education 150003000298 567 SEEQS charter Regular School Yes Middle 06 8 2017   grade_1                                                   0.0                                             0
127247 HI     school 1500030 1   Hawaii Department of Education 150003000298 567 SEEQS charter Regular School Yes Middle 06 8 2017   grade_2                                                   0.0                                             0
127537 HI     school 1500030 1   Hawaii Department of Education 150003000298 567 SEEQS charter Regular School Yes Middle 06 8 2017   grade_3                                                   0.0                                             0
127827 HI     school 1500030 1   Hawaii Department of Education 150003000298 567 SEEQS charter Regular School Yes Middle 06 8 2017   grade_4                                                   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
128407 HI     school 1500030 1   Hawaii Department of Education 150003000298 567 SEEQS charter Regular School Yes Middle 06 8 2017   grade_6                                                   47.0                                             47
128697 HI     school 1500030 1   Hawaii Department of Education 150003000298 567 SEEQS charter Regular School Yes Middle 06 8 2017   grade_7                                                   46.0                                             46
128987 HI     school 1500030 1   Hawaii Department of Education 150003000298 567 SEEQS charter Regular School Yes Middle 06 8 2017   grade_8                                                   45.0                                             45
129277 HI     school 1500030 1   Hawaii Department of Education 150003000298 567 SEEQS charter Regular School Yes Middle 06 8 2017   grade_9                                                   0.0                                             0
129567 HI     school 1500030 1   Hawaii Department of Education 150003000298 567 SEEQS charter Regular School Yes Middle 06 8 2017   grade_10                                                   0.0                                             0
129857 HI     school 1500030 1   Hawaii Department of Education 150003000298 567 SEEQS charter Regular School Yes Middle 06 8 2017   grade_11                                                   0.0                                             0
130147 HI     school 1500030 1   Hawaii Department of Education 150003000298 567 SEEQS charter Regular School Yes Middle 06 8 2017   grade_12                                                   0.0                                             0
130437 HI     school 1500030 1   Hawaii Department of Education 150003000298 567 SEEQS charter Regular School Yes Middle 06 8 2017   pre_kindergarten                                                   0.0                                             0
130727 HI     school 1500030 1   Hawaii Department of Education 150003000298 567 SEEQS charter Regular School Yes Middle 06 8 2017   pk_12_total                                               22.0   160.0                                         22   160
126658 HI     school 1500030 1   Hawaii Department of Education 150003000293 566 KONA PACIFIC-PCS charter Regular School Yes Elementary KG 8 2017   kindergarten                                                   28.0                                             28
126948 HI     school 1500030 1   Hawaii Department of Education 150003000293 566 KONA PACIFIC-PCS charter Regular School Yes Elementary KG 8 2017   grade_1                                                   30.0                                             30
127238 HI     school 1500030 1   Hawaii Department of Education 150003000293 566 KONA PACIFIC-PCS charter Regular School Yes Elementary KG 8 2017   grade_2                                                   22.0                                             22
127528 HI     school 1500030 1   Hawaii Department of Education 150003000293 566 KONA PACIFIC-PCS charter Regular School Yes Elementary KG 8 2017   grade_3                                                   27.0                                             27
127818 HI     school 1500030 1   Hawaii Department of Education 150003000293 566 KONA PACIFIC-PCS charter Regular School Yes Elementary KG 8 2017   grade_4                                                   21.0                                             21
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
128398 HI     school 1500030 1   Hawaii Department of Education 150003000293 566 KONA PACIFIC-PCS charter Regular School Yes Elementary KG 8 2017   grade_6                                                   20.0                                             20
128688 HI     school 1500030 1   Hawaii Department of Education 150003000293 566 KONA PACIFIC-PCS charter Regular School Yes Elementary KG 8 2017   grade_7                                                   17.0                                             17
128978 HI     school 1500030 1   Hawaii Department of Education 150003000293 566 KONA PACIFIC-PCS charter Regular School Yes Elementary KG 8 2017   grade_8                                                   21.0                                             21
129268 HI     school 1500030 1   Hawaii Department of Education 150003000293 566 KONA PACIFIC-PCS charter Regular School Yes Elementary KG 8 2017   grade_9                                                   0.0                                             0
129558 HI     school 1500030 1   Hawaii Department of Education 150003000293 566 KONA PACIFIC-PCS charter Regular School Yes Elementary KG 8 2017   grade_10                                                   0.0                                             0
129848 HI     school 1500030 1   Hawaii Department of Education 150003000293 566 KONA PACIFIC-PCS charter Regular School Yes Elementary KG 8 2017   grade_11                                                   0.0                                             0
130138 HI     school 1500030 1   Hawaii Department of Education 150003000293 566 KONA PACIFIC-PCS charter Regular School Yes Elementary KG 8 2017   grade_12                                                   0.0                                             0
130428 HI     school 1500030 1   Hawaii Department of Education 150003000293 566 KONA PACIFIC-PCS charter Regular School Yes Elementary KG 8 2017   pre_kindergarten                                                   0.0                                             0
130718 HI     school 1500030 1   Hawaii Department of Education 150003000293 566 KONA PACIFIC-PCS charter Regular School Yes Elementary KG 8 2017   pk_12_total                                               18.0   223.0                                         18   223
126653 HI     school 1500030 1   Hawaii Department of Education 150003000294 565 KAWAIKINI-PCS charter Regular School Yes Other KG 12 2017   kindergarten                                                   20.0                                             20
126943 HI     school 1500030 1   Hawaii Department of Education 150003000294 565 KAWAIKINI-PCS charter Regular School Yes Other KG 12 2017   grade_1                                                   21.0                                             21
127233 HI     school 1500030 1   Hawaii Department of Education 150003000294 565 KAWAIKINI-PCS charter Regular School Yes Other KG 12 2017   grade_2                                                   20.0                                             20
127523 HI     school 1500030 1   Hawaii Department of Education 150003000294 565 KAWAIKINI-PCS charter Regular School Yes Other KG 12 2017   grade_3                                                   20.0                                             20
127813 HI     school 1500030 1   Hawaii Department of Education 150003000294 565 KAWAIKINI-PCS charter Regular School Yes Other KG 12 2017   grade_4                                                   12.0                                             12
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
128393 HI     school 1500030 1   Hawaii Department of Education 150003000294 565 KAWAIKINI-PCS charter Regular School Yes Other KG 12 2017   grade_6                                                   7.0                                             7
128683 HI     school 1500030 1   Hawaii Department of Education 150003000294 565 KAWAIKINI-PCS charter Regular School Yes Other KG 12 2017   grade_7                                                   8.0                                             8
128973 HI     school 1500030 1   Hawaii Department of Education 150003000294 565 KAWAIKINI-PCS charter Regular School Yes Other KG 12 2017   grade_8                                                   10.0                                             10
129263 HI     school 1500030 1   Hawaii Department of Education 150003000294 565 KAWAIKINI-PCS charter Regular School Yes Other KG 12 2017   grade_9                                                   5.0                                             5
129553 HI     school 1500030 1   Hawaii Department of Education 150003000294 565 KAWAIKINI-PCS charter Regular School Yes Other KG 12 2017   grade_10                                                   1.0                                             1
129843 HI     school 1500030 1   Hawaii Department of Education 150003000294 565 KAWAIKINI-PCS charter Regular School Yes Other KG 12 2017   grade_11                                                   2.0                                             2
130133 HI     school 1500030 1   Hawaii Department of Education 150003000294 565 KAWAIKINI-PCS charter Regular School Yes Other KG 12 2017   grade_12                                                   2.0                                             2
130423 HI     school 1500030 1   Hawaii Department of Education 150003000294 565 KAWAIKINI-PCS charter Regular School Yes Other KG 12 2017   pre_kindergarten                                                   0.0                                             0
130713 HI     school 1500030 1   Hawaii Department of Education 150003000294 565 KAWAIKINI-PCS charter Regular School Yes Other KG 12 2017   pk_12_total                                               6.0   150.0                                         6   150
126651 HI     school 1500030 1   Hawaii Department of Education 150003000289 564 KANUIKAPONO-PCS charter Regular School Yes Other KG 12 2017   kindergarten                                                   18.0                                             18
126941 HI     school 1500030 1   Hawaii Department of Education 150003000289 564 KANUIKAPONO-PCS charter Regular School Yes Other KG 12 2017   grade_1                                                   18.0                                             18
127231 HI     school 1500030 1   Hawaii Department of Education 150003000289 564 KANUIKAPONO-PCS charter Regular School Yes Other KG 12 2017   grade_2                                                   20.0                                             20
127521 HI     school 1500030 1   Hawaii Department of Education 150003000289 564 KANUIKAPONO-PCS charter Regular School Yes Other KG 12 2017   grade_3                                                   20.0                                             20
127811 HI     school 1500030 1   Hawaii Department of Education 150003000289 564 KANUIKAPONO-PCS charter Regular School Yes Other KG 12 2017   grade_4                                                   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
128391 HI     school 1500030 1   Hawaii Department of Education 150003000289 564 KANUIKAPONO-PCS charter Regular School Yes Other KG 12 2017   grade_6                                                   18.0                                             18
128681 HI     school 1500030 1   Hawaii Department of Education 150003000289 564 KANUIKAPONO-PCS charter Regular School Yes Other KG 12 2017   grade_7                                                   17.0                                             17
128971 HI     school 1500030 1   Hawaii Department of Education 150003000289 564 KANUIKAPONO-PCS charter Regular School Yes Other KG 12 2017   grade_8                                                   17.0                                             17
129261 HI     school 1500030 1   Hawaii Department of Education 150003000289 564 KANUIKAPONO-PCS charter Regular School Yes Other KG 12 2017   grade_9                                                   4.0                                             4
129551 HI     school 1500030 1   Hawaii Department of Education 150003000289 564 KANUIKAPONO-PCS charter Regular School Yes Other KG 12 2017   grade_10                                                   3.0                                             3
129841 HI     school 1500030 1   Hawaii Department of Education 150003000289 564 KANUIKAPONO-PCS charter Regular School Yes Other KG 12 2017   grade_11                                                   4.0                                             4
130131 HI     school 1500030 1   Hawaii Department of Education 150003000289 564 KANUIKAPONO-PCS charter Regular School Yes Other KG 12 2017   grade_12                                                   4.0                                             4
130421 HI     school 1500030 1   Hawaii Department of Education 150003000289 564 KANUIKAPONO-PCS charter Regular School Yes Other KG 12 2017   pre_kindergarten                                                   0.0                                             0
130711 HI     school 1500030 1   Hawaii Department of Education 150003000289 564 KANUIKAPONO-PCS charter Regular School Yes Other KG 12 2017   pk_12_total                                               8.0   186.0                                         8   186
126666 HI     school 1500030 1   Hawaii Department of Education 150003000284 563 NAWAHI IKI LAB-PCS charter Regular School Yes Elementary PK 8 2017   kindergarten                                                   60.0                                             60
126956 HI     school 1500030 1   Hawaii Department of Education 150003000284 563 NAWAHI IKI LAB-PCS charter Regular School Yes Elementary PK 8 2017   grade_1                                                   60.0                                             60
127246 HI     school 1500030 1   Hawaii Department of Education 150003000284 563 NAWAHI IKI LAB-PCS charter Regular School Yes Elementary PK 8 2017   grade_2                                                   36.0                                             36
127536 HI     school 1500030 1   Hawaii Department of Education 150003000284 563 NAWAHI IKI LAB-PCS charter Regular School Yes Elementary PK 8 2017   grade_3                                                   46.0                                             46
127826 HI     school 1500030 1   Hawaii Department of Education 150003000284 563 NAWAHI IKI LAB-PCS charter Regular School Yes Elementary PK 8 2017   grade_4                                                   46.0                                             46
128116 HI     school 1500030 1   Hawaii Department of Education 150003000284 563 NAWAHI IKI LAB-PCS charter Regular School Yes Elementary PK 8 2017   grade_5                                                   50.0                                             50
128406 HI     school 1500030 1   Hawaii Department of Education 150003000284 563 NAWAHI IKI LAB-PCS charter Regular School Yes Elementary PK 8 2017   grade_6                                                   38.0                                             38
128696 HI     school 1500030 1   Hawaii Department of Education 150003000284 563 NAWAHI IKI LAB-PCS charter Regular School Yes Elementary PK 8 2017   grade_7                                                   35.0                                             35
128986 HI     school 1500030 1   Hawaii Department of Education 150003000284 563 NAWAHI IKI LAB-PCS charter Regular School Yes Elementary PK 8 2017   grade_8                                                   17.0                                             17
129276 HI     school 1500030 1   Hawaii Department of Education 150003000284 563 NAWAHI IKI LAB-PCS charter Regular School Yes Elementary PK 8 2017   grade_9                                                   0.0                                             0
129566 HI     school 1500030 1   Hawaii Department of Education 150003000284 563 NAWAHI IKI LAB-PCS charter Regular School Yes Elementary PK 8 2017   grade_10                                                   0.0                                             0
129856 HI     school 1500030 1   Hawaii Department of Education 150003000284 563 NAWAHI IKI LAB-PCS charter Regular School Yes Elementary PK 8 2017   grade_11                                                   0.0                                             0
130146 HI     school 1500030 1   Hawaii Department of Education 150003000284 563 NAWAHI IKI LAB-PCS charter Regular School Yes Elementary PK 8 2017   grade_12                                                   0.0                                             0
130436 HI     school 1500030 1   Hawaii Department of Education 150003000284 563 NAWAHI IKI LAB-PCS charter Regular School Yes Elementary PK 8 2017   pre_kindergarten                                                   0.0                                             0
130726 HI     school 1500030 1   Hawaii Department of Education 150003000284 563 NAWAHI IKI LAB-PCS charter Regular School Yes Elementary PK 8 2017   pk_12_total                                               7.0   395.0                                         7   395
126646 HI     school 1500030 1   Hawaii Department of Education 150003000283 562 KA 'UMEKE KA'EO-PCS charter Regular School Yes Elementary PK 8 2017   kindergarten                                                   34.0                                             34
126936 HI     school 1500030 1   Hawaii Department of Education 150003000283 562 KA 'UMEKE KA'EO-PCS charter Regular School Yes Elementary PK 8 2017   grade_1                                                   36.0                                             36
127226 HI     school 1500030 1   Hawaii Department of Education 150003000283 562 KA 'UMEKE KA'EO-PCS charter Regular School Yes Elementary PK 8 2017   grade_2                                                   16.0                                             16
127516 HI     school 1500030 1   Hawaii Department of Education 150003000283 562 KA 'UMEKE KA'EO-PCS charter Regular School Yes Elementary PK 8 2017   grade_3                                                   33.0                                             33
127806 HI     school 1500030 1   Hawaii Department of Education 150003000283 562 KA 'UMEKE KA'EO-PCS charter Regular School Yes Elementary PK 8 2017   grade_4                                                   24.0                                             24
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
128386 HI     school 1500030 1   Hawaii Department of Education 150003000283 562 KA 'UMEKE KA'EO-PCS charter Regular School Yes Elementary PK 8 2017   grade_6                                                   19.0                                             19
128676 HI     school 1500030 1   Hawaii Department of Education 150003000283 562 KA 'UMEKE KA'EO-PCS charter Regular School Yes Elementary PK 8 2017   grade_7                                                   11.0                                             11
128966 HI     school 1500030 1   Hawaii Department of Education 150003000283 562 KA 'UMEKE KA'EO-PCS charter Regular School Yes Elementary PK 8 2017   grade_8                                                   7.0                                             7
129256 HI     school 1500030 1   Hawaii Department of Education 150003000283 562 KA 'UMEKE KA'EO-PCS charter Regular School Yes Elementary PK 8 2017   grade_9                                                   0.0                                             0
129546 HI     school 1500030 1   Hawaii Department of Education 150003000283 562 KA 'UMEKE KA'EO-PCS charter Regular School Yes Elementary PK 8 2017   grade_10                                                   0.0                                             0
129836 HI     school 1500030 1   Hawaii Department of Education 150003000283 562 KA 'UMEKE KA'EO-PCS charter Regular School Yes Elementary PK 8 2017   grade_11                                                   0.0                                             0
130126 HI     school 1500030 1   Hawaii Department of Education 150003000283 562 KA 'UMEKE KA'EO-PCS charter Regular School Yes Elementary PK 8 2017   grade_12                                                   0.0                                             0
130416 HI     school 1500030 1   Hawaii Department of Education 150003000283 562 KA 'UMEKE KA'EO-PCS charter Regular School Yes Elementary PK 8 2017   pre_kindergarten                                                   0.0                                             0
130706 HI     school 1500030 1   Hawaii Department of Education 150003000283 562 KA 'UMEKE KA'EO-PCS charter Regular School Yes Elementary PK 8 2017   pk_12_total                                               8.0   215.0                                         8   215
126644 HI     school 1500030 1   Hawaii Department of Education 150003000282 561 HI ACADEMY OF A&S-PCS charter Regular School Yes Other KG 12 2017   kindergarten                                                   36.0                                             36
126934 HI     school 1500030 1   Hawaii Department of Education 150003000282 561 HI ACADEMY OF A&S-PCS charter Regular School Yes Other KG 12 2017   grade_1                                                   26.0                                             26
127224 HI     school 1500030 1   Hawaii Department of Education 150003000282 561 HI ACADEMY OF A&S-PCS charter Regular School Yes Other KG 12 2017   grade_2                                                   31.0                                             31
127514 HI     school 1500030 1   Hawaii Department of Education 150003000282 561 HI ACADEMY OF A&S-PCS charter Regular School Yes Other KG 12 2017   grade_3                                                   48.0                                             48
127804 HI     school 1500030 1   Hawaii Department of Education 150003000282 561 HI ACADEMY OF A&S-PCS charter Regular School Yes Other KG 12 2017   grade_4                                                   33.0                                             33
128094 HI     school 1500030 1   Hawaii Department of Education 150003000282 561 HI ACADEMY OF A&S-PCS charter Regular School Yes Other KG 12 2017   grade_5                                                   43.0                                             43
128384 HI     school 1500030 1   Hawaii Department of Education 150003000282 561 HI ACADEMY OF A&S-PCS charter Regular School Yes Other KG 12 2017   grade_6                                                   48.0                                             48
128674 HI     school 1500030 1   Hawaii Department of Education 150003000282 561 HI ACADEMY OF A&S-PCS charter Regular School Yes Other KG 12 2017   grade_7                                                   54.0                                             54
128964 HI     school 1500030 1   Hawaii Department of Education 150003000282 561 HI ACADEMY OF A&S-PCS charter Regular School Yes Other KG 12 2017   grade_8                                                   62.0                                             62
129254 HI     school 1500030 1   Hawaii Department of Education 150003000282 561 HI ACADEMY OF A&S-PCS charter Regular School Yes Other KG 12 2017   grade_9                                                   71.0                                             71
129544 HI     school 1500030 1   Hawaii Department of Education 150003000282 561 HI ACADEMY OF A&S-PCS charter Regular School Yes Other KG 12 2017   grade_10                                                   54.0                                             54