Data source: Big Local News · About: Big Local

978 rows where grade = "grade_2", state = "MN" and year = 2021 sorted by white

View and edit SQL

year

  • 2021 · 978

grade

  • grade_2 · 978
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
1713545 MN Anoka 2 school 2733330 16 Independent Districts and Schools Spring Lake Park Public Schools 273333004657 787 Elementary Lighthouse Elementary School (Grades PK-6) Regular School No Elementary 01 06 2021   grade_2 0 0 0   0 1     0   0   1 0     *   *     *   *   1 0 0 0   0 1     0   0   1 0                 1
1713578 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_2 0 0 1   12 0     0   0   4 9     0.0   0.0     11.0   4.0   13 0 0 1   12 0     0   0   4 9     0 0   11 4   13
1713645 MN Beltrami 4 school 2730510 38 Independent Districts and Schools Red Lake Public School District 273051001302 10 Red Lake Elementary Elementary School (Grades PK-6) Regular School No Elementary 01 05 2021   grade_2 0 0 0   111 0     0   0   57 54     0.0   7.0     *   22.0   111 0 0 0   111 0     0   0   57 54     0 7     22   111
1713655 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_2 0 0 0   19 0     0   0   12 7     0.0   4.0     *   2.0   19 0 0 0   19 0     0   0   12 7     0 4     2   19
1715131 MN Hennepin 27 school 2725200 279 Independent Districts and Schools Osseo Public School District 272520001210 672 Crest View Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   grade_2 0 25 7   1 3     0   0   15 21     11.0   *     24.0   5.0   36 0 25 7   1 3     0   0   15 21     11     24 5   36
1716877 MN Ramsey 62 school 2733840 625 Independent Districts and Schools St. Paul Public School District 273384001593 496 Highwood Hills Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   grade_2 0 15 4   0 9     0   2   14 16     17.0   0.0     25.0   1.0   30 0 15 4   0 9     0   2   14 16     17 0   25 1   30
1716945 MN Ramsey 62 school 2733840 625 Independent Districts and Schools St. Paul Public School District 273384001619 541 Phalen Lake Hmong Studies Magnet Elementary School (Grades PK-6) Regular School No Elementary PK 06 2021   grade_2 0 1 4   0 107     0   0   59 53     78.0   0.0     84.0   8.0   112 0 1 4   0 107     0   0   59 53     78 0   84 8   112
1717195 MN Saint Louis 69 school 2733720 707 Independent Districts and Schools Nett Lake Public School District 273372001508 1 Nett Lake Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2021   grade_2 0 0 0   7 0     0   0   5 2     *   *     *   *   7 0 0 0   7 0     0   0   5 2                 7
1719309 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124004172 225 Anishinabe Academy Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   grade_2 0 1 3   19 0     0   4   11 16     *   1.0     *   4.0   27 0 1 3   19 0     0   4   11 16       1     4   27
1719366 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124002580 287 Hall International Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   grade_2 0 28 3   1 0     0   1   17 16     1.0   0.0     *   6.0   33 0 28 3   1 0     0   1   17 16     1 0     6   33
1719440 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_2 0 7 0   0 0     0   0   3 4     *   *     *   *   7 0 7 0   0 0     0   0   3 4                 7
1719504 MN Hennepin 27 school 2700117 4017 Charter Schools Minnesota Transitions Charter School 270011704989 21 Banaadir Elementary Elementary School (Grades PK-6) Regular School Yes Elementary KG 04 2021   grade_2 0 40 0   0 0     0   0   22 18     27.0   0.0     *   4.0   40 0 40 0   0 0     0   0   22 18     27 0     4   40
1719539 MN Ramsey 62 school 2700140 4027 Charter Schools Higher Ground Academy 270014002719 10 Higher Ground Academy Elementary School (Grades PK-6) Regular School Yes Elementary KG 06 2021   grade_2 0 85 0   0 0     0   0   47 38     29.0   0.0     *   1.0   85 0 85 0   0 0     0   0   47 38     29 0     1   85
1719557 MN Ramsey 62 school 2700156 4035 Charter Schools Life Prep 270015602951 10 LIFE Prep Elementary School (Grades PK-6) Regular School Yes Elementary PK 06 2021   grade_2 0 18 3   2 8     0   0   19 12     5.0   0.0     21.0   3.0   31 0 18 3   2 8     0   0   19 12     5 0   21 3   31
1719566 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_2 0 25 4   0 0     0   2   16 15     4.0   3.0     *   5.0   31 0 25 4   0 0     0   2   16 15     4 3     5   31
1719639 MN Hennepin 27 school 2700220 4067 Charter Schools Aurora Charter School 270022003473 10 Aurora Charter School Elementary School (Grades PK-6) Regular School Yes Elementary PK 04 2021   grade_2 0 0 42   0 0     0   0   22 20     *   0.0     33.0   6.0   42 0 0 42   0 0     0   0   22 20       0   33 6   42
1719646 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_2 0 49 3   0 0     0   0   21 31     17.0   4.0     *   6.0   52 0 49 3   0 0     0   0   21 31     17 4     6   52
1719656 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_2 0 1 1   0 70     0   0   38 34     46.0   1.0     57.0   3.0   72 0 1 1   0 70     0   0   38 34     46 1   57 3   72
1719687 MN Hennepin 27 school 2700189 4078 Charter Schools Twin Cities International Schools 270018905160 20 Twin Cities International Schools Elementary School (Grades PK-6) Regular School Yes Elementary KG 04 2021   grade_2 0 121 0   0 0     0   0   66 55     65.0   0.0     *   9.0   121 0 121 0   0 0     0   0   66 55     65 0     9   121
1719694 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_2 0 40 2   0 0     0   0   22 20     1.0   1.0     *   7.0   42 0 40 2   0 0     0   0   22 20     1 1     7   42
1719720 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_2 0 9 0   0 60     0   1   35 35     26.0   0.0     *   5.0   70 0 9 0   0 60     0   1   35 35     26 0     5   70
1719748 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_2 0 5 39   0 0     0   1   27 18     33.0   0.0     35.0   8.0   45 0 5 39   0 0     0   1   27 18     33 0   35 8   45
1719775 MN Ramsey 62 school 2700342 4103 Charter Schools Hmong College Prep Academy 270034205102 30 Hmong College Prep Academy ES Elementary School (Grades PK-6) Regular School Yes Elementary KG 05 2021   grade_2 0 0 0   0 180     0   0   83 97     83.0   0.0     135.0   13.0   180 0 0 0   0 180     0   0   83 97     83 0   135 13   180
1719850 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_2 0 48 0   0 0     0   0   26 22     19.0   0.0     *   5.0   48 0 48 0   0 0     0   0   26 22     19 0     5   48
1719868 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_2 0 12 0   0 0     0   0   7 5     0.0   0.0     *   4.0   12 0 12 0   0 0     0   0   7 5     0 0     4   12
1719898 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_2 0 4 2   0 92     0   1   50 49     72.0   2.0     57.0   7.0   99 0 4 2   0 92     0   1   50 49     72 2   57 7   99
1719933 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_2 0 42 0   0 0     0   0   19 23     37.0   0.0     *   0.0   42 0 42 0   0 0     0   0   19 23     37 0     0   42
1719943 MN Mahnomen 44 school 2700275 4155 Charter Schools Naytahwaush Community School 270027503580 10 Naytahwaush Community School Elementary School (Grades PK-6) Regular School Yes Elementary KG 06 2021   grade_2 0 0 0   20 0     0   0   8 12     0.0   0.0     15.0   2.0   20 0 0 0   20 0     0   0   8 12     0 0   15 2   20
1720014 MN Hennepin 27 school 2700288 4170 Charter Schools Hiawatha Academies 270028803725 10 Hiawatha Leadership Acad-Morris Pk Elementary School (Grades PK-6) Regular School Yes Elementary KG 04 2021   grade_2 0 8 31   0 0     0   1   21 19     30.0   2.0     32.0   6.0   40 0 8 31   0 0     0   1   21 19     30 2   32 6   40
1720020 MN Hennepin 27 school 2700288 4170 Charter Schools Hiawatha Academies 270028804669 12 Hiawatha Leadership Academy-Northrop Elementary School (Grades PK-6) Regular School Yes Elementary KG 04 2021   grade_2 0 5 45   2 0     0   1   22 31     45.0   2.0     46.0   8.0   53 0 5 45   2 0     0   1   22 31     45 2   46 8   53
1720033 MN Hennepin 27 school 2700295 4171 Charter Schools Noble Academy 270029505126 20 Nompeng Academy Elementary School (Grades PK-6) Regular School Yes Elementary KG 02 2021   grade_2 0 11 0   0 74     0   0   49 36     48.0   0.0     64.0   3.0   85 0 11 0   0 74     0   0   49 36     48 0   64 3   85
1720047 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_2 0 0 0   0 152     0   0   80 72     128.0   1.0     119.0   8.0   152 0 0 0   0 152     0   0   80 72     128 1   119 8   152
1720116 MN Hennepin 27 school 2700308 4191 Charter Schools KIPP Minnesota Charter School 270030805286 40 KIPP Legacy Primary Elementary School (Grades PK-6) Regular School Yes Elementary KG 02 2021   grade_2 0 11 0   0 0     0   0   4 7     0.0   1.0     *   3.0   11 0 11 0   0 0     0   0   4 7     0 1     3   11
1720130 MN Ramsey 62 school 2700325 4193 Charter Schools College Preparatory Elementary 270032504338 10 College Preparatory Elementary Elementary School (Grades PK-6) Regular School Yes Elementary KG 06 2021   grade_2 0 7 2   1 41     0   2   27 26     41.0   1.0     41.0   3.0   53 0 7 2   1 41     0   2   27 26     41 1   41 3   53
1720148 MN Cook 16 school 2700321 4195 Charter Schools Oshki Ogimaag Charter School 270032104293 10 Oshki Ogimaag Charter School Elementary School (Grades PK-6) Regular School Yes Elementary KG 06 2021   grade_2 0 0 0   5 0     0   0   4 1     *   *     *   *   5 0 0 0   5 0     0   0   4 1                 5
1720170 MN Ramsey 62 school 2700367 4200 Charter Schools STEP Academy Charter School 270036705139 20 STEP Academy Elementary Elementary School (Grades PK-6) Regular School Yes Elementary KG 05 2021   grade_2 0 40 1   0 0     0   2   22 21     18.0   0.0     32.0   1.0   43 0 40 1   0 0     0   2   22 21     18 0   32 1   43
1720202 MN Hennepin 27 school 2700373 4209 Charter Schools Mastery School 270037304602 10 Mastery School Elementary School (Grades PK-6) Regular School Yes Elementary KG 05 2021   grade_2 0 22 0   0 0     0   0   7 15     0.0   0.0     *   2.0   22 0 22 0   0 0     0   0   7 15     0 0     2   22
1720220 MN Ramsey 62 school 2700380 4213 Charter Schools Prodeo Academy 270038005150 20 Prodeo Academy St. Paul Elementary School (Grades PK-6) Regular School Yes Elementary PK 03 2021   grade_2 0 8 1   0 31     0   0   21 19     31.0   0.0     *   *   40 0 8 1   0 31     0   0   21 19     31 0         40
1720266 MN Stearns 73 school 2700395 4223 Charter Schools Saint Cloud Math and Science Academy Charter School 270039504752 10 Saint Cloud Math and Science Academy Charter School Elementary School (Grades PK-6) Regular School Yes Elementary KG 06 2021   grade_2 0 38 0   0 0     0   0   19 19     28.0   0.0     32.0   3.0   38 0 38 0   0 0     0   0   19 19     28 0   32 3   38
1720285 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_2 0 52 0   0 0     1   0   28 25     46.0   0.0     40.0   1.0   53 0 52 0   0 0     1   0   28 25     46 0   40 1   53
1720331 MN Ramsey 62 school 2700399 4231 Charter Schools Minnesota Math and Science Academy 270039904788 10 MMSA Elementary School Elementary School (Grades PK-6) Regular School Yes Elementary KG 04 2021   grade_2 0 41 0   0 0     0   0   21 20     *   0.0     *   1.0   41 0 41 0   0 0     0   0   21 20       0     1   41
1720337 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_2 0 22 0   0 1     0   0   13 10     15.0   0.0     18.0   2.0   23 0 22 0   0 1     0   0   13 10     15 0   18 2   23
1720362 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_2 0 48 0   0 0     0   0   28 20     43.0   0.0     *   2.0   48 0 48 0   0 0     0   0   28 20     43 0     2   48
1720417 MN Hennepin 27 school 2700433 4255 Charter Schools Skyline Math and Science Academy 270043305067 10 Skyline Math and Science Academy Elementary School (Grades PK-6) Regular School Yes Elementary KG 06 2021   grade_2 0 36 0   0 0     0   0   21 15     *   0.0     *   3.0   36 0 36 0   0 0     0   0   21 15       0     3   36
1720425 MN Ramsey 62 school 2700438 4258 Charter Schools The Journey School 270043805258 10 The Journey School Elementary School (Grades PK-6) Regular School Yes Elementary KG 06 2021   grade_2 0 2 2   0 0     0   4   6 2     *   *     *   *   8 0 2 2   0 0     0   4   6 2                 8
1720433 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 05 2021   grade_2 0 36 0   0 0     0   0   16 20     *   0.0     *   4.0   36 0 36 0   0 0     0   0   16 20       0     4   36
1720440 MN Dakota 19 school 2700445 4264 Charter Schools Gateway STEM Academy 270044505138 10 Gateway STEM Academy Charter School Elementary School (Grades PK-6) Regular School Yes Elementary KG 06 2021   grade_2 0 39 0   0 0     0   0   16 23     23.0   0.0     *   2.0   39 0 39 0   0 0     0   0   16 23     23 0     2   39
1720475 MN Ramsey 62 school 2700451 4269 Charter Schools Quantum STEAM Academy Charter School 270045105182 10 Quantum STEAM Academy Charter School Elementary School (Grades PK-6) Regular School Yes Elementary KG 06 2021   grade_2 0 13 0   0 0     0   0   8 5     *   0.0     *   1.0   13 0 13 0   0 0     0   0   8 5       0     1   13
1720513 MN Hennepin 27 school 2700460 4277 Charter Schools Metro Tech Academy Charter School 270046005321 20 Metro Tech Academy Elementary Elementary School (Grades PK-6) Regular School Yes Elementary KG 06 2021   grade_2 0 3 0   0 0     0   0   2 1     *   *     *   *   3 0 3 0   0 0     0   0   2 1                 3
1720521 MN Anoka 2 school 2700464 4282 Charter Schools Innovation Science and Technology Academy Charter School 270046405322 10 Innovation Science and Technology Academy Elementary School (Grades PK-6) Regular School Yes Elementary PK 05 2021   grade_2 0 7 0   0 0     0   0   3 4     *   *     *   *   7 0 7 0   0 0     0   0   3 4                 7
1723575 MN Hennepin 27 school 2731780 281 Independent Districts and Schools Robbinsdale Public School District 273178002441 103 Early Childhood Special Education Special Education Special Education School No Elementary PK 02 2021   grade_2 0 2 1   0 0     0   0   3 0     *   *     *   *   3 0 2 1   0 0     0   0   3 0                 3
1723712 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_2 0 1 0   0 0     0   1   2 0     *   *     *   *   2 0 1 0   0 0     0   1   2 0                 2
1723801 MN Stearns 73 school 2733510 742 Independent Districts and Schools St. Cloud Public School District 273351004648 62 Roosevelt Education Center Special Education Special Education School No Other KG 12 2021   grade_2 0 3 0   0 0     0   0   3 0     *   *     *   *   3 0 3 0   0 0     0   0   3 0                 3
1724081 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_2 0 0 0   0 1     0   0   1 0     *   *     *   *   1 0 0 0   0 1     0   0   1 0                 1
1724342 MN Redwood 64 school 2700086 991 Service Cooperative (ECSU Region) Region 6 and 8-SW/WC Service Cooperative 270008604438 22 SWWC ELC - Belview Special Education Special Education School No Other KG 12 2021   grade_2 0 0 1   0 0     0   0   1 0     *   *     *   *   1 0 0 1   0 0     0   0   1 0                 1
1724531 MN Nicollet 52 school 2700063 6027 Education Districts MN Valley Education District 270006304710 40 Minnesota River School Special Education Special Education School No Other KG 12 2021   grade_2 0 1 0   0 0     0   0   1 0     *   *     *   *   1 0 1 0   0 0     0   0   1 0                 1
1725288 MN Ramsey 62 school 2723850 622 Independent Districts and Schools North St. Paul-Maplewood Oakdale Public School District 272385004943 76 PrairieCare Maplewood Educational Oversight to Public Care and Treatment Day Program Alternative School No Other KG 12 2021   grade_2 0 1 2   0 0     0   0   3 0     *   *     *   *   3 0 1 2   0 0     0   0   3 0                 3
1725555 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_2 0 0 0   1 0     0   0   1 0     *   *     *   *   1 0 0 0   1 0     0   0   1 0                 1
1715156 MN Hennepin 27 school 2725200 279 Independent Districts and Schools Osseo Public School District 272520001213 675 Garden City Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   grade_2 1 11 10   1 8     0   3   13 21     12.0   *     28.0   4.0   34 1 11 10   1 8     0   3   13 21     12     28 4   34
1715165 MN Hennepin 27 school 2725200 279 Independent Districts and Schools Osseo Public School District 272520001219 678 Palmer Lake Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   grade_2 1 12 4   0 7     0   4   12 16     10.0   0.0     16.0   4.0   28 1 12 4   0 7     0   4   12 16     10 0   16 4   28
1716778 MN Ramsey 62 school 2733840 625 Independent Districts and Schools St. Paul Public School District 273384001581 464 Frost Lake Elementary School Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   grade_2 1 16 8   0 49     0   7   42 39     48.0   0.0     67.0   8.0   81 1 16 8   0 49     0   7   42 39     48 0   67 8   81
1717124 MN Lake of the Woods 39 school 2741850 690 Independent Districts and Schools Warroad Public School District 274185002456 20 Angle Inlet Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 06 2021   grade_2 1 0 0   0 0     0   0   0 1     *   *     *   *   1 1 0 0   0 0     0   0   0 1                 1
1718895 MN Big Stone 6 school 2700150 2888 Independent Districts and Schools Clinton-Graceville-Beardsley 270015005276 4 Big Stone Colony Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 08 2021   grade_2 1 0 0   0 0     0   0   1 0     *   *     *   *   1 1 0 0   0 0     0   0   1 0                 1
1719258 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_2 1 17 16   1 0     0   1   25 11     22.0   1.0     32.0   7.0   36 1 17 16   1 0     0   1   25 11     22 1   32 7   36
1719478 MN Ramsey 62 school 2700115 4015 Charter Schools Community of Peace Academy 270011502605 10 Community of Peace Academy Elementary School Elementary School (Grades PK-6) Regular School Yes Elementary PK 04 2021   grade_2 1 10 14   0 25     0   2   25 27     26.0   0.0     39.0   9.0   52 1 10 14   0 25     0   2   25 27     26 0   39 9   52
1719549 MN Ramsey 62 school 2700142 4029 Charter Schools St. Paul City School 270014202721 10 St. Paul City Primary School Elementary School (Grades PK-6) Regular School Yes Elementary PK 05 2021   grade_2 1 6 21   1 13     0   3   21 24     26.0   2.0     *   5.0   45 1 6 21   1 13     0   3   21 24     26 2     5   45
1719668 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_2 1 1 50   0 0     0   0   21 31     35.0   0.0     13.0   6.0   52 1 1 50   0 0     0   0   21 31     35 0   13 6   52
1719835 MN Hennepin 27 school 2700240 4126 Charter Schools Prairie Seeds Academy 270024003340 10 Prairie Seeds Elementary School Academy Elementary School (Grades PK-6) Regular School Yes Elementary KG 05 2021   grade_2 1 4 8   0 50     0   1   34 30     40.0   0.0     47.0   7.0   64 1 4 8   0 50     0   1   34 30     40 0   47 7   64
1720110 MN Hennepin 27 school 2700308 4191 Charter Schools KIPP Minnesota Charter School 270030804898 30 KIPP North Star Primary Elementary School (Grades PK-6) Regular School Yes Elementary KG 04 2021   grade_2 1 48 0   0 0     0   3   22 30     0.0   9.0     *   7.0   52 1 48 0   0 0     0   3   22 30     0 9     7   52
1720120 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_2 1 84 0   0 0     0   1   47 39     25.0   5.0     75.0   8.0   86 1 84 0   0 0     0   1   47 39     25 5   75 8   86
1720212 MN Anoka 2 school 2700380 4213 Charter Schools Prodeo Academy 270038005318 11 Prodeo Academy Columbia Heights Elementary Elementary School (Grades PK-6) Regular School Yes Elementary 02 04 2021   grade_2 1 63 12   0 1     0   5   28 54     20.0   3.0     *   *   82 1 63 12   0 1     0   5   28 54     20 3         82
1720295 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_2 1 0 0   14 0     0   0   10 5     2.0   6.0     10.0   4.0   15 1 0 0   14 0     0   0   10 5     2 6   10 4   15
1720353 MN Anoka 2 school 2700415 4239 Charter Schools Tesfa International School 270041504876 10 Tesfa International School Elementary School (Grades PK-6) Regular School Yes Elementary KG 06 2021   grade_2 1 16 1   0 0     0   0   10 8     16.0   0.0     *   2.0   18 1 16 1   0 0     0   0   10 8     16 0     2   18
1720462 MN Hennepin 27 school 2700450 4267 Charter Schools Horizon Science Academy Twin Cities Charter School 270045005159 10 Horizon Science Academy Twin Cities Elementary School (Grades PK-6) Regular School Yes Elementary KG 05 2021   grade_2 1 10 0   0 0     0   0   8 3     7.0   0.0     *   2.0   11 1 10 0   0 0     0   0   8 3     7 0     2   11
1723454 MN Nicollet 52 school 2718780 77 Independent Districts and Schools Mankato Public School District 271878004374 370 Futures Program Special Education Special Education School No Other KG 12 2021   grade_2 1 0 0   0 0     0   0   1 0     *   *     *   *   1 1 0 0   0 0     0   0   1 0                 1
1723493 MN Dakota 19 school 2732390 196 Independent Districts and Schools Rosemount-Apple Valley-Eagan 273239002517 100 Dakota Ridge School Special Education Special Education School No Other KG 12 2021   grade_2 1 1 0   0 0     0   0   2 0     *   *     *   *   2 1 1 0   0 0     0   0   2 0                 2
1723545 MN Hennepin 27 school 2711250 273 Independent Districts and Schools Edina Public School District 271125002649 515 Special Ed-Non Public Special Education Special Education School No Other KG 12 2021   grade_2 1 0 0   0 0     0   0   1 0     *   *     *   *   1 1 0 0   0 0     0   0   1 0                 1
1723581 MN Hennepin 27 school 2733780 283 Independent Districts and Schools St. Louis Park Public School District 273378000833 756 St. Louis Park Special Ed. Program Special Education Special Education School No Elementary PK 06 2021   grade_2 1 1 0   0 0     0   0   2 0     *   *     *   *   2 1 1 0   0 0     0   0   2 0                 2
1723635 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_2 1 0 0   0 0     0   0   1 0     *   *     *   *   1 1 0 0   0 0     0   0   1 0                 1
1723700 MN Ramsey 62 school 2733840 625 Independent Districts and Schools St. Paul Public School District 273384002189 430 Bridge View Special Education Special Education Special Education School No Other KG 12 2021   grade_2 1 1 0   1 2     0   2   5 2     *   *     *   *   7 1 1 0   1 2     0   2   5 2                 7
1723775 MN Scott 70 school 2733000 720 Independent Districts and Schools Shakopee Public School District 273300004646 905 Special Services Special Education Special Education School No Elementary PK 08 2021   grade_2 1 0 0   0 0     0   0   1 0     *   *     *   *   1 1 0 0   0 0     0   0   1 0                 1
1723779 MN Scott 70 school 2723430 721 Independent Districts and Schools New Prague Area Schools 272343003677 510 Central Education Campus Special Education Special Education School No Elementary 02 02 2021   grade_2 1 0 0   0 0     0   0   1 0     *   *     *   *   1 1 0 0   0 0     0   0   1 0                 1
1723870 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_2 1 2 1   0 0     0   0   4 0     *   *     *   *   4 1 2 1   0 0     0   0   4 0                 4
1723913 MN Hennepin 27 school 2700025 287 Intermediate Districts and Schools Intermediate School District 287 270002505315 302 Tier Two Special Education Special Education School No Other KG 12 2021   grade_2 1 0 1   0 0     0   1   3 0     *   *     *   *   3 1 0 1   0 0     0   1   3 0                 3
1723927 MN Hennepin 27 school 2700025 287 Intermediate Districts and Schools Intermediate School District 287 270002505316 303 Tier Three Special Education Special Education School No Other KG 12 2021   grade_2 1 3 0   0 1     0   0   5 0     *   *     *   *   5 1 3 0   0 1     0   0   5 0                 5
1724007 MN Dakota 19 school 2700026 917 Intermediate Districts and Schools Intermediate School District 917 270002602121 51 917 Intra-Dakota Educational Alt Special Education Special Education School No Other KG 12 2021   grade_2 1 0 0   0 0     0   0   1 0     *   *     *   *   1 1 0 0   0 0     0   0   1 0                 1
1724021 MN Dakota 19 school 2700026 917 Intermediate Districts and Schools Intermediate School District 917 270002602124 60 Deaf/Hard of Hearing Special Education Special Education School No Other PK 12 2021   grade_2 1 1 0   0 1     0   0   2 1     *   *     *   *   3 1 1 0   0 1     0   0   2 1                 3
1724105 MN Martin 46 school 2700046 915 Special Education Cooperatives Southern Plains Education Cooperative 270004604627 45 Southern Plains Bridges Special Education Special Education School No Other KG 12 2021   grade_2 1 0 0   0 0     0   0   1 0     *   *     *   *   1 1 0 0   0 0     0   0   1 0                 1
1724147 MN Wright 86 school 2700045 938 Special Education Cooperatives Meeker And Wright Special Education 270004504351 17 Journeys Alternative Program Special Education Special Education School No Elementary KG 08 2021   grade_2 1 0 0   0 0     0   0   1 0     *   *     *   *   1 1 0 0   0 0     0   0   1 0                 1
1724175 MN Mower 50 school 2700327 6083 Special Education Cooperatives Southern MN Education Consortium 270032704983 10 Enrich Program Special Education Special Education School No Other KG 12 2021   grade_2 1 0 0   0 0     0   0   0 1     *   *     *   *   1 1 0 0   0 0     0   0   0 1                 1
1724230 MN Freeborn 24 school 2700327 6083 Special Education Cooperatives Southern MN Education Consortium 270032705323 160 Success West Special Education Special Education School No Other KG 12 2021   grade_2 1 0 0   0 0     0   0   1 0     *   *     *   *   1 1 0 0   0 0     0   0   1 0                 1
1724302 MN Mower 50 school 2700426 6095 Special Education Cooperatives Austin Albert Lea Area Special Education Cooperative (AALASEC) 270042605016 550 Oakland Education Center Special Education Special Education School No Other KG 12 2021   grade_2 1 0 0   0 0     0   0   1 0     *   *     *   *   1 1 0 0   0 0     0   0   1 0                 1
1724330 MN Cottonwood 17 school 2700086 991 Service Cooperative (ECSU Region) Region 6 and 8-SW/WC Service Cooperative 270008604168 16 SWWC ELC - Windom Special Education Special Education School No Other KG 12 2021   grade_2 1 1 0   0 0     0   0   1 1     *   *     *   *   2 1 1 0   0 0     0   0   1 1                 2
1724365 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_2 1 0 0   0 0     0   1   2 0     *   *     *   *   2 1 0 0   0 0     0   1   2 0                 2
1724402 MN Ramsey 62 school 2700028 4005 Charter Schools Metro Deaf School 270002802341 10 Metro Deaf School Special Education Special Education School Yes Other PK 12 2021   grade_2 1 5 2   0 0     0   0   6 2     *   *     *   *   8 1 5 2   0 0     0   0   6 2                 8
1724428 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_2 1 0 0   0 0     0   0   0 1     *   *     *   *   1 1 0 0   0 0     0   0   0 1                 1
1724442 MN Chisago 13 school 2700015 6009 Education Districts St. Croix River Education District 270001505147 40 Pathway to Change Special Education Special Education School No Other KG 12 2021   grade_2 1 0 0   0 0     0   0   0 1     *   *     *   *   1 1 0 0   0 0     0   0   0 1                 1
1724452 MN Chisago 13 school 2700015 6009 Education Districts St. Croix River Education District 270001505144 50 Skillbuilding Opportunities for Academic Resiliency Special Education Special Education School No Other KG 12 2021   grade_2 1 0 0   0 0     0   0   1 0     *   *     *   *   1 1 0 0   0 0     0   0   1 0                 1
1724458 MN Pine 58 school 2700015 6009 Education Districts St. Croix River Education District 270001505145 80 Vision Special Education Special Education School No Other KG 12 2021   grade_2 1 0 0   0 0     0   0   1 0     *   *     *   *   1 1 0 0   0 0     0   0   1 0                 1
1724471 MN Olmsted 55 school 2700054 6012 Education Districts Zumbro Education District 270005402500 30 Zumbro Ed. Dist. Futures/Choice Special Education Special Education School No Other KG 12 2021   grade_2 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]);