Data source: Big Local News · About: Big Local

4,774 rows where grade = "grade_7" and state = "MN" sorted by hispanic_int descending

View and edit SQL

year

grade

  • grade_7 · 4,774
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
1834608 MN Nobles 53 school 2744160 518 Independent Districts and Schools Worthington Public School District 274416001840 4 Worthington Middle Middle School (Grades 5-8) Regular School No Middle 05 08 2020   grade_7 59.0 15.0 148.0   0.0 23.0     0.0   5.0   117.0 133.0     *   *     188.0   37.0   250.0 59 15 148   0 23     0   5   117 133           188 37   250
1953536 MN Hennepin 27 school 2731750 280 Independent Districts and Schools RICHFIELD PUBLIC SCHOOL DISTRICT 273175001317 37 RICHFIELD MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_7 81.0 48.0 146.0   1.0 13.0     0.0   29.0   160.0 158.0     70.0   5.0     213.0   54.0   318.0 81 48 146   1 13     0   29   160 158     70 5   213 54   318
1888940 MN Hennepin 27 school 2731750 280 Independent Districts and Schools Richfield Public School District 273175001317 37 Richfield Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2018   grade_7 77.0 50.0 144.0   0.0 14.0     1.0   24.0   162.0 148.0     60.0   5.0     206.0   45.0   310.0 77 50 144   0 14     1   24   162 148     60 5   206 45   310
1721093 MN Nobles 53 school 2744160 518 Independent Districts and Schools Worthington Public School District 274416001840 4 Worthington Middle Middle School (Grades 5-8) Regular School No Middle 05 08 2021   grade_7 48 17 139   2 35     0   8   122 127     65.0   0.0     158.0   38.0   249 48 17 139   2 35     0   8   122 127     65 0   158 38   249
1721065 MN Mower 50 school 2703450 492 Independent Districts and Schools Austin Public School District 270345000150 300 Ellis Middle Middle School (Grades 5-8) Regular School No Middle 07 08 2021   grade_7 201 34 133   0 34     8   10   210 210     79.0   1.0     200.0   64.0   420 201 34 133   0 34     8   10   210 210     79 1   200 64   420
1834460 MN Hennepin 27 school 2731750 280 Independent Districts and Schools Richfield Public School District 273175001317 37 Richfield Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2020   grade_7 99.0 46.0 130.0   6.0 14.0     0.0   36.0   165.0 166.0     44.0   5.0     193.0   44.0   331.0 99 46 130   6 14     0   36   165 166     44 5   193 44   331
1953680 MN Nobles 53 school 2744160 518 Independent Districts and Schools WORTHINGTON PUBLIC SCHOOL DISTRICT 274416001840 4 WORTHINGTON MIDDLE Middle School (Grades 5-8) Regular School No Middle 05 08 2019   grade_7 67.0 18.0 129.0   2.0 18.0     0.0   7.0   129.0 112.0     62.0   1.0     177.0   50.0   241.0 67 18 129   2 18     0   7   129 112     62 1   177 50   241
1720946 MN Hennepin 27 school 2731750 280 Independent Districts and Schools Richfield Public School District 273175001317 37 Richfield Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 79 36 128   3 10     0   38   157 137     59.0   3.0     158.0   40.0   294 79 36 128   3 10     0   38   157 137     59 3   158 40   294
697989 MN Hennepin 27 school 2731750 280 Independent Districts and Schools RICHFIELD PUBLIC SCHOOL DISTRICT 273175001317 37 RICHFIELD MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_7 72.0 42.0 125.0   2.0 16.0     0.0   25.0   165.0 117.0     79.0   3.0     190.0   58.0   282.0 72 42 125   2 16     0   25   165 117     79 3   190 58   282
698115 MN Nobles 53 school 2744160 518 Independent Districts and Schools WORTHINGTON PUBLIC SCHOOL DISTRICT 274416001840 4 WORTHINGTON MIDDLE Middle School (Grades 5-8) Regular School No Middle 05 08 2017   grade_7 77.0 20.0 122.0   1.0 23.0     0.0   7.0   130.0 120.0         *     180.0   *   250.0 77 20 122   1 23     0   7   130 120           180     250
1953652 MN Mower 50 school 2703450 492 Independent Districts and Schools AUSTIN PUBLIC SCHOOL DISTRICT 270345000150 300 ELLIS MIDDLE Middle School (Grades 5-8) Regular School No Middle 07 08 2019   grade_7 179.0 29.0 118.0   0.0 18.0     3.0   15.0   183.0 179.0     41.0   0.0     213.0   *   362.0 179 29 118   0 18     3   15   183 179     41 0   213     362
1953605 MN Kandiyohi 34 school 2742720 347 Independent Districts and Schools WILLMAR PUBLIC SCHOOL DISTRICT 274272001808 301 WILLMAR MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_7 127.0 47.0 117.0   3.0 4.0     1.0   9.0   158.0 150.0     *   0.0         *   308.0 127 47 117   3 4     1   9   158 150       0         308
1154825 MN Hennepin 27 school 2731750 280 Independent Districts and Schools RICHFIELD PUBLIC SCHOOL DISTRICT 273175001317 37 RICHFIELD MIDDLE Middle School (Grades 5-8) Regular School No 2 06 08 2015   grade_7 80.0 61.0 116.0   3.0 14.0     0.0   15.0   147.0 142.0     103.0   0.0     198.0   57.0   289.0 80 61 116   3 14     0   15   147 142     103 0   198 57   289
1720891 MN Hennepin 27 school 2705790 271 Independent Districts and Schools Bloomington Public School District 270579000638 345 Valley View Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 79 73 115   4 24     0   18   166 147     53.0   5.0     197.0   40.0   313 79 73 115   4 24     0   18   166 147     53 5   197 40   313
1889009 MN Kandiyohi 34 school 2742720 347 Independent Districts and Schools Willmar Public School District 274272001808 301 Willmar Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2018   grade_7 140.0 55.0 115.0   2.0 9.0     1.0   4.0   171.0 155.0     62.0   2.0     201.0   42.0   326.0 140 55 115   2 9     1   4   171 155     62 2   201 42   326
1834533 MN Kandiyohi 34 school 2742720 347 Independent Districts and Schools Willmar Public School District 274272001808 301 Willmar Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2020   grade_7 136.0 48.0 114.0   0.0 9.0     1.0   2.0   147.0 163.0     60.0   *     187.0   44.0   310.0 136 48 114   0 9     1   2   147 163     60     187 44   310
1834580 MN Mower 50 school 2703450 492 Independent Districts and Schools Austin Public School District 270345000150 300 Ellis Middle Middle School (Grades 5-8) Regular School No Middle 07 08 2020   grade_7 180.0 30.0 114.0   2.0 26.0     8.0   13.0   173.0 200.0     60.0   0.0     216.0   *   373.0 180 30 114   2 26     8   13   173 200     60 0   216     373
1889084 MN Nobles 53 school 2744160 518 Independent Districts and Schools Worthington Public School District 274416001840 4 Worthington Middle Middle School (Grades 5-8) Regular School No Middle 05 08 2018   grade_7 67.0 20.0 110.0   1.0 29.0     1.0   4.0   124.0 108.0     *   *     158.0   *   232.0 67 20 110   1 29     1   4   124 108           158     232
1721018 MN Kandiyohi 34 school 2742720 347 Independent Districts and Schools Willmar Public School District 274272001808 301 Willmar Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 101 56 109   2 7     2   9   151 135     *   *     *   *   286 101 56 109   2 7     2   9   151 135                 286
698050 MN Kandiyohi 34 school 2742720 347 Independent Districts and Schools WILLMAR PUBLIC SCHOOL DISTRICT 274272001808 301 WILLMAR MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_7 145.0 62.0 108.0   1.0 7.0     0.0   1.0   164.0 160.0     64.0   3.0     203.0   33.0   324.0 145 62 108   1 7     0   1   164 160     64 3   203 33   324
697713 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 2017   grade_7 45.0 90.0 107.0   1.0 8.0     0.0   18.0   131.0 138.0         *         41.0   269.0 45 90 107   1 8     0   18   131 138             41   269
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
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
1953485 MN Hennepin 27 school 2705790 271 Independent Districts and Schools BLOOMINGTON PUBLIC SCHOOL DISTRICT 270579000638 345 VALLEY VIEW MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_7 60.0 48.0 106.0   1.0 14.0     0.0   26.0   134.0 121.0     44.0   7.0     170.0   32.0   255.0 60 48 106   1 14     0   26   134 121     44 7   170 32   255
1720676 MN Anoka 2 school 2709510 13 Independent Districts and Schools Columbia Heights Public School District 270951000395 17 Columbia Academy Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 43 68 101   3 9     1   21   124 122     59.0   3.0     199.0   47.0   246 43 68 101   3 9     1   21   124 122     59 3   199 47   246
862296 MN Nobles 53 school 2744160 518 Independent Districts and Schools WORTHINGTON PUBLIC SCHOOL DISTRICT 274416001840 4 WORTHINGTON MIDDLE Middle School (Grades 5-8) Regular School No 2 05 08 2016   grade_7 65 11 99   1 27     0   3   101 105     39.0   *     146.0   31.0   206 65 11 99   1 27     0   3   101 105     39     146 31   206
698208 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384001591 330 HIGHLAND PARK MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_7 114.0 52.0 96.0   2.0 15.0     0.0   13.0   142.0 150.0     45.0   3.0     141.0   33.0   292.0 114 52 96   2 15     0   13   142 150     45 3   141 33   292
862169 MN Hennepin 27 school 2731750 280 Independent Districts and Schools RICHFIELD PUBLIC SCHOOL DISTRICT 273175001317 37 RICHFIELD MIDDLE Middle School (Grades 5-8) Regular School No 2 06 08 2016   grade_7 98 45 96   1 16     0   18   133 141     79.0   1.0     168.0   37.0   274 98 45 96   1 16     0   18   133 141     79 1   168 37   274
1835122 MN Hennepin 27 school 2700288 4170 Charter Schools Hiawatha Academies 270028804599 11 Hiawatha College Prep - Kingfield Middle School (Grades 5-8) Regular School Yes Middle 05 08 2020   grade_7 1.0 7.0 95.0   0.0 0.0     0.0   0.0   54.0 49.0     48.0   1.0     86.0   12.0   103.0 1 7 95   0 0     0   0   54 49     48 1   86 12   103
1888889 MN Hennepin 27 school 2705790 271 Independent Districts and Schools Bloomington Public School District 270579000638 345 Valley View Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2018   grade_7 44.0 78.0 95.0   2.0 20.0     0.0   20.0   131.0 128.0     48.0   11.0     197.0   49.0   259.0 44 78 95   2 20     0   20   131 128     48 11   197 49   259
1721191 MN Ramsey 62 school 2733840 625 Independent Districts and Schools St. Paul Public School District 273384001591 330 Highland Park Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 110 52 94   3 13     0   21   160 133     37.0   2.0     133.0   33.0   293 110 52 94   3 13     0   21   160 133     37 2   133 33   293
1953258 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 2019   grade_7 39.0 84.0 94.0   5.0 8.0     0.0   15.0   127.0 118.0     39.0   5.0     182.0   32.0   245.0 39 84 94   5 8     0   15   127 118     39 5   182 32   245
697936 MN Hennepin 27 school 2705790 271 Independent Districts and Schools BLOOMINGTON PUBLIC SCHOOL DISTRICT 270579000638 345 VALLEY VIEW MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_7 59.0 53.0 92.0   1.0 18.0     0.0   14.0   128.0 109.0     40.0   4.0     166.0   32.0   237.0 59 53 92   1 18     0   14   128 109     40 4   166 32   237
862230 MN Kandiyohi 34 school 2742720 347 Independent Districts and Schools WILLMAR PUBLIC SCHOOL DISTRICT 274272001808 301 WILLMAR MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No 2 06 08 2016   grade_7 158 47 91   2 11     0   3   149 163     55.0   1.0     175.0   34.0   312 158 47 91   2 11     0   3   149 163     55 1   175 34   312
1834409 MN Hennepin 27 school 2705790 271 Independent Districts and Schools Bloomington Public School District 270579000638 345 Valley View Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2020   grade_7 40.0 65.0 91.0   2.0 16.0     0.0   19.0   120.0 113.0     37.0   5.0     162.0   39.0   233.0 40 65 91   2 16     0   19   120 113     37 5   162 39   233
1154886 MN Kandiyohi 34 school 2742720 347 Independent Districts and Schools WILLMAR PUBLIC SCHOOL DISTRICT 274272001808 301 WILLMAR MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No 2 06 08 2015   grade_7 133.0 37.0 90.0   1.0 4.0     0.0   3.0   139.0 129.0     58.0   3.0     151.0   34.0   268.0 133 37 90   1 4     0   3   139 129     58 3   151 34   268
1154952 MN Nobles 53 school 2744160 518 Independent Districts and Schools WORTHINGTON PUBLIC SCHOOL DISTRICT 274416001840 4 WORTHINGTON MIDDLE Middle School (Grades 5-8) Regular School No 2 05 08 2015   grade_7 83.0 11.0 89.0   0.0 21.0     0.0   4.0   97.0 111.0     31.0   0.0         *   208.0 83 11 89   0 21     0   4   97 111     31 0         208
1888663 MN Anoka 2 school 2709510 13 Independent Districts and Schools Columbia Heights Public School District 270951000395 17 Columbia Academy Middle School (Grades 5-8) Regular School No Middle 06 08 2018   grade_7 48.0 91.0 88.0   7.0 14.0     0.0   19.0   130.0 137.0     59.0   8.0     205.0   31.0   267.0 48 91 88   7 14     0   19   130 137     59 8   205 31   267
690317 MN Dakota 19 school 2733270 6 Special Districts and Schools SOUTH ST. PAUL PUBLIC SCHOOL DIST. 273327001456 120 SOUTH ST. PAUL SECONDARY Secondary School (Grades 7-12) Regular School No Other 06 12 2017   grade_7 141.0 18.0 87.0   1.0 4.0     0.0   16.0   134.0 133.0     4.0   2.0     145.0   47.0   267.0 141 18 87   1 4     0   16   134 133     4 2   145 47   267
698089 MN Mower 50 school 2703450 492 Independent Districts and Schools AUSTIN PUBLIC SCHOOL DISTRICT 270345000150 300 ELLIS MIDDLE Middle School (Grades 5-8) Regular School No Middle 07 08 2017   grade_7 192.0 25.0 87.0   0.0 20.0     1.0   12.0   170.0 167.0     26.0   5.0     184.0   *   337.0 192 25 87   0 20     1   12   170 167     26 5   184     337
1155042 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384001591 330 HIGHLAND PARK MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No 2 06 08 2015   grade_7 81.0 55.0 87.0   4.0 18.0     0.0   2.0   123.0 124.0     91.0   3.0     138.0   31.0   247.0 81 55 87   4 18     0   2   123 124     91 3   138 31   247
1954178 MN Hennepin 27 school 2700288 4170 Charter Schools HIAWATHA ACADEMIES 270028804599 11 Hiawatha College Prep - Kingfield Middle School (Grades 5-8) Regular School Yes Middle 05 08 2019   grade_7 0.0 9.0 87.0   0.0 0.0     0.0   0.0   42.0 54.0     38.0   1.0     80.0   17.0   96.0 0 9 87   0 0     0   0   42 54     38 1   80 17   96
1154926 MN Mower 50 school 2703450 492 Independent Districts and Schools AUSTIN PUBLIC SCHOOL DISTRICT 270345000150 300 ELLIS MIDDLE Middle School (Grades 5-8) Regular School No 2 05 08 2015   grade_7 208.0 28.0 85.0   0.0 18.0     1.0   14.0   187.0 167.0     50.0   0.0     205.0   *   354.0 208 28 85   0 18     1   14   187 167     50 0   205     354
1834686 MN Ramsey 62 school 2732430 623 Independent Districts and Schools Roseville Public School District 273243002667 70 Roseville Area Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2020   grade_7 181.0 71.0 85.0   1.0 90.0     0.0   30.0   221.0 237.0     55.0   4.0     225.0   39.0   458.0 181 71 85   1 90     0   30   221 237     55 4   225 39   458
1889178 MN Ramsey 62 school 2733840 625 Independent Districts and Schools St. Paul Public School District 273384001591 330 Highland Park Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2018   grade_7 101.0 49.0 85.0   2.0 10.0     0.0   14.0   132.0 129.0     31.0   1.0     133.0   26.0   261.0 101 49 85   2 10     0   14   132 129     31 1   133 26   261
1889567 MN Hennepin 27 school 2700288 4170 Charter Schools Hiawatha Academies 270028804599 11 Hiawatha College Prep - Kingfield Middle School (Grades 5-8) Regular School Yes Middle 05 08 2018   grade_7 1.0 3.0 85.0   1.0 0.0     0.0   0.0   46.0 44.0     34.0   5.0     70.0   9.0   90.0 1 3 85   1 0     0   0   46 44     34 5   70 9   90
1955447 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 2019   grade_7 73.0 98.0 85.0   4.0 18.0     0.0   15.0   144.0 149.0     74.0   2.0     198.0   70.0   293.0 73 98 85   4 18     0   15   144 149     74 2   198 70   293
698591 MN Hennepin 27 school 2700288 4170 Charter Schools HIAWATHA ACADEMIES 270028804599 11 Hiawatha College Prep - Kingfield Middle School (Grades 5-8) Regular School Yes Middle 05 08 2017   grade_7 0.0 5.0 83.0   2.0 0.0     0.0   0.0   43.0 47.0     40.0   11.0         6.0   90.0 0 5 83   2 0     0   0   43 47     40 11     6   90
862390 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384001591 330 HIGHLAND PARK MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No 2 06 08 2016   grade_7 125 45 83   2 9     0   5   135 134     52.0   3.0     121.0   25.0   269 125 45 83   2 9     0   5   135 134     52 3   121 25   269
1953775 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384001591 330 HIGHLAND PARK MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_7 112.0 54.0 83.0   1.0 12.0     0.0   10.0   140.0 132.0     21.0   1.0     125.0   25.0   272.0 112 54 83   1 12     0   10   140 132     21 1   125 25   272
1154788 MN Hennepin 27 school 2705790 271 Independent Districts and Schools BLOOMINGTON PUBLIC SCHOOL DISTRICT 270579000638 345 VALLEY VIEW MIDDLE Middle School (Grades 5-8) Regular School No 2 06 08 2015   grade_7 51.0 51.0 81.0   4.0 21.0     0.0   5.0   98.0 115.0     53.0   4.0     158.0   30.0   213.0 51 51 81   4 21     0   5   98 115     53 4   158 30   213
1826527 MN Dakota 19 school 2733270 6 Special Districts and Schools South St. Paul Public School Dist. 273327001456 120 South St. Paul Secondary Secondary School (Grades 7-12) Regular School No High 06 12 2020   grade_7 126.0 26.0 81.0   2.0 4.0     0.0   21.0   125.0 135.0     17.0   2.0     133.0   57.0   260.0 126 26 81   2 4     0   21   125 135     17 2   133 57   260
1890820 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 2018   grade_7 118.0 107.0 81.0   3.0 27.0     3.0   35.0   189.0 185.0     51.0   1.0     233.0   70.0   374.0 118 107 81   3 27     3   35   189 185     51 1   233 70   374
697894 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 2017   grade_7 88.0 13.0 80.0   1.0 5.0     0.0   19.0   105.0 101.0     30.0   4.0     122.0   36.0   206.0 88 13 80   1 5     0   19   105 101     30 4   122 36   206
697997 MN Hennepin 27 school 2731780 281 Independent Districts and Schools ROBBINSDALE PUBLIC SCHOOL DISTRICT 273178002184 43 ROBBINSDALE MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_7 109.0 162.0 80.0   3.0 36.0     0.0   38.0   230.0 198.0     48.0   7.0     294.0   69.0   428.0 109 162 80   3 36     0   38   230 198     48 7   294 69   428
862074 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 2 05 08 2016   grade_7 65 17 80   4 9     0   5   98 82     38.0   *     107.0   38.0   180 65 17 80   4 9     0   5   98 82     38     107 38   180
862270 MN Mower 50 school 2703450 492 Independent Districts and Schools AUSTIN PUBLIC SCHOOL DISTRICT 270345000150 300 ELLIS MIDDLE Middle School (Grades 5-8) Regular School No 2 06 08 2016   grade_7 204 16 80   0 24     2   11   174 163         *     191.0   58.0   337 204 16 80   0 24     2   11   174 163           191 58   337
1721210 MN Rice 66 school 2711760 656 Independent Districts and Schools Faribault Public School District 271176000557 70 Faribault Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 114 57 80   0 3     0   9   149 114     34.0   1.0     170.0   42.0   263 114 57 80   0 3     0   9   149 114     34 1   170 42   263
1889056 MN Mower 50 school 2703450 492 Independent Districts and Schools Austin Public School District 270345000150 300 Ellis Middle Middle School (Grades 5-8) Regular School No Middle 07 08 2018   grade_7 176.0 28.0 80.0   0.0 25.0     4.0   12.0   154.0 171.0     *   *     187.0   *   325.0 176 28 80   0 25     4   12   154 171           187     325
1155416 MN Hennepin 27 school 2700288 4170 Charter Schools HIAWATHA ACADEMIES 270028804599 11 Hiawatha College Prep Middle School (Grades 5-8) Regular School Yes 2 05 08 2015   grade_7 1.0 3.0 79.0   1.0 0.0     0.0   0.0   46.0 38.0     68.0   1.0         7.0   84.0 1 3 79   1 0     0   0   46 38     68 1     7   84
1953754 MN Ramsey 62 school 2732430 623 Independent Districts and Schools ROSEVILLE PUBLIC SCHOOL DISTRICT 273243002667 70 ROSEVILLE AREA MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_7 216.0 76.0 79.0   2.0 102.0     0.0   36.0   268.0 243.0     61.0   9.0     246.0   80.0   511.0 216 76 79   2 102     0   36   268 243     61 9   246 80   511
1953700 MN Olmsted 55 school 2731800 535 Independent Districts and Schools ROCHESTER PUBLIC SCHOOL DISTRICT 273180001019 330 WILLOW CREEK MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_7 180.0 48.0 78.0   4.0 26.0     0.0   22.0   180.0 178.0     53.0   10.0     170.0   70.0   358.0 180 48 78   4 26     0   22   180 178     53 10   170 70   358
1720690 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 2021   grade_7 276 55 77   4 38     0   36   231 255     44.0   2.0     143.0   64.0   486 276 55 77   4 38     0   36   231 255     44 2   143 64   486
1720857 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 2021   grade_7 108 24 77   2 17     0   22   132 118     30.0   0.0     104.0   40.0   250 108 24 77   2 17     0   22   132 118     30 0   104 40   250
697898 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 2017   grade_7 178.0 37.0 76.0   0.0 16.0     0.0   18.0   162.0 163.0     31.0   0.0     133.0   32.0   325.0 178 37 76   0 16     0   18   162 163     31 0   133 32   325
698187 MN Ramsey 62 school 2732430 623 Independent Districts and Schools ROSEVILLE PUBLIC SCHOOL DISTRICT 273243002667 70 ROSEVILLE AREA MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_7 202.0 76.0 76.0   2.0 103.0     0.0   20.0   245.0 234.0         2.0         53.0   479.0 202 76 76   2 103     0   20   245 234       2     53   479
1154746 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 2 05 08 2015   grade_7 81.0 21.0 76.0   1.0 2.0     0.0   11.0   98.0 94.0     28.0   1.0     110.0   40.0   192.0 81 21 76   1 2     0   11   98 94     28 1   110 40   192
1154833 MN Hennepin 27 school 2731780 281 Independent Districts and Schools ROBBINSDALE PUBLIC SCHOOL DISTRICT 273178002184 43 ROBBINSDALE MIDDLE Middle School (Grades 5-8) Regular School No 2 06 08 2015   grade_7 129.0 179.0 76.0   6.0 49.0     0.0   29.0   251.0 217.0     54.0   2.0     319.0   88.0   468.0 129 179 76   6 49     0   29   251 217     54 2   319 88   468
1888948 MN Hennepin 27 school 2731780 281 Independent Districts and Schools Robbinsdale Public School District 273178002184 43 Robbinsdale Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2018   grade_7 76.0 114.0 75.0   3.0 22.0     0.0   21.0   160.0 151.0     43.0   8.0     223.0   50.0   311.0 76 114 75   3 22     0   21   160 151     43 8   223 50   311
1889476 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124000937 309 Anwatin Middle Com and Spanish D I Middle School (Grades 5-8) Regular School No Middle 06 08 2018   grade_7 20.0 55.0 75.0   4.0 14.0     0.0   6.0   83.0 91.0     57.0   5.0     122.0   30.0   174.0 20 55 75   4 14     0   6   83 91     57 5   122 30   174
1945670 MN Dakota 19 school 2733270 6 Special Districts and Schools SOUTH ST. PAUL PUBLIC SCHOOL DIST. 273327001456 120 SOUTH ST. PAUL SECONDARY Secondary School (Grades 7-12) Regular School No High 06 12 2019   grade_7 133.0 19.0 75.0   2.0 3.0     0.0   23.0   142.0 113.0     5.0   0.0     136.0   34.0   255.0 133 19 75   2 3     0   23   142 113     5 0   136 34   255
1721530 MN Dakota 19 school 2733270 6 Special Districts and Schools South St. Paul Public School District 273327005313 110 South St. Paul Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 117 27 74   1 5     0   30   125 129     17.0   1.0     130.0   37.0   254 117 27 74   1 5     0   30   125 129     17 1   130 37   254
1889104 MN Olmsted 55 school 2731800 535 Independent Districts and Schools Rochester Public School District 273180001019 330 Willow Creek Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2018   grade_7 217.0 44.0 74.0   2.0 31.0     0.0   11.0   199.0 180.0     40.0   7.0     162.0   69.0   379.0 217 44 74   2 31     0   11   199 180     40 7   162 69   379
1889157 MN Ramsey 62 school 2732430 623 Independent Districts and Schools Roseville Public School District 273243002667 70 Roseville Area Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2018   grade_7 171.0 94.0 74.0   4.0 96.0     0.0   21.0   249.0 211.0     *   4.0     245.0   60.0   460.0 171 94 74   4 96     0   21   249 211       4   245 60   460
1720853 MN Dakota 19 school 2742270 197 Independent Districts and Schools West St. Paul-Mendota Heights-Eagan 274227001774 54 Heritage E-STEM Magnet School Middle School (Grades 5-8) Regular School No Middle 05 08 2021   grade_7 85 19 73   3 4     0   17   96 105     *   6.0     99.0   35.0   201 85 19 73   3 4     0   17   96 105       6   99 35   201
1721611 MN Hennepin 27 school 2700288 4170 Charter Schools Hiawatha Academies 270028805141 15 Hiawatha College Prep - Northrop Middle School (Grades 5-8) Regular School Yes Middle 05 07 2021   grade_7 0 7 73   0 1     0   1   44 38     32.0   1.0     73.0   11.0   82 0 7 73   0 1     0   1   44 38     32 1   73 11   82
1834707 MN Ramsey 62 school 2733840 625 Independent Districts and Schools St. Paul Public School District 273384001591 330 Highland Park Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2020   grade_7 99.0 55.0 73.0   2.0 15.0     0.0   22.0   132.0 134.0     36.0   3.0     124.0   34.0   266.0 99 55 73   2 15     0   22   132 134     36 3   124 34   266
862116 MN Hennepin 27 school 2705790 271 Independent Districts and Schools BLOOMINGTON PUBLIC SCHOOL DISTRICT 270579000638 345 VALLEY VIEW MIDDLE Middle School (Grades 5-8) Regular School No 2 06 08 2016   grade_7 56 55 72   1 13     0   6   110 93     36.0   2.0     146.0   28.0   203 56 55 72   1 13     0   6   110 93     36 2   146 28   203
1154590 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 2 06 08 2015   grade_7 62.0 72.0 72.0   2.0 12.0     0.0   7.0   110.0 117.0     33.0   5.0         35.0   227.0 62 72 72   2 12     0   7   110 117     33 5     35   227
1720879 MN Freeborn 24 school 2702970 241 Independent Districts and Schools Albert Lea Public School District 270297000078 320 Southwest Middle Middle School (Grades 5-8) Regular School No Middle 06 07 2021   grade_7 165 7 72   0 21     0   8   149 124     *   *     *   *   273 165 7 72   0 21     0   8   149 124                 273
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
1834632 MN Olmsted 55 school 2731800 535 Independent Districts and Schools Rochester Public School District 273180001019 330 Willow Creek Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2020   grade_7 177.0 39.0 72.0   2.0 20.0     1.0   25.0   163.0 173.0     36.0   7.0     137.0   46.0   336.0 177 39 72   2 20     1   25   163 173     36 7   137 46   336
861912 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 2 06 08 2016   grade_7 38 69 71   5 12     2   15   118 94     28.0   4.0     180.0   35.0   212 38 69 71   5 12     2   15   118 94     28 4   180 35   212
1155058 MN Rice 66 school 2711760 656 Independent Districts and Schools FARIBAULT PUBLIC SCHOOL DISTRICT 271176000557 70 FARIBAULT MIDDLE Middle School (Grades 5-8) Regular School No 2 06 08 2015   grade_7 182.0 37.0 71.0   0.0 5.0     0.0   2.0   144.0 153.0     60.0   10.0     169.0   43.0   297.0 182 37 71   0 5     0   2   144 153     60 10   169 43   297
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
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
862406 MN Rice 66 school 2711760 656 Independent Districts and Schools FARIBAULT PUBLIC SCHOOL DISTRICT 271176000557 70 FARIBAULT MIDDLE Middle School (Grades 5-8) Regular School No 2 06 08 2016   grade_7 161 35 70   3 7     0   4   148 132     45.0   9.0     148.0   32.0   280 161 35 70   3 7     0   4   148 132     45 9   148 32   280
862779 MN Hennepin 27 school 2700288 4170 Charter Schools HIAWATHA ACADEMIES 270028804599 11 Hiawatha College Prep Middle School (Grades 5-8) Regular School Yes 2 05 08 2016   grade_7 0 7 69   1 1     0   0   37 41     40.0   12.0         9.0   78 0 7 69   1 1     0   0   37 41     40 12     9   78
697726 MN Anoka 2 school 2733330 16 Independent Districts and Schools SPRING LAKE PARK PUBLIC SCHOOLS 273333001466 92 WESTWOOD MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_7 257.0 37.0 68.0   2.0 30.0     0.0   29.0   193.0 230.0     29.0   3.0     169.0   47.0   423.0 257 37 68   2 30     0   29   193 230     29 3   169 47   423
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
1953890 MN Steele 74 school 2728050 761 Independent Districts and Schools OWATONNA PUBLIC SCHOOL DISTRICT 272805001227 151 Owatonna Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_7 264.0 30.0 68.0   1.0 4.0     0.0   6.0   190.0 183.0     *   *     152.0   49.0   373.0 264 30 68   1 4     0   6   190 183           152 49   373
1721117 MN Olmsted 55 school 2731800 535 Independent Districts and Schools Rochester Public School District 273180001019 330 Willow Creek Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 165 50 67   0 16     0   24   180 142     36.0   6.0     141.0   64.0   322 165 50 67   0 16     0   24   180 142     36 6   141 64   322
1721170 MN Ramsey 62 school 2732430 623 Independent Districts and Schools Roseville Public School District 273243002667 70 Roseville Area Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 157 74 67   2 101     0   40   229 212     70.0   5.0     225.0   81.0   441 157 74 67   2 101     0   40   229 212     70 5   225 81   441
1721252 MN Scott 70 school 2733000 720 Independent Districts and Schools Shakopee Public School District 273300001439 84 Shakopee West Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 189 22 67   1 35     0   22   167 169     21.0   2.0     93.0   45.0   336 189 22 67   1 35     0   22   167 169     21 2   93 45   336
1721606 MN Hennepin 27 school 2700288 4170 Charter Schools Hiawatha Academies 270028804599 11 Hiawatha College Prep - Kingfield Middle School (Grades 5-8) Regular School Yes Middle 05 08 2021   grade_7 0 12 67   1 0     0   0   40 40     37.0   0.0     69.0   9.0   80 0 12 67   1 0     0   0   40 40     37 0   69 9   80
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
1888851 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 2018   grade_7 152.0 21.0 67.0   1.0 9.0     0.0   21.0   134.0 137.0     20.0   3.0     107.0   29.0   271.0 152 21 67   1 9     0   21   134 137     20 3   107 29   271
1954084 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 2019   grade_7 27.0 70.0 67.0   6.0 10.0     1.0   9.0   86.0 104.0     37.0   1.0     135.0   25.0   190.0 27 70 67   6 10     1   9   86 104     37 1   135 25   190
1954100 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 2019   grade_7 142.0 81.0 67.0   19.0 8.0     1.0   10.0   161.0 167.0     53.0   5.0     172.0   47.0   328.0 142 81 67   19 8     1   10   161 167     53 5   172 47   328
860761 MN Hennepin 27 school 2721240 1 Special Districts and Schools MINNEAPOLIS PUBLIC SCHOOL DIST. 272124000932 190 ANDERSEN COMMUNITY Elementary School (Grades PK-6) Regular School No 1 PK 08 2016   grade_7 5 41 66   6 4     0   0   59 63     86.0   14.0         31.0   122 5 41 66   6 4     0   0   59 63     86 14     31   122

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