Data source: Big Local News · About: Big Local

680 rows where grade = "grade_7", state = "MN" and year = 2016 sorted by district_state_id

View and edit SQL

year

  • 2016 · 680

grade

  • grade_7 · 680
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
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
860580 MN Hennepin 27 school 2721240 1 Special Districts and Schools MINNEAPOLIS PUBLIC SCHOOL DIST. 272124000942 106 BARTON OPEN ELEMENTARY Elementary School (Grades PK-6) Regular School No 1 KG 08 2016   grade_7 54 24 8   2 4     0   1   47 46     14.0   1.0     28.0   6.0   93 54 24 8   2 4     0   1   47 46     14 1   28 6   93
860600 MN Hennepin 27 school 2721240 1 Special Districts and Schools MINNEAPOLIS PUBLIC SCHOOL DIST. 272124000969 121 LAKE HARRIET UPPER SCHOOL Elementary School (Grades PK-6) Regular School No 2 04 08 2016   grade_7 108 11 5   0 2     0   1   66 61     5.0   2.0     16.0   15.0   127 108 11 5   0 2     0   1   66 61     5 2   16 15   127
860622 MN Hennepin 27 school 2721240 1 Special Districts and Schools MINNEAPOLIS PUBLIC SCHOOL DIST. 272124000988 134 LK NOKOMIS COMM-KEEWAYDIN CAMPUS Elementary School (Grades PK-6) Regular School No 1 03 08 2016   grade_7 30 15 11   3 0     1   3   26 37     7.0   6.0     39.0   11.0   63 30 15 11   3 0     1   3   26 37     7 6   39 11   63
860693 MN Hennepin 27 school 2721240 1 Special Districts and Schools MINNEAPOLIS PUBLIC SCHOOL DIST. 272124001031 160 SEWARD ELEMENTARY Elementary School (Grades PK-6) Regular School No 1 KG 08 2016   grade_7 32 44 6   2 5     0   0   48 41     25.0   1.0     50.0   7.0   89 32 44 6   2 5     0   0   48 41     25 1   50 7   89
860732 MN Hennepin 27 school 2721240 1 Special Districts and Schools MINNEAPOLIS PUBLIC SCHOOL DIST. 272124001866 175 FOLWELL ARTS MAGNET Elementary School (Grades PK-6) Regular School No 1 PK 08 2016   grade_7 8 29 52   1 3     0   0   41 52         7.0     80.0   11.0   93 8 29 52   1 3     0   0   41 52       7   80 11   93
860743 MN Hennepin 27 school 2721240 1 Special Districts and Schools MINNEAPOLIS PUBLIC SCHOOL DIST. 272124000986 179 JEFFERSON ELEMENTARY Elementary School (Grades PK-6) Regular School No 1 PK 08 2016   grade_7 0 20 25   0 3     0   0   26 22     30.0   6.0         5.0   48 0 20 25   0 3     0   0   26 22     30 6     5   48
860761 MN Hennepin 27 school 2721240 1 Special Districts and Schools MINNEAPOLIS PUBLIC SCHOOL DIST. 272124000932 190 ANDERSEN COMMUNITY Elementary School (Grades PK-6) Regular School No 1 PK 08 2016   grade_7 5 41 66   6 4     0   0   59 63     86.0   14.0         31.0   122 5 41 66   6 4     0   0   59 63     86 14     31   122
860772 MN Hennepin 27 school 2721240 1 Special Districts and Schools MINNEAPOLIS PUBLIC SCHOOL DIST. 272124002297 193 SULLIVAN ELEMENTARY Elementary School (Grades PK-6) Regular School No 1 PK 08 2016   grade_7 3 51 2   4 2     0   1   27 36     36.0   2.0         8.0   63 3 51 2   4 2     0   1   27 36     36 2     8   63
860792 MN Hennepin 27 school 2721240 1 Special Districts and Schools MINNEAPOLIS PUBLIC SCHOOL DIST. 272124004172 225 ANISHINABE ACADEMY Elementary School (Grades PK-6) Regular School No 1 PK 08 2016   grade_7 0 3 3   21 0     0   3   16 14     2.0   7.0         4.0   30 0 3 3   21 0     0   3   16 14     2 7     4   30
860802 MN Hennepin 27 school 2721240 1 Special Districts and Schools MINNEAPOLIS PUBLIC SCHOOL DIST. 272124002144 226 MARCY OPEN ELEMENTARY Elementary School (Grades PK-6) Regular School No 1 KG 08 2016   grade_7 35 27 0   1 4     0   0   36 31     13.0   1.0     34.0   10.0   67 35 27 0   1 4     0   0   36 31     13 1   34 10   67
860868 MN Hennepin 27 school 2721240 1 Special Districts and Schools MINNEAPOLIS PUBLIC SCHOOL DIST. 272124004239 291 HMONG INTERNATIONAL ACADEMY Elementary School (Grades PK-6) Regular School No 1 PK 08 2016   grade_7 1 13 1   0 35     0   0   27 23     27.0   2.0         8.0   50 1 13 1   0 35     0   0   27 23     27 2     8   50
862664 MN Hennepin 27 school 2721240 1 Special Districts and Schools MINNEAPOLIS PUBLIC SCHOOL DIST. 272124000965 119 FIELD ELEMENTARY Middle School (Grades 5-8) Regular School No 2 05 08 2016   grade_7 93 18 5   1 9     0   0   72 54     1.0   1.0     27.0   15.0   126 93 18 5   1 9     0   0   72 54     1 1   27 15   126
862668 MN Hennepin 27 school 2721240 1 Special Districts and Schools MINNEAPOLIS PUBLIC SCHOOL DIST. 272124000936 300 ANTHONY MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No 2 06 08 2016   grade_7 125 54 24   7 8     0   1   95 124     23.0   5.0     85.0   27.0   219 125 54 24   7 8     0   1   95 124     23 5   85 27   219
862672 MN Hennepin 27 school 2721240 1 Special Districts and Schools MINNEAPOLIS PUBLIC SCHOOL DIST. 272124000937 309 ANWATIN MIDDLE COM & SPANISH D I Middle School (Grades 5-8) Regular School No 2 06 08 2016   grade_7 25 92 62   5 16     0   3   109 94     54.0   20.0     159.0   34.0   203 25 92 62   5 16     0   3   109 94     54 20   159 34   203
862676 MN Hennepin 27 school 2721240 1 Special Districts and Schools MINNEAPOLIS PUBLIC SCHOOL DIST. 272124001008 316 NORTHEAST MIDDLE Middle School (Grades 5-8) Regular School No 2 06 08 2016   grade_7 38 96 34   10 8     0   0   105 81     30.0   14.0     151.0   41.0   186 38 96 34   10 8     0   0   105 81     30 14   151 41   186
862680 MN Hennepin 27 school 2721240 1 Special Districts and Schools MINNEAPOLIS PUBLIC SCHOOL DIST. 272124002581 318 OLSON MIDDLE Middle School (Grades 5-8) Regular School No 2 06 08 2016   grade_7 4 68 7   5 11     0   1   57 39     8.0   15.0         29.0   96 4 68 7   5 11     0   1   57 39     8 15     29   96
862684 MN Hennepin 27 school 2721240 1 Special Districts and Schools MINNEAPOLIS PUBLIC SCHOOL DIST. 272124004574 323 RAMSEY MIDDLE Middle School (Grades 5-8) Regular School No 2 06 08 2016   grade_7 139 42 50   2 6     0   4   122 121     45.0   2.0     84.0   26.0   243 139 42 50   2 6     0   4   122 121     45 2   84 26   243
862688 MN Hennepin 27 school 2721240 1 Special Districts and Schools MINNEAPOLIS PUBLIC SCHOOL DIST. 272124001028 324 SANFORD MIDDLE Middle School (Grades 5-8) Regular School No 2 06 08 2016   grade_7 104 87 36   27 10     0   4   132 136     54.0   18.0     165.0   37.0   268 104 87 36   27 10     0   4   132 136     54 18   165 37   268
862692 MN Hennepin 27 school 2721240 1 Special Districts and Schools MINNEAPOLIS PUBLIC SCHOOL DIST. 272124004882 327 Franklin Middle School Middle School (Grades 5-8) Regular School No 2 06 08 2016   grade_7 0 73 15   2 3     0   0   46 47     16.0   10.0         30.0   93 0 73 15   2 3     0   0   46 47     16 10     30   93
865183 MN Hennepin 27 school 2721240 1 Special Districts and Schools MINNEAPOLIS PUBLIC SCHOOL DIST. 272124003022 625 RIVER BEND EDUCATIONAL CENTER Special Education Special Education School No 4 KG 12 2016   grade_7 0 13 0   0 0     0   2   10 5     1.0   2.0         *   15 0 13 0   0 0     0   2   10 5     1 2         15
866040 MN Hennepin 27 school 2721240 1 Special Districts and Schools MINNEAPOLIS PUBLIC SCHOOL DIST. 272124001935 688 MPS METRO HA Hospital/Medical/Partial Hospitalization Program Alternative Education School No 4 KG 12 2016   grade_7 3 0 0   0 0     0   0   0 3         *         *   3 3 0 0   0 0     0   0   0 3                 3
866513 MN Hennepin 27 school 2721240 1 Special Districts and Schools MINNEAPOLIS PUBLIC SCHOOL DIST. 272124001936 689 MPS METRO SJ Educational Oversight to Public Residential Care & Treatment (State approved) Alternative Education School No 4 KG 12 2016   grade_7 1 2 0   0 0     0   1   4 0         *         *   4 1 2 0   0 0     0   1   4 0                 4
866519 MN Hennepin 27 school 2721240 1 Special Districts and Schools MINNEAPOLIS PUBLIC SCHOOL DIST. 272124001948 697 MPS METRO C Educational Oversight to Public Residential Care & Treatment (State approved) Alternative Education School No 4 KG 12 2016   grade_7 1 0 0   0 0     0   0   0 1         *         *   1 1 0 0   0 0     0   0   0 1                 1
866792 MN Hennepin 27 school 2721240 1 Special Districts and Schools MINNEAPOLIS PUBLIC SCHOOL DIST. 272124002860 315 RONALD MCDONALD HOUSE Private Alternative Program Alternative Education School No 4 KG 12 2016   grade_7 0 0 1   0 0     0   0   1 0         *         *   1 0 0 1   0 0     0   0   1 0                 1
866827 MN Hennepin 27 school 2721240 1 Special Districts and Schools MINNEAPOLIS PUBLIC SCHOOL DIST. 272124004313 417 HERITAGE SCIENCE & TECHNOLOGY Private Alternative Program Alternative Education School No 4 06 12 2016   grade_7 0 32 0   0 0     0   0   17 15     16.0   1.0         1.0   32 0 32 0   0 0     0   0   17 15     16 1     1   32
853528 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 3 07 12 2016   grade_7 22 0 2   0 0     0   1   10 15     0.0   0.0     18.0   7.0   25 22 0 2   0 0     0   1   10 15     0 0   18 7   25
862696 MN Washington 82 school 2700411 1001 State Operated Integration Magnet School Crosswinds Arts and Science School 270041104874 10 Crosswinds Arts and Science Middle School Middle School (Grades 5-8) Regular School No 2 06 08 2016   grade_7 13 19 5   1 5     0   2   21 24     3.0   1.0     15.0   14.0   45 13 19 5   1 5     0   2   21 24     3 1   15 14   45
861954 MN Carver 10 school 2723910 108 Independent Districts and Schools CENTRAL PUBLIC SCHOOL DISTRICT 272391002507 30 CENTRAL MIDDLE Middle School (Grades 5-8) Regular School No 2 06 08 2016   grade_7 64 1 0   0 3     0   4   38 34     0.0   1.0     12.0   8.0   72 64 1 0   0 3     0   4   38 34     0 1   12 8   72
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
861959 MN Carver 10 school 2741460 110 Independent Districts and Schools WACONIA PUBLIC SCHOOL DISTRICT 274146003066 220 CLEARWATER MIDDLE Middle School (Grades 5-8) Regular School No 2 05 08 2016   grade_7 267 2 15   0 5     0   5   147 147     1.0   0.0     34.0   28.0   294 267 2 15   0 5     0   5   147 147     1 0   34 28   294
861963 MN Carver 10 school 2741910 111 Independent Districts and Schools WATERTOWN-MAYER PUBLIC SCHOOL DIST. 274191000024 841 WATERTOWN-MAYER MIDDLE Middle School (Grades 5-8) Regular School No 2 06 08 2016   grade_7 101 0 4   0 2     0   1   50 58     2.0   1.0     19.0   12.0   108 101 0 4   0 2     0   1   50 58     2 1   19 12   108
861967 MN Carver 10 school 2708190 112 Independent Districts and Schools EASTERN CARVER COUNTY PUBLIC SCHOOL 270819000345 61 CHASKA MIDDLE SCHOOL EAST Middle School (Grades 5-8) Regular School No 2 06 08 2016   grade_7 201 3 21   1 10     0   3   141 98     3.0   2.0     29.0   24.0   239 201 3 21   1 10     0   3   141 98     3 2   29 24   239
861971 MN Carver 10 school 2708190 112 Independent Districts and Schools EASTERN CARVER COUNTY PUBLIC SCHOOL 270819002798 62 CHASKA MIDDLE SCHOOL WEST Middle School (Grades 5-8) Regular School No 2 06 08 2016   grade_7 198 10 9   2 17     0   10   125 121     6.0   0.0     43.0   38.0   246 198 10 9   2 17     0   10   125 121     6 0   43 38   246
861975 MN Carver 10 school 2708190 112 Independent Districts and Schools EASTERN CARVER COUNTY PUBLIC SCHOOL 270819003180 63 PIONEER RIDGE MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No 2 06 08 2016   grade_7 137 10 27   1 8     1   2   94 92     8.0   0.0     52.0   27.0   186 137 10 27   1 8     1   2   94 92     8 0   52 27   186
864007 MN Carver 10 school 2708190 112 Independent Districts and Schools EASTERN CARVER COUNTY PUBLIC SCHOOL 270819004622 66 112 ALC MIDDLE SCHOOL Public Area Learning Center ALC (State approved) Alternative Education School No 2 06 08 2016   grade_7 20 1 1   0 0     0   0   16 6     1.0   0.0     8.0   2.0   22 20 1 1   0 0     0   0   16 6     1 0   8 2   22
853535 MN Cass 11 school 2702910 113 Independent Districts and Schools WALKER-HACKENSACK-AKELEY SCHL. DIST 270291001737 20 WALKER-HACKENSACK-AKELEY SEC. Secondary School (Grades 7-12) Regular School No 3 07 12 2016   grade_7 51 0 0   12 1     0   2   38 28     1.0   2.0     34.0   13.0   66 51 0 0   12 1     0   2   38 28     1 2   34 13   66
861980 MN Cass 11 school 2708070 115 Independent Districts and Schools CASS LAKE-BENA PUBLIC SCHOOLS 270807003181 20 CASS LAKE-BENA MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No 2 05 08 2016   grade_7 6 0 4   61 0     0   6   37 40         *         *   77 6 0 4   61 0     0   6   37 40                 77
864012 MN Cass 11 school 2708070 115 Independent Districts and Schools CASS LAKE-BENA PUBLIC SCHOOLS 270807002234 31 CASS LAKE-BENA AREA LRNG. CNTR. Public Area Learning Center ALC (State approved) Alternative Education School No 3 07 12 2016   grade_7 0 0 0   3 0     0   0   0 3         *         *   3 0 0 0   3 0     0   0   0 3                 3
861985 MN Cass 11 school 2728350 116 Independent Districts and Schools PILLAGER PUBLIC SCHOOL DISTRICT 272835004841 40 Pillager Middle School Middle School (Grades 5-8) Regular School No 2 05 08 2016   grade_7 67 0 1   0 0     0   0   32 36     0.0   0.0     31.0   15.0   68 67 0 1   0 0     0   0   32 36     0 0   31 15   68
853542 MN Cass 11 school 2730870 118 Independent Districts and Schools NORTHLAND COMMUNITY SCHOOLS 273087001308 20 NORTHLAND SECONDARY Secondary School (Grades 7-12) Regular School No 3 07 12 2016   grade_7 9 0 0   2 1     0   0   11 1     0.0   0.0     7.0   3.0   12 9 0 0   2 1     0   0   11 1     0 0   7 3   12
861908 MN Anoka 2 school 2708100 12 Independent Districts and Schools CENTENNIAL PUBLIC SCHOOL DISTRICT 270810002784 166 CENTENNIAL MIDDLE Middle School (Grades 5-8) Regular School No 2 06 08 2016   grade_7 445 10 23   2 20     0   8   240 268     7.0   4.0     88.0   81.0   508 445 10 23   2 20     0   8   240 268     7 4   88 81   508
866256 MN Anoka 2 school 2708100 12 Independent Districts and Schools CENTENNIAL PUBLIC SCHOOL DISTRICT 270810004656 159 Pines School - NSP Educational Oversight to Public Residential Care & Treatment (State approved) Alternative Education School No 3 07 12 2016   grade_7 0 1 0   0 0     0   0   0 1         *         *   1 0 1 0   0 0     0   0   0 1                 1
866263 MN Anoka 2 school 2708100 12 Independent Districts and Schools CENTENNIAL PUBLIC SCHOOL DISTRICT 270810004620 161 Pines School - RJC Educational Oversight to Public Residential Care & Treatment (State approved) Alternative Education School No 3 07 12 2016   grade_7 1 0 0   0 0     0   0   1 0         *         *   1 1 0 0   0 0     0   0   1 0                 1
866589 MN Anoka 2 school 2708100 12 Independent Districts and Schools CENTENNIAL PUBLIC SCHOOL DISTRICT 270810004616 162 PINES SCHOOL DAY PROGRAM Miscellaneous Program (assignment is now limited) Alternative Education School No 3 07 12 2016   grade_7 1 0 0   0 0     0   0   1 0         *         *   1 1 0 0   0 0     0   0   1 0                 1
861991 MN Chippewa 12 school 2721320 129 Independent Districts and Schools MONTEVIDEO PUBLIC SCHOOL DISTRICT 272132001071 30 MONTEVIDEO MIDDLE Middle School (Grades 5-8) Regular School No 2 04 07 2016   grade_7 67 1 19   0 0     1   5   42 51     9.0   1.0     48.0   16.0   93 67 1 19   0 0     1   5   42 51     9 1   48 16   93
861912 MN Anoka 2 school 2709510 13 Independent Districts and Schools COLUMBIA HEIGHTS PUBLIC SCHOOL DIST 270951000395 17 COLUMBIA ACADEMY Middle School (Grades 5-8) Regular School No 2 06 08 2016   grade_7 38 69 71   5 12     2   15   118 94     28.0   4.0     180.0   35.0   212 38 69 71   5 12     2   15   118 94     28 4   180 35   212
861995 MN Chisago 13 school 2723820 138 Independent Districts and Schools NORTH BRANCH PUBLIC SCHOOLS 272382001164 20 NORTH BRANCH MIDDLE Middle School (Grades 5-8) Regular School No 2 05 08 2016   grade_7 201 4 3   2 2     0   3   121 94     0.0   *     62.0   32.0   215 201 4 3   2 2     0   3   121 94     0     62 32   215
864019 MN Chisago 13 school 2723820 138 Independent Districts and Schools NORTH BRANCH PUBLIC SCHOOLS 272382000401 50 NORTH BRANCH LAB SCHOOL ALC Public Area Learning Center ALC (State approved) Alternative Education School No 3 07 12 2016   grade_7 20 0 3   0 1     0   1   18 7         0.0         *   25 20 0 3   0 1     0   1   18 7       0         25
866095 MN Chisago 13 school 2723820 138 Independent Districts and Schools NORTH BRANCH PUBLIC SCHOOLS 272382002633 70 DISTANCE LEARNING PROGRAM Distance Learning Program OLL (State approved) Regular School No 4 KG 12 2016   grade_7 2 0 0   0 0     0   0   1 1         *         *   2 2 0 0   0 0     0   0   1 1                 2
853549 MN Chisago 13 school 2732550 139 Independent Districts and Schools RUSH CITY PUBLIC SCHOOL DISTRICT 273255001406 20 RUSH CITY SECONDARY Secondary School (Grades 7-12) Regular School No 3 07 12 2016   grade_7 63 1 2   1 2     0   0   35 34     0.0   0.0     26.0   4.0   69 63 1 2   1 2     0   0   35 34     0 0   26 4   69
861917 MN Anoka 2 school 2712420 14 Independent Districts and Schools FRIDLEY PUBLIC SCHOOL DISTRICT 271242000610 23 FRIDLEY MIDDLE Middle School (Grades 5-8) Regular School No 2 05 08 2016   grade_7 95 68 33   3 20     0   7   113 113         *         *   226 95 68 33   3 20     0   7   113 113                 226
863939 MN Anoka 2 school 2712420 14 Independent Districts and Schools FRIDLEY PUBLIC SCHOOL DISTRICT 271242003427 652 FRIDLEY MIDDLE AREA LEARNING CENTER Public Area Learning Center ALC (State approved) Alternative Education School No 2 05 08 2016   grade_7 7 6 2   0 0     0   0   5 10         *         *   15 7 6 2   0 0     0   0   5 10                 15
853556 MN Clay 14 school 2703660 146 Independent Districts and Schools Barnesville Public School District 270366000170 40 BARNESVILLE SECONDARY Secondary School (Grades 7-12) Regular School No 4 06 12 2016   grade_7 75 0 1   2 0     0   1   38 41     0.0   0.0     17.0   15.0   79 75 0 1   2 0     0   1   38 41     0 0   17 15   79
861921 MN Anoka 2 school 2733540 15 Independent Districts and Schools ST. FRANCIS PUBLIC SCHOOL DISTRICT 273354000013 123 ST. FRANCIS MIDDLE Middle School (Grades 5-8) Regular School No 2 06 08 2016   grade_7 342 4 10   3 15     0   8   190 192         *         *   382 342 4 10   3 15     0   8   190 192                 382
866599 MN Anoka 2 school 2733540 15 Independent Districts and Schools ST. FRANCIS PUBLIC SCHOOL DISTRICT 273354000268 850 CROSSROADS SCHOOL & VOC. CENTER Miscellaneous Program (assignment is now limited) Alternative Education School No 4 KG 12 2016   grade_7 3 4 0   1 0     0   1   9 0         *         *   9 3 4 0   1 0     0   1   9 0                 9
853563 MN Clay 14 school 2713560 150 Independent Districts and Schools HAWLEY PUBLIC SCHOOL DISTRICT 271356000699 20 HAWLEY SECONDARY Secondary School (Grades 7-12) Regular School No 3 07 12 2016   grade_7 80 0 0   0 0     0   2   38 44         0.0     12.0   13.0   82 80 0 0   0 0     0   2   38 44       0   12 13   82
861999 MN Clay 14 school 2721420 152 Independent Districts and Schools MOORHEAD PUBLIC SCHOOL DISTRICT 272142003512 380 HORIZON MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No 2 06 08 2016   grade_7 342 26 33   8 8     0   24   241 200         *     175.0   59.0   441 342 26 33   8 8     0   24   241 200           175 59   441
864026 MN Clay 14 school 2721420 152 Independent Districts and Schools MOORHEAD PUBLIC SCHOOL DISTRICT 272142000462 980 Red River Area Learning Center Public Area Learning Center ALC (State approved) Alternative Education School No 4 05 12 2016   grade_7 4 2 3   1 0     0   3   8 5         0.0         *   13 4 2 3   1 0     0   3   8 5       0         13
866296 MN Clay 14 school 2721420 152 Independent Districts and Schools MOORHEAD PUBLIC SCHOOL DISTRICT 272142002799 970 CLAY COUNTY SHELTER CARE Educational Oversight to Public Residential Care & Treatment (State approved) Alternative Education School No 4 03 12 2016   grade_7 0 0 0   1 0     0   0   0 1         *         *   1 0 0 0   1 0     0   0   0 1                 1
853429 MN Anoka 2 school 2733330 16 Independent Districts and Schools SPRING LAKE PARK PUBLIC SCHOOLS 273333004658 788 Secondary Lighthouse Secondary School (Grades 7-12) Regular School No 3 07 12 2016   grade_7 10 1 0   0 0     0   2   6 7     0.0   *     1.0   0.0   13 10 1 0   0 0     0   2   6 7     0     1 0   13
861925 MN Anoka 2 school 2733330 16 Independent Districts and Schools SPRING LAKE PARK PUBLIC SCHOOLS 273333001466 92 WESTWOOD MIDDLE Middle School (Grades 5-8) Regular School No 2 06 08 2016   grade_7 231 45 55   1 34     2   25   197 196     30.0   *     174.0   57.0   393 231 45 55   1 34     2   25   197 196     30     174 57   393
865195 MN Rice 66 school 2700129 160 State Operated Schools (which include MN Academy Deaf & Blind, School for the Arts) MINNESOTA STATE ACADEMIES 270012903056 1 MN ACADEMY FOR THE BLIND Special Education Special Education School No 4 PK 12 2016   grade_7 2 0 0   0 0     0   0   2 0         *         *   2 2 0 0   0 0     0   0   2 0                 2
865209 MN Rice 66 school 2700129 160 State Operated Schools (which include MN Academy Deaf & Blind, School for the Arts) MINNESOTA STATE ACADEMIES 270012902409 2 MN ACADEMY FOR THE DEAF Special Education Special Education School No 4 PK 12 2016   grade_7 3 0 1   0 0     0   0   2 2         *         *   4 3 0 1   0 0     0   0   2 2                 4
853570 MN Clearwater 15 school 2703570 162 Independent Districts and Schools BAGLEY PUBLIC SCHOOL DISTRICT 270357000165 20 BAGLEY SECONDARY Secondary School (Grades 7-12) Regular School No 3 07 12 2016   grade_7 53 1 1   17 0     0   3   42 33     0.0   0.0     36.0   16.0   75 53 1 1   17 0     0   3   42 33     0 0   36 16   75
862003 MN Cook 16 school 2713110 166 Independent Districts and Schools COOK COUNTY PUBLIC SCHOOLS 271311002635 40 COOK COUNTY MIDDLE Middle School (Grades 5-8) Regular School No 2 06 08 2016   grade_7 21 1 0   10 0     0   3   23 12     0.0   0.0     20.0   7.0   35 21 1 0   10 0     0   3   23 12     0 0   20 7   35
853577 MN Cottonwood 17 school 2723010 173 Independent Districts and Schools MOUNTAIN LAKE PUBLIC SCHOOLS 272301001135 20 MOUNTAIN LAKE SECONDARY Secondary School (Grades 7-12) Regular School No 3 07 12 2016   grade_7 20 0 8   0 2     0   0   16 14     0.0   0.0     16.0   5.0   30 20 0 8   0 2     0   0   16 14     0 0   16 5   30
862009 MN Cottonwood 17 school 2742780 177 Independent Districts and Schools WINDOM PUBLIC SCHOOL DISTRICT 274278003068 60 WINDOM MIDDLE Middle School (Grades 5-8) Regular School No 2 04 08 2016   grade_7 71 4 8   0 1     0   3   45 42     3.0   0.0     40.0   19.0   87 71 4 8   0 1     0   3   45 42     3 0   40 19   87
862014 MN Crow Wing 18 school 2706090 181 Independent Districts and Schools BRAINERD PUBLIC SCHOOL DISTRICT 270609004196 22 FORESTVIEW MIDDLE Middle School (Grades 5-8) Regular School No 2 05 08 2016   grade_7 451 9 7   7 3     0   8   237 248         4.0     181.0   66.0   485 451 9 7   7 3     0   8   237 248       4   181 66   485
864040 MN Crow Wing 18 school 2706090 181 Independent Districts and Schools BRAINERD PUBLIC SCHOOL DISTRICT 270609002982 21 MIDDLE LEVEL ALTERNATIVE PROGRAM Public Area Learning Center ALC (State approved) Alternative Education School No 2 05 08 2016   grade_7 2 0 0   1 0     0   0   2 1         *         *   3 2 0 0   1 0     0   0   2 1                 3
866609 MN Crow Wing 18 school 2706090 181 Independent Districts and Schools BRAINERD PUBLIC SCHOOL DISTRICT 270609000468 17 LINCOLN EDUCATION CENTER Miscellaneous Program (assignment is now limited) Alternative Education School No 4 03 12 2016   grade_7 5 1 0   0 0     0   1   7 0         *         *   7 5 1 0   0 0     0   1   7 0                 7
853584 MN Crow Wing 18 school 2709750 182 Independent Districts and Schools CROSBY-IRONTON PUBLIC SCHOOL DIST. 270975000417 1 CROSBY-IRONTON SECONDARY Secondary School (Grades 7-12) Regular School No 3 07 12 2016   grade_7 77 0 1   1 0     0   4   42 41     0.0   0.0     39.0   11.0   83 77 0 1   1 0     0   4   42 41     0 0   39 11   83
862019 MN Crow Wing 18 school 2728200 186 Independent Districts and Schools PEQUOT LAKES PUBLIC SCHOOLS 272820003069 15 PEQUOT LAKES MIDDLE Middle School (Grades 5-8) Regular School No 2 05 08 2016   grade_7 123 1 0   2 0     0   5   71 60     0.0   0.0         22.0   131 123 1 0   2 0     0   5   71 60     0 0     22   131
864043 MN Dakota 19 school 2707290 191 Independent Districts and Schools BURNSVILLE PUBLIC SCHOOL DISTRICT 270729002640 314 BURNSVILLE AREA LEARNING CENTER Public Area Learning Center ALC (State approved) Alternative Education School No 3 07 12 2016   grade_7 56 44 35   0 9     2   14   75 85     24.0   3.0     98.0   10.0   160 56 44 35   0 9     2   14   75 85     24 3   98 10   160
866673 MN Dakota 19 school 2707290 191 Independent Districts and Schools BURNSVILLE PUBLIC SCHOOL DISTRICT 270729000295 15 METCALF JUNIOR HIGH Junior High School (Grades 7-8 or 7-9) Regular School No 2 07 09 2016   grade_7 108 46 33   1 9     1   18   106 110     26.0   6.0     99.0   35.0   216 108 46 33   1 9     1   18   106 110     26 6   99 35   216
866677 MN Scott 70 school 2707290 191 Independent Districts and Schools BURNSVILLE PUBLIC SCHOOL DISTRICT 270729002639 66 EAGLE RIDGE JUNIOR HIGH Junior High School (Grades 7-8 or 7-9) Regular School No 2 07 09 2016   grade_7 117 36 43   1 21     1   16   117 118     29.0   2.0     91.0   30.0   235 117 36 43   1 21     1   16   117 118     29 2   91 30   235
866681 MN Dakota 19 school 2707290 191 Independent Districts and Schools BURNSVILLE PUBLIC SCHOOL DISTRICT 270729000297 85 NICOLLET JUNIOR HIGH Junior High School (Grades 7-8 or 7-9) Regular School No 2 07 09 2016   grade_7 23 6 3   1 3     0   5   18 23     1.0   0.0     13.0   9.0   41 23 6 3   1 3     0   5   18 23     1 0   13 9   41
855980 MN Dakota 19 school 2711820 192 Independent Districts and Schools FARMINGTON PUBLIC SCHOOL DISTRICT 271182004816 155 Gateway Academy Elementary School (Grades PK-6) Regular School No 1 03 07 2016   grade_7 16 0 1   0 0     0   1   10 8     0.0   0.0     2.0   3.0   18 16 0 1   0 0     0   1   10 8     0 0   2 3   18
862023 MN Dakota 19 school 2711820 192 Independent Districts and Schools FARMINGTON PUBLIC SCHOOL DISTRICT 271182000570 30 LEVI P. DODGE MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No 2 06 08 2016   grade_7 210 7 17   2 12     0   6   127 127     4.0   *     47.0   33.0   254 210 7 17   2 12     0   6   127 127     4     47 33   254
862027 MN Dakota 19 school 2711820 192 Independent Districts and Schools FARMINGTON PUBLIC SCHOOL DISTRICT 271182002983 60 ROBERT BOECKMAN MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No 2 06 08 2016   grade_7 246 8 11   2 19     0   7   156 137     6.0   *     58.0   48.0   293 246 8 11   2 19     0   7   156 137     6     58 48   293
862031 MN Dakota 19 school 2717780 194 Independent Districts and Schools LAKEVILLE PUBLIC SCHOOL DISTRICT 271778002435 89 MCGUIRE MIDDLE Middle School (Grades 5-8) Regular School No 2 06 08 2016   grade_7 275 4 12   0 10     0   16   164 153     1.0   2.0     38.0   41.0   317 275 4 12   0 10     0   16   164 153     1 2   38 41   317
862035 MN Dakota 19 school 2717780 194 Independent Districts and Schools LAKEVILLE PUBLIC SCHOOL DISTRICT 271778000483 104 KENWOOD TRAIL MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No 2 06 08 2016   grade_7 181 19 15   0 16     0   7   128 110     12.0   0.0     41.0   37.0   238 181 19 15   0 16     0   7   128 110     12 0   41 37   238
862039 MN Dakota 19 school 2717780 194 Independent Districts and Schools LAKEVILLE PUBLIC SCHOOL DISTRICT 271778002984 105 CENTURY MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No 2 06 08 2016   grade_7 252 7 4   1 17     1   9   141 150         0.0     19.0   32.0   291 252 7 4   1 17     1   9   141 150       0   19 32   291
864056 MN Dakota 19 school 2717780 194 Independent Districts and Schools LAKEVILLE PUBLIC SCHOOL DISTRICT 271778002804 590 LAKEVILLE AREA LEARNING CENTER Public Area Learning Center ALC (State approved) Alternative Education School No 4 06 12 2016   grade_7 2 1 0   0 0     0   0   2 1         *         *   3 2 1 0   0 0     0   0   2 1                 3
866106 MN Dakota 19 school 2717780 194 Independent Districts and Schools LAKEVILLE PUBLIC SCHOOL DISTRICT 271778004309 90 Link12 Lakeville Distance Learning Program OLL (State approved) Regular School No 4 KG 12 2016   grade_7 2 0 1   0 0     0   0   0 3         *         *   3 2 0 1   0 0     0   0   0 3                 3
853591 MN Dakota 19 school 2730150 195 Independent Districts and Schools RANDOLPH PUBLIC SCHOOL DISTRICT 273015001287 20 RANDOLPH SECONDARY Secondary School (Grades 7-12) Regular School No 3 07 12 2016   grade_7 64 0 0   0 0     0   1   27 38     0.0   0.0     14.0   13.0   65 64 0 0   0 0     0   1   27 38     0 0   14 13   65
862043 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239000484 25 DAKOTA HILLS MIDDLE Middle School (Grades 5-8) Regular School No 2 06 08 2016   grade_7 289 12 34   2 47     0   10   214 180     13.0   0.0         *   394 289 12 34   2 47     0   10   214 180     13 0         394
862048 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239002437 32 BLACK HAWK MIDDLE Middle School (Grades 5-8) Regular School No 2 05 08 2016   grade_7 168 56 33   4 35     0   15   152 159     18.0   0.0     107.0   *   311 168 56 33   4 35     0   15   152 159     18 0   107     311
862052 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239001381 39 ROSEMOUNT MIDDLE Middle School (Grades 5-8) Regular School No 2 06 08 2016   grade_7 352 19 16   4 32     0   12   223 212     7.0   *     60.0   59.0   435 352 19 16   4 32     0   12   223 212     7     60 59   435
862056 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239002644 86 FALCON RIDGE MIDDLE Middle School (Grades 5-8) Regular School No 2 06 08 2016   grade_7 234 30 40   0 29     0   12   198 147     18.0   2.0     75.0   53.0   345 234 30 40   0 29     0   12   198 147     18 2   75 53   345
862060 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239001943 93 SCOTT HIGHLANDS MIDDLE Middle School (Grades 5-8) Regular School No 2 06 08 2016   grade_7 229 39 19   1 31     1   19   170 169         2.0     86.0   60.0   339 229 39 19   1 31     1   19   170 169       2   86 60   339
862064 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239001383 98 VALLEY MIDDLE Middle School (Grades 5-8) Regular School No 2 06 08 2016   grade_7 186 63 39   3 16     0   17   174 150     23.0   5.0     128.0   55.0   324 186 63 39   3 16     0   17   174 150     23 5   128 55   324
864749 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239002517 100 DAKOTA RIDGE SCHOOL Special Education Special Education School No 4 KG 12 2016   grade_7 1 2 0   0 2     0   0   3 2         *         *   5 1 2 0   0 2     0   0   3 2                 5

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