enrollments

Data source: Big Local News · About: Big Local

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

✎ 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
697316 697316 MN Hennepin 27 school 2700309 4192 Charter Schools BEST ACADEMY 270030904261 10 Best Academy East at Olson Elementary School (Grades PK-6) Regular School Yes Elementary KG 07 2017   grade_7 0.0 30.0 0.0   0.0 0.0     0.0   0.0   14.0 16.0     17.0   2.0     26.0   0.0   30.0 0 30 0   0 0     0   0   14 16     17 2   26 0   30
697463 697463 MN Ramsey 62 school 2700393 4225 Charter Schools Universal Academy Charter School 270039304758 10 Universal Academy Charter School Elementary School (Grades PK-6) Regular School Yes Elementary KG 07 2017   grade_7 0.0 20.0 0.0   0.0 2.0     0.0   0.0   4.0 18.0         0.0         0.0   22.0 0 20 0   0 2     0   0   4 18       0     0   22
697800 697800 MN Chippewa 12 school 2721320 129 Independent Districts and Schools MONTEVIDEO PUBLIC SCHOOL DISTRICT 272132001071 30 MONTEVIDEO MIDDLE Middle School (Grades 5-8) Regular School No Elementary 04 07 2017   grade_7 91.0 0.0 16.0   1.0 0.0     0.0   3.0   57.0 54.0     7.0   0.0     47.0   21.0   111.0 91 0 16   1 0     0   3   57 54     7 0   47 21   111
697920 697920 MN Freeborn 24 school 2702970 241 Independent Districts and Schools ALBERT LEA PUBLIC SCHOOL DISTRICT 270297000078 320 SOUTHWEST MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 07 2017   grade_7 194.0 9.0 54.0   0.0 13.0     0.0   13.0   145.0 138.0         *         *   283.0 194 9 54   0 13     0   13   145 138                 283
697929 697929 MN Goodhue 25 school 2730480 256 Independent Districts and Schools RED WING PUBLIC SCHOOL DISTRICT 273048001298 109 TWIN BLUFF MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 05 07 2017   grade_7 161.0 5.0 18.0   9.0 4.0     1.0   12.0   100.0 110.0     1.0   0.0     51.0   26.0   210.0 161 5 18   9 4     1   12   100 110     1 0   51 26   210
697966 697966 MN Hennepin 27 school 2722920 277 Independent Districts and Schools WESTONKA PUBLIC SCHOOL DISTRICT 272292001109 63 GRANDVIEW MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 05 07 2017   grade_7 195.0 2.0 8.0   0.0 4.0     0.0   6.0   111.0 104.0     2.0   0.0     48.0   37.0   215.0 195 2 8   0 4     0   6   111 104     2 0   48 37   215
698419 698419 MN Morrison 49 school 2733900 2170 Independent Districts and Schools STAPLES-MOTLEY SCHOOL DISTRICT 273390002468 50 MOTLEY-STAPLES MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Elementary 04 07 2017   grade_7 80.0 0.0 4.0   1.0 1.0     0.0   1.0   47.0 40.0     0.0   4.0     43.0   12.0   87.0 80 0 4   1 1     0   1   47 40     0 4   43 12   87
698469 698469 MN Faribault 22 school 2700130 2860 Independent Districts and Schools BLUE EARTH AREA PUBLIC SCHOOL 270013002497 23 BLUE EARTH AREA MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 07 2017   grade_7 77.0 1.0 18.0   0.0 0.0     0.0   0.0   44.0 52.0     0.0   0.0     46.0   12.0   96.0 77 1 18   0 0     0   0   44 52     0 0   46 12   96
700402 700402 MN Goodhue 25 school 2791443 6051 Education Districts Goodhue County Education District 279144304717 610 Pathways Program Grades 6-7 Public Area Learning Center ALC (State approved) Alternative School No Middle 06 07 2017   grade_7 3.0 0.0 1.0   2.0 0.0     0.0   0.0   1.0 5.0         *         *   6.0 3 0 1   2 0     0   0   1 5                 6
700703 700703 MN Ramsey 62 school 2722950 621 Independent Districts and Schools MOUNDS VIEW PUBLIC SCHOOL DISTRICT 272295002998 39 MOUNDS VIEW BRIDGES PROGRAM Special Education Special Education School No Elementary KG 07 2017   grade_7 4.0 0.0 1.0   0.0 0.0     0.0   0.0   4.0 1.0         *         *   5.0 4 0 1   0 0     0   0   4 1                 5
690899 690899 MN Becker 3 school 2728960 25 Independent Districts and Schools PINE POINT PUBLIC SCHOOL DISTRICT 272896000034 70 PINE POINT ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 08 2017   grade_7 0.0 0.0 0.0   3.0 0.0     0.0   0.0   0.0 3.0         *         *   3.0 0 0 0   3 0     0   0   0 3                 3
690986 690986 MN Beltrami 4 school 2730510 38 Independent Districts and Schools RED LAKE PUBLIC SCHOOL DISTRICT 273051001301 20 PONEMAH ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 08 2017   grade_7 0.0 0.0 0.0   7.0 0.0     0.0   0.0   5.0 2.0         *         *   7.0 0 0 0   7 0     0   0   5 2                 7
691021 691021 MN Benton 5 school 2712240 51 Independent Districts and Schools FOLEY PUBLIC SCHOOL DISTRICT 271224002270 30 FOLEY INTERMEDIATE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 04 08 2017   grade_7 145.0 0.0 1.0   0.0 0.0     0.0   2.0   81.0 67.0     0.0   0.0     41.0   23.0   148.0 145 0 1   0 0     0   2   81 67     0 0   41 23   148
691603 691603 MN Dakota 19 school 2711820 192 Independent Districts and Schools FARMINGTON PUBLIC SCHOOL DISTRICT 271182004816 155 Gateway Academy Elementary School (Grades PK-6) Regular School No Elementary 03 08 2017   grade_7 7.0 0.0 2.0   0.0 0.0     0.0   0.0   4.0 5.0         *         *   9.0 7 0 2   0 0     0   0   4 5                 9
692600 692600 MN Hennepin 27 school 2731780 281 Independent Districts and Schools ROBBINSDALE PUBLIC SCHOOL DISTRICT 273178004952 401 The FAIR School - Crystal Elementary School (Grades PK-6) Regular School No Elementary 04 08 2017   grade_7 32.0 50.0 7.0   3.0 5.0     0.0   10.0   47.0 60.0     5.0   0.0     55.0   13.0   107.0 32 50 7   3 5     0   10   47 60     5 0   55 13   107
693432 693432 MN Olmsted 55 school 2731800 535 Independent Districts and Schools ROCHESTER PUBLIC SCHOOL DISTRICT 273180001005 138 LINCOLN K-8 CHOICE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 08 2017   grade_7 31.0 4.0 2.0   0.0 4.0     0.0   2.0   19.0 24.0         0.0         6.0   43.0 31 4 2   0 4     0   2   19 24       0     6   43
693754 693754 MN Ramsey 62 school 2732430 623 Independent Districts and Schools ROSEVILLE PUBLIC SCHOOL DISTRICT 273243001046 73 PARKVIEW CENTER SCHOOL Elementary School (Grades PK-6) Regular School No Elementary PK 08 2017   grade_7 65.0 15.0 3.0   0.0 6.0     0.0   2.0   47.0 44.0         0.0         12.0   91.0 65 15 3   0 6     0   2   47 44       0     12   91
694031 694031 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384004457 489 HAZEL PARK PREPARATORY ACADEMY Elementary School (Grades PK-6) Regular School No Elementary PK 08 2017   grade_7 4.0 40.0 24.0   2.0 32.0     0.0   0.0   56.0 46.0     37.0   6.0     89.0   10.0   102.0 4 40 24   2 32     0   0   56 46     37 6   89 10   102
694054 694054 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384001594 494 CAPITOL HILL MAGNET/RONDO Elementary School (Grades PK-6) Regular School No Elementary 01 08 2017   grade_7 64.0 52.0 13.0   0.0 70.0     0.0   3.0   100.0 102.0     20.0   0.0     101.0   8.0   202.0 64 52 13   0 70     0   3   100 102     20 0   101 8   202
694100 694100 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384001612 528 LINWOOD MONROE ARTS PLUS UPPER Elementary School (Grades PK-6) Regular School No Elementary 04 08 2017   grade_7 49.0 40.0 13.0   0.0 22.0     0.0   6.0   59.0 71.0     29.0   0.0     77.0   27.0   130.0 49 40 13   0 22     0   6   59 71     29 0   77 27   130
694175 694175 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384002303 579 AMERICAN INDIAN MAGNET SCHOOL Elementary School (Grades PK-6) Regular School No Elementary PK 08 2017   grade_7 3.0 9.0 13.0   15.0 23.0     0.0   4.0   30.0 37.0     22.0   1.0     57.0   15.0   67.0 3 9 13   15 23     0   4   30 37     22 1   57 15   67
694697 694697 MN Stearns 73 school 2733510 742 Independent Districts and Schools ST. CLOUD PUBLIC SCHOOL DISTRICT 273351001485 25 KENNEDY COMMUNITY SCHOOL Elementary School (Grades PK-6) Regular School No Elementary PK 08 2017   grade_7 62.0 9.0 4.0   0.0 0.0     0.0   1.0   43.0 33.0         0.0     34.0   13.0   76.0 62 9 4   0 0     0   1   43 33       0   34 13   76
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
696230 696230 MN Lesueur 40 school 2700379 2905 Independent Districts and Schools TRI-CITY UNITED SCHOOL DISTRICT 270037904625 30 MONTGOMERY PRE K-8 Elementary School (Grades PK-6) Regular School No Elementary PK 08 2017   grade_7 73.0 1.0 12.0   0.0 0.0     0.0   4.0   43.0 47.0     4.0   3.0     38.0   9.0   90.0 73 1 12   0 0     0   4   43 47     4 3   38 9   90
696297 696297 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124000942 106 BARTON OPEN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 08 2017   grade_7 55.0 22.0 4.0   2.0 4.0     0.0   1.0   43.0 45.0     13.0   0.0     30.0   6.0   88.0 55 22 4   2 4     0   1   43 45     13 0   30 6   88
696319 696319 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124000969 121 LAKE HARRIET UPPER SCHOOL Elementary School (Grades PK-6) Regular School No Elementary 04 08 2017   grade_7 129.0 7.0 11.0   1.0 9.0     0.0   4.0   82.0 79.0     3.0   0.0     21.0   16.0   161.0 129 7 11   1 9     0   4   82 79     3 0   21 16   161
696340 696340 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124000988 134 LK NOKOMIS COMM-KEEWAYDIN CAMPUS Elementary School (Grades PK-6) Regular School No Elementary 03 08 2017   grade_7 27.0 15.0 14.0   5.0 7.0     0.0   1.0   41.0 28.0     10.0   2.0     42.0   13.0   69.0 27 15 14   5 7     0   1   41 28     10 2   42 13   69
696410 696410 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124001031 160 SEWARD ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 08 2017   grade_7 27.0 50.0 5.0   1.0 6.0     0.0   3.0   46.0 46.0     22.0   2.0     51.0   8.0   92.0 27 50 5   1 6     0   3   46 46     22 2   51 8   92
696449 696449 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124001866 175 FOLWELL ARTS MAGNET Elementary School (Grades PK-6) Regular School No Elementary PK 08 2017   grade_7 10.0 32.0 49.0   3.0 3.0     0.0   3.0   52.0 48.0     44.0   2.0     83.0   16.0   100.0 10 32 49   3 3     0   3   52 48     44 2   83 16   100
696460 696460 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124000986 179 JEFFERSON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 08 2017   grade_7 4.0 28.0 29.0   1.0 0.0     0.0   1.0   36.0 27.0     32.0   9.0         13.0   63.0 4 28 29   1 0     0   1   36 27     32 9     13   63
696479 696479 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124000932 190 ANDERSEN COMMUNITY Elementary School (Grades PK-6) Regular School No Elementary PK 08 2017   grade_7 1.0 40.0 65.0   5.0 2.0     0.0   0.0   65.0 48.0     75.0   11.0         26.0   113.0 1 40 65   5 2     0   0   65 48     75 11     26   113
696490 696490 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124002297 193 SULLIVAN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 08 2017   grade_7 1.0 68.0 4.0   2.0 1.0     0.0   1.0   48.0 29.0     48.0   3.0         9.0   77.0 1 68 4   2 1     0   1   48 29     48 3     9   77
696512 696512 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124004172 225 ANISHINABE ACADEMY Elementary School (Grades PK-6) Regular School No Elementary PK 08 2017   grade_7 1.0 2.0 2.0   23.0 0.0     0.0   2.0   13.0 17.0     0.0   6.0     26.0   5.0   30.0 1 2 2   23 0     0   2   13 17     0 6   26 5   30
696522 696522 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124002144 226 MARCY OPEN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 08 2017   grade_7 41.0 34.0 9.0   3.0 1.0     0.0   3.0   46.0 45.0     12.0   2.0     48.0   13.0   91.0 41 34 9   3 1     0   3   46 45     12 2   48 13   91
696591 696591 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124004239 291 HMONG INTERNATIONAL ACADEMY Elementary School (Grades PK-6) Regular School No Elementary PK 08 2017   grade_7 0.0 26.0 2.0   1.0 32.0     0.0   0.0   28.0 33.0     23.0   4.0     54.0   15.0   61.0 0 26 2   1 32     0   0   28 33     23 4   54 15   61
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
696703 696703 MN Hennepin 27 school 2700117 4017 Charter Schools Minnesota Transitions Charter School 270011703566 17 Banaadir Academy Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2017   grade_7 0.0 31.0 0.0   0.0 0.0     0.0   0.0   14.0 17.0     23.0   *         *   31.0 0 31 0   0 0     0   0   14 17     23           31
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
696808 696808 MN Nicollet 52 school 2700174 4050 Charter Schools LAFAYETTE PUBLIC CHARTER SCHOOL 270017404126 20 STARLAND ELEMENTARY Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2017   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
696842 696842 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 2017   grade_7 21.0 0.0 0.0   0.0 0.0     0.0   0.0   14.0 7.0     0.0   0.0     10.0   5.0   21.0 21 0 0   0 0     0   0   14 7     0 0   10 5   21
696869 696869 MN Hennepin 27 school 2700184 4068 Charter Schools EXCELL ACADEMY CHARTER 270018403137 10 EXCELL ACADEMY CHARTER Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2017   grade_7 0.0 26.0 1.0   0.0 0.0     0.0   0.0   16.0 11.0     5.0   2.0         10.0   27.0 0 26 1   0 0     0   0   16 11     5 2     10   27
696879 696879 MN Ramsey 62 school 2700230 4070 Charter Schools HOPE COMMUNITY ACADEMY 270023003482 10 HOPE COMMUNITY ACADEMY Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2017   grade_7 0.0 3.0 1.0   0.0 45.0     0.0   0.0   19.0 30.0     16.0   0.0     37.0   6.0   49.0 0 3 1   0 45     0   0   19 30     16 0   37 6   49
696937 696937 MN Hennepin 27 school 2700354 4089 Charter Schools NEW CITY SCHOOL 270035404849 20 New City School - East Campus Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2017   grade_7 10.0 6.0 2.0   1.0 1.0     0.0   1.0   12.0 9.0     2.0   0.0     8.0   3.0   21.0 10 6 2   1 1     0   1   12 9     2 0   8 3   21
696970 696970 MN Cook 16 school 2700339 4100 Charter Schools GREAT EXPECTATIONS 270033904177 10 GREAT EXPECTATIONS Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2017   grade_7 10.0 0.0 0.0   0.0 0.0     0.0   0.0   2.0 8.0     0.0   0.0     3.0   3.0   10.0 10 0 0   0 0     0   0   2 8     0 0   3 3   10
696980 696980 MN Ramsey 62 school 2700342 4103 Charter Schools HMONG COLLEGE PREP ACADEMY 270034203700 20 HMONG COLLEGE PREP MIDDLE ACADEMY Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2017   grade_7 0.0 2.0 0.0   0.0 139.0     0.0   0.0   84.0 57.0     31.0   2.0     119.0   14.0   141.0 0 2 0   0 139     0   0   84 57     31 2   119 14   141
697033 697033 MN Hennepin 27 school 2700366 4124 Charter Schools BEACON ACADEMY 270036604110 10 BEACON ACADEMY Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2017   grade_7 27.0 8.0 5.0   0.0 2.0     0.0   4.0   25.0 21.0     1.0   0.0     13.0   7.0   46.0 27 8 5   0 2     0   4   25 21     1 0   13 7   46
697058 697058 MN Olmsted 55 school 2700247 4135 Charter Schools ROCHESTER MATH AND SCIENCE ACADEMY 270024703308 10 ROCHESTER MATH AND SCIENCE ACADEMY Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2017   grade_7 1.0 43.0 0.0   0.0 0.0     0.0   0.0   24.0 20.0     15.0   0.0         2.0   44.0 1 43 0   0 0     0   0   24 20     15 0     2   44
697082 697082 MN Hennepin 27 school 2700273 4139 Charter Schools LOVEWORKS ACADEMY FOR ARTS 270027303575 10 LOVEWORKS ACADEMY FOR ARTS Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2017   grade_7 0.0 21.0 2.0   0.0 0.0     0.0   0.0   11.0 12.0     0.0   3.0     20.0   5.0   23.0 0 21 2   0 0     0   0   11 12     0 3   20 5   23
697092 697092 MN Hennepin 27 school 2700281 4140 Charter Schools YINGHUA ACADEMY 270028103611 10 YINGHUA ACADEMY Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2017   grade_7 30.0 3.0 2.0   1.0 18.0     0.0   0.0   25.0 29.0     0.0   0.0     6.0   5.0   54.0 30 3 2   1 18     0   0   25 29     0 0   6 5   54
697102 697102 MN Stearns 73 school 2700252 4142 Charter Schools Stride Academy Charter School 270025204405 20 Stride Academy K-8 Charter School Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2017   grade_7 30.0 18.0 2.0   0.0 2.0     0.0   0.0   28.0 24.0     7.0   0.0     29.0   14.0   52.0 30 18 2   0 2     0   0   28 24     7 0   29 14   52
697112 697112 MN Hennepin 27 school 2700253 4143 Charter Schools NEW MILLENNIUM ACADEMY CHARTER SCH 270025303311 10 New Millenium Academy Charter School Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2017   grade_7 0.0 1.0 1.0   0.0 49.0     0.0   1.0   22.0 30.0     40.0   0.0         4.0   52.0 0 1 1   0 49     0   1   22 30     40 0     4   52
697137 697137 MN Ramsey 62 school 2700262 4152 Charter Schools Twin Cities German Immersion Charter School 270026203578 10 Twin Cities German Immersion Charter School Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2017   grade_7 32.0 0.0 1.0   0.0 0.0     0.0   2.0   11.0 24.0     1.0   0.0     2.0   5.0   35.0 32 0 1   0 0     0   2   11 24     1 0   2 5   35
697147 697147 MN Ramsey 62 school 2700263 4153 Charter Schools DUGSI ACADEMY 270026303320 10 DUGSI ACADEMY Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2017   grade_7 0.0 39.0 0.0   0.0 0.0     0.0   0.0   19.0 20.0         0.0         0.0   39.0 0 39 0   0 0     0   0   19 20       0     0   39
697185 697185 MN Hennepin 27 school 2700278 4162 Charter Schools SOUTHSIDE FAMILY CHARTER SCHOOL 270027803617 10 SOUTHSIDE FAMILY CHARTER SCHOOL Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2017   grade_7 5.0 4.0 2.0   0.0 0.0     0.0   1.0   2.0 10.0     0.0   0.0     6.0   3.0   12.0 5 4 2   0 0     0   1   2 10     0 0   6 3   12
697230 697230 MN Hennepin 27 school 2700295 4171 Charter Schools NOBLE ACADEMY 270029503727 10 NOBLE ACADEMY Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2017   grade_7 0.0 14.0 0.0   0.0 65.0     0.0   0.0   44.0 35.0     32.0   0.0     53.0   1.0   79.0 0 14 0   0 65     0   0   44 35     32 0   53 1   79
697248 697248 MN Ramsey 62 school 2700304 4181 Charter Schools COMMUNITY SCHOOL OF EXCELLENCE 270030403728 10 COMMUNITY SCHOOL OF EXCELLENCE Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2017   grade_7 0.0 0.0 0.0   0.0 84.0     0.0   0.0   51.0 33.0     51.0   0.0     68.0   9.0   84.0 0 0 0   0 84     0   0   51 33     51 0   68 9   84
697258 697258 MN Scott 70 school 2700311 4184 Charter Schools ASPEN ACADEMY 270031104282 10 ASPEN ACADEMY Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2017   grade_7 21.0 2.0 1.0   0.0 2.0     0.0   0.0   4.0 22.0     1.0   0.0     5.0   4.0   26.0 21 2 1   0 2     0   0   4 22     1 0   5 4   26
697268 697268 MN Anoka 2 school 2700320 4185 Charter Schools DAVINCI ACADEMY 270032004268 10 DAVINCI ACADEMY Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2017   grade_7 32.0 7.0 2.0   1.0 5.0     0.0   3.0   26.0 24.0     0.0   0.0     9.0   10.0   50.0 32 7 2   1 5     0   3   26 24     0 0   9 10   50
697278 697278 MN Anoka 2 school 2700313 4186 Charter Schools GLOBAL ACADEMY 270031304294 10 GLOBAL ACADEMY Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2017   grade_7 11.0 37.0 0.0   0.0 1.0     0.0   0.0   20.0 29.0     5.0   0.0         1.0   49.0 11 37 0   0 1     0   0   20 29     5 0     1   49
697295 697295 MN Carver 10 school 2700319 4188 Charter Schools COLOGNE ACADEMY 270031904320 10 COLOGNE ACADEMY Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2017   grade_7 39.0 2.0 3.0   0.0 1.0     0.0   0.0   25.0 20.0     0.0   0.0     7.0   6.0   45.0 39 2 3   0 1     0   0   25 20     0 0   7 6   45
697333 697333 MN Rice 66 school 2700324 4194 Charter Schools CANNON RIVER STEM SCHOOL 270032404271 10 CANNON RIVER STEM SCHOOL Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2017   grade_7 32.0 2.0 5.0   0.0 0.0     0.0   1.0   27.0 13.0     4.0   0.0     10.0   6.0   40.0 32 2 5   0 0     0   1   27 13     4 0   10 6   40
697380 697380 MN Hennepin 27 school 2700378 4208 Charter Schools NASHA SHKOLA CHARTER SCHOOL 270037804635 10 NASHA SHKOLA CHARTER SCHOOL Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2017   grade_7 7.0 0.0 0.0   0.0 0.0     0.0   0.0   2.0 5.0         *         *   7.0 7 0 0   0 0     0   0   2 5                 7
697409 697409 MN Ramsey 62 school 2700386 4215 Charter Schools Sejong Academy of Minnesota 270038604695 10 Sejong Academy of Minnesota Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2017   grade_7 0.0 1.0 0.0   0.0 8.0     0.0   0.0   3.0 6.0         *         *   9.0 0 1 0   0 8     0   0   3 6                 9
697454 697454 MN Anoka 2 school 2700390 4224 Charter Schools Star of the North Academy Charter School 270039004759 10 Star of the North Academy Charter School Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2017   grade_7 6.0 5.0 0.0   0.0 1.0     0.0   0.0   6.0 6.0     3.0   0.0     10.0   0.0   12.0 6 5 0   0 1     0   0   6 6     3 0   10 0   12
697479 697479 MN Isanti 30 school 2700397 4227 Charter Schools Art and Science Academy 270039704766 10 Art and Science Academy Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2017   grade_7 18.0 2.0 0.0   0.0 0.0     0.0   0.0   10.0 10.0     0.0   0.0     4.0   9.0   20.0 18 2 0   0 0     0   0   10 10     0 0   4 9   20
697489 697489 MN Washington 82 school 2700401 4228 Charter Schools Woodbury Leadership Academy 270040104812 10 Woodbury Leadership Academy Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2017   grade_7 5.0 0.0 2.0   0.0 2.0     0.0   1.0   4.0 6.0     0.0   0.0     0.0   *   10.0 5 0 2   0 2     0   1   4 6     0 0   0     10
697503 697503 MN Ramsey 62 school 2700399 4231 Charter Schools Minnesota Math and Science Academy 270039904788 10 Minnesota Math and Science Academy Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2017   grade_7 1.0 47.0 1.0   0.0 3.0     0.0   0.0   23.0 29.0     27.0   0.0         2.0   52.0 1 47 1   0 3     0   0   23 29     27 0     2   52
697521 697521 MN Ramsey 62 school 2700408 4233 Charter Schools Level Up Academy 270040804800 10 Level Up Academy Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2017   grade_7 6.0 3.0 0.0   0.0 0.0     0.0   0.0   6.0 3.0         *         *   9.0 6 3 0   0 0     0   0   6 3                 9
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
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
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
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
697697 697697 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000119 90 NORTHDALE MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_7 258.0 46.0 43.0   7.0 31.0     0.0   25.0   224.0 186.0     25.0   7.0     186.0   69.0   410.0 258 46 43   7 31     0   25   224 186     25 7   186 69   410
697701 697701 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318002501 193 OAK VIEW MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_7 376.0 14.0 11.0   5.0 13.0     1.0   5.0   228.0 197.0         *         48.0   425.0 376 14 11   5 13     1   5   228 197             48   425
697705 697705 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000122 195 Roosevelt Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_7 324.0 35.0 21.0   0.0 32.0     0.0   28.0   223.0 217.0     12.0   8.0     113.0   52.0   440.0 324 35 21   0 32     0   28   223 217     12 8   113 52   440
697709 697709 MN Anoka 2 school 2708100 12 Independent Districts and Schools CENTENNIAL PUBLIC SCHOOL DISTRICT 270810002784 166 CENTENNIAL MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_7 441.0 13.0 26.0   4.0 22.0     0.0   24.0   264.0 266.0         *         *   530.0 441 13 26   4 22     0   24   264 266                 530
697713 697713 MN Anoka 2 school 2709510 13 Independent Districts and Schools COLUMBIA HEIGHTS PUBLIC SCHOOL DIST 270951000395 17 COLUMBIA ACADEMY Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_7 45.0 90.0 107.0   1.0 8.0     0.0   18.0   131.0 138.0         *         41.0   269.0 45 90 107   1 8     0   18   131 138             41   269
697718 697718 MN Anoka 2 school 2712420 14 Independent Districts and Schools FRIDLEY PUBLIC SCHOOL DISTRICT 271242000610 23 FRIDLEY MIDDLE Middle School (Grades 5-8) Regular School No Middle 05 08 2017   grade_7 98.0 71.0 26.0   1.0 18.0     1.0   21.0   118.0 118.0     18.0   *     148.0   *   236.0 98 71 26   1 18     1   21   118 118     18     148     236
697722 697722 MN Anoka 2 school 2733540 15 Independent Districts and Schools ST. FRANCIS PUBLIC SCHOOL DISTRICT 273354000013 123 ST. FRANCIS MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_7 261.0 5.0 13.0   2.0 10.0     0.0   20.0   162.0 149.0         0.0         50.0   311.0 261 5 13   2 10     0   20   162 149       0     50   311
697726 697726 MN Anoka 2 school 2733330 16 Independent Districts and Schools SPRING LAKE PARK PUBLIC SCHOOLS 273333001466 92 WESTWOOD MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_7 257.0 37.0 68.0   2.0 30.0     0.0   29.0   193.0 230.0     29.0   3.0     169.0   47.0   423.0 257 37 68   2 30     0   29   193 230     29 3   169 47   423
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
697735 697735 MN Beltrami 4 school 2704440 31 Independent Districts and Schools BEMIDJI PUBLIC SCHOOL DISTRICT 270444002031 15 BEMIDJI MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_7 245.0 7.0 8.0   57.0 4.0     0.0   15.0   181.0 155.0         *         *   336.0 245 7 8   57 4     0   15   181 155                 336
697739 697739 MN Beltrami 4 school 2730510 38 Independent Districts and Schools RED LAKE PUBLIC SCHOOL DISTRICT 273051002427 40 Red Lake Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_7 0.0 0.0 0.0   70.0 0.0     0.0   0.0   40.0 30.0     0.0   11.0         14.0   70.0 0 0 0   70 0     0   0   40 30     0 11     14   70
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
697747 697747 MN Nicollet 52 school 2718780 77 Independent Districts and Schools MANKATO PUBLIC SCHOOL DISTRICT 271878002046 190 Dakota Meadows Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_7 256.0 24.0 14.0   1.0 7.0     1.0   11.0   180.0 134.0         0.0         34.0   314.0 256 24 14   1 7     1   11   180 134       0     34   314
697751 697751 MN Blue Earth 7 school 2718780 77 Independent Districts and Schools MANKATO PUBLIC SCHOOL DISTRICT 271878002045 200 Prairie Winds Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_7 212.0 54.0 26.0   1.0 5.0     0.0   13.0   166.0 145.0     26.0   *     132.0   36.0   311.0 212 54 26   1 5     0   13   166 145     26     132 36   311
697756 697756 MN Brown 8 school 2723490 88 Independent Districts and Schools NEW ULM PUBLIC SCHOOL DISTRICT 272349005035 40 NEW ULM MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 05 08 2017   grade_7 140.0 2.0 8.0   0.0 0.0     0.0   0.0   68.0 82.0     1.0   0.0     46.0   22.0   150.0 140 2 8   0 0     0   0   68 82     1 0   46 22   150
697760 697760 MN Carlton 9 school 2709420 94 Independent Districts and Schools CLOQUET PUBLIC SCHOOL DISTRICT 270942000381 201 CLOQUET MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_7 143.0 1.0 2.0   23.0 2.0     0.0   27.0   100.0 98.0         *         *   198.0 143 1 2   23 2     0   27   100 98                 198
697764 697764 MN Carver 10 school 2723910 108 Independent Districts and Schools CENTRAL PUBLIC SCHOOL DISTRICT 272391002507 30 CENTRAL MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_7 68.0 1.0 2.0   0.0 1.0     0.0   2.0   32.0 42.0     2.0   0.0     15.0   7.0   74.0 68 1 2   0 1     0   2   32 42     2 0   15 7   74
697768 697768 MN Carver 10 school 2741460 110 Independent Districts and Schools WACONIA PUBLIC SCHOOL DISTRICT 274146003066 220 CLEARWATER MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_7 266.0 3.0 11.0   1.0 2.0     0.0   4.0   154.0 133.0     4.0   1.0     24.0   38.0   287.0 266 3 11   1 2     0   4   154 133     4 1   24 38   287
697772 697772 MN Carver 10 school 2741910 111 Independent Districts and Schools WATERTOWN-MAYER PUBLIC SCHOOL DIST. 274191000024 841 WATERTOWN-MAYER MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_7 111.0 1.0 3.0   0.0 0.0     0.0   4.0   63.0 56.0     0.0   0.0     31.0   16.0   119.0 111 1 3   0 0     0   4   63 56     0 0   31 16   119

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