Data source: Big Local News · About: Big Local

713 rows where grade = "grade_6", state = "MN" and year = 2021 sorted by district_state_id

View and edit SQL

year

  • 2021 · 713

grade

  • grade_6 · 713
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
1713216 MN Aitkin 1 school 2702760 1 Independent Districts and Schools Aitkin Public School District 270276000059 2 Rippleside Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2021   grade_6 75 0 0   1 0     0   2   48 30     0.0   0.0     32.0   14.0   78 75 0 0   1 0     0   2   48 30     0 0   32 14   78
1719099 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_6 25 30 5   0 1     0   2   27 36     7.0   0.0     32.0   8.0   63 25 30 5   0 1     0   2   27 36     7 0   32 8   63
1719120 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_6 88 5 4   0 10     0   5   64 48     2.0   0.0     10.0   18.0   112 88 5 4   0 10     0   5   64 48     2 0   10 18   112
1719141 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_6 36 15 7   0 3     0   4   34 31     3.0   *     29.0   9.0   65 36 15 7   0 3     0   4   34 31     3     29 9   65
1719212 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_6 45 39 3   3 1     0   0   43 48     *   0.0     44.0   10.0   91 45 39 3   3 1     0   0   43 48       0   44 10   91
1719250 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_6 9 28 36   1 0     0   2   33 43     26.0   1.0     66.0   14.0   76 9 28 36   1 0     0   2   33 43     26 1   66 14   76
1719262 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_6 2 21 29   0 2     0   4   28 30     15.0   1.0     49.0   *   58 2 21 29   0 2     0   4   28 30     15 1   49     58
1719281 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_6 5 22 47   4 0     0   3   50 31     *   4.0     *   20.0   81 5 22 47   4 0     0   3   50 31       4     20   81
1719293 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_6 2 37 2   3 0     0   1   25 20     12.0   4.0     40.0   12.0   45 2 37 2   3 0     0   1   25 20     12 4   40 12   45
1719320 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_6 33 32 7   1 1     0   5   38 41     7.0   0.0     41.0   11.0   79 33 32 7   1 1     0   5   38 41     7 0   41 11   79
1719396 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_6 1 29 3   0 24     0   2   34 25     *   1.0     48.0   11.0   59 1 29 3   0 24     0   2   34 25       1   48 11   59
1721497 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_6 71 11 2   0 4     0   19   60 47     1.0   0.0     22.0   17.0   107 71 11 2   0 4     0   19   60 47     1 0   22 17   107
1721501 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_6 112 60 29   0 9     0   15   111 114     21.0   0.0     91.0   21.0   225 112 60 29   0 9     0   15   111 114     21 0   91 21   225
1721505 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_6 41 49 71   4 5     0   8   91 87     33.0   1.0     106.0   39.0   178 41 49 71   4 5     0   8   91 87     33 1   106 39   178
1721509 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_6 37 64 26   11 4     0   12   74 80     23.0   7.0     111.0   39.0   154 37 64 26   11 4     0   12   74 80     23 7   111 39   154
1721513 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_6 12 86 12   3 7     1   13   71 63     9.0   0.0     105.0   32.0   134 12 86 12   3 7     1   13   71 63     9 0   105 32   134
1721517 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_6 127 52 58   4 6     2   7   149 107     41.0   2.0     140.0   37.0   256 127 52 58   4 6     2   7   149 107     41 2   140 37   256
1721521 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_6 157 73 41   26 8     0   31   169 167     30.0   5.0     181.0   51.0   336 157 73 41   26 8     0   31   169 167     30 5   181 51   336
1721525 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_6 3 87 19   2 2     0   3   66 50     12.0   1.0     89.0   23.0   116 3 87 19   2 2     0   3   66 50     12 1   89 23   116
1723874 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_6 0 10 0   1 0     0   0   10 1     2.0   0.0     9.0   *   11 0 10 0   1 0     0   0   10 1     2 0   9     11
1725340 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_6 1 1 1   0 1     0   0   3 1     *   *     *   *   4 1 1 1   0 1     0   0   3 1                 4
1713878 MN Carlton 9 school 2744190 100 Independent Districts and Schools Wrenshall Public School District 274419001842 1 Wrenshall Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2021   grade_6 35 0 2   0 1     0   0   19 19     0.0   0.0     16.0   13.0   38 35 0 2   0 1     0   0   19 19     0 0   16 13   38
1720727 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_6 58 1 5   0 0     0   5   33 36     3.0   0.0     12.0   10.0   69 58 1 5   0 0     0   5   33 36     3 0   12 10   69
1720647 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_6 386 75 29   9 25     0   52   309 267     23.0   5.0     183.0   98.0   576 386 75 29   9 25     0   52   309 267     23 5   183 98   576
1720651 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_6 243 99 37   3 55     1   49   249 238     32.0   10.0     237.0   99.0   487 243 99 37   3 55     1   49   249 238     32 10   237 99   487
1720655 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_6 291 98 53   5 87     0   52   299 287     49.0   5.0     187.0   91.0   586 291 98 53   5 87     0   52   299 287     49 5   187 91   586
1720659 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_6 285 65 41   2 42     0   41   236 240     25.0   9.0     150.0   83.0   476 285 65 41   2 42     0   41   236 240     25 9   150 83   476
1720663 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_6 311 23 20   0 6     0   25   197 188     *   5.0     67.0   *   385 311 23 20   0 6     0   25   197 188       5   67     385
1720667 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_6 199 11 7   1 15     0   17   141 109     *   *     45.0   *   250 199 11 7   1 15     0   17   141 109           45     250
1723408 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_6 6 3 1   1 0     0   1   10 2     0.0   *     7.0   *   12 6 3 1   1 0     0   1   10 2     0     7     12
1720731 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_6 267 7 9   2 3     0   4   142 150     2.0   1.0     20.0   55.0   292 267 7 9   2 3     0   4   142 150     2 1   20 55   292
1720736 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_6 121 0 3   0 1     0   6   68 63     1.0   0.0     21.0   23.0   131 121 0 3   0 1     0   6   68 63     1 0   21 23   131
1720740 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_6 147 5 5   0 7     0   8   94 78     1.0   *     18.0   19.0   172 147 5 5   0 7     0   8   94 78     1     18 19   172
1720744 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_6 177 6 40   0 12     1   14   131 119     9.0   *     51.0   30.0   250 177 6 40   0 12     1   14   131 119     9     51 30   250
1720748 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_6 108 10 10   0 10     0   10   74 74     2.0   0.0     30.0   27.0   148 108 10 10   0 10     0   10   74 74     2 0   30 27   148
1722881 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_6 36 11 10   0 2     0   3   34 28     8.0   0.0     20.0   2.0   62 36 11 10   0 2     0   3   34 28     8 0   20 2   62
1713983 MN Cass 11 school 2702910 113 Independent Districts and Schools Walker-Hackensack-Akeley School District 270291001736 10 W.H.A. Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2021   grade_6 30 0 1   16 1     0   3   28 23     0.0   5.0     24.0   14.0   51 30 0 1   16 1     0   3   28 23     0 5   24 14   51
1720753 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_6 2 0 1   71 0     0   5   43 36     0.0   0.0     56.0   20.0   79 2 0 1   71 0     0   5   43 36     0 0   56 20   79
1720758 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_6 81 1 3   0 0     0   3   56 32     0.0   1.0     42.0   19.0   88 81 1 3   0 0     0   3   56 32     0 1   42 19   88
1714007 MN Cass 11 school 2730870 118 Independent Districts and Schools Northland Community Schools 273087001307 10 Northland Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2021   grade_6 9 0 0   8 0     0   0   7 10     0.0   0.0     13.0   5.0   17 9 0 0   8 0     0   0   7 10     0 0   13 5   17
1720671 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_6 389 25 36   3 37     0   29   267 252     16.0   6.0     75.0   90.0   519 389 25 36   3 37     0   29   267 252     16 6   75 90   519
1724942 MN Anoka 2 school 2708100 12 Independent Districts and Schools Centennial Public School District 270810004656 159 Pines School - NSP Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No High 06 12 2021   grade_6 1 0 0   0 0     0   0   1 0     *   *     *   *   1 1 0 0   0 0     0   0   1 0                 1
1724948 MN Anoka 2 school 2708100 12 Independent Districts and Schools Centennial Public School District 270810004620 161 Pines School - RJC Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No High 06 12 2021   grade_6 0 1 0   0 0     0   0   1 0     *   *     *   *   1 0 1 0   0 0     0   0   1 0                 1
1720764 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_6 77 0 20   5 1     1   3   57 50     7.0   1.0     50.0   22.0   107 77 0 20   5 1     1   3   57 50     7 1   50 22   107
1720675 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_6 31 62 89   1 11     0   13   107 100     *   *     *   *   207 31 62 89   1 11     0   13   107 100                 207
1725245 MN Anoka 2 school 2709510 13 Independent Districts and Schools Columbia Heights Public School District 270951005164 810 Columbia Academy Anchor Program Educational Oversight to Public Care and Treatment Day Program Alternative School No Middle 06 08 2021   grade_6 1 0 0   0 0     0   0   1 0     *   *     *   *   1 1 0 0   0 0     0   0   1 0                 1
1720767 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_6 124 1 4   0 5     0   6   62 78     1.0   0.0     18.0   25.0   140 124 1 4   0 5     0   6   62 78     1 0   18 25   140
1724740 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_6 34 0 2   0 4     0   0   26 14     2.0   0.0     6.0   4.0   40 34 0 2   0 4     0   0   26 14     2 0   6 4   40
1714031 MN Chisago 13 school 2732550 139 Independent Districts and Schools Rush City Public School District 273255001405 10 C.E. Jacobson Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2021   grade_6 72 0 0   0 0     0   2   45 29     0.0   1.0     25.0   11.0   74 72 0 0   0 0     0   2   45 29     0 1   25 11   74
1720680 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_6 62 93 31   4 14     0   17   117 104     21.0   3.0     137.0   35.0   221 62 93 31   4 14     0   17   117 104     21 3   137 35   221
1714039 MN Clay 14 school 2703660 146 Independent Districts and Schools Barnesville Public School District 270366000169 10 Barnesville Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 06 2021   grade_6 64 1 1   1 0     0   3   36 34     0.0   0.0     12.0   12.0   70 64 1 1   1 0     0   3   36 34     0 0   12 12   70
1720684 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_6 240 1 15   3 16     0   17   140 152     8.0   2.0     69.0   34.0   292 240 1 15   3 16     0   17   140 152     8 2   69 34   292
1724724 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_6 4 0 1   0 0     0   1   4 2     *   *     *   *   6 4 0 1   0 0     0   1   4 2                 6
1724953 MN Anoka 2 school 2733540 15 Independent Districts and Schools St. Francis Area Schools 273354005205 856 Crossroads School Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No Other KG 12 2021   grade_6 0 1 0   0 0     0   0   0 1     *   *     *   *   1 0 1 0   0 0     0   0   0 1                 1
1714047 MN Clay 14 school 2713560 150 Independent Districts and Schools Hawley Public School District 271356000698 10 Hawley Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2021   grade_6 71 0 4   1 0     0   0   44 32     *   *     *   *   76 71 0 4   1 0     0   0   44 32                 76
1714055 MN Clay 14 school 2713560 150 Independent Districts and Schools Hawley Public School District 271356002240 11 Spring Prairie Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 06 2021   grade_6 2 0 0   0 0     0   0   1 1     *   *     *   *   2 2 0 0   0 0     0   0   1 1                 2
1720772 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_6 389 55 51   11 6     0   34   272 274     27.0   5.0     172.0   92.0   546 389 55 51   11 6     0   34   272 274     27 5   172 92   546
1724976 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_6 1 0 0   0 0     0   0   1 0     *   *     *   *   1 1 0 0   0 0     0   0   1 0                 1
1724984 MN Clay 14 school 2721420 152 Independent Districts and Schools Moorhead Public School District 272142002799 970 West Central Academy-N Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No Other 03 12 2021   grade_6 1 0 0   0 0     0   0   1 0     *   *     *   *   1 1 0 0   0 0     0   0   1 0                 1
1713549 MN Anoka 2 school 2733330 16 Independent Districts and Schools Spring Lake Park Public Schools 273333004657 787 Elementary Lighthouse Elementary School (Grades PK-6) Regular School No Elementary 01 06 2021   grade_6 9 0 0   0 0     0   2   7 4     0.0   0.0     0.0   2.0   11 9 0 0   0 0     0   2   7 4     0 0   0 2   11
1720689 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_6 223 48 84   2 38     2   32   205 224     39.0   3.0     164.0   54.0   429 223 48 84   2 38     2   32   205 224     39 3   164 54   429
1723887 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_6 4 0 0   0 0     0   0   1 3     *   *     *   *   4 4 0 0   0 0     0   0   1 3                 4
1723902 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_6 0 1 0   0 0     0   0   0 1     *   *     *   *   1 0 1 0   0 0     0   0   0 1                 1
1714089 MN Clearwater 15 school 2703570 162 Independent Districts and Schools Bagley Public School District 270357000164 10 Bagley Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2021   grade_6 56 1 1   13 0     0   11   47 35     0.0   1.0     32.0   10.0   82 56 1 1   13 0     0   11   47 35     0 1   32 10   82
1720776 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_6 21 0 1   1 0     0   4   16 11     0.0   0.0     5.0   1.0   27 21 0 1   1 0     0   4   16 11     0 0   5 1   27
1714106 MN Cottonwood 17 school 2723010 173 Independent Districts and Schools Mountain Lake Public Schools 272301001134 10 Mountain Lake Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2021   grade_6 18 0 11   0 3     0   2   20 14     *   0.0     17.0   11.0   34 18 0 11   0 3     0   2   20 14       0   17 11   34
1720780 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_6 48 1 23   0 0     1   0   47 26     9.0   0.0     27.0   22.0   73 48 1 23   0 0     1   0   47 26     9 0   27 22   73
1720785 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_6 435 7 5   6 2     0   18   237 236     1.0   2.0     186.0   94.0   473 435 7 5   6 2     0   18   237 236     1 2   186 94   473
1722908 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_6 5 0 1   0 0     0   0   3 3     *   *     *   *   6 5 0 1   0 0     0   0   3 3                 6
1725228 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_6 6 0 0   1 0     0   0   7 0     *   *     *   *   7 6 0 0   1 0     0   0   7 0                 7
1714161 MN Crow Wing 18 school 2709750 182 Independent Districts and Schools Crosby-Ironton Public School District 270975000291 6 Cuyuna Range Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2021   grade_6 72 1 3   0 0     0   4   38 42     0.0   0.0     33.0   20.0   80 72 1 3   0 0     0   4   38 42     0 0   33 20   80
1720790 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_6 127 1 2   1 1     1   0   77 56     0.0   0.0     9.0   19.0   133 127 1 2   1 1     1   0   77 56     0 0   9 19   133
1720794 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_6 53 22 27   1 14     0   7   71 53     12.0   1.0     50.0   27.0   124 53 22 27   1 14     0   7   71 53     12 1   50 27   124
1720798 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_6 71 47 29   1 12     1   10   88 83     13.0   0.0     69.0   44.0   171 71 47 29   1 12     1   10   88 83     13 0   69 44   171
1722912 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_6 45 97 84   2 17     1   25   129 142     67.0   0.0     181.0   23.0   271 45 97 84   2 17     1   25   129 142     67 0   181 23   271
1720802 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_6 185 11 21   3 13     0   17   120 130     9.0   *     27.0   42.0   250 185 11 21   3 13     0   17   120 130     9     27 42   250
1720806 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_6 238 8 14   1 15     1   15   147 145     7.0   *     39.0   57.0   292 238 8 14   1 15     1   15   147 145     7     39 57   292
1720810 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_6 215 13 16   0 6     0   12   138 124     *   *     29.0   48.0   262 215 13 16   0 6     0   12   138 124           29 48   262
1720814 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_6 153 11 33   0 7     0   8   107 105     12.0   *     34.0   44.0   212 153 11 33   0 7     0   8   107 105     12     34 44   212
1720818 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_6 242 7 12   0 6     0   15   147 135     *   1.0     22.0   37.0   282 242 7 12   0 6     0   15   147 135       1   22 37   282
1724754 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_6 63 14 10   2 15     0   8   60 52     6.0   0.0     23.0   20.0   112 63 14 10   2 15     0   8   60 52     6 0   23 20   112
1714348 MN Dakota 19 school 2730150 195 Independent Districts and Schools Randolph Public School District 273015001286 10 Randolph Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2021   grade_6 67 1 0   1 0     0   0   28 41     0.0   0.0     8.0   12.0   69 67 1 0   1 0     0   0   28 41     0 0   8 12   69
1720822 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_6 235 31 33   2 60     0   27   206 182     13.0   *     47.0   46.0   388 235 31 33   2 60     0   27   206 182     13     47 46   388
1720826 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_6 150 69 25   2 33     0   27   158 148     16.0   0.0     72.0   60.0   306 150 69 25   2 33     0   27   158 148     16 0   72 60   306
1720830 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_6 291 23 36   0 29     0   28   216 191     *   0.0     *   46.0   407 291 23 36   0 29     0   28   216 191       0     46   407
1720834 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_6 190 50 49   1 24     0   28   169 173     26.0   0.0     65.0   55.0   342 190 50 49   1 24     0   28   169 173     26 0   65 55   342
1720838 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_6 243 45 29   2 55     0   40   215 199     15.0   0.0     55.0   71.0   414 243 45 29   2 55     0   40   215 199     15 0   55 71   414
1720842 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_6 165 84 51   2 15     0   30   164 183     24.0   0.0     98.0   59.0   347 165 84 51   2 15     0   30   164 183     24 0   98 59   347
1723497 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_6 3 1 0   1 0     0   1   5 1     *   *     *   *   6 3 1 0   1 0     0   1   5 1                 6
1720847 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_6 86 30 50   3 9     0   15   106 87     18.0   *     *   26.0   193 86 30 50   3 9     0   15   106 87     18       26   193
1720852 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_6 106 11 68   6 6     1   10   103 105     24.0   *     *   39.0   208 106 11 68   6 6     1   10   103 105     24       39   208
1720856 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_6 117 33 79   1 9     0   17   136 120     13.0   1.0     102.0   41.0   256 117 33 79   1 9     0   17   136 120     13 1   102 41   256
1720643 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_6 13 0 0   2 0     0   0   10 5     0.0   0.0     9.0   8.0   15 13 0 0   2 0     0   0   10 5     0 0   9 8   15
1720861 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_6 262 14 19   2 2     0   21   136 184     5.0   1.0     73.0   46.0   320 262 14 19   2 2     0   21   136 184     5 1   73 46   320
1711829 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_6 45 0 4   0 0     0   1   16 34     0.0   0.0     10.0   4.0   50 45 0 4   0 0     0   1   16 34     0 0   10 4   50
1720866 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_6 169 2 7   0 1     0   7   92 94     1.0   1.0     21.0   26.0   186 169 2 7   0 1     0   7   92 94     1 1   21 26   186
1720870 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_6 276 1 9   1 5     0   7   149 150     1.0   3.0     83.0   41.0   299 276 1 9   1 5     0   7   149 150     1 3   83 41   299
1712598 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_6 72 1 1   1 0     0   0   34 41     0.0   0.0     14.0   12.0   75 72 1 1   1 0     0   0   34 41     0 0   14 12   75
1721404 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_6 60 0 12   0 0     0   0   36 36     2.0   0.0     17.0   17.0   72 60 0 12   0 0     0   0   36 36     2 0   17 17   72
1714632 MN Douglas 21 school 2725140 213 Independent Districts and Schools Osakis Public School District 272514001203 10 Osakis Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2021   grade_6 59 0 2   1 0     0   1   37 26     0.0   0.0     16.0   16.0   63 59 0 2   1 0     0   1   37 26     0 0   16 16   63

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