Data source: Big Local News · About: Big Local

14,034 rows where state = "MN" and year = 2020 sorted by county descending

View and edit SQL

year

  • 2020 · 14,034
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
1826155 MN Yellow Medicine 87 school 2707470 891 Independent Districts and Schools Canby Public School District 270747000322 10 Canby Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2020   grade_7 55.0 1.0 2.0   0.0 1.0     0.0   1.0   31.0 29.0     0.0   0.0     23.0   6.0   60.0 55 1 2   0 1     0   1   31 29     0 0   23 6   60
1826156 MN Yellow Medicine 87 school 2707470 891 Independent Districts and Schools Canby Public School District 270747000322 10 Canby Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2020   grade_8 42.0 0.0 2.0   0.0 0.0     0.0   1.0   25.0 20.0     0.0   0.0     17.0   7.0   45.0 42 0 2   0 0     0   1   25 20     0 0   17 7   45
1826157 MN Yellow Medicine 87 school 2707470 891 Independent Districts and Schools Canby Public School District 270747000322 10 Canby Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2020   grade_9 42.0 0.0 0.0   0.0 0.0     0.0   1.0   19.0 24.0     0.0   0.0     16.0   5.0   43.0 42 0 0   0 0     0   1   19 24     0 0   16 5   43
1826158 MN Yellow Medicine 87 school 2707470 891 Independent Districts and Schools Canby Public School District 270747000322 10 Canby Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2020   grade_10 51.0 1.0 2.0   0.0 1.0     0.0   0.0   25.0 30.0     0.0   0.0     13.0   8.0   55.0 51 1 2   0 1     0   0   25 30     0 0   13 8   55
1826159 MN Yellow Medicine 87 school 2707470 891 Independent Districts and Schools Canby Public School District 270747000322 10 Canby Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2020   grade_11 35.0 0.0 2.0   0.0 0.0     0.0   1.0   20.0 18.0     0.0   0.0     10.0   4.0   38.0 35 0 2   0 0     0   1   20 18     0 0   10 4   38
1826160 MN Yellow Medicine 87 school 2707470 891 Independent Districts and Schools Canby Public School District 270747000322 10 Canby Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2020   grade_12 36.0 0.0 2.0   0.0 0.0     0.0   1.0   25.0 14.0     0.0   0.0     10.0   4.0   39.0 36 0 2   0 0     0   1   25 14     0 0   10 4   39
1826161 MN Yellow Medicine 87 school 2707470 891 Independent Districts and Schools Canby Public School District 270747000322 10 Canby Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2020   pk_12_total 261.0 2.0 10.0   0.0 2.0     0.0   5.0   145.0 135.0     0.0   0.0     89.0   34.0   280.0 261 2 10   0 2     0   5   145 135     0 0   89 34   280
1831807 MN Yellow Medicine 87 school 2707470 891 Independent Districts and Schools Canby Public School District 270747000321 20 Canby Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2020   early_childhood_special_ed 5.0 0.0 0.0   0.0 0.0     0.0   1.0   5.0 1.0     *   *         *   6.0 5 0 0   0 0     0   1   5 1                 6
1831808 MN Yellow Medicine 87 school 2707470 891 Independent Districts and Schools Canby Public School District 270747000321 20 Canby Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2020   kindergarten 47.0 0.0 1.0   0.0 0.0     0.0   1.0   22.0 27.0     0.0   *     21.0   6.0   49.0 47 0 1   0 0     0   1   22 27     0     21 6   49
1831809 MN Yellow Medicine 87 school 2707470 891 Independent Districts and Schools Canby Public School District 270747000321 20 Canby Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2020   grade_1 34.0 0.0 1.0   0.0 0.0     0.0   3.0   21.0 17.0     0.0   0.0     18.0   2.0   38.0 34 0 1   0 0     0   3   21 17     0 0   18 2   38
1831810 MN Yellow Medicine 87 school 2707470 891 Independent Districts and Schools Canby Public School District 270747000321 20 Canby Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2020   grade_2 40.0 0.0 3.0   1.0 0.0     0.0   0.0   20.0 24.0     *   0.0     21.0   6.0   44.0 40 0 3   1 0     0   0   20 24       0   21 6   44
1831811 MN Yellow Medicine 87 school 2707470 891 Independent Districts and Schools Canby Public School District 270747000321 20 Canby Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2020   grade_3 35.0 2.0 0.0   0.0 0.0     0.0   4.0   19.0 22.0     0.0   0.0     20.0   5.0   41.0 35 2 0   0 0     0   4   19 22     0 0   20 5   41
1831812 MN Yellow Medicine 87 school 2707470 891 Independent Districts and Schools Canby Public School District 270747000321 20 Canby Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2020   grade_4 37.0 0.0 1.0   0.0 0.0     0.0   1.0   17.0 22.0     0.0   0.0         3.0   39.0 37 0 1   0 0     0   1   17 22     0 0     3   39
1831813 MN Yellow Medicine 87 school 2707470 891 Independent Districts and Schools Canby Public School District 270747000321 20 Canby 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   17.0 19.0     0.0   0.0     18.0   8.0   36.0 34 0 2   0 0     0   0   17 19     0 0   18 8   36
1831814 MN Yellow Medicine 87 school 2707470 891 Independent Districts and Schools Canby Public School District 270747000321 20 Canby Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2020   grade_6 52.0 0.0 2.0   0.0 0.0     0.0   1.0   24.0 31.0     0.0   0.0     19.0   8.0   55.0 52 0 2   0 0     0   1   24 31     0 0   19 8   55
1831815 MN Yellow Medicine 87 school 2707470 891 Independent Districts and Schools Canby Public School District 270747000321 20 Canby Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2020   pk_12_total 284.0 2.0 10.0   1.0 0.0     0.0   11.0   145.0 163.0     1.0   0.0     132.0   44.0   308.0 284 2 10   1 0     0   11   145 163     1 0   132 44   308
1832137 MN Yellow Medicine 87 school 2700099 2190 Independent Districts and Schools Yellow Medicine East 270009900676 10 Bert Raney Elementary School Elementary School (Grades PK-6) Regular School No Elementary PK 05 2020   early_childhood_special_ed 11.0 0.0 2.0   4.0 0.0     0.0   1.0   12.0 6.0     0.0   0.0     7.0   *   18.0 11 0 2   4 0     0   1   12 6     0 0   7     18
1832138 MN Yellow Medicine 87 school 2700099 2190 Independent Districts and Schools Yellow Medicine East 270009900676 10 Bert Raney Elementary School Elementary School (Grades PK-6) Regular School No Elementary PK 05 2020   kindergarten 27.0 2.0 2.0   8.0 0.0     0.0   1.0   17.0 23.0     1.0   0.0     23.0   6.0   40.0 27 2 2   8 0     0   1   17 23     1 0   23 6   40
1832139 MN Yellow Medicine 87 school 2700099 2190 Independent Districts and Schools Yellow Medicine East 270009900676 10 Bert Raney Elementary School Elementary School (Grades PK-6) Regular School No Elementary PK 05 2020   grade_1 27.0 0.0 8.0   5.0 0.0     0.0   0.0   17.0 23.0     3.0   0.0     19.0   8.0   40.0 27 0 8   5 0     0   0   17 23     3 0   19 8   40
1832140 MN Yellow Medicine 87 school 2700099 2190 Independent Districts and Schools Yellow Medicine East 270009900676 10 Bert Raney Elementary School Elementary School (Grades PK-6) Regular School No Elementary PK 05 2020   grade_2 32.0 0.0 4.0   8.0 1.0     0.0   0.0   25.0 20.0     1.0   0.0     19.0   14.0   45.0 32 0 4   8 1     0   0   25 20     1 0   19 14   45
1832141 MN Yellow Medicine 87 school 2700099 2190 Independent Districts and Schools Yellow Medicine East 270009900676 10 Bert Raney Elementary School Elementary School (Grades PK-6) Regular School No Elementary PK 05 2020   grade_3 28.0 1.0 7.0   5.0 1.0     0.0   1.0   21.0 22.0     3.0   0.0     20.0   9.0   43.0 28 1 7   5 1     0   1   21 22     3 0   20 9   43
1832142 MN Yellow Medicine 87 school 2700099 2190 Independent Districts and Schools Yellow Medicine East 270009900676 10 Bert Raney Elementary School Elementary School (Grades PK-6) Regular School No Elementary PK 05 2020   grade_4 39.0 1.0 6.0   9.0 1.0     0.0   1.0   38.0 19.0     1.0   0.0     24.0   12.0   57.0 39 1 6   9 1     0   1   38 19     1 0   24 12   57
1832143 MN Yellow Medicine 87 school 2700099 2190 Independent Districts and Schools Yellow Medicine East 270009900676 10 Bert Raney Elementary School Elementary School (Grades PK-6) Regular School No Elementary PK 05 2020   grade_5 34.0 1.0 3.0   10.0 1.0     0.0   2.0   21.0 30.0     1.0   0.0     21.0   14.0   51.0 34 1 3   10 1     0   2   21 30     1 0   21 14   51
1832144 MN Yellow Medicine 87 school 2700099 2190 Independent Districts and Schools Yellow Medicine East 270009900676 10 Bert Raney Elementary School Elementary School (Grades PK-6) Regular School No Elementary PK 05 2020   pk_12_total 198.0 5.0 32.0   49.0 4.0     0.0   6.0   151.0 143.0     10.0   0.0     133.0   81.0   294.0 198 5 32   49 4     0   6   151 143     10 0   133 81   294
1833586 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   kindergarten 10.0 0.0 1.0   0.0 0.0     0.0   0.0   6.0 5.0     0.0   0.0     5.0   1.0   11.0 10 0 1   0 0     0   0   6 5     0 0   5 1   11
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
1833588 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_2 10.0 0.0 1.0   0.0 0.0     0.0   1.0   7.0 5.0     0.0   0.0     7.0   2.0   12.0 10 0 1   0 0     0   1   7 5     0 0   7 2   12
1833589 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_3 4.0 0.0 1.0   0.0 0.0     0.0   2.0   2.0 5.0     *   *         *   7.0 4 0 1   0 0     0   2   2 5                 7
1833590 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_4 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
1833592 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_6 4.0 0.0 1.0   0.0 0.0     0.0   0.0   2.0 3.0     *   *         *   5.0 4 0 1   0 0     0   0   2 3                 5
1833593 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   pk_12_total 44.0 0.0 5.0   1.0 0.0     0.0   4.0   29.0 25.0     0.0   0.0     24.0   8.0   54.0 44 0 5   1 0     0   4   29 25     0 0   24 8   54
1834954 MN Yellow Medicine 87 school 2700099 2190 Independent Districts and Schools Yellow Medicine East 270009904609 23 Yellow Medicine East Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2020   grade_6 47.0 0.0 8.0   9.0 0.0     0.0   2.0   36.0 30.0     1.0   0.0     32.0   17.0   66.0 47 0 8   9 0     0   2   36 30     1 0   32 17   66
1834955 MN Yellow Medicine 87 school 2700099 2190 Independent Districts and Schools Yellow Medicine East 270009904609 23 Yellow Medicine East Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2020   grade_7 35.0 2.0 6.0   10.0 1.0     0.0   0.0   26.0 28.0     0.0   0.0     18.0   14.0   54.0 35 2 6   10 1     0   0   26 28     0 0   18 14   54
1834956 MN Yellow Medicine 87 school 2700099 2190 Independent Districts and Schools Yellow Medicine East 270009904609 23 Yellow Medicine East Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2020   grade_8 31.0 0.0 6.0   10.0 1.0     0.0   3.0   23.0 28.0     1.0   0.0     22.0   8.0   51.0 31 0 6   10 1     0   3   23 28     1 0   22 8   51
1834957 MN Yellow Medicine 87 school 2700099 2190 Independent Districts and Schools Yellow Medicine East 270009904609 23 Yellow Medicine East Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2020   pk_12_total 113.0 2.0 20.0   29.0 2.0     0.0   5.0   85.0 86.0     2.0   0.0     72.0   39.0   171.0 113 2 20   29 2     0   5   85 86     2 0   72 39   171
1835962 MN Yellow Medicine 87 school 2700099 2190 Independent Districts and Schools Yellow Medicine East 270009903539 22 Yellow Medicine East High School Senior High School (Grades 9-12) Regular School No High 09 12 2020   grade_9 46.0 1.0 6.0   10.0 1.0     0.0   2.0   30.0 36.0     2.0   0.0     27.0   7.0   66.0 46 1 6   10 1     0   2   30 36     2 0   27 7   66
1835963 MN Yellow Medicine 87 school 2700099 2190 Independent Districts and Schools Yellow Medicine East 270009903539 22 Yellow Medicine East High School Senior High School (Grades 9-12) Regular School No High 09 12 2020   grade_10 44.0 2.0 4.0   12.0 0.0     0.0   0.0   32.0 30.0     0.0   0.0     24.0   13.0   62.0 44 2 4   12 0     0   0   32 30     0 0   24 13   62
1835964 MN Yellow Medicine 87 school 2700099 2190 Independent Districts and Schools Yellow Medicine East 270009903539 22 Yellow Medicine East High School Senior High School (Grades 9-12) Regular School No High 09 12 2020   grade_11 38.0 0.0 7.0   6.0 0.0     0.0   0.0   30.0 21.0     2.0   0.0     19.0   4.0   51.0 38 0 7   6 0     0   0   30 21     2 0   19 4   51
1835965 MN Yellow Medicine 87 school 2700099 2190 Independent Districts and Schools Yellow Medicine East 270009903539 22 Yellow Medicine East High School Senior High School (Grades 9-12) Regular School No High 09 12 2020   grade_12 28.0 0.0 9.0   4.0 2.0     0.0   0.0   22.0 21.0     6.0   0.0     17.0   8.0   43.0 28 0 9   4 2     0   0   22 21     6 0   17 8   43
1835966 MN Yellow Medicine 87 school 2700099 2190 Independent Districts and Schools Yellow Medicine East 270009903539 22 Yellow Medicine East High School Senior High School (Grades 9-12) Regular School No High 09 12 2020   pk_12_total 156.0 3.0 26.0   32.0 3.0     0.0   2.0   114.0 108.0     10.0   0.0     87.0   32.0   222.0 156 3 26   32 3     0   2   114 108     10 0   87 32   222
1839230 MN Yellow Medicine 87 school 2700139 4026 Charter Schools E.C.H.O. Charter School 270013902718 10 E.C.H.O. Charter School Elementary/Secondary Combined (Grades K-12 limited to District Type 34 Bureau of Indian Education) Regular School Yes Other KG 12 2020   kindergarten 2.0 1.0 1.0   1.0 0.0     0.0   0.0   2.0 3.0     *   *         *   5.0 2 1 1   1 0     0   0   2 3                 5
1839231 MN Yellow Medicine 87 school 2700139 4026 Charter Schools E.C.H.O. Charter School 270013902718 10 E.C.H.O. Charter School Elementary/Secondary Combined (Grades K-12 limited to District Type 34 Bureau of Indian Education) Regular School Yes 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
1839232 MN Yellow Medicine 87 school 2700139 4026 Charter Schools E.C.H.O. Charter School 270013902718 10 E.C.H.O. Charter School Elementary/Secondary Combined (Grades K-12 limited to District Type 34 Bureau of Indian Education) Regular School Yes Other KG 12 2020   grade_2 2.0 0.0 1.0   0.0 0.0     0.0   0.0   1.0 2.0     *   *         *   3.0 2 0 1   0 0     0   0   1 2                 3
1839233 MN Yellow Medicine 87 school 2700139 4026 Charter Schools E.C.H.O. Charter School 270013902718 10 E.C.H.O. Charter School Elementary/Secondary Combined (Grades K-12 limited to District Type 34 Bureau of Indian Education) Regular School Yes Other KG 12 2020   grade_3 0.0 0.0 0.0   2.0 0.0     0.0   0.0   1.0 1.0     *   *         *   2.0 0 0 0   2 0     0   0   1 1                 2
1839234 MN Yellow Medicine 87 school 2700139 4026 Charter Schools E.C.H.O. Charter School 270013902718 10 E.C.H.O. Charter School Elementary/Secondary Combined (Grades K-12 limited to District Type 34 Bureau of Indian Education) Regular School Yes Other KG 12 2020   grade_4 2.0 0.0 0.0   0.0 0.0     0.0   1.0   3.0 0.0     *   *         *   3.0 2 0 0   0 0     0   1   3 0                 3
1839235 MN Yellow Medicine 87 school 2700139 4026 Charter Schools E.C.H.O. Charter School 270013902718 10 E.C.H.O. Charter School Elementary/Secondary Combined (Grades K-12 limited to District Type 34 Bureau of Indian Education) Regular School Yes Other KG 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
1839236 MN Yellow Medicine 87 school 2700139 4026 Charter Schools E.C.H.O. Charter School 270013902718 10 E.C.H.O. Charter School Elementary/Secondary Combined (Grades K-12 limited to District Type 34 Bureau of Indian Education) Regular School Yes Other KG 12 2020   grade_6 3.0 0.0 0.0   1.0 0.0     0.0   1.0   1.0 4.0     *   *         *   5.0 3 0 0   1 0     0   1   1 4                 5
1839237 MN Yellow Medicine 87 school 2700139 4026 Charter Schools E.C.H.O. Charter School 270013902718 10 E.C.H.O. Charter School Elementary/Secondary Combined (Grades K-12 limited to District Type 34 Bureau of Indian Education) Regular School Yes Other KG 12 2020   grade_7 3.0 0.0 0.0   4.0 0.0     0.0   0.0   3.0 4.0     *   *         *   7.0 3 0 0   4 0     0   0   3 4                 7
1839238 MN Yellow Medicine 87 school 2700139 4026 Charter Schools E.C.H.O. Charter School 270013902718 10 E.C.H.O. Charter School Elementary/Secondary Combined (Grades K-12 limited to District Type 34 Bureau of Indian Education) Regular School Yes Other KG 12 2020   grade_8 5.0 0.0 1.0   0.0 0.0     0.0   2.0   5.0 3.0     *   *         *   8.0 5 0 1   0 0     0   2   5 3                 8
1839239 MN Yellow Medicine 87 school 2700139 4026 Charter Schools E.C.H.O. Charter School 270013902718 10 E.C.H.O. Charter School Elementary/Secondary Combined (Grades K-12 limited to District Type 34 Bureau of Indian Education) Regular School Yes Other KG 12 2020   grade_9 3.0 0.0 0.0   0.0 0.0     0.0   1.0   1.0 3.0     *   *         *   4.0 3 0 0   0 0     0   1   1 3                 4
1839240 MN Yellow Medicine 87 school 2700139 4026 Charter Schools E.C.H.O. Charter School 270013902718 10 E.C.H.O. Charter School Elementary/Secondary Combined (Grades K-12 limited to District Type 34 Bureau of Indian Education) Regular School Yes Other KG 12 2020   grade_10 5.0 1.0 1.0   0.0 0.0     0.0   1.0   3.0 5.0     *   *         *   8.0 5 1 1   0 0     0   1   3 5                 8
1839241 MN Yellow Medicine 87 school 2700139 4026 Charter Schools E.C.H.O. Charter School 270013902718 10 E.C.H.O. Charter School Elementary/Secondary Combined (Grades K-12 limited to District Type 34 Bureau of Indian Education) Regular School Yes Other KG 12 2020   grade_11 2.0 0.0 0.0   2.0 0.0     0.0   0.0   2.0 2.0     *   *         *   4.0 2 0 0   2 0     0   0   2 2                 4
1839242 MN Yellow Medicine 87 school 2700139 4026 Charter Schools E.C.H.O. Charter School 270013902718 10 E.C.H.O. Charter School Elementary/Secondary Combined (Grades K-12 limited to District Type 34 Bureau of Indian Education) Regular School Yes Other KG 12 2020   grade_12 6.0 0.0 1.0   0.0 0.0     0.0   0.0   2.0 5.0     *   *         *   7.0 6 0 1   0 0     0   0   2 5                 7
1839243 MN Yellow Medicine 87 school 2700139 4026 Charter Schools E.C.H.O. Charter School 270013902718 10 E.C.H.O. Charter School Elementary/Secondary Combined (Grades K-12 limited to District Type 34 Bureau of Indian Education) Regular School Yes Other KG 12 2020   pk_12_total 37.0 2.0 5.0   10.0 0.0     0.0   6.0   27.0 33.0     0.0   0.0     36.0   18.0   60.0 37 2 5   10 0     0   6   27 33     0 0   36 18   60
1826141 MN Wright 86 school 2710170 879 Independent Districts and Schools Delano Public School District 271017000438 20 Delano High School Secondary School (Grades 7-12) Regular School No High 07 12 2020   grade_7 200.0 2.0 3.0   0.0 4.0     0.0   2.0   104.0 107.0     4.0   0.0     21.0   21.0   211.0 200 2 3   0 4     0   2   104 107     4 0   21 21   211
1826142 MN Wright 86 school 2710170 879 Independent Districts and Schools Delano Public School District 271017000438 20 Delano High School Secondary School (Grades 7-12) Regular School No High 07 12 2020   grade_8 179.0 0.0 3.0   0.0 0.0     0.0   9.0   95.0 96.0     1.0   0.0     20.0   22.0   191.0 179 0 3   0 0     0   9   95 96     1 0   20 22   191
1826143 MN Wright 86 school 2710170 879 Independent Districts and Schools Delano Public School District 271017000438 20 Delano High School Secondary School (Grades 7-12) Regular School No High 07 12 2020   grade_9 199.0 0.0 2.0   0.0 2.0     0.0   6.0   91.0 118.0     2.0   0.0     21.0   20.0   209.0 199 0 2   0 2     0   6   91 118     2 0   21 20   209
1826144 MN Wright 86 school 2710170 879 Independent Districts and Schools Delano Public School District 271017000438 20 Delano High School Secondary School (Grades 7-12) Regular School No High 07 12 2020   grade_10 194.0 0.0 6.0   1.0 0.0     0.0   9.0   119.0 91.0     1.0   0.0     21.0   27.0   210.0 194 0 6   1 0     0   9   119 91     1 0   21 27   210
1826145 MN Wright 86 school 2710170 879 Independent Districts and Schools Delano Public School District 271017000438 20 Delano High School Secondary School (Grades 7-12) Regular School No High 07 12 2020   grade_11 176.0 1.0 5.0   0.0 2.0     0.0   3.0   101.0 86.0     0.0   0.0     13.0   23.0   187.0 176 1 5   0 2     0   3   101 86     0 0   13 23   187
1826146 MN Wright 86 school 2710170 879 Independent Districts and Schools Delano Public School District 271017000438 20 Delano High School Secondary School (Grades 7-12) Regular School No High 07 12 2020   grade_12 174.0 2.0 3.0   1.0 3.0     0.0   3.0   91.0 95.0     0.0   0.0     12.0   17.0   186.0 174 2 3   1 3     0   3   91 95     0 0   12 17   186
1826147 MN Wright 86 school 2710170 879 Independent Districts and Schools Delano Public School District 271017000438 20 Delano High School Secondary School (Grades 7-12) Regular School No High 07 12 2020   pk_12_total 1122.0 5.0 22.0   2.0 11.0     0.0   32.0   601.0 593.0     8.0   0.0     108.0   130.0   1194.0 1122 5 22   2 11     0   32   601 593     8 0   108 130   1194
1826148 MN Wright 86 school 2718810 881 Independent Districts and Schools Maple Lake Public School District 271881000886 20 Maple Lake Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2020   grade_7 54.0 0.0 0.0   0.0 0.0     0.0   0.0   32.0 22.0     0.0   0.0     11.0   9.0   54.0 54 0 0   0 0     0   0   32 22     0 0   11 9   54
1826149 MN Wright 86 school 2718810 881 Independent Districts and Schools Maple Lake Public School District 271881000886 20 Maple Lake Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2020   grade_8 57.0 0.0 2.0   0.0 0.0     0.0   2.0   34.0 27.0     0.0   0.0     12.0   10.0   61.0 57 0 2   0 0     0   2   34 27     0 0   12 10   61
1826150 MN Wright 86 school 2718810 881 Independent Districts and Schools Maple Lake Public School District 271881000886 20 Maple Lake Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2020   grade_9 64.0 0.0 2.0   0.0 0.0     1.0   1.0   37.0 31.0     0.0   0.0     15.0   12.0   68.0 64 0 2   0 0     1   1   37 31     0 0   15 12   68
1826151 MN Wright 86 school 2718810 881 Independent Districts and Schools Maple Lake Public School District 271881000886 20 Maple Lake Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2020   grade_10 85.0 0.0 1.0   0.0 0.0     0.0   2.0   37.0 51.0     0.0   0.0     16.0   9.0   88.0 85 0 1   0 0     0   2   37 51     0 0   16 9   88
1826152 MN Wright 86 school 2718810 881 Independent Districts and Schools Maple Lake Public School District 271881000886 20 Maple Lake Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2020   grade_11 73.0 0.0 1.0   0.0 0.0     0.0   2.0   39.0 37.0     1.0   0.0     11.0   12.0   76.0 73 0 1   0 0     0   2   39 37     1 0   11 12   76
1826153 MN Wright 86 school 2718810 881 Independent Districts and Schools Maple Lake Public School District 271881000886 20 Maple Lake Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2020   grade_12 66.0 3.0 2.0   0.0 0.0     1.0   0.0   41.0 31.0     0.0   0.0     7.0   5.0   72.0 66 3 2   0 0     1   0   41 31     0 0   7 5   72
1826154 MN Wright 86 school 2718810 881 Independent Districts and Schools Maple Lake Public School District 271881000886 20 Maple Lake Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2020   pk_12_total 399.0 3.0 8.0   0.0 0.0     2.0   7.0   220.0 199.0     1.0   0.0     72.0   57.0   419.0 399 3 8   0 0     2   7   220 199     1 0   72 57   419
1826755 MN Wright 86 school 2700403 4229 Charter Schools Jane Goodall Environmental Science Academy 270040304850 10 Jane Goodall Environmental Science Academy Secondary School (Grades 7-12) Regular School Yes High 06 12 2020   grade_6 11.0 0.0 0.0   0.0 0.0     0.0   0.0   7.0 4.0     *   *     5.0   *   11.0 11 0 0   0 0     0   0   7 4           5     11
1826756 MN Wright 86 school 2700403 4229 Charter Schools Jane Goodall Environmental Science Academy 270040304850 10 Jane Goodall Environmental Science Academy Secondary School (Grades 7-12) Regular School Yes High 06 12 2020   grade_7 13.0 0.0 0.0   0.0 0.0     0.0   0.0   7.0 6.0     0.0   0.0     3.0   2.0   13.0 13 0 0   0 0     0   0   7 6     0 0   3 2   13
1826757 MN Wright 86 school 2700403 4229 Charter Schools Jane Goodall Environmental Science Academy 270040304850 10 Jane Goodall Environmental Science Academy Secondary School (Grades 7-12) Regular School Yes High 06 12 2020   grade_8 18.0 0.0 2.0   0.0 0.0     0.0   0.0   14.0 6.0     0.0   0.0     5.0   9.0   20.0 18 0 2   0 0     0   0   14 6     0 0   5 9   20
1826758 MN Wright 86 school 2700403 4229 Charter Schools Jane Goodall Environmental Science Academy 270040304850 10 Jane Goodall Environmental Science Academy Secondary School (Grades 7-12) Regular School Yes High 06 12 2020   grade_9 11.0 0.0 0.0   0.0 0.0     0.0   1.0   10.0 2.0     0.0   0.0     0.0   7.0   12.0 11 0 0   0 0     0   1   10 2     0 0   0 7   12
1826759 MN Wright 86 school 2700403 4229 Charter Schools Jane Goodall Environmental Science Academy 270040304850 10 Jane Goodall Environmental Science Academy Secondary School (Grades 7-12) Regular School Yes High 06 12 2020   grade_10 17.0 0.0 0.0   0.0 0.0     0.0   0.0   12.0 5.0     0.0   0.0     3.0   5.0   17.0 17 0 0   0 0     0   0   12 5     0 0   3 5   17
1826760 MN Wright 86 school 2700403 4229 Charter Schools Jane Goodall Environmental Science Academy 270040304850 10 Jane Goodall Environmental Science Academy Secondary School (Grades 7-12) Regular School Yes High 06 12 2020   grade_11 13.0 0.0 0.0   0.0 0.0     0.0   0.0   7.0 6.0     0.0   0.0         5.0   13.0 13 0 0   0 0     0   0   7 6     0 0     5   13
1826761 MN Wright 86 school 2700403 4229 Charter Schools Jane Goodall Environmental Science Academy 270040304850 10 Jane Goodall Environmental Science Academy Secondary School (Grades 7-12) Regular School Yes High 06 12 2020   grade_12 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
1826762 MN Wright 86 school 2700403 4229 Charter Schools Jane Goodall Environmental Science Academy 270040304850 10 Jane Goodall Environmental Science Academy Secondary School (Grades 7-12) Regular School Yes High 06 12 2020   pk_12_total 90.0 0.0 2.0   0.0 0.0     0.0   1.0   61.0 32.0     0.0   0.0     18.0   32.0   93.0 90 0 2   0 0     0   1   61 32     0 0   18 32   93
1829428 MN Wright 86 school 2710060 466 Independent Districts and Schools Dassel-Cokato Public School Dist. 271006000426 1 Cokato Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 04 2020   early_childhood_special_ed 13.0 0.0 0.0   0.0 0.0     0.0   0.0   10.0 3.0     0.0   0.0     6.0   *   13.0 13 0 0   0 0     0   0   10 3     0 0   6     13
1829429 MN Wright 86 school 2710060 466 Independent Districts and Schools Dassel-Cokato Public School Dist. 271006000426 1 Cokato Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 04 2020   kindergarten 95.0 1.0 3.0   0.0 0.0     0.0   2.0   55.0 46.0     1.0   0.0     29.0   16.0   101.0 95 1 3   0 0     0   2   55 46     1 0   29 16   101
1829430 MN Wright 86 school 2710060 466 Independent Districts and Schools Dassel-Cokato Public School Dist. 271006000426 1 Cokato Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 04 2020   grade_1 69.0 0.0 4.0   0.0 0.0     0.0   4.0   46.0 31.0     1.0   0.0     19.0   14.0   77.0 69 0 4   0 0     0   4   46 31     1 0   19 14   77
1829431 MN Wright 86 school 2710060 466 Independent Districts and Schools Dassel-Cokato Public School Dist. 271006000426 1 Cokato Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 04 2020   grade_2 78.0 1.0 5.0   0.0 0.0     0.0   5.0   40.0 49.0     0.0   0.0     32.0   13.0   89.0 78 1 5   0 0     0   5   40 49     0 0   32 13   89
1829432 MN Wright 86 school 2710060 466 Independent Districts and Schools Dassel-Cokato Public School Dist. 271006000426 1 Cokato Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 04 2020   grade_3 82.0 0.0 2.0   0.0 0.0     0.0   1.0   39.0 46.0     1.0   1.0     21.0   12.0   85.0 82 0 2   0 0     0   1   39 46     1 1   21 12   85
1829433 MN Wright 86 school 2710060 466 Independent Districts and Schools Dassel-Cokato Public School Dist. 271006000426 1 Cokato Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 04 2020   grade_4 88.0 0.0 4.0   0.0 0.0     0.0   6.0   44.0 54.0     1.0   0.0     24.0   18.0   98.0 88 0 4   0 0     0   6   44 54     1 0   24 18   98
1829434 MN Wright 86 school 2710060 466 Independent Districts and Schools Dassel-Cokato Public School Dist. 271006000426 1 Cokato Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 04 2020   pk_12_total 425.0 2.0 18.0   0.0 0.0     0.0   18.0   234.0 229.0     4.0   1.0     131.0   86.0   463.0 425 2 18   0 0     0   18   234 229     4 1   131 86   463
1831018 MN Wright 86 school 2711370 728 Independent Districts and Schools Elk River School District 271137004932 180 Prairie View Elementary School Elementary School (Grades PK-6) Regular School No Elementary KG 05 2020   kindergarten 97.0 7.0 5.0   1.0 4.0     0.0   6.0   60.0 60.0     7.0   0.0     13.0   20.0   120.0 97 7 5   1 4     0   6   60 60     7 0   13 20   120
1831019 MN Wright 86 school 2711370 728 Independent Districts and Schools Elk River School District 271137004932 180 Prairie View Elementary School Elementary School (Grades PK-6) Regular School No Elementary KG 05 2020   grade_1 99.0 5.0 0.0   1.0 1.0     0.0   6.0   58.0 54.0     1.0   0.0         20.0   112.0 99 5 0   1 1     0   6   58 54     1 0     20   112
1831020 MN Wright 86 school 2711370 728 Independent Districts and Schools Elk River School District 271137004932 180 Prairie View Elementary School Elementary School (Grades PK-6) Regular School No Elementary KG 05 2020   grade_2 88.0 8.0 2.0   0.0 3.0     0.0   10.0   54.0 57.0     5.0   0.0     8.0   20.0   111.0 88 8 2   0 3     0   10   54 57     5 0   8 20   111
1831021 MN Wright 86 school 2711370 728 Independent Districts and Schools Elk River School District 271137004932 180 Prairie View Elementary School Elementary School (Grades PK-6) Regular School No Elementary KG 05 2020   grade_3 85.0 3.0 1.0   1.0 1.0     0.0   6.0   48.0 49.0     2.0   0.0     11.0   22.0   97.0 85 3 1   1 1     0   6   48 49     2 0   11 22   97
1831022 MN Wright 86 school 2711370 728 Independent Districts and Schools Elk River School District 271137004932 180 Prairie View Elementary School Elementary School (Grades PK-6) Regular School No Elementary KG 05 2020   grade_4 65.0 7.0 3.0   0.0 1.0     0.0   4.0   38.0 42.0     2.0   0.0     11.0   9.0   80.0 65 7 3   0 1     0   4   38 42     2 0   11 9   80
1831023 MN Wright 86 school 2711370 728 Independent Districts and Schools Elk River School District 271137004932 180 Prairie View Elementary School Elementary School (Grades PK-6) Regular School No Elementary KG 05 2020   grade_5 66.0 5.0 5.0   1.0 4.0     0.0   8.0   41.0 48.0     6.0   0.0         15.0   89.0 66 5 5   1 4     0   8   41 48     6 0     15   89
1831024 MN Wright 86 school 2711370 728 Independent Districts and Schools Elk River School District 271137004932 180 Prairie View Elementary School Elementary School (Grades PK-6) Regular School No Elementary KG 05 2020   pk_12_total 500.0 35.0 16.0   4.0 14.0     0.0   40.0   299.0 310.0     23.0   0.0     55.0   106.0   609.0 500 35 16   4 14     0   40   299 310     23 0   55 106   609
1831047 MN Wright 86 school 2711370 728 Independent Districts and Schools Elk River School District 271137002557 800 Otsego Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2020   kindergarten 91.0 6.0 10.0   0.0 0.0     0.0   4.0   51.0 60.0     8.0   0.0     16.0   21.0   111.0 91 6 10   0 0     0   4   51 60     8 0   16 21   111
1831048 MN Wright 86 school 2711370 728 Independent Districts and Schools Elk River School District 271137002557 800 Otsego Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2020   grade_1 103.0 1.0 2.0   0.0 4.0     0.0   7.0   55.0 62.0     4.0   0.0     20.0   17.0   117.0 103 1 2   0 4     0   7   55 62     4 0   20 17   117
1831049 MN Wright 86 school 2711370 728 Independent Districts and Schools Elk River School District 271137002557 800 Otsego Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2020   grade_2 76.0 3.0 11.0   0.0 4.0     0.0   9.0   57.0 46.0     10.0   0.0     22.0   9.0   103.0 76 3 11   0 4     0   9   57 46     10 0   22 9   103
1831050 MN Wright 86 school 2711370 728 Independent Districts and Schools Elk River School District 271137002557 800 Otsego Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2020   grade_3 94.0 5.0 2.0   0.0 0.0     0.0   5.0   55.0 51.0     3.0   0.0     13.0   15.0   106.0 94 5 2   0 0     0   5   55 51     3 0   13 15   106
1831051 MN Wright 86 school 2711370 728 Independent Districts and Schools Elk River School District 271137002557 800 Otsego Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2020   grade_4 93.0 3.0 7.0   0.0 2.0     0.0   6.0   59.0 52.0     5.0   0.0     20.0   18.0   111.0 93 3 7   0 2     0   6   59 52     5 0   20 18   111
1831052 MN Wright 86 school 2711370 728 Independent Districts and Schools Elk River School District 271137002557 800 Otsego Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2020   grade_5 82.0 3.0 7.0   0.0 4.0     0.0   8.0   50.0 54.0     5.0   0.0     21.0   14.0   104.0 82 3 7   0 4     0   8   50 54     5 0   21 14   104
1831053 MN Wright 86 school 2711370 728 Independent Districts and Schools Elk River School District 271137002557 800 Otsego Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2020   pk_12_total 539.0 21.0 39.0   0.0 14.0     0.0   39.0   327.0 325.0     35.0   0.0     112.0   94.0   652.0 539 21 39   0 14     0   39   327 325     35 0   112 94   652
1831702 MN Wright 86 school 2703150 876 Independent Districts and Schools Annandale Public School District 270315000094 1 Annandale Elementary School Elementary School (Grades PK-6) Regular School No Elementary PK 05 2020   early_childhood_special_ed 25.0 0.0 0.0   0.0 0.0     0.0   0.0   13.0 12.0     0.0   0.0     8.0   *   25.0 25 0 0   0 0     0   0   13 12     0 0   8     25
1831703 MN Wright 86 school 2703150 876 Independent Districts and Schools Annandale Public School District 270315000094 1 Annandale Elementary School Elementary School (Grades PK-6) Regular School No Elementary PK 05 2020   kindergarten 154.0 0.0 3.0   0.0 1.0     0.0   6.0   82.0 82.0     2.0   0.0     33.0   41.0   164.0 154 0 3   0 1     0   6   82 82     2 0   33 41   164

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