enrollments

Data source: Big Local News · About: Big Local

13,757 rows where state = "MN" and year = 2017 sorted by asian 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
696982 696982 MN Ramsey 62 school 2700342 4103 Charter Schools HMONG COLLEGE PREP ACADEMY 270034203700 20 HMONG COLLEGE PREP MIDDLE ACADEMY Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2017   pk_12_total 1.0 3.0 4.0   0.0 990.0     0.0   3.0   562.0 439.0     382.0   9.0     846.0   92.0   1001.0 1 3 4   0 990     0   3   562 439     382 9   846 92   1001
691734 691734 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239001374 712 Cedar Park Elementary School of Science, Technology, Engineering and Math Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   pk_12_total 300.0 173.0 95.0   3.0 99.0     0.0   62.0   389.0 343.0     88.0   2.0     331.0   66.0   732.0 300 173 95   3 99     0   62   389 343     88 2   331 66   732
695140 695140 MN Washington 82 school 2733810 833 Independent Districts and Schools SOUTH WASHINGTON COUNTY SCHOOL DIST 273381001548 46 WOODBURY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   pk_12_total 273.0 50.0 44.0   0.0 99.0     0.0   40.0   277.0 229.0     91.0   1.0     162.0   80.0   506.0 273 50 44   0 99     0   40   277 229     91 1   162 80   506
697692 697692 MN Hennepin 27 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000108 6 JACKSON MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_6 418.0 111.0 50.0   6.0 99.0     0.0   40.0   344.0 380.0     27.0   3.0     250.0   96.0   724.0 418 111 50   6 99     0   40   344 380     27 3   250 96   724
692288 692288 MN Hennepin 27 school 2711250 273 Independent Districts and Schools EDINA PUBLIC SCHOOL DISTRICT 271125000508 532 CREEK VALLEY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   pk_12_total 388.0 40.0 36.0   0.0 98.0     0.0   39.0   297.0 304.0     60.0   1.0     59.0   80.0   601.0 388 40 36   0 98     0   39   297 304     60 1   59 80   601
699162 699162 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   grade_12 61.0 86.0 25.0   5.0 98.0     0.0   4.0   151.0 128.0     82.0   4.0     164.0   37.0   279.0 61 86 25   5 98     0   4   151 128     82 4   164 37   279
698141 698141 MN Olmsted 55 school 2731800 535 Independent Districts and Schools ROCHESTER PUBLIC SCHOOL DISTRICT 273180001020 335 KELLOGG MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   pk_12_total 555.0 101.0 74.0   3.0 97.0     0.0   40.0   439.0 431.0     101.0   16.0     290.0   123.0   870.0 555 101 74   3 97     0   40   439 431     101 16   290 123   870
698188 698188 MN Ramsey 62 school 2732430 623 Independent Districts and Schools ROSEVILLE PUBLIC SCHOOL DISTRICT 273243002667 70 ROSEVILLE AREA MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_8 179.0 86.0 76.0   4.0 97.0     0.0   25.0   250.0 217.0         9.0         68.0   467.0 179 86 76   4 97     0   25   250 217       9     68   467
698198 698198 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   grade_6 11.0 79.0 41.0   5.0 97.0     0.0   6.0   138.0 101.0     108.0   8.0     201.0   37.0   239.0 11 79 41   5 97     0   6   138 101     108 8   201 37   239
698205 698205 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 2017   grade_8 10.0 35.0 18.0   0.0 97.0     0.0   1.0   88.0 73.0     60.0   3.0     122.0   32.0   161.0 10 35 18   0 97     0   1   88 73     60 3   122 32   161
699072 699072 MN Nobles 53 school 2744160 518 Independent Districts and Schools WORTHINGTON PUBLIC SCHOOL DISTRICT 274416001841 8 WORTHINGTON SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 09 12 2017   pk_12_total 307.0 50.0 407.0   0.0 97.0     0.0   9.0   450.0 420.0     172.0   3.0     519.0   120.0   870.0 307 50 407   0 97     0   9   450 420     172 3   519 120   870
693988 693988 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384003000 466 CROSSROADS SCIENCE PROGRAM Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   pk_12_total 32.0 146.0 25.0   0.0 96.0     0.0   32.0   167.0 164.0     101.0   6.0     266.0   36.0   331.0 32 146 25   0 96     0   32   167 164     101 6   266 36   331
694116 694116 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384004684 534 Nokomis Montessori South Campus Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   pk_12_total 50.0 41.0 30.0   1.0 96.0     0.0   20.0   121.0 117.0     90.0   3.0     136.0   34.0   238.0 50 41 30   1 96     0   20   121 117     90 3   136 34   238
694120 694120 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384001619 541 PHALEN LAKE HMONG STUDIES MAGNET Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_3 2.0 10.0 7.0   0.0 96.0     0.0   3.0   53.0 65.0     95.0   0.0     101.0   4.0   118.0 2 10 7   0 96     0   3   53 65     95 0   101 4   118
695147 695147 MN Washington 82 school 2733810 833 Independent Districts and Schools SOUTH WASHINGTON COUNTY SCHOOL DIST 273381002306 47 MIDDLETON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   pk_12_total 490.0 54.0 40.0   0.0 96.0     1.0   54.0   411.0 324.0     62.0   2.0     87.0   97.0   735.0 490 54 40   0 96     1   54   411 324     62 2   87 97   735
697224 697224 MN Hennepin 27 school 2700295 4171 Charter Schools NOBLE ACADEMY 270029503727 10 NOBLE ACADEMY Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2017   grade_1 0.0 14.0 1.0   0.0 96.0     0.0   0.0   63.0 48.0     77.0   0.0     73.0   4.0   111.0 0 14 1   0 96     0   0   63 48     77 0   73 4   111
698654 698654 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   grade_10 420.0 130.0 51.0   5.0 96.0     0.0   23.0   385.0 340.0     27.0   7.0     261.0   80.0   725.0 420 130 51   5 96     0   23   385 340     27 7   261 80   725
698200 698200 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   grade_8 23.0 67.0 37.0   5.0 95.0     0.0   9.0   140.0 96.0     109.0   9.0     190.0   34.0   236.0 23 67 37   5 95     0   9   140 96     109 9   190 34   236
699522 699522 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   grade_10 24.0 154.0 31.0   3.0 95.0     0.0   0.0   163.0 144.0     44.0   19.0     260.0   69.0   307.0 24 154 31   3 95     0   0   163 144     44 19   260 69   307
696759 696759 MN Ramsey 62 school 2700142 4029 Charter Schools ST. PAUL CITY SCHOOL 270014202721 10 ST. PAUL CITY PRIMARY SCHOOL Elementary School (Grades PK-6) Regular School Yes Elementary PK 05 2017   pk_12_total 4.0 68.0 162.0   3.0 94.0     0.0   3.0   158.0 176.0     203.0   2.0         16.0   334.0 4 68 162   3 94     0   3   158 176     203 2     16   334
697225 697225 MN Hennepin 27 school 2700295 4171 Charter Schools NOBLE ACADEMY 270029503727 10 NOBLE ACADEMY Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2017   grade_2 0.0 11.0 1.0   0.0 94.0     0.0   0.0   58.0 48.0     72.0   0.0     63.0   8.0   106.0 0 11 1   0 94     0   0   58 48     72 0   63 8   106
697226 697226 MN Hennepin 27 school 2700295 4171 Charter Schools NOBLE ACADEMY 270029503727 10 NOBLE ACADEMY Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2017   grade_3 0.0 12.0 0.0   0.0 94.0     0.0   0.0   47.0 59.0     78.0   0.0     70.0   3.0   106.0 0 12 0   0 94     0   0   47 59     78 0   70 3   106
699230 699230 MN Scott 70 school 2733000 720 Independent Districts and Schools SHAKOPEE PUBLIC SCHOOL DISTRICT 273300001440 83 SHAKOPEE SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 10 12 2017   grade_11 373.0 50.0 73.0   5.0 94.0     0.0   22.0   313.0 304.0     21.0   *         86.0   617.0 373 50 73   5 94     0   22   313 304     21       86   617
699523 699523 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   grade_11 23.0 123.0 21.0   5.0 94.0     0.0   0.0   141.0 125.0     25.0   16.0     218.0   48.0   266.0 23 123 21   5 94     0   0   141 125     25 16   218 48   266
693959 693959 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384002671 460 FOUR SEASONS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   pk_12_total 84.0 175.0 67.0   2.0 93.0     0.0   40.0   228.0 233.0     181.0   15.0     389.0   73.0   461.0 84 175 67   2 93     0   40   228 233     181 15   389 73   461
697227 697227 MN Hennepin 27 school 2700295 4171 Charter Schools NOBLE ACADEMY 270029503727 10 NOBLE ACADEMY Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2017   grade_4 0.0 19.0 0.0   0.0 93.0     0.0   0.0   56.0 56.0     51.0   0.0     75.0   4.0   112.0 0 19 0   0 93     0   0   56 56     51 0   75 4   112
697728 697728 MN Anoka 2 school 2733330 16 Independent Districts and Schools SPRING LAKE PARK PUBLIC SCHOOLS 273333001466 92 WESTWOOD MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   pk_12_total 717.0 131.0 188.0   5.0 93.0     2.0   76.0   604.0 608.0     81.0   6.0     505.0   131.0   1212.0 717 131 188   5 93     2   76   604 608     81 6   505 131   1212
698011 698011 MN Hennepin 27 school 2742160 284 Independent Districts and Schools WAYZATA PUBLIC SCHOOL DISTRICT 274216001764 51 WAYZATA WEST MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   pk_12_total 612.0 23.0 36.0   0.0 93.0     0.0   27.0   393.0 398.0     3.0   *     80.0   69.0   791.0 612 23 36   0 93     0   27   393 398     3     80 69   791
689674 689674 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   grade_11 5.0 52.0 41.0   1.0 92.0     0.0   4.0   98.0 97.0     113.0   1.0     173.0   30.0   195.0 5 52 41   1 92     0   4   98 97     113 1   173 30   195
693862 693862 MN Ramsey 62 school 2742360 624 Independent Districts and Schools WHITE BEAR LAKE SCHOOL DISTRICT 274236001795 834 VADNAIS HEIGHTS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   pk_12_total 235.0 18.0 22.0   2.0 92.0     0.0   32.0   193.0 208.0     35.0   2.0     154.0   55.0   401.0 235 18 22   2 92     0   32   193 208     35 2   154 55   401
698902 698902 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_9 469.0 97.0 41.0   5.0 92.0     2.0   35.0   376.0 365.0     30.0   2.0     135.0   77.0   741.0 469 97 41   5 92     2   35   376 365     30 2   135 77   741
699146 699146 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   grade_12 296.0 72.0 55.0   2.0 92.0     0.0   25.0   262.0 280.0         *         *   542.0 296 72 55   2 92     0   25   262 280                 542
699521 699521 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   grade_9 17.0 169.0 29.0   5.0 92.0     0.0   3.0   155.0 160.0     65.0   26.0     266.0   73.0   315.0 17 169 29   5 92     0   3   155 160     65 26   266 73   315
697250 697250 MN Ramsey 62 school 2700304 4181 Charter Schools COMMUNITY SCHOOL OF EXCELLENCE 270030403728 10 COMMUNITY SCHOOL OF EXCELLENCE Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2017   pk_12_total 0.0 0.0 2.0   0.0 913.0     0.0   5.0   452.0 468.0     612.0   0.0     696.0   75.0   920.0 0 0 2   0 913     0   5   452 468     612 0   696 75   920
697694 697694 MN Hennepin 27 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000108 6 JACKSON MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_8 384.0 111.0 45.0   5.0 91.0     0.0   35.0   332.0 339.0     48.0   6.0     230.0   86.0   671.0 384 111 45   5 91     0   35   332 339     48 6   230 86   671
697974 697974 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   grade_8 56.0 94.0 34.0   0.0 91.0     0.0   27.0   158.0 144.0     41.0   *     201.0   36.0   302.0 56 94 34   0 91     0   27   158 144     41     201 36   302
698017 698017 MN Hennepin 27 school 2742160 284 Independent Districts and Schools WAYZATA PUBLIC SCHOOL DISTRICT 274216002654 53 WAYZATA CENTRAL MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_7 270.0 33.0 15.0   0.0 91.0     0.0   17.0   218.0 208.0     0.0   1.0     53.0   25.0   426.0 270 33 15   0 91     0   17   218 208     0 1   53 25   426
699135 699135 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   grade_11 241.0 74.0 61.0   0.0 90.0     0.0   16.0   243.0 239.0     34.0   4.0     235.0   71.0   482.0 241 74 61   0 90     0   16   243 239     34 4   235 71   482
689143 689143 MN Chisago 13 school 2732550 139 Independent Districts and Schools RUSH CITY PUBLIC SCHOOL DISTRICT 273255001406 20 RUSH CITY SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   pk_12_total 377.0 1.0 8.0   1.0 9.0     0.0   1.0   202.0 195.0     0.0   3.0     135.0   37.0   397.0 377 1 8   1 9     0   1   202 195     0 3   135 37   397
689582 689582 MN Otter Tail 56 school 2728170 548 Independent Districts and Schools PELICAN RAPIDS PUBLIC SCHOOL DIST. 272817001243 20 PELICAN RAPIDS SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   pk_12_total 203.0 41.0 80.0   4.0 9.0     0.0   13.0   164.0 186.0     43.0   9.0     169.0   50.0   350.0 203 41 80   4 9     0   13   164 186     43 9   169 50   350
689639 689639 MN Polk 60 school 2709720 593 Independent Districts and Schools CROOKSTON PUBLIC SCHOOL DISTRICT 270972000412 90 CROOKSTON SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   pk_12_total 386.0 10.0 85.0   5.0 9.0     0.0   14.0   255.0 254.0     22.0   15.0     175.0   86.0   509.0 386 10 85   5 9     0   14   255 254     22 15   175 86   509
689677 689677 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384004443 250 OPEN WORLD LEARNING SECONDARY Secondary School (Grades 7-12) Regular School No Other 06 12 2017   grade_6 40.0 7.0 12.0   1.0 9.0     0.0   1.0   42.0 28.0     5.0   0.0     21.0   8.0   70.0 40 7 12   1 9     0   1   42 28     5 0   21 8   70
690295 690295 MN Lyon 42 school 2700326 2904 Independent Districts and Schools TRACY AREA PUBLIC SCHOOL DISTRICT 270032604389 1 TRACY SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   grade_8 34.0 0.0 2.0   1.0 9.0     0.0   0.0   25.0 21.0     2.0   0.0     18.0   5.0   46.0 34 0 2   1 9     0   0   25 21     2 0   18 5   46
690297 690297 MN Lyon 42 school 2700326 2904 Independent Districts and Schools TRACY AREA PUBLIC SCHOOL DISTRICT 270032604389 1 TRACY SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   grade_10 59.0 0.0 3.0   0.0 9.0     0.0   0.0   36.0 35.0     5.0   0.0     30.0   3.0   71.0 59 0 3   0 9     0   0   36 35     5 0   30 3   71
690299 690299 MN Lyon 42 school 2700326 2904 Independent Districts and Schools TRACY AREA PUBLIC SCHOOL DISTRICT 270032604389 1 TRACY SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   grade_12 50.0 0.0 1.0   0.0 9.0     0.0   0.0   20.0 40.0     2.0   0.0     20.0   7.0   60.0 50 0 1   0 9     0   0   20 40     2 0   20 7   60
690318 690318 MN Dakota 19 school 2733270 6 Special Districts and Schools SOUTH ST. PAUL PUBLIC SCHOOL DIST. 273327001456 120 SOUTH ST. PAUL SECONDARY Secondary School (Grades 7-12) Regular School No Other 06 12 2017   grade_8 160.0 19.0 57.0   2.0 9.0     0.0   13.0   125.0 135.0     4.0   0.0     117.0   45.0   260.0 160 19 57   2 9     0   13   125 135     4 0   117 45   260
690424 690424 MN Ramsey 62 school 2700337 4098 Charter Schools Nova Classical Academy 270033704356 20 NOVA CLASSICAL ACADEMY UPPER SCHOOL Secondary School (Grades 7-12) Regular School Yes Other 06 12 2017   grade_7 50.0 9.0 5.0   1.0 9.0     0.0   4.0   45.0 33.0     5.0   0.0     11.0   4.0   78.0 50 9 5   1 9     0   4   45 33     5 0   11 4   78
690469 690469 MN Ramsey 62 school 2700246 4132 Charter Schools Twin Cities Academy 270024603307 10 TWIN CITIES ACADEMY Secondary School (Grades 7-12) Regular School Yes Other 06 12 2017   grade_8 45.0 15.0 13.0   1.0 9.0     0.0   14.0   44.0 53.0     4.0   0.0     39.0   8.0   97.0 45 15 13   1 9     0   14   44 53     4 0   39 8   97
690489 690489 MN Sherburne 71 school 2700276 4160 Charter Schools SPECTRUM HIGH SCHOOL 270027603615 10 SPECTRUM HIGH SCHOOL Secondary School (Grades 7-12) Regular School Yes High 07 12 2017   pk_12_total 495.0 7.0 9.0   2.0 9.0     0.0   18.0   253.0 287.0     6.0   0.0     75.0   69.0   540.0 495 7 9   2 9     0   18   253 287     6 0   75 69   540
690613 690613 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000110 406 JEFFERSON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_3 78.0 7.0 5.0   1.0 9.0     0.0   5.0   57.0 48.0     13.0   3.0     51.0   17.0   105.0 78 7 5   1 9     0   5   57 48     13 3   51 17   105
690618 690618 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000111 407 JOHNSVILLE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_1 117.0 3.0 2.0   1.0 9.0     0.0   5.0   63.0 74.0     4.0   1.0     16.0   8.0   137.0 117 3 2   1 9     0   5   63 74     4 1   16 8   137
690634 690634 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   grade_3 51.0 9.0 3.0   0.0 9.0     1.0   1.0   37.0 37.0     13.0   *     32.0   12.0   74.0 51 9 3   0 9     1   1   37 37     13     32 12   74
690678 690678 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000126 418 UNIVERSITY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_5 56.0 25.0 7.0   1.0 9.0     0.0   9.0   50.0 57.0     6.0   0.0     59.0   15.0   107.0 56 25 7   1 9     0   9   50 57     6 0   59 15   107
690687 690687 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 2017   pre_kindergarten 10.0 10.0 2.0   0.0 9.0     0.0   1.0   15.0 17.0     0.0   0.0     14.0   0.0   32.0 10 10 2   0 9     0   1   15 17     0 0   14 0   32
690724 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
690728 690728 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_5 197.0 7.0 11.0   0.0 9.0     1.0   4.0   121.0 108.0     4.0   1.0     38.0   29.0   229.0 197 7 11   0 9     1   4   121 108     4 1   38 29   229
690738 690738 MN Hennepin 27 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318004406 430 CHAMPLIN/BROOKLYN PK ACD MATH ENSCI Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_1 87.0 24.0 7.0   1.0 9.0     1.0   12.0   73.0 68.0     12.0   0.0     52.0   21.0   141.0 87 24 7   1 9     1   12   73 68     12 0   52 21   141
690739 690739 MN Hennepin 27 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318004406 430 CHAMPLIN/BROOKLYN PK ACD MATH ENSCI Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_2 92.0 21.0 5.0   2.0 9.0     0.0   11.0   67.0 73.0     17.0   0.0     46.0   18.0   140.0 92 21 5   2 9     0   11   67 73     17 0   46 18   140
690828 690828 MN Anoka 2 school 2733540 15 Independent Districts and Schools ST. FRANCIS PUBLIC SCHOOL DISTRICT 273354000233 784 CEDAR CREEK COMMUNITY SCHOOL Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   kindergarten 99.0 0.0 1.0   3.0 9.0     0.0   8.0   59.0 61.0         *     34.0   12.0   120.0 99 0 1   3 9     0   8   59 61           34 12   120
690831 690831 MN Anoka 2 school 2733540 15 Independent Districts and Schools ST. FRANCIS PUBLIC SCHOOL DISTRICT 273354000233 784 CEDAR CREEK COMMUNITY SCHOOL Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_3 106.0 0.0 4.0   1.0 9.0     0.0   7.0   64.0 63.0     8.0   0.0     30.0   13.0   127.0 106 0 4   1 9     0   7   64 63     8 0   30 13   127
691221 691221 MN Carver 10 school 2741460 110 Independent Districts and Schools WACONIA PUBLIC SCHOOL DISTRICT 274146000363 110 SOUTHVIEW ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   pk_12_total 590.0 11.0 17.0   0.0 9.0     0.0   19.0   325.0 321.0     10.0   0.0     74.0   76.0   646.0 590 11 17   0 9     0   19   325 321     10 0   74 76   646
691286 691286 MN Carver 10 school 2708190 112 Independent Districts and Schools EASTERN CARVER COUNTY PUBLIC SCHOOL 270819003067 511 CLOVER RIDGE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 01 05 2017   grade_5 99.0 5.0 3.0   0.0 9.0     0.0   10.0   64.0 62.0     3.0   0.0     16.0   20.0   126.0 99 5 3   0 9     0   10   64 62     3 0   16 20   126
691295 691295 MN Carver 10 school 2708190 112 Independent Districts and Schools EASTERN CARVER COUNTY PUBLIC SCHOOL 270819002294 513 JONATHAN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   kindergarten 98.0 14.0 2.0   0.0 9.0     0.0   9.0   67.0 65.0     8.0   0.0     23.0   17.0   132.0 98 14 2   0 9     0   9   67 65     8 0   23 17   132
691505 691505 MN Scott 70 school 2707290 191 Independent Districts and Schools BURNSVILLE PUBLIC SCHOOL DISTRICT 270729000300 484 M.W. SAVAGE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   kindergarten 22.0 15.0 5.0   0.0 9.0     0.0   5.0   28.0 28.0     8.0   0.0     36.0   6.0   56.0 22 15 5   0 9     0   5   28 28     8 0   36 6   56
691560 691560 MN Scott 70 school 2707290 191 Independent Districts and Schools BURNSVILLE PUBLIC SCHOOL DISTRICT 270729002641 491 HARRIET BISHOP ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   kindergarten 57.0 6.0 6.0   1.0 9.0     0.0   7.0   41.0 45.0     11.0   0.0         5.0   86.0 57 6 6   1 9     0   7   41 45     11 0     5   86
691579 691579 MN Dakota 19 school 2711820 192 Independent Districts and Schools FARMINGTON PUBLIC SCHOOL DISTRICT 271182002642 40 NORTH TRAIL ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_3 68.0 3.0 7.0   0.0 9.0     0.0   5.0   49.0 43.0     13.0   0.0     19.0   *   92.0 68 3 7   0 9     0   5   49 43     13 0   19     92
691580 691580 MN Dakota 19 school 2711820 192 Independent Districts and Schools FARMINGTON PUBLIC SCHOOL DISTRICT 271182002642 40 NORTH TRAIL ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_4 91.0 8.0 7.0   0.0 9.0     0.0   11.0   62.0 64.0     7.0   0.0     22.0   22.0   126.0 91 8 7   0 9     0   11   62 64     7 0   22 22   126
691586 691586 MN Dakota 19 school 2711820 192 Independent Districts and Schools FARMINGTON PUBLIC SCHOOL DISTRICT 271182003183 80 MEADOWVIEW ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_2 103.0 2.0 0.0   0.0 9.0     0.0   2.0   54.0 62.0     5.0   0.0     15.0   14.0   116.0 103 2 0   0 9     0   2   54 62     5 0   15 14   116
691589 691589 MN Dakota 19 school 2711820 192 Independent Districts and Schools FARMINGTON PUBLIC SCHOOL DISTRICT 271182003183 80 MEADOWVIEW ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_5 107.0 1.0 7.0   0.0 9.0     0.0   6.0   66.0 64.0         0.0     17.0   15.0   130.0 107 1 7   0 9     0   6   66 64       0   17 15   130
691608 691608 MN Dakota 19 school 2711820 192 Independent Districts and Schools FARMINGTON PUBLIC SCHOOL DISTRICT 271182002205 621 AKIN ROAD ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_1 76.0 1.0 7.0   0.0 9.0     0.0   6.0   49.0 50.0     9.0   1.0     19.0   12.0   99.0 76 1 7   0 9     0   6   49 50     9 1   19 12   99
691665 691665 MN Dakota 19 school 2717780 194 Independent Districts and Schools LAKEVILLE PUBLIC SCHOOL DISTRICT 271778002985 599 OAK HILLS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_2 64.0 1.0 24.0   0.0 9.0     0.0   2.0   55.0 45.0     15.0   *     22.0   9.0   100.0 64 1 24   0 9     0   2   55 45     15     22 9   100
691667 691667 MN Dakota 19 school 2717780 194 Independent Districts and Schools LAKEVILLE PUBLIC SCHOOL DISTRICT 271778002985 599 OAK HILLS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_4 86.0 2.0 19.0   1.0 9.0     0.0   5.0   66.0 56.0     19.0   0.0     28.0   16.0   122.0 86 2 19   1 9     0   5   66 56     19 0   28 16   122
691690 691690 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239001377 706 NORTHVIEW ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_4 52.0 8.0 6.0   0.0 9.0     0.0   6.0   40.0 41.0     5.0   *     18.0   20.0   81.0 52 8 6   0 9     0   6   40 41     5     18 20   81
691718 691718 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239001375 710 Diamond Path Elementary School of International Studies Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_4 95.0 14.0 6.0   0.0 9.0     0.0   15.0   58.0 81.0     6.0   1.0     34.0   7.0   139.0 95 14 6   0 9     0   15   58 81     6 1   34 7   139
691723 691723 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   grade_2 100.0 18.0 34.0   1.0 9.0     0.0   22.0   101.0 83.0     37.0   1.0     66.0   15.0   184.0 100 18 34   1 9     0   22   101 83     37 1   66 15   184
691726 691726 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   grade_5 90.0 21.0 34.0   1.0 9.0     0.0   21.0   89.0 87.0     21.0   1.0     62.0   17.0   176.0 90 21 34   1 9     0   21   89 87     21 1   62 17   176
691746 691746 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 2017   grade_2 53.0 23.0 20.0   1.0 9.0     0.0   17.0   59.0 64.0     33.0   0.0     60.0   11.0   123.0 53 23 20   1 9     0   17   59 64     33 0   60 11   123
691758 691758 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239000511 716 DEERWOOD ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   kindergarten 62.0 9.0 9.0   0.0 9.0     0.0   12.0   43.0 58.0     10.0   0.0     18.0   14.0   101.0 62 9 9   0 9     0   12   43 58     10 0   18 14   101
691780 691780 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239002283 719 SHANNON PARK ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_1 108.0 1.0 1.0   0.0 9.0     0.0   8.0   65.0 62.0     6.0   0.0     10.0   9.0   127.0 108 1 1   0 9     0   8   65 62     6 0   10 9   127
691833 691833 MN Dakota 19 school 2742270 197 Independent Districts and Schools WEST ST. PAUL-MENDOTA HTS.-EAGAN 274227001778 820 PILOT KNOB STEM MAGNET SCHOOL Elementary School (Grades PK-6) Regular School No Elementary KG 04 2017   grade_2 31.0 23.0 3.0   1.0 9.0     0.0   9.0   36.0 40.0     14.0   0.0     29.0   5.0   76.0 31 23 3   1 9     0   9   36 40     14 0   29 5   76
691834 691834 MN Dakota 19 school 2742270 197 Independent Districts and Schools WEST ST. PAUL-MENDOTA HTS.-EAGAN 274227001778 820 PILOT KNOB STEM MAGNET SCHOOL Elementary School (Grades PK-6) Regular School No Elementary KG 04 2017   grade_3 29.0 16.0 10.0   1.0 9.0     0.0   10.0   43.0 32.0     11.0   *     32.0   8.0   75.0 29 16 10   1 9     0   10   43 32     11     32 8   75
691835 691835 MN Dakota 19 school 2742270 197 Independent Districts and Schools WEST ST. PAUL-MENDOTA HTS.-EAGAN 274227001778 820 PILOT KNOB STEM MAGNET SCHOOL Elementary School (Grades PK-6) Regular School No Elementary KG 04 2017   grade_4 38.0 19.0 7.0   1.0 9.0     0.0   10.0   48.0 36.0     4.0   0.0     33.0   15.0   84.0 38 19 7   1 9     0   10   48 36     4 0   33 15   84
691850 691850 MN Dakota 19 school 2715030 199 Independent Districts and Schools INVER GROVE HEIGHTS SCHOOLS 271503000547 577 PINE BEND ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_1 47.0 7.0 22.0   0.0 9.0     0.0   6.0   51.0 40.0     15.0   0.0     46.0   9.0   91.0 47 7 22   0 9     0   6   51 40     15 0   46 9   91
692098 692098 MN Hennepin 27 school 2714260 270 Independent Districts and Schools HOPKINS PUBLIC SCHOOL DISTRICT 271426001887 567 L.H. TANGLEN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   kindergarten 36.0 12.0 5.0   0.0 9.0     0.0   7.0   38.0 31.0     10.0   0.0     22.0   8.0   69.0 36 12 5   0 9     0   7   38 31     10 0   22 8   69
692101 692101 MN Hennepin 27 school 2714260 270 Independent Districts and Schools HOPKINS PUBLIC SCHOOL DISTRICT 271426001887 567 L.H. TANGLEN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_3 34.0 21.0 4.0   1.0 9.0     0.0   4.0   41.0 32.0     10.0   1.0     32.0   12.0   73.0 34 21 4   1 9     0   4   41 32     10 1   32 12   73
692103 692103 MN Hennepin 27 school 2714260 270 Independent Districts and Schools HOPKINS PUBLIC SCHOOL DISTRICT 271426001887 567 L.H. TANGLEN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_5 27.0 24.0 12.0   1.0 9.0     0.0   5.0   36.0 42.0     13.0   1.0     39.0   7.0   78.0 27 24 12   1 9     0   5   36 42     13 1   39 7   78
692159 692159 MN Hennepin 27 school 2705790 271 Independent Districts and Schools BLOOMINGTON PUBLIC SCHOOL DISTRICT 270579000227 447 OLSON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_5 61.0 14.0 8.0   0.0 9.0     0.0   8.0   40.0 60.0     4.0   0.0     35.0   10.0   100.0 61 14 8   0 9     0   8   40 60     4 0   35 10   100
692165 692165 MN Hennepin 27 school 2705790 271 Independent Districts and Schools BLOOMINGTON PUBLIC SCHOOL DISTRICT 270579000223 448 OAK GROVE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_3 26.0 10.0 15.0   0.0 9.0     0.0   8.0   42.0 26.0     18.0   0.0         6.0   68.0 26 10 15   0 9     0   8   42 26     18 0     6   68
692215 692215 MN Hennepin 27 school 2714220 272 Independent Districts and Schools EDEN PRAIRIE PUBLIC SCHOOL DISTRICT 271422000737 881 PRAIRIE VIEW ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 06 2017   grade_1 63.0 13.0 7.0   0.0 9.0     0.0   6.0   52.0 46.0     13.0   0.0     23.0   5.0   98.0 63 13 7   0 9     0   6   52 46     13 0   23 5   98
692270 692270 MN Hennepin 27 school 2711250 273 Independent Districts and Schools EDINA PUBLIC SCHOOL DISTRICT 271125000507 528 COUNTRYSIDE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_2 73.0 4.0 4.0   0.0 9.0     0.0   3.0   58.0 35.0     3.0   0.0     6.0   5.0   93.0 73 4 4   0 9     0   3   58 35     3 0   6 5   93
692279 692279 MN Hennepin 27 school 2711250 273 Independent Districts and Schools EDINA PUBLIC SCHOOL DISTRICT 271125002269 529 HIGHLANDS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_4 66.0 8.0 1.0   0.0 9.0     0.0   7.0   51.0 40.0     1.0   0.0     7.0   7.0   91.0 66 8 1   0 9     0   7   51 40     1 0   7 7   91
692315 692315 MN Hennepin 27 school 2711670 276 Independent Districts and Schools MINNETONKA PUBLIC SCHOOL DISTRICT 271167000543 603 EXCELSIOR ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_5 120.0 3.0 5.0   1.0 9.0     0.0   8.0   79.0 67.0     0.0   0.0     7.0   18.0   146.0 120 3 5   1 9     0   8   79 67     0 0   7 18   146
692353 692353 MN Hennepin 27 school 2725080 278 Independent Districts and Schools ORONO PUBLIC SCHOOL DISTRICT 272508001200 661 SCHUMANN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 02 2017   pk_12_total 498.0 7.0 22.0   1.0 9.0     0.0   18.0   315.0 240.0     21.0   5.0     49.0   45.0   555.0 498 7 22   1 9     0   18   315 240     21 5   49 45   555
692389 692389 MN Hennepin 27 school 2725200 279 Independent Districts and Schools OSSEO PUBLIC SCHOOL DISTRICT 272520001207 671 BIRCH GROVE SCHOOL FOR THE ARTS Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   kindergarten 16.0 25.0 6.0   0.0 9.0     0.0   10.0   35.0 31.0     10.0   0.0     42.0   5.0   66.0 16 25 6   0 9     0   10   35 31     10 0   42 5   66
692455 692455 MN Hennepin 27 school 2725200 279 Independent Districts and Schools OSSEO PUBLIC SCHOOL DISTRICT 272520001224 681 ZANEWOOD COMMUNITY SCHOOL Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_5 1.0 27.0 9.0   0.0 9.0     0.0   2.0   24.0 24.0     11.0   3.0     42.0   9.0   48.0 1 27 9   0 9     0   2   24 24     11 3   42 9   48
692473 692473 MN Hennepin 27 school 2725200 279 Independent Districts and Schools OSSEO PUBLIC SCHOOL DISTRICT 272520001940 685 RICE LAKE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_2 61.0 10.0 5.0   0.0 9.0     0.0   8.0   41.0 52.0     9.0   0.0     27.0   11.0   93.0 61 10 5   0 9     0   8   41 52     9 0   27 11   93
692480 692480 MN Hennepin 27 school 2725200 279 Independent Districts and Schools OSSEO PUBLIC SCHOOL DISTRICT 272520002212 689 FERNBROOK ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_2 107.0 16.0 1.0   0.0 9.0     0.0   16.0   76.0 73.0     7.0   0.0     25.0   23.0   149.0 107 16 1   0 9     0   16   76 73     7 0   25 23   149
692494 692494 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   kindergarten 52.0 17.0 16.0   1.0 9.0     1.0   13.0   58.0 51.0         0.0     52.0   4.0   109.0 52 17 16   1 9     1   13   58 51       0   52 4   109
692496 692496 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   grade_2 43.0 20.0 26.0   2.0 9.0     0.0   12.0   62.0 50.0     37.0   3.0     67.0   18.0   112.0 43 20 26   2 9     0   12   62 50     37 3   67 18   112
692498 692498 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   grade_4 46.0 20.0 30.0   2.0 9.0     0.0   18.0   73.0 52.0     28.0   2.0     74.0   19.0   125.0 46 20 30   2 9     0   18   73 52     28 2   74 19   125

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