Data source: Big Local News · About: Big Local

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

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
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
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
1720342 MN Hennepin 27 school 2700404 4232 Charter Schools Success Academy 270040404790 10 Success Academy Elementary School (Grades PK-6) Regular School Yes Elementary KG 07 2021   grade_7 0 9 0   0 0     0   0   5 4     *   *     *   *   9 0 9 0   0 0     0   0   5 4                 9
1720405 MN Chisago 13 school 2700429 4253 Charter Schools Phoenix Academy Charter School 270042904969 10 Phoenix Academy Charter School Elementary School (Grades PK-6) Regular School Yes Elementary KG 07 2021   grade_7 8 0 0   0 0     0   1   3 6     *   *     *   *   9 8 0 0   0 0     0   1   3 6                 9
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
1720765 MN Chippewa 12 school 2721320 129 Independent Districts and Schools Montevideo Public School District 272132001071 30 Montevideo Middle Middle School (Grades 5-8) Regular School No Middle 04 07 2021   grade_7 73 2 15   2 0     3   6   50 51     10.0   0.0     42.0   18.0   101 73 2 15   2 0     3   6   50 51     10 0   42 18   101
1720879 MN Freeborn 24 school 2702970 241 Independent Districts and Schools Albert Lea Public School District 270297000078 320 Southwest Middle Middle School (Grades 5-8) Regular School No Middle 06 07 2021   grade_7 165 7 72   0 21     0   8   149 124     *   *     *   *   273 165 7 72   0 21     0   8   149 124                 273
1720919 MN Hennepin 27 school 2722920 277 Independent Districts and Schools Westonka Public School District 272292001109 63 Grandview Middle School Middle School (Grades 5-8) Regular School No Middle 05 07 2021   grade_7 160 8 11   0 1     0   13   89 104     3.0   0.0     26.0   36.0   193 160 8 11   0 1     0   13   89 104     3 0   26 36   193
1721473 MN Faribault 22 school 2700130 2860 Independent Districts and Schools Blue Earth Area Public School 270013002497 23 Blue Earth Area Middle Middle School (Grades 5-8) Regular School No Middle 06 07 2021   grade_7 71 1 9   0 0     0   0   42 39     2.0   0.0     25.0   15.0   81 71 1 9   0 0     0   0   42 39     2 0   25 15   81
1721611 MN Hennepin 27 school 2700288 4170 Charter Schools Hiawatha Academies 270028805141 15 Hiawatha College Prep - Northrop Middle School (Grades 5-8) Regular School Yes Middle 05 07 2021   grade_7 0 7 73   0 1     0   1   44 38     32.0   1.0     73.0   11.0   82 0 7 73   0 1     0   1   44 38     32 1   73 11   82
1721633 MN Anoka 2 school 2700380 4213 Charter Schools Prodeo Academy 270038005319 12 Prodeo Academy Columbia Heights Middle Middle School (Grades 5-8) Regular School Yes Middle 05 07 2021   grade_7 1 32 17   0 0     0   1   25 26     7.0   6.0     38.0   7.0   51 1 32 17   0 0     0   1   25 26     7 6   38 7   51
1721652 MN Ramsey 62 school 2700438 4258 Charter Schools The Journey School 270043805290 20 The Journey School Middle Middle School (Grades 5-8) Regular School Yes Middle 07 07 2021   grade_7 3 1 4   0 0     0   2   5 5     1.0   0.0     *   1.0   10 3 1 4   0 0     0   2   5 5     1 0     1   10
1723656 MN Ramsey 62 school 2722950 621 Independent Districts and Schools Mounds View Public School District 272295002998 39 Mounds View Bridges Program Special Education Special Education School No Elementary KG 07 2021   grade_7 0 0 1   0 0     0   0   1 0     *   *     *   *   1 0 0 1   0 0     0   0   1 0                 1
1713583 MN Becker 3 school 2728960 25 Independent Districts and Schools Pine Point Public School District 272896000034 70 Pine Point Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 08 2021   grade_7 0 0 0   6 0     0   0   2 4     *   *     *   *   6 0 0 0   6 0     0   0   2 4                 6
1713660 MN Beltrami 4 school 2730510 38 Independent Districts and Schools Red Lake Public School District 273051001301 20 Ponemah Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 08 2021   grade_7 0 0 0   17 0     0   0   10 7     *   *     *   *   17 0 0 0   17 0     0   0   10 7                 17
1713694 MN Benton 5 school 2712240 51 Independent Districts and Schools Foley Public School District 271224002270 30 Foley Intermediate Elementary Elementary School (Grades PK-6) Regular School No Middle 04 08 2021   grade_7 140 1 7   0 0     0   4   83 69     1.0   0.0     37.0   13.0   152 140 1 7   0 0     0   4   83 69     1 0   37 13   152
1715361 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 2021   grade_7 17 28 7   1 2     0   4   26 33     1.0   0.0     34.0   13.0   59 17 28 7   1 2     0   4   26 33     1 0   34 13   59
1716197 MN Olmsted 55 school 2731800 535 Independent Districts and Schools Rochester Public School District 273180001005 138 Lincoln K-8 Choice Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 08 2021   grade_7 37 3 3   0 5     0   1   28 21     1.0   0.0     8.0   8.0   49 37 3 3   0 5     0   1   28 21     1 0   8 8   49
1716537 MN Ramsey 62 school 2732430 623 Independent Districts and Schools Roseville Public School District 273243001046 73 Parkview Center School Elementary School (Grades PK-6) Regular School No Elementary PK 08 2021   grade_7 44 20 5   1 6     0   9   45 40     6.0   0.0     21.0   11.0   85 44 20 5   1 6     0   9   45 40     6 0   21 11   85
1716845 MN Ramsey 62 school 2733840 625 Independent Districts and Schools St. Paul Public School District 273384004457 489 Hazel Park Preparatory Academy Elementary School (Grades PK-6) Regular School No Elementary PK 08 2021   grade_7 3 27 9   0 23     0   3   29 36     13.0   1.0     51.0   11.0   65 3 27 9   0 23     0   3   29 36     13 1   51 11   65
1716870 MN Ramsey 62 school 2733840 625 Independent Districts and Schools St. Paul Public School District 273384001594 494 Capitol Hill Magnet/Rondo Elementary School (Grades PK-6) Regular School No Elementary 01 08 2021   grade_7 64 59 8   0 45     0   16   94 98     18.0   0.0     92.0   15.0   192 64 59 8   0 45     0   16   94 98     18 0   92 15   192
1716923 MN Ramsey 62 school 2733840 625 Independent Districts and Schools St. Paul Public School District 273384001612 528 Global Arts Plus Upper Elementary School (Grades PK-6) Regular School No Middle 05 08 2021   grade_7 47 40 26   2 16     0   9   67 73     31.0   2.0     77.0   27.0   140 47 40 26   2 16     0   9   67 73     31 2   77 27   140
1717007 MN Ramsey 62 school 2733840 625 Independent Districts and Schools St. Paul Public School District 273384002303 579 American Indian Magnet School Elementary School (Grades PK-6) Regular School No Elementary PK 08 2021   grade_7 3 11 17   9 21     0   14   34 41     21.0   3.0     *   10.0   75 3 11 17   9 21     0   14   34 41     21 3     10   75
1717535 MN Stearns 73 school 2733510 742 Independent Districts and Schools St. Cloud Public School District 273351001485 25 Kennedy Community School Elementary School (Grades PK-6) Regular School No Elementary PK 08 2021   grade_7 33 24 3   0 1     0   5   35 31     7.0   2.0     32.0   14.0   66 33 24 3   0 1     0   5   35 31     7 2   32 14   66
1718906 MN Big Stone 6 school 2700150 2888 Independent Districts and Schools Clinton-Graceville-Beardsley 270015003019 6 Lismore Colony Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 08 2021   grade_7 5 0 0   0 0     0   0   1 4     *   *     *   *   5 5 0 0   0 0     0   0   1 4                 5
1718998 MN Lesueur 40 school 2700379 2905 Independent Districts and Schools Tri-City United School District 270037904626 10 Le Center Pre K-8 Elementary School (Grades PK-6) Regular School No Elementary PK 08 2021   grade_7 26 1 17   0 0     0   1   27 18     8.0   0.0     17.0   4.0   45 26 1 17   0 0     0   1   27 18     8 0   17 4   45
1719009 MN Lesueur 40 school 2700379 2905 Independent Districts and Schools Tri-City United School District 270037904625 30 Montgomery Pre K-8 Elementary School (Grades PK-6) Regular School No Elementary PK 08 2021   grade_7 81 1 8   1 2     0   3   55 41     1.0   2.0     34.0   14.0   96 81 1 8   1 2     0   3   55 41     1 2   34 14   96
1719100 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124000942 106 Barton Open Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 08 2021   grade_7 37 32 5   1 0     0   0   35 40     9.0   0.0     31.0   8.0   75 37 32 5   1 0     0   0   35 40     9 0   31 8   75
1719121 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124000969 121 Lake Harriet Upper School Elementary School (Grades PK-6) Regular School No Middle 04 08 2021   grade_7 102 2 5   0 3     0   3   52 63     3.0   0.0     6.0   9.0   115 102 2 5   0 3     0   3   52 63     3 0   6 9   115
1719142 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124000988 134 Lake Nokomis Comm-Keewaydin Campus Elementary School (Grades PK-6) Regular School No Middle 03 08 2021   grade_7 42 12 10   1 1     1   9   37 39     6.0   0.0     33.0   18.0   76 42 12 10   1 1     1   9   37 39     6 0   33 18   76
1719213 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124001031 160 Seward Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 08 2021   grade_7 34 44 5   4 2     0   4   43 50     9.0   0.0     56.0   5.0   93 34 44 5   4 2     0   4   43 50     9 0   56 5   93
1719251 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124001866 175 Folwell Arts Magnet Elementary School (Grades PK-6) Regular School No Elementary PK 08 2021   grade_7 8 20 49   6 2     0   2   38 49     34.0   1.0     77.0   15.0   87 8 20 49   6 2     0   2   38 49     34 1   77 15   87
1719263 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124000986 179 Jefferson Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 08 2021   grade_7 0 13 20   3 1     0   1   20 18     13.0   1.0     32.0   11.0   38 0 13 20   3 1     0   1   20 18     13 1   32 11   38
1719282 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 2021   grade_7 2 22 54   2 0     0   2   39 43     45.0   4.0     73.0   21.0   82 2 22 54   2 0     0   2   39 43     45 4   73 21   82
1719294 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124002297 193 Sullivan Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 08 2021   grade_7 1 37 3   6 0     0   1   24 24     13.0   0.0     *   11.0   48 1 37 3   6 0     0   1   24 24     13 0     11   48
1719321 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124002144 226 Marcy Open Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 08 2021   grade_7 32 33 6   5 4     0   0   44 36     8.0   0.0     42.0   15.0   80 32 33 6   5 4     0   0   44 36     8 0   42 15   80
1719397 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124004239 291 Hmong International Academy Elementary School (Grades PK-6) Regular School No Elementary PK 08 2021   grade_7 0 28 6   1 13     0   1   21 28     19.0   2.0     40.0   12.0   49 0 28 6   1 13     0   1   21 28     19 2   40 12   49
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
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
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
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
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
1720644 MN Aitkin 1 school 2714010 2 Independent Districts and Schools Hill City Public School District 271401004653 2 Hill City Middle School Middle School (Grades 5-8) Regular School No Middle 05 08 2021   grade_7 13 1 0   2 0     0   0   7 9     0.0   0.0     10.0   5.0   16 13 1 0   2 0     0   0   7 9     0 0   10 5   16
1720648 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000117 3 Anoka Middle School For The Arts Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 398 77 48   1 32     0   43   307 292     26.0   3.0     185.0   87.0   599 398 77 48   1 32     0   43   307 292     26 3   185 87   599
1720652 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000099 4 Coon Rapids Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 281 106 40   6 37     1   58   258 271     35.0   19.0     248.0   91.0   529 281 106 40   6 37     1   58   258 271     35 19   248 91   529
1720656 MN Hennepin 27 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000108 6 Jackson Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 334 131 52   3 83     0   62   334 331     46.0   4.0     219.0   86.0   665 334 131 52   3 83     0   62   334 331     46 4   219 86   665
1720660 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000119 90 Northdale Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 249 56 30   2 41     2   35   216 199     24.0   7.0     118.0   46.0   415 249 56 30   2 41     2   35   216 199     24 7   118 46   415
1720664 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318002501 193 Oak View Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 331 17 13   3 16     0   24   226 178     9.0   4.0     65.0   *   404 331 17 13   3 16     0   24   226 178     9 4   65     404
1720668 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000122 195 Roosevelt Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 186 27 8   1 24     0   25   137 134     *   3.0     64.0   *   271 186 27 8   1 24     0   25   137 134       3   64     271
1720672 MN Anoka 2 school 2708100 12 Independent Districts and Schools Centennial Public School District 270810002784 166 Centennial Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 379 39 35   0 31     2   30   247 269     21.0   2.0     71.0   87.0   516 379 39 35   0 31     2   30   247 269     21 2   71 87   516
1720676 MN Anoka 2 school 2709510 13 Independent Districts and Schools Columbia Heights Public School District 270951000395 17 Columbia Academy Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 43 68 101   3 9     1   21   124 122     59.0   3.0     199.0   47.0   246 43 68 101   3 9     1   21   124 122     59 3   199 47   246
1720681 MN Anoka 2 school 2712420 14 Independent Districts and Schools Fridley Public School District 271242000610 23 Fridley Middle Middle School (Grades 5-8) Regular School No Middle 05 08 2021   grade_7 60 94 30   5 13     0   24   117 109     *   *     *   *   226 60 94 30   5 13     0   24   117 109                 226
1720685 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 2021   grade_7 233 2 14   2 15     0   15   127 154     4.0   2.0     69.0   33.0   281 233 2 14   2 15     0   15   127 154     4 2   69 33   281
1720690 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 2021   grade_7 276 55 77   4 38     0   36   231 255     44.0   2.0     143.0   64.0   486 276 55 77   4 38     0   36   231 255     44 2   143 64   486
1720694 MN Becker 3 school 2710230 22 Independent Districts and Schools Detroit Lakes Public School District 271023000443 4 Detroit Lakes Middle Middle School (Grades 5-8) Regular School No Middle 05 08 2021   grade_7 148 1 3   45 0     0   1   106 92     *   *     *   *   198 148 1 3   45 0     0   1   106 92                 198

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