Data source: Big Local News · About: Big Local

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

View and edit SQL

year

  • 2017 · 13,657
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
696086 MN Mcleod 43 school 2700128 2859 Independent Districts and Schools GLENCOE-SILVER LAKE SCHOOL DISTRICT 270012801444 30 LAKESIDE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 03 06 2017   grade_4 96.0 0.0 28.0   0.0 0.0     0.0   1.0   63.0 62.0     9.0   1.0     40.0   22.0   125.0 96 0 28   0 0     0   1   63 62     9 1   40 22   125
696322 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124000970 123 HALE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 04 2017   kindergarten 96.0 5.0 6.0   0.0 2.0     0.0   19.0   72.0 56.0     1.0   0.0     10.0   4.0   128.0 96 5 6   0 2     0   19   72 56     1 0   10 4   128
696912 MN Winona 85 school 2700194 4083 Charter Schools RIDGEWAY COMMUNITY SCHOOL 270019403147 10 RIDGEWAY COMMUNITY SCHOOL Elementary School (Grades PK-6) Regular School Yes Elementary KG 05 2017   pk_12_total 96.0 0.0 0.0   0.0 0.0     1.0   3.0   54.0 46.0     0.0   0.0     32.0   11.0   100.0 96 0 0   0 0     1   3   54 46     0 0   32 11   100
698026 MN Houston 28 school 2717250 300 Independent Districts and Schools LA CRESCENT-HOKAH SCHOOL DISTRICT 271725004238 50 LA CRESCENT-HOKAH MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 05 08 2017   grade_7 96.0 3.0 1.0   1.0 2.0     0.0   0.0   51.0 52.0     0.0   0.0     21.0   10.0   103.0 96 3 1   1 2     0   0   51 52     0 0   21 10   103
698366 MN Wright 86 school 2732070 883 Independent Districts and Schools ROCKFORD PUBLIC SCHOOL DISTRICT 273207001941 3 ROCKFORD MIDDLE Middle School (Grades 5-8) Regular School No Middle 05 08 2017   grade_6 96.0 7.0 11.0   2.0 5.0     0.0   5.0   57.0 69.0     3.0   0.0     41.0   11.0   126.0 96 7 11   2 5     0   5   57 69     3 0   41 11   126
698976 MN Hubbard 29 school 2728080 309 Independent Districts and Schools PARK RAPIDS PUBLIC SCHOOL DISTRICT 272808001235 60 PARK RAPIDS SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 09 12 2017   grade_9 96.0 1.0 3.0   8.0 0.0     0.0   5.0   53.0 60.0     2.0   0.0     49.0   23.0   113.0 96 1 3   8 0     0   5   53 60     2 0   49 23   113
698977 MN Hubbard 29 school 2728080 309 Independent Districts and Schools PARK RAPIDS PUBLIC SCHOOL DISTRICT 272808001235 60 PARK RAPIDS SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 09 12 2017   grade_10 96.0 2.0 10.0   11.0 1.0     0.0   5.0   71.0 54.0         *         *   125.0 96 2 10   11 1     0   5   71 54                 125
699221 MN Scott 70 school 2715750 717 Independent Districts and Schools JORDAN PUBLIC SCHOOL DISTRICT 271575001625 127 JORDAN SECONDARY Senior High School (Grades 9-12) Regular School No High 09 12 2017   grade_11 96.0 1.0 9.0   1.0 1.0     0.0   2.0   65.0 45.0     0.0   1.0     25.0   12.0   110.0 96 1 9   1 1     0   2   65 45     0 1   25 12   110
699481 MN Jackson 32 school 2700231 2895 Independent Districts and Schools JACKSON COUNTY CENTRAL SCHOOL DIST. 270023100773 113 JACKSON COUNTY CENTRAL SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 09 12 2017   grade_9 96.0 1.0 2.0   0.0 1.0     0.0   2.0   63.0 39.0     1.0   0.0     31.0   19.0   102.0 96 1 2   0 1     0   2   63 39     1 0   31 19   102
702607 MN Mcleod 43 school 2700128 2859 Independent Districts and Schools GLENCOE-SILVER LAKE SCHOOL DISTRICT 270012801445 40 LINCOLN JUNIOR HIGH Junior High School (Grades 7-8 or 7-9) Regular School No Middle 07 08 2017   grade_7 96.0 1.0 31.0   0.0 0.0     0.0   1.0   59.0 70.0     5.0   0.0     54.0   11.0   129.0 96 1 31   0 0     0   1   59 70     5 0   54 11   129
698280 MN Hennepin 27 school 2711370 728 Independent Districts and Schools ELK RIVER PUBLIC SCHOOL DISTRICT 271137002844 340 ROGERS MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 06 08 2017   pk_12_total 959.0 28.0 42.0   2.0 24.0     0.0   45.0   552.0 548.0     32.0   3.0     152.0   145.0   1100.0 959 28 42   2 24     0   45   552 548     32 3   152 145   1100
698683 MN Anoka 2 school 2733330 16 Independent Districts and Schools SPRING LAKE PARK PUBLIC SCHOOLS 273333001464 45 SPRING LAKE PARK SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 09 12 2017   pk_12_total 953.0 200.0 189.0   8.0 148.0     1.0   68.0   775.0 792.0     102.0   11.0     653.0   159.0   1567.0 953 200 189   8 148     1   68   775 792     102 11   653 159   1567
689109 MN Carlton 9 school 2738880 99 Independent Districts and Schools ESKO PUBLIC SCHOOL DISTRICT 273888001681 1 LINCOLN SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   grade_7 95.0 0.0 4.0   0.0 2.0     0.0   6.0   51.0 56.0     0.0   0.0     9.0   14.0   107.0 95 0 4   0 2     0   6   51 56     0 0   9 14   107
689500 MN Morrison 49 school 2728320 484 Independent Districts and Schools PIERZ PUBLIC SCHOOL DISTRICT 272832001252 30 HEALY SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   grade_7 95.0 0.0 2.0   0.0 0.0     0.0   1.0   49.0 49.0     0.0   0.0     39.0   12.0   98.0 95 0 2   0 0     0   1   49 49     0 0   39 12   98
689772 MN Stearns 73 school 2714190 738 Independent Districts and Schools HOLDINGFORD PUBLIC SCHOOL DISTRICT 271419000733 2 HOLDINGFORD SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   grade_8 95.0 0.0 1.0   1.0 0.0     0.0   1.0   57.0 41.0     0.0   0.0     23.0   9.0   98.0 95 0 1   1 0     0   1   57 41     0 0   23 9   98
689775 MN Stearns 73 school 2714190 738 Independent Districts and Schools HOLDINGFORD PUBLIC SCHOOL DISTRICT 271419000733 2 HOLDINGFORD SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   grade_11 95.0 0.0 0.0   0.0 0.0     0.0   4.0   54.0 45.0     0.0   0.0     19.0   17.0   99.0 95 0 0   0 0     0   4   54 45     0 0   19 17   99
689868 MN Wabasha 79 school 2717520 813 Independent Districts and Schools LAKE CITY PUBLIC SCHOOL DISTRICT 271752000804 40 LINCOLN SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   grade_7 95.0 0.0 3.0   0.0 1.0     0.0   0.0   45.0 54.0     0.0   0.0     19.0   17.0   99.0 95 0 3   0 1     0   0   45 54     0 0   19 17   99
690670 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000123 417 SAND CREEK ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_4 95.0 12.0 8.0   0.0 10.0     0.0   8.0   69.0 64.0     11.0   2.0     42.0   21.0   133.0 95 12 8   0 10     0   8   69 64     11 2   42 21   133
690824 MN Anoka 2 school 2733540 15 Independent Districts and Schools ST. FRANCIS PUBLIC SCHOOL DISTRICT 273354000230 782 ST. FRANCIS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_3 95.0 2.0 3.0   0.0 2.0     0.0   10.0   55.0 57.0     1.0   0.0     33.0   20.0   112.0 95 2 3   0 2     0   10   55 57     1 0   33 20   112
690860 MN Anoka 2 school 2733330 16 Independent Districts and Schools SPRING LAKE PARK PUBLIC SCHOOLS 273333001462 775 Park Terrace Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 03 2017   grade_3 95.0 32.0 29.0   1.0 14.0     0.0   18.0   96.0 93.0     33.0   *     113.0   26.0   189.0 95 32 29   1 14     0   18   96 93     33     113 26   189
691658 MN Dakota 19 school 2717780 194 Independent Districts and Schools LAKEVILLE PUBLIC SCHOOL DISTRICT 271778002643 598 EASTVIEW ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_2 95.0 2.0 1.0   0.0 7.0     0.0   7.0   60.0 52.0     4.0   0.0     7.0   13.0   112.0 95 2 1   0 7     0   7   60 52     4 0   7 13   112
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
691938 MN Douglas 21 school 2703060 206 Independent Districts and Schools ALEXANDRIA PUBLIC SCHOOL DISTRICT 270306003516 170 EARLY EDUCATION CENTER Elementary School (Grades PK-6) Regular School No Elementary PK PK 2017   early_childhood_special_ed 95.0 1.0 4.0   0.0 0.0     0.0   4.0   62.0 42.0     0.0   3.0     47.0   *   104.0 95 1 4   0 0     0   4   62 42     0 3   47     104
691939 MN Douglas 21 school 2703060 206 Independent Districts and Schools ALEXANDRIA PUBLIC SCHOOL DISTRICT 270306003516 170 EARLY EDUCATION CENTER Elementary School (Grades PK-6) Regular School No Elementary PK PK 2017   pk_12_total 95.0 1.0 4.0   0.0 0.0     0.0   4.0   62.0 42.0     0.0   3.0     47.0   *   104.0 95 1 4   0 0     0   4   62 42     0 3   47     104
692239 MN Hennepin 27 school 2714220 272 Independent Districts and Schools EDEN PRAIRIE PUBLIC SCHOOL DISTRICT 271422003620 886 EAGLE HEIGHTS SPANISH IMMERSION Elementary School (Grades PK-6) Regular School No Elementary KG 06 2017   grade_1 95.0 1.0 19.0   0.0 3.0     0.0   5.0   61.0 62.0     3.0   0.0     6.0   1.0   123.0 95 1 19   0 3     0   5   61 62     3 0   6 1   123
692257 MN Hennepin 27 school 2711250 273 Independent Districts and Schools EDINA PUBLIC SCHOOL DISTRICT 271125000505 526 CONCORD ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_3 95.0 6.0 5.0   0.0 8.0     0.0   3.0   70.0 47.0     8.0   0.0     10.0   7.0   117.0 95 6 5   0 8     0   3   70 47     8 0   10 7   117
692258 MN Hennepin 27 school 2711250 273 Independent Districts and Schools EDINA PUBLIC SCHOOL DISTRICT 271125000505 526 CONCORD ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_4 95.0 9.0 4.0   0.0 8.0     0.0   9.0   62.0 63.0     3.0   0.0     11.0   17.0   125.0 95 9 4   0 8     0   9   62 63     3 0   11 17   125
692306 MN Hennepin 27 school 2711670 276 Independent Districts and Schools MINNETONKA PUBLIC SCHOOL DISTRICT 271167000542 602 DEEPHAVEN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_3 95.0 2.0 6.0   1.0 3.0     0.0   6.0   58.0 55.0     2.0   0.0     10.0   12.0   113.0 95 2 6   1 3     0   6   58 55     2 0   10 12   113
692655 MN Hennepin 27 school 2742160 284 Independent Districts and Schools WAYZATA PUBLIC SCHOOL DISTRICT 274216001760 806 GREENWOOD ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_2 95.0 3.0 6.0   0.0 31.0     0.0   2.0   74.0 63.0     6.0   0.0     7.0   8.0   137.0 95 3 6   0 31     0   2   74 63     6 0   7 8   137
692762 MN Hubbard 29 school 2728080 309 Independent Districts and Schools PARK RAPIDS PUBLIC SCHOOL DISTRICT 272808001233 30 PARK RAPIDS AREA CENTURY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2017   grade_1 95.0 0.0 7.0   1.0 1.0     0.0   6.0   63.0 47.0     2.0   0.0     64.0   22.0   110.0 95 0 7   1 1     0   6   63 47     2 0   64 22   110
693168 MN Morrison 49 school 2718240 482 Independent Districts and Schools LITTLE FALLS PUBLIC SCHOOL DISTRICT 271824000961 120 LINDBERGH ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_4 95.0 6.0 2.0   0.0 2.0     0.0   8.0   64.0 49.0     1.0   0.0     53.0   17.0   113.0 95 6 2   0 2     0   8   64 49     1 0   53 17   113
693169 MN Morrison 49 school 2718240 482 Independent Districts and Schools LITTLE FALLS PUBLIC SCHOOL DISTRICT 271824000961 120 LINDBERGH ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_5 95.0 2.0 6.0   0.0 0.0     0.0   5.0   45.0 63.0     0.0   1.0     41.0   19.0   108.0 95 2 6   0 0     0   5   45 63     0 1   41 19   108
693409 MN Olmsted 55 school 2731800 535 Independent Districts and Schools ROCHESTER PUBLIC SCHOOL DISTRICT 273180004287 129 GEORGE W. GIBBS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_3 95.0 16.0 4.0   1.0 22.0     0.0   6.0   70.0 74.0     14.0   1.0     33.0   12.0   144.0 95 16 4   1 22     0   6   70 74     14 1   33 12   144
694243 MN Rice 66 school 2723880 659 Independent Districts and Schools NORTHFIELD PUBLIC SCHOOL DISTRICT 272388001184 8 SIBLEY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_4 95.0 0.0 10.0   0.0 0.0     0.0   0.0   52.0 53.0     5.0   0.0     23.0   14.0   105.0 95 0 10   0 0     0   0   52 53     5 0   23 14   105
694265 MN Roseau 68 school 2732250 682 Independent Districts and Schools ROSEAU PUBLIC SCHOOL DISTRICT 273225001370 10 ROSEAU ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_1 95.0 2.0 2.0   1.0 0.0     0.0   2.0   51.0 51.0     0.0   0.0     27.0   13.0   102.0 95 2 2   1 0     0   2   51 51     0 0   27 13   102
694343 MN Saint Louis 69 school 2730090 704 Independent Districts and Schools PROCTOR PUBLIC SCHOOL DISTRICT 273009001557 4 BAY VIEW ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_5 95.0 2.0 1.0   1.0 0.0     0.0   8.0   61.0 46.0     0.0   1.0     50.0   19.0   107.0 95 2 1   1 0     0   8   61 46     0 1   50 19   107
694354 MN Saint Louis 69 school 2741040 706 Independent Districts and Schools VIRGINIA PUBLIC SCHOOL DISTRICT 274104001716 30 ROOSEVELT ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 03 06 2017   grade_5 95.0 2.0 2.0   6.0 1.0     0.0   14.0   57.0 63.0     0.0   0.0     56.0   13.0   120.0 95 2 2   6 1     0   14   57 63     0 0   56 13   120
694561 MN Scott 70 school 2723430 721 Independent Districts and Schools NEW PRAGUE AREA SCHOOLS 272343001144 651 FALCON RIDGE Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_1 95.0 0.0 2.0   2.0 1.0     0.0   4.0   60.0 44.0         0.0         9.0   104.0 95 0 2   2 1     0   4   60 44       0     9   104
694584 MN Sherburne 71 school 2705460 727 Independent Districts and Schools BIG LAKE PUBLIC SCHOOL DISTRICT 270546004180 40 LIBERTY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   kindergarten 95.0 1.0 6.0   0.0 1.0     0.0   10.0   47.0 66.0     3.0   0.0     28.0   13.0   113.0 95 1 6   0 1     0   10   47 66     3 0   28 13   113
694638 MN Sherburne 71 school 2711370 728 Independent Districts and Schools ELK RIVER PUBLIC SCHOOL DISTRICT 271137000030 700 MEADOWVALE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_4 95.0 1.0 1.0   0.0 0.0     0.0   3.0   53.0 47.0     0.0   0.0     10.0   19.0   100.0 95 1 1   0 0     0   3   53 47     0 0   10 19   100
695067 MN Washington 82 school 2733810 833 Independent Districts and Schools SOUTH WASHINGTON COUNTY SCHOOL DIST 273381002305 34 GREY CLOUD ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_5 95.0 8.0 6.0   0.0 9.0     0.0   8.0   72.0 54.0     7.0   1.0     18.0   17.0   126.0 95 8 6   0 9     0   8   72 54     7 1   18 17   126
696972 MN Cook 16 school 2700339 4100 Charter Schools GREAT EXPECTATIONS 270033904177 10 GREAT EXPECTATIONS Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2017   pk_12_total 95.0 0.0 0.0   3.0 0.0     0.0   0.0   43.0 55.0     0.0   0.0     42.0   25.0   98.0 95 0 0   3 0     0   0   43 55     0 0   42 25   98
697996 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   grade_6 95.0 148.0 106.0   2.0 32.0     0.0   27.0   222.0 188.0     53.0   9.0     309.0   51.0   410.0 95 148 106   2 32     0   27   222 188     53 9   309 51   410
698159 MN Polk 60 school 2711130 595 Independent Districts and Schools EAST GRAND FORKS PUBLIC SCHOOL DIST 271113000494 310 CENTRAL MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_6 95.0 13.0 13.0   0.0 0.0     0.0   12.0   69.0 64.0     9.0   0.0     50.0   18.0   133.0 95 13 13   0 0     0   12   69 64     9 0   50 18   133
698295 MN Stearns 73 school 2720550 740 Independent Districts and Schools MELROSE PUBLIC SCHOOL DISTRICT 272055003367 20 MELROSE MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_8 95.0 1.0 27.0   0.0 0.0     0.0   0.0   67.0 56.0     14.0   0.0     51.0   19.0   123.0 95 1 27   0 0     0   0   67 56     14 0   51 19   123
698883 MN Goodhue 25 school 2728950 255 Independent Districts and Schools PINE ISLAND PUBLIC SCHOOL DIST. 272895001258 20 PINE ISLAND SECONDARY Senior High School (Grades 9-12) Regular School No High 09 12 2017   grade_12 95.0 1.0 1.0   0.0 1.0     0.0   0.0   49.0 49.0     0.0   1.0     8.0   5.0   98.0 95 1 1   0 1     0   0   49 49     0 1   8 5   98
697707 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000122 195 Roosevelt Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2017   pk_12_total 948.0 86.0 53.0   4.0 89.0     1.0   54.0   617.0 618.0     28.0   11.0     286.0   136.0   1235.0 948 86 53   4 89     1   54   617 618     28 11   286 136   1235
698331 MN Washington 82 school 2733810 833 Independent Districts and Schools SOUTH WASHINGTON COUNTY SCHOOL DIST 273381002466 21 LAKE MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 06 08 2017   pk_12_total 948.0 72.0 69.0   3.0 157.0     0.0   55.0   629.0 675.0     41.0   2.0     109.0   152.0   1304.0 948 72 69   3 157     0   55   629 675     41 2   109 152   1304
698990 MN Itasca 31 school 2713170 318 Independent Districts and Schools GRAND RAPIDS PUBLIC SCHOOL DISTRICT 271317000935 360 GRAND RAPIDS SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 09 12 2017   pk_12_total 941.0 16.0 12.0   50.0 5.0     1.0   68.0   573.0 520.0     0.0   0.0     304.0   137.0   1093.0 941 16 12   50 5     1   68   573 520     0 0   304 137   1093
689110 MN Carlton 9 school 2738880 99 Independent Districts and Schools ESKO PUBLIC SCHOOL DISTRICT 273888001681 1 LINCOLN SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   grade_8 94.0 0.0 0.0   1.0 0.0     0.0   4.0   48.0 51.0     0.0   1.0     14.0   14.0   99.0 94 0 0   1 0     0   4   48 51     0 1   14 14   99
689870 MN Wabasha 79 school 2717520 813 Independent Districts and Schools LAKE CITY PUBLIC SCHOOL DISTRICT 271752000804 40 LINCOLN SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   grade_9 94.0 0.0 3.0   0.0 2.0     0.0   3.0   57.0 45.0     1.0   0.0     24.0   11.0   102.0 94 0 3   0 2     0   3   57 45     1 0   24 11   102
689871 MN Wabasha 79 school 2717520 813 Independent Districts and Schools LAKE CITY PUBLIC SCHOOL DISTRICT 271752000804 40 LINCOLN SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   grade_10 94.0 1.0 4.0   0.0 0.0     0.0   2.0   40.0 61.0     1.0   0.0     23.0   16.0   101.0 94 1 4   0 0     0   2   40 61     1 0   23 16   101
690485 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   grade_9 94.0 1.0 1.0   0.0 1.0     0.0   4.0   43.0 58.0     3.0   0.0     13.0   12.0   101.0 94 1 1   0 1     0   4   43 58     3 0   13 12   101
690617 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   kindergarten 94.0 3.0 4.0   0.0 6.0     0.0   7.0   51.0 63.0     3.0   0.0     22.0   8.0   114.0 94 3 4   0 6     0   7   51 63     3 0   22 8   114
690857 MN Anoka 2 school 2733330 16 Independent Districts and Schools SPRING LAKE PARK PUBLIC SCHOOLS 273333001462 775 Park Terrace Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 03 2017   kindergarten 94.0 17.0 29.0   0.0 13.0     1.0   25.0   92.0 87.0     35.0   2.0     103.0   24.0   179.0 94 17 29   0 13     1   25   92 87     35 2   103 24   179
691224 MN Carver 10 school 2741460 110 Independent Districts and Schools WACONIA PUBLIC SCHOOL DISTRICT 274146003065 120 BAYVIEW ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_2 94.0 0.0 2.0   2.0 1.0     0.0   1.0   51.0 49.0     2.0   1.0     18.0   12.0   100.0 94 0 2   2 1     0   1   51 49     2 1   18 12   100
691587 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_3 94.0 3.0 5.0   0.0 5.0     0.0   5.0   56.0 56.0         0.0     15.0   17.0   112.0 94 3 5   0 5     0   5   56 56       0   15 17   112
691611 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_4 94.0 6.0 13.0   1.0 7.0     0.0   8.0   66.0 63.0     8.0   1.0     29.0   13.0   129.0 94 6 13   1 7     0   8   66 63     8 1   29 13   129
691651 MN Dakota 19 school 2717780 194 Independent Districts and Schools LAKEVILLE PUBLIC SCHOOL DISTRICT 271778002436 597 LAKEVIEW ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_2 94.0 4.0 4.0   0.0 1.0     0.0   4.0   49.0 58.0     5.0   0.0     11.0   15.0   107.0 94 4 4   0 1     0   4   49 58     5 0   11 15   107
691683 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239001380 705 ROSEMOUNT ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_4 94.0 8.0 9.0   0.0 6.0     0.0   6.0   58.0 65.0     5.0   0.0     34.0   16.0   123.0 94 8 9   0 6     0   6   58 65     5 0   34 16   123
691684 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239001380 705 ROSEMOUNT ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_5 94.0 13.0 13.0   0.0 6.0     0.0   11.0   67.0 70.0     3.0   0.0     29.0   18.0   137.0 94 13 13   0 6     0   11   67 70     3 0   29 18   137
691779 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   kindergarten 94.0 3.0 4.0   1.0 10.0     0.0   8.0   67.0 53.0     3.0   0.0         15.0   120.0 94 3 4   1 10     0   8   67 53     3 0     15   120
692256 MN Hennepin 27 school 2711250 273 Independent Districts and Schools EDINA PUBLIC SCHOOL DISTRICT 271125000505 526 CONCORD ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_2 94.0 4.0 0.0   1.0 8.0     0.0   5.0   66.0 46.0     3.0   0.0     8.0   15.0   112.0 94 4 0   1 8     0   5   66 46     3 0   8 15   112
692301 MN Hennepin 27 school 2711670 276 Independent Districts and Schools MINNETONKA PUBLIC SCHOOL DISTRICT 271167000541 601 CLEAR SPRINGS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_5 94.0 3.0 12.0   0.0 4.0     0.0   7.0   62.0 58.0     4.0   0.0     13.0   17.0   120.0 94 3 12   0 4     0   7   62 58     4 0   13 17   120
692479 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_1 94.0 9.0 3.0   0.0 6.0     0.0   6.0   60.0 58.0         0.0     21.0   8.0   118.0 94 9 3   0 6     0   6   60 58       0   21 8   118
693166 MN Morrison 49 school 2718240 482 Independent Districts and Schools LITTLE FALLS PUBLIC SCHOOL DISTRICT 271824000961 120 LINDBERGH ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_2 94.0 1.0 6.0   0.0 4.0     0.0   3.0   57.0 51.0     5.0   2.0     54.0   17.0   108.0 94 1 6   0 4     0   3   57 51     5 2   54 17   108
694329 MN Saint Louis 69 school 2713980 701 Independent Districts and Schools HIBBING PUBLIC SCHOOL DISTRICT 271398001528 160 WASHINGTON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 02 2017   grade_1 94.0 1.0 2.0   0.0 0.0     0.0   10.0   64.0 43.0     0.0   0.0     57.0   18.0   107.0 94 1 2   0 0     0   10   64 43     0 0   57 18   107
694340 MN Saint Louis 69 school 2730090 704 Independent Districts and Schools PROCTOR PUBLIC SCHOOL DISTRICT 273009001557 4 BAY VIEW ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_2 94.0 0.0 2.0   1.0 0.0     0.0   6.0   47.0 56.0     0.0   0.0     44.0   *   103.0 94 0 2   1 0     0   6   47 56     0 0   44     103
694472 MN Scott 70 school 2730060 719 Independent Districts and Schools PRIOR LAKE-SAVAGE AREA SCHOOLS 273006001278 10 WESTWOOD EL. Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_5 94.0 10.0 4.0   1.0 9.0     0.0   3.0   64.0 57.0     2.0   0.0     16.0   9.0   121.0 94 10 4   1 9     0   3   64 57     2 0   16 9   121
694562 MN Scott 70 school 2723430 721 Independent Districts and Schools NEW PRAGUE AREA SCHOOLS 272343001144 651 FALCON RIDGE Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_2 94.0 0.0 0.0   3.0 2.0     0.0   2.0   54.0 47.0         0.0         12.0   101.0 94 0 0   3 2     0   2   54 47       0     12   101
694966 MN Waseca 81 school 2741880 829 Independent Districts and Schools WASECA PUBLIC SCHOOL DISTRICT 274188001747 20 HARTLEY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 03 2017   kindergarten 94.0 5.0 12.0   3.0 3.0     0.0   5.0   69.0 53.0     4.0   0.0     62.0   25.0   122.0 94 5 12   3 3     0   5   69 53     4 0   62 25   122
695064 MN Washington 82 school 2733810 833 Independent Districts and Schools SOUTH WASHINGTON COUNTY SCHOOL DIST 273381002305 34 GREY CLOUD ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_2 94.0 3.0 4.0   0.0 7.0     0.0   6.0   54.0 60.0     4.0   0.0     16.0   11.0   114.0 94 3 4   0 7     0   6   54 60     4 0   16 11   114
695141 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   kindergarten 94.0 8.0 4.0   0.0 15.0     0.0   12.0   72.0 61.0     18.0   0.0     14.0   12.0   133.0 94 8 4   0 15     0   12   72 61     18 0   14 12   133
695225 MN Washington 82 school 2738190 834 Independent Districts and Schools STILLWATER AREA PUBLIC SCHOOL DIST. 273819003004 804 RUTHERFORD ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 06 2017   grade_6 94.0 0.0 3.0   0.0 0.0     0.0   7.0   50.0 54.0     0.0   0.0     3.0   18.0   104.0 94 0 3   0 0     0   7   50 54     0 0   3 18   104
695292 MN Winona 85 school 2718090 857 Independent Districts and Schools LEWISTON-ALTURA PUBLIC SCHOOL DIST. 271809000834 20 LEWISTON-ALTURA INTERMEDIATE EL. Elementary School (Grades PK-6) Regular School No Middle 05 06 2017   pk_12_total 94.0 0.0 7.0   0.0 1.0     0.0   3.0   55.0 50.0     1.0   1.0     38.0   18.0   105.0 94 0 7   0 1     0   3   55 50     1 1   38 18   105
695406 MN Wright 86 school 2721390 882 Independent Districts and Schools MONTICELLO PUBLIC SCHOOL DISTRICT 272139001837 50 LITTLE MOUNTAIN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   kindergarten 94.0 1.0 9.0   0.0 1.0     0.0   4.0   53.0 56.0     8.0   0.0     22.0   11.0   109.0 94 1 9   0 1     0   4   53 56     8 0   22 11   109
695763 MN Rock 67 school 2718330 2184 Independent Districts and Schools LUVERNE PUBLIC SCHOOL DISTRICT 271833000851 2 LUVERNE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_4 94.0 3.0 4.0   0.0 2.0     0.0   5.0   62.0 46.0     7.0   0.0     36.0   16.0   108.0 94 3 4   0 2     0   5   62 46     7 0   36 16   108
696029 MN Wabasha 79 school 2745735 2805 Independent Districts and Schools ZUMBROTA-MAZEPPA SCHOOL DISTRICT 274573500200 1 ZUMBROTA-MAZEPPA ELEMENTARY SCHOOL Elementary School (Grades PK-6) Regular School No Elementary 03 06 2017   grade_3 94.0 1.0 1.0   1.0 0.0     0.0   0.0   49.0 48.0     0.0   1.0     19.0   8.0   97.0 94 1 1   1 0     0   0   49 48     0 1   19 8   97
696031 MN Wabasha 79 school 2745735 2805 Independent Districts and Schools ZUMBROTA-MAZEPPA SCHOOL DISTRICT 274573500200 1 ZUMBROTA-MAZEPPA ELEMENTARY SCHOOL Elementary School (Grades PK-6) Regular School No Elementary 03 06 2017   grade_5 94.0 1.0 5.0   1.0 2.0     0.0   2.0   55.0 50.0     2.0   2.0     29.0   13.0   105.0 94 1 5   1 2     0   2   55 50     2 2   29 13   105
696036 MN Goodhue 25 school 2745735 2805 Independent Districts and Schools ZUMBROTA-MAZEPPA SCHOOL DISTRICT 274573504730 30 Zumbrota-Mazeppa Primary School Elementary School (Grades PK-6) Regular School No Elementary PK 02 2017   grade_1 94.0 1.0 4.0   0.0 1.0     0.0   3.0   59.0 44.0     2.0   0.0     21.0   8.0   103.0 94 1 4   0 1     0   3   59 44     2 0   21 8   103
697990 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 2017   grade_8 94.0 49.0 105.0   1.0 16.0     1.0   14.0   142.0 138.0     58.0   5.0     170.0   38.0   280.0 94 49 105   1 16     1   14   142 138     58 5   170 38   280
698000 MN Hennepin 27 school 2733420 282 Independent Districts and Schools ST. ANTHONY-NEW BRIGHTON SCHOOLS 273342001949 50 ST. ANTHONY MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_6 94.0 16.0 16.0   1.0 8.0     0.0   9.0   80.0 64.0     12.0   1.0     38.0   12.0   144.0 94 16 16   1 8     0   9   80 64     12 1   38 12   144
698317 MN Wadena 80 school 2720580 821 Independent Districts and Schools MENAHGA PUBLIC SCHOOL DISTRICT 272058005019 20 Menahga Middle School Middle School (Grades 5-8) Regular School No Middle 05 08 2017   grade_7 94.0 0.0 0.0   1.0 1.0     0.0   4.0   45.0 55.0     0.0   1.0     54.0   19.0   100.0 94 0 0   1 1     0   4   45 55     0 1   54 19   100
698670 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   grade_10 94.0 83.0 22.0   7.0 19.0     0.0   18.0   127.0 116.0     24.0   2.0     147.0   33.0   243.0 94 83 22   7 19     0   18   127 116     24 2   147 33   243
698732 MN Carver 10 school 2723910 108 Independent Districts and Schools CENTRAL PUBLIC SCHOOL DISTRICT 272391001186 20 CENTRAL SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 09 12 2017   grade_11 94.0 2.0 1.0   0.0 2.0     1.0   1.0   49.0 52.0     1.0   0.0     14.0   12.0   101.0 94 2 1   0 2     1   1   49 52     1 0   14 12   101
699491 MN Wabasha 79 school 2700287 2899 Independent Districts and Schools PLAINVIEW-ELGIN-MILLVILLE 270028703631 40 PLAINVIEW-ELGIN-MILLVILLE HIGH Senior High School (Grades 9-12) Regular School No High 09 12 2017   grade_9 94.0 0.0 10.0   0.0 0.0     0.0   1.0   49.0 56.0     0.0   0.0     11.0   11.0   105.0 94 0 10   0 0     0   1   49 56     0 0   11 11   105
700178 MN Stearns 73 school 2733510 742 Independent Districts and Schools ST. CLOUD PUBLIC SCHOOL DISTRICT 273351003003 65 ST CLOUD AREA LEARNING CENTER Public Area Learning Center ALC (State approved) Alternative School No High 07 12 2017   grade_12 94.0 39.0 17.0   5.0 5.0     0.0   14.0   85.0 89.0     11.0   8.0     105.0   53.0   174.0 94 39 17   5 5     0   14   85 89     11 8   105 53   174
701872 MN Ramsey 62 school 2700117 4017 Charter Schools Minnesota Transitions Charter School 270011703694 18 MTCS CONNECTIONS ACADEMY Distance Learning Program OLL (State approved) Regular School Yes Other KG 12 2017   grade_6 94.0 8.0 10.0   1.0 6.0     0.0   8.0   51.0 76.0     0.0   2.0     45.0   14.0   127.0 94 8 10   1 6     0   8   51 76     0 2   45 14   127
695480 MN Mille Lacs 48 school 2720670 912 Independent Districts and Schools MILACA PUBLIC SCHOOL DISTRICT 272067000923 10 MILACA ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   pk_12_total 934.0 4.0 10.0   9.0 1.0     0.0   54.0   510.0 502.0     0.0   11.0     495.0   218.0   1012.0 934 4 10   9 1     0   54   510 502     0 11   495 218   1012
689756 MN Saint Louis 69 school 2713980 701 Independent Districts and Schools HIBBING PUBLIC SCHOOL DISTRICT 271398001539 350 HIBBING HIGH Secondary School (Grades 7-12) Regular School No High 07 12 2017   pk_12_total 930.0 34.0 12.0   15.0 11.0     0.0   41.0   511.0 532.0     0.0   8.0     404.0   164.0   1043.0 930 34 12   15 11     0   41   511 532     0 8   404 164   1043
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
691322 MN Cass 11 school 2728350 116 Independent Districts and Schools PILLAGER PUBLIC SCHOOL DISTRICT 272835001253 10 PILLAGER ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2017   grade_3 93.0 0.0 1.0   0.0 0.0     0.0   1.0   50.0 45.0     0.0   0.0     45.0   15.0   95.0 93 0 1   0 0     0   1   50 45     0 0   45 15   95
691460 MN Crow Wing 18 school 2706090 181 Independent Districts and Schools BRAINERD PUBLIC SCHOOL DISTRICT 270609000259 12 RIVERSIDE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 04 2017   kindergarten 93.0 1.0 2.0   4.0 0.0     0.0   3.0   46.0 57.0     0.0   0.0     60.0   26.0   103.0 93 1 2   4 0     0   3   46 57     0 0   60 26   103
691573 MN Dakota 19 school 2711820 192 Independent Districts and Schools FARMINGTON PUBLIC SCHOOL DISTRICT 271182000569 10 FARMINGTON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_5 93.0 6.0 5.0   0.0 1.0     0.0   7.0   56.0 56.0         1.0     33.0   21.0   112.0 93 6 5   0 1     0   7   56 56       1   33 21   112
691647 MN Dakota 19 school 2717780 194 Independent Districts and Schools LAKEVILLE PUBLIC SCHOOL DISTRICT 271778000025 596 CHERRY VIEW ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_5 93.0 2.0 5.0   0.0 4.0     0.0   11.0   58.0 57.0     2.0   0.0         25.0   115.0 93 2 5   0 4     0   11   58 57     2 0     25   115
691653 MN Dakota 19 school 2717780 194 Independent Districts and Schools LAKEVILLE PUBLIC SCHOOL DISTRICT 271778002436 597 LAKEVIEW ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_4 93.0 2.0 7.0   1.0 3.0     0.0   5.0   58.0 53.0         2.0     11.0   12.0   111.0 93 2 7   1 3     0   5   58 53       2   11 12   111
691777 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239002282 718 PINEWOOD EL. Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_5 93.0 5.0 8.0   0.0 8.0     0.0   3.0   66.0 51.0     4.0   0.0     14.0   16.0   117.0 93 5 8   0 8     0   3   66 51     4 0   14 16   117
692243 MN Hennepin 27 school 2714220 272 Independent Districts and Schools EDEN PRAIRIE PUBLIC SCHOOL DISTRICT 271422003620 886 EAGLE HEIGHTS SPANISH IMMERSION Elementary School (Grades PK-6) Regular School No Elementary KG 06 2017   grade_5 93.0 4.0 12.0   0.0 5.0     0.0   7.0   62.0 59.0     2.0   0.0     11.0   12.0   121.0 93 4 12   0 5     0   7   62 59     2 0   11 12   121
692305 MN Hennepin 27 school 2711670 276 Independent Districts and Schools MINNETONKA PUBLIC SCHOOL DISTRICT 271167000542 602 DEEPHAVEN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_2 93.0 2.0 1.0   0.0 2.0     0.0   3.0   53.0 48.0     3.0   0.0     6.0   17.0   101.0 93 2 1   0 2     0   3   53 48     3 0   6 17   101
694109 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384001194 533 NOKOMIS MONTESSORI NORTH CAMPUS Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   pk_12_total 93.0 25.0 21.0   0.0 185.0     1.0   25.0   179.0 171.0     164.0   3.0     228.0   40.0   350.0 93 25 21   0 185     1   25   179 171     164 3   228 40   350

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