enrollments

Data source: Big Local News · About: Big Local

681 rows where grade = "grade_7", state = "MN" and year = 2019 sorted by school_state_id

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2019 · 681 ✖

grade ✖

  • grade_7 · 681 ✖
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
1944368 1944368 MN Aitkin 1 school 2702760 1 Independent Districts and Schools AITKIN PUBLIC SCHOOL DISTRICT 270276000057 1 AITKIN SECONDARY SCHOOL Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_7 80.0 1.0 1.0   2.0 0.0     0.0   3.0   36.0 51.0     0.0   0.0     40.0   10.0   87.0 80 1 1   2 0     0   3   36 51     0 0   40 10   87
1944431 1944431 MN Brown 8 school 2733390 85 Independent Districts and Schools SPRINGFIELD PUBLIC SCHOOL DISTRICT 273339001471 1 SPRINGFIELD SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_7 40.0 0.0 0.0   0.0 0.0     0.0   0.0   25.0 15.0     0.0   0.0     15.0   1.0   40.0 40 0 0   0 0     0   0   25 15     0 0   15 1   40
1944446 1944446 MN Carlton 9 school 2707590 93 Independent Districts and Schools CARLTON PUBLIC SCHOOL DISTRICT 270759000327 1 CARLTON SECONDARY Secondary School (Grades 7-12) Regular School No High 06 12 2019   grade_7 18.0 0.0 1.0   6.0 0.0     0.0   2.0   18.0 9.0     0.0   0.0     10.0   5.0   27.0 18 0 1   6 0     0   2   18 9     0 0   10 5   27
1944467 1944467 MN Carlton 9 school 2738880 99 Independent Districts and Schools ESKO PUBLIC SCHOOL DISTRICT 273888001681 1 LINCOLN SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_7 107.0 0.0 1.0   1.0 0.0     0.0   3.0   52.0 60.0     0.0   1.0     10.0   10.0   112.0 107 0 1   1 0     0   3   52 60     0 1   10 10   112
1944530 1944530 MN Crow Wing 18 school 2709750 182 Independent Districts and Schools CROSBY-IRONTON PUBLIC SCHOOL DIST. 270975000417 1 CROSBY-IRONTON SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_7 70.0 1.0 2.0   0.0 0.0     0.0   3.0   36.0 40.0     0.0   0.0     34.0   15.0   76.0 70 1 2   0 0     0   3   36 40     0 0   34 15   76
1944545 1944545 MN Dodge 20 school 2713590 203 Independent Districts and Schools HAYFIELD PUBLIC SCHOOL DISTRICT 271359000702 1 HAYFIELD SECONDARY Secondary School (Grades 7-12) Regular School No High 06 12 2019   grade_7 50.0 1.0 2.0   1.0 0.0     0.0   0.0   31.0 23.0     0.0   0.0     13.0   9.0   54.0 50 1 2   1 0     0   0   31 23     0 0   13 9   54
1944559 1944559 MN Olmsted 55 school 2708220 227 Independent Districts and Schools CHATFIELD PUBLIC SCHOOLS 270822000348 1 CHATFIELD SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_7 68.0 0.0 3.0   0.0 1.0     0.0   1.0   41.0 32.0     0.0   0.0     12.0   7.0   73.0 68 0 3   0 1     0   1   41 32     0 0   12 7   73
1944580 1944580 MN Freeborn 24 school 2703030 242 Independent Districts and Schools ALDEN-CONGER PUBLIC SCHOOL DISTRICT 270303000080 1 ALDEN-CONGER SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_7 34.0 0.0 2.0   0.0 0.0     0.0   1.0   20.0 17.0     0.0   1.0     10.0   6.0   37.0 34 0 2   0 0     0   1   20 17     0 1   10 6   37
1944656 1944656 MN Isanti 30 school 2706060 314 Independent Districts and Schools BRAHAM PUBLIC SCHOOL DISTRICT 270606000247 1 BRAHAM AREA SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_7 60.0 1.0 1.0   0.0 1.0     0.0   0.0   37.0 26.0     1.0   0.0     22.0   6.0   63.0 60 1 1   0 1     0   0   37 26     1 0   22 6   63
1944664 1944664 MN Itasca 31 school 2710140 317 Independent Districts and Schools DEER RIVER PUBLIC SCHOOL DISTRICT 271014000433 1 DEER RIVER SECONDARY Secondary School (Grades 7-12) Regular School No High 06 12 2019   grade_7 38.0 1.0 3.0   27.0 0.0     0.0   9.0   40.0 38.0     0.0   4.0     58.0   16.0   78.0 38 1 3   27 0     0   9   40 38     0 4   58 16   78
1944715 1944715 MN Koochiching 36 school 2715000 361 Independent Districts and Schools INTERNATIONAL FALLS SCHOOL DISTRICT 271500000761 1 FALLS SECONDARY Secondary School (Grades 7-12) Regular School No High 06 12 2019   grade_7 60.0 0.0 2.0   9.0 0.0     0.0   2.0   34.0 39.0     1.0   1.0     32.0   11.0   73.0 60 0 2   9 0     0   2   34 39     1 1   32 11   73
1945381 1945381 MN Wadena 80 school 2700022 2155 Independent Districts and Schools WADENA-DEER CREEK SCHOOL DISTRICT 270002201733 1 WADENA-DEER CREEK SENIOR HIGH Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_7 84.0 2.0 2.0   0.0 1.0     0.0   3.0   38.0 54.0     0.0   0.0     52.0   19.0   92.0 84 2 2   0 1     0   3   38 54     0 0   52 19   92
1945647 1945647 MN Lyon 42 school 2700326 2904 Independent Districts and Schools TRACY AREA PUBLIC SCHOOL DISTRICT 270032604389 1 TRACY SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_7 42.0 0.0 5.0   0.0 7.0     0.0   0.0   28.0 26.0     2.0   0.0     32.0   9.0   54.0 42 0 5   0 7     0   0   28 26     2 0   32 9   54
1953799 1953799 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 2019   grade_7 37.0 0.0 0.0   0.0 0.0     0.0   3.0   25.0 15.0     0.0   0.0     20.0   7.0   40.0 37 0 0   0 0     0   3   25 15     0 0   20 7   40
1956439 1956439 MN Rice 66 school 2700129 160 State Operated Schools (which include MN Academy Deaf & Blind, School for the Arts) MINNESOTA STATE ACADEMIES 270012903056 1 MN ACADEMY FOR THE BLIND Special Education Special Education School No Other PK 12 2019   grade_7 4.0 0.0 0.0   0.0 0.0     0.0   0.0   3.0 1.0     *   *         *   4.0 4 0 0   0 0     0   0   3 1                 4
1944438 1944438 MN Carlton 9 school 2703690 91 Independent Districts and Schools BARNUM PUBLIC SCHOOL DISTRICT 270369000172 2 BARNUM SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_7 51.0 0.0 3.0   1.0 0.0     0.0   6.0   38.0 23.0     0.0   0.0     17.0   9.0   61.0 51 0 3   1 0     0   6   38 23     0 0   17 9   61
1944474 1944474 MN Carlton 9 school 2744190 100 Independent Districts and Schools WRENSHALL PUBLIC SCHOOL DISTRICT 274419001843 2 WRENSHALL SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_7 47.0 0.0 4.0   0.0 0.0     0.0   2.0   32.0 21.0     0.0   0.0     23.0   15.0   53.0 47 0 4   0 0     0   2   32 21     0 0   23 15   53
1944573 1944573 MN Fillmore 23 school 2718540 238 Independent Districts and Schools MABEL-CANTON PUBLIC SCHOOL DIST. 271854000858 2 MABEL-CANTON SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_7 13.0 0.0 1.0   0.0 0.0     0.0   0.0   9.0 5.0     1.0   0.0     5.0   2.0   14.0 13 0 1   0 0     0   0   9 5     1 0   5 2   14
1944588 1944588 MN Goodhue 25 school 2707500 252 Independent Districts and Schools CANNON FALLS PUBLIC SCHOOL DISTRICT 270750000324 2 Cannon Falls Secondary Secondary School (Grades 7-12) Regular School No High 06 12 2019   grade_7 79.0 1.0 2.0   1.0 1.0     0.0   4.0   44.0 44.0     1.0   0.0     27.0   12.0   88.0 79 1 2   1 1     0   4   44 44     1 0   27 12   88
1944595 1944595 MN Goodhue 25 school 2712900 253 Independent Districts and Schools GOODHUE PUBLIC SCHOOL DISTRICT 271290000648 2 GOODHUE SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_7 39.0 0.0 4.0   0.0 0.0     0.0   0.0   25.0 18.0     1.0   0.0     9.0   1.0   43.0 39 0 4   0 0     0   0   25 18     1 0   9 1   43
1944615 1944615 MN Grant 26 school 2713890 264 Independent Districts and Schools HERMAN-NORCROSS SCHOOL DISTRICT 271389000714 2 HERMAN SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_7 7.0 0.0 0.0   0.0 0.0     0.0   1.0   5.0 3.0     *   *         *   8.0 7 0 0   0 0     0   1   5 3                 8
1944779 1944779 MN Lyon 42 school 2721270 414 Independent Districts and Schools MINNEOTA PUBLIC SCHOOL DISTRICT 272127001068 2 MINNEOTA SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_7 32.0 0.0 4.0   1.0 1.0     0.0   2.0   23.0 17.0     2.0   0.0     19.0   7.0   40.0 32 0 4   1 1     0   2   23 17     2 0   19 7   40
1944990 1944990 MN Polk 60 school 2712180 600 Independent Districts and Schools FISHER PUBLIC SCHOOL DISTRICT 271218000586 2 FISHER SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_7 18.0 0.0 3.0   0.0 0.0     0.0   1.0   11.0 11.0     1.0   0.0     14.0   7.0   22.0 18 0 3   0 0     0   1   11 11     1 0   14 7   22
1945114 1945114 MN Stearns 73 school 2714190 738 Independent Districts and Schools HOLDINGFORD PUBLIC SCHOOL DISTRICT 271419000733 2 HOLDINGFORD SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_7 82.0 0.0 2.0   0.0 1.0     0.0   0.0   44.0 41.0     1.0   0.0     17.0   14.0   85.0 82 0 2   0 1     0   0   44 41     1 0   17 14   85
1945162 1945162 MN Stevens 75 school 2708940 771 Independent Districts and Schools CHOKIO-ALBERTA PUBLIC SCHOOL DIST. 270894000361 2 CHOKIO-ALBERTA SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_7 16.0 1.0 0.0   0.0 0.0     0.0   0.0   10.0 7.0     0.0   0.0     4.0   4.0   17.0 16 1 0   0 0     0   0   10 7     0 0   4 4   17
1945198 1945198 MN Traverse 78 school 2742330 803 Independent Districts and Schools WHEATON AREA PUBLIC SCHOOL DISTRICT 274233001784 2 WHEATON SECONDARY Secondary School (Grades 7-12) Regular School No High 06 12 2019   grade_7 20.0 0.0 2.0   0.0 0.0     0.0   1.0   7.0 16.0     0.0   0.0     9.0   3.0   23.0 20 0 2   0 0     0   1   7 16     0 0   9 3   23
1945226 1945226 MN Wadena 80 school 2732970 820 Independent Districts and Schools SEBEKA PUBLIC SCHOOL DISTRICT 273297001436 2 SEBEKA SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_7 37.0 0.0 0.0   0.0 0.0     0.0   2.0   17.0 22.0     0.0   0.0     15.0   10.0   39.0 37 0 0   0 0     0   2   17 22     0 0   15 10   39
1945311 1945311 MN Clay 14 school 2740810 914 Independent Districts and Schools ULEN-HITTERDAL PUBLIC SCHOOL DIST 274081001705 2 ULEN-HITTERDAL SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_7 21.0 1.0 0.0   2.0 0.0     0.0   2.0   13.0 13.0     0.0   0.0     7.0   2.0   26.0 21 1 0   2 0     0   2   13 13     0 0   7 2   26
1945461 1945461 MN Norman 54 school 2700101 2215 Independent Districts and Schools NORMAN COUNTY EAST SCHOOL DISTRICT 270010101695 2 NORMAN COUNTY EAST SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_7 18.0 0.0 0.0   0.0 0.0     0.0   1.0   10.0 9.0     0.0   0.0     8.0   4.0   19.0 18 0 0   0 0     0   1   10 9     0 0   8 4   19
1945482 1945482 MN Stearns 73 school 2700105 2364 Independent Districts and Schools Belgrade-Brooten-Elrosa Public School District 270010502567 2 BELGRADE-BROOTEN-ELROSA SEC. Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_7 38.0 0.0 7.0   0.0 1.0     0.0   0.0   27.0 19.0     5.0   0.0     15.0   5.0   46.0 38 0 7   0 1     0   0   27 19     5 0   15 5   46
1945547 1945547 MN Redwood 64 school 2700110 2754 Independent Districts and Schools CEDAR MOUNTAIN SCHOOL DISTRICT 270011001099 2 CEDAR MOUNTAIN SECONDARY Secondary School (Grades 7-12) Regular School No High 06 12 2019   grade_7 23.0 0.0 2.0   6.0 0.0     0.0   4.0   19.0 16.0     0.0   0.0     16.0   10.0   35.0 23 0 2   6 0     0   4   19 16     0 0   16 10   35
1953226 1953226 MN Aitkin 1 school 2714010 2 Independent Districts and Schools HILL CITY PUBLIC SCHOOL DISTRICT 271401004653 2 Hill City Middle School Middle School (Grades 5-8) Regular School No Middle 05 08 2019   grade_7 12.0 0.0 0.0   1.0 0.0     0.0   1.0   9.0 5.0     0.0   0.0     9.0   1.0   14.0 12 0 0   1 0     0   1   9 5     0 0   9 1   14
1953795 1953795 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 2019   grade_7 254.0 3.0 52.0   0.0 4.0     0.0   17.0   164.0 166.0     22.0   3.0     88.0   44.0   330.0 254 3 52   0 4     0   17   164 166     22 3   88 44   330
1953808 1953808 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 2019   grade_7 144.0 2.0 3.0   2.0 0.0     0.0   10.0   90.0 71.0     0.0   *     56.0   30.0   161.0 144 2 3   2 0     0   10   90 71     0     56 30   161
1953873 1953873 MN Stearns 73 school 2728140 741 Independent Districts and Schools PAYNESVILLE PUBLIC SCHOOL DISTRICT 272814001241 2 PAYNESVILLE MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_7 77.0 0.0 3.0   0.0 0.0     0.0   2.0   46.0 36.0     0.0   0.0     28.0   15.0   82.0 77 0 3   0 0     0   2   46 36     0 0   28 15   82
1953940 1953940 MN Wright 86 school 2703150 876 Independent Districts and Schools ANNANDALE PUBLIC SCHOOL DISTRICT 270315000093 2 ANNANDALE MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_7 167.0 3.0 5.0   0.0 0.0     0.0   8.0   84.0 99.0     0.0   0.0     52.0   24.0   183.0 167 3 5   0 0     0   8   84 99     0 0   52 24   183
1953983 1953983 MN Dodge 20 school 2740665 2125 Independent Districts and Schools TRITON SCHOOL DISTRICT 274066500035 2 TRITON MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_7 66.0 0.0 16.0   0.0 0.0     0.0   0.0   41.0 41.0     1.0   0.0     24.0   14.0   82.0 66 0 16   0 0     0   0   41 41     1 0   24 14   82
1954023 1954023 MN Renville 65 school 2712580 2365 Independent Districts and Schools G.F.W. Public School District 271258000043 2 G.F.W. Middle School Middle School (Grades 5-8) Regular School No Middle 05 08 2019   grade_7 43.0 1.0 12.0   0.0 0.0     0.0   1.0   36.0 21.0     3.0   0.0     30.0   19.0   57.0 43 1 12   0 0     0   1   36 21     3 0   30 19   57
1956453 1956453 MN Rice 66 school 2700129 160 State Operated Schools (which include MN Academy Deaf & Blind, School for the Arts) MINNESOTA STATE ACADEMIES 270012902409 2 MN ACADEMY FOR THE DEAF Special Education Special Education School No Other PK 12 2019   grade_7 5.0 1.0 1.0   0.0 0.0     0.0   0.0   1.0 6.0     *   *         *   7.0 5 1 1   0 0     0   0   1 6                 7
1944814 1944814 MN Marshall 45 school 2718920 447 Independent Districts and Schools GRYGLA PUBLIC SCHOOL DISTRICT 271892000897 3 GRYGLA SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_7 11.0 0.0 1.0   0.0 0.0     0.0   0.0   8.0 4.0     0.0   0.0     8.0   0.0   12.0 11 0 1   0 0     0   0   8 4     0 0   8 0   12
1945107 1945107 MN Saint Louis 69 school 2700001 712 Independent Districts and Schools MOUNTAIN IRON-BUHL SCHOOL DISTRICT 270000101613 3 MOUNTAIN IRON-BUHL SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_7 44.0 0.0 1.0   2.0 0.0     0.0   7.0   28.0 26.0     0.0   0.0     32.0   7.0   54.0 44 0 1   2 0     0   7   28 26     0 0   32 7   54
1945276 1945276 MN Winona 85 school 2733450 858 Independent Districts and Schools ST. CHARLES PUBLIC SCHOOL DISTRICT 273345001476 3 ST. CHARLES SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_7 51.0 0.0 13.0   0.0 2.0     0.0   4.0   36.0 34.0     5.0   0.0     22.0   6.0   70.0 51 0 13   0 2     0   4   36 34     5 0   22 6   70
1945411 1945411 MN Waseca 81 school 2700089 2168 Independent Districts and Schools NRHEG SCHOOL DISTRICT 270008901148 3 NRHEG SECONDARY Secondary School (Grades 7-12) Regular School No High 06 12 2019   grade_7 67.0 0.0 2.0   0.0 0.0     0.0   2.0   33.0 38.0     0.0   0.0     18.0   8.0   71.0 67 0 2   0 0     0   2   33 38     0 0   18 8   71
1945612 1945612 MN Big Stone 6 school 2700150 2888 Independent Districts and Schools CLINTON-GRACEVILLE-BEARDSLEY 270015000652 3 CLINTON-GRACEVILLE-BEARDSLEY SR. Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_7 17.0 0.0 0.0   0.0 0.0     0.0   0.0   8.0 9.0     *   *         *   17.0 17 0 0   0 0     0   0   8 9                 17
1953230 1953230 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000117 3 ANOKA MIDDLE SCHOOL FOR THE ARTS Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_7 454.0 68.0 27.0   6.0 23.0     1.0   33.0   306.0 306.0     23.0   13.0     209.0   104.0   612.0 454 68 27   6 23     1   33   306 306     23 13   209 104   612
1953465 1953465 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 2019   grade_7 52.0 1.0 0.0   0.0 0.0     0.0   1.0   27.0 27.0     1.0   0.0     12.0   4.0   54.0 52 1 0   0 0     0   1   27 27     1 0   12 4   54
1953957 1953957 MN Wright 86 school 2732070 883 Independent Districts and Schools ROCKFORD PUBLIC SCHOOL DISTRICT 273207001941 3 ROCKFORD MIDDLE Middle School (Grades 5-8) Regular School No Middle 05 08 2019   grade_7 118.0 9.0 13.0   0.0 0.0     0.0   5.0   77.0 68.0     4.0   0.0     30.0   13.0   145.0 118 9 13   0 0     0   5   77 68     4 0   30 13   145
1953987 1953987 MN Chisago 13 school 2700017 2144 Independent Districts and Schools CHISAGO LAKES SCHOOL DISTRICT 270001700351 3 CHISAGO LAKES MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_7 249.0 1.0 3.0   1.0 5.0     0.0   6.0   141.0 124.0     0.0   1.0     49.0   29.0   265.0 249 1 3   1 5     0   6   141 124     0 1   49 29   265
1953995 1953995 MN Clay 14 school 2710260 2164 Independent Districts and Schools DILWORTH-GLYNDON-FELTON 271026000448 3 DILWORTH-GLYNDON-FELTON MIDDLE SCH Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_7 104.0 0.0 9.0   2.0 0.0     0.0   7.0   54.0 68.0     0.0   1.0     37.0   20.0   122.0 104 0 9   2 0     0   7   54 68     0 1   37 20   122
1954009 1954009 MN Rock 67 school 2718330 2184 Independent Districts and Schools LUVERNE PUBLIC SCHOOL DISTRICT 271833002471 3 LUVERNE MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_7 90.0 2.0 6.0   0.0 0.0     0.0   1.0   50.0 49.0     *   *         *   99.0 90 2 6   0 0     0   1   50 49                 99
1954059 1954059 MN Redwood 64 school 2700182 2897 Independent Districts and Schools REDWOOD AREA SCHOOL DISTRICT 270018202301 3 REDWOOD VALLEY MIDDLE Middle School (Grades 5-8) Regular School No Middle 05 08 2019   grade_7 46.0 0.0 7.0   27.0 0.0     0.0   4.0   38.0 46.0     2.0   4.0     40.0   12.0   84.0 46 0 7   27 0     0   4   38 46     2 4   40 12   84
1954071 1954071 MN Douglas 21 school 2700382 2908 Independent Districts and Schools BRANDON-EVANSVILLE PUBLIC SCHOOLS 270038204740 3 Brandon-Evansville Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_7 38.0 0.0 3.0   0.0 0.0     0.0   0.0   26.0 15.0     0.0   0.0     12.0   6.0   41.0 38 0 3   0 0     0   0   26 15     0 0   12 6   41
1953234 1953234 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000099 4 COON RAPIDS MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_7 260.0 80.0 36.0   7.0 25.0     0.0   26.0   236.0 198.0     21.0   17.0     229.0   73.0   434.0 260 80 36   7 25     0   26   236 198     21 17   229 73   434
1953277 1953277 MN Becker 3 school 2710230 22 Independent Districts and Schools DETROIT LAKES PUBLIC SCHOOL DIST. 271023000443 4 DETROIT LAKES MIDDLE Middle School (Grades 5-8) Regular School No Middle 05 08 2019   grade_7 185.0 5.0 5.0   26.0 3.0     0.0   23.0   139.0 108.0     *   *         *   247.0 185 5 5   26 3     0   23   139 108                 247
1953629 1953629 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 2019   grade_7 162.0 2.0 7.0   2.0 0.0     0.0   7.0   93.0 87.0     2.0   0.0     40.0   21.0   180.0 162 2 7   2 0     0   7   93 87     2 0   40 21   180
1953680 1953680 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 2019   grade_7 67.0 18.0 129.0   2.0 18.0     0.0   7.0   129.0 112.0     62.0   1.0     177.0   50.0   241.0 67 18 129   2 18     0   7   129 112     62 1   177 50   241
1954018 1954018 MN Grant 26 school 2700104 2342 Independent Districts and Schools WEST CENTRAL AREA 270010404375 4 WCA Middle School Middle School (Grades 5-8) Regular School No Middle 05 08 2019   grade_7 67.0 0.0 1.0   0.0 0.0     0.0   3.0   37.0 34.0     0.0   0.0     19.0   6.0   71.0 67 0 1   0 0     0   3   37 34     0 0   19 6   71
1951450 1951450 MN Pipestone 59 school 2700108 2689 Independent Districts and Schools PIPESTONE AREA SCHOOL DISTRICT 270010803015 6 HEARTLAND ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 08 2019   grade_7 3.0 0.0 0.0   0.0 0.0     0.0   0.0   1.0 2.0     *   *         *   3.0 3 0 0   0 0     0   0   1 2                 3
1953238 1953238 MN Hennepin 27 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000108 6 JACKSON MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_7 372.0 135.0 53.0   4.0 88.0     1.0   56.0   369.0 340.0     39.0   10.0     243.0   80.0   709.0 372 135 53   4 88     1   56   369 340     39 10   243 80   709
1953610 1953610 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 2019   grade_7 121.0 12.0 17.0   0.0 16.0     0.0   9.0   88.0 87.0     *   *         *   175.0 121 12 17   0 16     0   9   88 87                 175
1953936 1953936 MN Winona 85 school 2744070 861 Independent Districts and Schools WINONA AREA PUBLIC SCHOOL DISTRICT 274407001830 6 WINONA MIDDLE Middle School (Grades 5-8) Regular School No Middle 05 08 2019   grade_7 159.0 16.0 14.0   1.0 8.0     0.0   9.0   88.0 119.0     9.0   0.0     81.0   32.0   207.0 159 16 14   1 8     0   9   88 119     9 0   81 32   207
1958222 1958222 MN Big Stone 6 school 2700150 2888 Independent Districts and Schools CLINTON-GRACEVILLE-BEARDSLEY 270015003019 6 Lismore Colony School Elementary/Secondary Combined (Grades K-12 limited to District Type 34 Bureau of Indian Education) Regular School No Other KG 11 2019   grade_7 3.0 0.0 0.0   0.0 0.0     0.0   0.0   2.0 1.0     *   *         *   3.0 3 0 0   0 0     0   0   2 1                 3
1954041 1954041 MN Pipestone 59 school 2700108 2689 Independent Districts and Schools PIPESTONE AREA SCHOOL DISTRICT 270010801264 7 PIPESTONE MIDDLE Middle School (Grades 5-8) Regular School No Middle 05 08 2019   grade_7 72.0 0.0 18.0   1.0 1.0     0.0   7.0   54.0 45.0     *   *         *   99.0 72 0 18   1 1     0   7   54 45                 99
1955546 1955546 MN Lyon 42 school 2718940 413 Independent Districts and Schools MARSHALL PUBLIC SCHOOL DISTRICT 271894002816 8 MATEC Public Area Learning Center ALC (State approved) Alternative School No High 07 12 2019   grade_7 1.0 4.0 3.0   0.0 0.0     0.0   0.0   6.0 2.0     *   *         *   8.0 1 4 3   0 0     0   0   6 2                 8
1953289 1953289 MN Benton 5 school 2732880 47 Independent Districts and Schools SAUK RAPIDS-RICE PUBLIC SCHOOLS 273288002246 9 SAUK RAPIDS-RICE MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_7 343.0 15.0 15.0   0.0 6.0     0.0   13.0   203.0 189.0     6.0   1.0     133.0   54.0   392.0 343 15 15   0 6     0   13   203 189     6 1   133 54   392
1944460 1944460 MN Carlton 9 school 2721450 97 Independent Districts and Schools MOOSE LAKE PUBLIC SCHOOL DISTRICT 272145001094 10 MOOSE LAKE SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_7 59.0 0.0 0.0   0.0 0.0     0.0   1.0   25.0 35.0     0.0   1.0     14.0   6.0   60.0 59 0 0   0 0     0   1   25 35     0 1   14 6   60
1944962 1944962 MN Pipestone 59 school 2711220 581 Independent Districts and Schools EDGERTON PUBLIC SCHOOL DISTRICT 271122000504 10 EDGERTON SECONDARY Secondary School (Grades 7-12) Regular School No High 06 12 2019   grade_7 21.0 1.0 5.0   0.0 0.0     0.0   0.0   15.0 12.0     4.0   0.0     11.0   7.0   27.0 21 1 5   0 0     0   0   15 12     4 0   11 7   27
1945297 1945297 MN Yellow Medicine 87 school 2707470 891 Independent Districts and Schools CANBY PUBLIC SCHOOL DISTRICT 270747000322 10 CANBY SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_7 45.0 0.0 2.0   0.0 0.0     0.0   1.0   26.0 22.0     0.0   0.0     17.0   9.0   48.0 45 0 2   0 0     0   1   26 22     0 0   17 9   48
1945554 1945554 MN Stevens 75 school 2700383 2769 Independent Districts and Schools MORRIS AREA PUBLIC SCHOOLS 270038304728 10 Morris Area Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_7 73.0 0.0 7.0   0.0 0.0     0.0   1.0   44.0 37.0     2.0   0.0     14.0   12.0   81.0 73 0 7   0 0     0   1   44 37     2 0   14 12   81
1945685 1945685 MN Sibley 72 school 2700092 4007 Charter Schools Minnesota New Country School 270009202487 10 MINNESOTA NEW COUNTRY SCHOOL Secondary School (Grades 7-12) Regular School Yes High 07 12 2019   grade_7 16.0 0.0 0.0   0.0 0.0     0.0   0.0   9.0 7.0     0.0   0.0     2.0   1.0   16.0 16 0 0   0 0     0   0   9 7     0 0   2 1   16
1945712 1945712 MN Washington 82 school 2700167 4043 Charter Schools MATH AND SCIENCE ACADEMY 270016703035 10 MATH AND SCIENCE ACADEMY Secondary School (Grades 7-12) Regular School Yes High 06 12 2019   grade_7 46.0 15.0 2.0   0.0 23.0     0.0   2.0   44.0 44.0     2.0   0.0     6.0   3.0   88.0 46 15 2   0 23     0   2   44 44     2 0   6 3   88
1945744 1945744 MN Blue Earth 7 school 2700226 4066 Charter Schools Kato Public Charter School 270022603471 10 Kato Public Charter School Secondary School (Grades 7-12) Regular School Yes High 06 12 2019   grade_7 2.0 0.0 2.0   0.0 0.0     0.0   0.0   3.0 1.0     *   *         *   4.0 2 0 2   0 0     0   0   3 1                 4
1945751 1945751 MN Ramsey 62 school 2700186 4074 Charter Schools AFSA HIGH SCHOOL 270018603139 10 AFSA HIGH SCHOOL Secondary School (Grades 7-12) Regular School Yes High 07 12 2019   grade_7 19.0 6.0 1.0   0.0 4.0     0.0   0.0   21.0 9.0     0.0   0.0     13.0   9.0   30.0 19 6 1   0 4     0   0   21 9     0 0   13 9   30
1945759 1945759 MN Rice 66 school 2700192 4081 Charter Schools DISCOVERY PUBLIC SCHOOL FARIBAULT 270019203145 10 DISCOVERY PUBLIC SCHOOL FARIBAULT Secondary School (Grades 7-12) Regular School Yes High 06 12 2019   grade_7 2.0 0.0 2.0   0.0 0.0     0.0   0.0   2.0 2.0     *   *         *   4.0 2 0 2   0 0     0   0   2 2                 4
1945767 1945767 MN Rice 66 school 2700355 4091 Charter Schools ARCADIA CHARTER SCHOOL 270035504151 10 ARCADIA CHARTER SCHOOL Secondary School (Grades 7-12) Regular School Yes High 06 12 2019   grade_7 15.0 0.0 1.0   1.0 0.0     0.0   1.0   9.0 9.0     0.0   0.0     2.0   5.0   18.0 15 0 1   1 0     0   1   9 9     0 0   2 5   18
1945774 1945774 MN Mcleod 43 school 2700214 4093 Charter Schools New Century Academy 270021403275 10 New Century Academy Secondary School (Grades 7-12) Regular School Yes High 07 12 2019   grade_7 9.0 0.0 0.0   0.0 0.0     0.0   1.0   4.0 6.0     0.0   0.0     7.0   1.0   10.0 9 0 0   0 0     0   1   4 6     0 0   7 1   10
1945789 1945789 MN Ramsey 62 school 2700344 4105 Charter Schools GREAT RIVER SCHOOL 270034404093 10 GREAT RIVER SCHOOL Secondary School (Grades 7-12) Regular School Yes High 07 12 2019   grade_7 42.0 5.0 5.0   0.0 10.0     1.0   1.0   32.0 32.0     0.0   0.0     8.0   11.0   64.0 42 5 5   0 10     1   1   32 32     0 0   8 11   64
1945810 1945810 MN Hennepin 27 school 2700364 4122 Charter Schools EAGLE RIDGE ACADEMY CHARTER SCHOOL 270036404108 10 EAGLE RIDGE ACADEMY CHARTER SCHOOL Secondary School (Grades 7-12) Regular School Yes High 06 12 2019   grade_7 49.0 27.0 5.0   0.0 13.0     0.0   5.0   55.0 44.0     6.0   0.0     31.0   10.0   99.0 49 27 5   0 13     0   5   55 44     6 0   31 10   99
1945818 1945818 MN Ramsey 62 school 2700246 4132 Charter Schools Twin Cities Academy 270024603307 10 TWIN CITIES ACADEMY Secondary School (Grades 7-12) Regular School Yes High 06 12 2019   grade_7 40.0 26.0 16.0   0.0 13.0     0.0   10.0   52.0 53.0     3.0   2.0     50.0   10.0   105.0 40 26 16   0 13     0   10   52 53     3 2   50 10   105
1945826 1945826 MN Itasca 31 school 2700256 4146 Charter Schools NORTHERN LIGHTS COMMUNITY SCHOOL 270025603314 10 NORTHERN LIGHTS COMMUNITY SCHOOL Secondary School (Grades 7-12) Regular School Yes High 06 12 2019   grade_7 16.0 0.0 0.0   0.0 0.0     0.0   0.0   8.0 8.0     0.0   0.0     12.0   7.0   16.0 16 0 0   0 0     0   0   8 8     0 0   12 7   16
1945838 1945838 MN Hennepin 27 school 2700315 4183 Charter Schools LIONSGATE ACADEMY 270031504325 10 LIONSGATE ACADEMY Secondary School (Grades 7-12) Regular School Yes High 07 12 2019   grade_7 15.0 3.0 2.0   0.0 0.0     0.0   2.0   19.0 3.0     *   *         *   22.0 15 3 2   0 0     0   2   19 3                 22
1945851 1945851 MN Ramsey 62 school 2700367 4200 Charter Schools STEP ACADEMY CHARTER SCHOOL 270036704507 10 STEP ACADEMY CHARTER SCHOOL Secondary School (Grades 7-12) Regular School Yes High 06 12 2019   grade_7 0.0 46.0 0.0   0.0 0.0     0.0   0.0   23.0 23.0     21.0   0.0         2.0   46.0 0 46 0   0 0     0   0   23 23     21 0     2   46
1945858 1945858 MN Saint Louis 69 school 2700372 4207 Charter Schools Vermilion Country School 270037204555 10 Vermilion Country School Secondary School (Grades 7-12) Regular School Yes High 07 12 2019   grade_7 2.0 0.0 0.0   0.0 0.0     0.0   0.0   1.0 1.0     *   *         *   2.0 2 0 0   0 0     0   0   1 1                 2
1945865 1945865 MN Kandiyohi 34 school 2700389 4217 Charter Schools TECHNICAL ACADEMIES OF MINNESOTA 270038904696 10 DREAM Technical Academy Secondary School (Grades 7-12) Regular School Yes High 07 12 2019   grade_7 2.0 0.0 2.0   0.0 0.0     0.0   0.0   3.0 1.0     *   *         *   4.0 2 0 2   0 0     0   0   3 1                 4
1945880 1945880 MN Hennepin 27 school 2700384 4218 Charter Schools Venture Academy 270038404697 10 Venture Academy Secondary School (Grades 7-12) Regular School Yes Secondary 06 11 2019   grade_7 4.0 10.0 37.0   4.0 0.0     0.0   2.0   28.0 29.0     20.0   1.0         16.0   57.0 4 10 37   4 0     0   2   28 29     20 1     16   57
1945887 1945887 MN Wright 86 school 2700403 4229 Charter Schools Jane Goodall Environmental Science Academy 270040304850 10 Jane Goodall Environmental Science Academy Secondary School (Grades 7-12) Regular School Yes High 06 12 2019   grade_7 15.0 0.0 0.0   0.0 0.0     0.0   0.0   13.0 2.0     0.0   0.0     4.0   7.0   15.0 15 0 0   0 0     0   0   13 2     0 0   4 7   15
1945895 1945895 MN Ramsey 62 school 2700402 4237 Charter Schools Career Pathways 270040204836 10 Career Pathways Secondary School (Grades 7-12) Regular School Yes High 06 12 2019   grade_7 2.0 3.0 1.0   0.0 0.0     0.0   0.0   1.0 5.0     *   *         *   6.0 2 3 1   0 0     0   0   1 5                 6
1945903 1945903 MN Olmsted 55 school 2700412 4238 Charter Schools Rochester Beacon Academy 270041204878 10 Rochester Beacon Academy Secondary School (Grades 7-12) Regular School Yes High 06 12 2019   grade_7 15.0 1.0 1.0   0.0 0.0     0.0   1.0   16.0 2.0     0.0   0.0     6.0   11.0   18.0 15 1 1   0 0     0   1   16 2     0 0   6 11   18
1951693 1951693 MN Lesueur 40 school 2700379 2905 Independent Districts and Schools TRI-CITY UNITED SCHOOL DISTRICT 270037904626 10 LE CENTER PRE K-8 Elementary School (Grades PK-6) Regular School No Elementary PK 08 2019   grade_7 38.0 0.0 23.0   0.0 0.0     0.0   3.0   36.0 28.0     10.0   0.0     31.0   12.0   64.0 38 0 23   0 0     0   3   36 28     10 0   31 12   64
1952110 1952110 MN Winona 85 school 2705850 4001 Charter Schools BLUFFVIEW MONTESSORI 270585000018 10 BLUFFVIEW MONTESSORI Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2019   grade_7 16.0 1.0 0.0   0.0 1.0     0.0   1.0   11.0 8.0     0.0   0.0     5.0   6.0   19.0 16 1 0   0 1     0   1   11 8     0 0   5 6   19
1952121 1952121 MN Hennepin 27 school 2700027 4004 Charter Schools CEDAR RIVERSIDE COMMUNITY SCHOOL 270002702340 10 CEDAR RIVERSIDE COMMUNITY SCHOOL Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2019   grade_7 0.0 12.0 3.0   0.0 0.0     0.0   0.0   7.0 8.0     10.0   0.0         1.0   15.0 0 12 3   0 0     0   0   7 8     10 0     1   15
1952147 1952147 MN Hennepin 27 school 2700096 4011 Charter Schools Athlos Leadership Academy 270009601892 10 Athlos Leadership Academy Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2019   grade_7 11.0 46.0 8.0   0.0 3.0     0.0   6.0   37.0 37.0     4.0   0.0     47.0   16.0   74.0 11 46 8   0 3     0   6   37 37     4 0   47 16   74
1952166 1952166 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 2019   grade_7 16.0 0.0 1.0   0.0 2.0     0.0   1.0   12.0 8.0     0.0   0.0     2.0   5.0   20.0 16 0 1   0 2     0   1   12 8     0 0   2 5   20
1952201 1952201 MN Ramsey 62 school 2700118 4018 Charter Schools ACHIEVE LANGUAGE ACADEMY 270011802608 10 ACHIEVE LANGUAGE ACADEMY Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2019   grade_7 5.0 4.0 24.0   0.0 14.0     0.0   1.0   18.0 30.0     17.0   2.0     40.0   9.0   48.0 5 4 24   0 14     0   1   18 30     17 2   40 9   48
1952211 1952211 MN Saint Louis 69 school 2700133 4020 Charter Schools DULUTH PUBLIC SCHOOLS ACADEMY 270013302711 10 NORTH STAR ACADEMY Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2019   grade_7 110.0 6.0 9.0   6.0 1.0     0.0   13.0   71.0 74.0     1.0   0.0     70.0   37.0   145.0 110 6 9   6 1     0   13   71 74     1 0   70 37   145
1952228 1952228 MN Ramsey 62 school 2700140 4027 Charter Schools HIGHER GROUND ACADEMY 270014002719 10 HIGHER GROUND ACADEMY Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2019   grade_7 0.0 71.0 0.0   0.0 0.0     0.0   0.0   36.0 35.0     10.0   0.0         4.0   71.0 0 71 0   0 0     0   0   36 35     10 0     4   71
1952257 1952257 MN Hennepin 27 school 2700159 4038 Charter Schools SOJOURNER TRUTH ACADEMY 270015902954 10 SOJOURNER TRUTH ACADEMY Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2019   grade_7 0.0 39.0 6.0   0.0 0.0     0.0   3.0   25.0 23.0     5.0   3.0         10.0   48.0 0 39 6   0 0     0   3   25 23     5 3     10   48
1952267 1952267 MN Nicollet 52 school 2700174 4050 Charter Schools LAFAYETTE PUBLIC CHARTER SCHOOL 270017403042 10 LAFAYETTE PUBLIC CHARTER SCHOOL Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2019   grade_7 9.0 0.0 1.0   0.0 0.0     0.0   0.0   1.0 9.0     *   *         *   10.0 9 0 1   0 0     0   0   1 9                 10
1952299 1952299 MN Beltrami 4 school 2700225 4058 Charter Schools SCHOOLCRAFT LEARNING COMMUNITY CHTR 270022503464 10 SCHOOLCRAFT LEARNING COMMUNITY CHTR Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2019   grade_7 16.0 1.0 2.0   0.0 0.0     0.0   2.0   13.0 8.0     0.0   0.0     10.0   7.0   21.0 16 1 2   0 0     0   2   13 8     0 0   10 7   21
1952309 1952309 MN Crow Wing 18 school 2700218 4059 Charter Schools CROSSLAKE COMMUNITY CHARTER SCHOOL 270021803475 10 CROSSLAKE COMMUNITY CHARTER SCHOOL Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2019   grade_7 12.0 1.0 1.0   0.0 0.0     0.0   2.0   7.0 9.0     *   *         *   16.0 12 1 1   0 0     0   2   7 9                 16

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