Data source: Big Local News · About: Big Local

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

View and edit SQL

year

  • 2019 · 13,903
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
1945297 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 2019   grade_7 45.0 0.0 2.0   0.0 0.0     0.0   1.0   26.0 22.0     0.0   0.0     17.0   9.0   48.0 45 0 2   0 0     0   1   26 22     0 0   17 9   48
1945298 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 2019   grade_8 40.0 0.0 1.0   0.0 0.0     0.0   1.0   20.0 22.0     0.0   0.0     12.0   6.0   42.0 40 0 1   0 0     0   1   20 22     0 0   12 6   42
1945299 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 2019   grade_9 53.0 1.0 2.0   0.0 1.0     0.0   0.0   24.0 33.0     0.0   0.0     10.0   9.0   57.0 53 1 2   0 1     0   0   24 33     0 0   10 9   57
1945300 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 2019   grade_10 33.0 1.0 1.0   0.0 0.0     0.0   0.0   19.0 16.0     0.0   0.0     6.0   4.0   35.0 33 1 1   0 0     0   0   19 16     0 0   6 4   35
1945301 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 2019   grade_11 37.0 0.0 1.0   0.0 0.0     0.0   1.0   25.0 14.0     0.0   0.0     9.0   3.0   39.0 37 0 1   0 0     0   1   25 14     0 0   9 3   39
1945302 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 2019   grade_12 53.0 1.0 2.0   0.0 0.0     0.0   0.0   33.0 23.0     0.0   0.0     7.0   10.0   56.0 53 1 2   0 0     0   0   33 23     0 0   7 10   56
1945303 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 2019   pk_12_total 261.0 3.0 9.0   0.0 1.0     0.0   3.0   147.0 130.0     0.0   0.0     61.0   41.0   277.0 261 3 9   0 1     0   3   147 130     0 0   61 41   277
1950926 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 2019   early_childhood_special_ed 6.0 0.0 0.0   0.0 0.0     0.0   1.0   5.0 2.0     *   *         *   7.0 6 0 0   0 0     0   1   5 2                 7
1950927 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 2019   kindergarten 41.0 0.0 0.0   0.0 0.0     0.0   1.0   22.0 20.0     0.0   *     14.0   4.0   42.0 41 0 0   0 0     0   1   22 20     0     14 4   42
1950928 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 2019   grade_1 38.0 0.0 2.0   1.0 0.0     0.0   1.0   20.0 22.0     *   0.0     18.0   7.0   42.0 38 0 2   1 0     0   1   20 22       0   18 7   42
1950929 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 2019   grade_2 36.0 2.0 0.0   0.0 0.0     0.0   3.0   19.0 22.0     0.0   0.0     22.0   5.0   41.0 36 2 0   0 0     0   3   19 22     0 0   22 5   41
1950930 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 2019   grade_3 34.0 0.0 0.0   0.0 0.0     0.0   1.0   15.0 20.0     0.0   0.0         2.0   35.0 34 0 0   0 0     0   1   15 20     0 0     2   35
1950931 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 2019   grade_4 36.0 0.0 1.0   0.0 0.0     0.0   0.0   17.0 20.0     0.0   0.0     14.0   8.0   37.0 36 0 1   0 0     0   0   17 20     0 0   14 8   37
1950932 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 2019   grade_5 51.0 0.0 2.0   0.0 0.0     0.0   1.0   22.0 32.0     0.0   0.0     16.0   10.0   54.0 51 0 2   0 0     0   1   22 32     0 0   16 10   54
1950933 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 2019   grade_6 39.0 1.0 2.0   0.0 1.0     0.0   1.0   20.0 24.0     1.0   0.0     16.0   6.0   44.0 39 1 2   0 1     0   1   20 24     1 0   16 6   44
1950934 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 2019   pk_12_total 281.0 3.0 7.0   1.0 1.0     0.0   9.0   140.0 162.0     2.0   0.0     111.0   49.0   302.0 281 3 7   1 1     0   9   140 162     2 0   111 49   302
1951256 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   early_childhood_special_ed 16.0 0.0 0.0   3.0 0.0     0.0   0.0   12.0 7.0     0.0   0.0     11.0   *   19.0 16 0 0   3 0     0   0   12 7     0 0   11     19
1951257 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   kindergarten 26.0 0.0 8.0   6.0 0.0     0.0   0.0   16.0 24.0     2.0   0.0     19.0   8.0   40.0 26 0 8   6 0     0   0   16 24     2 0   19 8   40
1951258 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_1 35.0 1.0 4.0   7.0 1.0     0.0   0.0   26.0 22.0     1.0   0.0     18.0   10.0   48.0 35 1 4   7 1     0   0   26 22     1 0   18 10   48
1951259 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_2 29.0 0.0 7.0   5.0 1.0     0.0   1.0   22.0 21.0     2.0   0.0     17.0   9.0   43.0 29 0 7   5 1     0   1   22 21     2 0   17 9   43
1951260 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_3 40.0 1.0 8.0   8.0 1.0     0.0   1.0   39.0 20.0     1.0   0.0     24.0   14.0   59.0 40 1 8   8 1     0   1   39 20     1 0   24 14   59
1951261 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_4 36.0 0.0 4.0   10.0 1.0     0.0   2.0   22.0 31.0     1.0   0.0     22.0   13.0   53.0 36 0 4   10 1     0   2   22 31     1 0   22 13   53
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
1951263 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   pk_12_total 227.0 2.0 38.0   48.0 4.0     0.0   6.0   173.0 152.0     9.0   0.0     139.0   90.0   325.0 227 2 38   48 4     0   6   173 152     9 0   139 90   325
1952703 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 2019   kindergarten 6.0 0.0 1.0   0.0 0.0     0.0   0.0   4.0 3.0     *   *         *   7.0 6 0 1   0 0     0   0   4 3                 7
1952704 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 2019   grade_1 10.0 0.0 1.0   0.0 0.0     0.0   0.0   6.0 5.0     0.0   0.0     7.0   1.0   11.0 10 0 1   0 0     0   0   6 5     0 0   7 1   11
1952705 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 2019   grade_2 6.0 0.0 1.0   0.0 0.0     0.0   1.0   1.0 7.0     *   *         *   8.0 6 0 1   0 0     0   1   1 7                 8
1952706 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 2019   grade_3 6.0 0.0 0.0   0.0 0.0     0.0   0.0   3.0 3.0     *   *         *   6.0 6 0 0   0 0     0   0   3 3                 6
1952707 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 2019   grade_4 9.0 0.0 1.0   0.0 0.0     0.0   1.0   8.0 3.0     0.0   0.0     7.0   2.0   11.0 9 0 1   0 0     0   1   8 3     0 0   7 2   11
1952708 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 2019   grade_5 4.0 0.0 1.0   0.0 0.0     0.0   0.0   2.0 3.0     *   *         *   5.0 4 0 1   0 0     0   0   2 3                 5
1952709 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 2019   grade_6 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
1952710 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 2019   pk_12_total 44.0 0.0 5.0   0.0 0.0     0.0   2.0   26.0 25.0     0.0   0.0     28.0   11.0   51.0 44 0 5   0 0     0   2   26 25     0 0   28 11   51
1954012 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 2019   grade_6 36.0 1.0 9.0   10.0 1.0     0.0   0.0   26.0 31.0     0.0   0.0     22.0   17.0   57.0 36 1 9   10 1     0   0   26 31     0 0   22 17   57
1954013 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 2019   grade_7 31.0 0.0 8.0   8.0 1.0     0.0   3.0   25.0 26.0     1.0   0.0     24.0   8.0   51.0 31 0 8   8 1     0   3   25 26     1 0   24 8   51
1954014 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 2019   grade_8 43.0 1.0 5.0   10.0 1.0     0.0   2.0   28.0 34.0     0.0   0.0     24.0   6.0   62.0 43 1 5   10 1     0   2   28 34     0 0   24 6   62
1954015 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 2019   pk_12_total 110.0 2.0 22.0   28.0 3.0     0.0   5.0   79.0 91.0     1.0   0.0     70.0   31.0   170.0 110 2 22   28 3     0   5   79 91     1 0   70 31   170
1955007 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 2019   grade_9 42.0 3.0 5.0   11.0 0.0     0.0   0.0   31.0 30.0     0.0   0.0     25.0   13.0   61.0 42 3 5   11 0     0   0   31 30     0 0   25 13   61
1955008 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 2019   grade_10 36.0 0.0 6.0   8.0 0.0     0.0   0.0   28.0 22.0     2.0   0.0     19.0   4.0   50.0 36 0 6   8 0     0   0   28 22     2 0   19 4   50
1955009 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 2019   grade_11 29.0 1.0 7.0   2.0 2.0     0.0   0.0   23.0 18.0     4.0   0.0     15.0   9.0   41.0 29 1 7   2 2     0   0   23 18     4 0   15 9   41
1955010 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 2019   grade_12 38.0 1.0 7.0   2.0 1.0     0.0   0.0   24.0 25.0     3.0   0.0     14.0   8.0   49.0 38 1 7   2 1     0   0   24 25     3 0   14 8   49
1955011 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 2019   pk_12_total 145.0 5.0 25.0   23.0 3.0     0.0   0.0   106.0 95.0     9.0   0.0     73.0   34.0   201.0 145 5 25   23 3     0   0   106 95     9 0   73 34   201
1958245 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 2019   kindergarten 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
1958246 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 2019   grade_1 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
1958247 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 2019   grade_2 1.0 0.0 0.0   3.0 0.0     0.0   0.0   2.0 2.0     *   *         *   4.0 1 0 0   3 0     0   0   2 2                 4
1958248 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 2019   grade_3 2.0 0.0 0.0   0.0 0.0     0.0   2.0   3.0 1.0     *   *         *   4.0 2 0 0   0 0     0   2   3 1                 4
1958249 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 2019   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
1958250 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 2019   grade_5 4.0 0.0 0.0   2.0 0.0     0.0   1.0   3.0 4.0     *   *         *   7.0 4 0 0   2 0     0   1   3 4                 7
1958251 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 2019   grade_6 3.0 0.0 0.0   3.0 0.0     0.0   0.0   3.0 3.0     *   *         *   6.0 3 0 0   3 0     0   0   3 3                 6
1958252 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 2019   grade_7 6.0 0.0 1.0   2.0 0.0     0.0   2.0   6.0 5.0     0.0   0.0     7.0   4.0   11.0 6 0 1   2 0     0   2   6 5     0 0   7 4   11
1958253 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 2019   grade_8 4.0 0.0 1.0   0.0 0.0     0.0   3.0   3.0 5.0     *   *         *   8.0 4 0 1   0 0     0   3   3 5                 8
1958254 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 2019   grade_9 5.0 0.0 1.0   0.0 0.0     0.0   1.0   4.0 3.0     *   *         *   7.0 5 0 1   0 0     0   1   4 3                 7
1958255 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 2019   grade_10 3.0 0.0 0.0   1.0 0.0     0.0   0.0   3.0 1.0     *   *         *   4.0 3 0 0   1 0     0   0   3 1                 4
1958256 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 2019   grade_11 5.0 0.0 0.0   0.0 0.0     0.0   0.0   2.0 3.0     *   *         *   5.0 5 0 0   0 0     0   0   2 3                 5
1958257 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 2019   grade_12 4.0 0.0 0.0   1.0 1.0     0.0   0.0   2.0 4.0     *   *         *   6.0 4 0 0   1 1     0   0   2 4                 6
1958258 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 2019   pk_12_total 43.0 0.0 3.0   12.0 1.0     0.0   9.0   35.0 33.0     0.0   0.0     40.0   23.0   68.0 43 0 3   12 1     0   9   35 33     0 0   40 23   68
1945283 MN Wright 86 school 2710170 879 Independent Districts and Schools DELANO PUBLIC SCHOOL DISTRICT 271017000438 20 Delano High School Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_7 177.0 0.0 3.0   0.0 0.0     0.0   10.0   95.0 95.0     1.0   0.0     17.0   19.0   190.0 177 0 3   0 0     0   10   95 95     1 0   17 19   190
1945284 MN Wright 86 school 2710170 879 Independent Districts and Schools DELANO PUBLIC SCHOOL DISTRICT 271017000438 20 Delano High School Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_8 200.0 0.0 3.0   0.0 2.0     0.0   8.0   94.0 119.0     2.0   0.0     22.0   21.0   213.0 200 0 3   0 2     0   8   94 119     2 0   22 21   213
1945285 MN Wright 86 school 2710170 879 Independent Districts and Schools DELANO PUBLIC SCHOOL DISTRICT 271017000438 20 Delano High School Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_9 200.0 0.0 3.0   1.0 1.0     0.0   5.0   117.0 93.0     0.0   0.0     23.0   28.0   210.0 200 0 3   1 1     0   5   117 93     0 0   23 28   210
1945286 MN Wright 86 school 2710170 879 Independent Districts and Schools DELANO PUBLIC SCHOOL DISTRICT 271017000438 20 Delano High School Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_10 178.0 0.0 4.0   0.0 3.0     0.0   2.0   101.0 86.0     0.0   0.0     11.0   22.0   187.0 178 0 4   0 3     0   2   101 86     0 0   11 22   187
1945287 MN Wright 86 school 2710170 879 Independent Districts and Schools DELANO PUBLIC SCHOOL DISTRICT 271017000438 20 Delano High School Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_11 184.0 3.0 4.0   1.0 3.0     0.0   1.0   92.0 104.0     0.0   0.0     13.0   16.0   196.0 184 3 4   1 3     0   1   92 104     0 0   13 16   196
1945288 MN Wright 86 school 2710170 879 Independent Districts and Schools DELANO PUBLIC SCHOOL DISTRICT 271017000438 20 Delano High School Secondary School (Grades 7-12) Regular School No High 07 12 2019   grade_12 196.0 1.0 3.0   0.0 2.0     0.0   1.0   98.0 105.0     0.0   0.0     14.0   22.0   203.0 196 1 3   0 2     0   1   98 105     0 0   14 22   203
1945289 MN Wright 86 school 2710170 879 Independent Districts and Schools DELANO PUBLIC SCHOOL DISTRICT 271017000438 20 Delano High School Secondary School (Grades 7-12) Regular School No High 07 12 2019   pk_12_total 1135.0 4.0 20.0   2.0 11.0     0.0   27.0   597.0 602.0     3.0   0.0     100.0   128.0   1199.0 1135 4 20   2 11     0   27   597 602     3 0   100 128   1199
1945290 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 2019   grade_7 58.0 0.0 2.0   0.0 0.0     0.0   2.0   35.0 27.0     0.0   0.0     14.0   14.0   62.0 58 0 2   0 0     0   2   35 27     0 0   14 14   62
1945291 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 2019   grade_8 65.0 0.0 1.0   0.0 0.0     1.0   1.0   36.0 32.0     0.0   0.0     14.0   14.0   68.0 65 0 1   0 0     1   1   36 32     0 0   14 14   68
1945292 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 2019   grade_9 89.0 0.0 1.0   0.0 0.0     0.0   2.0   35.0 57.0     0.0   0.0     21.0   14.0   92.0 89 0 1   0 0     0   2   35 57     0 0   21 14   92
1945293 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 2019   grade_10 74.0 0.0 0.0   0.0 0.0     0.0   2.0   36.0 40.0     1.0   0.0     8.0   10.0   76.0 74 0 0   0 0     0   2   36 40     1 0   8 10   76
1945294 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 2019   grade_11 60.0 2.0 0.0   0.0 0.0     1.0   0.0   35.0 28.0     0.0   0.0     6.0   4.0   63.0 60 2 0   0 0     1   0   35 28     0 0   6 4   63
1945295 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 2019   grade_12 75.0 0.0 1.0   1.0 0.0     1.0   2.0   42.0 38.0     0.0   0.0     11.0   11.0   80.0 75 0 1   1 0     1   2   42 38     0 0   11 11   80
1945296 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 2019   pk_12_total 421.0 2.0 5.0   1.0 0.0     3.0   9.0   219.0 222.0     1.0   0.0     74.0   67.0   441.0 421 2 5   1 0     3   9   219 222     1 0   74 67   441
1945886 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 High 06 12 2019   grade_6 12.0 0.0 0.0   0.0 0.0     0.0   0.0   7.0 5.0     0.0   0.0     4.0   3.0   12.0 12 0 0   0 0     0   0   7 5     0 0   4 3   12
1945887 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 High 06 12 2019   grade_7 15.0 0.0 0.0   0.0 0.0     0.0   0.0   13.0 2.0     0.0   0.0     4.0   7.0   15.0 15 0 0   0 0     0   0   13 2     0 0   4 7   15
1945888 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 High 06 12 2019   grade_8 15.0 1.0 1.0   1.0 0.0     0.0   1.0   11.0 8.0     0.0   0.0     4.0   11.0   19.0 15 1 1   1 0     0   1   11 8     0 0   4 11   19
1945889 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 High 06 12 2019   grade_9 16.0 0.0 1.0   0.0 0.0     0.0   0.0   14.0 3.0     0.0   0.0     2.0   6.0   17.0 16 0 1   0 0     0   0   14 3     0 0   2 6   17
1945890 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 High 06 12 2019   grade_10 15.0 0.0 0.0   1.0 0.0     0.0   0.0   8.0 8.0     0.0   0.0     1.0   6.0   16.0 15 0 0   1 0     0   0   8 8     0 0   1 6   16
1945891 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 High 06 12 2019   grade_11 14.0 0.0 2.0   0.0 0.0     0.0   0.0   7.0 9.0     0.0   0.0     3.0   7.0   16.0 14 0 2   0 0     0   0   7 9     0 0   3 7   16
1945892 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 High 06 12 2019   grade_12 19.0 0.0 0.0   0.0 0.0     0.0   0.0   11.0 8.0     0.0   0.0     2.0   7.0   19.0 19 0 0   0 0     0   0   11 8     0 0   2 7   19
1945893 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 High 06 12 2019   pk_12_total 106.0 1.0 4.0   2.0 0.0     0.0   1.0   71.0 43.0     0.0   0.0     20.0   47.0   114.0 106 1 4   2 0     0   1   71 43     0 0   20 47   114
1948542 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 2019   early_childhood_special_ed 20.0 0.0 0.0   0.0 0.0     0.0   0.0   15.0 5.0     0.0   0.0     7.0   *   20.0 20 0 0   0 0     0   0   15 5     0 0   7     20
1948543 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 2019   kindergarten 69.0 1.0 4.0   0.0 0.0     0.0   4.0   46.0 32.0     0.0   0.0     18.0   15.0   78.0 69 1 4   0 0     0   4   46 32     0 0   18 15   78
1948544 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 2019   grade_1 75.0 1.0 5.0   1.0 0.0     0.0   5.0   40.0 47.0     0.0   0.0     28.0   15.0   87.0 75 1 5   1 0     0   5   40 47     0 0   28 15   87
1948545 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 2019   grade_2 87.0 0.0 1.0   0.0 1.0     0.0   1.0   42.0 48.0     1.0   0.0     25.0   10.0   90.0 87 0 1   0 1     0   1   42 48     1 0   25 10   90
1948546 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 2019   grade_3 87.0 0.0 4.0   0.0 0.0     0.0   5.0   44.0 52.0     2.0   0.0     20.0   13.0   96.0 87 0 4   0 0     0   5   44 52     2 0   20 13   96
1948547 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 2019   grade_4 97.0 1.0 2.0   1.0 1.0     0.0   3.0   60.0 45.0     4.0   0.0     29.0   22.0   105.0 97 1 2   1 1     0   3   60 45     4 0   29 22   105
1948548 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 2019   pk_12_total 435.0 3.0 16.0   2.0 2.0     0.0   18.0   247.0 229.0     7.0   0.0     127.0   95.0   476.0 435 3 16   2 2     0   18   247 229     7 0   127 95   476
1950121 MN Wright 86 school 2711370 728 Independent Districts and Schools ELK RIVER PUBLIC SCHOOL DISTRICT 271137004932 180 Prairie View Elementary & Middle School Elementary School (Grades PK-6) Regular School No Elementary KG 08 2019   kindergarten 96.0 2.0 1.0   0.0 1.0     0.0   7.0   54.0 53.0     *   0.0     7.0   15.0   107.0 96 2 1   0 1     0   7   54 53       0   7 15   107
1950122 MN Wright 86 school 2711370 728 Independent Districts and Schools ELK RIVER PUBLIC SCHOOL DISTRICT 271137004932 180 Prairie View Elementary & Middle School Elementary School (Grades PK-6) Regular School No Elementary KG 08 2019   grade_1 85.0 7.0 3.0   0.0 3.0     0.0   10.0   55.0 53.0     4.0   0.0     6.0   22.0   108.0 85 7 3   0 3     0   10   55 53     4 0   6 22   108
1950123 MN Wright 86 school 2711370 728 Independent Districts and Schools ELK RIVER PUBLIC SCHOOL DISTRICT 271137004932 180 Prairie View Elementary & Middle School Elementary School (Grades PK-6) Regular School No Elementary KG 08 2019   grade_2 77.0 2.0 1.0   0.0 1.0     0.0   6.0   42.0 45.0     *   0.0         15.0   87.0 77 2 1   0 1     0   6   42 45       0     15   87
1950124 MN Wright 86 school 2711370 728 Independent Districts and Schools ELK RIVER PUBLIC SCHOOL DISTRICT 271137004932 180 Prairie View Elementary & Middle School Elementary School (Grades PK-6) Regular School No Elementary KG 08 2019   grade_3 55.0 5.0 5.0   0.0 1.0     0.0   5.0   33.0 38.0     2.0   0.0     7.0   6.0   71.0 55 5 5   0 1     0   5   33 38     2 0   7 6   71
1950125 MN Wright 86 school 2711370 728 Independent Districts and Schools ELK RIVER PUBLIC SCHOOL DISTRICT 271137004932 180 Prairie View Elementary & Middle School Elementary School (Grades PK-6) Regular School No Elementary KG 08 2019   grade_4 67.0 8.0 5.0   0.0 4.0     0.0   9.0   39.0 54.0     5.0   0.0         15.0   93.0 67 8 5   0 4     0   9   39 54     5 0     15   93
1950126 MN Wright 86 school 2711370 728 Independent Districts and Schools ELK RIVER PUBLIC SCHOOL DISTRICT 271137004932 180 Prairie View Elementary & Middle School Elementary School (Grades PK-6) Regular School No Elementary KG 08 2019   grade_5 70.0 7.0 4.0   0.0 0.0     0.0   6.0   45.0 42.0     4.0   0.0     14.0   12.0   87.0 70 7 4   0 0     0   6   45 42     4 0   14 12   87
1950127 MN Wright 86 school 2711370 728 Independent Districts and Schools ELK RIVER PUBLIC SCHOOL DISTRICT 271137004932 180 Prairie View Elementary & Middle School Elementary School (Grades PK-6) Regular School No Elementary KG 08 2019   grade_6 139.0 9.0 21.0   1.0 2.0     0.0   17.0   93.0 96.0     6.0   *     38.0   27.0   189.0 139 9 21   1 2     0   17   93 96     6     38 27   189
1950128 MN Wright 86 school 2711370 728 Independent Districts and Schools ELK RIVER PUBLIC SCHOOL DISTRICT 271137004932 180 Prairie View Elementary & Middle School Elementary School (Grades PK-6) Regular School No Elementary KG 08 2019   grade_7 111.0 8.0 8.0   1.0 2.0     0.0   14.0   65.0 79.0     3.0   0.0     28.0   19.0   144.0 111 8 8   1 2     0   14   65 79     3 0   28 19   144
1950129 MN Wright 86 school 2711370 728 Independent Districts and Schools ELK RIVER PUBLIC SCHOOL DISTRICT 271137004932 180 Prairie View Elementary & Middle School Elementary School (Grades PK-6) Regular School No Elementary KG 08 2019   pk_12_total 700.0 48.0 48.0   2.0 14.0     0.0   74.0   426.0 460.0     26.0   *     110.0   131.0   886.0 700 48 48   2 14     0   74   426 460     26     110 131   886
1950152 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 2019   kindergarten 97.0 1.0 2.0   0.0 3.0     0.0   7.0   53.0 57.0     4.0   0.0     12.0   18.0   110.0 97 1 2   0 3     0   7   53 57     4 0   12 18   110
1950153 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 2019   grade_1 77.0 2.0 10.0   0.0 4.0     0.0   8.0   56.0 45.0     9.0   0.0     30.0   9.0   101.0 77 2 10   0 4     0   8   56 45     9 0   30 9   101
1950154 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 2019   grade_2 88.0 3.0 3.0   0.0 1.0     0.0   5.0   49.0 51.0     3.0   0.0     21.0   14.0   100.0 88 3 3   0 1     0   5   49 51     3 0   21 14   100
1950155 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 2019   grade_3 89.0 4.0 7.0   0.0 1.0     0.0   6.0   57.0 50.0     7.0   0.0     23.0   16.0   107.0 89 4 7   0 1     0   6   57 50     7 0   23 16   107
1950156 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 2019   grade_4 79.0 3.0 7.0   0.0 3.0     0.0   8.0   50.0 50.0     5.0   0.0     23.0   15.0   100.0 79 3 7   0 3     0   8   50 50     5 0   23 15   100
1950157 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 2019   grade_5 84.0 0.0 4.0   0.0 2.0     0.0   5.0   36.0 59.0     2.0   0.0     13.0   17.0   95.0 84 0 4   0 2     0   5   36 59     2 0   13 17   95
1950158 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 2019   pk_12_total 514.0 13.0 33.0   0.0 14.0     0.0   39.0   301.0 312.0     30.0   0.0     122.0   89.0   613.0 514 13 33   0 14     0   39   301 312     30 0   122 89   613

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