Data source: Big Local News · About: Big Local

694 rows where grade = "grade_7", state = "MN" and year = 2020 sorted by homeless_int

View and edit SQL

year

  • 2020 · 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
1825342 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 2020   grade_7 10.0 0.0 0.0   16.0 0.0     0.0   0.0   13.0 13.0     *   *     21.0   6.0   26.0 10 0 0   16 0     0   0   13 13           21 6   26
1825469 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 2020   grade_7 5.0 0.0 1.0   0.0 0.0     0.0   2.0   3.0 5.0     *   *         *   8.0 5 0 1   0 0     0   2   3 5                 8
1825518 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 2020   grade_7 25.0 0.0 1.0   0.0 0.0     0.0   0.0   8.0 18.0     0.0   *         *   26.0 25 0 1   0 0     0   0   8 18     0           26
1825576 MN Koochiching 36 school 2732700 363 Independent Districts and Schools South Koochiching School District 273270001413 60 Indus Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2020   grade_7 8.0 0.0 0.0   0.0 0.0     0.0   0.0   6.0 2.0     *   *         *   8.0 8 0 0   0 0     0   0   6 2                 8
1825583 MN Koochiching 36 school 2732700 363 Independent Districts and Schools South Koochiching School District 273270001416 70 Northome Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2020   grade_7 14.0 0.0 1.0   4.0 0.0     0.0   0.0   8.0 11.0     *   *         *   19.0 14 0 1   4 0     0   0   8 11                 19
1825670 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 2020   grade_7 14.0 0.0 0.0   0.0 0.0     0.0   1.0   11.0 4.0     *   *     9.0   3.0   15.0 14 0 0   0 0     0   1   11 4           9 3   15
1825768 MN Otter Tail 56 school 2728170 548 Independent Districts and Schools Pelican Rapids Public School Dist. 272817001243 20 Pelican Rapids Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2020   grade_7 31.0 8.0 12.0   0.0 0.0     0.0   2.0   24.0 29.0     *   *     30.0   *   53.0 31 8 12   0 0     0   2   24 29           30     53
1825924 MN Roseau 68 school 2741850 690 Independent Districts and Schools Warroad Public School District 274185001745 30 Warroad High School Secondary School (Grades 7-12) Regular School No High 07 12 2020   grade_7 39.0 1.0 1.0   5.0 7.0     0.0   5.0   30.0 28.0     *   *     23.0   15.0   58.0 39 1 1   5 7     0   5   30 28           23 15   58
1826014 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 2020   grade_7 8.0 0.0 0.0   0.0 0.0     0.0   0.0   3.0 5.0     *   *         *   8.0 8 0 0   0 0     0   0   3 5                 8
1826057 MN Wabasha 79 school 2741060 811 Independent Districts and Schools Wabasha-Kellogg Public School Dist. 274106001722 40 Wabasha-Kellogg Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2020   grade_7 44.0 2.0 2.0   0.0 0.0     0.0   0.0   22.0 26.0     *   *         *   48.0 44 2 2   0 0     0   0   22 26                 48
1826090 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 2020   grade_7 4.0 0.0 21.0   0.0 0.0     0.0   0.0   15.0 10.0     13.0   *     16.0   5.0   25.0 4 0 21   0 0     0   0   15 10     13     16 5   25
1826127 MN Winona 85 school 2718090 857 Independent Districts and Schools Lewiston-Altura Public School Dist. 271809000836 30 Lewiston-Altura Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2020   grade_7 48.0 0.0 4.0   0.0 1.0     0.0   1.0   32.0 22.0     2.0   *     21.0   9.0   54.0 48 0 4   0 1     0   1   32 22     2     21 9   54
1826361 MN Pine 58 school 2711085 2580 Independent Districts and Schools East Central School District 271108500189 30 East Central Senior Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2020   grade_7 40.0 1.0 3.0   10.0 0.0     0.0   3.0   23.0 34.0     *   *         *   57.0 40 1 3   10 0     0   3   23 34                 57
1826535 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 2020   grade_7 0.0 1.0 0.0   0.0 0.0     0.0   0.0   0.0 1.0     *   *         *   1.0 0 1 0   0 0     0   0   0 1                 1
1826557 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 2020   grade_7 1.0 31.0 5.0   0.0 0.0     0.0   5.0   32.0 10.0     18.0   *         *   42.0 1 31 5   0 0     0   5   32 10     18           42
1826594 MN Houston 28 school 2700178 4054 Charter Schools LA CRESCENT MONTESSORI ACADEMY 270017804750 20 La Crescent Secondary Montessori & STEM Academy Secondary School (Grades 7-12) Regular School Yes High 07 12 2020   grade_7 9.0 0.0 0.0   0.0 0.0     0.0   0.0   7.0 2.0     *   *         *   9.0 9 0 0   0 0     0   0   7 2                 9
1826609 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 2020   grade_7 1.0 0.0 0.0   0.0 0.0     0.0   1.0   1.0 1.0     *   *         *   2.0 1 0 0   0 0     0   1   1 1                 2
1826623 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 2020   grade_7 6.0 1.0 0.0   0.0 0.0     0.0   0.0   6.0 1.0     *   *         *   7.0 6 1 0   0 0     0   0   6 1                 7
1826639 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 2020   grade_7 9.0 0.0 0.0   0.0 0.0     0.0   0.0   2.0 7.0     *   *         *   9.0 9 0 0   0 0     0   0   2 7                 9
1826691 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 2020   grade_7 5.0 0.0 2.0   1.0 0.0     0.0   0.0   5.0 3.0     *   *         *   8.0 5 0 2   1 0     0   0   5 3                 8
1826724 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 2020   grade_7 1.0 0.0 0.0   0.0 0.0     0.0   0.0   1.0 0.0     *   *         *   1.0 1 0 0   0 0     0   0   1 0                 1
1826733 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 2020   grade_7 6.0 0.0 1.0   0.0 0.0     0.0   0.0   4.0 3.0     *   *         *   7.0 6 0 1   0 0     0   0   4 3                 7
1826740 MN Steele 74 school 2700389 4217 Charter Schools Technical Academies of Minnesota 270038904954 20 CHOICE Technical Academy Secondary School (Grades 7-12) Regular School Yes High 07 12 2020   grade_7 3.0 0.0 1.0   0.0 0.0     0.0   0.0   1.0 3.0     *   *         *   4.0 3 0 1   0 0     0   0   1 3                 4
1826764 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 2020   grade_7 1.0 6.0 0.0   0.0 0.0     0.0   0.0   6.0 1.0     *   *         *   7.0 1 6 0   0 0     0   0   6 1                 7
1827151 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 2020   grade_7 0.0 0.0 2.0   2.0 0.0     0.0   0.0   2.0 2.0     *   *         *   4.0 0 0 2   2 0     0   0   2 2                 4
1827229 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 2020   grade_7 0.0 0.0 0.0   18.0 0.0     0.0   0.0   9.0 9.0     *   *         *   18.0 0 0 0   18 0     0   0   9 9                 18
1829732 MN Olmsted 55 school 2731800 535 Independent Districts and Schools Rochester Public School District 273180001004 136 Jefferson Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 07 2020   grade_7 0.0 0.0 0.0   1.0 0.0     0.0   0.0   0.0 1.0     *   *         *   1.0 0 0 0   1 0     0   0   0 1                 1
1832326 MN Pipestone 59 school 2700108 2689 Independent Districts and Schools Pipestone Area School District 270010803015 6 Heartland Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 08 2020   grade_7 3.0 0.0 0.0   0.0 0.0     0.0   0.0   2.0 1.0     *   *         *   3.0 3 0 0   0 0     0   0   2 1                 3
1832793 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124001866 175 Folwell Arts Magnet Elementary School (Grades PK-6) Regular School No Elementary PK 08 2020   grade_7 9.0 18.0 58.0   5.0 0.0     1.0   2.0   49.0 44.0     29.0   *     77.0   22.0   93.0 9 18 58   5 0     1   2   49 44     29     77 22   93
1833132 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 2020   grade_7 3.0 0.0 0.0   0.0 0.0     0.0   0.0   2.0 1.0     *   *         *   3.0 3 0 0   0 0     0   0   2 1                 3
1833178 MN Crow Wing 18 school 2700218 4059 Charter Schools Crosslake Community Charter School 270021803475 10 Crosslake Community Charter School Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2020   grade_7 11.0 0.0 0.0   0.0 0.0     0.0   0.0   7.0 4.0     *   *         *   11.0 11 0 0   0 0     0   0   7 4                 11
1833323 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 2020   grade_7 8.0 0.0 0.0   0.0 0.0     0.0   0.0   3.0 5.0     *   *         *   8.0 8 0 0   0 0     0   0   3 5                 8
1833749 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 2020   grade_7 6.0 0.0 0.0   0.0 0.0     0.0   1.0   3.0 4.0     *   *         *   7.0 6 0 0   0 0     0   1   3 4                 7
1833831 MN Anoka 2 school 2700390 4224 Charter Schools Star of the North Academy Charter School 270039004759 10 Star of the North Academy Charter School Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2020   grade_7 1.0 4.0 0.0   0.0 2.0     0.0   0.0   3.0 4.0     *   *         *   7.0 1 4 0   0 2     0   0   3 4                 7
1833852 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 2020   grade_7 0.0 0.0 2.0   6.0 0.0     0.0   0.0   2.0 6.0     *   *         *   8.0 0 0 2   6 0     0   0   2 6                 8
1834182 MN Anoka 2 school 2709510 13 Independent Districts and Schools Columbia Heights Public School Dist 270951000395 17 Columbia Academy Middle School (Grades 5-8) Regular School No Middle 06 08 2020   grade_7 35.0 73.0 107.0   4.0 7.0     0.0   15.0   128.0 113.0     *   *         *   241.0 35 73 107   4 7     0   15   128 113                 241
1834231 MN Carlton 9 school 2709420 94 Independent Districts and Schools Cloquet Public School District 270942000381 201 Cloquet Middle Middle School (Grades 5-8) Regular School No Middle 05 08 2020   grade_7 143.0 0.0 6.0   27.0 1.0     0.0   36.0   106.0 107.0     *   *         *   213.0 143 0 6   27 1     0   36   106 107                 213
1834261 MN Cass 11 school 2708070 115 Independent Districts and Schools Cass Lake-Bena Public Schools 270807003181 20 Cass Lake-Bena Middle School Middle School (Grades 5-8) Regular School No Middle 05 08 2020   grade_7 6.0 0.0 1.0   81.0 0.0     0.0   0.0   49.0 39.0     *   *         *   88.0 6 0 1   81 0     0   0   49 39                 88
1834296 MN Crow Wing 18 school 2706090 181 Independent Districts and Schools Brainerd Public School District 270609004196 22 Forestview Middle Middle School (Grades 5-8) Regular School No Middle 05 08 2020   grade_7 443.0 8.0 12.0   9.0 1.0     0.0   15.0   225.0 263.0     1.0   *     182.0   *   488.0 443 8 12   9 1     0   15   225 263     1     182     488
1834325 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 2020   grade_7 255.0 14.0 20.0   1.0 13.0     1.0   18.0   163.0 159.0     *   *     39.0   33.0   322.0 255 14 20   1 13     1   18   163 159           39 33   322
1834345 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 2020   grade_7 328.0 22.0 20.0   1.0 31.0     0.0   28.0   208.0 222.0     *   *         38.0   430.0 328 22 20   1 31     0   28   208 222             38   430
1834353 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 2020   grade_7 255.0 54.0 31.0   0.0 52.0     0.0   35.0   217.0 210.0     16.0   *     74.0   55.0   427.0 255 54 31   0 52     0   35   217 210     16     74 55   427
1834362 MN Dakota 19 school 2742270 197 Independent Districts and Schools West St. Paul-Mendota Hts.-Eagan 274227002646 52 Friendly Hills Middle Middle School (Grades 5-8) Regular School No Middle 05 08 2020   grade_7 104.0 31.0 48.0   3.0 9.0     0.0   14.0   109.0 100.0     *   *         33.0   209.0 104 31 48   3 9     0   14   109 100             33   209
1834393 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 2020   grade_7 162.0 10.0 58.0   1.0 23.0     0.0   12.0   129.0 137.0     *   *         *   266.0 162 10 58   1 23     0   12   129 137                 266
1834448 MN Hennepin 27 school 2725200 279 Independent Districts and Schools Osseo Public School District 272520001217 34 Osseo Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2020   grade_7 196.0 83.0 11.0   9.0 41.0     0.0   31.0   199.0 172.0     14.0   *         48.0   371.0 196 83 11   9 41     0   31   199 172     14       48   371
1834464 MN Hennepin 27 school 2731780 281 Independent Districts and Schools Robbinsdale Public School District 273178001333 40 Plymouth Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2020   grade_7 144.0 86.0 62.0   2.0 18.0     0.0   25.0   168.0 169.0     23.0   *     135.0   36.0   337.0 144 86 62   2 18     0   25   168 169     23     135 36   337
1834472 MN Hennepin 27 school 2731780 281 Independent Districts and Schools Robbinsdale Public School District 273178005115 45 Sandburg Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2020   grade_7 84.0 62.0 34.0   3.0 15.0     0.0   31.0   120.0 109.0     22.0   *     132.0   29.0   229.0 84 62 34   3 15     0   31   120 109     22     132 29   229
1834496 MN Hennepin 27 school 2706240 286 Independent Districts and Schools Brooklyn Center School District 270624005130 11 Brooklyn Center Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2020   grade_7 4.0 57.0 27.0   2.0 29.0     0.0   8.0   70.0 57.0     *   *         *   127.0 4 57 27   2 29     0   8   70 57                 127
1834533 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 2020   grade_7 136.0 48.0 114.0   0.0 9.0     1.0   2.0   147.0 163.0     60.0   *     187.0   44.0   310.0 136 48 114   0 9     1   2   147 163     60     187 44   310
1834547 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 2020   grade_7 198.0 1.0 16.0   0.0 3.0     0.0   8.0   111.0 115.0     *   *     53.0   *   226.0 198 1 16   0 3     0   8   111 115           53     226
1834561 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 2020   grade_7 257.0 0.0 5.0   3.0 0.0     0.0   7.0   135.0 137.0     *   *         *   272.0 257 0 5   3 0     0   7   135 137                 272
1834568 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 2020   grade_7 17.0 0.0 3.0   21.0 0.0     0.0   5.0   20.0 26.0     *   *         *   46.0 17 0 3   21 0     0   5   20 26                 46
1834599 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 2020   grade_7 120.0 18.0 28.0   1.0 3.0     0.0   3.0   106.0 67.0     *   *         *   173.0 120 18 28   1 3     0   3   106 67                 173
1834608 MN Nobles 53 school 2744160 518 Independent Districts and Schools Worthington Public School District 274416001840 4 Worthington Middle Middle School (Grades 5-8) Regular School No Middle 05 08 2020   grade_7 59.0 15.0 148.0   0.0 23.0     0.0   5.0   117.0 133.0     *   *     188.0   37.0   250.0 59 15 148   0 23     0   5   117 133           188 37   250
1834628 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 2020   grade_7 3.0 2.0 1.0   0.0 0.0     0.0   0.0   5.0 1.0     *   *         *   6.0 3 2 1   0 0     0   0   5 1                 6
1834675 MN Washington 82 school 2723850 622 Independent Districts and Schools North St. Paul-Maplewood Oakdale Public School District 272385002666 54 Skyview Community Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2020   grade_7 101.0 54.0 37.0   0.0 43.0     0.0   16.0   131.0 120.0     12.0   *     121.0   *   251.0 101 54 37   0 43     0   16   131 120     12     121     251
1834795 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 2020   grade_7 143.0 10.0 21.0   0.0 2.0     0.0   14.0   92.0 98.0     5.0   *     31.0   30.0   190.0 143 10 21   0 2     0   14   92 98     5     31 30   190
1834827 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 2020   grade_7 175.0 1.0 22.0   0.0 0.0     0.0   3.0   106.0 95.0     *   *         *   201.0 175 1 22   0 0     0   3   106 95                 201
1834866 MN Washington 82 school 2738190 834 Independent Districts and Schools Stillwater Area Public School Dist. 273819001660 48 Oak-Land Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2020   grade_7 234.0 25.0 31.0   0.0 26.0     0.0   9.0   160.0 165.0     10.0   *     68.0   39.0   325.0 234 25 31   0 26     0   9   160 165     10     68 39   325
1834870 MN Washington 82 school 2738190 834 Independent Districts and Schools Stillwater Area Public School Dist. 273819001661 49 Stillwater Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2020   grade_7 277.0 11.0 11.0   0.0 6.0     0.0   19.0   160.0 164.0     1.0   *     50.0   48.0   324.0 277 11 11   0 6     0   19   160 164     1     50 48   324
1834951 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 2020   grade_7 90.0 2.0 6.0   0.0 2.0     0.0   2.0   55.0 47.0     *   *         *   102.0 90 2 6   0 2     0   2   55 47                 102
1834968 MN Lesueur 40 school 2718070 2397 Independent Districts and Schools Le Sueur-Henderson School District 271807004408 21 Le Sueur-Henderson Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2020   grade_7 60.0 2.0 11.0   0.0 0.0     0.0   3.0   38.0 38.0     0.0   *         *   76.0 60 2 11   0 0     0   3   38 38     0           76
1834987 MN Pipestone 59 school 2700108 2689 Independent Districts and Schools Pipestone Area School District 270010801264 7 Pipestone Middle Middle School (Grades 5-8) Regular School No Middle 05 08 2020   grade_7 59.0 2.0 12.0   0.0 0.0     0.0   5.0   48.0 30.0     *   *         *   78.0 59 2 12   0 0     0   5   48 30                 78
1835544 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 2020   grade_7 5.0 0.0 0.0   0.0 0.0     0.0   0.0   3.0 2.0     *   *         *   5.0 5 0 0   0 0     0   0   3 2                 5
1836110 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 2020   grade_7 0.0 1.0 0.0   0.0 0.0     0.0   0.0   1.0 0.0     *   *         *   1.0 0 1 0   0 0     0   0   1 0                 1
1836285 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 2020   grade_7 0.0 1.0 1.0   0.0 0.0     0.0   0.0   1.0 1.0     *   *         *   2.0 0 1 1   0 0     0   0   1 1                 2
1836305 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 2020   grade_7 107.0 0.0 6.0   0.0 7.0     0.0   10.0   72.0 58.0     9.0   *     43.0   *   130.0 107 0 6   0 7     0   10   72 58     9     43     130
1836332 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 2020   grade_7 0.0 0.0 0.0   3.0 0.0     0.0   0.0   2.0 1.0     *   *         *   3.0 0 0 0   3 0     0   0   2 1                 3
1836347 MN Carlton 9 school 2709420 94 Independent Districts and Schools Cloquet Public School District 270942002236 103 CLOQUET AREA ALT. ED. PROGRAMS Public Area Learning Center ALC (State approved) Alternative School No Other 01 12 2020   grade_7 0.0 0.0 0.0   0.0 0.0     0.0   1.0   1.0 0.0     *   *         *   1.0 0 0 0   0 0     0   1   1 0                 1
1836374 MN Cass 11 school 2708070 115 Independent Districts and Schools Cass Lake-Bena Public Schools 270807002234 31 Cass Lake-Bena Area Lrng. Cntr. Public Area Learning Center ALC (State approved) Alternative School No High 07 12 2020   grade_7 0.0 0.0 0.0   1.0 0.0     0.0   0.0   1.0 0.0     *   *         *   1.0 0 0 0   1 0     0   0   1 0                 1
1836397 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 2020   grade_7 4.0 0.0 0.0   0.0 0.0     0.0   0.0   0.0 4.0     *   *         *   4.0 4 0 0   0 0     0   0   0 4                 4
1836425 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 2020   grade_7 4.0 0.0 1.0   0.0 0.0     0.0   0.0   3.0 2.0     *   *         *   5.0 4 0 1   0 0     0   0   3 2                 5
1836443 MN Hennepin 27 school 2731780 281 Independent Districts and Schools Robbinsdale Public School District 273178004630 903 Robbinsdale TASC ALC Public Area Learning Center ALC (State approved) Alternative School No High 07 12 2020   grade_7 0.0 1.0 0.0   0.0 0.0     0.0   0.0   0.0 1.0     *   *         *   1.0 0 1 0   0 0     0   0   0 1                 1
1836451 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 2020   grade_7 4.0 6.0 1.0   0.0 2.0     0.0   2.0   8.0 7.0     *   *         0.0   15.0 4 6 1   0 2     0   2   8 7             0   15
1836454 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 2020   grade_7 3.0 4.0 0.0   0.0 0.0     0.0   1.0   6.0 2.0     *   *         *   8.0 3 4 0   0 0     0   1   6 2                 8
1836487 MN Kandiyohi 34 school 2742720 347 Independent Districts and Schools Willmar Public School District 274272000950 949 Willmar Area Learning Center Public Area Learning Center ALC (State approved) Alternative School No High 07 12 2020   grade_7 0.0 1.0 3.0   0.0 0.0     0.0   0.0   4.0 0.0     *   *         *   4.0 0 1 3   0 0     0   0   4 0                 4
1836554 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 2020   grade_7 0.0 0.0 0.0   0.0 1.0     0.0   0.0   1.0 0.0     *   *         *   1.0 0 0 0   0 1     0   0   1 0                 1
1836578 MN Otter Tail 56 school 2728170 548 Independent Districts and Schools Pelican Rapids Public School Dist. 272817004487 60 Pelican Rapids Alt Center Mid-Level Public Area Learning Center ALC (State approved) Alternative School No Middle 07 10 2020   grade_7 6.0 2.0 6.0   0.0 0.0     0.0   0.0   6.0 8.0     *   *     9.0   *   14.0 6 2 6   0 0     0   0   6 8           9     14
1836679 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 2020   grade_7 1.0 0.0 0.0   0.0 0.0     0.0   0.0   1.0 0.0     *   *         *   1.0 1 0 0   0 0     0   0   1 0                 1
1836734 MN Pine 58 school 2711085 2580 Independent Districts and Schools East Central School District 271108500222 35 Crossroads Area Learning Center Public Area Learning Center ALC (State approved) Alternative School No High 07 12 2020   grade_7 0.0 0.0 0.0   0.0 0.0     0.0   1.0   1.0 0.0     *   *         *   1.0 0 0 0   0 0     0   1   1 0                 1
1836853 MN Olmsted 55 school 2700054 6012 Education Districts Zumbro Education District 270005402492 20 Zumbro Area Learning Center Public Area Learning Center ALC (State approved) Alternative School No High 06 12 2020   grade_7 2.0 1.0 0.0   0.0 0.0     0.0   0.0   1.0 2.0     *   *         *   3.0 2 1 0   0 0     0   0   1 2                 3
1836869 MN Chippewa 12 school 2700058 6018 Education Districts MN River Valley Education District 270005802245 20 MN River Valley ALC-Seatbased Public Area Learning Center ALC (State approved) Alternative School No High 07 12 2020   grade_7 0.0 0.0 1.0   0.0 0.0     0.0   0.0   1.0 0.0     *   *         *   1.0 0 0 1   0 0     0   0   1 0                 1
1836876 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 2020   grade_7 1.0 0.0 0.0   0.0 0.0     0.0   0.0   1.0 0.0     *   *         *   1.0 1 0 0   0 0     0   0   1 0                 1
1836883 MN Brown 8 school 2791353 6049 Education Districts River Bend Education District 279135302494 20 River Bend Area Learning Center Public Area Learning Center ALC (State approved) Alternative School No High 07 12 2020   grade_7 1.0 0.0 0.0   0.0 0.0     0.0   0.0   0.0 1.0     *   *         *   1.0 1 0 0   0 0     0   0   0 1                 1
1836904 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 2020   grade_7 0.0 0.0 0.0   0.0 0.0     0.0   1.0   1.0 0.0     *   *         *   1.0 0 0 0   0 0     0   1   1 0                 1
1836929 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000005 467 River Trail Learning Ctr @ LO Jacob Special Education Special Education School No Other KG 12 2020   grade_7 5.0 1.0 1.0   0.0 0.0     0.0   0.0   6.0 1.0     *   *         *   7.0 5 1 1   0 0     0   0   6 1                 7
1836958 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 2020   grade_7 0.0 0.0 0.0   1.0 0.0     0.0   0.0   1.0 0.0     *   *         *   1.0 0 0 0   1 0     0   0   1 0                 1
1836976 MN Blue Earth 7 school 2718780 77 Independent Districts and Schools Mankato Public School District 271878004374 370 Futures Program Special Education Special Education School No Other KG 12 2020   grade_7 3.0 0.0 1.0   0.0 0.0     0.0   0.0   4.0 0.0     *   *         *   4.0 3 0 1   0 0     0   0   4 0                 4
1837028 MN Dakota 19 school 2742270 197 Independent Districts and Schools West St. Paul-Mendota Hts.-Eagan 274227005008 827 Special Education Special Education Special Education School No Other KG 12 2020   grade_7 1.0 0.0 0.0   0.0 0.0     0.0   0.0   1.0 0.0     *   *         *   1.0 1 0 0   0 0     0   0   1 0                 1
1837072 MN Hennepin 27 school 2725200 279 Independent Districts and Schools Osseo Public School District 272520003593 45 Achieve Special Education Special Education School No Other KG 12 2020   grade_7 1.0 0.0 0.0   0.0 0.0     0.0   0.0   1.0 0.0     *   *         *   1.0 1 0 0   0 0     0   0   1 0                 1
1837155 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 2020   grade_7 0.0 3.0 0.0   0.0 0.0     0.0   3.0   2.0 4.0     *   *         *   6.0 0 3 0   0 0     0   3   2 4                 6
1837173 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 2020   grade_7 4.0 2.0 0.0   0.0 0.0     0.0   0.0   6.0 0.0     *   *         *   6.0 4 2 0   0 0     0   0   6 0                 6
1837199 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 2020   grade_7 2.0 3.0 0.0   0.0 0.0     0.0   2.0   4.0 3.0     *   *         *   7.0 2 3 0   0 0     0   2   4 3                 7
1837224 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 2020   grade_7 1.0 4.0 0.0   0.0 4.0     0.0   0.0   7.0 2.0     *   *         *   9.0 1 4 0   0 4     0   0   7 2                 9
1837237 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 Elementary KG 08 2020   grade_7 1.0 5.0 1.0   0.0 0.0     0.0   1.0   7.0 1.0     *   *         *   8.0 1 5 1   0 0     0   1   7 1                 8
1837302 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 02 12 2020   grade_7 2.0 0.0 0.0   0.0 0.0     0.0   2.0   4.0 0.0     *   *         *   4.0 2 0 0   0 0     0   2   4 0                 4
1837398 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 2020   grade_7 2.0 0.0 0.0   0.0 0.0     0.0   0.0   0.0 2.0     *   *         *   2.0 2 0 0   0 0     0   0   0 2                 2
1837412 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 2020   grade_7 5.0 0.0 2.0   0.0 0.0     0.0   0.0   2.0 5.0     *   *         *   7.0 5 0 2   0 0     0   0   2 5                 7
1837439 MN Hennepin 27 school 2700025 287 Intermediate Districts and Schools Intermediate School District 287 270002503213 440 Options Mid/Elem EBD Special Education Special Education School No Other KG 09 2020   grade_7 1.0 6.0 0.0   0.0 0.0     0.0   0.0   5.0 2.0     *   *         *   7.0 1 6 0   0 0     0   0   5 2                 7
1837453 MN Hennepin 27 school 2700025 287 Intermediate Districts and Schools Intermediate School District 287 270002503226 465 Sun Special Education Special Education School No Other KG 12 2020   grade_7 1.0 3.0 0.0   0.0 0.0     0.0   1.0   3.0 2.0     *   *         *   5.0 1 3 0   0 0     0   1   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]);