Data source: Big Local News · About: Big Local

13,757 rows where state = "MN" and year = 2017 sorted by multiracial 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
697733 MN Becker 3 school 2710230 22 Independent Districts and Schools DETROIT LAKES PUBLIC SCHOOL DIST. 271023000443 4 DETROIT LAKES MIDDLE Middle School (Grades 5-8) Regular School No Middle 05 08 2017   pk_12_total 599.0 16.0 21.0   70.0 11.0     0.0   99.0   428.0 388.0     2.0   6.0     313.0   165.0   816.0 599 16 21   70 11     0   99   428 388     2 6   313 165   816
691170 MN Carlton 9 school 2709420 94 Independent Districts and Schools CLOQUET PUBLIC SCHOOL DISTRICT 270942000384 105 WASHINGTON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   pk_12_total 464.0 1.0 8.0   67.0 1.0     1.0   96.0   335.0 303.0     1.0   9.0     292.0   98.0   638.0 464 1 8   67 1     1   96   335 303     1 9   292 98   638
692500 MN Hennepin 27 school 2731750 280 Independent Districts and Schools RICHFIELD PUBLIC SCHOOL DISTRICT 273175001312 36 RICHFIELD STEM SCHOOL Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   pk_12_total 300.0 123.0 201.0   8.0 56.0     2.0   95.0   435.0 350.0     191.0   12.0     446.0   93.0   785.0 300 123 201   8 56     2   95   435 350     191 12   446 93   785
698930 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   pk_12_total 343.0 705.0 234.0   10.0 656.0     0.0   94.0   1038.0 1004.0     239.0   31.0     1353.0   255.0   2042.0 343 705 234   10 656     0   94   1038 1004     239 31   1353 255   2042
699147 MN Ramsey 62 school 2732430 623 Independent Districts and Schools ROSEVILLE PUBLIC SCHOOL DISTRICT 273243001385 69 ROSEVILLE AREA SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 09 12 2017   pk_12_total 1146.0 354.0 236.0   11.0 446.0     0.0   94.0   1121.0 1166.0     200.0   14.0     960.0   270.0   2287.0 1146 354 236   11 446     0   94   1121 1166     200 14   960 270   2287
692703 MN Hennepin 27 school 2706240 286 Independent Districts and Schools BROOKLYN CENTER SCHOOL DISTRICT 270624000274 480 EARLE BROWN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   pk_12_total 133.0 437.0 267.0   7.0 170.0     0.0   92.0   559.0 547.0     261.0   22.0     881.0   129.0   1106.0 133 437 267   7 170     0   92   559 547     261 22   881 129   1106
697987 MN Hennepin 27 school 2725200 279 Independent Districts and Schools OSSEO PUBLIC SCHOOL DISTRICT 272520002278 94 Maple Grove Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2017   pk_12_total 1131.0 206.0 113.0   4.0 143.0     1.0   92.0   813.0 877.0     59.0   11.0     401.0   145.0   1690.0 1131 206 113   4 143     1   92   813 877     59 11   401 145   1690
691727 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239001376 711 GREENLEAF ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   pk_12_total 523.0 110.0 185.0   5.0 45.0     2.0   91.0   483.0 478.0     173.0   4.0     363.0   113.0   961.0 523 110 185   5 45     2   91   483 478     173 4   363 113   961
697810 MN Clay 14 school 2721420 152 Independent Districts and Schools MOORHEAD PUBLIC SCHOOL DISTRICT 272142003512 380 HORIZON MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 06 08 2017   pk_12_total 1027.0 97.0 121.0   41.0 10.0     1.0   91.0   712.0 676.0     77.0   12.0     562.0   206.0   1388.0 1027 97 121   41 10     1   91   712 676     77 12   562 206   1388
698950 MN Hennepin 27 school 2731780 281 Independent Districts and Schools ROBBINSDALE PUBLIC SCHOOL DISTRICT 273178001318 53 ROBBINSDALE ARMSTRONG SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 09 12 2017   pk_12_total 1125.0 415.0 213.0   15.0 122.0     1.0   91.0   1001.0 981.0     57.0   25.0     708.0   225.0   1982.0 1125 415 213   15 122     1   91   1001 981     57 25   708 225   1982
694430 MN Saint Louis 69 school 2711040 709 Independent Districts and Schools DULUTH PUBLIC SCHOOL DISTRICT 271104000482 550 PIEDMONT ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   pk_12_total 370.0 50.0 14.0   27.0 8.0     0.0   90.0   286.0 273.0     3.0   13.0     331.0   96.0   559.0 370 50 14   27 8     0   90   286 273     3 13   331 96   559
689284 MN Houston 28 school 2714280 294 Independent Districts and Schools HOUSTON PUBLIC SCHOOL DISTRICT 271428000749 20 HOUSTON SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   pk_12_total 185.0 2.0 2.0   0.0 2.0     0.0   9.0   106.0 94.0     0.0   0.0     75.0   28.0   200.0 185 2 2   0 2     0   9   106 94     0 0   75 28   200
689315 MN Itasca 31 school 2710140 317 Independent Districts and Schools DEER RIVER PUBLIC SCHOOL DISTRICT 271014000433 1 DEER RIVER SECONDARY Secondary School (Grades 7-12) Regular School No Other 06 12 2017   grade_8 31.0 0.0 3.0   22.0 0.0     0.0   9.0   32.0 33.0     0.0   *     42.0   13.0   65.0 31 0 3   22 0     0   9   32 33     0     42 13   65
689687 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   grade_8 18.0 86.0 37.0   1.0 201.0     0.0   9.0   184.0 168.0     179.0   3.0     315.0   41.0   352.0 18 86 37   1 201     0   9   184 168     179 3   315 41   352
689760 MN Saint Louis 69 school 2741040 706 Independent Districts and Schools VIRGINIA PUBLIC SCHOOL DISTRICT 274104001718 90 VIRGINIA SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   grade_10 109.0 1.0 1.0   4.0 1.0     0.0   9.0   61.0 64.0     0.0   1.0     37.0   16.0   125.0 109 1 1   4 1     0   9   61 64     0 1   37 16   125
689945 MN Wright 86 school 2718810 881 Independent Districts and Schools MAPLE LAKE PUBLIC SCHOOL DISTRICT 271881000886 20 MAPLE LAKE SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   pk_12_total 433.0 3.0 1.0   1.0 1.0     5.0   9.0   223.0 230.0     0.0   0.0     87.0   66.0   453.0 433 3 1   1 1     5   9   223 230     0 0   87 66   453
690192 MN Todd 77 school 2700109 2753 Independent Districts and Schools Long Prairie-Grey Eagle School District 270010900850 20 LONG PRAIRIE-GREY SECONDARY SCHOOL Secondary School (Grades 7-12) Regular School No High 07 12 2017   pk_12_total 260.0 0.0 128.0   2.0 7.0     5.0   9.0   212.0 199.0     26.0   5.0     207.0   66.0   411.0 260 0 128   2 7     5   9   212 199     26 5   207 66   411
690272 MN Becker 3 school 2700162 2889 Independent Districts and Schools LAKE PARK AUDUBON SCHOOL DISTRICT 270016200812 20 LAKE PARK AUDUBON SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   pk_12_total 277.0 1.0 7.0   6.0 2.0     0.0   9.0   164.0 138.0     0.0   0.0     77.0   34.0   302.0 277 1 7   6 2     0   9   164 138     0 0   77 34   302
690603 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000107 405 HOOVER ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   kindergarten 54.0 14.0 4.0   1.0 7.0     0.0   9.0   37.0 52.0     7.0   *     45.0   14.0   89.0 54 14 4   1 7     0   9   37 52     7     45 14   89
690614 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_4 76.0 18.0 15.0   2.0 10.0     0.0   9.0   70.0 60.0     6.0   1.0     54.0   32.0   130.0 76 18 15   2 10     0   9   70 60     6 1   54 32   130
690652 MN Hennepin 27 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000116 413 MONROE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   kindergarten 29.0 26.0 2.0   0.0 25.0     0.0   9.0   48.0 43.0     25.0   0.0     46.0   16.0   91.0 29 26 2   0 25     0   9   48 43     25 0   46 16   91
690673 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000126 418 UNIVERSITY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   kindergarten 53.0 15.0 4.0   0.0 11.0     0.0   9.0   50.0 42.0     13.0   1.0     51.0   15.0   92.0 53 15 4   0 11     0   9   50 42     13 1   51 15   92
690675 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000126 418 UNIVERSITY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_2 66.0 20.0 6.0   0.0 4.0     0.0   9.0   56.0 49.0     12.0   4.0     57.0   12.0   105.0 66 20 6   0 4     0   9   56 49     12 4   57 12   105
690678 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000126 418 UNIVERSITY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_5 56.0 25.0 7.0   1.0 9.0     0.0   9.0   50.0 57.0     6.0   0.0     59.0   15.0   107.0 56 25 7   1 9     0   9   50 57     6 0   59 15   107
690703 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000120 423 RAMSEY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_1 160.0 17.0 11.0   1.0 6.0     0.0   9.0   116.0 88.0     14.0   4.0     51.0   30.0   204.0 160 17 11   1 6     0   9   116 88     14 4   51 30   204
690705 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000120 423 RAMSEY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_3 194.0 23.0 5.0   1.0 7.0     0.0   9.0   140.0 99.0     17.0   4.0     70.0   41.0   239.0 194 23 5   1 7     0   9   140 99     17 4   70 41   239
690742 MN Hennepin 27 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318004406 430 CHAMPLIN/BROOKLYN PK ACD MATH ENSCI Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_5 110.0 21.0 8.0   1.0 14.0     0.0   9.0   81.0 82.0     6.0   1.0     50.0   25.0   163.0 110 21 8   1 14     0   9   81 82     6 1   50 25   163
690780 MN Anoka 2 school 2709510 13 Independent Districts and Schools COLUMBIA HEIGHTS PUBLIC SCHOOL DIST 270951000398 515 HIGHLAND ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   pre_kindergarten 18.0 11.0 7.0   1.0 2.0     0.0   9.0   25.0 23.0     0.0   *         0.0   48.0 18 11 7   1 2     0   9   25 23     0       0   48
690808 MN Anoka 2 school 2712420 14 Independent Districts and Schools FRIDLEY PUBLIC SCHOOL DISTRICT 271242000612 546 HAYES ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2017   grade_1 52.0 34.0 8.0   1.0 13.0     0.0   9.0   65.0 52.0     29.0   2.0     62.0   9.0   117.0 52 34 8   1 13     0   9   65 52     29 2   62 9   117
690825 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_4 88.0 3.0 7.0   0.0 1.0     0.0   9.0   63.0 45.0     3.0   *     32.0   *   108.0 88 3 7   0 1     0   9   63 45     3     32     108
690852 MN Anoka 2 school 2733330 16 Independent Districts and Schools SPRING LAKE PARK PUBLIC SCHOOLS 273333001467 774 Woodcrest Elementary Spanish Immersion Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_2 54.0 3.0 41.0   0.0 1.0     0.0   9.0   43.0 65.0     26.0   0.0     35.0   6.0   108.0 54 3 41   0 1     0   9   43 65     26 0   35 6   108
690879 MN Becker 3 school 2710230 22 Independent Districts and Schools DETROIT LAKES PUBLIC SCHOOL DIST. 271023002268 60 ROOSEVELT ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2017   grade_2 87.0 2.0 9.0   15.0 0.0     0.0   9.0   58.0 64.0     2.0   5.0     70.0   20.0   122.0 87 2 9   15 0     0   9   58 64     2 5   70 20   122
690889 MN Becker 3 school 2712360 23 Independent Districts and Schools FRAZEE-VERGAS PUBLIC SCHOOL DIST. 271236000607 10 FRAZEE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_5 61.0 0.0 4.0   3.0 0.0     0.0   9.0   38.0 39.0     0.0   2.0     43.0   15.0   77.0 61 0 4   3 0     0   9   38 39     0 2   43 15   77
690916 MN Beltrami 4 school 2704440 31 Independent Districts and Schools BEMIDJI PUBLIC SCHOOL DISTRICT 270444000196 40 J.W. SMITH ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_4 22.0 6.0 3.0   12.0 0.0     0.0   9.0   25.0 27.0         2.0     41.0   7.0   52.0 22 6 3   12 0     0   9   25 27       2   41 7   52
691076 MN Nicollet 52 school 2718780 77 Independent Districts and Schools MANKATO PUBLIC SCHOOL DISTRICT 271878002977 60 BRIDGES COMMUNITY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   pk_12_total 161.0 1.0 4.0   0.0 12.0     0.0   9.0   92.0 95.0     1.0   0.0     27.0   12.0   187.0 161 1 4   0 12     0   9   92 95     1 0   27 12   187
691078 MN Blue Earth 7 school 2718780 77 Independent Districts and Schools MANKATO PUBLIC SCHOOL DISTRICT 271878004388 70 ROSA PARKS ELEMENTARY SCHOOL Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_1 46.0 16.0 6.0   1.0 5.0     0.0   9.0   45.0 38.0     14.0   2.0     38.0   13.0   83.0 46 16 6   1 5     0   9   45 38     14 2   38 13   83
691155 MN Carlton 9 school 2707590 93 Independent Districts and Schools CARLTON PUBLIC SCHOOL DISTRICT 270759000328 2 SOUTH TERRACE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   pk_12_total 166.0 2.0 2.0   26.0 0.0     0.0   9.0   103.0 102.0     0.0   *         *   205.0 166 2 2   26 0     0   9   103 102     0           205
691261 MN Carver 10 school 2708190 112 Independent Districts and Schools EASTERN CARVER COUNTY PUBLIC SCHOOL 270819000342 506 CHANHASSEN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_2 66.0 2.0 8.0   0.0 5.0     0.0   9.0   49.0 41.0     5.0   0.0     15.0   10.0   90.0 66 2 8   0 5     0   9   49 41     5 0   15 10   90
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
691300 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   grade_5 85.0 4.0 4.0   0.0 5.0     0.0   9.0   59.0 48.0         0.0     23.0   17.0   107.0 85 4 4   0 5     0   9   59 48       0   23 17   107
691338 MN Chippewa 12 school 2721320 129 Independent Districts and Schools MONTEVIDEO PUBLIC SCHOOL DISTRICT 272132001073 10 RAMSEY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 01 03 2017   pk_12_total 246.0 6.0 61.0   5.0 0.0     1.0   9.0   173.0 155.0     46.0   0.0     168.0   72.0   328.0 246 6 61   5 0     1   9   173 155     46 0   168 72   328
691406 MN Clearwater 15 school 2703570 162 Independent Districts and Schools BAGLEY PUBLIC SCHOOL DISTRICT 270357000164 10 BAGLEY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_2 63.0 4.0 1.0   15.0 0.0     0.0   9.0   50.0 42.0     0.0   0.0     51.0   9.0   92.0 63 4 1   15 0     0   9   50 42     0 0   51 9   92
691408 MN Clearwater 15 school 2703570 162 Independent Districts and Schools BAGLEY PUBLIC SCHOOL DISTRICT 270357000164 10 BAGLEY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_4 74.0 2.0 0.0   17.0 1.0     0.0   9.0   43.0 60.0     0.0   0.0     58.0   13.0   103.0 74 2 0   17 1     0   9   43 60     0 0   58 13   103
691508 MN Scott 70 school 2707290 191 Independent Districts and Schools BURNSVILLE PUBLIC SCHOOL DISTRICT 270729000300 484 M.W. SAVAGE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_3 20.0 15.0 7.0   0.0 10.0     0.0   9.0   26.0 35.0     22.0   *     40.0   6.0   61.0 20 15 7   0 10     0   9   26 35     22     40 6   61
691510 MN Scott 70 school 2707290 191 Independent Districts and Schools BURNSVILLE PUBLIC SCHOOL DISTRICT 270729000300 484 M.W. SAVAGE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_5 22.0 10.0 10.0   0.0 6.0     0.0   9.0   27.0 30.0     5.0   3.0     25.0   12.0   57.0 22 10 10   0 6     0   9   27 30     5 3   25 12   57
691577 MN Dakota 19 school 2711820 192 Independent Districts and Schools FARMINGTON PUBLIC SCHOOL DISTRICT 271182002642 40 NORTH TRAIL ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_1 65.0 2.0 3.0   0.0 7.0     0.0   9.0   49.0 37.0     6.0   0.0     9.0   *   86.0 65 2 3   0 7     0   9   49 37     6 0   9     86
691617 MN Dakota 19 school 2717780 194 Independent Districts and Schools LAKEVILLE PUBLIC SCHOOL DISTRICT 271778000815 591 KENNEDY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_3 86.0 2.0 4.0   0.0 6.0     0.0   9.0   59.0 48.0     5.0   *     14.0   15.0   107.0 86 2 4   0 6     0   9   59 48     5     14 15   107
691656 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   kindergarten 81.0 0.0 2.0   0.0 6.0     1.0   9.0   41.0 58.0     2.0   *         *   99.0 81 0 2   0 6     1   9   41 58     2           99
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
691681 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_2 84.0 7.0 11.0   0.0 7.0     0.0   9.0   61.0 57.0     6.0   0.0     18.0   7.0   118.0 84 7 11   0 7     0   9   61 57     6 0   18 7   118
691728 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239001374 712 Cedar Park Elementary School of Science, Technology, Engineering and Math Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   kindergarten 43.0 28.0 16.0   2.0 10.0     0.0   9.0   61.0 47.0     24.0   0.0     51.0   12.0   108.0 43 28 16   2 10     0   9   61 47     24 0   51 12   108
691745 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239001942 714 Echo Park Elementary School of Leadership, Engineering and Technology Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_1 45.0 33.0 23.0   1.0 3.0     0.0   9.0   60.0 54.0     36.0   *     67.0   13.0   114.0 45 33 23   1 3     0   9   60 54     36     67 13   114
691765 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239002216 717 WOODLAND ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   kindergarten 85.0 1.0 6.0   1.0 10.0     0.0   9.0   61.0 51.0     5.0   *     13.0   13.0   112.0 85 1 6   1 10     0   9   61 51     5     13 13   112
691784 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239002283 719 SHANNON PARK ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_5 134.0 5.0 7.0   0.0 16.0     0.0   9.0   84.0 87.0     5.0   0.0     11.0   23.0   171.0 134 5 7   0 16     0   9   84 87     5 0   11 23   171
691786 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239002302 720 Oak Ridge Elementary School of Leadership, Environmental and Health Sciences Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   kindergarten 44.0 32.0 5.0   1.0 3.0     0.0   9.0   46.0 48.0     22.0   0.0     43.0   13.0   94.0 44 32 5   1 3     0   9   46 48     22 0   43 13   94
691791 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239002302 720 Oak Ridge Elementary School of Leadership, Environmental and Health Sciences Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_5 36.0 28.0 10.0   1.0 13.0     0.0   9.0   48.0 49.0     5.0   1.0     42.0   14.0   97.0 36 28 10   1 13     0   9   48 49     5 1   42 14   97
691798 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239000512 764 Glacier Hills Elementary School of Arts and Science Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_5 64.0 18.0 12.0   1.0 31.0     0.0   9.0   64.0 71.0     16.0   0.0     27.0   11.0   135.0 64 18 12   1 31     0   9   64 71     16 0   27 11   135
691805 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239002519 765 RED PINE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_5 128.0 7.0 13.0   1.0 10.0     0.0   9.0   91.0 77.0     5.0   0.0     21.0   17.0   168.0 128 7 13   1 10     0   9   91 77     5 0   21 17   168
691813 MN Dakota 19 school 2742270 197 Independent Districts and Schools WEST ST. PAUL-MENDOTA HTS.-EAGAN 274227002202 816 MENDOTA ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2017   kindergarten 55.0 9.0 9.0   0.0 2.0     0.0   9.0   46.0 38.0     8.0   0.0         10.0   84.0 55 9 9   0 2     0   9   46 38     8 0     10   84
691833 MN Dakota 19 school 2742270 197 Independent Districts and Schools WEST ST. PAUL-MENDOTA HTS.-EAGAN 274227001778 820 PILOT KNOB STEM MAGNET SCHOOL Elementary School (Grades PK-6) Regular School No Elementary KG 04 2017   grade_2 31.0 23.0 3.0   1.0 9.0     0.0   9.0   36.0 40.0     14.0   0.0     29.0   5.0   76.0 31 23 3   1 9     0   9   36 40     14 0   29 5   76
691871 MN Dakota 19 school 2713530 200 Independent Districts and Schools HASTINGS PUBLIC SCHOOL DISTRICT 271353000696 610 PINECREST ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 04 2017   grade_2 103.0 1.0 2.0   2.0 0.0     0.0   9.0   51.0 66.0     2.0   0.0     36.0   11.0   117.0 103 1 2   2 0     0   9   51 66     2 0   36 11   117
691875 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   kindergarten 79.0 2.0 4.0   0.0 0.0     1.0   9.0   50.0 45.0     5.0   1.0     27.0   18.0   95.0 79 2 4   0 0     1   9   50 45     5 1   27 18   95
691888 MN Dodge 20 school 2713590 203 Independent Districts and Schools HAYFIELD PUBLIC SCHOOL DISTRICT 271359000701 3 HAYFIELD ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   pk_12_total 272.0 3.0 20.0   1.0 0.0     1.0   9.0   161.0 145.0     0.0   3.0     111.0   54.0   306.0 272 3 20   1 0     1   9   161 145     0 3   111 54   306
691890 MN Dodge 20 school 2716980 204 Independent Districts and Schools KASSON-MANTORVILLE SCHOOL DISTRICT 271698000783 10 KASSON-MANTORVILLE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2017   kindergarten 160.0 0.0 10.0   1.0 2.0     0.0   9.0   84.0 98.0     6.0   0.0     33.0   22.0   182.0 160 0 10   1 2     0   9   84 98     6 0   33 22   182
692048 MN Goodhue 25 school 2728950 255 Independent Districts and Schools PINE ISLAND PUBLIC SCHOOL DIST. 272895001257 10 PINE ISLAND ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2017   pk_12_total 479.0 11.0 20.0   0.0 4.0     0.0   9.0   268.0 255.0     0.0   3.0     112.0   71.0   523.0 479 11 20   0 4     0   9   268 255     0 3   112 71   523
692054 MN Goodhue 25 school 2730480 256 Independent Districts and Schools RED WING PUBLIC SCHOOL DISTRICT 273048001297 541 SUNNYSIDE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 02 2017   grade_1 146.0 6.0 12.0   5.0 0.0     0.0   9.0   78.0 100.0     4.0   6.0     71.0   28.0   178.0 146 6 12   5 0     0   9   78 100     4 6   71 28   178
692128 MN Hennepin 27 school 2714260 270 Independent Districts and Schools HOPKINS PUBLIC SCHOOL DISTRICT 271426001884 570 MEADOWBROOK ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_6 51.0 9.0 3.0   2.0 6.0     0.0   9.0   39.0 41.0     4.0   0.0     12.0   8.0   80.0 51 9 3   2 6     0   9   39 41     4 0   12 8   80
692134 MN Hennepin 27 school 2705790 271 Independent Districts and Schools BLOOMINGTON PUBLIC SCHOOL DISTRICT 270579000640 432 WASHBURN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_2 27.0 20.0 14.0   0.0 4.0     0.0   9.0   30.0 44.0     19.0   *     46.0   5.0   74.0 27 20 14   0 4     0   9   30 44     19     46 5   74
692136 MN Hennepin 27 school 2705790 271 Independent Districts and Schools BLOOMINGTON PUBLIC SCHOOL DISTRICT 270579000640 432 WASHBURN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_4 18.0 24.0 21.0   0.0 4.0     0.0   9.0   43.0 33.0     20.0   0.0     54.0   16.0   76.0 18 24 21   0 4     0   9   43 33     20 0   54 16   76
692141 MN Hennepin 27 school 2705790 271 Independent Districts and Schools BLOOMINGTON PUBLIC SCHOOL DISTRICT 270579002292 443 HILLCREST ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_2 52.0 6.0 3.0   0.0 3.0     0.0   9.0   33.0 40.0         0.0         6.0   73.0 52 6 3   0 3     0   9   33 40       0     6   73
692171 MN Hennepin 27 school 2705790 271 Independent Districts and Schools BLOOMINGTON PUBLIC SCHOOL DISTRICT 270579000225 450 NORMANDALE HILLS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_2 49.0 15.0 10.0   0.0 6.0     0.0   9.0   45.0 44.0     16.0   0.0     34.0   12.0   89.0 49 15 10   0 6     0   9   45 44     16 0   34 12   89
692185 MN Hennepin 27 school 2705790 271 Independent Districts and Schools BLOOMINGTON PUBLIC SCHOOL DISTRICT 270579000234 455 RIDGEVIEW ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_2 41.0 5.0 3.0   0.0 6.0     0.0   9.0   31.0 33.0     5.0   1.0     14.0   13.0   64.0 41 5 3   0 6     0   9   31 33     5 1   14 13   64
692236 MN Hennepin 27 school 2714220 272 Independent Districts and Schools EDEN PRAIRIE PUBLIC SCHOOL DISTRICT 271422002197 883 EDEN LAKE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 06 2017   grade_6 84.0 22.0 10.0   0.0 21.0     0.0   9.0   71.0 75.0     7.0   2.0     35.0   14.0   146.0 84 22 10   0 21     0   9   71 75     7 2   35 14   146
692240 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_2 103.0 3.0 15.0   0.0 6.0     0.0   9.0   67.0 69.0     3.0   0.0     8.0   10.0   136.0 103 3 15   0 6     0   9   67 69     3 0   8 10   136
692241 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_3 84.0 2.0 9.0   0.0 7.0     0.0   9.0   55.0 56.0     0.0   0.0     11.0   4.0   111.0 84 2 9   0 7     0   9   55 56     0 0   11 4   111
692252 MN Hennepin 27 school 2714220 272 Independent Districts and Schools EDEN PRAIRIE PUBLIC SCHOOL DISTRICT 271422002241 887 CEDAR RIDGE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 06 2017   grade_6 64.0 13.0 11.0   0.0 12.0     0.0   9.0   61.0 48.0     4.0   0.0     20.0   20.0   109.0 64 13 11   0 12     0   9   61 48     4 0   20 20   109
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
692296 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   kindergarten 161.0 5.0 7.0   0.0 2.0     0.0   9.0   95.0 89.0     6.0   0.0     8.0   11.0   184.0 161 5 7   0 2     0   9   95 89     6 0   8 11   184
692334 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 2017   grade_3 116.0 1.0 2.0   0.0 16.0     0.0   9.0   68.0 76.0     4.0   0.0     11.0   16.0   144.0 116 1 2   0 16     0   9   68 76     4 0   11 16   144
692354 MN Hennepin 27 school 2725080 278 Independent Districts and Schools ORONO PUBLIC SCHOOL DISTRICT 272508003444 662 ORONO INTERMEDIATE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 03 05 2017   grade_3 157.0 2.0 17.0   1.0 3.0     0.0   9.0   97.0 92.0     12.0   0.0     16.0   12.0   189.0 157 2 17   1 3     0   9   97 92     12 0   16 12   189
692369 MN Hennepin 27 school 2725200 279 Independent Districts and Schools OSSEO PUBLIC SCHOOL DISTRICT 272520002211 668 EDINBROOK ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_2 14.0 41.0 8.0   1.0 40.0     1.0   9.0   55.0 59.0     32.0   0.0     79.0   11.0   114.0 14 41 8   1 40     1   9   55 59     32 0   79 11   114
692374 MN Hennepin 27 school 2725200 279 Independent Districts and Schools OSSEO PUBLIC SCHOOL DISTRICT 272520002522 669 RUSH CREEK ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   kindergarten 113.0 7.0 4.0   1.0 8.0     0.0   9.0   76.0 66.0     3.0   *         14.0   142.0 113 7 4   1 8     0   9   76 66     3       14   142
692392 MN Hennepin 27 school 2725200 279 Independent Districts and Schools OSSEO PUBLIC SCHOOL DISTRICT 272520001207 671 BIRCH GROVE SCHOOL FOR THE ARTS Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_3 18.0 17.0 7.0   0.0 20.0     0.0   9.0   23.0 48.0     16.0   2.0     45.0   8.0   71.0 18 17 7   0 20     0   9   23 48     16 2   45 8   71
692458 MN Hennepin 27 school 2725200 279 Independent Districts and Schools OSSEO PUBLIC SCHOOL DISTRICT 272520001209 682 CEDAR ISLAND ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_1 58.0 11.0 5.0   0.0 3.0     0.0   9.0   45.0 41.0     7.0   2.0     22.0   16.0   86.0 58 11 5   0 3     0   9   45 41     7 2   22 16   86
692465 MN Hennepin 27 school 2725200 279 Independent Districts and Schools OSSEO PUBLIC SCHOOL DISTRICT 272520001939 684 ELM CREEK ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_1 64.0 8.0 4.0   0.0 4.0     0.0   9.0   45.0 44.0     5.0   1.0     25.0   10.0   89.0 64 8 4   0 4     0   9   45 44     5 1   25 10   89
692482 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_4 90.0 13.0 4.0   2.0 7.0     0.0   9.0   66.0 59.0     2.0   0.0     34.0   26.0   125.0 90 13 4   2 7     0   9   66 59     2 0   34 26   125
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
692506 MN Hennepin 27 school 2731750 280 Independent Districts and Schools RICHFIELD PUBLIC SCHOOL DISTRICT 273175001311 695 CENTENNIAL ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_3 8.0 17.0 46.0   0.0 2.0     0.0   9.0   51.0 31.0     41.0   2.0         4.0   82.0 8 17 46   0 2     0   9   51 31     41 2     4   82
692507 MN Hennepin 27 school 2731750 280 Independent Districts and Schools RICHFIELD PUBLIC SCHOOL DISTRICT 273175001311 695 CENTENNIAL ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_4 12.0 17.0 39.0   5.0 4.0     0.0   9.0   45.0 41.0         3.0     72.0   19.0   86.0 12 17 39   5 4     0   9   45 41       3   72 19   86
692512 MN Hennepin 27 school 2731750 280 Independent Districts and Schools RICHFIELD PUBLIC SCHOOL DISTRICT 273175001316 701 SHERIDAN HILLS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   kindergarten 22.0 17.0 20.0   0.0 7.0     0.0   9.0   42.0 33.0         0.0     44.0   9.0   75.0 22 17 20   0 7     0   9   42 33       0   44 9   75
692513 MN Hennepin 27 school 2731750 280 Independent Districts and Schools RICHFIELD PUBLIC SCHOOL DISTRICT 273175001316 701 SHERIDAN HILLS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_1 26.0 21.0 15.0   2.0 8.0     2.0   9.0   46.0 37.0     34.0   0.0     51.0   12.0   83.0 26 21 15   2 8     2   9   46 37     34 0   51 12   83
692527 MN Hennepin 27 school 2731780 281 Independent Districts and Schools ROBBINSDALE PUBLIC SCHOOL DISTRICT 273178001321 4 FOREST ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_1 37.0 26.0 17.0   0.0 5.0     0.0   9.0   56.0 38.0     13.0   0.0     52.0   10.0   94.0 37 26 17   0 5     0   9   56 38     13 0   52 10   94
692533 MN Hennepin 27 school 2731780 281 Independent Districts and Schools ROBBINSDALE PUBLIC SCHOOL DISTRICT 273178001323 6 LAKEVIEW ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   kindergarten 21.0 27.0 6.0   0.0 3.0     0.0   9.0   34.0 32.0     9.0   2.0     48.0   5.0   66.0 21 27 6   0 3     0   9   34 32     9 2   48 5   66
692582 MN Hennepin 27 school 2731780 281 Independent Districts and Schools ROBBINSDALE PUBLIC SCHOOL DISTRICT 273178001337 22 SONNESYN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   kindergarten 24.0 23.0 9.0   1.0 4.0     0.0   9.0   42.0 28.0     9.0   3.0     46.0   *   70.0 24 23 9   1 4     0   9   42 28     9 3   46     70
692592 MN Hennepin 27 school 2731780 281 Independent Districts and Schools ROBBINSDALE PUBLIC SCHOOL DISTRICT 273178001339 30 ZACHARY LANE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_3 56.0 11.0 6.0   0.0 12.0     0.0   9.0   44.0 50.0     7.0   2.0     22.0   5.0   94.0 56 11 6   0 12     0   9   44 50     7 2   22 5   94
692611 MN Hennepin 27 school 2733780 283 Independent Districts and Schools ST. LOUIS PARK PUBLIC SCHOOL DIST. 273378001525 745 AQUILA ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   kindergarten 43.0 20.0 6.0   1.0 2.0     0.0   9.0   46.0 35.0     18.0   *     30.0   *   81.0 43 20 6   1 2     0   9   46 35     18     30     81
692649 MN Hennepin 27 school 2742160 284 Independent Districts and Schools WAYZATA PUBLIC SCHOOL DISTRICT 274216001759 804 BIRCHVIEW ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_3 37.0 12.0 4.0   0.0 13.0     0.0   9.0   31.0 44.0     4.0   0.0     25.0   6.0   75.0 37 12 4   0 13     0   9   31 44     4 0   25 6   75
692653 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   kindergarten 77.0 2.0 6.0   0.0 24.0     0.0   9.0   63.0 55.0     2.0   2.0     8.0   5.0   118.0 77 2 6   0 24     0   9   63 55     2 2   8 5   118
692657 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_4 76.0 8.0 4.0   0.0 37.0     0.0   9.0   68.0 66.0     0.0   0.0     10.0   6.0   134.0 76 8 4   0 37     0   9   68 66     0 0   10 6   134
692668 MN Hennepin 27 school 2742160 284 Independent Districts and Schools WAYZATA PUBLIC SCHOOL DISTRICT 274216001763 808 SUNSET HILL ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_1 63.0 9.0 6.0   0.0 22.0     0.0   9.0   54.0 55.0     7.0   1.0     30.0   13.0   109.0 63 9 6   0 22     0   9   54 55     7 1   30 13   109

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