Data source: Big Local News · About: Big Local

995 rows where grade = "pk_12_total" and state = "AK" sorted by district_state_id descending

View and edit SQL

year

grade

  • pk_12_total · 995
Link rowid state county county_state_id admin_level district_nces_id district_state_id ▲ district_state_type district school_nces_id school_state_id school school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ccd_school_high_grade year term grade white black hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
1738258 AK     school 200006 98   Mount Edgecumbe 20000600558 980000 Mt. Edgecumbe High School   Regular School No High 09 12.0 2020   pk_12_total 38.0     5.0   4.0     3.0   8.0                             431 38     5   4     3   8                       431
1820577 AK     school 200006 98   Mount Edgecumbe 20000600558 980000 Mt. Edgecumbe High School   Regular School No High 09 12 2021   pk_12_total 35.0   2.0 4.0   3.0     2.0   9.0                             374.0 35   2 4   3     2   9                       374
1732418 AK     school 200730 9   Chatham Schools 20073000342 90010 Angoon School   Regular School No Other PK 12.0 2020   pk_12_total 2.0                   3.0                             65 2                   3                       65
1732434 AK     school 200730 9   Chatham Schools 20073000344 90030 Gustavus School   Regular School No Other KG 12.0 2020   pk_12_total 52.0                                                 64 52                                           64
1732450 AK     school 200730 9   Chatham Schools 20073000490 90090 Klukwan School   Regular School No Other KG 12.0 2020   pk_12_total 4.0                   3.0                             14 4                   3                       14
1732466 AK     school 200730 9   Chatham Schools 20073000477 98010 Chatham Correspondence   Regular School No Other KG 12.0 2020   pk_12_total 5.0 5.0                                               10 5 5                                         10
1814737 AK     school 200730 9   Chatham Schools 20073000342 90010 Angoon School   Regular School No Other PK 12 2021   pk_12_total 1.0                   3.0                             67.0 1                   3                       67
1814753 AK     school 200730 9   Chatham Schools 20073000344 90030 Gustavus School   Regular School No Other KG 12 2021   pk_12_total 53.0 4.0                                               64.0 53 4                                         64
1814769 AK     school 200730 9   Chatham Schools 20073000490 90090 Klukwan School   Regular School No Other KG 12 2021   pk_12_total 4.0                   3.0                             13.0 4                   3                       13
1732370 AK     school 200030 8   Bristol Bay Borough Schools 20003000020 80010 Bristol Bay Middle/High School   Regular School No High 07 12.0 2020   pk_12_total 7.0 1.0 1.0     2.0         3.0                             45 7 1 1     2         3                       45
1732386 AK     school 200030 8   Bristol Bay Borough Schools 20003000626 80020 Naknek Elementary   Regular School No Elementary PK 6.0 2020   pk_12_total 9.0   3.0     2.0         7.0                             61 9   3     2         7                       61
1732402 AK     school 200030 8   Bristol Bay Borough Schools 20003000751 88010 Bristol Bay Correspondence   Regular School No Other KG 12.0 2020   pk_12_total 4.0                                                 7 4                                           7
1814689 AK     school 200030 8   Bristol Bay Borough Schools 20003000020 80010 Bristol Bay Middle/High School   Regular School No High 07 12 2021   pk_12_total 11.0         1.0     1.0   2.0                             45.0 11         1     1   2                       45
1814705 AK     school 200030 8   Bristol Bay Borough Schools 20003000626 80020 Naknek Elementary   Regular School No Elementary PK 6 2021   pk_12_total 9.0 1.0 4.0     2.0         5.0                             59.0 9 1 4     2         5                       59
1814721 AK     school 200030 8   Bristol Bay Borough Schools 20003000751 88010 Bristol Bay Correspondence   Regular School No Other KG 12 2021   pk_12_total 6.0                                                 18.0 6                                           18
1732130 AK     school 200020 7   Bering Strait Schools 20002000423 70010 Brevig Mission School   Regular School No Other PK 12.0 2020   pk_12_total                                                   154                                             154
1732146 AK     school 200020 7   Bering Strait Schools 20002000421 70040 Aniguiin School   Regular School No Other PK 12.0 2020   pk_12_total 2.0 2.0                                               127 2 2                                         127
1732162 AK     school 200020 7   Bering Strait Schools 20002000499 70050 Diomede School   Regular School No Other PK 12.0 2020   pk_12_total                                                   16                                             16
1732178 AK     school 200020 7   Bering Strait Schools 20002000422 70060 Martin L. Olson School   Regular School No Other PK 12.0 2020   pk_12_total 1.0                                                 47 1                                           47
1732194 AK     school 200020 7   Bering Strait Schools 20002000013 70070 Koyuk-Malimiut School   Regular School No Other PK 12.0 2020   pk_12_total                                                   91                                             91
1732210 AK     school 200020 7   Bering Strait Schools 20002000467 70080 Anthony A. Andrews School   Regular School No Other PK 12.0 2020   pk_12_total 2.0                                                 157 2                                           157
1732226 AK     school 200020 7   Bering Strait Schools 20002000466 70100 Shaktoolik School   Regular School No Other PK 12.0 2020   pk_12_total 2.0                                                 86 2                                           86
1732242 AK     school 200020 7   Bering Strait Schools 20002000015 70110 Shishmaref School   Regular School No Other PK 12.0 2020   pk_12_total                                                   188                                             188
1732258 AK     school 200020 7   Bering Strait Schools 20002000468 70120 Tukurngailnguq School   Regular School No Other PK 12.0 2020   pk_12_total 1.0 1.0                                               216 1 1                                         216
1732274 AK     school 200020 7   Bering Strait Schools 20002000016 70130 James C. Isabell School   Regular School No Other PK 12.0 2020   pk_12_total                                                   85                                             85
1732290 AK     school 200020 7   Bering Strait Schools 20002000018 70150 Wales School   Regular School No Other PK 12.0 2020   pk_12_total           2.0                                       52           2                                 52
1732306 AK     school 200020 7   Bering Strait Schools 20002000019 70160 White Mountain School   Regular School No Other PK 12.0 2020   pk_12_total                                                   54                                             54
1732322 AK     school 200020 7   Bering Strait Schools 20002000012 70180 Gambell School   Regular School No Other PK 12.0 2020   pk_12_total 1.0                                                 178 1                                           178
1732338 AK     school 200020 7   Bering Strait Schools 20002000014 70200 Hogarth Kingeekuk Sr. Memorial School   Regular School No Other PK 12.0 2020   pk_12_total                                                   250                                             250
1732354 AK     school 200020 7   Bering Strait Schools 20002000017 70260 Unalakleet School   Regular School No Other PK 12.0 2020   pk_12_total 10.0         1.0         2.0                             200 10         1         2                       200
1814449 AK     school 200020 7   Bering Strait Schools 20002000423 70010 Brevig Mission School   Regular School No Other PK 12 2021   pk_12_total 1.0                                                 158.0 1                                           158
1814465 AK     school 200020 7   Bering Strait Schools 20002000421 70040 Aniguiin School   Regular School No Other PK 12 2021   pk_12_total 2.0 2.0                                               120.0 2 2                                         120
1814481 AK     school 200020 7   Bering Strait Schools 20002000499 70050 Diomede School   Regular School No Other PK 12 2021   pk_12_total                                                   17.0                                             17
1814497 AK     school 200020 7   Bering Strait Schools 20002000422 70060 Martin L. Olson School   Regular School No Other PK 12 2021   pk_12_total 2.0                                                 48.0 2                                           48
1814513 AK     school 200020 7   Bering Strait Schools 20002000013 70070 Koyuk-Malimiut School   Regular School No Other PK 12 2021   pk_12_total                                                   93.0                                             93
1814529 AK     school 200020 7   Bering Strait Schools 20002000467 70080 Anthony A. Andrews School   Regular School No Other PK 12 2021   pk_12_total 2.0 2.0 1.0                                             150.0 2 2 1                                       150
1814545 AK     school 200020 7   Bering Strait Schools 20002000466 70100 Shaktoolik School   Regular School No Other PK 12 2021   pk_12_total 3.0                                                 81.0 3                                           81
1814561 AK     school 200020 7   Bering Strait Schools 20002000015 70110 Shishmaref School   Regular School No Other PK 12 2021   pk_12_total 1.0                                                 196.0 1                                           196
1814577 AK     school 200020 7   Bering Strait Schools 20002000468 70120 Tukurngailnguq School   Regular School No Other PK 12 2021   pk_12_total 3.0 1.0                                               202.0 3 1                                         202
1814593 AK     school 200020 7   Bering Strait Schools 20002000016 70130 James C. Isabell School   Regular School No Other PK 12 2021   pk_12_total                                                   81.0                                             81
1814609 AK     school 200020 7   Bering Strait Schools 20002000018 70150 Wales School   Regular School No Other PK 12 2021   pk_12_total           2.0                                       42.0           2                                 42
1814625 AK     school 200020 7   Bering Strait Schools 20002000019 70160 White Mountain School   Regular School No Other PK 12 2021   pk_12_total                                                   49.0                                             49
1814641 AK     school 200020 7   Bering Strait Schools 20002000012 70180 Gambell School   Regular School No Other PK 12 2021   pk_12_total 2.0                                                 167.0 2                                           167
1814657 AK     school 200020 7   Bering Strait Schools 20002000014 70200 Hogarth Kingeekuk Sr. Memorial School   Regular School No Other PK 12 2021   pk_12_total                                                   246.0                                             246
1814673 AK     school 200020 7   Bering Strait Schools 20002000017 70260 Unalakleet School   Regular School No Other PK 12 2021   pk_12_total 5.0   3.0               4.0                             189.0 5   3               4                       189
1732082 AK     school 200525 6   Annette Island Schools 20052500111 60020 Charles R. Leask Sr. Middle School   Regular School No Middle 06 8.0 2020   pk_12_total 5.0     1.0             5.0                             82 5     1             5                       82
1732098 AK     school 200525 6   Annette Island Schools 20052500250 60030 Richard Johnson Elementary   Regular School No Elementary PK 5.0 2020   pk_12_total 6.0                                                 160 6                                           160
1732114 AK     school 200525 6   Annette Island Schools 20052500648 60040 Metlakatla High School   Regular School No High 09 12.0 2020   pk_12_total 3.0                   1.0                             68 3                   1                       68
1814401 AK     school 200525 6   Annette Island Schools 20052500111 60020 Charles R. Leask Sr. Middle School   Regular School No Middle 06 8 2021   pk_12_total 2.0                   2.0                             88.0 2                   2                       88
1814417 AK     school 200525 6   Annette Island Schools 20052500250 60030 Richard Johnson Elementary   Regular School No Elementary PK 5 2021   pk_12_total 6.0     1.0                                           151.0 6     1                                     151
1814433 AK     school 200525 6   Annette Island Schools 20052500648 60040 Metlakatla High School   Regular School No High 09 12 2021   pk_12_total 1.0                   4.0                             77.0 1                   4                       77
1738194 AK     school 200007 56   Aleutians East Borough Schools 20000700177 560010 King Cove School   Regular School No Other PK 12.0 2020   pk_12_total 5.0   1.0 1.0   4.0                                       87 5   1 1   4                                 87
1738210 AK     school 200007 56   Aleutians East Borough Schools 20000700461 560020 Sand Point School   Regular School No Other PK 12.0 2020   pk_12_total 11.0   2.0     10.0     8.0   5.0                             120 11   2     10     8   5                       120
1738226 AK     school 200007 56   Aleutians East Borough Schools 20000700004 560030 Akutan School   Regular School No Other PK 12.0 2020   pk_12_total 2.0                   3.0                             20 2                   3                       20
1738242 AK     school 200007 56   Aleutians East Borough Schools 20000700007 560050 False Pass School   Regular School No Other PK 12.0 2020   pk_12_total 1.0                                                 7 1                                           7
1820513 AK     school 200007 56   Aleutians East Borough Schools 20000700177 560010 King Cove School   Regular School No Other PK 12 2021   pk_12_total 6.0         2.0                                       83.0 6         2                                 83
1820529 AK     school 200007 56   Aleutians East Borough Schools 20000700461 560020 Sand Point School   Regular School No Other PK 12 2021   pk_12_total 15.0   2.0     9.0     7.0   9.0                             117.0 15   2     9     7   9                       117
1820545 AK     school 200007 56   Aleutians East Borough Schools 20000700004 560030 Akutan School   Regular School No Other PK 12 2021   pk_12_total 1.0                   3.0                             17.0 1                   3                       17
1820561 AK     school 200007 56   Aleutians East Borough Schools 20000700007 560050 False Pass School   Regular School No Other PK 12 2021   pk_12_total 3.0                   1.0                             11.0 3                   1                       11
1738178 AK     school 200005 55   Kashunamiut Schools 20000500582 550010 Chevak School   Regular School No Other PK 12.0 2020   pk_12_total 2.0         2.0                                       313 2         2                                 313
1820497 AK     school 200005 55   Kashunamiut Schools 20000500582 550010 Chevak School   Regular School No Other PK 12 2021   pk_12_total 1.0                                                 332.0 1                                           332
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
1738146 AK     school 200004 54   Yupiit Schools 20000400623 540040 Tuluksak School   Regular School No Other KG 12.0 2020   pk_12_total                                                   119                                             119
1738162 AK     school   54   Yupiit Schools   548010 Akiachak School             2020   pk_12_total 1.0                   2.0                             213 1                   2                       213
1820449 AK     school 200004 54   Yupiit Schools 20000400624 540030 Akiak School   Regular School No Other KG 12 2021   pk_12_total 4.0                                                 148.0 4                                           148
1820465 AK     school 200004 54   Yupiit Schools 20000400623 540040 Tuluksak School   Regular School No Other KG 12 2021   pk_12_total   2.0                 2.0                             144.0   2                 2                       144
1820481 AK     school 200004 54   Yupiit Schools 20000400769 548010 Akiachak School   Regular School No High 07 12 2021   pk_12_total                     2.0                             214.0                     2                       214
1738114 AK     school 200715 53   Tanana Schools 20071500488 530010 Maudrey J. Sommer School   Regular School No Other KG 12.0 2020   pk_12_total 1.0                   4.0                             33 1                   4                       33
1820433 AK     school 200715 53   Tanana Schools 20071500488 530010 Maudrey J. Sommer School   Regular School No Other KG 12 2021   pk_12_total 1.0                   2.0                             30.0 1                   2                       30
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
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
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
1738002 AK     school 200862 52   Yukon-Koyukuk Schools 20086200381 520050 Kaltag School   Regular School No Other PK 12.0 2020   pk_12_total                                                   24                                             24
1738018 AK     school 200862 52   Yukon-Koyukuk Schools 20086200382 520060 Ella B. Vernetti School   Regular School No Elementary PK 8.0 2020   pk_12_total                                                   15                                             15
1738034 AK     school 200862 52   Yukon-Koyukuk Schools 20086200384 520080 Minto School   Regular School No Other PK 12.0 2020   pk_12_total 5.0                                                 48 5                                           48
1738050 AK     school 200862 52   Yukon-Koyukuk Schools 20086200385 520090 Andrew K. Demoski School   Regular School No Other PK 12.0 2020   pk_12_total 1.0     1.0   1.0                                       47 1     1   1                                 47
1738066 AK     school 200862 52   Yukon-Koyukuk Schools 20086200386 520110 Merreline A Kangas School   Regular School No Other PK 12.0 2020   pk_12_total 2.0     2.0                                           25 2     2                                     25
1738082 AK     school 200862 52   Yukon-Koyukuk Schools 20086200757 520120 Rampart School   Regular School No Other PK 12.0 2020   pk_12_total                                                   15                                             15
1738098 AK     school 200862 52   Yukon-Koyukuk Schools 20086200453 528010 Raven School   Regular School No Other PK 12.0 2020   pk_12_total 1141.0 36.0 71.0 41.0   23.0     25.0   127.0                             1695 1141 36 71 41   23     25   127                       1695
1820273 AK     school 200862 52   Yukon-Koyukuk Schools 20086200377 520010 Allakaket School   Regular School No Other PK 12 2021   pk_12_total           1.0                                       23.0           1                                 23
1820289 AK     school 200862 52   Yukon-Koyukuk Schools 20086200379 520030 Johnny Oldman School   Regular School No Other PK 12 2021   pk_12_total 2.0                                                 20.0 2                                           20
1820305 AK     school 200862 52   Yukon-Koyukuk Schools 20086200380 520040 Jimmy Huntington School   Regular School No Other PK 12 2021   pk_12_total 2.0     2.0                                           91.0 2     2                                     91
1820321 AK     school 200862 52   Yukon-Koyukuk Schools 20086200381 520050 Kaltag School   Regular School No Other PK 12 2021   pk_12_total                                                   26.0                                             26
1820337 AK     school 200862 52   Yukon-Koyukuk Schools 20086200382 520060 Ella B. Vernetti School   Regular School No Elementary PK 8 2021   pk_12_total                                                   14.0                                             14
1820353 AK     school 200862 52   Yukon-Koyukuk Schools 20086200384 520080 Minto School   Regular School No Other PK 12 2021   pk_12_total 3.0     1.0             1.0                             48.0 3     1             1                       48
1820369 AK     school 200862 52   Yukon-Koyukuk Schools 20086200385 520090 Andrew K. Demoski School   Regular School No Other PK 12 2021   pk_12_total           1.0                                       42.0           1                                 42
1820385 AK     school 200862 52   Yukon-Koyukuk Schools 20086200386 520110 Merreline A Kangas School   Regular School No Other PK 12 2021   pk_12_total 2.0     2.0                                           33.0 2     2                                     33
1820401 AK     school 200862 52   Yukon-Koyukuk Schools 20086200757 520120 Rampart School   Regular School No Other PK 12 2021   pk_12_total                                                   16.0                                             16
1820417 AK     school 200862 52   Yukon-Koyukuk Schools 20086200453 528010 Raven School   Regular School No Other PK 12 2021   pk_12_total 2500.0 108.0 205.0 67.0   68.0     79.0   450.0                             4035.0 2500 108 205 67   68     79   450                       4035
1737858 AK     school 200775 51   Yukon Flats Schools 20077500358 510010 Arctic Village School   Regular School No Other PK 12.0 2020   pk_12_total                                                   34                                             34
1737874 AK     school 200775 51   Yukon Flats Schools 20077500360 510040 Tsuk Taih School   Regular School No Other PK 12.0 2020   pk_12_total   1.0                                               11   1                                         11
1737890 AK     school 200775 51   Yukon Flats Schools 20077500361 510050 Circle School   Regular School No Other PK 12.0 2020   pk_12_total 1.0                                                 15 1                                           15
1737906 AK     school 200775 51   Yukon Flats Schools 20077500366 510060 John Fredson School   Regular School No Other PK 12.0 2020   pk_12_total 2.0                                                 50 2                                           50
1737922 AK     school 200775 51   Yukon Flats Schools 20077500362 510070 Fort Yukon School   Regular School No Other PK 12.0 2020   pk_12_total 3.0                                                 92 3                                           92
1737938 AK     school 200775 51   Yukon Flats Schools 20077500552 510140 Cruikshank School   Regular School No Other PK 12.0 2020   pk_12_total                                                   10                                             10
1820177 AK     school 200775 51   Yukon Flats Schools 20077500358 510010 Arctic Village School   Regular School No Other PK 12 2021   pk_12_total                                                   36.0                                             36
1820193 AK     school 200775 51   Yukon Flats Schools 20077500360 510040 Tsuk Taih School   Regular School No Other PK 12 2021   pk_12_total   1.0                                               10.0   1                                         10
1820209 AK     school 200775 51   Yukon Flats Schools 20077500361 510050 Circle School   Regular School No Other PK 12 2021   pk_12_total 1.0                                                 18.0 1                                           18
1820225 AK     school 200775 51   Yukon Flats Schools 20077500366 510060 John Fredson School   Regular School No Other PK 12 2021   pk_12_total                                                   48.0                                             48
1820241 AK     school 200775 51   Yukon Flats Schools 20077500362 510070 Fort Yukon School   Regular School No Other PK 12 2021   pk_12_total 1.0                                                 88.0 1                                           88

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "enrollments" (
   [state] TEXT,
   [county] TEXT,
   [county_state_id] INTEGER,
   [admin_level] TEXT,
   [district_nces_id] INTEGER,
   [district_state_id] TEXT,
   [district_state_type] TEXT,
   [district] TEXT,
   [school_nces_id] INTEGER,
   [school_state_id] INTEGER,
   [school] TEXT,
   [school_state_type] TEXT,
   [ccd_school_type] TEXT,
   [ccd_charter_school] TEXT,
   [ccd_school_lvl] TEXT,
   [ccd_school_low_grade] TEXT,
   [ccd_school_high_grade] TEXT,
   [year] INTEGER,
   [term] TEXT,
   [grade] TEXT,
   [white] TEXT,
   [black] TEXT,
   [hispanic] TEXT,
   [native_american] TEXT,
   [native_american_alaskan_native] TEXT,
   [asian] TEXT,
   [native_hawaiian] TEXT,
   [asian_pacific_islander] TEXT,
   [native_hawaiian_pacific_islander] TEXT,
   [pacific_islander] TEXT,
   [multiracial] TEXT,
   [unknown_race] TEXT,
   [male] TEXT,
   [female] TEXT,
   [non_binary] TEXT,
   [unknown_gender] TEXT,
   [ell] TEXT,
   [ell_percent] TEXT,
   [homeless] TEXT,
   [homeless_percent] TEXT,
   [low_income] TEXT,
   [free_and_reduced] TEXT,
   [free_and_reduced_percent] TEXT,
   [disability] TEXT,
   [section_504] TEXT,
   [total] TEXT
, [white_int] INTEGER, [black_int] INTEGER, [hispanic_int] INTEGER, [native_american_int] INTEGER, [native_american_alaskan_native_int] INTEGER, [asian_int] INTEGER, [native_hawaiian_int] INTEGER, [asian_pacific_islander_int] INTEGER, [native_hawaiian_pacific_islander_int] INTEGER, [pacific_islander_int] INTEGER, [multiracial_int] INTEGER, [unknown_race_int] INTEGER, [male_int] INTEGER, [female_int] INTEGER, [non_binary_int] INTEGER, [unknown_gender_int] INTEGER, [ell_int] INTEGER, [homeless_int] INTEGER, [low_income_int] INTEGER, [free_and_reduced_int] INTEGER, [disability_int] INTEGER, [section_504_int] INTEGER, [total_int] INTEGER);
CREATE INDEX [idx_enrollments_state_grade]
    ON [enrollments] ([state], [grade]);
CREATE INDEX [idx_enrollments_grade]
    ON [enrollments] ([grade]);
CREATE INDEX [idx_enrollments_year]
    ON [enrollments] ([year]);
CREATE INDEX [idx_enrollments_state_year]
    ON [enrollments] ([state], [year]);
CREATE INDEX [idx_enrollments_school_nces_id]
    ON [enrollments] ([school_nces_id]);
CREATE INDEX [idx_enrollments_district_nces_id]
    ON [enrollments] ([district_nces_id]);