Data source: Big Local News · About: Big Local

4,774 rows where grade = "grade_7" and state = "MN" sorted by ell_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
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
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
1712102 MN Martin 46 school 2740680 458 Independent Districts and Schools Truman Public School District 274068001693 20 Truman Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 20 0 0   0 1     0   0   10 11     *   *     13.0   *   21 20 0 0   0 1     0   0   10 11           13     21
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
1712221 MN Pennington 57 school 2713020 561 Independent Districts and Schools Goodridge Public School District 271302000650 20 Goodridge Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 15 0 3   2 0     0   0   13 7     *   *     12.0   3.0   20 15 0 3   2 0     0   0   13 7           12 3   20
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
1712302 MN Ramsey 62 school 2733840 625 Independent Districts and Schools St. Paul Public School District 273384004443 250 Open World Learning Secondary Secondary School (Grades 7-12) Regular School No High 06 12 2021   grade_7 37 5 15   0 4     0   9   32 38     *   0.0     23.0   8.0   70 37 5 15   0 4     0   9   32 38       0   23 8   70
1712436 MN Stevens 75 school 2708940 771 Independent Districts and Schools Chokio-Alberta Public School Dist. 270894000361 2 Chokio-Alberta Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 16 0 0   0 0     0   0   9 7     *   *     5.0   2.0   16 16 0 0   0 0     0   0   9 7           5 2   16
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
1712584 MN Mille Lacs 48 school 2720670 912 Independent Districts and Schools Milaca Public School District 272067000924 30 Milaca Secondary High Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 117 1 5   2 1     0   3   61 68     *   *     56.0   32.0   129 117 1 5   2 1     0   3   61 68           56 32   129
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
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
1713023 MN Winona 85 school 2700221 4064 Charter Schools Riverway Learning Community Charter 270022103136 20 Riverway Secondary Secondary School (Grades 7-12) Regular School Yes High 07 12 2021   grade_7 7 0 0   0 0     0   3   10 0     *   *     7.0   5.0   10 7 0 0   0 0     0   3   10 0           7 5   10
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
1713132 MN Hennepin 27 school 2700315 4183 Charter Schools Lionsgate Academy 270031504325 10 Lionsgate Academy - Minnetonka Secondary School (Grades 7-12) Regular School Yes High 07 12 2021   grade_7 16 3 1   0 0     0   3   15 8     *   0.0     2.0   *   23 16 3 1   0 0     0   3   15 8       0   2     23
1713139 MN Ramsey 62 school 2700315 4183 Charter Schools Lionsgate Academy 270031505148 50 Lionsgate Academy - Shoreview Secondary School (Grades 7-12) Regular School Yes High 07 12 2021   grade_7 13 3 3   0 3     0   4   21 5     *   0.0     8.0   *   26 13 3 3   0 3     0   4   21 5       0   8     26
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
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
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
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
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
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
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
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
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
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
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
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
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
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
1720811 MN Dakota 19 school 2717780 194 Independent Districts and Schools Lakeville Public School District 271778002435 89 McGuire Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 226 6 13   0 11     1   14   133 138     *   *     24.0   40.0   271 226 6 13   0 11     1   14   133 138           24 40   271
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
1720839 MN Dakota 19 school 2732390 196 Independent Districts and Schools Rosemount-Apple Valley-Eagan 273239001943 93 Scott Highlands Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 256 45 33   1 45     0   26   195 211     *   0.0     63.0   45.0   406 256 45 33   1 45     0   26   195 211       0   63 45   406
1720848 MN Dakota 19 school 2742270 197 Independent Districts and Schools West St. Paul-Mendota Heights-Eagan 274227002646 52 Friendly Hills Middle Middle School (Grades 5-8) Regular School No Middle 05 08 2021   grade_7 100 32 53   0 9     0   13   109 98     *   2.0     90.0   32.0   207 100 32 53   0 9     0   13   109 98       2   90 32   207
1720853 MN Dakota 19 school 2742270 197 Independent Districts and Schools West St. Paul-Mendota Heights-Eagan 274227001774 54 Heritage E-STEM Magnet School Middle School (Grades 5-8) Regular School No Middle 05 08 2021   grade_7 85 19 73   3 4     0   17   96 105     *   6.0     99.0   35.0   201 85 19 73   3 4     0   17   96 105       6   99 35   201
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
1721000 MN Hubbard 29 school 2728080 309 Independent Districts and Schools Park Rapids Public School District 272808001236 80 Park Rapids Area Century Middle Middle School (Grades 5-8) Regular School No Middle 05 08 2021   grade_7 93 1 9   5 0     0   6   60 54     *   0.0     54.0   27.0   114 93 1 9   5 0     0   6   60 54       0   54 27   114
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
1721028 MN Lyon 42 school 2718390 415 Independent Districts and Schools Lynd Public School District 271839004845 40 Lynd Middle School Middle School (Grades 5-8) Regular School No Middle 05 08 2021   grade_7 8 0 5   0 0     0   0   6 7     *   *     11.0   5.0   13 8 0 5   0 0     0   0   6 7           11 5   13
1721032 MN Mcleod 43 school 2714970 423 Independent Districts and Schools Hutchinson Public School District 271497000755 20 Hutchinson Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 160 1 21   0 6     0   9   110 87     *   *     43.0   *   197 160 1 21   0 6     0   9   110 87           43     197
1721046 MN Mille Lacs 48 school 2730030 477 Independent Districts and Schools Princeton Public School District 273003001272 20 Princeton Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 219 1 13   1 1     0   6   125 116     *   0.0     60.0   31.0   241 219 1 13   1 1     0   6   125 116       0   60 31   241
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
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
1721288 MN Sherburne 71 school 2711370 728 Independent Districts and Schools Elk River School District 271137002038 410 Salk Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 196 25 13   4 8     0   11   139 118     *   0.0     29.0   24.0   257 196 25 13   4 8     0   11   139 118       0   29 24   257
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
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
1723001 MN Mcleod 43 school 2714970 423 Independent Districts and Schools Hutchinson Public School District 271497003522 75 Hutchinson Middle School A.L.C. Public Area Learning Center ALC (State approved) Alternative School No Middle 06 08 2021   grade_7 8 1 5   0 1     0   0   6 9     *   *     12.0   *   15 8 1 5   0 1     0   0   6 9           12     15
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
1723182 MN Washington 82 school 2712270 831 Independent Districts and Schools Forest Lake Public School District 271227001725 113 Forest Lake Area Community School Public Area Learning Center ALC (State approved) Alternative School No High 06 12 2021   grade_7 21 4 1   1 3     0   1   15 16     *   0.0     10.0   0.0   31 21 4 1   1 3     0   1   15 16       0   10 0   31
1723193 MN Winona 85 school 2744070 861 Independent Districts and Schools Winona Area Public School District 274407002249 19 Winona Area Learning Center Public Area Learning Center ALC (State approved) Alternative School No High 06 12 2021   grade_7 3 0 0   0 0     0   0   2 1     *   *     *   *   3 3 0 0   0 0     0   0   2 1                 3
1723308 MN Mower 50 school 2700327 6083 Special Education Cooperatives Southern MN Education Consortium 270032704978 50 SMEC ALC Public Area Learning Center ALC (State approved) Alternative School No High 05 12 2021   grade_7 2 0 0   0 0     0   0   2 0     *   *     *   *   2 2 0 0   0 0     0   0   2 0                 2
1723357 MN Stearns 73 school 2791455 6026 Education Districts West Central Education District 279145502388 20 West Central Area Learning Center Public Area Learning Center ALC (State approved) Alternative School No High 06 12 2021   grade_7 1 0 1   0 0     0   2   2 2     *   *     *   *   4 1 0 1   0 0     0   2   2 2                 4
1723383 MN Saint Louis 69 school 2700224 6076 Miscellaneous Cooperatives Northland Learning Center 270022403477 10 Northland Learning Center 010 Public Area Learning Center ALC (State approved) Alternative School No Other PK 12 2021   grade_7 0 1 0   0 0     0   0   0 1     *   *     *   *   1 0 1 0   0 0     0   0   0 1                 1
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
1723459 MN Nicollet 52 school 2718780 77 Independent Districts and Schools Mankato Public School District 271878004374 370 Futures Program Special Education Special Education School No Other KG 12 2021   grade_7 3 0 0   0 0     0   3   5 1     *   *     *   *   6 3 0 0   0 0     0   3   5 1                 6

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