Data source: Big Local News · About: Big Local

671 rows where grade = "grade_7", state = "MN" and year = 2015 sorted by ccd_school_low_grade

View and edit SQL

year

  • 2015 · 671

grade

  • grade_7 · 671
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
1147547 MN Ramsey 62 school 2700344 4105 Charter Schools GREAT RIVER SCHOOL 270034404093 10 GREAT RIVER SCHOOL Secondary School (Grades 7-12) Regular School Yes 4 01 12 2015   grade_7 44.0 1.0 2.0   0.0 1.0     0.0   3.0   27.0 24.0     1.0   0.0     6.0   7.0   51.0 44 1 2   0 1     0   3   27 24     1 0   6 7   51
1151046 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 1 01 08 2015   grade_7 83.0 60.0 15.0   1.0 58.0     0.0   3.0   120.0 100.0     33.0   0.0     109.0   7.0   220.0 83 60 15   1 58     0   3   120 100     33 0   109 7   220
1153665 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 1 01 08 2015   grade_7 24.0 1.0 0.0   0.0 0.0     0.0   0.0   13.0 12.0     0.0   0.0     4.0   7.0   25.0 24 1 0   0 0     0   0   13 12     0 0   4 7   25
1156616 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 Education School No 4 01 12 2015   grade_7 0.0 0.0 0.0   0.0 0.0     0.0   1.0   1.0 0.0         *         *   1.0 0 0 0   0 0     0   1   1 0                 1
1157402 MN Hennepin 27 school 2725200 279 Independent Districts and Schools OSSEO PUBLIC SCHOOL DISTRICT 272520003593 45 ACHIEVE Special Education Special Education School No 4 01 12 2015   grade_7 2.0 1.0 0.0   1.0 0.0     0.0   0.0   3.0 1.0         *         *   4.0 2 1 0   1 0     0   0   3 1                 4
1157850 MN Hennepin 27 school 2700025 287 Intermediate Districts and Schools INTERMEDIATE SCHOOL DISTRICT 287 270002503542 479 SAFE Special Education Special Education School No 4 01 12 2015   grade_7 1.0 1.0 0.0   0.0 0.0     0.0   0.0   2.0 0.0         *         *   2.0 1 1 0   0 0     0   0   2 0                 2
1158106 MN Cottonwood 17 school 2700086 991 Service Cooperative (ECSU Region) REGION 6 AND 8-SW/WC SRV COOPERATIVE 270008604168 16 RED ROCK RIDGE SETTING IV Special Education Special Education School No 4 01 12 2015   grade_7 2.0 0.0 0.0   0.0 0.0     0.0   0.0   1.0 1.0         *         *   2.0 2 0 0   0 0     0   0   1 1                 2
1158791 MN Saint Louis 69 school 2711040 709 Independent Districts and Schools DULUTH PUBLIC SCHOOL DISTRICT 271104001562 81 MERRITT CREEK ACADEMY Educational Oversight to Public Residential Care & Treatment (State approved) Alternative Education School No 4 01 12 2015   grade_7 8.0 1.0 1.0   0.0 0.0     0.0   0.0   7.0 3.0     0.0   1.0         8.0   10.0 8 1 1   0 0     0   0   7 3     0 1     8   10
1158251 MN Brown 8 school 2791353 6049 Education Districts RIVER BEND EDUCATION DISTRICT 279135304366 35 IMPRINTS PROGRAM Special Education Special Education School No 4 02 12 2015   grade_7 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
1158773 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384001334 678 JUVENILE SERVICE CENTER Educational Oversight to Public Residential Care & Treatment (State approved) Alternative Education School No 4 02 12 2015   grade_7 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
1153326 MN Hennepin 27 school 2721240 1 Special Districts and Schools MINNEAPOLIS PUBLIC SCHOOL DIST. 272124000988 134 LK NOKOMIS COMM-KEEWAYDIN CAMPUS Elementary School (Grades PK-6) Regular School No 1 03 08 2015   grade_7 27.0 16.0 12.0   3.0 0.0     0.0   0.0   30.0 28.0     7.0   6.0     34.0   12.0   58.0 27 16 12   3 0     0   0   30 28     7 6   34 12   58
1157655 MN Sherburne 71 school 2711370 728 Independent Districts and Schools ELK RIVER PUBLIC SCHOOL DISTRICT 271137004142 401 ISD 728 FOCUS/JOURNEY Special Education Special Education School No 4 03 12 2015   grade_7 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
1158183 MN Otter Tail 56 school 2700014 6004 Education Districts FRESHWATER ED. DIST. 270001404821 50 Elm Tree Academy Special Education Special Education School No 4 03 12 2015   grade_7 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
1158565 MN Ramsey 62 school 2700138 4025 Charter Schools CYBER VILLAGE ACADEMY 270013802717 10 CYBER VILLAGE ACADEMY Distance Learning Program OLL (State approved) Regular School Yes 4 03 12 2015   grade_7 20.0 0.0 4.0   0.0 0.0     0.0   2.0   13.0 13.0     0.0   0.0     8.0   6.0   26.0 20 0 4   0 0     0   2   13 13     0 0   8 6   26
1158629 MN Beltrami 4 school 2704440 31 Independent Districts and Schools BEMIDJI PUBLIC SCHOOL DISTRICT 270444000313 160 FIRST CITY SCHOOL Educational Oversight to Public Residential Care & Treatment (State approved) Alternative Education School No 4 03 12 2015   grade_7 0.0 0.0 0.0   1.0 0.0     0.0   0.0   1.0 0.0         *         *   1.0 0 0 0   1 0     0   0   1 0                 1
1158656 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 Education School No 4 03 12 2015   grade_7 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
1158981 MN Crow Wing 18 school 2706090 181 Independent Districts and Schools BRAINERD PUBLIC SCHOOL DISTRICT 270609000468 17 LINCOLN EDUCATION CENTER Miscellaneous Program (assignment is now limited) Alternative Education School No 4 03 12 2015   grade_7 3.0 0.0 0.0   1.0 0.0     0.0   1.0   4.0 1.0         *         *   5.0 3 0 0   1 0     0   1   4 1                 5
1148072 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 2 04 08 2015   grade_7 126.0 1.0 3.0   1.0 0.0     0.0   2.0   71.0 62.0     0.0   2.0     48.0   18.0   133.0 126 1 3   1 0     0   2   71 62     0 2   48 18   133
1151092 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 2 04 08 2015   grade_7 31.0 44.0 21.0   2.0 19.0     0.0   4.0   56.0 65.0     35.0   5.0     93.0   21.0   121.0 31 44 21   2 19     0   4   56 65     35 5   93 21   121
1153304 MN Hennepin 27 school 2721240 1 Special Districts and Schools MINNEAPOLIS PUBLIC SCHOOL DIST. 272124000969 121 LAKE HARRIET UPPER SCHOOL Elementary School (Grades PK-6) Regular School No 2 04 08 2015   grade_7 90.0 9.0 1.0   1.0 7.0     0.0   0.0   47.0 61.0     2.0   0.0     12.0   10.0   108.0 90 9 1   1 7     0   0   47 61     2 0   12 10   108
1154664 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 2 04 07 2015   grade_7 64.0 3.0 16.0   1.0 1.0     0.0   2.0   53.0 34.0     12.0   0.0     40.0   17.0   87.0 64 3 16   1 1     0   2   53 34     12 0   40 17   87
1154682 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 2 04 08 2015   grade_7 57.0 2.0 14.0   0.0 0.0     0.0   3.0   41.0 35.0     4.0   0.0     38.0   11.0   76.0 57 2 14   0 0     0   3   41 35     4 0   38 11   76
1155072 MN Saint Louis 69 school 2713920 700 Independent Districts and Schools HERMANTOWN PUBLIC SCHOOL DISTRICT 271392002143 15 HERMANTOWN MIDDLE Middle School (Grades 5-8) Regular School No 2 04 08 2015   grade_7 153.0 0.0 2.0   2.0 2.0     0.0   7.0   82.0 84.0     0.0   1.0     19.0   19.0   166.0 153 0 2   2 2     0   7   82 84     0 1   19 19   166
1155400 MN Stearns 73 school 2700252 4142 Charter Schools Stride Academy Charter School 270025204405 20 STRIDE ACADEMY MIDDLE SCHOOL Middle School (Grades 5-8) Regular School Yes 2 04 08 2015   grade_7 30.0 13.0 0.0   0.0 0.0     0.0   0.0   29.0 14.0     8.0   1.0     30.0   15.0   43.0 30 13 0   0 0     0   0   29 14     8 1   30 15   43
1155439 MN Hennepin 27 school 2700161 6069 Secondary Facilities Cooperatives WEST METRO EDUCATION PROGRAM 270016103417 401 FAIR School Crystal Middle School (Grades 5-8) Regular School No 2 04 08 2015   grade_7 26.0 44.0 4.0   0.0 1.0     0.0   6.0   37.0 44.0     1.0   1.0     42.0   11.0   81.0 26 44 4   0 1     0   6   37 44     1 1   42 11   81
1157625 MN Rice 66 school 2711760 656 Independent Districts and Schools FARIBAULT PUBLIC SCHOOL DISTRICT 271176004466 60 FOCUS Special Education Special Education School No 4 04 12 2015   grade_7 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
1158711 MN Kandiyohi 34 school 2742720 347 Independent Districts and Schools WILLMAR PUBLIC SCHOOL DISTRICT 274272004673 931 Prairie Lakes Education Center Educational Oversight to Public Residential Care & Treatment (State approved) Alternative Education School No 4 04 12 2015   grade_7 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
1159304 MN Dakota 19 school 2700026 917 Intermediate Districts and Schools INTERMEDIATE SCHOOL DISTRICT 917 270002604516 300 Options Educational Oversight to Public Care and Treatment Day Program Alternative Education School No 4 04 12 2015   grade_7 1.0 0.0 0.0   1.0 0.0     0.0   0.0   1.0 1.0         *         *   2.0 1 0 0   1 0     0   0   1 1                 2
1146684 MN Otter Tail 56 school 2740830 550 Independent Districts and Schools UNDERWOOD PUBLIC SCHOOL DISTRICT 274083001707 20 UNDERWOOD SECONDARY Secondary School (Grades 7-12) Regular School No 4 05 12 2015   grade_7 52.0 0.0 0.0   0.0 2.0     0.0   0.0   31.0 23.0     0.0   0.0     21.0   12.0   54.0 52 0 0   0 2     0   0   31 23     0 0   21 12   54
1147365 MN Redwood 64 school 2700132 2884 Independent Districts and Schools RED ROCK CENTRAL SCHOOL DISTRICT 270013200820 20 RED ROCK CENTRAL SECONDARY Secondary School (Grades 7-12) Regular School No 4 05 12 2015   grade_7 32.0 1.0 1.0   0.0 0.0     0.0   3.0   19.0 18.0     0.0   0.0     14.0   3.0   37.0 32 1 1   0 0     0   3   19 18     0 0   14 3   37
1154558 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 2 05 08 2015   grade_7 16.0 0.0 1.0   3.0 0.0     0.0   0.0   9.0 11.0     0.0   0.0     11.0   4.0   20.0 16 0 1   3 0     0   0   9 11     0 0   11 4   20
1154595 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 2 05 08 2015   grade_7 97.0 58.0 32.0   7.0 20.0     0.0   11.0   125.0 100.0     29.0   2.0     151.0   35.0   225.0 97 58 32   7 20     0   11   125 100     29 2   151 35   225
1154608 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 2 05 08 2015   grade_7 179.0 2.0 2.0   27.0 3.0     0.0   8.0   116.0 105.0         *         *   221.0 179 2 2   27 3     0   8   116 105                 221
1154633 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 2 05 08 2015   grade_7 283.0 3.0 9.0   1.0 1.0     0.0   8.0   155.0 150.0     2.0   1.0     37.0   29.0   305.0 283 3 9   1 1     0   8   155 150     2 1   37 29   305
1154654 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 2 05 08 2015   grade_7 3.0 0.0 0.0   73.0 0.0     0.0   2.0   46.0 32.0         *         *   78.0 3 0 0   73 0     0   2   46 32                 78
1154668 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 2 05 08 2015   grade_7 224.0 3.0 3.0   1.0 3.0     0.0   0.0   122.0 112.0         *         *   234.0 224 3 3   1 3     0   0   122 112                 234
1154687 MN Crow Wing 18 school 2706090 181 Independent Districts and Schools BRAINERD PUBLIC SCHOOL DISTRICT 270609004196 22 FORESTVIEW MIDDLE Middle School (Grades 5-8) Regular School No 2 05 08 2015   grade_7 491.0 11.0 4.0   7.0 5.0     1.0   11.0   268.0 262.0     0.0   3.0     208.0   92.0   530.0 491 11 4   7 5     1   11   268 262     0 3   208 92   530
1154692 MN Crow Wing 18 school 2728200 186 Independent Districts and Schools PEQUOT LAKES PUBLIC SCHOOLS 272820003069 15 PEQUOT LAKES MIDDLE Middle School (Grades 5-8) Regular School No 2 05 08 2015   grade_7 129.0 1.0 0.0   1.0 0.0     0.0   0.0   63.0 68.0     0.0   0.0     41.0   17.0   131.0 129 1 0   1 0     0   0   63 68     0 0   41 17   131
1154741 MN Dakota 19 school 2742270 197 Independent Districts and Schools WEST ST. PAUL-MENDOTA HTS.-EAGAN 274227002646 52 FRIENDLY HILLS MIDDLE Middle School (Grades 5-8) Regular School No 2 05 08 2015   grade_7 109.0 14.0 30.0   0.0 17.0     0.0   10.0   85.0 95.0     11.0   1.0     51.0   26.0   180.0 109 14 30   0 17     0   10   85 95     11 1   51 26   180
1154746 MN Dakota 19 school 2742270 197 Independent Districts and Schools WEST ST. PAUL-MENDOTA HTS.-EAGAN 274227001774 54 HERITAGE E-STEM MAGNET SCHOOL Middle School (Grades 5-8) Regular School No 2 05 08 2015   grade_7 81.0 21.0 76.0   1.0 2.0     0.0   11.0   98.0 94.0     28.0   1.0     110.0   40.0   192.0 81 21 76   1 2     0   11   98 94     28 1   110 40   192
1154755 MN Dakota 19 school 2713530 200 Independent Districts and Schools HASTINGS PUBLIC SCHOOL DISTRICT 271353000693 130 HASTINGS MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No 2 05 08 2015   grade_7 310.0 7.0 15.0   2.0 4.0     0.0   8.0   170.0 176.0         *         *   346.0 310 7 15   2 4     0   8   170 176                 346
1154760 MN Dodge 20 school 2716980 204 Independent Districts and Schools KASSON-MANTORVILLE SCHOOL DISTRICT 271698002243 40 KASSON-MANTORVILLE MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No 2 05 08 2015   grade_7 161.0 1.0 7.0   0.0 0.0     0.0   0.0   85.0 84.0     1.0   0.0     30.0   19.0   169.0 161 1 7   0 0     0   0   85 84     1 0   30 19   169
1154776 MN Goodhue 25 school 2728950 255 Independent Districts and Schools PINE ISLAND PUBLIC SCHOOL DIST. 272895004143 15 PINE ISLAND MIDDLE Middle School (Grades 5-8) Regular School No 2 05 08 2015   grade_7 80.0 2.0 3.0   0.0 3.0     0.0   0.0   50.0 38.0     0.0   0.0     16.0   9.0   88.0 80 2 3   0 3     0   0   50 38     0 0   16 9   88
1154781 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 2 05 07 2015   grade_7 152.0 10.0 15.0   12.0 8.0     0.0   6.0   108.0 95.0     3.0   1.0     77.0   27.0   203.0 152 10 15   12 8     0   6   108 95     3 1   77 27   203
1154818 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 2 05 07 2015   grade_7 154.0 3.0 9.0   0.0 2.0     0.0   13.0   92.0 89.0     1.0   1.0     46.0   20.0   181.0 154 3 9   0 2     0   13   92 89     1 1   46 20   181
1154862 MN Houston 28 school 2717250 300 Independent Districts and Schools LA CRESCENT-HOKAH SCHOOL DISTRICT 271725004238 50 LA CRESCENT-HOKAH MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No 2 05 08 2015   grade_7 82.0 2.0 0.0   1.0 1.0     0.0   0.0   34.0 52.0     0.0   0.0     13.0   10.0   86.0 82 2 0   1 1     0   0   34 52     0 0   13 10   86
1154867 MN Hubbard 29 school 2728080 309 Independent Districts and Schools PARK RAPIDS PUBLIC SCHOOL DISTRICT 272808001236 80 PARK RAPIDS AREA CENTURY MIDDLE Middle School (Grades 5-8) Regular School No 2 05 08 2015   grade_7 72.0 0.0 0.0   2.0 0.0     0.0   3.0   37.0 40.0     0.0   0.0     27.0   8.0   77.0 72 0 0   2 0     0   3   37 40     0 0   27 8   77
1154872 MN Itasca 31 school 2709480 316 Independent Districts and Schools GREENWAY PUBLIC SCHOOL DISTRICT 270948002785 210 GREENWAY MIDDLE Middle School (Grades 5-8) Regular School No 2 05 08 2015   grade_7 75.0 1.0 1.0   3.0 0.0     0.0   8.0   53.0 35.0     0.0   0.0     49.0   12.0   88.0 75 1 1   3 0     0   8   53 35     0 0   49 12   88
1154877 MN Itasca 31 school 2713170 318 Independent Districts and Schools GRAND RAPIDS PUBLIC SCHOOL DISTRICT 271317000939 370 ROBERT J. ELKINGTON MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No 2 05 08 2015   grade_7 194.0 6.0 1.0   14.0 0.0     0.0   10.0   122.0 103.0     0.0   0.0     67.0   40.0   225.0 194 6 1   14 0     0   10   122 103     0 0   67 40   225
1154882 MN Kandiyohi 34 school 2723400 345 Independent Districts and Schools NEW LONDON-SPICER SCHOOL DISTRICT 272340000948 20 NEW LONDON-SPICER MIDDLE Middle School (Grades 5-8) Regular School No 2 05 08 2015   grade_7 99.0 0.0 5.0   1.0 0.0     0.0   1.0   55.0 51.0     1.0   0.0     27.0   18.0   106.0 99 0 5   1 0     0   1   55 51     1 0   27 18   106
1154891 MN Lyon 42 school 2718940 413 Independent Districts and Schools MARSHALL PUBLIC SCHOOL DISTRICT 271894003715 6 MARSHALL MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No 2 05 08 2015   grade_7 98.0 12.0 22.0   1.0 3.0     0.0   6.0   74.0 68.0     13.0   1.0     57.0   19.0   142.0 98 12 22   1 3     0   6   74 68     13 1   57 19   142
1154896 MN Lincoln 41 school 2718390 415 Independent Districts and Schools LYND PUBLIC SCHOOL DISTRICT 271839004845 40 Lynd Middle School Middle School (Grades 5-8) Regular School No 2 05 08 2015   grade_7 7.0 0.0 8.0   0.0 0.0     0.0   0.0   7.0 8.0     4.0   0.0     9.0   2.0   15.0 7 0 8   0 0     0   0   7 8     4 0   9 2   15
1154909 MN Wright 86 school 2710060 466 Independent Districts and Schools DASSEL-COKATO PUBLIC SCHOOL DIST. 271006002267 4 DASSEL-COKATO MIDDLE Middle School (Grades 5-8) Regular School No 2 05 08 2015   grade_7 155.0 1.0 1.0   2.0 2.0     0.0   0.0   72.0 89.0     0.0   0.0     44.0   16.0   161.0 155 1 1   2 2     0   0   72 89     0 0   44 16   161
1154926 MN Mower 50 school 2703450 492 Independent Districts and Schools AUSTIN PUBLIC SCHOOL DISTRICT 270345000150 300 ELLIS MIDDLE Middle School (Grades 5-8) Regular School No 2 05 08 2015   grade_7 208.0 28.0 85.0   0.0 18.0     1.0   14.0   187.0 167.0     50.0   0.0     205.0   *   354.0 208 28 85   0 18     1   14   187 167     50 0   205     354
1154931 MN Mower 50 school 2713140 495 Independent Districts and Schools GRAND MEADOW PUBLIC SCHOOL DISTRICT 271314000660 20 GRAND MEADOW MIDDLE Middle School (Grades 5-8) Regular School No 2 05 08 2015   grade_7 34.0 1.0 0.0   0.0 0.0     0.0   0.0   22.0 13.0     0.0   0.0     11.0   6.0   35.0 34 1 0   0 0     0   0   22 13     0 0   11 6   35
1154940 MN Nicollet 52 school 2723580 507 Independent Districts and Schools NICOLLET PUBLIC SCHOOL DISTRICT 272358004675 15 Nicollet Middle School Middle School (Grades 5-8) Regular School No 2 05 08 2015   grade_7 27.0 0.0 1.0   0.0 0.0     0.0   0.0   14.0 14.0     0.0   0.0     9.0   3.0   28.0 27 0 1   0 0     0   0   14 14     0 0   9 3   28
1154952 MN Nobles 53 school 2744160 518 Independent Districts and Schools WORTHINGTON PUBLIC SCHOOL DISTRICT 274416001840 4 WORTHINGTON MIDDLE Middle School (Grades 5-8) Regular School No 2 05 08 2015   grade_7 83.0 11.0 89.0   0.0 21.0     0.0   4.0   97.0 111.0     31.0   0.0         *   208.0 83 11 89   0 21     0   4   97 111     31 0         208
1154957 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 2 05 08 2015   grade_7 122.0 1.0 2.0   1.0 3.0     0.0   1.0   67.0 63.0     1.0   0.0     20.0   5.0   130.0 122 1 2   1 3     0   1   67 63     1 0   20 5   130
1154986 MN Otter Tail 56 school 2728230 549 Independent Districts and Schools PERHAM-DENT PUBLIC SCHOOL DISTRICT 272823002535 20 PRAIRIE WIND MIDDLE Middle School (Grades 5-8) Regular School No 2 05 08 2015   grade_7 99.0 1.0 9.0   2.0 0.0     0.0   4.0   70.0 45.0     3.0   0.0     46.0   22.0   115.0 99 1 9   2 0     0   4   70 45     3 0   46 22   115
1155038 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384001567 315 FARNSWORTH AEROSPACE UPPER Middle School (Grades 5-8) Regular School No 2 05 08 2015   grade_7 15.0 39.0 24.0   1.0 113.0     0.0   4.0   119.0 77.0     100.0   4.0     157.0   37.0   196.0 15 39 24   1 113     0   4   119 77     100 4   157 37   196
1155089 MN Scott 70 school 2715750 717 Independent Districts and Schools JORDAN PUBLIC SCHOOL DISTRICT 271575004144 128 JORDAN MIDDLE Middle School (Grades 5-8) Regular School No 2 05 08 2015   grade_7 114.0 3.0 13.0   3.0 3.0     2.0   4.0   70.0 72.0     5.0   0.0     37.0   22.0   142.0 114 3 13   3 3     2   4   70 72     5 0   37 22   142
1155138 MN Stearns 73 school 2732820 748 Independent Districts and Schools SARTELL-ST. STEPHEN SCHOOL DISTRICT 273282001675 50 SARTELL MIDDLE Middle School (Grades 5-8) Regular School No 2 05 08 2015   grade_7 255.0 5.0 1.0   2.0 7.0     0.0   0.0   139.0 131.0         0.0     51.0   37.0   270.0 255 5 1   2 7     0   0   139 131       0   51 37   270
1155147 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 2 05 08 2015   grade_7 2.0 0.0 0.0   5.0 0.0     0.0   0.0   2.0 5.0         *         *   7.0 2 0 0   5 0     0   0   2 5                 7
1155175 MN Winona 85 school 2744070 861 Independent Districts and Schools WINONA AREA PUBLIC SCHOOL DISTRICT 274407001830 6 WINONA MIDDLE Middle School (Grades 5-8) Regular School No 2 05 08 2015   grade_7 191.0 17.0 11.0   1.0 10.0     0.0   3.0   119.0 114.0         *         *   233.0 191 17 11   1 10     0   3   119 114                 233
1155188 MN Wright 86 school 2710170 879 Independent Districts and Schools DELANO PUBLIC SCHOOL DISTRICT 271017000437 15 DELANO MIDDLE Middle School (Grades 5-8) Regular School No 2 05 08 2015   grade_7 180.0 3.0 3.0   1.0 2.0     0.0   0.0   89.0 100.0     0.0   0.0     16.0   18.0   189.0 180 3 3   1 2     0   0   89 100     0 0   16 18   189
1155197 MN Wright 86 school 2732070 883 Independent Districts and Schools ROCKFORD PUBLIC SCHOOL DISTRICT 273207001941 3 ROCKFORD MIDDLE Middle School (Grades 5-8) Regular School No 2 05 08 2015   grade_7 123.0 4.0 11.0   0.0 6.0     0.0   3.0   80.0 67.0     12.0   1.0     36.0   23.0   147.0 123 4 11   0 6     0   3   80 67     12 1   36 23   147
1155202 MN Wright 86 school 2733790 885 Independent Districts and Schools ST. MICHAEL-ALBERTVILLE SCHOOL DIST 273379001536 30 ST. MICHAEL-ALBERTVILLE MIDDLE EAST Middle School (Grades 5-8) Regular School No 2 05 08 2015   grade_7 222.0 5.0 1.0   0.0 2.0     0.0   9.0   124.0 115.0     3.0   0.0     22.0   23.0   239.0 222 5 1   0 2     0   9   124 115     3 0   22 23   239
1155207 MN Wright 86 school 2733790 885 Independent Districts and Schools ST. MICHAEL-ALBERTVILLE SCHOOL DIST 273379004346 90 ST MICHAEL-ALBERTVILLE MIDDLE WEST Middle School (Grades 5-8) Regular School No 2 05 08 2015   grade_7 201.0 4.0 4.0   0.0 8.0     0.0   6.0   112.0 111.0     6.0   0.0     39.0   16.0   223.0 201 4 4   0 8     0   6   112 111     6 0   39 16   223
1155251 MN Goodhue 25 school 2717100 2172 Independent Districts and Schools KENYON-WANAMINGO SCHOOL DISTRICT 271710001741 40 KENYON-WANAMINGO MIDDLE Middle School (Grades 5-8) Regular School No 2 05 08 2015   grade_7 57.0 1.0 8.0   0.0 0.0     0.0   1.0   33.0 34.0     4.0   0.0     24.0   9.0   67.0 57 1 8   0 0     0   1   33 34     4 0   24 9   67
1155264 MN Renville 65 school 2712580 2365 Independent Districts and Schools G.F.W. Public School District 271258000043 2 G.F.W. Middle School Middle School (Grades 5-8) Regular School No 2 05 08 2015   grade_7 41.0 0.0 18.0   0.0 0.0     0.0   1.0   35.0 25.0     6.0   0.0     34.0   13.0   60.0 41 0 18   0 0     0   1   35 25     6 0   34 13   60
1155277 MN Wright 86 school 2700123 2687 Independent Districts and Schools HOWARD LAKE-WAVERLY-WINSTED 270012303350 86 HOWARD LAKE MIDDLE Middle School (Grades 5-8) Regular School No 2 05 08 2015   grade_7 74.0 0.0 2.0   1.0 1.0     0.0   0.0   40.0 38.0     0.0   0.0     21.0   12.0   78.0 74 0 2   1 1     0   0   40 38     0 0   21 12   78
1155282 MN Pipestone 59 school 2700108 2689 Independent Districts and Schools PIPESTONE AREA SCHOOL DISTRICT 270010801264 7 PIPESTONE MIDDLE Middle School (Grades 5-8) Regular School No 2 05 08 2015   grade_7 57.0 2.0 8.0   2.0 2.0     0.0   0.0   40.0 31.0         *         *   71.0 57 2 8   2 2     0   0   40 31                 71
1155300 MN Redwood 64 school 2700182 2897 Independent Districts and Schools REDWOOD AREA SCHOOL DISTRICT 270018202301 3 REDWOOD VALLEY MIDDLE Middle School (Grades 5-8) Regular School No 2 05 08 2015   grade_7 57.0 3.0 4.0   17.0 1.0     0.0   3.0   41.0 44.0     2.0   0.0     36.0   10.0   85.0 57 3 4   17 1     0   3   41 44     2 0   36 10   85
1155313 MN Hennepin 27 school 2721240 1 Special Districts and Schools MINNEAPOLIS PUBLIC SCHOOL DIST. 272124000965 119 FIELD ELEMENTARY Middle School (Grades 5-8) Regular School No 2 05 08 2015   grade_7 86.0 26.0 7.0   1.0 3.0     0.0   1.0   71.0 53.0     1.0   3.0     32.0   31.0   124.0 86 26 7   1 3     0   1   71 53     1 3   32 31   124
1155354 MN Washington 82 school 2700177 4053 Charter Schools NORTH LAKES ACADEMY 270017703045 10 NORTH LAKES ACADEMY Middle School (Grades 5-8) Regular School Yes 2 05 08 2015   grade_7 56.0 2.0 2.0   0.0 2.0     0.0   2.0   34.0 30.0     0.0   0.0     16.0   14.0   64.0 56 2 2   0 2     0   2   34 30     0 0   16 14   64
1155359 MN Hennepin 27 school 2700220 4067 Charter Schools AURORA CHARTER SCHOOL 270022004420 20 AURORA MIDDLE SCHOOL Middle School (Grades 5-8) Regular School Yes 2 05 08 2015   grade_7 0.0 0.0 45.0   0.0 0.0     0.0   0.0   20.0 25.0     18.0   0.0         1.0   45.0 0 0 45   0 0     0   0   20 25     18 0     1   45
1155364 MN Ramsey 62 school 2700186 4074 Charter Schools AFSA HIGH SCHOOL 270018604854 20 AFSA Middle School Middle School (Grades 5-8) Regular School Yes 2 05 08 2015   grade_7 28.0 4.0 2.0   0.0 2.0     0.0   6.0   26.0 16.0         *         *   42.0 28 4 2   0 2     0   6   26 16                 42
1155372 MN Hennepin 27 school 2700189 4078 Charter Schools Minnesota International Middle Charter 270018903142 10 Minnesota International Middle Charter School Middle School (Grades 5-8) Regular School Yes 2 05 08 2015   grade_7 1.0 99.0 0.0   0.0 0.0     0.0   0.0   51.0 49.0     64.0   2.0         10.0   100.0 1 99 0   0 0     0   0   51 49     64 2     10   100
1155385 MN Hennepin 27 school 2700357 4115 Charter Schools MINNEAPOLIS ACADEMY CHARTER SCHOOL 270035704101 10 MINNEAPOLIS ACADEMY CHARTER SCHOOL Middle School (Grades 5-8) Regular School Yes 2 05 08 2015   grade_7 3.0 14.0 22.0   1.0 1.0     0.0   0.0   17.0 24.0     16.0   0.0         6.0   41.0 3 14 22   1 1     0   0   17 24     16 0     6   41
1155390 MN Washington 82 school 2700362 4120 Charter Schools ST. CROIX PREPARATORY ACADEMY 270036204222 20 ST CROIX PREPARATORY ACADEMY MIDDLE Middle School (Grades 5-8) Regular School Yes 2 05 08 2015   grade_7 81.0 1.0 4.0   0.0 5.0     0.0   0.0   39.0 52.0     0.0   0.0     7.0   4.0   91.0 81 1 4   0 5     0   0   39 52     0 0   7 4   91
1155411 MN Ramsey 62 school 2700292 4164 Charter Schools LAURA JEFFREY ACADEMY CHARTER 270029203713 10 LAURA JEFFREY ACADEMY CHARTER Middle School (Grades 5-8) Regular School Yes 2 05 08 2015   grade_7 15.0 15.0 4.0   0.0 5.0     0.0   6.0   0.0 45.0     0.0   0.0     25.0   16.0   45.0 15 15 4   0 5     0   6   0 45     0 0   25 16   45
1155416 MN Hennepin 27 school 2700288 4170 Charter Schools HIAWATHA ACADEMIES 270028804599 11 Hiawatha College Prep Middle School (Grades 5-8) Regular School Yes 2 05 08 2015   grade_7 1.0 3.0 79.0   1.0 0.0     0.0   0.0   46.0 38.0     68.0   1.0         7.0   84.0 1 3 79   1 0     0   0   46 38     68 1     7   84
1155421 MN Hennepin 27 school 2700308 4191 Charter Schools KIPP MINNESOTA CHARTER SCHOOL 270030804244 10 KIPP MINNESOTA CHARTER SCHOOL Middle School (Grades 5-8) Regular School Yes 2 05 08 2015   grade_7 1.0 57.0 1.0   0.0 0.0     0.0   1.0   33.0 27.0     0.0   1.0         13.0   60.0 1 57 1   0 0     0   1   33 27     0 1     13   60
1155426 MN Hennepin 27 school 2700333 4199 Charter Schools PARNASSUS PREPARATORY CHARTER SCH 270033304837 20 Parnassus Preparatory School-Logic Middle School (Grades 5-8) Regular School Yes 2 05 08 2015   grade_7 25.0 10.0 1.0   0.0 3.0     0.0   5.0   13.0 31.0     3.0   0.0     10.0   3.0   44.0 25 10 1   0 3     0   5   13 31     3 0   10 3   44
1156495 MN Hennepin 27 school 2700245 4131 Charter Schools METRO SCHOOLS CHARTER 270024503573 10 METRO SCHOOLS CHARTER Senior High School (Grades 9-12) Regular School Yes 4 05 12 2015   grade_7 0.0 25.0 0.0   0.0 0.0     0.0   0.0   10.0 15.0     20.0   0.0         6.0   25.0 0 25 0   0 0     0   0   10 15     20 0     6   25
1156573 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 Education School No 2 05 08 2015   grade_7 4.0 7.0 0.0   0.0 0.0     0.0   0.0   5.0 6.0     0.0   0.0     9.0   0.0   11.0 4 7 0   0 0     0   0   5 6     0 0   9 0   11
1156653 MN Clay 14 school 2721420 152 Independent Districts and Schools MOORHEAD PUBLIC SCHOOL DISTRICT 272142000462 980 Red River Area Learning Center Public Area Learning Center ALC (State approved) Alternative Education School No 4 05 12 2015   grade_7 0.0 0.0 2.0   3.0 0.0     0.0   1.0   3.0 3.0         *         *   6.0 0 0 2   3 0     0   1   3 3                 6
1156666 MN Crow Wing 18 school 2706090 181 Independent Districts and Schools BRAINERD PUBLIC SCHOOL DISTRICT 270609002982 21 MIDDLE LEVEL ALTERNATIVE PROGRAM Public Area Learning Center ALC (State approved) Alternative Education School No 2 05 08 2015   grade_7 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
1156755 MN Hubbard 29 school 2728080 309 Independent Districts and Schools PARK RAPIDS PUBLIC SCHOOL DISTRICT 272808004671 81 Century Middle School Within A School Public Area Learning Center ALC (State approved) Alternative Education School No 2 05 08 2015   grade_7 19.0 0.0 0.0   1.0 0.0     0.0   1.0   11.0 10.0     0.0   0.0     13.0   11.0   21.0 19 0 0   1 0     0   1   11 10     0 0   13 11   21
1156768 MN Itasca 31 school 2713170 318 Independent Districts and Schools GRAND RAPIDS PUBLIC SCHOOL DISTRICT 271317000940 375 MIDDLE AREA LEARNING CENTER Public Area Learning Center ALC (State approved) Alternative Education School No 2 05 08 2015   grade_7 40.0 1.0 2.0   2.0 0.0     0.0   1.0   23.0 23.0     0.0   0.0     19.0   *   46.0 40 1 2   2 0     0   1   23 23     0 0   19     46
1157462 MN Nobles 53 school 2744160 518 Independent Districts and Schools WORTHINGTON PUBLIC SCHOOL DISTRICT 274416004426 14 WEST ACADEMY Special Education Special Education School No 4 05 12 2015   grade_7 0.0 0.0 1.0   0.0 1.0     0.0   0.0   2.0 0.0         *         *   2.0 0 0 1   0 1     0   0   2 0                 2
1157819 MN Hennepin 27 school 2700025 287 Intermediate Districts and Schools INTERMEDIATE SCHOOL DISTRICT 287 270002503216 453 EXPLORE Special Education Special Education School No 4 05 12 2015   grade_7 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
1157882 MN Ramsey 62 school 2702264 916 Intermediate Districts and Schools NORTHEAST METRO 916 270226402064 15 Bellaire Education Center Special Education Special Education School No 4 05 12 2015   grade_7 1.0 1.0 0.0   0.0 0.0     0.0   1.0   3.0 0.0         *         *   3.0 1 1 0   0 0     0   1   3 0                 3
1157892 MN Ramsey 62 school 2702264 916 Intermediate Districts and Schools NORTHEAST METRO 916 270226402093 36 ALP @ CAPITOL VIEW CENTER Special Education Special Education School No 4 05 12 2015   grade_7 3.0 4.0 1.0   0.0 0.0     0.0   0.0   7.0 1.0         *         *   8.0 3 4 1   0 0     0   0   7 1                 8
1157901 MN Ramsey 62 school 2702264 916 Intermediate Districts and Schools NORTHEAST METRO 916 270226404149 37 CREATIVE ALTERNATIVES PROGRAM Special Education Special Education School No 4 05 12 2015   grade_7 2.0 1.0 1.0   0.0 1.0     0.0   0.0   4.0 1.0         *         *   5.0 2 1 1   0 1     0   0   4 1                 5
1157928 MN Ramsey 62 school 2702264 916 Intermediate Districts and Schools NORTHEAST METRO 916 270226402108 56 SOUTH CAMPUS 916 Special Education Special Education School No 4 05 12 2015   grade_7 4.0 4.0 0.0   0.0 1.0     0.0   1.0   9.0 1.0     0.0   0.0     5.0   *   10.0 4 4 0   0 1     0   1   9 1     0 0   5     10
1158053 MN Otter Tail 56 school 2700043 935 Special Education Cooperatives FERGUS FALLS AREA SP. ED. COOP. 270004304316 14 FERGUS FALLS ELEMENTARY SP ED 5-8 Special Education Special Education School No 2 05 09 2015   grade_7 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
1158665 MN Dakota 19 school 2713530 200 Independent Districts and Schools HASTINGS PUBLIC SCHOOL DISTRICT 271353000559 137 Harbor Educational Program Educational Oversight to Public Residential Care & Treatment (State approved) Alternative Education School No 4 05 12 2015   grade_7 0.0 0.0 1.0   0.0 0.0     0.0   1.0   2.0 0.0         *         *   2.0 0 0 1   0 0     0   1   2 0                 2
1158736 MN Mille Lacs 48 school 2725050 480 Independent Districts and Schools ONAMIA PUBLIC SCHOOL DISTRICT 272505000957 30 MILLE LACS ACADEMY (NEXUS) Educational Oversight to Public Residential Care & Treatment (State approved) Alternative Education School No 4 05 12 2015   grade_7 7.0 3.0 1.0   1.0 0.0     0.0   0.0   12.0 0.0     0.0   0.0         9.0   12.0 7 3 1   1 0     0   0   12 0     0 0     9   12
1158744 MN Nicollet 52 school 2733870 508 Independent Districts and Schools ST. PETER PUBLIC SCHOOL DISTRICT 273387000973 60 HOFFMAN LEARNING CENTER Educational Oversight to Public Residential Care & Treatment (State approved) Alternative Education School No 4 05 12 2015   grade_7 0.0 0.0 1.0   0.0 0.0     0.0   0.0   1.0 0.0         *         *   1.0 0 0 1   0 0     0   0   1 0                 1

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