Data source: Big Local News · About: Big Local

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

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
1712959 MN Sibley 72 school 2700092 4007 Charter Schools Minnesota New Country School 270009202487 10 Minnesota New Country School Secondary School (Grades 7-12) Regular School Yes High 07 12 2021   grade_7 15 0 1   0 0     0   0   9 7     0.0   0.0     3.0   7.0   16 15 0 1   0 0     0   0   9 7     0 0   3 7   16
1712966 MN Anoka 2 school 2700093 4008 Charter Schools PACT Charter School 270009303030 30 PACT Charter Secondary Secondary School (Grades 7-12) Regular School Yes High 07 12 2021   grade_7 50 1 0   0 0     0   2   23 30     2.0   0.0     5.0   10.0   53 50 1 0   0 0     0   2   23 30     2 0   5 10   53
1712973 MN Hennepin 27 school 2700117 4017 Charter Schools Minnesota Transitions Charter School 270011703262 12 MTS High School Secondary School (Grades 7-12) Regular School Yes High 07 12 2021   grade_7 5 5 2   1 0     0   5   7 11     0.0   *     *   2.0   18 5 5 2   1 0     0   5   7 11     0       2   18
1712980 MN Hennepin 27 school 2700117 4017 Charter Schools Minnesota Transitions Charter School 270011705279 27 Banaadir Secondary Secondary School (Grades 7-12) Regular School Yes High 07 12 2021   grade_7 0 22 0   0 0     0   0   9 13     *   0.0     *   3.0   22 0 22 0   0 0     0   0   9 13       0     3   22
1712986 MN Ramsey 62 school 2700140 4027 Charter Schools Higher Ground Academy 270014004749 30 Higher Ground Secondary Academy Secondary School (Grades 7-12) Regular School Yes High 07 12 2021   grade_7 0 86 0   0 0     0   0   42 44     33.0   0.0     *   3.0   86 0 86 0   0 0     0   0   42 44     33 0     3   86
1712999 MN Washington 82 school 2700167 4043 Charter Schools Math And Science Academy 270016703035 10 Math And Science Academy Secondary School (Grades 7-12) Regular School Yes High 06 12 2021   grade_7 42 12 1   0 31     0   1   38 49     1.0   0.0     2.0   10.0   87 42 12 1   0 31     0   1   38 49     1 0   2 10   87
1713016 MN Houston 28 school 2700178 4054 Charter Schools La Crescent Montessori & STEM School 270017804750 20 La Crescent Secondary Montessori & STEM Academy Secondary School (Grades 7-12) Regular School Yes High 07 12 2021   grade_7 10 0 0   0 0     0   0   4 6     0.0   0.0     0.0   1.0   10 10 0 0   0 0     0   0   4 6     0 0   0 1   10
1713023 MN Winona 85 school 2700221 4064 Charter Schools Riverway Learning Community Charter 270022103136 20 Riverway Secondary Secondary School (Grades 7-12) Regular School Yes High 07 12 2021   grade_7 7 0 0   0 0     0   3   10 0     *   *     7.0   5.0   10 7 0 0   0 0     0   3   10 0           7 5   10
1713031 MN Blue Earth 7 school 2700226 4066 Charter Schools Kato Public Charter School 270022603471 10 Kato Public Charter School Secondary School (Grades 7-12) Regular School Yes High 06 12 2021   grade_7 2 1 0   0 0     0   0   3 0     *   *     *   *   3 2 1 0   0 0     0   0   3 0                 3
1713044 MN Cass 11 school 2700191 4080 Charter Schools Pillager Area Charter School 270019103144 10 PILLAGER AREA CHARTER SCHOOL Secondary School (Grades 7-12) Regular School Yes High 07 12 2021   grade_7 1 0 0   0 0     0   0   1 0     *   *     *   *   1 1 0 0   0 0     0   0   1 0                 1
1713052 MN Rice 66 school 2700192 4081 Charter Schools Discovery Public School Faribault 270019203145 10 Discovery Public School Faribault Secondary School (Grades 7-12) Regular School Yes High 06 12 2021   grade_7 1 0 1   0 0     0   0   1 1     *   *     *   *   2 1 0 1   0 0     0   0   1 1                 2
1713060 MN Rice 66 school 2700355 4091 Charter Schools Arcadia Charter School 270035504151 10 Arcadia Charter School Secondary School (Grades 7-12) Regular School Yes High 06 12 2021   grade_7 9 0 2   0 0     0   1   8 4     0.0   0.0     4.0   5.0   12 9 0 2   0 0     0   1   8 4     0 0   4 5   12
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
1713076 MN Ramsey 62 school 2700337 4098 Charter Schools Nova Classical Academy 270033704356 20 NOVA CLASSICAL ACADEMY UPPER SCHOOL Secondary School (Grades 7-12) Regular School Yes High 06 12 2021   grade_7 49 7 9   0 10     0   9   44 40     5.0   0.0     4.0   8.0   84 49 7 9   0 10     0   9   44 40     5 0   4 8   84
1713083 MN Ramsey 62 school 2700344 4105 Charter Schools Great River School 270034404093 10 Great River School Secondary School (Grades 7-12) Regular School Yes High 07 12 2021   grade_7 46 5 6   0 6     0   3   35 31     0.0   0.0     7.0   17.0   66 46 5 6   0 6     0   3   35 31     0 0   7 17   66
1713091 MN Washington 82 school 2700358 4116 Charter Schools Lakes International Language Academy 270035804828 20 Lakes International Language Academy-Headwaters Campus Secondary School (Grades 7-12) Regular School Yes High 06 12 2021   grade_7 90 2 10   1 3     0   5   58 53     0.0   0.0     11.0   18.0   111 90 2 10   1 3     0   5   58 53     0 0   11 18   111
1713104 MN Hennepin 27 school 2700364 4122 Charter Schools Eagle Ridge Academy Charter School 270036404108 10 Eagle Ridge Academy Charter School Secondary School (Grades 7-12) Regular School Yes High 06 12 2021   grade_7 50 34 3   0 30     0   2   57 62     11.0   0.0     30.0   5.0   119 50 34 3   0 30     0   2   57 62     11 0   30 5   119
1713112 MN Ramsey 62 school 2700246 4132 Charter Schools Twin Cities Academy 270024603307 10 Twin Cities Academy Secondary School (Grades 7-12) Regular School Yes High 06 12 2021   grade_7 22 28 27   0 20     0   9   52 54     18.0   2.0     61.0   16.0   106 22 28 27   0 20     0   9   52 54     18 2   61 16   106
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
1713147 MN Ramsey 62 school 2700367 4200 Charter Schools STEP Academy Charter School 270036704507 10 STEP ACADEMY CHARTER SCHOOL Secondary School (Grades 7-12) Regular School Yes High 06 12 2021   grade_7 0 51 0   0 0     0   0   22 29     14.0   0.0     30.0   5.0   51 0 51 0   0 0     0   0   22 29     14 0   30 5   51
1713154 MN Saint Louis 69 school 2700372 4207 Charter Schools Vermilion Country School 270037204555 10 Vermilion Country School Secondary School (Grades 7-12) Regular School Yes High 07 12 2021   grade_7 1 0 0   1 0     0   0   1 1     *   *     *   *   2 1 0 0   1 0     0   0   1 1                 2
1713164 MN Kandiyohi 34 school 2700389 4217 Charter Schools Technical Academies of Minnesota 270038904696 10 DREAM Technical Academy Secondary School (Grades 7-12) Regular School Yes High 07 12 2021   grade_7 3 0 2   0 0     0   0   1 4     *   *     *   *   5 3 0 2   0 0     0   0   1 4                 5
1713178 MN Hennepin 27 school 2700384 4218 Charter Schools Venture Academy 270038404697 10 Venture Academy Secondary School (Grades 7-12) Regular School Yes High 06 12 2021   grade_7 0 13 16   6 0     0   0   18 17     9.0   1.0     *   8.0   35 0 13 16   6 0     0   0   18 17     9 1     8   35
1713186 MN Wright 86 school 2700403 4229 Charter Schools Jane Goodall Environmental Science Academy 270040304850 10 Jane Goodall Environmental Science Academy Secondary School (Grades 7-12) Regular School Yes High 06 12 2021   grade_7 9 0 0   0 0     0   0   4 5     *   *     *   *   9 9 0 0   0 0     0   0   4 5                 9
1713194 MN Ramsey 62 school 2700402 4237 Charter Schools Career Pathways 270040204836 10 Career Pathways Secondary School (Grades 7-12) Regular School Yes High 06 12 2021   grade_7 1 1 0   0 0     0   0   1 1     *   *     *   *   2 1 1 0   0 0     0   0   1 1                 2
1713202 MN Olmsted 55 school 2700412 4238 Charter Schools Rochester Beacon Academy 270041204878 10 Rochester Beacon Academy Secondary School (Grades 7-12) Regular School Yes High 06 12 2021   grade_7 15 0 4   1 1     0   1   16 6     0.0   0.0     6.0   19.0   22 15 0 4   1 1     0   1   16 6     0 0   6 19   22
1719434 MN Winona 85 school 2705850 4001 Charter Schools Bluffview Montessori 270585000018 10 Bluffview Montessori Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2021   grade_7 17 0 1   0 0     0   2   8 12     1.0   0.0     7.0   3.0   20 17 0 1   0 0     0   2   8 12     1 0   7 3   20
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
1719471 MN Hennepin 27 school 2700096 4011 Charter Schools Athlos Leadership Academy 270009601892 10 Athlos Leadership Academy Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2021   grade_7 5 50 10   0 1     0   12   37 41     3.0   2.0     43.0   8.0   78 5 50 10   0 1     0   12   37 41     3 2   43 8   78
1719488 MN Carver 10 school 2700116 4016 Charter Schools World Learner Charter School 270011602606 10 World Learner Charter School Elementary School (Grades PK-6) Regular School Yes Elementary 01 08 2021   grade_7 19 1 2   0 2     0   0   8 16     0.0   0.0     1.0   3.0   24 19 1 2   0 2     0   0   8 16     0 0   1 3   24
1719517 MN Ramsey 62 school 2700118 4018 Charter Schools Achieve Language Academy 270011802608 10 Achieve Language Academy Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2021   grade_7 6 4 20   0 15     0   1   25 21     *   0.0     21.0   4.0   46 6 4 20   0 15     0   1   25 21       0   21 4   46
1719527 MN Saint Louis 69 school 2700133 4020 Charter Schools Duluth Public Schools Academy 270013302711 10 North Star Academy Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2021   grade_7 94 7 6   5 1     0   17   66 64     0.0   0.0     50.0   44.0   130 94 7 6   5 1     0   17   66 64     0 0   50 44   130
1719571 MN Hennepin 27 school 2700159 4038 Charter Schools Sojourner Truth Academy 270015902954 10 Sojourner Truth Academy Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2021   grade_7 0 32 10   0 0     0   0   22 20     6.0   4.0     *   7.0   42 0 32 10   0 0     0   0   22 20     6 4     7   42
1719581 MN Nicollet 52 school 2700174 4050 Charter Schools Lafayette Public Charter School 270017403042 10 Lafayette Public Charter School Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2021   grade_7 2 0 0   0 0     0   1   2 1     *   *     *   *   3 2 0 0   0 0     0   1   2 1                 3
1719613 MN Beltrami 4 school 2700225 4058 Charter Schools Schoolcraft Learning Community Chtr 270022503464 10 Schoolcraft Learning Community Chtr Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2021   grade_7 19 0 1   1 0     0   1   10 12     0.0   0.0     7.0   8.0   22 19 0 1   1 0     0   1   10 12     0 0   7 8   22
1719623 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 2021   grade_7 11 0 0   0 0     0   0   5 6     0.0   0.0     5.0   1.0   11 11 0 0   0 0     0   0   5 6     0 0   5 1   11
1719651 MN Hennepin 27 school 2700184 4068 Charter Schools Excell Academy Charter 270018403137 10 Excell Academy Charter Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2021   grade_7 0 31 2   0 0     0   0   20 13     2.0   0.0     *   3.0   33 0 31 2   0 0     0   0   20 13     2 0     3   33
1719661 MN Ramsey 62 school 2700230 4070 Charter Schools HOPE Community Academy 270023003482 10 HOPE Community Academy Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2021   grade_7 1 1 0   0 53     0   0   31 24     22.0   1.0     45.0   2.0   55 1 1 0   0 53     0   0   31 24     22 1   45 2   55
1719673 MN Ramsey 62 school 2700185 4073 Charter Schools Academia Cesar Chavez Charter School 270018503138 10 Academia Cesar Chavez Charter School Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2021   grade_7 1 1 50   0 0     0   0   27 25     22.0   0.0     18.0   7.0   52 1 1 50   0 0     0   0   27 25     22 0   18 7   52
1719683 MN Ramsey 62 school 2700186 4074 Charter Schools AFSA High School 270018604854 20 AFSA Middle School Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2021   grade_7 24 2 4   0 1     0   3   16 18     0.0   0.0     11.0   9.0   34 24 2 4   0 1     0   3   16 18     0 0   11 9   34
1719699 MN Hennepin 27 school 2700190 4079 Charter Schools Friendship Academy of Fine Arts Charter 270019005280 30 Friendship Academy of the Arts - Intermediate Elementary School (Grades PK-6) Regular School Yes Middle 02 08 2021   grade_7 0 20 0   0 0     0   0   10 10     0.0   0.0     *   4.0   20 0 20 0   0 0     0   0   10 10     0 0     4   20
1719725 MN Ramsey 62 school 2700353 4088 Charter Schools Urban Academy Charter School 270035304173 10 Urban Academy Charter School Elementary School (Grades PK-6) Regular School Yes Elementary PK 07 2021   grade_7 1 6 0   0 31     0   0   15 23     21.0   0.0     *   8.0   38 1 6 0   0 31     0   0   15 23     21 0     8   38
1719734 MN Hennepin 27 school 2700354 4089 Charter Schools New City School 270035404849 20 New City School Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2021   grade_7 24 8 4   0 0     0   4   19 21     2.0   1.0     20.0   4.0   40 24 8 4   0 0     0   4   19 21     2 1   20 4   40
1719753 MN Hennepin 27 school 2700237 4097 Charter Schools Partnership Academy, Inc. 270023703278 10 Partnership Academy, Inc. Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2021   grade_7 0 2 53   1 0     0   0   27 29     29.0   1.0     40.0   11.0   56 0 2 53   1 0     0   0   27 29     29 1   40 11   56
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
1719830 MN Hennepin 27 school 2700366 4124 Charter Schools Beacon Academy 270036604110 10 Beacon Academy Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2021   grade_7 32 20 7   0 0     0   5   35 29     6.0   0.0     24.0   14.0   64 32 20 7   0 0     0   5   35 29     6 0   24 14   64
1719855 MN Olmsted 55 school 2700247 4135 Charter Schools Rochester Math And Science Academy 270024703308 10 Rochester Math And Science Academy Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2021   grade_7 0 39 0   0 0     0   0   22 17     11.0   0.0     *   3.0   39 0 39 0   0 0     0   0   22 17     11 0     3   39
1719873 MN Hennepin 27 school 2700273 4139 Charter Schools LoveWorks Academy For Arts 270027303575 10 LoveWorks Academy For Arts Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2021   grade_7 0 20 0   0 0     0   0   11 9     0.0   0.0     *   3.0   20 0 20 0   0 0     0   0   11 9     0 0     3   20
1719883 MN Hennepin 27 school 2700281 4140 Charter Schools Yinghua Academy 270028103611 10 Yinghua Academy Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2021   grade_7 51 7 4   0 34     0   1   48 49     2.0   0.0     6.0   8.0   97 51 7 4   0 34     0   1   48 49     2 0   6 8   97
1719893 MN Stearns 73 school 2700252 4142 Charter Schools Stride Academy Charter School 270025204405 20 Stride Academy K-8 Charter School Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2021   grade_7 8 28 4   0 0     0   5   23 22     15.0   0.0     25.0   7.0   45 8 28 4   0 0     0   5   23 22     15 0   25 7   45
1719903 MN Hennepin 27 school 2700253 4143 Charter Schools New Millennium Academy Charter Sch 270025303311 10 New Millenium Academy Charter School Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2021   grade_7 0 8 4   0 78     0   0   44 46     45.0   7.0     65.0   10.0   90 0 8 4   0 78     0   0   44 46     45 7   65 10   90
1719928 MN Ramsey 62 school 2700262 4152 Charter Schools Twin Cities German Immersion Charter School 270026203578 10 Twin Cities German Immersion Charter School Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2021   grade_7 32 4 4   0 4     0   9   21 32     1.0   0.0     2.0   13.0   53 32 4 4   0 4     0   9   21 32     1 0   2 13   53
1719938 MN Ramsey 62 school 2700263 4153 Charter Schools Midway Star Academy 270026303320 10 Midway Star Academy Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2021   grade_7 0 36 0   0 0     0   0   16 20     30.0   0.0     *   5.0   36 0 36 0   0 0     0   0   16 20     30 0     5   36
1719972 MN Mcleod 43 school 2700277 4161 Charter Schools New Discoveries Montessori Academy 270027703616 10 New Discoveries Montessori Academy Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2021   grade_7 6 0 1   0 0     0   1   7 1     *   *     *   *   8 6 0 1   0 0     0   1   7 1                 8
1719982 MN Hennepin 27 school 2700278 4162 Charter Schools Southside Family Charter School 270027803617 10 Southside Family Charter School Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2021   grade_7 4 3 2   0 0     0   3   7 5     0.0   0.0     4.0   1.0   12 4 3 2   0 0     0   3   7 5     0 0   4 1   12
1720009 MN Hennepin 27 school 2700289 4169 Charter Schools Stonebridge World School 270028903731 10 Stonebridge World School Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2021   grade_7 0 18 12   1 1     0   1   14 19     5.0   2.0     27.0   9.0   33 0 18 12   1 1     0   1   14 19     5 2   27 9   33
1720028 MN Hennepin 27 school 2700295 4171 Charter Schools Noble Academy 270029503727 10 Noble Academy Elementary School (Grades PK-6) Regular School Yes Middle 03 08 2021   grade_7 0 10 1   0 75     0   1   45 42     25.0   0.0     62.0   11.0   87 0 10 1   0 75     0   1   45 42     25 0   62 11   87
1720052 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 2021   grade_7 0 1 1   0 144     0   2   66 82     45.0   0.0     119.0   22.0   148 0 1 1   0 144     0   2   66 82     45 0   119 22   148
1720062 MN Scott 70 school 2700311 4184 Charter Schools Aspen Academy 270031104282 10 Aspen Academy Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2021   grade_7 25 6 0   0 2     0   1   19 15     2.0   0.0     4.0   5.0   34 25 6 0   0 2     0   1   19 15     2 0   4 5   34
1720072 MN Anoka 2 school 2700320 4185 Charter Schools DaVinci Academy 270032004268 10 DaVinci Academy Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2021   grade_7 50 12 2   0 6     0   4   34 40     1.0   0.0     11.0   8.0   74 50 12 2   0 6     0   4   34 40     1 0   11 8   74
1720082 MN Ramsey 62 school 2700313 4186 Charter Schools Global Academy 270031304294 10 Global Academy Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2021   grade_7 7 44 0   0 0     0   0   24 27     7.0   0.0     42.0   4.0   51 7 44 0   0 0     0   0   24 27     7 0   42 4   51
1720092 MN Carver 10 school 2700319 4188 Charter Schools Cologne Academy 270031904320 10 Cologne Academy Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2021   grade_7 61 0 3   1 0     0   2   28 39     0.0   0.0     3.0   11.0   67 61 0 3   1 0     0   2   28 39     0 0   3 11   67
1720106 MN Hennepin 27 school 2700308 4191 Charter Schools KIPP Minnesota Charter School 270030805269 20 KIPP Legacy Academy Elementary School (Grades PK-6) Regular School Yes Middle 04 07 2021   grade_7 0 34 1   0 0     0   0   19 16     0.0   3.0     28.0   9.0   35 0 34 1   0 0     0   0   19 16     0 3   28 9   35
1720125 MN Hennepin 27 school 2700309 4192 Charter Schools Best Academy 270030904261 10 Best Academy Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2021   grade_7 0 73 1   0 0     0   2   48 28     14.0   3.0     *   11.0   76 0 73 1   0 0     0   2   48 28     14 3     11   76
1720143 MN Rice 66 school 2700324 4194 Charter Schools Cannon River STEM School 270032404271 10 Cannon River STEM School Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2021   grade_7 27 0 4   0 0     0   1   16 16     0.0   0.0     9.0   8.0   32 27 0 4   0 0     0   1   16 16     0 0   9 8   32
1720197 MN Hennepin 27 school 2700378 4208 Charter Schools Nasha Shkola Charter School 270037804635 10 Nasha Shkola Charter School Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2021   grade_7 6 0 0   0 0     0   0   2 4     *   *     *   *   6 6 0 0   0 0     0   0   2 4                 6
1720231 MN Ramsey 62 school 2700386 4215 Charter Schools Sejong Academy of Minnesota 270038604695 10 Sejong Academy of Minnesota Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2021   grade_7 0 0 0   0 8     0   0   4 4     *   *     *   *   8 0 0 0   0 8     0   0   4 4                 8
1720241 MN Hennepin 27 school 2700398 4219 Charter Schools Northeast College Prep 270039804757 10 Northeast College Prep Charter School Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2021   grade_7 4 34 3   0 0     0   3   19 25     10.0   0.0     *   9.0   44 4 34 3   0 0     0   3   19 25     10 0     9   44
1720251 MN Hennepin 27 school 2700394 4220 Charter Schools Agamim Classical Academy 270039404751 10 Agamim Classical Academy Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2021   grade_7 8 8 2   0 1     0   2   12 9     7.0   0.0     5.0   2.0   21 8 8 2   0 1     0   2   12 9     7 0   5 2   21
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
1720279 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 2021   grade_7 8 5 0   0 0     0   0   5 8     4.0   0.0     8.0   0.0   13 8 5 0   0 0     0   0   5 8     4 0   8 0   13
1720290 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 2021   grade_7 0 38 0   0 0     0   0   16 22     31.0   0.0     29.0   4.0   38 0 38 0   0 0     0   0   16 22     31 0   29 4   38
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
1720316 MN Washington 82 school 2700401 4228 Charter Schools Woodbury Leadership Academy 270040104812 10 Woodbury Leadership Academy Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2021   grade_7 10 12 2   0 4     0   1   15 14     0.0   0.0     4.0   6.0   29 10 12 2   0 4     0   1   15 14     0 0   4 6   29
1720342 MN Hennepin 27 school 2700404 4232 Charter Schools Success Academy 270040404790 10 Success Academy Elementary School (Grades PK-6) Regular School Yes Elementary KG 07 2021   grade_7 0 9 0   0 0     0   0   5 4     *   *     *   *   9 0 9 0   0 0     0   0   5 4                 9
1720367 MN Ramsey 62 school 2700410 4240 Charter Schools New Century School 270041004873 10 New Century School Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2021   grade_7 0 29 0   0 0     0   0   15 14     17.0   0.0     *   3.0   29 0 29 0   0 0     0   0   15 14     17 0     3   29
1720385 MN Dakota 19 school 2700425 4244 Charter Schools FIT Academy 270042504902 10 FIT Academy Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2021   grade_7 14 2 1   0 0     0   1   16 2     2.0   0.0     8.0   12.0   18 14 2 1   0 0     0   1   16 2     2 0   8 12   18
1720395 MN Stearns 73 school 2700430 4250 Charter Schools Athlos Academy of Saint Cloud 270043004959 10 Athlos Academy of Saint Cloud Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2021   grade_7 13 18 6   0 0     0   2   14 25     9.0   1.0     17.0   7.0   39 13 18 6   0 0     0   2   14 25     9 1   17 7   39
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
1721535 MN Ramsey 62 school 2700115 4015 Charter Schools Community of Peace Academy 270011505136 12 Community of Peace Academy Middle School Middle School (Grades 5-8) Regular School Yes Middle 05 08 2021   grade_7 6 14 19   0 24     0   2   29 36     13.0   0.0     44.0   11.0   65 6 14 19   0 24     0   2   29 36     13 0   44 11   65
1721539 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 2021   grade_7 0 17 26   1 6     0   2   29 23     14.0   4.0     46.0   10.0   52 0 17 26   1 6     0   2   29 23     14 4   46 10   52
1721543 MN Washington 82 school 2700177 4053 Charter Schools North Lakes Academy 270017703045 10 North Lakes Academy Middle School Middle School (Grades 5-8) Regular School Yes Middle 06 08 2021   grade_7 53 0 2   0 0     0   0   26 29     0.0   0.0     14.0   16.0   55 53 0 2   0 0     0   0   26 29     0 0   14 16   55
1721548 MN Hennepin 27 school 2700220 4067 Charter Schools Aurora Charter School 270022004420 20 Aurora Middle School Middle School (Grades 5-8) Regular School Yes Middle 05 08 2021   grade_7 0 0 50   0 0     0   0   28 22     26.0   0.0     43.0   7.0   50 0 0 50   0 0     0   0   28 22     26 0   43 7   50
1721552 MN Ramsey 62 school 2700187 4075 Charter Schools Avalon School 270018704664 20 Avalon Middle School Middle School (Grades 5-8) Regular School Yes Middle 06 08 2021   grade_7 23 0 2   0 1     0   3   19 10     2.0   0.0     2.0   10.0   29 23 0 2   0 1     0   3   19 10     2 0   2 10   29
1721557 MN Hennepin 27 school 2700189 4078 Charter Schools Twin Cities International Schools 270018903142 10 Minnesota International Middle Charter School Middle School (Grades 5-8) Regular School Yes Middle 05 08 2021   grade_7 0 114 0   0 0     0   0   42 72     45.0   0.0     *   6.0   114 0 114 0   0 0     0   0   42 72     45 0     6   114
1721561 MN Ramsey 62 school 2700342 4103 Charter Schools Hmong College Prep Academy 270034203700 20 Hmong College Prep Academy MS Middle School (Grades 5-8) Regular School Yes Middle 06 08 2021   grade_7 0 1 0   0 217     0   0   112 106     70.0   0.0     172.0   23.0   218 0 1 0   0 217     0   0   112 106     70 0   172 23   218
1721565 MN Beltrami 4 school 2700345 4106 Charter Schools TrekNorth High School 270034504666 20 Trek North Middle School Middle School (Grades 5-8) Regular School Yes Middle 06 08 2021   grade_7 13 0 0   19 0     0   5   14 23     0.0   0.0     13.0   11.0   37 13 0 0   19 0     0   5   14 23     0 0   13 11   37
1721569 MN Beltrami 4 school 2700346 4107 Charter Schools Voyageurs Expeditionary 270034604667 20 Voyageurs Expeditionary MS Middle School (Grades 5-8) Regular School Yes Middle 06 08 2021   grade_7 5 0 0   9 0     0   2   12 4     0.0   0.0     *   6.0   16 5 0 0   9 0     0   2   12 4     0 0     6   16
1721573 MN Wright 86 school 2700360 4118 Charter Schools Kaleidoscope Charter School 270036005071 30 Kaleidoscope Middle School Middle School (Grades 5-8) Regular School Yes Middle 06 08 2021   grade_7 32 1 1   0 0     0   1   21 14     2.0   0.0     7.0   13.0   35 32 1 1   0 0     0   1   21 14     2 0   7 13   35
1721578 MN Washington 82 school 2700362 4120 Charter Schools St. Croix Preparatory Academy 270036204222 20 St. Croix Preparatory Academy Middle Middle School (Grades 5-8) Regular School Yes Middle 05 08 2021   grade_7 67 5 6   0 12     0   3   42 51     2.0   0.0     7.0   13.0   93 67 5 6   0 12     0   3   42 51     2 0   7 13   93
1721582 MN Hennepin 27 school 2700240 4126 Charter Schools Prairie Seeds Academy 270024004805 30 Prairie Seeds Middle School Academy Middle School (Grades 5-8) Regular School Yes Middle 06 08 2021   grade_7 0 11 9   0 55     0   0   39 36     33.0   1.0     54.0   4.0   75 0 11 9   0 55     0   0   39 36     33 1   54 4   75
1721587 MN Hennepin 27 school 2700245 4131 Charter Schools Metro Schools Charter 270024504857 20 Metro Schools Middle Charter Middle School (Grades 5-8) Regular School Yes Middle 05 08 2021   grade_7 0 37 0   0 0     0   0   19 18     21.0   0.0     *   3.0   37 0 37 0   0 0     0   0   19 18     21 0     3   37
1721591 MN Hennepin 27 school 2700284 4159 Charter Schools Seven Hills Preparatory Academy 270028404804 20 Seven Hills Preparatory Academy Upper School Middle School (Grades 5-8) Regular School Yes Middle 06 08 2021   grade_7 47 11 13   2 10     1   4   51 37     6.0   0.0     23.0   10.0   88 47 11 13   2 10     1   4   51 37     6 0   23 10   88
1721596 MN Sherburne 71 school 2700276 4160 Charter Schools Spectrum High School 270027605140 30 Spectrum Middle School - Grades 7-8 Middle School (Grades 5-8) Regular School Yes Middle 07 08 2021   grade_7 107 2 6   0 0     0   5   68 52     2.0   0.0     8.0   7.0   120 107 2 6   0 0     0   5   68 52     2 0   8 7   120
1721601 MN Ramsey 62 school 2700292 4164 Charter Schools Laura Jeffrey Academy Charter 270029203713 10 Laura Jeffrey Academy Charter Middle School (Grades 5-8) Regular School Yes Middle 05 08 2021   grade_7 17 5 2   0 1     0   2   1 26     0.0   3.0     6.0   5.0   27 17 5 2   0 1     0   2   1 26     0 3   6 5   27
1721606 MN Hennepin 27 school 2700288 4170 Charter Schools Hiawatha Academies 270028804599 11 Hiawatha College Prep - Kingfield Middle School (Grades 5-8) Regular School Yes Middle 05 08 2021   grade_7 0 12 67   1 0     0   0   40 40     37.0   0.0     69.0   9.0   80 0 12 67   1 0     0   0   40 40     37 0   69 9   80

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