Data source: Big Local News · About: Big Local

4,774 rows where grade = "grade_7" and state = "MN" sorted by ccd_school_low_grade

View and edit SQL

year

grade

  • grade_7 · 4,674
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
1721053 MN Mille Lacs 48 school 2725050 480 Independent Districts and Schools Onamia Public School District 272505005107 50 Onamia Intermediate School Middle School (Grades 5-8) Regular School No Other 03 09 2021   grade_7 18 0 3   28 1     0   5   26 29     *   *     *   *   55 18 0 3   28 1     0   5   26 29                 55
1724725 MN Anoka 2 school 2733540 15 Independent Districts and Schools St. Francis Area Schools 273354004917 15 Saints Online Distance Learning Program OLL (State approved) Regular School No Other 03 12 2021   grade_7 2 1 0   0 0     0   0   2 1     *   *     *   *   3 2 1 0   0 0     0   0   2 1                 3
1724959 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 School No Other 03 12 2021   grade_7 0 0 0   1 0     0   0   1 0     *   *     *   *   1 0 0 0   1 0     0   0   1 0                 1
1832686 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124000988 134 Lake Nokomis Comm-Keewaydin Campus Elementary School (Grades PK-6) Regular School No Middle 03 08 2020   grade_7 43.0 13.0 14.0   1.0 1.0     0.0   4.0   44.0 32.0     6.0   3.0     38.0   18.0   76.0 43 13 14   1 1     0   4   44 32     6 3   38 18   76
1834568 MN Mille Lacs 48 school 2725050 480 Independent Districts and Schools Onamia Public School District 272505005107 50 Onamia Intermediate School Middle School (Grades 5-8) Regular School No Other 03 09 2020   grade_7 17.0 0.0 3.0   21.0 0.0     0.0   5.0   20.0 26.0     *   *         *   46.0 17 0 3   21 0     0   5   20 26                 46
1838311 MN Anoka 2 school 2733540 15 Independent Districts and Schools St. Francis Area Schools 273354004917 15 Saints Online Distance Learning Program OLL (State approved) Regular School No Other 03 12 2020   grade_7 2.0 0.0 1.0   0.0 0.0     0.0   0.0   2.0 1.0     *   *         *   3.0 2 0 1   0 0     0   0   2 1                 3
1838527 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 School No Other 03 12 2020   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
1838551 MN Clay 14 school 2721420 152 Independent Districts and Schools Moorhead Public School District 272142002799 970 West Central Academy-N Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No Other 03 12 2020   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
1887233 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124000988 134 Lake Nokomis Community-Keewaydin Campus Elementary School (Grades PK-6) Regular School No Middle 03 08 2018   grade_7 37.0 13.0 17.0   3.0 3.0     0.0   1.0   35.0 39.0     5.0   3.0     41.0   10.0   74.0 37 13 17   3 3     0   1   35 39     5 3   41 10   74
1889044 MN Mille Lacs 48 school 2725050 480 Independent Districts and Schools Onamia Public School District 272505005107 50 Onamia Intermediate School Middle School (Grades 5-8) Regular School No Other 03 09 2018   grade_7 16.0 2.0 0.0   23.0 0.0     0.0   5.0   32.0 14.0     *   *     *   *   46.0 16 2 0   23 0     0   5   32 14                 46
1891772 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 03 12 2018   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
1892710 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 2018   grade_7 2.0 0.0 0.0   0.0 0.0     0.0   0.0   0.0 2.0     *   *     *   *   2.0 2 0 0   0 0     0   0   0 2                 2
1892772 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 2018   grade_7 1.0 0.0 0.0   1.0 0.0     0.0   0.0   2.0 0.0     *   *     *   *   2.0 1 0 0   1 0     0   0   2 0                 2
1892916 MN Anoka 2 school 2733540 15 Independent Districts and Schools St. Francis Public School District 273354005097 852 Crossroads South Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No Other 03 12 2018   grade_7 3.0 0.0 0.0   0.0 0.0     0.0   1.0   4.0 0.0     *   *     *   *   4.0 3 0 0   0 0     0   1   4 0                 4
1892924 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 School No Other 03 12 2018   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
1892948 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 2018   grade_7 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
1893243 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 03 12 2018   grade_7 3.0 0.0 0.0   0.0 0.0     0.0   2.0   5.0 0.0     *   *     *   *   5.0 3 0 0   0 0     0   2   5 0                 5
1951816 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 Middle 03 08 2019   grade_7 41.0 17.0 11.0   1.0 1.0     0.0   1.0   33.0 39.0     5.0   0.0     35.0   11.0   72.0 41 17 11   1 1     0   1   33 39     5 0   35 11   72
1953640 MN Mille Lacs 48 school 2725050 480 Independent Districts and Schools ONAMIA PUBLIC SCHOOL DISTRICT 272505005107 50 Onamia Intermediate School Middle School (Grades 5-8) Regular School No Other 03 09 2019   grade_7 17.0 2.0 0.0   34.0 0.0     1.0   3.0   27.0 30.0     *   *         *   57.0 17 2 0   34 0     1   3   27 30                 57
1957328 MN Anoka 2 school 2733540 15 Independent Districts and Schools St. Francis Area Schools 273354004917 15 Saints Online Distance Learning Program OLL (State approved) Regular School No Other 03 12 2019   grade_7 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
1957535 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 School No Other 03 12 2019   grade_7 0.0 0.0 0.0   1.0 0.0     0.0   1.0   1.0 1.0     *   *         *   2.0 0 0 0   1 0     0   1   1 1                 2
1957837 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 03 12 2019   grade_7 3.0 0.0 0.0   0.0 1.0     0.0   0.0   4.0 0.0     *   *         *   4.0 3 0 0   0 1     0   0   4 0                 4
691021 MN Benton 5 school 2712240 51 Independent Districts and Schools FOLEY PUBLIC SCHOOL DISTRICT 271224002270 30 FOLEY INTERMEDIATE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 04 08 2017   grade_7 145.0 0.0 1.0   0.0 0.0     0.0   2.0   81.0 67.0     0.0   0.0     41.0   23.0   148.0 145 0 1   0 0     0   2   81 67     0 0   41 23   148
692600 MN Hennepin 27 school 2731780 281 Independent Districts and Schools ROBBINSDALE PUBLIC SCHOOL DISTRICT 273178004952 401 The FAIR School - Crystal Elementary School (Grades PK-6) Regular School No Elementary 04 08 2017   grade_7 32.0 50.0 7.0   3.0 5.0     0.0   10.0   47.0 60.0     5.0   0.0     55.0   13.0   107.0 32 50 7   3 5     0   10   47 60     5 0   55 13   107
694100 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384001612 528 LINWOOD MONROE ARTS PLUS UPPER Elementary School (Grades PK-6) Regular School No Elementary 04 08 2017   grade_7 49.0 40.0 13.0   0.0 22.0     0.0   6.0   59.0 71.0     29.0   0.0     77.0   27.0   130.0 49 40 13   0 22     0   6   59 71     29 0   77 27   130
696319 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124000969 121 LAKE HARRIET UPPER SCHOOL Elementary School (Grades PK-6) Regular School No Elementary 04 08 2017   grade_7 129.0 7.0 11.0   1.0 9.0     0.0   4.0   82.0 79.0     3.0   0.0     21.0   16.0   161.0 129 7 11   1 9     0   4   82 79     3 0   21 16   161
697800 MN Chippewa 12 school 2721320 129 Independent Districts and Schools MONTEVIDEO PUBLIC SCHOOL DISTRICT 272132001071 30 MONTEVIDEO MIDDLE Middle School (Grades 5-8) Regular School No Elementary 04 07 2017   grade_7 91.0 0.0 16.0   1.0 0.0     0.0   3.0   57.0 54.0     7.0   0.0     47.0   21.0   111.0 91 0 16   1 0     0   3   57 54     7 0   47 21   111
697818 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_7 57.0 2.0 17.0   0.0 1.0     1.0   6.0   47.0 37.0     1.0   0.0     37.0   8.0   84.0 57 2 17   0 1     1   6   47 37     1 0   37 8   84
698419 MN Morrison 49 school 2733900 2170 Independent Districts and Schools STAPLES-MOTLEY SCHOOL DISTRICT 273390002468 50 MOTLEY-STAPLES MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Elementary 04 07 2017   grade_7 80.0 0.0 4.0   1.0 1.0     0.0   1.0   47.0 40.0     0.0   4.0     43.0   12.0   87.0 80 0 4   1 1     0   1   47 40     0 4   43 12   87
701687 MN Saint Louis 69 school 2711040 709 Independent Districts and Schools DULUTH PUBLIC SCHOOL DISTRICT 271104001600 630 SUPERIOR ACADEMY Hospital/Medical/Partial Hospitalization Program Alternative School No Other 04 12 2017   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
701961 MN Clay 14 school 2721420 152 Independent Districts and Schools MOORHEAD PUBLIC SCHOOL DISTRICT 272142000413 960 WEST CENTRAL JUVENILE CENTER Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No Other 04 12 2017   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
702004 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 School No Other 04 12 2017   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
702111 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_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
702526 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_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
855406 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 2016   grade_7 157 0 2   0 0     0   2   86 75     0.0   2.0     46.0   24.0   161 157 0 2   0 0     0   2   86 75     0 2   46 24   161
856950 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 2 04 08 2016   grade_7 51 38 4   2 2     0   4   44 57     1.0   2.0     41.0   *   101 51 38 4   2 2     0   4   44 57     1 2   41     101
858414 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 2016   grade_7 40 30 19   4 25     0   4   44 78     31.0   1.0     82.0   29.0   122 40 30 19   4 25     0   4   44 78     31 1   82 29   122
860600 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 2016   grade_7 108 11 5   0 2     0   1   66 61     5.0   2.0     16.0   15.0   127 108 11 5   0 2     0   1   66 61     5 2   16 15   127
861991 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 2016   grade_7 67 1 19   0 0     1   5   42 51     9.0   1.0     48.0   16.0   93 67 1 19   0 0     1   5   42 51     9 1   48 16   93
862009 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 2016   grade_7 71 4 8   0 1     0   3   45 42     3.0   0.0     40.0   19.0   87 71 4 8   0 1     0   3   45 42     3 0   40 19   87
865052 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 2016   grade_7 0 0 1   0 0     0   0   1 0         *         *   1 0 0 1   0 0     0   0   1 0                 1
865981 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 2016   grade_7 0 0 0   1 0     0   0   0 1         *         *   1 0 0 0   1 0     0   0   0 1                 1
866447 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 Education School No 4 04 12 2016   grade_7 0 0 0   0 0     0   1   1 0         *         *   1 0 0 0   0 0     0   1   1 0                 1
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
1713694 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 Middle 04 08 2021   grade_7 140 1 7   0 0     0   4   83 69     1.0   0.0     37.0   13.0   152 140 1 7   0 0     0   4   83 69     1 0   37 13   152
1719121 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 Middle 04 08 2021   grade_7 102 2 5   0 3     0   3   52 63     3.0   0.0     6.0   9.0   115 102 2 5   0 3     0   3   52 63     3 0   6 9   115
1720106 MN Hennepin 27 school 2700308 4191 Charter Schools KIPP Minnesota Charter School 270030805269 20 KIPP Legacy Academy Elementary School (Grades PK-6) Regular School Yes Middle 04 07 2021   grade_7 0 34 1   0 0     0   0   19 16     0.0   3.0     28.0   9.0   35 0 34 1   0 0     0   0   19 16     0 3   28 9   35
1720765 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 Middle 04 07 2021   grade_7 73 2 15   2 0     3   6   50 51     10.0   0.0     42.0   18.0   101 73 2 15   2 0     3   6   50 51     10 0   42 18   101
1721661 MN Hennepin 27 school 2700444 4263 Charter Schools Progeny Academy Charter School 270044405133 10 Progeny Academy Charter School Middle School (Grades 5-8) Regular School Yes Middle 04 08 2021   grade_7 2 15 2   0 2     0   1   13 9     13.0   0.0     18.0   3.0   22 2 15 2   0 2     0   1   13 9     13 0   18 3   22
1724597 MN Stearns 73 school 2700071 6383 Education Districts Benton-Stearns Education District 270007104581 40 Benton-Stearns Education District - ASD Program Special Education Special Education School No Other 04 12 2021   grade_7 1 0 0   0 0     0   0   1 0     *   *     *   *   1 1 0 0   0 0     0   0   1 0                 1
1724977 MN Clay 14 school 2721420 152 Independent Districts and Schools Moorhead Public School District 272142000413 960 West Central Academy-S Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No Other 04 12 2021   grade_7 0 0 0   1 0     0   0   0 1     *   *     *   *   1 0 0 0   1 0     0   0   0 1                 1
1725017 MN Kandiyohi 34 school 2742720 347 Independent Districts and Schools Willmar Public School District 274272004674 941 Lake Park School Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No Other 04 12 2021   grade_7 1 0 0   0 0     0   1   1 1     *   *     *   *   2 1 0 0   0 0     0   1   1 1                 2
1725031 MN Mille Lacs 48 school 2725050 480 Independent Districts and Schools Onamia Public School District 272505000957 30 Onamia Academy Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No Other 04 12 2021   grade_7 3 1 0   1 0     0   1   6 0     *   *     *   *   6 3 1 0   1 0     0   1   6 0                 6
1725099 MN Saint Louis 69 school 2711040 709 Independent Districts and Schools Duluth Public School District 271104001577 580 Rockridge Academy Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No Other 04 12 2021   grade_7 1 0 0   0 0     0   0   0 1     *   *     *   *   1 1 0 0   0 0     0   0   0 1                 1
1827263 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 Middle 04 08 2020   grade_7 171.0 0.0 0.0   0.0 0.0     0.0   1.0   93.0 79.0     0.0   1.0     44.0   25.0   172.0 171 0 0   0 0     0   1   93 79     0 1   44 25   172
1832665 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 Middle 04 08 2020   grade_7 98.0 3.0 5.0   0.0 8.0     0.0   7.0   72.0 49.0     4.0   2.0     14.0   9.0   121.0 98 3 5   0 8     0   7   72 49     4 2   14 9   121
1834272 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 Middle 04 07 2020   grade_7 79.0 2.0 23.0   3.0 2.0     2.0   6.0   60.0 57.0     9.0   0.0     59.0   18.0   117.0 79 2 23   3 2     2   6   60 57     9 0   59 18   117
1834291 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 Middle 04 08 2020   grade_7 52.0 4.0 26.0   1.0 2.0     2.0   9.0   54.0 42.0     7.0   0.0     50.0   19.0   96.0 52 4 26   1 2     2   9   54 42     7 0   50 19   96
1838544 MN Clay 14 school 2721420 152 Independent Districts and Schools Moorhead Public School District 272142000413 960 West Central Academy-S Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No Other 04 12 2020   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
1838578 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 School No Other 04 12 2020   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
1838585 MN Kandiyohi 34 school 2742720 347 Independent Districts and Schools Willmar Public School District 274272004674 941 Lake Park School Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No Other 04 12 2020   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
1838667 MN Saint Louis 69 school 2711040 709 Independent Districts and Schools Duluth Public School District 271104001577 580 Rockridge Academy Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No Other 04 12 2020   grade_7 1.0 0.0 1.0   0.0 0.0     0.0   1.0   1.0 2.0     *   *         *   3.0 1 0 1   0 0     0   1   1 2                 3
1838674 MN Saint Louis 69 school 2711040 709 Independent Districts and Schools Duluth Public School District 271104001589 605 Arrowhead Academy Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No Other 04 12 2020   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
1839013 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 2020   grade_7 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
1881841 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 Middle 04 08 2018   grade_7 160.0 0.0 2.0   1.0 0.0     0.0   4.0   76.0 91.0     0.0   1.0     41.0   23.0   167.0 160 0 2   1 0     0   4   76 91     0 1   41 23   167
1882428 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 Middle 04 08 2018   grade_7 6.0 1.0 0.0   0.0 1.0     0.0   1.0   7.0 2.0     *   *     *   *   9.0 6 1 0   0 1     0   1   7 2                 9
1883460 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 Middle 04 08 2018   grade_7 32.0 47.0 9.0   0.0 3.0     1.0   11.0   50.0 53.0     7.0   0.0     57.0   13.0   103.0 32 47 9   0 3     1   11   50 53     7 0   57 13   103
1885001 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 Middle 04 08 2018   grade_7 49.0 33.0 7.0   1.0 27.0     0.0   6.0   49.0 74.0     32.0   1.0     72.0   29.0   123.0 49 33 7   1 27     0   6   49 74     32 1   72 29   123
1887212 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 Middle 04 08 2018   grade_7 110.0 4.0 4.0   0.0 7.0     0.0   2.0   54.0 73.0     4.0   0.0     10.0   8.0   127.0 110 4 4   0 7     0   2   54 73     4 0   10 8   127
1888751 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 Middle 04 07 2018   grade_7 89.0 1.0 11.0   0.0 2.0     1.0   3.0   68.0 39.0     5.0   0.0     39.0   19.0   107.0 89 1 11   0 2     1   3   68 39     5 0   39 19   107
1888770 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 Middle 04 08 2018   grade_7 68.0 2.0 13.0   0.0 1.0     0.0   1.0   48.0 37.0     2.0   0.0     35.0   15.0   85.0 68 2 13   0 1     0   1   48 37     2 0   35 15   85
1889397 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 Middle 04 07 2018   grade_7 87.0 0.0 3.0   0.0 0.0     0.0   4.0   52.0 42.0     0.0   3.0     50.0   17.0   94.0 87 0 3   0 0     0   4   52 42     0 3   50 17   94
1892142 MN Dakota 19 school 2700026 917 Intermediate Districts and Schools Intermediate School District 917 270002605108 900 Customized Alternative Solutions for Education (CASE) Special Education Special Education School No Other 04 11 2018   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
1892980 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 School No Other 04 12 2018   grade_7 0.0 1.0 1.0   0.0 0.0     0.0   0.0   2.0 0.0     *   *     *   *   2.0 0 1 1   0 0     0   0   2 0                 2
1893079 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 2018   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
1893438 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 2018   grade_7 4.0 1.0 0.0   0.0 0.0     0.0   0.0   1.0 4.0     *   *     *   *   5.0 4 1 0   0 0     0   0   1 4                 5
1946383 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 Middle 04 08 2019   grade_7 150.0 0.0 3.0   1.0 0.0     1.0   2.0   84.0 73.0     0.0   0.0     36.0   24.0   157.0 150 0 3   1 0     1   2   84 73     0 0   36 24   157
1946976 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 Middle 04 08 2019   grade_7 9.0 0.0 1.0   0.0 0.0     0.0   2.0   11.0 1.0     0.0   0.0         *   12.0 9 0 1   0 0     0   2   11 1     0 0         12
1948014 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 Middle 04 08 2019   grade_7 27.0 50.0 12.0   2.0 2.0     0.0   12.0   41.0 64.0     5.0   2.0     67.0   14.0   105.0 27 50 12   2 2     0   12   41 64     5 2   67 14   105
1951795 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 Middle 04 08 2019   grade_7 113.0 4.0 4.0   0.0 4.0     0.0   2.0   64.0 63.0     2.0   0.0     8.0   12.0   127.0 113 4 4   0 4     0   2   64 63     2 0   8 12   127
1953348 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 Middle 04 07 2019   grade_7 89.0 2.0 20.0   1.0 0.0     0.0   2.0   60.0 54.0     3.0   1.0     45.0   20.0   114.0 89 2 20   1 0     0   2   60 54     3 1   45 20   114
1953367 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 Middle 04 08 2019   grade_7 55.0 1.0 15.0   0.0 2.0     3.0   4.0   44.0 36.0     2.0   0.0     36.0   18.0   80.0 55 1 15   0 2     3   4   44 36     2 0   36 18   80
1953714 MN Otter Tail 56 school 2711880 544 Independent Districts and Schools FERGUS FALLS PUBLIC SCHOOL DISTRICT 271188004944 380 Kennedy Middle School Middle School (Grades 5-8) Regular School No Middle 04 08 2019   grade_7 162.0 7.0 9.0   2.0 0.0     0.0   9.0   100.0 89.0     *   0.0         22.0   189.0 162 7 9   2 0     0   9   100 89       0     22   189
1954001 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 Middle 04 07 2019   grade_7 77.0 0.0 4.0   2.0 0.0     0.0   0.0   50.0 33.0     1.0   5.0     42.0   11.0   83.0 77 0 4   2 0     0   0   50 33     1 5   42 11   83
1957594 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 School No Other 04 12 2019   grade_7 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
1957645 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384004398 42 ANNA WESTIN HOUSE Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No Other 04 12 2019   grade_7 4.0 0.0 0.0   0.0 0.0     0.0   0.0   1.0 3.0     *   *         *   4.0 4 0 0   0 0     0   0   1 3                 4
1957693 MN Saint Louis 69 school 2711040 709 Independent Districts and Schools DULUTH PUBLIC SCHOOL DISTRICT 271104001577 580 Rockridge Academy Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No Other 04 12 2019   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
1958037 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 2019   grade_7 0.0 1.0 0.0   1.0 0.0     0.0   0.0   1.0 1.0     *   *         *   2.0 0 1 0   1 0     0   0   1 1                 2
689583 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 Other 05 12 2017   grade_7 48.0 1.0 0.0   0.0 1.0     0.0   0.0   26.0 24.0     0.0   0.0     18.0   5.0   50.0 48 1 0   0 1     0   0   26 24     0 0   18 5   50
690245 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_7 27.0 0.0 3.0   0.0 0.0     0.0   2.0   14.0 18.0     0.0   0.0     15.0   4.0   32.0 27 0 3   0 0     0   2   14 18     0 0   15 4   32

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