Data source: Big Local News · About: Big Local

705 rows where grade = "grade_8", state = "MN" and year = 2020 sorted by district_state_id

View and edit SQL

year

  • 2020 · 705

grade

  • grade_8 · 705
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
1825223 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_8 85.0 2.0 1.0   3.0 0.0     0.0   3.0   40.0 54.0     0.0   0.0     41.0   16.0   94.0 85 2 1   3 0     0   3   40 54     0 0   41 16   94
1826520 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_8 0.0 18.0 0.0   0.0 0.0     0.0   2.0   11.0 9.0     11.0   0.0         0.0   20.0 0 18 0   0 0     0   2   11 9     11 0     0   20
1832644 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_8 39.0 38.0 5.0   0.0 3.0     0.0   4.0   46.0 43.0     22.0   1.0     40.0   7.0   89.0 39 38 5   0 3     0   4   46 43     22 1   40 7   89
1832666 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_8 110.0 5.0 4.0   0.0 4.0     1.0   2.0   63.0 63.0     1.0   1.0     8.0   13.0   126.0 110 5 4   0 4     1   2   63 63     1 1   8 13   126
1832687 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_8 38.0 18.0 9.0   3.0 1.0     0.0   0.0   32.0 37.0     6.0   3.0     38.0   7.0   69.0 38 18 9   3 1     0   0   32 37     6 3   38 7   69
1832756 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_8 34.0 43.0 5.0   5.0 3.0     0.0   2.0   51.0 41.0     16.0   0.0     48.0   *   92.0 34 43 5   5 3     0   2   51 41     16 0   48     92
1832794 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_8 6.0 26.0 49.0   4.0 3.0     0.0   4.0   47.0 45.0     *   4.0     81.0   17.0   92.0 6 26 49   4 3     0   4   47 45       4   81 17   92
1832806 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_8 1.0 15.0 26.0   0.0 1.0     0.0   1.0   18.0 26.0     24.0   2.0     39.0   7.0   44.0 1 15 26   0 1     0   1   18 26     24 2   39 7   44
1832825 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_8 4.0 28.0 56.0   4.0 0.0     1.0   0.0   47.0 46.0     41.0   4.0         17.0   93.0 4 28 56   4 0     1   0   47 46     41 4     17   93
1832837 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_8 0.0 35.0 1.0   6.0 0.0     0.0   1.0   19.0 24.0     18.0   6.0         9.0   43.0 0 35 1   6 0     0   1   19 24     18 6     9   43
1832863 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_8 24.0 40.0 11.0   2.0 1.0     0.0   3.0   36.0 45.0     8.0   1.0     45.0   9.0   81.0 24 40 11   2 1     0   3   36 45     8 1   45 9   81
1832938 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_8 1.0 32.0 1.0   0.0 28.0     0.0   1.0   38.0 25.0     33.0   2.0         7.0   63.0 1 32 1   0 28     0   1   38 25     33 2     7   63
1835023 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_8 102.0 11.0 5.0   3.0 7.0     0.0   8.0   68.0 68.0     2.0   0.0     24.0   16.0   136.0 102 11 5   3 7     0   8   68 68     2 0   24 16   136
1835027 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_8 143.0 71.0 28.0   1.0 6.0     1.0   12.0   139.0 123.0     31.0   2.0     91.0   22.0   262.0 143 71 28   1 6     1   12   139 123     31 2   91 22   262
1835031 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_8 28.0 68.0 66.0   5.0 9.0     0.0   9.0   84.0 101.0     31.0   3.0     118.0   26.0   185.0 28 68 66   5 9     0   9   84 101     31 3   118 26   185
1835035 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_8 37.0 58.0 32.0   9.0 9.0     0.0   7.0   71.0 81.0     25.0   6.0     110.0   42.0   152.0 37 58 32   9 9     0   7   71 81     25 6   110 42   152
1835039 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_8 12.0 69.0 11.0   3.0 11.0     0.0   7.0   65.0 48.0     10.0   8.0     83.0   29.0   113.0 12 69 11   3 11     0   7   65 48     10 8   83 29   113
1835043 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_8 153.0 62.0 51.0   2.0 3.0     1.0   6.0   134.0 144.0     54.0   3.0     121.0   25.0   278.0 153 62 51   2 3     1   6   134 144     54 3   121 25   278
1835047 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_8 141.0 77.0 66.0   15.0 8.0     1.0   11.0   151.0 168.0     45.0   7.0     156.0   47.0   319.0 141 77 66   15 8     1   11   151 168     45 7   156 47   319
1835051 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_8 3.0 86.0 19.0   3.0 4.0     0.0   4.0   54.0 65.0     12.0   4.0     95.0   21.0   119.0 3 86 19   3 4     0   4   54 65     12 4   95 21   119
1837386 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_8 3.0 7.0 1.0   1.0 1.0     0.0   3.0   7.0 9.0     3.0   1.0     14.0   *   16.0 3 7 1   1 1     0   3   7 9     3 1   14     16
1838249 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_8 2.0 0.0 1.0   0.0 0.0     0.0   0.0   0.0 3.0     *   *         *   3.0 2 0 1   0 0     0   0   0 3                 3
1838711 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124001933 685 Stadium View Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No High 06 12 2020   grade_8 0.0 3.0 0.0   0.0 0.0     0.0   0.0   3.0 0.0     *   *         *   3.0 0 3 0   0 0     0   0   3 0                 3
1838959 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_8 0.0 3.0 0.0   0.0 0.0     0.0   0.0   2.0 1.0     *   *         *   3.0 0 3 0   0 0     0   0   2 1                 3
1839166 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_8 0.0 0.0 0.0   2.0 0.0     0.0   0.0   1.0 1.0     *   *         *   2.0 0 0 0   2 0     0   0   1 1                 2
1825329 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_8 46.0 0.0 5.0   0.0 0.0     0.0   2.0   32.0 21.0     0.0   0.0     27.0   18.0   53.0 46 0 5   0 0     0   2   32 21     0 0   27 18   53
1834236 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_8 63.0 1.0 3.0   1.0 1.0     0.0   4.0   42.0 31.0     0.0   0.0     18.0   9.0   73.0 63 1 3   1 1     0   4   42 31     0 0   18 9   73
1834155 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_8 412.0 71.0 38.0   3.0 29.0     0.0   47.0   304.0 296.0     22.0   6.0     198.0   93.0   600.0 412 71 38   3 29     0   47   304 296     22 6   198 93   600
1834159 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_8 320.0 98.0 51.0   9.0 41.0     0.0   44.0   315.0 248.0     36.0   23.0     287.0   94.0   563.0 320 98 51   9 41     0   44   315 248     36 23   287 94   563
1834163 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_8 340.0 140.0 59.0   4.0 95.0     1.0   72.0   364.0 347.0     43.0   8.0     228.0   72.0   711.0 340 140 59   4 95     1   72   364 347     43 8   228 72   711
1834167 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_8 255.0 56.0 36.0   2.0 44.0     0.0   29.0   215.0 207.0     14.0   10.0     164.0   61.0   422.0 255 56 36   2 44     0   29   215 207     14 10   164 61   422
1834171 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_8 351.0 12.0 18.0   0.0 8.0     1.0   19.0   216.0 193.0     3.0   2.0     58.0   *   409.0 351 12 18   0 8     1   19   216 193     3 2   58     409
1834175 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_8 227.0 17.0 18.0   1.0 26.0     0.0   18.0   160.0 147.0     6.0   9.0     74.0   36.0   307.0 227 17 18   1 26     0   18   160 147     6 9   74 36   307
1836286 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_8 8.0 1.0 1.0   0.0 0.0     0.0   3.0   4.0 9.0     0.0   0.0     9.0   *   13.0 8 1 1   0 0     0   3   4 9     0 0   9     13
1836930 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_8 8.0 3.0 0.0   0.0 0.0     0.0   4.0   15.0 0.0     0.0   3.0     8.0   *   15.0 8 3 0   0 0     0   4   15 0     0 3   8     15
1834240 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_8 290.0 6.0 13.0   1.0 3.0     0.0   9.0   171.0 151.0     2.0   0.0     26.0   40.0   322.0 290 6 13   1 3     0   9   171 151     2 0   26 40   322
1834245 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_8 106.0 2.0 1.0   0.0 0.0     0.0   1.0   45.0 65.0     0.0   0.0     20.0   8.0   110.0 106 2 1   0 0     0   1   45 65     0 0   20 8   110
1834249 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_8 184.0 6.0 6.0   0.0 6.0     0.0   9.0   112.0 99.0     1.0   1.0     15.0   15.0   211.0 184 6 6   0 6     0   9   112 99     1 1   15 15   211
1834253 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_8 176.0 7.0 19.0   0.0 9.0     1.0   9.0   119.0 102.0     2.0   0.0     26.0   16.0   221.0 176 7 19   0 9     1   9   119 102     2 0   26 16   221
1834257 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_8 100.0 10.0 7.0   1.0 8.0     0.0   5.0   72.0 59.0     2.0   1.0     25.0   22.0   131.0 100 10 7   1 8     0   5   72 59     2 1   25 22   131
1836369 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_8 102.0 14.0 38.0   0.0 7.0     0.0   11.0   95.0 77.0     14.0   0.0     71.0   44.0   172.0 102 14 38   0 7     0   11   95 77     14 0   71 44   172
1825336 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_8 33.0 0.0 0.0   8.0 0.0     0.0   3.0   25.0 19.0     0.0   5.0     25.0   11.0   44.0 33 0 0   8 0     0   3   25 19     0 5   25 11   44
1834262 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_8 11.0 0.0 1.0   64.0 0.0     0.0   1.0   37.0 40.0     *   *         *   77.0 11 0 1   64 0     0   1   37 40                 77
1836375 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_8 1.0 0.0 0.0   1.0 0.0     0.0   0.0   1.0 1.0     *   *         *   2.0 1 0 0   1 0     0   0   1 1                 2
1834267 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_8 82.0 0.0 5.0   0.0 0.0     0.0   4.0   54.0 37.0     0.0   0.0     34.0   10.0   91.0 82 0 5   0 0     0   4   54 37     0 0   34 10   91
1825343 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_8 23.0 0.0 0.0   8.0 0.0     0.0   0.0   14.0 17.0     *   *         *   31.0 23 0 0   8 0     0   0   14 17                 31
1838538 MN Cass 11 school 2730870 118 Independent Districts and Schools Northland Community Schools 273087003507 40 Little Sand Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No High 07 12 2020   grade_8 0.0 0.0 1.0   1.0 0.0     0.0   0.0   0.0 2.0     *   *         *   2.0 0 0 1   1 0     0   0   0 2                 2
1834179 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_8 400.0 27.0 36.0   1.0 16.0     0.0   30.0   257.0 253.0     11.0   *         *   510.0 400 27 36   1 16     0   30   257 253     11           510
1838500 MN Anoka 2 school 2708100 12 Independent Districts and Schools Centennial Public School District 270810004655 158 Pines School - ACS Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No High 08 12 2020   grade_8 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
1838507 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_8 1.0 1.0 0.0   0.0 0.0     0.0   0.0   1.0 1.0     *   *         *   2.0 1 1 0   0 0     0   0   1 1                 2
1835300 MN Chippewa 12 school 2721320 129 Independent Districts and Schools Montevideo Public School District 272132001072 40 Montevideo Senior High Senior High School (Grades 9-12) Regular School No High 08 12 2020   grade_8 97.0 0.0 7.0   16.0 0.0     0.0   1.0   67.0 54.0     6.0   0.0     48.0   18.0   121.0 97 0 7   16 0     0   1   67 54     6 0   48 18   121
1834183 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_8 33.0 76.0 93.0   3.0 10.0     0.0   18.0   125.0 108.0     *   *         *   233.0 33 76 93   3 10     0   18   125 108                 233
1838834 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_8 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
1834277 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_8 199.0 3.0 11.0   1.0 10.0     0.0   8.0   112.0 120.0     *   *         *   232.0 199 3 11   1 10     0   8   112 120                 232
1838324 MN Chisago 13 school 2723820 138 Independent Districts and Schools North Branch Public Schools 272382002633 70 Distance Learning Program Distance Learning Program OLL (State approved) Regular School No Other KG 12 2020   grade_8 1.0 0.0 0.0   0.0 0.0     0.0   0.0   0.0 1.0     *   *         *   1.0 1 0 0   0 0     0   0   0 1                 1
1825350 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_8 71.0 1.0 1.0   1.0 1.0     0.0   2.0   39.0 38.0     0.0   0.0     23.0   6.0   77.0 71 1 1   1 1     0   2   39 38     0 0   23 6   77
1834188 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_8 55.0 85.0 25.0   1.0 12.0     0.0   13.0   105.0 86.0     16.0   7.0         28.0   191.0 55 85 25   1 12     0   13   105 86     16 7     28   191
1836300 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_8 2.0 6.0 2.0   0.0 0.0     0.0   1.0   9.0 2.0     0.0   0.0         0.0   11.0 2 6 2   0 0     0   1   9 2     0 0     0   11
1825357 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_8 72.0 0.0 1.0   1.0 0.0     0.0   2.0   51.0 25.0     0.0   0.0     14.0   12.0   76.0 72 0 1   1 0     0   2   51 25     0 0   14 12   76
1834192 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_8 183.0 1.0 6.0   0.0 10.0     0.0   14.0   117.0 97.0     2.0   *     40.0   37.0   214.0 183 1 6   0 10     0   14   117 97     2     40 37   214
1836306 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_8 96.0 0.0 5.0   2.0 8.0     0.0   3.0   65.0 49.0     5.0   3.0     34.0   5.0   114.0 96 0 5   2 8     0   3   65 49     5 3   34 5   114
1838312 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_8 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
1838518 MN Anoka 2 school 2733540 15 Independent Districts and Schools St. Francis Area Schools 273354005205 856 Crossroads School Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No Other KG 12 2020   grade_8 1.0 1.0 0.0   0.0 0.0     0.0   1.0   3.0 0.0     *   *         *   3.0 1 1 0   0 0     0   1   3 0                 3
1825364 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_8 77.0 0.0 1.0   1.0 0.0     0.0   3.0   44.0 38.0     1.0   0.0     7.0   11.0   82.0 77 0 1   1 0     0   3   44 38     1 0   7 11   82
1834282 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_8 392.0 42.0 44.0   11.0 1.0     1.0   36.0   240.0 287.0     29.0   6.0     224.0   83.0   527.0 392 42 44   11 1     1   36   240 287     29 6   224 83   527
1836385 MN Clay 14 school 2721420 152 Independent Districts and Schools Moorhead Public School District 272142000462 980 Red River Area Learning Center Public Area Learning Center ALC (State approved) Alternative School No High 05 12 2020   grade_8 3.0 1.0 0.0   0.0 0.0     0.0   0.0   1.0 3.0     *   *         *   4.0 3 1 0   0 0     0   0   1 3                 4
1838545 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_8 0.0 1.0 0.0   0.0 0.0     0.0   0.0   1.0 0.0     *   *         *   1.0 0 1 0   0 0     0   0   1 0                 1
1838552 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_8 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
1825237 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_8 3.0 0.0 1.0   0.0 0.0     0.0   4.0   6.0 2.0     *   *         *   8.0 3 0 1   0 0     0   4   6 2                 8
1834197 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_8 259.0 69.0 65.0   6.0 43.0     1.0   41.0   245.0 239.0     *   *         *   484.0 259 69 65   6 43     1   41   245 239                 484
1837399 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_8 5.0 0.0 0.0   0.0 0.0     0.0   0.0   4.0 1.0     *   *         *   5.0 5 0 0   0 0     0   0   4 1                 5
1837413 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_8 6.0 1.0 1.0   0.0 0.0     0.0   0.0   1.0 7.0     *   *         *   8.0 6 1 1   0 0     0   0   1 7                 8
1825371 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_8 44.0 0.0 1.0   14.0 0.0     0.0   11.0   39.0 31.0     0.0   1.0     38.0   19.0   70.0 44 0 1   14 0     0   11   39 31     0 1   38 19   70
1834286 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_8 30.0 0.0 3.0   6.0 0.0     0.0   0.0   25.0 14.0     1.0   0.0     16.0   9.0   39.0 30 0 3   6 0     0   0   25 14     1 0   16 9   39
1825378 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_8 15.0 5.0 9.0   0.0 6.0     0.0   2.0   23.0 14.0     2.0   1.0     23.0   8.0   37.0 15 5 9   0 6     0   2   23 14     2 1   23 8   37
1834292 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_8 58.0 0.0 16.0   0.0 2.0     4.0   3.0   46.0 37.0     5.0   0.0     37.0   17.0   83.0 58 0 16   0 2     4   3   46 37     5 0   37 17   83
1834297 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_8 478.0 3.0 13.0   7.0 2.0     0.0   17.0   274.0 246.0     1.0   0.0         84.0   520.0 478 3 13   7 2     0   17   274 246     1 0     84   520
1836398 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_8 4.0 0.0 0.0   0.0 0.0     0.0   1.0   2.0 3.0     *   *         *   5.0 4 0 0   0 0     0   1   2 3                 5
1838813 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_8 3.0 1.0 0.0   0.0 0.0     0.0   0.0   3.0 1.0     *   *         *   4.0 3 1 0   0 0     0   0   3 1                 4
1825385 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_8 73.0 1.0 3.0   0.0 0.0     0.0   4.0   37.0 44.0     0.0   1.0     32.0   17.0   81.0 73 1 3   0 0     0   4   37 44     0 1   32 17   81
1834302 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_8 150.0 1.0 3.0   1.0 1.0     1.0   1.0   76.0 82.0     2.0   0.0     31.0   15.0   158.0 150 1 3   1 1     1   1   76 82     2 0   31 15   158
1834306 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_8 40.0 18.0 14.0   0.0 6.0     1.0   4.0   35.0 48.0     3.0   0.0     33.0   5.0   83.0 40 18 14   0 6     1   4   35 48     3 0   33 5   83
1834310 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_8 66.0 12.0 15.0   2.0 13.0     0.0   6.0   55.0 59.0     5.0   0.0     36.0   18.0   114.0 66 12 15   2 13     0   6   55 59     5 0   36 18   114
1834314 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_8 30.0 23.0 15.0   0.0 5.0     0.0   8.0   31.0 50.0     5.0   0.0     35.0   7.0   81.0 30 23 15   0 5     0   8   31 50     5 0   35 7   81
1836402 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_8 84.0 101.0 83.0   2.0 19.0     0.0   17.0   165.0 141.0     68.0   2.0     212.0   55.0   306.0 84 101 83   2 19     0   17   165 141     68 2   212 55   306
1834318 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_8 207.0 12.0 23.0   1.0 10.0     0.0   16.0   139.0 130.0     11.0   2.0     38.0   *   269.0 207 12 23   1 10     0   16   139 130     11 2   38     269
1834322 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_8 272.0 8.0 26.0   1.0 13.0     0.0   22.0   165.0 177.0     6.0   0.0     49.0   *   342.0 272 8 26   1 13     0   22   165 177     6 0   49     342
1834326 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_8 269.0 16.0 9.0   3.0 6.0     1.0   21.0   169.0 156.0     *   0.0     48.0   59.0   325.0 269 16 9   3 6     1   21   169 156       0   48 59   325
1834330 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_8 198.0 18.0 33.0   0.0 16.0     0.0   23.0   147.0 141.0     9.0   3.0     62.0   41.0   288.0 198 18 33   0 16     0   23   147 141     9 3   62 41   288
1834334 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_8 262.0 15.0 18.0   0.0 17.0     0.0   24.0   167.0 169.0     0.0   *         *   336.0 262 15 18   0 17     0   24   167 169     0           336
1836408 MN Dakota 19 school 2717780 194 Independent Districts and Schools Lakeville Public School District 271778002804 590 Lakeville Area Learning Center Public Area Learning Center ALC (State approved) Alternative School No High 06 12 2020   grade_8 4.0 0.0 1.0   0.0 0.0     0.0   0.0   5.0 0.0     *   *         *   5.0 4 0 1   0 0     0   0   5 0                 5
1838337 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_8 12.0 0.0 0.0   0.0 0.0     0.0   0.0   6.0 6.0     0.0   0.0     0.0   *   12.0 12 0 0   0 0     0   0   6 6     0 0   0     12
1825392 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_8 58.0 0.0 1.0   1.0 1.0     0.0   2.0   32.0 31.0     0.0   1.0     12.0   6.0   63.0 58 0 1   1 1     0   2   32 31     0 1   12 6   63
1834338 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_8 277.0 33.0 42.0   1.0 47.0     0.0   20.0   227.0 193.0     *   0.0         53.0   420.0 277 33 42   1 47     0   20   227 193       0     53   420
1834342 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_8 140.0 58.0 31.0   2.0 36.0     2.0   14.0   149.0 134.0     26.0   *     85.0   48.0   283.0 140 58 31   2 36     2   14   149 134     26     85 48   283
1834346 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_8 346.0 30.0 39.0   1.0 29.0     0.0   30.0   237.0 238.0     11.0   0.0     62.0   66.0   475.0 346 30 39   1 29     0   30   237 238     11 0   62 66   475
1834350 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_8 216.0 53.0 61.0   1.0 23.0     1.0   34.0   198.0 191.0     27.0   5.0     110.0   45.0   389.0 216 53 61   1 23     1   34   198 191     27 5   110 45   389
1834354 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_8 210.0 37.0 26.0   2.0 46.0     1.0   23.0   176.0 169.0     18.0   0.0     72.0   51.0   345.0 210 37 26   2 46     1   23   176 169     18 0   72 51   345
1834358 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_8 160.0 81.0 60.0   2.0 24.0     0.0   35.0   197.0 165.0     33.0   0.0     132.0   63.0   362.0 160 81 60   2 24     0   35   197 165     33 0   132 63   362
1837016 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_8 4.0 3.0 0.0   0.0 0.0     0.0   0.0   7.0 0.0     *   *         *   7.0 4 3 0   0 0     0   0   7 0                 7

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