Data source: Big Local News · About: Big Local

13,757 rows where state = "MN" and year = 2017 sorted by native_hawaiian_pacific_islander 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
690216 MN Lac qui Parle 37 school 2700125 2853 Independent Districts and Schools LAC QUI PARLE VALLEY SCHOOL DIST. 270012502260 40 LAC QUI PARLE VALLEY SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   grade_8 43.0 0.0 1.0   0.0 1.0     9.0   2.0   27.0 29.0     4.0   1.0     29.0   9.0   56.0 43 0 1   0 1     9   2   27 29     4 1   29 9   56
699864 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 Other 06 12 2017   pk_12_total 217.0 222.0 201.0   4.0 40.0     8.0   81.0   391.0 382.0     164.0   6.0     523.0   171.0   773.0 217 222 201   4 40     8   81   391 382     164 6   523 171   773
696002 MN Todd 77 school 2700109 2753 Independent Districts and Schools Long Prairie-Grey Eagle School District 270010900680 10 Long Prairie-Grey Eagle Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   pk_12_total 220.0 2.0 219.0   1.0 2.0     7.0   6.0   231.0 226.0     131.0   13.0     307.0   68.0   457.0 220 2 219   1 2     7   6   231 226     131 13   307 68   457
698906 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 2017   pk_12_total 2017.0 325.0 209.0   15.0 334.0     7.0   111.0   1550.0 1468.0     94.0   12.0     536.0   308.0   3018.0 2017 325 209   15 334     7   111   1550 1468     94 12   536 308   3018
698960 MN Hennepin 27 school 2733780 283 Independent Districts and Schools ST. LOUIS PARK PUBLIC SCHOOL DIST. 273378001532 40 ST. LOUIS PARK SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 09 12 2017   pk_12_total 804.0 342.0 154.0   7.0 51.0     7.0   81.0   730.0 716.0     86.0   32.0     516.0   150.0   1446.0 804 342 154   7 51     7   81   730 716     86 32   516 150   1446
690219 MN Lac qui Parle 37 school 2700125 2853 Independent Districts and Schools LAC QUI PARLE VALLEY SCHOOL DIST. 270012502260 40 LAC QUI PARLE VALLEY SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   grade_11 46.0 0.0 3.0   0.0 1.0     6.0   0.0   26.0 30.0     3.0   0.0     15.0   4.0   56.0 46 0 3   0 1     6   0   26 30     3 0   15 4   56
696057 MN Swift 76 school 2700125 2853 Independent Districts and Schools LAC QUI PARLE VALLEY SCHOOL DIST. 270012500129 20 APPLETON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2017   grade_1 24.0 0.0 7.0   0.0 0.0     6.0   1.0   16.0 22.0     9.0   0.0     27.0   3.0   38.0 24 0 7   0 0     6   1   16 22     9 0   27 3   38
697820 MN Cottonwood 17 school 2742780 177 Independent Districts and Schools WINDOM PUBLIC SCHOOL DISTRICT 274278003068 60 WINDOM MIDDLE Middle School (Grades 5-8) Regular School No Elementary 04 08 2017   pk_12_total 302.0 15.0 74.0   1.0 5.0     6.0   18.0   231.0 190.0     29.0   0.0     184.0   73.0   421.0 302 15 74   1 5     6   18   231 190     29 0   184 73   421
689945 MN Wright 86 school 2718810 881 Independent Districts and Schools MAPLE LAKE PUBLIC SCHOOL DISTRICT 271881000886 20 MAPLE LAKE SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   pk_12_total 433.0 3.0 1.0   1.0 1.0     5.0   9.0   223.0 230.0     0.0   0.0     87.0   66.0   453.0 433 3 1   1 1     5   9   223 230     0 0   87 66   453
690192 MN Todd 77 school 2700109 2753 Independent Districts and Schools Long Prairie-Grey Eagle School District 270010900850 20 LONG PRAIRIE-GREY SECONDARY SCHOOL Secondary School (Grades 7-12) Regular School No High 07 12 2017   pk_12_total 260.0 0.0 128.0   2.0 7.0     5.0   9.0   212.0 199.0     26.0   5.0     207.0   66.0   411.0 260 0 128   2 7     5   9   212 199     26 5   207 66   411
690218 MN Lac qui Parle 37 school 2700125 2853 Independent Districts and Schools LAC QUI PARLE VALLEY SCHOOL DIST. 270012502260 40 LAC QUI PARLE VALLEY SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   grade_10 40.0 0.0 2.0   0.0 3.0     5.0   2.0   28.0 24.0     3.0   0.0     20.0   5.0   52.0 40 0 2   0 3     5   2   28 24     3 0   20 5   52
690729 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 2017   pk_12_total 1165.0 40.0 49.0   1.0 46.0     5.0   33.0   701.0 638.0     59.0   7.0     221.0   146.0   1339.0 1165 40 49   1 46     5   33   701 638     59 7   221 146   1339
691434 MN Cottonwood 17 school 2742780 177 Independent Districts and Schools WINDOM PUBLIC SCHOOL DISTRICT 274278001816 30 WINFAIR ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 03 2017   pk_12_total 243.0 4.0 59.0   1.0 10.0     5.0   10.0   177.0 155.0     44.0   0.0     157.0   43.0   332.0 243 4 59   1 10     5   10   177 155     44 0   157 43   332
696058 MN Swift 76 school 2700125 2853 Independent Districts and Schools LAC QUI PARLE VALLEY SCHOOL DIST. 270012500129 20 APPLETON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2017   grade_2 22.0 0.0 3.0   0.0 0.0     5.0   3.0   19.0 14.0     8.0   0.0         2.0   33.0 22 0 3   0 0     5   3   19 14     8 0     2   33
697297 MN Carver 10 school 2700319 4188 Charter Schools COLOGNE ACADEMY 270031904320 10 COLOGNE ACADEMY Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2017   pk_12_total 530.0 17.0 31.0   1.0 8.0     5.0   15.0   289.0 318.0     1.0   0.0     83.0   72.0   607.0 530 17 31   1 8     5   15   289 318     1 0   83 72   607
698091 MN Mower 50 school 2703450 492 Independent Districts and Schools AUSTIN PUBLIC SCHOOL DISTRICT 270345000150 300 ELLIS MIDDLE Middle School (Grades 5-8) Regular School No Middle 07 08 2017   pk_12_total 389.0 46.0 166.0   0.0 41.0     5.0   24.0   340.0 331.0     66.0   7.0     364.0   104.0   671.0 389 46 166   0 41     5   24   340 331     66 7   364 104   671
698805 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   pk_12_total 1400.0 475.0 401.0   15.0 236.0     5.0   79.0   1398.0 1213.0     205.0   41.0     1051.0   314.0   2611.0 1400 475 401   15 236     5   79   1398 1213     205 41   1051 314   2611
694835 MN Steele 74 school 2728050 761 Independent Districts and Schools OWATONNA PUBLIC SCHOOL DISTRICT 272805001230 904 WASHINGTON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 06 2017   pk_12_total 353.0 16.0 57.0   2.0 3.0     4.0   16.0   212.0 239.0     24.0   10.0     195.0   82.0   451.0 353 16 57   2 3     4   16   212 239     24 10   195 82   451
696056 MN Swift 76 school 2700125 2853 Independent Districts and Schools LAC QUI PARLE VALLEY SCHOOL DIST. 270012500129 20 APPLETON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2017   kindergarten 19.0 1.0 2.0   1.0 0.0     4.0   3.0   15.0 15.0         *         1.0   30.0 19 1 2   1 0     4   3   15 15             1   30
697296 MN Carver 10 school 2700319 4188 Charter Schools COLOGNE ACADEMY 270031904320 10 COLOGNE ACADEMY Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2017   grade_8 37.0 1.0 3.0   0.0 0.0     4.0   1.0   22.0 24.0     0.0   0.0     10.0   7.0   46.0 37 1 3   0 0     4   1   22 24     0 0   10 7   46
698090 MN Mower 50 school 2703450 492 Independent Districts and Schools AUSTIN PUBLIC SCHOOL DISTRICT 270345000150 300 ELLIS MIDDLE Middle School (Grades 5-8) Regular School No Middle 07 08 2017   grade_8 197.0 21.0 79.0   0.0 21.0     4.0   12.0   170.0 164.0     40.0   2.0     180.0   *   334.0 197 21 79   0 21     4   12   170 164     40 2   180     334
698647 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000097 91 Blaine High School Senior High School (Grades 9-12) Regular School No High 09 12 2017   pk_12_total 2232.0 274.0 131.0   22.0 259.0     4.0   50.0   1557.0 1415.0     85.0   39.0     786.0   289.0   2972.0 2232 274 131   22 259     4   50   1557 1415     85 39   786 289   2972
698790 MN Cottonwood 17 school 2742780 177 Independent Districts and Schools WINDOM PUBLIC SCHOOL DISTRICT 274278001815 50 WINDOM SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 09 12 2017   pk_12_total 205.0 11.0 46.0   1.0 4.0     4.0   11.0   154.0 128.0     11.0   3.0     119.0   49.0   282.0 205 11 46   1 4     4   11   154 128     11 3   119 49   282
698830 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239000488 41 EAGAN SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 09 12 2017   pk_12_total 1482.0 135.0 127.0   4.0 205.0     4.0   63.0   1043.0 977.0     33.0   4.0     276.0   241.0   2020.0 1482 135 127   4 205     4   63   1043 977     33 4   276 241   2020
698903 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 2017   grade_10 532.0 74.0 50.0   2.0 81.0     4.0   27.0   407.0 363.0     26.0   2.0     130.0   78.0   770.0 532 74 50   2 81     4   27   407 363     26 2   130 78   770
698957 MN Hennepin 27 school 2733780 283 Independent Districts and Schools ST. LOUIS PARK PUBLIC SCHOOL DIST. 273378001532 40 ST. LOUIS PARK SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 09 12 2017   grade_10 198.0 84.0 44.0   3.0 17.0     4.0   21.0   180.0 191.0         *         *   371.0 198 84 44   3 17     4   21   180 191                 371
699044 MN Mower 50 school 2703450 492 Independent Districts and Schools AUSTIN PUBLIC SCHOOL DISTRICT 270345000148 200 AUSTIN SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 09 12 2017   grade_10 218.0 24.0 87.0   1.0 21.0     4.0   11.0   195.0 171.0         *     186.0   50.0   366.0 218 24 87   1 21     4   11   195 171           186 50   366
700587 MN Hennepin 27 school 2714220 272 Independent Districts and Schools EDEN PRAIRIE PUBLIC SCHOOL DISTRICT 271422000651 884 EARLY CHILDHOOD SPECIAL ED. Special Education Special Education School No Elementary PK PK 2017   early_childhood_special_ed 83.0 18.0 4.0   2.0 24.0     4.0   12.0   101.0 46.0     0.0   0.0     26.0   *   147.0 83 18 4   2 24     4   12   101 46     0 0   26     147
700588 MN Hennepin 27 school 2714220 272 Independent Districts and Schools EDEN PRAIRIE PUBLIC SCHOOL DISTRICT 271422000651 884 EARLY CHILDHOOD SPECIAL ED. Special Education Special Education School No Elementary PK PK 2017   pk_12_total 83.0 18.0 4.0   2.0 24.0     4.0   12.0   101.0 46.0     0.0   0.0     26.0   *   147.0 83 18 4   2 24     4   12   101 46     0 0   26     147
690220 MN Lac qui Parle 37 school 2700125 2853 Independent Districts and Schools LAC QUI PARLE VALLEY SCHOOL DIST. 270012502260 40 LAC QUI PARLE VALLEY SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   grade_12 34.0 0.0 5.0   0.0 1.0     3.0   0.0   27.0 16.0     2.0   0.0     16.0   8.0   43.0 34 0 5   0 1     3   0   27 16     2 0   16 8   43
690722 MN Hennepin 27 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318002193 425 OXBOW CREEK ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   pk_12_total 872.0 127.0 38.0   3.0 82.0     3.0   86.0   619.0 592.0     60.0   5.0     286.0   142.0   1211.0 872 127 38   3 82     3   86   619 592     60 5   286 142   1211
691041 MN Blue Earth 7 school 2718780 77 Independent Districts and Schools MANKATO PUBLIC SCHOOL DISTRICT 271878000877 10 KENNEDY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   pk_12_total 268.0 101.0 30.0   0.0 4.0     3.0   28.0   211.0 223.0     57.0   10.0     212.0   78.0   434.0 268 101 30   0 4     3   28   211 223     57 10   212 78   434
691741 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239001944 713 THOMAS LAKE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   pk_12_total 337.0 50.0 22.0   0.0 44.0     3.0   42.0   275.0 223.0     60.0   0.0     82.0   81.0   498.0 337 50 22   0 44     3   42   275 223     60 0   82 81   498
693217 MN Mower 50 school 2703450 492 Independent Districts and Schools AUSTIN PUBLIC SCHOOL DISTRICT 270345000149 10 BANFIELD ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 01 04 2017   pk_12_total 266.0 45.0 101.0   0.0 27.0     3.0   11.0   208.0 245.0     95.0   0.0     245.0   64.0   453.0 266 45 101   0 27     3   11   208 245     95 0   245 64   453
693227 MN Mower 50 school 2703450 492 Independent Districts and Schools AUSTIN PUBLIC SCHOOL DISTRICT 270345002230 70 SOUTHGATE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 01 04 2017   pk_12_total 278.0 22.0 140.0   0.0 24.0     3.0   22.0   245.0 244.0     118.0   5.0     263.0   68.0   489.0 278 22 140   0 24     3   22   245 244     118 5   263 68   489
693241 MN Mower 50 school 2703450 492 Independent Districts and Schools AUSTIN PUBLIC SCHOOL DISTRICT 270345004638 280 I.J. HOLTON INTERMEDIATE SCHOOL Elementary School (Grades PK-6) Regular School No Middle 05 06 2017   pk_12_total 376.0 49.0 216.0   0.0 37.0     3.0   30.0   362.0 349.0     67.0   5.0     417.0   120.0   711.0 376 49 216   0 37     3   30   362 349     67 5   417 120   711
693663 MN Ramsey 62 school 2722950 621 Independent Districts and Schools MOUNDS VIEW PUBLIC SCHOOL DISTRICT 272295001124 30 PINEWOOD ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 01 05 2017   pk_12_total 285.0 64.0 69.0   6.0 66.0     3.0   49.0   282.0 260.0     69.0   7.0     308.0   65.0   542.0 285 64 69   6 66     3   49   282 260     69 7   308 65   542
694405 MN Saint Louis 69 school 2711040 709 Independent Districts and Schools DULUTH PUBLIC SCHOOL DISTRICT 271104000475 520 Lowell Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   pk_12_total 266.0 24.0 16.0   25.0 6.0     3.0   36.0   192.0 184.0     14.0   15.0     166.0   33.0   376.0 266 24 16   25 6     3   36   192 184     14 15   166 33   376
695368 MN Wright 86 school 2707200 877 Independent Districts and Schools BUFFALO-HANOVER-MONTROSE PUBLIC SCH 270720001875 60 TATANKA ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   pk_12_total 465.0 11.0 12.0   6.0 3.0     3.0   28.0   271.0 257.0     10.0   6.0     166.0   73.0   528.0 465 11 12   6 3     3   28   271 257     10 6   166 73   528
695995 MN Todd 77 school 2700109 2753 Independent Districts and Schools Long Prairie-Grey Eagle School District 270010900680 10 Long Prairie-Grey Eagle Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   kindergarten 29.0 0.0 29.0   0.0 1.0     3.0   1.0   38.0 25.0     23.0   *     43.0   4.0   63.0 29 0 29   0 1     3   1   38 25     23     43 4   63
696574 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124002699 288 NELLIE STONE JOHNSON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 08 2017   pk_12_total 21.0 255.0 146.0   7.0 4.0     3.0   13.0   232.0 217.0     150.0   54.0         82.0   449.0 21 255 146   7 4     3   13   232 217     150 54     82   449
697749 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   pk_12_total 734.0 82.0 34.0   2.0 22.0     3.0   33.0   503.0 407.0     31.0   7.0     268.0   119.0   910.0 734 82 34   2 22     3   33   503 407     31 7   268 119   910
697815 MN Cottonwood 17 school 2742780 177 Independent Districts and Schools WINDOM PUBLIC SCHOOL DISTRICT 274278003068 60 WINDOM MIDDLE Middle School (Grades 5-8) Regular School No Elementary 04 08 2017   grade_4 56.0 5.0 23.0   0.0 2.0     3.0   5.0   52.0 42.0     19.0   0.0     47.0   15.0   94.0 56 5 23   0 2     3   5   52 42     19 0   47 15   94
697842 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 2017   pk_12_total 182.0 79.0 57.0   3.0 36.0     3.0   25.0   196.0 189.0     11.0   7.0     182.0   33.0   385.0 182 79 57   3 36     3   25   196 189     11 7   182 33   385
697854 MN Dakota 19 school 2717780 194 Independent Districts and Schools LAKEVILLE PUBLIC SCHOOL DISTRICT 271778002435 89 MCGUIRE MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   pk_12_total 786.0 27.0 44.0   3.0 37.0     3.0   48.0   494.0 454.0     10.0   2.0     126.0   135.0   948.0 786 27 44   3 37     3   48   494 454     10 2   126 135   948
698182 MN Ramsey 62 school 2723850 622 Independent Districts and Schools North St Paul-Maplewood Oakdale Public School District 272385001170 55 JOHN GLENN MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   pk_12_total 230.0 159.0 108.0   5.0 206.0     3.0   55.0   374.0 392.0     110.0   12.0     544.0   137.0   766.0 230 159 108   5 206     3   55   374 392     110 12   544 137   766
698718 MN Blue Earth 7 school 2718780 77 Independent Districts and Schools MANKATO PUBLIC SCHOOL DISTRICT 271878000879 160 MANKATO EAST SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 09 12 2017   pk_12_total 814.0 192.0 78.0   9.0 37.0     3.0   15.0   587.0 561.0     72.0   12.0     446.0   147.0   1148.0 814 192 78   9 37     3   15   587 561     72 12   446 147   1148
698739 MN Carver 10 school 2741460 110 Independent Districts and Schools WACONIA PUBLIC SCHOOL DISTRICT 274146000358 310 WACONIA SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 09 12 2017   pk_12_total 1118.0 9.0 40.0   2.0 9.0     3.0   17.0   612.0 586.0     7.0   1.0     116.0   101.0   1198.0 1118 9 40   2 9     3   17   612 586     7 1   116 101   1198
698825 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239001379 38 ROSEMOUNT SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 09 12 2017   pk_12_total 1724.0 138.0 123.0   10.0 149.0     3.0   46.0   1119.0 1074.0     35.0   2.0     339.0   267.0   2193.0 1724 138 123   10 149     3   46   1119 1074     35 2   339 267   2193
698838 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239002645 88 EASTVIEW SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 09 12 2017   pk_12_total 1507.0 213.0 141.0   3.0 256.0     3.0   84.0   1119.0 1088.0     32.0   9.0     374.0   204.0   2207.0 1507 213 141   3 256     3   84   1119 1088     32 9   374 204   2207
698893 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 2017   pk_12_total 619.0 361.0 436.0   10.0 156.0     3.0   61.0   877.0 769.0     167.0   28.0     892.0   239.0   1646.0 619 361 436   10 156     3   61   877 769     167 28   892 239   1646
699000 MN Kandiyohi 34 school 2742720 347 Independent Districts and Schools WILLMAR PUBLIC SCHOOL DISTRICT 274272001809 300 WILLMAR SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 09 12 2017   pk_12_total 625.0 235.0 315.0   7.0 26.0     3.0   8.0   646.0 573.0     274.0   3.0     649.0   145.0   1219.0 625 235 315   7 26     3   8   646 573     274 3   649 145   1219
699365 MN Wright 86 school 2721390 882 Independent Districts and Schools MONTICELLO PUBLIC SCHOOL DISTRICT 272139001079 20 MONTICELLO SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 09 12 2017   pk_12_total 1020.0 28.0 85.0   1.0 14.0     3.0   21.0   604.0 568.0         5.0     279.0   165.0   1172.0 1020 28 85   1 14     3   21   604 568       5   279 165   1172
699545 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124001037 364 SOUTHWEST SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 09 12 2017   pk_12_total 994.0 495.0 174.0   15.0 105.0     3.0   8.0   892.0 902.0     195.0   31.0     624.0   205.0   1794.0 994 495 174   15 105     3   8   892 902     195 31   624 205   1794
699861 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 Other 06 12 2017   grade_6 83.0 79.0 75.0   1.0 16.0     3.0   25.0   144.0 138.0     54.0   2.0     185.0   74.0   282.0 83 79 75   1 16     3   25   144 138     54 2   185 74   282
699862 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 Other 06 12 2017   grade_7 64.0 68.0 55.0   3.0 16.0     3.0   28.0   132.0 105.0     54.0   2.0     161.0   57.0   237.0 64 68 55   3 16     3   28   132 105     54 2   161 57   237
700440 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318002168 437 EARLY CHILDHOOD/SPECIAL EDUCATION Special Education Special Education School No Elementary PK PK 2017   early_childhood_special_ed 530.0 65.0 73.0   4.0 35.0     3.0   58.0   525.0 243.0     0.0   29.0     191.0   *   768.0 530 65 73   4 35     3   58   525 243     0 29   191     768
700441 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318002168 437 EARLY CHILDHOOD/SPECIAL EDUCATION Special Education Special Education School No Elementary PK PK 2017   pk_12_total 530.0 65.0 73.0   4.0 35.0     3.0   58.0   525.0 243.0     0.0   29.0     191.0   *   768.0 530 65 73   4 35     3   58   525 243     0 29   191     768
690221 MN Lac qui Parle 37 school 2700125 2853 Independent Districts and Schools LAC QUI PARLE VALLEY SCHOOL DIST. 270012502260 40 LAC QUI PARLE VALLEY SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   pk_12_total 265.0 2.0 15.0   0.0 7.0     26.0   5.0   164.0 156.0     14.0   2.0     118.0   36.0   320.0 265 2 15   0 7     26   5   164 156     14 2   118 36   320
696061 MN Swift 76 school 2700125 2853 Independent Districts and Schools LAC QUI PARLE VALLEY SCHOOL DIST. 270012500129 20 APPLETON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2017   pk_12_total 124.0 2.0 18.0   1.0 0.0     20.0   14.0   86.0 93.0     25.0   0.0     110.0   34.0   179.0 124 2 18   1 0     20   14   86 93     25 0   110 34   179
689200 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   pk_12_total 378.0 4.0 6.0   0.0 2.0     2.0   2.0   197.0 197.0     0.0   3.0     115.0   52.0   394.0 378 4 6   0 2     2   2   197 197     0 3   115 52   394
689236 MN Goodhue 25 school 2707500 252 Independent Districts and Schools CANNON FALLS PUBLIC SCHOOL DISTRICT 270750000324 2 Cannon Falls Secondary Secondary School (Grades 7-12) Regular School No Other 06 12 2017   pk_12_total 569.0 4.0 20.0   4.0 6.0     2.0   22.0   322.0 305.0     0.0   5.0     125.0   58.0   627.0 569 4 20   4 6     2   22   322 305     0 5   125 58   627
689406 MN Lake 38 school 2740740 381 Independent Districts and Schools LAKE SUPERIOR PUBLIC SCHOOL DIST. 274074001697 90 Wm. M. Kelley Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2017   pk_12_total 151.0 1.0 2.0   0.0 2.0     2.0   1.0   89.0 70.0     0.0   6.0         *   159.0 151 1 2   0 2     2   1   89 70     0 6         159
689475 MN Martin 46 school 2740680 458 Independent Districts and Schools TRUMAN PUBLIC SCHOOL DISTRICT 274068001693 20 TRUMAN SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   grade_11 16.0 0.0 1.0   0.0 0.0     2.0   1.0   17.0 3.0     0.0   0.0     4.0   5.0   20.0 16 0 1   0 0     2   1   17 3     0 0   4 5   20
689477 MN Martin 46 school 2740680 458 Independent Districts and Schools TRUMAN PUBLIC SCHOOL DISTRICT 274068001693 20 TRUMAN SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   pk_12_total 67.0 2.0 3.0   0.0 0.0     2.0   4.0   49.0 29.0     0.0   0.0     31.0   10.0   78.0 67 2 3   0 0     2   4   49 29     0 0   31 10   78
689938 MN Winona 85 school 2733450 858 Independent Districts and Schools ST. CHARLES PUBLIC SCHOOL DISTRICT 273345001476 3 ST. CHARLES SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   pk_12_total 364.0 2.0 48.0   0.0 7.0     2.0   14.0   242.0 195.0     5.0   0.0     108.0   30.0   437.0 364 2 48   0 7     2   14   242 195     5 0   108 30   437
689944 MN Wright 86 school 2718810 881 Independent Districts and Schools MAPLE LAKE PUBLIC SCHOOL DISTRICT 271881000886 20 MAPLE LAKE SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   grade_12 70.0 0.0 0.0   0.0 0.0     2.0   1.0   39.0 34.0     0.0   0.0     14.0   9.0   73.0 70 0 0   0 0     2   1   39 34     0 0   14 9   73
690093 MN Chippewa 12 school 2700091 2180 Independent Districts and Schools MACCRAY School District 270009100365 20 MACCRAY SENIOR HIGH Secondary School (Grades 7-12) Regular School No High 07 12 2017   pk_12_total 225.0 2.0 25.0   0.0 2.0     2.0   5.0   124.0 137.0     2.0   2.0     119.0   53.0   261.0 225 2 25   0 2     2   5   124 137     2 2   119 53   261
690186 MN Todd 77 school 2700109 2753 Independent Districts and Schools Long Prairie-Grey Eagle School District 270010900850 20 LONG PRAIRIE-GREY SECONDARY SCHOOL Secondary School (Grades 7-12) Regular School No High 07 12 2017   grade_7 37.0 0.0 26.0   1.0 1.0     2.0   0.0   42.0 25.0     8.0   0.0     40.0   10.0   67.0 37 0 26   1 1     2   0   42 25     8 0   40 10   67
690191 MN Todd 77 school 2700109 2753 Independent Districts and Schools Long Prairie-Grey Eagle School District 270010900850 20 LONG PRAIRIE-GREY SECONDARY SCHOOL Secondary School (Grades 7-12) Regular School No High 07 12 2017   grade_12 47.0 0.0 14.0   0.0 0.0     2.0   3.0   33.0 33.0     0.0   1.0     22.0   8.0   66.0 47 0 14   0 0     2   3   33 33     0 1   22 8   66
690217 MN Lac qui Parle 37 school 2700125 2853 Independent Districts and Schools LAC QUI PARLE VALLEY SCHOOL DIST. 270012502260 40 LAC QUI PARLE VALLEY SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   grade_9 51.0 1.0 4.0   0.0 1.0     2.0   0.0   29.0 30.0     1.0   0.0     19.0   2.0   59.0 51 1 4   0 1     2   0   29 30     1 0   19 2   59
690434 MN Ramsey 62 school 2700344 4105 Charter Schools GREAT RIVER SCHOOL 270034404093 10 GREAT RIVER SCHOOL Secondary School (Grades 7-12) Regular School Yes High 07 12 2017   grade_10 36.0 2.0 4.0   1.0 6.0     2.0   0.0   22.0 29.0     0.0   0.0     7.0   7.0   51.0 36 2 4   1 6     2   0   22 29     0 0   7 7   51
690437 MN Ramsey 62 school 2700344 4105 Charter Schools GREAT RIVER SCHOOL 270034404093 10 GREAT RIVER SCHOOL Secondary School (Grades 7-12) Regular School Yes High 07 12 2017   pk_12_total 235.0 20.0 26.0   7.0 14.0     2.0   3.0   157.0 150.0     1.0   0.0     48.0   55.0   307.0 235 20 26   7 14     2   3   157 150     1 0   48 55   307
690637 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 2017   pk_12_total 332.0 31.0 36.0   5.0 40.0     2.0   17.0   234.0 229.0     53.0   3.0     183.0   74.0   463.0 332 31 36   5 40     2   17   234 229     53 3   183 74   463
690668 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000123 417 SAND CREEK ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_2 104.0 18.0 7.0   0.0 8.0     2.0   3.0   79.0 63.0     9.0   0.0     47.0   23.0   142.0 104 18 7   0 8     2   3   79 63     9 0   47 23   142
690672 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000123 417 SAND CREEK ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   pk_12_total 567.0 79.0 34.0   5.0 57.0     2.0   40.0   408.0 376.0     70.0   9.0     258.0   128.0   784.0 567 79 34   5 57     2   40   408 376     70 9   258 128   784
690718 MN Hennepin 27 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318002193 425 OXBOW CREEK ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_2 134.0 22.0 8.0   0.0 13.0     2.0   10.0   98.0 91.0     12.0   2.0     48.0   17.0   189.0 134 22 8   0 13     2   10   98 91     12 2   48 17   189
690724 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 2017   grade_1 187.0 4.0 7.0   1.0 9.0     2.0   7.0   109.0 108.0     16.0   1.0     35.0   20.0   217.0 187 4 7   1 9     2   7   109 108     16 1   35 20   217
690734 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318003058 427 RUM RIVER ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_4 170.0 6.0 4.0   0.0 4.0     2.0   10.0   108.0 88.0     3.0   1.0     37.0   31.0   196.0 170 6 4   0 4     2   10   108 88     3 1   37 31   196
690736 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318003058 427 RUM RIVER ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   pk_12_total 915.0 22.0 30.0   2.0 18.0     2.0   29.0   535.0 483.0     22.0   4.0     191.0   158.0   1018.0 915 22 30   2 18     2   29   535 483     22 4   191 158   1018
691104 MN Blue Earth 7 school 2718780 77 Independent Districts and Schools MANKATO PUBLIC SCHOOL DISTRICT 271878000872 150 EAGLE LAKE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   pk_12_total 350.0 18.0 17.0   0.0 1.0     2.0   22.0   217.0 193.0     6.0   5.0     115.0   56.0   410.0 350 18 17   0 1     2   22   217 193     6 5   115 56   410
691341 MN Chippewa 12 school 2721320 129 Independent Districts and Schools MONTEVIDEO PUBLIC SCHOOL DISTRICT 272132001074 20 SANFORD EDUCATION CENTER Elementary School (Grades PK-6) Regular School No Elementary PK KG 2017   pk_12_total 111.0 3.0 26.0   0.0 2.0     2.0   10.0   89.0 65.0     18.0   0.0     78.0   57.0   154.0 111 3 26   0 2     2   10   89 65     18 0   78 57   154
691430 MN Cottonwood 17 school 2742780 177 Independent Districts and Schools WINDOM PUBLIC SCHOOL DISTRICT 274278001816 30 WINFAIR ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 03 2017   kindergarten 61.0 3.0 15.0   0.0 2.0     2.0   3.0   41.0 45.0     10.0   0.0     39.0   9.0   86.0 61 3 15   0 2     2   3   41 45     10 0   39 9   86
691431 MN Cottonwood 17 school 2742780 177 Independent Districts and Schools WINDOM PUBLIC SCHOOL DISTRICT 274278001816 30 WINFAIR ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 03 2017   grade_1 60.0 0.0 13.0   0.0 1.0     2.0   5.0   40.0 41.0     11.0   0.0     43.0   12.0   81.0 60 0 13   0 1     2   5   40 41     11 0   43 12   81
691620 MN Dakota 19 school 2717780 194 Independent Districts and Schools LAKEVILLE PUBLIC SCHOOL DISTRICT 271778000815 591 KENNEDY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   pk_12_total 484.0 16.0 24.0   0.0 22.0     2.0   30.0   311.0 267.0     16.0   *     72.0   82.0   578.0 484 16 24   0 22     2   30   311 267     16     72 82   578
691727 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 2017   pk_12_total 523.0 110.0 185.0   5.0 45.0     2.0   91.0   483.0 478.0     173.0   4.0     363.0   113.0   961.0 523 110 185   5 45     2   91   483 478     173 4   363 113   961
691740 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239001944 713 THOMAS LAKE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_5 52.0 9.0 3.0   0.0 7.0     2.0   4.0   46.0 31.0     8.0   0.0         15.0   77.0 52 9 3   0 7     2   4   46 31     8 0     15   77
691794 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239000512 764 Glacier Hills Elementary School of Arts and Science Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_1 55.0 13.0 9.0   1.0 38.0     2.0   5.0   65.0 58.0     29.0   0.0     26.0   16.0   123.0 55 13 9   1 38     2   5   65 58     29 0   26 16   123
691799 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239000512 764 Glacier Hills Elementary School of Arts and Science Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   pk_12_total 351.0 86.0 74.0   4.0 198.0     2.0   57.0   363.0 409.0     167.0   2.0     186.0   72.0   772.0 351 86 74   4 198     2   57   363 409     167 2   186 72   772
691824 MN Dakota 19 school 2742270 197 Independent Districts and Schools WEST ST. PAUL-MENDOTA HTS.-EAGAN 274227001773 817 GARLOUGH ENVIRONMENTAL MAGNET Elementary School (Grades PK-6) Regular School No Elementary KG 04 2017   pk_12_total 151.0 47.0 175.0   0.0 8.0     2.0   38.0   203.0 218.0     140.0   3.0     239.0   51.0   421.0 151 47 175   0 8     2   38   203 218     140 3   239 51   421
692229 MN Hennepin 27 school 2714220 272 Independent Districts and Schools EDEN PRAIRIE PUBLIC SCHOOL DISTRICT 271422000736 882 FOREST HILLS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 06 2017   pk_12_total 290.0 121.0 51.0   3.0 124.0     2.0   53.0   331.0 313.0     119.0   2.0     177.0   81.0   644.0 290 121 51   3 124     2   53   331 313     119 2   177 81   644
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
692513 MN Hennepin 27 school 2731750 280 Independent Districts and Schools RICHFIELD PUBLIC SCHOOL DISTRICT 273175001316 701 SHERIDAN HILLS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_1 26.0 21.0 15.0   2.0 8.0     2.0   9.0   46.0 37.0     34.0   0.0     51.0   12.0   83.0 26 21 15   2 8     2   9   46 37     34 0   51 12   83
692518 MN Hennepin 27 school 2731750 280 Independent Districts and Schools RICHFIELD PUBLIC SCHOOL DISTRICT 273175001316 701 SHERIDAN HILLS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   pk_12_total 173.0 117.0 129.0   2.0 44.0     2.0   57.0   260.0 264.0     148.0   0.0     305.0   64.0   524.0 173 117 129   2 44     2   57   260 264     148 0   305 64   524
692602 MN Hennepin 27 school 2731780 281 Independent Districts and Schools ROBBINSDALE PUBLIC SCHOOL DISTRICT 273178004952 401 The FAIR School - Crystal Elementary School (Grades PK-6) Regular School No Elementary 04 08 2017   pk_12_total 205.0 262.0 45.0   11.0 15.0     2.0   47.0   248.0 339.0     27.0   9.0     313.0   79.0   587.0 205 262 45   11 15     2   47   248 339     27 9   313 79   587
692604 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 2017   kindergarten 76.0 7.0 11.0   0.0 10.0     2.0   11.0   63.0 54.0     17.0   0.0         13.0   117.0 76 7 11   0 10     2   11   63 54     17 0     13   117
692610 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 2017   pk_12_total 463.0 65.0 53.0   3.0 64.0     2.0   58.0   356.0 352.0     97.0   3.0     150.0   62.0   708.0 463 65 53   3 64     2   58   356 352     97 3   150 62   708
692638 MN Hennepin 27 school 2733780 283 Independent Districts and Schools ST. LOUIS PARK PUBLIC SCHOOL DIST. 273378002653 758 PARK SPANISH IMMERSION ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   pk_12_total 349.0 22.0 80.0   0.0 11.0     2.0   42.0   251.0 255.0         4.0     88.0   *   506.0 349 22 80   0 11     2   42   251 255       4   88     506
692666 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 2017   pk_12_total 310.0 86.0 21.0   0.0 22.0     2.0   27.0   240.0 228.0     38.0   0.0     103.0   50.0   468.0 310 86 21   0 22     2   27   240 228     38 0   103 50   468
692816 MN Itasca 31 school 2713170 318 Independent Districts and Schools GRAND RAPIDS PUBLIC SCHOOL DISTRICT 271317000662 120 FOREST LAKE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 04 2017   pk_12_total 303.0 1.0 9.0   6.0 0.0     2.0   45.0   192.0 174.0     0.0   0.0     189.0   56.0   366.0 303 1 9   6 0     2   45   192 174     0 0   189 56   366

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