Data source: Big Local News · About: Big Local

702 rows where grade = "grade_6", state = "MN" and year = 2017 sorted by county_state_id

View and edit SQL

year

  • 2017 · 702

grade

  • grade_6 · 702
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
690555 MN Aitkin 1 school 2702760 1 Independent Districts and Schools AITKIN PUBLIC SCHOOL DISTRICT 270276000059 2 RIPPLESIDE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_6 90.0 1.0 2.0   0.0 0.0     0.0   5.0   61.0 37.0     1.0   0.0     48.0   12.0   98.0 90 1 2   0 0     0   5   61 37     1 0   48 12   98
690572 MN Aitkin 1 school 2719170 4 Independent Districts and Schools MCGREGOR PUBLIC SCHOOL DISTRICT 271917000903 10 MCGREGOR ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_6 24.0 0.0 1.0   6.0 1.0     0.0   1.0   18.0 15.0     0.0   0.0     20.0   11.0   33.0 24 0 1   6 1     0   1   18 15     0 0   20 11   33
697680 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_6 21.0 0.0 0.0   1.0 0.0     0.0   2.0   12.0 12.0     0.0   0.0     15.0   3.0   24.0 21 0 0   1 0     0   2   12 12     0 0   15 3   24
702759 MN Aitkin 1 school 2700300 4177 Charter Schools MINISINAAKWAANG LEADERSHIP ACADEMY 270030003730 10 MINISINAAKWAANG LEADERSHIP ACADEMY Elementary/Secondary Combined (Grades K-12 limited to District Type 34 Bureau of Indian Education) Regular School Yes Other KG 12 2017   grade_6 0.0 0.0 0.0   2.0 0.0     0.0   0.0   2.0 0.0         *         *   2.0 0 0 0   2 0     0   0   2 0                 2
690866 MN Anoka 2 school 2733330 16 Independent Districts and Schools SPRING LAKE PARK PUBLIC SCHOOLS 273333004657 787 Elementary Lighthouse Elementary School (Grades PK-6) Regular School No Elementary 01 06 2017   grade_6 9.0 0.0 1.0   0.0 0.0     0.0   0.0   7.0 3.0     0.0   0.0     2.0   1.0   10.0 9 0 1   0 0     0   0   7 3     0 0   2 1   10
694999 MN Anoka 2 school 2712270 831 Independent Districts and Schools FOREST LAKE PUBLIC SCHOOL DISTRICT 271227000597 628 Lino Lakes Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_6 47.0 2.0 1.0   1.0 6.0     0.0   4.0   26.0 35.0     4.0   0.0     18.0   3.0   61.0 47 2 1   1 6     0   4   26 35     4 0   18 3   61
696655 MN Anoka 2 school 2700093 4008 Charter Schools PACT CHARTER SCHOOL 270009302488 10 PACT CHARTER SCHOOL Elementary School (Grades PK-6) Regular School Yes Elementary KG 06 2017   grade_6 47.0 0.0 1.0   0.0 0.0     0.0   3.0   28.0 23.0     0.0   0.0     8.0   8.0   51.0 47 0 1   0 0     0   3   28 23     0 0   8 8   51
697267 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_6 36.0 3.0 2.0   0.0 8.0     0.0   1.0   25.0 25.0     0.0   0.0     10.0   4.0   50.0 36 3 2   0 8     0   1   25 25     0 0   10 4   50
697277 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_6 9.0 38.0 0.0   0.0 1.0     0.0   0.0   21.0 27.0     3.0   0.0         6.0   48.0 9 38 0   0 1     0   0   21 27     3 0     6   48
697453 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_6 7.0 10.0 0.0   0.0 1.0     0.0   1.0   14.0 5.0     3.0   0.0     11.0   0.0   19.0 7 10 0   0 1     0   1   14 5     3 0   11 0   19
697684 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_6 458.0 50.0 28.0   7.0 21.0     1.0   20.0   257.0 328.0     16.0   8.0     203.0   65.0   585.0 458 50 28   7 21     1   20   257 328     16 8   203 65   585
697688 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_6 250.0 55.0 39.0   4.0 29.0     0.0   25.0   211.0 191.0     16.0   11.0     213.0   56.0   402.0 250 55 39   4 29     0   25   211 191     16 11   213 56   402
697696 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_6 233.0 59.0 35.0   1.0 37.0     0.0   29.0   205.0 189.0     13.0   7.0     159.0   79.0   394.0 233 59 35   1 37     0   29   205 189     13 7   159 79   394
697700 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_6 342.0 10.0 7.0   2.0 8.0     1.0   15.0   199.0 186.0         3.0         *   385.0 342 10 7   2 8     1   15   199 186       3         385
697704 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_6 321.0 28.0 14.0   1.0 33.0     0.0   13.0   200.0 210.0     7.0   1.0     86.0   44.0   410.0 321 28 14   1 33     0   13   200 210     7 1   86 44   410
697708 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_6 395.0 19.0 21.0   2.0 23.0     1.0   21.0   261.0 221.0         *         *   482.0 395 19 21   2 23     1   21   261 221                 482
697712 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_6 51.0 82.0 92.0   5.0 17.0     0.0   24.0   130.0 141.0     54.0   15.0     224.0   *   271.0 51 82 92   5 17     0   24   130 141     54 15   224     271
697717 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_6 74.0 83.0 34.0   1.0 15.0     0.0   18.0   117.0 108.0         *         *   225.0 74 83 34   1 15     0   18   117 108                 225
697721 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_6 312.0 2.0 12.0   5.0 9.0     0.0   20.0   182.0 178.0         *         *   360.0 312 2 12   5 9     0   20   182 178                 360
697725 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_6 236.0 51.0 59.0   2.0 31.0     0.0   21.0   217.0 183.0     22.0   1.0     160.0   39.0   400.0 236 51 59   2 31     0   21   217 183     22 1   160 39   400
699752 MN Anoka 2 school 2712420 14 Independent Districts and Schools FRIDLEY PUBLIC SCHOOL DISTRICT 271242003427 652 FRIDLEY MIDDLE AREA LEARNING CENTER Public Area Learning Center ALC (State approved) Alternative School No Middle 05 08 2017   grade_6 2.0 2.0 2.0   0.0 1.0     0.0   1.0   4.0 4.0         *         *   8.0 2 2 2   0 1     0   1   4 4                 8
700448 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000005 467 RIVER TRAIL LEARNING CTR @ LO JACOB Special Education Special Education School No Other KG 12 2017   grade_6 4.0 1.0 0.0   0.0 0.0     0.0   1.0   6.0 0.0         *         *   6.0 4 1 0   0 0     0   1   6 0                 6
701116 MN Anoka 2 school 2702264 916 Intermediate Districts and Schools NORTHEAST METRO 916 270226404643 40 Karner Blue Education Center Special Education Special Education School No Elementary KG 08 2017   grade_6 8.0 3.0 0.0   0.0 1.0     0.0   0.0   7.0 5.0     0.0   0.0     8.0   *   12.0 8 3 0   0 1     0   0   7 5     0 0   8     12
701649 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 2017   grade_6 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     0   1   0 1                 1
701743 MN Anoka 2 school 2733540 15 Independent Districts and Schools ST. FRANCIS PUBLIC SCHOOL DISTRICT 273354004917 15 Saints Online Distance Learning Program OLL (State approved) Regular School No Other 03 12 2017   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
701929 MN Anoka 2 school 2708100 12 Independent Districts and Schools CENTENNIAL PUBLIC SCHOOL DISTRICT 270810004656 159 Pines School - NSP Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No Other 06 12 2017   grade_6 0.0 0.0 0.0   0.0 1.0     0.0   0.0   1.0 0.0         *         *   1.0 0 0 0   0 1     0   0   1 0                 1
690890 MN Becker 3 school 2712360 23 Independent Districts and Schools FRAZEE-VERGAS PUBLIC SCHOOL DIST. 271236000607 10 FRAZEE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_6 64.0 1.0 1.0   1.0 0.0     0.0   5.0   30.0 42.0     0.0   1.0     26.0   11.0   72.0 64 1 1   1 0     0   5   30 42     0 1   26 11   72
690898 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_6 0.0 0.0 0.0   4.0 0.0     0.0   0.0   0.0 4.0         *         *   4.0 0 0 0   4 0     0   0   0 4                 4
696130 MN Becker 3 school 2700162 2889 Independent Districts and Schools LAKE PARK AUDUBON SCHOOL DISTRICT 270016200142 10 LAKE PARK AUDUBON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_6 56.0 0.0 2.0   2.0 1.0     0.0   1.0   32.0 30.0     0.0   0.0     16.0   15.0   62.0 56 0 2   2 1     0   1   32 30     0 0   16 15   62
697730 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_6 188.0 3.0 6.0   16.0 3.0     0.0   27.0   123.0 120.0     0.0   3.0     100.0   47.0   243.0 188 3 6   16 3     0   27   123 120     0 3   100 47   243
690957 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 2017   grade_6 46.0 0.0 0.0   6.0 0.0     0.0   5.0   29.0 28.0     0.0   4.0     37.0   15.0   57.0 46 0 0   6 0     0   5   29 28     0 4   37 15   57
690967 MN Beltrami 4 school 2717010 36 Independent Districts and Schools KELLIHER PUBLIC SCHOOL DISTRICT 271701000786 10 KELLIHER ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_6 8.0 0.0 0.0   15.0 0.0     0.0   0.0   14.0 9.0     0.0   0.0     18.0   9.0   23.0 8 0 0   15 0     0   0   14 9     0 0   18 9   23
690985 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_6 0.0 0.0 0.0   28.0 0.0     0.0   0.0   16.0 12.0     0.0   3.0         12.0   28.0 0 0 0   28 0     0   0   16 12     0 3     12   28
696831 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_6 14.0 0.0 2.0   0.0 0.0     0.0   2.0   7.0 11.0     0.0   0.0     9.0   6.0   18.0 14 0 2   0 0     0   2   7 11     0 0   9 6   18
697734 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_6 263.0 5.0 7.0   48.0 2.0     0.0   28.0   183.0 170.0     2.0   *         *   353.0 263 5 7   48 2     0   28   183 170     2           353
697738 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_6 0.0 0.0 0.0   81.0 0.0     0.0   0.0   36.0 45.0     0.0   6.0         12.0   81.0 0 0 0   81 0     0   0   36 45     0 6     12   81
698556 MN Beltrami 4 school 2700345 4106 Charter Schools TREKNORTH HIGH SCHOOL 270034504666 20 Trek North Middle School Middle School (Grades 5-8) Regular School Yes Middle 06 08 2017   grade_6 23.0 0.0 1.0   10.0 0.0     0.0   4.0   19.0 19.0     0.0   0.0     22.0   12.0   38.0 23 0 1   10 0     0   4   19 19     0 0   22 12   38
698560 MN Beltrami 4 school 2700346 4107 Charter Schools VOYAGEURS EXPEDITIONARY 270034604667 20 Voyageurs Expeditionary MS Middle School (Grades 5-8) Regular School Yes Middle 06 08 2017   grade_6 5.0 0.0 0.0   9.0 0.0     0.0   0.0   8.0 6.0     0.0   0.0     9.0   5.0   14.0 5 0 0   9 0     0   0   8 6     0 0   9 5   14
691020 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_6 145.0 0.0 1.0   1.0 0.0     0.0   5.0   73.0 79.0     0.0   1.0     40.0   20.0   152.0 145 0 1   1 0     0   5   73 79     0 1   40 20   152
697742 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_6 279.0 13.0 16.0   5.0 7.0     1.0   13.0   160.0 174.0     4.0   1.0     125.0   49.0   334.0 279 13 16   5 7     1   13   160 174     4 1   125 49   334
696122 MN Big Stone 6 school 2700150 2888 Independent Districts and Schools CLINTON-GRACEVILLE-BEARDSLEY 270015000378 1 CLINTON-GRACEVILLE-BEARDSLEY EL. Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_6 23.0 0.0 0.0   0.0 0.0     0.0   1.0   9.0 15.0         *         *   24.0 23 0 0   0 0     0   1   9 15                 24
696200 MN Big Stone 6 school 2700328 2903 Independent Districts and Schools ORTONVILLE PUBLIC SCHOOLS 270032804394 10 KNOLL ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_6 30.0 0.0 1.0   0.0 0.0     0.0   1.0   16.0 16.0     0.0   0.0     15.0   6.0   32.0 30 0 1   0 0     0   1   16 16     0 0   15 6   32
702705 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_6 4.0 0.0 0.0   0.0 0.0     0.0   0.0   0.0 4.0         *         *   4.0 4 0 0   0 0     0   0   0 4                 4
689967 MN Blue Earth 7 school 2791445 2071 Independent Districts and Schools LAKE CRYSTAL-WELLCOME MEMORIAL 279144502312 30 LK CRYSTAL-WELLCOME MEMORIAL SECONDARY Secondary School (Grades 7-12) Regular School No Other 06 12 2017   grade_6 58.0 1.0 3.0   0.0 0.0     0.0   1.0   28.0 35.0     0.0   0.0     15.0   11.0   63.0 58 1 3   0 0     0   1   28 35     0 0   15 11   63
690387 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_6 3.0 1.0 1.0   0.0 0.0     0.0   0.0   4.0 1.0         *         *   5.0 3 1 1   0 0     0   0   4 1                 5
691031 MN Blue Earth 7 school 2733480 75 Independent Districts and Schools ST. CLAIR PUBLIC SCHOOL DISTRICT 273348001477 10 ST. CLAIR ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_6 52.0 0.0 3.0   0.0 0.0     0.0   2.0   21.0 36.0     0.0   0.0     9.0   4.0   57.0 52 0 3   0 0     0   2   21 36     0 0   9 4   57
697750 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_6 256.0 46.0 21.0   1.0 9.0     0.0   7.0   171.0 169.0     19.0   *     130.0   50.0   340.0 256 46 21   1 9     0   7   171 169     19     130 50   340
698396 MN Blue Earth 7 school 2700006 2135 Independent Districts and Schools MAPLE RIVER SCHOOL DISTRICT 270000601070 30 MAPLE RIVER MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_6 70.0 0.0 3.0   0.0 0.0     0.0   1.0   39.0 35.0     0.0   0.0     27.0   6.0   74.0 70 0 3   0 0     0   1   39 35     0 0   27 6   74
700487 MN Blue Earth 7 school 2718780 77 Independent Districts and Schools MANKATO PUBLIC SCHOOL DISTRICT 271878004374 370 FUTURES PROGRAM Special Education Special Education School No Other KG 12 2017   grade_6 2.0 0.0 0.0   0.0 0.0     0.0   0.0   2.0 0.0         *         *   2.0 2 0 0   0 0     0   0   2 0                 2
691111 MN Brown 8 school 2709540 81 Independent Districts and Schools COMFREY PUBLIC SCHOOL DISTRICT 270954000403 10 COMFREY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_6 11.0 0.0 0.0   0.0 0.0     0.0   0.0   3.0 8.0     0.0   0.0     5.0   2.0   11.0 11 0 0   0 0     0   0   3 8     0 0   5 2   11
691120 MN Brown 8 school 2733210 84 Independent Districts and Schools SLEEPY EYE PUBLIC SCHOOL DISTRICT 273321001450 10 SLEEPY EYE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_6 22.0 3.0 13.0   0.0 1.0     0.0   0.0   21.0 18.0     4.0   2.0     17.0   6.0   39.0 22 3 13   0 1     0   0   21 18     4 2   17 6   39
691129 MN Brown 8 school 2733390 85 Independent Districts and Schools SPRINGFIELD PUBLIC SCHOOL DISTRICT 273339001470 2 SPRINGFIELD ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_6 33.0 0.0 3.0   0.0 1.0     0.0   0.0   18.0 19.0     0.0   0.0     15.0   2.0   37.0 33 0 3   0 1     0   0   18 19     0 0   15 2   37
697755 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_6 134.0 0.0 5.0   0.0 1.0     0.0   1.0   76.0 65.0     0.0   2.0     37.0   24.0   141.0 134 0 5   0 1     0   1   76 65     0 2   37 24   141
701572 MN Brown 8 school 2791353 6049 Education Districts RIVER BEND EDUCATION DISTRICT 279135304366 35 IMPRINTS PROGRAM Special Education Special Education School No Other 02 12 2017   grade_6 4.0 0.0 0.0   0.0 0.0     0.0   0.0   4.0 0.0         *         *   4.0 4 0 0   0 0     0   0   4 0                 4
689087 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_6 29.0 0.0 0.0   4.0 1.0     0.0   2.0   22.0 14.0     0.0   0.0     16.0   9.0   36.0 29 0 0   4 1     0   2   22 14     0 0   16 9   36
691146 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 2017   grade_6 52.0 0.0 1.0   0.0 0.0     0.0   5.0   36.0 22.0     0.0   0.0     18.0   8.0   58.0 52 0 1   0 0     0   5   36 22     0 0   18 8   58
691162 MN Carlton 9 school 2709420 94 Independent Districts and Schools CLOQUET PUBLIC SCHOOL DISTRICT 270942000380 101 CHURCHILL ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_6 3.0 0.0 0.0   0.0 0.0     0.0   0.0   3.0 0.0         *         *   3.0 3 0 0   0 0     0   0   3 0                 3
691178 MN Carlton 9 school 2709690 95 Independent Districts and Schools CROMWELL-WRIGHT PUBLIC SCHOOLS 270969000410 10 CROMWELL-WRIGHT ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_6 29.0 0.0 0.0   2.0 0.0     0.0   0.0   15.0 16.0     0.0   0.0     14.0   5.0   31.0 29 0 0   2 0     0   0   15 16     0 0   14 5   31
691187 MN Carlton 9 school 2721450 97 Independent Districts and Schools MOOSE LAKE PUBLIC SCHOOL DISTRICT 272145001093 20 MOOSE LAKE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_6 44.0 1.0 0.0   1.0 0.0     0.0   2.0   27.0 21.0     0.0   1.0     19.0   10.0   48.0 44 1 0   1 0     0   2   27 21     0 1   19 10   48
691196 MN Carlton 9 school 2738880 99 Independent Districts and Schools ESKO PUBLIC SCHOOL DISTRICT 273888001683 30 WINTERQUIST ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_6 74.0 0.0 0.0   0.0 0.0     0.0   3.0   46.0 31.0     0.0   0.0     11.0   10.0   77.0 74 0 0   0 0     0   3   46 31     0 0   11 10   77
691205 MN Carlton 9 school 2744190 100 Independent Districts and Schools WRENSHALL PUBLIC SCHOOL DISTRICT 274419001842 1 WRENSHALL ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_6 20.0 0.0 0.0   0.0 0.0     0.0   0.0   10.0 10.0     0.0   0.0     15.0   6.0   20.0 20 0 0   0 0     0   0   10 10     0 0   15 6   20
697759 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_6 129.0 2.0 2.0   20.0 2.0     1.0   24.0   98.0 82.0         *     80.0   32.0   180.0 129 2 2   20 2     1   24   98 82           80 32   180
699806 MN Carlton 9 school 2709420 94 Independent Districts and Schools CLOQUET PUBLIC SCHOOL DISTRICT 270942002236 103 CLOQUET AREA ALT. ED. PROGRAMS Public Area Learning Center ALC (State approved) Alternative School No Other 01 12 2017   grade_6 2.0 0.0 0.0   1.0 0.0     0.0   0.0   2.0 1.0         *         *   3.0 2 0 0   1 0     0   0   2 1                 3
696684 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_6 20.0 2.0 1.0   0.0 0.0     0.0   1.0   11.0 13.0     0.0   0.0     2.0   7.0   24.0 20 2 1   0 0     0   1   11 13     0 0   2 7   24
697294 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_6 44.0 4.0 5.0   0.0 1.0     0.0   2.0   28.0 28.0     0.0   0.0     3.0   11.0   56.0 44 4 5   0 1     0   2   28 28     0 0   3 11   56
697763 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_6 66.0 0.0 6.0   0.0 1.0     1.0   1.0   41.0 34.0     1.0   0.0     18.0   14.0   75.0 66 0 6   0 1     1   1   41 34     1 0   18 14   75
697767 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_6 266.0 3.0 15.0   1.0 2.0     2.0   13.0   165.0 137.0     5.0   1.0     48.0   53.0   302.0 266 3 15   1 2     2   13   165 137     5 1   48 53   302
697771 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_6 127.0 0.0 1.0   0.0 1.0     0.0   3.0   65.0 67.0     0.0   0.0     27.0   13.0   132.0 127 0 1   0 1     0   3   65 67     0 0   27 13   132
697775 MN Carver 10 school 2708190 112 Independent Districts and Schools EASTERN CARVER COUNTY PUBLIC SCHOOL 270819000345 61 CHASKA MIDDLE SCHOOL EAST Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_6 149.0 2.0 15.0   1.0 3.0     0.0   11.0   80.0 101.0     4.0   0.0         *   181.0 149 2 15   1 3     0   11   80 101     4 0         181
697779 MN Carver 10 school 2708190 112 Independent Districts and Schools EASTERN CARVER COUNTY PUBLIC SCHOOL 270819002798 62 CHASKA MIDDLE SCHOOL WEST Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_6 158.0 4.0 11.0   0.0 10.0     0.0   10.0   98.0 95.0         0.0     24.0   23.0   193.0 158 4 11   0 10     0   10   98 95       0   24 23   193
697783 MN Carver 10 school 2708190 112 Independent Districts and Schools EASTERN CARVER COUNTY PUBLIC SCHOOL 270819003180 63 PIONEER RIDGE MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_6 144.0 11.0 30.0   0.0 10.0     0.0   11.0   113.0 93.0     5.0   *     58.0   *   206.0 144 11 30   0 10     0   11   113 93     5     58     206
697960 MN Carver 10 school 2711670 276 Independent Districts and Schools MINNETONKA PUBLIC SCHOOL DISTRICT 271167002194 175 MINNETONKA WEST MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_6 352.0 10.0 19.0   0.0 23.0     1.0   12.0   200.0 217.0     5.0   0.0     18.0   52.0   417.0 352 10 19   0 23     1   12   200 217     5 0   18 52   417
699829 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 2017   grade_6 59.0 6.0 28.0   2.0 1.0     0.0   6.0   50.0 52.0     12.0   0.0     44.0   22.0   102.0 59 6 28   2 1     0   6   50 52     12 0   44 22   102
701663 MN Carver 10 school 2708190 112 Independent Districts and Schools EASTERN CARVER COUNTY PUBLIC SCHOOL 270819004659 522 PrairieCare Chaska Hospital/Medical/Partial Hospitalization Program Alternative School No Other KG 12 2017   grade_6 1.0 0.0 1.0   0.0 0.0     0.0   0.0   1.0 1.0         *         *   2.0 1 0 1   0 0     0   0   1 1                 2
691309 MN Cass 11 school 2702910 113 Independent Districts and Schools WALKER-HACKENSACK-AKELEY SCHL. DIST 270291001736 10 W.H.A. ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_6 42.0 0.0 3.0   10.0 0.0     0.0   4.0   28.0 31.0     0.0   3.0     31.0   15.0   59.0 42 0 3   10 0     0   4   28 31     0 3   31 15   59
691333 MN Cass 11 school 2730870 118 Independent Districts and Schools NORTHLAND COMMUNITY SCHOOLS 273087001307 10 REMER ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_6 17.0 0.0 0.0   5.0 0.0     0.0   7.0   18.0 11.0     0.0   0.0     20.0   9.0   29.0 17 0 0   5 0     0   7   18 11     0 0   20 9   29
695729 MN Cass 11 school 2728970 2174 Independent Districts and Schools PINE RIVER-BACKUS SCHOOL DISTRICT 272897000039 10 PINE RIVER-BACKUS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_6 70.0 2.0 0.0   1.0 0.0     0.0   1.0   46.0 28.0     0.0   1.0     40.0   15.0   74.0 70 2 0   1 0     0   1   46 28     0 1   40 15   74
697788 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 2017   grade_6 8.0 0.0 3.0   68.0 0.0     0.0   3.0   48.0 34.0     0.0   2.0     66.0   24.0   82.0 8 0 3   68 0     0   3   48 34     0 2   66 24   82
697793 MN Cass 11 school 2728350 116 Independent Districts and Schools PILLAGER PUBLIC SCHOOL DISTRICT 272835004841 40 Pillager Middle School Middle School (Grades 5-8) Regular School No Middle 05 08 2017   grade_6 81.0 1.0 1.0   1.0 0.0     0.0   0.0   33.0 51.0     0.0   0.0     32.0   12.0   84.0 81 1 1   1 0     0   0   33 51     0 0   32 12   84
695748 MN Chippewa 12 school 2700091 2180 Independent Districts and Schools MACCRAY School District 270009100898 2 MACCRAY WEST ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_6 16.0 0.0 4.0   0.0 0.0     0.0   0.0   9.0 11.0     0.0   1.0     10.0   4.0   20.0 16 0 4   0 0     0   0   9 11     0 1   10 4   20
697799 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_6 92.0 1.0 12.0   0.0 2.0     0.0   4.0   70.0 41.0     4.0   0.0     43.0   23.0   111.0 92 1 12   0 2     0   4   70 41     4 0   43 23   111
691357 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 2017   grade_6 67.0 0.0 1.0   1.0 2.0     0.0   0.0   39.0 32.0     2.0   0.0     28.0   9.0   71.0 67 0 1   1 2     0   0   39 32     2 0   28 9   71
697803 MN Chisago 13 school 2723820 138 Independent Districts and Schools NORTH BRANCH PUBLIC SCHOOLS 272382001164 20 NORTH BRANCH MIDDLE Middle School (Grades 5-8) Regular School No Middle 05 08 2017   grade_6 192.0 0.0 7.0   2.0 2.0     0.0   3.0   110.0 96.0         *         *   206.0 192 0 7   2 2     0   3   110 96                 206
698404 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_6 253.0 2.0 4.0   0.0 1.0     0.0   4.0   134.0 130.0         *         24.0   264.0 253 2 4   0 1     0   4   134 130             24   264
700914 MN Chisago 13 school 2700017 2144 Independent Districts and Schools CHISAGO LAKES SCHOOL DISTRICT 270001704939 17 SOAR Special Education Special Education School No Other 01 12 2017   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
701755 MN Chisago 13 school 2723820 138 Independent Districts and Schools NORTH BRANCH PUBLIC SCHOOLS 272382002633 70 DISTANCE LEARNING PROGRAM Distance Learning Program OLL (State approved) Regular School No Other KG 12 2017   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
691365 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 2017   grade_6 67.0 0.0 1.0   0.0 0.0     0.0   2.0   39.0 31.0     0.0   1.0     6.0   4.0   70.0 67 0 1   0 0     0   2   39 31     0 1   6 4   70
691373 MN Clay 14 school 2713560 150 Independent Districts and Schools HAWLEY PUBLIC SCHOOL DISTRICT 271356000698 10 HAWLEY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_6 60.0 0.0 0.0   0.0 0.0     1.0   2.0   40.0 23.0         *         *   63.0 60 0 0   0 0     1   2   40 23                 63
691380 MN Clay 14 school 2713560 150 Independent Districts and Schools HAWLEY PUBLIC SCHOOL DISTRICT 271356002240 11 SPRING PRAIRIE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 06 2017   grade_6 4.0 0.0 0.0   0.0 0.0     0.0   0.0   2.0 2.0         *         *   4.0 4 0 0   0 0     0   0   2 2                 4
695488 MN Clay 14 school 2740810 914 Independent Districts and Schools ULEN-HITTERDAL PUBLIC SCHOOL DIST 274081001704 1 ULEN-HITTERDAL ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_6 16.0 1.0 1.0   2.0 1.0     0.0   0.0   13.0 8.0     0.0   0.0         5.0   21.0 16 1 1   2 1     0   0   13 8     0 0     5   21
697807 MN Clay 14 school 2721420 152 Independent Districts and Schools MOORHEAD PUBLIC SCHOOL DISTRICT 272142003512 380 HORIZON MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_6 339.0 26.0 41.0   19.0 3.0     0.0   30.0   245.0 213.0         *         *   458.0 339 26 41   19 3     0   30   245 213                 458
698412 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_6 115.0 2.0 11.0   3.0 0.0     0.0   4.0   79.0 56.0     2.0   1.0     45.0   24.0   135.0 115 2 11   3 0     0   4   79 56     2 1   45 24   135
701967 MN Clay 14 school 2721420 152 Independent Districts and Schools MOORHEAD PUBLIC SCHOOL DISTRICT 272142002799 970 CLAY COUNTY SHELTER CARE Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No Other 03 12 2017   grade_6 0.0 0.0 1.0   0.0 0.0     0.0   0.0   0.0 1.0         *         *   1.0 0 0 1   0 0     0   0   0 1                 1
691410 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 2017   grade_6 51.0 1.0 0.0   20.0 1.0     0.0   6.0   41.0 38.0     0.0   0.0     44.0   14.0   79.0 51 1 0   20 1     0   6   41 38     0 0   44 14   79
695816 MN Clearwater 15 school 2700103 2311 Independent Districts and Schools CLEARBROOK-GONVICK SCHOOL DISTRICT 270010303467 10 CLEARBROOK-GONVICK ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_6 29.0 0.0 0.0   14.0 0.0     0.0   1.0   21.0 23.0     0.0   1.0     28.0   4.0   44.0 29 0 0   14 0     0   1   21 23     0 1   28 4   44
696969 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_6 11.0 0.0 0.0   0.0 0.0     0.0   0.0   6.0 5.0     0.0   0.0     3.0   3.0   11.0 11 0 0   0 0     0   0   6 5     0 0   3 3   11
697342 MN Cook 16 school 2700321 4195 Charter Schools OSHKI OGIMAAG CHARTER SCHOOL 270032104293 10 OSHKI OGIMAAG CHARTER SCHOOL Elementary School (Grades PK-6) Regular School Yes Elementary KG 06 2017   grade_6 0.0 0.0 0.0   2.0 0.0     0.0   1.0   3.0 0.0         *         *   3.0 0 0 0   2 0     0   1   3 0                 3
697811 MN Cook 16 school 2713110 166 Independent Districts and Schools COOK COUNTY PUBLIC SCHOOLS 271311002635 40 COOK COUNTY MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_6 18.0 0.0 2.0   5.0 0.0     0.0   2.0   14.0 13.0     0.0   0.0     14.0   3.0   27.0 18 0 2   5 0     0   2   14 13     0 0   14 3   27
691428 MN Cottonwood 17 school 2723010 173 Independent Districts and Schools MOUNTAIN LAKE PUBLIC SCHOOLS 272301001134 10 MOUNTAIN LAKE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_6 26.0 0.0 5.0   0.0 1.0     0.0   1.0   14.0 19.0     1.0   0.0     18.0   7.0   33.0 26 0 5   0 1     0   1   14 19     1 0   18 7   33
697817 MN Cottonwood 17 school 2742780 177 Independent Districts and Schools WINDOM PUBLIC SCHOOL DISTRICT 274278003068 60 WINDOM MIDDLE Middle School (Grades 5-8) Regular School No Elementary 04 08 2017   grade_6 66.0 3.0 12.0   0.0 0.0     0.0   2.0   47.0 36.0     1.0   0.0     30.0   15.0   83.0 66 3 12   0 0     0   2   47 36     1 0   30 15   83

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