Data source: Big Local News · About: Big Local

962 rows where grade = "grade_5", state = "MN" and year = 2020 sorted by homeless_int

View and edit SQL

year

  • 2020 · 962

grade

  • grade_5 · 962
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
1827073 MN Anoka 2 school 2733540 15 Independent Districts and Schools St. Francis Area Schools 273354000230 782 St. Francis Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2020   grade_5 87.0 1.0 4.0   0.0 1.0     0.0   6.0   47.0 52.0     *   *         *   99.0 87 1 4   0 1     0   6   47 52                 99
1827125 MN Becker 3 school 2710230 22 Independent Districts and Schools Detroit Lakes Public School Dist. 271023000445 10 Rossman Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2020   grade_5 83.0 0.0 5.0   6.0 1.0     0.0   10.0   48.0 57.0     0.0   *         *   105.0 83 0 5   6 1     0   10   48 57     0           105
1827155 MN Beltrami 4 school 2704440 31 Independent Districts and Schools Bemidji Public School District 270444005094 11 Gene Dillon Elementary School Elementary School (Grades PK-6) Regular School No Elementary 04 05 2020   grade_5 256.0 5.0 15.0   90.0 3.0     1.0   44.0   225.0 189.0     *   *         *   414.0 256 5 15   90 3     1   44   225 189                 414
1827354 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_5 3.0 0.0 2.0   0.0 0.0     0.0   0.0   2.0 3.0     *   *         *   5.0 3 0 2   0 0     0   0   2 3                 5
1827613 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_5 71.0 0.0 4.0   1.0 0.0     0.0   1.0   45.0 32.0     *   *         *   77.0 71 0 4   1 0     0   1   45 32                 77
1827621 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_5 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
1827780 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_5 18.0 18.0 16.0   0.0 7.0     0.0   8.0   38.0 29.0     13.0   *     37.0   10.0   67.0 18 18 16   0 7     0   8   38 29     13     37 10   67
1827805 MN Dakota 19 school 2707290 191 Independent Districts and Schools Burnsville Public School District 270729000302 489 Sky Oaks Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2020   grade_5 13.0 14.0 27.0   0.0 3.0     0.0   3.0   29.0 31.0     26.0   *     44.0   10.0   60.0 13 14 27   0 3     0   3   29 31     26     44 10   60
1827875 MN Dakota 19 school 2717780 194 Independent Districts and Schools Lakeville Public School District 271778002043 592 Huddleston Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2020   grade_5 69.0 11.0 12.0   1.0 6.0     0.0   2.0   46.0 55.0     7.0   *     31.0   29.0   101.0 69 11 12   1 6     0   2   46 55     7     31 29   101
1827889 MN Dakota 19 school 2717780 194 Independent Districts and Schools Lakeville Public School District 271778002273 595 Lake Marion Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2020   grade_5 92.0 11.0 8.0   0.0 2.0     0.0   6.0   64.0 55.0     0.0   *     24.0   22.0   119.0 92 11 8   0 2     0   6   64 55     0     24 22   119
1827975 MN Dakota 19 school 2732390 196 Independent Districts and Schools Rosemount-Apple Valley-Eagan 273239001376 711 Greenleaf Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2020   grade_5 96.0 16.0 31.0   0.0 8.0     0.0   19.0   94.0 76.0     20.0   *     57.0   30.0   170.0 96 16 31   0 8     0   19   94 76     20     57 30   170
1828407 MN Hennepin 27 school 2705790 271 Independent Districts and Schools Bloomington Public School District 270579000640 432 Washburn Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2020   grade_5 22.0 15.0 18.0   0.0 5.0     0.0   8.0   27.0 41.0     5.0   *     34.0   11.0   68.0 22 15 18   0 5     0   8   27 41     5     34 11   68
1828635 MN Hennepin 27 school 2725200 279 Independent Districts and Schools Osseo Public School District 272520003186 665 Woodland Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2020   grade_5 33.0 33.0 5.0   0.0 37.0     0.0   5.0   49.0 64.0     18.0   *     42.0   16.0   113.0 33 33 5   0 37     0   5   49 64     18     42 16   113
1828667 MN Hennepin 27 school 2725200 279 Independent Districts and Schools Osseo Public School District 272520001207 671 Birch Grove School For The Arts Elementary School (Grades PK-6) Regular School No Elementary PK 05 2020   grade_5 10.0 25.0 8.0   2.0 10.0     0.0   13.0   34.0 34.0     8.0   *     41.0   14.0   68.0 10 25 8   2 10     0   13   34 34     8     41 14   68
1828836 MN Hennepin 27 school 2731780 281 Independent Districts and Schools Robbinsdale Public School District 273178001326 10 Meadow Lake Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2020   grade_5 19.0 39.0 20.0   1.0 1.0     0.0   5.0   39.0 46.0     *   *     61.0   9.0   85.0 19 39 20   1 1     0   5   39 46           61 9   85
1828860 MN Hennepin 27 school 2731780 281 Independent Districts and Schools Robbinsdale Public School District 273178001329 17 Noble Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2020   grade_5 9.0 19.0 12.0   0.0 8.0     0.0   9.0   33.0 24.0     6.0   *     39.0   10.0   57.0 9 19 12   0 8     0   9   33 24     6     39 10   57
1829095 MN Itasca 31 school 2710140 317 Independent Districts and Schools Deer River Public School District 271014000434 4 King Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2020   grade_5 32.0 0.0 2.0   27.0 0.0     0.0   12.0   41.0 32.0     *   *         19.0   73.0 32 0 2   27 0     0   12   41 32             19   73
1829232 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_5 13.0 0.0 1.0   3.0 0.0     0.0   0.0   10.0 7.0     *   *         *   17.0 13 0 1   3 0     0   0   10 7                 17
1829241 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_5 8.0 0.0 0.0   1.0 0.0     0.0   0.0   4.0 5.0     *   *         *   9.0 8 0 0   1 0     0   0   4 5                 9
1829295 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_5 8.0 0.0 0.0   0.0 0.0     0.0   0.0   5.0 3.0     *   *         *   8.0 8 0 0   0 0     0   0   5 3                 8
1829348 MN Mcleod 43 school 2714970 423 Independent Districts and Schools Hutchinson Public School District 271497000754 10 Hutchinson Park Elementary Elementary School (Grades PK-6) Regular School No Elementary 02 05 2020   grade_5 176.0 1.0 23.0   0.0 0.0     0.0   10.0   120.0 90.0     *   *         *   210.0 176 1 23   0 0     0   10   120 90                 210
1829458 MN Mille Lacs 48 school 2730030 477 Independent Districts and Schools Princeton Public School District 273003001271 10 Princeton Intermediate School Elementary School (Grades PK-6) Regular School No Elementary 03 05 2020   grade_5 236.0 0.0 8.0   0.0 2.0     0.0   7.0   127.0 126.0     *   *         *   253.0 236 0 8   0 2     0   7   127 126                 253
1829551 MN Mower 50 school 2703450 492 Independent Districts and Schools Austin Public School District 270345004638 280 I.J. Holton Intermediate School Elementary School (Grades PK-6) Regular School No Middle 05 06 2020   grade_5 167.0 46.0 125.0   2.0 43.0     9.0   13.0   204.0 201.0     *   *         *   405.0 167 46 125   2 43     9   13   204 201                 405
1829591 MN Murray 51 school 2712480 505 Independent Districts and Schools Fulda Public School District 271248000617 10 Fulda Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2020   grade_5 25.0 0.0 4.0   1.0 3.0     0.0   1.0   17.0 17.0     3.0   *     15.0   8.0   34.0 25 0 4   1 3     0   1   17 17     3     15 8   34
1829620 MN Nobles 53 school 2711460 514 Independent Districts and Schools Ellsworth Public School District 271146000525 10 Ellsworth Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2020   grade_5 6.0 0.0 0.0   0.0 0.0     0.0   1.0   3.0 4.0     *   *         *   7.0 6 0 0   0 0     0   1   3 4                 7
1829980 MN Ramsey 62 school 2722950 621 Independent Districts and Schools Mounds View Public School District 272295001124 30 Pinewood Elementary Elementary School (Grades PK-6) Regular School No Elementary 01 05 2020   grade_5 68.0 15.0 11.0   1.0 14.0     0.0   5.0   62.0 52.0     13.0   *     61.0   18.0   114.0 68 15 11   1 14     0   5   62 52     13     61 18   114
1830154 MN Washington 82 school 2742360 624 Independent Districts and Schools White Bear Lake School District 274236003699 824 Oneka Elementary School Elementary School (Grades PK-6) Regular School No Elementary 02 05 2020   grade_5 124.0 2.0 10.0   0.0 9.0     0.0   10.0   69.0 86.0     5.0   *     32.0   24.0   155.0 124 2 10   0 9     0   10   69 86     5     32 24   155
1830202 MN Ramsey 62 school 2742360 624 Independent Districts and Schools White Bear Lake School District 274236001795 834 Vadnais Heights Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2020   grade_5 46.0 5.0 3.0   0.0 16.0     0.0   6.0   41.0 35.0     5.0   *     29.0   15.0   76.0 46 5 3   0 16     0   6   41 35     5     29 15   76
1830547 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_5 3.0 38.0 1.0   1.0 3.0     0.0   5.0   23.0 28.0     4.0   *     45.0   10.0   51.0 3 38 1   1 3     0   5   23 28     4     45 10   51
1830576 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_5 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
1830672 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_5 46.0 0.0 0.0   3.0 3.0     0.0   5.0   25.0 32.0     *   *         *   57.0 46 0 0   3 3     0   5   25 32                 57
1830680 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_5 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
1830708 MN Saint Louis 69 school 2712210 698 Independent Districts and Schools Floodwood Public School District 271221000588 10 Floodwood Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2020   grade_5 7.0 0.0 0.0   0.0 0.0     0.0   1.0   4.0 4.0     *   *         *   8.0 7 0 0   0 0     0   1   4 4                 8
1830995 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_5 78.0 2.0 6.0   0.0 5.0     0.0   4.0   51.0 44.0     3.0   *     8.0   15.0   95.0 78 2 6   0 5     0   4   51 44     3     8 15   95
1831092 MN Sherburne 71 school 2733510 742 Independent Districts and Schools St. Cloud Public School District 273351001481 16 Clearview Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2020   grade_5 42.0 3.0 6.0   1.0 0.0     0.0   5.0   31.0 26.0     1.0   *     18.0   *   57.0 42 3 6   1 0     0   5   31 26     1     18     57
1831333 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_5 34.0 0.0 2.0   0.0 0.0     0.0   0.0   20.0 16.0     *   *         *   36.0 34 0 2   0 0     0   0   20 16                 36
1831360 MN Wadena 80 school 2732970 820 Independent Districts and Schools Sebeka Public School District 273297001435 1 Sebeka Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2020   grade_5 37.0 1.0 0.0   0.0 0.0     0.0   2.0   24.0 16.0     0.0   *     17.0   10.0   40.0 37 1 0   0 0     0   2   24 16     0     17 10   40
1831911 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_5 11.0 0.0 1.0   0.0 0.0     0.0   1.0   10.0 3.0     *   *         5.0   13.0 11 0 1   0 0     0   1   10 3             5   13
1831921 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_5 5.0 0.0 1.0   1.0 0.0     0.0   1.0   6.0 2.0     *   *         *   8.0 5 0 1   1 0     0   1   6 2                 8
1831990 MN Saint Louis 69 school 2700021 2154 Independent Districts and Schools Eveleth-Gilbert School District 270002100629 20 Nelle Shean Elementary Elementary School (Grades PK-6) Regular School No Middle 05 06 2020   grade_5 48.0 0.0 5.0   0.0 0.0     0.0   4.0   29.0 28.0     *   *     32.0   5.0   57.0 48 0 5   0 0     0   4   29 28           32 5   57
1832135 MN Rock 67 school 2718330 2184 Independent Districts and Schools Luverne Public School District 271833000851 2 Luverne Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2020   grade_5 70.0 0.0 6.0   0.0 0.0     0.0   3.0   43.0 36.0     *   *         *   79.0 70 0 6   0 0     0   3   43 36                 79
1832234 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 06 2020   grade_5 1.0 0.0 1.0   0.0 0.0     0.0   0.0   0.0 2.0     *   *         *   2.0 1 0 1   0 0     0   0   0 2                 2
1832238 MN Sibley 72 school 2718070 2397 Independent Districts and Schools Le Sueur-Henderson School District 271807000046 15 Hilltop Elementary Elementary School (Grades PK-6) Regular School No Elementary 04 05 2020   grade_5 68.0 3.0 13.0   0.0 0.0     0.0   4.0   54.0 34.0     *   *         *   88.0 68 3 13   0 0     0   4   54 34                 88
1832255 MN Norman 54 school 2791448 2527 Independent Districts and Schools Norman County West School District 279144802317 1 Norman County West Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2020   grade_5 7.0 0.0 1.0   0.0 0.0     0.0   0.0   6.0 2.0     *   *         *   8.0 7 0 1   0 0     0   0   6 2                 8
1832311 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_5 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
1832325 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_5 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
1832469 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_5 16.0 0.0 0.0   0.0 0.0     0.0   0.0   8.0 8.0     *   *         *   16.0 16 0 0   0 0     0   0   8 8                 16
1832753 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 2020   grade_5 45.0 43.0 1.0   4.0 1.0     0.0   0.0   44.0 50.0     *   *     53.0   9.0   94.0 45 43 1   4 1     0   0   44 50           53 9   94
1833040 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_5 1.0 3.0 2.0   0.0 0.0     0.0   1.0   5.0 2.0     *   *         *   7.0 1 3 2   0 0     0   1   5 2                 7
1833048 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_5 0.0 14.0 0.0   0.0 0.0     0.0   0.0   6.0 8.0     *   *         *   14.0 0 14 0   0 0     0   0   6 8                 14
1833176 MN Crow Wing 18 school 2700218 4059 Charter Schools Crosslake Community Charter School 270021803475 10 Crosslake Community Charter School Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2020   grade_5 15.0 0.0 0.0   0.0 0.0     0.0   1.0   11.0 5.0     *   *         *   16.0 15 0 0   0 0     0   1   11 5                 16
1833187 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_5 3.0 0.0 0.0   0.0 0.0     0.0   5.0   5.0 3.0     *   *         *   8.0 3 0 0   0 0     0   5   5 3                 8
1833471 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_5 3.0 0.0 0.0   0.0 0.0     0.0   0.0   2.0 1.0     *   *         *   3.0 3 0 0   0 0     0   0   2 1                 3
1833591 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_5 8.0 0.0 0.0   0.0 0.0     0.0   1.0   7.0 2.0     *   *         *   9.0 8 0 0   0 0     0   1   7 2                 9
1833641 MN Washington 82 school 2700310 4187 Charter Schools Natural Science Academy 270031004276 10 Natural Science Academy Elementary School (Grades PK-6) Regular School Yes Elementary KG 05 2020   grade_5 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
1833658 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_5 1.0 5.0 0.0   0.0 0.0     0.0   3.0   5.0 4.0     *   *         *   9.0 1 5 0   0 0     0   3   5 4                 9
1833703 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_5 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
1833977 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_5 0.0 3.0 1.0   0.0 0.0     0.0   1.0   1.0 4.0     *   *         *   5.0 0 3 1   0 0     0   1   1 4                 5
1834006 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_5 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
1834013 MN Beltrami 4 school 2700455 4271 Charter Schools Aurora Waasakone Community of Learners Charter School 270045505196 10 Aurora Waasakone Community of Learners Charter School Elementary School (Grades PK-6) Regular School Yes Elementary KG 06 2020   grade_5 4.0 0.0 1.0   3.0 0.0     0.0   0.0   4.0 4.0     *   *         *   8.0 4 0 1   3 0     0   0   4 4                 8
1834021 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_5 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
1834028 MN Ramsey 62 school 2700458 4275 Charter Schools St. Paul School of Northern Lights 270045805256 10 St. Paul School of Northern Lights Elementary School (Grades PK-6) Regular School Yes Elementary KG 06 2020   grade_5 2.0 1.0 1.0   0.0 0.0     0.0   1.0   4.0 1.0     *   *         *   5.0 2 1 1   0 0     0   1   4 1                 5
1834199 MN Becker 3 school 2710230 22 Independent Districts and Schools Detroit Lakes Public School Dist. 271023000443 4 Detroit Lakes Middle Middle School (Grades 5-8) Regular School No Middle 05 08 2020   grade_5 77.0 0.0 8.0   8.0 0.0     0.0   9.0   44.0 58.0     2.0   *         *   102.0 77 0 8   8 0     0   9   44 58     2           102
1834360 MN Dakota 19 school 2742270 197 Independent Districts and Schools West St. Paul-Mendota Hts.-Eagan 274227002646 52 Friendly Hills Middle Middle School (Grades 5-8) Regular School No Middle 05 08 2020   grade_5 89.0 30.0 42.0   4.0 8.0     0.0   15.0   101.0 87.0     23.0   *         27.0   188.0 89 30 42   4 8     0   15   101 87     23       27   188
1834365 MN Dakota 19 school 2742270 197 Independent Districts and Schools West St. Paul-Mendota Hts.-Eagan 274227001774 54 Heritage E-STEM Magnet School Middle School (Grades 5-8) Regular School No Middle 05 08 2020   grade_5 112.0 12.0 71.0   6.0 4.0     1.0   9.0   107.0 108.0     32.0   *         43.0   215.0 112 12 71   6 4     1   9   107 108     32       43   215
1834512 MN Hubbard 29 school 2728080 309 Independent Districts and Schools Park Rapids Public School District 272808001236 80 Park Rapids Area Century Middle Middle School (Grades 5-8) Regular School No Middle 05 08 2020   grade_5 102.0 0.0 8.0   0.0 0.0     0.0   12.0   60.0 62.0     *   *         *   122.0 102 0 8   0 0     0   12   60 62                 122
1834522 MN Itasca 31 school 2713170 318 Independent Districts and Schools Grand Rapids Public School District 271317000939 370 Robert J. Elkington Middle School Middle School (Grades 5-8) Regular School No Middle 05 08 2020   grade_5 237.0 0.0 4.0   10.0 1.0     0.0   33.0   150.0 135.0     0.0   *     117.0   66.0   285.0 237 0 4   10 1     0   33   150 135     0     117 66   285
1834566 MN Mille Lacs 48 school 2725050 480 Independent Districts and Schools Onamia Public School District 272505005107 50 Onamia Intermediate School Middle School (Grades 5-8) Regular School No Other 03 09 2020   grade_5 9.0 0.0 5.0   22.0 0.0     0.0   3.0   24.0 15.0     *   *         *   39.0 9 0 5   22 0     0   3   24 15                 39
1834597 MN Nicollet 52 school 2733870 508 Independent Districts and Schools St. Peter Public School District 273387002533 80 St. Peter Middle School Middle School (Grades 5-8) Regular School No Middle 05 08 2020   grade_5 111.0 27.0 32.0   1.0 1.0     0.0   6.0   94.0 84.0     *   *         *   178.0 111 27 32   1 1     0   6   94 84                 178
1834635 MN Olmsted 55 school 2731800 535 Independent Districts and Schools Rochester Public School District 273180001020 335 Kellogg Middle Middle School (Grades 5-8) Regular School No Middle 05 08 2020   grade_5 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
1834834 MN Traverse 78 school 2707110 801 Independent Districts and Schools Browns Valley Public School Dist. 270711000280 20 Browns Valley Middle Middle School (Grades 5-8) Regular School No Middle 05 10 2020   grade_5 10.0 0.0 1.0   7.0 0.0     0.0   0.0   11.0 7.0     *   *     10.0   5.0   18.0 10 0 1   7 0     0   0   11 7           10 5   18
1834933 MN Pope 61 school 2700019 2149 Independent Districts and Schools Minnewaska School District 270001903535 60 Minnewaska Area Intermediate School Middle School (Grades 5-8) Regular School No Middle 04 06 2020   grade_5 100.0 0.0 2.0   0.0 0.0     0.0   1.0   53.0 50.0     *   *         *   103.0 100 0 2   0 0     0   1   53 50                 103
1834980 MN Wright 86 school 2700123 2687 Independent Districts and Schools Howard Lake-Waverly-Winsted 270012303350 86 Howard Lake-Waverly-Winsted Middle School Middle School (Grades 5-8) Regular School No Middle 05 08 2020   grade_5 97.0 2.0 2.0   1.0 0.0     0.0   7.0   51.0 58.0     *   *         *   109.0 97 2 2   1 0     0   7   51 58                 109
1834985 MN Pipestone 59 school 2700108 2689 Independent Districts and Schools Pipestone Area School District 270010801264 7 Pipestone Middle Middle School (Grades 5-8) Regular School No Middle 05 08 2020   grade_5 60.0 4.0 12.0   1.0 0.0     0.0   6.0   39.0 44.0     *   *         *   83.0 60 4 12   1 0     0   6   39 44                 83
1835101 MN Hennepin 27 school 2700245 4131 Charter Schools Metro Schools Charter 270024504857 20 Metro Schools Middle Charter Middle School (Grades 5-8) Regular School Yes Middle 05 08 2020   grade_5 0.0 8.0 0.0   0.0 0.0     0.0   0.0   4.0 4.0     *   *         *   8.0 0 8 0   0 0     0   0   4 4                 8
1835115 MN Ramsey 62 school 2700292 4164 Charter Schools Laura Jeffrey Academy Charter 270029203713 10 Laura Jeffrey Academy Charter Middle School (Grades 5-8) Regular School Yes Middle 05 08 2020   grade_5 4.0 2.0 0.0   0.0 1.0     0.0   1.0   1.0 7.0     *   *         *   8.0 4 2 0   0 1     0   1   1 7                 8
1835160 MN Hennepin 27 school 2700444 4263 Charter Schools Progeny Academy Charter School 270044405133 10 Progeny Academy Charter School Middle School (Grades 5-8) Regular School Yes Middle 05 08 2020   grade_5 3.0 1.0 3.0   0.0 0.0     0.0   0.0   4.0 3.0     *   *         *   7.0 3 1 3   0 0     0   0   4 3                 7
1836396 MN Crow Wing 18 school 2706090 181 Independent Districts and Schools Brainerd Public School District 270609002982 21 Middle Level Alternative Program Public Area Learning Center ALC (State approved) Alternative School No Middle 05 08 2020   grade_5 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
1836467 MN Hubbard 29 school 2728080 309 Independent Districts and Schools Park Rapids Public School District 272808004671 81 Century Middle School Within A School Public Area Learning Center ALC (State approved) Alternative School No Middle 05 08 2020   grade_5 7.0 0.0 1.0   0.0 0.0     0.0   1.0   3.0 6.0     *   *         *   9.0 7 0 1   0 0     0   1   3 6                 9
1836974 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_5 2.0 0.0 0.0   0.0 0.0     0.0   0.0   0.0 2.0     *   *         *   2.0 2 0 0   0 0     0   0   0 2                 2
1837013 MN Dakota 19 school 2732390 196 Independent Districts and Schools Rosemount-Apple Valley-Eagan 273239002517 100 Dakota Ridge School Special Education Special Education School No Other KG 12 2020   grade_5 3.0 1.0 0.0   0.0 0.0     0.0   1.0   4.0 1.0     *   *         *   5.0 3 1 0   0 0     0   1   4 1                 5
1837048 MN Hennepin 27 school 2705790 271 Independent Districts and Schools Bloomington Public School District 270579003658 535 Bloomington Shared Time Special Education Special Education School No Other KG 12 2020   grade_5 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
1837109 MN Itasca 31 school 2710140 317 Independent Districts and Schools Deer River Public School District 271014004672 6 Deer River Schools SPED Special Education Special Education School No Elementary KG 05 2020   grade_5 1.0 0.0 0.0   1.0 0.0     0.0   0.0   2.0 0.0     *   *         *   2.0 1 0 0   1 0     0   0   2 0                 2
1837153 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_5 3.0 2.0 1.0   0.0 0.0     0.0   0.0   5.0 1.0     *   *         *   6.0 3 2 1   0 0     0   0   5 1                 6
1837171 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_5 2.0 1.0 0.0   0.0 0.0     0.0   1.0   4.0 0.0     *   *         *   4.0 2 1 0   0 0     0   1   4 0                 4
1837197 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_5 0.0 3.0 1.0   0.0 0.0     0.0   0.0   2.0 2.0     *   *         *   4.0 0 3 1   0 0     0   0   2 2                 4
1837222 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_5 3.0 5.0 0.0   0.0 1.0     0.0   0.0   8.0 1.0     *   *         *   9.0 3 5 0   0 1     0   0   8 1                 9
1837235 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_5 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
1837300 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_5 0.0 1.0 0.0   0.0 0.0     0.0   1.0   2.0 0.0     *   *         *   2.0 0 1 0   0 0     0   1   2 0                 2
1837317 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_5 0.0 2.0 1.0   0.0 0.0     0.0   0.0   3.0 0.0     *   *         *   3.0 0 2 1   0 0     0   0   3 0                 3
1837396 MN Rice 66 school 2700129 160 State Operated Schools (which include MN Academy Deaf & Blind, School for the Arts) Minnesota State Academies 270012903056 1 MN Academy For The Blind Special Education Special Education School No Other PK 12 2020   grade_5 4.0 0.0 0.0   0.0 0.0     0.0   0.0   1.0 3.0     *   *         *   4.0 4 0 0   0 0     0   0   1 3                 4
1837451 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_5 1.0 5.0 0.0   0.0 0.0     0.0   0.0   5.0 1.0     *   *         *   6.0 1 5 0   0 0     0   0   5 1                 6
1837463 MN Hennepin 27 school 2700025 287 Intermediate Districts and Schools Intermediate School District 287 270002503542 479 Safe Special Education Special Education School No Other 01 12 2020   grade_5 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
1837473 MN Hennepin 27 school 2700025 287 Intermediate Districts and Schools Intermediate School District 287 270002503229 480 Strive Secondary Special Education Special Education School No Other 01 12 2020   grade_5 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
1837486 MN Hennepin 27 school 2700025 287 Intermediate Districts and Schools Intermediate School District 287 270002503234 486 CIP Special Education Special Education School No Other 01 12 2020   grade_5 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
1837533 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_5 12.0 5.0 1.0   1.0 2.0     1.0   1.0   20.0 3.0     3.0   *         *   23.0 12 5 1   1 2     1   1   20 3     3           23
1837563 MN Dakota 19 school 2700026 917 Intermediate Districts and Schools Intermediate School District 917 270002602121 51 917 Intra-Dakota Educational Alt Special Education Special Education School No Other KG 12 2020   grade_5 0.0 1.0 0.0   0.0 0.0     0.0   2.0   3.0 0.0     *   *         *   3.0 0 1 0   0 0     0   2   3 0                 3
1837578 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_5 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
1837590 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_5 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
1837628 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_5 3.0 1.0 1.0   0.0 0.0     0.0   0.0   4.0 1.0     *   *         *   5.0 3 1 1   0 0     0   0   4 1                 5

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