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
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
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
2456675 HI     school 1500030 1   Hawaii Department of Education 150003000227 100 Aina Haina Elem   Regular School No Elementary PK 5 2021   grade_12                                                   0.0                                             0
2456969 HI     school 1500030 1   Hawaii Department of Education 150003000227 100 Aina Haina Elem   Regular School No Elementary PK 5 2021   pre_kindergarten                                                   4.0                                             4
2457263 HI     school 1500030 1   Hawaii Department of Education 150003000227 100 Aina Haina Elem   Regular School No Elementary PK 5 2021   pk_12_total                                               35.0   490.0                                         35   490
2453172 HI     school 1500030 1   Hawaii Department of Education 150003000226 101 Ala Wai Elem   Regular School No Elementary PK 5 2021   kindergarten                                                   57.0                                             57
2453466 HI     school 1500030 1   Hawaii Department of Education 150003000226 101 Ala Wai Elem   Regular School No Elementary PK 5 2021   grade_1                                                   51.0                                             51
2453760 HI     school 1500030 1   Hawaii Department of Education 150003000226 101 Ala Wai Elem   Regular School No Elementary PK 5 2021   grade_2                                                   56.0                                             56
2454054 HI     school 1500030 1   Hawaii Department of Education 150003000226 101 Ala Wai Elem   Regular School No Elementary PK 5 2021   grade_3                                                   60.0                                             60
2454348 HI     school 1500030 1   Hawaii Department of Education 150003000226 101 Ala Wai Elem   Regular School No Elementary PK 5 2021   grade_4                                                   50.0                                             50
2454642 HI     school 1500030 1   Hawaii Department of Education 150003000226 101 Ala Wai Elem   Regular School No Elementary PK 5 2021   grade_5                                                   43.0                                             43
2454936 HI     school 1500030 1   Hawaii Department of Education 150003000226 101 Ala Wai Elem   Regular School No Elementary PK 5 2021   grade_6                                                   0.0                                             0
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
2455524 HI     school 1500030 1   Hawaii Department of Education 150003000226 101 Ala Wai Elem   Regular School No Elementary PK 5 2021   grade_8                                                   0.0                                             0
2455818 HI     school 1500030 1   Hawaii Department of Education 150003000226 101 Ala Wai Elem   Regular School No Elementary PK 5 2021   grade_9                                                   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
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
2456700 HI     school 1500030 1   Hawaii Department of Education 150003000226 101 Ala Wai Elem   Regular School No Elementary PK 5 2021   grade_12                                                   0.0                                             0
2456994 HI     school 1500030 1   Hawaii Department of Education 150003000226 101 Ala Wai Elem   Regular School No Elementary PK 5 2021   pre_kindergarten                                                   13.0                                             13
2457288 HI     school 1500030 1   Hawaii Department of Education 150003000226 101 Ala Wai Elem   Regular School No Elementary PK 5 2021   pk_12_total                                               33.0   363.0                                         33   363
2453173 HI     school 1500030 1   Hawaii Department of Education 150003000225 102 Aliiolani Elem   Regular School No Elementary PK 5 2021   kindergarten                                                   40.0                                             40
2453467 HI     school 1500030 1   Hawaii Department of Education 150003000225 102 Aliiolani Elem   Regular School No Elementary PK 5 2021   grade_1                                                   35.0                                             35
2453761 HI     school 1500030 1   Hawaii Department of Education 150003000225 102 Aliiolani Elem   Regular School No Elementary PK 5 2021   grade_2                                                   38.0                                             38
2454055 HI     school 1500030 1   Hawaii Department of Education 150003000225 102 Aliiolani Elem   Regular School No Elementary PK 5 2021   grade_3                                                   40.0                                             40
2454349 HI     school 1500030 1   Hawaii Department of Education 150003000225 102 Aliiolani Elem   Regular School No Elementary PK 5 2021   grade_4                                                   35.0                                             35
2454643 HI     school 1500030 1   Hawaii Department of Education 150003000225 102 Aliiolani Elem   Regular School No Elementary PK 5 2021   grade_5                                                   46.0                                             46
2454937 HI     school 1500030 1   Hawaii Department of Education 150003000225 102 Aliiolani Elem   Regular School No Elementary PK 5 2021   grade_6                                                   0.0                                             0
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
2455525 HI     school 1500030 1   Hawaii Department of Education 150003000225 102 Aliiolani Elem   Regular School No Elementary PK 5 2021   grade_8                                                   0.0                                             0
2455819 HI     school 1500030 1   Hawaii Department of Education 150003000225 102 Aliiolani Elem   Regular School No Elementary PK 5 2021   grade_9                                                   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
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
2456701 HI     school 1500030 1   Hawaii Department of Education 150003000225 102 Aliiolani Elem   Regular School No Elementary PK 5 2021   grade_12                                                   0.0                                             0
2456995 HI     school 1500030 1   Hawaii Department of Education 150003000225 102 Aliiolani Elem   Regular School No Elementary PK 5 2021   pre_kindergarten                                                   10.0                                             10
2457289 HI     school 1500030 1   Hawaii Department of Education 150003000225 102 Aliiolani Elem   Regular School No Elementary PK 5 2021   pk_12_total                                               19.0   263.0                                         19   263
2453174 HI     school 1500030 1   Hawaii Department of Education 150003000246 103 Anuenue   Regular School No Other PK 12 2021   kindergarten                                                   30.0                                             30
2453468 HI     school 1500030 1   Hawaii Department of Education 150003000246 103 Anuenue   Regular School No Other PK 12 2021   grade_1                                                   51.0                                             51
2453762 HI     school 1500030 1   Hawaii Department of Education 150003000246 103 Anuenue   Regular School No Other PK 12 2021   grade_2                                                   61.0                                             61
2454056 HI     school 1500030 1   Hawaii Department of Education 150003000246 103 Anuenue   Regular School No Other PK 12 2021   grade_3                                                   48.0                                             48
2454350 HI     school 1500030 1   Hawaii Department of Education 150003000246 103 Anuenue   Regular School No Other PK 12 2021   grade_4                                                   45.0                                             45
2454644 HI     school 1500030 1   Hawaii Department of Education 150003000246 103 Anuenue   Regular School No Other PK 12 2021   grade_5                                                   47.0                                             47
2454938 HI     school 1500030 1   Hawaii Department of Education 150003000246 103 Anuenue   Regular School No Other PK 12 2021   grade_6                                                   29.0                                             29
2455232 HI     school 1500030 1   Hawaii Department of Education 150003000246 103 Anuenue   Regular School No Other PK 12 2021   grade_7                                                   47.0                                             47
2455526 HI     school 1500030 1   Hawaii Department of Education 150003000246 103 Anuenue   Regular School No Other PK 12 2021   grade_8                                                   32.0                                             32
2455820 HI     school 1500030 1   Hawaii Department of Education 150003000246 103 Anuenue   Regular School No Other PK 12 2021   grade_9                                                   27.0                                             27
2456114 HI     school 1500030 1   Hawaii Department of Education 150003000246 103 Anuenue   Regular School No Other PK 12 2021   grade_10                                                   17.0                                             17
2456408 HI     school 1500030 1   Hawaii Department of Education 150003000246 103 Anuenue   Regular School No Other PK 12 2021   grade_11                                                   21.0                                             21
2456702 HI     school 1500030 1   Hawaii Department of Education 150003000246 103 Anuenue   Regular School No Other PK 12 2021   grade_12                                                   22.0                                             22
2456996 HI     school 1500030 1   Hawaii Department of Education 150003000246 103 Anuenue   Regular School No Other PK 12 2021   pre_kindergarten                                                   0.0                                             0
2457290 HI     school 1500030 1   Hawaii Department of Education 150003000246 103 Anuenue   Regular School No Other PK 12 2021   pk_12_total                                               30.0   507.0                                         30   507
2453175 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 Central Middle   Regular School No Middle 06 8 2021   kindergarten                                                   0.0                                             0
2453469 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 Central Middle   Regular School No Middle 06 8 2021   grade_1                                                   0.0                                             0
2453763 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 Central Middle   Regular School No Middle 06 8 2021   grade_2                                                   0.0                                             0
2454057 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 Central Middle   Regular School No Middle 06 8 2021   grade_3                                                   0.0                                             0
2454351 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 Central Middle   Regular School No Middle 06 8 2021   grade_4                                                   0.0                                             0
2454645 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 Central Middle   Regular School No Middle 06 8 2021   grade_5                                                   0.0                                             0
2454939 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 Central Middle   Regular School No Middle 06 8 2021   grade_6                                                   72.0                                             72
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
2455527 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 Central Middle   Regular School No Middle 06 8 2021   grade_8                                                   105.0                                             105
2455821 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 Central Middle   Regular School No Middle 06 8 2021   grade_9                                                   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
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
2456703 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 Central Middle   Regular School No Middle 06 8 2021   grade_12                                                   0.0                                             0
2456997 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 Central Middle   Regular School No Middle 06 8 2021   pre_kindergarten                                                   0.0                                             0
2457291 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 Central Middle   Regular School No Middle 06 8 2021   pk_12_total                                               45.0   321.0                                         45   321
2453148 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 Dole Middle   Regular School No Middle 06 8 2021   kindergarten                                                   0.0                                             0
2453442 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 Dole Middle   Regular School No Middle 06 8 2021   grade_1                                                   0.0                                             0
2453736 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 Dole Middle   Regular School No Middle 06 8 2021   grade_2                                                   0.0                                             0
2454030 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 Dole Middle   Regular School No Middle 06 8 2021   grade_3                                                   0.0                                             0
2454324 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 Dole Middle   Regular School No Middle 06 8 2021   grade_4                                                   0.0                                             0
2454618 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 Dole Middle   Regular School No Middle 06 8 2021   grade_5                                                   0.0                                             0
2454912 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 Dole Middle   Regular School No Middle 06 8 2021   grade_6                                                   121.0                                             121
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
2455500 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 Dole Middle   Regular School No Middle 06 8 2021   grade_8                                                   183.0                                             183
2455794 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 Dole Middle   Regular School No Middle 06 8 2021   grade_9                                                   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
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
2456676 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 Dole Middle   Regular School No Middle 06 8 2021   grade_12                                                   0.0                                             0
2456970 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 Dole Middle   Regular School No Middle 06 8 2021   pre_kindergarten                                                   0.0                                             0
2457264 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 Dole Middle   Regular School No Middle 06 8 2021   pk_12_total                                               78.0   580.0                                         78   580
2453149 HI     school 1500030 1   Hawaii Department of Education 150003000221 106 Farrington High   Regular School No High 09 12 2021   kindergarten                                                   0.0                                             0
2453443 HI     school 1500030 1   Hawaii Department of Education 150003000221 106 Farrington High   Regular School No High 09 12 2021   grade_1                                                   0.0                                             0
2453737 HI     school 1500030 1   Hawaii Department of Education 150003000221 106 Farrington High   Regular School No High 09 12 2021   grade_2                                                   0.0                                             0
2454031 HI     school 1500030 1   Hawaii Department of Education 150003000221 106 Farrington High   Regular School No High 09 12 2021   grade_3                                                   0.0                                             0
2454325 HI     school 1500030 1   Hawaii Department of Education 150003000221 106 Farrington High   Regular School No High 09 12 2021   grade_4                                                   0.0                                             0
2454619 HI     school 1500030 1   Hawaii Department of Education 150003000221 106 Farrington High   Regular School No High 09 12 2021   grade_5                                                   0.0                                             0
2454913 HI     school 1500030 1   Hawaii Department of Education 150003000221 106 Farrington High   Regular School No High 09 12 2021   grade_6                                                   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
2455501 HI     school 1500030 1   Hawaii Department of Education 150003000221 106 Farrington High   Regular School No High 09 12 2021   grade_8                                                   0.0                                             0
2455795 HI     school 1500030 1   Hawaii Department of Education 150003000221 106 Farrington High   Regular School No High 09 12 2021   grade_9                                                   674.0                                             674
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
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
2456677 HI     school 1500030 1   Hawaii Department of Education 150003000221 106 Farrington High   Regular School No High 09 12 2021   grade_12                                                   449.0                                             449
2456971 HI     school 1500030 1   Hawaii Department of Education 150003000221 106 Farrington High   Regular School No High 09 12 2021   pre_kindergarten                                                   0.0                                             0
2457265 HI     school 1500030 1   Hawaii Department of Education 150003000221 106 Farrington High   Regular School No High 09 12 2021   pk_12_total                                               205.0   2365.0                                         205   2365
2453150 HI     school 1500030 1   Hawaii Department of Education 150003000220 107 Fern Elem   Regular School No Elementary PK 5 2021   kindergarten                                                   32.0                                             32
2453444 HI     school 1500030 1   Hawaii Department of Education 150003000220 107 Fern Elem   Regular School No Elementary PK 5 2021   grade_1                                                   45.0                                             45
2453738 HI     school 1500030 1   Hawaii Department of Education 150003000220 107 Fern Elem   Regular School No Elementary PK 5 2021   grade_2                                                   91.0                                             91
2454032 HI     school 1500030 1   Hawaii Department of Education 150003000220 107 Fern Elem   Regular School No Elementary PK 5 2021   grade_3                                                   73.0                                             73
2454326 HI     school 1500030 1   Hawaii Department of Education 150003000220 107 Fern Elem   Regular School No Elementary PK 5 2021   grade_4                                                   66.0                                             66
2454620 HI     school 1500030 1   Hawaii Department of Education 150003000220 107 Fern Elem   Regular School No Elementary PK 5 2021   grade_5                                                   76.0                                             76