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
107380 HI     school 1500030 1   Hawaii Department of Education 150003000227 100 AINA HAINA   Regular School No 1 PK 5 2016   kindergarten                                                   67.0                                             67
107670 HI     school 1500030 1   Hawaii Department of Education 150003000227 100 AINA HAINA   Regular School No 1 PK 5 2016   grade_1                                                   55.0                                             55
107960 HI     school 1500030 1   Hawaii Department of Education 150003000227 100 AINA HAINA   Regular School No 1 PK 5 2016   grade_2                                                   76.0                                             76
108250 HI     school 1500030 1   Hawaii Department of Education 150003000227 100 AINA HAINA   Regular School No 1 PK 5 2016   grade_3                                                   85.0                                             85
108540 HI     school 1500030 1   Hawaii Department of Education 150003000227 100 AINA HAINA   Regular School No 1 PK 5 2016   grade_4                                                   84.0                                             84
108830 HI     school 1500030 1   Hawaii Department of Education 150003000227 100 AINA HAINA   Regular School No 1 PK 5 2016   grade_5                                                   96.0                                             96
109120 HI     school 1500030 1   Hawaii Department of Education 150003000227 100 AINA HAINA   Regular School No 1 PK 5 2016   grade_6                                                   0.0                                             0
109410 HI     school 1500030 1   Hawaii Department of Education 150003000227 100 AINA HAINA   Regular School No 1 PK 5 2016   grade_7                                                   0.0                                             0
109700 HI     school 1500030 1   Hawaii Department of Education 150003000227 100 AINA HAINA   Regular School No 1 PK 5 2016   grade_8                                                   0.0                                             0
109990 HI     school 1500030 1   Hawaii Department of Education 150003000227 100 AINA HAINA   Regular School No 1 PK 5 2016   grade_9                                                   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
110570 HI     school 1500030 1   Hawaii Department of Education 150003000227 100 AINA HAINA   Regular School No 1 PK 5 2016   grade_11                                                   0.0                                             0
110860 HI     school 1500030 1   Hawaii Department of Education 150003000227 100 AINA HAINA   Regular School No 1 PK 5 2016   grade_12                                                   0.0                                             0
111150 HI     school 1500030 1   Hawaii Department of Education 150003000227 100 AINA HAINA   Regular School No 1 PK 5 2016   pre_kindergarten                                                   9.0                                             9
111440 HI     school 1500030 1   Hawaii Department of Education 150003000227 100 AINA HAINA   Regular School No 1 PK 5 2016   pk_12_total                                               36.0   508.0                                         36   508
107405 HI     school 1500030 1   Hawaii Department of Education 150003000226 101 ALA WAI   Regular School No 1 PK 5 2016   kindergarten                                                   69.0                                             69
107695 HI     school 1500030 1   Hawaii Department of Education 150003000226 101 ALA WAI   Regular School No 1 PK 5 2016   grade_1                                                   45.0                                             45
107985 HI     school 1500030 1   Hawaii Department of Education 150003000226 101 ALA WAI   Regular School No 1 PK 5 2016   grade_2                                                   70.0                                             70
108275 HI     school 1500030 1   Hawaii Department of Education 150003000226 101 ALA WAI   Regular School No 1 PK 5 2016   grade_3                                                   66.0                                             66
108565 HI     school 1500030 1   Hawaii Department of Education 150003000226 101 ALA WAI   Regular School No 1 PK 5 2016   grade_4                                                   69.0                                             69
108855 HI     school 1500030 1   Hawaii Department of Education 150003000226 101 ALA WAI   Regular School No 1 PK 5 2016   grade_5                                                   64.0                                             64
109145 HI     school 1500030 1   Hawaii Department of Education 150003000226 101 ALA WAI   Regular School No 1 PK 5 2016   grade_6                                                   0.0                                             0
109435 HI     school 1500030 1   Hawaii Department of Education 150003000226 101 ALA WAI   Regular School No 1 PK 5 2016   grade_7                                                   0.0                                             0
109725 HI     school 1500030 1   Hawaii Department of Education 150003000226 101 ALA WAI   Regular School No 1 PK 5 2016   grade_8                                                   0.0                                             0
110015 HI     school 1500030 1   Hawaii Department of Education 150003000226 101 ALA WAI   Regular School No 1 PK 5 2016   grade_9                                                   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
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
110885 HI     school 1500030 1   Hawaii Department of Education 150003000226 101 ALA WAI   Regular School No 1 PK 5 2016   grade_12                                                   0.0                                             0
111175 HI     school 1500030 1   Hawaii Department of Education 150003000226 101 ALA WAI   Regular School No 1 PK 5 2016   pre_kindergarten                                                   12.0                                             12
111465 HI     school 1500030 1   Hawaii Department of Education 150003000226 101 ALA WAI   Regular School No 1 PK 5 2016   pk_12_total                                               35.0   430.0                                         35   430
107406 HI     school 1500030 1   Hawaii Department of Education 150003000225 102 ALIIOLANI   Regular School No 1 PK 5 2016   kindergarten                                                   38.0                                             38
107696 HI     school 1500030 1   Hawaii Department of Education 150003000225 102 ALIIOLANI   Regular School No 1 PK 5 2016   grade_1                                                   19.0                                             19
107986 HI     school 1500030 1   Hawaii Department of Education 150003000225 102 ALIIOLANI   Regular School No 1 PK 5 2016   grade_2                                                   38.0                                             38
108276 HI     school 1500030 1   Hawaii Department of Education 150003000225 102 ALIIOLANI   Regular School No 1 PK 5 2016   grade_3                                                   40.0                                             40
108566 HI     school 1500030 1   Hawaii Department of Education 150003000225 102 ALIIOLANI   Regular School No 1 PK 5 2016   grade_4                                                   31.0                                             31
108856 HI     school 1500030 1   Hawaii Department of Education 150003000225 102 ALIIOLANI   Regular School No 1 PK 5 2016   grade_5                                                   32.0                                             32
109146 HI     school 1500030 1   Hawaii Department of Education 150003000225 102 ALIIOLANI   Regular School No 1 PK 5 2016   grade_6                                                   0.0                                             0
109436 HI     school 1500030 1   Hawaii Department of Education 150003000225 102 ALIIOLANI   Regular School No 1 PK 5 2016   grade_7                                                   0.0                                             0
109726 HI     school 1500030 1   Hawaii Department of Education 150003000225 102 ALIIOLANI   Regular School No 1 PK 5 2016   grade_8                                                   0.0                                             0
110016 HI     school 1500030 1   Hawaii Department of Education 150003000225 102 ALIIOLANI   Regular School No 1 PK 5 2016   grade_9                                                   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
110596 HI     school 1500030 1   Hawaii Department of Education 150003000225 102 ALIIOLANI   Regular School No 1 PK 5 2016   grade_11                                                   0.0                                             0
110886 HI     school 1500030 1   Hawaii Department of Education 150003000225 102 ALIIOLANI   Regular School No 1 PK 5 2016   grade_12                                                   0.0                                             0
111176 HI     school 1500030 1   Hawaii Department of Education 150003000225 102 ALIIOLANI   Regular School No 1 PK 5 2016   pre_kindergarten                                                   5.0                                             5
111466 HI     school 1500030 1   Hawaii Department of Education 150003000225 102 ALIIOLANI   Regular School No 1 PK 5 2016   pk_12_total                                               29.0   232.0                                         29   232
107407 HI     school 1500030 1   Hawaii Department of Education 150003000246 103 ANUENUE   Regular School No 4 PK 12 2016   kindergarten                                                   49.0                                             49
107697 HI     school 1500030 1   Hawaii Department of Education 150003000246 103 ANUENUE   Regular School No 4 PK 12 2016   grade_1                                                   29.0                                             29
107987 HI     school 1500030 1   Hawaii Department of Education 150003000246 103 ANUENUE   Regular School No 4 PK 12 2016   grade_2                                                   54.0                                             54
108277 HI     school 1500030 1   Hawaii Department of Education 150003000246 103 ANUENUE   Regular School No 4 PK 12 2016   grade_3                                                   35.0                                             35
108567 HI     school 1500030 1   Hawaii Department of Education 150003000246 103 ANUENUE   Regular School No 4 PK 12 2016   grade_4                                                   48.0                                             48
108857 HI     school 1500030 1   Hawaii Department of Education 150003000246 103 ANUENUE   Regular School No 4 PK 12 2016   grade_5                                                   30.0                                             30
109147 HI     school 1500030 1   Hawaii Department of Education 150003000246 103 ANUENUE   Regular School No 4 PK 12 2016   grade_6                                                   23.0                                             23
109437 HI     school 1500030 1   Hawaii Department of Education 150003000246 103 ANUENUE   Regular School No 4 PK 12 2016   grade_7                                                   34.0                                             34
109727 HI     school 1500030 1   Hawaii Department of Education 150003000246 103 ANUENUE   Regular School No 4 PK 12 2016   grade_8                                                   31.0                                             31
110017 HI     school 1500030 1   Hawaii Department of Education 150003000246 103 ANUENUE   Regular School No 4 PK 12 2016   grade_9                                                   20.0                                             20
110307 HI     school 1500030 1   Hawaii Department of Education 150003000246 103 ANUENUE   Regular School No 4 PK 12 2016   grade_10                                                   13.0                                             13
110597 HI     school 1500030 1   Hawaii Department of Education 150003000246 103 ANUENUE   Regular School No 4 PK 12 2016   grade_11                                                   11.0                                             11
110887 HI     school 1500030 1   Hawaii Department of Education 150003000246 103 ANUENUE   Regular School No 4 PK 12 2016   grade_12                                                   15.0                                             15
111177 HI     school 1500030 1   Hawaii Department of Education 150003000246 103 ANUENUE   Regular School No 4 PK 12 2016   pre_kindergarten                                                   0.0                                             0
111467 HI     school 1500030 1   Hawaii Department of Education 150003000246 103 ANUENUE   Regular School No 4 PK 12 2016   pk_12_total                                               29.0   421.0                                         29   421
107408 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 CENTRAL MID   Regular School No 2 06 8 2016   kindergarten                                                   0.0                                             0
107698 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 CENTRAL MID   Regular School No 2 06 8 2016   grade_1                                                   0.0                                             0
107988 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 CENTRAL MID   Regular School No 2 06 8 2016   grade_2                                                   0.0                                             0
108278 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 CENTRAL MID   Regular School No 2 06 8 2016   grade_3                                                   0.0                                             0
108568 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 CENTRAL MID   Regular School No 2 06 8 2016   grade_4                                                   0.0                                             0
108858 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 CENTRAL MID   Regular School No 2 06 8 2016   grade_5                                                   0.0                                             0
109148 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 CENTRAL MID   Regular School No 2 06 8 2016   grade_6                                                   126.0                                             126
109438 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 CENTRAL MID   Regular School No 2 06 8 2016   grade_7                                                   115.0                                             115
109728 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 CENTRAL MID   Regular School No 2 06 8 2016   grade_8                                                   106.0                                             106
110018 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 CENTRAL MID   Regular School No 2 06 8 2016   grade_9                                                   0.0                                             0
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
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
110888 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 CENTRAL MID   Regular School No 2 06 8 2016   grade_12                                                   0.0                                             0
111178 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 CENTRAL MID   Regular School No 2 06 8 2016   pre_kindergarten                                                   0.0                                             0
111468 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 CENTRAL MID   Regular School No 2 06 8 2016   pk_12_total                                               51.0   398.0                                         51   398
107381 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 DOLE MID   Regular School No 2 06 8 2016   kindergarten                                                   0.0                                             0
107671 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 DOLE MID   Regular School No 2 06 8 2016   grade_1                                                   0.0                                             0
107961 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 DOLE MID   Regular School No 2 06 8 2016   grade_2                                                   0.0                                             0
108251 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 DOLE MID   Regular School No 2 06 8 2016   grade_3                                                   0.0                                             0
108541 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 DOLE MID   Regular School No 2 06 8 2016   grade_4                                                   0.0                                             0
108831 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 DOLE MID   Regular School No 2 06 8 2016   grade_5                                                   0.0                                             0
109121 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 DOLE MID   Regular School No 2 06 8 2016   grade_6                                                   260.0                                             260
109411 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 DOLE MID   Regular School No 2 06 8 2016   grade_7                                                   239.0                                             239
109701 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 DOLE MID   Regular School No 2 06 8 2016   grade_8                                                   225.0                                             225
109991 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 DOLE MID   Regular School No 2 06 8 2016   grade_9                                                   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
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
110861 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 DOLE MID   Regular School No 2 06 8 2016   grade_12                                                   0.0                                             0
111151 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 DOLE MID   Regular School No 2 06 8 2016   pre_kindergarten                                                   0.0                                             0
111441 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 DOLE MID   Regular School No 2 06 8 2016   pk_12_total                                               76.0   800.0                                         76   800
107382 HI     school 1500030 1   Hawaii Department of Education 150003000221 106 FARRINGTON HI   Regular School No 3 09 12 2016   kindergarten                                                   0.0                                             0
107672 HI     school 1500030 1   Hawaii Department of Education 150003000221 106 FARRINGTON HI   Regular School No 3 09 12 2016   grade_1                                                   0.0                                             0
107962 HI     school 1500030 1   Hawaii Department of Education 150003000221 106 FARRINGTON HI   Regular School No 3 09 12 2016   grade_2                                                   0.0                                             0
108252 HI     school 1500030 1   Hawaii Department of Education 150003000221 106 FARRINGTON HI   Regular School No 3 09 12 2016   grade_3                                                   0.0                                             0
108542 HI     school 1500030 1   Hawaii Department of Education 150003000221 106 FARRINGTON HI   Regular School No 3 09 12 2016   grade_4                                                   0.0                                             0
108832 HI     school 1500030 1   Hawaii Department of Education 150003000221 106 FARRINGTON HI   Regular School No 3 09 12 2016   grade_5                                                   0.0                                             0
109122 HI     school 1500030 1   Hawaii Department of Education 150003000221 106 FARRINGTON HI   Regular School No 3 09 12 2016   grade_6                                                   0.0                                             0
109412 HI     school 1500030 1   Hawaii Department of Education 150003000221 106 FARRINGTON HI   Regular School No 3 09 12 2016   grade_7                                                   0.0                                             0
109702 HI     school 1500030 1   Hawaii Department of Education 150003000221 106 FARRINGTON HI   Regular School No 3 09 12 2016   grade_8                                                   0.0                                             0
109992 HI     school 1500030 1   Hawaii Department of Education 150003000221 106 FARRINGTON HI   Regular School No 3 09 12 2016   grade_9                                                   607.0                                             607
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