enrollments

Data source: Big Local News · About: Big Local

951 rows where grade = "grade_5", state = "MN" and year = 2017 sorted by county

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2017 · 951 ✖

grade ✖

  • grade_5 · 951 ✖
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
690554 690554 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 2017   grade_5 74.0 0.0 1.0   2.0 0.0     0.0   3.0   31.0 49.0     0.0   0.0     38.0   5.0   80.0 74 0 1   2 0     0   3   31 49     0 0   38 5   80
690571 690571 MN Aitkin 1 school 2719170 4 Independent Districts and Schools MCGREGOR PUBLIC SCHOOL DISTRICT 271917000903 10 MCGREGOR ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_5 26.0 0.0 2.0   5.0 0.0     0.0   0.0   18.0 15.0     0.0   0.0     19.0   7.0   33.0 26 0 2   5 0     0   0   18 15     0 0   19 7   33
697679 697679 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 2017   grade_5 13.0 0.0 0.0   1.0 0.0     0.0   1.0   10.0 5.0     0.0   0.0     9.0   1.0   15.0 13 0 0   1 0     0   1   10 5     0 0   9 1   15
702758 702758 MN Aitkin 1 school 2700300 4177 Charter Schools MINISINAAKWAANG LEADERSHIP ACADEMY 270030003730 10 MINISINAAKWAANG LEADERSHIP ACADEMY Elementary/Secondary Combined (Grades K-12 limited to District Type 34 Bureau of Indian Education) Regular School Yes Other KG 12 2017   grade_5 0.0 0.0 0.0   1.0 0.0     0.0   0.0   0.0 1.0         *         *   1.0 0 0 0   1 0     0   0   0 1                 1
690580 690580 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000095 400 ADAMS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_5 61.0 16.0 8.0   1.0 7.0     0.0   3.0   51.0 45.0     0.0   0.0     63.0   11.0   96.0 61 16 8   1 7     0   3   51 45     0 0   63 11   96
690587 690587 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000101 402 CROOKED LAKE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_5 71.0 3.0 3.0   0.0 1.0     0.0   3.0   46.0 35.0     1.0   1.0     20.0   14.0   81.0 71 3 3   0 1     0   3   46 35     1 1   20 14   81
690594 690594 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000105 403 FRANKLIN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_5 36.0 10.0 5.0   1.0 3.0     1.0   6.0   36.0 26.0     3.0   0.0     34.0   15.0   62.0 36 10 5   1 3     1   6   36 26     3 0   34 15   62
690601 690601 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000106 404 HAMILTON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_5 55.0 14.0 12.0   0.0 4.0     0.0   5.0   48.0 42.0     7.0   4.0     56.0   19.0   90.0 55 14 12   0 4     0   5   48 42     7 4   56 19   90
690608 690608 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000107 405 HOOVER ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_5 59.0 9.0 7.0   1.0 3.0     0.0   4.0   49.0 34.0     2.0   0.0     42.0   22.0   83.0 59 9 7   1 3     0   4   49 34     2 0   42 22   83
690615 690615 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000110 406 JEFFERSON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_5 98.0 15.0 12.0   0.0 12.0     0.0   7.0   90.0 54.0     8.0   0.0     72.0   30.0   144.0 98 15 12   0 12     0   7   90 54     8 0   72 30   144
690622 690622 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000111 407 JOHNSVILLE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_5 105.0 5.0 4.0   0.0 7.0     0.0   1.0   62.0 60.0     2.0   0.0     19.0   16.0   122.0 105 5 4   0 7     0   1   62 60     2 0   19 16   122
690629 690629 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000112 408 Lincoln Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_5 51.0 7.0 5.0   1.0 0.0     0.0   4.0   30.0 38.0     1.0   0.0     30.0   18.0   68.0 51 7 5   1 0     0   4   30 38     1 0   30 18   68
690636 690636 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000113 410 MADISON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_5 56.0 3.0 6.0   1.0 7.0     0.0   2.0   43.0 32.0     5.0   0.0     29.0   14.0   75.0 56 3 6   1 7     0   2   43 32     5 0   29 14   75
690643 690643 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000114 411 MCKINLEY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_5 104.0 0.0 2.0   1.0 5.0     0.0   2.0   51.0 63.0     0.0   2.0     22.0   9.0   114.0 104 0 2   1 5     0   2   51 63     0 2   22 9   114
690650 690650 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000115 412 MISSISSIPPI ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_5 47.0 13.0 3.0   2.0 2.0     0.0   7.0   35.0 39.0     3.0   3.0     34.0   17.0   74.0 47 13 3   2 2     0   7   35 39     3 3   34 17   74
690664 690664 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000118 414 MORRIS BYE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_5 61.0 9.0 4.0   0.0 3.0     1.0   8.0   45.0 41.0     3.0   0.0     38.0   22.0   86.0 61 9 4   0 3     1   8   45 41     3 0   38 22   86
690671 690671 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000123 417 SAND CREEK ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_5 109.0 12.0 4.0   3.0 10.0     0.0   5.0   77.0 66.0     2.0   2.0     55.0   28.0   143.0 109 12 4   3 10     0   5   77 66     2 2   55 28   143
690678 690678 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000126 418 UNIVERSITY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_5 56.0 25.0 7.0   1.0 9.0     0.0   9.0   50.0 57.0     6.0   0.0     59.0   15.0   107.0 56 25 7   1 9     0   9   50 57     6 0   59 15   107
690685 690685 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000128 420 WILSON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_5 76.0 5.0 2.0   0.0 3.0     0.0   6.0   53.0 39.0     4.0   3.0     50.0   16.0   92.0 76 5 2   0 3     0   6   53 39     4 3   50 16   92
690700 690700 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000103 422 EISENHOWER ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_5 72.0 14.0 13.0   0.0 10.0     0.0   7.0   61.0 55.0     5.0   5.0     62.0   20.0   116.0 72 14 13   0 10     0   7   61 55     5 5   62 20   116
690707 690707 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000120 423 RAMSEY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_5 198.0 25.0 6.0   3.0 5.0     0.0   12.0   129.0 120.0     6.0   3.0     69.0   38.0   249.0 198 25 6   3 5     0   12   129 120     6 3   69 38   249
690728 690728 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318002203 426 ANDOVER ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_5 197.0 7.0 11.0   0.0 9.0     1.0   4.0   121.0 108.0     4.0   1.0     38.0   29.0   229.0 197 7 11   0 9     1   4   121 108     4 1   38 29   229
690735 690735 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318003058 427 RUM RIVER ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_5 160.0 0.0 4.0   1.0 5.0     0.0   1.0   83.0 88.0     1.0   1.0     27.0   24.0   171.0 160 0 4   1 5     0   1   83 88     1 1   27 24   171
690749 690749 MN Anoka 2 school 2708100 12 Independent Districts and Schools CENTENNIAL PUBLIC SCHOOL DISTRICT 270810000332 510 CENTENNIAL ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_5 54.0 8.0 3.0   0.0 4.0     0.0   2.0   33.0 38.0     2.0   0.0     25.0   16.0   71.0 54 8 3   0 4     0   2   33 38     2 0   25 16   71
690756 690756 MN Anoka 2 school 2708100 12 Independent Districts and Schools CENTENNIAL PUBLIC SCHOOL DISTRICT 270810000335 511 CENTERVILLE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_5 65.0 0.0 2.0   0.0 1.0     0.0   2.0   38.0 32.0     0.0   0.0     5.0   12.0   70.0 65 0 2   0 1     0   2   38 32     0 0   5 12   70
690763 690763 MN Anoka 2 school 2708100 12 Independent Districts and Schools CENTENNIAL PUBLIC SCHOOL DISTRICT 270810000336 512 GOLDEN LAKE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_5 36.0 4.0 12.0   0.0 3.0     0.0   5.0   29.0 31.0     7.0   1.0     30.0   15.0   60.0 36 4 12   0 3     0   5   29 31     7 1   30 15   60
690770 690770 MN Anoka 2 school 2708100 12 Independent Districts and Schools CENTENNIAL PUBLIC SCHOOL DISTRICT 270810000022 513 RICE LAKE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_5 97.0 2.0 4.0   0.0 2.0     0.0   5.0   60.0 50.0     0.0   1.0     7.0   23.0   110.0 97 2 4   0 2     0   5   60 50     0 1   7 23   110
690777 690777 MN Anoka 2 school 2708100 12 Independent Districts and Schools CENTENNIAL PUBLIC SCHOOL DISTRICT 270810003172 515 BLUE HERON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_5 134.0 4.0 7.0   2.0 6.0     0.0   11.0   79.0 85.0     1.0   0.0     22.0   27.0   164.0 134 4 7   2 6     0   11   79 85     1 0   22 27   164
690786 690786 MN Anoka 2 school 2709510 13 Independent Districts and Schools COLUMBIA HEIGHTS PUBLIC SCHOOL DIST 270951000398 515 HIGHLAND ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_5 15.0 21.0 26.0   2.0 3.0     0.0   12.0   43.0 36.0         2.0     54.0   13.0   79.0 15 21 26   2 3     0   12   43 36       2   54 13   79
690795 690795 MN Anoka 2 school 2709510 13 Independent Districts and Schools COLUMBIA HEIGHTS PUBLIC SCHOOL DIST 270951000400 517 NORTH PARK ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_5 15.0 29.0 29.0   1.0 3.0     0.0   6.0   46.0 37.0         3.0     65.0   19.0   83.0 15 29 29   1 3     0   6   46 37       3   65 19   83
690804 690804 MN Anoka 2 school 2709510 13 Independent Districts and Schools COLUMBIA HEIGHTS PUBLIC SCHOOL DIST 270951000402 520 VALLEY VIEW ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_5 14.0 24.0 43.0   1.0 2.0     0.0   5.0   40.0 49.0         2.0     77.0   14.0   89.0 14 24 43   1 2     0   5   40 49       2   77 14   89
690826 690826 MN Anoka 2 school 2733540 15 Independent Districts and Schools ST. FRANCIS PUBLIC SCHOOL DISTRICT 273354000230 782 ST. FRANCIS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_5 105.0 0.0 4.0   1.0 3.0     0.0   4.0   61.0 56.0         0.0         17.0   117.0 105 0 4   1 3     0   4   61 56       0     17   117
690833 690833 MN Anoka 2 school 2733540 15 Independent Districts and Schools ST. FRANCIS PUBLIC SCHOOL DISTRICT 273354000233 784 CEDAR CREEK COMMUNITY SCHOOL Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_5 109.0 0.0 3.0   0.0 8.0     0.0   4.0   74.0 50.0     7.0   *     35.0   20.0   124.0 109 0 3   0 8     0   4   74 50     7     35 20   124
690840 690840 MN Anoka 2 school 2733540 15 Independent Districts and Schools ST. FRANCIS PUBLIC SCHOOL DISTRICT 273354000258 848 EAST BETHEL COMMUNITY SCHOOL Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_5 84.0 2.0 3.0   1.0 1.0     0.0   6.0   51.0 46.0     2.0   0.0     34.0   *   97.0 84 2 3   1 1     0   6   51 46     2 0   34     97
690848 690848 MN Anoka 2 school 2733330 16 Independent Districts and Schools SPRING LAKE PARK PUBLIC SCHOOLS 273333001465 773 WESTWOOD INTERMEDIATE SCHOOL Elementary School (Grades PK-6) Regular School No Elementary 04 05 2017   grade_5 222.0 60.0 46.0   7.0 35.0     0.0   33.0   199.0 204.0     67.0   7.0     200.0   61.0   403.0 222 60 46   7 35     0   33   199 204     67 7   200 61   403
690855 690855 MN Anoka 2 school 2733330 16 Independent Districts and Schools SPRING LAKE PARK PUBLIC SCHOOLS 273333001467 774 Woodcrest Elementary Spanish Immersion Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_5 31.0 2.0 14.0   0.0 3.0     0.0   6.0   21.0 35.0     7.0   0.0     10.0   3.0   56.0 31 2 14   0 3     0   6   21 35     7 0   10 3   56
690865 690865 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 2017   grade_5 8.0 0.0 1.0   0.0 2.0     0.0   2.0   9.0 4.0     0.0   0.0     3.0   1.0   13.0 8 0 1   0 2     0   2   9 4     0 0   3 1   13
694998 694998 MN Anoka 2 school 2712270 831 Independent Districts and Schools FOREST LAKE PUBLIC SCHOOL DISTRICT 271227000597 628 Lino Lakes Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_5 53.0 5.0 4.0   1.0 3.0     0.0   2.0   33.0 35.0     4.0   0.0     16.0   11.0   68.0 53 5 4   1 3     0   2   33 35     4 0   16 11   68
696654 696654 MN Anoka 2 school 2700093 4008 Charter Schools PACT CHARTER SCHOOL 270009302488 10 PACT CHARTER SCHOOL Elementary School (Grades PK-6) Regular School Yes Elementary KG 06 2017   grade_5 45.0 2.0 3.0   0.0 1.0     0.0   1.0   23.0 29.0     0.0   0.0     8.0   8.0   52.0 45 2 3   0 1     0   1   23 29     0 0   8 8   52
697266 697266 MN Anoka 2 school 2700320 4185 Charter Schools DAVINCI ACADEMY 270032004268 10 DAVINCI ACADEMY Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2017   grade_5 32.0 5.0 2.0   0.0 7.0     0.0   4.0   26.0 24.0     0.0   0.0     7.0   7.0   50.0 32 5 2   0 7     0   4   26 24     0 0   7 7   50
697276 697276 MN Anoka 2 school 2700313 4186 Charter Schools GLOBAL ACADEMY 270031304294 10 GLOBAL ACADEMY Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2017   grade_5 11.0 36.0 0.0   0.0 0.0     0.0   1.0   29.0 19.0     6.0   1.0     40.0   11.0   48.0 11 36 0   0 0     0   1   29 19     6 1   40 11   48
697452 697452 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 2017   grade_5 11.0 9.0 0.0   0.0 1.0     0.0   0.0   10.0 11.0     4.0   0.0     11.0   0.0   21.0 11 9 0   0 1     0   0   10 11     4 0   11 0   21
697716 697716 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 2017   grade_5 84.0 92.0 27.0   3.0 15.0     0.0   17.0   122.0 116.0     26.0   3.0     163.0   39.0   238.0 84 92 27   3 15     0   17   122 116     26 3   163 39   238
700447 700447 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 2017   grade_5 12.0 4.0 0.0   0.0 0.0     0.0   0.0   15.0 1.0     0.0   1.0     9.0   *   16.0 12 4 0   0 0     0   0   15 1     0 1   9     16
701115 701115 MN Anoka 2 school 2702264 916 Intermediate Districts and Schools NORTHEAST METRO 916 270226404643 40 Karner Blue Education Center Special Education Special Education School No Elementary KG 08 2017   grade_5 15.0 5.0 4.0   0.0 1.0     0.0   0.0   22.0 3.0     0.0   0.0     9.0   *   25.0 15 5 4   0 1     0   0   22 3     0 0   9     25
702255 702255 MN Anoka 2 school 2733540 15 Independent Districts and Schools ST. FRANCIS PUBLIC SCHOOL DISTRICT 273354000268 850 CROSSROADS SCHOOL & VOC. CENTER Miscellaneous Program (assignment is now limited) Alternative School No Other KG 12 2017   grade_5 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
690873 690873 MN Becker 3 school 2710230 22 Independent Districts and Schools DETROIT LAKES PUBLIC SCHOOL DIST. 271023000445 10 ROSSMAN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_5 101.0 3.0 4.0   8.0 0.0     0.0   6.0   65.0 57.0     0.0   0.0     43.0   15.0   122.0 101 3 4   8 0     0   6   65 57     0 0   43 15   122
690889 690889 MN Becker 3 school 2712360 23 Independent Districts and Schools FRAZEE-VERGAS PUBLIC SCHOOL DIST. 271236000607 10 FRAZEE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_5 61.0 0.0 4.0   3.0 0.0     0.0   9.0   38.0 39.0     0.0   2.0     43.0   15.0   77.0 61 0 4   3 0     0   9   38 39     0 2   43 15   77
690897 690897 MN Becker 3 school 2728960 25 Independent Districts and Schools PINE POINT PUBLIC SCHOOL DISTRICT 272896000034 70 PINE POINT ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 08 2017   grade_5 0.0 0.0 0.0   4.0 0.0     0.0   0.0   0.0 4.0         *         *   4.0 0 0 0   4 0     0   0   0 4                 4
696129 696129 MN Becker 3 school 2700162 2889 Independent Districts and Schools LAKE PARK AUDUBON SCHOOL DISTRICT 270016200142 10 LAKE PARK AUDUBON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_5 42.0 0.0 1.0   0.0 0.0     0.0   2.0   27.0 18.0     0.0   0.0     13.0   5.0   45.0 42 0 1   0 0     0   2   27 18     0 0   13 5   45
697729 697729 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 2017   grade_5 83.0 3.0 3.0   18.0 3.0     0.0   17.0   78.0 49.0     2.0   1.0     59.0   30.0   127.0 83 3 3   18 3     0   17   78 49     2 1   59 30   127
690907 690907 MN Beltrami 4 school 2704440 31 Independent Districts and Schools BEMIDJI PUBLIC SCHOOL DISTRICT 270444000194 16 NORTHERN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 01 05 2017   grade_5 73.0 0.0 3.0   10.0 1.0     0.0   7.0   49.0 45.0     0.0   0.0     44.0   12.0   94.0 73 0 3   10 1     0   7   49 45     0 0   44 12   94
690917 690917 MN Beltrami 4 school 2704440 31 Independent Districts and Schools BEMIDJI PUBLIC SCHOOL DISTRICT 270444000196 40 J.W. SMITH ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_5 23.0 1.0 3.0   20.0 0.0     0.0   18.0   37.0 28.0     0.0   1.0     53.0   13.0   65.0 23 1 3   20 0     0   18   37 28     0 1   53 13   65
690925 690925 MN Beltrami 4 school 2704440 31 Independent Districts and Schools BEMIDJI PUBLIC SCHOOL DISTRICT 270444000191 50 CENTRAL ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_5 18.0 0.0 2.0   6.0 1.0     0.0   6.0   19.0 14.0     1.0   1.0     21.0   8.0   33.0 18 0 2   6 1     0   6   19 14     1 1   21 8   33
690933 690933 MN Beltrami 4 school 2704440 31 Independent Districts and Schools BEMIDJI PUBLIC SCHOOL DISTRICT 270444000192 60 Lincoln Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_5 59.0 1.0 2.0   16.0 0.0     0.0   12.0   46.0 44.0     0.0   2.0     45.0   13.0   90.0 59 1 2   16 0     0   12   46 44     0 2   45 13   90
690940 690940 MN Beltrami 4 school 2704440 31 Independent Districts and Schools BEMIDJI PUBLIC SCHOOL DISTRICT 270444000197 80 SOLWAY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 01 05 2017   grade_5 26.0 0.0 0.0   2.0 0.0     0.0   5.0   13.0 20.0     0.0   0.0     18.0   3.0   33.0 26 0 0   2 0     0   5   13 20     0 0   18 3   33
690947 690947 MN Beltrami 4 school 2704440 31 Independent Districts and Schools BEMIDJI PUBLIC SCHOOL DISTRICT 270444000193 100 HORACE MAY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 01 05 2017   grade_5 62.0 1.0 0.0   9.0 3.0     0.0   6.0   41.0 40.0     2.0   3.0     33.0   14.0   81.0 62 1 0   9 3     0   6   41 40     2 3   33 14   81
690956 690956 MN Beltrami 4 school 2705730 32 Independent Districts and Schools BLACKDUCK PUBLIC SCHOOL DISTRICT 270573000212 10 BLACKDUCK ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_5 27.0 1.0 1.0   5.0 0.0     0.0   4.0   22.0 16.0     0.0   0.0     24.0   7.0   38.0 27 1 1   5 0     0   4   22 16     0 0   24 7   38
690966 690966 MN Beltrami 4 school 2717010 36 Independent Districts and Schools KELLIHER PUBLIC SCHOOL DISTRICT 271701000786 10 KELLIHER ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_5 17.0 0.0 0.0   10.0 0.0     0.0   0.0   18.0 9.0     0.0   0.0     22.0   7.0   27.0 17 0 0   10 0     0   0   18 9     0 0   22 7   27
690973 690973 MN Beltrami 4 school 2730510 38 Independent Districts and Schools RED LAKE PUBLIC SCHOOL DISTRICT 273051001302 10 RED LAKE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 01 05 2017   grade_5 0.0 1.0 0.0   92.0 0.0     0.0   0.0   45.0 48.0     1.0   11.0         *   93.0 0 1 0   92 0     0   0   45 48     1 11         93
690984 690984 MN Beltrami 4 school 2730510 38 Independent Districts and Schools RED LAKE PUBLIC SCHOOL DISTRICT 273051001301 20 PONEMAH ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 08 2017   grade_5 0.0 0.0 0.0   25.0 0.0     0.0   0.0   14.0 11.0     0.0   2.0         *   25.0 0 0 0   25 0     0   0   14 11     0 2         25
696830 696830 MN Beltrami 4 school 2700225 4058 Charter Schools SCHOOLCRAFT LEARNING COMMUNITY CHTR 270022503464 10 SCHOOLCRAFT LEARNING COMMUNITY CHTR Elementary School (Grades PK-6) Regular School Yes Other KG 09 2017   grade_5 26.0 0.0 4.0   5.0 0.0     0.0   3.0   20.0 18.0     0.0   0.0     19.0   10.0   38.0 26 0 4   5 0     0   3   20 18     0 0   19 10   38
690994 690994 MN Benton 5 school 2732880 47 Independent Districts and Schools SAUK RAPIDS-RICE PUBLIC SCHOOLS 273288001430 3 MISSISSIPPI HEIGHTS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_5 160.0 7.0 6.0   0.0 1.0     0.0   5.0   86.0 93.0     3.0   1.0     51.0   28.0   179.0 160 7 6   0 1     0   5   86 93     3 1   51 28   179
691002 691002 MN Benton 5 school 2732880 47 Independent Districts and Schools SAUK RAPIDS-RICE PUBLIC SCHOOLS 273288001433 6 RICE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_5 48.0 0.0 3.0   0.0 0.0     0.0   4.0   33.0 22.0     1.0   2.0     18.0   13.0   55.0 48 0 3   0 0     0   4   33 22     1 2   18 13   55
691010 691010 MN Benton 5 school 2732880 47 Independent Districts and Schools SAUK RAPIDS-RICE PUBLIC SCHOOLS 273288001431 7 PLEASANT VIEW ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_5 106.0 9.0 6.0   1.0 3.0     0.0   4.0   63.0 66.0     3.0   3.0     55.0   20.0   129.0 106 9 6   1 3     0   4   63 66     3 3   55 20   129
691019 691019 MN Benton 5 school 2712240 51 Independent Districts and Schools FOLEY PUBLIC SCHOOL DISTRICT 271224002270 30 FOLEY INTERMEDIATE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 04 08 2017   grade_5 141.0 1.0 1.0   1.0 0.0     0.0   2.0   74.0 72.0     0.0   0.0     43.0   26.0   146.0 141 1 1   1 0     0   2   74 72     0 0   43 26   146
694706 694706 MN Benton 5 school 2733510 742 Independent Districts and Schools ST. CLOUD PUBLIC SCHOOL DISTRICT 273351001486 28 Lincoln Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_5 17.0 19.0 3.0   1.0 0.0     0.0   6.0   24.0 22.0     5.0   3.0     37.0   9.0   46.0 17 19 3   1 0     0   6   24 22     5 3   37 9   46
696121 696121 MN Big Stone 6 school 2700150 2888 Independent Districts and Schools CLINTON-GRACEVILLE-BEARDSLEY 270015000378 1 CLINTON-GRACEVILLE-BEARDSLEY EL. Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_5 20.0 0.0 0.0   0.0 0.0     0.0   0.0   10.0 10.0         *         *   20.0 20 0 0   0 0     0   0   10 10                 20
696199 696199 MN Big Stone 6 school 2700328 2903 Independent Districts and Schools ORTONVILLE PUBLIC SCHOOLS 270032804394 10 KNOLL ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_5 34.0 0.0 2.0   0.0 1.0     0.0   1.0   18.0 20.0     0.0   0.0     18.0   5.0   38.0 34 0 2   0 1     0   1   18 20     0 0   18 5   38
702704 702704 MN Big Stone 6 school 2700150 2888 Independent Districts and Schools CLINTON-GRACEVILLE-BEARDSLEY 270015003019 6 Lismore Colony School Elementary/Secondary Combined (Grades K-12 limited to District Type 34 Bureau of Indian Education) Regular School No Other KG 10 2017   grade_5 3.0 0.0 0.0   0.0 0.0     0.0   0.0   2.0 1.0         *         *   3.0 3 0 0   0 0     0   0   2 1                 3
691030 691030 MN Blue Earth 7 school 2733480 75 Independent Districts and Schools ST. CLAIR PUBLIC SCHOOL DISTRICT 273348001477 10 ST. CLAIR ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_5 59.0 0.0 0.0   0.0 0.0     0.0   1.0   29.0 31.0     0.0   0.0     18.0   5.0   60.0 59 0 0   0 0     0   1   29 31     0 0   18 5   60
691040 691040 MN Blue Earth 7 school 2718780 77 Independent Districts and Schools MANKATO PUBLIC SCHOOL DISTRICT 271878000877 10 KENNEDY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_5 39.0 11.0 2.0   0.0 0.0     0.0   8.0   23.0 37.0     9.0   2.0     26.0   6.0   60.0 39 11 2   0 0     0   8   23 37     9 2   26 6   60
691054 691054 MN Blue Earth 7 school 2718780 77 Independent Districts and Schools MANKATO PUBLIC SCHOOL DISTRICT 271878000876 30 JEFFERSON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_5 37.0 2.0 1.0   2.0 0.0     0.0   2.0   23.0 21.0         5.0         7.0   44.0 37 2 1   2 0     0   2   23 21       5     7   44
691068 691068 MN Blue Earth 7 school 2718780 77 Independent Districts and Schools MANKATO PUBLIC SCHOOL DISTRICT 271878000883 50 ROOSEVELT ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_5 57.0 6.0 5.0   0.0 1.0     0.0   2.0   32.0 39.0     4.0   *     26.0   11.0   71.0 57 6 5   0 1     0   2   32 39     4     26 11   71
691082 691082 MN Blue Earth 7 school 2718780 77 Independent Districts and Schools MANKATO PUBLIC SCHOOL DISTRICT 271878004388 70 ROSA PARKS ELEMENTARY SCHOOL Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_5 74.0 7.0 7.0   0.0 3.0     0.0   4.0   53.0 42.0     2.0   0.0     38.0   18.0   95.0 74 7 7   0 3     0   4   53 42     2 0   38 18   95
691089 691089 MN Blue Earth 7 school 2718780 77 Independent Districts and Schools MANKATO PUBLIC SCHOOL DISTRICT 271878000884 80 WASHINGTON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_5 41.0 5.0 3.0   0.0 2.0     0.0   3.0   27.0 27.0     4.0   *     22.0   11.0   54.0 41 5 3   0 2     0   3   27 27     4     22 11   54
691096 691096 MN Blue Earth 7 school 2718780 77 Independent Districts and Schools MANKATO PUBLIC SCHOOL DISTRICT 271878000873 90 FRANKLIN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_5 62.0 9.0 6.0   0.0 1.0     0.0   5.0   39.0 44.0     8.0   2.0     37.0   16.0   83.0 62 9 6   0 1     0   5   39 44     8 2   37 16   83
691103 691103 MN Blue Earth 7 school 2718780 77 Independent Districts and Schools MANKATO PUBLIC SCHOOL DISTRICT 271878000872 150 EAGLE LAKE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_5 58.0 4.0 3.0   0.0 0.0     0.0   0.0   39.0 26.0     0.0   0.0     17.0   11.0   65.0 58 4 3   0 0     0   0   39 26     0 0   17 11   65
695496 695496 MN Blue Earth 7 school 2791445 2071 Independent Districts and Schools LAKE CRYSTAL-WELLCOME MEMORIAL 279144502308 10 Lake Crystal-Wellcome Memorial Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_5 65.0 0.0 1.0   0.0 0.0     0.0   0.0   35.0 31.0     0.0   0.0     15.0   7.0   66.0 65 0 1   0 0     0   0   35 31     0 0   15 7   66
695529 695529 MN Blue Earth 7 school 2700006 2135 Independent Districts and Schools MAPLE RIVER SCHOOL DISTRICT 270000600092 35 MAPLE RIVER WEST ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_5 34.0 0.0 1.0   0.0 0.0     0.0   0.0   20.0 15.0     0.0   0.0     12.0   3.0   35.0 34 0 1   0 0     0   0   20 15     0 0   12 3   35
700486 700486 MN Blue Earth 7 school 2718780 77 Independent Districts and Schools MANKATO PUBLIC SCHOOL DISTRICT 271878004374 370 FUTURES PROGRAM Special Education Special Education School No Other KG 12 2017   grade_5 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
691110 691110 MN Brown 8 school 2709540 81 Independent Districts and Schools COMFREY PUBLIC SCHOOL DISTRICT 270954000403 10 COMFREY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_5 14.0 0.0 0.0   0.0 0.0     0.0   0.0   8.0 6.0     0.0   0.0     8.0   5.0   14.0 14 0 0   0 0     0   0   8 6     0 0   8 5   14
691119 691119 MN Brown 8 school 2733210 84 Independent Districts and Schools SLEEPY EYE PUBLIC SCHOOL DISTRICT 273321001450 10 SLEEPY EYE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_5 29.0 0.0 11.0   0.0 1.0     0.0   0.0   21.0 20.0     1.0   0.0         4.0   41.0 29 0 11   0 1     0   0   21 20     1 0     4   41
691128 691128 MN Brown 8 school 2733390 85 Independent Districts and Schools SPRINGFIELD PUBLIC SCHOOL DISTRICT 273339001470 2 SPRINGFIELD ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_5 32.0 0.0 0.0   0.0 0.0     0.0   0.0   20.0 12.0     0.0   0.0         3.0   32.0 32 0 0   0 0     0   0   20 12     0 0     3   32
697754 697754 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 2017   grade_5 147.0 1.0 9.0   0.0 1.0     0.0   2.0   78.0 82.0     1.0   1.0     53.0   28.0   160.0 147 1 9   0 1     0   2   78 82     1 1   53 28   160
701571 701571 MN Brown 8 school 2791353 6049 Education Districts RIVER BEND EDUCATION DISTRICT 279135304366 35 IMPRINTS PROGRAM Special Education Special Education School No Other 02 12 2017   grade_5 3.0 0.0 1.0   0.0 0.0     0.0   0.0   3.0 1.0         *         *   4.0 3 0 1   0 0     0   0   3 1                 4
691145 691145 MN Carlton 9 school 2703690 91 Independent Districts and Schools BARNUM PUBLIC SCHOOL DISTRICT 270369000171 1 BARNUM ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_5 58.0 0.0 2.0   1.0 0.0     0.0   6.0   39.0 28.0     0.0   0.0     18.0   11.0   67.0 58 0 2   1 0     0   6   39 28     0 0   18 11   67
691154 691154 MN Carlton 9 school 2707590 93 Independent Districts and Schools CARLTON PUBLIC SCHOOL DISTRICT 270759000328 2 SOUTH TERRACE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_5 22.0 0.0 0.0   3.0 0.0     0.0   0.0   13.0 12.0     0.0   0.0     9.0   5.0   25.0 22 0 0   3 0     0   0   13 12     0 0   9 5   25
691161 691161 MN Carlton 9 school 2709420 94 Independent Districts and Schools CLOQUET PUBLIC SCHOOL DISTRICT 270942000380 101 CHURCHILL ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_5 71.0 0.0 2.0   10.0 0.0     0.0   14.0   51.0 46.0         2.0         14.0   97.0 71 0 2   10 0     0   14   51 46       2     14   97
691169 691169 MN Carlton 9 school 2709420 94 Independent Districts and Schools CLOQUET PUBLIC SCHOOL DISTRICT 270942000384 105 WASHINGTON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_5 87.0 1.0 1.0   2.0 0.0     0.0   11.0   56.0 46.0     0.0   *     46.0   21.0   102.0 87 1 1   2 0     0   11   56 46     0     46 21   102
691177 691177 MN Carlton 9 school 2709690 95 Independent Districts and Schools CROMWELL-WRIGHT PUBLIC SCHOOLS 270969000410 10 CROMWELL-WRIGHT ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_5 32.0 1.0 0.0   3.0 1.0     0.0   0.0   18.0 19.0     0.0   0.0     14.0   2.0   37.0 32 1 0   3 1     0   0   18 19     0 0   14 2   37
691186 691186 MN Carlton 9 school 2721450 97 Independent Districts and Schools MOOSE LAKE PUBLIC SCHOOL DISTRICT 272145001093 20 MOOSE LAKE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_5 54.0 0.0 0.0   1.0 0.0     0.0   1.0   25.0 31.0     0.0   2.0     17.0   5.0   56.0 54 0 0   1 0     0   1   25 31     0 2   17 5   56
691195 691195 MN Carlton 9 school 2738880 99 Independent Districts and Schools ESKO PUBLIC SCHOOL DISTRICT 273888001683 30 WINTERQUIST ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_5 104.0 0.0 0.0   1.0 0.0     0.0   2.0   48.0 59.0     0.0   1.0     15.0   14.0   107.0 104 0 0   1 0     0   2   48 59     0 1   15 14   107
691204 691204 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 2017   grade_5 29.0 0.0 0.0   0.0 0.0     0.0   2.0   21.0 10.0     0.0   0.0     8.0   7.0   31.0 29 0 0   0 0     0   2   21 10     0 0   8 7   31
700499 700499 MN Carlton 9 school 2709420 94 Independent Districts and Schools CLOQUET PUBLIC SCHOOL DISTRICT 270942004962 110 CAAEP SETTING 4 Special Education Special Education School No Other 02 12 2017   grade_5 1.0 0.0 0.0   1.0 0.0     0.0   0.0   2.0 0.0         *         *   2.0 1 0 0   1 0     0   0   2 0                 2
691213 691213 MN Carver 10 school 2723910 108 Independent Districts and Schools CENTRAL PUBLIC SCHOOL DISTRICT 272391001187 40 CENTRAL ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_5 62.0 1.0 3.0   0.0 0.0     0.0   2.0   35.0 33.0     1.0   0.0     13.0   8.0   68.0 62 1 3   0 0     0   2   35 33     1 0   13 8   68
691220 691220 MN Carver 10 school 2741460 110 Independent Districts and Schools WACONIA PUBLIC SCHOOL DISTRICT 274146000363 110 SOUTHVIEW ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_5 124.0 4.0 1.0   0.0 1.0     0.0   3.0   71.0 62.0     0.0   0.0     14.0   19.0   133.0 124 4 1   0 1     0   3   71 62     0 0   14 19   133
691227 691227 MN Carver 10 school 2741460 110 Independent Districts and Schools WACONIA PUBLIC SCHOOL DISTRICT 274146003065 120 BAYVIEW ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_5 96.0 1.0 6.0   1.0 2.0     0.0   3.0   71.0 38.0     3.0   0.0     17.0   21.0   109.0 96 1 6   1 2     0   3   71 38     3 0   17 21   109
691234 691234 MN Carver 10 school 2741460 110 Independent Districts and Schools WACONIA PUBLIC SCHOOL DISTRICT 274146004916 130 Laketown Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_5 71.0 0.0 0.0   1.0 0.0     0.0   1.0   32.0 41.0     0.0   0.0     6.0   13.0   73.0 71 0 0   1 0     0   1   32 41     0 0   6 13   73
691243 691243 MN Carver 10 school 2741910 111 Independent Districts and Schools WATERTOWN-MAYER PUBLIC SCHOOL DIST. 274191003674 839 WATERTOWN-MAYER ELEMENTARY SCHOOL Elementary School (Grades PK-6) Regular School No Elementary 01 05 2017   grade_5 104.0 2.0 3.0   0.0 2.0     0.0   0.0   44.0 67.0     2.0   0.0     23.0   8.0   111.0 104 2 3   0 2     0   0   44 67     2 0   23 8   111

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