Data source: Big Local News · About: Big Local

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

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
1712951 MN Ramsey 62 school 2702264 916 Intermediate Districts and Schools Northeast Metro 916 270226404818 29 Assessment Center Secondary School (Grades 7-12) Regular School No Other KG 12 2021   grade_7 0 0 1   0 0     0   0   0 1     *   *     *   *   1 0 0 1   0 0     0   0   0 1                 1
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
1721526 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124004882 327 Franklin Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 0 68 20   4 0     1   2   52 43     11.0   3.0     82.0   27.0   95 0 68 20   4 0     1   2   52 43     11 3   82 27   95
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
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
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
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
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
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
1721615 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 2021   grade_7 0 44 0   0 0     0   2   24 22     0.0   3.0     37.0   11.0   46 0 44 0   0 0     0   2   24 22     0 3   37 11   46
1721624 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 2021   grade_7 0 31 3   0 0     0   0   23 11     14.0   0.0     *   8.0   34 0 31 3   0 0     0   0   23 11     14 0     8   34
1721642 MN Ramsey 62 school 2700399 4231 Charter Schools Minnesota Math and Science Academy 270039905177 20 MMSA Middle School Middle School (Grades 5-8) Regular School Yes Middle 05 08 2021   grade_7 0 47 2   0 1     0   1   28 23     35.0   0.0     *   5.0   51 0 47 2   0 1     0   1   28 23     35 0     5   51
1721649 MN Ramsey 62 school 2700423 4243 Charter Schools North Metro Flex Academy 270042305320 20 North Metro Flex Middle School Middle School (Grades 5-8) Regular School Yes Middle 07 08 2021   grade_7 0 8 7   0 0     0   2   4 13     2.0   1.0     *   3.0   17 0 8 7   0 0     0   2   4 13     2 1     3   17
1721655 MN Hennepin 27 school 2700439 4261 Charter Schools SciTech Academy Charter School 270043905291 20 SciTech Academy Middle Middle School (Grades 5-8) Regular School Yes Middle 06 08 2021   grade_7 0 19 0   0 0     0   0   9 10     *   0.0     *   3.0   19 0 19 0   0 0     0   0   9 10       0     3   19
1722630 MN Ramsey 62 school 2700152 4031 Charter Schools Jennings Community School 270015202947 10 Jennings Experiential High School Senior High School (Grades 9-12) Regular School Yes High 07 12 2021   grade_7 0 0 0   1 0     0   0   1 0     *   *     *   *   1 0 0 0   1 0     0   0   1 0                 1
1722801 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318002974 812 Compass-Bell Center Public Area Learning Center ALC (State approved) Alternative School No High 06 12 2021   grade_7 0 0 0   0 0     0   1   0 1     *   *     *   *   1 0 0 0   0 0     0   1   0 1                 1
1722815 MN Anoka 2 school 2712420 14 Independent Districts and Schools Fridley Public School District 271242003427 652 Fridley Middle Area Learning Center Public Area Learning Center ALC (State approved) Alternative School No Middle 05 08 2021   grade_7 0 0 1   1 0     0   1   1 2     *   *     *   *   3 0 0 1   1 0     0   1   1 2                 3
1722827 MN Becker 3 school 2710230 22 Independent Districts and Schools Detroit Lakes Public School District 271023003061 32 Detroit Lakes Middle ALC Public Area Learning Center ALC (State approved) Alternative School No Middle 06 08 2021   grade_7 0 0 1   0 0     0   0   1 0     *   *     *   *   1 0 0 1   0 0     0   0   1 0                 1
1722849 MN Beltrami 4 school 2730510 38 Independent Districts and Schools Red Lake Public School District 273051002793 50 Red Lake Middle Level ALC Public Area Learning Center ALC (State approved) Alternative School No Middle 06 08 2021   grade_7 0 0 0   4 0     0   0   1 3     *   *     *   *   4 0 0 0   4 0     0   0   1 3                 4
1722953 MN Hennepin 27 school 2742160 284 Independent Districts and Schools Wayzata Public School District 274216003743 952 East Middle Alternative (EMAP) Public Area Learning Center ALC (State approved) Alternative School No Middle 06 08 2021   grade_7 0 1 2   0 2     0   1   4 2     *   *     *   *   6 0 1 2   0 2     0   1   4 2                 6
1723004 MN Mahnomen 44 school 2718660 432 Independent Districts and Schools Mahnomen Public School District 271866002333 40 MAHNOMEN AREA LEARNING CENTER Public Area Learning Center ALC (State approved) Alternative School No High 06 12 2021   grade_7 0 0 0   3 0     0   0   2 1     *   *     *   *   3 0 0 0   3 0     0   0   2 1                 3
1723046 MN Nobles 53 school 2744160 518 Independent Districts and Schools Worthington Public School District 274416002335 6 Learning Center Public Area Learning Center ALC (State approved) Alternative School No High 07 12 2021   grade_7 0 0 2   0 0     0   0   1 1     *   *     *   *   2 0 0 2   0 0     0   0   1 1                 2
1723383 MN Saint Louis 69 school 2700224 6076 Miscellaneous Cooperatives Northland Learning Center 270022403477 10 Northland Learning Center 010 Public Area Learning Center ALC (State approved) Alternative School No Other PK 12 2021   grade_7 0 1 0   0 0     0   0   0 1     *   *     *   *   1 0 1 0   0 0     0   0   0 1                 1
1723438 MN Beltrami 4 school 2704440 31 Independent Districts and Schools Bemidji Public School District 270444004194 70 Lakeside Learning Center Special Education Special Education School No High 06 12 2021   grade_7 0 0 0   1 0     0   0   1 0     *   *     *   *   1 0 0 0   1 0     0   0   1 0                 1
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
1723717 MN Ramsey 62 school 2733840 625 Independent Districts and Schools St. Paul Public School District 273384004275 607 Rivereast Program Special Education Special Education School No Other KG 12 2021   grade_7 0 1 0   0 0     0   2   3 0     *   *     *   *   3 0 1 0   0 0     0   2   3 0                 3
1723986 MN Ramsey 62 school 2702264 916 Intermediate Districts and Schools Northeast Metro 916 270226402108 56 South Campus Education Center Special Education Special Education School No High 05 12 2021   grade_7 0 2 0   0 0     0   0   1 1     *   *     *   *   2 0 2 0   0 0     0   0   1 1                 2
1724084 MN Dakota 19 school 2700026 917 Intermediate Districts and Schools Intermediate School District 917 270002605108 900 Customized Alternative Solutions for Education (CASE) Special Education Special Education School No Other PK 12 2021   grade_7 0 1 0   0 0     0   0   0 1     *   *     *   *   1 0 1 0   0 0     0   0   0 1                 1
1724154 MN Wright 86 school 2700045 938 Special Education Cooperatives Meeker And Wright Special Education 270004502732 18 Eastern Wright Program Special Education Special Education School No Elementary KG 08 2021   grade_7 0 0 1   0 0     0   0   1 0     *   *     *   *   1 0 0 1   0 0     0   0   1 0                 1
1724318 MN Otter Tail 56 school 2700083 926 Service Cooperative (ECSU Region) Region 4-Lakes Country Service Coop 270008305103 30 Lakes Country Academy - FF Special Education Special Education School No Other KG 12 2021   grade_7 0 1 0   0 0     0   0   1 0     *   *     *   *   1 0 1 0   0 0     0   0   1 0                 1
1724959 MN Beltrami 4 school 2704440 31 Independent Districts and Schools Bemidji Public School District 270444000313 160 First City School Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No Other 03 12 2021   grade_7 0 0 0   1 0     0   0   1 0     *   *     *   *   1 0 0 0   1 0     0   0   1 0                 1
1724966 MN Beltrami 4 school 2704440 31 Independent Districts and Schools Bemidji Public School District 270444004315 190 Oshki Manidoo Center Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No High 07 12 2021   grade_7 0 0 0   1 0     0   0   1 0     *   *     *   *   1 0 0 0   1 0     0   0   1 0                 1
1724969 MN Cass 11 school 2730870 118 Independent Districts and Schools Northland Community Schools 273087003507 40 Little Sand Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No High 07 12 2021   grade_7 0 0 0   1 0     0   1   0 2     *   *     *   *   2 0 0 0   1 0     0   1   0 2                 2
1724977 MN Clay 14 school 2721420 152 Independent Districts and Schools Moorhead Public School District 272142000413 960 West Central Academy-S Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No Other 04 12 2021   grade_7 0 0 0   1 0     0   0   0 1     *   *     *   *   1 0 0 0   1 0     0   0   0 1                 1
1725134 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124001933 685 Stadium View Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No High 06 12 2021   grade_7 0 1 0   0 0     0   0   0 1     *   *     *   *   1 0 1 0   0 0     0   0   0 1                 1
1725198 MN Wright 86 school 2700045 938 Special Education Cooperatives Meeker And Wright Special Education 270004502964 16 VILLAGE RANCH ALTERNATIVE PROGRAM Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No High 05 12 2021   grade_7 0 1 0   0 0     0   0   1 0     *   *     *   *   1 0 1 0   0 0     0   0   1 0                 1
1725210 MN Wright 86 school 2700045 938 Special Education Cooperatives Meeker And Wright Special Education 270004505005 26 Sholund School for Girls Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No High 05 12 2021   grade_7 0 0 0   0 0     0   1   0 1     *   *     *   *   1 0 0 0   0 0     0   1   0 1                 1
1725278 MN Ramsey 62 school 2722950 621 Independent Districts and Schools Mounds View Public School District 272295004678 45 Options Educational Oversight to Public Care and Treatment Day Program Alternative School No High 06 12 2021   grade_7 0 0 1   0 0     0   0   1 0     *   *     *   *   1 0 0 1   0 0     0   0   1 0                 1
1725319 MN Stearns 73 school 2733510 742 Independent Districts and Schools St. Cloud Public School District 273351001640 72 Riverwoods School Non-Residential Educational Oversight to Public Care and Treatment Day Program Alternative School No Other KG 12 2021   grade_7 0 6 0   0 0     0   2   8 0     *   *     *   *   8 0 6 0   0 0     0   2   8 0                 8
1725344 MN Hennepin 27 school 2700025 287 Intermediate Districts and Schools Intermediate School District 287 270002504533 527 Headway Academy Educational Oversight to Public Care and Treatment Day Program Alternative School No High 07 12 2021   grade_7 0 0 0   0 0     0   1   0 1     *   *     *   *   1 0 0 0   0 0     0   1   0 1                 1
1725472 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124001903 361 Center School Private Alternative Program Alternative School No High 07 12 2021   grade_7 0 0 0   2 0     0   0   1 1     *   *     *   *   2 0 0 0   2 0     0   0   1 1                 2
1725491 MN Rock 67 school 2718330 2184 Independent Districts and Schools Luverne Public School District 271833004162 10 Pinnacle Programs Southwestern Youth Services Educational Oversight to Private Residential Care & Treatment (State approved) Alternative School No High 06 12 2021   grade_7 0 0 0   2 0     0   0   2 0     *   *     *   *   2 0 0 0   2 0     0   0   2 0                 2
1725560 MN Aitkin 1 school 2700300 4177 Charter Schools Minisinaakwaang Leadership Academy 270030003730 10 Minisinaakwaang Leadership Academy Elementary/Secondary Combined (Grades K-12 limited to District Type 34 Bureau of Indian Education) Regular School Yes Other KG 12 2021   grade_7 0 0 0   5 0     0   1   2 4     *   *     *   *   6 0 0 0   5 0     0   1   2 4                 6
1712058 MN Lincoln 41 school 2717460 404 Independent Districts and Schools Lake Benton Public School District 271746000802 20 Lake Benton Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 1 0 0   0 0     0   0   0 1     *   *     *   *   1 1 0 0   0 0     0   0   0 1                 1
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
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
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
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
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
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
1720702 MN Beltrami 4 school 2730510 38 Independent Districts and Schools Red Lake Public School District 273051002427 40 Red Lake Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 1 0 0   83 0     0   0   51 33     0.0   18.0     *   21.0   84 1 0 0   83 0     0   0   51 33     0 18     21   84
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
1723015 MN Mille Lacs 48 school 2715510 473 Independent Districts and Schools Isle Public School District 271551002819 40 ISLE AREA LEARNING CENTER Public Area Learning Center ALC (State approved) Alternative School No High 07 12 2021   grade_7 1 0 0   0 0     0   0   0 1     *   *     *   *   1 1 0 0   0 0     0   0   0 1                 1
1723157 MN Sherburne 71 school 2711370 728 Independent Districts and Schools Elk River School District 271137005158 610 Ivan Sand Middle School ALC Public Area Learning Center ALC (State approved) Alternative School No Middle 06 08 2021   grade_7 1 0 0   0 0     0   0   0 1     *   *     *   *   1 1 0 0   0 0     0   0   0 1                 1
1723164 MN Stearns 73 school 2709440 750 Independent Districts and Schools Rocori Public School District 270944004629 70 Rocori ALC Public Area Learning Center ALC (State approved) Alternative School No High 07 12 2021   grade_7 1 0 0   0 0     0   0   0 1     *   *     *   *   1 1 0 0   0 0     0   0   0 1                 1
1723357 MN Stearns 73 school 2791455 6026 Education Districts West Central Education District 279145502388 20 West Central Area Learning Center Public Area Learning Center ALC (State approved) Alternative School No High 06 12 2021   grade_7 1 0 1   0 0     0   2   2 2     *   *     *   *   4 1 0 1   0 0     0   2   2 2                 4
1723639 MN Olmsted 55 school 2731800 535 Independent Districts and Schools Rochester Public School District 273180000985 342 Rochester Phoenix Academy Special Education Special Education School No Other KG 12 2021   grade_7 1 1 1   0 0     0   2   4 1     *   *     *   *   5 1 1 1   0 0     0   2   4 1                 5
1723788 MN Sherburne 71 school 2711370 728 Independent Districts and Schools Elk River School District 271137004142 401 ISD 728 Focus/Journey Special Education Special Education School No Other 01 12 2021   grade_7 1 0 0   0 0     0   1   2 0     *   *     *   *   2 1 0 0   0 0     0   1   2 0                 2
1723846 MN Isanti 30 school 2707410 911 Independent Districts and Schools Cambridge-Isanti Public School District 270741005198 701 Brookside Academy Special Education Special Education School No Other KG 12 2021   grade_7 1 0 0   0 0     0   0   1 0     *   *     *   *   1 1 0 0   0 0     0   0   1 0                 1
1723875 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124003022 625 River Bend Educational Center Special Education Special Education School No Other KG 12 2021   grade_7 1 12 0   1 0     0   0   13 1     0.0   0.0     11.0   *   14 1 12 0   1 0     0   0   13 1     0 0   11     14
1724037 MN Dakota 19 school 2700026 917 Intermediate Districts and Schools Intermediate School District 917 270002602125 61 917 Paces Special Education Special Education School No Other KG 12 2021   grade_7 1 2 0   0 1     0   0   4 0     *   *     *   *   4 1 2 0   0 1     0   0   4 0                 4
1724060 MN Dakota 19 school 2700026 917 Intermediate Districts and Schools Intermediate School District 917 270002603897 500 917 Dash Special Education Special Education School No Other PK 12 2021   grade_7 1 0 0   0 0     0   0   1 0     *   *     *   *   1 1 0 0   0 0     0   0   1 0                 1
1724074 MN Dakota 19 school 2700026 917 Intermediate Districts and Schools Intermediate School District 917 270002604371 700 TEA Special Education Special Education School No Other PK 12 2021   grade_7 1 0 0   0 0     0   0   0 1     *   *     *   *   1 1 0 0   0 0     0   0   0 1                 1
1724090 MN Clay 14 school 2700040 397 Special Education Cooperatives Lake Agassiz Education Cooperative 270004003643 11 Intensive Interagency Program Special Education Special Education School No High 07 12 2021   grade_7 1 0 0   0 0     0   0   0 1     *   *     *   *   1 1 0 0   0 0     0   0   0 1                 1
1724224 MN Mower 50 school 2700327 6083 Special Education Cooperatives Southern MN Education Consortium 270032705231 150 RESET Special Education Special Education School No Other 01 12 2021   grade_7 1 0 0   0 0     0   0   1 0     *   *     *   *   1 1 0 0   0 0     0   0   1 0                 1
1724295 MN Rice 66 school 2700424 6094 Special Education Cooperatives Cannon Valley Special Education Cooperative 270042405068 20 Laura Baker SUN Program Special Education Special Education School No Other PK 12 2021   grade_7 1 0 0   0 0     0   0   1 0     *   *     *   *   1 1 0 0   0 0     0   0   1 0                 1
1724369 MN Pipestone 59 school 2700086 991 Service Cooperative (ECSU Region) Region 6 and 8-SW/WC Service Cooperative 270008604353 29 SWWC ELC - Pipestone Special Education Special Education School No Other KG 12 2021   grade_7 1 0 0   0 0     0   0   1 0     *   *     *   *   1 1 0 0   0 0     0   0   1 0                 1
1724380 MN Kandiyohi 34 school 2700086 991 Service Cooperative (ECSU Region) Region 6 and 8-SW/WC Service Cooperative 270008604724 47 SWWC ELC - Willmar Special Education Special Education School No Other KG 12 2021   grade_7 1 0 2   0 0     0   0   3 0     *   *     *   *   3 1 0 2   0 0     0   0   3 0                 3
1724430 MN Wadena 80 school 2700014 6004 Education Districts Freshwater Education District 270001404821 50 Elm Tree Academy Special Education Special Education School No Other 02 12 2021   grade_7 1 0 0   0 0     0   0   1 0     *   *     *   *   1 1 0 0   0 0     0   0   1 0                 1

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "enrollments" (
   [state] TEXT,
   [county] TEXT,
   [county_state_id] INTEGER,
   [admin_level] TEXT,
   [district_nces_id] INTEGER,
   [district_state_id] TEXT,
   [district_state_type] TEXT,
   [district] TEXT,
   [school_nces_id] INTEGER,
   [school_state_id] INTEGER,
   [school] TEXT,
   [school_state_type] TEXT,
   [ccd_school_type] TEXT,
   [ccd_charter_school] TEXT,
   [ccd_school_lvl] TEXT,
   [ccd_school_low_grade] TEXT,
   [ccd_school_high_grade] TEXT,
   [year] INTEGER,
   [term] TEXT,
   [grade] TEXT,
   [white] TEXT,
   [black] TEXT,
   [hispanic] TEXT,
   [native_american] TEXT,
   [native_american_alaskan_native] TEXT,
   [asian] TEXT,
   [native_hawaiian] TEXT,
   [asian_pacific_islander] TEXT,
   [native_hawaiian_pacific_islander] TEXT,
   [pacific_islander] TEXT,
   [multiracial] TEXT,
   [unknown_race] TEXT,
   [male] TEXT,
   [female] TEXT,
   [non_binary] TEXT,
   [unknown_gender] TEXT,
   [ell] TEXT,
   [ell_percent] TEXT,
   [homeless] TEXT,
   [homeless_percent] TEXT,
   [low_income] TEXT,
   [free_and_reduced] TEXT,
   [free_and_reduced_percent] TEXT,
   [disability] TEXT,
   [section_504] TEXT,
   [total] TEXT
, [white_int] INTEGER, [black_int] INTEGER, [hispanic_int] INTEGER, [native_american_int] INTEGER, [native_american_alaskan_native_int] INTEGER, [asian_int] INTEGER, [native_hawaiian_int] INTEGER, [asian_pacific_islander_int] INTEGER, [native_hawaiian_pacific_islander_int] INTEGER, [pacific_islander_int] INTEGER, [multiracial_int] INTEGER, [unknown_race_int] INTEGER, [male_int] INTEGER, [female_int] INTEGER, [non_binary_int] INTEGER, [unknown_gender_int] INTEGER, [ell_int] INTEGER, [homeless_int] INTEGER, [low_income_int] INTEGER, [free_and_reduced_int] INTEGER, [disability_int] INTEGER, [section_504_int] INTEGER, [total_int] INTEGER);
CREATE INDEX [idx_enrollments_state_grade]
    ON [enrollments] ([state], [grade]);
CREATE INDEX [idx_enrollments_grade]
    ON [enrollments] ([grade]);
CREATE INDEX [idx_enrollments_year]
    ON [enrollments] ([year]);
CREATE INDEX [idx_enrollments_state_year]
    ON [enrollments] ([state], [year]);
CREATE INDEX [idx_enrollments_school_nces_id]
    ON [enrollments] ([school_nces_id]);
CREATE INDEX [idx_enrollments_district_nces_id]
    ON [enrollments] ([district_nces_id]);