Data source: Big Local News · About: Big Local

13,914 rows where state = "MN" and year = 2021 sorted by white

View and edit SQL

year

  • 2021 · 13,814
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
1716942 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   early_childhood_special_ed 0 0 0   0 4     0   2   3 3     *   *     *   *   6 0 0 0   0 4     0   2   3 3                 6
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
1716965 MN Ramsey 62 school 2733840 625 Independent Districts and Schools St. Paul Public School District 273384002454 552 Paul & Sheila Wellstone Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2021   early_childhood_special_ed 0 0 2   0 0     0   1   3 0     *   *     *   *   3 0 0 2   0 0     0   1   3 0                 3
1716989 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   early_childhood_special_ed 0 1 0   0 0     0   0   0 1     *   *     *   *   1 0 1 0   0 0     0   0   0 1                 1
1717192 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   early_childhood_special_ed 0 0 0   1 0     0   0   1 0     *   *     *   *   1 0 0 0   1 0     0   0   1 0                 1
1717193 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   kindergarten 0 0 0   7 0     0   0   3 4     *   *     *   *   7 0 0 0   7 0     0   0   3 4                 7
1717194 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_1 0 0 0   7 0     0   0   5 2     *   *     *   *   7 0 0 0   7 0     0   0   5 2                 7
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
1717196 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_3 0 0 0   2 0     0   0   1 1     *   *     *   *   2 0 0 0   2 0     0   0   1 1                 2
1717197 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_4 0 0 0   6 0     0   0   3 3     *   *     *   *   6 0 0 0   6 0     0   0   3 3                 6
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
1717199 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_6 0 0 0   14 0     0   0   6 8     0.0   0.0     10.0   5.0   14 0 0 0   14 0     0   0   6 8     0 0   10 5   14
1717200 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   pk_12_total 0 0 0   46 0     0   0   26 20     0.0   0.0     32.0   15.0   46 0 0 0   46 0     0   0   26 20     0 0   32 15   46
1717739 MN Traverse 78 school 2707110 801 Independent Districts and Schools Browns Valley Public School District 270711000279 10 Browns Valley Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 04 2021   early_childhood_special_ed 0 0 0   2 0     0   0   2 0     *   *     *   *   2 0 0 0   2 0     0   0   2 0                 2
1718035 MN Watonwan 83 school 2707320 836 Independent Districts and Schools Butterfield Public School District 270732000304 10 Butterfield Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2021   early_childhood_special_ed 0 0 1   0 0     0   0   1 0     *   *     *   *   1 0 0 1   0 0     0   0   1 0                 1
1718659 MN Lesueur 40 school 2718070 2397 Independent Districts and Schools Le Sueur-Henderson School District 271807000045 10 Park Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 04 2021   grade_4 0 0 1   0 0     0   0   1 0     *   *     *   *   1 0 0 1   0 0     0   0   1 0                 1
1719103 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   pre_kindergarten 0 11 3   1 2     0   2   7 12     0.0   2.0     11.0   0.0   19 0 11 3   1 2     0   2   7 12     0 2   11 0   19
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
1719159 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124001920 140 Loring Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   early_childhood_special_ed 0 0 1   0 1     0   0   1 1     *   *     *   *   2 0 0 1   0 1     0   0   1 1                 2
1719175 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124001014 151 Jenny Lind Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   early_childhood_special_ed 0 0 0   0 0     0   1   0 1     *   *     *   *   1 0 0 0   0 0     0   1   0 1                 1
1719205 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124001031 160 Seward Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 08 2021   early_childhood_special_ed 0 0 1   0 0     0   2   2 1     *   *     *   *   3 0 0 1   0 0     0   2   2 1                 3
1719216 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124002178 161 Sheridan Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   early_childhood_special_ed 0 0 2   0 0     0   0   1 1     *   *     *   *   2 0 0 2   0 0     0   0   1 1                 2
1719243 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124001866 175 Folwell Arts Magnet Elementary School (Grades PK-6) Regular School No Elementary PK 08 2021   early_childhood_special_ed 0 0 2   0 0     0   0   1 1     *   *     *   *   2 0 0 2   0 0     0   0   1 1                 2
1719254 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   early_childhood_special_ed 0 2 12   0 0     0   0   10 4     0.0   0.0     11.0   *   14 0 2 12   0 0     0   0   10 4     0 0   11     14
1719260 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_4 0 6 28   1 1     0   2   19 19     26.0   0.0     33.0   8.0   38 0 6 28   1 1     0   2   19 19     26 0   33 8   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
1719263 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124000986 179 Jefferson Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 08 2021   grade_7 0 13 20   3 1     0   1   20 18     13.0   1.0     32.0   11.0   38 0 13 20   3 1     0   1   20 18     13 1   32 11   38
1719290 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124002297 193 Sullivan Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 08 2021   grade_3 0 30 1   1 0     0   4   20 16     16.0   3.0     *   5.0   36 0 30 1   1 0     0   4   20 16     16 3     5   36
1719305 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   early_childhood_special_ed 0 1 0   0 0     0   0   1 0     *   *     *   *   1 0 1 0   0 0     0   0   1 0                 1
1719308 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_1 0 5 5   16 0     0   8   15 19     0.0   0.0     *   5.0   34 0 5 5   16 0     0   8   15 19     0 0     5   34
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
1719310 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_3 0 4 6   23 0     0   2   19 16     0.0   1.0     *   7.0   35 0 4 6   23 0     0   2   19 16     0 1     7   35
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
1719324 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124005048 230 Prekindergarten North Elementary School (Grades PK-6) Regular School No Prekindergarten PK PK 2021   early_childhood_special_ed 0 3 2   0 0     0   1   4 2     *   *     *   *   6 0 3 2   0 0     0   1   4 2                 6
1719325 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124005048 230 Prekindergarten North Elementary School (Grades PK-6) Regular School No Prekindergarten PK PK 2021   pk_12_total 0 3 2   0 0     0   1   4 2     *   *     *   *   6 0 3 2   0 0     0   1   4 2                 6
1719345 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124001882 260 Emerson Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   early_childhood_special_ed 0 0 3   0 0     0   0   3 0     *   *     *   *   3 0 0 3   0 0     0   0   3 0                 3
1719353 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 2021   early_childhood_special_ed 0 0 0   0 0     0   1   1 0     *   *     *   *   1 0 0 0   0 0     0   1   1 0                 1
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
1719371 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   early_childhood_special_ed 0 1 1   0 0     0   0   1 1     *   *     *   *   2 0 1 1   0 0     0   0   1 1                 2
1719380 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124002700 289 Whittier International Elementary School (Grades PK-6) Regular School No Elementary PK 05 2021   early_childhood_special_ed 0 3 0   0 0     0   0   3 0     *   *     *   *   3 0 3 0   0 0     0   0   3 0                 3
1719388 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   early_childhood_special_ed 0 0 0   0 1     0   0   1 0     *   *     *   *   1 0 0 0   0 1     0   0   1 0                 1
1719394 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_4 0 26 2   1 26     0   3   31 27     39.0   3.0     43.0   7.0   58 0 26 2   1 26     0   3   31 27     39 3   43 7   58
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
1719397 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124004239 291 Hmong International Academy Elementary School (Grades PK-6) Regular School No Elementary PK 08 2021   grade_7 0 28 6   1 13     0   1   21 28     19.0   2.0     40.0   12.0   49 0 28 6   1 13     0   1   21 28     19 2   40 12   49
1719437 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   pre_kindergarten 0 8 2   0 0     0   0   8 2     0.0   0.0     *   0.0   10 0 8 2   0 0     0   0   8 2     0 0     0   10
1719438 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   kindergarten 0 16 2   0 0     0   0   8 10     10.0   0.0     *   0.0   18 0 16 2   0 0     0   0   8 10     10 0     0   18
1719439 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_1 0 13 0   0 0     0   0   6 7     *   0.0     *   0.0   13 0 13 0   0 0     0   0   6 7       0     0   13
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
1719441 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_3 0 6 0   0 0     0   0   3 3     *   *     *   *   6 0 6 0   0 0     0   0   3 3                 6
1719442 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_4 0 9 0   0 0     0   0   8 1     *   *     *   *   9 0 9 0   0 0     0   0   8 1                 9
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
1719444 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_6 0 12 1   0 0     0   0   6 7     7.0   0.0     *   2.0   13 0 12 1   0 0     0   0   6 7     7 0     2   13
1719445 MN Hennepin 27 school 2700027 4004 Charter Schools Cedar Riverside Community School 270002702340 10 Cedar Riverside Community School Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2021   grade_7 0 2 0   0 0     0   0   1 1     *   *     *   *   2 0 2 0   0 0     0   0   1 1                 2
1719446 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_8 0 11 0   0 0     0   1   7 5     5.0   0.0     *   1.0   12 0 11 0   0 0     0   1   7 5     5 0     1   12
1719447 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   pk_12_total 0 92 6   0 0     0   1   53 46     58.0   0.0     *   6.0   99 0 92 6   0 0     0   1   53 46     58 0     6   99
1719474 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   early_childhood_special_ed 0 1 0   0 0     0   0   1 0     *   *     *   *   1 0 1 0   0 0     0   0   1 0                 1
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
1719500 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_6 0 26 0   0 0     0   0   15 11     13.0   0.0     *   3.0   26 0 26 0   0 0     0   0   15 11     13 0     3   26
1719501 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   pk_12_total 0 62 0   0 0     0   0   33 29     38.0   0.0     *   5.0   62 0 62 0   0 0     0   0   33 29     38 0     5   62
1719502 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   kindergarten 0 33 0   0 0     0   0   11 22     16.0   0.0     *   0.0   33 0 33 0   0 0     0   0   11 22     16 0     0   33
1719503 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_1 0 32 0   0 0     0   0   16 16     20.0   0.0     *   0.0   32 0 32 0   0 0     0   0   16 16     20 0     0   32
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
1719505 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_3 0 35 0   0 0     0   0   21 14     29.0   0.0     *   2.0   35 0 35 0   0 0     0   0   21 14     29 0     2   35
1719506 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_4 0 39 0   0 0     0   0   19 20     32.0   0.0     *   1.0   39 0 39 0   0 0     0   0   19 20     32 0     1   39
1719507 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   pk_12_total 0 179 0   0 0     0   0   89 90     124.0   0.0     *   7.0   179 0 179 0   0 0     0   0   89 90     124 0     7   179
1719508 MN Ramsey 62 school 2700118 4018 Charter Schools Achieve Language Academy 270011802608 10 Achieve Language Academy Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2021   early_childhood_special_ed 0 0 2   0 1     0   0   2 1     *   *     *   *   3 0 0 2   0 1     0   0   2 1                 3
1719537 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   kindergarten 0 94 0   0 0     0   0   47 47     12.0   0.0     83.0   0.0   94 0 94 0   0 0     0   0   47 47     12 0   83 0   94
1719538 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_1 0 100 0   0 0     0   0   42 58     9.0   0.0     *   1.0   100 0 100 0   0 0     0   0   42 58     9 0     1   100
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
1719540 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_3 0 86 0   0 0     0   0   44 42     64.0   0.0     *   5.0   86 0 86 0   0 0     0   0   44 42     64 0     5   86
1719541 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_4 0 73 0   0 0     0   0   36 37     44.0   0.0     *   4.0   73 0 73 0   0 0     0   0   36 37     44 0     4   73
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
1719543 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_6 0 92 0   0 0     0   0   41 51     34.0   0.0     *   1.0   92 0 92 0   0 0     0   0   41 51     34 0     1   92
1719544 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   pk_12_total 0 608 0   0 0     0   0   294 314     216.0   0.0     *   14.0   608 0 608 0   0 0     0   0   294 314     216 0     14   608
1719545 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   early_childhood_special_ed 0 0 2   0 0     0   0   1 1     *   *     *   *   2 0 0 2   0 0     0   0   1 1                 2
1719546 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   pre_kindergarten 0 5 7   0 14     0   3   15 14     0.0   0.0     16.0   0.0   29 0 5 7   0 14     0   3   15 14     0 0   16 0   29
1719550 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_3 0 10 23   0 11     0   1   27 18     28.0   2.0     40.0   5.0   45 0 10 23   0 11     0   1   27 18     28 2   40 5   45
1719551 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_4 0 7 18   1 15     0   1   20 22     25.0   1.0     *   3.0   42 0 7 18   1 15     0   1   20 22     25 1     3   42
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
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
1719559 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_4 0 13 3   0 12     0   1   14 15     6.0   1.0     16.0   4.0   29 0 13 3   0 12     0   1   14 15     6 1   16 4   29
1719564 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   kindergarten 0 32 2   0 0     0   0   18 16     3.0   5.0     29.0   0.0   34 0 32 2   0 0     0   0   18 16     3 5   29 0   34
1719565 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_1 0 22 9   0 0     0   4   20 15     8.0   3.0     31.0   4.0   35 0 22 9   0 0     0   4   20 15     8 3   31 4   35
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
1719567 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_3 0 25 4   0 0     0   4   18 15     3.0   3.0     *   10.0   33 0 25 4   0 0     0   4   18 15     3 3     10   33
1719568 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_4 0 28 7   0 0     0   2   20 17     7.0   6.0     *   11.0   37 0 28 7   0 0     0   2   20 17     7 6     11   37
1719571 MN Hennepin 27 school 2700159 4038 Charter Schools Sojourner Truth Academy 270015902954 10 Sojourner Truth Academy Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2021   grade_7 0 32 10   0 0     0   0   22 20     6.0   4.0     *   7.0   42 0 32 10   0 0     0   0   22 20     6 4     7   42
1719635 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   early_childhood_special_ed 0 0 2   0 0     0   0   1 1     *   *     *   *   2 0 0 2   0 0     0   0   1 1                 2
1719636 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   pre_kindergarten 0 0 18   0 0     0   0   7 11     15.0   *     14.0   0.0   18 0 0 18   0 0     0   0   7 11     15     14 0   18
1719637 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   kindergarten 0 0 37   0 0     0   0   19 18     30.0   0.0     31.0   3.0   37 0 0 37   0 0     0   0   19 18     30 0   31 3   37
1719638 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_1 0 0 41   0 0     0   0   22 19     *   0.0     33.0   5.0   41 0 0 41   0 0     0   0   22 19       0   33 5   41
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
1719640 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_3 0 0 40   0 0     0   0   22 18     *   0.0     *   7.0   40 0 0 40   0 0     0   0   22 18       0     7   40
1719641 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_4 0 0 40   0 0     0   0   20 20     *   0.0     32.0   6.0   40 0 0 40   0 0     0   0   20 20       0   32 6   40
1719642 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   pk_12_total 0 0 220   0 0     0   0   113 107     197.0   0.0     180.0   29.0   220 0 0 220   0 0     0   0   113 107     197 0   180 29   220
1719645 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_1 0 57 4   0 0     0   0   32 29     6.0   0.0     *   4.0   61 0 57 4   0 0     0   0   32 29     6 0     4   61
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
1719647 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_3 0 41 1   0 0     0   2   16 28     13.0   3.0     *   5.0   44 0 41 1   0 0     0   2   16 28     13 3     5   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

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