enrollments

Data source: Big Local News · About: Big Local

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

✎ 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
1711653 1711653 MN Aitkin 1 school 2702760 1 Independent Districts and Schools Aitkin Public School District 270276000057 1 Aitkin Secondary School Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 85 1 1   1 2     0   3   42 51     1.0   0.0     29.0   16.0   93 85 1 1   1 2     0   3   42 51     1 0   29 16   93
1719100 1719100 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124000942 106 Barton Open Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 08 2021   grade_7 37 32 5   1 0     0   0   35 40     9.0   0.0     31.0   8.0   75 37 32 5   1 0     0   0   35 40     9 0   31 8   75
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
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
1719213 1719213 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124001031 160 Seward Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 08 2021   grade_7 34 44 5   4 2     0   4   43 50     9.0   0.0     56.0   5.0   93 34 44 5   4 2     0   4   43 50     9 0   56 5   93
1719251 1719251 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124001866 175 Folwell Arts Magnet Elementary School (Grades PK-6) Regular School No Elementary PK 08 2021   grade_7 8 20 49   6 2     0   2   38 49     34.0   1.0     77.0   15.0   87 8 20 49   6 2     0   2   38 49     34 1   77 15   87
1719263 1719263 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124000986 179 Jefferson Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 08 2021   grade_7 0 13 20   3 1     0   1   20 18     13.0   1.0     32.0   11.0   38 0 13 20   3 1     0   1   20 18     13 1   32 11   38
1719282 1719282 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124000932 190 Andersen Community Elementary School (Grades PK-6) Regular School No Elementary PK 08 2021   grade_7 2 22 54   2 0     0   2   39 43     45.0   4.0     73.0   21.0   82 2 22 54   2 0     0   2   39 43     45 4   73 21   82
1719294 1719294 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124002297 193 Sullivan Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 08 2021   grade_7 1 37 3   6 0     0   1   24 24     13.0   0.0     *   11.0   48 1 37 3   6 0     0   1   24 24     13 0     11   48
1719321 1719321 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 2021   grade_7 32 33 6   5 4     0   0   44 36     8.0   0.0     42.0   15.0   80 32 33 6   5 4     0   0   44 36     8 0   42 15   80
1719397 1719397 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124004239 291 Hmong International Academy Elementary School (Grades PK-6) Regular School No Elementary PK 08 2021   grade_7 0 28 6   1 13     0   1   21 28     19.0   2.0     40.0   12.0   49 0 28 6   1 13     0   1   21 28     19 2   40 12   49
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
1721502 1721502 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 2021   grade_7 136 50 19   0 8     0   9   116 106     23.0   0.0     79.0   30.0   222 136 50 19   0 8     0   9   116 106     23 0   79 30   222
1721506 1721506 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124000937 309 Anwatin Middle Com & Spanish D I Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 39 69 62   3 13     0   4   95 95     39.0   1.0     109.0   29.0   190 39 69 62   3 13     0   4   95 95     39 1   109 29   190
1721510 1721510 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 2021   grade_7 42 52 29   10 3     0   3   76 63     19.0   2.0     93.0   34.0   139 42 52 29   10 3     0   3   76 63     19 2   93 34   139
1721514 1721514 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 2021   grade_7 16 77 13   2 12     0   8   60 68     10.0   1.0     86.0   31.0   128 16 77 13   2 12     0   8   60 68     10 1   86 31   128
1721518 1721518 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124004574 323 Justice Page Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 135 70 52   1 6     0   6   126 144     47.0   0.0     113.0   38.0   270 135 70 52   1 6     0   6   126 144     47 0   113 38   270
1721522 1721522 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124001028 324 Sanford Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 143 76 52   17 8     0   13   166 143     39.0   0.0     161.0   54.0   309 143 76 52   17 8     0   13   166 143     39 0   161 54   309
1721526 1721526 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124004882 327 Franklin Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 0 68 20   4 0     1   2   52 43     11.0   3.0     82.0   27.0   95 0 68 20   4 0     1   2   52 43     11 3   82 27   95
1723875 1723875 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124003022 625 River Bend Educational Center Special Education Special Education School No Other KG 12 2021   grade_7 1 12 0   1 0     0   0   13 1     0.0   0.0     11.0   *   14 1 12 0   1 0     0   0   13 1     0 0   11     14
1724669 1724669 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124001935 688 MPS Metro HA Hospital/Medical/Partial Hospitalization Program Alternative School No Other KG 12 2021   grade_7 1 1 0   0 0     0   0   0 2     *   *     *   *   2 1 1 0   0 0     0   0   0 2                 2
1725134 1725134 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124001933 685 Stadium View Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No High 06 12 2021   grade_7 0 1 0   0 0     0   0   0 1     *   *     *   *   1 0 1 0   0 0     0   0   0 1                 1
1725341 1725341 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124001936 689 MPS Metro SJ Educational Oversight to Public Care and Treatment Day Program Alternative School No Other KG 12 2021   grade_7 1 1 1   0 0     0   1   1 3     *   *     *   *   4 1 1 1   0 0     0   1   1 3                 4
1725472 1725472 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124001903 361 Center School Private Alternative Program Alternative School No High 07 12 2021   grade_7 0 0 0   2 0     0   0   1 1     *   *     *   *   2 0 0 0   2 0     0   0   1 1                 2
1711759 1711759 MN Carlton 9 school 2744190 100 Independent Districts and Schools Wrenshall Public School District 274419001843 2 Wrenshall Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 29 0 1   1 0     0   2   18 15     0.0   0.0     18.0   7.0   33 29 0 1   1 0     0   2   18 15     0 0   18 7   33
1720728 1720728 MN Carver 10 school 2723910 108 Independent Districts and Schools Central Public School District 272391002507 30 Central Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 50 2 6   1 1     0   4   36 28     0.0   0.0     12.0   6.0   64 50 2 6   1 1     0   4   36 28     0 0   12 6   64
1720648 1720648 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000117 3 Anoka Middle School For The Arts Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 398 77 48   1 32     0   43   307 292     26.0   3.0     185.0   87.0   599 398 77 48   1 32     0   43   307 292     26 3   185 87   599
1720652 1720652 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000099 4 Coon Rapids Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 281 106 40   6 37     1   58   258 271     35.0   19.0     248.0   91.0   529 281 106 40   6 37     1   58   258 271     35 19   248 91   529
1720656 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
1720660 1720660 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000119 90 Northdale Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 249 56 30   2 41     2   35   216 199     24.0   7.0     118.0   46.0   415 249 56 30   2 41     2   35   216 199     24 7   118 46   415
1720664 1720664 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 2021   grade_7 331 17 13   3 16     0   24   226 178     9.0   4.0     65.0   *   404 331 17 13   3 16     0   24   226 178     9 4   65     404
1720668 1720668 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000122 195 Roosevelt Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 186 27 8   1 24     0   25   137 134     *   3.0     64.0   *   271 186 27 8   1 24     0   25   137 134       3   64     271
1722801 1722801 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318002974 812 Compass-Bell Center Public Area Learning Center ALC (State approved) Alternative School No High 06 12 2021   grade_7 0 0 0   0 0     0   1   0 1     *   *     *   *   1 0 0 0   0 0     0   1   0 1                 1
1723409 1723409 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000005 467 River Trail Learning Center at LO Jacob Special Education Special Education School No Other KG 12 2021   grade_7 16 1 0   0 0     0   4   18 3     0.0   *     *   *   21 16 1 0   0 0     0   4   18 3     0           21
1720732 1720732 MN Carver 10 school 2741460 110 Independent Districts and Schools Waconia Public School District 274146003066 220 Waconia Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 277 5 14   1 2     0   9   160 148     2.0   1.0     13.0   46.0   308 277 5 14   1 2     0   9   160 148     2 1   13 46   308
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
1720741 1720741 MN Carver 10 school 2708190 112 Independent Districts and Schools Eastern Carver County Public Schools 270819000345 61 Chaska Middle School East Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 137 7 8   0 2     0   8   83 79     3.0   0.0     15.0   14.0   162 137 7 8   0 2     0   8   83 79     3 0   15 14   162
1720745 1720745 MN Carver 10 school 2708190 112 Independent Districts and Schools Eastern Carver County Public Schools 270819002798 62 Chaska Middle School West Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 214 8 35   1 16     0   13   136 151     11.0   0.0     46.0   38.0   287 214 8 35   1 16     0   13   136 151     11 0   46 38   287
1720749 1720749 MN Carver 10 school 2708190 112 Independent Districts and Schools Eastern Carver County Public Schools 270819003180 63 Pioneer Ridge Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 127 12 11   0 11     0   10   78 93     9.0   0.0     37.0   28.0   171 127 12 11   0 11     0   10   78 93     9 0   37 28   171
1722882 1722882 MN Carver 10 school 2708190 112 Independent Districts and Schools Eastern Carver County Public Schools 270819004622 66 112 ALC Middle School Public Area Learning Center ALC (State approved) Alternative School No Middle 06 08 2021   grade_7 45 8 28   0 2     0   10   44 49     12.0   0.0     47.0   9.0   93 45 8 28   0 2     0   10   44 49     12 0   47 9   93
1711766 1711766 MN Cass 11 school 2702910 113 Independent Districts and Schools Walker-Hackensack-Akeley School District 270291001737 20 Walker-Hackensack-Akeley Sec. Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 30 1 0   11 0     0   7   32 17     0.0   1.0     28.0   7.0   49 30 1 0   11 0     0   7   32 17     0 1   28 7   49
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
1711773 1711773 MN Cass 11 school 2730870 118 Independent Districts and Schools Northland Community Schools 273087001308 20 Northland Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 15 0 1   10 0     0   0   7 19     *   *     *   *   26 15 0 1   10 0     0   0   7 19                 26
1724969 1724969 MN Cass 11 school 2730870 118 Independent Districts and Schools Northland Community Schools 273087003507 40 Little Sand Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No High 07 12 2021   grade_7 0 0 0   1 0     0   1   0 2     *   *     *   *   2 0 0 0   1 0     0   1   0 2                 2
1720672 1720672 MN Anoka 2 school 2708100 12 Independent Districts and Schools Centennial Public School District 270810002784 166 Centennial Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 379 39 35   0 31     2   30   247 269     21.0   2.0     71.0   87.0   516 379 39 35   0 31     2   30   247 269     21 2   71 87   516
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
1720676 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
1720768 1720768 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 06 08 2021   grade_7 140 0 10   1 4     0   7   80 82     3.0   0.0     34.0   24.0   162 140 0 10   1 4     0   7   80 82     3 0   34 24   162
1724741 1724741 MN Chisago 13 school 2723820 138 Independent Districts and Schools North Branch Public Schools 272382002633 70 Distance Learning Program Distance Learning Program OLL (State approved) Regular School No Other KG 12 2021   grade_7 40 0 2   0 5     0   0   22 25     3.0   0.0     5.0   2.0   47 40 0 2   0 5     0   0   22 25     3 0   5 2   47
1711780 1711780 MN Chisago 13 school 2732550 139 Independent Districts and Schools Rush City Public School District 273255001406 20 Rush City Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 47 1 2   1 1     0   5   29 28     0.0   0.0     16.0   9.0   57 47 1 2   1 1     0   5   29 28     0 0   16 9   57
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
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
1711787 1711787 MN Clay 14 school 2703660 146 Independent Districts and Schools Barnesville Public School District 270366000170 40 Barnesville Secondary Secondary School (Grades 7-12) Regular School No High 06 12 2021   grade_7 64 2 0   2 0     0   4   39 33     0.0   0.0     15.0   6.0   72 64 2 0   2 0     0   4   39 33     0 0   15 6   72
1720685 1720685 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 2021   grade_7 233 2 14   2 15     0   15   127 154     4.0   2.0     69.0   33.0   281 233 2 14   2 15     0   15   127 154     4 2   69 33   281
1722820 1722820 MN Anoka 2 school 2733540 15 Independent Districts and Schools St. Francis Area Schools 273354004980 18 Saints Academy Public Area Learning Center ALC (State approved) Alternative School No High 07 12 2021   grade_7 31 0 2   0 2     0   4   23 16     *   *     *   *   39 31 0 2   0 2     0   4   23 16                 39
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
1711794 1711794 MN Clay 14 school 2713560 150 Independent Districts and Schools Hawley Public School District 271356000699 20 Hawley Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 60 1 2   0 1     0   2   37 29     0.0   0.0     6.0   6.0   66 60 1 2   0 1     0   2   37 29     0 0   6 6   66
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
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
1711667 1711667 MN Anoka 2 school 2733330 16 Independent Districts and Schools Spring Lake Park Public Schools 273333004658 788 Secondary Lighthouse Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 11 1 0   0 0     0   0   6 6     0.0   0.0     1.0   0.0   12 11 1 0   0 0     0   0   6 6     0 0   1 0   12
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
1723888 1723888 MN Rice 66 school 2700129 160 State Operated Schools (which include MN Academy Deaf & Blind, School for the Arts) Minnesota State Academies 270012903056 1 MN Academy For The Blind Special Education Special Education School No Other PK 12 2021   grade_7 2 0 1   0 0     0   0   2 1     *   *     *   *   3 2 0 1   0 0     0   0   2 1                 3
1723903 1723903 MN Rice 66 school 2700129 160 State Operated Schools (which include MN Academy Deaf & Blind, School for the Arts) Minnesota State Academies 270012902409 2 MN Academy For The Deaf Special Education Special Education School No Other PK 12 2021   grade_7 5 0 0   0 0     0   0   3 2     *   *     *   *   5 5 0 0   0 0     0   0   3 2                 5
1711801 1711801 MN Clearwater 15 school 2703570 162 Independent Districts and Schools Bagley Public School District 270357000165 20 Bagley Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 54 0 0   11 0     0   8   32 41     *   0.0     38.0   10.0   73 54 0 0   11 0     0   8   32 41       0   38 10   73
1720777 1720777 MN Cook 16 school 2713110 166 Independent Districts and Schools Cook County Public Schools 271311002635 40 Cook County Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 22 0 2   4 0     0   2   16 14     0.0   0.0     7.0   7.0   30 22 0 2   4 0     0   2   16 14     0 0   7 7   30
1711808 1711808 MN Cottonwood 17 school 2723010 173 Independent Districts and Schools Mountain Lake Public Schools 272301001135 20 Mountain Lake Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 17 0 11   0 10     0   0   18 20     0.0   0.0     21.0   8.0   38 17 0 11   0 10     0   0   18 20     0 0   21 8   38
1720781 1720781 MN Cottonwood 17 school 2742780 177 Independent Districts and Schools Windom Public School District 274278003068 60 Windom Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 61 1 13   0 2     0   2   44 35     4.0   0.0     27.0   17.0   79 61 1 13   0 2     0   2   44 35     4 0   27 17   79
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
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
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
1711815 1711815 MN Crow Wing 18 school 2709750 182 Independent Districts and Schools Crosby-Ironton Public School District 270975000417 1 Crosby-Ironton Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 76 0 0   0 1     0   6   47 36     0.0   0.0     27.0   20.0   83 76 0 0   0 1     0   6   47 36     0 0   27 20   83
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
1720795 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
1720799 1720799 MN Dakota 19 school 2707290 191 Independent Districts and Schools Burnsville Public School District 270729000297 85 Joseph Nicollet Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 63 49 28   0 13     0   10   96 67     14.0   3.0     72.0   44.0   163 63 49 28   0 13     0   10   96 67     14 3   72 44   163
1722913 1722913 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 School No High 06 12 2021   grade_7 41 74 64   3 22     0   17   103 118     66.0   0.0     132.0   15.0   221 41 74 64   3 22     0   17   103 118     66 0   132 15   221
1720803 1720803 MN Dakota 19 school 2711820 192 Independent Districts and Schools Farmington Public School District 271182000570 30 Levi P. Dodge Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 210 11 19   5 17     0   13   151 124     13.0   0.0     44.0   37.0   275 210 11 19   5 17     0   13   151 124     13 0   44 37   275
1720807 1720807 MN Dakota 19 school 2711820 192 Independent Districts and Schools Farmington Public School District 271182002983 60 Robert Boeckman Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 232 13 19   1 13     0   12   141 149     11.0   0.0     47.0   44.0   290 232 13 19   1 13     0   12   141 149     11 0   47 44   290
1720811 1720811 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 2021   grade_7 226 6 13   0 11     1   14   133 138     *   *     24.0   40.0   271 226 6 13   0 11     1   14   133 138           24 40   271
1720815 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
1720819 1720819 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 2021   grade_7 190 10 10   2 14     0   15   116 125     *   1.0     *   *   241 190 10 10   2 14     0   15   116 125       1         241
1724755 1724755 MN Dakota 19 school 2717780 194 Independent Districts and Schools Lakeville Public School District 271778004309 90 Link12 Lakeville Distance Learning Program OLL (State approved) Regular School No Other KG 12 2021   grade_7 74 14 18   0 21     0   13   62 78     *   0.0     *   *   140 74 14 18   0 21     0   13   62 78       0         140
1711822 1711822 MN Dakota 19 school 2730150 195 Independent Districts and Schools Randolph Public School District 273015001287 20 Randolph Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 50 0 2   0 0     0   1   34 19     0.0   2.0     8.0   11.0   53 50 0 2   0 0     0   1   34 19     0 2   8 11   53
1720823 1720823 MN Dakota 19 school 2732390 196 Independent Districts and Schools Rosemount-Apple Valley-Eagan 273239000484 25 Dakota Hills Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 255 23 46   3 59     1   19   219 187     18.0   *     39.0   41.0   406 255 23 46   3 59     1   19   219 187     18     39 41   406
1720827 1720827 MN Dakota 19 school 2732390 196 Independent Districts and Schools Rosemount-Apple Valley-Eagan 273239002437 32 Black Hawk Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 123 55 31   2 31     0   22   131 133     21.0   0.0     59.0   45.0   264 123 55 31   2 31     0   22   131 133     21 0   59 45   264
1720831 1720831 MN Dakota 19 school 2732390 196 Independent Districts and Schools Rosemount-Apple Valley-Eagan 273239001381 39 Rosemount Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 325 33 24   1 16     0   24   211 212     15.0   0.0     *   40.0   423 325 33 24   1 16     0   24   211 212     15 0     40   423
1720835 1720835 MN Dakota 19 school 2732390 196 Independent Districts and Schools Rosemount-Apple Valley-Eagan 273239002644 86 Falcon Ridge Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 182 52 52   2 25     3   24   189 151     23.0   *     79.0   43.0   340 182 52 52   2 25     3   24   189 151     23     79 43   340
1720839 1720839 MN Dakota 19 school 2732390 196 Independent Districts and Schools Rosemount-Apple Valley-Eagan 273239001943 93 Scott Highlands Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 256 45 33   1 45     0   26   195 211     *   0.0     63.0   45.0   406 256 45 33   1 45     0   26   195 211       0   63 45   406
1720843 1720843 MN Dakota 19 school 2732390 196 Independent Districts and Schools Rosemount-Apple Valley-Eagan 273239001383 98 Valley Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 172 99 45   0 12     0   31   189 170     28.0   0.0     95.0   49.0   359 172 99 45   0 12     0   31   189 170     28 0   95 49   359
1723498 1723498 MN Dakota 19 school 2732390 196 Independent Districts and Schools Rosemount-Apple Valley-Eagan 273239002517 100 Dakota Ridge School Special Education Special Education School No Other KG 12 2021   grade_7 5 3 1   1 1     0   3   12 2     *   1.0     *   *   14 5 3 1   1 1     0   3   12 2       1         14
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
1720857 1720857 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 2021   grade_7 108 24 77   2 17     0   22   132 118     30.0   0.0     104.0   40.0   250 108 24 77   2 17     0   22   132 118     30 0   104 40   250
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
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
1711830 1711830 MN Dodge 20 school 2713590 203 Independent Districts and Schools Hayfield Public School District 271359000702 1 HAYFIELD SECONDARY Secondary School (Grades 7-12) Regular School No High 06 12 2021   grade_7 51 0 6   0 0     0   2   25 34     0.0   0.0     16.0   9.0   59 51 0 6   0 0     0   2   25 34     0 0   16 9   59
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
1720871 1720871 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 Middle 06 08 2021   grade_7 323 2 15   0 1     0   7   183 165     1.0   2.0     80.0   49.0   348 323 2 15   0 1     0   7   183 165     1 2   80 49   348
1712599 1712599 MN Blue Earth 7 school 2791445 2071 Independent Districts and Schools Lake Crystal-Wellcome Memorial 279144502312 30 LK CRYSTAL-WELLCOME MEMORIAL SECONDARY Secondary School (Grades 7-12) Regular School No High 06 12 2021   grade_7 67 1 4   1 0     0   3   40 36     0.0   1.0     14.0   14.0   76 67 1 4   1 0     0   3   40 36     0 1   14 14   76
1721405 1721405 MN Dodge 20 school 2740665 2125 Independent Districts and Schools Triton School District 274066500035 2 Triton Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 60 1 22   0 1     0   3   43 44     4.0   0.0     28.0   11.0   87 60 1 22   0 1     0   3   43 44     4 0   28 11   87

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