Data source: Big Local News · About: Big Local

676 rows where grade = "grade_7", state = "MN" and year = 2017 sorted by white

View and edit SQL

year

  • 2017 · 676

grade

  • grade_7 · 676
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
690309 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124004903 390 Heritage STEM Academy Secondary School (Grades 7-12) Regular School No Other 06 12 2017   grade_7 0.0 10.0 0.0   0.0 0.0     0.0   0.0   6.0 4.0     7.0   0.0         0.0   10.0 0 10 0   0 0     0   0   6 4     7 0     0   10
690498 MN Ramsey 62 school 2700367 4200 Charter Schools STEP ACADEMY CHARTER SCHOOL 270036704507 10 STEP ACADEMY CHARTER SCHOOL Secondary School (Grades 7-12) Regular School Yes Other 06 12 2017   grade_7 0.0 50.0 0.0   0.0 0.0     0.0   0.0   25.0 25.0     19.0   0.0         1.0   50.0 0 50 0   0 0     0   0   25 25     19 0     1   50
690534 MN Unknown   school 2700402 4237 Charter Schools Metropolitan Education for Future Employment 270040204836 10 Metropolitan Education for Future Employment Charter Secondary School (Grades 7-12) Regular School Yes Other 06 12 2017   grade_7 0.0 5.0 0.0   0.0 0.0     0.0   0.0   5.0 0.0         *         *   5.0 0 5 0   0 0     0   0   5 0                 5
690899 MN Becker 3 school 2728960 25 Independent Districts and Schools PINE POINT PUBLIC SCHOOL DISTRICT 272896000034 70 PINE POINT ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 08 2017   grade_7 0.0 0.0 0.0   3.0 0.0     0.0   0.0   0.0 3.0         *         *   3.0 0 0 0   3 0     0   0   0 3                 3
690986 MN Beltrami 4 school 2730510 38 Independent Districts and Schools RED LAKE PUBLIC SCHOOL DISTRICT 273051001301 20 PONEMAH ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 08 2017   grade_7 0.0 0.0 0.0   7.0 0.0     0.0   0.0   5.0 2.0         *         *   7.0 0 0 0   7 0     0   0   5 2                 7
696591 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124004239 291 HMONG INTERNATIONAL ACADEMY Elementary School (Grades PK-6) Regular School No Elementary PK 08 2017   grade_7 0.0 26.0 2.0   1.0 32.0     0.0   0.0   28.0 33.0     23.0   4.0     54.0   15.0   61.0 0 26 2   1 32     0   0   28 33     23 4   54 15   61
696638 MN Hennepin 27 school 2700027 4004 Charter Schools CEDAR RIVERSIDE COMMUNITY SCHOOL 270002702340 10 CEDAR RIVERSIDE COMMUNITY SCHOOL Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2017   grade_7 0.0 18.0 1.0   0.0 0.0     0.0   0.0   7.0 12.0     5.0   0.0         3.0   19.0 0 18 1   0 0     0   0   7 12     5 0     3   19
696703 MN Hennepin 27 school 2700117 4017 Charter Schools Minnesota Transitions Charter School 270011703566 17 Banaadir Academy Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2017   grade_7 0.0 31.0 0.0   0.0 0.0     0.0   0.0   14.0 17.0     23.0   *         *   31.0 0 31 0   0 0     0   0   14 17     23           31
696748 MN Ramsey 62 school 2700140 4027 Charter Schools HIGHER GROUND ACADEMY 270014002719 10 HIGHER GROUND ACADEMY Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2017   grade_7 0.0 52.0 0.0   0.0 0.0     0.0   0.0   22.0 30.0     5.0   0.0         2.0   52.0 0 52 0   0 0     0   0   22 30     5 0     2   52
696791 MN Hennepin 27 school 2700159 4038 Charter Schools SOJOURNER TRUTH ACADEMY 270015902954 10 SOJOURNER TRUTH ACADEMY Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2017   grade_7 0.0 33.0 10.0   0.0 0.0     0.0   1.0   18.0 26.0     7.0   0.0         10.0   44.0 0 33 10   0 0     0   1   18 26     7 0     10   44
696869 MN Hennepin 27 school 2700184 4068 Charter Schools EXCELL ACADEMY CHARTER 270018403137 10 EXCELL ACADEMY CHARTER Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2017   grade_7 0.0 26.0 1.0   0.0 0.0     0.0   0.0   16.0 11.0     5.0   2.0         10.0   27.0 0 26 1   0 0     0   0   16 11     5 2     10   27
696879 MN Ramsey 62 school 2700230 4070 Charter Schools HOPE COMMUNITY ACADEMY 270023003482 10 HOPE COMMUNITY ACADEMY Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2017   grade_7 0.0 3.0 1.0   0.0 45.0     0.0   0.0   19.0 30.0     16.0   0.0     37.0   6.0   49.0 0 3 1   0 45     0   0   19 30     16 0   37 6   49
696980 MN Ramsey 62 school 2700342 4103 Charter Schools HMONG COLLEGE PREP ACADEMY 270034203700 20 HMONG COLLEGE PREP MIDDLE ACADEMY Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2017   grade_7 0.0 2.0 0.0   0.0 139.0     0.0   0.0   84.0 57.0     31.0   2.0     119.0   14.0   141.0 0 2 0   0 139     0   0   84 57     31 2   119 14   141
697082 MN Hennepin 27 school 2700273 4139 Charter Schools LOVEWORKS ACADEMY FOR ARTS 270027303575 10 LOVEWORKS ACADEMY FOR ARTS Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2017   grade_7 0.0 21.0 2.0   0.0 0.0     0.0   0.0   11.0 12.0     0.0   3.0     20.0   5.0   23.0 0 21 2   0 0     0   0   11 12     0 3   20 5   23
697112 MN Hennepin 27 school 2700253 4143 Charter Schools NEW MILLENNIUM ACADEMY CHARTER SCH 270025303311 10 New Millenium Academy Charter School Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2017   grade_7 0.0 1.0 1.0   0.0 49.0     0.0   1.0   22.0 30.0     40.0   0.0         4.0   52.0 0 1 1   0 49     0   1   22 30     40 0     4   52
697147 MN Ramsey 62 school 2700263 4153 Charter Schools DUGSI ACADEMY 270026303320 10 DUGSI ACADEMY Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2017   grade_7 0.0 39.0 0.0   0.0 0.0     0.0   0.0   19.0 20.0         0.0         0.0   39.0 0 39 0   0 0     0   0   19 20       0     0   39
697230 MN Hennepin 27 school 2700295 4171 Charter Schools NOBLE ACADEMY 270029503727 10 NOBLE ACADEMY Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2017   grade_7 0.0 14.0 0.0   0.0 65.0     0.0   0.0   44.0 35.0     32.0   0.0     53.0   1.0   79.0 0 14 0   0 65     0   0   44 35     32 0   53 1   79
697248 MN Ramsey 62 school 2700304 4181 Charter Schools COMMUNITY SCHOOL OF EXCELLENCE 270030403728 10 COMMUNITY SCHOOL OF EXCELLENCE Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2017   grade_7 0.0 0.0 0.0   0.0 84.0     0.0   0.0   51.0 33.0     51.0   0.0     68.0   9.0   84.0 0 0 0   0 84     0   0   51 33     51 0   68 9   84
697316 MN Hennepin 27 school 2700309 4192 Charter Schools BEST ACADEMY 270030904261 10 Best Academy East at Olson Elementary School (Grades PK-6) Regular School Yes Elementary KG 07 2017   grade_7 0.0 30.0 0.0   0.0 0.0     0.0   0.0   14.0 16.0     17.0   2.0     26.0   0.0   30.0 0 30 0   0 0     0   0   14 16     17 2   26 0   30
697409 MN Ramsey 62 school 2700386 4215 Charter Schools Sejong Academy of Minnesota 270038604695 10 Sejong Academy of Minnesota Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2017   grade_7 0.0 1.0 0.0   0.0 8.0     0.0   0.0   3.0 6.0         *         *   9.0 0 1 0   0 8     0   0   3 6                 9
697463 MN Ramsey 62 school 2700393 4225 Charter Schools Universal Academy Charter School 270039304758 10 Universal Academy Charter School Elementary School (Grades PK-6) Regular School Yes Elementary KG 07 2017   grade_7 0.0 20.0 0.0   0.0 2.0     0.0   0.0   4.0 18.0         0.0         0.0   22.0 0 20 0   0 2     0   0   4 18       0     0   22
697739 MN Beltrami 4 school 2730510 38 Independent Districts and Schools RED LAKE PUBLIC SCHOOL DISTRICT 273051002427 40 Red Lake Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_7 0.0 0.0 0.0   70.0 0.0     0.0   0.0   40.0 30.0     0.0   11.0         14.0   70.0 0 0 0   70 0     0   0   40 30     0 11     14   70
698530 MN Ramsey 62 school 2700142 4029 Charter Schools ST. PAUL CITY SCHOOL 270014204150 20 ST. PAUL CITY MIDDLE SCHOOL Middle School (Grades 5-8) Regular School Yes Middle 06 08 2017   grade_7 0.0 12.0 18.0   2.0 13.0     0.0   0.0   22.0 23.0     24.0   0.0         5.0   45.0 0 12 18   2 13     0   0   22 23     24 0     5   45
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
698570 MN Hennepin 27 school 2700240 4126 Charter Schools PRAIRIE SEEDS ACADEMY 270024004805 30 Prairie Seeds Middle School Academy Middle School (Grades 5-8) Regular School Yes Middle 06 08 2017   grade_7 0.0 13.0 10.0   0.0 35.0     0.0   0.0   33.0 25.0     19.0   4.0     48.0   5.0   58.0 0 13 10   0 35     0   0   33 25     19 4   48 5   58
698575 MN Hennepin 27 school 2700245 4131 Charter Schools METRO SCHOOLS CHARTER 270024504857 20 Metro Schools Middle Charter Middle School (Grades 5-8) Regular School Yes Middle 05 08 2017   grade_7 0.0 25.0 0.0   0.0 0.0     0.0   0.0   14.0 11.0         0.0         2.0   25.0 0 25 0   0 0     0   0   14 11       0     2   25
698591 MN Hennepin 27 school 2700288 4170 Charter Schools HIAWATHA ACADEMIES 270028804599 11 Hiawatha College Prep - Kingfield Middle School (Grades 5-8) Regular School Yes Middle 05 08 2017   grade_7 0.0 5.0 83.0   2.0 0.0     0.0   0.0   43.0 47.0     40.0   11.0         6.0   90.0 0 5 83   2 0     0   0   43 47     40 11     6   90
698606 MN Hennepin 27 school 2700309 4192 Charter Schools BEST ACADEMY 270030904773 20 Best Academy K-8 at Penn Middle School (Grades 5-8) Regular School Yes Elementary KG 08 2017   grade_7 0.0 56.0 1.0   0.0 0.0     0.0   1.0   31.0 27.0     2.0   0.0     51.0   14.0   58.0 0 56 1   0 0     0   1   31 27     2 0   51 14   58
699576 MN Ramsey 62 school 2700152 4031 Charter Schools Jennings Community School 270015202947 10 JENNINGS EXPERIENTIAL HIGH SCHOOL Senior High School (Grades 9-12) Regular School Yes High 07 12 2017   grade_7 0.0 0.0 0.0   0.0 1.0     0.0   0.0   0.0 1.0         *         *   1.0 0 0 0   0 1     0   0   0 1                 1
699791 MN Beltrami 4 school 2730510 38 Independent Districts and Schools RED LAKE PUBLIC SCHOOL DISTRICT 273051002793 50 RED LAKE MIDDLE LEVEL ALC Public Area Learning Center ALC (State approved) Alternative School No Middle 06 08 2017   grade_7 0.0 0.0 0.0   3.0 0.0     0.0   0.0   2.0 1.0         *         *   3.0 0 0 0   3 0     0   0   2 1                 3
699833 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 School No High 07 12 2017   grade_7 0.0 0.0 0.0   4.0 0.0     0.0   0.0   3.0 1.0         *         *   4.0 0 0 0   4 0     0   0   3 1                 4
700031 MN Nobles 53 school 2744160 518 Independent Districts and Schools WORTHINGTON PUBLIC SCHOOL DISTRICT 274416002335 6 WORTHINGTON AREA LEARNING CENTER Public Area Learning Center ALC (State approved) Alternative School No High 07 12 2017   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
700223 MN Isanti 30 school 2707410 911 Independent Districts and Schools CAMBRIDGE-ISANTI PUBLIC SCHOOL DIST 270741005021 385 Riverside Academy MLP Public Area Learning Center ALC (State approved) Alternative School No Middle 06 08 2017   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
700428 MN Koochiching 36 school 2700224 6076 Miscellaneous Cooperatives NORTHLAND LEARNING CENTER 270022404905 15 ISD 361 - ALC Program Public Area Learning Center ALC (State approved) Alternative School No Other 06 12 2017   grade_7 0.0 0.0 0.0   1.0 0.0     0.0   0.0   0.0 1.0         *         *   1.0 0 0 0   1 0     0   0   0 1                 1
700578 MN Hennepin 27 school 2705790 271 Independent Districts and Schools BLOOMINGTON PUBLIC SCHOOL DISTRICT 270579004809 503 SUN Center Special Education Special Education School No Elementary KG 08 2017   grade_7 0.0 0.0 0.0   0.0 0.0     0.0   1.0   1.0 0.0         *         *   1.0 0 0 0   0 0     0   1   1 0                 1
700999 MN Hennepin 27 school 2700025 287 Intermediate Districts and Schools INTERMEDIATE SCHOOL DISTRICT 287 270002503213 440 OPTIONS MID/ELEM EBD Special Education Special Education School No Other KG 09 2017   grade_7 0.0 3.0 0.0   0.0 0.0     0.0   0.0   2.0 1.0         *         *   3.0 0 3 0   0 0     0   0   2 1                 3
701007 MN Hennepin 27 school 2700025 287 Intermediate Districts and Schools INTERMEDIATE SCHOOL DISTRICT 287 270002503216 453 EXPLORE Special Education Special Education School No Other 05 12 2017   grade_7 0.0 3.0 0.0   0.0 0.0     0.0   2.0   5.0 0.0         *         *   5.0 0 3 0   0 0     0   2   5 0                 5
701311 MN Mower 50 school 2700327 6083 Special Education Cooperatives SOUTHERN MN EDUCATION CONSORTIUM 270032704983 10 Enrich Program Special Education Special Education School No Other KG 12 2017   grade_7 0.0 1.0 1.0   0.0 0.0     0.0   0.0   2.0 0.0         *         *   2.0 0 1 1   0 0     0   0   2 0                 2
701483 MN Otter Tail 56 school 2700014 6004 Education Districts FRESHWATER ED. DIST. 270001403297 40 WHITE PINE ACADEMY Special Education Special Education School No Other 05 12 2017   grade_7 0.0 0.0 1.0   0.0 0.0     0.0   0.0   1.0 0.0         *         *   1.0 0 0 1   0 0     0   0   1 0                 1
701943 MN Beltrami 4 school 2704440 31 Independent Districts and Schools BEMIDJI PUBLIC SCHOOL DISTRICT 270444000313 160 FIRST CITY SCHOOL Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No Other 03 12 2017   grade_7 0.0 0.0 0.0   1.0 0.0     0.0   0.0   0.0 1.0         *         *   1.0 0 0 0   1 0     0   0   0 1                 1
702047 MN Polk 60 school 2709720 593 Independent Districts and Schools CROOKSTON PUBLIC SCHOOL DISTRICT 270972001030 100 Northern Lights Academy Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No Other 06 12 2017   grade_7 0.0 0.0 0.0   1.0 0.0     0.0   0.0   1.0 0.0         *         *   1.0 0 0 0   1 0     0   0   1 0                 1
702065 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384001334 678 JUVENILE SERVICE CENTER Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No Other 02 12 2017   grade_7 0.0 1.0 0.0   0.0 0.0     0.0   0.0   0.0 1.0         *         *   1.0 0 1 0   0 0     0   0   0 1                 1
702103 MN Saint Louis 69 school 2711040 709 Independent Districts and Schools DULUTH PUBLIC SCHOOL DISTRICT 271104001577 580 WOODLAND HILLS ACADEMY Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No Other 06 12 2017   grade_7 0.0 1.0 0.0   1.0 0.0     0.0   0.0   2.0 0.0         *         *   2.0 0 1 0   1 0     0   0   2 0                 2
702132 MN Stearns 73 school 2733510 742 Independent Districts and Schools ST. CLOUD PUBLIC SCHOOL DISTRICT 273351004650 73 Riverwoods School - Residential Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No Other KG 12 2017   grade_7 0.0 0.0 1.0   0.0 0.0     0.0   0.0   0.0 1.0         *         *   1.0 0 0 1   0 0     0   0   0 1                 1
702139 MN Swift 76 school 2704470 777 Independent Districts and Schools BENSON PUBLIC SCHOOL DISTRICT 270447004182 110 Heartland Girls Ranch Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No High 07 12 2017   grade_7 0.0 0.0 0.0   1.0 0.0     0.0   1.0   0.0 2.0         *         *   2.0 0 0 0   1 0     0   1   0 2                 2
702374 MN Ramsey 62 school 2722950 621 Independent Districts and Schools MOUNDS VIEW PUBLIC SCHOOL DISTRICT 272295004678 45 Options Educational Oversight to Public Care and Treatment Day Program Alternative School No Other 06 12 2017   grade_7 0.0 0.0 1.0   0.0 0.0     0.0   0.0   0.0 1.0         *         *   1.0 0 0 1   0 0     0   0   0 1                 1
702661 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124001903 361 CENTER SCHOOL Private Alternative Program Alternative School No High 07 12 2017   grade_7 0.0 0.0 0.0   1.0 0.0     0.0   0.0   1.0 0.0         *         *   1.0 0 0 0   1 0     0   0   1 0                 1
702760 MN Aitkin 1 school 2700300 4177 Charter Schools MINISINAAKWAANG LEADERSHIP ACADEMY 270030003730 10 MINISINAAKWAANG LEADERSHIP ACADEMY Elementary/Secondary Combined (Grades K-12 limited to District Type 34 Bureau of Indian Education) Regular School Yes Other KG 12 2017   grade_7 0.0 0.0 0.0   2.0 0.0     0.0   0.0   0.0 2.0         *         *   2.0 0 0 0   2 0     0   0   0 2                 2
690344 MN Hennepin 27 school 2700117 4017 Charter Schools Minnesota Transitions Charter School 270011703262 12 MTS HIGH SCHOOL Secondary School (Grades 7-12) Regular School Yes High 07 12 2017   grade_7 1.0 8.0 5.0   0.0 0.0     0.0   1.0   7.0 8.0         3.0         *   15.0 1 8 5   0 0     0   1   7 8       3         15
690512 MN Kandiyohi 34 school 2700389 4217 Charter Schools TECHNICAL ACADEMIES OF MINNESOTA 270038904696 10 DREAM Technical Academy Secondary School (Grades 7-12) Regular School Yes High 07 12 2017   grade_7 1.0 0.0 1.0   0.0 0.0     0.0   1.0   1.0 2.0         *         *   3.0 1 0 1   0 0     0   1   1 2                 3
696479 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124000932 190 ANDERSEN COMMUNITY Elementary School (Grades PK-6) Regular School No Elementary PK 08 2017   grade_7 1.0 40.0 65.0   5.0 2.0     0.0   0.0   65.0 48.0     75.0   11.0         26.0   113.0 1 40 65   5 2     0   0   65 48     75 11     26   113
696490 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124002297 193 SULLIVAN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 08 2017   grade_7 1.0 68.0 4.0   2.0 1.0     0.0   1.0   48.0 29.0     48.0   3.0         9.0   77.0 1 68 4   2 1     0   1   48 29     48 3     9   77
696512 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124004172 225 ANISHINABE ACADEMY Elementary School (Grades PK-6) Regular School No Elementary PK 08 2017   grade_7 1.0 2.0 2.0   23.0 0.0     0.0   2.0   13.0 17.0     0.0   6.0     26.0   5.0   30.0 1 2 2   23 0     0   2   13 17     0 6   26 5   30
697058 MN Olmsted 55 school 2700247 4135 Charter Schools ROCHESTER MATH AND SCIENCE ACADEMY 270024703308 10 ROCHESTER MATH AND SCIENCE ACADEMY Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2017   grade_7 1.0 43.0 0.0   0.0 0.0     0.0   0.0   24.0 20.0     15.0   0.0         2.0   44.0 1 43 0   0 0     0   0   24 20     15 0     2   44
697503 MN Ramsey 62 school 2700399 4231 Charter Schools Minnesota Math and Science Academy 270039904788 10 Minnesota Math and Science Academy Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2017   grade_7 1.0 47.0 1.0   0.0 3.0     0.0   0.0   23.0 29.0     27.0   0.0         2.0   52.0 1 47 1   0 3     0   0   23 29     27 0     2   52
698553 MN Hennepin 27 school 2700189 4078 Charter Schools Minnesota International Middle Charter 270018903142 10 Minnesota International Middle Charter School Middle School (Grades 5-8) Regular School Yes Middle 05 08 2017   grade_7 1.0 109.0 0.0   0.0 0.0     0.0   0.0   54.0 56.0     46.0   0.0         5.0   110.0 1 109 0   0 0     0   0   54 56     46 0     5   110
698561 MN Beltrami 4 school 2700346 4107 Charter Schools VOYAGEURS EXPEDITIONARY 270034604667 20 Voyageurs Expeditionary MS Middle School (Grades 5-8) Regular School Yes Middle 06 08 2017   grade_7 1.0 0.0 0.0   15.0 0.0     0.0   0.0   6.0 10.0     0.0   0.0         2.0   16.0 1 0 0   15 0     0   0   6 10     0 0     2   16
698596 MN Hennepin 27 school 2700308 4191 Charter Schools KIPP MINNESOTA CHARTER SCHOOL 270030804244 10 KIPP MINNESOTA CHARTER SCHOOL Middle School (Grades 5-8) Regular School Yes Middle 05 08 2017   grade_7 1.0 50.0 0.0   0.0 0.0     0.0   0.0   18.0 33.0     0.0   1.0         11.0   51.0 1 50 0   0 0     0   0   18 33     0 1     11   51
700355 MN Wadena 80 school 2700014 6004 Education Districts FRESHWATER ED. DIST. 270001402222 20 FRESHWATER ED. DIST. ALC Public Area Learning Center ALC (State approved) Alternative School No Other 06 12 2017   grade_7 1.0 0.0 0.0   0.0 0.0     0.0   0.0   1.0 0.0         *         *   1.0 1 0 0   0 0     0   0   1 0                 1
700363 MN Olmsted 55 school 2700054 6012 Education Districts ZUMBRO EDUCATION DISTRICT 270005402492 20 ZUMBRO AREA LEARNING CENTER Public Area Learning Center ALC (State approved) Alternative School No Other 06 12 2017   grade_7 1.0 0.0 0.0   0.0 0.0     0.0   0.0   1.0 0.0         *         *   1.0 1 0 0   0 0     0   0   1 0                 1
700420 MN Saint Louis 69 school 2700224 6076 Miscellaneous Cooperatives NORTHLAND LEARNING CENTER 270022403477 10 NORTHLAND LEARNING CENTER 010 Public Area Learning Center ALC (State approved) Alternative School No Other PK 12 2017   grade_7 1.0 1.0 0.0   0.0 0.0     0.0   0.0   0.0 2.0         *         *   2.0 1 1 0   0 0     0   0   0 2                 2
700488 MN Blue Earth 7 school 2718780 77 Independent Districts and Schools MANKATO PUBLIC SCHOOL DISTRICT 271878004374 370 FUTURES PROGRAM Special Education Special Education School No Other KG 12 2017   grade_7 1.0 0.0 1.0   0.0 0.0     0.0   0.0   2.0 0.0         *         *   2.0 1 0 1   0 0     0   0   2 0                 2
700568 MN Hennepin 27 school 2714260 270 Independent Districts and Schools HOPKINS PUBLIC SCHOOL DISTRICT 271426005032 611 SENOPS Special Education Special Education School No Other KG 12 2017   grade_7 1.0 0.0 0.0   0.0 0.0     0.0   0.0   1.0 0.0         *         *   1.0 1 0 0   0 0     0   0   1 0                 1
700603 MN Hennepin 27 school 2725200 279 Independent Districts and Schools OSSEO PUBLIC SCHOOL DISTRICT 272520003593 45 ACHIEVE Special Education Special Education School No Other KG 12 2017   grade_7 1.0 1.0 0.0   0.0 0.0     0.0   1.0   2.0 1.0         *         *   3.0 1 1 0   0 0     0   1   2 1                 3
700731 MN Ramsey 62 school 2723850 622 Independent Districts and Schools North St Paul-Maplewood Oakdale Public School District 272385003374 41 Harmony Learning Center Special Education Special Education School No Other KG 12 2017   grade_7 1.0 0.0 0.0   0.0 0.0     0.0   0.0   0.0 1.0         *         *   1.0 1 0 0   0 0     0   0   0 1                 1
700770 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384004275 607 RIVEREAST PROGRAM Special Education Special Education School No Elementary KG 08 2017   grade_7 1.0 3.0 2.0   0.0 0.0     0.0   2.0   7.0 1.0         *         *   8.0 1 3 2   0 0     0   2   7 1                 8
700819 MN Saint Louis 69 school 2711040 709 Independent Districts and Schools DULUTH PUBLIC SCHOOL DISTRICT 271104002554 610 SPECIAL ED. N.P. Special Education Special Education School No Other PK 12 2017   grade_7 1.0 0.0 0.0   0.0 0.0     0.0   0.0   0.0 1.0         *         *   1.0 1 0 0   0 0     0   0   0 1                 1
700907 MN Chisago 13 school 2700017 2144 Independent Districts and Schools CHISAGO LAKES SCHOOL DISTRICT 270001703386 10 LEVEL 4 PROGRAM PATHWAYS TO CHANGE Special Education Special Education School No Other KG 12 2017   grade_7 1.0 0.0 0.0   0.0 0.0     0.0   0.0   1.0 0.0         *         *   1.0 1 0 0   0 0     0   0   1 0                 1
700941 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124003022 625 RIVER BEND EDUCATIONAL CENTER Special Education Special Education School No Other KG 12 2017   grade_7 1.0 12.0 0.0   0.0 0.0     0.0   0.0   10.0 3.0     0.0   3.0         *   13.0 1 12 0   0 0     0   0   10 3     0 3         13
701035 MN Hennepin 27 school 2700025 287 Intermediate Districts and Schools INTERMEDIATE SCHOOL DISTRICT 287 270002503542 479 SAFE Special Education Special Education School No Other 01 12 2017   grade_7 1.0 0.0 0.0   0.0 0.0     0.0   0.0   1.0 0.0         *         *   1.0 1 0 0   0 0     0   0   1 0                 1
701047 MN Hennepin 27 school 2700025 287 Intermediate Districts and Schools INTERMEDIATE SCHOOL DISTRICT 287 270002503229 480 STRIVE SECONDARY Special Education Special Education School No Other 01 12 2017   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
701095 MN Ramsey 62 school 2702264 916 Intermediate Districts and Schools NORTHEAST METRO 916 270226402093 36 ALP @ CAPITOL VIEW CENTER Special Education Special Education School No Other 05 12 2017   grade_7 1.0 1.0 2.0   0.0 0.0     0.0   0.0   3.0 1.0         *         *   4.0 1 1 2   0 0     0   0   3 1                 4
701133 MN Ramsey 62 school 2702264 916 Intermediate Districts and Schools NORTHEAST METRO 916 270226402108 56 SOUTH CAMPUS 916 Special Education Special Education School No Other 05 12 2017   grade_7 1.0 1.0 1.0   0.0 0.0     0.0   0.0   3.0 0.0         *         *   3.0 1 1 1   0 0     0   0   3 0                 3
701152 MN Dakota 19 school 2700026 917 Intermediate Districts and Schools INTERMEDIATE SCHOOL DISTRICT 917 270002602121 51 917 INTRA-DAKOTA EDUCATIONAL ALT Special Education Special Education School No Other KG 12 2017   grade_7 1.0 1.0 0.0   0.0 0.0     0.0   0.0   2.0 0.0         *         *   2.0 1 1 0   0 0     0   0   2 0                 2
701248 MN Martin 46 school 2700046 915 Special Education Cooperatives SOUTHERN PLAINS EDUCATION COOP. 270004603691 70 POSITIVE APPROACH TO LEARNING Special Education Special Education School No Other KG 12 2017   grade_7 1.0 0.0 0.0   0.0 0.0     0.0   0.0   1.0 0.0         *         *   1.0 1 0 0   0 0     0   0   1 0                 1
701258 MN Otter Tail 56 school 2700043 935 Special Education Cooperatives FERGUS FALLS AREA SP. ED. COOP. 270004304316 14 FERGUS FALLS ELEMENTARY SP ED 5-8 Special Education Special Education School No Middle 05 08 2017   grade_7 1.0 0.0 0.0   0.0 0.0     0.0   0.0   1.0 0.0         *         *   1.0 1 0 0   0 0     0   0   1 0                 1
701265 MN Wright 86 school 2700045 938 Special Education Cooperatives MEEKER AND WRIGHT SPECIAL EDUCATION 270004504402 10 TREK PROGRAM Special Education Special Education School No Other KG 12 2017   grade_7 1.0 0.0 0.0   0.0 0.0     0.0   0.0   0.0 1.0         *         *   1.0 1 0 0   0 0     0   0   0 1                 1
701285 MN Wright 86 school 2700045 938 Special Education Cooperatives MEEKER AND WRIGHT SPECIAL EDUCATION 270004504351 17 JOURNEYS ALTERNATIVE PROGRAM Special Education Special Education School No Elementary KG 08 2017   grade_7 1.0 0.0 0.0   0.0 0.0     0.0   0.0   0.0 1.0         *         *   1.0 1 0 0   0 0     0   0   0 1                 1
701385 MN Mower 50 school 2700426 6095 Special Education Cooperatives Austin Albert Lea Area Special Education Cooperative (AALASEC) 270042605016 550 Oakland Education Center Special Education Special Education School No Other KG 12 2017   grade_7 1.0 0.0 1.0   0.0 0.0     0.0   0.0   2.0 0.0         *         *   2.0 1 0 1   0 0     0   0   2 0                 2
701447 MN Kandiyohi 34 school 2700086 991 Service Cooperative (ECSU Region) Region 6 and 8-SW/WC Service Cooperative 270008604724 47 North Central Learning Center Special Education Special Education School No Other KG 12 2017   grade_7 1.0 2.0 0.0   0.0 0.0     0.0   0.0   2.0 1.0         *         *   3.0 1 2 0   0 0     0   0   2 1                 3
701476 MN Ramsey 62 school 2700315 4183 Charter Schools LIONSGATE ACADEMY 270031504868 40 Lionsgate Academy - Lynx Program Special Education Special Education School Yes High 07 12 2017   grade_7 1.0 0.0 0.0   0.0 0.0     0.0   0.0   1.0 0.0         *         *   1.0 1 0 0   0 0     0   0   1 0                 1
701492 MN Otter Tail 56 school 2700014 6004 Education Districts FRESHWATER ED. DIST. 270001404821 50 Elm Tree Academy Special Education Special Education School No Other 02 12 2017   grade_7 1.0 0.0 0.0   0.0 0.0     0.0   0.0   1.0 0.0         *         *   1.0 1 0 0   0 0     0   0   1 0                 1
701547 MN Stearns 73 school 2791455 6026 Education Districts WEST CENTRAL EDUCATION DISTRICT 279145503591 24 BEACON PROGRAM W CENTRAL ED. DIST. Special Education Special Education School No Other 01 11 2017   grade_7 1.0 0.0 0.0   0.0 0.0     0.0   0.0   1.0 0.0         *         *   1.0 1 0 0   0 0     0   0   1 0                 1
701627 MN Mille Lacs 48 school 2700073 6979 Education Districts MID STATE EDUCATION DISTRICT 270007304436 40 MID-STATE NORTH Special Education Special Education School No High 07 12 2017   grade_7 1.0 0.0 0.0   2.0 0.0     0.0   1.0   4.0 0.0         *         *   4.0 1 0 0   2 0     0   1   4 0                 4
701669 MN Kandiyohi 34 school 2742720 347 Independent Districts and Schools WILLMAR PUBLIC SCHOOL DISTRICT 274272000949 899 LAKEVIEW SCHOOL Hospital/Medical/Partial Hospitalization Program Alternative School No Other KG 12 2017   grade_7 1.0 0.0 0.0   0.0 0.0     0.0   0.0   1.0 0.0         *         *   1.0 1 0 0   0 0     0   0   1 0                 1
701698 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124001935 688 MPS METRO HA Hospital/Medical/Partial Hospitalization Program Alternative School No Other KG 12 2017   grade_7 1.0 1.0 0.0   0.0 0.0     0.0   0.0   1.0 1.0         *         *   2.0 1 1 0   0 0     0   0   1 1                 2
701730 MN Hennepin 27 school 2700025 287 Intermediate Districts and Schools INTERMEDIATE SCHOOL DISTRICT 287 270002504467 532 PRAIRIE CARE EDINA - PHP Hospital/Medical/Partial Hospitalization Program Alternative School No Other KG 12 2017   grade_7 1.0 0.0 0.0   0.0 0.0     0.0   0.0   1.0 0.0         *         *   1.0 1 0 0   0 0     0   0   1 0                 1
701756 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 Other KG 12 2017   grade_7 1.0 0.0 0.0   0.0 0.0     0.0   0.0   0.0 1.0         *         *   1.0 1 0 0   0 0     0   0   0 1                 1
701930 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 School No Other 06 12 2017   grade_7 1.0 0.0 0.0   0.0 0.0     0.0   0.0   0.0 1.0         *         *   1.0 1 0 0   0 0     0   0   0 1                 1
701955 MN Cass 11 school 2730870 118 Independent Districts and Schools NORTHLAND COMMUNITY SCHOOLS 273087003507 40 LITTLE SAND Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No High 07 12 2017   grade_7 1.0 0.0 0.0   0.0 0.0     0.0   0.0   0.0 1.0         *         *   1.0 1 0 0   0 0     0   0   0 1                 1
702004 MN Kandiyohi 34 school 2742720 347 Independent Districts and Schools WILLMAR PUBLIC SCHOOL DISTRICT 274272004673 931 Prairie Lakes Education Center Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No Other 04 12 2017   grade_7 1.0 0.0 0.0   0.0 0.0     0.0   0.0   1.0 0.0         *         *   1.0 1 0 0   0 0     0   0   1 0                 1
702111 MN Saint Louis 69 school 2711040 709 Independent Districts and Schools DULUTH PUBLIC SCHOOL DISTRICT 271104001589 605 ARROWHEAD JUVENILE CENTER Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No Other 04 12 2017   grade_7 1.0 0.0 0.0   0.0 0.0     0.0   0.0   1.0 0.0         *         *   1.0 1 0 0   0 0     0   0   1 0                 1
702124 MN Stearns 73 school 2733510 742 Independent Districts and Schools ST. CLOUD PUBLIC SCHOOL DISTRICT 273351004649 67 St Cloud Hospital Progs-Residential Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No Other KG 12 2017   grade_7 1.0 0.0 0.0   0.0 0.0     0.0   0.0   0.0 1.0         *         *   1.0 1 0 0   0 0     0   0   0 1                 1
702170 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124001936 689 MPS METRO SJ Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No Other KG 12 2017   grade_7 1.0 3.0 0.0   0.0 0.0     0.0   0.0   2.0 2.0         *         *   4.0 1 3 0   0 0     0   0   2 2                 4
702203 MN Scott 70 school 2700420 288 Intermediate Districts and Schools Southwest Metro Intermediate 288 270042004999 34 SW Metro Day Treatment Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No Other 06 12 2017   grade_7 1.0 0.0 0.0   0.0 0.0     0.0   0.0   0.0 1.0         *         *   1.0 1 0 0   0 0     0   0   0 1                 1
702256 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 School No Other KG 12 2017   grade_7 1.0 6.0 0.0   0.0 0.0     0.0   0.0   7.0 0.0         *         *   7.0 1 6 0   0 0     0   0   7 0                 7
702266 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 School No Other 02 12 2017   grade_7 1.0 1.0 0.0   1.0 0.0     0.0   1.0   2.0 2.0         *         *   4.0 1 1 0   1 0     0   1   2 2                 4
702406 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384005018 56 LS MNIC Educational Oversight to Public Care and Treatment Day Program Alternative School No Other PK 12 2017   grade_7 1.0 1.0 0.0   0.0 0.0     0.0   0.0   1.0 1.0         *         *   2.0 1 1 0   0 0     0   0   1 1                 2
702423 MN Stearns 73 school 2733510 742 Independent Districts and Schools ST. CLOUD PUBLIC SCHOOL DISTRICT 273351003369 66 ST. CLOUD HOSPITAL PROGRAMS NON-RES Educational Oversight to Public Care and Treatment Day Program Alternative School No Other PK 12 2017   grade_7 1.0 0.0 0.0   0.0 0.0     0.0   0.0   0.0 1.0         *         *   1.0 1 0 0   0 0     0   0   0 1                 1
702469 MN Fillmore 23 school 2700100 2198 Independent Districts and Schools FILLMORE CENTRAL 270010004226 301 ROOT RIVER PROGRAM Educational Oversight to Public Care and Treatment Day Program Alternative School No High 07 12 2017   grade_7 1.0 0.0 0.0   0.0 0.0     0.0   0.0   1.0 0.0         *         *   1.0 1 0 0   0 0     0   0   1 0                 1

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