Data source: Big Local News · About: Big Local

13,903 rows where state = "MN" and year = 2019 sorted by white 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
1953423 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239001381 39 ROSEMOUNT MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2019   pk_12_total 997.0 67.0 84.0   2.0 83.0     1.0   77.0   664.0 647.0     26.0   1.0     177.0   143.0   1311.0 997 67 84   2 83     1   77   664 647     26 1   177 143   1311
1954719 MN Ramsey 62 school 2722950 621 Independent Districts and Schools MOUNDS VIEW PUBLIC SCHOOL DISTRICT 272295001118 65 IRONDALE SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 09 12 2019   pk_12_total 991.0 320.0 236.0   10.0 159.0     1.0   61.0   893.0 885.0     81.0   23.0     719.0   205.0   1778.0 991 320 236   10 159     1   61   893 885     81 23   719 205   1778
1954905 MN Washington 82 school 2718750 832 Independent Districts and Schools MAHTOMEDI PUBLIC SCHOOL DISTRICT 271875000870 40 MAHTOMEDI SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 09 12 2019   pk_12_total 990.0 41.0 50.0   1.0 46.0     0.0   48.0   601.0 575.0     9.0   2.0     78.0   86.0   1176.0 990 41 50   1 46     0   48   601 575     9 2   78 86   1176
1944697 MN Kanabec 33 school 2721480 332 Independent Districts and Schools MORA PUBLIC SCHOOL DISTRICT 272148000944 40 MORA SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_12 99.0 1.0 2.0   1.0 1.0     0.0   1.0   58.0 47.0     0.0   1.0     24.0   10.0   105.0 99 1 2   1 1     0   1   58 47     0 1   24 10   105
1946208 MN Anoka 2 school 2733330 16 Independent Districts and Schools SPRING LAKE PARK PUBLIC SCHOOLS 273333001461 772 NORTHPOINT ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 04 2019   grade_2 99.0 3.0 2.0   0.0 10.0     0.0   7.0   64.0 57.0     8.0   0.0     15.0   14.0   121.0 99 3 2   0 10     0   7   64 57     8 0   15 14   121
1946209 MN Anoka 2 school 2733330 16 Independent Districts and Schools SPRING LAKE PARK PUBLIC SCHOOLS 273333001461 772 NORTHPOINT ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 04 2019   grade_3 99.0 5.0 3.0   0.0 7.0     0.0   12.0   70.0 56.0     *   0.0         16.0   126.0 99 5 3   0 7     0   12   70 56       0     16   126
1946557 MN Carlton 9 school 2738880 99 Independent Districts and Schools ESKO PUBLIC SCHOOL DISTRICT 273888001683 30 WINTERQUIST ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   grade_6 99.0 1.0 4.0   0.0 1.0     0.0   4.0   53.0 56.0     1.0   1.0     11.0   12.0   109.0 99 1 4   0 1     0   4   53 56     1 1   11 12   109
1946600 MN Carver 10 school 2741910 111 Independent Districts and Schools WATERTOWN-MAYER PUBLIC SCHOOL DIST. 274191003674 839 WATERTOWN-MAYER ELEMENTARY SCHOOL Elementary School (Grades PK-6) Regular School No Elementary KG 04 2019   grade_1 99.0 0.0 0.0   1.0 0.0     0.0   2.0   50.0 52.0     1.0   0.0     19.0   14.0   102.0 99 0 0   1 0     0   2   50 52     1 0   19 14   102
1946961 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 2019   grade_4 99.0 4.0 5.0   0.0 11.0     0.0   4.0   57.0 66.0     8.0   *     20.0   26.0   123.0 99 4 5   0 11     0   4   57 66     8     20 26   123
1946966 MN Dakota 19 school 2711820 192 Independent Districts and Schools FARMINGTON PUBLIC SCHOOL DISTRICT 271182004376 100 RIVERVIEW ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   grade_1 99.0 2.0 3.0   1.0 3.0     0.0   7.0   68.0 47.0     0.0   0.0     12.0   22.0   115.0 99 2 3   1 3     0   7   68 47     0 0   12 22   115
1947098 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 2019   grade_4 99.0 17.0 33.0   1.0 8.0     0.0   16.0   96.0 78.0     14.0   1.0     59.0   30.0   174.0 99 17 33   1 8     0   16   96 78     14 1   59 30   174
1947873 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 2019   grade_1 99.0 13.0 2.0   1.0 5.0     0.0   9.0   65.0 64.0     *   0.0     15.0   11.0   129.0 99 13 2   1 5     0   9   65 64       0   15 11   129
1948178 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 2019   grade_3 99.0 0.0 9.0   0.0 1.0     0.0   10.0   59.0 60.0     3.0   0.0     72.0   33.0   119.0 99 0 9   0 1     0   10   59 60     3 0   72 33   119
1948833 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 2019   grade_1 99.0 12.0 6.0   0.0 13.0     0.0   14.0   70.0 74.0     10.0   0.0     29.0   10.0   144.0 99 12 6   0 13     0   14   70 74     10 0   29 10   144
1949107 MN Ramsey 62 school 2722950 621 Independent Districts and Schools MOUNDS VIEW PUBLIC SCHOOL DISTRICT 272295001130 36 Valentine Hills Elementary Elementary School (Grades PK-6) Regular School No Elementary 01 05 2019   grade_1 99.0 15.0 13.0   0.0 11.0     0.0   10.0   71.0 77.0     10.0   0.0     51.0   14.0   148.0 99 15 13   0 11     0   10   71 77     10 0   51 14   148
1949767 MN Roseau 68 school 2703540 676 Independent Districts and Schools BADGER PUBLIC SCHOOL DISTRICT 270354000162 10 BADGER ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   pk_12_total 99.0 4.0 0.0   0.0 1.0     0.0   4.0   65.0 43.0     0.0   0.0     51.0   13.0   108.0 99 4 0   0 1     0   4   65 43     0 0   51 13   108
1950017 MN Scott 70 school 2730060 719 Independent Districts and Schools PRIOR LAKE-SAVAGE AREA SCHOOLS 273006004305 18 REDTAIL RIDGE ELEMENTARY SCHOOL Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   grade_5 99.0 3.0 5.0   0.0 6.0     0.0   5.0   54.0 64.0     0.0   0.0     9.0   12.0   118.0 99 3 5   0 6     0   5   54 64     0 0   9 12   118
1950072 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 2019   grade_4 99.0 0.0 0.0   5.0 2.0     0.0   3.0   56.0 53.0     2.0   0.0     14.0   13.0   109.0 99 0 0   5 2     0   3   56 53     2 0   14 13   109
1950094 MN Hennepin 27 school 2711370 728 Independent Districts and Schools ELK RIVER PUBLIC SCHOOL DISTRICT 271137000521 70 ROGERS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   grade_1 99.0 0.0 0.0   0.0 1.0     0.0   6.0   46.0 60.0     *   0.0     7.0   15.0   106.0 99 0 0   0 1     0   6   46 60       0   7 15   106
1950493 MN Waseca 81 school 2741880 829 Independent Districts and Schools WASECA PUBLIC SCHOOL DISTRICT 274188001746 40 WASECA INTERMEDIATE SCHOOL Elementary School (Grades PK-6) Regular School No Middle 04 06 2019   grade_4 99.0 5.0 7.0   0.0 1.0     0.0   9.0   55.0 66.0     4.0   *     47.0   21.0   121.0 99 5 7   0 1     0   9   55 66     4     47 21   121
1950512 MN Washington 82 school 2712270 831 Independent Districts and Schools FOREST LAKE PUBLIC SCHOOL DISTRICT 271227000596 627 Forest View Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 03 2019   grade_3 99.0 4.0 9.0   0.0 7.0     0.0   6.0   74.0 51.0     8.0   1.0     43.0   30.0   125.0 99 4 9   0 7     0   6   74 51     8 1   43 30   125
1950894 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 2019   grade_3 99.0 2.0 18.0   0.0 1.0     0.0   5.0   67.0 58.0     7.0   0.0     37.0   18.0   125.0 99 2 18   0 1     0   5   67 58     7 0   37 18   125
1950903 MN Hennepin 27 school 2732070 883 Independent Districts and Schools ROCKFORD PUBLIC SCHOOL DISTRICT 273207001367 2 ROCKFORD ELEMENTARY ARTS MAGNET SCH Elementary School (Grades PK-6) Regular School No Elementary PK 04 2019   grade_1 99.0 3.0 14.0   0.0 1.0     0.0   7.0   74.0 50.0     11.0   0.0     37.0   16.0   124.0 99 3 14   0 1     0   7   74 50     11 0   37 16   124
1951501 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 2019   grade_5 99.0 0.0 1.0   0.0 0.0     0.0   0.0   54.0 46.0     0.0   1.0     18.0   13.0   100.0 99 0 1   0 0     0   0   54 46     0 1   18 13   100
1951753 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124001861 104 LAKE HARRIET LOWER ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 03 2019   kindergarten 99.0 5.0 6.0   1.0 3.0     0.0   11.0   63.0 62.0     3.0   0.0     13.0   8.0   125.0 99 5 6   1 3     0   11   63 62     3 0   13 8   125
1951801 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 2019   grade_3 99.0 7.0 10.0   0.0 2.0     0.0   17.0   63.0 72.0     2.0   0.0     13.0   17.0   135.0 99 7 10   0 2     0   17   63 72     2 0   13 17   135
1953437 MN Dakota 19 school 2742270 197 Independent Districts and Schools WEST ST. PAUL-MENDOTA HTS.-EAGAN 274227002646 52 FRIENDLY HILLS MIDDLE Middle School (Grades 5-8) Regular School No Middle 05 08 2019   grade_6 99.0 32.0 40.0   1.0 12.0     0.0   19.0   98.0 105.0     12.0   0.0     77.0   34.0   203.0 99 32 40   1 12     0   19   98 105     12 0   77 34   203
1953609 MN Lyon 42 school 2718940 413 Independent Districts and Schools MARSHALL PUBLIC SCHOOL DISTRICT 271894003715 6 MARSHALL MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 05 08 2019   grade_6 99.0 14.0 26.0   2.0 17.0     0.0   6.0   98.0 66.0     16.0   2.0     77.0   23.0   164.0 99 14 26   2 17     0   6   98 66     16 2   77 23   164
1954076 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124000965 119 Field Community Middle School (Grades 5-8) Regular School No Middle 05 08 2019   grade_7 99.0 13.0 5.0   3.0 7.0     0.0   8.0   68.0 67.0     3.0   1.0     25.0   16.0   135.0 99 13 5   3 7     0   8   68 67     3 1   25 16   135
1954506 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   grade_11 99.0 181.0 59.0   5.0 164.0     0.0   10.0   259.0 259.0     58.0   11.0     309.0   51.0   518.0 99 181 59   5 164     0   10   259 259     58 11   309 51   518
1954695 MN Otter Tail 56 school 2728230 549 Independent Districts and Schools PERHAM-DENT PUBLIC SCHOOL DISTRICT 272823001248 30 PERHAM SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 09 12 2019   grade_9 99.0 3.0 16.0   2.0 4.0     0.0   6.0   66.0 64.0     2.0   1.0     46.0   25.0   130.0 99 3 16   2 4     0   6   66 64     2 1   46 25   130
1954986 MN Clay 14 school 2710260 2164 Independent Districts and Schools DILWORTH-GLYNDON-FELTON 271026000642 4 DILWORTH-GLYNDON-FELTON SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 09 12 2019   grade_9 99.0 1.0 7.0   2.0 0.0     0.0   3.0   51.0 61.0     2.0   0.0     24.0   15.0   112.0 99 1 7   2 0     0   3   51 61     2 0   24 15   112
1955921 MN Chippewa 12 school 2700058 6018 Education Districts MN River Valley Education District 270005802245 20 MN River Valley ALC-Seatbased Public Area Learning Center ALC (State approved) Alternative School No High 07 12 2019   pk_12_total 99.0 3.0 29.0   14.0 0.0     0.0   8.0   70.0 83.0     2.0   4.0     59.0   40.0   153.0 99 3 29   14 0     0   8   70 83     2 4   59 40   153
1956126 MN Hennepin 27 school 2731780 281 Independent Districts and Schools ROBBINSDALE PUBLIC SCHOOL DISTRICT 273178002441 103 EARLY CHILDHOOD SPECIAL EDUCATION Special Education Special Education School No Elementary PK 01 2019   early_childhood_special_ed 99.0 51.0 34.0   1.0 14.0     0.0   15.0   134.0 80.0     *   *         *   214.0 99 51 34   1 14     0   15   134 80                 214
1956128 MN Hennepin 27 school 2731780 281 Independent Districts and Schools ROBBINSDALE PUBLIC SCHOOL DISTRICT 273178002441 103 EARLY CHILDHOOD SPECIAL EDUCATION Special Education Special Education School No Elementary PK 01 2019   pk_12_total 99.0 52.0 34.0   1.0 14.0     0.0   15.0   135.0 80.0     0.0   0.0     72.0   *   215.0 99 52 34   1 14     0   15   135 80     0 0   72     215
1958126 MN Wabasha 79 school 2700287 2899 Independent Districts and Schools PLAINVIEW-ELGIN-MILLVILLE 270028703714 30 PLAINVIEW-ELGIN-MILLVILLE JUNIOR Junior High School (Grades 7-8 or 7-9) Regular School No Middle 07 08 2019   grade_7 99.0 1.0 10.0   0.0 0.0     0.0   3.0   50.0 63.0     3.0   0.0     30.0   9.0   113.0 99 1 10   0 0     0   3   50 63     3 0   30 9   113
1954573 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 2019   pk_12_total 987.0 9.0 17.0   41.0 2.0     2.0   78.0   566.0 570.0     0.0   2.0     324.0   150.0   1136.0 987 9 17   41 2     2   78   566 570     0 2   324 150   1136
1953252 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 2019   pk_12_total 982.0 100.0 55.0   6.0 92.0     1.0   43.0   660.0 619.0     21.0   19.0     279.0   159.0   1279.0 982 100 55   6 92     1   43   660 619     21 19   279 159   1279
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
1945535 MN Martin 46 school 2700124 2752 Independent Districts and Schools FAIRMONT AREA SCHOOL DISTRICT 270012400553 60 FAIRMONT JR./SR. HIGH SCHOOL Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_10 98.0 1.0 16.0   0.0 3.0     0.0   2.0   54.0 66.0     5.0   3.0     43.0   12.0   120.0 98 1 16   0 3     0   2   54 66     5 3   43 12   120
1946188 MN Anoka 2 school 2733540 15 Independent Districts and Schools St. Francis Area Schools 273354000230 782 ST. FRANCIS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   grade_3 98.0 2.0 7.0   3.0 1.0     0.0   8.0   53.0 66.0     *   0.0     39.0   17.0   119.0 98 2 7   3 1     0   8   53 66       0   39 17   119
1946294 MN Beltrami 4 school 2704440 31 Independent Districts and Schools BEMIDJI PUBLIC SCHOOL DISTRICT 270444000191 50 CENTRAL ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 03 2019   pk_12_total 98.0 2.0 5.0   42.0 0.0     0.0   25.0   101.0 71.0     1.0   10.0     126.0   55.0   172.0 98 2 5   42 0     0   25   101 71     1 10   126 55   172
1946577 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 2019   grade_1 98.0 3.0 3.0   0.0 3.0     0.0   0.0   53.0 54.0     2.0   0.0     11.0   15.0   107.0 98 3 3   0 3     0   0   53 54     2 0   11 15   107
1946649 MN Carver 10 school 2708190 112 Independent Districts and Schools EASTERN CARVER COUNTY PUBLIC SCHOOL 270819003506 512 VICTORIA ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   kindergarten 98.0 1.0 2.0   1.0 1.0     0.0   4.0   47.0 60.0     1.0   0.0     4.0   7.0   107.0 98 1 2   1 1     0   4   47 60     1 0   4 7   107
1947127 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239002185 715 HIGHLAND ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   grade_3 98.0 6.0 5.0   0.0 8.0     0.0   5.0   67.0 55.0     7.0   0.0     13.0   24.0   122.0 98 6 5   0 8     0   5   67 55     7 0   13 24   122
1947635 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 2019   grade_4 98.0 3.0 14.0   0.0 4.0     0.0   7.0   62.0 64.0     3.0   0.0     9.0   5.0   126.0 98 3 14   0 4     0   7   62 64     3 0   9 5   126
1947682 MN Hennepin 27 school 2711250 273 Independent Districts and Schools EDINA PUBLIC SCHOOL DISTRICT 271125000709 533 NORMANDALE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   kindergarten 98.0 1.0 5.0   0.0 4.0     0.0   1.0   48.0 61.0     5.0   0.0         7.0   109.0 98 1 5   0 4     0   1   48 61     5 0     7   109
1947726 MN Hennepin 27 school 2711670 276 Independent Districts and Schools MINNETONKA PUBLIC SCHOOL DISTRICT 271167000549 606 SCENIC HEIGHTS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   grade_2 98.0 1.0 4.0   0.0 29.0     0.0   18.0   77.0 73.0     6.0   0.0     9.0   14.0   150.0 98 1 4   0 29     0   18   77 73     6 0   9 14   150
1948054 MN Hennepin 27 school 2742160 284 Independent Districts and Schools WAYZATA PUBLIC SCHOOL DISTRICT 274216004847 803 Meadow Ridge Elementary School Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   grade_1 98.0 9.0 4.0   0.0 35.0     0.0   4.0   69.0 81.0     4.0   0.0     11.0   12.0   150.0 98 9 4   0 35     0   4   69 81     4 0   11 12   150
1948280 MN Kandiyohi 34 school 2723400 345 Independent Districts and Schools NEW LONDON-SPICER SCHOOL DISTRICT 272340001141 10 PRAIRIE WOODS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2019   kindergarten 98.0 0.0 14.0   0.0 0.0     0.0   1.0   58.0 55.0     1.0   2.0     30.0   9.0   113.0 98 0 14   0 0     0   1   58 55     1 2   30 9   113
1948717 MN Nicollet 52 school 2733870 508 Independent Districts and Schools ST. PETER PUBLIC SCHOOL DISTRICT 273387001638 30 North Elementary School Elementary School (Grades PK-6) Regular School No Elementary 02 04 2019   grade_3 98.0 9.0 19.0   0.0 0.0     0.0   11.0   70.0 67.0     16.0   0.0     51.0   22.0   137.0 98 9 19   0 0     0   11   70 67     16 0   51 22   137
1948774 MN Olmsted 55 school 2731800 535 Independent Districts and Schools ROCHESTER PUBLIC SCHOOL DISTRICT 273180000982 110 BAMBER VALLEY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   grade_2 98.0 6.0 21.0   0.0 13.0     0.0   6.0   68.0 76.0     18.0   0.0     38.0   24.0   144.0 98 6 21   0 13     0   6   68 76     18 0   38 24   144
1948835 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 2019   grade_3 98.0 11.0 7.0   0.0 12.0     0.0   8.0   77.0 59.0     10.0   0.0     29.0   13.0   136.0 98 11 7   0 12     0   8   77 59     10 0   29 13   136
1949002 MN Pine 58 school 2728380 578 Independent Districts and Schools PINE CITY PUBLIC SCHOOL DISTRICT 272838001255 10 PINE CITY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   grade_1 98.0 0.0 3.0   2.0 0.0     0.0   4.0   56.0 51.0     0.0   1.0     40.0   15.0   107.0 98 0 3   2 0     0   4   56 51     0 1   40 15   107
1949239 MN Ramsey 62 school 2732430 623 Independent Districts and Schools ROSEVILLE PUBLIC SCHOOL DISTRICT 273243001389 723 EDGERTON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 06 2019   pk_12_total 98.0 72.0 74.0   0.0 220.0     0.0   31.0   272.0 223.0     143.0   12.0     382.0   57.0   495.0 98 72 74   0 220     0   31   272 223     143 12   382 57   495
1950107 MN Hennepin 27 school 2711370 728 Independent Districts and Schools ELK RIVER PUBLIC SCHOOL DISTRICT 271137003534 160 HASSAN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   kindergarten 98.0 5.0 7.0   0.0 4.0     0.0   5.0   72.0 47.0     5.0   0.0     10.0   12.0   119.0 98 5 7   0 4     0   5   72 47     5 0   10 12   119
1951799 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 2019   grade_1 98.0 5.0 6.0   1.0 4.0     0.0   15.0   69.0 60.0     3.0   0.0     16.0   9.0   129.0 98 5 6   1 4     0   15   69 60     3 0   16 9   129
1952382 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 2019   pk_12_total 98.0 0.0 0.0   0.0 0.0     0.0   1.0   56.0 43.0     2.0   0.0     27.0   7.0   99.0 98 0 0   0 0     0   1   56 43     2 0   27 7   99
1952444 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 2019   pk_12_total 98.0 0.0 2.0   5.0 0.0     0.0   0.0   51.0 54.0     0.0   0.0     41.0   30.0   105.0 98 0 2   5 0     0   0   51 54     0 0   41 30   105
1952475 MN Washington 82 school 2700358 4116 Charter Schools Lakes International Language Academy 270035804102 10 Lakes International Language Academy Elementary School (Grades PK-6) Regular School Yes Elementary KG 05 2019   grade_4 98.0 1.0 14.0   1.0 2.0     0.0   14.0   63.0 67.0     6.0   0.0     11.0   13.0   130.0 98 1 14   1 2     0   14   63 67     6 0   11 13   130
1953436 MN Dakota 19 school 2742270 197 Independent Districts and Schools WEST ST. PAUL-MENDOTA HTS.-EAGAN 274227002646 52 FRIENDLY HILLS MIDDLE Middle School (Grades 5-8) Regular School No Middle 05 08 2019   grade_5 98.0 30.0 41.0   2.0 9.0     0.0   14.0   106.0 88.0     20.0   2.0     86.0   22.0   194.0 98 30 41   2 9     0   14   106 88     20 2   86 22   194
1954520 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   grade_10 98.0 182.0 65.0   3.0 33.0     1.0   37.0   214.0 205.0     47.0   9.0     280.0   73.0   419.0 98 182 65   3 33     1   37   214 205     47 9   280 73   419
1955252 MN Ramsey 62 school 2700351 4112 Charter Schools ST PAUL CONSERVATORY PERFORMING ART 270035104098 10 ST PAUL CONSERVATORY PERFORMING ART Senior High School (Grades 9-12) Regular School Yes High 09 12 2019   grade_11 98.0 7.0 14.0   1.0 2.0     0.0   10.0   39.0 93.0     0.0   0.0     18.0   7.0   132.0 98 7 14   1 2     0   10   39 93     0 0   18 7   132
1955350 MN Anoka 2 school 2733540 15 Independent Districts and Schools St. Francis Area Schools 273354004980 18 Saints Academy Public Area Learning Center ALC (State approved) Alternative School No High 07 12 2019   grade_7 98.0 0.0 5.0   0.0 11.0     0.0   2.0   68.0 48.0     8.0   4.0     42.0   7.0   116.0 98 0 5   0 11     0   2   68 48     8 4   42 7   116
1958091 MN Scott 70 school 2704050 716 Independent Districts and Schools BELLE PLAINE PUBLIC SCHOOL DISTRICT 270405002169 30 BELLE PLAINE JUNIOR HIGH Junior High School (Grades 7-8 or 7-9) Regular School No Middle 07 08 2019   grade_8 98.0 1.0 7.0   1.0 3.0     1.0   3.0   49.0 65.0     0.0   0.0     21.0   10.0   114.0 98 1 7   1 3     1   3   49 65     0 0   21 10   114
1954264 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 2019   pk_12_total 976.0 235.0 245.0   3.0 162.0     4.0   98.0   825.0 898.0     125.0   9.0     586.0   178.0   1723.0 976 235 245   3 162     4   98   825 898     125 9   586 178   1723
1944469 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 2019   grade_9 97.0 0.0 3.0   0.0 3.0     0.0   7.0   56.0 54.0     1.0   1.0     8.0   14.0   110.0 97 0 3   0 3     0   7   56 54     1 1   8 14   110
1946743 MN Clay 14 school 2721420 152 Independent Districts and Schools MOORHEAD PUBLIC SCHOOL DISTRICT 272142005026 185 Dorothy Dodds Elementary School Elementary School (Grades PK-6) Regular School No Elementary KG 04 2019   grade_1 97.0 15.0 14.0   4.0 1.0     0.0   8.0   83.0 56.0     11.0   0.0     53.0   23.0   139.0 97 15 14   4 1     0   8   83 56     11 0   53 23   139
1946965 MN Dakota 19 school 2711820 192 Independent Districts and Schools FARMINGTON PUBLIC SCHOOL DISTRICT 271182004376 100 RIVERVIEW ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   kindergarten 97.0 0.0 7.0   0.0 1.0     0.0   4.0   60.0 49.0     *   0.0     5.0   *   109.0 97 0 7   0 1     0   4   60 49       0   5     109
1947652 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 2019   grade_5 97.0 9.0 9.0   0.0 7.0     0.0   4.0   74.0 52.0     8.0   0.0     12.0   13.0   126.0 97 9 9   0 7     0   4   74 52     8 0   12 13   126
1948281 MN Kandiyohi 34 school 2723400 345 Independent Districts and Schools NEW LONDON-SPICER SCHOOL DISTRICT 272340001141 10 PRAIRIE WOODS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2019   grade_1 97.0 0.0 7.0   0.0 0.0     0.0   0.0   48.0 56.0     4.0   1.0     26.0   13.0   104.0 97 0 7   0 0     0   0   48 56     4 1   26 13   104
1948547 MN Wright 86 school 2710060 466 Independent Districts and Schools DASSEL-COKATO PUBLIC SCHOOL DIST. 271006000426 1 COKATO ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2019   grade_4 97.0 1.0 2.0   1.0 1.0     0.0   3.0   60.0 45.0     4.0   0.0     29.0   22.0   105.0 97 1 2   1 1     0   3   60 45     4 0   29 22   105
1948834 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 2019   grade_2 97.0 16.0 3.0   1.0 19.0     0.0   3.0   69.0 70.0     9.0   *     23.0   15.0   139.0 97 16 3   1 19     0   3   69 70     9     23 15   139
1949005 MN Pine 58 school 2728380 578 Independent Districts and Schools PINE CITY PUBLIC SCHOOL DISTRICT 272838001255 10 PINE CITY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   grade_4 97.0 2.0 0.0   1.0 0.0     0.0   1.0   56.0 45.0     0.0   0.0     40.0   11.0   101.0 97 2 0   1 0     0   1   56 45     0 0   40 11   101
1949043 MN Polk 60 school 2711130 595 Independent Districts and Schools EAST GRAND FORKS PUBLIC SCHOOL DIST 271113000497 120 NEW HEIGHTS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 02 2019   grade_2 97.0 21.0 18.0   1.0 0.0     0.0   7.0   72.0 72.0     16.0   0.0     52.0   13.0   144.0 97 21 18   1 0     0   7   72 72     16 0   52 13   144
1949822 MN Saint Louis 69 school 2712210 698 Independent Districts and Schools FLOODWOOD PUBLIC SCHOOL DISTRICT 271221000588 10 FLOODWOOD ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   pk_12_total 97.0 4.0 2.0   4.0 0.0     0.0   7.0   53.0 61.0     *   *     55.0   *   114.0 97 4 2   4 0     0   7   53 61           55     114
1950063 MN Scott 70 school 2723430 721 Independent Districts and Schools NEW PRAGUE AREA SCHOOLS 272343003641 521 EAGLE VIEW Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   grade_2 97.0 1.0 2.0   1.0 2.0     1.0   1.0   51.0 54.0     *   *         20.0   105.0 97 1 2   1 2     1   1   51 54             20   105
1950109 MN Hennepin 27 school 2711370 728 Independent Districts and Schools ELK RIVER PUBLIC SCHOOL DISTRICT 271137003534 160 HASSAN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   grade_2 97.0 4.0 6.0   0.0 4.0     1.0   4.0   68.0 48.0     11.0   0.0     14.0   11.0   116.0 97 4 6   0 4     1   4   68 48     11 0   14 11   116
1950110 MN Hennepin 27 school 2711370 728 Independent Districts and Schools ELK RIVER PUBLIC SCHOOL DISTRICT 271137003534 160 HASSAN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   grade_3 97.0 4.0 10.0   0.0 5.0     0.0   4.0   56.0 64.0     9.0   0.0     16.0   13.0   120.0 97 4 10   0 5     0   4   56 64     9 0   16 13   120
1950152 MN Wright 86 school 2711370 728 Independent Districts and Schools ELK RIVER PUBLIC SCHOOL DISTRICT 271137002557 800 OTSEGO ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   kindergarten 97.0 1.0 2.0   0.0 3.0     0.0   7.0   53.0 57.0     4.0   0.0     12.0   18.0   110.0 97 1 2   0 3     0   7   53 57     4 0   12 18   110
1950460 MN Wabasha 79 school 2717520 813 Independent Districts and Schools LAKE CITY PUBLIC SCHOOL DISTRICT 271752000803 10 BLUFF VIEW ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   grade_5 97.0 0.0 6.0   0.0 0.0     0.0   3.0   60.0 46.0     3.0   0.0     24.0   14.0   106.0 97 0 6   0 0     0   3   60 46     3 0   24 14   106
1951649 MN Wabasha 79 school 2700287 2899 Independent Districts and Schools PLAINVIEW-ELGIN-MILLVILLE 270028703701 10 PLAINVIEW-ELGIN-MILLVILLE PK-3 Elementary School (Grades PK-6) Regular School No Elementary PK 03 2019   kindergarten 97.0 0.0 8.0   0.0 1.0     0.0   1.0   61.0 46.0     2.0   0.0     24.0   8.0   107.0 97 0 8   0 1     0   1   61 46     2 0   24 8   107
1951790 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124000945 110 BURROUGHS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   grade_5 97.0 9.0 4.0   0.0 4.0     0.0   3.0   54.0 63.0     1.0   0.0     9.0   11.0   117.0 97 9 4   0 4     0   3   54 63     1 0   9 11   117
1953438 MN Dakota 19 school 2742270 197 Independent Districts and Schools WEST ST. PAUL-MENDOTA HTS.-EAGAN 274227002646 52 FRIENDLY HILLS MIDDLE Middle School (Grades 5-8) Regular School No Middle 05 08 2019   grade_7 97.0 25.0 30.0   0.0 5.0     1.0   14.0   81.0 91.0     12.0   2.0     60.0   32.0   172.0 97 25 30   0 5     1   14   81 91     12 2   60 32   172
1953441 MN Dakota 19 school 2742270 197 Independent Districts and Schools WEST ST. PAUL-MENDOTA HTS.-EAGAN 274227001774 54 HERITAGE E-STEM MAGNET SCHOOL Middle School (Grades 5-8) Regular School No Middle 05 08 2019   grade_5 97.0 15.0 80.0   0.0 6.0     0.0   18.0   99.0 117.0     28.0   4.0     115.0   36.0   216.0 97 15 80   0 6     0   18   99 117     28 4   115 36   216
1953622 MN Meeker 47 school 2718210 465 Independent Districts and Schools LITCHFIELD PUBLIC SCHOOL DISTRICT 271821000838 30 Litchfield Middle School Middle School (Grades 5-8) Regular School No Middle 05 08 2019   grade_5 97.0 0.0 7.0   1.0 1.0     0.0   5.0   61.0 50.0     1.0   0.0     33.0   15.0   111.0 97 0 7   1 1     0   5   61 50     1 0   33 15   111
1953643 MN Mille Lacs 48 school 2725050 480 Independent Districts and Schools ONAMIA PUBLIC SCHOOL DISTRICT 272505005107 50 Onamia Intermediate School Middle School (Grades 5-8) Regular School No Other 03 09 2019   pk_12_total 97.0 11.0 11.0   183.0 0.0     1.0   25.0   165.0 163.0     0.0   9.0     225.0   84.0   328.0 97 11 11   183 0     1   25   165 163     0 9   225 84   328
1953709 MN Olmsted 55 school 2731800 535 Independent Districts and Schools ROCHESTER PUBLIC SCHOOL DISTRICT 273180002449 340 FRIEDELL MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_8 97.0 8.0 11.0   1.0 24.0     0.0   11.0   72.0 80.0     3.0   0.0     22.0   18.0   152.0 97 8 11   1 24     0   11   72 80     3 0   22 18   152
1953956 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 2019   grade_6 97.0 6.0 13.0   1.0 2.0     0.0   5.0   59.0 65.0     3.0   1.0     22.0   15.0   124.0 97 6 13   1 2     0   5   59 65     3 1   22 15   124
1953990 MN Pope 61 school 2700019 2149 Independent Districts and Schools MINNEWASKA SCHOOL DISTRICT 270001903535 60 Minnewaska Area Intermediate School Middle School (Grades 5-8) Regular School No Middle 04 06 2019   grade_4 97.0 0.0 3.0   0.0 1.0     0.0   1.0   54.0 48.0     *   *         *   102.0 97 0 3   0 1     0   1   54 48                 102
1954576 MN Kandiyohi 34 school 2723400 345 Independent Districts and Schools NEW LONDON-SPICER SCHOOL DISTRICT 272340001142 30 NEW LONDON-SPICER SR. Senior High School (Grades 9-12) Regular School No High 09 12 2019   grade_11 97.0 0.0 5.0   0.0 0.0     0.0   0.0   51.0 51.0     *   *         *   102.0 97 0 5   0 0     0   0   51 51                 102
1955960 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318003171 198 Secondary Technical Education Program S.T.E.P. Secondary Vocational Program Career and Technical School No High 10 12 2019   grade_12 97.0 24.0 12.0   2.0 10.0     0.0   2.0   82.0 65.0     *   *     55.0   18.0   147.0 97 24 12   2 10     0   2   82 65           55 18   147
1954684 MN Olmsted 55 school 2731800 535 Independent Districts and Schools ROCHESTER PUBLIC SCHOOL DISTRICT 273180001015 310 JOHN MARSHALL SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 08 12 2019   pk_12_total 968.0 357.0 108.0   5.0 213.0     1.0   78.0   900.0 830.0     123.0   15.0     667.0   203.0   1730.0 968 357 108   5 213     1   78   900 830     123 15   667 203   1730
1944846 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 2019   grade_11 96.0 0.0 2.0   0.0 0.0     0.0   0.0   49.0 49.0     1.0   0.0     25.0   9.0   98.0 96 0 2   0 0     0   0   49 49     1 0   25 9   98
1944847 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 2019   grade_12 96.0 0.0 0.0   0.0 1.0     0.0   0.0   57.0 40.0     1.0   0.0     22.0   13.0   97.0 96 0 0   0 1     0   0   57 40     1 0   22 13   97
1945134 MN Stearns 73 school 2732850 743 Independent Districts and Schools SAUK CENTRE PUBLIC SCHOOL DISTRICT 273285001429 30 SAUK CENTRE SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_7 96.0 0.0 9.0   0.0 2.0     0.0   1.0   56.0 52.0     2.0   0.0     37.0   12.0   108.0 96 0 9   0 2     0   1   56 52     2 0   37 12   108
1945833 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 09 12 2019   grade_9 96.0 3.0 4.0   0.0 5.0     0.0   4.0   47.0 65.0     0.0   0.0     11.0   17.0   112.0 96 3 4   0 5     0   4   47 65     0 0   11 17   112
1946136 MN Anoka 2 school 2708100 12 Independent Districts and Schools CENTENNIAL PUBLIC SCHOOL DISTRICT 270810003172 515 BLUE HERON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   kindergarten 96.0 6.0 5.0   0.0 11.0     1.0   12.0   67.0 64.0     9.0   *     22.0   19.0   131.0 96 6 5   0 11     1   12   67 64     9     22 19   131
1946194 MN Anoka 2 school 2733540 15 Independent Districts and Schools St. Francis Area Schools 273354000233 784 Cedar Creek Elementary School Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   grade_2 96.0 1.0 0.0   0.0 8.0     0.0   9.0   56.0 58.0     5.0   *     33.0   13.0   114.0 96 1 0   0 8     0   9   56 58     5     33 13   114
1946658 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 2019   grade_2 96.0 7.0 5.0   0.0 5.0     0.0   6.0   58.0 61.0     3.0   1.0     17.0   13.0   119.0 96 7 5   0 5     0   6   58 61     3 1   17 13   119

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