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
277532 HI     school 1500030 1   Hawaii Department of Education 150003000098 475 OLOMANA   Alternative Education School No 3 07 12 2015   kindergarten                                                   0.0                                             0
277821 HI     school 1500030 1   Hawaii Department of Education 150003000098 475 OLOMANA   Alternative Education School No 3 07 12 2015   grade_1                                                   0.0                                             0
278110 HI     school 1500030 1   Hawaii Department of Education 150003000098 475 OLOMANA   Alternative Education School No 3 07 12 2015   grade_2                                                   0.0                                             0
278399 HI     school 1500030 1   Hawaii Department of Education 150003000098 475 OLOMANA   Alternative Education School No 3 07 12 2015   grade_3                                                   0.0                                             0
278688 HI     school 1500030 1   Hawaii Department of Education 150003000098 475 OLOMANA   Alternative Education School No 3 07 12 2015   grade_4                                                   0.0                                             0
278977 HI     school 1500030 1   Hawaii Department of Education 150003000098 475 OLOMANA   Alternative Education School No 3 07 12 2015   grade_5                                                   0.0                                             0
279266 HI     school 1500030 1   Hawaii Department of Education 150003000098 475 OLOMANA   Alternative Education School No 3 07 12 2015   grade_6                                                   0.0                                             0
279555 HI     school 1500030 1   Hawaii Department of Education 150003000098 475 OLOMANA   Alternative Education School No 3 07 12 2015   grade_7                                                   3.0                                             3
279844 HI     school 1500030 1   Hawaii Department of Education 150003000098 475 OLOMANA   Alternative Education School No 3 07 12 2015   grade_8                                                   3.0                                             3
280133 HI     school 1500030 1   Hawaii Department of Education 150003000098 475 OLOMANA   Alternative Education School No 3 07 12 2015   grade_9                                                   12.0                                             12
280422 HI     school 1500030 1   Hawaii Department of Education 150003000098 475 OLOMANA   Alternative Education School No 3 07 12 2015   grade_10                                                   11.0                                             11
280711 HI     school 1500030 1   Hawaii Department of Education 150003000098 475 OLOMANA   Alternative Education School No 3 07 12 2015   grade_11                                                   12.0                                             12
281000 HI     school 1500030 1   Hawaii Department of Education 150003000098 475 OLOMANA   Alternative Education School No 3 07 12 2015   grade_12                                                   5.0                                             5
281289 HI     school 1500030 1   Hawaii Department of Education 150003000098 475 OLOMANA   Alternative Education School No 3 07 12 2015   pre_kindergarten                                                   0.0                                             0
281578 HI     school 1500030 1   Hawaii Department of Education 150003000098 475 OLOMANA   Alternative Education School No 3 07 12 2015   pk_12_total                                               26.0   72.0                                         26   72
107545 HI     school 1500030 1   Hawaii Department of Education 150003000098 475 OLOMANA   Alternative Education School No 3 07 12 2016   kindergarten                                                   0.0                                             0
107835 HI     school 1500030 1   Hawaii Department of Education 150003000098 475 OLOMANA   Alternative Education School No 3 07 12 2016   grade_1                                                   0.0                                             0
108125 HI     school 1500030 1   Hawaii Department of Education 150003000098 475 OLOMANA   Alternative Education School No 3 07 12 2016   grade_2                                                   0.0                                             0
108415 HI     school 1500030 1   Hawaii Department of Education 150003000098 475 OLOMANA   Alternative Education School No 3 07 12 2016   grade_3                                                   0.0                                             0
108705 HI     school 1500030 1   Hawaii Department of Education 150003000098 475 OLOMANA   Alternative Education School No 3 07 12 2016   grade_4                                                   0.0                                             0
108995 HI     school 1500030 1   Hawaii Department of Education 150003000098 475 OLOMANA   Alternative Education School No 3 07 12 2016   grade_5                                                   0.0                                             0
109285 HI     school 1500030 1   Hawaii Department of Education 150003000098 475 OLOMANA   Alternative Education School No 3 07 12 2016   grade_6                                                   0.0                                             0
109575 HI     school 1500030 1   Hawaii Department of Education 150003000098 475 OLOMANA   Alternative Education School No 3 07 12 2016   grade_7                                                   5.0                                             5
109865 HI     school 1500030 1   Hawaii Department of Education 150003000098 475 OLOMANA   Alternative Education School No 3 07 12 2016   grade_8                                                   1.0                                             1
110155 HI     school 1500030 1   Hawaii Department of Education 150003000098 475 OLOMANA   Alternative Education School No 3 07 12 2016   grade_9                                                   8.0                                             8
110445 HI     school 1500030 1   Hawaii Department of Education 150003000098 475 OLOMANA   Alternative Education School No 3 07 12 2016   grade_10                                                   13.0                                             13
110735 HI     school 1500030 1   Hawaii Department of Education 150003000098 475 OLOMANA   Alternative Education School No 3 07 12 2016   grade_11                                                   14.0                                             14
111025 HI     school 1500030 1   Hawaii Department of Education 150003000098 475 OLOMANA   Alternative Education School No 3 07 12 2016   grade_12                                                   4.0                                             4
111315 HI     school 1500030 1   Hawaii Department of Education 150003000098 475 OLOMANA   Alternative Education School No 3 07 12 2016   pre_kindergarten                                                   0.0                                             0
111605 HI     school 1500030 1   Hawaii Department of Education 150003000098 475 OLOMANA   Alternative Education School No 3 07 12 2016   pk_12_total                                               29.0   74.0                                         29   74
126548 HI     school 1500030 1   Hawaii Department of Education 150003000098 475 OLOMANA   Alternative School No High 07 12 2017   kindergarten                                                   0.0                                             0
126838 HI     school 1500030 1   Hawaii Department of Education 150003000098 475 OLOMANA   Alternative School No High 07 12 2017   grade_1                                                   0.0                                             0
127128 HI     school 1500030 1   Hawaii Department of Education 150003000098 475 OLOMANA   Alternative School No High 07 12 2017   grade_2                                                   0.0                                             0
127418 HI     school 1500030 1   Hawaii Department of Education 150003000098 475 OLOMANA   Alternative School No High 07 12 2017   grade_3                                                   0.0                                             0
127708 HI     school 1500030 1   Hawaii Department of Education 150003000098 475 OLOMANA   Alternative School No High 07 12 2017   grade_4                                                   0.0                                             0
127998 HI     school 1500030 1   Hawaii Department of Education 150003000098 475 OLOMANA   Alternative School No High 07 12 2017   grade_5                                                   0.0                                             0
128288 HI     school 1500030 1   Hawaii Department of Education 150003000098 475 OLOMANA   Alternative School No High 07 12 2017   grade_6                                                   0.0                                             0
128578 HI     school 1500030 1   Hawaii Department of Education 150003000098 475 OLOMANA   Alternative School No High 07 12 2017   grade_7                                                   1.0                                             1
128868 HI     school 1500030 1   Hawaii Department of Education 150003000098 475 OLOMANA   Alternative School No High 07 12 2017   grade_8                                                   7.0                                             7
129158 HI     school 1500030 1   Hawaii Department of Education 150003000098 475 OLOMANA   Alternative School No High 07 12 2017   grade_9                                                   8.0                                             8
129448 HI     school 1500030 1   Hawaii Department of Education 150003000098 475 OLOMANA   Alternative School No High 07 12 2017   grade_10                                                   14.0                                             14
129738 HI     school 1500030 1   Hawaii Department of Education 150003000098 475 OLOMANA   Alternative School No High 07 12 2017   grade_11                                                   9.0                                             9
130028 HI     school 1500030 1   Hawaii Department of Education 150003000098 475 OLOMANA   Alternative School No High 07 12 2017   grade_12                                                   7.0                                             7
130318 HI     school 1500030 1   Hawaii Department of Education 150003000098 475 OLOMANA   Alternative School No High 07 12 2017   pre_kindergarten                                                   0.0                                             0
130608 HI     school 1500030 1   Hawaii Department of Education 150003000098 475 OLOMANA   Alternative School No High 07 12 2017   pk_12_total                                               23.0   69.0                                         23   69
2779351 HI     school 1500030 1   Hawaii Department of Education 150003000098 475 Olomana   Alternative School No High 07 12 2018   kindergarten                                                   0.0                                             0
2779643 HI     school 1500030 1   Hawaii Department of Education 150003000098 475 Olomana   Alternative School No High 07 12 2018   grade_1                                                   0.0                                             0
2779935 HI     school 1500030 1   Hawaii Department of Education 150003000098 475 Olomana   Alternative School No High 07 12 2018   grade_2                                                   0.0                                             0
2780227 HI     school 1500030 1   Hawaii Department of Education 150003000098 475 Olomana   Alternative School No High 07 12 2018   grade_3                                                   0.0                                             0
2780519 HI     school 1500030 1   Hawaii Department of Education 150003000098 475 Olomana   Alternative School No High 07 12 2018   grade_4                                                   0.0                                             0
2780811 HI     school 1500030 1   Hawaii Department of Education 150003000098 475 Olomana   Alternative School No High 07 12 2018   grade_5                                                   0.0                                             0
2781103 HI     school 1500030 1   Hawaii Department of Education 150003000098 475 Olomana   Alternative School No High 07 12 2018   grade_6                                                   0.0                                             0
2781395 HI     school 1500030 1   Hawaii Department of Education 150003000098 475 Olomana   Alternative School No High 07 12 2018   grade_7                                                   4.0                                             4
2781687 HI     school 1500030 1   Hawaii Department of Education 150003000098 475 Olomana   Alternative School No High 07 12 2018   grade_8                                                   2.0                                             2
2781979 HI     school 1500030 1   Hawaii Department of Education 150003000098 475 Olomana   Alternative School No High 07 12 2018   grade_9                                                   7.0                                             7
2782271 HI     school 1500030 1   Hawaii Department of Education 150003000098 475 Olomana   Alternative School No High 07 12 2018   grade_10                                                   21.0                                             21
2782563 HI     school 1500030 1   Hawaii Department of Education 150003000098 475 Olomana   Alternative School No High 07 12 2018   grade_11                                                   7.0                                             7
2782855 HI     school 1500030 1   Hawaii Department of Education 150003000098 475 Olomana   Alternative School No High 07 12 2018   grade_12                                                   6.0                                             6
2783147 HI     school 1500030 1   Hawaii Department of Education 150003000098 475 Olomana   Alternative School No High 07 12 2018   pre_kindergarten                                                   0.0                                             0
2783439 HI     school 1500030 1   Hawaii Department of Education 150003000098 475 Olomana   Alternative School No High 07 12 2018   pk_12_total                                               22.0   69.0                                         22   69
2734301 HI     school 1500030 1   Hawaii Department of Education 150003000098 475 Olomana   Alternative School No High 07 12 2019   kindergarten                                                   0.0                                             0
2734593 HI     school 1500030 1   Hawaii Department of Education 150003000098 475 Olomana   Alternative School No High 07 12 2019   grade_1                                                   0.0                                             0
2734885 HI     school 1500030 1   Hawaii Department of Education 150003000098 475 Olomana   Alternative School No High 07 12 2019   grade_2                                                   0.0                                             0
2735177 HI     school 1500030 1   Hawaii Department of Education 150003000098 475 Olomana   Alternative School No High 07 12 2019   grade_3                                                   0.0                                             0
2735469 HI     school 1500030 1   Hawaii Department of Education 150003000098 475 Olomana   Alternative School No High 07 12 2019   grade_4                                                   0.0                                             0
2735761 HI     school 1500030 1   Hawaii Department of Education 150003000098 475 Olomana   Alternative School No High 07 12 2019   grade_5                                                   0.0                                             0
2736053 HI     school 1500030 1   Hawaii Department of Education 150003000098 475 Olomana   Alternative School No High 07 12 2019   grade_6                                                   0.0                                             0
2736345 HI     school 1500030 1   Hawaii Department of Education 150003000098 475 Olomana   Alternative School No High 07 12 2019   grade_7                                                   2.0                                             2
2736637 HI     school 1500030 1   Hawaii Department of Education 150003000098 475 Olomana   Alternative School No High 07 12 2019   grade_8                                                   2.0                                             2
2736929 HI     school 1500030 1   Hawaii Department of Education 150003000098 475 Olomana   Alternative School No High 07 12 2019   grade_9                                                   10.0                                             10
2737221 HI     school 1500030 1   Hawaii Department of Education 150003000098 475 Olomana   Alternative School No High 07 12 2019   grade_10                                                   14.0                                             14
2737513 HI     school 1500030 1   Hawaii Department of Education 150003000098 475 Olomana   Alternative School No High 07 12 2019   grade_11                                                   7.0                                             7
2737805 HI     school 1500030 1   Hawaii Department of Education 150003000098 475 Olomana   Alternative School No High 07 12 2019   grade_12                                                   12.0                                             12
2738097 HI     school 1500030 1   Hawaii Department of Education 150003000098 475 Olomana   Alternative School No High 07 12 2019   pre_kindergarten                                                   0.0                                             0
2738389 HI     school 1500030 1   Hawaii Department of Education 150003000098 475 Olomana   Alternative School No High 07 12 2019   pk_12_total                                               24.0   71.0                                         24   71
2428631 HI     school 1500030 1   Hawaii Department of Education 150003000098 475 Olomana   Alternative School No High 07 12 2020   kindergarten                                                   0.0                                             0
2428924 HI     school 1500030 1   Hawaii Department of Education 150003000098 475 Olomana   Alternative School No High 07 12 2020   grade_1                                                   0.0                                             0
2429217 HI     school 1500030 1   Hawaii Department of Education 150003000098 475 Olomana   Alternative School No High 07 12 2020   grade_2                                                   0.0                                             0
2429510 HI     school 1500030 1   Hawaii Department of Education 150003000098 475 Olomana   Alternative School No High 07 12 2020   grade_3                                                   0.0                                             0
2429803 HI     school 1500030 1   Hawaii Department of Education 150003000098 475 Olomana   Alternative School No High 07 12 2020   grade_4                                                   0.0                                             0
2430096 HI     school 1500030 1   Hawaii Department of Education 150003000098 475 Olomana   Alternative School No High 07 12 2020   grade_5                                                   0.0                                             0
2430389 HI     school 1500030 1   Hawaii Department of Education 150003000098 475 Olomana   Alternative School No High 07 12 2020   grade_6                                                   0.0                                             0
2430682 HI     school 1500030 1   Hawaii Department of Education 150003000098 475 Olomana   Alternative School No High 07 12 2020   grade_7                                                   1.0                                             1
2430975 HI     school 1500030 1   Hawaii Department of Education 150003000098 475 Olomana   Alternative School No High 07 12 2020   grade_8                                                   7.0                                             7
2431268 HI     school 1500030 1   Hawaii Department of Education 150003000098 475 Olomana   Alternative School No High 07 12 2020   grade_9                                                   24.0                                             24
2431561 HI     school 1500030 1   Hawaii Department of Education 150003000098 475 Olomana   Alternative School No High 07 12 2020   grade_10                                                   23.0                                             23
2431854 HI     school 1500030 1   Hawaii Department of Education 150003000098 475 Olomana   Alternative School No High 07 12 2020   grade_11                                                   13.0                                             13
2432147 HI     school 1500030 1   Hawaii Department of Education 150003000098 475 Olomana   Alternative School No High 07 12 2020   grade_12                                                   9.0                                             9
2432440 HI     school 1500030 1   Hawaii Department of Education 150003000098 475 Olomana   Alternative School No High 07 12 2020   pre_kindergarten                                                   0.0                                             0
2432733 HI     school 1500030 1   Hawaii Department of Education 150003000098 475 Olomana   Alternative School No High 07 12 2020   pk_12_total                                               26.0   103.0                                         26   103
2453313 HI     school 1500030 1   Hawaii Department of Education 150003000098 475 Olomana   Alternative School No High 07 12 2021   kindergarten                                                   0.0                                             0
2453607 HI     school 1500030 1   Hawaii Department of Education 150003000098 475 Olomana   Alternative School No High 07 12 2021   grade_1                                                   0.0                                             0
2453901 HI     school 1500030 1   Hawaii Department of Education 150003000098 475 Olomana   Alternative School No High 07 12 2021   grade_2                                                   0.0                                             0
2454195 HI     school 1500030 1   Hawaii Department of Education 150003000098 475 Olomana   Alternative School No High 07 12 2021   grade_3                                                   0.0                                             0
2454489 HI     school 1500030 1   Hawaii Department of Education 150003000098 475 Olomana   Alternative School No High 07 12 2021   grade_4                                                   0.0                                             0
2454783 HI     school 1500030 1   Hawaii Department of Education 150003000098 475 Olomana   Alternative School No High 07 12 2021   grade_5                                                   0.0                                             0
2455077 HI     school 1500030 1   Hawaii Department of Education 150003000098 475 Olomana   Alternative School No High 07 12 2021   grade_6                                                   0.0                                             0
2455371 HI     school 1500030 1   Hawaii Department of Education 150003000098 475 Olomana   Alternative School No High 07 12 2021   grade_7                                                   2.0                                             2
2455665 HI     school 1500030 1   Hawaii Department of Education 150003000098 475 Olomana   Alternative School No High 07 12 2021   grade_8                                                   1.0                                             1
2455959 HI     school 1500030 1   Hawaii Department of Education 150003000098 475 Olomana   Alternative School No High 07 12 2021   grade_9                                                   9.0                                             9
2456253 HI     school 1500030 1   Hawaii Department of Education 150003000098 475 Olomana   Alternative School No High 07 12 2021   grade_10                                                   17.0                                             17