Data source: Big Local News · About: Big Local

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

View and edit SQL

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
690534 MN Unknown   school 2700402 4237 Charter Schools Metropolitan Education for Future Employment 270040204836 10 Metropolitan Education for Future Employment Charter Secondary School (Grades 7-12) Regular School Yes Other 06 12 2017   grade_7 0.0 5.0 0.0   0.0 0.0     0.0   0.0   5.0 0.0         *         *   5.0 0 5 0   0 0     0   0   5 0                 5
690535 MN Unknown   school 2700402 4237 Charter Schools Metropolitan Education for Future Employment 270040204836 10 Metropolitan Education for Future Employment Charter Secondary School (Grades 7-12) Regular School Yes Other 06 12 2017   grade_8 0.0 4.0 0.0   0.0 0.0     0.0   1.0   3.0 2.0         *         *   5.0 0 4 0   0 0     0   1   3 2                 5
690536 MN Unknown   school 2700402 4237 Charter Schools Metropolitan Education for Future Employment 270040204836 10 Metropolitan Education for Future Employment Charter Secondary School (Grades 7-12) Regular School Yes Other 06 12 2017   grade_9 1.0 2.0 0.0   0.0 0.0     0.0   0.0   2.0 1.0         *         *   3.0 1 2 0   0 0     0   0   2 1                 3
690537 MN Unknown   school 2700402 4237 Charter Schools Metropolitan Education for Future Employment 270040204836 10 Metropolitan Education for Future Employment Charter Secondary School (Grades 7-12) Regular School Yes Other 06 12 2017   grade_10 1.0 6.0 0.0   0.0 0.0     0.0   0.0   4.0 3.0         *         *   7.0 1 6 0   0 0     0   0   4 3                 7
690538 MN Unknown   school 2700402 4237 Charter Schools Metropolitan Education for Future Employment 270040204836 10 Metropolitan Education for Future Employment Charter Secondary School (Grades 7-12) Regular School Yes Other 06 12 2017   grade_11 0.0 11.0 1.0   0.0 0.0     0.0   0.0   8.0 4.0     4.0   1.0         0.0   12.0 0 11 1   0 0     0   0   8 4     4 1     0   12
690539 MN Unknown   school 2700402 4237 Charter Schools Metropolitan Education for Future Employment 270040204836 10 Metropolitan Education for Future Employment Charter Secondary School (Grades 7-12) Regular School Yes Other 06 12 2017   grade_12 0.0 37.0 3.0   0.0 0.0     0.0   0.0   31.0 9.0     15.0   1.0     31.0   2.0   40.0 0 37 3   0 0     0   0   31 9     15 1   31 2   40
690540 MN Unknown   school 2700402 4237 Charter Schools Metropolitan Education for Future Employment 270040204836 10 Metropolitan Education for Future Employment Charter Secondary School (Grades 7-12) Regular School Yes Other 06 12 2017   pk_12_total 2.0 65.0 4.0   0.0 0.0     0.0   1.0   53.0 19.0     28.0   3.0     60.0   7.0   72.0 2 65 4   0 0     0   1   53 19     28 3   60 7   72
697397 MN Unknown   school 2700380 4213 Charter Schools Prodeo Academy 270038004642 10 Prodeo Academy Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2017   kindergarten 1.0 50.0 6.0   0.0 1.0     0.0   6.0   29.0 35.0     11.0   0.0     56.0   0.0   64.0 1 50 6   0 1     0   6   29 35     11 0   56 0   64
697398 MN Unknown   school 2700380 4213 Charter Schools Prodeo Academy 270038004642 10 Prodeo Academy Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2017   grade_1 3.0 65.0 9.0   0.0 1.0     0.0   6.0   33.0 51.0     13.0   0.0     67.0   3.0   84.0 3 65 9   0 1     0   6   33 51     13 0   67 3   84
697399 MN Unknown   school 2700380 4213 Charter Schools Prodeo Academy 270038004642 10 Prodeo Academy Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2017   grade_2 1.0 41.0 7.0   1.0 1.0     0.0   6.0   25.0 32.0     11.0   0.0     44.0   4.0   57.0 1 41 7   1 1     0   6   25 32     11 0   44 4   57
697400 MN Unknown   school 2700380 4213 Charter Schools Prodeo Academy 270038004642 10 Prodeo Academy Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2017   grade_3 3.0 46.0 16.0   0.0 0.0     0.0   7.0   39.0 33.0     22.0   0.0     59.0   7.0   72.0 3 46 16   0 0     0   7   39 33     22 0   59 7   72
697401 MN Unknown   school 2700380 4213 Charter Schools Prodeo Academy 270038004642 10 Prodeo Academy Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2017   pk_12_total 8.0 202.0 38.0   1.0 3.0     0.0   25.0   126.0 151.0     57.0   0.0     226.0   14.0   277.0 8 202 38   1 3     0   25   126 151     57 0   226 14   277
700482 MN Unknown   school 2718780 77 Independent Districts and Schools MANKATO PUBLIC SCHOOL DISTRICT 271878002173 170 SPECIAL EDUCATION Special Education Special Education School No Other PK 12 2017   early_childhood_special_ed 222.0 28.0 17.0   2.0 2.0     0.0   6.0   181.0 96.0         *         *   277.0 222 28 17   2 2     0   6   181 96                 277
700483 MN Unknown   school 2718780 77 Independent Districts and Schools MANKATO PUBLIC SCHOOL DISTRICT 271878002173 170 SPECIAL EDUCATION Special Education Special Education School No Other PK 12 2017   pk_12_total 222.0 28.0 17.0   2.0 2.0     0.0   6.0   181.0 96.0         *         *   277.0 222 28 17   2 2     0   6   181 96                 277
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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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

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