Data source: Big Local News · About: Big Local

678 rows where grade = "grade_7", state = "MN" and year = 2018 sorted by white

View and edit SQL

year

  • 2018 · 678

grade

  • grade_7 · 678
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
1881122 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 2018   grade_7 0.0 25.0 0.0   0.0 0.0     0.0   0.0   13.0 12.0     17.0   0.0     *   1.0   25.0 0 25 0   0 0     0   0   13 12     17 0     1   25
1881215 MN Rice 66 school 2700192 4081 Charter Schools Discovery Public School Faribault 270019203145 10 Discovery Public School Faribault Secondary School (Grades 7-12) Regular School Yes High 06 12 2018   grade_7 0.0 0.0 1.0   0.0 0.0     0.0   1.0   0.0 2.0     *   *     *   *   2.0 0 0 1   0 0     0   1   0 2                 2
1881303 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 2018   grade_7 0.0 43.0 0.0   0.0 0.0     0.0   0.0   25.0 18.0     25.0   0.0     *   1.0   43.0 0 43 0   0 0     0   0   25 18     25 0     1   43
1881310 MN Saint Louis 69 school 2700372 4207 Charter Schools Vermilion Country School 270037204555 10 Vermilion Country School Secondary School (Grades 7-12) Regular School Yes High 07 12 2018   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
1881317 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 2018   grade_7 0.0 0.0 6.0   0.0 0.0     0.0   0.0   5.0 1.0     *   *     *   *   6.0 0 0 6   0 0     0   0   5 1                 6
1881715 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 2018   grade_7 0.0 0.0 0.0   6.0 0.0     0.0   0.0   1.0 5.0     *   *     *   *   6.0 0 0 0   6 0     0   0   1 5                 6
1881806 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 2018   grade_7 0.0 0.0 0.0   21.0 0.0     0.0   1.0   15.0 7.0     *   *     *   *   22.0 0 0 0   21 0     0   1   15 7                 22
1887386 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 2018   grade_7 0.0 56.0 2.0   2.0 0.0     0.0   1.0   32.0 29.0     39.0   7.0     *   3.0   61.0 0 56 2   2 0     0   1   32 29     39 7     3   61
1887489 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 2018   grade_7 0.0 24.0 1.0   0.0 17.0     0.0   2.0   23.0 21.0     14.0   0.0     36.0   10.0   44.0 0 24 1   0 17     0   2   23 21     14 0   36 10   44
1887542 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 2018   grade_7 0.0 13.0 0.0   0.0 0.0     0.0   0.0   6.0 7.0     7.0   0.0     *   3.0   13.0 0 13 0   0 0     0   0   6 7     7 0     3   13
1887649 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 2018   grade_7 0.0 69.0 0.0   0.0 0.0     0.0   0.0   39.0 30.0     10.0   0.0     *   4.0   69.0 0 69 0   0 0     0   0   39 30     10 0     4   69
1887684 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 2018   grade_7 0.0 33.0 11.0   0.0 0.0     0.0   1.0   22.0 23.0     5.0   5.0     *   9.0   45.0 0 33 11   0 0     0   1   22 23     5 5     9   45
1887765 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 2018   grade_7 0.0 29.0 3.0   0.0 0.0     0.0   0.0   17.0 15.0     6.0   2.0     *   7.0   32.0 0 29 3   0 0     0   0   17 15     6 2     7   32
1887878 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 2018   grade_7 0.0 0.0 1.0   0.0 174.0     0.0   0.0   94.0 81.0     44.0   1.0     148.0   19.0   175.0 0 0 1   0 174     0   0   94 81     44 1   148 19   175
1887957 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 2018   grade_7 0.0 41.0 0.0   0.0 0.0     0.0   0.0   25.0 16.0     9.0   0.0     *   5.0   41.0 0 41 0   0 0     0   0   25 16     9 0     5   41
1887981 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 2018   grade_7 0.0 14.0 1.0   0.0 0.0     0.0   0.0   8.0 7.0     0.0   0.0     *   2.0   15.0 0 14 1   0 0     0   0   8 7     0 0     2   15
1888009 MN Hennepin 27 school 2700253 4143 Charter Schools New Millennium Academy Charter School 270025303311 10 New Millenium Academy Charter School Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2018   grade_7 0.0 2.0 2.0   0.0 61.0     0.0   0.0   34.0 31.0     32.0   0.0     39.0   8.0   65.0 0 2 2   0 61     0   0   34 31     32 0   39 8   65
1888044 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 2018   grade_7 0.0 25.0 0.0   0.0 0.0     0.0   0.0   11.0 14.0     21.0   0.0     *   1.0   25.0 0 25 0   0 0     0   0   11 14     21 0     1   25
1888147 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 2018   grade_7 0.0 0.0 1.0   0.0 133.0     0.0   0.0   77.0 57.0     64.0   0.0     110.0   19.0   134.0 0 0 1   0 133     0   0   77 57     64 0   110 19   134
1888307 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 2018   grade_7 0.0 5.0 8.0   0.0 0.0     0.0   0.0   5.0 8.0     *   4.0     10.0   2.0   13.0 0 5 8   0 0     0   0   5 8       4   10 2   13
1888325 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 2018   grade_7 0.0 1.0 0.0   0.0 19.0     0.0   0.0   8.0 12.0     *   0.0     *   1.0   20.0 0 1 0   0 19     0   0   8 12       0     1   20
1888377 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 2018   grade_7 0.0 21.0 0.0   0.0 0.0     0.0   0.0   12.0 9.0     *   0.0     *   2.0   21.0 0 21 0   0 0     0   0   12 9       0     2   21
1888689 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 2018   grade_7 0.0 0.0 0.0   85.0 0.0     0.0   0.0   34.0 51.0     0.0   4.0     70.0   18.0   85.0 0 0 0   85 0     0   0   34 51     0 4   70 18   85
1889503 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 2018   grade_7 0.0 12.0 18.0   1.0 16.0     0.0   0.0   31.0 16.0     21.0   2.0     *   8.0   47.0 0 12 18   1 16     0   0   31 16     21 2     8   47
1889513 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 2018   grade_7 0.0 0.0 46.0   0.0 0.0     0.0   0.0   22.0 24.0     17.0   0.0     40.0   4.0   46.0 0 0 46   0 0     0   0   22 24     17 0   40 4   46
1889525 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 2018   grade_7 0.0 109.0 0.0   0.0 0.0     0.0   0.0   47.0 62.0     33.0   0.0     *   8.0   109.0 0 109 0   0 0     0   0   47 62     33 0     8   109
1889551 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 2018   grade_7 0.0 40.0 0.0   0.0 0.0     0.0   0.0   24.0 16.0     27.0   0.0     *   0.0   40.0 0 40 0   0 0     0   0   24 16     27 0     0   40
1890755 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 2018   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
1890768 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 2018   grade_7 0.0 0.0 0.0   0.0 0.0     0.0   2.0   2.0 0.0     *   *     *   *   2.0 0 0 0   0 0     0   2   2 0                 2
1890791 MN Cass 11 school 2708070 115 Independent Districts and Schools Cass Lake-Bena Public Schools 270807002234 31 Cass Lake-Bena Area Learning Center Public Area Learning Center ALC (State approved) Alternative School No High 07 12 2018   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
1890949 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 2018   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
1890995 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 2018   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
1891620 MN Pine 58 school 2728380 578 Independent Districts and Schools Pine City Public School District 272838004499 50 Vision Special Education Special Education School No Other KG 12 2018   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
1891703 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 2018   grade_7 0.0 11.0 2.0   0.0 0.0     0.0   2.0   13.0 2.0     1.0   1.0     11.0   *   15.0 0 11 2   0 0     0   2   13 2     1 1   11     15
1891865 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 2018   grade_7 0.0 9.0 0.0   1.0 0.0     0.0   0.0   8.0 2.0     0.0   1.0     *   *   10.0 0 9 0   1 0     0   0   8 2     0 1         10
1891921 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 2018   grade_7 0.0 4.0 1.0   0.0 0.0     0.0   0.0   5.0 0.0     *   *     *   *   5.0 0 4 1   0 0     0   0   5 0                 5
1891968 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 KG 12 2018   grade_7 0.0 2.0 0.0   0.0 0.0     0.0   1.0   3.0 0.0     *   *     *   *   3.0 0 2 0   0 0     0   1   3 0                 3
1892506 MN Nicollet 52 school 2700063 6027 Education Districts Minnesota Valley Education District 270006304710 40 ASD Program Special Education Special Education School No Other KG 12 2018   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
1892581 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 2018   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
1892636 MN Ramsey 62 school 2733840 625 Independent Districts and Schools St. Paul Public School District 273384001331 675 United Hospital Adolescent Program Hospital/Medical/Partial Hospitalization Program Alternative School No High 06 12 2018   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
1892980 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 2018   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
1892993 MN Mcleod 43 school 2714970 423 Independent Districts and Schools Hutchinson Public School District 271497003189 35 Cornerstone Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No Other KG 12 2018   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
1893019 MN Olmsted 55 school 2731800 535 Independent Districts and Schools Rochester Public School District 273180002823 217 Care and Treatment JDC/Von Wald Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No High 05 12 2018   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
1893079 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 2018   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
1893086 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 2018   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
1893118 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 2018   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
1893131 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 2018   grade_7 0.0 4.0 2.0   0.0 0.0     0.0   1.0   4.0 3.0     *   *     *   *   7.0 0 4 2   0 0     0   1   4 3                 7
1893188 MN Dakota 19 school 2700026 917 Intermediate Districts and Schools Intermediate School District 917 270002602600 105 Riverside School Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No High 06 12 2018   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
1893302 MN Ramsey 62 school 2722950 621 Independent Districts and Schools Mounds View Public School District 272295003494 41 NETS Educational Oversight to Public Care and Treatment Day Program Alternative School No High 05 12 2018   grade_7 0.0 2.0 0.0   0.0 0.0     0.0   0.0   1.0 1.0     *   *     *   *   2.0 0 2 0   0 0     0   0   1 1                 2
1893587 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 2018   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
1881185 MN Houston 28 school 2700178 4054 Charter Schools La Crescent Montessori and STEM School 270017804750 20 La Crescent Secondary Montessori and STEM Academy Secondary School (Grades 7-12) Regular School Yes High 07 12 2018   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
1881346 MN Ramsey 62 school 2700402 4237 Charter Schools Career Pathways 270040204836 10 Career Pathways Secondary School (Grades 7-12) Regular School Yes High 06 12 2018   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
1886255 MN Wright 86 school 2707200 877 Independent Districts and Schools Buffalo-Hanover-Montrose Public Schools 270720000286 20 Hanover Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 07 2018   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
1887355 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 2018   grade_7 1.0 27.0 27.0   1.0 1.0     0.0   1.0   32.0 26.0     *   2.0     52.0   16.0   58.0 1 27 27   1 1     0   1   32 26       2   52 16   58
1887775 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 2018   grade_7 1.0 3.0 0.0   0.0 46.0     1.0   0.0   25.0 26.0     18.0   0.0     40.0   6.0   51.0 1 3 0   0 46     1   0   25 26     18 0   40 6   51
1888129 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 2018   grade_7 1.0 10.0 1.0   0.0 75.0     0.0   0.0   52.0 35.0     26.0   0.0     42.0   6.0   87.0 1 10 1   0 75     0   0   52 35     26 0   42 6   87
1888216 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 08 2018   grade_7 1.0 79.0 1.0   0.0 0.0     0.0   2.0   44.0 39.0     11.0   1.0     72.0   13.0   83.0 1 79 1   0 0     0   2   44 39     11 1   72 13   83
1888418 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 Other KG 09 2018   grade_7 1.0 36.0 0.0   0.0 2.0     0.0   1.0   9.0 31.0     32.0   0.0     *   3.0   40.0 1 36 0   0 2     0   1   9 31     32 0     3   40
1889546 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 2018   grade_7 1.0 14.0 9.0   0.0 44.0     0.0   0.0   30.0 38.0     30.0   4.0     53.0   9.0   68.0 1 14 9   0 44     0   0   30 38     30 4   53 9   68
1889567 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 2018   grade_7 1.0 3.0 85.0   1.0 0.0     0.0   0.0   46.0 44.0     34.0   5.0     70.0   9.0   90.0 1 3 85   1 0     0   0   46 44     34 5   70 9   90
1889572 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 2018   grade_7 1.0 42.0 1.0   0.0 0.0     0.0   0.0   28.0 16.0     1.0   4.0     *   13.0   44.0 1 42 1   0 0     0   0   28 16     1 4     13   44
1890704 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318002974 812 Compass-Bell Center Public Area Learning Center ALC (State approved) Alternative School No High 06 12 2018   grade_7 1.0 2.0 0.0   0.0 0.0     0.0   0.0   3.0 0.0     *   *     *   *   3.0 1 2 0   0 0     0   0   3 0                 3
1890803 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 School No High 05 12 2018   grade_7 1.0 0.0 1.0   0.0 0.0     0.0   1.0   2.0 1.0     *   *     *   *   3.0 1 0 1   0 0     0   1   2 1                 3
1890886 MN Hennepin 27 school 2706240 286 Independent Districts and Schools Brooklyn Center School District 270624004780 16 Brooklyn Center Middle School ALC Public Area Learning Center ALC (State approved) Alternative School No Middle 06 08 2018   grade_7 1.0 3.0 4.0   0.0 5.0     0.0   2.0   4.0 11.0     *   0.0     13.0   *   15.0 1 3 4   0 5     0   2   4 11       0   13     15
1890919 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 2018   grade_7 1.0 0.0 5.0   0.0 0.0     0.0   1.0   5.0 2.0     *   *     *   *   7.0 1 0 5   0 0     0   1   5 2                 7
1891168 MN Isanti 30 school 2707410 911 Independent Districts and Schools Cambridge-Isanti Public School District 270741005021 385 Riverside Academy MLP Public Area Learning Center ALC (State approved) Alternative School No Middle 06 08 2018   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
1891300 MN Wadena 80 school 2700014 6004 Education Districts Freshwater Education District 270001402222 20 Freshwater Education District ALC Public Area Learning Center ALC (State approved) Alternative School No High 06 12 2018   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
1891307 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 2018   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
1891323 MN Chippewa 12 school 2700058 6018 Education Districts Minnesota River Valley Education District 270005802245 20 Minnesota River Valley ALC-Seatbased Public Area Learning Center ALC (State approved) Alternative School No High 07 12 2018   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
1891333 MN Stearns 73 school 2791455 6026 Education Districts West Central Education District 279145502388 20 West Central Area Learning Center Public Area Learning Center ALC (State approved) Alternative School No High 06 12 2018   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
1891345 MN Goodhue 25 school 2791443 6051 Education Districts Goodhue County Education District 279144304717 610 Pathways Program Grades 6-7 Public Area Learning Center ALC (State approved) Alternative School No Middle 06 07 2018   grade_7 1.0 0.0 1.0   1.0 0.0     0.0   1.0   3.0 1.0     *   *     *   *   4.0 1 0 1   1 0     0   1   3 1                 4
1891535 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 2018   grade_7 1.0 2.0 0.0   0.0 0.0     0.0   1.0   4.0 0.0     *   *     *   *   4.0 1 2 0   0 0     0   1   4 0                 4
1891637 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 2018   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
1891691 MN Ramsey 62 school 2733840 625 Independent Districts and Schools St. Paul Public School District 273384002189 430 Bridge View Special Education Special Education Special Education School No Other KG 12 2018   grade_7 1.0 7.0 2.0   0.0 2.0     0.0   0.0   7.0 5.0     7.0   0.0     9.0   *   12.0 1 7 2   0 2     0   0   7 5     7 0   9     12
1891747 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 2018   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
1891772 MN Sherburne 71 school 2711370 728 Independent Districts and Schools Elk River Public School District 271137004142 401 ISD 728 Focus/Journey Special Education Special Education School No Other 03 12 2018   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
1891834 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 2018   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
1891840 MN Chisago 13 school 2700017 2144 Independent Districts and Schools Chisago Lakes School District 270001704939 17 SOAR Special Education Special Education School No Other 01 12 2018   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
1891901 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 06 12 2018   grade_7 1.0 8.0 0.0   0.0 0.0     0.0   0.0   6.0 3.0     *   *     *   *   9.0 1 8 0   0 0     0   0   6 3                 9
1891929 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 2018   grade_7 1.0 3.0 1.0   0.0 0.0     0.0   0.0   5.0 0.0     *   *     *   *   5.0 1 3 1   0 0     0   0   5 0                 5
1891957 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 2018   grade_7 1.0 2.0 0.0   0.0 0.0     0.0   0.0   3.0 0.0     *   *     *   *   3.0 1 2 0   0 0     0   0   3 0                 3
1892017 MN Ramsey 62 school 2702264 916 Intermediate Districts and Schools Northeast Metro 916 270226402093 36 ALP at Capitol View Center Special Education Special Education School No High 05 12 2018   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
1892042 MN Ramsey 62 school 2702264 916 Intermediate Districts and Schools Northeast Metro 916 270226402108 56 South Campus 916 Special Education Special Education School No High 05 12 2018   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
1892098 MN Dakota 19 school 2700026 917 Intermediate Districts and Schools Intermediate School District 917 270002602125 61 917 PACES Special Education Special Education School No Other KG 12 2018   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
1892123 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 2018   grade_7 1.0 0.0 0.0   0.0 1.0     0.0   0.0   2.0 0.0     *   *     *   *   2.0 1 0 0   0 1     0   0   2 0                 2
1892135 MN Dakota 19 school 2700026 917 Intermediate Districts and Schools Intermediate School District 917 270002604371 700 TEA Special Education Special Education School No Other KG 12 2018   grade_7 1.0 0.0 0.0   0.0 0.0     0.0   1.0   1.0 1.0     *   *     *   *   2.0 1 0 0   0 0     0   1   1 1                 2
1892142 MN Dakota 19 school 2700026 917 Intermediate Districts and Schools Intermediate School District 917 270002605108 900 Customized Alternative Solutions for Education (CASE) Special Education Special Education School No Other 04 11 2018   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
1892215 MN Wright 86 school 2700045 938 Special Education Cooperatives Meeker and Wright Special Education 270004502732 18 Eastern Wright Program Special Education Special Education School No Elementary KG 07 2018   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
1892265 MN Fillmore 23 school 2700327 6083 Special Education Cooperatives Southern Minnesota Education Consortium 270032705124 70 Enrich Kingsland Special Education Special Education School No High 06 12 2018   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
1892357 MN Lyon 42 school 2700086 991 Service Cooperative (ECSU Region) Region 6 and 8-SW/WC Service Cooperative 270008604438 22 Belview Learning Center Special Education Special Education School No Other KG 12 2018   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
1892381 MN Pipestone 59 school 2700086 991 Service Cooperative (ECSU Region) Region 6 and 8-SW/WC Service Cooperative 270008604353 29 Blue Mound Learning Center Special Education Special Education School No Other KG 12 2018   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
1892472 MN Houston 28 school 2700055 6013 Education Districts Hiawatha Valley Education District 270005504591 32 WIN Program Special Education Special Education School No Other PK 12 2018   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
1892644 MN Saint Louis 69 school 2711040 709 Independent Districts and Schools Duluth Public School District 271104001600 630 Superior Academy Hospital/Medical/Partial Hospitalization Program Alternative School No High 06 12 2018   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
1892657 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 2018   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
1892721 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 2018   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
1892772 MN Mille Lacs 48 school 2730030 477 Independent Districts and Schools Princeton Public School District 273003004927 80 Princeton Online Academy Distance Learning Program OLL (State approved) Regular School No Other 03 12 2018   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
1892948 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 School No Other 03 12 2018   grade_7 1.0 0.0 1.0   0.0 0.0     0.0   0.0   1.0 1.0     *   *     *   *   2.0 1 0 1   0 0     0   0   1 1                 2
1892959 MN Dakota 19 school 2713530 200 Independent Districts and Schools Hastings Public School District 271353000559 137 Harbor Educational Program Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No High 05 12 2018   grade_7 1.0 0.0 0.0   0.0 1.0     0.0   0.0   2.0 0.0     *   *     *   *   2.0 1 0 0   0 1     0   0   2 0                 2
1893008 MN Nicollet 52 school 2733870 508 Independent Districts and Schools St. Peter Public School District 273387000973 60 Hoffman Learning Center Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No High 05 12 2018   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
1893098 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 2018   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]);