Data source: Big Local News · About: Big Local

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

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 ▼
1826535 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 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
1826724 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 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
1829732 MN Olmsted 55 school 2731800 535 Independent Districts and Schools Rochester Public School District 273180001004 136 Jefferson Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 07 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
1836110 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 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
1836347 MN Carlton 9 school 2709420 94 Independent Districts and Schools Cloquet Public School District 270942002236 103 CLOQUET AREA ALT. ED. PROGRAMS Public Area Learning Center ALC (State approved) Alternative School No Other 01 12 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
1836374 MN Cass 11 school 2708070 115 Independent Districts and Schools Cass Lake-Bena Public Schools 270807002234 31 Cass Lake-Bena Area Lrng. Cntr. Public Area Learning Center ALC (State approved) Alternative School No High 07 12 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
1836443 MN Hennepin 27 school 2731780 281 Independent Districts and Schools Robbinsdale Public School District 273178004630 903 Robbinsdale TASC ALC Public Area Learning Center ALC (State approved) Alternative School No High 07 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
1836554 MN Nobles 53 school 2744160 518 Independent Districts and Schools Worthington Public School District 274416002335 6 Learning Center Public Area Learning Center ALC (State approved) Alternative School No High 07 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
1836679 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 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
1836734 MN Pine 58 school 2711085 2580 Independent Districts and Schools East Central School District 271108500222 35 Crossroads Area Learning Center Public Area Learning Center ALC (State approved) Alternative School No High 07 12 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
1836869 MN Chippewa 12 school 2700058 6018 Education Districts MN River Valley Education District 270005802245 20 MN River Valley ALC-Seatbased Public Area Learning Center ALC (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
1836876 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 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
1836883 MN Brown 8 school 2791353 6049 Education Districts River Bend Education District 279135302494 20 River Bend Area Learning Center Public Area Learning Center ALC (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   0.0 1.0     *   *         *   1.0 1 0 0   0 0     0   0   0 1                 1
1836904 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 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
1836958 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 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
1837028 MN Dakota 19 school 2742270 197 Independent Districts and Schools West St. Paul-Mendota Hts.-Eagan 274227005008 827 Special Education 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
1837072 MN Hennepin 27 school 2725200 279 Independent Districts and Schools Osseo Public School District 272520003593 45 Achieve Special Education Special Education School No Other KG 12 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
1837616 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 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
1837646 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 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
1837652 MN Clay 14 school 2700040 397 Special Education Cooperatives Lake Agassiz Education Cooperative 270004005080 12 Glacial Ridge Transitional Skills Program Special Education Special Education School No High 07 12 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
1837665 MN Martin 46 school 2700046 915 Special Education Cooperatives Southern Plains Education Coop. 270004604627 45 Southern Plains Bridges 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
1837673 MN Martin 46 school 2700046 915 Special Education Cooperatives Southern Plains Education Coop. 270004603691 70 Positive Approach To Learning Special Education Special Education School No Other KG 12 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
1837691 MN Wright 86 school 2700045 938 Special Education Cooperatives Meeker And Wright Special Education 270004504402 10 Trek Program Special Education Special Education School No Other KG 12 2020   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
1837736 MN Mower 50 school 2700327 6083 Special Education Cooperatives Southern MN Education Consortium 270032705013 20 Success Program 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   1.0 0.0     *   *         *   1.0 1 0 0   0 0     0   0   1 0                 1
1837813 MN Wright 86 school 2700413 6090 Special Education Cooperatives Sherburne and Northern Wright Special Education Cooperative 270041305265 76 SNW Monti MS EBD Program 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
1837844 MN Mower 50 school 2700426 6095 Special Education Cooperatives Austin Albert Lea Area Special Education Cooperative (AALASEC) 270042605016 550 Oakland Education Center 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
1837868 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 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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
1826609 MN Blue Earth 7 school 2700226 4066 Charter Schools Kato Public Charter School 270022603471 10 Kato Public Charter School Secondary School (Grades 7-12) Regular School Yes High 06 12 2020   grade_7 1.0 0.0 0.0   0.0 0.0     0.0   1.0   1.0 1.0     *   *         *   2.0 1 0 0   0 0     0   1   1 1                 2
1836285 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 2020   grade_7 0.0 1.0 1.0   0.0 0.0     0.0   0.0   1.0 1.0     *   *         *   2.0 0 1 1   0 0     0   0   1 1                 2
1837398 MN Rice 66 school 2700129 160 State Operated Schools (which include MN Academy Deaf & Blind, School for the Arts) Minnesota State Academies 270012903056 1 MN Academy For The Blind Special Education Special Education School No Other PK 12 2020   grade_7 2.0 0.0 0.0   0.0 0.0     0.0   0.0   0.0 2.0     *   *         *   2.0 2 0 0   0 0     0   0   0 2                 2
1837465 MN Hennepin 27 school 2700025 287 Intermediate Districts and Schools Intermediate School District 287 270002503542 479 Safe Special Education Special Education School No Other 01 12 2020   grade_7 1.0 0.0 0.0   0.0 0.0     0.0   1.0   2.0 0.0     *   *         *   2.0 1 0 0   0 0     0   1   2 0                 2
1837475 MN Hennepin 27 school 2700025 287 Intermediate Districts and Schools Intermediate School District 287 270002503229 480 Strive Secondary Special Education Special Education School No Other 01 12 2020   grade_7 0.0 2.0 0.0   0.0 0.0     0.0   0.0   2.0 0.0     *   *         *   2.0 0 2 0   0 0     0   0   2 0                 2
1837754 MN Mower 50 school 2700327 6083 Special Education Cooperatives Southern MN Education Consortium 270032705011 40 CARDS Program Special Education Special Education School No Other PK 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
1837763 MN Fillmore 23 school 2700327 6083 Special Education Cooperatives Southern MN Education Consortium 270032705124 70 Enrich Kingsland Special Education Special Education School No High 06 12 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
1837774 MN Freeborn 24 school 2700327 6083 Special Education Cooperatives Southern MN Education Consortium 270032705152 110 Enrich Alden Special Education Special Education School No High 06 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
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
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
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
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
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
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
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
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
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
1832326 MN Pipestone 59 school 2700108 2689 Independent Districts and Schools Pipestone Area School District 270010803015 6 Heartland Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 08 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
1833132 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 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
1836332 MN Beltrami 4 school 2730510 38 Independent Districts and Schools Red Lake Public School District 273051002793 50 Red Lake Middle Level ALC Public Area Learning Center ALC (State approved) Alternative School No Middle 06 08 2020   grade_7 0.0 0.0 0.0   3.0 0.0     0.0   0.0   2.0 1.0     *   *         *   3.0 0 0 0   3 0     0   0   2 1                 3
1836853 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 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
1837511 MN Scott 70 school 2700420 288 Intermediate Districts and Schools Southwest Metro Intermediate 288 270042005237 13 SWMetro Waseca 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   2.0 1.0     *   *         *   3.0 3 0 0   0 0     0   0   2 1                 3
1837580 MN Dakota 19 school 2700026 917 Intermediate Districts and Schools Intermediate School District 917 270002602124 60 Deaf/Hard of Hearing Special Education Special Education School No Other PK 12 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
1837592 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 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
1837855 MN Carlton 9 school 2700442 6096 Special Education Cooperatives Northern Lights Academy Cooperative 270044205073 10 Northern Lights Academy 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
1837885 MN Cottonwood 17 school 2700086 991 Service Cooperative (ECSU Region) Region 6 and 8-SW/WC Service Cooperative 270008604168 16 SWWC ELC - Windom Special Education Special Education School No Other 02 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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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

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