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,674
Link rowid state county county_state_id admin_level district_nces_id district_state_id district_state_type district ▼ school_nces_id school_state_id school school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ccd_school_high_grade year term grade white black hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
1834603 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 2020   grade_7 29.0 1.0 6.0   0.0 2.0     0.0   2.0   19.0 21.0     2.0   0.0     23.0   8.0   40.0 29 1 6   0 2     0   2   19 21     2 0   23 8   40
1889079 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 2018   grade_7 50.0 1.0 5.0   0.0 1.0     0.0   0.0   29.0 28.0     1.0   0.0     25.0   10.0   57.0 50 1 5   0 1     0   0   29 28     1 0   25 10   57
1720251 MN Hennepin 27 school 2700394 4220 Charter Schools Agamim Classical Academy 270039404751 10 Agamim Classical Academy Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2021   grade_7 8 8 2   0 1     0   2   12 9     7.0   0.0     5.0   2.0   21 8 8 2   0 1     0   2   12 9     7 0   5 2   21
1833804 MN Hennepin 27 school 2700394 4220 Charter Schools Agamim Classical Academy 270039404751 10 Agamim Classical Academy Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2020   grade_7 18.0 8.0 5.0   0.0 3.0     0.0   2.0   18.0 18.0     5.0   0.0     11.0   6.0   36.0 18 8 5   0 3     0   2   18 18     5 0   11 6   36
1952918 MN Hennepin 27 school 2700394 4220 Charter Schools Agamim Classical Academy 270039404751 10 Agamim Classical Academy Elementary School (Grades PK-6) Regular School Yes Elementary KG 07 2019   grade_7 7.0 8.0 1.0   0.0 0.0     0.0   0.0   7.0 9.0     2.0   0.0     8.0   4.0   16.0 7 8 1   0 0     0   0   7 9     2 0   8 4   16
1711653 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 2021   grade_7 85 1 1   1 2     0   3   42 51     1.0   0.0     29.0   16.0   93 85 1 1   1 2     0   3   42 51     1 0   29 16   93
1825222 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 2020   grade_7 92.0 1.0 3.0   0.0 0.0     0.0   2.0   53.0 45.0     0.0   1.0     43.0   13.0   98.0 92 1 3   0 0     0   2   53 45     0 1   43 13   98
1879819 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 2018   grade_7 93.0 1.0 2.0   0.0 0.0     0.0   4.0   58.0 42.0     1.0   0.0     43.0   17.0   100.0 93 1 2   0 0     0   4   58 42     1 0   43 17   100
1721303 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 2021   grade_7 135 2 9   0 0     0   5   71 80     5.0   1.0     25.0   32.0   151 135 2 9   0 0     0   5   71 80     5 1   25 32   151
1834818 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 2020   grade_7 151.0 0.0 5.0   0.0 0.0     0.0   2.0   80.0 78.0     0.0   0.0     21.0   26.0   158.0 151 0 5   0 0     0   2   80 78     0 0   21 26   158
1889272 MN Stearns 73 school 2702930 745 Independent Districts and Schools Albany Public School District 270293000063 50 Albany Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2018   grade_7 127.0 0.0 6.0   0.0 0.0     0.0   2.0   57.0 78.0     2.0   0.0     32.0   18.0   135.0 127 0 6   0 0     0   2   57 78     2 0   32 18   135
1720879 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 2021   grade_7 165 7 72   0 21     0   8   149 124     *   *     *   *   273 165 7 72   0 21     0   8   149 124                 273
1722931 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 2021   grade_7 4 0 1   0 0     0   3   3 5     *   *     *   *   8 4 0 1   0 0     0   3   3 5                 8
1834393 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 2020   grade_7 162.0 10.0 58.0   1.0 23.0     0.0   12.0   129.0 137.0     *   *         *   266.0 162 10 58   1 23     0   12   129 137                 266
1836425 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 2020   grade_7 4.0 0.0 1.0   0.0 0.0     0.0   0.0   3.0 2.0     *   *         *   5.0 4 0 1   0 0     0   0   3 2                 5
1888873 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 2018   grade_7 163.0 5.0 59.0   3.0 14.0     0.0   8.0   132.0 120.0     14.0   1.0     123.0   37.0   252.0 163 5 59   3 14     0   8   132 120     14 1   123 37   252
1890846 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 2018   grade_7 6.0 1.0 3.0   0.0 0.0     0.0   1.0   5.0 6.0     0.0   0.0     9.0   0.0   11.0 6 1 3   0 0     0   1   5 6     0 0   9 0   11
1711865 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 2021   grade_7 34 0 0   0 0     0   0   15 19     0.0   0.0     12.0   7.0   34 34 0 0   0 0     0   0   15 19     0 0   12 7   34
1825434 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 2020   grade_7 34.0 0.0 1.0   0.0 0.0     0.0   2.0   21.0 16.0     1.0   0.0     9.0   7.0   37.0 34 0 1   0 0     0   2   21 16     1 0   9 7   37
1880031 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 2018   grade_7 37.0 0.0 3.0   0.0 0.0     0.0   1.0   15.0 26.0     0.0   0.0     11.0   6.0   41.0 37 0 3   0 0     0   1   15 26     0 0   11 6   41
1720871 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 2021   grade_7 323 2 15   0 1     0   7   183 165     1.0   2.0     80.0   49.0   348 323 2 15   0 1     0   7   183 165     1 2   80 49   348
1834385 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 2020   grade_7 317.0 2.0 8.0   0.0 1.0     0.0   17.0   172.0 173.0     0.0   0.0     88.0   38.0   345.0 317 2 8   0 1     0   17   172 173     0 0   88 38   345
1888865 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 2018   grade_7 306.0 2.0 11.0   1.0 6.0     0.0   10.0   166.0 170.0     1.0   2.0     92.0   47.0   336.0 306 2 11   1 6     0   10   166 170     1 2   92 47   336
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
1834882 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 2020   grade_7 152.0 0.0 2.0   0.0 1.0     0.0   6.0   84.0 77.0     0.0   2.0     37.0   32.0   161.0 152 0 2   0 1     0   6   84 77     0 2   37 32   161
1889335 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 2018   grade_7 132.0 1.0 5.0   0.0 0.0     0.0   4.0   71.0 71.0     2.0   0.0     31.0   23.0   142.0 132 1 5   0 0     0   4   71 71     2 0   31 23   142
697685 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000117 3 ANOKA MIDDLE SCHOOL FOR THE ARTS Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_7 480.0 58.0 39.0   9.0 35.0     0.0   16.0   320.0 317.0     21.0   8.0     218.0   106.0   637.0 480 58 39   9 35     0   16   320 317     21 8   218 106   637
697689 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000099 4 COON RAPIDS MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_7 254.0 54.0 36.0   5.0 20.0     0.0   16.0   174.0 211.0     20.0   4.0     179.0   48.0   385.0 254 54 36   5 20     0   16   174 211     20 4   179 48   385
697693 MN Hennepin 27 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000108 6 JACKSON MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_7 379.0 122.0 59.0   2.0 105.0     0.0   56.0   382.0 341.0     41.0   8.0     271.0   76.0   723.0 379 122 59   2 105     0   56   382 341     41 8   271 76   723
697697 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000119 90 NORTHDALE MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_7 258.0 46.0 43.0   7.0 31.0     0.0   25.0   224.0 186.0     25.0   7.0     186.0   69.0   410.0 258 46 43   7 31     0   25   224 186     25 7   186 69   410
697701 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318002501 193 OAK VIEW MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_7 376.0 14.0 11.0   5.0 13.0     1.0   5.0   228.0 197.0         *         48.0   425.0 376 14 11   5 13     1   5   228 197             48   425
697705 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000122 195 Roosevelt Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_7 324.0 35.0 21.0   0.0 32.0     0.0   28.0   223.0 217.0     12.0   8.0     113.0   52.0   440.0 324 35 21   0 32     0   28   223 217     12 8   113 52   440
700449 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000005 467 RIVER TRAIL LEARNING CTR @ LO JACOB Special Education Special Education School No Other KG 12 2017   grade_7 8.0 1.0 0.0   0.0 0.0     0.0   0.0   6.0 3.0         *         *   9.0 8 1 0   0 0     0   0   6 3                 9
861884 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000117 3 ANOKA MIDDLE SCHOOL FOR THE ARTS Middle School (Grades 5-8) Regular School No 2 06 08 2016   grade_7 490 50 16   7 23     0   19   281 324     15.0   4.0     215.0   100.0   605 490 50 16   7 23     0   19   281 324     15 4   215 100   605
861888 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000099 4 COON RAPIDS MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No 2 06 08 2016   grade_7 258 72 27   2 31     0   16   206 200     29.0   6.0     205.0   54.0   406 258 72 27   2 31     0   16   206 200     29 6   205 54   406
861892 MN Hennepin 27 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000108 6 JACKSON MIDDLE Middle School (Grades 5-8) Regular School No 2 06 08 2016   grade_7 391 105 44   5 84     0   35   322 342     42.0   6.0     240.0   89.0   664 391 105 44   5 84     0   35   322 342     42 6   240 89   664
861896 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000119 90 NORTHDALE MIDDLE Middle School (Grades 5-8) Regular School No 2 06 08 2016   grade_7 246 39 29   5 36     0   16   187 184     9.0   9.0     153.0   65.0   371 246 39 29   5 36     0   16   187 184     9 9   153 65   371
861900 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318002501 193 OAK VIEW MIDDLE Middle School (Grades 5-8) Regular School No 2 06 08 2016   grade_7 357 9 18   3 15     0   8   210 200         *     62.0   *   410 357 9 18   3 15     0   8   210 200           62     410
861904 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000122 195 Roosevelt Middle Middle School (Grades 5-8) Regular School No 2 06 08 2016   grade_7 306 22 17   2 21     1   11   193 187     6.0   2.0     78.0   45.0   380 306 22 17   2 21     1   11   193 187     6 2   78 45   380
863923 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318002974 812 COMPASS-BELL CENTER Public Area Learning Center ALC (State approved) Alternative Education School No 4 06 12 2016   grade_7 2 0 0   0 0     0   0   2 0         *         *   2 2 0 0   0 0     0   0   2 0                 2
864671 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000005 467 RIVER TRAIL LEARNING CTR @ LO JACOB Special Education Special Education School No 4 KG 12 2016   grade_7 11 1 2   1 0     0   3   15 3     0.0   2.0         *   18 11 1 2   1 0     0   3   15 3     0 2         18
1154562 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000117 3 ANOKA MIDDLE SCHOOL FOR THE ARTS Middle School (Grades 5-8) Regular School No 2 06 08 2015   grade_7 491.0 45.0 23.0   9.0 23.0     0.0   9.0   267.0 333.0     14.0   7.0     209.0   95.0   600.0 491 45 23   9 23     0   9   267 333     14 7   209 95   600
1154566 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000099 4 COON RAPIDS MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No 2 06 08 2015   grade_7 270.0 51.0 27.0   7.0 19.0     0.0   9.0   197.0 186.0     18.0   8.0     183.0   53.0   383.0 270 51 27   7 19     0   9   197 186     18 8   183 53   383
1154570 MN Hennepin 27 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000108 6 JACKSON MIDDLE Middle School (Grades 5-8) Regular School No 2 06 08 2015   grade_7 392.0 108.0 32.0   7.0 89.0     0.0   11.0   316.0 323.0     46.0   4.0     221.0   91.0   639.0 392 108 32   7 89     0   11   316 323     46 4   221 91   639
1154574 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000119 90 NORTHDALE MIDDLE Middle School (Grades 5-8) Regular School No 2 06 08 2015   grade_7 279.0 52.0 21.0   9.0 29.0     0.0   11.0   198.0 203.0     18.0   9.0     173.0   49.0   401.0 279 52 21   9 29     0   11   198 203     18 9   173 49   401
1154578 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318002501 193 OAK VIEW MIDDLE Middle School (Grades 5-8) Regular School No 2 06 08 2015   grade_7 381.0 13.0 12.0   4.0 13.0     0.0   4.0   237.0 190.0     2.0   1.0     67.0   *   427.0 381 13 12   4 13     0   4   237 190     2 1   67     427
1154582 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000122 195 Roosevelt Middle Middle School (Grades 5-8) Regular School No 2 06 08 2015   grade_7 306.0 25.0 8.0   1.0 26.0     1.0   7.0   188.0 186.0     8.0   2.0     86.0   *   374.0 306 25 8   1 26     1   7   188 186     8 2   86     374
1156559 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318002974 812 COMPASS-BELL CENTER Public Area Learning Center ALC (State approved) Alternative Education School No 4 06 12 2015   grade_7 0.0 1.0 0.0   0.0 0.0     0.0   0.0   1.0 0.0         *         *   1.0 0 1 0   0 0     0   0   1 0                 1
1157257 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000005 467 RIVER TRAIL LEARNING CTR @ LO JACOB Special Education Special Education School No 4 KG 12 2015   grade_7 4.0 0.0 0.0   0.0 0.0     0.0   0.0   3.0 1.0         *         *   4.0 4 0 0   0 0     0   0   3 1                 4
1720648 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000117 3 Anoka Middle School For The Arts Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 398 77 48   1 32     0   43   307 292     26.0   3.0     185.0   87.0   599 398 77 48   1 32     0   43   307 292     26 3   185 87   599
1720652 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000099 4 Coon Rapids Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 281 106 40   6 37     1   58   258 271     35.0   19.0     248.0   91.0   529 281 106 40   6 37     1   58   258 271     35 19   248 91   529
1720656 MN Hennepin 27 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000108 6 Jackson Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 334 131 52   3 83     0   62   334 331     46.0   4.0     219.0   86.0   665 334 131 52   3 83     0   62   334 331     46 4   219 86   665
1720660 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000119 90 Northdale Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 249 56 30   2 41     2   35   216 199     24.0   7.0     118.0   46.0   415 249 56 30   2 41     2   35   216 199     24 7   118 46   415
1720664 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318002501 193 Oak View Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 331 17 13   3 16     0   24   226 178     9.0   4.0     65.0   *   404 331 17 13   3 16     0   24   226 178     9 4   65     404
1720668 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000122 195 Roosevelt Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 186 27 8   1 24     0   25   137 134     *   3.0     64.0   *   271 186 27 8   1 24     0   25   137 134       3   64     271
1722801 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318002974 812 Compass-Bell Center Public Area Learning Center ALC (State approved) Alternative School No High 06 12 2021   grade_7 0 0 0   0 0     0   1   0 1     *   *     *   *   1 0 0 0   0 0     0   1   0 1                 1
1723409 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000005 467 River Trail Learning Center at LO Jacob Special Education Special Education School No Other KG 12 2021   grade_7 16 1 0   0 0     0   4   18 3     0.0   *     *   *   21 16 1 0   0 0     0   4   18 3     0           21
1834154 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000117 3 Anoka Middle School For The Arts Middle School (Grades 5-8) Regular School No Middle 06 08 2020   grade_7 402.0 77.0 33.0   3.0 23.0     1.0   51.0   285.0 305.0     16.0   10.0     211.0   104.0   590.0 402 77 33   3 23     1   51   285 305     16 10   211 104   590
1834158 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000099 4 Coon Rapids Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2020   grade_7 271.0 105.0 49.0   3.0 38.0     2.0   52.0   271.0 249.0     37.0   24.0     286.0   91.0   520.0 271 105 49   3 38     2   52   271 249     37 24   286 91   520
1834162 MN Hennepin 27 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000108 6 Jackson Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2020   grade_7 331.0 140.0 71.0   9.0 101.0     0.0   47.0   362.0 337.0     61.0   11.0     262.0   92.0   699.0 331 140 71   9 101     0   47   362 337     61 11   262 92   699
1834166 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000119 90 Northdale Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2020   grade_7 277.0 48.0 43.0   2.0 42.0     0.0   39.0   252.0 199.0     29.0   4.0     167.0   85.0   451.0 277 48 43   2 42     0   39   252 199     29 4   167 85   451
1834170 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318002501 193 Oak View Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2020   grade_7 364.0 23.0 18.0   1.0 13.0     0.0   25.0   233.0 211.0     8.0   0.0     69.0   *   444.0 364 23 18   1 13     0   25   233 211     8 0   69     444
1834174 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000122 195 Roosevelt Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2020   grade_7 230.0 21.0 18.0   0.0 21.0     0.0   22.0   174.0 138.0     6.0   5.0     63.0   43.0   312.0 230 21 18   0 21     0   22   174 138     6 5   63 43   312
1836285 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318002974 812 Compass-Bell Center Public Area Learning Center ALC (State approved) Alternative School No High 06 12 2020   grade_7 0.0 1.0 1.0   0.0 0.0     0.0   0.0   1.0 1.0     *   *         *   2.0 0 1 1   0 0     0   0   1 1                 2
1836929 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000005 467 River Trail Learning Ctr @ LO Jacob Special Education Special Education School No Other KG 12 2020   grade_7 5.0 1.0 1.0   0.0 0.0     0.0   0.0   6.0 1.0     *   *         *   7.0 5 1 1   0 0     0   0   6 1                 7
1888635 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000117 3 Anoka Middle School for the Arts Middle School (Grades 5-8) Regular School No Middle 06 08 2018   grade_7 459.0 55.0 29.0   7.0 22.0     1.0   24.0   270.0 327.0     20.0   9.0     200.0   66.0   597.0 459 55 29   7 22     1   24   270 327     20 9   200 66   597
1888639 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000099 4 Coon Rapids Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2018   grade_7 228.0 63.0 41.0   5.0 29.0     0.0   26.0   205.0 187.0     21.0   6.0     202.0   54.0   392.0 228 63 41   5 29     0   26   205 187     21 6   202 54   392
1888643 MN Hennepin 27 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000108 6 Jackson Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2018   grade_7 413.0 113.0 52.0   5.0 94.0     0.0   40.0   337.0 380.0     33.0   9.0     237.0   88.0   717.0 413 113 52   5 94     0   40   337 380     33 9   237 88   717
1888647 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000119 90 Northdale Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2018   grade_7 221.0 62.0 36.0   2.0 40.0     0.0   29.0   198.0 192.0     23.0   7.0     149.0   66.0   390.0 221 62 36   2 40     0   29   198 192     23 7   149 66   390
1888651 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318002501 193 Oak View Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2018   grade_7 352.0 11.0 9.0   2.0 11.0     1.0   16.0   205.0 197.0     3.0   4.0     57.0   *   402.0 352 11 9   2 11     1   16   205 197     3 4   57     402
1888655 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000122 195 Roosevelt Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2018   grade_7 321.0 32.0 13.0   1.0 38.0     0.0   14.0   204.0 215.0     8.0   2.0     94.0   47.0   419.0 321 32 13   1 38     0   14   204 215     8 2   94 47   419
1890704 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318002974 812 Compass-Bell Center Public Area Learning Center ALC (State approved) Alternative School No High 06 12 2018   grade_7 1.0 2.0 0.0   0.0 0.0     0.0   0.0   3.0 0.0     *   *     *   *   3.0 1 2 0   0 0     0   0   3 0                 3
1891389 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000005 467 River Trail Learning Center at Lo Jacob Special Education Special Education School No Other KG 12 2018   grade_7 4.0 1.0 0.0   0.0 0.0     0.0   1.0   5.0 1.0     *   *     *   *   6.0 4 1 0   0 0     0   1   5 1                 6
1953230 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000117 3 ANOKA MIDDLE SCHOOL FOR THE ARTS Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_7 454.0 68.0 27.0   6.0 23.0     1.0   33.0   306.0 306.0     23.0   13.0     209.0   104.0   612.0 454 68 27   6 23     1   33   306 306     23 13   209 104   612
1953234 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000099 4 COON RAPIDS MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_7 260.0 80.0 36.0   7.0 25.0     0.0   26.0   236.0 198.0     21.0   17.0     229.0   73.0   434.0 260 80 36   7 25     0   26   236 198     21 17   229 73   434
1953238 MN Hennepin 27 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000108 6 JACKSON MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_7 372.0 135.0 53.0   4.0 88.0     1.0   56.0   369.0 340.0     39.0   10.0     243.0   80.0   709.0 372 135 53   4 88     1   56   369 340     39 10   243 80   709
1953242 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000119 90 NORTHDALE MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_7 277.0 54.0 31.0   4.0 43.0     0.0   21.0   231.0 199.0     19.0   11.0     191.0   79.0   430.0 277 54 31   4 43     0   21   231 199     19 11   191 79   430
1953246 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318002501 193 OAK VIEW MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_7 362.0 11.0 13.0   0.0 9.0     1.0   11.0   212.0 195.0     4.0   5.0     65.0   *   407.0 362 11 13   0 9     1   11   212 195     4 5   65     407
1953250 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000122 195 Roosevelt Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_7 322.0 35.0 20.0   2.0 27.0     0.0   11.0   221.0 196.0     6.0   8.0     109.0   *   417.0 322 35 20   2 27     0   11   221 196     6 8   109     417
1955973 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000005 467 RIVER TRAIL LEARNING CTR @ LO JACOB Special Education Special Education School No Other KG 12 2019   grade_7 9.0 1.0 1.0   0.0 0.0     0.0   1.0   12.0 0.0     0.0   0.0     7.0   *   12.0 9 1 1   0 0     0   1   12 0     0 0   7     12
1713060 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 2021   grade_7 9 0 2   0 0     0   1   8 4     0.0   0.0     4.0   5.0   12 9 0 2   0 0     0   1   8 4     0 0   4 5   12
1826631 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 2020   grade_7 19.0 0.0 0.0   0.0 0.0     0.0   2.0   13.0 8.0     0.0   0.0     3.0   5.0   21.0 19 0 0   0 0     0   2   13 8     0 0   3 5   21
1881223 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 2018   grade_7 21.0 1.0 0.0   0.0 0.0     0.0   0.0   9.0 13.0     0.0   0.0     4.0   6.0   22.0 21 1 0   0 0     0   0   9 13     0 0   4 6   22
697479 MN Isanti 30 school 2700397 4227 Charter Schools Art and Science Academy 270039704766 10 Art and Science Academy Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2017   grade_7 18.0 2.0 0.0   0.0 0.0     0.0   0.0   10.0 10.0     0.0   0.0     4.0   9.0   20.0 18 2 0   0 0     0   0   10 10     0 0   4 9   20
861722 MN Isanti 30 school 2700397 4227 Charter Schools Art and Science Academy 270039704766 10 Art and Science Academy Elementary School (Grades PK-6) Regular School Yes 1 KG 07 2016   grade_7 11 0 0   0 0     0   0   8 3     0.0   0.0     4.0   0.0   11 11 0 0   0 0     0   0   8 3     0 0   4 0   11
1721637 MN Isanti 30 school 2700397 4227 Charter Schools Art and Science Academy 270039705095 30 Art & Science Academy Middle School Middle School (Grades 5-8) Regular School Yes Middle 05 08 2021   grade_7 35 2 1   0 0     0   2   19 21     0.0   1.0     9.0   13.0   40 35 2 1   0 0     0   2   19 21     0 1   9 13   40
1835148 MN Isanti 30 school 2700397 4227 Charter Schools Art and Science Academy 270039705095 30 Art & Science Academy Middle School Middle School (Grades 5-8) Regular School Yes Middle 05 08 2020   grade_7 46.0 0.0 0.0   0.0 0.0     0.0   3.0   28.0 21.0     0.0   0.0     12.0   10.0   49.0 46 0 0   0 0     0   3   28 21     0 0   12 10   49
1889586 MN Isanti 30 school 2700397 4227 Charter Schools Art and Science Academy 270039705095 30 Art and Science Academy Middle School Middle School (Grades 5-8) Regular School Yes Middle 05 08 2018   grade_7 49.0 0.0 1.0   0.0 0.0     0.0   0.0   16.0 34.0     0.0   0.0     19.0   5.0   50.0 49 0 1   0 0     0   0   16 34     0 0   19 5   50
1954198 MN Isanti 30 school 2700397 4227 Charter Schools Art and Science Academy 270039705095 30 Art & Science Academy Middle School Middle School (Grades 5-8) Regular School Yes Middle 05 08 2019   grade_7 30.0 0.0 2.0   0.0 0.0     0.0   3.0   19.0 16.0     0.0   0.0     14.0   5.0   35.0 30 0 2   0 0     0   3   19 16     0 0   14 5   35
1711894 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 2021   grade_7 22 0 0   1 0     0   0   10 13     0.0   0.0     9.0   2.0   23 22 0 0   1 0     0   0   10 13     0 0   9 2   23
1825462 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 2020   grade_7 22.0 0.0 0.0   0.0 0.0     0.0   0.0   6.0 16.0     0.0   0.0     9.0   7.0   22.0 22 0 0   0 0     0   0   6 16     0 0   9 7   22
1880059 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 2018   grade_7 16.0 0.0 1.0   0.0 0.0     0.0   0.0   7.0 10.0     0.0   0.0     6.0   2.0   17.0 16 0 1   0 0     0   0   7 10     0 0   6 2   17
1720062 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 2021   grade_7 25 6 0   0 2     0   1   19 15     2.0   0.0     4.0   5.0   34 25 6 0   0 2     0   1   19 15     2 0   4 5   34
1833613 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 2020   grade_7 28.0 3.0 1.0   0.0 1.0     0.0   0.0   21.0 12.0     0.0   0.0     7.0   9.0   33.0 28 3 1   0 1     0   0   21 12     0 0   7 9   33
1888157 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 2018   grade_7 28.0 4.0 0.0   0.0 3.0     0.0   1.0   18.0 18.0     1.0   0.0     9.0   3.0   36.0 28 4 0   0 3     0   1   18 18     1 0   9 3   36
1720395 MN Stearns 73 school 2700430 4250 Charter Schools Athlos Academy of Saint Cloud 270043004959 10 Athlos Academy of Saint Cloud Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2021   grade_7 13 18 6   0 0     0   2   14 25     9.0   1.0     17.0   7.0   39 13 18 6   0 0     0   2   14 25     9 1   17 7   39
1833945 MN Stearns 73 school 2700430 4250 Charter Schools Athlos Academy of Saint Cloud 270043004959 10 Athlos Academy of Saint Cloud Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2020   grade_7 21.0 28.0 5.0   0.0 0.0     1.0   2.0   31.0 26.0     16.0   0.0     34.0   7.0   57.0 21 28 5   0 0     1   2   31 26     16 0   34 7   57
1888480 MN Stearns 73 school 2700430 4250 Charter Schools Athlos Academy of Saint Cloud 270043004959 10 Athlos Academy of Saint Cloud Elementary School (Grades PK-6) Regular School Yes Elementary KG 07 2018   grade_7 32.0 26.0 4.0   0.0 1.0     0.0   6.0   38.0 31.0     18.0   1.0     37.0   9.0   69.0 32 26 4   0 1     0   6   38 31     18 1   37 9   69
1953053 MN Stearns 73 school 2700430 4250 Charter Schools Athlos Academy of Saint Cloud 270043004959 10 Athlos Academy of Saint Cloud Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2019   grade_7 21.0 29.0 3.0   1.0 0.0     0.0   4.0   30.0 28.0     18.0   0.0     43.0   7.0   58.0 21 29 3   1 0     0   4   30 28     18 0   43 7   58
696664 MN Hennepin 27 school 2700096 4011 Charter Schools Athlos Leadership Academy 270009601892 10 Athlos Leadership Academy Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2017   grade_7 16.0 40.0 8.0   1.0 3.0     0.0   19.0   36.0 51.0     8.0   2.0     49.0   10.0   87.0 16 40 8   1 3     0   19   36 51     8 2   49 10   87

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