Data source: Big Local News · About: Big Local

4,774 rows where grade = "grade_7" and state = "MN" sorted by homeless 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
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
1833678 MN Hennepin 27 school 2700309 4192 Charter Schools Best Academy 270030904261 10 Best Academy Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2020   grade_7 0.0 66.0 1.0   0.0 0.0     0.0   2.0   35.0 34.0     14.0   7.0         12.0   69.0 0 66 1   0 0     0   2   35 34     14 7     12   69
1834205 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 2020   grade_7 261.0 6.0 10.0   65.0 2.0     1.0   37.0   193.0 189.0     0.0   7.0     167.0   *   382.0 261 6 10   65 2     1   37   193 189     0 7   167     382
1834444 MN Hennepin 27 school 2725200 279 Independent Districts and Schools Osseo Public School District 272520001208 33 Brooklyn Middle School, a Science, Technology, Engineering, Art and Math School Middle School (Grades 5-8) Regular School No Middle 06 08 2020   grade_7 57.0 118.0 60.0   3.0 94.0     0.0   31.0   181.0 182.0     33.0   7.0     202.0   47.0   363.0 57 118 60   3 94     0   31   181 182     33 7   202 47   363
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
1834719 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 2020   grade_7 50.0 88.0 21.0   4.0 21.0     0.0   18.0   96.0 106.0     21.0   7.0     119.0   21.0   202.0 50 88 21   4 21     0   18   96 106     21 7   119 21   202
1835034 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124001008 316 Northeast Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2020   grade_7 33.0 75.0 36.0   10.0 5.0     0.0   6.0   83.0 82.0     27.0   7.0     124.0   43.0   165.0 33 75 36   10 5     0   6   83 82     27 7   124 43   165
1887386 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 2018   grade_7 0.0 56.0 2.0   2.0 0.0     0.0   1.0   32.0 29.0     39.0   7.0     *   3.0   61.0 0 56 2   2 0     0   1   32 29     39 7     3   61
1888647 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 2018   grade_7 221.0 62.0 36.0   2.0 40.0     0.0   29.0   198.0 192.0     23.0   7.0     149.0   66.0   390.0 221 62 36   2 40     0   29   198 192     23 7   149 66   390
1888701 MN Blue Earth 7 school 2718780 77 Independent Districts and Schools Mankato Public School District 271878002045 200 Prairie Winds Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2018   grade_7 234.0 46.0 20.0   1.0 10.0     0.0   9.0   162.0 158.0     *   7.0     117.0   49.0   320.0 234 46 20   1 10     0   9   162 158       7   117 49   320
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
1889134 MN Ramsey 62 school 2722950 621 Independent Districts and Schools Mounds View Public School District 272295001041 66 Edgewood Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2018   grade_7 126.0 37.0 22.0   2.0 22.0     0.0   12.0   125.0 96.0     8.0   7.0     108.0   *   221.0 126 37 22   2 22     0   12   125 96     8 7   108     221
1889285 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 2018   grade_7 259.0 25.0 50.0   0.0 6.0     0.0   11.0   168.0 183.0     31.0   7.0     160.0   *   351.0 259 25 50   0 6     0   11   168 183     31 7   160     351
1893503 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 2018   grade_7 99.0 113.0 21.0   2.0 14.0     0.0   21.0   145.0 125.0     68.0   7.0     204.0   56.0   270.0 99 113 21   2 14     0   21   145 125     68 7   204 56   270
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
1953791 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 2019   grade_7 129.0 50.0 56.0   0.0 4.0     0.0   7.0   128.0 118.0     37.0   7.0     152.0   40.0   246.0 129 50 56   0 4     0   7   128 118     37 7   152 40   246
1954088 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 2019   grade_7 37.0 66.0 27.0   13.0 9.0     0.0   7.0   68.0 91.0     21.0   7.0     118.0   42.0   159.0 37 66 27   13 9     0   7   68 91     21 7   118 42   159
694031 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384004457 489 HAZEL PARK PREPARATORY ACADEMY Elementary School (Grades PK-6) Regular School No Elementary PK 08 2017   grade_7 4.0 40.0 24.0   2.0 32.0     0.0   0.0   56.0 46.0     37.0   6.0     89.0   10.0   102.0 4 40 24   2 32     0   0   56 46     37 6   89 10   102
696512 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124004172 225 ANISHINABE ACADEMY Elementary School (Grades PK-6) Regular School No Elementary PK 08 2017   grade_7 1.0 2.0 2.0   23.0 0.0     0.0   2.0   13.0 17.0     0.0   6.0     26.0   5.0   30.0 1 2 2   23 0     0   2   13 17     0 6   26 5   30
698135 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 2017   grade_7 211.0 49.0 64.0   0.0 22.0     1.0   17.0   175.0 189.0     46.0   6.0     168.0   53.0   364.0 211 49 64   0 22     1   17   175 189     46 6   168 53   364
698224 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 2017   grade_7 156.0 54.0 55.0   0.0 3.0     0.0   5.0   145.0 128.0     49.0   6.0     153.0   41.0   273.0 156 54 55   0 3     0   5   145 128     49 6   153 41   273
698245 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 2017   grade_7 125.0 15.0 6.0   11.0 1.0     0.0   15.0   87.0 86.0     0.0   6.0     91.0   24.0   173.0 125 15 6   11 1     0   15   87 86     0 6   91 24   173
860622 MN Hennepin 27 school 2721240 1 Special Districts and Schools MINNEAPOLIS PUBLIC SCHOOL DIST. 272124000988 134 LK NOKOMIS COMM-KEEWAYDIN CAMPUS Elementary School (Grades PK-6) Regular School No 1 03 08 2016   grade_7 30 15 11   3 0     1   3   26 37     7.0   6.0     39.0   11.0   63 30 15 11   3 0     1   3   26 37     7 6   39 11   63
860743 MN Hennepin 27 school 2721240 1 Special Districts and Schools MINNEAPOLIS PUBLIC SCHOOL DIST. 272124000986 179 JEFFERSON ELEMENTARY Elementary School (Grades PK-6) Regular School No 1 PK 08 2016   grade_7 0 20 25   0 3     0   0   26 22     30.0   6.0         5.0   48 0 20 25   0 3     0   0   26 22     30 6     5   48
861888 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 2016   grade_7 258 72 27   2 31     0   16   206 200     29.0   6.0     205.0   54.0   406 258 72 27   2 31     0   16   206 200     29 6   205 54   406
861892 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 2 06 08 2016   grade_7 391 105 44   5 84     0   35   322 342     42.0   6.0     240.0   89.0   664 391 105 44   5 84     0   35   322 342     42 6   240 89   664
861938 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 2 06 08 2016   grade_7 0 0 0   85 0     0   0   42 43     0.0   6.0     76.0   11.0   85 0 0 0   85 0     0   0   42 43     0 6   76 11   85
862153 MN Hennepin 27 school 2725200 279 Independent Districts and Schools OSSEO PUBLIC SCHOOL DISTRICT 272520001208 33 Brooklyn Middle School, a Science, Technology, Engineering, Art and Math School Middle School (Grades 5-8) Regular School No 2 06 08 2016   grade_7 53 103 34   0 87     0   29   157 149     39.0   6.0     200.0   45.0   306 53 103 34   0 87     0   29   157 149     39 6   200 45   306
862321 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 2 06 08 2016   grade_7 220 33 13   1 33     0   12   157 155     33.0   6.0     103.0   35.0   312 220 33 13   1 33     0   12   157 155     33 6   103 35   312
862402 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 2 06 08 2016   grade_7 60 75 22   6 34     0   4   109 92     37.0   6.0     125.0   35.0   201 60 75 22   6 34     0   4   109 92     37 6   125 35   201
866673 MN Dakota 19 school 2707290 191 Independent Districts and Schools BURNSVILLE PUBLIC SCHOOL DISTRICT 270729000295 15 METCALF JUNIOR HIGH Junior High School (Grades 7-8 or 7-9) Regular School No 2 07 09 2016   grade_7 108 46 33   1 9     1   18   106 110     26.0   6.0     99.0   35.0   216 108 46 33   1 9     1   18   106 110     26 6   99 35   216
866707 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 2016   grade_7 138 102 23   3 12     0   19   160 137     85.0   6.0     201.0   53.0   297 138 102 23   3 12     0   19   160 137     85 6   201 53   297
1151023 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384004457 489 HAZEL PARK PREPARATORY ACADEMY Elementary School (Grades PK-6) Regular School No 1 PK 08 2015   grade_7 8.0 46.0 22.0   0.0 39.0     0.0   2.0   64.0 53.0     44.0   6.0         16.0   117.0 8 46 22   0 39     0   2   64 53     44 6     16   117
1153326 MN Hennepin 27 school 2721240 1 Special Districts and Schools MINNEAPOLIS PUBLIC SCHOOL DIST. 272124000988 134 LK NOKOMIS COMM-KEEWAYDIN CAMPUS Elementary School (Grades PK-6) Regular School No 1 03 08 2015   grade_7 27.0 16.0 12.0   3.0 0.0     0.0   0.0   30.0 28.0     7.0   6.0     34.0   12.0   58.0 27 16 12   3 0     0   0   30 28     7 6   34 12   58
1153521 MN Hennepin 27 school 2721240 1 Special Districts and Schools MINNEAPOLIS PUBLIC SCHOOL DIST. 272124001879 256 GREEN CENTRAL PARK ELEMENTARY Elementary School (Grades PK-6) Regular School No 1 PK 08 2015   grade_7 4.0 13.0 39.0   2.0 2.0     0.0   0.0   30.0 30.0     30.0   6.0         15.0   60.0 4 13 39   2 2     0   0   30 30     30 6     15   60
1154672 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 2 06 08 2015   grade_7 321.0 17.0 42.0   9.0 4.0     0.0   23.0   197.0 219.0     34.0   6.0     165.0   61.0   416.0 321 17 42   9 4     0   23   197 219     34 6   165 61   416
1155054 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 2 06 08 2015   grade_7 55.0 89.0 18.0   2.0 39.0     0.0   4.0   117.0 90.0     57.0   6.0     149.0   29.0   207.0 55 89 18   2 39     0   4   117 90     57 6   149 29   207
1155105 MN Sherburne 71 school 2703870 726 Independent Districts and Schools BECKER PUBLIC SCHOOL DISTRICT 270387002556 30 BECKER MIDDLE Middle School (Grades 5-8) Regular School No 2 06 08 2015   grade_7 212.0 2.0 10.0   2.0 1.0     0.0   3.0   127.0 103.0     6.0   6.0     53.0   26.0   230.0 212 2 10   2 1     0   3   127 103     6 6   53 26   230
1155317 MN Hennepin 27 school 2721240 1 Special Districts and Schools MINNEAPOLIS PUBLIC SCHOOL DIST. 272124000936 300 ANTHONY MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No 2 06 08 2015   grade_7 100.0 84.0 13.0   1.0 12.0     0.0   1.0   96.0 115.0     26.0   6.0     97.0   30.0   211.0 100 84 13   1 12     0   1   96 115     26 6   97 30   211
1159072 MN Hennepin 27 school 2725200 279 Independent Districts and Schools OSSEO PUBLIC SCHOOL DISTRICT 272520001214 86 NORTH VIEW IB WORLD SCHOOL Junior High School (Grades 7-8 or 7-9) Regular School No 2 07 09 2015   grade_7 25.0 80.0 33.0   2.0 57.0     0.0   6.0   120.0 83.0     38.0   6.0     172.0   28.0   203.0 25 80 33   2 57     0   6   120 83     38 6   172 28   203
1712820 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 2021   grade_7 35 0 46   0 0     0   1   48 34     19.0   6.0     45.0   18.0   82 35 0 46   0 0     0   1   48 34     19 6   45 18   82
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
1721109 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 2021   grade_7 167 82 36   3 57     0   27   176 196     42.0   6.0     154.0   61.0   372 167 82 36   3 57     0   27   176 196     42 6   154 61   372
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
1721121 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 2021   grade_7 236 52 31   1 46     1   36   220 183     26.0   6.0     87.0   52.0   403 236 52 31   1 46     1   36   220 183     26 6   87 52   403
1721163 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 2021   grade_7 76 49 35   2 84     1   15   138 124     30.0   6.0     128.0   *   262 76 49 35   2 84     1   15   138 124     30 6   128     262
1721203 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 2021   grade_7 63 83 15   1 23     0   23   94 114     17.0   6.0     116.0   24.0   208 63 83 15   1 23     0   23   94 114     17 6   116 24   208
1721342 MN Washington 82 school 2733810 833 Independent Districts and Schools South Washington County School Dist 273381001542 22 Oltman Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 199 32 42   0 35     0   28   163 173     8.0   6.0     72.0   50.0   336 199 32 42   0 35     0   28   163 173     8 6   72 50   336
1721633 MN Anoka 2 school 2700380 4213 Charter Schools Prodeo Academy 270038005319 12 Prodeo Academy Columbia Heights Middle Middle School (Grades 5-8) Regular School Yes Middle 05 07 2021   grade_7 1 32 17   0 0     0   1   25 26     7.0   6.0     38.0   7.0   51 1 32 17   0 0     0   1   25 26     7 6   38 7   51
1825881 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 High 06 12 2020   grade_7 19.0 93.0 41.0   5.0 163.0     0.0   20.0   182.0 159.0     98.0   6.0     298.0   64.0   341.0 19 93 41   5 163     0   20   182 159     98 6   298 64   341
1830474 MN Ramsey 62 school 2733840 625 Independent Districts and Schools St. Paul Public School District 273384001612 528 Global Arts Plus Upper Elementary School (Grades PK-6) Regular School No Middle 05 08 2020   grade_7 39.0 46.0 29.0   0.0 20.0     0.0   12.0   65.0 81.0     42.0   6.0     80.0   26.0   146.0 39 46 29   0 20     0   12   65 81     42 6   80 26   146
1833455 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 2020   grade_7 1.0 4.0 3.0   0.0 63.0     0.0   2.0   38.0 35.0     28.0   6.0     59.0   11.0   73.0 1 4 3   0 63     0   2   38 35     28 6   59 11   73

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