enrollments

Data source: Big Local News · About: Big Local

681 rows where grade = "grade_7", state = "MN" and year = 2019 sorted by free_and_reduced_int

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2019 · 681 ✖

grade ✖

  • grade_7 · 681 ✖
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
1945845 1945845 MN Ramsey 62 school 2700315 4183 Charter Schools LIONSGATE ACADEMY 270031505148 50 Lionsgate Academy - Shoreview Secondary School (Grades 7-12) Regular School Yes Secondary 07 10 2019   grade_7 10.0 2.0 2.0   0.0 0.0     0.0   2.0   12.0 4.0     0.0   0.0     0.0   *   16.0 10 2 2   0 0     0   2   12 4     0 0   0     16
1958133 1958133 MN Mower 50 school 2703450 492 Independent Districts and Schools AUSTIN PUBLIC SCHOOL DISTRICT 270345003192 450 NEW DOMINION ACADEMY Educational Oversight to Private Residential Care & Treatment (State approved) Alternative School No Other KG 12 2019   grade_7 3.0 3.0 1.0   2.0 0.0     0.0   2.0   6.0 5.0     0.0   0.0     0.0   *   11.0 3 3 1   2 0     0   2   6 5     0 0   0     11
1944382 1944382 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 2019   grade_7 5.0 0.0 1.0   0.0 1.0     0.0   4.0   8.0 3.0     0.0   0.0     1.0   0.0   11.0 5 0 1   0 1     0   4   8 3     0 0   1 0   11
1957503 1957503 MN Lesueur 40 school 2700261 4151 Charter Schools EDVISIONS OFF CAMPUS SCHOOL 270026103319 10 EDVISIONS OFF CAMPUS SCHOOL Distance Learning Program OLL (State approved) Regular School Yes High 07 12 2019   grade_7 11.0 2.0 0.0   0.0 1.0     0.0   0.0   7.0 7.0     0.0   0.0     1.0   2.0   14.0 11 2 0   0 1     0   0   7 7     0 0   1 2   14
1945685 1945685 MN Sibley 72 school 2700092 4007 Charter Schools Minnesota New Country School 270009202487 10 MINNESOTA NEW COUNTRY SCHOOL Secondary School (Grades 7-12) Regular School Yes High 07 12 2019   grade_7 16.0 0.0 0.0   0.0 0.0     0.0   0.0   9.0 7.0     0.0   0.0     2.0   1.0   16.0 16 0 0   0 0     0   0   9 7     0 0   2 1   16
1945767 1945767 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 2019   grade_7 15.0 0.0 1.0   1.0 0.0     0.0   1.0   9.0 9.0     0.0   0.0     2.0   5.0   18.0 15 0 1   1 0     0   1   9 9     0 0   2 5   18
1952166 1952166 MN Carver 10 school 2700116 4016 Charter Schools WORLD LEARNER CHARTER SCHOOL 270011602606 10 WORLD LEARNER CHARTER SCHOOL Elementary School (Grades PK-6) Regular School Yes Elementary 01 08 2019   grade_7 16.0 0.0 1.0   0.0 2.0     0.0   1.0   12.0 8.0     0.0   0.0     2.0   5.0   20.0 16 0 1   0 2     0   1   12 8     0 0   2 5   20
1945051 1945051 MN Rock 67 school 2714040 671 Independent Districts and Schools HILLS-BEAVER CREEK SCHOOL DISTRICT 271404000727 20 HILLS-BEAVER CREEK SECONDARY Secondary School (Grades 7-12) Regular School No High 06 12 2019   grade_7 29.0 1.0 1.0   0.0 0.0     0.0   1.0   16.0 16.0     0.0   0.0     3.0   4.0   32.0 29 1 1   0 0     0   1   16 16     0 0   3 4   32
1952978 1952978 MN Washington 82 school 2700401 4228 Charter Schools Woodbury Leadership Academy 270040104812 10 Woodbury Leadership Academy Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2019   grade_7 5.0 4.0 1.0   0.0 2.0     0.0   2.0   7.0 7.0     0.0   0.0     3.0   4.0   14.0 5 4 1   0 2     0   2   7 7     0 0   3 4   14
1956544 1956544 MN Hennepin 27 school 2700025 287 Intermediate Districts and Schools INTERMEDIATE SCHOOL DISTRICT 287 270002503234 486 CIP Special Education Special Education School No Other 01 12 2019   grade_7 6.0 1.0 0.0   1.0 2.0     0.0   1.0   10.0 1.0     2.0   0.0     3.0   *   11.0 6 1 0   1 2     0   1   10 1     2 0   3     11
1944940 1944940 MN Pennington 57 school 2713020 561 Independent Districts and Schools GOODRIDGE PUBLIC SCHOOL DISTRICT 271302000650 20 GOODRIDGE SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_7 15.0 0.0 0.0   1.0 0.0     0.0   0.0   9.0 7.0     0.0   0.0     4.0   1.0   16.0 15 0 0   1 0     0   0   9 7     0 0   4 1   16
1945162 1945162 MN Stevens 75 school 2708940 771 Independent Districts and Schools CHOKIO-ALBERTA PUBLIC SCHOOL DIST. 270894000361 2 CHOKIO-ALBERTA SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_7 16.0 1.0 0.0   0.0 0.0     0.0   0.0   10.0 7.0     0.0   0.0     4.0   4.0   17.0 16 1 0   0 0     0   0   10 7     0 0   4 4   17
1945887 1945887 MN Wright 86 school 2700403 4229 Charter Schools Jane Goodall Environmental Science Academy 270040304850 10 Jane Goodall Environmental Science Academy Secondary School (Grades 7-12) Regular School Yes High 06 12 2019   grade_7 15.0 0.0 0.0   0.0 0.0     0.0   0.0   13.0 2.0     0.0   0.0     4.0   7.0   15.0 15 0 0   0 0     0   0   13 2     0 0   4 7   15
1953666 1953666 MN Nicollet 52 school 2723580 507 Independent Districts and Schools NICOLLET PUBLIC SCHOOL DISTRICT 272358004675 15 Nicollet Middle School Middle School (Grades 5-8) Regular School No Middle 05 08 2019   grade_7 24.0 0.0 3.0   0.0 0.0     0.0   0.0   14.0 13.0     0.0   0.0     4.0   5.0   27.0 24 0 3   0 0     0   0   14 13     0 0   4 5   27
1954207 1954207 MN Ramsey 62 school 2700408 4233 Charter Schools Level Up Academy 270040805167 20 Level Up Middle Academy Middle School (Grades 5-8) Regular School Yes Middle 06 08 2019   grade_7 7.0 1.0 3.0   0.0 0.0     0.0   0.0   3.0 8.0     0.0   0.0     4.0   *   11.0 7 1 3   0 0     0   0   3 8     0 0   4     11
1957400 1957400 MN Nobles 53 school 2744160 518 Independent Districts and Schools WORTHINGTON PUBLIC SCHOOL DISTRICT 274416004676 20 Worthington 518 (Virtual Instruction By Excellence) Distance Learning Program OLL (State approved) Regular School No Other KG 12 2019   grade_7 26.0 0.0 1.0   0.0 0.0     0.0   2.0   18.0 11.0     0.0   0.0     4.0   0.0   29.0 26 0 1   0 0     0   2   18 11     0 0   4 0   29
1944573 1944573 MN Fillmore 23 school 2718540 238 Independent Districts and Schools MABEL-CANTON PUBLIC SCHOOL DIST. 271854000858 2 MABEL-CANTON SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_7 13.0 0.0 1.0   0.0 0.0     0.0   0.0   9.0 5.0     1.0   0.0     5.0   2.0   14.0 13 0 1   0 0     0   0   9 5     1 0   5 2   14
1944849 1944849 MN Morrison 49 school 2738280 486 Independent Districts and Schools SWANVILLE PUBLIC SCHOOL DISTRICT 273828001671 20 SWANVILLE SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_7 17.0 0.0 0.0   0.0 0.0     0.0   0.0   9.0 8.0     0.0   0.0     5.0   1.0   17.0 17 0 0   0 0     0   0   9 8     0 0   5 1   17
1945518 1945518 MN Roseau 68 school 2700107 2683 Independent Districts and Schools GREENBUSH-MIDDLE RIVER SCHOOL DIST. 270010700921 20 Greenbush-Middle River Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_7 15.0 2.0 0.0   0.0 0.0     0.0   0.0   8.0 9.0     0.0   0.0     5.0   3.0   17.0 15 2 0   0 0     0   0   8 9     0 0   5 3   17
1948857 1948857 MN Olmsted 55 school 2731800 535 Independent Districts and Schools ROCHESTER PUBLIC SCHOOL DISTRICT 273180001005 138 LINCOLN K-8 CHOICE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 08 2019   grade_7 39.0 5.0 5.0   0.0 2.0     0.0   1.0   28.0 24.0     1.0   0.0     5.0   *   52.0 39 5 5   0 2     0   1   28 24     1 0   5     52
1952110 1952110 MN Winona 85 school 2705850 4001 Charter Schools BLUFFVIEW MONTESSORI 270585000018 10 BLUFFVIEW MONTESSORI Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2019   grade_7 16.0 1.0 0.0   0.0 1.0     0.0   1.0   11.0 8.0     0.0   0.0     5.0   6.0   19.0 16 1 0   0 1     0   1   11 8     0 0   5 6   19
1952602 1952602 MN Ramsey 62 school 2700262 4152 Charter Schools Twin Cities German Immersion Charter School 270026203578 10 Twin Cities German Immersion Charter School Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2019   grade_7 47.0 0.0 0.0   0.0 1.0     0.0   3.0   31.0 20.0     1.0   0.0     5.0   11.0   51.0 47 0 0   0 1     0   3   31 20     1 0   5 11   51
1952653 1952653 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 2019   grade_7 6.0 2.0 1.0   0.0 0.0     0.0   4.0   7.0 6.0     0.0   0.0     5.0   2.0   13.0 6 2 1   0 0     0   4   7 6     0 0   5 2   13
1952943 1952943 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 2019   grade_7 6.0 10.0 0.0   0.0 2.0     0.0   0.0   10.0 8.0     8.0   0.0     5.0   3.0   18.0 6 10 0   0 2     0   0   10 8     8 0   5 3   18
1953615 1953615 MN Lincoln 41 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 2019   grade_7 7.0 0.0 4.0   0.0 0.0     0.0   0.0   4.0 7.0     2.0   0.0     5.0   *   11.0 7 0 4   0 0     0   0   4 7     2 0   5     11
1953657 1953657 MN Mower 50 school 2713140 495 Independent Districts and Schools GRAND MEADOW PUBLIC SCHOOL DISTRICT 271314000660 20 GRAND MEADOW MIDDLE Middle School (Grades 5-8) Regular School No Middle 05 08 2019   grade_7 30.0 1.0 2.0   0.0 0.0     0.0   0.0   12.0 21.0     0.0   0.0     5.0   5.0   33.0 30 1 2   0 0     0   0   12 21     0 0   5 5   33
1944566 1944566 MN Fillmore 23 school 2717910 229 Independent Districts and Schools LANESBORO PUBLIC SCHOOL DISTRICT 271791000824 20 LANESBORO SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_7 25.0 0.0 1.0   0.0 1.0     0.0   0.0   11.0 16.0     0.0   0.0     6.0   3.0   27.0 25 0 1   0 1     0   0   11 16     0 0   6 3   27
1944729 1944729 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 2019   grade_7 10.0 0.0 0.0   0.0 0.0     0.0   0.0   5.0 5.0     *   *     6.0   3.0   10.0 10 0 0   0 0     0   0   5 5           6 3   10
1945605 1945605 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 2019   grade_7 14.0 1.0 0.0   0.0 0.0     0.0   0.0   7.0 8.0     0.0   0.0     6.0   1.0   15.0 14 1 0   0 0     0   0   7 8     0 0   6 1   15
1945712 1945712 MN Washington 82 school 2700167 4043 Charter Schools MATH AND SCIENCE ACADEMY 270016703035 10 MATH AND SCIENCE ACADEMY Secondary School (Grades 7-12) Regular School Yes High 06 12 2019   grade_7 46.0 15.0 2.0   0.0 23.0     0.0   2.0   44.0 44.0     2.0   0.0     6.0   3.0   88.0 46 15 2   0 23     0   2   44 44     2 0   6 3   88
1945736 1945736 MN Winona 85 school 2700221 4064 Charter Schools RIVERWAY LEARNING COMMUNITY CHTR 270022103136 20 RIVERWAY SECONDARY Secondary School (Grades 7-12) Regular School Yes High 07 12 2019   grade_7 7.0 2.0 0.0   0.0 0.0     0.0   1.0   5.0 5.0     *   *     6.0   4.0   10.0 7 2 0   0 0     0   1   5 5           6 4   10
1945797 1945797 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 2019   grade_7 76.0 0.0 10.0   0.0 2.0     0.0   5.0   52.0 41.0     1.0   0.0     6.0   9.0   93.0 76 0 10   0 2     0   5   52 41     1 0   6 9   93
1945903 1945903 MN Olmsted 55 school 2700412 4238 Charter Schools Rochester Beacon Academy 270041204878 10 Rochester Beacon Academy Secondary School (Grades 7-12) Regular School Yes High 06 12 2019   grade_7 15.0 1.0 1.0   0.0 0.0     0.0   1.0   16.0 2.0     0.0   0.0     6.0   11.0   18.0 15 1 1   0 0     0   1   16 2     0 0   6 11   18
1952927 1952927 MN Dakota 19 school 2700391 4221 Charter Schools Discovery Charter School 270039104764 10 Discovery Charter Elementary School Elementary School (Grades PK-6) Regular School Yes Elementary KG 07 2019   grade_7 7.0 1.0 4.0   0.0 0.0     0.0   1.0   8.0 5.0     1.0   0.0     6.0   3.0   13.0 7 1 4   0 0     0   1   8 5     1 0   6 3   13
1953328 1953328 MN Carver 10 school 2708190 112 Independent Districts and Schools EASTERN CARVER COUNTY PUBLIC SCHOOL 270819002798 62 CHASKA MIDDLE SCHOOL WEST Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_7 170.0 1.0 9.0   0.0 7.0     0.0   7.0   106.0 88.0     0.0   0.0     6.0   13.0   194.0 170 1 9   0 7     0   7   106 88     0 0   6 13   194
1944635 1944635 MN Houston 28 school 2733300 297 Independent Districts and Schools SPRING GROVE SCHOOL DISTRICT 273330001459 20 SPRING GROVE SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_7 17.0 0.0 1.0   0.0 0.0     0.0   0.0   9.0 9.0     0.0   0.0     7.0   2.0   18.0 17 0 1   0 0     0   0   9 9     0 0   7 2   18
1944736 1944736 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 2019   grade_7 8.0 0.0 0.0   3.0 1.0     0.0   1.0   4.0 9.0     *   *     7.0   6.0   13.0 8 0 0   3 1     0   1   4 9           7 6   13
1944750 1944750 MN Lake 38 school 2740740 381 Independent Districts and Schools LAKE SUPERIOR PUBLIC SCHOOL DIST. 274074001697 90 Wm. M. Kelley Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_7 23.0 1.0 0.0   1.0 0.0     1.0   1.0   14.0 13.0     0.0   *     7.0   3.0   27.0 23 1 0   1 0     1   1   14 13     0     7 3   27
1944872 1944872 MN Mower 50 school 2718060 499 Independent Districts and Schools LEROY-OSTRANDER PUBLIC SCHOOLS 271806000832 30 LEROY SECONDARY Secondary School (Grades 7-12) Regular School No High 06 12 2019   grade_7 18.0 0.0 0.0   2.0 0.0     0.0   2.0   10.0 12.0     0.0   0.0     7.0   4.0   22.0 18 0 0   2 0     0   2   10 12     0 0   7 4   22
1945262 1945262 MN Wilkin 84 school 2707450 852 Independent Districts and Schools CAMPBELL-TINTAH PUBLIC SCHOOL DIST. 270745000320 20 CAMPBELL-TINTAH SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_7 9.0 0.0 2.0   0.0 0.0     0.0   0.0   5.0 6.0     0.0   0.0     7.0   3.0   11.0 9 0 2   0 0     0   0   5 6     0 0   7 3   11
1945311 1945311 MN Clay 14 school 2740810 914 Independent Districts and Schools ULEN-HITTERDAL PUBLIC SCHOOL DIST 274081001705 2 ULEN-HITTERDAL SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_7 21.0 1.0 0.0   2.0 0.0     0.0   2.0   13.0 13.0     0.0   0.0     7.0   2.0   26.0 21 1 0   2 0     0   2   13 13     0 0   7 2   26
1945341 1945341 MN Fillmore 23 school 2700007 2137 Independent Districts and Schools KINGSLAND PUBLIC SCHOOL DISTRICT 270000701469 25 Kingsland Junior/Senior High School Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_7 48.0 0.0 0.0   0.0 0.0     0.0   0.0   22.0 26.0     0.0   0.0     7.0   4.0   48.0 48 0 0   0 0     0   0   22 26     0 0   7 4   48
1945774 1945774 MN Mcleod 43 school 2700214 4093 Charter Schools New Century Academy 270021403275 10 New Century Academy Secondary School (Grades 7-12) Regular School Yes High 07 12 2019   grade_7 9.0 0.0 0.0   0.0 0.0     0.0   1.0   4.0 6.0     0.0   0.0     7.0   1.0   10.0 9 0 0   0 0     0   1   4 6     0 0   7 1   10
1952729 1952729 MN Scott 70 school 2700311 4184 Charter Schools ASPEN ACADEMY 270031104282 10 ASPEN ACADEMY Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2019   grade_7 17.0 3.0 0.0   0.0 2.0     0.0   1.0   11.0 12.0     1.0   0.0     7.0   5.0   23.0 17 3 0   0 2     0   1   11 12     1 0   7 5   23
1952877 1952877 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 2019   grade_7 1.0 4.0 5.0   0.0 0.0     0.0   0.0   6.0 4.0     1.0   *     7.0   3.0   10.0 1 4 5   0 0     0   0   6 4     1     7 3   10
1955973 1955973 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000005 467 RIVER TRAIL LEARNING CTR @ LO JACOB Special Education Special Education School No Other KG 12 2019   grade_7 9.0 1.0 1.0   0.0 0.0     0.0   1.0   12.0 0.0     0.0   0.0     7.0   *   12.0 9 1 1   0 0     0   1   12 0     0 0   7     12
1958252 1958252 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 2019   grade_7 6.0 0.0 1.0   2.0 0.0     0.0   2.0   6.0 5.0     0.0   0.0     7.0   4.0   11.0 6 0 1   2 0     0   2   6 5     0 0   7 4   11
1944814 1944814 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 2019   grade_7 11.0 0.0 1.0   0.0 0.0     0.0   0.0   8.0 4.0     0.0   0.0     8.0   0.0   12.0 11 0 1   0 0     0   0   8 4     0 0   8 0   12
1944856 1944856 MN Morrison 49 school 2740860 487 Independent Districts and Schools UPSALA PUBLIC SCHOOL DISTRICT 274086001709 20 UPSALA SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_7 24.0 0.0 2.0   0.0 0.0     0.0   0.0   12.0 14.0     0.0   0.0     8.0   2.0   26.0 24 0 2   0 0     0   0   12 14     0 0   8 2   26
1944879 1944879 MN Murray 51 school 2712480 505 Independent Districts and Schools FULDA PUBLIC SCHOOL DISTRICT 271248000618 20 FULDA SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_7 29.0 0.0 1.0   1.0 2.0     0.0   0.0   17.0 16.0     2.0   0.0     8.0   4.0   33.0 29 0 1   1 2     0   0   17 16     2 0   8 4   33
1945036 1945036 MN Red Lake 63 school 2730450 630 Independent Districts and Schools RED LAKE FALLS PUBLIC SCHOOL DIST. 273045001290 20 LAFAYETTE SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_7 19.0 0.0 0.0   0.0 0.0     0.0   1.0   9.0 11.0     0.0   0.0     8.0   1.0   20.0 19 0 0   0 0     0   1   9 11     0 0   8 1   20
1945086 1945086 MN Saint Louis 69 school 2712210 698 Independent Districts and Schools FLOODWOOD PUBLIC SCHOOL DISTRICT 271221000589 20 FLOODWOOD SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_7 9.0 1.0 0.0   1.0 0.0     0.0   1.0   8.0 4.0     *   *     8.0   4.0   12.0 9 1 0   1 0     0   1   8 4           8 4   12
1945205 1945205 MN Wabasha 79 school 2741060 811 Independent Districts and Schools WABASHA-KELLOGG PUBLIC SCHOOL DIST. 274106001722 40 WABASHA-KELLOGG SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_7 40.0 1.0 1.0   0.0 0.0     0.0   1.0   22.0 21.0     0.0   1.0     8.0   4.0   43.0 40 1 1   0 0     0   1   22 21     0 1   8 4   43
1945461 1945461 MN Norman 54 school 2700101 2215 Independent Districts and Schools NORMAN COUNTY EAST SCHOOL DISTRICT 270010101695 2 NORMAN COUNTY EAST SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_7 18.0 0.0 0.0   0.0 0.0     0.0   1.0   10.0 9.0     0.0   0.0     8.0   4.0   19.0 18 0 0   0 0     0   1   10 9     0 0   8 4   19
1945583 1945583 MN Marshall 45 school 2700127 2856 Independent Districts and Schools STEPHEN-ARGYLE CENTRAL SCHOOLS 270012701648 30 STEPHEN SENIOR HIGH Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_7 21.0 0.0 2.0   0.0 0.0     0.0   1.0   10.0 14.0     0.0   0.0     8.0   1.0   24.0 21 0 2   0 0     0   1   10 14     0 0   8 1   24
1945789 1945789 MN Ramsey 62 school 2700344 4105 Charter Schools GREAT RIVER SCHOOL 270034404093 10 GREAT RIVER SCHOOL Secondary School (Grades 7-12) Regular School Yes High 07 12 2019   grade_7 42.0 5.0 5.0   0.0 10.0     1.0   1.0   32.0 32.0     0.0   0.0     8.0   11.0   64.0 42 5 5   0 10     1   1   32 32     0 0   8 11   64
1951795 1951795 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 2019   grade_7 113.0 4.0 4.0   0.0 4.0     0.0   2.0   64.0 63.0     2.0   0.0     8.0   12.0   127.0 113 4 4   0 4     0   2   64 63     2 0   8 12   127
1952531 1952531 MN Olmsted 55 school 2700247 4135 Charter Schools ROCHESTER MATH AND SCIENCE ACADEMY 270024703308 10 ROCHESTER MATH AND SCIENCE ACADEMY Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2019   grade_7 1.0 38.0 0.0   0.0 0.0     0.0   0.0   16.0 23.0     12.0   0.0     8.0   1.0   39.0 1 38 0   0 0     0   0   16 23     12 0   8 1   39
1952918 1952918 MN Hennepin 27 school 2700394 4220 Charter Schools Agamim Classical Academy 270039404751 10 Agamim Classical Academy Elementary School (Grades PK-6) Regular School Yes Elementary KG 07 2019   grade_7 7.0 8.0 1.0   0.0 0.0     0.0   0.0   7.0 9.0     2.0   0.0     8.0   4.0   16.0 7 8 1   0 0     0   0   7 9     2 0   8 4   16
1953661 1953661 MN Mower 50 school 2702720 500 Independent Districts and Schools SOUTHLAND PUBLIC SCHOOL DISTRICT 270272000054 50 SOUTHLAND MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_7 30.0 1.0 1.0   0.0 0.0     0.0   1.0   22.0 11.0     0.0   0.0     8.0   6.0   33.0 30 1 1   0 0     0   1   22 11     0 0   8 6   33
1954145 1954145 MN Wright 86 school 2700360 4118 Charter Schools KALEIDOSCOPE CHARTER SCHOOL 270036005071 30 Kaleidoscope Middle School Middle School (Grades 5-8) Regular School Yes Middle 06 08 2019   grade_7 34.0 1.0 2.0   0.0 0.0     0.0   1.0   25.0 13.0     0.0   0.0     8.0   12.0   38.0 34 1 2   0 0     0   1   25 13     0 0   8 12   38
1954150 1954150 MN Washington 82 school 2700362 4120 Charter Schools ST. CROIX PREPARATORY ACADEMY 270036204222 20 ST CROIX PREPARATORY ACADEMY MIDDLE Middle School (Grades 5-8) Regular School Yes Middle 05 08 2019   grade_7 70.0 2.0 5.0   0.0 7.0     0.0   8.0   46.0 46.0     3.0   0.0     8.0   17.0   92.0 70 2 5   0 7     0   8   46 46     3 0   8 17   92
1956262 1956262 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 2019   grade_7 2.0 7.0 0.0   2.0 0.0     0.0   0.0   8.0 3.0     5.0   0.0     8.0   *   11.0 2 7 0   2 0     0   0   8 3     5 0   8     11
1958238 1958238 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 2019   grade_7 11.0 2.0 0.0   0.0 0.0     0.0   0.0   7.0 6.0     0.0   0.0     8.0   7.0   13.0 11 2 0   0 0     0   0   7 6     0 0   8 7   13
1944410 1944410 MN Blue Earth 7 school 2733480 75 Independent Districts and Schools ST. CLAIR PUBLIC SCHOOL DISTRICT 273348001478 20 ST. CLAIR SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_7 67.0 0.0 0.0   0.0 0.0     0.0   1.0   34.0 34.0     0.0   0.0     9.0   7.0   68.0 67 0 0   0 0     0   1   34 34     0 0   9 7   68
1944417 1944417 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 2019   grade_7 13.0 0.0 0.0   0.0 0.0     0.0   0.0   7.0 6.0     0.0   0.0     9.0   2.0   13.0 13 0 0   0 0     0   0   7 6     0 0   9 2   13
1944595 1944595 MN Goodhue 25 school 2712900 253 Independent Districts and Schools GOODHUE PUBLIC SCHOOL DISTRICT 271290000648 2 GOODHUE SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_7 39.0 0.0 4.0   0.0 0.0     0.0   0.0   25.0 18.0     1.0   0.0     9.0   1.0   43.0 39 0 4   0 0     0   0   25 18     1 0   9 1   43
1944608 1944608 MN Grant 26 school 2703300 261 Independent Districts and Schools ASHBY PUBLIC SCHOOL DISTRICT 270330000137 20 ASHBY SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_7 19.0 0.0 2.0   0.0 0.0     0.0   0.0   11.0 10.0     1.0   1.0     9.0   4.0   21.0 19 0 2   0 0     0   0   11 10     1 1   9 4   21
1945198 1945198 MN Traverse 78 school 2742330 803 Independent Districts and Schools WHEATON AREA PUBLIC SCHOOL DISTRICT 274233001784 2 WHEATON SECONDARY Secondary School (Grades 7-12) Regular School No High 06 12 2019   grade_7 20.0 0.0 2.0   0.0 0.0     0.0   1.0   7.0 16.0     0.0   0.0     9.0   3.0   23.0 20 0 2   0 0     0   1   7 16     0 0   9 3   23
1952408 1952408 MN Hennepin 27 school 2700354 4089 Charter Schools NEW CITY SCHOOL 270035404849 20 NEW CITY SCHOOL Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2019   grade_7 16.0 5.0 3.0   1.0 0.0     0.0   1.0   13.0 13.0     2.0   0.0     9.0   7.0   26.0 16 5 3   1 0     0   1   13 13     2 0   9 7   26
1952766 1952766 MN Carver 10 school 2700319 4188 Charter Schools COLOGNE ACADEMY 270031904320 10 COLOGNE ACADEMY Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2019   grade_7 47.0 2.0 3.0   0.0 1.0     0.0   2.0   23.0 32.0     0.0   0.0     9.0   8.0   55.0 47 2 3   0 1     0   2   23 32     0 0   9 8   55
1953226 1953226 MN Aitkin 1 school 2714010 2 Independent Districts and Schools HILL CITY PUBLIC SCHOOL DISTRICT 271401004653 2 Hill City Middle School Middle School (Grades 5-8) Regular School No Middle 05 08 2019   grade_7 12.0 0.0 0.0   1.0 0.0     0.0   1.0   9.0 5.0     0.0   0.0     9.0   1.0   14.0 12 0 0   1 0     0   1   9 5     0 0   9 1   14
1954031 1954031 MN Martin 46 school 2713040 2536 Independent Districts and Schools Granada Huntley East Chain 271304005153 40 Granada Huntley East Chain Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_7 23.0 0.0 0.0   0.0 0.0     0.0   0.0   12.0 11.0     0.0   1.0     9.0   2.0   23.0 23 0 0   0 0     0   0   12 11     0 1   9 2   23
1954116 1954116 MN Washington 82 school 2700177 4053 Charter Schools NORTH LAKES ACADEMY 270017703045 10 NORTH LAKES ACADEMY Middle School (Grades 5-8) Regular School Yes Middle 05 08 2019   grade_7 51.0 2.0 3.0   1.0 1.0     0.0   0.0   33.0 25.0     0.0   0.0     9.0   17.0   58.0 51 2 3   1 1     0   0   33 25     0 0   9 17   58
1954128 1954128 MN Ramsey 62 school 2700187 4075 Charter Schools AVALON SCHOOL 270018704664 20 Avalon Middle School Middle School (Grades 5-8) Regular School Yes Middle 06 08 2019   grade_7 14.0 1.0 4.0   1.0 0.0     0.0   7.0   17.0 10.0     1.0   1.0     9.0   8.0   27.0 14 1 4   1 0     0   7   17 10     1 1   9 8   27
1955556 1955556 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 2019   grade_7 13.0 1.0 2.0   0.0 0.0     0.0   0.0   10.0 6.0     2.0   0.0     9.0   *   16.0 13 1 2   0 0     0   0   10 6     2 0   9     16
1957470 1957470 MN Ramsey 62 school 2700138 4025 Charter Schools CYBER VILLAGE ACADEMY 270013802717 10 CYBER VILLAGE ACADEMY Distance Learning Program OLL (State approved) Regular School Yes Other KG 12 2019   grade_7 17.0 3.0 4.0   0.0 0.0     0.0   1.0   13.0 12.0     2.0   0.0     9.0   7.0   25.0 17 3 4   0 0     0   1   13 12     2 0   9 7   25
1957674 1957674 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 2019   grade_7 4.0 3.0 2.0   1.0 0.0     0.0   2.0   8.0 4.0     0.0   0.0     9.0   *   12.0 4 3 2   1 0     0   2   8 4     0 0   9     12
1944446 1944446 MN Carlton 9 school 2707590 93 Independent Districts and Schools CARLTON PUBLIC SCHOOL DISTRICT 270759000327 1 CARLTON SECONDARY Secondary School (Grades 7-12) Regular School No High 06 12 2019   grade_7 18.0 0.0 1.0   6.0 0.0     0.0   2.0   18.0 9.0     0.0   0.0     10.0   5.0   27.0 18 0 1   6 0     0   2   18 9     0 0   10 5   27
1944467 1944467 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 2019   grade_7 107.0 0.0 1.0   1.0 0.0     0.0   3.0   52.0 60.0     0.0   1.0     10.0   10.0   112.0 107 0 1   1 0     0   3   52 60     0 1   10 10   112
1944509 1944509 MN Clay 14 school 2713560 150 Independent Districts and Schools HAWLEY PUBLIC SCHOOL DISTRICT 271356000699 20 HAWLEY SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_7 75.0 0.0 1.0   1.0 0.0     0.0   4.0   42.0 39.0     2.0   0.0     10.0   11.0   81.0 75 0 1   1 0     0   4   42 39     2 0   10 11   81
1944580 1944580 MN Freeborn 24 school 2703030 242 Independent Districts and Schools ALDEN-CONGER PUBLIC SCHOOL DISTRICT 270303000080 1 ALDEN-CONGER SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_7 34.0 0.0 2.0   0.0 0.0     0.0   1.0   20.0 17.0     0.0   1.0     10.0   6.0   37.0 34 0 2   0 0     0   1   20 17     0 1   10 6   37
1944628 1944628 MN Houston 28 school 2714280 294 Independent Districts and Schools HOUSTON PUBLIC SCHOOL DISTRICT 271428000749 20 HOUSTON SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_7 30.0 1.0 1.0   0.0 0.0     0.0   0.0   21.0 11.0     0.0   0.0     10.0   7.0   32.0 30 1 1   0 0     0   0   21 11     0 0   10 7   32
1944807 1944807 MN Marshall 45 school 2723550 441 Independent Districts and Schools MARSHALL COUNTY CENTRAL SCHOOLS 272355001157 20 MARSHALL COUNTY CENTRAL HIGH Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_7 32.0 0.0 2.0   0.0 0.0     0.0   2.0   14.0 22.0     0.0   0.0     10.0   4.0   36.0 32 0 2   0 0     0   2   14 22     0 0   10 4   36
1944898 1944898 MN Otter Tail 56 school 2703750 542 Independent Districts and Schools BATTLE LAKE PUBLIC SCHOOL DISTRICT 270375000176 20 BATTLE LAKE SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_7 29.0 0.0 2.0   0.0 0.0     0.0   1.0   16.0 16.0     0.0   0.0     10.0   2.0   32.0 29 0 2   0 0     0   1   16 16     0 0   10 2   32
1945058 1945058 MN Roseau 68 school 2703540 676 Independent Districts and Schools BADGER PUBLIC SCHOOL DISTRICT 270354000163 20 BADGER SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_7 18.0 1.0 0.0   0.0 0.0     0.0   0.0   10.0 9.0     0.0   0.0     10.0   4.0   19.0 18 1 0   0 0     0   0   10 9     0 0   10 4   19
1945348 1945348 MN Saint Louis 69 school 2700008 2142 Independent Districts and Schools ST. LOUIS COUNTY SCHOOL DISTRICT 270000800159 35 NORTHEAST RANGE SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_7 14.0 0.0 0.0   2.0 0.0     0.0   0.0   6.0 10.0     0.0   0.0     10.0   2.0   16.0 14 0 0   2 0     0   0   6 10     0 0   10 2   16
1945692 1945692 MN Anoka 2 school 2700093 4008 Charter Schools PACT CHARTER SCHOOL 270009303030 30 PACT CHARTER SECONDARY Secondary School (Grades 7-12) Regular School Yes High 07 12 2019   grade_7 46.0 3.0 3.0   0.0 0.0     0.0   2.0   20.0 34.0     5.0   0.0     10.0   8.0   54.0 46 3 3   0 0     0   2   20 34     5 0   10 8   54
1952299 1952299 MN Beltrami 4 school 2700225 4058 Charter Schools SCHOOLCRAFT LEARNING COMMUNITY CHTR 270022503464 10 SCHOOLCRAFT LEARNING COMMUNITY CHTR Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2019   grade_7 16.0 1.0 2.0   0.0 0.0     0.0   2.0   13.0 8.0     0.0   0.0     10.0   7.0   21.0 16 1 2   0 0     0   2   13 8     0 0   10 7   21
1952559 1952559 MN Hennepin 27 school 2700281 4140 Charter Schools YINGHUA ACADEMY 270028103611 10 YINGHUA ACADEMY Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2019   grade_7 47.0 5.0 0.0   2.0 22.0     0.0   0.0   30.0 46.0     3.0   1.0     10.0   9.0   76.0 47 5 0   2 22     0   0   30 46     3 1   10 9   76
1953576 1953576 MN Houston 28 school 2707380 299 Independent Districts and Schools CALEDONIA PUBLIC SCHOOL DISTRICT 270738000310 20 CALEDONIA MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_7 51.0 1.0 0.0   0.0 0.0     0.0   1.0   27.0 26.0     0.0   0.0     10.0   7.0   53.0 51 1 0   0 0     0   1   27 26     0 0   10 7   53
1953895 1953895 MN Traverse 78 school 2707110 801 Independent Districts and Schools BROWNS VALLEY PUBLIC SCHOOL DIST. 270711000280 20 BROWNS VALLEY MIDDLE Middle School (Grades 5-8) Regular School No Middle 05 08 2019   grade_7 5.0 0.0 0.0   7.0 0.0     0.0   0.0   5.0 7.0     0.0   0.0     10.0   3.0   12.0 5 0 0   7 0     0   0   5 7     0 0   10 3   12
1944722 1944722 MN Koochiching 36 school 2718270 362 Independent Districts and Schools LITTLEFORK-BIG FALLS SCHOOL DIST. 271827000848 30 LITTLEFORK-BIG FALLS SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_7 24.0 1.0 0.0   1.0 0.0     0.0   0.0   14.0 12.0     0.0   0.0     11.0   5.0   26.0 24 1 0   1 0     0   0   14 12     0 0   11 5   26
1944821 1944821 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 2019   grade_7 14.0 0.0 0.0   0.0 0.0     0.0   3.0   12.0 5.0     *   *     11.0   4.0   17.0 14 0 0   0 0     0   3   12 5           11 4   17
1944905 1944905 MN Otter Tail 56 school 2713860 545 Independent Districts and Schools HENNING PUBLIC SCHOOL DISTRICT 271386000712 20 HENNING SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_7 16.0 0.0 1.0   1.0 0.0     0.0   1.0   6.0 13.0     0.0   0.0     11.0   1.0   19.0 16 0 1   1 0     0   1   6 13     0 0   11 1   19
1944962 1944962 MN Pipestone 59 school 2711220 581 Independent Districts and Schools EDGERTON PUBLIC SCHOOL DISTRICT 271122000504 10 EDGERTON SECONDARY Secondary School (Grades 7-12) Regular School No High 06 12 2019   grade_7 21.0 1.0 5.0   0.0 0.0     0.0   0.0   15.0 12.0     4.0   0.0     11.0   7.0   27.0 21 1 5   0 0     0   0   15 12     4 0   11 7   27
1945155 1945155 MN Stevens 75 school 2713380 768 Independent Districts and Schools HANCOCK PUBLIC SCHOOL DISTRICT 271338000689 20 HANCOCK SEC. Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_7 29.0 1.0 3.0   0.0 0.0     0.0   1.0   13.0 21.0     0.0   0.0     11.0   4.0   34.0 29 1 3   0 0     0   1   13 21     0 0   11 4   34
1945782 1945782 MN Ramsey 62 school 2700337 4098 Charter Schools Nova Classical Academy 270033704356 20 NOVA CLASSICAL ACADEMY UPPER SCHOOL Secondary School (Grades 7-12) Regular School Yes High 06 12 2019   grade_7 57.0 5.0 7.0   0.0 6.0     0.0   5.0   42.0 38.0     1.0   0.0     11.0   2.0   80.0 57 5 7   0 6     0   5   42 38     1 0   11 2   80
1955521 1955521 MN Hubbard 29 school 2728080 309 Independent Districts and Schools PARK RAPIDS PUBLIC SCHOOL DISTRICT 272808004671 81 Century Middle School Within A School Public Area Learning Center ALC (State approved) Alternative School No Middle 05 08 2019   grade_7 17.0 0.0 2.0   1.0 0.0     0.0   1.0   11.0 10.0     0.0   0.0     11.0   1.0   21.0 17 0 2   1 0     0   1   11 10     0 0   11 1   21
1944559 1944559 MN Olmsted 55 school 2708220 227 Independent Districts and Schools CHATFIELD PUBLIC SCHOOLS 270822000348 1 CHATFIELD SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_7 68.0 0.0 3.0   0.0 1.0     0.0   1.0   41.0 32.0     0.0   0.0     12.0   7.0   73.0 68 0 3   0 1     0   1   41 32     0 0   12 7   73

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