enrollments

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

This data as json, CSV (advanced)

year ✖

  • 2017 · 13,757 ✖
Link rowid state county county_state_id admin_level district_nces_id district_state_id district_state_type district school_nces_id school_state_id school school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ccd_school_high_grade ▼ year term grade white black hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
690909 690909 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   kindergarten 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
690910 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
693034 693034 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   early_childhood_special_ed 59.0 0.0 3.0   0.0 0.0     0.0   1.0   36.0 27.0     0.0   0.0     23.0   *   63.0 59 0 3   0 0     0   1   36 27     0 0   23     63
693035 693035 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   kindergarten 173.0 4.0 20.0   0.0 0.0     0.0   5.0   95.0 107.0     10.0   1.0     74.0   25.0   202.0 173 4 20   0 0     0   5   95 107     10 1   74 25   202
693036 693036 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   grade_1 171.0 3.0 14.0   0.0 2.0     1.0   9.0   107.0 93.0     11.0   1.0     72.0   25.0   200.0 171 3 14   0 2     1   9   107 93     11 1   72 25   200
693037 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
693489 693489 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   kindergarten 166.0 6.0 5.0   1.0 0.0     2.0   4.0   93.0 91.0         *         *   184.0 166 6 5   1 0     2   4   93 91                 184
693490 693490 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   grade_1 47.0 1.0 1.0   0.0 0.0     0.0   2.0   24.0 27.0     0.0   *         *   51.0 47 1 1   0 0     0   2   24 27     0           51
693491 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
693597 693597 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   kindergarten 52.0 4.0 12.0   3.0 0.0     0.0   2.0   39.0 34.0     4.0   7.0     42.0   14.0   73.0 52 4 12   3 0     0   2   39 34     4 7   42 14   73
693598 693598 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   grade_1 54.0 6.0 26.0   3.0 0.0     0.0   3.0   46.0 46.0     6.0   10.0     53.0   14.0   92.0 54 6 26   3 0     0   3   46 46     6 10   53 14   92
693599 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
693832 693832 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   kindergarten 138.0 1.0 2.0   0.0 8.0     0.0   18.0   95.0 72.0     5.0   0.0     27.0   21.0   167.0 138 1 2   0 8     0   18   95 72     5 0   27 21   167
693833 693833 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   grade_1 145.0 6.0 7.0   0.0 3.0     0.0   7.0   95.0 73.0     5.0   0.0     22.0   15.0   168.0 145 6 7   0 3     0   7   95 73     5 0   22 15   168
693834 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
695959 695959 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   early_childhood_special_ed 19.0 0.0 4.0   0.0 0.0     0.0   1.0   16.0 8.0     0.0   0.0     8.0   *   24.0 19 0 4   0 0     0   1   16 8     0 0   8     24
695960 695960 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   kindergarten 64.0 3.0 22.0   0.0 2.0     0.0   8.0   51.0 48.0         *         *   99.0 64 3 22   0 2     0   8   51 48                 99
695961 695961 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   grade_1 52.0 4.0 16.0   0.0 1.0     0.0   6.0   42.0 37.0         *         *   79.0 52 4 16   0 1     0   6   42 37                 79
695962 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
697306 697306 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   kindergarten 1.0 39.0 0.0   1.0 1.0     0.0   0.0   20.0 22.0     0.0   3.0     37.0   3.0   42.0 1 39 0   1 1     0   0   20 22     0 3   37 3   42
697307 697307 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   grade_1 0.0 25.0 0.0   0.0 0.0     0.0   0.0   10.0 15.0     0.0   2.0         1.0   25.0 0 25 0   0 0     0   0   10 15     0 2     1   25
697308 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
697551 697551 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   kindergarten 0.0 29.0 1.0   0.0 0.0     0.0   3.0   21.0 12.0     0.0   0.0     24.0   0.0   33.0 0 29 1   0 0     0   3   21 12     0 0   24 0   33
697552 697552 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   grade_1 1.0 11.0 1.0   0.0 0.0     0.0   1.0   8.0 6.0     0.0   0.0     9.0   0.0   14.0 1 11 1   0 0     0   1   8 6     0 0   9 0   14
697553 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
701091 701091 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   early_childhood_special_ed 5.0 0.0 2.0   0.0 3.0     0.0   0.0   7.0 3.0         *         *   10.0 5 0 2   0 3     0   0   7 3                 10
701092 701092 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   kindergarten 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
701093 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
692053 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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

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