enrollments

Data source: Big Local News · About: Big Local

943 rows where grade = "grade_1", state = "MN" and year = 2017 sorted by ccd_school_high_grade

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2017 · 943 ✖

grade ✖

  • grade_1 · 943 ✖
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
694448 694448 MN Scott 70 school 2704050 716 Independent Districts and Schools BELLE PLAINE PUBLIC SCHOOL DISTRICT 270405000183 10 CHATFIELD ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 02 2017   grade_1 117.0 0.0 6.0   0.0 1.0     1.0   8.0   66.0 67.0     2.0   0.0     29.0   9.0   133.0 117 0 6   0 1     1   8   66 67     2 0   29 9   133
694464 694464 MN Scott 70 school 2730060 719 Independent Districts and Schools PRIOR LAKE-SAVAGE AREA SCHOOLS 273006003449 9 EDGEWOOD ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 02 2017   grade_1 52.0 0.0 10.0   0.0 0.0     0.0   5.0   25.0 42.0     4.0   0.0         0.0   67.0 52 0 10   0 0     0   5   25 42     4 0     0   67
694573 694573 MN Sherburne 71 school 2703870 726 Independent Districts and Schools BECKER PUBLIC SCHOOL DISTRICT 270387003092 40 BECKER PRIMARY Elementary School (Grades PK-6) Regular School No Elementary PK 02 2017   grade_1 206.0 1.0 4.0   0.0 0.0     0.0   13.0   105.0 119.0     2.0   1.0     37.0   19.0   224.0 206 1 4   0 0     0   13   105 119     2 1   37 19   224
694620 694620 MN Sherburne 71 school 2711370 728 Independent Districts and Schools ELK RIVER PUBLIC SCHOOL DISTRICT 271137000522 200 ZIMMERMAN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 02 2017   grade_1 159.0 0.0 5.0   0.0 1.0     0.0   8.0   96.0 77.0     2.0   0.0     50.0   32.0   173.0 159 0 5   0 1     0   8   96 77     2 0   50 32   173
695038 695038 MN Washington 82 school 2718750 832 Independent Districts and Schools MAHTOMEDI PUBLIC SCHOOL DISTRICT 271875000871 20 WILDWOOD ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 02 2017   grade_1 139.0 6.0 8.0   0.0 5.0     0.0   15.0   85.0 88.0     4.0   0.0     16.0   16.0   173.0 139 6 8   0 5     0   15   85 88     4 0   16 16   173
695449 695449 MN Isanti 30 school 2707410 911 Independent Districts and Schools CAMBRIDGE-ISANTI PUBLIC SCHOOL DIST 270741003638 101 CAMBRIDGE PRIMARY SCHOOL Elementary School (Grades PK-6) Regular School No Elementary PK 02 2017   grade_1 157.0 1.0 6.0   0.0 4.0     0.0   12.0   96.0 84.0     6.0   1.0     62.0   35.0   180.0 157 1 6   0 4     0   12   96 84     6 1   62 35   180
695454 695454 MN Isanti 30 school 2707410 911 Independent Districts and Schools CAMBRIDGE-ISANTI PUBLIC SCHOOL DIST 270741003686 102 ISANTI PRIMARY SCHOOL Elementary School (Grades PK-6) Regular School No Elementary PK 02 2017   grade_1 140.0 4.0 5.0   1.0 3.0     0.0   9.0   80.0 82.0     4.0   3.0     55.0   26.0   162.0 140 4 5   1 3     0   9   80 82     4 3   55 26   162
695594 695594 MN Chisago 13 school 2700017 2144 Independent Districts and Schools CHISAGO LAKES SCHOOL DISTRICT 270001700352 1 CHISAGO LAKES EL. Elementary School (Grades PK-6) Regular School No Elementary PK 02 2017   grade_1 178.0 0.0 5.0   0.0 1.0     0.0   2.0   92.0 94.0     2.0   2.0     45.0   12.0   186.0 178 0 5   0 1     0   2   92 94     2 2   45 12   186
695879 695879 MN Martin 46 school 2718960 2448 Independent Districts and Schools MARTIN COUNTY WEST SCHOOL DISTRICT 271896000067 10 SHERBURN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 02 2017   grade_1 46.0 0.0 0.0   1.0 0.0     0.0   3.0   31.0 19.0     0.0   0.0     20.0   5.0   50.0 46 0 0   1 0     0   3   31 19     0 0   20 5   50
696036 696036 MN Goodhue 25 school 2745735 2805 Independent Districts and Schools ZUMBROTA-MAZEPPA SCHOOL DISTRICT 274573504730 30 Zumbrota-Mazeppa Primary School Elementary School (Grades PK-6) Regular School No Elementary PK 02 2017   grade_1 94.0 1.0 4.0   0.0 1.0     0.0   3.0   59.0 44.0     2.0   0.0     21.0   8.0   103.0 94 1 4   0 1     0   3   59 44     2 0   21 8   103
696082 696082 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   grade_1 84.0 0.0 28.0   0.0 0.0     0.0   5.0   61.0 56.0     8.0   0.0     52.0   9.0   117.0 84 0 28   0 0     0   5   61 56     8 0   52 9   117
696329 696329 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124000978 130 HIAWATHA ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 02 2017   grade_1 48.0 12.0 11.0   2.0 1.0     0.0   5.0   39.0 40.0     9.0   0.0     33.0   11.0   79.0 48 12 11   2 1     0   5   39 40     9 0   33 11   79
696430 696430 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124001057 167 LK NOKOMIS COMM-WENONAH CAMPUS Elementary School (Grades PK-6) Regular School No Elementary KG 02 2017   grade_1 63.0 7.0 13.0   2.0 6.0     0.0   3.0   51.0 43.0     9.0   0.0     41.0   12.0   94.0 63 7 13   2 6     0   3   51 43     9 0   41 12   94
690843 690843 MN Anoka 2 school 2733330 16 Independent Districts and Schools SPRING LAKE PARK PUBLIC SCHOOLS 273333001461 772 NORTHPOINT ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 03 2017   grade_1 132.0 11.0 10.0   0.0 10.0     0.0   21.0   109.0 75.0     14.0   0.0     50.0   21.0   184.0 132 11 10   0 10     0   21   109 75     14 0   50 21   184
690858 690858 MN Anoka 2 school 2733330 16 Independent Districts and Schools SPRING LAKE PARK PUBLIC SCHOOLS 273333001462 775 Park Terrace Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 03 2017   grade_1 86.0 29.0 20.0   0.0 19.0     0.0   22.0   87.0 89.0     35.0   *     104.0   29.0   176.0 86 29 20   0 19     0   22   87 89     35     104 29   176
691014 691014 MN Benton 5 school 2712240 51 Independent Districts and Schools FOLEY PUBLIC SCHOOL DISTRICT 271224000590 10 FOLEY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 03 2017   grade_1 120.0 0.0 0.0   0.0 0.0     0.0   0.0   57.0 63.0     0.0   0.0     35.0   16.0   120.0 120 0 0   0 0     0   0   57 63     0 0   35 16   120
691335 691335 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   grade_1 85.0 2.0 25.0   2.0 0.0     0.0   3.0   64.0 53.0     16.0   0.0     69.0   25.0   117.0 85 2 25   2 0     0   3   64 53     16 0   69 25   117
691431 691431 MN Cottonwood 17 school 2742780 177 Independent Districts and Schools WINDOM PUBLIC SCHOOL DISTRICT 274278001816 30 WINFAIR ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 03 2017   grade_1 60.0 0.0 13.0   0.0 1.0     2.0   5.0   40.0 41.0     11.0   0.0     43.0   12.0   81.0 60 0 13   0 1     2   5   40 41     11 0   43 12   81
694072 694072 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384002540 510 LINWOOD MONROE ARTS PLUS LOWER Elementary School (Grades PK-6) Regular School No Elementary KG 03 2017   grade_1 26.0 20.0 12.0   0.0 16.0     0.0   7.0   40.0 41.0     30.0   0.0     54.0   18.0   81.0 26 20 12   0 16     0   7   40 41     30 0   54 18   81
694291 694291 MN Saint Louis 69 school 2708910 695 Independent Districts and Schools CHISHOLM PUBLIC SCHOOL DISTRICT 270891000360 101 VAUGHAN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 03 2017   grade_1 50.0 1.0 1.0   1.0 0.0     0.0   0.0   19.0 34.0     0.0   0.0         9.0   53.0 50 1 1   1 0     0   0   19 34     0 0     9   53
694967 694967 MN Waseca 81 school 2741880 829 Independent Districts and Schools WASECA PUBLIC SCHOOL DISTRICT 274188001747 20 HARTLEY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 03 2017   grade_1 68.0 7.0 14.0   0.0 3.0     0.0   2.0   41.0 53.0     8.0   1.0     37.0   16.0   94.0 68 7 14   0 3     0   2   41 53     8 1   37 16   94
694989 694989 MN Washington 82 school 2712270 831 Independent Districts and Schools FOREST LAKE PUBLIC SCHOOL DISTRICT 271227000596 627 Forest View Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 03 2017   grade_1 87.0 1.0 9.0   0.0 5.0     0.0   9.0   63.0 48.0     8.0   0.0     39.0   18.0   111.0 87 1 9   0 5     0   9   63 48     8 0   39 18   111
695533 695533 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   grade_1 36.0 0.0 0.0   0.0 1.0     0.0   2.0   25.0 14.0     0.0   0.0     13.0   5.0   39.0 36 0 0   0 1     0   2   25 14     0 0   13 5   39
695609 695609 MN Pope 61 school 2700019 2149 Independent Districts and Schools MINNEWASKA SCHOOL DISTRICT 270001903536 70 MINNEWASKA AREA ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 03 2017   grade_1 84.0 1.0 3.0   0.0 0.0     0.0   0.0   51.0 37.0         *         *   88.0 84 1 3   0 0     0   0   51 37                 88
695701 695701 MN Todd 77 school 2733900 2170 Independent Districts and Schools STAPLES-MOTLEY SCHOOL DISTRICT 273390001643 30 Staples-Motley Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 03 2017   grade_1 62.0 0.0 2.0   1.0 1.0     0.0   2.0   42.0 26.0     0.0   2.0         16.0   68.0 62 0 2   1 1     0   2   42 26     0 2     16   68
695870 695870 MN Lesueur 40 school 2718070 2397 Independent Districts and Schools LE SUEUR-HENDERSON SCHOOL DISTRICT 271807000045 10 PARK ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 03 2017   grade_1 54.0 0.0 9.0   0.0 0.0     0.0   2.0   31.0 34.0     5.0   0.0     20.0   5.0   65.0 54 0 9   0 0     0   2   31 34     5 0   20 5   65
696177 696177 MN Wabasha 79 school 2700287 2899 Independent Districts and Schools PLAINVIEW-ELGIN-MILLVILLE 270028703701 10 PLAINVIEW-ELGIN-MILLVILLE PK-3 Elementary School (Grades PK-6) Regular School No Elementary PK 03 2017   grade_1 102.0 1.0 7.0   0.0 0.0     0.0   1.0   66.0 45.0     3.0   0.0     41.0   13.0   111.0 102 1 7   0 0     0   1   66 45     3 0   41 13   111
696262 696262 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   grade_1 44.0 0.0 0.0   0.0 0.0     0.0   2.0   25.0 21.0     0.0   0.0     17.0   6.0   46.0 44 0 0   0 0     0   2   25 21     0 0   17 6   46
696278 696278 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124001861 104 LAKE HARRIET LOWER ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 03 2017   grade_1 93.0 4.0 5.0   1.0 9.0     1.0   4.0   65.0 52.0     5.0   0.0     8.0   7.0   117.0 93 4 5   1 9     1   4   65 52     5 0   8 7   117
696495 696495 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124004885 215 WEBSTER ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 03 2017   grade_1 16.0 11.0 8.0   3.0 1.0     0.0   4.0   21.0 22.0     8.0   0.0     25.0   2.0   43.0 16 11 8   3 1     0   4   21 22     8 0   25 2   43
696499 696499 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124004883 216 FAIR Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 03 2017   grade_1 2.0 17.0 1.0   0.0 0.0     0.0   3.0   11.0 12.0     2.0   1.0         0.0   23.0 2 17 1   0 0     0   3   11 12     2 1     0   23
697219 697219 MN Hennepin 27 school 2700288 4170 Charter Schools HIAWATHA ACADEMIES 270028804669 12 Hiawatha Leadership Academy-Northrop Elementary School (Grades PK-6) Regular School Yes Elementary KG 03 2017   grade_1 2.0 8.0 60.0   1.0 1.0     1.0   3.0   39.0 37.0     57.0   1.0         5.0   76.0 2 8 60   1 1     1   3   39 37     57 1     5   76
690559 690559 MN Aitkin 1 school 2714010 2 Independent Districts and Schools HILL CITY PUBLIC SCHOOL DISTRICT 271401000723 1 HILL CITY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2017   grade_1 15.0 0.0 1.0   0.0 0.0     0.0   2.0   5.0 13.0     0.0   0.0     11.0   5.0   18.0 15 0 1   0 0     0   2   5 13     0 0   11 5   18
690808 690808 MN Anoka 2 school 2712420 14 Independent Districts and Schools FRIDLEY PUBLIC SCHOOL DISTRICT 271242000612 546 HAYES ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2017   grade_1 52.0 34.0 8.0   1.0 13.0     0.0   9.0   65.0 52.0     29.0   2.0     62.0   9.0   117.0 52 34 8   1 13     0   9   65 52     29 2   62 9   117
690816 690816 MN Anoka 2 school 2712420 14 Independent Districts and Schools FRIDLEY PUBLIC SCHOOL DISTRICT 271242000614 550 STEVENSON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2017   grade_1 37.0 35.0 14.0   1.0 10.0     0.0   8.0   64.0 41.0     25.0   1.0     79.0   8.0   105.0 37 35 14   1 10     0   8   64 41     25 1   79 8   105
690878 690878 MN Becker 3 school 2710230 22 Independent Districts and Schools DETROIT LAKES PUBLIC SCHOOL DIST. 271023002268 60 ROOSEVELT ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2017   grade_1 80.0 5.0 3.0   19.0 1.0     0.0   18.0   56.0 70.0     0.0   2.0     75.0   20.0   126.0 80 5 3   19 1     0   18   56 70     0 2   75 20   126
691131 691131 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   grade_1 132.0 1.0 7.0   0.0 0.0     0.0   2.0   82.0 60.0     0.0   2.0     39.0   18.0   142.0 132 1 7   0 0     0   2   82 60     0 2   39 18   142
691313 691313 MN Cass 11 school 2708070 115 Independent Districts and Schools CASS LAKE-BENA PUBLIC SCHOOLS 270807000330 10 CASS LAKE-BENA ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2017   grade_1 8.0 1.0 6.0   83.0 0.0     0.0   15.0   57.0 56.0     0.0   0.0     89.0   30.0   113.0 8 1 6   83 0     0   15   57 56     0 0   89 30   113
691320 691320 MN Cass 11 school 2728350 116 Independent Districts and Schools PILLAGER PUBLIC SCHOOL DISTRICT 272835001253 10 PILLAGER ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2017   grade_1 81.0 0.0 2.0   0.0 0.0     0.0   2.0   42.0 43.0     0.0   1.0     37.0   16.0   85.0 81 0 2   0 0     0   2   42 43     0 1   37 16   85
691345 691345 MN Chisago 13 school 2723820 138 Independent Districts and Schools NORTH BRANCH PUBLIC SCHOOLS 272382003514 45 SUNRISE RIVER ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 04 2017   grade_1 185.0 2.0 8.0   2.0 2.0     0.0   8.0   117.0 90.0     3.0   3.0     64.0   30.0   207.0 185 2 8   2 2     0   8   117 90     3 3   64 30   207
691437 691437 MN Crow Wing 18 school 2706090 181 Independent Districts and Schools BRAINERD PUBLIC SCHOOL DISTRICT 270609000248 4 BAXTER ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2017   grade_1 75.0 0.0 1.0   1.0 2.0     0.0   2.0   42.0 39.0         0.0     26.0   14.0   81.0 75 0 1   1 2     0   2   42 39       0   26 14   81
691443 691443 MN Crow Wing 18 school 2706090 181 Independent Districts and Schools BRAINERD PUBLIC SCHOOL DISTRICT 270609000252 8 GARFIELD ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 04 2017   grade_1 73.0 0.0 1.0   4.0 0.0     0.0   1.0   28.0 51.0         3.0     38.0   16.0   79.0 73 0 1   4 0     0   1   28 51       3   38 16   79
691449 691449 MN Crow Wing 18 school 2706090 181 Independent Districts and Schools BRAINERD PUBLIC SCHOOL DISTRICT 270609000254 9 HARRISON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 04 2017   grade_1 55.0 0.0 0.0   1.0 0.0     0.0   4.0   29.0 31.0     0.0   0.0     33.0   18.0   60.0 55 0 0   1 0     0   4   29 31     0 0   33 18   60
691455 691455 MN Crow Wing 18 school 2706090 181 Independent Districts and Schools BRAINERD PUBLIC SCHOOL DISTRICT 270609000256 11 Lowell Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 04 2017   grade_1 77.0 1.0 0.0   0.0 0.0     0.0   2.0   36.0 44.0     0.0   0.0     37.0   10.0   80.0 77 1 0   0 0     0   2   36 44     0 0   37 10   80
691461 691461 MN Crow Wing 18 school 2706090 181 Independent Districts and Schools BRAINERD PUBLIC SCHOOL DISTRICT 270609000259 12 RIVERSIDE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 04 2017   grade_1 125.0 2.0 2.0   2.0 0.0     0.0   5.0   73.0 63.0     0.0   1.0     71.0   34.0   136.0 125 2 2   2 0     0   5   73 63     0 1   71 34   136
691468 691468 MN Crow Wing 18 school 2706090 181 Independent Districts and Schools BRAINERD PUBLIC SCHOOL DISTRICT 270609000257 15 NISSWA ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2017   grade_1 49.0 0.0 0.0   0.0 0.0     0.0   1.0   32.0 18.0     0.0   0.0     13.0   5.0   50.0 49 0 0   0 0     0   1   32 18     0 0   13 5   50
691484 691484 MN Crow Wing 18 school 2728200 186 Independent Districts and Schools PEQUOT LAKES PUBLIC SCHOOLS 272820001244 10 EAGLE VIEW ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2017   grade_1 114.0 2.0 0.0   3.0 0.0     0.0   0.0   69.0 50.0     0.0   0.0     40.0   20.0   119.0 114 2 0   3 0     0   0   69 50     0 0   40 20   119
691808 691808 MN Dakota 19 school 2742270 197 Independent Districts and Schools WEST ST. PAUL-MENDOTA HTS.-EAGAN 274227001776 815 MORELAND ART/HEALTH SCIENCE MAGNET Elementary School (Grades PK-6) Regular School No Elementary KG 04 2017   grade_1 31.0 8.0 22.0   0.0 8.0     0.0   4.0   34.0 39.0     20.0   0.0     39.0   19.0   73.0 31 8 22   0 8     0   4   34 39     20 0   39 19   73
691814 691814 MN Dakota 19 school 2742270 197 Independent Districts and Schools WEST ST. PAUL-MENDOTA HTS.-EAGAN 274227002202 816 MENDOTA ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2017   grade_1 68.0 3.0 2.0   0.0 0.0     0.0   7.0   40.0 40.0     1.0   0.0     16.0   10.0   80.0 68 3 2   0 0     0   7   40 40     1 0   16 10   80
691820 691820 MN Dakota 19 school 2742270 197 Independent Districts and Schools WEST ST. PAUL-MENDOTA HTS.-EAGAN 274227001773 817 GARLOUGH ENVIRONMENTAL MAGNET Elementary School (Grades PK-6) Regular School No Elementary KG 04 2017   grade_1 28.0 14.0 38.0   0.0 1.0     0.0   5.0   38.0 48.0     26.0   1.0     50.0   8.0   86.0 28 14 38   0 1     0   5   38 48     26 1   50 8   86
691826 691826 MN Dakota 19 school 2742270 197 Independent Districts and Schools WEST ST. PAUL-MENDOTA HTS.-EAGAN 274227001780 819 SOMERSET ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2017   grade_1 61.0 3.0 6.0   0.0 0.0     0.0   10.0   39.0 41.0     5.0   0.0     15.0   4.0   80.0 61 3 6   0 0     0   10   39 41     5 0   15 4   80
691832 691832 MN Dakota 19 school 2742270 197 Independent Districts and Schools WEST ST. PAUL-MENDOTA HTS.-EAGAN 274227001778 820 PILOT KNOB STEM MAGNET SCHOOL Elementary School (Grades PK-6) Regular School No Elementary KG 04 2017   grade_1 31.0 20.0 5.0   0.0 8.0     0.0   13.0   41.0 36.0     17.0   0.0     33.0   16.0   77.0 31 20 5   0 8     0   13   41 36     17 0   33 16   77
691864 691864 MN Dakota 19 school 2713530 200 Independent Districts and Schools HASTINGS PUBLIC SCHOOL DISTRICT 271353000695 609 KENNEDY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 04 2017   grade_1 67.0 3.0 5.0   1.0 1.0     0.0   1.0   38.0 40.0     0.0   0.0     30.0   11.0   78.0 67 3 5   1 1     0   1   38 40     0 0   30 11   78
691870 691870 MN Dakota 19 school 2713530 200 Independent Districts and Schools HASTINGS PUBLIC SCHOOL DISTRICT 271353000696 610 PINECREST ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 04 2017   grade_1 88.0 2.0 5.0   2.0 2.0     0.0   3.0   53.0 49.0     3.0   0.0     26.0   11.0   102.0 88 2 5   2 2     0   3   53 49     3 0   26 11   102
691876 691876 MN Dakota 19 school 2713530 200 Independent Districts and Schools HASTINGS PUBLIC SCHOOL DISTRICT 271353002239 612 CHRISTA MCAULIFFE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 04 2017   grade_1 82.0 0.0 5.0   0.0 2.0     0.0   7.0   46.0 50.0     1.0   2.0     24.0   14.0   96.0 82 0 5   0 2     0   7   46 50     1 2   24 14   96
691891 691891 MN Dodge 20 school 2716980 204 Independent Districts and Schools KASSON-MANTORVILLE SCHOOL DISTRICT 271698000783 10 KASSON-MANTORVILLE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2017   grade_1 130.0 1.0 10.0   1.0 1.0     0.0   2.0   83.0 62.0     1.0   0.0     20.0   23.0   145.0 130 1 10   1 1     0   2   83 62     1 0   20 23   145
692044 692044 MN Goodhue 25 school 2728950 255 Independent Districts and Schools PINE ISLAND PUBLIC SCHOOL DIST. 272895001257 10 PINE ISLAND ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2017   grade_1 104.0 5.0 4.0   0.0 1.0     0.0   3.0   61.0 56.0     0.0   1.0     21.0   14.0   117.0 104 5 4   0 1     0   3   61 56     0 1   21 14   117
692339 692339 MN Hennepin 27 school 2722920 277 Independent Districts and Schools WESTONKA PUBLIC SCHOOL DISTRICT 272292001113 615 SHIRLEY HILLS PRIMARY SCHOOL Elementary School (Grades PK-6) Regular School No Elementary PK 04 2017   grade_1 78.0 1.0 2.0   0.0 1.0     0.0   2.0   38.0 46.0     0.0   0.0     17.0   14.0   84.0 78 1 2   0 1     0   2   38 46     0 0   17 14   84
692345 692345 MN Hennepin 27 school 2722920 277 Independent Districts and Schools WESTONKA PUBLIC SCHOOL DISTRICT 272292001110 616 HILLTOP PRIMARY SCHOOL Elementary School (Grades PK-6) Regular School No Elementary PK 04 2017   grade_1 68.0 0.0 4.0   1.0 0.0     0.0   6.0   50.0 29.0     1.0   0.0     10.0   7.0   79.0 68 0 4   1 0     0   6   50 29     1 0   10 7   79
692732 692732 MN Houston 28 school 2717250 300 Independent Districts and Schools LA CRESCENT-HOKAH SCHOOL DISTRICT 271725000799 10 LA CRESCENT-HOKAH ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2017   grade_1 58.0 0.0 1.0   0.0 4.0     0.0   1.0   37.0 27.0     0.0   0.0     14.0   12.0   64.0 58 0 1   0 4     0   1   37 27     0 0   14 12   64
692762 692762 MN Hubbard 29 school 2728080 309 Independent Districts and Schools PARK RAPIDS PUBLIC SCHOOL DISTRICT 272808001233 30 PARK RAPIDS AREA CENTURY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2017   grade_1 95.0 0.0 7.0   1.0 1.0     0.0   6.0   63.0 47.0     2.0   0.0     64.0   22.0   110.0 95 0 7   1 1     0   6   63 47     2 0   64 22   110
692779 692779 MN Itasca 31 school 2709480 316 Independent Districts and Schools GREENWAY PUBLIC SCHOOL DISTRICT 270948000394 110 VANDYKE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2017   grade_1 57.0 1.0 1.0   5.0 0.0     0.0   1.0   30.0 35.0     0.0   1.0     41.0   16.0   65.0 57 1 1   5 0     0   1   30 35     0 1   41 16   65
692796 692796 MN Itasca 31 school 2713170 318 Independent Districts and Schools GRAND RAPIDS PUBLIC SCHOOL DISTRICT 271317000661 110 COHASSET ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 04 2017   grade_1 35.0 1.0 2.0   1.0 0.0     0.0   2.0   24.0 17.0     0.0   0.0         3.0   41.0 35 1 2   1 0     0   2   24 17     0 0     3   41
692812 692812 MN Itasca 31 school 2713170 318 Independent Districts and Schools GRAND RAPIDS PUBLIC SCHOOL DISTRICT 271317000662 120 FOREST LAKE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 04 2017   grade_1 51.0 0.0 4.0   3.0 0.0     0.0   8.0   35.0 31.0     0.0   0.0     35.0   8.0   66.0 51 0 4   3 0     0   8   35 31     0 0   35 8   66
692818 692818 MN Itasca 31 school 2713170 318 Independent Districts and Schools GRAND RAPIDS PUBLIC SCHOOL DISTRICT 271317000907 125 MURPHY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 04 2017   grade_1 54.0 1.0 3.0   3.0 1.0     0.0   6.0   32.0 36.0     0.0   0.0     37.0   9.0   68.0 54 1 3   3 1     0   6   32 36     0 0   37 9   68
692824 692824 MN Itasca 31 school 2713170 318 Independent Districts and Schools GRAND RAPIDS PUBLIC SCHOOL DISTRICT 271317000915 135 SOUTHWEST ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 04 2017   grade_1 62.0 0.0 0.0   2.0 0.0     0.0   6.0   35.0 35.0     0.0   0.0     32.0   16.0   70.0 62 0 0   2 0     0   6   35 35     0 0   32 16   70
692867 692867 MN Kandiyohi 34 school 2723400 345 Independent Districts and Schools NEW LONDON-SPICER SCHOOL DISTRICT 272340001141 10 PRAIRIE WOODS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2017   grade_1 100.0 0.0 7.0   0.0 0.0     1.0   0.0   57.0 51.0     1.0   1.0     27.0   8.0   108.0 100 0 7   0 0     1   0   57 51     1 1   27 8   108
693063 693063 MN Becker 3 school 2742120 435 Independent Districts and Schools WAUBUN-OGEMA-WHITE EARTH PUBLIC SCH 274212001754 20 OGEMA ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2017   grade_1 6.0 0.0 2.0   40.0 0.0     0.0   8.0   27.0 29.0     0.0   6.0     41.0   4.0   56.0 6 0 2   40 0     0   8   27 29     0 6   41 4   56
693109 693109 MN Meeker 47 school 2718210 465 Independent Districts and Schools LITCHFIELD PUBLIC SCHOOL DISTRICT 271821000837 10 LAKE RIPLEY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 04 2017   grade_1 98.0 2.0 17.0   0.0 0.0     0.0   3.0   59.0 61.0     4.0   1.0     56.0   18.0   120.0 98 2 17   0 0     0   3   59 61     4 1   56 18   120
693116 693116 MN Wright 86 school 2710060 466 Independent Districts and Schools DASSEL-COKATO PUBLIC SCHOOL DIST. 271006000426 1 COKATO ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2017   grade_1 90.0 0.0 6.0   0.0 0.0     0.0   4.0   48.0 52.0     1.0   0.0     23.0   14.0   100.0 90 0 6   0 0     0   4   48 52     1 0   23 14   100
693123 693123 MN Meeker 47 school 2710060 466 Independent Districts and Schools DASSEL-COKATO PUBLIC SCHOOL DIST. 271006000427 3 DASSEL ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2017   grade_1 68.0 0.0 0.0   0.0 0.0     0.0   3.0   29.0 42.0     1.0   0.0     26.0   12.0   71.0 68 0 0   0 0     0   3   29 42     1 0   26 12   71
693213 693213 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   grade_1 68.0 8.0 18.0   0.0 6.0     0.0   3.0   41.0 62.0         0.0     55.0   11.0   103.0 68 8 18   0 6     0   3   41 62       0   55 11   103
693218 693218 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   grade_1 50.0 2.0 24.0   0.0 3.0     0.0   1.0   36.0 44.0         4.0         *   80.0 50 2 24   0 3     0   1   36 44       4         80
693223 693223 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   grade_1 65.0 8.0 35.0   0.0 6.0     1.0   8.0   60.0 63.0     30.0   3.0     66.0   23.0   123.0 65 8 35   0 6     1   8   60 63     30 3   66 23   123
693228 693228 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   grade_1 15.0 9.0 27.0   0.0 15.0     0.0   1.0   39.0 28.0     36.0   0.0         *   67.0 15 9 27   0 15     0   1   39 28     36 0         67
693244 693244 MN Mower 50 school 2713140 495 Independent Districts and Schools GRAND MEADOW PUBLIC SCHOOL DISTRICT 271314000659 10 GRAND MEADOW ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2017   grade_1 22.0 0.0 2.0   0.0 0.0     0.0   0.0   10.0 14.0     0.0   0.0         2.0   24.0 22 0 2   0 0     0   0   10 14     0 0     2   24
693285 693285 MN Nicollet 52 school 2723580 507 Independent Districts and Schools NICOLLET PUBLIC SCHOOL DISTRICT 272358001160 10 NICOLLET ELEMENTARY SCHOOL Elementary School (Grades PK-6) Regular School No Elementary PK 04 2017   grade_1 25.0 0.0 0.0   0.0 0.0     0.0   1.0   13.0 13.0     0.0   0.0     6.0   5.0   26.0 25 0 0   0 0     0   1   13 13     0 0   6 5   26

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