enrollments

Data source: Big Local News · About: Big Local

7,968 rows where state = "AK" and year = 2020 sorted by rowid descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2020 · 7,868 ✖
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
1738159 1738159 AK     school   54   Yupiit Schools   548010 Akiachak School             2020   grade_9 0.0                   0.0                             16 0                   0                       16
1738158 1738158 AK     school   54   Yupiit Schools   548010 Akiachak School             2020   grade_8 0.0                   0.0                             9 0                   0                       9
1738157 1738157 AK     school   54   Yupiit Schools   548010 Akiachak School             2020   grade_7 0.0                   0.0                             15 0                   0                       15
1738156 1738156 AK     school   54   Yupiit Schools   548010 Akiachak School             2020   grade_6 0.0                   0.0                             10 0                   0                       10
1738155 1738155 AK     school   54   Yupiit Schools   548010 Akiachak School             2020   grade_5 0.0                   0.0                             24 0                   0                       24
1738154 1738154 AK     school   54   Yupiit Schools   548010 Akiachak School             2020   grade_4 0.0                   1.0                             22 0                   1                       22
1738153 1738153 AK     school   54   Yupiit Schools   548010 Akiachak School             2020   grade_3 0.0                   0.0                             12 0                   0                       12
1738152 1738152 AK     school   54   Yupiit Schools   548010 Akiachak School             2020   grade_2 0.0                   0.0                             24 0                   0                       24
1738151 1738151 AK     school   54   Yupiit Schools   548010 Akiachak School             2020   grade_12 1.0                   0.0                             15 1                   0                       15
1738150 1738150 AK     school   54   Yupiit Schools   548010 Akiachak School             2020   grade_11 0.0                   0.0                             10 0                   0                       10
1738149 1738149 AK     school   54   Yupiit Schools   548010 Akiachak School             2020   grade_10 0.0                   0.0                             14 0                   0                       14
1738148 1738148 AK     school   54   Yupiit Schools   548010 Akiachak School             2020   grade_1 0.0                   0.0                             15 0                   0                       15
1738147 1738147 AK     school 200004 54   Yupiit Schools 20000400623 540040 Tuluksak School   Regular School No Other KG 12.0 2020   pre_kindergarten                                                   0                                             0
1738146 1738146 AK     school 200004 54   Yupiit Schools 20000400623 540040 Tuluksak School   Regular School No Other KG 12.0 2020   pk_12_total                                                   119                                             119
1738145 1738145 AK     school 200004 54   Yupiit Schools 20000400623 540040 Tuluksak School   Regular School No Other KG 12.0 2020   kindergarten                                                   14                                             14
1738144 1738144 AK     school 200004 54   Yupiit Schools 20000400623 540040 Tuluksak School   Regular School No Other KG 12.0 2020   k_12_total                                                   119                                             119
1738143 1738143 AK     school 200004 54   Yupiit Schools 20000400623 540040 Tuluksak School   Regular School No Other KG 12.0 2020   grade_9                                                   7                                             7
1738142 1738142 AK     school 200004 54   Yupiit Schools 20000400623 540040 Tuluksak School   Regular School No Other KG 12.0 2020   grade_8                                                   6                                             6
1738141 1738141 AK     school 200004 54   Yupiit Schools 20000400623 540040 Tuluksak School   Regular School No Other KG 12.0 2020   grade_7                                                   12                                             12
1738140 1738140 AK     school 200004 54   Yupiit Schools 20000400623 540040 Tuluksak School   Regular School No Other KG 12.0 2020   grade_6                                                   8                                             8
1738139 1738139 AK     school 200004 54   Yupiit Schools 20000400623 540040 Tuluksak School   Regular School No Other KG 12.0 2020   grade_5                                                   8                                             8
1738138 1738138 AK     school 200004 54   Yupiit Schools 20000400623 540040 Tuluksak School   Regular School No Other KG 12.0 2020   grade_4                                                   9                                             9
1738137 1738137 AK     school 200004 54   Yupiit Schools 20000400623 540040 Tuluksak School   Regular School No Other KG 12.0 2020   grade_3                                                   12                                             12
1738136 1738136 AK     school 200004 54   Yupiit Schools 20000400623 540040 Tuluksak School   Regular School No Other KG 12.0 2020   grade_2                                                   6                                             6
1738135 1738135 AK     school 200004 54   Yupiit Schools 20000400623 540040 Tuluksak School   Regular School No Other KG 12.0 2020   grade_12                                                   9                                             9
1738134 1738134 AK     school 200004 54   Yupiit Schools 20000400623 540040 Tuluksak School   Regular School No Other KG 12.0 2020   grade_11                                                   4                                             4
1738133 1738133 AK     school 200004 54   Yupiit Schools 20000400623 540040 Tuluksak School   Regular School No Other KG 12.0 2020   grade_10                                                   12                                             12
1738132 1738132 AK     school 200004 54   Yupiit Schools 20000400623 540040 Tuluksak School   Regular School No Other KG 12.0 2020   grade_1                                                   12                                             12
1738131 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
1738130 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
1738129 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
1738128 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
1738127 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
1738126 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
1738125 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
1738124 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
1738123 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
1738122 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
1738121 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
1738120 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
1738119 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
1738118 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
1738117 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
1738116 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
1738115 1738115 AK     school 200715 53   Tanana Schools 20071500488 530010 Maudrey J. Sommer School   Regular School No Other KG 12.0 2020   pre_kindergarten 0.0                   0.0                             0 0                   0                       0
1738114 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
1738113 1738113 AK     school 200715 53   Tanana Schools 20071500488 530010 Maudrey J. Sommer School   Regular School No Other KG 12.0 2020   kindergarten 0.0                   0.0                             3 0                   0                       3
1738112 1738112 AK     school 200715 53   Tanana Schools 20071500488 530010 Maudrey J. Sommer School   Regular School No Other KG 12.0 2020   k_12_total 1.0                   4.0                             33 1                   4                       33
1738111 1738111 AK     school 200715 53   Tanana Schools 20071500488 530010 Maudrey J. Sommer School   Regular School No Other KG 12.0 2020   grade_9 0.0                   0.0                             3 0                   0                       3
1738110 1738110 AK     school 200715 53   Tanana Schools 20071500488 530010 Maudrey J. Sommer School   Regular School No Other KG 12.0 2020   grade_8 0.0                   1.0                             2 0                   1                       2
1738109 1738109 AK     school 200715 53   Tanana Schools 20071500488 530010 Maudrey J. Sommer School   Regular School No Other KG 12.0 2020   grade_7 0.0                   0.0                             0 0                   0                       0
1738108 1738108 AK     school 200715 53   Tanana Schools 20071500488 530010 Maudrey J. Sommer School   Regular School No Other KG 12.0 2020   grade_6 0.0                   0.0                             2 0                   0                       2
1738107 1738107 AK     school 200715 53   Tanana Schools 20071500488 530010 Maudrey J. Sommer School   Regular School No Other KG 12.0 2020   grade_5 0.0                   1.0                             3 0                   1                       3
1738106 1738106 AK     school 200715 53   Tanana Schools 20071500488 530010 Maudrey J. Sommer School   Regular School No Other KG 12.0 2020   grade_4 0.0                   0.0                             2 0                   0                       2
1738105 1738105 AK     school 200715 53   Tanana Schools 20071500488 530010 Maudrey J. Sommer School   Regular School No Other KG 12.0 2020   grade_3 0.0                   0.0                             1 0                   0                       1
1738104 1738104 AK     school 200715 53   Tanana Schools 20071500488 530010 Maudrey J. Sommer School   Regular School No Other KG 12.0 2020   grade_2 0.0                   1.0                             6 0                   1                       6
1738103 1738103 AK     school 200715 53   Tanana Schools 20071500488 530010 Maudrey J. Sommer School   Regular School No Other KG 12.0 2020   grade_12 1.0                   1.0                             3 1                   1                       3
1738102 1738102 AK     school 200715 53   Tanana Schools 20071500488 530010 Maudrey J. Sommer School   Regular School No Other KG 12.0 2020   grade_11 0.0                   0.0                             2 0                   0                       2
1738101 1738101 AK     school 200715 53   Tanana Schools 20071500488 530010 Maudrey J. Sommer School   Regular School No Other KG 12.0 2020   grade_10 0.0                   0.0                             4 0                   0                       4
1738100 1738100 AK     school 200715 53   Tanana Schools 20071500488 530010 Maudrey J. Sommer School   Regular School No Other KG 12.0 2020   grade_1 0.0                   0.0                             2 0                   0                       2
1738099 1738099 AK     school 200862 52   Yukon-Koyukuk Schools 20086200453 528010 Raven School   Regular School No Other PK 12.0 2020   pre_kindergarten 38.0 1.0 1.0 3.0   0.0     1.0   4.0                             50 38 1 1 3   0     1   4                       50
1738098 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
1738097 1738097 AK     school 200862 52   Yukon-Koyukuk Schools 20086200453 528010 Raven School   Regular School No Other PK 12.0 2020   kindergarten 88.0 1.0 5.0 0.0   1.0     3.0   10.0                             118 88 1 5 0   1     3   10                       118
1738096 1738096 AK     school 200862 52   Yukon-Koyukuk Schools 20086200453 528010 Raven School   Regular School No Other PK 12.0 2020   k_12_total 1103.0 35.0 70.0 38.0   23.0     24.0   123.0                             1645 1103 35 70 38   23     24   123                       1645
1738095 1738095 AK     school 200862 52   Yukon-Koyukuk Schools 20086200453 528010 Raven School   Regular School No Other PK 12.0 2020   grade_9 76.0 5.0 6.0 2.0   5.0     2.0   9.0                             117 76 5 6 2   5     2   9                       117
1738094 1738094 AK     school 200862 52   Yukon-Koyukuk Schools 20086200453 528010 Raven School   Regular School No Other PK 12.0 2020   grade_8 81.0 3.0 3.0 6.0   2.0     1.0   7.0                             124 81 3 3 6   2     1   7                       124
1738093 1738093 AK     school 200862 52   Yukon-Koyukuk Schools 20086200453 528010 Raven School   Regular School No Other PK 12.0 2020   grade_7 75.0 1.0 4.0 0.0   2.0     4.0   9.0                             106 75 1 4 0   2     4   9                       106
1738092 1738092 AK     school 200862 52   Yukon-Koyukuk Schools 20086200453 528010 Raven School   Regular School No Other PK 12.0 2020   grade_6 74.0 3.0 5.0 2.0   1.0     0.0   10.0                             103 74 3 5 2   1     0   10                       103
1738091 1738091 AK     school 200862 52   Yukon-Koyukuk Schools 20086200453 528010 Raven School   Regular School No Other PK 12.0 2020   grade_5 74.0 3.0 5.0 2.0   2.0     0.0   6.0                             101 74 3 5 2   2     0   6                       101
1738090 1738090 AK     school 200862 52   Yukon-Koyukuk Schools 20086200453 528010 Raven School   Regular School No Other PK 12.0 2020   grade_4 74.0 3.0 6.0 3.0   1.0     2.0   4.0                             99 74 3 6 3   1     2   4                       99
1738089 1738089 AK     school 200862 52   Yukon-Koyukuk Schools 20086200453 528010 Raven School   Regular School No Other PK 12.0 2020   grade_3 81.0 0.0 5.0 1.0   1.0     2.0   8.0                             104 81 0 5 1   1     2   8                       104
1738088 1738088 AK     school 200862 52   Yukon-Koyukuk Schools 20086200453 528010 Raven School   Regular School No Other PK 12.0 2020   grade_2 65.0 3.0 4.0 3.0   2.0     3.0   7.0                             100 65 3 4 3   2     3   7                       100
1738087 1738087 AK     school 200862 52   Yukon-Koyukuk Schools 20086200453 528010 Raven School   Regular School No Other PK 12.0 2020   grade_12 141.0 3.0 13.0 11.0   1.0     1.0   20.0                             260 141 3 13 11   1     1   20                       260
1738086 1738086 AK     school 200862 52   Yukon-Koyukuk Schools 20086200453 528010 Raven School   Regular School No Other PK 12.0 2020   grade_11 115.0 6.0 6.0 4.0   1.0     1.0   12.0                             172 115 6 6 4   1     1   12                       172
1738085 1738085 AK     school 200862 52   Yukon-Koyukuk Schools 20086200453 528010 Raven School   Regular School No Other PK 12.0 2020   grade_10 90.0 2.0 6.0 2.0   3.0     3.0   12.0                             143 90 2 6 2   3     3   12                       143
1738084 1738084 AK     school 200862 52   Yukon-Koyukuk Schools 20086200453 528010 Raven School   Regular School No Other PK 12.0 2020   grade_1 69.0 2.0 2.0 2.0   1.0     2.0   9.0                             98 69 2 2 2   1     2   9                       98
1738083 1738083 AK     school 200862 52   Yukon-Koyukuk Schools 20086200757 520120 Rampart School   Regular School No Other PK 12.0 2020   pre_kindergarten                                                   0                                             0
1738082 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
1738081 1738081 AK     school 200862 52   Yukon-Koyukuk Schools 20086200757 520120 Rampart School   Regular School No Other PK 12.0 2020   kindergarten                                                   0                                             0
1738080 1738080 AK     school 200862 52   Yukon-Koyukuk Schools 20086200757 520120 Rampart School   Regular School No Other PK 12.0 2020   k_12_total                                                   15                                             15
1738079 1738079 AK     school 200862 52   Yukon-Koyukuk Schools 20086200757 520120 Rampart School   Regular School No Other PK 12.0 2020   grade_9                                                   1                                             1
1738078 1738078 AK     school 200862 52   Yukon-Koyukuk Schools 20086200757 520120 Rampart School   Regular School No Other PK 12.0 2020   grade_8                                                   1                                             1
1738077 1738077 AK     school 200862 52   Yukon-Koyukuk Schools 20086200757 520120 Rampart School   Regular School No Other PK 12.0 2020   grade_7                                                   3                                             3
1738076 1738076 AK     school 200862 52   Yukon-Koyukuk Schools 20086200757 520120 Rampart School   Regular School No Other PK 12.0 2020   grade_6                                                   1                                             1
1738075 1738075 AK     school 200862 52   Yukon-Koyukuk Schools 20086200757 520120 Rampart School   Regular School No Other PK 12.0 2020   grade_5                                                   1                                             1
1738074 1738074 AK     school 200862 52   Yukon-Koyukuk Schools 20086200757 520120 Rampart School   Regular School No Other PK 12.0 2020   grade_4                                                   2                                             2
1738073 1738073 AK     school 200862 52   Yukon-Koyukuk Schools 20086200757 520120 Rampart School   Regular School No Other PK 12.0 2020   grade_3                                                   1                                             1
1738072 1738072 AK     school 200862 52   Yukon-Koyukuk Schools 20086200757 520120 Rampart School   Regular School No Other PK 12.0 2020   grade_2                                                   2                                             2
1738071 1738071 AK     school 200862 52   Yukon-Koyukuk Schools 20086200757 520120 Rampart School   Regular School No Other PK 12.0 2020   grade_12                                                   1                                             1
1738070 1738070 AK     school 200862 52   Yukon-Koyukuk Schools 20086200757 520120 Rampart School   Regular School No Other PK 12.0 2020   grade_11                                                   0                                             0
1738069 1738069 AK     school 200862 52   Yukon-Koyukuk Schools 20086200757 520120 Rampart School   Regular School No Other PK 12.0 2020   grade_10                                                   1                                             1
1738068 1738068 AK     school 200862 52   Yukon-Koyukuk Schools 20086200757 520120 Rampart School   Regular School No Other PK 12.0 2020   grade_1                                                   1                                             1
1738067 1738067 AK     school 200862 52   Yukon-Koyukuk Schools 20086200386 520110 Merreline A Kangas School   Regular School No Other PK 12.0 2020   pre_kindergarten 0.0     0.0                                           2 0     0                                     2
1738066 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
1738065 1738065 AK     school 200862 52   Yukon-Koyukuk Schools 20086200386 520110 Merreline A Kangas School   Regular School No Other PK 12.0 2020   kindergarten 0.0     1.0                                           3 0     1                                     3
1738064 1738064 AK     school 200862 52   Yukon-Koyukuk Schools 20086200386 520110 Merreline A Kangas School   Regular School No Other PK 12.0 2020   k_12_total 2.0     2.0                                           23 2     2                                     23
1738063 1738063 AK     school 200862 52   Yukon-Koyukuk Schools 20086200386 520110 Merreline A Kangas School   Regular School No Other PK 12.0 2020   grade_9 0.0     0.0                                           0 0     0                                     0
1738062 1738062 AK     school 200862 52   Yukon-Koyukuk Schools 20086200386 520110 Merreline A Kangas School   Regular School No Other PK 12.0 2020   grade_8 0.0     0.0                                           1 0     0                                     1
1738061 1738061 AK     school 200862 52   Yukon-Koyukuk Schools 20086200386 520110 Merreline A Kangas School   Regular School No Other PK 12.0 2020   grade_7 0.0     0.0                                           1 0     0                                     1
1738060 1738060 AK     school 200862 52   Yukon-Koyukuk Schools 20086200386 520110 Merreline A Kangas School   Regular School No Other PK 12.0 2020   grade_6 2.0     1.0                                           9 2     1                                     9

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