Data source: Big Local News · About: Big Local

4,774 rows where grade = "grade_7" and state = "MN" sorted by district 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
1721466 MN Goodhue 25 school 2745735 2805 Independent Districts and Schools Zumbrota-Mazeppa School District 274573500221 20 Zumbrota-Mazeppa Middle School Middle School (Grades 5-8) Regular School No Middle 07 08 2021   grade_7 93 2 2   0 0     0   0   53 44     0.0   0.0     15.0   12.0   97 93 2 2   0 0     0   0   53 44     0 0   15 12   97
1834990 MN Goodhue 25 school 2745735 2805 Independent Districts and Schools Zumbrota-Mazeppa School District 274573500221 20 Zumbrota-Mazeppa Middle School Middle School (Grades 5-8) Regular School No Middle 07 08 2020   grade_7 80.0 3.0 2.0   1.0 2.0     0.0   1.0   46.0 43.0     0.0   1.0     19.0   16.0   89.0 80 3 2   1 2     0   1   46 43     0 1   19 16   89
1889436 MN Goodhue 25 school 2745735 2805 Independent Districts and Schools Zumbrota-Mazeppa School District 274573500221 20 Zumbrota-Mazeppa Middle School Middle School (Grades 5-8) Regular School No Middle 07 08 2018   grade_7 83.0 3.0 5.0   0.0 1.0     0.0   0.0   42.0 50.0     2.0   1.0     21.0   11.0   92.0 83 3 5   0 1     0   0   42 50     2 1   21 11   92
1724476 MN Olmsted 55 school 2700054 6012 Education Districts Zumbro Education District 270005402500 30 Zumbro Ed. Dist. Futures/Choice Special Education Special Education School No Other KG 12 2021   grade_7 3 1 0   0 0     0   0   4 0     *   *     *   *   4 3 1 0   0 0     0   0   4 0                 4
1836853 MN Olmsted 55 school 2700054 6012 Education Districts Zumbro Education District 270005402492 20 Zumbro Area Learning Center Public Area Learning Center ALC (State approved) Alternative School No High 06 12 2020   grade_7 2.0 1.0 0.0   0.0 0.0     0.0   0.0   1.0 2.0     *   *         *   3.0 2 1 0   0 0     0   0   1 2                 3
1838027 MN Olmsted 55 school 2700054 6012 Education Districts Zumbro Education District 270005402500 30 Zumbro Ed. Dist. Futures/Choice Special Education Special Education School No Other KG 12 2020   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
1891307 MN Olmsted 55 school 2700054 6012 Education Districts Zumbro Education District 270005402492 20 Zumbro Area Learning Center Public Area Learning Center ALC (State approved) Alternative School No High 06 12 2018   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
1892448 MN Olmsted 55 school 2700054 6012 Education Districts Zumbro Education District 270005402500 30 Zumbro Ed. Dist. Futures/Choice Special Education Special Education School No Other KG 12 2018   grade_7 2.0 0.0 1.0   0.0 0.0     0.0   0.0   3.0 0.0     *   *     *   *   3.0 2 0 1   0 0     0   0   3 0                 3
698462 MN Goodhue 25 school 2745735 2805 Independent Districts and Schools ZUMBROTA-MAZEPPA SCHOOL DISTRICT 274573500221 20 ZUMBROTA-MAZEPPA MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 07 08 2017   grade_7 84.0 1.0 2.0   3.0 2.0     0.0   3.0   44.0 51.0     2.0   2.0     27.0   12.0   95.0 84 1 2   3 2     0   3   44 51     2 2   27 12   95
862632 MN Goodhue 25 school 2745735 2805 Independent Districts and Schools ZUMBROTA-MAZEPPA SCHOOL DISTRICT 274573500221 20 ZUMBROTA-MAZEPPA MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No 2 07 08 2016   grade_7 92 0 2   1 0     0   1   43 53     0.0   1.0     14.0   10.0   96 92 0 2   1 0     0   1   43 53     0 1   14 10   96
1155285 MN Goodhue 25 school 2745735 2805 Independent Districts and Schools ZUMBROTA-MAZEPPA SCHOOL DISTRICT 274573500221 20 ZUMBROTA-MAZEPPA MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No 2 07 08 2015   grade_7 74.0 2.0 1.0   0.0 2.0     0.0   0.0   41.0 38.0     0.0   2.0     18.0   9.0   79.0 74 2 1   0 2     0   0   41 38     0 2   18 9   79
1954044 MN Goodhue 25 school 2745735 2805 Independent Districts and Schools ZUMBROTA-MAZEPPA SCHOOL DISTRICT 274573500221 20 ZUMBROTA-MAZEPPA MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 07 08 2019   grade_7 93.0 0.0 5.0   1.0 2.0     0.0   2.0   56.0 47.0     1.0   1.0     21.0   16.0   103.0 93 0 5   1 2     0   2   56 47     1 1   21 16   103
700363 MN Olmsted 55 school 2700054 6012 Education Districts ZUMBRO EDUCATION DISTRICT 270005402492 20 ZUMBRO AREA LEARNING CENTER Public Area Learning Center ALC (State approved) Alternative School No Other 06 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
701511 MN Olmsted 55 school 2700054 6012 Education Districts ZUMBRO EDUCATION DISTRICT 270005402500 30 ZUMBRO ED. DIST. FUTURES/CHOICE Special Education Special Education School No Other KG 12 2017   grade_7 3.0 1.0 1.0   0.0 0.0     0.0   0.0   5.0 0.0         *         *   5.0 3 1 1   0 0     0   0   5 0                 5
865666 MN Olmsted 55 school 2700054 6012 Education Districts ZUMBRO EDUCATION DISTRICT 270005402500 30 ZUMBRO ED. DIST. FUTURES/CHOICE Special Education Special Education School No 4 KG 12 2016   grade_7 4 0 1   0 0     0   0   4 1         *         *   5 4 0 1   0 0     0   0   4 1                 5
1157168 MN Olmsted 55 school 2700054 6012 Education Districts ZUMBRO EDUCATION DISTRICT 270005402492 20 ZUMBRO AREA LEARNING CENTER 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   2.0 0.0         *         *   2.0 2 0 0   0 0     0   0   2 0                 2
1158200 MN Olmsted 55 school 2700054 6012 Education Districts ZUMBRO EDUCATION DISTRICT 270005402500 30 ZUMBRO ED. DIST. FUTURES/CHOICE 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
1955899 MN Olmsted 55 school 2700054 6012 Education Districts ZUMBRO EDUCATION DISTRICT 270005402492 20 ZUMBRO AREA LEARNING CENTER Public Area Learning Center ALC (State approved) Alternative School No High 06 12 2019   grade_7 1.0 1.0 0.0   0.0 0.0     0.0   0.0   1.0 1.0     *   *         *   2.0 1 1 0   0 0     0   0   1 1                 2
1957053 MN Olmsted 55 school 2700054 6012 Education Districts ZUMBRO EDUCATION DISTRICT 270005402500 30 ZUMBRO ED. DIST. FUTURES/CHOICE Special Education Special Education School No Other KG 12 2019   grade_7 2.0 0.0 1.0   0.0 0.0     0.0   0.0   3.0 0.0     *   *         *   3.0 2 0 1   0 0     0   0   3 0                 3
1719883 MN Hennepin 27 school 2700281 4140 Charter Schools Yinghua Academy 270028103611 10 Yinghua Academy Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2021   grade_7 51 7 4   0 34     0   1   48 49     2.0   0.0     6.0   8.0   97 51 7 4   0 34     0   1   48 49     2 0   6 8   97
1833436 MN Hennepin 27 school 2700281 4140 Charter Schools Yinghua Academy 270028103611 10 Yinghua Academy Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2020   grade_7 41.0 5.0 2.0   1.0 34.0     0.0   0.0   38.0 45.0     1.0   0.0     8.0   7.0   83.0 41 5 2   1 34     0   0   38 45     1 0   8 7   83
1887991 MN Hennepin 27 school 2700281 4140 Charter Schools Yinghua Academy 270028103611 10 Yinghua Academy Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2018   grade_7 24.0 2.0 2.0   0.0 31.0     0.0   0.0   31.0 28.0     2.0   0.0     5.0   2.0   59.0 24 2 2   0 31     0   0   31 28     2 0   5 2   59
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
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
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
697092 MN Hennepin 27 school 2700281 4140 Charter Schools YINGHUA ACADEMY 270028103611 10 YINGHUA ACADEMY Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2017   grade_7 30.0 3.0 2.0   1.0 18.0     0.0   0.0   25.0 29.0     0.0   0.0     6.0   5.0   54.0 30 3 2   1 18     0   0   25 29     0 0   6 5   54
861344 MN Hennepin 27 school 2700281 4140 Charter Schools YINGHUA ACADEMY 270028103611 10 YINGHUA ACADEMY Elementary School (Grades PK-6) Regular School Yes 1 KG 08 2016   grade_7 18 1 1   0 32     0   0   18 34     5.0   0.0     5.0   6.0   52 18 1 1   0 32     0   0   18 34     5 0   5 6   52
1154064 MN Hennepin 27 school 2700281 4140 Charter Schools YINGHUA ACADEMY 270028103611 10 YINGHUA ACADEMY Elementary School (Grades PK-6) Regular School Yes 1 KG 08 2015   grade_7 11.0 0.0 0.0   1.0 13.0     0.0   0.0   11.0 14.0     0.0   0.0     4.0   5.0   25.0 11 0 0   1 13     0   0   11 14     0 0   4 5   25
1952559 MN Hennepin 27 school 2700281 4140 Charter Schools YINGHUA ACADEMY 270028103611 10 YINGHUA ACADEMY Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2019   grade_7 47.0 5.0 0.0   2.0 22.0     0.0   0.0   30.0 46.0     3.0   1.0     10.0   9.0   76.0 47 5 0   2 22     0   0   30 46     3 1   10 9   76
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
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
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
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
1711759 MN Carlton 9 school 2744190 100 Independent Districts and Schools Wrenshall Public School District 274419001843 2 Wrenshall Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 29 0 1   1 0     0   2   18 15     0.0   0.0     18.0   7.0   33 29 0 1   1 0     0   2   18 15     0 0   18 7   33
1825328 MN Carlton 9 school 2744190 100 Independent Districts and Schools Wrenshall Public School District 274419001843 2 Wrenshall Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2020   grade_7 23.0 1.0 0.0   0.0 0.0     0.0   3.0   13.0 14.0     1.0   0.0     12.0   7.0   27.0 23 1 0   0 0     0   3   13 14     1 0   12 7   27
1879925 MN Carlton 9 school 2744190 100 Independent Districts and Schools Wrenshall Public School District 274419001843 2 Wrenshall Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_7 22.0 1.0 0.0   0.0 0.0     0.0   2.0   11.0 14.0     0.0   0.0     19.0   5.0   25.0 22 1 0   0 0     0   2   11 14     0 0   19 5   25
1721093 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 2021   grade_7 48 17 139   2 35     0   8   122 127     65.0   0.0     158.0   38.0   249 48 17 139   2 35     0   8   122 127     65 0   158 38   249
1723046 MN Nobles 53 school 2744160 518 Independent Districts and Schools Worthington Public School District 274416002335 6 Learning Center Public Area Learning Center ALC (State approved) Alternative School No High 07 12 2021   grade_7 0 0 2   0 0     0   0   1 1     *   *     *   *   2 0 0 2   0 0     0   0   1 1                 2
1724809 MN Nobles 53 school 2744160 518 Independent Districts and Schools Worthington Public School District 274416004676 20 Worthington 518 (Virtual Instruction By Excellence) Distance Learning Program OLL (State approved) Regular School No Other KG 12 2021   grade_7 3 0 4   0 0     0   0   3 4     *   *     *   *   7 3 0 4   0 0     0   0   3 4                 7
1834608 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 2020   grade_7 59.0 15.0 148.0   0.0 23.0     0.0   5.0   117.0 133.0     *   *     188.0   37.0   250.0 59 15 148   0 23     0   5   117 133           188 37   250
1836554 MN Nobles 53 school 2744160 518 Independent Districts and Schools Worthington Public School District 274416002335 6 Learning Center Public Area Learning Center ALC (State approved) Alternative School No High 07 12 2020   grade_7 0.0 0.0 0.0   0.0 1.0     0.0   0.0   1.0 0.0     *   *         *   1.0 0 0 0   0 1     0   0   1 0                 1
1838383 MN Nobles 53 school 2744160 518 Independent Districts and Schools Worthington Public School District 274416004676 20 Worthington 518 (Virtual Instruction By Excellence) Distance Learning Program OLL (State approved) Regular School No Other KG 12 2020   grade_7 28.0 3.0 2.0   0.0 2.0     0.0   1.0   23.0 13.0     0.0   0.0         *   36.0 28 3 2   0 2     0   1   23 13     0 0         36
1889084 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 2018   grade_7 67.0 20.0 110.0   1.0 29.0     1.0   4.0   124.0 108.0     *   *     158.0   *   232.0 67 20 110   1 29     1   4   124 108           158     232
1890995 MN Nobles 53 school 2744160 518 Independent Districts and Schools Worthington Public School District 274416002335 6 Worthington Area Learning Center Public Area Learning Center ALC (State approved) Alternative School No High 07 12 2018   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
1892786 MN Nobles 53 school 2744160 518 Independent Districts and Schools Worthington Public School District 274416004676 20 Worthington 518 (Virtual Instruction by Excellence) Distance Learning Program OLL (State approved) Regular School No Other KG 12 2018   grade_7 22.0 0.0 3.0   0.0 0.0     0.0   1.0   12.0 14.0     0.0   0.0     *   0.0   26.0 22 0 3   0 0     0   1   12 14     0 0     0   26
1719488 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 2021   grade_7 19 1 2   0 2     0   0   8 16     0.0   0.0     1.0   3.0   24 19 1 2   0 2     0   0   8 16     0 0   1 3   24
1833032 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 2020   grade_7 25.0 0.0 1.0   0.0 1.0     0.0   0.0   12.0 15.0     0.0   0.0     3.0   5.0   27.0 25 0 1   0 1     0   0   12 15     0 0   3 5   27
1887587 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 2018   grade_7 19.0 3.0 0.0   0.0 0.0     0.0   1.0   10.0 13.0     2.0   0.0     2.0   5.0   23.0 19 3 0   0 0     0   1   10 13     2 0   2 5   23
697489 MN Washington 82 school 2700401 4228 Charter Schools Woodbury Leadership Academy 270040104812 10 Woodbury Leadership Academy Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2017   grade_7 5.0 0.0 2.0   0.0 2.0     0.0   1.0   4.0 6.0     0.0   0.0     0.0   *   10.0 5 0 2   0 2     0   1   4 6     0 0   0     10
861731 MN Washington 82 school 2700401 4228 Charter Schools Woodbury Leadership Academy 270040104812 10 Woodbury Leadership Academy Elementary School (Grades PK-6) Regular School Yes 1 KG 07 2016   grade_7 15 0 0   0 1     0   1   9 8     0.0   0.0     1.0   3.0   17 15 0 0   0 1     0   1   9 8     0 0   1 3   17
1720316 MN Washington 82 school 2700401 4228 Charter Schools Woodbury Leadership Academy 270040104812 10 Woodbury Leadership Academy Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2021   grade_7 10 12 2   0 4     0   1   15 14     0.0   0.0     4.0   6.0   29 10 12 2   0 4     0   1   15 14     0 0   4 6   29
1833868 MN Washington 82 school 2700401 4228 Charter Schools Woodbury Leadership Academy 270040104812 10 Woodbury Leadership Academy Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2020   grade_7 12.0 7.0 0.0   0.0 1.0     0.0   1.0   12.0 9.0     0.0   0.0     6.0   8.0   21.0 12 7 0   0 1     0   1   12 9     0 0   6 8   21
1952978 MN Washington 82 school 2700401 4228 Charter Schools Woodbury Leadership Academy 270040104812 10 Woodbury Leadership Academy Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2019   grade_7 5.0 4.0 1.0   0.0 2.0     0.0   2.0   7.0 7.0     0.0   0.0     3.0   4.0   14.0 5 4 1   0 2     0   2   7 7     0 0   3 4   14
1721362 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 2021   grade_7 166 16 11   0 4     0   9   111 95     *   *     *   *   206 166 16 11   0 4     0   9   111 95                 206
1723193 MN Winona 85 school 2744070 861 Independent Districts and Schools Winona Area Public School District 274407002249 19 Winona Area Learning Center Public Area Learning Center ALC (State approved) Alternative School No High 06 12 2021   grade_7 3 0 0   0 0     0   0   2 1     *   *     *   *   3 3 0 0   0 0     0   0   2 1                 3
1834878 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 2020   grade_7 161.0 18.0 14.0   1.0 11.0     0.0   13.0   116.0 102.0     9.0   0.0     96.0   39.0   218.0 161 18 14   1 11     0   13   116 102     9 0   96 39   218
1889331 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 2018   grade_7 184.0 7.0 7.0   1.0 7.0     0.0   13.0   107.0 112.0     8.0   0.0     68.0   39.0   219.0 184 7 7   1 7     0   13   107 112     8 0   68 39   219
1720781 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 06 08 2021   grade_7 61 1 13   0 2     0   2   44 35     4.0   0.0     27.0   17.0   79 61 1 13   0 2     0   2   44 35     4 0   27 17   79
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
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
1712792 MN Polk 60 school 2791449 2609 Independent Districts and Schools Win-E-Mac School District 279144902322 20 Win-E-Mac Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 31 0 0   1 0     0   0   16 16     0.0   0.0     7.0   5.0   32 31 0 0   1 0     0   0   16 16     0 0   7 5   32
1826368 MN Polk 60 school 2791449 2609 Independent Districts and Schools Win-E-Mac School District 279144902322 20 Win-E-Mac Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2020   grade_7 39.0 0.0 2.0   0.0 0.0     0.0   1.0   18.0 24.0     0.0   0.0     25.0   4.0   42.0 39 0 2   0 0     0   1   18 24     0 0   25 4   42
1880971 MN Polk 60 school 2791449 2609 Independent Districts and Schools Win-E-Mac School District 279144902322 20 Win-E-Mac Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_7 27.0 0.0 0.0   0.0 0.0     0.0   0.0   15.0 12.0     0.0   0.0     15.0   9.0   27.0 27 0 0   0 0     0   0   15 12     0 0   15 9   27
1712228 MN Pine 58 school 2742750 577 Independent Districts and Schools Willow River Public School District 274275001812 40 Willow River Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 35 0 0   1 0     0   3   22 17     0.0   0.0     15.0   5.0   39 35 0 0   1 0     0   3   22 17     0 0   15 5   39
1825796 MN Pine 58 school 2742750 577 Independent Districts and Schools Willow River Public School District 274275001812 40 Willow River Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2020   grade_7 28.0 0.0 0.0   1.0 1.0     0.0   0.0   17.0 13.0     1.0   0.0     10.0   6.0   30.0 28 0 0   1 1     0   0   17 13     1 0   10 6   30
1880397 MN Pine 58 school 2742750 577 Independent Districts and Schools Willow River Public School District 274275001812 40 Willow River Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_7 38.0 0.0 2.0   1.0 0.0     0.0   0.0   20.0 21.0     0.0   0.0     16.0   10.0   41.0 38 0 2   1 0     0   0   20 21     0 0   16 10   41
1721018 MN Kandiyohi 34 school 2742720 347 Independent Districts and Schools Willmar Public School District 274272001808 301 Willmar Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 101 56 109   2 7     2   9   151 135     *   *     *   *   286 101 56 109   2 7     2   9   151 135                 286
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
1834533 MN Kandiyohi 34 school 2742720 347 Independent Districts and Schools Willmar Public School District 274272001808 301 Willmar Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2020   grade_7 136.0 48.0 114.0   0.0 9.0     1.0   2.0   147.0 163.0     60.0   *     187.0   44.0   310.0 136 48 114   0 9     1   2   147 163     60     187 44   310
1836487 MN Kandiyohi 34 school 2742720 347 Independent Districts and Schools Willmar Public School District 274272000950 949 Willmar Area Learning Center Public Area Learning Center ALC (State approved) Alternative School No High 07 12 2020   grade_7 0.0 1.0 3.0   0.0 0.0     0.0   0.0   4.0 0.0     *   *         *   4.0 0 1 3   0 0     0   0   4 0                 4
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
1889009 MN Kandiyohi 34 school 2742720 347 Independent Districts and Schools Willmar Public School District 274272001808 301 Willmar Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2018   grade_7 140.0 55.0 115.0   2.0 9.0     1.0   4.0   171.0 155.0     62.0   2.0     201.0   42.0   326.0 140 55 115   2 9     1   4   171 155     62 2   201 42   326
1890919 MN Kandiyohi 34 school 2742720 347 Independent Districts and Schools Willmar Public School District 274272000950 949 Willmar Area Learning Center Public Area Learning Center ALC (State approved) Alternative School No High 07 12 2018   grade_7 1.0 0.0 5.0   0.0 0.0     0.0   1.0   5.0 2.0     *   *     *   *   7.0 1 0 5   0 0     0   1   5 2                 7
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
1721174 MN Ramsey 62 school 2742360 624 Independent Districts and Schools White Bear Lake School District 274236001787 57 Central Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 302 21 26   2 21     0   22   186 208     3.0   0.0     98.0   45.0   394 302 21 26   2 21     0   22   186 208     3 0   98 45   394
1721178 MN Ramsey 62 school 2742360 624 Independent Districts and Schools White Bear Lake School District 274236001049 59 Sunrise Park Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 185 32 28   0 21     0   31   139 158     14.0   2.0     130.0   46.0   297 185 32 28   0 21     0   31   139 158     14 2   130 46   297
1834690 MN Ramsey 62 school 2742360 624 Independent Districts and Schools White Bear Lake School District 274236001787 57 Central Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2020   grade_7 323.0 12.0 26.0   0.0 14.0     0.0   22.0   197.0 200.0     3.0   2.0     72.0   51.0   397.0 323 12 26   0 14     0   22   197 200     3 2   72 51   397
1834694 MN Ramsey 62 school 2742360 624 Independent Districts and Schools White Bear Lake School District 274236001049 59 Sunrise Park Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2020   grade_7 199.0 25.0 22.0   3.0 29.0     0.0   24.0   155.0 147.0     13.0   6.0     107.0   42.0   302.0 199 25 22   3 29     0   24   155 147     13 6   107 42   302
1889161 MN Ramsey 62 school 2742360 624 Independent Districts and Schools White Bear Lake School District 274236001787 57 Central Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2018   grade_7 292.0 11.0 23.0   0.0 14.0     0.0   18.0   170.0 188.0     4.0   1.0     80.0   39.0   358.0 292 11 23   0 14     0   18   170 188     4 1   80 39   358
1889165 MN Ramsey 62 school 2742360 624 Independent Districts and Schools White Bear Lake School District 274236001049 59 Sunrise Park Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2018   grade_7 183.0 33.0 15.0   2.0 26.0     1.0   17.0   143.0 134.0     6.0   2.0     100.0   48.0   277.0 183 33 15   2 26     1   17   143 134     6 2   100 48   277
1712473 MN Traverse 78 school 2742330 803 Independent Districts and Schools Wheaton Area Public School District 274233001784 2 Wheaton Secondary Secondary School (Grades 7-12) Regular School No High 06 12 2021   grade_7 19 0 6   0 0     0   1   14 12     1.0   0.0     12.0   6.0   26 19 0 6   0 0     0   1   14 12     1 0   12 6   26
1826050 MN Traverse 78 school 2742330 803 Independent Districts and Schools Wheaton Area Public School District 274233001784 2 Wheaton Secondary Secondary School (Grades 7-12) Regular School No High 06 12 2020   grade_7 25.0 0.0 0.0   0.0 0.0     0.0   1.0   9.0 17.0     0.0   0.0     6.0   2.0   26.0 25 0 0   0 0     0   1   9 17     0 0   6 2   26
1880650 MN Traverse 78 school 2742330 803 Independent Districts and Schools Wheaton Area Public School District 274233001784 2 Wheaton Secondary Secondary School (Grades 7-12) Regular School No High 06 12 2018   grade_7 24.0 0.0 3.0   0.0 0.0     0.0   2.0   22.0 7.0     0.0   0.0     8.0   4.0   29.0 24 0 3   0 0     0   2   22 7     0 0   8 4   29
1720919 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 2021   grade_7 160 8 11   0 1     0   13   89 104     3.0   0.0     26.0   36.0   193 160 8 11   0 1     0   13   89 104     3 0   26 36   193
1834437 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 2020   grade_7 162.0 3.0 6.0   0.0 2.0     0.0   15.0   96.0 92.0     0.0   1.0     29.0   30.0   188.0 162 3 6   0 2     0   15   96 92     0 1   29 30   188
1888917 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 2018   grade_7 178.0 5.0 7.0   1.0 3.0     0.0   7.0   103.0 98.0     0.0   0.0     25.0   28.0   201.0 178 5 7   1 3     0   7   103 98     0 0   25 28   201
1712915 MN Cottonwood 17 school 2700183 2898 Independent Districts and Schools Westbrook-Walnut Grove Schools 270018301782 30 Westbrook-Walnut Grove Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 24 0 0   0 12     0   0   16 20     5.0   0.0     23.0   3.0   36 24 0 0   0 12     0   0   16 20     5 0   23 3   36
1826490 MN Cottonwood 17 school 2700183 2898 Independent Districts and Schools Westbrook-Walnut Grove Schools 270018301782 30 Westbrook-Walnut Grove Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2020   grade_7 19.0 0.0 2.0   0.0 6.0     0.0   0.0   11.0 16.0     3.0   0.0     16.0   2.0   27.0 19 0 2   0 6     0   0   11 16     3 0   16 2   27
1881093 MN Cottonwood 17 school 2700183 2898 Independent Districts and Schools Westbrook-Walnut Grove Schools 270018301782 30 Westbrook-Walnut Grove Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_7 21.0 0.0 0.0   0.0 2.0     0.0   0.0   13.0 10.0     1.0   0.0     12.0   5.0   23.0 21 0 0   0 2     0   0   13 10     1 0   12 5   23
1834362 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 2020   grade_7 104.0 31.0 48.0   3.0 9.0     0.0   14.0   109.0 100.0     *   *         33.0   209.0 104 31 48   3 9     0   14   109 100             33   209
1834367 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 2020   grade_7 88.0 19.0 71.0   3.0 6.0     0.0   14.0   109.0 92.0     *   4.0     106.0   45.0   201.0 88 19 71   3 6     0   14   109 92       4   106 45   201
1837028 MN Dakota 19 school 2742270 197 Independent Districts and Schools West St. Paul-Mendota Hts.-Eagan 274227005008 827 Special Education Special Education Special Education School No Other KG 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
1720848 MN Dakota 19 school 2742270 197 Independent Districts and Schools West St. Paul-Mendota Heights-Eagan 274227002646 52 Friendly Hills Middle Middle School (Grades 5-8) Regular School No Middle 05 08 2021   grade_7 100 32 53   0 9     0   13   109 98     *   2.0     90.0   32.0   207 100 32 53   0 9     0   13   109 98       2   90 32   207
1720853 MN Dakota 19 school 2742270 197 Independent Districts and Schools West St. Paul-Mendota Heights-Eagan 274227001774 54 Heritage E-STEM Magnet School Middle School (Grades 5-8) Regular School No Middle 05 08 2021   grade_7 85 19 73   3 4     0   17   96 105     *   6.0     99.0   35.0   201 85 19 73   3 4     0   17   96 105       6   99 35   201
1888842 MN Dakota 19 school 2742270 197 Independent Districts and Schools West St. Paul-Mendota Heights-Eagan 274227002646 52 Friendly Hills Middle Middle School (Grades 5-8) Regular School No Middle 05 08 2018   grade_7 95.0 27.0 26.0   0.0 10.0     0.0   14.0   89.0 83.0     12.0   1.0     58.0   25.0   172.0 95 27 26   0 10     0   14   89 83     12 1   58 25   172
1888847 MN Dakota 19 school 2742270 197 Independent Districts and Schools West St. Paul-Mendota Heights-Eagan 274227001774 54 Heritage E-STEM Magnet School Middle School (Grades 5-8) Regular School No Middle 05 08 2018   grade_7 76.0 12.0 65.0   0.0 4.0     0.0   13.0   80.0 90.0     22.0   0.0     86.0   26.0   170.0 76 12 65   0 4     0   13   80 90     22 0   86 26   170
1888307 MN Ramsey 62 school 2700374 4212 Charter Schools West Side Summit Charter School 270037404588 10 West Side Summit Charter School Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2018   grade_7 0.0 5.0 8.0   0.0 0.0     0.0   0.0   5.0 8.0     *   4.0     10.0   2.0   13.0 0 5 8   0 0     0   0   5 8       4   10 2   13
1723357 MN Stearns 73 school 2791455 6026 Education Districts West Central Education District 279145502388 20 West Central Area Learning Center Public Area Learning Center ALC (State approved) Alternative School No High 06 12 2021   grade_7 1 0 1   0 0     0   2   2 2     *   *     *   *   4 1 0 1   0 0     0   2   2 2                 4
1724512 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 KG 12 2021   grade_7 1 0 0   0 0     0   0   1 0     *   *     *   *   1 1 0 0   0 0     0   0   1 0                 1

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "enrollments" (
   [state] TEXT,
   [county] TEXT,
   [county_state_id] INTEGER,
   [admin_level] TEXT,
   [district_nces_id] INTEGER,
   [district_state_id] TEXT,
   [district_state_type] TEXT,
   [district] TEXT,
   [school_nces_id] INTEGER,
   [school_state_id] INTEGER,
   [school] TEXT,
   [school_state_type] TEXT,
   [ccd_school_type] TEXT,
   [ccd_charter_school] TEXT,
   [ccd_school_lvl] TEXT,
   [ccd_school_low_grade] TEXT,
   [ccd_school_high_grade] TEXT,
   [year] INTEGER,
   [term] TEXT,
   [grade] TEXT,
   [white] TEXT,
   [black] TEXT,
   [hispanic] TEXT,
   [native_american] TEXT,
   [native_american_alaskan_native] TEXT,
   [asian] TEXT,
   [native_hawaiian] TEXT,
   [asian_pacific_islander] TEXT,
   [native_hawaiian_pacific_islander] TEXT,
   [pacific_islander] TEXT,
   [multiracial] TEXT,
   [unknown_race] TEXT,
   [male] TEXT,
   [female] TEXT,
   [non_binary] TEXT,
   [unknown_gender] TEXT,
   [ell] TEXT,
   [ell_percent] TEXT,
   [homeless] TEXT,
   [homeless_percent] TEXT,
   [low_income] TEXT,
   [free_and_reduced] TEXT,
   [free_and_reduced_percent] TEXT,
   [disability] TEXT,
   [section_504] TEXT,
   [total] TEXT
, [white_int] INTEGER, [black_int] INTEGER, [hispanic_int] INTEGER, [native_american_int] INTEGER, [native_american_alaskan_native_int] INTEGER, [asian_int] INTEGER, [native_hawaiian_int] INTEGER, [asian_pacific_islander_int] INTEGER, [native_hawaiian_pacific_islander_int] INTEGER, [pacific_islander_int] INTEGER, [multiracial_int] INTEGER, [unknown_race_int] INTEGER, [male_int] INTEGER, [female_int] INTEGER, [non_binary_int] INTEGER, [unknown_gender_int] INTEGER, [ell_int] INTEGER, [homeless_int] INTEGER, [low_income_int] INTEGER, [free_and_reduced_int] INTEGER, [disability_int] INTEGER, [section_504_int] INTEGER, [total_int] INTEGER);
CREATE INDEX [idx_enrollments_state_grade]
    ON [enrollments] ([state], [grade]);
CREATE INDEX [idx_enrollments_grade]
    ON [enrollments] ([grade]);
CREATE INDEX [idx_enrollments_year]
    ON [enrollments] ([year]);
CREATE INDEX [idx_enrollments_state_year]
    ON [enrollments] ([state], [year]);
CREATE INDEX [idx_enrollments_school_nces_id]
    ON [enrollments] ([school_nces_id]);
CREATE INDEX [idx_enrollments_district_nces_id]
    ON [enrollments] ([district_nces_id]);