enrollments

Data source: Big Local News · About: Big Local

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

✎ 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
1712778 1712778 MN Meeker 47 school 2700106 2396 Independent Districts and Schools A.C.G.C. Public School District 270010602570 300 A.C.G.C. Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 54 0 3   1 0     0   3   26 35     0.0   0.0     20.0   18.0   61 54 0 3   1 0     0   3   26 35     0 0   20 18   61
1719683 1719683 MN Ramsey 62 school 2700186 4074 Charter Schools AFSA High School 270018604854 20 AFSA Middle School Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2021   grade_7 24 2 4   0 1     0   3   16 18     0.0   0.0     11.0   9.0   34 24 2 4   0 1     0   3   16 18     0 0   11 9   34
1719673 1719673 MN Ramsey 62 school 2700185 4073 Charter Schools Academia Cesar Chavez Charter School 270018503138 10 Academia Cesar Chavez Charter School Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2021   grade_7 1 1 50   0 0     0   0   27 25     22.0   0.0     18.0   7.0   52 1 1 50   0 0     0   0   27 25     22 0   18 7   52
1719517 1719517 MN Ramsey 62 school 2700118 4018 Charter Schools Achieve Language Academy 270011802608 10 Achieve Language Academy Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2021   grade_7 6 4 20   0 15     0   1   25 21     *   0.0     21.0   4.0   46 6 4 20   0 15     0   1   25 21       0   21 4   46
1712857 1712857 MN Norman 54 school 2700126 2854 Independent Districts and Schools Ada-Borup Public School District 270012600051 30 Ada-Borup Secondary Secondary School (Grades 7-12) Regular School No High 06 12 2021   grade_7 47 0 8   2 0     0   7   29 35     1.0   0.0     25.0   11.0   64 47 0 8   2 0     0   7   29 35     1 0   25 11   64
1721088 1721088 MN Nobles 53 school 2702730 511 Independent Districts and Schools Adrian Public School District 270273003076 15 Adrian Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 29 0 4   0 0     0   3   23 13     2.0   0.0     9.0   4.0   36 29 0 4   0 0     0   3   23 13     2 0   9 4   36
1720251 1720251 MN Hennepin 27 school 2700394 4220 Charter Schools Agamim Classical Academy 270039404751 10 Agamim Classical Academy Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2021   grade_7 8 8 2   0 1     0   2   12 9     7.0   0.0     5.0   2.0   21 8 8 2   0 1     0   2   12 9     7 0   5 2   21
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
1721303 1721303 MN Stearns 73 school 2702930 745 Independent Districts and Schools Albany Public School District 270293000063 50 Albany Area Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 135 2 9   0 0     0   5   71 80     5.0   1.0     25.0   32.0   151 135 2 9   0 0     0   5   71 80     5 1   25 32   151
1720879 1720879 MN Freeborn 24 school 2702970 241 Independent Districts and Schools Albert Lea Public School District 270297000078 320 Southwest Middle Middle School (Grades 5-8) Regular School No Middle 06 07 2021   grade_7 165 7 72   0 21     0   8   149 124     *   *     *   *   273 165 7 72   0 21     0   8   149 124                 273
1722931 1722931 MN Freeborn 24 school 2702970 241 Independent Districts and Schools Albert Lea Public School District 270297002228 350 Albert Lea Area Learning Center Public Area Learning Center ALC (State approved) Alternative School No High 06 12 2021   grade_7 4 0 1   0 0     0   3   3 5     *   *     *   *   8 4 0 1   0 0     0   3   3 5                 8
1711865 1711865 MN Freeborn 24 school 2703030 242 Independent Districts and Schools Alden-Conger Public School District 270303000080 1 Alden-Conger Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 34 0 0   0 0     0   0   15 19     0.0   0.0     12.0   7.0   34 34 0 0   0 0     0   0   15 19     0 0   12 7   34
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
1721366 1721366 MN Wright 86 school 2703150 876 Independent Districts and Schools Annandale Public School District 270315000093 2 Annandale Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 145 1 3   0 0     0   12   75 86     0.0   0.0     21.0   19.0   161 145 1 3   0 0     0   12   75 86     0 0   21 19   161
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
1713060 1713060 MN Rice 66 school 2700355 4091 Charter Schools Arcadia Charter School 270035504151 10 Arcadia Charter School Secondary School (Grades 7-12) Regular School Yes High 06 12 2021   grade_7 9 0 2   0 0     0   1   8 4     0.0   0.0     4.0   5.0   12 9 0 2   0 0     0   1   8 4     0 0   4 5   12
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
1711894 1711894 MN Grant 26 school 2703300 261 Independent Districts and Schools Ashby Public School District 270330000137 20 Ashby Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 22 0 0   1 0     0   0   10 13     0.0   0.0     9.0   2.0   23 22 0 0   1 0     0   0   10 13     0 0   9 2   23
1720062 1720062 MN Scott 70 school 2700311 4184 Charter Schools Aspen Academy 270031104282 10 Aspen Academy Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2021   grade_7 25 6 0   0 2     0   1   19 15     2.0   0.0     4.0   5.0   34 25 6 0   0 2     0   1   19 15     2 0   4 5   34
1720395 1720395 MN Stearns 73 school 2700430 4250 Charter Schools Athlos Academy of Saint Cloud 270043004959 10 Athlos Academy of Saint Cloud Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2021   grade_7 13 18 6   0 0     0   2   14 25     9.0   1.0     17.0   7.0   39 13 18 6   0 0     0   2   14 25     9 1   17 7   39
1719471 1719471 MN Hennepin 27 school 2700096 4011 Charter Schools Athlos Leadership Academy 270009601892 10 Athlos Leadership Academy Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2021   grade_7 5 50 10   0 1     0   12   37 41     3.0   2.0     43.0   8.0   78 5 50 10   0 1     0   12   37 41     3 2   43 8   78
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
1720488 1720488 MN Beltrami 4 school 2700455 4271 Charter Schools Aurora Waasakone Community of Learners Charter School 270045505196 10 Aurora Waasakone Community of Learners Charter School Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2021   grade_7 6 0 0   2 0     0   1   7 2     *   *     *   *   9 6 0 0   2 0     0   1   7 2                 9
1724305 1724305 MN Mower 50 school 2700426 6095 Special Education Cooperatives Austin Albert Lea Area Special Education Cooperative (AALASEC) 270042605016 550 Oakland Education Center Special Education Special Education School No Other KG 12 2021   grade_7 2 1 1   0 0     0   3   5 2     *   *     *   *   7 2 1 1   0 0     0   3   5 2                 7
1721065 1721065 MN Mower 50 school 2703450 492 Independent Districts and Schools Austin Public School District 270345000150 300 Ellis Middle Middle School (Grades 5-8) Regular School No Middle 07 08 2021   grade_7 201 34 133   0 34     8   10   210 210     79.0   1.0     200.0   64.0   420 201 34 133   0 34     8   10   210 210     79 1   200 64   420
1723036 1723036 MN Mower 50 school 2703450 492 Independent Districts and Schools Austin Public School District 270345002231 150 Austin Area Learning Center Public Area Learning Center ALC (State approved) Alternative School No High 06 12 2021   grade_7 6 2 5   0 3     0   0   8 8     0.0   0.0     11.0   0.0   16 6 2 5   0 3     0   0   8 8     0 0   11 0   16
1721552 1721552 MN Ramsey 62 school 2700187 4075 Charter Schools Avalon School 270018704664 20 Avalon Middle School Middle School (Grades 5-8) Regular School Yes Middle 06 08 2021   grade_7 23 0 2   0 1     0   3   19 10     2.0   0.0     2.0   10.0   29 23 0 2   0 1     0   3   19 10     2 0   2 10   29
1712339 1712339 MN Roseau 68 school 2703540 676 Independent Districts and Schools Badger Public School District 270354000163 20 Badger Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 15 0 0   0 0     0   1   12 4     0.0   0.0     3.0   3.0   16 15 0 0   0 0     0   1   12 4     0 0   3 3   16
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
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
1711723 1711723 MN Carlton 9 school 2703690 91 Independent Districts and Schools Barnum Public School District 270369000172 2 Barnum Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 57 0 3   0 0     0   8   29 39     0.0   0.0     19.0   9.0   68 57 0 3   0 0     0   8   29 39     0 0   19 9   68
1712179 1712179 MN Otter Tail 56 school 2703750 542 Independent Districts and Schools Battle Lake Public School District 270375000176 20 Battle Lake Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 30 0 1   0 0     0   3   17 17     0.0   0.0     10.0   4.0   34 30 0 1   0 0     0   3   17 17     0 0   10 4   34
1720300 1720300 MN Hennepin 27 school 2700396 4226 Charter Schools Bdote Learning Center 270039604763 10 Bdote Learning Center Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2021   grade_7 0 0 0   6 0     0   0   2 4     *   *     *   *   6 0 0 0   6 0     0   0   2 4                 6
1719830 1719830 MN Hennepin 27 school 2700366 4124 Charter Schools Beacon Academy 270036604110 10 Beacon Academy Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2021   grade_7 32 20 7   0 0     0   5   35 29     6.0   0.0     24.0   14.0   64 32 20 7   0 0     0   5   35 29     6 0   24 14   64
1721264 1721264 MN Sherburne 71 school 2703870 726 Independent Districts and Schools Becker Public School District 270387002556 30 Becker Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 190 2 8   1 2     0   10   104 109     1.0   0.0     35.0   25.0   213 190 2 8   1 2     0   10   104 109     1 0   35 25   213
1712763 1712763 MN Stearns 73 school 2700105 2364 Independent Districts and Schools Belgrade-Brooten-Elrosa Public School District 270010502567 2 Belgrade-Brooten-Elrosa Sec. Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 48 0 2   0 0     0   0   27 23     2.0   0.0     19.0   4.0   50 48 0 2   0 0     0   0   27 23     2 0   19 4   50
1725406 1725406 MN Scott 70 school 2704050 716 Independent Districts and Schools Belle Plaine Public School District 270405002169 30 Belle Plaine Junior High Junior High School (Grades 7-8 or 7-9) Regular School No Middle 07 08 2021   grade_7 100 2 6   1 1     1   0   59 52     *   0.0     *   17.0   111 100 2 6   1 1     1   0   59 52       0     17   111
1720698 1720698 MN Beltrami 4 school 2704440 31 Independent Districts and Schools Bemidji Public School District 270444002031 15 Bemidji Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 258 4 4   121 0     0   12   217 182     0.0   10.0     142.0   67.0   399 258 4 4   121 0     0   12   217 182     0 10   142 67   399
1723438 1723438 MN Beltrami 4 school 2704440 31 Independent Districts and Schools Bemidji Public School District 270444004194 70 Lakeside Learning Center Special Education Special Education School No High 06 12 2021   grade_7 0 0 0   1 0     0   0   1 0     *   *     *   *   1 0 0 0   1 0     0   0   1 0                 1
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
1724966 1724966 MN Beltrami 4 school 2704440 31 Independent Districts and Schools Bemidji Public School District 270444004315 190 Oshki Manidoo Center Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No High 07 12 2021   grade_7 0 0 0   1 0     0   0   1 0     *   *     *   *   1 0 0 0   1 0     0   0   1 0                 1
1712451 1712451 MN Swift 76 school 2704470 777 Independent Districts and Schools Benson Public School District 270447000199 101 Benson Secondary Secondary School (Grades 7-12) Regular School No High 06 12 2021   grade_7 61 0 7   0 1     0   1   44 26     2.0   0.0     27.0   16.0   70 61 0 7   0 1     0   1   44 26     2 0   27 16   70
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
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
1712458 1712458 MN Todd 77 school 2705430 786 Independent Districts and Schools Bertha-Hewitt Public School District 270543000204 20 Bertha Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 38 1 0   0 0     0   2   20 21     0.0   0.0     16.0   7.0   41 38 1 0   0 0     0   2   20 21     0 0   16 7   41
1720125 1720125 MN Hennepin 27 school 2700309 4192 Charter Schools Best Academy 270030904261 10 Best Academy Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2021   grade_7 0 73 1   0 0     0   2   48 28     14.0   3.0     *   11.0   76 0 73 1   0 0     0   2   48 28     14 3     11   76
1721268 1721268 MN Sherburne 71 school 2705460 727 Independent Districts and Schools Big Lake Public School District 270546002462 30 Big Lake Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 190 11 13   3 6     0   14   124 113     3.0   1.0     46.0   25.0   237 190 11 13   3 6     0   14   124 113     3 1   46 25   237
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
1711681 1711681 MN Beltrami 4 school 2705730 32 Independent Districts and Schools Blackduck Public School District 270573000213 20 Blackduck Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 40 0 2   5 0     0   4   25 26     0.0   1.0     21.0   11.0   51 40 0 2   5 0     0   4   25 26     0 1   21 11   51
1712415 1712415 MN Steele 74 school 2705760 756 Independent Districts and Schools Blooming Prairie Public School Dist 270576000215 20 Blooming Prairie Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 53 0 3   0 0     0   0   27 29     0.0   0.0     19.0   6.0   56 53 0 3   0 0     0   0   27 29     0 0   19 6   56
1720887 1720887 MN Hennepin 27 school 2705790 271 Independent Districts and Schools Bloomington Public School District 270579000226 13 Oak Grove Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 112 38 28   0 15     0   16   111 98     19.0   1.0     83.0   35.0   209 112 38 28   0 15     0   16   111 98     19 1   83 35   209
1720891 1720891 MN Hennepin 27 school 2705790 271 Independent Districts and Schools Bloomington Public School District 270579000638 345 Valley View Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 79 73 115   4 24     0   18   166 147     53.0   5.0     197.0   40.0   313 79 73 115   4 24     0   18   166 147     53 5   197 40   313
1720895 1720895 MN Hennepin 27 school 2705790 271 Independent Districts and Schools Bloomington Public School District 270579000228 346 Olson Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 146 27 24   1 15     0   14   122 105     7.0   1.0     51.0   31.0   227 146 27 24   1 15     0   14   122 105     7 1   51 31   227
1721473 1721473 MN Faribault 22 school 2700130 2860 Independent Districts and Schools Blue Earth Area Public School 270013002497 23 Blue Earth Area Middle Middle School (Grades 5-8) Regular School No Middle 06 07 2021   grade_7 71 1 9   0 0     0   0   42 39     2.0   0.0     25.0   15.0   81 71 1 9   0 0     0   0   42 39     2 0   25 15   81
1724913 1724913 MN Hennepin 27 school 2700193 4082 Charter Schools BlueSky Charter School 270019303146 10 BlueSky Charter School Distance Learning Program OLL (State approved) Regular School Yes High 07 12 2021   grade_7 17 0 4   0 1     0   5   13 14     0.0   0.0     7.0   9.0   27 17 0 4   0 1     0   5   13 14     0 0   7 9   27
1719434 1719434 MN Winona 85 school 2705850 4001 Charter Schools Bluffview Montessori 270585000018 10 Bluffview Montessori Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2021   grade_7 17 0 1   0 0     0   2   8 12     1.0   0.0     7.0   3.0   20 17 0 1   0 0     0   2   8 12     1 0   7 3   20
1711935 1711935 MN Isanti 30 school 2706060 314 Independent Districts and Schools Braham Public School District 270606000247 1 Braham Area Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 58 1 3   0 0     0   6   32 36     0.0   0.0     28.0   5.0   68 58 1 3   0 0     0   6   32 36     0 0   28 5   68
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
1721493 1721493 MN Douglas 21 school 2700382 2908 Independent Districts and Schools Brandon-Evansville Public Schools 270038204740 3 Brandon-Evansville Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 35 0 1   0 0     0   0   20 16     0.0   0.0     12.0   1.0   36 35 0 1   0 0     0   0   20 16     0 0   12 1   36
1721357 1721357 MN Wilkin 84 school 2706150 846 Independent Districts and Schools Breckenridge Public School District 270615003005 20 Breckenridge Middle Middle School (Grades 5-8) Regular School No Middle 07 08 2021   grade_7 42 2 1   1 0     0   4   28 22     1.0   0.0     21.0   13.0   50 42 2 1   1 0     0   4   28 22     1 0   21 13   50
1720982 1720982 MN Hennepin 27 school 2706240 286 Independent Districts and Schools Brooklyn Center School District 270624005130 11 Brooklyn Center Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 7 53 33   1 19     0   4   55 62     24.0   2.0     99.0   19.0   117 7 53 33   1 19     0   4   55 62     24 2   99 19   117
1724769 1724769 MN Hennepin 27 school 2706240 286 Independent Districts and Schools Brooklyn Center School District 270624004306 221 Insight School of Minnesota Distance Learning Program OLL (State approved) Regular School No High 06 12 2021   grade_7 16 6 5   0 0     0   1   14 14     1.0   0.0     21.0   9.0   28 16 6 5   0 0     0   1   14 14     1 0   21 9   28
1712465 1712465 MN Todd 77 school 2706300 787 Independent Districts and Schools Browerville Public School District 270630000278 20 Browerville Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 42 0 4   0 0     0   2   24 24     3.0   0.0     20.0   8.0   48 42 0 4   0 0     0   2   24 24     3 0   20 8   48
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
1712670 1712670 MN Renville 65 school 2700023 2159 Independent Districts and Schools Buffalo Lake-Hector-Stewart Public Schools 270002300704 20 Buffalo Lake-Hector Secondary Secondary School (Grades 7-12) Regular School No High 06 12 2021   grade_7 34 0 5   0 0     0   2   16 25     4.0   0.0     13.0   6.0   41 34 0 5   0 0     0   2   16 25     4 0   13 6   41
1721370 1721370 MN Wright 86 school 2707200 877 Independent Districts and Schools Buffalo-Hanover-Montrose Public Sch 270720000284 30 Buffalo Community Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 359 11 19   2 4     1   20   205 211     3.0   0.0     70.0   67.0   416 359 11 19   2 4     1   20   205 211     3 0   70 67   416
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
1712513 1712513 MN Watonwan 83 school 2707320 836 Independent Districts and Schools Butterfield Public School District 270732000305 30 Butterfield Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 6 0 9   0 0     0   0   5 10     8.0   *     10.0   *   15 6 0 9   0 0     0   0   5 10     8     10     15
1721097 1721097 MN Olmsted 55 school 2707350 531 Independent Districts and Schools Byron Public School District 270735000981 30 Byron Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 153 1 9   2 3     1   5   84 90     1.0   2.0     22.0   17.0   174 153 1 9   2 3     1   5   84 90     1 2   22 17   174
1720986 1720986 MN Houston 28 school 2707380 299 Independent Districts and Schools Caledonia Public School District 270738000310 20 Caledonia Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 45 1 2   0 0     0   2   33 17     0.0   0.0     12.0   6.0   50 45 1 2   0 0     0   2   33 17     0 0   12 6   50
1721397 1721397 MN Isanti 30 school 2707410 911 Independent Districts and Schools Cambridge-Isanti Public School District 270741003671 301 Cambridge Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 171 3 7   0 2     0   10   94 99     0.0   *     46.0   35.0   193 171 3 7   0 2     0   10   94 99     0     46 35   193
1721401 1721401 MN Isanti 30 school 2707410 911 Independent Districts and Schools Cambridge-Isanti Public School District 270741003629 302 Isanti Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 175 1 5   0 5     0   9   106 89     *   0.0     *   34.0   195 175 1 5   0 5     0   9   106 89       0     34   195
1723846 1723846 MN Isanti 30 school 2707410 911 Independent Districts and Schools Cambridge-Isanti Public School District 270741005198 701 Brookside Academy Special Education Special Education School No Other KG 12 2021   grade_7 1 0 0   0 0     0   0   1 0     *   *     *   *   1 1 0 0   0 0     0   0   1 0                 1
1712542 1712542 MN Wilkin 84 school 2707450 852 Independent Districts and Schools Campbell-Tintah Public School Dist. 270745000320 20 Campbell-Tintah Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 6 0 1   0 0     0   0   3 4     *   *     *   *   7 6 0 1   0 0     0   0   3 4                 7
1712577 1712577 MN Yellow Medicine 87 school 2707470 891 Independent Districts and Schools Canby Public School District 270747000322 10 Canby Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 57 0 1   0 0     0   2   26 34     0.0   0.0     22.0   9.0   60 57 0 1   0 0     0   2   26 34     0 0   22 9   60
1711873 1711873 MN Goodhue 25 school 2707500 252 Independent Districts and Schools Cannon Falls Public School District 270750000324 2 Cannon Falls Secondary Secondary School (Grades 7-12) Regular School No High 06 12 2021   grade_7 89 0 3   0 2     0   2   52 44     1.0   0.0     13.0   16.0   96 89 0 3   0 2     0   2   52 44     1 0   13 16   96
1720143 1720143 MN Rice 66 school 2700324 4194 Charter Schools Cannon River STEM School 270032404271 10 Cannon River STEM School Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2021   grade_7 27 0 4   0 0     0   1   16 16     0.0   0.0     9.0   8.0   32 27 0 4   0 0     0   1   16 16     0 0   9 8   32
1724288 1724288 MN Rice 66 school 2700424 6094 Special Education Cooperatives Cannon Valley Special Education Cooperative 270042404938 10 Alexander Learning Academy Special Education Special Education School No Other KG 12 2021   grade_7 4 1 0   0 0     0   0   4 1     *   *     *   *   5 4 1 0   0 0     0   0   4 1                 5
1724295 1724295 MN Rice 66 school 2700424 6094 Special Education Cooperatives Cannon Valley Special Education Cooperative 270042405068 20 Laura Baker SUN Program Special Education Special Education School No Other PK 12 2021   grade_7 1 0 0   0 0     0   0   1 0     *   *     *   *   1 1 0 0   0 0     0   0   1 0                 1
1713194 1713194 MN Ramsey 62 school 2700402 4237 Charter Schools Career Pathways 270040204836 10 Career Pathways Secondary School (Grades 7-12) Regular School Yes High 06 12 2021   grade_7 1 1 0   0 0     0   0   1 1     *   *     *   *   2 1 1 0   0 0     0   0   1 1                 2
1711731 1711731 MN Carlton 9 school 2707590 93 Independent Districts and Schools Carlton Public School District 270759000327 1 Carlton Secondary Secondary School (Grades 7-12) Regular School No High 06 12 2021   grade_7 21 1 0   5 0     0   0   13 14     0.0   0.0     7.0   4.0   27 21 1 0   5 0     0   0   13 14     0 0   7 4   27
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
1712828 1712828 MN Redwood 64 school 2700110 2754 Independent Districts and Schools Cedar Mountain School District 270011001099 2 Cedar Mountain Secondary Secondary School (Grades 7-12) Regular School No High 06 12 2021   grade_7 31 0 0   4 0     0   4   22 17     0.0   0.0     14.0   11.0   39 31 0 0   4 0     0   4   22 17     0 0   14 11   39
1719445 1719445 MN Hennepin 27 school 2700027 4004 Charter Schools Cedar Riverside Community School 270002702340 10 Cedar Riverside Community School Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2021   grade_7 0 2 0   0 0     0   0   1 1     *   *     *   *   2 0 2 0   0 0     0   0   1 1                 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
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
1711844 1711844 MN Olmsted 55 school 2708220 227 Independent Districts and Schools Chatfield Public Schools 270822000348 1 Chatfield Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 69 0 1   0 1     0   3   37 37     0.0   0.0     10.0   11.0   74 69 0 1   0 1     0   3   37 37     0 0   10 11   74
1721409 1721409 MN Chisago 13 school 2700017 2144 Independent Districts and Schools Chisago Lakes School District 270001700351 3 Chisago Lakes Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 235 2 10   1 4     0   14   142 124     3.0   0.0     32.0   35.0   266 235 2 10   1 4     0   14   142 124     3 0   32 35   266
1712360 1712360 MN Saint Louis 69 school 2708910 695 Independent Districts and Schools Chisholm Public School District 270891000357 302 Chisholm Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 61 1 0   0 0     0   2   32 32     0.0   0.0     27.0   6.0   64 61 1 0   0 0     0   2   32 32     0 0   27 6   64

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