Data source: Big Local News · About: Big Local

13,914 rows where state = "MN" and year = 2021 sorted by ccd_school_lvl

View and edit SQL

year

  • 2021 · 13,914
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
1713209 MN Aitkin 1 school 2702760 1 Independent Districts and Schools Aitkin Public School District 270276000059 2 Rippleside Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2021   early_childhood_special_ed 14 0 0   0 0     0   0   9 5     0.0   0.0     9.0   *   14 14 0 0   0 0     0   0   9 5     0 0   9     14
1713210 MN Aitkin 1 school 2702760 1 Independent Districts and Schools Aitkin Public School District 270276000059 2 Rippleside Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2021   kindergarten 60 0 0   1 0     0   3   34 30     0.0   0.0     22.0   10.0   64 60 0 0   1 0     0   3   34 30     0 0   22 10   64
1713211 MN Aitkin 1 school 2702760 1 Independent Districts and Schools Aitkin Public School District 270276000059 2 Rippleside Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2021   grade_1 51 3 1   1 0     0   7   32 31     0.0   0.0     22.0   15.0   63 51 3 1   1 0     0   7   32 31     0 0   22 15   63
1713212 MN Aitkin 1 school 2702760 1 Independent Districts and Schools Aitkin Public School District 270276000059 2 Rippleside Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2021   grade_2 48 2 1   0 0     0   4   23 32     0.0   0.0     30.0   10.0   55 48 2 1   0 0     0   4   23 32     0 0   30 10   55
1713213 MN Aitkin 1 school 2702760 1 Independent Districts and Schools Aitkin Public School District 270276000059 2 Rippleside Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2021   grade_3 78 0 4   1 1     0   4   51 37     0.0   0.0     28.0   16.0   88 78 0 4   1 1     0   4   51 37     0 0   28 16   88
1713214 MN Aitkin 1 school 2702760 1 Independent Districts and Schools Aitkin Public School District 270276000059 2 Rippleside Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2021   grade_4 64 0 1   2 1     0   4   36 36     0.0   0.0     26.0   13.0   72 64 0 1   2 1     0   4   36 36     0 0   26 13   72
1713215 MN Aitkin 1 school 2702760 1 Independent Districts and Schools Aitkin Public School District 270276000059 2 Rippleside Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2021   grade_5 77 1 1   1 1     0   3   50 34     0.0   1.0     31.0   13.0   84 77 1 1   1 1     0   3   50 34     0 1   31 13   84
1713216 MN Aitkin 1 school 2702760 1 Independent Districts and Schools Aitkin Public School District 270276000059 2 Rippleside Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2021   grade_6 75 0 0   1 0     0   2   48 30     0.0   0.0     32.0   14.0   78 75 0 0   1 0     0   2   48 30     0 0   32 14   78
1713217 MN Aitkin 1 school 2702760 1 Independent Districts and Schools Aitkin Public School District 270276000059 2 Rippleside Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2021   pk_12_total 467 6 8   7 3     0   27   283 235     0.0   1.0     200.0   105.0   518 467 6 8   7 3     0   27   283 235     0 1   200 105   518
1713218 MN Aitkin 1 school 2714010 2 Independent Districts and Schools Hill City Public School District 271401000723 1 Hill City Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 04 2021   early_childhood_special_ed 3 0 0   0 0     0   1   4 0     *   *     *   *   4 3 0 0   0 0     0   1   4 0                 4
1713219 MN Aitkin 1 school 2714010 2 Independent Districts and Schools Hill City Public School District 271401000723 1 Hill City Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 04 2021   pre_kindergarten 8 0 0   0 0     0   0   3 5     *   *     *   *   8 8 0 0   0 0     0   0   3 5                 8
1713220 MN Aitkin 1 school 2714010 2 Independent Districts and Schools Hill City Public School District 271401000723 1 Hill City Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 04 2021   kindergarten 16 0 0   0 0     0   0   10 6     0.0   0.0     8.0   6.0   16 16 0 0   0 0     0   0   10 6     0 0   8 6   16
1713221 MN Aitkin 1 school 2714010 2 Independent Districts and Schools Hill City Public School District 271401000723 1 Hill City Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 04 2021   grade_1 13 0 0   0 0     0   1   12 2     0.0   0.0     9.0   *   14 13 0 0   0 0     0   1   12 2     0 0   9     14
1713222 MN Aitkin 1 school 2714010 2 Independent Districts and Schools Hill City Public School District 271401000723 1 Hill City Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 04 2021   grade_2 9 0 1   1 0     0   1   4 8     0.0   0.0     8.0   2.0   12 9 0 1   1 0     0   1   4 8     0 0   8 2   12
1713223 MN Aitkin 1 school 2714010 2 Independent Districts and Schools Hill City Public School District 271401000723 1 Hill City Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 04 2021   grade_3 14 0 0   2 0     0   1   9 8     0.0   0.0     7.0   1.0   17 14 0 0   2 0     0   1   9 8     0 0   7 1   17
1713224 MN Aitkin 1 school 2714010 2 Independent Districts and Schools Hill City Public School District 271401000723 1 Hill City Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 04 2021   grade_4 12 0 1   0 0     0   0   6 7     0.0   0.0     7.0   5.0   13 12 0 1   0 0     0   0   6 7     0 0   7 5   13
1713225 MN Aitkin 1 school 2714010 2 Independent Districts and Schools Hill City Public School District 271401000723 1 Hill City Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 04 2021   pk_12_total 75 0 2   3 0     0   4   48 36     0.0   0.0     47.0   19.0   84 75 0 2   3 0     0   4   48 36     0 0   47 19   84
1713226 MN Aitkin 1 school 2719170 4 Independent Districts and Schools McGregor Public School District 271917000903 10 McGregor Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2021   early_childhood_special_ed 5 0 0   6 0     0   0   7 4     *   *     *   *   11 5 0 0   6 0     0   0   7 4                 11
1713227 MN Aitkin 1 school 2719170 4 Independent Districts and Schools McGregor Public School District 271917000903 10 McGregor Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2021   pre_kindergarten 5 0 0   0 0     0   0   3 2     *   *     *   *   5 5 0 0   0 0     0   0   3 2                 5
1713228 MN Aitkin 1 school 2719170 4 Independent Districts and Schools McGregor Public School District 271917000903 10 McGregor Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2021   kindergarten 11 0 0   4 0     0   0   10 5     0.0   0.0     6.0   6.0   15 11 0 0   4 0     0   0   10 5     0 0   6 6   15
1713229 MN Aitkin 1 school 2719170 4 Independent Districts and Schools McGregor Public School District 271917000903 10 McGregor Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2021   grade_1 27 0 1   9 0     0   0   21 16     0.0   0.0     15.0   10.0   37 27 0 1   9 0     0   0   21 16     0 0   15 10   37
1713230 MN Aitkin 1 school 2719170 4 Independent Districts and Schools McGregor Public School District 271917000903 10 McGregor Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2021   grade_2 23 1 0   4 0     0   1   18 11     0.0   0.0     10.0   8.0   29 23 1 0   4 0     0   1   18 11     0 0   10 8   29
1713231 MN Aitkin 1 school 2719170 4 Independent Districts and Schools McGregor Public School District 271917000903 10 McGregor Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2021   grade_3 14 0 0   7 0     0   0   11 10     0.0   0.0     8.0   7.0   21 14 0 0   7 0     0   0   11 10     0 0   8 7   21
1713232 MN Aitkin 1 school 2719170 4 Independent Districts and Schools McGregor Public School District 271917000903 10 McGregor Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2021   grade_4 16 0 0   8 0     0   1   14 11     0.0   0.0     6.0   *   25 16 0 0   8 0     0   1   14 11     0 0   6     25
1713233 MN Aitkin 1 school 2719170 4 Independent Districts and Schools McGregor Public School District 271917000903 10 McGregor Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2021   grade_5 26 0 1   9 0     0   0   15 21     0.0   0.0     19.0   12.0   36 26 0 1   9 0     0   0   15 21     0 0   19 12   36
1713234 MN Aitkin 1 school 2719170 4 Independent Districts and Schools McGregor Public School District 271917000903 10 McGregor Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2021   grade_6 24 0 0   9 0     0   1   17 17     0.0   0.0     13.0   9.0   34 24 0 0   9 0     0   1   17 17     0 0   13 9   34
1713235 MN Aitkin 1 school 2719170 4 Independent Districts and Schools McGregor Public School District 271917000903 10 McGregor Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2021   pk_12_total 151 1 2   56 0     0   3   116 97     *   *     84.0   68.0   213 151 1 2   56 0     0   3   116 97           84 68   213
1713236 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000095 400 Adams Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   pre_kindergarten 15 0 0   0 6     0   2   11 12     0.0   0.0     8.0   0.0   23 15 0 0   0 6     0   2   11 12     0 0   8 0   23
1713237 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000095 400 Adams Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   kindergarten 38 12 8   1 9     0   11   48 31     20.0   *     35.0   17.0   79 38 12 8   1 9     0   11   48 31     20     35 17   79
1713238 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000095 400 Adams Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   grade_1 44 11 4   1 11     0   6   31 46     16.0   0.0     35.0   16.0   77 44 11 4   1 11     0   6   31 46     16 0   35 16   77
1713239 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000095 400 Adams Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   grade_2 31 16 6   0 14     0   12   46 33     12.0   2.0     42.0   15.0   79 31 16 6   0 14     0   12   46 33     12 2   42 15   79
1713240 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000095 400 Adams Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   grade_3 22 19 8   0 7     0   10   38 28     19.0   *     35.0   15.0   66 22 19 8   0 7     0   10   38 28     19     35 15   66
1713241 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000095 400 Adams Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   grade_4 36 23 9   0 6     0   11   46 39     13.0   4.0     48.0   19.0   85 36 23 9   0 6     0   11   46 39     13 4   48 19   85
1713242 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000095 400 Adams Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   grade_5 32 17 14   2 7     0   10   41 41     16.0   2.0     53.0   15.0   82 32 17 14   2 7     0   10   41 41     16 2   53 15   82
1713243 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000095 400 Adams Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   pk_12_total 218 98 49   4 60     0   62   261 230     96.0   10.0     256.0   97.0   491 218 98 49   4 60     0   62   261 230     96 10   256 97   491
1713244 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000101 402 Crooked Lake Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   kindergarten 38 4 4   2 3     0   3   28 26     7.0   0.0     11.0   13.0   54 38 4 4   2 3     0   3   28 26     7 0   11 13   54
1713245 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000101 402 Crooked Lake Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   grade_1 56 4 3   0 3     0   5   37 34     6.0   2.0     21.0   12.0   71 56 4 3   0 3     0   5   37 34     6 2   21 12   71
1713246 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000101 402 Crooked Lake Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   grade_2 52 7 5   0 1     0   6   37 34     *   2.0     21.0   14.0   71 52 7 5   0 1     0   6   37 34       2   21 14   71
1713247 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000101 402 Crooked Lake Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   grade_3 54 4 2   0 3     0   5   38 30     5.0   2.0     14.0   9.0   68 54 4 2   0 3     0   5   38 30     5 2   14 9   68
1713248 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000101 402 Crooked Lake Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   grade_4 51 7 5   0 1     0   3   41 26     *   0.0     21.0   13.0   67 51 7 5   0 1     0   3   41 26       0   21 13   67
1713249 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000101 402 Crooked Lake Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   grade_5 49 1 6   2 6     0   6   40 30     3.0   0.0     20.0   18.0   70 49 1 6   2 6     0   6   40 30     3 0   20 18   70
1713250 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000101 402 Crooked Lake Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   pk_12_total 300 27 25   4 17     0   28   221 180     28.0   6.0     108.0   79.0   401 300 27 25   4 17     0   28   221 180     28 6   108 79   401
1713251 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000105 403 Franklin Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   kindergarten 21 4 9   1 2     0   8   21 24     8.0   2.0     25.0   9.0   45 21 4 9   1 2     0   8   21 24     8 2   25 9   45
1713252 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000105 403 Franklin Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   grade_1 15 10 6   0 5     0   6   14 28     7.0   0.0     22.0   2.0   42 15 10 6   0 5     0   6   14 28     7 0   22 2   42
1713253 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000105 403 Franklin Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   grade_2 28 11 4   2 6     1   13   30 35     8.0   0.0     36.0   13.0   65 28 11 4   2 6     1   13   30 35     8 0   36 13   65
1713254 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000105 403 Franklin Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   grade_3 27 6 5   1 1     0   2   21 21     5.0   0.0     18.0   15.0   42 27 6 5   1 1     0   2   21 21     5 0   18 15   42
1713255 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000105 403 Franklin Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   grade_4 37 20 4   0 1     0   7   33 36     7.0   1.0     43.0   23.0   69 37 20 4   0 1     0   7   33 36     7 1   43 23   69
1713256 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000105 403 Franklin Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   grade_5 28 4 7   2 4     0   4   23 26     6.0   1.0     19.0   15.0   49 28 4 7   2 4     0   4   23 26     6 1   19 15   49
1713257 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000105 403 Franklin Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   pk_12_total 156 55 35   6 19     1   40   142 170     41.0   4.0     163.0   77.0   312 156 55 35   6 19     1   40   142 170     41 4   163 77   312
1713258 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000106 404 Hamilton Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   kindergarten 23 8 6   0 9     0   5   23 28     14.0   2.0     32.0   9.0   51 23 8 6   0 9     0   5   23 28     14 2   32 9   51
1713259 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000106 404 Hamilton Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   grade_1 27 16 3   0 11     0   8   39 26     11.0   2.0     35.0   13.0   65 27 16 3   0 11     0   8   39 26     11 2   35 13   65
1713260 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000106 404 Hamilton Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   grade_2 32 15 9   1 8     0   10   36 39     16.0   1.0     42.0   20.0   75 32 15 9   1 8     0   10   36 39     16 1   42 20   75
1713261 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000106 404 Hamilton Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   grade_3 35 15 7   1 8     0   3   40 29     15.0   0.0     36.0   16.0   69 35 15 7   1 8     0   3   40 29     15 0   36 16   69
1713262 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000106 404 Hamilton Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   grade_4 28 12 5   0 10     0   9   39 25     12.0   0.0     37.0   21.0   64 28 12 5   0 10     0   9   39 25     12 0   37 21   64
1713263 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000106 404 Hamilton Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   grade_5 31 9 6   1 6     0   6   35 24     6.0   0.0     35.0   17.0   59 31 9 6   1 6     0   6   35 24     6 0   35 17   59
1713264 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000106 404 Hamilton Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   pk_12_total 176 75 36   3 52     0   41   212 171     74.0   5.0     217.0   96.0   383 176 75 36   3 52     0   41   212 171     74 5   217 96   383
1713265 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000107 405 Hoover Elementary - Biomedical, Health Sciences and Engineering Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   kindergarten 47 11 9   1 5     0   6   42 37     9.0   0.0     33.0   16.0   79 47 11 9   1 5     0   6   42 37     9 0   33 16   79
1713266 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000107 405 Hoover Elementary - Biomedical, Health Sciences and Engineering Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   grade_1 50 11 7   2 8     0   8   50 36     14.0   2.0     38.0   24.0   86 50 11 7   2 8     0   8   50 36     14 2   38 24   86
1713267 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000107 405 Hoover Elementary - Biomedical, Health Sciences and Engineering Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   grade_2 44 13 5   0 10     0   13   46 39     12.0   0.0     37.0   18.0   85 44 13 5   0 10     0   13   46 39     12 0   37 18   85
1713268 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000107 405 Hoover Elementary - Biomedical, Health Sciences and Engineering Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   grade_3 36 9 11   0 8     0   10   33 41     10.0   1.0     31.0   8.0   74 36 9 11   0 8     0   10   33 41     10 1   31 8   74
1713269 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000107 405 Hoover Elementary - Biomedical, Health Sciences and Engineering Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   grade_4 42 12 4   0 10     0   7   34 41     10.0   2.0     41.0   7.0   75 42 12 4   0 10     0   7   34 41     10 2   41 7   75
1713270 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000107 405 Hoover Elementary - Biomedical, Health Sciences and Engineering Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   grade_5 37 11 10   0 4     0   13   40 35     3.0   2.0     35.0   11.0   75 37 11 10   0 4     0   13   40 35     3 2   35 11   75
1713271 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000107 405 Hoover Elementary - Biomedical, Health Sciences and Engineering Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   pk_12_total 256 67 46   3 45     0   57   245 229     58.0   7.0     215.0   84.0   474 256 67 46   3 45     0   57   245 229     58 7   215 84   474
1713272 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000110 406 Jefferson Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   kindergarten 38 12 11   0 9     0   6   45 31     13.0   *     28.0   16.0   76 38 12 11   0 9     0   6   45 31     13     28 16   76
1713273 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000110 406 Jefferson Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   grade_1 49 15 7   0 8     0   10   49 40     14.0   0.0     28.0   21.0   89 49 15 7   0 8     0   10   49 40     14 0   28 21   89
1713274 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000110 406 Jefferson Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   grade_2 48 14 4   1 10     0   11   44 44     12.0   5.0     28.0   20.0   88 48 14 4   1 10     0   11   44 44     12 5   28 20   88
1713275 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000110 406 Jefferson Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   grade_3 54 10 8   0 11     0   12   44 51     7.0   0.0     35.0   24.0   95 54 10 8   0 11     0   12   44 51     7 0   35 24   95
1713276 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000110 406 Jefferson Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   grade_4 51 18 4   1 12     0   10   44 52     10.0   0.0     31.0   26.0   96 51 18 4   1 12     0   10   44 52     10 0   31 26   96
1713277 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000110 406 Jefferson Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   grade_5 51 19 7   0 10     0   6   51 42     6.0   1.0     35.0   18.0   93 51 19 7   0 10     0   6   51 42     6 1   35 18   93
1713278 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000110 406 Jefferson Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   pk_12_total 291 88 41   2 60     0   55   277 260     62.0   7.0     185.0   125.0   537 291 88 41   2 60     0   55   277 260     62 7   185 125   537
1713279 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000111 407 Johnsville Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   kindergarten 54 13 6   0 6     1   8   46 42     5.0   0.0     28.0   13.0   88 54 13 6   0 6     1   8   46 42     5 0   28 13   88
1713280 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000111 407 Johnsville Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   grade_1 60 10 9   0 9     0   9   49 48     12.0   1.0     32.0   17.0   97 60 10 9   0 9     0   9   49 48     12 1   32 17   97
1713281 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000111 407 Johnsville Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   grade_2 67 16 7   0 9     0   12   64 47     12.0   0.0     41.0   27.0   111 67 16 7   0 9     0   12   64 47     12 0   41 27   111
1713282 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000111 407 Johnsville Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   grade_3 65 4 6   1 8     0   7   43 48     9.0   1.0     27.0   18.0   91 65 4 6   1 8     0   7   43 48     9 1   27 18   91
1713283 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000111 407 Johnsville Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   grade_4 66 9 3   1 8     0   6   48 45     7.0   0.0     40.0   24.0   93 66 9 3   1 8     0   6   48 45     7 0   40 24   93
1713284 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000111 407 Johnsville Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   grade_5 68 12 7   0 3     0   12   46 56     3.0   0.0     23.0   18.0   102 68 12 7   0 3     0   12   46 56     3 0   23 18   102
1713285 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000111 407 Johnsville Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   pk_12_total 380 64 38   2 43     1   54   296 286     48.0   2.0     191.0   117.0   582 380 64 38   2 43     1   54   296 286     48 2   191 117   582
1713286 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000112 408 Lincoln Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   kindergarten 29 3 5   1 3     0   6   21 26     3.0   0.0     14.0   13.0   47 29 3 5   1 3     0   6   21 26     3 0   14 13   47
1713287 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000112 408 Lincoln Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   grade_1 33 9 8   0 7     0   5   30 32     10.0   1.0     24.0   18.0   62 33 9 8   0 7     0   5   30 32     10 1   24 18   62
1713288 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000112 408 Lincoln Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   grade_2 45 7 3   0 2     1   6   34 30     8.0   2.0     31.0   20.0   64 45 7 3   0 2     1   6   34 30     8 2   31 20   64
1713289 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000112 408 Lincoln Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   grade_3 39 5 5   0 1     0   11   31 30     3.0   0.0     23.0   12.0   61 39 5 5   0 1     0   11   31 30     3 0   23 12   61
1713290 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000112 408 Lincoln Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   grade_4 41 3 6   1 2     0   8   21 40     5.0   0.0     27.0   13.0   61 41 3 6   1 2     0   8   21 40     5 0   27 13   61
1713291 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000112 408 Lincoln Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   grade_5 52 7 4   1 4     0   4   33 39     4.0   0.0     32.0   16.0   72 52 7 4   1 4     0   4   33 39     4 0   32 16   72
1713292 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000112 408 Lincoln Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   pk_12_total 239 34 31   3 19     1   40   170 197     33.0   3.0     151.0   92.0   367 239 34 31   3 19     1   40   170 197     33 3   151 92   367
1713293 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000113 410 Madison Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   kindergarten 32 7 9   0 10     0   5   31 32     14.0   0.0     21.0   14.0   63 32 7 9   0 10     0   5   31 32     14 0   21 14   63
1713294 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000113 410 Madison Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   grade_1 32 3 10   0 3     0   4   34 18     11.0   0.0     18.0   11.0   52 32 3 10   0 3     0   4   34 18     11 0   18 11   52
1713295 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000113 410 Madison Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   grade_2 43 12 6   0 6     0   3   37 33     11.0   1.0     32.0   14.0   70 43 12 6   0 6     0   3   37 33     11 1   32 14   70
1713296 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000113 410 Madison Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   grade_3 34 12 9   0 10     0   3   44 24     18.0   0.0     29.0   14.0   68 34 12 9   0 10     0   3   44 24     18 0   29 14   68
1713297 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000113 410 Madison Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   grade_4 39 10 11   0 4     0   5   38 31     9.0   0.0     21.0   13.0   69 39 10 11   0 4     0   5   38 31     9 0   21 13   69
1713298 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000113 410 Madison Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   grade_5 43 7 4   1 12     0   4   34 37     2.0   0.0     27.0   16.0   71 43 7 4   1 12     0   4   34 37     2 0   27 16   71
1713299 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000113 410 Madison Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   pk_12_total 223 51 49   1 45     0   24   218 175     65.0   1.0     148.0   82.0   393 223 51 49   1 45     0   24   218 175     65 1   148 82   393
1713300 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000114 411 McKinley Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   kindergarten 78 2 2   0 2     0   6   49 41     1.0   1.0     19.0   9.0   90 78 2 2   0 2     0   6   49 41     1 1   19 9   90
1713301 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000114 411 McKinley Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   grade_1 63 2 5   0 6     0   8   39 45     7.0   0.0     9.0   10.0   84 63 2 5   0 6     0   8   39 45     7 0   9 10   84
1713302 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000114 411 McKinley Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   grade_2 92 1 1   0 4     0   5   47 56     *   0.0     15.0   11.0   103 92 1 1   0 4     0   5   47 56       0   15 11   103
1713303 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000114 411 McKinley Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   grade_3 76 1 0   0 4     0   9   45 45     4.0   0.0     15.0   15.0   90 76 1 0   0 4     0   9   45 45     4 0   15 15   90
1713304 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000114 411 McKinley Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   grade_4 86 2 0   0 6     0   7   50 51     6.0   0.0     20.0   15.0   101 86 2 0   0 6     0   7   50 51     6 0   20 15   101
1713305 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000114 411 McKinley Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   grade_5 84 1 3   0 3     0   10   53 48     3.0   0.0     12.0   13.0   101 84 1 3   0 3     0   10   53 48     3 0   12 13   101
1713306 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000114 411 McKinley Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   pk_12_total 479 9 11   0 25     0   45   283 286     23.0   1.0     90.0   73.0   569 479 9 11   0 25     0   45   283 286     23 1   90 73   569
1713307 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000115 412 Mississippi Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   kindergarten 37 11 2   1 8     0   9   33 35     8.0   2.0     32.0   11.0   68 37 11 2   1 8     0   9   33 35     8 2   32 11   68
1713308 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000115 412 Mississippi Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2021   grade_1 28 10 3   0 3     0   10   25 29     4.0   2.0     21.0   14.0   54 28 10 3   0 3     0   10   25 29     4 2   21 14   54

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