Data source: Big Local News · About: Big Local

13,757 rows where state = "MN" and year = 2017 sorted by ccd_school_high_grade

View and edit SQL

year

  • 2017 · 13,729
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
692053 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   kindergarten 139.0 3.0 19.0   3.0 1.0     0.0   19.0   90.0 94.0     5.0   2.0     58.0   24.0   184.0 139 3 19   3 1     0   19   90 94     5 2   58 24   184
692054 MN Goodhue 25 school 2730480 256 Independent Districts and Schools RED WING PUBLIC SCHOOL DISTRICT 273048001297 541 SUNNYSIDE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 02 2017   grade_1 146.0 6.0 12.0   5.0 0.0     0.0   9.0   78.0 100.0     4.0   6.0     71.0   28.0   178.0 146 6 12   5 0     0   9   78 100     4 6   71 28   178
692055 MN Goodhue 25 school 2730480 256 Independent Districts and Schools RED WING PUBLIC SCHOOL DISTRICT 273048001297 541 SUNNYSIDE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 02 2017   grade_2 38.0 1.0 4.0   1.0 0.0     0.0   5.0   24.0 25.0     0.0   0.0     16.0   2.0   49.0 38 1 4   1 0     0   5   24 25     0 0   16 2   49
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
692350 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   kindergarten 147.0 1.0 9.0   1.0 3.0     0.0   5.0   96.0 70.0     9.0   1.0     11.0   16.0   166.0 147 1 9   1 3     0   5   96 70     9 1   11 16   166
692351 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   grade_1 174.0 2.0 8.0   0.0 3.0     0.0   5.0   109.0 83.0     6.0   3.0     14.0   14.0   192.0 174 2 8   0 3     0   5   109 83     6 3   14 14   192
692352 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   grade_2 177.0 4.0 5.0   0.0 3.0     0.0   8.0   110.0 87.0     6.0   1.0     24.0   15.0   197.0 177 4 5   0 3     0   8   110 87     6 1   24 15   197
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
692848 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   early_childhood_special_ed 31.0 2.0 0.0   3.0 0.0     0.0   4.0   23.0 17.0     0.0   1.0     25.0   *   40.0 31 2 0   3 0     0   4   23 17     0 1   25     40
692849 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   kindergarten 110.0 0.0 1.0   1.0 0.0     0.0   5.0   63.0 54.0     0.0   0.0     55.0   19.0   117.0 110 0 1   1 0     0   5   63 54     0 0   55 19   117
692850 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   grade_1 113.0 1.0 2.0   1.0 1.0     0.0   5.0   65.0 58.0     0.0   1.0     60.0   26.0   123.0 113 1 2   1 1     0   5   65 58     0 1   60 26   123
692851 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   grade_2 110.0 0.0 5.0   2.0 0.0     0.0   1.0   63.0 55.0     0.0   1.0     56.0   19.0   118.0 110 0 5   2 0     0   1   63 55     0 1   56 19   118
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
693004 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   early_childhood_special_ed 45.0 2.0 12.0   0.0 3.0     0.0   2.0   43.0 21.0     0.0   0.0     23.0   *   64.0 45 2 12   0 3     0   2   43 21     0 0   23     64
693005 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   kindergarten 87.0 26.0 32.0   1.0 24.0     0.0   7.0   89.0 88.0     45.0   1.0     102.0   26.0   177.0 87 26 32   1 24     0   7   89 88     45 1   102 26   177
693006 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   grade_1 104.0 24.0 37.0   0.0 19.0     0.0   6.0   104.0 86.0     60.0   1.0     109.0   33.0   190.0 104 24 37   0 19     0   6   104 86     60 1   109 33   190
693007 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   grade_2 111.0 20.0 26.0   1.0 14.0     0.0   12.0   99.0 85.0     41.0   0.0     97.0   25.0   184.0 111 20 26   1 14     0   12   99 85     41 0   97 25   184
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
693073 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   early_childhood_special_ed 4.0 0.0 0.0   0.0 0.0     0.0   0.0   3.0 1.0         *         *   4.0 4 0 0   0 0     0   0   3 1                 4
693074 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   kindergarten 25.0 1.0 1.0   0.0 0.0     0.0   0.0   13.0 14.0         *         2.0   27.0 25 1 1   0 0     0   0   13 14             2   27
693075 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   grade_1 27.0 0.0 0.0   0.0 0.0     0.0   1.0   11.0 17.0     0.0   0.0     14.0   1.0   28.0 27 0 0   0 0     0   1   11 17     0 0   14 1   28
693076 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   grade_2 32.0 1.0 1.0   0.0 0.0     0.0   0.0   24.0 10.0     0.0   0.0     12.0   5.0   34.0 32 1 1   0 0     0   0   24 10     0 0   12 5   34
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
693138 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   early_childhood_special_ed 54.0 0.0 2.0   3.0 0.0     0.0   0.0   48.0 11.0     0.0   0.0         *   59.0 54 0 2   3 0     0   0   48 11     0 0         59
693139 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   kindergarten 202.0 0.0 11.0   1.0 0.0     0.0   4.0   116.0 102.0     0.0   2.0     70.0   32.0   218.0 202 0 11   1 0     0   4   116 102     0 2   70 32   218
693140 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   grade_1 211.0 1.0 6.0   2.0 0.0     0.0   3.0   114.0 109.0         *         *   223.0 211 1 6   2 0     0   3   114 109                 223
693141 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   grade_2 227.0 1.0 7.0   3.0 3.0     0.0   5.0   123.0 123.0         *     82.0   *   246.0 227 1 7   3 3     0   5   123 123           82     246
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
693295 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   kindergarten 114.0 14.0 21.0   1.0 1.0     0.0   7.0   85.0 73.0     12.0   3.0     69.0   29.0   158.0 114 14 21   1 1     0   7   85 73     12 3   69 29   158
693296 MN Nicollet 52 school 2733870 508 Independent Districts and Schools ST. PETER PUBLIC SCHOOL DISTRICT 273387001639 50 South Early Learning Center Elementary School (Grades PK-6) Regular School No Elementary PK 02 2017   grade_1 98.0 9.0 19.0   1.0 0.0     0.0   10.0   63.0 74.0     14.0   2.0     70.0   21.0   137.0 98 9 19   1 0     0   10   63 74     14 2   70 21   137
693297 MN Nicollet 52 school 2733870 508 Independent Districts and Schools ST. PETER PUBLIC SCHOOL DISTRICT 273387001639 50 South Early Learning Center Elementary School (Grades PK-6) Regular School No Elementary PK 02 2017   grade_2 110.0 16.0 31.0   1.0 1.0     0.0   6.0   91.0 74.0     19.0   5.0     63.0   20.0   165.0 110 16 31   1 1     0   6   91 74     19 5   63 20   165
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
693326 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   early_childhood_special_ed 23.0 0.0 0.0   0.0 1.0     0.0   0.0   17.0 7.0     0.0   0.0     7.0   *   24.0 23 0 0   0 1     0   0   17 7     0 0   7     24
693327 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   kindergarten 164.0 1.0 8.0   0.0 4.0     0.0   2.0   97.0 82.0     2.0   0.0     20.0   17.0   179.0 164 1 8   0 4     0   2   97 82     2 0   20 17   179
693328 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   grade_1 137.0 1.0 3.0   1.0 3.0     0.0   9.0   91.0 63.0     2.0   0.0     19.0   20.0   154.0 137 1 3   1 3     0   9   91 63     2 0   19 20   154
693329 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   grade_2 121.0 1.0 2.0   1.0 3.0     0.0   6.0   59.0 75.0     1.0   1.0     14.0   11.0   134.0 121 1 2   1 3     0   6   59 75     1 1   14 11   134
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
693343 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   kindergarten 138.0 1.0 5.0   0.0 0.0     0.0   11.0   72.0 83.0     3.0   1.0     32.0   14.0   155.0 138 1 5   0 0     0   11   72 83     3 1   32 14   155
693344 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   grade_1 169.0 1.0 7.0   1.0 3.0     0.0   3.0   93.0 91.0     3.0   0.0     29.0   23.0   184.0 169 1 7   1 3     0   3   93 91     3 0   29 23   184
693345 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   grade_2 135.0 1.0 8.0   0.0 0.0     0.0   7.0   74.0 77.0     4.0   0.0     39.0   14.0   151.0 135 1 8   0 0     0   7   74 77     4 0   39 14   151
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
693363 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   early_childhood_special_ed 17.0 2.0 2.0   0.0 2.0     0.0   0.0   17.0 6.0     0.0   0.0     4.0   *   23.0 17 2 2   0 2     0   0   17 6     0 0   4     23
693364 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   kindergarten 47.0 9.0 6.0   0.0 5.0     0.0   2.0   40.0 29.0     6.0   3.0     19.0   9.0   69.0 47 9 6   0 5     0   2   40 29     6 3   19 9   69
693365 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   grade_1 44.0 7.0 5.0   0.0 9.0     0.0   5.0   34.0 36.0     9.0   3.0     22.0   10.0   70.0 44 7 5   0 9     0   5   34 36     9 3   22 10   70
693366 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   grade_2 50.0 6.0 6.0   1.0 8.0     0.0   4.0   33.0 42.0     6.0   1.0     22.0   7.0   75.0 50 6 6   1 8     0   4   33 42     6 1   22 7   75
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
693482 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   grade_1 134.0 4.0 5.0   1.0 0.0     1.0   2.0   70.0 77.0         *     64.0   *   147.0 134 4 5   1 0     1   2   70 77           64     147
693483 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   grade_2 174.0 7.0 4.0   1.0 1.0     1.0   10.0   104.0 94.0         *     68.0   *   198.0 174 7 4   1 1     1   10   104 94           68     198
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
693610 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   early_childhood_special_ed 21.0 2.0 4.0   2.0 0.0     0.0   2.0   23.0 8.0     0.0   0.0     11.0   *   31.0 21 2 4   2 0     0   2   23 8     0 0   11     31
693611 MN Polk 60 school 2711130 595 Independent Districts and Schools EAST GRAND FORKS PUBLIC SCHOOL DIST 271113000497 120 NEW HEIGHTS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 02 2017   kindergarten 98.0 25.0 14.0   2.0 0.0     0.0   6.0   78.0 67.0     8.0   1.0     58.0   9.0   145.0 98 25 14   2 0     0   6   78 67     8 1   58 9   145
693612 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   grade_1 123.0 18.0 9.0   0.0 0.0     0.0   2.0   76.0 76.0     13.0   0.0     62.0   9.0   152.0 123 18 9   0 0     0   2   76 76     13 0   62 9   152
693613 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   grade_2 114.0 12.0 26.0   5.0 0.0     0.0   5.0   89.0 73.0     6.0   1.0     62.0   31.0   162.0 114 12 26   5 0     0   5   89 73     6 1   62 31   162
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
693965 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   kindergarten 52.0 21.0 8.0   0.0 2.0     0.0   10.0   35.0 58.0     18.0   1.0     39.0   4.0   93.0 52 21 8   0 2     0   10   35 58     18 1   39 4   93
693966 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   grade_1 39.0 16.0 11.0   1.0 3.0     0.0   10.0   32.0 48.0     21.0   0.0     30.0   5.0   80.0 39 16 11   1 3     0   10   32 48     21 0   30 5   80
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
694323 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   early_childhood_special_ed 45.0 0.0 0.0   0.0 0.0     0.0   1.0   31.0 15.0     0.0   0.0     26.0   *   46.0 45 0 0   0 0     0   1   31 15     0 0   26     46
694324 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   kindergarten 90.0 0.0 3.0   0.0 2.0     0.0   2.0   45.0 52.0     0.0   0.0     32.0   10.0   97.0 90 0 3   0 2     0   2   45 52     0 0   32 10   97
694325 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   grade_1 73.0 1.0 1.0   3.0 0.0     0.0   4.0   42.0 40.0     0.0   1.0     42.0   14.0   82.0 73 1 1   3 0     0   4   42 40     0 1   42 14   82
694326 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   grade_2 77.0 4.0 2.0   2.0 0.0     2.0   6.0   37.0 56.0     0.0   0.0     54.0   9.0   93.0 77 4 2   2 0     2   6   37 56     0 0   54 9   93
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
694328 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   kindergarten 76.0 2.0 2.0   2.0 0.0     1.0   4.0   47.0 40.0     0.0   1.0     47.0   15.0   87.0 76 2 2   2 0     1   4   47 40     0 1   47 15   87
694329 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   grade_1 94.0 1.0 2.0   0.0 0.0     0.0   10.0   64.0 43.0     0.0   0.0     57.0   18.0   107.0 94 1 2   0 0     0   10   64 43     0 0   57 18   107
694330 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   grade_2 74.0 0.0 1.0   1.0 1.0     0.0   14.0   47.0 44.0     1.0   2.0     43.0   19.0   91.0 74 0 1   1 1     0   14   47 44     1 2   43 19   91
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
694357 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   early_childhood_special_ed 25.0 2.0 0.0   0.0 1.0     0.0   4.0   20.0 12.0     0.0   0.0     18.0   *   32.0 25 2 0   0 1     0   4   20 12     0 0   18     32
694358 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   kindergarten 122.0 3.0 4.0   3.0 0.0     0.0   19.0   95.0 56.0     0.0   0.0     71.0   15.0   151.0 122 3 4   3 0     0   19   95 56     0 0   71 15   151
694359 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   grade_1 107.0 2.0 9.0   2.0 0.0     0.0   12.0   71.0 61.0     0.0   0.0     59.0   16.0   132.0 107 2 9   2 0     0   12   71 61     0 0   59 16   132
694360 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   grade_2 88.0 4.0 6.0   5.0 0.0     0.0   14.0   66.0 51.0     1.0   0.0     55.0   22.0   117.0 88 4 6   5 0     0   14   66 51     1 0   55 22   117
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
694447 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   kindergarten 133.0 1.0 5.0   0.0 1.0     0.0   5.0   85.0 60.0     0.0   *     24.0   21.0   145.0 133 1 5   0 1     0   5   85 60     0     24 21   145
694448 MN Scott 70 school 2704050 716 Independent Districts and Schools BELLE PLAINE PUBLIC SCHOOL DISTRICT 270405000183 10 CHATFIELD ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 02 2017   grade_1 117.0 0.0 6.0   0.0 1.0     1.0   8.0   66.0 67.0     2.0   0.0     29.0   9.0   133.0 117 0 6   0 1     1   8   66 67     2 0   29 9   133
694449 MN Scott 70 school 2704050 716 Independent Districts and Schools BELLE PLAINE PUBLIC SCHOOL DISTRICT 270405000183 10 CHATFIELD ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 02 2017   grade_2 97.0 1.0 8.0   1.0 0.0     0.0   4.0   59.0 52.0     1.0   0.0     23.0   11.0   111.0 97 1 8   1 0     0   4   59 52     1 0   23 11   111
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
694462 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   early_childhood_special_ed 103.0 2.0 5.0   1.0 3.0     0.0   3.0   76.0 41.0     0.0   *     11.0   *   117.0 103 2 5   1 3     0   3   76 41     0     11     117
694463 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   kindergarten 62.0 2.0 12.0   0.0 2.0     0.0   0.0   29.0 49.0     4.0   *     5.0   4.0   78.0 62 2 12   0 2     0   0   29 49     4     5 4   78
694464 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   grade_1 52.0 0.0 10.0   0.0 0.0     0.0   5.0   25.0 42.0     4.0   0.0         0.0   67.0 52 0 10   0 0     0   5   25 42     4 0     0   67
694465 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   grade_2 46.0 0.0 11.0   0.0 1.0     0.0   1.0   19.0 40.0     1.0   0.0     6.0   2.0   59.0 46 0 11   0 1     0   1   19 40     1 0   6 2   59
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
694571 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   early_childhood_special_ed 25.0 2.0 1.0   1.0 0.0     0.0   0.0   22.0 7.0     0.0   1.0     7.0   *   29.0 25 2 1   1 0     0   0   22 7     0 1   7     29
694572 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   kindergarten 179.0 1.0 4.0   0.0 1.0     0.0   8.0   105.0 88.0     2.0   2.0     42.0   29.0   193.0 179 1 4   0 1     0   8   105 88     2 2   42 29   193
694573 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   grade_1 206.0 1.0 4.0   0.0 0.0     0.0   13.0   105.0 119.0     2.0   1.0     37.0   19.0   224.0 206 1 4   0 0     0   13   105 119     2 1   37 19   224
694574 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   grade_2 205.0 3.0 9.0   0.0 1.0     0.0   8.0   125.0 101.0     4.0   3.0     47.0   21.0   226.0 205 3 9   0 1     0   8   125 101     4 3   47 21   226
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
694619 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   kindergarten 158.0 3.0 1.0   0.0 1.0     0.0   8.0   95.0 76.0     4.0   1.0     54.0   25.0   171.0 158 3 1   0 1     0   8   95 76     4 1   54 25   171
694620 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   grade_1 159.0 0.0 5.0   0.0 1.0     0.0   8.0   96.0 77.0     2.0   0.0     50.0   32.0   173.0 159 0 5   0 1     0   8   96 77     2 0   50 32   173
694621 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   grade_2 165.0 0.0 2.0   0.0 2.0     0.0   7.0   95.0 81.0     3.0   0.0     43.0   24.0   176.0 165 0 2   0 2     0   7   95 81     3 0   43 24   176
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
695037 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   kindergarten 120.0 11.0 3.0   0.0 1.0     0.0   6.0   77.0 64.0     6.0   0.0     13.0   24.0   141.0 120 11 3   0 1     0   6   77 64     6 0   13 24   141
695038 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   grade_1 139.0 6.0 8.0   0.0 5.0     0.0   15.0   85.0 88.0     4.0   0.0     16.0   16.0   173.0 139 6 8   0 5     0   15   85 88     4 0   16 16   173
695039 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   grade_2 181.0 5.0 8.0   0.0 4.0     0.0   9.0   102.0 105.0     7.0   0.0     18.0   25.0   207.0 181 5 8   0 4     0   9   102 105     7 0   18 25   207
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
695447 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   early_childhood_special_ed 59.0 0.0 3.0   1.0 0.0     0.0   2.0   43.0 22.0     0.0   1.0     26.0   *   65.0 59 0 3   1 0     0   2   43 22     0 1   26     65
695448 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   kindergarten 177.0 2.0 7.0   0.0 2.0     0.0   12.0   98.0 102.0     3.0   4.0     62.0   20.0   200.0 177 2 7   0 2     0   12   98 102     3 4   62 20   200
695449 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   grade_1 157.0 1.0 6.0   0.0 4.0     0.0   12.0   96.0 84.0     6.0   1.0     62.0   35.0   180.0 157 1 6   0 4     0   12   96 84     6 1   62 35   180
695450 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   grade_2 163.0 4.0 6.0   2.0 3.0     1.0   13.0   99.0 93.0     6.0   3.0     75.0   23.0   192.0 163 4 6   2 3     1   13   99 93     6 3   75 23   192
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
695452 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   early_childhood_special_ed 47.0 0.0 2.0   0.0 1.0     0.0   1.0   33.0 18.0     0.0   0.0     23.0   *   51.0 47 0 2   0 1     0   1   33 18     0 0   23     51
695453 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   kindergarten 121.0 1.0 4.0   0.0 1.0     0.0   5.0   64.0 68.0     2.0   1.0     43.0   21.0   132.0 121 1 4   0 1     0   5   64 68     2 1   43 21   132

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