enrollments

Data source: Big Local News · About: Big Local

676 rows where grade = "grade_7", state = "MN" and year = 2017 sorted by school_state_id

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2017 · 676 ✖

grade ✖

  • grade_7 · 676 ✖
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
689010 689010 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 2017   grade_7 102.0 0.0 1.0   0.0 0.0     0.0   4.0   55.0 52.0     0.0   0.0     39.0   14.0   107.0 102 0 1   0 0     0   4   55 52     0 0   39 14   107
689073 689073 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 2017   grade_7 43.0 0.0 2.0   0.0 0.0     0.0   0.0   27.0 18.0     0.0   0.0     19.0   7.0   45.0 43 0 2   0 0     0   0   27 18     0 0   19 7   45
689088 689088 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 Other 06 12 2017   grade_7 20.0 1.0 0.0   4.0 1.0     0.0   1.0   15.0 12.0     0.0   0.0     10.0   5.0   27.0 20 1 0   4 1     0   1   15 12     0 0   10 5   27
689109 689109 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 2017   grade_7 95.0 0.0 4.0   0.0 2.0     0.0   6.0   51.0 56.0     0.0   0.0     9.0   14.0   107.0 95 0 4   0 2     0   6   51 56     0 0   9 14   107
689172 689172 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 2017   grade_7 68.0 3.0 2.0   0.0 1.0     0.0   6.0   40.0 40.0     0.0   0.0     39.0   13.0   80.0 68 3 2   0 1     0   6   40 40     0 0   39 13   80
689187 689187 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 Other 06 12 2017   grade_7 45.0 0.0 5.0   1.0 0.0     0.0   0.0   22.0 29.0     1.0   0.0     20.0   8.0   51.0 45 0 5   1 0     0   0   22 29     1 0   20 8   51
689201 689201 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 2017   grade_7 67.0 1.0 1.0   0.0 0.0     0.0   1.0   35.0 35.0     0.0   0.0     17.0   7.0   70.0 67 1 1   0 0     0   1   35 35     0 0   17 7   70
689222 689222 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 2017   grade_7 28.0 0.0 1.0   0.0 0.0     0.0   1.0   13.0 17.0     0.0   0.0     14.0   7.0   30.0 28 0 1   0 0     0   1   13 17     0 0   14 7   30
689306 689306 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 2017   grade_7 50.0 0.0 0.0   0.0 0.0     0.0   1.0   24.0 27.0     0.0   0.0     22.0   5.0   51.0 50 0 0   0 0     0   1   24 27     0 0   22 5   51
689314 689314 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 Other 06 12 2017   grade_7 40.0 0.0 2.0   22.0 0.0     0.0   8.0   37.0 35.0     0.0   0.0     55.0   21.0   72.0 40 0 2   22 0     0   8   37 35     0 0   55 21   72
689365 689365 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 Other 06 12 2017   grade_7 82.0 1.0 2.0   3.0 0.0     0.0   0.0   46.0 42.0     0.0   0.0     39.0   10.0   88.0 82 1 2   3 0     0   0   46 42     0 0   39 10   88
690022 690022 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 2017   grade_7 48.0 0.0 4.0   0.0 1.0     0.0   1.0   27.0 27.0     0.0   2.0     24.0   9.0   54.0 48 0 4   0 1     0   1   27 27     0 2   24 9   54
690294 690294 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 2017   grade_7 59.0 0.0 4.0   1.0 8.0     0.0   0.0   36.0 36.0     3.0   0.0     24.0   7.0   72.0 59 0 4   1 8     0   0   36 36     3 0   24 7   72
698232 698232 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_7 32.0 0.0 0.0   2.0 1.0     0.0   2.0   19.0 18.0     0.0   0.0     12.0   4.0   37.0 32 0 0   2 1     0   2   19 18     0 0   12 4   37
700955 700955 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 2017   grade_7 2.0 2.0 0.0   0.0 0.0     0.0   0.0   1.0 3.0         *         *   4.0 2 2 0   0 0     0   0   1 3                 4
689080 689080 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 2017   grade_7 62.0 0.0 0.0   0.0 0.0     0.0   4.0   27.0 39.0     0.0   0.0     25.0   6.0   66.0 62 0 0   0 0     0   4   27 39     0 0   25 6   66
689116 689116 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 2017   grade_7 26.0 0.0 1.0   0.0 0.0     0.0   1.0   14.0 14.0     0.0   0.0     14.0   9.0   28.0 26 0 1   0 0     0   1   14 14     0 0   14 9   28
689215 689215 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 2017   grade_7 13.0 0.0 1.0   0.0 0.0     0.0   0.0   7.0 7.0     1.0   0.0     7.0   4.0   14.0 13 0 1   0 0     0   0   7 7     1 0   7 4   14
689230 689230 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 Other 06 12 2017   grade_7 80.0 0.0 3.0   0.0 1.0     1.0   7.0   46.0 46.0     0.0   1.0     21.0   8.0   92.0 80 0 3   0 1     1   7   46 46     0 1   21 8   92
689237 689237 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 2017   grade_7 51.0 0.0 3.0   0.0 0.0     0.0   0.0   28.0 26.0     0.0   0.0     12.0   1.0   54.0 51 0 3   0 0     0   0   28 26     0 0   12 1   54
689257 689257 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 2017   grade_7 10.0 0.0 1.0   0.0 0.0     0.0   0.0   6.0 5.0     0.0   0.0     5.0   1.0   11.0 10 0 1   0 0     0   0   6 5     0 0   5 1   11
689429 689429 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 2017   grade_7 44.0 0.0 5.0   0.0 0.0     0.0   1.0   21.0 29.0     3.0   0.0     17.0   4.0   50.0 44 0 5   0 0     0   1   21 29     3 0   17 4   50
689647 689647 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 2017   grade_7 19.0 0.0 2.0   0.0 1.0     0.0   1.0   15.0 8.0     1.0   0.0     10.0   4.0   23.0 19 0 2   0 1     0   1   15 8     1 0   10 4   23
689771 689771 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 2017   grade_7 69.0 1.0 1.0   0.0 0.0     0.0   0.0   39.0 32.0     1.0   0.0     25.0   5.0   71.0 69 1 1   0 0     0   0   39 32     1 0   25 5   71
689818 689818 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 2017   grade_7 25.0 0.0 2.0   0.0 0.0     0.0   0.0   15.0 12.0     0.0   0.0     8.0   1.0   27.0 25 0 2   0 0     0   0   15 12     0 0   8 1   27
689854 689854 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 Other 06 12 2017   grade_7 29.0 0.0 4.0   0.0 0.0     0.0   2.0   16.0 19.0     0.0   0.0     18.0   9.0   35.0 29 0 4   0 0     0   2   16 19     0 0   18 9   35
689882 689882 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 2017   grade_7 36.0 0.0 0.0   0.0 0.0     0.0   2.0   20.0 18.0     0.0   0.0     18.0   4.0   38.0 36 0 0   0 0     0   2   20 18     0 0   18 4   38
689960 689960 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 2017   grade_7 20.0 0.0 0.0   3.0 2.0     0.0   1.0   15.0 11.0     0.0   0.0     7.0   4.0   26.0 20 0 0   3 2     0   1   15 11     0 0   7 4   26
690101 690101 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 2017   grade_7 16.0 0.0 0.0   4.0 0.0     0.0   3.0   11.0 12.0     0.0   0.0     11.0   5.0   23.0 16 0 0   4 0     0   3   11 12     0 0   11 5   23
690122 690122 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 2017   grade_7 50.0 0.0 4.0   1.0 0.0     0.0   1.0   32.0 24.0     0.0   0.0     24.0   7.0   56.0 50 0 4   1 0     0   1   32 24     0 0   24 7   56
690194 690194 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 Other 06 12 2017   grade_7 36.0 0.0 0.0   7.0 0.0     0.0   3.0   27.0 19.0     0.0   0.0     23.0   14.0   46.0 36 0 0   7 0     0   3   27 19     0 0   23 14   46
697681 697681 MN Aitkin 1 school 2714010 2 Independent Districts and Schools HILL CITY PUBLIC SCHOOL DISTRICT 271401004653 2 Hill City Middle School Middle School (Grades 5-8) Regular School No Middle 05 08 2017   grade_7 30.0 0.0 0.0   0.0 0.0     0.0   3.0   17.0 16.0     0.0   0.0     21.0   4.0   33.0 30 0 0   0 0     0   3   17 16     0 0   21 4   33
698228 698228 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_7 255.0 7.0 45.0   1.0 4.0     0.0   12.0   163.0 161.0     17.0   3.0     87.0   35.0   324.0 255 7 45   1 4     0   12   163 161     17 3   87 35   324
698241 698241 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_7 130.0 0.0 7.0   0.0 0.0     0.0   4.0   73.0 68.0     1.0   *     44.0   29.0   141.0 130 0 7   0 0     0   4   73 68     1     44 29   141
698298 698298 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 2017   grade_7 73.0 1.0 0.0   0.0 0.0     1.0   1.0   39.0 37.0     0.0   0.0     21.0   14.0   76.0 73 1 0   0 0     1   1   39 37     0 0   21 14   76
698349 698349 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 2017   grade_7 135.0 1.0 2.0   1.0 2.0     0.0   4.0   73.0 72.0     1.0   1.0     37.0   20.0   145.0 135 1 2   1 2     0   4   73 72     1 1   37 20   145
698393 698393 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 2017   grade_7 67.0 1.0 24.0   0.0 0.0     0.0   5.0   44.0 53.0     6.0   1.0     42.0   18.0   97.0 67 1 24   0 0     0   5   44 53     6 1   42 18   97
698441 698441 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 2017   grade_7 39.0 1.0 11.0   0.0 0.0     0.0   1.0   24.0 28.0     5.0   0.0     25.0   11.0   52.0 39 1 11   0 0     0   1   24 28     5 0   25 11   52
700970 700970 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 2017   grade_7 2.0 1.0 1.0   1.0 0.0     0.0   0.0   3.0 2.0         *         *   5.0 2 1 1   1 0     0   0   3 2                 5
702544 702544 MN Redwood 64 school 2721210 635 Independent Districts and Schools MILROY PUBLIC SCHOOL DISTRICT 272121000928 2 MILROY JUNIOR HIGH Junior High School (Grades 7-8 or 7-9) Regular School No Middle 07 08 2017   grade_7 6.0 0.0 0.0   0.0 0.0     0.0   0.0   1.0 5.0         *         *   6.0 6 0 0   0 0     0   0   1 5                 6
689464 689464 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 2017   grade_7 11.0 0.0 0.0   0.0 0.0     0.0   0.0   7.0 4.0     0.0   0.0     5.0   0.0   11.0 11 0 0   0 0     0   0   7 4     0 0   5 0   11
689764 689764 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 2017   grade_7 33.0 0.0 1.0   1.0 0.0     0.0   2.0   20.0 17.0     0.0   0.0     12.0   2.0   37.0 33 0 1   1 0     0   2   20 17     0 0   12 2   37
689932 689932 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 2017   grade_7 56.0 0.0 6.0   0.0 1.0     0.0   2.0   42.0 23.0     2.0   0.0     17.0   4.0   65.0 56 0 6   0 1     0   2   42 23     2 0   17 4   65
690052 690052 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 Other 06 12 2017   grade_7 66.0 2.0 2.0   0.0 1.0     0.0   3.0   39.0 35.0     0.0   0.0     21.0   9.0   74.0 66 2 2   0 1     0   3   39 35     0 0   21 9   74
690259 690259 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 2017   grade_7 22.0 0.0 0.0   0.0 0.0     0.0   0.0   11.0 11.0         *         *   22.0 22 0 0   0 0     0   0   11 11                 22
697685 697685 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 2017   grade_7 480.0 58.0 39.0   9.0 35.0     0.0   16.0   320.0 317.0     21.0   8.0     218.0   106.0   637.0 480 58 39   9 35     0   16   320 317     21 8   218 106   637
697916 697916 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_7 45.0 0.0 1.0   0.0 0.0     0.0   0.0   29.0 17.0     0.0   0.0     21.0   3.0   46.0 45 0 1   0 0     0   0   29 17     0 0   21 3   46
698367 698367 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 2017   grade_7 116.0 8.0 14.0   0.0 3.0     0.0   1.0   70.0 72.0     3.0   0.0     34.0   14.0   142.0 116 8 14   0 3     0   1   70 72     3 0   34 14   142
698405 698405 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 2017   grade_7 261.0 2.0 4.0   0.0 6.0     0.0   8.0   141.0 140.0         *         30.0   281.0 261 2 4   0 6     0   8   141 140             30   281
698413 698413 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 2017   grade_7 103.0 1.0 7.0   2.0 0.0     0.0   2.0   53.0 62.0     1.0   1.0     33.0   11.0   115.0 103 1 7   2 0     0   2   53 62     1 1   33 11   115
698427 698427 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 2017   grade_7 89.0 1.0 7.0   0.0 1.0     0.0   3.0   62.0 39.0         0.0     30.0   *   101.0 89 1 7   0 1     0   3   62 39       0   30     101
698477 698477 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 2017   grade_7 51.0 1.0 7.0   10.0 0.0     0.0   4.0   42.0 31.0     1.0   2.0     41.0   15.0   73.0 51 1 7   10 0     0   4   42 31     1 2   41 15   73
698489 698489 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 2017   grade_7 32.0 0.0 2.0   0.0 0.0     0.0   1.0   22.0 13.0     0.0   0.0     10.0   1.0   35.0 32 0 2   0 0     0   1   22 13     0 0   10 1   35
697689 697689 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 2017   grade_7 254.0 54.0 36.0   5.0 20.0     0.0   16.0   174.0 211.0     20.0   4.0     179.0   48.0   385.0 254 54 36   5 20     0   16   174 211     20 4   179 48   385
697731 697731 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 2017   grade_7 151.0 5.0 7.0   21.0 1.0     0.0   34.0   109.0 110.0         *         *   219.0 151 5 7   21 1     0   34   109 110                 219
698074 698074 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_7 167.0 2.0 4.0   0.0 2.0     0.0   2.0   86.0 91.0     2.0   1.0     46.0   19.0   177.0 167 2 4   0 2     0   2   86 91     2 1   46 19   177
698115 698115 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_7 77.0 20.0 122.0   1.0 23.0     0.0   7.0   130.0 120.0         *     180.0   *   250.0 77 20 122   1 23     0   7   130 120           180     250
698436 698436 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 2017   grade_7 36.0 2.0 0.0   0.0 0.0     0.0   3.0   16.0 25.0     0.0   0.0     13.0   6.0   41.0 36 2 0   0 0     0   3   16 25     0 0   13 6   41
697693 697693 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 2017   grade_7 379.0 122.0 59.0   2.0 105.0     0.0   56.0   382.0 341.0     41.0   8.0     271.0   76.0   723.0 379 122 59   2 105     0   56   382 341     41 8   271 76   723
698055 698055 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_7 113.0 15.0 21.0   0.0 15.0     0.0   5.0   85.0 84.0     23.0   4.0     65.0   22.0   169.0 113 15 21   0 15     0   5   85 84     23 4   65 22   169
698345 698345 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 2017   grade_7 225.0 7.0 6.0   2.0 11.0     0.0   11.0   148.0 114.0     6.0   0.0     99.0   55.0   262.0 225 7 6   2 11     0   11   148 114     6 0   99 55   262
700031 700031 MN Nobles 53 school 2744160 518 Independent Districts and Schools WORTHINGTON PUBLIC SCHOOL DISTRICT 274416002335 6 WORTHINGTON AREA LEARNING CENTER Public Area Learning Center ALC (State approved) Alternative School No High 07 12 2017   grade_7 0.0 1.0 1.0   0.0 0.0     0.0   0.0   1.0 1.0         *         *   2.0 0 1 1   0 0     0   0   1 1                 2
702706 702706 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 10 2017   grade_7 2.0 0.0 0.0   0.0 0.0     0.0   0.0   0.0 2.0         *         *   2.0 2 0 0   0 0     0   0   0 2                 2
698459 698459 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 2017   grade_7 71.0 2.0 10.0   2.0 2.0     0.0   5.0   52.0 40.0     6.0   0.0     47.0   10.0   92.0 71 2 10   2 2     0   5   52 40     6 0   47 10   92
697743 697743 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 2017   grade_7 301.0 13.0 9.0   2.0 3.0     0.0   13.0   171.0 170.0     4.0   1.0     111.0   61.0   341.0 301 13 9   2 3     0   13   171 170     4 1   111 61   341
689102 689102 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 2017   grade_7 53.0 0.0 1.0   0.0 0.0     0.0   0.0   26.0 28.0     0.0   1.0     22.0   8.0   54.0 53 0 1   0 0     0   0   26 28     0 1   22 8   54
689619 689619 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 Other 06 12 2017   grade_7 19.0 1.0 7.0   0.0 0.0     0.0   0.0   10.0 17.0     4.0   1.0     12.0   6.0   27.0 19 1 7   0 0     0   0   10 17     4 1   12 6   27
689946 689946 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 2017   grade_7 52.0 1.0 2.0   0.0 1.0     0.0   0.0   25.0 31.0     0.0   0.0     15.0   10.0   56.0 52 1 2   0 1     0   0   25 31     0 0   15 10   56
690201 690201 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 2017   grade_7 77.0 1.0 12.0   1.0 1.0     0.0   5.0   50.0 47.0     0.0   0.0     28.0   19.0   97.0 77 1 12   1 1     0   5   50 47     0 0   28 19   97
690330 690330 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 2017   grade_7 14.0 0.0 0.0   1.0 0.0     0.0   2.0   8.0 9.0     0.0   0.0     8.0   3.0   17.0 14 0 0   1 0     0   2   8 9     0 0   8 3   17
690357 690357 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 Other 06 12 2017   grade_7 47.0 13.0 1.0   1.0 19.0     0.0   7.0   45.0 43.0     2.0   0.0     4.0   4.0   88.0 47 13 1   1 19     0   7   45 43     2 0   4 4   88
690388 690388 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 Other 06 12 2017   grade_7 2.0 0.0 1.0   0.0 0.0     0.0   1.0   1.0 3.0         *         *   4.0 2 0 1   0 0     0   1   1 3                 4
690401 690401 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 Other 06 12 2017   grade_7 2.0 0.0 1.0   0.0 0.0     0.0   0.0   1.0 2.0         *         *   3.0 2 0 1   0 0     0   0   1 2                 3
690409 690409 MN Rice 66 school 2700355 4091 Charter Schools ARCADIA CHARTER SCHOOL 270035504151 10 ARCADIA CHARTER SCHOOL Secondary School (Grades 7-12) Regular School Yes Other 06 12 2017   grade_7 15.0 0.0 2.0   0.0 0.0     0.0   0.0   10.0 7.0     0.0   0.0     1.0   7.0   17.0 15 0 2   0 0     0   0   10 7     0 0   1 7   17
690416 690416 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 2017   grade_7 16.0 0.0 2.0   0.0 0.0     0.0   0.0   7.0 11.0     0.0   0.0     10.0   6.0   18.0 16 0 2   0 0     0   0   7 11     0 0   10 6   18
690431 690431 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 2017   grade_7 39.0 4.0 5.0   0.0 2.0     0.0   1.0   25.0 26.0     0.0   0.0     8.0   8.0   51.0 39 4 5   0 2     0   1   25 26     0 0   8 8   51
690460 690460 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 Other 06 12 2017   grade_7 43.0 8.0 1.0   0.0 21.0     0.0   2.0   31.0 44.0     3.0   0.0     13.0   3.0   75.0 43 8 1   0 21     0   2   31 44     3 0   13 3   75
690468 690468 MN Ramsey 62 school 2700246 4132 Charter Schools Twin Cities Academy 270024603307 10 TWIN CITIES ACADEMY Secondary School (Grades 7-12) Regular School Yes Other 06 12 2017   grade_7 45.0 20.0 12.0   0.0 13.0     0.0   10.0   52.0 48.0     6.0   0.0     35.0   7.0   100.0 45 20 12   0 13     0   10   52 48     6 0   35 7   100
690476 690476 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 Other 06 12 2017   grade_7 7.0 0.0 0.0   1.0 0.0     0.0   2.0   7.0 3.0     0.0   0.0     6.0   6.0   10.0 7 0 0   1 0     0   2   7 3     0 0   6 6   10
690483 690483 MN Sherburne 71 school 2700276 4160 Charter Schools SPECTRUM HIGH SCHOOL 270027603615 10 SPECTRUM HIGH SCHOOL Secondary School (Grades 7-12) Regular School Yes High 07 12 2017   grade_7 84.0 3.0 5.0   0.0 5.0     0.0   3.0   43.0 57.0     0.0   0.0     13.0   19.0   100.0 84 3 5   0 5     0   3   43 57     0 0   13 19   100
690490 690490 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 2017   grade_7 18.0 1.0 0.0   0.0 1.0     0.0   1.0   16.0 5.0         *         18.0   21.0 18 1 0   0 1     0   1   16 5             18   21
690498 690498 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 Other 06 12 2017   grade_7 0.0 50.0 0.0   0.0 0.0     0.0   0.0   25.0 25.0     19.0   0.0         1.0   50.0 0 50 0   0 0     0   0   25 25     19 0     1   50
690505 690505 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 2017   grade_7 2.0 0.0 0.0   3.0 0.0     0.0   1.0   3.0 3.0         *         *   6.0 2 0 0   3 0     0   1   3 3                 6
690512 690512 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 2017   grade_7 1.0 0.0 1.0   0.0 0.0     0.0   1.0   1.0 2.0         *         *   3.0 1 0 1   0 0     0   1   1 2                 3
690527 690527 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 Other 06 12 2017   grade_7 18.0 0.0 1.0   0.0 0.0     0.0   1.0   14.0 6.0     0.0   0.0     5.0   6.0   20.0 18 0 1   0 0     0   1   14 6     0 0   5 6   20
690534 690534 MN Unknown   school 2700402 4237 Charter Schools Metropolitan Education for Future Employment 270040204836 10 Metropolitan Education for Future Employment Charter Secondary School (Grades 7-12) Regular School Yes Other 06 12 2017   grade_7 0.0 5.0 0.0   0.0 0.0     0.0   0.0   5.0 0.0         *         *   5.0 0 5 0   0 0     0   0   5 0                 5
690542 690542 MN Olmsted 55 school 2700412 4238 Charter Schools Rochester Beacon Academy 270041204878 10 Rochester Beacon Academy Secondary School (Grades 7-12) Regular School Yes Other 06 11 2017   grade_7 25.0 1.0 0.0   0.0 1.0     0.0   5.0   22.0 10.0     0.0   0.0     10.0   24.0   32.0 25 1 0   0 1     0   5   22 10     0 0   10 24   32
696219 696219 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 2017   grade_7 46.0 1.0 16.0   0.0 0.0     0.0   0.0   29.0 34.0     4.0   0.0     30.0   3.0   63.0 46 1 16   0 0     0   0   29 34     4 0   30 3   63
696627 696627 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 2017   grade_7 22.0 1.0 0.0   0.0 0.0     0.0   0.0   9.0 14.0     0.0   0.0     5.0   1.0   23.0 22 1 0   0 0     0   0   9 14     0 0   5 1   23
696638 696638 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 2017   grade_7 0.0 18.0 1.0   0.0 0.0     0.0   0.0   7.0 12.0     5.0   0.0         3.0   19.0 0 18 1   0 0     0   0   7 12     5 0     3   19
696664 696664 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 2017   grade_7 16.0 40.0 8.0   1.0 3.0     0.0   19.0   36.0 51.0     8.0   2.0     49.0   10.0   87.0 16 40 8   1 3     0   19   36 51     8 2   49 10   87
696676 696676 MN Ramsey 62 school 2700115 4015 Charter Schools COMMUNITY OF PEACE ACADEMY 270011502605 10 COMMUNITY OF PEACE ACADEMY Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2017   grade_7 6.0 16.0 19.0   0.0 20.0     0.0   1.0   37.0 25.0     11.0   2.0         11.0   62.0 6 16 19   0 20     0   1   37 25     11 2     11   62
696685 696685 MN Carver 10 school 2700116 4016 Charter Schools WORLD LEARNER CHARTER SCHOOL 270011602606 10 WORLD LEARNER CHARTER SCHOOL Elementary School (Grades PK-6) Regular School Yes Elementary 01 08 2017   grade_7 27.0 0.0 4.0   0.0 1.0     0.0   0.0   14.0 18.0     1.0   0.0     0.0   5.0   32.0 27 0 4   0 1     0   0   14 18     1 0   0 5   32
696721 696721 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 2017   grade_7 3.0 5.0 19.0   0.0 21.0     0.0   2.0   24.0 26.0     27.0   0.0     44.0   9.0   50.0 3 5 19   0 21     0   2   24 26     27 0   44 9   50
696731 696731 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 2017   grade_7 127.0 10.0 8.0   6.0 2.0     0.0   16.0   89.0 80.0     1.0   3.0     62.0   37.0   169.0 127 10 8   6 2     0   16   89 80     1 3   62 37   169
696748 696748 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 2017   grade_7 0.0 52.0 0.0   0.0 0.0     0.0   0.0   22.0 30.0     5.0   0.0         2.0   52.0 0 52 0   0 0     0   0   22 30     5 0     2   52
696767 696767 MN Hennepin 27 school 2700151 4030 Charter Schools ODYSSEY ACADEMY 270015102946 10 ODYSSEY ACADEMY Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2017   grade_7 5.0 15.0 3.0   0.0 0.0     0.0   2.0   10.0 15.0     2.0   0.0     22.0   3.0   25.0 5 15 3   0 0     0   2   10 15     2 0   22 3   25
696791 696791 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 2017   grade_7 0.0 33.0 10.0   0.0 0.0     0.0   1.0   18.0 26.0     7.0   0.0         10.0   44.0 0 33 10   0 0     0   1   18 26     7 0     10   44
696801 696801 MN Nicollet 52 school 2700174 4050 Charter Schools LAFAYETTE PUBLIC CHARTER SCHOOL 270017403042 10 LAFAYETTE PUBLIC CHARTER SCHOOL Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2017   grade_7 3.0 0.0 0.0   0.0 0.0     0.0   1.0   2.0 2.0         *         *   4.0 3 0 0   0 0     0   1   2 2                 4
696832 696832 MN Beltrami 4 school 2700225 4058 Charter Schools SCHOOLCRAFT LEARNING COMMUNITY CHTR 270022503464 10 SCHOOLCRAFT LEARNING COMMUNITY CHTR Elementary School (Grades PK-6) Regular School Yes Other KG 09 2017   grade_7 13.0 0.0 1.0   3.0 0.0     0.0   1.0   8.0 10.0     0.0   0.0     9.0   3.0   18.0 13 0 1   3 0     0   1   8 10     0 0   9 3   18

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