Data source: Big Local News · About: Big Local

954 rows where grade = "grade_5", state = "MN" and year = 2021 sorted by white

View and edit SQL

year

  • 2021 · 954

grade

  • grade_5 · 954
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
1713581 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_5 0 0 0   9 0     0   0   4 5     *   *     *   *   9 0 0 0   9 0     0   0   4 5                 9
1713648 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_5 0 0 0   117 0     0   1   55 63     0.0   29.0     *   27.0   118 0 0 0   117 0     0   1   55 63     0 29     27   118
1713658 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_5 0 0 0   15 0     0   0   10 5     0.0   8.0     *   5.0   15 0 0 0   15 0     0   0   10 5     0 8     5   15
1715134 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_5 0 22 4   0 2     0   0   16 12     8.0   3.0     20.0   4.0   28 0 22 4   0 2     0   0   16 12     8 3   20 4   28
1715186 MN Hennepin 27 school 2725200 279 Independent Districts and Schools Osseo Public School District 272520001224 681 Zanewood Community School, Science, Technology, Engineering, Arts and Math Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   grade_5 0 17 3   0 6     0   2   13 15     6.0   3.0     18.0   5.0   28 0 17 3   0 6     0   2   13 15     6 3   18 5   28
1716888 MN Ramsey 62 school 2733840 625 Independent Districts and Schools St. Paul Public School District 273384001601 500 Jackson Preparatory Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   grade_5 0 8 1   1 23     0   2   18 17     *   0.0     *   6.0   35 0 8 1   1 23     0   2   18 17       0     6   35
1717198 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_5 0 0 0   2 0     0   0   2 0     *   *     *   *   2 0 0 0   2 0     0   0   2 0                 2
1719109 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124000943 107 Bethune Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   grade_5 0 33 0   1 1     0   3   26 12     3.0   2.0     33.0   13.0   38 0 33 0   1 1     0   3   26 12     3 2   33 13   38
1719261 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_5 0 13 16   0 0     0   1   17 13     15.0   0.0     *   8.0   30 0 13 16   0 0     0   1   17 13     15 0     8   30
1719312 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_5 0 0 3   29 0     0   3   10 25     0.0   3.0     *   12.0   35 0 0 3   29 0     0   3   10 25     0 3     12   35
1719395 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_5 0 23 3   1 15     0   0   18 24     21.0   1.0     36.0   10.0   42 0 23 3   1 15     0   0   18 24     21 1   36 10   42
1719443 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_5 0 8 1   0 0     0   0   3 6     *   *     *   *   9 0 8 1   0 0     0   0   3 6                 9
1719496 MN Hennepin 27 school 2700117 4017 Charter Schools Minnesota Transitions Charter School 270011702607 10 Minnesota Transitions Charter Elementary Elementary School (Grades PK-6) Regular School Yes Elementary KG 06 2021   grade_5 0 6 2   1 0     0   3   11 1     1.0   2.0     *   4.0   12 0 6 2   1 0     0   3   11 1     1 2     4   12
1719499 MN Hennepin 27 school 2700117 4017 Charter Schools Minnesota Transitions Charter School 270011703566 17 Banaadir Academy Elementary School (Grades PK-6) Regular School Yes Middle 05 06 2021   grade_5 0 36 0   0 0     0   0   18 18     25.0   0.0     *   2.0   36 0 36 0   0 0     0   0   18 18     25 0     2   36
1719542 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_5 0 78 0   0 0     0   0   37 41     24.0   0.0     *   2.0   78 0 78 0   0 0     0   0   37 41     24 0     2   78
1719552 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_5 0 9 27   0 8     0   0   29 15     *   0.0     *   7.0   44 0 9 27   0 8     0   0   29 15       0     7   44
1719649 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_5 0 43 3   0 0     0   1   20 27     8.0   1.0     41.0   5.0   47 0 43 3   0 0     0   1   20 27     8 1   41 5   47
1719659 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_5 0 2 0   0 50     0   0   25 27     28.0   1.0     43.0   3.0   52 0 2 0   0 50     0   0   25 27     28 1   43 3   52
1719671 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_5 0 0 70   0 0     0   1   31 40     46.0   4.0     18.0   8.0   71 0 0 70   0 0     0   1   31 40     46 4   18 8   71
1719723 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_5 0 6 0   0 26     0   0   17 15     22.0   0.0     *   3.0   32 0 6 0   0 26     0   0   17 15     22 0     3   32
1719751 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_5 0 2 49   0 0     0   1   27 25     27.0   0.0     42.0   10.0   52 0 2 49   0 0     0   1   27 25     27 0   42 10   52
1719778 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_5 0 0 4   0 177     0   4   94 91     64.0   0.0     138.0   27.0   185 0 0 4   0 177     0   4   94 91     64 0   138 27   185
1719838 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_5 0 6 3   0 55     0   1   32 33     35.0   1.0     50.0   8.0   65 0 6 3   0 55     0   1   32 33     35 1   50 8   65
1719853 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_5 0 54 0   0 0     0   0   31 23     19.0   0.0     *   6.0   54 0 54 0   0 0     0   0   31 23     19 0     6   54
1719871 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_5 0 17 0   0 0     0   0   6 11     0.0   0.0     *   3.0   17 0 17 0   0 0     0   0   6 11     0 0     3   17
1719936 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_5 0 38 0   0 0     0   0   17 21     *   0.0     *   3.0   38 0 38 0   0 0     0   0   17 21       0     3   38
1719946 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_5 0 0 0   19 0     0   0   7 12     0.0   0.0     15.0   3.0   19 0 0 0   19 0     0   0   7 12     0 0   15 3   19
1720026 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_5 0 9 2   0 100     0   0   60 51     47.0   0.0     79.0   8.0   111 0 9 2   0 100     0   0   60 51     47 0   79 8   111
1720050 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_5 0 0 0   0 151     0   0   79 72     61.0   0.0     125.0   10.0   151 0 0 0   0 151     0   0   79 72     61 0   125 10   151
1720104 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_5 0 26 5   0 0     0   0   17 14     *   *     *   *   31 0 26 5   0 0     0   0   17 14                 31
1720123 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_5 0 69 0   0 0     0   1   40 30     22.0   3.0     *   14.0   70 0 69 0   0 0     0   1   40 30     22 3     14   70
1720151 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_5 0 0 0   3 0     0   0   0 3     *   *     *   *   3 0 0 0   3 0     0   0   0 3                 3
1720173 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_5 0 50 0   0 0     0   0   24 26     28.0   0.0     27.0   1.0   50 0 50 0   0 0     0   0   24 26     28 0   27 1   50
1720188 MN Hennepin 27 school 2700335 4205 Charter Schools Hennepin Elementary School 270033504554 10 Hennepin Elementary School Elementary School (Grades PK-6) Regular School Yes Elementary KG 05 2021   grade_5 0 34 5   0 0     0   0   18 21     24.0   0.0     *   5.0   39 0 34 5   0 0     0   0   18 21     24 0     5   39
1720205 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_5 0 19 0   0 0     0   0   8 11     0.0   0.0     17.0   3.0   19 0 19 0   0 0     0   0   8 11     0 0   17 3   19
1720269 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_5 0 30 0   0 0     0   1   16 15     17.0   0.0     26.0   3.0   31 0 30 0   0 0     0   1   16 15     17 0   26 3   31
1720288 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_5 0 40 0   0 1     0   1   19 23     29.0   0.0     31.0   2.0   42 0 40 0   0 1     0   1   19 23     29 0   31 2   42
1720298 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_5 0 0 0   8 0     0   0   3 5     *   *     *   *   8 0 0 0   8 0     0   0   3 5                 8
1720340 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_5 0 13 0   0 0     0   0   6 7     11.0   0.0     *   0.0   13 0 13 0   0 0     0   0   6 7     11 0     0   13
1720365 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_5 0 34 0   0 0     0   0   17 17     27.0   0.0     *   *   34 0 34 0   0 0     0   0   17 17     27 0         34
1720420 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_5 0 28 0   0 0     0   0   12 16     23.0   0.0     *   3.0   28 0 28 0   0 0     0   0   12 16     23 0     3   28
1720436 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_5 0 26 0   0 0     0   0   13 13     23.0   0.0     23.0   2.0   26 0 26 0   0 0     0   0   13 13     23 0   23 2   26
1720443 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_5 0 27 0   0 0     0   0   17 10     12.0   0.0     *   1.0   27 0 27 0   0 0     0   0   17 10     12 0     1   27
1720465 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_5 0 9 1   0 0     0   0   7 3     6.0   0.0     *   0.0   10 0 9 1   0 0     0   0   7 3     6 0     0   10
1720478 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_5 0 6 0   0 0     0   0   1 5     *   *     *   *   6 0 6 0   0 0     0   0   1 5                 6
1720516 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_5 0 4 0   0 0     0   0   2 2     *   *     *   *   4 0 4 0   0 0     0   0   2 2                 4
1720524 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_5 0 1 0   0 0     0   0   0 1     *   *     *   *   1 0 1 0   0 0     0   0   0 1                 1
1721546 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_5 0 0 48   0 0     0   0   20 28     32.0   0.0     39.0   7.0   48 0 0 48   0 0     0   0   20 28     32 0   39 7   48
1721555 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_5 0 125 0   0 0     0   0   63 62     49.0   0.0     *   7.0   125 0 125 0   0 0     0   0   63 62     49 0     7   125
1721585 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_5 0 10 0   0 0     0   0   6 4     *   0.0     *   1.0   10 0 10 0   0 0     0   0   6 4       0     1   10
1721604 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_5 0 4 52   0 0     0   2   33 25     29.0   2.0     43.0   13.0   58 0 4 52   0 0     0   2   33 25     29 2   43 13   58
1721609 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_5 0 8 69   0 1     0   3   45 36     47.0   0.0     72.0   18.0   81 0 8 69   0 1     0   3   45 36     47 0   72 18   81
1721613 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_5 0 54 2   0 0     0   0   28 28     *   *     *   *   56 0 54 2   0 0     0   0   28 28                 56
1721631 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_5 0 48 13   0 0     0   7   33 35     5.0   7.0     57.0   10.0   68 0 48 13   0 0     0   7   33 35     5 7   57 10   68
1721640 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_5 0 40 0   2 0     0   3   18 27     22.0   0.0     *   2.0   45 0 40 0   2 0     0   3   18 27     22 0     2   45
1721659 MN Hennepin 27 school 2700444 4263 Charter Schools Progeny Academy Charter School 270044405133 10 Progeny Academy Charter School Middle School (Grades 5-8) Regular School Yes Middle 04 08 2021   grade_5 0 2 0   0 0     0   0   2 0     *   *     *   *   2 0 2 0   0 0     0   0   2 0                 2
1723678 MN Ramsey 62 school 2723850 622 Independent Districts and Schools North St. Paul-Maplewood Oakdale Public School District 272385003374 41 Harmony Learning Center Special Education Special Education School No Other KG 12 2021   grade_5 0 2 0   0 0     0   0   2 0     *   *     *   *   2 0 2 0   0 0     0   0   2 0                 2
1723715 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_5 0 8 0   0 0     0   2   8 2     0.0   2.0     7.0   *   10 0 8 0   0 0     0   2   8 2     0 2   7     10
1723930 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_5 0 3 0   0 1     0   0   3 1     *   *     *   *   4 0 3 0   0 1     0   0   3 1                 4
1724024 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_5 0 0 2   0 0     0   0   2 0     *   *     *   *   2 0 0 2   0 0     0   0   2 0                 2
1724276 MN Wright 86 school 2700413 6090 Special Education Cooperatives Sherburne and Northern Wright Special Education Cooperative 270041305087 81 Intensive DCD - SNW Special Education Special Education School No Other 04 12 2021   grade_5 0 1 0   0 0     0   0   0 1     *   *     *   *   1 0 1 0   0 0     0   0   0 1                 1
1724615 MN Morrison 49 school 2700073 6979 Education Districts Mid State Education District 270007303604 30 WIN-Elementary School Special Education Special Education School No Elementary KG 05 2021   grade_5 0 0 0   1 0     0   1   2 0     *   *     *   *   2 0 0 0   1 0     0   1   2 0                 2
1724698 MN Hennepin 27 school 2700025 287 Intermediate Districts and Schools Intermediate School District 287 270002504467 532 Prairie Care Edina - PHP Hospital/Medical/Partial Hospitalization Program Alternative School No Other KG 12 2021   grade_5 0 0 0   0 1     0   1   2 0     *   *     *   *   2 0 0 0   0 1     0   1   2 0                 2
1725015 MN Kandiyohi 34 school 2742720 347 Independent Districts and Schools Willmar Public School District 274272004674 941 Lake Park School Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No Other 04 12 2021   grade_5 0 0 1   0 0     0   0   1 0     *   *     *   *   1 0 0 1   0 0     0   0   1 0                 1
1725558 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_5 0 0 0   4 0     0   0   2 2     *   *     *   *   4 0 0 0   4 0     0   0   2 2                 4
1714146 MN Crow Wing 18 school 2706090 181 Independent Districts and Schools Brainerd Public School District 270609000259 12 Riverside Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   grade_5 1 0 0   0 0     0   0   0 1     *   *     *   *   1 1 0 0   0 0     0   0   0 1                 1
1715150 MN Hennepin 27 school 2725200 279 Independent Districts and Schools Osseo Public School District 272520001212 674 Fair Oaks Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   grade_5 1 9 8   0 5     0   4   18 9     *   0.0     18.0   5.0   27 1 9 8   0 5     0   4   18 9       0   18 5   27
1716691 MN Ramsey 62 school 2733840 625 Independent Districts and Schools St. Paul Public School District 273384001952 424 Benjamin E Mays Magnet Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   grade_5 1 40 4   1 5     0   4   26 29     8.0   3.0     47.0   9.0   55 1 40 4   1 5     0   4   26 29     8 3   47 9   55
1716843 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_5 1 17 8   0 13     1   1   18 23     *   1.0     *   *   41 1 17 8   0 13     1   1   18 23       1         41
1716880 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_5 1 10 7   0 11     0   1   18 12     17.0   0.0     *   4.0   30 1 10 7   0 11     0   1   18 12     17 0     4   30
1716948 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_5 1 6 7   0 80     0   3   48 49     *   1.0     81.0   8.0   97 1 6 7   0 80     0   3   48 49       1   81 8   97
1716996 MN Ramsey 62 school 2733840 625 Independent Districts and Schools St. Paul Public School District 273384001634 578 Obama Service Learning Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2021   grade_5 1 34 2   0 2     0   6   22 23     1.0   3.0     35.0   11.0   45 1 34 2   0 2     0   6   22 23     1 3   35 11   45
1718748 MN Pipestone 59 school 2700108 2689 Independent Districts and Schools Pipestone Area School District 270010803015 6 Heartland Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 08 2021   grade_5 1 0 0   0 0     0   0   1 0     *   *     *   *   1 1 0 0   0 0     0   0   1 0                 1
1719343 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124001879 256 Green Central Park Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   grade_5 1 14 29   2 0     0   1   23 24     22.0   0.0     *   5.0   47 1 14 29   2 0     0   1   23 24     22 0     5   47
1719378 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124002699 288 Nellie Stone Johnson Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   grade_5 1 32 18   1 1     0   1   30 24     *   2.0     *   15.0   54 1 32 18   1 1     0   1   30 24       2     15   54
1719569 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_5 1 24 5   0 0     0   0   17 13     4.0   4.0     *   7.0   30 1 24 5   0 0     0   0   17 13     4 4     7   30
1719697 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_5 1 17 0   0 0     0   1   9 10     0.0   0.0     16.0   2.0   19 1 17 0   0 0     0   1   9 10     0 0   16 2   19
1719901 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_5 1 3 5   0 74     0   1   38 46     41.0   3.0     60.0   9.0   84 1 3 5   0 74     0   1   38 46     41 3   60 9   84
1720040 MN Yellow Medicine 87 school 2700290 4172 Charter Schools Clarkfield Charter School 270029003726 10 Clarkfield Charter School Elementary School (Grades PK-6) Regular School Yes Elementary KG 06 2021   grade_5 1 0 0   0 0     0   0   1 0     *   *     *   *   1 1 0 0   0 0     0   0   1 0                 1
1720229 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_5 1 0 0   0 22     0   2   14 11     15.0   0.0     22.0   3.0   25 1 0 0   0 22     0   2   14 11     15 0   22 3   25
1720326 MN Hennepin 27 school 2700406 4230 Charter Schools Minnesota Excellence in Learning Academy 270040604843 10 Minnesota Excellence in Learning Academy Elementary School (Grades PK-6) Regular School Yes Elementary PK 06 2021   grade_5 1 13 6   0 0     0   2   7 15     0.0   2.0     19.0   3.0   22 1 13 6   0 0     0   2   7 15     0 2   19 3   22
1720428 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_5 1 3 3   1 0     0   3   3 8     0.0   0.0     *   0.0   11 1 3 3   1 0     0   3   3 8     0 0     0   11
1721533 MN Ramsey 62 school 2700115 4015 Charter Schools Community of Peace Academy 270011505136 12 Community of Peace Academy Middle School Middle School (Grades 5-8) Regular School Yes Middle 05 08 2021   grade_5 1 7 17   0 30     1   4   31 29     16.0   0.0     38.0   9.0   60 1 7 17   0 30     1   4   31 29     16 0   38 9   60
1723559 MN Hennepin 27 school 2725080 278 Independent Districts and Schools Orono Public School District 272508002277 663 Orono Discovery Center Special Education Special Education School No Middle 05 05 2021   grade_5 1 0 0   0 0     0   0   0 1     *   *     *   *   1 1 0 0   0 0     0   0   0 1                 1
1723595 MN Itasca 31 school 2710140 317 Independent Districts and Schools Deer River Public School District 271014004672 6 Deer River Schools SPED Special Education Special Education School No Elementary KG 05 2021   grade_5 1 0 0   1 0     0   0   2 0     *   *     *   *   2 1 0 0   1 0     0   0   2 0                 2
1723776 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_5 1 0 0   0 0     0   0   1 0     *   *     *   *   1 1 0 0   0 0     0   0   1 0                 1
1723873 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_5 1 11 0   0 0     0   2   14 0     1.0   0.0     11.0   *   14 1 11 0   0 0     0   2   14 0     1 0   11     14
1723886 MN Rice 66 school 2700129 160 State Operated Schools (which include MN Academy Deaf & Blind, School for the Arts) Minnesota State Academies 270012903056 1 MN Academy For The Blind Special Education Special Education School No Other PK 12 2021   grade_5 1 0 0   0 0     0   0   0 1     *   *     *   *   1 1 0 0   0 0     0   0   0 1                 1
1723955 MN Waseca 81 school 2700420 288 Intermediate Districts and Schools Southwest Metro Intermediate 288 270042005278 829 SW Metro Waseca Special Education Special Education School No Other KG 12 2021   grade_5 1 0 0   0 0     0   0   1 0     *   *     *   *   1 1 0 0   0 0     0   0   1 0                 1
1724059 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_5 1 0 0   0 0     0   0   1 0     *   *     *   *   1 1 0 0   0 0     0   0   1 0                 1
1724129 MN Otter Tail 56 school 2700043 935 Special Education Cooperatives Fergus Falls Area Special Education Cooperative 270004304316 14 Fergus Falls Elementary Sp Ed 5-8 Special Education Special Education School No Middle 05 08 2021   grade_5 1 0 0   0 0     0   0   1 0     *   *     *   *   1 1 0 0   0 0     0   0   1 0                 1
1724152 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_5 1 0 0   0 0     0   0   1 0     *   *     *   *   1 1 0 0   0 0     0   0   1 0                 1
1724178 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_5 1 0 1   0 0     0   0   1 1     *   *     *   *   2 1 0 1   0 0     0   0   1 1                 2
1724286 MN Rice 66 school 2700424 6094 Special Education Cooperatives Cannon Valley Special Education Cooperative 270042404938 10 Alexander Learning Academy Special Education Special Education School No Other KG 12 2021   grade_5 1 0 1   0 0     0   0   2 0     *   *     *   *   2 1 0 1   0 0     0   0   2 0                 2
1724303 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_5 1 0 2   0 0     0   0   3 0     *   *     *   *   3 1 0 2   0 0     0   0   3 0                 3
1724356 MN Meeker 47 school 2700086 991 Service Cooperative (ECSU Region) Region 6 and 8-SW/WC Service Cooperative 270008604215 27 SWWC ELC - Cosmos Special Education Special Education School No Other KG 12 2021   grade_5 1 0 0   0 0     0   0   1 0     *   *     *   *   1 1 0 0   0 0     0   0   1 0                 1
1724367 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_5 1 1 0   0 0     0   0   2 0     *   *     *   *   2 1 1 0   0 0     0   0   2 0                 2
1724444 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_5 1 0 0   0 0     0   0   0 1     *   *     *   *   1 1 0 0   0 0     0   0   0 1                 1
1724494 MN Wabasha 79 school 2700055 6013 Education Districts Hiawatha Valley Ed. District 270005504535 31 Sail Program Special Education Special Education School No Other PK 12 2021   grade_5 1 0 0   0 0     0   0   1 0     *   *     *   *   1 1 0 0   0 0     0   0   1 0                 1
1724504 MN Houston 28 school 2700055 6013 Education Districts Hiawatha Valley Ed. District 270005504960 33 HVED Spectrum Program Special Education Special Education School No Other PK 12 2021   grade_5 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]);