Data source: Big Local News · About: Big Local

13,757 rows where state = "MN" and year = 2017 sorted by disability 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
690787 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   pk_12_total 133.0 171.0 154.0   11.0 33.0     0.0   82.0   316.0 268.0     177.0   14.0     443.0   99.0   584.0 133 171 154   11 33     0   82   316 268     177 14   443 99   584
690891 MN Becker 3 school 2712360 23 Independent Districts and Schools FRAZEE-VERGAS PUBLIC SCHOOL DIST. 271236000607 10 FRAZEE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   pk_12_total 439.0 3.0 17.0   7.0 0.0     0.0   31.0   248.0 249.0     0.0   7.0     237.0   99.0   497.0 439 3 17   7 0     0   31   248 249     0 7   237 99   497
691757 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 2017   pk_12_total 505.0 66.0 38.0   0.0 73.0     0.0   48.0   375.0 355.0     69.0   1.0     112.0   99.0   730.0 505 66 38   0 73     0   48   375 355     69 1   112 99   730
693389 MN Olmsted 55 school 2731800 535 Independent Districts and Schools ROCHESTER PUBLIC SCHOOL DISTRICT 273180000993 124 FRANKLIN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   pk_12_total 279.0 153.0 144.0   3.0 22.0     1.0   28.0   318.0 312.0     181.0   13.0     394.0   99.0   630.0 279 153 144   3 22     1   28   318 312     181 13   394 99   630
694421 MN Saint Louis 69 school 2711040 709 Independent Districts and Schools DULUTH PUBLIC SCHOOL DISTRICT 271104000479 540 MYERS-WILKINS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   pk_12_total 193.0 79.0 17.0   44.0 3.0     0.0   76.0   207.0 205.0     1.0   18.0     310.0   99.0   412.0 193 79 17   44 3     0   76   207 205     1 18   310 99   412
694545 MN Scott 70 school 2733000 720 Independent Districts and Schools SHAKOPEE PUBLIC SCHOOL DISTRICT 273300004391 866 JACKSON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   pk_12_total 492.0 56.0 125.0   2.0 129.0     0.0   67.0   485.0 386.0     143.0   6.0     266.0   99.0   871.0 492 56 125   2 129     0   67   485 386     143 6   266 99   871
695068 MN Washington 82 school 2733810 833 Independent Districts and Schools SOUTH WASHINGTON COUNTY SCHOOL DIST 273381002305 34 GREY CLOUD ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   pk_12_total 560.0 38.0 47.0   0.0 39.0     0.0   45.0   391.0 338.0     42.0   3.0     117.0   99.0   729.0 560 38 47   0 39     0   45   391 338     42 3   117 99   729
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
690834 MN Anoka 2 school 2733540 15 Independent Districts and Schools ST. FRANCIS PUBLIC SCHOOL DISTRICT 273354000233 784 CEDAR CREEK COMMUNITY SCHOOL Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   pk_12_total 617.0 3.0 23.0   7.0 42.0     0.0   28.0   368.0 352.0     40.0   7.0     182.0   98.0   720.0 617 3 23   7 42     0   28   368 352     40 7   182 98   720
691170 MN Carlton 9 school 2709420 94 Independent Districts and Schools CLOQUET PUBLIC SCHOOL DISTRICT 270942000384 105 WASHINGTON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   pk_12_total 464.0 1.0 8.0   67.0 1.0     1.0   96.0   335.0 303.0     1.0   9.0     292.0   98.0   638.0 464 1 8   67 1     1   96   335 303     1 9   292 98   638
691441 MN Crow Wing 18 school 2706090 181 Independent Districts and Schools BRAINERD PUBLIC SCHOOL DISTRICT 270609000248 4 BAXTER ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2017   pk_12_total 445.0 2.0 8.0   5.0 6.0     0.0   18.0   245.0 239.0     2.0   0.0     161.0   98.0   484.0 445 2 8   5 6     0   18   245 239     2 0   161 98   484
691792 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239002302 720 Oak Ridge Elementary School of Leadership, Environmental and Health Sciences Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   pk_12_total 236.0 171.0 45.0   4.0 42.0     0.0   60.0   277.0 281.0     80.0   5.0     269.0   98.0   558.0 236 171 45   4 42     0   60   277 281     80 5   269 98   558
693525 MN Otter Tail 56 school 2728230 549 Independent Districts and Schools PERHAM-DENT PUBLIC SCHOOL DISTRICT 272823001247 10 HEART OF THE LAKE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2017   pk_12_total 427.0 14.0 42.0   8.0 3.0     1.0   23.0   275.0 243.0     28.0   0.0     234.0   98.0   518.0 427 14 42   8 3     1   23   275 243     28 0   234 98   518
694575 MN Sherburne 71 school 2703870 726 Independent Districts and Schools BECKER PUBLIC SCHOOL DISTRICT 270387003092 40 BECKER PRIMARY Elementary School (Grades PK-6) Regular School No Elementary PK 02 2017   pk_12_total 615.0 7.0 18.0   1.0 2.0     0.0   29.0   357.0 315.0     8.0   7.0     133.0   98.0   672.0 615 7 18   1 2     0   29   357 315     8 7   133 98   672
696593 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124004239 291 HMONG INTERNATIONAL ACADEMY Elementary School (Grades PK-6) Regular School No Elementary PK 08 2017   pk_12_total 13.0 171.0 22.0   7.0 301.0     0.0   11.0   280.0 245.0     260.0   57.0     458.0   98.0   525.0 13 171 22   7 301     0   11   280 245     260 57   458 98   525
698791 MN Crow Wing 18 school 2706090 181 Independent Districts and Schools BRAINERD PUBLIC SCHOOL DISTRICT 270609000249 14 BRAINERD SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 09 12 2017   grade_9 496.0 12.0 6.0   8.0 7.0     0.0   13.0   276.0 266.0         *     169.0   98.0   542.0 496 12 6   8 7     0   13   276 266           169 98   542
699262 MN Sherburne 71 school 2711370 728 Independent Districts and Schools ELK RIVER PUBLIC SCHOOL DISTRICT 271137003361 530 ZIMMERMAN HIGH SCHOOL Senior High School (Grades 9-12) Regular School No High 09 12 2017   pk_12_total 589.0 5.0 15.0   3.0 7.0     2.0   18.0   345.0 294.0     3.0   1.0     127.0   98.0   639.0 589 5 15   3 7     2   18   345 294     3 1   127 98   639
702586 MN Washington 82 school 2738190 834 Independent Districts and Schools STILLWATER AREA PUBLIC SCHOOL DIST. 273819001660 48 OAK-LAND JUNIOR HIGH Junior High School (Grades 7-8 or 7-9) Regular School No Other 07 09 2017   pk_12_total 659.0 54.0 43.0   4.0 62.0     0.0   25.0   459.0 388.0     18.0   2.0     149.0   98.0   847.0 659 54 43   4 62     0   25   459 388     18 2   149 98   847
691228 MN Carver 10 school 2741460 110 Independent Districts and Schools WACONIA PUBLIC SCHOOL DISTRICT 274146003065 120 BAYVIEW ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   pk_12_total 566.0 2.0 25.0   6.0 6.0     0.0   14.0   340.0 279.0     12.0   4.0     81.0   97.0   619.0 566 2 25   6 6     0   14   340 279     12 4   81 97   619
694280 MN Roseau 68 school 2741850 690 Independent Districts and Schools WARROAD PUBLIC SCHOOL DISTRICT 274185001744 10 WARROAD ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   pk_12_total 385.0 3.0 12.0   42.0 46.0     0.0   55.0   277.0 266.0     26.0   6.0     247.0   97.0   543.0 385 3 12   42 46     0   55   277 266     26 6   247 97   543
695147 MN Washington 82 school 2733810 833 Independent Districts and Schools SOUTH WASHINGTON COUNTY SCHOOL DIST 273381002306 47 MIDDLETON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   pk_12_total 490.0 54.0 40.0   0.0 96.0     1.0   54.0   411.0 324.0     62.0   2.0     87.0   97.0   735.0 490 54 40   0 96     1   54   411 324     62 2   87 97   735
696164 MN Redwood 64 school 2700182 2897 Independent Districts and Schools REDWOOD AREA SCHOOL DISTRICT 270018201305 2 REEDE GRAY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2017   pk_12_total 264.0 3.0 37.0   88.0 4.0     0.0   56.0   243.0 209.0     0.0   10.0     241.0   97.0   452.0 264 3 37   88 4     0   56   243 209     0 10   241 97   452
697758 MN Brown 8 school 2723490 88 Independent Districts and Schools NEW ULM PUBLIC SCHOOL DISTRICT 272349005035 40 NEW ULM MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 05 08 2017   pk_12_total 552.0 6.0 34.0   0.0 4.0     0.0   5.0   310.0 291.0     3.0   5.0     188.0   97.0   601.0 552 6 34   0 4     0   5   310 291     3 5   188 97   601
702543 MN Hennepin 27 school 2714260 270 Independent Districts and Schools HOPKINS PUBLIC SCHOOL DISTRICT 271426000616 380 HOPKINS WEST JUNIOR HIGH Junior High School (Grades 7-8 or 7-9) Regular School No Other 07 09 2017   pk_12_total 425.0 147.0 35.0   2.0 40.0     1.0   41.0   346.0 345.0     12.0   8.0     221.0   97.0   691.0 425 147 35   2 40     1   41   346 345     12 8   221 97   691
691590 MN Dakota 19 school 2711820 192 Independent Districts and Schools FARMINGTON PUBLIC SCHOOL DISTRICT 271182003183 80 MEADOWVIEW ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   pk_12_total 597.0 13.0 29.0   1.0 42.0     0.0   31.0   361.0 352.0     23.0   0.0     92.0   96.0   713.0 597 13 29   1 42     0   31   361 352     23 0   92 96   713
691613 MN Dakota 19 school 2711820 192 Independent Districts and Schools FARMINGTON PUBLIC SCHOOL DISTRICT 271182002205 621 AKIN ROAD ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   pk_12_total 520.0 23.0 55.0   7.0 36.0     0.0   43.0   336.0 348.0     48.0   6.0     128.0   96.0   684.0 520 23 55   7 36     0   43   336 348     48 6   128 96   684
693186 MN Morrison 49 school 2728320 484 Independent Districts and Schools PIERZ PUBLIC SCHOOL DISTRICT 272832001251 20 PIONEER ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   pk_12_total 588.0 1.0 18.0   0.0 1.0     0.0   7.0   345.0 270.0     4.0   0.0     276.0   96.0   615.0 588 1 18   0 1     0   7   345 270     4 0   276 96   615
693465 MN Olmsted 55 school 2731800 535 Independent Districts and Schools ROCHESTER PUBLIC SCHOOL DISTRICT 273180001010 150 SUNSET TERRACE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   pk_12_total 346.0 145.0 33.0   2.0 102.0     0.0   43.0   351.0 320.0     104.0   11.0     324.0   96.0   671.0 346 145 33   2 102     0   43   351 320     104 11   324 96   671
694430 MN Saint Louis 69 school 2711040 709 Independent Districts and Schools DULUTH PUBLIC SCHOOL DISTRICT 271104000482 550 PIEDMONT ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   pk_12_total 370.0 50.0 14.0   27.0 8.0     0.0   90.0   286.0 273.0     3.0   13.0     331.0   96.0   559.0 370 50 14   27 8     0   90   286 273     3 13   331 96   559
694732 MN Sherburne 71 school 2733510 742 Independent Districts and Schools ST. CLOUD PUBLIC SCHOOL DISTRICT 273351002286 36 TALAHI COMMUNITY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   pk_12_total 86.0 405.0 29.0   3.0 15.0     0.0   38.0   329.0 247.0     270.0   29.0         96.0   576.0 86 405 29   3 15     0   38   329 247     270 29     96   576
697692 MN Hennepin 27 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000108 6 JACKSON MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_6 418.0 111.0 50.0   6.0 99.0     0.0   40.0   344.0 380.0     27.0   3.0     250.0   96.0   724.0 418 111 50   6 99     0   40   344 380     27 3   250 96   724
697971 MN Hennepin 27 school 2725080 278 Independent Districts and Schools ORONO PUBLIC SCHOOL DISTRICT 272508001199 31 ORONO MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   pk_12_total 641.0 10.0 24.0   2.0 9.0     0.0   15.0   360.0 341.0     2.0   0.0     48.0   96.0   701.0 641 10 24   2 9     0   15   360 341     2 0   48 96   701
698524 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 2017   pk_12_total 8.0 255.0 57.0   10.0 6.0     2.0   5.0   161.0 182.0     43.0   43.0         96.0   343.0 8 255 57   10 6     2   5   161 182     43 43     96   343
691310 MN Cass 11 school 2702910 113 Independent Districts and Schools WALKER-HACKENSACK-AKELEY SCHL. DIST 270291001736 10 W.H.A. ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   pk_12_total 237.0 1.0 12.0   103.0 2.0     0.0   35.0   205.0 185.0     0.0   22.0     234.0   95.0   390.0 237 1 12   103 2     0   35   205 185     0 22   234 95   390
695467 MN Isanti 30 school 2707410 911 Independent Districts and Schools CAMBRIDGE-ISANTI PUBLIC SCHOOL DIST 270741003657 201 CAMBRIDGE INTERMEDIATE SCHOOL Elementary School (Grades PK-6) Regular School No Elementary 03 05 2017   pk_12_total 582.0 6.0 15.0   4.0 7.0     0.0   31.0   343.0 302.0     4.0   4.0     251.0   95.0   645.0 582 6 15   4 7     0   31   343 302     4 4   251 95   645
698174 MN Ramsey 62 school 2722950 621 Independent Districts and Schools MOUNDS VIEW PUBLIC SCHOOL DISTRICT 272295001115 70 Chippewa Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2017   pk_12_total 772.0 33.0 46.0   5.0 155.0     0.0   51.0   525.0 537.0     15.0   3.0     160.0   95.0   1062.0 772 33 46   5 155     0   51   525 537     15 3   160 95   1062
702578 MN Washington 82 school 2712270 831 Independent Districts and Schools FOREST LAKE PUBLIC SCHOOL DISTRICT 271227000592 115 CENTURY JUNIOR HIGH Junior High School (Grades 7-8 or 7-9) Regular School No Other 07 09 2017   pk_12_total 731.0 9.0 27.0   4.0 28.0     0.0   22.0   446.0 375.0     3.0   4.0     184.0   95.0   821.0 731 9 27   4 28     0   22   446 375     3 4   184 95   821
691764 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 2017   pk_12_total 400.0 72.0 60.0   5.0 51.0     0.0   66.0   327.0 327.0     52.0   1.0     151.0   94.0   654.0 400 72 60   5 51     0   66   327 327     52 1   151 94   654
691785 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239002283 719 SHANNON PARK ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   pk_12_total 650.0 18.0 29.0   2.0 79.0     0.0   51.0   438.0 391.0     36.0   0.0     59.0   94.0   829.0 650 18 29   2 79     0   51   438 391     36 0   59 94   829
692213 MN Hennepin 27 school 2714220 272 Independent Districts and Schools EDEN PRAIRIE PUBLIC SCHOOL DISTRICT 271422002271 880 Oak Point Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 06 2017   pk_12_total 343.0 107.0 63.0   5.0 185.0     0.0   37.0   376.0 364.0     134.0   2.0     178.0   94.0   740.0 343 107 63   5 185     0   37   376 364     134 2   178 94   740
693831 MN Ramsey 62 school 2742360 624 Independent Districts and Schools WHITE BEAR LAKE SCHOOL DISTRICT 274236001050 828 OTTER LAKE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   pk_12_total 458.0 19.0 41.0   4.0 34.0     0.0   33.0   298.0 291.0     34.0   2.0     106.0   94.0   589.0 458 19 41   4 34     0   33   298 291     34 2   106 94   589
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
697862 MN Dakota 19 school 2717780 194 Independent Districts and Schools LAKEVILLE PUBLIC SCHOOL DISTRICT 271778002984 105 CENTURY MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 06 08 2017   pk_12_total 770.0 26.0 21.0   4.0 54.0     1.0   32.0   450.0 458.0     8.0   *     68.0   94.0   908.0 770 26 21   4 54     1   32   450 458     8     68 94   908
698659 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_10 420.0 15.0 22.0   3.0 22.0     0.0   11.0   255.0 238.0     0.0   4.0     77.0   94.0   493.0 420 15 22   3 22     0   11   255 238     0 4   77 94   493
699416 MN Todd 77 school 2733900 2170 Independent Districts and Schools STAPLES-MOTLEY SCHOOL DISTRICT 273390001644 40 STAPLES-MOTLEY SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 08 12 2017   pk_12_total 421.0 5.0 16.0   8.0 6.0     1.0   16.0   251.0 222.0     0.0   14.0     224.0   94.0   473.0 421 5 16   8 6     1   16   251 222     0 14   224 94   473
689178 MN Crow Wing 18 school 2709750 182 Independent Districts and Schools CROSBY-IRONTON PUBLIC SCHOOL DIST. 270975000417 1 CROSBY-IRONTON SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   pk_12_total 458.0 8.0 5.0   6.0 5.0     0.0   16.0   256.0 242.0     0.0   0.0     186.0   93.0   498.0 458 8 5   6 5     0   16   256 242     0 0   186 93   498
691083 MN Blue Earth 7 school 2718780 77 Independent Districts and Schools MANKATO PUBLIC SCHOOL DISTRICT 271878004388 70 ROSA PARKS ELEMENTARY SCHOOL Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   pk_12_total 369.0 61.0 41.0   5.0 17.0     0.0   34.0   302.0 225.0     43.0   5.0     236.0   93.0   527.0 369 61 41   5 17     0   34   302 225     43 5   236 93   527
691135 MN Brown 8 school 2723490 88 Independent Districts and Schools NEW ULM PUBLIC SCHOOL DISTRICT 272349001150 20 JEFFERSON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 01 04 2017   pk_12_total 587.0 7.0 37.0   0.0 2.0     0.0   21.0   354.0 300.0     7.0   3.0     211.0   93.0   654.0 587 7 37   0 2     0   21   354 300     7 3   211 93   654
691699 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 2017   pk_12_total 238.0 74.0 54.0   2.0 32.0     0.0   29.0   220.0 209.0     60.0   0.0     188.0   93.0   429.0 238 74 54   2 32     0   29   220 209     60 0   188 93   429
692500 MN Hennepin 27 school 2731750 280 Independent Districts and Schools RICHFIELD PUBLIC SCHOOL DISTRICT 273175001312 36 RICHFIELD STEM SCHOOL Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   pk_12_total 300.0 123.0 201.0   8.0 56.0     2.0   95.0   435.0 350.0     191.0   12.0     446.0   93.0   785.0 300 123 201   8 56     2   95   435 350     191 12   446 93   785
693170 MN Morrison 49 school 2718240 482 Independent Districts and Schools LITTLE FALLS PUBLIC SCHOOL DISTRICT 271824000961 120 LINDBERGH ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   pk_12_total 527.0 16.0 26.0   0.0 6.0     0.0   30.0   305.0 300.0     12.0   5.0     267.0   93.0   605.0 527 16 26   0 6     0   30   305 300     12 5   267 93   605
694023 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384001587 488 THE HEIGHTS COMMUNITY SCHOOL Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   pk_12_total 65.0 110.0 120.0   8.0 169.0     1.0   49.0   289.0 233.0     221.0   19.0     395.0   93.0   522.0 65 110 120   8 169     1   49   289 233     221 19   395 93   522
694522 MN Scott 70 school 2733000 720 Independent Districts and Schools SHAKOPEE PUBLIC SCHOOL DISTRICT 273300001437 861 SUN PATH ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   pk_12_total 409.0 75.0 64.0   9.0 73.0     2.0   38.0   310.0 360.0     122.0   3.0     231.0   93.0   670.0 409 75 64   9 73     2   38   310 360     122 3   231 93   670
696617 MN Dakota 19 school 2733270 6 Special Districts and Schools SOUTH ST. PAUL PUBLIC SCHOOL DIST. 273327001457 737 KAPOSIA EDUCATION CENTER ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   pk_12_total 402.0 81.0 247.0   10.0 14.0     0.0   73.0   435.0 392.0     112.0   11.0     500.0   93.0   827.0 402 81 247   10 14     0   73   435 392     112 11   500 93   827
697686 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000117 3 ANOKA MIDDLE SCHOOL FOR THE ARTS Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_8 501.0 53.0 19.0   7.0 22.0     0.0   22.0   294.0 330.0     9.0   10.0     208.0   93.0   624.0 501 53 19   7 22     0   22   294 330     9 10   208 93   624
697801 MN Chippewa 12 school 2721320 129 Independent Districts and Schools MONTEVIDEO PUBLIC SCHOOL DISTRICT 272132001071 30 MONTEVIDEO MIDDLE Middle School (Grades 5-8) Regular School No Elementary 04 07 2017   pk_12_total 356.0 4.0 70.0   3.0 3.0     2.0   10.0   245.0 203.0     27.0   0.0     194.0   93.0   448.0 356 4 70   3 3     2   10   245 203     27 0   194 93   448
697822 MN Crow Wing 18 school 2706090 181 Independent Districts and Schools BRAINERD PUBLIC SCHOOL DISTRICT 270609004196 22 FORESTVIEW MIDDLE Middle School (Grades 5-8) Regular School No Middle 05 08 2017   grade_6 474.0 13.0 3.0   6.0 4.0     1.0   14.0   242.0 273.0         3.0     209.0   93.0   515.0 474 13 3   6 4     1   14   242 273       3   209 93   515
698019 MN Hennepin 27 school 2742160 284 Independent Districts and Schools WAYZATA PUBLIC SCHOOL DISTRICT 274216002654 53 WAYZATA CENTRAL MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   pk_12_total 744.0 106.0 40.0   1.0 238.0     0.0   64.0   621.0 572.0         3.0     156.0   93.0   1193.0 744 106 40   1 238     0   64   621 572       3   156 93   1193
698407 MN Chisago 13 school 2700017 2144 Independent Districts and Schools CHISAGO LAKES SCHOOL DISTRICT 270001700351 3 CHISAGO LAKES MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   pk_12_total 777.0 8.0 12.0   1.0 10.0     0.0   16.0   421.0 403.0     4.0   3.0     155.0   93.0   824.0 777 8 12   1 10     0   16   421 403     4 3   155 93   824
698500 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124000936 300 ANTHONY MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 06 08 2017   pk_12_total 392.0 201.0 69.0   8.0 23.0     0.0   9.0   346.0 356.0     80.0   21.0     325.0   93.0   702.0 392 201 69   8 23     0   9   346 356     80 21   325 93   702
690400 MN Ramsey 62 school 2700186 4074 Charter Schools AFSA HIGH SCHOOL 270018603139 10 AFSA HIGH SCHOOL Secondary School (Grades 7-12) Regular School Yes High 07 12 2017   pk_12_total 224.0 16.0 17.0   1.0 16.0     1.0   18.0   173.0 120.0     0.0   0.0     81.0   92.0   293.0 224 16 17   1 16     1   18   173 120     0 0   81 92   293
690630 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 2017   pk_12_total 334.0 47.0 35.0   3.0 11.0     0.0   24.0   203.0 251.0     28.0   11.0     247.0   92.0   454.0 334 47 35   3 11     0   24   203 251     28 11   247 92   454
690812 MN Anoka 2 school 2712420 14 Independent Districts and Schools FRIDLEY PUBLIC SCHOOL DISTRICT 271242000612 546 HAYES ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2017   pk_12_total 242.0 179.0 49.0   5.0 26.0     0.0   62.0   300.0 263.0     110.0   13.0     340.0   92.0   563.0 242 179 49   5 26     0   62   300 263     110 13   340 92   563
693716 MN Washington 82 school 2723850 622 Independent Districts and Schools North St Paul-Maplewood Oakdale Public School District 272385001175 33 OAKDALE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   pk_12_total 215.0 92.0 69.0   4.0 86.0     1.0   68.0   267.0 268.0     65.0   15.0     340.0   92.0   535.0 215 92 69   4 86     1   68   267 268     65 15   340 92   535
694229 MN Rice 66 school 2723880 659 Independent Districts and Schools NORTHFIELD PUBLIC SCHOOL DISTRICT 272388001180 3 GREENVALE PARK ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   pk_12_total 318.0 17.0 145.0   3.0 13.0     0.0   16.0   263.0 249.0     107.0   3.0     244.0   92.0   512.0 318 17 145   3 13     0   16   263 249     107 3   244 92   512
694531 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 2017   pk_12_total 347.0 75.0 93.0   10.0 72.0     0.0   44.0   317.0 324.0     143.0   3.0     294.0   92.0   641.0 347 75 93   10 72     0   44   317 324     143 3   294 92   641
695765 MN Rock 67 school 2718330 2184 Independent Districts and Schools LUVERNE PUBLIC SCHOOL DISTRICT 271833000851 2 LUVERNE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   pk_12_total 496.0 12.0 40.0   2.0 11.0     0.0   22.0   312.0 271.0     28.0   *     217.0   92.0   583.0 496 12 40   2 11     0   22   312 271     28     217 92   583
696982 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   pk_12_total 1.0 3.0 4.0   0.0 990.0     0.0   3.0   562.0 439.0     382.0   9.0     846.0   92.0   1001.0 1 3 4   0 990     0   3   562 439     382 9   846 92   1001
697846 MN Dakota 19 school 2711820 192 Independent Districts and Schools FARMINGTON PUBLIC SCHOOL DISTRICT 271182000570 30 LEVI P. DODGE MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 06 08 2017   pk_12_total 633.0 18.0 51.0   7.0 35.0     1.0   25.0   389.0 381.0     15.0   *     120.0   92.0   770.0 633 18 51   7 35     1   25   389 381     15     120 92   770
698292 MN Sherburne 71 school 2711370 728 Independent Districts and Schools ELK RIVER PUBLIC SCHOOL DISTRICT 271137002038 410 SALK MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 06 08 2017   pk_12_total 625.0 38.0 18.0   4.0 17.0     0.0   31.0   386.0 347.0     5.0   1.0     106.0   92.0   733.0 625 38 18   4 17     0   31   386 347     5 1   106 92   733
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
702582 MN Washington 82 school 2712270 831 Independent Districts and Schools FOREST LAKE PUBLIC SCHOOL DISTRICT 271227000600 116 Southwest Junior High Junior High School (Grades 7-8 or 7-9) Regular School No Other 07 09 2017   pk_12_total 652.0 10.0 22.0   4.0 19.0     0.0   26.0   389.0 344.0     12.0   1.0     151.0   92.0   733.0 652 10 22   4 19     0   26   389 344     12 1   151 92   733
689320 MN Itasca 31 school 2710140 317 Independent Districts and Schools DEER RIVER PUBLIC SCHOOL DISTRICT 271014000433 1 DEER RIVER SECONDARY Secondary School (Grades 7-12) Regular School No Other 06 12 2017   pk_12_total 232.0 0.0 20.0   136.0 0.0     0.0   49.0   234.0 203.0         *         91.0   437.0 232 0 20   136 0     0   49   234 203             91   437
690623 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 2017   pk_12_total 680.0 34.0 21.0   5.0 49.0     1.0   23.0   409.0 404.0     29.0   3.0     150.0   91.0   813.0 680 34 21   5 49     1   23   409 404     29 3   150 91   813
691163 MN Carlton 9 school 2709420 94 Independent Districts and Schools CLOQUET PUBLIC SCHOOL DISTRICT 270942000380 101 CHURCHILL ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   pk_12_total 376.0 3.0 9.0   69.0 2.0     0.0   63.0   262.0 260.0     0.0   8.0     240.0   91.0   522.0 376 3 9   69 2     0   63   262 260     0 8   240 91   522
691214 MN Carver 10 school 2723910 108 Independent Districts and Schools CENTRAL PUBLIC SCHOOL DISTRICT 272391001187 40 CENTRAL ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   pk_12_total 404.0 16.0 34.0   1.0 1.0     0.0   21.0   247.0 230.0     23.0   2.0     104.0   91.0   477.0 404 16 34   1 1     0   21   247 230     23 2   104 91   477
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
692438 MN Hennepin 27 school 2725200 279 Independent Districts and Schools OSSEO PUBLIC SCHOOL DISTRICT 272520001219 678 PALMER LAKE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   pk_12_total 50.0 189.0 56.0   0.0 144.0     0.0   55.0   246.0 248.0     119.0   6.0     374.0   91.0   494.0 50 189 56   0 144     0   55   246 248     119 6   374 91   494
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
694681 MN Stearns 73 school 2728140 741 Independent Districts and Schools PAYNESVILLE PUBLIC SCHOOL DISTRICT 272814001240 1 PAYNESVILLE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   pk_12_total 397.0 0.0 17.0   0.0 0.0     0.0   8.0   201.0 221.0     3.0   4.0     145.0   91.0   422.0 397 0 17   0 0     0   8   201 221     3 4   145 91   422
695592 MN Lesueur 40 school 2700013 2143 Independent Districts and Schools Waterville-Elysian-Morristown Public School District 270001301752 30 WATERVILLE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2017   pk_12_total 265.0 5.0 30.0   2.0 0.0     0.0   14.0   169.0 147.0     4.0   0.0     102.0   91.0   316.0 265 5 30   2 0     0   14   169 147     4 0   102 91   316
698057 MN Lyon 42 school 2718940 413 Independent Districts and Schools MARSHALL PUBLIC SCHOOL DISTRICT 271894003715 6 MARSHALL MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 05 08 2017   pk_12_total 436.0 76.0 82.0   0.0 59.0     0.0   26.0   344.0 335.0     96.0   8.0     294.0   91.0   679.0 436 76 82   0 59     0   26   344 335     96 8   294 91   679
698801 MN Dakota 19 school 2707290 191 Independent Districts and Schools BURNSVILLE PUBLIC SCHOOL DISTRICT 270729000292 14 Burnsville High School Senior High School (Grades 9-12) Regular School No High 09 12 2017   grade_9 341.0 125.0 116.0   6.0 57.0     2.0   20.0   344.0 323.0     78.0   10.0     310.0   91.0   667.0 341 125 116   6 57     2   20   344 323     78 10   310 91   667
689763 MN Saint Louis 69 school 2741040 706 Independent Districts and Schools VIRGINIA PUBLIC SCHOOL DISTRICT 274104001718 90 VIRGINIA SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   pk_12_total 593.0 7.0 16.0   18.0 4.0     0.0   60.0   361.0 337.0     1.0   5.0     216.0   90.0   698.0 593 7 16   18 4     0   60   361 337     1 5   216 90   698
690178 MN Saint Louis 69 school 2791450 2711 Independent Districts and Schools MESABI EAST SCHOOL DISTRICT 279145002326 40 MESABI EAST SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   pk_12_total 417.0 1.0 0.0   7.0 1.0     0.0   13.0   226.0 213.0     0.0   0.0     182.0   90.0   439.0 417 1 0   7 1     0   13   226 213     0 0   182 90   439
692387 MN Hennepin 27 school 2725200 279 Independent Districts and Schools OSSEO PUBLIC SCHOOL DISTRICT 272520002523 670 BASSWOOD ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   pk_12_total 759.0 70.0 27.0   2.0 69.0     0.0   76.0   536.0 467.0     34.0   1.0     125.0   90.0   1003.0 759 70 27   2 69     0   76   536 467     34 1   125 90   1003
694322 MN Saint Louis 69 school 2713920 700 Independent Districts and Schools HERMANTOWN PUBLIC SCHOOL DISTRICT 271392000715 10 HERMANTOWN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 04 2017   pk_12_total 683.0 11.0 19.0   2.0 12.0     1.0   25.0   399.0 354.0     7.0   5.0     131.0   90.0   753.0 683 11 19   2 12     1   25   399 354     7 5   131 90   753
694461 MN Scott 70 school 2715750 717 Independent Districts and Schools JORDAN PUBLIC SCHOOL DISTRICT 271575001630 637 JORDAN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2017   pk_12_total 516.0 12.0 69.0   5.0 6.0     1.0   23.0   331.0 301.0     41.0   0.0     141.0   90.0   632.0 516 12 69   5 6     1   23   331 301     41 0   141 90   632
696089 MN Mcleod 43 school 2700128 2859 Independent Districts and Schools GLENCOE-SILVER LAKE SCHOOL DISTRICT 270012801444 30 LAKESIDE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 03 06 2017   pk_12_total 355.0 0.0 115.0   2.0 0.0     0.0   10.0   268.0 214.0     43.0   2.0     198.0   90.0   482.0 355 0 115   2 0     0   10   268 214     43 2   198 90   482
699203 MN Saint Louis 69 school 2730090 704 Independent Districts and Schools PROCTOR PUBLIC SCHOOL DISTRICT 273009001551 1 PROCTOR SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 09 12 2017   pk_12_total 508.0 4.0 10.0   5.0 5.0     0.0   13.0   292.0 253.0         0.0     152.0   90.0   545.0 508 4 10   5 5     0   13   292 253       0   152 90   545
689041 MN Beltrami 4 school 2705730 32 Independent Districts and Schools BLACKDUCK PUBLIC SCHOOL DISTRICT 270573000213 20 BLACKDUCK SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   grade_10 46.0 2.0 2.0   5.0 1.0     0.0   2.0   34.0 24.0     0.0   4.0     30.0   9.0   58.0 46 2 2   5 1     0   2   34 24     0 4   30 9   58
689066 MN Brown 8 school 2733210 84 Independent Districts and Schools SLEEPY EYE PUBLIC SCHOOL DISTRICT 273321001451 20 SLEEPY EYE SEC. Secondary School (Grades 7-12) Regular School No High 07 12 2017   grade_7 34.0 1.0 14.0   0.0 1.0     0.0   0.0   27.0 23.0     3.0   1.0     24.0   9.0   50.0 34 1 14   0 1     0   0   27 23     3 1   24 9   50
689087 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   grade_6 29.0 0.0 0.0   4.0 1.0     0.0   2.0   22.0 14.0     0.0   0.0     16.0   9.0   36.0 29 0 0   4 1     0   2   22 14     0 0   16 9   36
689116 MN Carlton 9 school 2744190 100 Independent Districts and Schools WRENSHALL PUBLIC SCHOOL DISTRICT 274419001843 2 WRENSHALL SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   grade_7 26.0 0.0 1.0   0.0 0.0     0.0   1.0   14.0 14.0     0.0   0.0     14.0   9.0   28.0 26 0 1   0 0     0   1   14 14     0 0   14 9   28
689139 MN Chisago 13 school 2732550 139 Independent Districts and Schools RUSH CITY PUBLIC SCHOOL DISTRICT 273255001406 20 RUSH CITY SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   grade_9 63.0 0.0 2.0   0.0 0.0     0.0   0.0   34.0 31.0     0.0   0.0     13.0   9.0   65.0 63 0 2   0 0     0   0   34 31     0 0   13 9   65
689146 MN Clay 14 school 2703660 146 Independent Districts and Schools Barnesville Public School District 270366000170 40 BARNESVILLE SECONDARY Secondary School (Grades 7-12) Regular School No Other 06 12 2017   grade_9 52.0 0.0 1.0   1.0 0.0     0.0   0.0   24.0 30.0     0.0   0.0     8.0   9.0   54.0 52 0 1   1 0     0   0   24 30     0 0   8 9   54
689151 MN Clay 14 school 2713560 150 Independent Districts and Schools HAWLEY PUBLIC SCHOOL DISTRICT 271356000699 20 HAWLEY SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   grade_7 77.0 1.0 2.0   0.0 1.0     0.0   1.0   40.0 42.0         0.0     17.0   9.0   82.0 77 1 2   0 1     0   1   40 42       0   17 9   82
689199 MN Douglas 21 school 2725140 213 Independent Districts and Schools OSAKIS PUBLIC SCHOOL DISTRICT 272514001204 20 OSAKIS SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   grade_12 61.0 1.0 1.0   0.0 2.0     1.0   1.0   37.0 30.0     0.0   2.0     16.0   9.0   67.0 61 1 1   0 2     1   1   37 30     0 2   16 9   67
689363 MN Kittson 35 school 2717880 356 Independent Districts and Schools LANCASTER PUBLIC SCHOOL DISTRICT 271788000822 20 LANCASTER SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   pk_12_total 56.0 1.0 3.0   0.0 0.0     0.0   0.0   25.0 35.0     0.0   0.0     18.0   9.0   60.0 56 1 3   0 0     0   0   25 35     0 0   18 9   60
689420 MN Lake of the Woods 39 school 2717570 390 Independent Districts and Schools LAKE OF THE WOODS SCHOOL DISTRICT 271757000809 222 LAKE OF THE WOODS SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   grade_12 29.0 1.0 0.0   3.0 0.0     0.0   2.0   19.0 16.0     0.0   0.0     15.0   9.0   35.0 29 1 0   3 0     0   2   19 16     0 0   15 9   35

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