Data source: Big Local News · About: Big Local

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

View and edit SQL

year

grade

  • grade_7 · 4,774
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
690534 MN Unknown   school 2700402 4237 Charter Schools Metropolitan Education for Future Employment 270040204836 10 Metropolitan Education for Future Employment Charter Secondary School (Grades 7-12) Regular School Yes Other 06 12 2017   grade_7 0.0 5.0 0.0   0.0 0.0     0.0   0.0   5.0 0.0         *         *   5.0 0 5 0   0 0     0   0   5 0                 5
854895 MN Unknown   school 2700367 4200 Charter Schools STEP ACADEMY CHARTER SCHOOL 270036704507 10 STEP ACADEMY CHARTER SCHOOL Secondary School (Grades 7-12) Regular School Yes 4 06 12 2016   grade_7 1 29 0   0 0     0   0   16 14     2.0   0.0         0.0   30 1 29 0   0 0     0   0   16 14     2 0     0   30
854932 MN Unknown   school 2700402 4237 Charter Schools Metropolitan Education for Future Employment 270040204836 10 Metropolitan Education for Future Employment Charter Secondary School (Grades 7-12) Regular School Yes 4 06 12 2016   grade_7 0 15 0   0 0     0   0   8 7     10.0   0.0         *   15 0 15 0   0 0     0   0   8 7     10 0         15
866223 MN Unknown   school 2700193 4082 Charter Schools BLUESKY CHARTER SCHOOL 270019303146 10 BLUESKY CHARTER SCHOOL Distance Learning Program OLL (State approved) Regular School Yes 3 07 12 2016   grade_7 7 0 3   0 1     0   0   9 2     0.0   0.0     5.0   3.0   11 7 0 3   0 1     0   0   9 2     0 0   5 3   11
1147589 MN Unknown   school 2700367 4200 Charter Schools STEP ACADEMY CHARTER SCHOOL 270036704507 10 STEP ACADEMY CHARTER SCHOOL Secondary School (Grades 7-12) Regular School Yes 4 06 12 2015   grade_7 0.0 50.0 0.0   0.0 1.0     0.0   0.0   27.0 24.0     7.0   0.0         1.0   51.0 0 50 0   0 1     0   0   27 24     7 0     1   51
1157161 MN Unknown   school 2700014 6004 Education Districts FRESHWATER ED. DIST. 270001402222 20 FRESHWATER ED. DIST. ALC Public Area Learning Center ALC (State approved) Alternative Education School No 4 06 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
1158189 MN Unknown   school 2700014 6004 Education Districts FRESHWATER ED. DIST. 270001403675 60 LEAF RIVER ACADEMY Special Education Special Education School No 4 KG 12 2015   grade_7 2.0 1.0 0.0   1.0 0.0     0.0   0.0   4.0 0.0         *         *   4.0 2 1 0   1 0     0   0   4 0                 4
1158577 MN Unknown   school 2700193 4082 Charter Schools BLUESKY CHARTER SCHOOL 270019303146 10 BLUESKY CHARTER SCHOOL Distance Learning Program OLL (State approved) Regular School Yes 3 07 12 2015   grade_7 7.0 0.0 0.0   0.0 1.0     0.0   0.0   5.0 3.0         *         *   8.0 7 0 0   0 1     0   0   5 3                 8
1954190 MN Unknown   school 2700335 4205 Charter Schools HENNEPIN ELEMENTARY SCHOOL 270033505203 20 Hennepin Middle School Middle School (Grades 5-8) Regular School Yes Middle 05 08 2019   grade_7 0.0 18.0 3.0   0.0 0.0     0.0   0.0   12.0 9.0     7.0   0.0         6.0   21.0 0 18 3   0 0     0   0   12 9     7 0     6   21
1954203 MN Unknown   school 2700399 4231 Charter Schools Minnesota Math and Science Academy 270039905177 20 MMSA Middle School Middle School (Grades 5-8) Regular School Yes Middle 05 08 2019   grade_7 0.0 42.0 0.0   0.0 2.0     0.0   0.0   21.0 23.0     24.0   1.0         3.0   44.0 0 42 0   0 2     0   0   21 23     24 1     3   44
1957022 MN Unknown   school 2700015 6009 Education Districts ST. CROIX RIVER EDUCATION DISTRICT 270001505147 40 Pathway to Change Special Education Special Education School No Other KG 12 2019   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
689946 MN Yellow Medicine 87 school 2707470 891 Independent Districts and Schools CANBY PUBLIC SCHOOL DISTRICT 270747000322 10 CANBY SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   grade_7 52.0 1.0 2.0   0.0 1.0     0.0   0.0   25.0 31.0     0.0   0.0     15.0   10.0   56.0 52 1 2   0 1     0   0   25 31     0 0   15 10   56
698431 MN Yellow Medicine 87 school 2700099 2190 Independent Districts and Schools YELLOW MEDICINE EAST 270009904609 23 YELLOW MEDICINE EAST MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_7 40.0 2.0 6.0   12.0 0.0     0.0   0.0   30.0 30.0     0.0   0.0     27.0   12.0   60.0 40 2 6   12 0     0   0   30 30     0 0   27 12   60
702733 MN Yellow Medicine 87 school 2700139 4026 Charter Schools E.C.H.O. CHARTER SCHOOL 270013902718 10 E.C.H.O. CHARTER SCHOOL Elementary/Secondary Combined (Grades K-12 limited to District Type 34 Bureau of Indian Education) Regular School Yes Other KG 12 2017   grade_7 8.0 0.0 1.0   0.0 0.0     0.0   1.0   5.0 5.0     0.0   0.0     5.0   2.0   10.0 8 0 1   0 0     0   1   5 5     0 0   5 2   10
854364 MN Yellow Medicine 87 school 2707470 891 Independent Districts and Schools CANBY PUBLIC SCHOOL DISTRICT 270747000322 10 CANBY SECONDARY Secondary School (Grades 7-12) Regular School No 3 07 12 2016   grade_7 34 1 1   0 0     0   0   21 15     0.0   0.0     15.0   5.0   36 34 1 1   0 0     0   0   21 15     0 0   15 5   36
862606 MN Yellow Medicine 87 school 2700099 2190 Independent Districts and Schools YELLOW MEDICINE EAST 270009904609 23 YELLOW MEDICINE EAST MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No 2 06 08 2016   grade_7 39 1 9   13 0     0   1   33 30     2.0   0.0     33.0   11.0   63 39 1 9   13 0     0   1   33 30     2 0   33 11   63
866880 MN Yellow Medicine 87 school 2700139 4026 Charter Schools E.C.H.O. CHARTER SCHOOL 270013902718 10 E.C.H.O. CHARTER SCHOOL Elementary/Secondary Combined (Grades K-12 limited to District Type 34 Bureau of Indian Education) Regular School Yes 4 KG 12 2016   grade_7 8 0 1   0 0     0   0   8 1         *         *   9 8 0 1   0 0     0   0   8 1                 9
1147054 MN Yellow Medicine 87 school 2707470 891 Independent Districts and Schools CANBY PUBLIC SCHOOL DISTRICT 270747000322 10 CANBY SECONDARY Secondary School (Grades 7-12) Regular School No 3 07 12 2015   grade_7 35.0 0.0 1.0   0.0 0.0     0.0   0.0   25.0 11.0     0.0   0.0     9.0   3.0   36.0 35 0 1   0 0     0   0   25 11     0 0   9 3   36
1155259 MN Yellow Medicine 87 school 2700099 2190 Independent Districts and Schools YELLOW MEDICINE EAST 270009904609 23 YELLOW MEDICINE EAST MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No 2 06 08 2015   grade_7 29.0 0.0 8.0   9.0 2.0     0.0   0.0   24.0 24.0     3.0   0.0     25.0   13.0   48.0 29 0 8   9 2     0   0   24 24     3 0   25 13   48
1159429 MN Yellow Medicine 87 school 2700139 4026 Charter Schools E.C.H.O. CHARTER SCHOOL 270013902718 10 E.C.H.O. CHARTER SCHOOL Elementary/Secondary Combined (Grades K-12 limited to District Type 34 Bureau of Indian Education) Regular School Yes 4 KG 12 2015   grade_7 9.0 0.0 0.0   0.0 0.0     0.0   1.0   5.0 5.0     0.0   0.0     6.0   1.0   10.0 9 0 0   0 0     0   1   5 5     0 0   6 1   10
1712577 MN Yellow Medicine 87 school 2707470 891 Independent Districts and Schools Canby Public School District 270747000322 10 Canby Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 57 0 1   0 0     0   2   26 34     0.0   0.0     22.0   9.0   60 57 0 1   0 0     0   2   26 34     0 0   22 9   60
1721435 MN Yellow Medicine 87 school 2700099 2190 Independent Districts and Schools Yellow Medicine East 270009904609 23 Yellow Medicine East Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 41 0 9   8 0     0   2   34 26     1.0   0.0     26.0   15.0   60 41 0 9   8 0     0   2   34 26     1 0   26 15   60
1725546 MN Yellow Medicine 87 school 2700139 4026 Charter Schools E.C.H.O. Charter School 270013902718 10 E.C.H.O. Charter School Elementary/Secondary Combined (Grades K-12 limited to District Type 34 Bureau of Indian Education) Regular School Yes Other KG 12 2021   grade_7 9 0 0   1 0     0   1   4 7     0.0   0.0     9.0   2.0   11 9 0 0   1 0     0   1   4 7     0 0   9 2   11
1826155 MN Yellow Medicine 87 school 2707470 891 Independent Districts and Schools Canby Public School District 270747000322 10 Canby Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2020   grade_7 55.0 1.0 2.0   0.0 1.0     0.0   1.0   31.0 29.0     0.0   0.0     23.0   6.0   60.0 55 1 2   0 1     0   1   31 29     0 0   23 6   60
1834955 MN Yellow Medicine 87 school 2700099 2190 Independent Districts and Schools Yellow Medicine East 270009904609 23 Yellow Medicine East Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2020   grade_7 35.0 2.0 6.0   10.0 1.0     0.0   0.0   26.0 28.0     0.0   0.0     18.0   14.0   54.0 35 2 6   10 1     0   0   26 28     0 0   18 14   54
1839237 MN Yellow Medicine 87 school 2700139 4026 Charter Schools E.C.H.O. Charter School 270013902718 10 E.C.H.O. Charter School Elementary/Secondary Combined (Grades K-12 limited to District Type 34 Bureau of Indian Education) Regular School Yes Other KG 12 2020   grade_7 3.0 0.0 0.0   4.0 0.0     0.0   0.0   3.0 4.0     *   *         *   7.0 3 0 0   4 0     0   0   3 4                 7
1880742 MN Yellow Medicine 87 school 2707470 891 Independent Districts and Schools Canby Public School District 270747000322 10 Canby Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_7 39.0 0.0 1.0   0.0 0.0     0.0   1.0   20.0 21.0     0.0   0.0     13.0   6.0   41.0 39 0 1   0 0     0   1   20 21     0 0   13 6   41
1889409 MN Yellow Medicine 87 school 2700099 2190 Independent Districts and Schools Yellow Medicine East 270009904609 23 Yellow Medicine East Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2018   grade_7 43.0 1.0 6.0   11.0 1.0     0.0   2.0   29.0 35.0     0.0   0.0     23.0   11.0   64.0 43 1 6   11 1     0   2   29 35     0 0   23 11   64
1893648 MN Yellow Medicine 87 school 2700139 4026 Charter Schools E.C.H.O. Charter School 270013902718 10 E.C.H.O. Charter School Elementary/Secondary Combined (Grades K-12 limited to District Type 34 Bureau of Indian Education) Regular School Yes Other KG 12 2018   grade_7 5.0 0.0 1.0   0.0 0.0     0.0   3.0   4.0 5.0     *   *     *   *   9.0 5 0 1   0 0     0   3   4 5                 9
1945297 MN Yellow Medicine 87 school 2707470 891 Independent Districts and Schools CANBY PUBLIC SCHOOL DISTRICT 270747000322 10 CANBY SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_7 45.0 0.0 2.0   0.0 0.0     0.0   1.0   26.0 22.0     0.0   0.0     17.0   9.0   48.0 45 0 2   0 0     0   1   26 22     0 0   17 9   48
1954013 MN Yellow Medicine 87 school 2700099 2190 Independent Districts and Schools YELLOW MEDICINE EAST 270009904609 23 YELLOW MEDICINE EAST MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_7 31.0 0.0 8.0   8.0 1.0     0.0   3.0   25.0 26.0     1.0   0.0     24.0   8.0   51.0 31 0 8   8 1     0   3   25 26     1 0   24 8   51
1958252 MN Yellow Medicine 87 school 2700139 4026 Charter Schools E.C.H.O. CHARTER SCHOOL 270013902718 10 E.C.H.O. CHARTER SCHOOL Elementary/Secondary Combined (Grades K-12 limited to District Type 34 Bureau of Indian Education) Regular School Yes Other KG 12 2019   grade_7 6.0 0.0 1.0   2.0 0.0     0.0   2.0   6.0 5.0     0.0   0.0     7.0   4.0   11.0 6 0 1   2 0     0   2   6 5     0 0   7 4   11
689939 MN Wright 86 school 2718810 881 Independent Districts and Schools MAPLE LAKE PUBLIC SCHOOL DISTRICT 271881000886 20 MAPLE LAKE SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   grade_7 79.0 1.0 0.0   0.0 0.0     0.0   3.0   35.0 48.0     0.0   0.0     20.0   15.0   83.0 79 1 0   0 0     0   3   35 48     0 0   20 15   83
690447 MN Wright 86 school 2700360 4118 Charter Schools KALEIDOSCOPE CHARTER SCHOOL 270036004668 20 Kaleidoscope Charter Secondary School Secondary School (Grades 7-12) Regular School Yes Other 06 12 2017   grade_7 33.0 2.0 4.0   0.0 0.0     0.0   1.0   18.0 22.0     0.0   0.0     12.0   11.0   40.0 33 2 4   0 0     0   1   18 22     0 0   12 11   40
690527 MN Wright 86 school 2700403 4229 Charter Schools Jane Goodall Environmental Science Academy 270040304850 10 Jane Goodall Environmental Science Academy Secondary School (Grades 7-12) Regular School Yes Other 06 12 2017   grade_7 18.0 0.0 1.0   0.0 0.0     0.0   1.0   14.0 6.0     0.0   0.0     5.0   6.0   20.0 18 0 1   0 0     0   1   14 6     0 0   5 6   20
698074 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_7 167.0 2.0 4.0   0.0 2.0     0.0   2.0   86.0 91.0     2.0   1.0     46.0   19.0   177.0 167 2 4   0 2     0   2   86 91     2 1   46 19   177
698349 MN Wright 86 school 2703150 876 Independent Districts and Schools ANNANDALE PUBLIC SCHOOL DISTRICT 270315000093 2 ANNANDALE MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_7 135.0 1.0 2.0   1.0 2.0     0.0   4.0   73.0 72.0     1.0   1.0     37.0   20.0   145.0 135 1 2   1 2     0   4   73 72     1 1   37 20   145
698353 MN Wright 86 school 2707200 877 Independent Districts and Schools BUFFALO-HANOVER-MONTROSE PUBLIC SCH 270720000284 30 BUFFALO COMMUNITY MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_7 386.0 4.0 22.0   2.0 1.0     0.0   18.0   226.0 207.0     7.0   3.0         61.0   433.0 386 4 22   2 1     0   18   226 207     7 3     61   433
698358 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_7 200.0 0.0 4.0   0.0 2.0     0.0   6.0   114.0 98.0     0.0   0.0     20.0   33.0   212.0 200 0 4   0 2     0   6   114 98     0 0   20 33   212
698362 MN Wright 86 school 2721390 882 Independent Districts and Schools MONTICELLO PUBLIC SCHOOL DISTRICT 272139002209 30 MONTICELLO MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_7 296.0 5.0 23.0   1.0 5.0     0.0   4.0   176.0 158.0     10.0   *     90.0   39.0   334.0 296 5 23   1 5     0   4   176 158     10     90 39   334
698367 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_7 116.0 8.0 14.0   0.0 3.0     0.0   1.0   70.0 72.0     3.0   0.0     34.0   14.0   142.0 116 8 14   0 3     0   1   70 72     3 0   34 14   142
698372 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_7 232.0 4.0 6.0   1.0 4.0     0.0   11.0   137.0 121.0     1.0   0.0     31.0   21.0   258.0 232 4 6   1 4     0   11   137 121     1 0   31 21   258
698377 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_7 231.0 8.0 9.0   0.0 3.0     0.0   9.0   133.0 127.0     3.0   0.0     41.0   24.0   260.0 231 8 9   0 3     0   9   133 127     3 0   41 24   260
698454 MN Wright 86 school 2700123 2687 Independent Districts and Schools HOWARD LAKE-WAVERLY-WINSTED 270012303350 86 Howard Lake-Waverly-Winsted Middle School Middle School (Grades 5-8) Regular School No Middle 05 08 2017   grade_7 63.0 2.0 2.0   0.0 1.0     0.0   2.0   28.0 42.0     0.0   1.0     18.0   6.0   70.0 63 2 2   0 1     0   2   28 42     0 1   18 6   70
701265 MN Wright 86 school 2700045 938 Special Education Cooperatives MEEKER AND WRIGHT SPECIAL EDUCATION 270004504402 10 TREK PROGRAM Special Education Special Education School No Other KG 12 2017   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
701271 MN Wright 86 school 2700045 938 Special Education Cooperatives MEEKER AND WRIGHT SPECIAL EDUCATION 270004502961 11 CORNERSTONES PROGRAM Special Education Special Education School No Other 06 12 2017   grade_7 3.0 1.0 0.0   1.0 0.0     0.0   0.0   3.0 2.0         *         *   5.0 3 1 0   1 0     0   0   3 2                 5
701285 MN Wright 86 school 2700045 938 Special Education Cooperatives MEEKER AND WRIGHT SPECIAL EDUCATION 270004504351 17 JOURNEYS ALTERNATIVE PROGRAM Special Education Special Education School No Elementary KG 08 2017   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
701347 MN Wright 86 school 2700413 6090 Special Education Cooperatives Sherburne and Northern Wright Special Education Cooperative 270041304909 30 Monticello Middle School - SNW Special Education Special Education School No Middle 06 08 2017   grade_7 4.0 2.0 0.0   0.0 0.0     0.0   0.0   4.0 2.0         *         *   6.0 4 2 0   0 0     0   0   4 2                 6
702236 MN Wright 86 school 2700045 938 Special Education Cooperatives MEEKER AND WRIGHT SPECIAL EDUCATION 270004502964 16 VILLAGE RANCH ALTERNATIVE PROGRAM Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No Other 05 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
854357 MN Wright 86 school 2718810 881 Independent Districts and Schools MAPLE LAKE PUBLIC SCHOOL DISTRICT 271881000886 20 MAPLE LAKE SECONDARY Secondary School (Grades 7-12) Regular School No 3 07 12 2016   grade_7 67 0 0   0 0     0   1   31 37     0.0   0.0     9.0   11.0   68 67 0 0   0 0     0   1   31 37     0 0   9 11   68
854854 MN Wright 86 school 2700360 4118 Charter Schools KALEIDOSCOPE CHARTER SCHOOL 270036004668 20 Kaleidoscope Charter Secondary School Secondary School (Grades 7-12) Regular School Yes 4 06 11 2016   grade_7 22 2 0   0 0     0   0   16 8     0.0   0.0     5.0   7.0   24 22 2 0   0 0     0   0   16 8     0 0   5 7   24
854924 MN Wright 86 school 2700403 4229 Charter Schools Jane Goodall Environmental Science Academy 270040304850 10 Jane Goodall Environmental Science Academy Secondary School (Grades 7-12) Regular School Yes 4 06 12 2016   grade_7 25 0 0   0 0     0   0   14 11     0.0   0.0     4.0   9.0   25 25 0 0   0 0     0   0   14 11     0 0   4 9   25
862254 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 2016   grade_7 172 1 7   2 0     0   2   85 99     1.0   1.0     56.0   23.0   184 172 1 7   2 0     0   2   85 99     1 1   56 23   184
862526 MN Wright 86 school 2703150 876 Independent Districts and Schools ANNANDALE PUBLIC SCHOOL DISTRICT 270315000093 2 ANNANDALE MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No 2 06 08 2016   grade_7 109 0 2   0 0     0   3   59 55     1.0   0.0     29.0   19.0   114 109 0 2   0 0     0   3   59 55     1 0   29 19   114
862530 MN Wright 86 school 2707200 877 Independent Districts and Schools BUFFALO-HANOVER-MONTROSE PUBLIC SCH 270720000284 30 BUFFALO COMMUNITY MIDDLE Middle School (Grades 5-8) Regular School No 2 06 08 2016   grade_7 428 5 10   3 4     1   12   219 244     4.0   0.0     130.0   57.0   463 428 5 10   3 4     1   12   219 244     4 0   130 57   463
862535 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 2016   grade_7 169 1 5   0 4     0   2   98 83     0.0   0.0     19.0   25.0   181 169 1 5   0 4     0   2   98 83     0 0   19 25   181
862539 MN Wright 86 school 2721390 882 Independent Districts and Schools MONTICELLO PUBLIC SCHOOL DISTRICT 272139002209 30 MONTICELLO MIDDLE Middle School (Grades 5-8) Regular School No 2 06 08 2016   grade_7 270 4 25   3 7     0   5   149 165     8.0   0.0         *   314 270 4 25   3 7     0   5   149 165     8 0         314
862544 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 2016   grade_7 119 4 9   0 4     0   7   78 65     3.0   0.0     28.0   24.0   143 119 4 9   0 4     0   7   78 65     3 0   28 24   143
862549 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 2016   grade_7 238 9 7   0 7     0   7   140 128     2.0   1.0     23.0   28.0   268 238 9 7   0 7     0   7   140 128     2 1   23 28   268
862554 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 2016   grade_7 213 5 3   1 6     0   15   125 118     3.0   2.0     39.0   18.0   243 213 5 3   1 6     0   15   125 118     3 2   39 18   243
862624 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 2016   grade_7 76 1 2   0 0     0   1   37 43     0.0   0.0     18.0   10.0   80 76 1 2   0 0     0   1   37 43     0 0   18 10   80
865497 MN Wright 86 school 2700045 938 Special Education Cooperatives MEEKER AND WRIGHT SPECIAL EDUCATION 270004504402 10 TREK PROGRAM Special Education Special Education School No 4 KG 12 2016   grade_7 1 0 0   0 0     0   0   0 1         *         *   1 1 0 0   0 0     0   0   0 1                 1
865503 MN Wright 86 school 2700045 938 Special Education Cooperatives MEEKER AND WRIGHT SPECIAL EDUCATION 270004502961 11 CORNERSTONES PROGRAM Special Education Special Education School No 4 06 12 2016   grade_7 3 0 0   0 0     0   0   2 1         *         *   3 3 0 0   0 0     0   0   2 1                 3
865516 MN Wright 86 school 2700045 938 Special Education Cooperatives MEEKER AND WRIGHT SPECIAL EDUCATION 270004504351 17 JOURNEYS ALTERNATIVE PROGRAM Special Education Special Education School No 1 KG 08 2016   grade_7 1 0 0   0 0     0   0   1 0         *         *   1 1 0 0   0 0     0   0   1 0                 1
865551 MN Wright 86 school 2700413 6090 Special Education Cooperatives Sherburne and Northern Wright Special Education Cooperative 270041304909 30 Monticello Middle School - SNW Special Education Special Education School No 2 06 08 2016   grade_7 4 0 1   0 0     0   1   4 2         *         *   6 4 0 1   0 0     0   1   4 2                 6
866557 MN Wright 86 school 2700045 938 Special Education Cooperatives MEEKER AND WRIGHT SPECIAL EDUCATION 270004503890 15 WINGS ALTERNATIVE PROGRAM Educational Oversight to Public Residential Care & Treatment (State approved) Alternative Education School No 3 07 12 2016   grade_7 0 0 0   1 0     0   0   0 1         *         *   1 0 0 0   1 0     0   0   0 1                 1
866563 MN Wright 86 school 2700045 938 Special Education Cooperatives MEEKER AND WRIGHT SPECIAL EDUCATION 270004502964 16 VILLAGE RANCH ALTERNATIVE PROGRAM Educational Oversight to Public Residential Care & Treatment (State approved) Alternative Education School No 4 05 12 2016   grade_7 2 0 1   0 0     0   1   4 0         *         *   4 2 0 1   0 0     0   1   4 0                 4
1147047 MN Wright 86 school 2718810 881 Independent Districts and Schools MAPLE LAKE PUBLIC SCHOOL DISTRICT 271881000886 20 MAPLE LAKE SECONDARY Secondary School (Grades 7-12) Regular School No 3 07 12 2015   grade_7 68.0 2.0 1.0   0.0 0.0     0.0   0.0   35.0 36.0     0.0   0.0     14.0   9.0   71.0 68 2 1   0 0     0   0   35 36     0 0   14 9   71
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
1155179 MN Wright 86 school 2703150 876 Independent Districts and Schools ANNANDALE PUBLIC SCHOOL DISTRICT 270315000093 2 ANNANDALE MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No 2 06 08 2015   grade_7 112.0 1.0 3.0   0.0 0.0     0.0   3.0   53.0 66.0     2.0   0.0     26.0   23.0   119.0 112 1 3   0 0     0   3   53 66     2 0   26 23   119
1155183 MN Wright 86 school 2707200 877 Independent Districts and Schools BUFFALO-HANOVER-MONTROSE PUBLIC SCH 270720000284 30 BUFFALO COMMUNITY MIDDLE Middle School (Grades 5-8) Regular School No 2 06 08 2015   grade_7 403.0 5.0 20.0   0.0 6.0     1.0   7.0   227.0 215.0     3.0   1.0     112.0   54.0   442.0 403 5 20   0 6     1   7   227 215     3 1   112 54   442
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
1155192 MN Wright 86 school 2721390 882 Independent Districts and Schools MONTICELLO PUBLIC SCHOOL DISTRICT 272139002209 30 MONTICELLO MIDDLE Middle School (Grades 5-8) Regular School No 2 06 08 2015   grade_7 275.0 4.0 17.0   0.0 4.0     1.0   5.0   165.0 141.0     7.0   3.0     84.0   45.0   306.0 275 4 17   0 4     1   5   165 141     7 3   84 45   306
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
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
1158063 MN Wright 86 school 2700045 938 Special Education Cooperatives MEEKER AND WRIGHT SPECIAL EDUCATION 270004504402 10 TREK PROGRAM Special Education Special Education School No 4 KG 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
1158067 MN Wright 86 school 2700045 938 Special Education Cooperatives MEEKER AND WRIGHT SPECIAL EDUCATION 270004502961 11 CORNERSTONES PROGRAM Special Education Special Education School No 4 06 12 2015   grade_7 5.0 0.0 0.0   0.0 0.0     0.0   0.0   3.0 2.0         *         *   5.0 5 0 0   0 0     0   0   3 2                 5
1158080 MN Wright 86 school 2700045 938 Special Education Cooperatives MEEKER AND WRIGHT SPECIAL EDUCATION 270004504351 17 JOURNEYS ALTERNATIVE PROGRAM Special Education Special Education School No 1 KG 08 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
1158933 MN Wright 86 school 2700045 938 Special Education Cooperatives MEEKER AND WRIGHT SPECIAL EDUCATION 270004502964 16 VILLAGE RANCH ALTERNATIVE PROGRAM Educational Oversight to Public Residential Care & Treatment (State approved) Alternative Education School No 4 05 12 2015   grade_7 1.0 0.0 1.0   0.0 0.0     0.0   0.0   2.0 0.0         *         *   2.0 1 0 1   0 0     0   0   2 0                 2
1159150 MN Wright 86 school 2700360 4118 Charter Schools KALEIDOSCOPE CHARTER SCHOOL 270036004668 20 Kaleidoscope Charter School Junior High Junior High School (Grades 7-8 or 7-9) Regular School Yes 4 06 10 2015   grade_7 23.0 1.0 1.0   0.0 0.0     0.0   0.0   14.0 11.0     0.0   0.0     7.0   10.0   25.0 23 1 1   0 0     0   0   14 11     0 0   7 10   25
1712563 MN Wright 86 school 2710170 879 Independent Districts and Schools Delano Public School District 271017000438 20 Delano High School Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 200 1 8   0 0     0   9   114 104     3.0   0.0     16.0   23.0   218 200 1 8   0 0     0   9   114 104     3 0   16 23   218
1712570 MN Wright 86 school 2718810 881 Independent Districts and Schools Maple Lake Public School District 271881000886 20 Maple Lake Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 65 1 1   0 0     0   2   36 33     1.0   0.0     11.0   14.0   69 65 1 1   0 0     0   2   36 33     1 0   11 14   69
1713186 MN Wright 86 school 2700403 4229 Charter Schools Jane Goodall Environmental Science Academy 270040304850 10 Jane Goodall Environmental Science Academy Secondary School (Grades 7-12) Regular School Yes High 06 12 2021   grade_7 9 0 0   0 0     0   0   4 5     *   *     *   *   9 9 0 0   0 0     0   0   4 5                 9
1721042 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 2021   grade_7 141 0 9   0 2     0   4   92 64     1.0   0.0     23.0   21.0   156 141 0 9   0 2     0   4   92 64     1 0   23 21   156
1721280 MN Wright 86 school 2711370 728 Independent Districts and Schools Elk River School District 271137005253 380 Prairie View Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 142 11 9   0 1     0   12   81 94     7.0   0.0     *   26.0   175 142 11 9   0 1     0   12   81 94     7 0     26   175
1721366 MN Wright 86 school 2703150 876 Independent Districts and Schools Annandale Public School District 270315000093 2 Annandale Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 145 1 3   0 0     0   12   75 86     0.0   0.0     21.0   19.0   161 145 1 3   0 0     0   12   75 86     0 0   21 19   161
1721370 MN Wright 86 school 2707200 877 Independent Districts and Schools Buffalo-Hanover-Montrose Public Sch 270720000284 30 Buffalo Community Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 359 11 19   2 4     1   20   205 211     3.0   0.0     70.0   67.0   416 359 11 19   2 4     1   20   205 211     3 0   70 67   416
1721378 MN Wright 86 school 2721390 882 Independent Districts and Schools Monticello Public School District 272139002209 30 Monticello Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 274 8 35   1 4     0   18   186 154     3.0   1.0     71.0   39.0   340 274 8 35   1 4     0   18   186 154     3 1   71 39   340
1721383 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 2021   grade_7 102 7 9   0 2     0   8   64 64     3.0   0.0     25.0   16.0   128 102 7 9   0 2     0   8   64 64     3 0   25 16   128
1721388 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 2021   grade_7 201 6 8   1 7     0   18   121 120     1.0   0.0     27.0   24.0   241 201 6 8   1 7     0   18   121 120     1 0   27 24   241
1721393 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 2021   grade_7 250 12 11   0 4     0   9   145 141     6.0   0.0     38.0   17.0   286 250 12 11   0 4     0   9   145 141     6 0   38 17   286
1721458 MN Wright 86 school 2700123 2687 Independent Districts and Schools Howard Lake-Waverly-Winsted 270012303350 86 Howard Lake-Waverly-Winsted Middle School Middle School (Grades 5-8) Regular School No Middle 05 08 2021   grade_7 84 1 6   0 0     0   6   56 41     2.0   0.0     24.0   10.0   97 84 1 6   0 0     0   6   56 41     2 0   24 10   97
1721573 MN Wright 86 school 2700360 4118 Charter Schools Kaleidoscope Charter School 270036005071 30 Kaleidoscope Middle School Middle School (Grades 5-8) Regular School Yes Middle 06 08 2021   grade_7 32 1 1   0 0     0   1   21 14     2.0   0.0     7.0   13.0   35 32 1 1   0 0     0   1   21 14     2 0   7 13   35
1724137 MN Wright 86 school 2700045 938 Special Education Cooperatives Meeker And Wright Special Education 270004504402 10 Trek Program Special Education Special Education School No Other KG 12 2021   grade_7 2 0 0   0 0     0   0   2 0     *   *     *   *   2 2 0 0   0 0     0   0   2 0                 2
1724154 MN Wright 86 school 2700045 938 Special Education Cooperatives Meeker And Wright Special Education 270004502732 18 Eastern Wright Program Special Education Special Education School No Elementary KG 08 2021   grade_7 0 0 1   0 0     0   0   1 0     *   *     *   *   1 0 0 1   0 0     0   0   1 0                 1
1724249 MN Wright 86 school 2700413 6090 Special Education Cooperatives Sherburne and Northern Wright Special Education Cooperative 270041304909 30 SNW MS DCD Program Special Education Special Education School No Middle 06 08 2021   grade_7 2 0 0   0 0     0   0   2 0     *   *     *   *   2 2 0 0   0 0     0   0   2 0                 2
1724272 MN Wright 86 school 2700413 6090 Special Education Cooperatives Sherburne and Northern Wright Special Education Cooperative 270041305265 76 SNW Monti MS EBD Program Special Education Special Education School No Middle 06 08 2021   grade_7 3 0 0   0 0     0   0   3 0     *   *     *   *   3 3 0 0   0 0     0   0   3 0                 3
1724282 MN Wright 86 school 2700413 6090 Special Education Cooperatives Sherburne and Northern Wright Special Education Cooperative 270041305259 82 Foundations II Special Education Special Education School No Middle 05 09 2021   grade_7 4 0 0   0 0     0   0   3 1     *   *     *   *   4 4 0 0   0 0     0   0   3 1                 4

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