enrollments

Data source: Big Local News · About: Big Local

13,903 rows where state = "MN" and year = 2019 sorted by school

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2019 · 13,803 ✖
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
1945807 1945807 MN Dakota 19 school 2700361 4119 Charter Schools ACADEMIC ARTS HIGH SCHOOL 270036104105 10 ACADEMIC ARTS HIGH SCHOOL Secondary School (Grades 7-12) Regular School Yes High 09 12 2019   grade_12 18.0 5.0 11.0   4.0 0.0     0.0   0.0   21.0 17.0     0.0   2.0     11.0   12.0   38.0 18 5 11   4 0     0   0   21 17     0 2   11 12   38
1945808 1945808 MN Dakota 19 school 2700361 4119 Charter Schools ACADEMIC ARTS HIGH SCHOOL 270036104105 10 ACADEMIC ARTS HIGH SCHOOL Secondary School (Grades 7-12) Regular School Yes High 09 12 2019   pk_12_total 43.0 7.0 31.0   6.0 0.0     0.0   3.0   41.0 49.0     0.0   4.0     34.0   32.0   90.0 43 7 31   6 0     0   3   41 49     0 4   34 32   90
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
1951347 1951347 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_6 61.0 1.0 6.0   0.0 0.0     0.0   0.0   38.0 30.0     2.0   0.0     35.0   15.0   68.0 61 1 6   0 0     0   0   38 30     2 0   35 15   68
1951348 1951348 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   pk_12_total 109.0 1.0 11.0   0.0 0.0     0.0   2.0   61.0 62.0     2.0   0.0     55.0   27.0   123.0 109 1 11   0 0     0   2   61 62     2 0   55 27   123
1956110 1956110 MN Hennepin 27 school 2725200 279 Independent Districts and Schools OSSEO PUBLIC SCHOOL DISTRICT 272520003593 45 ACHIEVE Special Education Special Education School No Other KG 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
1956111 1956111 MN Hennepin 27 school 2725200 279 Independent Districts and Schools OSSEO PUBLIC SCHOOL DISTRICT 272520003593 45 ACHIEVE Special Education Special Education School No Other KG 12 2019   grade_7 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
1956112 1956112 MN Hennepin 27 school 2725200 279 Independent Districts and Schools OSSEO PUBLIC SCHOOL DISTRICT 272520003593 45 ACHIEVE Special Education Special Education School No Other KG 12 2019   grade_8 0.0 2.0 0.0   0.0 0.0     0.0   1.0   3.0 0.0     *   *         *   3.0 0 2 0   0 0     0   1   3 0                 3
1956113 1956113 MN Hennepin 27 school 2725200 279 Independent Districts and Schools OSSEO PUBLIC SCHOOL DISTRICT 272520003593 45 ACHIEVE Special Education Special Education School No Other KG 12 2019   grade_9 1.0 2.0 0.0   0.0 0.0     0.0   1.0   3.0 1.0     *   *         *   4.0 1 2 0   0 0     0   1   3 1                 4
1956114 1956114 MN Hennepin 27 school 2725200 279 Independent Districts and Schools OSSEO PUBLIC SCHOOL DISTRICT 272520003593 45 ACHIEVE Special Education Special Education School No Other KG 12 2019   grade_10 0.0 2.0 0.0   0.0 0.0     0.0   0.0   0.0 2.0     *   *         *   2.0 0 2 0   0 0     0   0   0 2                 2
1956115 1956115 MN Hennepin 27 school 2725200 279 Independent Districts and Schools OSSEO PUBLIC SCHOOL DISTRICT 272520003593 45 ACHIEVE Special Education Special Education School No Other KG 12 2019   grade_11 1.0 1.0 0.0   0.0 0.0     0.0   0.0   2.0 0.0     *   *         *   2.0 1 1 0   0 0     0   0   2 0                 2
1956116 1956116 MN Hennepin 27 school 2725200 279 Independent Districts and Schools OSSEO PUBLIC SCHOOL DISTRICT 272520003593 45 ACHIEVE Special Education Special Education School No Other KG 12 2019   grade_12 0.0 0.0 1.0   0.0 0.0     0.0   4.0   4.0 1.0     *   *         *   5.0 0 0 1   0 0     0   4   4 1                 5
1956117 1956117 MN Hennepin 27 school 2725200 279 Independent Districts and Schools OSSEO PUBLIC SCHOOL DISTRICT 272520003593 45 ACHIEVE Special Education Special Education School No Other KG 12 2019   pk_12_total 3.0 8.0 1.0   0.0 0.0     0.0   6.0   14.0 4.0     0.0   *         *   18.0 3 8 1   0 0     0   6   14 4     0           18
1952193 1952193 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   pre_kindergarten 0.0 3.0 13.0   0.0 16.0     0.0   3.0   14.0 21.0     0.0   0.0     21.0   0.0   35.0 0 3 13   0 16     0   3   14 21     0 0   21 0   35
1952194 1952194 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   kindergarten 5.0 7.0 16.0   0.0 12.0     3.0   2.0   23.0 22.0     12.0   0.0     36.0   0.0   45.0 5 7 16   0 12     3   2   23 22     12 0   36 0   45
1952195 1952195 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_1 5.0 6.0 21.0   0.0 9.0     0.0   4.0   26.0 19.0     23.0   0.0     40.0   6.0   45.0 5 6 21   0 9     0   4   26 19     23 0   40 6   45
1952196 1952196 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_2 6.0 6.0 18.0   1.0 13.0     0.0   2.0   15.0 31.0     30.0   1.0     40.0   2.0   46.0 6 6 18   1 13     0   2   15 31     30 1   40 2   46
1952197 1952197 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_3 3.0 6.0 25.0   0.0 16.0     0.0   1.0   28.0 23.0     33.0   1.0     40.0   2.0   51.0 3 6 25   0 16     0   1   28 23     33 1   40 2   51
1952198 1952198 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_4 3.0 12.0 21.0   0.0 10.0     0.0   2.0   21.0 27.0     23.0   2.0     41.0   4.0   48.0 3 12 21   0 10     0   2   21 27     23 2   41 4   48
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
1952200 1952200 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_6 5.0 8.0 17.0   0.0 16.0     0.0   1.0   26.0 21.0     14.0   0.0     39.0   5.0   47.0 5 8 17   0 16     0   1   26 21     14 0   39 5   47
1952201 1952201 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_7 5.0 4.0 24.0   0.0 14.0     0.0   1.0   18.0 30.0     17.0   2.0     40.0   9.0   48.0 5 4 24   0 14     0   1   18 30     17 2   40 9   48
1952202 1952202 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_8 3.0 4.0 11.0   0.0 20.0     0.0   1.0   19.0 20.0     21.0   1.0     33.0   6.0   39.0 3 4 11   0 20     0   1   19 20     21 1   33 6   39
1952203 1952203 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   pk_12_total 42.0 60.0 184.0   1.0 144.0     3.0   18.0   214.0 238.0     182.0   9.0     371.0   43.0   452.0 42 60 184   1 144     3   18   214 238     182 9   371 43   452
1951533 1951533 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   early_childhood_special_ed 11.0 0.0 2.0   0.0 0.0     0.0   2.0   10.0 5.0     0.0   1.0     11.0   *   15.0 11 0 2   0 0     0   2   10 5     0 1   11     15
1951534 1951534 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   pre_kindergarten 36.0 0.0 1.0   0.0 0.0     0.0   1.0   23.0 15.0     0.0   0.0     16.0   0.0   38.0 36 0 1   0 0     0   1   23 15     0 0   16 0   38
1951535 1951535 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   kindergarten 37.0 0.0 4.0   0.0 0.0     0.0   4.0   23.0 22.0     0.0   1.0     23.0   10.0   45.0 37 0 4   0 0     0   4   23 22     0 1   23 10   45
1951536 1951536 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_1 29.0 0.0 4.0   1.0 0.0     0.0   6.0   16.0 24.0     0.0   0.0     27.0   7.0   40.0 29 0 4   1 0     0   6   16 24     0 0   27 7   40
1951537 1951537 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_2 29.0 0.0 4.0   0.0 0.0     0.0   4.0   18.0 19.0     1.0   1.0     23.0   7.0   37.0 29 0 4   0 0     0   4   18 19     1 1   23 7   37
1951538 1951538 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_3 34.0 0.0 10.0   0.0 0.0     0.0   3.0   28.0 19.0     4.0   0.0     23.0   10.0   47.0 34 0 10   0 0     0   3   28 19     4 0   23 10   47
1951539 1951539 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_4 29.0 0.0 4.0   1.0 0.0     0.0   2.0   21.0 15.0     1.0   0.0     19.0   5.0   36.0 29 0 4   1 0     0   2   21 15     1 0   19 5   36
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
1951541 1951541 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   pk_12_total 241.0 0.0 38.0   3.0 0.0     0.0   29.0   160.0 151.0     7.0   3.0     169.0   61.0   311.0 241 0 38   3 0     0   29   160 151     7 3   169 61   311
1945575 1945575 MN Norman 54 school 2700126 2854 Independent Districts and Schools ADA-BORUP PUBLIC SCHOOL DISTRICT 270012600051 30 ADA-BORUP SECONDARY Secondary School (Grades 7-12) Regular School No High 06 12 2019   grade_6 47.0 1.0 5.0   0.0 0.0     0.0   6.0   29.0 30.0     1.0   0.0     27.0   8.0   59.0 47 1 5   0 0     0   6   29 30     1 0   27 8   59
1945576 1945576 MN Norman 54 school 2700126 2854 Independent Districts and Schools ADA-BORUP PUBLIC SCHOOL DISTRICT 270012600051 30 ADA-BORUP SECONDARY Secondary School (Grades 7-12) Regular School No High 06 12 2019   grade_7 40.0 0.0 8.0   1.0 2.0     0.0   3.0   31.0 23.0     0.0   0.0     19.0   7.0   54.0 40 0 8   1 2     0   3   31 23     0 0   19 7   54
1945577 1945577 MN Norman 54 school 2700126 2854 Independent Districts and Schools ADA-BORUP PUBLIC SCHOOL DISTRICT 270012600051 30 ADA-BORUP SECONDARY Secondary School (Grades 7-12) Regular School No High 06 12 2019   grade_8 40.0 1.0 8.0   1.0 0.0     0.0   5.0   26.0 29.0     0.0   0.0     26.0   12.0   55.0 40 1 8   1 0     0   5   26 29     0 0   26 12   55
1945578 1945578 MN Norman 54 school 2700126 2854 Independent Districts and Schools ADA-BORUP PUBLIC SCHOOL DISTRICT 270012600051 30 ADA-BORUP SECONDARY Secondary School (Grades 7-12) Regular School No High 06 12 2019   grade_9 46.0 0.0 7.0   0.0 0.0     0.0   3.0   28.0 28.0     1.0   0.0     23.0   9.0   56.0 46 0 7   0 0     0   3   28 28     1 0   23 9   56
1945579 1945579 MN Norman 54 school 2700126 2854 Independent Districts and Schools ADA-BORUP PUBLIC SCHOOL DISTRICT 270012600051 30 ADA-BORUP SECONDARY Secondary School (Grades 7-12) Regular School No High 06 12 2019   grade_10 39.0 0.0 3.0   2.0 0.0     0.0   1.0   22.0 23.0     0.0   2.0     22.0   11.0   45.0 39 0 3   2 0     0   1   22 23     0 2   22 11   45
1945580 1945580 MN Norman 54 school 2700126 2854 Independent Districts and Schools ADA-BORUP PUBLIC SCHOOL DISTRICT 270012600051 30 ADA-BORUP SECONDARY Secondary School (Grades 7-12) Regular School No High 06 12 2019   grade_11 63.0 1.0 9.0   1.0 0.0     0.0   3.0   41.0 36.0     0.0   2.0     38.0   19.0   77.0 63 1 9   1 0     0   3   41 36     0 2   38 19   77
1945581 1945581 MN Norman 54 school 2700126 2854 Independent Districts and Schools ADA-BORUP PUBLIC SCHOOL DISTRICT 270012600051 30 ADA-BORUP SECONDARY Secondary School (Grades 7-12) Regular School No High 06 12 2019   grade_12 45.0 0.0 3.0   1.0 0.0     0.0   3.0   29.0 23.0     0.0   0.0     19.0   9.0   52.0 45 0 3   1 0     0   3   29 23     0 0   19 9   52
1945582 1945582 MN Norman 54 school 2700126 2854 Independent Districts and Schools ADA-BORUP PUBLIC SCHOOL DISTRICT 270012600051 30 ADA-BORUP SECONDARY Secondary School (Grades 7-12) Regular School No High 06 12 2019   pk_12_total 320.0 3.0 43.0   6.0 2.0     0.0   24.0   206.0 192.0     2.0   4.0     174.0   75.0   398.0 320 3 43   6 2     0   24   206 192     2 4   174 75   398
1945937 1945937 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   pre_kindergarten 19.0 4.0 1.0   0.0 8.0     0.0   2.0   12.0 22.0     0.0   0.0     13.0   0.0   34.0 19 4 1   0 8     0   2   12 22     0 0   13 0   34
1945938 1945938 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   kindergarten 43.0 19.0 5.0   0.0 18.0     0.0   11.0   55.0 41.0     27.0   8.0     56.0   17.0   96.0 43 19 5   0 18     0   11   55 41     27 8   56 17   96
1945939 1945939 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_1 28.0 16.0 4.0   0.0 3.0     0.0   10.0   31.0 30.0     17.0   2.0     39.0   12.0   61.0 28 16 4   0 3     0   10   31 30     17 2   39 12   61
1945940 1945940 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_2 48.0 22.0 6.0   0.0 7.0     0.0   9.0   50.0 42.0     19.0   6.0     56.0   20.0   92.0 48 22 6   0 7     0   9   50 42     19 6   56 20   92
1945941 1945941 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_3 39.0 16.0 10.0   2.0 9.0     1.0   4.0   36.0 45.0     27.0   3.0     59.0   14.0   81.0 39 16 10   2 9     1   4   36 45     27 3   59 14   81
1945942 1945942 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_4 42.0 15.0 4.0   1.0 11.0     0.0   5.0   39.0 39.0     14.0   6.0     46.0   20.0   78.0 42 15 4   1 11     0   5   39 39     14 6   46 20   78
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
1945944 1945944 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   pk_12_total 260.0 110.0 32.0   4.0 63.0     1.0   54.0   265.0 259.0     119.0   28.0     326.0   99.0   524.0 260 110 32   4 63     1   54   265 259     119 28   326 99   524
1948910 1948910 MN Otter Tail 56 school 2711880 544 Independent Districts and Schools FERGUS FALLS PUBLIC SCHOOL DISTRICT 271188000571 130 ADAMS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 01 02 2019   grade_1 129.0 3.0 8.0   1.0 4.0     0.0   2.0   83.0 64.0     *   *     59.0   19.0   147.0 129 3 8   1 4     0   2   83 64           59 19   147
1948911 1948911 MN Otter Tail 56 school 2711880 544 Independent Districts and Schools FERGUS FALLS PUBLIC SCHOOL DISTRICT 271188000571 130 ADAMS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 01 02 2019   grade_2 158.0 7.0 2.0   0.0 0.0     2.0   3.0   84.0 88.0     *   *     64.0   7.0   172.0 158 7 2   0 0     2   3   84 88           64 7   172
1948912 1948912 MN Otter Tail 56 school 2711880 544 Independent Districts and Schools FERGUS FALLS PUBLIC SCHOOL DISTRICT 271188000571 130 ADAMS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 01 02 2019   pk_12_total 287.0 10.0 10.0   1.0 4.0     2.0   5.0   167.0 152.0     8.0   0.0     123.0   26.0   319.0 287 10 10   1 4     2   5   167 152     8 0   123 26   319
1949325 1949325 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   kindergarten 43.0 20.0 53.0   0.0 0.0     0.0   9.0   59.0 66.0     23.0   2.0     59.0   9.0   125.0 43 20 53   0 0     0   9   59 66     23 2   59 9   125
1949326 1949326 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_1 19.0 21.0 54.0   1.0 2.0     0.0   11.0   56.0 52.0     29.0   1.0     58.0   7.0   108.0 19 21 54   1 2     0   11   56 52     29 1   58 7   108
1949327 1949327 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_2 28.0 17.0 54.0   0.0 0.0     0.0   8.0   56.0 51.0     28.0   0.0     52.0   8.0   107.0 28 17 54   0 0     0   8   56 51     28 0   52 8   107
1949328 1949328 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_3 28.0 11.0 44.0   0.0 0.0     0.0   5.0   44.0 44.0     20.0   0.0     38.0   5.0   88.0 28 11 44   0 0     0   5   44 44     20 0   38 5   88
1949329 1949329 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_4 20.0 10.0 47.0   1.0 0.0     0.0   8.0   39.0 47.0     20.0   0.0     46.0   5.0   86.0 20 10 47   1 0     0   8   39 47     20 0   46 5   86
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
1949331 1949331 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   pk_12_total 163.0 94.0 304.0   2.0 2.0     0.0   51.0   303.0 313.0     136.0   5.0     301.0   41.0   616.0 163 94 304   2 2     0   51   303 313     136 5   301 41   616
1948723 1948723 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   early_childhood_special_ed 6.0 0.0 0.0   0.0 0.0     0.0   2.0   5.0 3.0     *   *         *   8.0 6 0 0   0 0     0   2   5 3                 8
1948724 1948724 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   kindergarten 33.0 0.0 6.0   0.0 0.0     0.0   3.0   20.0 22.0     4.0   *     14.0   5.0   42.0 33 0 6   0 0     0   3   20 22     4     14 5   42
1948725 1948725 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_1 30.0 0.0 2.0   0.0 2.0     0.0   1.0   17.0 18.0     0.0   0.0     12.0   5.0   35.0 30 0 2   0 2     0   1   17 18     0 0   12 5   35
1948726 1948726 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_2 37.0 0.0 4.0   0.0 0.0     0.0   6.0   20.0 27.0     3.0   0.0     21.0   11.0   47.0 37 0 4   0 0     0   6   20 27     3 0   21 11   47
1948727 1948727 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_3 38.0 0.0 8.0   1.0 2.0     0.0   0.0   20.0 29.0     6.0   0.0     24.0   9.0   49.0 38 0 8   1 2     0   0   20 29     6 0   24 9   49
1948728 1948728 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_4 35.0 0.0 2.0   0.0 0.0     0.0   0.0   20.0 17.0     0.0   0.0         3.0   37.0 35 0 2   0 0     0   0   20 17     0 0     3   37
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
1948730 1948730 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   pk_12_total 209.0 0.0 27.0   1.0 4.0     0.0   13.0   125.0 129.0     15.0   0.0     97.0   47.0   254.0 209 0 27   1 4     0   13   125 129     15 0   97 47   254
1953674 1953674 MN Nobles 53 school 2702730 511 Independent Districts and Schools ADRIAN PUBLIC SCHOOL DISTRICT 270273003076 15 ADRIAN MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_6 26.0 0.0 5.0   0.0 2.0     0.0   2.0   16.0 19.0     2.0   0.0     18.0   7.0   35.0 26 0 5   0 2     0   2   16 19     2 0   18 7   35
1953675 1953675 MN Nobles 53 school 2702730 511 Independent Districts and Schools ADRIAN PUBLIC SCHOOL DISTRICT 270273003076 15 ADRIAN MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_7 39.0 0.0 2.0   0.0 2.0     0.0   1.0   24.0 20.0     1.0   0.0     19.0   5.0   44.0 39 0 2   0 2     0   1   24 20     1 0   19 5   44
1953676 1953676 MN Nobles 53 school 2702730 511 Independent Districts and Schools ADRIAN PUBLIC SCHOOL DISTRICT 270273003076 15 ADRIAN MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2019   grade_8 47.0 1.0 6.0   0.0 1.0     0.0   0.0   30.0 25.0     1.0   0.0     26.0   11.0   55.0 47 1 6   0 1     0   0   30 25     1 0   26 11   55
1953677 1953677 MN Nobles 53 school 2702730 511 Independent Districts and Schools ADRIAN PUBLIC SCHOOL DISTRICT 270273003076 15 ADRIAN MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2019   pk_12_total 112.0 1.0 13.0   0.0 5.0     0.0   3.0   70.0 64.0     4.0   0.0     63.0   23.0   134.0 112 1 13   0 5     0   3   70 64     4 0   63 23   134
1944886 1944886 MN Nobles 53 school 2702730 511 Independent Districts and Schools ADRIAN PUBLIC SCHOOL DISTRICT 270273000056 20 ADRIAN SECONDARY Secondary School (Grades 7-12) Regular School No High 09 12 2019   grade_9 29.0 0.0 13.0   0.0 3.0     0.0   1.0   22.0 24.0     8.0   0.0     22.0   5.0   46.0 29 0 13   0 3     0   1   22 24     8 0   22 5   46
1944887 1944887 MN Nobles 53 school 2702730 511 Independent Districts and Schools ADRIAN PUBLIC SCHOOL DISTRICT 270273000056 20 ADRIAN SECONDARY Secondary School (Grades 7-12) Regular School No High 09 12 2019   grade_10 33.0 0.0 9.0   0.0 1.0     0.0   2.0   21.0 24.0     4.0   0.0     20.0   5.0   45.0 33 0 9   0 1     0   2   21 24     4 0   20 5   45
1944888 1944888 MN Nobles 53 school 2702730 511 Independent Districts and Schools ADRIAN PUBLIC SCHOOL DISTRICT 270273000056 20 ADRIAN SECONDARY Secondary School (Grades 7-12) Regular School No High 09 12 2019   grade_11 40.0 0.0 5.0   1.0 1.0     0.0   1.0   26.0 22.0     1.0   0.0     17.0   4.0   48.0 40 0 5   1 1     0   1   26 22     1 0   17 4   48
1944889 1944889 MN Nobles 53 school 2702730 511 Independent Districts and Schools ADRIAN PUBLIC SCHOOL DISTRICT 270273000056 20 ADRIAN SECONDARY Secondary School (Grades 7-12) Regular School No High 09 12 2019   grade_12 42.0 1.0 3.0   0.0 1.0     0.0   0.0   20.0 27.0     0.0   0.0     12.0   4.0   47.0 42 1 3   0 1     0   0   20 27     0 0   12 4   47
1944890 1944890 MN Nobles 53 school 2702730 511 Independent Districts and Schools ADRIAN PUBLIC SCHOOL DISTRICT 270273000056 20 ADRIAN SECONDARY Secondary School (Grades 7-12) Regular School No High 09 12 2019   pk_12_total 144.0 1.0 30.0   1.0 6.0     0.0   4.0   89.0 97.0     13.0   0.0     71.0   18.0   186.0 144 1 30   1 6     0   4   89 97     13 0   71 18   186
1955492 1955492 MN Hennepin 27 school 2731780 281 Independent Districts and Schools ROBBINSDALE PUBLIC SCHOOL DISTRICT 273178004585 648 ADULT ACADEMICS Public Area Learning Center ALC (State approved) Alternative School No High 09 12 2019   grade_12 3.0 0.0 0.0   0.0 0.0     0.0   0.0   1.0 2.0     *   *         *   3.0 3 0 0   0 0     0   0   1 2                 3
1955493 1955493 MN Hennepin 27 school 2731780 281 Independent Districts and Schools ROBBINSDALE PUBLIC SCHOOL DISTRICT 273178004585 648 ADULT ACADEMICS Public Area Learning Center ALC (State approved) Alternative School No High 09 12 2019   pk_12_total 3.0 0.0 0.0   0.0 0.0     0.0   0.0   1.0 2.0     *   *         *   3.0 3 0 0   0 0     0   0   1 2                 3
1945751 1945751 MN Ramsey 62 school 2700186 4074 Charter Schools AFSA HIGH SCHOOL 270018603139 10 AFSA HIGH SCHOOL Secondary School (Grades 7-12) Regular School Yes High 07 12 2019   grade_7 19.0 6.0 1.0   0.0 4.0     0.0   0.0   21.0 9.0     0.0   0.0     13.0   9.0   30.0 19 6 1   0 4     0   0   21 9     0 0   13 9   30
1945752 1945752 MN Ramsey 62 school 2700186 4074 Charter Schools AFSA HIGH SCHOOL 270018603139 10 AFSA HIGH SCHOOL Secondary School (Grades 7-12) Regular School Yes High 07 12 2019   grade_8 25.0 4.0 4.0   0.0 2.0     0.0   0.0   16.0 19.0     0.0   0.0     15.0   10.0   35.0 25 4 4   0 2     0   0   16 19     0 0   15 10   35
1945753 1945753 MN Ramsey 62 school 2700186 4074 Charter Schools AFSA HIGH SCHOOL 270018603139 10 AFSA HIGH SCHOOL Secondary School (Grades 7-12) Regular School Yes High 07 12 2019   grade_9 52.0 7.0 3.0   0.0 2.0     0.0   3.0   35.0 32.0     0.0   0.0     25.0   13.0   67.0 52 7 3   0 2     0   3   35 32     0 0   25 13   67
1945754 1945754 MN Ramsey 62 school 2700186 4074 Charter Schools AFSA HIGH SCHOOL 270018603139 10 AFSA HIGH SCHOOL Secondary School (Grades 7-12) Regular School Yes High 07 12 2019   grade_10 49.0 1.0 2.0   0.0 2.0     0.0   1.0   37.0 18.0     0.0   0.0     15.0   20.0   55.0 49 1 2   0 2     0   1   37 18     0 0   15 20   55
1945755 1945755 MN Ramsey 62 school 2700186 4074 Charter Schools AFSA HIGH SCHOOL 270018603139 10 AFSA HIGH SCHOOL Secondary School (Grades 7-12) Regular School Yes High 07 12 2019   grade_11 47.0 2.0 2.0   0.0 6.0     0.0   5.0   36.0 26.0     0.0   0.0     17.0   16.0   62.0 47 2 2   0 6     0   5   36 26     0 0   17 16   62
1945756 1945756 MN Ramsey 62 school 2700186 4074 Charter Schools AFSA HIGH SCHOOL 270018603139 10 AFSA HIGH SCHOOL Secondary School (Grades 7-12) Regular School Yes High 07 12 2019   grade_12 37.0 4.0 4.0   0.0 1.0     0.0   1.0   25.0 22.0     0.0   0.0     16.0   16.0   47.0 37 4 4   0 1     0   1   25 22     0 0   16 16   47
1945757 1945757 MN Ramsey 62 school 2700186 4074 Charter Schools AFSA HIGH SCHOOL 270018603139 10 AFSA HIGH SCHOOL Secondary School (Grades 7-12) Regular School Yes High 07 12 2019   pk_12_total 229.0 24.0 16.0   0.0 17.0     0.0   10.0   170.0 126.0     0.0   0.0     101.0   84.0   296.0 229 24 16   0 17     0   10   170 126     0 0   101 84   296
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
1954125 1954125 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_6 18.0 2.0 2.0   0.0 1.0     0.0   0.0   9.0 14.0     0.0   0.0     8.0   3.0   23.0 18 2 2   0 1     0   0   9 14     0 0   8 3   23
1954126 1954126 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   pk_12_total 28.0 2.0 3.0   0.0 1.0     0.0   0.0   14.0 20.0     0.0   0.0     9.0   4.0   34.0 28 2 3   0 1     0   0   14 20     0 0   9 4   34
1955357 1955357 MN Becker 3 school 2710230 22 Independent Districts and Schools DETROIT LAKES PUBLIC SCHOOL DIST. 271023004330 7 AFTERSCHOOL PROGRAM Public Area Learning Center ALC (State approved) Alternative School No High 09 12 2019   grade_10 4.0 0.0 0.0   0.0 0.0     0.0   0.0   3.0 1.0     *   *         *   4.0 4 0 0   0 0     0   0   3 1                 4
1955358 1955358 MN Becker 3 school 2710230 22 Independent Districts and Schools DETROIT LAKES PUBLIC SCHOOL DIST. 271023004330 7 AFTERSCHOOL PROGRAM Public Area Learning Center ALC (State approved) Alternative School No High 09 12 2019   grade_11 2.0 0.0 0.0   1.0 0.0     0.0   0.0   2.0 1.0     *   *         *   3.0 2 0 0   1 0     0   0   2 1                 3
1955359 1955359 MN Becker 3 school 2710230 22 Independent Districts and Schools DETROIT LAKES PUBLIC SCHOOL DIST. 271023004330 7 AFTERSCHOOL PROGRAM Public Area Learning Center ALC (State approved) Alternative School No High 09 12 2019   grade_12 8.0 0.0 1.0   1.0 0.0     0.0   1.0   5.0 6.0     0.0   3.0         2.0   11.0 8 0 1   1 0     0   1   5 6     0 3     2   11
1955360 1955360 MN Becker 3 school 2710230 22 Independent Districts and Schools DETROIT LAKES PUBLIC SCHOOL DIST. 271023004330 7 AFTERSCHOOL PROGRAM Public Area Learning Center ALC (State approved) Alternative School No High 09 12 2019   pk_12_total 14.0 0.0 1.0   2.0 0.0     0.0   1.0   10.0 8.0     0.0   *         5.0   18.0 14 0 1   2 0     0   1   10 8     0       5   18
1950672 1950672 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   kindergarten 68.0 0.0 4.0   0.0 2.0     0.0   1.0   38.0 37.0     1.0   1.0     8.0   4.0   75.0 68 0 4   0 2     0   1   38 37     1 1   8 4   75
1950673 1950673 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_1 64.0 0.0 3.0   0.0 4.0     0.0   1.0   36.0 36.0     *   0.0     8.0   7.0   72.0 64 0 3   0 4     0   1   36 36       0   8 7   72
1950674 1950674 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_2 55.0 0.0 5.0   0.0 5.0     0.0   4.0   32.0 37.0     4.0   0.0     11.0   9.0   69.0 55 0 5   0 5     0   4   32 37     4 0   11 9   69
1950675 1950675 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_3 75.0 1.0 1.0   0.0 4.0     0.0   2.0   39.0 44.0     0.0   0.0         11.0   83.0 75 1 1   0 4     0   2   39 44     0 0     11   83
1950676 1950676 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_4 68.0 0.0 0.0   0.0 1.0     0.0   4.0   34.0 39.0     0.0   0.0         8.0   73.0 68 0 0   0 1     0   4   34 39     0 0     8   73
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
1950678 1950678 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   pk_12_total 394.0 3.0 15.0   1.0 19.0     0.0   16.0   208.0 240.0     6.0   1.0     51.0   51.0   448.0 394 3 15   1 19     0   16   208 240     6 1   51 51   448
1953098 1953098 MN Aitkin 1 school 2702760 1 Independent Districts and Schools AITKIN PUBLIC SCHOOL DISTRICT 270276002789 6 AITKIN ALTERNATIVE LEARNING PROGRAM Public Area Learning Program ALP (State approved) Alternative School No High 07 12 2019   grade_10 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

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