Data source: Big Local News · About: Big Local

694 rows where grade = "grade_7", state = "MN" and year = 2020 sorted by rowid descending

View and edit SQL

year

  • 2020 · 694

grade

  • grade_7 · 694
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
1839250 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 2020   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
1839237 MN Yellow Medicine 87 school 2700139 4026 Charter Schools E.C.H.O. Charter School 270013902718 10 E.C.H.O. Charter School Elementary/Secondary Combined (Grades K-12 limited to District Type 34 Bureau of Indian Education) Regular School Yes Other KG 12 2020   grade_7 3.0 0.0 0.0   4.0 0.0     0.0   0.0   3.0 4.0     *   *         *   7.0 3 0 0   4 0     0   0   3 4                 7
1839223 MN Washington 82 school 2723380 4003 Charter Schools New Heights School, Inc. 272338000020 10 New Heights School, Inc. Elementary/Secondary Combined (Grades K-12 limited to District Type 34 Bureau of Indian Education) Regular School Yes Other KG 12 2020   grade_7 7.0 1.0 2.0   0.0 0.0     0.0   1.0   9.0 2.0     0.0   0.0     5.0   7.0   11.0 7 1 2   0 0     0   1   9 2     0 0   5 7   11
1839211 MN Ramsey 62 school 2702264 916 Intermediate Districts and Schools Northeast Metro 916 270226404132 38 PROJECT RETURN Elementary/Secondary Combined (Grades K-12 limited to District Type 34 Bureau of Indian Education) Regular School No Other KG 12 2020   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
1839165 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 2020   grade_7 0.0 0.0 0.0   4.0 0.0     0.0   0.0   1.0 3.0     *   *         *   4.0 0 0 0   4 0     0   0   1 3                 4
1839148 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124002860 315 Ronald McDonald House Private Alternative Program Alternative School No Other KG 12 2020   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
1839133 MN Rock 67 school 2718330 2184 Independent Districts and Schools Luverne Public School District 271833004162 10 Pinnacle Programs Southwestern Youth Services Educational Oversight to Private Residential Care & Treatment (State approved) Alternative School No High 05 12 2020   grade_7 2.0 0.0 1.0   1.0 0.0     0.0   0.0   4.0 0.0     *   *         *   4.0 2 0 1   1 0     0   0   4 0                 4
1839124 MN Mower 50 school 2703450 492 Independent Districts and Schools Austin Public School District 270345003192 450 New Dominion Academy Educational Oversight to Private Residential Care & Treatment (State approved) Alternative School No Other KG 12 2020   grade_7 7.0 2.0 2.0   0.0 0.0     0.0   0.0   5.0 6.0     0.0   0.0     1.0   *   11.0 7 2 2   0 0     0   0   5 6     0 0   1     11
1839105 MN Wabasha 79 school 2700287 2899 Independent Districts and Schools Plainview-Elgin-Millville 270028703714 30 Plainview-Elgin-Millville Junior Junior High School (Grades 7-8 or 7-9) Regular School No Middle 07 08 2020   grade_7 98.0 1.0 10.0   0.0 0.0     0.0   3.0   63.0 49.0     2.0   0.0     29.0   15.0   112.0 98 1 10   0 0     0   3   63 49     2 0   29 15   112
1839102 MN Mcleod 43 school 2700128 2859 Independent Districts and Schools Glencoe-Silver Lake School District 270012801445 40 GSL Junior High School Junior High School (Grades 7-8 or 7-9) Regular School No Middle 07 08 2020   grade_7 103.0 0.0 27.0   1.0 0.0     0.0   3.0   65.0 69.0     6.0   0.0     37.0   15.0   134.0 103 0 27   1 0     0   3   65 69     6 0   37 15   134
1839099 MN Martin 46 school 2718960 2448 Independent Districts and Schools Martin County West School District 271896000076 25 Martin County West Junior High Junior High School (Grades 7-8 or 7-9) Regular School No Middle 07 08 2020   grade_7 57.0 0.0 1.0   0.0 0.0     0.0   2.0   30.0 30.0     0.0   0.0     22.0   9.0   60.0 57 0 1   0 0     0   2   30 30     0 0   22 9   60
1839096 MN Sibley 72 school 2700102 2310 Independent Districts and Schools Sibley East School District 270010200625 20 Sibley East Middle School Junior High School (Grades 7-8 or 7-9) Regular School No Middle 06 08 2020   grade_7 52.0 3.0 32.0   0.0 0.0     0.0   2.0   48.0 41.0     7.0   0.0     35.0   19.0   89.0 52 3 32   0 0     0   2   48 41     7 0   35 19   89
1839092 MN Saint Louis 69 school 2700021 2154 Independent Districts and Schools Eveleth-Gilbert School District 270002100628 30 Eveleth-Gilbert Junior High Junior High School (Grades 7-8 or 7-9) Regular School No Middle 07 08 2020   grade_7 57.0 0.0 0.0   1.0 0.0     0.0   1.0   26.0 33.0     0.0   *         *   59.0 57 0 0   1 0     0   1   26 33     0           59
1839089 MN Pope 61 school 2700019 2149 Independent Districts and Schools Minnewaska School District 270001904237 55 Minnewaska Area Junior High Junior High School (Grades 7-8 or 7-9) Regular School No Middle 07 08 2020   grade_7 107.0 2.0 0.0   0.0 4.0     0.0   2.0   66.0 49.0     *   *         *   115.0 107 2 0   0 4     0   2   66 49                 115
1839086 MN Rice 66 school 2700013 2143 Independent Districts and Schools Waterville-Elysian-Morristown Public School District 270001301104 20 Waterville-Elysian-Morristown Jr. Junior High School (Grades 7-8 or 7-9) Regular School No Middle 07 08 2020   grade_7 66.0 1.0 2.0   1.0 0.0     0.0   0.0   28.0 42.0     0.0   0.0     18.0   15.0   70.0 66 1 2   1 0     0   0   28 42     0 0   18 15   70
1839083 MN Washington 82 school 2712270 831 Independent Districts and Schools Forest Lake Public School District 271227000592 115 Forest Lake Area Middle School Junior High School (Grades 7-8 or 7-9) Regular School No Middle 07 08 2020   grade_7 369.0 6.0 17.0   3.0 14.0     0.0   21.0   222.0 208.0     9.0   1.0     94.0   54.0   430.0 369 6 17   3 14     0   21   222 208     9 1   94 54   430
1839080 MN Waseca 81 school 2741880 829 Independent Districts and Schools Waseca Public School District 274188002683 45 Waseca Junior High Junior High School (Grades 7-8 or 7-9) Regular School No Middle 07 08 2020   grade_7 152.0 6.0 24.0   0.0 2.0     0.0   4.0   97.0 91.0     6.0   2.0     73.0   26.0   188.0 152 6 24   0 2     0   4   97 91     6 2   73 26   188
1839077 MN Stearns 73 school 2733510 742 Independent Districts and Schools St. Cloud Public School District 273351001492 54 South Junior High Junior High School (Grades 7-8 or 7-9) Regular School No Middle 06 08 2020   grade_7 128.0 123.0 21.0   0.0 5.0     0.0   25.0   162.0 140.0     42.0   13.0     195.0   49.0   302.0 128 123 21   0 5     0   25   162 140     42 13   195 49   302
1839073 MN Stearns 73 school 2733510 742 Independent Districts and Schools St. Cloud Public School District 273351002188 52 North Junior High Junior High School (Grades 7-8 or 7-9) Regular School No Middle 06 08 2020   grade_7 105.0 110.0 25.0   0.0 15.0     0.0   29.0   148.0 136.0     59.0   *     198.0   63.0   284.0 105 110 25   0 15     0   29   148 136     59     198 63   284
1839069 MN Scott 70 school 2704050 716 Independent Districts and Schools Belle Plaine Public School District 270405002169 30 Belle Plaine Junior High Junior High School (Grades 7-8 or 7-9) Regular School No Middle 07 08 2020   grade_7 112.0 1.0 9.0   0.0 2.0     0.0   7.0   59.0 72.0     1.0   0.0     20.0   23.0   131.0 112 1 9   0 2     0   7   59 72     1 0   20 23   131
1839065 MN Hennepin 27 school 2714260 270 Independent Districts and Schools Hopkins Public School District 271426000616 380 Hopkins West Junior High Junior High School (Grades 7-8 or 7-9) Regular School No Middle 07 09 2020   grade_7 91.0 60.0 12.0   0.0 11.0     0.0   24.0   96.0 102.0     14.0   5.0     85.0   38.0   198.0 91 60 12   0 11     0   24   96 102     14 5   85 38   198
1839061 MN Hennepin 27 school 2714260 270 Independent Districts and Schools Hopkins Public School District 271426000615 378 Hopkins North Junior High Junior High School (Grades 7-8 or 7-9) Regular School No Middle 07 09 2020   grade_7 182.0 60.0 38.0   1.0 15.0     1.0   29.0   164.0 162.0     16.0   3.0     111.0   33.0   326.0 182 60 38   1 15     1   29   164 162     16 3   111 33   326
1839013 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 2020   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
1839008 MN Washington 82 school 2702264 916 Intermediate Districts and Schools Northeast Metro 916 270226405238 70 Aris Woodwinds Educational Oversight to Public Care and Treatment Day Program Alternative School No High 06 12 2020   grade_7 3.0 0.0 0.0   0.0 0.0     0.0   0.0   1.0 2.0     *   *         *   3.0 3 0 0   0 0     0   0   1 2                 3
1838983 MN Scott 70 school 2700420 288 Intermediate Districts and Schools Southwest Metro Intermediate 288 270042004999 34 SW Metro Day Treatment Educational Oversight to Public Care and Treatment Day Program Alternative School No High 06 12 2020   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
1838975 MN Hennepin 27 school 2700025 287 Intermediate Districts and Schools Intermediate School District 287 270002504929 538 Headway Academy North Educational Oversight to Public Care and Treatment Day Program Alternative School No High 07 12 2020   grade_7 2.0 1.0 0.0   0.0 0.0     0.0   0.0   1.0 2.0     *   *         *   3.0 2 1 0   0 0     0   0   1 2                 3
1838958 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124001936 689 MPS Metro SJ Educational Oversight to Public Care and Treatment Day Program Alternative School No Other KG 12 2020   grade_7 1.0 1.0 0.0   0.0 0.0     0.0   1.0   1.0 2.0     *   *         *   3.0 1 1 0   0 0     0   1   1 2                 3
1838945 MN Pope 61 school 2700019 2149 Independent Districts and Schools Minnewaska School District 270001903600 101 Minnewaska Area WIN Academy Educational Oversight to Public Care and Treatment Day Program Alternative School No Other KG 12 2020   grade_7 5.0 0.0 0.0   0.0 0.0     0.0   1.0   5.0 1.0     *   *         *   6.0 5 0 0   0 0     0   1   5 1                 6
1838934 MN Stearns 73 school 2733510 742 Independent Districts and Schools St. Cloud Public School District 273351001640 72 Riverwoods School Non-Residential Educational Oversight to Public Care and Treatment Day Program Alternative School No Other KG 12 2020   grade_7 6.0 6.0 0.0   0.0 0.0     0.0   2.0   12.0 2.0     0.0   3.0         *   14.0 6 6 0   0 0     0   2   12 2     0 3         14
1838926 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 2020   grade_7 3.0 0.0 0.0   0.0 0.0     0.0   0.0   0.0 3.0     *   *         *   3.0 3 0 0   0 0     0   0   0 3                 3
1838909 MN Ramsey 62 school 2723850 622 Independent Districts and Schools North St. Paul-Maplewood Oakdale Public School District 272385004943 76 PrairieCare Maplewood Educational Oversight to Public Care and Treatment Day Program Alternative School No Other KG 12 2020   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
1838884 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 High 06 12 2020   grade_7 1.0 0.0 0.0   0.0 1.0     0.0   0.0   1.0 1.0     *   *         *   2.0 1 0 0   0 1     0   0   1 1                 2
1838877 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 2020   grade_7 2.0 0.0 1.0   0.0 0.0     0.0   0.0   2.0 1.0     *   *         *   3.0 2 0 1   0 0     0   0   2 1                 3
1838870 MN Olmsted 55 school 2731800 535 Independent Districts and Schools Rochester Public School District 273180004784 220 PrairieCare Educational Oversight to Public Care and Treatment Day Program Alternative School No Other KG 12 2020   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
1838862 MN Mille Lacs 48 school 2730030 477 Independent Districts and Schools Princeton Public School District 273003004863 700 Princeton Educational Options Educational Oversight to Public Care and Treatment Day Program Alternative School No Other KG 12 2020   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
1838844 MN Blue Earth 7 school 2718780 77 Independent Districts and Schools Mankato Public School District 271878005116 375 Prairie Care Mankato Educational Oversight to Public Care and Treatment Day Program Alternative School No Other 02 12 2020   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
1838833 MN Anoka 2 school 2709510 13 Independent Districts and Schools Columbia Heights Public School Dist 270951005164 810 Columbia Academy Anchor Program Educational Oversight to Public Care and Treatment Day Program Alternative School No Middle 06 08 2020   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
1838812 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 2020   grade_7 5.0 0.0 0.0   2.0 0.0     0.0   0.0   5.0 2.0     *   *         *   7.0 5 0 0   2 0     0   0   5 2                 7
1838785 MN Wright 86 school 2700045 938 Special Education Cooperatives Meeker And Wright Special Education 270004502964 16 VILLAGE RANCH ALTERNATIVE PROGRAM Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No High 05 12 2020   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
1838739 MN Hennepin 27 school 2700025 287 Intermediate Districts and Schools Intermediate School District 287 270002504880 533 Paragon Academy Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No High 05 12 2020   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
1838731 MN Hennepin 27 school 2700025 287 Intermediate Districts and Schools Intermediate School District 287 270002503549 522 OMEGON Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No High 07 12 2020   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
1838717 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124001948 697 MPS Metro C Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No Other KG 12 2020   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
1838685 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 2020   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
1838674 MN Saint Louis 69 school 2711040 709 Independent Districts and Schools Duluth Public School District 271104001589 605 Arrowhead Academy Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No Other 04 12 2020   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
1838667 MN Saint Louis 69 school 2711040 709 Independent Districts and Schools Duluth Public School District 271104001577 580 Rockridge Academy Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No Other 04 12 2020   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
1838659 MN Saint Louis 69 school 2711040 709 Independent Districts and Schools Duluth Public School District 271104001574 575 Chester Creek Academy Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No Other KG 12 2020   grade_7 3.0 1.0 0.0   0.0 0.0     0.0   1.0   5.0 0.0     *   *         *   5.0 3 1 0   0 0     0   1   5 0                 5
1838646 MN Saint Louis 69 school 2711040 709 Independent Districts and Schools Duluth Public School District 271104001562 81 Merritt Creek Academy Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No Other KG 12 2020   grade_7 3.0 1.0 1.0   1.0 0.0     0.0   0.0   4.0 2.0     *   *         *   6.0 3 1 1   1 0     0   0   4 2                 6
1838634 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 2020   grade_7 0.0 3.0 0.0   0.0 0.0     0.0   0.0   3.0 0.0     *   *         *   3.0 0 3 0   0 0     0   0   3 0                 3
1838631 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 2020   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
1838608 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 2020   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
1838600 MN Mille Lacs 48 school 2725050 480 Independent Districts and Schools Onamia Public School District 272505000957 30 Mille Lacs Academy (Nexus) Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No High 05 12 2020   grade_7 2.0 2.0 0.0   1.0 0.0     0.0   1.0   6.0 0.0     *   *         *   6.0 2 2 0   1 0     0   1   6 0                 6
1838592 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 2020   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
1838585 MN Kandiyohi 34 school 2742720 347 Independent Districts and Schools Willmar Public School District 274272004674 941 Lake Park School Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No Other 04 12 2020   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
1838578 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 2020   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
1838571 MN Itasca 31 school 2713170 318 Independent Districts and Schools Grand Rapids Public School District 271317003073 227 ITASKIN EDUCATION CENTER Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No Other KG 12 2020   grade_7 3.0 0.0 2.0   1.0 0.0     0.0   1.0   5.0 2.0     *   *         *   7.0 3 0 2   1 0     0   1   5 2                 7
1838551 MN Clay 14 school 2721420 152 Independent Districts and Schools Moorhead Public School District 272142002799 970 West Central Academy-N Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No Other 03 12 2020   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
1838544 MN Clay 14 school 2721420 152 Independent Districts and Schools Moorhead Public School District 272142000413 960 West Central Academy-S Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No Other 04 12 2020   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
1838527 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 2020   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
1838512 MN Anoka 2 school 2708100 12 Independent Districts and Schools Centennial Public School District 270810004620 161 Pines School - RJC Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No High 07 12 2020   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
1838506 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 High 07 12 2020   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
1838493 MN Lesueur 40 school 2700261 4151 Charter Schools EdVisions Off Campus School 270026103319 10 EdVisions Off Campus School Distance Learning Program OLL (State approved) Regular School Yes High 07 12 2020   grade_7 11.0 1.0 0.0   0.0 0.0     0.0   0.0   4.0 8.0     0.0   0.0     2.0   2.0   12.0 11 1 0   0 0     0   0   4 8     0 0   2 2   12
1838476 MN Dakota 19 school 2700193 4082 Charter Schools BlueSky Charter School 270019303146 10 BlueSky Charter School Distance Learning Program OLL (State approved) Regular School Yes High 07 12 2020   grade_7 8.0 0.0 1.0   0.0 0.0     0.0   2.0   6.0 5.0     0.0   0.0     7.0   2.0   11.0 8 0 1   0 0     0   2   6 5     0 0   7 2   11
1838469 MN Crow Wing 18 school 2700218 4059 Charter Schools Crosslake Community Charter School 270021804782 20 Crosslake Community High School Distance Learning Program OLL (State approved) Regular School Yes High 05 12 2020   grade_7 4.0 0.0 1.0   0.0 0.0     0.0   0.0   4.0 1.0     *   *         *   5.0 4 0 1   0 0     0   0   4 1                 5
1838460 MN Ramsey 62 school 2700138 4025 Charter Schools Cyber Village Academy 270013802717 10 Cyber Village Academy Distance Learning Program OLL (State approved) Regular School Yes Other KG 12 2020   grade_7 12.0 0.0 1.0   0.0 2.0     0.0   2.0   10.0 7.0     0.0   0.0     4.0   8.0   17.0 12 0 1   0 2     0   2   10 7     0 0   4 8   17
1838446 MN Ramsey 62 school 2700117 4017 Charter Schools Minnesota Transitions Charter School 270011703694 18 Minnesota Connections Academy Distance Learning Program OLL (State approved) Regular School Yes Other KG 12 2020   grade_7 153.0 27.0 16.0   1.0 4.0     0.0   20.0   105.0 116.0     *   2.0     119.0   42.0   221.0 153 27 16   1 4     0   20   105 116       2   119 42   221
1838432 MN Hennepin 27 school 2700117 4017 Charter Schools Minnesota Transitions Charter School 270011703264 14 Minnesota Virtual Schools Distance Learning Program OLL (State approved) Regular School Yes High 06 12 2020   grade_7 5.0 1.0 1.0   0.0 0.0     0.0   1.0   3.0 5.0     *   *         *   8.0 5 1 1   0 0     0   1   3 5                 8
1838416 MN Wabasha 79 school 2741060 811 Independent Districts and Schools Wabasha-Kellogg Public School Dist. 274106005263 80 Falcon View Connections Academy Distance Learning Program OLL (State approved) Regular School No Other KG 10 2020   grade_7 2.0 0.0 0.0   0.0 0.0     0.0   0.0   2.0 0.0     *   *         *   2.0 2 0 0   0 0     0   0   2 0                 2
1838397 MN Otter Tail 56 school 2711880 544 Independent Districts and Schools Fergus Falls Public School District 271188003645 340 iQ Academy Minnesota Distance Learning Program OLL (State approved) Regular School No Other KG 12 2020   grade_7 47.0 4.0 4.0   0.0 2.0     0.0   3.0   36.0 24.0     0.0   2.0     20.0   9.0   60.0 47 4 4   0 2     0   3   36 24     0 2   20 9   60
1838383 MN Nobles 53 school 2744160 518 Independent Districts and Schools Worthington Public School District 274416004676 20 Worthington 518 (Virtual Instruction By Excellence) Distance Learning Program OLL (State approved) Regular School No Other KG 12 2020   grade_7 28.0 3.0 2.0   0.0 2.0     0.0   1.0   23.0 13.0     0.0   0.0         *   36.0 28 3 2   0 2     0   1   23 13     0 0         36
1838358 MN Houston 28 school 2714280 294 Independent Districts and Schools Houston Public School District 271428003187 12 Minnesota Virtual Academy Distance Learning Program OLL (State approved) Regular School No Other KG 12 2020   grade_7 69.0 18.0 13.0   1.0 4.0     0.0   13.0   63.0 55.0     1.0   1.0     43.0   22.0   118.0 69 18 13   1 4     0   13   63 55     1 1   43 22   118
1838344 MN Hennepin 27 school 2706240 286 Independent Districts and Schools Brooklyn Center School District 270624004306 221 Insight School of Minnesota Distance Learning Program OLL (State approved) Regular School No High 06 12 2020   grade_7 17.0 2.0 3.0   0.0 1.0     0.0   4.0   11.0 16.0     *   *         *   27.0 17 2 3   0 1     0   4   11 16                 27
1838336 MN Dakota 19 school 2717780 194 Independent Districts and Schools Lakeville Public School District 271778004309 90 Link12 Lakeville Distance Learning Program OLL (State approved) Regular School No Other KG 12 2020   grade_7 4.0 0.0 0.0   0.0 0.0     0.0   1.0   4.0 1.0     *   *         *   5.0 4 0 0   0 0     0   1   4 1                 5
1838311 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 2020   grade_7 2.0 0.0 1.0   0.0 0.0     0.0   0.0   2.0 1.0     *   *         *   3.0 2 0 1   0 0     0   0   2 1                 3
1838293 MN Carver 10 school 2700420 288 Intermediate Districts and Schools Southwest Metro Intermediate 288 270042005204 36 Prairie Care Hospital/Medical/Partial Hospitalization Program Alternative School No Other KG 12 2020   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
1838280 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 2020   grade_7 3.0 0.0 0.0   0.0 0.0     0.0   0.0   2.0 1.0     *   *         *   3.0 3 0 0   0 0     0   0   2 1                 3
1838248 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 2020   grade_7 2.0 0.0 1.0   0.0 0.0     0.0   0.0   1.0 2.0     *   *         *   3.0 2 0 1   0 0     0   0   1 2                 3
1838222 MN Ramsey 62 school 2733840 625 Independent Districts and Schools St. Paul Public School District 273384001053 7 Home/Hospital Instruction Hospital/Medical/Partial Hospitalization Program Alternative School No Other PK 12 2020   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
1838200 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 2020   grade_7 3.0 0.0 0.0   0.0 0.0     0.0   0.0   3.0 0.0     *   *         *   3.0 3 0 0   0 0     0   0   3 0                 3
1838190 MN Morrison 49 school 2700073 6979 Education Districts Mid State Education District 270007305181 70 WIN-Middle School Special Education Special Education School No Middle 06 09 2020   grade_7 2.0 0.0 0.0   1.0 0.0     0.0   0.0   2.0 1.0     *   *         *   3.0 2 0 0   1 0     0   0   2 1                 3
1838172 MN Morrison 49 school 2700073 6979 Education Districts Mid State Education District 270007303304 10 SUN Program Special Education Special Education School No Other PK 12 2020   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
1838152 MN Stearns 73 school 2700071 6383 Education Districts Benton-Stearns Education District 270007102403 10 Benton-Stearns Education District Special Education Special Education School No Other PK 12 2020   grade_7 1.0 0.0 0.0   0.0 0.0     0.0   2.0   3.0 0.0     *   *         *   3.0 1 0 0   0 0     0   2   3 0                 3
1838140 MN Goodhue 25 school 2791443 6051 Education Districts Goodhue County Education District 279144302399 10 Reach Programs Special Education Special Education School No Other PK 12 2020   grade_7 6.0 0.0 1.0   0.0 0.0     0.0   0.0   6.0 1.0     *   *         *   7.0 6 0 1   0 0     0   0   6 1                 7
1838121 MN Brown 8 school 2791353 6049 Education Districts River Bend Education District 279135305192 55 Raptor Program Special Education Special Education School No Other 02 12 2020   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
1838114 MN Brown 8 school 2791353 6049 Education Districts River Bend Education District 279135305074 50 R.I.S.E. Program Special Education Special Education School No Other KG 12 2020   grade_7 2.0 0.0 0.0   0.0 0.0     0.0   0.0   1.0 1.0     *   *         *   2.0 2 0 0   0 0     0   0   1 1                 2
1838095 MN Brown 8 school 2791353 6049 Education Districts River Bend Education District 279135304366 35 Imprints Program Special Education Special Education School No Other KG 12 2020   grade_7 3.0 0.0 0.0   0.0 0.0     0.0   0.0   3.0 0.0     *   *         *   3.0 3 0 0   0 0     0   0   3 0                 3
1838074 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 2020   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
1838057 MN Douglas 21 school 2700016 6014 Education Districts Runestone Area Ed. District 270001604931 90 SOAR Special Education Special Education School No Middle 06 08 2020   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
1838042 MN Wabasha 79 school 2700055 6013 Education Districts Hiawatha Valley Ed. District 270005504535 31 Sail Program Special Education Special Education School No Other PK 12 2020   grade_7 2.0 0.0 1.0   0.0 0.0     0.0   0.0   2.0 1.0     *   *         *   3.0 2 0 1   0 0     0   0   2 1                 3
1838027 MN Olmsted 55 school 2700054 6012 Education Districts Zumbro Education District 270005402500 30 Zumbro Ed. Dist. Futures/Choice Special Education Special Education School No Other KG 12 2020   grade_7 3.0 0.0 0.0   0.0 0.0     0.0   0.0   3.0 0.0     *   *         *   3.0 3 0 0   0 0     0   0   3 0                 3
1838013 MN Pine 58 school 2700015 6009 Education Districts St. Croix River Education District 270001505145 80 Vision Special Education Special Education School No Other KG 12 2020   grade_7 3.0 0.0 0.0   0.0 0.0     0.0   0.0   1.0 2.0     *   *         *   3.0 3 0 0   0 0     0   0   1 2                 3
1838004 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 2020   grade_7 0.0 0.0 0.0   0.0 1.0     0.0   0.0   1.0 0.0     *   *         *   1.0 0 0 0   0 1     0   0   1 0                 1
1837989 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 2020   grade_7 4.0 0.0 0.0   0.0 0.0     0.0   0.0   4.0 0.0     *   *         *   4.0 4 0 0   0 0     0   0   4 0                 4
1837980 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 2020   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
1837971 MN Otter Tail 56 school 2700014 6004 Education Districts Freshwater Ed. Dist. 270001403297 40 White Pine Academy Special Education Special Education School No High 05 12 2020   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
1837956 MN Ramsey 62 school 2700028 4005 Charter Schools Metro Deaf School 270002802341 10 Metro Deaf School Special Education Special Education School Yes Other PK 12 2020   grade_7 5.0 4.0 0.0   0.0 3.0     0.0   0.0   4.0 8.0     0.0   0.0     8.0   *   12.0 5 4 0   0 3     0   0   4 8     0 0   8     12
1837943 MN Chippewa 12 school 2700086 991 Service Cooperative (ECSU Region) Region 6 and 8-SW/WC Service Cooperative 270008605170 61 SWWC ELC - Montevideo Special Education Special Education School No Other PK 12 2020   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
1837932 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 2020   grade_7 2.0 0.0 1.0   0.0 0.0     0.0   1.0   4.0 0.0     *   *         *   4.0 2 0 1   0 0     0   1   4 0                 4
1837919 MN Pipestone 59 school 2700086 991 Service Cooperative (ECSU Region) Region 6 and 8-SW/WC Service Cooperative 270008604353 29 SWWC ELC - Pipestone Special Education Special Education School No Other KG 12 2020   grade_7 1.0 0.0 0.0   0.0 1.0     0.0   0.0   0.0 2.0     *   *         *   2.0 1 0 0   0 1     0   0   0 2                 2
1837908 MN Meeker 47 school 2700086 991 Service Cooperative (ECSU Region) Region 6 and 8-SW/WC Service Cooperative 270008604215 27 SWWC ELC - Cosmos Special Education Special Education School No Other KG 12 2020   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
1837897 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 2020   grade_7 2.0 0.0 0.0   0.0 1.0     0.0   0.0   3.0 0.0     *   *         *   3.0 2 0 0   0 1     0   0   3 0                 3

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