Data source: Big Local News · About: Big Local

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

View and edit SQL

year

  • 2019 · 13,903
Link rowid state county county_state_id admin_level district_nces_id district_state_id district_state_type district school_nces_id school_state_id school school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ccd_school_high_grade year term grade white black hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int ▲ homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
1952721 MN Ramsey 62 school 2700304 4181 Charter Schools COMMUNITY SCHOOL OF EXCELLENCE 270030403728 10 COMMUNITY SCHOOL OF EXCELLENCE Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2019   pk_12_total 0.0 10.0 4.0   1.0 1322.0     0.0   7.0   670.0 674.0     827.0   1.0     1117.0   137.0   1344.0 0 10 4   1 1322     0   7   670 674     827 1   1117 137   1344
1945035 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384004429 252 WASHINGTON TECH SECONDARY MAGNET Secondary School (Grades 7-12) Regular School No High 06 12 2019   pk_12_total 98.0 499.0 245.0   12.0 1164.0     2.0   63.0   1120.0 963.0     759.0   17.0     1807.0   297.0   2083.0 98 499 245   12 1164     2   63   1120 963     759 17   1807 297   2083
1954755 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384001585 215 HARDING SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 09 12 2019   pk_12_total 116.0 402.0 277.0   42.0 1038.0     0.0   33.0   988.0 920.0     644.0   28.0     1396.0   235.0   1908.0 116 402 277   42 1038     0   33   988 920     644 28   1396 235   1908
1948746 MN Nobles 53 school 2744160 518 Independent Districts and Schools WORTHINGTON PUBLIC SCHOOL DISTRICT 274416001836 1 PRAIRIE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2019   pk_12_total 245.0 83.0 729.0   1.0 118.0     0.0   42.0   625.0 593.0     596.0   4.0     925.0   160.0   1218.0 245 83 729   1 118     0   42   625 593     596 4   925 160   1218
1945019 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 High 06 12 2019   pk_12_total 73.0 324.0 220.0   4.0 530.0     0.0   36.0   614.0 573.0     569.0   27.0     1003.0   195.0   1187.0 73 324 220   4 530     0   36   614 573     569 27   1003 195   1187
1951959 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 2019   pk_12_total 38.0 321.0 483.0   25.0 11.0     0.0   12.0   437.0 453.0     506.0   50.0         161.0   890.0 38 321 483   25 11     0   12   437 453     506 50     161   890
1952702 MN Hennepin 27 school 2700295 4171 Charter Schools NOBLE ACADEMY 270029503727 10 NOBLE ACADEMY Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2019   pk_12_total 4.0 116.0 12.0   0.0 894.0     0.0   3.0   542.0 487.0     494.0   0.0     539.0   68.0   1029.0 4 116 12   0 894     0   3   542 487     494 0   539 68   1029
1954750 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 2019   pk_12_total 249.0 454.0 121.0   16.0 426.0     0.0   41.0   675.0 632.0     481.0   22.0     841.0   167.0   1307.0 249 454 121   16 426     0   41   675 632     481 22   841 167   1307
1949613 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384001619 541 PHALEN LAKE HMONG STUDIES MAGNET Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   pk_12_total 6.0 25.0 33.0   0.0 572.0     0.0   15.0   340.0 311.0     456.0   1.0     524.0   45.0   651.0 6 25 33   0 572     0   15   340 311     456 1   524 45   651
1955116 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 2019   pk_12_total 582.0 652.0 313.0   111.0 63.0     1.0   17.0   880.0 859.0     440.0   24.0     949.0   216.0   1739.0 582 652 313   111 63     1   17   880 859     440 24   949 216   1739
1952455 MN Ramsey 62 school 2700342 4103 Charter Schools HMONG COLLEGE PREP ACADEMY 270034205102 30 Hmong College Prep Academy ES Elementary School (Grades PK-6) Regular School Yes Elementary KG 05 2019   pk_12_total 0.0 0.0 4.0   0.0 1004.0     0.0   8.0   533.0 483.0     415.0   5.0     803.0   85.0   1016.0 0 0 4   0 1004     0   8   533 483     415 5   803 85   1016
1952579 MN Hennepin 27 school 2700253 4143 Charter Schools NEW MILLENNIUM ACADEMY CHARTER SCH 270025303311 10 New Millenium Academy Charter School Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2019   pk_12_total 4.0 33.0 21.0   1.0 624.0     0.0   5.0   356.0 332.0     414.0   34.0     522.0   54.0   688.0 4 33 21   1 624     0   5   356 332     414 34   522 54   688
1954865 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 2019   pk_12_total 733.0 643.0 65.0   8.0 33.0     3.0   58.0   781.0 762.0     413.0   21.0     844.0   223.0   1543.0 733 643 65   8 33     3   58   781 762     413 21   844 223   1543
1954860 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 2019   pk_12_total 640.0 578.0 87.0   7.0 71.0     0.0   85.0   760.0 708.0     392.0   31.0     854.0   267.0   1468.0 640 578 87   7 71     0   85   760 708     392 31   854 267   1468
1949652 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384004491 558 SAINT PAUL MUSIC ACADEMY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   pk_12_total 22.0 135.0 75.0   0.0 365.0     0.0   40.0   307.0 330.0     371.0   8.0     563.0   86.0   637.0 22 135 75   0 365     0   40   307 330     371 8   563 86   637
1952367 MN Hennepin 27 school 2700189 4078 Charter Schools Twin Cities International Schools 270018905160 20 Twin Cities International Schools Elementary School (Grades PK-6) Regular School Yes Elementary KG 04 2019   pk_12_total 0.0 569.0 0.0   0.0 0.0     0.0   0.0   276.0 293.0     343.0   0.0         30.0   569.0 0 569 0   0 0     0   0   276 293     343 0     30   569
1949584 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384001611 527 Mississippi Creative Arts Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   pk_12_total 47.0 132.0 71.0   4.0 334.0     0.0   31.0   315.0 304.0     340.0   16.0     532.0   83.0   619.0 47 132 71   4 334     0   31   315 304     340 16   532 83   619
1951971 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 2019   pk_12_total 30.0 485.0 29.0   25.0 7.0     0.0   11.0   314.0 273.0     329.0   60.0     512.0   132.0   587.0 30 485 29   25 7     0   11   314 273     329 60   512 132   587
1949636 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384002454 552 PAUL & SHEILA WELLSTONE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   pk_12_total 27.0 118.0 267.0   4.0 91.0     0.0   30.0   279.0 258.0     317.0   10.0     440.0   92.0   537.0 27 118 267   4 91     0   30   279 258     317 10   440 92   537
1955111 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124001026 360 ROOSEVELT SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 09 12 2019   pk_12_total 229.0 351.0 336.0   44.0 37.0     1.0   16.0   541.0 473.0     313.0   13.0     598.0   188.0   1014.0 229 351 336   44 37     1   16   541 473     313 13   598 188   1014
1954765 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384001603 230 JOHNSON SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 09 12 2019   pk_12_total 131.0 297.0 146.0   9.0 676.0     0.0   36.0   738.0 557.0     312.0   14.0     984.0   205.0   1295.0 131 297 146   9 676     0   36   738 557     312 14   984 205   1295
1954583 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 2019   pk_12_total 604.0 271.0 350.0   6.0 39.0     5.0   7.0   648.0 634.0     309.0   2.0     693.0   144.0   1282.0 604 271 350   6 39     5   7   648 634     309 2   693 144   1282
1954385 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 2019   pk_12_total 1165.0 534.0 418.0   13.0 238.0     7.0   128.0   1288.0 1215.0     304.0   24.0     1061.0   308.0   2503.0 1165 534 418   13 238     7   128   1288 1215     304 24   1061 308   2503
1950243 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 2019   pk_12_total 89.0 449.0 28.0   4.0 13.0     0.0   42.0   320.0 305.0     302.0   22.0         96.0   625.0 89 449 28   4 13     0   42   320 305     302 22     96   625
1950234 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 2019   pk_12_total 105.0 321.0 61.0   5.0 12.0     3.0   30.0   296.0 241.0     299.0   25.0     460.0   84.0   537.0 105 321 61   5 12     3   30   296 241     299 25   460 84   537
1951928 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 2019   pk_12_total 93.0 220.0 428.0   30.0 8.0     1.0   34.0   405.0 409.0     298.0   14.0     697.0   124.0   814.0 93 220 428   30 8     1   34   405 409     298 14   697 124   814
1948117 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 2019   pk_12_total 90.0 481.0 228.0   9.0 141.0     0.0   58.0   505.0 502.0     289.0   27.0     849.0   135.0   1007.0 90 481 228   9 141     0   58   505 502     289 27   849 135   1007
1952361 MN Ramsey 62 school 2700185 4073 Charter Schools Academia Cesar Chavez Charter School 270018503138 10 Academia Cesar Chavez Charter School Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2019   pk_12_total 17.0 7.0 507.0   0.0 3.0     0.0   7.0   247.0 294.0     286.0   33.0     475.0   73.0   541.0 17 7 507   0 3     0   7   247 294     286 33   475 73   541
1949446 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384001581 464 FROST LAKE ELEMENTARY SCHOOL Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   pk_12_total 32.0 118.0 69.0   2.0 281.0     1.0   32.0   276.0 259.0     284.0   5.0     410.0   79.0   535.0 32 118 69   2 281     1   32   276 259     284 5   410 79   535
1949405 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384001575 449 BRUCE F VENTO ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   pk_12_total 17.0 131.0 42.0   1.0 295.0     0.0   28.0   256.0 258.0     282.0   19.0     459.0   59.0   514.0 17 131 42   1 295     0   28   256 258     282 19   459 59   514
1949420 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384001172 458 FARNSWORTH AEROSPACE LOWER Elementary School (Grades PK-6) Regular School No Elementary PK 04 2019   pk_12_total 33.0 56.0 42.0   3.0 329.0     0.0   16.0   255.0 224.0     279.0   6.0     349.0   40.0   479.0 33 56 42   3 329     0   16   255 224     279 6   349 40   479
1952070 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 2019   pk_12_total 9.0 246.0 17.0   9.0 236.0     0.0   8.0   272.0 253.0     270.0   10.0     466.0   76.0   525.0 9 246 17   9 236     0   8   272 253     270 10   466 76   525
1955101 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 2019   pk_12_total 182.0 559.0 167.0   33.0 50.0     0.0   14.0   513.0 492.0     269.0   29.0     753.0   229.0   1005.0 182 559 167   33 50     0   14   513 492     269 29   753 229   1005
1952349 MN Ramsey 62 school 2700230 4070 Charter Schools HOPE COMMUNITY ACADEMY 270023003482 10 HOPE COMMUNITY ACADEMY Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2019   pk_12_total 6.0 19.0 1.0   0.0 467.0     1.0   0.0   238.0 256.0     267.0   0.0     390.0   34.0   494.0 6 19 1   0 467     1   0   238 256     267 0   390 34   494
1952692 MN Hennepin 27 school 2700288 4170 Charter Schools HIAWATHA ACADEMIES 270028804669 12 Hiawatha Leadership Academy-Northrop Elementary School (Grades PK-6) Regular School Yes Elementary KG 04 2019   pk_12_total 7.0 29.0 279.0   14.0 2.0     1.0   5.0   180.0 157.0     259.0   8.0         55.0   337.0 7 29 279   14 2     1   5   180 157     259 8     55   337
1947591 MN Hennepin 27 school 2705790 271 Independent Districts and Schools BLOOMINGTON PUBLIC SCHOOL DISTRICT 270579000238 459 VALLEY VIEW ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   pk_12_total 69.0 130.0 260.0   4.0 39.0     1.0   39.0   254.0 288.0     256.0   14.0     437.0   70.0   542.0 69 130 260   4 39     1   39   254 288     256 14   437 70   542
1946169 MN Anoka 2 school 2709510 13 Independent Districts and Schools COLUMBIA HEIGHTS PUBLIC SCHOOL DIST 270951000402 520 VALLEY VIEW ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   pk_12_total 74.0 150.0 250.0   2.0 15.0     1.0   45.0   275.0 262.0     255.0   15.0     409.0   *   537.0 74 150 250   2 15     1   45   275 262     255 15   409     537
1953682 MN Nobles 53 school 2744160 518 Independent Districts and Schools WORTHINGTON PUBLIC SCHOOL DISTRICT 274416001840 4 WORTHINGTON MIDDLE Middle School (Grades 5-8) Regular School No Middle 05 08 2019   pk_12_total 246.0 76.0 518.0   4.0 105.0     1.0   26.0   497.0 479.0     254.0   2.0     722.0   159.0   976.0 246 76 518   4 105     1   26   497 479     254 2   722 159   976
1955126 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 2019   pk_12_total 1052.0 535.0 205.0   16.0 90.0     5.0   20.0   986.0 937.0     253.0   0.0     720.0   248.0   1923.0 1052 535 205   16 90     5   20   986 937     253 0   720 248   1923
1952791 MN Hennepin 27 school 2700309 4192 Charter Schools BEST ACADEMY 270030904261 10 BEST ACADEMY Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2019   pk_12_total 0.0 742.0 0.0   0.0 0.0     0.0   14.0   408.0 348.0     249.0   56.0     667.0   88.0   756.0 0 742 0   0 0     0   14   408 348     249 56   667 88   756
1954508 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 2019   pk_12_total 282.0 758.0 261.0   15.0 646.0     1.0   100.0   1045.0 1018.0     249.0   37.0     1311.0   255.0   2063.0 282 758 261   15 646     1   100   1045 1018     249 37   1311 255   2063
1951940 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 2019   pk_12_total 21.0 169.0 245.0   5.0 15.0     1.0   24.0   237.0 243.0     248.0   4.0         95.0   480.0 21 169 245   5 15     1   24   237 243     248 4     95   480
1953027 MN Ramsey 62 school 2700410 4240 Charter Schools New Century School 270041004873 10 New Century School Elementary School (Grades PK-6) Regular School Yes Elementary KG 07 2019   pk_12_total 0.0 293.0 0.0   1.0 0.0     0.0   0.0   143.0 151.0     248.0   0.0         10.0   294.0 0 293 0   1 0     0   0   143 151     248 0     10   294
1952614 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 2019   pk_12_total 0.0 286.0 0.0   0.0 1.0     0.0   1.0   137.0 151.0     243.0   0.0         18.0   288.0 0 286 0   0 1     0   1   137 151     243 0     18   288
1955449 MN Dakota 19 school 2707290 191 Independent Districts and Schools BURNSVILLE PUBLIC SCHOOL DISTRICT 270729002640 314 BURNSVILLE AREA LEARNING CENTER Public Area Learning Center ALC (State approved) Alternative School No High 06 12 2019   pk_12_total 322.0 344.0 277.0   10.0 84.0     5.0   77.0   578.0 541.0     243.0   13.0     712.0   245.0   1119.0 322 344 277   10 84     5   77   578 541     243 13   712 245   1119
1952024 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124001882 260 EMERSON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   pk_12_total 64.0 47.0 347.0   6.0 5.0     0.0   20.0   239.0 250.0     238.0   3.0     340.0   48.0   489.0 64 47 347   6 5     0   20   239 250     238 3   340 48   489
1952686 MN Hennepin 27 school 2700288 4170 Charter Schools HIAWATHA ACADEMIES 270028803725 10 HIAWATHA LEADERSHIP ACAD-MORRIS PK Elementary School (Grades PK-6) Regular School Yes Elementary KG 04 2019   pk_12_total 2.0 21.0 282.0   3.0 1.0     0.0   4.0   155.0 158.0     236.0   1.0     276.0   38.0   313.0 2 21 282   3 1     0   4   155 158     236 1   276 38   313
1953768 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384001556 310 BATTLE CREEK MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2019   pk_12_total 46.0 260.0 103.0   7.0 292.0     0.0   42.0   399.0 351.0     235.0   18.0     584.0   118.0   750.0 46 260 103   7 292     0   42   399 351     235 18   584 118   750
1954734 MN Ramsey 62 school 2732430 623 Independent Districts and Schools ROSEVILLE PUBLIC SCHOOL DISTRICT 273243001385 69 ROSEVILLE AREA SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 09 12 2019   pk_12_total 1084.0 352.0 288.0   9.0 478.0     0.0   104.0   1144.0 1171.0     234.0   34.0     911.0   302.0   2315.0 1084 352 288   9 478     0   104   1144 1171     234 34   911 302   2315
1948830 MN Olmsted 55 school 2731800 535 Independent Districts and Schools ROCHESTER PUBLIC SCHOOL DISTRICT 273180000996 126 GAGE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   pk_12_total 232.0 215.0 134.0   4.0 107.0     0.0   76.0   373.0 395.0     228.0   7.0     494.0   121.0   768.0 232 215 134   4 107     0   76   373 395     228 7   494 121   768
1952425 MN Hennepin 27 school 2700237 4097 Charter Schools PARTNERSHIP ACADEMY, INC. 270023703278 10 PARTNERSHIP ACADEMY, INC. Elementary School (Grades PK-6) Regular School Yes Elementary KG 06 2019   pk_12_total 1.0 13.0 278.0   2.0 0.0     0.0   3.0   159.0 138.0     228.0   0.0     250.0   46.0   297.0 1 13 278   2 0     0   3   159 138     228 0   250 46   297
1954659 MN Nobles 53 school 2744160 518 Independent Districts and Schools WORTHINGTON PUBLIC SCHOOL DISTRICT 274416001841 8 WORTHINGTON SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 09 12 2019   pk_12_total 292.0 66.0 504.0   7.0 88.0     0.0   23.0   507.0 473.0     220.0   1.0     636.0   144.0   980.0 292 66 504   7 88     0   23   507 473     220 1   636 144   980
1954751 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384001585 215 HARDING SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 09 12 2019   grade_9 18.0 104.0 94.0   17.0 261.0     0.0   15.0   256.0 253.0     215.0   9.0     396.0   58.0   509.0 18 104 94   17 261     0   15   256 253     215 9   396 58   509
1948303 MN Kandiyohi 34 school 2742720 347 Independent Districts and Schools WILLMAR PUBLIC SCHOOL DISTRICT 274272002445 109 KENNEDY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   pk_12_total 255.0 129.0 324.0   0.0 15.0     5.0   14.0   382.0 360.0     214.0   *     520.0   65.0   742.0 255 129 324   0 15     5   14   382 360     214     520 65   742
1954473 MN Hennepin 27 school 2705790 271 Independent Districts and Schools BLOOMINGTON PUBLIC SCHOOL DISTRICT 270579000220 7 KENNEDY SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 09 12 2019   pk_12_total 529.0 321.0 436.0   11.0 139.0     2.0   69.0   796.0 711.0     214.0   26.0     808.0   253.0   1507.0 529 321 436   11 139     2   69   796 711     214 26   808 253   1507
1951890 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 PK 08 2019   pk_12_total 323.0 414.0 43.0   19.0 21.0     0.0   26.0   401.0 445.0     213.0   2.0     461.0   58.0   846.0 323 414 43   19 21     0   26   401 445     213 2   461 58   846
1949706 MN Rice 66 school 2711760 656 Independent Districts and Schools FARIBAULT PUBLIC SCHOOL DISTRICT 271176000561 30 JEFFERSON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   pk_12_total 134.0 192.0 119.0   0.0 5.0     0.0   15.0   247.0 218.0     212.0   11.0     362.0   54.0   465.0 134 192 119   0 5     0   15   247 218     212 11   362 54   465
1952799 MN Ramsey 62 school 2700325 4193 Charter Schools COLLEGE PREPARATORY ELEMENTARY 270032504338 10 COLLEGE PREPARATORY ELEMENTARY Elementary School (Grades PK-6) Regular School Yes Elementary KG 06 2019   pk_12_total 7.0 46.0 5.0   0.0 264.0     1.0   13.0   174.0 162.0     212.0   0.0         36.0   336.0 7 46 5   0 264     1   13   174 162     212 0     36   336
1958100 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 2019   pk_12_total 413.0 416.0 53.0   2.0 13.0     0.0   57.0   492.0 462.0     212.0   21.0     595.0   140.0   954.0 413 416 53   2 13     0   57   492 462     212 21   595 140   954
1947905 MN Hennepin 27 school 2731750 280 Independent Districts and Schools RICHFIELD PUBLIC SCHOOL DISTRICT 273175001311 695 CENTENNIAL ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   pk_12_total 68.0 82.0 236.0   9.0 14.0     0.0   38.0   234.0 213.0     210.0   13.0     368.0   66.0   447.0 68 82 236   9 14     0   38   234 213     210 13   368 66   447
1947922 MN Hennepin 27 school 2731750 280 Independent Districts and Schools RICHFIELD PUBLIC SCHOOL DISTRICT 273175004212 705 RICHFIELD DUAL LANGUAGE SCHOOL Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   pk_12_total 113.0 9.0 321.0   0.0 3.0     1.0   22.0   215.0 254.0     209.0   7.0     283.0   33.0   469.0 113 9 321   0 3     1   22   215 254     209 7   283 33   469
1950260 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 2019   pk_12_total 365.0 314.0 40.0   4.0 29.0     1.0   57.0   425.0 385.0     209.0   8.0     461.0   127.0   810.0 365 314 40   4 29     1   57   425 385     209 8   461 127   810
1952059 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 2019   pk_12_total 106.0 254.0 132.0   5.0 12.0     0.0   19.0   260.0 268.0     208.0   3.0     399.0   64.0   528.0 106 254 132   5 12     0   19   260 268     208 3   399 64   528
1953773 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384001567 315 FARNSWORTH AEROSPACE UPPER Middle School (Grades 5-8) Regular School No Middle 05 08 2019   pk_12_total 33.0 118.0 70.0   6.0 387.0     0.0   29.0   349.0 294.0     208.0   11.0     491.0   85.0   643.0 33 118 70   6 387     0   29   349 294     208 11   491 85   643
1954760 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 2019   pk_12_total 474.0 300.0 310.0   12.0 197.0     0.0   35.0   672.0 656.0     205.0   5.0     605.0   132.0   1328.0 474 300 310   12 197     0   35   672 656     205 5   605 132   1328
1949379 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384001568 431 COMO PARK ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   pk_12_total 53.0 115.0 33.0   12.0 200.0     0.0   38.0   242.0 209.0     202.0   6.0     351.0   103.0   451.0 53 115 33   12 200     0   38   242 209     202 6   351 103   451
1947123 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239001942 714 Echo Park Elementary School of Leadership, Engineering and Technology Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   pk_12_total 281.0 220.0 163.0   1.0 25.0     0.0   94.0   390.0 394.0     200.0   6.0     385.0   122.0   784.0 281 220 163   1 25     0   94   390 394     200 6   385 122   784
1946932 MN Scott 70 school 2707290 191 Independent Districts and Schools BURNSVILLE PUBLIC SCHOOL DISTRICT 270729002233 490 HIDDEN VALLEY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   pk_12_total 72.0 144.0 183.0   1.0 25.0     0.0   23.0   221.0 227.0     199.0   2.0     342.0   83.0   448.0 72 144 183   1 25     0   23   221 227     199 2   342 83   448
1947989 MN Hennepin 27 school 2731780 281 Independent Districts and Schools ROBBINSDALE PUBLIC SCHOOL DISTRICT 273178001330 19 NORTHPORT ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   pk_12_total 89.0 198.0 172.0   1.0 101.0     0.0   45.0   312.0 294.0     198.0   17.0     448.0   57.0   606.0 89 198 172   1 101     0   45   312 294     198 17   448 57   606
1949628 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384001623 551 RIVERVIEW WEST SCHOOL OF EXCELLENCE Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   pk_12_total 30.0 79.0 244.0   2.0 14.0     0.0   22.0   201.0 190.0     197.0   5.0     300.0   47.0   391.0 30 79 244   2 14     0   22   201 190     197 5   300 47   391
1952851 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 04 2019   pk_12_total 2.0 254.0 12.0   0.0 0.0     0.0   0.0   134.0 134.0     197.0   0.0         21.0   268.0 2 254 12   0 0     0   0   134 134     197 0     21   268
1954745 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 2019   pk_12_total 737.0 518.0 118.0   10.0 347.0     0.0   65.0   834.0 961.0     196.0   26.0     824.0   187.0   1795.0 737 518 118   10 347     0   65   834 961     196 26   824 187   1795
1949348 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384001555 422 BATTLE CREEK ELEMENTARY SCHOOL Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   pk_12_total 34.0 136.0 56.0   9.0 203.0     0.0   34.0   256.0 216.0     195.0   6.0     346.0   85.0   472.0 34 136 56   9 203     0   34   256 216     195 6   346 85   472
1954249 MN Anoka 2 school 2709510 13 Independent Districts and Schools COLUMBIA HEIGHTS PUBLIC SCHOOL DIST 270951000396 16 COLUMBIA HEIGHTS SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 09 12 2019   pk_12_total 159.0 440.0 330.0   6.0 53.0     1.0   44.0   507.0 526.0     195.0   15.0     730.0   123.0   1033.0 159 440 330   6 53     1   44   507 526     195 15   730 123   1033
1946058 MN Hennepin 27 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000104 421 EVERGREEN PARK ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   pk_12_total 34.0 170.0 79.0   0.0 160.0     0.0   42.0   248.0 237.0     194.0   11.0     366.0   82.0   485.0 34 170 79   0 160     0   42   248 237     194 11   366 82   485
1955279 MN Hennepin 27 school 2700245 4131 Charter Schools METRO SCHOOLS CHARTER 270024503573 10 METRO SCHOOLS CHARTER Senior High School (Grades 9-12) Regular School Yes High 09 12 2019   pk_12_total 0.0 269.0 0.0   0.0 0.0     0.0   0.0   137.0 132.0     191.0   2.0     72.0   14.0   269.0 0 269 0   0 0     0   0   137 132     191 2   72 14   269
1955131 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124001055 368 WASHBURN SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 09 12 2019   pk_12_total 910.0 354.0 261.0   16.0 64.0     2.0   25.0   850.0 782.0     189.0   5.0     618.0   178.0   1632.0 910 354 261   16 64     2   25   850 782     189 5   618 178   1632
1949500 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 2019   pk_12_total 42.0 113.0 95.0   6.0 179.0     0.0   27.0   263.0 199.0     188.0   9.0     323.0   85.0   462.0 42 113 95   6 179     0   27   263 199     188 9   323 85   462
1948312 MN Kandiyohi 34 school 2742720 347 Independent Districts and Schools WILLMAR PUBLIC SCHOOL DISTRICT 274272005083 110 Lakeland Elementary School Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   pk_12_total 207.0 143.0 248.0   3.0 13.0     4.0   9.0   311.0 316.0     187.0   4.0     423.0   63.0   627.0 207 143 248   3 13     4   9   311 316     187 4   423 63   627
1954518 MN Hennepin 27 school 2731750 280 Independent Districts and Schools RICHFIELD PUBLIC SCHOOL DISTRICT 273175001315 35 RICHFIELD SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 09 12 2019   pk_12_total 295.0 194.0 438.0   7.0 69.0     1.0   76.0   573.0 507.0     187.0   13.0     668.0   183.0   1080.0 295 194 438   7 69     1   76   573 507     187 13   668 183   1080
1947766 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 2019   pk_12_total 110.0 279.0 65.0   13.0 248.0     1.0   58.0   422.0 352.0     186.0   7.0     467.0   90.0   774.0 110 279 65   13 248     1   58   422 352     186 7   467 90   774
1947814 MN Hennepin 27 school 2725200 279 Independent Districts and Schools OSSEO PUBLIC SCHOOL DISTRICT 272520001212 674 FAIR OAKS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   pk_12_total 27.0 131.0 151.0   0.0 114.0     0.0   20.0   230.0 213.0     186.0   7.0     366.0   76.0   443.0 27 131 151   0 114     0   20   230 213     186 7   366 76   443
1948294 MN Kandiyohi 34 school 2742720 347 Independent Districts and Schools WILLMAR PUBLIC SCHOOL DISTRICT 274272002221 108 ROOSEVELT ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   pk_12_total 240.0 162.0 185.0   3.0 16.0     1.0   4.0   316.0 295.0     185.0   5.0     388.0   92.0   611.0 240 162 185   3 16     1   4   316 295     185 5   388 92   611
1949552 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384001601 500 JACKSON PREPARATORY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   pk_12_total 6.0 81.0 11.0   2.0 192.0     0.0   19.0   169.0 142.0     185.0   2.0     250.0   32.0   311.0 6 81 11   2 192     0   19   169 142     185 2   250 32   311
1953274 MN Anoka 2 school 2733330 16 Independent Districts and Schools SPRING LAKE PARK PUBLIC SCHOOLS 273333001466 92 Westwood Intermediate and Middle School Middle School (Grades 5-8) Regular School No Middle 05 08 2019   pk_12_total 1041.0 223.0 283.0   16.0 142.0     4.0   130.0   933.0 906.0     185.0   12.0     637.0   201.0   1839.0 1041 223 283   16 142     4   130   933 906     185 12   637 201   1839
1955289 MN Hennepin 27 school 2700288 4170 Charter Schools HIAWATHA ACADEMIES 270028804862 13 Hiawatha Collegiate High School Senior High School (Grades 9-12) Regular School Yes High 09 12 2019   pk_12_total 3.0 45.0 375.0   2.0 0.0     0.0   12.0   197.0 240.0     184.0   15.0     360.0   57.0   437.0 3 45 375   2 0     0   12   197 240     184 15   360 57   437
1949673 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384002303 579 AMERICAN INDIAN MAGNET SCHOOL Elementary School (Grades PK-6) Regular School No Elementary PK 08 2019   pk_12_total 33.0 111.0 137.0   87.0 172.0     1.0   101.0   331.0 311.0     183.0   24.0     526.0   121.0   642.0 33 111 137   87 172     1   101   331 311     183 24   526 121   642
1952203 MN Ramsey 62 school 2700118 4018 Charter Schools ACHIEVE LANGUAGE ACADEMY 270011802608 10 ACHIEVE LANGUAGE ACADEMY Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2019   pk_12_total 42.0 60.0 184.0   1.0 144.0     3.0   18.0   214.0 238.0     182.0   9.0     371.0   43.0   452.0 42 60 184   1 144     3   18   214 238     182 9   371 43   452
1952569 MN Stearns 73 school 2700252 4142 Charter Schools Stride Academy Charter School 270025204405 20 Stride Academy K-6 Charter School Elementary School (Grades PK-6) Regular School Yes Elementary KG 06 2019   pk_12_total 114.0 230.0 16.0   1.0 2.0     0.0   9.0   200.0 172.0     182.0   0.0     191.0   43.0   372.0 114 230 16   1 2     0   9   200 172     182 0   191 43   372
1954523 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 2019   pk_12_total 419.0 698.0 282.0   15.0 171.0     1.0   131.0   851.0 866.0     182.0   40.0     1062.0   271.0   1717.0 419 698 282   15 171     1   131   851 866     182 40   1062 271   1717
1953055 MN Stearns 73 school 2700430 4250 Charter Schools Athlos Academy of Saint Cloud 270043004959 10 Athlos Academy of Saint Cloud Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2019   pk_12_total 233.0 277.0 38.0   2.0 3.0     1.0   59.0   313.0 300.0     181.0   10.0     428.0   59.0   613.0 233 277 38   2 3     1   59   313 300     181 10   428 59   613
1951481 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 2019   pk_12_total 207.0 0.0 263.0   3.0 1.0     8.0   10.0   255.0 237.0     180.0   41.0     326.0   99.0   492.0 207 0 263   3 1     8   10   255 237     180 41   326 99   492
1952448 MN Ramsey 62 school 2700342 4103 Charter Schools HMONG COLLEGE PREP ACADEMY 270034203700 20 Hmong College Prep Academy MS Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2019   pk_12_total 1.0 4.0 2.0   0.0 596.0     0.0   2.0   318.0 287.0     179.0   3.0     495.0   60.0   605.0 1 4 2   0 596     0   2   318 287     179 3   495 60   605
1946151 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 2019   pk_12_total 131.0 180.0 152.0   10.0 33.0     0.0   64.0   305.0 265.0     178.0   8.0     429.0   97.0   570.0 131 180 152   10 33     0   64   305 265     178 8   429 97   570
1949721 MN Rice 66 school 2711760 656 Independent Districts and Schools FARIBAULT PUBLIC SCHOOL DISTRICT 271176002675 45 ROOSEVELT ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   pk_12_total 176.0 120.0 152.0   2.0 8.0     0.0   15.0   237.0 236.0     177.0   6.0     361.0   62.0   473.0 176 120 152   2 8     0   15   237 236     177 6   361 62   473
1953538 MN Hennepin 27 school 2731750 280 Independent Districts and Schools RICHFIELD PUBLIC SCHOOL DISTRICT 273175001317 37 RICHFIELD MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2019   pk_12_total 262.0 141.0 425.0   7.0 43.0     1.0   90.0   500.0 469.0     177.0   20.0     624.0   148.0   969.0 262 141 425   7 43     1   90   500 469     177 20   624 148   969
1953607 MN Kandiyohi 34 school 2742720 347 Independent Districts and Schools WILLMAR PUBLIC SCHOOL DISTRICT 274272001808 301 WILLMAR MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 06 08 2019   pk_12_total 399.0 159.0 349.0   5.0 24.0     3.0   16.0   485.0 470.0     175.0   3.0     602.0   131.0   955.0 399 159 349   5 24     3   16   485 470     175 3   602 131   955
1958096 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 2019   pk_12_total 344.0 338.0 69.0   4.0 40.0     0.0   78.0   480.0 393.0     175.0   33.0     606.0   196.0   873.0 344 338 69   4 40     0   78   480 393     175 33   606 196   873
1951765 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 2019   pk_12_total 101.0 226.0 94.0   45.0 15.0     0.0   24.0   268.0 237.0     174.0   1.0     391.0   90.0   505.0 101 226 94   45 15     0   24   268 237     174 1   391 90   505
1950225 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 PK 05 2019   pk_12_total 269.0 308.0 38.0   8.0 23.0     1.0   65.0   370.0 342.0     173.0   47.0     509.0   136.0   712.0 269 308 38   8 23     1   65   370 342     173 47   509 136   712

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