Data source: Big Local News · About: Big Local

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

View and edit SQL

year

  • 2017 · 2,294

grade

  • pk_12_total · 2,294
Link rowid state county county_state_id admin_level district_nces_id district_state_id district_state_type district school_nces_id school_state_id school school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ▼ ccd_school_high_grade year term grade white black hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
690867 MN Anoka 2 school 2733330 16 Independent Districts and Schools SPRING LAKE PARK PUBLIC SCHOOLS 273333004657 787 Elementary Lighthouse Elementary School (Grades PK-6) Regular School No Elementary 01 06 2017   pk_12_total 31.0 1.0 2.0   0.0 3.0     0.0   3.0   23.0 17.0     0.0   0.0     7.0   4.0   40.0 31 1 2   0 3     0   3   23 17     0 0   7 4   40
690908 MN Beltrami 4 school 2704440 31 Independent Districts and Schools BEMIDJI PUBLIC SCHOOL DISTRICT 270444000194 16 NORTHERN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 01 05 2017   pk_12_total 381.0 1.0 13.0   55.0 2.0     0.0   37.0   249.0 240.0     0.0   2.0     204.0   81.0   489.0 381 1 13   55 2     0   37   249 240     0 2   204 81   489
690941 MN Beltrami 4 school 2704440 31 Independent Districts and Schools BEMIDJI PUBLIC SCHOOL DISTRICT 270444000197 80 SOLWAY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 01 05 2017   pk_12_total 135.0 1.0 3.0   10.0 0.0     1.0   20.0   88.0 82.0     1.0   7.0     91.0   32.0   170.0 135 1 3   10 0     1   20   88 82     1 7   91 32   170
690948 MN Beltrami 4 school 2704440 31 Independent Districts and Schools BEMIDJI PUBLIC SCHOOL DISTRICT 270444000193 100 HORACE MAY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 01 05 2017   pk_12_total 386.0 6.0 8.0   42.0 4.0     0.0   33.0   263.0 216.0     2.0   6.0     195.0   106.0   479.0 386 6 8   42 4     0   33   263 216     2 6   195 106   479
690974 MN Beltrami 4 school 2730510 38 Independent Districts and Schools RED LAKE PUBLIC SCHOOL DISTRICT 273051001302 10 RED LAKE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 01 05 2017   pk_12_total 0.0 1.0 0.0   568.0 0.0     0.0   0.0   292.0 277.0         85.0     508.0   103.0   569.0 0 1 0   568 0     0   0   292 277       85   508 103   569
691135 MN Brown 8 school 2723490 88 Independent Districts and Schools NEW ULM PUBLIC SCHOOL DISTRICT 272349001150 20 JEFFERSON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 01 04 2017   pk_12_total 587.0 7.0 37.0   0.0 2.0     0.0   21.0   354.0 300.0     7.0   3.0     211.0   93.0   654.0 587 7 37   0 2     0   21   354 300     7 3   211 93   654
691244 MN Carver 10 school 2741910 111 Independent Districts and Schools WATERTOWN-MAYER PUBLIC SCHOOL DIST. 274191003674 839 WATERTOWN-MAYER ELEMENTARY SCHOOL Elementary School (Grades PK-6) Regular School No Elementary 01 05 2017   pk_12_total 561.0 4.0 12.0   5.0 8.0     0.0   14.0   317.0 287.0     10.0   0.0     156.0   101.0   604.0 561 4 12   5 8     0   14   317 287     10 0   156 101   604
691287 MN Carver 10 school 2708190 112 Independent Districts and Schools EASTERN CARVER COUNTY PUBLIC SCHOOL 270819003067 511 CLOVER RIDGE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 01 05 2017   pk_12_total 460.0 39.0 22.0   0.0 33.0     0.0   43.0   292.0 305.0     44.0   0.0     108.0   69.0   597.0 460 39 22   0 33     0   43   292 305     44 0   108 69   597
691338 MN Chippewa 12 school 2721320 129 Independent Districts and Schools MONTEVIDEO PUBLIC SCHOOL DISTRICT 272132001073 10 RAMSEY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 01 03 2017   pk_12_total 246.0 6.0 61.0   5.0 0.0     1.0   9.0   173.0 155.0     46.0   0.0     168.0   72.0   328.0 246 6 61   5 0     1   9   173 155     46 0   168 72   328
693217 MN Mower 50 school 2703450 492 Independent Districts and Schools AUSTIN PUBLIC SCHOOL DISTRICT 270345000149 10 BANFIELD ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 01 04 2017   pk_12_total 266.0 45.0 101.0   0.0 27.0     3.0   11.0   208.0 245.0     95.0   0.0     245.0   64.0   453.0 266 45 101   0 27     3   11   208 245     95 0   245 64   453
693222 MN Mower 50 school 2703450 492 Independent Districts and Schools AUSTIN PUBLIC SCHOOL DISTRICT 270345000153 40 NEVELN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 01 04 2017   pk_12_total 181.0 16.0 103.0   0.0 23.0     0.0   9.0   155.0 177.0     73.0   10.0     200.0   32.0   332.0 181 16 103   0 23     0   9   155 177     73 10   200 32   332
693227 MN Mower 50 school 2703450 492 Independent Districts and Schools AUSTIN PUBLIC SCHOOL DISTRICT 270345002230 70 SOUTHGATE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 01 04 2017   pk_12_total 278.0 22.0 140.0   0.0 24.0     3.0   22.0   245.0 244.0     118.0   5.0     263.0   68.0   489.0 278 22 140   0 24     3   22   245 244     118 5   263 68   489
693232 MN Mower 50 school 2703450 492 Independent Districts and Schools AUSTIN PUBLIC SCHOOL DISTRICT 270345000156 80 SUMNER ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 01 04 2017   pk_12_total 64.0 36.0 122.0   0.0 45.0     1.0   18.0   144.0 142.0     125.0   5.0     244.0   39.0   286.0 64 36 122   0 45     1   18   144 142     125 5   244 39   286
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
693651 MN Ramsey 62 school 2722950 621 Independent Districts and Schools MOUNDS VIEW PUBLIC SCHOOL DISTRICT 272295001114 25 BEL AIR ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 01 05 2017   pk_12_total 396.0 123.0 91.0   0.0 39.0     0.0   51.0   364.0 336.0     72.0   10.0     279.0   48.0   700.0 396 123 91   0 39     0   51   364 336     72 10   279 48   700
693657 MN Ramsey 62 school 2722950 621 Independent Districts and Schools MOUNDS VIEW PUBLIC SCHOOL DISTRICT 272295001119 26 ISLAND LAKE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 01 05 2017   pk_12_total 534.0 52.0 31.0   3.0 103.0     0.0   46.0   389.0 380.0     37.0   4.0     149.0   65.0   769.0 534 52 31   3 103     0   46   389 380     37 4   149 65   769
693663 MN Ramsey 62 school 2722950 621 Independent Districts and Schools MOUNDS VIEW PUBLIC SCHOOL DISTRICT 272295001124 30 PINEWOOD ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 01 05 2017   pk_12_total 285.0 64.0 69.0   6.0 66.0     3.0   49.0   282.0 260.0     69.0   7.0     308.0   65.0   542.0 285 64 69   6 66     3   49   282 260     69 7   308 65   542
693669 MN Ramsey 62 school 2722950 621 Independent Districts and Schools MOUNDS VIEW PUBLIC SCHOOL DISTRICT 272295001128 34 SUNNYSIDE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 01 05 2017   pk_12_total 329.0 64.0 58.0   2.0 52.0     1.0   57.0   294.0 269.0     40.0   14.0     252.0   81.0   563.0 329 64 58   2 52     1   57   294 269     40 14   252 81   563
693675 MN Ramsey 62 school 2722950 621 Independent Districts and Schools MOUNDS VIEW PUBLIC SCHOOL DISTRICT 272295001129 35 Turtle Lake Elementary Elementary School (Grades PK-6) Regular School No Elementary 01 05 2017   pk_12_total 697.0 28.0 37.0   3.0 138.0     0.0   54.0   517.0 440.0     29.0   3.0     122.0   89.0   957.0 697 28 37   3 138     0   54   517 440     29 3   122 89   957
693681 MN Ramsey 62 school 2722950 621 Independent Districts and Schools MOUNDS VIEW PUBLIC SCHOOL DISTRICT 272295001130 36 Valentine Hills Elementary Elementary School (Grades PK-6) Regular School No Elementary 01 05 2017   pk_12_total 372.0 91.0 73.0   5.0 59.0     0.0   42.0   350.0 292.0     66.0   7.0     283.0   56.0   642.0 372 91 73   5 59     0   42   350 292     66 7   283 56   642
694056 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384001594 494 CAPITOL HILL MAGNET/RONDO Elementary School (Grades PK-6) Regular School No Elementary 01 08 2017   pk_12_total 479.0 274.0 84.0   2.0 343.0     1.0   65.0   663.0 585.0     219.0   1.0     571.0   66.0   1248.0 479 274 84   2 343     1   65   663 585     219 1   571 66   1248
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
695251 MN Watonwan 83 school 2733600 840 Independent Districts and Schools ST. JAMES PUBLIC SCHOOL DISTRICT 273360001506 20 ST. JAMES NORTHSIDE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 01 05 2017   pk_12_total 167.0 2.0 193.0   0.0 1.0     0.0   1.0   172.0 192.0     76.0   9.0     214.0   46.0   364.0 167 2 193   0 1     0   1   172 192     76 9   214 46   364
695427 MN Wright 86 school 2733790 885 Independent Districts and Schools ST. MICHAEL-ALBERTVILLE SCHOOL DIST 273379000032 40 ST. MICHAEL ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 01 04 2017   pk_12_total 470.0 11.0 19.0   0.0 10.0     0.0   24.0   279.0 255.0     9.0   3.0     73.0   35.0   534.0 470 11 19   0 10     0   24   279 255     9 3   73 35   534
695432 MN Wright 86 school 2733790 885 Independent Districts and Schools ST. MICHAEL-ALBERTVILLE SCHOOL DIST 273379004187 60 BIG WOODS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 01 04 2017   pk_12_total 562.0 15.0 19.0   1.0 15.0     1.0   25.0   322.0 316.0     16.0   0.0     45.0   51.0   638.0 562 15 19   1 15     1   25   322 316     16 0   45 51   638
695437 MN Wright 86 school 2733790 885 Independent Districts and Schools ST. MICHAEL-ALBERTVILLE SCHOOL DIST 273379003673 70 FIELDSTONE ELEMENTARY SCHOOL Elementary School (Grades PK-6) Regular School No Elementary 01 04 2017   pk_12_total 561.0 22.0 21.0   2.0 11.0     0.0   31.0   353.0 295.0     18.0   0.0     88.0   58.0   648.0 561 22 21   2 11     0   31   353 295     18 0   88 58   648
696687 MN Carver 10 school 2700116 4016 Charter Schools WORLD LEARNER CHARTER SCHOOL 270011602606 10 WORLD LEARNER CHARTER SCHOOL Elementary School (Grades PK-6) Regular School Yes Elementary 01 08 2017   pk_12_total 183.0 3.0 10.0   0.0 8.0     0.0   4.0   95.0 113.0     2.0   0.0     19.0   28.0   208.0 183 3 10   0 8     0   4   95 113     2 0   19 28   208
696989 MN Ramsey 62 school 2700344 4105 Charter Schools GREAT RIVER SCHOOL 270034404665 20 Great River Elementary School Elementary School (Grades PK-6) Regular School Yes Elementary 01 06 2017   pk_12_total 90.0 8.0 12.0   2.0 4.0     1.0   6.0   58.0 65.0     3.0   0.0     18.0   20.0   123.0 90 8 12   2 4     1   6   58 65     3 0   18 20   123
699813 MN Carlton 9 school 2709420 94 Independent Districts and Schools CLOQUET PUBLIC SCHOOL DISTRICT 270942002236 103 CLOQUET AREA ALT. ED. PROGRAMS Public Area Learning Center ALC (State approved) Alternative School No Other 01 12 2017   pk_12_total 58.0 0.0 1.0   16.0 0.0     0.0   9.0   52.0 32.0     0.0   2.0     59.0   *   84.0 58 0 1   16 0     0   9   52 32     0 2   59     84
699820 MN Carver 10 school 2741460 110 Independent Districts and Schools WACONIA PUBLIC SCHOOL DISTRICT 274146004597 601 WACONIA ALTERNATIVE LEARNING CENTER Public Area Learning Center ALC (State approved) Alternative School No Other 01 12 2017   pk_12_total 30.0 1.0 2.0   0.0 0.0     0.0   1.0   15.0 19.0     0.0   0.0     11.0   7.0   34.0 30 1 2   0 0     0   1   15 19     0 0   11 7   34
700414 MN Benton 5 school 2700143 6074 Miscellaneous Cooperatives CENTRAL MINNESOTA JT. POWERS DIST. 270014302723 647 CENTRAL MN. ALC - SAUK RAPIDS Public Area Learning Center ALC (State approved) Alternative School No Other 01 12 2017   pk_12_total 5.0 0.0 0.0   0.0 0.0     0.0   2.0   3.0 4.0         *         *   7.0 5 0 0   0 0     0   2   3 4                 7
700916 MN Chisago 13 school 2700017 2144 Independent Districts and Schools CHISAGO LAKES SCHOOL DISTRICT 270001704939 17 SOAR Special Education Special Education School No Other 01 12 2017   pk_12_total 3.0 0.0 0.0   0.0 0.0     0.0   1.0   3.0 1.0         *         *   4.0 3 0 0   0 0     0   1   3 1                 4
701041 MN Hennepin 27 school 2700025 287 Intermediate Districts and Schools INTERMEDIATE SCHOOL DISTRICT 287 270002503542 479 SAFE Special Education Special Education School No Other 01 12 2017   pk_12_total 9.0 19.0 2.0   1.0 1.0     0.0   2.0   26.0 8.0     0.0   2.0     26.0   *   34.0 9 19 2   1 1     0   2   26 8     0 2   26     34
701052 MN Hennepin 27 school 2700025 287 Intermediate Districts and Schools INTERMEDIATE SCHOOL DISTRICT 287 270002503229 480 STRIVE SECONDARY Special Education Special Education School No Other 01 12 2017   pk_12_total 6.0 18.0 0.0   0.0 0.0     0.0   1.0   17.0 8.0     1.0   2.0         *   25.0 6 18 0   0 0     0   1   17 8     1 2         25
701066 MN Hennepin 27 school 2700025 287 Intermediate Districts and Schools INTERMEDIATE SCHOOL DISTRICT 287 270002503234 486 CIP Special Education Special Education School No Other 01 12 2017   pk_12_total 44.0 14.0 5.0   1.0 3.0     0.0   6.0   70.0 3.0     3.0   0.0     32.0   *   73.0 44 14 5   1 3     0   6   70 3     3 0   32     73
701081 MN Scott 70 school 2700420 288 Intermediate Districts and Schools Southwest Metro Intermediate 288 270042005038 12 SW Metro Level 4 Programs Special Education Special Education School No Other 01 12 2017   pk_12_total 87.0 15.0 7.0   5.0 2.0     0.0   2.0   97.0 21.0     0.0   1.0     65.0   *   118.0 87 15 7   5 2     0   2   97 21     0 1   65     118
701306 MN Mille Lacs 48 school 2700318 6079 Special Education Cooperatives RUM RIVER SPECIAL EDUCATION COOP 270031804296 10 RUM RIVER NORTH Special Education Special Education School No Other 01 12 2017   pk_12_total 82.0 7.0 1.0   4.0 0.0     0.0   2.0   80.0 16.0     0.0   3.0     59.0   *   96.0 82 7 1   4 0     0   2   80 16     0 3   59     96
701403 MN Cottonwood 17 school 2700086 991 Service Cooperative (ECSU Region) Region 6 and 8-SW/WC Service Cooperative 270008604168 16 RED ROCK RIDGE SETTING IV Special Education Special Education School No Other 01 12 2017   pk_12_total 24.0 0.0 6.0   0.0 1.0     0.0   1.0   30.0 2.0     0.0   0.0     23.0   *   32.0 24 0 6   0 1     0   1   30 2     0 0   23     32
701551 MN Stearns 73 school 2791455 6026 Education Districts WEST CENTRAL EDUCATION DISTRICT 279145503591 24 BEACON PROGRAM W CENTRAL ED. DIST. Special Education Special Education School No Other 01 11 2017   pk_12_total 13.0 0.0 0.0   0.0 0.0     0.0   0.0   12.0 1.0     0.0   0.0     1.0   *   13.0 13 0 0   0 0     0   0   12 1     0 0   1     13
701994 MN Hennepin 27 school 2733780 283 Independent Districts and Schools ST. LOUIS PARK PUBLIC SCHOOL DIST. 273378004332 759 MELROSE Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No Other 01 12 2017   pk_12_total 1.0 0.0 0.0   0.0 1.0     0.0   0.0   0.0 2.0         *         *   2.0 1 0 0   0 1     0   0   0 2                 2
702089 MN Saint Louis 69 school 2711040 709 Independent Districts and Schools DULUTH PUBLIC SCHOOL DISTRICT 271104001562 81 MERRITT CREEK ACADEMY Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No Other 01 12 2017   pk_12_total 55.0 9.0 4.0   13.0 0.0     0.0   21.0   72.0 30.0     0.0   1.0     86.0   68.0   102.0 55 9 4   13 0     0   21   72 30     0 1   86 68   102
702354 MN Mille Lacs 48 school 2730030 477 Independent Districts and Schools PRINCETON PUBLIC SCHOOL DISTRICT 273003004936 90 Princeton Alternative Services Educational Oversight to Public Care and Treatment Day Program Alternative School No Other 01 12 2017   pk_12_total 7.0 0.0 2.0   2.0 0.0     0.0   0.0   6.0 5.0     0.0   1.0     8.0   9.0   11.0 7 0 2   2 0     0   0   6 5     0 1   8 9   11
691841 MN Dakota 19 school 2715030 199 Independent Districts and Schools INVER GROVE HEIGHTS SCHOOLS 271503003184 574 ATHENEUM ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 02 05 2017   pk_12_total 70.0 2.0 6.0   0.0 18.0     0.0   7.0   61.0 42.0         0.0     12.0   5.0   103.0 70 2 6   0 18     0   7   61 42       0   12 5   103
692052 MN Goodhue 25 school 2730480 256 Independent Districts and Schools RED WING PUBLIC SCHOOL DISTRICT 273048001292 537 BURNSIDE ELEMENTARY. Elementary School (Grades PK-6) Regular School No Elementary 02 04 2017   pk_12_total 413.0 13.0 64.0   23.0 5.0     0.0   42.0   286.0 274.0     19.0   3.0     218.0   86.0   560.0 413 13 64   23 5     0   42   286 274     19 3   218 86   560
693033 MN Mcleod 43 school 2714970 423 Independent Districts and Schools HUTCHINSON PUBLIC SCHOOL DISTRICT 271497000754 10 HUTCHINSON PARK ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 02 05 2017   pk_12_total 715.0 11.0 68.0   0.0 8.0     0.0   29.0   436.0 395.0     38.0   3.0     275.0   100.0   831.0 715 11 68   0 8     0   29   436 395     38 3   275 100   831
693605 MN Polk 60 school 2709720 593 Independent Districts and Schools CROOKSTON PUBLIC SCHOOL DISTRICT 270972000414 80 HIGHLAND ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 02 06 2017   pk_12_total 297.0 13.0 112.0   16.0 3.0     0.0   30.0   232.0 239.0     40.0   31.0     238.0   80.0   471.0 297 13 112   16 3     0   30   232 239     40 31   238 80   471
693817 MN Washington 82 school 2742360 624 Independent Districts and Schools WHITE BEAR LAKE SCHOOL DISTRICT 274236003699 824 ONEKA ELEMENTARY SCHOOL Elementary School (Grades PK-6) Regular School No Elementary 02 05 2017   pk_12_total 548.0 15.0 24.0   2.0 20.0     0.0   31.0   319.0 321.0     16.0   0.0     117.0   70.0   640.0 548 15 24   2 20     0   31   319 321     16 0   117 70   640
693964 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384002672 462 L'ETOILE DU NORD FRENCH IMMERSION U Elementary School (Grades PK-6) Regular School No Elementary 02 05 2017   pk_12_total 200.0 68.0 41.0   2.0 21.0     0.0   34.0   158.0 208.0     54.0   1.0     114.0   10.0   366.0 200 68 41   2 21     0   34   158 208     54 1   114 10   366
695966 MN Pipestone 59 school 2700108 2689 Independent Districts and Schools PIPESTONE AREA SCHOOL DISTRICT 270010801262 3 HILL ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 02 04 2017   pk_12_total 181.0 5.0 44.0   2.0 4.0     0.0   14.0   122.0 128.0     26.0   0.0     136.0   37.0   250.0 181 5 44   2 4     0   14   122 128     26 0   136 37   250
700500 MN Carlton 9 school 2709420 94 Independent Districts and Schools CLOQUET PUBLIC SCHOOL DISTRICT 270942004962 110 CAAEP SETTING 4 Special Education Special Education School No Other 02 12 2017   pk_12_total 3.0 0.0 0.0   5.0 0.0     0.0   0.0   8.0 0.0         *         *   8.0 3 0 0   5 0     0   0   8 0                 8
700848 MN Sherburne 71 school 2711370 728 Independent Districts and Schools ELK RIVER PUBLIC SCHOOL DISTRICT 271137004142 401 ISD 728 FOCUS/JOURNEY Special Education Special Education School No Other 02 12 2017   pk_12_total 15.0 3.0 1.0   0.0 0.0     0.0   4.0   23.0 0.0     0.0   1.0     16.0   *   23.0 15 3 1   0 0     0   4   23 0     0 1   16     23
701068 MN Scott 70 school 2700420 288 Intermediate Districts and Schools Southwest Metro Intermediate 288 270042005063 11 SW Shakopee Special Ed Special Education Special Education School No Other 02 12 2017   pk_12_total 26.0 2.0 0.0   0.0 2.0     0.0   0.0   19.0 11.0     0.0   0.0     12.0   *   30.0 26 2 0   0 2     0   0   19 11     0 0   12     30
701357 MN Wright 86 school 2700413 6090 Special Education Cooperatives Sherburne and Northern Wright Special Education Cooperative 270041304947 80 Becker Intermediate School - SNW Special Education Special Education School No Elementary 02 06 2017   pk_12_total 5.0 0.0 0.0   0.0 0.0     0.0   1.0   6.0 0.0         *         *   6.0 5 0 0   0 0     0   1   6 0                 6
701494 MN Otter Tail 56 school 2700014 6004 Education Districts FRESHWATER ED. DIST. 270001404821 50 Elm Tree Academy Special Education Special Education School No Other 02 12 2017   pk_12_total 4.0 0.0 0.0   0.0 0.0     0.0   0.0   4.0 0.0         *         *   4.0 4 0 0   0 0     0   0   4 0                 4
701579 MN Brown 8 school 2791353 6049 Education Districts RIVER BEND EDUCATION DISTRICT 279135304366 35 IMPRINTS PROGRAM Special Education Special Education School No Other 02 12 2017   pk_12_total 32.0 3.0 1.0   0.0 0.0     0.0   1.0   29.0 8.0     0.0   0.0     28.0   *   37.0 32 3 1   0 0     0   1   29 8     0 0   28     37
702071 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384001334 678 JUVENILE SERVICE CENTER Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No Other 02 12 2017   pk_12_total 1.0 21.0 1.0   1.0 1.0     0.0   0.0   22.0 3.0     1.0   2.0         15.0   25.0 1 21 1   1 1     0   0   22 3     1 2     15   25
702272 MN Crow Wing 18 school 2706090 181 Independent Districts and Schools BRAINERD PUBLIC SCHOOL DISTRICT 270609000468 17 LINCOLN EDUCATION CENTER Miscellaneous Program (assignment is now limited) Alternative School No Other 02 12 2017   pk_12_total 46.0 5.0 1.0   5.0 2.0     0.0   6.0   50.0 15.0     2.0   *         54.0   65.0 46 5 1   5 2     0   6   50 15     2       54   65
691605 MN Dakota 19 school 2711820 192 Independent Districts and Schools FARMINGTON PUBLIC SCHOOL DISTRICT 271182004816 155 Gateway Academy Elementary School (Grades PK-6) Regular School No Elementary 03 08 2017   pk_12_total 42.0 2.0 5.0   0.0 1.0     0.0   3.0   32.0 21.0         0.0         *   53.0 42 2 5   0 1     0   3   32 21       0         53
692357 MN Hennepin 27 school 2725080 278 Independent Districts and Schools ORONO PUBLIC SCHOOL DISTRICT 272508003444 662 ORONO INTERMEDIATE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 03 05 2017   pk_12_total 543.0 4.0 33.0   1.0 5.0     0.0   18.0   323.0 281.0     15.0   2.0     47.0   62.0   604.0 543 4 33   1 5     0   18   323 281     15 2   47 62   604
692857 MN Kanabec 33 school 2721480 332 Independent Districts and Schools MORA PUBLIC SCHOOL DISTRICT 272148001097 30 TRAILVIEW ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 03 06 2017   pk_12_total 476.0 4.0 14.0   5.0 4.0     0.0   20.0   262.0 261.0     1.0   6.0     227.0   83.0   523.0 476 4 14   5 4     0   20   262 261     1 6   227 83   523
693011 MN Lyon 42 school 2718940 413 Independent Districts and Schools MARSHALL PUBLIC SCHOOL DISTRICT 271894000894 3 WEST SIDE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 03 04 2017   pk_12_total 207.0 43.0 52.0   2.0 28.0     0.0   18.0   185.0 165.0         3.0     175.0   56.0   350.0 207 43 52   2 28     0   18   185 165       3   175 56   350
693072 MN Marshall 45 school 2723550 441 Independent Districts and Schools MARSHALL COUNTY CENTRAL SCHOOLS 272355001158 10 NEWFOLDEN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 03 06 2017   pk_12_total 111.0 1.0 2.0   0.0 1.0     0.0   3.0   57.0 61.0     0.0   0.0     46.0   15.0   118.0 111 1 2   0 1     0   3   57 61     0 0   46 15   118
693146 MN Mille Lacs 48 school 2730030 477 Independent Districts and Schools PRINCETON PUBLIC SCHOOL DISTRICT 273003001271 10 Princeton Intermediate School Elementary School (Grades PK-6) Regular School No Elementary 03 05 2017   pk_12_total 708.0 1.0 14.0   4.0 3.0     0.0   18.0   360.0 388.0     1.0   11.0     271.0   85.0   748.0 708 1 14   4 3     0   18   360 388     1 11   271 85   748
693294 MN Nicollet 52 school 2733870 508 Independent Districts and Schools ST. PETER PUBLIC SCHOOL DISTRICT 273387001638 30 North Intermediate School Elementary School (Grades PK-6) Regular School No Elementary 03 06 2017   pk_12_total 476.0 45.0 100.0   2.0 8.0     0.0   12.0   341.0 302.0     54.0   9.0     274.0   86.0   643.0 476 45 100   2 8     0   12   341 302     54 9   274 86   643
693325 MN Olmsted 55 school 2707350 531 Independent Districts and Schools BYRON PUBLIC SCHOOL DISTRICT 270735000306 10 Byron Intermediate School Elementary School (Grades PK-6) Regular School No Elementary 03 05 2017   pk_12_total 445.0 4.0 16.0   2.0 3.0     1.0   12.0   251.0 232.0     1.0   1.0     63.0   51.0   483.0 445 4 16   2 3     1   12   251 232     1 1   63 51   483
693342 MN Olmsted 55 school 2738160 534 Independent Districts and Schools STEWARTVILLE PUBLIC SCHOOL DISTRICT 273816001652 10 Bear Cave Intermediate School Elementary School (Grades PK-6) Regular School No Elementary 03 05 2017   pk_12_total 470.0 3.0 15.0   1.0 5.0     0.0   13.0   263.0 244.0     4.0   0.0     113.0   63.0   507.0 470 3 15   1 5     0   13   263 244     4 0   113 63   507
693417 MN Olmsted 55 school 2731800 535 Independent Districts and Schools ROCHESTER PUBLIC SCHOOL DISTRICT 273180001001 134 HOOVER ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 03 05 2017   pk_12_total 184.0 11.0 12.0   0.0 16.0     0.0   16.0   129.0 110.0     6.0   5.0     75.0   59.0   239.0 184 11 12   0 16     0   16   129 110     6 5   75 59   239
693488 MN Otter Tail 56 school 2711880 544 Independent Districts and Schools FERGUS FALLS PUBLIC SCHOOL DISTRICT 271188000574 140 CLEVELAND ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 03 05 2017   pk_12_total 508.0 18.0 18.0   5.0 3.0     1.0   21.0   286.0 288.0     12.0   0.0     217.0   78.0   574.0 508 18 18   5 3     1   21   286 288     12 0   217 78   574
693609 MN Polk 60 school 2711130 595 Independent Districts and Schools EAST GRAND FORKS PUBLIC SCHOOL DIST 271113000495 110 SOUTH POINT ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 03 05 2017   pk_12_total 338.0 34.0 49.0   5.0 2.0     0.0   13.0   244.0 197.0     29.0   0.0     165.0   54.0   441.0 338 34 49   5 2     0   13   244 197     29 0   165 54   441
694336 MN Saint Louis 69 school 2713980 701 Independent Districts and Schools HIBBING PUBLIC SCHOOL DISTRICT 271398001529 310 Lincoln Elementary Elementary School (Grades PK-6) Regular School No Elementary 03 06 2017   pk_12_total 671.0 15.0 11.0   17.0 7.0     1.0   57.0   392.0 387.0     3.0   8.0     387.0   143.0   779.0 671 15 11   17 7     1   57   392 387     3 8   387 143   779
694356 MN Saint Louis 69 school 2741040 706 Independent Districts and Schools VIRGINIA PUBLIC SCHOOL DISTRICT 274104001716 30 ROOSEVELT ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 03 06 2017   pk_12_total 431.0 9.0 11.0   17.0 4.0     0.0   61.0   285.0 248.0     0.0   0.0     239.0   80.0   533.0 431 9 11   17 4     0   61   285 248     0 0   239 80   533
694455 MN Scott 70 school 2704050 716 Independent Districts and Schools BELLE PLAINE PUBLIC SCHOOL DISTRICT 270405003718 11 OAK CREST ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 03 06 2017   pk_12_total 432.0 6.0 23.0   2.0 10.0     1.0   19.0   254.0 239.0     8.0   0.0     105.0   66.0   493.0 432 6 23   2 10     1   19   254 239     8 0   105 66   493
694570 MN Sherburne 71 school 2703870 726 Independent Districts and Schools BECKER PUBLIC SCHOOL DISTRICT 270387000179 10 BECKER INTERMEDIATE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 03 05 2017   pk_12_total 589.0 3.0 21.0   1.0 6.0     0.0   25.0   311.0 334.0     9.0   2.0     115.0   72.0   645.0 589 3 21   1 6     0   25   311 334     9 2   115 72   645
694626 MN Sherburne 71 school 2711370 728 Independent Districts and Schools ELK RIVER PUBLIC SCHOOL DISTRICT 271137004141 210 WESTWOOD ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 03 05 2017   pk_12_total 537.0 3.0 18.0   0.0 2.0     1.0   25.0   282.0 304.0     8.0   1.0     143.0   78.0   586.0 537 3 18   0 2     1   25   282 304     8 1   143 78   586
695036 MN Washington 82 school 2718750 832 Independent Districts and Schools MAHTOMEDI PUBLIC SCHOOL DISTRICT 271875000868 10 O.H. ANDERSON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 03 05 2017   pk_12_total 586.0 22.0 36.0   0.0 10.0     0.0   44.0   353.0 345.0     15.0   0.0     66.0   78.0   698.0 586 22 36   0 10     0   44   353 345     15 0   66 78   698
695467 MN Isanti 30 school 2707410 911 Independent Districts and Schools CAMBRIDGE-ISANTI PUBLIC SCHOOL DIST 270741003657 201 CAMBRIDGE INTERMEDIATE SCHOOL Elementary School (Grades PK-6) Regular School No Elementary 03 05 2017   pk_12_total 582.0 6.0 15.0   4.0 7.0     0.0   31.0   343.0 302.0     4.0   4.0     251.0   95.0   645.0 582 6 15   4 7     0   31   343 302     4 4   251 95   645
695471 MN Isanti 30 school 2707410 911 Independent Districts and Schools CAMBRIDGE-ISANTI PUBLIC SCHOOL DIST 270741003705 202 ISANTI INTERMEDIATE SCHOOL Elementary School (Grades PK-6) Regular School No Elementary 03 05 2017   pk_12_total 395.0 5.0 15.0   1.0 2.0     0.0   17.0   216.0 219.0     7.0   8.0     163.0   61.0   435.0 395 5 15   1 2     0   17   216 219     7 8   163 61   435
695600 MN Chisago 13 school 2700017 2144 Independent Districts and Schools CHISAGO LAKES SCHOOL DISTRICT 270001701673 2 LAKESIDE EL. Elementary School (Grades PK-6) Regular School No Elementary 03 05 2017   pk_12_total 518.0 6.0 12.0   1.0 9.0     0.0   12.0   306.0 252.0     6.0   3.0     120.0   79.0   558.0 518 6 12   1 9     0   12   306 252     6 3   120 79   558
695888 MN Martin 46 school 2718960 2448 Independent Districts and Schools MARTIN COUNTY WEST SCHOOL DISTRICT 271896000072 15 TRIMONT ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 03 06 2017   pk_12_total 225.0 3.0 11.0   0.0 0.0     0.0   6.0   137.0 108.0     1.0   0.0     113.0   35.0   245.0 225 3 11   0 0     0   6   137 108     1 0   113 35   245
696033 MN Wabasha 79 school 2745735 2805 Independent Districts and Schools ZUMBROTA-MAZEPPA SCHOOL DISTRICT 274573500200 1 ZUMBROTA-MAZEPPA ELEMENTARY SCHOOL Elementary School (Grades PK-6) Regular School No Elementary 03 06 2017   pk_12_total 350.0 8.0 13.0   3.0 5.0     0.0   3.0   187.0 195.0     4.0   3.0     88.0   50.0   382.0 350 8 13   3 5     0   3   187 195     4 3   88 50   382
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
696335 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124004742 132 Howe Elementary Elementary School (Grades PK-6) Regular School No Elementary 03 05 2017   pk_12_total 108.0 24.0 40.0   3.0 4.0     0.0   6.0   98.0 87.0     31.0   10.0     83.0   28.0   185.0 108 24 40   3 4     0   6   98 87     31 10   83 28   185
696342 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124000988 134 LK NOKOMIS COMM-KEEWAYDIN CAMPUS Elementary School (Grades PK-6) Regular School No Elementary 03 08 2017   pk_12_total 226.0 97.0 74.0   21.0 16.0     1.0   11.0   223.0 223.0     54.0   23.0     242.0   70.0   446.0 226 97 74   21 16     1   11   223 223     54 23   242 70   446
701656 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000002 464 ANTHONY LOUIS HOUSE Hospital/Medical/Partial Hospitalization Program Alternative School No Other 03 12 2017   pk_12_total 15.0 2.0 0.0   0.0 0.0     0.0   1.0   15.0 3.0     0.0   0.0     7.0   4.0   18.0 15 2 0   0 0     0   1   15 3     0 0   7 4   18
701749 MN Anoka 2 school 2733540 15 Independent Districts and Schools ST. FRANCIS PUBLIC SCHOOL DISTRICT 273354004917 15 Saints Online Distance Learning Program OLL (State approved) Regular School No Other 03 12 2017   pk_12_total 46.0 1.0 0.0   0.0 0.0     0.0   0.0   23.0 24.0     0.0   *     7.0   4.0   47.0 46 1 0   0 0     0   0   23 24     0     7 4   47
701808 MN Mille Lacs 48 school 2730030 477 Independent Districts and Schools PRINCETON PUBLIC SCHOOL DISTRICT 273003004927 80 Princeton Online Academy Distance Learning Program OLL (State approved) Regular School No Other 03 12 2017   pk_12_total 45.0 0.0 0.0   0.0 0.0     0.0   1.0   20.0 26.0     0.0   0.0     17.0   8.0   46.0 45 0 0   0 0     0   1   20 26     0 0   17 8   46
701949 MN Beltrami 4 school 2704440 31 Independent Districts and Schools BEMIDJI PUBLIC SCHOOL DISTRICT 270444000313 160 FIRST CITY SCHOOL Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No Other 03 12 2017   pk_12_total 17.0 3.0 3.0   39.0 0.0     0.0   1.0   38.0 25.0     0.0   3.0         27.0   63.0 17 3 3   39 0     0   1   38 25     0 3     27   63
701973 MN Clay 14 school 2721420 152 Independent Districts and Schools MOORHEAD PUBLIC SCHOOL DISTRICT 272142002799 970 CLAY COUNTY SHELTER CARE Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No Other 03 12 2017   pk_12_total 6.0 1.0 2.0   2.0 0.0     0.0   1.0   8.0 4.0     0.0   2.0         *   12.0 6 1 2   2 0     0   1   8 4     0 2         12
690849 MN Anoka 2 school 2733330 16 Independent Districts and Schools SPRING LAKE PARK PUBLIC SCHOOLS 273333001465 773 WESTWOOD INTERMEDIATE SCHOOL Elementary School (Grades PK-6) Regular School No Elementary 04 05 2017   pk_12_total 440.0 102.0 89.0   13.0 60.0     0.0   55.0   389.0 370.0     109.0   7.0     334.0   104.0   759.0 440 102 89   13 60     0   55   389 370     109 7   334 104   759
691023 MN Benton 5 school 2712240 51 Independent Districts and Schools FOLEY PUBLIC SCHOOL DISTRICT 271224002270 30 FOLEY INTERMEDIATE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 04 08 2017   pk_12_total 744.0 1.0 5.0   2.0 0.0     0.0   12.0   397.0 367.0     0.0   1.0     214.0   119.0   764.0 744 1 5   2 0     0   12   397 367     0 1   214 119   764
692602 MN Hennepin 27 school 2731780 281 Independent Districts and Schools ROBBINSDALE PUBLIC SCHOOL DISTRICT 273178004952 401 The FAIR School - Crystal Elementary School (Grades PK-6) Regular School No Elementary 04 08 2017   pk_12_total 205.0 262.0 45.0   11.0 15.0     2.0   47.0   248.0 339.0     27.0   9.0     313.0   79.0   587.0 205 262 45   11 15     2   47   248 339     27 9   313 79   587
694102 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384001612 528 LINWOOD MONROE ARTS PLUS UPPER Elementary School (Grades PK-6) Regular School No Elementary 04 08 2017   pk_12_total 180.0 163.0 57.0   4.0 119.0     0.0   27.0   234.0 316.0     177.0   4.0     353.0   106.0   550.0 180 163 57   4 119     0   27   234 316     177 4   353 106   550
694298 MN Saint Louis 69 school 2708910 695 Independent Districts and Schools CHISHOLM PUBLIC SCHOOL DISTRICT 270891000356 301 CHISHOLM ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 04 06 2017   pk_12_total 155.0 6.0 2.0   3.0 0.0     0.0   9.0   96.0 79.0     0.0   0.0     84.0   42.0   175.0 155 6 2   3 0     0   9   96 79     0 0   84 42   175
694975 MN Waseca 81 school 2741880 829 Independent Districts and Schools WASECA PUBLIC SCHOOL DISTRICT 274188001746 40 WASECA INTERMEDIATE SCHOOL Elementary School (Grades PK-6) Regular School No Elementary 04 06 2017   pk_12_total 367.0 13.0 55.0   3.0 6.0     1.0   9.0   236.0 218.0     18.0   4.0     167.0   105.0   454.0 367 13 55   3 6     1   9   236 218     18 4   167 105   454
694987 MN Washington 82 school 2712270 831 Independent Districts and Schools FOREST LAKE PUBLIC SCHOOL DISTRICT 271227000594 626 FOREST LAKE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 04 06 2017   pk_12_total 315.0 4.0 16.0   1.0 15.0     1.0   24.0   189.0 187.0     14.0   1.0     124.0   58.0   376.0 315 4 16   1 15     1   24   189 187     14 1   124 58   376
695876 MN Sibley 72 school 2718070 2397 Independent Districts and Schools LE SUEUR-HENDERSON SCHOOL DISTRICT 271807000046 15 HILLTOP ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 04 05 2017   pk_12_total 101.0 8.0 33.0   0.0 0.0     0.0   3.0   69.0 76.0     9.0   1.0     56.0   20.0   145.0 101 8 33   0 0     0   3   69 76     9 1   56 20   145
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
696268 MN Douglas 21 school 2700382 2908 Independent Districts and Schools BRANDON-EVANSVILLE PUBLIC SCHOOLS 270038204739 2 Evansville Elementary Elementary School (Grades PK-6) Regular School No Elementary 04 05 2017   pk_12_total 72.0 1.0 3.0   0.0 0.0     0.0   3.0   43.0 36.0     0.0   1.0     25.0   9.0   79.0 72 1 3   0 0     0   3   43 36     0 1   25 9   79
696321 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124000969 121 LAKE HARRIET UPPER SCHOOL Elementary School (Grades PK-6) Regular School No Elementary 04 08 2017   pk_12_total 578.0 28.0 31.0   2.0 27.0     1.0   16.0   348.0 335.0     17.0   2.0     96.0   67.0   683.0 578 28 31   2 27     1   16   348 335     17 2   96 67   683
697801 MN Chippewa 12 school 2721320 129 Independent Districts and Schools MONTEVIDEO PUBLIC SCHOOL DISTRICT 272132001071 30 MONTEVIDEO MIDDLE Middle School (Grades 5-8) Regular School No Elementary 04 07 2017   pk_12_total 356.0 4.0 70.0   3.0 3.0     2.0   10.0   245.0 203.0     27.0   0.0     194.0   93.0   448.0 356 4 70   3 3     2   10   245 203     27 0   194 93   448

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