Data source: Big Local News · About: Big Local

96,319 rows where state = "MN" sorted by county descending

View and edit SQL

grade

year

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
1147054 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 3 07 12 2015   grade_7 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
1147055 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 3 07 12 2015   grade_8 48.0 0.0 0.0   0.0 0.0     0.0   0.0   29.0 19.0     0.0   0.0     13.0   10.0   48.0 48 0 0   0 0     0   0   29 19     0 0   13 10   48
1147056 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 3 07 12 2015   grade_9 45.0 0.0 0.0   0.0 0.0     0.0   0.0   21.0 24.0     1.0   0.0     12.0   4.0   45.0 45 0 0   0 0     0   0   21 24     1 0   12 4   45
1147057 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 3 07 12 2015   grade_10 34.0 0.0 0.0   0.0 0.0     0.0   0.0   15.0 19.0     0.0   0.0     9.0   3.0   34.0 34 0 0   0 0     0   0   15 19     0 0   9 3   34
1147058 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 3 07 12 2015   grade_11 45.0 0.0 2.0   0.0 0.0     0.0   0.0   28.0 19.0     0.0   0.0     20.0   9.0   47.0 45 0 2   0 0     0   0   28 19     0 0   20 9   47
1147059 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 3 07 12 2015   grade_12 45.0 1.0 3.0   0.0 0.0     0.0   0.0   30.0 19.0     0.0   0.0     19.0   6.0   49.0 45 1 3   0 0     0   0   30 19     0 0   19 6   49
1147060 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 3 07 12 2015   pk_12_total 252.0 1.0 6.0   0.0 0.0     0.0   0.0   148.0 111.0     1.0   0.0     82.0   35.0   259.0 252 1 6   0 0     0   0   148 111     1 0   82 35   259
1152401 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 1 PK 06 2015   early_childhood_special_ed 9.0 1.0 0.0   0.0 0.0     0.0   0.0   9.0 1.0     0.0   0.0     4.0   *   10.0 9 1 0   0 0     0   0   9 1     0 0   4     10
1152402 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 1 PK 06 2015   kindergarten 31.0 0.0 0.0   0.0 0.0     0.0   0.0   15.0 16.0     0.0   0.0     16.0   6.0   31.0 31 0 0   0 0     0   0   15 16     0 0   16 6   31
1152403 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 1 PK 06 2015   grade_1 44.0 0.0 1.0   0.0 0.0     0.0   0.0   19.0 26.0     0.0   0.0     17.0   6.0   45.0 44 0 1   0 0     0   0   19 26     0 0   17 6   45
1152404 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 1 PK 06 2015   grade_2 31.0 0.0 1.0   0.0 1.0     0.0   0.0   13.0 20.0     0.0   0.0     13.0   6.0   33.0 31 0 1   0 1     0   0   13 20     0 0   13 6   33
1152405 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 1 PK 06 2015   grade_3 31.0 0.0 0.0   0.0 0.0     0.0   1.0   17.0 15.0     0.0   0.0     11.0   6.0   32.0 31 0 0   0 0     0   1   17 15     0 0   11 6   32
1152406 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 1 PK 06 2015   grade_4 34.0 0.0 1.0   0.0 0.0     0.0   0.0   18.0 17.0     0.0   0.0     15.0   3.0   35.0 34 0 1   0 0     0   0   18 17     0 0   15 3   35
1152407 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 1 PK 06 2015   grade_5 39.0 1.0 1.0   0.0 1.0     0.0   0.0   20.0 22.0     0.0   0.0     11.0   10.0   42.0 39 1 1   0 1     0   0   20 22     0 0   11 10   42
1152408 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 1 PK 06 2015   grade_6 27.0 1.0 0.0   0.0 0.0     0.0   0.0   18.0 10.0     0.0   0.0     11.0   6.0   28.0 27 1 0   0 0     0   0   18 10     0 0   11 6   28
1152409 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 1 PK 06 2015   pk_12_total 246.0 3.0 4.0   0.0 2.0     0.0   1.0   129.0 127.0     0.0   0.0     98.0   53.0   256.0 246 3 4   0 2     0   1   129 127     0 0   98 53   256
1152742 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 1 PK 05 2015   early_childhood_special_ed 13.0 0.0 2.0   2.0 2.0     0.0   0.0   11.0 8.0     0.0   0.0     10.0   *   19.0 13 0 2   2 2     0   0   11 8     0 0   10     19
1152743 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 1 PK 05 2015   kindergarten 37.0 0.0 7.0   5.0 1.0     0.0   2.0   23.0 29.0     0.0   0.0     24.0   7.0   52.0 37 0 7   5 1     0   2   23 29     0 0   24 7   52
1152744 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 1 PK 05 2015   grade_1 53.0 1.0 9.0   11.0 0.0     0.0   2.0   43.0 33.0     1.0   0.0     38.0   17.0   76.0 53 1 9   11 0     0   2   43 33     1 0   38 17   76
1152745 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 1 PK 05 2015   grade_2 33.0 1.0 11.0   11.0 2.0     0.0   0.0   26.0 32.0     4.0   0.0     34.0   13.0   58.0 33 1 11   11 2     0   0   26 32     4 0   34 13   58
1152746 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 1 PK 05 2015   grade_3 31.0 0.0 12.0   12.0 1.0     0.0   3.0   34.0 25.0     5.0   0.0     29.0   8.0   59.0 31 0 12   12 1     0   3   34 25     5 0   29 8   59
1152747 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 1 PK 05 2015   grade_4 40.0 0.0 8.0   9.0 2.0     0.0   1.0   28.0 32.0     3.0   0.0     27.0   12.0   60.0 40 0 8   9 2     0   1   28 32     3 0   27 12   60
1152748 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 1 PK 05 2015   grade_5 39.0 1.0 6.0   13.0 0.0     0.0   0.0   30.0 29.0     0.0   1.0     31.0   15.0   59.0 39 1 6   13 0     0   0   30 29     0 1   31 15   59
1152749 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 1 PK 05 2015   pk_12_total 246.0 3.0 55.0   63.0 8.0     0.0   8.0   195.0 188.0     13.0   1.0     193.0   91.0   383.0 246 3 55   63 8     0   8   195 188     13 1   193 91   383
1154203 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 1 KG 06 2015   kindergarten 15.0 0.0 0.0   1.0 0.0     0.0   0.0   10.0 6.0     0.0   0.0     6.0   1.0   16.0 15 0 0   1 0     0   0   10 6     0 0   6 1   16
1154204 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 1 KG 06 2015   grade_1 5.0 0.0 2.0   0.0 0.0     0.0   0.0   3.0 4.0         *         *   7.0 5 0 2   0 0     0   0   3 4                 7
1154205 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 1 KG 06 2015   grade_2 8.0 0.0 0.0   0.0 0.0     0.0   1.0   6.0 3.0         *         *   9.0 8 0 0   0 0     0   1   6 3                 9
1154206 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 1 KG 06 2015   grade_3 12.0 0.0 2.0   0.0 0.0     0.0   0.0   6.0 8.0     0.0   0.0     9.0   6.0   14.0 12 0 2   0 0     0   0   6 8     0 0   9 6   14
1154207 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 1 KG 06 2015   grade_4 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
1154208 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 1 KG 06 2015   grade_5 7.0 0.0 0.0   0.0 0.0     0.0   0.0   7.0 0.0         *         *   7.0 7 0 0   0 0     0   0   7 0                 7
1154209 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 1 KG 06 2015   grade_6 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
1154210 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 1 KG 06 2015   pk_12_total 54.0 0.0 4.0   1.0 0.0     0.0   1.0   36.0 24.0     0.0   0.0     34.0   12.0   60.0 54 0 4   1 0     0   1   36 24     0 0   34 12   60
1155258 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 2 06 08 2015   grade_6 40.0 1.0 10.0   10.0 0.0     0.0   1.0   33.0 29.0     3.0   1.0     31.0   11.0   62.0 40 1 10   10 0     0   1   33 29     3 1   31 11   62
1155259 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 2 06 08 2015   grade_7 29.0 0.0 8.0   9.0 2.0     0.0   0.0   24.0 24.0     3.0   0.0     25.0   13.0   48.0 29 0 8   9 2     0   0   24 24     3 0   25 13   48
1155260 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 2 06 08 2015   grade_8 41.0 0.0 6.0   10.0 1.0     0.0   0.0   32.0 26.0     4.0   0.0     25.0   11.0   58.0 41 0 6   10 1     0   0   32 26     4 0   25 11   58
1155261 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 2 06 08 2015   pk_12_total 110.0 1.0 24.0   29.0 3.0     0.0   1.0   89.0 79.0     10.0   1.0     81.0   35.0   168.0 110 1 24   29 3     0   1   89 79     10 1   81 35   168
1156228 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 3 09 12 2015   grade_9 51.0 0.0 5.0   16.0 1.0     0.0   1.0   40.0 34.0     2.0   0.0     33.0   13.0   74.0 51 0 5   16 1     0   1   40 34     2 0   33 13   74
1156229 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 3 09 12 2015   grade_10 48.0 0.0 4.0   4.0 0.0     0.0   1.0   31.0 26.0     0.0   0.0     18.0   8.0   57.0 48 0 4   4 0     0   1   31 26     0 0   18 8   57
1156230 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 3 09 12 2015   grade_11 45.0 1.0 3.0   5.0 1.0     0.0   0.0   27.0 28.0     0.0   0.0     12.0   7.0   55.0 45 1 3   5 1     0   0   27 28     0 0   12 7   55
1156231 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 3 09 12 2015   grade_12 55.0 0.0 11.0   9.0 2.0     0.0   0.0   35.0 42.0     2.0   0.0     29.0   15.0   77.0 55 0 11   9 2     0   0   35 42     2 0   29 15   77
1156232 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 3 09 12 2015   pk_12_total 199.0 1.0 23.0   34.0 4.0     0.0   2.0   133.0 130.0     4.0   0.0     92.0   43.0   263.0 199 1 23   34 4     0   2   133 130     4 0   92 43   263
1159422 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 4 KG 12 2015   kindergarten 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
1159423 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 4 KG 12 2015   grade_1 4.0 1.0 1.0   0.0 0.0     0.0   1.0   4.0 3.0         *         *   7.0 4 1 1   0 0     0   1   4 3                 7
1159424 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 4 KG 12 2015   grade_2 7.0 1.0 0.0   0.0 0.0     0.0   0.0   4.0 4.0         *         *   8.0 7 1 0   0 0     0   0   4 4                 8
1159425 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 4 KG 12 2015   grade_3 3.0 0.0 0.0   0.0 0.0     0.0   2.0   2.0 3.0         *         *   5.0 3 0 0   0 0     0   2   2 3                 5
1159426 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 4 KG 12 2015   grade_4 5.0 1.0 0.0   0.0 0.0     0.0   1.0   2.0 5.0         *         *   7.0 5 1 0   0 0     0   1   2 5                 7
1159427 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 4 KG 12 2015   grade_5 7.0 0.0 1.0   0.0 0.0     0.0   0.0   6.0 2.0         *         *   8.0 7 0 1   0 0     0   0   6 2                 8
1159428 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 4 KG 12 2015   grade_6 7.0 0.0 1.0   0.0 0.0     0.0   0.0   7.0 1.0         *         *   8.0 7 0 1   0 0     0   0   7 1                 8
1159429 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 4 KG 12 2015   grade_7 9.0 0.0 0.0   0.0 0.0     0.0   1.0   5.0 5.0     0.0   0.0     6.0   1.0   10.0 9 0 0   0 0     0   1   5 5     0 0   6 1   10
1159430 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 4 KG 12 2015   grade_8 4.0 0.0 0.0   2.0 1.0     0.0   0.0   4.0 3.0         *         *   7.0 4 0 0   2 1     0   0   4 3                 7
1159431 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 4 KG 12 2015   grade_9 5.0 0.0 3.0   1.0 0.0     0.0   1.0   4.0 6.0     0.0   0.0     5.0   3.0   10.0 5 0 3   1 0     0   1   4 6     0 0   5 3   10
1159432 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 4 KG 12 2015   grade_10 6.0 0.0 2.0   0.0 1.0     0.0   0.0   5.0 4.0         *         *   9.0 6 0 2   0 1     0   0   5 4                 9
1159433 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 4 KG 12 2015   grade_11 7.0 0.0 0.0   3.0 0.0     0.0   0.0   7.0 3.0     0.0   0.0     5.0   5.0   10.0 7 0 0   3 0     0   0   7 3     0 0   5 5   10
1159434 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 4 KG 12 2015   grade_12 7.0 0.0 0.0   0.0 0.0     0.0   0.0   3.0 4.0         *         *   7.0 7 0 0   0 0     0   0   3 4                 7
1159435 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 4 KG 12 2015   pk_12_total 75.0 3.0 8.0   6.0 2.0     0.0   6.0   55.0 45.0     0.0   0.0     60.0   25.0   100.0 75 3 8   6 2     0   6   55 45     0 0   60 25   100
854364 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 3 07 12 2016   grade_7 34 1 1   0 0     0   0   21 15     0.0   0.0     15.0   5.0   36 34 1 1   0 0     0   0   21 15     0 0   15 5   36
854365 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 3 07 12 2016   grade_8 35 0 1   0 0     0   0   26 10     0.0   0.0     9.0   4.0   36 35 0 1   0 0     0   0   26 10     0 0   9 4   36
854366 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 3 07 12 2016   grade_9 48 0 0   0 0     0   0   30 18     0.0   0.0     12.0   9.0   48 48 0 0   0 0     0   0   30 18     0 0   12 9   48
854367 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 3 07 12 2016   grade_10 44 0 0   0 0     0   0   20 24     1.0   0.0     11.0   4.0   44 44 0 0   0 0     0   0   20 24     1 0   11 4   44
854368 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 3 07 12 2016   grade_11 37 0 0   0 0     0   0   15 22     0.0   0.0     12.0   2.0   37 37 0 0   0 0     0   0   15 22     0 0   12 2   37
854369 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 3 07 12 2016   grade_12 46 0 2   0 0     0   0   28 20     0.0   0.0     18.0   8.0   48 46 0 2   0 0     0   0   28 20     0 0   18 8   48
854370 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 3 07 12 2016   pk_12_total 244 1 4   0 0     0   0   140 109     1.0   0.0     77.0   32.0   249 244 1 4   0 0     0   0   140 109     1 0   77 32   249
859723 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 1 PK 06 2016   early_childhood_special_ed 5 1 1   0 0     0   0   6 1         *         *   7 5 1 1   0 0     0   0   6 1                 7
859724 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 1 PK 06 2016   kindergarten 34 1 0   0 0     0   2   16 21         *     13.0   4.0   37 34 1 0   0 0     0   2   16 21           13 4   37
859725 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 1 PK 06 2016   grade_1 30 0 0   0 0     0   0   15 15     0.0   0.0     15.0   4.0   30 30 0 0   0 0     0   0   15 15     0 0   15 4   30
859726 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 1 PK 06 2016   grade_2 46 0 1   0 0     0   0   19 28     0.0   0.0     18.0   5.0   47 46 0 1   0 0     0   0   19 28     0 0   18 5   47
859727 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 1 PK 06 2016   grade_3 31 0 2   0 1     0   0   14 20     0.0   0.0     14.0   8.0   34 31 0 2   0 1     0   0   14 20     0 0   14 8   34
859728 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 1 PK 06 2016   grade_4 34 0 0   0 0     0   1   20 15     0.0   0.0         7.0   35 34 0 0   0 0     0   1   20 15     0 0     7   35
859729 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 1 PK 06 2016   grade_5 34 0 1   0 0     0   0   18 17     0.0   0.0     15.0   4.0   35 34 0 1   0 0     0   0   18 17     0 0   15 4   35
859730 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 1 PK 06 2016   grade_6 44 1 1   0 1     0   0   20 27     0.0   0.0     12.0   9.0   47 44 1 1   0 1     0   0   20 27     0 0   12 9   47
859731 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 1 PK 06 2016   pk_12_total 258 3 6   0 2     0   3   128 144     0.0   0.0     102.0   48.0   272 258 3 6   0 2     0   3   128 144     0 0   102 48   272
860059 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 1 PK 05 2016   early_childhood_special_ed 13 0 2   3 1     0   0   10 9     0.0   0.0     11.0   *   19 13 0 2   3 1     0   0   10 9     0 0   11     19
860060 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 1 PK 05 2016   kindergarten 40 1 6   7 1     0   1   36 20     0.0   0.0     26.0   9.0   56 40 1 6   7 1     0   1   36 20     0 0   26 9   56
860061 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 1 PK 05 2016   grade_1 37 0 5   6 1     0   2   20 31     0.0   0.0     23.0   9.0   51 37 0 5   6 1     0   2   20 31     0 0   23 9   51
860062 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 1 PK 05 2016   grade_2 49 1 10   10 0     0   2   38 34     1.0   0.0     36.0   15.0   72 49 1 10   10 0     0   2   38 34     1 0   36 15   72
860063 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 1 PK 05 2016   grade_3 35 1 9   10 2     0   0   26 31     4.0   0.0     29.0   14.0   57 35 1 9   10 2     0   0   26 31     4 0   29 14   57
860064 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 1 PK 05 2016   grade_4 32 0 10   13 1     0   4   34 26     6.0   0.0     34.0   7.0   60 32 0 10   13 1     0   4   34 26     6 0   34 7   60
860065 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 1 PK 05 2016   grade_5 43 0 6   9 2     0   2   31 31     2.0   0.0     26.0   11.0   62 43 0 6   9 2     0   2   31 31     2 0   26 11   62
860066 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 1 PK 05 2016   pk_12_total 249 3 48   58 8     0   11   195 182     13.0   0.0     185.0   84.0   377 249 3 48   58 8     0   11   195 182     13 0   185 84   377
861489 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 1 KG 06 2016   kindergarten 9 0 0   1 0     0   1   3 8     0.0   0.0     6.0   1.0   11 9 0 0   1 0     0   1   3 8     0 0   6 1   11
861490 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 1 KG 06 2016   grade_1 12 0 0   1 0     0   0   9 4     0.0   0.0     7.0   1.0   13 12 0 0   1 0     0   0   9 4     0 0   7 1   13
861491 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 1 KG 06 2016   grade_2 5 0 1   0 0     0   0   3 3         *         *   6 5 0 1   0 0     0   0   3 3                 6
861492 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 1 KG 06 2016   grade_3 6 0 0   0 0     0   1   6 1         *         *   7 6 0 0   0 0     0   1   6 1                 7
861493 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 1 KG 06 2016   grade_4 10 0 1   0 0     0   0   5 6     0.0   0.0     5.0   3.0   11 10 0 1   0 0     0   0   5 6     0 0   5 3   11
861494 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 1 KG 06 2016   grade_5 3 0 0   0 0     0   0   1 2         *         *   3 3 0 0   0 0     0   0   1 2                 3
861495 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 1 KG 06 2016   grade_6 7 0 0   0 0     0   0   7 0         *         *   7 7 0 0   0 0     0   0   7 0                 7
861496 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 1 KG 06 2016   pk_12_total 52 0 2   2 0     0   2   34 24     0.0   0.0     31.0   11.0   58 52 0 2   2 0     0   2   34 24     0 0   31 11   58
862605 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 2 06 08 2016   grade_6 41 2 6   12 1     0   0   29 33     0.0   0.0     30.0   12.0   62 41 2 6   12 1     0   0   29 33     0 0   30 12   62
862606 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 2 06 08 2016   grade_7 39 1 9   13 0     0   1   33 30     2.0   0.0     33.0   11.0   63 39 1 9   13 0     0   1   33 30     2 0   33 11   63
862607 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 2 06 08 2016   grade_8 30 0 8   7 3     0   0   27 21     4.0   0.0     22.0   11.0   48 30 0 8   7 3     0   0   27 21     4 0   22 11   48
862608 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 2 06 08 2016   pk_12_total 110 3 23   32 4     0   1   89 84     6.0   0.0     85.0   34.0   173 110 3 23   32 4     0   1   89 84     6 0   85 34   173
863600 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 3 09 12 2016   grade_9 40 0 7   7 1     0   0   30 25     4.0   0.0     21.0   9.0   55 40 0 7   7 1     0   0   30 25     4 0   21 9   55
863601 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 3 09 12 2016   grade_10 51 0 4   14 1     0   1   36 35     0.0   0.0     32.0   10.0   71 51 0 4   14 1     0   1   36 35     0 0   32 10   71
863602 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 3 09 12 2016   grade_11 47 0 4   2 0     0   0   32 21     0.0   0.0     13.0   7.0   53 47 0 4   2 0     0   0   32 21     0 0   13 7   53
863603 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 3 09 12 2016   grade_12 40 1 2   5 2     0   0   27 23     0.0   0.0     8.0   8.0   50 40 1 2   5 2     0   0   27 23     0 0   8 8   50
863604 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 3 09 12 2016   pk_12_total 178 1 17   28 4     0   1   125 104     4.0   0.0     74.0   34.0   229 178 1 17   28 4     0   1   125 104     4 0   74 34   229
866873 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 4 KG 12 2016   kindergarten 6 0 0   0 0     0   2   5 3         *         *   8 6 0 0   0 0     0   2   5 3                 8
866874 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 4 KG 12 2016   grade_1 4 0 0   0 0     0   0   2 2         *         *   4 4 0 0   0 0     0   0   2 2                 4
866875 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 4 KG 12 2016   grade_2 4 0 0   1 0     0   1   2 4         *         *   6 4 0 0   1 0     0   1   2 4                 6
866876 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 4 KG 12 2016   grade_3 6 0 0   1 0     0   0   3 4         *         *   7 6 0 0   1 0     0   0   3 4                 7

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