Data source: Big Local News · About: Big Local

4,774 rows where grade = "grade_7" and state = "MN" sorted by free_and_reduced_int

View and edit SQL

year

grade

  • grade_7 · 4,774
Link rowid state county county_state_id admin_level district_nces_id district_state_id district_state_type district school_nces_id school_state_id school school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ccd_school_high_grade year term grade white black hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int ▼ disability_int section_504_int total_int
1711702 MN Brown 8 school 2709540 81 Independent Districts and Schools Comfrey Public School District 270954000404 20 Comfrey Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 8 0 1   0 0     0   0   2 7     *   *     *   *   9 8 0 1   0 0     0   0   2 7                 9
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
1711901 MN Grant 26 school 2713890 264 Independent Districts and Schools Herman-Norcross School District 271389000714 2 Herman Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 6 0 1   0 0     0   1   3 5     *   *     *   *   8 6 0 1   0 0     0   1   3 5                 8
1711950 MN Itasca 31 school 2713170 318 Independent Districts and Schools Grand Rapids Public School District 271317000934 350 Bigfork Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 13 0 0   2 0     0   1   8 8     *   0.0     *   6.0   16 13 0 0   2 0     0   1   8 8       0     6   16
1712058 MN Lincoln 41 school 2717460 404 Independent Districts and Schools Lake Benton Public School District 271746000802 20 Lake Benton Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 1 0 0   0 0     0   0   0 1     *   *     *   *   1 1 0 0   0 0     0   0   0 1                 1
1712074 MN Mahnomen 44 school 2718660 432 Independent Districts and Schools Mahnomen Public School District 271866000866 20 Mahnomen Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 14 0 5   46 0     0   4   33 36     *   *     *   *   69 14 0 5   46 0     0   4   33 36                 69
1712095 MN Marshall 45 school 2718920 447 Independent Districts and Schools Grygla Public School District 271892000897 3 Grygla Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 7 0 1   0 0     0   0   3 5     *   *     *   *   8 7 0 1   0 0     0   0   3 5                 8
1712116 MN Mille Lacs 48 school 2715510 473 Independent Districts and Schools Isle Public School District 271551000770 20 Isle Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 34 0 0   4 0     0   1   26 13     *   *     *   *   39 34 0 0   4 0     0   1   26 13                 39
1712172 MN Nobles 53 school 2711460 514 Independent Districts and Schools Ellsworth Public School District 271146000526 20 Ellsworth Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 6 0 0   0 0     0   1   2 5     *   *     *   *   7 6 0 0   0 0     0   1   2 5                 7
1712257 MN Polk 60 school 2709720 593 Independent Districts and Schools Crookston Public School District 270972000412 90 Crookston Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 70 0 22   7 0     0   5   57 47     *   *     *   *   104 70 0 22   7 0     0   5   57 47                 104
1712294 MN Ramsey 62 school 2733840 625 Independent Districts and Schools St. Paul Public School District 273384001598 225 HUMBOLDT HIGH SCHOOL Secondary School (Grades 7-12) Regular School No High 06 12 2021   grade_7 9 34 26   1 41     0   11   64 58     43.0   *     *   23.0   122 9 34 26   1 41     0   11   64 58     43       23   122
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
1712894 MN Big Stone 6 school 2700150 2888 Independent Districts and Schools Clinton-Graceville-Beardsley 270015000652 3 6-12th Grade Building Secondary School (Grades 7-12) Regular School No High 06 12 2021   grade_7 13 0 1   0 0     0   0   3 11     *   *     *   *   14 13 0 1   0 0     0   0   3 11                 14
1712951 MN Ramsey 62 school 2702264 916 Intermediate Districts and Schools Northeast Metro 916 270226404818 29 Assessment Center Secondary School (Grades 7-12) Regular School No Other KG 12 2021   grade_7 0 0 1   0 0     0   0   0 1     *   *     *   *   1 0 0 1   0 0     0   0   0 1                 1
1712973 MN Hennepin 27 school 2700117 4017 Charter Schools Minnesota Transitions Charter School 270011703262 12 MTS High School Secondary School (Grades 7-12) Regular School Yes High 07 12 2021   grade_7 5 5 2   1 0     0   5   7 11     0.0   *     *   2.0   18 5 5 2   1 0     0   5   7 11     0       2   18
1712980 MN Hennepin 27 school 2700117 4017 Charter Schools Minnesota Transitions Charter School 270011705279 27 Banaadir Secondary Secondary School (Grades 7-12) Regular School Yes High 07 12 2021   grade_7 0 22 0   0 0     0   0   9 13     *   0.0     *   3.0   22 0 22 0   0 0     0   0   9 13       0     3   22
1712986 MN Ramsey 62 school 2700140 4027 Charter Schools Higher Ground Academy 270014004749 30 Higher Ground Secondary Academy Secondary School (Grades 7-12) Regular School Yes High 07 12 2021   grade_7 0 86 0   0 0     0   0   42 44     33.0   0.0     *   3.0   86 0 86 0   0 0     0   0   42 44     33 0     3   86
1713031 MN Blue Earth 7 school 2700226 4066 Charter Schools Kato Public Charter School 270022603471 10 Kato Public Charter School Secondary School (Grades 7-12) Regular School Yes High 06 12 2021   grade_7 2 1 0   0 0     0   0   3 0     *   *     *   *   3 2 1 0   0 0     0   0   3 0                 3
1713044 MN Cass 11 school 2700191 4080 Charter Schools Pillager Area Charter School 270019103144 10 PILLAGER AREA CHARTER SCHOOL Secondary School (Grades 7-12) Regular School Yes High 07 12 2021   grade_7 1 0 0   0 0     0   0   1 0     *   *     *   *   1 1 0 0   0 0     0   0   1 0                 1
1713052 MN Rice 66 school 2700192 4081 Charter Schools Discovery Public School Faribault 270019203145 10 Discovery Public School Faribault Secondary School (Grades 7-12) Regular School Yes High 06 12 2021   grade_7 1 0 1   0 0     0   0   1 1     *   *     *   *   2 1 0 1   0 0     0   0   1 1                 2
1713068 MN Mcleod 43 school 2700214 4093 Charter Schools New Century Academy 270021403275 10 New Century Academy Secondary School (Grades 7-12) Regular School Yes High 06 12 2021   grade_7 4 0 0   0 0     0   0   3 1     *   *     *   *   4 4 0 0   0 0     0   0   3 1                 4
1713120 MN Itasca 31 school 2700256 4146 Charter Schools Northern Lights Community School 270025603314 10 Northern Lights Community School Secondary School (Grades 7-12) Regular School Yes High 06 12 2021   grade_7 6 1 0   1 0     0   1   4 5     *   *     *   *   9 6 1 0   1 0     0   1   4 5                 9
1713154 MN Saint Louis 69 school 2700372 4207 Charter Schools Vermilion Country School 270037204555 10 Vermilion Country School Secondary School (Grades 7-12) Regular School Yes High 07 12 2021   grade_7 1 0 0   1 0     0   0   1 1     *   *     *   *   2 1 0 0   1 0     0   0   1 1                 2
1713164 MN Kandiyohi 34 school 2700389 4217 Charter Schools Technical Academies of Minnesota 270038904696 10 DREAM Technical Academy Secondary School (Grades 7-12) Regular School Yes High 07 12 2021   grade_7 3 0 2   0 0     0   0   1 4     *   *     *   *   5 3 0 2   0 0     0   0   1 4                 5
1713178 MN Hennepin 27 school 2700384 4218 Charter Schools Venture Academy 270038404697 10 Venture Academy Secondary School (Grades 7-12) Regular School Yes High 06 12 2021   grade_7 0 13 16   6 0     0   0   18 17     9.0   1.0     *   8.0   35 0 13 16   6 0     0   0   18 17     9 1     8   35
1713186 MN Wright 86 school 2700403 4229 Charter Schools Jane Goodall Environmental Science Academy 270040304850 10 Jane Goodall Environmental Science Academy Secondary School (Grades 7-12) Regular School Yes High 06 12 2021   grade_7 9 0 0   0 0     0   0   4 5     *   *     *   *   9 9 0 0   0 0     0   0   4 5                 9
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
1713583 MN Becker 3 school 2728960 25 Independent Districts and Schools Pine Point Public School District 272896000034 70 Pine Point Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 08 2021   grade_7 0 0 0   6 0     0   0   2 4     *   *     *   *   6 0 0 0   6 0     0   0   2 4                 6
1713660 MN Beltrami 4 school 2730510 38 Independent Districts and Schools Red Lake Public School District 273051001301 20 Ponemah Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 08 2021   grade_7 0 0 0   17 0     0   0   10 7     *   *     *   *   17 0 0 0   17 0     0   0   10 7                 17
1717007 MN Ramsey 62 school 2733840 625 Independent Districts and Schools St. Paul Public School District 273384002303 579 American Indian Magnet School Elementary School (Grades PK-6) Regular School No Elementary PK 08 2021   grade_7 3 11 17   9 21     0   14   34 41     21.0   3.0     *   10.0   75 3 11 17   9 21     0   14   34 41     21 3     10   75
1718906 MN Big Stone 6 school 2700150 2888 Independent Districts and Schools Clinton-Graceville-Beardsley 270015003019 6 Lismore Colony Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 08 2021   grade_7 5 0 0   0 0     0   0   1 4     *   *     *   *   5 5 0 0   0 0     0   0   1 4                 5
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
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
1719571 MN Hennepin 27 school 2700159 4038 Charter Schools Sojourner Truth Academy 270015902954 10 Sojourner Truth Academy Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2021   grade_7 0 32 10   0 0     0   0   22 20     6.0   4.0     *   7.0   42 0 32 10   0 0     0   0   22 20     6 4     7   42
1719581 MN Nicollet 52 school 2700174 4050 Charter Schools Lafayette Public Charter School 270017403042 10 Lafayette Public Charter School Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2021   grade_7 2 0 0   0 0     0   1   2 1     *   *     *   *   3 2 0 0   0 0     0   1   2 1                 3
1719651 MN Hennepin 27 school 2700184 4068 Charter Schools Excell Academy Charter 270018403137 10 Excell Academy Charter Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2021   grade_7 0 31 2   0 0     0   0   20 13     2.0   0.0     *   3.0   33 0 31 2   0 0     0   0   20 13     2 0     3   33
1719699 MN Hennepin 27 school 2700190 4079 Charter Schools Friendship Academy of Fine Arts Charter 270019005280 30 Friendship Academy of the Arts - Intermediate Elementary School (Grades PK-6) Regular School Yes Middle 02 08 2021   grade_7 0 20 0   0 0     0   0   10 10     0.0   0.0     *   4.0   20 0 20 0   0 0     0   0   10 10     0 0     4   20
1719725 MN Ramsey 62 school 2700353 4088 Charter Schools Urban Academy Charter School 270035304173 10 Urban Academy Charter School Elementary School (Grades PK-6) Regular School Yes Elementary PK 07 2021   grade_7 1 6 0   0 31     0   0   15 23     21.0   0.0     *   8.0   38 1 6 0   0 31     0   0   15 23     21 0     8   38
1719770 MN Cook 16 school 2700339 4100 Charter Schools Great Expectations 270033904177 10 Great Expectations Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2021   grade_7 7 0 0   0 0     0   0   1 6     *   *     *   *   7 7 0 0   0 0     0   0   1 6                 7
1719855 MN Olmsted 55 school 2700247 4135 Charter Schools Rochester Math And Science Academy 270024703308 10 Rochester Math And Science Academy Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2021   grade_7 0 39 0   0 0     0   0   22 17     11.0   0.0     *   3.0   39 0 39 0   0 0     0   0   22 17     11 0     3   39
1719873 MN Hennepin 27 school 2700273 4139 Charter Schools LoveWorks Academy For Arts 270027303575 10 LoveWorks Academy For Arts Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2021   grade_7 0 20 0   0 0     0   0   11 9     0.0   0.0     *   3.0   20 0 20 0   0 0     0   0   11 9     0 0     3   20
1719938 MN Ramsey 62 school 2700263 4153 Charter Schools Midway Star Academy 270026303320 10 Midway Star Academy Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2021   grade_7 0 36 0   0 0     0   0   16 20     30.0   0.0     *   5.0   36 0 36 0   0 0     0   0   16 20     30 0     5   36
1719972 MN Mcleod 43 school 2700277 4161 Charter Schools New Discoveries Montessori Academy 270027703616 10 New Discoveries Montessori Academy Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2021   grade_7 6 0 1   0 0     0   1   7 1     *   *     *   *   8 6 0 1   0 0     0   1   7 1                 8
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
1720197 MN Hennepin 27 school 2700378 4208 Charter Schools Nasha Shkola Charter School 270037804635 10 Nasha Shkola Charter School Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2021   grade_7 6 0 0   0 0     0   0   2 4     *   *     *   *   6 6 0 0   0 0     0   0   2 4                 6
1720231 MN Ramsey 62 school 2700386 4215 Charter Schools Sejong Academy of Minnesota 270038604695 10 Sejong Academy of Minnesota Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2021   grade_7 0 0 0   0 8     0   0   4 4     *   *     *   *   8 0 0 0   0 8     0   0   4 4                 8
1720241 MN Hennepin 27 school 2700398 4219 Charter Schools Northeast College Prep 270039804757 10 Northeast College Prep Charter School Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2021   grade_7 4 34 3   0 0     0   3   19 25     10.0   0.0     *   9.0   44 4 34 3   0 0     0   3   19 25     10 0     9   44
1720261 MN Dakota 19 school 2700391 4221 Charter Schools Discovery Charter School 270039104764 10 Discovery Charter Elementary School Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2021   grade_7 0 2 3   1 0     0   1   5 2     *   *     *   *   7 0 2 3   1 0     0   1   5 2                 7
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
1720342 MN Hennepin 27 school 2700404 4232 Charter Schools Success Academy 270040404790 10 Success Academy Elementary School (Grades PK-6) Regular School Yes Elementary KG 07 2021   grade_7 0 9 0   0 0     0   0   5 4     *   *     *   *   9 0 9 0   0 0     0   0   5 4                 9
1720367 MN Ramsey 62 school 2700410 4240 Charter Schools New Century School 270041004873 10 New Century School Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2021   grade_7 0 29 0   0 0     0   0   15 14     17.0   0.0     *   3.0   29 0 29 0   0 0     0   0   15 14     17 0     3   29
1720405 MN Chisago 13 school 2700429 4253 Charter Schools Phoenix Academy Charter School 270042904969 10 Phoenix Academy Charter School Elementary School (Grades PK-6) Regular School Yes Elementary KG 07 2021   grade_7 8 0 0   0 0     0   1   3 6     *   *     *   *   9 8 0 0   0 0     0   1   3 6                 9
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
1720506 MN Ramsey 62 school 2700458 4275 Charter Schools St. Paul School of Northern Lights 270045805256 10 St. Paul School of Northern Lights Elementary School (Grades PK-6) Regular School Yes Elementary KG 07 2021   grade_7 6 0 1   0 0     0   1   5 3     *   *     *   *   8 6 0 1   0 0     0   1   5 3                 8
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
1720694 MN Becker 3 school 2710230 22 Independent Districts and Schools Detroit Lakes Public School District 271023000443 4 Detroit Lakes Middle Middle School (Grades 5-8) Regular School No Middle 05 08 2021   grade_7 148 1 3   45 0     0   1   106 92     *   *     *   *   198 148 1 3   45 0     0   1   106 92                 198
1720702 MN Beltrami 4 school 2730510 38 Independent Districts and Schools Red Lake Public School District 273051002427 40 Red Lake Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 1 0 0   83 0     0   0   51 33     0.0   18.0     *   21.0   84 1 0 0   83 0     0   0   51 33     0 18     21   84
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
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
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
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
1720902 MN Hennepin 27 school 2711250 273 Independent Districts and Schools Edina Public School District 271125000686 19 South View Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 222 33 34   0 29     0   15   175 158     *   0.0     *   43.0   333 222 33 34   0 29     0   15   175 158       0     43   333
1720906 MN Hennepin 27 school 2711250 273 Independent Districts and Schools Edina Public School District 271125002035 20 Valley View Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 247 32 11   0 31     1   27   167 182     *   0.0     *   39.0   349 247 32 11   0 31     1   27   167 182       0     39   349
1721018 MN Kandiyohi 34 school 2742720 347 Independent Districts and Schools Willmar Public School District 274272001808 301 Willmar Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 101 56 109   2 7     2   9   151 135     *   *     *   *   286 101 56 109   2 7     2   9   151 135                 286
1721053 MN Mille Lacs 48 school 2725050 480 Independent Districts and Schools Onamia Public School District 272505005107 50 Onamia Intermediate School Middle School (Grades 5-8) Regular School No Other 03 09 2021   grade_7 18 0 3   28 1     0   5   26 29     *   *     *   *   55 18 0 3   28 1     0   5   26 29                 55
1721062 MN Morrison 49 school 2732520 485 Independent Districts and Schools Royalton Public School District 273252004640 50 Royalton Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 64 1 1   0 0     0   2   36 32     0.0   0.0     *   10.0   68 64 1 1   0 0     0   2   36 32     0 0     10   68
1721084 MN Nicollet 52 school 2733870 508 Independent Districts and Schools St. Peter Public School District 273387002533 80 St. Peter Middle School Middle School (Grades 5-8) Regular School No Middle 05 08 2021   grade_7 131 15 25   1 1     0   2   84 91     *   *     *   *   175 131 15 25   1 1     0   2   84 91                 175
1721113 MN Olmsted 55 school 2731800 535 Independent Districts and Schools Rochester Public School District 273180005219 329 Middle School Right Fit Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 2 1 0   0 0     0   0   3 0     *   *     *   *   3 2 1 0   0 0     0   0   3 0                 3
1721135 MN Otter Tail 56 school 2728230 549 Independent Districts and Schools Perham-Dent Public School District 272823002535 20 Prairie Wind Middle Middle School (Grades 5-8) Regular School No Middle 05 08 2021   grade_7 109 3 12   1 0     0   9   75 59     *   *     *   *   134 109 3 12   1 0     0   9   75 59                 134
1721155 MN Ramsey 62 school 2722950 621 Independent Districts and Schools Mounds View Public School District 272295001115 70 Chippewa Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 242 13 18   2 57     0   29   194 167     8.0   0.0     *   34.0   361 242 13 18   2 57     0   29   194 167     8 0     34   361
1721280 MN Wright 86 school 2711370 728 Independent Districts and Schools Elk River School District 271137005253 380 Prairie View Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 142 11 9   0 1     0   12   81 94     7.0   0.0     *   26.0   175 142 11 9   0 1     0   12   81 94     7 0     26   175
1721311 MN Stearns 73 school 2709440 750 Independent Districts and Schools Rocori Public School District 270944001682 60 Rocori Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 169 1 27   1 0     0   4   100 102     *   *     *   *   202 169 1 27   1 0     0   4   100 102                 202
1721362 MN Winona 85 school 2744070 861 Independent Districts and Schools Winona Area Public School District 274407001830 6 Winona Middle Middle School (Grades 5-8) Regular School No Middle 05 08 2021   grade_7 166 16 11   0 4     0   9   111 95     *   *     *   *   206 166 16 11   0 4     0   9   111 95                 206
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
1721431 MN Rock 67 school 2718330 2184 Independent Districts and Schools Luverne Public School District 271833002471 3 Luverne Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 80 0 6   1 0     0   4   47 44     *   *     *   *   91 80 0 6   1 0     0   4   47 44                 91
1721557 MN Hennepin 27 school 2700189 4078 Charter Schools Twin Cities International Schools 270018903142 10 Minnesota International Middle Charter School Middle School (Grades 5-8) Regular School Yes Middle 05 08 2021   grade_7 0 114 0   0 0     0   0   42 72     45.0   0.0     *   6.0   114 0 114 0   0 0     0   0   42 72     45 0     6   114
1721569 MN Beltrami 4 school 2700346 4107 Charter Schools Voyageurs Expeditionary 270034604667 20 Voyageurs Expeditionary MS Middle School (Grades 5-8) Regular School Yes Middle 06 08 2021   grade_7 5 0 0   9 0     0   2   12 4     0.0   0.0     *   6.0   16 5 0 0   9 0     0   2   12 4     0 0     6   16
1721587 MN Hennepin 27 school 2700245 4131 Charter Schools Metro Schools Charter 270024504857 20 Metro Schools Middle Charter Middle School (Grades 5-8) Regular School Yes Middle 05 08 2021   grade_7 0 37 0   0 0     0   0   19 18     21.0   0.0     *   3.0   37 0 37 0   0 0     0   0   19 18     21 0     3   37
1721624 MN Hennepin 27 school 2700335 4205 Charter Schools Hennepin Elementary School 270033505203 20 Hennepin Middle School Middle School (Grades 5-8) Regular School Yes Middle 06 08 2021   grade_7 0 31 3   0 0     0   0   23 11     14.0   0.0     *   8.0   34 0 31 3   0 0     0   0   23 11     14 0     8   34
1721642 MN Ramsey 62 school 2700399 4231 Charter Schools Minnesota Math and Science Academy 270039905177 20 MMSA Middle School Middle School (Grades 5-8) Regular School Yes Middle 05 08 2021   grade_7 0 47 2   0 1     0   1   28 23     35.0   0.0     *   5.0   51 0 47 2   0 1     0   1   28 23     35 0     5   51
1721649 MN Ramsey 62 school 2700423 4243 Charter Schools North Metro Flex Academy 270042305320 20 North Metro Flex Middle School Middle School (Grades 5-8) Regular School Yes Middle 07 08 2021   grade_7 0 8 7   0 0     0   2   4 13     2.0   1.0     *   3.0   17 0 8 7   0 0     0   2   4 13     2 1     3   17
1721652 MN Ramsey 62 school 2700438 4258 Charter Schools The Journey School 270043805290 20 The Journey School Middle Middle School (Grades 5-8) Regular School Yes Middle 07 07 2021   grade_7 3 1 4   0 0     0   2   5 5     1.0   0.0     *   1.0   10 3 1 4   0 0     0   2   5 5     1 0     1   10
1721655 MN Hennepin 27 school 2700439 4261 Charter Schools SciTech Academy Charter School 270043905291 20 SciTech Academy Middle Middle School (Grades 5-8) Regular School Yes Middle 06 08 2021   grade_7 0 19 0   0 0     0   0   9 10     *   0.0     *   3.0   19 0 19 0   0 0     0   0   9 10       0     3   19
1722048 MN Lincoln 41 school 2713680 402 Independent Districts and Schools Hendricks Public School District 271368004530 20 Hendricks Senior High Senior High School (Grades 9-12) Regular School No High 07 12 2021   grade_7 4 0 3   0 0     0   0   4 3     *   *     *   *   7 4 0 3   0 0     0   0   4 3                 7
1722630 MN Ramsey 62 school 2700152 4031 Charter Schools Jennings Community School 270015202947 10 Jennings Experiential High School Senior High School (Grades 9-12) Regular School Yes 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
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
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
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
1722827 MN Becker 3 school 2710230 22 Independent Districts and Schools Detroit Lakes Public School District 271023003061 32 Detroit Lakes Middle ALC Public Area Learning Center ALC (State approved) Alternative School No Middle 06 08 2021   grade_7 0 0 1   0 0     0   0   1 0     *   *     *   *   1 0 0 1   0 0     0   0   1 0                 1
1722849 MN Beltrami 4 school 2730510 38 Independent Districts and Schools Red Lake Public School District 273051002793 50 Red Lake Middle Level ALC Public Area Learning Center ALC (State approved) Alternative School No Middle 06 08 2021   grade_7 0 0 0   4 0     0   0   1 3     *   *     *   *   4 0 0 0   4 0     0   0   1 3                 4
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
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
1722953 MN Hennepin 27 school 2742160 284 Independent Districts and Schools Wayzata Public School District 274216003743 952 East Middle Alternative (EMAP) Public Area Learning Center ALC (State approved) Alternative School No Middle 06 08 2021   grade_7 0 1 2   0 2     0   1   4 2     *   *     *   *   6 0 1 2   0 2     0   1   4 2                 6
1722956 MN Hennepin 27 school 2742160 284 Independent Districts and Schools Wayzata Public School District 274216003740 953 Central Middle Alternative (CMAP) Public Area Learning Center ALC (State approved) Alternative School No Middle 06 08 2021   grade_7 2 4 2   0 0     0   0   4 4     *   *     *   *   8 2 4 2   0 0     0   0   4 4                 8
1723004 MN Mahnomen 44 school 2718660 432 Independent Districts and Schools Mahnomen Public School District 271866002333 40 MAHNOMEN AREA LEARNING CENTER Public Area Learning Center ALC (State approved) Alternative School No High 06 12 2021   grade_7 0 0 0   3 0     0   0   2 1     *   *     *   *   3 0 0 0   3 0     0   0   2 1                 3
1723015 MN Mille Lacs 48 school 2715510 473 Independent Districts and Schools Isle Public School District 271551002819 40 ISLE AREA LEARNING CENTER Public Area Learning Center ALC (State approved) Alternative School No High 07 12 2021   grade_7 1 0 0   0 0     0   0   0 1     *   *     *   *   1 1 0 0   0 0     0   0   0 1                 1
1723046 MN Nobles 53 school 2744160 518 Independent Districts and Schools Worthington Public School District 274416002335 6 Learning Center Public Area Learning Center ALC (State approved) Alternative School No High 07 12 2021   grade_7 0 0 2   0 0     0   0   1 1     *   *     *   *   2 0 0 2   0 0     0   0   1 1                 2
1723073 MN Otter Tail 56 school 2728230 549 Independent Districts and Schools Perham-Dent Public School District 272823001023 80 Perham Area Learning Center Public Area Learning Center ALC (State approved) Alternative School No High 07 12 2021   grade_7 2 0 0   0 0     0   1   3 0     *   *     *   *   3 2 0 0   0 0     0   1   3 0                 3
1723157 MN Sherburne 71 school 2711370 728 Independent Districts and Schools Elk River School District 271137005158 610 Ivan Sand Middle School ALC Public Area Learning Center ALC (State approved) Alternative School No Middle 06 08 2021   grade_7 1 0 0   0 0     0   0   0 1     *   *     *   *   1 1 0 0   0 0     0   0   0 1                 1
1723164 MN Stearns 73 school 2709440 750 Independent Districts and Schools Rocori Public School District 270944004629 70 Rocori ALC Public Area Learning Center ALC (State approved) Alternative School No High 07 12 2021   grade_7 1 0 0   0 0     0   0   0 1     *   *     *   *   1 1 0 0   0 0     0   0   0 1                 1

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