Data source: Big Local News · About: Big Local

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

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
1825236 MN Anoka 2 school 2733330 16 Independent Districts and Schools Spring Lake Park Public Schools 273333004658 788 Secondary Lighthouse Secondary School (Grades 7-12) Regular School No High 07 12 2020   grade_7 9.0 1.0 1.0   0.0 2.0     0.0   2.0   8.0 7.0     *   0.0         *   15.0 9 1 1   0 2     0   2   8 7       0         15
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
1825865 MN Ramsey 62 school 2733840 625 Independent Districts and Schools St. Paul Public School District 273384001598 225 HUMBOLDT HIGH SCHOOL Secondary School (Grades 7-12) Regular School No High 06 12 2020   grade_7 15.0 38.0 28.0   1.0 72.0     0.0   3.0   78.0 79.0     72.0   1.0         22.0   157.0 15 38 28   1 72     0   3   78 79     72 1     22   157
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
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
1826519 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124004903 390 Heritage STEM Academy Secondary School (Grades 7-12) Regular School No High 06 12 2020   grade_7 0.0 13.0 0.0   0.0 0.0     0.0   0.0   5.0 8.0     5.0   1.0         0.0   13.0 0 13 0   0 0     0   0   5 8     5 1     0   13
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
1826564 MN Ramsey 62 school 2700140 4027 Charter Schools Higher Ground Academy 270014004749 30 Higher Ground Secondary Academy Secondary School (Grades 7-12) Regular School Yes High 07 12 2020   grade_7 0.0 94.0 0.0   0.0 0.0     0.0   0.0   45.0 49.0     13.0   0.0         4.0   94.0 0 94 0   0 0     0   0   45 49     13 0     4   94
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
1826748 MN Hennepin 27 school 2700384 4218 Charter Schools Venture Academy 270038404697 10 Venture Academy Secondary School (Grades 7-12) Regular School Yes High 06 12 2020   grade_7 1.0 8.0 24.0   8.0 0.0     0.0   0.0   15.0 26.0     12.0   4.0         4.0   41.0 1 8 24   8 0     0   0   15 26     12 4     4   41
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
1828895 MN Hennepin 27 school 2731780 281 Independent Districts and Schools Robbinsdale Public School District 273178004952 401 The FAIR School - Crystal Elementary School (Grades PK-6) Regular School No Middle 05 08 2020   grade_7 29.0 47.0 12.0   1.0 1.0     0.0   14.0   49.0 55.0     *   3.0         *   104.0 29 47 12   1 1     0   14   49 55       3         104
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
1832824 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124000932 190 Andersen Community Elementary School (Grades PK-6) Regular School No Elementary PK 08 2020   grade_7 3.0 27.0 55.0   3.0 2.0     0.0   1.0   48.0 43.0     43.0   5.0         22.0   91.0 3 27 55   3 2     0   1   48 43     43 5     22   91
1832990 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 2020   grade_7 0.0 14.0 1.0   0.0 0.0     0.0   1.0   10.0 6.0     7.0   0.0         3.0   16.0 0 14 1   0 0     0   1   10 6     7 0     3   16
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
1833408 MN Olmsted 55 school 2700247 4135 Charter Schools Rochester Math And Science Academy 270024703308 10 Rochester Math And Science Academy Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2020   grade_7 0.0 45.0 0.0   0.0 0.0     0.0   0.0   27.0 18.0     9.0   0.0         6.0   45.0 0 45 0   0 0     0   0   27 18     9 0     6   45
1833426 MN Hennepin 27 school 2700273 4139 Charter Schools LoveWorks Academy For Arts 270027303575 10 LoveWorks Academy For Arts Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2020   grade_7 0.0 16.0 1.0   0.0 0.0     0.0   2.0   11.0 8.0     0.0   1.0         4.0   19.0 0 16 1   0 0     0   2   11 8     0 1     4   19
1833490 MN Ramsey 62 school 2700263 4153 Charter Schools Dugsi Academy 270026303320 10 Dugsi Academy Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2020   grade_7 0.0 36.0 0.0   0.0 0.0     0.0   0.0   18.0 18.0     26.0   0.0         3.0   36.0 0 36 0   0 0     0   0   18 18     26 0     3   36
1833603 MN Ramsey 62 school 2700304 4181 Charter Schools Community School of Excellence 270030403728 10 Community School of Excellence Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2020   grade_7 0.0 0.0 0.0   0.0 148.0     0.0   0.0   82.0 66.0     59.0   0.0         18.0   148.0 0 0 0   0 148     0   0   82 66     59 0     18   148
1833678 MN Hennepin 27 school 2700309 4192 Charter Schools Best Academy 270030904261 10 Best Academy Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2020   grade_7 0.0 66.0 1.0   0.0 0.0     0.0   2.0   35.0 34.0     14.0   7.0         12.0   69.0 0 66 1   0 0     0   2   35 34     14 7     12   69
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
1833759 MN Hennepin 27 school 2700373 4209 Charter Schools Mastery School 270037304602 10 Mastery School Elementary School (Grades PK-6) Regular School Yes Elementary KG 07 2020   grade_7 0.0 20.0 0.0   0.0 0.0     0.0   1.0   13.0 8.0     0.0   0.0         9.0   21.0 0 20 0   0 0     0   1   13 8     0 0     9   21
1833784 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 2020   grade_7 0.0 1.0 0.0   0.0 18.0     0.0   0.0   9.0 10.0     15.0   0.0         1.0   19.0 0 1 0   0 18     0   0   9 10     15 0     1   19
1833794 MN Hennepin 27 school 2700398 4219 Charter Schools Northeast College Prep 270039804757 10 Northeast College Prep Charter School Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2020   grade_7 3.0 23.0 4.0   0.0 0.0     0.0   0.0   13.0 17.0     6.0   0.0         5.0   30.0 3 23 4   0 0     0   0   13 17     6 0     5   30
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
1833842 MN Hennepin 27 school 2700393 4225 Charter Schools Universal Academy Charter School 270039304758 10 Universal Academy Charter School Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2020   grade_7 0.0 25.0 0.0   0.0 0.0     0.0   0.0   15.0 10.0     19.0   0.0         0.0   25.0 0 25 0   0 0     0   0   15 10     19 0     0   25
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
1833916 MN Ramsey 62 school 2700410 4240 Charter Schools New Century School 270041004873 10 New Century School Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2020   grade_7 0.0 31.0 0.0   0.0 0.0     0.0   0.0   17.0 14.0     25.0   0.0         0.0   31.0 0 31 0   0 0     0   0   17 14     25 0     0   31
1833926 MN Ramsey 62 school 2700423 4243 Charter Schools North Metro Flex Academy 270042304942 10 North Metro Flex Academy Elementary School (Grades PK-6) Regular School Yes Elementary KG 07 2020   grade_7 2.0 6.0 2.0   0.0 0.0     0.0   0.0   5.0 5.0     2.0   0.0         6.0   10.0 2 6 2   0 0     0   0   5 5     2 0     6   10
1833987 MN Hennepin 27 school 2700439 4261 Charter Schools SciTech Academy Charter School 270043905072 10 SciTech Academy Charter School Elementary School (Grades PK-6) Regular School Yes Elementary KG 07 2020   grade_7 0.0 23.0 0.0   0.0 0.0     0.0   0.0   16.0 7.0     *   0.0         6.0   23.0 0 23 0   0 0     0   0   16 7       0     6   23
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
1834187 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 2020   grade_7 41.0 77.0 25.0   1.0 12.0     0.0   15.0   74.0 97.0     21.0   2.0         26.0   171.0 41 77 25   1 12     0   15   74 97     21 2     26   171
1834191 MN Anoka 2 school 2733540 15 Independent Districts and Schools St. Francis Area Schools 273354000013 123 St. Francis Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2020   grade_7 160.0 1.0 10.0   4.0 7.0     0.0   12.0   101.0 93.0     *   0.0         *   194.0 160 1 10   4 7     0   12   101 93       0         194
1834196 MN Anoka 2 school 2733330 16 Independent Districts and Schools Spring Lake Park Public Schools 273333001466 92 Westwood Intermediate and Middle School Middle School (Grades 5-8) Regular School No Middle 05 08 2020   grade_7 261.0 67.0 72.0   5.0 30.0     2.0   32.0   251.0 218.0     *   6.0         *   469.0 261 67 72   5 30     2   32   251 218       6         469
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
1834333 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 2020   grade_7 248.0 10.0 10.0   2.0 21.0     0.0   19.0   154.0 156.0     0.0   1.0         *   310.0 248 10 10   2 21     0   19   154 156     0 1         310
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
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
1834456 MN Hennepin 27 school 2725200 279 Independent Districts and Schools Osseo Public School District 272520002278 94 Maple Grove Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2020   grade_7 370.0 70.0 46.0   3.0 49.0     0.0   33.0   304.0 267.0     *   1.0         56.0   571.0 370 70 46   3 49     0   33   304 267       1     56   571
1834484 MN Hennepin 27 school 2742160 284 Independent Districts and Schools Wayzata Public School District 274216001764 51 Wayzata West Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2020   grade_7 165.0 14.0 13.0   1.0 49.0     0.0   19.0   128.0 133.0     *   1.0         21.0   261.0 165 14 13   1 49     0   19   128 133       1     21   261
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
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
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
1834637 MN Olmsted 55 school 2731800 535 Independent Districts and Schools Rochester Public School District 273180001020 335 Kellogg Middle Middle School (Grades 5-8) Regular School No Middle 05 08 2020   grade_7 240.0 42.0 32.0   1.0 49.0     0.0   21.0   193.0 192.0     *   4.0         48.0   385.0 240 42 32   1 49     0   21   193 192       4     48   385
1834787 MN Hennepin 27 school 2711370 728 Independent Districts and Schools Elk River School District 271137002844 340 Rogers Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2020   grade_7 194.0 4.0 9.0   0.0 7.0     0.0   13.0   114.0 113.0     5.0   0.0         25.0   227.0 194 4 9   0 7     0   13   114 113     5 0     25   227
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
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
1835013 MN Nobles 53 school 2700388 2907 Independent Districts and Schools Round Lake-Brewster Public Schools 270038804737 20 Round Lake-Brewster Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2020   grade_7 7.0 0.0 19.0   0.0 0.0     0.0   1.0   13.0 14.0     5.0   0.0         2.0   27.0 7 0 19   0 0     0   1   13 14     5 0     2   27
1835059 MN Ramsey 62 school 2700142 4029 Charter Schools St. Paul City School 270014204150 20 St. Paul City Middle School Middle School (Grades 5-8) Regular School Yes Middle 06 08 2020   grade_7 1.0 13.0 22.0   1.0 12.0     0.0   3.0   22.0 30.0     16.0   3.0         9.0   52.0 1 13 22   1 12     0   3   22 30     16 3     9   52
1835073 MN Hennepin 27 school 2700189 4078 Charter Schools Twin Cities International Schools 270018903142 10 Minnesota International Middle Charter School Middle School (Grades 5-8) Regular School Yes Middle 05 08 2020   grade_7 1.0 103.0 0.0   0.0 0.0     0.0   0.0   40.0 64.0     42.0   0.0         9.0   104.0 1 103 0   0 0     0   0   40 64     42 0     9   104
1835103 MN Hennepin 27 school 2700245 4131 Charter Schools Metro Schools Charter 270024504857 20 Metro Schools Middle Charter Middle School (Grades 5-8) Regular School Yes Middle 05 08 2020   grade_7 0.0 37.0 0.0   0.0 0.0     0.0   0.0   22.0 15.0     25.0   0.0         3.0   37.0 0 37 0   0 0     0   0   22 15     25 0     3   37
1835130 MN Hennepin 27 school 2700308 4191 Charter Schools KIPP Minnesota Charter School 270030804244 10 KIPP North Star Academy Middle School (Grades 5-8) Regular School Yes Middle 05 08 2020   grade_7 2.0 54.0 1.0   1.0 0.0     0.0   0.0   27.0 31.0     0.0   2.0         18.0   58.0 2 54 1   1 0     0   0   27 31     0 2     18   58
1835139 MN Hennepin 27 school 2700335 4205 Charter Schools Hennepin Elementary School 270033505203 20 Hennepin Middle School Middle School (Grades 5-8) Regular School Yes Middle 06 08 2020   grade_7 0.0 26.0 9.0   0.0 0.0     0.0   0.0   16.0 19.0     13.0   0.0         5.0   35.0 0 26 9   0 0     0   0   16 19     13 0     5   35
1835153 MN Ramsey 62 school 2700399 4231 Charter Schools Minnesota Math and Science Academy 270039905177 20 MMSA Middle School Middle School (Grades 5-8) Regular School Yes Middle 05 08 2020   grade_7 1.0 44.0 0.0   0.0 1.0     0.0   0.0   24.0 22.0     27.0   0.0         6.0   46.0 1 44 0   0 1     0   0   24 22     27 0     6   46
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
1836299 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 2020   grade_7 5.0 5.0 0.0   1.0 0.0     0.0   1.0   7.0 5.0     0.0   0.0         0.0   12.0 5 5 0   1 0     0   1   7 5     0 0     0   12
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
1836506 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 2020   grade_7 9.0 1.0 3.0   0.0 0.0     0.0   2.0   8.0 7.0     *   0.0         *   15.0 9 1 3   0 0     0   2   8 7       0         15
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
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

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