Data source: Big Local News · About: Big Local

951 rows where grade = "grade_1", state = "MN" and year = 2020 sorted by ell

View and edit SQL

year

  • 2020 · 951

grade

  • grade_1 · 951
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
1826871 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000114 411 McKinley Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2020   grade_1 95.0 1.0 2.0   0.0 4.0     0.0   4.0   50.0 56.0     *   0.0         10.0   106.0 95 1 2   0 4     0   4   50 56       0     10   106
1827211 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_1 0.0 0.0 0.0   112.0 0.0     0.0   0.0   54.0 58.0     *   5.0         23.0   112.0 0 0 0   112 0     0   0   54 58       5     23   112
1827223 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_1 0.0 0.0 0.0   23.0 0.0     0.0   0.0   14.0 9.0     *   5.0         3.0   23.0 0 0 0   23 0     0   0   14 9       5     3   23
1827350 MN Brown 8 school 2709540 81 Independent Districts and Schools Comfrey Public School District 270954000403 10 Comfrey Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2020   grade_1 4.0 0.0 1.0   0.0 0.0     0.0   0.0   3.0 2.0     *   *         *   5.0 4 0 1   0 0     0   0   3 2                 5
1827609 MN Clay 14 school 2713560 150 Independent Districts and Schools Hawley Public School District 271356000698 10 Hawley Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2020   grade_1 70.0 1.0 5.0   1.0 0.0     0.0   0.0   33.0 44.0     *   *         *   77.0 70 1 5   1 0     0   0   33 44                 77
1827617 MN Clay 14 school 2713560 150 Independent Districts and Schools Hawley Public School District 271356002240 11 Spring Prairie Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 06 2020   grade_1 2.0 0.0 0.0   0.0 0.0     0.0   0.0   2.0 0.0     *   *         *   2.0 2 0 0   0 0     0   0   2 0                 2
1827749 MN Dakota 19 school 2707290 191 Independent Districts and Schools Burnsville Public School District 270729000296 483 Edward Neill Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2020   grade_1 19.0 15.0 9.0   1.0 1.0     0.0   8.0   29.0 24.0     *   2.0     31.0   6.0   53.0 19 15 9   1 1     0   8   29 24       2   31 6   53
1827776 MN Dakota 19 school 2707290 191 Independent Districts and Schools Burnsville Public School District 270729000303 486 Vista View Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2020   grade_1 12.0 20.0 10.0   0.0 3.0     0.0   1.0   27.0 19.0     *   0.0     34.0   10.0   46.0 12 20 10   0 3     0   1   27 19       0   34 10   46
1827906 MN Dakota 19 school 2717780 194 Independent Districts and Schools Lakeville Public School District 271778002643 598 Eastview Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2020   grade_1 94.0 3.0 3.0   0.0 5.0     0.0   4.0   48.0 61.0     *   0.0         8.0   109.0 94 3 3   0 5     0   4   48 61       0     8   109
1828258 MN Freeborn 24 school 2702970 241 Independent Districts and Schools Albert Lea Public School District 270297000071 120 Hawthorne Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2020   grade_1 42.0 5.0 19.0   0.0 6.0     0.0   2.0   42.0 32.0     *   0.0     51.0   11.0   74.0 42 5 19   0 6     0   2   42 32       0   51 11   74
1828265 MN Freeborn 24 school 2702970 241 Independent Districts and Schools Albert Lea Public School District 270297000074 130 Lakeview Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2020   grade_1 42.0 7.0 15.0   0.0 3.0     0.0   2.0   33.0 36.0     *   0.0     32.0   11.0   69.0 42 7 15   0 3     0   2   33 36       0   32 11   69
1828329 MN Grant 26 school 2713890 264 Independent Districts and Schools Herman-Norcross School District 271389000713 1 Herman Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2020   grade_1 3.0 0.0 0.0   0.0 0.0     0.0   0.0   1.0 2.0     *   *         *   3.0 3 0 0   0 0     0   0   1 2                 3
1828887 MN Hennepin 27 school 2731780 281 Independent Districts and Schools Robbinsdale Public School District 273178001339 30 Zachary Lane Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2020   grade_1 49.0 12.0 4.0   0.0 3.0     0.0   7.0   44.0 31.0     *   0.0     18.0   9.0   75.0 49 12 4   0 3     0   7   44 31       0   18 9   75
1828928 MN Hennepin 27 school 2733780 283 Independent Districts and Schools St. Louis Park Public School Dist. 273378002653 758 Park Spanish Immersion Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2020   grade_1 70.0 4.0 9.0   0.0 0.0     0.0   6.0   43.0 46.0     *   0.0         3.0   89.0 70 4 9   0 0     0   6   43 46       0     3   89
1829228 MN Koochiching 36 school 2732700 363 Independent Districts and Schools South Koochiching School District 273270001946 80 Northome Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2020   grade_1 6.0 0.0 0.0   3.0 0.0     0.0   0.0   4.0 5.0     *   *         *   9.0 6 0 0   3 0     0   0   4 5                 9
1829237 MN Koochiching 36 school 2732700 363 Independent Districts and Schools South Koochiching School District 273270001945 90 Indus Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2020   grade_1 10.0 0.0 0.0   1.0 0.0     0.0   0.0   5.0 6.0     *   *         *   11.0 10 0 0   1 0     0   0   5 6                 11
1829291 MN Lincoln 41 school 2713680 402 Independent Districts and Schools Hendricks Public School District 271368000707 10 Hendricks Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2020   grade_1 8.0 0.0 0.0   0.0 0.0     0.0   0.0   2.0 6.0     *   *         *   8.0 8 0 0   0 0     0   0   2 6                 8
1829331 MN Lyon 42 school 2721270 414 Independent Districts and Schools Minneota Public School District 272127001067 1 Minneota Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2020   grade_1 30.0 0.0 2.0   0.0 0.0     0.0   0.0   17.0 15.0     *   0.0     7.0   5.0   32.0 30 0 2   0 0     0   0   17 15       0   7 5   32
1829453 MN Mille Lacs 48 school 2730030 477 Independent Districts and Schools Princeton Public School District 273003001274 1 Princeton Primary School Elementary School (Grades PK-6) Regular School No Elementary KG 02 2020   grade_1 209.0 2.0 7.0   0.0 1.0     0.0   5.0   106.0 118.0     *   6.0         36.0   224.0 209 2 7   0 1     0   5   106 118       6     36   224
1829530 MN Mower 50 school 2703450 492 Independent Districts and Schools Austin Public School District 270345000153 40 Neveln Elementary Elementary School (Grades PK-6) Regular School No Elementary 01 04 2020   grade_1 37.0 3.0 11.0   0.0 6.0     0.0   3.0   32.0 28.0     *   *         15.0   60.0 37 3 11   0 6     0   3   32 28             15   60
1829572 MN Mower 50 school 2718060 499 Independent Districts and Schools LeRoy-Ostrander Public Schools 271806000831 15 LeRoy Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2020   grade_1 21.0 0.0 1.0   0.0 0.0     0.0   1.0   14.0 9.0     *   0.0     11.0   2.0   23.0 21 0 1   0 0     0   1   14 9       0   11 2   23
1829641 MN Olmsted 55 school 2711010 533 Independent Districts and Schools Dover-Eyota Public School District 271101000453 20 Dover-Eyota Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2020   grade_1 78.0 2.0 0.0   1.0 0.0     0.0   0.0   44.0 37.0     *   0.0     25.0   12.0   81.0 78 2 0   1 0     0   0   44 37       0   25 12   81
1829684 MN Olmsted 55 school 2731800 535 Independent Districts and Schools Rochester Public School District 273180000992 122 Folwell Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2020   grade_1 41.0 3.0 3.0   0.0 3.0     0.0   0.0   33.0 17.0     *   *         *   50.0 41 3 3   0 3     0   0   33 17                 50
1829746 MN Olmsted 55 school 2731800 535 Independent Districts and Schools Rochester Public School District 273180001006 140 Longfellow Choice Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2020   grade_1 28.0 12.0 6.0   0.0 2.0     0.0   6.0   26.0 28.0     *   0.0     21.0   7.0   54.0 28 12 6   0 2     0   6   26 28       0   21 7   54
1829988 MN Ramsey 62 school 2722950 621 Independent Districts and Schools Mounds View Public School District 272295001129 35 Turtle Lake Elementary Elementary School (Grades PK-6) Regular School No Elementary 01 05 2020   grade_1 158.0 8.0 10.0   0.0 19.0     0.0   13.0   105.0 103.0     *   0.0     24.0   18.0   208.0 158 8 10   0 19     0   13   105 103       0   24 18   208
1830021 MN Ramsey 62 school 2723850 622 Independent Districts and Schools North St. Paul-Maplewood Oakdale Public School District 272385001168 29 Cowern Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2020   grade_1 25.0 13.0 9.0   1.0 14.0     0.0   10.0   38.0 34.0     *   1.0     37.0   *   72.0 25 13 9   1 14     0   10   38 34       1   37     72
1830028 MN Washington 82 school 2723850 622 Independent Districts and Schools North St. Paul-Maplewood Oakdale Public School District 272385001169 30 Eagle Point Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2020   grade_1 39.0 9.0 5.0   1.0 12.0     0.0   11.0   37.0 40.0     *   0.0     30.0   18.0   77.0 39 9 5   1 12     0   11   37 40       0   30 18   77
1830323 MN Ramsey 62 school 2733840 625 Independent Districts and Schools St. Paul Public School District 273384004682 463 L'etoile Du Nord French Immersion L Elementary School (Grades PK-6) Regular School No Elementary PK 02 2020   grade_1 37.0 6.0 10.0   0.0 5.0     0.0   14.0   26.0 46.0     *   0.0         3.0   72.0 37 6 10   0 5     0   14   26 46       0     3   72
1830359 MN Ramsey 62 school 2733840 625 Independent Districts and Schools St. Paul Public School District 273384001583 476 Groveland Park Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2020   grade_1 31.0 20.0 2.0   0.0 2.0     0.0   9.0   27.0 37.0     *   2.0     31.0   6.0   64.0 31 20 2   0 2     0   9   27 37       2   31 6   64
1830390 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 2020   grade_1 4.0 21.0 5.0   0.0 11.0     0.0   0.0   24.0 17.0     *   0.0     36.0   9.0   41.0 4 21 5   0 11     0   0   24 17       0   36 9   41
1830572 MN Redwood 64 school 2721210 635 Independent Districts and Schools Milroy Public School District 272121000927 1 Milroy Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2020   grade_1 5.0 0.0 0.0   0.0 0.0     0.0   0.0   2.0 3.0     *   *         *   5.0 5 0 0   0 0     0   0   2 3                 5
1830668 MN Roseau 68 school 2741850 690 Independent Districts and Schools Warroad Public School District 274185001744 10 Warroad Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2020   grade_1 49.0 0.0 2.0   3.0 7.0     0.0   8.0   37.0 32.0     *   *         *   69.0 49 0 2   3 7     0   8   37 32                 69
1830676 MN Lake of the Woods 39 school 2741850 690 Independent Districts and Schools Warroad Public School District 274185002456 20 Angle Inlet Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 06 2020   grade_1 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
1830759 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_1 0.0 0.0 0.0   6.0 0.0     0.0   0.0   5.0 1.0     *   *         *   6.0 0 0 0   6 0     0   0   5 1                 6
1830795 MN Saint Louis 69 school 2711040 709 Independent Districts and Schools Duluth Public School District 271104000475 520 Lowell Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2020   grade_1 32.0 4.0 2.0   2.0 0.0     0.0   9.0   24.0 25.0     *   0.0     23.0   7.0   49.0 32 4 2   2 0     0   9   24 25       0   23 7   49
1830924 MN Scott 70 school 2733000 720 Independent Districts and Schools Shakopee Public School District 273300001437 861 Sun Path Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2020   grade_1 57.0 11.0 7.0   2.0 6.0     0.0   12.0   49.0 46.0     *   *         14.0   95.0 57 11 7   2 6     0   12   49 46             14   95
1830991 MN Hennepin 27 school 2711370 728 Independent Districts and Schools Elk River School District 271137000521 70 Rogers Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2020   grade_1 95.0 3.0 4.0   1.0 2.0     0.0   5.0   56.0 54.0     *   *     7.0   11.0   110.0 95 3 4   1 2     0   5   56 54           7 11   110
1831041 MN Sherburne 71 school 2711370 728 Independent Districts and Schools Elk River School District 271137000030 700 Meadowvale Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2020   grade_1 93.0 5.0 1.0   0.0 0.0     0.0   9.0   62.0 46.0     *   0.0     11.0   11.0   108.0 93 5 1   0 0     0   9   62 46       0   11 11   108
1831095 MN Stearns 73 school 2733510 742 Independent Districts and Schools St. Cloud Public School District 273351001485 25 Kennedy Community School Elementary School (Grades PK-6) Regular School No Elementary PK 08 2020   grade_1 80.0 14.0 5.0   1.0 0.0     0.0   4.0   41.0 63.0     *   3.0     40.0   19.0   104.0 80 14 5   1 0     0   4   41 63       3   40 19   104
1831256 MN Stevens 75 school 2713380 768 Independent Districts and Schools Hancock Public School District 271338000688 10 Hancock Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2020   grade_1 21.0 0.0 4.0   0.0 0.0     0.0   1.0   9.0 17.0     *   0.0         1.0   26.0 21 0 4   0 0     0   1   9 17       0     1   26
1831265 MN Stevens 75 school 2708940 771 Independent Districts and Schools Chokio-Alberta Public School Dist. 270894000362 3 Chokio-Alberta Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2020   grade_1 8.0 0.0 0.0   0.0 0.0     0.0   0.0   6.0 2.0     *   *         *   8.0 8 0 0   0 0     0   0   6 2                 8
1831274 MN Swift 76 school 2717120 775 Independent Districts and Schools Kerkhoven-Murdock-Sunburg 271712001890 30 Murdock Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2020   grade_1 40.0 1.0 7.0   0.0 0.0     0.0   1.0   28.0 21.0     *   0.0         6.0   49.0 40 1 7   0 0     0   1   28 21       0     6   49
1831294 MN Todd 77 school 2705430 786 Independent Districts and Schools Bertha-Hewitt Public School District 270543000203 10 Bertha Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2020   grade_1 34.0 0.0 2.0   0.0 0.0     0.0   1.0   16.0 21.0     *   0.0     19.0   8.0   37.0 34 0 2   0 0     0   1   16 21       0   19 8   37
1831303 MN Todd 77 school 2706300 787 Independent Districts and Schools Browerville Public School District 270630000277 10 Browerville Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2020   grade_1 33.0 0.0 1.0   0.0 0.0     0.0   0.0   14.0 20.0     *   0.0     18.0   5.0   34.0 33 0 1   0 0     0   0   14 20       0   18 5   34
1831329 MN Wabasha 79 school 2741060 811 Independent Districts and Schools Wabasha-Kellogg Public School Dist. 274106001723 30 Wabasha-Kellogg Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2020   grade_1 27.0 2.0 1.0   0.0 0.0     0.0   0.0   10.0 20.0     *   *         *   30.0 27 2 1   0 0     0   0   10 20                 30
1831347 MN Wadena 80 school 2740920 818 Independent Districts and Schools Verndale Public School District 274092001712 10 Verndale Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2020   grade_1 34.0 0.0 0.0   1.0 1.0     0.0   1.0   20.0 17.0     *   0.0         12.0   37.0 34 0 0   1 1     0   1   20 17       0     12   37
1831907 MN Saint Louis 69 school 2700008 2142 Independent Districts and Schools St. Louis County School District 270000800158 10 Babbitt Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2020   grade_1 10.0 0.0 0.0   0.0 1.0     0.0   3.0   5.0 9.0     *   *         *   14.0 10 0 0   0 1     0   3   5 9                 14
1831917 MN Saint Louis 69 school 2700008 2142 Independent Districts and Schools St. Louis County School District 270000801684 20 Tower-Soudan Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2020   grade_1 5.0 0.0 0.0   4.0 0.0     0.0   0.0   3.0 6.0     *   *         *   9.0 5 0 0   4 0     0   0   3 6                 9
1831964 MN Chisago 13 school 2700017 2144 Independent Districts and Schools Chisago Lakes School District 270001700352 1 Chisago Lakes El. Elementary School (Grades PK-6) Regular School No Elementary PK 01 2020   grade_1 185.0 1.0 1.0   0.0 1.0     0.0   1.0   98.0 91.0     *   0.0     35.0   26.0   189.0 185 1 1   0 1     0   1   98 91       0   35 26   189
1831972 MN Chisago 13 school 2700017 2144 Independent Districts and Schools Chisago Lakes School District 270001701672 6 Taylors Falls Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2020   grade_1 56.0 2.0 2.0   0.0 0.0     0.0   2.0   31.0 31.0     *   0.0     13.0   16.0   62.0 56 2 2   0 0     0   2   31 31       0   13 16   62
1832028 MN Pine 58 school 2714070 2165 Independent Districts and Schools Hinckley-Finlayson School District 271407000728 10 Hinckley Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2020   grade_1 46.0 0.0 3.0   11.0 2.0     0.0   3.0   30.0 35.0     *   *         *   65.0 46 0 3   11 2     0   3   30 35                 65
1832037 MN Pine 58 school 2714070 2165 Independent Districts and Schools Hinckley-Finlayson School District 271407000585 30 Finlayson Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2020   grade_1 6.0 0.0 1.0   0.0 0.0     0.0   0.0   3.0 4.0     *   *         *   7.0 6 0 1   0 0     0   0   3 4                 7
1832301 MN Mcleod 43 school 2700123 2687 Independent Districts and Schools Howard Lake-Waverly-Winsted 270012300908 1 Winsted Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 04 2020   grade_1 37.0 2.0 1.0   0.0 0.0     0.0   1.0   25.0 16.0     *   *     12.0   *   41.0 37 2 1   0 0     0   1   25 16           12     41
1832307 MN Wright 86 school 2700123 2687 Independent Districts and Schools Howard Lake-Waverly-Winsted 270012302697 3 Humphrey Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2020   grade_1 48.0 0.0 3.0   0.0 0.0     0.0   1.0   26.0 26.0     *   *     10.0   *   52.0 48 0 3   0 0     0   1   26 26           10     52
1832315 MN Pipestone 59 school 2700108 2689 Independent Districts and Schools Pipestone Area School District 270010801261 2 Brown Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 01 2020   grade_1 63.0 0.0 22.0   0.0 0.0     0.0   4.0   49.0 40.0     *   *         *   89.0 63 0 22   0 0     0   4   49 40                 89
1832322 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 2020   grade_1 2.0 0.0 0.0   0.0 0.0     0.0   0.0   1.0 1.0     *   *         *   2.0 2 0 0   0 0     0   0   1 1                 2
1832465 MN Big Stone 6 school 2700150 2888 Independent Districts and Schools Clinton-Graceville-Beardsley 270015000378 1 Clinton-Graceville-Beardsley El. Elementary School (Grades PK-6) Regular School No Elementary PK 06 2020   grade_1 18.0 0.0 0.0   0.0 0.0     0.0   1.0   11.0 8.0     *   *         *   19.0 18 0 0   0 0     0   1   11 8                 19
1832779 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124001865 170 Windom School Elementary School (Grades PK-6) Regular School No Elementary PK 05 2020   grade_1 50.0 4.0 42.0   0.0 1.0     0.0   12.0   55.0 54.0     *   0.0     29.0   7.0   109.0 50 4 42   0 1     0   12   55 54       0   29 7   109
1833036 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 2020   grade_1 3.0 3.0 0.0   0.0 0.0     0.0   1.0   3.0 4.0     *   *         *   7.0 3 3 0   0 0     0   1   3 4                 7
1833126 MN Nicollet 52 school 2700174 4050 Charter Schools Lafayette Public Charter School 270017403042 10 Lafayette Public Charter School Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2020   grade_1 7.0 0.0 0.0   0.0 0.0     0.0   0.0   2.0 5.0     *   *         *   7.0 7 0 0   0 0     0   0   2 5                 7
1833147 MN Houston 28 school 2700178 4054 Charter Schools LA CRESCENT MONTESSORI ACADEMY 270017803046 10 La Crescent Montessori & STEM Academy Elementary School (Grades PK-6) Regular School Yes Elementary KG 06 2020   grade_1 5.0 0.0 0.0   0.0 0.0     0.0   0.0   4.0 1.0     *   *         *   5.0 5 0 0   0 0     0   0   4 1                 5
1833183 MN Winona 85 school 2700221 4064 Charter Schools Riverway Learning Community Charter 270022103478 10 Riverway Learning Community Charter Elementary School (Grades PK-6) Regular School Yes Elementary PK 06 2020   grade_1 5.0 2.0 1.0   0.0 0.0     0.0   1.0   4.0 5.0     *   *         *   9.0 5 2 1   0 0     0   1   4 5                 9
1833193 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_1 0.0 0.0 39.0   0.0 0.0     0.0   0.0   20.0 19.0     *   0.0     33.0   7.0   39.0 0 0 39   0 0     0   0   20 19       0   33 7   39
1833467 MN Cook 16 school 2700255 4145 Charter Schools Birch Grove Community School 270025503313 10 Birch Grove Community School Elementary School (Grades PK-6) Regular School Yes Elementary KG 05 2020   grade_1 3.0 0.0 0.0   0.0 0.0     0.0   0.0   1.0 2.0     *   *         *   3.0 3 0 0   0 0     0   0   1 2                 3
1833484 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_1 0.0 25.0 0.0   0.0 0.0     0.0   0.0   10.0 15.0     *   0.0         0.0   25.0 0 25 0   0 0     0   0   10 15       0     0   25
1833587 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 2020   grade_1 5.0 0.0 1.0   1.0 0.0     0.0   0.0   3.0 4.0     *   *         *   7.0 5 0 1   1 0     0   0   3 4                 7
1833654 MN Hennepin 27 school 2700316 4189 Charter Schools Bright Water Elementary 270031604319 10 Bright Water Elementary Elementary School (Grades PK-6) Regular School Yes Elementary KG 06 2020   grade_1 3.0 13.0 1.0   0.0 0.0     0.0   0.0   9.0 8.0     *   3.0     13.0   2.0   17.0 3 13 1   0 0     0   0   9 8       3   13 2   17
1833700 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_1 0.0 0.0 0.0   3.0 0.0     0.0   0.0   3.0 0.0     *   *         *   3.0 0 0 0   3 0     0   0   3 0                 3
1833910 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_1 0.0 42.0 0.0   0.0 0.0     0.0   0.0   23.0 19.0     *   0.0         0.0   42.0 0 42 0   0 0     0   0   23 19       0     0   42
1833965 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_1 0.0 37.0 0.0   0.0 0.0     0.0   0.0   19.0 18.0     *   0.0     33.0   1.0   37.0 0 37 0   0 0     0   0   19 18       0   33 1   37
1833973 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_1 0.0 0.0 0.0   0.0 0.0     0.0   2.0   1.0 1.0     *   *         *   2.0 0 0 0   0 0     0   2   1 1                 2
1833981 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_1 0.0 41.0 0.0   0.0 0.0     0.0   0.0   22.0 19.0     *   0.0         4.0   41.0 0 41 0   0 0     0   0   22 19       0     4   41
1834002 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 2020   grade_1 1.0 4.0 0.0   0.0 0.0     0.0   0.0   2.0 3.0     *   *         *   5.0 1 4 0   0 0     0   0   2 3                 5
1834017 MN Hennepin 27 school 2700456 4273 Charter Schools Modern Montessori Charter School 270045605224 10 Modern Montessori Charter School Elementary School (Grades PK-6) Regular School Yes Elementary PK 05 2020   grade_1 7.0 0.0 0.0   0.0 0.0     0.0   0.0   4.0 3.0     *   *         *   7.0 7 0 0   0 0     0   0   4 3                 7
1836923 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000005 467 River Trail Learning Ctr @ LO Jacob Special Education Special Education School No Other KG 12 2020   grade_1 0.0 1.0 3.0   0.0 0.0     0.0   0.0   3.0 1.0     *   *         *   4.0 0 1 3   0 0     0   0   3 1                 4
1837088 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_1 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
1837095 MN Hennepin 27 school 2733780 283 Independent Districts and Schools St. Louis Park Public School Dist. 273378000833 756 St. Louis Park Special Ed. Program Special Education Special Education School No Elementary PK 06 2020   grade_1 1.0 1.0 0.0   0.0 0.0     0.0   0.0   2.0 0.0     *   *         *   2.0 1 1 0   0 0     0   0   2 0                 2
1837150 MN Olmsted 55 school 2731800 535 Independent Districts and Schools Rochester Public School District 273180000985 342 Rochester Phoenix Academy Special Education Special Education School No Other KG 12 2020   grade_1 1.0 1.0 0.0   0.0 0.0     0.0   0.0   2.0 0.0     *   *         *   2.0 1 1 0   0 0     0   0   2 0                 2
1837167 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_1 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
1837218 MN Ramsey 62 school 2733840 625 Independent Districts and Schools St. Paul Public School District 273384002189 430 Bridge View Special Education Special Education Special Education School No Other KG 12 2020   grade_1 1.0 0.0 0.0   1.0 3.0     0.0   0.0   3.0 2.0     *   *         *   5.0 1 0 0   1 3     0   0   3 2                 5
1837231 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_1 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
1837288 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_1 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
1837314 MN Stearns 73 school 2733510 742 Independent Districts and Schools St. Cloud Public School District 273351004648 62 Roosevelt Education Center Special Education Special Education School No Other KG 12 2020   grade_1 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
1837379 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 2020   grade_1 1.0 2.0 0.0   0.0 0.0     0.0   0.0   3.0 0.0     *   *         *   3.0 1 2 0   0 0     0   0   3 0                 3
1837407 MN Rice 66 school 2700129 160 State Operated Schools (which include MN Academy Deaf & Blind, School for the Arts) Minnesota State Academies 270012902409 2 MN Academy For The Deaf Special Education Special Education School No Other PK 12 2020   grade_1 5.0 0.0 1.0   0.0 0.0     0.0   0.0   3.0 3.0     *   *         *   6.0 5 0 1   0 0     0   0   3 3                 6
1837433 MN Hennepin 27 school 2700025 287 Intermediate Districts and Schools Intermediate School District 287 270002503213 440 Options Mid/Elem EBD Special Education Special Education School No Other KG 09 2020   grade_1 2.0 1.0 1.0   0.0 0.0     0.0   0.0   4.0 0.0     *   *         *   4.0 2 1 1   0 0     0   0   4 0                 4
1837447 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_1 0.0 0.0 0.0   0.0 1.0     0.0   0.0   1.0 0.0     *   *         *   1.0 0 0 0   0 1     0   0   1 0                 1
1837497 MN Scott 70 school 2700420 288 Intermediate Districts and Schools Southwest Metro Intermediate 288 270042005038 12 SW Metro Level 4 Programs Special Education Special Education School No Other 01 12 2020   grade_1 3.0 1.0 0.0   0.0 1.0     0.0   0.0   4.0 1.0     *   *         *   5.0 3 1 0   0 1     0   0   4 1                 5
1837529 MN Anoka 2 school 2702264 916 Intermediate Districts and Schools Northeast Metro 916 270226404643 40 Karner Blue Education Center Special Education Special Education School No Elementary KG 08 2020   grade_1 1.0 4.0 0.0   0.0 2.0     0.0   1.0   7.0 1.0     *   *         *   8.0 1 4 0   0 2     0   1   7 1                 8
1837545 MN Washington 82 school 2702264 916 Intermediate Districts and Schools Northeast Metro 916 270226404951 58 Pankalo Education Center Special Education Special Education School No Elementary KG 08 2020   grade_1 1.0 1.0 1.0   0.0 0.0     0.0   1.0   3.0 1.0     *   *         *   4.0 1 1 1   0 0     0   1   3 1                 4
1837574 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 2020   grade_1 1.0 1.0 0.0   0.0 1.0     0.0   0.0   2.0 1.0     *   *         *   3.0 1 1 0   0 1     0   0   2 1                 3
1837586 MN Dakota 19 school 2700026 917 Intermediate Districts and Schools Intermediate School District 917 270002602125 61 917 Paces Special Education Special Education School No Other KG 12 2020   grade_1 1.0 0.0 0.0   0.0 1.0     0.0   0.0   2.0 0.0     *   *         *   2.0 1 0 0   0 1     0   0   2 0                 2
1837600 MN Dakota 19 school 2700026 917 Intermediate Districts and Schools Intermediate School District 917 270002604218 400 917 Sun Special Education Special Education School No Other KG 12 2020   grade_1 3.0 1.0 1.0   0.0 1.0     0.0   1.0   6.0 1.0     *   *         *   7.0 3 1 1   0 1     0   1   6 1                 7
1837637 MN Dakota 19 school 2700026 917 Intermediate Districts and Schools Intermediate School District 917 270002605108 900 Customized Alternative Solutions for Education (CASE) Special Education Special Education School No Other PK 12 2020   grade_1 0.0 0.0 0.0   0.0 1.0     0.0   0.0   1.0 0.0     *   *         *   1.0 0 0 0   0 1     0   0   1 0                 1
1837702 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_1 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
1837715 MN Mille Lacs 48 school 2700318 6079 Special Education Cooperatives Rum River Special Education Coop 270031804296 10 RUM RIVER NORTH Special Education Special Education School No Other PK 12 2020   grade_1 2.0 0.0 0.0   0.0 0.0     0.0   0.0   2.0 0.0     *   *         *   2.0 2 0 0   0 0     0   0   2 0                 2
1837728 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 2020   grade_1 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
1837743 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_1 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
1837750 MN Mower 50 school 2700327 6083 Special Education Cooperatives Southern MN Education Consortium 270032705011 40 CARDS Program Special Education Special Education School No Other PK 12 2020   grade_1 3.0 0.0 0.0   0.0 0.0     0.0   0.0   3.0 0.0     *   *         *   3.0 3 0 0   0 0     0   0   3 0                 3
1837758 MN Freeborn 24 school 2700327 6083 Special Education Cooperatives Southern MN Education Consortium 270032705020 60 Wolverine Program Special Education Special Education School No Elementary PK 06 2020   grade_1 3.0 0.0 1.0   0.0 0.0     0.0   0.0   1.0 3.0     *   *         *   4.0 3 0 1   0 0     0   0   1 3                 4

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