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
2734419 HI     school 1500030 1   Hawaii Department of Education 150003000304 558 Alakai O Kauai PCS charter Regular School Yes Elementary KG 5 2019   kindergarten                                                   32.0                                             32
2734711 HI     school 1500030 1   Hawaii Department of Education 150003000304 558 Alakai O Kauai PCS charter Regular School Yes Elementary KG 5 2019   grade_1                                                   20.0                                             20
2735003 HI     school 1500030 1   Hawaii Department of Education 150003000304 558 Alakai O Kauai PCS charter Regular School Yes Elementary KG 5 2019   grade_2                                                   18.0                                             18
2735295 HI     school 1500030 1   Hawaii Department of Education 150003000304 558 Alakai O Kauai PCS charter Regular School Yes Elementary KG 5 2019   grade_3                                                   17.0                                             17
2735587 HI     school 1500030 1   Hawaii Department of Education 150003000304 558 Alakai O Kauai PCS charter Regular School Yes Elementary KG 5 2019   grade_4                                                   16.0                                             16
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
2736171 HI     school 1500030 1   Hawaii Department of Education 150003000304 558 Alakai O Kauai PCS charter Regular School Yes Elementary KG 5 2019   grade_6                                                   0.0                                             0
2736463 HI     school 1500030 1   Hawaii Department of Education 150003000304 558 Alakai O Kauai PCS charter Regular School Yes Elementary KG 5 2019   grade_7                                                   0.0                                             0
2736755 HI     school 1500030 1   Hawaii Department of Education 150003000304 558 Alakai O Kauai PCS charter Regular School Yes Elementary KG 5 2019   grade_8                                                   0.0                                             0
2737047 HI     school 1500030 1   Hawaii Department of Education 150003000304 558 Alakai O Kauai PCS charter Regular School Yes Elementary KG 5 2019   grade_9                                                   0.0                                             0
2737339 HI     school 1500030 1   Hawaii Department of Education 150003000304 558 Alakai O Kauai PCS charter Regular School Yes Elementary KG 5 2019   grade_10                                                   0.0                                             0
2737631 HI     school 1500030 1   Hawaii Department of Education 150003000304 558 Alakai O Kauai PCS charter Regular School Yes Elementary KG 5 2019   grade_11                                                   0.0                                             0
2737923 HI     school 1500030 1   Hawaii Department of Education 150003000304 558 Alakai O Kauai PCS charter Regular School Yes Elementary KG 5 2019   grade_12                                                   0.0                                             0
2738215 HI     school 1500030 1   Hawaii Department of Education 150003000304 558 Alakai O Kauai PCS charter Regular School Yes Elementary KG 5 2019   pre_kindergarten                                                   0.0                                             0
2738507 HI     school 1500030 1   Hawaii Department of Education 150003000304 558 Alakai O Kauai PCS charter Regular School Yes Elementary KG 5 2019   pk_12_total                                               4.0   123.0                                         4   123
2734414 HI     school 1500030 1   Hawaii Department of Education 150003000303 553 Kamalani Academy charter Regular School Yes Elementary PK 8 2019   kindergarten                                                   37.0                                             37
2734706 HI     school 1500030 1   Hawaii Department of Education 150003000303 553 Kamalani Academy charter Regular School Yes Elementary PK 8 2019   grade_1                                                   32.0                                             32
2734998 HI     school 1500030 1   Hawaii Department of Education 150003000303 553 Kamalani Academy charter Regular School Yes Elementary PK 8 2019   grade_2                                                   24.0                                             24
2735290 HI     school 1500030 1   Hawaii Department of Education 150003000303 553 Kamalani Academy charter Regular School Yes Elementary PK 8 2019   grade_3                                                   24.0                                             24
2735582 HI     school 1500030 1   Hawaii Department of Education 150003000303 553 Kamalani Academy charter Regular School Yes Elementary PK 8 2019   grade_4                                                   22.0                                             22
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
2736166 HI     school 1500030 1   Hawaii Department of Education 150003000303 553 Kamalani Academy charter Regular School Yes Elementary PK 8 2019   grade_6                                                   27.0                                             27
2736458 HI     school 1500030 1   Hawaii Department of Education 150003000303 553 Kamalani Academy charter Regular School Yes Elementary PK 8 2019   grade_7                                                   44.0                                             44
2736750 HI     school 1500030 1   Hawaii Department of Education 150003000303 553 Kamalani Academy charter Regular School Yes Elementary PK 8 2019   grade_8                                                   20.0                                             20
2737042 HI     school 1500030 1   Hawaii Department of Education 150003000303 553 Kamalani Academy charter Regular School Yes Elementary PK 8 2019   grade_9                                                   0.0                                             0
2737334 HI     school 1500030 1   Hawaii Department of Education 150003000303 553 Kamalani Academy charter Regular School Yes Elementary PK 8 2019   grade_10                                                   0.0                                             0
2737626 HI     school 1500030 1   Hawaii Department of Education 150003000303 553 Kamalani Academy charter Regular School Yes Elementary PK 8 2019   grade_11                                                   0.0                                             0
2737918 HI     school 1500030 1   Hawaii Department of Education 150003000303 553 Kamalani Academy charter Regular School Yes Elementary PK 8 2019   grade_12                                                   0.0                                             0
2738210 HI     school 1500030 1   Hawaii Department of Education 150003000303 553 Kamalani Academy charter Regular School Yes Elementary PK 8 2019   pre_kindergarten                                                   0.0                                             0
2738502 HI     school 1500030 1   Hawaii Department of Education 150003000303 553 Kamalani Academy charter Regular School Yes Elementary PK 8 2019   pk_12_total                                               32.0   297.0                                         32   297
2734416 HI     school 1500030 1   Hawaii Department of Education 150003000302 555 Kapolei Charter School charter Regular School Yes Secondary 09 10 2019   kindergarten                                                   0.0                                             0
2734708 HI     school 1500030 1   Hawaii Department of Education 150003000302 555 Kapolei Charter School charter Regular School Yes Secondary 09 10 2019   grade_1                                                   0.0                                             0
2735000 HI     school 1500030 1   Hawaii Department of Education 150003000302 555 Kapolei Charter School charter Regular School Yes Secondary 09 10 2019   grade_2                                                   0.0                                             0
2735292 HI     school 1500030 1   Hawaii Department of Education 150003000302 555 Kapolei Charter School charter Regular School Yes Secondary 09 10 2019   grade_3                                                   0.0                                             0
2735584 HI     school 1500030 1   Hawaii Department of Education 150003000302 555 Kapolei Charter School charter Regular School Yes Secondary 09 10 2019   grade_4                                                   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
2736168 HI     school 1500030 1   Hawaii Department of Education 150003000302 555 Kapolei Charter School charter Regular School Yes Secondary 09 10 2019   grade_6                                                   0.0                                             0
2736460 HI     school 1500030 1   Hawaii Department of Education 150003000302 555 Kapolei Charter School charter Regular School Yes Secondary 09 10 2019   grade_7                                                   0.0                                             0
2736752 HI     school 1500030 1   Hawaii Department of Education 150003000302 555 Kapolei Charter School charter Regular School Yes Secondary 09 10 2019   grade_8                                                   0.0                                             0
2737044 HI     school 1500030 1   Hawaii Department of Education 150003000302 555 Kapolei Charter School charter Regular School Yes Secondary 09 10 2019   grade_9                                                   41.0                                             41
2737336 HI     school 1500030 1   Hawaii Department of Education 150003000302 555 Kapolei Charter School charter Regular School Yes Secondary 09 10 2019   grade_10                                                   39.0                                             39
2737628 HI     school 1500030 1   Hawaii Department of Education 150003000302 555 Kapolei Charter School charter Regular School Yes Secondary 09 10 2019   grade_11                                                   0.0                                             0
2737920 HI     school 1500030 1   Hawaii Department of Education 150003000302 555 Kapolei Charter School charter Regular School Yes Secondary 09 10 2019   grade_12                                                   0.0                                             0
2738212 HI     school 1500030 1   Hawaii Department of Education 150003000302 555 Kapolei Charter School charter Regular School Yes Secondary 09 10 2019   pre_kindergarten                                                   0.0                                             0
2738504 HI     school 1500030 1   Hawaii Department of Education 150003000302 555 Kapolei Charter School charter Regular School Yes Secondary 09 10 2019   pk_12_total                                               9.0   89.0                                         9   89
2734237 HI     school 1500030 1   Hawaii Department of Education 150003000300 293 Hookele Elem   Regular School No Elementary PK 5 2019   kindergarten                                                   150.0                                             150
2734529 HI     school 1500030 1   Hawaii Department of Education 150003000300 293 Hookele Elem   Regular School No Elementary PK 5 2019   grade_1                                                   149.0                                             149
2734821 HI     school 1500030 1   Hawaii Department of Education 150003000300 293 Hookele Elem   Regular School No Elementary PK 5 2019   grade_2                                                   160.0                                             160
2735113 HI     school 1500030 1   Hawaii Department of Education 150003000300 293 Hookele Elem   Regular School No Elementary PK 5 2019   grade_3                                                   161.0                                             161
2735405 HI     school 1500030 1   Hawaii Department of Education 150003000300 293 Hookele Elem   Regular School No Elementary PK 5 2019   grade_4                                                   72.0                                             72
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
2735989 HI     school 1500030 1   Hawaii Department of Education 150003000300 293 Hookele Elem   Regular School No Elementary PK 5 2019   grade_6                                                   0.0                                             0
2736281 HI     school 1500030 1   Hawaii Department of Education 150003000300 293 Hookele Elem   Regular School No Elementary PK 5 2019   grade_7                                                   0.0                                             0
2736573 HI     school 1500030 1   Hawaii Department of Education 150003000300 293 Hookele Elem   Regular School No Elementary PK 5 2019   grade_8                                                   0.0                                             0
2736865 HI     school 1500030 1   Hawaii Department of Education 150003000300 293 Hookele Elem   Regular School No Elementary PK 5 2019   grade_9                                                   0.0                                             0
2737157 HI     school 1500030 1   Hawaii Department of Education 150003000300 293 Hookele Elem   Regular School No Elementary PK 5 2019   grade_10                                                   0.0                                             0
2737449 HI     school 1500030 1   Hawaii Department of Education 150003000300 293 Hookele Elem   Regular School No Elementary PK 5 2019   grade_11                                                   0.0                                             0
2737741 HI     school 1500030 1   Hawaii Department of Education 150003000300 293 Hookele Elem   Regular School No Elementary PK 5 2019   grade_12                                                   0.0                                             0
2738033 HI     school 1500030 1   Hawaii Department of Education 150003000300 293 Hookele Elem   Regular School No Elementary PK 5 2019   pre_kindergarten                                                   12.0                                             12
2738325 HI     school 1500030 1   Hawaii Department of Education 150003000300 293 Hookele Elem   Regular School No Elementary PK 5 2019   pk_12_total                                               39.0   873.0                                         39   873
2734412 HI     school 1500030 1   Hawaii Department of Education 150003000299 550 Malama Honua charter Regular School Yes Elementary KG 6 2019   kindergarten                                                   20.0                                             20
2734704 HI     school 1500030 1   Hawaii Department of Education 150003000299 550 Malama Honua charter Regular School Yes Elementary KG 6 2019   grade_1                                                   20.0                                             20
2734996 HI     school 1500030 1   Hawaii Department of Education 150003000299 550 Malama Honua charter Regular School Yes Elementary KG 6 2019   grade_2                                                   20.0                                             20
2735288 HI     school 1500030 1   Hawaii Department of Education 150003000299 550 Malama Honua charter Regular School Yes Elementary KG 6 2019   grade_3                                                   18.0                                             18
2735580 HI     school 1500030 1   Hawaii Department of Education 150003000299 550 Malama Honua charter Regular School Yes Elementary KG 6 2019   grade_4                                                   18.0                                             18
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
2736164 HI     school 1500030 1   Hawaii Department of Education 150003000299 550 Malama Honua charter Regular School Yes Elementary KG 6 2019   grade_6                                                   13.0                                             13
2736456 HI     school 1500030 1   Hawaii Department of Education 150003000299 550 Malama Honua charter Regular School Yes Elementary KG 6 2019   grade_7                                                   0.0                                             0
2736748 HI     school 1500030 1   Hawaii Department of Education 150003000299 550 Malama Honua charter Regular School Yes Elementary KG 6 2019   grade_8                                                   0.0                                             0
2737040 HI     school 1500030 1   Hawaii Department of Education 150003000299 550 Malama Honua charter Regular School Yes Elementary KG 6 2019   grade_9                                                   0.0                                             0
2737332 HI     school 1500030 1   Hawaii Department of Education 150003000299 550 Malama Honua charter Regular School Yes Elementary KG 6 2019   grade_10                                                   0.0                                             0
2737624 HI     school 1500030 1   Hawaii Department of Education 150003000299 550 Malama Honua charter Regular School Yes Elementary KG 6 2019   grade_11                                                   0.0                                             0
2737916 HI     school 1500030 1   Hawaii Department of Education 150003000299 550 Malama Honua charter Regular School Yes Elementary KG 6 2019   grade_12                                                   0.0                                             0
2738208 HI     school 1500030 1   Hawaii Department of Education 150003000299 550 Malama Honua charter Regular School Yes Elementary KG 6 2019   pre_kindergarten                                                   0.0                                             0
2738500 HI     school 1500030 1   Hawaii Department of Education 150003000299 550 Malama Honua charter Regular School Yes Elementary KG 6 2019   pk_12_total                                               8.0   126.0                                         8   126
2734427 HI     school 1500030 1   Hawaii Department of Education 150003000298 567 SEEQS PCS charter Regular School Yes Middle 06 8 2019   kindergarten                                                   0.0                                             0
2734719 HI     school 1500030 1   Hawaii Department of Education 150003000298 567 SEEQS PCS charter Regular School Yes Middle 06 8 2019   grade_1                                                   0.0                                             0
2735011 HI     school 1500030 1   Hawaii Department of Education 150003000298 567 SEEQS PCS charter Regular School Yes Middle 06 8 2019   grade_2                                                   0.0                                             0
2735303 HI     school 1500030 1   Hawaii Department of Education 150003000298 567 SEEQS PCS charter Regular School Yes Middle 06 8 2019   grade_3                                                   0.0                                             0
2735595 HI     school 1500030 1   Hawaii Department of Education 150003000298 567 SEEQS PCS charter Regular School Yes Middle 06 8 2019   grade_4                                                   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
2736179 HI     school 1500030 1   Hawaii Department of Education 150003000298 567 SEEQS PCS charter Regular School Yes Middle 06 8 2019   grade_6                                                   61.0                                             61
2736471 HI     school 1500030 1   Hawaii Department of Education 150003000298 567 SEEQS PCS charter Regular School Yes Middle 06 8 2019   grade_7                                                   54.0                                             54
2736763 HI     school 1500030 1   Hawaii Department of Education 150003000298 567 SEEQS PCS charter Regular School Yes Middle 06 8 2019   grade_8                                                   46.0                                             46
2737055 HI     school 1500030 1   Hawaii Department of Education 150003000298 567 SEEQS PCS charter Regular School Yes Middle 06 8 2019   grade_9                                                   0.0                                             0
2737347 HI     school 1500030 1   Hawaii Department of Education 150003000298 567 SEEQS PCS charter Regular School Yes Middle 06 8 2019   grade_10                                                   0.0                                             0
2737639 HI     school 1500030 1   Hawaii Department of Education 150003000298 567 SEEQS PCS charter Regular School Yes Middle 06 8 2019   grade_11                                                   0.0                                             0
2737931 HI     school 1500030 1   Hawaii Department of Education 150003000298 567 SEEQS PCS charter Regular School Yes Middle 06 8 2019   grade_12                                                   0.0                                             0
2738223 HI     school 1500030 1   Hawaii Department of Education 150003000298 567 SEEQS PCS charter Regular School Yes Middle 06 8 2019   pre_kindergarten                                                   0.0                                             0
2738515 HI     school 1500030 1   Hawaii Department of Education 150003000298 567 SEEQS PCS charter Regular School Yes Middle 06 8 2019   pk_12_total                                               24.0   185.0                                         24   185
2734362 HI     school 1500030 1   Hawaii Department of Education 150003000297 436 Puu Kukui Elem   Regular School No Elementary PK 5 2019   kindergarten                                                   118.0                                             118
2734654 HI     school 1500030 1   Hawaii Department of Education 150003000297 436 Puu Kukui Elem   Regular School No Elementary PK 5 2019   grade_1                                                   108.0                                             108
2734946 HI     school 1500030 1   Hawaii Department of Education 150003000297 436 Puu Kukui Elem   Regular School No Elementary PK 5 2019   grade_2                                                   128.0                                             128
2735238 HI     school 1500030 1   Hawaii Department of Education 150003000297 436 Puu Kukui Elem   Regular School No Elementary PK 5 2019   grade_3                                                   123.0                                             123
2735530 HI     school 1500030 1   Hawaii Department of Education 150003000297 436 Puu Kukui Elem   Regular School No Elementary PK 5 2019   grade_4                                                   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
2736114 HI     school 1500030 1   Hawaii Department of Education 150003000297 436 Puu Kukui Elem   Regular School No Elementary PK 5 2019   grade_6                                                   0.0                                             0
2736406 HI     school 1500030 1   Hawaii Department of Education 150003000297 436 Puu Kukui Elem   Regular School No Elementary PK 5 2019   grade_7                                                   0.0                                             0
2736698 HI     school 1500030 1   Hawaii Department of Education 150003000297 436 Puu Kukui Elem   Regular School No Elementary PK 5 2019   grade_8                                                   0.0                                             0
2736990 HI     school 1500030 1   Hawaii Department of Education 150003000297 436 Puu Kukui Elem   Regular School No Elementary PK 5 2019   grade_9                                                   0.0                                             0
2737282 HI     school 1500030 1   Hawaii Department of Education 150003000297 436 Puu Kukui Elem   Regular School No Elementary PK 5 2019   grade_10                                                   0.0                                             0