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
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
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
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
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
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
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
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
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
110308 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 CENTRAL MID   Regular School No 2 06 8 2016   grade_10                                                   0.0                                             0
129311 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 CENTRAL MID   Regular School No Middle 06 8 2017   grade_10                                                   0.0                                             0
280286 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 CENTRAL MID   Regular School No 2 06 8 2015   grade_10                                                   0.0                                             0
2431424 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 Central Middle   Regular School No Middle 06 8 2020   grade_10                                                   0.0                                             0
2456115 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 Central Middle   Regular School No Middle 06 8 2021   grade_10                                                   0.0                                             0
2737084 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 Central Middle   Regular School No Middle 06 8 2019   grade_10                                                   0.0                                             0
2782134 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 Central Middle   Regular School No Middle 06 8 2018   grade_10                                                   0.0                                             0
110281 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 DOLE MID   Regular School No 2 06 8 2016   grade_10                                                   0.0                                             0
129284 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 DOLE MID   Regular School No Middle 06 8 2017   grade_10                                                   0.0                                             0
280259 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 DOLE MID   Regular School No 2 06 8 2015   grade_10                                                   0.0                                             0
2431397 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 Dole Middle   Regular School No Middle 06 8 2020   grade_10                                                   0.0                                             0
2456088 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 Dole Middle   Regular School No Middle 06 8 2021   grade_10                                                   0.0                                             0
2737057 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 Dole Middle   Regular School No Middle 06 8 2019   grade_10                                                   0.0                                             0
2782107 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 Dole Middle   Regular School No Middle 06 8 2018   grade_10                                                   0.0                                             0
110282 HI     school 1500030 1   Hawaii Department of Education 150003000221 106 FARRINGTON HI   Regular School No 3 09 12 2016   grade_10                                                   587.0                                             587
129285 HI     school 1500030 1   Hawaii Department of Education 150003000221 106 FARRINGTON HI   Regular School No High 09 12 2017   grade_10                                                   486.0                                             486
280260 HI     school 1500030 1   Hawaii Department of Education 150003000221 106 FARRINGTON HI   Regular School No 3 09 12 2015   grade_10                                                   579.0                                             579
2431398 HI     school 1500030 1   Hawaii Department of Education 150003000221 106 Farrington High   Regular School No High 09 12 2020   grade_10                                                   561.0                                             561
2456089 HI     school 1500030 1   Hawaii Department of Education 150003000221 106 Farrington High   Regular School No High 09 12 2021   grade_10                                                   543.0                                             543
2737058 HI     school 1500030 1   Hawaii Department of Education 150003000221 106 Farrington High   Regular School No High 09 12 2019   grade_10                                                   505.0                                             505
2782108 HI     school 1500030 1   Hawaii Department of Education 150003000221 106 Farrington High   Regular School No High 09 12 2018   grade_10                                                   565.0                                             565
110283 HI     school 1500030 1   Hawaii Department of Education 150003000220 107 FERN   Regular School No 1 PK 5 2016   grade_10                                                   0.0                                             0
129286 HI     school 1500030 1   Hawaii Department of Education 150003000220 107 FERN   Regular School No Elementary PK 5 2017   grade_10                                                   0.0                                             0
280261 HI     school 1500030 1   Hawaii Department of Education 150003000220 107 FERN   Regular School No 1 PK 5 2015   grade_10                                                   0.0                                             0
2431399 HI     school 1500030 1   Hawaii Department of Education 150003000220 107 Fern Elem   Regular School No Elementary PK 5 2020   grade_10                                                   0.0                                             0
2456090 HI     school 1500030 1   Hawaii Department of Education 150003000220 107 Fern Elem   Regular School No Elementary PK 5 2021   grade_10                                                   0.0                                             0
2737059 HI     school 1500030 1   Hawaii Department of Education 150003000220 107 Fern Elem   Regular School No Elementary PK 5 2019   grade_10                                                   0.0                                             0
2782109 HI     school 1500030 1   Hawaii Department of Education 150003000220 107 Fern Elem   Regular School No Elementary PK 5 2018   grade_10                                                   0.0                                             0
110284 HI     school 1500030 1   Hawaii Department of Education 150003000219 108 HAHAIONE   Regular School No 1 PK 5 2016   grade_10                                                   0.0                                             0
129287 HI     school 1500030 1   Hawaii Department of Education 150003000219 108 HAHAIONE   Regular School No Elementary PK 5 2017   grade_10                                                   0.0                                             0
280262 HI     school 1500030 1   Hawaii Department of Education 150003000219 108 HAHAIONE   Regular School No 1 PK 5 2015   grade_10                                                   0.0                                             0
2431400 HI     school 1500030 1   Hawaii Department of Education 150003000219 108 Hahaione Elem   Regular School No Elementary PK 5 2020   grade_10                                                   0.0                                             0
2456091 HI     school 1500030 1   Hawaii Department of Education 150003000219 108 Hahaione Elem   Regular School No Elementary PK 5 2021   grade_10                                                   0.0                                             0
2737060 HI     school 1500030 1   Hawaii Department of Education 150003000219 108 Hahaione Elem   Regular School No Elementary PK 5 2019   grade_10                                                   0.0                                             0
2782110 HI     school 1500030 1   Hawaii Department of Education 150003000219 108 Hahaione Elem   Regular School No Elementary PK 5 2018   grade_10                                                   0.0                                             0
110309 HI     school 1500030 1   Hawaii Department of Education 150003000214 109 HOKULANI   Regular School No 1 PK 5 2016   grade_10                                                   0.0                                             0
129312 HI     school 1500030 1   Hawaii Department of Education 150003000214 109 HOKULANI   Regular School No Elementary PK 5 2017   grade_10                                                   0.0                                             0
280287 HI     school 1500030 1   Hawaii Department of Education 150003000214 109 HOKULANI   Regular School No 1 PK 5 2015   grade_10                                                   0.0                                             0
2431425 HI     school 1500030 1   Hawaii Department of Education 150003000214 109 Hokulani Elem   Regular School No Elementary PK 5 2020   grade_10                                                   0.0                                             0
2456116 HI     school 1500030 1   Hawaii Department of Education 150003000214 109 Hokulani Elem   Regular School No Elementary PK 5 2021   grade_10                                                   0.0                                             0
2737085 HI     school 1500030 1   Hawaii Department of Education 150003000214 109 Hokulani Elem   Regular School No Elementary PK 5 2019   grade_10                                                   0.0                                             0
2782135 HI     school 1500030 1   Hawaii Department of Education 150003000214 109 Hokulani Elem   Regular School No Elementary PK 5 2018   grade_10                                                   0.0                                             0
110310 HI     school 1500030 1   Hawaii Department of Education 150003000218 110 JARRETT MID   Regular School No 2 06 8 2016   grade_10                                                   0.0                                             0
129313 HI     school 1500030 1   Hawaii Department of Education 150003000218 110 JARRETT MID   Regular School No Middle 06 8 2017   grade_10                                                   0.0                                             0
280288 HI     school 1500030 1   Hawaii Department of Education 150003000218 110 JARRETT MID   Regular School No 2 06 8 2015   grade_10                                                   0.0                                             0
2431426 HI     school 1500030 1   Hawaii Department of Education 150003000218 110 Jarrett Middle   Regular School No Middle 06 8 2020   grade_10                                                   0.0                                             0
2456117 HI     school 1500030 1   Hawaii Department of Education 150003000218 110 Jarrett Middle   Regular School No Middle 06 8 2021   grade_10                                                   0.0                                             0
2737086 HI     school 1500030 1   Hawaii Department of Education 150003000218 110 Jarrett Middle   Regular School No Middle 06 8 2019   grade_10                                                   0.0                                             0
2782136 HI     school 1500030 1   Hawaii Department of Education 150003000218 110 Jarrett Middle   Regular School No Middle 06 8 2018   grade_10                                                   0.0                                             0
110311 HI     school 1500030 1   Hawaii Department of Education 150003000213 111 JEFFERSON   Regular School No 1 PK 5 2016   grade_10                                                   0.0                                             0
129314 HI     school 1500030 1   Hawaii Department of Education 150003000213 111 JEFFERSON   Regular School No Elementary PK 5 2017   grade_10                                                   0.0                                             0
280289 HI     school 1500030 1   Hawaii Department of Education 150003000213 111 JEFFERSON   Regular School No 1 PK 5 2015   grade_10                                                   0.0                                             0
2431427 HI     school 1500030 1   Hawaii Department of Education 150003000213 111 Jefferson Elem   Regular School No Elementary PK 5 2020   grade_10                                                   0.0                                             0
2456118 HI     school 1500030 1   Hawaii Department of Education 150003000213 111 Jefferson Elem   Regular School No Elementary PK 5 2021   grade_10                                                   0.0                                             0
2737087 HI     school 1500030 1   Hawaii Department of Education 150003000213 111 Jefferson Elem   Regular School No Elementary PK 5 2019   grade_10                                                   0.0                                             0
2782137 HI     school 1500030 1   Hawaii Department of Education 150003000213 111 Jefferson Elem   Regular School No Elementary PK 5 2018   grade_10                                                   0.0                                             0
110312 HI     school 1500030 1   Hawaii Department of Education 150003000217 112 KAAHUMANU   Regular School No 1 PK 5 2016   grade_10                                                   0.0                                             0
129315 HI     school 1500030 1   Hawaii Department of Education 150003000217 112 KAAHUMANU   Regular School No Elementary PK 5 2017   grade_10                                                   0.0                                             0
280290 HI     school 1500030 1   Hawaii Department of Education 150003000217 112 KAAHUMANU   Regular School No 1 PK 5 2015   grade_10                                                   0.0                                             0
2431428 HI     school 1500030 1   Hawaii Department of Education 150003000217 112 Kaahumanu Elem   Regular School No Elementary PK 5 2020   grade_10                                                   0.0                                             0
2456119 HI     school 1500030 1   Hawaii Department of Education 150003000217 112 Kaahumanu Elem   Regular School No Elementary PK 5 2021   grade_10                                                   0.0                                             0
2737088 HI     school 1500030 1   Hawaii Department of Education 150003000217 112 Kaahumanu Elem   Regular School No Elementary PK 5 2019   grade_10                                                   0.0                                             0
2782138 HI     school 1500030 1   Hawaii Department of Education 150003000217 112 Kaahumanu Elem   Regular School No Elementary PK 5 2018   grade_10                                                   0.0                                             0
110286 HI     school 1500030 1   Hawaii Department of Education 150003000216 113 KAEWAI   Regular School No 1 PK 5 2016   grade_10                                                   0.0                                             0
129289 HI     school 1500030 1   Hawaii Department of Education 150003000216 113 KAEWAI   Regular School No Elementary PK 5 2017   grade_10                                                   0.0                                             0
280264 HI     school 1500030 1   Hawaii Department of Education 150003000216 113 KAEWAI   Regular School No 1 PK 5 2015   grade_10                                                   0.0                                             0
2431402 HI     school 1500030 1   Hawaii Department of Education 150003000216 113 Kaewai Elem   Regular School No Elementary PK 5 2020   grade_10                                                   0.0                                             0
2456093 HI     school 1500030 1   Hawaii Department of Education 150003000216 113 Kaewai Elem   Regular School No Elementary PK 5 2021   grade_10                                                   0.0                                             0
2737062 HI     school 1500030 1   Hawaii Department of Education 150003000216 113 Kaewai Elem   Regular School No Elementary PK 5 2019   grade_10                                                   0.0                                             0
2782112 HI     school 1500030 1   Hawaii Department of Education 150003000216 113 Kaewai Elem   Regular School No Elementary PK 5 2018   grade_10                                                   0.0                                             0
110287 HI     school 1500030 1   Hawaii Department of Education 150003000215 114 KAHALA   Regular School No 1 PK 5 2016   grade_10                                                   0.0                                             0
129290 HI     school 1500030 1   Hawaii Department of Education 150003000215 114 KAHALA   Regular School No Elementary PK 5 2017   grade_10                                                   0.0                                             0
280265 HI     school 1500030 1   Hawaii Department of Education 150003000215 114 KAHALA   Regular School No 1 PK 5 2015   grade_10                                                   0.0                                             0