Data source: Big Local News · About: Big Local

697 rows where grade = "grade_6", state = "MN" and year = 2019 sorted by school

View and edit SQL

year

  • 2019 · 697

grade

  • grade_6 · 697
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
1955411 MN Carver 10 school 2708190 112 Independent Districts and Schools EASTERN CARVER COUNTY PUBLIC SCHOOL 270819004622 66 112 ALC MIDDLE SCHOOL Public Area Learning Center ALC (State approved) Alternative School No Middle 06 08 2019   grade_6 62.0 12.0 35.0   1.0 2.0     0.0   6.0   58.0 60.0     15.0   1.0     61.0   45.0   118.0 62 12 35   1 2     0   6   58 60     15 1   61 45   118
1956663 MN Dakota 19 school 2700026 917 Intermediate Districts and Schools INTERMEDIATE SCHOOL DISTRICT 917 270002603897 500 917 DASH Special Education Special Education School No Other PK 12 2019   grade_6 0.0 1.0 0.0   0.0 0.0     0.0   0.0   0.0 1.0     *   *         *   1.0 0 1 0   0 0     0   0   0 1                 1
1956614 MN Dakota 19 school 2700026 917 Intermediate Districts and Schools INTERMEDIATE SCHOOL DISTRICT 917 270002602121 51 917 INTRA-DAKOTA EDUCATIONAL ALT Special Education Special Education School No Other KG 12 2019   grade_6 2.0 1.0 0.0   0.0 0.0     0.0   0.0   2.0 1.0     *   *         *   3.0 2 1 0   0 0     0   0   2 1                 3
1956640 MN Dakota 19 school 2700026 917 Intermediate Districts and Schools INTERMEDIATE SCHOOL DISTRICT 917 270002602125 61 917 PACES Special Education Special Education School No Other KG 12 2019   grade_6 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
1956653 MN Dakota 19 school 2700026 917 Intermediate Districts and Schools INTERMEDIATE SCHOOL DISTRICT 917 270002604218 400 917 SUN Special Education Special Education School No Other KG 12 2019   grade_6 4.0 2.0 1.0   0.0 0.0     0.0   0.0   4.0 3.0     *   *         *   7.0 4 2 1   0 0     0   0   4 3                 7
1953807 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_6 124.0 1.0 3.0   0.0 0.0     0.0   10.0   76.0 62.0     0.0   0.0     40.0   27.0   138.0 124 1 3   0 0     0   10   76 62     0 0   40 27   138
1951347 MN Meeker 47 school 2700106 2396 Independent Districts and Schools A.C.G.C. Public School District 270010603647 150 ACGC ELEMENTARY GRADES 5 AND 6 Elementary School (Grades PK-6) Regular School No Middle 05 06 2019   grade_6 61.0 1.0 6.0   0.0 0.0     0.0   0.0   38.0 30.0     2.0   0.0     35.0   15.0   68.0 61 1 6   0 0     0   0   38 30     2 0   35 15   68
1956110 MN Hennepin 27 school 2725200 279 Independent Districts and Schools OSSEO PUBLIC SCHOOL DISTRICT 272520003593 45 ACHIEVE Special Education Special Education School No Other KG 12 2019   grade_6 1.0 0.0 0.0   0.0 0.0     0.0   0.0   1.0 0.0     *   *         *   1.0 1 0 0   0 0     0   0   1 0                 1
1952200 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_6 5.0 8.0 17.0   0.0 16.0     0.0   1.0   26.0 21.0     14.0   0.0     39.0   5.0   47.0 5 8 17   0 16     0   1   26 21     14 0   39 5   47
1945575 MN Norman 54 school 2700126 2854 Independent Districts and Schools ADA-BORUP PUBLIC SCHOOL DISTRICT 270012600051 30 ADA-BORUP SECONDARY Secondary School (Grades 7-12) Regular School No High 06 12 2019   grade_6 47.0 1.0 5.0   0.0 0.0     0.0   6.0   29.0 30.0     1.0   0.0     27.0   8.0   59.0 47 1 5   0 0     0   6   29 30     1 0   27 8   59
1953674 MN Nobles 53 school 2702730 511 Independent Districts and Schools ADRIAN PUBLIC SCHOOL DISTRICT 270273003076 15 ADRIAN MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_6 26.0 0.0 5.0   0.0 2.0     0.0   2.0   16.0 19.0     2.0   0.0     18.0   7.0   35.0 26 0 5   0 2     0   2   16 19     2 0   18 7   35
1954125 MN Ramsey 62 school 2700186 4074 Charter Schools AFSA HIGH SCHOOL 270018604854 20 AFSA Middle School Middle School (Grades 5-8) Regular School Yes Middle 05 06 2019   grade_6 18.0 2.0 2.0   0.0 1.0     0.0   0.0   9.0 14.0     0.0   0.0     8.0   3.0   23.0 18 2 2   0 1     0   0   9 14     0 0   8 3   23
1947410 MN Freeborn 24 school 2703030 242 Independent Districts and Schools ALDEN-CONGER PUBLIC SCHOOL DISTRICT 270303000079 2 ALDEN-CONGER ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   grade_6 34.0 0.0 2.0   0.0 0.0     0.0   2.0   22.0 16.0     0.0   1.0     11.0   9.0   38.0 34 0 2   0 0     0   2   22 16     0 1   11 9   38
1947468 MN Hennepin 27 school 2714260 270 Independent Districts and Schools HOPKINS PUBLIC SCHOOL DISTRICT 271426001886 561 ALICE SMITH ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   grade_6 44.0 20.0 14.0   0.0 3.0     0.0   6.0   46.0 41.0     7.0   0.0     43.0   15.0   87.0 44 20 14   0 3     0   6   46 41     7 0   43 15   87
1949670 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 2019   grade_6 3.0 16.0 19.0   10.0 20.0     0.0   8.0   41.0 35.0     18.0   3.0     59.0   15.0   76.0 3 16 19   10 20     0   8   41 35     18 3   59 15   76
1951956 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 2019   grade_6 2.0 33.0 63.0   3.0 2.0     0.0   1.0   51.0 53.0     53.0   8.0         24.0   104.0 2 33 63   3 2     0   1   51 53     53 8     24   104
1949792 MN Lake of the Woods 39 school 2741850 690 Independent Districts and Schools WARROAD PUBLIC SCHOOL DISTRICT 274185002456 20 ANGLE INLET ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 06 2019   grade_6 1.0 0.0 0.0   0.0 0.0     0.0   0.0   0.0 1.0     *   *         *   1.0 1 0 0   0 0     0   0   0 1                 1
1953939 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_6 150.0 2.0 2.0   0.0 1.0     0.0   4.0   77.0 82.0     0.0   1.0     41.0   34.0   159.0 150 2 2   0 1     0   4   77 82     0 1   41 34   159
1953229 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_6 437.0 72.0 23.0   3.0 21.0     2.0   28.0   284.0 302.0     9.0   12.0     215.0   114.0   586.0 437 72 23   3 21     2   28   284 302     9 12   215 114   586
1954079 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124000936 300 ANTHONY MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_6 142.0 71.0 33.0   1.0 9.0     1.0   9.0   130.0 136.0     22.0   0.0     102.0   30.0   266.0 142 71 33   1 9     1   9   130 136     22 0   102 30   266
1954083 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124000937 309 ANWATIN MIDDLE COM & SPANISH D I Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_6 33.0 72.0 63.0   3.0 16.0     0.0   7.0   94.0 100.0     41.0   5.0     123.0   33.0   194.0 33 72 63   3 16     0   7   94 100     41 5   123 33   194
1945766 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_6 18.0 0.0 0.0   0.0 0.0     0.0   0.0   11.0 7.0     0.0   0.0     1.0   5.0   18.0 18 0 0   0 0     0   0   11 7     0 0   1 5   18
1951549 MN Marshall 45 school 2700127 2856 Independent Districts and Schools STEPHEN-ARGYLE CENTRAL SCHOOLS 270012700131 20 ARGYLE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   grade_6 16.0 1.0 1.0   0.0 0.0     0.0   1.0   5.0 14.0     0.0   0.0     8.0   3.0   19.0 16 1 1   0 0     0   1   5 14     0 0   8 3   19
1947451 MN Grant 26 school 2703300 261 Independent Districts and Schools ASHBY PUBLIC SCHOOL DISTRICT 270330000136 10 ASHBY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   grade_6 24.0 0.0 0.0   0.0 0.0     0.0   0.0   7.0 17.0     0.0   0.0     9.0   7.0   24.0 24 0 0   0 0     0   0   7 17     0 0   9 7   24
1952728 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 2019   grade_6 34.0 5.0 1.0   0.0 2.0     0.0   0.0   25.0 17.0     0.0   0.0     10.0   8.0   42.0 34 5 1   0 2     0   0   25 17     0 0   10 8   42
1954120 MN Hennepin 27 school 2700220 4067 Charter Schools AURORA CHARTER SCHOOL 270022004420 20 AURORA MIDDLE SCHOOL Middle School (Grades 5-8) Regular School Yes Middle 05 08 2019   grade_6 0.0 0.0 47.0   0.0 0.0     0.0   0.0   18.0 29.0     20.0   0.0     42.0   4.0   47.0 0 0 47   0 0     0   0   18 29     20 0   42 4   47
1952358 MN Ramsey 62 school 2700185 4073 Charter Schools Academia Cesar Chavez Charter School 270018503138 10 Academia Cesar Chavez Charter School Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2019   grade_6 3.0 0.0 49.0   0.0 1.0     0.0   0.0   29.0 24.0     21.0   2.0     47.0   7.0   53.0 3 0 49   0 1     0   0   29 24     21 2   47 7   53
1952917 MN Hennepin 27 school 2700394 4220 Charter Schools Agamim Classical Academy 270039404751 10 Agamim Classical Academy Elementary School (Grades PK-6) Regular School Yes Elementary KG 07 2019   grade_6 17.0 10.0 3.0   0.0 3.0     0.0   3.0   18.0 18.0     4.0   0.0     12.0   6.0   36.0 17 10 3   0 3     0   3   18 18     4 0   12 6   36
1953876 MN Stearns 73 school 2702930 745 Independent Districts and Schools ALBANY PUBLIC SCHOOL DISTRICT 270293000063 50 Albany Area Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_6 149.0 0.0 4.0   0.0 0.0     0.0   2.0   79.0 76.0     0.0   0.0     19.0   26.0   155.0 149 0 4   0 0     0   2   79 76     0 0   19 26   155
1955472 MN Freeborn 24 school 2702970 241 Independent Districts and Schools ALBERT LEA PUBLIC SCHOOL DISTRICT 270297002228 350 Albert Lea Area Learning Center Public Area Learning Center ALC (State approved) Alternative School No High 06 12 2019   grade_6 3.0 0.0 1.0   0.0 0.0     0.0   0.0   2.0 2.0     *   *         *   4.0 3 0 1   0 0     0   0   2 2                 4
1956852 MN Rice 66 school 2700424 6094 Special Education Cooperatives Cannon Valley Special Education Cooperative 270042404938 10 Alexander Learning Academy Special Education Special Education School No Other KG 12 2019   grade_6 1.0 1.0 2.0   0.0 0.0     0.0   1.0   4.0 1.0     *   *         *   5.0 1 1 2   0 0     0   1   4 1                 5
1957227 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318002504 440 Alexandra House Homeless Student Program, Title I Alternative School No Other KG 12 2019   grade_6 0.0 1.0 0.0   0.0 0.0     0.0   0.0   0.0 1.0     *   *         *   1.0 0 1 0   0 0     0   0   0 1                 1
1954197 MN Isanti 30 school 2700397 4227 Charter Schools Art and Science Academy 270039705095 30 Art & Science Academy Middle School Middle School (Grades 5-8) Regular School Yes Middle 05 08 2019   grade_6 45.0 0.0 0.0   0.0 0.0     0.0   3.0   27.0 21.0     0.0   0.0     16.0   11.0   48.0 45 0 0   0 0     0   3   27 21     0 0   16 11   48
1945677 MN Ramsey 62 school 2702264 916 Intermediate Districts and Schools NORTHEAST METRO 916 270226404818 29 Assessment Center Sec Secondary School (Grades 7-12) Regular School No Other KG 12 2019   grade_6 0.0 1.0 0.0   0.0 0.0     0.0   0.0   1.0 0.0     *   *         *   1.0 0 1 0   0 0     0   0   1 0                 1
1953052 MN Stearns 73 school 2700430 4250 Charter Schools Athlos Academy of Saint Cloud 270043004959 10 Athlos Academy of Saint Cloud Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2019   grade_6 26.0 30.0 4.0   0.0 0.0     1.0   3.0   33.0 31.0     13.0   0.0     44.0   10.0   64.0 26 30 4   0 0     1   3   33 31     13 0   44 10   64
1952146 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_6 6.0 58.0 13.0   1.0 3.0     0.0   12.0   54.0 39.0     2.0   2.0     68.0   7.0   93.0 6 58 13   1 3     0   12   54 39     2 2   68 7   93
1954127 MN Ramsey 62 school 2700187 4075 Charter Schools AVALON SCHOOL 270018704664 20 Avalon Middle School Middle School (Grades 5-8) Regular School Yes Middle 06 08 2019   grade_6 19.0 0.0 3.0   0.0 0.0     0.0   1.0   16.0 7.0     0.0   2.0     7.0   10.0   23.0 19 0 3   0 0     0   1   16 7     0 2   7 10   23
1951033 MN Saint Louis 69 school 2700008 2142 Independent Districts and Schools ST. LOUIS COUNTY SCHOOL DISTRICT 270000800158 10 BABBITT ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   grade_6 13.0 0.0 1.0   0.0 0.0     0.0   1.0   6.0 9.0     *   0.0         *   15.0 13 0 1   0 0     0   1   6 9       0         15
1949766 MN Roseau 68 school 2703540 676 Independent Districts and Schools BADGER PUBLIC SCHOOL DISTRICT 270354000162 10 BADGER ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   grade_6 19.0 0.0 0.0   0.0 0.0     0.0   0.0   11.0 8.0     0.0   0.0     5.0   2.0   19.0 19 0 0   0 0     0   0   11 8     0 0   5 2   19
1946774 MN Clearwater 15 school 2703570 162 Independent Districts and Schools BAGLEY PUBLIC SCHOOL DISTRICT 270357000164 10 BAGLEY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   grade_6 67.0 1.0 0.0   16.0 1.0     0.0   8.0   41.0 52.0     0.0   0.0     39.0   14.0   93.0 67 1 0   16 1     0   8   41 52     0 0   39 14   93
1946725 MN Clay 14 school 2703660 146 Independent Districts and Schools Barnesville Public School District 270366000169 10 BARNESVILLE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 06 2019   grade_6 65.0 0.0 2.0   0.0 0.0     0.0   1.0   34.0 34.0     0.0   0.0     12.0   7.0   68.0 65 0 2   0 0     0   1   34 34     0 0   12 7   68
1946510 MN Carlton 9 school 2703690 91 Independent Districts and Schools BARNUM PUBLIC SCHOOL DISTRICT 270369000171 1 BARNUM ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   grade_6 49.0 0.0 0.0   0.0 0.0     0.0   3.0   28.0 24.0     0.0   0.0     19.0   10.0   52.0 49 0 0   0 0     0   3   28 24     0 0   19 10   52
1951772 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 2019   grade_6 35.0 31.0 4.0   0.0 0.0     0.0   7.0   43.0 34.0     15.0   0.0     40.0   7.0   77.0 35 31 4   0 0     0   7   43 34     15 0   40 7   77
1953765 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384001556 310 BATTLE CREEK MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_6 15.0 89.0 27.0   2.0 103.0     0.0   17.0   144.0 109.0     81.0   10.0     206.0   45.0   253.0 15 89 27   2 103     0   17   144 109     81 10   206 45   253
1948908 MN Otter Tail 56 school 2703750 542 Independent Districts and Schools BATTLE LAKE PUBLIC SCHOOL DISTRICT 270375000175 10 BATTLE LAKE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 06 2019   grade_6 23.0 0.0 3.0   0.0 0.0     0.0   2.0   14.0 14.0     1.0   0.0     10.0   5.0   28.0 23 0 3   0 0     0   2   14 14     1 0   10 5   28
1952505 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 2019   grade_6 44.0 19.0 7.0   0.0 2.0     0.0   5.0   29.0 48.0     3.0   0.0     27.0   9.0   77.0 44 19 7   0 2     0   5   29 48     3 0   27 9   77
1953844 MN Sherburne 71 school 2703870 726 Independent Districts and Schools BECKER PUBLIC SCHOOL DISTRICT 270387002556 30 BECKER MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_6 227.0 0.0 2.0   1.0 3.0     0.0   4.0   120.0 117.0     0.0   1.0     48.0   24.0   237.0 227 0 2   1 3     0   4   120 117     0 1   48 24   237
1951330 MN Stearns 73 school 2700105 2364 Independent Districts and Schools Belgrade-Brooten-Elrosa Public School District 270010500182 1 BELGRADE-BROOTEN-ELROSA ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   grade_6 60.0 0.0 5.0   0.0 0.0     0.0   0.0   38.0 27.0     2.0   1.0     22.0   10.0   65.0 60 0 5   0 0     0   0   38 27     2 1   22 10   65
1953280 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 2019   grade_6 260.0 5.0 9.0   62.0 2.0     1.0   41.0   195.0 185.0     *   *     188.0   67.0   380.0 260 5 9   62 2     1   41   195 185           188 67   380
1957172 MN Stearns 73 school 2700071 6383 Education Districts BENTON-STEARNS ED. DISTRICT 270007102403 10 BENTON-STEARNS ED. DISTRICT Special Education Special Education School No Other PK 12 2019   grade_6 2.0 0.0 0.0   0.0 0.0     0.0   1.0   3.0 0.0     *   *         *   3.0 2 0 0   0 0     0   1   3 0                 3
1957182 MN Stearns 73 school 2700071 6383 Education Districts BENTON-STEARNS ED. DISTRICT 270007104581 40 BENTON-STEARNS EDUCATION CENTER Special Education Special Education School No High 06 12 2019   grade_6 1.0 0.0 0.0   0.0 0.0     0.0   0.0   1.0 0.0     *   *         *   1.0 1 0 0   0 0     0   0   1 0                 1
1950417 MN Todd 77 school 2705430 786 Independent Districts and Schools Bertha-Hewitt Public School District 270543000203 10 BERTHA ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   grade_6 38.0 0.0 1.0   0.0 0.0     0.0   4.0   26.0 17.0     0.0   *     25.0   12.0   43.0 38 0 1   0 0     0   4   26 17     0     25 12   43
1952788 MN Hennepin 27 school 2700309 4192 Charter Schools BEST ACADEMY 270030904261 10 BEST ACADEMY Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2019   grade_6 0.0 81.0 0.0   0.0 0.0     0.0   2.0   51.0 32.0     22.0   7.0         11.0   83.0 0 81 0   0 0     0   2   51 32     22 7     11   83
1953848 MN Sherburne 71 school 2705460 727 Independent Districts and Schools BIG LAKE PUBLIC SCHOOL DISTRICT 270546002462 30 BIG LAKE MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_6 222.0 8.0 13.0   0.0 5.0     0.0   8.0   125.0 131.0     2.0   0.0     67.0   31.0   256.0 222 8 13   0 5     0   8   125 131     2 0   67 31   256
1948223 MN Itasca 31 school 2713170 318 Independent Districts and Schools GRAND RAPIDS PUBLIC SCHOOL DISTRICT 271317000882 115 BIGFORK ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   grade_6 23.0 1.0 1.0   1.0 0.0     0.0   1.0   9.0 18.0     *   0.0         *   27.0 23 1 1   1 0     0   1   9 18       0         27
1953416 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239002437 32 BLACK HAWK MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_6 148.0 53.0 33.0   0.0 27.0     0.0   21.0   126.0 156.0     15.0   *     90.0   53.0   282.0 148 53 33   0 27     0   21   126 156     15     90 53   282
1946320 MN Beltrami 4 school 2705730 32 Independent Districts and Schools BLACKDUCK PUBLIC SCHOOL DISTRICT 270573000212 10 BLACKDUCK ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   grade_6 39.0 0.0 1.0   7.0 0.0     0.0   1.0   31.0 17.0     0.0   0.0     28.0   11.0   48.0 39 0 1   7 0     0   1   31 17     0 0   28 11   48
1950327 MN Steele 74 school 2705760 756 Independent Districts and Schools BLOOMING PRAIRIE PUBLIC SCHOOL DIST 270576000214 10 BLOOMING PRAIRIE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   grade_6 52.0 0.0 6.0   0.0 0.0     0.0   2.0   32.0 28.0     0.0   0.0     18.0   5.0   60.0 52 0 6   0 0     0   2   32 28     0 0   18 5   60
1954050 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 2019   grade_6 66.0 3.0 15.0   0.0 0.0     0.0   0.0   42.0 42.0     2.0   0.0     48.0   11.0   84.0 66 3 15   0 0     0   0   42 42     2 0   48 11   84
1950461 MN Wabasha 79 school 2717520 813 Independent Districts and Schools LAKE CITY PUBLIC SCHOOL DISTRICT 271752000803 10 BLUFF VIEW ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   grade_6 103.0 1.0 4.0   0.0 0.0     0.0   2.0   56.0 54.0     1.0   0.0     27.0   13.0   110.0 103 1 4   0 0     0   2   56 54     1 0   27 13   110
1952109 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_6 27.0 0.0 1.0   0.0 0.0     0.0   1.0   12.0 17.0     0.0   0.0     5.0   2.0   29.0 27 0 1   0 0     0   1   12 17     0 0   5 2   29
1951386 MN Renville 65 school 2705660 2534 Independent Districts and Schools Bird Island-Olivia-Lake Lillian Public School District 270566000144 15 BOLD-BIRD ISLAND ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 06 2019   grade_6 57.0 0.0 3.0   0.0 0.0     0.0   0.0   31.0 29.0     1.0   0.0     21.0   9.0   60.0 57 0 3   0 0     0   0   31 29     1 0   21 9   60
1948188 MN Isanti 30 school 2706060 314 Independent Districts and Schools BRAHAM PUBLIC SCHOOL DISTRICT 270606000245 2 BRAHAM ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   grade_6 52.0 0.0 0.0   0.0 0.0     0.0   2.0   26.0 28.0     0.0   0.0     21.0   11.0   54.0 52 0 0   0 0     0   2   26 28     0 0   21 11   54
1950761 MN Wilkin 84 school 2706150 846 Independent Districts and Schools BRECKENRIDGE PUBLIC SCHOOL DISTRICT 270615000266 10 BRECKENRIDGE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   grade_6 28.0 1.0 2.0   2.0 1.0     0.0   7.0   16.0 25.0     0.0   0.0     19.0   13.0   41.0 28 1 2   2 1     0   7   16 25     0 0   19 13   41
1956261 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384002189 430 BRIDGE VIEW SPECIAL EDUCATION Special Education Special Education School No Other KG 12 2019   grade_6 1.0 3.0 0.0   0.0 1.0     0.0   0.0   4.0 1.0     *   *         *   5.0 1 3 0   0 1     0   0   4 1                 5
1952775 MN Hennepin 27 school 2700316 4189 Charter Schools BRIGHT WATER ELEMENTARY 270031604319 10 BRIGHT WATER ELEMENTARY Elementary School (Grades PK-6) Regular School Yes Elementary KG 06 2019   grade_6 4.0 9.0 2.0   0.0 0.0     0.0   1.0   10.0 6.0     0.0   1.0     6.0   5.0   16.0 4 9 2   0 0     0   1   10 6     0 1   6 5   16
1949222 MN Ramsey 62 school 2732430 623 Independent Districts and Schools ROSEVILLE PUBLIC SCHOOL DISTRICT 273243001386 721 BRIMHALL ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 06 2019   grade_6 35.0 11.0 10.0   0.0 12.0     0.0   6.0   38.0 36.0     4.0   1.0     25.0   4.0   74.0 35 11 10   0 12     0   6   38 36     4 1   25 4   74
1950426 MN Todd 77 school 2706300 787 Independent Districts and Schools BROWERVILLE PUBLIC SCHOOL DISTRICT 270630000277 10 BROWERVILLE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   grade_6 44.0 1.0 0.0   0.0 0.0     0.0   0.0   27.0 18.0     0.0   0.0     22.0   11.0   45.0 44 1 0   0 0     0   0   27 18     0 0   22 11   45
1953894 MN Traverse 78 school 2707110 801 Independent Districts and Schools BROWNS VALLEY PUBLIC SCHOOL DIST. 270711000280 20 BROWNS VALLEY MIDDLE Middle School (Grades 5-8) Regular School No Middle 05 08 2019   grade_6 7.0 0.0 0.0   13.0 0.0     0.0   0.0   13.0 7.0     0.0   0.0     13.0   6.0   20.0 7 0 0   13 0     0   0   13 7     0 0   13 6   20
1953943 MN Wright 86 school 2707200 877 Independent Districts and Schools BUFFALO-HANOVER-MONTROSE PUBLIC SCH 270720000284 30 BUFFALO COMMUNITY MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_6 418.0 6.0 22.0   1.0 3.0     2.0   14.0   236.0 230.0     8.0   0.0     109.0   56.0   466.0 418 6 22   1 3     2   14   236 230     8 0   109 56   466
1945388 MN Renville 65 school 2700023 2159 Independent Districts and Schools BUFFALO LK-HECTOR-STEWART PUBLIC SC 270002300704 20 BUFFALO LAKE-HECTOR SECONDARY Secondary School (Grades 7-12) Regular School No High 06 12 2019   grade_6 31.0 0.0 6.0   1.0 0.0     0.0   2.0   21.0 19.0     1.0   1.0     17.0   8.0   40.0 31 0 6   1 0     0   2   21 19     1 1   17 8   40
1955446 MN Dakota 19 school 2707290 191 Independent Districts and Schools BURNSVILLE PUBLIC SCHOOL DISTRICT 270729002640 314 BURNSVILLE AREA LEARNING CENTER Public Area Learning Center ALC (State approved) Alternative School No High 06 12 2019   grade_6 140.0 136.0 107.0   4.0 27.0     1.0   30.0   243.0 202.0     90.0   6.0     278.0   95.0   445.0 140 136 107   4 27     1   30   243 202     90 6   278 95   445
1950732 MN Watonwan 83 school 2707320 836 Independent Districts and Schools BUTTERFIELD PUBLIC SCHOOL DISTRICT 270732000304 10 BUTTERFIELD ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   grade_6 4.0 0.0 14.0   0.0 0.0     0.0   0.0   10.0 8.0     6.0   0.0     13.0   5.0   18.0 4 0 14   0 0     0   0   10 8     6 0   13 5   18
1953683 MN Olmsted 55 school 2707350 531 Independent Districts and Schools BYRON PUBLIC SCHOOL DISTRICT 270735000981 30 BYRON MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_6 157.0 2.0 7.0   0.0 2.0     1.0   5.0   105.0 69.0     0.0   0.0     22.0   16.0   174.0 157 2 7   0 2     1   5   105 69     0 0   22 16   174
1952183 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 PK 06 2019   grade_6 0.0 23.0 0.0   0.0 0.0     0.0   0.0   14.0 9.0     16.0   0.0         2.0   23.0 0 23 0   0 0     0   0   14 9     16 0     2   23
1952191 MN Hennepin 27 school 2700117 4017 Charter Schools Minnesota Transitions Charter School 270011704989 21 Banaadir South Elementary School (Grades PK-6) Regular School Yes Elementary KG 06 2019   grade_6 0.0 6.0 0.0   0.0 0.0     0.0   0.0   4.0 2.0     *   *         *   6.0 0 6 0   0 0     0   0   4 2                 6
1952962 MN Hennepin 27 school 2700396 4226 Charter Schools Bdote Learning Center 270039604763 10 Bdote Learning Center Elementary School (Grades PK-6) Regular School Yes Elementary KG 07 2019   grade_6 0.0 0.0 2.0   7.0 0.0     0.0   1.0   5.0 5.0     0.0   3.0         3.0   10.0 0 0 2   7 0     0   1   5 5     0 3     3   10
1956566 MN Ramsey 62 school 2702264 916 Intermediate Districts and Schools NORTHEAST METRO 916 270226402064 15 Bellaire Education Center Special Education Special Education School No High 05 12 2019   grade_6 9.0 4.0 0.0   0.0 0.0     0.0   1.0   14.0 0.0     0.0   0.0     8.0   *   14.0 9 4 0   0 0     0   1   14 0     0 0   8     14
1954070 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_6 37.0 1.0 0.0   0.0 0.0     0.0   2.0   18.0 22.0     0.0   1.0     12.0   2.0   40.0 37 1 0   0 0     0   2   18 22     0 1   12 2   40
1953571 MN Hennepin 27 school 2706240 286 Independent Districts and Schools BROOKLYN CENTER SCHOOL DISTRICT 270624005130 11 Brooklyn Center Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_6 12.0 70.0 28.0   2.0 25.0     0.0   6.0   74.0 69.0     *   *         *   143.0 12 70 28   2 25     0   6   74 69                 143
1953519 MN Hennepin 27 school 2725200 279 Independent Districts and Schools OSSEO PUBLIC SCHOOL DISTRICT 272520001208 33 Brooklyn Middle School, a Science, Technology, Engineering, Art and Math School Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_6 58.0 133.0 53.0   4.0 94.0     0.0   35.0   196.0 181.0     26.0   *     226.0   49.0   377.0 58 133 53   4 94     0   35   196 181     26     226 49   377
1946717 MN Chisago 13 school 2732550 139 Independent Districts and Schools RUSH CITY PUBLIC SCHOOL DISTRICT 273255001405 10 C.E. JACOBSON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   grade_6 63.0 0.0 2.0   2.0 0.0     0.0   4.0   40.0 31.0     0.0   0.0     31.0   8.0   71.0 63 0 2   2 0     0   4   40 31     0 0   31 8   71
1953575 MN Houston 28 school 2707380 299 Independent Districts and Schools CALEDONIA PUBLIC SCHOOL DISTRICT 270738000310 20 CALEDONIA MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_6 60.0 0.0 1.0   0.0 0.0     0.0   2.0   37.0 26.0     0.0   0.0     19.0   14.0   63.0 60 0 1   0 0     0   2   37 26     0 0   19 14   63
1953970 MN Isanti 30 school 2707410 911 Independent Districts and Schools CAMBRIDGE-ISANTI PUBLIC SCHOOL DIST 270741003671 301 CAMBRIDGE MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_6 179.0 3.0 3.0   1.0 3.0     0.0   11.0   110.0 90.0     *   *     59.0   26.0   200.0 179 3 3   1 3     0   11   110 90           59 26   200
1950781 MN Wilkin 84 school 2707450 852 Independent Districts and Schools CAMPBELL-TINTAH PUBLIC SCHOOL DIST. 270745000319 10 CAMPBELL-TINTAH ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   grade_6 10.0 0.0 0.0   0.0 0.0     0.0   0.0   7.0 3.0     0.0   0.0     4.0   1.0   10.0 10 0 0   0 0     0   0   7 3     0 0   4 1   10
1950933 MN Yellow Medicine 87 school 2707470 891 Independent Districts and Schools CANBY PUBLIC SCHOOL DISTRICT 270747000321 20 CANBY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   grade_6 39.0 1.0 2.0   0.0 1.0     0.0   1.0   20.0 24.0     1.0   0.0     16.0   6.0   44.0 39 1 2   0 1     0   1   20 24     1 0   16 6   44
1952806 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 2019   grade_6 30.0 2.0 5.0   0.0 0.0     0.0   1.0   25.0 13.0     0.0   0.0     12.0   7.0   38.0 30 2 5   0 0     0   1   25 13     0 0   12 7   38
1949533 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 2019   grade_6 75.0 53.0 12.0   0.0 58.0     1.0   12.0   122.0 89.0     15.0   1.0     100.0   14.0   211.0 75 53 12   0 58     1   12   122 89     15 1   100 14   211
1956803 MN Mower 50 school 2700327 6083 Special Education Cooperatives SOUTHERN MN EDUCATION CONSORTIUM 270032705011 40 CARDS Program Special Education Special Education School No Other PK 12 2019   grade_6 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
1957631 MN Olmsted 55 school 2731800 535 Independent Districts and Schools ROCHESTER PUBLIC SCHOOL DISTRICT 273180001013 216 CARE & TREATMENT HOSPITAL/HOMEBOUND Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No Other KG 12 2019   grade_6 1.0 0.0 0.0   0.0 0.0     0.0   0.0   0.0 1.0     *   *         *   1.0 1 0 0   0 0     0   0   0 1                 1
1944445 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_6 25.0 0.0 1.0   9.0 0.0     0.0   1.0   18.0 18.0     0.0   0.0     14.0   11.0   36.0 25 0 1   9 0     0   1   18 18     0 0   14 11   36
1953336 MN Cass 11 school 2708070 115 Independent Districts and Schools CASS LAKE-BENA PUBLIC SCHOOLS 270807003181 20 CASS LAKE-BENA MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 05 08 2019   grade_6 8.0 0.0 5.0   76.0 0.0     0.0   5.0   48.0 46.0     0.0   0.0     69.0   18.0   94.0 8 0 5   76 0     0   5   48 46     0 0   69 18   94
1945546 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_6 38.0 0.0 1.0   8.0 0.0     0.0   4.0   31.0 20.0     0.0   0.0     24.0   15.0   51.0 38 0 1   8 0     0   4   31 20     0 0   24 15   51
1947645 MN Hennepin 27 school 2714220 272 Independent Districts and Schools EDEN PRAIRIE PUBLIC SCHOOL DISTRICT 271422002241 887 CEDAR RIDGE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 06 2019   grade_6 61.0 17.0 9.0   0.0 17.0     0.0   10.0   58.0 56.0     7.0   0.0     23.0   22.0   114.0 61 17 9   0 17     0   10   58 56     7 0   23 22   114
1952120 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_6 0.0 14.0 0.0   0.0 0.0     0.0   0.0   7.0 7.0     7.0   0.0         2.0   14.0 0 14 0   0 0     0   0   7 7     7 0     2   14
1953253 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 2019   grade_6 411.0 26.0 34.0   2.0 30.0     0.0   27.0   252.0 278.0     *   *         *   530.0 411 26 34   2 30     0   27   252 278                 530
1953310 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 2019   grade_6 72.0 1.0 8.0   0.0 0.0     0.0   2.0   40.0 43.0     0.0   0.0     18.0   11.0   83.0 72 1 8   0 0     0   2   40 43     0 0   18 11   83
1953726 MN Polk 60 school 2711130 595 Independent Districts and Schools EAST GRAND FORKS PUBLIC SCHOOL DIST 271113000494 310 CENTRAL MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_6 107.0 11.0 17.0   0.0 0.0     0.0   5.0   71.0 69.0     9.0   0.0     44.0   26.0   140.0 107 11 17   0 0     0   5   71 69     9 0   44 26   140
1953757 MN Ramsey 62 school 2742360 624 Independent Districts and Schools WHITE BEAR LAKE SCHOOL DISTRICT 274236001787 57 CENTRAL MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_6 319.0 11.0 30.0   0.0 13.0     1.0   23.0   195.0 202.0     2.0   *     80.0   53.0   397.0 319 11 30   0 13     1   23   195 202     2     80 53   397
1949230 MN Ramsey 62 school 2732430 623 Independent Districts and Schools ROSEVILLE PUBLIC SCHOOL DISTRICT 273243001388 722 CENTRAL PARK ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 06 2019   grade_6 10.0 16.0 8.0   0.0 23.0     0.0   7.0   26.0 38.0     16.0   0.0     49.0   5.0   64.0 10 16 8   0 23     0   7   26 38     16 0   49 5   64

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