Data source: Big Local News · About: Big Local

975 rows where grade = "grade_2", state = "MN" and year = 2020 sorted by white

View and edit SQL

year

  • 2020 · 975

grade

  • grade_2 · 975
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
1827114 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 2020   grade_2 0.0 0.0 1.0   0.0 0.0     0.0   1.0   1.0 1.0     *   *         *   2.0 0 0 1   0 0     0   1   1 1                 2
1827146 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 2020   grade_2 0.0 0.0 0.0   12.0 0.0     0.0   0.0   4.0 8.0     0.0   0.0         5.0   12.0 0 0 0   12 0     0   0   4 8     0 0     5   12
1827212 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 2020   grade_2 0.0 0.0 0.0   127.0 0.0     0.0   0.0   72.0 55.0     0.0   15.0     104.0   34.0   127.0 0 0 0   127 0     0   0   72 55     0 15   104 34   127
1827224 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 2020   grade_2 0.0 0.0 0.0   15.0 0.0     0.0   0.0   6.0 9.0     0.0   4.0     11.0   4.0   15.0 0 0 0   15 0     0   0   6 9     0 4   11 4   15
1830760 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 2020   grade_2 0.0 0.0 0.0   2.0 0.0     0.0   0.0   1.0 1.0     *   *         *   2.0 0 0 0   2 0     0   0   1 1                 2
1832850 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 2020   grade_2 0.0 3.0 7.0   22.0 0.0     0.0   2.0   17.0 17.0     0.0   3.0     30.0   7.0   34.0 0 3 7   22 0     0   2   17 17     0 3   30 7   34
1832907 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 2020   grade_2 0.0 25.0 2.0   0.0 0.0     0.0   4.0   15.0 16.0     1.0   5.0         4.0   31.0 0 25 2   0 0     0   4   15 16     1 5     4   31
1832985 MN Hennepin 27 school 2700027 4004 Charter Schools Cedar Riverside Community School 270002702340 10 Cedar Riverside Community School Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2020   grade_2 0.0 10.0 2.0   0.0 0.0     0.0   0.0   9.0 3.0     8.0   0.0         2.0   12.0 0 10 2   0 0     0   0   9 3     8 0     2   12
1833045 MN Hennepin 27 school 2700117 4017 Charter Schools Minnesota Transitions Charter School 270011703566 17 Banaadir Academy Elementary School (Grades PK-6) Regular School Yes Elementary KG 06 2020   grade_2 0.0 21.0 0.0   0.0 0.0     0.0   0.0   13.0 8.0     16.0   0.0         0.0   21.0 0 21 0   0 0     0   0   13 8     16 0     0   21
1833053 MN Hennepin 27 school 2700117 4017 Charter Schools Minnesota Transitions Charter School 270011704989 21 Banaadir South Elementary School (Grades PK-6) Regular School Yes Elementary KG 06 2020   grade_2 0.0 20.0 0.0   0.0 0.0     0.0   0.0   12.0 8.0     17.0   0.0         0.0   20.0 0 20 0   0 0     0   0   12 8     17 0     0   20
1833089 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 2020   grade_2 0.0 80.0 0.0   0.0 0.0     0.0   0.0   39.0 41.0     13.0   0.0         5.0   80.0 0 80 0   0 0     0   0   39 41     13 0     5   80
1833099 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 2020   grade_2 0.0 11.0 23.0   0.0 10.0     0.0   1.0   28.0 17.0     27.0   2.0         5.0   45.0 0 11 23   0 10     0   1   28 17     27 2     5   45
1833117 MN Hennepin 27 school 2700159 4038 Charter Schools Sojourner Truth Academy 270015902954 10 Sojourner Truth Academy Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2020   grade_2 0.0 22.0 7.0   0.0 0.0     0.0   1.0   18.0 12.0     5.0   1.0         6.0   30.0 0 22 7   0 0     0   1   18 12     5 1     6   30
1833194 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 2020   grade_2 0.0 0.0 40.0   0.0 0.0     0.0   0.0   20.0 20.0     *   0.0     35.0   5.0   40.0 0 0 40   0 0     0   0   20 20       0   35 5   40
1833201 MN Hennepin 27 school 2700184 4068 Charter Schools Excell Academy Charter 270018403137 10 Excell Academy Charter Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2020   grade_2 0.0 43.0 2.0   0.0 0.0     0.0   2.0   18.0 29.0     14.0   0.0     40.0   4.0   47.0 0 43 2   0 0     0   2   18 29     14 0   40 4   47
1833223 MN Ramsey 62 school 2700185 4073 Charter Schools Academia Cesar Chavez Charter School 270018503138 10 Academia Cesar Chavez Charter School Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2020   grade_2 0.0 1.0 50.0   0.0 0.0     0.0   1.0   24.0 28.0     40.0   1.0     42.0   8.0   52.0 0 1 50   0 0     0   1   24 28     40 1   42 8   52
1833243 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 2020   grade_2 0.0 119.0 0.0   0.0 0.0     0.0   0.0   53.0 66.0     63.0   0.0         7.0   119.0 0 119 0   0 0     0   0   53 66     63 0     7   119
1833249 MN Hennepin 27 school 2700190 4079 Charter Schools Friendship Academy of Fine Arts Charter 270019003143 10 Friendship Academy of Fine Arts Charter Elementary School (Grades PK-6) Regular School Yes Elementary KG 07 2020   grade_2 0.0 15.0 0.0   0.0 0.0     0.0   0.0   8.0 7.0     0.0   0.0     10.0   2.0   15.0 0 15 0   0 0     0   0   8 7     0 0   10 2   15
1833275 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 06 2020   grade_2 0.0 10.0 1.0   0.0 56.0     0.0   1.0   27.0 41.0     32.0   *         5.0   68.0 0 10 1   0 56     0   1   27 41     32       5   68
1833328 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 2020   grade_2 0.0 0.0 0.0   0.0 186.0     0.0   3.0   102.0 87.0     60.0   0.0     138.0   20.0   189.0 0 0 0   0 186     0   3   102 87     60 0   138 20   189
1833403 MN Olmsted 55 school 2700247 4135 Charter Schools Rochester Math And Science Academy 270024703308 10 Rochester Math And Science Academy Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2020   grade_2 0.0 40.0 0.0   0.0 0.0     0.0   0.0   21.0 19.0     18.0   0.0         6.0   40.0 0 40 0   0 0     0   0   21 19     18 0     6   40
1833485 MN Ramsey 62 school 2700263 4153 Charter Schools Dugsi Academy 270026303320 10 Dugsi Academy Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2020   grade_2 0.0 22.0 0.0   0.0 0.0     0.0   0.0   10.0 12.0     11.0   0.0         1.0   22.0 0 22 0   0 0     0   0   10 12     11 0     1   22
1833495 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 2020   grade_2 0.0 0.0 0.0   13.0 0.0     0.0   0.0   4.0 9.0     0.0   0.0     10.0   3.0   13.0 0 0 0   13 0     0   0   4 9     0 0   10 3   13
1833571 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 2020   grade_2 0.0 3.0 46.0   4.0 0.0     0.0   0.0   32.0 21.0     46.0   1.0     47.0   12.0   53.0 0 3 46   4 0     0   0   32 21     46 1   47 12   53
1833598 MN Ramsey 62 school 2700304 4181 Charter Schools Community School of Excellence 270030403728 10 Community School of Excellence Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2020   grade_2 0.0 0.0 0.0   1.0 144.0     0.0   0.0   86.0 59.0     112.0   0.0     125.0   10.0   145.0 0 0 0   1 144     0   0   86 59     112 0   125 10   145
1833667 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 2020   grade_2 0.0 58.0 0.0   0.0 0.0     0.0   0.0   31.0 27.0     0.0   5.0         8.0   58.0 0 58 0   0 0     0   0   31 27     0 5     8   58
1833673 MN Hennepin 27 school 2700309 4192 Charter Schools Best Academy 270030904261 10 Best Academy Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2020   grade_2 0.0 91.0 1.0   0.0 0.0     0.0   1.0   48.0 45.0     33.0   6.0         6.0   93.0 0 91 1   0 0     0   1   48 45     33 6     6   93
1833701 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 2020   grade_2 0.0 0.0 0.0   3.0 0.0     0.0   0.0   2.0 1.0     *   *         *   3.0 0 0 0   3 0     0   0   2 1                 3
1833722 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 2020   grade_2 0.0 37.0 0.0   0.0 0.0     0.0   0.0   26.0 11.0     29.0   0.0     24.0   0.0   37.0 0 37 0   0 0     0   0   26 11     29 0   24 0   37
1833737 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 2020   grade_2 0.0 43.0 2.0   0.0 0.0     0.0   0.0   23.0 22.0     32.0   0.0         3.0   45.0 0 43 2   0 0     0   0   23 22     32 0     3   45
1833754 MN Hennepin 27 school 2700373 4209 Charter Schools Mastery School 270037304602 10 Mastery School Elementary School (Grades PK-6) Regular School Yes Elementary KG 07 2020   grade_2 0.0 25.0 0.0   0.0 0.0     0.0   3.0   15.0 13.0     0.0   2.0         3.0   28.0 0 25 0   0 0     0   3   15 13     0 2     3   28
1833765 MN Hennepin 27 school 2700380 4213 Charter Schools Prodeo Academy 270038004642 10 Prodeo Academy Elementary School (Grades PK-6) Regular School Yes Elementary PK 06 2020   grade_2 0.0 49.0 18.0   0.0 0.0     0.0   7.0   38.0 36.0     17.0   11.0         7.0   74.0 0 49 18   0 0     0   7   38 36     17 11     7   74
1833774 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 02 2020   grade_2 0.0 7.0 3.0   0.0 26.0     0.0   1.0   22.0 15.0     28.0   0.0         2.0   37.0 0 7 3   0 26     0   1   22 15     28 0     2   37
1833819 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 05 2020   grade_2 0.0 28.0 0.0   0.0 1.0     0.0   0.0   13.0 16.0     25.0   0.0         4.0   29.0 0 28 0   0 1     0   0   13 16     25 0     4   29
1833837 MN Hennepin 27 school 2700393 4225 Charter Schools Universal Academy Charter School 270039304758 10 Universal Academy Charter School Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2020   grade_2 0.0 50.0 0.0   0.0 1.0     0.0   0.0   23.0 28.0     43.0   0.0         0.0   51.0 0 50 0   0 1     0   0   23 28     43 0     0   51
1833847 MN Hennepin 27 school 2700396 4226 Charter Schools Bdote Learning Center 270039604763 10 Bdote Learning Center Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2020   grade_2 0.0 0.0 1.0   13.0 0.0     0.0   0.0   8.0 6.0     4.0   5.0         3.0   14.0 0 0 1   13 0     0   0   8 6     4 5     3   14
1833882 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 2020   grade_2 0.0 38.0 0.0   0.0 1.0     0.0   0.0   14.0 25.0     34.0   0.0         0.0   39.0 0 38 0   0 1     0   0   14 25     34 0     0   39
1833888 MN Hennepin 27 school 2700404 4232 Charter Schools Success Academy 270040404790 10 Success Academy Elementary School (Grades PK-6) Regular School Yes Elementary KG 06 2020   grade_2 0.0 22.0 0.0   0.0 1.0     0.0   0.0   11.0 12.0     13.0   0.0     20.0   0.0   23.0 0 22 0   0 1     0   0   11 12     13 0   20 0   23
1833911 MN Ramsey 62 school 2700410 4240 Charter Schools New Century School 270041004873 10 New Century School Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2020   grade_2 0.0 39.0 0.0   0.0 0.0     0.0   0.0   19.0 20.0     *   0.0         0.0   39.0 0 39 0   0 0     0   0   19 20       0     0   39
1833966 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 2020   grade_2 0.0 28.0 0.0   0.0 0.0     0.0   0.0   12.0 16.0     *   0.0         0.0   28.0 0 28 0   0 0     0   0   12 16       0     0   28
1833974 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 2020   grade_2 0.0 3.0 0.0   0.0 0.0     0.0   1.0   2.0 2.0     *   *         *   4.0 0 3 0   0 0     0   1   2 2                 4
1833982 MN Hennepin 27 school 2700439 4261 Charter Schools SciTech Academy Charter School 270043905072 10 SciTech Academy Charter School Elementary School (Grades PK-6) Regular School Yes Elementary KG 07 2020   grade_2 0.0 32.0 0.0   0.0 0.0     0.0   0.0   14.0 18.0     *   0.0         0.0   32.0 0 32 0   0 0     0   0   14 18       0     0   32
1833991 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 2020   grade_2 0.0 25.0 0.0   0.0 0.0     0.0   0.0   12.0 13.0     18.0   0.0         0.0   25.0 0 25 0   0 0     0   0   12 13     18 0     0   25
1837089 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 2020   grade_2 0.0 1.0 0.0   0.0 0.0     0.0   0.0   1.0 0.0     *   *         *   1.0 0 1 0   0 0     0   0   1 0                 1
1837194 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 2020   grade_2 0.0 1.0 1.0   0.0 0.0     0.0   0.0   2.0 0.0     *   *         *   2.0 0 1 1   0 0     0   0   2 0                 2
1837232 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 Elementary KG 08 2020   grade_2 0.0 0.0 0.0   0.0 0.0     0.0   1.0   1.0 0.0     *   *         *   1.0 0 0 0   0 0     0   1   1 0                 1
1837297 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 02 12 2020   grade_2 0.0 0.0 1.0   0.0 0.0     0.0   0.0   1.0 0.0     *   *         *   1.0 0 0 1   0 0     0   0   1 0                 1
1837703 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 2020   grade_2 0.0 0.0 1.0   0.0 0.0     0.0   0.0   1.0 0.0     *   *         *   1.0 0 0 1   0 0     0   0   1 0                 1
1837832 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 2020   grade_2 0.0 0.0 0.0   0.0 0.0     0.0   1.0   1.0 0.0     *   *         *   1.0 0 0 0   0 0     0   1   1 0                 1
1837928 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 2020   grade_2 0.0 0.0 0.0   0.0 0.0     0.0   1.0   0.0 1.0     *   *         *   1.0 0 0 0   0 0     0   1   0 1                 1
1838051 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 2020   grade_2 0.0 0.0 0.0   0.0 0.0     0.0   1.0   1.0 0.0     *   *         *   1.0 0 0 0   0 0     0   1   1 0                 1
1838069 MN Nicollet 52 school 2700063 6027 Education Districts MN Valley Education District 270006302389 10 Minnesota Valley School Special Education Special Education School No Other KG 12 2020   grade_2 0.0 0.0 1.0   0.0 0.0     0.0   0.0   1.0 0.0     *   *         *   1.0 0 0 1   0 0     0   0   1 0                 1
1838084 MN Nicollet 52 school 2700063 6027 Education Districts MN Valley Education District 270006304710 40 ASD Program Special Education Special Education School No Other KG 12 2020   grade_2 0.0 1.0 1.0   0.0 0.0     0.0   0.0   1.0 1.0     *   *         *   2.0 0 1 1   0 0     0   0   1 1                 2
1838124 MN Sibley 72 school 2791353 6049 Education Districts River Bend Education District 279135305199 65 Connect and Soar Program Special Education Special Education School No Elementary KG 05 2020   grade_2 0.0 0.0 1.0   0.0 0.0     0.0   0.0   0.0 1.0     *   *         *   1.0 0 0 1   0 0     0   0   0 1                 1
1838177 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 2020   grade_2 0.0 0.0 0.0   1.0 0.0     0.0   0.0   1.0 0.0     *   *         *   1.0 0 0 0   1 0     0   0   1 0                 1
1838231 MN Saint Louis 69 school 2711040 709 Independent Districts and Schools Duluth Public School District 271104001600 630 Superior Academy Hospital/Medical/Partial Hospitalization Program Alternative School No Other 02 12 2020   grade_2 0.0 0.0 0.0   0.0 0.0     0.0   1.0   0.0 1.0     *   *         *   1.0 0 0 0   0 0     0   1   0 1                 1
1838256 MN Hennepin 27 school 2700025 287 Intermediate Districts and Schools Intermediate School District 287 270002504537 530 PraIrie Care Brooklyn Park Day Program Hospital/Medical/Partial Hospitalization Program Alternative School No Other KG 12 2020   grade_2 0.0 0.0 0.0   0.0 0.0     0.0   1.0   0.0 1.0     *   *         *   1.0 0 0 0   0 0     0   1   0 1                 1
1838807 MN Crow Wing 18 school 2706090 181 Independent Districts and Schools Brainerd Public School District 270609000468 17 Lincoln Education Center Miscellaneous Program (assignment is now limited) Alternative School No Other 02 12 2020   grade_2 0.0 0.0 0.0   1.0 0.0     0.0   0.0   1.0 0.0     *   *         *   1.0 0 0 0   1 0     0   0   1 0                 1
1838841 MN Blue Earth 7 school 2718780 77 Independent Districts and Schools Mankato Public School District 271878005116 375 Prairie Care Mankato Educational Oversight to Public Care and Treatment Day Program Alternative School No Other 02 12 2020   grade_2 0.0 1.0 0.0   0.0 0.0     0.0   0.0   0.0 1.0     *   *         *   1.0 0 1 0   0 0     0   0   0 1                 1
1839143 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124002860 315 Ronald McDonald House Private Alternative Program Alternative School No Other KG 12 2020   grade_2 0.0 0.0 1.0   0.0 0.0     0.0   0.0   1.0 0.0     *   *         *   1.0 0 0 1   0 0     0   0   1 0                 1
1839245 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 2020   grade_2 0.0 0.0 0.0   3.0 0.0     0.0   0.0   1.0 2.0     *   *         *   3.0 0 0 0   3 0     0   0   1 2                 3
1828673 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 2020   grade_2 1.0 21.0 5.0   0.0 5.0     0.0   3.0   19.0 16.0     8.0   6.0     29.0   6.0   35.0 1 21 5   0 5     0   3   19 16     8 6   29 6   35
1828725 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 2020   grade_2 1.0 36.0 9.0   0.0 11.0     0.0   2.0   32.0 27.0     20.0   5.0     47.0   10.0   59.0 1 36 9   0 11     0   2   32 27     20 5   47 10   59
1830289 MN Ramsey 62 school 2733840 625 Independent Districts and Schools St. Paul Public School District 273384001575 449 Bruce F Vento Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2020   grade_2 1.0 22.0 3.0   0.0 38.0     0.0   3.0   40.0 27.0     42.0   2.0         11.0   67.0 1 22 3   0 38     0   3   40 27     42 2     11   67
1830428 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 2020   grade_2 1.0 24.0 0.0   0.0 10.0     0.0   1.0   14.0 22.0     26.0   0.0         2.0   36.0 1 24 0   0 10     0   1   14 22     26 0     2   36
1830458 MN Ramsey 62 school 2733840 625 Independent Districts and Schools St. Paul Public School District 273384001609 524 Maxfield Elementary School Elementary School (Grades PK-6) Regular School No Elementary PK 05 2020   grade_2 1.0 24.0 5.0   0.0 2.0     0.0   3.0   23.0 12.0     5.0   0.0         5.0   35.0 1 24 5   0 2     0   3   23 12     5 0     5   35
1830544 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 2020   grade_2 1.0 30.0 5.0   0.0 3.0     0.0   8.0   28.0 19.0     5.0   4.0     40.0   11.0   47.0 1 30 5   0 3     0   8   28 19     5 4   40 11   47
1830726 MN Saint Louis 69 school 2713980 701 Independent Districts and Schools Hibbing Public School District 271398001529 310 Lincoln Elementary Elementary School (Grades PK-6) Regular School No Elementary 02 06 2020   grade_2 1.0 0.0 0.0   1.0 0.0     0.0   1.0   1.0 2.0     *   *         *   3.0 1 0 0   1 0     0   1   1 2                 3
1832800 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 2020   grade_2 1.0 17.0 20.0   0.0 2.0     0.0   3.0   25.0 18.0     26.0   2.0         8.0   43.0 1 17 20   0 2     0   3   25 18     26 2     8   43
1832831 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 2020   grade_2 1.0 36.0 1.0   3.0 0.0     0.0   4.0   25.0 20.0     18.0   6.0     40.0   7.0   45.0 1 36 1   3 0     0   4   25 20     18 6   40 7   45
1832898 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124002476 282 Lucy Laney @ Cleveland Park Elem Elementary School (Grades PK-6) Regular School No Elementary PK 05 2020   grade_2 1.0 59.0 6.0   2.0 0.0     0.0   3.0   35.0 36.0     4.0   *     62.0   12.0   71.0 1 59 6   2 0     0   3   35 36     4     62 12   71
1832967 MN Wright 86 school 2700413 6090 Special Education Cooperatives Sherburne and Northern Wright Special Education Cooperative 270041305084 50 Little Mountain Elementary - SNW Elementary School (Grades PK-6) Regular School No Elementary 02 06 2020   grade_2 1.0 0.0 1.0   0.0 0.0     0.0   0.0   2.0 0.0     *   *         *   2.0 1 0 1   0 0     0   0   2 0                 2
1833211 MN Ramsey 62 school 2700230 4070 Charter Schools HOPE Community Academy 270023003482 10 HOPE Community Academy Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2020   grade_2 1.0 3.0 0.0   0.0 63.0     0.0   0.0   26.0 41.0     48.0   1.0     54.0   5.0   67.0 1 3 0   0 63     0   0   26 41     48 1   54 5   67
1833300 MN Hennepin 27 school 2700237 4097 Charter Schools Partnership Academy, Inc. 270023703278 10 Partnership Academy, Inc. Elementary School (Grades PK-6) Regular School Yes Elementary KG 07 2020   grade_2 1.0 1.0 48.0   0.0 0.0     0.0   3.0   27.0 26.0     41.0   1.0     45.0   9.0   53.0 1 1 48   0 0     0   3   27 26     41 1   45 9   53
1833421 MN Hennepin 27 school 2700273 4139 Charter Schools LoveWorks Academy For Arts 270027303575 10 LoveWorks Academy For Arts Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2020   grade_2 1.0 18.0 0.0   0.0 1.0     0.0   2.0   11.0 11.0     0.0   2.0         1.0   22.0 1 18 0   0 1     0   2   11 11     0 2     1   22
1833450 MN Hennepin 27 school 2700253 4143 Charter Schools New Millennium Academy Charter Sch 270025303311 10 New Millenium Academy Charter School Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2020   grade_2 1.0 4.0 1.0   0.0 92.0     0.0   1.0   56.0 43.0     68.0   3.0     73.0   2.0   99.0 1 4 1   0 92     0   1   56 43     68 3   73 2   99
1833555 MN Hennepin 27 school 2700289 4169 Charter Schools Stonebridge World School 270028903731 10 Stonebridge World School Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2020   grade_2 1.0 21.0 8.0   0.0 2.0     0.0   1.0   16.0 17.0     7.0   3.0     29.0   5.0   33.0 1 21 8   0 2     0   1   16 17     7 3   29 5   33
1833565 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 2020   grade_2 1.0 6.0 39.0   1.0 0.0     0.0   0.0   22.0 25.0     35.0   0.0     39.0   11.0   47.0 1 6 39   1 0     0   0   22 25     35 0   39 11   47
1833584 MN Hennepin 27 school 2700295 4171 Charter Schools Noble Academy 270029505126 20 Nompeng Academy Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2020   grade_2 1.0 16.0 1.0   0.0 96.0     0.0   1.0   63.0 52.0     73.0   0.0     98.0   7.0   115.0 1 16 1   0 96     0   1   63 52     73 0   98 7   115
1833683 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 2020   grade_2 1.0 4.0 1.0   0.0 42.0     0.0   1.0   25.0 24.0     39.0   1.0     42.0   5.0   49.0 1 4 1   0 42     0   1   25 24     39 1   42 5   49
1833779 MN Ramsey 62 school 2700386 4215 Charter Schools Sejong Academy of Minnesota 270038604695 10 Sejong Academy of Minnesota Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2020   grade_2 1.0 1.0 0.0   0.0 20.0     0.0   1.0   14.0 9.0     18.0   0.0         0.0   23.0 1 1 0   0 20     0   1   14 9     18 0     0   23
1836972 MN Blue Earth 7 school 2718780 77 Independent Districts and Schools Mankato Public School District 271878004374 370 Futures Program Special Education Special Education School No Other KG 12 2020   grade_2 1.0 0.0 0.0   0.0 0.0     0.0   0.0   1.0 0.0     *   *         *   1.0 1 0 0   0 0     0   0   1 0                 1
1837168 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 2020   grade_2 1.0 0.0 0.0   0.0 0.0     0.0   0.0   1.0 0.0     *   *         *   1.0 1 0 0   0 0     0   0   1 0                 1
1837289 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 2020   grade_2 1.0 0.0 0.0   0.0 0.0     0.0   0.0   1.0 0.0     *   *         *   1.0 1 0 0   0 0     0   0   1 0                 1
1837448 MN Hennepin 27 school 2700025 287 Intermediate Districts and Schools Intermediate School District 287 270002503226 465 Sun Special Education Special Education School No Other KG 12 2020   grade_2 1.0 1.0 0.0   0.0 1.0     0.0   0.0   3.0 0.0     *   *         *   3.0 1 1 0   0 1     0   0   3 0                 3
1837625 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 2020   grade_2 1.0 0.0 0.0   0.0 0.0     0.0   0.0   0.0 1.0     *   *         *   1.0 1 0 0   0 0     0   0   0 1                 1
1837679 MN Otter Tail 56 school 2700043 935 Special Education Cooperatives Fergus Falls Area Sp. Ed. Coop. 270004304289 13 Fergus Falls EC/Elementary Sp Ed Special Education Special Education School No Elementary PK 04 2020   grade_2 1.0 0.0 1.0   0.0 0.0     0.0   0.0   2.0 0.0     *   *         *   2.0 1 0 1   0 0     0   0   2 0                 2
1837688 MN Wright 86 school 2700045 938 Special Education Cooperatives Meeker And Wright Special Education 270004504402 10 Trek Program Special Education Special Education School No Other KG 12 2020   grade_2 1.0 0.0 0.0   0.0 0.0     0.0   0.0   1.0 0.0     *   *         *   1.0 1 0 0   0 0     0   0   1 0                 1
1837744 MN Mower 50 school 2700327 6083 Special Education Cooperatives Southern MN Education Consortium 270032705061 30 Flight Program Special Education Special Education School No Elementary KG 06 2020   grade_2 1.0 0.0 0.0   0.0 0.0     0.0   0.0   1.0 0.0     *   *         *   1.0 1 0 0   0 0     0   0   1 0                 1
1837880 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 02 12 2020   grade_2 1.0 0.0 1.0   0.0 0.0     0.0   0.0   1.0 1.0     *   *         *   2.0 1 0 1   0 0     0   0   1 1                 2
1837893 MN Lyon 42 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 2020   grade_2 1.0 0.0 1.0   0.0 0.0     0.0   0.0   2.0 0.0     *   *         *   2.0 1 0 1   0 0     0   0   2 0                 2
1837904 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 2020   grade_2 1.0 0.0 0.0   0.0 0.0     0.0   0.0   1.0 0.0     *   *         *   1.0 1 0 0   0 0     0   0   1 0                 1
1837939 MN Chippewa 12 school 2700086 991 Service Cooperative (ECSU Region) Region 6 and 8-SW/WC Service Cooperative 270008605170 61 SWWC ELC - Montevideo Special Education Special Education School No Other PK 12 2020   grade_2 1.0 0.0 0.0   0.0 0.0     0.0   0.0   1.0 0.0     *   *         *   1.0 1 0 0   0 0     0   0   1 0                 1
1837951 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 2020   grade_2 1.0 3.0 1.0   0.0 2.0     0.0   0.0   4.0 3.0     *   *         *   7.0 1 3 1   0 2     0   0   4 3                 7
1838010 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 2020   grade_2 1.0 0.0 0.0   0.0 0.0     0.0   0.0   1.0 0.0     *   *         *   1.0 1 0 0   0 0     0   0   1 0                 1
1838022 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 2020   grade_2 1.0 0.0 0.0   0.0 0.0     0.0   0.0   1.0 0.0     *   *         *   1.0 1 0 0   0 0     0   0   1 0                 1
1838060 MN Stearns 73 school 2791455 6026 Education Districts West Central Education District 279145503591 24 Beacon Program W Central Ed. Dist. Special Education Special Education School No Other KG 12 2020   grade_2 1.0 0.0 0.0   0.0 0.0     0.0   0.0   1.0 0.0     *   *         *   1.0 1 0 0   0 0     0   0   1 0                 1
1838110 MN Brown 8 school 2791353 6049 Education Districts River Bend Education District 279135305074 50 R.I.S.E. Program Special Education Special Education School No Other KG 12 2020   grade_2 1.0 0.0 0.0   0.0 0.0     0.0   0.0   1.0 0.0     *   *         *   1.0 1 0 0   0 0     0   0   1 0                 1
1838135 MN Goodhue 25 school 2791443 6051 Education Districts Goodhue County Education District 279144302399 10 Reach Programs Special Education Special Education School No Other PK 12 2020   grade_2 1.0 0.0 0.0   0.0 0.0     0.0   0.0   1.0 0.0     *   *         *   1.0 1 0 0   0 0     0   0   1 0                 1
1838169 MN Morrison 49 school 2700073 6979 Education Districts Mid State Education District 270007303304 10 SUN Program Special Education Special Education School No Other PK 12 2020   grade_2 1.0 0.0 0.0   0.0 0.0     0.0   0.0   1.0 0.0     *   *         *   1.0 1 0 0   0 0     0   0   1 0                 1

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