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
126408 HI     school 1500030 1   Hawaii Department of Education 150003000226 101 ALA WAI   Regular School No Elementary PK 5 2017   kindergarten                                                   62.0                                             62
126698 HI     school 1500030 1   Hawaii Department of Education 150003000226 101 ALA WAI   Regular School No Elementary PK 5 2017   grade_1                                                   70.0                                             70
126988 HI     school 1500030 1   Hawaii Department of Education 150003000226 101 ALA WAI   Regular School No Elementary PK 5 2017   grade_2                                                   38.0                                             38
127278 HI     school 1500030 1   Hawaii Department of Education 150003000226 101 ALA WAI   Regular School No Elementary PK 5 2017   grade_3                                                   71.0                                             71
127568 HI     school 1500030 1   Hawaii Department of Education 150003000226 101 ALA WAI   Regular School No Elementary PK 5 2017   grade_4                                                   65.0                                             65
127858 HI     school 1500030 1   Hawaii Department of Education 150003000226 101 ALA WAI   Regular School No Elementary PK 5 2017   grade_5                                                   64.0                                             64
128148 HI     school 1500030 1   Hawaii Department of Education 150003000226 101 ALA WAI   Regular School No Elementary PK 5 2017   grade_6                                                   0.0                                             0
128438 HI     school 1500030 1   Hawaii Department of Education 150003000226 101 ALA WAI   Regular School No Elementary PK 5 2017   grade_7                                                   0.0                                             0
128728 HI     school 1500030 1   Hawaii Department of Education 150003000226 101 ALA WAI   Regular School No Elementary PK 5 2017   grade_8                                                   0.0                                             0
129018 HI     school 1500030 1   Hawaii Department of Education 150003000226 101 ALA WAI   Regular School No Elementary PK 5 2017   grade_9                                                   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
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
129888 HI     school 1500030 1   Hawaii Department of Education 150003000226 101 ALA WAI   Regular School No Elementary PK 5 2017   grade_12                                                   0.0                                             0
130178 HI     school 1500030 1   Hawaii Department of Education 150003000226 101 ALA WAI   Regular School No Elementary PK 5 2017   pre_kindergarten                                                   10.0                                             10
130468 HI     school 1500030 1   Hawaii Department of Education 150003000226 101 ALA WAI   Regular School No Elementary PK 5 2017   pk_12_total                                               33.0   413.0                                         33   413
126409 HI     school 1500030 1   Hawaii Department of Education 150003000225 102 ALIIOLANI   Regular School No Elementary PK 5 2017   kindergarten                                                   31.0                                             31
126699 HI     school 1500030 1   Hawaii Department of Education 150003000225 102 ALIIOLANI   Regular School No Elementary PK 5 2017   grade_1                                                   38.0                                             38
126989 HI     school 1500030 1   Hawaii Department of Education 150003000225 102 ALIIOLANI   Regular School No Elementary PK 5 2017   grade_2                                                   19.0                                             19
127279 HI     school 1500030 1   Hawaii Department of Education 150003000225 102 ALIIOLANI   Regular School No Elementary PK 5 2017   grade_3                                                   36.0                                             36
127569 HI     school 1500030 1   Hawaii Department of Education 150003000225 102 ALIIOLANI   Regular School No Elementary PK 5 2017   grade_4                                                   35.0                                             35
127859 HI     school 1500030 1   Hawaii Department of Education 150003000225 102 ALIIOLANI   Regular School No Elementary PK 5 2017   grade_5                                                   27.0                                             27
128149 HI     school 1500030 1   Hawaii Department of Education 150003000225 102 ALIIOLANI   Regular School No Elementary PK 5 2017   grade_6                                                   0.0                                             0
128439 HI     school 1500030 1   Hawaii Department of Education 150003000225 102 ALIIOLANI   Regular School No Elementary PK 5 2017   grade_7                                                   0.0                                             0
128729 HI     school 1500030 1   Hawaii Department of Education 150003000225 102 ALIIOLANI   Regular School No Elementary PK 5 2017   grade_8                                                   0.0                                             0
129019 HI     school 1500030 1   Hawaii Department of Education 150003000225 102 ALIIOLANI   Regular School No Elementary PK 5 2017   grade_9                                                   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
129599 HI     school 1500030 1   Hawaii Department of Education 150003000225 102 ALIIOLANI   Regular School No Elementary PK 5 2017   grade_11                                                   0.0                                             0
129889 HI     school 1500030 1   Hawaii Department of Education 150003000225 102 ALIIOLANI   Regular School No Elementary PK 5 2017   grade_12                                                   0.0                                             0
130179 HI     school 1500030 1   Hawaii Department of Education 150003000225 102 ALIIOLANI   Regular School No Elementary PK 5 2017   pre_kindergarten                                                   7.0                                             7
130469 HI     school 1500030 1   Hawaii Department of Education 150003000225 102 ALIIOLANI   Regular School No Elementary PK 5 2017   pk_12_total                                               23.0   216.0                                         23   216
126410 HI     school 1500030 1   Hawaii Department of Education 150003000246 103 ANUENUE   Regular School No Other PK 12 2017   kindergarten                                                   54.0                                             54
126700 HI     school 1500030 1   Hawaii Department of Education 150003000246 103 ANUENUE   Regular School No Other PK 12 2017   grade_1                                                   50.0                                             50
126990 HI     school 1500030 1   Hawaii Department of Education 150003000246 103 ANUENUE   Regular School No Other PK 12 2017   grade_2                                                   30.0                                             30
127280 HI     school 1500030 1   Hawaii Department of Education 150003000246 103 ANUENUE   Regular School No Other PK 12 2017   grade_3                                                   48.0                                             48
127570 HI     school 1500030 1   Hawaii Department of Education 150003000246 103 ANUENUE   Regular School No Other PK 12 2017   grade_4                                                   35.0                                             35
127860 HI     school 1500030 1   Hawaii Department of Education 150003000246 103 ANUENUE   Regular School No Other PK 12 2017   grade_5                                                   43.0                                             43
128150 HI     school 1500030 1   Hawaii Department of Education 150003000246 103 ANUENUE   Regular School No Other PK 12 2017   grade_6                                                   32.0                                             32
128440 HI     school 1500030 1   Hawaii Department of Education 150003000246 103 ANUENUE   Regular School No Other PK 12 2017   grade_7                                                   28.0                                             28
128730 HI     school 1500030 1   Hawaii Department of Education 150003000246 103 ANUENUE   Regular School No Other PK 12 2017   grade_8                                                   30.0                                             30
129020 HI     school 1500030 1   Hawaii Department of Education 150003000246 103 ANUENUE   Regular School No Other PK 12 2017   grade_9                                                   24.0                                             24
129310 HI     school 1500030 1   Hawaii Department of Education 150003000246 103 ANUENUE   Regular School No Other PK 12 2017   grade_10                                                   16.0                                             16
129600 HI     school 1500030 1   Hawaii Department of Education 150003000246 103 ANUENUE   Regular School No Other PK 12 2017   grade_11                                                   12.0                                             12
129890 HI     school 1500030 1   Hawaii Department of Education 150003000246 103 ANUENUE   Regular School No Other PK 12 2017   grade_12                                                   10.0                                             10
130180 HI     school 1500030 1   Hawaii Department of Education 150003000246 103 ANUENUE   Regular School No Other PK 12 2017   pre_kindergarten                                                   0.0                                             0
130470 HI     school 1500030 1   Hawaii Department of Education 150003000246 103 ANUENUE   Regular School No Other PK 12 2017   pk_12_total                                               23.0   435.0                                         23   435
126411 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 CENTRAL MID   Regular School No Middle 06 8 2017   kindergarten                                                   0.0                                             0
126701 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 CENTRAL MID   Regular School No Middle 06 8 2017   grade_1                                                   0.0                                             0
126991 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 CENTRAL MID   Regular School No Middle 06 8 2017   grade_2                                                   0.0                                             0
127281 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 CENTRAL MID   Regular School No Middle 06 8 2017   grade_3                                                   0.0                                             0
127571 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 CENTRAL MID   Regular School No Middle 06 8 2017   grade_4                                                   0.0                                             0
127861 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 CENTRAL MID   Regular School No Middle 06 8 2017   grade_5                                                   0.0                                             0
128151 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 CENTRAL MID   Regular School No Middle 06 8 2017   grade_6                                                   138.0                                             138
128441 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 CENTRAL MID   Regular School No Middle 06 8 2017   grade_7                                                   113.0                                             113
128731 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 CENTRAL MID   Regular School No Middle 06 8 2017   grade_8                                                   118.0                                             118
129021 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 CENTRAL MID   Regular School No Middle 06 8 2017   grade_9                                                   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
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
129891 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 CENTRAL MID   Regular School No Middle 06 8 2017   grade_12                                                   0.0                                             0
130181 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 CENTRAL MID   Regular School No Middle 06 8 2017   pre_kindergarten                                                   0.0                                             0
130471 HI     school 1500030 1   Hawaii Department of Education 150003000223 104 CENTRAL MID   Regular School No Middle 06 8 2017   pk_12_total                                               60.0   429.0                                         60   429
126384 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 DOLE MID   Regular School No Middle 06 8 2017   kindergarten                                                   0.0                                             0
126674 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 DOLE MID   Regular School No Middle 06 8 2017   grade_1                                                   0.0                                             0
126964 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 DOLE MID   Regular School No Middle 06 8 2017   grade_2                                                   0.0                                             0
127254 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 DOLE MID   Regular School No Middle 06 8 2017   grade_3                                                   0.0                                             0
127544 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 DOLE MID   Regular School No Middle 06 8 2017   grade_4                                                   0.0                                             0
127834 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 DOLE MID   Regular School No Middle 06 8 2017   grade_5                                                   0.0                                             0
128124 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 DOLE MID   Regular School No Middle 06 8 2017   grade_6                                                   258.0                                             258
128414 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 DOLE MID   Regular School No Middle 06 8 2017   grade_7                                                   255.0                                             255
128704 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 DOLE MID   Regular School No Middle 06 8 2017   grade_8                                                   201.0                                             201
128994 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 DOLE MID   Regular School No Middle 06 8 2017   grade_9                                                   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
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
129864 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 DOLE MID   Regular School No Middle 06 8 2017   grade_12                                                   0.0                                             0
130154 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 DOLE MID   Regular School No Middle 06 8 2017   pre_kindergarten                                                   0.0                                             0
130444 HI     school 1500030 1   Hawaii Department of Education 150003000222 105 DOLE MID   Regular School No Middle 06 8 2017   pk_12_total                                               81.0   795.0                                         81   795
126385 HI     school 1500030 1   Hawaii Department of Education 150003000221 106 FARRINGTON HI   Regular School No High 09 12 2017   kindergarten                                                   0.0                                             0
126675 HI     school 1500030 1   Hawaii Department of Education 150003000221 106 FARRINGTON HI   Regular School No High 09 12 2017   grade_1                                                   0.0                                             0
126965 HI     school 1500030 1   Hawaii Department of Education 150003000221 106 FARRINGTON HI   Regular School No High 09 12 2017   grade_2                                                   0.0                                             0
127255 HI     school 1500030 1   Hawaii Department of Education 150003000221 106 FARRINGTON HI   Regular School No High 09 12 2017   grade_3                                                   0.0                                             0
127545 HI     school 1500030 1   Hawaii Department of Education 150003000221 106 FARRINGTON HI   Regular School No High 09 12 2017   grade_4                                                   0.0                                             0
127835 HI     school 1500030 1   Hawaii Department of Education 150003000221 106 FARRINGTON HI   Regular School No High 09 12 2017   grade_5                                                   0.0                                             0
128125 HI     school 1500030 1   Hawaii Department of Education 150003000221 106 FARRINGTON HI   Regular School No High 09 12 2017   grade_6                                                   0.0                                             0
128415 HI     school 1500030 1   Hawaii Department of Education 150003000221 106 FARRINGTON HI   Regular School No High 09 12 2017   grade_7                                                   0.0                                             0
128705 HI     school 1500030 1   Hawaii Department of Education 150003000221 106 FARRINGTON HI   Regular School No High 09 12 2017   grade_8                                                   0.0                                             0
128995 HI     school 1500030 1   Hawaii Department of Education 150003000221 106 FARRINGTON HI   Regular School No High 09 12 2017   grade_9                                                   645.0                                             645
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
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
129865 HI     school 1500030 1   Hawaii Department of Education 150003000221 106 FARRINGTON HI   Regular School No High 09 12 2017   grade_12                                                   448.0                                             448
130155 HI     school 1500030 1   Hawaii Department of Education 150003000221 106 FARRINGTON HI   Regular School No High 09 12 2017   pre_kindergarten                                                   0.0                                             0
130445 HI     school 1500030 1   Hawaii Department of Education 150003000221 106 FARRINGTON HI   Regular School No High 09 12 2017   pk_12_total                                               255.0   2370.0                                         255   2370
126386 HI     school 1500030 1   Hawaii Department of Education 150003000220 107 FERN   Regular School No Elementary PK 5 2017   kindergarten                                                   39.0                                             39
126676 HI     school 1500030 1   Hawaii Department of Education 150003000220 107 FERN   Regular School No Elementary PK 5 2017   grade_1                                                   55.0                                             55
126966 HI     school 1500030 1   Hawaii Department of Education 150003000220 107 FERN   Regular School No Elementary PK 5 2017   grade_2                                                   65.0                                             65
127256 HI     school 1500030 1   Hawaii Department of Education 150003000220 107 FERN   Regular School No Elementary PK 5 2017   grade_3                                                   88.0                                             88
127546 HI     school 1500030 1   Hawaii Department of Education 150003000220 107 FERN   Regular School No Elementary PK 5 2017   grade_4                                                   87.0                                             87
127836 HI     school 1500030 1   Hawaii Department of Education 150003000220 107 FERN   Regular School No Elementary PK 5 2017   grade_5                                                   85.0                                             85
128126 HI     school 1500030 1   Hawaii Department of Education 150003000220 107 FERN   Regular School No Elementary PK 5 2017   grade_6                                                   0.0                                             0
128416 HI     school 1500030 1   Hawaii Department of Education 150003000220 107 FERN   Regular School No Elementary PK 5 2017   grade_7                                                   0.0                                             0
128706 HI     school 1500030 1   Hawaii Department of Education 150003000220 107 FERN   Regular School No Elementary PK 5 2017   grade_8                                                   0.0                                             0
128996 HI     school 1500030 1   Hawaii Department of Education 150003000220 107 FERN   Regular School No Elementary PK 5 2017   grade_9                                                   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