Data source: Big Local News · About: Big Local

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

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
1826543 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 2020   grade_7 13.0 0.0 1.0   0.0 0.0     0.0   1.0   7.0 8.0     0.0   1.0     4.0   5.0   15.0 13 0 1   0 0     0   1   7 8     0 1   4 5   15
1826550 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 2020   grade_7 48.0 2.0 2.0   0.0 1.0     0.0   1.0   30.0 24.0     2.0   0.0     6.0   9.0   54.0 48 2 2   0 1     0   1   30 24     2 0   6 9   54
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
1826577 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 2020   grade_7 31.0 23.0 3.0   0.0 28.0     0.0   3.0   40.0 48.0     0.0   0.0     5.0   6.0   88.0 31 23 3   0 28     0   3   40 48     0 0   5 6   88
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
1826601 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 2020   grade_7 8.0 2.0 1.0   0.0 0.0     0.0   0.0   5.0 6.0     0.0   0.0     9.0   7.0   11.0 8 2 1   0 0     0   0   5 6     0 0   9 7   11
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
1826631 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 2020   grade_7 19.0 0.0 0.0   0.0 0.0     0.0   2.0   13.0 8.0     0.0   0.0     3.0   5.0   21.0 19 0 0   0 0     0   2   13 8     0 0   3 5   21
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
1826647 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 2020   grade_7 54.0 3.0 6.0   0.0 12.0     0.0   10.0   36.0 49.0     1.0   1.0     8.0   6.0   85.0 54 3 6   0 12     0   10   36 49     1 1   8 6   85
1826654 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 2020   grade_7 50.0 4.0 5.0   0.0 3.0     0.0   0.0   29.0 33.0     2.0   0.0     9.0   9.0   62.0 50 4 5   0 3     0   0   29 33     2 0   9 9   62
1826662 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 2020   grade_7 64.0 0.0 17.0   1.0 1.0     0.0   4.0   39.0 48.0     1.0   0.0     13.0   10.0   87.0 64 0 17   1 1     0   4   39 48     1 0   13 10   87
1826675 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 2020   grade_7 56.0 22.0 7.0   1.0 20.0     0.0   11.0   57.0 60.0     11.0   0.0     34.0   9.0   117.0 56 22 7   1 20     0   11   57 60     11 0   34 9   117
1826683 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 2020   grade_7 30.0 24.0 22.0   0.0 16.0     0.0   10.0   55.0 47.0     3.0   0.0     54.0   13.0   102.0 30 24 22   0 16     0   10   55 47     3 0   54 13   102
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
1826703 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 2020   grade_7 16.0 2.0 1.0   0.0 3.0     0.0   1.0   16.0 7.0     0.0   0.0     4.0   *   23.0 16 2 1   0 3     0   1   16 7     0 0   4     23
1826710 MN Ramsey 62 school 2700315 4183 Charter Schools Lionsgate Academy 270031505148 50 Lionsgate Academy - Shoreview Secondary School (Grades 7-12) Regular School Yes Secondary 07 11 2020   grade_7 15.0 0.0 4.0   0.0 1.0     0.0   3.0   18.0 5.0     0.0   0.0     5.0   *   23.0 15 0 4   0 1     0   3   18 5     0 0   5     23
1826717 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 2020   grade_7 0.0 54.0 0.0   0.0 0.0     0.0   0.0   23.0 31.0     24.0   0.0     36.0   6.0   54.0 0 54 0   0 0     0   0   23 31     24 0   36 6   54
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
1826756 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 2020   grade_7 13.0 0.0 0.0   0.0 0.0     0.0   0.0   7.0 6.0     0.0   0.0     3.0   2.0   13.0 13 0 0   0 0     0   0   7 6     0 0   3 2   13
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
1826772 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 2020   grade_7 17.0 0.0 3.0   0.0 0.0     0.0   4.0   12.0 12.0     0.0   0.0     8.0   13.0   24.0 17 0 3   0 0     0   4   12 12     0 0   8 13   24
1832979 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 2020   grade_7 22.0 0.0 0.0   0.0 0.0     0.0   1.0   10.0 13.0     0.0   0.0     6.0   2.0   23.0 22 0 0   0 0     0   1   10 13     0 0   6 2   23
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
1833016 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 2020   grade_7 4.0 60.0 16.0   1.0 3.0     0.0   8.0   49.0 43.0     2.0   0.0     68.0   7.0   92.0 4 60 16   1 3     0   8   49 43     2 0   68 7   92
1833032 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 2020   grade_7 25.0 0.0 1.0   0.0 1.0     0.0   0.0   12.0 15.0     0.0   0.0     3.0   5.0   27.0 25 0 1   0 1     0   0   12 15     0 0   3 5   27
1833067 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 2020   grade_7 5.0 8.0 19.0   0.0 16.0     0.0   1.0   26.0 23.0     13.0   0.0     43.0   5.0   49.0 5 8 19   0 16     0   1   26 23     13 0   43 5   49
1833077 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 2020   grade_7 91.0 5.0 3.0   9.0 0.0     0.0   11.0   63.0 56.0     1.0   1.0     45.0   20.0   119.0 91 5 3   9 0     0   11   63 56     1 1   45 20   119
1833122 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 2020   grade_7 1.0 26.0 9.0   0.0 1.0     0.0   4.0   18.0 23.0     7.0   3.0     35.0   6.0   41.0 1 26 9   0 1     0   4   18 23     7 3   35 6   41
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
1833136 MN Washington 82 school 2700177 4053 Charter Schools North Lakes Academy 270017703045 10 North Lakes Academy Middle School Elementary School (Grades PK-6) Regular School Yes Middle 06 08 2020   grade_7 55.0 3.0 1.0   1.0 1.0     0.0   3.0   36.0 28.0     2.0   0.0     15.0   17.0   64.0 55 3 1   1 1     0   3   36 28     2 0   15 17   64
1833168 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 2020   grade_7 7.0 0.0 0.0   4.0 0.0     0.0   3.0   11.0 3.0     0.0   0.0     6.0   4.0   14.0 7 0 0   4 0     0   3   11 3     0 0   6 4   14
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
1833206 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 2020   grade_7 0.0 24.0 4.0   0.0 0.0     0.0   0.0   17.0 11.0     4.0   1.0     25.0   5.0   28.0 0 24 4   0 0     0   0   17 11     4 1   25 5   28
1833216 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 2020   grade_7 0.0 1.0 0.0   0.0 67.0     0.0   1.0   34.0 35.0     29.0   2.0     58.0   6.0   69.0 0 1 0   0 67     0   1   34 35     29 2   58 6   69
1833228 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 2020   grade_7 2.0 0.0 50.0   0.0 0.0     0.0   0.0   25.0 27.0     21.0   0.0     37.0   8.0   52.0 2 0 50   0 0     0   0   25 27     21 0   37 8   52
1833238 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 2020   grade_7 26.0 6.0 8.0   0.0 3.0     0.0   6.0   26.0 23.0     0.0   0.0     23.0   7.0   49.0 26 6 8   0 3     0   6   26 23     0 0   23 7   49
1833254 MN Hennepin 27 school 2700190 4079 Charter Schools Friendship Academy of Fine Arts Charter 270019003143 10 Friendship Academy of Fine Arts Charter Elementary School (Grades PK-6) Regular School Yes Elementary KG 07 2020   grade_7 0.0 19.0 0.0   0.0 0.0     0.0   0.0   10.0 9.0     0.0   0.0     11.0   3.0   19.0 0 19 0   0 0     0   0   10 9     0 0   11 3   19
1833288 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 2020   grade_7 17.0 12.0 4.0   0.0 0.0     0.0   2.0   15.0 20.0     2.0   0.0     18.0   7.0   35.0 17 12 4   0 0     0   2   15 20     2 0   18 7   35
1833305 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 KG 07 2020   grade_7 0.0 3.0 43.0   0.0 0.0     0.0   0.0   24.0 22.0     *   0.0     35.0   6.0   46.0 0 3 43   0 0     0   0   24 22       0   35 6   46
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
1833383 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 2020   grade_7 42.0 20.0 7.0   0.0 3.0     0.0   5.0   30.0 47.0     4.0   0.0     30.0   13.0   77.0 42 20 7   0 3     0   5   30 47     4 0   30 13   77
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
1833436 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 2020   grade_7 41.0 5.0 2.0   1.0 34.0     0.0   0.0   38.0 45.0     1.0   0.0     8.0   7.0   83.0 41 5 2   1 34     0   0   38 45     1 0   8 7   83
1833446 MN Stearns 73 school 2700252 4142 Charter Schools Stride Academy Charter School 270025204405 20 Stride Academy K-7 Charter School Elementary School (Grades PK-6) Regular School Yes Elementary KG 07 2020   grade_7 7.0 39.0 1.0   1.0 1.0     0.0   1.0   25.0 25.0     26.0   0.0     35.0   10.0   50.0 7 39 1   1 1     0   1   25 25     26 0   35 10   50
1833455 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 2020   grade_7 1.0 4.0 3.0   0.0 63.0     0.0   2.0   38.0 35.0     28.0   6.0     59.0   11.0   73.0 1 4 3   0 63     0   2   38 35     28 6   59 11   73
1833480 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 2020   grade_7 40.0 0.0 2.0   0.0 0.0     0.0   6.0   24.0 24.0     2.0   0.0     4.0   4.0   48.0 40 0 2   0 0     0   6   24 24     2 0   4 4   48
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
1833523 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 2020   grade_7 20.0 0.0 2.0   0.0 0.0     0.0   1.0   12.0 11.0     1.0   0.0     8.0   14.0   23.0 20 0 2   0 0     0   1   12 11     1 0   8 14   23
1833533 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 2020   grade_7 3.0 3.0 3.0   0.0 0.0     0.0   2.0   5.0 6.0     0.0   1.0     5.0   3.0   11.0 3 3 3   0 0     0   2   5 6     0 1   5 3   11
1833560 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 2020   grade_7 0.0 19.0 5.0   0.0 0.0     0.0   1.0   13.0 12.0     5.0   3.0     22.0   9.0   25.0 0 19 5   0 0     0   1   13 12     5 3   22 9   25
1833579 MN Hennepin 27 school 2700295 4171 Charter Schools Noble Academy 270029503727 10 Noble Academy Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2020   grade_7 0.0 10.0 0.0   0.0 91.0     0.0   0.0   56.0 45.0     40.0   0.0     81.0   7.0   101.0 0 10 0   0 91     0   0   56 45     40 0   81 7   101
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
1833613 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 2020   grade_7 28.0 3.0 1.0   0.0 1.0     0.0   0.0   21.0 12.0     0.0   0.0     7.0   9.0   33.0 28 3 1   0 1     0   0   21 12     0 0   7 9   33
1833623 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 2020   grade_7 43.0 3.0 4.0   1.0 5.0     0.0   8.0   35.0 29.0     2.0   0.0     14.0   9.0   64.0 43 3 4   1 5     0   8   35 29     2 0   14 9   64
1833633 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 2020   grade_7 5.0 44.0 1.0   0.0 1.0     0.0   0.0   21.0 30.0     9.0   0.0     43.0   5.0   51.0 5 44 1   0 1     0   0   21 30     9 0   43 5   51
1833650 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 2020   grade_7 56.0 1.0 2.0   0.0 0.0     0.0   2.0   26.0 35.0     0.0   0.0     6.0   4.0   61.0 56 1 2   0 0     0   2   26 35     0 0   6 4   61
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
1833696 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 2020   grade_7 29.0 1.0 5.0   0.0 0.0     0.0   0.0   25.0 10.0     0.0   0.0     11.0   9.0   35.0 29 1 5   0 0     0   0   25 10     0 0   11 9   35
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
1833804 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 2020   grade_7 18.0 8.0 5.0   0.0 3.0     0.0   2.0   18.0 18.0     5.0   0.0     11.0   6.0   36.0 18 8 5   0 3     0   2   18 18     5 0   11 6   36
1833814 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 2020   grade_7 7.0 1.0 6.0   0.0 0.0     0.0   4.0   10.0 8.0     1.0   0.0     6.0   5.0   18.0 7 1 6   0 0     0   4   10 8     1 0   6 5   18
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
1833868 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 2020   grade_7 12.0 7.0 0.0   0.0 1.0     0.0   1.0   12.0 9.0     0.0   0.0     6.0   8.0   21.0 12 7 0   0 1     0   1   12 9     0 0   6 8   21
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
1833935 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 2020   grade_7 11.0 3.0 6.0   0.0 0.0     0.0   2.0   11.0 11.0     3.0   0.0     7.0   8.0   22.0 11 3 6   0 0     0   2   11 11     3 0   7 8   22
1833945 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 2020   grade_7 21.0 28.0 5.0   0.0 0.0     1.0   2.0   31.0 26.0     16.0   0.0     34.0   7.0   57.0 21 28 5   0 0     1   2   31 26     16 0   34 7   57
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
1835055 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 2020   grade_7 6.0 16.0 16.0   1.0 31.0     0.0   6.0   37.0 39.0     17.0   2.0     65.0   14.0   76.0 6 16 16   1 31     0   6   37 39     17 2   65 14   76
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
1835064 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 2020   grade_7 0.0 0.0 48.0   0.0 0.0     0.0   0.0   17.0 31.0     *   0.0     43.0   4.0   48.0 0 0 48   0 0     0   0   17 31       0   43 4   48
1835068 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 2020   grade_7 21.0 0.0 3.0   0.0 0.0     0.0   2.0   18.0 8.0     0.0   2.0     7.0   13.0   26.0 21 0 3   0 0     0   2   18 8     0 2   7 13   26
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
1835077 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 2020   grade_7 1.0 4.0 0.0   0.0 208.0     0.0   1.0   115.0 99.0     75.0   0.0     159.0   19.0   214.0 1 4 0   0 208     0   1   115 99     75 0   159 19   214
1835081 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 2020   grade_7 20.0 0.0 0.0   14.0 0.0     0.0   6.0   18.0 22.0     0.0   0.0     25.0   8.0   40.0 20 0 0   14 0     0   6   18 22     0 0   25 8   40
1835085 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 2020   grade_7 5.0 0.0 0.0   10.0 0.0     0.0   2.0   10.0 7.0     0.0   1.0     15.0   7.0   17.0 5 0 0   10 0     0   2   10 7     0 1   15 7   17
1835089 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 2020   grade_7 41.0 2.0 2.0   0.0 0.0     0.0   0.0   25.0 20.0     0.0   0.0     9.0   11.0   45.0 41 2 2   0 0     0   0   25 20     0 0   9 11   45
1835094 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 2020   grade_7 74.0 2.0 4.0   0.0 8.0     0.0   4.0   44.0 48.0     0.0   0.0     4.0   23.0   92.0 74 2 4   0 8     0   4   44 48     0 0   4 23   92
1835098 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 2020   grade_7 2.0 10.0 7.0   0.0 44.0     0.0   1.0   29.0 35.0     20.0   3.0     38.0   8.0   64.0 2 10 7   0 44     0   1   29 35     20 3   38 8   64
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
1835107 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 2020   grade_7 49.0 14.0 13.0   0.0 7.0     0.0   4.0   42.0 45.0     9.0   0.0     21.0   11.0   87.0 49 14 13   0 7     0   4   42 45     9 0   21 11   87
1835112 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 2020   grade_7 103.0 1.0 4.0   0.0 2.0     0.0   2.0   66.0 46.0     0.0   0.0     22.0   12.0   112.0 103 1 4   0 2     0   2   66 46     0 0   22 12   112
1835117 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 2020   grade_7 10.0 12.0 2.0   0.0 1.0     0.0   5.0   2.0 28.0     0.0   0.0     13.0   *   30.0 10 12 2   0 1     0   5   2 28     0 0   13     30
1835122 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 2020   grade_7 1.0 7.0 95.0   0.0 0.0     0.0   0.0   54.0 49.0     48.0   1.0     86.0   12.0   103.0 1 7 95   0 0     0   0   54 49     48 1   86 12   103
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
1835135 MN Hennepin 27 school 2700333 4199 Charter Schools Parnassus Preparatory Charter Sch 270033304837 20 Parnassus Preparatory School-Logic Middle School (Grades 5-8) Regular School Yes Middle 05 08 2020   grade_7 45.0 45.0 11.0   0.0 6.0     0.0   7.0   53.0 61.0     7.0   1.0     36.0   4.0   114.0 45 45 11   0 6     0   7   53 61     7 1   36 4   114
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
1835143 MN Ramsey 62 school 2700376 4210 Charter Schools Upper Mississippi Academy 270037604693 20 Upper Mississippi Middle Academy Middle School (Grades 5-8) Regular School Yes Middle 06 08 2020   grade_7 34.0 5.0 5.0   0.0 0.0     0.0   5.0   32.0 17.0     0.0   0.0     13.0   13.0   49.0 34 5 5   0 0     0   5   32 17     0 0   13 13   49

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