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
2456381 HI     school 1500030 1   Hawaii Department of Education 150003000227 100 Aina Haina Elem   Regular School No Elementary PK 5 2021   grade_11                                                   0.0                                             0
2737348 HI     school 1500030 1   Hawaii Department of Education 150003000227 100 Aina Haina Elem   Regular School No Elementary PK 5 2019   grade_11                                                   0.0                                             0
2782398 HI     school 1500030 1   Hawaii Department of Education 150003000227 100 Aina Haina Elem   Regular School No Elementary PK 5 2018   grade_11                                                   0.0                                             0
110595 HI     school 1500030 1   Hawaii Department of Education 150003000226 101 ALA WAI   Regular School No 1 PK 5 2016   grade_11                                                   0.0                                             0
129598 HI     school 1500030 1   Hawaii Department of Education 150003000226 101 ALA WAI   Regular School No Elementary PK 5 2017   grade_11                                                   0.0                                             0
280572 HI     school 1500030 1   Hawaii Department of Education 150003000226 101 ALA WAI   Regular School No 1 PK 5 2015   grade_11                                                   0.0                                             0
2431714 HI     school 1500030 1   Hawaii Department of Education 150003000226 101 Ala Wai Elem   Regular School No Elementary PK 5 2020   grade_11                                                   0.0                                             0
2456406 HI     school 1500030 1   Hawaii Department of Education 150003000226 101 Ala Wai Elem   Regular School No Elementary PK 5 2021   grade_11                                                   0.0                                             0
2737373 HI     school 1500030 1   Hawaii Department of Education 150003000226 101 Ala Wai Elem   Regular School No Elementary PK 5 2019   grade_11                                                   0.0                                             0
2782423 HI     school 1500030 1   Hawaii Department of Education 150003000226 101 Ala Wai Elem   Regular School No Elementary PK 5 2018   grade_11                                                   0.0                                             0
110596 HI     school 1500030 1   Hawaii Department of Education 150003000225 102 ALIIOLANI   Regular School No 1 PK 5 2016   grade_11                                                   0.0                                             0
129599 HI     school 1500030 1   Hawaii Department of Education 150003000225 102 ALIIOLANI   Regular School No Elementary PK 5 2017   grade_11                                                   0.0                                             0
280573 HI     school 1500030 1   Hawaii Department of Education 150003000225 102 ALIIOLANI   Regular School No 1 PK 5 2015   grade_11                                                   0.0                                             0
2431715 HI     school 1500030 1   Hawaii Department of Education 150003000225 102 Aliiolani Elem   Regular School No Elementary PK 5 2020   grade_11                                                   0.0                                             0
2456407 HI     school 1500030 1   Hawaii Department of Education 150003000225 102 Aliiolani Elem   Regular School No Elementary PK 5 2021   grade_11                                                   0.0                                             0
2737374 HI     school 1500030 1   Hawaii Department of Education 150003000225 102 Aliiolani Elem   Regular School No Elementary PK 5 2019   grade_11                                                   0.0                                             0
2782424 HI     school 1500030 1   Hawaii Department of Education 150003000225 102 Aliiolani Elem   Regular School No Elementary PK 5 2018   grade_11                                                   0.0                                             0
110597 HI     school 1500030 1   Hawaii Department of Education 150003000246 103 ANUENUE   Regular School No 4 PK 12 2016   grade_11                                                   11.0                                             11
129600 HI     school 1500030 1   Hawaii Department of Education 150003000246 103 ANUENUE   Regular School No Other PK 12 2017   grade_11                                                   12.0                                             12
280574 HI     school 1500030 1   Hawaii Department of Education 150003000246 103 ANUENUE   Regular School No 4 PK 12 2015   grade_11                                                   14.0                                             14
2431716 HI     school 1500030 1   Hawaii Department of Education 150003000246 103 Anuenue   Regular School No Other PK 12 2020   grade_11                                                   18.0                                             18
2456408 HI     school 1500030 1   Hawaii Department of Education 150003000246 103 Anuenue   Regular School No Other PK 12 2021   grade_11                                                   21.0                                             21
2737375 HI     school 1500030 1   Hawaii Department of Education 150003000246 103 Anuenue   Regular School No Other PK 12 2019   grade_11                                                   16.0                                             16
2782425 HI     school 1500030 1   Hawaii Department of Education 150003000246 103 Anuenue   Regular School No Other PK 12 2018   grade_11                                                   14.0                                             14
110598 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 CENTRAL MID   Regular School No 2 06 8 2016   grade_11                                                   0.0                                             0
129601 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 CENTRAL MID   Regular School No Middle 06 8 2017   grade_11                                                   0.0                                             0
280575 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 CENTRAL MID   Regular School No 2 06 8 2015   grade_11                                                   0.0                                             0
2431717 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 Central Middle   Regular School No Middle 06 8 2020   grade_11                                                   0.0                                             0
2456409 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 Central Middle   Regular School No Middle 06 8 2021   grade_11                                                   0.0                                             0
2737376 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 Central Middle   Regular School No Middle 06 8 2019   grade_11                                                   0.0                                             0
2782426 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 Central Middle   Regular School No Middle 06 8 2018   grade_11                                                   0.0                                             0
110571 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 DOLE MID   Regular School No 2 06 8 2016   grade_11                                                   0.0                                             0
129574 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 DOLE MID   Regular School No Middle 06 8 2017   grade_11                                                   0.0                                             0
280548 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 DOLE MID   Regular School No 2 06 8 2015   grade_11                                                   0.0                                             0
2431690 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 Dole Middle   Regular School No Middle 06 8 2020   grade_11                                                   0.0                                             0
2456382 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 Dole Middle   Regular School No Middle 06 8 2021   grade_11                                                   0.0                                             0
2737349 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 Dole Middle   Regular School No Middle 06 8 2019   grade_11                                                   0.0                                             0
2782399 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 Dole Middle   Regular School No Middle 06 8 2018   grade_11                                                   0.0                                             0
110572 HI     school 1500030 1   Hawaii Department of Education 150003000221 106 FARRINGTON HI   Regular School No 3 09 12 2016   grade_11                                                   491.0                                             491
129575 HI     school 1500030 1   Hawaii Department of Education 150003000221 106 FARRINGTON HI   Regular School No High 09 12 2017   grade_11                                                   536.0                                             536
280549 HI     school 1500030 1   Hawaii Department of Education 150003000221 106 FARRINGTON HI   Regular School No 3 09 12 2015   grade_11                                                   503.0                                             503
2431691 HI     school 1500030 1   Hawaii Department of Education 150003000221 106 Farrington High   Regular School No High 09 12 2020   grade_11                                                   472.0                                             472
2456383 HI     school 1500030 1   Hawaii Department of Education 150003000221 106 Farrington High   Regular School No High 09 12 2021   grade_11                                                   494.0                                             494
2737350 HI     school 1500030 1   Hawaii Department of Education 150003000221 106 Farrington High   Regular School No High 09 12 2019   grade_11                                                   515.0                                             515
2782400 HI     school 1500030 1   Hawaii Department of Education 150003000221 106 Farrington High   Regular School No High 09 12 2018   grade_11                                                   471.0                                             471
110573 HI     school 1500030 1   Hawaii Department of Education 150003000220 107 FERN   Regular School No 1 PK 5 2016   grade_11                                                   0.0                                             0
129576 HI     school 1500030 1   Hawaii Department of Education 150003000220 107 FERN   Regular School No Elementary PK 5 2017   grade_11                                                   0.0                                             0
280550 HI     school 1500030 1   Hawaii Department of Education 150003000220 107 FERN   Regular School No 1 PK 5 2015   grade_11                                                   0.0                                             0
2431692 HI     school 1500030 1   Hawaii Department of Education 150003000220 107 Fern Elem   Regular School No Elementary PK 5 2020   grade_11                                                   0.0                                             0
2456384 HI     school 1500030 1   Hawaii Department of Education 150003000220 107 Fern Elem   Regular School No Elementary PK 5 2021   grade_11                                                   0.0                                             0
2737351 HI     school 1500030 1   Hawaii Department of Education 150003000220 107 Fern Elem   Regular School No Elementary PK 5 2019   grade_11                                                   0.0                                             0
2782401 HI     school 1500030 1   Hawaii Department of Education 150003000220 107 Fern Elem   Regular School No Elementary PK 5 2018   grade_11                                                   0.0                                             0
110574 HI     school 1500030 1   Hawaii Department of Education 150003000219 108 HAHAIONE   Regular School No 1 PK 5 2016   grade_11                                                   0.0                                             0
129577 HI     school 1500030 1   Hawaii Department of Education 150003000219 108 HAHAIONE   Regular School No Elementary PK 5 2017   grade_11                                                   0.0                                             0
280551 HI     school 1500030 1   Hawaii Department of Education 150003000219 108 HAHAIONE   Regular School No 1 PK 5 2015   grade_11                                                   0.0                                             0
2431693 HI     school 1500030 1   Hawaii Department of Education 150003000219 108 Hahaione Elem   Regular School No Elementary PK 5 2020   grade_11                                                   0.0                                             0
2456385 HI     school 1500030 1   Hawaii Department of Education 150003000219 108 Hahaione Elem   Regular School No Elementary PK 5 2021   grade_11                                                   0.0                                             0
2737352 HI     school 1500030 1   Hawaii Department of Education 150003000219 108 Hahaione Elem   Regular School No Elementary PK 5 2019   grade_11                                                   0.0                                             0
2782402 HI     school 1500030 1   Hawaii Department of Education 150003000219 108 Hahaione Elem   Regular School No Elementary PK 5 2018   grade_11                                                   0.0                                             0
110599 HI     school 1500030 1   Hawaii Department of Education 150003000214 109 HOKULANI   Regular School No 1 PK 5 2016   grade_11                                                   0.0                                             0
129602 HI     school 1500030 1   Hawaii Department of Education 150003000214 109 HOKULANI   Regular School No Elementary PK 5 2017   grade_11                                                   0.0                                             0
280576 HI     school 1500030 1   Hawaii Department of Education 150003000214 109 HOKULANI   Regular School No 1 PK 5 2015   grade_11                                                   0.0                                             0
2431718 HI     school 1500030 1   Hawaii Department of Education 150003000214 109 Hokulani Elem   Regular School No Elementary PK 5 2020   grade_11                                                   0.0                                             0
2456410 HI     school 1500030 1   Hawaii Department of Education 150003000214 109 Hokulani Elem   Regular School No Elementary PK 5 2021   grade_11                                                   0.0                                             0
2737377 HI     school 1500030 1   Hawaii Department of Education 150003000214 109 Hokulani Elem   Regular School No Elementary PK 5 2019   grade_11                                                   0.0                                             0
2782427 HI     school 1500030 1   Hawaii Department of Education 150003000214 109 Hokulani Elem   Regular School No Elementary PK 5 2018   grade_11                                                   0.0                                             0
110600 HI     school 1500030 1   Hawaii Department of Education 150003000218 110 JARRETT MID   Regular School No 2 06 8 2016   grade_11                                                   0.0                                             0
129603 HI     school 1500030 1   Hawaii Department of Education 150003000218 110 JARRETT MID   Regular School No Middle 06 8 2017   grade_11                                                   0.0                                             0
280577 HI     school 1500030 1   Hawaii Department of Education 150003000218 110 JARRETT MID   Regular School No 2 06 8 2015   grade_11                                                   0.0                                             0
2431719 HI     school 1500030 1   Hawaii Department of Education 150003000218 110 Jarrett Middle   Regular School No Middle 06 8 2020   grade_11                                                   0.0                                             0
2456411 HI     school 1500030 1   Hawaii Department of Education 150003000218 110 Jarrett Middle   Regular School No Middle 06 8 2021   grade_11                                                   0.0                                             0
2737378 HI     school 1500030 1   Hawaii Department of Education 150003000218 110 Jarrett Middle   Regular School No Middle 06 8 2019   grade_11                                                   0.0                                             0
2782428 HI     school 1500030 1   Hawaii Department of Education 150003000218 110 Jarrett Middle   Regular School No Middle 06 8 2018   grade_11                                                   0.0                                             0
110601 HI     school 1500030 1   Hawaii Department of Education 150003000213 111 JEFFERSON   Regular School No 1 PK 5 2016   grade_11                                                   0.0                                             0
129604 HI     school 1500030 1   Hawaii Department of Education 150003000213 111 JEFFERSON   Regular School No Elementary PK 5 2017   grade_11                                                   0.0                                             0
280578 HI     school 1500030 1   Hawaii Department of Education 150003000213 111 JEFFERSON   Regular School No 1 PK 5 2015   grade_11                                                   0.0                                             0
2431720 HI     school 1500030 1   Hawaii Department of Education 150003000213 111 Jefferson Elem   Regular School No Elementary PK 5 2020   grade_11                                                   0.0                                             0
2456412 HI     school 1500030 1   Hawaii Department of Education 150003000213 111 Jefferson Elem   Regular School No Elementary PK 5 2021   grade_11                                                   0.0                                             0
2737379 HI     school 1500030 1   Hawaii Department of Education 150003000213 111 Jefferson Elem   Regular School No Elementary PK 5 2019   grade_11                                                   0.0                                             0
2782429 HI     school 1500030 1   Hawaii Department of Education 150003000213 111 Jefferson Elem   Regular School No Elementary PK 5 2018   grade_11                                                   0.0                                             0
110602 HI     school 1500030 1   Hawaii Department of Education 150003000217 112 KAAHUMANU   Regular School No 1 PK 5 2016   grade_11                                                   0.0                                             0
129605 HI     school 1500030 1   Hawaii Department of Education 150003000217 112 KAAHUMANU   Regular School No Elementary PK 5 2017   grade_11                                                   0.0                                             0
280579 HI     school 1500030 1   Hawaii Department of Education 150003000217 112 KAAHUMANU   Regular School No 1 PK 5 2015   grade_11                                                   0.0                                             0
2431721 HI     school 1500030 1   Hawaii Department of Education 150003000217 112 Kaahumanu Elem   Regular School No Elementary PK 5 2020   grade_11                                                   0.0                                             0
2456413 HI     school 1500030 1   Hawaii Department of Education 150003000217 112 Kaahumanu Elem   Regular School No Elementary PK 5 2021   grade_11                                                   0.0                                             0
2737380 HI     school 1500030 1   Hawaii Department of Education 150003000217 112 Kaahumanu Elem   Regular School No Elementary PK 5 2019   grade_11                                                   0.0                                             0
2782430 HI     school 1500030 1   Hawaii Department of Education 150003000217 112 Kaahumanu Elem   Regular School No Elementary PK 5 2018   grade_11                                                   0.0                                             0
110576 HI     school 1500030 1   Hawaii Department of Education 150003000216 113 KAEWAI   Regular School No 1 PK 5 2016   grade_11                                                   0.0                                             0
129579 HI     school 1500030 1   Hawaii Department of Education 150003000216 113 KAEWAI   Regular School No Elementary PK 5 2017   grade_11                                                   0.0                                             0
280553 HI     school 1500030 1   Hawaii Department of Education 150003000216 113 KAEWAI   Regular School No 1 PK 5 2015   grade_11                                                   0.0                                             0
2431695 HI     school 1500030 1   Hawaii Department of Education 150003000216 113 Kaewai Elem   Regular School No Elementary PK 5 2020   grade_11                                                   0.0                                             0
2456387 HI     school 1500030 1   Hawaii Department of Education 150003000216 113 Kaewai Elem   Regular School No Elementary PK 5 2021   grade_11                                                   0.0                                             0
2737354 HI     school 1500030 1   Hawaii Department of Education 150003000216 113 Kaewai Elem   Regular School No Elementary PK 5 2019   grade_11                                                   0.0                                             0
2782404 HI     school 1500030 1   Hawaii Department of Education 150003000216 113 Kaewai Elem   Regular School No Elementary PK 5 2018   grade_11                                                   0.0                                             0
110577 HI     school 1500030 1   Hawaii Department of Education 150003000215 114 KAHALA   Regular School No 1 PK 5 2016   grade_11                                                   0.0                                             0
129580 HI     school 1500030 1   Hawaii Department of Education 150003000215 114 KAHALA   Regular School No Elementary PK 5 2017   grade_11                                                   0.0                                             0
280554 HI     school 1500030 1   Hawaii Department of Education 150003000215 114 KAHALA   Regular School No 1 PK 5 2015   grade_11                                                   0.0                                             0
2431696 HI     school 1500030 1   Hawaii Department of Education 150003000215 114 Kahala Elem   Regular School No Elementary PK 5 2020   grade_11                                                   0.0                                             0
2456388 HI     school 1500030 1   Hawaii Department of Education 150003000215 114 Kahala Elem   Regular School No Elementary PK 5 2021   grade_11                                                   0.0                                             0
2737355 HI     school 1500030 1   Hawaii Department of Education 150003000215 114 Kahala Elem   Regular School No Elementary PK 5 2019   grade_11                                                   0.0                                             0
2782405 HI     school 1500030 1   Hawaii Department of Education 150003000215 114 Kahala Elem   Regular School No Elementary PK 5 2018   grade_11                                                   0.0                                             0