Data source: Big Local News · About: Big Local

4,774 rows where grade = "grade_7" and state = "MN" sorted by asian 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
1953766 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_7 16.0 90.0 37.0   3.0 99.0     0.0   16.0   126.0 135.0     71.0   3.0     202.0   34.0   261.0 16 90 37   3 99     0   16   126 135     71 3   202 34   261
1834703 MN Ramsey 62 school 2733840 625 Independent Districts and Schools St. Paul Public School District 273384001567 315 Farnsworth Aerospace Upper Middle School (Grades 5-8) Regular School No Middle 05 08 2020   grade_7 10.0 36.0 18.0   2.0 96.0     0.0   11.0   103.0 70.0     49.0   1.0     140.0   29.0   173.0 10 36 18   2 96     0   11   103 70     49 1   140 29   173
1889157 MN Ramsey 62 school 2732430 623 Independent Districts and Schools Roseville Public School District 273243002667 70 Roseville Area Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2018   grade_7 171.0 94.0 74.0   4.0 96.0     0.0   21.0   249.0 211.0     *   4.0     245.0   60.0   460.0 171 94 74   4 96     0   21   249 211       4   245 60   460
862386 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384001567 315 FARNSWORTH AEROSPACE UPPER Middle School (Grades 5-8) Regular School No 2 05 08 2016   grade_7 14 38 18   0 96     0   1   92 75     62.0   *     136.0   38.0   167 14 38 18   0 96     0   1   92 75     62     136 38   167
1153952 MN Ramsey 62 school 2700342 4103 Charter Schools HMONG COLLEGE PREP ACADEMY 270034203700 20 HMONG COLLEGE PREP MIDDLE ACADEMY Elementary School (Grades PK-6) Regular School Yes 1 KG 08 2015   grade_7 0.0 1.0 0.0   0.0 94.0     0.0   0.0   52.0 43.0     43.0   2.0     83.0   12.0   95.0 0 1 0   0 94     0   0   52 43     43 2   83 12   95
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
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
1154218 MN Ramsey 62 school 2700304 4181 Charter Schools COMMUNITY SCHOOL OF EXCELLENCE 270030403728 10 COMMUNITY SCHOOL OF EXCELLENCE Elementary School (Grades PK-6) Regular School Yes 1 KG 08 2015   grade_7 1.0 0.0 0.0   0.0 92.0     0.0   1.0   57.0 37.0     64.0   0.0         16.0   94.0 1 0 0   0 92     0   1   57 37     64 0     16   94
1953492 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 Middle 07 08 2019   grade_7 378.0 95.0 55.0   0.0 92.0     0.0   31.0   332.0 319.0     38.0   1.0     148.0   51.0   651.0 378 95 55   0 92     0   31   332 319     38 1   148 51   651
1720898 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 Middle 07 08 2021   grade_7 340 108 61   1 92     1   35   349 289     35.0   0.0     147.0   54.0   638 340 108 61   1 92     1   35   349 289     35 0   147 54   638
1721182 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 2021   grade_7 14 68 34   0 92     0   14   120 102     78.0   2.0     175.0   47.0   222 14 68 34   0 92     0   14   120 102     78 2   175 47   222
698017 MN Hennepin 27 school 2742160 284 Independent Districts and Schools WAYZATA PUBLIC SCHOOL DISTRICT 274216002654 53 WAYZATA CENTRAL MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_7 270.0 33.0 15.0   0.0 91.0     0.0   17.0   218.0 208.0     0.0   1.0     53.0   25.0   426.0 270 33 15   0 91     0   17   218 208     0 1   53 25   426
1833579 MN Hennepin 27 school 2700295 4171 Charter Schools Noble Academy 270029503727 10 Noble Academy Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2020   grade_7 0.0 10.0 0.0   0.0 91.0     0.0   0.0   56.0 45.0     40.0   0.0     81.0   7.0   101.0 0 10 0   0 91     0   0   56 45     40 0   81 7   101
1888972 MN Hennepin 27 school 2742160 284 Independent Districts and Schools Wayzata Public School District 274216002654 53 Wayzata Central Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2018   grade_7 258.0 38.0 18.0   0.0 91.0     0.0   30.0   246.0 189.0     3.0   0.0     57.0   39.0   435.0 258 38 18   0 91     0   30   246 189     3 0   57 39   435
1834686 MN Ramsey 62 school 2732430 623 Independent Districts and Schools Roseville Public School District 273243002667 70 Roseville Area Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2020   grade_7 181.0 71.0 85.0   1.0 90.0     0.0   30.0   221.0 237.0     55.0   4.0     225.0   39.0   458.0 181 71 85   1 90     0   30   221 237     55 4   225 39   458
690424 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 Other 06 12 2017   grade_7 50.0 9.0 5.0   1.0 9.0     0.0   4.0   45.0 33.0     5.0   0.0     11.0   4.0   78.0 50 9 5   1 9     0   4   45 33     5 0   11 4   78
696319 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124000969 121 LAKE HARRIET UPPER SCHOOL Elementary School (Grades PK-6) Regular School No Elementary 04 08 2017   grade_7 129.0 7.0 11.0   1.0 9.0     0.0   4.0   82.0 79.0     3.0   0.0     21.0   16.0   161.0 129 7 11   1 9     0   4   82 79     3 0   21 16   161
698303 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 Middle 05 08 2017   grade_7 297.0 7.0 6.0   2.0 9.0     0.0   3.0   160.0 164.0     4.0   2.0     43.0   41.0   324.0 297 7 6   2 9     0   3   160 164     4 2   43 41   324
702540 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 Other 07 09 2017   grade_7 137.0 48.0 11.0   1.0 9.0     0.0   18.0   107.0 117.0         *         31.0   224.0 137 48 11   1 9     0   18   107 117             31   224
1146830 MN Roseau 68 school 2741850 690 Independent Districts and Schools WARROAD PUBLIC SCHOOL DISTRICT 274185001745 30 WARROAD HIGH SCHOOL Secondary School (Grades 7-12) Regular School No 3 07 12 2015   grade_7 66.0 0.0 0.0   5.0 9.0     0.0   2.0   45.0 37.0         0.0     29.0   11.0   82.0 66 0 0   5 9     0   2   45 37       0   29 11   82
1154837 MN Hennepin 27 school 2733420 282 Independent Districts and Schools ST. ANTHONY-NEW BRIGHTON SCHOOLS 273342001949 50 ST. ANTHONY MIDDLE Middle School (Grades 5-8) Regular School No 2 06 08 2015   grade_7 97.0 9.0 18.0   3.0 9.0     0.0   6.0   73.0 69.0     10.0   0.0     32.0   14.0   142.0 97 9 18   3 9     0   6   73 69     10 0   32 14   142
1830088 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 Elementary PK 08 2020   grade_7 59.0 10.0 4.0   0.0 9.0     0.0   8.0   50.0 40.0     4.0   0.0     20.0   19.0   90.0 59 10 4   0 9     0   8   50 40     4 0   20 19   90
1834309 MN Scott 70 school 2707290 191 Independent Districts and Schools Burnsville Public School District 270729002639 66 Eagle Ridge Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2020   grade_7 55.0 14.0 17.0   0.0 9.0     0.0   8.0   58.0 45.0     5.0   1.0     37.0   15.0   103.0 55 14 17   0 9     0   8   58 45     5 1   37 15   103
1834362 MN Dakota 19 school 2742270 197 Independent Districts and Schools West St. Paul-Mendota Hts.-Eagan 274227002646 52 Friendly Hills Middle Middle School (Grades 5-8) Regular School No Middle 05 08 2020   grade_7 104.0 31.0 48.0   3.0 9.0     0.0   14.0   109.0 100.0     *   *         33.0   209.0 104 31 48   3 9     0   14   109 100             33   209
1834476 MN Hennepin 27 school 2733420 282 Independent Districts and Schools St. Anthony-New Brighton Schools 273342001949 50 St. Anthony Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2020   grade_7 83.0 28.0 12.0   1.0 9.0     0.0   13.0   75.0 71.0     10.0   3.0     36.0   16.0   146.0 83 28 12   1 9     0   13   75 71     10 3   36 16   146
1834533 MN Kandiyohi 34 school 2742720 347 Independent Districts and Schools Willmar Public School District 274272001808 301 Willmar Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2020   grade_7 136.0 48.0 114.0   0.0 9.0     1.0   2.0   147.0 163.0     60.0   *     187.0   44.0   310.0 136 48 114   0 9     1   2   147 163     60     187 44   310
1834846 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 Middle 06 08 2020   grade_7 227.0 11.0 11.0   0.0 9.0     0.0   25.0   146.0 137.0     4.0   0.0     28.0   23.0   283.0 227 11 11   0 9     0   25   146 137     4 0   28 23   283
1881107 MN Lyon 42 school 2700326 2904 Independent Districts and Schools Tracy Area Public School District 270032604389 1 Tracy Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_7 49.0 2.0 2.0   0.0 9.0     0.0   0.0   25.0 37.0     5.0   0.0     33.0   9.0   62.0 49 2 2   0 9     0   0   25 37     5 0   33 9   62
1888697 MN Nicollet 52 school 2718780 77 Independent Districts and Schools Mankato Public School District 271878002046 190 Dakota Meadows Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2018   grade_7 238.0 33.0 10.0   0.0 9.0     2.0   12.0   165.0 139.0     *   *     *   45.0   304.0 238 33 10   0 9     2   12   165 139             45   304
1888851 MN Dakota 19 school 2715030 199 Independent Districts and Schools Inver Grove Heights Schools 271503000765 27 Inver Grove Heights Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2018   grade_7 152.0 21.0 67.0   1.0 9.0     0.0   21.0   134.0 137.0     20.0   3.0     107.0   29.0   271.0 152 21 67   1 9     0   21   134 137     20 3   107 29   271
1888885 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 Middle 06 08 2018   grade_7 142.0 44.0 42.0   0.0 9.0     0.0   24.0   129.0 132.0     *   *     *   32.0   261.0 142 44 42   0 9     0   24   129 132             32   261
1888956 MN Hennepin 27 school 2733420 282 Independent Districts and Schools St. Anthony-New Brighton Schools 273342001949 50 St. Anthony Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2018   grade_7 93.0 15.0 15.0   2.0 9.0     0.0   11.0   81.0 64.0     5.0   5.0     35.0   13.0   145.0 93 15 15   2 9     0   11   81 64     5 5   35 13   145
1889009 MN Kandiyohi 34 school 2742720 347 Independent Districts and Schools Willmar Public School District 274272001808 301 Willmar Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2018   grade_7 140.0 55.0 115.0   2.0 9.0     1.0   4.0   171.0 155.0     62.0   2.0     201.0   42.0   326.0 140 55 115   2 9     1   4   171 155     62 2   201 42   326
1889277 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 Middle 05 08 2018   grade_7 314.0 7.0 12.0   2.0 9.0     0.0   7.0   189.0 162.0     5.0   1.0     49.0   49.0   351.0 314 7 12   2 9     0   7   189 162     5 1   49 49   351
1889472 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 2018   grade_7 136.0 73.0 29.0   0.0 9.0     0.0   6.0   131.0 122.0     36.0   3.0     109.0   40.0   253.0 136 73 29   0 9     0   6   131 122     36 3   109 40   253
1949201 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 Elementary PK 08 2019   grade_7 46.0 17.0 4.0   0.0 9.0     0.0   6.0   33.0 49.0     4.0   1.0     19.0   14.0   82.0 46 17 4   0 9     0   6   33 49     4 1   19 14   82
1953246 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 Middle 06 08 2019   grade_7 362.0 11.0 13.0   0.0 9.0     1.0   11.0   212.0 195.0     4.0   5.0     65.0   *   407.0 362 11 13   0 9     1   11   212 195     4 5   65     407
1953297 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 2019   grade_7 253.0 33.0 26.0   2.0 9.0     0.0   20.0   179.0 164.0     16.0   5.0     130.0   *   343.0 253 33 26   2 9     0   20   179 164     16 5   130     343
1953481 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 Middle 06 08 2019   grade_7 156.0 47.0 35.0   3.0 9.0     0.0   27.0   145.0 132.0     17.0   4.0     111.0   38.0   277.0 156 47 35   3 9     0   27   145 132     17 4   111 38   277
1953853 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 Middle 06 08 2019   grade_7 218.0 5.0 11.0   0.0 9.0     1.0   10.0   140.0 114.0     8.0   *         27.0   254.0 218 5 11   0 9     1   10   140 114     8       27   254
1953904 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 Middle 06 08 2019   grade_7 227.0 11.0 12.0   1.0 9.0     0.0   8.0   130.0 138.0     2.0   0.0     23.0   25.0   268.0 227 11 12   1 9     0   8   130 138     2 0   23 25   268
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
854724 MN Lyon 42 school 2700326 2904 Independent Districts and Schools TRACY AREA PUBLIC SCHOOL DISTRICT 270032604389 1 TRACY SECONDARY Secondary School (Grades 7-12) Regular School No 3 07 12 2016   grade_7 36 0 2   0 9     0   2   25 24     5.0   0.0     29.0   4.0   49 36 0 2   0 9     0   2   25 24     5 0   29 4   49
862074 MN Dakota 19 school 2742270 197 Independent Districts and Schools WEST ST. PAUL-MENDOTA HTS.-EAGAN 274227001774 54 HERITAGE E-STEM MAGNET SCHOOL Middle School (Grades 5-8) Regular School No 2 05 08 2016   grade_7 65 17 80   4 9     0   5   98 82     38.0   *     107.0   38.0   180 65 17 80   4 9     0   5   98 82     38     107 38   180
862092 MN Douglas 21 school 2703060 206 Independent Districts and Schools ALEXANDRIA PUBLIC SCHOOL DISTRICT 270306000083 310 Discovery Middle School Middle School (Grades 5-8) Regular School No 2 06 08 2016   grade_7 289 1 7   3 9     0   5   171 143     1.0   3.0     82.0   44.0   314 289 1 7   3 9     0   5   171 143     1 3   82 44   314
862373 MN Ramsey 62 school 2742360 624 Independent Districts and Schools WHITE BEAR LAKE SCHOOL DISTRICT 274236001787 57 CENTRAL MIDDLE Middle School (Grades 5-8) Regular School No 2 06 08 2016   grade_7 303 11 20   3 9     0   10   204 152         *         *   356 303 11 20   3 9     0   10   204 152                 356
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
862664 MN Hennepin 27 school 2721240 1 Special Districts and Schools MINNEAPOLIS PUBLIC SCHOOL DIST. 272124000965 119 FIELD ELEMENTARY Middle School (Grades 5-8) Regular School No 2 05 08 2016   grade_7 93 18 5   1 9     0   0   72 54     1.0   1.0     27.0   15.0   126 93 18 5   1 9     0   0   72 54     1 1   27 15   126
862704 MN Ramsey 62 school 2700142 4029 Charter Schools ST. PAUL CITY SCHOOL 270014204150 20 ST. PAUL CITY MIDDLE SCHOOL Middle School (Grades 5-8) Regular School Yes 2 06 08 2016   grade_7 2 12 15   1 9     0   2   24 17     14.0   1.0         8.0   41 2 12 15   1 9     0   2   24 17     14 1     8   41
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
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
1720676 MN Anoka 2 school 2709510 13 Independent Districts and Schools Columbia Heights Public School District 270951000395 17 Columbia Academy Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 43 68 101   3 9     1   21   124 122     59.0   3.0     199.0   47.0   246 43 68 101   3 9     1   21   124 122     59 3   199 47   246
1720795 MN Scott 70 school 2707290 191 Independent Districts and Schools Burnsville Public School District 270729002639 66 Eagle Ridge Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 46 47 32   0 9     1   4   88 51     16.0   1.0     65.0   34.0   139 46 47 32   0 9     1   4   88 51     16 1   65 34   139
1720815 MN Dakota 19 school 2717780 194 Independent Districts and Schools Lakeville Public School District 271778000483 104 Kenwood Trail Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 156 8 31   0 9     1   17   108 114     16.0   *     33.0   24.0   222 156 8 31   0 9     1   17   108 114     16     33 24   222
1720848 MN Dakota 19 school 2742270 197 Independent Districts and Schools West St. Paul-Mendota Heights-Eagan 274227002646 52 Friendly Hills Middle Middle School (Grades 5-8) Regular School No Middle 05 08 2021   grade_7 100 32 53   0 9     0   13   109 98     *   2.0     90.0   32.0   207 100 32 53   0 9     0   13   109 98       2   90 32   207
1721354 MN Washington 82 school 2738190 834 Independent Districts and Schools Stillwater Area Public School Dist. 273819001661 49 Stillwater Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 275 7 19   1 9     1   18   149 181     5.0   2.0     30.0   40.0   330 275 7 19   1 9     1   18   149 181     5 2   30 40   330
1725402 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 Middle 07 09 2021   grade_7 114 45 17   0 9     0   12   109 88     *   0.0     *   34.0   197 114 45 17   0 9     0   12   109 88       0     34   197
1154570 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_7 392.0 108.0 32.0   7.0 89.0     0.0   11.0   316.0 323.0     46.0   4.0     221.0   91.0   639.0 392 108 32   7 89     0   11   316 323     46 4   221 91   639
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
697973 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 2017   grade_7 63.0 112.0 34.0   0.0 88.0     0.0   21.0   162.0 156.0     42.0   *     194.0   45.0   318.0 63 112 34   0 88     0   21   162 156     42     194 45   318
1953238 MN Hennepin 27 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000108 6 JACKSON MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_7 372.0 135.0 53.0   4.0 88.0     1.0   56.0   369.0 340.0     39.0   10.0     243.0   80.0   709.0 372 135 53   4 88     1   56   369 340     39 10   243 80   709
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
1159064 MN Hennepin 27 school 2725200 279 Independent Districts and Schools OSSEO PUBLIC SCHOOL DISTRICT 272520001208 33 BROOKLYN JUNIOR HIGH Junior High School (Grades 7-8 or 7-9) Regular School No 2 07 09 2015   grade_7 88.0 98.0 28.0   3.0 86.0     0.0   12.0   146.0 169.0     43.0   4.0     177.0   41.0   315.0 88 98 28   3 86     0   12   146 169     43 4   177 41   315
697248 MN Ramsey 62 school 2700304 4181 Charter Schools COMMUNITY SCHOOL OF EXCELLENCE 270030403728 10 COMMUNITY SCHOOL OF EXCELLENCE Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2017   grade_7 0.0 0.0 0.0   0.0 84.0     0.0   0.0   51.0 33.0     51.0   0.0     68.0   9.0   84.0 0 0 0   0 84     0   0   51 33     51 0   68 9   84
697943 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 Middle 07 08 2017   grade_7 401.0 94.0 60.0   2.0 84.0     0.0   54.0   364.0 331.0     29.0   2.0     161.0   76.0   695.0 401 94 60   2 84     0   54   364 331     29 2   161 76   695
1154795 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 2015   grade_7 442.0 89.0 38.0   3.0 84.0     2.0   34.0   338.0 354.0     23.0   0.0     141.0   76.0   692.0 442 89 38   3 84     2   34   338 354     23 0   141 76   692
1952700 MN Hennepin 27 school 2700295 4171 Charter Schools NOBLE ACADEMY 270029503727 10 NOBLE ACADEMY Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2019   grade_7 0.0 9.0 0.0   0.0 84.0     0.0   0.0   44.0 49.0     36.0   0.0     50.0   11.0   93.0 0 9 0   0 84     0   0   44 49     36 0   50 11   93
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
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
1880465 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 High 06 12 2018   grade_7 10.0 62.0 31.0   1.0 83.0     0.0   14.0   97.0 104.0     90.0   5.0     178.0   22.0   201.0 10 62 31   1 83     0   14   97 104     90 5   178 22   201
1953520 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 2019   grade_7 72.0 134.0 43.0   1.0 83.0     1.0   29.0   174.0 189.0     40.0   *     230.0   59.0   363.0 72 134 43   1 83     1   29   174 189     40     230 59   363
1720656 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 2021   grade_7 334 131 52   3 83     0   62   334 331     46.0   4.0     219.0   86.0   665 334 131 52   3 83     0   62   334 331     46 4   219 86   665
1888924 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 2018   grade_7 51.0 120.0 25.0   0.0 82.0     0.0   29.0   166.0 141.0     35.0   *     205.0   40.0   307.0 51 120 25   0 82     0   29   166 141     35     205 40   307
1889150 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_7 64.0 69.0 36.0   1.0 82.0     1.0   21.0   139.0 135.0     43.0   6.0     203.0   41.0   274.0 64 69 36   1 82     1   21   139 135     43 6   203 41   274
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
1721187 MN Ramsey 62 school 2733840 625 Independent Districts and Schools St. Paul Public School District 273384001567 315 Farnsworth Aerospace Upper Middle School (Grades 5-8) Regular School No Middle 05 08 2021   grade_7 9 41 12   2 81     0   9   76 78     45.0   4.0     120.0   28.0   154 9 41 12   2 81     0   9   76 78     45 4   120 28   154
1834679 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 2020   grade_7 72.0 58.0 41.0   1.0 80.0     0.0   19.0   128.0 143.0     35.0   2.0     169.0   52.0   271.0 72 58 41   1 80     0   19   128 143     35 2   169 52   271
690294 MN Lyon 42 school 2700326 2904 Independent Districts and Schools TRACY AREA PUBLIC SCHOOL DISTRICT 270032604389 1 TRACY SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   grade_7 59.0 0.0 4.0   1.0 8.0     0.0   0.0   36.0 36.0     3.0   0.0     24.0   7.0   72.0 59 0 4   1 8     0   0   36 36     3 0   24 7   72
697409 MN Ramsey 62 school 2700386 4215 Charter Schools Sejong Academy of Minnesota 270038604695 10 Sejong Academy of Minnesota Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2017   grade_7 0.0 1.0 0.0   0.0 8.0     0.0   0.0   3.0 6.0         *         *   9.0 0 1 0   0 8     0   0   3 6                 9
697713 MN Anoka 2 school 2709510 13 Independent Districts and Schools COLUMBIA HEIGHTS PUBLIC SCHOOL DIST 270951000395 17 COLUMBIA ACADEMY Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_7 45.0 90.0 107.0   1.0 8.0     0.0   18.0   131.0 138.0         *         41.0   269.0 45 90 107   1 8     0   18   131 138             41   269
697889 MN Dakota 19 school 2742270 197 Independent Districts and Schools WEST ST. PAUL-MENDOTA HTS.-EAGAN 274227002646 52 FRIENDLY HILLS MIDDLE Middle School (Grades 5-8) Regular School No Middle 05 08 2017   grade_7 133.0 19.0 33.0   0.0 8.0     0.0   9.0   123.0 79.0     10.0   0.0     53.0   30.0   202.0 133 19 33   0 8     0   9   123 79     10 0   53 30   202
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
698510 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124002581 318 OLSON MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_7 9.0 76.0 6.0   6.0 8.0     0.0   1.0   55.0 51.0     4.0   11.0         22.0   106.0 9 76 6   6 8     0   1   55 51     4 11     22   106
702575 MN Washington 82 school 2712270 831 Independent Districts and Schools FOREST LAKE PUBLIC SCHOOL DISTRICT 271227000592 115 CENTURY JUNIOR HIGH Junior High School (Grades 7-8 or 7-9) Regular School No Other 07 09 2017   grade_7 223.0 2.0 14.0   1.0 8.0     0.0   3.0   140.0 111.0     3.0   2.0     65.0   36.0   251.0 223 2 14   1 8     0   3   140 111     3 2   65 36   251
702587 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 Other 07 09 2017   grade_7 319.0 8.0 10.0   1.0 8.0     0.0   6.0   168.0 184.0         *         55.0   352.0 319 8 10   1 8     0   6   168 184             55   352
1154599 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 2015   grade_7 335.0 0.0 7.0   2.0 8.0     0.0   8.0   184.0 176.0         *         *   360.0 335 0 7   2 8     0   8   184 176                 360
1154620 MN Benton 5 school 2732880 47 Independent Districts and Schools SAUK RAPIDS-RICE PUBLIC SCHOOLS 273288002246 9 SAUK RAPIDS-RICE MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No 2 06 08 2015   grade_7 287.0 9.0 8.0   5.0 8.0     0.0   11.0   154.0 174.0     4.0   3.0     107.0   63.0   328.0 287 9 8   5 8     0   11   154 174     4 3   107 63   328
1154641 MN Carver 10 school 2708190 112 Independent Districts and Schools EASTERN CARVER COUNTY PUBLIC SCHOOL 270819000345 61 CHASKA MIDDLE SCHOOL EAST Middle School (Grades 5-8) Regular School No 2 06 08 2015   grade_7 161.0 3.0 23.0   0.0 8.0     1.0   5.0   104.0 97.0     7.0   1.0     35.0   18.0   201.0 161 3 23   0 8     1   5   104 97     7 1   35 18   201
1154649 MN Carver 10 school 2708190 112 Independent Districts and Schools EASTERN CARVER COUNTY PUBLIC SCHOOL 270819003180 63 PIONEER RIDGE MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No 2 06 08 2015   grade_7 156.0 3.0 21.0   0.0 8.0     0.0   3.0   93.0 98.0     8.0   0.0     42.0   16.0   191.0 156 3 21   0 8     0   3   93 98     8 0   42 16   191
1154781 MN Goodhue 25 school 2730480 256 Independent Districts and Schools RED WING PUBLIC SCHOOL DISTRICT 273048001298 109 TWIN BLUFF MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No 2 05 07 2015   grade_7 152.0 10.0 15.0   12.0 8.0     0.0   6.0   108.0 95.0     3.0   1.0     77.0   27.0   203.0 152 10 15   12 8     0   6   108 95     3 1   77 27   203
1155151 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 2015   grade_7 253.0 7.0 11.0   0.0 8.0     0.0   3.0   143.0 139.0     4.0   0.0     25.0   22.0   282.0 253 7 11   0 8     0   3   143 139     4 0   25 22   282
1155207 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 2015   grade_7 201.0 4.0 4.0   0.0 8.0     0.0   6.0   112.0 111.0     6.0   0.0     39.0   16.0   223.0 201 4 4   0 8     0   6   112 111     6 0   39 16   223
1832665 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124000969 121 Lake Harriet Upper School Elementary School (Grades PK-6) Regular School No Middle 04 08 2020   grade_7 98.0 3.0 5.0   0.0 8.0     0.0   7.0   72.0 49.0     4.0   2.0     14.0   9.0   121.0 98 3 5   0 8     0   7   72 49     4 2   14 9   121
1835026 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 2020   grade_7 128.0 71.0 31.0   1.0 8.0     1.0   11.0   126.0 125.0     24.0   1.0     95.0   31.0   251.0 128 71 31   1 8     1   11   126 125     24 1   95 31   251
1835094 MN Washington 82 school 2700362 4120 Charter Schools St. Croix Preparatory Academy 270036204222 20 St Croix Preparatory Academy Middle Middle School (Grades 5-8) Regular School Yes Middle 05 08 2020   grade_7 74.0 2.0 4.0   0.0 8.0     0.0   4.0   44.0 48.0     0.0   0.0     4.0   23.0   92.0 74 2 4   0 8     0   4   44 48     0 0   4 23   92
1836368 MN Carver 10 school 2708190 112 Independent Districts and Schools Eastern Carver County Public School 270819004622 66 112 ALC Middle School Public Area Learning Center ALC (State approved) Alternative School No Middle 06 08 2020   grade_7 79.0 11.0 27.0   1.0 8.0     0.0   7.0   73.0 60.0     10.0   0.0     58.0   30.0   133.0 79 11 27   1 8     0   7   73 60     10 0   58 30   133
1888167 MN Anoka 2 school 2700320 4185 Charter Schools DaVinci Academy 270032004268 10 DaVinci Academy Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2018   grade_7 36.0 4.0 2.0   1.0 8.0     0.0   1.0   25.0 27.0     0.0   0.0     10.0   4.0   52.0 36 4 2   1 8     0   1   25 27     0 0   10 4   52
1888672 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 Middle 06 08 2018   grade_7 266.0 1.0 13.0   1.0 8.0     0.0   18.0   144.0 163.0     5.0   2.0     72.0   35.0   307.0 266 1 13   1 8     0   18   144 163     5 2   72 35   307
1888693 MN Benton 5 school 2732880 47 Independent Districts and Schools Sauk Rapids-Rice Public Schools 273288002246 9 Sauk Rapids-Rice Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2018   grade_7 285.0 14.0 17.0   4.0 8.0     0.0   13.0   163.0 178.0     4.0   3.0     122.0   48.0   341.0 285 14 17   4 8     0   13   163 178     4 3   122 48   341
1888960 MN Hennepin 27 school 2733780 283 Independent Districts and Schools St. Louis Park Public School District 273378001533 42 St. Louis Park Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2018   grade_7 189.0 79.0 39.0   5.0 8.0     0.0   24.0   176.0 168.0     20.0   3.0     118.0   41.0   344.0 189 79 39   5 8     0   24   176 168     20 3   118 41   344

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