enrollments

Data source: Big Local News · About: Big Local

4,953 rows where grade = "grade_8" and state = "MN" sorted by ccd_school_high_grade

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_8 · 4,853 ✖
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
697841 697841 MN Dakota 19 school 2707290 191 Independent Districts and Schools BURNSVILLE PUBLIC SCHOOL DISTRICT 270729000297 85 Joseph Nicollet Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_8 54.0 24.0 16.0   0.0 12.0     2.0   8.0   53.0 63.0     5.0   3.0     49.0   10.0   116.0 54 24 16   0 12     2   8   53 63     5 3   49 10   116
697845 697845 MN Dakota 19 school 2711820 192 Independent Districts and Schools FARMINGTON PUBLIC SCHOOL DISTRICT 271182000570 30 LEVI P. DODGE MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_8 205.0 6.0 19.0   2.0 14.0     0.0   6.0   131.0 121.0     4.0   0.0     46.0   32.0   252.0 205 6 19   2 14     0   6   131 121     4 0   46 32   252
697849 697849 MN Dakota 19 school 2711820 192 Independent Districts and Schools FARMINGTON PUBLIC SCHOOL DISTRICT 271182002983 60 ROBERT BOECKMAN MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_8 258.0 6.0 13.0   2.0 17.0     0.0   5.0   155.0 146.0     5.0   0.0     47.0   45.0   301.0 258 6 13   2 17     0   5   155 146     5 0   47 45   301
697853 697853 MN Dakota 19 school 2717780 194 Independent Districts and Schools LAKEVILLE PUBLIC SCHOOL DISTRICT 271778002435 89 MCGUIRE MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_8 272.0 3.0 17.0   0.0 10.0     0.0   14.0   164.0 152.0     0.0   *     34.0   39.0   316.0 272 3 17   0 10     0   14   164 152     0     34 39   316
697857 697857 MN Dakota 19 school 2717780 194 Independent Districts and Schools LAKEVILLE PUBLIC SCHOOL DISTRICT 271778000483 104 KENWOOD TRAIL MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_8 180.0 19.0 18.0   0.0 16.0     0.0   6.0   131.0 108.0     7.0   1.0     40.0   42.0   239.0 180 19 18   0 16     0   6   131 108     7 1   40 42   239
697861 697861 MN Dakota 19 school 2717780 194 Independent Districts and Schools LAKEVILLE PUBLIC SCHOOL DISTRICT 271778002984 105 CENTURY MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_8 257.0 7.0 5.0   1.0 17.0     1.0   9.0   145.0 152.0     5.0   0.0     23.0   26.0   297.0 257 7 5   1 17     1   9   145 152     5 0   23 26   297
697865 697865 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239000484 25 DAKOTA HILLS MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_8 292.0 16.0 36.0   2.0 48.0     0.0   11.0   221.0 184.0     13.0   *         41.0   405.0 292 16 36   2 48     0   11   221 184     13       41   405
697869 697869 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239002437 32 BLACK HAWK MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_8 157.0 52.0 31.0   3.0 34.0     0.0   14.0   139.0 152.0     13.0   1.0     93.0   43.0   291.0 157 52 31   3 34     0   14   139 152     13 1   93 43   291
697873 697873 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239001381 39 ROSEMOUNT MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_8 357.0 21.0 20.0   3.0 31.0     0.0   13.0   232.0 213.0         0.0     64.0   63.0   445.0 357 21 20   3 31     0   13   232 213       0   64 63   445
697877 697877 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239002644 86 FALCON RIDGE MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_8 229.0 31.0 43.0   0.0 32.0     0.0   12.0   203.0 144.0     16.0   0.0     69.0   46.0   347.0 229 31 43   0 32     0   12   203 144     16 0   69 46   347
697881 697881 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239001943 93 SCOTT HIGHLANDS MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_8 239.0 39.0 20.0   0.0 33.0     1.0   22.0   173.0 181.0         3.0     95.0   56.0   354.0 239 39 20   0 33     1   22   173 181       3   95 56   354
697885 697885 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239001383 98 VALLEY MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_8 196.0 63.0 37.0   2.0 18.0     0.0   17.0   185.0 148.0     23.0   0.0     134.0   57.0   333.0 196 63 37   2 18     0   17   185 148     23 0   134 57   333
697890 697890 MN Dakota 19 school 2742270 197 Independent Districts and Schools WEST ST. PAUL-MENDOTA HTS.-EAGAN 274227002646 52 FRIENDLY HILLS MIDDLE Middle School (Grades 5-8) Regular School No Middle 05 08 2017   grade_8 110.0 19.0 35.0   0.0 6.0     0.0   9.0   92.0 87.0     11.0   4.0     51.0   23.0   179.0 110 19 35   0 6     0   9   92 87     11 4   51 23   179
697895 697895 MN Dakota 19 school 2742270 197 Independent Districts and Schools WEST ST. PAUL-MENDOTA HTS.-EAGAN 274227001774 54 HERITAGE E-STEM MAGNET SCHOOL Middle School (Grades 5-8) Regular School No Middle 05 08 2017   grade_8 67.0 16.0 80.0   3.0 7.0     0.0   4.0   97.0 80.0     32.0   2.0     97.0   39.0   177.0 67 16 80   3 7     0   4   97 80     32 2   97 39   177
697899 697899 MN Dakota 19 school 2715030 199 Independent Districts and Schools INVER GROVE HEIGHTS SCHOOLS 271503000765 27 INVER GROVE HEIGHTS MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_8 174.0 18.0 57.0   0.0 13.0     0.0   16.0   127.0 151.0     23.0   2.0     99.0   28.0   278.0 174 18 57   0 13     0   16   127 151     23 2   99 28   278
697904 697904 MN Dakota 19 school 2713530 200 Independent Districts and Schools HASTINGS PUBLIC SCHOOL DISTRICT 271353000693 130 HASTINGS MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 05 08 2017   grade_8 311.0 10.0 13.0   3.0 5.0     0.0   11.0   174.0 179.0         *         *   353.0 311 10 13   3 5     0   11   174 179                 353
697909 697909 MN Dodge 20 school 2716980 204 Independent Districts and Schools KASSON-MANTORVILLE SCHOOL DISTRICT 271698002243 40 KASSON-MANTORVILLE MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 05 08 2017   grade_8 146.0 1.0 11.0   0.0 1.0     0.0   1.0   72.0 88.0     2.0   0.0     24.0   10.0   160.0 146 1 11   0 1     0   1   72 88     2 0   24 10   160
697913 697913 MN Douglas 21 school 2703060 206 Independent Districts and Schools ALEXANDRIA PUBLIC SCHOOL DISTRICT 270306000083 310 Discovery Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_8 283.0 2.0 6.0   1.0 8.0     0.0   9.0   168.0 141.0     1.0   1.0     76.0   45.0   309.0 283 2 6   1 8     0   9   168 141     1 1   76 45   309
697917 697917 MN Fillmore 23 school 2728290 239 Independent Districts and Schools RUSHFORD-PETERSON PUBLIC SCHOOLS 272829001249 3 RUSHFORD-PETERSON MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_8 43.0 1.0 1.0   0.0 0.0     0.0   1.0   22.0 24.0     1.0   0.0     19.0   5.0   46.0 43 1 1   0 0     0   1   22 24     1 0   19 5   46
697925 697925 MN Goodhue 25 school 2728950 255 Independent Districts and Schools PINE ISLAND PUBLIC SCHOOL DIST. 272895004143 15 PINE ISLAND MIDDLE Middle School (Grades 5-8) Regular School No Middle 05 08 2017   grade_8 85.0 2.0 1.0   1.0 1.0     0.0   0.0   42.0 48.0     0.0   0.0     14.0   9.0   90.0 85 2 1   1 1     0   0   42 48     0 0   14 9   90
697933 697933 MN Hennepin 27 school 2705790 271 Independent Districts and Schools BLOOMINGTON PUBLIC SCHOOL DISTRICT 270579000226 13 OAK GROVE MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_8 150.0 46.0 37.0   2.0 17.0     0.0   9.0   141.0 120.0     21.0   *     98.0   55.0   261.0 150 46 37   2 17     0   9   141 120     21     98 55   261
697937 697937 MN Hennepin 27 school 2705790 271 Independent Districts and Schools BLOOMINGTON PUBLIC SCHOOL DISTRICT 270579000638 345 VALLEY VIEW MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_8 54.0 55.0 77.0   1.0 12.0     0.0   7.0   115.0 91.0     40.0   4.0     148.0   27.0   206.0 54 55 77   1 12     0   7   115 91     40 4   148 27   206
697941 697941 MN Hennepin 27 school 2705790 271 Independent Districts and Schools BLOOMINGTON PUBLIC SCHOOL DISTRICT 270579000228 346 OLSON MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_8 190.0 30.0 18.0   0.0 24.0     0.0   11.0   153.0 120.0         4.0         33.0   273.0 190 30 18   0 24     0   11   153 120       4     33   273
697944 697944 MN Hennepin 27 school 2714220 272 Independent Districts and Schools EDEN PRAIRIE PUBLIC SCHOOL DISTRICT 271422000734 65 CENTRAL MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 07 08 2017   grade_8 430.0 85.0 44.0   3.0 88.0     1.0   20.0   328.0 343.0     29.0   3.0     119.0   72.0   671.0 430 85 44   3 88     1   20   328 343     29 3   119 72   671
697958 697958 MN Hennepin 27 school 2711670 276 Independent Districts and Schools MINNETONKA PUBLIC SCHOOL DISTRICT 271167000545 75 MINNETONKA EAST MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_8 341.0 18.0 16.0   3.0 33.0     0.0   14.0   213.0 212.0     5.0   1.0     39.0   33.0   425.0 341 18 16   3 33     0   14   213 212     5 1   39 33   425
697962 697962 MN Carver 10 school 2711670 276 Independent Districts and Schools MINNETONKA PUBLIC SCHOOL DISTRICT 271167002194 175 MINNETONKA WEST MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_8 306.0 13.0 16.0   3.0 19.0     0.0   7.0   179.0 185.0     8.0   0.0     25.0   42.0   364.0 306 13 16   3 19     0   7   179 185     8 0   25 42   364
697970 697970 MN Hennepin 27 school 2725080 278 Independent Districts and Schools ORONO PUBLIC SCHOOL DISTRICT 272508001199 31 ORONO MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_8 212.0 2.0 9.0   1.0 2.0     0.0   1.0   112.0 115.0     2.0   0.0     16.0   25.0   227.0 212 2 9   1 2     0   1   112 115     2 0   16 25   227
697974 697974 MN Hennepin 27 school 2725200 279 Independent Districts and Schools OSSEO PUBLIC SCHOOL DISTRICT 272520001208 33 Brooklyn Middle School, a Science, Technology, Engineering, Art and Math School Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_8 56.0 94.0 34.0   0.0 91.0     0.0   27.0   158.0 144.0     41.0   *     201.0   36.0   302.0 56 94 34   0 91     0   27   158 144     41     201 36   302
697978 697978 MN Hennepin 27 school 2725200 279 Independent Districts and Schools OSSEO PUBLIC SCHOOL DISTRICT 272520001217 34 Osseo Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_8 209.0 65.0 26.0   1.0 31.0     0.0   23.0   176.0 179.0         3.0     128.0   33.0   355.0 209 65 26   1 31     0   23   176 179       3   128 33   355
697982 697982 MN Hennepin 27 school 2725200 279 Independent Districts and Schools OSSEO PUBLIC SCHOOL DISTRICT 272520001214 86 North View Middle School, an IB World School Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_8 18.0 112.0 33.0   1.0 63.0     0.0   13.0   122.0 118.0     46.0   *     196.0   35.0   240.0 18 112 33   1 63     0   13   122 118     46     196 35   240
697986 697986 MN Hennepin 27 school 2725200 279 Independent Districts and Schools OSSEO PUBLIC SCHOOL DISTRICT 272520002278 94 Maple Grove Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_8 362.0 72.0 38.0   0.0 49.0     0.0   27.0   252.0 296.0     19.0   3.0         44.0   548.0 362 72 38   0 49     0   27   252 296     19 3     44   548
697990 697990 MN Hennepin 27 school 2731750 280 Independent Districts and Schools RICHFIELD PUBLIC SCHOOL DISTRICT 273175001317 37 RICHFIELD MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_8 94.0 49.0 105.0   1.0 16.0     1.0   14.0   142.0 138.0     58.0   5.0     170.0   38.0   280.0 94 49 105   1 16     1   14   142 138     58 5   170 38   280
697994 697994 MN Hennepin 27 school 2731780 281 Independent Districts and Schools ROBBINSDALE PUBLIC SCHOOL DISTRICT 273178001333 40 PLYMOUTH MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_8 237.0 89.0 47.0   3.0 27.0     1.0   34.0   213.0 225.0     19.0   7.0     161.0   45.0   438.0 237 89 47   3 27     1   34   213 225     19 7   161 45   438
697998 697998 MN Hennepin 27 school 2731780 281 Independent Districts and Schools ROBBINSDALE PUBLIC SCHOOL DISTRICT 273178002184 43 ROBBINSDALE MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_8 109.0 148.0 63.0   4.0 32.0     1.0   43.0   211.0 189.0     45.0   8.0     279.0   48.0   400.0 109 148 63   4 32     1   43   211 189     45 8   279 48   400
698002 698002 MN Hennepin 27 school 2733420 282 Independent Districts and Schools ST. ANTHONY-NEW BRIGHTON SCHOOLS 273342001949 50 ST. ANTHONY MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_8 100.0 11.0 13.0   1.0 7.0     1.0   11.0   62.0 82.0     8.0   0.0     34.0   13.0   144.0 100 11 13   1 7     1   11   62 82     8 0   34 13   144
698006 698006 MN Hennepin 27 school 2733780 283 Independent Districts and Schools ST. LOUIS PARK PUBLIC SCHOOL DIST. 273378001533 42 ST. LOUIS PARK MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_8 192.0 69.0 39.0   2.0 15.0     0.0   30.0   157.0 190.0         9.0     129.0   32.0   347.0 192 69 39   2 15     0   30   157 190       9   129 32   347
698010 698010 MN Hennepin 27 school 2742160 284 Independent Districts and Schools WAYZATA PUBLIC SCHOOL DISTRICT 274216001764 51 WAYZATA WEST MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_8 203.0 6.0 19.0   0.0 33.0     0.0   3.0   130.0 134.0         0.0     33.0   20.0   264.0 203 6 19   0 33     0   3   130 134       0   33 20   264
698014 698014 MN Hennepin 27 school 2742160 284 Independent Districts and Schools WAYZATA PUBLIC SCHOOL DISTRICT 274216001762 52 WAYZATA EAST MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_8 171.0 11.0 16.0   0.0 41.0     0.0   9.0   137.0 111.0     15.0   0.0     36.0   *   248.0 171 11 16   0 41     0   9   137 111     15 0   36     248
698018 698018 MN Hennepin 27 school 2742160 284 Independent Districts and Schools WAYZATA PUBLIC SCHOOL DISTRICT 274216002654 53 WAYZATA CENTRAL MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_8 222.0 36.0 8.0   1.0 66.0     0.0   17.0   173.0 177.0         2.0     46.0   30.0   350.0 222 36 8   1 66     0   17   173 177       2   46 30   350
698022 698022 MN Houston 28 school 2707380 299 Independent Districts and Schools CALEDONIA PUBLIC SCHOOL DISTRICT 270738000310 20 CALEDONIA MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_8 43.0 2.0 0.0   0.0 0.0     0.0   1.0   26.0 20.0     0.0   0.0     14.0   8.0   46.0 43 2 0   0 0     0   1   26 20     0 0   14 8   46
698027 698027 MN Houston 28 school 2717250 300 Independent Districts and Schools LA CRESCENT-HOKAH SCHOOL DISTRICT 271725004238 50 LA CRESCENT-HOKAH MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 05 08 2017   grade_8 80.0 3.0 1.0   1.0 0.0     0.0   2.0   40.0 47.0     0.0   0.0     24.0   20.0   87.0 80 3 1   1 0     0   2   40 47     0 0   24 20   87
698032 698032 MN Hubbard 29 school 2728080 309 Independent Districts and Schools PARK RAPIDS PUBLIC SCHOOL DISTRICT 272808001236 80 PARK RAPIDS AREA CENTURY MIDDLE Middle School (Grades 5-8) Regular School No Middle 05 08 2017   grade_8 70.0 0.0 5.0   5.0 0.0     0.0   4.0   41.0 43.0     1.0   0.0         16.0   84.0 70 0 5   5 0     0   4   41 43     1 0     16   84
698037 698037 MN Itasca 31 school 2709480 316 Independent Districts and Schools GREENWAY PUBLIC SCHOOL DISTRICT 270948002785 210 GREENWAY MIDDLE Middle School (Grades 5-8) Regular School No Middle 05 08 2017   grade_8 59.0 0.0 2.0   1.0 0.0     0.0   6.0   33.0 35.0     1.0   0.0     34.0   7.0   68.0 59 0 2   1 0     0   6   33 35     1 0   34 7   68
698042 698042 MN Itasca 31 school 2713170 318 Independent Districts and Schools GRAND RAPIDS PUBLIC SCHOOL DISTRICT 271317000939 370 ROBERT J. ELKINGTON MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 05 08 2017   grade_8 208.0 3.0 5.0   10.0 3.0     0.0   19.0   127.0 121.0     0.0   0.0     82.0   35.0   248.0 208 3 5   10 3     0   19   127 121     0 0   82 35   248
698047 698047 MN Kandiyohi 34 school 2723400 345 Independent Districts and Schools NEW LONDON-SPICER SCHOOL DISTRICT 272340000948 20 NEW LONDON-SPICER MIDDLE Middle School (Grades 5-8) Regular School No Middle 05 08 2017   grade_8 108.0 1.0 9.0   1.0 0.0     0.0   1.0   56.0 64.0     0.0   1.0     35.0   12.0   120.0 108 1 9   1 0     0   1   56 64     0 1   35 12   120
698051 698051 MN Kandiyohi 34 school 2742720 347 Independent Districts and Schools WILLMAR PUBLIC SCHOOL DISTRICT 274272001808 301 WILLMAR MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_8 159.0 49.0 95.0   2.0 11.0     0.0   3.0   150.0 169.0     51.0   1.0     178.0   35.0   319.0 159 49 95   2 11     0   3   150 169     51 1   178 35   319
698056 698056 MN Lyon 42 school 2718940 413 Independent Districts and Schools MARSHALL PUBLIC SCHOOL DISTRICT 271894003715 6 MARSHALL MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 05 08 2017   grade_8 97.0 17.0 24.0   0.0 15.0     0.0   4.0   84.0 73.0     18.0   4.0     71.0   21.0   157.0 97 17 24   0 15     0   4   84 73     18 4   71 21   157
698061 698061 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   grade_8 8.0 0.0 1.0   0.0 0.0     0.0   0.0   5.0 4.0         *         *   9.0 8 0 1   0 0     0   0   5 4                 9
698065 698065 MN Mcleod 43 school 2714970 423 Independent Districts and Schools HUTCHINSON PUBLIC SCHOOL DISTRICT 271497000755 20 HUTCHINSON MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_8 207.0 2.0 12.0   0.0 6.0     0.0   2.0   121.0 108.0         *     42.0   *   229.0 207 2 12   0 6     0   2   121 108           42     229
698070 698070 MN Meeker 47 school 2718210 465 Independent Districts and Schools LITCHFIELD PUBLIC SCHOOL DISTRICT 271821000838 30 Litchfield Middle School Middle School (Grades 5-8) Regular School No Middle 05 08 2017   grade_8 105.0 3.0 11.0   0.0 0.0     0.0   0.0   52.0 67.0     0.0   0.0     43.0   11.0   119.0 105 3 11   0 0     0   0   52 67     0 0   43 11   119
698075 698075 MN Wright 86 school 2710060 466 Independent Districts and Schools DASSEL-COKATO PUBLIC SCHOOL DIST. 271006002267 4 DASSEL-COKATO MIDDLE Middle School (Grades 5-8) Regular School No Middle 05 08 2017   grade_8 173.0 1.0 7.0   2.0 0.0     0.0   2.0   89.0 96.0     2.0   0.0     53.0   23.0   185.0 173 1 7   2 0     0   2   89 96     2 0   53 23   185
698079 698079 MN Mille Lacs 48 school 2730030 477 Independent Districts and Schools PRINCETON PUBLIC SCHOOL DISTRICT 273003001272 20 Princeton Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_8 239.0 2.0 7.0   1.0 1.0     0.0   6.0   144.0 112.0     1.0   3.0     91.0   27.0   256.0 239 2 7   1 1     0   6   144 112     1 3   91 27   256
698083 698083 MN Morrison 49 school 2718240 482 Independent Districts and Schools LITTLE FALLS PUBLIC SCHOOL DISTRICT 271824000963 200 COMMUNITY MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_8 150.0 2.0 5.0   1.0 0.0     1.0   5.0   98.0 66.0     2.0   0.0     70.0   27.0   164.0 150 2 5   1 0     1   5   98 66     2 0   70 27   164
698087 698087 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   grade_8 83.0 0.0 2.0   2.0 0.0     0.0   1.0   49.0 39.0     0.0   2.0     24.0   11.0   88.0 83 0 2   2 0     0   1   49 39     0 2   24 11   88
698090 698090 MN Mower 50 school 2703450 492 Independent Districts and Schools AUSTIN PUBLIC SCHOOL DISTRICT 270345000150 300 ELLIS MIDDLE Middle School (Grades 5-8) Regular School No Middle 07 08 2017   grade_8 197.0 21.0 79.0   0.0 21.0     4.0   12.0   170.0 164.0     40.0   2.0     180.0   *   334.0 197 21 79   0 21     4   12   170 164     40 2   180     334
698095 698095 MN Mower 50 school 2713140 495 Independent Districts and Schools GRAND MEADOW PUBLIC SCHOOL DISTRICT 271314000660 20 GRAND MEADOW MIDDLE Middle School (Grades 5-8) Regular School No Middle 05 08 2017   grade_8 34.0 1.0 2.0   0.0 0.0     0.0   1.0   26.0 12.0     0.0   0.0     10.0   5.0   38.0 34 1 2   0 0     0   1   26 12     0 0   10 5   38
698099 698099 MN Mower 50 school 2702720 500 Independent Districts and Schools SOUTHLAND PUBLIC SCHOOL DISTRICT 270272000054 50 SOUTHLAND MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_8 28.0 0.0 1.0   0.0 0.0     0.0   0.0   15.0 14.0     1.0   0.0     7.0   4.0   29.0 28 0 1   0 0     0   0   15 14     1 0   7 4   29
698104 698104 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   grade_8 30.0 0.0 1.0   0.0 0.0     0.0   0.0   16.0 15.0     0.0   0.0     7.0   2.0   31.0 30 0 1   0 0     0   0   16 15     0 0   7 2   31
698107 698107 MN Nicollet 52 school 2733870 508 Independent Districts and Schools ST. PETER PUBLIC SCHOOL DISTRICT 273387002533 80 St. Peter Middle School Middle School (Grades 5-8) Regular School No Middle 07 08 2017   grade_8 135.0 13.0 20.0   1.0 6.0     0.0   5.0   83.0 97.0         *         *   180.0 135 13 20   1 6     0   5   83 97                 180
698111 698111 MN Nobles 53 school 2702730 511 Independent Districts and Schools ADRIAN PUBLIC SCHOOL DISTRICT 270273003076 15 ADRIAN MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_8 31.0 0.0 4.0   0.0 1.0     0.0   2.0   19.0 19.0     1.0   0.0     15.0   2.0   38.0 31 0 4   0 1     0   2   19 19     1 0   15 2   38
698116 698116 MN Nobles 53 school 2744160 518 Independent Districts and Schools WORTHINGTON PUBLIC SCHOOL DISTRICT 274416001840 4 WORTHINGTON MIDDLE Middle School (Grades 5-8) Regular School No Middle 05 08 2017   grade_8 64.0 15.0 96.0   1.0 27.0     0.0   3.0   100.0 106.0     41.0   0.0     146.0   35.0   206.0 64 15 96   1 27     0   3   100 106     41 0   146 35   206
698120 698120 MN Olmsted 55 school 2707350 531 Independent Districts and Schools BYRON PUBLIC SCHOOL DISTRICT 270735000981 30 BYRON MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_8 150.0 1.0 3.0   0.0 1.0     0.0   7.0   89.0 73.0     1.0   0.0     22.0   11.0   162.0 150 1 3   0 1     0   7   89 73     1 0   22 11   162
698124 698124 MN Olmsted 55 school 2711010 533 Independent Districts and Schools DOVER-EYOTA PUBLIC SCHOOL DISTRICT 271101004345 25 DOVER-EYOTA MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_8 84.0 1.0 0.0   0.0 1.0     0.0   0.0   37.0 49.0     0.0   0.0     17.0   11.0   86.0 84 1 0   0 1     0   0   37 49     0 0   17 11   86
698128 698128 MN Olmsted 55 school 2738160 534 Independent Districts and Schools STEWARTVILLE PUBLIC SCHOOL DISTRICT 273816002822 20 STEWARTVILLE MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_8 153.0 3.0 4.0   1.0 0.0     0.0   2.0   73.0 90.0     1.0   0.0     33.0   18.0   163.0 153 3 4   1 0     0   2   73 90     1 0   33 18   163
698132 698132 MN Olmsted 55 school 2731800 535 Independent Districts and Schools ROCHESTER PUBLIC SCHOOL DISTRICT 273180001018 325 JOHN ADAMS MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_8 213.0 66.0 30.0   0.0 57.0     0.0   15.0   176.0 205.0     46.0   12.0     178.0   45.0   381.0 213 66 30   0 57     0   15   176 205     46 12   178 45   381
698136 698136 MN Olmsted 55 school 2731800 535 Independent Districts and Schools ROCHESTER PUBLIC SCHOOL DISTRICT 273180001019 330 WILLOW CREEK MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_8 221.0 55.0 62.0   2.0 23.0     0.0   15.0   182.0 196.0     50.0   6.0     168.0   60.0   378.0 221 55 62   2 23     0   15   182 196     50 6   168 60   378
698140 698140 MN Olmsted 55 school 2731800 535 Independent Districts and Schools ROCHESTER PUBLIC SCHOOL DISTRICT 273180001020 335 KELLOGG MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_8 221.0 34.0 15.0   1.0 34.0     0.0   10.0   161.0 154.0     29.0   4.0     93.0   39.0   315.0 221 34 15   1 34     0   10   161 154     29 4   93 39   315
698144 698144 MN Olmsted 55 school 2731800 535 Independent Districts and Schools ROCHESTER PUBLIC SCHOOL DISTRICT 273180002449 340 FRIEDELL MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_8 102.0 4.0 8.0   0.0 26.0     0.0   6.0   71.0 75.0     5.0   1.0     22.0   16.0   146.0 102 4 8   0 26     0   6   71 75     5 1   22 16   146
698148 698148 MN Otter Tail 56 school 2711880 544 Independent Districts and Schools FERGUS FALLS PUBLIC SCHOOL DISTRICT 271188004944 380 Kennedy Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_8 150.0 6.0 4.0   0.0 0.0     0.0   6.0   78.0 88.0     0.0   0.0     45.0   26.0   166.0 150 6 4   0 0     0   6   78 88     0 0   45 26   166
698153 698153 MN Otter Tail 56 school 2728230 549 Independent Districts and Schools PERHAM-DENT PUBLIC SCHOOL DISTRICT 272823002535 20 PRAIRIE WIND MIDDLE Middle School (Grades 5-8) Regular School No Middle 05 08 2017   grade_8 93.0 1.0 7.0   2.0 0.0     0.0   3.0   51.0 55.0     2.0   0.0     39.0   19.0   106.0 93 1 7   2 0     0   3   51 55     2 0   39 19   106
698157 698157 MN Pennington 57 school 2738850 564 Independent Districts and Schools THIEF RIVER FALLS SCHOOL DISTRICT 273885001674 60 FRANKLIN MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_8 138.0 2.0 6.0   5.0 1.0     0.0   5.0   86.0 71.0     0.0   0.0     45.0   23.0   157.0 138 2 6   5 1     0   5   86 71     0 0   45 23   157
698161 698161 MN Polk 60 school 2711130 595 Independent Districts and Schools EAST GRAND FORKS PUBLIC SCHOOL DIST 271113000494 310 CENTRAL MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_8 105.0 7.0 14.0   0.0 1.0     0.0   6.0   65.0 68.0     7.0   0.0     35.0   20.0   133.0 105 7 14   0 1     0   6   65 68     7 0   35 20   133
698165 698165 MN Ramsey 62 school 2722950 621 Independent Districts and Schools MOUNDS VIEW PUBLIC SCHOOL DISTRICT 272295001041 66 Edgewood Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_8 129.0 39.0 20.0   2.0 23.0     0.0   11.0   115.0 109.0     12.0   8.0     101.0   32.0   224.0 129 39 20   2 23     0   11   115 109     12 8   101 32   224
698169 698169 MN Ramsey 62 school 2722950 621 Independent Districts and Schools MOUNDS VIEW PUBLIC SCHOOL DISTRICT 272295001117 67 Highview Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_8 163.0 46.0 30.0   1.0 16.0     0.0   11.0   125.0 142.0     11.0   3.0     101.0   24.0   267.0 163 46 30   1 16     0   11   125 142     11 3   101 24   267
698173 698173 MN Ramsey 62 school 2722950 621 Independent Districts and Schools MOUNDS VIEW PUBLIC SCHOOL DISTRICT 272295001115 70 Chippewa Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_8 262.0 12.0 13.0   3.0 62.0     0.0   11.0   188.0 175.0     4.0   0.0     54.0   *   363.0 262 12 13   3 62     0   11   188 175     4 0   54     363
698177 698177 MN Washington 82 school 2723850 622 Independent Districts and Schools North St Paul-Maplewood Oakdale Public School District 272385002666 54 SKYVIEW COMMUNITY MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_8 139.0 38.0 16.0   2.0 43.0     0.0   14.0   141.0 111.0         *         *   252.0 139 38 16   2 43     0   14   141 111                 252
698181 698181 MN Ramsey 62 school 2723850 622 Independent Districts and Schools North St Paul-Maplewood Oakdale Public School District 272385001170 55 JOHN GLENN MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_8 89.0 55.0 40.0   3.0 74.0     0.0   11.0   138.0 134.0     25.0   6.0     194.0   48.0   272.0 89 55 40   3 74     0   11   138 134     25 6   194 48   272
698185 698185 MN Ramsey 62 school 2723850 622 Independent Districts and Schools North St Paul-Maplewood Oakdale Public School District 272385002199 56 MAPLEWOOD MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_8 103.0 37.0 37.0   1.0 45.0     0.0   15.0   117.0 121.0     21.0   6.0     139.0   *   238.0 103 37 37   1 45     0   15   117 121     21 6   139     238
698188 698188 MN Ramsey 62 school 2732430 623 Independent Districts and Schools ROSEVILLE PUBLIC SCHOOL DISTRICT 273243002667 70 ROSEVILLE AREA MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_8 179.0 86.0 76.0   4.0 97.0     0.0   25.0   250.0 217.0         9.0         68.0   467.0 179 86 76   4 97     0   25   250 217       9     68   467
698192 698192 MN Ramsey 62 school 2742360 624 Independent Districts and Schools WHITE BEAR LAKE SCHOOL DISTRICT 274236001787 57 CENTRAL MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_8 274.0 10.0 19.0   4.0 12.0     0.0   13.0   193.0 139.0     0.0   0.0     58.0   36.0   332.0 274 10 19   4 12     0   13   193 139     0 0   58 36   332
698196 698196 MN Ramsey 62 school 2742360 624 Independent Districts and Schools WHITE BEAR LAKE SCHOOL DISTRICT 274236001049 59 SUNRISE PARK MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_8 178.0 17.0 24.0   3.0 29.0     1.0   13.0   132.0 133.0     9.0   4.0     101.0   38.0   265.0 178 17 24   3 29     1   13   132 133     9 4   101 38   265
698200 698200 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384001556 310 BATTLE CREEK MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_8 23.0 67.0 37.0   5.0 95.0     0.0   9.0   140.0 96.0     109.0   9.0     190.0   34.0   236.0 23 67 37   5 95     0   9   140 96     109 9   190 34   236
698205 698205 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384001567 315 FARNSWORTH AEROSPACE UPPER Middle School (Grades 5-8) Regular School No Middle 05 08 2017   grade_8 10.0 35.0 18.0   0.0 97.0     0.0   1.0   88.0 73.0     60.0   3.0     122.0   32.0   161.0 10 35 18   0 97     0   1   88 73     60 3   122 32   161
698209 698209 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384001591 330 HIGHLAND PARK MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_8 121.0 42.0 81.0   3.0 9.0     0.0   5.0   132.0 129.0     51.0   3.0     114.0   24.0   261.0 121 42 81   3 9     0   5   132 129     51 3   114 24   261
698213 698213 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384001969 342 MURRAY MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_8 80.0 63.0 20.0   6.0 33.0     0.0   7.0   102.0 107.0     47.0   4.0     118.0   32.0   209.0 80 63 20   6 33     0   7   102 107     47 4   118 32   209
698217 698217 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384004681 344 Parkway Montessori/Community Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_8 31.0 45.0 18.0   5.0 52.0     0.0   4.0   79.0 76.0     41.0   1.0     115.0   37.0   155.0 31 45 18   5 52     0   4   79 76     41 1   115 37   155
698221 698221 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384001621 345 RAMSEY MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_8 51.0 65.0 20.0   2.0 32.0     0.0   6.0   91.0 85.0     32.0   8.0     106.0   25.0   176.0 51 65 20   2 32     0   6   91 85     32 8   106 25   176
698225 698225 MN Rice 66 school 2711760 656 Independent Districts and Schools FARIBAULT PUBLIC SCHOOL DISTRICT 271176000557 70 FARIBAULT MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_8 161.0 44.0 68.0   1.0 8.0     0.0   5.0   148.0 139.0     52.0   3.0     143.0   28.0   287.0 161 44 68   1 8     0   5   148 139     52 3   143 28   287
698229 698229 MN Rice 66 school 2723880 659 Independent Districts and Schools NORTHFIELD PUBLIC SCHOOL DISTRICT 272388001182 2 NORTHFIELD MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_8 278.0 5.0 42.0   1.0 5.0     0.0   3.0   157.0 177.0     22.0   3.0     86.0   43.0   334.0 278 5 42   1 5     0   3   157 177     22 3   86 43   334
698233 698233 MN Saint Louis 69 school 2711520 696 Independent Districts and Schools ELY PUBLIC SCHOOL DISTRICT 271152004645 1 Memorial Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_8 34.0 2.0 1.0   0.0 1.0     0.0   0.0   18.0 20.0     0.0   0.0     10.0   1.0   38.0 34 2 1   0 1     0   0   18 20     0 0   10 1   38
698238 698238 MN Saint Louis 69 school 2713920 700 Independent Districts and Schools HERMANTOWN PUBLIC SCHOOL DISTRICT 271392002143 15 HERMANTOWN MIDDLE Middle School (Grades 5-8) Regular School No Middle 05 08 2017   grade_8 159.0 1.0 3.0   0.0 1.0     0.0   3.0   81.0 86.0     0.0   0.0     17.0   24.0   167.0 159 1 3   0 1     0   3   81 86     0 0   17 24   167
698242 698242 MN Saint Louis 69 school 2730090 704 Independent Districts and Schools PROCTOR PUBLIC SCHOOL DISTRICT 273009001552 2 A.I. JEDLICKA MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_8 146.0 1.0 2.0   1.0 0.0     0.0   2.0   89.0 63.0     0.0   1.0     40.0   25.0   152.0 146 1 2   1 0     0   2   89 63     0 1   40 25   152
698246 698246 MN Saint Louis 69 school 2711040 709 Independent Districts and Schools DULUTH PUBLIC SCHOOL DISTRICT 271104002788 225 LINCOLN PARK MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_8 123.0 10.0 4.0   10.0 1.0     0.0   14.0   69.0 93.0     0.0   3.0     85.0   19.0   162.0 123 10 4   10 1     0   14   69 93     0 3   85 19   162
698250 698250 MN Saint Louis 69 school 2711040 709 Independent Districts and Schools DULUTH PUBLIC SCHOOL DISTRICT 271104000489 335 ORDEAN EAST MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_8 263.0 3.0 10.0   2.0 8.0     0.0   14.0   157.0 143.0     1.0   2.0     59.0   12.0   300.0 263 3 10   2 8     0   14   157 143     1 2   59 12   300
698255 698255 MN Scott 70 school 2715750 717 Independent Districts and Schools JORDAN PUBLIC SCHOOL DISTRICT 271575004144 128 JORDAN MIDDLE Middle School (Grades 5-8) Regular School No Middle 05 08 2017   grade_8 128.0 1.0 13.0   1.0 1.0     0.0   6.0   69.0 81.0     2.0   0.0     25.0   23.0   150.0 128 1 13   1 1     0   6   69 81     2 0   25 23   150
698259 698259 MN Scott 70 school 2730060 719 Independent Districts and Schools PRIOR LAKE-SAVAGE AREA SCHOOLS 273006001276 20 HIDDEN OAKS MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_8 304.0 18.0 20.0   4.0 23.0     0.0   11.0   167.0 213.0         *     58.0   40.0   380.0 304 18 20   4 23     0   11   167 213           58 40   380
698263 698263 MN Scott 70 school 2730060 719 Independent Districts and Schools PRIOR LAKE-SAVAGE AREA SCHOOLS 273006003626 21 TWIN OAKS MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_8 269.0 9.0 14.0   1.0 17.0     0.0   5.0   161.0 154.0     0.0   0.0         *   315.0 269 9 14   1 17     0   5   161 154     0 0         315
698267 698267 MN Scott 70 school 2723430 721 Independent Districts and Schools NEW PRAGUE AREA SCHOOLS 272343001145 111 NEW PRAGUE MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_8 276.0 4.0 6.0   1.0 5.0     0.0   2.0   156.0 138.0     1.0   0.0     46.0   31.0   294.0 276 4 6   1 5     0   2   156 138     1 0   46 31   294
698271 698271 MN Sherburne 71 school 2703870 726 Independent Districts and Schools BECKER PUBLIC SCHOOL DISTRICT 270387002556 30 BECKER MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_8 227.0 0.0 5.0   3.0 2.0     0.0   6.0   112.0 131.0     0.0   1.0     33.0   27.0   243.0 227 0 5   3 2     0   6   112 131     0 1   33 27   243
698275 698275 MN Sherburne 71 school 2705460 727 Independent Districts and Schools BIG LAKE PUBLIC SCHOOL DISTRICT 270546002462 30 BIG LAKE MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_8 217.0 9.0 11.0   1.0 7.0     0.0   4.0   125.0 124.0     2.0   0.0     53.0   24.0   249.0 217 9 11   1 7     0   4   125 124     2 0   53 24   249

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