Data source: Big Local News · About: Big Local

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

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
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
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
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
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
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
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
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
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
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
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
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
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
1893176 MN Scott 70 school 2700420 288 Intermediate Districts and Schools Southwest Metro Intermediate 288 270042005050 865 SW Metro JAF Educational Oversight to Public Residential Care & Treatment (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
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
1893217 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 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
1893227 MN Anoka 2 school 2708100 12 Independent Districts and Schools Centennial Public School District 270810004616 162 Pines School Day Program Miscellaneous Program (assignment is now limited) 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
1893373 MN Swift 76 school 2704470 777 Independent Districts and Schools Benson Public School District 270447003708 112 Benson Day Treatment Educational Oversight to Public Care and Treatment Day 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
1893422 MN Washington 82 school 2702264 916 Intermediate Districts and Schools Northeast Metro 916 270226403646 35 ARIS Educational Oversight to Public Care and Treatment Day Program Alternative 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
1893570 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 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
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
1880272 MN Martin 46 school 2740680 458 Independent Districts and Schools Truman Public School District 274068001693 20 Truman Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_7 10.0 0.0 0.0   0.0 0.0     0.0   0.0   3.0 7.0     0.0   0.0     4.0   1.0   10.0 10 0 0   0 0     0   0   3 7     0 0   4 1   10
1881192 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 2018   grade_7 8.0 0.0 0.0   0.0 0.0     0.0   2.0   4.0 6.0     0.0   0.0     5.0   1.0   10.0 8 0 0   0 0     0   2   4 6     0 0   5 1   10
1887694 MN Nicollet 52 school 2700174 4050 Charter Schools Lafayette Public Charter School 270017403042 10 Lafayette Public Charter School Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2018   grade_7 10.0 0.0 0.0   0.0 0.0     0.0   0.0   6.0 4.0     0.0   0.0     1.0   1.0   10.0 10 0 0   0 0     0   0   6 4     0 0   1 1   10
1891471 MN Dakota 19 school 2732390 196 Independent Districts and Schools Rosemount-Apple Valley-Eagan 273239002517 100 Dakota Ridge School Special Education Special Education School No Other KG 12 2018   grade_7 6.0 2.0 0.0   0.0 0.0     0.0   2.0   6.0 4.0     0.0   0.0     8.0   *   10.0 6 2 0   0 0     0   2   6 4     0 0   8     10
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
1891999 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 2018   grade_7 7.0 2.0 0.0   0.0 0.0     0.0   1.0   8.0 2.0     *   *     *   *   10.0 7 2 0   0 0     0   1   8 2                 10
1879819 MN Aitkin 1 school 2702760 1 Independent Districts and Schools Aitkin Public School District 270276000057 1 Aitkin Secondary School Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_7 93.0 1.0 2.0   0.0 0.0     0.0   4.0   58.0 42.0     1.0   0.0     43.0   17.0   100.0 93 1 2   0 0     0   4   58 42     1 0   43 17   100
1881274 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 2018   grade_7 43.0 21.0 14.0   0.0 10.0     0.0   12.0   45.0 55.0     5.0   0.0     33.0   8.0   100.0 43 21 14   0 10     0   12   45 55     5 0   33 8   100
1887343 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124001866 175 Folwell Arts Magnet Elementary School (Grades PK-6) Regular School No Elementary PK 08 2018   grade_7 11.0 22.0 61.0   3.0 1.0     0.0   2.0   57.0 43.0     34.0   0.0     86.0   19.0   100.0 11 22 61   3 1     0   2   57 43     34 0   86 19   100
1881266 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 2018   grade_7 43.0 31.0 0.0   0.0 23.0     0.0   4.0   43.0 58.0     3.0   0.0     35.0   8.0   101.0 43 31 0   0 23     0   4   43 58     3 0   35 8   101
1880293 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 2018   grade_7 99.0 0.0 3.0   0.0 0.0     0.0   0.0   51.0 51.0     0.0   *     35.0   10.0   102.0 99 0 3   0 0     0   0   51 51     0     35 10   102
1883460 MN Hennepin 27 school 2731780 281 Independent Districts and Schools Robbinsdale Public School District 273178004952 401 The FAIR School - Crystal Elementary School (Grades PK-6) Regular School No Middle 04 08 2018   grade_7 32.0 47.0 9.0   0.0 3.0     1.0   11.0   50.0 53.0     7.0   0.0     57.0   13.0   103.0 32 47 9   0 3     1   11   50 53     7 0   57 13   103
1889428 MN Wright 86 school 2700123 2687 Independent Districts and Schools Howard Lake-Waverly-Winsted 270012303350 86 Howard Lake-Waverly-Winsted Middle School Middle School (Grades 5-8) Regular School No Middle 05 08 2018   grade_7 94.0 0.0 5.0   0.0 0.0     0.0   4.0   47.0 56.0     0.0   0.0     28.0   15.0   103.0 94 0 5   0 0     0   4   47 56     0 0   28 15   103
1889264 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 2018   grade_7 82.0 1.0 21.0   0.0 0.0     0.0   1.0   56.0 49.0     3.0   0.0     42.0   8.0   105.0 82 1 21   0 0     0   1   56 49     3 0   42 8   105
1888751 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 2018   grade_7 89.0 1.0 11.0   0.0 2.0     1.0   3.0   68.0 39.0     5.0   0.0     39.0   19.0   107.0 89 1 11   0 2     1   3   68 39     5 0   39 19   107
1887374 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124000932 190 Andersen Community Elementary School (Grades PK-6) Regular School No Elementary PK 08 2018   grade_7 3.0 33.0 65.0   6.0 1.0     0.0   0.0   52.0 56.0     55.0   6.0     *   20.0   108.0 3 33 65   6 1     0   0   52 56     55 6     20   108
1888976 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 2018   grade_7 12.0 54.0 25.0   1.0 14.0     0.0   3.0   56.0 53.0     *   *     *   *   109.0 12 54 25   1 14     0   3   56 53                 109
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
1879833 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 2018   grade_7 10.0 0.0 0.0   0.0 0.0     0.0   1.0   6.0 5.0     0.0   0.0     2.0   0.0   11.0 10 0 0   0 0     0   1   6 5     0 0   2 0   11
1879868 MN Brown 8 school 2709540 81 Independent Districts and Schools Comfrey Public School District 270954000404 20 Comfrey Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_7 11.0 0.0 0.0   0.0 0.0     0.0   0.0   3.0 8.0     0.0   0.0     4.0   1.0   11.0 11 0 0   0 0     0   0   3 8     0 0   4 1   11
1880265 MN Marshall 45 school 2718920 447 Independent Districts and Schools Grygla Public School District 271892000897 3 Grygla Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_7 11.0 0.0 0.0   0.0 0.0     0.0   0.0   7.0 4.0     0.0   0.0     4.0   3.0   11.0 11 0 0   0 0     0   0   7 4     0 0   4 3   11
1888366 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 2018   grade_7 6.0 3.0 0.0   0.0 2.0     0.0   0.0   10.0 1.0     *   0.0     7.0   2.0   11.0 6 3 0   0 2     0   0   10 1       0   7 2   11
1890737 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 2018   grade_7 4.0 0.0 1.0   1.0 1.0     0.0   4.0   7.0 4.0     *   *     *   *   11.0 4 0 1   1 1     0   4   7 4                 11
1890846 MN Freeborn 24 school 2702970 241 Independent Districts and Schools Albert Lea Public School District 270297002228 350 Albert Lea Area Learning Center Public Area Learning Center ALC (State approved) Alternative School No High 06 12 2018   grade_7 6.0 1.0 3.0   0.0 0.0     0.0   1.0   5.0 6.0     0.0   0.0     9.0   0.0   11.0 6 1 3   0 0     0   1   5 6     0 0   9 0   11
1880426 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 2018   grade_7 74.0 3.0 23.0   3.0 0.0     0.0   10.0   57.0 56.0     5.0   4.0     59.0   28.0   113.0 74 3 23   3 0     0   10   57 56     5 4   59 28   113
1889371 MN Isanti 30 school 2707410 911 Independent Districts and Schools Cambridge-Isanti Public School District 270741003629 302 Isanti Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2018   grade_7 100.0 0.0 8.0   0.0 3.0     0.0   4.0   58.0 57.0     4.0   0.0     45.0   13.0   115.0 100 0 8   0 3     0   4   58 57     4 0   45 13   115
1889005 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 2018   grade_7 106.0 0.0 9.0   0.0 0.0     1.0   0.0   60.0 56.0     1.0   2.0     28.0   18.0   116.0 106 0 9   0 0     1   0   60 56     1 2   28 18   116
1887868 MN Cook 16 school 2700339 4100 Charter Schools Great Expectations 270033904177 10 Great Expectations Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2018   grade_7 12.0 0.0 0.0   0.0 0.0     0.0   0.0   7.0 5.0     0.0   0.0     5.0   4.0   12.0 12 0 0   0 0     0   0   7 5     0 0   5 4   12
1890946 MN Mcleod 43 school 2714970 423 Independent Districts and Schools Hutchinson Public School District 271497003522 75 Hutchinson Middle School A.L.C. Public Area Learning Center ALC (State approved) Alternative School No Middle 06 08 2018   grade_7 11.0 0.0 0.0   0.0 0.0     0.0   1.0   8.0 4.0     0.0   0.0     *   0.0   12.0 11 0 0   0 0     0   1   8 4     0 0     0   12
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
1892409 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 2018   grade_7 3.0 5.0 2.0   0.0 1.0     0.0   1.0   9.0 3.0     0.0   0.0     9.0   *   12.0 3 5 2   0 1     0   1   9 3     0 0   9     12
1893362 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 2018   grade_7 9.0 2.0 0.0   0.0 0.0     0.0   1.0   6.0 6.0     0.0   1.0     *   *   12.0 9 2 0   0 0     0   1   6 6     0 1         12
1881289 MN Sherburne 71 school 2700276 4160 Charter Schools Spectrum High School 270027603615 10 Spectrum High School Secondary School (Grades 7-12) Regular School Yes High 07 12 2018   grade_7 105.0 1.0 4.0   0.0 6.0     0.0   5.0   64.0 57.0     1.0   1.0     20.0   10.0   121.0 105 1 4   0 6     0   5   64 57     1 1   20 10   121
1888785 MN Dakota 19 school 2707290 191 Independent Districts and Schools Burnsville Public School District 270729000295 15 John Metcalf Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2018   grade_7 54.0 24.0 16.0   1.0 15.0     0.0   11.0   58.0 63.0     *   3.0     *   *   121.0 54 24 16   1 15     0   11   58 63       3         121
1889028 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 2018   grade_7 109.0 1.0 8.0   0.0 0.0     0.0   4.0   56.0 66.0     2.0   1.0     52.0   20.0   122.0 109 1 8   0 0     0   4   56 66     2 1   52 20   122
1893491 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 2018   grade_7 106.0 3.0 5.0   2.0 2.0     1.0   3.0   54.0 68.0     *   *     26.0   12.0   122.0 106 3 5   2 2     1   3   54 68           26 12   122
1885001 MN Ramsey 62 school 2733840 625 Independent Districts and Schools St. Paul Public School District 273384001612 528 Linwood Monroe Arts Plus Upper Elementary School (Grades PK-6) Regular School No Middle 04 08 2018   grade_7 49.0 33.0 7.0   1.0 27.0     0.0   6.0   49.0 74.0     32.0   1.0     72.0   29.0   123.0 49 33 7   1 27     0   6   49 74     32 1   72 29   123
1880143 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 2018   grade_7 116.0 1.0 3.0   0.0 3.0     0.0   1.0   66.0 58.0     0.0   1.0     49.0   19.0   124.0 116 1 3   0 3     0   1   66 58     0 1   49 19   124
1890786 MN Carver 10 school 2708190 112 Independent Districts and Schools Eastern Carver County Public Schools 270819004622 66 112 ALC Middle School Public Area Learning Center ALC (State approved) Alternative School No Middle 06 08 2018   grade_7 67.0 12.0 31.0   3.0 0.0     0.0   11.0   63.0 61.0     11.0   1.0     53.0   24.0   124.0 67 12 31   3 0     0   11   63 61     11 1   53 24   124
1889122 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 2018   grade_7 109.0 1.0 10.0   1.0 0.0     0.0   4.0   60.0 65.0     2.0   0.0     46.0   17.0   125.0 109 1 10   1 0     0   4   60 65     2 0   46 17   125
1892757 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 2018   grade_7 91.0 13.0 5.0   3.0 5.0     0.0   8.0   64.0 61.0     3.0   0.0     39.0   26.0   125.0 91 13 5   3 5     0   8   64 61     3 0   39 26   125
1893540 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 2018   grade_7 107.0 0.0 13.0   1.0 0.0     0.0   5.0   65.0 61.0     2.0   0.0     34.0   23.0   126.0 107 0 13   1 0     0   5   65 61     2 0   34 23   126
1887212 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 2018   grade_7 110.0 4.0 4.0   0.0 7.0     0.0   2.0   54.0 73.0     4.0   0.0     10.0   8.0   127.0 110 4 4   0 7     0   2   54 73     4 0   10 8   127
1889353 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 2018   grade_7 96.0 6.0 14.0   2.0 4.0     0.0   5.0   56.0 71.0     4.0   0.0     39.0   10.0   127.0 96 6 14   2 4     0   5   56 71     4 0   39 10   127
1889496 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124004882 327 Franklin Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2018   grade_7 2.0 94.0 21.0   3.0 3.0     1.0   3.0   57.0 70.0     15.0   8.0     111.0   40.0   127.0 2 94 21   3 3     1   3   57 70     15 8   111 40   127
1889391 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 2018   grade_7 110.0 1.0 10.0   4.0 0.0     0.0   3.0   75.0 53.0     1.0   0.0     37.0   25.0   128.0 110 1 10   4 0     0   3   75 53     1 0   37 25   128
1880552 MN Saint Louis 69 school 2741040 706 Independent Districts and Schools Virginia Public School District 274104001718 90 Virginia Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_7 106.0 2.0 2.0   4.0 1.0     0.0   14.0   73.0 56.0     0.0   3.0     52.0   24.0   129.0 106 2 2   4 1     0   14   73 56     0 3   52 24   129
1880685 MN Watonwan 83 school 2707320 836 Independent Districts and Schools Butterfield Public School District 270732000305 30 Butterfield Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_7 5.0 1.0 7.0   0.0 0.0     0.0   0.0   8.0 5.0     *   *     9.0   4.0   13.0 5 1 7   0 0     0   0   8 5           9 4   13
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
1888083 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 2018   grade_7 5.0 3.0 2.0   0.0 0.0     0.0   3.0   6.0 7.0     1.0   0.0     4.0   6.0   13.0 5 3 2   0 0     0   3   6 7     1 0   4 6   13
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
1889290 MN Traverse 78 school 2707110 801 Independent Districts and Schools Browns Valley Public School District 270711000280 20 Browns Valley Middle Middle School (Grades 5-8) Regular School No Middle 05 08 2018   grade_7 4.0 0.0 0.0   9.0 0.0     0.0   0.0   5.0 8.0     0.0   0.0     9.0   4.0   13.0 4 0 0   9 0     0   0   5 8     0 0   9 4   13
1893054 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 2018   grade_7 7.0 2.0 1.0   0.0 0.0     0.0   3.0   12.0 1.0     0.0   0.0     *   10.0   13.0 7 2 1   0 0     0   3   12 1     0 0     10   13
1888723 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 06 08 2018   grade_7 125.0 1.0 2.0   0.0 1.0     0.0   2.0   64.0 67.0     1.0   0.0     29.0   12.0   131.0 125 1 2   0 1     0   2   64 67     1 0   29 12   131
1889484 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 2018   grade_7 17.0 76.0 19.0   3.0 15.0     0.0   3.0   77.0 56.0     20.0   20.0     115.0   33.0   133.0 17 76 19   3 15     0   3   77 56     20 20   115 33   133
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
1889468 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 2018   grade_7 93.0 23.0 9.0   1.0 5.0     0.0   3.0   62.0 72.0     5.0   0.0     33.0   21.0   134.0 93 23 9   1 5     0   3   62 72     5 0   33 21   134
1889272 MN Stearns 73 school 2702930 745 Independent Districts and Schools Albany Public School District 270293000063 50 Albany Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2018   grade_7 127.0 0.0 6.0   0.0 0.0     0.0   2.0   57.0 78.0     2.0   0.0     32.0   18.0   135.0 127 0 6   0 0     0   2   57 78     2 0   32 18   135
1889014 MN Lyon 42 school 2718940 413 Independent Districts and Schools Marshall Public School District 271894003715 6 Marshall Middle School Middle School (Grades 5-8) Regular School No Middle 05 08 2018   grade_7 100.0 9.0 17.0   0.0 7.0     0.0   5.0   65.0 73.0     *   0.0     51.0   12.0   138.0 100 9 17   0 7     0   5   65 73       0   51 12   138
1880404 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 2018   grade_7 124.0 0.0 8.0   0.0 0.0     0.0   7.0   81.0 58.0     *   *     *   15.0   139.0 124 0 8   0 0     0   7   81 58             15   139
1880158 MN Kittson 35 school 2717880 356 Independent Districts and Schools Lancaster Public School District 271788000822 20 Lancaster Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_7 11.0 1.0 2.0   0.0 0.0     0.0   0.0   9.0 5.0     *   *     7.0   6.0   14.0 11 1 2   0 0     0   0   9 5           7 6   14

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