Data source: Big Local News · About: Big Local

671 rows where grade = "grade_7", state = "MN" and year = 2015 sorted by white descending

View and edit SQL

year

  • 2015 · 671

grade

  • grade_7 · 671
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
1154882 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 2 05 08 2015   grade_7 99.0 0.0 5.0   1.0 0.0     0.0   1.0   55.0 51.0     1.0   0.0     27.0   18.0   106.0 99 0 5   1 0     0   1   55 51     1 0   27 18   106
1154986 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 2 05 08 2015   grade_7 99.0 1.0 9.0   2.0 0.0     0.0   4.0   70.0 45.0     3.0   0.0     46.0   22.0   115.0 99 1 9   2 0     0   4   70 45     3 0   46 22   115
1155242 MN Clay 14 school 2710260 2164 Independent Districts and Schools DILWORTH-GLYNDON-FELTON 271026000448 3 DILWORTH-GLYNDON-FELTON MIDDLE SCH Middle School (Grades 5-8) Regular School No 2 06 08 2015   grade_7 99.0 1.0 7.0   1.0 0.0     0.0   1.0   47.0 62.0     1.0   0.0     25.0   9.0   109.0 99 1 7   1 0     0   1   47 62     1 0   25 9   109
1159143 MN Mcleod 43 school 2700128 2859 Independent Districts and Schools GLENCOE-SILVER LAKE SCHOOL DISTRICT 270012801445 40 LINCOLN JUNIOR HIGH Junior High School (Grades 7-8 or 7-9) Regular School No 2 07 08 2015   grade_7 99.0 0.0 16.0   1.0 2.0     0.0   3.0   60.0 61.0     5.0   0.0     45.0   7.0   121.0 99 0 16   1 2     0   3   60 61     5 0   45 7   121
1154891 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 2 05 08 2015   grade_7 98.0 12.0 22.0   1.0 3.0     0.0   6.0   74.0 68.0     13.0   1.0     57.0   19.0   142.0 98 12 22   1 3     0   6   74 68     13 1   57 19   142
1155295 MN Jackson 32 school 2700231 2895 Independent Districts and Schools JACKSON COUNTY CENTRAL SCHOOL DIST. 270023102042 115 JACKSON COUNTY CENTRAL MIDDLE Middle School (Grades 5-8) Regular School No 2 06 08 2015   grade_7 98.0 1.0 2.0   0.0 2.0     0.0   2.0   62.0 43.0     1.0   0.0     41.0   19.0   105.0 98 1 2   0 2     0   2   62 43     1 0   41 19   105
1146593 MN Morrison 49 school 2728320 484 Independent Districts and Schools PIERZ PUBLIC SCHOOL DISTRICT 272832001252 30 HEALY SECONDARY Secondary School (Grades 7-12) Regular School No 3 07 12 2015   grade_7 97.0 0.0 2.0   0.0 0.0     0.0   1.0   52.0 48.0     1.0   *     45.0   10.0   100.0 97 0 2   0 0     0   1   52 48     1     45 10   100
1146858 MN Saint Louis 69 school 2741040 706 Independent Districts and Schools VIRGINIA PUBLIC SCHOOL DISTRICT 274104001718 90 VIRGINIA SECONDARY Secondary School (Grades 7-12) Regular School No 3 07 12 2015   grade_7 97.0 4.0 0.0   3.0 1.0     0.0   12.0   63.0 54.0     1.0   0.0     46.0   14.0   117.0 97 4 0   3 1     0   12   63 54     1 0   46 14   117
1154595 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 2 05 08 2015   grade_7 97.0 58.0 32.0   7.0 20.0     0.0   11.0   125.0 100.0     29.0   2.0     151.0   35.0   225.0 97 58 32   7 20     0   11   125 100     29 2   151 35   225
1154837 MN Hennepin 27 school 2733420 282 Independent Districts and Schools ST. ANTHONY-NEW BRIGHTON SCHOOLS 273342001949 50 ST. ANTHONY MIDDLE Middle School (Grades 5-8) Regular School No 2 06 08 2015   grade_7 97.0 9.0 18.0   3.0 9.0     0.0   6.0   73.0 69.0     10.0   0.0     32.0   14.0   142.0 97 9 18   3 9     0   6   73 69     10 0   32 14   142
1154981 MN Olmsted 55 school 2731800 535 Independent Districts and Schools ROCHESTER PUBLIC SCHOOL DISTRICT 273180002449 340 FRIEDELL MIDDLE Middle School (Grades 5-8) Regular School No 2 06 08 2015   grade_7 96.0 13.0 10.0   0.0 27.0     0.0   4.0   78.0 72.0     8.0   0.0     33.0   13.0   150.0 96 13 10   0 27     0   4   78 72     8 0   33 13   150
1159083 MN Scott 70 school 2704050 716 Independent Districts and Schools BELLE PLAINE PUBLIC SCHOOL DISTRICT 270405002169 30 BELLE PLAINE JUNIOR HIGH Junior High School (Grades 7-8 or 7-9) Regular School No 2 07 08 2015   grade_7 95.0 0.0 2.0   0.0 2.0     0.0   5.0   56.0 48.0     0.0   0.0     21.0   13.0   104.0 95 0 2   0 2     0   5   56 48     0 0   21 13   104
1146969 MN Wabasha 79 school 2717520 813 Independent Districts and Schools LAKE CITY PUBLIC SCHOOL DISTRICT 271752000804 40 LINCOLN SECONDARY Secondary School (Grades 7-12) Regular School No 3 07 12 2015   grade_7 94.0 0.0 2.0   0.0 1.0     0.0   2.0   56.0 43.0     1.0   1.0     30.0   13.0   99.0 94 0 2   0 1     0   2   56 43     1 1   30 13   99
1147574 MN Sherburne 71 school 2700276 4160 Charter Schools SPECTRUM HIGH SCHOOL 270027603615 10 SPECTRUM HIGH SCHOOL Secondary School (Grades 7-12) Regular School Yes 3 07 12 2015   grade_7 93.0 2.0 2.0   0.0 1.0     0.0   4.0   40.0 62.0     2.0   0.0     19.0   15.0   102.0 93 2 2   0 1     0   4   40 62     2 0   19 15   102
1158484 MN Houston 28 school 2714280 294 Independent Districts and Schools HOUSTON PUBLIC SCHOOL DISTRICT 271428003187 12 MINNESOTA VIRTUAL ACADEMY Distance Learning Program OLL (State approved) Regular School No 4 KG 12 2015   grade_7 93.0 4.0 1.0   2.0 4.0     0.0   1.0   56.0 49.0     2.0   0.0     25.0   22.0   105.0 93 4 1   2 4     0   1   56 49     2 0   25 22   105
1153219 MN Lesueur 40 school 2700379 2905 Independent Districts and Schools TRI-CITY UNITED SCHOOL DISTRICT 270037904625 30 MONTGOMERY PRE K-8 Elementary School (Grades PK-6) Regular School No 1 PK 08 2015   grade_7 91.0 0.0 7.0   1.0 1.0     1.0   1.0   57.0 45.0     4.0   2.0     39.0   14.0   102.0 91 0 7   1 1     1   1   57 45     4 2   39 14   102
1155430 MN Ramsey 62 school 2700376 4210 Charter Schools Upper Mississippi Academy 270037604693 20 Upper Mississippi Middle Academy Middle School (Grades 5-8) Regular School Yes 2 06 08 2015   grade_7 91.0 13.0 14.0   0.0 1.0     0.0   9.0   88.0 40.0         *         *   128.0 91 13 14   0 1     0   9   88 40                 128
1156945 MN Saint Louis 69 school 2711040 709 Independent Districts and Schools DULUTH PUBLIC SCHOOL DISTRICT 271104002237 611 DULUTH AREA LEARNING CENTER Public Area Learning Center ALC (State approved) Alternative Education School No 4 06 12 2015   grade_7 91.0 20.0 3.0   14.0 1.0     0.0   11.0   81.0 59.0     1.0   9.0     114.0   51.0   140.0 91 20 3   14 1     0   11   81 59     1 9   114 51   140
1153304 MN Hennepin 27 school 2721240 1 Special Districts and Schools MINNEAPOLIS PUBLIC SCHOOL DIST. 272124000969 121 LAKE HARRIET UPPER SCHOOL Elementary School (Grades PK-6) Regular School No 2 04 08 2015   grade_7 90.0 9.0 1.0   1.0 7.0     0.0   0.0   47.0 61.0     2.0   0.0     12.0   10.0   108.0 90 9 1   1 7     0   0   47 61     2 0   12 10   108
1146558 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 3 07 12 2015   grade_7 9.0 0.0 0.0   0.0 0.0     0.0   0.0   4.0 5.0         *         *   9.0 9 0 0   0 0     0   0   4 5                 9
1146764 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384004680 211 Creative Arts Secondary School Secondary School (Grades 7-12) Regular School No 4 06 12 2015   grade_7 9.0 28.0 11.0   2.0 11.0     0.0   0.0   16.0 45.0     10.0   1.0     47.0   12.0   61.0 9 28 11   2 11     0   0   16 45     10 1   47 12   61
1147026 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 3 07 12 2015   grade_7 9.0 0.0 2.0   0.0 0.0     0.0   0.0   6.0 5.0         *     5.0   *   11.0 9 0 2   0 0     0   0   6 5           5     11
1153911 MN Hennepin 27 school 2700354 4089 Charter Schools NEW CITY SCHOOL 270035404849 20 New City School - East Campus Elementary School (Grades PK-6) Regular School Yes 1 KG 08 2015   grade_7 9.0 3.0 1.0   0.0 1.0     0.0   1.0   9.0 6.0     1.0   0.0     8.0   2.0   15.0 9 3 1   0 1     0   1   9 6     1 0   8 2   15
1156787 MN Lyon 42 school 2718940 413 Independent Districts and Schools MARSHALL PUBLIC SCHOOL DISTRICT 271894002816 8 MATEC Public Area Learning Center ALC (State approved) Alternative Education School No 3 07 12 2015   grade_7 9.0 4.0 2.0   0.0 3.0     0.0   1.0   10.0 9.0     7.0   0.0     16.0   6.0   19.0 9 4 2   0 3     0   1   10 9     7 0   16 6   19
1158337 MN Scott 70 school 2700387 6088 Miscellaneous Cooperatives Southwest Metro Educational Coop 270038704860 12 SW Metro River Valley Education Center Special Education Special Education School No 4 KG 12 2015   grade_7 9.0 0.0 0.0   0.0 0.0     0.0   0.0   8.0 1.0         *         *   9.0 9 0 0   0 0     0   0   8 1                 9
1158595 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 3 07 12 2015   grade_7 9.0 3.0 0.0   0.0 0.0     0.0   0.0   4.0 8.0     0.0   0.0     4.0   2.0   12.0 9 3 0   0 0     0   0   4 8     0 0   4 2   12
1159429 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 4 KG 12 2015   grade_7 9.0 0.0 0.0   0.0 0.0     0.0   1.0   5.0 5.0     0.0   0.0     6.0   1.0   10.0 9 0 0   0 0     0   1   5 5     0 0   6 1   10
1146457 MN Koochiching 36 school 2715000 361 Independent Districts and Schools INTERNATIONAL FALLS SCHOOL DISTRICT 271500000761 1 FALLS SECONDARY Secondary School (Grades 7-12) Regular School No 3 07 12 2015   grade_7 88.0 1.0 2.0   3.0 0.0     0.0   1.0   55.0 40.0     0.0   0.0     35.0   14.0   95.0 88 1 2   3 0     0   1   55 40     0 0   35 14   95
1159064 MN Hennepin 27 school 2725200 279 Independent Districts and Schools OSSEO PUBLIC SCHOOL DISTRICT 272520001208 33 BROOKLYN JUNIOR HIGH Junior High School (Grades 7-8 or 7-9) Regular School No 2 07 09 2015   grade_7 88.0 98.0 28.0   3.0 86.0     0.0   12.0   146.0 169.0     43.0   4.0     177.0   41.0   315.0 88 98 28   3 86     0   12   146 169     43 4   177 41   315
1159133 MN Saint Louis 69 school 2700021 2154 Independent Districts and Schools EVELETH-GILBERT SCHOOL DISTRICT 270002100628 30 EVELETH-GILBERT JUNIOR HIGH Junior High School (Grades 7-8 or 7-9) Regular School No 2 07 08 2015   grade_7 88.0 1.0 3.0   1.0 0.0     0.0   3.0   58.0 38.0     0.0   0.0     41.0   15.0   96.0 88 1 3   1 0     0   3   58 38     0 0   41 15   96
1159146 MN Wabasha 79 school 2700287 2899 Independent Districts and Schools PLAINVIEW-ELGIN-MILLVILLE 270028703714 30 PLAINVIEW-ELGIN-MILLVILLE JUNIOR Junior High School (Grades 7-8 or 7-9) Regular School No 2 07 08 2015   grade_7 87.0 0.0 11.0   0.0 0.0     0.0   2.0   48.0 52.0     0.0   0.0     33.0   12.0   100.0 87 0 11   0 0     0   2   48 52     0 0   33 12   100
1146500 MN Lake 38 school 2740740 381 Independent Districts and Schools LAKE SUPERIOR PUBLIC SCHOOL DIST. 274074001701 200 TWO HARBORS SECONDARY Secondary School (Grades 7-12) Regular School No 4 06 12 2015   grade_7 86.0 0.0 0.0   0.0 0.0     0.0   1.0   39.0 48.0         *     30.0   *   87.0 86 0 0   0 0     0   1   39 48           30     87
1146891 MN Stearns 73 school 2732850 743 Independent Districts and Schools SAUK CENTRE PUBLIC SCHOOL DISTRICT 273285001429 30 SAUK CENTRE SECONDARY Secondary School (Grades 7-12) Regular School No 3 07 12 2015   grade_7 86.0 1.0 6.0   0.0 0.0     0.0   0.0   39.0 54.0     2.0   0.0     32.0   12.0   93.0 86 1 6   0 0     0   0   39 54     2 0   32 12   93
1155080 MN Saint Louis 69 school 2711040 709 Independent Districts and Schools DULUTH PUBLIC SCHOOL DISTRICT 271104002788 225 LINCOLN PARK MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No 2 06 08 2015   grade_7 86.0 6.0 4.0   10.0 1.0     0.0   9.0   59.0 57.0     0.0   3.0     77.0   14.0   116.0 86 6 4   10 1     0   9   59 57     0 3   77 14   116
1155313 MN Hennepin 27 school 2721240 1 Special Districts and Schools MINNEAPOLIS PUBLIC SCHOOL DIST. 272124000965 119 FIELD ELEMENTARY Middle School (Grades 5-8) Regular School No 2 05 08 2015   grade_7 86.0 26.0 7.0   1.0 3.0     0.0   1.0   71.0 53.0     1.0   3.0     32.0   31.0   124.0 86 26 7   1 3     0   1   71 53     1 3   32 31   124
1147286 MN Saint Louis 69 school 2791450 2711 Independent Districts and Schools MESABI EAST SCHOOL DISTRICT 279145002326 40 MESABI EAST SECONDARY Secondary School (Grades 7-12) Regular School No 3 07 12 2015   grade_7 84.0 0.0 0.0   0.0 1.0     0.0   2.0   44.0 43.0     0.0   0.0     41.0   22.0   87.0 84 0 0   0 1     0   2   44 43     0 0   41 22   87
1155337 MN Hennepin 27 school 2721240 1 Special Districts and Schools MINNEAPOLIS PUBLIC SCHOOL DIST. 272124001028 324 SANFORD MIDDLE Middle School (Grades 5-8) Regular School No 2 06 08 2015   grade_7 84.0 82.0 41.0   16.0 12.0     0.0   2.0   112.0 125.0     54.0   21.0     154.0   39.0   237.0 84 82 41   16 12     0   2   112 125     54 21   154 39   237
1146204 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 3 07 12 2015   grade_7 83.0 0.0 2.0   1.0 3.0     0.0   2.0   41.0 50.0     1.0   1.0     9.0   11.0   91.0 83 0 2   1 3     0   2   41 50     1 1   9 11   91
1146823 MN Roseau 68 school 2732250 682 Independent Districts and Schools ROSEAU PUBLIC SCHOOL DISTRICT 273225001371 20 ROSEAU SECONDARY Secondary School (Grades 7-12) Regular School No 3 07 12 2015   grade_7 83.0 0.0 1.0   0.0 0.0     0.0   0.0   41.0 43.0     0.0   0.0     18.0   10.0   84.0 83 0 1   0 0     0   0   41 43     0 0   18 10   84
1151046 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 1 01 08 2015   grade_7 83.0 60.0 15.0   1.0 58.0     0.0   3.0   120.0 100.0     33.0   0.0     109.0   7.0   220.0 83 60 15   1 58     0   3   120 100     33 0   109 7   220
1154952 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 2 05 08 2015   grade_7 83.0 11.0 89.0   0.0 21.0     0.0   4.0   97.0 111.0     31.0   0.0         *   208.0 83 11 89   0 21     0   4   97 111     31 0         208
1155046 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384001969 342 MURRAY MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No 2 06 08 2015   grade_7 83.0 57.0 24.0   4.0 44.0     0.0   7.0   123.0 96.0     51.0   4.0     128.0   32.0   219.0 83 57 24   4 44     0   7   123 96     51 4   128 32   219
1154862 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 2 05 08 2015   grade_7 82.0 2.0 0.0   1.0 1.0     0.0   0.0   34.0 52.0     0.0   0.0     13.0   10.0   86.0 82 2 0   1 1     0   0   34 52     0 0   13 10   86
1154746 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 2 05 08 2015   grade_7 81.0 21.0 76.0   1.0 2.0     0.0   11.0   98.0 94.0     28.0   1.0     110.0   40.0   192.0 81 21 76   1 2     0   11   98 94     28 1   110 40   192
1155042 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384001591 330 HIGHLAND PARK MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No 2 06 08 2015   grade_7 81.0 55.0 87.0   4.0 18.0     0.0   2.0   123.0 124.0     91.0   3.0     138.0   31.0   247.0 81 55 87   4 18     0   2   123 124     91 3   138 31   247
1155255 MN Rock 67 school 2718330 2184 Independent Districts and Schools LUVERNE PUBLIC SCHOOL DISTRICT 271833002471 3 LUVERNE MIDDLE Middle School (Grades 5-8) Regular School No 2 06 08 2015   grade_7 81.0 0.0 5.0   0.0 0.0     0.0   1.0   43.0 44.0         *         *   87.0 81 0 5   0 0     0   1   43 44                 87
1155390 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 2 05 08 2015   grade_7 81.0 1.0 4.0   0.0 5.0     0.0   0.0   39.0 52.0     0.0   0.0     7.0   4.0   91.0 81 1 4   0 5     0   0   39 52     0 0   7 4   91
1154776 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 2 05 08 2015   grade_7 80.0 2.0 3.0   0.0 3.0     0.0   0.0   50.0 38.0     0.0   0.0     16.0   9.0   88.0 80 2 3   0 3     0   0   50 38     0 0   16 9   88
1154825 MN Hennepin 27 school 2731750 280 Independent Districts and Schools RICHFIELD PUBLIC SCHOOL DISTRICT 273175001317 37 RICHFIELD MIDDLE Middle School (Grades 5-8) Regular School No 2 06 08 2015   grade_7 80.0 61.0 116.0   3.0 14.0     0.0   15.0   147.0 142.0     103.0   0.0     198.0   57.0   289.0 80 61 116   3 14     0   15   147 142     103 0   198 57   289
1159130 MN Pope 61 school 2700019 2149 Independent Districts and Schools MINNEWASKA SCHOOL DISTRICT 270001904237 55 MINNEWASKA AREA JUNIOR HIGH Junior High School (Grades 7-8 or 7-9) Regular School No 2 07 08 2015   grade_7 80.0 2.0 4.0   1.0 1.0     0.0   0.0   47.0 41.0         *         *   88.0 80 2 4   1 1     0   0   47 41                 88
1146147 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 3 07 12 2015   grade_7 8.0 0.0 0.0   0.0 0.0     0.0   0.0   2.0 6.0         *         *   8.0 8 0 0   0 0     0   0   2 6                 8
1146351 MN Grant 26 school 2713890 264 Independent Districts and Schools HERMAN-NORCROSS SCHOOL DISTRICT 271389000714 2 HERMAN SECONDARY Secondary School (Grades 7-12) Regular School No 3 07 12 2015   grade_7 8.0 0.0 0.0   1.0 0.0     0.0   1.0   4.0 6.0     0.0   0.0     4.0   2.0   10.0 8 0 0   1 0     0   1   4 6     0 0   4 2   10
1146537 MN Mahnomen 44 school 2718660 432 Independent Districts and Schools MAHNOMEN PUBLIC SCHOOL DISTRICT 271866000866 20 MAHNOMEN SECONDARY Secondary School (Grades 7-12) Regular School No 3 07 12 2015   grade_7 8.0 0.0 1.0   22.0 0.0     0.0   19.0   31.0 19.0     0.0   0.0     44.0   15.0   50.0 8 0 1   22 0     0   19   31 19     0 0   44 15   50
1151023 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384004457 489 HAZEL PARK PREPARATORY ACADEMY Elementary School (Grades PK-6) Regular School No 1 PK 08 2015   grade_7 8.0 46.0 22.0   0.0 39.0     0.0   2.0   64.0 53.0     44.0   6.0         16.0   117.0 8 46 22   0 39     0   2   64 53     44 6     16   117
1157784 MN Rice 66 school 2700129 160 State Operated Schools (which include MN Academy Deaf & Blind, School for the Arts) MINNESOTA STATE ACADEMIES 270012902409 2 MN ACADEMY FOR THE DEAF Special Education Special Education School No 4 PK 12 2015   grade_7 8.0 0.0 1.0   0.0 0.0     0.0   0.0   7.0 2.0         *         *   9.0 8 0 1   0 0     0   0   7 2                 9
1158096 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 4 KG 12 2015   grade_7 8.0 0.0 0.0   0.0 0.0     0.0   0.0   8.0 0.0         *         *   8.0 8 0 0   0 0     0   0   8 0                 8
1158791 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 Education School No 4 01 12 2015   grade_7 8.0 1.0 1.0   0.0 0.0     0.0   0.0   7.0 3.0     0.0   1.0         8.0   10.0 8 1 1   0 0     0   0   7 3     0 1     8   10
1146324 MN Goodhue 25 school 2707500 252 Independent Districts and Schools CANNON FALLS PUBLIC SCHOOL DISTRICT 270750000324 2 Cannon Falls Secondary Secondary School (Grades 7-12) Regular School No 4 06 12 2015   grade_7 79.0 1.0 3.0   0.0 3.0     0.0   1.0   49.0 38.0     0.0   0.0     19.0   10.0   87.0 79 1 3   0 3     0   1   49 38     0 0   19 10   87
1155014 MN Ramsey 62 school 2723850 622 Independent Districts and Schools North St Paul-Maplewood Oakdale Public School District 272385001170 55 JOHN GLENN MIDDLE Middle School (Grades 5-8) Regular School No 2 06 08 2015   grade_7 79.0 53.0 41.0   2.0 74.0     0.0   22.0   136.0 135.0     50.0   *     186.0   49.0   271.0 79 53 41   2 74     0   22   136 135     50     186 49   271
1146267 MN Crow Wing 18 school 2709750 182 Independent Districts and Schools CROSBY-IRONTON PUBLIC SCHOOL DIST. 270975000417 1 CROSBY-IRONTON SECONDARY Secondary School (Grades 7-12) Regular School No 3 07 12 2015   grade_7 78.0 0.0 1.0   1.0 0.0     0.0   1.0   47.0 34.0     0.0   0.0     39.0   16.0   81.0 78 0 1   1 0     0   1   47 34     0 0   39 16   81
1154658 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 2 06 08 2015   grade_7 77.0 0.0 0.0   2.0 0.0     0.0   1.0   44.0 36.0     0.0   0.0     32.0   12.0   80.0 77 0 0   2 0     0   1   44 36     0 0   32 12   80
1155227 MN Blue Earth 7 school 2700006 2135 Independent Districts and Schools MAPLE RIVER SCHOOL DISTRICT 270000601070 30 MAPLE RIVER MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No 2 06 08 2015   grade_7 77.0 0.0 2.0   0.0 0.0     0.0   3.0   45.0 37.0     0.0   *     35.0   15.0   82.0 77 0 2   0 0     0   3   45 37     0     35 15   82
1146295 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 3 07 12 2015   grade_7 76.0 2.0 2.0   0.0 0.0     0.0   0.0   40.0 40.0     0.0   1.0     25.0   9.0   80.0 76 2 2   0 0     0   0   40 40     0 1   25 9   80
1155246 MN Morrison 49 school 2733900 2170 Independent Districts and Schools STAPLES-MOTLEY SCHOOL DISTRICT 273390002468 50 MOTLEY-STAPLES MIDDLE Middle School (Grades 5-8) Regular School No 2 06 08 2015   grade_7 76.0 0.0 3.0   1.0 0.0     0.0   4.0   44.0 40.0     0.0   0.0     48.0   18.0   84.0 76 0 3   1 0     0   4   44 40     0 0   48 18   84
1154872 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 2 05 08 2015   grade_7 75.0 1.0 1.0   3.0 0.0     0.0   8.0   53.0 35.0     0.0   0.0     49.0   12.0   88.0 75 1 1   3 0     0   8   53 35     0 0   49 12   88
1155292 MN Faribault 22 school 2700130 2860 Independent Districts and Schools BLUE EARTH AREA PUBLIC SCHOOL 270013002497 23 BLUE EARTH AREA MIDDLE Middle School (Grades 5-8) Regular School No 2 06 07 2015   grade_7 75.0 1.0 10.0   0.0 0.0     0.0   0.0   53.0 33.0     2.0   0.0     38.0   12.0   86.0 75 1 10   0 0     0   0   53 33     2 0   38 12   86
1155277 MN Wright 86 school 2700123 2687 Independent Districts and Schools HOWARD LAKE-WAVERLY-WINSTED 270012303350 86 HOWARD LAKE MIDDLE Middle School (Grades 5-8) Regular School No 2 05 08 2015   grade_7 74.0 0.0 2.0   1.0 1.0     0.0   0.0   40.0 38.0     0.0   0.0     21.0   12.0   78.0 74 0 2   1 1     0   0   40 38     0 0   21 12   78
1155285 MN Goodhue 25 school 2745735 2805 Independent Districts and Schools ZUMBROTA-MAZEPPA SCHOOL DISTRICT 274573500221 20 ZUMBROTA-MAZEPPA MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No 2 07 08 2015   grade_7 74.0 2.0 1.0   0.0 2.0     0.0   0.0   41.0 38.0     0.0   2.0     18.0   9.0   79.0 74 2 1   0 2     0   0   41 38     0 2   18 9   79
1146098 MN Aitkin 1 school 2702760 1 Independent Districts and Schools AITKIN PUBLIC SCHOOL DISTRICT 270276000057 1 AITKIN SECONDARY SCHOOL Secondary School (Grades 7-12) Regular School No 3 07 12 2015   grade_7 73.0 0.0 0.0   2.0 0.0     0.0   2.0   38.0 39.0     0.0   0.0     29.0   10.0   77.0 73 0 0   2 0     0   2   38 39     0 0   29 10   77
1146872 MN Stearns 73 school 2714190 738 Independent Districts and Schools HOLDINGFORD PUBLIC SCHOOL DISTRICT 271419000733 2 HOLDINGFORD SECONDARY Secondary School (Grades 7-12) Regular School No 3 07 12 2015   grade_7 73.0 0.0 1.0   1.0 0.0     0.0   1.0   38.0 38.0     0.0   0.0     25.0   7.0   76.0 73 0 1   1 0     0   1   38 38     0 0   25 7   76
1154961 MN Olmsted 55 school 2711010 533 Independent Districts and Schools DOVER-EYOTA PUBLIC SCHOOL DISTRICT 271101004345 25 DOVER-EYOTA MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No 2 06 08 2015   grade_7 73.0 0.0 2.0   1.0 0.0     0.0   0.0   42.0 34.0     0.0   0.0     21.0   5.0   76.0 73 0 2   1 0     0   0   42 34     0 0   21 5   76
1154867 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 2 05 08 2015   grade_7 72.0 0.0 0.0   2.0 0.0     0.0   3.0   37.0 40.0     0.0   0.0     27.0   8.0   77.0 72 0 0   2 0     0   3   37 40     0 0   27 8   77
1146246 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 3 07 12 2015   grade_7 71.0 0.0 1.0   1.0 0.0     0.0   1.0   42.0 32.0     3.0   0.0     10.0   12.0   74.0 71 0 1   1 0     0   1   42 32     3 0   10 12   74
1155133 MN Stearns 73 school 2728140 741 Independent Districts and Schools PAYNESVILLE PUBLIC SCHOOL DISTRICT 272814001241 2 PAYNESVILLE MIDDLE Middle School (Grades 5-8) Regular School No 2 06 08 2015   grade_7 71.0 3.0 6.0   0.0 0.0     0.0   1.0   39.0 42.0     0.0   1.0     30.0   13.0   81.0 71 3 6   0 0     0   1   39 42     0 1   30 13   81
1146572 MN Meeker 47 school 2711190 463 Independent Districts and Schools EDEN VALLEY-WATKINS SCHOOL DISTRICT 271119000502 20 EDEN VALLEY SECONDARY Secondary School (Grades 7-12) Regular School No 3 07 12 2015   grade_7 70.0 0.0 5.0   1.0 0.0     0.0   0.0   40.0 36.0         0.0     30.0   16.0   76.0 70 0 5   1 0     0   0   40 36       0   30 16   76
1154628 MN Carver 10 school 2723910 108 Independent Districts and Schools CENTRAL PUBLIC SCHOOL DISTRICT 272391002507 30 CENTRAL MIDDLE Middle School (Grades 5-8) Regular School No 2 06 08 2015   grade_7 70.0 1.0 3.0   1.0 0.0     0.0   0.0   38.0 37.0     1.0   0.0     19.0   11.0   75.0 70 1 3   1 0     0   0   38 37     1 0   19 11   75
1146450 MN Kittson 35 school 2717880 356 Independent Districts and Schools LANCASTER PUBLIC SCHOOL DISTRICT 271788000822 20 LANCASTER SECONDARY Secondary School (Grades 7-12) Regular School No 3 07 12 2015   grade_7 7.0 1.0 0.0   0.0 0.0     0.0   0.0   4.0 4.0         *         *   8.0 7 1 0   0 0     0   0   4 4                 8
1146544 MN Mahnomen 44 school 2742120 435 Independent Districts and Schools WAUBUN-OGEMA-WHITE EARTH PUBLIC SCH 274212001756 30 WAUBUN SECONDARY Secondary School (Grades 7-12) Regular School No 3 07 12 2015   grade_7 7.0 0.0 1.0   28.0 0.0     0.0   7.0   27.0 16.0     0.0   2.0     29.0   9.0   43.0 7 0 1   28 0     0   7   27 16     0 2   29 9   43
1146788 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384004429 252 WASHINGTON TECH SECONDARY MAGNET Secondary School (Grades 7-12) Regular School No 4 06 12 2015   grade_7 7.0 90.0 41.0   0.0 159.0     0.0   1.0   163.0 135.0     173.0   9.0         51.0   298.0 7 90 41   0 159     0   1   163 135     173 9     51   298
1147429 MN Nobles 53 school 2700388 2907 Independent Districts and Schools ROUND LAKE-BREWSTER PUBLIC SCHOOLS 270038804737 20 Round Lake-Brewster Secondary Secondary School (Grades 7-12) Regular School No 4 06 12 2015   grade_7 7.0 0.0 7.0   0.0 0.0     0.0   1.0   6.0 9.0     5.0   0.0     10.0   5.0   15.0 7 0 7   0 0     0   1   6 9     5 0   10 5   15
1147489 MN Winona 85 school 2700221 4064 Charter Schools RIVERWAY LEARNING COMMUNITY CHTR 270022103136 20 RIVERWAY SECONDARY Secondary School (Grades 7-12) Regular School Yes 3 07 12 2015   grade_7 7.0 1.0 1.0   0.0 0.0     0.0   0.0   5.0 4.0         *         *   9.0 7 1 1   0 0     0   0   5 4                 9
1153692 MN Ramsey 62 school 2700118 4018 Charter Schools ACHIEVE LANGUAGE ACADEMY 270011802608 10 ACHIEVE LANGUAGE ACADEMY Elementary School (Grades PK-6) Regular School Yes 1 PK 08 2015   grade_7 7.0 5.0 14.0   0.0 22.0     0.0   0.0   26.0 22.0     25.0   0.0     36.0   6.0   48.0 7 5 14   0 22     0   0   26 22     25 0   36 6   48
1154896 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 2 05 08 2015   grade_7 7.0 0.0 8.0   0.0 0.0     0.0   0.0   7.0 8.0     4.0   0.0     9.0   2.0   15.0 7 0 8   0 0     0   0   7 8     4 0   9 2   15
1156897 MN Polk 60 school 2709720 593 Independent Districts and Schools CROOKSTON PUBLIC SCHOOL DISTRICT 270972001029 20 NEW PATHS AREA LEARNING CENTER Public Area Learning Center ALC (State approved) Alternative Education School No 3 07 12 2015   grade_7 7.0 0.0 4.0   0.0 0.0     0.0   1.0   7.0 5.0     0.0   3.0     8.0   0.0   12.0 7 0 4   0 0     0   1   7 5     0 3   8 0   12
1158237 MN Nicollet 52 school 2700063 6027 Education Districts MN VALLEY EDUCATION DISTRICT 270006302389 10 Minnesota Valley School Special Education Special Education School No 4 KG 12 2015   grade_7 7.0 0.0 0.0   0.0 0.0     0.0   1.0   5.0 3.0         *         *   8.0 7 0 0   0 0     0   1   5 3                 8
1158540 MN Hennepin 27 school 2700117 4017 Charter Schools Minnesota Transitions Charter School 270011703264 14 VIRTUAL HIGH SCHOOL Distance Learning Program OLL (State approved) Regular School Yes 4 06 12 2015   grade_7 7.0 0.0 1.0   0.0 0.0     0.0   0.0   4.0 4.0         *         *   8.0 7 0 1   0 0     0   0   4 4                 8
1158577 MN Unknown   school 2700193 4082 Charter Schools BLUESKY CHARTER SCHOOL 270019303146 10 BLUESKY CHARTER SCHOOL Distance Learning Program OLL (State approved) Regular School Yes 3 07 12 2015   grade_7 7.0 0.0 0.0   0.0 1.0     0.0   0.0   5.0 3.0         *         *   8.0 7 0 0   0 1     0   0   5 3                 8
1158736 MN Mille Lacs 48 school 2725050 480 Independent Districts and Schools ONAMIA PUBLIC SCHOOL DISTRICT 272505000957 30 MILLE LACS ACADEMY (NEXUS) Educational Oversight to Public Residential Care & Treatment (State approved) Alternative Education School No 4 05 12 2015   grade_7 7.0 3.0 1.0   1.0 0.0     0.0   0.0   12.0 0.0     0.0   0.0         9.0   12.0 7 3 1   1 0     0   0   12 0     0 0     9   12
1159249 MN Pope 61 school 2700019 2149 Independent Districts and Schools MINNEWASKA SCHOOL DISTRICT 270001903600 101 MINNEWASKA DAY TREATMENT PROGRAM Educational Oversight to Public Care and Treatment Day Program Alternative Education School No 4 KG 12 2015   grade_7 7.0 0.0 0.0   0.0 0.0     0.0   0.0   6.0 1.0         *         *   7.0 7 0 0   0 0     0   0   6 1                 7
1146232 MN Chisago 13 school 2732550 139 Independent Districts and Schools RUSH CITY PUBLIC SCHOOL DISTRICT 273255001406 20 RUSH CITY SECONDARY Secondary School (Grades 7-12) Regular School No 3 07 12 2015   grade_7 69.0 0.0 1.0   0.0 0.0     0.0   0.0   36.0 34.0     0.0   0.0     19.0   10.0   70.0 69 0 1   0 0     0   0   36 34     0 0   19 10   70
1146733 MN Polk 60 school 2709720 593 Independent Districts and Schools CROOKSTON PUBLIC SCHOOL DISTRICT 270972000412 90 CROOKSTON SECONDARY Secondary School (Grades 7-12) Regular School No 3 07 12 2015   grade_7 69.0 2.0 12.0   1.0 1.0     0.0   2.0   40.0 47.0     0.0   4.0     35.0   20.0   87.0 69 2 12   1 1     0   2   40 47     0 4   35 20   87
1147047 MN Wright 86 school 2718810 881 Independent Districts and Schools MAPLE LAKE PUBLIC SCHOOL DISTRICT 271881000886 20 MAPLE LAKE SECONDARY Secondary School (Grades 7-12) Regular School No 3 07 12 2015   grade_7 68.0 2.0 1.0   0.0 0.0     0.0   0.0   35.0 36.0     0.0   0.0     14.0   9.0   71.0 68 2 1   0 0     0   0   35 36     0 0   14 9   71
1147129 MN Wadena 80 school 2700022 2155 Independent Districts and Schools WADENA-DEER CREEK SCHOOL DISTRICT 270002201733 1 WADENA-DEER CREEK SENIOR HIGH Secondary School (Grades 7-12) Regular School No 3 07 12 2015   grade_7 68.0 0.0 3.0   2.0 0.0     0.0   1.0   41.0 33.0     0.0   0.0     34.0   10.0   74.0 68 0 3   2 0     0   1   41 33     0 0   34 10   74
1147322 MN Stevens 75 school 2700383 2769 Independent Districts and Schools MORRIS AREA PUBLIC SCHOOLS 270038304728 10 Morris Area Secondary Secondary School (Grades 7-12) Regular School No 3 07 12 2015   grade_7 68.0 1.0 6.0   1.0 0.0     0.0   3.0   45.0 34.0     4.0   0.0     25.0   11.0   79.0 68 1 6   1 0     0   3   45 34     4 0   25 11   79
1154921 MN Morrison 49 school 2732520 485 Independent Districts and Schools ROYALTON PUBLIC SCHOOL DISTRICT 273252004640 50 ROYALTON MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No 2 06 08 2015   grade_7 67.0 1.0 2.0   0.0 1.0     0.0   0.0   28.0 43.0     1.0   1.0     18.0   8.0   71.0 67 1 2   0 1     0   0   28 43     1 1   18 8   71
1159136 MN Sibley 72 school 2700102 2310 Independent Districts and Schools SIBLEY EAST SCHOOL DISTRICT 270010200625 20 SIBLEY EAST-GAYLORD JUNIOR HIGH Junior High School (Grades 7-8 or 7-9) Regular School No 2 07 09 2015   grade_7 67.0 1.0 29.0   0.0 1.0     0.0   0.0   53.0 45.0     21.0   0.0     51.0   12.0   98.0 67 1 29   0 1     0   0   53 45     21 0   51 12   98
1146400 MN Isanti 30 school 2706060 314 Independent Districts and Schools BRAHAM PUBLIC SCHOOL DISTRICT 270606000247 1 BRAHAM AREA SECONDARY Secondary School (Grades 7-12) Regular School No 3 07 12 2015   grade_7 66.0 0.0 1.0   0.0 0.0     0.0   4.0   34.0 37.0     0.0   1.0     35.0   10.0   71.0 66 0 1   0 0     0   4   34 37     0 1   35 10   71
1146830 MN Roseau 68 school 2741850 690 Independent Districts and Schools WARROAD PUBLIC SCHOOL DISTRICT 274185001745 30 WARROAD HIGH SCHOOL Secondary School (Grades 7-12) Regular School No 3 07 12 2015   grade_7 66.0 0.0 0.0   5.0 9.0     0.0   2.0   45.0 37.0         0.0     29.0   11.0   82.0 66 0 0   5 9     0   2   45 37       0   29 11   82
1147075 MN Blue Earth 7 school 2791445 2071 Independent Districts and Schools LAKE CRYSTAL-WELLCOME MEMORIAL 279144502312 30 LK CRYSTAL-WELLCOME MEMORIAL SEC. Secondary School (Grades 7-12) Regular School No 3 07 12 2015   grade_7 65.0 2.0 2.0   0.0 0.0     0.0   0.0   33.0 36.0     1.0   0.0     18.0   7.0   69.0 65 2 2   0 0     0   0   33 36     1 0   18 7   69
1154664 MN Chippewa 12 school 2721320 129 Independent Districts and Schools MONTEVIDEO PUBLIC SCHOOL DISTRICT 272132001071 30 MONTEVIDEO MIDDLE Middle School (Grades 5-8) Regular School No 2 04 07 2015   grade_7 64.0 3.0 16.0   1.0 1.0     0.0   2.0   53.0 34.0     12.0   0.0     40.0   17.0   87.0 64 3 16   1 1     0   2   53 34     12 0   40 17   87

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