Data source: Big Local News · About: Big Local

13,757 rows where state = "MN" and year = 2017 sorted by free_and_reduced descending

View and edit SQL

year

  • 2017 · 13,757
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
692885 MN Kandiyohi 34 school 2742720 347 Independent Districts and Schools WILLMAR PUBLIC SCHOOL DISTRICT 274272002445 109 KENNEDY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_3 39.0 27.0 59.0   1.0 4.0     0.0   5.0   75.0 60.0     56.0   2.0     99.0   11.0   135.0 39 27 59   1 4     0   5   75 60     56 2   99 11   135
693338 MN Olmsted 55 school 2711010 533 Independent Districts and Schools DOVER-EYOTA PUBLIC SCHOOL DISTRICT 271101000453 20 DOVER-EYOTA ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   pk_12_total 481.0 1.0 9.0   0.0 0.0     0.0   27.0   272.0 246.0     7.0   0.0     99.0   60.0   518.0 481 1 9   0 0     0   27   272 246     7 0   99 60   518
693587 MN Pipestone 59 school 2711220 581 Independent Districts and Schools EDGERTON PUBLIC SCHOOL DISTRICT 271122000503 20 EDGERTON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   pk_12_total 132.0 8.0 48.0   2.0 0.0     0.0   9.0   111.0 88.0     28.0   3.0     99.0   36.0   199.0 132 8 48   2 0     0   9   111 88     28 3   99 36   199
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
696498 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124004885 215 WEBSTER ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 03 2017   pk_12_total 68.0 44.0 20.0   8.0 9.0     0.0   15.0   88.0 76.0     33.0   6.0     99.0   37.0   164.0 68 44 20   8 9     0   15   88 76     33 6   99 37   164
697867 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239002437 32 BLACK HAWK MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_6 164.0 50.0 26.0   1.0 25.0     0.0   28.0   146.0 148.0     25.0   *     99.0   48.0   294.0 164 50 26   1 25     0   28   146 148     25     99 48   294
697897 MN Dakota 19 school 2715030 199 Independent Districts and Schools INVER GROVE HEIGHTS SCHOOLS 271503000765 27 INVER GROVE HEIGHTS MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_6 149.0 15.0 64.0   1.0 8.0     0.0   22.0   126.0 133.0     21.0   2.0     99.0   41.0   259.0 149 15 64   1 8     0   22   126 133     21 2   99 41   259
697899 MN Dakota 19 school 2715030 199 Independent Districts and Schools INVER GROVE HEIGHTS SCHOOLS 271503000765 27 INVER GROVE HEIGHTS MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_8 174.0 18.0 57.0   0.0 13.0     0.0   16.0   127.0 151.0     23.0   2.0     99.0   28.0   278.0 174 18 57   0 13     0   16   127 151     23 2   99 28   278
698345 MN Winona 85 school 2744070 861 Independent Districts and Schools WINONA AREA PUBLIC SCHOOL DISTRICT 274407001830 6 WINONA MIDDLE Middle School (Grades 5-8) Regular School No Middle 05 08 2017   grade_7 225.0 7.0 6.0   2.0 11.0     0.0   11.0   148.0 114.0     6.0   0.0     99.0   55.0   262.0 225 7 6   2 11     0   11   148 114     6 0   99 55   262
698658 MN Anoka 2 school 2708100 12 Independent Districts and Schools CENTENNIAL PUBLIC SCHOOL DISTRICT 270810000334 164 CENTENNIAL HIGH SCHOOL Senior High School (Grades 9-12) Regular School No High 09 12 2017   grade_9 430.0 19.0 23.0   6.0 36.0     0.0   19.0   276.0 257.0     8.0   2.0     99.0   85.0   533.0 430 19 23   6 36     0   19   276 257     8 2   99 85   533
698764 MN Cass 11 school 2728350 116 Independent Districts and Schools PILLAGER PUBLIC SCHOOL DISTRICT 272835001254 20 Pillager Senior High School Senior High School (Grades 9-12) Regular School No High 09 12 2017   pk_12_total 264.0 2.0 6.0   2.0 1.0     0.0   6.0   158.0 123.0     0.0   0.0     99.0   45.0   281.0 264 2 6   2 1     0   6   158 123     0 0   99 45   281
699328 MN Washington 82 school 2733810 833 Independent Districts and Schools SOUTH WASHINGTON COUNTY SCHOOL DIST 273381001550 29 WOODBURY SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 09 12 2017   grade_10 316.0 62.0 33.0   0.0 65.0     0.0   25.0   260.0 241.0     19.0   1.0     99.0   51.0   501.0 316 62 33   0 65     0   25   260 241     19 1   99 51   501
689491 MN Mille Lacs 48 school 2715510 473 Independent Districts and Schools ISLE PUBLIC SCHOOL DISTRICT 271551000770 20 ISLE SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   pk_12_total 180.0 2.0 5.0   13.0 3.0     0.0   7.0   115.0 95.0     0.0   7.0     98.0   39.0   210.0 180 2 5   13 3     0   7   115 95     0 7   98 39   210
690286 MN Cottonwood 17 school 2700183 2898 Independent Districts and Schools WESTBROOK-WALNUT GROVE SCHOOLS 270018301782 30 WESTBROOK-WALNUT GROVE SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   pk_12_total 134.0 1.0 2.0   0.0 45.0     1.0   0.0   101.0 82.0     23.0   0.0     98.0   25.0   183.0 134 1 2   0 45     1   0   101 82     23 0   98 25   183
690859 MN Anoka 2 school 2733330 16 Independent Districts and Schools SPRING LAKE PARK PUBLIC SCHOOLS 273333001462 775 Park Terrace Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 03 2017   grade_2 80.0 28.0 24.0   1.0 16.0     0.0   18.0   88.0 79.0     30.0   1.0     98.0   23.0   167.0 80 28 24   1 16     0   18   88 79     30 1   98 23   167
696356 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124000991 136 KENWOOD ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   pk_12_total 285.0 61.0 28.0   4.0 23.0     2.0   26.0   193.0 236.0     13.0   7.0     98.0   32.0   429.0 285 61 28   4 23     2   26   193 236     13 7   98 32   429
696834 MN Beltrami 4 school 2700225 4058 Charter Schools SCHOOLCRAFT LEARNING COMMUNITY CHTR 270022503464 10 SCHOOLCRAFT LEARNING COMMUNITY CHTR Elementary School (Grades PK-6) Regular School Yes Other KG 09 2017   pk_12_total 141.0 0.0 12.0   22.0 0.0     0.0   16.0   90.0 101.0     0.0   0.0     98.0   56.0   191.0 141 0 12   22 0     0   16   90 101     0 0   98 56   191
697910 MN Dodge 20 school 2716980 204 Independent Districts and Schools KASSON-MANTORVILLE SCHOOL DISTRICT 271698002243 40 KASSON-MANTORVILLE MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 05 08 2017   pk_12_total 611.0 5.0 24.0   0.0 6.0     0.0   12.0   315.0 343.0     8.0   0.0     98.0   52.0   658.0 611 5 24   0 6     0   12   315 343     8 0   98 52   658
697933 MN Hennepin 27 school 2705790 271 Independent Districts and Schools BLOOMINGTON PUBLIC SCHOOL DISTRICT 270579000226 13 OAK GROVE MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_8 150.0 46.0 37.0   2.0 17.0     0.0   9.0   141.0 120.0     21.0   *     98.0   55.0   261.0 150 46 37   2 17     0   9   141 120     21     98 55   261
698325 MN Washington 82 school 2733810 833 Independent Districts and Schools SOUTH WASHINGTON COUNTY SCHOOL DIST 273381002465 20 COTTAGE GROVE MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_7 279.0 25.0 33.0   4.0 35.0     0.0   29.0   199.0 206.0     26.0   1.0     98.0   49.0   405.0 279 25 33   4 35     0   29   199 206     26 1   98 49   405
699089 MN Olmsted 55 school 2731800 535 Independent Districts and Schools ROCHESTER PUBLIC SCHOOL DISTRICT 273180002660 305 CENTURY SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 08 12 2017   grade_10 268.0 40.0 12.0   2.0 40.0     0.0   7.0   180.0 189.0     27.0   2.0     98.0   34.0   369.0 268 40 12   2 40     0   7   180 189     27 2   98 34   369
700137 MN Saint Louis 69 school 2711040 709 Independent Districts and Schools DULUTH PUBLIC SCHOOL DISTRICT 271104002237 611 DULUTH AREA LEARNING CENTER Public Area Learning Center ALC (State approved) Alternative School No Other 06 12 2017   grade_9 76.0 24.0 5.0   21.0 1.0     0.0   9.0   82.0 54.0     1.0   9.0     98.0   59.0   136.0 76 24 5   21 1     0   9   82 54     1 9   98 59   136
700140 MN Saint Louis 69 school 2711040 709 Independent Districts and Schools DULUTH PUBLIC SCHOOL DISTRICT 271104002237 611 DULUTH AREA LEARNING CENTER Public Area Learning Center ALC (State approved) Alternative School No Other 06 12 2017   grade_12 90.0 10.0 4.0   18.0 3.0     0.0   13.0   71.0 67.0     2.0   42.0     98.0   32.0   138.0 90 10 4   18 3     0   13   71 67     2 42   98 32   138
689838 MN Swift 76 school 2704470 777 Independent Districts and Schools BENSON PUBLIC SCHOOL DISTRICT 270447000199 101 BENSON SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   pk_12_total 331.0 4.0 17.0   0.0 3.0     0.0   6.0   178.0 183.0     0.0   *     97.0   56.0   361.0 331 4 17   0 3     0   6   178 183     0     97 56   361
691582 MN Dakota 19 school 2711820 192 Independent Districts and Schools FARMINGTON PUBLIC SCHOOL DISTRICT 271182002642 40 NORTH TRAIL ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   pk_12_total 457.0 25.0 37.0   0.0 41.0     0.0   48.0   336.0 272.0     46.0   0.0     97.0   91.0   608.0 457 25 37   0 41     0   48   336 272     46 0   97 91   608
692578 MN Hennepin 27 school 2731780 281 Independent Districts and Schools ROBBINSDALE PUBLIC SCHOOL DISTRICT 273178001330 19 NORTHPORT ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_3 14.0 32.0 35.0   0.0 22.0     0.0   12.0   63.0 52.0     49.0   6.0     97.0   9.0   115.0 14 32 35   0 22     0   12   63 52     49 6   97 9   115
693007 MN Lyon 42 school 2718940 413 Independent Districts and Schools MARSHALL PUBLIC SCHOOL DISTRICT 271894000891 2 PARK SIDE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 02 2017   grade_2 111.0 20.0 26.0   1.0 14.0     0.0   12.0   99.0 85.0     41.0   0.0     97.0   25.0   184.0 111 20 26   1 14     0   12   99 85     41 0   97 25   184
693491 MN Otter Tail 56 school 2711880 544 Independent Districts and Schools FERGUS FALLS PUBLIC SCHOOL DISTRICT 271188000581 180 MCKINLEY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 01 2017   pk_12_total 213.0 7.0 6.0   1.0 0.0     2.0   6.0   117.0 118.0         0.0     97.0   18.0   235.0 213 7 6   1 0     2   6   117 118       0   97 18   235
693569 MN Pine 58 school 2742750 577 Independent Districts and Schools WILLOW RIVER PUBLIC SCHOOL DISTRICT 274275001811 30 WILLOW RIVER ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   pk_12_total 223.0 0.0 2.0   3.0 0.0     0.0   5.0   119.0 114.0     1.0   0.0     97.0   36.0   233.0 223 0 2   3 0     0   5   119 114     1 0   97 36   233
694906 MN Todd 77 school 2706300 787 Independent Districts and Schools BROWERVILLE PUBLIC SCHOOL DISTRICT 270630000277 10 BROWERVILLE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   pk_12_total 189.0 0.0 5.0   0.0 2.0     0.0   1.0   115.0 82.0     0.0   0.0     97.0   39.0   197.0 189 0 5   0 2     0   1   115 82     0 0   97 39   197
696978 MN Ramsey 62 school 2700342 4103 Charter Schools HMONG COLLEGE PREP ACADEMY 270034203700 20 HMONG COLLEGE PREP MIDDLE ACADEMY Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2017   grade_5 0.0 0.0 1.0   0.0 110.0     0.0   0.0   56.0 55.0     35.0   1.0     97.0   12.0   111.0 0 0 1   0 110     0   0   56 55     35 1   97 12   111
696981 MN Ramsey 62 school 2700342 4103 Charter Schools HMONG COLLEGE PREP ACADEMY 270034203700 20 HMONG COLLEGE PREP MIDDLE ACADEMY Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2017   grade_8 0.0 0.0 0.0   0.0 115.0     0.0   0.0   70.0 45.0     45.0   1.0     97.0   12.0   115.0 0 0 0   0 115     0   0   70 45     45 1   97 12   115
697876 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239002644 86 FALCON RIDGE MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_7 238.0 41.0 59.0   2.0 25.0     0.0   20.0   200.0 185.0     24.0   2.0     97.0   56.0   385.0 238 41 59   2 25     0   20   200 185     24 2   97 56   385
697895 MN Dakota 19 school 2742270 197 Independent Districts and Schools WEST ST. PAUL-MENDOTA HTS.-EAGAN 274227001774 54 HERITAGE E-STEM MAGNET SCHOOL Middle School (Grades 5-8) Regular School No Middle 05 08 2017   grade_8 67.0 16.0 80.0   3.0 7.0     0.0   4.0   97.0 80.0     32.0   2.0     97.0   39.0   177.0 67 16 80   3 7     0   4   97 80     32 2   97 39   177
698326 MN Washington 82 school 2733810 833 Independent Districts and Schools SOUTH WASHINGTON COUNTY SCHOOL DIST 273381002465 20 COTTAGE GROVE MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_8 280.0 27.0 44.0   1.0 34.0     2.0   16.0   206.0 198.0     12.0   3.0     97.0   57.0   404.0 280 27 44   1 34     2   16   206 198     12 3   97 57   404
698395 MN Dodge 20 school 2740665 2125 Independent Districts and Schools TRITON SCHOOL DISTRICT 274066500035 2 TRITON MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 06 08 2017   pk_12_total 220.0 2.0 52.0   1.0 0.0     0.0   11.0   149.0 137.0     13.0   1.0     97.0   41.0   286.0 220 2 52   1 0     0   11   149 137     13 1   97 41   286
698987 MN Itasca 31 school 2713170 318 Independent Districts and Schools GRAND RAPIDS PUBLIC SCHOOL DISTRICT 271317000935 360 GRAND RAPIDS SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 09 12 2017   grade_10 246.0 4.0 2.0   11.0 0.0     0.0   20.0   133.0 150.0     0.0   0.0     97.0   39.0   283.0 246 4 2   11 0     0   20   133 150     0 0   97 39   283
699087 MN Olmsted 55 school 2738160 534 Independent Districts and Schools STEWARTVILLE PUBLIC SCHOOL DISTRICT 273816001653 30 STEWARTVILLE SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 09 12 2017   pk_12_total 518.0 7.0 12.0   2.0 6.0     0.0   7.0   307.0 245.0     2.0   0.0     97.0   46.0   552.0 518 7 12   2 6     0   7   307 245     2 0   97 46   552
702609 MN Mcleod 43 school 2700128 2859 Independent Districts and Schools GLENCOE-SILVER LAKE SCHOOL DISTRICT 270012801445 40 LINCOLN JUNIOR HIGH Junior High School (Grades 7-8 or 7-9) Regular School No Middle 07 08 2017   pk_12_total 211.0 2.0 48.0   0.0 0.0     0.0   5.0   124.0 142.0     8.0   0.0     97.0   31.0   266.0 211 2 48   0 0     0   5   124 142     8 0   97 31   266
698657 MN Hennepin 27 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000021 192 Champlin Park High School Senior High School (Grades 9-12) Regular School No High 09 12 2017   pk_12_total 1620.0 521.0 168.0   16.0 402.0     1.0   73.0   1438.0 1363.0     119.0   23.0     967.0   296.0   2801.0 1620 521 168   16 402     1   73   1438 1363     119 23   967 296   2801
699147 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 2017   pk_12_total 1146.0 354.0 236.0   11.0 446.0     0.0   94.0   1121.0 1166.0     200.0   14.0     960.0   270.0   2287.0 1146 354 236   11 446     0   94   1121 1166     200 14   960 270   2287
689094 MN Carlton 9 school 2707590 93 Independent Districts and Schools CARLTON PUBLIC SCHOOL DISTRICT 270759000327 1 CARLTON SECONDARY Secondary School (Grades 7-12) Regular School No Other 06 12 2017   pk_12_total 220.0 1.0 3.0   33.0 3.0     0.0   7.0   150.0 117.0         0.0     96.0   45.0   267.0 220 1 3   33 3     0   7   150 117       0   96 45   267
689596 MN Otter Tail 56 school 2723520 553 Independent Districts and Schools NEW YORK MILLS PUBLIC SCHOOL DIST. 272352001156 20 NEW YORK MILLS SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   pk_12_total 302.0 2.0 6.0   3.0 0.0     0.0   5.0   161.0 157.0     0.0   1.0     96.0   35.0   318.0 302 2 6   3 0     0   5   161 157     0 1   96 35   318
689750 MN Saint Louis 69 school 2713980 701 Independent Districts and Schools HIBBING PUBLIC SCHOOL DISTRICT 271398001539 350 HIBBING HIGH Secondary School (Grades 7-12) Regular School No High 07 12 2017   grade_7 177.0 4.0 3.0   4.0 0.0     0.0   11.0   103.0 96.0     0.0   4.0     96.0   26.0   199.0 177 4 3   4 0     0   11   103 96     0 4   96 26   199
690818 MN Anoka 2 school 2712420 14 Independent Districts and Schools FRIDLEY PUBLIC SCHOOL DISTRICT 271242000614 550 STEVENSON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2017   grade_3 47.0 47.0 19.0   2.0 5.0     0.0   7.0   64.0 63.0     31.0   4.0     96.0   19.0   127.0 47 47 19   2 5     0   7   64 63     31 4   96 19   127
693306 MN Nobles 53 school 2702730 511 Independent Districts and Schools ADRIAN PUBLIC SCHOOL DISTRICT 270273000055 10 ADRIAN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   pk_12_total 208.0 0.0 24.0   1.0 7.0     0.0   11.0   118.0 133.0     13.0   0.0     96.0   30.0   251.0 208 0 24   1 7     0   11   118 133     13 0   96 30   251
696321 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124000969 121 LAKE HARRIET UPPER SCHOOL Elementary School (Grades PK-6) Regular School No Elementary 04 08 2017   pk_12_total 578.0 28.0 31.0   2.0 27.0     1.0   16.0   348.0 335.0     17.0   2.0     96.0   67.0   683.0 578 28 31   2 27     1   16   348 335     17 2   96 67   683
697335 MN Rice 66 school 2700324 4194 Charter Schools CANNON RIVER STEM SCHOOL 270032404271 10 CANNON RIVER STEM SCHOOL Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2017   pk_12_total 301.0 9.0 26.0   2.0 1.0     0.0   7.0   190.0 156.0     14.0   2.0     96.0   42.0   346.0 301 9 26   2 1     0   7   190 156     14 2   96 42   346
698961 MN Hennepin 27 school 2742160 284 Independent Districts and Schools WAYZATA PUBLIC SCHOOL DISTRICT 274216001765 50 WAYZATA HIGH Senior High School (Grades 9-12) Regular School No High 09 12 2017   grade_9 591.0 56.0 31.0   1.0 134.0     0.0   31.0   426.0 418.0     12.0   1.0     96.0   61.0   844.0 591 56 31   1 134     0   31   426 418     12 1   96 61   844
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
699351 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   grade_9 423.0 6.0 18.0   4.0 6.0     1.0   5.0   239.0 224.0     3.0   0.0     96.0   60.0   463.0 423 6 18   4 6     1   5   239 224     3 0   96 60   463
701874 MN Ramsey 62 school 2700117 4017 Charter Schools Minnesota Transitions Charter School 270011703694 18 MTCS CONNECTIONS ACADEMY Distance Learning Program OLL (State approved) Regular School Yes Other KG 12 2017   grade_8 140.0 10.0 26.0   6.0 5.0     0.0   15.0   91.0 111.0     2.0   4.0     96.0   22.0   202.0 140 10 26   6 5     0   15   91 111     2 4   96 22   202
702570 MN Steele 74 school 2728050 761 Independent Districts and Schools OWATONNA PUBLIC SCHOOL DISTRICT 272805001227 151 OWATONNA JUNIOR HIGH Junior High School (Grades 7-8 or 7-9) Regular School No Middle 07 08 2017   grade_8 225.0 29.0 35.0   1.0 5.0     0.0   7.0   155.0 147.0     25.0   *     96.0   36.0   302.0 225 29 35   1 5     0   7   155 147     25     96 36   302
690784 MN Anoka 2 school 2709510 13 Independent Districts and Schools COLUMBIA HEIGHTS PUBLIC SCHOOL DIST 270951000398 515 HIGHLAND ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_3 21.0 33.0 31.0   4.0 11.0     0.0   14.0   63.0 51.0     55.0   2.0     95.0   19.0   114.0 21 33 31   4 11     0   14   63 51     55 2   95 19   114
691374 MN Clay 14 school 2713560 150 Independent Districts and Schools HAWLEY PUBLIC SCHOOL DISTRICT 271356000698 10 HAWLEY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   pk_12_total 479.0 1.0 12.0   1.0 2.0     1.0   15.0   279.0 232.0     4.0   0.0     95.0   52.0   511.0 479 1 12   1 2     1   15   279 232     4 0   95 52   511
691771 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239002216 717 WOODLAND ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   pk_12_total 435.0 39.0 44.0   4.0 61.0     1.0   31.0   338.0 277.0     34.0   6.0     95.0   73.0   615.0 435 39 44   4 61     1   31   338 277     34 6   95 73   615
692024 MN Freeborn 24 school 2703030 242 Independent Districts and Schools ALDEN-CONGER PUBLIC SCHOOL DISTRICT 270303000079 2 ALDEN-CONGER ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   pk_12_total 254.0 0.0 13.0   0.0 0.0     0.0   2.0   129.0 140.0     0.0   0.0     95.0   43.0   269.0 254 0 13   0 0     0   2   129 140     0 0   95 43   269
692579 MN Hennepin 27 school 2731780 281 Independent Districts and Schools ROBBINSDALE PUBLIC SCHOOL DISTRICT 273178001330 19 NORTHPORT ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_4 7.0 44.0 35.0   1.0 13.0     0.0   8.0   58.0 50.0     30.0   7.0     95.0   14.0   108.0 7 44 35   1 13     0   8   58 50     30 7   95 14   108
692712 MN Houston 28 school 2714280 294 Independent Districts and Schools HOUSTON PUBLIC SCHOOL DISTRICT 271428000748 10 HOUSTON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   pk_12_total 230.0 0.0 11.0   0.0 0.0     0.0   1.0   119.0 123.0     0.0   0.0     95.0   51.0   242.0 230 0 11   0 0     0   1   119 123     0 0   95 51   242
693599 MN Polk 60 school 2709720 593 Independent Districts and Schools CROOKSTON PUBLIC SCHOOL DISTRICT 270972000416 10 WASHINGTON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 01 2017   pk_12_total 106.0 10.0 38.0   6.0 0.0     0.0   5.0   85.0 80.0     10.0   17.0     95.0   28.0   165.0 106 10 38   6 0     0   5   85 80     10 17   95 28   165
694053 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384001594 494 CAPITOL HILL MAGNET/RONDO Elementary School (Grades PK-6) Regular School No Elementary 01 08 2017   grade_6 82.0 56.0 13.0   0.0 49.0     0.0   2.0   111.0 91.0     22.0   0.0     95.0   11.0   202.0 82 56 13   0 49     0   2   111 91     22 0   95 11   202
694121 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384001619 541 PHALEN LAKE HMONG STUDIES MAGNET Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_4 2.0 5.0 12.0   1.0 89.0     0.0   3.0   60.0 52.0     86.0   0.0     95.0   9.0   112.0 2 5 12   1 89     0   3   60 52     86 0   95 9   112
695236 MN Watonwan 83 school 2707320 836 Independent Districts and Schools BUTTERFIELD PUBLIC SCHOOL DISTRICT 270732000304 10 BUTTERFIELD ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   pk_12_total 45.0 1.0 72.0   0.0 3.0     0.0   2.0   66.0 57.0     32.0   0.0     95.0   36.0   123.0 45 1 72   0 3     0   2   66 57     32 0   95 36   123
697881 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239001943 93 SCOTT HIGHLANDS MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_8 239.0 39.0 20.0   0.0 33.0     1.0   22.0   173.0 181.0         3.0     95.0   56.0   354.0 239 39 20   0 33     1   22   173 181       3   95 56   354
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
698674 MN Anoka 2 school 2733540 15 Independent Districts and Schools ST. FRANCIS PUBLIC SCHOOL DISTRICT 273354000012 122 ST. FRANCIS HIGH Senior High School (Grades 9-12) Regular School No High 09 12 2017   grade_9 335.0 2.0 8.0   2.0 9.0     0.0   10.0   194.0 172.0     4.0   3.0     95.0   39.0   366.0 335 2 8   2 9     0   10   194 172     4 3   95 39   366
699101 MN Olmsted 55 school 2731800 535 Independent Districts and Schools ROCHESTER PUBLIC SCHOOL DISTRICT 273180001016 315 MAYO SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 08 12 2017   grade_12 265.0 46.0 36.0   0.0 30.0     0.0   6.0   190.0 193.0     15.0   7.0     95.0   45.0   383.0 265 46 36   0 30     0   6   190 193     15 7   95 45   383
699182 MN Rice 66 school 2711760 656 Independent Districts and Schools FARIBAULT PUBLIC SCHOOL DISTRICT 271176000558 80 FARIBAULT SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 09 12 2017   grade_12 181.0 43.0 48.0   1.0 6.0     0.0   1.0   143.0 137.0     22.0   6.0     95.0   29.0   280.0 181 43 48   1 6     0   1   143 137     22 6   95 29   280
699267 MN Stearns 73 school 2728140 741 Independent Districts and Schools PAYNESVILLE PUBLIC SCHOOL DISTRICT 272814001239 20 PAYNESVILLE AREA HIGH SCHOOL Senior High School (Grades 9-12) Regular School No High 09 12 2017   pk_12_total 281.0 3.0 12.0   1.0 4.0     0.0   1.0   156.0 146.0     2.0   7.0     95.0   48.0   302.0 281 3 12   1 4     0   1   156 146     2 7   95 48   302
699525 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124000977 354 HENRY SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 09 12 2017   pk_12_total 85.0 573.0 106.0   17.0 366.0     0.0   5.0   598.0 554.0     160.0   74.0     942.0   240.0   1152.0 85 573 106   17 366     0   5   598 554     160 74   942 240   1152
693009 MN Lyon 42 school 2718940 413 Independent Districts and Schools MARSHALL PUBLIC SCHOOL DISTRICT 271894000894 3 WEST SIDE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 03 04 2017   grade_3 108.0 27.0 28.0   1.0 12.0     0.0   9.0   90.0 95.0     38.0   3.0     94.0   28.0   185.0 108 27 28   1 12     0   9   90 95     38 3   94 28   185
697247 MN Ramsey 62 school 2700304 4181 Charter Schools COMMUNITY SCHOOL OF EXCELLENCE 270030403728 10 COMMUNITY SCHOOL OF EXCELLENCE Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2017   grade_6 0.0 0.0 0.0   0.0 126.0     0.0   0.0   69.0 57.0     69.0   0.0     94.0   14.0   126.0 0 0 0   0 126     0   0   69 57     69 0   94 14   126
697305 MN Hennepin 27 school 2700316 4189 Charter Schools BRIGHT WATER ELEMENTARY 270031604319 10 BRIGHT WATER ELEMENTARY Elementary School (Grades PK-6) Regular School Yes Elementary KG 06 2017   pk_12_total 69.0 75.0 16.0   1.0 2.0     0.0   12.0   93.0 82.0     10.0   8.0     94.0   27.0   175.0 69 75 16   1 2     0   12   93 82     10 8   94 27   175
697748 MN Nicollet 52 school 2718780 77 Independent Districts and Schools MANKATO PUBLIC SCHOOL DISTRICT 271878002046 190 Dakota Meadows Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_8 249.0 30.0 10.0   1.0 6.0     0.0   7.0   166.0 137.0     6.0   *     94.0   40.0   303.0 249 30 10   1 6     0   7   166 137     6     94 40   303
697955 MN Hennepin 27 school 2711250 273 Independent Districts and Schools EDINA PUBLIC SCHOOL DISTRICT 271125002035 20 VALLEY VIEW MIDDLE Middle School (Grades 5-8) Regular School No Other 06 09 2017   pk_12_total 1059.0 78.0 61.0   2.0 130.0     0.0   63.0   653.0 740.0     30.0   1.0     94.0   99.0   1393.0 1059 78 61   2 130     0   63   653 740     30 1   94 99   1393
698139 MN Olmsted 55 school 2731800 535 Independent Districts and Schools ROCHESTER PUBLIC SCHOOL DISTRICT 273180001020 335 KELLOGG MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_7 169.0 36.0 30.0   0.0 27.0     0.0   10.0   138.0 134.0     34.0   8.0     94.0   42.0   272.0 169 36 30   0 27     0   10   138 134     34 8   94 42   272
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
698474 MN Jackson 32 school 2700231 2895 Independent Districts and Schools JACKSON COUNTY CENTRAL SCHOOL DIST. 270023102042 115 JACKSON COUNTY CENTRAL MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   pk_12_total 227.0 1.0 11.0   0.0 7.0     0.0   14.0   146.0 114.0     2.0   0.0     94.0   56.0   260.0 227 1 11   0 7     0   14   146 114     2 0   94 56   260
699071 MN Nobles 53 school 2744160 518 Independent Districts and Schools WORTHINGTON PUBLIC SCHOOL DISTRICT 274416001841 8 WORTHINGTON SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 09 12 2017   grade_12 83.0 9.0 76.0   0.0 22.0     0.0   1.0   91.0 100.0     22.0   *     94.0   17.0   191.0 83 9 76   0 22     0   1   91 100     22     94 17   191
699450 MN Lesueur 40 school 2718070 2397 Independent Districts and Schools LE SUEUR-HENDERSON SCHOOL DISTRICT 271807000047 20 LE SUEUR-HENDERSON HIGH SCHOOL Senior High School (Grades 9-12) Regular School No High 09 12 2017   pk_12_total 243.0 8.0 51.0   0.0 2.0     0.0   15.0   156.0 163.0     15.0   5.0     94.0   45.0   319.0 243 8 51   0 2     0   15   156 163     15 5   94 45   319
699964 MN Kandiyohi 34 school 2742720 347 Independent Districts and Schools WILLMAR PUBLIC SCHOOL DISTRICT 274272000950 949 WILLMAR AREA LEARNING CENTER Public Area Learning Center ALC (State approved) Alternative School No High 07 12 2017   pk_12_total 36.0 6.0 71.0   3.0 0.0     0.0   1.0   54.0 63.0     16.0   0.0     94.0   27.0   117.0 36 6 71   3 0     0   1   54 63     16 0   94 27   117
700616 MN Hennepin 27 school 2731780 281 Independent Districts and Schools ROBBINSDALE PUBLIC SCHOOL DISTRICT 273178002441 103 EARLY CHILDHOOD SPECIAL EDUCATION Special Education Special Education School No Elementary PK KG 2017   early_childhood_special_ed 103.0 56.0 31.0   1.0 18.0     0.0   19.0   164.0 64.0     0.0   2.0     94.0   *   228.0 103 56 31   1 18     0   19   164 64     0 2   94     228
700617 MN Hennepin 27 school 2731780 281 Independent Districts and Schools ROBBINSDALE PUBLIC SCHOOL DISTRICT 273178002441 103 EARLY CHILDHOOD SPECIAL EDUCATION Special Education Special Education School No Elementary PK KG 2017   pk_12_total 103.0 56.0 31.0   1.0 18.0     0.0   19.0   164.0 64.0     0.0   2.0     94.0   *   228.0 103 56 31   1 18     0   19   164 64     0 2   94     228
700764 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384002189 430 BRIDGE VIEW SPECIAL EDUCATION Special Education Special Education School No Other KG 12 2017   pk_12_total 22.0 56.0 11.0   4.0 35.0     0.0   4.0   85.0 47.0     71.0   2.0     94.0   *   132.0 22 56 11   4 35     0   4   85 47     71 2   94     132
699137 MN Ramsey 62 school 2723850 622 Independent Districts and Schools North St Paul-Maplewood Oakdale Public School District 272385001174 57 NORTH SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 09 12 2017   pk_12_total 801.0 272.0 243.0   10.0 377.0     0.0   71.0   894.0 880.0     144.0   18.0     938.0   267.0   1774.0 801 272 243   10 377     0   71   894 880     144 18   938 267   1774
689108 MN Carlton 9 school 2721450 97 Independent Districts and Schools MOOSE LAKE PUBLIC SCHOOL DISTRICT 272145001094 10 MOOSE LAKE SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   pk_12_total 272.0 2.0 5.0   0.0 2.0     0.0   13.0   157.0 137.0     1.0   7.0     93.0   31.0   294.0 272 2 5   0 2     0   13   157 137     1 7   93 31   294
690036 MN Renville 65 school 2700023 2159 Independent Districts and Schools BUFFALO LK-HECTOR-STEWART PUBLIC SC 270002300704 20 BUFFALO LAKE-HECTOR SECONDARY Secondary School (Grades 7-12) Regular School No Other 06 12 2017   pk_12_total 234.0 2.0 35.0   0.0 6.0     0.0   6.0   143.0 140.0     10.0   0.0     93.0   39.0   283.0 234 2 35   0 6     0   6   143 140     10 0   93 39   283
690128 MN Stearns 73 school 2700105 2364 Independent Districts and Schools Belgrade-Brooten-Elrosa Public School District 270010502567 2 BELGRADE-BROOTEN-ELROSA SEC. Secondary School (Grades 7-12) Regular School No High 07 12 2017   pk_12_total 271.0 2.0 23.0   2.0 0.0     0.0   3.0   156.0 145.0     3.0   0.0     93.0   30.0   301.0 271 2 23   2 0     0   3   156 145     3 0   93 30   301
690321 MN Dakota 19 school 2733270 6 Special Districts and Schools SOUTH ST. PAUL PUBLIC SCHOOL DIST. 273327001456 120 SOUTH ST. PAUL SECONDARY Secondary School (Grades 7-12) Regular School No Other 06 12 2017   grade_11 164.0 13.0 55.0   2.0 3.0     0.0   5.0   135.0 107.0     4.0   1.0     93.0   23.0   242.0 164 13 55   2 3     0   5   135 107     4 1   93 23   242
692145 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 2017   pk_12_total 283.0 43.0 29.0   1.0 12.0     0.0   37.0   214.0 191.0     23.0   0.0     93.0   38.0   405.0 283 43 29   1 12     0   37   214 191     23 0   93 38   405
694055 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384001594 494 CAPITOL HILL MAGNET/RONDO Elementary School (Grades PK-6) Regular School No Elementary 01 08 2017   grade_8 78.0 48.0 12.0   2.0 66.0     0.0   4.0   119.0 91.0     26.0   1.0     93.0   10.0   210.0 78 48 12   2 66     0   4   119 91     26 1   93 10   210
694117 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384001619 541 PHALEN LAKE HMONG STUDIES MAGNET Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   kindergarten 2.0 3.0 0.0   0.0 105.0     0.0   2.0   54.0 58.0     91.0   2.0     93.0   9.0   112.0 2 3 0   0 105     0   2   54 58     91 2   93 9   112
696975 MN Ramsey 62 school 2700342 4103 Charter Schools HMONG COLLEGE PREP ACADEMY 270034203700 20 HMONG COLLEGE PREP MIDDLE ACADEMY Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2017   grade_2 0.0 0.0 0.0   0.0 107.0     0.0   0.0   57.0 50.0     61.0   0.0     93.0   9.0   107.0 0 0 0   0 107     0   0   57 50     61 0   93 9   107
697177 MN Mcleod 43 school 2700277 4161 Charter Schools NEW DISCOVERIES MONTESSORI ACADEMY 270027703616 10 NEW DISCOVERIES MONTESSORI ACADEMY Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2017   pk_12_total 134.0 3.0 6.0   5.0 0.0     0.0   11.0   74.0 85.0     0.0   5.0     93.0   50.0   159.0 134 3 6   5 0     0   11   74 85     0 5   93 50   159
697869 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239002437 32 BLACK HAWK MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_8 157.0 52.0 31.0   3.0 34.0     0.0   14.0   139.0 152.0     13.0   1.0     93.0   43.0   291.0 157 52 31   3 34     0   14   139 152     13 1   93 43   291
698140 MN Olmsted 55 school 2731800 535 Independent Districts and Schools ROCHESTER PUBLIC SCHOOL DISTRICT 273180001020 335 KELLOGG MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_8 221.0 34.0 15.0   1.0 34.0     0.0   10.0   161.0 154.0     29.0   4.0     93.0   39.0   315.0 221 34 15   1 34     0   10   161 154     29 4   93 39   315
698239 MN Saint Louis 69 school 2713920 700 Independent Districts and Schools HERMANTOWN PUBLIC SCHOOL DISTRICT 271392002143 15 HERMANTOWN MIDDLE Middle School (Grades 5-8) Regular School No Middle 05 08 2017   pk_12_total 637.0 4.0 13.0   3.0 4.0     0.0   27.0   344.0 344.0     2.0   4.0     93.0   88.0   688.0 637 4 13   3 4     0   27   344 344     2 4   93 88   688
698324 MN Washington 82 school 2733810 833 Independent Districts and Schools SOUTH WASHINGTON COUNTY SCHOOL DIST 273381002465 20 COTTAGE GROVE MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_6 306.0 22.0 26.0   1.0 18.0     0.0   18.0   176.0 215.0     13.0   2.0     93.0   44.0   391.0 306 22 26   1 18     0   18   176 215     13 2   93 44   391
698895 MN Hennepin 27 school 2705790 271 Independent Districts and Schools BLOOMINGTON PUBLIC SCHOOL DISTRICT 270579000219 9 JEFFERSON SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 09 12 2017   grade_10 311.0 43.0 24.0   3.0 39.0     1.0   9.0   214.0 216.0     6.0   2.0     93.0   41.0   430.0 311 43 24   3 39     1   9   214 216     6 2   93 41   430
693321 MN Nobles 53 school 2744160 518 Independent Districts and Schools WORTHINGTON PUBLIC SCHOOL DISTRICT 274416001836 1 PRAIRIE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2017   pk_12_total 278.0 81.0 688.0   1.0 137.0     0.0   25.0   594.0 616.0     616.0   3.0     927.0   125.0   1210.0 278 81 688   1 137     0   25   594 616     616 3   927 125   1210

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