Data source: Big Local News · About: Big Local

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

View and edit SQL

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
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
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
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
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
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
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
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
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 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
1720710 MN Nicollet 52 school 2718780 77 Independent Districts and Schools Mankato Public School District 271878002046 190 Dakota Meadows Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 230 38 16   0 8     0   16   157 151     16.0   0.0     91.0   *   308 230 38 16   0 8     0   16   157 151     16 0   91     308
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
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
1720974 MN Hennepin 27 school 2742160 284 Independent Districts and Schools Wayzata Public School District 274216001762 52 Wayzata East Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 139 14 8   0 44     0   6   99 112     1.0   0.0     25.0   *   211 139 14 8   0 44     0   6   99 112     1 0   25     211
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
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
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
1721151 MN Ramsey 62 school 2722950 621 Independent Districts and Schools Mounds View Public School District 272295001117 67 Highview Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 140 49 44   2 20     0   14   153 116     19.0   1.0     122.0   *   269 140 49 44   2 20     0   14   153 116     19 1   122     269
1721163 MN Ramsey 62 school 2723850 622 Independent Districts and Schools North St. Paul-Maplewood Oakdale Public School District 272385001170 55 John Glenn Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 76 49 35   2 84     1   15   138 124     30.0   6.0     128.0   *   262 76 49 35   2 84     1   15   138 124     30 6   128     262
1721167 MN Ramsey 62 school 2723850 622 Independent Districts and Schools North St. Paul-Maplewood Oakdale Public School District 272385002199 56 Maplewood Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 73 41 44   1 42     0   11   113 99     24.0   4.0     82.0   *   212 73 41 44   1 42     0   11   113 99     24 4   82     212
1721276 MN Sherburne 71 school 2711370 728 Independent Districts and Schools Elk River School District 271137003360 350 Zimmerman Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 169 1 4   0 5     0   6   88 97     2.0   0.0     26.0   *   185 169 1 4   0 5     0   6   88 97     2 0   26     185
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
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
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
1722974 MN Itasca 31 school 2713170 318 Independent Districts and Schools Grand Rapids Public School District 271317000940 375 Middle Area Learning Center Public Area Learning Center ALC (State approved) Alternative School No Middle 05 08 2021   grade_7 27 0 0   3 0     0   2   16 16     0.0   0.0     16.0   *   32 27 0 0   3 0     0   2   16 16     0 0   16     32
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
1723126 MN Saint Louis 69 school 2711040 709 Independent Districts and Schools Duluth Public School District 271104002237 611 Duluth Area Learning Center Public Area Learning Center ALC (State approved) Alternative School No High 06 12 2021   grade_7 26 3 4   1 0     0   5   25 14     1.0   0.0     20.0   *   39 26 3 4   1 0     0   5   25 14     1 0   20     39
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
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
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
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
1723498 MN Dakota 19 school 2732390 196 Independent Districts and Schools Rosemount-Apple Valley-Eagan 273239002517 100 Dakota Ridge School Special Education Special Education School No Other KG 12 2021   grade_7 5 3 1   1 1     0   3   12 2     *   1.0     *   *   14 5 3 1   1 1     0   3   12 2       1         14
1723639 MN Olmsted 55 school 2731800 535 Independent Districts and Schools Rochester Public School District 273180000985 342 Rochester Phoenix Academy Special Education Special Education School No Other KG 12 2021   grade_7 1 1 1   0 0     0   2   4 1     *   *     *   *   5 1 1 1   0 0     0   2   4 1                 5
1723656 MN Ramsey 62 school 2722950 621 Independent Districts and Schools Mounds View Public School District 272295002998 39 Mounds View Bridges Program Special Education Special Education School No Elementary KG 07 2021   grade_7 0 0 1   0 0     0   0   1 0     *   *     *   *   1 0 0 1   0 0     0   0   1 0                 1
1723680 MN Ramsey 62 school 2723850 622 Independent Districts and Schools North St. Paul-Maplewood Oakdale Public School District 272385003374 41 Harmony Learning Center Special Education Special Education School No Other KG 12 2021   grade_7 2 1 0   0 0     0   0   3 0     *   *     *   *   3 2 1 0   0 0     0   0   3 0                 3
1723705 MN Ramsey 62 school 2733840 625 Independent Districts and Schools St. Paul Public School District 273384002189 430 Bridge View Special Education Special Education Special Education School No Other KG 12 2021   grade_7 2 6 1   0 1     0   0   8 2     4.0   1.0     6.0   *   10 2 6 1   0 1     0   0   8 2     4 1   6     10
1723717 MN Ramsey 62 school 2733840 625 Independent Districts and Schools St. Paul Public School District 273384004275 607 Rivereast Program Special Education Special Education School No Other KG 12 2021   grade_7 0 1 0   0 0     0   2   3 0     *   *     *   *   3 0 1 0   0 0     0   2   3 0                 3
1723788 MN Sherburne 71 school 2711370 728 Independent Districts and Schools Elk River School District 271137004142 401 ISD 728 Focus/Journey Special Education Special Education School No Other 01 12 2021   grade_7 1 0 0   0 0     0   1   2 0     *   *     *   *   2 1 0 0   0 0     0   1   2 0                 2
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
1723875 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124003022 625 River Bend Educational Center Special Education Special Education School No Other KG 12 2021   grade_7 1 12 0   1 0     0   0   13 1     0.0   0.0     11.0   *   14 1 12 0   1 0     0   0   13 1     0 0   11     14
1723888 MN Rice 66 school 2700129 160 State Operated Schools (which include MN Academy Deaf & Blind, School for the Arts) Minnesota State Academies 270012903056 1 MN Academy For The Blind Special Education Special Education School No Other PK 12 2021   grade_7 2 0 1   0 0     0   0   2 1     *   *     *   *   3 2 0 1   0 0     0   0   2 1                 3
1723903 MN Rice 66 school 2700129 160 State Operated Schools (which include MN Academy Deaf & Blind, School for the Arts) Minnesota State Academies 270012902409 2 MN Academy For The Deaf Special Education Special Education School No Other PK 12 2021   grade_7 5 0 0   0 0     0   0   3 2     *   *     *   *   5 5 0 0   0 0     0   0   3 2                 5

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