enrollments

Data source: Big Local News · About: Big Local

700 rows where grade = "grade_8", state = "MN" and year = 2019 sorted by ccd_school_low_grade

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2019 · 700 ✖

grade ✖

  • grade_8 · 700 ✖
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
1949535 1949535 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384001594 494 CAPITOL HILL MAGNET/RONDO Elementary School (Grades PK-6) Regular School No Elementary 01 08 2019   grade_8 76.0 58.0 12.0   0.0 52.0     0.0   5.0   111.0 92.0     11.0   1.0     88.0   10.0   203.0 76 58 12   0 52     0   5   111 92     11 1   88 10   203
1952167 1952167 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_8 21.0 3.0 0.0   0.0 0.0     0.0   0.0   9.0 15.0     1.0   0.0     1.0   5.0   24.0 21 3 0   0 0     0   0   9 15     1 0   1 5   24
1955393 1955393 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 2019   grade_8 2.0 0.0 0.0   3.0 0.0     0.0   1.0   2.0 4.0     *   *         *   6.0 2 0 0   3 0     0   1   2 4                 6
1956520 1956520 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 2019   grade_8 1.0 3.0 0.0   0.0 0.0     0.0   0.0   3.0 1.0     *   *         *   4.0 1 3 0   0 0     0   0   3 1                 4
1956531 1956531 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 2019   grade_8 1.0 2.0 0.0   0.0 0.0     0.0   1.0   4.0 0.0     *   *         *   4.0 1 2 0   0 0     0   1   4 0                 4
1956545 1956545 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_8 5.0 0.0 2.0   1.0 0.0     0.0   0.0   7.0 1.0     *   *         *   8.0 5 0 2   1 0     0   0   7 1                 8
1956560 1956560 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 01 12 2019   grade_8 13.0 1.0 0.0   0.0 0.0     0.0   0.0   13.0 1.0     0.0   0.0     10.0   *   14.0 13 1 0   0 0     0   0   13 1     0 0   10     14
1956774 1956774 MN Mille Lacs 48 school 2700318 6079 Special Education Cooperatives RUM RIVER SPECIAL EDUCATION COOP 270031804296 10 RUM RIVER NORTH Special Education Special Education School No Other 01 12 2019   grade_8 6.0 1.0 0.0   0.0 0.0     0.0   0.0   5.0 2.0     *   *         *   7.0 6 1 0   0 0     0   0   5 2                 7
1956917 1956917 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 01 12 2019   grade_8 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
1957128 1957128 MN Brown 8 school 2791353 6049 Education Districts RIVER BEND EDUCATION DISTRICT 279135304366 35 IMPRINTS PROGRAM Special Education Special Education School No Other 01 12 2019   grade_8 3.0 0.0 1.0   0.0 0.0     0.0   0.0   4.0 0.0     *   *         *   4.0 3 0 1   0 0     0   0   4 0                 4
1956343 1956343 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 02 12 2019   grade_8 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
1956689 1956689 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 02 12 2019   grade_8 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
1957656 1957656 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 2019   grade_8 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
1951817 1951817 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124000988 134 LK NOKOMIS COMM-KEEWAYDIN CAMPUS Elementary School (Grades PK-6) Regular School No Middle 03 08 2019   grade_8 35.0 11.0 13.0   2.0 2.0     0.0   1.0   30.0 34.0     4.0   1.0     35.0   8.0   64.0 35 11 13   2 2     0   1   30 34     4 1   35 8   64
1953641 1953641 MN Mille Lacs 48 school 2725050 480 Independent Districts and Schools ONAMIA PUBLIC SCHOOL DISTRICT 272505005107 50 Onamia Intermediate School Middle School (Grades 5-8) Regular School No Other 03 09 2019   grade_8 11.0 1.0 1.0   25.0 0.0     0.0   3.0   25.0 16.0     *   *         *   41.0 11 1 1   25 0     0   3   25 16                 41
1957257 1957257 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 Other 03 12 2019   grade_8 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
1957329 1957329 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 2019   grade_8 4.0 0.0 0.0   0.0 0.0     0.0   0.0   0.0 4.0     *   *         *   4.0 4 0 0   0 0     0   0   0 4                 4
1957536 1957536 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 2019   grade_8 2.0 0.0 0.0   2.0 0.0     0.0   0.0   3.0 1.0     *   *         *   4.0 2 0 0   2 0     0   0   3 1                 4
1957561 1957561 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 2019   grade_8 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
1957838 1957838 MN Crow Wing 18 school 2706090 181 Independent Districts and Schools BRAINERD PUBLIC SCHOOL DISTRICT 270609000468 17 LINCOLN EDUCATION CENTER Miscellaneous Program (assignment is now limited) Alternative School No Other 03 12 2019   grade_8 3.0 0.0 0.0   1.0 0.0     0.0   2.0   6.0 0.0     *   *         *   6.0 3 0 0   1 0     0   2   6 0                 6
1946384 1946384 MN Benton 5 school 2712240 51 Independent Districts and Schools FOLEY PUBLIC SCHOOL DISTRICT 271224002270 30 FOLEY INTERMEDIATE ELEMENTARY Elementary School (Grades PK-6) Regular School No Middle 04 08 2019   grade_8 157.0 0.0 1.0   1.0 0.0     0.0   4.0   75.0 88.0     0.0   0.0     43.0   19.0   163.0 157 0 1   1 0     0   4   75 88     0 0   43 19   163
1946977 1946977 MN Dakota 19 school 2711820 192 Independent Districts and Schools FARMINGTON PUBLIC SCHOOL DISTRICT 271182004816 155 Gateway Academy Elementary School (Grades PK-6) Regular School No Middle 04 08 2019   grade_8 6.0 1.0 0.0   0.0 1.0     0.0   1.0   7.0 2.0     *   *         *   9.0 6 1 0   0 1     0   1   7 2                 9
1948015 1948015 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 2019   grade_8 26.0 46.0 9.0   1.0 2.0     0.0   14.0   42.0 56.0     *   *         *   98.0 26 46 9   1 2     0   14   42 56                 98
1951796 1951796 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_8 108.0 6.0 4.0   0.0 8.0     0.0   2.0   53.0 75.0     3.0   0.0     10.0   8.0   128.0 108 6 4   0 8     0   2   53 75     3 0   10 8   128
1953368 1953368 MN Cottonwood 17 school 2742780 177 Independent Districts and Schools WINDOM PUBLIC SCHOOL DISTRICT 274278003068 60 WINDOM MIDDLE Middle School (Grades 5-8) Regular School No Middle 04 08 2019   grade_8 66.0 2.0 15.0   0.0 0.0     0.0   1.0   47.0 37.0     2.0   0.0     29.0   14.0   84.0 66 2 15   0 0     0   1   47 37     2 0   29 14   84
1953715 1953715 MN Otter Tail 56 school 2711880 544 Independent Districts and Schools FERGUS FALLS PUBLIC SCHOOL DISTRICT 271188004944 380 Kennedy Middle School Middle School (Grades 5-8) Regular School No Middle 04 08 2019   grade_8 166.0 5.0 5.0   0.0 0.0     1.0   13.0   91.0 99.0     1.0   0.0     61.0   24.0   190.0 166 5 5   0 0     1   13   91 99     1 0   61 24   190
1957595 1957595 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 2019   grade_8 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
1957601 1957601 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 2019   grade_8 2.0 0.0 0.0   0.0 0.0     0.0   1.0   1.0 2.0     *   *         *   3.0 2 0 0   0 0     0   1   1 2                 3
1957646 1957646 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384004398 42 ANNA WESTIN HOUSE Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No Other 04 12 2019   grade_8 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
1957694 1957694 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 2019   grade_8 2.0 1.0 0.0   2.0 0.0     0.0   2.0   3.0 4.0     *   *         *   7.0 2 1 0   2 0     0   2   3 4                 7
1957700 1957700 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 2019   grade_8 1.0 0.0 0.0   1.0 0.0     0.0   0.0   1.0 1.0     *   *         *   2.0 1 0 0   1 0     0   0   1 1                 2
1958038 1958038 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 2019   grade_8 2.0 0.0 1.0   0.0 0.0     0.0   1.0   3.0 1.0     *   *         *   4.0 2 0 1   0 0     0   1   3 1                 4
1944927 1944927 MN Otter Tail 56 school 2740830 550 Independent Districts and Schools UNDERWOOD PUBLIC SCHOOL DISTRICT 274083001707 20 UNDERWOOD SECONDARY Secondary School (Grades 7-12) Regular School No High 05 12 2019   grade_8 41.0 0.0 0.0   2.0 0.0     0.0   0.0   19.0 24.0     0.0   0.0     16.0   2.0   43.0 41 0 0   2 0     0   0   19 24     0 0   16 2   43
1945599 1945599 MN Redwood 64 school 2700132 2884 Independent Districts and Schools RED ROCK CENTRAL SCHOOL DISTRICT 270013200820 20 RED ROCK CENTRAL SECONDARY Secondary School (Grades 7-12) Regular School No High 05 12 2019   grade_8 31.0 0.0 1.0   0.0 0.0     0.0   1.0   15.0 18.0     0.0   0.0     15.0   2.0   33.0 31 0 1   0 0     0   1   15 18     0 0   15 2   33
1949588 1949588 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 05 08 2019   grade_8 46.0 40.0 10.0   1.0 23.0     0.0   6.0   51.0 75.0     32.0   1.0     76.0   26.0   126.0 46 40 10   1 23     0   6   51 75     32 1   76 26   126
1953227 1953227 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_8 20.0 0.0 1.0   1.0 0.0     0.0   3.0   12.0 13.0     0.0   0.0     15.0   3.0   25.0 20 0 1   1 0     0   3   12 13     0 0   15 3   25
1953264 1953264 MN Anoka 2 school 2712420 14 Independent Districts and Schools FRIDLEY PUBLIC SCHOOL DISTRICT 271242000610 23 FRIDLEY MIDDLE Middle School (Grades 5-8) Regular School No Middle 05 08 2019   grade_8 64.0 93.0 35.0   1.0 13.0     0.0   15.0   115.0 106.0     29.0   6.0     162.0   22.0   221.0 64 93 35   1 13     0   15   115 106     29 6   162 22   221
1953273 1953273 MN Anoka 2 school 2733330 16 Independent Districts and Schools SPRING LAKE PARK PUBLIC SCHOOLS 273333001466 92 Westwood Intermediate and Middle School Middle School (Grades 5-8) Regular School No Middle 05 08 2019   grade_8 238.0 55.0 64.0   2.0 34.0     1.0   22.0   221.0 195.0     28.0   5.0     137.0   38.0   416.0 238 55 64   2 34     1   22   221 195     28 5   137 38   416
1953278 1953278 MN Becker 3 school 2710230 22 Independent Districts and Schools DETROIT LAKES PUBLIC SCHOOL DIST. 271023000443 4 DETROIT LAKES MIDDLE Middle School (Grades 5-8) Regular School No Middle 05 08 2019   grade_8 193.0 2.0 4.0   15.0 2.0     0.0   21.0   112.0 125.0     *   *         *   237.0 193 2 4   15 2     0   21   112 125                 237
1953303 1953303 MN Brown 8 school 2723490 88 Independent Districts and Schools NEW ULM PUBLIC SCHOOL DISTRICT 272349005035 40 NEW ULM MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 05 08 2019   grade_8 134.0 1.0 7.0   0.0 1.0     0.0   1.0   80.0 64.0     1.0   0.0     47.0   25.0   144.0 134 1 7   0 1     0   1   80 64     1 0   47 25   144
1953308 1953308 MN Carlton 9 school 2709420 94 Independent Districts and Schools CLOQUET PUBLIC SCHOOL DISTRICT 270942000381 201 CLOQUET MIDDLE Middle School (Grades 5-8) Regular School No Middle 05 08 2019   grade_8 139.0 0.0 2.0   18.0 1.0     1.0   28.0   108.0 81.0     *   *         *   189.0 139 0 2   18 1     1   28   108 81                 189
1953321 1953321 MN Carver 10 school 2741910 111 Independent Districts and Schools WATERTOWN-MAYER PUBLIC SCHOOL DIST. 274191000024 841 WATERTOWN-MAYER MIDDLE Middle School (Grades 5-8) Regular School No Middle 05 08 2019   grade_8 124.0 0.0 1.0   0.0 1.0     0.0   2.0   64.0 64.0     0.0   0.0     23.0   11.0   128.0 124 0 1   0 1     0   2   64 64     0 0   23 11   128
1953338 1953338 MN Cass 11 school 2708070 115 Independent Districts and Schools CASS LAKE-BENA PUBLIC SCHOOLS 270807003181 20 CASS LAKE-BENA MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 05 08 2019   grade_8 8.0 0.0 2.0   63.0 0.0     0.0   2.0   42.0 33.0     *   *         *   75.0 8 0 2   63 0     0   2   42 33                 75
1953343 1953343 MN Cass 11 school 2728350 116 Independent Districts and Schools PILLAGER PUBLIC SCHOOL DISTRICT 272835004841 40 Pillager Middle School Middle School (Grades 5-8) Regular School No Middle 05 08 2019   grade_8 83.0 0.0 2.0   1.0 0.0     0.0   1.0   39.0 48.0     0.0   0.0     34.0   16.0   87.0 83 0 2   1 0     0   1   39 48     0 0   34 16   87
1953353 1953353 MN Chisago 13 school 2723820 138 Independent Districts and Schools NORTH BRANCH PUBLIC SCHOOLS 272382001164 20 NORTH BRANCH MIDDLE Middle School (Grades 5-8) Regular School No Middle 05 08 2019   grade_8 163.0 2.0 5.0   1.0 5.0     0.0   4.0   92.0 88.0     *   *         *   180.0 163 2 5   1 5     0   4   92 88                 180
1953358 1953358 MN Clay 14 school 2721420 152 Independent Districts and Schools MOORHEAD PUBLIC SCHOOL DISTRICT 272142003512 380 HORIZON MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 05 08 2019   grade_8 338.0 37.0 44.0   15.0 3.0     0.0   28.0   250.0 215.0     *   6.0         68.0   465.0 338 37 44   15 3     0   28   250 215       6     68   465
1953373 1953373 MN Crow Wing 18 school 2706090 181 Independent Districts and Schools BRAINERD PUBLIC SCHOOL DISTRICT 270609004196 22 FORESTVIEW MIDDLE Middle School (Grades 5-8) Regular School No Middle 05 08 2019   grade_8 466.0 10.0 4.0   9.0 4.0     1.0   15.0   238.0 271.0     0.0   2.0     183.0   94.0   509.0 466 10 4   9 4     1   15   238 271     0 2   183 94   509
1953378 1953378 MN Crow Wing 18 school 2728200 186 Independent Districts and Schools PEQUOT LAKES PUBLIC SCHOOLS 272820003069 15 PEQUOT LAKES MIDDLE Middle School (Grades 5-8) Regular School No Middle 05 08 2019   grade_8 139.0 3.0 0.0   3.0 0.0     0.0   4.0   74.0 75.0     0.0   1.0     30.0   13.0   149.0 139 3 0   3 0     0   4   74 75     0 1   30 13   149
1953439 1953439 MN Dakota 19 school 2742270 197 Independent Districts and Schools WEST ST. PAUL-MENDOTA HTS.-EAGAN 274227002646 52 FRIENDLY HILLS MIDDLE Middle School (Grades 5-8) Regular School No Middle 05 08 2019   grade_8 88.0 30.0 29.0   0.0 9.0     0.0   14.0   88.0 82.0     12.0   1.0     66.0   28.0   170.0 88 30 29   0 9     0   14   88 82     12 1   66 28   170
1953444 1953444 MN Dakota 19 school 2742270 197 Independent Districts and Schools WEST ST. PAUL-MENDOTA HTS.-EAGAN 274227001774 54 HERITAGE E-STEM MAGNET SCHOOL Middle School (Grades 5-8) Regular School No Middle 05 08 2019   grade_8 76.0 12.0 64.0   0.0 3.0     0.0   10.0   82.0 83.0     21.0   0.0     89.0   26.0   165.0 76 12 64   0 3     0   10   82 83     21 0   89 26   165
1953453 1953453 MN Dakota 19 school 2713530 200 Independent Districts and Schools HASTINGS PUBLIC SCHOOL DISTRICT 271353000693 130 HASTINGS MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 05 08 2019   grade_8 286.0 6.0 14.0   1.0 1.0     0.0   12.0   176.0 144.0     *   *         *   320.0 286 6 14   1 1     0   12   176 144                 320
1953458 1953458 MN Dodge 20 school 2716980 204 Independent Districts and Schools KASSON-MANTORVILLE SCHOOL DISTRICT 271698002243 40 KASSON-MANTORVILLE MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 05 08 2019   grade_8 173.0 0.0 3.0   0.0 0.0     0.0   3.0   91.0 88.0     0.0   2.0     24.0   21.0   179.0 173 0 3   0 0     0   3   91 88     0 2   24 21   179
1953474 1953474 MN Goodhue 25 school 2728950 255 Independent Districts and Schools PINE ISLAND PUBLIC SCHOOL DIST. 272895004143 15 PINE ISLAND MIDDLE Middle School (Grades 5-8) Regular School No Middle 05 08 2019   grade_8 91.0 2.0 4.0   0.0 1.0     0.0   1.0   51.0 48.0     0.0   0.0     20.0   9.0   99.0 91 2 4   0 1     0   1   51 48     0 0   20 9   99
1953582 1953582 MN Houston 28 school 2717250 300 Independent Districts and Schools LA CRESCENT-HOKAH SCHOOL DISTRICT 271725004238 50 LA CRESCENT-HOKAH MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 05 08 2019   grade_8 89.0 3.0 4.0   0.0 1.0     0.0   1.0   49.0 49.0     0.0   0.0     15.0   13.0   98.0 89 3 4   0 1     0   1   49 49     0 0   15 13   98
1953587 1953587 MN Hubbard 29 school 2728080 309 Independent Districts and Schools PARK RAPIDS PUBLIC SCHOOL DISTRICT 272808001236 80 PARK RAPIDS AREA CENTURY MIDDLE Middle School (Grades 5-8) Regular School No Middle 05 08 2019   grade_8 116.0 0.0 9.0   1.0 0.0     0.0   8.0   59.0 75.0     0.0   0.0     57.0   24.0   134.0 116 0 9   1 0     0   8   59 75     0 0   57 24   134
1953592 1953592 MN Itasca 31 school 2709480 316 Independent Districts and Schools GREENWAY PUBLIC SCHOOL DISTRICT 270948002785 210 GREENWAY MIDDLE Middle School (Grades 5-8) Regular School No Middle 05 08 2019   grade_8 67.0 1.0 4.0   7.0 1.0     0.0   0.0   45.0 35.0     1.0   0.0     42.0   16.0   80.0 67 1 4   7 1     0   0   45 35     1 0   42 16   80
1953597 1953597 MN Itasca 31 school 2713170 318 Independent Districts and Schools GRAND RAPIDS PUBLIC SCHOOL DISTRICT 271317000939 370 ROBERT J. ELKINGTON MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 05 08 2019   grade_8 280.0 0.0 5.0   9.0 3.0     0.0   22.0   168.0 151.0     0.0   *     107.0   53.0   319.0 280 0 5   9 3     0   22   168 151     0     107 53   319
1953602 1953602 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 2019   grade_8 108.0 0.0 9.0   0.0 0.0     1.0   0.0   62.0 56.0     2.0   0.0     24.0   14.0   118.0 108 0 9   0 0     1   0   62 56     2 0   24 14   118
1953611 1953611 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 2019   grade_8 113.0 14.0 16.0   0.0 13.0     0.0   4.0   74.0 86.0     *   *         *   160.0 113 14 16   0 13     0   4   74 86                 160
1953616 1953616 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_8 2.0 0.0 3.0   0.0 0.0     0.0   0.0   3.0 2.0     *   *         *   5.0 2 0 3   0 0     0   0   3 2                 5
1953625 1953625 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 2019   grade_8 111.0 1.0 10.0   1.0 0.0     0.0   3.0   56.0 70.0     3.0   0.0     50.0   18.0   126.0 111 1 10   1 0     0   3   56 70     3 0   50 18   126
1953630 1953630 MN Wright 86 school 2710060 466 Independent Districts and Schools DASSEL-COKATO PUBLIC SCHOOL DIST. 271006002267 4 DASSEL-COKATO MIDDLE Middle School (Grades 5-8) Regular School No Middle 05 08 2019   grade_8 141.0 1.0 7.0   1.0 2.0     0.0   2.0   86.0 68.0     2.0   0.0     45.0   17.0   154.0 141 1 7   1 2     0   2   86 68     2 0   45 17   154
1953658 1953658 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_8 38.0 2.0 1.0   0.0 0.0     0.0   1.0   19.0 23.0     0.0   0.0     13.0   6.0   42.0 38 2 1   0 0     0   1   19 23     0 0   13 6   42
1953667 1953667 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_8 29.0 1.0 5.0   0.0 0.0     0.0   2.0   12.0 25.0     0.0   0.0     10.0   9.0   37.0 29 1 5   0 0     0   2   12 25     0 0   10 9   37
1953672 1953672 MN Nicollet 52 school 2733870 508 Independent Districts and Schools ST. PETER PUBLIC SCHOOL DISTRICT 273387002533 80 St. Peter Middle School Middle School (Grades 5-8) Regular School No Middle 05 08 2019   grade_8 146.0 11.0 18.0   0.0 2.0     0.0   6.0   91.0 92.0     *   *         *   183.0 146 11 18   0 2     0   6   91 92                 183
1953681 1953681 MN Nobles 53 school 2744160 518 Independent Districts and Schools WORTHINGTON PUBLIC SCHOOL DISTRICT 274416001840 4 WORTHINGTON MIDDLE Middle School (Grades 5-8) Regular School No Middle 05 08 2019   grade_8 64.0 24.0 113.0   0.0 29.0     1.0   7.0   128.0 110.0     *   *     166.0   *   238.0 64 24 113   0 29     1   7   128 110           166     238
1953720 1953720 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 2019   grade_8 114.0 1.0 12.0   0.0 0.0     0.0   4.0   64.0 67.0     2.0   0.0     40.0   22.0   131.0 114 1 12   0 0     0   4   64 67     2 0   40 22   131
1953772 1953772 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384001567 315 FARNSWORTH AEROSPACE UPPER Middle School (Grades 5-8) Regular School No Middle 05 08 2019   grade_8 10.0 35.0 18.0   1.0 109.0     0.0   9.0   90.0 92.0     46.0   2.0     144.0   23.0   182.0 10 35 18   1 109     0   9   90 92     46 2   144 23   182
1953805 1953805 MN Saint Louis 69 school 2713920 700 Independent Districts and Schools HERMANTOWN PUBLIC SCHOOL DISTRICT 271392002143 15 HERMANTOWN MIDDLE Middle School (Grades 5-8) Regular School No Middle 05 08 2019   grade_8 165.0 1.0 3.0   1.0 1.0     0.0   7.0   82.0 96.0     2.0   1.0     21.0   22.0   178.0 165 1 3   1 1     0   7   82 96     2 1   21 22   178
1953822 1953822 MN Scott 70 school 2715750 717 Independent Districts and Schools JORDAN PUBLIC SCHOOL DISTRICT 271575004144 128 JORDAN MIDDLE Middle School (Grades 5-8) Regular School No Middle 05 08 2019   grade_8 129.0 4.0 14.0   2.0 4.0     0.0   5.0   83.0 75.0     6.0   0.0     32.0   23.0   158.0 129 4 14   2 4     0   5   83 75     6 0   32 23   158
1953883 1953883 MN Stearns 73 school 2732820 748 Independent Districts and Schools SARTELL-ST. STEPHEN SCHOOL DISTRICT 273282001675 50 SARTELL MIDDLE Middle School (Grades 5-8) Regular School No Middle 05 08 2019   grade_8 325.0 9.0 10.0   2.0 8.0     0.0   7.0   192.0 169.0     3.0   1.0     50.0   50.0   361.0 325 9 10   2 8     0   7   192 169     3 1   50 50   361
1953896 1953896 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_8 4.0 0.0 0.0   7.0 0.0     0.0   0.0   4.0 7.0     0.0   0.0     8.0   3.0   11.0 4 0 0   7 0     0   0   4 7     0 0   8 3   11
1953901 1953901 MN Wadena 80 school 2720580 821 Independent Districts and Schools MENAHGA PUBLIC SCHOOL DISTRICT 272058005019 20 Menahga Middle School Middle School (Grades 5-8) Regular School No Middle 05 08 2019   grade_8 82.0 0.0 2.0   0.0 1.0     0.0   3.0   40.0 48.0     3.0   2.0     42.0   17.0   88.0 82 0 2   0 1     0   3   40 48     3 2   42 17   88
1953937 1953937 MN Winona 85 school 2744070 861 Independent Districts and Schools WINONA AREA PUBLIC SCHOOL DISTRICT 274407001830 6 WINONA MIDDLE Middle School (Grades 5-8) Regular School No Middle 05 08 2019   grade_8 172.0 10.0 7.0   1.0 5.0     0.0   17.0   107.0 105.0     7.0   0.0     67.0   37.0   212.0 172 10 7   1 5     0   17   107 105     7 0   67 37   212
1953958 1953958 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 2019   grade_8 93.0 4.0 14.0   2.0 2.0     0.0   3.0   54.0 64.0     4.0   0.0     30.0   9.0   118.0 93 4 14   2 2     0   3   54 64     4 0   30 9   118
1953963 1953963 MN Wright 86 school 2733790 885 Independent Districts and Schools ST. MICHAEL-ALBERTVILLE SCHOOL DIST 273379001536 30 ST. MICHAEL-ALBERTVILLE MIDDLE EAST Middle School (Grades 5-8) Regular School No Middle 05 08 2019   grade_8 222.0 6.0 8.0   0.0 6.0     0.0   9.0   133.0 118.0     1.0   1.0     25.0   20.0   251.0 222 6 8   0 6     0   9   133 118     1 1   25 20   251
1953968 1953968 MN Wright 86 school 2733790 885 Independent Districts and Schools ST. MICHAEL-ALBERTVILLE SCHOOL DIST 273379004346 90 ST MICHAEL-ALBERTVILLE MIDDLE WEST Middle School (Grades 5-8) Regular School No Middle 05 08 2019   grade_8 230.0 9.0 7.0   0.0 5.0     0.0   15.0   150.0 116.0     5.0   0.0     27.0   23.0   266.0 230 9 7   0 5     0   15   150 116     5 0   27 23   266
1954006 1954006 MN Goodhue 25 school 2717100 2172 Independent Districts and Schools KENYON-WANAMINGO SCHOOL DISTRICT 271710001741 40 KENYON-WANAMINGO MIDDLE Middle School (Grades 5-8) Regular School No Middle 05 08 2019   grade_8 54.0 0.0 3.0   0.0 0.0     0.0   1.0   28.0 30.0     3.0   0.0     16.0   7.0   58.0 54 0 3   0 0     0   1   28 30     3 0   16 7   58
1954019 1954019 MN Grant 26 school 2700104 2342 Independent Districts and Schools WEST CENTRAL AREA 270010404375 4 WCA Middle School Middle School (Grades 5-8) Regular School No Middle 05 08 2019   grade_8 59.0 0.0 4.0   0.0 0.0     0.0   0.0   36.0 27.0     0.0   0.0     22.0   11.0   63.0 59 0 4   0 0     0   0   36 27     0 0   22 11   63
1954024 1954024 MN Renville 65 school 2712580 2365 Independent Districts and Schools G.F.W. Public School District 271258000043 2 G.F.W. Middle School Middle School (Grades 5-8) Regular School No Middle 05 08 2019   grade_8 36.0 1.0 7.0   0.0 0.0     0.0   1.0   18.0 27.0     0.0   0.0     21.0   8.0   45.0 36 1 7   0 0     0   1   18 27     0 0   21 8   45
1954037 1954037 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 2019   grade_8 93.0 0.0 6.0   0.0 0.0     0.0   3.0   46.0 56.0     0.0   0.0     24.0   12.0   102.0 93 0 6   0 0     0   3   46 56     0 0   24 12   102
1954042 1954042 MN Pipestone 59 school 2700108 2689 Independent Districts and Schools PIPESTONE AREA SCHOOL DISTRICT 270010801264 7 PIPESTONE MIDDLE Middle School (Grades 5-8) Regular School No Middle 05 08 2019   grade_8 67.0 0.0 7.0   0.0 0.0     0.0   4.0   41.0 37.0     *   *         *   78.0 67 0 7   0 0     0   4   41 37                 78
1954060 1954060 MN Redwood 64 school 2700182 2897 Independent Districts and Schools REDWOOD AREA SCHOOL DISTRICT 270018202301 3 REDWOOD VALLEY MIDDLE Middle School (Grades 5-8) Regular School No Middle 05 08 2019   grade_8 50.0 1.0 5.0   17.0 0.0     0.0   2.0   45.0 30.0     0.0   1.0     28.0   13.0   75.0 50 1 5   17 0     0   2   45 30     0 1   28 13   75
1954077 1954077 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 2019   grade_8 94.0 22.0 8.0   1.0 5.0     0.0   3.0   63.0 70.0     5.0   0.0     29.0   20.0   133.0 94 22 8   1 5     0   3   63 70     5 0   29 20   133
1954117 1954117 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_8 50.0 1.0 3.0   1.0 0.0     0.0   1.0   35.0 21.0     0.0   0.0     14.0   12.0   56.0 50 1 3   1 0     0   1   35 21     0 0   14 12   56
1954122 1954122 MN Hennepin 27 school 2700220 4067 Charter Schools AURORA CHARTER SCHOOL 270022004420 20 AURORA MIDDLE SCHOOL Middle School (Grades 5-8) Regular School Yes Middle 05 08 2019   grade_8 0.0 0.0 43.0   0.0 0.0     0.0   0.0   22.0 21.0     *   0.0         4.0   43.0 0 0 43   0 0     0   0   22 21       0     4   43
1954134 1954134 MN Hennepin 27 school 2700189 4078 Charter Schools Twin Cities International Schools 270018903142 10 Minnesota International Middle Charter School Middle School (Grades 5-8) Regular School Yes Middle 05 08 2019   grade_8 0.0 113.0 0.0   0.0 0.0     0.0   0.0   51.0 62.0     33.0   0.0         6.0   113.0 0 113 0   0 0     0   0   51 62     33 0     6   113
1954151 1954151 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_8 71.0 3.0 4.0   1.0 8.0     0.0   3.0   42.0 48.0     0.0   0.0     3.0   9.0   90.0 71 3 4   1 8     0   3   42 48     0 0   3 9   90
1954160 1954160 MN Hennepin 27 school 2700245 4131 Charter Schools METRO SCHOOLS CHARTER 270024504857 20 Metro Schools Middle Charter Middle School (Grades 5-8) Regular School Yes Middle 05 08 2019   grade_8 0.0 50.0 0.0   0.0 0.0     0.0   0.0   26.0 24.0     36.0   0.0     18.0   3.0   50.0 0 50 0   0 0     0   0   26 24     36 0   18 3   50
1954174 1954174 MN Ramsey 62 school 2700292 4164 Charter Schools LAURA JEFFREY ACADEMY CHARTER 270029203713 10 LAURA JEFFREY ACADEMY CHARTER Middle School (Grades 5-8) Regular School Yes Middle 05 08 2019   grade_8 11.0 6.0 3.0   1.0 3.0     0.0   0.0   1.0 23.0     0.0   1.0     14.0   6.0   24.0 11 6 3   1 3     0   0   1 23     0 1   14 6   24
1954179 1954179 MN Hennepin 27 school 2700288 4170 Charter Schools HIAWATHA ACADEMIES 270028804599 11 Hiawatha College Prep - Kingfield Middle School (Grades 5-8) Regular School Yes Middle 05 08 2019   grade_8 1.0 1.0 88.0   1.0 0.0     0.0   2.0   52.0 41.0     35.0   5.0         10.0   93.0 1 1 88   1 0     0   2   52 41     35 5     10   93
1954186 1954186 MN Hennepin 27 school 2700333 4199 Charter Schools PARNASSUS PREPARATORY CHARTER SCH 270033304837 20 Parnassus Preparatory School-Logic Middle School (Grades 5-8) Regular School Yes Middle 05 08 2019   grade_8 26.0 25.0 7.0   0.0 7.0     0.0   4.0   27.0 42.0     4.0   0.0     21.0   7.0   69.0 26 25 7   0 7     0   4   27 42     4 0   21 7   69
1954199 1954199 MN Isanti 30 school 2700397 4227 Charter Schools Art and Science Academy 270039705095 30 Art & Science Academy Middle School Middle School (Grades 5-8) Regular School Yes Middle 05 08 2019   grade_8 39.0 0.0 1.0   0.0 0.0     0.0   3.0   16.0 27.0     0.0   0.0     15.0   6.0   43.0 39 0 1   0 0     0   3   16 27     0 0   15 6   43
1954204 1954204 MN Unknown   school 2700399 4231 Charter Schools Minnesota Math and Science Academy 270039905177 20 MMSA Middle School Middle School (Grades 5-8) Regular School Yes Middle 05 08 2019   grade_8 1.0 32.0 0.0   0.0 0.0     0.0   0.0   11.0 22.0     23.0   0.0         3.0   33.0 1 32 0   0 0     0   0   11 22     23 0     3   33
1955345 1955345 MN Anoka 2 school 2712420 14 Independent Districts and Schools FRIDLEY PUBLIC SCHOOL DISTRICT 271242003427 652 FRIDLEY MIDDLE AREA LEARNING CENTER Public Area Learning Center ALC (State approved) Alternative School No Middle 05 08 2019   grade_8 3.0 4.0 3.0   0.0 0.0     0.0   3.0   7.0 6.0     0.0   1.0     11.0   0.0   13.0 3 4 3   0 0     0   3   7 6     0 1   11 0   13
1955431 1955431 MN Clay 14 school 2721420 152 Independent Districts and Schools MOORHEAD PUBLIC SCHOOL DISTRICT 272142000462 980 Red River Area Learning Center Public Area Learning Center ALC (State approved) Alternative School No High 05 12 2019   grade_8 1.0 0.0 1.0   1.0 0.0     0.0   1.0   4.0 0.0     *   *         *   4.0 1 0 1   1 0     0   1   4 0                 4
1955444 1955444 MN Crow Wing 18 school 2706090 181 Independent Districts and Schools BRAINERD PUBLIC SCHOOL DISTRICT 270609002982 21 MIDDLE LEVEL ALTERNATIVE PROGRAM Public Area Learning Center ALC (State approved) Alternative School No Middle 05 08 2019   grade_8 8.0 1.0 0.0   0.0 0.0     0.0   1.0   3.0 7.0     *   *         *   10.0 8 1 0   0 0     0   1   3 7                 10
1955522 1955522 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_8 16.0 1.0 1.0   2.0 0.0     0.0   2.0   12.0 10.0     1.0   0.0     17.0   1.0   22.0 16 1 1   2 0     0   2   12 10     1 0   17 1   22
1956463 1956463 MN Hennepin 27 school 2700025 287 Intermediate Districts and Schools INTERMEDIATE SCHOOL DISTRICT 287 270002504327 428 INVEST HIGH SCHOOL Special Education Special Education School No High 05 12 2019   grade_8 3.0 6.0 0.0   0.0 0.0     0.0   0.0   5.0 4.0     *   *         *   9.0 3 6 0   0 0     0   0   5 4                 9
1956492 1956492 MN Hennepin 27 school 2700025 287 Intermediate Districts and Schools INTERMEDIATE SCHOOL DISTRICT 287 270002503216 453 EXPLORE Special Education Special Education School No High 05 12 2019   grade_8 1.0 6.0 2.0   0.0 0.0     0.0   0.0   8.0 1.0     *   *         *   9.0 1 6 2   0 0     0   0   8 1                 9

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