enrollments

Data source: Big Local News · About: Big Local

13,903 rows where state = "MN" and year = 2019 sorted by black descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2019 · 13,903 ✖
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
1954103 1954103 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124004882 327 Franklin Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_6 3.0 99.0 21.0   5.0 0.0     1.0   3.0   80.0 52.0     11.0   4.0     116.0   32.0   132.0 3 99 21   5 0     1   3   80 52     11 4   116 32   132
1954420 1954420 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239001373 97 APPLE VALLEY SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 09 12 2019   grade_10 229.0 99.0 74.0   2.0 18.0     0.0   24.0   250.0 196.0     28.0   1.0     153.0   70.0   446.0 229 99 74   2 18     0   24   250 196     28 1   153 70   446
1954481 1954481 MN Hennepin 27 school 2714220 272 Independent Districts and Schools EDEN PRAIRIE PUBLIC SCHOOL DISTRICT 271422000735 64 EDEN PRAIRIE SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 09 12 2019   grade_11 476.0 99.0 47.0   3.0 100.0     2.0   36.0   386.0 377.0     23.0   5.0     143.0   76.0   763.0 476 99 47   3 100     2   36   386 377     23 5   143 76   763
1954682 1954682 MN Olmsted 55 school 2731800 535 Independent Districts and Schools ROCHESTER PUBLIC SCHOOL DISTRICT 273180001015 310 JOHN MARSHALL SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 08 12 2019   grade_11 268.0 99.0 25.0   4.0 58.0     1.0   18.0   257.0 216.0     31.0   5.0     185.0   52.0   473.0 268 99 25   4 58     1   18   257 216     31 5   185 52   473
1947100 1947100 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239001376 711 GREENLEAF ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   pk_12_total 492.0 98.0 175.0   2.0 39.0     3.0   65.0   467.0 407.0     140.0   2.0     324.0   132.0   874.0 492 98 175   2 39     3   65   467 407     140 2   324 132   874
1952192 1952192 MN Hennepin 27 school 2700117 4017 Charter Schools Minnesota Transitions Charter School 270011704989 21 Banaadir South Elementary School (Grades PK-6) Regular School Yes Elementary KG 06 2019   pk_12_total 0.0 98.0 0.0   0.0 0.0     0.0   0.0   46.0 52.0     83.0   1.0         1.0   98.0 0 98 0   0 0     0   0   46 52     83 1     1   98
1954222 1954222 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000100 2 Coon Rapids High School Senior High School (Grades 9-12) Regular School No High 09 12 2019   grade_11 313.0 98.0 30.0   10.0 32.0     0.0   16.0   248.0 251.0     20.0   11.0     219.0   56.0   499.0 313 98 30   10 32     0   16   248 251     20 11   219 56   499
1954526 1954526 MN Hennepin 27 school 2731780 281 Independent Districts and Schools ROBBINSDALE PUBLIC SCHOOL DISTRICT 273178001318 53 ROBBINSDALE ARMSTRONG SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 09 12 2019   grade_11 272.0 98.0 65.0   3.0 26.0     0.0   20.0   257.0 227.0     19.0   6.0     164.0   63.0   484.0 272 98 65   3 26     0   20   257 227     19 6   164 63   484
1955447 1955447 MN Dakota 19 school 2707290 191 Independent Districts and Schools BURNSVILLE PUBLIC SCHOOL DISTRICT 270729002640 314 BURNSVILLE AREA LEARNING CENTER Public Area Learning Center ALC (State approved) Alternative School No High 06 12 2019   grade_7 73.0 98.0 85.0   4.0 18.0     0.0   15.0   144.0 149.0     74.0   2.0     198.0   70.0   293.0 73 98 85   4 18     0   15   144 149     74 2   198 70   293
1945030 1945030 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384004429 252 WASHINGTON TECH SECONDARY MAGNET Secondary School (Grades 7-12) Regular School No High 06 12 2019   grade_8 17.0 97.0 38.0   4.0 169.0     0.0   10.0   172.0 163.0     140.0   2.0     297.0   36.0   335.0 17 97 38   4 169     0   10   172 163     140 2   297 36   335
1952016 1952016 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124001879 256 GREEN CENTRAL PARK ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   pk_12_total 22.0 97.0 180.0   8.0 8.0     0.0   8.0   173.0 150.0     170.0   3.0         57.0   323.0 22 97 180   8 8     0   8   173 150     170 3     57   323
1947093 1947093 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239001375 710 Diamond Path Elementary School of International Studies Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   pk_12_total 430.0 96.0 59.0   3.0 87.0     0.0   64.0   333.0 406.0     75.0   2.0     141.0   68.0   739.0 430 96 59   3 87     0   64   333 406     75 2   141 68   739
1949527 1949527 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384001173 493 JJ HILL MONTESSORI Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   pk_12_total 195.0 96.0 27.0   2.0 31.0     0.0   55.0   203.0 203.0     86.0   0.0     140.0   43.0   406.0 195 96 27   2 31     0   55   203 203     86 0   140 43   406
1950039 1950039 MN Scott 70 school 2733000 720 Independent Districts and Schools SHAKOPEE PUBLIC SCHOOL DISTRICT 273300003166 864 RED OAK ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   pk_12_total 289.0 96.0 100.0   3.0 46.0     0.0   33.0   285.0 282.0     133.0   4.0     255.0   87.0   567.0 289 96 100   3 46     0   33   285 282     133 4   255 87   567
1950342 1950342 MN Steele 74 school 2728050 761 Independent Districts and Schools OWATONNA PUBLIC SCHOOL DISTRICT 272805001226 902 MCKINLEY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   pk_12_total 395.0 96.0 105.0   0.0 4.0     0.0   16.0   314.0 302.0     120.0   13.0     308.0   85.0   616.0 395 96 105   0 4     0   16   314 302     120 13   308 85   616
1954680 1954680 MN Olmsted 55 school 2731800 535 Independent Districts and Schools ROCHESTER PUBLIC SCHOOL DISTRICT 273180001015 310 JOHN MARSHALL SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 08 12 2019   grade_9 220.0 96.0 28.0   1.0 57.0     0.0   37.0   230.0 209.0     45.0   1.0     188.0   57.0   439.0 220 96 28   1 57     0   37   230 209     45 1   188 57   439
1955107 1955107 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124001026 360 ROOSEVELT SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 09 12 2019   grade_9 55.0 96.0 80.0   10.0 13.0     0.0   7.0   128.0 133.0     99.0   6.0     161.0   45.0   261.0 55 96 80   10 13     0   7   128 133     99 6   161 45   261
1955127 1955127 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124001055 368 WASHBURN SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 09 12 2019   grade_9 250.0 96.0 52.0   3.0 14.0     1.0   9.0   217.0 208.0     58.0   2.0     158.0   44.0   425.0 250 96 52   3 14     1   9   217 208     58 2   158 44   425
1949074 1949074 MN Ramsey 62 school 2722950 621 Independent Districts and Schools MOUNDS VIEW PUBLIC SCHOOL DISTRICT 272295004813 20 Pike Lake Kindergarten Center Elementary School (Grades PK-6) Regular School No Elementary PK KG 2019   pk_12_total 347.0 95.0 85.0   3.0 62.0     1.0   66.0   340.0 319.0     53.0   *     316.0   99.0   659.0 347 95 85   3 62     1   66   340 319     53     316 99   659
1953492 1953492 MN Hennepin 27 school 2714220 272 Independent Districts and Schools EDEN PRAIRIE PUBLIC SCHOOL DISTRICT 271422000734 65 CENTRAL MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 07 08 2019   grade_7 378.0 95.0 55.0   0.0 92.0     0.0   31.0   332.0 319.0     38.0   1.0     148.0   51.0   651.0 378 95 55   0 92     0   31   332 319     38 1   148 51   651
1953528 1953528 MN Hennepin 27 school 2725200 279 Independent Districts and Schools OSSEO PUBLIC SCHOOL DISTRICT 272520001214 86 North View Middle School, an IB World School Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_7 11.0 95.0 27.0   1.0 51.0     0.0   16.0   97.0 104.0     35.0   12.0     155.0   48.0   201.0 11 95 27   1 51     0   16   97 104     35 12   155 48   201
1955130 1955130 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124001055 368 WASHBURN SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 09 12 2019   grade_12 208.0 95.0 57.0   7.0 12.0     0.0   5.0   204.0 180.0     35.0   0.0     150.0   48.0   384.0 208 95 57   7 12     0   5   204 180     35 0   150 48   384
1955134 1955134 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124004557 375 NORTH ACADEMY SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 09 12 2019   grade_11 1.0 95.0 8.0   1.0 3.0     0.0   0.0   59.0 49.0     8.0   0.0     92.0   30.0   108.0 1 95 8   1 3     0   0   59 49     8 0   92 30   108
1949331 1949331 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384001133 410 ADAMS MAGNET ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   pk_12_total 163.0 94.0 304.0   2.0 2.0     0.0   51.0   303.0 313.0     136.0   5.0     301.0   41.0   616.0 163 94 304   2 2     0   51   303 313     136 5   301 41   616
1952786 1952786 MN Hennepin 27 school 2700309 4192 Charter Schools BEST ACADEMY 270030904261 10 BEST ACADEMY Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2019   grade_4 0.0 94.0 0.0   0.0 0.0     0.0   1.0   56.0 39.0     34.0   9.0     84.0   14.0   95.0 0 94 0   0 0     0   1   56 39     34 9   84 14   95
1953525 1953525 MN Hennepin 27 school 2725200 279 Independent Districts and Schools OSSEO PUBLIC SCHOOL DISTRICT 272520001217 34 Osseo Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_8 198.0 94.0 24.0   1.0 31.0     0.0   28.0   196.0 180.0     *   3.0         43.0   376.0 198 94 24   1 31     0   28   196 180       3     43   376
1954752 1954752 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384001585 215 HARDING SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 09 12 2019   grade_10 36.0 94.0 72.0   11.0 267.0     0.0   9.0   253.0 236.0     162.0   10.0     360.0   67.0   489.0 36 94 72   11 267     0   9   253 236     162 10   360 67   489
1955665 1955665 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384001415 710 GORDON PARKS HIGH SCHOOL Public Area Learning Center ALC (State approved) Alternative School No High 07 12 2019   pk_12_total 14.0 94.0 30.0   5.0 39.0     0.0   7.0   118.0 71.0     43.0   3.0     135.0   19.0   189.0 14 94 30   5 39     0   7   118 71     43 3   135 19   189
1945029 1945029 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384004429 252 WASHINGTON TECH SECONDARY MAGNET Secondary School (Grades 7-12) Regular School No High 06 12 2019   grade_7 15.0 93.0 39.0   0.0 154.0     1.0   11.0   162.0 151.0     115.0   3.0     264.0   56.0   313.0 15 93 39   0 154     1   11   162 151     115 3   264 56   313
1945901 1945901 MN Ramsey 62 school 2700402 4237 Charter Schools Career Pathways 270040204836 10 Career Pathways Secondary School (Grades 7-12) Regular School Yes High 06 12 2019   pk_12_total 7.0 93.0 4.0   0.0 0.0     0.0   2.0   63.0 43.0     34.0   2.0     83.0   18.0   106.0 7 93 4   0 0     0   2   63 43     34 2   83 18   106
1946914 1946914 MN Dakota 19 school 2707290 191 Independent Districts and Schools BURNSVILLE PUBLIC SCHOOL DISTRICT 270729000299 488 RAHN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   pk_12_total 141.0 93.0 47.0   2.0 30.0     1.0   27.0   176.0 165.0     64.0   7.0     158.0   65.0   341.0 141 93 47   2 30     1   27   176 165     64 7   158 65   341
1947568 1947568 MN Hennepin 27 school 2705790 271 Independent Districts and Schools BLOOMINGTON PUBLIC SCHOOL DISTRICT 270579000225 450 NORMANDALE HILLS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   pk_12_total 251.0 93.0 50.0   1.0 40.0     1.0   34.0   253.0 217.0     91.0   4.0     181.0   55.0   470.0 251 93 50   1 40     1   34   253 217     91 4   181 55   470
1953264 1953264 MN Anoka 2 school 2712420 14 Independent Districts and Schools FRIDLEY PUBLIC SCHOOL DISTRICT 271242000610 23 FRIDLEY MIDDLE Middle School (Grades 5-8) Regular School No Middle 05 08 2019   grade_8 64.0 93.0 35.0   1.0 13.0     0.0   15.0   115.0 106.0     29.0   6.0     162.0   22.0   221.0 64 93 35   1 13     0   15   115 106     29 6   162 22   221
1953391 1953391 MN Dakota 19 school 2707290 191 Independent Districts and Schools BURNSVILLE PUBLIC SCHOOL DISTRICT 270729000297 85 Joseph Nicollet Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2019   pk_12_total 126.0 93.0 41.0   0.0 19.0     0.0   22.0   139.0 162.0     4.0   7.0     159.0   18.0   301.0 126 93 41   0 19     0   22   139 162     4 7   159 18   301
1953755 1953755 MN Ramsey 62 school 2732430 623 Independent Districts and Schools ROSEVILLE PUBLIC SCHOOL DISTRICT 273243002667 70 ROSEVILLE AREA MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_8 166.0 93.0 77.0   2.0 94.0     0.0   19.0   239.0 212.0     53.0   9.0     230.0   59.0   451.0 166 93 77   2 94     0   19   239 212     53 9   230 59   451
1953835 1953835 MN Scott 70 school 2733000 720 Independent Districts and Schools SHAKOPEE PUBLIC SCHOOL DISTRICT 273300001439 84 Shakopee West Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2019   pk_12_total 644.0 93.0 162.0   11.0 141.0     2.0   94.0   589.0 558.0     77.0   5.0     385.0   145.0   1147.0 644 93 162   11 141     2   94   589 558     77 5   385 145   1147
1954762 1954762 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384001603 230 JOHNSON SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 09 12 2019   grade_10 43.0 93.0 29.0   2.0 156.0     0.0   10.0   172.0 161.0     73.0   6.0     257.0   65.0   333.0 43 93 29   2 156     0   10   172 161     73 6   257 65   333
1955210 1955210 MN Hennepin 27 school 2700341 4102 Charter Schools MINNESOTA INTERNSHIP CENTER 270034104165 15 UNITY CAMPUS Senior High School (Grades 9-12) Regular School Yes High 09 12 2019   pk_12_total 0.0 93.0 3.0   0.0 0.0     0.0   5.0   44.0 57.0     1.0   30.0     88.0   20.0   101.0 0 93 3   0 0     0   5   44 57     1 30   88 20   101
1956118 1956118 MN Hennepin 27 school 2725200 279 Independent Districts and Schools OSSEO PUBLIC SCHOOL DISTRICT 272520000742 697 EARLY CHILDHOOD SPECIAL EDUCATION Special Education Special Education School No Prekindergarten PK PK 2019   early_childhood_special_ed 159.0 93.0 46.0   3.0 40.0     0.0   35.0   253.0 123.0     0.0   1.0     79.0   *   376.0 159 93 46   3 40     0   35   253 123     0 1   79     376
1956119 1956119 MN Hennepin 27 school 2725200 279 Independent Districts and Schools OSSEO PUBLIC SCHOOL DISTRICT 272520000742 697 EARLY CHILDHOOD SPECIAL EDUCATION Special Education Special Education School No Prekindergarten PK PK 2019   pk_12_total 159.0 93.0 46.0   3.0 40.0     0.0   35.0   253.0 123.0     0.0   1.0     79.0   *   376.0 159 93 46   3 40     0   35   253 123     0 1   79     376
1949112 1949112 MN Ramsey 62 school 2722950 621 Independent Districts and Schools MOUNDS VIEW PUBLIC SCHOOL DISTRICT 272295001130 36 Valentine Hills Elementary Elementary School (Grades PK-6) Regular School No Elementary 01 05 2019   pk_12_total 391.0 92.0 83.0   5.0 48.0     0.0   54.0   364.0 309.0     66.0   6.0     277.0   65.0   673.0 391 92 83   5 48     0   54   364 309     66 6   277 65   673
1954220 1954220 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000100 2 Coon Rapids High School Senior High School (Grades 9-12) Regular School No High 09 12 2019   grade_9 353.0 92.0 53.0   8.0 45.0     0.0   33.0   276.0 308.0     29.0   7.0     269.0   74.0   584.0 353 92 53   8 45     0   33   276 308     29 7   269 74   584
1954470 1954470 MN Hennepin 27 school 2705790 271 Independent Districts and Schools BLOOMINGTON PUBLIC SCHOOL DISTRICT 270579000220 7 KENNEDY SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 09 12 2019   grade_10 131.0 92.0 115.0   3.0 28.0     0.0   16.0   211.0 174.0     62.0   5.0     216.0   60.0   385.0 131 92 115   3 28     0   16   211 174     62 5   216 60   385
1954733 1954733 MN Ramsey 62 school 2732430 623 Independent Districts and Schools ROSEVILLE PUBLIC SCHOOL DISTRICT 273243001385 69 ROSEVILLE AREA SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 09 12 2019   grade_12 293.0 92.0 60.0   2.0 116.0     0.0   16.0   285.0 294.0     *   *         78.0   579.0 293 92 60   2 116     0   16   285 294             78   579
1945979 1945979 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000110 406 JEFFERSON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   pk_12_total 485.0 91.0 33.0   3.0 56.0     1.0   45.0   352.0 362.0     65.0   11.0     246.0   151.0   714.0 485 91 33   3 56     1   45   352 362     65 11   246 151   714
1946765 1946765 MN Clay 14 school 2721420 152 Independent Districts and Schools MOORHEAD PUBLIC SCHOOL DISTRICT 272142003511 189 S.G.REINERTSEN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 04 2019   pk_12_total 551.0 91.0 27.0   5.0 3.0     0.0   32.0   384.0 325.0     105.0   1.0     264.0   96.0   709.0 551 91 27   5 3     0   32   384 325     105 1   264 96   709
1948024 1948024 MN Hennepin 27 school 2733420 282 Independent Districts and Schools ST. ANTHONY-NEW BRIGHTON SCHOOLS 273342001474 40 WILSHIRE PARK ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   pk_12_total 482.0 91.0 30.0   3.0 53.0     2.0   60.0   356.0 365.0     74.0   7.0     178.0   64.0   721.0 482 91 30   3 53     2   60   356 365     74 7   178 64   721
1948080 1948080 MN Hennepin 27 school 2742160 284 Independent Districts and Schools WAYZATA PUBLIC SCHOOL DISTRICT 274216001761 807 OAKWOOD ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   pk_12_total 359.0 91.0 27.0   0.0 55.0     1.0   28.0   282.0 279.0     67.0   0.0     105.0   57.0   561.0 359 91 27   0 55     1   28   282 279     67 0   105 57   561
1949223 1949223 MN Ramsey 62 school 2732430 623 Independent Districts and Schools ROSEVILLE PUBLIC SCHOOL DISTRICT 273243001386 721 BRIMHALL ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 06 2019   pk_12_total 324.0 91.0 63.0   3.0 84.0     0.0   40.0   326.0 279.0     76.0   3.0     216.0   51.0   605.0 324 91 63   3 84     0   40   326 279     76 3   216 51   605
1953524 1953524 MN Hennepin 27 school 2725200 279 Independent Districts and Schools OSSEO PUBLIC SCHOOL DISTRICT 272520001217 34 Osseo Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_7 193.0 91.0 21.0   10.0 30.0     1.0   23.0   202.0 167.0     18.0   4.0     137.0   46.0   369.0 193 91 21   10 30     1   23   202 167     18 4   137 46   369
1953529 1953529 MN Hennepin 27 school 2725200 279 Independent Districts and Schools OSSEO PUBLIC SCHOOL DISTRICT 272520001214 86 North View Middle School, an IB World School Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_8 8.0 91.0 41.0   4.0 43.0     0.0   9.0   109.0 87.0     48.0   9.0     161.0   31.0   196.0 8 91 41   4 43     0   9   109 87     48 9   161 31   196
1947646 1947646 MN Hennepin 27 school 2714220 272 Independent Districts and Schools EDEN PRAIRIE PUBLIC SCHOOL DISTRICT 271422002241 887 CEDAR RIDGE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 06 2019   pk_12_total 368.0 90.0 60.0   4.0 85.0     0.0   42.0   350.0 299.0     67.0   0.0     124.0   82.0   649.0 368 90 60   4 85     0   42   350 299     67 0   124 82   649
1952946 1952946 MN Ramsey 62 school 2700393 4225 Charter Schools Universal Academy Charter School 270039304758 10 Universal Academy Charter School Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2019   kindergarten 0.0 90.0 0.0   0.0 0.0     0.0   2.0   38.0 54.0     *   0.0         0.0   92.0 0 90 0   0 0     0   2   38 54       0     0   92
1953766 1953766 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384001556 310 BATTLE CREEK MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_7 16.0 90.0 37.0   3.0 99.0     0.0   16.0   126.0 135.0     71.0   3.0     202.0   34.0   261.0 16 90 37   3 99     0   16   126 135     71 3   202 34   261
1954248 1954248 MN Anoka 2 school 2709510 13 Independent Districts and Schools COLUMBIA HEIGHTS PUBLIC SCHOOL DIST 270951000396 16 COLUMBIA HEIGHTS SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 09 12 2019   grade_12 41.0 90.0 64.0   1.0 14.0     0.0   3.0   96.0 117.0     40.0   *     143.0   *   213.0 41 90 64   1 14     0   3   96 117     40     143     213
1954482 1954482 MN Hennepin 27 school 2714220 272 Independent Districts and Schools EDEN PRAIRIE PUBLIC SCHOOL DISTRICT 271422000735 64 EDEN PRAIRIE SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 09 12 2019   grade_12 508.0 90.0 59.0   3.0 74.0     2.0   24.0   407.0 353.0     44.0   1.0     142.0   85.0   760.0 508 90 59   3 74     2   24   407 353     44 1   142 85   760
1944606 1944606 MN Goodhue 25 school 2730480 256 Independent Districts and Schools RED WING PUBLIC SCHOOL DISTRICT 273048001293 108 RED WING SENIOR HIGH Secondary School (Grades 7-12) Regular School No High 08 12 2019   grade_12 139.0 9.0 13.0   6.0 4.0     0.0   4.0   92.0 83.0     4.0   0.0     39.0   26.0   175.0 139 9 13   6 4     0   4   92 83     4 0   39 26   175
1945246 1945246 MN Watonwan 83 school 2718570 837 Independent Districts and Schools MADELIA PUBLIC SCHOOL DISTRICT 271857000860 20 MADELIA SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2019   pk_12_total 126.0 9.0 115.0   1.0 1.0     0.0   2.0   139.0 115.0     *   0.0         *   254.0 126 9 115   1 1     0   2   139 115       0         254
1945402 1945402 MN Pine 58 school 2714070 2165 Independent Districts and Schools HINCKLEY-FINLAYSON SCHOOL DISTRICT 271407000729 20 HINCKLEY-FINLAYSON SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2019   pk_12_total 287.0 9.0 10.0   60.0 3.0     0.0   15.0   201.0 183.0     0.0   13.0     183.0   63.0   384.0 287 9 10   60 3     0   15   201 183     0 13   183 63   384
1945438 1945438 MN Cass 11 school 2728970 2174 Independent Districts and Schools PINE RIVER-BACKUS SCHOOL DISTRICT 272897000041 20 PINE RIVER-BACKUS HIGH SCHOOL Secondary School (Grades 7-12) Regular School No High 07 12 2019   pk_12_total 338.0 9.0 5.0   4.0 1.0     2.0   3.0   180.0 182.0     1.0   8.0     137.0   85.0   362.0 338 9 5   4 1     2   3   180 182     1 8   137 85   362
1945538 1945538 MN Martin 46 school 2700124 2752 Independent Districts and Schools FAIRMONT AREA SCHOOL DISTRICT 270012400553 60 FAIRMONT JR./SR. HIGH SCHOOL Secondary School (Grades 7-12) Regular School No High 07 12 2019   pk_12_total 678.0 9.0 97.0   0.0 12.0     0.0   24.0   394.0 426.0     22.0   28.0     310.0   109.0   820.0 678 9 97   0 12     0   24   394 426     22 28   310 109   820
1945698 1945698 MN Anoka 2 school 2700093 4008 Charter Schools PACT CHARTER SCHOOL 270009303030 30 PACT CHARTER SECONDARY Secondary School (Grades 7-12) Regular School Yes High 07 12 2019   pk_12_total 261.0 9.0 18.0   0.0 5.0     0.0   20.0   152.0 161.0     15.0   0.0     42.0   50.0   313.0 261 9 18   0 5     0   20   152 161     15 0   42 50   313
1945715 1945715 MN Washington 82 school 2700167 4043 Charter Schools MATH AND SCIENCE ACADEMY 270016703035 10 MATH AND SCIENCE ACADEMY Secondary School (Grades 7-12) Regular School Yes High 06 12 2019   grade_10 40.0 9.0 2.0   0.0 16.0     0.0   5.0   34.0 38.0     0.0   0.0     4.0   13.0   72.0 40 9 2   0 16     0   5   34 38     0 0   4 13   72
1945952 1945952 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000105 403 FRANKLIN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   kindergarten 42.0 9.0 10.0   2.0 4.0     1.0   10.0   36.0 42.0     14.0   4.0     45.0   12.0   78.0 42 9 10   2 4     1   10   36 42     14 4   45 12   78
1945962 1945962 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000106 404 HAMILTON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   grade_3 40.0 9.0 11.0   2.0 8.0     0.0   2.0   43.0 29.0     17.0   1.0     46.0   16.0   72.0 40 9 11   2 8     0   2   43 29     17 1   46 16   72
1945968 1945968 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000107 405 Hoover Elementary - Biomedical, Health Sciences and Engineering Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   grade_2 49.0 9.0 3.0   1.0 7.0     0.0   7.0   36.0 40.0     7.0   *     37.0   14.0   76.0 49 9 3   1 7     0   7   36 40     7     37 14   76
1945983 1945983 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000111 407 JOHNSVILLE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   grade_3 110.0 9.0 3.0   0.0 9.0     0.0   8.0   64.0 75.0     9.0   2.0     21.0   14.0   139.0 110 9 3   0 9     0   8   64 75     9 2   21 14   139
1945985 1945985 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000111 407 JOHNSVILLE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   grade_5 112.0 9.0 3.0   2.0 9.0     0.0   4.0   79.0 60.0     7.0   6.0     35.0   19.0   139.0 112 9 3   2 9     0   4   79 60     7 6   35 19   139
1945988 1945988 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000112 408 Lincoln Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   grade_1 55.0 9.0 3.0   1.0 1.0     1.0   8.0   36.0 42.0     4.0   1.0     41.0   12.0   78.0 55 9 3   1 1     1   8   36 42     4 1   41 12   78
1945990 1945990 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000112 408 Lincoln Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   grade_3 45.0 9.0 4.0   2.0 3.0     0.0   3.0   29.0 37.0     8.0   2.0     33.0   12.0   66.0 45 9 4   2 3     0   3   29 37     8 2   33 12   66
1945995 1945995 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000113 410 MADISON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   grade_1 48.0 9.0 9.0   0.0 8.0     0.0   2.0   52.0 24.0     18.0   *     32.0   15.0   76.0 48 9 9   0 8     0   2   52 24     18     32 15   76
1946007 1946007 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000114 411 MCKINLEY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   pk_12_total 626.0 9.0 9.0   3.0 30.0     0.0   26.0   372.0 331.0     17.0   7.0     112.0   75.0   703.0 626 9 9   3 30     0   26   372 331     17 7   112 75   703
1946010 1946010 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000115 412 MISSISSIPPI ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   grade_2 44.0 9.0 6.0   1.0 6.0     0.0   4.0   36.0 34.0     8.0   1.0     35.0   14.0   70.0 44 9 6   1 6     0   4   36 34     8 1   35 14   70
1946013 1946013 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000115 412 MISSISSIPPI ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   grade_5 52.0 9.0 2.0   0.0 3.0     0.0   5.0   37.0 34.0     4.0   2.0     30.0   19.0   71.0 52 9 2   0 3     0   5   37 34     4 2   30 19   71
1946091 1946091 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318002203 426 ANDOVER ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   grade_4 186.0 9.0 10.0   0.0 4.0     0.0   7.0   111.0 105.0     15.0   1.0     29.0   46.0   216.0 186 9 10   0 4     0   7   111 105     15 1   29 46   216
1946210 1946210 MN Anoka 2 school 2733330 16 Independent Districts and Schools SPRING LAKE PARK PUBLIC SCHOOLS 273333001461 772 NORTHPOINT ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 04 2019   grade_4 88.0 9.0 1.0   1.0 9.0     0.0   9.0   53.0 64.0     *   *         *   117.0 88 9 1   1 9     0   9   53 64                 117
1946251 1946251 MN Becker 3 school 2710230 22 Independent Districts and Schools DETROIT LAKES PUBLIC SCHOOL DIST. 271023002268 60 ROOSEVELT ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2019   pk_12_total 376.0 9.0 17.0   85.0 3.0     0.0   62.0   263.0 289.0     5.0   6.0     261.0   119.0   552.0 376 9 17   85 3     0   62   263 289     5 6   261 119   552
1946287 1946287 MN Beltrami 4 school 2704440 31 Independent Districts and Schools BEMIDJI PUBLIC SCHOOL DISTRICT 270444000196 40 J.W. SMITH ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 03 2019   pk_12_total 103.0 9.0 9.0   94.0 0.0     0.0   46.0   134.0 127.0     0.0   6.0     201.0   74.0   261.0 103 9 9   94 0     0   46   134 127     0 6   201 74   261
1946371 1946371 MN Benton 5 school 2732880 47 Independent Districts and Schools SAUK RAPIDS-RICE PUBLIC SCHOOLS 273288001431 7 PLEASANT VIEW ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   grade_4 113.0 9.0 7.0   3.0 4.0     0.0   8.0   70.0 74.0     3.0   0.0     64.0   30.0   144.0 113 9 7   3 4     0   8   70 74     3 0   64 30   144
1946415 1946415 MN Blue Earth 7 school 2718780 77 Independent Districts and Schools MANKATO PUBLIC SCHOOL DISTRICT 271878000876 30 JEFFERSON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   grade_4 32.0 9.0 3.0   0.0 2.0     0.0   0.0   19.0 27.0     *   0.0     19.0   3.0   46.0 32 9 3   0 2     0   0   19 27       0   19 3   46
1946428 1946428 MN Blue Earth 7 school 2718780 77 Independent Districts and Schools MANKATO PUBLIC SCHOOL DISTRICT 271878000883 50 ROOSEVELT ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   grade_3 50.0 9.0 4.0   0.0 0.0     0.0   2.0   29.0 36.0     8.0   0.0     30.0   10.0   65.0 50 9 4   0 0     0   2   29 36     8 0   30 10   65
1946430 1946430 MN Blue Earth 7 school 2718780 77 Independent Districts and Schools MANKATO PUBLIC SCHOOL DISTRICT 271878000883 50 ROOSEVELT ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   grade_5 56.0 9.0 3.0   0.0 0.0     0.0   1.0   45.0 24.0     4.0   1.0     29.0   12.0   69.0 56 9 3   0 0     0   1   45 24     4 1   29 12   69
1946621 1946621 MN Carver 10 school 2708190 112 Independent Districts and Schools EASTERN CARVER COUNTY PUBLIC SCHOOL 270819000342 506 CHANHASSEN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   grade_2 66.0 9.0 2.0   0.0 6.0     0.0   6.0   40.0 49.0     8.0   0.0     14.0   10.0   89.0 66 9 2   0 6     0   6   40 49     8 0   14 10   89
1946750 1946750 MN Clay 14 school 2721420 152 Independent Districts and Schools MOORHEAD PUBLIC SCHOOL DISTRICT 272142003509 187 Robert Asp Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 04 2019   grade_2 76.0 9.0 15.0   6.0 0.0     0.0   7.0   64.0 49.0     10.0   6.0     62.0   24.0   113.0 76 9 15   6 0     0   7   64 49     10 6   62 24   113
1946894 1946894 MN Dakota 19 school 2707290 191 Independent Districts and Schools BURNSVILLE PUBLIC SCHOOL DISTRICT 270729000303 486 VISTA VIEW ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   grade_2 16.0 9.0 7.0   0.0 3.0     0.0   6.0   22.0 19.0     12.0   *     25.0   7.0   41.0 16 9 7   0 3     0   6   22 19     12     25 7   41
1946934 1946934 MN Scott 70 school 2707290 191 Independent Districts and Schools BURNSVILLE PUBLIC SCHOOL DISTRICT 270729002641 491 HARRIET BISHOP ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   grade_1 36.0 9.0 10.0   0.0 10.0     0.0   6.0   28.0 43.0     15.0   1.0     21.0   8.0   71.0 36 9 10   0 10     0   6   28 43     15 1   21 8   71
1946938 1946938 MN Scott 70 school 2707290 191 Independent Districts and Schools BURNSVILLE PUBLIC SCHOOL DISTRICT 270729002641 491 HARRIET BISHOP ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   grade_5 45.0 9.0 6.0   0.0 8.0     0.0   5.0   49.0 24.0     10.0   0.0     18.0   6.0   73.0 45 9 6   0 8     0   5   49 24     10 0   18 6   73
1947064 1947064 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239001377 706 NORTHVIEW ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   grade_5 39.0 9.0 1.0   0.0 6.0     0.0   3.0   26.0 32.0     3.0   0.0     11.0   11.0   58.0 39 9 1   0 6     0   3   26 32     3 0   11 11   58
1947067 1947067 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239001384 707 WESTVIEW ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   grade_1 50.0 9.0 12.0   1.0 4.0     0.0   10.0   43.0 43.0     11.0   0.0     34.0   13.0   86.0 50 9 12   1 4     0   10   43 43     11 0   34 13   86
1947080 1947080 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239001378 709 PARKVIEW ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   kindergarten 75.0 9.0 10.0   1.0 6.0     0.0   11.0   56.0 56.0     10.0   0.0     24.0   20.0   112.0 75 9 10   1 6     0   11   56 56     10 0   24 20   112
1947085 1947085 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239001378 709 PARKVIEW ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   grade_5 94.0 9.0 13.0   1.0 14.0     0.0   10.0   72.0 69.0     4.0   1.0     34.0   16.0   141.0 94 9 13   1 14     0   10   72 69     4 1   34 16   141
1947125 1947125 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239002185 715 HIGHLAND ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   grade_1 93.0 9.0 9.0   0.0 8.0     1.0   6.0   59.0 67.0     14.0   0.0     17.0   12.0   126.0 93 9 9   0 8     1   6   59 67     14 0   17 12   126
1947126 1947126 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239002185 715 HIGHLAND ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   grade_2 78.0 9.0 9.0   0.0 14.0     0.0   11.0   65.0 56.0     8.0   0.0     15.0   20.0   121.0 78 9 9   0 14     0   11   65 56     8 0   15 20   121
1947131 1947131 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239000511 716 DEERWOOD ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   kindergarten 68.0 9.0 16.0   0.0 10.0     0.0   6.0   58.0 51.0     9.0   0.0     22.0   14.0   109.0 68 9 16   0 10     0   6   58 51     9 0   22 14   109
1947225 1947225 MN Dakota 19 school 2715030 199 Independent Districts and Schools INVER GROVE HEIGHTS SCHOOLS 271503000763 575 HILLTOP ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   kindergarten 59.0 9.0 24.0   2.0 7.0     0.0   11.0   50.0 62.0     16.0   0.0     36.0   20.0   112.0 59 9 24   2 7     0   11   50 62     16 0   36 20   112
1947235 1947235 MN Dakota 19 school 2715030 199 Independent Districts and Schools INVER GROVE HEIGHTS SCHOOLS 271503000547 577 PINE BEND ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   grade_1 63.0 9.0 20.0   0.0 3.0     0.0   3.0   45.0 53.0     9.0   0.0         11.0   98.0 63 9 20   0 3     0   3   45 53     9 0     11   98
1947436 1947436 MN Goodhue 25 school 2730480 256 Independent Districts and Schools RED WING PUBLIC SCHOOL DISTRICT 273048001292 537 BURNSIDE ELEMENTARY. Elementary School (Grades PK-6) Regular School No Elementary 02 04 2019   grade_3 151.0 9.0 14.0   2.0 0.0     0.0   11.0   85.0 102.0     3.0   0.0     63.0   28.0   187.0 151 9 14   2 0     0   11   85 102     3 0   63 28   187
1947475 1947475 MN Hennepin 27 school 2714260 270 Independent Districts and Schools HOPKINS PUBLIC SCHOOL DISTRICT 271426001881 563 GLEN LAKE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   grade_5 53.0 9.0 1.0   0.0 4.0     0.0   1.0   31.0 37.0     *   0.0     12.0   7.0   68.0 53 9 1   0 4     0   1   31 37       0   12 7   68
1947520 1947520 MN Hennepin 27 school 2714260 270 Independent Districts and Schools HOPKINS PUBLIC SCHOOL DISTRICT 271426001884 570 MEADOWBROOK ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   grade_6 74.0 9.0 4.0   2.0 2.0     0.0   11.0   57.0 45.0     0.0   0.0     13.0   15.0   102.0 74 9 4   2 2     0   11   57 45     0 0   13 15   102
1947532 1947532 MN Hennepin 27 school 2705790 271 Independent Districts and Schools BLOOMINGTON PUBLIC SCHOOL DISTRICT 270579002292 443 HILLCREST ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   grade_2 48.0 9.0 3.0   1.0 2.0     0.0   7.0   42.0 28.0     *   0.0     16.0   8.0   70.0 48 9 3   1 2     0   7   42 28       0   16 8   70

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