enrollments

Data source: Big Local News · About: Big Local

942 rows where grade = "grade_5", state = "MN" and year = 2019 sorted by school

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2019 · 942 ✖

grade ✖

  • grade_5 · 942 ✖
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
1956662 1956662 MN Dakota 19 school 2700026 917 Intermediate Districts and Schools INTERMEDIATE SCHOOL DISTRICT 917 270002603897 500 917 DASH Special Education Special Education School No Other PK 12 2019   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
1956613 1956613 MN Dakota 19 school 2700026 917 Intermediate Districts and Schools INTERMEDIATE SCHOOL DISTRICT 917 270002602121 51 917 INTRA-DAKOTA EDUCATIONAL ALT Special Education Special Education School No Other KG 12 2019   grade_5 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
1956639 1956639 MN Dakota 19 school 2700026 917 Intermediate Districts and Schools INTERMEDIATE SCHOOL DISTRICT 917 270002602125 61 917 PACES Special Education Special Education School No Other KG 12 2019   grade_5 2.0 1.0 0.0   0.0 1.0     0.0   0.0   3.0 1.0     *   *         *   4.0 2 1 0   0 1     0   0   3 1                 4
1956652 1956652 MN Dakota 19 school 2700026 917 Intermediate Districts and Schools INTERMEDIATE SCHOOL DISTRICT 917 270002604218 400 917 SUN Special Education Special Education School No Other KG 12 2019   grade_5 4.0 2.0 0.0   1.0 0.0     0.0   0.0   4.0 3.0     *   *         *   7.0 4 2 0   1 0     0   0   4 3                 7
1951346 1951346 MN Meeker 47 school 2700106 2396 Independent Districts and Schools A.C.G.C. Public School District 270010603647 150 ACGC ELEMENTARY GRADES 5 AND 6 Elementary School (Grades PK-6) Regular School No Middle 05 06 2019   grade_5 48.0 0.0 5.0   0.0 0.0     0.0   2.0   23.0 32.0     0.0   0.0     20.0   12.0   55.0 48 0 5   0 0     0   2   23 32     0 0   20 12   55
1952199 1952199 MN Ramsey 62 school 2700118 4018 Charter Schools ACHIEVE LANGUAGE ACADEMY 270011802608 10 ACHIEVE LANGUAGE ACADEMY Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2019   grade_5 7.0 4.0 18.0   0.0 18.0     0.0   1.0   24.0 24.0     9.0   2.0     41.0   9.0   48.0 7 4 18   0 18     0   1   24 24     9 2   41 9   48
1951540 1951540 MN Norman 54 school 2700126 2854 Independent Districts and Schools ADA-BORUP PUBLIC SCHOOL DISTRICT 270012600050 10 ADA ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   grade_5 36.0 0.0 9.0   1.0 0.0     0.0   7.0   21.0 32.0     1.0   0.0     27.0   7.0   53.0 36 0 9   1 0     0   7   21 32     1 0   27 7   53
1945943 1945943 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 2019   grade_5 41.0 18.0 2.0   1.0 7.0     0.0   13.0   42.0 40.0     15.0   3.0     57.0   16.0   82.0 41 18 2   1 7     0   13   42 40     15 3   57 16   82
1949330 1949330 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384001133 410 ADAMS MAGNET ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   grade_5 25.0 15.0 52.0   0.0 0.0     0.0   10.0   49.0 53.0     16.0   2.0     48.0   7.0   102.0 25 15 52   0 0     0   10   49 53     16 2   48 7   102
1948729 1948729 MN Nobles 53 school 2702730 511 Independent Districts and Schools ADRIAN PUBLIC SCHOOL DISTRICT 270273000055 10 ADRIAN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   grade_5 30.0 0.0 5.0   0.0 0.0     0.0   1.0   23.0 13.0     *   0.0     11.0   6.0   36.0 30 0 5   0 0     0   1   23 13       0   11 6   36
1954124 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
1950677 1950677 MN Washington 82 school 2738190 834 Independent Districts and Schools STILLWATER AREA PUBLIC SCHOOL DIST. 273819001654 785 AFTON-LAKELAND ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   grade_5 64.0 2.0 2.0   1.0 3.0     0.0   4.0   29.0 47.0     0.0   0.0     8.0   12.0   76.0 64 2 2   1 3     0   4   29 47     0 0   8 12   76
1946985 1946985 MN Dakota 19 school 2711820 192 Independent Districts and Schools FARMINGTON PUBLIC SCHOOL DISTRICT 271182002205 621 AKIN ROAD ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   grade_5 83.0 4.0 7.0   3.0 7.0     0.0   7.0   64.0 47.0     6.0   0.0     17.0   16.0   111.0 83 4 7   3 7     0   7   64 47     6 0   17 16   111
1950276 1950276 MN Stearns 73 school 2702930 745 Independent Districts and Schools ALBANY PUBLIC SCHOOL DISTRICT 270293000062 10 ALBANY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   grade_5 69.0 0.0 4.0   0.0 0.0     0.0   4.0   32.0 45.0     2.0   1.0     14.0   13.0   77.0 69 0 4   0 0     0   4   32 45     2 1   14 13   77
1947409 1947409 MN Freeborn 24 school 2703030 242 Independent Districts and Schools ALDEN-CONGER PUBLIC SCHOOL DISTRICT 270303000079 2 ALDEN-CONGER ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   grade_5 37.0 0.0 0.0   0.0 0.0     0.0   0.0   17.0 20.0     0.0   0.0     14.0   7.0   37.0 37 0 0   0 0     0   0   17 20     0 0   14 7   37
1947467 1947467 MN Hennepin 27 school 2714260 270 Independent Districts and Schools HOPKINS PUBLIC SCHOOL DISTRICT 271426001886 561 ALICE SMITH ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   grade_5 38.0 23.0 14.0   0.0 0.0     1.0   8.0   48.0 36.0     9.0   1.0     43.0   16.0   84.0 38 23 14   0 0     1   8   48 36     9 1   43 16   84
1949669 1949669 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384002303 579 AMERICAN INDIAN MAGNET SCHOOL Elementary School (Grades PK-6) Regular School No Elementary PK 08 2019   grade_5 2.0 14.0 11.0   10.0 20.0     0.0   10.0   32.0 35.0     23.0   3.0         12.0   67.0 2 14 11   10 20     0   10   32 35     23 3     12   67
1951955 1951955 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_5 1.0 28.0 54.0   2.0 0.0     0.0   1.0   38.0 48.0     56.0   5.0         17.0   86.0 1 28 54   2 0     0   1   38 48     56 5     17   86
1950684 1950684 MN Washington 82 school 2738190 834 Independent Districts and Schools STILLWATER AREA PUBLIC SCHOOL DIST. 273819001655 786 ANDERSEN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   grade_5 36.0 1.0 4.0   0.0 1.0     0.0   1.0   23.0 20.0     0.0   0.0     5.0   *   43.0 36 1 4   0 1     0   1   23 20     0 0   5     43
1946092 1946092 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 2019   grade_5 179.0 7.0 10.0   0.0 12.0     0.0   11.0   115.0 104.0     7.0   0.0     42.0   34.0   219.0 179 7 10   0 12     0   11   115 104     7 0   42 34   219
1949791 1949791 MN Lake of the Woods 39 school 2741850 690 Independent Districts and Schools WARROAD PUBLIC SCHOOL DISTRICT 274185002456 20 ANGLE INLET ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 06 2019   grade_5 0.0 0.0 0.0   1.0 0.0     0.0   0.0   1.0 0.0     *   *         *   1.0 0 0 0   1 0     0   0   1 0                 1
1951986 1951986 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124004172 225 ANISHINABE ACADEMY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   grade_5 0.0 0.0 8.0   24.0 0.0     0.0   4.0   19.0 17.0     0.0   2.0         5.0   36.0 0 0 8   24 0     0   4   19 17     0 2     5   36
1950827 1950827 MN Wright 86 school 2703150 876 Independent Districts and Schools ANNANDALE PUBLIC SCHOOL DISTRICT 270315000094 1 ANNANDALE ELEMENTARY SCHOOL Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   grade_5 144.0 1.0 3.0   0.0 0.0     0.0   12.0   74.0 86.0     0.0   1.0     43.0   27.0   160.0 144 1 3   0 0     0   12   74 86     0 1   43 27   160
1948030 1948030 MN Hennepin 27 school 2733780 283 Independent Districts and Schools ST. LOUIS PARK PUBLIC SCHOOL DIST. 273378001525 745 AQUILA ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   grade_5 41.0 23.0 16.0   0.0 3.0     0.0   12.0   49.0 46.0     8.0   *     46.0   13.0   95.0 41 23 16   0 3     0   12   49 46     8     46 13   95
1951548 1951548 MN Marshall 45 school 2700127 2856 Independent Districts and Schools STEPHEN-ARGYLE CENTRAL SCHOOLS 270012700131 20 ARGYLE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   grade_5 21.0 0.0 1.0   0.0 0.0     0.0   0.0   12.0 10.0     0.0   0.0     8.0   1.0   22.0 21 0 1   0 0     0   0   12 10     0 0   8 1   22
1958017 1958017 MN Washington 82 school 2702264 916 Intermediate Districts and Schools NORTHEAST METRO 916 270226403646 35 ARIS Educational Oversight to Public Care and Treatment Day Program Alternative School No Other KG 12 2019   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
1951751 1951751 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124000938 103 ARMATAGE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   grade_5 67.0 18.0 5.0   0.0 1.0     0.0   5.0   55.0 41.0     7.0   1.0     24.0   10.0   96.0 67 18 5   0 1     0   5   55 41     7 1   24 10   96
1950559 1950559 MN Washington 82 school 2733810 833 Independent Districts and Schools SOUTH WASHINGTON COUNTY SCHOOL DIST 273381001537 30 ARMSTRONG ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   grade_5 34.0 3.0 4.0   0.0 11.0     0.0   4.0   24.0 32.0     3.0   0.0     20.0   10.0   56.0 34 3 4   0 11     0   4   24 32     3 0   20 10   56
1957115 1957115 MN Nicollet 52 school 2700063 6027 Education Districts MN VALLEY EDUCATION DISTRICT 270006304710 40 ASD Program Special Education Special Education School No Other KG 12 2019   grade_5 0.0 0.0 1.0   0.0 0.0     0.0   0.0   1.0 0.0     *   *         *   1.0 0 0 1   0 0     0   0   1 0                 1
1947450 1947450 MN Grant 26 school 2703300 261 Independent Districts and Schools ASHBY PUBLIC SCHOOL DISTRICT 270330000136 10 ASHBY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   grade_5 18.0 0.0 0.0   0.0 0.0     0.0   0.0   8.0 10.0     0.0   0.0         3.0   18.0 18 0 0   0 0     0   0   8 10     0 0     3   18
1952727 1952727 MN Scott 70 school 2700311 4184 Charter Schools ASPEN ACADEMY 270031104282 10 ASPEN ACADEMY Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2019   grade_5 53.0 6.0 1.0   0.0 5.0     0.0   2.0   31.0 36.0     5.0   0.0     16.0   3.0   67.0 53 6 1   0 5     0   2   31 36     5 0   16 3   67
1947223 1947223 MN Dakota 19 school 2715030 199 Independent Districts and Schools INVER GROVE HEIGHTS SCHOOLS 271503003184 574 ATHENEUM ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 02 05 2019   grade_5 15.0 1.0 1.0   0.0 7.0     0.0   0.0   13.0 11.0     0.0   0.0     3.0   2.0   24.0 15 1 1   0 7     0   0   13 11     0 0   3 2   24
1954119 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
1950284 1950284 MN Stearns 73 school 2702930 745 Independent Districts and Schools ALBANY PUBLIC SCHOOL DISTRICT 270293000065 30 AVON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   grade_5 54.0 0.0 2.0   0.0 0.0     0.0   0.0   24.0 32.0     0.0   0.0     8.0   11.0   56.0 54 0 2   0 0     0   0   24 32     0 0   8 11   56
1952357 1952357 MN Ramsey 62 school 2700185 4073 Charter Schools Academia Cesar Chavez Charter School 270018503138 10 Academia Cesar Chavez Charter School Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2019   grade_5 3.0 1.0 53.0   0.0 0.0     0.0   1.0   32.0 26.0     31.0   5.0         6.0   58.0 3 1 53   0 0     0   1   32 26     31 5     6   58
1952916 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
1956851 1956851 MN Rice 66 school 2700424 6094 Special Education Cooperatives Cannon Valley Special Education Cooperative 270042404938 10 Alexander Learning Academy Special Education Special Education School No Other KG 12 2019   grade_5 7.0 0.0 0.0   0.0 0.0     0.0   0.0   6.0 1.0     *   *         *   7.0 7 0 0   0 0     0   0   6 1                 7
1954196 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
1953051 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
1952145 1952145 MN Hennepin 27 school 2700096 4011 Charter Schools Athlos Leadership Academy 270009601892 10 Athlos Leadership Academy Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2019   grade_5 15.0 67.0 12.0   1.0 3.0     0.0   12.0   52.0 58.0     10.0   1.0     79.0   9.0   110.0 15 67 12   1 3     0   12   52 58     10 1   79 9   110
1951032 1951032 MN Saint Louis 69 school 2700008 2142 Independent Districts and Schools ST. LOUIS COUNTY SCHOOL DISTRICT 270000800158 10 BABBITT ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   grade_5 18.0 0.0 1.0   1.0 0.0     1.0   0.0   12.0 9.0     0.0   0.0     10.0   8.0   21.0 18 0 1   1 0     1   0   12 9     0 0   10 8   21
1949765 1949765 MN Roseau 68 school 2703540 676 Independent Districts and Schools BADGER PUBLIC SCHOOL DISTRICT 270354000162 10 BADGER ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   grade_5 14.0 0.0 0.0   0.0 1.0     0.0   1.0   12.0 4.0     0.0   0.0     8.0   3.0   16.0 14 0 0   0 1     0   1   12 4     0 0   8 3   16
1946773 1946773 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_5 56.0 0.0 0.0   11.0 0.0     0.0   6.0   33.0 40.0     0.0   0.0     46.0   11.0   73.0 56 0 0   11 0     0   6   33 40     0 0   46 11   73
1948777 1948777 MN Olmsted 55 school 2731800 535 Independent Districts and Schools ROCHESTER PUBLIC SCHOOL DISTRICT 273180000982 110 BAMBER VALLEY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   grade_5 87.0 10.0 34.0   0.0 10.0     0.0   7.0   78.0 70.0     17.0   3.0     55.0   29.0   148.0 87 10 34   0 10     0   7   78 70     17 3   55 29   148
1951764 1951764 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124000941 105 BANCROFT ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   grade_5 10.0 35.0 15.0   9.0 1.0     0.0   3.0   39.0 34.0     *   0.0     61.0   16.0   73.0 10 35 15   9 1     0   3   39 34       0   61 16   73
1946724 1946724 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_5 61.0 2.0 1.0   0.0 0.0     0.0   5.0   36.0 33.0     0.0   0.0     15.0   4.0   69.0 61 2 1   0 0     0   5   36 33     0 0   15 4   69
1946509 1946509 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 2019   grade_5 58.0 0.0 2.0   0.0 0.0     0.0   3.0   30.0 33.0     0.0   0.0     24.0   6.0   63.0 58 0 2   0 0     0   3   30 33     0 0   24 6   63
1951771 1951771 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_5 45.0 29.0 5.0   0.0 2.0     0.0   0.0   35.0 46.0     10.0   0.0     30.0   7.0   81.0 45 29 5   0 2     0   0   35 46     10 0   30 7   81
1947779 1947779 MN Hennepin 27 school 2725200 279 Independent Districts and Schools OSSEO PUBLIC SCHOOL DISTRICT 272520002523 670 BASSWOOD ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   grade_5 122.0 13.0 3.0   0.0 14.0     0.0   13.0   88.0 77.0     4.0   0.0     18.0   20.0   165.0 122 13 3   0 14     0   13   88 77     4 0   18 20   165
1949347 1949347 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384001555 422 BATTLE CREEK ELEMENTARY SCHOOL Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   grade_5 5.0 22.0 9.0   0.0 24.0     0.0   10.0   47.0 23.0     *   2.0         11.0   70.0 5 22 9   0 24     0   10   47 23       2     11   70
1948907 1948907 MN Otter Tail 56 school 2703750 542 Independent Districts and Schools BATTLE LAKE PUBLIC SCHOOL DISTRICT 270375000175 10 BATTLE LAKE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 06 2019   grade_5 30.0 0.0 0.0   0.0 0.0     0.0   1.0   16.0 15.0     0.0   0.0     12.0   3.0   31.0 30 0 0   0 0     0   1   16 15     0 0   12 3   31
1949848 1949848 MN Saint Louis 69 school 2730090 704 Independent Districts and Schools PROCTOR PUBLIC SCHOOL DISTRICT 273009001557 4 BAY VIEW ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   grade_5 93.0 0.0 4.0   0.0 0.0     0.0   6.0   56.0 47.0     0.0   1.0     39.0   23.0   103.0 93 0 4   0 0     0   6   56 47     0 1   39 23   103
1946588 1946588 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 KG 05 2019   grade_5 101.0 1.0 3.0   1.0 0.0     0.0   5.0   63.0 48.0     0.0   0.0     12.0   23.0   111.0 101 1 3   1 0     0   5   63 48     0 0   12 23   111
1952504 1952504 MN Hennepin 27 school 2700366 4124 Charter Schools BEACON ACADEMY 270036604110 10 BEACON ACADEMY Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2019   grade_5 33.0 14.0 4.0   0.0 1.0     0.0   3.0   25.0 30.0     7.0   0.0     23.0   7.0   55.0 33 14 4   0 1     0   3   25 30     7 0   23 7   55
1957096 1957096 MN Stearns 73 school 2791455 6026 Education Districts WEST CENTRAL EDUCATION DISTRICT 279145503591 24 BEACON PROGRAM W CENTRAL ED. DIST. Special Education Special Education School No Other KG 12 2019   grade_5 5.0 0.0 0.0   0.0 0.0     0.0   0.0   4.0 1.0     *   *         *   5.0 5 0 0   0 0     0   0   4 1                 5
1950077 1950077 MN Sherburne 71 school 2703870 726 Independent Districts and Schools BECKER PUBLIC SCHOOL DISTRICT 270387000179 10 BECKER INTERMEDIATE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 03 05 2019   grade_5 179.0 2.0 11.0   1.0 2.0     0.0   11.0   100.0 106.0     1.0   0.0     45.0   30.0   206.0 179 2 11   1 2     0   11   100 106     1 0   45 30   206
1949081 1949081 MN Ramsey 62 school 2722950 621 Independent Districts and Schools MOUNDS VIEW PUBLIC SCHOOL DISTRICT 272295001114 25 BEL AIR ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 01 05 2019   grade_5 74.0 24.0 16.0   1.0 13.0     0.0   13.0   71.0 70.0     9.0   3.0     58.0   12.0   141.0 74 24 16   1 13     0   13   71 70     9 3   58 12   141
1951329 1951329 MN Stearns 73 school 2700105 2364 Independent Districts and Schools Belgrade-Brooten-Elrosa Public School District 270010500182 1 BELGRADE-BROOTEN-ELROSA ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   grade_5 42.0 0.0 5.0   0.0 0.0     0.0   0.0   25.0 22.0     4.0   2.0     18.0   3.0   47.0 42 0 5   0 0     0   0   25 22     4 2   18 3   47
1949355 1949355 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384001952 424 BENJAMIN E MAYS MAGNET Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   grade_5 0.0 44.0 7.0   0.0 7.0     0.0   8.0   45.0 21.0     *   5.0     55.0   12.0   66.0 0 44 7   0 7     0   8   45 21       5   55 12   66
1957171 1957171 MN Stearns 73 school 2700071 6383 Education Districts BENTON-STEARNS ED. DISTRICT 270007102403 10 BENTON-STEARNS ED. DISTRICT Special Education Special Education School No Other PK 12 2019   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
1951262 1951262 MN Yellow Medicine 87 school 2700099 2190 Independent Districts and Schools YELLOW MEDICINE EAST 270009900676 10 BERT RANEY ELEMENTARY SCHOOL Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   grade_5 45.0 0.0 7.0   9.0 0.0     0.0   2.0   36.0 27.0     2.0   0.0     28.0   17.0   63.0 45 0 7   9 0     0   2   36 27     2 0   28 17   63
1950416 1950416 MN Todd 77 school 2705430 786 Independent Districts and Schools Bertha-Hewitt Public School District 270543000203 10 BERTHA ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   grade_5 36.0 1.0 0.0   0.0 0.0     0.0   2.0   20.0 19.0     0.0   0.0     24.0   7.0   39.0 36 1 0   0 0     0   2   20 19     0 0   24 7   39
1952787 1952787 MN Hennepin 27 school 2700309 4192 Charter Schools BEST ACADEMY 270030904261 10 BEST ACADEMY Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2019   grade_5 0.0 82.0 0.0   0.0 0.0     0.0   2.0   50.0 34.0     30.0   5.0     71.0   14.0   84.0 0 82 0   0 0     0   2   50 34     30 5   71 14   84
1951783 1951783 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124000943 107 BETHUNE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   grade_5 1.0 32.0 1.0   0.0 2.0     0.0   1.0   17.0 20.0     *   2.0         15.0   37.0 1 32 1   0 2     0   1   17 20       2     15   37
1948222 1948222 MN Itasca 31 school 2713170 318 Independent Districts and Schools GRAND RAPIDS PUBLIC SCHOOL DISTRICT 271317000882 115 BIGFORK ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   grade_5 16.0 0.0 1.0   0.0 0.0     0.0   4.0   10.0 11.0     *   *         *   21.0 16 0 1   0 0     0   4   10 11                 21
1952593 1952593 MN Cook 16 school 2700255 4145 Charter Schools BIRCH GROVE COMMUNITY SCHOOL 270025503313 10 BIRCH GROVE COMMUNITY SCHOOL Elementary School (Grades PK-6) Regular School Yes Elementary PK 05 2019   grade_5 4.0 0.0 0.0   0.0 0.0     0.0   0.0   1.0 3.0     *   *         *   4.0 4 0 0   0 0     0   0   1 3                 4
1947788 1947788 MN Hennepin 27 school 2725200 279 Independent Districts and Schools OSSEO PUBLIC SCHOOL DISTRICT 272520001207 671 BIRCH GROVE SCHOOL FOR THE ARTS Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   grade_5 19.0 23.0 10.0   2.0 20.0     0.0   10.0   34.0 50.0     10.0   0.0     47.0   10.0   84.0 19 23 10   2 20     0   10   34 50     10 0   47 10   84
1949276 1949276 MN Ramsey 62 school 2742360 624 Independent Districts and Schools WHITE BEAR LAKE SCHOOL DISTRICT 274236001786 827 BIRCH LAKE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   grade_5 33.0 8.0 5.0   0.0 4.0     0.0   4.0   27.0 27.0     *   0.0     28.0   12.0   54.0 33 8 5   0 4     0   4   27 27       0   28 12   54
1948065 1948065 MN Hennepin 27 school 2742160 284 Independent Districts and Schools WAYZATA PUBLIC SCHOOL DISTRICT 274216001759 804 BIRCHVIEW ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   grade_5 40.0 12.0 6.0   0.0 7.0     0.0   6.0   27.0 44.0     4.0   0.0     19.0   6.0   71.0 40 12 6   0 7     0   6   27 44     4 0   19 6   71
1948784 1948784 MN Olmsted 55 school 2731800 535 Independent Districts and Schools ROCHESTER PUBLIC SCHOOL DISTRICT 273180000984 112 BISHOP ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   grade_5 74.0 7.0 1.0   1.0 4.0     0.0   1.0   45.0 43.0     6.0   0.0     23.0   14.0   88.0 74 7 1   1 4     0   1   45 43     6 0   23 14   88
1946319 1946319 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 2019   grade_5 39.0 0.0 1.0   9.0 0.0     0.0   1.0   25.0 25.0     0.0   0.0     23.0   10.0   50.0 39 0 1   9 0     0   1   25 25     0 0   23 10   50
1950326 1950326 MN Steele 74 school 2705760 756 Independent Districts and Schools BLOOMING PRAIRIE PUBLIC SCHOOL DIST 270576000214 10 BLOOMING PRAIRIE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   grade_5 52.0 0.0 1.0   0.0 0.0     0.0   1.0   24.0 30.0     0.0   1.0     17.0   4.0   54.0 52 0 1   0 0     0   1   24 30     0 1   17 4   54
1946141 1946141 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 2019   grade_5 130.0 11.0 9.0   0.0 13.0     0.0   7.0   84.0 86.0     7.0   0.0     23.0   25.0   170.0 130 11 9   0 13     0   7   84 86     7 0   23 25   170
1946640 1946640 MN Carver 10 school 2708190 112 Independent Districts and Schools EASTERN CARVER COUNTY PUBLIC SCHOOL 270819002509 510 BLUFF CREEK ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   grade_5 81.0 2.0 18.0   0.0 7.0     0.0   5.0   61.0 52.0     8.0   1.0     22.0   20.0   113.0 81 2 18   0 7     0   5   61 52     8 1   22 20   113
1950460 1950460 MN Wabasha 79 school 2717520 813 Independent Districts and Schools LAKE CITY PUBLIC SCHOOL DISTRICT 271752000803 10 BLUFF VIEW ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   grade_5 97.0 0.0 6.0   0.0 0.0     0.0   3.0   60.0 46.0     3.0   0.0     24.0   14.0   106.0 97 0 6   0 0     0   3   60 46     3 0   24 14   106
1952108 1952108 MN Winona 85 school 2705850 4001 Charter Schools BLUFFVIEW MONTESSORI 270585000018 10 BLUFFVIEW MONTESSORI Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2019   grade_5 19.0 0.0 1.0   1.0 0.0     0.0   1.0   9.0 13.0     1.0   0.0     7.0   2.0   22.0 19 0 1   1 0     0   1   9 13     1 0   7 2   22
1951385 1951385 MN Renville 65 school 2705660 2534 Independent Districts and Schools Bird Island-Olivia-Lake Lillian Public School District 270566000144 15 BOLD-BIRD ISLAND ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 06 2019   grade_5 36.0 0.0 13.0   0.0 0.0     0.0   2.0   27.0 24.0     5.0   0.0     24.0   9.0   51.0 36 0 13   0 0     0   2   27 24     5 0   24 9   51
1948187 1948187 MN Isanti 30 school 2706060 314 Independent Districts and Schools BRAHAM PUBLIC SCHOOL DISTRICT 270606000245 2 BRAHAM ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   grade_5 61.0 3.0 2.0   0.0 0.0     0.0   2.0   31.0 37.0     0.0   2.0     32.0   12.0   68.0 61 3 2   0 0     0   2   31 37     0 2   32 12   68
1950760 1950760 MN Wilkin 84 school 2706150 846 Independent Districts and Schools BRECKENRIDGE PUBLIC SCHOOL DISTRICT 270615000266 10 BRECKENRIDGE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   grade_5 39.0 0.0 2.0   2.0 0.0     0.0   4.0   27.0 20.0     0.0   *     19.0   11.0   47.0 39 0 2   2 0     0   4   27 20     0     19 11   47
1956260 1956260 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384002189 430 BRIDGE VIEW SPECIAL EDUCATION Special Education Special Education School No Other KG 12 2019   grade_5 1.0 6.0 2.0   0.0 1.0     0.0   0.0   6.0 4.0     5.0   0.0     8.0   *   10.0 1 6 2   0 1     0   0   6 4     5 0   8     10
1946437 1946437 MN Nicollet 52 school 2718780 77 Independent Districts and Schools MANKATO PUBLIC SCHOOL DISTRICT 271878002977 60 BRIDGES COMMUNITY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   grade_5 17.0 0.0 0.0   0.0 3.0     0.0   2.0   11.0 11.0     0.0   0.0         2.0   22.0 17 0 0   0 3     0   2   11 11     0 0     2   22
1949742 1949742 MN Rice 66 school 2723880 659 Independent Districts and Schools NORTHFIELD PUBLIC SCHOOL DISTRICT 272388002841 7 BRIDGEWATER ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   grade_5 74.0 2.0 10.0   0.0 2.0     0.0   7.0   36.0 59.0     3.0   1.0     30.0   18.0   95.0 74 2 10   0 2     0   7   36 59     3 1   30 18   95
1952774 1952774 MN Hennepin 27 school 2700316 4189 Charter Schools BRIGHT WATER ELEMENTARY 270031604319 10 BRIGHT WATER ELEMENTARY Elementary School (Grades PK-6) Regular School Yes Elementary KG 06 2019   grade_5 10.0 14.0 1.0   1.0 0.0     0.0   1.0   15.0 12.0     0.0   2.0     17.0   8.0   27.0 10 14 1   1 0     0   1   15 12     0 2   17 8   27
1949221 1949221 MN Ramsey 62 school 2732430 623 Independent Districts and Schools ROSEVILLE PUBLIC SCHOOL DISTRICT 273243001386 721 BRIMHALL ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 06 2019   grade_5 48.0 3.0 7.0   0.0 14.0     0.0   2.0   41.0 33.0     3.0   0.0     23.0   7.0   74.0 48 3 7   0 14     0   2   41 33     3 0   23 7   74
1950425 1950425 MN Todd 77 school 2706300 787 Independent Districts and Schools BROWERVILLE PUBLIC SCHOOL DISTRICT 270630000277 10 BROWERVILLE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   grade_5 39.0 0.0 1.0   0.0 0.0     0.0   3.0   22.0 21.0     0.0   0.0     23.0   8.0   43.0 39 0 1   0 0     0   3   22 21     0 0   23 8   43
1953893 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
1949404 1949404 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384001575 449 BRUCE F VENTO ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   grade_5 2.0 26.0 10.0   0.0 39.0     0.0   7.0   48.0 36.0     28.0   5.0         15.0   84.0 2 26 10   0 39     0   7   48 36     28 5     15   84
1952006 1952006 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124001878 249 BRYN MAWR ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   grade_5 6.0 30.0 2.0   3.0 13.0     0.0   0.0   25.0 29.0     5.0   0.0     43.0   12.0   54.0 6 30 2   3 13     0   0   25 29     5 0   43 12   54
1951129 1951129 MN Renville 65 school 2700023 2159 Independent Districts and Schools BUFFALO LK-HECTOR-STEWART PUBLIC SC 270002300288 10 BUFFALO LAKE-HECTOR ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   grade_5 36.0 0.0 4.0   0.0 0.0     0.0   1.0   17.0 24.0     3.0   0.0     16.0   5.0   41.0 36 0 4   0 0     0   1   17 24     3 0   16 5   41
1951790 1951790 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124000945 110 BURROUGHS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   grade_5 97.0 9.0 4.0   0.0 4.0     0.0   3.0   54.0 63.0     1.0   0.0     9.0   11.0   117.0 97 9 4   0 4     0   3   54 63     1 0   9 11   117
1950731 1950731 MN Watonwan 83 school 2707320 836 Independent Districts and Schools BUTTERFIELD PUBLIC SCHOOL DISTRICT 270732000304 10 BUTTERFIELD ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   grade_5 6.0 0.0 8.0   0.0 0.0     0.0   0.0   4.0 10.0     5.0   0.0     10.0   5.0   14.0 6 0 8   0 0     0   0   4 10     5 0   10 5   14
1952182 1952182 MN Hennepin 27 school 2700117 4017 Charter Schools Minnesota Transitions Charter School 270011703566 17 Banaadir Academy Elementary School (Grades PK-6) Regular School Yes Elementary PK 06 2019   grade_5 0.0 24.0 0.0   0.0 0.0     0.0   0.0   12.0 12.0     *   0.0         0.0   24.0 0 24 0   0 0     0   0   12 12       0     0   24
1952190 1952190 MN Hennepin 27 school 2700117 4017 Charter Schools Minnesota Transitions Charter School 270011704989 21 Banaadir South Elementary School (Grades PK-6) Regular School Yes Elementary KG 06 2019   grade_5 0.0 12.0 0.0   0.0 0.0     0.0   0.0   5.0 7.0     8.0   0.0         0.0   12.0 0 12 0   0 0     0   0   5 7     8 0     0   12
1952961 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
1948766 1948766 MN Olmsted 55 school 2738160 534 Independent Districts and Schools STEWARTVILLE PUBLIC SCHOOL DISTRICT 273816001652 10 Bear Cave Intermediate School Elementary School (Grades PK-6) Regular School No Elementary 03 05 2019   grade_5 171.0 0.0 7.0   0.0 2.0     0.0   7.0   102.0 85.0     0.0   1.0     41.0   28.0   187.0 171 0 7   0 2     0   7   102 85     0 1   41 28   187
1951567 1951567 MN Faribault 22 school 2700130 2860 Independent Districts and Schools BLUE EARTH AREA PUBLIC SCHOOL 270013000241 10 Blue Earth Area Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   grade_5 68.0 1.0 15.0   0.0 0.0     0.0   0.0   45.0 39.0     3.0   0.0     34.0   15.0   84.0 68 1 15   0 0     0   0   45 39     3 0   34 15   84
1950712 1950712 MN Washington 82 school 2738190 834 Independent Districts and Schools STILLWATER AREA PUBLIC SCHOOL DIST. 273819005114 797 Brookview Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   grade_5 39.0 14.0 1.0   0.0 4.0     0.0   1.0   27.0 32.0     3.0   0.0     11.0   8.0   59.0 39 14 1   0 4     0   1   27 32     3 0   11 8   59
1948749 1948749 MN Olmsted 55 school 2707350 531 Independent Districts and Schools BYRON PUBLIC SCHOOL DISTRICT 270735000306 10 Byron Intermediate School Elementary School (Grades PK-6) Regular School No Elementary 03 05 2019   grade_5 151.0 2.0 7.0   2.0 2.0     0.0   5.0   79.0 90.0     2.0   0.0     21.0   16.0   169.0 151 2 7   2 2     0   5   79 90     2 0   21 16   169
1946716 1946716 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_5 49.0 1.0 3.0   1.0 1.0     0.0   3.0   29.0 29.0     0.0   0.0     23.0   5.0   58.0 49 1 3   1 1     0   3   29 29     0 0   23 5   58
1948142 1948142 MN Houston 28 school 2707380 299 Independent Districts and Schools CALEDONIA PUBLIC SCHOOL DISTRICT 270738000309 10 CALEDONIA ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   grade_5 41.0 1.0 1.0   0.0 0.0     0.0   1.0   27.0 17.0     0.0   2.0     17.0   7.0   44.0 41 1 1   0 0     0   1   27 17     0 2   17 7   44

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