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
111150 HI     school 1500030 1   Hawaii Department of Education 150003000227 100 AINA HAINA   Regular School No 1 PK 5 2016   pre_kindergarten                                                   9.0                                             9
130153 HI     school 1500030 1   Hawaii Department of Education 150003000227 100 AINA HAINA   Regular School No Elementary PK 5 2017   pre_kindergarten                                                   4.0                                             4
281125 HI     school 1500030 1   Hawaii Department of Education 150003000227 100 AINA HAINA   Regular School No 1 PK 5 2015   pre_kindergarten                                                   7.0                                             7
2432275 HI     school 1500030 1   Hawaii Department of Education 150003000227 100 Aina Haina Elem   Regular School No Elementary PK 5 2020   pre_kindergarten                                                   4.0                                             4
2456969 HI     school 1500030 1   Hawaii Department of Education 150003000227 100 Aina Haina Elem   Regular School No Elementary PK 5 2021   pre_kindergarten                                                   4.0                                             4
2737932 HI     school 1500030 1   Hawaii Department of Education 150003000227 100 Aina Haina Elem   Regular School No Elementary PK 5 2019   pre_kindergarten                                                   4.0                                             4
2782982 HI     school 1500030 1   Hawaii Department of Education 150003000227 100 Aina Haina Elem   Regular School No Elementary PK 5 2018   pre_kindergarten                                                   3.0                                             3
111175 HI     school 1500030 1   Hawaii Department of Education 150003000226 101 ALA WAI   Regular School No 1 PK 5 2016   pre_kindergarten                                                   12.0                                             12
130178 HI     school 1500030 1   Hawaii Department of Education 150003000226 101 ALA WAI   Regular School No Elementary PK 5 2017   pre_kindergarten                                                   10.0                                             10
281150 HI     school 1500030 1   Hawaii Department of Education 150003000226 101 ALA WAI   Regular School No 1 PK 5 2015   pre_kindergarten                                                   8.0                                             8
2432300 HI     school 1500030 1   Hawaii Department of Education 150003000226 101 Ala Wai Elem   Regular School No Elementary PK 5 2020   pre_kindergarten                                                   13.0                                             13
2456994 HI     school 1500030 1   Hawaii Department of Education 150003000226 101 Ala Wai Elem   Regular School No Elementary PK 5 2021   pre_kindergarten                                                   13.0                                             13
2737957 HI     school 1500030 1   Hawaii Department of Education 150003000226 101 Ala Wai Elem   Regular School No Elementary PK 5 2019   pre_kindergarten                                                   9.0                                             9
2783007 HI     school 1500030 1   Hawaii Department of Education 150003000226 101 Ala Wai Elem   Regular School No Elementary PK 5 2018   pre_kindergarten                                                   6.0                                             6
111176 HI     school 1500030 1   Hawaii Department of Education 150003000225 102 ALIIOLANI   Regular School No 1 PK 5 2016   pre_kindergarten                                                   5.0                                             5
130179 HI     school 1500030 1   Hawaii Department of Education 150003000225 102 ALIIOLANI   Regular School No Elementary PK 5 2017   pre_kindergarten                                                   7.0                                             7
281151 HI     school 1500030 1   Hawaii Department of Education 150003000225 102 ALIIOLANI   Regular School No 1 PK 5 2015   pre_kindergarten                                                   7.0                                             7
2432301 HI     school 1500030 1   Hawaii Department of Education 150003000225 102 Aliiolani Elem   Regular School No Elementary PK 5 2020   pre_kindergarten                                                   8.0                                             8
2456995 HI     school 1500030 1   Hawaii Department of Education 150003000225 102 Aliiolani Elem   Regular School No Elementary PK 5 2021   pre_kindergarten                                                   10.0                                             10
2737958 HI     school 1500030 1   Hawaii Department of Education 150003000225 102 Aliiolani Elem   Regular School No Elementary PK 5 2019   pre_kindergarten                                                   5.0                                             5
2783008 HI     school 1500030 1   Hawaii Department of Education 150003000225 102 Aliiolani Elem   Regular School No Elementary PK 5 2018   pre_kindergarten                                                   7.0                                             7
111177 HI     school 1500030 1   Hawaii Department of Education 150003000246 103 ANUENUE   Regular School No 4 PK 12 2016   pre_kindergarten                                                   0.0                                             0
130180 HI     school 1500030 1   Hawaii Department of Education 150003000246 103 ANUENUE   Regular School No Other PK 12 2017   pre_kindergarten                                                   0.0                                             0
281152 HI     school 1500030 1   Hawaii Department of Education 150003000246 103 ANUENUE   Regular School No 4 PK 12 2015   pre_kindergarten                                                   0.0                                             0
2432302 HI     school 1500030 1   Hawaii Department of Education 150003000246 103 Anuenue   Regular School No Other PK 12 2020   pre_kindergarten                                                   0.0                                             0
2456996 HI     school 1500030 1   Hawaii Department of Education 150003000246 103 Anuenue   Regular School No Other PK 12 2021   pre_kindergarten                                                   0.0                                             0
2737959 HI     school 1500030 1   Hawaii Department of Education 150003000246 103 Anuenue   Regular School No Other PK 12 2019   pre_kindergarten                                                   0.0                                             0
2783009 HI     school 1500030 1   Hawaii Department of Education 150003000246 103 Anuenue   Regular School No Other PK 12 2018   pre_kindergarten                                                   0.0                                             0
111178 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 CENTRAL MID   Regular School No 2 06 8 2016   pre_kindergarten                                                   0.0                                             0
130181 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 CENTRAL MID   Regular School No Middle 06 8 2017   pre_kindergarten                                                   0.0                                             0
281153 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 CENTRAL MID   Regular School No 2 06 8 2015   pre_kindergarten                                                   0.0                                             0
2432303 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 Central Middle   Regular School No Middle 06 8 2020   pre_kindergarten                                                   0.0                                             0
2456997 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 Central Middle   Regular School No Middle 06 8 2021   pre_kindergarten                                                   0.0                                             0
2737960 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 Central Middle   Regular School No Middle 06 8 2019   pre_kindergarten                                                   0.0                                             0
2783010 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 Central Middle   Regular School No Middle 06 8 2018   pre_kindergarten                                                   0.0                                             0
111151 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 DOLE MID   Regular School No 2 06 8 2016   pre_kindergarten                                                   0.0                                             0
130154 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 DOLE MID   Regular School No Middle 06 8 2017   pre_kindergarten                                                   0.0                                             0
281126 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 DOLE MID   Regular School No 2 06 8 2015   pre_kindergarten                                                   0.0                                             0
2432276 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 Dole Middle   Regular School No Middle 06 8 2020   pre_kindergarten                                                   0.0                                             0
2456970 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 Dole Middle   Regular School No Middle 06 8 2021   pre_kindergarten                                                   0.0                                             0
2737933 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 Dole Middle   Regular School No Middle 06 8 2019   pre_kindergarten                                                   0.0                                             0
2782983 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 Dole Middle   Regular School No Middle 06 8 2018   pre_kindergarten                                                   0.0                                             0
111152 HI     school 1500030 1   Hawaii Department of Education 150003000221 106 FARRINGTON HI   Regular School No 3 09 12 2016   pre_kindergarten                                                   0.0                                             0
130155 HI     school 1500030 1   Hawaii Department of Education 150003000221 106 FARRINGTON HI   Regular School No High 09 12 2017   pre_kindergarten                                                   0.0                                             0
281127 HI     school 1500030 1   Hawaii Department of Education 150003000221 106 FARRINGTON HI   Regular School No 3 09 12 2015   pre_kindergarten                                                   0.0                                             0
2432277 HI     school 1500030 1   Hawaii Department of Education 150003000221 106 Farrington High   Regular School No High 09 12 2020   pre_kindergarten                                                   0.0                                             0
2456971 HI     school 1500030 1   Hawaii Department of Education 150003000221 106 Farrington High   Regular School No High 09 12 2021   pre_kindergarten                                                   0.0                                             0
2737934 HI     school 1500030 1   Hawaii Department of Education 150003000221 106 Farrington High   Regular School No High 09 12 2019   pre_kindergarten                                                   0.0                                             0
2782984 HI     school 1500030 1   Hawaii Department of Education 150003000221 106 Farrington High   Regular School No High 09 12 2018   pre_kindergarten                                                   0.0                                             0
111153 HI     school 1500030 1   Hawaii Department of Education 150003000220 107 FERN   Regular School No 1 PK 5 2016   pre_kindergarten                                                   3.0                                             3
130156 HI     school 1500030 1   Hawaii Department of Education 150003000220 107 FERN   Regular School No Elementary PK 5 2017   pre_kindergarten                                                   2.0                                             2
281128 HI     school 1500030 1   Hawaii Department of Education 150003000220 107 FERN   Regular School No 1 PK 5 2015   pre_kindergarten                                                   2.0                                             2
2432278 HI     school 1500030 1   Hawaii Department of Education 150003000220 107 Fern Elem   Regular School No Elementary PK 5 2020   pre_kindergarten                                                   4.0                                             4
2456972 HI     school 1500030 1   Hawaii Department of Education 150003000220 107 Fern Elem   Regular School No Elementary PK 5 2021   pre_kindergarten                                                   4.0                                             4
2737935 HI     school 1500030 1   Hawaii Department of Education 150003000220 107 Fern Elem   Regular School No Elementary PK 5 2019   pre_kindergarten                                                   2.0                                             2
2782985 HI     school 1500030 1   Hawaii Department of Education 150003000220 107 Fern Elem   Regular School No Elementary PK 5 2018   pre_kindergarten                                                   4.0                                             4
111154 HI     school 1500030 1   Hawaii Department of Education 150003000219 108 HAHAIONE   Regular School No 1 PK 5 2016   pre_kindergarten                                                   6.0                                             6
130157 HI     school 1500030 1   Hawaii Department of Education 150003000219 108 HAHAIONE   Regular School No Elementary PK 5 2017   pre_kindergarten                                                   9.0                                             9
281129 HI     school 1500030 1   Hawaii Department of Education 150003000219 108 HAHAIONE   Regular School No 1 PK 5 2015   pre_kindergarten                                                   4.0                                             4
2432279 HI     school 1500030 1   Hawaii Department of Education 150003000219 108 Hahaione Elem   Regular School No Elementary PK 5 2020   pre_kindergarten                                                   5.0                                             5
2456973 HI     school 1500030 1   Hawaii Department of Education 150003000219 108 Hahaione Elem   Regular School No Elementary PK 5 2021   pre_kindergarten                                                   3.0                                             3
2737936 HI     school 1500030 1   Hawaii Department of Education 150003000219 108 Hahaione Elem   Regular School No Elementary PK 5 2019   pre_kindergarten                                                   10.0                                             10
2782986 HI     school 1500030 1   Hawaii Department of Education 150003000219 108 Hahaione Elem   Regular School No Elementary PK 5 2018   pre_kindergarten                                                   11.0                                             11
111179 HI     school 1500030 1   Hawaii Department of Education 150003000214 109 HOKULANI   Regular School No 1 PK 5 2016   pre_kindergarten                                                   0.0                                             0
130182 HI     school 1500030 1   Hawaii Department of Education 150003000214 109 HOKULANI   Regular School No Elementary PK 5 2017   pre_kindergarten                                                   0.0                                             0
281154 HI     school 1500030 1   Hawaii Department of Education 150003000214 109 HOKULANI   Regular School No 1 PK 5 2015   pre_kindergarten                                                   1.0                                             1
2432304 HI     school 1500030 1   Hawaii Department of Education 150003000214 109 Hokulani Elem   Regular School No Elementary PK 5 2020   pre_kindergarten                                                   0.0                                             0
2456998 HI     school 1500030 1   Hawaii Department of Education 150003000214 109 Hokulani Elem   Regular School No Elementary PK 5 2021   pre_kindergarten                                                   0.0                                             0
2737961 HI     school 1500030 1   Hawaii Department of Education 150003000214 109 Hokulani Elem   Regular School No Elementary PK 5 2019   pre_kindergarten                                                   0.0                                             0
2783011 HI     school 1500030 1   Hawaii Department of Education 150003000214 109 Hokulani Elem   Regular School No Elementary PK 5 2018   pre_kindergarten                                                   0.0                                             0
111180 HI     school 1500030 1   Hawaii Department of Education 150003000218 110 JARRETT MID   Regular School No 2 06 8 2016   pre_kindergarten                                                   0.0                                             0
130183 HI     school 1500030 1   Hawaii Department of Education 150003000218 110 JARRETT MID   Regular School No Middle 06 8 2017   pre_kindergarten                                                   0.0                                             0
281155 HI     school 1500030 1   Hawaii Department of Education 150003000218 110 JARRETT MID   Regular School No 2 06 8 2015   pre_kindergarten                                                   0.0                                             0
2432305 HI     school 1500030 1   Hawaii Department of Education 150003000218 110 Jarrett Middle   Regular School No Middle 06 8 2020   pre_kindergarten                                                   0.0                                             0
2456999 HI     school 1500030 1   Hawaii Department of Education 150003000218 110 Jarrett Middle   Regular School No Middle 06 8 2021   pre_kindergarten                                                   0.0                                             0
2737962 HI     school 1500030 1   Hawaii Department of Education 150003000218 110 Jarrett Middle   Regular School No Middle 06 8 2019   pre_kindergarten                                                   0.0                                             0
2783012 HI     school 1500030 1   Hawaii Department of Education 150003000218 110 Jarrett Middle   Regular School No Middle 06 8 2018   pre_kindergarten                                                   0.0                                             0
111181 HI     school 1500030 1   Hawaii Department of Education 150003000213 111 JEFFERSON   Regular School No 1 PK 5 2016   pre_kindergarten                                                   7.0                                             7
130184 HI     school 1500030 1   Hawaii Department of Education 150003000213 111 JEFFERSON   Regular School No Elementary PK 5 2017   pre_kindergarten                                                   7.0                                             7
281156 HI     school 1500030 1   Hawaii Department of Education 150003000213 111 JEFFERSON   Regular School No 1 PK 5 2015   pre_kindergarten                                                   7.0                                             7
2432306 HI     school 1500030 1   Hawaii Department of Education 150003000213 111 Jefferson Elem   Regular School No Elementary PK 5 2020   pre_kindergarten                                                   9.0                                             9
2457000 HI     school 1500030 1   Hawaii Department of Education 150003000213 111 Jefferson Elem   Regular School No Elementary PK 5 2021   pre_kindergarten                                                   8.0                                             8
2737963 HI     school 1500030 1   Hawaii Department of Education 150003000213 111 Jefferson Elem   Regular School No Elementary PK 5 2019   pre_kindergarten                                                   11.0                                             11
2783013 HI     school 1500030 1   Hawaii Department of Education 150003000213 111 Jefferson Elem   Regular School No Elementary PK 5 2018   pre_kindergarten                                                   11.0                                             11
111182 HI     school 1500030 1   Hawaii Department of Education 150003000217 112 KAAHUMANU   Regular School No 1 PK 5 2016   pre_kindergarten                                                   22.0                                             22
130185 HI     school 1500030 1   Hawaii Department of Education 150003000217 112 KAAHUMANU   Regular School No Elementary PK 5 2017   pre_kindergarten                                                   16.0                                             16
281157 HI     school 1500030 1   Hawaii Department of Education 150003000217 112 KAAHUMANU   Regular School No 1 PK 5 2015   pre_kindergarten                                                   20.0                                             20
2432307 HI     school 1500030 1   Hawaii Department of Education 150003000217 112 Kaahumanu Elem   Regular School No Elementary PK 5 2020   pre_kindergarten                                                   19.0                                             19
2457001 HI     school 1500030 1   Hawaii Department of Education 150003000217 112 Kaahumanu Elem   Regular School No Elementary PK 5 2021   pre_kindergarten                                                   15.0                                             15
2737964 HI     school 1500030 1   Hawaii Department of Education 150003000217 112 Kaahumanu Elem   Regular School No Elementary PK 5 2019   pre_kindergarten                                                   15.0                                             15
2783014 HI     school 1500030 1   Hawaii Department of Education 150003000217 112 Kaahumanu Elem   Regular School No Elementary PK 5 2018   pre_kindergarten                                                   15.0                                             15
111156 HI     school 1500030 1   Hawaii Department of Education 150003000216 113 KAEWAI   Regular School No 1 PK 5 2016   pre_kindergarten                                                   5.0                                             5
130159 HI     school 1500030 1   Hawaii Department of Education 150003000216 113 KAEWAI   Regular School No Elementary PK 5 2017   pre_kindergarten                                                   2.0                                             2
281131 HI     school 1500030 1   Hawaii Department of Education 150003000216 113 KAEWAI   Regular School No 1 PK 5 2015   pre_kindergarten                                                   7.0                                             7
2432281 HI     school 1500030 1   Hawaii Department of Education 150003000216 113 Kaewai Elem   Regular School No Elementary PK 5 2020   pre_kindergarten                                                   10.0                                             10
2456975 HI     school 1500030 1   Hawaii Department of Education 150003000216 113 Kaewai Elem   Regular School No Elementary PK 5 2021   pre_kindergarten                                                   6.0                                             6
2737938 HI     school 1500030 1   Hawaii Department of Education 150003000216 113 Kaewai Elem   Regular School No Elementary PK 5 2019   pre_kindergarten                                                   6.0                                             6
2782988 HI     school 1500030 1   Hawaii Department of Education 150003000216 113 Kaewai Elem   Regular School No Elementary PK 5 2018   pre_kindergarten                                                   2.0                                             2
111157 HI     school 1500030 1   Hawaii Department of Education 150003000215 114 KAHALA   Regular School No 1 PK 5 2016   pre_kindergarten                                                   11.0                                             11
130160 HI     school 1500030 1   Hawaii Department of Education 150003000215 114 KAHALA   Regular School No Elementary PK 5 2017   pre_kindergarten                                                   10.0                                             10
281132 HI     school 1500030 1   Hawaii Department of Education 150003000215 114 KAHALA   Regular School No 1 PK 5 2015   pre_kindergarten                                                   4.0                                             4