Data source: Big Local News · About: Big Local

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

View and edit SQL

year

  • 2021 · 13,914
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
1712577 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 2021   grade_7 57 0 1   0 0     0   2   26 34     0.0   0.0     22.0   9.0   60 57 0 1   0 0     0   2   26 34     0 0   22 9   60
1712578 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 2021   grade_8 54 1 3   0 1     0   1   31 29     1.0   0.0     21.0   8.0   60 54 1 3   0 1     0   1   31 29     1 0   21 8   60
1712579 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 2021   grade_9 43 0 1   0 0     0   0   23 21     0.0   0.0     14.0   8.0   44 43 0 1   0 0     0   0   23 21     0 0   14 8   44
1712580 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 2021   grade_10 39 0 1   0 0     0   1   18 23     1.0   0.0     15.0   5.0   41 39 0 1   0 0     0   1   18 23     1 0   15 5   41
1712581 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 2021   grade_11 51 1 1   0 1     0   0   24 30     0.0   0.0     12.0   6.0   54 51 1 1   0 1     0   0   24 30     0 0   12 6   54
1712582 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 2021   grade_12 33 0 1   0 0     0   0   17 17     0.0   0.0     8.0   4.0   34 33 0 1   0 0     0   0   17 17     0 0   8 4   34
1712583 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 2021   pk_12_total 277 2 8   0 2     0   4   139 154     2.0   0.0     92.0   40.0   293 277 2 8   0 2     0   4   139 154     2 0   92 40   293
1718242 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 2021   early_childhood_special_ed 6 0 1   0 0     0   0   7 0     *   *     *   *   7 6 0 1   0 0     0   0   7 0                 7
1718243 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 2021   kindergarten 33 0 2   0 0     0   1   22 14     0.0   *     *   4.0   36 33 0 2   0 0     0   1   22 14     0       4   36
1718244 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 2021   grade_1 36 0 0   0 0     0   2   19 19     0.0   0.0     14.0   4.0   38 36 0 0   0 0     0   2   19 19     0 0   14 4   38
1718245 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 2021   grade_2 33 0 0   0 0     0   3   20 16     0.0   0.0     14.0   3.0   36 33 0 0   0 0     0   3   20 16     0 0   14 3   36
1718246 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 2021   grade_3 42 0 4   0 0     0   2   20 28     *   0.0     22.0   6.0   48 42 0 4   0 0     0   2   20 28       0   22 6   48
1718247 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 2021   grade_4 33 0 1   0 0     0   4   17 21     0.0   0.0     16.0   4.0   38 33 0 1   0 0     0   4   17 21     0 0   16 4   38
1718248 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 2021   grade_5 35 0 1   0 0     0   1   15 22     0.0   0.0     13.0   3.0   37 35 0 1   0 0     0   1   15 22     0 0   13 3   37
1718249 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 2021   grade_6 29 0 4   0 0     0   1   16 18     0.0   0.0     17.0   8.0   34 29 0 4   0 0     0   1   16 18     0 0   17 8   34
1718250 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 2021   pk_12_total 247 0 13   0 0     0   14   136 138     1.0   0.0     113.0   39.0   274 247 0 13   0 0     0   14   136 138     1 0   113 39   274
1718560 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 2021   early_childhood_special_ed 11 0 2   9 0     0   0   13 9     0.0   0.0     13.0   *   22 11 0 2   9 0     0   0   13 9     0 0   13     22
1718561 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 2021   kindergarten 31 0 11   0 0     0   0   29 13     0.0   0.0     16.0   4.0   42 31 0 11   0 0     0   0   29 13     0 0   16 4   42
1718562 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 2021   grade_1 27 1 0   9 0     0   0   14 23     0.0   0.0     18.0   5.0   37 27 1 0   9 0     0   0   14 23     0 0   18 5   37
1718563 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 2021   grade_2 24 1 8   4 0     0   0   15 22     4.0   0.0     20.0   9.0   37 24 1 8   4 0     0   0   15 22     4 0   20 9   37
1718564 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 2021   grade_3 30 0 5   8 1     0   1   27 18     2.0   0.0     15.0   13.0   45 30 0 5   8 1     0   1   27 18     2 0   15 13   45
1718565 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 2021   grade_4 27 0 6   5 1     0   2   19 22     2.0   0.0     20.0   11.0   41 27 0 6   5 1     0   2   19 22     2 0   20 11   41
1718566 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 2021   grade_5 35 1 8   8 1     0   3   36 20     2.0   0.0     21.0   13.0   56 35 1 8   8 1     0   3   36 20     2 0   21 13   56
1718567 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 2021   pk_12_total 185 3 40   43 3     0   6   153 127     10.0   0.0     123.0   77.0   280 185 3 40   43 3     0   6   153 127     10 0   123 77   280
1720035 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 2021   kindergarten 12 0 0   0 0     0   1   4 9     0.0   0.0     4.0   0.0   13 12 0 0   0 0     0   1   4 9     0 0   4 0   13
1720036 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 2021   grade_1 7 0 1   0 0     0   0   3 5     *   *     *   *   8 7 0 1   0 0     0   0   3 5                 8
1720037 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 2021   grade_2 5 0 0   1 0     0   0   3 3     *   *     *   *   6 5 0 0   1 0     0   0   3 3                 6
1720038 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 2021   grade_3 10 0 1   0 0     0   0   6 5     0.0   0.0     7.0   1.0   11 10 0 1   0 0     0   0   6 5     0 0   7 1   11
1720039 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 2021   grade_4 2 0 0   0 0     0   1   0 3     *   *     *   *   3 2 0 0   0 0     0   1   0 3                 3
1720040 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 2021   grade_5 1 0 0   0 0     0   0   1 0     *   *     *   *   1 1 0 0   0 0     0   0   1 0                 1
1720041 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 2021   grade_6 3 0 0   0 0     0   1   3 1     *   *     *   *   4 3 0 0   0 0     0   1   3 1                 4
1720042 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 2021   pk_12_total 40 0 2   1 0     0   3   20 26     0.0   0.0     22.0   4.0   46 40 0 2   1 0     0   3   20 26     0 0   22 4   46
1721434 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 2021   grade_6 32 0 2   9 1     0   1   19 26     1.0   0.0     14.0   13.0   45 32 0 2   9 1     0   1   19 26     1 0   14 13   45
1721435 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 2021   grade_7 41 0 9   8 0     0   2   34 26     1.0   0.0     26.0   15.0   60 41 0 9   8 0     0   2   34 26     1 0   26 15   60
1721436 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 2021   grade_8 35 1 9   7 1     0   0   26 27     0.0   0.0     11.0   12.0   53 35 1 9   7 1     0   0   26 27     0 0   11 12   53
1721437 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 2021   pk_12_total 108 1 20   24 2     0   3   79 79     2.0   0.0     51.0   40.0   158 108 1 20   24 2     0   3   79 79     2 0   51 40   158
1722461 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 2021   grade_9 25 0 4   10 2     0   3   20 24     1.0   0.0     12.0   6.0   44 25 0 4   10 2     0   3   20 24     1 0   12 6   44
1722462 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 2021   grade_10 42 0 8   11 0     0   4   31 34     2.0   0.0     25.0   8.0   65 42 0 8   11 0     0   4   31 34     2 0   25 8   65
1722463 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 2021   grade_11 44 1 6   10 0     0   0   34 27     0.0   0.0     16.0   13.0   61 44 1 6   10 0     0   0   34 27     0 0   16 13   61
1722464 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 2021   grade_12 34 0 6   7 0     0   1   30 18     2.0   0.0     9.0   5.0   48 34 0 6   7 0     0   1   30 18     2 0   9 5   48
1722465 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 2021   pk_12_total 145 1 24   38 2     0   8   115 103     5.0   0.0     62.0   32.0   218 145 1 24   38 2     0   8   115 103     5 0   62 32   218
1725539 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 2021   kindergarten 3 1 0   0 0     0   0   2 2     *   *     *   *   4 3 1 0   0 0     0   0   2 2                 4
1725540 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 2021   grade_1 2 1 1   1 0     0   0   2 3     *   *     *   *   5 2 1 1   1 0     0   0   2 3                 5
1725541 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 2021   grade_2 1 0 0   0 0     0   0   0 1     *   *     *   *   1 1 0 0   0 0     0   0   0 1                 1
1725542 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 2021   grade_3 2 0 1   0 0     0   0   1 2     *   *     *   *   3 2 0 1   0 0     0   0   1 2                 3
1725543 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 2021   grade_4 2 0 0   1 0     0   0   0 3     *   *     *   *   3 2 0 0   1 0     0   0   0 3                 3
1725544 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 2021   grade_5 4 0 0   0 0     0   1   4 1     *   *     *   *   5 4 0 0   0 0     0   1   4 1                 5
1725545 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 2021   grade_6 3 0 0   0 0     0   0   3 0     *   *     *   *   3 3 0 0   0 0     0   0   3 0                 3
1725546 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 2021   grade_7 9 0 0   1 0     0   1   4 7     0.0   0.0     9.0   2.0   11 9 0 0   1 0     0   1   4 7     0 0   9 2   11
1725547 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 2021   grade_8 4 0 0   5 1     0   0   4 6     0.0   0.0     6.0   3.0   10 4 0 0   5 1     0   0   4 6     0 0   6 3   10
1725548 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 2021   grade_9 5 0 1   1 0     0   1   5 3     *   *     *   *   8 5 0 1   1 0     0   1   5 3                 8
1725549 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 2021   grade_10 5 0 2   0 0     0   1   3 5     *   *     *   *   8 5 0 2   0 0     0   1   3 5                 8
1725550 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 2021   grade_11 4 0 0   1 0     0   1   2 4     *   *     *   *   6 4 0 0   1 0     0   1   2 4                 6
1725551 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 2021   grade_12 1 0 0   1 0     0   0   2 0     *   *     *   *   2 1 0 0   1 0     0   0   2 0                 2
1725552 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 2021   pk_12_total 45 2 5   11 1     0   5   32 37     1.0   0.0     50.0   21.0   69 45 2 5   11 1     0   5   32 37     1 0   50 21   69
1712563 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 2021   grade_7 200 1 8   0 0     0   9   114 104     3.0   0.0     16.0   23.0   218 200 1 8   0 0     0   9   114 104     3 0   16 23   218
1712564 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 2021   grade_8 191 1 5   0 4     0   3   99 105     4.0   0.0     13.0   18.0   204 191 1 5   0 4     0   3   99 105     4 0   13 18   204
1712565 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 2021   grade_9 180 0 3   0 0     0   10   97 96     2.0   0.0     12.0   21.0   193 180 0 3   0 0     0   10   97 96     2 0   12 21   193
1712566 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 2021   grade_10 199 0 2   0 2     0   7   96 114     2.0   0.0     12.0   22.0   210 199 0 2   0 2     0   7   96 114     2 0   12 22   210
1712567 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 2021   grade_11 187 0 6   0 0     0   10   111 92     1.0   0.0     11.0   26.0   203 187 0 6   0 0     0   10   111 92     1 0   11 26   203
1712568 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 2021   grade_12 174 1 5   0 2     0   3   104 81     0.0   0.0     9.0   24.0   185 174 1 5   0 2     0   3   104 81     0 0   9 24   185
1712569 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 2021   pk_12_total 1131 3 29   0 8     0   42   621 592     12.0   0.0     73.0   134.0   1213 1131 3 29   0 8     0   42   621 592     12 0   73 134   1213
1712570 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 2021   grade_7 65 1 1   0 0     0   2   36 33     1.0   0.0     11.0   14.0   69 65 1 1   0 0     0   2   36 33     1 0   11 14   69
1712571 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 2021   grade_8 53 0 0   0 0     0   0   29 24     0.0   0.0     7.0   7.0   53 53 0 0   0 0     0   0   29 24     0 0   7 7   53
1712572 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 2021   grade_9 57 0 2   0 0     0   1   37 23     0.0   0.0     12.0   10.0   60 57 0 2   0 0     0   1   37 23     0 0   12 10   60
1712573 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 2021   grade_10 61 0 1   0 0     1   1   37 27     0.0   0.0     11.0   12.0   64 61 0 1   0 0     1   1   37 27     0 0   11 12   64
1712574 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 2021   grade_11 80 0 1   0 0     0   2   32 51     0.0   0.0     10.0   9.0   83 80 0 1   0 0     0   2   32 51     0 0   10 9   83
1712575 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 2021   grade_12 70 0 0   0 0     0   2   37 35     1.0   0.0     13.0   10.0   72 70 0 0   0 0     0   2   37 35     1 0   13 10   72
1712576 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 2021   pk_12_total 386 1 5   0 0     1   8   208 193     2.0   0.0     64.0   62.0   401 386 1 5   0 0     1   8   208 193     2 0   64 62   401
1713185 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 2021   grade_6 12 0 0   0 0     0   0   9 3     *   *     *   6.0   12 12 0 0   0 0     0   0   9 3             6   12
1713186 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 2021   grade_7 9 0 0   0 0     0   0   4 5     *   *     *   *   9 9 0 0   0 0     0   0   4 5                 9
1713187 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 2021   grade_8 15 0 0   0 0     0   0   11 4     0.0   0.0     1.0   *   15 15 0 0   0 0     0   0   11 4     0 0   1     15
1713188 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 2021   grade_9 24 0 2   0 0     0   0   12 14     0.0   0.0     3.0   8.0   26 24 0 2   0 0     0   0   12 14     0 0   3 8   26
1713189 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 2021   grade_10 11 1 0   0 0     0   1   11 2     0.0   0.0     2.0   8.0   13 11 1 0   0 0     0   1   11 2     0 0   2 8   13
1713190 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 2021   grade_11 19 0 0   0 0     0   0   16 3     0.0   0.0     3.0   8.0   19 19 0 0   0 0     0   0   16 3     0 0   3 8   19
1713191 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 2021   grade_12 17 0 0   0 0     0   0   8 9     0.0   0.0     0.0   5.0   17 17 0 0   0 0     0   0   8 9     0 0   0 5   17
1713192 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 2021   pk_12_total 107 1 2   0 0     0   1   71 40     0.0   0.0     11.0   38.0   111 107 1 2   0 0     0   1   71 40     0 0   11 38   111
1715889 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 2021   early_childhood_special_ed 11 0 0   0 0     0   0   7 4     0.0   0.0     3.0   *   11 11 0 0   0 0     0   0   7 4     0 0   3     11
1715890 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 2021   kindergarten 62 0 2   0 0     0   1   33 32     3.0   0.0     19.0   13.0   65 62 0 2   0 0     0   1   33 32     3 0   19 13   65
1715891 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 2021   grade_1 79 1 3   1 0     0   1   46 39     1.0   0.0     19.0   14.0   85 79 1 3   1 0     0   1   46 39     1 0   19 14   85
1715892 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 2021   grade_2 60 0 2   1 0     0   2   37 28     1.0   0.0     12.0   9.0   65 60 0 2   1 0     0   2   37 28     1 0   12 9   65
1715893 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 2021   grade_3 69 1 5   0 0     0   6   36 45     1.0   0.0     27.0   11.0   81 69 1 5   0 0     0   6   36 45     1 0   27 11   81
1715894 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 2021   grade_4 70 0 2   0 0     0   1   30 43     2.0   1.0     18.0   9.0   73 70 0 2   0 0     0   1   30 43     2 1   18 9   73
1715895 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 2021   pk_12_total 351 2 14   2 0     0   11   189 191     8.0   1.0     98.0   67.0   380 351 2 14   2 0     0   11   189 191     8 1   98 67   380
1717452 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 2021   kindergarten 92 13 2   0 4     0   7   60 58     5.0   0.0     10.0   9.0   118 92 13 2   0 4     0   7   60 58     5 0   10 9   118
1717453 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 2021   grade_1 97 10 5   0 6     0   6   60 64     8.0   0.0     11.0   19.0   124 97 10 5   0 6     0   6   60 64     8 0   11 19   124
1717454 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 2021   grade_2 95 7 1   1 1     0   10   60 55     1.0   0.0     4.0   22.0   115 95 7 1   1 1     0   10   60 55     1 0   4 22   115
1717455 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 2021   grade_3 85 11 3   0 5     0   9   59 54     6.0   0.0     11.0   18.0   113 85 11 3   0 5     0   9   59 54     6 0   11 18   113
1717456 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 2021   grade_4 79 6 2   1 1     0   5   49 45     3.0   0.0     7.0   25.0   94 79 6 2   1 1     0   5   49 45     3 0   7 25   94
1717457 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 2021   grade_5 63 10 2   0 1     0   5   39 42     2.0   0.0     8.0   8.0   81 63 10 2   0 1     0   5   39 42     2 0   8 8   81
1717458 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 2021   pk_12_total 511 57 15   2 18     0   42   327 318     25.0   0.0     51.0   101.0   645 511 57 15   2 18     0   42   327 318     25 0   51 101   645
1717481 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 2021   kindergarten 90 2 6   0 2     0   6   55 51     6.0   0.0     14.0   11.0   106 90 2 6   0 2     0   6   55 51     6 0   14 11   106
1717482 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 2021   grade_1 90 7 12   0 0     0   5   52 62     8.0   0.0     14.0   17.0   114 90 7 12   0 0     0   5   52 62     8 0   14 17   114
1717483 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 2021   grade_2 97 1 3   0 5     0   7   48 65     6.0   0.0     14.0   10.0   113 97 1 3   0 5     0   7   48 65     6 0   14 10   113
1717484 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 2021   grade_3 81 2 10   0 5     0   8   58 48     11.0   0.0     20.0   9.0   106 81 2 10   0 5     0   8   58 48     11 0   20 9   106
1717485 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 2021   grade_4 82 5 3   0 2     0   7   47 52     *   0.0     14.0   16.0   99 82 5 3   0 2     0   7   47 52       0   14 16   99
1717486 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 2021   grade_5 87 2 8   0 2     0   8   57 50     *   0.0     16.0   21.0   107 87 2 8   0 2     0   8   57 50       0   16 21   107
1717487 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 2021   pk_12_total 527 19 42   0 16     0   41   317 328     36.0   0.0     92.0   84.0   645 527 19 42   0 16     0   41   317 328     36 0   92 84   645
1718130 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 2021   early_childhood_special_ed 26 0 0   0 0     0   0   19 7     0.0   0.0     9.0   *   26 26 0 0   0 0     0   0   19 7     0 0   9     26
1718131 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 2021   kindergarten 149 1 2   0 0     0   6   69 89     3.0   1.0     26.0   19.0   158 149 1 2   0 0     0   6   69 89     3 1   26 19   158

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