Data source: Big Local News · About: Big Local

13,903 rows where state = "MN" and year = 2019 sorted by multiracial 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
1954920 MN Washington 82 school 2733810 833 Independent Districts and Schools SOUTH WASHINGTON COUNTY SCHOOL DIST 273381001550 29 Woodbury High School Senior High School (Grades 9-12) Regular School No High 09 12 2019   pk_12_total 1251.0 221.0 135.0   3.0 262.0     1.0   99.0   1017.0 955.0     45.0   4.0     271.0   206.0   1972.0 1251 221 135   3 262     1   99   1017 955     45 4   271 206   1972
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
1946531 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 2019   pk_12_total 358.0 1.0 7.0   64.0 3.0     0.0   97.0   285.0 245.0     2.0   5.0     244.0   95.0   530.0 358 1 7   64 3     0   97   285 245     2 5   244 95   530
1949536 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384001594 494 CAPITOL HILL MAGNET/RONDO Elementary School (Grades PK-6) Regular School No Elementary 01 08 2019   pk_12_total 480.0 284.0 79.0   0.0 313.0     1.0   97.0   665.0 589.0     132.0   4.0     525.0   69.0   1254.0 480 284 79   0 313     1   97   665 589     132 4   525 69   1254
1954418 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239002645 88 EASTVIEW SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 09 12 2019   pk_12_total 1452.0 258.0 146.0   5.0 264.0     3.0   96.0   1101.0 1123.0     42.0   6.0     347.0   234.0   2224.0 1452 258 146   5 264     3   96   1101 1123     42 6   347 234   2224
1947123 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 2019   pk_12_total 281.0 220.0 163.0   1.0 25.0     0.0   94.0   390.0 394.0     200.0   6.0     385.0   122.0   784.0 281 220 163   1 25     0   94   390 394     200 6   385 122   784
1953558 MN Hennepin 27 school 2733780 283 Independent Districts and Schools ST. LOUIS PARK PUBLIC SCHOOL DIST. 273378001533 42 ST. LOUIS PARK MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 06 08 2019   pk_12_total 539.0 215.0 128.0   9.0 31.0     1.0   94.0   541.0 476.0     78.0   16.0     389.0   131.0   1017.0 539 215 128   9 31     1   94   541 476     78 16   389 131   1017
1953835 MN Scott 70 school 2733000 720 Independent Districts and Schools SHAKOPEE PUBLIC SCHOOL DISTRICT 273300001439 84 Shakopee West Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2019   pk_12_total 644.0 93.0 162.0   11.0 141.0     2.0   94.0   589.0 558.0     77.0   5.0     385.0   145.0   1147.0 644 93 162   11 141     2   94   589 558     77 5   385 145   1147
1954224 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000100 2 Coon Rapids High School Senior High School (Grades 9-12) Regular School No High 09 12 2019   pk_12_total 1335.0 372.0 155.0   28.0 169.0     0.0   94.0   1049.0 1104.0     94.0   48.0     945.0   266.0   2153.0 1335 372 155   28 169     0   94   1049 1104     94 48   945 266   2153
1954513 MN Hennepin 27 school 2725200 279 Independent Districts and Schools OSSEO PUBLIC SCHOOL DISTRICT 272520002651 90 MAPLE GROVE SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 09 12 2019   pk_12_total 1750.0 222.0 88.0   19.0 181.0     0.0   92.0   1171.0 1181.0     47.0   7.0     336.0   174.0   2352.0 1750 222 88   19 181     0   92   1171 1181     47 7   336 174   2352
1947896 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 2019   pk_12_total 261.0 87.0 170.0   9.0 65.0     2.0   91.0   395.0 290.0     163.0   4.0     388.0   87.0   685.0 261 87 170   9 65     2   91   395 290     163 4   388 87   685
1947931 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 PK 05 2019   pk_12_total 201.0 184.0 99.0   1.0 38.0     0.0   91.0   322.0 292.0     107.0   11.0     355.0   92.0   614.0 201 184 99   1 38     0   91   322 292     107 11   355 92   614
1949937 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 2019   pk_12_total 334.0 41.0 11.0   23.0 10.0     0.0   91.0   270.0 240.0     5.0   12.0     313.0   99.0   510.0 334 41 11   23 10     0   91   270 240     5 12   313 99   510
1953279 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 2019   pk_12_total 631.0 12.0 17.0   79.0 7.0     0.0   91.0   444.0 393.0     *   8.0     333.0   162.0   837.0 631 12 17   79 7     0   91   444 393       8   333 162   837
1953522 MN Hennepin 27 school 2725200 279 Independent Districts and Schools OSSEO PUBLIC SCHOOL DISTRICT 272520001208 33 Brooklyn Middle School, a Science, Technology, Engineering, Art and Math School Middle School (Grades 5-8) Regular School No Middle 06 08 2019   pk_12_total 183.0 397.0 126.0   6.0 266.0     1.0   91.0   551.0 519.0     97.0   7.0     675.0   151.0   1070.0 183 397 126   6 266     1   91   551 519     97 7   675 151   1070
1946086 MN Hennepin 27 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318002193 425 OXBOW CREEK ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   pk_12_total 799.0 117.0 41.0   3.0 92.0     4.0   90.0   564.0 582.0     80.0   4.0     236.0   150.0   1146.0 799 117 41   3 92     4   90   564 582     80 4   236 150   1146
1953427 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239002644 86 FALCON RIDGE MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2019   pk_12_total 628.0 138.0 149.0   5.0 72.0     1.0   90.0   559.0 524.0     62.0   5.0     298.0   140.0   1083.0 628 138 149   5 72     1   90   559 524     62 5   298 140   1083
1953538 MN Hennepin 27 school 2731750 280 Independent Districts and Schools RICHFIELD PUBLIC SCHOOL DISTRICT 273175001317 37 RICHFIELD MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2019   pk_12_total 262.0 141.0 425.0   7.0 43.0     1.0   90.0   500.0 469.0     177.0   20.0     624.0   148.0   969.0 262 141 425   7 43     1   90   500 469     177 20   624 148   969
1944604 MN Goodhue 25 school 2730480 256 Independent Districts and Schools RED WING PUBLIC SCHOOL DISTRICT 273048001293 108 RED WING SENIOR HIGH Secondary School (Grades 7-12) Regular School No High 08 12 2019   grade_10 146.0 7.0 14.0   8.0 0.0     0.0   9.0   96.0 88.0     4.0   0.0     54.0   22.0   184.0 146 7 14   8 0     0   9   96 88     4 0   54 22   184
1944664 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 High 06 12 2019   grade_7 38.0 1.0 3.0   27.0 0.0     0.0   9.0   40.0 38.0     0.0   4.0     58.0   16.0   78.0 38 1 3   27 0     0   9   40 38     0 4   58 16   78
1944679 MN Itasca 31 school 2723310 319 Independent Districts and Schools NASHWAUK-KEEWATIN SCHOOL DISTRICT 272331001138 50 NASHWAUK SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_8 40.0 1.0 0.0   0.0 0.0     0.0   9.0   28.0 22.0     0.0   2.0     26.0   18.0   50.0 40 1 0   0 0     0   9   28 22     0 2   26 18   50
1944764 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 High 06 12 2019   pk_12_total 608.0 1.0 7.0   9.0 3.0     1.0   9.0   334.0 304.0     0.0   *     123.0   100.0   638.0 608 1 7   9 3     1   9   334 304     0     123 100   638
1944977 MN Polk 60 school 2709720 593 Independent Districts and Schools CROOKSTON PUBLIC SCHOOL DISTRICT 270972000412 90 CROOKSTON SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_8 70.0 3.0 22.0   3.0 0.0     0.0   9.0   53.0 54.0     4.0   8.0     54.0   24.0   107.0 70 3 22   3 0     0   9   53 54     4 8   54 24   107
1945005 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384004680 211 Creative Arts Secondary School Secondary School (Grades 7-12) Regular School No High 06 12 2019   grade_7 12.0 37.0 12.0   1.0 19.0     0.0   9.0   31.0 59.0     16.0   5.0     70.0   12.0   90.0 12 37 12   1 19     0   9   31 59     16 5   70 12   90
1945021 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384004443 250 OPEN WORLD LEARNING SECONDARY Secondary School (Grades 7-12) Regular School No High 06 12 2019   grade_7 39.0 5.0 12.0   0.0 6.0     0.0   9.0   35.0 36.0     3.0   1.0     20.0   14.0   71.0 39 5 12   0 6     0   9   35 36     3 1   20 14   71
1945097 MN Saint Louis 69 school 2713980 701 Independent Districts and Schools HIBBING PUBLIC SCHOOL DISTRICT 271398001539 350 HIBBING HIGH Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_11 123.0 4.0 1.0   2.0 0.0     0.0   9.0   58.0 81.0     *   *         *   139.0 123 4 1   2 0     0   9   58 81                 139
1945103 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 2019   grade_10 113.0 0.0 4.0   3.0 1.0     0.0   9.0   76.0 54.0     2.0   1.0     38.0   11.0   130.0 113 0 4   3 1     0   9   76 54     2 1   38 11   130
1945296 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 2019   pk_12_total 421.0 2.0 5.0   1.0 0.0     3.0   9.0   219.0 222.0     1.0   0.0     74.0   67.0   441.0 421 2 5   1 0     3   9   219 222     1 0   74 67   441
1945357 MN Saint Louis 69 school 2700008 2142 Independent Districts and Schools ST. LOUIS COUNTY SCHOOL DISTRICT 270000804544 45 SOUTH RIDGE SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_9 39.0 1.0 0.0   2.0 0.0     0.0   9.0   27.0 24.0     0.0   0.0     20.0   8.0   51.0 39 1 0   2 0     0   9   27 24     0 0   20 8   51
1945460 MN Fillmore 23 school 2700100 2198 Independent Districts and Schools FILLMORE CENTRAL 270010000691 456 FILLMORE CENTRAL SENIOR HIGH Secondary School (Grades 7-12) Regular School No High 07 12 2019   pk_12_total 257.0 0.0 3.0   0.0 0.0     0.0   9.0   127.0 142.0     0.0   0.0         *   269.0 257 0 3   0 0     0   9   127 142     0 0         269
1945781 MN Ramsey 62 school 2700337 4098 Charter Schools Nova Classical Academy 270033704356 20 NOVA CLASSICAL ACADEMY UPPER SCHOOL Secondary School (Grades 7-12) Regular School Yes High 06 12 2019   grade_6 53.0 4.0 6.0   0.0 10.0     0.0   9.0   36.0 46.0     3.0   0.0     13.0   3.0   82.0 53 4 6   0 10     0   9   36 46     3 0   13 3   82
1945844 MN Hennepin 27 school 2700315 4183 Charter Schools LIONSGATE ACADEMY 270031504325 10 LIONSGATE ACADEMY Secondary School (Grades 7-12) Regular School Yes High 07 12 2019   pk_12_total 111.0 12.0 4.0   0.0 9.0     0.0   9.0   109.0 36.0     *   *     26.0   *   145.0 111 12 4   0 9     0   9   109 36           26     145
1945940 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000095 400 ADAMS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   grade_2 48.0 22.0 6.0   0.0 7.0     0.0   9.0   50.0 42.0     19.0   6.0     56.0   20.0   92.0 48 22 6   0 7     0   9   50 42     19 6   56 20   92
1945959 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000106 404 HAMILTON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   kindergarten 39.0 10.0 5.0   1.0 8.0     0.0   9.0   39.0 33.0     14.0   0.0     45.0   12.0   72.0 39 10 5   1 8     0   9   39 33     14 0   45 12   72
1946009 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000115 412 MISSISSIPPI ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   grade_1 38.0 11.0 5.0   0.0 3.0     0.0   9.0   39.0 27.0     5.0   4.0     33.0   14.0   66.0 38 11 5   0 3     0   9   39 27     5 4   33 14   66
1946016 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 2019   grade_1 27.0 18.0 7.0   0.0 27.0     0.0   9.0   56.0 32.0     32.0   *     36.0   13.0   88.0 27 18 7   0 27     0   9   56 32     32     36 13   88
1946017 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 2019   grade_2 28.0 31.0 6.0   0.0 24.0     0.0   9.0   50.0 48.0     24.0   3.0     45.0   26.0   98.0 28 31 6   0 24     0   9   50 48     24 3   45 26   98
1946019 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 2019   grade_4 28.0 31.0 8.0   2.0 35.0     0.0   9.0   58.0 55.0     29.0   1.0     56.0   17.0   113.0 28 31 8   2 35     0   9   58 55     29 1   56 17   113
1946041 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 PK 05 2019   grade_4 62.0 31.0 3.0   0.0 3.0     0.0   9.0   58.0 50.0     9.0   6.0     56.0   23.0   108.0 62 31 3   0 3     0   9   58 50     9 6   56 23   108
1946044 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000128 420 WILSON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   kindergarten 134.0 23.0 12.0   1.0 6.0     0.0   9.0   93.0 92.0     19.0   0.0     70.0   25.0   185.0 134 23 12   1 6     0   9   93 92     19 0   70 25   185
1946070 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 2019   grade_4 208.0 20.0 8.0   2.0 11.0     0.0   9.0   145.0 113.0     19.0   2.0     77.0   33.0   258.0 208 20 8   2 11     0   9   145 113     19 2   77 33   258
1946071 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 2019   grade_5 198.0 18.0 9.0   1.0 9.0     0.0   9.0   141.0 103.0     11.0   2.0     67.0   41.0   244.0 198 18 9   1 9     0   9   141 103     11 2   67 41   244
1946084 MN Hennepin 27 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318002193 425 OXBOW CREEK ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   grade_4 125.0 26.0 9.0   0.0 14.0     2.0   9.0   93.0 92.0     13.0   1.0     40.0   22.0   185.0 125 26 9   0 14     2   9   93 92     13 1   40 22   185
1946090 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318002203 426 ANDOVER ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   grade_3 193.0 8.0 13.0   1.0 10.0     2.0   9.0   121.0 115.0     17.0   1.0     42.0   26.0   236.0 193 8 13   1 10     2   9   121 115     17 1   42 26   236
1946147 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 2019   grade_2 19.0 29.0 18.0   1.0 4.0     0.0   9.0   45.0 35.0     30.0   *     60.0   13.0   80.0 19 29 18   1 4     0   9   45 35     30     60 13   80
1946149 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 2019   grade_4 15.0 26.0 27.0   2.0 2.0     0.0   9.0   37.0 44.0     30.0   2.0     59.0   14.0   81.0 15 26 27   2 2     0   9   37 44     30 2   59 14   81
1946174 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 2019   grade_1 28.0 32.0 8.0   1.0 6.0     0.0   9.0   45.0 39.0     17.0   1.0     51.0   12.0   84.0 28 32 8   1 6     0   9   45 39     17 1   51 12   84
1946185 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   kindergarten 93.0 2.0 3.0   0.0 1.0     0.0   9.0   68.0 40.0     *   *     33.0   26.0   108.0 93 2 3   0 1     0   9   68 40           33 26   108
1946193 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_1 102.0 1.0 5.0   0.0 5.0     0.0   9.0   63.0 59.0     5.0   1.0     30.0   19.0   122.0 102 1 5   0 5     0   9   63 59     5 1   30 19   122
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
1946210 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_4 88.0 9.0 1.0   1.0 9.0     0.0   9.0   53.0 64.0     *   *         *   117.0 88 9 1   1 9     0   9   53 64                 117
1946220 MN Anoka 2 school 2733330 16 Independent Districts and Schools SPRING LAKE PARK PUBLIC SCHOOLS 273333001462 775 Park Terrace Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 04 2019   kindergarten 64.0 19.0 10.0   1.0 12.0     2.0   9.0   63.0 54.0     25.0   4.0     69.0   25.0   117.0 64 19 10   1 12     2   9   63 54     25 4   69 25   117
1946227 MN Unknown   school 2733330 16 Independent Districts and Schools SPRING LAKE PARK PUBLIC SCHOOLS 273333005028 776 Centerview Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 04 2019   grade_1 60.0 16.0 4.0   0.0 12.0     0.0   9.0   53.0 48.0     18.0   0.0     33.0   18.0   101.0 60 16 4   0 12     0   9   53 48     18 0   33 18   101
1946246 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 2019   kindergarten 67.0 2.0 3.0   24.0 2.0     0.0   9.0   57.0 50.0     1.0   0.0     47.0   25.0   107.0 67 2 3   24 2     0   9   57 50     1 0   47 25   107
1946284 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 03 2019   grade_1 12.0 2.0 1.0   31.0 0.0     0.0   9.0   30.0 25.0     0.0   3.0     47.0   *   55.0 12 2 1   31 0     0   9   30 25     0 3   47     55
1946293 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   grade_3 23.0 0.0 1.0   10.0 0.0     0.0   9.0   24.0 19.0     0.0   5.0     29.0   11.0   43.0 23 0 1   10 0     0   9   24 19     0 5   29 11   43
1946356 MN Benton 5 school 2732880 47 Independent Districts and Schools SAUK RAPIDS-RICE PUBLIC SCHOOLS 273288001430 3 MISSISSIPPI HEIGHTS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   grade_4 148.0 3.0 3.0   1.0 0.0     1.0   9.0   77.0 88.0     2.0   2.0     49.0   33.0   165.0 148 3 3   1 0     1   9   77 88     2 2   49 33   165
1946440 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 2019   grade_1 55.0 10.0 2.0   0.0 2.0     0.0   9.0   45.0 33.0     10.0   3.0     34.0   13.0   78.0 55 10 2   0 2     0   9   45 33     10 3   34 13   78
1946524 MN Carlton 9 school 2709420 94 Independent Districts and Schools CLOQUET PUBLIC SCHOOL DISTRICT 270942000380 101 CHURCHILL ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   grade_4 69.0 1.0 0.0   20.0 0.0     0.0   9.0   48.0 51.0     0.0   1.0     52.0   *   99.0 69 1 0   20 0     0   9   48 51     0 1   52     99
1946556 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_5 92.0 0.0 1.0   0.0 0.0     0.0   9.0   56.0 46.0     0.0   2.0     13.0   11.0   102.0 92 0 1   0 0     0   9   56 46     0 2   13 11   102
1946623 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 2019   grade_4 63.0 5.0 7.0   0.0 3.0     0.0   9.0   48.0 39.0     4.0   0.0     19.0   15.0   87.0 63 5 7   0 3     0   9   48 39     4 0   19 15   87
1946632 MN Carver 10 school 2708190 112 Independent Districts and Schools EASTERN CARVER COUNTY PUBLIC SCHOOL 270819000346 507 EAST UNION ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   pk_12_total 107.0 2.0 4.0   0.0 1.0     0.0   9.0   71.0 52.0     0.0   0.0     9.0   13.0   123.0 107 2 4   0 1     0   9   71 52     0 0   9 13   123
1946707 MN Chisago 13 school 2723820 138 Independent Districts and Schools NORTH BRANCH PUBLIC SCHOOLS 272382003514 45 SUNRISE RIVER ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 04 2019   grade_3 167.0 2.0 11.0   2.0 3.0     0.0   9.0   107.0 87.0     6.0   1.0     55.0   29.0   194.0 167 2 11   2 3     0   9   107 87     6 1   55 29   194
1946708 MN Chisago 13 school 2723820 138 Independent Districts and Schools NORTH BRANCH PUBLIC SCHOOLS 272382003514 45 SUNRISE RIVER ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 04 2019   grade_4 155.0 1.0 5.0   0.0 6.0     0.0   9.0   89.0 87.0     5.0   0.0     55.0   28.0   176.0 155 1 5   0 6     0   9   89 87     5 0   55 28   176
1946755 MN Clay 14 school 2721420 152 Independent Districts and Schools MOORHEAD PUBLIC SCHOOL DISTRICT 272142003510 188 ELLEN HOPKINS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 04 2019   grade_1 101.0 17.0 10.0   3.0 3.0     0.0   9.0   75.0 68.0     7.0   0.0     44.0   22.0   143.0 101 17 10   3 3     0   9   75 68     7 0   44 22   143
1946756 MN Clay 14 school 2721420 152 Independent Districts and Schools MOORHEAD PUBLIC SCHOOL DISTRICT 272142003510 188 ELLEN HOPKINS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 04 2019   grade_2 74.0 16.0 16.0   4.0 1.0     0.0   9.0   50.0 70.0     10.0   3.0     47.0   15.0   120.0 74 16 16   4 1     0   9   50 70     10 3   47 15   120
1946760 MN Clay 14 school 2721420 152 Independent Districts and Schools MOORHEAD PUBLIC SCHOOL DISTRICT 272142003511 189 S.G.REINERTSEN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 04 2019   kindergarten 104.0 25.0 6.0   1.0 1.0     0.0   9.0   88.0 58.0     26.0   1.0     55.0   20.0   146.0 104 25 6   1 1     0   9   88 58     26 1   55 20   146
1946763 MN Clay 14 school 2721420 152 Independent Districts and Schools MOORHEAD PUBLIC SCHOOL DISTRICT 272142003511 189 S.G.REINERTSEN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 04 2019   grade_3 130.0 18.0 7.0   1.0 1.0     0.0   9.0   96.0 70.0     21.0   0.0     65.0   28.0   166.0 130 18 7   1 1     0   9   96 70     21 0   65 28   166
1946896 MN Dakota 19 school 2707290 191 Independent Districts and Schools BURNSVILLE PUBLIC SCHOOL DISTRICT 270729000303 486 VISTA VIEW ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   grade_4 18.0 18.0 15.0   0.0 6.0     0.0   9.0   36.0 30.0     16.0   4.0     37.0   12.0   66.0 18 18 15   0 6     0   9   36 30     16 4   37 12   66
1946952 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 2019   grade_3 71.0 3.0 7.0   0.0 4.0     0.0   9.0   53.0 41.0     11.0   0.0     15.0   15.0   94.0 71 3 7   0 4     0   9   53 41     11 0   15 15   94
1947013 MN Dakota 19 school 2717780 194 Independent Districts and Schools LAKEVILLE PUBLIC SCHOOL DISTRICT 271778002273 595 LAKE MARION ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   grade_5 95.0 2.0 9.0   0.0 2.0     0.0   9.0   59.0 58.0     *   *     15.0   25.0   117.0 95 2 9   0 2     0   9   59 58           15 25   117
1947039 MN Dakota 19 school 2717780 194 Independent Districts and Schools LAKEVILLE PUBLIC SCHOOL DISTRICT 271778002985 599 OAK HILLS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   grade_3 60.0 7.0 21.0   0.0 7.0     0.0   9.0   53.0 51.0     11.0   0.0     20.0   16.0   104.0 60 7 21   0 7     0   9   53 51     11 0   20 16   104
1947041 MN Dakota 19 school 2717780 194 Independent Districts and Schools LAKEVILLE PUBLIC SCHOOL DISTRICT 271778002985 599 OAK HILLS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   grade_5 63.0 5.0 19.0   0.0 9.0     1.0   9.0   60.0 46.0     11.0   0.0     26.0   26.0   106.0 63 5 19   0 9     1   9   60 46     11 0   26 26   106
1947057 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 2019   grade_5 81.0 14.0 3.0   0.0 4.0     0.0   9.0   60.0 51.0     5.0   *     14.0   14.0   111.0 81 14 3   0 4     0   9   60 51     5     14 14   111
1947066 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239001384 707 WESTVIEW ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   kindergarten 45.0 19.0 6.0   1.0 2.0     0.0   9.0   42.0 40.0     18.0   0.0     30.0   15.0   82.0 45 19 6   1 2     0   9   42 40     18 0   30 15   82
1947074 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239001382 708 SOUTHVIEW ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   grade_1 60.0 24.0 12.0   0.0 0.0     0.0   9.0   64.0 41.0     7.0   0.0     30.0   20.0   105.0 60 24 12   0 0     0   9   64 41     7 0   30 20   105
1947110 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239001944 713 THOMAS LAKE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   grade_2 58.0 14.0 4.0   0.0 4.0     0.0   9.0   54.0 35.0     15.0   0.0     15.0   12.0   89.0 58 14 4   0 4     0   9   54 35     15 0   15 12   89
1947111 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239001944 713 THOMAS LAKE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   grade_3 56.0 8.0 4.0   1.0 4.0     0.0   9.0   44.0 38.0     6.0   0.0     14.0   16.0   82.0 56 8 4   1 4     0   9   44 38     6 0   14 16   82
1947113 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239001944 713 THOMAS LAKE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   grade_5 52.0 3.0 5.0   0.0 9.0     1.0   9.0   46.0 33.0     4.0   0.0     10.0   19.0   79.0 52 3 5   0 9     1   9   46 33     4 0   10 19   79
1947156 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 2019   grade_4 100.0 2.0 6.0   0.0 16.0     0.0   9.0   66.0 67.0     5.0   0.0         12.0   133.0 100 2 6   0 16     0   9   66 67     5 0     12   133
1947165 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 PK 05 2019   grade_4 36.0 33.0 5.0   1.0 5.0     0.0   9.0   44.0 45.0     18.0   1.0     46.0   18.0   89.0 36 33 5   1 5     0   9   44 45     18 1   46 18   89
1947166 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 PK 05 2019   grade_5 34.0 20.0 9.0   1.0 6.0     0.0   9.0   35.0 44.0     *   0.0     30.0   10.0   79.0 34 20 9   1 6     0   9   35 44       0   30 10   79
1947182 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 2019   kindergarten 86.0 2.0 8.0   0.0 1.0     0.0   9.0   55.0 51.0     10.0   0.0         13.0   106.0 86 2 8   0 1     0   9   55 51     10 0     13   106
1947214 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 2019   kindergarten 31.0 23.0 13.0   0.0 20.0     0.0   9.0   52.0 44.0     22.0   1.0     31.0   11.0   96.0 31 23 13   0 20     0   9   52 44     22 1   31 11   96
1947217 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 2019   grade_3 24.0 20.0 9.0   0.0 8.0     0.0   9.0   37.0 33.0     10.0   0.0     33.0   14.0   70.0 24 20 9   0 8     0   9   37 33     10 0   33 14   70
1947228 MN Dakota 19 school 2715030 199 Independent Districts and Schools INVER GROVE HEIGHTS SCHOOLS 271503000763 575 HILLTOP ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   grade_3 31.0 14.0 27.0   0.0 1.0     0.0   9.0   41.0 41.0     16.0   0.0     45.0   17.0   82.0 31 14 27   0 1     0   9   41 41     16 0   45 17   82
1947243 MN Dakota 19 school 2715030 199 Independent Districts and Schools INVER GROVE HEIGHTS SCHOOLS 271503000766 578 SALEM HILLS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   kindergarten 23.0 4.0 11.0   1.0 2.0     0.0   9.0   31.0 19.0     5.0   0.0     19.0   6.0   50.0 23 4 11   1 2     0   9   31 19     5 0   19 6   50
1947370 MN Fillmore 23 school 2728290 239 Independent Districts and Schools RUSHFORD-PETERSON PUBLIC SCHOOLS 272829001407 1 RUSHFORD-PETERSON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   pk_12_total 306.0 0.0 7.0   0.0 1.0     0.0   9.0   179.0 144.0     6.0   0.0     100.0   37.0   323.0 306 0 7   0 1     0   9   179 144     6 0   100 37   323
1947476 MN Hennepin 27 school 2714260 270 Independent Districts and Schools HOPKINS PUBLIC SCHOOL DISTRICT 271426001881 563 GLEN LAKE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   grade_6 42.0 15.0 2.0   0.0 4.0     0.0   9.0   31.0 41.0     2.0   *     24.0   15.0   72.0 42 15 2   0 4     0   9   31 41     2     24 15   72
1947486 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 2019   grade_6 8.0 21.0 8.0   0.0 1.0     0.0   9.0   20.0 27.0     10.0   0.0     37.0   10.0   47.0 8 21 8   0 1     0   9   20 27     10 0   37 10   47
1947493 MN Hennepin 27 school 2714260 270 Independent Districts and Schools HOPKINS PUBLIC SCHOOL DISTRICT 271426001887 567 L.H. TANGLEN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   grade_5 40.0 21.0 5.0   1.0 6.0     0.0   9.0   43.0 39.0     9.0   1.0     39.0   10.0   82.0 40 21 5   1 6     0   9   43 39     9 1   39 10   82
1947497 MN Hennepin 27 school 2714260 270 Independent Districts and Schools HOPKINS PUBLIC SCHOOL DISTRICT 271426004662 568 Xinxing Academy Elementary School (Grades PK-6) Regular School No Elementary KG 06 2019   grade_1 26.0 3.0 5.0   0.0 6.0     0.0   9.0   17.0 32.0     *   0.0     3.0   0.0   49.0 26 3 5   0 6     0   9   17 32       0   3 0   49
1947509 MN Hennepin 27 school 2714260 270 Independent Districts and Schools HOPKINS PUBLIC SCHOOL DISTRICT 271426001880 569 GATEWOOD ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   grade_3 21.0 25.0 8.0   0.0 1.0     0.0   9.0   30.0 34.0     17.0   0.0     43.0   14.0   64.0 21 25 8   0 1     0   9   30 34     17 0   43 14   64
1947510 MN Hennepin 27 school 2714260 270 Independent Districts and Schools HOPKINS PUBLIC SCHOOL DISTRICT 271426001880 569 GATEWOOD ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   grade_4 22.0 18.0 12.0   0.0 3.0     0.0   9.0   42.0 22.0     8.0   0.0     33.0   16.0   64.0 22 18 12   0 3     0   9   42 22     8 0   33 16   64
1947534 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 2019   grade_4 50.0 11.0 5.0   0.0 3.0     0.0   9.0   35.0 43.0     7.0   0.0     20.0   8.0   78.0 50 11 5   0 3     0   9   35 43     7 0   20 8   78
1947560 MN Hennepin 27 school 2705790 271 Independent Districts and Schools BLOOMINGTON PUBLIC SCHOOL DISTRICT 270579000223 448 OAK GROVE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   grade_5 35.0 11.0 13.0   0.0 5.0     0.0   9.0   44.0 29.0     13.0   1.0     32.0   13.0   73.0 35 11 13   0 5     0   9   44 29     13 1   32 13   73
1947566 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 2019   grade_4 46.0 14.0 8.0   0.0 7.0     0.0   9.0   45.0 39.0     14.0   1.0     30.0   17.0   84.0 46 14 8   0 7     0   9   45 39     14 1   30 17   84
1947588 MN Hennepin 27 school 2705790 271 Independent Districts and Schools BLOOMINGTON PUBLIC SCHOOL DISTRICT 270579000238 459 VALLEY VIEW ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   grade_3 8.0 15.0 37.0   1.0 6.0     1.0   9.0   35.0 42.0     44.0   3.0     66.0   10.0   77.0 8 15 37   1 6     1   9   35 42     44 3   66 10   77
1947601 MN Hennepin 27 school 2714220 272 Independent Districts and Schools EDEN PRAIRIE PUBLIC SCHOOL DISTRICT 271422002271 880 Oak Point Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 06 2019   grade_2 45.0 17.0 8.0   1.0 35.0     0.0   9.0   52.0 63.0     30.0   0.0     24.0   8.0   115.0 45 17 8   1 35     0   9   52 63     30 0   24 8   115
1947608 MN Hennepin 27 school 2714220 272 Independent Districts and Schools EDEN PRAIRIE PUBLIC SCHOOL DISTRICT 271422000737 881 PRAIRIE VIEW ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 06 2019   grade_1 70.0 20.0 4.0   0.0 10.0     0.0   9.0   59.0 54.0     15.0   0.0     27.0   12.0   113.0 70 20 4   0 10     0   9   59 54     15 0   27 12   113

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