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
1738116 AK     school 200004 54   Yupiit Schools 20000400624 540030 Akiak School   Regular School No Other KG 12.0 2020   grade_1 0.0                                                 10 0                                           10
1738117 AK     school 200004 54   Yupiit Schools 20000400624 540030 Akiak School   Regular School No Other KG 12.0 2020   grade_10 0.0                                                 9 0                                           9
1738118 AK     school 200004 54   Yupiit Schools 20000400624 540030 Akiak School   Regular School No Other KG 12.0 2020   grade_11 0.0                                                 8 0                                           8
1738119 AK     school 200004 54   Yupiit Schools 20000400624 540030 Akiak School   Regular School No Other KG 12.0 2020   grade_12 0.0                                                 9 0                                           9
1738120 AK     school 200004 54   Yupiit Schools 20000400624 540030 Akiak School   Regular School No Other KG 12.0 2020   grade_2 0.0                                                 10 0                                           10
1738121 AK     school 200004 54   Yupiit Schools 20000400624 540030 Akiak School   Regular School No Other KG 12.0 2020   grade_3 0.0                                                 11 0                                           11
1738122 AK     school 200004 54   Yupiit Schools 20000400624 540030 Akiak School   Regular School No Other KG 12.0 2020   grade_4 0.0                                                 11 0                                           11
1738123 AK     school 200004 54   Yupiit Schools 20000400624 540030 Akiak School   Regular School No Other KG 12.0 2020   grade_5 0.0                                                 8 0                                           8
1738124 AK     school 200004 54   Yupiit Schools 20000400624 540030 Akiak School   Regular School No Other KG 12.0 2020   grade_6 0.0                                                 11 0                                           11
1738125 AK     school 200004 54   Yupiit Schools 20000400624 540030 Akiak School   Regular School No Other KG 12.0 2020   grade_7 0.0                                                 8 0                                           8
1738126 AK     school 200004 54   Yupiit Schools 20000400624 540030 Akiak School   Regular School No Other KG 12.0 2020   grade_8 0.0                                                 7 0                                           7
1738127 AK     school 200004 54   Yupiit Schools 20000400624 540030 Akiak School   Regular School No Other KG 12.0 2020   grade_9 0.0                                                 11 0                                           11
1738128 AK     school 200004 54   Yupiit Schools 20000400624 540030 Akiak School   Regular School No Other KG 12.0 2020   k_12_total 1.0                                                 131 1                                           131
1738129 AK     school 200004 54   Yupiit Schools 20000400624 540030 Akiak School   Regular School No Other KG 12.0 2020   kindergarten 1.0                                                 18 1                                           18
1738130 AK     school 200004 54   Yupiit Schools 20000400624 540030 Akiak School   Regular School No Other KG 12.0 2020   pk_12_total 1.0                                                 131 1                                           131
1738131 AK     school 200004 54   Yupiit Schools 20000400624 540030 Akiak School   Regular School No Other KG 12.0 2020   pre_kindergarten 0.0                                                 0 0                                           0
1738132 AK     school 200004 54   Yupiit Schools 20000400623 540040 Tuluksak School   Regular School No Other KG 12.0 2020   grade_1                                                   12                                             12
1738133 AK     school 200004 54   Yupiit Schools 20000400623 540040 Tuluksak School   Regular School No Other KG 12.0 2020   grade_10                                                   12                                             12
1738134 AK     school 200004 54   Yupiit Schools 20000400623 540040 Tuluksak School   Regular School No Other KG 12.0 2020   grade_11                                                   4                                             4
1738135 AK     school 200004 54   Yupiit Schools 20000400623 540040 Tuluksak School   Regular School No Other KG 12.0 2020   grade_12                                                   9                                             9
1738136 AK     school 200004 54   Yupiit Schools 20000400623 540040 Tuluksak School   Regular School No Other KG 12.0 2020   grade_2                                                   6                                             6
1738137 AK     school 200004 54   Yupiit Schools 20000400623 540040 Tuluksak School   Regular School No Other KG 12.0 2020   grade_3                                                   12                                             12
1738138 AK     school 200004 54   Yupiit Schools 20000400623 540040 Tuluksak School   Regular School No Other KG 12.0 2020   grade_4                                                   9                                             9
1738139 AK     school 200004 54   Yupiit Schools 20000400623 540040 Tuluksak School   Regular School No Other KG 12.0 2020   grade_5                                                   8                                             8
1738140 AK     school 200004 54   Yupiit Schools 20000400623 540040 Tuluksak School   Regular School No Other KG 12.0 2020   grade_6                                                   8                                             8
1738141 AK     school 200004 54   Yupiit Schools 20000400623 540040 Tuluksak School   Regular School No Other KG 12.0 2020   grade_7                                                   12                                             12
1738142 AK     school 200004 54   Yupiit Schools 20000400623 540040 Tuluksak School   Regular School No Other KG 12.0 2020   grade_8                                                   6                                             6
1738143 AK     school 200004 54   Yupiit Schools 20000400623 540040 Tuluksak School   Regular School No Other KG 12.0 2020   grade_9                                                   7                                             7
1738144 AK     school 200004 54   Yupiit Schools 20000400623 540040 Tuluksak School   Regular School No Other KG 12.0 2020   k_12_total                                                   119                                             119
1738145 AK     school 200004 54   Yupiit Schools 20000400623 540040 Tuluksak School   Regular School No Other KG 12.0 2020   kindergarten                                                   14                                             14
1738146 AK     school 200004 54   Yupiit Schools 20000400623 540040 Tuluksak School   Regular School No Other KG 12.0 2020   pk_12_total                                                   119                                             119
1738147 AK     school 200004 54   Yupiit Schools 20000400623 540040 Tuluksak School   Regular School No Other KG 12.0 2020   pre_kindergarten                                                   0                                             0
1738148 AK     school   54   Yupiit Schools   548010 Akiachak School             2020   grade_1 0.0                   0.0                             15 0                   0                       15
1738149 AK     school   54   Yupiit Schools   548010 Akiachak School             2020   grade_10 0.0                   0.0                             14 0                   0                       14
1738150 AK     school   54   Yupiit Schools   548010 Akiachak School             2020   grade_11 0.0                   0.0                             10 0                   0                       10
1738151 AK     school   54   Yupiit Schools   548010 Akiachak School             2020   grade_12 1.0                   0.0                             15 1                   0                       15
1738152 AK     school   54   Yupiit Schools   548010 Akiachak School             2020   grade_2 0.0                   0.0                             24 0                   0                       24
1738153 AK     school   54   Yupiit Schools   548010 Akiachak School             2020   grade_3 0.0                   0.0                             12 0                   0                       12
1738154 AK     school   54   Yupiit Schools   548010 Akiachak School             2020   grade_4 0.0                   1.0                             22 0                   1                       22
1738155 AK     school   54   Yupiit Schools   548010 Akiachak School             2020   grade_5 0.0                   0.0                             24 0                   0                       24
1738156 AK     school   54   Yupiit Schools   548010 Akiachak School             2020   grade_6 0.0                   0.0                             10 0                   0                       10
1738157 AK     school   54   Yupiit Schools   548010 Akiachak School             2020   grade_7 0.0                   0.0                             15 0                   0                       15
1738158 AK     school   54   Yupiit Schools   548010 Akiachak School             2020   grade_8 0.0                   0.0                             9 0                   0                       9
1738159 AK     school   54   Yupiit Schools   548010 Akiachak School             2020   grade_9 0.0                   0.0                             16 0                   0                       16
1738160 AK     school   54   Yupiit Schools   548010 Akiachak School             2020   k_12_total 1.0                   2.0                             213 1                   2                       213
1738161 AK     school   54   Yupiit Schools   548010 Akiachak School             2020   kindergarten 0.0                   1.0                             27 0                   1                       27
1738162 AK     school   54   Yupiit Schools   548010 Akiachak School             2020   pk_12_total 1.0                   2.0                             213 1                   2                       213
1738163 AK     school   54   Yupiit Schools   548010 Akiachak School             2020   pre_kindergarten 0.0                   0.0                             0 0                   0                       0
1737940 AK     school 200862 52   Yukon-Koyukuk Schools 20086200377 520010 Allakaket School   Regular School No Other PK 12.0 2020   grade_1 1.0                                                 7 1                                           7
1737941 AK     school 200862 52   Yukon-Koyukuk Schools 20086200377 520010 Allakaket School   Regular School No Other PK 12.0 2020   grade_10 0.0                                                 0 0                                           0
1737942 AK     school 200862 52   Yukon-Koyukuk Schools 20086200377 520010 Allakaket School   Regular School No Other PK 12.0 2020   grade_11 0.0                                                 0 0                                           0
1737943 AK     school 200862 52   Yukon-Koyukuk Schools 20086200377 520010 Allakaket School   Regular School No Other PK 12.0 2020   grade_12 0.0                                                 1 0                                           1
1737944 AK     school 200862 52   Yukon-Koyukuk Schools 20086200377 520010 Allakaket School   Regular School No Other PK 12.0 2020   grade_2 0.0                                                 3 0                                           3
1737945 AK     school 200862 52   Yukon-Koyukuk Schools 20086200377 520010 Allakaket School   Regular School No Other PK 12.0 2020   grade_3 0.0                                                 3 0                                           3
1737946 AK     school 200862 52   Yukon-Koyukuk Schools 20086200377 520010 Allakaket School   Regular School No Other PK 12.0 2020   grade_4 0.0                                                 2 0                                           2
1737947 AK     school 200862 52   Yukon-Koyukuk Schools 20086200377 520010 Allakaket School   Regular School No Other PK 12.0 2020   grade_5 0.0                                                 3 0                                           3
1737948 AK     school 200862 52   Yukon-Koyukuk Schools 20086200377 520010 Allakaket School   Regular School No Other PK 12.0 2020   grade_6 0.0                                                 4 0                                           4
1737949 AK     school 200862 52   Yukon-Koyukuk Schools 20086200377 520010 Allakaket School   Regular School No Other PK 12.0 2020   grade_7 0.0                                                 1 0                                           1
1737950 AK     school 200862 52   Yukon-Koyukuk Schools 20086200377 520010 Allakaket School   Regular School No Other PK 12.0 2020   grade_8 0.0                                                 4 0                                           4
1737951 AK     school 200862 52   Yukon-Koyukuk Schools 20086200377 520010 Allakaket School   Regular School No Other PK 12.0 2020   grade_9 0.0                                                 0 0                                           0
1737952 AK     school 200862 52   Yukon-Koyukuk Schools 20086200377 520010 Allakaket School   Regular School No Other PK 12.0 2020   k_12_total 1.0                                                 29 1                                           29
1737953 AK     school 200862 52   Yukon-Koyukuk Schools 20086200377 520010 Allakaket School   Regular School No Other PK 12.0 2020   kindergarten 0.0                                                 1 0                                           1
1737954 AK     school 200862 52   Yukon-Koyukuk Schools 20086200377 520010 Allakaket School   Regular School No Other PK 12.0 2020   pk_12_total 1.0                                                 32 1                                           32
1737955 AK     school 200862 52   Yukon-Koyukuk Schools 20086200377 520010 Allakaket School   Regular School No Other PK 12.0 2020   pre_kindergarten 0.0                                                 3 0                                           3
1737956 AK     school 200862 52   Yukon-Koyukuk Schools 20086200379 520030 Johnny Oldman School   Regular School No Other PK 12.0 2020   grade_1 0.0                                                 0 0                                           0
1737957 AK     school 200862 52   Yukon-Koyukuk Schools 20086200379 520030 Johnny Oldman School   Regular School No Other PK 12.0 2020   grade_10 0.0                                                 0 0                                           0
1737958 AK     school 200862 52   Yukon-Koyukuk Schools 20086200379 520030 Johnny Oldman School   Regular School No Other PK 12.0 2020   grade_11 0.0                                                 0 0                                           0
1737959 AK     school 200862 52   Yukon-Koyukuk Schools 20086200379 520030 Johnny Oldman School   Regular School No Other PK 12.0 2020   grade_12 0.0                                                 0 0                                           0
1737960 AK     school 200862 52   Yukon-Koyukuk Schools 20086200379 520030 Johnny Oldman School   Regular School No Other PK 12.0 2020   grade_2 1.0                                                 4 1                                           4
1737961 AK     school 200862 52   Yukon-Koyukuk Schools 20086200379 520030 Johnny Oldman School   Regular School No Other PK 12.0 2020   grade_3 0.0                                                 0 0                                           0
1737962 AK     school 200862 52   Yukon-Koyukuk Schools 20086200379 520030 Johnny Oldman School   Regular School No Other PK 12.0 2020   grade_4 0.0                                                 2 0                                           2
1737963 AK     school 200862 52   Yukon-Koyukuk Schools 20086200379 520030 Johnny Oldman School   Regular School No Other PK 12.0 2020   grade_5 1.0                                                 4 1                                           4
1737964 AK     school 200862 52   Yukon-Koyukuk Schools 20086200379 520030 Johnny Oldman School   Regular School No Other PK 12.0 2020   grade_6 0.0                                                 0 0                                           0
1737965 AK     school 200862 52   Yukon-Koyukuk Schools 20086200379 520030 Johnny Oldman School   Regular School No Other PK 12.0 2020   grade_7 0.0                                                 1 0                                           1
1737966 AK     school 200862 52   Yukon-Koyukuk Schools 20086200379 520030 Johnny Oldman School   Regular School No Other PK 12.0 2020   grade_8 0.0                                                 1 0                                           1
1737967 AK     school 200862 52   Yukon-Koyukuk Schools 20086200379 520030 Johnny Oldman School   Regular School No Other PK 12.0 2020   grade_9 0.0                                                 0 0                                           0
1737968 AK     school 200862 52   Yukon-Koyukuk Schools 20086200379 520030 Johnny Oldman School   Regular School No Other PK 12.0 2020   k_12_total 2.0                                                 17 2                                           17
1737969 AK     school 200862 52   Yukon-Koyukuk Schools 20086200379 520030 Johnny Oldman School   Regular School No Other PK 12.0 2020   kindergarten 0.0                                                 5 0                                           5
1737970 AK     school 200862 52   Yukon-Koyukuk Schools 20086200379 520030 Johnny Oldman School   Regular School No Other PK 12.0 2020   pk_12_total 2.0                                                 18 2                                           18
1737971 AK     school 200862 52   Yukon-Koyukuk Schools 20086200379 520030 Johnny Oldman School   Regular School No Other PK 12.0 2020   pre_kindergarten 0.0                                                 1 0                                           1
1737972 AK     school 200862 52   Yukon-Koyukuk Schools 20086200380 520040 Jimmy Huntington School   Regular School No Other PK 12.0 2020   grade_1 0.0     1.0             0.0                             11 0     1             0                       11
1737973 AK     school 200862 52   Yukon-Koyukuk Schools 20086200380 520040 Jimmy Huntington School   Regular School No Other PK 12.0 2020   grade_10 0.0     0.0             0.0                             6 0     0             0                       6
1737974 AK     school 200862 52   Yukon-Koyukuk Schools 20086200380 520040 Jimmy Huntington School   Regular School No Other PK 12.0 2020   grade_11 0.0     0.0             0.0                             1 0     0             0                       1
1737975 AK     school 200862 52   Yukon-Koyukuk Schools 20086200380 520040 Jimmy Huntington School   Regular School No Other PK 12.0 2020   grade_12 0.0     0.0             0.0                             1 0     0             0                       1
1737976 AK     school 200862 52   Yukon-Koyukuk Schools 20086200380 520040 Jimmy Huntington School   Regular School No Other PK 12.0 2020   grade_2 1.0     0.0             0.0                             5 1     0             0                       5
1737977 AK     school 200862 52   Yukon-Koyukuk Schools 20086200380 520040 Jimmy Huntington School   Regular School No Other PK 12.0 2020   grade_3 1.0     0.0             0.0                             8 1     0             0                       8
1737978 AK     school 200862 52   Yukon-Koyukuk Schools 20086200380 520040 Jimmy Huntington School   Regular School No Other PK 12.0 2020   grade_4 0.0     0.0             0.0                             8 0     0             0                       8
1737979 AK     school 200862 52   Yukon-Koyukuk Schools 20086200380 520040 Jimmy Huntington School   Regular School No Other PK 12.0 2020   grade_5 0.0     0.0             0.0                             12 0     0             0                       12
1737980 AK     school 200862 52   Yukon-Koyukuk Schools 20086200380 520040 Jimmy Huntington School   Regular School No Other PK 12.0 2020   grade_6 0.0     0.0             0.0                             7 0     0             0                       7
1737981 AK     school 200862 52   Yukon-Koyukuk Schools 20086200380 520040 Jimmy Huntington School   Regular School No Other PK 12.0 2020   grade_7 0.0     0.0             1.0                             8 0     0             1                       8
1737982 AK     school 200862 52   Yukon-Koyukuk Schools 20086200380 520040 Jimmy Huntington School   Regular School No Other PK 12.0 2020   grade_8 0.0     0.0             0.0                             4 0     0             0                       4
1737983 AK     school 200862 52   Yukon-Koyukuk Schools 20086200380 520040 Jimmy Huntington School   Regular School No Other PK 12.0 2020   grade_9 0.0     0.0             0.0                             2 0     0             0                       2
1737984 AK     school 200862 52   Yukon-Koyukuk Schools 20086200380 520040 Jimmy Huntington School   Regular School No Other PK 12.0 2020   k_12_total 2.0     3.0             2.0                             81 2     3             2                       81
1737985 AK     school 200862 52   Yukon-Koyukuk Schools 20086200380 520040 Jimmy Huntington School   Regular School No Other PK 12.0 2020   kindergarten 0.0     2.0             1.0                             8 0     2             1                       8
1737986 AK     school 200862 52   Yukon-Koyukuk Schools 20086200380 520040 Jimmy Huntington School   Regular School No Other PK 12.0 2020   pk_12_total 2.0     3.0             2.0                             83 2     3             2                       83
1737987 AK     school 200862 52   Yukon-Koyukuk Schools 20086200380 520040 Jimmy Huntington School   Regular School No Other PK 12.0 2020   pre_kindergarten 0.0     0.0             0.0                             2 0     0             0                       2
1737988 AK     school 200862 52   Yukon-Koyukuk Schools 20086200381 520050 Kaltag School   Regular School No Other PK 12.0 2020   grade_1                                                   3                                             3
1737989 AK     school 200862 52   Yukon-Koyukuk Schools 20086200381 520050 Kaltag School   Regular School No Other PK 12.0 2020   grade_10                                                   0                                             0
1737990 AK     school 200862 52   Yukon-Koyukuk Schools 20086200381 520050 Kaltag School   Regular School No Other PK 12.0 2020   grade_11                                                   1                                             1
1737991 AK     school 200862 52   Yukon-Koyukuk Schools 20086200381 520050 Kaltag School   Regular School No Other PK 12.0 2020   grade_12                                                   2                                             2
1737992 AK     school 200862 52   Yukon-Koyukuk Schools 20086200381 520050 Kaltag School   Regular School No Other PK 12.0 2020   grade_2                                                   3                                             3