enrollments

Data source: Big Local News · About: Big Local

16,029 rows where grade = "pk_12_total" and state = "MN" sorted by county descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • pk_12_total · 16,029 ✖
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
689952 689952 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 2017   pk_12_total 252.0 2.0 5.0   0.0 1.0     0.0   0.0   138.0 122.0     1.0   0.0     70.0   34.0   260.0 252 2 5   0 1     0   0   138 122     1 0   70 34   260
695446 695446 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 2017   pk_12_total 249.0 4.0 13.0   0.0 1.0     0.0   8.0   123.0 152.0     0.0   0.0     116.0   57.0   275.0 249 4 13   0 1     0   8   123 152     0 0   116 57   275
695773 695773 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 2017   pk_12_total 229.0 2.0 38.0   59.0 6.0     0.0   8.0   181.0 161.0     5.0   0.0     155.0   85.0   342.0 229 2 38   59 6     0   8   181 161     5 0   155 85   342
697240 697240 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 2017   pk_12_total 45.0 0.0 6.0   1.0 0.0     0.0   1.0   24.0 29.0     0.0   0.0     29.0   7.0   53.0 45 0 6   1 0     0   1   24 29     0 0   29 7   53
698433 698433 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 2017   pk_12_total 118.0 3.0 22.0   35.0 2.0     0.0   2.0   94.0 88.0     3.0   0.0     78.0   33.0   182.0 118 3 22   35 2     0   2   94 88     3 0   78 33   182
699431 699431 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 2017   pk_12_total 169.0 1.0 20.0   26.0 4.0     0.0   0.0   116.0 104.0     8.0   0.0     79.0   33.0   220.0 169 1 20   26 4     0   0   116 104     8 0   79 33   220
702739 702739 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 2017   pk_12_total 77.0 1.0 6.0   7.0 1.0     0.0   14.0   54.0 52.0     0.0   0.0     65.0   24.0   106.0 77 1 6   7 1     0   14   54 52     0 0   65 24   106
854370 854370 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 3 07 12 2016   pk_12_total 244 1 4   0 0     0   0   140 109     1.0   0.0     77.0   32.0   249 244 1 4   0 0     0   0   140 109     1 0   77 32   249
859731 859731 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 1 PK 06 2016   pk_12_total 258 3 6   0 2     0   3   128 144     0.0   0.0     102.0   48.0   272 258 3 6   0 2     0   3   128 144     0 0   102 48   272
860066 860066 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 1 PK 05 2016   pk_12_total 249 3 48   58 8     0   11   195 182     13.0   0.0     185.0   84.0   377 249 3 48   58 8     0   11   195 182     13 0   185 84   377
861496 861496 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 1 KG 06 2016   pk_12_total 52 0 2   2 0     0   2   34 24     0.0   0.0     31.0   11.0   58 52 0 2   2 0     0   2   34 24     0 0   31 11   58
862608 862608 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 2 06 08 2016   pk_12_total 110 3 23   32 4     0   1   89 84     6.0   0.0     85.0   34.0   173 110 3 23   32 4     0   1   89 84     6 0   85 34   173
863604 863604 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 3 09 12 2016   pk_12_total 178 1 17   28 4     0   1   125 104     4.0   0.0     74.0   34.0   229 178 1 17   28 4     0   1   125 104     4 0   74 34   229
866886 866886 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 4 KG 12 2016   pk_12_total 71 1 7   7 1     0   9   56 40     0.0   0.0     57.0   22.0   96 71 1 7   7 1     0   9   56 40     0 0   57 22   96
1147060 1147060 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 3 07 12 2015   pk_12_total 252.0 1.0 6.0   0.0 0.0     0.0   0.0   148.0 111.0     1.0   0.0     82.0   35.0   259.0 252 1 6   0 0     0   0   148 111     1 0   82 35   259
1152409 1152409 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 1 PK 06 2015   pk_12_total 246.0 3.0 4.0   0.0 2.0     0.0   1.0   129.0 127.0     0.0   0.0     98.0   53.0   256.0 246 3 4   0 2     0   1   129 127     0 0   98 53   256
1152749 1152749 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 1 PK 05 2015   pk_12_total 246.0 3.0 55.0   63.0 8.0     0.0   8.0   195.0 188.0     13.0   1.0     193.0   91.0   383.0 246 3 55   63 8     0   8   195 188     13 1   193 91   383
1154210 1154210 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 1 KG 06 2015   pk_12_total 54.0 0.0 4.0   1.0 0.0     0.0   1.0   36.0 24.0     0.0   0.0     34.0   12.0   60.0 54 0 4   1 0     0   1   36 24     0 0   34 12   60
1155261 1155261 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 2 06 08 2015   pk_12_total 110.0 1.0 24.0   29.0 3.0     0.0   1.0   89.0 79.0     10.0   1.0     81.0   35.0   168.0 110 1 24   29 3     0   1   89 79     10 1   81 35   168
1156232 1156232 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 3 09 12 2015   pk_12_total 199.0 1.0 23.0   34.0 4.0     0.0   2.0   133.0 130.0     4.0   0.0     92.0   43.0   263.0 199 1 23   34 4     0   2   133 130     4 0   92 43   263
1159435 1159435 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 4 KG 12 2015   pk_12_total 75.0 3.0 8.0   6.0 2.0     0.0   6.0   55.0 45.0     0.0   0.0     60.0   25.0   100.0 75 3 8   6 2     0   6   55 45     0 0   60 25   100
1712583 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
1718250 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
1718567 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
1720042 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
1721437 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
1722465 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
1725552 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
1826161 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
1831815 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
1832144 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
1833593 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
1834957 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
1835966 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
1839243 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
1880748 1880748 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 2018   pk_12_total 259.0 4.0 6.0   0.0 1.0     0.0   3.0   144.0 129.0     1.0   0.0     71.0   39.0   273.0 259 4 6   0 1     0   3   144 129     1 0   71 39   273
1886349 1886349 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 2018   pk_12_total 274.0 3.0 11.0   1.0 1.0     0.0   7.0   140.0 157.0     3.0   0.0     127.0   59.0   297.0 274 3 11   1 1     0   7   140 157     3 0   127 59   297
1886678 1886678 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 2018   pk_12_total 236.0 4.0 41.0   43.0 6.0     0.0   6.0   181.0 155.0     5.0   0.0     143.0   92.0   336.0 236 4 41   43 6     0   6   181 155     5 0   143 92   336
1888139 1888139 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 2018   pk_12_total 45.0 0.0 9.0   0.0 0.0     0.0   2.0   24.0 32.0     0.0   0.0     27.0   11.0   56.0 45 0 9   0 0     0   2   24 32     0 0   27 11   56
1889411 1889411 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 2018   pk_12_total 117.0 2.0 18.0   32.0 2.0     0.0   5.0   88.0 88.0     3.0   0.0     69.0   32.0   176.0 117 2 18   32 2     0   5   88 88     3 0   69 32   176
1890401 1890401 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 2018   pk_12_total 156.0 3.0 25.0   28.0 4.0     0.0   0.0   114.0 102.0     11.0   0.0     82.0   35.0   216.0 156 3 25   28 4     0   0   114 102     11 0   82 35   216
1893654 1893654 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 2018   pk_12_total 67.0 2.0 8.0   24.0 1.0     0.0   13.0   54.0 61.0     0.0   0.0     68.0   36.0   115.0 67 2 8   24 1     0   13   54 61     0 0   68 36   115
1945303 1945303 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 2019   pk_12_total 261.0 3.0 9.0   0.0 1.0     0.0   3.0   147.0 130.0     0.0   0.0     61.0   41.0   277.0 261 3 9   0 1     0   3   147 130     0 0   61 41   277
1950934 1950934 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 2019   pk_12_total 281.0 3.0 7.0   1.0 1.0     0.0   9.0   140.0 162.0     2.0   0.0     111.0   49.0   302.0 281 3 7   1 1     0   9   140 162     2 0   111 49   302
1951263 1951263 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 2019   pk_12_total 227.0 2.0 38.0   48.0 4.0     0.0   6.0   173.0 152.0     9.0   0.0     139.0   90.0   325.0 227 2 38   48 4     0   6   173 152     9 0   139 90   325
1952710 1952710 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 2019   pk_12_total 44.0 0.0 5.0   0.0 0.0     0.0   2.0   26.0 25.0     0.0   0.0     28.0   11.0   51.0 44 0 5   0 0     0   2   26 25     0 0   28 11   51
1954015 1954015 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 2019   pk_12_total 110.0 2.0 22.0   28.0 3.0     0.0   5.0   79.0 91.0     1.0   0.0     70.0   31.0   170.0 110 2 22   28 3     0   5   79 91     1 0   70 31   170
1955011 1955011 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 2019   pk_12_total 145.0 5.0 25.0   23.0 3.0     0.0   0.0   106.0 95.0     9.0   0.0     73.0   34.0   201.0 145 5 25   23 3     0   0   106 95     9 0   73 34   201
1958258 1958258 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 2019   pk_12_total 43.0 0.0 3.0   12.0 1.0     0.0   9.0   35.0 33.0     0.0   0.0     40.0   23.0   68.0 43 0 3   12 1     0   9   35 33     0 0   40 23   68
689945 689945 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 2017   pk_12_total 433.0 3.0 1.0   1.0 1.0     5.0   9.0   223.0 230.0     0.0   0.0     87.0   66.0   453.0 433 3 1   1 1     5   9   223 230     0 0   87 66   453
690453 690453 MN Wright 86 school 2700360 4118 Charter Schools KALEIDOSCOPE CHARTER SCHOOL 270036004668 20 Kaleidoscope Charter Secondary School Secondary School (Grades 7-12) Regular School Yes Other 06 12 2017   pk_12_total 120.0 3.0 5.0   0.0 0.0     0.0   1.0   67.0 62.0     1.0   0.0     33.0   45.0   129.0 120 3 5   0 0     0   1   67 62     1 0   33 45   129
690533 690533 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 Other 06 12 2017   pk_12_total 98.0 0.0 1.0   0.0 0.0     0.0   2.0   65.0 36.0     0.0   1.0     25.0   33.0   101.0 98 0 1   0 0     0   2   65 36     0 1   25 33   101
693120 693120 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 2017   pk_12_total 487.0 2.0 21.0   0.0 5.0     0.0   13.0   266.0 262.0     10.0   0.0     147.0   91.0   528.0 487 2 21   0 5     0   13   266 262     10 0   147 91   528
694647 694647 MN Wright 86 school 2711370 728 Independent Districts and Schools ELK RIVER PUBLIC SCHOOL DISTRICT 271137002557 800 OTSEGO ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   pk_12_total 654.0 23.0 31.0   1.0 9.0     0.0   50.0   382.0 386.0     34.0   1.0     166.0   106.0   768.0 654 23 31   1 9     0   50   382 386     34 1   166 106   768
695339 695339 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 2017   pk_12_total 820.0 9.0 19.0   0.0 6.0     1.0   55.0   451.0 459.0     10.0   3.0     250.0   177.0   910.0 820 9 19   0 6     1   55   451 459     10 3   250 177   910
695346 695346 MN Wright 86 school 2707200 877 Independent Districts and Schools BUFFALO-HANOVER-MONTROSE PUBLIC SCH 270720000283 10 PARKSIDE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   pk_12_total 342.0 5.0 31.0   1.0 1.0     1.0   24.0   239.0 166.0     18.0   2.0     142.0   84.0   405.0 342 5 31   1 1     1   24   239 166     18 2   142 84   405
695354 695354 MN Wright 86 school 2707200 877 Independent Districts and Schools BUFFALO-HANOVER-MONTROSE PUBLIC SCH 270720000286 20 HANOVER ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 06 2017   pk_12_total 404.0 4.0 14.0   0.0 6.0     0.0   8.0   199.0 237.0     4.0   0.0     59.0   40.0   436.0 404 4 14   0 6     0   8   199 237     4 0   59 40   436
695361 695361 MN Wright 86 school 2707200 877 Independent Districts and Schools BUFFALO-HANOVER-MONTROSE PUBLIC SCH 270720000287 50 MONTROSE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   pk_12_total 296.0 8.0 24.0   0.0 3.0     0.0   11.0   181.0 161.0     6.0   0.0     137.0   53.0   342.0 296 8 24   0 3     0   11   181 161     6 0   137 53   342
695368 695368 MN Wright 86 school 2707200 877 Independent Districts and Schools BUFFALO-HANOVER-MONTROSE PUBLIC SCH 270720001875 60 TATANKA ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   pk_12_total 465.0 11.0 12.0   6.0 3.0     3.0   28.0   271.0 257.0     10.0   6.0     166.0   73.0   528.0 465 11 12   6 3     3   28   271 257     10 6   166 73   528
695375 695375 MN Wright 86 school 2707200 877 Independent Districts and Schools BUFFALO-HANOVER-MONTROSE PUBLIC SCH 270720004186 65 NORTHWINDS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   pk_12_total 485.0 5.0 6.0   1.0 2.0     0.0   15.0   282.0 232.0     1.0   1.0     109.0   75.0   514.0 485 5 6   1 2     0   15   282 232     1 1   109 75   514
695382 695382 MN Wright 86 school 2707200 877 Independent Districts and Schools BUFFALO-HANOVER-MONTROSE PUBLIC SCH 270720002686 70 DISCOVERY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   pk_12_total 231.0 0.0 4.0   0.0 4.0     0.0   9.0   126.0 122.0     0.0   0.0     37.0   26.0   248.0 231 0 4   0 4     0   9   126 122     0 0   37 26   248
695389 695389 MN Wright 86 school 2710170 879 Independent Districts and Schools DELANO PUBLIC SCHOOL DISTRICT 271017000436 10 DELANO ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2017   pk_12_total 881.0 2.0 21.0   4.0 7.0     0.0   39.0   491.0 463.0     7.0   0.0     99.0   151.0   954.0 881 2 21   4 7     0   39   491 463     7 0   99 151   954
695398 695398 MN Wright 86 school 2718810 881 Independent Districts and Schools MAPLE LAKE PUBLIC SCHOOL DISTRICT 271881000885 10 MAPLE LAKE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   pk_12_total 388.0 4.0 2.0   2.0 2.0     2.0   5.0   204.0 201.0     0.0   0.0     105.0   94.0   405.0 388 4 2   2 2     2   5   204 201     0 0   105 94   405
695405 695405 MN Wright 86 school 2721390 882 Independent Districts and Schools MONTICELLO PUBLIC SCHOOL DISTRICT 272139001078 10 PINEWOOD ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   pk_12_total 962.0 10.0 60.0   1.0 8.0     0.0   36.0   579.0 498.0     34.0   5.0     295.0   135.0   1077.0 962 10 60   1 8     0   36   579 498     34 5   295 135   1077
695412 695412 MN Wright 86 school 2721390 882 Independent Districts and Schools MONTICELLO PUBLIC SCHOOL DISTRICT 272139001837 50 LITTLE MOUNTAIN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   pk_12_total 672.0 18.0 77.0   0.0 5.0     0.0   36.0   438.0 370.0     43.0   2.0     234.0   117.0   808.0 672 18 77   0 5     0   36   438 370     43 2   234 117   808
695422 695422 MN Wright 86 school 2733790 885 Independent Districts and Schools ST. MICHAEL-ALBERTVILLE SCHOOL DIST 273379001534 10 ALBERTVILLE PRIMARY Elementary School (Grades PK-6) Regular School No Elementary PK KG 2017   pk_12_total 459.0 15.0 17.0   0.0 7.0     0.0   17.0   270.0 245.0     13.0   0.0     58.0   108.0   515.0 459 15 17   0 7     0   17   270 245     13 0   58 108   515
695427 695427 MN Wright 86 school 2733790 885 Independent Districts and Schools ST. MICHAEL-ALBERTVILLE SCHOOL DIST 273379000032 40 ST. MICHAEL ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 01 04 2017   pk_12_total 470.0 11.0 19.0   0.0 10.0     0.0   24.0   279.0 255.0     9.0   3.0     73.0   35.0   534.0 470 11 19   0 10     0   24   279 255     9 3   73 35   534
695432 695432 MN Wright 86 school 2733790 885 Independent Districts and Schools ST. MICHAEL-ALBERTVILLE SCHOOL DIST 273379004187 60 BIG WOODS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 01 04 2017   pk_12_total 562.0 15.0 19.0   1.0 15.0     1.0   25.0   322.0 316.0     16.0   0.0     45.0   51.0   638.0 562 15 19   1 15     1   25   322 316     16 0   45 51   638
695437 695437 MN Wright 86 school 2733790 885 Independent Districts and Schools ST. MICHAEL-ALBERTVILLE SCHOOL DIST 273379003673 70 FIELDSTONE ELEMENTARY SCHOOL Elementary School (Grades PK-6) Regular School No Elementary 01 04 2017   pk_12_total 561.0 22.0 21.0   2.0 11.0     0.0   31.0   353.0 295.0     18.0   0.0     88.0   58.0   648.0 561 22 21   2 11     0   31   353 295     18 0   88 58   648
695958 695958 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 04 2017   pk_12_total 259.0 3.0 2.0   0.0 0.0     0.0   7.0   144.0 127.0     0.0   0.0     73.0   28.0   271.0 259 3 2   0 0     0   7   144 127     0 0   73 28   271
697012 697012 MN Wright 86 school 2700360 4118 Charter Schools KALEIDOSCOPE CHARTER SCHOOL 270036004104 10 KALEIDOSCOPE CHARTER SCHOOL Elementary School (Grades PK-6) Regular School Yes Elementary KG 05 2017   pk_12_total 399.0 7.0 13.0   1.0 2.0     0.0   13.0   216.0 219.0     5.0   0.0     75.0   64.0   435.0 399 7 13   1 2     0   13   216 219     5 0   75 64   435
697068 697068 MN Wright 86 school 2700249 4137 Charter Schools Swan River Montessori Charter School 270024903309 10 Swan River Montessori Charter School Elementary School (Grades PK-6) Regular School Yes Elementary KG 06 2017   pk_12_total 141.0 2.0 6.0   2.0 3.0     0.0   3.0   72.0 85.0     0.0   0.0     13.0   30.0   157.0 141 2 6   2 3     0   3   72 85     0 0   13 30   157
697639 697639 MN Wright 86 school 2707200 877 Independent Districts and Schools BUFFALO-HANOVER-MONTROSE PUBLIC SCH 270720002853 45 PHOENIX LEARNING CENTER Public Area Learning Program ALP (State approved) Alternative School No High 09 12 2017   pk_12_total 18.0 0.0 1.0   0.0 0.0     0.0   0.0   11.0 8.0     0.0   0.0     10.0   *   19.0 18 0 1   0 0     0   0   11 8     0 0   10     19
697643 697643 MN Wright 86 school 2721390 882 Independent Districts and Schools MONTICELLO PUBLIC SCHOOL DISTRICT 272139001834 40 MONTICELLO ALTERNATIVE PROGRAM Public Area Learning Program ALP (State approved) Alternative School No High 09 12 2017   pk_12_total 22.0 0.0 0.0   0.0 0.0     0.0   1.0   12.0 11.0     0.0   1.0     12.0   *   23.0 22 0 0   0 0     0   1   12 11     0 1   12     23
697647 697647 MN Wright 86 school 2733790 885 Independent Districts and Schools ST. MICHAEL-ALBERTVILLE SCHOOL DIST 273379003105 50 KNIGHTS ACADEMY Public Area Learning Program ALP (State approved) Alternative School No High 10 12 2017   pk_12_total 22.0 2.0 1.0   0.0 0.0     0.0   0.0   19.0 6.0     0.0   1.0     6.0   7.0   25.0 22 2 1   0 0     0   0   19 6     0 1   6 7   25
697671 697671 MN Wright 86 school 2700123 2687 Independent Districts and Schools HOWARD LAKE-WAVERLY-WINSTED 270012304414 8 HLWW ALTERNATIVE LEARNING PROGRAM Public Area Learning Program ALP (State approved) Alternative School No High 09 12 2017   pk_12_total 12.0 2.0 0.0   0.0 0.0     0.0   1.0   6.0 9.0     0.0   0.0     4.0   3.0   15.0 12 2 0   0 0     0   1   6 9     0 0   4 3   15
698076 698076 MN Wright 86 school 2710060 466 Independent Districts and Schools DASSEL-COKATO PUBLIC SCHOOL DIST. 271006002267 4 DASSEL-COKATO MIDDLE Middle School (Grades 5-8) Regular School No Middle 05 08 2017   pk_12_total 638.0 5.0 23.0   4.0 4.0     0.0   12.0   355.0 331.0     9.0   1.0     202.0   87.0   686.0 638 5 23   4 4     0   12   355 331     9 1   202 87   686
698351 698351 MN Wright 86 school 2703150 876 Independent Districts and Schools ANNANDALE PUBLIC SCHOOL DISTRICT 270315000093 2 ANNANDALE MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 06 08 2017   pk_12_total 376.0 3.0 8.0   1.0 2.0     0.0   10.0   201.0 199.0     4.0   2.0     95.0   57.0   400.0 376 3 8   1 2     0   10   201 199     4 2   95 57   400
698355 698355 MN Wright 86 school 2707200 877 Independent Districts and Schools BUFFALO-HANOVER-MONTROSE PUBLIC SCH 270720000284 30 BUFFALO COMMUNITY MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   pk_12_total 1227.0 16.0 46.0   5.0 10.0     1.0   45.0   668.0 682.0     9.0   5.0     299.0   175.0   1350.0 1227 16 46   5 10     1   45   668 682     9 5   299 175   1350
698360 698360 MN Wright 86 school 2710170 879 Independent Districts and Schools DELANO PUBLIC SCHOOL DISTRICT 271017000437 15 DELANO MIDDLE Middle School (Grades 5-8) Regular School No Middle 05 08 2017   pk_12_total 726.0 1.0 14.0   0.0 7.0     0.0   24.0   394.0 378.0     4.0   0.0     85.0   105.0   772.0 726 1 14   0 7     0   24   394 378     4 0   85 105   772
698364 698364 MN Wright 86 school 2721390 882 Independent Districts and Schools MONTICELLO PUBLIC SCHOOL DISTRICT 272139002209 30 MONTICELLO MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   pk_12_total 827.0 11.0 71.0   3.0 19.0     0.0   18.0   489.0 460.0     34.0   *     259.0   122.0   949.0 827 11 71   3 19     0   18   489 460     34     259 122   949
698369 698369 MN Wright 86 school 2732070 883 Independent Districts and Schools ROCKFORD PUBLIC SCHOOL DISTRICT 273207001941 3 ROCKFORD MIDDLE Middle School (Grades 5-8) Regular School No Middle 05 08 2017   pk_12_total 447.0 27.0 47.0   2.0 12.0     0.0   17.0   282.0 270.0     11.0   1.0     139.0   59.0   552.0 447 27 47   2 12     0   17   282 270     11 1   139 59   552
698374 698374 MN Wright 86 school 2733790 885 Independent Districts and Schools ST. MICHAEL-ALBERTVILLE SCHOOL DIST 273379001536 30 ST. MICHAEL-ALBERTVILLE MIDDLE EAST Middle School (Grades 5-8) Regular School No Middle 05 08 2017   pk_12_total 901.0 29.0 21.0   1.0 18.0     0.0   35.0   522.0 483.0     6.0   2.0     101.0   87.0   1005.0 901 29 21   1 18     0   35   522 483     6 2   101 87   1005
698379 698379 MN Wright 86 school 2733790 885 Independent Districts and Schools ST. MICHAEL-ALBERTVILLE SCHOOL DIST 273379004346 90 ST MICHAEL-ALBERTVILLE MIDDLE WEST Middle School (Grades 5-8) Regular School No Middle 05 08 2017   pk_12_total 899.0 34.0 32.0   2.0 15.0     0.0   51.0   535.0 498.0     14.0   3.0     153.0   92.0   1033.0 899 34 32   2 15     0   51   535 498     14 3   153 92   1033
698456 698456 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 2017   pk_12_total 309.0 4.0 13.0   1.0 1.0     0.0   7.0   153.0 182.0     1.0   2.0     94.0   52.0   335.0 309 4 13   1 1     0   7   153 182     1 2   94 52   335
699027 699027 MN Wright 86 school 2710060 466 Independent Districts and Schools DASSEL-COKATO PUBLIC SCHOOL DIST. 271006000428 2 DASSEL-COKATO SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 09 12 2017   pk_12_total 609.0 7.0 14.0   2.0 5.0     0.0   5.0   331.0 311.0     4.0   1.0     164.0   65.0   642.0 609 7 14   2 5     0   5   331 311     4 1   164 65   642
699350 699350 MN Wright 86 school 2703150 876 Independent Districts and Schools ANNANDALE PUBLIC SCHOOL DISTRICT 270315001825 3 ANNANDALE SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 09 12 2017   pk_12_total 494.0 4.0 13.0   0.0 3.0     0.0   16.0   272.0 258.0     4.0   3.0     96.0   81.0   530.0 494 4 13   0 3     0   16   272 258     4 3   96 81   530
699355 699355 MN Wright 86 school 2707200 877 Independent Districts and Schools BUFFALO-HANOVER-MONTROSE PUBLIC SCH 270720000285 40 BUFFALO SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 09 12 2017   pk_12_total 1705.0 23.0 66.0   8.0 25.0     2.0   36.0   929.0 936.0     6.0   2.0     350.0   221.0   1865.0 1705 23 66   8 25     2   36   929 936     6 2   350 221   1865
699360 699360 MN Wright 86 school 2710170 879 Independent Districts and Schools DELANO PUBLIC SCHOOL DISTRICT 271017000438 20 DELANO SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 09 12 2017   pk_12_total 758.0 7.0 12.0   3.0 14.0     0.0   5.0   397.0 402.0     3.0   1.0     68.0   73.0   799.0 758 7 12   3 14     0   5   397 402     3 1   68 73   799
699365 699365 MN Wright 86 school 2721390 882 Independent Districts and Schools MONTICELLO PUBLIC SCHOOL DISTRICT 272139001079 20 MONTICELLO SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 09 12 2017   pk_12_total 1020.0 28.0 85.0   1.0 14.0     3.0   21.0   604.0 568.0         5.0     279.0   165.0   1172.0 1020 28 85   1 14     3   21   604 568       5   279 165   1172
699375 699375 MN Wright 86 school 2733790 885 Independent Districts and Schools ST. MICHAEL-ALBERTVILLE SCHOOL DIST 273379001535 20 ST. MICHAEL-ALBERTVILLE SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 09 12 2017   pk_12_total 1709.0 42.0 36.0   1.0 44.0     1.0   55.0   949.0 939.0     26.0   7.0     211.0   139.0   1888.0 1709 42 36   1 44     1   55   949 939     26 7   211 139   1888
699465 699465 MN Wright 86 school 2700123 2687 Independent Districts and Schools HOWARD LAKE-WAVERLY-WINSTED 270012300751 2 HOWARD LAKE-WAVERLY-WINSTED SEC. Senior High School (Grades 9-12) Regular School No High 09 12 2017   pk_12_total 283.0 4.0 9.0   3.0 5.0     0.0   10.0   156.0 158.0     0.0   1.0     66.0   46.0   314.0 283 4 9   3 5     0   10   156 158     0 1   66 46   314
699999 699999 MN Wright 86 school 2710060 466 Independent Districts and Schools DASSEL-COKATO PUBLIC SCHOOL DIST. 271006002658 6 DASSEL-COKATO ALTERNATIVE CTR. Public Area Learning Center ALC (State approved) Alternative School No High 09 12 2017   pk_12_total 61.0 1.0 3.0   2.0 0.0     0.0   0.0   46.0 21.0     0.0   0.0     28.0   17.0   67.0 61 1 3   2 0     0   0   46 21     0 0   28 17   67
700354 700354 MN Wright 86 school 2700036 966 Vocational Cooperatives WRIGHT TECHNICAL CENTER 270003602351 20 WRIGHT TECHNICAL CENTER ALC Public Area Learning Center ALC (State approved) Alternative School No High 09 12 2017   pk_12_total 77.0 8.0 11.0   1.0 2.0     0.0   1.0   57.0 43.0     0.0   1.0     50.0   15.0   100.0 77 8 11   1 2     0   1   57 43     0 1   50 15   100
700901 700901 MN Wright 86 school 2707200 877 Independent Districts and Schools BUFFALO-HANOVER-MONTROSE PUBLIC SCH 270720002852 15 BUFFALO EARLY CHILD. SP. ED PROGRAM Special Education Special Education School No Elementary PK PK 2017   pk_12_total 112.0 1.0 8.0   1.0 0.0     0.0   4.0   84.0 42.0     0.0   1.0     35.0   *   126.0 112 1 8   1 0     0   4   84 42     0 1   35     126
700903 700903 MN Wright 86 school 2721390 882 Independent Districts and Schools MONTICELLO PUBLIC SCHOOL DISTRICT 272139003006 60 EARLY CHILDHOOD SPECIAL EDUCATION Special Education Special Education School No Elementary PK PK 2017   pk_12_total 53.0 0.0 3.0   0.0 1.0     0.0   1.0   40.0 18.0     0.0   0.0         *   58.0 53 0 3   0 1     0   1   40 18     0 0         58
701262 701262 MN Wright 86 school 2700045 938 Special Education Cooperatives MEEKER AND WRIGHT SPECIAL EDUCATION 270004502960 2 MEEKER-WRIGHT EARLY CHILDHOOD SP ED Special Education Special Education School No Elementary PK PK 2017   pk_12_total 60.0 0.0 2.0   0.0 0.0     0.0   0.0   41.0 21.0     0.0   1.0     24.0   *   62.0 60 0 2   0 0     0   0   41 21     0 1   24     62
701270 701270 MN Wright 86 school 2700045 938 Special Education Cooperatives MEEKER AND WRIGHT SPECIAL EDUCATION 270004504402 10 TREK PROGRAM Special Education Special Education School No Other KG 12 2017   pk_12_total 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
701277 701277 MN Wright 86 school 2700045 938 Special Education Cooperatives MEEKER AND WRIGHT SPECIAL EDUCATION 270004502961 11 CORNERSTONES PROGRAM Special Education Special Education School No Other 06 12 2017   pk_12_total 29.0 1.0 0.0   1.0 0.0     0.0   0.0   22.0 9.0     0.0   0.0     21.0   *   31.0 29 1 0   1 0     0   0   22 9     0 0   21     31
701279 701279 MN Wright 86 school 2700045 938 Special Education Cooperatives MEEKER AND WRIGHT SPECIAL EDUCATION 270004504318 13 STEP TD PROGRAM Special Education Special Education School No High 11 12 2017   pk_12_total 21.0 0.0 1.0   1.0 0.0     0.0   0.0   11.0 12.0     0.0   0.0     6.0   *   23.0 21 0 1   1 0     0   0   11 12     0 0   6     23

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