Data source: Big Local News · About: Big Local

697 rows where grade = "grade_6", state = "MN" and year = 2019 sorted by district_state_id

View and edit SQL

year

  • 2019 · 697

grade

  • grade_6 · 697
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
1945661 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124004903 390 Heritage STEM Academy Secondary School (Grades 7-12) Regular School No High 06 12 2019   grade_6 0.0 10.0 0.0   0.0 0.0     0.0   0.0   6.0 4.0     4.0   0.0         1.0   10.0 0 10 0   0 0     0   0   6 4     4 0     1   10
1945917 MN Aitkin 1 school 2702760 1 Independent Districts and Schools AITKIN PUBLIC SCHOOL DISTRICT 270276000059 2 RIPPLESIDE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   grade_6 88.0 2.0 2.0   0.0 0.0     0.0   4.0   51.0 45.0     0.0   0.0     46.0   13.0   96.0 88 2 2   0 0     0   4   51 45     0 0   46 13   96
1951772 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124000942 106 BARTON OPEN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 08 2019   grade_6 35.0 31.0 4.0   0.0 0.0     0.0   7.0   43.0 34.0     15.0   0.0     40.0   7.0   77.0 35 31 4   0 0     0   7   43 34     15 0   40 7   77
1951794 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_6 101.0 2.0 6.0   0.0 8.0     0.0   7.0   71.0 53.0     5.0   0.0     12.0   11.0   124.0 101 2 6   0 8     0   7   71 53     5 0   12 11   124
1951815 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_6 46.0 15.0 16.0   2.0 2.0     0.0   4.0   46.0 39.0     8.0   2.0     40.0   20.0   85.0 46 15 16   2 2     0   4   46 39     8 2   40 20   85
1951887 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124001031 160 SEWARD ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 08 2019   grade_6 29.0 49.0 5.0   4.0 2.0     0.0   0.0   46.0 43.0     19.0   0.0     56.0   12.0   89.0 29 49 5   4 2     0   0   46 43     19 0   56 12   89
1951925 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124001866 175 FOLWELL ARTS MAGNET Elementary School (Grades PK-6) Regular School No Elementary PK 08 2019   grade_6 9.0 19.0 60.0   3.0 0.0     1.0   3.0   48.0 47.0     34.0   0.0         20.0   95.0 9 19 60   3 0     1   3   48 47     34 0     20   95
1951937 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124000986 179 JEFFERSON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 08 2019   grade_6 2.0 21.0 28.0   0.0 6.0     1.0   1.0   29.0 30.0     28.0   1.0         10.0   59.0 2 21 28   0 6     1   1   29 30     28 1     10   59
1951956 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124000932 190 ANDERSEN COMMUNITY Elementary School (Grades PK-6) Regular School No Elementary PK 08 2019   grade_6 2.0 33.0 63.0   3.0 2.0     0.0   1.0   51.0 53.0     53.0   8.0         24.0   104.0 2 33 63   3 2     0   1   51 53     53 8     24   104
1951968 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124002297 193 SULLIVAN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 08 2019   grade_6 4.0 52.0 4.0   5.0 0.0     0.0   0.0   29.0 36.0     28.0   5.0     55.0   10.0   65.0 4 52 4   5 0     0   0   29 36     28 5   55 10   65
1951994 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124002144 226 MARCY OPEN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 08 2019   grade_6 43.0 36.0 8.0   2.0 2.0     0.0   2.0   47.0 46.0     13.0   0.0     41.0   16.0   93.0 43 36 8   2 2     0   2   47 46     13 0   41 16   93
1952067 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124004239 291 HMONG INTERNATIONAL ACADEMY Elementary School (Grades PK-6) Regular School No Elementary PK 08 2019   grade_6 1.0 32.0 3.0   1.0 23.0     0.0   0.0   23.0 37.0     31.0   0.0         15.0   60.0 1 32 3   1 23     0   0   23 37     31 0     15   60
1954075 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_6 85.0 11.0 10.0   2.0 2.0     0.0   2.0   42.0 70.0     4.0   0.0     20.0   13.0   112.0 85 11 10   2 2     0   2   42 70     4 0   20 13   112
1954079 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124000936 300 ANTHONY MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_6 142.0 71.0 33.0   1.0 9.0     1.0   9.0   130.0 136.0     22.0   0.0     102.0   30.0   266.0 142 71 33   1 9     1   9   130 136     22 0   102 30   266
1954083 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124000937 309 ANWATIN MIDDLE COM & SPANISH D I Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_6 33.0 72.0 63.0   3.0 16.0     0.0   7.0   94.0 100.0     41.0   5.0     123.0   33.0   194.0 33 72 63   3 16     0   7   94 100     41 5   123 33   194
1954087 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124001008 316 NORTHEAST MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_6 40.0 70.0 41.0   9.0 6.0     0.0   7.0   90.0 83.0     30.0   4.0     131.0   39.0   173.0 40 70 41   9 6     0   7   90 83     30 4   131 39   173
1954091 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124002581 318 OLSON MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_6 19.0 89.0 16.0   4.0 9.0     0.0   5.0   69.0 73.0     16.0   5.0     113.0   27.0   142.0 19 89 16   4 9     0   5   69 73     16 5   113 27   142
1954095 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124004574 323 Justice Page Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_6 139.0 64.0 59.0   5.0 10.0     0.0   4.0   145.0 136.0     49.0   1.0     128.0   34.0   281.0 139 64 59   5 10     0   4   145 136     49 1   128 34   281
1954099 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124001028 324 SANFORD MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_6 121.0 82.0 62.0   20.0 7.0     0.0   19.0   150.0 161.0     38.0   1.0     185.0   46.0   311.0 121 82 62   20 7     0   19   150 161     38 1   185 46   311
1954103 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124004882 327 Franklin Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_6 3.0 99.0 21.0   5.0 0.0     1.0   3.0   80.0 52.0     11.0   4.0     116.0   32.0   132.0 3 99 21   5 0     1   3   80 52     11 4   116 32   132
1956425 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124003022 625 RIVER BEND EDUCATIONAL CENTER Special Education Special Education School No Other KG 12 2019   grade_6 1.0 9.0 0.0   1.0 0.0     0.0   1.0   10.0 2.0     0.0   0.0     10.0   *   12.0 1 9 0   1 0     0   1   10 2     0 0   10     12
1957267 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124001935 688 MPS METRO HA Hospital/Medical/Partial Hospitalization Program Alternative School No Other KG 12 2019   grade_6 1.0 2.0 0.0   0.0 0.0     0.0   0.0   2.0 1.0     *   *         *   3.0 1 2 0   0 0     0   0   2 1                 3
1957979 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124001936 689 MPS METRO SJ Educational Oversight to Public Care and Treatment Day Program Alternative School No Other KG 12 2019   grade_6 0.0 1.0 1.0   0.0 0.0     0.0   0.0   1.0 1.0     *   *         *   2.0 0 1 1   0 0     0   0   1 1                 2
1946566 MN Carlton 9 school 2744190 100 Independent Districts and Schools WRENSHALL PUBLIC SCHOOL DISTRICT 274419001842 1 WRENSHALL ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   grade_6 25.0 1.0 0.0   0.0 0.0     0.0   3.0   14.0 15.0     1.0   0.0     14.0   6.0   29.0 25 1 0   0 0     0   3   14 15     1 0   14 6   29
1953310 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 Middle 06 08 2019   grade_6 72.0 1.0 8.0   0.0 0.0     0.0   2.0   40.0 43.0     0.0   0.0     18.0   11.0   83.0 72 1 8   0 0     0   2   40 43     0 0   18 11   83
1953229 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000117 3 ANOKA MIDDLE SCHOOL FOR THE ARTS Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_6 437.0 72.0 23.0   3.0 21.0     2.0   28.0   284.0 302.0     9.0   12.0     215.0   114.0   586.0 437 72 23   3 21     2   28   284 302     9 12   215 114   586
1953233 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000099 4 COON RAPIDS MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_6 227.0 63.0 31.0   3.0 26.0     1.0   32.0   196.0 187.0     22.0   17.0     209.0   64.0   383.0 227 63 31   3 26     1   32   196 187     22 17   209 64   383
1953237 MN Hennepin 27 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000108 6 JACKSON MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_6 359.0 123.0 65.0   3.0 97.0     1.0   38.0   352.0 334.0     56.0   7.0     253.0   96.0   686.0 359 123 65   3 97     1   38   352 334     56 7   253 96   686
1953241 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000119 90 NORTHDALE MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_6 262.0 67.0 50.0   1.0 34.0     0.0   26.0   243.0 197.0     34.0   7.0     208.0   91.0   440.0 262 67 50   1 34     0   26   243 197     34 7   208 91   440
1953245 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318002501 193 OAK VIEW MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_6 381.0 19.0 14.0   0.0 11.0     1.0   16.0   229.0 213.0     7.0   2.0     72.0   49.0   442.0 381 19 14   0 11     1   16   229 213     7 2   72 49   442
1953249 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000122 195 Roosevelt Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_6 324.0 31.0 20.0   3.0 25.0     1.0   18.0   230.0 192.0     6.0   5.0     82.0   57.0   422.0 324 31 20   3 25     1   18   230 192     6 5   82 57   422
1955330 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318002974 812 COMPASS-BELL CENTER Public Area Learning Center ALC (State approved) Alternative School No High 06 12 2019   grade_6 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
1955972 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000005 467 RIVER TRAIL LEARNING CTR @ LO JACOB Special Education Special Education School No Other KG 12 2019   grade_6 6.0 0.0 0.0   0.0 0.0     0.0   1.0   5.0 2.0     *   *         *   7.0 6 0 0   0 0     0   1   5 2                 7
1957227 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318002504 440 Alexandra House Homeless Student Program, Title I Alternative School No Other KG 12 2019   grade_6 0.0 1.0 0.0   0.0 0.0     0.0   0.0   0.0 1.0     *   *         *   1.0 0 1 0   0 0     0   0   0 1                 1
1953314 MN Carver 10 school 2741460 110 Independent Districts and Schools WACONIA PUBLIC SCHOOL DISTRICT 274146003066 220 Waconia Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_6 285.0 3.0 22.0   2.0 5.0     0.0   4.0   163.0 158.0     6.0   0.0     47.0   58.0   321.0 285 3 22   2 5     0   4   163 158     6 0   47 58   321
1953319 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_6 110.0 0.0 1.0   0.0 1.0     0.0   2.0   65.0 49.0     1.0   0.0     25.0   18.0   114.0 110 0 1   0 1     0   2   65 49     1 0   25 18   114
1953323 MN Carver 10 school 2708190 112 Independent Districts and Schools EASTERN CARVER COUNTY PUBLIC SCHOOL 270819000345 61 CHASKA MIDDLE SCHOOL EAST Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_6 167.0 4.0 10.0   1.0 7.0     0.0   14.0   116.0 87.0     2.0   1.0     24.0   17.0   203.0 167 4 10   1 7     0   14   116 87     2 1   24 17   203
1953327 MN Carver 10 school 2708190 112 Independent Districts and Schools EASTERN CARVER COUNTY PUBLIC SCHOOL 270819002798 62 CHASKA MIDDLE SCHOOL WEST Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_6 188.0 7.0 17.0   0.0 10.0     0.0   18.0   126.0 114.0     6.0   0.0     40.0   33.0   240.0 188 7 17   0 10     0   18   126 114     6 0   40 33   240
1953331 MN Carver 10 school 2708190 112 Independent Districts and Schools EASTERN CARVER COUNTY PUBLIC SCHOOL 270819003180 63 PIONEER RIDGE MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_6 133.0 8.0 15.0   0.0 7.0     1.0   7.0   84.0 87.0     3.0   0.0     29.0   22.0   171.0 133 8 15   0 7     1   7   84 87     3 0   29 22   171
1955411 MN Carver 10 school 2708190 112 Independent Districts and Schools EASTERN CARVER COUNTY PUBLIC SCHOOL 270819004622 66 112 ALC MIDDLE SCHOOL Public Area Learning Center ALC (State approved) Alternative School No Middle 06 08 2019   grade_6 62.0 12.0 35.0   1.0 2.0     0.0   6.0   58.0 60.0     15.0   1.0     61.0   45.0   118.0 62 12 35   1 2     0   6   58 60     15 1   61 45   118
1946671 MN Cass 11 school 2702910 113 Independent Districts and Schools WALKER-HACKENSACK-AKELEY SCHL. DIST 270291001736 10 W.H.A. ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   grade_6 42.0 0.0 4.0   17.0 0.0     0.0   6.0   33.0 36.0     0.0   4.0     35.0   20.0   69.0 42 0 4   17 0     0   6   33 36     0 4   35 20   69
1953336 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_6 8.0 0.0 5.0   76.0 0.0     0.0   5.0   48.0 46.0     0.0   0.0     69.0   18.0   94.0 8 0 5   76 0     0   5   48 46     0 0   69 18   94
1953341 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_6 94.0 1.0 2.0   1.0 0.0     0.0   1.0   53.0 46.0     0.0   0.0     47.0   21.0   99.0 94 1 2   1 0     0   1   53 46     0 0   47 21   99
1946695 MN Cass 11 school 2730870 118 Independent Districts and Schools NORTHLAND COMMUNITY SCHOOLS 273087001307 10 REMER ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   grade_6 11.0 0.0 0.0   15.0 0.0     0.0   0.0   12.0 14.0     0.0   0.0     21.0   7.0   26.0 11 0 0   15 0     0   0   12 14     0 0   21 7   26
1953253 MN Anoka 2 school 2708100 12 Independent Districts and Schools CENTENNIAL PUBLIC SCHOOL DISTRICT 270810002784 166 CENTENNIAL MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_6 411.0 26.0 34.0   2.0 30.0     0.0   27.0   252.0 278.0     *   *         *   530.0 411 26 34   2 30     0   27   252 278                 530
1957514 MN Anoka 2 school 2708100 12 Independent Districts and Schools CENTENNIAL PUBLIC SCHOOL DISTRICT 270810004656 159 Pines School - NSP Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No High 06 12 2019   grade_6 1.0 0.0 0.0   0.0 0.0     0.0   0.0   1.0 0.0     *   *         *   1.0 1 0 0   0 0     0   0   1 0                 1
1953347 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_6 77.0 2.0 27.0   0.0 1.0     2.0   5.0   54.0 60.0     5.0   0.0     50.0   19.0   114.0 77 2 27   0 1     2   5   54 60     5 0   50 19   114
1953257 MN Anoka 2 school 2709510 13 Independent Districts and Schools COLUMBIA HEIGHTS PUBLIC SCHOOL DIST 270951000395 17 COLUMBIA ACADEMY Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_6 35.0 81.0 101.0   4.0 8.0     0.0   14.0   130.0 113.0     66.0   7.0     181.0   54.0   243.0 35 81 101   4 8     0   14   130 113     66 7   181 54   243
1953351 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_6 179.0 1.0 9.0   1.0 4.0     0.0   6.0   105.0 95.0     *   *         *   200.0 179 1 9   1 4     0   6   105 95                 200
1957339 MN Chisago 13 school 2723820 138 Independent Districts and Schools NORTH BRANCH PUBLIC SCHOOLS 272382002633 70 DISTANCE LEARNING PROGRAM Distance Learning Program OLL (State approved) Regular School No Other KG 12 2019   grade_6 1.0 0.0 0.0   0.0 0.0     0.0   0.0   0.0 1.0     *   *         *   1.0 1 0 0   0 0     0   0   0 1                 1
1946717 MN Chisago 13 school 2732550 139 Independent Districts and Schools RUSH CITY PUBLIC SCHOOL DISTRICT 273255001405 10 C.E. JACOBSON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   grade_6 63.0 0.0 2.0   2.0 0.0     0.0   4.0   40.0 31.0     0.0   0.0     31.0   8.0   71.0 63 0 2   2 0     0   4   40 31     0 0   31 8   71
1953262 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_6 53.0 89.0 24.0   2.0 13.0     0.0   20.0   86.0 115.0     29.0   3.0     152.0   32.0   201.0 53 89 24   2 13     0   20   86 115     29 3   152 32   201
1946725 MN Clay 14 school 2703660 146 Independent Districts and Schools Barnesville Public School District 270366000169 10 BARNESVILLE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 06 2019   grade_6 65.0 0.0 2.0   0.0 0.0     0.0   1.0   34.0 34.0     0.0   0.0     12.0   7.0   68.0 65 0 2   0 0     0   1   34 34     0 0   12 7   68
1953266 MN Anoka 2 school 2733540 15 Independent Districts and Schools St. Francis Area Schools 273354000013 123 ST. FRANCIS MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_6 279.0 2.0 16.0   1.0 14.0     0.0   20.0   176.0 156.0     14.0   2.0     84.0   38.0   332.0 279 2 16   1 14     0   20   176 156     14 2   84 38   332
1957327 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_6 1.0 0.0 0.0   0.0 0.0     0.0   0.0   0.0 1.0     *   *         *   1.0 1 0 0   0 0     0   0   0 1                 1
1957527 MN Anoka 2 school 2733540 15 Independent Districts and Schools St. Francis Area Schools 273354005205 856 Crossroads School Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No Other KG 12 2019   grade_6 1.0 0.0 0.0   1.0 0.0     0.0   1.0   3.0 0.0     *   *         *   3.0 1 0 0   1 0     0   1   3 0                 3
1946733 MN Clay 14 school 2713560 150 Independent Districts and Schools HAWLEY PUBLIC SCHOOL DISTRICT 271356000698 10 HAWLEY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   grade_6 75.0 0.0 2.0   0.0 1.0     0.0   3.0   41.0 40.0     *   *         *   81.0 75 0 2   0 1     0   3   41 40                 81
1946740 MN Clay 14 school 2713560 150 Independent Districts and Schools HAWLEY PUBLIC SCHOOL DISTRICT 271356002240 11 SPRING PRAIRIE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 06 2019   grade_6 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
1953356 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_6 389.0 53.0 30.0   16.0 11.0     0.0   46.0   279.0 266.0     *   *         *   545.0 389 53 30   16 11     0   46   279 266                 545
1957560 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_6 2.0 0.0 0.0   0.0 0.0     0.0   0.0   1.0 1.0     *   *         *   2.0 2 0 0   0 0     0   0   1 1                 2
1946235 MN Anoka 2 school 2733330 16 Independent Districts and Schools SPRING LAKE PARK PUBLIC SCHOOLS 273333004657 787 Elementary Lighthouse Elementary School (Grades PK-6) Regular School No Elementary 01 06 2019   grade_6 8.0 1.0 1.0   0.0 2.0     0.0   1.0   7.0 6.0     0.0   0.0     3.0   2.0   13.0 8 1 1   0 2     0   1   7 6     0 0   3 2   13
1953271 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_6 264.0 52.0 81.0   5.0 30.0     2.0   36.0   245.0 225.0     47.0   1.0     155.0   46.0   470.0 264 52 81   5 30     2   36   245 225     47 1   155 46   470
1956438 MN Rice 66 school 2700129 160 State Operated Schools (which include MN Academy Deaf & Blind, School for the Arts) MINNESOTA STATE ACADEMIES 270012903056 1 MN ACADEMY FOR THE BLIND Special Education Special Education School No Other PK 12 2019   grade_6 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
1956452 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 Other PK 12 2019   grade_6 3.0 0.0 2.0   0.0 0.0     0.0   0.0   1.0 4.0     *   *         *   5.0 3 0 2   0 0     0   0   1 4                 5
1946774 MN Clearwater 15 school 2703570 162 Independent Districts and Schools BAGLEY PUBLIC SCHOOL DISTRICT 270357000164 10 BAGLEY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   grade_6 67.0 1.0 0.0   16.0 1.0     0.0   8.0   41.0 52.0     0.0   0.0     39.0   14.0   93.0 67 1 0   16 1     0   8   41 52     0 0   39 14   93
1953360 MN Cook 16 school 2713110 166 Independent Districts and Schools COOK COUNTY PUBLIC SCHOOLS 271311002635 40 COOK COUNTY MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_6 23.0 1.0 3.0   9.0 1.0     0.0   1.0   24.0 14.0     0.0   0.0     15.0   7.0   38.0 23 1 3   9 1     0   1   24 14     0 0   15 7   38
1946792 MN Cottonwood 17 school 2723010 173 Independent Districts and Schools MOUNTAIN LAKE PUBLIC SCHOOLS 272301001134 10 MOUNTAIN LAKE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   grade_6 26.0 2.0 8.0   0.0 4.0     0.0   2.0   22.0 20.0     4.0   0.0     22.0   6.0   42.0 26 2 8   0 4     0   2   22 20     4 0   22 6   42
1953366 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_6 51.0 3.0 25.0   0.0 2.0     2.0   10.0   52.0 41.0     5.0   0.0     53.0   18.0   93.0 51 3 25   0 2     2   10   52 41     5 0   53 18   93
1953371 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_6 452.0 7.0 14.0   7.0 1.0     0.0   13.0   227.0 267.0     *   *         *   494.0 452 7 14   7 1     0   13   227 267                 494
1957836 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_6 4.0 0.0 0.0   0.0 0.0     0.0   0.0   4.0 0.0     *   *         *   4.0 4 0 0   0 0     0   0   4 0                 4
1946842 MN Crow Wing 18 school 2709750 182 Independent Districts and Schools CROSBY-IRONTON PUBLIC SCHOOL DIST. 270975000291 6 CUYUNA RANGE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   grade_6 77.0 0.0 3.0   0.0 0.0     0.0   4.0   48.0 36.0     0.0   0.0     39.0   20.0   84.0 77 0 3   0 0     0   4   48 36     0 0   39 20   84
1953376 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_6 139.0 3.0 1.0   2.0 0.0     0.0   1.0   79.0 67.0     0.0   0.0     54.0   17.0   146.0 139 3 1   2 0     0   1   79 67     0 0   54 17   146
1953380 MN Dakota 19 school 2707290 191 Independent Districts and Schools BURNSVILLE PUBLIC SCHOOL DISTRICT 270729000295 15 John Metcalf Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_6 37.0 15.0 11.0   0.0 4.0     0.0   5.0   32.0 40.0     *   *     26.0   9.0   72.0 37 15 11   0 4     0   5   32 40           26 9   72
1953384 MN Scott 70 school 2707290 191 Independent Districts and Schools BURNSVILLE PUBLIC SCHOOL DISTRICT 270729002639 66 Eagle Ridge Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_6 19.0 9.0 13.0   0.0 3.0     0.0   2.0   24.0 22.0     3.0   0.0     23.0   8.0   46.0 19 9 13   0 3     0   2   24 22     3 0   23 8   46
1953388 MN Dakota 19 school 2707290 191 Independent Districts and Schools BURNSVILLE PUBLIC SCHOOL DISTRICT 270729000297 85 Joseph Nicollet Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_6 43.0 37.0 18.0   0.0 7.0     0.0   8.0   59.0 54.0     *   *     66.0   5.0   113.0 43 37 18   0 7     0   8   59 54           66 5   113
1955446 MN Dakota 19 school 2707290 191 Independent Districts and Schools BURNSVILLE PUBLIC SCHOOL DISTRICT 270729002640 314 BURNSVILLE AREA LEARNING CENTER Public Area Learning Center ALC (State approved) Alternative School No High 06 12 2019   grade_6 140.0 136.0 107.0   4.0 27.0     1.0   30.0   243.0 202.0     90.0   6.0     278.0   95.0   445.0 140 136 107   4 27     1   30   243 202     90 6   278 95   445
1946971 MN Dakota 19 school 2711820 192 Independent Districts and Schools FARMINGTON PUBLIC SCHOOL DISTRICT 271182004376 100 RIVERVIEW ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   grade_6 1.0 0.0 0.0   0.0 0.0     0.0   0.0   1.0 0.0     *   *         *   1.0 1 0 0   0 0     0   0   1 0                 1
1946975 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_6 5.0 1.0 1.0   0.0 0.0     0.0   0.0   6.0 1.0     *   *         *   7.0 5 1 1   0 0     0   0   6 1                 7
1953392 MN Dakota 19 school 2711820 192 Independent Districts and Schools FARMINGTON PUBLIC SCHOOL DISTRICT 271182000570 30 LEVI P. DODGE MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_6 208.0 13.0 26.0   1.0 15.0     0.0   18.0   148.0 133.0     13.0   *     50.0   38.0   281.0 208 13 26   1 15     0   18   148 133     13     50 38   281
1953396 MN Dakota 19 school 2711820 192 Independent Districts and Schools FARMINGTON PUBLIC SCHOOL DISTRICT 271182002983 60 ROBERT BOECKMAN MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_6 257.0 8.0 15.0   2.0 12.0     0.0   15.0   145.0 164.0     *   2.0     44.0   52.0   309.0 257 8 15   2 12     0   15   145 164       2   44 52   309
1953400 MN Dakota 19 school 2717780 194 Independent Districts and Schools LAKEVILLE PUBLIC SCHOOL DISTRICT 271778002435 89 MCGUIRE MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_6 258.0 13.0 18.0   1.0 14.0     1.0   13.0   163.0 155.0     5.0   *     40.0   36.0   318.0 258 13 18   1 14     1   13   163 155     5     40 36   318
1953404 MN Dakota 19 school 2717780 194 Independent Districts and Schools LAKEVILLE PUBLIC SCHOOL DISTRICT 271778000483 104 KENWOOD TRAIL MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_6 146.0 18.0 44.0   2.0 10.0     0.0   14.0   115.0 119.0     9.0   1.0     64.0   36.0   234.0 146 18 44   2 10     0   14   115 119     9 1   64 36   234
1953408 MN Dakota 19 school 2717780 194 Independent Districts and Schools LAKEVILLE PUBLIC SCHOOL DISTRICT 271778002984 105 CENTURY MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_6 244.0 11.0 9.0   2.0 21.0     0.0   18.0   152.0 153.0     *   0.0         *   305.0 244 11 9   2 21     0   18   152 153       0         305
1957352 MN Dakota 19 school 2717780 194 Independent Districts and Schools LAKEVILLE PUBLIC SCHOOL DISTRICT 271778004309 90 Link12 Lakeville Distance Learning Program OLL (State approved) Regular School No Other KG 12 2019   grade_6 4.0 0.0 0.0   0.0 0.0     0.0   1.0   2.0 3.0     *   *         *   5.0 4 0 0   0 0     0   1   2 3                 5
1947050 MN Dakota 19 school 2730150 195 Independent Districts and Schools RANDOLPH PUBLIC SCHOOL DISTRICT 273015001286 10 RANDOLPH ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   grade_6 49.0 0.0 4.0   0.0 0.0     0.0   0.0   32.0 21.0     0.0   0.0     8.0   7.0   53.0 49 0 4   0 0     0   0   32 21     0 0   8 7   53
1953412 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239000484 25 DAKOTA HILLS MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_6 273.0 22.0 59.0   0.0 59.0     0.0   24.0   222.0 215.0     21.0   3.0     82.0   53.0   437.0 273 22 59   0 59     0   24   222 215     21 3   82 53   437
1953416 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239002437 32 BLACK HAWK MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_6 148.0 53.0 33.0   0.0 27.0     0.0   21.0   126.0 156.0     15.0   *     90.0   53.0   282.0 148 53 33   0 27     0   21   126 156     15     90 53   282
1953420 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239001381 39 ROSEMOUNT MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_6 318.0 22.0 22.0   1.0 29.0     1.0   28.0   206.0 215.0     *   0.0     61.0   41.0   421.0 318 22 22   1 29     1   28   206 215       0   61 41   421
1953424 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239002644 86 FALCON RIDGE MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_6 192.0 44.0 50.0   2.0 20.0     0.0   26.0   156.0 178.0     19.0   0.0     99.0   54.0   334.0 192 44 50   2 20     0   26   156 178     19 0   99 54   334
1953428 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239001943 93 SCOTT HIGHLANDS MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_6 264.0 46.0 32.0   0.0 53.0     0.0   33.0   214.0 214.0     *   0.0     91.0   60.0   428.0 264 46 32   0 53     0   33   214 214       0   91 60   428
1953432 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239001383 98 VALLEY MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_6 178.0 86.0 54.0   4.0 15.0     0.0   38.0   190.0 185.0     23.0   2.0     164.0   57.0   375.0 178 86 54   4 15     0   38   190 185     23 2   164 57   375
1956057 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239002517 100 DAKOTA RIDGE SCHOOL Special Education Special Education School No Other KG 12 2019   grade_6 3.0 4.0 2.0   0.0 0.0     0.0   1.0   7.0 3.0     0.0   *     6.0   *   10.0 3 4 2   0 0     0   1   7 3     0     6     10
1953437 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_6 99.0 32.0 40.0   1.0 12.0     0.0   19.0   98.0 105.0     12.0   0.0     77.0   34.0   203.0 99 32 40   1 12     0   19   98 105     12 0   77 34   203
1953442 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_6 93.0 18.0 72.0   3.0 7.0     0.0   17.0   114.0 96.0     17.0   2.0     109.0   49.0   210.0 93 18 72   3 7     0   17   114 96     17 2   109 49   210
1953446 MN Dakota 19 school 2715030 199 Independent Districts and Schools INVER GROVE HEIGHTS SCHOOLS 271503000765 27 INVER GROVE HEIGHTS MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_6 117.0 36.0 69.0   3.0 13.0     0.0   23.0   129.0 132.0     22.0   3.0     136.0   40.0   261.0 117 36 69   3 13     0   23   129 132     22 3   136 40   261
1953225 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_6 16.0 0.0 1.0   0.0 0.0     0.0   1.0   10.0 8.0     0.0   0.0     9.0   3.0   18.0 16 0 1   0 0     0   1   10 8     0 0   9 3   18
1953451 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_6 285.0 12.0 16.0   2.0 3.0     0.0   7.0   158.0 167.0     0.0   *         *   325.0 285 12 16   2 3     0   7   158 167     0           325
1944544 MN Dodge 20 school 2713590 203 Independent Districts and Schools HAYFIELD PUBLIC SCHOOL DISTRICT 271359000702 1 HAYFIELD SECONDARY Secondary School (Grades 7-12) Regular School No High 06 12 2019   grade_6 47.0 1.0 6.0   0.0 0.0     0.0   3.0   31.0 26.0     0.0   1.0     22.0   3.0   57.0 47 1 6   0 0     0   3   31 26     0 1   22 3   57
1953456 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_6 145.0 2.0 11.0   0.0 1.0     0.0   10.0   86.0 83.0     2.0   3.0     33.0   17.0   169.0 145 2 11   0 1     0   10   86 83     2 3   33 17   169
1953460 MN Douglas 21 school 2703060 206 Independent Districts and Schools ALEXANDRIA PUBLIC SCHOOL DISTRICT 270306000083 310 Discovery Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_6 311.0 2.0 7.0   0.0 0.0     0.0   14.0   167.0 167.0     0.0   1.0     88.0   44.0   334.0 311 2 7   0 0     0   14   167 167     0 1   88 44   334

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