Data source: Big Local News · About: Big Local

2,304 rows where grade = "pk_12_total", state = "MN" and year = 2019 sorted by ccd_school_low_grade

View and edit SQL

year

  • 2019 · 2,304

grade

  • pk_12_total · 2,304
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
1946236 MN Anoka 2 school 2733330 16 Independent Districts and Schools SPRING LAKE PARK PUBLIC SCHOOLS 273333004657 787 Elementary Lighthouse Elementary School (Grades PK-6) Regular School No Elementary 01 06 2019   pk_12_total 29.0 3.0 1.0   0.0 4.0     0.0   2.0   26.0 13.0     0.0   0.0         3.0   39.0 29 3 1   0 4     0   2   26 13     0 0     3   39
1946278 MN Beltrami 4 school 2704440 31 Independent Districts and Schools BEMIDJI PUBLIC SCHOOL DISTRICT 270444000194 16 NORTHERN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 01 03 2019   pk_12_total 238.0 0.0 3.0   28.0 1.0     0.0   21.0   144.0 147.0     *   3.0     110.0   54.0   291.0 238 0 3   28 1     0   21   144 147       3   110 54   291
1946311 MN Beltrami 4 school 2704440 31 Independent Districts and Schools BEMIDJI PUBLIC SCHOOL DISTRICT 270444000193 100 HORACE MAY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 01 03 2019   pk_12_total 253.0 5.0 5.0   25.0 3.0     0.0   6.0   166.0 131.0     0.0   3.0     109.0   86.0   297.0 253 5 5   25 3     0   6   166 131     0 3   109 86   297
1946337 MN Beltrami 4 school 2730510 38 Independent Districts and Schools RED LAKE PUBLIC SCHOOL DISTRICT 273051001302 10 RED LAKE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 01 05 2019   pk_12_total 0.0 0.0 0.0   588.0 0.0     0.0   1.0   308.0 281.0     *   85.0     498.0   117.0   589.0 0 0 0   588 0     0   1   308 281       85   498 117   589
1946499 MN Brown 8 school 2723490 88 Independent Districts and Schools NEW ULM PUBLIC SCHOOL DISTRICT 272349001150 20 JEFFERSON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 01 04 2019   pk_12_total 551.0 8.0 31.0   0.0 0.0     0.0   16.0   319.0 287.0     7.0   2.0     190.0   114.0   606.0 551 8 31   0 0     0   16   319 287     7 2   190 114   606
1946700 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 2019   pk_12_total 241.0 7.0 71.0   2.0 0.0     2.0   16.0   177.0 162.0     51.0   0.0     168.0   76.0   339.0 241 7 71   2 0     2   16   177 162     51 0   168 76   339
1948644 MN Mower 50 school 2703450 492 Independent Districts and Schools AUSTIN PUBLIC SCHOOL DISTRICT 270345000149 10 BANFIELD ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 01 04 2019   pk_12_total 238.0 45.0 99.0   0.0 34.0     4.0   17.0   232.0 205.0     107.0   1.0     229.0   68.0   437.0 238 45 99   0 34     4   17   232 205     107 1   229 68   437
1948649 MN Mower 50 school 2703450 492 Independent Districts and Schools AUSTIN PUBLIC SCHOOL DISTRICT 270345000153 40 NEVELN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 01 04 2019   pk_12_total 161.0 16.0 99.0   0.0 31.0     5.0   10.0   151.0 171.0     85.0   0.0     207.0   52.0   322.0 161 16 99   0 31     5   10   151 171     85 0   207 52   322
1948654 MN Mower 50 school 2703450 492 Independent Districts and Schools AUSTIN PUBLIC SCHOOL DISTRICT 270345002230 70 SOUTHGATE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 01 04 2019   pk_12_total 265.0 28.0 145.0   0.0 47.0     2.0   26.0   252.0 261.0     117.0   *     274.0   96.0   513.0 265 28 145   0 47     2   26   252 261     117     274 96   513
1948660 MN Mower 50 school 2703450 492 Independent Districts and Schools AUSTIN PUBLIC SCHOOL DISTRICT 270345000156 80 SUMNER ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 01 04 2019   pk_12_total 58.0 64.0 120.0   0.0 70.0     5.0   11.0   171.0 157.0     148.0   4.0     276.0   51.0   328.0 58 64 120   0 70     5   11   171 157     148 4   276 51   328
1948912 MN Otter Tail 56 school 2711880 544 Independent Districts and Schools FERGUS FALLS PUBLIC SCHOOL DISTRICT 271188000571 130 ADAMS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 01 02 2019   pk_12_total 287.0 10.0 10.0   1.0 4.0     2.0   5.0   167.0 152.0     8.0   0.0     123.0   26.0   319.0 287 10 10   1 4     2   5   167 152     8 0   123 26   319
1949082 MN Ramsey 62 school 2722950 621 Independent Districts and Schools MOUNDS VIEW PUBLIC SCHOOL DISTRICT 272295001114 25 BEL AIR ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 01 05 2019   pk_12_total 417.0 127.0 65.0   4.0 51.0     0.0   55.0   365.0 354.0     78.0   8.0     257.0   61.0   719.0 417 127 65   4 51     0   55   365 354     78 8   257 61   719
1949088 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 2019   pk_12_total 532.0 39.0 34.0   3.0 124.0     0.0   43.0   432.0 343.0     44.0   0.0     112.0   70.0   775.0 532 39 34   3 124     0   43   432 343     44 0   112 70   775
1949094 MN Ramsey 62 school 2722950 621 Independent Districts and Schools MOUNDS VIEW PUBLIC SCHOOL DISTRICT 272295001124 30 PINEWOOD ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 01 05 2019   pk_12_total 291.0 66.0 74.0   3.0 78.0     1.0   53.0   276.0 290.0     85.0   9.0     290.0   73.0   566.0 291 66 74   3 78     1   53   276 290     85 9   290 73   566
1949100 MN Ramsey 62 school 2722950 621 Independent Districts and Schools MOUNDS VIEW PUBLIC SCHOOL DISTRICT 272295001128 34 SUNNYSIDE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 01 05 2019   pk_12_total 301.0 60.0 64.0   1.0 45.0     1.0   48.0   279.0 241.0     65.0   5.0     216.0   75.0   520.0 301 60 64   1 45     1   48   279 241     65 5   216 75   520
1949106 MN Ramsey 62 school 2722950 621 Independent Districts and Schools MOUNDS VIEW PUBLIC SCHOOL DISTRICT 272295001129 35 Turtle Lake Elementary Elementary School (Grades PK-6) Regular School No Elementary 01 05 2019   pk_12_total 736.0 18.0 39.0   3.0 152.0     1.0   58.0   545.0 462.0     35.0   2.0     99.0   90.0   1007.0 736 18 39   3 152     1   58   545 462     35 2   99 90   1007
1949112 MN Ramsey 62 school 2722950 621 Independent Districts and Schools MOUNDS VIEW PUBLIC SCHOOL DISTRICT 272295001130 36 Valentine Hills Elementary Elementary School (Grades PK-6) Regular School No Elementary 01 05 2019   pk_12_total 391.0 92.0 83.0   5.0 48.0     0.0   54.0   364.0 309.0     66.0   6.0     277.0   65.0   673.0 391 92 83   5 48     0   54   364 309     66 6   277 65   673
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
1950915 MN Wright 86 school 2733790 885 Independent Districts and Schools ST. MICHAEL-ALBERTVILLE SCHOOL DIST 273379000032 40 ST. MICHAEL ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 01 04 2019   pk_12_total 447.0 25.0 18.0   0.0 15.0     0.0   19.0   288.0 236.0     10.0   1.0     73.0   64.0   524.0 447 25 18   0 15     0   19   288 236     10 1   73 64   524
1950920 MN Wright 86 school 2733790 885 Independent Districts and Schools ST. MICHAEL-ALBERTVILLE SCHOOL DIST 273379004187 60 BIG WOODS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 01 04 2019   pk_12_total 563.0 26.0 18.0   0.0 10.0     0.0   21.0   323.0 315.0     12.0   1.0     69.0   71.0   638.0 563 26 18   0 10     0   21   323 315     12 1   69 71   638
1950925 MN Wright 86 school 2733790 885 Independent Districts and Schools ST. MICHAEL-ALBERTVILLE SCHOOL DIST 273379003673 70 FIELDSTONE ELEMENTARY SCHOOL Elementary School (Grades PK-6) Regular School No Elementary 01 04 2019   pk_12_total 522.0 29.0 29.0   1.0 16.0     0.0   28.0   324.0 301.0     31.0   0.0     86.0   85.0   625.0 522 29 29   1 16     0   28   324 301     31 0   86 85   625
1952168 MN Carver 10 school 2700116 4016 Charter Schools WORLD LEARNER CHARTER SCHOOL 270011602606 10 WORLD LEARNER CHARTER SCHOOL Elementary School (Grades PK-6) Regular School Yes Elementary 01 08 2019   pk_12_total 190.0 7.0 6.0   0.0 6.0     0.0   3.0   106.0 106.0     3.0   0.0     18.0   43.0   212.0 190 7 6   0 6     0   3   106 106     3 0   18 43   212
1952462 MN Ramsey 62 school 2700344 4105 Charter Schools GREAT RIVER SCHOOL 270034404665 20 Great River Elementary School Elementary School (Grades PK-6) Regular School Yes Elementary 01 06 2019   pk_12_total 219.0 18.0 21.0   5.0 25.0     1.0   5.0   136.0 158.0     2.0   0.0     32.0   36.0   294.0 219 18 21   5 25     1   5   136 158     2 0   32 36   294
1955398 MN Carlton 9 school 2709420 94 Independent Districts and Schools CLOQUET PUBLIC SCHOOL DISTRICT 270942002236 103 CLOQUET AREA ALT. ED. PROGRAMS Public Area Learning Center ALC (State approved) Alternative School No Other 01 12 2019   pk_12_total 55.0 0.0 0.0   18.0 0.0     0.0   11.0   45.0 39.0     0.0   0.0     58.0   *   84.0 55 0 0   18 0     0   11   45 39     0 0   58     84
1955402 MN Carver 10 school 2741460 110 Independent Districts and Schools WACONIA PUBLIC SCHOOL DISTRICT 274146004597 601 Waconia Learning Center Public Area Learning Center ALC (State approved) Alternative School No Other 01 12 2019   pk_12_total 39.0 2.0 8.0   0.0 1.0     0.0   1.0   34.0 17.0     2.0   0.0     18.0   12.0   51.0 39 2 8   0 1     0   1   34 17     2 0   18 12   51
1955945 MN Benton 5 school 2700143 6074 Miscellaneous Cooperatives CENTRAL MINNESOTA JT. POWERS DIST. 270014302723 647 CENTRAL MN. ALC - SAUK RAPIDS Public Area Learning Center ALC (State approved) Alternative School No Other 01 12 2019   pk_12_total 4.0 0.0 0.0   0.0 0.0     0.0   1.0   1.0 4.0     *   *         *   5.0 4 0 0   0 0     0   1   1 4                 5
1956525 MN Hennepin 27 school 2700025 287 Intermediate Districts and Schools INTERMEDIATE SCHOOL DISTRICT 287 270002503542 479 SAFE Special Education Special Education School No Other 01 12 2019   pk_12_total 11.0 13.0 4.0   1.0 0.0     0.0   4.0   26.0 7.0     0.0   1.0     18.0   *   33.0 11 13 4   1 0     0   4   26 7     0 1   18     33
1956535 MN Hennepin 27 school 2700025 287 Intermediate Districts and Schools INTERMEDIATE SCHOOL DISTRICT 287 270002503229 480 STRIVE SECONDARY Special Education Special Education School No Other 01 12 2019   pk_12_total 3.0 14.0 0.0   0.0 0.0     0.0   2.0   15.0 4.0     2.0   2.0     15.0   *   19.0 3 14 0   0 0     0   2   15 4     2 2   15     19
1956550 MN Hennepin 27 school 2700025 287 Intermediate Districts and Schools INTERMEDIATE SCHOOL DISTRICT 287 270002503234 486 CIP Special Education Special Education School No Other 01 12 2019   pk_12_total 49.0 15.0 5.0   2.0 5.0     0.0   6.0   78.0 4.0     4.0   1.0     26.0   *   82.0 49 15 5   2 5     0   6   78 4     4 1   26     82
1956565 MN Scott 70 school 2700420 288 Intermediate Districts and Schools Southwest Metro Intermediate 288 270042005038 12 SW Metro Level 4 Programs Special Education Special Education School No Other 01 12 2019   pk_12_total 96.0 22.0 6.0   3.0 4.0     0.0   2.0   108.0 25.0     0.0   0.0     69.0   *   133.0 96 22 6   3 4     0   2   108 25     0 0   69     133
1956779 MN Mille Lacs 48 school 2700318 6079 Special Education Cooperatives RUM RIVER SPECIAL EDUCATION COOP 270031804296 10 RUM RIVER NORTH Special Education Special Education School No Other 01 12 2019   pk_12_total 71.0 6.0 4.0   6.0 0.0     0.0   1.0   74.0 14.0     0.0   1.0     62.0   *   88.0 71 6 4   6 0     0   1   74 14     0 1   62     88
1956922 MN Cottonwood 17 school 2700086 991 Service Cooperative (ECSU Region) Region 6 and 8-SW/WC Service Cooperative 270008604168 16 SWWC ELC - Windom Special Education Special Education School No Other 01 12 2019   pk_12_total 43.0 5.0 4.0   0.0 0.0     0.0   2.0   44.0 10.0     0.0   0.0     39.0   *   54.0 43 5 4   0 0     0   2   44 10     0 0   39     54
1957133 MN Brown 8 school 2791353 6049 Education Districts RIVER BEND EDUCATION DISTRICT 279135304366 35 IMPRINTS PROGRAM Special Education Special Education School No Other 01 12 2019   pk_12_total 28.0 2.0 3.0   0.0 0.0     0.0   1.0   29.0 5.0     1.0   0.0     20.0   *   34.0 28 2 3   0 0     0   1   29 5     1 0   20     34
1957583 MN Hennepin 27 school 2733780 283 Independent Districts and Schools ST. LOUIS PARK PUBLIC SCHOOL DIST. 273378004332 759 MELROSE Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No Other 01 12 2019   pk_12_total 1.0 1.0 0.0   0.0 0.0     0.0   0.0   0.0 2.0     *   *         *   2.0 1 1 0   0 0     0   0   0 2                 2
1947224 MN Dakota 19 school 2715030 199 Independent Districts and Schools INVER GROVE HEIGHTS SCHOOLS 271503003184 574 ATHENEUM ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 02 05 2019   pk_12_total 74.0 8.0 6.0   0.0 26.0     0.0   3.0   62.0 55.0     0.0   0.0     17.0   9.0   117.0 74 8 6   0 26     0   3   62 55     0 0   17 9   117
1947438 MN Goodhue 25 school 2730480 256 Independent Districts and Schools RED WING PUBLIC SCHOOL DISTRICT 273048001292 537 BURNSIDE ELEMENTARY. Elementary School (Grades PK-6) Regular School No Elementary 02 04 2019   pk_12_total 404.0 20.0 46.0   10.0 2.0     0.0   46.0   264.0 264.0     14.0   0.0     174.0   88.0   528.0 404 20 46   10 2     0   46   264 264     14 0   174 88   528
1948461 MN Mcleod 43 school 2714970 423 Independent Districts and Schools HUTCHINSON PUBLIC SCHOOL DISTRICT 271497000754 10 HUTCHINSON PARK ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 02 05 2019   pk_12_total 665.0 9.0 91.0   0.0 7.0     2.0   30.0   429.0 375.0     45.0   13.0     274.0   109.0   804.0 665 9 91   0 7     2   30   429 375     45 13   274 109   804
1948719 MN Nicollet 52 school 2733870 508 Independent Districts and Schools ST. PETER PUBLIC SCHOOL DISTRICT 273387001638 30 North Elementary School Elementary School (Grades PK-6) Regular School No Elementary 02 04 2019   pk_12_total 322.0 44.0 79.0   1.0 2.0     0.0   26.0   251.0 223.0     59.0   *     169.0   76.0   474.0 322 44 79   1 2     0   26   251 223     59     169 76   474
1949035 MN Polk 60 school 2709720 593 Independent Districts and Schools CROOKSTON PUBLIC SCHOOL DISTRICT 270972000414 80 HIGHLAND ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 02 06 2019   pk_12_total 268.0 6.0 92.0   19.0 2.0     0.0   27.0   205.0 209.0     23.0   36.0     219.0   63.0   414.0 268 6 92   19 2     0   27   205 209     23 36   219 63   414
1949268 MN Washington 82 school 2742360 624 Independent Districts and Schools WHITE BEAR LAKE SCHOOL DISTRICT 274236003699 824 ONEKA ELEMENTARY SCHOOL Elementary School (Grades PK-6) Regular School No Elementary 02 05 2019   pk_12_total 552.0 18.0 24.0   1.0 26.0     0.0   43.0   353.0 311.0     21.0   4.0     138.0   87.0   664.0 552 18 24   1 26     0   43   353 311     21 4   138 87   664
1949433 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384002672 462 L'ETOILE DU NORD FRENCH IMMERSION U Elementary School (Grades PK-6) Regular School No Elementary 02 05 2019   pk_12_total 163.0 59.0 41.0   1.0 11.0     0.0   29.0   121.0 183.0     38.0   0.0     92.0   14.0   304.0 163 59 41   1 11     0   29   121 183     38 0   92 14   304
1951444 MN Pipestone 59 school 2700108 2689 Independent Districts and Schools PIPESTONE AREA SCHOOL DISTRICT 270010801262 3 HILL ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 02 04 2019   pk_12_total 168.0 8.0 45.0   1.0 2.0     0.0   17.0   119.0 122.0     31.0   2.0     146.0   31.0   241.0 168 8 45   1 2     0   17   119 122     31 2   146 31   241
1952102 MN Wright 86 school 2700413 6090 Special Education Cooperatives Sherburne and Northern Wright Special Education Cooperative 270041305084 50 Little Mountain Elementary - SNW Elementary School (Grades PK-6) Regular School No Elementary 02 05 2019   pk_12_total 5.0 0.0 0.0   0.0 0.0     0.0   2.0   6.0 1.0     *   *         *   7.0 5 0 0   0 0     0   2   6 1                 7
1956334 MN Scott 70 school 2723430 721 Independent Districts and Schools NEW PRAGUE AREA SCHOOLS 272343003677 510 CENTRAL EDUCATION CAMPUS Special Education Special Education School No Elementary 02 03 2019   pk_12_total 74.0 2.0 6.0   2.0 0.0     1.0   0.0   51.0 34.0     0.0   0.0     19.0   *   85.0 74 2 6   2 0     1   0   51 34     0 0   19     85
1956348 MN Sherburne 71 school 2711370 728 Independent Districts and Schools ELK RIVER PUBLIC SCHOOL DISTRICT 271137004142 401 ISD 728 FOCUS/JOURNEY Special Education Special Education School No Other 02 12 2019   pk_12_total 17.0 2.0 3.0   0.0 0.0     0.0   3.0   24.0 1.0     0.0   0.0     12.0   *   25.0 17 2 3   0 0     0   3   24 1     0 0   12     25
1956552 MN Scott 70 school 2700420 288 Intermediate Districts and Schools Southwest Metro Intermediate 288 270042005063 11 SW Shakopee Special Ed Special Education Special Education School No Other 02 12 2019   pk_12_total 31.0 4.0 1.0   1.0 0.0     0.0   0.0   18.0 19.0     0.0   0.0     3.0   *   37.0 31 4 1   1 0     0   0   18 19     0 0   3     37
1956691 MN Dakota 19 school 2700026 917 Intermediate Districts and Schools INTERMEDIATE SCHOOL DISTRICT 917 270002605108 900 Customized Alternative Solutions for Education (CASE) Special Education Special Education School No Other 02 12 2019   pk_12_total 5.0 2.0 0.0   0.0 1.0     0.0   1.0   9.0 0.0     *   *         *   9.0 5 2 0   0 1     0   1   9 0                 9
1957007 MN Otter Tail 56 school 2700014 6004 Education Districts FRESHWATER ED. DIST. 270001404821 50 Elm Tree Academy Special Education Special Education School No Other 02 12 2019   pk_12_total 4.0 0.0 0.0   0.0 0.0     0.0   0.0   4.0 0.0     *   *         *   4.0 4 0 0   0 0     0   0   4 0                 4
1957148 MN Brown 8 school 2791353 6049 Education Districts RIVER BEND EDUCATION DISTRICT 279135305192 55 Raptor Program Special Education Special Education School No Other 02 12 2019   pk_12_total 1.0 0.0 0.0   0.0 0.0     0.0   0.0   1.0 0.0     *   *         *   1.0 1 0 0   0 0     0   0   1 0                 1
1957661 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384001334 678 JUVENILE SERVICE CENTER Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No Other 02 12 2019   pk_12_total 0.0 17.0 3.0   0.0 2.0     0.0   1.0   20.0 3.0     0.0   0.0         10.0   23.0 0 17 3   0 2     0   1   20 3     0 0     10   23
1946273 MN Beltrami 4 school 2704440 31 Independent Districts and Schools BEMIDJI PUBLIC SCHOOL DISTRICT 270444005094 11 Gene Dillon Elementary School Elementary School (Grades PK-6) Regular School No Elementary 03 05 2019   pk_12_total 558.0 11.0 15.0   168.0 2.0     0.0   84.0   460.0 378.0     0.0   8.0     428.0   156.0   838.0 558 11 15   168 2     0   84   460 378     0 8   428 156   838
1947750 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 2019   pk_12_total 567.0 6.0 37.0   2.0 11.0     0.0   29.0   350.0 302.0     13.0   0.0     57.0   81.0   652.0 567 6 37   2 11     0   29   350 302     13 0   57 81   652
1948437 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 2019   pk_12_total 210.0 33.0 58.0   1.0 42.0     0.0   21.0   195.0 170.0     88.0   0.0     205.0   64.0   365.0 210 33 58   1 42     0   21   195 170     88 0   205 64   365
1948500 MN Marshall 45 school 2723550 441 Independent Districts and Schools MARSHALL COUNTY CENTRAL SCHOOLS 272355001158 10 NEWFOLDEN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 03 06 2019   pk_12_total 137.0 1.0 1.0   0.0 0.0     0.0   2.0   70.0 71.0     0.0   0.0     52.0   22.0   141.0 137 1 1   0 0     0   2   70 71     0 0   52 22   141
1948574 MN Mille Lacs 48 school 2730030 477 Independent Districts and Schools PRINCETON PUBLIC SCHOOL DISTRICT 273003001271 10 Princeton Intermediate School Elementary School (Grades PK-6) Regular School No Elementary 03 05 2019   pk_12_total 691.0 2.0 25.0   3.0 4.0     0.0   14.0   369.0 370.0     5.0   17.0     236.0   99.0   739.0 691 2 25   3 4     0   14   369 370     5 17   236 99   739
1948750 MN Olmsted 55 school 2707350 531 Independent Districts and Schools BYRON PUBLIC SCHOOL DISTRICT 270735000306 10 Byron Intermediate School Elementary School (Grades PK-6) Regular School No Elementary 03 05 2019   pk_12_total 424.0 3.0 13.0   4.0 9.0     0.0   20.0   240.0 233.0     5.0   0.0     49.0   47.0   473.0 424 3 13   4 9     0   20   240 233     5 0   49 47   473
1948767 MN Olmsted 55 school 2738160 534 Independent Districts and Schools STEWARTVILLE PUBLIC SCHOOL DISTRICT 273816001652 10 Bear Cave Intermediate School Elementary School (Grades PK-6) Regular School No Elementary 03 05 2019   pk_12_total 478.0 2.0 19.0   1.0 4.0     0.0   18.0   282.0 240.0     2.0   2.0     122.0   89.0   522.0 478 2 19   1 4     0   18   282 240     2 2   122 89   522
1948842 MN Olmsted 55 school 2731800 535 Independent Districts and Schools ROCHESTER PUBLIC SCHOOL DISTRICT 273180001001 134 HOOVER ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 03 05 2019   pk_12_total 150.0 16.0 17.0   0.0 19.0     0.0   16.0   114.0 104.0     17.0   0.0     68.0   43.0   218.0 150 16 17   0 19     0   16   114 104     17 0   68 43   218
1948915 MN Otter Tail 56 school 2711880 544 Independent Districts and Schools FERGUS FALLS PUBLIC SCHOOL DISTRICT 271188000574 140 CLEVELAND ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 03 04 2019   pk_12_total 348.0 15.0 11.0   2.0 1.0     2.0   14.0   192.0 201.0     7.0   0.0     148.0   47.0   393.0 348 15 11   2 1     2   14   192 201     7 0   148 47   393
1949039 MN Polk 60 school 2711130 595 Independent Districts and Schools EAST GRAND FORKS PUBLIC SCHOOL DIST 271113000495 110 SOUTH POINT ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 03 05 2019   pk_12_total 364.0 46.0 46.0   8.0 0.0     0.0   14.0   246.0 232.0     43.0   1.0     178.0   69.0   478.0 364 46 46   8 0     0   14   246 232     43 1   178 69   478
1949842 MN Saint Louis 69 school 2713980 701 Independent Districts and Schools HIBBING PUBLIC SCHOOL DISTRICT 271398001529 310 Lincoln Elementary Elementary School (Grades PK-6) Regular School No Elementary 03 06 2019   pk_12_total 645.0 17.0 15.0   11.0 5.0     3.0   50.0   373.0 373.0     0.0   1.0     356.0   142.0   746.0 645 17 15   11 5     3   50   373 373     0 1   356 142   746
1949861 MN Saint Louis 69 school 2741040 706 Independent Districts and Schools VIRGINIA PUBLIC SCHOOL DISTRICT 274104001716 30 ROOSEVELT ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 03 06 2019   pk_12_total 427.0 11.0 18.0   11.0 3.0     0.0   48.0   290.0 228.0     0.0   1.0     206.0   80.0   518.0 427 11 18   11 3     0   48   290 228     0 1   206 80   518
1949963 MN Scott 70 school 2704050 716 Independent Districts and Schools BELLE PLAINE PUBLIC SCHOOL DISTRICT 270405003718 11 OAK CREST ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 03 06 2019   pk_12_total 428.0 7.0 27.0   1.0 6.0     1.0   21.0   247.0 244.0     6.0   0.0     94.0   73.0   491.0 428 7 27   1 6     1   21   247 244     6 0   94 73   491
1950078 MN Sherburne 71 school 2703870 726 Independent Districts and Schools BECKER PUBLIC SCHOOL DISTRICT 270387000179 10 BECKER INTERMEDIATE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 03 05 2019   pk_12_total 599.0 5.0 25.0   1.0 3.0     0.0   29.0   340.0 322.0     7.0   5.0     133.0   95.0   662.0 599 5 25   1 3     0   29   340 322     7 5   133 95   662
1950087 MN Sherburne 71 school 2705460 727 Independent Districts and Schools BIG LAKE PUBLIC SCHOOL DISTRICT 270546000205 10 INDEPENDENCE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 03 05 2019   pk_12_total 585.0 16.0 43.0   5.0 13.0     0.0   37.0   366.0 333.0     18.0   0.0     177.0   110.0   699.0 585 16 43   5 13     0   37   366 333     18 0   177 110   699
1950137 MN Sherburne 71 school 2711370 728 Independent Districts and Schools ELK RIVER PUBLIC SCHOOL DISTRICT 271137004141 210 WESTWOOD ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 03 05 2019   pk_12_total 517.0 2.0 15.0   0.0 7.0     0.0   29.0   297.0 273.0     5.0   0.0     134.0   85.0   570.0 517 2 15   0 7     0   29   297 273     5 0   134 85   570
1950549 MN Washington 82 school 2718750 832 Independent Districts and Schools MAHTOMEDI PUBLIC SCHOOL DISTRICT 271875000868 10 O.H. ANDERSON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 03 05 2019   pk_12_total 563.0 31.0 28.0   0.0 15.0     0.0   45.0   340.0 342.0     16.0   1.0     68.0   91.0   682.0 563 31 28   0 15     0   45   340 342     16 1   68 91   682
1950955 MN Isanti 30 school 2707410 911 Independent Districts and Schools CAMBRIDGE-ISANTI PUBLIC SCHOOL DIST 270741003657 201 CAMBRIDGE INTERMEDIATE SCHOOL Elementary School (Grades PK-6) Regular School No Elementary 03 05 2019   pk_12_total 509.0 8.0 7.0   3.0 14.0     0.0   38.0   291.0 288.0     8.0   4.0     206.0   118.0   579.0 509 8 7   3 14     0   38   291 288     8 4   206 118   579
1950959 MN Isanti 30 school 2707410 911 Independent Districts and Schools CAMBRIDGE-ISANTI PUBLIC SCHOOL DIST 270741003705 202 ISANTI INTERMEDIATE SCHOOL Elementary School (Grades PK-6) Regular School No Elementary 03 05 2019   pk_12_total 409.0 3.0 16.0   1.0 7.0     0.0   24.0   244.0 216.0     6.0   5.0     125.0   70.0   460.0 409 3 16   1 7     0   24   244 216     6 5   125 70   460
1951091 MN Chisago 13 school 2700017 2144 Independent Districts and Schools CHISAGO LAKES SCHOOL DISTRICT 270001701673 2 LAKESIDE EL. Elementary School (Grades PK-6) Regular School No Elementary 03 05 2019   pk_12_total 554.0 2.0 16.0   0.0 8.0     0.0   15.0   306.0 289.0     4.0   0.0     116.0   70.0   595.0 554 2 16   0 8     0   15   306 289     4 0   116 70   595
1951370 MN Martin 46 school 2718960 2448 Independent Districts and Schools MARTIN COUNTY WEST SCHOOL DISTRICT 271896000072 15 TRIMONT ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 03 06 2019   pk_12_total 215.0 1.0 11.0   1.0 0.0     0.0   15.0   127.0 116.0     0.0   0.0     109.0   45.0   243.0 215 1 11   1 0     0   15   127 116     0 0   109 45   243
1951503 MN Wabasha 79 school 2745735 2805 Independent Districts and Schools ZUMBROTA-MAZEPPA SCHOOL DISTRICT 274573500200 1 ZUMBROTA-MAZEPPA ELEMENTARY SCHOOL Elementary School (Grades PK-6) Regular School No Elementary 03 06 2019   pk_12_total 356.0 3.0 12.0   1.0 3.0     0.0   8.0   217.0 166.0     2.0   5.0     83.0   65.0   383.0 356 3 12   1 3     0   8   217 166     2 5   83 65   383
1951560 MN Mcleod 43 school 2700128 2859 Independent Districts and Schools GLENCOE-SILVER LAKE SCHOOL DISTRICT 270012801444 30 LAKESIDE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 03 06 2019   pk_12_total 345.0 1.0 102.0   2.0 0.0     0.0   15.0   236.0 229.0     39.0   2.0     187.0   87.0   465.0 345 1 102   2 0     0   15   236 229     39 2   187 87   465
1951811 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124004742 132 Howe Elementary Elementary School (Grades PK-6) Regular School No Elementary 03 05 2019   pk_12_total 133.0 31.0 30.0   8.0 6.0     1.0   15.0   120.0 104.0     21.0   1.0     83.0   33.0   224.0 133 31 30   8 6     1   15   120 104     21 1   83 33   224
1951818 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124000988 134 LK NOKOMIS COMM-KEEWAYDIN CAMPUS Elementary School (Grades PK-6) Regular School No Middle 03 08 2019   pk_12_total 266.0 79.0 72.0   10.0 16.0     1.0   19.0   230.0 233.0     38.0   6.0     210.0   77.0   463.0 266 79 72   10 16     1   19   230 233     38 6   210 77   463
1953643 MN Mille Lacs 48 school 2725050 480 Independent Districts and Schools ONAMIA PUBLIC SCHOOL DISTRICT 272505005107 50 Onamia Intermediate School Middle School (Grades 5-8) Regular School No Other 03 09 2019   pk_12_total 97.0 11.0 11.0   183.0 0.0     1.0   25.0   165.0 163.0     0.0   9.0     225.0   84.0   328.0 97 11 11   183 0     1   25   165 163     0 9   225 84   328
1957233 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000002 464 ANTHONY LOUIS HOUSE Hospital/Medical/Partial Hospitalization Program Alternative School No Other 03 12 2019   pk_12_total 12.0 3.0 1.0   1.0 0.0     0.0   0.0   11.0 6.0     0.0   0.0     7.0   5.0   17.0 12 3 1   1 0     0   0   11 6     0 0   7 5   17
1957261 MN Saint Louis 69 school 2711040 709 Independent Districts and Schools DULUTH PUBLIC SCHOOL DISTRICT 271104001600 630 SUPERIOR ACADEMY Hospital/Medical/Partial Hospitalization Program Alternative School No Other 03 12 2019   pk_12_total 9.0 0.0 0.0   0.0 0.0     0.0   2.0   4.0 7.0     0.0   1.0     7.0   2.0   11.0 9 0 0   0 0     0   2   4 7     0 1   7 2   11
1957334 MN Anoka 2 school 2733540 15 Independent Districts and Schools St. Francis Area Schools 273354004917 15 Saints Online Distance Learning Program OLL (State approved) Regular School No Other 03 12 2019   pk_12_total 41.0 1.0 0.0   1.0 1.0     0.0   1.0   20.0 25.0     0.0   0.0     17.0   7.0   45.0 41 1 0   1 1     0   1   20 25     0 0   17 7   45
1957541 MN Beltrami 4 school 2704440 31 Independent Districts and Schools BEMIDJI PUBLIC SCHOOL DISTRICT 270444000313 160 FIRST CITY SCHOOL Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No Other 03 12 2019   pk_12_total 13.0 1.0 1.0   25.0 0.0     0.0   1.0   30.0 11.0     1.0   0.0         16.0   41.0 13 1 1   25 0     0   1   30 11     1 0     16   41
1957565 MN Clay 14 school 2721420 152 Independent Districts and Schools MOORHEAD PUBLIC SCHOOL DISTRICT 272142002799 970 West Central Academy-N Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No Other 03 12 2019   pk_12_total 7.0 0.0 1.0   1.0 0.0     0.0   3.0   5.0 7.0     0.0   0.0         6.0   12.0 7 0 1   1 0     0   3   5 7     0 0     6   12
1957843 MN Crow Wing 18 school 2706090 181 Independent Districts and Schools BRAINERD PUBLIC SCHOOL DISTRICT 270609000468 17 LINCOLN EDUCATION CENTER Miscellaneous Program (assignment is now limited) Alternative School No Other 03 12 2019   pk_12_total 48.0 3.0 1.0   4.0 3.0     0.0   3.0   51.0 11.0     *   4.0     51.0   53.0   62.0 48 3 1   4 3     0   3   51 11       4   51 53   62
1946385 MN Benton 5 school 2712240 51 Independent Districts and Schools FOLEY PUBLIC SCHOOL DISTRICT 271224002270 30 FOLEY INTERMEDIATE ELEMENTARY Elementary School (Grades PK-6) Regular School No Middle 04 08 2019   pk_12_total 726.0 3.0 8.0   3.0 1.0     1.0   12.0   392.0 362.0     1.0   2.0     214.0   104.0   754.0 726 3 8   3 1     1   12   392 362     1 2   214 104   754
1946978 MN Dakota 19 school 2711820 192 Independent Districts and Schools FARMINGTON PUBLIC SCHOOL DISTRICT 271182004816 155 Gateway Academy Elementary School (Grades PK-6) Regular School No Middle 04 08 2019   pk_12_total 27.0 2.0 2.0   0.0 1.0     0.0   4.0   29.0 7.0     *   0.0         *   36.0 27 2 2   0 1     0   4   29 7       0         36
1948016 MN Hennepin 27 school 2731780 281 Independent Districts and Schools ROBBINSDALE PUBLIC SCHOOL DISTRICT 273178004952 401 The FAIR School - Crystal Elementary School (Grades PK-6) Regular School No Middle 04 08 2019   pk_12_total 109.0 189.0 38.0   9.0 8.0     0.0   46.0   172.0 227.0     19.0   9.0     259.0   50.0   399.0 109 189 38   9 8     0   46   172 227     19 9   259 50   399
1949804 MN Saint Louis 69 school 2708910 695 Independent Districts and Schools CHISHOLM PUBLIC SCHOOL DISTRICT 270891000356 301 CHISHOLM ELEMENTARY Elementary School (Grades PK-6) Regular School No Middle 04 06 2019   pk_12_total 164.0 6.0 2.0   6.0 0.0     0.0   4.0   94.0 88.0     0.0   0.0     86.0   30.0   182.0 164 6 2   6 0     0   4   94 88     0 0   86 30   182
1950496 MN Waseca 81 school 2741880 829 Independent Districts and Schools WASECA PUBLIC SCHOOL DISTRICT 274188001746 40 WASECA INTERMEDIATE SCHOOL Elementary School (Grades PK-6) Regular School No Middle 04 06 2019   pk_12_total 346.0 16.0 38.0   0.0 4.0     0.0   19.0   215.0 208.0     15.0   *     159.0   70.0   423.0 346 16 38   0 4     0   19   215 208     15     159 70   423
1950508 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 Middle 04 06 2019   pk_12_total 295.0 10.0 20.0   4.0 16.0     1.0   25.0   190.0 181.0     11.0   7.0     136.0   64.0   371.0 295 10 20   4 16     1   25   190 181     11 7   136 64   371
1950716 MN Washington 82 school 2738190 834 Independent Districts and Schools STILLWATER AREA PUBLIC SCHOOL DIST. 273819005119 798 GATE 4/5 Elementary School (Grades PK-6) Regular School No Elementary 04 05 2019   pk_12_total 35.0 1.0 0.0   0.0 9.0     0.0   3.0   28.0 20.0     0.0   0.0         *   48.0 35 1 0   0 9     0   3   28 20     0 0         48
1951359 MN Sibley 72 school 2718070 2397 Independent Districts and Schools LE SUEUR-HENDERSON SCHOOL DISTRICT 271807000046 15 HILLTOP ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 04 05 2019   pk_12_total 105.0 3.0 26.0   0.0 0.0     0.0   9.0   80.0 63.0     *   *         *   143.0 105 3 26   0 0     0   9   80 63                 143
1951657 MN Wabasha 79 school 2700287 2899 Independent Districts and Schools PLAINVIEW-ELGIN-MILLVILLE 270028703667 20 PLAINVIEW-ELGIN-MILLVILLE 4-6 Elementary School (Grades PK-6) Regular School No Middle 04 06 2019   pk_12_total 311.0 3.0 31.0   1.0 0.0     0.0   7.0   174.0 179.0     10.0   0.0     98.0   60.0   353.0 311 3 31   1 0     0   7   174 179     10 0   98 60   353
1951744 MN Douglas 21 school 2700382 2908 Independent Districts and Schools BRANDON-EVANSVILLE PUBLIC SCHOOLS 270038204739 2 Evansville Elementary Elementary School (Grades PK-6) Regular School No Elementary 04 05 2019   pk_12_total 72.0 0.0 1.0   0.0 0.0     0.0   1.0   39.0 35.0     0.0   0.0     30.0   7.0   74.0 72 0 1   0 0     0   1   39 35     0 0   30 7   74
1951797 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124000969 121 LAKE HARRIET UPPER SCHOOL Elementary School (Grades PK-6) Regular School No Middle 04 08 2019   pk_12_total 541.0 17.0 24.0   0.0 35.0     0.0   17.0   316.0 318.0     18.0   0.0     44.0   52.0   634.0 541 17 24   0 35     0   17   316 318     18 0   44 52   634
1953349 MN Chippewa 12 school 2721320 129 Independent Districts and Schools MONTEVIDEO PUBLIC SCHOOL DISTRICT 272132001071 30 MONTEVIDEO MIDDLE Middle School (Grades 5-8) Regular School No Middle 04 07 2019   pk_12_total 322.0 6.0 86.0   3.0 1.0     3.0   17.0   218.0 220.0     28.0   1.0     190.0   87.0   438.0 322 6 86   3 1     3   17   218 220     28 1   190 87   438
1953369 MN Cottonwood 17 school 2742780 177 Independent Districts and Schools WINDOM PUBLIC SCHOOL DISTRICT 274278003068 60 WINDOM MIDDLE Middle School (Grades 5-8) Regular School No Middle 04 08 2019   pk_12_total 284.0 9.0 90.0   0.0 10.0     6.0   17.0   236.0 180.0     27.0   0.0     186.0   87.0   416.0 284 9 90   0 10     6   17   236 180     27 0   186 87   416
1953716 MN Otter Tail 56 school 2711880 544 Independent Districts and Schools FERGUS FALLS PUBLIC SCHOOL DISTRICT 271188004944 380 Kennedy Middle School Middle School (Grades 5-8) Regular School No Middle 04 08 2019   pk_12_total 689.0 20.0 25.0   4.0 0.0     2.0   36.0   385.0 391.0     9.0   1.0     260.0   92.0   776.0 689 20 25   4 0     2   36   385 391     9 1   260 92   776
1953950 MN Wright 86 school 2710170 879 Independent Districts and Schools DELANO PUBLIC SCHOOL DISTRICT 271017000437 15 Delano Intermediate School Middle School (Grades 5-8) Regular School No Middle 04 06 2019   pk_12_total 546.0 4.0 12.0   0.0 7.0     0.0   25.0   295.0 299.0     8.0   1.0     67.0   87.0   594.0 546 4 12   0 7     0   25   295 299     8 1   67 87   594
1953993 MN Pope 61 school 2700019 2149 Independent Districts and Schools MINNEWASKA SCHOOL DISTRICT 270001903535 60 Minnewaska Area Intermediate School Middle School (Grades 5-8) Regular School No Middle 04 06 2019   pk_12_total 292.0 3.0 4.0   0.0 4.0     0.0   6.0   175.0 134.0     0.0   0.0     91.0   59.0   309.0 292 3 4   0 4     0   6   175 134     0 0   91 59   309
1954002 MN Morrison 49 school 2733900 2170 Independent Districts and Schools STAPLES-MOTLEY SCHOOL DISTRICT 273390002468 50 MOTLEY-STAPLES MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 04 07 2019   pk_12_total 285.0 0.0 13.0   6.0 2.0     0.0   15.0   173.0 148.0     1.0   14.0     173.0   55.0   321.0 285 0 13   6 2     0   15   173 148     1 14   173 55   321
1957559 MN Clay 14 school 2721420 152 Independent Districts and Schools MOORHEAD PUBLIC SCHOOL DISTRICT 272142000413 960 West Central Academy-S Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No Other 04 12 2019   pk_12_total 16.0 3.0 0.0   2.0 0.0     0.0   1.0   21.0 1.0     0.0   0.0         9.0   22.0 16 3 0   2 0     0   1   21 1     0 0     9   22

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