Data source: Big Local News · About: Big Local

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

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
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
694053 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384001594 494 CAPITOL HILL MAGNET/RONDO Elementary School (Grades PK-6) Regular School No Elementary 01 08 2017   grade_6 82.0 56.0 13.0   0.0 49.0     0.0   2.0   111.0 91.0     22.0   0.0     95.0   11.0   202.0 82 56 13   0 49     0   2   111 91     22 0   95 11   202
694761 MN Stearns 73 school 2702930 745 Independent Districts and Schools ALBANY PUBLIC SCHOOL DISTRICT 270293000062 10 ALBANY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 01 06 2017   grade_6 61.0 0.0 5.0   0.0 0.0     0.0   1.0   30.0 37.0     2.0   0.0     19.0   13.0   67.0 61 0 5   0 0     0   1   30 37     2 0   19 13   67
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
696988 MN Ramsey 62 school 2700344 4105 Charter Schools GREAT RIVER SCHOOL 270034404665 20 Great River Elementary School Elementary School (Grades PK-6) Regular School Yes Elementary 01 06 2017   grade_6 15.0 2.0 1.0   0.0 2.0     0.0   1.0   15.0 6.0     0.0   0.0     1.0   6.0   21.0 15 2 1   0 2     0   1   15 6     0 0   1 6   21
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
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
701034 MN Hennepin 27 school 2700025 287 Intermediate Districts and Schools INTERMEDIATE SCHOOL DISTRICT 287 270002503542 479 SAFE Special Education Special Education School No Other 01 12 2017   grade_6 1.0 2.0 0.0   0.0 0.0     0.0   0.0   3.0 0.0         *         *   3.0 1 2 0   0 0     0   0   3 0                 3
701046 MN Hennepin 27 school 2700025 287 Intermediate Districts and Schools INTERMEDIATE SCHOOL DISTRICT 287 270002503229 480 STRIVE SECONDARY Special Education Special Education School No Other 01 12 2017   grade_6 1.0 2.0 0.0   0.0 0.0     0.0   0.0   3.0 0.0         *         *   3.0 1 2 0   0 0     0   0   3 0                 3
701059 MN Hennepin 27 school 2700025 287 Intermediate Districts and Schools INTERMEDIATE SCHOOL DISTRICT 287 270002503234 486 CIP Special Education Special Education School No Other 01 12 2017   grade_6 4.0 0.0 0.0   0.0 1.0     0.0   1.0   6.0 0.0         *         *   6.0 4 0 0   0 1     0   1   6 0                 6
701074 MN Scott 70 school 2700420 288 Intermediate Districts and Schools Southwest Metro Intermediate 288 270042005038 12 SW Metro Level 4 Programs Special Education Special Education School No Other 01 12 2017   grade_6 6.0 2.0 0.0   0.0 0.0     0.0   1.0   9.0 0.0         *         *   9.0 6 2 0   0 0     0   1   9 0                 9
701299 MN Mille Lacs 48 school 2700318 6079 Special Education Cooperatives RUM RIVER SPECIAL EDUCATION COOP 270031804296 10 RUM RIVER NORTH Special Education Special Education School No Other 01 12 2017   grade_6 8.0 0.0 0.0   0.0 0.0     0.0   0.0   7.0 1.0         *         *   8.0 8 0 0   0 0     0   0   7 1                 8
701397 MN Cottonwood 17 school 2700086 991 Service Cooperative (ECSU Region) Region 6 and 8-SW/WC Service Cooperative 270008604168 16 RED ROCK RIDGE SETTING IV Special Education Special Education School No Other 01 12 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
701546 MN Stearns 73 school 2791455 6026 Education Districts WEST CENTRAL EDUCATION DISTRICT 279145503591 24 BEACON PROGRAM W CENTRAL ED. DIST. Special Education Special Education School No Other 01 11 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
702082 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 School No Other 01 12 2017   grade_6 6.0 1.0 0.0   2.0 0.0     0.0   5.0   12.0 2.0     0.0   0.0     11.0   9.0   14.0 6 1 0   2 0     0   5   12 2     0 0   11 9   14
693604 MN Polk 60 school 2709720 593 Independent Districts and Schools CROOKSTON PUBLIC SCHOOL DISTRICT 270972000414 80 HIGHLAND ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 02 06 2017   grade_6 71.0 5.0 21.0   3.0 0.0     0.0   9.0   52.0 57.0     4.0   5.0     56.0   35.0   109.0 71 5 21   3 0     0   9   52 57     4 5   56 35   109
700841 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 Other 02 12 2017   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
701356 MN Wright 86 school 2700413 6090 Special Education Cooperatives Sherburne and Northern Wright Special Education Cooperative 270041304947 80 Becker Intermediate School - SNW Special Education Special Education School No Elementary 02 06 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
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
702265 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 School No Other 02 12 2017   grade_6 1.0 0.0 0.0   0.0 0.0     0.0   2.0   3.0 0.0         *         *   3.0 1 0 0   0 0     0   2   3 0                 3
691602 MN Dakota 19 school 2711820 192 Independent Districts and Schools FARMINGTON PUBLIC SCHOOL DISTRICT 271182004816 155 Gateway Academy Elementary School (Grades PK-6) Regular School No Elementary 03 08 2017   grade_6 5.0 2.0 1.0   0.0 1.0     0.0   1.0   8.0 2.0         0.0         *   10.0 5 2 1   0 1     0   1   8 2       0         10
692856 MN Kanabec 33 school 2721480 332 Independent Districts and Schools MORA PUBLIC SCHOOL DISTRICT 272148001097 30 TRAILVIEW ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 03 06 2017   grade_6 113.0 1.0 4.0   1.0 3.0     0.0   2.0   69.0 55.0     0.0   0.0     47.0   16.0   124.0 113 1 4   1 3     0   2   69 55     0 0   47 16   124
693071 MN Marshall 45 school 2723550 441 Independent Districts and Schools MARSHALL COUNTY CENTRAL SCHOOLS 272355001158 10 NEWFOLDEN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 03 06 2017   grade_6 28.0 0.0 0.0   0.0 0.0     0.0   1.0   17.0 12.0     0.0   0.0     10.0   3.0   29.0 28 0 0   0 0     0   1   17 12     0 0   10 3   29
693293 MN Nicollet 52 school 2733870 508 Independent Districts and Schools ST. PETER PUBLIC SCHOOL DISTRICT 273387001638 30 North Intermediate School Elementary School (Grades PK-6) Regular School No Elementary 03 06 2017   grade_6 137.0 6.0 18.0   0.0 2.0     0.0   5.0   83.0 85.0     5.0   2.0     65.0   30.0   168.0 137 6 18   0 2     0   5   83 85     5 2   65 30   168
694335 MN Saint Louis 69 school 2713980 701 Independent Districts and Schools HIBBING PUBLIC SCHOOL DISTRICT 271398001529 310 Lincoln Elementary Elementary School (Grades PK-6) Regular School No Elementary 03 06 2017   grade_6 161.0 2.0 2.0   4.0 1.0     0.0   14.0   92.0 92.0     0.0   2.0     89.0   29.0   184.0 161 2 2   4 1     0   14   92 92     0 2   89 29   184
694355 MN Saint Louis 69 school 2741040 706 Independent Districts and Schools VIRGINIA PUBLIC SCHOOL DISTRICT 274104001716 30 ROOSEVELT ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 03 06 2017   grade_6 100.0 1.0 2.0   4.0 1.0     0.0   16.0   67.0 57.0     0.0   0.0     56.0   23.0   124.0 100 1 2   4 1     0   16   67 57     0 0   56 23   124
694454 MN Scott 70 school 2704050 716 Independent Districts and Schools BELLE PLAINE PUBLIC SCHOOL DISTRICT 270405003718 11 OAK CREST ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 03 06 2017   grade_6 102.0 2.0 5.0   2.0 2.0     1.0   4.0   53.0 65.0     1.0   0.0     25.0   11.0   118.0 102 2 5   2 2     1   4   53 65     1 0   25 11   118
695887 MN Martin 46 school 2718960 2448 Independent Districts and Schools MARTIN COUNTY WEST SCHOOL DISTRICT 271896000072 15 TRIMONT ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 03 06 2017   grade_6 51.0 2.0 4.0   0.0 0.0     0.0   0.0   27.0 30.0         0.0     16.0   7.0   57.0 51 2 4   0 0     0   0   27 30       0   16 7   57
696032 MN Wabasha 79 school 2745735 2805 Independent Districts and Schools ZUMBROTA-MAZEPPA SCHOOL DISTRICT 274573500200 1 ZUMBROTA-MAZEPPA ELEMENTARY SCHOOL Elementary School (Grades PK-6) Regular School No Elementary 03 06 2017   grade_6 79.0 3.0 5.0   0.0 1.0     0.0   0.0   40.0 48.0     2.0   0.0     18.0   11.0   88.0 79 3 5   0 1     0   0   40 48     2 0   18 11   88
696088 MN Mcleod 43 school 2700128 2859 Independent Districts and Schools GLENCOE-SILVER LAKE SCHOOL DISTRICT 270012801444 30 LAKESIDE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 03 06 2017   grade_6 103.0 0.0 32.0   1.0 0.0     0.0   1.0   80.0 57.0     5.0   1.0     61.0   27.0   137.0 103 0 32   1 0     0   1   80 57     5 1   61 27   137
696339 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124000988 134 LK NOKOMIS COMM-KEEWAYDIN CAMPUS Elementary School (Grades PK-6) Regular School No Elementary 03 08 2017   grade_6 36.0 14.0 18.0   2.0 3.0     0.0   1.0   32.0 42.0     6.0   2.0     40.0   4.0   74.0 36 14 18   2 3     0   1   32 42     6 2   40 4   74
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
701801 MN Mille Lacs 48 school 2730030 477 Independent Districts and Schools PRINCETON PUBLIC SCHOOL DISTRICT 273003004927 80 Princeton Online Academy 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   1.0 0.0         *         *   1.0 1 0 0   0 0     0   0   1 0                 1
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
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
692599 MN Hennepin 27 school 2731780 281 Independent Districts and Schools ROBBINSDALE PUBLIC SCHOOL DISTRICT 273178004952 401 The FAIR School - Crystal Elementary School (Grades PK-6) Regular School No Elementary 04 08 2017   grade_6 40.0 45.0 11.0   1.0 3.0     1.0   10.0   46.0 65.0     8.0   1.0     59.0   16.0   111.0 40 45 11   1 3     1   10   46 65     8 1   59 16   111
694099 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384001612 528 LINWOOD MONROE ARTS PLUS UPPER Elementary School (Grades PK-6) Regular School No Elementary 04 08 2017   grade_6 49.0 40.0 7.0   1.0 32.0     0.0   6.0   55.0 80.0     42.0   2.0     83.0   27.0   135.0 49 40 7   1 32     0   6   55 80     42 2   83 27   135
694297 MN Saint Louis 69 school 2708910 695 Independent Districts and Schools CHISHOLM PUBLIC SCHOOL DISTRICT 270891000356 301 CHISHOLM ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 04 06 2017   grade_6 43.0 2.0 1.0   0.0 0.0     0.0   3.0   24.0 25.0     0.0   0.0     22.0   10.0   49.0 43 2 1   0 0     0   3   24 25     0 0   22 10   49
694974 MN Waseca 81 school 2741880 829 Independent Districts and Schools WASECA PUBLIC SCHOOL DISTRICT 274188001746 40 WASECA INTERMEDIATE SCHOOL Elementary School (Grades PK-6) Regular School No Elementary 04 06 2017   grade_6 128.0 2.0 22.0   3.0 0.0     0.0   0.0   72.0 83.0     6.0   2.0     52.0   30.0   155.0 128 2 22   3 0     0   0   72 83     6 2   52 30   155
694986 MN Washington 82 school 2712270 831 Independent Districts and Schools FOREST LAKE PUBLIC SCHOOL DISTRICT 271227000594 626 FOREST LAKE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 04 06 2017   grade_6 108.0 2.0 5.0   0.0 6.0     1.0   7.0   67.0 62.0     5.0   1.0     40.0   19.0   129.0 108 2 5   0 6     1   7   67 62     5 1   40 19   129
696183 MN Wabasha 79 school 2700287 2899 Independent Districts and Schools PLAINVIEW-ELGIN-MILLVILLE 270028703667 20 PLAINVIEW-ELGIN-MILLVILLE 4-6 Elementary School (Grades PK-6) Regular School No Elementary 04 06 2017   grade_6 103.0 0.0 13.0   0.0 0.0     0.0   5.0   59.0 62.0     2.0   0.0     40.0   21.0   121.0 103 0 13   0 0     0   5   59 62     2 0   40 21   121
696318 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124000969 121 LAKE HARRIET UPPER SCHOOL Elementary School (Grades PK-6) Regular School No Elementary 04 08 2017   grade_6 116.0 4.0 4.0   0.0 6.0     0.0   2.0   57.0 75.0     5.0   0.0     20.0   13.0   132.0 116 4 4   0 6     0   2   57 75     5 0   20 13   132
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
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
698402 MN Fillmore 23 school 2700007 2137 Independent Districts and Schools KINGSLAND PUBLIC SCHOOL DISTRICT 270000701845 20 Kingsland Intermediate School Middle School (Grades 5-8) Regular School No Elementary 04 06 2017   grade_6 34.0 0.0 0.0   0.0 0.0     1.0   0.0   19.0 16.0     0.0   0.0     16.0   8.0   35.0 34 0 0   0 0     1   0   19 16     0 0   16 8   35
698410 MN Pope 61 school 2700019 2149 Independent Districts and Schools MINNEWASKA SCHOOL DISTRICT 270001903535 60 Minnewaska Area Intermediate School Middle School (Grades 5-8) Regular School No Elementary 04 06 2017   grade_6 71.0 1.0 0.0   1.0 2.0     0.0   2.0   44.0 33.0         *         *   77.0 71 1 0   1 2     0   2   44 33                 77
698418 MN Morrison 49 school 2733900 2170 Independent Districts and Schools STAPLES-MOTLEY SCHOOL DISTRICT 273390002468 50 MOTLEY-STAPLES MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Elementary 04 07 2017   grade_6 91.0 0.0 2.0   0.0 0.0     0.0   3.0   55.0 41.0     0.0   1.0     50.0   13.0   96.0 91 0 2   0 0     0   3   55 41     0 1   50 13   96
702110 MN Saint Louis 69 school 2711040 709 Independent Districts and Schools DULUTH PUBLIC SCHOOL DISTRICT 271104001589 605 ARROWHEAD JUVENILE CENTER Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No Other 04 12 2017   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
702525 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 School No Other 04 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
690244 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 Other 05 12 2017   grade_6 29.0 0.0 0.0   0.0 0.0     0.0   0.0   15.0 14.0     0.0   0.0     16.0   1.0   29.0 29 0 0   0 0     0   0   15 14     0 0   16 1   29
693058 MN Mahnomen 44 school 2742120 435 Independent Districts and Schools WAUBUN-OGEMA-WHITE EARTH PUBLIC SCH 274212001755 10 WAUBUN ELEMENTARY Elementary School (Grades PK-6) Regular School No Middle 05 06 2017   grade_6 6.0 1.0 1.0   25.0 0.0     0.0   12.0   22.0 23.0     0.0   2.0     31.0   10.0   45.0 6 1 1   25 0     0   12   22 23     0 2   31 10   45
693240 MN Mower 50 school 2703450 492 Independent Districts and Schools AUSTIN PUBLIC SCHOOL DISTRICT 270345004638 280 I.J. HOLTON INTERMEDIATE SCHOOL Elementary School (Grades PK-6) Regular School No Middle 05 06 2017   grade_6 183.0 26.0 92.0   0.0 23.0     1.0   10.0   165.0 170.0         *         *   335.0 183 26 92   0 23     1   10   165 170                 335
694188 MN Redwood 64 school 2721210 635 Independent Districts and Schools MILROY PUBLIC SCHOOL DISTRICT 272121000927 1 MILROY ELEMENTARY Elementary School (Grades PK-6) Regular School No Middle 05 06 2017   grade_6 9.0 0.0 0.0   0.0 0.0     0.0   0.0   3.0 6.0         *         *   9.0 9 0 0   0 0     0   0   3 6                 9
695291 MN Winona 85 school 2718090 857 Independent Districts and Schools LEWISTON-ALTURA PUBLIC SCHOOL DIST. 271809000834 20 LEWISTON-ALTURA INTERMEDIATE EL. Elementary School (Grades PK-6) Regular School No Middle 05 06 2017   grade_6 43.0 0.0 2.0   0.0 0.0     0.0   1.0   23.0 23.0     0.0   1.0     15.0   9.0   46.0 43 0 2   0 0     0   1   23 23     0 1   15 9   46
695584 MN Rice 66 school 2700013 2143 Independent Districts and Schools Waterville-Elysian-Morristown Public School District 270001301103 10 MORRISTOWN ELEMENTARY Elementary School (Grades PK-6) Regular School No Middle 05 06 2017   grade_6 53.0 1.0 6.0   0.0 0.0     0.0   2.0   28.0 34.0     0.0   0.0     17.0   9.0   62.0 53 1 6   0 0     0   2   28 34     0 0   17 9   62
695622 MN Saint Louis 69 school 2700021 2154 Independent Districts and Schools EVELETH-GILBERT SCHOOL DISTRICT 270002100629 20 NELLE SHEAN ELEMENTARY Elementary School (Grades PK-6) Regular School No Middle 05 06 2017   grade_6 88.0 1.0 1.0   1.0 0.0     0.0   7.0   49.0 49.0     0.0   0.0         12.0   98.0 88 1 1   1 0     0   7   49 49     0 0     12   98
695632 MN Wadena 80 school 2700022 2155 Independent Districts and Schools WADENA-DEER CREEK SCHOOL DISTRICT 270002204587 3 WADENA-DEER CREEK 5TH AND 6TH GRADE Elementary School (Grades PK-6) Regular School No Middle 05 06 2017   grade_6 74.0 4.0 3.0   0.0 0.0     0.0   3.0   47.0 37.0     0.0   1.0     41.0   19.0   84.0 74 4 3   0 0     0   3   47 37     0 1   41 19   84
695866 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 2017   grade_6 56.0 0.0 4.0   2.0 0.0     0.0   3.0   36.0 29.0     0.0   1.0     28.0   10.0   65.0 56 0 4   2 0     0   3   36 29     0 1   28 10   65
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
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
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
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
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
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
697822 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 Middle 05 08 2017   grade_6 474.0 13.0 3.0   6.0 4.0     1.0   14.0   242.0 273.0         3.0     209.0   93.0   515.0 474 13 3   6 4     1   14   242 273       3   209 93   515
697827 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 Middle 05 08 2017   grade_6 131.0 3.0 0.0   1.0 0.0     0.0   4.0   68.0 71.0     0.0   0.0     31.0   19.0   139.0 131 3 0   1 0     0   4   68 71     0 0   31 19   139
697888 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 Middle 05 08 2017   grade_6 93.0 22.0 28.0   0.0 14.0     0.0   14.0   85.0 86.0     12.0   4.0     54.0   30.0   171.0 93 22 28   0 14     0   14   85 86     12 4   54 30   171
697893 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 Middle 05 08 2017   grade_6 83.0 15.0 66.0   0.0 2.0     0.0   12.0   85.0 93.0     19.0   2.0     90.0   23.0   178.0 83 15 66   0 2     0   12   85 93     19 2   90 23   178
697902 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 Middle 05 08 2017   grade_6 282.0 5.0 9.0   1.0 2.0     0.0   12.0   172.0 139.0         0.0         *   311.0 282 5 9   1 2     0   12   172 139       0         311
697907 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 Middle 05 08 2017   grade_6 163.0 1.0 3.0   0.0 0.0     0.0   2.0   83.0 86.0     0.0   0.0     25.0   18.0   169.0 163 1 3   0 0     0   2   83 86     0 0   25 18   169
697923 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 Middle 05 08 2017   grade_6 85.0 1.0 1.0   0.0 1.0     0.0   1.0   48.0 41.0     0.0   0.0     15.0   8.0   89.0 85 1 1   0 1     0   1   48 41     0 0   15 8   89
697928 MN Goodhue 25 school 2730480 256 Independent Districts and Schools RED WING PUBLIC SCHOOL DISTRICT 273048001298 109 TWIN BLUFF MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 05 07 2017   grade_6 157.0 7.0 20.0   6.0 1.0     0.0   15.0   101.0 105.0     2.0   0.0     70.0   32.0   206.0 157 7 20   6 1     0   15   101 105     2 0   70 32   206
697965 MN Hennepin 27 school 2722920 277 Independent Districts and Schools WESTONKA PUBLIC SCHOOL DISTRICT 272292001109 63 GRANDVIEW MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 05 07 2017   grade_6 175.0 3.0 8.0   2.0 3.0     0.0   7.0   98.0 100.0     0.0   1.0     29.0   28.0   198.0 175 3 8   2 3     0   7   98 100     0 1   29 28   198
698025 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 Middle 05 08 2017   grade_6 83.0 2.0 4.0   0.0 1.0     0.0   0.0   49.0 41.0     0.0   0.0     19.0   10.0   90.0 83 2 4   0 1     0   0   49 41     0 0   19 10   90
698030 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 Middle 05 08 2017   grade_6 104.0 0.0 7.0   3.0 0.0     0.0   6.0   60.0 60.0     0.0   0.0     53.0   16.0   120.0 104 0 7   3 0     0   6   60 60     0 0   53 16   120
698035 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 Middle 05 08 2017   grade_6 62.0 0.0 5.0   6.0 0.0     0.0   0.0   43.0 30.0     0.0   0.0     37.0   14.0   73.0 62 0 5   6 0     0   0   43 30     0 0   37 14   73
698040 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 Middle 05 08 2017   grade_6 213.0 0.0 3.0   7.0 2.0     0.0   22.0   124.0 123.0     0.0   0.0     78.0   48.0   247.0 213 0 3   7 2     0   22   124 123     0 0   78 48   247
698045 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 Middle 05 08 2017   grade_6 107.0 0.0 6.0   0.0 0.0     1.0   1.0   63.0 52.0     1.0   0.0     28.0   14.0   115.0 107 0 6   0 0     1   1   63 52     1 0   28 14   115
698054 MN Lyon 42 school 2718940 413 Independent Districts and Schools MARSHALL PUBLIC SCHOOL DISTRICT 271894003715 6 MARSHALL MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 05 08 2017   grade_6 110.0 24.0 17.0   0.0 12.0     0.0   7.0   87.0 83.0     21.0   0.0     78.0   21.0   170.0 110 24 17   0 12     0   7   87 83     21 0   78 21   170
698059 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 Middle 05 08 2017   grade_6 2.0 0.0 3.0   0.0 0.0     0.0   1.0   4.0 2.0         *         *   6.0 2 0 3   0 0     0   1   4 2                 6
698068 MN Meeker 47 school 2718210 465 Independent Districts and Schools LITCHFIELD PUBLIC SCHOOL DISTRICT 271821000838 30 Litchfield Middle School Middle School (Grades 5-8) Regular School No Middle 05 08 2017   grade_6 110.0 1.0 8.0   0.0 1.0     0.0   4.0   56.0 68.0     3.0   0.0     56.0   22.0   124.0 110 1 8   0 1     0   4   56 68     3 0   56 22   124
698073 MN Wright 86 school 2710060 466 Independent Districts and Schools DASSEL-COKATO PUBLIC SCHOOL DIST. 271006002267 4 DASSEL-COKATO MIDDLE Middle School (Grades 5-8) Regular School No Middle 05 08 2017   grade_6 140.0 1.0 6.0   1.0 1.0     0.0   3.0   87.0 65.0     3.0   0.0     57.0   22.0   152.0 140 1 6   1 1     0   3   87 65     3 0   57 22   152
698093 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 Middle 05 08 2017   grade_6 37.0 2.0 1.0   0.0 0.0     0.0   1.0   18.0 23.0     0.0   1.0     9.0   5.0   41.0 37 2 1   0 0     0   1   18 23     0 1   9 5   41
698102 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 Middle 05 08 2017   grade_6 29.0 0.0 5.0   0.0 0.0     0.0   1.0   13.0 22.0     0.0   0.0     8.0   9.0   35.0 29 0 5   0 0     0   1   13 22     0 0   8 9   35
698114 MN Nobles 53 school 2744160 518 Independent Districts and Schools WORTHINGTON PUBLIC SCHOOL DISTRICT 274416001840 4 WORTHINGTON MIDDLE Middle School (Grades 5-8) Regular School No Middle 05 08 2017   grade_6 64.0 17.0 109.0   2.0 32.0     1.0   5.0   123.0 107.0         *     164.0   *   230.0 64 17 109   2 32     1   5   123 107           164     230
698151 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 Middle 05 08 2017   grade_6 105.0 0.0 7.0   1.0 0.0     0.0   5.0   53.0 65.0     2.0   0.0     41.0   13.0   118.0 105 0 7   1 0     0   5   53 65     2 0   41 13   118
698203 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 Middle 05 08 2017   grade_6 9.0 29.0 14.0   0.0 104.0     0.0   9.0   73.0 92.0     53.0   0.0     135.0   21.0   165.0 9 29 14   0 104     0   9   73 92     53 0   135 21   165
698236 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 Middle 05 08 2017   grade_6 168.0 0.0 2.0   0.0 1.0     0.0   8.0   83.0 96.0     2.0   1.0     22.0   18.0   179.0 168 0 2   0 1     0   8   83 96     2 1   22 18   179
698253 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 Middle 05 08 2017   grade_6 116.0 4.0 13.0   2.0 3.0     0.0   5.0   72.0 71.0     8.0   1.0     32.0   23.0   143.0 116 4 13   2 3     0   5   72 71     8 1   32 23   143
698302 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 Middle 05 08 2017   grade_6 304.0 7.0 11.0   2.0 6.0     0.0   7.0   183.0 154.0     2.0   0.0     51.0   53.0   337.0 304 7 11   2 6     0   7   183 154     2 0   51 53   337
698311 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 2017   grade_6 4.0 0.0 0.0   10.0 0.0     0.0   0.0   6.0 8.0     0.0   0.0     11.0   3.0   14.0 4 0 0   10 0     0   0   6 8     0 0   11 3   14
698316 MN Wadena 80 school 2720580 821 Independent Districts and Schools MENAHGA PUBLIC SCHOOL DISTRICT 272058005019 20 Menahga Middle School Middle School (Grades 5-8) Regular School No Middle 05 08 2017   grade_6 85.0 0.0 1.0   0.0 1.0     0.0   3.0   40.0 50.0     3.0   0.0     56.0   18.0   90.0 85 0 1   0 1     0   3   40 50     3 0   56 18   90
698344 MN Winona 85 school 2744070 861 Independent Districts and Schools WINONA AREA PUBLIC SCHOOL DISTRICT 274407001830 6 WINONA MIDDLE Middle School (Grades 5-8) Regular School No Middle 05 08 2017   grade_6 189.0 10.0 7.0   1.0 6.0     0.0   13.0   112.0 114.0     9.0   1.0     76.0   45.0   226.0 189 10 7   1 6     0   13   112 114     9 1   76 45   226
698357 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 Middle 05 08 2017   grade_6 187.0 0.0 3.0   0.0 1.0     0.0   9.0   91.0 109.0     3.0   0.0     22.0   27.0   200.0 187 0 3   0 1     0   9   91 109     3 0   22 27   200
698366 MN Wright 86 school 2732070 883 Independent Districts and Schools ROCKFORD PUBLIC SCHOOL DISTRICT 273207001941 3 ROCKFORD MIDDLE Middle School (Grades 5-8) Regular School No Middle 05 08 2017   grade_6 96.0 7.0 11.0   2.0 5.0     0.0   5.0   57.0 69.0     3.0   0.0     41.0   11.0   126.0 96 7 11   2 5     0   5   57 69     3 0   41 11   126
698371 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 Middle 05 08 2017   grade_6 218.0 6.0 3.0   0.0 5.0     0.0   8.0   127.0 113.0     1.0   1.0     26.0   23.0   240.0 218 6 3   0 5     0   8   127 113     1 1   26 23   240
698376 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 Middle 05 08 2017   grade_6 219.0 12.0 7.0   0.0 4.0     0.0   12.0   145.0 109.0     5.0   0.0     31.0   25.0   254.0 219 12 7   0 4     0   12   145 109     5 0   31 25   254
698422 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 Middle 05 08 2017   grade_6 56.0 0.0 4.0   0.0 0.0     0.0   2.0   29.0 33.0     2.0   0.0     21.0   8.0   62.0 56 0 4   0 0     0   2   29 33     2 0   21 8   62
698435 MN Grant 26 school 2700104 2342 Independent Districts and Schools WEST CENTRAL AREA 270010404375 4 WCA Middle School Middle School (Grades 5-8) Regular School No Middle 05 08 2017   grade_6 58.0 0.0 4.0   0.0 0.0     0.0   1.0   37.0 26.0     0.0   0.0     25.0   11.0   63.0 58 0 4   0 0     0   1   37 26     0 0   25 11   63

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