Data source: Big Local News · About: Big Local

6,616 rows where grade = "grade_5" and state = "MN" sorted by rowid descending

View and edit SQL

year

grade

  • grade_5 · 6,516
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
1954201 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_5 1.0 41.0 0.0   0.0 2.0     0.0   2.0   24.0 22.0     28.0   1.0         4.0   46.0 1 41 0   0 2     0   2   24 22     28 1     4   46
1954196 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_5 48.0 0.0 1.0   0.0 0.0     0.0   2.0   28.0 23.0     0.0   0.0     22.0   17.0   51.0 48 0 1   0 0     0   2   28 23     0 0   22 17   51
1954188 MN Unknown   school 2700335 4205 Charter Schools HENNEPIN ELEMENTARY SCHOOL 270033505203 20 Hennepin Middle School Middle School (Grades 5-8) Regular School Yes Middle 05 08 2019   grade_5 0.0 38.0 6.0   0.0 0.0     0.0   0.0   26.0 18.0     18.0   0.0         9.0   44.0 0 38 6   0 0     0   0   26 18     18 0     9   44
1954183 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_5 57.0 36.0 6.0   1.0 15.0     0.0   5.0   60.0 60.0     3.0   0.0     27.0   14.0   120.0 57 36 6   1 15     0   5   60 60     3 0   27 14   120
1954181 MN Hennepin 27 school 2700288 4170 Charter Schools HIAWATHA ACADEMIES 270028805141 15 Hiawatha College Prep - Northrop Middle School (Grades 5-8) Regular School Yes Middle 05 05 2019   grade_5 0.0 10.0 75.0   1.0 1.0     0.0   2.0   47.0 42.0     40.0   1.0         13.0   89.0 0 10 75   1 1     0   2   47 42     40 1     13   89
1954176 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_5 0.0 7.0 65.0   0.0 0.0     0.0   0.0   42.0 30.0     37.0   0.0         9.0   72.0 0 7 65   0 0     0   0   42 30     37 0     9   72
1954171 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_5 10.0 2.0 1.0   0.0 1.0     0.0   1.0   0.0 15.0     0.0   1.0     4.0   2.0   15.0 10 2 1   0 1     0   1   0 15     0 1   4 2   15
1954157 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_5 0.0 13.0 0.0   0.0 0.0     0.0   0.0   6.0 7.0     8.0   0.0     10.0   0.0   13.0 0 13 0   0 0     0   0   6 7     8 0   10 0   13
1954148 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_5 72.0 5.0 7.0   0.0 6.0     1.0   1.0   42.0 50.0     1.0   0.0     7.0   15.0   92.0 72 5 7   0 6     1   1   42 50     1 0   7 15   92
1954131 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_5 0.0 115.0 0.0   0.0 0.0     0.0   0.0   47.0 68.0     47.0   0.0         5.0   115.0 0 115 0   0 0     0   0   47 68     47 0     5   115
1954124 MN Ramsey 62 school 2700186 4074 Charter Schools AFSA HIGH SCHOOL 270018604854 20 AFSA Middle School Middle School (Grades 5-8) Regular School Yes Middle 05 06 2019   grade_5 10.0 0.0 1.0   0.0 0.0     0.0   0.0   5.0 6.0     0.0   0.0     1.0   1.0   11.0 10 0 1   0 0     0   0   5 6     0 0   1 1   11
1954119 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_5 0.0 0.0 48.0   0.0 0.0     0.0   0.0   26.0 22.0     32.0   0.0     42.0   6.0   48.0 0 0 48   0 0     0   0   26 22     32 0   42 6   48
1954114 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_5 27.0 0.0 1.0   0.0 1.0     0.0   0.0   13.0 16.0     0.0   0.0     5.0   9.0   29.0 27 0 1   0 1     0   0   13 16     0 0   5 9   29
1954074 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_5 107.0 9.0 10.0   1.0 3.0     1.0   6.0   59.0 78.0     4.0   0.0     21.0   17.0   137.0 107 9 10   1 3     1   6   59 78     4 0   21 17   137
1954057 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_5 47.0 2.0 4.0   28.0 1.0     0.0   5.0   48.0 39.0     1.0   0.0     40.0   12.0   87.0 47 2 4   28 1     0   5   48 39     1 0   40 12   87
1954047 MN Lac qui Parle 37 school 2700125 2853 Independent Districts and Schools LAC QUI PARLE VALLEY SCHOOL DIST. 270012503893 35 LAC QUI PARLE VALLEY MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 05 06 2019   grade_5 46.0 1.0 5.0   0.0 0.0     5.0   4.0   28.0 33.0     5.0   0.0     28.0   16.0   61.0 46 1 5   0 0     5   4   28 33     5 0   28 16   61
1954039 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_5 53.0 1.0 18.0   0.0 0.0     0.0   7.0   37.0 42.0     5.0   0.0     41.0   9.0   79.0 53 1 18   0 0     0   7   37 42     5 0   41 9   79
1954034 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_5 83.0 1.0 10.0   1.0 0.0     0.0   4.0   53.0 46.0     4.0   0.0     35.0   9.0   99.0 83 1 10   1 0     0   4   53 46     4 0   35 9   99
1954021 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_5 45.0 0.0 12.0   0.0 1.0     0.0   0.0   28.0 30.0     4.0   0.0     33.0   10.0   58.0 45 0 12   0 1     0   0   28 30     4 0   33 10   58
1954016 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_5 64.0 1.0 3.0   0.0 0.0     0.0   1.0   31.0 38.0     1.0   0.0     30.0   5.0   69.0 64 1 3   0 0     0   1   31 38     1 0   30 5   69
1954003 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_5 56.0 1.0 4.0   0.0 0.0     0.0   2.0   31.0 32.0     4.0   0.0     21.0   7.0   63.0 56 1 4   0 0     0   2   31 32     4 0   21 7   63
1953999 MN Morrison 49 school 2733900 2170 Independent Districts and Schools STAPLES-MOTLEY SCHOOL DISTRICT 273390002468 50 MOTLEY-STAPLES MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 04 07 2019   grade_5 68.0 0.0 3.0   1.0 0.0     0.0   5.0   34.0 43.0     0.0   4.0     48.0   14.0   77.0 68 0 3   1 0     0   5   34 43     0 4   48 14   77
1953991 MN Pope 61 school 2700019 2149 Independent Districts and Schools MINNEWASKA SCHOOL DISTRICT 270001903535 60 Minnewaska Area Intermediate School Middle School (Grades 5-8) Regular School No Middle 04 06 2019   grade_5 100.0 2.0 1.0   0.0 0.0     0.0   3.0   60.0 46.0     *   *         *   106.0 100 2 1   0 0     0   3   60 46                 106
1953965 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_5 244.0 9.0 10.0   0.0 4.0     0.0   8.0   140.0 135.0     7.0   0.0     31.0   24.0   275.0 244 9 10   0 4     0   8   140 135     7 0   31 24   275
1953960 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_5 185.0 8.0 6.0   1.0 6.0     0.0   13.0   118.0 101.0     1.0   3.0     33.0   23.0   219.0 185 8 6   1 6     0   13   118 101     1 3   33 23   219
1953955 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_5 106.0 5.0 9.0   1.0 2.0     0.0   9.0   67.0 65.0     4.0   0.0     39.0   14.0   132.0 106 5 9   1 2     0   9   67 65     4 0   39 14   132
1953948 MN Wright 86 school 2710170 879 Independent Districts and Schools DELANO PUBLIC SCHOOL DISTRICT 271017000437 15 Delano Intermediate School Middle School (Grades 5-8) Regular School No Middle 04 06 2019   grade_5 195.0 1.0 6.0   0.0 1.0     0.0   12.0   113.0 102.0     1.0   1.0     22.0   29.0   215.0 195 1 6   0 1     0   12   113 102     1 1   22 29   215
1953934 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_5 176.0 12.0 10.0   2.0 3.0     0.0   12.0   114.0 101.0     7.0   0.0     88.0   45.0   215.0 176 12 10   2 3     0   12   114 101     7 0   88 45   215
1953898 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_5 85.0 0.0 3.0   0.0 1.0     0.0   3.0   42.0 50.0     0.0   1.0     49.0   17.0   92.0 85 0 3   0 1     0   3   42 50     0 1   49 17   92
1953893 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_5 8.0 0.0 0.0   9.0 0.0     0.0   0.0   8.0 9.0     0.0   0.0     15.0   6.0   17.0 8 0 0   9 0     0   0   8 9     0 0   15 6   17
1953880 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_5 281.0 3.0 5.0   2.0 6.0     0.0   9.0   147.0 159.0     2.0   1.0     45.0   49.0   306.0 281 3 5   2 6     0   9   147 159     2 1   45 49   306
1953819 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_5 130.0 3.0 14.0   3.0 3.0     1.0   8.0   89.0 73.0     10.0   1.0     36.0   20.0   162.0 130 3 14   3 3     1   8   89 73     10 1   36 20   162
1953802 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_5 139.0 2.0 4.0   0.0 0.0     0.0   3.0   85.0 63.0     2.0   1.0     18.0   22.0   148.0 139 2 4   0 0     0   3   85 63     2 1   18 22   148
1953769 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_5 4.0 15.0 13.0   1.0 71.0     0.0   3.0   55.0 52.0     47.0   3.0     82.0   8.0   107.0 4 15 13   1 71     0   3   55 52     47 3   82 8   107
1953717 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_5 90.0 2.0 14.0   1.0 0.0     0.0   10.0   62.0 55.0     11.0   0.0     48.0   17.0   117.0 90 2 14   1 0     0   10   62 55     11 0   48 17   117
1953712 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_5 177.0 4.0 5.0   1.0 0.0     1.0   6.0   89.0 105.0     5.0   *     76.0   *   194.0 177 4 5   1 0     1   6   89 105     5     76     194
1953678 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_5 55.0 15.0 141.0   1.0 35.0     0.0   7.0   126.0 128.0     76.0   *     196.0   *   254.0 55 15 141   1 35     0   7   126 128     76     196     254
1953669 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_5 122.0 15.0 23.0   1.0 1.0     0.0   2.0   78.0 86.0     11.0   2.0     57.0   24.0   164.0 122 15 23   1 1     0   2   78 86     11 2   57 24   164
1953664 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_5 21.0 0.0 4.0   0.0 0.0     0.0   0.0   13.0 12.0     0.0   0.0         6.0   25.0 21 0 4   0 0     0   0   13 12     0 0     6   25
1953655 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_5 36.0 0.0 1.0   1.0 0.0     0.0   3.0   15.0 26.0     0.0   0.0     16.0   7.0   41.0 36 0 1   1 0     0   3   15 26     0 0   16 7   41
1953638 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_5 19.0 0.0 1.0   24.0 0.0     0.0   4.0   24.0 24.0     *   *         *   48.0 19 0 1   24 0     0   4   24 24                 48
1953627 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_5 149.0 1.0 12.0   0.0 2.0     0.0   2.0   98.0 68.0     2.0   0.0     37.0   29.0   166.0 149 1 12   0 2     0   2   98 68     2 0   37 29   166
1953622 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_5 97.0 0.0 7.0   1.0 1.0     0.0   5.0   61.0 50.0     1.0   0.0     33.0   15.0   111.0 97 0 7   1 1     0   5   61 50     1 0   33 15   111
1953613 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_5 7.0 0.0 5.0   0.0 0.0     0.0   0.0   6.0 6.0     *   *     9.0   5.0   12.0 7 0 5   0 0     0   0   6 6           9 5   12
1953608 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_5 109.0 19.0 28.0   2.0 15.0     0.0   10.0   94.0 89.0     22.0   2.0     91.0   26.0   183.0 109 19 28   2 15     0   10   94 89     22 2   91 26   183
1953599 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_5 124.0 0.0 12.0   0.0 0.0     0.0   1.0   62.0 75.0     3.0   0.0     48.0   21.0   137.0 124 0 12   0 0     0   1   62 75     3 0   48 21   137
1953594 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_5 235.0 2.0 5.0   2.0 1.0     0.0   32.0   153.0 124.0     0.0   0.0     121.0   65.0   277.0 235 2 5   2 1     0   32   153 124     0 0   121 65   277
1953589 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_5 78.0 1.0 3.0   10.0 0.0     0.0   2.0   49.0 45.0     0.0   2.0     48.0   28.0   94.0 78 1 3   10 0     0   2   49 45     0 2   48 28   94
1953584 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_5 84.0 1.0 6.0   2.0 0.0     0.0   7.0   51.0 49.0     1.0   0.0     50.0   25.0   100.0 84 1 6   2 0     0   7   51 49     1 0   50 25   100
1953579 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_5 70.0 4.0 3.0   1.0 0.0     0.0   6.0   46.0 38.0     1.0   0.0     18.0   17.0   84.0 70 4 3   1 0     0   6   46 38     1 0   18 17   84
1953511 MN Hennepin 27 school 2722920 277 Independent Districts and Schools WESTONKA PUBLIC SCHOOL DISTRICT 272292001109 63 GRANDVIEW MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 05 07 2019   grade_5 162.0 8.0 11.0   0.0 0.0     0.0   13.0   94.0 100.0     1.0   0.0     38.0   44.0   194.0 162 8 11   0 0     0   13   94 100     1 0   38 44   194
1953476 MN Goodhue 25 school 2730480 256 Independent Districts and Schools RED WING PUBLIC SCHOOL DISTRICT 273048001298 109 TWIN BLUFF MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 05 07 2019   grade_5 152.0 6.0 28.0   6.0 0.0     0.0   14.0   98.0 108.0     4.0   0.0     82.0   27.0   206.0 152 6 28   6 0     0   14   98 108     4 0   82 27   206
1953471 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_5 112.0 1.0 3.0   0.0 1.0     0.0   1.0   62.0 56.0     0.0   0.0     22.0   14.0   118.0 112 1 3   0 1     0   1   62 56     0 0   22 14   118
1953455 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_5 154.0 1.0 11.0   0.0 1.0     0.0   7.0   83.0 91.0     4.0   0.0     37.0   22.0   174.0 154 1 11   0 1     0   7   83 91     4 0   37 22   174
1953450 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_5 287.0 13.0 23.0   2.0 5.0     0.0   12.0   174.0 168.0     8.0   4.0     84.0   49.0   342.0 287 13 23   2 5     0   12   174 168     8 4   84 49   342
1953441 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_5 97.0 15.0 80.0   0.0 6.0     0.0   18.0   99.0 117.0     28.0   4.0     115.0   36.0   216.0 97 15 80   0 6     0   18   99 117     28 4   115 36   216
1953436 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_5 98.0 30.0 41.0   2.0 9.0     0.0   14.0   106.0 88.0     20.0   2.0     86.0   22.0   194.0 98 30 41   2 9     0   14   106 88     20 2   86 22   194
1953375 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_5 117.0 3.0 1.0   1.0 0.0     0.0   0.0   69.0 53.0     0.0   0.0     34.0   16.0   122.0 117 3 1   1 0     0   0   69 53     0 0   34 16   122
1953370 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_5 451.0 4.0 9.0   10.0 2.0     0.0   28.0   261.0 243.0     *   *         *   504.0 451 4 9   10 2     0   28   261 243                 504
1953365 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_5 63.0 3.0 15.0   0.0 5.0     0.0   2.0   48.0 40.0     6.0   0.0     37.0   19.0   88.0 63 3 15   0 5     0   2   48 40     6 0   37 19   88
1953355 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_5 388.0 43.0 51.0   19.0 6.0     0.0   36.0   293.0 250.0     44.0   10.0     229.0   97.0   543.0 388 43 51   19 6     0   36   293 250     44 10   229 97   543
1953350 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_5 180.0 0.0 14.0   2.0 7.0     0.0   7.0   98.0 112.0     4.0   1.0     72.0   30.0   210.0 180 0 14   2 7     0   7   98 112     4 1   72 30   210
1953346 MN Chippewa 12 school 2721320 129 Independent Districts and Schools MONTEVIDEO PUBLIC SCHOOL DISTRICT 272132001071 30 MONTEVIDEO MIDDLE Middle School (Grades 5-8) Regular School No Middle 04 07 2019   grade_5 77.0 2.0 16.0   0.0 0.0     1.0   6.0   48.0 54.0     5.0   0.0     46.0   21.0   102.0 77 2 16   0 0     1   6   48 54     5 0   46 21   102
1953340 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_5 91.0 0.0 2.0   0.0 0.0     0.0   3.0   49.0 47.0     0.0   0.0     42.0   17.0   96.0 91 0 2   0 0     0   3   49 47     0 0   42 17   96
1953335 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_5 6.0 0.0 1.0   78.0 0.0     0.0   14.0   50.0 49.0     0.0   0.0         21.0   99.0 6 0 1   78 0     0   14   50 49     0 0     21   99
1953318 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_5 106.0 1.0 3.0   1.0 1.0     0.0   1.0   65.0 48.0     2.0   0.0     28.0   22.0   113.0 106 1 3   1 1     0   1   65 48     2 0   28 22   113
1953305 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_5 145.0 0.0 3.0   26.0 0.0     0.0   22.0   89.0 107.0     0.0   1.0     96.0   41.0   196.0 145 0 3   26 0     0   22   89 107     0 1   96 41   196
1953300 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_5 152.0 1.0 10.0   0.0 1.0     0.0   7.0   86.0 85.0     3.0   0.0     51.0   25.0   171.0 152 1 10   0 1     0   7   86 85     3 0   51 25   171
1953275 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_5 79.0 1.0 1.0   14.0 0.0     0.0   17.0   62.0 50.0     0.0   1.0     59.0   31.0   112.0 79 1 1   14 0     0   17   62 50     0 1   59 31   112
1953270 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_5 285.0 52.0 73.0   2.0 32.0     0.0   36.0   232.0 248.0     54.0   1.0     156.0   58.0   480.0 285 52 73   2 32     0   36   232 248     54 1   156 58   480
1953261 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_5 72.0 80.0 36.0   3.0 12.0     0.0   24.0   109.0 118.0     48.0   0.0     158.0   33.0   227.0 72 80 36   3 12     0   24   109 118     48 0   158 33   227
1953224 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_5 19.0 0.0 0.0   0.0 0.0     0.0   2.0   9.0 12.0     0.0   0.0     17.0   6.0   21.0 19 0 0   0 0     0   2   9 12     0 0   17 6   21
1953092 MN Unknown   school 2700445 4264 Charter Schools Gateway STEM Academy 270044505138 10 Gateway STEM Academy Charter School Elementary School (Grades PK-6) Regular School Yes Elementary KG 05 2019   grade_5 0.0 13.0 0.0   0.0 0.0     0.0   1.0   7.0 7.0     3.0   0.0         1.0   14.0 0 13 0   0 0     0   1   7 7     3 0     1   14
1953084 MN Unknown   school 2700439 4261 Charter Schools SciTech Academy Charter School 270043905072 10 SciTech Academy Charter School Elementary School (Grades PK-6) Regular School Yes Elementary KG 06 2019   grade_5 0.0 10.0 0.0   0.0 0.0     0.0   0.0   5.0 5.0     8.0   0.0         2.0   10.0 0 10 0   0 0     0   0   5 5     8 0     2   10
1953076 MN Hennepin 27 school 2700433 4255 Charter Schools Skyline Math and Science Academy 270043305067 10 Skyline Math and Science Academy Elementary School (Grades PK-6) Regular School Yes Elementary KG 06 2019   grade_5 0.0 28.0 0.0   0.0 0.0     0.0   0.0   16.0 12.0     15.0   0.0         2.0   28.0 0 28 0   0 0     0   0   16 12     15 0     2   28
1953068 MN Washington 82 school 2700437 4254 Charter Schools Marine Area Community School 270043705088 10 Marine Area Community School Elementary School (Grades PK-6) Regular School Yes Elementary KG 06 2019   grade_5 16.0 0.0 0.0   1.0 0.0     0.0   0.0   11.0 6.0     0.0   0.0     0.0   3.0   17.0 16 0 0   1 0     0   0   11 6     0 0   0 3   17
1953061 MN Chisago 13 school 2700429 4253 Charter Schools Phoenix Academy Charter School 270042904969 10 Phoenix Academy Charter School Elementary School (Grades PK-6) Regular School Yes Elementary KG 05 2019   grade_5 18.0 0.0 0.0   0.0 0.0     0.0   0.0   9.0 9.0     0.0   0.0     7.0   4.0   18.0 18 0 0   0 0     0   0   9 9     0 0   7 4   18
1953051 MN Stearns 73 school 2700430 4250 Charter Schools Athlos Academy of Saint Cloud 270043004959 10 Athlos Academy of Saint Cloud Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2019   grade_5 24.0 21.0 3.0   0.0 0.0     0.0   2.0   21.0 29.0     7.0   0.0     32.0   6.0   50.0 24 21 3   0 0     0   2   21 29     7 0   32 6   50
1953041 MN Dakota 19 school 2700425 4244 Charter Schools FIT Academy 270042504902 10 FIT Academy Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2019   grade_5 16.0 3.0 8.0   0.0 0.0     0.0   0.0   16.0 11.0     4.0   0.0     6.0   6.0   27.0 16 3 8   0 0     0   0   16 11     4 0   6 6   27
1953033 MN Ramsey 62 school 2700423 4243 Charter Schools North Metro Flex Academy 270042304942 10 North Metro Flex Academy Elementary School (Grades PK-6) Regular School Yes Elementary KG 06 2019   grade_5 5.0 11.0 10.0   0.0 0.0     0.0   4.0   6.0 24.0     6.0   0.0     25.0   7.0   30.0 5 11 10   0 0     0   4   6 24     6 0   25 7   30
1953024 MN Ramsey 62 school 2700410 4240 Charter Schools New Century School 270041004873 10 New Century School Elementary School (Grades PK-6) Regular School Yes Elementary KG 07 2019   grade_5 0.0 30.0 0.0   0.0 0.0     0.0   0.0   15.0 15.0     25.0   0.0         2.0   30.0 0 30 0   0 0     0   0   15 15     25 0     2   30
1953016 MN Ramsey 62 school 2700415 4239 Charter Schools Tesfa International School 270041504876 10 Tesfa International School Elementary School (Grades PK-6) Regular School Yes Elementary KG 06 2019   grade_5 2.0 19.0 0.0   0.0 0.0     0.0   0.0   13.0 8.0     *   0.0     18.0   3.0   21.0 2 19 0   0 0     0   0   13 8       0   18 3   21
1953009 MN Ramsey 62 school 2700408 4233 Charter Schools Level Up Academy 270040804800 10 Level Up Academy Elementary School (Grades PK-6) Regular School Yes Elementary KG 05 2019   grade_5 12.0 2.0 2.0   0.0 0.0     0.0   0.0   10.0 6.0     1.0   0.0     7.0   5.0   16.0 12 2 2   0 0     0   0   10 6     1 0   7 5   16
1953001 MN Hennepin 27 school 2700404 4232 Charter Schools Success Academy 270040404790 10 Success Academy Elementary School (Grades PK-6) Regular School Yes Elementary KG 06 2019   grade_5 0.0 4.0 0.0   0.0 0.0     0.0   0.0   2.0 2.0     *   *         *   4.0 0 4 0   0 0     0   0   2 2                 4
1952987 MN Hennepin 27 school 2700406 4230 Charter Schools Minnesota Excellence in Learning Academy 270040604843 10 Minnesota Excellence in Learning Academy Elementary School (Grades PK-6) Regular School Yes Elementary PK 06 2019   grade_5 0.0 16.0 4.0   0.0 0.0     0.0   0.0   10.0 10.0     2.0   1.0         *   20.0 0 16 4   0 0     0   0   10 10     2 1         20
1952976 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_5 19.0 6.0 0.0   1.0 8.0     0.0   3.0   23.0 14.0     2.0   0.0     4.0   7.0   37.0 19 6 0   1 8     0   3   23 14     2 0   4 7   37
1952961 MN Hennepin 27 school 2700396 4226 Charter Schools Bdote Learning Center 270039604763 10 Bdote Learning Center Elementary School (Grades PK-6) Regular School Yes Elementary KG 07 2019   grade_5 0.0 1.0 0.0   3.0 0.0     0.0   1.0   1.0 4.0     *   *         *   5.0 0 1 0   3 0     0   1   1 4                 5
1952951 MN Ramsey 62 school 2700393 4225 Charter Schools Universal Academy Charter School 270039304758 10 Universal Academy Charter School Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2019   grade_5 0.0 40.0 0.0   0.0 0.0     0.0   0.0   20.0 20.0     *   0.0     34.0   5.0   40.0 0 40 0   0 0     0   0   20 20       0   34 5   40
1952941 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_5 6.0 9.0 0.0   0.0 0.0     0.0   0.0   6.0 9.0     6.0   0.0     4.0   0.0   15.0 6 9 0   0 0     0   0   6 9     6 0   4 0   15
1952934 MN Stearns 73 school 2700395 4223 Charter Schools Saint Cloud Math and Science Academy Charter School 270039504752 10 Saint Cloud Math and Science Academy Charter School Elementary School (Grades PK-6) Regular School Yes Elementary KG 05 2019   grade_5 1.0 21.0 0.0   0.0 0.0     0.0   0.0   11.0 11.0     19.0   0.0     19.0   4.0   22.0 1 21 0   0 0     0   0   11 11     19 0   19 4   22
1952925 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_5 18.0 4.0 9.0   3.0 2.0     0.0   8.0   26.0 18.0     5.0   0.0     22.0   3.0   44.0 18 4 9   3 2     0   8   26 18     5 0   22 3   44
1952916 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_5 17.0 6.0 1.0   0.0 1.0     0.0   1.0   16.0 10.0     1.0   0.0     7.0   5.0   26.0 17 6 1   0 1     0   1   16 10     1 0   7 5   26
1952907 MN Hennepin 27 school 2700398 4219 Charter Schools Northeast College Prep 270039804757 10 Northeast College Prep Charter School Elementary School (Grades PK-6) Regular School Yes Elementary KG 07 2019   grade_5 4.0 32.0 5.0   0.0 0.0     0.0   0.0   19.0 22.0     17.0   0.0         9.0   41.0 4 32 5   0 0     0   0   19 22     17 0     9   41
1952897 MN Ramsey 62 school 2700386 4215 Charter Schools Sejong Academy of Minnesota 270038604695 10 Sejong Academy of Minnesota Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2019   grade_5 1.0 0.0 0.0   0.0 9.0     0.0   1.0   7.0 4.0     6.0   0.0         2.0   11.0 1 0 0   0 9     0   1   7 4     6 0     2   11
1952886 MN Hennepin 27 school 2700380 4213 Charter Schools Prodeo Academy 270038004642 10 Prodeo Academy Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2019   grade_5 4.0 51.0 12.0   0.0 0.0     0.0   6.0   34.0 39.0     8.0   7.0     54.0   9.0   73.0 4 51 12   0 0     0   6   34 39     8 7   54 9   73
1952875 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_5 1.0 11.0 15.0   1.0 0.0     0.0   5.0   19.0 14.0     5.0   4.0     29.0   10.0   33.0 1 11 15   1 0     0   5   19 14     5 4   29 10   33
1952867 MN Hennepin 27 school 2700373 4209 Charter Schools MASTERY SCHOOL 270037304602 10 MASTERY SCHOOL Elementary School (Grades PK-6) Regular School Yes Elementary KG 06 2019   grade_5 0.0 28.0 1.0   0.0 0.0     0.0   1.0   14.0 16.0     0.0   1.0     25.0   4.0   30.0 0 28 1   0 0     0   1   14 16     0 1   25 4   30
1952857 MN Hennepin 27 school 2700378 4208 Charter Schools NASHA SHKOLA CHARTER SCHOOL 270037804635 10 NASHA SHKOLA CHARTER SCHOOL Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2019   grade_5 6.0 0.0 0.0   0.0 0.0     0.0   0.0   3.0 3.0     *   *         *   6.0 6 0 0   0 0     0   0   3 3                 6
1952843 MN Ramsey 62 school 2700368 4201 Charter Schools CORNERSTONE MONTESSORI ELEMENTARY 270036804523 10 CORNERSTONE MONTESSORI ELEMENTARY Elementary School (Grades PK-6) Regular School Yes Elementary KG 06 2019   grade_5 15.0 5.0 2.0   0.0 1.0     0.0   4.0   7.0 20.0     2.0   0.0     13.0   4.0   27.0 15 5 2   0 1     0   4   7 20     2 0   13 4   27
1952836 MN Ramsey 62 school 2700367 4200 Charter Schools STEP ACADEMY CHARTER SCHOOL 270036705139 20 STEP Academy Elementary Elementary School (Grades PK-6) Regular School Yes Elementary KG 06 2019   grade_5 0.0 25.0 0.0   0.0 0.0     0.0   0.0   10.0 15.0     15.0   0.0         2.0   25.0 0 25 0   0 0     0   0   10 15     15 0     2   25

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