Data source: Big Local News · About: Big Local

16,029 rows where grade = "pk_12_total" and state = "MN" sorted by black_int

View and edit SQL

year

grade

  • pk_12_total · 15,929
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
694665 MN Stearns 73 school 2717220 739 Independent Districts and Schools KIMBALL PUBLIC SCHOOL DISTRICT 271722000796 10 KIMBALL ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   pk_12_total 387.0 0.0 3.0   0.0 0.0     0.0   11.0   220.0 181.0     0.0   0.0     127.0   50.0   401.0 387 0 3   0 0     0   11   220 181     0 0   127 50   401
694681 MN Stearns 73 school 2728140 741 Independent Districts and Schools PAYNESVILLE PUBLIC SCHOOL DISTRICT 272814001240 1 PAYNESVILLE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   pk_12_total 397.0 0.0 17.0   0.0 0.0     0.0   8.0   201.0 221.0     3.0   4.0     145.0   91.0   422.0 397 0 17   0 0     0   8   201 221     3 4   145 91   422
694762 MN Stearns 73 school 2702930 745 Independent Districts and Schools ALBANY PUBLIC SCHOOL DISTRICT 270293000062 10 ALBANY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 01 06 2017   pk_12_total 446.0 0.0 19.0   0.0 0.0     0.0   8.0   232.0 241.0     13.0   3.0     122.0   72.0   473.0 446 0 19   0 0     0   8   232 241     13 3   122 72   473
694796 MN Stearns 73 school 2709440 750 Independent Districts and Schools ROCORI PUBLIC SCHOOL DISTRICT 270944000387 20 ROCKVILLE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   pk_12_total 115.0 0.0 8.0   0.0 0.0     0.0   7.0   68.0 62.0     5.0   2.0     44.0   21.0   130.0 115 0 8   0 0     0   7   68 62     5 2   44 21   130
694861 MN Stevens 75 school 2713380 768 Independent Districts and Schools HANCOCK PUBLIC SCHOOL DISTRICT 271338000688 10 HANCOCK ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   pk_12_total 181.0 0.0 14.0   1.0 0.0     0.0   2.0   110.0 88.0     9.0   0.0     63.0   38.0   198.0 181 0 14   1 0     0   2   110 88     9 0   63 38   198
694906 MN Todd 77 school 2706300 787 Independent Districts and Schools BROWERVILLE PUBLIC SCHOOL DISTRICT 270630000277 10 BROWERVILLE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   pk_12_total 189.0 0.0 5.0   0.0 2.0     0.0   1.0   115.0 82.0     0.0   0.0     97.0   39.0   197.0 189 0 5   0 2     0   1   115 82     0 0   97 39   197
694965 MN Wadena 80 school 2720580 821 Independent Districts and Schools MENAHGA PUBLIC SCHOOL DISTRICT 272058000917 10 MENAHGA ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2017   pk_12_total 401.0 0.0 9.0   2.0 0.0     0.0   7.0   189.0 230.0     0.0   0.0     223.0   63.0   419.0 401 0 9   2 0     0   7   189 230     0 0   223 63   419
695016 MN Washington 82 school 2712270 831 Independent Districts and Schools FOREST LAKE PUBLIC SCHOOL DISTRICT 271227000599 630 Scandia Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 06 2017   pk_12_total 305.0 0.0 4.0   0.0 5.0     0.0   10.0   164.0 160.0     0.0   1.0     46.0   48.0   324.0 305 0 4   0 5     0   10   164 160     0 1   46 48   324
695032 MN Washington 82 school 2712270 831 Independent Districts and Schools FOREST LAKE PUBLIC SCHOOL DISTRICT 271227001757 633 CENTRAL MONTESSORI ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   pk_12_total 100.0 0.0 4.0   0.0 1.0     0.0   5.0   60.0 50.0     0.0   0.0     33.0   16.0   110.0 100 0 4   0 1     0   5   60 50     0 0   33 16   110
695170 MN Washington 82 school 2738190 834 Independent Districts and Schools STILLWATER AREA PUBLIC SCHOOL DIST. 273819001655 786 ANDERSEN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 06 2017   pk_12_total 337.0 0.0 10.0   2.0 18.0     0.0   15.0   196.0 186.0     6.0   2.0     51.0   43.0   382.0 337 0 10   2 18     0   15   196 186     6 2   51 43   382
695194 MN Washington 82 school 2738190 834 Independent Districts and Schools STILLWATER AREA PUBLIC SCHOOL DIST. 273819001658 789 MARINE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 06 2017   pk_12_total 128.0 0.0 9.0   2.0 4.0     0.0   1.0   75.0 69.0     1.0   0.0     18.0   20.0   144.0 128 0 9   2 4     0   1   75 69     1 0   18 20   144
695210 MN Washington 82 school 2738190 834 Independent Districts and Schools STILLWATER AREA PUBLIC SCHOOL DIST. 273819001665 792 WITHROW ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 06 2017   pk_12_total 178.0 0.0 3.0   0.0 6.0     0.0   7.0   95.0 99.0     2.0   0.0     21.0   29.0   194.0 178 0 3   0 6     0   7   95 99     2 0   21 29   194
695218 MN Washington 82 school 2738190 834 Independent Districts and Schools STILLWATER AREA PUBLIC SCHOOL DIST. 273819001663 793 STONEBRIDGE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 06 2017   pk_12_total 423.0 0.0 15.0   0.0 6.0     0.0   25.0   242.0 227.0     1.0   1.0     57.0   61.0   469.0 423 0 15   0 6     0   25   242 227     1 1   57 61   469
695255 MN Watonwan 83 school 2733600 840 Independent Districts and Schools ST. JAMES PUBLIC SCHOOL DISTRICT 273360004814 25 Armstrong School Elementary School (Grades PK-6) Regular School No Elementary PK KG 2017   pk_12_total 65.0 0.0 62.0   1.0 1.0     0.0   1.0   66.0 64.0         0.0         16.0   130.0 65 0 62   1 1     0   1   66 64       0     16   130
695292 MN Winona 85 school 2718090 857 Independent Districts and Schools LEWISTON-ALTURA PUBLIC SCHOOL DIST. 271809000834 20 LEWISTON-ALTURA INTERMEDIATE EL. Elementary School (Grades PK-6) Regular School No Middle 05 06 2017   pk_12_total 94.0 0.0 7.0   0.0 1.0     0.0   3.0   55.0 50.0     1.0   1.0     38.0   18.0   105.0 94 0 7   0 1     0   3   55 50     1 1   38 18   105
695382 MN Wright 86 school 2707200 877 Independent Districts and Schools BUFFALO-HANOVER-MONTROSE PUBLIC SCH 270720002686 70 DISCOVERY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   pk_12_total 231.0 0.0 4.0   0.0 4.0     0.0   9.0   126.0 122.0     0.0   0.0     37.0   26.0   248.0 231 0 4   0 4     0   9   126 122     0 0   37 26   248
695463 MN Isanti 30 school 2707410 911 Independent Districts and Schools CAMBRIDGE-ISANTI PUBLIC SCHOOL DIST 270741003651 103 SCHOOL FOR ALL SEASONS Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   pk_12_total 175.0 0.0 10.0   0.0 2.0     0.0   11.0   98.0 100.0     2.0   0.0     57.0   28.0   198.0 175 0 10   0 2     0   11   98 100     2 0   57 28   198
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
695545 MN Saint Louis 69 school 2700008 2142 Independent Districts and Schools ST. LOUIS COUNTY SCHOOL DISTRICT 270000800158 10 BABBITT ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   pk_12_total 104.0 0.0 3.0   7.0 0.0     0.0   4.0   56.0 62.0     0.0   5.0     59.0   36.0   118.0 104 0 3   7 0     0   4   56 62     0 5   59 36   118
695555 MN Saint Louis 69 school 2700008 2142 Independent Districts and Schools ST. LOUIS COUNTY SCHOOL DISTRICT 270000801684 20 Tower-Soudan Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   pk_12_total 50.0 0.0 1.0   21.0 0.0     0.0   11.0   47.0 36.0     0.0   7.0     47.0   16.0   83.0 50 0 1   21 0     0   11   47 36     0 7   47 16   83
695573 MN Saint Louis 69 school 2700008 2142 Independent Districts and Schools ST. LOUIS COUNTY SCHOOL DISTRICT 270000804456 50 NORTH WOODS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   pk_12_total 184.0 0.0 6.0   21.0 1.0     0.0   35.0   122.0 125.0     1.0   0.0     129.0   51.0   247.0 184 0 6   21 1     0   35   122 125     1 0   129 51   247
695582 MN Saint Louis 69 school 2700008 2142 Independent Districts and Schools ST. LOUIS COUNTY SCHOOL DISTRICT 270000801513 96 CHERRY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   pk_12_total 250.0 0.0 6.0   2.0 0.0     2.0   34.0   155.0 139.0     0.0   1.0     162.0   49.0   294.0 250 0 6   2 0     2   34   155 139     0 1   162 49   294
695607 MN Chisago 13 school 2700017 2144 Independent Districts and Schools CHISAGO LAKES SCHOOL DISTRICT 270001701672 6 TAYLORS FALLS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   pk_12_total 320.0 0.0 13.0   0.0 3.0     0.0   24.0   187.0 173.0     2.0   0.0     125.0   71.0   360.0 320 0 13   0 3     0   24   187 173     2 0   125 71   360
695619 MN Saint Louis 69 school 2700021 2154 Independent Districts and Schools EVELETH-GILBERT SCHOOL DISTRICT 270002100540 10 FRANKLIN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2017   pk_12_total 324.0 0.0 10.0   4.0 2.0     0.0   8.0   160.0 188.0         0.0     150.0   33.0   348.0 324 0 10   4 2     0   8   160 188       0   150 33   348
695655 MN Clay 14 school 2710260 2164 Independent Districts and Schools DILWORTH-GLYNDON-FELTON 271026002690 2 GLYNDON-FELTON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   pk_12_total 328.0 0.0 35.0   4.0 1.0     0.0   6.0   182.0 192.0     3.0   0.0     115.0   76.0   374.0 328 0 35   4 1     0   6   182 192     3 0   115 76   374
695713 MN Kittson 35 school 2791447 2171 Independent Districts and Schools KITTSON CENTRAL SCHOOL DISTRICT 279144702469 15 KITTSON CENTRAL ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   pk_12_total 130.0 0.0 4.0   0.0 0.0     0.0   6.0   83.0 57.0     0.0   0.0     56.0   15.0   140.0 130 0 4   0 0     0   6   83 57     0 0   56 15   140
695740 MN Marshall 45 school 2700024 2176 Independent Districts and Schools WARREN-ALVARADO-OSLO SCHOOL DIST. 270002401742 10 WARREN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   pk_12_total 248.0 0.0 40.0   0.0 0.0     0.0   11.0   153.0 146.0     13.0   0.0     132.0   37.0   299.0 248 0 40   0 0     0   11   153 146     13 0   132 37   299
695782 MN Fillmore 23 school 2700100 2198 Independent Districts and Schools FILLMORE CENTRAL 270010001269 10 FILLMORE CENTRAL ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   pk_12_total 342.0 0.0 4.0   0.0 0.0     0.0   8.0   190.0 164.0         *     118.0   39.0   354.0 342 0 4   0 0     0   8   190 164           118 39   354
695792 MN Norman 54 school 2700101 2215 Independent Districts and Schools NORMAN COUNTY EAST SCHOOL DISTRICT 270010100622 10 NORMAN COUNTY EAST ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   pk_12_total 117.0 0.0 9.0   7.0 0.0     0.0   23.0   89.0 67.0     0.0   0.0     82.0   35.0   156.0 117 0 9   7 0     0   23   89 67     0 0   82 35   156
695824 MN Grant 26 school 2700104 2342 Independent Districts and Schools WEST CENTRAL AREA 270010400513 1 WEST CENTRAL AREA N. EL. Elementary School (Grades PK-6) Regular School No Elementary PK 04 2017   pk_12_total 141.0 0.0 1.0   0.0 0.0     0.0   7.0   75.0 74.0     0.0   0.0     50.0   14.0   149.0 141 0 1   0 0     0   7   75 74     0 0   50 14   149
695850 MN Stearns 73 school 2700105 2364 Independent Districts and Schools Belgrade-Brooten-Elrosa Public School District 270010500182 1 BELGRADE-BROOTEN-ELROSA ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   pk_12_total 302.0 0.0 36.0   0.0 1.0     0.0   1.0   174.0 166.0     24.0   0.0     113.0   51.0   340.0 302 0 36   0 1     0   1   174 166     24 0   113 51   340
695867 MN Meeker 47 school 2700106 2396 Independent Districts and Schools A.C.G.C. Public School District 270010603647 150 ACGC ELEMENTARY GRADES 5 AND 6 Elementary School (Grades PK-6) Regular School No Middle 05 06 2017   pk_12_total 103.0 0.0 11.0   3.0 0.0     0.0   4.0   65.0 56.0     1.0   1.0     54.0   22.0   121.0 103 0 11   3 0     0   4   65 56     1 1   54 22   121
695913 MN Martin 46 school 2713040 2536 Independent Districts and Schools Granada Huntley East Chain 271304000152 15 Granada Huntley East Chain Elementary School Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   pk_12_total 116.0 0.0 1.0   0.0 0.0     0.0   1.0   61.0 57.0     0.0   3.0     45.0   14.0   118.0 116 0 1   0 0     0   1   61 57     0 3   45 14   118
695974 MN Pipestone 59 school 2700108 2689 Independent Districts and Schools PIPESTONE AREA SCHOOL DISTRICT 270010803015 6 HEARTLAND ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 08 2017   pk_12_total 18.0 0.0 0.0   0.0 0.0     0.0   0.0   9.0 9.0     6.0   0.0     0.0   1.0   18.0 18 0 0   0 0     0   0   9 9     6 0   0 1   18
696010 MN Renville 65 school 2700110 2754 Independent Districts and Schools CEDAR MOUNTAIN SCHOOL DISTRICT 270011001098 1 CEDAR MOUNTAIN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   pk_12_total 158.0 0.0 6.0   29.0 1.0     0.0   13.0   119.0 88.0     0.0   0.0     103.0   64.0   207.0 158 0 6   29 1     0   13   119 88     0 0   103 64   207
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
696089 MN Mcleod 43 school 2700128 2859 Independent Districts and Schools GLENCOE-SILVER LAKE SCHOOL DISTRICT 270012801444 30 LAKESIDE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 03 06 2017   pk_12_total 355.0 0.0 115.0   2.0 0.0     0.0   10.0   268.0 214.0     43.0   2.0     198.0   90.0   482.0 355 0 115   2 0     0   10   268 214     43 2   198 90   482
696104 MN Redwood 64 school 2700132 2884 Independent Districts and Schools RED ROCK CENTRAL SCHOOL DISTRICT 270013201419 30 RED ROCK CENTRAL ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2017   pk_12_total 160.0 0.0 8.0   0.0 1.0     0.0   3.0   89.0 83.0     0.0   0.0     102.0   26.0   172.0 160 0 8   0 1     0   3   89 83     0 0   102 26   172
696123 MN Big Stone 6 school 2700150 2888 Independent Districts and Schools CLINTON-GRACEVILLE-BEARDSLEY 270015000378 1 CLINTON-GRACEVILLE-BEARDSLEY EL. Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   pk_12_total 162.0 0.0 3.0   0.0 0.0     0.0   4.0   74.0 95.0     0.0   0.0         27.0   169.0 162 0 3   0 0     0   4   74 95     0 0     27   169
696131 MN Becker 3 school 2700162 2889 Independent Districts and Schools LAKE PARK AUDUBON SCHOOL DISTRICT 270016200142 10 LAKE PARK AUDUBON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   pk_12_total 346.0 0.0 8.0   10.0 2.0     0.0   25.0   207.0 184.0     1.0   1.0     122.0   68.0   391.0 346 0 8   10 2     0   25   207 184     1 1   122 68   391
696141 MN Renville 65 school 2700163 2890 Independent Districts and Schools RENVILLE COUNTY WEST SCHOOL DIST. 270016301417 1 RENVILLE COUNTY WEST ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   pk_12_total 204.0 0.0 96.0   0.0 0.0     0.0   4.0   163.0 141.0     20.0   0.0     155.0   51.0   304.0 204 0 96   0 0     0   4   163 141     20 0   155 51   304
696149 MN Jackson 32 school 2700231 2895 Independent Districts and Schools JACKSON COUNTY CENTRAL SCHOOL DIST. 270023100814 10 PLEASANTVIEW ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   pk_12_total 121.0 0.0 8.0   0.0 1.0     0.0   3.0   67.0 66.0     2.0   0.0     50.0   32.0   133.0 121 0 8   0 1     0   3   67 66     2 0   50 32   133
696184 MN Wabasha 79 school 2700287 2899 Independent Districts and Schools PLAINVIEW-ELGIN-MILLVILLE 270028703667 20 PLAINVIEW-ELGIN-MILLVILLE 4-6 Elementary School (Grades PK-6) Regular School No Elementary 04 06 2017   pk_12_total 295.0 0.0 33.0   0.0 0.0     0.0   10.0   169.0 169.0     6.0   0.0     113.0   48.0   338.0 295 0 33   0 0     0   10   169 169     6 0   113 48   338
696201 MN Big Stone 6 school 2700328 2903 Independent Districts and Schools ORTONVILLE PUBLIC SCHOOLS 270032804394 10 KNOLL ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   pk_12_total 246.0 0.0 13.0   2.0 1.0     0.0   9.0   140.0 131.0     0.0   0.0     130.0   64.0   271.0 246 0 13   2 1     0   9   140 131     0 0   130 64   271
696241 MN Red Lake 63 school 2700385 2906 Independent Districts and Schools Red Lake County Central Public Schools 270038504733 10 RLCC Elementary at Oklee Elementary School (Grades PK-6) Regular School No Elementary PK PK 2017   pk_12_total 1.0 0.0 1.0   0.0 0.0     0.0   0.0   2.0 0.0         *         *   2.0 1 0 1   0 0     0   0   2 0                 2
696250 MN Red Lake 63 school 2700385 2906 Independent Districts and Schools Red Lake County Central Public Schools 270038504734 11 Red Lake County Central Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   pk_12_total 207.0 0.0 7.0   12.0 0.0     0.0   6.0   128.0 104.0         *     111.0   *   232.0 207 0 7   12 0     0   6   128 104           111     232
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
696648 MN Sibley 72 school 2700092 4007 Charter Schools Minnesota New Country School 270009204748 20 Minnesota New Country Elementary Elementary School (Grades PK-6) Regular School Yes Elementary KG 06 2017   pk_12_total 69.0 0.0 8.0   0.0 0.0     0.0   9.0   53.0 33.0     0.0   0.0     23.0   10.0   86.0 69 0 8   0 0     0   9   53 33     0 0   23 10   86
696803 MN Nicollet 52 school 2700174 4050 Charter Schools LAFAYETTE PUBLIC CHARTER SCHOOL 270017403042 10 LAFAYETTE PUBLIC CHARTER SCHOOL Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2017   pk_12_total 67.0 0.0 4.0   1.0 0.0     0.0   2.0   37.0 37.0     0.0   0.0         10.0   74.0 67 0 4   1 0     0   2   37 37     0 0     10   74
696809 MN Nicollet 52 school 2700174 4050 Charter Schools LAFAYETTE PUBLIC CHARTER SCHOOL 270017404126 20 STARLAND ELEMENTARY Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2017   pk_12_total 11.0 0.0 0.0   0.0 0.0     0.0   0.0   6.0 5.0     0.0   0.0         0.0   11.0 11 0 0   0 0     0   0   6 5     0 0     0   11
696834 MN Beltrami 4 school 2700225 4058 Charter Schools SCHOOLCRAFT LEARNING COMMUNITY CHTR 270022503464 10 SCHOOLCRAFT LEARNING COMMUNITY CHTR Elementary School (Grades PK-6) Regular School Yes Other KG 09 2017   pk_12_total 141.0 0.0 12.0   22.0 0.0     0.0   16.0   90.0 101.0     0.0   0.0     98.0   56.0   191.0 141 0 12   22 0     0   16   90 101     0 0   98 56   191
696860 MN Hennepin 27 school 2700220 4067 Charter Schools AURORA CHARTER SCHOOL 270022003473 10 AURORA CHARTER SCHOOL Elementary School (Grades PK-6) Regular School Yes Elementary PK 04 2017   pk_12_total 1.0 0.0 241.0   0.0 0.0     0.0   0.0   113.0 129.0         0.0         23.0   242.0 1 0 241   0 0     0   0   113 129       0     23   242
696912 MN Winona 85 school 2700194 4083 Charter Schools RIDGEWAY COMMUNITY SCHOOL 270019403147 10 RIDGEWAY COMMUNITY SCHOOL Elementary School (Grades PK-6) Regular School Yes Elementary KG 05 2017   pk_12_total 96.0 0.0 0.0   0.0 0.0     1.0   3.0   54.0 46.0     0.0   0.0     32.0   11.0   100.0 96 0 0   0 0     1   3   54 46     0 0   32 11   100
696972 MN Cook 16 school 2700339 4100 Charter Schools GREAT EXPECTATIONS 270033904177 10 GREAT EXPECTATIONS Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2017   pk_12_total 95.0 0.0 0.0   3.0 0.0     0.0   0.0   43.0 55.0     0.0   0.0     42.0   25.0   98.0 95 0 0   3 0     0   0   43 55     0 0   42 25   98
697005 MN Washington 82 school 2700358 4116 Charter Schools Lakes International Language Academy 270035805055 30 LILA Annex Elementary School (Grades PK-6) Regular School Yes Middle 05 05 2017   pk_12_total 71.0 0.0 6.0   0.0 1.0     0.0   1.0   38.0 41.0     0.0   0.0     8.0   8.0   79.0 71 0 6   0 1     0   1   38 41     0 0   8 8   79
697074 MN Redwood 64 school 2700250 4138 Charter Schools Milroy Area Charter School 270025003310 10 Milroy Area Charter School Elementary School (Grades PK-6) Regular School Yes Elementary KG 04 2017   pk_12_total 42.0 0.0 0.0   0.0 0.0     0.0   0.0   19.0 23.0     0.0   0.0     17.0   0.0   42.0 42 0 0   0 0     0   0   19 23     0 0   17 0   42
697122 MN Sibley 72 school 2700254 4144 Charter Schools GREEN ISLE COMMUNITY SCHOOL 270025403312 10 GREEN ISLE COMMUNITY SCHOOL Elementary School (Grades PK-6) Regular School Yes Elementary KG 06 2017   pk_12_total 61.0 0.0 2.0   0.0 0.0     0.0   4.0   32.0 35.0     2.0   0.0     27.0   9.0   67.0 61 0 2   0 0     0   4   32 35     2 0   27 9   67
697157 MN Mahnomen 44 school 2700275 4155 Charter Schools NAYTAHWAUSH COMMUNITY SCHOOL 270027503580 10 NAYTAHWAUSH COMMUNITY SCHOOL Elementary School (Grades PK-6) Regular School Yes Elementary KG 06 2017   pk_12_total 2.0 0.0 1.0   92.0 0.0     0.0   1.0   51.0 45.0     0.0   0.0     74.0   18.0   96.0 2 0 1   92 0     0   1   51 45     0 0   74 18   96
697240 MN Yellow Medicine 87 school 2700290 4172 Charter Schools CLARKFIELD CHARTER SCHOOL 270029003726 10 CLARKFIELD CHARTER SCHOOL Elementary School (Grades PK-6) Regular School Yes Elementary KG 06 2017   pk_12_total 45.0 0.0 6.0   1.0 0.0     0.0   1.0   24.0 29.0     0.0   0.0     29.0   7.0   53.0 45 0 6   1 0     0   1   24 29     0 0   29 7   53
697250 MN Ramsey 62 school 2700304 4181 Charter Schools COMMUNITY SCHOOL OF EXCELLENCE 270030403728 10 COMMUNITY SCHOOL OF EXCELLENCE Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2017   pk_12_total 0.0 0.0 2.0   0.0 913.0     0.0   5.0   452.0 468.0     612.0   0.0     696.0   75.0   920.0 0 0 2   0 913     0   5   452 468     612 0   696 75   920
697343 MN Cook 16 school 2700321 4195 Charter Schools OSHKI OGIMAAG CHARTER SCHOOL 270032104293 10 OSHKI OGIMAAG CHARTER SCHOOL Elementary School (Grades PK-6) Regular School Yes Elementary KG 06 2017   pk_12_total 3.0 0.0 0.0   19.0 0.0     0.0   6.0   14.0 14.0     0.0   2.0     24.0   7.0   28.0 3 0 0   19 0     0   6   14 14     0 2   24 7   28
697471 MN Hennepin 27 school 2700396 4226 Charter Schools Bdote Learning Center 270039604763 10 Bdote Learning Center Elementary School (Grades PK-6) Regular School Yes Elementary KG 05 2017   pk_12_total 3.0 0.0 10.0   43.0 0.0     0.0   19.0   37.0 38.0     0.0   29.0         8.0   75.0 3 0 10   43 0     0   19   37 38     0 29     8   75
697564 MN Aitkin 1 school 2702760 1 Independent Districts and Schools AITKIN PUBLIC SCHOOL DISTRICT 270276002789 6 AITKIN ALTERNATIVE LEARNING PROGRAM Public Area Learning Program ALP (State approved) Alternative School No High 09 12 2017   pk_12_total 3.0 0.0 0.0   0.0 0.0     0.0   0.0   3.0 0.0         *         *   3.0 3 0 0   0 0     0   0   3 0                 3
697566 MN Aitkin 1 school 2719170 4 Independent Districts and Schools MCGREGOR PUBLIC SCHOOL DISTRICT 271917003432 30 MCGREGOR AREA LEARNING PROGRAM Public Area Learning Program ALP (State approved) Alternative School No High 08 12 2017   pk_12_total 1.0 0.0 0.0   1.0 0.0     0.0   0.0   1.0 1.0         *         *   2.0 1 0 0   1 0     0   0   1 1                 2
697568 MN Blue Earth 7 school 2718780 77 Independent Districts and Schools MANKATO PUBLIC SCHOOL DISTRICT 271878000347 230 LIFE LINES ADULT CONNECTION Public Area Learning Program ALP (State approved) Alternative School No High 11 12 2017   pk_12_total 1.0 0.0 0.0   0.0 0.0     0.0   0.0   1.0 0.0         *         *   1.0 1 0 0   0 0     0   0   1 0                 1
697573 MN Cass 11 school 2702910 113 Independent Districts and Schools WALKER-HACKENSACK-AKELEY SCHL. DIST 270291002428 25 W. H. A . ALTERNATIVE PROGRAM Public Area Learning Program ALP (State approved) Alternative School No High 09 12 2017   pk_12_total 8.0 0.0 0.0   7.0 0.0     0.0   1.0   13.0 3.0     0.0   0.0     10.0   0.0   16.0 8 0 0   7 0     0   1   13 3     0 0   10 0   16
697576 MN Clearwater 15 school 2703570 162 Independent Districts and Schools BAGLEY PUBLIC SCHOOL DISTRICT 270357004279 30 BAGLEY ALP Public Area Learning Program ALP (State approved) Alternative School No High 09 12 2017   pk_12_total 2.0 0.0 0.0   0.0 0.0     0.0   0.0   1.0 1.0         *         *   2.0 2 0 0   0 0     0   0   1 1                 2
697578 MN Dakota 19 school 2711820 192 Independent Districts and Schools FARMINGTON PUBLIC SCHOOL DISTRICT 271182002803 50 DAKOTA PRAIRIE AREA LEARNING CENTER Public Area Learning Program ALP (State approved) Alternative School No High 10 12 2017   pk_12_total 5.0 0.0 1.0   0.0 1.0     0.0   0.0   5.0 2.0         *         *   7.0 5 0 1   0 1     0   0   5 2                 7
697589 MN Hennepin 27 school 2705790 271 Independent Districts and Schools BLOOMINGTON PUBLIC SCHOOL DISTRICT 270579003518 629 Beacon ALP Public Area Learning Program ALP (State approved) Alternative School No High 09 12 2017   pk_12_total 2.0 0.0 3.0   0.0 1.0     0.0   1.0   5.0 2.0         *         *   7.0 2 0 3   0 1     0   1   5 2                 7
697603 MN Itasca 31 school 2723310 319 Independent Districts and Schools NASHWAUK-KEEWATIN SCHOOL DISTRICT 272331003702 70 NASHWAUK-KEEWATIN ALP Public Area Learning Program ALP (State approved) Alternative School No High 09 12 2017   pk_12_total 16.0 0.0 0.0   0.0 0.0     0.0   3.0   10.0 9.0     0.0   0.0     8.0   1.0   19.0 16 0 0   0 0     0   3   10 9     0 0   8 1   19
697606 MN Kandiyohi 34 school 2723400 345 Independent Districts and Schools NEW LONDON-SPICER SCHOOL DISTRICT 272340002766 31 NEW LONDON ALTERNATIVE SCHOOL Public Area Learning Program ALP (State approved) Alternative School No High 09 12 2017   pk_12_total 18.0 0.0 1.0   0.0 0.0     0.0   1.0   17.0 3.0     0.0   1.0     9.0   0.0   20.0 18 0 1   0 0     0   1   17 3     0 1   9 0   20
697609 MN Mahnomen 44 school 2742120 435 Independent Districts and Schools WAUBUN-OGEMA-WHITE EARTH PUBLIC SCH 274212003460 40 WAUBUN AREA LEARNING PROGRAM Public Area Learning Program ALP (State approved) Alternative School No High 10 12 2017   pk_12_total 1.0 0.0 0.0   7.0 0.0     0.0   0.0   2.0 6.0         *         *   8.0 1 0 0   7 0     0   0   2 6                 8
697612 MN Meeker 47 school 2718210 465 Independent Districts and Schools LITCHFIELD PUBLIC SCHOOL DISTRICT 271821003075 50 LITCHFIELD AREA LEARNING PROGRAM Public Area Learning Program ALP (State approved) Alternative School No High 10 12 2017   pk_12_total 9.0 0.0 1.0   0.0 0.0     0.0   0.0   6.0 4.0     0.0   0.0     4.0   0.0   10.0 9 0 1   0 0     0   0   6 4     0 0   4 0   10
697616 MN Roseau 68 school 2732250 682 Independent Districts and Schools ROSEAU PUBLIC SCHOOL DISTRICT 273225004520 60 ROSEAU DIST. AREA LEARNING PROGRAM Public Area Learning Program ALP (State approved) Alternative School No High 07 12 2017   pk_12_total 1.0 0.0 0.0   0.0 0.0     0.0   0.0   1.0 0.0         *         *   1.0 1 0 0   0 0     0   0   1 0                 1
697619 MN Saint Louis 69 school 2713920 700 Independent Districts and Schools HERMANTOWN PUBLIC SCHOOL DISTRICT 271392004370 35 Hermantown Alternative Learning Program Public Area Learning Program ALP (State approved) Alternative School No Other 05 12 2017   pk_12_total 11.0 0.0 0.0   0.0 0.0     0.0   1.0   7.0 5.0     0.0   0.0     4.0   1.0   12.0 11 0 0   0 0     0   1   7 5     0 0   4 1   12
697623 MN Sherburne 71 school 2703870 726 Independent Districts and Schools BECKER PUBLIC SCHOOL DISTRICT 270387003533 50 BECKER ALTERNATIVE LEARNING PROGRAM Public Area Learning Program ALP (State approved) Alternative School No High 09 12 2017   pk_12_total 20.0 0.0 0.0   0.0 0.0     0.0   0.0   16.0 4.0     0.0   0.0     4.0   1.0   20.0 20 0 0   0 0     0   0   16 4     0 0   4 1   20
697630 MN Washington 82 school 2733810 833 Independent Districts and Schools SOUTH WASHINGTON COUNTY SCHOOL DIST 273381001793 52 Access Public Area Learning Program ALP (State approved) Alternative School No High 10 12 2017   pk_12_total 7.0 0.0 2.0   0.0 0.0     0.0   1.0   5.0 5.0     0.0   0.0     0.0   0.0   10.0 7 0 2   0 0     0   1   5 5     0 0   0 0   10
697635 MN Wilkin 84 school 2706150 846 Independent Districts and Schools BRECKENRIDGE PUBLIC SCHOOL DISTRICT 270615004963 70 Breckenridge Area Learning Program Public Area Learning Program ALP (State approved) Alternative School No High 07 12 2017   pk_12_total 7.0 0.0 0.0   0.0 0.0     0.0   3.0   3.0 7.0     0.0   0.0     5.0   5.0   10.0 7 0 0   0 0     0   3   3 7     0 0   5 5   10
697639 MN Wright 86 school 2707200 877 Independent Districts and Schools BUFFALO-HANOVER-MONTROSE PUBLIC SCH 270720002853 45 PHOENIX LEARNING CENTER Public Area Learning Program ALP (State approved) Alternative School No High 09 12 2017   pk_12_total 18.0 0.0 1.0   0.0 0.0     0.0   0.0   11.0 8.0     0.0   0.0     10.0   *   19.0 18 0 1   0 0     0   0   11 8     0 0   10     19
697643 MN Wright 86 school 2721390 882 Independent Districts and Schools MONTICELLO PUBLIC SCHOOL DISTRICT 272139001834 40 MONTICELLO ALTERNATIVE PROGRAM Public Area Learning Program ALP (State approved) Alternative School No High 09 12 2017   pk_12_total 22.0 0.0 0.0   0.0 0.0     0.0   1.0   12.0 11.0     0.0   1.0     12.0   *   23.0 22 0 0   0 0     0   1   12 11     0 1   12     23
697649 MN Chisago 13 school 2700017 2144 Independent Districts and Schools CHISAGO LAKES SCHOOL DISTRICT 270001703889 14 CHISAGO LAKES HS ALT LEARNING PROG Public Area Learning Program ALP (State approved) Alternative School No High 09 12 2017   pk_12_total 1.0 0.0 0.0   0.0 0.0     0.0   0.0   1.0 0.0         *         *   1.0 1 0 0   0 0     0   0   1 0                 1
697652 MN Saint Louis 69 school 2700021 2154 Independent Districts and Schools EVELETH-GILBERT SCHOOL DISTRICT 270002105010 80 Eveleth Gilbert HOPE Program Public Area Learning Program ALP (State approved) Alternative School No High 10 12 2017   pk_12_total 3.0 0.0 0.0   0.0 0.0     0.0   0.0   3.0 0.0         *         *   3.0 3 0 0   0 0     0   0   3 0                 3
697657 MN Pine 58 school 2714070 2165 Independent Districts and Schools HINCKLEY-FINLAYSON SCHOOL DISTRICT 271407004489 40 HINCKLEY-FINLAYSON ALTERNATIVE PROG Public Area Learning Program ALP (State approved) Alternative School No High 09 12 2017   pk_12_total 10.0 0.0 1.0   2.0 0.0     0.0   0.0   9.0 4.0     0.0   0.0         0.0   13.0 10 0 1   2 0     0   0   9 4     0 0     0   13
697662 MN Chippewa 12 school 2700091 2180 Independent Districts and Schools MACCRAY School District 270009102856 40 MACCRAY Area Learning Program Public Area Learning Program ALP (State approved) Alternative School No High 09 12 2017   pk_12_total 25.0 0.0 2.0   0.0 0.0     0.0   1.0   14.0 14.0     0.0   1.0     12.0   3.0   28.0 25 0 2   0 0     0   1   14 14     0 1   12 3   28
697667 MN Lesueur 40 school 2718070 2397 Independent Districts and Schools LE SUEUR-HENDERSON SCHOOL DISTRICT 271807002695 30 AREA ADULT LEARNING COOPERATIVE Public Area Learning Program ALP (State approved) Alternative School No High 12 12 2017   pk_12_total 3.0 0.0 0.0   0.0 0.0     0.0   0.0   1.0 2.0         *         *   3.0 3 0 0   0 0     0   0   1 2                 3
697673 MN Redwood 64 school 2700182 2897 Independent Districts and Schools REDWOOD AREA SCHOOL DISTRICT 270018202576 4 REDWOOD VALLEY ALTERNATIVE Public Area Learning Program ALP (State approved) Alternative School No High 09 12 2017   pk_12_total 0.0 0.0 0.0   1.0 0.0     0.0   0.0   0.0 1.0         *         *   1.0 0 0 0   1 0     0   0   0 1                 1
697678 MN Clay 14 school 2700083 926 Service Cooperative (ECSU Region) REGION 4-LAKES COUNTRY SERVICE COOP 270008302417 20 LAKES COUNTRY YOUTH EDUC SVCS Public Area Learning Program ALP (State approved) Alternative School No High 09 12 2017   pk_12_total 26.0 0.0 9.0   0.0 0.0     0.0   7.0   22.0 20.0     0.0   0.0     18.0   8.0   42.0 26 0 9   0 0     0   7   22 20     0 0   18 8   42
697683 MN Aitkin 1 school 2714010 2 Independent Districts and Schools HILL CITY PUBLIC SCHOOL DISTRICT 271401004653 2 Hill City Middle School Middle School (Grades 5-8) Regular School No Middle 05 08 2017   pk_12_total 86.0 0.0 0.0   2.0 0.0     0.0   6.0   52.0 42.0     0.0   0.0     62.0   16.0   94.0 86 0 0   2 0     0   6   52 42     0 0   62 16   94
697741 MN Beltrami 4 school 2730510 38 Independent Districts and Schools RED LAKE PUBLIC SCHOOL DISTRICT 273051002427 40 Red Lake Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2017   pk_12_total 0.0 0.0 0.0   227.0 0.0     0.0   0.0   118.0 109.0     0.0   26.0     200.0   33.0   227.0 0 0 0   227 0     0   0   118 109     0 26   200 33   227
697791 MN Cass 11 school 2708070 115 Independent Districts and Schools CASS LAKE-BENA PUBLIC SCHOOLS 270807003181 20 CASS LAKE-BENA MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 05 08 2017   pk_12_total 29.0 0.0 8.0   286.0 0.0     0.0   15.0   188.0 150.0     0.0   7.0     280.0   69.0   338.0 29 0 8   286 0     0   15   188 150     0 7   280 69   338
698062 MN Lincoln 41 school 2718390 415 Independent Districts and Schools LYND PUBLIC SCHOOL DISTRICT 271839004845 40 Lynd Middle School Middle School (Grades 5-8) Regular School No Middle 05 08 2017   pk_12_total 23.0 0.0 18.0   0.0 0.0     0.0   2.0   17.0 26.0     7.0   0.0     29.0   8.0   43.0 23 0 18   0 0     0   2   17 26     7 0   29 8   43
698088 MN Morrison 49 school 2732520 485 Independent Districts and Schools ROYALTON PUBLIC SCHOOL DISTRICT 273252004640 50 ROYALTON MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 06 08 2017   pk_12_total 218.0 0.0 4.0   3.0 1.0     0.0   2.0   123.0 105.0     0.0   3.0     53.0   27.0   228.0 218 0 4   3 1     0   2   123 105     0 3   53 27   228
698105 MN Nicollet 52 school 2723580 507 Independent Districts and Schools NICOLLET PUBLIC SCHOOL DISTRICT 272358004675 15 Nicollet Middle School Middle School (Grades 5-8) Regular School No Middle 05 08 2017   pk_12_total 106.0 0.0 10.0   0.0 0.0     0.0   2.0   52.0 66.0     0.0   0.0     29.0   17.0   118.0 106 0 10   0 0     0   2   52 66     0 0   29 17   118
698319 MN Wadena 80 school 2720580 821 Independent Districts and Schools MENAHGA PUBLIC SCHOOL DISTRICT 272058005019 20 Menahga Middle School Middle School (Grades 5-8) Regular School No Middle 05 08 2017   pk_12_total 322.0 0.0 3.0   1.0 2.0     0.0   12.0   164.0 176.0     3.0   1.0     189.0   58.0   340.0 322 0 3   1 2     0   12   164 176     3 1   189 58   340
698391 MN Isanti 30 school 2707410 911 Independent Districts and Schools CAMBRIDGE-ISANTI PUBLIC SCHOOL DIST 270741003634 303 MINNESOTA CENTER Middle School (Grades 5-8) Regular School No Middle 06 08 2017   pk_12_total 70.0 0.0 4.0   0.0 1.0     0.0   8.0   46.0 37.0         *     31.0   19.0   83.0 70 0 4   0 1     0   8   46 37           31 19   83
698487 MN Nobles 53 school 2700388 2907 Independent Districts and Schools ROUND LAKE-BREWSTER PUBLIC SCHOOLS 270038804737 20 Round Lake-Brewster Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2017   pk_12_total 14.0 0.0 40.0   0.0 0.0     0.0   2.0   30.0 26.0     16.0   0.0     47.0   8.0   56.0 14 0 40   0 0     0   2   30 26     16 0   47 8   56
698542 MN Hennepin 27 school 2700220 4067 Charter Schools AURORA CHARTER SCHOOL 270022004420 20 AURORA MIDDLE SCHOOL Middle School (Grades 5-8) Regular School Yes Middle 05 08 2017   pk_12_total 0.0 0.0 178.0   0.0 0.0     0.0   0.0   82.0 96.0         0.0         18.0   178.0 0 0 178   0 0     0   0   82 96       0     18   178
698559 MN Beltrami 4 school 2700345 4106 Charter Schools TREKNORTH HIGH SCHOOL 270034504666 20 Trek North Middle School Middle School (Grades 5-8) Regular School Yes Middle 06 08 2017   pk_12_total 58.0 0.0 3.0   37.0 1.0     0.0   12.0   53.0 58.0     0.0   0.0     70.0   25.0   111.0 58 0 3   37 1     0   12   53 58     0 0   70 25   111
698563 MN Beltrami 4 school 2700346 4107 Charter Schools VOYAGEURS EXPEDITIONARY 270034604667 20 Voyageurs Expeditionary MS Middle School (Grades 5-8) Regular School Yes Middle 06 08 2017   pk_12_total 9.0 0.0 0.0   36.0 0.0     0.0   0.0   22.0 23.0     0.0   0.0     38.0   12.0   45.0 9 0 0   36 0     0   0   22 23     0 0   38 12   45
698632 MN Aitkin 1 school 2714010 2 Independent Districts and Schools HILL CITY PUBLIC SCHOOL DISTRICT 271401000724 3 HILL CITY SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 09 12 2017   pk_12_total 73.0 0.0 0.0   6.0 0.0     0.0   2.0   42.0 39.0     0.0   0.0     40.0   21.0   81.0 73 0 0   6 0     0   2   42 39     0 0   40 21   81

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