enrollments

Data source: Big Local News · About: Big Local

694 rows where grade = "grade_7", state = "MN" and year = 2020 sorted by district_state_id

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2020 · 694 ✖

grade ✖

  • grade_7 · 694 ✖
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
1825222 1825222 MN Aitkin 1 school 2702760 1 Independent Districts and Schools Aitkin Public School District 270276000057 1 Aitkin Secondary School Secondary School (Grades 7-12) Regular School No High 07 12 2020   grade_7 92.0 1.0 3.0   0.0 0.0     0.0   2.0   53.0 45.0     0.0   1.0     43.0   13.0   98.0 92 1 3   0 0     0   2   53 45     0 1   43 13   98
1826519 1826519 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124004903 390 Heritage STEM Academy Secondary School (Grades 7-12) Regular School No High 06 12 2020   grade_7 0.0 13.0 0.0   0.0 0.0     0.0   0.0   5.0 8.0     5.0   1.0         0.0   13.0 0 13 0   0 0     0   0   5 8     5 1     0   13
1832643 1832643 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124000942 106 Barton Open Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 08 2020   grade_7 36.0 30.0 4.0   1.0 0.0     0.0   7.0   43.0 35.0     15.0   1.0     37.0   7.0   78.0 36 30 4   1 0     0   7   43 35     15 1   37 7   78
1832665 1832665 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124000969 121 Lake Harriet Upper School Elementary School (Grades PK-6) Regular School No Middle 04 08 2020   grade_7 98.0 3.0 5.0   0.0 8.0     0.0   7.0   72.0 49.0     4.0   2.0     14.0   9.0   121.0 98 3 5   0 8     0   7   72 49     4 2   14 9   121
1832686 1832686 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124000988 134 Lake Nokomis Comm-Keewaydin Campus Elementary School (Grades PK-6) Regular School No Middle 03 08 2020   grade_7 43.0 13.0 14.0   1.0 1.0     0.0   4.0   44.0 32.0     6.0   3.0     38.0   18.0   76.0 43 13 14   1 1     0   4   44 32     6 3   38 18   76
1832755 1832755 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124001031 160 Seward Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 08 2020   grade_7 28.0 48.0 4.0   4.0 2.0     0.0   0.0   42.0 44.0     18.0   0.0     55.0   12.0   86.0 28 48 4   4 2     0   0   42 44     18 0   55 12   86
1832793 1832793 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124001866 175 Folwell Arts Magnet Elementary School (Grades PK-6) Regular School No Elementary PK 08 2020   grade_7 9.0 18.0 58.0   5.0 0.0     1.0   2.0   49.0 44.0     29.0   *     77.0   22.0   93.0 9 18 58   5 0     1   2   49 44     29     77 22   93
1832805 1832805 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124000986 179 Jefferson Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 08 2020   grade_7 1.0 15.0 22.0   1.0 6.0     1.0   1.0   18.0 29.0     20.0   4.0     42.0   7.0   47.0 1 15 22   1 6     1   1   18 29     20 4   42 7   47
1832824 1832824 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124000932 190 Andersen Community Elementary School (Grades PK-6) Regular School No Elementary PK 08 2020   grade_7 3.0 27.0 55.0   3.0 2.0     0.0   1.0   48.0 43.0     43.0   5.0         22.0   91.0 3 27 55   3 2     0   1   48 43     43 5     22   91
1832836 1832836 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124002297 193 Sullivan Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 08 2020   grade_7 1.0 40.0 4.0   6.0 0.0     0.0   1.0   25.0 27.0     19.0   3.0     42.0   11.0   52.0 1 40 4   6 0     0   1   25 27     19 3   42 11   52
1832862 1832862 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124002144 226 Marcy Open Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 08 2020   grade_7 42.0 39.0 9.0   2.0 2.0     0.0   3.0   49.0 48.0     12.0   2.0     42.0   16.0   97.0 42 39 9   2 2     0   3   49 48     12 2   42 16   97
1832937 1832937 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124004239 291 Hmong International Academy Elementary School (Grades PK-6) Regular School No Elementary PK 08 2020   grade_7 1.0 33.0 4.0   1.0 23.0     0.0   0.0   26.0 36.0     30.0   1.0     53.0   16.0   62.0 1 33 4   1 23     0   0   26 36     30 1   53 16   62
1835022 1835022 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124000965 119 Field Community Middle School (Grades 5-8) Regular School No Middle 05 08 2020   grade_7 82.0 15.0 11.0   2.0 2.0     0.0   2.0   41.0 73.0     5.0   0.0     21.0   12.0   114.0 82 15 11   2 2     0   2   41 73     5 0   21 12   114
1835026 1835026 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124000936 300 Anthony Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2020   grade_7 128.0 71.0 31.0   1.0 8.0     1.0   11.0   126.0 125.0     24.0   1.0     95.0   31.0   251.0 128 71 31   1 8     1   11   126 125     24 1   95 31   251
1835030 1835030 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124000937 309 Anwatin Middle Com & Spanish D I Middle School (Grades 5-8) Regular School No Middle 06 08 2020   grade_7 32.0 68.0 67.0   4.0 15.0     0.0   8.0   97.0 97.0     39.0   6.0     126.0   36.0   194.0 32 68 67   4 15     0   8   97 97     39 6   126 36   194
1835034 1835034 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124001008 316 Northeast Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2020   grade_7 33.0 75.0 36.0   10.0 5.0     0.0   6.0   83.0 82.0     27.0   7.0     124.0   43.0   165.0 33 75 36   10 5     0   6   83 82     27 7   124 43   165
1835038 1835038 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124002581 318 Olson Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2020   grade_7 22.0 83.0 13.0   1.0 10.0     0.0   3.0   62.0 70.0     17.0   6.0     102.0   33.0   132.0 22 83 13   1 10     0   3   62 70     17 6   102 33   132
1835042 1835042 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124004574 323 Justice Page Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2020   grade_7 132.0 61.0 62.0   5.0 10.0     0.0   5.0   147.0 128.0     51.0   2.0     122.0   31.0   275.0 132 61 62   5 10     0   5   147 128     51 2   122 31   275
1835046 1835046 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124001028 324 Sanford Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2020   grade_7 123.0 68.0 59.0   17.0 6.0     0.0   21.0   142.0 152.0     30.0   14.0     170.0   47.0   294.0 123 68 59   17 6     0   21   142 152     30 14   170 47   294
1835050 1835050 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124004882 327 Franklin Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2020   grade_7 2.0 86.0 19.0   5.0 1.0     1.0   3.0   70.0 47.0     13.0   8.0     105.0   30.0   117.0 2 86 19   5 1     1   3   70 47     13 8   105 30   117
1837385 1837385 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124003022 625 River Bend Educational Center Special Education Special Education School No Other KG 12 2020   grade_7 1.0 9.0 0.0   1.0 0.0     0.0   1.0   9.0 3.0     1.0   1.0     9.0   *   12.0 1 9 0   1 0     0   1   9 3     1 1   9     12
1838248 1838248 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124001935 688 MPS Metro HA Hospital/Medical/Partial Hospitalization Program Alternative School No Other KG 12 2020   grade_7 2.0 0.0 1.0   0.0 0.0     0.0   0.0   1.0 2.0     *   *         *   3.0 2 0 1   0 0     0   0   1 2                 3
1838717 1838717 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124001948 697 MPS Metro C Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No Other KG 12 2020   grade_7 0.0 0.0 0.0   1.0 0.0     0.0   0.0   0.0 1.0     *   *         *   1.0 0 0 0   1 0     0   0   0 1                 1
1838958 1838958 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124001936 689 MPS Metro SJ Educational Oversight to Public Care and Treatment Day Program Alternative School No Other KG 12 2020   grade_7 1.0 1.0 0.0   0.0 0.0     0.0   1.0   1.0 2.0     *   *         *   3.0 1 1 0   0 0     0   1   1 2                 3
1839148 1839148 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124002860 315 Ronald McDonald House Private Alternative Program Alternative School No Other KG 12 2020   grade_7 0.0 0.0 1.0   0.0 0.0     0.0   0.0   1.0 0.0     *   *         *   1.0 0 0 1   0 0     0   0   1 0                 1
1839165 1839165 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124001903 361 Center School Private Alternative Program Alternative School No High 07 12 2020   grade_7 0.0 0.0 0.0   4.0 0.0     0.0   0.0   1.0 3.0     *   *         *   4.0 0 0 0   4 0     0   0   1 3                 4
1825328 1825328 MN Carlton 9 school 2744190 100 Independent Districts and Schools Wrenshall Public School District 274419001843 2 Wrenshall Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2020   grade_7 23.0 1.0 0.0   0.0 0.0     0.0   3.0   13.0 14.0     1.0   0.0     12.0   7.0   27.0 23 1 0   0 0     0   3   13 14     1 0   12 7   27
1834235 1834235 MN Carver 10 school 2723910 108 Independent Districts and Schools Central Public School District 272391002507 30 Central Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2020   grade_7 72.0 1.0 8.0   0.0 1.0     0.0   2.0   39.0 45.0     0.0   0.0     12.0   11.0   84.0 72 1 8   0 1     0   2   39 45     0 0   12 11   84
1834154 1834154 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000117 3 Anoka Middle School For The Arts Middle School (Grades 5-8) Regular School No Middle 06 08 2020   grade_7 402.0 77.0 33.0   3.0 23.0     1.0   51.0   285.0 305.0     16.0   10.0     211.0   104.0   590.0 402 77 33   3 23     1   51   285 305     16 10   211 104   590
1834158 1834158 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000099 4 Coon Rapids Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2020   grade_7 271.0 105.0 49.0   3.0 38.0     2.0   52.0   271.0 249.0     37.0   24.0     286.0   91.0   520.0 271 105 49   3 38     2   52   271 249     37 24   286 91   520
1834162 1834162 MN Hennepin 27 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000108 6 Jackson Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2020   grade_7 331.0 140.0 71.0   9.0 101.0     0.0   47.0   362.0 337.0     61.0   11.0     262.0   92.0   699.0 331 140 71   9 101     0   47   362 337     61 11   262 92   699
1834166 1834166 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000119 90 Northdale Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2020   grade_7 277.0 48.0 43.0   2.0 42.0     0.0   39.0   252.0 199.0     29.0   4.0     167.0   85.0   451.0 277 48 43   2 42     0   39   252 199     29 4   167 85   451
1834170 1834170 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318002501 193 Oak View Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2020   grade_7 364.0 23.0 18.0   1.0 13.0     0.0   25.0   233.0 211.0     8.0   0.0     69.0   *   444.0 364 23 18   1 13     0   25   233 211     8 0   69     444
1834174 1834174 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000122 195 Roosevelt Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2020   grade_7 230.0 21.0 18.0   0.0 21.0     0.0   22.0   174.0 138.0     6.0   5.0     63.0   43.0   312.0 230 21 18   0 21     0   22   174 138     6 5   63 43   312
1836285 1836285 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318002974 812 Compass-Bell Center Public Area Learning Center ALC (State approved) Alternative School No High 06 12 2020   grade_7 0.0 1.0 1.0   0.0 0.0     0.0   0.0   1.0 1.0     *   *         *   2.0 0 1 1   0 0     0   0   1 1                 2
1836929 1836929 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000005 467 River Trail Learning Ctr @ LO Jacob Special Education Special Education School No Other KG 12 2020   grade_7 5.0 1.0 1.0   0.0 0.0     0.0   0.0   6.0 1.0     *   *         *   7.0 5 1 1   0 0     0   0   6 1                 7
1834239 1834239 MN Carver 10 school 2741460 110 Independent Districts and Schools Waconia Public School District 274146003066 220 Waconia Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2020   grade_7 287.0 3.0 23.0   2.0 4.0     0.0   7.0   161.0 165.0     7.0   0.0     42.0   52.0   326.0 287 3 23   2 4     0   7   161 165     7 0   42 52   326
1834244 1834244 MN Carver 10 school 2741910 111 Independent Districts and Schools Watertown-Mayer Public School Dist. 274191000024 841 Watertown-Mayer Middle Middle School (Grades 5-8) Regular School No Middle 05 08 2020   grade_7 117.0 0.0 1.0   0.0 0.0     0.0   2.0   69.0 51.0     0.0   0.0     27.0   15.0   120.0 117 0 1   0 0     0   2   69 51     0 0   27 15   120
1834248 1834248 MN Carver 10 school 2708190 112 Independent Districts and Schools Eastern Carver County Public School 270819000345 61 Chaska Middle School East Middle School (Grades 5-8) Regular School No Middle 06 08 2020   grade_7 171.0 5.0 14.0   2.0 6.0     0.0   13.0   118.0 93.0     3.0   1.0     24.0   20.0   211.0 171 5 14   2 6     0   13   118 93     3 1   24 20   211
1834252 1834252 MN Carver 10 school 2708190 112 Independent Districts and Schools Eastern Carver County Public School 270819002798 62 Chaska Middle School West Middle School (Grades 5-8) Regular School No Middle 06 08 2020   grade_7 193.0 10.0 27.0   0.0 6.0     0.0   17.0   115.0 138.0     12.0   0.0     52.0   48.0   253.0 193 10 27   0 6     0   17   115 138     12 0   52 48   253
1834256 1834256 MN Carver 10 school 2708190 112 Independent Districts and Schools Eastern Carver County Public School 270819003180 63 Pioneer Ridge Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2020   grade_7 116.0 5.0 13.0   0.0 6.0     1.0   4.0   74.0 71.0     5.0   1.0     30.0   23.0   145.0 116 5 13   0 6     1   4   74 71     5 1   30 23   145
1836368 1836368 MN Carver 10 school 2708190 112 Independent Districts and Schools Eastern Carver County Public School 270819004622 66 112 ALC Middle School Public Area Learning Center ALC (State approved) Alternative School No Middle 06 08 2020   grade_7 79.0 11.0 27.0   1.0 8.0     0.0   7.0   73.0 60.0     10.0   0.0     58.0   30.0   133.0 79 11 27   1 8     0   7   73 60     10 0   58 30   133
1825335 1825335 MN Cass 11 school 2702910 113 Independent Districts and Schools Walker-Hackensack-Akeley Schl. Dist 270291001737 20 Walker-Hackensack-Akeley Sec. Secondary School (Grades 7-12) Regular School No High 07 12 2020   grade_7 44.0 0.0 3.0   19.0 0.0     0.0   7.0   36.0 37.0     0.0   1.0     39.0   22.0   73.0 44 0 3   19 0     0   7   36 37     0 1   39 22   73
1834261 1834261 MN Cass 11 school 2708070 115 Independent Districts and Schools Cass Lake-Bena Public Schools 270807003181 20 Cass Lake-Bena Middle School Middle School (Grades 5-8) Regular School No Middle 05 08 2020   grade_7 6.0 0.0 1.0   81.0 0.0     0.0   0.0   49.0 39.0     *   *         *   88.0 6 0 1   81 0     0   0   49 39                 88
1836374 1836374 MN Cass 11 school 2708070 115 Independent Districts and Schools Cass Lake-Bena Public Schools 270807002234 31 Cass Lake-Bena Area Lrng. Cntr. Public Area Learning Center ALC (State approved) Alternative School No High 07 12 2020   grade_7 0.0 0.0 0.0   1.0 0.0     0.0   0.0   1.0 0.0     *   *         *   1.0 0 0 0   1 0     0   0   1 0                 1
1834266 1834266 MN Cass 11 school 2728350 116 Independent Districts and Schools Pillager Public School District 272835004841 40 Pillager Middle School Middle School (Grades 5-8) Regular School No Middle 05 08 2020   grade_7 94.0 1.0 2.0   0.0 0.0     0.0   1.0   52.0 46.0     0.0   0.0     40.0   19.0   98.0 94 1 2   0 0     0   1   52 46     0 0   40 19   98
1825342 1825342 MN Cass 11 school 2730870 118 Independent Districts and Schools Northland Community Schools 273087001308 20 Northland Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2020   grade_7 10.0 0.0 0.0   16.0 0.0     0.0   0.0   13.0 13.0     *   *     21.0   6.0   26.0 10 0 0   16 0     0   0   13 13           21 6   26
1834178 1834178 MN Anoka 2 school 2708100 12 Independent Districts and Schools Centennial Public School District 270810002784 166 Centennial Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2020   grade_7 417.0 29.0 30.0   2.0 31.0     0.0   33.0   260.0 282.0     *   4.0     90.0   83.0   542.0 417 29 30   2 31     0   33   260 282       4   90 83   542
1838506 1838506 MN Anoka 2 school 2708100 12 Independent Districts and Schools Centennial Public School District 270810004656 159 Pines School - NSP Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No High 07 12 2020   grade_7 1.0 1.0 0.0   0.0 0.0     0.0   0.0   2.0 0.0     *   *         *   2.0 1 1 0   0 0     0   0   2 0                 2
1838512 1838512 MN Anoka 2 school 2708100 12 Independent Districts and Schools Centennial Public School District 270810004620 161 Pines School - RJC Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No High 07 12 2020   grade_7 0.0 0.0 1.0   0.0 0.0     0.0   0.0   1.0 0.0     *   *         *   1.0 0 0 1   0 0     0   0   1 0                 1
1834272 1834272 MN Chippewa 12 school 2721320 129 Independent Districts and Schools Montevideo Public School District 272132001071 30 Montevideo Middle Middle School (Grades 5-8) Regular School No Middle 04 07 2020   grade_7 79.0 2.0 23.0   3.0 2.0     2.0   6.0   60.0 57.0     9.0   0.0     59.0   18.0   117.0 79 2 23   3 2     2   6   60 57     9 0   59 18   117
1834182 1834182 MN Anoka 2 school 2709510 13 Independent Districts and Schools Columbia Heights Public School Dist 270951000395 17 Columbia Academy Middle School (Grades 5-8) Regular School No Middle 06 08 2020   grade_7 35.0 73.0 107.0   4.0 7.0     0.0   15.0   128.0 113.0     *   *         *   241.0 35 73 107   4 7     0   15   128 113                 241
1838833 1838833 MN Anoka 2 school 2709510 13 Independent Districts and Schools Columbia Heights Public School Dist 270951005164 810 Columbia Academy Anchor Program Educational Oversight to Public Care and Treatment Day Program Alternative School No Middle 06 08 2020   grade_7 0.0 1.0 0.0   0.0 0.0     0.0   0.0   0.0 1.0     *   *         *   1.0 0 1 0   0 0     0   0   0 1                 1
1834276 1834276 MN Chisago 13 school 2723820 138 Independent Districts and Schools North Branch Public Schools 272382001164 20 North Branch Middle Middle School (Grades 5-8) Regular School No Middle 05 08 2020   grade_7 181.0 2.0 9.0   1.0 3.0     0.0   7.0   98.0 105.0     3.0   0.0     52.0   26.0   203.0 181 2 9   1 3     0   7   98 105     3 0   52 26   203
1825349 1825349 MN Chisago 13 school 2732550 139 Independent Districts and Schools Rush City Public School District 273255001406 20 Rush City Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2020   grade_7 61.0 0.0 2.0   2.0 0.0     0.0   4.0   38.0 31.0     0.0   0.0     29.0   12.0   69.0 61 0 2   2 0     0   4   38 31     0 0   29 12   69
1834187 1834187 MN Anoka 2 school 2712420 14 Independent Districts and Schools Fridley Public School District 271242000610 23 Fridley Middle Middle School (Grades 5-8) Regular School No Middle 05 08 2020   grade_7 41.0 77.0 25.0   1.0 12.0     0.0   15.0   74.0 97.0     21.0   2.0         26.0   171.0 41 77 25   1 12     0   15   74 97     21 2     26   171
1836299 1836299 MN Anoka 2 school 2712420 14 Independent Districts and Schools Fridley Public School District 271242003427 652 Fridley Middle Area Learning Center Public Area Learning Center ALC (State approved) Alternative School No Middle 05 08 2020   grade_7 5.0 5.0 0.0   1.0 0.0     0.0   1.0   7.0 5.0     0.0   0.0         0.0   12.0 5 5 0   1 0     0   1   7 5     0 0     0   12
1825356 1825356 MN Clay 14 school 2703660 146 Independent Districts and Schools Barnesville Public School District 270366000170 40 Barnesville Secondary Secondary School (Grades 7-12) Regular School No High 06 12 2020   grade_7 63.0 0.0 2.0   0.0 0.0     0.0   2.0   33.0 34.0     0.0   0.0     13.0   7.0   67.0 63 0 2   0 0     0   2   33 34     0 0   13 7   67
1834191 1834191 MN Anoka 2 school 2733540 15 Independent Districts and Schools St. Francis Area Schools 273354000013 123 St. Francis Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2020   grade_7 160.0 1.0 10.0   4.0 7.0     0.0   12.0   101.0 93.0     *   0.0         *   194.0 160 1 10   4 7     0   12   101 93       0         194
1836305 1836305 MN Anoka 2 school 2733540 15 Independent Districts and Schools St. Francis Area Schools 273354004980 18 Saints Academy Public Area Learning Center ALC (State approved) Alternative School No High 07 12 2020   grade_7 107.0 0.0 6.0   0.0 7.0     0.0   10.0   72.0 58.0     9.0   *     43.0   *   130.0 107 0 6   0 7     0   10   72 58     9     43     130
1838311 1838311 MN Anoka 2 school 2733540 15 Independent Districts and Schools St. Francis Area Schools 273354004917 15 Saints Online Distance Learning Program OLL (State approved) Regular School No Other 03 12 2020   grade_7 2.0 0.0 1.0   0.0 0.0     0.0   0.0   2.0 1.0     *   *         *   3.0 2 0 1   0 0     0   0   2 1                 3
1825363 1825363 MN Clay 14 school 2713560 150 Independent Districts and Schools Hawley Public School District 271356000699 20 Hawley Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2020   grade_7 78.0 0.0 2.0   0.0 1.0     0.0   1.0   40.0 42.0     0.0   0.0     15.0   10.0   82.0 78 0 2   0 1     0   1   40 42     0 0   15 10   82
1834281 1834281 MN Clay 14 school 2721420 152 Independent Districts and Schools Moorhead Public School District 272142003512 380 Horizon Middle School Middle School (Grades 5-8) Regular School No Middle 05 08 2020   grade_7 372.0 58.0 34.0   18.0 12.0     0.0   40.0   281.0 253.0     38.0   10.0     210.0   99.0   534.0 372 58 34   18 12     0   40   281 253     38 10   210 99   534
1838544 1838544 MN Clay 14 school 2721420 152 Independent Districts and Schools Moorhead Public School District 272142000413 960 West Central Academy-S Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No Other 04 12 2020   grade_7 1.0 0.0 0.0   0.0 0.0     0.0   0.0   1.0 0.0     *   *         *   1.0 1 0 0   0 0     0   0   1 0                 1
1838551 1838551 MN Clay 14 school 2721420 152 Independent Districts and Schools Moorhead Public School District 272142002799 970 West Central Academy-N Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No Other 03 12 2020   grade_7 0.0 0.0 0.0   0.0 0.0     0.0   1.0   1.0 0.0     *   *         *   1.0 0 0 0   0 0     0   1   1 0                 1
1825236 1825236 MN Anoka 2 school 2733330 16 Independent Districts and Schools Spring Lake Park Public Schools 273333004658 788 Secondary Lighthouse Secondary School (Grades 7-12) Regular School No High 07 12 2020   grade_7 9.0 1.0 1.0   0.0 2.0     0.0   2.0   8.0 7.0     *   0.0         *   15.0 9 1 1   0 2     0   2   8 7       0         15
1834196 1834196 MN Anoka 2 school 2733330 16 Independent Districts and Schools Spring Lake Park Public Schools 273333001466 92 Westwood Intermediate and Middle School Middle School (Grades 5-8) Regular School No Middle 05 08 2020   grade_7 261.0 67.0 72.0   5.0 30.0     2.0   32.0   251.0 218.0     *   6.0         *   469.0 261 67 72   5 30     2   32   251 218       6         469
1837398 1837398 MN Rice 66 school 2700129 160 State Operated Schools (which include MN Academy Deaf & Blind, School for the Arts) Minnesota State Academies 270012903056 1 MN Academy For The Blind Special Education Special Education School No Other PK 12 2020   grade_7 2.0 0.0 0.0   0.0 0.0     0.0   0.0   0.0 2.0     *   *         *   2.0 2 0 0   0 0     0   0   0 2                 2
1837412 1837412 MN Rice 66 school 2700129 160 State Operated Schools (which include MN Academy Deaf & Blind, School for the Arts) Minnesota State Academies 270012902409 2 MN Academy For The Deaf Special Education Special Education School No Other PK 12 2020   grade_7 5.0 0.0 2.0   0.0 0.0     0.0   0.0   2.0 5.0     *   *         *   7.0 5 0 2   0 0     0   0   2 5                 7
1825370 1825370 MN Clearwater 15 school 2703570 162 Independent Districts and Schools Bagley Public School District 270357000165 20 Bagley Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2020   grade_7 69.0 0.0 0.0   15.0 1.0     0.0   10.0   45.0 50.0     *   0.0     46.0   13.0   95.0 69 0 0   15 1     0   10   45 50       0   46 13   95
1834285 1834285 MN Cook 16 school 2713110 166 Independent Districts and Schools Cook County Public Schools 271311002635 40 Cook County Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2020   grade_7 21.0 1.0 3.0   11.0 1.0     0.0   3.0   27.0 13.0     0.0   0.0     22.0   11.0   40.0 21 1 3   11 1     0   3   27 13     0 0   22 11   40
1825377 1825377 MN Cottonwood 17 school 2723010 173 Independent Districts and Schools Mountain Lake Public Schools 272301001135 20 Mountain Lake Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2020   grade_7 29.0 2.0 6.0   0.0 4.0     0.0   3.0   26.0 18.0     4.0   0.0     20.0   8.0   44.0 29 2 6   0 4     0   3   26 18     4 0   20 8   44
1834291 1834291 MN Cottonwood 17 school 2742780 177 Independent Districts and Schools Windom Public School District 274278003068 60 Windom Middle Middle School (Grades 5-8) Regular School No Middle 04 08 2020   grade_7 52.0 4.0 26.0   1.0 2.0     2.0   9.0   54.0 42.0     7.0   0.0     50.0   19.0   96.0 52 4 26   1 2     2   9   54 42     7 0   50 19   96
1834296 1834296 MN Crow Wing 18 school 2706090 181 Independent Districts and Schools Brainerd Public School District 270609004196 22 Forestview Middle Middle School (Grades 5-8) Regular School No Middle 05 08 2020   grade_7 443.0 8.0 12.0   9.0 1.0     0.0   15.0   225.0 263.0     1.0   *     182.0   *   488.0 443 8 12   9 1     0   15   225 263     1     182     488
1836397 1836397 MN Crow Wing 18 school 2706090 181 Independent Districts and Schools Brainerd Public School District 270609002982 21 Middle Level Alternative Program Public Area Learning Center ALC (State approved) Alternative School No Middle 05 08 2020   grade_7 4.0 0.0 0.0   0.0 0.0     0.0   0.0   0.0 4.0     *   *         *   4.0 4 0 0   0 0     0   0   0 4                 4
1838812 1838812 MN Crow Wing 18 school 2706090 181 Independent Districts and Schools Brainerd Public School District 270609000468 17 Lincoln Education Center Miscellaneous Program (assignment is now limited) Alternative School No Other 02 12 2020   grade_7 5.0 0.0 0.0   2.0 0.0     0.0   0.0   5.0 2.0     *   *         *   7.0 5 0 0   2 0     0   0   5 2                 7
1825384 1825384 MN Crow Wing 18 school 2709750 182 Independent Districts and Schools Crosby-Ironton Public School District 270975000417 1 Crosby-Ironton Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2020   grade_7 75.0 0.0 3.0   0.0 0.0     0.0   4.0   47.0 35.0     0.0   2.0     33.0   21.0   82.0 75 0 3   0 0     0   4   47 35     0 2   33 21   82
1834301 1834301 MN Crow Wing 18 school 2728200 186 Independent Districts and Schools Pequot Lakes Public Schools 272820003069 15 Pequot Lakes Middle Middle School (Grades 5-8) Regular School No Middle 05 08 2020   grade_7 149.0 1.0 2.0   2.0 0.0     0.0   1.0   80.0 75.0     0.0   0.0     50.0   19.0   155.0 149 1 2   2 0     0   1   80 75     0 0   50 19   155
1834305 1834305 MN Dakota 19 school 2707290 191 Independent Districts and Schools Burnsville Public School District 270729000295 15 John Metcalf Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2020   grade_7 55.0 17.0 15.0   0.0 6.0     0.0   8.0   52.0 49.0     2.0   0.0     37.0   13.0   101.0 55 17 15   0 6     0   8   52 49     2 0   37 13   101
1834309 1834309 MN Scott 70 school 2707290 191 Independent Districts and Schools Burnsville Public School District 270729002639 66 Eagle Ridge Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2020   grade_7 55.0 14.0 17.0   0.0 9.0     0.0   8.0   58.0 45.0     5.0   1.0     37.0   15.0   103.0 55 14 17   0 9     0   8   58 45     5 1   37 15   103
1834313 1834313 MN Dakota 19 school 2707290 191 Independent Districts and Schools Burnsville Public School District 270729000297 85 Joseph Nicollet Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2020   grade_7 29.0 27.0 16.0   0.0 6.0     0.0   6.0   44.0 40.0     2.0   0.0     47.0   10.0   84.0 29 27 16   0 6     0   6   44 40     2 0   47 10   84
1836401 1836401 MN Dakota 19 school 2707290 191 Independent Districts and Schools Burnsville Public School District 270729002640 314 Burnsville Area Learning Center Public Area Learning Center ALC (State approved) Alternative School No High 06 12 2020   grade_7 85.0 118.0 106.0   4.0 17.0     1.0   19.0   181.0 169.0     88.0   5.0     240.0   66.0   350.0 85 118 106   4 17     1   19   181 169     88 5   240 66   350
1834317 1834317 MN Dakota 19 school 2711820 192 Independent Districts and Schools Farmington Public School District 271182000570 30 Levi P. Dodge Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2020   grade_7 205.0 9.0 31.0   1.0 16.0     0.0   18.0   148.0 132.0     17.0   1.0     49.0   *   280.0 205 9 31   1 16     0   18   148 132     17 1   49     280
1834321 1834321 MN Dakota 19 school 2711820 192 Independent Districts and Schools Farmington Public School District 271182002983 60 Robert Boeckman Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2020   grade_7 254.0 9.0 18.0   3.0 10.0     0.0   15.0   142.0 167.0     5.0   1.0     43.0   *   309.0 254 9 18   3 10     0   15   142 167     5 1   43     309
1834325 1834325 MN Dakota 19 school 2717780 194 Independent Districts and Schools Lakeville Public School District 271778002435 89 McGuire Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2020   grade_7 255.0 14.0 20.0   1.0 13.0     1.0   18.0   163.0 159.0     *   *     39.0   33.0   322.0 255 14 20   1 13     1   18   163 159           39 33   322
1834329 1834329 MN Dakota 19 school 2717780 194 Independent Districts and Schools Lakeville Public School District 271778000483 104 Kenwood Trail Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2020   grade_7 154.0 21.0 49.0   2.0 10.0     0.0   12.0   124.0 124.0     12.0   2.0     73.0   *   248.0 154 21 49   2 10     0   12   124 124     12 2   73     248
1834333 1834333 MN Dakota 19 school 2717780 194 Independent Districts and Schools Lakeville Public School District 271778002984 105 Century Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2020   grade_7 248.0 10.0 10.0   2.0 21.0     0.0   19.0   154.0 156.0     0.0   1.0         *   310.0 248 10 10   2 21     0   19   154 156     0 1         310
1838336 1838336 MN Dakota 19 school 2717780 194 Independent Districts and Schools Lakeville Public School District 271778004309 90 Link12 Lakeville Distance Learning Program OLL (State approved) Regular School No Other KG 12 2020   grade_7 4.0 0.0 0.0   0.0 0.0     0.0   1.0   4.0 1.0     *   *         *   5.0 4 0 0   0 0     0   1   4 1                 5
1825391 1825391 MN Dakota 19 school 2730150 195 Independent Districts and Schools Randolph Public School District 273015001287 20 Randolph Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2020   grade_7 52.0 0.0 5.0   0.0 0.0     0.0   1.0   33.0 25.0     0.0   0.0     11.0   8.0   58.0 52 0 5   0 0     0   1   33 25     0 0   11 8   58
1834337 1834337 MN Dakota 19 school 2732390 196 Independent Districts and Schools Rosemount-Apple Valley-Eagan 273239000484 25 Dakota Hills Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2020   grade_7 276.0 25.0 61.0   0.0 60.0     0.0   27.0   227.0 222.0     21.0   0.0     79.0   62.0   449.0 276 25 61   0 60     0   27   227 222     21 0   79 62   449
1834341 1834341 MN Dakota 19 school 2732390 196 Independent Districts and Schools Rosemount-Apple Valley-Eagan 273239002437 32 Black Hawk Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2020   grade_7 145.0 56.0 29.0   0.0 24.0     0.0   18.0   119.0 153.0     *   0.0     84.0   53.0   272.0 145 56 29   0 24     0   18   119 153       0   84 53   272
1834345 1834345 MN Dakota 19 school 2732390 196 Independent Districts and Schools Rosemount-Apple Valley-Eagan 273239001381 39 Rosemount Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2020   grade_7 328.0 22.0 20.0   1.0 31.0     0.0   28.0   208.0 222.0     *   *         38.0   430.0 328 22 20   1 31     0   28   208 222             38   430
1834349 1834349 MN Dakota 19 school 2732390 196 Independent Districts and Schools Rosemount-Apple Valley-Eagan 273239002644 86 Falcon Ridge Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2020   grade_7 205.0 46.0 58.0   1.0 20.0     0.0   20.0   170.0 180.0     23.0   0.0     98.0   56.0   350.0 205 46 58   1 20     0   20   170 180     23 0   98 56   350
1834353 1834353 MN Dakota 19 school 2732390 196 Independent Districts and Schools Rosemount-Apple Valley-Eagan 273239001943 93 Scott Highlands Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2020   grade_7 255.0 54.0 31.0   0.0 52.0     0.0   35.0   217.0 210.0     16.0   *     74.0   55.0   427.0 255 54 31   0 52     0   35   217 210     16     74 55   427
1834357 1834357 MN Dakota 19 school 2732390 196 Independent Districts and Schools Rosemount-Apple Valley-Eagan 273239001383 98 Valley Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2020   grade_7 174.0 90.0 58.0   3.0 16.0     0.0   35.0   193.0 183.0     25.0   0.0     170.0   61.0   376.0 174 90 58   3 16     0   35   193 183     25 0   170 61   376
1837015 1837015 MN Dakota 19 school 2732390 196 Independent Districts and Schools Rosemount-Apple Valley-Eagan 273239002517 100 Dakota Ridge School Special Education Special Education School No Other KG 12 2020   grade_7 4.0 4.0 2.0   0.0 0.0     0.0   0.0   8.0 2.0     0.0   0.0         *   10.0 4 4 2   0 0     0   0   8 2     0 0         10
1834362 1834362 MN Dakota 19 school 2742270 197 Independent Districts and Schools West St. Paul-Mendota Hts.-Eagan 274227002646 52 Friendly Hills Middle Middle School (Grades 5-8) Regular School No Middle 05 08 2020   grade_7 104.0 31.0 48.0   3.0 9.0     0.0   14.0   109.0 100.0     *   *         33.0   209.0 104 31 48   3 9     0   14   109 100             33   209
1834367 1834367 MN Dakota 19 school 2742270 197 Independent Districts and Schools West St. Paul-Mendota Hts.-Eagan 274227001774 54 Heritage E-STEM Magnet School Middle School (Grades 5-8) Regular School No Middle 05 08 2020   grade_7 88.0 19.0 71.0   3.0 6.0     0.0   14.0   109.0 92.0     *   4.0     106.0   45.0   201.0 88 19 71   3 6     0   14   109 92       4   106 45   201
1837028 1837028 MN Dakota 19 school 2742270 197 Independent Districts and Schools West St. Paul-Mendota Hts.-Eagan 274227005008 827 Special Education Special Education Special Education School No Other KG 12 2020   grade_7 1.0 0.0 0.0   0.0 0.0     0.0   0.0   1.0 0.0     *   *         *   1.0 1 0 0   0 0     0   0   1 0                 1
1834371 1834371 MN Dakota 19 school 2715030 199 Independent Districts and Schools Inver Grove Heights Schools 271503000765 27 Inver Grove Heights Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2020   grade_7 118.0 35.0 68.0   3.0 11.0     0.0   20.0   125.0 130.0     24.0   3.0     126.0   36.0   255.0 118 35 68   3 11     0   20   125 130     24 3   126 36   255

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