Data source: Big Local News · About: Big Local

694 rows where grade = "grade_7", state = "MN" and year = 2021 sorted by total

View and edit SQL

year

  • 2021 · 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
1712058 MN Lincoln 41 school 2717460 404 Independent Districts and Schools Lake Benton Public School District 271746000802 20 Lake Benton Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 1 0 0   0 0     0   0   0 1     *   *     *   *   1 1 0 0   0 0     0   0   0 1                 1
1712951 MN Ramsey 62 school 2702264 916 Intermediate Districts and Schools Northeast Metro 916 270226404818 29 Assessment Center Secondary School (Grades 7-12) Regular School No Other KG 12 2021   grade_7 0 0 1   0 0     0   0   0 1     *   *     *   *   1 0 0 1   0 0     0   0   0 1                 1
1713044 MN Cass 11 school 2700191 4080 Charter Schools Pillager Area Charter School 270019103144 10 PILLAGER AREA CHARTER SCHOOL Secondary School (Grades 7-12) Regular School Yes High 07 12 2021   grade_7 1 0 0   0 0     0   0   1 0     *   *     *   *   1 1 0 0   0 0     0   0   1 0                 1
1722630 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 2021   grade_7 0 0 0   1 0     0   0   1 0     *   *     *   *   1 0 0 0   1 0     0   0   1 0                 1
1722801 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 2021   grade_7 0 0 0   0 0     0   1   0 1     *   *     *   *   1 0 0 0   0 0     0   1   0 1                 1
1722827 MN Becker 3 school 2710230 22 Independent Districts and Schools Detroit Lakes Public School District 271023003061 32 Detroit Lakes Middle ALC Public Area Learning Center ALC (State approved) Alternative School No Middle 06 08 2021   grade_7 0 0 1   0 0     0   0   1 0     *   *     *   *   1 0 0 1   0 0     0   0   1 0                 1
1723015 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 2021   grade_7 1 0 0   0 0     0   0   0 1     *   *     *   *   1 1 0 0   0 0     0   0   0 1                 1
1723157 MN Sherburne 71 school 2711370 728 Independent Districts and Schools Elk River School District 271137005158 610 Ivan Sand Middle School ALC Public Area Learning Center ALC (State approved) Alternative School No Middle 06 08 2021   grade_7 1 0 0   0 0     0   0   0 1     *   *     *   *   1 1 0 0   0 0     0   0   0 1                 1
1723164 MN Stearns 73 school 2709440 750 Independent Districts and Schools Rocori Public School District 270944004629 70 Rocori ALC Public Area Learning Center ALC (State approved) Alternative School No High 07 12 2021   grade_7 1 0 0   0 0     0   0   0 1     *   *     *   *   1 1 0 0   0 0     0   0   0 1                 1
1723383 MN Saint Louis 69 school 2700224 6076 Miscellaneous Cooperatives Northland Learning Center 270022403477 10 Northland Learning Center 010 Public Area Learning Center ALC (State approved) Alternative School No Other PK 12 2021   grade_7 0 1 0   0 0     0   0   0 1     *   *     *   *   1 0 1 0   0 0     0   0   0 1                 1
1723438 MN Beltrami 4 school 2704440 31 Independent Districts and Schools Bemidji Public School District 270444004194 70 Lakeside Learning Center Special Education Special Education School No High 06 12 2021   grade_7 0 0 0   1 0     0   0   1 0     *   *     *   *   1 0 0 0   1 0     0   0   1 0                 1
1723656 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 2021   grade_7 0 0 1   0 0     0   0   1 0     *   *     *   *   1 0 0 1   0 0     0   0   1 0                 1
1723846 MN Isanti 30 school 2707410 911 Independent Districts and Schools Cambridge-Isanti Public School District 270741005198 701 Brookside Academy Special Education Special Education School No Other KG 12 2021   grade_7 1 0 0   0 0     0   0   1 0     *   *     *   *   1 1 0 0   0 0     0   0   1 0                 1
1724060 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 2021   grade_7 1 0 0   0 0     0   0   1 0     *   *     *   *   1 1 0 0   0 0     0   0   1 0                 1
1724074 MN Dakota 19 school 2700026 917 Intermediate Districts and Schools Intermediate School District 917 270002604371 700 TEA Special Education Special Education School No Other PK 12 2021   grade_7 1 0 0   0 0     0   0   0 1     *   *     *   *   1 1 0 0   0 0     0   0   0 1                 1
1724084 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 PK 12 2021   grade_7 0 1 0   0 0     0   0   0 1     *   *     *   *   1 0 1 0   0 0     0   0   0 1                 1
1724090 MN Clay 14 school 2700040 397 Special Education Cooperatives Lake Agassiz Education Cooperative 270004003643 11 Intensive Interagency Program Special Education Special Education School No High 07 12 2021   grade_7 1 0 0   0 0     0   0   0 1     *   *     *   *   1 1 0 0   0 0     0   0   0 1                 1
1724154 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 08 2021   grade_7 0 0 1   0 0     0   0   1 0     *   *     *   *   1 0 0 1   0 0     0   0   1 0                 1
1724224 MN Mower 50 school 2700327 6083 Special Education Cooperatives Southern MN Education Consortium 270032705231 150 RESET Special Education Special Education School No Other 01 12 2021   grade_7 1 0 0   0 0     0   0   1 0     *   *     *   *   1 1 0 0   0 0     0   0   1 0                 1
1724295 MN Rice 66 school 2700424 6094 Special Education Cooperatives Cannon Valley Special Education Cooperative 270042405068 20 Laura Baker SUN Program Special Education Special Education School No Other PK 12 2021   grade_7 1 0 0   0 0     0   0   1 0     *   *     *   *   1 1 0 0   0 0     0   0   1 0                 1
1724318 MN Otter Tail 56 school 2700083 926 Service Cooperative (ECSU Region) Region 4-Lakes Country Service Coop 270008305103 30 Lakes Country Academy - FF Special Education Special Education School No Other KG 12 2021   grade_7 0 1 0   0 0     0   0   1 0     *   *     *   *   1 0 1 0   0 0     0   0   1 0                 1
1724369 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 2021   grade_7 1 0 0   0 0     0   0   1 0     *   *     *   *   1 1 0 0   0 0     0   0   1 0                 1
1724430 MN Wadena 80 school 2700014 6004 Education Districts Freshwater Education District 270001404821 50 Elm Tree Academy Special Education Special Education School No Other 02 12 2021   grade_7 1 0 0   0 0     0   0   1 0     *   *     *   *   1 1 0 0   0 0     0   0   1 0                 1
1724462 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 2021   grade_7 1 0 0   0 0     0   0   1 0     *   *     *   *   1 1 0 0   0 0     0   0   1 0                 1
1724512 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 2021   grade_7 1 0 0   0 0     0   0   1 0     *   *     *   *   1 1 0 0   0 0     0   0   1 0                 1
1724597 MN Stearns 73 school 2700071 6383 Education Districts Benton-Stearns Education District 270007104581 40 Benton-Stearns Education District - ASD Program Special Education Special Education School No Other 04 12 2021   grade_7 1 0 0   0 0     0   0   1 0     *   *     *   *   1 1 0 0   0 0     0   0   1 0                 1
1724959 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 2021   grade_7 0 0 0   1 0     0   0   1 0     *   *     *   *   1 0 0 0   1 0     0   0   1 0                 1
1724966 MN Beltrami 4 school 2704440 31 Independent Districts and Schools Bemidji Public School District 270444004315 190 Oshki Manidoo Center Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No High 07 12 2021   grade_7 0 0 0   1 0     0   0   1 0     *   *     *   *   1 0 0 0   1 0     0   0   1 0                 1
1724977 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 2021   grade_7 0 0 0   1 0     0   0   0 1     *   *     *   *   1 0 0 0   1 0     0   0   0 1                 1
1725046 MN Olmsted 55 school 2731800 535 Independent Districts and Schools Rochester Public School District 273180002823 217 Care & Treatment JDC/Von Wald Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No High 05 12 2021   grade_7 1 0 0   0 0     0   0   1 0     *   *     *   *   1 1 0 0   0 0     0   0   1 0                 1
1725052 MN Polk 60 school 2709720 593 Independent Districts and Schools Crookston Public School District 270972001030 100 Northern Lights Academy Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No High 06 12 2021   grade_7 1 0 0   0 0     0   0   1 0     *   *     *   *   1 1 0 0   0 0     0   0   1 0                 1
1725099 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 2021   grade_7 1 0 0   0 0     0   0   0 1     *   *     *   *   1 1 0 0   0 0     0   0   0 1                 1
1725134 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 2021   grade_7 0 1 0   0 0     0   0   0 1     *   *     *   *   1 0 1 0   0 0     0   0   0 1                 1
1725155 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 07 12 2021   grade_7 1 0 0   0 0     0   0   0 1     *   *     *   *   1 1 0 0   0 0     0   0   0 1                 1
1725198 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 2021   grade_7 0 1 0   0 0     0   0   1 0     *   *     *   *   1 0 1 0   0 0     0   0   1 0                 1
1725210 MN Wright 86 school 2700045 938 Special Education Cooperatives Meeker And Wright Special Education 270004505005 26 Sholund School for Girls Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No High 05 12 2021   grade_7 0 0 0   0 0     0   1   0 1     *   *     *   *   1 0 0 0   0 0     0   1   0 1                 1
1725255 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 KG 12 2021   grade_7 1 0 0   0 0     0   0   0 1     *   *     *   *   1 1 0 0   0 0     0   0   0 1                 1
1725278 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 2021   grade_7 0 0 1   0 0     0   0   1 0     *   *     *   *   1 0 0 1   0 0     0   0   1 0                 1
1725344 MN Hennepin 27 school 2700025 287 Intermediate Districts and Schools Intermediate School District 287 270002504533 527 Headway Academy Educational Oversight to Public Care and Treatment Day Program Alternative School No High 07 12 2021   grade_7 0 0 0   0 0     0   1   0 1     *   *     *   *   1 0 0 0   0 0     0   1   0 1                 1
1725386 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 2021   grade_7 1 0 0   0 0     0   0   0 1     *   *     *   *   1 1 0 0   0 0     0   0   0 1                 1
1713016 MN Houston 28 school 2700178 4054 Charter Schools La Crescent Montessori & STEM School 270017804750 20 La Crescent Secondary Montessori & STEM Academy Secondary School (Grades 7-12) Regular School Yes High 07 12 2021   grade_7 10 0 0   0 0     0   0   4 6     0.0   0.0     0.0   1.0   10 10 0 0   0 0     0   0   4 6     0 0   0 1   10
1713023 MN Winona 85 school 2700221 4064 Charter Schools Riverway Learning Community Charter 270022103136 20 Riverway Secondary Secondary School (Grades 7-12) Regular School Yes High 07 12 2021   grade_7 7 0 0   0 0     0   3   10 0     *   *     7.0   5.0   10 7 0 0   0 0     0   3   10 0           7 5   10
1721652 MN Ramsey 62 school 2700438 4258 Charter Schools The Journey School 270043805290 20 The Journey School Middle Middle School (Grades 5-8) Regular School Yes Middle 07 07 2021   grade_7 3 1 4   0 0     0   2   5 5     1.0   0.0     *   1.0   10 3 1 4   0 0     0   2   5 5     1 0     1   10
1722981 MN Kanabec 33 school 2721480 332 Independent Districts and Schools Mora Public School District 272148004472 51 Mora Middle Level ALC Public Area Learning Center ALC (State approved) Alternative School No Middle 06 08 2021   grade_7 7 0 1   0 0     0   2   8 2     0.0   0.0     1.0   0.0   10 7 0 1   0 0     0   2   8 2     0 0   1 0   10
1723705 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 2021   grade_7 2 6 1   0 1     0   0   8 2     4.0   1.0     6.0   *   10 2 6 1   0 1     0   0   8 2     4 1   6     10
1724012 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 2021   grade_7 5 0 2   1 0     0   2   10 0     0.0   0.0     5.0   *   10 5 0 2   1 0     0   2   10 0     0 0   5     10
1712408 MN Stearns 73 school 2732850 743 Independent Districts and Schools Sauk Centre Public School District 273285001429 30 Sauk Centre Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 89 0 7   0 1     0   3   44 56     5.0   0.0     26.0   9.0   100 89 0 7   0 1     0   3   44 56     5 0   26 9   100
1712388 MN Stearns 73 school 2714190 738 Independent Districts and Schools Holdingford Public School District 271419000733 2 Holdingford Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 98 1 1   0 0     0   1   50 51     1.0   0.0     19.0   12.0   101 98 1 1   0 0     0   1   50 51     1 0   19 12   101
1720765 MN Chippewa 12 school 2721320 129 Independent Districts and Schools Montevideo Public School District 272132001071 30 Montevideo Middle Middle School (Grades 5-8) Regular School No Middle 04 07 2021   grade_7 73 2 15   2 0     3   6   50 51     10.0   0.0     42.0   18.0   101 73 2 15   2 0     3   6   50 51     10 0   42 18   101
1711752 MN Carlton 9 school 2738880 99 Independent Districts and Schools Esko Public School District 273888001681 1 Lincoln Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 95 0 2   0 0     0   7   56 48     0.0   0.0     7.0   17.0   104 95 0 2   0 0     0   7   56 48     0 0   7 17   104
1712257 MN Polk 60 school 2709720 593 Independent Districts and Schools Crookston Public School District 270972000412 90 Crookston Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 70 0 22   7 0     0   5   57 47     *   *     *   *   104 70 0 22   7 0     0   5   57 47                 104
1712487 MN Wabasha 79 school 2717520 813 Independent Districts and Schools Lake City Public School District 271752000804 40 Lincoln Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 93 0 7   0 1     0   3   56 48     3.0   0.0     19.0   13.0   104 93 0 7   0 1     0   3   56 48     3 0   19 13   104
1713112 MN Ramsey 62 school 2700246 4132 Charter Schools Twin Cities Academy 270024603307 10 Twin Cities Academy Secondary School (Grades 7-12) Regular School Yes High 06 12 2021   grade_7 22 28 27   0 20     0   9   52 54     18.0   2.0     61.0   16.0   106 22 28 27   0 20     0   9   52 54     18 2   61 16   106
1720737 MN Carver 10 school 2741910 111 Independent Districts and Schools Watertown-Mayer Public School District 274191000024 841 Watertown-Mayer Middle Middle School (Grades 5-8) Regular School No Middle 05 08 2021   grade_7 101 2 2   2 0     0   1   60 48     2.0   0.0     21.0   21.0   108 101 2 2   2 0     0   1   60 48     2 0   21 21   108
1719623 MN Crow Wing 18 school 2700218 4059 Charter Schools Crosslake Community Charter School 270021803475 10 Crosslake Community Charter School Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2021   grade_7 11 0 0   0 0     0   0   5 6     0.0   0.0     5.0   1.0   11 11 0 0   0 0     0   0   5 6     0 0   5 1   11
1723948 MN Scott 70 school 2700420 288 Intermediate Districts and Schools Southwest Metro Intermediate 288 270042005038 12 SW Metro Level 4 Programs Special Education Special Education School No Other KG 12 2021   grade_7 10 0 1   0 0     0   0   10 1     0.0   0.0     6.0   *   11 10 0 1   0 0     0   0   10 1     0 0   6     11
1723999 MN Washington 82 school 2702264 916 Intermediate Districts and Schools Northeast Metro 916 270226404951 58 Pankalo Education Center Special Education Special Education School No Elementary KG 08 2021   grade_7 5 6 0   0 0     0   0   8 3     2.0   1.0     6.0   *   11 5 6 0   0 0     0   0   8 3     2 1   6     11
1724688 MN Hennepin 27 school 2700025 287 Intermediate Districts and Schools Intermediate School District 287 270002504532 531 Prairie Care Brooklyn Park - IHP Hospital/Medical/Partial Hospitalization Program Alternative School No Other KG 12 2021   grade_7 7 1 1   0 2     0   0   0 11     0.0   0.0     *   4.0   11 7 1 1   0 2     0   0   0 11     0 0     4   11
1725532 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 2021   grade_7 8 1 0   0 0     0   2   8 3     0.0   0.0     6.0   6.0   11 8 1 0   0 0     0   2   8 3     0 0   6 6   11
1725546 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 2021   grade_7 9 0 0   1 0     0   1   4 7     0.0   0.0     9.0   2.0   11 9 0 0   1 0     0   1   4 7     0 0   9 2   11
1713091 MN Washington 82 school 2700358 4116 Charter Schools Lakes International Language Academy 270035804828 20 Lakes International Language Academy-Headwaters Campus Secondary School (Grades 7-12) Regular School Yes High 06 12 2021   grade_7 90 2 10   1 3     0   5   58 53     0.0   0.0     11.0   18.0   111 90 2 10   1 3     0   5   58 53     0 0   11 18   111
1725406 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 2021   grade_7 100 2 6   1 1     1   0   59 52     *   0.0     *   17.0   111 100 2 6   1 1     1   0   59 52       0     17   111
1725436 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 2021   grade_7 82 0 24   1 1     0   3   65 46     7.0   0.0     30.0   24.0   111 82 0 24   1 1     0   3   65 46     7 0   30 24   111
1711971 MN Kanabec 33 school 2721480 332 Independent Districts and Schools Mora Public School District 272148000944 40 Mora Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 102 2 4   1 0     0   3   43 69     0.0   0.0     31.0   18.0   112 102 2 4   1 0     0   3   43 69     0 0   31 18   112
1712123 MN Morrison 49 school 2728320 484 Independent Districts and Schools Pierz Public School District 272832001252 30 Healy Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 109 0 2   0 0     0   1   53 59     0.0   0.0     23.0   11.0   112 109 0 2   0 0     0   1   53 59     0 0   23 11   112
1721000 MN Hubbard 29 school 2728080 309 Independent Districts and Schools Park Rapids Public School District 272808001236 80 Park Rapids Area Century Middle Middle School (Grades 5-8) Regular School No Middle 05 08 2021   grade_7 93 1 9   5 0     0   6   60 54     *   0.0     54.0   27.0   114 93 1 9   5 0     0   6   60 54       0   54 27   114
1721557 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 2021   grade_7 0 114 0   0 0     0   0   42 72     45.0   0.0     *   6.0   114 0 114 0   0 0     0   0   42 72     45 0     6   114
1719121 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124000969 121 Lake Harriet Upper School Elementary School (Grades PK-6) Regular School No Middle 04 08 2021   grade_7 102 2 5   0 3     0   3   52 63     3.0   0.0     6.0   9.0   115 102 2 5   0 3     0   3   52 63     3 0   6 9   115
1720982 MN Hennepin 27 school 2706240 286 Independent Districts and Schools Brooklyn Center School District 270624005130 11 Brooklyn Center Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 7 53 33   1 19     0   4   55 62     24.0   2.0     99.0   19.0   117 7 53 33   1 19     0   4   55 62     24 2   99 19   117
1713104 MN Hennepin 27 school 2700364 4122 Charter Schools Eagle Ridge Academy Charter School 270036404108 10 Eagle Ridge Academy Charter School Secondary School (Grades 7-12) Regular School Yes High 06 12 2021   grade_7 50 34 3   0 30     0   2   57 62     11.0   0.0     30.0   5.0   119 50 34 3   0 30     0   2   57 62     11 0   30 5   119
1711667 MN Anoka 2 school 2733330 16 Independent Districts and Schools Spring Lake Park Public Schools 273333004658 788 Secondary Lighthouse Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 11 1 0   0 0     0   0   6 6     0.0   0.0     1.0   0.0   12 11 1 0   0 0     0   0   6 6     0 0   1 0   12
1712008 MN Koochiching 36 school 2732700 363 Independent Districts and Schools South Koochiching School District 273270001413 60 Indus Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 12 0 0   0 0     0   0   5 7     0.0   0.0     5.0   3.0   12 12 0 0   0 0     0   0   5 7     0 0   5 3   12
1712015 MN Koochiching 36 school 2732700 363 Independent Districts and Schools South Koochiching School District 273270001416 70 Northome Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 8 0 0   4 0     0   0   5 7     0.0   0.0     6.0   3.0   12 8 0 0   4 0     0   0   5 7     0 0   6 3   12
1712886 MN Freeborn 24 school 2700148 2886 Independent Districts and Schools Glenville-Emmons School District 270014800635 300 Glenville-Emmons Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 11 1 0   0 0     0   0   6 6     0.0   0.0     2.0   1.0   12 11 1 0   0 0     0   0   6 6     0 0   2 1   12
1713060 MN Rice 66 school 2700355 4091 Charter Schools Arcadia Charter School 270035504151 10 Arcadia Charter School Secondary School (Grades 7-12) Regular School Yes High 06 12 2021   grade_7 9 0 2   0 0     0   1   8 4     0.0   0.0     4.0   5.0   12 9 0 2   0 0     0   1   8 4     0 0   4 5   12
1719982 MN Hennepin 27 school 2700278 4162 Charter Schools Southside Family Charter School 270027803617 10 Southside Family Charter School Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2021   grade_7 4 3 2   0 0     0   3   7 5     0.0   0.0     4.0   1.0   12 4 3 2   0 0     0   3   7 5     0 0   4 1   12
1723066 MN Otter Tail 56 school 2711880 544 Independent Districts and Schools Fergus Falls Public School District 271188001021 370 Fergus Falls Area Learning Center Public Area Learning Center ALC (State approved) Alternative School No High 05 12 2021   grade_7 8 1 1   0 0     0   2   4 8     0.0   0.0     8.0   1.0   12 8 1 1   0 0     0   2   4 8     0 0   8 1   12
1721037 MN Meeker 47 school 2718210 465 Independent Districts and Schools Litchfield Public School District 271821000838 30 Litchfield Middle School Middle School (Grades 5-8) Regular School No Middle 05 08 2021   grade_7 103 0 11   0 1     0   5   71 49     2.0   0.0     34.0   17.0   120 103 0 11   0 1     0   5   71 49     2 0   34 17   120
1721596 MN Sherburne 71 school 2700276 4160 Charter Schools Spectrum High School 270027605140 30 Spectrum Middle School - Grades 7-8 Middle School (Grades 5-8) Regular School Yes Middle 07 08 2021   grade_7 107 2 6   0 0     0   5   68 52     2.0   0.0     8.0   7.0   120 107 2 6   0 0     0   5   68 52     2 0   8 7   120
1721620 MN Hennepin 27 school 2700333 4199 Charter Schools Parnassus Preparatory Charter School 270033304837 20 Parnassus Preparatory School-Logic Middle School (Grades 5-8) Regular School Yes Middle 05 08 2021   grade_7 45 44 7   0 18     0   6   60 60     6.0   0.0     33.0   9.0   120 45 44 7   0 18     0   6   60 60     6 0   33 9   120
1712235 MN Pine 58 school 2728380 578 Independent Districts and Schools Pine City Public School District 272838001256 20 Pine City Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 104 0 5   1 2     0   10   54 68     0.0   2.0     39.0   14.0   122 104 0 5   1 2     0   10   54 68     0 2   39 14   122
1712294 MN Ramsey 62 school 2733840 625 Independent Districts and Schools St. Paul Public School District 273384001598 225 HUMBOLDT HIGH SCHOOL Secondary School (Grades 7-12) Regular School No High 06 12 2021   grade_7 9 34 26   1 41     0   11   64 58     43.0   *     *   23.0   122 9 34 26   1 41     0   11   64 58     43       23   122
1725426 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 2021   grade_7 116 1 1   0 0     0   5   69 54     *   *     *   *   123 116 1 1   0 0     0   5   69 54                 123
1721498 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124000965 119 Field Community Middle School (Grades 5-8) Regular School No Middle 05 08 2021   grade_7 95 8 10   1 4     1   7   57 69     5.0   0.0     17.0   13.0   126 95 8 10   1 4     1   7   57 69     5 0   17 13   126
1720791 MN Crow Wing 18 school 2728200 186 Independent Districts and Schools Pequot Lakes Public Schools 272820003069 15 Pequot Lakes Middle Middle School (Grades 5-8) Regular School No Middle 05 08 2021   grade_7 123 2 1   1 0     0   1   73 55     0.0   0.0     10.0   15.0   128 123 2 1   1 0     0   1   73 55     0 0   10 15   128
1720883 MN Goodhue 25 school 2728950 255 Independent Districts and Schools Pine Island Public School District 272895004143 15 Pine Island Middle Middle School (Grades 5-8) Regular School No Middle 05 08 2021   grade_7 117 2 7   0 1     0   1   67 61     0.0   0.0     19.0   15.0   128 117 2 7   0 1     0   1   67 61     0 0   19 15   128
1721014 MN Kandiyohi 34 school 2723400 345 Independent Districts and Schools New London-Spicer School District 272340000948 20 New London-Spicer Middle Middle School (Grades 5-8) Regular School No Middle 05 08 2021   grade_7 115 0 12   0 0     0   1   51 77     2.0   1.0     33.0   19.0   128 115 0 12   0 0     0   1   51 77     2 1   33 19   128
1721292 MN Stearns 73 school 2720550 740 Independent Districts and Schools Melrose Public School District 272055003367 20 Melrose Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 96 1 30   0 0     0   1   60 68     10.0   2.0     37.0   19.0   128 96 1 30   0 0     0   1   60 68     10 2   37 19   128
1721383 MN Wright 86 school 2732070 883 Independent Districts and Schools Rockford Public School District 273207001941 3 Rockford Middle Middle School (Grades 5-8) Regular School No Middle 05 08 2021   grade_7 102 7 9   0 2     0   8   64 64     3.0   0.0     25.0   16.0   128 102 7 9   0 2     0   8   64 64     3 0   25 16   128
1721514 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124002581 318 Olson Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 16 77 13   2 12     0   8   60 68     10.0   1.0     86.0   31.0   128 16 77 13   2 12     0   8   60 68     10 1   86 31   128
1712584 MN Mille Lacs 48 school 2720670 912 Independent Districts and Schools Milaca Public School District 272067000924 30 Milaca Secondary High Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 117 1 5   2 1     0   3   61 68     *   *     56.0   32.0   129 117 1 5   2 1     0   3   61 68           56 32   129
1721417 MN Clay 14 school 2710260 2164 Independent Districts and Schools Dilworth-Glyndon-Felton 271026000448 3 Dilworth-Glyndon-Felton Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 112 3 6   1 1     0   6   74 55     0.0   1.0     22.0   20.0   129 112 3 6   1 1     0   6   74 55     0 1   22 20   129
1720279 MN Anoka 2 school 2700390 4224 Charter Schools Star of the North Academy Charter School 270039004759 10 Star of the North Academy Charter School Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2021   grade_7 8 5 0   0 0     0   0   5 8     4.0   0.0     8.0   0.0   13 8 5 0   0 0     0   0   5 8     4 0   8 0   13
1721028 MN Lyon 42 school 2718390 415 Independent Districts and Schools Lynd Public School District 271839004845 40 Lynd Middle School Middle School (Grades 5-8) Regular School No Middle 05 08 2021   grade_7 8 0 5   0 0     0   0   6 7     *   *     11.0   5.0   13 8 0 5   0 0     0   0   6 7           11 5   13
1719527 MN Saint Louis 69 school 2700133 4020 Charter Schools Duluth Public Schools Academy 270013302711 10 North Star Academy Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2021   grade_7 94 7 6   5 1     0   17   66 64     0.0   0.0     50.0   44.0   130 94 7 6   5 1     0   17   66 64     0 0   50 44   130
1720962 MN Hennepin 27 school 2733420 282 Independent Districts and Schools St. Anthony-New Brighton Schools 273342001949 50 St. Anthony Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 81 18 16   1 11     0   6   61 72     11.0   0.0     36.0   12.0   133 81 18 16   1 11     0   6   61 72     11 0   36 12   133
1725439 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 2021   grade_7 125 1 6   0 0     0   1   67 66     2.0   0.0     31.0   18.0   133 125 1 6   0 0     0   1   67 66     2 0   31 18   133
1721135 MN Otter Tail 56 school 2728230 549 Independent Districts and Schools Perham-Dent Public School District 272823002535 20 Prairie Wind Middle Middle School (Grades 5-8) Regular School No Middle 05 08 2021   grade_7 109 3 12   1 0     0   9   75 59     *   *     *   *   134 109 3 12   1 0     0   9   75 59                 134
1720795 MN Scott 70 school 2707290 191 Independent Districts and Schools Burnsville Public School District 270729002639 66 Eagle Ridge Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 46 47 32   0 9     1   4   88 51     16.0   1.0     65.0   34.0   139 46 47 32   0 9     1   4   88 51     16 1   65 34   139
1721510 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124001008 316 Northeast Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2021   grade_7 42 52 29   10 3     0   3   76 63     19.0   2.0     93.0   34.0   139 42 52 29   10 3     0   3   76 63     19 2   93 34   139

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