Data source: Big Local News · About: Big Local

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

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
690129 MN Meeker 47 school 2700106 2396 Independent Districts and Schools A.C.G.C. Public School District 270010602570 300 A.C.G.C. SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   grade_7 62.0 0.0 6.0   2.0 0.0     0.0   0.0   41.0 29.0     2.0   1.0     32.0   12.0   70.0 62 0 6   2 0     0   0   41 29     2 1   32 12   70
854553 MN Meeker 47 school 2700106 2396 Independent Districts and Schools A.C.G.C. Public School District 270010602570 300 A.C.G.C. SECONDARY Secondary School (Grades 7-12) Regular School No 3 07 12 2016   grade_7 47 0 4   0 0     0   0   31 20     2.0   0.0     24.0   12.0   51 47 0 4   0 0     0   0   31 20     2 0   24 12   51
1147243 MN Meeker 47 school 2700106 2396 Independent Districts and Schools A.C.G.C. Public School District 270010602570 300 A.C.G.C. SECONDARY Secondary School (Grades 7-12) Regular School No 3 07 12 2015   grade_7 55.0 0.0 6.0   0.0 0.0     0.0   1.0   32.0 30.0     0.0   0.0     24.0   7.0   62.0 55 0 6   0 0     0   1   32 30     0 0   24 7   62
1712778 MN Meeker 47 school 2700106 2396 Independent Districts and Schools A.C.G.C. Public School District 270010602570 300 A.C.G.C. Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 54 0 3   1 0     0   3   26 35     0.0   0.0     20.0   18.0   61 54 0 3   1 0     0   3   26 35     0 0   20 18   61
1826354 MN Meeker 47 school 2700106 2396 Independent Districts and Schools A.C.G.C. Public School District 270010602570 300 A.C.G.C. Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2020   grade_7 65.0 0.0 6.0   0.0 0.0     0.0   3.0   42.0 32.0     2.0   0.0     38.0   15.0   74.0 65 0 6   0 0     0   3   42 32     2 0   38 15   74
1880934 MN Meeker 47 school 2700106 2396 Independent Districts and Schools A.C.G.C. Public School District 270010602570 300 A.C.G.C. Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_7 63.0 0.0 5.0   1.0 0.0     0.0   4.0   38.0 35.0     0.0   1.0     32.0   16.0   73.0 63 0 5   1 0     0   4   38 35     0 1   32 16   73
1945489 MN Meeker 47 school 2700106 2396 Independent Districts and Schools A.C.G.C. Public School District 270010602570 300 A.C.G.C. SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_7 45.0 0.0 7.0   0.0 0.0     0.0   1.0   23.0 30.0     3.0   0.0     22.0   10.0   53.0 45 0 7   0 0     0   1   23 30     3 0   22 10   53
696721 MN Ramsey 62 school 2700118 4018 Charter Schools ACHIEVE LANGUAGE ACADEMY 270011802608 10 ACHIEVE LANGUAGE ACADEMY Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2017   grade_7 3.0 5.0 19.0   0.0 21.0     0.0   2.0   24.0 26.0     27.0   0.0     44.0   9.0   50.0 3 5 19   0 21     0   2   24 26     27 0   44 9   50
860984 MN Ramsey 62 school 2700118 4018 Charter Schools ACHIEVE LANGUAGE ACADEMY 270011802608 10 ACHIEVE LANGUAGE ACADEMY Elementary School (Grades PK-6) Regular School Yes 1 PK 08 2016   grade_7 2 5 12   0 24     0   1   18 26     29.0   0.0     38.0   11.0   44 2 5 12   0 24     0   1   18 26     29 0   38 11   44
1153692 MN Ramsey 62 school 2700118 4018 Charter Schools ACHIEVE LANGUAGE ACADEMY 270011802608 10 ACHIEVE LANGUAGE ACADEMY Elementary School (Grades PK-6) Regular School Yes 1 PK 08 2015   grade_7 7.0 5.0 14.0   0.0 22.0     0.0   0.0   26.0 22.0     25.0   0.0     36.0   6.0   48.0 7 5 14   0 22     0   0   26 22     25 0   36 6   48
1952201 MN Ramsey 62 school 2700118 4018 Charter Schools ACHIEVE LANGUAGE ACADEMY 270011802608 10 ACHIEVE LANGUAGE ACADEMY Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2019   grade_7 5.0 4.0 24.0   0.0 14.0     0.0   1.0   18.0 30.0     17.0   2.0     40.0   9.0   48.0 5 4 24   0 14     0   1   18 30     17 2   40 9   48
690223 MN Norman 54 school 2700126 2854 Independent Districts and Schools ADA-BORUP PUBLIC SCHOOL DISTRICT 270012600051 30 ADA-BORUP SECONDARY Secondary School (Grades 7-12) Regular School No Other 06 12 2017   grade_7 33.0 0.0 4.0   0.0 1.0     0.0   0.0   19.0 19.0     0.0   0.0     14.0   2.0   38.0 33 0 4   0 1     0   0   19 19     0 0   14 2   38
854653 MN Norman 54 school 2700126 2854 Independent Districts and Schools ADA-BORUP PUBLIC SCHOOL DISTRICT 270012600051 30 ADA-BORUP SECONDARY Secondary School (Grades 7-12) Regular School No 3 07 12 2016   grade_7 21 0 2   2 0     0   1   17 9     0.0   0.0     12.0   5.0   26 21 0 2   2 0     0   1   17 9     0 0   12 5   26
1147343 MN Norman 54 school 2700126 2854 Independent Districts and Schools ADA-BORUP PUBLIC SCHOOL DISTRICT 270012600051 30 ADA-BORUP SECONDARY Secondary School (Grades 7-12) Regular School No 3 07 12 2015   grade_7 43.0 0.0 3.0   2.0 0.0     0.0   1.0   27.0 22.0     2.0   0.0     21.0   10.0   49.0 43 0 3   2 0     0   1   27 22     2 0   21 10   49
1945576 MN Norman 54 school 2700126 2854 Independent Districts and Schools ADA-BORUP PUBLIC SCHOOL DISTRICT 270012600051 30 ADA-BORUP SECONDARY Secondary School (Grades 7-12) Regular School No High 06 12 2019   grade_7 40.0 0.0 8.0   1.0 2.0     0.0   3.0   31.0 23.0     0.0   0.0     19.0   7.0   54.0 40 0 8   1 2     0   3   31 23     0 0   19 7   54
698110 MN Nobles 53 school 2702730 511 Independent Districts and Schools ADRIAN PUBLIC SCHOOL DISTRICT 270273003076 15 ADRIAN MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_7 27.0 0.0 9.0   0.0 3.0     0.0   1.0   20.0 20.0     2.0   0.0     14.0   4.0   40.0 27 0 9   0 3     0   1   20 20     2 0   14 4   40
862291 MN Nobles 53 school 2702730 511 Independent Districts and Schools ADRIAN PUBLIC SCHOOL DISTRICT 270273003076 15 ADRIAN MIDDLE Middle School (Grades 5-8) Regular School No 2 06 08 2016   grade_7 32 0 6   0 1     0   1   19 21     1.0   0.0     15.0   5.0   40 32 0 6   0 1     0   1   19 21     1 0   15 5   40
1154947 MN Nobles 53 school 2702730 511 Independent Districts and Schools ADRIAN PUBLIC SCHOOL DISTRICT 270273003076 15 ADRIAN MIDDLE Middle School (Grades 5-8) Regular School No 2 06 08 2015   grade_7 41.0 0.0 2.0   2.0 0.0     0.0   0.0   25.0 20.0     0.0   0.0     12.0   6.0   45.0 41 0 2   2 0     0   0   25 20     0 0   12 6   45
1953675 MN Nobles 53 school 2702730 511 Independent Districts and Schools ADRIAN PUBLIC SCHOOL DISTRICT 270273003076 15 ADRIAN MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_7 39.0 0.0 2.0   0.0 2.0     0.0   1.0   24.0 20.0     1.0   0.0     19.0   5.0   44.0 39 0 2   0 2     0   1   24 20     1 0   19 5   44
698545 MN Ramsey 62 school 2700186 4074 Charter Schools AFSA HIGH SCHOOL 270018604854 20 AFSA Middle School Middle School (Grades 5-8) Regular School Yes Middle 05 08 2017   grade_7 29.0 4.0 1.0   0.0 0.0     0.0   2.0   21.0 15.0     0.0   0.0     6.0   4.0   36.0 29 4 1   0 0     0   2   21 15     0 0   6 4   36
862723 MN Ramsey 62 school 2700186 4074 Charter Schools AFSA HIGH SCHOOL 270018604854 20 AFSA Middle School Middle School (Grades 5-8) Regular School Yes 2 05 08 2016   grade_7 33 1 2   0 1     0   5   21 21     0.0   0.0     12.0   13.0   42 33 1 2   0 1     0   5   21 21     0 0   12 13   42
1147504 MN Ramsey 62 school 2700186 4074 Charter Schools AFSA HIGH SCHOOL 270018603139 10 AFSA HIGH SCHOOL Secondary School (Grades 7-12) Regular School Yes 3 07 12 2015   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
1155364 MN Ramsey 62 school 2700186 4074 Charter Schools AFSA HIGH SCHOOL 270018604854 20 AFSA Middle School Middle School (Grades 5-8) Regular School Yes 2 05 08 2015   grade_7 28.0 4.0 2.0   0.0 2.0     0.0   6.0   26.0 16.0         *         *   42.0 28 4 2   0 2     0   6   26 16                 42
1945751 MN Ramsey 62 school 2700186 4074 Charter Schools AFSA HIGH SCHOOL 270018603139 10 AFSA HIGH SCHOOL Secondary School (Grades 7-12) Regular School Yes High 07 12 2019   grade_7 19.0 6.0 1.0   0.0 4.0     0.0   0.0   21.0 9.0     0.0   0.0     13.0   9.0   30.0 19 6 1   0 4     0   0   21 9     0 0   13 9   30
1719683 MN Ramsey 62 school 2700186 4074 Charter Schools AFSA High School 270018604854 20 AFSA Middle School Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2021   grade_7 24 2 4   0 1     0   3   16 18     0.0   0.0     11.0   9.0   34 24 2 4   0 1     0   3   16 18     0 0   11 9   34
1833238 MN Ramsey 62 school 2700186 4074 Charter Schools AFSA High School 270018604854 20 AFSA Middle School Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2020   grade_7 26.0 6.0 8.0   0.0 3.0     0.0   6.0   26.0 23.0     0.0   0.0     23.0   7.0   49.0 26 6 8   0 3     0   6   26 23     0 0   23 7   49
1881207 MN Ramsey 62 school 2700186 4074 Charter Schools AFSA High School 270018603139 10 AFSA High School Secondary School (Grades 7-12) Regular School Yes High 07 12 2018   grade_7 17.0 5.0 5.0   0.0 2.0     0.0   0.0   14.0 15.0     0.0   0.0     15.0   5.0   29.0 17 5 5   0 2     0   0   14 15     0 0   15 5   29
689010 MN Aitkin 1 school 2702760 1 Independent Districts and Schools AITKIN PUBLIC SCHOOL DISTRICT 270276000057 1 AITKIN SECONDARY SCHOOL Secondary School (Grades 7-12) Regular School No High 07 12 2017   grade_7 102.0 0.0 1.0   0.0 0.0     0.0   4.0   55.0 52.0     0.0   0.0     39.0   14.0   107.0 102 0 1   0 0     0   4   55 52     0 0   39 14   107
853415 MN Aitkin 1 school 2702760 1 Independent Districts and Schools AITKIN PUBLIC SCHOOL DISTRICT 270276000057 1 AITKIN SECONDARY SCHOOL Secondary School (Grades 7-12) Regular School No 3 07 12 2016   grade_7 96 2 1   1 0     0   2   49 53     0.0   0.0     45.0   8.0   102 96 2 1   1 0     0   2   49 53     0 0   45 8   102
1146098 MN Aitkin 1 school 2702760 1 Independent Districts and Schools AITKIN PUBLIC SCHOOL DISTRICT 270276000057 1 AITKIN SECONDARY SCHOOL Secondary School (Grades 7-12) Regular School No 3 07 12 2015   grade_7 73.0 0.0 0.0   2.0 0.0     0.0   2.0   38.0 39.0     0.0   0.0     29.0   10.0   77.0 73 0 0   2 0     0   2   38 39     0 0   29 10   77
1944368 MN Aitkin 1 school 2702760 1 Independent Districts and Schools AITKIN PUBLIC SCHOOL DISTRICT 270276000057 1 AITKIN SECONDARY SCHOOL Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_7 80.0 1.0 1.0   2.0 0.0     0.0   3.0   36.0 51.0     0.0   0.0     40.0   10.0   87.0 80 1 1   2 0     0   3   36 51     0 0   40 10   87
702566 MN Stearns 73 school 2702930 745 Independent Districts and Schools ALBANY PUBLIC SCHOOL DISTRICT 270293000063 50 ALBANY JUNIOR HIGH Junior High School (Grades 7-8 or 7-9) Regular School No Middle 07 08 2017   grade_7 129.0 0.0 4.0   0.0 1.0     1.0   4.0   57.0 82.0     0.0   0.0     31.0   19.0   139.0 129 0 4   0 1     1   4   57 82     0 0   31 19   139
866714 MN Stearns 73 school 2702930 745 Independent Districts and Schools ALBANY PUBLIC SCHOOL DISTRICT 270293000063 50 ALBANY JUNIOR HIGH Junior High School (Grades 7-8 or 7-9) Regular School No 2 07 08 2016   grade_7 130 0 4   0 1     1   4   62 78     2.0   0.0     33.0   14.0   140 130 0 4   0 1     1   4   62 78     2 0   33 14   140
1159102 MN Stearns 73 school 2702930 745 Independent Districts and Schools ALBANY PUBLIC SCHOOL DISTRICT 270293000063 50 ALBANY JUNIOR HIGH Junior High School (Grades 7-8 or 7-9) Regular School No 2 07 08 2015   grade_7 120.0 2.0 2.0   0.0 1.0     0.0   2.0   70.0 57.0     1.0   1.0     25.0   19.0   127.0 120 2 2   0 1     0   2   70 57     1 1   25 19   127
1953877 MN Stearns 73 school 2702930 745 Independent Districts and Schools ALBANY PUBLIC SCHOOL DISTRICT 270293000063 50 Albany Area Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_7 116.0 0.0 5.0   0.0 0.0     0.0   1.0   59.0 63.0     2.0   1.0     28.0   23.0   122.0 116 0 5   0 0     0   1   59 63     2 1   28 23   122
697920 MN Freeborn 24 school 2702970 241 Independent Districts and Schools ALBERT LEA PUBLIC SCHOOL DISTRICT 270297000078 320 SOUTHWEST MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 07 2017   grade_7 194.0 9.0 54.0   0.0 13.0     0.0   13.0   145.0 138.0         *         *   283.0 194 9 54   0 13     0   13   145 138                 283
699888 MN Freeborn 24 school 2702970 241 Independent Districts and Schools ALBERT LEA PUBLIC SCHOOL DISTRICT 270297002228 350 Albert Lea Area Learning Center Public Area Learning Center ALC (State approved) Alternative School No Other 06 12 2017   grade_7 5.0 0.0 3.0   0.0 1.0     0.0   0.0   5.0 4.0         *         *   9.0 5 0 3   0 1     0   0   5 4                 9
862100 MN Freeborn 24 school 2702970 241 Independent Districts and Schools ALBERT LEA PUBLIC SCHOOL DISTRICT 270297000078 320 SOUTHWEST MIDDLE Middle School (Grades 5-8) Regular School No 2 06 07 2016   grade_7 170 6 45   1 15     0   7   127 117         *         *   244 170 6 45   1 15     0   7   127 117                 244
864073 MN Freeborn 24 school 2702970 241 Independent Districts and Schools ALBERT LEA PUBLIC SCHOOL DISTRICT 270297002228 350 Albert Lea Area Learning Center Public Area Learning Center ALC (State approved) Alternative Education School No 4 06 12 2016   grade_7 2 0 2   0 0     0   0   4 0         *         *   4 2 0 2   0 0     0   0   4 0                 4
1154772 MN Freeborn 24 school 2702970 241 Independent Districts and Schools ALBERT LEA PUBLIC SCHOOL DISTRICT 270297000078 320 SOUTHWEST MIDDLE Middle School (Grades 5-8) Regular School No 2 06 07 2015   grade_7 167.0 7.0 57.0   0.0 10.0     0.0   6.0   126.0 121.0         *         *   247.0 167 7 57   0 10     0   6   126 121                 247
1156701 MN Freeborn 24 school 2702970 241 Independent Districts and Schools ALBERT LEA PUBLIC SCHOOL DISTRICT 270297002228 350 Albert Lea Area Learning Center Public Area Learning Center ALC (State approved) Alternative Education School No 4 06 12 2015   grade_7 2.0 2.0 6.0   0.0 0.0     0.0   0.0   6.0 4.0         *         *   10.0 2 2 6   0 0     0   0   6 4                 10
1953469 MN Freeborn 24 school 2702970 241 Independent Districts and Schools ALBERT LEA PUBLIC SCHOOL DISTRICT 270297000078 320 SOUTHWEST MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 07 2019   grade_7 163.0 4.0 50.0   0.0 12.0     0.0   6.0   127.0 108.0     *   *         *   235.0 163 4 50   0 12     0   6   127 108                 235
1955473 MN Freeborn 24 school 2702970 241 Independent Districts and Schools ALBERT LEA PUBLIC SCHOOL DISTRICT 270297002228 350 Albert Lea Area Learning Center Public Area Learning Center ALC (State approved) Alternative School No High 06 12 2019   grade_7 6.0 0.0 6.0   0.0 0.0     0.0   0.0   8.0 4.0     *   *         *   12.0 6 0 6   0 0     0   0   8 4                 12
689222 MN Freeborn 24 school 2703030 242 Independent Districts and Schools ALDEN-CONGER PUBLIC SCHOOL DISTRICT 270303000080 1 ALDEN-CONGER SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   grade_7 28.0 0.0 1.0   0.0 0.0     0.0   1.0   13.0 17.0     0.0   0.0     14.0   7.0   30.0 28 0 1   0 0     0   1   13 17     0 0   14 7   30
853633 MN Freeborn 24 school 2703030 242 Independent Districts and Schools ALDEN-CONGER PUBLIC SCHOOL DISTRICT 270303000080 1 ALDEN-CONGER SECONDARY Secondary School (Grades 7-12) Regular School No 3 07 12 2016   grade_7 50 0 3   0 0     0   0   26 27     0.0   0.0     16.0   10.0   53 50 0 3   0 0     0   0   26 27     0 0   16 10   53
1146316 MN Freeborn 24 school 2703030 242 Independent Districts and Schools ALDEN-CONGER PUBLIC SCHOOL DISTRICT 270303000080 1 ALDEN-CONGER SECONDARY Secondary School (Grades 7-12) Regular School No 3 07 12 2015   grade_7 30.0 0.0 1.0   0.0 0.0     0.0   3.0   22.0 12.0     0.0   0.0     14.0   5.0   34.0 30 0 1   0 0     0   3   22 12     0 0   14 5   34
1944580 MN Freeborn 24 school 2703030 242 Independent Districts and Schools ALDEN-CONGER PUBLIC SCHOOL DISTRICT 270303000080 1 ALDEN-CONGER SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_7 34.0 0.0 2.0   0.0 0.0     0.0   1.0   20.0 17.0     0.0   1.0     10.0   6.0   37.0 34 0 2   0 0     0   1   20 17     0 1   10 6   37
697912 MN Douglas 21 school 2703060 206 Independent Districts and Schools ALEXANDRIA PUBLIC SCHOOL DISTRICT 270306000083 310 Discovery Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_7 305.0 5.0 7.0   0.0 7.0     0.0   10.0   170.0 164.0     2.0   2.0     108.0   50.0   334.0 305 5 7   0 7     0   10   170 164     2 2   108 50   334
862092 MN Douglas 21 school 2703060 206 Independent Districts and Schools ALEXANDRIA PUBLIC SCHOOL DISTRICT 270306000083 310 Discovery Middle School Middle School (Grades 5-8) Regular School No 2 06 08 2016   grade_7 289 1 7   3 9     0   5   171 143     1.0   3.0     82.0   44.0   314 289 1 7   3 9     0   5   171 143     1 3   82 44   314
1154764 MN Douglas 21 school 2703060 206 Independent Districts and Schools ALEXANDRIA PUBLIC SCHOOL DISTRICT 270306000083 310 Discovery Middle School Middle School (Grades 5-8) Regular School No 2 06 08 2015   grade_7 267.0 0.0 10.0   1.0 2.0     0.0   5.0   144.0 141.0     1.0   1.0     74.0   36.0   285.0 267 0 10   1 2     0   5   144 141     1 1   74 36   285
1953461 MN Douglas 21 school 2703060 206 Independent Districts and Schools ALEXANDRIA PUBLIC SCHOOL DISTRICT 270306000083 310 Discovery Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_7 299.0 4.0 15.0   0.0 2.0     0.0   5.0   183.0 142.0     4.0   2.0     91.0   40.0   325.0 299 4 15   0 2     0   5   183 142     4 2   91 40   325
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
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
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
1953940 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 2019   grade_7 167.0 3.0 5.0   0.0 0.0     0.0   8.0   84.0 99.0     0.0   0.0     52.0   24.0   183.0 167 3 5   0 0     0   8   84 99     0 0   52 24   183
690409 MN Rice 66 school 2700355 4091 Charter Schools ARCADIA CHARTER SCHOOL 270035504151 10 ARCADIA CHARTER SCHOOL Secondary School (Grades 7-12) Regular School Yes Other 06 12 2017   grade_7 15.0 0.0 2.0   0.0 0.0     0.0   0.0   10.0 7.0     0.0   0.0     1.0   7.0   17.0 15 0 2   0 0     0   0   10 7     0 0   1 7   17
854824 MN Rice 66 school 2700355 4091 Charter Schools ARCADIA CHARTER SCHOOL 270035504151 10 ARCADIA CHARTER SCHOOL Secondary School (Grades 7-12) Regular School Yes 4 06 12 2016   grade_7 12 0 0   0 0     0   0   8 4     0.0   0.0     2.0   9.0   12 12 0 0   0 0     0   0   8 4     0 0   2 9   12
1147519 MN Rice 66 school 2700355 4091 Charter Schools ARCADIA CHARTER SCHOOL 270035504151 10 ARCADIA CHARTER SCHOOL Secondary School (Grades 7-12) Regular School Yes 4 06 12 2015   grade_7 20.0 1.0 0.0   0.0 1.0     0.0   0.0   14.0 8.0     0.0   0.0     3.0   5.0   22.0 20 1 0   0 1     0   0   14 8     0 0   3 5   22
1945767 MN Rice 66 school 2700355 4091 Charter Schools ARCADIA CHARTER SCHOOL 270035504151 10 ARCADIA CHARTER SCHOOL Secondary School (Grades 7-12) Regular School Yes High 06 12 2019   grade_7 15.0 0.0 1.0   1.0 0.0     0.0   1.0   9.0 9.0     0.0   0.0     2.0   5.0   18.0 15 0 1   1 0     0   1   9 9     0 0   2 5   18
689250 MN Grant 26 school 2703300 261 Independent Districts and Schools ASHBY PUBLIC SCHOOL DISTRICT 270330000137 20 ASHBY SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   grade_7 27.0 0.0 0.0   0.0 0.0     0.0   0.0   19.0 8.0     0.0   0.0     10.0   2.0   27.0 27 0 0   0 0     0   0   19 8     0 0   10 2   27
853661 MN Grant 26 school 2703300 261 Independent Districts and Schools ASHBY PUBLIC SCHOOL DISTRICT 270330000137 20 ASHBY SECONDARY Secondary School (Grades 7-12) Regular School No 3 07 12 2016   grade_7 27 0 0   0 0     0   0   14 13     0.0   0.0     12.0   3.0   27 27 0 0   0 0     0   0   14 13     0 0   12 3   27
1146344 MN Grant 26 school 2703300 261 Independent Districts and Schools ASHBY PUBLIC SCHOOL DISTRICT 270330000137 20 ASHBY SECONDARY Secondary School (Grades 7-12) Regular School No 3 07 12 2015   grade_7 16.0 1.0 0.0   0.0 0.0     0.0   1.0   7.0 11.0     0.0   0.0     7.0   3.0   18.0 16 1 0   0 0     0   1   7 11     0 0   7 3   18
1944608 MN Grant 26 school 2703300 261 Independent Districts and Schools ASHBY PUBLIC SCHOOL DISTRICT 270330000137 20 ASHBY SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_7 19.0 0.0 2.0   0.0 0.0     0.0   0.0   11.0 10.0     1.0   1.0     9.0   4.0   21.0 19 0 2   0 0     0   0   11 10     1 1   9 4   21
697258 MN Scott 70 school 2700311 4184 Charter Schools ASPEN ACADEMY 270031104282 10 ASPEN ACADEMY Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2017   grade_7 21.0 2.0 1.0   0.0 2.0     0.0   0.0   4.0 22.0     1.0   0.0     5.0   4.0   26.0 21 2 1   0 2     0   0   4 22     1 0   5 4   26
861514 MN Scott 70 school 2700311 4184 Charter Schools ASPEN ACADEMY 270031104282 10 ASPEN ACADEMY Elementary School (Grades PK-6) Regular School Yes 1 KG 08 2016   grade_7 21 1 0   0 1     0   0   10 13     3.0   0.0     5.0   4.0   23 21 1 0   0 1     0   0   10 13     3 0   5 4   23
1154228 MN Scott 70 school 2700311 4184 Charter Schools ASPEN ACADEMY 270031104282 10 ASPEN ACADEMY Elementary School (Grades PK-6) Regular School Yes 1 KG 08 2015   grade_7 46.0 4.0 1.0   0.0 1.0     0.0   1.0   26.0 27.0     8.0   0.0     13.0   2.0   53.0 46 4 1   0 1     0   1   26 27     8 0   13 2   53
1952729 MN Scott 70 school 2700311 4184 Charter Schools ASPEN ACADEMY 270031104282 10 ASPEN ACADEMY Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2019   grade_7 17.0 3.0 0.0   0.0 2.0     0.0   1.0   11.0 12.0     1.0   0.0     7.0   5.0   23.0 17 3 0   0 2     0   1   11 12     1 0   7 5   23
698540 MN Hennepin 27 school 2700220 4067 Charter Schools AURORA CHARTER SCHOOL 270022004420 20 AURORA MIDDLE SCHOOL Middle School (Grades 5-8) Regular School Yes Middle 05 08 2017   grade_7 0.0 0.0 46.0   0.0 0.0     0.0   0.0   17.0 29.0     25.0   0.0         3.0   46.0 0 0 46   0 0     0   0   17 29     25 0     3   46
862718 MN Hennepin 27 school 2700220 4067 Charter Schools AURORA CHARTER SCHOOL 270022004420 20 AURORA MIDDLE SCHOOL Middle School (Grades 5-8) Regular School Yes 2 05 08 2016   grade_7 0 0 42   0 0     0   1   24 19     21.0   0.0     38.0   5.0   43 0 0 42   0 0     0   1   24 19     21 0   38 5   43
1155359 MN Hennepin 27 school 2700220 4067 Charter Schools AURORA CHARTER SCHOOL 270022004420 20 AURORA MIDDLE SCHOOL Middle School (Grades 5-8) Regular School Yes 2 05 08 2015   grade_7 0.0 0.0 45.0   0.0 0.0     0.0   0.0   20.0 25.0     18.0   0.0         1.0   45.0 0 0 45   0 0     0   0   20 25     18 0     1   45
1954121 MN Hennepin 27 school 2700220 4067 Charter Schools AURORA CHARTER SCHOOL 270022004420 20 AURORA MIDDLE SCHOOL Middle School (Grades 5-8) Regular School Yes Middle 05 08 2019   grade_7 0.0 0.0 45.0   1.0 0.0     0.0   0.0   18.0 28.0     24.0   0.0         9.0   46.0 0 0 45   1 0     0   0   18 28     24 0     9   46
698089 MN Mower 50 school 2703450 492 Independent Districts and Schools AUSTIN PUBLIC SCHOOL DISTRICT 270345000150 300 ELLIS MIDDLE Middle School (Grades 5-8) Regular School No Middle 07 08 2017   grade_7 192.0 25.0 87.0   0.0 20.0     1.0   12.0   170.0 167.0     26.0   5.0     184.0   *   337.0 192 25 87   0 20     1   12   170 167     26 5   184     337
700020 MN Mower 50 school 2703450 492 Independent Districts and Schools AUSTIN PUBLIC SCHOOL DISTRICT 270345002231 150 AUSTIN AREA LEARNING CENTER Public Area Learning Center ALC (State approved) Alternative School No Other 06 12 2017   grade_7 3.0 2.0 10.0   0.0 2.0     1.0   1.0   12.0 7.0     2.0   0.0     15.0   0.0   19.0 3 2 10   0 2     1   1   12 7     2 0   15 0   19
702618 MN Mower 50 school 2703450 492 Independent Districts and Schools AUSTIN PUBLIC SCHOOL DISTRICT 270345003192 450 NEW DOMINION ACADEMY Educational Oversight to Private Residential Care & Treatment (State approved) Alternative School No Other KG 12 2017   grade_7 8.0 2.0 0.0   0.0 0.0     0.0   2.0   6.0 6.0     0.0   0.0     0.0   *   12.0 8 2 0   0 0     0   2   6 6     0 0   0     12
862270 MN Mower 50 school 2703450 492 Independent Districts and Schools AUSTIN PUBLIC SCHOOL DISTRICT 270345000150 300 ELLIS MIDDLE Middle School (Grades 5-8) Regular School No 2 06 08 2016   grade_7 204 16 80   0 24     2   11   174 163         *     191.0   58.0   337 204 16 80   0 24     2   11   174 163           191 58   337
864207 MN Mower 50 school 2703450 492 Independent Districts and Schools AUSTIN PUBLIC SCHOOL DISTRICT 270345002231 150 AUSTIN AREA LEARNING CENTER Public Area Learning Center ALC (State approved) Alternative Education School No 4 06 12 2016   grade_7 6 1 9   0 0     1   1   10 8     7.0   0.0         0.0   18 6 1 9   0 0     1   1   10 8     7 0     0   18
864874 MN Mower 50 school 2703450 492 Independent Districts and Schools AUSTIN PUBLIC SCHOOL DISTRICT 270345002659 160 HORIZON PROGRAM Special Education Special Education School No 4 KG 12 2016   grade_7 1 0 2   0 0     0   0   3 0         *         *   3 1 0 2   0 0     0   0   3 0                 3
866765 MN Mower 50 school 2703450 492 Independent Districts and Schools AUSTIN PUBLIC SCHOOL DISTRICT 270345003192 450 NEW DOMINION ACADEMY Educational Oversight to Private Residential Care & Treatment (State approved) Alternative Education School No 4 KG 12 2016   grade_7 7 8 2   1 0     0   1   13 6     0.0   0.0     0.0   15.0   19 7 8 2   1 0     0   1   13 6     0 0   0 15   19
1154926 MN Mower 50 school 2703450 492 Independent Districts and Schools AUSTIN PUBLIC SCHOOL DISTRICT 270345000150 300 ELLIS MIDDLE Middle School (Grades 5-8) Regular School No 2 05 08 2015   grade_7 208.0 28.0 85.0   0.0 18.0     1.0   14.0   187.0 167.0     50.0   0.0     205.0   *   354.0 208 28 85   0 18     1   14   187 167     50 0   205     354
1156837 MN Mower 50 school 2703450 492 Independent Districts and Schools AUSTIN PUBLIC SCHOOL DISTRICT 270345002231 150 AUSTIN AREA LEARNING CENTER Public Area Learning Center ALC (State approved) Alternative Education School No 4 06 12 2015   grade_7 6.0 2.0 3.0   0.0 0.0     0.0   0.0   5.0 6.0         *         0.0   11.0 6 2 3   0 0     0   0   5 6             0   11
1157451 MN Mower 50 school 2703450 492 Independent Districts and Schools AUSTIN PUBLIC SCHOOL DISTRICT 270345002659 160 HORIZON PROGRAM Special Education Special Education School No 4 KG 12 2015   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
1159318 MN Mower 50 school 2703450 492 Independent Districts and Schools AUSTIN PUBLIC SCHOOL DISTRICT 270345003192 450 NEW DOMINION ACADEMY Educational Oversight to Private Residential Care & Treatment (State approved) Alternative Education School No 4 KG 12 2015   grade_7 3.0 2.0 0.0   2.0 0.0     0.0   4.0   8.0 3.0     0.0   0.0     0.0   *   11.0 3 2 0   2 0     0   4   8 3     0 0   0     11
1953652 MN Mower 50 school 2703450 492 Independent Districts and Schools AUSTIN PUBLIC SCHOOL DISTRICT 270345000150 300 ELLIS MIDDLE Middle School (Grades 5-8) Regular School No Middle 07 08 2019   grade_7 179.0 29.0 118.0   0.0 18.0     3.0   15.0   183.0 179.0     41.0   0.0     213.0   *   362.0 179 29 118   0 18     3   15   183 179     41 0   213     362
1955594 MN Mower 50 school 2703450 492 Independent Districts and Schools AUSTIN PUBLIC SCHOOL DISTRICT 270345002231 150 AUSTIN AREA LEARNING CENTER Public Area Learning Center ALC (State approved) Alternative School No High 06 12 2019   grade_7 8.0 2.0 10.0   0.0 2.0     0.0   0.0   10.0 12.0     9.0   0.0     15.0   0.0   22.0 8 2 10   0 2     0   0   10 12     9 0   15 0   22
1958133 MN Mower 50 school 2703450 492 Independent Districts and Schools AUSTIN PUBLIC SCHOOL DISTRICT 270345003192 450 NEW DOMINION ACADEMY Educational Oversight to Private Residential Care & Treatment (State approved) Alternative School No Other KG 12 2019   grade_7 3.0 3.0 1.0   2.0 0.0     0.0   2.0   6.0 5.0     0.0   0.0     0.0   *   11.0 3 3 1   2 0     0   2   6 5     0 0   0     11
698548 MN Ramsey 62 school 2700187 4075 Charter Schools AVALON SCHOOL 270018704664 20 Avalon Middle School Middle School (Grades 5-8) Regular School Yes Middle 06 08 2017   grade_7 18.0 3.0 0.0   1.0 0.0     0.0   0.0   14.0 8.0     0.0   0.0     7.0   7.0   22.0 18 3 0   1 0     0   0   14 8     0 0   7 7   22
862726 MN Ramsey 62 school 2700187 4075 Charter Schools AVALON SCHOOL 270018704664 20 Avalon Middle School Middle School (Grades 5-8) Regular School Yes 2 06 08 2016   grade_7 15 0 3   2 0     0   1   12 9     0.0   0.0     6.0   6.0   21 15 0 3   2 0     0   1   12 9     0 0   6 6   21
1155367 MN Ramsey 62 school 2700187 4075 Charter Schools AVALON SCHOOL 270018704664 20 Avalon Middle School Middle School (Grades 5-8) Regular School Yes 2 06 08 2015   grade_7 19.0 1.0 1.0   0.0 3.0     0.0   0.0   17.0 7.0     0.0   1.0     6.0   8.0   24.0 19 1 1   0 3     0   0   17 7     0 1   6 8   24
1954128 MN Ramsey 62 school 2700187 4075 Charter Schools AVALON SCHOOL 270018704664 20 Avalon Middle School Middle School (Grades 5-8) Regular School Yes Middle 06 08 2019   grade_7 14.0 1.0 4.0   1.0 0.0     0.0   7.0   17.0 10.0     1.0   1.0     9.0   8.0   27.0 14 1 4   1 0     0   7   17 10     1 1   9 8   27
1719673 MN Ramsey 62 school 2700185 4073 Charter Schools Academia Cesar Chavez Charter School 270018503138 10 Academia Cesar Chavez Charter School Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2021   grade_7 1 1 50   0 0     0   0   27 25     22.0   0.0     18.0   7.0   52 1 1 50   0 0     0   0   27 25     22 0   18 7   52
1833228 MN Ramsey 62 school 2700185 4073 Charter Schools Academia Cesar Chavez Charter School 270018503138 10 Academia Cesar Chavez Charter School Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2020   grade_7 2.0 0.0 50.0   0.0 0.0     0.0   0.0   25.0 27.0     21.0   0.0     37.0   8.0   52.0 2 0 50   0 0     0   0   25 27     21 0   37 8   52
1887787 MN Ramsey 62 school 2700185 4073 Charter Schools Academia Cesar Chavez Charter School 270018503138 10 Academia Cesar Chavez Charter School Elementary School (Grades PK-6) Regular School Yes Elementary PK 07 2018   grade_7 4.0 0.0 52.0   0.0 1.0     0.0   1.0   26.0 32.0     28.0   2.0     *   11.0   58.0 4 0 52   0 1     0   1   26 32     28 2     11   58
1952359 MN Ramsey 62 school 2700185 4073 Charter Schools Academia Cesar Chavez Charter School 270018503138 10 Academia Cesar Chavez Charter School Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2019   grade_7 0.0 0.0 33.0   0.0 0.0     0.0   2.0   18.0 17.0     *   4.0         8.0   35.0 0 0 33   0 0     0   2   18 17       4     8   35
1719517 MN Ramsey 62 school 2700118 4018 Charter Schools Achieve Language Academy 270011802608 10 Achieve Language Academy Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2021   grade_7 6 4 20   0 15     0   1   25 21     *   0.0     21.0   4.0   46 6 4 20   0 15     0   1   25 21       0   21 4   46
1833067 MN Ramsey 62 school 2700118 4018 Charter Schools Achieve Language Academy 270011802608 10 Achieve Language Academy Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2020   grade_7 5.0 8.0 19.0   0.0 16.0     0.0   1.0   26.0 23.0     13.0   0.0     43.0   5.0   49.0 5 8 19   0 16     0   1   26 23     13 0   43 5   49
1887622 MN Ramsey 62 school 2700118 4018 Charter Schools Achieve Language Academy 270011802608 10 Achieve Language Academy Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2018   grade_7 3.0 5.0 14.0   1.0 22.0     0.0   1.0   25.0 21.0     22.0   2.0     22.0   6.0   46.0 3 5 14   1 22     0   1   25 21     22 2   22 6   46
1712857 MN Norman 54 school 2700126 2854 Independent Districts and Schools Ada-Borup Public School District 270012600051 30 Ada-Borup Secondary Secondary School (Grades 7-12) Regular School No High 06 12 2021   grade_7 47 0 8   2 0     0   7   29 35     1.0   0.0     25.0   11.0   64 47 0 8   2 0     0   7   29 35     1 0   25 11   64
1826433 MN Norman 54 school 2700126 2854 Independent Districts and Schools Ada-Borup Public School District 270012600051 30 Ada-Borup Secondary Secondary School (Grades 7-12) Regular School No High 06 12 2020   grade_7 46.0 0.0 6.0   0.0 1.0     0.0   6.0   27.0 32.0     2.0   0.0     24.0   7.0   59.0 46 0 6   0 1     0   6   27 32     2 0   24 7   59
1881036 MN Norman 54 school 2700126 2854 Independent Districts and Schools Ada-Borup Public School District 270012600051 30 Ada-Borup Secondary Secondary School (Grades 7-12) Regular School No High 06 12 2018   grade_7 37.0 1.0 1.0   1.0 0.0     0.0   3.0   20.0 23.0     0.0   0.0     19.0   8.0   43.0 37 1 1   1 0     0   3   20 23     0 0   19 8   43
1721088 MN Nobles 53 school 2702730 511 Independent Districts and Schools Adrian Public School District 270273003076 15 Adrian Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 29 0 4   0 0     0   3   23 13     2.0   0.0     9.0   4.0   36 29 0 4   0 0     0   3   23 13     2 0   9 4   36

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