enrollments

Data source: Big Local News · About: Big Local

694 rows where grade = "grade_7", state = "MN" and year = 2021 sorted by ccd_school_low_grade

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2021 · 694 ✖

grade ✖

  • grade_7 · 694 ✖
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
1716870 1716870 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 Elementary 01 08 2021   grade_7 64 59 8   0 45     0   16   94 98     18.0   0.0     92.0   15.0   192 64 59 8   0 45     0   16   94 98     18 0   92 15   192
1719488 1719488 MN Carver 10 school 2700116 4016 Charter Schools World Learner Charter School 270011602606 10 World Learner Charter School Elementary School (Grades PK-6) Regular School Yes Elementary 01 08 2021   grade_7 19 1 2   0 2     0   0   8 16     0.0   0.0     1.0   3.0   24 19 1 2   0 2     0   0   8 16     0 0   1 3   24
1723788 1723788 MN Sherburne 71 school 2711370 728 Independent Districts and Schools Elk River School District 271137004142 401 ISD 728 Focus/Journey Special Education Special Education School No Other 01 12 2021   grade_7 1 0 0   0 0     0   1   2 0     *   *     *   *   2 1 0 0   0 0     0   1   2 0                 2
1724224 1724224 MN Mower 50 school 2700327 6083 Special Education Cooperatives Southern MN Education Consortium 270032705231 150 RESET Special Education Special Education School No Other 01 12 2021   grade_7 1 0 0   0 0     0   0   1 0     *   *     *   *   1 1 0 0   0 0     0   0   1 0                 1
1724543 1724543 MN Brown 8 school 2791353 6049 Education Districts River Bend Education District 279135304366 35 Imprints Program Special Education Special Education School No Other 01 12 2021   grade_7 5 1 0   0 0     0   0   6 0     *   *     *   *   6 5 1 0   0 0     0   0   6 0                 6
1719699 1719699 MN Hennepin 27 school 2700190 4079 Charter Schools Friendship Academy of Fine Arts Charter 270019005280 30 Friendship Academy of the Arts - Intermediate Elementary School (Grades PK-6) Regular School Yes Middle 02 08 2021   grade_7 0 20 0   0 0     0   0   10 10     0.0   0.0     *   4.0   20 0 20 0   0 0     0   0   10 10     0 0     4   20
1724430 1724430 MN Wadena 80 school 2700014 6004 Education Districts Freshwater Education District 270001404821 50 Elm Tree Academy Special Education Special Education School No Other 02 12 2021   grade_7 1 0 0   0 0     0   0   1 0     *   *     *   *   1 1 0 0   0 0     0   0   1 0                 1
1725174 1725174 MN Anoka 2 school 2702264 916 Intermediate Districts and Schools Northeast Metro 916 270226405176 26 Cambia Hills Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No Other 02 12 2021   grade_7 1 0 0   0 0     0   1   0 2     *   *     *   *   2 1 0 0   0 0     0   1   0 2                 2
1725229 1725229 MN Crow Wing 18 school 2706090 181 Independent Districts and Schools Brainerd Public School District 270609000468 17 Lincoln Education Center Miscellaneous Program (assignment is now limited) Alternative School No Other 02 12 2021   grade_7 2 1 0   1 0     0   1   4 1     *   *     *   *   5 2 1 0   1 0     0   1   4 1                 5
1719142 1719142 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124000988 134 Lake Nokomis Comm-Keewaydin Campus Elementary School (Grades PK-6) Regular School No Middle 03 08 2021   grade_7 42 12 10   1 1     1   9   37 39     6.0   0.0     33.0   18.0   76 42 12 10   1 1     1   9   37 39     6 0   33 18   76
1720028 1720028 MN Hennepin 27 school 2700295 4171 Charter Schools Noble Academy 270029503727 10 Noble Academy Elementary School (Grades PK-6) Regular School Yes Middle 03 08 2021   grade_7 0 10 1   0 75     0   1   45 42     25.0   0.0     62.0   11.0   87 0 10 1   0 75     0   1   45 42     25 0   62 11   87
1721053 1721053 MN Mille Lacs 48 school 2725050 480 Independent Districts and Schools Onamia Public School District 272505005107 50 Onamia Intermediate School Middle School (Grades 5-8) Regular School No Other 03 09 2021   grade_7 18 0 3   28 1     0   5   26 29     *   *     *   *   55 18 0 3   28 1     0   5   26 29                 55
1724725 1724725 MN Anoka 2 school 2733540 15 Independent Districts and Schools St. Francis Area Schools 273354004917 15 Saints Online Distance Learning Program OLL (State approved) Regular School No Other 03 12 2021   grade_7 2 1 0   0 0     0   0   2 1     *   *     *   *   3 2 1 0   0 0     0   0   2 1                 3
1724959 1724959 MN Beltrami 4 school 2704440 31 Independent Districts and Schools Bemidji Public School District 270444000313 160 First City School Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No Other 03 12 2021   grade_7 0 0 0   1 0     0   0   1 0     *   *     *   *   1 0 0 0   1 0     0   0   1 0                 1
1713694 1713694 MN Benton 5 school 2712240 51 Independent Districts and Schools Foley Public School District 271224002270 30 Foley Intermediate Elementary Elementary School (Grades PK-6) Regular School No Middle 04 08 2021   grade_7 140 1 7   0 0     0   4   83 69     1.0   0.0     37.0   13.0   152 140 1 7   0 0     0   4   83 69     1 0   37 13   152
1719121 1719121 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 2021   grade_7 102 2 5   0 3     0   3   52 63     3.0   0.0     6.0   9.0   115 102 2 5   0 3     0   3   52 63     3 0   6 9   115
1720106 1720106 MN Hennepin 27 school 2700308 4191 Charter Schools KIPP Minnesota Charter School 270030805269 20 KIPP Legacy Academy Elementary School (Grades PK-6) Regular School Yes Middle 04 07 2021   grade_7 0 34 1   0 0     0   0   19 16     0.0   3.0     28.0   9.0   35 0 34 1   0 0     0   0   19 16     0 3   28 9   35
1720765 1720765 MN Chippewa 12 school 2721320 129 Independent Districts and Schools Montevideo Public School District 272132001071 30 Montevideo Middle Middle School (Grades 5-8) Regular School No Middle 04 07 2021   grade_7 73 2 15   2 0     3   6   50 51     10.0   0.0     42.0   18.0   101 73 2 15   2 0     3   6   50 51     10 0   42 18   101
1721661 1721661 MN Hennepin 27 school 2700444 4263 Charter Schools Progeny Academy Charter School 270044405133 10 Progeny Academy Charter School Middle School (Grades 5-8) Regular School Yes Middle 04 08 2021   grade_7 2 15 2   0 2     0   1   13 9     13.0   0.0     18.0   3.0   22 2 15 2   0 2     0   1   13 9     13 0   18 3   22
1724597 1724597 MN Stearns 73 school 2700071 6383 Education Districts Benton-Stearns Education District 270007104581 40 Benton-Stearns Education District - ASD Program Special Education Special Education School No Other 04 12 2021   grade_7 1 0 0   0 0     0   0   1 0     *   *     *   *   1 1 0 0   0 0     0   0   1 0                 1
1724977 1724977 MN Clay 14 school 2721420 152 Independent Districts and Schools Moorhead Public School District 272142000413 960 West Central Academy-S Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No Other 04 12 2021   grade_7 0 0 0   1 0     0   0   0 1     *   *     *   *   1 0 0 0   1 0     0   0   0 1                 1
1725017 1725017 MN Kandiyohi 34 school 2742720 347 Independent Districts and Schools Willmar Public School District 274272004674 941 Lake Park School Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No Other 04 12 2021   grade_7 1 0 0   0 0     0   1   1 1     *   *     *   *   2 1 0 0   0 0     0   1   1 1                 2
1725031 1725031 MN Mille Lacs 48 school 2725050 480 Independent Districts and Schools Onamia Public School District 272505000957 30 Onamia Academy Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No Other 04 12 2021   grade_7 3 1 0   1 0     0   1   6 0     *   *     *   *   6 3 1 0   1 0     0   1   6 0                 6
1725099 1725099 MN Saint Louis 69 school 2711040 709 Independent Districts and Schools Duluth Public School District 271104001577 580 Rockridge Academy Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No Other 04 12 2021   grade_7 1 0 0   0 0     0   0   0 1     *   *     *   *   1 1 0 0   0 0     0   0   0 1                 1
1712207 1712207 MN Otter Tail 56 school 2740830 550 Independent Districts and Schools Underwood Public School District 274083001707 20 Underwood Secondary Secondary School (Grades 7-12) Regular School No High 05 12 2021   grade_7 47 1 0   0 0     0   0   28 20     1.0   0.0     22.0   9.0   48 47 1 0   0 0     0   0   28 20     1 0   22 9   48
1712615 1712615 MN Blue Earth 7 school 2700006 2135 Independent Districts and Schools Maple River School District 270000600888 20 Maple River Secondary Secondary School (Grades 7-12) Regular School No High 05 12 2021   grade_7 63 1 2   0 1     0   2   35 34     0.0   0.0     10.0   12.0   69 63 1 2   0 1     0   2   35 34     0 0   10 12   69
1712879 1712879 MN Redwood 64 school 2700132 2884 Independent Districts and Schools Red Rock Central School District 270013200820 20 Red Rock Central Secondary Secondary School (Grades 7-12) Regular School No High 05 12 2021   grade_7 30 0 0   0 1     0   0   19 12     0.0   0.0     11.0   4.0   31 30 0 0   0 1     0   0   19 12     0 0   11 4   31
1715361 1715361 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 05 08 2021   grade_7 17 28 7   1 2     0   4   26 33     1.0   0.0     34.0   13.0   59 17 28 7   1 2     0   4   26 33     1 0   34 13   59
1716923 1716923 MN Ramsey 62 school 2733840 625 Independent Districts and Schools St. Paul Public School District 273384001612 528 Global Arts Plus Upper Elementary School (Grades PK-6) Regular School No Middle 05 08 2021   grade_7 47 40 26   2 16     0   9   67 73     31.0   2.0     77.0   27.0   140 47 40 26   2 16     0   9   67 73     31 2   77 27   140
1720644 1720644 MN Aitkin 1 school 2714010 2 Independent Districts and Schools Hill City Public School District 271401004653 2 Hill City Middle School Middle School (Grades 5-8) Regular School No Middle 05 08 2021   grade_7 13 1 0   2 0     0   0   7 9     0.0   0.0     10.0   5.0   16 13 1 0   2 0     0   0   7 9     0 0   10 5   16
1720681 1720681 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 Middle 05 08 2021   grade_7 60 94 30   5 13     0   24   117 109     *   *     *   *   226 60 94 30   5 13     0   24   117 109                 226
1720690 1720690 MN Anoka 2 school 2733330 16 Independent Districts and Schools Spring Lake Park Public Schools 273333001466 92 Westwood Intermediate and Middle School Middle School (Grades 5-8) Regular School No Middle 05 08 2021   grade_7 276 55 77   4 38     0   36   231 255     44.0   2.0     143.0   64.0   486 276 55 77   4 38     0   36   231 255     44 2   143 64   486
1720694 1720694 MN Becker 3 school 2710230 22 Independent Districts and Schools Detroit Lakes Public School District 271023000443 4 Detroit Lakes Middle Middle School (Grades 5-8) Regular School No Middle 05 08 2021   grade_7 148 1 3   45 0     0   1   106 92     *   *     *   *   198 148 1 3   45 0     0   1   106 92                 198
1720719 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
1720724 1720724 MN Carlton 9 school 2709420 94 Independent Districts and Schools Cloquet Public School District 270942000381 201 Cloquet Middle Middle School (Grades 5-8) Regular School No Middle 05 08 2021   grade_7 163 2 5   24 0     0   25   106 113     0.0   0.0     101.0   48.0   219 163 2 5   24 0     0   25   106 113     0 0   101 48   219
1720737 1720737 MN Carver 10 school 2741910 111 Independent Districts and Schools Watertown-Mayer Public School District 274191000024 841 Watertown-Mayer Middle Middle School (Grades 5-8) Regular School No Middle 05 08 2021   grade_7 101 2 2   2 0     0   1   60 48     2.0   0.0     21.0   21.0   108 101 2 2   2 0     0   1   60 48     2 0   21 21   108
1720754 1720754 MN Cass 11 school 2708070 115 Independent Districts and Schools Cass Lake-Bena Public Schools 270807003181 20 Cass Lake-Bena Middle School Middle School (Grades 5-8) Regular School No Middle 05 08 2021   grade_7 5 0 0   78 0     0   0   42 41     0.0   0.0     55.0   19.0   83 5 0 0   78 0     0   0   42 41     0 0   55 19   83
1720759 1720759 MN Cass 11 school 2728350 116 Independent Districts and Schools Pillager Public School District 272835004841 40 Pillager Middle School Middle School (Grades 5-8) Regular School No Middle 05 08 2021   grade_7 86 0 2   0 0     0   4   47 45     0.0   0.0     40.0   18.0   92 86 0 2   0 0     0   4   47 45     0 0   40 18   92
1720773 1720773 MN Clay 14 school 2721420 152 Independent Districts and Schools Moorhead Public School District 272142003512 380 Horizon Middle School Middle School (Grades 5-8) Regular School No Middle 05 08 2021   grade_7 375 43 50   19 5     0   28   275 245     *   *     *   *   520 375 43 50   19 5     0   28   275 245                 520
1720786 1720786 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 Middle 05 08 2021   grade_7 430 5 13   11 3     0   20   243 239     2.0   2.0     166.0   91.0   482 430 5 13   11 3     0   20   243 239     2 2   166 91   482
1720791 1720791 MN Crow Wing 18 school 2728200 186 Independent Districts and Schools Pequot Lakes Public Schools 272820003069 15 Pequot Lakes Middle Middle School (Grades 5-8) Regular School No Middle 05 08 2021   grade_7 123 2 1   1 0     0   1   73 55     0.0   0.0     10.0   15.0   128 123 2 1   1 0     0   1   73 55     0 0   10 15   128
1720848 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
1720853 1720853 MN Dakota 19 school 2742270 197 Independent Districts and Schools West St. Paul-Mendota Heights-Eagan 274227001774 54 Heritage E-STEM Magnet School Middle School (Grades 5-8) Regular School No Middle 05 08 2021   grade_7 85 19 73   3 4     0   17   96 105     *   6.0     99.0   35.0   201 85 19 73   3 4     0   17   96 105       6   99 35   201
1720862 1720862 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 Middle 05 08 2021   grade_7 286 17 23   3 2     0   23   184 170     8.0   0.0     71.0   43.0   354 286 17 23   3 2     0   23   184 170     8 0   71 43   354
1720867 1720867 MN Dodge 20 school 2716980 204 Independent Districts and Schools Kasson-Mantorville School District 271698002243 40 Kasson-Mantorville Middle School Middle School (Grades 5-8) Regular School No Middle 05 08 2021   grade_7 156 1 15   0 2     0   7   84 97     4.0   1.0     29.0   15.0   181 156 1 15   0 2     0   7   84 97     4 1   29 15   181
1720883 1720883 MN Goodhue 25 school 2728950 255 Independent Districts and Schools Pine Island Public School District 272895004143 15 Pine Island Middle Middle School (Grades 5-8) Regular School No Middle 05 08 2021   grade_7 117 2 7   0 1     0   1   67 61     0.0   0.0     19.0   15.0   128 117 2 7   0 1     0   1   67 61     0 0   19 15   128
1720919 1720919 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 Middle 05 07 2021   grade_7 160 8 11   0 1     0   13   89 104     3.0   0.0     26.0   36.0   193 160 8 11   0 1     0   13   89 104     3 0   26 36   193
1720991 1720991 MN Houston 28 school 2717250 300 Independent Districts and Schools La Crescent-Hokah School District 271725004238 50 LA CRESCENT-HOKAH MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 05 08 2021   grade_7 73 4 3   1 1     0   6   47 41     0.0   0.0     18.0   16.0   88 73 4 3   1 1     0   6   47 41     0 0   18 16   88
1721000 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
1721005 1721005 MN Itasca 31 school 2709480 316 Independent Districts and Schools Greenway Public School District 270948002785 210 Greenway Middle Middle School (Grades 5-8) Regular School No Middle 05 08 2021   grade_7 77 1 4   7 0     0   7   53 43     0.0   1.0     40.0   34.0   96 77 1 4   7 0     0   7   53 43     0 1   40 34   96
1721014 1721014 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 2021   grade_7 115 0 12   0 0     0   1   51 77     2.0   1.0     33.0   19.0   128 115 0 12   0 0     0   1   51 77     2 1   33 19   128
1721023 1721023 MN Lyon 42 school 2718940 413 Independent Districts and Schools Marshall Public School District 271894003715 6 Marshall Middle School Middle School (Grades 5-8) Regular School No Middle 05 08 2021   grade_7 105 16 28   3 15     1   9   91 86     17.0   2.0     68.0   26.0   177 105 16 28   3 15     1   9   91 86     17 2   68 26   177
1721028 1721028 MN Lyon 42 school 2718390 415 Independent Districts and Schools Lynd Public School District 271839004845 40 Lynd Middle School Middle School (Grades 5-8) Regular School No Middle 05 08 2021   grade_7 8 0 5   0 0     0   0   6 7     *   *     11.0   5.0   13 8 0 5   0 0     0   0   6 7           11 5   13
1721037 1721037 MN Meeker 47 school 2718210 465 Independent Districts and Schools Litchfield Public School District 271821000838 30 Litchfield Middle School Middle School (Grades 5-8) Regular School No Middle 05 08 2021   grade_7 103 0 11   0 1     0   5   71 49     2.0   0.0     34.0   17.0   120 103 0 11   0 1     0   5   71 49     2 0   34 17   120
1721042 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
1721070 1721070 MN Mower 50 school 2713140 495 Independent Districts and Schools Grand Meadow Public School District 271314000660 20 Grand Meadow Middle Middle School (Grades 5-8) Regular School No Middle 05 08 2021   grade_7 36 0 2   0 1     0   3   16 26     0.0   0.0     10.0   7.0   42 36 0 2   0 1     0   3   16 26     0 0   10 7   42
1721079 1721079 MN Nicollet 52 school 2723580 507 Independent Districts and Schools Nicollet Public School District 272358004675 15 Nicollet Middle School Middle School (Grades 5-8) Regular School No Middle 05 08 2021   grade_7 20 0 4   0 0     0   1   14 11     0.0   0.0     3.0   7.0   25 20 0 4   0 0     0   1   14 11     0 0   3 7   25
1721084 1721084 MN Nicollet 52 school 2733870 508 Independent Districts and Schools St. Peter Public School District 273387002533 80 St. Peter Middle School Middle School (Grades 5-8) Regular School No Middle 05 08 2021   grade_7 131 15 25   1 1     0   2   84 91     *   *     *   *   175 131 15 25   1 1     0   2   84 91                 175
1721093 1721093 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 Middle 05 08 2021   grade_7 48 17 139   2 35     0   8   122 127     65.0   0.0     158.0   38.0   249 48 17 139   2 35     0   8   122 127     65 0   158 38   249
1721130 1721130 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 05 08 2021   grade_7 165 4 8   2 1     0   11   89 102     5.0   0.0     57.0   24.0   191 165 4 8   2 1     0   11   89 102     5 0   57 24   191
1721135 1721135 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 Middle 05 08 2021   grade_7 109 3 12   1 0     0   9   75 59     *   *     *   *   134 109 3 12   1 0     0   9   75 59                 134
1721187 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
1721223 1721223 MN Saint Louis 69 school 2713920 700 Independent Districts and Schools Hermantown Public School District 271392002143 15 Hermantown Middle Middle School (Grades 5-8) Regular School No Middle 05 08 2021   grade_7 140 0 5   0 1     0   10   85 71     2.0   3.0     17.0   24.0   156 140 0 5   0 1     0   10   85 71     2 3   17 24   156
1721240 1721240 MN Scott 70 school 2715750 717 Independent Districts and Schools Jordan Public School District 271575004144 128 Jordan Middle Middle School (Grades 5-8) Regular School No Middle 05 08 2021   grade_7 123 5 16   2 4     1   9   87 73     7.0   0.0     24.0   17.0   160 123 5 16   2 4     1   9   87 73     7 0   24 17   160
1721320 1721320 MN Traverse 78 school 2707110 801 Independent Districts and Schools Browns Valley Public School District 270711000280 20 Browns Valley Middle Middle School (Grades 5-8) Regular School No Middle 05 09 2021   grade_7 7 0 0   6 0     0   1   6 8     0.0   0.0     12.0   4.0   14 7 0 0   6 0     0   1   6 8     0 0   12 4   14
1721326 1721326 MN Wadena 80 school 2720580 821 Independent Districts and Schools Menahga Public School District 272058005019 20 Menahga Middle School Middle School (Grades 5-8) Regular School No Middle 05 08 2021   grade_7 65 0 3   0 1     0   4   34 39     0.0   0.0     43.0   12.0   73 65 0 3   0 1     0   4   34 39     0 0   43 12   73
1721362 1721362 MN Winona 85 school 2744070 861 Independent Districts and Schools Winona Area Public School District 274407001830 6 Winona Middle Middle School (Grades 5-8) Regular School No Middle 05 08 2021   grade_7 166 16 11   0 4     0   9   111 95     *   *     *   *   206 166 16 11   0 4     0   9   111 95                 206
1721383 1721383 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 Middle 05 08 2021   grade_7 102 7 9   0 2     0   8   64 64     3.0   0.0     25.0   16.0   128 102 7 9   0 2     0   8   64 64     3 0   25 16   128
1721388 1721388 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 2021   grade_7 201 6 8   1 7     0   18   121 120     1.0   0.0     27.0   24.0   241 201 6 8   1 7     0   18   121 120     1 0   27 24   241
1721393 1721393 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 2021   grade_7 250 12 11   0 4     0   9   145 141     6.0   0.0     38.0   17.0   286 250 12 11   0 4     0   9   145 141     6 0   38 17   286
1721422 1721422 MN Todd 77 school 2733900 2170 Independent Districts and Schools Staples-Motley School District 273390002468 50 Motley-Staples Middle School Middle School (Grades 5-8) Regular School No Middle 05 08 2021   grade_7 68 0 3   1 1     0   6   37 42     0.0   2.0     32.0   13.0   79 68 0 3   1 1     0   6   37 42     0 2   32 13   79
1721427 1721427 MN Goodhue 25 school 2717100 2172 Independent Districts and Schools Kenyon-Wanamingo School District 271710001741 40 Kenyon-Wanamingo Middle Middle School (Grades 5-8) Regular School No Middle 05 08 2021   grade_7 55 1 4   0 0     0   2   30 32     4.0   0.0     22.0   12.0   62 55 1 4   0 0     0   2   30 32     4 0   22 12   62
1721440 1721440 MN Grant 26 school 2700104 2342 Independent Districts and Schools West Central Area 270010404375 4 WCA Middle School Middle School (Grades 5-8) Regular School No Middle 05 08 2021   grade_7 56 1 2   0 0     0   2   26 35     1.0   0.0     22.0   8.0   61 56 1 2   0 0     0   2   26 35     1 0   22 8   61
1721449 1721449 MN Renville 65 school 2705660 2534 Independent Districts and Schools Bird Island-Olivia-Lake Lillian Public School District 270566005222 17 BOLD Middle School Middle School (Grades 5-8) Regular School No Middle 05 08 2021   grade_7 31 0 14   0 0     0   1   26 20     2.0   0.0     17.0   7.0   46 31 0 14   0 0     0   1   26 20     2 0   17 7   46
1721458 1721458 MN Wright 86 school 2700123 2687 Independent Districts and Schools Howard Lake-Waverly-Winsted 270012303350 86 Howard Lake-Waverly-Winsted Middle School Middle School (Grades 5-8) Regular School No Middle 05 08 2021   grade_7 84 1 6   0 0     0   6   56 41     2.0   0.0     24.0   10.0   97 84 1 6   0 0     0   6   56 41     2 0   24 10   97
1721463 1721463 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 Middle 05 08 2021   grade_7 53 1 20   0 0     0   6   38 42     4.0   0.0     33.0   9.0   80 53 1 20   0 0     0   6   38 42     4 0   33 9   80
1721481 1721481 MN Redwood 64 school 2700182 2897 Independent Districts and Schools Redwood Area School District 270018202301 3 Redwood Valley Middle Middle School (Grades 5-8) Regular School No Middle 05 08 2021   grade_7 44 2 3   33 1     0   4   48 39     0.0   0.0     33.0   11.0   87 44 2 3   33 1     0   4   48 39     0 0   33 11   87
1721498 1721498 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 2021   grade_7 95 8 10   1 4     1   7   57 69     5.0   0.0     17.0   13.0   126 95 8 10   1 4     1   7   57 69     5 0   17 13   126
1721535 1721535 MN Ramsey 62 school 2700115 4015 Charter Schools Community of Peace Academy 270011505136 12 Community of Peace Academy Middle School Middle School (Grades 5-8) Regular School Yes Middle 05 08 2021   grade_7 6 14 19   0 24     0   2   29 36     13.0   0.0     44.0   11.0   65 6 14 19   0 24     0   2   29 36     13 0   44 11   65
1721548 1721548 MN Hennepin 27 school 2700220 4067 Charter Schools Aurora Charter School 270022004420 20 Aurora Middle School Middle School (Grades 5-8) Regular School Yes Middle 05 08 2021   grade_7 0 0 50   0 0     0   0   28 22     26.0   0.0     43.0   7.0   50 0 0 50   0 0     0   0   28 22     26 0   43 7   50
1721557 1721557 MN Hennepin 27 school 2700189 4078 Charter Schools Twin Cities International Schools 270018903142 10 Minnesota International Middle Charter School Middle School (Grades 5-8) Regular School Yes Middle 05 08 2021   grade_7 0 114 0   0 0     0   0   42 72     45.0   0.0     *   6.0   114 0 114 0   0 0     0   0   42 72     45 0     6   114
1721578 1721578 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 2021   grade_7 67 5 6   0 12     0   3   42 51     2.0   0.0     7.0   13.0   93 67 5 6   0 12     0   3   42 51     2 0   7 13   93
1721587 1721587 MN Hennepin 27 school 2700245 4131 Charter Schools Metro Schools Charter 270024504857 20 Metro Schools Middle Charter Middle School (Grades 5-8) Regular School Yes Middle 05 08 2021   grade_7 0 37 0   0 0     0   0   19 18     21.0   0.0     *   3.0   37 0 37 0   0 0     0   0   19 18     21 0     3   37
1721601 1721601 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 Middle 05 08 2021   grade_7 17 5 2   0 1     0   2   1 26     0.0   3.0     6.0   5.0   27 17 5 2   0 1     0   2   1 26     0 3   6 5   27
1721606 1721606 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 2021   grade_7 0 12 67   1 0     0   0   40 40     37.0   0.0     69.0   9.0   80 0 12 67   1 0     0   0   40 40     37 0   69 9   80
1721611 1721611 MN Hennepin 27 school 2700288 4170 Charter Schools Hiawatha Academies 270028805141 15 Hiawatha College Prep - Northrop Middle School (Grades 5-8) Regular School Yes Middle 05 07 2021   grade_7 0 7 73   0 1     0   1   44 38     32.0   1.0     73.0   11.0   82 0 7 73   0 1     0   1   44 38     32 1   73 11   82
1721615 1721615 MN Hennepin 27 school 2700308 4191 Charter Schools KIPP Minnesota Charter School 270030804244 10 KIPP North Star Academy Middle School (Grades 5-8) Regular School Yes Middle 05 08 2021   grade_7 0 44 0   0 0     0   2   24 22     0.0   3.0     37.0   11.0   46 0 44 0   0 0     0   2   24 22     0 3   37 11   46
1721620 1721620 MN Hennepin 27 school 2700333 4199 Charter Schools Parnassus Preparatory Charter School 270033304837 20 Parnassus Preparatory School-Logic Middle School (Grades 5-8) Regular School Yes Middle 05 08 2021   grade_7 45 44 7   0 18     0   6   60 60     6.0   0.0     33.0   9.0   120 45 44 7   0 18     0   6   60 60     6 0   33 9   120
1721633 1721633 MN Anoka 2 school 2700380 4213 Charter Schools Prodeo Academy 270038005319 12 Prodeo Academy Columbia Heights Middle Middle School (Grades 5-8) Regular School Yes Middle 05 07 2021   grade_7 1 32 17   0 0     0   1   25 26     7.0   6.0     38.0   7.0   51 1 32 17   0 0     0   1   25 26     7 6   38 7   51
1721637 1721637 MN Isanti 30 school 2700397 4227 Charter Schools Art and Science Academy 270039705095 30 Art & Science Academy Middle School Middle School (Grades 5-8) Regular School Yes Middle 05 08 2021   grade_7 35 2 1   0 0     0   2   19 21     0.0   1.0     9.0   13.0   40 35 2 1   0 0     0   2   19 21     0 1   9 13   40
1721642 1721642 MN Ramsey 62 school 2700399 4231 Charter Schools Minnesota Math and Science Academy 270039905177 20 MMSA Middle School Middle School (Grades 5-8) Regular School Yes Middle 05 08 2021   grade_7 0 47 2   0 1     0   1   28 23     35.0   0.0     *   5.0   51 0 47 2   0 1     0   1   28 23     35 0     5   51
1722815 1722815 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 School No Middle 05 08 2021   grade_7 0 0 1   1 0     0   1   1 2     *   *     *   *   3 0 0 1   1 0     0   1   1 2                 3
1722909 1722909 MN Crow Wing 18 school 2706090 181 Independent Districts and Schools Brainerd Public School District 270609002982 21 Middle Level Alternative Program Public Area Learning Center ALC (State approved) Alternative School No Middle 05 08 2021   grade_7 3 0 0   0 0     0   0   2 1     *   *     *   *   3 3 0 0   0 0     0   0   2 1                 3
1722974 1722974 MN Itasca 31 school 2713170 318 Independent Districts and Schools Grand Rapids Public School District 271317000940 375 Middle Area Learning Center Public Area Learning Center ALC (State approved) Alternative School No Middle 05 08 2021   grade_7 27 0 0   3 0     0   2   16 16     0.0   0.0     16.0   *   32 27 0 0   3 0     0   2   16 16     0 0   16     32
1723066 1723066 MN Otter Tail 56 school 2711880 544 Independent Districts and Schools Fergus Falls Public School District 271188001021 370 Fergus Falls Area Learning Center Public Area Learning Center ALC (State approved) Alternative School No High 05 12 2021   grade_7 8 1 1   0 0     0   2   4 8     0.0   0.0     8.0   1.0   12 8 1 1   0 0     0   2   4 8     0 0   8 1   12
1723308 1723308 MN Mower 50 school 2700327 6083 Special Education Cooperatives Southern MN Education Consortium 270032704978 50 SMEC ALC Public Area Learning Center ALC (State approved) Alternative School No High 05 12 2021   grade_7 2 0 0   0 0     0   0   2 0     *   *     *   *   2 2 0 0   0 0     0   0   2 0                 2
1723986 1723986 MN Ramsey 62 school 2702264 916 Intermediate Districts and Schools Northeast Metro 916 270226402108 56 South Campus Education Center Special Education Special Education School No High 05 12 2021   grade_7 0 2 0   0 0     0   0   1 1     *   *     *   *   2 0 2 0   0 0     0   0   1 1                 2
1724130 1724130 MN Otter Tail 56 school 2700043 935 Special Education Cooperatives Fergus Falls Area Special Education Cooperative 270004304316 14 Fergus Falls Elementary Sp Ed 5-8 Special Education Special Education School No Middle 05 08 2021   grade_7 2 0 0   0 0     0   0   2 0     *   *     *   *   2 2 0 0   0 0     0   0   2 0                 2
1724282 1724282 MN Wright 86 school 2700413 6090 Special Education Cooperatives Sherburne and Northern Wright Special Education Cooperative 270041305259 82 Foundations II Special Education Special Education School No Middle 05 09 2021   grade_7 4 0 0   0 0     0   0   3 1     *   *     *   *   4 4 0 0   0 0     0   0   3 1                 4
1724583 1724583 MN Benton 5 school 2700071 6383 Education Districts Benton-Stearns Education District 270007102403 10 Benton-Stearns Education District Special Education Special Education School No High 05 12 2021   grade_7 3 1 0   1 0     0   0   5 0     *   *     *   *   5 3 1 0   1 0     0   0   5 0                 5

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