enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

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
698930 698930 MN Hennepin 27 school 2725200 279 Independent Districts and Schools OSSEO PUBLIC SCHOOL DISTRICT 272520001221 88 PARK CENTER IB WORLD SCHOOL Senior High School (Grades 9-12) Regular School No High 09 12 2017   pk_12_total 343.0 705.0 234.0   10.0 656.0     0.0   94.0   1038.0 1004.0     239.0   31.0     1353.0   255.0   2042.0 343 705 234   10 656     0   94   1038 1004     239 31   1353 255   2042
698945 698945 MN Hennepin 27 school 2731780 281 Independent Districts and Schools ROBBINSDALE PUBLIC SCHOOL DISTRICT 273178001319 50 ROBBINSDALE COOPER SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 09 12 2017   pk_12_total 454.0 628.0 226.0   13.0 171.0     0.0   88.0   784.0 796.0     131.0   40.0     1032.0   238.0   1580.0 454 628 226   13 171     0   88   784 796     131 40   1032 238   1580
698925 698925 MN Hennepin 27 school 2725200 279 Independent Districts and Schools OSSEO PUBLIC SCHOOL DISTRICT 272520001218 32 OSSEO SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 09 12 2017   pk_12_total 814.0 617.0 182.0   15.0 282.0     1.0   111.0   1022.0 1000.0     145.0   18.0     1007.0   227.0   2022.0 814 617 182   15 282     1   111   1022 1000     145 18   1007 227   2022
699535 699535 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124001035 362 SOUTH SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 09 12 2017   pk_12_total 597.0 615.0 361.0   123.0 78.0     1.0   12.0   894.0 893.0     452.0   70.0     1017.0   238.0   1787.0 597 615 361   123 78     1   12   894 893     452 70   1017 238   1787
699158 699158 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384001564 210 CENTRAL SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 09 12 2017   pk_12_total 669.0 591.0 88.0   9.0 379.0     0.0   28.0   809.0 955.0     271.0   24.0     897.0   175.0   1764.0 669 591 88   9 379     0   28   809 955     271 24   897 175   1764
696750 696750 MN Ramsey 62 school 2700140 4027 Charter Schools HIGHER GROUND ACADEMY 270014002719 10 HIGHER GROUND ACADEMY Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2017   pk_12_total 0.0 590.0 0.0   0.0 0.0     0.0   0.0   282.0 308.0     30.0   0.0         23.0   590.0 0 590 0   0 0     0   0   282 308     30 0     23   590
696897 696897 MN Hennepin 27 school 2700188 4077 Charter Schools Twin Cities International Elementary School 270018803141 10 Twin Cities International Elementary School Elementary School (Grades PK-6) Regular School Yes Elementary KG 04 2017   pk_12_total 1.0 587.0 0.0   0.0 0.0     0.0   0.0   275.0 313.0     478.0   0.0         14.0   588.0 1 587 0   0 0     0   0   275 313     478 0     14   588
699525 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
696492 696492 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124002297 193 SULLIVAN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 08 2017   pk_12_total 26.0 558.0 28.0   29.0 9.0     0.0   7.0   336.0 321.0     409.0   33.0         111.0   657.0 26 558 28   29 9     0   7   336 321     409 33     111   657
699272 699272 MN Stearns 73 school 2733510 742 Independent Districts and Schools ST. CLOUD PUBLIC SCHOOL DISTRICT 273351001479 57 APOLLO SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 09 12 2017   pk_12_total 689.0 526.0 65.0   9.0 73.0     0.0   72.0   723.0 711.0     389.0   13.0     844.0   244.0   1434.0 689 526 65   9 73     0   72   723 711     389 13   844 244   1434
699277 699277 MN Stearns 73 school 2733510 742 Independent Districts and Schools ST. CLOUD PUBLIC SCHOOL DISTRICT 273351001494 59 TECHNICAL SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 09 12 2017   pk_12_total 822.0 523.0 41.0   11.0 43.0     0.0   53.0   785.0 708.0     358.0   10.0     746.0   190.0   1493.0 822 523 41   11 43     0   53   785 708     358 10   746 190   1493
698657 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
699520 699520 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124000958 352 EDISON SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 09 12 2017   pk_12_total 153.0 515.0 193.0   34.0 53.0     0.0   9.0   479.0 478.0     286.0   80.0     783.0   241.0   957.0 153 515 193   34 53     0   9   479 478     286 80   783 241   957
689692 689692 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384004429 252 WASHINGTON TECH SECONDARY MAGNET Secondary School (Grades 7-12) Regular School No Other 06 12 2017   pk_12_total 93.0 504.0 248.0   13.0 1208.0     1.0   47.0   1127.0 987.0     992.0   16.0     1894.0   308.0   2114.0 93 504 248   13 1208     1   47   1127 987     992 16   1894 308   2114
699545 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
696666 696666 MN Hennepin 27 school 2700096 4011 Charter Schools Athlos Leadership Academy 270009601892 10 Athlos Leadership Academy Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2017   pk_12_total 183.0 479.0 61.0   4.0 54.0     0.0   127.0   481.0 427.0     93.0   8.0     560.0   79.0   908.0 183 479 61   4 54     0   127   481 427     93 8   560 79   908
698805 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
697999 697999 MN Hennepin 27 school 2731780 281 Independent Districts and Schools ROBBINSDALE PUBLIC SCHOOL DISTRICT 273178002184 43 ROBBINSDALE MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   pk_12_total 313.0 458.0 249.0   9.0 100.0     1.0   108.0   663.0 575.0     146.0   24.0     882.0   168.0   1238.0 313 458 249   9 100     1   108   663 575     146 24   882 168   1238
698555 698555 MN Hennepin 27 school 2700189 4078 Charter Schools Minnesota International Middle Charter 270018903142 10 Minnesota International Middle Charter School Middle School (Grades 5-8) Regular School Yes Middle 05 08 2017   pk_12_total 3.0 439.0 0.0   0.0 0.0     0.0   1.0   201.0 242.0     136.0   1.0         23.0   443.0 3 439 0   0 0     0   1   201 242     136 1     23   443
692703 692703 MN Hennepin 27 school 2706240 286 Independent Districts and Schools BROOKLYN CENTER SCHOOL DISTRICT 270624000274 480 EARLE BROWN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   pk_12_total 133.0 437.0 267.0   7.0 170.0     0.0   92.0   559.0 547.0     261.0   22.0     881.0   129.0   1106.0 133 437 267   7 170     0   92   559 547     261 22   881 129   1106
697505 697505 MN Ramsey 62 school 2700399 4231 Charter Schools Minnesota Math and Science Academy 270039904788 10 Minnesota Math and Science Academy Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2017   pk_12_total 3.0 427.0 7.0   1.0 26.0     0.0   5.0   223.0 246.0     307.0   0.0         16.0   469.0 3 427 7   1 26     0   5   223 246     307 0     16   469
696412 696412 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124001031 160 SEWARD ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 08 2017   pk_12_total 310.0 420.0 51.0   24.0 34.0     0.0   22.0   403.0 458.0     243.0   18.0     509.0   56.0   861.0 310 420 51   24 34     0   22   403 458     243 18   509 56   861
699168 699168 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384001585 215 HARDING SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 09 12 2017   pk_12_total 126.0 417.0 213.0   39.0 1061.0     0.0   28.0   972.0 912.0     780.0   16.0     1528.0   246.0   1884.0 126 417 213   39 1061     0   28   972 912     780 16   1528 246   1884
698950 698950 MN Hennepin 27 school 2731780 281 Independent Districts and Schools ROBBINSDALE PUBLIC SCHOOL DISTRICT 273178001318 53 ROBBINSDALE ARMSTRONG SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 09 12 2017   pk_12_total 1125.0 415.0 213.0   15.0 122.0     1.0   91.0   1001.0 981.0     57.0   25.0     708.0   225.0   1982.0 1125 415 213   15 122     1   91   1001 981     57 25   708 225   1982
694732 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
699163 699163 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384001955 212 COMO PARK SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 09 12 2017   pk_12_total 268.0 398.0 116.0   17.0 455.0     0.0   24.0   687.0 591.0     486.0   19.0     867.0   154.0   1278.0 268 398 116   17 455     0   24   687 591     486 19   867 154   1278
696558 696558 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124002476 282 LUCY LANEY @ CLEVELAND PARK ELEM. Elementary School (Grades PK-6) Regular School No Elementary PK 08 2017   pk_12_total 13.0 397.0 12.0   16.0 9.0     0.0   14.0   231.0 230.0     14.0   77.0         85.0   461.0 13 397 12   16 9     0   14   231 230     14 77     85   461
689277 689277 MN Hennepin 27 school 2706240 286 Independent Districts and Schools BROOKLYN CENTER SCHOOL DISTRICT 270624000273 12 BROOKLYN CENTER SECONDARY Secondary School (Grades 7-12) Regular School No Other 06 12 2017   pk_12_total 104.0 385.0 219.0   14.0 155.0     0.0   41.0   441.0 477.0     149.0   30.0     755.0   145.0   918.0 104 385 219   14 155     0   41   441 477     149 30   755 145   918
689676 689676 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384001598 225 HUMBOLDT HIGH SCHOOL Secondary School (Grades 7-12) Regular School No Other 06 12 2017   pk_12_total 60.0 380.0 235.0   11.0 517.0     0.0   40.0   615.0 628.0     678.0   21.0         198.0   1243.0 60 380 235   11 517     0   40   615 628     678 21     198   1243
696871 696871 MN Hennepin 27 school 2700184 4068 Charter Schools EXCELL ACADEMY CHARTER 270018403137 10 EXCELL ACADEMY CHARTER Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2017   pk_12_total 4.0 374.0 15.0   0.0 6.0     0.0   7.0   195.0 211.0     97.0   17.0         46.0   406.0 4 374 15   0 6     0   7   195 211     97 17     46   406
698608 698608 MN Hennepin 27 school 2700309 4192 Charter Schools BEST ACADEMY 270030904773 20 Best Academy K-8 at Penn Middle School (Grades 5-8) Regular School Yes Elementary KG 08 2017   pk_12_total 2.0 361.0 4.0   1.0 0.0     0.0   9.0   250.0 127.0     12.0   13.0     330.0   82.0   377.0 2 361 4   1 0     0   9   250 127     12 13   330 82   377
698893 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
698668 698668 MN Anoka 2 school 2709510 13 Independent Districts and Schools COLUMBIA HEIGHTS PUBLIC SCHOOL DIST 270951000396 16 COLUMBIA HEIGHTS SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 08 12 2017   pk_12_total 178.0 360.0 280.0   8.0 52.0     0.0   30.0   451.0 457.0     171.0   14.0     704.0   143.0   908.0 178 360 280   8 52     0   30   451 457     171 14   704 143   908
699550 699550 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124001055 368 WASHBURN SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 09 12 2017   pk_12_total 812.0 358.0 353.0   27.0 80.0     1.0   10.0   866.0 775.0     229.0   37.0     656.0   239.0   1641.0 812 358 353   27 80     1   10   866 775     229 37   656 239   1641
699530 699530 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124001026 360 ROOSEVELT SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 09 12 2017   pk_12_total 214.0 357.0 329.0   53.0 34.0     0.0   4.0   540.0 451.0     285.0   49.0     673.0   207.0   991.0 214 357 329   53 34     0   4   540 451     285 49   673 207   991
696481 696481 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124000932 190 ANDERSEN COMMUNITY Elementary School (Grades PK-6) Regular School No Elementary PK 08 2017   pk_12_total 42.0 355.0 546.0   50.0 17.0     0.0   15.0   542.0 483.0     699.0   84.0         169.0   1025.0 42 355 546   50 17     0   15   542 483     699 84     169   1025
699147 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
698888 698888 MN Hennepin 27 school 2714260 270 Independent Districts and Schools HOPKINS PUBLIC SCHOOL DISTRICT 271426000613 282 HOPKINS SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 10 12 2017   pk_12_total 968.0 351.0 142.0   5.0 114.0     1.0   75.0   866.0 790.0     70.0   22.0     595.0   204.0   1656.0 968 351 142   5 114     1   75   866 790     70 22   595 204   1656
699555 699555 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124004557 375 NORTH ACADEMY SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 09 12 2017   pk_12_total 14.0 351.0 12.0   3.0 7.0     0.0   3.0   195.0 195.0     15.0   35.0     332.0   111.0   390.0 14 351 12   3 7     0   3   195 195     15 35   332 111   390
702561 702561 MN Stearns 73 school 2733510 742 Independent Districts and Schools ST. CLOUD PUBLIC SCHOOL DISTRICT 273351002188 52 NORTH JUNIOR HIGH Junior High School (Grades 7-8 or 7-9) Regular School No Middle 06 08 2017   pk_12_total 341.0 346.0 70.0   7.0 46.0     0.0   60.0   450.0 420.0     248.0   22.0     635.0   161.0   870.0 341 346 70   7 46     0   60   450 420     248 22   635 161   870
702565 702565 MN Stearns 73 school 2733510 742 Independent Districts and Schools ST. CLOUD PUBLIC SCHOOL DISTRICT 273351001492 54 SOUTH JUNIOR HIGH Junior High School (Grades 7-8 or 7-9) Regular School No Middle 06 08 2017   pk_12_total 433.0 346.0 50.0   4.0 9.0     0.0   55.0   452.0 445.0     214.0   15.0     552.0   156.0   897.0 433 346 50   4 9     0   55   452 445     214 15   552 156   897
697695 697695 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   pk_12_total 1181.0 344.0 154.0   13.0 295.0     0.0   131.0   1058.0 1060.0     116.0   17.0     751.0   258.0   2118.0 1181 344 154   13 295     0   131   1058 1060     116 17   751 258   2118
699687 699687 MN Hennepin 27 school 2700363 4121 Charter Schools UBAH MEDICAL ACADEMY CHARTER SCHOOL 270036304107 10 UBAH MEDICAL ACADEMY CHARTER SCHOOL Senior High School (Grades 9-12) Regular School Yes High 09 12 2017   pk_12_total 2.0 344.0 0.0   0.0 1.0     0.0   0.0   150.0 197.0     121.0   1.0         13.0   347.0 2 344 0   0 1     0   0   150 197     121 1     13   347
698960 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
697317 697317 MN Hennepin 27 school 2700309 4192 Charter Schools BEST ACADEMY 270030904261 10 Best Academy East at Olson Elementary School (Grades PK-6) Regular School Yes Elementary KG 07 2017   pk_12_total 0.0 340.0 0.0   0.0 0.0     0.0   0.0   179.0 161.0     248.0   10.0     300.0   13.0   340.0 0 340 0   0 0     0   0   179 161     248 10   300 13   340
697060 697060 MN Olmsted 55 school 2700247 4135 Charter Schools ROCHESTER MATH AND SCIENCE ACADEMY 270024703308 10 ROCHESTER MATH AND SCIENCE ACADEMY Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2017   pk_12_total 3.0 334.0 0.0   0.0 0.0     0.0   0.0   184.0 153.0     84.0   0.0         18.0   337.0 3 334 0   0 0     0   0   184 153     84 0     18   337
694167 694167 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384001634 578 OBAMA SERVICE LEARNING ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   pk_12_total 9.0 333.0 36.0   9.0 35.0     0.0   50.0   239.0 233.0     37.0   43.0         70.0   472.0 9 333 36   9 35     0   50   239 233     37 43     70   472
697280 697280 MN Anoka 2 school 2700313 4186 Charter Schools GLOBAL ACADEMY 270031304294 10 GLOBAL ACADEMY Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2017   pk_12_total 85.0 331.0 3.0   0.0 6.0     0.0   4.0   207.0 222.0     152.0   1.0     369.0   39.0   429.0 85 331 3   0 6     0   4   207 222     152 1   369 39   429
697983 697983 MN Hennepin 27 school 2725200 279 Independent Districts and Schools OSSEO PUBLIC SCHOOL DISTRICT 272520001214 86 North View Middle School, an IB World School Middle School (Grades 5-8) Regular School No Middle 06 08 2017   pk_12_total 50.0 327.0 106.0   4.0 169.0     1.0   42.0   377.0 322.0     130.0   13.0     593.0   135.0   699.0 50 327 106   4 169     1   42   377 322     130 13   593 135   699
698906 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
697720 697720 MN Anoka 2 school 2712420 14 Independent Districts and Schools FRIDLEY PUBLIC SCHOOL DISTRICT 271242000610 23 FRIDLEY MIDDLE Middle School (Grades 5-8) Regular School No Middle 05 08 2017   pk_12_total 344.0 322.0 116.0   8.0 69.0     1.0   64.0   467.0 457.0     73.0   13.0     619.0   137.0   924.0 344 322 116   8 69     1   64   467 457     73 13   619 137   924
698642 698642 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000100 2 Coon Rapids High School Senior High School (Grades 9-12) Regular School No High 09 12 2017   pk_12_total 1320.0 322.0 129.0   43.0 138.0     0.0   54.0   1038.0 968.0     102.0   38.0     899.0   281.0   2006.0 1320 322 129   43 138     0   54   1038 968     102 38   899 281   2006
697975 697975 MN Hennepin 27 school 2725200 279 Independent Districts and Schools OSSEO PUBLIC SCHOOL DISTRICT 272520001208 33 Brooklyn Middle School, a Science, Technology, Engineering, Art and Math School Middle School (Grades 5-8) Regular School No Middle 06 08 2017   pk_12_total 172.0 321.0 93.0   0.0 254.0     0.0   75.0   477.0 438.0     120.0   7.0     593.0   124.0   915.0 172 321 93   0 254     0   75   477 438     120 7   593 124   915
696705 696705 MN Hennepin 27 school 2700117 4017 Charter Schools Minnesota Transitions Charter School 270011703566 17 Banaadir Academy Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2017   pk_12_total 1.0 315.0 0.0   0.0 0.0     0.0   1.0   150.0 167.0     272.0   13.0         17.0   317.0 1 315 0   0 0     0   1   150 167     272 13     17   317
698673 698673 MN Anoka 2 school 2712420 14 Independent Districts and Schools FRIDLEY PUBLIC SCHOOL DISTRICT 271242000611 22 FRIDLEY SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 09 12 2017   pk_12_total 339.0 313.0 85.0   17.0 77.0     0.0   46.0   460.0 417.0     74.0   7.0     522.0   135.0   877.0 339 313 85   17 77     0   46   460 417     74 7   522 135   877
698843 698843 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239001373 97 APPLE VALLEY SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 09 12 2017   pk_12_total 911.0 311.0 240.0   6.0 88.0     2.0   70.0   861.0 767.0     54.0   6.0     591.0   252.0   1628.0 911 311 240   6 88     2   70   861 767     54 6   591 252   1628
699178 699178 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384001603 230 JOHNSON SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 09 12 2017   pk_12_total 135.0 310.0 142.0   17.0 718.0     1.0   17.0   778.0 562.0     412.0   12.0     1094.0   221.0   1340.0 135 310 142   17 718     1   17   778 562     412 12   1094 221   1340
696380 696380 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124001014 151 JENNY LIND ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   pk_12_total 13.0 296.0 21.0   11.0 67.0     0.0   29.0   223.0 214.0     57.0   52.0         48.0   437.0 13 296 21   11 67     0   29   223 214     57 52     48   437
696775 696775 MN Hennepin 27 school 2700153 4032 Charter Schools Harvest Preparatory School 270015302948 10 Harvest Preparatory School Elementary School (Grades PK-6) Regular School Yes Elementary KG 04 2017   pk_12_total 2.0 296.0 5.0   0.0 0.0     0.0   3.0   143.0 163.0     12.0   17.0         28.0   306.0 2 296 5   0 0     0   3   143 163     12 17     28   306
699173 699173 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384001592 220 HIGHLAND PARK SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 09 12 2017   pk_12_total 500.0 296.0 284.0   11.0 165.0     0.0   18.0   667.0 607.0     227.0   14.0     593.0   131.0   1274.0 500 296 284   11 165     0   18   667 607     227 14   593 131   1274
693897 693897 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384001952 424 BENJAMIN E MAYS MAGNET Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   pk_12_total 10.0 292.0 21.0   5.0 80.0     1.0   33.0   222.0 220.0     115.0   23.0     390.0   56.0   442.0 10 292 21   5 80     1   33   222 220     115 23   390 56   442
697149 697149 MN Ramsey 62 school 2700263 4153 Charter Schools DUGSI ACADEMY 270026303320 10 DUGSI ACADEMY Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2017   pk_12_total 0.0 292.0 1.0   0.0 1.0     1.0   0.0   145.0 150.0         0.0         20.0   295.0 0 292 1   0 1     1   0   145 150       0     20   295
697464 697464 MN Ramsey 62 school 2700393 4225 Charter Schools Universal Academy Charter School 270039304758 10 Universal Academy Charter School Elementary School (Grades PK-6) Regular School Yes Elementary KG 07 2017   pk_12_total 0.0 287.0 0.0   0.0 6.0     0.0   0.0   122.0 171.0         0.0         0.0   293.0 0 287 0   0 6     0   0   122 171       0     0   293
692553 692553 MN Hennepin 27 school 2731780 281 Independent Districts and Schools ROBBINSDALE PUBLIC SCHOOL DISTRICT 273178001326 10 MEADOW LAKE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   pk_12_total 117.0 286.0 125.0   9.0 29.0     0.0   40.0   321.0 285.0     137.0   19.0     484.0   76.0   606.0 117 286 125   9 29     0   40   321 285     137 19   484 76   606
697372 697372 MN Hennepin 27 school 2700335 4205 Charter Schools HENNEPIN ELEMENTARY SCHOOL 270033504554 10 HENNEPIN ELEMENTARY SCHOOL Elementary School (Grades PK-6) Regular School Yes Elementary KG 06 2017   pk_12_total 1.0 286.0 51.0   0.0 0.0     0.0   0.0   180.0 158.0     247.0   0.0         36.0   338.0 1 286 51   0 0     0   0   180 158     247 0     36   338
696793 696793 MN Hennepin 27 school 2700159 4038 Charter Schools SOJOURNER TRUTH ACADEMY 270015902954 10 SOJOURNER TRUTH ACADEMY Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2017   pk_12_total 4.0 278.0 81.0   1.0 0.0     0.0   12.0   198.0 178.0     63.0   13.0         59.0   376.0 4 278 81   1 0     0   12   198 178     63 13     59   376
690504 690504 MN Ramsey 62 school 2700367 4200 Charter Schools STEP ACADEMY CHARTER SCHOOL 270036704507 10 STEP ACADEMY CHARTER SCHOOL Secondary School (Grades 7-12) Regular School Yes Other 06 12 2017   pk_12_total 2.0 276.0 0.0   0.0 0.0     0.0   0.0   133.0 145.0     87.0   0.0         7.0   278.0 2 276 0   0 0     0   0   133 145     87 0     7   278
699142 699142 MN Washington 82 school 2723850 622 Independent Districts and Schools North St Paul-Maplewood Oakdale Public School District 272385001177 58 TARTAN SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 09 12 2017   pk_12_total 843.0 276.0 202.0   9.0 258.0     0.0   63.0   859.0 792.0     89.0   15.0     762.0   222.0   1651.0 843 276 202   9 258     0   63   859 792     89 15   762 222   1651
697995 697995 MN Hennepin 27 school 2731780 281 Independent Districts and Schools ROBBINSDALE PUBLIC SCHOOL DISTRICT 273178001333 40 PLYMOUTH MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   pk_12_total 733.0 275.0 147.0   6.0 65.0     2.0   121.0   665.0 684.0     53.0   23.0     523.0   138.0   1349.0 733 275 147   6 65     2   121   665 684     53 23   523 138   1349
694056 694056 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   pk_12_total 479.0 274.0 84.0   2.0 343.0     1.0   65.0   663.0 585.0     219.0   1.0     571.0   66.0   1248.0 479 274 84   2 343     1   65   663 585     219 1   571 66   1248
698647 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
699097 699097 MN Olmsted 55 school 2731800 535 Independent Districts and Schools ROCHESTER PUBLIC SCHOOL DISTRICT 273180001015 310 JOHN MARSHALL SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 08 12 2017   pk_12_total 1016.0 274.0 107.0   11.0 189.0     0.0   50.0   828.0 819.0     76.0   26.0     558.0   194.0   1647.0 1016 274 107   11 189     0   50   828 819     76 26   558 194   1647
699132 699132 MN Ramsey 62 school 2722950 621 Independent Districts and Schools MOUNDS VIEW PUBLIC SCHOOL DISTRICT 272295001118 65 IRONDALE SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 09 12 2017   pk_12_total 975.0 273.0 197.0   10.0 152.0     1.0   62.0   842.0 828.0     47.0   25.0     667.0   188.0   1670.0 975 273 197   10 152     1   62   842 828     47 25   667 188   1670
699137 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
694033 694033 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384004457 489 HAZEL PARK PREPARATORY ACADEMY Elementary School (Grades PK-6) Regular School No Elementary PK 08 2017   pk_12_total 37.0 271.0 110.0   4.0 202.0     1.0   28.0   335.0 318.0     203.0   37.0     549.0   72.0   653.0 37 271 110   4 202     1   28   335 318     203 37   549 72   653
696582 696582 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124002700 289 WHITTIER INTERNATIONAL Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   pk_12_total 140.0 268.0 158.0   9.0 18.0     0.0   16.0   301.0 308.0     212.0   38.0     424.0   73.0   609.0 140 268 158   9 18     0   16   301 308     212 38   424 73   609
696462 696462 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124000986 179 JEFFERSON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 08 2017   pk_12_total 30.0 267.0 301.0   9.0 15.0     1.0   14.0   329.0 308.0     349.0   44.0         118.0   637.0 30 267 301   9 15     1   14   329 308     349 44     118   637
692602 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
698520 698520 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124001028 324 SANFORD MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   pk_12_total 365.0 262.0 141.0   63.0 36.0     1.0   30.0   438.0 460.0     166.0   34.0     559.0   129.0   898.0 365 262 141   63 36     1   30   438 460     166 34   559 129   898
694714 694714 MN Stearns 73 school 2733510 742 Independent Districts and Schools ST. CLOUD PUBLIC SCHOOL DISTRICT 273351001487 31 MADISON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   pk_12_total 294.0 260.0 39.0   5.0 13.0     0.0   56.0   327.0 340.0     177.0   23.0     468.0   107.0   667.0 294 260 39   5 13     0   56   327 340     177 23   468 107   667
696308 696308 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124000943 107 BETHUNE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   pk_12_total 21.0 260.0 8.0   7.0 9.0     0.0   11.0   175.0 141.0     17.0   37.0         66.0   316.0 21 260 8   7 9     0   11   175 141     17 37     66   316
696299 696299 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124000942 106 BARTON OPEN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 08 2017   pk_12_total 387.0 258.0 33.0   8.0 22.0     1.0   20.0   378.0 351.0     147.0   6.0     323.0   38.0   729.0 387 258 33   8 22     1   20   378 351     147 6   323 38   729
696574 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
698524 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
697715 697715 MN Anoka 2 school 2709510 13 Independent Districts and Schools COLUMBIA HEIGHTS PUBLIC SCHOOL DIST 270951000395 17 COLUMBIA ACADEMY Middle School (Grades 5-8) Regular School No Middle 06 08 2017   pk_12_total 123.0 251.0 271.0   8.0 36.0     2.0   52.0   377.0 366.0     143.0   30.0     613.0   112.0   743.0 123 251 271   8 36     2   52   377 366     143 30   613 112   743
692373 692373 MN Hennepin 27 school 2725200 279 Independent Districts and Schools OSSEO PUBLIC SCHOOL DISTRICT 272520002211 668 EDINBROOK ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   pk_12_total 109.0 248.0 60.0   4.0 224.0     1.0   71.0   395.0 322.0     169.0   13.0     449.0   89.0   717.0 109 248 60   4 224     1   71   395 322     169 13   449 89   717
696601 696601 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124004778 293 Cityview Community Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   pk_12_total 27.0 248.0 18.0   7.0 16.0     0.0   14.0   178.0 152.0     52.0   58.0         78.0   330.0 27 248 18   7 16     0   14   178 152     52 58     78   330
698508 698508 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124001008 316 NORTHEAST MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   pk_12_total 118.0 248.0 123.0   17.0 32.0     0.0   13.0   288.0 263.0     105.0   39.0     456.0   111.0   551.0 118 248 123   17 32     0   13   288 263     105 39   456 111   551
696524 696524 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124002144 226 MARCY OPEN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 08 2017   pk_12_total 328.0 247.0 58.0   18.0 33.0     1.0   27.0   385.0 327.0     103.0   12.0     384.0   76.0   712.0 328 247 58   18 33     1   27   385 327     103 12   384 76   712
698504 698504 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124000937 309 ANWATIN MIDDLE COM & SPANISH D I Middle School (Grades 5-8) Regular School No Middle 06 08 2017   pk_12_total 70.0 242.0 186.0   10.0 49.0     1.0   7.0   291.0 274.0     153.0   41.0     437.0   107.0   565.0 70 242 186   10 49     1   7   291 274     153 41   437 107   565
696372 696372 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124000999 144 LYNDALE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   pk_12_total 148.0 240.0 62.0   4.0 10.0     0.0   11.0   255.0 220.0     187.0   19.0     311.0   62.0   475.0 148 240 62   4 10     0   11   255 220     187 19   311 62   475
696451 696451 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124001866 175 FOLWELL ARTS MAGNET Elementary School (Grades PK-6) Regular School No Elementary PK 08 2017   pk_12_total 111.0 238.0 468.0   26.0 13.0     0.0   28.0   412.0 472.0     360.0   50.0         127.0   884.0 111 238 468   26 13     0   28   412 472     360 50     127   884
694723 694723 MN Stearns 73 school 2733510 742 Independent Districts and Schools ST. CLOUD PUBLIC SCHOOL DISTRICT 273351002287 35 DISCOVERY COMMUNITY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   pk_12_total 104.0 235.0 60.0   0.0 17.0     0.0   18.0   229.0 205.0     204.0   15.0     387.0   74.0   434.0 104 235 60   0 17     0   18   229 205     204 15   387 74   434
699000 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
698201 698201 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384001556 310 BATTLE CREEK MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   pk_12_total 49.0 233.0 121.0   11.0 299.0     0.0   20.0   415.0 318.0     327.0   22.0     602.0   117.0   733.0 49 233 121   11 299     0   20   415 318     327 22   602 117   733
699183 699183 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   pk_12_total 737.0 230.0 228.0   1.0 24.0     0.0   10.0   632.0 598.0     171.0   33.0     566.0   127.0   1230.0 737 230 228   1 24     0   10   632 598     171 33   566 127   1230
697104 697104 MN Stearns 73 school 2700252 4142 Charter Schools Stride Academy Charter School 270025204405 20 Stride Academy K-8 Charter School Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2017   pk_12_total 411.0 226.0 14.0   1.0 17.0     2.0   17.0   339.0 349.0     141.0   5.0     369.0   72.0   688.0 411 226 14   1 17     2   17   339 349     141 5   369 72   688
696289 696289 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124000941 105 BANCROFT ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   pk_12_total 100.0 225.0 139.0   53.0 18.0     0.0   28.0   279.0 284.0     209.0   27.0     474.0   86.0   563.0 100 225 139   53 18     0   28   279 284     209 27   474 86   563
699864 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
694746 694746 MN Stearns 73 school 2733510 742 Independent Districts and Schools ST. CLOUD PUBLIC SCHOOL DISTRICT 273351002285 51 OAK HILL COMMUNITY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   pk_12_total 321.0 220.0 33.0   0.0 20.0     0.0   28.0   327.0 295.0     172.0   *     328.0   79.0   622.0 321 220 33   0 20     0   28   327 295     172     328 79   622

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