Data source: Big Local News · About: Big Local

680 rows where grade = "grade_7", state = "MN" and year = 2016 sorted by black descending

View and edit SQL

year

  • 2016 · 680

grade

  • grade_7 · 680
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
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
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
861900 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318002501 193 OAK VIEW MIDDLE Middle School (Grades 5-8) Regular School No 2 06 08 2016   grade_7 357 9 18   3 15     0   8   210 200         *     62.0   *   410 357 9 18   3 15     0   8   210 200           62     410
862014 MN Crow Wing 18 school 2706090 181 Independent Districts and Schools BRAINERD PUBLIC SCHOOL DISTRICT 270609004196 22 FORESTVIEW MIDDLE Middle School (Grades 5-8) Regular School No 2 05 08 2016   grade_7 451 9 7   7 3     0   8   237 248         4.0     181.0   66.0   485 451 9 7   7 3     0   8   237 248       4   181 66   485
862329 MN Otter Tail 56 school 2711880 544 Independent Districts and Schools FERGUS FALLS PUBLIC SCHOOL DISTRICT 271188004944 380 Kennedy Middle School Middle School (Grades 5-8) Regular School No 2 06 08 2016   grade_7 150 9 4   0 0     0   8   79 92     0.0   1.0     49.0   29.0   171 150 9 4   0 0     0   8   79 92     0 1   49 29   171
862342 MN Polk 60 school 2711130 595 Independent Districts and Schools EAST GRAND FORKS PUBLIC SCHOOL DIST 271113000494 310 CENTRAL MIDDLE Middle School (Grades 5-8) Regular School No 2 06 08 2016   grade_7 112 9 19   3 3     0   0   70 76     10.0   0.0     50.0   16.0   146 112 9 19   3 3     0   0   70 76     10 0   50 16   146
862444 MN Scott 70 school 2730060 719 Independent Districts and Schools PRIOR LAKE-SAVAGE AREA SCHOOLS 273006003626 21 TWIN OAKS MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No 2 06 08 2016   grade_7 266 9 12   2 20     0   5   159 155     0.0   0.0     42.0   30.0   314 266 9 12   2 20     0   5   159 155     0 0   42 30   314
862549 MN Wright 86 school 2733790 885 Independent Districts and Schools ST. MICHAEL-ALBERTVILLE SCHOOL DIST 273379001536 30 ST. MICHAEL-ALBERTVILLE MIDDLE EAST Middle School (Grades 5-8) Regular School No 2 05 08 2016   grade_7 238 9 7   0 7     0   7   140 128     2.0   1.0     23.0   28.0   268 238 9 7   0 7     0   7   140 128     2 1   23 28   268
862700 MN Hennepin 27 school 2700117 4017 Charter Schools Minnesota Transitions Charter School 270011703261 11 MINNESOTA TRANSITIONS MIDDLE Middle School (Grades 5-8) Regular School Yes 2 06 08 2016   grade_7 0 9 1   2 0     0   1   4 9         3.0         3.0   13 0 9 1   2 0     0   1   4 9       3     3   13
866735 MN Washington 82 school 2738190 834 Independent Districts and Schools STILLWATER AREA PUBLIC SCHOOL DIST. 273819001661 49 STILLWATER JUNIOR HIGH Junior High School (Grades 7-8 or 7-9) Regular School No 2 07 09 2016   grade_7 350 9 8   0 16     0   6   204 185     4.0   0.0     50.0   39.0   389 350 9 8   0 16     0   6   204 185     4 0   50 39   389
862161 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 2 06 08 2016   grade_7 18 89 40   0 67     0   13   119 108     51.0   2.0     181.0   35.0   227 18 89 40   0 67     0   13   119 108     51 2   181 35   227
862173 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 2 06 08 2016   grade_7 243 89 45   2 28     1   37   216 229     18.0   4.0     171.0   52.0   445 243 89 45   2 28     1   37   216 229     18 4   171 52   445
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
862369 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 2 06 08 2016   grade_7 183 86 66   4 105     0   16   241 219         *     261.0   68.0   460 183 86 66   4 105     0   16   241 219           261 68   460
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
862027 MN Dakota 19 school 2711820 192 Independent Districts and Schools FARMINGTON PUBLIC SCHOOL DISTRICT 271182002983 60 ROBERT BOECKMAN MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No 2 06 08 2016   grade_7 246 8 11   2 19     0   7   156 137     6.0   *     58.0   48.0   293 246 8 11   2 19     0   7   156 137     6     58 48   293
862083 MN Dakota 19 school 2713530 200 Independent Districts and Schools HASTINGS PUBLIC SCHOOL DISTRICT 271353000693 130 HASTINGS MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No 2 05 08 2016   grade_7 318 8 16   2 6     1   11   179 183         *         *   362 318 8 16   2 6     1   11   179 183                 362
862287 MN Nicollet 52 school 2733870 508 Independent Districts and Schools ST. PETER PUBLIC SCHOOL DISTRICT 273387002533 80 ST. PETER MIDDLE Middle School (Grades 5-8) Regular School No 2 07 08 2016   grade_7 146 8 18   1 7     0   5   80 105         *         *   185 146 8 18   1 7     0   5   80 105                 185
866720 MN Waseca 81 school 2741880 829 Independent Districts and Schools WASECA PUBLIC SCHOOL DISTRICT 274188002683 45 WASECA JUNIOR HIGH Junior High School (Grades 7-8 or 7-9) Regular School No 2 07 08 2016   grade_7 144 8 20   0 1     0   0   88 85         *         26.0   173 144 8 20   0 1     0   0   88 85             26   173
866765 MN Mower 50 school 2703450 492 Independent Districts and Schools AUSTIN PUBLIC SCHOOL DISTRICT 270345003192 450 NEW DOMINION ACADEMY Educational Oversight to Private Residential Care & Treatment (State approved) Alternative Education School No 4 KG 12 2016   grade_7 7 8 2   1 0     0   1   13 6     0.0   0.0     0.0   15.0   19 7 8 2   1 0     0   1   13 6     0 0   0 15   19
854098 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_7 21 79 31   1 178     0   7   167 150     145.0   4.0         43.0   317 21 79 31   1 178     0   7   167 150     145 4     43   317
862123 MN Hennepin 27 school 2714220 272 Independent Districts and Schools EDEN PRAIRIE PUBLIC SCHOOL DISTRICT 271422000734 65 CENTRAL MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No 2 07 08 2016   grade_7 428 76 49   4 89     0   24   327 343     28.0   1.0     144.0   79.0   670 428 76 49   4 89     0   24   327 343     28 1   144 79   670
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
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
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
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
862165 MN Hennepin 27 school 2725200 279 Independent Districts and Schools OSSEO PUBLIC SCHOOL DISTRICT 272520002278 94 Maple Grove Middle School Middle School (Grades 5-8) Regular School No 2 06 08 2016   grade_7 365 71 41   0 46     0   23   259 287     20.0   2.0     123.0   53.0   546 365 71 41   0 46     0   23   259 287     20 2   123 53   546
862023 MN Dakota 19 school 2711820 192 Independent Districts and Schools FARMINGTON PUBLIC SCHOOL DISTRICT 271182000570 30 LEVI P. DODGE MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No 2 06 08 2016   grade_7 210 7 17   2 12     0   6   127 127     4.0   *     47.0   33.0   254 210 7 17   2 12     0   6   127 127     4     47 33   254
862039 MN Dakota 19 school 2717780 194 Independent Districts and Schools LAKEVILLE PUBLIC SCHOOL DISTRICT 271778002984 105 CENTURY MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No 2 06 08 2016   grade_7 252 7 4   1 17     1   9   141 150         0.0     19.0   32.0   291 252 7 4   1 17     1   9   141 150       0   19 32   291
862431 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_7 283 7 10   7 8     0   14   173 156     2.0   5.0     83.0   26.0   329 283 7 10   7 8     0   14   173 156     2 5   83 26   329
862472 MN Sherburne 71 school 2711370 728 Independent Districts and Schools ELK RIVER PUBLIC SCHOOL DISTRICT 271137002038 410 SALK MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No 2 06 08 2016   grade_7 220 7 10   0 4     0   8   131 118     3.0   0.0     26.0   21.0   249 220 7 10   0 4     0   8   131 118     3 0   26 21   249
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
861912 MN Anoka 2 school 2709510 13 Independent Districts and Schools COLUMBIA HEIGHTS PUBLIC SCHOOL DIST 270951000395 17 COLUMBIA ACADEMY Middle School (Grades 5-8) Regular School No 2 06 08 2016   grade_7 38 69 71   5 12     2   15   118 94     28.0   4.0     180.0   35.0   212 38 69 71   5 12     2   15   118 94     28 4   180 35   212
862313 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 2 06 08 2016   grade_7 207 69 28   1 56     0   14   181 194     55.0   5.0     186.0   45.0   375 207 69 28   1 56     0   14   181 194     55 5   186 45   375
861917 MN Anoka 2 school 2712420 14 Independent Districts and Schools FRIDLEY PUBLIC SCHOOL DISTRICT 271242000610 23 FRIDLEY MIDDLE Middle School (Grades 5-8) Regular School No 2 05 08 2016   grade_7 95 68 33   3 20     0   7   113 113         *         *   226 95 68 33   3 20     0   7   113 113                 226
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
862794 MN Hennepin 27 school 2700309 4192 Charter Schools BEST ACADEMY 270030904773 20 Best Academy K-8 at Penn Middle School (Grades 5-8) Regular School Yes 1 KG 08 2016   grade_7 0 68 2   0 0     0   1   36 35     4.0   0.0     52.0   13.0   71 0 68 2   0 0     0   1   36 35     4 0   52 13   71
853682 MN Hennepin 27 school 2706240 286 Independent Districts and Schools BROOKLYN CENTER SCHOOL DISTRICT 270624000273 12 BROOKLYN CENTER SECONDARY Secondary School (Grades 7-12) Regular School No 4 06 12 2016   grade_7 18 66 34   1 31     0   12   68 94         *         *   162 18 66 34   1 31     0   12   68 94                 162
862064 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239001383 98 VALLEY MIDDLE Middle School (Grades 5-8) Regular School No 2 06 08 2016   grade_7 186 63 39   3 16     0   17   174 150     23.0   5.0     128.0   55.0   324 186 63 39   3 16     0   17   174 150     23 5   128 55   324
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
854090 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384004443 250 OPEN WORLD LEARNING SECONDARY Secondary School (Grades 7-12) Regular School No 4 06 12 2016   grade_7 47 6 13   0 6     0   0   32 40     7.0   1.0     14.0   14.0   72 47 6 13   0 6     0   0   32 40     7 1   14 14   72
854272 MN Wabasha 79 school 2741060 811 Independent Districts and Schools WABASHA-KELLOGG PUBLIC SCHOOL DIST. 274106001722 40 WABASHA-KELLOGG SECONDARY Secondary School (Grades 7-12) Regular School No 3 07 12 2016   grade_7 36 6 2   0 0     0   0   26 18     0.0   0.0     21.0   5.0   44 36 6 2   0 0     0   0   26 18     0 0   21 5   44
862100 MN Freeborn 24 school 2702970 241 Independent Districts and Schools ALBERT LEA PUBLIC SCHOOL DISTRICT 270297000078 320 SOUTHWEST MIDDLE Middle School (Grades 5-8) Regular School No 2 06 07 2016   grade_7 170 6 45   1 15     0   7   127 117         *         *   244 170 6 45   1 15     0   7   127 117                 244
862189 MN Hennepin 27 school 2742160 284 Independent Districts and Schools WAYZATA PUBLIC SCHOOL DISTRICT 274216001764 51 WAYZATA WEST MIDDLE Middle School (Grades 5-8) Regular School No 2 06 08 2016   grade_7 200 6 18   0 33     0   4   130 131     2.0   0.0     25.0   *   261 200 6 18   0 33     0   4   130 131     2 0   25     261
862325 MN Olmsted 55 school 2731800 535 Independent Districts and Schools ROCHESTER PUBLIC SCHOOL DISTRICT 273180002449 340 FRIEDELL MIDDLE Middle School (Grades 5-8) Regular School No 2 06 08 2016   grade_7 105 6 8   0 27     0   6   74 78     5.0   *     29.0   17.0   152 105 6 8   0 27     0   6   74 78     5     29 17   152
862460 MN Hennepin 27 school 2711370 728 Independent Districts and Schools ELK RIVER PUBLIC SCHOOL DISTRICT 271137002844 340 ROGERS MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No 2 06 08 2016   grade_7 307 6 9   0 11     0   7   175 165     10.0   *     42.0   39.0   340 307 6 9   0 11     0   7   175 165     10     42 39   340
862485 MN Stearns 73 school 2732820 748 Independent Districts and Schools SARTELL-ST. STEPHEN SCHOOL DISTRICT 273282001675 50 SARTELL MIDDLE Middle School (Grades 5-8) Regular School No 2 05 08 2016   grade_7 292 6 6   0 5     1   0   149 161     6.0   2.0     48.0   43.0   310 292 6 6   0 5     1   0   149 161     6 2   48 43   310
862803 MN Ramsey 62 school 2700376 4210 Charter Schools Upper Mississippi Academy 270037604693 20 Upper Mississippi Middle Academy Middle School (Grades 5-8) Regular School Yes 2 06 08 2016   grade_7 57 6 6   1 0     0   3   43 30     0.0   0.0     10.0   14.0   73 57 6 6   1 0     0   3   43 30     0 0   10 14   73
863939 MN Anoka 2 school 2712420 14 Independent Districts and Schools FRIDLEY PUBLIC SCHOOL DISTRICT 271242003427 652 FRIDLEY MIDDLE AREA LEARNING CENTER Public Area Learning Center ALC (State approved) Alternative Education School No 2 05 08 2016   grade_7 7 6 2   0 0     0   0   5 10         *         *   15 7 6 2   0 0     0   0   5 10                 15
864361 MN Sherburne 71 school 2711370 728 Independent Districts and Schools ELK RIVER PUBLIC SCHOOL DISTRICT 271137003363 603 IVAN SAND COMMUNITY SCHOOL-MIDDLE Public Area Learning Center ALC (State approved) Alternative Education School No 2 06 08 2016   grade_7 119 6 6   1 2     0   5   58 81     4.0   0.0         6.0   139 119 6 6   1 2     0   5   58 81     4 0     6   139
866681 MN Dakota 19 school 2707290 191 Independent Districts and Schools BURNSVILLE PUBLIC SCHOOL DISTRICT 270729000297 85 NICOLLET JUNIOR HIGH Junior High School (Grades 7-8 or 7-9) Regular School No 2 07 09 2016   grade_7 23 6 3   1 3     0   5   18 23     1.0   0.0     13.0   9.0   41 23 6 3   1 3     0   5   18 23     1 0   13 9   41
854082 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 2016   grade_7 8 59 28   2 58     0   5   81 79     71.0   5.0         19.0   160 8 59 28   2 58     0   5   81 79     71 5     19   160
861011 MN Ramsey 62 school 2700140 4027 Charter Schools HIGHER GROUND ACADEMY 270014002719 10 HIGHER GROUND ACADEMY Elementary School (Grades PK-6) Regular School Yes 1 KG 08 2016   grade_7 0 58 0   0 0     0   0   27 31     3.0   0.0         8.0   58 0 58 0   0 0     0   0   27 31     3 0     8   58
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
862048 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239002437 32 BLACK HAWK MIDDLE Middle School (Grades 5-8) Regular School No 2 05 08 2016   grade_7 168 56 33   4 35     0   15   152 159     18.0   0.0     107.0   *   311 168 56 33   4 35     0   15   152 159     18 0   107     311
862116 MN Hennepin 27 school 2705790 271 Independent Districts and Schools BLOOMINGTON PUBLIC SCHOOL DISTRICT 270579000638 345 VALLEY VIEW MIDDLE Middle School (Grades 5-8) Regular School No 2 06 08 2016   grade_7 56 55 72   1 13     0   6   110 93     36.0   2.0     146.0   28.0   203 56 55 72   1 13     0   6   110 93     36 2   146 28   203
862157 MN Hennepin 27 school 2725200 279 Independent Districts and Schools OSSEO PUBLIC SCHOOL DISTRICT 272520001217 34 Osseo Middle School Middle School (Grades 5-8) Regular School No 2 06 08 2016   grade_7 210 55 26   0 25     0   21   165 172         *         36.0   337 210 55 26   0 25     0   21   165 172             36   337
862668 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 2016   grade_7 125 54 24   7 8     0   1   95 124     23.0   5.0     85.0   27.0   219 125 54 24   7 8     0   1   95 124     23 5   85 27   219
862784 MN Hennepin 27 school 2700308 4191 Charter Schools KIPP MINNESOTA CHARTER SCHOOL 270030804244 10 KIPP MINNESOTA CHARTER SCHOOL Middle School (Grades 5-8) Regular School Yes 2 05 08 2016   grade_7 3 54 0   0 0     0   1   30 28     0.0   3.0         12.0   58 3 54 0   0 0     0   1   30 28     0 3     12   58
860772 MN Hennepin 27 school 2721240 1 Special Districts and Schools MINNEAPOLIS PUBLIC SCHOOL DIST. 272124002297 193 SULLIVAN ELEMENTARY Elementary School (Grades PK-6) Regular School No 1 PK 08 2016   grade_7 3 51 2   4 2     0   1   27 36     36.0   2.0         8.0   63 3 51 2   4 2     0   1   27 36     36 2     8   63
861884 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_7 490 50 16   7 23     0   19   281 324     15.0   4.0     215.0   100.0   605 490 50 16   7 23     0   19   281 324     15 4   215 100   605
858069 MN Ramsey 62 school 2732430 623 Independent Districts and Schools ROSEVILLE PUBLIC SCHOOL DISTRICT 273243001046 73 PARKVIEW CENTER SCHOOL Elementary School (Grades PK-6) Regular School No 1 PK 08 2016   grade_7 62 5 4   0 16     0   1   43 45         *     14.0   14.0   88 62 5 4   0 16     0   1   43 45           14 14   88
860984 MN Ramsey 62 school 2700118 4018 Charter Schools ACHIEVE LANGUAGE ACADEMY 270011802608 10 ACHIEVE LANGUAGE ACADEMY Elementary School (Grades PK-6) Regular School Yes 1 PK 08 2016   grade_7 2 5 12   0 24     0   1   18 26     29.0   0.0     38.0   11.0   44 2 5 12   0 24     0   1   18 26     29 0   38 11   44
861524 MN Anoka 2 school 2700320 4185 Charter Schools DAVINCI ACADEMY 270032004268 10 DAVINCI ACADEMY Elementary School (Grades PK-6) Regular School Yes 1 KG 08 2016   grade_7 33 5 3   1 4     0   2   19 29     1.0   0.0     9.0   5.0   48 33 5 3   1 4     0   2   19 29     1 0   9 5   48
862448 MN Scott 70 school 2723430 721 Independent Districts and Schools NEW PRAGUE AREA SCHOOLS 272343001145 111 NEW PRAGUE MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No 2 06 08 2016   grade_7 279 5 4   1 5     0   2   155 141     5.0   0.0     51.0   31.0   296 279 5 4   1 5     0   2   155 141     5 0   51 31   296
862498 MN Washington 82 school 2718750 832 Independent Districts and Schools MAHTOMEDI PUBLIC SCHOOL DISTRICT 271875000869 30 MAHTOMEDI MIDDLE Middle School (Grades 5-8) Regular School No 2 06 08 2016   grade_7 244 5 9   0 7     0   8   133 140     2.0   1.0     20.0   22.0   273 244 5 9   0 7     0   8   133 140     2 1   20 22   273
862530 MN Wright 86 school 2707200 877 Independent Districts and Schools BUFFALO-HANOVER-MONTROSE PUBLIC SCH 270720000284 30 BUFFALO COMMUNITY MIDDLE Middle School (Grades 5-8) Regular School No 2 06 08 2016   grade_7 428 5 10   3 4     1   12   219 244     4.0   0.0     130.0   57.0   463 428 5 10   3 4     1   12   219 244     4 0   130 57   463
862554 MN Wright 86 school 2733790 885 Independent Districts and Schools ST. MICHAEL-ALBERTVILLE SCHOOL DIST 273379004346 90 ST MICHAEL-ALBERTVILLE MIDDLE WEST Middle School (Grades 5-8) Regular School No 2 05 08 2016   grade_7 213 5 3   1 6     0   15   125 118     3.0   2.0     39.0   18.0   243 213 5 3   1 6     0   15   125 118     3 2   39 18   243
862774 MN Ramsey 62 school 2700292 4164 Charter Schools LAURA JEFFREY ACADEMY CHARTER 270029203713 10 LAURA JEFFREY ACADEMY CHARTER Middle School (Grades 5-8) Regular School Yes 2 05 08 2016   grade_7 14 5 6   1 2     0   7   0 35     0.0   1.0     15.0   2.0   35 14 5 6   1 2     0   7   0 35     0 1   15 2   35
864383 MN Steele 74 school 2728050 761 Independent Districts and Schools OWATONNA PUBLIC SCHOOL DISTRICT 272805003100 609 OWATONNA ALC 6-8 Public Area Learning Center ALC (State approved) Alternative Education School No 2 06 08 2016   grade_7 16 5 6   0 0     0   1   15 13         1.0         0.0   28 16 5 6   0 0     0   1   15 13       1     0   28
864983 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384002189 430 BRIDGE VIEW SPECIAL EDUCATION Special Education Special Education School No 4 KG 12 2016   grade_7 4 5 1   1 1     0   0   7 5     4.0   0.0     7.0   *   12 4 5 1   1 1     0   0   7 5     4 0   7     12
862230 MN Kandiyohi 34 school 2742720 347 Independent Districts and Schools WILLMAR PUBLIC SCHOOL DISTRICT 274272001808 301 WILLMAR MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No 2 06 08 2016   grade_7 158 47 91   2 11     0   3   149 163     55.0   1.0     175.0   34.0   312 158 47 91   2 11     0   3   149 163     55 1   175 34   312
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
858368 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384001594 494 CAPITOL HILL MAGNET/RONDO Elementary School (Grades PK-6) Regular School No 1 01 08 2016   grade_7 84 45 13   3 64     0   5   119 95     24.0   0.0     90.0   9.0   214 84 45 13   3 64     0   5   119 95     24 0   90 9   214
861925 MN Anoka 2 school 2733330 16 Independent Districts and Schools SPRING LAKE PARK PUBLIC SCHOOLS 273333001466 92 WESTWOOD MIDDLE Middle School (Grades 5-8) Regular School No 2 06 08 2016   grade_7 231 45 55   1 34     2   25   197 196     30.0   *     174.0   57.0   393 231 45 55   1 34     2   25   197 196     30     174 57   393
862169 MN Hennepin 27 school 2731750 280 Independent Districts and Schools RICHFIELD PUBLIC SCHOOL DISTRICT 273175001317 37 RICHFIELD MIDDLE Middle School (Grades 5-8) Regular School No 2 06 08 2016   grade_7 98 45 96   1 16     0   18   133 141     79.0   1.0     168.0   37.0   274 98 45 96   1 16     0   18   133 141     79 1   168 37   274
862390 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384001591 330 HIGHLAND PARK MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No 2 06 08 2016   grade_7 125 45 83   2 9     0   5   135 134     52.0   3.0     121.0   25.0   269 125 45 83   2 9     0   5   135 134     52 3   121 25   269
860693 MN Hennepin 27 school 2721240 1 Special Districts and Schools MINNEAPOLIS PUBLIC SCHOOL DIST. 272124001031 160 SEWARD ELEMENTARY Elementary School (Grades PK-6) Regular School No 1 KG 08 2016   grade_7 32 44 6   2 5     0   0   48 41     25.0   1.0     50.0   7.0   89 32 44 6   2 5     0   0   48 41     25 1   50 7   89
862358 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 2 06 08 2016   grade_7 152 44 14   2 45     0   15   152 120         *         *   272 152 44 14   2 45     0   15   152 120                 272
862362 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 2 06 08 2016   grade_7 97 44 38   4 73     0   11   126 141     32.0   2.0     181.0   43.0   267 97 44 38   4 73     0   11   126 141     32 2   181 43   267
862398 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384004681 344 Parkway Montessori/Community Middle Middle School (Grades 5-8) Regular School No 2 06 08 2016   grade_7 37 44 16   5 50     0   8   82 78     34.0   5.0     113.0   40.0   160 37 44 16   5 50     0   8   82 78     34 5   113 40   160
864043 MN Dakota 19 school 2707290 191 Independent Districts and Schools BURNSVILLE PUBLIC SCHOOL DISTRICT 270729002640 314 BURNSVILLE AREA LEARNING CENTER Public Area Learning Center ALC (State approved) Alternative Education School No 3 07 12 2016   grade_7 56 44 35   0 9     2   14   75 85     24.0   3.0     98.0   10.0   160 56 44 35   0 9     2   14   75 85     24 3   98 10   160
866689 MN Hennepin 27 school 2714260 270 Independent Districts and Schools HOPKINS PUBLIC SCHOOL DISTRICT 271426000616 380 HOPKINS WEST JUNIOR HIGH Junior High School (Grades 7-8 or 7-9) Regular School No 2 07 09 2016   grade_7 138 44 15   1 17     0   16   116 115     1.0   1.0     65.0   32.0   231 138 44 15   1 17     0   16   116 115     1 1   65 32   231
858345 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 2016   grade_7 6 43 15   0 42     1   7   56 58     39.0   2.0     91.0   14.0   114 6 43 15   0 42     1   7   56 58     39 2   91 14   114
862684 MN Hennepin 27 school 2721240 1 Special Districts and Schools MINNEAPOLIS PUBLIC SCHOOL DIST. 272124004574 323 RAMSEY MIDDLE Middle School (Grades 5-8) Regular School No 2 06 08 2016   grade_7 139 42 50   2 6     0   4   122 121     45.0   2.0     84.0   26.0   243 139 42 50   2 6     0   4   122 121     45 2   84 26   243
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
862112 MN Hennepin 27 school 2705790 271 Independent Districts and Schools BLOOMINGTON PUBLIC SCHOOL DISTRICT 270579000226 13 OAK GROVE MIDDLE Middle School (Grades 5-8) Regular School No 2 06 08 2016   grade_7 149 41 31   3 18     0   8   136 114     18.0   0.0     92.0   47.0   250 149 41 31   3 18     0   8   136 114     18 0   92 47   250
866670 MN Blue Earth 7 school 2718780 77 Independent Districts and Schools MANKATO PUBLIC SCHOOL DISTRICT 271878002045 200 MANKATO EAST JR. Junior High School (Grades 7-8 or 7-9) Regular School No 2 07 08 2016   grade_7 186 41 16   1 11     0   4   126 133     19.0   *     109.0   29.0   259 186 41 16   1 11     0   4   126 133     19     109 29   259
862350 MN Ramsey 62 school 2722950 621 Independent Districts and Schools MOUNDS VIEW PUBLIC SCHOOL DISTRICT 272295001117 67 Highview Middle School Middle School (Grades 5-8) Regular School No 2 06 08 2016   grade_7 161 40 28   1 16     0   7   127 126     11.0   0.0     95.0   20.0   253 161 40 28   1 16     0   7   127 126     11 0   95 20   253
854161 MN Saint Louis 69 school 2713980 701 Independent Districts and Schools HIBBING PUBLIC SCHOOL DISTRICT 271398001539 350 HIBBING HIGH Secondary School (Grades 7-12) Regular School No 3 07 12 2016   grade_7 170 4 2   3 5     0   14   94 104     0.0   1.0     95.0   25.0   198 170 4 2   3 5     0   14   94 104     0 1   95 25   198
854839 MN Ramsey 62 school 2700337 4098 Charter Schools Nova Classical Academy 270033704356 20 NOVA CLASSICAL ACADEMY UPPER SCHOOL Secondary School (Grades 7-12) Regular School Yes 4 06 12 2016   grade_7 67 4 4   0 0     0   3   40 38     0.0   1.0     8.0   2.0   78 67 4 4   0 0     0   3   40 38     0 1   8 2   78
857748 MN Olmsted 55 school 2731800 535 Independent Districts and Schools ROCHESTER PUBLIC SCHOOL DISTRICT 273180001005 138 LINCOLN K-8 CHOICE ELEMENTARY Elementary School (Grades PK-6) Regular School No 1 KG 08 2016   grade_7 39 4 0   0 1     0   0   21 23     2.0   0.0     11.0   9.0   44 39 4 0   0 1     0   0   21 23     2 0   11 9   44
860994 MN Saint Louis 69 school 2700133 4020 Charter Schools DULUTH PUBLIC SCHOOLS ACADEMY 270013302711 10 NORTH STAR ACADEMY Elementary School (Grades PK-6) Regular School Yes 1 KG 08 2016   grade_7 111 4 6   4 2     0   20   85 62     1.0   1.0     68.0   31.0   147 111 4 6   4 2     0   20   85 62     1 1   68 31   147
861194 MN Hennepin 27 school 2700354 4089 Charter Schools NEW CITY SCHOOL 270035404849 20 New City School - East Campus Elementary School (Grades PK-6) Regular School Yes 1 KG 08 2016   grade_7 7 4 0   1 1     0   3   8 8     2.0   0.0     5.0   2.0   16 7 4 0   1 1     0   3   8 8     2 0   5 2   16
861486 MN Hennepin 27 school 2700295 4171 Charter Schools NOBLE ACADEMY 270029503727 10 NOBLE ACADEMY Elementary School (Grades PK-6) Regular School Yes 1 KG 08 2016   grade_7 0 4 0   0 39     0   0   21 22     26.0   0.0     31.0   7.0   43 0 4 0   0 39     0   0   21 22     26 0   31 7   43
861921 MN Anoka 2 school 2733540 15 Independent Districts and Schools ST. FRANCIS PUBLIC SCHOOL DISTRICT 273354000013 123 ST. FRANCIS MIDDLE Middle School (Grades 5-8) Regular School No 2 06 08 2016   grade_7 342 4 10   3 15     0   8   190 192         *         *   382 342 4 10   3 15     0   8   190 192                 382
861930 MN Becker 3 school 2710230 22 Independent Districts and Schools DETROIT LAKES PUBLIC SCHOOL DIST. 271023000443 4 DETROIT LAKES MIDDLE Middle School (Grades 5-8) Regular School No 2 05 08 2016   grade_7 188 4 5   18 3     0   17   120 115         *         *   235 188 4 5   18 3     0   17   120 115                 235
861995 MN Chisago 13 school 2723820 138 Independent Districts and Schools NORTH BRANCH PUBLIC SCHOOLS 272382001164 20 NORTH BRANCH MIDDLE Middle School (Grades 5-8) Regular School No 2 05 08 2016   grade_7 201 4 3   2 2     0   3   121 94     0.0   *     62.0   32.0   215 201 4 3   2 2     0   3   121 94     0     62 32   215
862009 MN Cottonwood 17 school 2742780 177 Independent Districts and Schools WINDOM PUBLIC SCHOOL DISTRICT 274278003068 60 WINDOM MIDDLE Middle School (Grades 5-8) Regular School No 2 04 08 2016   grade_7 71 4 8   0 1     0   3   45 42     3.0   0.0     40.0   19.0   87 71 4 8   0 1     0   3   45 42     3 0   40 19   87
862031 MN Dakota 19 school 2717780 194 Independent Districts and Schools LAKEVILLE PUBLIC SCHOOL DISTRICT 271778002435 89 MCGUIRE MIDDLE Middle School (Grades 5-8) Regular School No 2 06 08 2016   grade_7 275 4 12   0 10     0   16   164 153     1.0   2.0     38.0   41.0   317 275 4 12   0 10     0   16   164 153     1 2   38 41   317

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