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
110401 HI     school 1500030 1   Hawaii Department of Education 150003000136 250 AHRENS   Regular School No 1 PK 6 2016   grade_10                                                   0.0                                             0
129404 HI     school 1500030 1   Hawaii Department of Education 150003000136 250 AHRENS   Regular School No Elementary PK 6 2017   grade_10                                                   0.0                                             0
280378 HI     school 1500030 1   Hawaii Department of Education 150003000136 250 AHRENS   Regular School No 1 PK 6 2015   grade_10                                                   0.0                                             0
110418 HI     school 1500030 1   Hawaii Department of Education 150003000157 335 AHUIMANU   Regular School No 1 PK 6 2016   grade_10                                                   0.0                                             0
129421 HI     school 1500030 1   Hawaii Department of Education 150003000157 335 AHUIMANU   Regular School No Elementary PK 6 2017   grade_10                                                   0.0                                             0
280395 HI     school 1500030 1   Hawaii Department of Education 150003000157 335 AHUIMANU   Regular School No 1 PK 6 2015   grade_10                                                   0.0                                             0
110333 HI     school 1500030 1   Hawaii Department of Education 150003000178 200 AIEA EL   Regular School No 1 PK 6 2016   grade_10                                                   0.0                                             0
129336 HI     school 1500030 1   Hawaii Department of Education 150003000178 200 AIEA EL   Regular School No Elementary PK 6 2017   grade_10                                                   0.0                                             0
280311 HI     school 1500030 1   Hawaii Department of Education 150003000178 200 AIEA EL   Regular School No 1 PK 6 2015   grade_10                                                   0.0                                             0
110334 HI     school 1500030 1   Hawaii Department of Education 150003000177 202 AIEA HI   Regular School No 3 09 12 2016   grade_10                                                   227.0                                             227
129337 HI     school 1500030 1   Hawaii Department of Education 150003000177 202 AIEA HI   Regular School No High 09 12 2017   grade_10                                                   241.0                                             241
280312 HI     school 1500030 1   Hawaii Department of Education 150003000177 202 AIEA HI   Regular School No 3 09 12 2015   grade_10                                                   220.0                                             220
110335 HI     school 1500030 1   Hawaii Department of Education 150003000176 201 AIEA INT   Regular School No 2 07 8 2016   grade_10                                                   0.0                                             0
129338 HI     school 1500030 1   Hawaii Department of Education 150003000176 201 AIEA INT   Regular School No Middle 07 8 2017   grade_10                                                   0.0                                             0
280313 HI     school 1500030 1   Hawaii Department of Education 150003000176 201 AIEA INT   Regular School No 2 07 8 2015   grade_10                                                   0.0                                             0
110434 HI     school 1500030 1   Hawaii Department of Education 150003000101 300 AIKAHI   Regular School No 1 PK 6 2016   grade_10                                                   0.0                                             0
129437 HI     school 1500030 1   Hawaii Department of Education 150003000101 300 AIKAHI   Regular School No Elementary PK 6 2017   grade_10                                                   0.0                                             0
280411 HI     school 1500030 1   Hawaii Department of Education 150003000101 300 AIKAHI   Regular School No 1 PK 6 2015   grade_10                                                   0.0                                             0
110280 HI     school 1500030 1   Hawaii Department of Education 150003000227 100 AINA HAINA   Regular School No 1 PK 5 2016   grade_10                                                   0.0                                             0
129283 HI     school 1500030 1   Hawaii Department of Education 150003000227 100 AINA HAINA   Regular School No Elementary PK 5 2017   grade_10                                                   0.0                                             0
280258 HI     school 1500030 1   Hawaii Department of Education 150003000227 100 AINA HAINA   Regular School No 1 PK 5 2015   grade_10                                                   0.0                                             0
110305 HI     school 1500030 1   Hawaii Department of Education 150003000226 101 ALA WAI   Regular School No 1 PK 5 2016   grade_10                                                   0.0                                             0
129308 HI     school 1500030 1   Hawaii Department of Education 150003000226 101 ALA WAI   Regular School No Elementary PK 5 2017   grade_10                                                   0.0                                             0
280283 HI     school 1500030 1   Hawaii Department of Education 150003000226 101 ALA WAI   Regular School No 1 PK 5 2015   grade_10                                                   0.0                                             0
110336 HI     school 1500030 1   Hawaii Department of Education 150003000175 203 ALIAMANU EL   Regular School No 1 PK 6 2016   grade_10                                                   0.0                                             0
129339 HI     school 1500030 1   Hawaii Department of Education 150003000175 203 ALIAMANU EL   Regular School No Elementary PK 6 2017   grade_10                                                   0.0                                             0
280314 HI     school 1500030 1   Hawaii Department of Education 150003000175 203 ALIAMANU EL   Regular School No 1 PK 6 2015   grade_10                                                   0.0                                             0
110337 HI     school 1500030 1   Hawaii Department of Education 150003000174 204 ALIAMANU INT   Regular School No 2 07 8 2016   grade_10                                                   0.0                                             0
129340 HI     school 1500030 1   Hawaii Department of Education 150003000174 204 ALIAMANU INT   Regular School No Middle 07 8 2017   grade_10                                                   0.0                                             0
280315 HI     school 1500030 1   Hawaii Department of Education 150003000174 204 ALIAMANU INT   Regular School No 2 07 8 2015   grade_10                                                   0.0                                             0
110306 HI     school 1500030 1   Hawaii Department of Education 150003000225 102 ALIIOLANI   Regular School No 1 PK 5 2016   grade_10                                                   0.0                                             0
129309 HI     school 1500030 1   Hawaii Department of Education 150003000225 102 ALIIOLANI   Regular School No Elementary PK 5 2017   grade_10                                                   0.0                                             0
280284 HI     school 1500030 1   Hawaii Department of Education 150003000225 102 ALIIOLANI   Regular School No 1 PK 5 2015   grade_10                                                   0.0                                             0
110307 HI     school 1500030 1   Hawaii Department of Education 150003000246 103 ANUENUE   Regular School No 4 PK 12 2016   grade_10                                                   13.0                                             13
129310 HI     school 1500030 1   Hawaii Department of Education 150003000246 103 ANUENUE   Regular School No Other PK 12 2017   grade_10                                                   16.0                                             16
280285 HI     school 1500030 1   Hawaii Department of Education 150003000246 103 ANUENUE   Regular School No 4 PK 12 2015   grade_10                                                   12.0                                             12
2456209 HI     school 1500030 1   Hawaii Department of Education 150003000136 250 Ahrens Elem   Regular School No Elementary PK 6 2021   grade_10                                                   0.0                                             0
2431534 HI     school 1500030 1   Hawaii Department of Education 150003000157 335 Ahuimanu Elem   Regular School No Elementary PK 6 2020   grade_10                                                   0.0                                             0
2456226 HI     school 1500030 1   Hawaii Department of Education 150003000157 335 Ahuimanu Elem   Regular School No Elementary PK 6 2021   grade_10                                                   0.0                                             0
2737194 HI     school 1500030 1   Hawaii Department of Education 150003000157 335 Ahuimanu Elem   Regular School No Elementary PK 6 2019   grade_10                                                   0.0                                             0
2782244 HI     school 1500030 1   Hawaii Department of Education 150003000157 335 Ahuimanu Elem   Regular School No Elementary PK 6 2018   grade_10                                                   0.0                                             0
2431449 HI     school 1500030 1   Hawaii Department of Education 150003000178 200 Aiea Elem   Regular School No Elementary PK 6 2020   grade_10                                                   0.0                                             0
2456140 HI     school 1500030 1   Hawaii Department of Education 150003000178 200 Aiea Elem   Regular School No Elementary PK 6 2021   grade_10                                                   0.0                                             0
2737109 HI     school 1500030 1   Hawaii Department of Education 150003000178 200 Aiea Elem   Regular School No Elementary PK 6 2019   grade_10                                                   0.0                                             0
2782159 HI     school 1500030 1   Hawaii Department of Education 150003000178 200 Aiea Elem   Regular School No Elementary PK 6 2018   grade_10                                                   0.0                                             0
2431450 HI     school 1500030 1   Hawaii Department of Education 150003000177 202 Aiea High   Regular School No High 09 12 2020   grade_10                                                   208.0                                             208
2456141 HI     school 1500030 1   Hawaii Department of Education 150003000177 202 Aiea High   Regular School No High 09 12 2021   grade_10                                                   239.0                                             239
2737110 HI     school 1500030 1   Hawaii Department of Education 150003000177 202 Aiea High   Regular School No High 09 12 2019   grade_10                                                   190.0                                             190
2782160 HI     school 1500030 1   Hawaii Department of Education 150003000177 202 Aiea High   Regular School No High 09 12 2018   grade_10                                                   243.0                                             243
2431451 HI     school 1500030 1   Hawaii Department of Education 150003000176 201 Aiea Int   Regular School No Middle 07 8 2020   grade_10                                                   0.0                                             0
2456142 HI     school 1500030 1   Hawaii Department of Education 150003000176 201 Aiea Int   Regular School No Middle 07 8 2021   grade_10                                                   0.0                                             0
2737111 HI     school 1500030 1   Hawaii Department of Education 150003000176 201 Aiea Int   Regular School No Middle 07 8 2019   grade_10                                                   0.0                                             0
2782161 HI     school 1500030 1   Hawaii Department of Education 150003000176 201 Aiea Int   Regular School No Middle 07 8 2018   grade_10                                                   0.0                                             0
2431550 HI     school 1500030 1   Hawaii Department of Education 150003000101 300 Aikahi Elem   Regular School No Elementary PK 6 2020   grade_10                                                   0.0                                             0
2456242 HI     school 1500030 1   Hawaii Department of Education 150003000101 300 Aikahi Elem   Regular School No Elementary PK 6 2021   grade_10                                                   0.0                                             0
2737210 HI     school 1500030 1   Hawaii Department of Education 150003000101 300 Aikahi Elem   Regular School No Elementary PK 6 2019   grade_10                                                   0.0                                             0
2782260 HI     school 1500030 1   Hawaii Department of Education 150003000101 300 Aikahi Elem   Regular School No Elementary PK 6 2018   grade_10                                                   0.0                                             0
2431396 HI     school 1500030 1   Hawaii Department of Education 150003000227 100 Aina Haina Elem   Regular School No Elementary PK 5 2020   grade_10                                                   0.0                                             0
2456087 HI     school 1500030 1   Hawaii Department of Education 150003000227 100 Aina Haina Elem   Regular School No Elementary PK 5 2021   grade_10                                                   0.0                                             0
2737056 HI     school 1500030 1   Hawaii Department of Education 150003000227 100 Aina Haina Elem   Regular School No Elementary PK 5 2019   grade_10                                                   0.0                                             0
2782106 HI     school 1500030 1   Hawaii Department of Education 150003000227 100 Aina Haina Elem   Regular School No Elementary PK 5 2018   grade_10                                                   0.0                                             0
2431421 HI     school 1500030 1   Hawaii Department of Education 150003000226 101 Ala Wai Elem   Regular School No Elementary PK 5 2020   grade_10                                                   0.0                                             0
2456112 HI     school 1500030 1   Hawaii Department of Education 150003000226 101 Ala Wai Elem   Regular School No Elementary PK 5 2021   grade_10                                                   0.0                                             0
2737081 HI     school 1500030 1   Hawaii Department of Education 150003000226 101 Ala Wai Elem   Regular School No Elementary PK 5 2019   grade_10                                                   0.0                                             0
2782131 HI     school 1500030 1   Hawaii Department of Education 150003000226 101 Ala Wai Elem   Regular School No Elementary PK 5 2018   grade_10                                                   0.0                                             0
2431652 HI     school 1500030 1   Hawaii Department of Education 150003000304 558 Alakai O Kauai PCS charter Regular School Yes Elementary KG 6 2020   grade_10                                                   0.0                                             0
2456344 HI     school 1500030 1   Hawaii Department of Education 150003000304 558 Alakai O Kauai PCS charter Regular School Yes Elementary KG 6 2021   grade_10                                                   0.0                                             0
2737339 HI     school 1500030 1   Hawaii Department of Education 150003000304 558 Alakai O Kauai PCS charter Regular School Yes Elementary KG 5 2019   grade_10                                                   0.0                                             0
2431452 HI     school 1500030 1   Hawaii Department of Education 150003000175 203 Aliamanu Elem   Regular School No Elementary PK 6 2020   grade_10                                                   0.0                                             0
2456143 HI     school 1500030 1   Hawaii Department of Education 150003000175 203 Aliamanu Elem   Regular School No Elementary PK 6 2021   grade_10                                                   0.0                                             0
2737112 HI     school 1500030 1   Hawaii Department of Education 150003000175 203 Aliamanu Elem   Regular School No Elementary PK 6 2019   grade_10                                                   0.0                                             0
2782162 HI     school 1500030 1   Hawaii Department of Education 150003000175 203 Aliamanu Elem   Regular School No Elementary PK 6 2018   grade_10                                                   0.0                                             0
2431453 HI     school 1500030 1   Hawaii Department of Education 150003000174 204 Aliamanu Middle   Regular School No Middle 07 8 2020   grade_10                                                   0.0                                             0
2456144 HI     school 1500030 1   Hawaii Department of Education 150003000174 204 Aliamanu Middle   Regular School No Middle 07 8 2021   grade_10                                                   0.0                                             0
2737113 HI     school 1500030 1   Hawaii Department of Education 150003000174 204 Aliamanu Middle   Regular School No Middle 07 8 2019   grade_10                                                   0.0                                             0
2782163 HI     school 1500030 1   Hawaii Department of Education 150003000174 204 Aliamanu Middle   Regular School No Middle 07 8 2018   grade_10                                                   0.0                                             0
2431422 HI     school 1500030 1   Hawaii Department of Education 150003000225 102 Aliiolani Elem   Regular School No Elementary PK 5 2020   grade_10                                                   0.0                                             0
2456113 HI     school 1500030 1   Hawaii Department of Education 150003000225 102 Aliiolani Elem   Regular School No Elementary PK 5 2021   grade_10                                                   0.0                                             0
2737082 HI     school 1500030 1   Hawaii Department of Education 150003000225 102 Aliiolani Elem   Regular School No Elementary PK 5 2019   grade_10                                                   0.0                                             0
2782132 HI     school 1500030 1   Hawaii Department of Education 150003000225 102 Aliiolani Elem   Regular School No Elementary PK 5 2018   grade_10                                                   0.0                                             0
2431423 HI     school 1500030 1   Hawaii Department of Education 150003000246 103 Anuenue   Regular School No Other PK 12 2020   grade_10                                                   24.0                                             24
2456114 HI     school 1500030 1   Hawaii Department of Education 150003000246 103 Anuenue   Regular School No Other PK 12 2021   grade_10                                                   17.0                                             17
2737083 HI     school 1500030 1   Hawaii Department of Education 150003000246 103 Anuenue   Regular School No Other PK 12 2019   grade_10                                                   26.0                                             26
2782133 HI     school 1500030 1   Hawaii Department of Education 150003000246 103 Anuenue   Regular School No Other PK 12 2018   grade_10                                                   21.0                                             21
2431517 HI     school 1500030 1   Hawaii Department of Education 150003000136 250 August Ahrens Elem   Regular School No Elementary PK 6 2020   grade_10                                                   0.0                                             0
2737177 HI     school 1500030 1   Hawaii Department of Education 150003000136 250 August Ahrens Elem   Regular School No Elementary PK 6 2019   grade_10                                                   0.0                                             0
2782227 HI     school 1500030 1   Hawaii Department of Education 150003000136 250 August Ahrens Elem   Regular School No Elementary PK 6 2018   grade_10                                                   0.0                                             0
110489 HI     school 1500030 1   Hawaii Department of Education 150003000056 400 BALDWIN HI   Regular School No 3 09 12 2016   grade_10                                                   326.0                                             326
129492 HI     school 1500030 1   Hawaii Department of Education 150003000056 400 BALDWIN HI   Regular School No High 09 12 2017   grade_10                                                   299.0                                             299
280466 HI     school 1500030 1   Hawaii Department of Education 150003000056 400 BALDWIN HI   Regular School No 3 09 12 2015   grade_10                                                   339.0                                             339
110375 HI     school 1500030 1   Hawaii Department of Education 150003000135 251 BARBERS POINT   Regular School No 1 PK 5 2016   grade_10                                                   0.0                                             0
129378 HI     school 1500030 1   Hawaii Department of Education 150003000135 251 BARBERS POINT   Regular School No Elementary PK 5 2017   grade_10                                                   0.0                                             0
280353 HI     school 1500030 1   Hawaii Department of Education 150003000135 251 BARBERS POINT   Regular School No 1 PK 5 2015   grade_10                                                   0.0                                             0
2431605 HI     school 1500030 1   Hawaii Department of Education 150003000056 400 Baldwin High   Regular School No High 09 12 2020   grade_10                                                   315.0                                             315
2456297 HI     school 1500030 1   Hawaii Department of Education 150003000056 400 Baldwin High   Regular School No High 09 12 2021   grade_10                                                   312.0                                             312
2737265 HI     school 1500030 1   Hawaii Department of Education 150003000056 400 Baldwin High   Regular School No High 09 12 2019   grade_10                                                   277.0                                             277
2782315 HI     school 1500030 1   Hawaii Department of Education 150003000056 400 Baldwin High   Regular School No High 09 12 2018   grade_10                                                   312.0                                             312
2431491 HI     school 1500030 1   Hawaii Department of Education 150003000135 251 Barbers Point Elem   Regular School No Elementary PK 5 2020   grade_10                                                   0.0                                             0
2456182 HI     school 1500030 1   Hawaii Department of Education 150003000135 251 Barbers Point Elem   Regular School No Elementary PK 5 2021   grade_10                                                   0.0                                             0
2737151 HI     school 1500030 1   Hawaii Department of Education 150003000135 251 Barbers Point Elem   Regular School No Elementary PK 5 2019   grade_10                                                   0.0                                             0
2782201 HI     school 1500030 1   Hawaii Department of Education 150003000135 251 Barbers Point Elem   Regular School No Elementary PK 5 2018   grade_10                                                   0.0                                             0