Data source: Big Local News · About: Big Local

14,034 rows where state = "MN" and year = 2020 sorted by ccd_school_lvl

View and edit SQL

year

  • 2020 · 14,034
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
1826779 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 2020   early_childhood_special_ed 17.0 0.0 0.0   0.0 0.0     0.0   1.0   14.0 4.0     0.0   0.0     14.0   *   18.0 17 0 0   0 0     0   1   14 4     0 0   14     18
1826780 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 2020   kindergarten 55.0 1.0 2.0   0.0 0.0     0.0   6.0   32.0 32.0     0.0   1.0     25.0   12.0   64.0 55 1 2   0 0     0   6   32 32     0 1   25 12   64
1826781 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 2020   grade_1 55.0 2.0 1.0   0.0 0.0     0.0   4.0   23.0 39.0     0.0   0.0     32.0   9.0   62.0 55 2 1   0 0     0   4   23 39     0 0   32 9   62
1826782 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 2020   grade_2 86.0 1.0 4.0   1.0 1.0     0.0   5.0   56.0 42.0     0.0   0.0     36.0   16.0   98.0 86 1 4   1 1     0   5   56 42     0 0   36 16   98
1826783 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 2020   grade_3 70.0 0.0 3.0   2.0 1.0     0.0   2.0   41.0 37.0     0.0   0.0     37.0   16.0   78.0 70 0 3   2 1     0   2   41 37     0 0   37 16   78
1826784 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 2020   grade_4 80.0 1.0 1.0   1.0 1.0     0.0   2.0   49.0 37.0     0.0   1.0     45.0   13.0   86.0 80 1 1   1 1     0   2   49 37     0 1   45 13   86
1826785 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 2020   grade_5 78.0 1.0 0.0   1.0 0.0     0.0   2.0   48.0 34.0     0.0   1.0     38.0   15.0   82.0 78 1 0   1 0     0   2   48 34     0 1   38 15   82
1826786 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 2020   grade_6 91.0 2.0 1.0   1.0 2.0     0.0   3.0   47.0 53.0     1.0   0.0     41.0   21.0   100.0 91 2 1   1 2     0   3   47 53     1 0   41 21   100
1826787 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 2020   pk_12_total 532.0 8.0 12.0   6.0 5.0     0.0   25.0   310.0 278.0     1.0   3.0     268.0   120.0   588.0 532 8 12   6 5     0   25   310 278     1 3   268 120   588
1826788 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 2020   early_childhood_special_ed 2.0 0.0 0.0   0.0 0.0     0.0   1.0   3.0 0.0     *   *         *   3.0 2 0 0   0 0     0   1   3 0                 3
1826789 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 2020   pre_kindergarten 12.0 0.0 0.0   0.0 0.0     0.0   0.0   6.0 6.0     *   *         0.0   12.0 12 0 0   0 0     0   0   6 6             0   12
1826790 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 2020   kindergarten 15.0 0.0 0.0   0.0 0.0     0.0   1.0   12.0 4.0     0.0   0.0     10.0   3.0   16.0 15 0 0   0 0     0   1   12 4     0 0   10 3   16
1826791 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 2020   grade_1 10.0 0.0 1.0   1.0 0.0     0.0   1.0   5.0 8.0     0.0   0.0     11.0   2.0   13.0 10 0 1   1 0     0   1   5 8     0 0   11 2   13
1826792 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 2020   grade_2 18.0 0.0 0.0   1.0 0.0     0.0   1.0   10.0 10.0     0.0   0.0     9.0   4.0   20.0 18 0 0   1 0     0   1   10 10     0 0   9 4   20
1826793 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 2020   grade_3 15.0 0.0 1.0   0.0 0.0     0.0   0.0   8.0 8.0     0.0   0.0     10.0   4.0   16.0 15 0 1   0 0     0   0   8 8     0 0   10 4   16
1826794 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 2020   grade_4 20.0 1.0 1.0   0.0 0.0     0.0   0.0   8.0 14.0     0.0   0.0     14.0   9.0   22.0 20 1 1   0 0     0   0   8 14     0 0   14 9   22
1826795 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 2020   pk_12_total 92.0 1.0 3.0   2.0 0.0     0.0   4.0   52.0 50.0     0.0   0.0     61.0   25.0   102.0 92 1 3   2 0     0   4   52 50     0 0   61 25   102
1826796 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 2020   early_childhood_special_ed 7.0 0.0 0.0   9.0 0.0     0.0   0.0   10.0 6.0     *   0.0     4.0   *   16.0 7 0 0   9 0     0   0   10 6       0   4     16
1826797 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 2020   pre_kindergarten 17.0 0.0 0.0   1.0 0.0     0.0   0.0   9.0 9.0     0.0   0.0     3.0   0.0   18.0 17 0 0   1 0     0   0   9 9     0 0   3 0   18
1826798 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 2020   kindergarten 26.0 0.0 1.0   10.0 0.0     0.0   0.0   19.0 18.0     0.0   0.0     15.0   11.0   37.0 26 0 1   10 0     0   0   19 18     0 0   15 11   37
1826799 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 2020   grade_1 25.0 0.0 0.0   9.0 0.0     0.0   1.0   22.0 13.0     0.0   0.0     14.0   14.0   35.0 25 0 0   9 0     0   1   22 13     0 0   14 14   35
1826800 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 2020   grade_2 10.0 0.0 1.0   12.0 0.0     0.0   0.0   13.0 10.0     0.0   0.0     14.0   7.0   23.0 10 0 1   12 0     0   0   13 10     0 0   14 7   23
1826801 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 2020   grade_3 15.0 0.0 0.0   12.0 0.0     0.0   0.0   14.0 13.0     0.0   0.0     8.0   8.0   27.0 15 0 0   12 0     0   0   14 13     0 0   8 8   27
1826802 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 2020   grade_4 28.0 0.0 1.0   13.0 0.0     0.0   0.0   17.0 25.0     0.0   0.0     23.0   11.0   42.0 28 0 1   13 0     0   0   17 25     0 0   23 11   42
1826803 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 2020   grade_5 27.0 0.0 1.0   13.0 0.0     0.0   1.0   20.0 22.0     0.0   0.0     17.0   13.0   42.0 27 0 1   13 0     0   1   20 22     0 0   17 13   42
1826804 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 2020   grade_6 23.0 0.0 0.0   11.0 0.0     0.0   1.0   19.0 16.0     0.0   0.0     25.0   11.0   35.0 23 0 0   11 0     0   1   19 16     0 0   25 11   35
1826805 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 2020   pk_12_total 178.0 0.0 4.0   90.0 0.0     0.0   3.0   143.0 132.0     *   0.0     123.0   91.0   275.0 178 0 4   90 0     0   3   143 132       0   123 91   275
1826806 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 2020   pre_kindergarten 14.0 5.0 1.0   0.0 4.0     0.0   1.0   8.0 17.0     1.0   0.0     14.0   0.0   25.0 14 5 1   0 4     0   1   8 17     1 0   14 0   25
1826807 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 2020   kindergarten 46.0 16.0 3.0   1.0 11.0     1.0   7.0   34.0 51.0     20.0   0.0     43.0   14.0   85.0 46 16 3   1 11     1   7   34 51     20 0   43 14   85
1826808 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 2020   grade_1 39.0 20.0 2.0   0.0 16.0     0.0   13.0   51.0 39.0     18.0   4.0     48.0   18.0   90.0 39 20 2   0 16     0   13   51 39     18 4   48 18   90
1826809 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 2020   grade_2 24.0 12.0 7.0   1.0 7.0     0.0   10.0   37.0 24.0     23.0   4.0     37.0   9.0   61.0 24 12 7   1 7     0   10   37 24     23 4   37 9   61
1826810 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 2020   grade_3 39.0 29.0 8.0   0.0 6.0     0.0   10.0   50.0 42.0     15.0   6.0     61.0   17.0   92.0 39 29 8   0 6     0   10   50 42     15 6   61 17   92
1826811 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 2020   grade_4 33.0 19.0 16.0   3.0 9.0     0.0   10.0   45.0 45.0     30.0   2.0     66.0   15.0   90.0 33 19 16   3 9     0   10   45 45     30 2   66 15   90
1826812 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 2020   grade_5 36.0 20.0 6.0   1.0 9.0     0.0   6.0   33.0 45.0     13.0   3.0     44.0   22.0   78.0 36 20 6   1 9     0   6   33 45     13 3   44 22   78
1826813 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 2020   pk_12_total 231.0 121.0 43.0   6.0 62.0     1.0   57.0   258.0 263.0     120.0   19.0     313.0   95.0   521.0 231 121 43   6 62     1   57   258 263     120 19   313 95   521
1826814 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 2020   kindergarten 64.0 4.0 3.0   0.0 4.0     0.0   4.0   39.0 40.0     6.0   2.0     19.0   13.0   79.0 64 4 3   0 4     0   4   39 40     6 2   19 13   79
1826815 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 2020   grade_1 50.0 4.0 3.0   0.0 1.0     0.0   7.0   36.0 29.0     0.0   *     23.0   12.0   65.0 50 4 3   0 1     0   7   36 29     0     23 12   65
1826816 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 2020   grade_2 61.0 4.0 2.0   0.0 2.0     0.0   5.0   43.0 31.0     5.0   *     19.0   13.0   74.0 61 4 2   0 2     0   5   43 31     5     19 13   74
1826817 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 2020   grade_3 62.0 7.0 5.0   0.0 1.0     0.0   4.0   48.0 31.0     5.0   0.0     27.0   20.0   79.0 62 7 5   0 1     0   4   48 31     5 0   27 20   79
1826818 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 2020   grade_4 50.0 2.0 5.0   2.0 6.0     0.0   4.0   43.0 26.0     6.0   0.0     23.0   19.0   69.0 50 2 5   2 6     0   4   43 26     6 0   23 19   69
1826819 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 2020   grade_5 46.0 6.0 5.0   1.0 3.0     0.0   7.0   36.0 32.0     3.0   0.0     24.0   14.0   68.0 46 6 5   1 3     0   7   36 32     3 0   24 14   68
1826820 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 2020   pk_12_total 333.0 27.0 23.0   3.0 17.0     0.0   31.0   245.0 189.0     25.0   4.0     135.0   91.0   434.0 333 27 23   3 17     0   31   245 189     25 4   135 91   434
1826821 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 2020   kindergarten 21.0 13.0 8.0   0.0 2.0     0.0   9.0   17.0 36.0     7.0   *     30.0   4.0   53.0 21 13 8   0 2     0   9   17 36     7     30 4   53
1826822 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 2020   grade_1 37.0 12.0 8.0   2.0 4.0     1.0   14.0   36.0 42.0     11.0   2.0     44.0   16.0   78.0 37 12 8   2 4     1   14   36 42     11 2   44 16   78
1826823 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 2020   grade_2 27.0 9.0 8.0   2.0 0.0     0.0   2.0   26.0 22.0     8.0   *     31.0   12.0   48.0 27 9 8   2 0     0   2   26 22     8     31 12   48
1826824 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 2020   grade_3 38.0 21.0 6.0   1.0 0.0     0.0   8.0   33.0 41.0     8.0   2.0     48.0   17.0   74.0 38 21 6   1 0     0   8   33 41     8 2   48 17   74
1826825 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 2020   grade_4 29.0 8.0 8.0   1.0 2.0     0.0   4.0   25.0 27.0     7.0   2.0     28.0   15.0   52.0 29 8 8   1 2     0   4   25 27     7 2   28 15   52
1826826 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 2020   grade_5 30.0 16.0 5.0   1.0 2.0     0.0   8.0   35.0 27.0     6.0   2.0     38.0   17.0   62.0 30 16 5   1 2     0   8   35 27     6 2   38 17   62
1826827 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 2020   pk_12_total 182.0 79.0 43.0   7.0 10.0     1.0   45.0   172.0 195.0     47.0   10.0     219.0   81.0   367.0 182 79 43   7 10     1   45   172 195     47 10   219 81   367
1826828 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 2020   kindergarten 30.0 14.0 4.0   0.0 11.0     0.0   11.0   43.0 27.0     12.0   1.0     40.0   12.0   70.0 30 14 4   0 11     0   11   43 27     12 1   40 12   70
1826829 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 2020   grade_1 38.0 13.0 9.0   1.0 9.0     0.0   14.0   43.0 41.0     19.0   3.0     51.0   21.0   84.0 38 13 9   1 9     0   14   43 41     19 3   51 21   84
1826830 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 2020   grade_2 42.0 17.0 7.0   1.0 8.0     0.0   3.0   45.0 33.0     18.0   3.0     51.0   18.0   78.0 42 17 7   1 8     0   3   45 33     18 3   51 18   78
1826831 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 2020   grade_3 31.0 11.0 6.0   0.0 9.0     0.0   9.0   37.0 29.0     16.0   2.0     41.0   17.0   66.0 31 11 6   0 9     0   9   37 29     16 2   41 17   66
1826832 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 2020   grade_4 35.0 9.0 5.0   1.0 7.0     0.0   4.0   36.0 25.0     9.0   2.0     38.0   16.0   61.0 35 9 5   1 7     0   4   36 25     9 2   38 16   61
1826833 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 2020   grade_5 30.0 14.0 6.0   0.0 8.0     1.0   7.0   37.0 29.0     9.0   2.0     43.0   13.0   66.0 30 14 6   0 8     1   7   37 29     9 2   43 13   66
1826834 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 2020   pk_12_total 206.0 78.0 37.0   3.0 52.0     1.0   48.0   241.0 184.0     83.0   13.0     264.0   97.0   425.0 206 78 37   3 52     1   48   241 184     83 13   264 97   425
1826835 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 2020   kindergarten 44.0 13.0 9.0   2.0 6.0     0.0   11.0   47.0 38.0     11.0   *     41.0   17.0   85.0 44 13 9   2 6     0   11   47 38     11     41 17   85
1826836 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 2020   grade_1 48.0 11.0 5.0   0.0 11.0     0.0   13.0   48.0 40.0     13.0   1.0     42.0   18.0   88.0 48 11 5   0 11     0   13   48 40     13 1   42 18   88
1826837 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 2020   grade_2 39.0 10.0 11.0   0.0 9.0     0.0   13.0   36.0 46.0     15.0   3.0     45.0   6.0   82.0 39 10 11   0 9     0   13   36 46     15 3   45 6   82
1826838 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 2020   grade_3 49.0 12.0 4.0   1.0 9.0     0.0   9.0   39.0 45.0     9.0   5.0     46.0   14.0   84.0 49 12 4   1 9     0   9   39 45     9 5   46 14   84
1826839 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 2020   grade_4 40.0 9.0 7.0   0.0 4.0     0.0   12.0   40.0 32.0     5.0   *     35.0   15.0   72.0 40 9 7   0 4     0   12   40 32     5     35 15   72
1826840 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 2020   grade_5 35.0 15.0 4.0   0.0 6.0     0.0   5.0   35.0 30.0     10.0   1.0     42.0   9.0   65.0 35 15 4   0 6     0   5   35 30     10 1   42 9   65
1826841 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 2020   pk_12_total 255.0 70.0 40.0   3.0 45.0     0.0   63.0   245.0 231.0     63.0   12.0     251.0   79.0   476.0 255 70 40   3 45     0   63   245 231     63 12   251 79   476
1826842 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 2020   kindergarten 56.0 15.0 5.0   0.0 8.0     0.0   12.0   55.0 41.0     14.0   0.0     32.0   22.0   96.0 56 15 5   0 8     0   12   55 41     14 0   32 22   96
1826843 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 2020   grade_1 61.0 11.0 3.0   1.0 9.0     0.0   11.0   50.0 46.0     10.0   5.0     33.0   25.0   96.0 61 11 3   1 9     0   11   50 46     10 5   33 25   96
1826844 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 2020   grade_2 56.0 9.0 7.0   0.0 9.0     0.0   12.0   46.0 47.0     8.0   1.0     31.0   21.0   93.0 56 9 7   0 9     0   12   46 47     8 1   31 21   93
1826845 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 2020   grade_3 59.0 16.0 4.0   1.0 11.0     0.0   9.0   45.0 55.0     15.0   0.0     37.0   29.0   100.0 59 16 4   1 11     0   9   45 55     15 0   37 29   100
1826846 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 2020   grade_4 55.0 19.0 7.0   0.0 10.0     0.0   5.0   50.0 46.0     15.0   2.0     35.0   23.0   96.0 55 19 7   0 10     0   5   50 46     15 2   35 23   96
1826847 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 2020   grade_5 60.0 16.0 2.0   0.0 8.0     0.0   9.0   53.0 42.0     6.0   1.0     31.0   27.0   95.0 60 16 2   0 8     0   9   53 42     6 1   31 27   95
1826848 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 2020   pk_12_total 347.0 86.0 28.0   2.0 55.0     0.0   58.0   299.0 277.0     68.0   9.0     199.0   147.0   576.0 347 86 28   2 55     0   58   299 277     68 9   199 147   576
1826849 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 2020   kindergarten 70.0 11.0 6.0   1.0 8.0     0.0   9.0   52.0 53.0     13.0   5.0     35.0   18.0   105.0 70 11 6   1 8     0   9   52 53     13 5   35 18   105
1826850 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 2020   grade_1 64.0 14.0 9.0   0.0 10.0     0.0   11.0   63.0 45.0     11.0   2.0     45.0   26.0   108.0 64 14 9   0 10     0   11   63 45     11 2   45 26   108
1826851 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 2020   grade_2 64.0 6.0 7.0   1.0 8.0     0.0   10.0   50.0 46.0     8.0   1.0     33.0   20.0   96.0 64 6 7   1 8     0   10   50 46     8 1   33 20   96
1826852 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 2020   grade_3 66.0 10.0 3.0   0.0 7.0     0.0   8.0   48.0 46.0     5.0   2.0     44.0   20.0   94.0 66 10 3   0 7     0   8   48 46     5 2   44 20   94
1826853 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 2020   grade_4 71.0 8.0 8.0   0.0 3.0     0.0   15.0   46.0 59.0     8.0   3.0     30.0   19.0   105.0 71 8 8   0 3     0   15   46 59     8 3   30 19   105
1826854 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 2020   grade_5 63.0 14.0 2.0   0.0 7.0     0.0   9.0   50.0 45.0     2.0   1.0     36.0   13.0   95.0 63 14 2   0 7     0   9   50 45     2 1   36 13   95
1826855 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 2020   pk_12_total 398.0 63.0 35.0   2.0 43.0     0.0   62.0   309.0 294.0     47.0   14.0     223.0   116.0   603.0 398 63 35   2 43     0   62   309 294     47 14   223 116   603
1826856 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 2020   kindergarten 34.0 6.0 7.0   0.0 8.0     0.0   7.0   30.0 32.0     9.0   0.0     26.0   17.0   62.0 34 6 7   0 8     0   7   30 32     9 0   26 17   62
1826857 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 2020   grade_1 49.0 6.0 4.0   0.0 3.0     1.0   7.0   36.0 34.0     10.0   2.0     28.0   22.0   70.0 49 6 4   0 3     1   7   36 34     10 2   28 22   70
1826858 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 2020   grade_2 53.0 9.0 4.0   0.0 1.0     0.0   14.0   39.0 42.0     3.0   1.0     39.0   14.0   81.0 53 9 4   0 1     0   14   39 42     3 1   39 14   81
1826859 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 2020   grade_3 48.0 4.0 6.0   2.0 3.0     0.0   5.0   30.0 38.0     5.0   1.0     30.0   22.0   68.0 48 4 6   2 3     0   5   30 38     5 1   30 22   68
1826860 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 2020   grade_4 49.0 7.0 5.0   1.0 4.0     0.0   3.0   29.0 40.0     8.0   1.0     30.0   14.0   69.0 49 7 5   1 4     0   3   29 40     8 1   30 14   69
1826861 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 2020   grade_5 45.0 3.0 6.0   0.0 1.0     0.0   6.0   34.0 27.0     0.0   0.0     24.0   9.0   61.0 45 3 6   0 1     0   6   34 27     0 0   24 9   61
1826862 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 2020   pk_12_total 278.0 35.0 32.0   3.0 20.0     1.0   42.0   198.0 213.0     35.0   5.0     177.0   98.0   411.0 278 35 32   3 20     1   42   198 213     35 5   177 98   411
1826863 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 2020   kindergarten 41.0 4.0 11.0   0.0 3.0     0.0   6.0   41.0 24.0     13.0   1.0     29.0   13.0   65.0 41 4 11   0 3     0   6   41 24     13 1   29 13   65
1826864 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 2020   grade_1 47.0 9.0 6.0   0.0 7.0     0.0   2.0   35.0 36.0     15.0   1.0     33.0   15.0   71.0 47 9 6   0 7     0   2   35 36     15 1   33 15   71
1826865 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 2020   grade_2 40.0 10.0 10.0   0.0 9.0     0.0   3.0   47.0 25.0     19.0   0.0     35.0   17.0   72.0 40 10 10   0 9     0   3   47 25     19 0   35 17   72
1826866 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 2020   grade_3 45.0 9.0 11.0   0.0 5.0     0.0   3.0   38.0 35.0     14.0   1.0     30.0   13.0   73.0 45 9 11   0 5     0   3   38 35     14 1   30 13   73
1826867 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 2020   grade_4 40.0 7.0 4.0   1.0 13.0     0.0   4.0   36.0 33.0     4.0   0.0     30.0   16.0   69.0 40 7 4   1 13     0   4   36 33     4 0   30 16   69
1826868 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 2020   grade_5 45.0 4.0 10.0   2.0 4.0     0.0   5.0   37.0 33.0     5.0   1.0     22.0   11.0   70.0 45 4 10   2 4     0   5   37 33     5 1   22 11   70
1826869 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 2020   pk_12_total 258.0 43.0 52.0   3.0 41.0     0.0   23.0   234.0 186.0     70.0   4.0     179.0   85.0   420.0 258 43 52   3 41     0   23   234 186     70 4   179 85   420
1826870 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 2020   kindergarten 68.0 0.0 4.0   0.0 4.0     0.0   8.0   42.0 42.0     5.0   0.0     8.0   14.0   84.0 68 0 4   0 4     0   8   42 42     5 0   8 14   84
1826871 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 2020   grade_1 95.0 1.0 2.0   0.0 4.0     0.0   4.0   50.0 56.0     *   0.0         10.0   106.0 95 1 2   0 4     0   4   50 56       0     10   106
1826872 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 2020   grade_2 81.0 1.0 0.0   1.0 3.0     0.0   9.0   49.0 46.0     3.0   0.0     13.0   15.0   95.0 81 1 0   1 3     0   9   49 46     3 0   13 15   95
1826873 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 2020   grade_3 90.0 2.0 0.0   0.0 6.0     0.0   7.0   51.0 54.0     4.0   1.0     20.0   13.0   105.0 90 2 0   0 6     0   7   51 54     4 1   20 13   105
1826874 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 2020   grade_4 85.0 0.0 2.0   0.0 2.0     0.0   11.0   50.0 50.0     *   1.0         14.0   100.0 85 0 2   0 2     0   11   50 50       1     14   100
1826875 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 2020   grade_5 120.0 0.0 1.0   1.0 2.0     0.0   5.0   81.0 48.0     2.0   1.0     16.0   14.0   129.0 120 0 1   1 2     0   5   81 48     2 1   16 14   129
1826876 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 2020   pk_12_total 539.0 4.0 9.0   2.0 21.0     0.0   44.0   323.0 296.0     18.0   3.0     83.0   80.0   619.0 539 4 9   2 21     0   44   323 296     18 3   83 80   619
1826877 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 2020   kindergarten 35.0 10.0 3.0   0.0 2.0     0.0   9.0   30.0 29.0     4.0   1.0     25.0   13.0   59.0 35 10 3   0 2     0   9   30 29     4 1   25 13   59
1826878 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 2020   grade_1 44.0 6.0 3.0   0.0 6.0     0.0   12.0   37.0 34.0     5.0   1.0     33.0   15.0   71.0 44 6 3   0 6     0   12   37 34     5 1   33 15   71

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