Data source: Big Local News · About: Big Local

4,929 rows where grade = "grade_6" and state = "MN" sorted by homeless_int descending

View and edit SQL

year

grade

  • grade_6 · 4,929
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
862671 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_6 23 115 52   5 18     1   3   108 109     66.0   28.0     173.0   49.0   217 23 115 52   5 18     1   3   108 109     66 28   173 49   217
1834157 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_6 299.0 105.0 38.0   7.0 33.0     1.0   57.0   260.0 280.0     35.0   26.0     283.0   110.0   540.0 299 105 38   7 33     1   57   260 280     35 26   283 110   540
1720701 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_6 0 0 0   107 0     0   0   60 47     0.0   23.0     93.0   22.0   107 0 0 0   107 0     0   0   60 47     0 23   93 22   107
698521 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_6 5.0 98.0 19.0   4.0 2.0     1.0   4.0   59.0 74.0     12.0   20.0         38.0   133.0 5 98 19   4 2     1   4   59 74     12 20     38   133
1834208 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_6 1.0 0.0 0.0   83.0 0.0     0.0   0.0   51.0 33.0     0.0   19.0     73.0   21.0   84.0 1 0 0   83 0     0   0   51 33     0 19   73 21   84
862691 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_6 2 99 24   4 1     1   4   73 62     17.0   17.0         39.0   135 2 99 24   4 1     1   4   73 62     17 17     39   135
1155336 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_6 104.0 87.0 34.0   22.0 10.0     0.0   1.0   130.0 128.0     46.0   17.0     154.0   34.0   258.0 104 87 34   22 10     0   1   130 128     46 17   154 34   258
1720890 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_6 75 57 103   3 20     0   30   131 157     32.0   17.0     177.0   46.0   288 75 57 103   3 20     0   30   131 157     32 17   177 46   288
1953233 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_6 227.0 63.0 31.0   3.0 26.0     1.0   32.0   196.0 187.0     22.0   17.0     209.0   64.0   383.0 227 63 31   3 26     1   32   196 187     22 17   209 64   383
1153463 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_6 4.0 41.0 75.0   6.0 3.0     0.0   1.0   63.0 67.0     88.0   16.0         28.0   130.0 4 41 75   6 3     0   1   63 67     88 16     28   130
697712 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_6 51.0 82.0 92.0   5.0 17.0     0.0   24.0   130.0 141.0     54.0   15.0     224.0   *   271.0 51 82 92   5 17     0   24   130 141     54 15   224     271
698509 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_6 20.0 74.0 14.0   5.0 13.0     0.0   1.0   78.0 49.0     19.0   15.0     109.0   31.0   127.0 20 74 14   5 13     0   1   78 49     19 15   109 31   127
862405 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_6 152 54 58   0 3     0   2   147 122     47.0   15.0     159.0   *   269 152 54 58   0 3     0   2   147 122     47 15   159     269
860742 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_6 3 32 33   3 1     0   0   43 29     45.0   14.0         14.0   72 3 32 33   3 1     0   0   43 29     45 14     14   72
862679 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_6 9 70 6   7 11     0   0   54 49     8.0   14.0         28.0   103 9 70 6   7 11     0   0   54 49     8 14     28   103
1839072 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 2020   grade_6 107.0 106.0 25.0   3.0 14.0     0.0   29.0   144.0 140.0     60.0   14.0     208.0   60.0   284.0 107 106 25   3 14     0   29   144 140     60 14   208 60   284
862380 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_6 16 87 43   2 98     0   9   136 119     91.0   13.0     229.0   53.0   255 16 87 43   2 98     0   9   136 119     91 13   229 53   255
862401 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_6 56 77 17   4 28     0   10   109 83     20.0   13.0     143.0   38.0   192 56 77 17   4 28     0   10   109 83     20 13   143 38   192
862687 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_6 120 74 56   28 15     2   11   142 164     65.0   13.0     190.0   49.0   306 120 74 56   28 15     2   11   142 164     65 13   190 49   306
1155320 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_6 33.0 95.0 69.0   3.0 19.0     0.0   2.0   111.0 110.0     63.0   13.0     176.0   36.0   221.0 33 95 69   3 19     0   2   111 110     63 13   176 36   221
1155324 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_6 43.0 89.0 31.0   13.0 13.0     0.0   2.0   110.0 81.0     29.0   13.0     158.0   41.0   191.0 43 89 31   13 13     0   2   110 81     29 13   158 41   191
1721632 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_6 0 49 16   0 0     0   2   27 40     2.0   13.0     53.0   13.0   67 0 49 16   0 0     0   2   27 40     2 13   53 13   67
1958093 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_6 107.0 108.0 23.0   0.0 14.0     0.0   30.0   156.0 126.0     51.0   13.0     194.0   62.0   282.0 107 108 23   0 14     0   30   156 126     51 13   194 62   282
860760 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_6 0 40 76   4 2     0   0   65 57     85.0   12.0         25.0   122 0 40 76   4 2     0   0   65 57     85 12     25   122
1155032 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 2015   grade_6 31.0 77.0 32.0   3.0 110.0     0.0   8.0   150.0 111.0     126.0   12.0         51.0   261.0 31 77 32   3 110     0   8   150 111     126 12     51   261
1839076 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_6 131.0 114.0 24.0   1.0 11.0     0.0   19.0   162.0 138.0     54.0   12.0     181.0   60.0   300.0 131 114 24   1 11     0   19   162 138     54 12   181 60   300
1887373 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 2018   grade_6 2.0 44.0 60.0   5.0 1.0     0.0   1.0   53.0 60.0     56.0   12.0     *   20.0   113.0 2 44 60   5 1     0   1   53 60     56 12     20   113
1888638 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 2018   grade_6 270.0 70.0 36.0   7.0 22.0     1.0   25.0   239.0 192.0     21.0   12.0     228.0   74.0   431.0 270 70 36   7 22     1   25   239 192     21 12   228 74   431
1889479 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_6 38.0 62.0 27.0   15.0 6.0     0.0   7.0   73.0 82.0     20.0   12.0     114.0   36.0   155.0 38 62 27   15 6     0   7   73 82     20 12   114 36   155
1889483 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_6 14.0 85.0 5.0   3.0 12.0     0.0   4.0   74.0 49.0     12.0   12.0     *   33.0   123.0 14 85 5   3 12     0   4   74 49     12 12     33   123
1889495 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_6 4.0 107.0 22.0   5.0 4.0     0.0   6.0   74.0 74.0     14.0   12.0     *   35.0   148.0 4 107 22   5 4     0   6   74 74     14 12     35   148
1953229 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_6 437.0 72.0 23.0   3.0 21.0     2.0   28.0   284.0 302.0     9.0   12.0     215.0   114.0   586.0 437 72 23   3 21     2   28   284 302     9 12   215 114   586
697688 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 2017   grade_6 250.0 55.0 39.0   4.0 29.0     0.0   25.0   211.0 191.0     16.0   11.0     213.0   56.0   402.0 250 55 39   4 29     0   25   211 191     16 11   213 56   402
698517 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_6 141.0 89.0 53.0   21.0 15.0     0.0   15.0   165.0 169.0     53.0   11.0     202.0   51.0   334.0 141 89 53   21 15     0   15   165 169     53 11   202 51   334
862778 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_6 0 4 78   1 0     0   0   37 46     35.0   11.0         6.0   83 0 4 78   1 0     0   0   37 46     35 11     6   83
1154840 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 2015   grade_6 198.0 58.0 39.0   3.0 16.0     0.0   32.0   156.0 190.0     34.0   11.0     130.0   51.0   346.0 198 58 39   3 16     0   32   156 190     34 11   130 51   346
1155328 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_6 4.0 53.0 6.0   3.0 12.0     0.0   1.0   46.0 33.0     11.0   11.0         24.0   79.0 4 53 6   3 12     0   1   46 33     11 11     24   79
1720697 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_6 230 5 11   78 3     1   28   191 165     1.0   11.0     146.0   *   356 230 5 11   78 3     1   28   191 165     1 11   146     356
1725409 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_6 82 100 26   3 16     1   22   122 128     39.0   11.0     167.0   55.0   250 82 100 26   3 16     1   22   122 128     39 11   167 55   250
1834165 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000119 90 Northdale Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2020   grade_6 257.0 56.0 32.0   3.0 42.0     2.0   35.0   228.0 199.0     22.0   11.0     145.0   57.0   427.0 257 56 32   3 42     2   35   228 199     22 11   145 57   427
1834443 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_6 72.0 127.0 43.0   4.0 104.0     0.0   35.0   202.0 183.0     35.0   11.0     222.0   36.0   385.0 72 127 43   4 104     0   35   202 183     35 11   222 36   385
1834745 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_6 140.0 17.0 12.0   20.0 4.0     0.0   42.0   124.0 111.0     2.0   11.0     145.0   45.0   235.0 140 17 12   20 4     0   42   124 111     2 11   145 45   235
1889149 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 2018   grade_6 78.0 39.0 29.0   1.0 79.0     1.0   24.0   126.0 125.0     36.0   11.0     174.0   38.0   251.0 78 39 29   1 79     1   24   126 125     36 11   174 38   251
1889491 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_6 150.0 71.0 68.0   21.0 9.0     1.0   9.0   161.0 168.0     54.0   11.0     179.0   51.0   329.0 150 71 68   21 9     1   9   161 168     54 11   179 51   329
1953746 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_6 78.0 55.0 42.0   4.0 75.0     0.0   21.0   135.0 140.0     35.0   11.0     189.0   45.0   275.0 78 55 42   4 75     0   21   135 140     35 11   189 45   275
696478 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_6 4.0 38.0 74.0   8.0 1.0     0.0   2.0   67.0 60.0     65.0   10.0         27.0   127.0 4 38 74   8 1     0   2   67 60     65 10     27   127
698501 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_6 25.0 58.0 78.0   4.0 19.0     0.0   2.0   91.0 95.0     59.0   10.0     139.0   31.0   186.0 25 58 78   4 19     0   2   91 95     59 10   139 31   186
861467 MN Hennepin 27 school 2700289 4169 Charter Schools Stonebridge World School 270028903731 10 Stonebridge World School Elementary School (Grades PK-6) Regular School Yes 1 KG 08 2016   grade_6 0 23 11   1 0     0   2   21 16     5.0   10.0         13.0   37 0 23 11   1 0     0   2   21 16     5 10     13   37
861937 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_6 0 0 0   76 0     0   0   37 39     0.0   10.0         11.0   76 0 0 0   76 0     0   0   37 39     0 10     11   76
862675 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_6 38 77 39   9 17     0   3   90 93     45.0   10.0     149.0   32.0   183 38 77 39   9 17     0   3   90 93     45 10   149 32   183
866710 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 2 06 08 2016   grade_6 128 111 12   1 5     0   19   140 136     64.0   10.0     181.0   64.0   276 128 111 12   1 5     0   19   140 136     64 10   181 64   276
1159094 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_6 154.0 96.0 22.0   2.0 11.0     0.0   18.0   165.0 138.0     77.0   10.0     206.0   51.0   303.0 154 96 22   2 11     0   18   165 138     77 10   206 51   303
1720651 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_6 243 99 37   3 55     1   49   249 238     32.0   10.0     237.0   99.0   487 243 99 37   3 55     1   49   249 238     32 10   237 99   487
1834451 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_6 15.0 103.0 44.0   2.0 52.0     0.0   22.0   124.0 114.0     35.0   10.0     182.0   44.0   238.0 15 103 44   2 52     0   22   124 114     35 10   182 44   238
1835037 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124002581 318 Olson Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2020   grade_6 14.0 79.0 13.0   1.0 15.0     0.0   7.0   58.0 71.0     10.0   10.0     101.0   30.0   129.0 14 79 13   1 15     0   7   58 71     10 10   101 30   129
1888688 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 2018   grade_6 0.0 0.0 0.0   82.0 0.0     0.0   0.0   37.0 45.0     0.0   10.0     *   *   82.0 0 0 0   82 0     0   0   37 45     0 10         82
1953765 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 2019   grade_6 15.0 89.0 27.0   2.0 103.0     0.0   17.0   144.0 109.0     81.0   10.0     206.0   45.0   253.0 15 89 27   2 103     0   17   144 109     81 10   206 45   253
697996 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_6 95.0 148.0 106.0   2.0 32.0     0.0   27.0   222.0 188.0     53.0   9.0     309.0   51.0   410.0 95 148 106   2 32     0   27   222 188     53 9   309 51   410
698497 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_6 133.0 69.0 27.0   0.0 9.0     0.0   5.0   126.0 117.0     33.0   9.0     111.0   37.0   243.0 133 69 27   0 9     0   5   126 117     33 9   111 37   243
698505 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_6 38.0 72.0 41.0   2.0 6.0     0.0   3.0   85.0 77.0     36.0   9.0     132.0   33.0   162.0 38 72 41   2 6     0   3   85 77     36 9   132 33   162
698513 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_6 146.0 71.0 40.0   3.0 13.0     2.0   5.0   145.0 135.0     43.0   9.0     133.0   39.0   280.0 146 71 40   3 13     2   5   145 135     43 9   133 39   280
862430 MN Saint Louis 69 school 2711040 709 Independent Districts and Schools DULUTH PUBLIC SCHOOL DISTRICT 271104000489 335 ORDEAN EAST MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No 2 06 08 2016   grade_6 273 14 6   9 4     0   14   165 155         9.0     87.0   37.0   320 273 14 6   9 4     0   14   165 155       9   87 37   320
1153445 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 2015   grade_6 1.0 24.0 29.0   1.0 2.0     0.0   0.0   25.0 32.0     37.0   9.0         9.0   57.0 1 24 29   1 2     0   0   25 32     37 9     9   57
1711942 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_6 33 0 2   28 0     0   9   40 32     0.0   9.0     49.0   18.0   72 33 0 2   28 0     0   9   40 32     0 9   49 18   72
1720659 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_6 285 65 41   2 42     0   41   236 240     25.0   9.0     150.0   83.0   476 285 65 41   2 42     0   41   236 240     25 9   150 83   476
1825880 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_6 13.0 89.0 36.0   3.0 141.0     0.0   19.0   150.0 151.0     92.0   9.0     257.0   48.0   301.0 13 89 36   3 141     0   19   150 151     92 9   257 48   301
1888642 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_6 368.0 122.0 54.0   4.0 92.0     0.0   50.0   357.0 333.0     35.0   9.0     236.0   85.0   690.0 368 122 54   4 92     0   50   357 333     35 9   236 85   690
1888646 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_6 285.0 54.0 30.0   2.0 44.0     0.0   19.0   234.0 200.0     18.0   9.0     196.0   80.0   434.0 285 54 30   2 44     0   19   234 200     18 9   196 80   434
1888888 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_6 68.0 55.0 108.0   1.0 14.0     0.0   29.0   136.0 139.0     39.0   9.0     192.0   39.0   275.0 68 55 108   1 14     0   29   136 139     39 9   192 39   275
1953555 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 Middle 06 08 2019   grade_6 187.0 80.0 38.0   2.0 12.0     0.0   37.0   200.0 156.0     27.0   9.0     139.0   50.0   356.0 187 80 38   2 12     0   37   200 156     27 9   139 50   356
694030 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_6 7.0 49.0 11.0   1.0 31.0     0.0   3.0   47.0 55.0     30.0   8.0     88.0   13.0   102.0 7 49 11   1 31     0   3   47 55     30 8   88 13   102
696448 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124001866 175 FOLWELL ARTS MAGNET Elementary School (Grades PK-6) Regular School No Elementary PK 08 2017   grade_6 12.0 23.0 61.0   3.0 1.0     0.0   3.0   52.0 51.0     35.0   8.0     91.0   19.0   103.0 12 23 61   3 1     0   3   52 51     35 8   91 19   103
696590 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124004239 291 HMONG INTERNATIONAL ACADEMY Elementary School (Grades PK-6) Regular School No Elementary PK 08 2017   grade_6 0.0 14.0 1.0   1.0 24.0     0.0   3.0   23.0 20.0     18.0   8.0         9.0   43.0 0 14 1   1 24     0   3   23 20     18 8     9   43
697684 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_6 458.0 50.0 28.0   7.0 21.0     1.0   20.0   257.0 328.0     16.0   8.0     203.0   65.0   585.0 458 50 28   7 21     1   20   257 328     16 8   203 65   585
698198 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 2017   grade_6 11.0 79.0 41.0   5.0 97.0     0.0   6.0   138.0 101.0     108.0   8.0     201.0   37.0   239.0 11 79 41   5 97     0   6   138 101     108 8   201 37   239
698590 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_6 0.0 5.0 82.0   1.0 0.0     0.0   0.0   44.0 44.0     28.0   8.0         8.0   88.0 0 5 82   1 0     0   0   44 44     28 8     8   88
854097 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 2016   grade_6 15 77 31   3 141     1   12   148 132     105.0   8.0     251.0   47.0   280 15 77 31   3 141     1   12   148 132     105 8   251 47   280
861887 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_6 264 52 39   4 18     0   20   179 218     24.0   8.0     204.0   53.0   397 264 52 39   4 18     0   20   179 218     24 8   204 53   397
1154569 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 2015   grade_6 380.0 93.0 39.0   3.0 78.0     0.0   26.0   303.0 316.0     44.0   8.0     225.0   89.0   619.0 380 93 39   3 78     0   26   303 316     44 8   225 89   619
1155053 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_6 65.0 99.0 17.0   2.0 37.0     0.0   6.0   119.0 107.0     39.0   8.0     155.0   36.0   226.0 65 99 17   2 37     0   6   119 107     39 8   155 36   226
1834153 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_6 416.0 74.0 48.0   1.0 29.0     0.0   39.0   316.0 291.0     26.0   8.0     222.0   96.0   607.0 416 74 48   1 29     0   39   316 291     26 8   222 96   607
1834366 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_6 91.0 18.0 76.0   3.0 4.0     0.0   17.0   96.0 113.0     25.0   8.0     111.0   37.0   209.0 91 18 76   3 4     0   17   96 113     25 8   111 37   209
1834408 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_6 57.0 58.0 98.0   3.0 18.0     0.0   22.0   133.0 123.0     47.0   8.0     175.0   36.0   256.0 57 58 98   3 18     0   22   133 123     47 8   175 36   256
1834697 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 2020   grade_6 13.0 60.0 35.0   1.0 97.0     0.0   12.0   115.0 103.0     77.0   8.0     178.0   42.0   218.0 13 60 35   1 97     0   12   115 103     77 8   178 42   218
1835029 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_6 40.0 66.0 62.0   6.0 13.0     0.0   5.0   94.0 98.0     33.0   8.0     126.0   32.0   192.0 40 66 62   6 13     0   5   94 98     33 8   126 32   192
1835049 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_6 1.0 67.0 20.0   5.0 0.0     1.0   3.0   57.0 40.0     14.0   8.0     82.0   27.0   97.0 1 67 20   5 0     1   3   57 40     14 8   82 27   97
1889103 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_6 188.0 47.0 82.0   5.0 27.0     0.0   23.0   184.0 188.0     53.0   8.0     176.0   70.0   372.0 188 47 82   5 27     0   23   184 188     53 8   176 70   372
1889164 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 Middle 06 08 2018   grade_6 154.0 30.0 28.0   2.0 25.0     0.0   19.0   125.0 133.0     12.0   8.0     102.0   43.0   258.0 154 30 28   2 25     0   19   125 133     12 8   102 43   258
1889193 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 2018   grade_6 134.0 59.0 57.0   0.0 4.0     0.0   11.0   132.0 133.0     41.0   8.0     169.0   40.0   265.0 134 59 57   0 4     0   11   132 133     41 8   169 40   265
1945028 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 2019   grade_6 18.0 81.0 40.0   3.0 156.0     0.0   18.0   168.0 148.0     89.0   8.0     276.0   55.0   316.0 18 81 40   3 156     0   18   168 148     89 8   276 55   316
1951956 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 2019   grade_6 2.0 33.0 63.0   3.0 2.0     0.0   1.0   51.0 53.0     53.0   8.0         24.0   104.0 2 33 63   3 2     0   1   51 53     53 8     24   104
1953527 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_6 18.0 84.0 40.0   1.0 47.0     0.0   14.0   97.0 107.0     29.0   8.0     158.0   29.0   204.0 18 84 40   1 47     0   14   97 107     29 8   158 29   204
1953543 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 2019   grade_6 80.0 107.0 71.0   1.0 12.0     0.0   27.0   162.0 136.0     40.0   8.0     212.0   51.0   298.0 80 107 71   1 12     0   27   162 136     40 8   212 51   298
1953786 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 2019   grade_6 50.0 100.0 23.0   4.0 25.0     0.0   20.0   110.0 112.0     23.0   8.0     141.0   25.0   222.0 50 100 23   4 25     0   20   110 112     23 8   141 25   222
697696 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_6 233.0 59.0 35.0   1.0 37.0     0.0   29.0   205.0 189.0     13.0   7.0     159.0   79.0   394.0 233 59 35   1 37     0   29   205 189     13 7   159 79   394
697935 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_6 49.0 69.0 87.0   2.0 21.0     0.0   20.0   131.0 117.0     42.0   7.0     177.0   47.0   248.0 49 69 87   2 21     0   20   131 117     42 7   177 47   248
697980 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 2017   grade_6 12.0 97.0 38.0   1.0 51.0     0.0   17.0   121.0 95.0     45.0   7.0     187.0   44.0   216.0 12 97 38   1 51     0   17   121 95     45 7   187 44   216
697988 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_6 79.0 48.0 155.0   0.0 13.0     1.0   29.0   172.0 153.0     74.0   7.0     214.0   49.0   325.0 79 48 155   0 13     1   29   172 153     74 7   214 49   325
860791 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_6 0 3 1   23 0     0   1   12 16     0.0   7.0     25.0   6.0   28 0 3 1   23 0     0   1   12 16     0 7   25 6   28
861883 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 2016   grade_6 464 56 33   9 38     0   16   301 315     20.0   7.0     204.0   100.0   616 464 56 33   9 38     0   16   301 315     20 7   204 100   616

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