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
109174 HI     school 1500030 1   Hawaii Department of Education 150003000177 202 AIEA HI   Regular School No 3 09 12 2016   grade_6                                                   0.0                                             0
128177 HI     school 1500030 1   Hawaii Department of Education 150003000177 202 AIEA HI   Regular School No High 09 12 2017   grade_6                                                   0.0                                             0
279156 HI     school 1500030 1   Hawaii Department of Education 150003000177 202 AIEA HI   Regular School No 3 09 12 2015   grade_6                                                   0.0                                             0
109175 HI     school 1500030 1   Hawaii Department of Education 150003000176 201 AIEA INT   Regular School No 2 07 8 2016   grade_6                                                   0.0                                             0
128178 HI     school 1500030 1   Hawaii Department of Education 150003000176 201 AIEA INT   Regular School No Middle 07 8 2017   grade_6                                                   0.0                                             0
279157 HI     school 1500030 1   Hawaii Department of Education 150003000176 201 AIEA INT   Regular School No 2 07 8 2015   grade_6                                                   0.0                                             0
109274 HI     school 1500030 1   Hawaii Department of Education 150003000101 300 AIKAHI   Regular School No 1 PK 6 2016   grade_6                                                   60.0                                             60
128277 HI     school 1500030 1   Hawaii Department of Education 150003000101 300 AIKAHI   Regular School No Elementary PK 6 2017   grade_6                                                   43.0                                             43
279255 HI     school 1500030 1   Hawaii Department of Education 150003000101 300 AIKAHI   Regular School No 1 PK 6 2015   grade_6                                                   50.0                                             50
109120 HI     school 1500030 1   Hawaii Department of Education 150003000227 100 AINA HAINA   Regular School No 1 PK 5 2016   grade_6                                                   0.0                                             0
128123 HI     school 1500030 1   Hawaii Department of Education 150003000227 100 AINA HAINA   Regular School No Elementary PK 5 2017   grade_6                                                   0.0                                             0
279102 HI     school 1500030 1   Hawaii Department of Education 150003000227 100 AINA HAINA   Regular School No 1 PK 5 2015   grade_6                                                                                                  
109145 HI     school 1500030 1   Hawaii Department of Education 150003000226 101 ALA WAI   Regular School No 1 PK 5 2016   grade_6                                                   0.0                                             0
128148 HI     school 1500030 1   Hawaii Department of Education 150003000226 101 ALA WAI   Regular School No Elementary PK 5 2017   grade_6                                                   0.0                                             0
279127 HI     school 1500030 1   Hawaii Department of Education 150003000226 101 ALA WAI   Regular School No 1 PK 5 2015   grade_6                                                   0.0                                             0
109176 HI     school 1500030 1   Hawaii Department of Education 150003000175 203 ALIAMANU EL   Regular School No 1 PK 6 2016   grade_6                                                   74.0                                             74
128179 HI     school 1500030 1   Hawaii Department of Education 150003000175 203 ALIAMANU EL   Regular School No Elementary PK 6 2017   grade_6                                                   89.0                                             89
279158 HI     school 1500030 1   Hawaii Department of Education 150003000175 203 ALIAMANU EL   Regular School No 1 PK 6 2015   grade_6                                                   78.0                                             78
109177 HI     school 1500030 1   Hawaii Department of Education 150003000174 204 ALIAMANU INT   Regular School No 2 07 8 2016   grade_6                                                   0.0                                             0
128180 HI     school 1500030 1   Hawaii Department of Education 150003000174 204 ALIAMANU INT   Regular School No Middle 07 8 2017   grade_6                                                   0.0                                             0
279159 HI     school 1500030 1   Hawaii Department of Education 150003000174 204 ALIAMANU INT   Regular School No 2 07 8 2015   grade_6                                                   0.0                                             0
109146 HI     school 1500030 1   Hawaii Department of Education 150003000225 102 ALIIOLANI   Regular School No 1 PK 5 2016   grade_6                                                   0.0                                             0
128149 HI     school 1500030 1   Hawaii Department of Education 150003000225 102 ALIIOLANI   Regular School No Elementary PK 5 2017   grade_6                                                   0.0                                             0
279128 HI     school 1500030 1   Hawaii Department of Education 150003000225 102 ALIIOLANI   Regular School No 1 PK 5 2015   grade_6                                                   0.0                                             0
109147 HI     school 1500030 1   Hawaii Department of Education 150003000246 103 ANUENUE   Regular School No 4 PK 12 2016   grade_6                                                   23.0                                             23
128150 HI     school 1500030 1   Hawaii Department of Education 150003000246 103 ANUENUE   Regular School No Other PK 12 2017   grade_6                                                   32.0                                             32
279129 HI     school 1500030 1   Hawaii Department of Education 150003000246 103 ANUENUE   Regular School No 4 PK 12 2015   grade_6                                                   34.0                                             34
2455033 HI     school 1500030 1   Hawaii Department of Education 150003000136 250 Ahrens Elem   Regular School No Elementary PK 6 2021   grade_6                                                   156.0                                             156
2430362 HI     school 1500030 1   Hawaii Department of Education 150003000157 335 Ahuimanu Elem   Regular School No Elementary PK 6 2020   grade_6                                                   39.0                                             39
2455050 HI     school 1500030 1   Hawaii Department of Education 150003000157 335 Ahuimanu Elem   Regular School No Elementary PK 6 2021   grade_6                                                   29.0                                             29
2736026 HI     school 1500030 1   Hawaii Department of Education 150003000157 335 Ahuimanu Elem   Regular School No Elementary PK 6 2019   grade_6                                                   37.0                                             37
2781076 HI     school 1500030 1   Hawaii Department of Education 150003000157 335 Ahuimanu Elem   Regular School No Elementary PK 6 2018   grade_6                                                   29.0                                             29
2430277 HI     school 1500030 1   Hawaii Department of Education 150003000178 200 Aiea Elem   Regular School No Elementary PK 6 2020   grade_6                                                   45.0                                             45
2454964 HI     school 1500030 1   Hawaii Department of Education 150003000178 200 Aiea Elem   Regular School No Elementary PK 6 2021   grade_6                                                   34.0                                             34
2735941 HI     school 1500030 1   Hawaii Department of Education 150003000178 200 Aiea Elem   Regular School No Elementary PK 6 2019   grade_6                                                   52.0                                             52
2780991 HI     school 1500030 1   Hawaii Department of Education 150003000178 200 Aiea Elem   Regular School No Elementary PK 6 2018   grade_6                                                   51.0                                             51
2430278 HI     school 1500030 1   Hawaii Department of Education 150003000177 202 Aiea High   Regular School No High 09 12 2020   grade_6                                                   0.0                                             0
2454965 HI     school 1500030 1   Hawaii Department of Education 150003000177 202 Aiea High   Regular School No High 09 12 2021   grade_6                                                   0.0                                             0
2735942 HI     school 1500030 1   Hawaii Department of Education 150003000177 202 Aiea High   Regular School No High 09 12 2019   grade_6                                                   0.0                                             0
2780992 HI     school 1500030 1   Hawaii Department of Education 150003000177 202 Aiea High   Regular School No High 09 12 2018   grade_6                                                   0.0                                             0
2430279 HI     school 1500030 1   Hawaii Department of Education 150003000176 201 Aiea Int   Regular School No Middle 07 8 2020   grade_6                                                   0.0                                             0
2454966 HI     school 1500030 1   Hawaii Department of Education 150003000176 201 Aiea Int   Regular School No Middle 07 8 2021   grade_6                                                   0.0                                             0
2735943 HI     school 1500030 1   Hawaii Department of Education 150003000176 201 Aiea Int   Regular School No Middle 07 8 2019   grade_6                                                   0.0                                             0
2780993 HI     school 1500030 1   Hawaii Department of Education 150003000176 201 Aiea Int   Regular School No Middle 07 8 2018   grade_6                                                   0.0                                             0
2430378 HI     school 1500030 1   Hawaii Department of Education 150003000101 300 Aikahi Elem   Regular School No Elementary PK 6 2020   grade_6                                                   69.0                                             69
2455066 HI     school 1500030 1   Hawaii Department of Education 150003000101 300 Aikahi Elem   Regular School No Elementary PK 6 2021   grade_6                                                   53.0                                             53
2736042 HI     school 1500030 1   Hawaii Department of Education 150003000101 300 Aikahi Elem   Regular School No Elementary PK 6 2019   grade_6                                                   41.0                                             41
2781092 HI     school 1500030 1   Hawaii Department of Education 150003000101 300 Aikahi Elem   Regular School No Elementary PK 6 2018   grade_6                                                   59.0                                             59
2430224 HI     school 1500030 1   Hawaii Department of Education 150003000227 100 Aina Haina Elem   Regular School No Elementary PK 5 2020   grade_6                                                   0.0                                             0
2454911 HI     school 1500030 1   Hawaii Department of Education 150003000227 100 Aina Haina Elem   Regular School No Elementary PK 5 2021   grade_6                                                   0.0                                             0
2735888 HI     school 1500030 1   Hawaii Department of Education 150003000227 100 Aina Haina Elem   Regular School No Elementary PK 5 2019   grade_6                                                   0.0                                             0
2780938 HI     school 1500030 1   Hawaii Department of Education 150003000227 100 Aina Haina Elem   Regular School No Elementary PK 5 2018   grade_6                                                   0.0                                             0
2430249 HI     school 1500030 1   Hawaii Department of Education 150003000226 101 Ala Wai Elem   Regular School No Elementary PK 5 2020   grade_6                                                   0.0                                             0
2454936 HI     school 1500030 1   Hawaii Department of Education 150003000226 101 Ala Wai Elem   Regular School No Elementary PK 5 2021   grade_6                                                   0.0                                             0
2735913 HI     school 1500030 1   Hawaii Department of Education 150003000226 101 Ala Wai Elem   Regular School No Elementary PK 5 2019   grade_6                                                   0.0                                             0
2780963 HI     school 1500030 1   Hawaii Department of Education 150003000226 101 Ala Wai Elem   Regular School No Elementary PK 5 2018   grade_6                                                   0.0                                             0
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
2455168 HI     school 1500030 1   Hawaii Department of Education 150003000304 558 Alakai O Kauai PCS charter Regular School Yes Elementary KG 6 2021   grade_6                                                   14.0                                             14
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
2430280 HI     school 1500030 1   Hawaii Department of Education 150003000175 203 Aliamanu Elem   Regular School No Elementary PK 6 2020   grade_6                                                   83.0                                             83
2454967 HI     school 1500030 1   Hawaii Department of Education 150003000175 203 Aliamanu Elem   Regular School No Elementary PK 6 2021   grade_6                                                   67.0                                             67
2735944 HI     school 1500030 1   Hawaii Department of Education 150003000175 203 Aliamanu Elem   Regular School No Elementary PK 6 2019   grade_6                                                   99.0                                             99
2780994 HI     school 1500030 1   Hawaii Department of Education 150003000175 203 Aliamanu Elem   Regular School No Elementary PK 6 2018   grade_6                                                   72.0                                             72
2430281 HI     school 1500030 1   Hawaii Department of Education 150003000174 204 Aliamanu Middle   Regular School No Middle 07 8 2020   grade_6                                                   0.0                                             0
2454968 HI     school 1500030 1   Hawaii Department of Education 150003000174 204 Aliamanu Middle   Regular School No Middle 07 8 2021   grade_6                                                   0.0                                             0
2735945 HI     school 1500030 1   Hawaii Department of Education 150003000174 204 Aliamanu Middle   Regular School No Middle 07 8 2019   grade_6                                                   0.0                                             0
2780995 HI     school 1500030 1   Hawaii Department of Education 150003000174 204 Aliamanu Middle   Regular School No Middle 07 8 2018   grade_6                                                   0.0                                             0
2430250 HI     school 1500030 1   Hawaii Department of Education 150003000225 102 Aliiolani Elem   Regular School No Elementary PK 5 2020   grade_6                                                   0.0                                             0
2454937 HI     school 1500030 1   Hawaii Department of Education 150003000225 102 Aliiolani Elem   Regular School No Elementary PK 5 2021   grade_6                                                   0.0                                             0
2735914 HI     school 1500030 1   Hawaii Department of Education 150003000225 102 Aliiolani Elem   Regular School No Elementary PK 5 2019   grade_6                                                   0.0                                             0
2780964 HI     school 1500030 1   Hawaii Department of Education 150003000225 102 Aliiolani Elem   Regular School No Elementary PK 5 2018   grade_6                                                   0.0                                             0
2430251 HI     school 1500030 1   Hawaii Department of Education 150003000246 103 Anuenue   Regular School No Other PK 12 2020   grade_6                                                   47.0                                             47
2454938 HI     school 1500030 1   Hawaii Department of Education 150003000246 103 Anuenue   Regular School No Other PK 12 2021   grade_6                                                   29.0                                             29
2735915 HI     school 1500030 1   Hawaii Department of Education 150003000246 103 Anuenue   Regular School No Other PK 12 2019   grade_6                                                   34.0                                             34
2780965 HI     school 1500030 1   Hawaii Department of Education 150003000246 103 Anuenue   Regular School No Other PK 12 2018   grade_6                                                   43.0                                             43
2430345 HI     school 1500030 1   Hawaii Department of Education 150003000136 250 August Ahrens Elem   Regular School No Elementary PK 6 2020   grade_6                                                   187.0                                             187
2736009 HI     school 1500030 1   Hawaii Department of Education 150003000136 250 August Ahrens Elem   Regular School No Elementary PK 6 2019   grade_6                                                   189.0                                             189
2781059 HI     school 1500030 1   Hawaii Department of Education 150003000136 250 August Ahrens Elem   Regular School No Elementary PK 6 2018   grade_6                                                   178.0                                             178
109329 HI     school 1500030 1   Hawaii Department of Education 150003000056 400 BALDWIN HI   Regular School No 3 09 12 2016   grade_6                                                   0.0                                             0
128332 HI     school 1500030 1   Hawaii Department of Education 150003000056 400 BALDWIN HI   Regular School No High 09 12 2017   grade_6                                                   0.0                                             0
279310 HI     school 1500030 1   Hawaii Department of Education 150003000056 400 BALDWIN HI   Regular School No 3 09 12 2015   grade_6                                                   0.0                                             0
109215 HI     school 1500030 1   Hawaii Department of Education 150003000135 251 BARBERS POINT   Regular School No 1 PK 5 2016   grade_6                                                   0.0                                             0
128218 HI     school 1500030 1   Hawaii Department of Education 150003000135 251 BARBERS POINT   Regular School No Elementary PK 5 2017   grade_6                                                   0.0                                             0
279197 HI     school 1500030 1   Hawaii Department of Education 150003000135 251 BARBERS POINT   Regular School No 1 PK 5 2015   grade_6                                                   0.0                                             0
2430433 HI     school 1500030 1   Hawaii Department of Education 150003000056 400 Baldwin High   Regular School No High 09 12 2020   grade_6                                                   0.0                                             0
2455121 HI     school 1500030 1   Hawaii Department of Education 150003000056 400 Baldwin High   Regular School No High 09 12 2021   grade_6                                                   0.0                                             0
2736097 HI     school 1500030 1   Hawaii Department of Education 150003000056 400 Baldwin High   Regular School No High 09 12 2019   grade_6                                                   0.0                                             0
2781147 HI     school 1500030 1   Hawaii Department of Education 150003000056 400 Baldwin High   Regular School No High 09 12 2018   grade_6                                                   0.0                                             0
2430319 HI     school 1500030 1   Hawaii Department of Education 150003000135 251 Barbers Point Elem   Regular School No Elementary PK 5 2020   grade_6                                                   0.0                                             0
2455006 HI     school 1500030 1   Hawaii Department of Education 150003000135 251 Barbers Point Elem   Regular School No Elementary PK 5 2021   grade_6                                                   0.0                                             0
2735983 HI     school 1500030 1   Hawaii Department of Education 150003000135 251 Barbers Point Elem   Regular School No Elementary PK 5 2019   grade_6                                                   0.0                                             0
2781033 HI     school 1500030 1   Hawaii Department of Education 150003000135 251 Barbers Point Elem   Regular School No Elementary PK 5 2018   grade_6                                                   0.0                                             0
109216 HI     school 1500030 1   Hawaii Department of Education 150003000134 252 CAMPBELL HI   Regular School No 3 09 12 2016   grade_6                                                   0.0                                             0
128219 HI     school 1500030 1   Hawaii Department of Education 150003000134 252 CAMPBELL HI   Regular School No High 09 12 2017   grade_6                                                   0.0                                             0
279198 HI     school 1500030 1   Hawaii Department of Education 150003000134 252 CAMPBELL HI   Regular School No 3 09 12 2015   grade_6                                                   0.0                                             0
109259 HI     school 1500030 1   Hawaii Department of Education 150003000100 301 CASTLE HI   Regular School No 3 09 12 2016   grade_6                                                   0.0                                             0
128262 HI     school 1500030 1   Hawaii Department of Education 150003000100 301 CASTLE HI   Regular School No High 09 12 2017   grade_6                                                   0.0                                             0
279240 HI     school 1500030 1   Hawaii Department of Education 150003000100 301 CASTLE HI   Regular School No 3 09 12 2015   grade_6                                                   0.0                                             0
109148 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 CENTRAL MID   Regular School No 2 06 8 2016   grade_6                                                   126.0                                             126
128151 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 CENTRAL MID   Regular School No Middle 06 8 2017   grade_6                                                   138.0                                             138
279130 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 CENTRAL MID   Regular School No 2 06 8 2015   grade_6                                                   126.0                                             126