Data source: Big Local News · About: Big Local

7,952 rows where state = "AK" and year = 2021 sorted by school_nces_id

View and edit SQL

year

  • 2021 · 7,852
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
1817831 AK     school 200001 31   Lower Kuskokwim Schools 20000100212 310150 Kwigillingok School   Regular School No Other PK 12 2021   grade_2                                                   12.0                                             12
1817832 AK     school 200001 31   Lower Kuskokwim Schools 20000100212 310150 Kwigillingok School   Regular School No Other PK 12 2021   grade_3                                                   8.0                                             8
1817833 AK     school 200001 31   Lower Kuskokwim Schools 20000100212 310150 Kwigillingok School   Regular School No Other PK 12 2021   grade_4                                                   9.0                                             9
1817834 AK     school 200001 31   Lower Kuskokwim Schools 20000100212 310150 Kwigillingok School   Regular School No Other PK 12 2021   grade_5                                                   10.0                                             10
1817835 AK     school 200001 31   Lower Kuskokwim Schools 20000100212 310150 Kwigillingok School   Regular School No Other PK 12 2021   grade_6                                                   8.0                                             8
1817836 AK     school 200001 31   Lower Kuskokwim Schools 20000100212 310150 Kwigillingok School   Regular School No Other PK 12 2021   grade_7                                                   10.0                                             10
1817837 AK     school 200001 31   Lower Kuskokwim Schools 20000100212 310150 Kwigillingok School   Regular School No Other PK 12 2021   grade_8                                                   8.0                                             8
1817838 AK     school 200001 31   Lower Kuskokwim Schools 20000100212 310150 Kwigillingok School   Regular School No Other PK 12 2021   grade_9                                                   19.0                                             19
1817839 AK     school 200001 31   Lower Kuskokwim Schools 20000100212 310150 Kwigillingok School   Regular School No Other PK 12 2021   k_12_total                                                   134.0                                             134
1817840 AK     school 200001 31   Lower Kuskokwim Schools 20000100212 310150 Kwigillingok School   Regular School No Other PK 12 2021   kindergarten                                                   12.0                                             12
1817841 AK     school 200001 31   Lower Kuskokwim Schools 20000100212 310150 Kwigillingok School   Regular School No Other PK 12 2021   pk_12_total                                                   148.0                                             148
1817842 AK     school 200001 31   Lower Kuskokwim Schools 20000100212 310150 Kwigillingok School   Regular School No Other PK 12 2021   pre_kindergarten                                                   14.0                                             14
1817987 AK     school 200001 31   Lower Kuskokwim Schools 20000100213 310250 Nelson Island Area School   Regular School No Other PK 12 2021   grade_1 0.0         0.0                                       13.0 0         0                                 13
1817988 AK     school 200001 31   Lower Kuskokwim Schools 20000100213 310250 Nelson Island Area School   Regular School No Other PK 12 2021   grade_10 0.0         0.0                                       15.0 0         0                                 15
1817989 AK     school 200001 31   Lower Kuskokwim Schools 20000100213 310250 Nelson Island Area School   Regular School No Other PK 12 2021   grade_11 0.0         0.0                                       18.0 0         0                                 18
1817990 AK     school 200001 31   Lower Kuskokwim Schools 20000100213 310250 Nelson Island Area School   Regular School No Other PK 12 2021   grade_12 1.0         0.0                                       23.0 1         0                                 23
1817991 AK     school 200001 31   Lower Kuskokwim Schools 20000100213 310250 Nelson Island Area School   Regular School No Other PK 12 2021   grade_2 0.0         0.0                                       13.0 0         0                                 13
1817992 AK     school 200001 31   Lower Kuskokwim Schools 20000100213 310250 Nelson Island Area School   Regular School No Other PK 12 2021   grade_3 0.0         1.0                                       8.0 0         1                                 8
1817993 AK     school 200001 31   Lower Kuskokwim Schools 20000100213 310250 Nelson Island Area School   Regular School No Other PK 12 2021   grade_4 0.0         0.0                                       12.0 0         0                                 12
1817994 AK     school 200001 31   Lower Kuskokwim Schools 20000100213 310250 Nelson Island Area School   Regular School No Other PK 12 2021   grade_5 0.0         0.0                                       7.0 0         0                                 7
1817995 AK     school 200001 31   Lower Kuskokwim Schools 20000100213 310250 Nelson Island Area School   Regular School No Other PK 12 2021   grade_6 0.0         0.0                                       13.0 0         0                                 13
1817996 AK     school 200001 31   Lower Kuskokwim Schools 20000100213 310250 Nelson Island Area School   Regular School No Other PK 12 2021   grade_7 0.0         0.0                                       13.0 0         0                                 13
1817997 AK     school 200001 31   Lower Kuskokwim Schools 20000100213 310250 Nelson Island Area School   Regular School No Other PK 12 2021   grade_8 0.0         0.0                                       8.0 0         0                                 8
1817998 AK     school 200001 31   Lower Kuskokwim Schools 20000100213 310250 Nelson Island Area School   Regular School No Other PK 12 2021   grade_9 0.0         0.0                                       11.0 0         0                                 11
1817999 AK     school 200001 31   Lower Kuskokwim Schools 20000100213 310250 Nelson Island Area School   Regular School No Other PK 12 2021   k_12_total 1.0         1.0                                       173.0 1         1                                 173
1818000 AK     school 200001 31   Lower Kuskokwim Schools 20000100213 310250 Nelson Island Area School   Regular School No Other PK 12 2021   kindergarten 0.0         0.0                                       19.0 0         0                                 19
1818001 AK     school 200001 31   Lower Kuskokwim Schools 20000100213 310250 Nelson Island Area School   Regular School No Other PK 12 2021   pk_12_total 1.0         1.0                                       174.0 1         1                                 174
1818002 AK     school 200001 31   Lower Kuskokwim Schools 20000100213 310250 Nelson Island Area School   Regular School No Other PK 12 2021   pre_kindergarten 0.0         0.0                                       1.0 0         0                                 1
1817923 AK     school 200001 31   Lower Kuskokwim Schools 20000100214 310210 Anna Tobeluk Memorial School   Regular School No Other PK 12 2021   grade_1                                                   15.0                                             15
1817924 AK     school 200001 31   Lower Kuskokwim Schools 20000100214 310210 Anna Tobeluk Memorial School   Regular School No Other PK 12 2021   grade_10                                                   13.0                                             13
1817925 AK     school 200001 31   Lower Kuskokwim Schools 20000100214 310210 Anna Tobeluk Memorial School   Regular School No Other PK 12 2021   grade_11                                                   14.0                                             14
1817926 AK     school 200001 31   Lower Kuskokwim Schools 20000100214 310210 Anna Tobeluk Memorial School   Regular School No Other PK 12 2021   grade_12                                                   9.0                                             9
1817927 AK     school 200001 31   Lower Kuskokwim Schools 20000100214 310210 Anna Tobeluk Memorial School   Regular School No Other PK 12 2021   grade_2                                                   16.0                                             16
1817928 AK     school 200001 31   Lower Kuskokwim Schools 20000100214 310210 Anna Tobeluk Memorial School   Regular School No Other PK 12 2021   grade_3                                                   14.0                                             14
1817929 AK     school 200001 31   Lower Kuskokwim Schools 20000100214 310210 Anna Tobeluk Memorial School   Regular School No Other PK 12 2021   grade_4                                                   15.0                                             15
1817930 AK     school 200001 31   Lower Kuskokwim Schools 20000100214 310210 Anna Tobeluk Memorial School   Regular School No Other PK 12 2021   grade_5                                                   18.0                                             18
1817931 AK     school 200001 31   Lower Kuskokwim Schools 20000100214 310210 Anna Tobeluk Memorial School   Regular School No Other PK 12 2021   grade_6                                                   16.0                                             16
1817932 AK     school 200001 31   Lower Kuskokwim Schools 20000100214 310210 Anna Tobeluk Memorial School   Regular School No Other PK 12 2021   grade_7                                                   8.0                                             8
1817933 AK     school 200001 31   Lower Kuskokwim Schools 20000100214 310210 Anna Tobeluk Memorial School   Regular School No Other PK 12 2021   grade_8                                                   17.0                                             17
1817934 AK     school 200001 31   Lower Kuskokwim Schools 20000100214 310210 Anna Tobeluk Memorial School   Regular School No Other PK 12 2021   grade_9                                                   27.0                                             27
1817935 AK     school 200001 31   Lower Kuskokwim Schools 20000100214 310210 Anna Tobeluk Memorial School   Regular School No Other PK 12 2021   k_12_total                                                   191.0                                             191
1817936 AK     school 200001 31   Lower Kuskokwim Schools 20000100214 310210 Anna Tobeluk Memorial School   Regular School No Other PK 12 2021   kindergarten                                                   9.0                                             9
1817937 AK     school 200001 31   Lower Kuskokwim Schools 20000100214 310210 Anna Tobeluk Memorial School   Regular School No Other PK 12 2021   pk_12_total                                                   192.0                                             192
1817938 AK     school 200001 31   Lower Kuskokwim Schools 20000100214 310210 Anna Tobeluk Memorial School   Regular School No Other PK 12 2021   pre_kindergarten                                                   1.0                                             1
1817955 AK     school 200001 31   Lower Kuskokwim Schools 20000100215 310230 Arviq School   Regular School No Other KG 12 2021   grade_1                                                   2.0                                             2
1817956 AK     school 200001 31   Lower Kuskokwim Schools 20000100215 310230 Arviq School   Regular School No Other KG 12 2021   grade_10                                                   1.0                                             1
1817957 AK     school 200001 31   Lower Kuskokwim Schools 20000100215 310230 Arviq School   Regular School No Other KG 12 2021   grade_11                                                   0.0                                             0
1817958 AK     school 200001 31   Lower Kuskokwim Schools 20000100215 310230 Arviq School   Regular School No Other KG 12 2021   grade_12                                                   0.0                                             0
1817959 AK     school 200001 31   Lower Kuskokwim Schools 20000100215 310230 Arviq School   Regular School No Other KG 12 2021   grade_2                                                   1.0                                             1
1817960 AK     school 200001 31   Lower Kuskokwim Schools 20000100215 310230 Arviq School   Regular School No Other KG 12 2021   grade_3                                                   3.0                                             3
1817961 AK     school 200001 31   Lower Kuskokwim Schools 20000100215 310230 Arviq School   Regular School No Other KG 12 2021   grade_4                                                   1.0                                             1
1817962 AK     school 200001 31   Lower Kuskokwim Schools 20000100215 310230 Arviq School   Regular School No Other KG 12 2021   grade_5                                                   0.0                                             0
1817963 AK     school 200001 31   Lower Kuskokwim Schools 20000100215 310230 Arviq School   Regular School No Other KG 12 2021   grade_6                                                   1.0                                             1
1817964 AK     school 200001 31   Lower Kuskokwim Schools 20000100215 310230 Arviq School   Regular School No Other KG 12 2021   grade_7                                                   1.0                                             1
1817965 AK     school 200001 31   Lower Kuskokwim Schools 20000100215 310230 Arviq School   Regular School No Other KG 12 2021   grade_8                                                   0.0                                             0
1817966 AK     school 200001 31   Lower Kuskokwim Schools 20000100215 310230 Arviq School   Regular School No Other KG 12 2021   grade_9                                                   1.0                                             1
1817967 AK     school 200001 31   Lower Kuskokwim Schools 20000100215 310230 Arviq School   Regular School No Other KG 12 2021   k_12_total                                                   11.0                                             11
1817968 AK     school 200001 31   Lower Kuskokwim Schools 20000100215 310230 Arviq School   Regular School No Other KG 12 2021   kindergarten                                                   0.0                                             0
1817969 AK     school 200001 31   Lower Kuskokwim Schools 20000100215 310230 Arviq School   Regular School No Other KG 12 2021   pk_12_total                                                   11.0                                             11
1817970 AK     school 200001 31   Lower Kuskokwim Schools 20000100215 310230 Arviq School   Regular School No Other KG 12 2021   pre_kindergarten                                                   0.0                                             0
1818051 AK     school 200001 31   Lower Kuskokwim Schools 20000100318 317010 Kuskokwim Learning Academy   Alternative School No High 09 12 2021   grade_1 0.0   0.0                                             0.0 0   0                                       0
1818052 AK     school 200001 31   Lower Kuskokwim Schools 20000100318 317010 Kuskokwim Learning Academy   Alternative School No High 09 12 2021   grade_10 0.0   0.0                                             7.0 0   0                                       7
1818053 AK     school 200001 31   Lower Kuskokwim Schools 20000100318 317010 Kuskokwim Learning Academy   Alternative School No High 09 12 2021   grade_11 1.0   0.0                                             5.0 1   0                                       5
1818054 AK     school 200001 31   Lower Kuskokwim Schools 20000100318 317010 Kuskokwim Learning Academy   Alternative School No High 09 12 2021   grade_12 1.0   1.0                                             12.0 1   1                                       12
1818055 AK     school 200001 31   Lower Kuskokwim Schools 20000100318 317010 Kuskokwim Learning Academy   Alternative School No High 09 12 2021   grade_2 0.0   0.0                                             0.0 0   0                                       0
1818056 AK     school 200001 31   Lower Kuskokwim Schools 20000100318 317010 Kuskokwim Learning Academy   Alternative School No High 09 12 2021   grade_3 0.0   0.0                                             0.0 0   0                                       0
1818057 AK     school 200001 31   Lower Kuskokwim Schools 20000100318 317010 Kuskokwim Learning Academy   Alternative School No High 09 12 2021   grade_4 0.0   0.0                                             0.0 0   0                                       0
1818058 AK     school 200001 31   Lower Kuskokwim Schools 20000100318 317010 Kuskokwim Learning Academy   Alternative School No High 09 12 2021   grade_5 0.0   0.0                                             0.0 0   0                                       0
1818059 AK     school 200001 31   Lower Kuskokwim Schools 20000100318 317010 Kuskokwim Learning Academy   Alternative School No High 09 12 2021   grade_6 0.0   0.0                                             0.0 0   0                                       0
1818060 AK     school 200001 31   Lower Kuskokwim Schools 20000100318 317010 Kuskokwim Learning Academy   Alternative School No High 09 12 2021   grade_7 0.0   0.0                                             0.0 0   0                                       0
1818061 AK     school 200001 31   Lower Kuskokwim Schools 20000100318 317010 Kuskokwim Learning Academy   Alternative School No High 09 12 2021   grade_8 0.0   0.0                                             0.0 0   0                                       0
1818062 AK     school 200001 31   Lower Kuskokwim Schools 20000100318 317010 Kuskokwim Learning Academy   Alternative School No High 09 12 2021   grade_9 0.0   0.0                                             3.0 0   0                                       3
1818063 AK     school 200001 31   Lower Kuskokwim Schools 20000100318 317010 Kuskokwim Learning Academy   Alternative School No High 09 12 2021   k_12_total 2.0   1.0                                             27.0 2   1                                       27
1818064 AK     school 200001 31   Lower Kuskokwim Schools 20000100318 317010 Kuskokwim Learning Academy   Alternative School No High 09 12 2021   kindergarten 0.0   0.0                                             0.0 0   0                                       0
1818065 AK     school 200001 31   Lower Kuskokwim Schools 20000100318 317010 Kuskokwim Learning Academy   Alternative School No High 09 12 2021   pk_12_total 2.0   1.0                                             27.0 2   1                                       27
1818066 AK     school 200001 31   Lower Kuskokwim Schools 20000100318 317010 Kuskokwim Learning Academy   Alternative School No High 09 12 2021   pre_kindergarten 0.0   0.0                                             0.0 0   0                                       0
1818083 AK     school 200001 31   Lower Kuskokwim Schools 20000100329 319010 Ayaprun Elitnaurvik   Regular School Yes Elementary PK 6 2021   grade_1 1.0                                                 32.0 1                                           32
1818084 AK     school 200001 31   Lower Kuskokwim Schools 20000100329 319010 Ayaprun Elitnaurvik   Regular School Yes Elementary PK 6 2021   grade_10 0.0                                                 0.0 0                                           0
1818085 AK     school 200001 31   Lower Kuskokwim Schools 20000100329 319010 Ayaprun Elitnaurvik   Regular School Yes Elementary PK 6 2021   grade_11 0.0                                                 0.0 0                                           0
1818086 AK     school 200001 31   Lower Kuskokwim Schools 20000100329 319010 Ayaprun Elitnaurvik   Regular School Yes Elementary PK 6 2021   grade_12 0.0                                                 0.0 0                                           0
1818087 AK     school 200001 31   Lower Kuskokwim Schools 20000100329 319010 Ayaprun Elitnaurvik   Regular School Yes Elementary PK 6 2021   grade_2 2.0                                                 32.0 2                                           32
1818088 AK     school 200001 31   Lower Kuskokwim Schools 20000100329 319010 Ayaprun Elitnaurvik   Regular School Yes Elementary PK 6 2021   grade_3 0.0                                                 17.0 0                                           17
1818089 AK     school 200001 31   Lower Kuskokwim Schools 20000100329 319010 Ayaprun Elitnaurvik   Regular School Yes Elementary PK 6 2021   grade_4 0.0                                                 16.0 0                                           16
1818090 AK     school 200001 31   Lower Kuskokwim Schools 20000100329 319010 Ayaprun Elitnaurvik   Regular School Yes Elementary PK 6 2021   grade_5 2.0                                                 19.0 2                                           19
1818091 AK     school 200001 31   Lower Kuskokwim Schools 20000100329 319010 Ayaprun Elitnaurvik   Regular School Yes Elementary PK 6 2021   grade_6 0.0                                                 15.0 0                                           15
1818092 AK     school 200001 31   Lower Kuskokwim Schools 20000100329 319010 Ayaprun Elitnaurvik   Regular School Yes Elementary PK 6 2021   grade_7 0.0                                                 0.0 0                                           0
1818093 AK     school 200001 31   Lower Kuskokwim Schools 20000100329 319010 Ayaprun Elitnaurvik   Regular School Yes Elementary PK 6 2021   grade_8 0.0                                                 0.0 0                                           0
1818094 AK     school 200001 31   Lower Kuskokwim Schools 20000100329 319010 Ayaprun Elitnaurvik   Regular School Yes Elementary PK 6 2021   grade_9 0.0                                                 0.0 0                                           0
1818095 AK     school 200001 31   Lower Kuskokwim Schools 20000100329 319010 Ayaprun Elitnaurvik   Regular School Yes Elementary PK 6 2021   k_12_total 6.0                                                 157.0 6                                           157
1818096 AK     school 200001 31   Lower Kuskokwim Schools 20000100329 319010 Ayaprun Elitnaurvik   Regular School Yes Elementary PK 6 2021   kindergarten 1.0                                                 26.0 1                                           26
1818097 AK     school 200001 31   Lower Kuskokwim Schools 20000100329 319010 Ayaprun Elitnaurvik   Regular School Yes Elementary PK 6 2021   pk_12_total 6.0                                                 157.0 6                                           157
1818098 AK     school 200001 31   Lower Kuskokwim Schools 20000100329 319010 Ayaprun Elitnaurvik   Regular School Yes Elementary PK 6 2021   pre_kindergarten 0.0                                                 0.0 0                                           0
1818035 AK     school 200001 31   Lower Kuskokwim Schools 20000100389 310320 Paul T. Albert Memorial School   Regular School No Other PK 12 2021   grade_1                                                   9.0                                             9
1818036 AK     school 200001 31   Lower Kuskokwim Schools 20000100389 310320 Paul T. Albert Memorial School   Regular School No Other PK 12 2021   grade_10                                                   10.0                                             10
1818037 AK     school 200001 31   Lower Kuskokwim Schools 20000100389 310320 Paul T. Albert Memorial School   Regular School No Other PK 12 2021   grade_11                                                   9.0                                             9
1818038 AK     school 200001 31   Lower Kuskokwim Schools 20000100389 310320 Paul T. Albert Memorial School   Regular School No Other PK 12 2021   grade_12                                                   2.0                                             2
1818039 AK     school 200001 31   Lower Kuskokwim Schools 20000100389 310320 Paul T. Albert Memorial School   Regular School No Other PK 12 2021   grade_2                                                   13.0                                             13
1818040 AK     school 200001 31   Lower Kuskokwim Schools 20000100389 310320 Paul T. Albert Memorial School   Regular School No Other PK 12 2021   grade_3                                                   4.0                                             4
1818041 AK     school 200001 31   Lower Kuskokwim Schools 20000100389 310320 Paul T. Albert Memorial School   Regular School No Other PK 12 2021   grade_4                                                   7.0                                             7
1818042 AK     school 200001 31   Lower Kuskokwim Schools 20000100389 310320 Paul T. Albert Memorial School   Regular School No Other PK 12 2021   grade_5                                                   14.0                                             14

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]);