Data source: Big Local News · About: Big Local

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

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
1713335 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000126 418 University Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   pre_kindergarten 18 6 1   0 5     0   1   15 16     0.0   1.0     12.0   0.0   31 18 6 1   0 5     0   1   15 16     0 1   12 0   31
1713336 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000126 418 University Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   kindergarten 47 25 8   0 9     0   9   52 46     10.0   3.0     46.0   16.0   98 47 25 8   0 9     0   9   52 46     10 3   46 16   98
1713337 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000126 418 University Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   grade_1 41 22 4   0 7     0   6   37 43     14.0   5.0     33.0   27.0   80 41 22 4   0 7     0   6   37 43     14 5   33 27   80
1713338 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000126 418 University Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   grade_2 41 29 10   1 4     0   19   55 49     17.0   3.0     50.0   22.0   104 41 29 10   1 4     0   19   55 49     17 3   50 22   104
1713339 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000126 418 University Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   grade_3 63 23 11   0 12     0   9   65 53     12.0   2.0     54.0   23.0   118 63 23 11   0 12     0   9   65 53     12 2   54 23   118
1713340 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000126 418 University Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   grade_4 45 31 5   1 9     0   13   55 49     9.0   6.0     63.0   21.0   104 45 31 5   1 9     0   13   55 49     9 6   63 21   104
1713341 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000126 418 University Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   grade_5 53 25 7   1 8     0   13   54 53     8.0   4.0     47.0   19.0   107 53 25 7   1 8     0   13   54 53     8 4   47 19   107
1713342 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000126 418 University Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   pk_12_total 308 161 46   3 54     0   70   333 309     70.0   24.0     305.0   128.0   642 308 161 46   3 54     0   70   333 309     70 24   305 128   642
1713350 MN Hennepin 27 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000104 421 Evergreen Park Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   pre_kindergarten 12 9 7   1 19     0   5   27 26     0.0   0.0     27.0   0.0   53 12 9 7   1 19     0   5   27 26     0 0   27 0   53
1713351 MN Hennepin 27 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000104 421 Evergreen Park Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   kindergarten 2 17 7   0 19     0   2   26 21     11.0   0.0     28.0   0.0   47 2 17 7   0 19     0   2   26 21     11 0   28 0   47
1713352 MN Hennepin 27 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000104 421 Evergreen Park Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   grade_1 6 22 13   1 17     0   3   30 32     28.0   1.0     37.0   15.0   62 6 22 13   1 17     0   3   30 32     28 1   37 15   62
1713353 MN Hennepin 27 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000104 421 Evergreen Park Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   grade_2 6 28 7   0 31     0   8   30 50     33.0   5.0     59.0   8.0   80 6 28 7   0 31     0   8   30 50     33 5   59 8   80
1713354 MN Hennepin 27 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000104 421 Evergreen Park Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   grade_3 3 22 17   0 23     0   11   45 31     41.0   2.0     44.0   16.0   76 3 22 17   0 23     0   11   45 31     41 2   44 16   76
1713355 MN Hennepin 27 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000104 421 Evergreen Park Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   grade_4 3 23 15   1 20     0   10   35 37     24.0   1.0     48.0   13.0   72 3 23 15   1 20     0   10   35 37     24 1   48 13   72
1713356 MN Hennepin 27 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000104 421 Evergreen Park Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   grade_5 5 26 12   0 23     0   5   39 32     20.0   3.0     53.0   19.0   71 5 26 12   0 23     0   5   39 32     20 3   53 19   71
1713357 MN Hennepin 27 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000104 421 Evergreen Park Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   pk_12_total 37 147 78   3 152     0   44   232 229     157.0   12.0     296.0   71.0   461 37 147 78   3 152     0   44   232 229     157 12   296 71   461
1713435 MN Anoka 2 school 2708100 12 Independent Districts and Schools Centennial Public School District 270810000336 512 Golden Lake Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   kindergarten 35 7 8   0 2     0   6   30 28     11.0   0.0     14.0   5.0   58 35 7 8   0 2     0   6   30 28     11 0   14 5   58
1713436 MN Anoka 2 school 2708100 12 Independent Districts and Schools Centennial Public School District 270810000336 512 Golden Lake Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   grade_1 40 8 7   0 7     0   5   36 31     10.0   0.0     14.0   8.0   67 40 8 7   0 7     0   5   36 31     10 0   14 8   67
1713437 MN Anoka 2 school 2708100 12 Independent Districts and Schools Centennial Public School District 270810000336 512 Golden Lake Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   grade_2 44 5 6   1 11     0   6   33 40     14.0   0.0     20.0   17.0   73 44 5 6   1 11     0   6   33 40     14 0   20 17   73
1713438 MN Anoka 2 school 2708100 12 Independent Districts and Schools Centennial Public School District 270810000336 512 Golden Lake Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   grade_3 49 2 11   0 4     1   4   32 39     5.0   0.0     13.0   11.0   71 49 2 11   0 4     1   4   32 39     5 0   13 11   71
1713439 MN Anoka 2 school 2708100 12 Independent Districts and Schools Centennial Public School District 270810000336 512 Golden Lake Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   grade_4 47 8 5   0 2     0   5   37 30     8.0   1.0     19.0   22.0   67 47 8 5   0 2     0   5   37 30     8 1   19 22   67
1713440 MN Anoka 2 school 2708100 12 Independent Districts and Schools Centennial Public School District 270810000336 512 Golden Lake Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   grade_5 34 5 9   2 4     0   6   31 29     1.0   0.0     15.0   18.0   60 34 5 9   2 4     0   6   31 29     1 0   15 18   60
1713441 MN Anoka 2 school 2708100 12 Independent Districts and Schools Centennial Public School District 270810000336 512 Golden Lake Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   pk_12_total 249 35 46   3 30     1   32   199 197     49.0   1.0     95.0   81.0   396 249 35 46   3 30     1   32   199 197     49 1   95 81   396
1713456 MN Anoka 2 school 2709510 13 Independent Districts and Schools Columbia Heights Public School District 270951000398 515 Highland Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   early_childhood_special_ed 0 3 4   0 0     0   0   6 1     *   *     *   *   7 0 3 4   0 0     0   0   6 1                 7
1713457 MN Anoka 2 school 2709510 13 Independent Districts and Schools Columbia Heights Public School District 270951000398 515 Highland Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   pre_kindergarten 13 12 15   0 4     0   3   24 23     22.0   0.0     *   0.0   47 13 12 15   0 4     0   3   24 23     22 0     0   47
1713458 MN Anoka 2 school 2709510 13 Independent Districts and Schools Columbia Heights Public School District 270951000398 515 Highland Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   kindergarten 12 35 23   2 3     0   8   46 37     36.0   0.0     60.0   15.0   83 12 35 23   2 3     0   8   46 37     36 0   60 15   83
1713459 MN Anoka 2 school 2709510 13 Independent Districts and Schools Columbia Heights Public School District 270951000398 515 Highland Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   grade_1 21 31 24   1 5     0   7   44 45     30.0   *     59.0   12.0   89 21 31 24   1 5     0   7   44 45     30     59 12   89
1713460 MN Anoka 2 school 2709510 13 Independent Districts and Schools Columbia Heights Public School District 270951000398 515 Highland Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   grade_2 15 22 19   1 5     0   6   40 28     36.0   0.0     52.0   7.0   68 15 22 19   1 5     0   6   40 28     36 0   52 7   68
1713461 MN Anoka 2 school 2709510 13 Independent Districts and Schools Columbia Heights Public School District 270951000398 515 Highland Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   grade_3 23 26 20   0 1     0   5   41 34     *   2.0     58.0   12.0   75 23 26 20   0 1     0   5   41 34       2   58 12   75
1713462 MN Anoka 2 school 2709510 13 Independent Districts and Schools Columbia Heights Public School District 270951000398 515 Highland Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   grade_4 13 26 16   1 3     0   7   37 29     25.0   0.0     49.0   9.0   66 13 26 16   1 3     0   7   37 29     25 0   49 9   66
1713463 MN Anoka 2 school 2709510 13 Independent Districts and Schools Columbia Heights Public School District 270951000398 515 Highland Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   grade_5 15 28 26   1 9     0   9   40 48     *   2.0     70.0   17.0   88 15 28 26   1 9     0   9   40 48       2   70 17   88
1713464 MN Anoka 2 school 2709510 13 Independent Districts and Schools Columbia Heights Public School District 270951000398 515 Highland Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   pk_12_total 112 183 147   6 30     0   45   278 245     195.0   5.0     375.0   79.0   523 112 183 147   6 30     0   45   278 245     195 5   375 79   523
1713465 MN Anoka 2 school 2709510 13 Independent Districts and Schools Columbia Heights Public School District 270951000400 517 North Park Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   early_childhood_special_ed 1 3 1   1 0     0   0   0 6     *   *     *   *   6 1 3 1   1 0     0   0   0 6                 6
1713466 MN Anoka 2 school 2709510 13 Independent Districts and Schools Columbia Heights Public School District 270951000400 517 North Park Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   pre_kindergarten 4 13 12   0 1     0   2   13 19     *   0.0     *   0.0   32 4 13 12   0 1     0   2   13 19       0     0   32
1713467 MN Anoka 2 school 2709510 13 Independent Districts and Schools Columbia Heights Public School District 270951000400 517 North Park Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   kindergarten 7 18 15   0 2     0   6   23 25     18.0   *     36.0   8.0   48 7 18 15   0 2     0   6   23 25     18     36 8   48
1713468 MN Anoka 2 school 2709510 13 Independent Districts and Schools Columbia Heights Public School District 270951000400 517 North Park Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   grade_1 14 20 18   0 3     0   6   27 34     24.0   *     49.0   7.0   61 14 20 18   0 3     0   6   27 34     24     49 7   61
1713469 MN Anoka 2 school 2709510 13 Independent Districts and Schools Columbia Heights Public School District 270951000400 517 North Park Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   grade_2 13 18 8   1 1     0   4   21 24     14.0   3.0     36.0   6.0   45 13 18 8   1 1     0   4   21 24     14 3   36 6   45
1713470 MN Anoka 2 school 2709510 13 Independent Districts and Schools Columbia Heights Public School District 270951000400 517 North Park Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   grade_3 22 20 16   0 4     0   5   41 26     *   2.0     51.0   11.0   67 22 20 16   0 4     0   5   41 26       2   51 11   67
1713471 MN Anoka 2 school 2709510 13 Independent Districts and Schools Columbia Heights Public School District 270951000400 517 North Park Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   grade_4 12 23 26   0 4     0   2   27 40     22.0   0.0     52.0   7.0   67 12 23 26   0 4     0   2   27 40     22 0   52 7   67
1713472 MN Anoka 2 school 2709510 13 Independent Districts and Schools Columbia Heights Public School District 270951000400 517 North Park Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   grade_5 17 20 19   0 1     0   8   35 30     *   1.0     53.0   14.0   65 17 20 19   0 1     0   8   35 30       1   53 14   65
1713473 MN Anoka 2 school 2709510 13 Independent Districts and Schools Columbia Heights Public School District 270951000400 517 North Park Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   pk_12_total 90 135 115   2 16     0   33   187 204     134.0   7.0     310.0   59.0   391 90 135 115   2 16     0   33   187 204     134 7   310 59   391
1713474 MN Anoka 2 school 2709510 13 Independent Districts and Schools Columbia Heights Public School District 270951000402 520 Valley View Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   early_childhood_special_ed 2 1 2   0 0     0   0   5 0     *   *     *   *   5 2 1 2   0 0     0   0   5 0                 5
1713475 MN Anoka 2 school 2709510 13 Independent Districts and Schools Columbia Heights Public School District 270951000402 520 Valley View Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   pre_kindergarten 4 3 13   0 4     0   1   10 15     *   0.0     *   0.0   25 4 3 13   0 4     0   1   10 15       0     0   25
1713476 MN Anoka 2 school 2709510 13 Independent Districts and Schools Columbia Heights Public School District 270951000402 520 Valley View Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   kindergarten 11 18 32   0 5     0   5   27 44     34.0   *     52.0   4.0   71 11 18 32   0 5     0   5   27 44     34     52 4   71
1713477 MN Anoka 2 school 2709510 13 Independent Districts and Schools Columbia Heights Public School District 270951000402 520 Valley View Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   grade_1 10 13 34   0 3     0   5   36 29     35.0   0.0     49.0   9.0   65 10 13 34   0 3     0   5   36 29     35 0   49 9   65
1713478 MN Anoka 2 school 2709510 13 Independent Districts and Schools Columbia Heights Public School District 270951000402 520 Valley View Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   grade_2 10 16 39   3 0     0   5   44 29     42.0   2.0     60.0   5.0   73 10 16 39   3 0     0   5   44 29     42 2   60 5   73
1713479 MN Anoka 2 school 2709510 13 Independent Districts and Schools Columbia Heights Public School District 270951000402 520 Valley View Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   grade_3 6 17 37   0 0     0   5   33 32     36.0   0.0     53.0   12.0   65 6 17 37   0 0     0   5   33 32     36 0   53 12   65
1713480 MN Anoka 2 school 2709510 13 Independent Districts and Schools Columbia Heights Public School District 270951000402 520 Valley View Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   grade_4 10 16 44   0 4     0   8   38 44     39.0   1.0     65.0   13.0   82 10 16 44   0 4     0   8   38 44     39 1   65 13   82
1713481 MN Anoka 2 school 2709510 13 Independent Districts and Schools Columbia Heights Public School District 270951000402 520 Valley View Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   grade_5 11 14 44   0 1     0   4   37 37     28.0   1.0     53.0   15.0   74 11 14 44   0 1     0   4   37 37     28 1   53 15   74
1713482 MN Anoka 2 school 2709510 13 Independent Districts and Schools Columbia Heights Public School District 270951000402 520 Valley View Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   pk_12_total 64 98 245   3 17     0   33   230 230     228.0   5.0     353.0   63.0   460 64 98 245   3 17     0   33   230 230     228 5   353 63   460
1713483 MN Anoka 2 school 2712420 14 Independent Districts and Schools Fridley Public School District 271242005082 6 Voluntary Prekindergarten School Elementary School (Grades PK-6) Regular School No Prekindergarten PK PK 2021   early_childhood_special_ed 6 4 2   0 2     0   1   9 6     0.0   0.0     7.0   *   15 6 4 2   0 2     0   1   9 6     0 0   7     15
1713484 MN Anoka 2 school 2712420 14 Independent Districts and Schools Fridley Public School District 271242005082 6 Voluntary Prekindergarten School Elementary School (Grades PK-6) Regular School No Prekindergarten PK PK 2021   pre_kindergarten 34 31 10   1 10     0   8   44 50     0.0   0.0     42.0   0.0   94 34 31 10   1 10     0   8   44 50     0 0   42 0   94
1713485 MN Anoka 2 school 2712420 14 Independent Districts and Schools Fridley Public School District 271242005082 6 Voluntary Prekindergarten School Elementary School (Grades PK-6) Regular School No Prekindergarten PK PK 2021   pk_12_total 40 35 12   1 12     0   9   53 56     0.0   0.0     49.0   15.0   109 40 35 12   1 12     0   9   53 56     0 0   49 15   109
1713486 MN Anoka 2 school 2712420 14 Independent Districts and Schools Fridley Public School District 271242000612 546 Hayes Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 04 2021   kindergarten 34 42 8   0 7     0   10   47 54     16.0   0.0     57.0   8.0   101 34 42 8   0 7     0   10   47 54     16 0   57 8   101
1713487 MN Anoka 2 school 2712420 14 Independent Districts and Schools Fridley Public School District 271242000612 546 Hayes Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 04 2021   grade_1 33 39 11   2 5     0   6   49 47     13.0   1.0     58.0   14.0   96 33 39 11   2 5     0   6   49 47     13 1   58 14   96
1713488 MN Anoka 2 school 2712420 14 Independent Districts and Schools Fridley Public School District 271242000612 546 Hayes Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 04 2021   grade_2 27 35 17   0 7     0   10   43 53     22.0   1.0     60.0   14.0   96 27 35 17   0 7     0   10   43 53     22 1   60 14   96
1713489 MN Anoka 2 school 2712420 14 Independent Districts and Schools Fridley Public School District 271242000612 546 Hayes Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 04 2021   grade_3 22 39 7   4 5     0   9   42 44     19.0   0.0     56.0   14.0   86 22 39 7   4 5     0   9   42 44     19 0   56 14   86
1713490 MN Anoka 2 school 2712420 14 Independent Districts and Schools Fridley Public School District 271242000612 546 Hayes Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 04 2021   grade_4 30 40 15   0 2     0   13   44 56     19.0   3.0     50.0   17.0   100 30 40 15   0 2     0   13   44 56     19 3   50 17   100
1713491 MN Anoka 2 school 2712420 14 Independent Districts and Schools Fridley Public School District 271242000612 546 Hayes Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 04 2021   pk_12_total 146 195 58   6 26     0   48   225 254     89.0   5.0     281.0   67.0   479 146 195 58   6 26     0   48   225 254     89 5   281 67   479
1713492 MN Anoka 2 school 2712420 14 Independent Districts and Schools Fridley Public School District 271242000614 550 Stevenson Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 04 2021   kindergarten 27 34 12   0 5     0   17   44 51     0.0   1.0     54.0   6.0   95 27 34 12   0 5     0   17   44 51     0 1   54 6   95
1713493 MN Anoka 2 school 2712420 14 Independent Districts and Schools Fridley Public School District 271242000614 550 Stevenson Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 04 2021   grade_1 22 44 15   1 8     0   14   46 58     10.0   1.0     61.0   17.0   104 22 44 15   1 8     0   14   46 58     10 1   61 17   104
1713494 MN Anoka 2 school 2712420 14 Independent Districts and Schools Fridley Public School District 271242000614 550 Stevenson Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 04 2021   grade_2 21 33 20   1 6     0   11   43 49     19.0   0.0     58.0   8.0   92 21 33 20   1 6     0   11   43 49     19 0   58 8   92
1713495 MN Anoka 2 school 2712420 14 Independent Districts and Schools Fridley Public School District 271242000614 550 Stevenson Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 04 2021   grade_3 27 33 13   1 7     0   9   48 42     13.0   1.0     58.0   14.0   90 27 33 13   1 7     0   9   48 42     13 1   58 14   90
1713496 MN Anoka 2 school 2712420 14 Independent Districts and Schools Fridley Public School District 271242000614 550 Stevenson Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 04 2021   grade_4 23 38 15   0 11     0   4   50 41     19.0   4.0     62.0   10.0   91 23 38 15   0 11     0   4   50 41     19 4   62 10   91
1713497 MN Anoka 2 school 2712420 14 Independent Districts and Schools Fridley Public School District 271242000614 550 Stevenson Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 04 2021   pk_12_total 120 182 75   3 37     0   55   231 241     61.0   7.0     293.0   55.0   472 120 182 75   3 37     0   55   231 241     61 7   293 55   472

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