Data source: Big Local News · About: Big Local

681 rows where grade = "grade_7", state = "MN" and year = 2019 sorted by white

View and edit SQL

year

  • 2019 · 681

grade

  • grade_7 · 681
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
1945662 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 High 06 12 2019   grade_7 0.0 21.0 0.0   0.0 0.0     0.0   1.0   12.0 10.0     11.0   0.0         1.0   22.0 0 21 0   0 0     0   1   12 10     11 0     1   22
1945699 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 2019   grade_7 0.0 33.0 1.0   1.0 0.0     0.0   5.0   20.0 20.0     18.0   6.0         *   40.0 0 33 1   1 0     0   5   20 20     18 6         40
1945851 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 High 06 12 2019   grade_7 0.0 46.0 0.0   0.0 0.0     0.0   0.0   23.0 23.0     21.0   0.0         2.0   46.0 0 46 0   0 0     0   0   23 23     21 0     2   46
1946349 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 2019   grade_7 0.0 0.0 0.0   19.0 0.0     0.0   0.0   13.0 6.0     *   *         *   19.0 0 0 0   19 0     0   0   13 6                 19
1951938 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124000986 179 JEFFERSON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 08 2019   grade_7 0.0 21.0 28.0   0.0 1.0     0.0   1.0   21.0 30.0     29.0   0.0         7.0   51.0 0 21 28   0 1     0   1   21 30     29 0     7   51
1951969 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 2019   grade_7 0.0 48.0 1.0   6.0 1.0     0.0   1.0   30.0 27.0     25.0   4.0         9.0   57.0 0 48 1   6 1     0   1   30 27     25 4     9   57
1952121 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 2019   grade_7 0.0 12.0 3.0   0.0 0.0     0.0   0.0   7.0 8.0     10.0   0.0         1.0   15.0 0 12 3   0 0     0   0   7 8     10 0     1   15
1952228 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 2019   grade_7 0.0 71.0 0.0   0.0 0.0     0.0   0.0   36.0 35.0     10.0   0.0         4.0   71.0 0 71 0   0 0     0   0   36 35     10 0     4   71
1952257 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 2019   grade_7 0.0 39.0 6.0   0.0 0.0     0.0   3.0   25.0 23.0     5.0   3.0         10.0   48.0 0 39 6   0 0     0   3   25 23     5 3     10   48
1952337 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 2019   grade_7 0.0 26.0 2.0   0.0 0.0     0.0   0.0   16.0 12.0     3.0   2.0         6.0   28.0 0 26 2   0 0     0   0   16 12     3 2     6   28
1952359 MN Ramsey 62 school 2700185 4073 Charter Schools Academia Cesar Chavez Charter School 270018503138 10 Academia Cesar Chavez Charter School Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2019   grade_7 0.0 0.0 33.0   0.0 0.0     0.0   2.0   18.0 17.0     *   4.0         8.0   35.0 0 0 33   0 0     0   2   18 17       4     8   35
1952446 MN Ramsey 62 school 2700342 4103 Charter Schools HMONG COLLEGE PREP ACADEMY 270034203700 20 Hmong College Prep Academy MS Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2019   grade_7 0.0 0.0 1.0   0.0 182.0     0.0   0.0   93.0 90.0     53.0   1.0     153.0   19.0   183.0 0 0 1   0 182     0   0   93 90     53 1   153 19   183
1952549 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 PK 08 2019   grade_7 0.0 15.0 1.0   0.0 0.0     0.0   0.0   8.0 8.0     0.0   0.0         5.0   16.0 0 15 1   0 0     0   0   8 8     0 0     5   16
1952577 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 2019   grade_7 0.0 5.0 2.0   0.0 60.0     0.0   0.0   35.0 32.0     23.0   1.0     53.0   9.0   67.0 0 5 2   0 60     0   0   35 32     23 1   53 9   67
1952612 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 2019   grade_7 0.0 32.0 0.0   0.0 0.0     0.0   0.0   17.0 15.0     23.0   0.0         1.0   32.0 0 32 0   0 0     0   0   17 15     23 0     1   32
1952679 MN Hennepin 27 school 2700289 4169 Charter Schools Stonebridge World School 270028903731 10 Stonebridge World School Elementary School (Grades PK-6) Regular School Yes Elementary PK 07 2019   grade_7 0.0 18.0 7.0   1.0 0.0     0.0   1.0   19.0 8.0     3.0   1.0         8.0   27.0 0 18 7   1 0     0   1   19 8     3 1     8   27
1952700 MN Hennepin 27 school 2700295 4171 Charter Schools NOBLE ACADEMY 270029503727 10 NOBLE ACADEMY Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2019   grade_7 0.0 9.0 0.0   0.0 84.0     0.0   0.0   44.0 49.0     36.0   0.0     50.0   11.0   93.0 0 9 0   0 84     0   0   44 49     36 0   50 11   93
1952719 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 PK 08 2019   grade_7 0.0 1.0 0.0   0.0 139.0     0.0   0.0   64.0 76.0     55.0   0.0     125.0   20.0   140.0 0 1 0   0 139     0   0   64 76     55 0   125 20   140
1952789 MN Hennepin 27 school 2700309 4192 Charter Schools BEST ACADEMY 270030904261 10 BEST ACADEMY Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2019   grade_7 0.0 74.0 0.0   0.0 0.0     0.0   3.0   47.0 30.0     19.0   5.0         15.0   77.0 0 74 0   0 0     0   3   47 30     19 5     15   77
1952899 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 2019   grade_7 0.0 2.0 0.0   0.0 20.0     0.0   0.0   11.0 11.0     19.0   1.0         3.0   22.0 0 2 0   0 20     0   0   11 11     19 1     3   22
1952953 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 PK 08 2019   grade_7 0.0 30.0 0.0   0.0 1.0     0.0   0.0   16.0 15.0     *   0.0         3.0   31.0 0 30 0   0 1     0   0   16 15       0     3   31
1952963 MN Hennepin 27 school 2700396 4226 Charter Schools Bdote Learning Center 270039604763 10 Bdote Learning Center Elementary School (Grades PK-6) Regular School Yes Elementary KG 07 2019   grade_7 0.0 0.0 1.0   11.0 0.0     0.0   0.0   7.0 5.0     0.0   8.0         6.0   12.0 0 0 1   11 0     0   0   7 5     0 8     6   12
1953026 MN Ramsey 62 school 2700410 4240 Charter Schools New Century School 270041004873 10 New Century School Elementary School (Grades PK-6) Regular School Yes Elementary KG 07 2019   grade_7 0.0 25.0 0.0   0.0 0.0     0.0   0.0   8.0 17.0     *   0.0         1.0   25.0 0 25 0   0 0     0   0   8 17       0     1   25
1953285 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 2019   grade_7 0.0 0.0 0.0   56.0 0.0     0.0   0.0   29.0 27.0     0.0   5.0     41.0   8.0   56.0 0 0 0   56 0     0   0   29 27     0 5   41 8   56
1954121 MN Hennepin 27 school 2700220 4067 Charter Schools AURORA CHARTER SCHOOL 270022004420 20 AURORA MIDDLE SCHOOL Middle School (Grades 5-8) Regular School Yes Middle 05 08 2019   grade_7 0.0 0.0 45.0   1.0 0.0     0.0   0.0   18.0 28.0     24.0   0.0         9.0   46.0 0 0 45   1 0     0   0   18 28     24 0     9   46
1954133 MN Hennepin 27 school 2700189 4078 Charter Schools Twin Cities International Schools 270018903142 10 Minnesota International Middle Charter School Middle School (Grades 5-8) Regular School Yes Middle 05 08 2019   grade_7 0.0 113.0 0.0   0.0 0.0     0.0   0.0   44.0 69.0     28.0   0.0         8.0   113.0 0 113 0   0 0     0   0   44 69     28 0     8   113
1954159 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 2019   grade_7 0.0 35.0 0.0   0.0 0.0     0.0   0.0   17.0 18.0     20.0   0.0     13.0   3.0   35.0 0 35 0   0 0     0   0   17 18     20 0   13 3   35
1954178 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 2019   grade_7 0.0 9.0 87.0   0.0 0.0     0.0   0.0   42.0 54.0     38.0   1.0     80.0   17.0   96.0 0 9 87   0 0     0   0   42 54     38 1   80 17   96
1954190 MN Unknown   school 2700335 4205 Charter Schools HENNEPIN ELEMENTARY SCHOOL 270033505203 20 Hennepin Middle School Middle School (Grades 5-8) Regular School Yes Middle 05 08 2019   grade_7 0.0 18.0 3.0   0.0 0.0     0.0   0.0   12.0 9.0     7.0   0.0         6.0   21.0 0 18 3   0 0     0   0   12 9     7 0     6   21
1954203 MN Unknown   school 2700399 4231 Charter Schools Minnesota Math and Science Academy 270039905177 20 MMSA Middle School Middle School (Grades 5-8) Regular School Yes Middle 05 08 2019   grade_7 0.0 42.0 0.0   0.0 2.0     0.0   0.0   21.0 23.0     24.0   1.0         3.0   44.0 0 42 0   0 2     0   0   21 23     24 1     3   44
1955381 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 2019   grade_7 0.0 0.0 0.0   5.0 0.0     0.0   0.0   3.0 2.0     *   *         *   5.0 0 0 0   5 0     0   0   3 2                 5
1955418 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 2019   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
1955507 MN Hennepin 27 school 2742160 284 Independent Districts and Schools WAYZATA PUBLIC SCHOOL DISTRICT 274216003740 953 CENTRAL MIDDLE ALTERNATIVE (CMAP) Public Area Learning Center ALC (State approved) Alternative School No Middle 06 08 2019   grade_7 0.0 3.0 0.0   0.0 0.0     0.0   1.0   1.0 3.0     *   *         *   4.0 0 3 0   0 0     0   1   1 3                 4
1955559 MN Mahnomen 44 school 2718660 432 Independent Districts and Schools MAHNOMEN PUBLIC SCHOOL DISTRICT 271866002333 40 MAHNOMEN AREA LEARNING CENTER Public Area Learning Center ALC (State approved) Alternative School No High 06 12 2019   grade_7 0.0 0.0 0.0   1.0 0.0     0.0   2.0   1.0 2.0     *   *         *   3.0 0 0 0   1 0     0   2   1 2                 3
1955790 MN Pine 58 school 2711085 2580 Independent Districts and Schools EAST CENTRAL SCHOOL DISTRICT 271108500222 35 CROSSROADS AREA LEARNING CENTER Public Area Learning Center ALC (State approved) Alternative School No High 07 12 2019   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
1956111 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 2019   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
1956273 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 2019   grade_7 0.0 5.0 1.0   0.0 0.0     0.0   2.0   6.0 2.0     *   *         *   8.0 0 5 1   0 0     0   2   6 2                 8
1956426 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 2019   grade_7 0.0 7.0 0.0   0.0 1.0     0.0   2.0   5.0 5.0     2.0   0.0         *   10.0 0 7 0   0 1     0   2   5 5     2 0         10
1956491 MN Hennepin 27 school 2700025 287 Intermediate Districts and Schools INTERMEDIATE SCHOOL DISTRICT 287 270002503216 453 EXPLORE Special Education Special Education School No High 05 12 2019   grade_7 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     0   1   0 1                 1
1956519 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 2019   grade_7 0.0 2.0 0.0   0.0 0.0     0.0   0.0   2.0 0.0     *   *         *   2.0 0 2 0   0 0     0   0   2 0                 2
1956530 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 2019   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
1956630 MN Dakota 19 school 2700026 917 Intermediate Districts and Schools INTERMEDIATE SCHOOL DISTRICT 917 270002602124 60 Deaf/Hard of Hearing Special Education Special Education School No Other PK 12 2019   grade_7 0.0 1.0 0.0   0.0 0.0     0.0   1.0   2.0 0.0     *   *         *   2.0 0 1 0   0 0     0   1   2 0                 2
1956654 MN Dakota 19 school 2700026 917 Intermediate Districts and Schools INTERMEDIATE SCHOOL DISTRICT 917 270002604218 400 917 SUN Special Education Special Education School No Other KG 12 2019   grade_7 0.0 1.0 1.0   0.0 1.0     0.0   1.0   3.0 1.0     *   *         *   4.0 0 1 1   0 1     0   1   3 1                 4
1956737 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 2019   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
1956837 MN Wright 86 school 2700413 6090 Special Education Cooperatives Sherburne and Northern Wright Special Education Cooperative 270041304909 30 Monticello Middle School - SNW Special Education Special Education School No Middle 06 08 2019   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
1956898 MN Clay 14 school 2700083 926 Service Cooperative (ECSU Region) REGION 4-LAKES COUNTRY SERVICE COOP 270008305101 40 Lakes Country Academy - MHD Special Education Special Education School No Other KG 10 2019   grade_7 0.0 0.0 0.0   2.0 0.0     0.0   0.0   2.0 0.0     *   *         *   2.0 0 0 0   2 0     0   0   2 0                 2
1957106 MN Nicollet 52 school 2700063 6027 Education Districts MN VALLEY EDUCATION DISTRICT 270006302389 10 Minnesota Valley School Special Education Special Education School No Other KG 12 2019   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
1957183 MN Stearns 73 school 2700071 6383 Education Districts BENTON-STEARNS ED. DISTRICT 270007104581 40 BENTON-STEARNS EDUCATION CENTER Special Education Special Education School No High 06 12 2019   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
1957300 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 2019   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
1957528 MN Anoka 2 school 2733540 15 Independent Districts and Schools St. Francis Area Schools 273354005205 856 Crossroads School Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No Other KG 12 2019   grade_7 0.0 0.0 0.0   0.0 1.0     0.0   2.0   3.0 0.0     *   *         *   3.0 0 0 0   0 1     0   2   3 0                 3
1957535 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 2019   grade_7 0.0 0.0 0.0   1.0 0.0     0.0   1.0   1.0 1.0     *   *         *   2.0 0 0 0   1 0     0   1   1 1                 2
1957581 MN Hennepin 27 school 2733780 283 Independent Districts and Schools ST. LOUIS PARK PUBLIC SCHOOL DIST. 273378004332 759 MELROSE Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No Other 01 12 2019   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
1957652 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384004858 54 Brittany's Place Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No Other KG 12 2019   grade_7 0.0 1.0 0.0   1.0 0.0     0.0   0.0   0.0 2.0     *   *         *   2.0 0 1 0   1 0     0   0   0 2                 2
1957706 MN Stearns 73 school 2733510 742 Independent Districts and Schools ST. CLOUD PUBLIC SCHOOL DISTRICT 273351003368 43 ST. CLOUD GROUP HOME Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No High 07 12 2019   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
1957716 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 2019   grade_7 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     0   1   0 1                 1
1957737 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124001933 685 STADIUM VIEW Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No High 06 12 2019   grade_7 0.0 2.0 0.0   0.0 0.0     0.0   0.0   2.0 0.0     *   *         *   2.0 0 2 0   0 0     0   0   2 0                 2
1957785 MN Anoka 2 school 2702264 916 Intermediate Districts and Schools NORTHEAST METRO 916 270226404404 31 THE WILLOWS Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No High 07 12 2019   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
1958037 MN Dakota 19 school 2700026 917 Intermediate Districts and Schools INTERMEDIATE SCHOOL DISTRICT 917 270002604516 300 Options Educational Oversight to Public Care and Treatment Day Program Alternative School No Other 04 12 2019   grade_7 0.0 1.0 0.0   1.0 0.0     0.0   0.0   1.0 1.0     *   *         *   2.0 0 1 0   1 0     0   0   1 1                 2
1958149 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384001489 841 GUADALUPE ALTERNATIVE PROGRAMS Private Alternative Program Alternative School No High 07 12 2019   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
1958175 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 2019   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
1958265 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 2019   grade_7 0.0 0.0 0.0   2.0 0.0     0.0   0.0   1.0 1.0     *   *         *   2.0 0 0 0   2 0     0   0   1 1                 2
1945678 MN Ramsey 62 school 2702264 916 Intermediate Districts and Schools NORTHEAST METRO 916 270226404818 29 Assessment Center Sec Secondary School (Grades 7-12) Regular School No Other KG 12 2019   grade_7 1.0 0.0 0.0   0.0 0.0     0.0   1.0   2.0 0.0     *   *         *   2.0 1 0 0   0 0     0   1   2 0                 2
1945872 MN Steele 74 school 2700389 4217 Charter Schools TECHNICAL ACADEMIES OF MINNESOTA 270038904954 20 CHOICE Technical Academy Secondary School (Grades 7-12) Regular School Yes High 07 12 2019   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
1952347 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 2019   grade_7 1.0 5.0 1.0   0.0 49.0     0.0   0.0   31.0 25.0     19.0   0.0     48.0   8.0   56.0 1 5 1   0 49     0   0   31 25     19 0   48 8   56
1952531 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 2019   grade_7 1.0 38.0 0.0   0.0 0.0     0.0   0.0   16.0 23.0     12.0   0.0     8.0   1.0   39.0 1 38 0   0 0     0   0   16 23     12 0   8 1   39
1952877 MN Ramsey 62 school 2700374 4212 Charter Schools WEST SIDE SUMMIT CHARTER SCHOOL 270037404588 10 WEST SIDE SUMMIT CHARTER SCHOOL Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2019   grade_7 1.0 4.0 5.0   0.0 0.0     0.0   0.0   6.0 4.0     1.0   *     7.0   3.0   10.0 1 4 5   0 0     0   0   6 4     1     7 3   10
1954154 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 2019   grade_7 1.0 8.0 10.0   0.0 45.0     0.0   0.0   41.0 23.0     22.0   4.0     36.0   3.0   64.0 1 8 10   0 45     0   0   41 23     22 4   36 3   64
1955154 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 2019   grade_7 1.0 0.0 0.0   1.0 0.0     0.0   0.0   2.0 0.0     *   *         *   2.0 1 0 0   1 0     0   0   2 0                 2
1955392 MN Carlton 9 school 2709420 94 Independent Districts and Schools CLOQUET PUBLIC SCHOOL DISTRICT 270942002236 103 CLOQUET AREA ALT. ED. PROGRAMS Public Area Learning Center ALC (State approved) Alternative School No Other 01 12 2019   grade_7 1.0 0.0 0.0   1.0 0.0     0.0   0.0   2.0 0.0     *   *         *   2.0 1 0 0   1 0     0   0   2 0                 2
1955536 MN Kandiyohi 34 school 2742720 347 Independent Districts and Schools WILLMAR PUBLIC SCHOOL DISTRICT 274272000950 949 WILLMAR AREA LEARNING CENTER Public Area Learning Center ALC (State approved) Alternative School No High 07 12 2019   grade_7 1.0 1.0 4.0   0.0 0.0     0.0   1.0   4.0 3.0     *   *         *   7.0 1 1 4   0 0     0   1   4 3                 7
1955546 MN Lyon 42 school 2718940 413 Independent Districts and Schools MARSHALL PUBLIC SCHOOL DISTRICT 271894002816 8 MATEC Public Area Learning Center ALC (State approved) Alternative School No High 07 12 2019   grade_7 1.0 4.0 3.0   0.0 0.0     0.0   0.0   6.0 2.0     *   *         *   8.0 1 4 3   0 0     0   0   6 2                 8
1955575 MN Mille Lacs 48 school 2715510 473 Independent Districts and Schools ISLE PUBLIC SCHOOL DISTRICT 271551002819 40 ISLE AREA LEARNING CENTER Public Area Learning Center ALC (State approved) Alternative School No High 07 12 2019   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
1955899 MN Olmsted 55 school 2700054 6012 Education Districts ZUMBRO EDUCATION DISTRICT 270005402492 20 ZUMBRO AREA LEARNING CENTER Public Area Learning Center ALC (State approved) Alternative School No High 06 12 2019   grade_7 1.0 1.0 0.0   0.0 0.0     0.0   0.0   1.0 1.0     *   *         *   2.0 1 1 0   0 0     0   0   1 1                 2
1956135 MN Hennepin 27 school 2733780 283 Independent Districts and Schools ST. LOUIS PARK PUBLIC SCHOOL DIST. 273378002442 757 SPECIAL ED. Special Education Special Education School No High 07 12 2019   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
1956205 MN Ramsey 62 school 2722950 621 Independent Districts and Schools MOUNDS VIEW PUBLIC SCHOOL DISTRICT 272295002998 39 MOUNDS VIEW BRIDGES PROGRAM Special Education Special Education School No Elementary KG 07 2019   grade_7 1.0 0.0 0.0   0.0 0.0     0.0   1.0   2.0 0.0     *   *         *   2.0 1 0 0   0 0     0   1   2 0                 2
1956234 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 2019   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
1956462 MN Hennepin 27 school 2700025 287 Intermediate Districts and Schools INTERMEDIATE SCHOOL DISTRICT 287 270002504327 428 INVEST HIGH SCHOOL Special Education Special Education School No High 05 12 2019   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
1956483 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 2019   grade_7 1.0 0.0 0.0   0.0 0.0     0.0   1.0   2.0 0.0     *   *         *   2.0 1 0 0   0 0     0   1   2 0                 2
1956600 MN Washington 82 school 2702264 916 Intermediate Districts and Schools NORTHEAST METRO 916 270226404951 58 Pankalo Special Education Special Education School No Elementary KG 08 2019   grade_7 1.0 1.0 0.0   0.0 1.0     0.0   0.0   1.0 2.0     *   *         *   3.0 1 1 0   0 1     0   0   1 2                 3
1956615 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 2019   grade_7 1.0 1.0 0.0   1.0 0.0     0.0   1.0   3.0 1.0     *   *         *   4.0 1 1 0   1 0     0   1   3 1                 4
1956664 MN Dakota 19 school 2700026 917 Intermediate Districts and Schools INTERMEDIATE SCHOOL DISTRICT 917 270002603897 500 917 DASH Special Education Special Education School No Other PK 12 2019   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
1956700 MN Clay 14 school 2700040 397 Special Education Cooperatives Lake Agassiz Education Cooperative 270004005080 12 Glacial Ridge Transitional Skills Program Special Education Special Education School No High 07 12 2019   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
1956724 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 2019   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
1956887 MN Carlton 9 school 2700442 6096 Special Education Cooperatives Northern Lights Academy Cooperative 270044205073 10 Northern Lights Academy Special Education Special Education School No Elementary KG 08 2019   grade_7 1.0 1.0 0.0   1.0 0.0     0.0   0.0   2.0 1.0     *   *         *   3.0 1 1 0   1 0     0   0   2 1                 3
1956893 MN Carlton 9 school 2700442 6096 Special Education Cooperatives Northern Lights Academy Cooperative 270044205117 20 Northern Lights Academy Cooperative-Our Savior's Special Education Special Education School No Elementary KG 08 2019   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
1956916 MN Cottonwood 17 school 2700086 991 Service Cooperative (ECSU Region) Region 6 and 8-SW/WC Service Cooperative 270008604168 16 SWWC ELC - Windom Special Education Special Education School No Other 01 12 2019   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
1956929 MN Lyon 42 school 2700086 991 Service Cooperative (ECSU Region) Region 6 and 8-SW/WC Service Cooperative 270008604438 22 SWWC ELC - Belview Special Education Special Education School No Other KG 12 2019   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
1956968 MN Kandiyohi 34 school 2700086 991 Service Cooperative (ECSU Region) Region 6 and 8-SW/WC Service Cooperative 270008604724 47 SWWC ELC - Willmar Special Education Special Education School No Other KG 12 2019   grade_7 1.0 1.0 0.0   0.0 0.0     0.0   0.0   1.0 1.0     *   *         *   2.0 1 1 0   0 0     0   0   1 1                 2
1956992 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 2019   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
1957013 MN Otter Tail 56 school 2700014 6004 Education Districts FRESHWATER ED. DIST. 270001403675 60 LEAF RIVER ACADEMY Special Education Special Education School No Other KG 12 2019   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
1957031 MN Chisago 13 school 2700015 6009 Education Districts ST. CROIX RIVER EDUCATION DISTRICT 270001505144 50 Skillbuilding Opportunities for Academic Resiliency Special Education Special Education School No Other KG 12 2019   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
1957079 MN Houston 28 school 2700055 6013 Education Districts HIAWATHA VALLEY ED. DISTRICT 270005504591 32 WIN PROGRAM Special Education Special Education School No Other PK 12 2019   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
1957089 MN Douglas 21 school 2700016 6014 Education Districts RUNESTONE AREA ED. DISTRICT 270001604931 90 SOAR Special Education Special Education School No Middle 06 09 2019   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
1957097 MN Stearns 73 school 2791455 6026 Education Districts WEST CENTRAL EDUCATION DISTRICT 279145503591 24 BEACON PROGRAM W CENTRAL ED. DIST. Special Education Special Education School No Other KG 12 2019   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
1957207 MN Morrison 49 school 2700073 6979 Education Districts MID STATE EDUCATION DISTRICT 270007305181 70 MSED Mid-Level Special Education Special Education School No Middle 06 08 2019   grade_7 1.0 0.0 0.0   2.0 0.0     0.0   0.0   2.0 1.0     *   *         *   3.0 1 0 0   2 0     0   0   2 1                 3
1957217 MN Saint Louis 69 school 2700224 6076 Miscellaneous Cooperatives NORTHLAND LEARNING CENTER 270022403476 20 NORTHLAND LEARNING CENTER 020 Special Education Special Education School No Other PK 12 2019   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
1957268 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 2019   grade_7 1.0 2.0 2.0   0.0 0.0     0.0   0.0   1.0 4.0     *   *         *   5.0 1 2 2   0 0     0   0   1 4                 5
1957279 MN Hennepin 27 school 2700025 287 Intermediate Districts and Schools INTERMEDIATE SCHOOL DISTRICT 287 270002504537 530 PraIrie Care Brooklyn Park Day Program Hospital/Medical/Partial Hospitalization Program Alternative School No Other KG 12 2019   grade_7 1.0 2.0 0.0   0.0 0.0     0.0   0.0   1.0 2.0     *   *         *   3.0 1 2 0   0 0     0   0   1 2                 3
1957328 MN Anoka 2 school 2733540 15 Independent Districts and Schools St. Francis Area Schools 273354004917 15 Saints Online Distance Learning Program OLL (State approved) Regular School No Other 03 12 2019   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
1957382 MN Lincoln 41 school 2713680 402 Independent Districts and Schools HENDRICKS PUBLIC SCHOOL DISTRICT 271368004925 90 MNVSS Distance Learning Program OLL (State approved) Regular School No High 06 12 2019   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

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