Data source: Big Local News · About: Big Local

2,294 rows where grade = "pk_12_total", state = "MN" and year = 2017 sorted by ccd_school_high_grade

View and edit SQL

year

  • 2017 · 2,294

grade

  • pk_12_total · 2,294
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
690910 MN Beltrami 4 school 2704440 31 Independent Districts and Schools BEMIDJI PUBLIC SCHOOL DISTRICT 270444004454 30 PAUL BUNYAN CENTER Elementary School (Grades PK-6) Regular School No Elementary PK 01 2017   pk_12_total 174.0 2.0 4.0   19.0 2.0     0.0   12.0   115.0 98.0         0.0     88.0   27.0   213.0 174 2 4   19 2     0   12   115 98       0   88 27   213
693037 MN Mcleod 43 school 2714970 423 Independent Districts and Schools HUTCHINSON PUBLIC SCHOOL DISTRICT 271497002198 60 HUTCHINSON WEST ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 01 2017   pk_12_total 403.0 7.0 37.0   0.0 2.0     1.0   15.0   238.0 227.0     21.0   2.0     169.0   113.0   465.0 403 7 37   0 2     1   15   238 227     21 2   169 113   465
693491 MN Otter Tail 56 school 2711880 544 Independent Districts and Schools FERGUS FALLS PUBLIC SCHOOL DISTRICT 271188000581 180 MCKINLEY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 01 2017   pk_12_total 213.0 7.0 6.0   1.0 0.0     2.0   6.0   117.0 118.0         0.0     97.0   18.0   235.0 213 7 6   1 0     2   6   117 118       0   97 18   235
693599 MN Polk 60 school 2709720 593 Independent Districts and Schools CROOKSTON PUBLIC SCHOOL DISTRICT 270972000416 10 WASHINGTON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 01 2017   pk_12_total 106.0 10.0 38.0   6.0 0.0     0.0   5.0   85.0 80.0     10.0   17.0     95.0   28.0   165.0 106 10 38   6 0     0   5   85 80     10 17   95 28   165
693834 MN Washington 82 school 2742360 624 Independent Districts and Schools WHITE BEAR LAKE SCHOOL DISTRICT 274236004409 830 HUGO ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 01 2017   pk_12_total 283.0 7.0 9.0   0.0 11.0     0.0   25.0   190.0 145.0     10.0   0.0     49.0   36.0   335.0 283 7 9   0 11     0   25   190 145     10 0   49 36   335
695962 MN Pipestone 59 school 2700108 2689 Independent Districts and Schools PIPESTONE AREA SCHOOL DISTRICT 270010801261 2 BROWN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 01 2017   pk_12_total 135.0 7.0 42.0   0.0 3.0     0.0   15.0   109.0 93.0     27.0   0.0     108.0   44.0   202.0 135 7 42   0 3     0   15   109 93     27 0   108 44   202
697308 MN Hennepin 27 school 2700308 4191 Charter Schools KIPP MINNESOTA CHARTER SCHOOL 270030804898 30 KIPP North Star Primary Elementary School (Grades PK-6) Regular School Yes Elementary KG 01 2017   pk_12_total 1.0 64.0 0.0   1.0 1.0     0.0   0.0   30.0 37.0     0.0   5.0         4.0   67.0 1 64 0   1 1     0   0   30 37     0 5     4   67
697553 MN Hennepin 27 school 2700435 4249 Charter Schools Sankofa Underground North Academy 270043504976 10 Sankofa Underground North Academy Elementary School (Grades PK-6) Regular School Yes Elementary KG 01 2017   pk_12_total 1.0 40.0 2.0   0.0 0.0     0.0   4.0   29.0 18.0     0.0   0.0     33.0   0.0   47.0 1 40 2   0 0     0   4   29 18     0 0   33 0   47
701093 MN Washington 82 school 2702264 916 Intermediate Districts and Schools NORTHEAST METRO 916 270226403259 20 A/O PROGRAM Special Education Special Education School No Elementary PK 01 2017   pk_12_total 6.0 0.0 2.0   0.0 3.0     0.0   0.0   8.0 3.0     0.0   0.0     1.0   *   11.0 6 0 2   0 3     0   0   8 3     0 0   1     11
692056 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   pk_12_total 323.0 10.0 35.0   9.0 1.0     0.0   33.0   192.0 219.0     9.0   8.0     145.0   54.0   411.0 323 10 35   9 1     0   33   192 219     9 8   145 54   411
692353 MN Hennepin 27 school 2725080 278 Independent Districts and Schools ORONO PUBLIC SCHOOL DISTRICT 272508001200 661 SCHUMANN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 02 2017   pk_12_total 498.0 7.0 22.0   1.0 9.0     0.0   18.0   315.0 240.0     21.0   5.0     49.0   45.0   555.0 498 7 22   1 9     0   18   315 240     21 5   49 45   555
692852 MN Kanabec 33 school 2721480 332 Independent Districts and Schools MORA PUBLIC SCHOOL DISTRICT 272148001095 20 FAIRVIEW ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 02 2017   pk_12_total 364.0 3.0 8.0   7.0 1.0     0.0   15.0   214.0 184.0     0.0   3.0     196.0   104.0   398.0 364 3 8   7 1     0   15   214 184     0 3   196 104   398
693008 MN Lyon 42 school 2718940 413 Independent Districts and Schools MARSHALL PUBLIC SCHOOL DISTRICT 271894000891 2 PARK SIDE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 02 2017   pk_12_total 347.0 72.0 107.0   2.0 60.0     0.0   27.0   335.0 280.0     146.0   2.0     331.0   148.0   615.0 347 72 107   2 60     0   27   335 280     146 2   331 148   615
693077 MN Marshall 45 school 2723550 441 Independent Districts and Schools MARSHALL COUNTY CENTRAL SCHOOLS 272355001159 30 VIKING ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 02 2017   pk_12_total 88.0 2.0 2.0   0.0 0.0     0.0   1.0   51.0 42.0     0.0   0.0     40.0   12.0   93.0 88 2 2   0 0     0   1   51 42     0 0   40 12   93
693142 MN Mille Lacs 48 school 2730030 477 Independent Districts and Schools PRINCETON PUBLIC SCHOOL DISTRICT 273003001274 1 Princeton Primary School Elementary School (Grades PK-6) Regular School No Elementary PK 02 2017   pk_12_total 694.0 2.0 26.0   9.0 3.0     0.0   12.0   401.0 345.0     3.0   3.0     246.0   141.0   746.0 694 2 26   9 3     0   12   401 345     3 3   246 141   746
693298 MN Nicollet 52 school 2733870 508 Independent Districts and Schools ST. PETER PUBLIC SCHOOL DISTRICT 273387001639 50 South Early Learning Center Elementary School (Grades PK-6) Regular School No Elementary PK 02 2017   pk_12_total 322.0 39.0 71.0   3.0 2.0     0.0   23.0   239.0 221.0     45.0   10.0     202.0   70.0   460.0 322 39 71   3 2     0   23   239 221     45 10   202 70   460
693330 MN Olmsted 55 school 2707350 531 Independent Districts and Schools BYRON PUBLIC SCHOOL DISTRICT 270735004958 60 Byron Primary School Elementary School (Grades PK-6) Regular School No Elementary PK 02 2017   pk_12_total 445.0 3.0 13.0   2.0 11.0     0.0   17.0   264.0 227.0     5.0   1.0     60.0   72.0   491.0 445 3 13   2 11     0   17   264 227     5 1   60 72   491
693346 MN Olmsted 55 school 2738160 534 Independent Districts and Schools STEWARTVILLE PUBLIC SCHOOL DISTRICT 273816001651 11 BONNER ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 02 2017   pk_12_total 442.0 3.0 20.0   1.0 3.0     0.0   21.0   239.0 251.0     10.0   1.0     100.0   51.0   490.0 442 3 20   1 3     0   21   239 251     10 1   100 51   490
693367 MN Olmsted 55 school 2731800 535 Independent Districts and Schools ROCHESTER PUBLIC SCHOOL DISTRICT 273180000987 116 CHURCHILL ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 02 2017   pk_12_total 158.0 24.0 19.0   1.0 24.0     0.0   11.0   124.0 113.0     21.0   7.0     67.0   49.0   237.0 158 24 19   1 24     0   11   124 113     21 7   67 49   237
693484 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 2017   pk_12_total 308.0 11.0 9.0   2.0 1.0     2.0   12.0   174.0 171.0         0.0     132.0   21.0   345.0 308 11 9   2 1     2   12   174 171       0   132 21   345
693614 MN Polk 60 school 2711130 595 Independent Districts and Schools EAST GRAND FORKS PUBLIC SCHOOL DIST 271113000497 120 NEW HEIGHTS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 02 2017   pk_12_total 356.0 57.0 53.0   9.0 0.0     0.0   15.0   266.0 224.0     27.0   2.0     193.0   80.0   490.0 356 57 53   9 0     0   15   266 224     27 2   193 80   490
693967 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384004682 463 L'etoile Du Nord French Immersion L Elementary School (Grades PK-6) Regular School No Elementary KG 02 2017   pk_12_total 91.0 37.0 19.0   1.0 5.0     0.0   20.0   67.0 106.0     39.0   1.0     69.0   9.0   173.0 91 37 19   1 5     0   20   67 106     39 1   69 9   173
694327 MN Saint Louis 69 school 2713980 701 Independent Districts and Schools HIBBING PUBLIC SCHOOL DISTRICT 271398001520 140 GREENHAVEN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 02 2017   pk_12_total 285.0 5.0 6.0   5.0 2.0     2.0   13.0   155.0 163.0     0.0   1.0     154.0   79.0   318.0 285 5 6   5 2     2   13   155 163     0 1   154 79   318
694331 MN Saint Louis 69 school 2713980 701 Independent Districts and Schools HIBBING PUBLIC SCHOOL DISTRICT 271398001528 160 WASHINGTON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 02 2017   pk_12_total 244.0 3.0 5.0   3.0 1.0     1.0   28.0   158.0 127.0     1.0   3.0     147.0   52.0   285.0 244 3 5   3 1     1   28   158 127     1 3   147 52   285
694361 MN Saint Louis 69 school 2741040 706 Independent Districts and Schools VIRGINIA PUBLIC SCHOOL DISTRICT 274104002552 112 PARKVIEW ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 02 2017   pk_12_total 342.0 11.0 19.0   10.0 1.0     0.0   49.0   252.0 180.0     1.0   0.0     203.0   85.0   432.0 342 11 19   10 1     0   49   252 180     1 0   203 85   432
694450 MN Scott 70 school 2704050 716 Independent Districts and Schools BELLE PLAINE PUBLIC SCHOOL DISTRICT 270405000183 10 CHATFIELD ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 02 2017   pk_12_total 347.0 2.0 19.0   1.0 2.0     1.0   17.0   210.0 179.0     3.0   *     76.0   41.0   389.0 347 2 19   1 2     1   17   210 179     3     76 41   389
694466 MN Scott 70 school 2730060 719 Independent Districts and Schools PRIOR LAKE-SAVAGE AREA SCHOOLS 273006003449 9 EDGEWOOD ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 02 2017   pk_12_total 263.0 4.0 38.0   1.0 6.0     0.0   9.0   149.0 172.0     9.0   0.0         123.0   321.0 263 4 38   1 6     0   9   149 172     9 0     123   321
694575 MN Sherburne 71 school 2703870 726 Independent Districts and Schools BECKER PUBLIC SCHOOL DISTRICT 270387003092 40 BECKER PRIMARY Elementary School (Grades PK-6) Regular School No Elementary PK 02 2017   pk_12_total 615.0 7.0 18.0   1.0 2.0     0.0   29.0   357.0 315.0     8.0   7.0     133.0   98.0   672.0 615 7 18   1 2     0   29   357 315     8 7   133 98   672
694622 MN Sherburne 71 school 2711370 728 Independent Districts and Schools ELK RIVER PUBLIC SCHOOL DISTRICT 271137000522 200 ZIMMERMAN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 02 2017   pk_12_total 482.0 3.0 8.0   0.0 4.0     0.0   23.0   286.0 234.0     9.0   1.0     147.0   81.0   520.0 482 3 8   0 4     0   23   286 234     9 1   147 81   520
695040 MN Washington 82 school 2718750 832 Independent Districts and Schools MAHTOMEDI PUBLIC SCHOOL DISTRICT 271875000871 20 WILDWOOD ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 02 2017   pk_12_total 440.0 22.0 19.0   0.0 10.0     0.0   30.0   264.0 257.0     17.0   0.0     47.0   65.0   521.0 440 22 19   0 10     0   30   264 257     17 0   47 65   521
695451 MN Isanti 30 school 2707410 911 Independent Districts and Schools CAMBRIDGE-ISANTI PUBLIC SCHOOL DIST 270741003638 101 CAMBRIDGE PRIMARY SCHOOL Elementary School (Grades PK-6) Regular School No Elementary PK 02 2017   pk_12_total 556.0 7.0 22.0   3.0 9.0     1.0   39.0   336.0 301.0     15.0   9.0     225.0   143.0   637.0 556 7 22   3 9     1   39   336 301     15 9   225 143   637
695456 MN Isanti 30 school 2707410 911 Independent Districts and Schools CAMBRIDGE-ISANTI PUBLIC SCHOOL DIST 270741003686 102 ISANTI PRIMARY SCHOOL Elementary School (Grades PK-6) Regular School No Elementary PK 02 2017   pk_12_total 427.0 5.0 11.0   3.0 8.0     0.0   18.0   249.0 223.0     6.0   4.0     162.0   109.0   472.0 427 5 11   3 8     0   18   249 223     6 4   162 109   472
695596 MN Chisago 13 school 2700017 2144 Independent Districts and Schools CHISAGO LAKES SCHOOL DISTRICT 270001700352 1 CHISAGO LAKES EL. Elementary School (Grades PK-6) Regular School No Elementary PK 02 2017   pk_12_total 470.0 1.0 11.0   0.0 4.0     0.0   9.0   242.0 253.0     7.0   2.0     111.0   49.0   495.0 470 1 11   0 4     0   9   242 253     7 2   111 49   495
695881 MN Martin 46 school 2718960 2448 Independent Districts and Schools MARTIN COUNTY WEST SCHOOL DISTRICT 271896000067 10 SHERBURN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 02 2017   pk_12_total 124.0 2.0 4.0   1.0 0.0     0.0   6.0   74.0 63.0     0.0   0.0     58.0   19.0   137.0 124 2 4   1 0     0   6   74 63     0 0   58 19   137
696038 MN Goodhue 25 school 2745735 2805 Independent Districts and Schools ZUMBROTA-MAZEPPA SCHOOL DISTRICT 274573504730 30 Zumbrota-Mazeppa Primary School Elementary School (Grades PK-6) Regular School No Elementary PK 02 2017   pk_12_total 269.0 4.0 9.0   0.0 4.0     0.0   9.0   169.0 126.0     3.0   0.0     73.0   51.0   295.0 269 4 9   0 4     0   9   169 126     3 0   73 51   295
696084 MN Mcleod 43 school 2700128 2859 Independent Districts and Schools GLENCOE-SILVER LAKE SCHOOL DISTRICT 270012800632 10 BAKER ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 02 2017   pk_12_total 263.0 0.0 85.0   0.0 0.0     0.0   17.0   190.0 175.0     33.0   0.0     162.0   49.0   365.0 263 0 85   0 0     0   17   190 175     33 0   162 49   365
696331 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124000978 130 HIAWATHA ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 02 2017   pk_12_total 153.0 37.0 27.0   4.0 7.0     0.0   17.0   131.0 114.0     28.0   *     85.0   23.0   245.0 153 37 27   4 7     0   17   131 114     28     85 23   245
696432 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124001057 167 LK NOKOMIS COMM-WENONAH CAMPUS Elementary School (Grades PK-6) Regular School No Elementary KG 02 2017   pk_12_total 203.0 33.0 40.0   4.0 12.0     0.0   13.0   163.0 142.0     30.0   5.0     127.0   31.0   305.0 203 33 40   4 12     0   13   163 142     30 5   127 31   305
690846 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 03 2017   pk_12_total 510.0 49.0 48.0   2.0 59.0     0.0   63.0   399.0 332.0     60.0   1.0     185.0   81.0   731.0 510 49 48   2 59     0   63   399 332     60 1   185 81   731
690861 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 KG 03 2017   pk_12_total 355.0 106.0 102.0   2.0 62.0     1.0   83.0   363.0 348.0     133.0   6.0     418.0   102.0   711.0 355 106 102   2 62     1   83   363 348     133 6   418 102   711
691017 MN Benton 5 school 2712240 51 Independent Districts and Schools FOLEY PUBLIC SCHOOL DISTRICT 271224000590 10 FOLEY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 03 2017   pk_12_total 547.0 1.0 3.0   4.0 1.0     0.0   4.0   295.0 265.0     0.0   1.0     172.0   102.0   560.0 547 1 3   4 1     0   4   295 265     0 1   172 102   560
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
691434 MN Cottonwood 17 school 2742780 177 Independent Districts and Schools WINDOM PUBLIC SCHOOL DISTRICT 274278001816 30 WINFAIR ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 03 2017   pk_12_total 243.0 4.0 59.0   1.0 10.0     5.0   10.0   177.0 155.0     44.0   0.0     157.0   43.0   332.0 243 4 59   1 10     5   10   177 155     44 0   157 43   332
694075 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384002540 510 LINWOOD MONROE ARTS PLUS LOWER Elementary School (Grades PK-6) Regular School No Elementary KG 03 2017   pk_12_total 87.0 89.0 39.0   0.0 79.0     0.0   23.0   159.0 158.0     141.0   5.0     223.0   49.0   317.0 87 89 39   0 79     0   23   159 158     141 5   223 49   317
694294 MN Saint Louis 69 school 2708910 695 Independent Districts and Schools CHISHOLM PUBLIC SCHOOL DISTRICT 270891000360 101 VAUGHAN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 03 2017   pk_12_total 219.0 5.0 2.0   7.0 0.0     0.0   3.0   111.0 125.0     0.0   0.0     122.0   36.0   236.0 219 5 2   7 0     0   3   111 125     0 0   122 36   236
694970 MN Waseca 81 school 2741880 829 Independent Districts and Schools WASECA PUBLIC SCHOOL DISTRICT 274188001747 20 HARTLEY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 03 2017   pk_12_total 362.0 22.0 46.0   3.0 7.0     0.0   18.0   227.0 231.0     25.0   2.0     196.0   77.0   458.0 362 22 46   3 7     0   18   227 231     25 2   196 77   458
694992 MN Washington 82 school 2712270 831 Independent Districts and Schools FOREST LAKE PUBLIC SCHOOL DISTRICT 271227000596 627 Forest View Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 03 2017   pk_12_total 359.0 9.0 28.0   0.0 13.0     0.0   32.0   233.0 208.0     24.0   0.0     152.0   64.0   441.0 359 9 28   0 13     0   32   233 208     24 0   152 64   441
695536 MN Fillmore 23 school 2700007 2137 Independent Districts and Schools KINGSLAND PUBLIC SCHOOL DISTRICT 270000701468 15 Kingsland Elementary School Elementary School (Grades PK-6) Regular School No Elementary PK 03 2017   pk_12_total 182.0 0.0 3.0   0.0 2.0     0.0   7.0   114.0 80.0     0.0   0.0     70.0   36.0   194.0 182 0 3   0 2     0   7   114 80     0 0   70 36   194
695612 MN Pope 61 school 2700019 2149 Independent Districts and Schools MINNEWASKA SCHOOL DISTRICT 270001903536 70 MINNEWASKA AREA ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 03 2017   pk_12_total 355.0 4.0 7.0   0.0 1.0     0.0   2.0   197.0 172.0     1.0   0.0     100.0   67.0   369.0 355 4 7   0 1     0   2   197 172     1 0   100 67   369
695704 MN Todd 77 school 2733900 2170 Independent Districts and Schools STAPLES-MOTLEY SCHOOL DISTRICT 273390001643 30 Staples-Motley Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 03 2017   pk_12_total 300.0 3.0 8.0   3.0 3.0     0.0   15.0   186.0 146.0     0.0   16.0     209.0   83.0   332.0 300 3 8   3 3     0   15   186 146     0 16   209 83   332
695873 MN Lesueur 40 school 2718070 2397 Independent Districts and Schools LE SUEUR-HENDERSON SCHOOL DISTRICT 271807000045 10 PARK ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 03 2017   pk_12_total 227.0 7.0 51.0   0.0 0.0     0.0   15.0   169.0 131.0     16.0   2.0     114.0   62.0   300.0 227 7 51   0 0     0   15   169 131     16 2   114 62   300
696180 MN Wabasha 79 school 2700287 2899 Independent Districts and Schools PLAINVIEW-ELGIN-MILLVILLE 270028703701 10 PLAINVIEW-ELGIN-MILLVILLE PK-3 Elementary School (Grades PK-6) Regular School No Elementary PK 03 2017   pk_12_total 426.0 1.0 35.0   0.0 2.0     0.0   9.0   241.0 232.0     13.0   0.0     151.0   61.0   473.0 426 1 35   0 2     0   9   241 232     13 0   151 61   473
696265 MN Douglas 21 school 2700382 2908 Independent Districts and Schools BRANDON-EVANSVILLE PUBLIC SCHOOLS 270038204738 1 Brandon Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 03 2017   pk_12_total 165.0 0.0 2.0   0.0 0.0     0.0   9.0   89.0 87.0     0.0   0.0     61.0   35.0   176.0 165 0 2   0 0     0   9   89 87     0 0   61 35   176
696281 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124001861 104 LAKE HARRIET LOWER ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 03 2017   pk_12_total 454.0 16.0 14.0   1.0 23.0     1.0   13.0   264.0 258.0     15.0   0.0     31.0   30.0   522.0 454 16 14   1 23     1   13   264 258     15 0   31 30   522
696498 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124004885 215 WEBSTER ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 03 2017   pk_12_total 68.0 44.0 20.0   8.0 9.0     0.0   15.0   88.0 76.0     33.0   6.0     99.0   37.0   164.0 68 44 20   8 9     0   15   88 76     33 6   99 37   164
696502 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124004883 216 FAIR Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 03 2017   pk_12_total 15.0 69.0 3.0   0.0 1.0     0.0   5.0   39.0 54.0     6.0   4.0     78.0   10.0   93.0 15 69 3   0 1     0   5   39 54     6 4   78 10   93
697222 MN Hennepin 27 school 2700288 4170 Charter Schools HIAWATHA ACADEMIES 270028804669 12 Hiawatha Leadership Academy-Northrop Elementary School (Grades PK-6) Regular School Yes Elementary KG 03 2017   pk_12_total 7.0 26.0 245.0   3.0 2.0     1.0   5.0   146.0 143.0     237.0   3.0     258.0   23.0   289.0 7 26 245   3 2     1   5   146 143     237 3   258 23   289
690563 MN Aitkin 1 school 2714010 2 Independent Districts and Schools HILL CITY PUBLIC SCHOOL DISTRICT 271401000723 1 HILL CITY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2017   pk_12_total 86.0 0.0 5.0   0.0 0.0     0.0   5.0   46.0 50.0     0.0   0.0     61.0   30.0   96.0 86 0 5   0 0     0   5   46 50     0 0   61 30   96
690812 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   pk_12_total 242.0 179.0 49.0   5.0 26.0     0.0   62.0   300.0 263.0     110.0   13.0     340.0   92.0   563.0 242 179 49   5 26     0   62   300 263     110 13   340 92   563
690820 MN Anoka 2 school 2712420 14 Independent Districts and Schools FRIDLEY PUBLIC SCHOOL DISTRICT 271242000614 550 STEVENSON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2017   pk_12_total 239.0 219.0 74.0   7.0 44.0     0.0   39.0   320.0 302.0     105.0   11.0     436.0   78.0   622.0 239 219 74   7 44     0   39   320 302     105 11   436 78   622
690882 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   pk_12_total 421.0 16.0 23.0   75.0 2.0     0.0   81.0   309.0 309.0     3.0   17.0     323.0   118.0   618.0 421 16 23   75 2     0   81   309 309     3 17   323 118   618
691135 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 2017   pk_12_total 587.0 7.0 37.0   0.0 2.0     0.0   21.0   354.0 300.0     7.0   3.0     211.0   93.0   654.0 587 7 37   0 2     0   21   354 300     7 3   211 93   654
691317 MN Cass 11 school 2708070 115 Independent Districts and Schools CASS LAKE-BENA PUBLIC SCHOOLS 270807000330 10 CASS LAKE-BENA ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2017   pk_12_total 34.0 1.0 22.0   431.0 0.0     1.0   54.0   274.0 269.0     0.0   1.0     466.0   124.0   543.0 34 1 22   431 0     1   54   274 269     0 1   466 124   543
691324 MN Cass 11 school 2728350 116 Independent Districts and Schools PILLAGER PUBLIC SCHOOL DISTRICT 272835001253 10 PILLAGER ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2017   pk_12_total 427.0 4.0 12.0   1.0 0.0     0.0   6.0   244.0 206.0     1.0   3.0     208.0   87.0   450.0 427 4 12   1 0     0   6   244 206     1 3   208 87   450
691349 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 2017   pk_12_total 913.0 7.0 39.0   6.0 13.0     0.0   30.0   521.0 487.0     14.0   3.0     323.0   130.0   1008.0 913 7 39   6 13     0   30   521 487     14 3   323 130   1008
691441 MN Crow Wing 18 school 2706090 181 Independent Districts and Schools BRAINERD PUBLIC SCHOOL DISTRICT 270609000248 4 BAXTER ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2017   pk_12_total 445.0 2.0 8.0   5.0 6.0     0.0   18.0   245.0 239.0     2.0   0.0     161.0   98.0   484.0 445 2 8   5 6     0   18   245 239     2 0   161 98   484
691447 MN Crow Wing 18 school 2706090 181 Independent Districts and Schools BRAINERD PUBLIC SCHOOL DISTRICT 270609000252 8 GARFIELD ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 04 2017   pk_12_total 367.0 4.0 5.0   12.0 0.0     0.0   14.0   185.0 217.0     0.0   4.0     191.0   87.0   402.0 367 4 5   12 0     0   14   185 217     0 4   191 87   402
691453 MN Crow Wing 18 school 2706090 181 Independent Districts and Schools BRAINERD PUBLIC SCHOOL DISTRICT 270609000254 9 HARRISON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 04 2017   pk_12_total 261.0 2.0 1.0   5.0 0.0     0.0   8.0   135.0 142.0     0.0   6.0     164.0   68.0   277.0 261 2 1   5 0     0   8   135 142     0 6   164 68   277
691459 MN Crow Wing 18 school 2706090 181 Independent Districts and Schools BRAINERD PUBLIC SCHOOL DISTRICT 270609000256 11 Lowell Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 04 2017   pk_12_total 383.0 6.0 5.0   3.0 1.0     0.0   19.0   201.0 216.0     0.0   *     167.0   49.0   417.0 383 6 5   3 1     0   19   201 216     0     167 49   417
691465 MN Crow Wing 18 school 2706090 181 Independent Districts and Schools BRAINERD PUBLIC SCHOOL DISTRICT 270609000259 12 RIVERSIDE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 04 2017   pk_12_total 536.0 14.0 12.0   13.0 1.0     0.0   20.0   307.0 289.0     0.0   3.0     339.0   138.0   596.0 536 14 12   13 1     0   20   307 289     0 3   339 138   596
691472 MN Crow Wing 18 school 2706090 181 Independent Districts and Schools BRAINERD PUBLIC SCHOOL DISTRICT 270609000257 15 NISSWA ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2017   pk_12_total 291.0 1.0 3.0   0.0 0.0     0.0   5.0   171.0 129.0     0.0   0.0     84.0   37.0   300.0 291 1 3   0 0     0   5   171 129     0 0   84 37   300
691488 MN Crow Wing 18 school 2728200 186 Independent Districts and Schools PEQUOT LAKES PUBLIC SCHOOLS 272820001244 10 EAGLE VIEW ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2017   pk_12_total 573.0 12.0 2.0   9.0 0.0     0.0   1.0   334.0 263.0     0.0   4.0     198.0   87.0   597.0 573 12 2   9 0     0   1   334 263     0 4   198 87   597
691812 MN Dakota 19 school 2742270 197 Independent Districts and Schools WEST ST. PAUL-MENDOTA HTS.-EAGAN 274227001776 815 MORELAND ART/HEALTH SCIENCE MAGNET Elementary School (Grades PK-6) Regular School No Elementary KG 04 2017   pk_12_total 140.0 30.0 178.0   3.0 17.0     0.0   26.0   193.0 201.0     112.0   2.0     236.0   89.0   394.0 140 30 178   3 17     0   26   193 201     112 2   236 89   394
691818 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   pk_12_total 301.0 23.0 38.0   1.0 8.0     0.0   24.0   217.0 178.0     19.0   *     68.0   58.0   395.0 301 23 38   1 8     0   24   217 178     19     68 58   395
691824 MN Dakota 19 school 2742270 197 Independent Districts and Schools WEST ST. PAUL-MENDOTA HTS.-EAGAN 274227001773 817 GARLOUGH ENVIRONMENTAL MAGNET Elementary School (Grades PK-6) Regular School No Elementary KG 04 2017   pk_12_total 151.0 47.0 175.0   0.0 8.0     2.0   38.0   203.0 218.0     140.0   3.0     239.0   51.0   421.0 151 47 175   0 8     2   38   203 218     140 3   239 51   421
691830 MN Dakota 19 school 2742270 197 Independent Districts and Schools WEST ST. PAUL-MENDOTA HTS.-EAGAN 274227001780 819 SOMERSET ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2017   pk_12_total 303.0 8.0 50.0   1.0 5.0     1.0   28.0   185.0 211.0         *     74.0   32.0   396.0 303 8 50   1 5     1   28   185 211           74 32   396
691836 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   pk_12_total 165.0 101.0 34.0   4.0 48.0     0.0   47.0   213.0 186.0     56.0   *     151.0   53.0   399.0 165 101 34   4 48     0   47   213 186     56     151 53   399
691868 MN Dakota 19 school 2713530 200 Independent Districts and Schools HASTINGS PUBLIC SCHOOL DISTRICT 271353000695 609 KENNEDY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 04 2017   pk_12_total 391.0 12.0 23.0   4.0 1.0     0.0   22.0   221.0 232.0     0.0   2.0     146.0   48.0   453.0 391 12 23   4 1     0   22   221 232     0 2   146 48   453
691874 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   pk_12_total 495.0 12.0 22.0   7.0 5.0     0.0   26.0   278.0 289.0     15.0   0.0     155.0   56.0   567.0 495 12 22   7 5     0   26   278 289     15 0   155 56   567
691880 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   pk_12_total 427.0 12.0 29.0   0.0 8.0     1.0   29.0   250.0 256.0     14.0   5.0     126.0   74.0   506.0 427 12 29   0 8     1   29   250 256     14 5   126 74   506
691895 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   pk_12_total 760.0 5.0 43.0   2.0 5.0     0.0   30.0   440.0 405.0     21.0   0.0     161.0   134.0   845.0 760 5 43   2 5     0   30   440 405     21 0   161 134   845
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
692052 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 2017   pk_12_total 413.0 13.0 64.0   23.0 5.0     0.0   42.0   286.0 274.0     19.0   3.0     218.0   86.0   560.0 413 13 64   23 5     0   42   286 274     19 3   218 86   560
692343 MN Hennepin 27 school 2722920 277 Independent Districts and Schools WESTONKA PUBLIC SCHOOL DISTRICT 272292001113 615 SHIRLEY HILLS PRIMARY SCHOOL Elementary School (Grades PK-6) Regular School No Elementary PK 04 2017   pk_12_total 377.0 8.0 25.0   0.0 6.0     0.0   18.0   201.0 233.0     5.0   0.0     88.0   67.0   434.0 377 8 25   0 6     0   18   201 233     5 0   88 67   434
692349 MN Hennepin 27 school 2722920 277 Independent Districts and Schools WESTONKA PUBLIC SCHOOL DISTRICT 272292001110 616 HILLTOP PRIMARY SCHOOL Elementary School (Grades PK-6) Regular School No Elementary PK 04 2017   pk_12_total 352.0 4.0 12.0   1.0 0.0     0.0   23.0   203.0 189.0     5.0   1.0     44.0   48.0   392.0 352 4 12   1 0     0   23   203 189     5 1   44 48   392
692736 MN Houston 28 school 2717250 300 Independent Districts and Schools LA CRESCENT-HOKAH SCHOOL DISTRICT 271725000799 10 LA CRESCENT-HOKAH ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2017   pk_12_total 342.0 21.0 10.0   2.0 9.0     0.0   4.0   210.0 178.0     1.0   1.0     91.0   79.0   388.0 342 21 10   2 9     0   4   210 178     1 1   91 79   388
692766 MN Hubbard 29 school 2728080 309 Independent Districts and Schools PARK RAPIDS PUBLIC SCHOOL DISTRICT 272808001233 30 PARK RAPIDS AREA CENTURY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2017   pk_12_total 544.0 3.0 32.0   5.0 1.0     0.0   53.0   315.0 323.0     9.0   0.0     352.0   135.0   638.0 544 3 32   5 1     0   53   315 323     9 0   352 135   638
692783 MN Itasca 31 school 2709480 316 Independent Districts and Schools GREENWAY PUBLIC SCHOOL DISTRICT 270948000394 110 VANDYKE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2017   pk_12_total 369.0 3.0 14.0   43.0 1.0     0.0   16.0   231.0 215.0     1.0   3.0     275.0   126.0   446.0 369 3 14   43 1     0   16   231 215     1 3   275 126   446
692800 MN Itasca 31 school 2713170 318 Independent Districts and Schools GRAND RAPIDS PUBLIC SCHOOL DISTRICT 271317000661 110 COHASSET ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 04 2017   pk_12_total 206.0 3.0 5.0   5.0 0.0     0.0   22.0   133.0 108.0     0.0   *     100.0   34.0   241.0 206 3 5   5 0     0   22   133 108     0     100 34   241
692816 MN Itasca 31 school 2713170 318 Independent Districts and Schools GRAND RAPIDS PUBLIC SCHOOL DISTRICT 271317000662 120 FOREST LAKE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 04 2017   pk_12_total 303.0 1.0 9.0   6.0 0.0     2.0   45.0   192.0 174.0     0.0   0.0     189.0   56.0   366.0 303 1 9   6 0     2   45   192 174     0 0   189 56   366
692822 MN Itasca 31 school 2713170 318 Independent Districts and Schools GRAND RAPIDS PUBLIC SCHOOL DISTRICT 271317000907 125 MURPHY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 04 2017   pk_12_total 314.0 1.0 7.0   9.0 2.0     0.0   27.0   169.0 191.0     0.0   0.0     165.0   60.0   360.0 314 1 7   9 2     0   27   169 191     0 0   165 60   360
692828 MN Itasca 31 school 2713170 318 Independent Districts and Schools GRAND RAPIDS PUBLIC SCHOOL DISTRICT 271317000915 135 SOUTHWEST ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 04 2017   pk_12_total 347.0 0.0 5.0   4.0 3.0     0.0   23.0   218.0 164.0     4.0   0.0     152.0   72.0   382.0 347 0 5   4 3     0   23   218 164     4 0   152 72   382
692871 MN Kandiyohi 34 school 2723400 345 Independent Districts and Schools NEW LONDON-SPICER SCHOOL DISTRICT 272340001141 10 PRAIRIE WOODS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2017   pk_12_total 547.0 1.0 38.0   1.0 0.0     1.0   1.0   307.0 282.0     7.0   2.0     170.0   61.0   589.0 547 1 38   1 0     1   1   307 282     7 2   170 61   589
693011 MN Lyon 42 school 2718940 413 Independent Districts and Schools MARSHALL PUBLIC SCHOOL DISTRICT 271894000894 3 WEST SIDE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 03 04 2017   pk_12_total 207.0 43.0 52.0   2.0 28.0     0.0   18.0   185.0 165.0         3.0     175.0   56.0   350.0 207 43 52   2 28     0   18   185 165       3   175 56   350
693067 MN Becker 3 school 2742120 435 Independent Districts and Schools WAUBUN-OGEMA-WHITE EARTH PUBLIC SCH 274212001754 20 OGEMA ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2017   pk_12_total 71.0 1.0 7.0   182.0 0.0     0.0   49.0   165.0 145.0     0.0   19.0     207.0   38.0   310.0 71 1 7   182 0     0   49   165 145     0 19   207 38   310
693113 MN Meeker 47 school 2718210 465 Independent Districts and Schools LITCHFIELD PUBLIC SCHOOL DISTRICT 271821000837 10 LAKE RIPLEY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 04 2017   pk_12_total 486.0 5.0 57.0   1.0 1.0     0.0   13.0   304.0 259.0     14.0   2.0     248.0   75.0   563.0 486 5 57   1 1     0   13   304 259     14 2   248 75   563
693120 MN Wright 86 school 2710060 466 Independent Districts and Schools DASSEL-COKATO PUBLIC SCHOOL DIST. 271006000426 1 COKATO ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2017   pk_12_total 487.0 2.0 21.0   0.0 5.0     0.0   13.0   266.0 262.0     10.0   0.0     147.0   91.0   528.0 487 2 21   0 5     0   13   266 262     10 0   147 91   528
693127 MN Meeker 47 school 2710060 466 Independent Districts and Schools DASSEL-COKATO PUBLIC SCHOOL DIST. 271006000427 3 DASSEL ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2017   pk_12_total 356.0 0.0 11.0   1.0 0.0     0.0   9.0   201.0 176.0     4.0   0.0     113.0   64.0   377.0 356 0 11   1 0     0   9   201 176     4 0   113 64   377
693217 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 2017   pk_12_total 266.0 45.0 101.0   0.0 27.0     3.0   11.0   208.0 245.0     95.0   0.0     245.0   64.0   453.0 266 45 101   0 27     3   11   208 245     95 0   245 64   453
693222 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 2017   pk_12_total 181.0 16.0 103.0   0.0 23.0     0.0   9.0   155.0 177.0     73.0   10.0     200.0   32.0   332.0 181 16 103   0 23     0   9   155 177     73 10   200 32   332

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