Data source: Big Local News · About: Big Local

4,774 rows where grade = "grade_7" and state = "MN" sorted by hispanic 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
862296 MN Nobles 53 school 2744160 518 Independent Districts and Schools WORTHINGTON PUBLIC SCHOOL DISTRICT 274416001840 4 WORTHINGTON MIDDLE Middle School (Grades 5-8) Regular School No 2 05 08 2016   grade_7 65 11 99   1 27     0   3   101 105     39.0   *     146.0   31.0   206 65 11 99   1 27     0   3   101 105     39     146 31   206
698208 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 Middle 06 08 2017   grade_7 114.0 52.0 96.0   2.0 15.0     0.0   13.0   142.0 150.0     45.0   3.0     141.0   33.0   292.0 114 52 96   2 15     0   13   142 150     45 3   141 33   292
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
1835122 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 2020   grade_7 1.0 7.0 95.0   0.0 0.0     0.0   0.0   54.0 49.0     48.0   1.0     86.0   12.0   103.0 1 7 95   0 0     0   0   54 49     48 1   86 12   103
1888889 MN Hennepin 27 school 2705790 271 Independent Districts and Schools Bloomington Public School District 270579000638 345 Valley View Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2018   grade_7 44.0 78.0 95.0   2.0 20.0     0.0   20.0   131.0 128.0     48.0   11.0     197.0   49.0   259.0 44 78 95   2 20     0   20   131 128     48 11   197 49   259
1953258 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 2019   grade_7 39.0 84.0 94.0   5.0 8.0     0.0   15.0   127.0 118.0     39.0   5.0     182.0   32.0   245.0 39 84 94   5 8     0   15   127 118     39 5   182 32   245
1721191 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 Middle 06 08 2021   grade_7 110 52 94   3 13     0   21   160 133     37.0   2.0     133.0   33.0   293 110 52 94   3 13     0   21   160 133     37 2   133 33   293
697936 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_7 59.0 53.0 92.0   1.0 18.0     0.0   14.0   128.0 109.0     40.0   4.0     166.0   32.0   237.0 59 53 92   1 18     0   14   128 109     40 4   166 32   237
1834409 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_7 40.0 65.0 91.0   2.0 16.0     0.0   19.0   120.0 113.0     37.0   5.0     162.0   39.0   233.0 40 65 91   2 16     0   19   120 113     37 5   162 39   233
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
1154886 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 2015   grade_7 133.0 37.0 90.0   1.0 4.0     0.0   3.0   139.0 129.0     58.0   3.0     151.0   34.0   268.0 133 37 90   1 4     0   3   139 129     58 3   151 34   268
690439 MN Washington 82 school 2700358 4116 Charter Schools Lakes International Language Academy 270035804828 20 Lakes International Language Academy-Headwaters Campus Secondary School (Grades 7-12) Regular School Yes Other 06 12 2017   grade_7 73.0 0.0 9.0   0.0 1.0     0.0   2.0   40.0 45.0     0.0   0.0     19.0   15.0   85.0 73 0 9   0 1     0   2   40 45     0 0   19 15   85
696522 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124002144 226 MARCY OPEN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 08 2017   grade_7 41.0 34.0 9.0   3.0 1.0     0.0   3.0   46.0 45.0     12.0   2.0     48.0   13.0   91.0 41 34 9   3 1     0   3   46 45     12 2   48 13   91
697743 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 2017   grade_7 301.0 13.0 9.0   2.0 3.0     0.0   13.0   171.0 170.0     4.0   1.0     111.0   61.0   341.0 301 13 9   2 3     0   13   171 170     4 1   111 61   341
698110 MN Nobles 53 school 2702730 511 Independent Districts and Schools ADRIAN PUBLIC SCHOOL DISTRICT 270273003076 15 ADRIAN MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_7 27.0 0.0 9.0   0.0 3.0     0.0   1.0   20.0 20.0     2.0   0.0     14.0   4.0   40.0 27 0 9   0 3     0   1   20 20     2 0   14 4   40
698249 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 Middle 06 08 2017   grade_7 277.0 10.0 9.0   5.0 5.0     0.0   14.0   164.0 156.0     1.0   1.0     77.0   15.0   320.0 277 10 9   5 5     0   14   164 156     1 1   77 15   320
698377 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 Middle 05 08 2017   grade_7 231.0 8.0 9.0   0.0 3.0     0.0   9.0   133.0 127.0     3.0   0.0     41.0   24.0   260.0 231 8 9   0 3     0   9   133 127     3 0   41 24   260
698579 MN Hennepin 27 school 2700284 4159 Charter Schools Seven Hills Preparatory Academy 270028404804 20 Seven Hills Preparatory Academy Upper School Middle School (Grades 5-8) Regular School Yes Middle 06 08 2017   grade_7 50.0 6.0 9.0   0.0 1.0     0.0   5.0   32.0 39.0     11.0   0.0     12.0   9.0   71.0 50 6 9   0 1     0   5   32 39     11 0   12 9   71
701873 MN Ramsey 62 school 2700117 4017 Charter Schools Minnesota Transitions Charter School 270011703694 18 MTCS CONNECTIONS ACADEMY Distance Learning Program OLL (State approved) Regular School Yes Other KG 12 2017   grade_7 120.0 11.0 9.0   0.0 6.0     0.0   12.0   77.0 81.0     0.0   0.0     53.0   27.0   158.0 120 11 9   0 6     0   12   77 81     0 0   53 27   158
1154612 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 2 06 08 2015   grade_7 268.0 5.0 9.0   54.0 3.0     2.0   8.0   179.0 170.0     3.0   3.0     163.0   61.0   349.0 268 5 9   54 3     2   8   179 170     3 3   163 61   349
1154633 MN Carver 10 school 2741460 110 Independent Districts and Schools WACONIA PUBLIC SCHOOL DISTRICT 274146003066 220 CLEARWATER MIDDLE Middle School (Grades 5-8) Regular School No 2 05 08 2015   grade_7 283.0 3.0 9.0   1.0 1.0     0.0   8.0   155.0 150.0     2.0   1.0     37.0   29.0   305.0 283 3 9   1 1     0   8   155 150     2 1   37 29   305
1154818 MN Hennepin 27 school 2722920 277 Independent Districts and Schools WESTONKA PUBLIC SCHOOL DISTRICT 272292001109 63 GRANDVIEW MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No 2 05 07 2015   grade_7 154.0 3.0 9.0   0.0 2.0     0.0   13.0   92.0 89.0     1.0   1.0     46.0   20.0   181.0 154 3 9   0 2     0   13   92 89     1 1   46 20   181
1154986 MN Otter Tail 56 school 2728230 549 Independent Districts and Schools PERHAM-DENT PUBLIC SCHOOL DISTRICT 272823002535 20 PRAIRIE WIND MIDDLE Middle School (Grades 5-8) Regular School No 2 05 08 2015   grade_7 99.0 1.0 9.0   2.0 0.0     0.0   4.0   70.0 45.0     3.0   0.0     46.0   22.0   115.0 99 1 9   2 0     0   4   70 45     3 0   46 22   115
1155109 MN Sherburne 71 school 2705460 727 Independent Districts and Schools BIG LAKE PUBLIC SCHOOL DISTRICT 270546002462 30 BIG LAKE MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No 2 06 08 2015   grade_7 192.0 6.0 9.0   1.0 5.0     0.0   5.0   112.0 106.0         0.0         34.0   218.0 192 6 9   1 5     0   5   112 106       0     34   218
1155121 MN Sherburne 71 school 2711370 728 Independent Districts and Schools ELK RIVER PUBLIC SCHOOL DISTRICT 271137000517 400 VANDENBERGE MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No 2 06 08 2015   grade_7 168.0 2.0 9.0   2.0 3.0     0.0   9.0   95.0 98.0     5.0   0.0         25.0   193.0 168 2 9   2 3     0   9   95 98     5 0     25   193
1159060 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 2015   grade_7 170.0 36.0 9.0   1.0 13.0     1.0   8.0   114.0 124.0     6.0   2.0     90.0   39.0   238.0 170 36 9   1 13     1   8   114 124     6 2   90 39   238
1159115 MN Washington 82 school 2712270 831 Independent Districts and Schools FOREST LAKE PUBLIC SCHOOL DISTRICT 271227000600 116 Southwest Junior High Junior High School (Grades 7-8 or 7-9) Regular School No 2 07 09 2015   grade_7 264.0 1.0 9.0   1.0 6.0     0.0   5.0   163.0 123.0     5.0   0.0     57.0   42.0   286.0 264 1 9   1 6     0   5   163 123     5 0   57 42   286
1159119 MN Washington 82 school 2738190 834 Independent Districts and Schools STILLWATER AREA PUBLIC SCHOOL DIST. 273819001660 48 OAK-LAND JUNIOR HIGH Junior High School (Grades 7-8 or 7-9) Regular School No 2 07 09 2015   grade_7 216.0 8.0 9.0   0.0 23.0     0.0   7.0   145.0 118.0         *         27.0   263.0 216 8 9   0 23     0   7   145 118             27   263
1826134 MN Winona 85 school 2733450 858 Independent Districts and Schools St. Charles Public School District 273345001476 3 St. Charles Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2020   grade_7 71.0 1.0 9.0   0.0 0.0     0.0   7.0   49.0 39.0     2.0   0.0     24.0   12.0   88.0 71 1 9   0 0     0   7   49 39     2 0   24 12   88
1832862 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124002144 226 Marcy Open Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 08 2020   grade_7 42.0 39.0 9.0   2.0 2.0     0.0   3.0   49.0 48.0     12.0   2.0     42.0   16.0   97.0 42 39 9   2 2     0   3   49 48     12 2   42 16   97
1833122 MN Hennepin 27 school 2700159 4038 Charter Schools Sojourner Truth Academy 270015902954 10 Sojourner Truth Academy Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2020   grade_7 1.0 26.0 9.0   0.0 1.0     0.0   4.0   18.0 23.0     7.0   3.0     35.0   6.0   41.0 1 26 9   0 1     0   4   18 23     7 3   35 6   41
1834276 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 Middle 05 08 2020   grade_7 181.0 2.0 9.0   1.0 3.0     0.0   7.0   98.0 105.0     3.0   0.0     52.0   26.0   203.0 181 2 9   1 3     0   7   98 105     3 0   52 26   203
1834440 MN Hennepin 27 school 2725080 278 Independent Districts and Schools Orono Public School District 272508001199 31 Orono Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2020   grade_7 206.0 1.0 9.0   0.0 4.0     0.0   6.0   123.0 103.0     3.0   1.0     13.0   28.0   226.0 206 1 9   0 4     0   6   123 103     3 1   13 28   226
1834488 MN Hennepin 27 school 2742160 284 Independent Districts and Schools Wayzata Public School District 274216001762 52 Wayzata East Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2020   grade_7 146.0 12.0 9.0   1.0 53.0     0.0   10.0   115.0 116.0     7.0   0.0     22.0   *   231.0 146 12 9   1 53     0   10   115 116     7 0   22     231
1834514 MN Hubbard 29 school 2728080 309 Independent Districts and Schools Park Rapids Public School District 272808001236 80 Park Rapids Area Century Middle Middle School (Grades 5-8) Regular School No Middle 05 08 2020   grade_7 125.0 2.0 9.0   3.0 0.0     0.0   7.0   66.0 80.0     3.0   0.0     69.0   27.0   146.0 125 2 9   3 0     0   7   66 80     3 0   69 27   146
1834557 MN Wright 86 school 2710060 466 Independent Districts and Schools Dassel-Cokato Public School Dist. 271006002267 4 Dassel-Cokato Middle Middle School (Grades 5-8) Regular School No Middle 05 08 2020   grade_7 194.0 2.0 9.0   0.0 1.0     0.0   2.0   105.0 103.0     2.0   0.0     50.0   18.0   208.0 194 2 9   0 1     0   2   105 103     2 0   50 18   208
1834620 MN Olmsted 55 school 2738160 534 Independent Districts and Schools Stewartville Public School District 273816002822 20 Stewartville Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2020   grade_7 142.0 1.0 9.0   0.0 1.0     0.0   4.0   81.0 76.0     1.0   0.0     42.0   22.0   157.0 142 1 9   0 1     0   4   81 76     1 0   42 22   157
1834750 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 Middle 06 08 2020   grade_7 310.0 7.0 9.0   7.0 3.0     0.0   21.0   169.0 188.0     *   2.0     60.0   24.0   357.0 310 7 9   7 3     0   21   169 188       2   60 24   357
1834787 MN Hennepin 27 school 2711370 728 Independent Districts and Schools Elk River School District 271137002844 340 Rogers Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2020   grade_7 194.0 4.0 9.0   0.0 7.0     0.0   13.0   114.0 113.0     5.0   0.0         25.0   227.0 194 4 9   0 7     0   13   114 113     5 0     25   227
1834791 MN Sherburne 71 school 2711370 728 Independent Districts and Schools Elk River School District 271137003360 350 Zimmerman Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2020   grade_7 185.0 3.0 9.0   0.0 1.0     0.0   8.0   101.0 105.0     4.0   0.0     48.0   36.0   206.0 185 3 9   0 1     0   8   101 105     4 0   48 36   206
1834799 MN Sherburne 71 school 2711370 728 Independent Districts and Schools Elk River School District 271137000517 400 VandenBerge Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2020   grade_7 158.0 6.0 9.0   2.0 4.0     0.0   6.0   91.0 94.0     *   0.0     35.0   34.0   185.0 158 6 9   2 4     0   6   91 94       0   35 34   185
1834917 MN Isanti 30 school 2707410 911 Independent Districts and Schools Cambridge-Isanti Public School Dist 270741003629 302 Isanti Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2020   grade_7 141.0 2.0 9.0   0.0 3.0     0.0   10.0   79.0 86.0     3.0   0.0     54.0   24.0   165.0 141 2 9   0 3     0   10   79 86     3 0   54 24   165
1835139 MN Hennepin 27 school 2700335 4205 Charter Schools Hennepin Elementary School 270033505203 20 Hennepin Middle School Middle School (Grades 5-8) Regular School Yes Middle 06 08 2020   grade_7 0.0 26.0 9.0   0.0 0.0     0.0   0.0   16.0 19.0     13.0   0.0         5.0   35.0 0 26 9   0 0     0   0   16 19     13 0     5   35
1839069 MN Scott 70 school 2704050 716 Independent Districts and Schools Belle Plaine Public School District 270405002169 30 Belle Plaine Junior High Junior High School (Grades 7-8 or 7-9) Regular School No Middle 07 08 2020   grade_7 112.0 1.0 9.0   0.0 2.0     0.0   7.0   59.0 72.0     1.0   0.0     20.0   23.0   131.0 112 1 9   0 2     0   7   59 72     1 0   20 23   131
1880600 MN Steele 74 school 2719320 763 Independent Districts and Schools Medford Public School District 271932000910 20 Medford Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_7 69.0 0.0 9.0   0.0 0.0     0.0   1.0   43.0 36.0     0.0   0.0     32.0   6.0   79.0 69 0 9   0 0     0   1   43 36     0 0   32 6   79
1880771 MN Faribault 22 school 2700005 2134 Independent Districts and Schools United South Central School District 270000501770 20 United South Central High School Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_7 36.0 2.0 9.0   0.0 0.0     0.0   2.0   23.0 26.0     2.0   0.0     27.0   7.0   49.0 36 2 9   0 0     0   2   23 26     2 0   27 7   49
1881253 MN Washington 82 school 2700358 4116 Charter Schools Lakes International Language Academy 270035804828 20 Lakes International Language Academy-Headwaters Campus Secondary School (Grades 7-12) Regular School Yes High 06 12 2018   grade_7 71.0 1.0 9.0   0.0 0.0     0.0   4.0   31.0 54.0     0.0   0.0     6.0   8.0   85.0 71 1 9   0 0     0   4   31 54     0 0   6 8   85
1883460 MN Hennepin 27 school 2731780 281 Independent Districts and Schools Robbinsdale Public School District 273178004952 401 The FAIR School - Crystal Elementary School (Grades PK-6) Regular School No Middle 04 08 2018   grade_7 32.0 47.0 9.0   0.0 3.0     1.0   11.0   50.0 53.0     7.0   0.0     57.0   13.0   103.0 32 47 9   0 3     1   11   50 53     7 0   57 13   103
1885080 MN Ramsey 62 school 2733840 625 Independent Districts and Schools St. Paul Public School District 273384002303 579 American Indian Magnet School Elementary School (Grades PK-6) Regular School No Elementary PK 08 2018   grade_7 3.0 15.0 9.0   12.0 14.0     0.0   5.0   31.0 27.0     *   3.0     50.0   16.0   58.0 3 15 9   12 14     0   5   31 27       3   50 16   58
1888651 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 2018   grade_7 352.0 11.0 9.0   2.0 11.0     1.0   16.0   205.0 197.0     3.0   4.0     57.0   *   402.0 352 11 9   2 11     1   16   205 197     3 4   57     402
1888813 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 Middle 06 08 2018   grade_7 263.0 7.0 9.0   2.0 20.0     0.0   8.0   163.0 146.0     *   0.0     *   *   309.0 263 7 9   2 20     0   8   163 146       0         309
1889005 MN Kandiyohi 34 school 2723400 345 Independent Districts and Schools New London-Spicer School District 272340000948 20 New London-Spicer Middle Middle School (Grades 5-8) Regular School No Middle 05 08 2018   grade_7 106.0 0.0 9.0   0.0 0.0     1.0   0.0   60.0 56.0     1.0   2.0     28.0   18.0   116.0 106 0 9   0 0     1   0   60 56     1 2   28 18   116
1889268 MN Stearns 73 school 2728140 741 Independent Districts and Schools Paynesville Public School District 272814001241 2 Paynesville Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2018   grade_7 60.0 0.0 9.0   0.0 0.0     0.0   3.0   29.0 43.0     3.0   0.0     25.0   16.0   72.0 60 0 9   0 0     0   3   29 43     3 0   25 16   72
1889468 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124000965 119 Field Community Middle School (Grades 5-8) Regular School No Middle 05 08 2018   grade_7 93.0 23.0 9.0   1.0 5.0     0.0   3.0   62.0 72.0     5.0   0.0     33.0   21.0   134.0 93 23 9   1 5     0   3   62 72     5 0   33 21   134
1889546 MN Hennepin 27 school 2700240 4126 Charter Schools Prairie Seeds Academy 270024004805 30 Prairie Seeds Middle School Academy Middle School (Grades 5-8) Regular School Yes Middle 06 08 2018   grade_7 1.0 14.0 9.0   0.0 44.0     0.0   0.0   30.0 38.0     30.0   4.0     53.0   9.0   68.0 1 14 9   0 44     0   0   30 38     30 4   53 9   68
1945134 MN Stearns 73 school 2732850 743 Independent Districts and Schools SAUK CENTRE PUBLIC SCHOOL DISTRICT 273285001429 30 SAUK CENTRE SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_7 96.0 0.0 9.0   0.0 2.0     0.0   1.0   56.0 52.0     2.0   0.0     37.0   12.0   108.0 96 0 9   0 2     0   1   56 52     2 0   37 12   108
1945233 MN Watonwan 83 school 2707320 836 Independent Districts and Schools BUTTERFIELD PUBLIC SCHOOL DISTRICT 270732000305 30 BUTTERFIELD SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_7 10.0 0.0 9.0   0.0 1.0     0.0   0.0   8.0 12.0     6.0   0.0     15.0   3.0   20.0 10 0 9   0 1     0   0   8 12     6 0   15 3   20
1945447 MN Chippewa 12 school 2700091 2180 Independent Districts and Schools MACCRAY School District 270009100365 20 MACCRAY SENIOR HIGH Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_7 52.0 0.0 9.0   0.0 0.0     1.0   1.0   35.0 28.0     0.0   0.0     23.0   13.0   63.0 52 0 9   0 0     1   1   35 28     0 0   23 13   63
1945497 MN Renville 65 school 2705660 2534 Independent Districts and Schools Bird Island-Olivia-Lake Lillian Public School District 270566000147 20 BOLD SENIOR HIGH Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_7 43.0 0.0 9.0   0.0 1.0     0.0   1.0   27.0 27.0     4.0   0.0     26.0   4.0   54.0 43 0 9   0 1     0   1   27 27     4 0   26 4   54
1945568 MN Lac qui Parle 37 school 2700125 2853 Independent Districts and Schools LAC QUI PARLE VALLEY SCHOOL DIST. 270012502260 40 LAC QUI PARLE VALLEY SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_7 36.0 0.0 9.0   0.0 0.0     4.0   2.0   26.0 25.0     2.0   0.0     29.0   8.0   51.0 36 0 9   0 0     4   2   26 25     2 0   29 8   51
1949587 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384001612 528 LINWOOD MONROE ARTS PLUS UPPER Elementary School (Grades PK-6) Regular School No Middle 05 08 2019   grade_7 37.0 45.0 9.0   1.0 24.0     0.0   9.0   58.0 67.0     32.0   2.0     79.0   28.0   125.0 37 45 9   1 24     0   9   58 67     32 2   79 28   125
1951704 MN Lesueur 40 school 2700379 2905 Independent Districts and Schools TRI-CITY UNITED SCHOOL DISTRICT 270037904625 30 MONTGOMERY PRE K-8 Elementary School (Grades PK-6) Regular School No Elementary PK 08 2019   grade_7 74.0 1.0 9.0   0.0 0.0     0.0   3.0   50.0 37.0     3.0   1.0     22.0   15.0   87.0 74 1 9   0 0     0   3   50 37     3 1   22 15   87
1952211 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 Elementary KG 08 2019   grade_7 110.0 6.0 9.0   6.0 1.0     0.0   13.0   71.0 74.0     1.0   0.0     70.0   37.0   145.0 110 6 9   6 1     0   13   71 74     1 0   70 37   145
1953267 MN Anoka 2 school 2733540 15 Independent Districts and Schools St. Francis Area Schools 273354000013 123 ST. FRANCIS MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_7 185.0 1.0 9.0   2.0 5.0     0.0   14.0   114.0 102.0     1.0   1.0     48.0   44.0   216.0 185 1 9   2 5     0   14   114 102     1 1   48 44   216
1953328 MN Carver 10 school 2708190 112 Independent Districts and Schools EASTERN CARVER COUNTY PUBLIC SCHOOL 270819002798 62 CHASKA MIDDLE SCHOOL WEST Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_7 170.0 1.0 9.0   0.0 7.0     0.0   7.0   106.0 88.0     0.0   0.0     6.0   13.0   194.0 170 1 9   0 7     0   7   106 88     0 0   6 13   194
1953401 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 Middle 06 08 2019   grade_7 273.0 19.0 9.0   2.0 7.0     1.0   21.0   176.0 156.0     2.0   0.0     52.0   60.0   332.0 273 19 9   2 7     1   21   176 156     2 0   52 60   332
1953564 MN Hennepin 27 school 2742160 284 Independent Districts and Schools WAYZATA PUBLIC SCHOOL DISTRICT 274216001762 52 WAYZATA EAST MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_7 127.0 16.0 9.0   0.0 31.0     0.0   10.0   94.0 99.0     5.0   2.0     23.0   18.0   193.0 127 16 9   0 31     0   10   94 99     5 2   23 18   193
1953708 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 Middle 06 08 2019   grade_7 105.0 16.0 9.0   0.0 18.0     0.0   4.0   87.0 65.0     7.0   0.0     29.0   13.0   152.0 105 16 9   0 18     0   4   87 65     7 0   29 13   152
1953714 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 Middle 04 08 2019   grade_7 162.0 7.0 9.0   2.0 0.0     0.0   9.0   100.0 89.0     *   0.0         22.0   189.0 162 7 9   2 0     0   9   100 89       0     22   189
1953787 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_7 45.0 85.0 9.0   3.0 21.0     0.0   9.0   96.0 76.0     20.0   6.0     116.0   21.0   172.0 45 85 9   3 21     0   9   96 76     20 6   116 21   172
1953962 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 Middle 05 08 2019   grade_7 214.0 12.0 9.0   0.0 2.0     0.0   11.0   123.0 125.0     2.0   1.0     27.0   19.0   248.0 214 12 9   0 2     0   11   123 125     2 1   27 19   248
1953995 MN Clay 14 school 2710260 2164 Independent Districts and Schools DILWORTH-GLYNDON-FELTON 271026000448 3 DILWORTH-GLYNDON-FELTON MIDDLE SCH Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_7 104.0 0.0 9.0   2.0 0.0     0.0   7.0   54.0 68.0     0.0   1.0     37.0   20.0   122.0 104 0 9   2 0     0   7   54 68     0 1   37 20   122
1957456 MN Ramsey 62 school 2700117 4017 Charter Schools Minnesota Transitions Charter School 270011703694 18 Minnesota Connections Academy Distance Learning Program OLL (State approved) Regular School Yes Other KG 12 2019   grade_7 144.0 18.0 9.0   4.0 3.0     0.0   17.0   91.0 104.0     *   *     90.0   26.0   195.0 144 18 9   4 3     0   17   91 104           90 26   195
854243 MN Swift 76 school 2704470 777 Independent Districts and Schools BENSON PUBLIC SCHOOL DISTRICT 270447000199 101 BENSON SECONDARY Secondary School (Grades 7-12) Regular School No 3 07 12 2016   grade_7 67 1 9   0 1     0   1   38 41         *         *   79 67 1 9   0 1     0   1   38 41                 79
854392 MN Faribault 22 school 2700005 2134 Independent Districts and Schools UNITED SOUTH CENTRAL SCHOOL DIST. 270000501770 20 UNITED SOUTH CENTRAL HIGH SCHOOL Secondary School (Grades 7-12) Regular School No 3 07 12 2016   grade_7 52 0 9   0 0     0   0   24 37     1.0   0.0     33.0   9.0   61 52 0 9   0 0     0   0   24 37     1 0   33 9   61
861971 MN Carver 10 school 2708190 112 Independent Districts and Schools EASTERN CARVER COUNTY PUBLIC SCHOOL 270819002798 62 CHASKA MIDDLE SCHOOL WEST Middle School (Grades 5-8) Regular School No 2 06 08 2016   grade_7 198 10 9   2 17     0   10   125 121     6.0   0.0     43.0   38.0   246 198 10 9   2 17     0   10   125 121     6 0   43 38   246
862197 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 2 06 08 2016   grade_7 227 36 9   2 62     0   15   171 180     1.0   1.0     50.0   27.0   351 227 36 9   2 62     0   15   171 180     1 1   50 27   351
862226 MN Kandiyohi 34 school 2723400 345 Independent Districts and Schools NEW LONDON-SPICER SCHOOL DISTRICT 272340000948 20 NEW LONDON-SPICER MIDDLE Middle School (Grades 5-8) Regular School No 2 05 08 2016   grade_7 105 0 9   1 0     0   2   54 63     0.0   0.0     32.0   13.0   117 105 0 9   1 0     0   2   54 63     0 0   32 13   117
862334 MN Otter Tail 56 school 2728230 549 Independent Districts and Schools PERHAM-DENT PUBLIC SCHOOL DISTRICT 272823002535 20 PRAIRIE WIND MIDDLE Middle School (Grades 5-8) Regular School No 2 05 08 2016   grade_7 93 1 9   1 0     0   2   52 54     1.0   0.0     48.0   16.0   106 93 1 9   1 0     0   2   52 54     1 0   48 16   106
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
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
862544 MN Wright 86 school 2732070 883 Independent Districts and Schools ROCKFORD PUBLIC SCHOOL DISTRICT 273207001941 3 ROCKFORD MIDDLE Middle School (Grades 5-8) Regular School No 2 05 08 2016   grade_7 119 4 9   0 4     0   7   78 65     3.0   0.0     28.0   24.0   143 119 4 9   0 4     0   7   78 65     3 0   28 24   143
862606 MN Yellow Medicine 87 school 2700099 2190 Independent Districts and Schools YELLOW MEDICINE EAST 270009904609 23 YELLOW MEDICINE EAST MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No 2 06 08 2016   grade_7 39 1 9   13 0     0   1   33 30     2.0   0.0     33.0   11.0   63 39 1 9   13 0     0   1   33 30     2 0   33 11   63
862611 MN Renville 65 school 2712580 2365 Independent Districts and Schools G.F.W. Public School District 271258000043 2 G.F.W. Middle School Middle School (Grades 5-8) Regular School No 2 05 08 2016   grade_7 45 0 9   0 1     0   4   28 31     4.0   0.0     21.0   9.0   59 45 0 9   0 1     0   4   28 31     4 0   21 9   59
862629 MN Pipestone 59 school 2700108 2689 Independent Districts and Schools PIPESTONE AREA SCHOOL DISTRICT 270010801264 7 PIPESTONE MIDDLE Middle School (Grades 5-8) Regular School No 2 05 08 2016   grade_7 73 4 9   1 0     0   0   41 46         *         *   87 73 4 9   1 0     0   0   41 46                 87
864207 MN Mower 50 school 2703450 492 Independent Districts and Schools AUSTIN PUBLIC SCHOOL DISTRICT 270345002231 150 AUSTIN AREA LEARNING CENTER Public Area Learning Center ALC (State approved) Alternative Education School No 4 06 12 2016   grade_7 6 1 9   0 0     1   1   10 8     7.0   0.0         0.0   18 6 1 9   0 0     1   1   10 8     7 0     0   18
866731 MN Washington 82 school 2738190 834 Independent Districts and Schools STILLWATER AREA PUBLIC SCHOOL DIST. 273819001660 48 OAK-LAND JUNIOR HIGH Junior High School (Grades 7-8 or 7-9) Regular School No 2 07 09 2016   grade_7 210 14 9   4 19     0   7   136 127         *         35.0   263 210 14 9   4 19     0   7   136 127             35   263
1712060 MN Lyon 42 school 2721270 414 Independent Districts and Schools Minneota Public School District 272127001068 2 Minneota Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 36 0 9   0 0     0   2   35 12     3.0   0.0     11.0   6.0   47 36 0 9   0 0     0   2   35 12     3 0   11 6   47
1712443 MN Swift 76 school 2717120 775 Independent Districts and Schools Kerkhoven-Murdock-Sunburg 271712000023 50 Kerkhoven Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 56 0 9   0 0     0   1   32 34     1.0   0.0     22.0   12.0   66 56 0 9   0 0     0   1   32 34     1 0   22 12   66
1712513 MN Watonwan 83 school 2707320 836 Independent Districts and Schools Butterfield Public School District 270732000305 30 Butterfield Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 6 0 9   0 0     0   0   5 10     8.0   *     10.0   *   15 6 0 9   0 0     0   0   5 10     8     10     15
1713076 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 High 06 12 2021   grade_7 49 7 9   0 10     0   9   44 40     5.0   0.0     4.0   8.0   84 49 7 9   0 10     0   9   44 40     5 0   4 8   84
1716845 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 2021   grade_7 3 27 9   0 23     0   3   29 36     13.0   1.0     51.0   11.0   65 3 27 9   0 23     0   3   29 36     13 1   51 11   65
1720719 MN Brown 8 school 2723490 88 Independent Districts and Schools New Ulm Public School District 272349005035 40 NEW ULM MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 05 08 2021   grade_7 155 1 9   0 1     0   7   83 90     2.0   0.0     40.0   25.0   173 155 1 9   0 1     0   7   83 90     2 0   40 25   173
1721000 MN Hubbard 29 school 2728080 309 Independent Districts and Schools Park Rapids Public School District 272808001236 80 Park Rapids Area Century Middle Middle School (Grades 5-8) Regular School No Middle 05 08 2021   grade_7 93 1 9   5 0     0   6   60 54     *   0.0     54.0   27.0   114 93 1 9   5 0     0   6   60 54       0   54 27   114
1721042 MN Wright 86 school 2710060 466 Independent Districts and Schools Dassel-Cokato Public School Dist. 271006002267 4 Dassel-Cokato Middle Middle School (Grades 5-8) Regular School No Middle 05 08 2021   grade_7 141 0 9   0 2     0   4   92 64     1.0   0.0     23.0   21.0   156 141 0 9   0 2     0   4   92 64     1 0   23 21   156
1721097 MN Olmsted 55 school 2707350 531 Independent Districts and Schools Byron Public School District 270735000981 30 Byron Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 153 1 9   2 3     1   5   84 90     1.0   2.0     22.0   17.0   174 153 1 9   2 3     1   5   84 90     1 2   22 17   174
1721125 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 Middle 06 08 2021   grade_7 105 21 9   1 12     0   10   76 82     5.0   0.0     20.0   16.0   158 105 21 9   1 12     0   10   76 82     5 0   20 16   158
1721139 MN Pennington 57 school 2738850 564 Independent Districts and Schools Thief River Falls School District 273885001674 60 Franklin Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 117 5 9   5 0     0   15   81 70     1.0   2.0     59.0   26.0   151 117 5 9   5 0     0   15   81 70     1 2   59 26   151
1721199 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 Middle 06 08 2021   grade_7 17 19 9   0 38     0   5   53 35     16.0   0.0     61.0   16.0   88 17 19 9   0 38     0   5   53 35     16 0   61 16   88
1721280 MN Wright 86 school 2711370 728 Independent Districts and Schools Elk River School District 271137005253 380 Prairie View Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 142 11 9   0 1     0   12   81 94     7.0   0.0     *   26.0   175 142 11 9   0 1     0   12   81 94     7 0     26   175

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