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,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
697950 MN Hennepin 27 school 2711250 273 Independent Districts and Schools EDINA PUBLIC SCHOOL DISTRICT 271125000686 19 SOUTH VIEW MIDDLE Middle School (Grades 5-8) Regular School No Other 06 09 2017   pk_12_total 998.0 76.0 79.0   0.0 110.0     0.0   63.0   710.0 616.0     26.0   0.0     136.0   127.0   1326.0 998 76 79   0 110     0   63   710 616     26 0   136 127   1326
699545 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124001037 364 SOUTHWEST SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 09 12 2017   pk_12_total 994.0 495.0 174.0   15.0 105.0     3.0   8.0   892.0 902.0     195.0   31.0     624.0   205.0   1794.0 994 495 174   15 105     3   8   892 902     195 31   624 205   1794
690486 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_10 99.0 1.0 0.0   1.0 1.0     0.0   6.0   58.0 50.0     1.0   0.0     21.0   10.0   108.0 99 1 0   1 1     0   6   58 50     1 0   21 10   108
690639 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000114 411 MCKINLEY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_1 99.0 1.0 1.0   0.0 4.0     0.0   3.0   52.0 56.0         0.0     14.0   8.0   108.0 99 1 1   0 4     0   3   52 56       0   14 8   108
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
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
691464 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   grade_4 99.0 2.0 4.0   3.0 0.0     0.0   5.0   59.0 54.0     0.0   0.0     64.0   25.0   113.0 99 2 4   3 0     0   5   59 54     0 0   64 25   113
692299 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_3 99.0 6.0 10.0   0.0 0.0     0.0   3.0   54.0 64.0     4.0   0.0     10.0   17.0   118.0 99 6 10   0 0     0   3   54 64     4 0   10 17   118
693010 MN Lyon 42 school 2718940 413 Independent Districts and Schools MARSHALL PUBLIC SCHOOL DISTRICT 271894000894 3 WEST SIDE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 03 04 2017   grade_4 99.0 16.0 24.0   1.0 16.0     0.0   9.0   95.0 70.0         0.0     81.0   28.0   165.0 99 16 24   1 16     0   9   95 70       0   81 28   165
694551 MN Scott 70 school 2723430 721 Independent Districts and Schools NEW PRAGUE AREA SCHOOLS 272343002842 345 RAVEN STREAM ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_5 99.0 0.0 5.0   0.0 0.0     0.0   0.0   56.0 48.0         *     20.0   16.0   104.0 99 0 5   0 0     0   0   56 48           20 16   104
694771 MN Stearns 73 school 2732820 748 Independent Districts and Schools SARTELL-ST. STEPHEN SCHOOL DISTRICT 273282002187 40 PINE MEADOW ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 04 2017   kindergarten 99.0 1.0 3.0   0.0 1.0     0.0   8.0   52.0 60.0     2.0   0.0     21.0   11.0   112.0 99 1 3   0 1     0   8   52 60     2 0   21 11   112
694984 MN Washington 82 school 2712270 831 Independent Districts and Schools FOREST LAKE PUBLIC SCHOOL DISTRICT 271227000594 626 FOREST LAKE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 04 06 2017   grade_4 99.0 1.0 9.0   0.0 4.0     0.0   11.0   58.0 66.0     7.0   0.0     45.0   20.0   124.0 99 1 9   0 4     0   11   58 66     7 0   45 20   124
695066 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_4 99.0 10.0 8.0   0.0 7.0     0.0   12.0   80.0 56.0     8.0   2.0     25.0   21.0   136.0 99 10 8   0 7     0   12   80 56     8 2   25 21   136
696309 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 2017   kindergarten 99.0 12.0 11.0   0.0 3.0     1.0   9.0   76.0 59.0     8.0   0.0     19.0   11.0   135.0 99 12 11   0 3     1   9   76 59     8 0   19 11   135
696933 MN Hennepin 27 school 2700354 4089 Charter Schools NEW CITY SCHOOL 270035404174 10 NEW CITY SCHOOL Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2017   pk_12_total 99.0 20.0 14.0   1.0 0.0     0.0   13.0   74.0 73.0     8.0   0.0     44.0   9.0   147.0 99 20 14   1 0     0   13   74 73     8 0   44 9   147
697837 MN Scott 70 school 2707290 191 Independent Districts and Schools BURNSVILLE PUBLIC SCHOOL DISTRICT 270729002639 66 Eagle Ridge Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_8 99.0 23.0 17.0   0.0 24.0     0.0   12.0   88.0 87.0     14.0   0.0     54.0   16.0   175.0 99 23 17   0 24     0   12   88 87     14 0   54 16   175
698152 MN Otter Tail 56 school 2728230 549 Independent Districts and Schools PERHAM-DENT PUBLIC SCHOOL DISTRICT 272823002535 20 PRAIRIE WIND MIDDLE Middle School (Grades 5-8) Regular School No Middle 05 08 2017   grade_7 99.0 2.0 15.0   4.0 4.0     0.0   7.0   64.0 67.0     2.0   1.0     56.0   19.0   131.0 99 2 15   4 4     0   7   64 67     2 1   56 19   131
698384 MN Isanti 30 school 2707410 911 Independent Districts and Schools CAMBRIDGE-ISANTI PUBLIC SCHOOL DIST 270741003629 302 ISANTI MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_6 99.0 0.0 10.0   0.0 4.0     0.0   4.0   62.0 55.0     5.0   0.0     52.0   14.0   117.0 99 0 10   0 4     0   4   62 55     5 0   52 14   117
698992 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 2017   grade_10 99.0 0.0 6.0   0.0 1.0     0.0   0.0   66.0 40.0     0.0   0.0     29.0   11.0   106.0 99 0 6   0 1     0   0   66 40     0 0   29 11   106
699408 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 2017   grade_11 99.0 0.0 5.0   0.0 0.0     0.0   4.0   59.0 49.0     0.0   0.0     21.0   9.0   108.0 99 0 5   0 0     0   4   59 49     0 0   21 9   108
700523 MN Dakota 19 school 2707290 191 Independent Districts and Schools BURNSVILLE PUBLIC SCHOOL DISTRICT 270729002171 481 EARLY EDUCATION PROGRAM & SERVICES Special Education Special Education School No Elementary PK PK 2017   early_childhood_special_ed 99.0 53.0 44.0   1.0 15.0     0.0   14.0   157.0 69.0     0.0   0.0     90.0   *   226.0 99 53 44   1 15     0   14   157 69     0 0   90     226
700524 MN Dakota 19 school 2707290 191 Independent Districts and Schools BURNSVILLE PUBLIC SCHOOL DISTRICT 270729002171 481 EARLY EDUCATION PROGRAM & SERVICES Special Education Special Education School No Elementary PK PK 2017   pk_12_total 99.0 53.0 44.0   1.0 15.0     0.0   14.0   157.0 69.0     0.0   0.0     90.0   *   226.0 99 53 44   1 15     0   14   157 69     0 0   90     226
700871 MN Steele 74 school 2728050 761 Independent Districts and Schools OWATONNA PUBLIC SCHOOL DISTRICT 272805002681 903 OWATONNA ECSE Special Education Special Education School No Elementary PK PK 2017   early_childhood_special_ed 99.0 6.0 15.0   0.0 0.0     1.0   3.0   82.0 42.0     0.0   0.0     66.0   *   124.0 99 6 15   0 0     1   3   82 42     0 0   66     124
700872 MN Steele 74 school 2728050 761 Independent Districts and Schools OWATONNA PUBLIC SCHOOL DISTRICT 272805002681 903 OWATONNA ECSE Special Education Special Education School No Elementary PK PK 2017   pk_12_total 99.0 6.0 15.0   0.0 0.0     1.0   3.0   82.0 42.0     0.0   0.0     66.0   *   124.0 99 6 15   0 0     1   3   82 42     0 0   66     124
701922 MN Lesueur 40 school 2700261 4151 Charter Schools EDVISIONS OFF CAMPUS SCHOOL 270026103319 10 EDVISIONS OFF CAMPUS SCHOOL Distance Learning Program OLL (State approved) Regular School Yes High 07 12 2017   pk_12_total 99.0 4.0 2.0   6.0 1.0     0.0   4.0   58.0 58.0     0.0   0.0     29.0   36.0   116.0 99 4 2   6 1     0   4   58 58     0 0   29 36   116
702593 MN Rice 66 school 2700013 2143 Independent Districts and Schools Waterville-Elysian-Morristown Public School District 270001301104 20 WATERVILLE-ELYSIAN-MORRISTOWN JR. Junior High School (Grades 7-8 or 7-9) Regular School No Middle 07 08 2017   pk_12_total 99.0 1.0 7.0   2.0 1.0     0.0   1.0   52.0 59.0     3.0   0.0     32.0   23.0   111.0 99 1 7   2 1     0   1   52 59     3 0   32 23   111
697963 MN Carver 10 school 2711670 276 Independent Districts and Schools MINNETONKA PUBLIC SCHOOL DISTRICT 271167002194 175 MINNETONKA WEST MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   pk_12_total 989.0 31.0 55.0   4.0 58.0     1.0   29.0   598.0 569.0     16.0   0.0     64.0   148.0   1167.0 989 31 55   4 58     1   29   598 569     16 0   64 148   1167
698713 MN Blue Earth 7 school 2718780 77 Independent Districts and Schools MANKATO PUBLIC SCHOOL DISTRICT 271878000880 130 MANKATO WEST SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 09 12 2017   pk_12_total 982.0 101.0 47.0   4.0 28.0     1.0   12.0   591.0 584.0     30.0   12.0     304.0   128.0   1175.0 982 101 47   4 28     1   12   591 584     30 12   304 128   1175
689503 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_10 98.0 0.0 0.0   0.0 1.0     0.0   0.0   57.0 42.0     1.0   0.0     30.0   14.0   99.0 98 0 0   0 1     0   0   57 42     1 0   30 14   99
690484 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_8 98.0 0.0 2.0   1.0 0.0     0.0   3.0   55.0 49.0     1.0   0.0     15.0   17.0   104.0 98 0 2   1 0     0   3   55 49     1 0   15 17   104
690533 MN Wright 86 school 2700403 4229 Charter Schools Jane Goodall Environmental Science Academy 270040304850 10 Jane Goodall Environmental Science Academy Secondary School (Grades 7-12) Regular School Yes Other 06 12 2017   pk_12_total 98.0 0.0 1.0   0.0 0.0     0.0   2.0   65.0 36.0     0.0   1.0     25.0   33.0   101.0 98 0 1   0 0     0   2   65 36     0 1   25 33   101
690615 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_5 98.0 15.0 12.0   0.0 12.0     0.0   7.0   90.0 54.0     8.0   0.0     72.0   30.0   144.0 98 15 12   0 12     0   7   90 54     8 0   72 30   144
690767 MN Anoka 2 school 2708100 12 Independent Districts and Schools CENTENNIAL PUBLIC SCHOOL DISTRICT 270810000022 513 RICE LAKE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_2 98.0 0.0 4.0   0.0 3.0     0.0   8.0   71.0 42.0     1.0   0.0     9.0   17.0   113.0 98 0 4   0 3     0   8   71 42     1 0   9 17   113
690772 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 2017   kindergarten 98.0 4.0 4.0   1.0 6.0     0.0   7.0   55.0 65.0     4.0   0.0     21.0   15.0   120.0 98 4 4   1 6     0   7   55 65     4 0   21 15   120
691292 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 2017   grade_4 98.0 1.0 13.0   1.0 0.0     0.0   6.0   71.0 48.0     3.0   0.0     18.0   13.0   119.0 98 1 13   1 0     0   6   71 48     3 0   18 13   119
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
691483 MN Crow Wing 18 school 2728200 186 Independent Districts and Schools PEQUOT LAKES PUBLIC SCHOOLS 272820001244 10 EAGLE VIEW ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2017   kindergarten 98.0 1.0 0.0   1.0 0.0     0.0   0.0   46.0 54.0     0.0   1.0     24.0   6.0   100.0 98 1 0   1 0     0   0   46 54     0 1   24 6   100
691679 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   kindergarten 98.0 11.0 8.0   3.0 3.0     0.0   9.0   74.0 58.0     6.0   0.0     33.0   20.0   132.0 98 11 8   3 3     0   9   74 58     6 0   33 20   132
691752 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 2017   grade_1 98.0 6.0 5.0   0.0 7.0     0.0   4.0   65.0 55.0     11.0   0.0     10.0   17.0   120.0 98 6 5   0 7     0   4   65 55     11 0   10 17   120
691878 MN Dakota 19 school 2713530 200 Independent Districts and Schools HASTINGS PUBLIC SCHOOL DISTRICT 271353002239 612 CHRISTA MCAULIFFE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 04 2017   grade_3 98.0 3.0 8.0   0.0 2.0     0.0   2.0   57.0 56.0     3.0   0.0     30.0   14.0   113.0 98 3 8   0 2     0   2   57 56     3 0   30 14   113
693109 MN Meeker 47 school 2718210 465 Independent Districts and Schools LITCHFIELD PUBLIC SCHOOL DISTRICT 271821000837 10 LAKE RIPLEY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 04 2017   grade_1 98.0 2.0 17.0   0.0 0.0     0.0   3.0   59.0 61.0     4.0   1.0     56.0   18.0   120.0 98 2 17   0 0     0   3   59 61     4 1   56 18   120
693296 MN Nicollet 52 school 2733870 508 Independent Districts and Schools ST. PETER PUBLIC SCHOOL DISTRICT 273387001639 50 South Early Learning Center Elementary School (Grades PK-6) Regular School No Elementary PK 02 2017   grade_1 98.0 9.0 19.0   1.0 0.0     0.0   10.0   63.0 74.0     14.0   2.0     70.0   21.0   137.0 98 9 19   1 0     0   10   63 74     14 2   70 21   137
693574 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 2017   grade_2 98.0 1.0 1.0   1.0 0.0     0.0   0.0   52.0 49.0     0.0   0.0     48.0   8.0   101.0 98 1 1   1 0     0   0   52 49     0 0   48 8   101
693611 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 2017   kindergarten 98.0 25.0 14.0   2.0 0.0     0.0   6.0   78.0 67.0     8.0   1.0     58.0   9.0   145.0 98 25 14   2 0     0   6   78 67     8 1   58 9   145
694499 MN Scott 70 school 2730060 719 Independent Districts and Schools PRIOR LAKE-SAVAGE AREA SCHOOLS 273006003711 17 JEFFERS POND ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_4 98.0 0.0 3.0   5.0 8.0     0.0   4.0   56.0 62.0     2.0   0.0     4.0   15.0   118.0 98 0 3   5 8     0   4   56 62     2 0   4 15   118
694557 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 2017   grade_4 98.0 2.0 2.0   1.0 0.0     0.0   2.0   53.0 52.0     1.0   0.0     10.0   13.0   105.0 98 2 2   1 0     0   2   53 52     1 0   10 13   105
694586 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   grade_2 98.0 0.0 9.0   0.0 0.0     0.0   7.0   60.0 54.0     4.0   0.0     26.0   18.0   114.0 98 0 9   0 0     0   7   60 54     4 0   26 18   114
694612 MN Sherburne 71 school 2711370 728 Independent Districts and Schools ELK RIVER PUBLIC SCHOOL DISTRICT 271137003689 170 TWIN LAKES ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   kindergarten 98.0 6.0 3.0   1.0 0.0     0.0   9.0   64.0 53.0     5.0   *     18.0   14.0   117.0 98 6 3   1 0     0   9   64 53     5     18 14   117
694652 MN Stearns 73 school 2714190 738 Independent Districts and Schools HOLDINGFORD PUBLIC SCHOOL DISTRICT 271419000732 1 HOLDINGFORD ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_3 98.0 1.0 0.0   0.0 0.0     0.0   0.0   52.0 47.0     1.0   0.0     25.0   11.0   99.0 98 1 0   0 0     0   0   52 47     1 0   25 11   99
697718 MN Anoka 2 school 2712420 14 Independent Districts and Schools FRIDLEY PUBLIC SCHOOL DISTRICT 271242000610 23 FRIDLEY MIDDLE Middle School (Grades 5-8) Regular School No Middle 05 08 2017   grade_7 98.0 71.0 26.0   1.0 18.0     1.0   21.0   118.0 118.0     18.0   *     148.0   *   236.0 98 71 26   1 18     1   21   118 118     18     148     236
698069 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 2017   grade_7 98.0 1.0 15.0   0.0 0.0     0.0   0.0   59.0 55.0     4.0   0.0     39.0   18.0   114.0 98 1 15   0 0     0   0   59 55     4 0   39 18   114
698926 MN Hennepin 27 school 2725200 279 Independent Districts and Schools OSSEO PUBLIC SCHOOL DISTRICT 272520001221 88 PARK CENTER IB WORLD SCHOOL Senior High School (Grades 9-12) Regular School No High 09 12 2017   grade_9 98.0 192.0 54.0   4.0 149.0     0.0   12.0   256.0 253.0     85.0   9.0     349.0   64.0   509.0 98 192 54   4 149     0   12   256 253     85 9   349 64   509
698971 MN Houston 28 school 2717250 300 Independent Districts and Schools LA CRESCENT-HOKAH SCHOOL DISTRICT 271725000800 20 LA CRESCENT SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 09 12 2017   grade_9 98.0 2.0 1.0   0.0 2.0     0.0   2.0   46.0 59.0     0.0   0.0     16.0   17.0   105.0 98 2 1   0 2     0   2   46 59     0 0   16 17   105
699111 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 2017   grade_12 98.0 2.0 7.0   3.0 1.0     0.0   0.0   56.0 55.0     2.0   0.0     17.0   18.0   111.0 98 2 7   3 1     0   0   56 55     2 0   17 18   111
699479 MN Mcleod 43 school 2700128 2859 Independent Districts and Schools GLENCOE-SILVER LAKE SCHOOL DISTRICT 270012800630 60 GLENCOE-SILVER LAKE SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 09 12 2017   grade_12 98.0 1.0 19.0   1.0 1.0     0.0   1.0   55.0 66.0     0.0   0.0     21.0   11.0   121.0 98 1 19   1 1     0   1   55 66     0 0   21 11   121
699675 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 2017   grade_11 98.0 20.0 13.0   1.0 2.0     1.0   17.0   48.0 104.0     0.0   0.0     24.0   6.0   152.0 98 20 13   1 2     1   17   48 104     0 0   24 6   152
699132 MN Ramsey 62 school 2722950 621 Independent Districts and Schools MOUNDS VIEW PUBLIC SCHOOL DISTRICT 272295001118 65 IRONDALE SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 09 12 2017   pk_12_total 975.0 273.0 197.0   10.0 152.0     1.0   62.0   842.0 828.0     47.0   25.0     667.0   188.0   1670.0 975 273 197   10 152     1   62   842 828     47 25   667 188   1670
690669 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_3 97.0 15.0 4.0   0.0 7.0     0.0   10.0   68.0 65.0     19.0   3.0     41.0   18.0   133.0 97 15 4   0 7     0   10   68 65     19 3   41 18   133
690770 MN Anoka 2 school 2708100 12 Independent Districts and Schools CENTENNIAL PUBLIC SCHOOL DISTRICT 270810000022 513 RICE LAKE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_5 97.0 2.0 4.0   0.0 2.0     0.0   5.0   60.0 50.0     0.0   1.0     7.0   23.0   110.0 97 2 4   0 2     0   5   60 50     0 1   7 23   110
692097 MN Hennepin 27 school 2714260 270 Independent Districts and Schools HOPKINS PUBLIC SCHOOL DISTRICT 271426002206 566 EISENHOWER ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   pk_12_total 97.0 147.0 67.0   3.0 17.0     1.0   41.0   177.0 196.0     98.0   9.0     280.0   49.0   373.0 97 147 67   3 17     1   41   177 196     98 9   280 49   373
692291 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 2017   grade_2 97.0 0.0 3.0   0.0 4.0     0.0   4.0   56.0 52.0     1.0   0.0     3.0   5.0   108.0 97 0 3   0 4     0   4   56 52     1 0   3 5   108
692525 MN Hennepin 27 school 2731750 280 Independent Districts and Schools RICHFIELD PUBLIC SCHOOL DISTRICT 273175004212 705 RICHFIELD DUAL LANGUAGE SCHOOL Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   pk_12_total 97.0 14.0 291.0   0.0 4.0     0.0   21.0   190.0 237.0     214.0   5.0     264.0   43.0   427.0 97 14 291   0 4     0   21   190 237     214 5   264 43   427
694449 MN Scott 70 school 2704050 716 Independent Districts and Schools BELLE PLAINE PUBLIC SCHOOL DISTRICT 270405000183 10 CHATFIELD ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 02 2017   grade_2 97.0 1.0 8.0   1.0 0.0     0.0   4.0   59.0 52.0     1.0   0.0     23.0   11.0   111.0 97 1 8   1 0     0   4   59 52     1 0   23 11   111
694470 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_3 97.0 8.0 4.0   1.0 11.0     0.0   11.0   65.0 67.0     6.0   0.0     23.0   16.0   132.0 97 8 4   1 11     0   11   65 67     6 0   23 16   132
694471 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_4 97.0 5.0 10.0   1.0 12.0     0.0   11.0   72.0 64.0     5.0   0.0     28.0   12.0   136.0 97 5 10   1 12     0   11   72 64     5 0   28 12   136
694646 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 2017   grade_5 97.0 5.0 5.0   1.0 1.0     0.0   7.0   58.0 58.0     4.0   0.0     28.0   19.0   116.0 97 5 5   1 1     0   7   58 58     4 0   28 19   116
694969 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   grade_3 97.0 5.0 10.0   0.0 1.0     0.0   4.0   57.0 60.0     7.0   1.0     51.0   18.0   117.0 97 5 10   0 1     0   4   57 60     7 1   51 18   117
694991 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 KG 03 2017   grade_3 97.0 4.0 5.0   0.0 4.0     0.0   9.0   59.0 60.0     5.0   0.0     42.0   12.0   119.0 97 4 5   0 4     0   9   59 60     5 0   42 12   119
695939 MN Roseau 68 school 2700107 2683 Independent Districts and Schools GREENBUSH-MIDDLE RIVER SCHOOL DIST. 270010700920 10 GREENBUSH ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   pk_12_total 97.0 6.0 0.0   0.0 0.0     0.0   2.0   50.0 55.0     0.0   0.0     28.0   23.0   105.0 97 6 0   0 0     0   2   50 55     0 0   28 23   105
697000 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 2017   grade_3 97.0 1.0 7.0   2.0 2.0     0.0   7.0   53.0 63.0     0.0   0.0     14.0   9.0   116.0 97 1 7   2 2     0   7   53 63     0 0   14 9   116
697382 MN Hennepin 27 school 2700378 4208 Charter Schools NASHA SHKOLA CHARTER SCHOOL 270037804635 10 NASHA SHKOLA CHARTER SCHOOL Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2017   pk_12_total 97.0 2.0 0.0   0.0 0.0     0.0   2.0   54.0 47.0     68.0   0.0     69.0   0.0   101.0 97 2 0   0 0     0   2   54 47     68 0   69 0   101
697892 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 2017   grade_5 97.0 17.0 60.0   0.0 3.0     0.0   20.0   99.0 98.0     20.0   0.0     84.0   37.0   197.0 97 17 60   0 3     0   20   99 98     20 0   84 37   197
698056 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 2017   grade_8 97.0 17.0 24.0   0.0 15.0     0.0   4.0   84.0 73.0     18.0   4.0     71.0   21.0   157.0 97 17 24   0 15     0   4   84 73     18 4   71 21   157
698491 MN Douglas 21 school 2700382 2908 Independent Districts and Schools BRANDON-EVANSVILLE PUBLIC SCHOOLS 270038204740 3 Brandon-Evansville Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2017   pk_12_total 97.0 1.0 2.0   0.0 0.0     0.0   2.0   57.0 45.0     0.0   0.0     37.0   5.0   102.0 97 1 2   0 0     0   2   57 45     0 0   37 5   102
698492 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 2017   grade_5 97.0 13.0 4.0   3.0 6.0     0.0   6.0   63.0 66.0     2.0   1.0     28.0   19.0   129.0 97 13 4   3 6     0   6   63 66     2 1   28 19   129
698973 MN Houston 28 school 2717250 300 Independent Districts and Schools LA CRESCENT-HOKAH SCHOOL DISTRICT 271725000800 20 LA CRESCENT SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 09 12 2017   grade_11 97.0 3.0 0.0   0.0 2.0     0.0   2.0   59.0 45.0     0.0   0.0     15.0   19.0   104.0 97 3 0   0 2     0   2   59 45     0 0   15 19   104
699425 MN Rock 67 school 2718330 2184 Independent Districts and Schools LUVERNE PUBLIC SCHOOL DISTRICT 271833000852 4 LUVERNE SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 09 12 2017   grade_12 97.0 1.0 6.0   0.0 2.0     0.0   1.0   56.0 51.0     1.0   0.0     29.0   13.0   107.0 97 1 6   0 2     0   1   56 51     1 0   29 13   107
699764 MN Anoka 2 school 2733540 15 Independent Districts and Schools ST. FRANCIS PUBLIC SCHOOL DISTRICT 273354004980 18 Saints Academy Public Area Learning Center ALC (State approved) Alternative School No High 07 12 2017   pk_12_total 97.0 0.0 1.0   0.0 0.0     0.0   7.0   63.0 42.0     1.0   1.0     41.0   6.0   105.0 97 0 1   0 0     0   7   63 42     1 1   41 6   105
698888 MN Hennepin 27 school 2714260 270 Independent Districts and Schools HOPKINS PUBLIC SCHOOL DISTRICT 271426000613 282 HOPKINS SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 10 12 2017   pk_12_total 968.0 351.0 142.0   5.0 114.0     1.0   75.0   866.0 790.0     70.0   22.0     595.0   204.0   1656.0 968 351 142   5 114     1   75   866 790     70 22   595 204   1656
695405 MN Wright 86 school 2721390 882 Independent Districts and Schools MONTICELLO PUBLIC SCHOOL DISTRICT 272139001078 10 PINEWOOD ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   pk_12_total 962.0 10.0 60.0   1.0 8.0     0.0   36.0   579.0 498.0     34.0   5.0     295.0   135.0   1077.0 962 10 60   1 8     0   36   579 498     34 5   295 135   1077
689413 MN Lake 38 school 2740740 381 Independent Districts and Schools LAKE SUPERIOR PUBLIC SCHOOL DIST. 274074001701 200 TWO HARBORS SECONDARY Secondary School (Grades 7-12) Regular School No Other 06 12 2017   grade_12 96.0 0.0 0.0   1.0 1.0     0.0   2.0   54.0 46.0     0.0   0.0     15.0   21.0   100.0 96 0 0   1 1     0   2   54 46     0 0   15 21   100
689505 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_12 96.0 3.0 0.0   1.0 0.0     0.0   0.0   45.0 55.0     0.0   0.0     25.0   20.0   100.0 96 3 0   1 0     0   0   45 55     0 0   25 20   100
690823 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_2 96.0 1.0 7.0   0.0 0.0     0.0   7.0   53.0 58.0         0.0     27.0   *   111.0 96 1 7   0 0     0   7   53 58       0   27     111
691227 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_5 96.0 1.0 6.0   1.0 2.0     0.0   3.0   71.0 38.0     3.0   0.0     17.0   21.0   109.0 96 1 6   1 2     0   3   71 38     3 0   17 21   109
691285 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_4 96.0 6.0 7.0   0.0 6.0     0.0   10.0   68.0 57.0     7.0   0.0     23.0   22.0   125.0 96 6 7   0 6     0   10   68 57     7 0   23 22   125
691288 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 2017   kindergarten 96.0 0.0 8.0   0.0 5.0     0.0   7.0   56.0 60.0     7.0   0.0     15.0   8.0   116.0 96 0 8   0 5     0   7   56 60     7 0   15 8   116
691550 MN Dakota 19 school 2707290 191 Independent Districts and Schools BURNSVILLE PUBLIC SCHOOL DISTRICT 270729000302 489 SKY OAKS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   pk_12_total 96.0 169.0 183.0   1.0 33.0     0.0   33.0   267.0 248.0     143.0   9.0     375.0   82.0   515.0 96 169 183   1 33     0   33   267 248     143 9   375 82   515
692238 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   kindergarten 96.0 2.0 18.0   0.0 2.0     0.0   13.0   62.0 69.0     0.0   0.0     6.0   3.0   131.0 96 2 18   0 2     0   13   62 69     0 0   6 3   131
692483 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_5 96.0 14.0 6.0   1.0 6.0     1.0   9.0   65.0 68.0     5.0   0.0     24.0   19.0   133.0 96 14 6   1 6     1   9   65 68     5 0   24 19   133
693652 MN Ramsey 62 school 2722950 621 Independent Districts and Schools MOUNDS VIEW PUBLIC SCHOOL DISTRICT 272295001119 26 ISLAND LAKE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 01 05 2017   grade_1 96.0 10.0 6.0   0.0 19.0     0.0   8.0   75.0 64.0     8.0   1.0     26.0   17.0   139.0 96 10 6   0 19     0   8   75 64     8 1   26 17   139
694371 MN Saint Louis 69 school 2711040 709 Independent Districts and Schools DULUTH PUBLIC SCHOOL DISTRICT 271104000459 435 CONGDON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   kindergarten 96.0 6.0 3.0   0.0 3.0     0.0   4.0   51.0 61.0         3.0     20.0   6.0   112.0 96 6 3   0 3     0   4   51 61       3   20 6   112
694477 MN Scott 70 school 2730060 719 Independent Districts and Schools PRIOR LAKE-SAVAGE AREA SCHOOLS 273006001275 11 FIVE HAWKS EL. Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_3 96.0 5.0 2.0   0.0 2.0     0.0   4.0   55.0 54.0     7.0   1.0     18.0   11.0   109.0 96 5 2   0 2     0   4   55 54     7 1   18 11   109
694479 MN Scott 70 school 2730060 719 Independent Districts and Schools PRIOR LAKE-SAVAGE AREA SCHOOLS 273006001275 11 FIVE HAWKS EL. Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_5 96.0 4.0 5.0   0.0 3.0     0.0   3.0   57.0 54.0     3.0   0.0     15.0   14.0   111.0 96 4 5   0 3     0   3   57 54     3 0   15 14   111
694587 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   grade_3 96.0 2.0 10.0   1.0 2.0     0.0   8.0   64.0 55.0     5.0   0.0     25.0   18.0   119.0 96 2 10   1 2     0   8   64 55     5 0   25 18   119
694642 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 2017   grade_1 96.0 4.0 5.0   0.0 1.0     0.0   5.0   62.0 49.0     6.0   0.0     21.0   16.0   111.0 96 4 5   0 1     0   5   62 49     6 0   21 16   111
694695 MN Stearns 73 school 2733510 742 Independent Districts and Schools ST. CLOUD PUBLIC SCHOOL DISTRICT 273351001485 25 KENNEDY COMMUNITY SCHOOL Elementary School (Grades PK-6) Regular School No Elementary PK 08 2017   grade_5 96.0 11.0 3.0   0.0 1.0     0.0   3.0   68.0 46.0     7.0   1.0     43.0   19.0   114.0 96 11 3   0 1     0   3   68 46     7 1   43 19   114
694973 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 Elementary 04 06 2017   grade_5 96.0 4.0 19.0   0.0 3.0     1.0   5.0   69.0 59.0     8.0   1.0     47.0   20.0   128.0 96 4 19   0 3     1   5   69 59     8 1   47 20   128
695020 MN Washington 82 school 2712270 831 Independent Districts and Schools FOREST LAKE PUBLIC SCHOOL DISTRICT 271227000601 631 Wyoming Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_3 96.0 1.0 1.0   0.0 0.0     0.0   1.0   49.0 50.0     0.0   0.0     20.0   10.0   99.0 96 1 1   0 0     0   1   49 50     0 0   20 10   99
695062 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   kindergarten 96.0 4.0 7.0   0.0 5.0     0.0   6.0   63.0 55.0     5.0   0.0     20.0   18.0   118.0 96 4 7   0 5     0   6   63 55     5 0   20 18   118
695611 MN Pope 61 school 2700019 2149 Independent Districts and Schools MINNEWASKA SCHOOL DISTRICT 270001903536 70 MINNEWASKA AREA ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 03 2017   grade_3 96.0 3.0 1.0   0.0 0.0     0.0   2.0   55.0 47.0         *         *   102.0 96 3 1   0 0     0   2   55 47                 102

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