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
109410 HI     school 1500030 1   Hawaii Department of Education 150003000227 100 AINA HAINA   Regular School No 1 PK 5 2016   grade_7                                                   0.0                                             0
128413 HI     school 1500030 1   Hawaii Department of Education 150003000227 100 AINA HAINA   Regular School No Elementary PK 5 2017   grade_7                                                   0.0                                             0
279391 HI     school 1500030 1   Hawaii Department of Education 150003000227 100 AINA HAINA   Regular School No 1 PK 5 2015   grade_7                                                   0.0                                             0
2430517 HI     school 1500030 1   Hawaii Department of Education 150003000227 100 Aina Haina Elem   Regular School No Elementary PK 5 2020   grade_7                                                   0.0                                             0
2455205 HI     school 1500030 1   Hawaii Department of Education 150003000227 100 Aina Haina Elem   Regular School No Elementary PK 5 2021   grade_7                                                   0.0                                             0
2736180 HI     school 1500030 1   Hawaii Department of Education 150003000227 100 Aina Haina Elem   Regular School No Elementary PK 5 2019   grade_7                                                   0.0                                             0
2781230 HI     school 1500030 1   Hawaii Department of Education 150003000227 100 Aina Haina Elem   Regular School No Elementary PK 5 2018   grade_7                                                   0.0                                             0
109435 HI     school 1500030 1   Hawaii Department of Education 150003000226 101 ALA WAI   Regular School No 1 PK 5 2016   grade_7                                                   0.0                                             0
128438 HI     school 1500030 1   Hawaii Department of Education 150003000226 101 ALA WAI   Regular School No Elementary PK 5 2017   grade_7                                                   0.0                                             0
279416 HI     school 1500030 1   Hawaii Department of Education 150003000226 101 ALA WAI   Regular School No 1 PK 5 2015   grade_7                                                   0.0                                             0
2430542 HI     school 1500030 1   Hawaii Department of Education 150003000226 101 Ala Wai Elem   Regular School No Elementary PK 5 2020   grade_7                                                   0.0                                             0
2455230 HI     school 1500030 1   Hawaii Department of Education 150003000226 101 Ala Wai Elem   Regular School No Elementary PK 5 2021   grade_7                                                   0.0                                             0
2736205 HI     school 1500030 1   Hawaii Department of Education 150003000226 101 Ala Wai Elem   Regular School No Elementary PK 5 2019   grade_7                                                   0.0                                             0
2781255 HI     school 1500030 1   Hawaii Department of Education 150003000226 101 Ala Wai Elem   Regular School No Elementary PK 5 2018   grade_7                                                   0.0                                             0
109436 HI     school 1500030 1   Hawaii Department of Education 150003000225 102 ALIIOLANI   Regular School No 1 PK 5 2016   grade_7                                                   0.0                                             0
128439 HI     school 1500030 1   Hawaii Department of Education 150003000225 102 ALIIOLANI   Regular School No Elementary PK 5 2017   grade_7                                                   0.0                                             0
279417 HI     school 1500030 1   Hawaii Department of Education 150003000225 102 ALIIOLANI   Regular School No 1 PK 5 2015   grade_7                                                   0.0                                             0
2430543 HI     school 1500030 1   Hawaii Department of Education 150003000225 102 Aliiolani Elem   Regular School No Elementary PK 5 2020   grade_7                                                   0.0                                             0
2455231 HI     school 1500030 1   Hawaii Department of Education 150003000225 102 Aliiolani Elem   Regular School No Elementary PK 5 2021   grade_7                                                   0.0                                             0
2736206 HI     school 1500030 1   Hawaii Department of Education 150003000225 102 Aliiolani Elem   Regular School No Elementary PK 5 2019   grade_7                                                   0.0                                             0
2781256 HI     school 1500030 1   Hawaii Department of Education 150003000225 102 Aliiolani Elem   Regular School No Elementary PK 5 2018   grade_7                                                   0.0                                             0
109437 HI     school 1500030 1   Hawaii Department of Education 150003000246 103 ANUENUE   Regular School No 4 PK 12 2016   grade_7                                                   34.0                                             34
128440 HI     school 1500030 1   Hawaii Department of Education 150003000246 103 ANUENUE   Regular School No Other PK 12 2017   grade_7                                                   28.0                                             28
279418 HI     school 1500030 1   Hawaii Department of Education 150003000246 103 ANUENUE   Regular School No 4 PK 12 2015   grade_7                                                   37.0                                             37
2430544 HI     school 1500030 1   Hawaii Department of Education 150003000246 103 Anuenue   Regular School No Other PK 12 2020   grade_7                                                   39.0                                             39
2455232 HI     school 1500030 1   Hawaii Department of Education 150003000246 103 Anuenue   Regular School No Other PK 12 2021   grade_7                                                   47.0                                             47
2736207 HI     school 1500030 1   Hawaii Department of Education 150003000246 103 Anuenue   Regular School No Other PK 12 2019   grade_7                                                   45.0                                             45
2781257 HI     school 1500030 1   Hawaii Department of Education 150003000246 103 Anuenue   Regular School No Other PK 12 2018   grade_7                                                   25.0                                             25
109438 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 CENTRAL MID   Regular School No 2 06 8 2016   grade_7                                                   115.0                                             115
128441 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 CENTRAL MID   Regular School No Middle 06 8 2017   grade_7                                                   113.0                                             113
279419 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 CENTRAL MID   Regular School No 2 06 8 2015   grade_7                                                   108.0                                             108
2430545 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 Central Middle   Regular School No Middle 06 8 2020   grade_7                                                   118.0                                             118
2455233 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 Central Middle   Regular School No Middle 06 8 2021   grade_7                                                   99.0                                             99
2736208 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 Central Middle   Regular School No Middle 06 8 2019   grade_7                                                   125.0                                             125
2781258 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 Central Middle   Regular School No Middle 06 8 2018   grade_7                                                   117.0                                             117
109411 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 DOLE MID   Regular School No 2 06 8 2016   grade_7                                                   239.0                                             239
128414 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 DOLE MID   Regular School No Middle 06 8 2017   grade_7                                                   255.0                                             255
279392 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 DOLE MID   Regular School No 2 06 8 2015   grade_7                                                   292.0                                             292
2430518 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 Dole Middle   Regular School No Middle 06 8 2020   grade_7                                                   240.0                                             240
2455206 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 Dole Middle   Regular School No Middle 06 8 2021   grade_7                                                   198.0                                             198
2736181 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 Dole Middle   Regular School No Middle 06 8 2019   grade_7                                                   268.0                                             268
2781231 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 Dole Middle   Regular School No Middle 06 8 2018   grade_7                                                   278.0                                             278
109412 HI     school 1500030 1   Hawaii Department of Education 150003000221 106 FARRINGTON HI   Regular School No 3 09 12 2016   grade_7                                                   0.0                                             0
128415 HI     school 1500030 1   Hawaii Department of Education 150003000221 106 FARRINGTON HI   Regular School No High 09 12 2017   grade_7                                                   0.0                                             0
279393 HI     school 1500030 1   Hawaii Department of Education 150003000221 106 FARRINGTON HI   Regular School No 3 09 12 2015   grade_7                                                   0.0                                             0
2430519 HI     school 1500030 1   Hawaii Department of Education 150003000221 106 Farrington High   Regular School No High 09 12 2020   grade_7                                                   0.0                                             0
2455207 HI     school 1500030 1   Hawaii Department of Education 150003000221 106 Farrington High   Regular School No High 09 12 2021   grade_7                                                   0.0                                             0
2736182 HI     school 1500030 1   Hawaii Department of Education 150003000221 106 Farrington High   Regular School No High 09 12 2019   grade_7                                                   0.0                                             0
2781232 HI     school 1500030 1   Hawaii Department of Education 150003000221 106 Farrington High   Regular School No High 09 12 2018   grade_7                                                   0.0                                             0
109413 HI     school 1500030 1   Hawaii Department of Education 150003000220 107 FERN   Regular School No 1 PK 5 2016   grade_7                                                   0.0                                             0
128416 HI     school 1500030 1   Hawaii Department of Education 150003000220 107 FERN   Regular School No Elementary PK 5 2017   grade_7                                                   0.0                                             0
279394 HI     school 1500030 1   Hawaii Department of Education 150003000220 107 FERN   Regular School No 1 PK 5 2015   grade_7                                                   0.0                                             0
2430520 HI     school 1500030 1   Hawaii Department of Education 150003000220 107 Fern Elem   Regular School No Elementary PK 5 2020   grade_7                                                   0.0                                             0
2455208 HI     school 1500030 1   Hawaii Department of Education 150003000220 107 Fern Elem   Regular School No Elementary PK 5 2021   grade_7                                                   0.0                                             0
2736183 HI     school 1500030 1   Hawaii Department of Education 150003000220 107 Fern Elem   Regular School No Elementary PK 5 2019   grade_7                                                   0.0                                             0
2781233 HI     school 1500030 1   Hawaii Department of Education 150003000220 107 Fern Elem   Regular School No Elementary PK 5 2018   grade_7                                                   0.0                                             0
109414 HI     school 1500030 1   Hawaii Department of Education 150003000219 108 HAHAIONE   Regular School No 1 PK 5 2016   grade_7                                                   0.0                                             0
128417 HI     school 1500030 1   Hawaii Department of Education 150003000219 108 HAHAIONE   Regular School No Elementary PK 5 2017   grade_7                                                   0.0                                             0
279395 HI     school 1500030 1   Hawaii Department of Education 150003000219 108 HAHAIONE   Regular School No 1 PK 5 2015   grade_7                                                   0.0                                             0
2430521 HI     school 1500030 1   Hawaii Department of Education 150003000219 108 Hahaione Elem   Regular School No Elementary PK 5 2020   grade_7                                                   0.0                                             0
2455209 HI     school 1500030 1   Hawaii Department of Education 150003000219 108 Hahaione Elem   Regular School No Elementary PK 5 2021   grade_7                                                   0.0                                             0
2736184 HI     school 1500030 1   Hawaii Department of Education 150003000219 108 Hahaione Elem   Regular School No Elementary PK 5 2019   grade_7                                                   0.0                                             0
2781234 HI     school 1500030 1   Hawaii Department of Education 150003000219 108 Hahaione Elem   Regular School No Elementary PK 5 2018   grade_7                                                   0.0                                             0
109439 HI     school 1500030 1   Hawaii Department of Education 150003000214 109 HOKULANI   Regular School No 1 PK 5 2016   grade_7                                                   0.0                                             0
128442 HI     school 1500030 1   Hawaii Department of Education 150003000214 109 HOKULANI   Regular School No Elementary PK 5 2017   grade_7                                                   0.0                                             0
279420 HI     school 1500030 1   Hawaii Department of Education 150003000214 109 HOKULANI   Regular School No 1 PK 5 2015   grade_7                                                   0.0                                             0
2430546 HI     school 1500030 1   Hawaii Department of Education 150003000214 109 Hokulani Elem   Regular School No Elementary PK 5 2020   grade_7                                                   0.0                                             0
2455234 HI     school 1500030 1   Hawaii Department of Education 150003000214 109 Hokulani Elem   Regular School No Elementary PK 5 2021   grade_7                                                   0.0                                             0
2736209 HI     school 1500030 1   Hawaii Department of Education 150003000214 109 Hokulani Elem   Regular School No Elementary PK 5 2019   grade_7                                                   0.0                                             0
2781259 HI     school 1500030 1   Hawaii Department of Education 150003000214 109 Hokulani Elem   Regular School No Elementary PK 5 2018   grade_7                                                   0.0                                             0
109440 HI     school 1500030 1   Hawaii Department of Education 150003000218 110 JARRETT MID   Regular School No 2 06 8 2016   grade_7                                                   79.0                                             79
128443 HI     school 1500030 1   Hawaii Department of Education 150003000218 110 JARRETT MID   Regular School No Middle 06 8 2017   grade_7                                                   64.0                                             64
279421 HI     school 1500030 1   Hawaii Department of Education 150003000218 110 JARRETT MID   Regular School No 2 06 8 2015   grade_7                                                   71.0                                             71
2430547 HI     school 1500030 1   Hawaii Department of Education 150003000218 110 Jarrett Middle   Regular School No Middle 06 8 2020   grade_7                                                   82.0                                             82
2455235 HI     school 1500030 1   Hawaii Department of Education 150003000218 110 Jarrett Middle   Regular School No Middle 06 8 2021   grade_7                                                   80.0                                             80
2736210 HI     school 1500030 1   Hawaii Department of Education 150003000218 110 Jarrett Middle   Regular School No Middle 06 8 2019   grade_7                                                   79.0                                             79
2781260 HI     school 1500030 1   Hawaii Department of Education 150003000218 110 Jarrett Middle   Regular School No Middle 06 8 2018   grade_7                                                   69.0                                             69
109441 HI     school 1500030 1   Hawaii Department of Education 150003000213 111 JEFFERSON   Regular School No 1 PK 5 2016   grade_7                                                   0.0                                             0
128444 HI     school 1500030 1   Hawaii Department of Education 150003000213 111 JEFFERSON   Regular School No Elementary PK 5 2017   grade_7                                                   0.0                                             0
279422 HI     school 1500030 1   Hawaii Department of Education 150003000213 111 JEFFERSON   Regular School No 1 PK 5 2015   grade_7                                                   0.0                                             0
2430548 HI     school 1500030 1   Hawaii Department of Education 150003000213 111 Jefferson Elem   Regular School No Elementary PK 5 2020   grade_7                                                   0.0                                             0
2455236 HI     school 1500030 1   Hawaii Department of Education 150003000213 111 Jefferson Elem   Regular School No Elementary PK 5 2021   grade_7                                                   0.0                                             0
2736211 HI     school 1500030 1   Hawaii Department of Education 150003000213 111 Jefferson Elem   Regular School No Elementary PK 5 2019   grade_7                                                   0.0                                             0
2781261 HI     school 1500030 1   Hawaii Department of Education 150003000213 111 Jefferson Elem   Regular School No Elementary PK 5 2018   grade_7                                                   0.0                                             0
109442 HI     school 1500030 1   Hawaii Department of Education 150003000217 112 KAAHUMANU   Regular School No 1 PK 5 2016   grade_7                                                   0.0                                             0
128445 HI     school 1500030 1   Hawaii Department of Education 150003000217 112 KAAHUMANU   Regular School No Elementary PK 5 2017   grade_7                                                   0.0                                             0
279423 HI     school 1500030 1   Hawaii Department of Education 150003000217 112 KAAHUMANU   Regular School No 1 PK 5 2015   grade_7                                                   0.0                                             0
2430549 HI     school 1500030 1   Hawaii Department of Education 150003000217 112 Kaahumanu Elem   Regular School No Elementary PK 5 2020   grade_7                                                   0.0                                             0
2455237 HI     school 1500030 1   Hawaii Department of Education 150003000217 112 Kaahumanu Elem   Regular School No Elementary PK 5 2021   grade_7                                                   0.0                                             0
2736212 HI     school 1500030 1   Hawaii Department of Education 150003000217 112 Kaahumanu Elem   Regular School No Elementary PK 5 2019   grade_7                                                   0.0                                             0
2781262 HI     school 1500030 1   Hawaii Department of Education 150003000217 112 Kaahumanu Elem   Regular School No Elementary PK 5 2018   grade_7                                                   0.0                                             0
109416 HI     school 1500030 1   Hawaii Department of Education 150003000216 113 KAEWAI   Regular School No 1 PK 5 2016   grade_7                                                   0.0                                             0
128419 HI     school 1500030 1   Hawaii Department of Education 150003000216 113 KAEWAI   Regular School No Elementary PK 5 2017   grade_7                                                   0.0                                             0
279397 HI     school 1500030 1   Hawaii Department of Education 150003000216 113 KAEWAI   Regular School No 1 PK 5 2015   grade_7                                                   0.0                                             0
2430523 HI     school 1500030 1   Hawaii Department of Education 150003000216 113 Kaewai Elem   Regular School No Elementary PK 5 2020   grade_7                                                   0.0                                             0
2455211 HI     school 1500030 1   Hawaii Department of Education 150003000216 113 Kaewai Elem   Regular School No Elementary PK 5 2021   grade_7                                                   0.0                                             0
2736186 HI     school 1500030 1   Hawaii Department of Education 150003000216 113 Kaewai Elem   Regular School No Elementary PK 5 2019   grade_7                                                   0.0                                             0
2781236 HI     school 1500030 1   Hawaii Department of Education 150003000216 113 Kaewai Elem   Regular School No Elementary PK 5 2018   grade_7                                                   0.0                                             0
109417 HI     school 1500030 1   Hawaii Department of Education 150003000215 114 KAHALA   Regular School No 1 PK 5 2016   grade_7                                                   0.0                                             0
128420 HI     school 1500030 1   Hawaii Department of Education 150003000215 114 KAHALA   Regular School No Elementary PK 5 2017   grade_7                                                   0.0                                             0
279398 HI     school 1500030 1   Hawaii Department of Education 150003000215 114 KAHALA   Regular School No 1 PK 5 2015   grade_7                                                   0.0                                             0