Data source: Big Local News · About: Big Local

4,774 rows where grade = "grade_7" and state = "MN" sorted by homeless_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
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
1155337 MN Hennepin 27 school 2721240 1 Special Districts and Schools MINNEAPOLIS PUBLIC SCHOOL DIST. 272124001028 324 SANFORD MIDDLE Middle School (Grades 5-8) Regular School No 2 06 08 2015   grade_7 84.0 82.0 41.0   16.0 12.0     0.0   2.0   112.0 125.0     54.0   21.0     154.0   39.0   237.0 84 82 41   16 12     0   2   112 125     54 21   154 39   237
862672 MN Hennepin 27 school 2721240 1 Special Districts and Schools MINNEAPOLIS PUBLIC SCHOOL DIST. 272124000937 309 ANWATIN MIDDLE COM & SPANISH D I Middle School (Grades 5-8) Regular School No 2 06 08 2016   grade_7 25 92 62   5 16     0   3   109 94     54.0   20.0     159.0   34.0   203 25 92 62   5 16     0   3   109 94     54 20   159 34   203
1889484 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 2018   grade_7 17.0 76.0 19.0   3.0 15.0     0.0   3.0   77.0 56.0     20.0   20.0     115.0   33.0   133.0 17 76 19   3 15     0   3   77 56     20 20   115 33   133
1155321 MN Hennepin 27 school 2721240 1 Special Districts and Schools MINNEAPOLIS PUBLIC SCHOOL DIST. 272124000937 309 ANWATIN MIDDLE COM & SPANISH D I Middle School (Grades 5-8) Regular School No 2 06 08 2015   grade_7 24.0 100.0 49.0   4.0 27.0     0.0   1.0   103.0 102.0     56.0   19.0     170.0   40.0   205.0 24 100 49   4 27     0   1   103 102     56 19   170 40   205
1720652 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 2021   grade_7 281 106 40   6 37     1   58   258 271     35.0   19.0     248.0   91.0   529 281 106 40   6 37     1   58   258 271     35 19   248 91   529
862688 MN Hennepin 27 school 2721240 1 Special Districts and Schools MINNEAPOLIS PUBLIC SCHOOL DIST. 272124001028 324 SANFORD MIDDLE Middle School (Grades 5-8) Regular School No 2 06 08 2016   grade_7 104 87 36   27 10     0   4   132 136     54.0   18.0     165.0   37.0   268 104 87 36   27 10     0   4   132 136     54 18   165 37   268
1720702 MN Beltrami 4 school 2730510 38 Independent Districts and Schools Red Lake Public School District 273051002427 40 Red Lake Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 1 0 0   83 0     0   0   51 33     0.0   18.0     *   21.0   84 1 0 0   83 0     0   0   51 33     0 18     21   84
698502 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 2017   grade_7 20.0 92.0 48.0   2.0 17.0     1.0   1.0   101.0 80.0     49.0   17.0     141.0   45.0   181.0 20 92 48   2 17     1   1   101 80     49 17   141 45   181
1953234 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 2019   grade_7 260.0 80.0 36.0   7.0 25.0     0.0   26.0   236.0 198.0     21.0   17.0     229.0   73.0   434.0 260 80 36   7 25     0   26   236 198     21 17   229 73   434
1153464 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 2015   grade_7 5.0 43.0 66.0   7.0 2.0     0.0   0.0   76.0 47.0     80.0   16.0         34.0   123.0 5 43 66   7 2     0   0   76 47     80 16     34   123
698522 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 2017   grade_7 2.0 83.0 25.0   5.0 1.0     1.0   1.0   55.0 63.0     17.0   15.0         28.0   118.0 2 83 25   5 1     1   1   55 63     17 15     28   118
862680 MN Hennepin 27 school 2721240 1 Special Districts and Schools MINNEAPOLIS PUBLIC SCHOOL DIST. 272124002581 318 OLSON MIDDLE Middle School (Grades 5-8) Regular School No 2 06 08 2016   grade_7 4 68 7   5 11     0   1   57 39     8.0   15.0         29.0   96 4 68 7   5 11     0   1   57 39     8 15     29   96
697993 MN Hennepin 27 school 2731780 281 Independent Districts and Schools ROBBINSDALE PUBLIC SCHOOL DISTRICT 273178001333 40 PLYMOUTH MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_7 248.0 94.0 58.0   0.0 17.0     0.0   50.0   221.0 246.0     19.0   14.0     193.0   60.0   467.0 248 94 58   0 17     0   50   221 246     19 14   193 60   467
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
862676 MN Hennepin 27 school 2721240 1 Special Districts and Schools MINNEAPOLIS PUBLIC SCHOOL DIST. 272124001008 316 NORTHEAST MIDDLE Middle School (Grades 5-8) Regular School No 2 06 08 2016   grade_7 38 96 34   10 8     0   0   105 81     30.0   14.0     151.0   41.0   186 38 96 34   10 8     0   0   105 81     30 14   151 41   186
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
862381 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384001556 310 BATTLE CREEK MIDDLE Middle School (Grades 5-8) Regular School No 2 06 08 2016   grade_7 24 82 35   3 104     0   9   151 106     107.0   13.0     228.0   46.0   257 24 82 35   3 104     0   9   151 106     107 13   228 46   257
1155329 MN Hennepin 27 school 2721240 1 Special Districts and Schools MINNEAPOLIS PUBLIC SCHOOL DIST. 272124002581 318 OLSON MIDDLE Middle School (Grades 5-8) Regular School No 2 06 08 2015   grade_7 5.0 59.0 5.0   6.0 12.0     0.0   0.0   48.0 39.0     5.0   13.0         28.0   87.0 5 59 5   6 12     0   0   48 39     5 13     28   87
1839077 MN Stearns 73 school 2733510 742 Independent Districts and Schools St. Cloud Public School District 273351001492 54 South Junior High Junior High School (Grades 7-8 or 7-9) Regular School No Middle 06 08 2020   grade_7 128.0 123.0 21.0   0.0 5.0     0.0   25.0   162.0 140.0     42.0   13.0     195.0   49.0   302.0 128 123 21   0 5     0   25   162 140     42 13   195 49   302
1889492 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 2018   grade_7 127.0 91.0 56.0   29.0 14.0     0.0   13.0   172.0 158.0     59.0   13.0     212.0   55.0   330.0 127 91 56   29 14     0   13   172 158     59 13   212 55   330
1953230 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 2019   grade_7 454.0 68.0 27.0   6.0 23.0     1.0   33.0   306.0 306.0     23.0   13.0     209.0   104.0   612.0 454 68 27   6 23     1   33   306 306     23 13   209 104   612
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
1155325 MN Hennepin 27 school 2721240 1 Special Districts and Schools MINNEAPOLIS PUBLIC SCHOOL DIST. 272124001008 316 NORTHEAST MIDDLE Middle School (Grades 5-8) Regular School No 2 06 08 2015   grade_7 40.0 102.0 33.0   9.0 10.0     0.0   4.0   107.0 91.0     29.0   12.0     164.0   50.0   198.0 40 102 33   9 10     0   4   107 91     29 12   164 50   198
1953528 MN Hennepin 27 school 2725200 279 Independent Districts and Schools OSSEO PUBLIC SCHOOL DISTRICT 272520001214 86 North View Middle School, an IB World School Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_7 11.0 95.0 27.0   1.0 51.0     0.0   16.0   97.0 104.0     35.0   12.0     155.0   48.0   201.0 11 95 27   1 51     0   16   97 104     35 12   155 48   201
1958094 MN Stearns 73 school 2733510 742 Independent Districts and Schools ST. CLOUD PUBLIC SCHOOL DISTRICT 273351002188 52 NORTH JUNIOR HIGH Junior High School (Grades 7-8 or 7-9) Regular School No Middle 06 08 2019   grade_7 117.0 109.0 29.0   1.0 12.0     0.0   26.0   163.0 131.0     58.0   12.0     201.0   71.0   294.0 117 109 29   1 12     0   26   163 131     58 12   201 71   294
696479 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 2017   grade_7 1.0 40.0 65.0   5.0 2.0     0.0   0.0   65.0 48.0     75.0   11.0         26.0   113.0 1 40 65   5 2     0   0   65 48     75 11     26   113
697739 MN Beltrami 4 school 2730510 38 Independent Districts and Schools RED LAKE PUBLIC SCHOOL DISTRICT 273051002427 40 Red Lake Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_7 0.0 0.0 0.0   70.0 0.0     0.0   0.0   40.0 30.0     0.0   11.0         14.0   70.0 0 0 0   70 0     0   0   40 30     0 11     14   70
698510 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 2017   grade_7 9.0 76.0 6.0   6.0 8.0     0.0   1.0   55.0 51.0     4.0   11.0         22.0   106.0 9 76 6   6 8     0   1   55 51     4 11     22   106
698514 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124004574 323 RAMSEY MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_7 113.0 70.0 52.0   2.0 10.0     0.0   3.0   134.0 116.0     63.0   11.0     121.0   36.0   250.0 113 70 52   2 10     0   3   134 116     63 11   121 36   250
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
862177 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 2016   grade_7 112 167 60   2 36     1   41   217 202     47.0   11.0     297.0   49.0   419 112 167 60   2 36     1   41   217 202     47 11   297 49   419
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
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
1953242 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 2019   grade_7 277.0 54.0 31.0   4.0 43.0     0.0   21.0   231.0 199.0     19.0   11.0     191.0   79.0   430.0 277 54 31   4 43     0   21   231 199     19 11   191 79   430
698506 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 2017   grade_7 39.0 82.0 39.0   6.0 19.0     0.0   5.0   90.0 100.0     37.0   10.0     156.0   31.0   190.0 39 82 39   6 19     0   5   90 100     37 10   156 31   190
698518 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 2017   grade_7 118.0 88.0 54.0   22.0 11.0     1.0   10.0   145.0 159.0     60.0   10.0     195.0   41.0   304.0 118 88 54   22 11     1   10   145 159     60 10   195 41   304
702559 MN Stearns 73 school 2733510 742 Independent Districts and Schools ST. CLOUD PUBLIC SCHOOL DISTRICT 273351002188 52 NORTH JUNIOR HIGH Junior High School (Grades 7-8 or 7-9) Regular School No Middle 06 08 2017   grade_7 122.0 121.0 29.0   1.0 15.0     0.0   25.0   149.0 164.0     86.0   10.0     233.0   52.0   313.0 122 121 29   1 15     0   25   149 164     86 10   233 52   313
862185 MN Hennepin 27 school 2733780 283 Independent Districts and Schools ST. LOUIS PARK PUBLIC SCHOOL DIST. 273378001533 42 ST. LOUIS PARK MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No 2 06 08 2016   grade_7 196 60 39   2 17     0   34   159 189     33.0   10.0     126.0   42.0   348 196 60 39   2 17     0   34   159 189     33 10   126 42   348
862692 MN Hennepin 27 school 2721240 1 Special Districts and Schools MINNEAPOLIS PUBLIC SCHOOL DIST. 272124004882 327 Franklin Middle School Middle School (Grades 5-8) Regular School No 2 06 08 2016   grade_7 0 73 15   2 3     0   0   46 47     16.0   10.0         30.0   93 0 73 15   2 3     0   0   46 47     16 10     30   93
1154973 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 2 06 08 2015   grade_7 213.0 33.0 50.0   0.0 28.0     0.0   6.0   163.0 167.0     39.0   10.0     149.0   65.0   330.0 213 33 50   0 28     0   6   163 167     39 10   149 65   330
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
1720698 MN Beltrami 4 school 2704440 31 Independent Districts and Schools Bemidji Public School District 270444002031 15 Bemidji Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 258 4 4   121 0     0   12   217 182     0.0   10.0     142.0   67.0   399 258 4 4   121 0     0   12   217 182     0 10   142 67   399
1725410 MN Stearns 73 school 2733510 742 Independent Districts and Schools St. Cloud Public School District 273351002188 52 North Junior High Junior High School (Grades 7-8 or 7-9) Regular School No Middle 06 08 2021   grade_7 98 105 29   3 13     0   27   140 135     55.0   10.0     188.0   59.0   275 98 105 29   3 13     0   27   140 135     55 10   188 59   275
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
1834209 MN Beltrami 4 school 2730510 38 Independent Districts and Schools Red Lake Public School District 273051002427 40 Red Lake Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2020   grade_7 2.0 0.0 0.0   83.0 0.0     0.0   0.0   53.0 32.0     0.0   10.0     62.0   18.0   85.0 2 0 0   83 0     0   0   53 32     0 10   62 18   85
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
1889215 MN Saint Louis 69 school 2711040 709 Independent Districts and Schools Duluth Public School District 271104002788 225 Lincoln Park Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2018   grade_7 120.0 22.0 2.0   13.0 4.0     0.0   27.0   84.0 104.0     1.0   10.0     127.0   24.0   188.0 120 22 2   13 4     0   27   84 104     1 10   127 24   188
1953238 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 2019   grade_7 372.0 135.0 53.0   4.0 88.0     1.0   56.0   369.0 340.0     39.0   10.0     243.0   80.0   709.0 372 135 53   4 88     1   56   369 340     39 10   243 80   709
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
1953747 MN Ramsey 62 school 2723850 622 Independent Districts and Schools North St Paul-Maplewood Oakdale Public School District 272385001170 55 JOHN GLENN MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_7 73.0 58.0 30.0   3.0 77.0     1.0   20.0   124.0 138.0     29.0   10.0     179.0   *   262.0 73 58 30   3 77     1   20   124 138     29 10   179     262
696460 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 2017   grade_7 4.0 28.0 29.0   1.0 0.0     0.0   1.0   36.0 27.0     32.0   9.0         13.0   63.0 4 28 29   1 0     0   1   36 27     32 9     13   63
698176 MN Washington 82 school 2723850 622 Independent Districts and Schools North St Paul-Maplewood Oakdale Public School District 272385002666 54 SKYVIEW COMMUNITY MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_7 147.0 47.0 29.0   1.0 50.0     1.0   20.0   154.0 141.0         9.0         48.0   295.0 147 47 29   1 50     1   20   154 141       9     48   295
698220 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384001621 345 RAMSEY MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_7 46.0 73.0 14.0   4.0 23.0     0.0   6.0   98.0 68.0     24.0   9.0     114.0   29.0   166.0 46 73 14   4 23     0   6   98 68     24 9   114 29   166
861896 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 2 06 08 2016   grade_7 246 39 29   5 36     0   16   187 184     9.0   9.0     153.0   65.0   371 246 39 29   5 36     0   16   187 184     9 9   153 65   371
862394 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384001969 342 MURRAY MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No 2 06 08 2016   grade_7 84 58 22   9 34     0   9   105 111     43.0   9.0     121.0   37.0   216 84 58 22   9 34     0   9   105 111     43 9   121 37   216
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
1146788 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384004429 252 WASHINGTON TECH SECONDARY MAGNET Secondary School (Grades 7-12) Regular School No 4 06 12 2015   grade_7 7.0 90.0 41.0   0.0 159.0     0.0   1.0   163.0 135.0     173.0   9.0         51.0   298.0 7 90 41   0 159     0   1   163 135     173 9     51   298
1153539 MN Hennepin 27 school 2721240 1 Special Districts and Schools MINNEAPOLIS PUBLIC SCHOOL DIST. 272124002476 282 LUCY LANEY @ CLEVELAND PARK ELEM. Elementary School (Grades PK-6) Regular School No 1 PK 08 2015   grade_7 0.0 52.0 1.0   1.0 2.0     0.0   0.0   25.0 31.0     2.0   9.0         22.0   56.0 0 52 1   1 2     0   0   25 31     2 9     22   56
1154574 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 2 06 08 2015   grade_7 279.0 52.0 21.0   9.0 29.0     0.0   11.0   198.0 203.0     18.0   9.0     173.0   49.0   401.0 279 52 21   9 29     0   11   198 203     18 9   173 49   401
1156945 MN Saint Louis 69 school 2711040 709 Independent Districts and Schools DULUTH PUBLIC SCHOOL DISTRICT 271104002237 611 DULUTH AREA LEARNING CENTER Public Area Learning Center ALC (State approved) Alternative Education School No 4 06 12 2015   grade_7 91.0 20.0 3.0   14.0 1.0     0.0   11.0   81.0 59.0     1.0   9.0     114.0   51.0   140.0 91 20 3   14 1     0   11   81 59     1 9   114 51   140
1711943 MN Itasca 31 school 2710140 317 Independent Districts and Schools Deer River Public School District 271014000433 1 Deer River Secondary Secondary School (Grades 7-12) Regular School No High 06 12 2021   grade_7 37 0 2   23 0     0   8   37 33     0.0   9.0     46.0   13.0   70 37 0 2   23 0     0   8   37 33     0 9   46 13   70
1888635 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 2018   grade_7 459.0 55.0 29.0   7.0 22.0     1.0   24.0   270.0 327.0     20.0   9.0     200.0   66.0   597.0 459 55 29   7 22     1   24   270 327     20 9   200 66   597
1888643 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 2018   grade_7 413.0 113.0 52.0   5.0 94.0     0.0   40.0   337.0 380.0     33.0   9.0     237.0   88.0   717.0 413 113 52   5 94     0   40   337 380     33 9   237 88   717
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
1958098 MN Stearns 73 school 2733510 742 Independent Districts and Schools ST. CLOUD PUBLIC SCHOOL DISTRICT 273351001492 54 SOUTH JUNIOR HIGH Junior High School (Grades 7-8 or 7-9) Regular School No Middle 06 08 2019   grade_7 139.0 141.0 16.0   1.0 3.0     0.0   17.0   166.0 151.0     81.0   9.0     207.0   45.0   317.0 139 141 16   1 3     0   17   166 151     81 9   207 45   317
697685 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 2017   grade_7 480.0 58.0 39.0   9.0 35.0     0.0   16.0   320.0 317.0     21.0   8.0     218.0   106.0   637.0 480 58 39   9 35     0   16   320 317     21 8   218 106   637
697693 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 2017   grade_7 379.0 122.0 59.0   2.0 105.0     0.0   56.0   382.0 341.0     41.0   8.0     271.0   76.0   723.0 379 122 59   2 105     0   56   382 341     41 8   271 76   723
697705 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 2017   grade_7 324.0 35.0 21.0   0.0 32.0     0.0   28.0   223.0 217.0     12.0   8.0     113.0   52.0   440.0 324 35 21   0 32     0   28   223 217     12 8   113 52   440
698139 MN Olmsted 55 school 2731800 535 Independent Districts and Schools ROCHESTER PUBLIC SCHOOL DISTRICT 273180001020 335 KELLOGG MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_7 169.0 36.0 30.0   0.0 27.0     0.0   10.0   138.0 134.0     34.0   8.0     94.0   42.0   272.0 169 36 30   0 27     0   10   138 134     34 8   94 42   272
698619 MN Hennepin 27 school 2700384 4218 Charter Schools Venture Academy 270038404697 10 Venture Academy Middle School (Grades 5-8) Regular School Yes Other 06 09 2017   grade_7 2.0 19.0 33.0   6.0 0.0     0.0   3.0   36.0 27.0     16.0   8.0         20.0   63.0 2 19 33   6 0     0   3   36 27     16 8     20   63
1153558 MN Hennepin 27 school 2721240 1 Special Districts and Schools MINNEAPOLIS PUBLIC SCHOOL DIST. 272124002699 288 NELLIE STONE JOHNSON ELEMENTARY Elementary School (Grades PK-6) Regular School No 1 PK 08 2015   grade_7 3.0 57.0 20.0   3.0 3.0     0.0   0.0   45.0 41.0         8.0         34.0   86.0 3 57 20   3 3     0   0   45 41       8     34   86
1154566 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 2 06 08 2015   grade_7 270.0 51.0 27.0   7.0 19.0     0.0   9.0   197.0 186.0     18.0   8.0     183.0   53.0   383.0 270 51 27   7 19     0   9   197 186     18 8   183 53   383
1155029 MN Ramsey 62 school 2742360 624 Independent Districts and Schools WHITE BEAR LAKE SCHOOL DISTRICT 274236001049 59 SUNRISE PARK MIDDLE Middle School (Grades 5-8) Regular School No 2 06 08 2015   grade_7 196.0 24.0 14.0   0.0 21.0     1.0   12.0   149.0 119.0         8.0         45.0   268.0 196 24 14   0 21     1   12   149 119       8     45   268
1159095 MN Stearns 73 school 2733510 742 Independent Districts and Schools ST. CLOUD PUBLIC SCHOOL DISTRICT 273351002188 52 NORTH JUNIOR HIGH Junior High School (Grades 7-8 or 7-9) Regular School No 2 06 08 2015   grade_7 133.0 90.0 16.0   3.0 16.0     0.0   17.0   151.0 124.0     76.0   8.0     191.0   44.0   275.0 133 90 16   3 16     0   17   151 124     76 8   191 44   275
1725414 MN Stearns 73 school 2733510 742 Independent Districts and Schools St. Cloud Public School District 273351001492 54 South Junior High Junior High School (Grades 7-8 or 7-9) Regular School No Middle 06 08 2021   grade_7 135 118 22   0 8     0   24   166 141     64.0   8.0     172.0   57.0   307 135 118 22   0 8     0   24   166 141     64 8   172 57   307
1834452 MN Hennepin 27 school 2725200 279 Independent Districts and Schools Osseo Public School District 272520001214 86 North View Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2020   grade_7 21.0 75.0 33.0   1.0 46.0     0.0   15.0   99.0 92.0     29.0   8.0     141.0   30.0   191.0 21 75 33   1 46     0   15   99 92     29 8   141 30   191
1834746 MN Saint Louis 69 school 2711040 709 Independent Districts and Schools Duluth Public School District 271104002788 225 Lincoln Park Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2020   grade_7 124.0 19.0 3.0   13.0 2.0     0.0   29.0   96.0 94.0     1.0   8.0     121.0   27.0   190.0 124 19 3   13 2     0   29   96 94     1 8   121 27   190
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
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
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
1889169 MN Ramsey 62 school 2733840 625 Independent Districts and Schools St. Paul Public School District 273384001556 310 Battle Creek Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2018   grade_7 10.0 77.0 38.0   2.0 82.0     0.0   8.0   117.0 100.0     73.0   8.0     169.0   35.0   217.0 10 77 38   2 82     0   8   117 100     73 8   169 35   217
1889480 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 2018   grade_7 38.0 74.0 40.0   16.0 7.0     0.0   4.0   92.0 87.0     35.0   8.0     139.0   48.0   179.0 38 74 40   16 7     0   4   92 87     35 8   139 48   179
1889496 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 2018   grade_7 2.0 94.0 21.0   3.0 3.0     1.0   3.0   57.0 70.0     15.0   8.0     111.0   40.0   127.0 2 94 21   3 3     1   3   57 70     15 8   111 40   127
1945539 MN Todd 77 school 2700109 2753 Independent Districts and Schools Long Prairie-Grey Eagle School District 270010900850 20 LONG PRAIRIE-GREY SECONDARY SCHOOL Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_7 47.0 0.0 24.0   0.0 0.0     2.0   1.0   32.0 42.0     5.0   8.0     39.0   12.0   74.0 47 0 24   0 0     2   1   32 42     5 8   39 12   74
1952963 MN Hennepin 27 school 2700396 4226 Charter Schools Bdote Learning Center 270039604763 10 Bdote Learning Center Elementary School (Grades PK-6) Regular School Yes Elementary KG 07 2019   grade_7 0.0 0.0 1.0   11.0 0.0     0.0   0.0   7.0 5.0     0.0   8.0         6.0   12.0 0 0 1   11 0     0   0   7 5     0 8     6   12
1953250 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 2019   grade_7 322.0 35.0 20.0   2.0 27.0     0.0   11.0   221.0 196.0     6.0   8.0     109.0   *   417.0 322 35 20   2 27     0   11   221 196     6 8   109     417
697697 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 2017   grade_7 258.0 46.0 43.0   7.0 31.0     0.0   25.0   224.0 186.0     25.0   7.0     186.0   69.0   410.0 258 46 43   7 31     0   25   224 186     25 7   186 69   410
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
698131 MN Olmsted 55 school 2731800 535 Independent Districts and Schools ROCHESTER PUBLIC SCHOOL DISTRICT 273180001018 325 JOHN ADAMS MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_7 193.0 64.0 25.0   1.0 51.0     0.0   32.0   200.0 166.0     39.0   7.0     161.0   56.0   366.0 193 64 25   1 51     0   32   200 166     39 7   161 56   366
698498 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 2017   grade_7 131.0 80.0 17.0   3.0 8.0     0.0   3.0   128.0 114.0     26.0   7.0     114.0   28.0   242.0 131 80 17   3 8     0   3   128 114     26 7   114 28   242
700135 MN Saint Louis 69 school 2711040 709 Independent Districts and Schools DULUTH PUBLIC SCHOOL DISTRICT 271104002237 611 DULUTH AREA LEARNING CENTER Public Area Learning Center ALC (State approved) Alternative School No Other 06 12 2017   grade_7 41.0 4.0 3.0   3.0 0.0     0.0   11.0   31.0 31.0     2.0   7.0     49.0   47.0   62.0 41 4 3   3 0     0   11   31 31     2 7   49 47   62
860732 MN Hennepin 27 school 2721240 1 Special Districts and Schools MINNEAPOLIS PUBLIC SCHOOL DIST. 272124001866 175 FOLWELL ARTS MAGNET Elementary School (Grades PK-6) Regular School No 1 PK 08 2016   grade_7 8 29 52   1 3     0   0   41 52         7.0     80.0   11.0   93 8 29 52   1 3     0   0   41 52       7   80 11   93
860792 MN Hennepin 27 school 2721240 1 Special Districts and Schools MINNEAPOLIS PUBLIC SCHOOL DIST. 272124004172 225 ANISHINABE ACADEMY Elementary School (Grades PK-6) Regular School No 1 PK 08 2016   grade_7 0 3 3   21 0     0   3   16 14     2.0   7.0         4.0   30 0 3 3   21 0     0   3   16 14     2 7     4   30
866685 MN Hennepin 27 school 2714260 270 Independent Districts and Schools HOPKINS PUBLIC SCHOOL DISTRICT 271426000615 378 HOPKINS NORTH JUNIOR HIGH Junior High School (Grades 7-8 or 7-9) Regular School No 2 07 09 2016   grade_7 168 74 43   2 17     0   16   164 156     35.0   7.0     142.0   42.0   320 168 74 43   2 17     0   16   164 156     35 7   142 42   320
1146772 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384001598 225 HUMBOLDT HIGH SCHOOL Secondary School (Grades 7-12) Regular School No 4 06 12 2015   grade_7 15.0 62.0 29.0   3.0 58.0     0.0   7.0   97.0 77.0     84.0   7.0         38.0   174.0 15 62 29   3 58     0   7   97 77     84 7     38   174
1154562 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 2 06 08 2015   grade_7 491.0 45.0 23.0   9.0 23.0     0.0   9.0   267.0 333.0     14.0   7.0     209.0   95.0   600.0 491 45 23   9 23     0   9   267 333     14 7   209 95   600
1719903 MN Hennepin 27 school 2700253 4143 Charter Schools New Millennium Academy Charter Sch 270025303311 10 New Millenium Academy Charter School Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2021   grade_7 0 8 4   0 78     0   0   44 46     45.0   7.0     65.0   10.0   90 0 8 4   0 78     0   0   44 46     45 7   65 10   90
1720660 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 2021   grade_7 249 56 30   2 41     2   35   216 199     24.0   7.0     118.0   46.0   415 249 56 30   2 41     2   35   216 199     24 7   118 46   415
1825511 MN Itasca 31 school 2710140 317 Independent Districts and Schools Deer River Public School District 271014000433 1 Deer River Secondary Secondary School (Grades 7-12) Regular School No High 06 12 2020   grade_7 42.0 0.0 2.0   23.0 1.0     0.0   13.0   51.0 30.0     0.0   7.0     53.0   14.0   81.0 42 0 2   23 1     0   13   51 30     0 7   53 14   81

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