enrollments

Data source: Big Local News · About: Big Local

13,757 rows where state = "MN" and year = 2017 sorted by county descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2017 · 13,757 ✖
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
689946 689946 MN Yellow Medicine 87 school 2707470 891 Independent Districts and Schools CANBY PUBLIC SCHOOL DISTRICT 270747000322 10 CANBY SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   grade_7 52.0 1.0 2.0   0.0 1.0     0.0   0.0   25.0 31.0     0.0   0.0     15.0   10.0   56.0 52 1 2   0 1     0   0   25 31     0 0   15 10   56
689947 689947 MN Yellow Medicine 87 school 2707470 891 Independent Districts and Schools CANBY PUBLIC SCHOOL DISTRICT 270747000322 10 CANBY SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   grade_8 36.0 1.0 1.0   0.0 0.0     0.0   0.0   20.0 18.0     0.0   0.0     15.0   4.0   38.0 36 1 1   0 0     0   0   20 18     0 0   15 4   38
689948 689948 MN Yellow Medicine 87 school 2707470 891 Independent Districts and Schools CANBY PUBLIC SCHOOL DISTRICT 270747000322 10 CANBY SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   grade_9 35.0 0.0 1.0   0.0 0.0     0.0   0.0   25.0 11.0     0.0   0.0     9.0   3.0   36.0 35 0 1   0 0     0   0   25 11     0 0   9 3   36
689949 689949 MN Yellow Medicine 87 school 2707470 891 Independent Districts and Schools CANBY PUBLIC SCHOOL DISTRICT 270747000322 10 CANBY SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   grade_10 49.0 0.0 1.0   0.0 0.0     0.0   0.0   31.0 19.0     0.0   0.0     12.0   9.0   50.0 49 0 1   0 0     0   0   31 19     0 0   12 9   50
689950 689950 MN Yellow Medicine 87 school 2707470 891 Independent Districts and Schools CANBY PUBLIC SCHOOL DISTRICT 270747000322 10 CANBY SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   grade_11 48.0 0.0 0.0   0.0 0.0     0.0   0.0   22.0 26.0     1.0   0.0     10.0   5.0   48.0 48 0 0   0 0     0   0   22 26     1 0   10 5   48
689951 689951 MN Yellow Medicine 87 school 2707470 891 Independent Districts and Schools CANBY PUBLIC SCHOOL DISTRICT 270747000322 10 CANBY SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   grade_12 32.0 0.0 0.0   0.0 0.0     0.0   0.0   15.0 17.0     0.0   0.0     9.0   3.0   32.0 32 0 0   0 0     0   0   15 17     0 0   9 3   32
689952 689952 MN Yellow Medicine 87 school 2707470 891 Independent Districts and Schools CANBY PUBLIC SCHOOL DISTRICT 270747000322 10 CANBY SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   pk_12_total 252.0 2.0 5.0   0.0 1.0     0.0   0.0   138.0 122.0     1.0   0.0     70.0   34.0   260.0 252 2 5   0 1     0   0   138 122     1 0   70 34   260
695438 695438 MN Yellow Medicine 87 school 2707470 891 Independent Districts and Schools CANBY PUBLIC SCHOOL DISTRICT 270747000321 20 CANBY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   early_childhood_special_ed 10.0 0.0 2.0   0.0 0.0     0.0   1.0   10.0 3.0     0.0   0.0     6.0   *   13.0 10 0 2   0 0     0   1   10 3     0 0   6     13
695439 695439 MN Yellow Medicine 87 school 2707470 891 Independent Districts and Schools CANBY PUBLIC SCHOOL DISTRICT 270747000321 20 CANBY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   kindergarten 33.0 3.0 1.0   0.0 0.0     0.0   4.0   14.0 27.0     0.0   0.0     21.0   6.0   41.0 33 3 1   0 0     0   4   14 27     0 0   21 6   41
695440 695440 MN Yellow Medicine 87 school 2707470 891 Independent Districts and Schools CANBY PUBLIC SCHOOL DISTRICT 270747000321 20 CANBY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_1 29.0 0.0 0.0   0.0 0.0     0.0   1.0   12.0 18.0     0.0   0.0     8.0   4.0   30.0 29 0 0   0 0     0   1   12 18     0 0   8 4   30
695441 695441 MN Yellow Medicine 87 school 2707470 891 Independent Districts and Schools CANBY PUBLIC SCHOOL DISTRICT 270747000321 20 CANBY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_2 32.0 0.0 3.0   0.0 0.0     0.0   1.0   18.0 18.0     0.0   0.0     22.0   6.0   36.0 32 0 3   0 0     0   1   18 18     0 0   22 6   36
695442 695442 MN Yellow Medicine 87 school 2707470 891 Independent Districts and Schools CANBY PUBLIC SCHOOL DISTRICT 270747000321 20 CANBY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_3 47.0 1.0 2.0   0.0 0.0     0.0   0.0   20.0 30.0     0.0   0.0     18.0   9.0   50.0 47 1 2   0 0     0   0   20 30     0 0   18 9   50
695443 695443 MN Yellow Medicine 87 school 2707470 891 Independent Districts and Schools CANBY PUBLIC SCHOOL DISTRICT 270747000321 20 CANBY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_4 29.0 0.0 3.0   0.0 1.0     0.0   0.0   12.0 21.0     0.0   0.0     15.0   7.0   33.0 29 0 3   0 1     0   0   12 21     0 0   15 7   33
695444 695444 MN Yellow Medicine 87 school 2707470 891 Independent Districts and Schools CANBY PUBLIC SCHOOL DISTRICT 270747000321 20 CANBY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_5 35.0 0.0 1.0   0.0 0.0     0.0   1.0   21.0 16.0     0.0   0.0     12.0   8.0   37.0 35 0 1   0 0     0   1   21 16     0 0   12 8   37
695445 695445 MN Yellow Medicine 87 school 2707470 891 Independent Districts and Schools CANBY PUBLIC SCHOOL DISTRICT 270747000321 20 CANBY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_6 34.0 0.0 1.0   0.0 0.0     0.0   0.0   16.0 19.0     0.0   0.0     14.0   4.0   35.0 34 0 1   0 0     0   0   16 19     0 0   14 4   35
695446 695446 MN Yellow Medicine 87 school 2707470 891 Independent Districts and Schools CANBY PUBLIC SCHOOL DISTRICT 270747000321 20 CANBY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   pk_12_total 249.0 4.0 13.0   0.0 1.0     0.0   8.0   123.0 152.0     0.0   0.0     116.0   57.0   275.0 249 4 13   0 1     0   8   123 152     0 0   116 57   275
695766 695766 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 2017   early_childhood_special_ed 15.0 0.0 0.0   2.0 0.0     0.0   0.0   8.0 9.0     0.0   0.0     7.0   *   17.0 15 0 0   2 0     0   0   8 9     0 0   7     17
695767 695767 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 2017   kindergarten 29.0 0.0 6.0   7.0 1.0     0.0   1.0   25.0 19.0     0.0   0.0     24.0   9.0   44.0 29 0 6   7 1     0   1   25 19     0 0   24 9   44
695768 695768 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 2017   grade_1 41.0 1.0 7.0   7.0 1.0     0.0   0.0   37.0 20.0     0.0   0.0     23.0   10.0   57.0 41 1 7   7 1     0   0   37 20     0 0   23 10   57
695769 695769 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 2017   grade_2 35.0 0.0 4.0   9.0 1.0     0.0   2.0   21.0 30.0     1.0   0.0     20.0   10.0   51.0 35 0 4   9 1     0   2   21 30     1 0   20 10   51
695770 695770 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 2017   grade_3 46.0 0.0 7.0   11.0 0.0     0.0   2.0   37.0 29.0     1.0   0.0     31.0   17.0   66.0 46 0 7   11 0     0   2   37 29     1 0   31 17   66
695771 695771 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 2017   grade_4 34.0 1.0 7.0   11.0 2.0     0.0   0.0   26.0 29.0     2.0   0.0     25.0   14.0   55.0 34 1 7   11 2     0   0   26 29     2 0   25 14   55
695772 695772 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 2017   grade_5 29.0 0.0 7.0   12.0 1.0     0.0   3.0   27.0 25.0     1.0   0.0     25.0   8.0   52.0 29 0 7   12 1     0   3   27 25     1 0   25 8   52
695773 695773 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 2017   pk_12_total 229.0 2.0 38.0   59.0 6.0     0.0   8.0   181.0 161.0     5.0   0.0     155.0   85.0   342.0 229 2 38   59 6     0   8   181 161     5 0   155 85   342
697233 697233 MN Yellow Medicine 87 school 2700290 4172 Charter Schools CLARKFIELD CHARTER SCHOOL 270029003726 10 CLARKFIELD CHARTER SCHOOL Elementary School (Grades PK-6) Regular School Yes Elementary KG 06 2017   kindergarten 10.0 0.0 1.0   0.0 0.0     0.0   1.0   1.0 11.0     0.0   0.0     7.0   0.0   12.0 10 0 1   0 0     0   1   1 11     0 0   7 0   12
697234 697234 MN Yellow Medicine 87 school 2700290 4172 Charter Schools CLARKFIELD CHARTER SCHOOL 270029003726 10 CLARKFIELD CHARTER SCHOOL Elementary School (Grades PK-6) Regular School Yes Elementary KG 06 2017   grade_1 6.0 0.0 0.0   0.0 0.0     0.0   0.0   2.0 4.0         *         *   6.0 6 0 0   0 0     0   0   2 4                 6
697235 697235 MN Yellow Medicine 87 school 2700290 4172 Charter Schools CLARKFIELD CHARTER SCHOOL 270029003726 10 CLARKFIELD CHARTER SCHOOL Elementary School (Grades PK-6) Regular School Yes Elementary KG 06 2017   grade_2 11.0 0.0 2.0   1.0 0.0     0.0   0.0   9.0 5.0     0.0   0.0     7.0   2.0   14.0 11 0 2   1 0     0   0   9 5     0 0   7 2   14
697236 697236 MN Yellow Medicine 87 school 2700290 4172 Charter Schools CLARKFIELD CHARTER SCHOOL 270029003726 10 CLARKFIELD CHARTER SCHOOL Elementary School (Grades PK-6) Regular School Yes Elementary KG 06 2017   grade_3 5.0 0.0 2.0   0.0 0.0     0.0   0.0   4.0 3.0         *         *   7.0 5 0 2   0 0     0   0   4 3                 7
697237 697237 MN Yellow Medicine 87 school 2700290 4172 Charter Schools CLARKFIELD CHARTER SCHOOL 270029003726 10 CLARKFIELD CHARTER SCHOOL Elementary School (Grades PK-6) Regular School Yes Elementary KG 06 2017   grade_4 3.0 0.0 0.0   0.0 0.0     0.0   0.0   3.0 0.0         *         *   3.0 3 0 0   0 0     0   0   3 0                 3
697238 697238 MN Yellow Medicine 87 school 2700290 4172 Charter Schools CLARKFIELD CHARTER SCHOOL 270029003726 10 CLARKFIELD CHARTER SCHOOL Elementary School (Grades PK-6) Regular School Yes Elementary KG 06 2017   grade_5 8.0 0.0 1.0   0.0 0.0     0.0   0.0   4.0 5.0         *         *   9.0 8 0 1   0 0     0   0   4 5                 9
697239 697239 MN Yellow Medicine 87 school 2700290 4172 Charter Schools CLARKFIELD CHARTER SCHOOL 270029003726 10 CLARKFIELD CHARTER SCHOOL Elementary School (Grades PK-6) Regular School Yes Elementary KG 06 2017   grade_6 2.0 0.0 0.0   0.0 0.0     0.0   0.0   1.0 1.0         *         *   2.0 2 0 0   0 0     0   0   1 1                 2
697240 697240 MN Yellow Medicine 87 school 2700290 4172 Charter Schools CLARKFIELD CHARTER SCHOOL 270029003726 10 CLARKFIELD CHARTER SCHOOL Elementary School (Grades PK-6) Regular School Yes Elementary KG 06 2017   pk_12_total 45.0 0.0 6.0   1.0 0.0     0.0   1.0   24.0 29.0     0.0   0.0     29.0   7.0   53.0 45 0 6   1 0     0   1   24 29     0 0   29 7   53
698430 698430 MN Yellow Medicine 87 school 2700099 2190 Independent Districts and Schools YELLOW MEDICINE EAST 270009904609 23 YELLOW MEDICINE EAST MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_6 41.0 0.0 7.0   11.0 2.0     0.0   2.0   30.0 33.0     1.0   0.0     25.0   11.0   63.0 41 0 7   11 2     0   2   30 33     1 0   25 11   63
698431 698431 MN Yellow Medicine 87 school 2700099 2190 Independent Districts and Schools YELLOW MEDICINE EAST 270009904609 23 YELLOW MEDICINE EAST MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_7 40.0 2.0 6.0   12.0 0.0     0.0   0.0   30.0 30.0     0.0   0.0     27.0   12.0   60.0 40 2 6   12 0     0   0   30 30     0 0   27 12   60
698432 698432 MN Yellow Medicine 87 school 2700099 2190 Independent Districts and Schools YELLOW MEDICINE EAST 270009904609 23 YELLOW MEDICINE EAST MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_8 37.0 1.0 9.0   12.0 0.0     0.0   0.0   34.0 25.0     2.0   0.0     26.0   10.0   59.0 37 1 9   12 0     0   0   34 25     2 0   26 10   59
698433 698433 MN Yellow Medicine 87 school 2700099 2190 Independent Districts and Schools YELLOW MEDICINE EAST 270009904609 23 YELLOW MEDICINE EAST MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 06 08 2017   pk_12_total 118.0 3.0 22.0   35.0 2.0     0.0   2.0   94.0 88.0     3.0   0.0     78.0   33.0   182.0 118 3 22   35 2     0   2   94 88     3 0   78 33   182
699427 699427 MN Yellow Medicine 87 school 2700099 2190 Independent Districts and Schools YELLOW MEDICINE EAST 270009903539 22 YELLOW MEDICINE EAST HIGH SCHOOL Senior High School (Grades 9-12) Regular School No High 09 12 2017   grade_9 30.0 1.0 7.0   7.0 2.0     0.0   0.0   25.0 22.0     4.0   0.0     23.0   10.0   47.0 30 1 7   7 2     0   0   25 22     4 0   23 10   47
699428 699428 MN Yellow Medicine 87 school 2700099 2190 Independent Districts and Schools YELLOW MEDICINE EAST 270009903539 22 YELLOW MEDICINE EAST HIGH SCHOOL Senior High School (Grades 9-12) Regular School No High 09 12 2017   grade_10 39.0 0.0 7.0   7.0 1.0     0.0   0.0   26.0 28.0     3.0   0.0     20.0   7.0   54.0 39 0 7   7 1     0   0   26 28     3 0   20 7   54
699429 699429 MN Yellow Medicine 87 school 2700099 2190 Independent Districts and Schools YELLOW MEDICINE EAST 270009903539 22 YELLOW MEDICINE EAST HIGH SCHOOL Senior High School (Grades 9-12) Regular School No High 09 12 2017   grade_11 50.0 0.0 3.0   10.0 1.0     0.0   0.0   33.0 31.0     1.0   0.0     24.0   9.0   64.0 50 0 3   10 1     0   0   33 31     1 0   24 9   64
699430 699430 MN Yellow Medicine 87 school 2700099 2190 Independent Districts and Schools YELLOW MEDICINE EAST 270009903539 22 YELLOW MEDICINE EAST HIGH SCHOOL Senior High School (Grades 9-12) Regular School No High 09 12 2017   grade_12 50.0 0.0 3.0   2.0 0.0     0.0   0.0   32.0 23.0     0.0   0.0     12.0   7.0   55.0 50 0 3   2 0     0   0   32 23     0 0   12 7   55
699431 699431 MN Yellow Medicine 87 school 2700099 2190 Independent Districts and Schools YELLOW MEDICINE EAST 270009903539 22 YELLOW MEDICINE EAST HIGH SCHOOL Senior High School (Grades 9-12) Regular School No High 09 12 2017   pk_12_total 169.0 1.0 20.0   26.0 4.0     0.0   0.0   116.0 104.0     8.0   0.0     79.0   33.0   220.0 169 1 20   26 4     0   0   116 104     8 0   79 33   220
702726 702726 MN Yellow Medicine 87 school 2700139 4026 Charter Schools E.C.H.O. CHARTER SCHOOL 270013902718 10 E.C.H.O. CHARTER SCHOOL Elementary/Secondary Combined (Grades K-12 limited to District Type 34 Bureau of Indian Education) Regular School Yes Other KG 12 2017   kindergarten 3.0 0.0 0.0   1.0 0.0     0.0   0.0   1.0 3.0         *         *   4.0 3 0 0   1 0     0   0   1 3                 4
702727 702727 MN Yellow Medicine 87 school 2700139 4026 Charter Schools E.C.H.O. CHARTER SCHOOL 270013902718 10 E.C.H.O. CHARTER SCHOOL Elementary/Secondary Combined (Grades K-12 limited to District Type 34 Bureau of Indian Education) Regular School Yes Other KG 12 2017   grade_1 5.0 0.0 0.0   0.0 0.0     0.0   2.0   3.0 4.0         *         *   7.0 5 0 0   0 0     0   2   3 4                 7
702728 702728 MN Yellow Medicine 87 school 2700139 4026 Charter Schools E.C.H.O. CHARTER SCHOOL 270013902718 10 E.C.H.O. CHARTER SCHOOL Elementary/Secondary Combined (Grades K-12 limited to District Type 34 Bureau of Indian Education) Regular School Yes Other KG 12 2017   grade_2 4.0 0.0 0.0   0.0 0.0     0.0   0.0   2.0 2.0         *         *   4.0 4 0 0   0 0     0   0   2 2                 4
702729 702729 MN Yellow Medicine 87 school 2700139 4026 Charter Schools E.C.H.O. CHARTER SCHOOL 270013902718 10 E.C.H.O. CHARTER SCHOOL Elementary/Secondary Combined (Grades K-12 limited to District Type 34 Bureau of Indian Education) Regular School Yes Other KG 12 2017   grade_3 4.0 0.0 0.0   1.0 0.0     0.0   1.0   2.0 4.0         *         *   6.0 4 0 0   1 0     0   1   2 4                 6
702730 702730 MN Yellow Medicine 87 school 2700139 4026 Charter Schools E.C.H.O. CHARTER SCHOOL 270013902718 10 E.C.H.O. CHARTER SCHOOL Elementary/Secondary Combined (Grades K-12 limited to District Type 34 Bureau of Indian Education) Regular School Yes Other KG 12 2017   grade_4 5.0 0.0 0.0   1.0 0.0     0.0   0.0   2.0 4.0         *         *   6.0 5 0 0   1 0     0   0   2 4                 6
702731 702731 MN Yellow Medicine 87 school 2700139 4026 Charter Schools E.C.H.O. CHARTER SCHOOL 270013902718 10 E.C.H.O. CHARTER SCHOOL Elementary/Secondary Combined (Grades K-12 limited to District Type 34 Bureau of Indian Education) Regular School Yes Other KG 12 2017   grade_5 3.0 0.0 1.0   0.0 0.0     0.0   4.0   4.0 4.0         *         *   8.0 3 0 1   0 0     0   4   4 4                 8
702732 702732 MN Yellow Medicine 87 school 2700139 4026 Charter Schools E.C.H.O. CHARTER SCHOOL 270013902718 10 E.C.H.O. CHARTER SCHOOL Elementary/Secondary Combined (Grades K-12 limited to District Type 34 Bureau of Indian Education) Regular School Yes Other KG 12 2017   grade_6 6.0 1.0 0.0   0.0 0.0     0.0   1.0   4.0 4.0         *         *   8.0 6 1 0   0 0     0   1   4 4                 8
702733 702733 MN Yellow Medicine 87 school 2700139 4026 Charter Schools E.C.H.O. CHARTER SCHOOL 270013902718 10 E.C.H.O. CHARTER SCHOOL Elementary/Secondary Combined (Grades K-12 limited to District Type 34 Bureau of Indian Education) Regular School Yes Other KG 12 2017   grade_7 8.0 0.0 1.0   0.0 0.0     0.0   1.0   5.0 5.0     0.0   0.0     5.0   2.0   10.0 8 0 1   0 0     0   1   5 5     0 0   5 2   10
702734 702734 MN Yellow Medicine 87 school 2700139 4026 Charter Schools E.C.H.O. CHARTER SCHOOL 270013902718 10 E.C.H.O. CHARTER SCHOOL Elementary/Secondary Combined (Grades K-12 limited to District Type 34 Bureau of Indian Education) Regular School Yes Other KG 12 2017   grade_8 6.0 0.0 1.0   0.0 0.0     0.0   0.0   5.0 2.0         *         *   7.0 6 0 1   0 0     0   0   5 2                 7
702735 702735 MN Yellow Medicine 87 school 2700139 4026 Charter Schools E.C.H.O. CHARTER SCHOOL 270013902718 10 E.C.H.O. CHARTER SCHOOL Elementary/Secondary Combined (Grades K-12 limited to District Type 34 Bureau of Indian Education) Regular School Yes Other KG 12 2017   grade_9 6.0 0.0 0.0   1.0 0.0     0.0   1.0   3.0 5.0         *         *   8.0 6 0 0   1 0     0   1   3 5                 8
702736 702736 MN Yellow Medicine 87 school 2700139 4026 Charter Schools E.C.H.O. CHARTER SCHOOL 270013902718 10 E.C.H.O. CHARTER SCHOOL Elementary/Secondary Combined (Grades K-12 limited to District Type 34 Bureau of Indian Education) Regular School Yes Other KG 12 2017   grade_10 7.0 0.0 0.0   1.0 1.0     0.0   1.0   6.0 4.0     0.0   0.0     5.0   1.0   10.0 7 0 0   1 1     0   1   6 4     0 0   5 1   10
702737 702737 MN Yellow Medicine 87 school 2700139 4026 Charter Schools E.C.H.O. CHARTER SCHOOL 270013902718 10 E.C.H.O. CHARTER SCHOOL Elementary/Secondary Combined (Grades K-12 limited to District Type 34 Bureau of Indian Education) Regular School Yes Other KG 12 2017   grade_11 9.0 0.0 1.0   2.0 0.0     0.0   3.0   9.0 6.0     0.0   0.0     7.0   4.0   15.0 9 0 1   2 0     0   3   9 6     0 0   7 4   15
702738 702738 MN Yellow Medicine 87 school 2700139 4026 Charter Schools E.C.H.O. CHARTER SCHOOL 270013902718 10 E.C.H.O. CHARTER SCHOOL Elementary/Secondary Combined (Grades K-12 limited to District Type 34 Bureau of Indian Education) Regular School Yes Other KG 12 2017   grade_12 11.0 0.0 2.0   0.0 0.0     0.0   0.0   8.0 5.0     0.0   0.0     5.0   4.0   13.0 11 0 2   0 0     0   0   8 5     0 0   5 4   13
702739 702739 MN Yellow Medicine 87 school 2700139 4026 Charter Schools E.C.H.O. CHARTER SCHOOL 270013902718 10 E.C.H.O. CHARTER SCHOOL Elementary/Secondary Combined (Grades K-12 limited to District Type 34 Bureau of Indian Education) Regular School Yes Other KG 12 2017   pk_12_total 77.0 1.0 6.0   7.0 1.0     0.0   14.0   54.0 52.0     0.0   0.0     65.0   24.0   106.0 77 1 6   7 1     0   14   54 52     0 0   65 24   106
689939 689939 MN Wright 86 school 2718810 881 Independent Districts and Schools MAPLE LAKE PUBLIC SCHOOL DISTRICT 271881000886 20 MAPLE LAKE SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   grade_7 79.0 1.0 0.0   0.0 0.0     0.0   3.0   35.0 48.0     0.0   0.0     20.0   15.0   83.0 79 1 0   0 0     0   3   35 48     0 0   20 15   83
689940 689940 MN Wright 86 school 2718810 881 Independent Districts and Schools MAPLE LAKE PUBLIC SCHOOL DISTRICT 271881000886 20 MAPLE LAKE SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   grade_8 70.0 0.0 0.0   0.0 0.0     0.0   2.0   35.0 37.0     0.0   0.0     13.0   11.0   72.0 70 0 0   0 0     0   2   35 37     0 0   13 11   72
689941 689941 MN Wright 86 school 2718810 881 Independent Districts and Schools MAPLE LAKE PUBLIC SCHOOL DISTRICT 271881000886 20 MAPLE LAKE SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   grade_9 65.0 2.0 1.0   0.0 0.0     1.0   0.0   34.0 35.0     0.0   0.0     11.0   7.0   69.0 65 2 1   0 0     1   0   34 35     0 0   11 7   69
689942 689942 MN Wright 86 school 2718810 881 Independent Districts and Schools MAPLE LAKE PUBLIC SCHOOL DISTRICT 271881000886 20 MAPLE LAKE SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   grade_10 73.0 0.0 0.0   1.0 0.0     1.0   2.0   40.0 37.0     0.0   0.0     16.0   15.0   77.0 73 0 0   1 0     1   2   40 37     0 0   16 15   77
689943 689943 MN Wright 86 school 2718810 881 Independent Districts and Schools MAPLE LAKE PUBLIC SCHOOL DISTRICT 271881000886 20 MAPLE LAKE SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   grade_11 76.0 0.0 0.0   0.0 1.0     1.0   1.0   40.0 39.0     0.0   0.0     13.0   9.0   79.0 76 0 0   0 1     1   1   40 39     0 0   13 9   79
689944 689944 MN Wright 86 school 2718810 881 Independent Districts and Schools MAPLE LAKE PUBLIC SCHOOL DISTRICT 271881000886 20 MAPLE LAKE SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   grade_12 70.0 0.0 0.0   0.0 0.0     2.0   1.0   39.0 34.0     0.0   0.0     14.0   9.0   73.0 70 0 0   0 0     2   1   39 34     0 0   14 9   73
689945 689945 MN Wright 86 school 2718810 881 Independent Districts and Schools MAPLE LAKE PUBLIC SCHOOL DISTRICT 271881000886 20 MAPLE LAKE SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   pk_12_total 433.0 3.0 1.0   1.0 1.0     5.0   9.0   223.0 230.0     0.0   0.0     87.0   66.0   453.0 433 3 1   1 1     5   9   223 230     0 0   87 66   453
690446 690446 MN Wright 86 school 2700360 4118 Charter Schools KALEIDOSCOPE CHARTER SCHOOL 270036004668 20 Kaleidoscope Charter Secondary School Secondary School (Grades 7-12) Regular School Yes Other 06 12 2017   grade_6 33.0 1.0 0.0   0.0 0.0     0.0   0.0   16.0 18.0     0.0   0.0     9.0   12.0   34.0 33 1 0   0 0     0   0   16 18     0 0   9 12   34
690447 690447 MN Wright 86 school 2700360 4118 Charter Schools KALEIDOSCOPE CHARTER SCHOOL 270036004668 20 Kaleidoscope Charter Secondary School Secondary School (Grades 7-12) Regular School Yes Other 06 12 2017   grade_7 33.0 2.0 4.0   0.0 0.0     0.0   1.0   18.0 22.0     0.0   0.0     12.0   11.0   40.0 33 2 4   0 0     0   1   18 22     0 0   12 11   40
690448 690448 MN Wright 86 school 2700360 4118 Charter Schools KALEIDOSCOPE CHARTER SCHOOL 270036004668 20 Kaleidoscope Charter Secondary School Secondary School (Grades 7-12) Regular School Yes Other 06 12 2017   grade_8 19.0 0.0 0.0   0.0 0.0     0.0   0.0   13.0 6.0     0.0   0.0     3.0   7.0   19.0 19 0 0   0 0     0   0   13 6     0 0   3 7   19
690449 690449 MN Wright 86 school 2700360 4118 Charter Schools KALEIDOSCOPE CHARTER SCHOOL 270036004668 20 Kaleidoscope Charter Secondary School Secondary School (Grades 7-12) Regular School Yes Other 06 12 2017   grade_9 14.0 0.0 1.0   0.0 0.0     0.0   0.0   8.0 7.0     0.0   0.0     5.0   6.0   15.0 14 0 1   0 0     0   0   8 7     0 0   5 6   15
690450 690450 MN Wright 86 school 2700360 4118 Charter Schools KALEIDOSCOPE CHARTER SCHOOL 270036004668 20 Kaleidoscope Charter Secondary School Secondary School (Grades 7-12) Regular School Yes Other 06 12 2017   grade_10 8.0 0.0 0.0   0.0 0.0     0.0   0.0   7.0 1.0         *         *   8.0 8 0 0   0 0     0   0   7 1                 8
690451 690451 MN Wright 86 school 2700360 4118 Charter Schools KALEIDOSCOPE CHARTER SCHOOL 270036004668 20 Kaleidoscope Charter Secondary School Secondary School (Grades 7-12) Regular School Yes Other 06 12 2017   grade_11 6.0 0.0 0.0   0.0 0.0     0.0   0.0   1.0 5.0         *         *   6.0 6 0 0   0 0     0   0   1 5                 6
690452 690452 MN Wright 86 school 2700360 4118 Charter Schools KALEIDOSCOPE CHARTER SCHOOL 270036004668 20 Kaleidoscope Charter Secondary School Secondary School (Grades 7-12) Regular School Yes Other 06 12 2017   grade_12 7.0 0.0 0.0   0.0 0.0     0.0   0.0   4.0 3.0         *         *   7.0 7 0 0   0 0     0   0   4 3                 7
690453 690453 MN Wright 86 school 2700360 4118 Charter Schools KALEIDOSCOPE CHARTER SCHOOL 270036004668 20 Kaleidoscope Charter Secondary School Secondary School (Grades 7-12) Regular School Yes Other 06 12 2017   pk_12_total 120.0 3.0 5.0   0.0 0.0     0.0   1.0   67.0 62.0     1.0   0.0     33.0   45.0   129.0 120 3 5   0 0     0   1   67 62     1 0   33 45   129
690526 690526 MN Wright 86 school 2700403 4229 Charter Schools Jane Goodall Environmental Science Academy 270040304850 10 Jane Goodall Environmental Science Academy Secondary School (Grades 7-12) Regular School Yes Other 06 12 2017   grade_6 8.0 0.0 0.0   0.0 0.0     0.0   1.0   5.0 4.0         *         *   9.0 8 0 0   0 0     0   1   5 4                 9
690527 690527 MN Wright 86 school 2700403 4229 Charter Schools Jane Goodall Environmental Science Academy 270040304850 10 Jane Goodall Environmental Science Academy Secondary School (Grades 7-12) Regular School Yes Other 06 12 2017   grade_7 18.0 0.0 1.0   0.0 0.0     0.0   1.0   14.0 6.0     0.0   0.0     5.0   6.0   20.0 18 0 1   0 0     0   1   14 6     0 0   5 6   20
690528 690528 MN Wright 86 school 2700403 4229 Charter Schools Jane Goodall Environmental Science Academy 270040304850 10 Jane Goodall Environmental Science Academy Secondary School (Grades 7-12) Regular School Yes Other 06 12 2017   grade_8 19.0 0.0 0.0   0.0 0.0     0.0   0.0   10.0 9.0     0.0   0.0     1.0   5.0   19.0 19 0 0   0 0     0   0   10 9     0 0   1 5   19
690529 690529 MN Wright 86 school 2700403 4229 Charter Schools Jane Goodall Environmental Science Academy 270040304850 10 Jane Goodall Environmental Science Academy Secondary School (Grades 7-12) Regular School Yes Other 06 12 2017   grade_9 16.0 0.0 0.0   0.0 0.0     0.0   0.0   11.0 5.0     0.0   0.0     6.0   5.0   16.0 16 0 0   0 0     0   0   11 5     0 0   6 5   16
690530 690530 MN Wright 86 school 2700403 4229 Charter Schools Jane Goodall Environmental Science Academy 270040304850 10 Jane Goodall Environmental Science Academy Secondary School (Grades 7-12) Regular School Yes Other 06 12 2017   grade_10 20.0 0.0 0.0   0.0 0.0     0.0   0.0   12.0 8.0     0.0   0.0     5.0   6.0   20.0 20 0 0   0 0     0   0   12 8     0 0   5 6   20
690531 690531 MN Wright 86 school 2700403 4229 Charter Schools Jane Goodall Environmental Science Academy 270040304850 10 Jane Goodall Environmental Science Academy Secondary School (Grades 7-12) Regular School Yes Other 06 12 2017   grade_11 12.0 0.0 0.0   0.0 0.0     0.0   0.0   8.0 4.0     0.0   1.0     4.0   6.0   12.0 12 0 0   0 0     0   0   8 4     0 1   4 6   12
690532 690532 MN Wright 86 school 2700403 4229 Charter Schools Jane Goodall Environmental Science Academy 270040304850 10 Jane Goodall Environmental Science Academy Secondary School (Grades 7-12) Regular School Yes Other 06 12 2017   grade_12 5.0 0.0 0.0   0.0 0.0     0.0   0.0   5.0 0.0         *         *   5.0 5 0 0   0 0     0   0   5 0                 5
690533 690533 MN Wright 86 school 2700403 4229 Charter Schools Jane Goodall Environmental Science Academy 270040304850 10 Jane Goodall Environmental Science Academy Secondary School (Grades 7-12) Regular School Yes Other 06 12 2017   pk_12_total 98.0 0.0 1.0   0.0 0.0     0.0   2.0   65.0 36.0     0.0   1.0     25.0   33.0   101.0 98 0 1   0 0     0   2   65 36     0 1   25 33   101
693114 693114 MN Wright 86 school 2710060 466 Independent Districts and Schools DASSEL-COKATO PUBLIC SCHOOL DIST. 271006000426 1 COKATO ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2017   early_childhood_special_ed 21.0 0.0 2.0   0.0 0.0     0.0   0.0   16.0 7.0     0.0   0.0     6.0   *   23.0 21 0 2   0 0     0   0   16 7     0 0   6     23
693115 693115 MN Wright 86 school 2710060 466 Independent Districts and Schools DASSEL-COKATO PUBLIC SCHOOL DIST. 271006000426 1 COKATO ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2017   kindergarten 89.0 0.0 1.0   0.0 1.0     0.0   3.0   43.0 51.0     1.0   0.0     26.0   12.0   94.0 89 0 1   0 1     0   3   43 51     1 0   26 12   94
693116 693116 MN Wright 86 school 2710060 466 Independent Districts and Schools DASSEL-COKATO PUBLIC SCHOOL DIST. 271006000426 1 COKATO ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2017   grade_1 90.0 0.0 6.0   0.0 0.0     0.0   4.0   48.0 52.0     1.0   0.0     23.0   14.0   100.0 90 0 6   0 0     0   4   48 52     1 0   23 14   100
693117 693117 MN Wright 86 school 2710060 466 Independent Districts and Schools DASSEL-COKATO PUBLIC SCHOOL DIST. 271006000426 1 COKATO ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2017   grade_2 102.0 1.0 3.0   0.0 1.0     0.0   4.0   62.0 49.0     4.0   0.0     42.0   18.0   111.0 102 1 3   0 1     0   4   62 49     4 0   42 18   111
693118 693118 MN Wright 86 school 2710060 466 Independent Districts and Schools DASSEL-COKATO PUBLIC SCHOOL DIST. 271006000426 1 COKATO ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2017   grade_3 79.0 1.0 6.0   0.0 2.0     0.0   0.0   45.0 43.0     3.0   0.0     20.0   11.0   88.0 79 1 6   0 2     0   0   45 43     3 0   20 11   88
693119 693119 MN Wright 86 school 2710060 466 Independent Districts and Schools DASSEL-COKATO PUBLIC SCHOOL DIST. 271006000426 1 COKATO ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2017   grade_4 106.0 0.0 3.0   0.0 1.0     0.0   2.0   52.0 60.0     1.0   0.0     30.0   13.0   112.0 106 0 3   0 1     0   2   52 60     1 0   30 13   112
693120 693120 MN Wright 86 school 2710060 466 Independent Districts and Schools DASSEL-COKATO PUBLIC SCHOOL DIST. 271006000426 1 COKATO ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2017   pk_12_total 487.0 2.0 21.0   0.0 5.0     0.0   13.0   266.0 262.0     10.0   0.0     147.0   91.0   528.0 487 2 21   0 5     0   13   266 262     10 0   147 91   528
694641 694641 MN Wright 86 school 2711370 728 Independent Districts and Schools ELK RIVER PUBLIC SCHOOL DISTRICT 271137002557 800 OTSEGO ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   kindergarten 111.0 0.0 2.0   0.0 0.0     0.0   8.0   61.0 60.0     4.0   0.0     21.0   15.0   121.0 111 0 2   0 0     0   8   61 60     4 0   21 15   121
694642 694642 MN Wright 86 school 2711370 728 Independent Districts and Schools ELK RIVER PUBLIC SCHOOL DISTRICT 271137002557 800 OTSEGO ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_1 96.0 4.0 5.0   0.0 1.0     0.0   5.0   62.0 49.0     6.0   0.0     21.0   16.0   111.0 96 4 5   0 1     0   5   62 49     6 0   21 16   111
694643 694643 MN Wright 86 school 2711370 728 Independent Districts and Schools ELK RIVER PUBLIC SCHOOL DISTRICT 271137002557 800 OTSEGO ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_2 110.0 6.0 3.0   0.0 5.0     0.0   13.0   65.0 72.0     7.0   0.0     31.0   19.0   137.0 110 6 3   0 5     0   13   65 72     7 0   31 19   137
694644 694644 MN Wright 86 school 2711370 728 Independent Districts and Schools ELK RIVER PUBLIC SCHOOL DISTRICT 271137002557 800 OTSEGO ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_3 120.0 4.0 6.0   0.0 1.0     0.0   9.0   62.0 78.0     7.0   1.0     32.0   16.0   140.0 120 4 6   0 1     0   9   62 78     7 1   32 16   140
694645 694645 MN Wright 86 school 2711370 728 Independent Districts and Schools ELK RIVER PUBLIC SCHOOL DISTRICT 271137002557 800 OTSEGO ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_4 120.0 4.0 10.0   0.0 1.0     0.0   8.0   74.0 69.0     6.0   0.0     33.0   21.0   143.0 120 4 10   0 1     0   8   74 69     6 0   33 21   143
694646 694646 MN Wright 86 school 2711370 728 Independent Districts and Schools ELK RIVER PUBLIC SCHOOL DISTRICT 271137002557 800 OTSEGO ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_5 97.0 5.0 5.0   1.0 1.0     0.0   7.0   58.0 58.0     4.0   0.0     28.0   19.0   116.0 97 5 5   1 1     0   7   58 58     4 0   28 19   116
694647 694647 MN Wright 86 school 2711370 728 Independent Districts and Schools ELK RIVER PUBLIC SCHOOL DISTRICT 271137002557 800 OTSEGO ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   pk_12_total 654.0 23.0 31.0   1.0 9.0     0.0   50.0   382.0 386.0     34.0   1.0     166.0   106.0   768.0 654 23 31   1 9     0   50   382 386     34 1   166 106   768
695332 695332 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 2017   early_childhood_special_ed 29.0 0.0 1.0   0.0 0.0     0.0   0.0   18.0 12.0     0.0   0.0     9.0   *   30.0 29 0 1   0 0     0   0   18 12     0 0   9     30
695333 695333 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 2017   kindergarten 125.0 1.0 4.0   0.0 1.0     0.0   4.0   64.0 71.0     3.0   0.0     39.0   21.0   135.0 125 1 4   0 1     0   4   64 71     3 0   39 21   135
695334 695334 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 2017   grade_1 136.0 2.0 4.0   0.0 1.0     0.0   8.0   83.0 68.0     2.0   1.0     48.0   33.0   151.0 136 2 4   0 1     0   8   83 68     2 1   48 33   151
695335 695335 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 2017   grade_2 135.0 1.0 4.0   0.0 2.0     1.0   4.0   74.0 73.0     2.0   0.0     36.0   29.0   147.0 135 1 4   0 2     1   4   74 73     2 0   36 29   147
695336 695336 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 2017   grade_3 111.0 1.0 1.0   0.0 1.0     0.0   34.0   71.0 77.0     1.0   0.0     43.0   19.0   148.0 111 1 1   0 1     0   34   71 77     1 0   43 19   148
695337 695337 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 2017   grade_4 133.0 2.0 1.0   0.0 1.0     0.0   3.0   69.0 71.0     1.0   1.0     33.0   27.0   140.0 133 2 1   0 1     0   3   69 71     1 1   33 27   140
695338 695338 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 2017   grade_5 151.0 2.0 4.0   0.0 0.0     0.0   2.0   72.0 87.0     1.0   1.0     42.0   18.0   159.0 151 2 4   0 0     0   2   72 87     1 1   42 18   159
695339 695339 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 2017   pk_12_total 820.0 9.0 19.0   0.0 6.0     1.0   55.0   451.0 459.0     10.0   3.0     250.0   177.0   910.0 820 9 19   0 6     1   55   451 459     10 3   250 177   910

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