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
2428722 HI     school 1500030 1   Hawaii Department of Education 150003000304 558 Alakai O Kauai PCS charter Regular School Yes Elementary KG 6 2020   kindergarten                                                   25.0                                             25
2429015 HI     school 1500030 1   Hawaii Department of Education 150003000304 558 Alakai O Kauai PCS charter Regular School Yes Elementary KG 6 2020   grade_1                                                   26.0                                             26
2429308 HI     school 1500030 1   Hawaii Department of Education 150003000304 558 Alakai O Kauai PCS charter Regular School Yes Elementary KG 6 2020   grade_2                                                   14.0                                             14
2429601 HI     school 1500030 1   Hawaii Department of Education 150003000304 558 Alakai O Kauai PCS charter Regular School Yes Elementary KG 6 2020   grade_3                                                   25.0                                             25
2429894 HI     school 1500030 1   Hawaii Department of Education 150003000304 558 Alakai O Kauai PCS charter Regular School Yes Elementary KG 6 2020   grade_4                                                   22.0                                             22
2430187 HI     school 1500030 1   Hawaii Department of Education 150003000304 558 Alakai O Kauai PCS charter Regular School Yes Elementary KG 6 2020   grade_5                                                   16.0                                             16
2430480 HI     school 1500030 1   Hawaii Department of Education 150003000304 558 Alakai O Kauai PCS charter Regular School Yes Elementary KG 6 2020   grade_6                                                   15.0                                             15
2430773 HI     school 1500030 1   Hawaii Department of Education 150003000304 558 Alakai O Kauai PCS charter Regular School Yes Elementary KG 6 2020   grade_7                                                   0.0                                             0
2431066 HI     school 1500030 1   Hawaii Department of Education 150003000304 558 Alakai O Kauai PCS charter Regular School Yes Elementary KG 6 2020   grade_8                                                   0.0                                             0
2431359 HI     school 1500030 1   Hawaii Department of Education 150003000304 558 Alakai O Kauai PCS charter Regular School Yes Elementary KG 6 2020   grade_9                                                   0.0                                             0
2431652 HI     school 1500030 1   Hawaii Department of Education 150003000304 558 Alakai O Kauai PCS charter Regular School Yes Elementary KG 6 2020   grade_10                                                   0.0                                             0
2431945 HI     school 1500030 1   Hawaii Department of Education 150003000304 558 Alakai O Kauai PCS charter Regular School Yes Elementary KG 6 2020   grade_11                                                   0.0                                             0
2432238 HI     school 1500030 1   Hawaii Department of Education 150003000304 558 Alakai O Kauai PCS charter Regular School Yes Elementary KG 6 2020   grade_12                                                   0.0                                             0
2432531 HI     school 1500030 1   Hawaii Department of Education 150003000304 558 Alakai O Kauai PCS charter Regular School Yes Elementary KG 6 2020   pre_kindergarten                                                   0.0                                             0
2432824 HI     school 1500030 1   Hawaii Department of Education 150003000304 558 Alakai O Kauai PCS charter Regular School Yes Elementary KG 6 2020   pk_12_total                                               6.0   149.0                                         6   149
2428733 HI     school 1500030 1   Hawaii Department of Education 150003000303 553 Kamalani Academy charter Regular School Yes Elementary PK 8 2020   kindergarten                                                   32.0                                             32
2429026 HI     school 1500030 1   Hawaii Department of Education 150003000303 553 Kamalani Academy charter Regular School Yes Elementary PK 8 2020   grade_1                                                   23.0                                             23
2429319 HI     school 1500030 1   Hawaii Department of Education 150003000303 553 Kamalani Academy charter Regular School Yes Elementary PK 8 2020   grade_2                                                   16.0                                             16
2429612 HI     school 1500030 1   Hawaii Department of Education 150003000303 553 Kamalani Academy charter Regular School Yes Elementary PK 8 2020   grade_3                                                   14.0                                             14
2429905 HI     school 1500030 1   Hawaii Department of Education 150003000303 553 Kamalani Academy charter Regular School Yes Elementary PK 8 2020   grade_4                                                   20.0                                             20
2430198 HI     school 1500030 1   Hawaii Department of Education 150003000303 553 Kamalani Academy charter Regular School Yes Elementary PK 8 2020   grade_5                                                   14.0                                             14
2430491 HI     school 1500030 1   Hawaii Department of Education 150003000303 553 Kamalani Academy charter Regular School Yes Elementary PK 8 2020   grade_6                                                   21.0                                             21
2430784 HI     school 1500030 1   Hawaii Department of Education 150003000303 553 Kamalani Academy charter Regular School Yes Elementary PK 8 2020   grade_7                                                   17.0                                             17
2431077 HI     school 1500030 1   Hawaii Department of Education 150003000303 553 Kamalani Academy charter Regular School Yes Elementary PK 8 2020   grade_8                                                   27.0                                             27
2431370 HI     school 1500030 1   Hawaii Department of Education 150003000303 553 Kamalani Academy charter Regular School Yes Elementary PK 8 2020   grade_9                                                   0.0                                             0
2431663 HI     school 1500030 1   Hawaii Department of Education 150003000303 553 Kamalani Academy charter Regular School Yes Elementary PK 8 2020   grade_10                                                   0.0                                             0
2431956 HI     school 1500030 1   Hawaii Department of Education 150003000303 553 Kamalani Academy charter Regular School Yes Elementary PK 8 2020   grade_11                                                   0.0                                             0
2432249 HI     school 1500030 1   Hawaii Department of Education 150003000303 553 Kamalani Academy charter Regular School Yes Elementary PK 8 2020   grade_12                                                   0.0                                             0
2432542 HI     school 1500030 1   Hawaii Department of Education 150003000303 553 Kamalani Academy charter Regular School Yes Elementary PK 8 2020   pre_kindergarten                                                   0.0                                             0
2432835 HI     school 1500030 1   Hawaii Department of Education 150003000303 553 Kamalani Academy charter Regular School Yes Elementary PK 8 2020   pk_12_total                                               23.0   207.0                                         23   207
2428738 HI     school 1500030 1   Hawaii Department of Education 150003000302 555 Kapolei Charter School charter Regular School Yes Secondary 09 11 2020   kindergarten                                                   0.0                                             0
2429031 HI     school 1500030 1   Hawaii Department of Education 150003000302 555 Kapolei Charter School charter Regular School Yes Secondary 09 11 2020   grade_1                                                   0.0                                             0
2429324 HI     school 1500030 1   Hawaii Department of Education 150003000302 555 Kapolei Charter School charter Regular School Yes Secondary 09 11 2020   grade_2                                                   0.0                                             0
2429617 HI     school 1500030 1   Hawaii Department of Education 150003000302 555 Kapolei Charter School charter Regular School Yes Secondary 09 11 2020   grade_3                                                   0.0                                             0
2429910 HI     school 1500030 1   Hawaii Department of Education 150003000302 555 Kapolei Charter School charter Regular School Yes Secondary 09 11 2020   grade_4                                                   0.0                                             0
2430203 HI     school 1500030 1   Hawaii Department of Education 150003000302 555 Kapolei Charter School charter Regular School Yes Secondary 09 11 2020   grade_5                                                   0.0                                             0
2430496 HI     school 1500030 1   Hawaii Department of Education 150003000302 555 Kapolei Charter School charter Regular School Yes Secondary 09 11 2020   grade_6                                                   0.0                                             0
2430789 HI     school 1500030 1   Hawaii Department of Education 150003000302 555 Kapolei Charter School charter Regular School Yes Secondary 09 11 2020   grade_7                                                   0.0                                             0
2431082 HI     school 1500030 1   Hawaii Department of Education 150003000302 555 Kapolei Charter School charter Regular School Yes Secondary 09 11 2020   grade_8                                                   0.0                                             0
2431375 HI     school 1500030 1   Hawaii Department of Education 150003000302 555 Kapolei Charter School charter Regular School Yes Secondary 09 11 2020   grade_9                                                   43.0                                             43
2431668 HI     school 1500030 1   Hawaii Department of Education 150003000302 555 Kapolei Charter School charter Regular School Yes Secondary 09 11 2020   grade_10                                                   47.0                                             47
2431961 HI     school 1500030 1   Hawaii Department of Education 150003000302 555 Kapolei Charter School charter Regular School Yes Secondary 09 11 2020   grade_11                                                   37.0                                             37
2432254 HI     school 1500030 1   Hawaii Department of Education 150003000302 555 Kapolei Charter School charter Regular School Yes Secondary 09 11 2020   grade_12                                                   0.0                                             0
2432547 HI     school 1500030 1   Hawaii Department of Education 150003000302 555 Kapolei Charter School charter Regular School Yes Secondary 09 11 2020   pre_kindergarten                                                   0.0                                             0
2432840 HI     school 1500030 1   Hawaii Department of Education 150003000302 555 Kapolei Charter School charter Regular School Yes Secondary 09 11 2020   pk_12_total                                               13.0   140.0                                         13   140
2428567 HI     school 1500030 1   Hawaii Department of Education 150003000300 293 Hookele Elem   Regular School No Elementary PK 5 2020   kindergarten                                                   122.0                                             122
2428860 HI     school 1500030 1   Hawaii Department of Education 150003000300 293 Hookele Elem   Regular School No Elementary PK 5 2020   grade_1                                                   158.0                                             158
2429153 HI     school 1500030 1   Hawaii Department of Education 150003000300 293 Hookele Elem   Regular School No Elementary PK 5 2020   grade_2                                                   143.0                                             143
2429446 HI     school 1500030 1   Hawaii Department of Education 150003000300 293 Hookele Elem   Regular School No Elementary PK 5 2020   grade_3                                                   146.0                                             146
2429739 HI     school 1500030 1   Hawaii Department of Education 150003000300 293 Hookele Elem   Regular School No Elementary PK 5 2020   grade_4                                                   158.0                                             158
2430032 HI     school 1500030 1   Hawaii Department of Education 150003000300 293 Hookele Elem   Regular School No Elementary PK 5 2020   grade_5                                                   77.0                                             77
2430325 HI     school 1500030 1   Hawaii Department of Education 150003000300 293 Hookele Elem   Regular School No Elementary PK 5 2020   grade_6                                                   0.0                                             0
2430618 HI     school 1500030 1   Hawaii Department of Education 150003000300 293 Hookele Elem   Regular School No Elementary PK 5 2020   grade_7                                                   0.0                                             0
2430911 HI     school 1500030 1   Hawaii Department of Education 150003000300 293 Hookele Elem   Regular School No Elementary PK 5 2020   grade_8                                                   0.0                                             0
2431204 HI     school 1500030 1   Hawaii Department of Education 150003000300 293 Hookele Elem   Regular School No Elementary PK 5 2020   grade_9                                                   0.0                                             0
2431497 HI     school 1500030 1   Hawaii Department of Education 150003000300 293 Hookele Elem   Regular School No Elementary PK 5 2020   grade_10                                                   0.0                                             0
2431790 HI     school 1500030 1   Hawaii Department of Education 150003000300 293 Hookele Elem   Regular School No Elementary PK 5 2020   grade_11                                                   0.0                                             0
2432083 HI     school 1500030 1   Hawaii Department of Education 150003000300 293 Hookele Elem   Regular School No Elementary PK 5 2020   grade_12                                                   0.0                                             0
2432376 HI     school 1500030 1   Hawaii Department of Education 150003000300 293 Hookele Elem   Regular School No Elementary PK 5 2020   pre_kindergarten                                                   18.0                                             18
2432669 HI     school 1500030 1   Hawaii Department of Education 150003000300 293 Hookele Elem   Regular School No Elementary PK 5 2020   pk_12_total                                               35.0   857.0                                         35   857
2428749 HI     school 1500030 1   Hawaii Department of Education 150003000299 550 Malama Honua charter Regular School Yes Elementary KG 7 2020   kindergarten                                                   20.0                                             20
2429042 HI     school 1500030 1   Hawaii Department of Education 150003000299 550 Malama Honua charter Regular School Yes Elementary KG 7 2020   grade_1                                                   19.0                                             19
2429335 HI     school 1500030 1   Hawaii Department of Education 150003000299 550 Malama Honua charter Regular School Yes Elementary KG 7 2020   grade_2                                                   21.0                                             21
2429628 HI     school 1500030 1   Hawaii Department of Education 150003000299 550 Malama Honua charter Regular School Yes Elementary KG 7 2020   grade_3                                                   18.0                                             18
2429921 HI     school 1500030 1   Hawaii Department of Education 150003000299 550 Malama Honua charter Regular School Yes Elementary KG 7 2020   grade_4                                                   18.0                                             18
2430214 HI     school 1500030 1   Hawaii Department of Education 150003000299 550 Malama Honua charter Regular School Yes Elementary KG 7 2020   grade_5                                                   18.0                                             18
2430507 HI     school 1500030 1   Hawaii Department of Education 150003000299 550 Malama Honua charter Regular School Yes Elementary KG 7 2020   grade_6                                                   7.0                                             7
2430800 HI     school 1500030 1   Hawaii Department of Education 150003000299 550 Malama Honua charter Regular School Yes Elementary KG 7 2020   grade_7                                                   17.0                                             17
2431093 HI     school 1500030 1   Hawaii Department of Education 150003000299 550 Malama Honua charter Regular School Yes Elementary KG 7 2020   grade_8                                                   0.0                                             0
2431386 HI     school 1500030 1   Hawaii Department of Education 150003000299 550 Malama Honua charter Regular School Yes Elementary KG 7 2020   grade_9                                                   0.0                                             0
2431679 HI     school 1500030 1   Hawaii Department of Education 150003000299 550 Malama Honua charter Regular School Yes Elementary KG 7 2020   grade_10                                                   0.0                                             0
2431972 HI     school 1500030 1   Hawaii Department of Education 150003000299 550 Malama Honua charter Regular School Yes Elementary KG 7 2020   grade_11                                                   0.0                                             0
2432265 HI     school 1500030 1   Hawaii Department of Education 150003000299 550 Malama Honua charter Regular School Yes Elementary KG 7 2020   grade_12                                                   0.0                                             0
2432558 HI     school 1500030 1   Hawaii Department of Education 150003000299 550 Malama Honua charter Regular School Yes Elementary KG 7 2020   pre_kindergarten                                                   0.0                                             0
2432851 HI     school 1500030 1   Hawaii Department of Education 150003000299 550 Malama Honua charter Regular School Yes Elementary KG 7 2020   pk_12_total                                               12.0   150.0                                         12   150
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