Data source: Big Local News · About: Big Local

13,486 rows where state = "MN" and year = 2016 sorted by county_state_id descending

View and edit SQL

year

  • 2016 · 13,486
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
854894 MN Unknown   school 2700367 4200 Charter Schools STEP ACADEMY CHARTER SCHOOL 270036704507 10 STEP ACADEMY CHARTER SCHOOL Secondary School (Grades 7-12) Regular School Yes 4 06 12 2016   grade_6 0 25 0   0 1     0   0   11 15     3.0   0.0         0.0   26 0 25 0   0 1     0   0   11 15     3 0     0   26
854895 MN Unknown   school 2700367 4200 Charter Schools STEP ACADEMY CHARTER SCHOOL 270036704507 10 STEP ACADEMY CHARTER SCHOOL Secondary School (Grades 7-12) Regular School Yes 4 06 12 2016   grade_7 1 29 0   0 0     0   0   16 14     2.0   0.0         0.0   30 1 29 0   0 0     0   0   16 14     2 0     0   30
854896 MN Unknown   school 2700367 4200 Charter Schools STEP ACADEMY CHARTER SCHOOL 270036704507 10 STEP ACADEMY CHARTER SCHOOL Secondary School (Grades 7-12) Regular School Yes 4 06 12 2016   grade_8 0 48 0   0 1     0   0   27 22     4.0   0.0     43.0   1.0   49 0 48 0   0 1     0   0   27 22     4 0   43 1   49
854897 MN Unknown   school 2700367 4200 Charter Schools STEP ACADEMY CHARTER SCHOOL 270036704507 10 STEP ACADEMY CHARTER SCHOOL Secondary School (Grades 7-12) Regular School Yes 4 06 12 2016   grade_9 0 35 0   0 0     0   0   15 20     10.0   0.0         1.0   35 0 35 0   0 0     0   0   15 20     10 0     1   35
854898 MN Unknown   school 2700367 4200 Charter Schools STEP ACADEMY CHARTER SCHOOL 270036704507 10 STEP ACADEMY CHARTER SCHOOL Secondary School (Grades 7-12) Regular School Yes 4 06 12 2016   grade_10 0 43 0   0 0     0   0   14 29     11.0   0.0     37.0   1.0   43 0 43 0   0 0     0   0   14 29     11 0   37 1   43
854899 MN Unknown   school 2700367 4200 Charter Schools STEP ACADEMY CHARTER SCHOOL 270036704507 10 STEP ACADEMY CHARTER SCHOOL Secondary School (Grades 7-12) Regular School Yes 4 06 12 2016   grade_11 0 31 0   0 0     0   0   13 18     5.0   0.0     26.0   1.0   31 0 31 0   0 0     0   0   13 18     5 0   26 1   31
854900 MN Unknown   school 2700367 4200 Charter Schools STEP ACADEMY CHARTER SCHOOL 270036704507 10 STEP ACADEMY CHARTER SCHOOL Secondary School (Grades 7-12) Regular School Yes 4 06 12 2016   grade_12 0 18 0   0 0     0   0   3 15     5.0   0.0     13.0   0.0   18 0 18 0   0 0     0   0   3 15     5 0   13 0   18
854901 MN Unknown   school 2700367 4200 Charter Schools STEP ACADEMY CHARTER SCHOOL 270036704507 10 STEP ACADEMY CHARTER SCHOOL Secondary School (Grades 7-12) Regular School Yes 4 06 12 2016   pk_12_total 1 229 0   0 2     0   0   99 133     40.0   0.0     207.0   4.0   232 1 229 0   0 2     0   0   99 133     40 0   207 4   232
854931 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 4 06 12 2016   grade_6 0 20 0   0 0     0   0   10 10     13.0   *         0.0   20 0 20 0   0 0     0   0   10 10     13       0   20
854932 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 4 06 12 2016   grade_7 0 15 0   0 0     0   0   8 7     10.0   0.0         *   15 0 15 0   0 0     0   0   8 7     10 0         15
854933 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 4 06 12 2016   grade_8 0 12 0   0 0     0   0   5 7         0.0         1.0   12 0 12 0   0 0     0   0   5 7       0     1   12
854934 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 4 06 12 2016   grade_9 1 17 1   0 0     0   0   8 11     12.0   0.0         3.0   19 1 17 1   0 0     0   0   8 11     12 0     3   19
854935 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 4 06 12 2016   grade_10 0 9 0   0 0     0   0   6 3         *         *   9 0 9 0   0 0     0   0   6 3                 9
854936 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 4 06 12 2016   grade_11 1 13 0   0 0     0   0   5 9     7.0   0.0         2.0   14 1 13 0   0 0     0   0   5 9     7 0     2   14
854937 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 4 06 12 2016   grade_12 0 26 1   0 0     0   0   14 13     10.0   0.0         1.0   27 0 26 1   0 0     0   0   14 13     10 0     1   27
854938 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 4 06 12 2016   pk_12_total 2 112 2   0 0     0   0   56 60     64.0   0.0         8.0   116 2 112 2   0 0     0   0   56 60     64 0     8   116
855453 MN Unknown   school 2718780 77 Independent Districts and Schools MANKATO PUBLIC SCHOOL DISTRICT 271878002977 60 BRIDGES COMMUNITY ELEMENTARY Elementary School (Grades PK-6) Regular School No 1 KG 05 2016   kindergarten 36 0 2   0 1     0   1   20 20     0.0   0.0     5.0   3.0   40 36 0 2   0 1     0   1   20 20     0 0   5 3   40
855454 MN Unknown   school 2718780 77 Independent Districts and Schools MANKATO PUBLIC SCHOOL DISTRICT 271878002977 60 BRIDGES COMMUNITY ELEMENTARY Elementary School (Grades PK-6) Regular School No 1 KG 05 2016   grade_1 35 0 1   0 3     0   1   16 24     0.0   0.0     13.0   2.0   40 35 0 1   0 3     0   1   16 24     0 0   13 2   40
855455 MN Unknown   school 2718780 77 Independent Districts and Schools MANKATO PUBLIC SCHOOL DISTRICT 271878002977 60 BRIDGES COMMUNITY ELEMENTARY Elementary School (Grades PK-6) Regular School No 1 KG 05 2016   grade_2 16 1 0   0 1     0   2   10 10         0.0     0.0   0.0   20 16 1 0   0 1     0   2   10 10       0   0 0   20
855456 MN Unknown   school 2718780 77 Independent Districts and Schools MANKATO PUBLIC SCHOOL DISTRICT 271878002977 60 BRIDGES COMMUNITY ELEMENTARY Elementary School (Grades PK-6) Regular School No 1 KG 05 2016   grade_3 18 0 0   0 2     0   1   14 7     0.0   0.0         1.0   21 18 0 0   0 2     0   1   14 7     0 0     1   21
855457 MN Unknown   school 2718780 77 Independent Districts and Schools MANKATO PUBLIC SCHOOL DISTRICT 271878002977 60 BRIDGES COMMUNITY ELEMENTARY Elementary School (Grades PK-6) Regular School No 1 KG 05 2016   grade_4 20 0 1   0 1     0   1   12 11     0.0   0.0         2.0   23 20 0 1   0 1     0   1   12 11     0 0     2   23
855458 MN Unknown   school 2718780 77 Independent Districts and Schools MANKATO PUBLIC SCHOOL DISTRICT 271878002977 60 BRIDGES COMMUNITY ELEMENTARY Elementary School (Grades PK-6) Regular School No 1 KG 05 2016   grade_5 19 0 0   0 3     0   0   11 11     0.0   0.0     1.0   4.0   22 19 0 0   0 3     0   0   11 11     0 0   1 4   22
855459 MN Unknown   school 2718780 77 Independent Districts and Schools MANKATO PUBLIC SCHOOL DISTRICT 271878002977 60 BRIDGES COMMUNITY ELEMENTARY Elementary School (Grades PK-6) Regular School No 1 KG 05 2016   pk_12_total 144 1 4   0 11     0   6   83 83         0.0     22.0   12.0   166 144 1 4   0 11     0   6   83 83       0   22 12   166
860386 MN Unknown   school 2700132 2884 Independent Districts and Schools RED ROCK CENTRAL SCHOOL DISTRICT 270013201419 30 RED ROCK CENTRAL ELEMENTARY Elementary School (Grades PK-6) Regular School No 1 PK 04 2016   early_childhood_special_ed 7 0 0   0 0     0   0   6 1         *         *   7 7 0 0   0 0     0   0   6 1                 7
860387 MN Unknown   school 2700132 2884 Independent Districts and Schools RED ROCK CENTRAL SCHOOL DISTRICT 270013201419 30 RED ROCK CENTRAL ELEMENTARY Elementary School (Grades PK-6) Regular School No 1 PK 04 2016   kindergarten 24 0 0   0 0     0   0   14 10         *     14.0   7.0   24 24 0 0   0 0     0   0   14 10           14 7   24
860388 MN Unknown   school 2700132 2884 Independent Districts and Schools RED ROCK CENTRAL SCHOOL DISTRICT 270013201419 30 RED ROCK CENTRAL ELEMENTARY Elementary School (Grades PK-6) Regular School No 1 PK 04 2016   grade_1 25 0 1   0 0     0   1   14 13     0.0   0.0     16.0   4.0   27 25 0 1   0 0     0   1   14 13     0 0   16 4   27
860389 MN Unknown   school 2700132 2884 Independent Districts and Schools RED ROCK CENTRAL SCHOOL DISTRICT 270013201419 30 RED ROCK CENTRAL ELEMENTARY Elementary School (Grades PK-6) Regular School No 1 PK 04 2016   grade_2 29 0 0   0 0     0   0   17 12     0.0   0.0     16.0   2.0   29 29 0 0   0 0     0   0   17 12     0 0   16 2   29
860390 MN Unknown   school 2700132 2884 Independent Districts and Schools RED ROCK CENTRAL SCHOOL DISTRICT 270013201419 30 RED ROCK CENTRAL ELEMENTARY Elementary School (Grades PK-6) Regular School No 1 PK 04 2016   grade_3 12 0 2   0 1     0   2   8 9     0.0   0.0         1.0   17 12 0 2   0 1     0   2   8 9     0 0     1   17
860391 MN Unknown   school 2700132 2884 Independent Districts and Schools RED ROCK CENTRAL SCHOOL DISTRICT 270013201419 30 RED ROCK CENTRAL ELEMENTARY Elementary School (Grades PK-6) Regular School No 1 PK 04 2016   grade_4 26 0 1   0 0     0   1   17 11     0.0   0.0     12.0   7.0   28 26 0 1   0 0     0   1   17 11     0 0   12 7   28
860392 MN Unknown   school 2700132 2884 Independent Districts and Schools RED ROCK CENTRAL SCHOOL DISTRICT 270013201419 30 RED ROCK CENTRAL ELEMENTARY Elementary School (Grades PK-6) Regular School No 1 PK 04 2016   pk_12_total 123 0 4   0 1     0   4   76 56     0.0   0.0     73.0   28.0   132 123 0 4   0 1     0   4   76 56     0 0   73 28   132
861647 MN Unknown   school 2700380 4213 Charter Schools Prodeo Academy 270038004642 10 Prodeo Academy Elementary School (Grades PK-6) Regular School Yes 1 KG 08 2016   kindergarten 0 65 5   1 2     0   5   35 43     14.0   6.0         0.0   78 0 65 5   1 2     0   5   35 43     14 6     0   78
861648 MN Unknown   school 2700380 4213 Charter Schools Prodeo Academy 270038004642 10 Prodeo Academy Elementary School (Grades PK-6) Regular School Yes 1 KG 08 2016   grade_1 3 56 6   0 2     0   4   31 40     12.0   6.0         2.0   71 3 56 6   0 2     0   4   31 40     12 6     2   71
861649 MN Unknown   school 2700380 4213 Charter Schools Prodeo Academy 270038004642 10 Prodeo Academy Elementary School (Grades PK-6) Regular School Yes 1 KG 08 2016   grade_2 0 44 14   0 1     0   6   32 33     19.0   3.0         4.0   65 0 44 14   0 1     0   6   32 33     19 3     4   65
861650 MN Unknown   school 2700380 4213 Charter Schools Prodeo Academy 270038004642 10 Prodeo Academy Elementary School (Grades PK-6) Regular School Yes 1 KG 08 2016   pk_12_total 3 165 25   1 5     0   15   98 116     45.0   15.0         6.0   214 3 165 25   1 5     0   15   98 116     45 15     6   214
864565 MN Unknown   school 2700014 6004 Education Districts FRESHWATER ED. DIST. 270001402222 20 FRESHWATER ED. DIST. ALC Public Area Learning Center ALC (State approved) Alternative Education School No 4 06 12 2016   grade_8 2 0 0   0 0     0   0   2 0         *         *   2 2 0 0   0 0     0   0   2 0                 2
864566 MN Unknown   school 2700014 6004 Education Districts FRESHWATER ED. DIST. 270001402222 20 FRESHWATER ED. DIST. ALC Public Area Learning Center ALC (State approved) Alternative Education School No 4 06 12 2016   grade_9 11 0 1   0 0     0   0   7 5         *         *   12 11 0 1   0 0     0   0   7 5                 12
864567 MN Unknown   school 2700014 6004 Education Districts FRESHWATER ED. DIST. 270001402222 20 FRESHWATER ED. DIST. ALC Public Area Learning Center ALC (State approved) Alternative Education School No 4 06 12 2016   grade_10 16 0 3   0 0     0   1   11 9     0.0   *     15.0   8.0   20 16 0 3   0 0     0   1   11 9     0     15 8   20
864568 MN Unknown   school 2700014 6004 Education Districts FRESHWATER ED. DIST. 270001402222 20 FRESHWATER ED. DIST. ALC Public Area Learning Center ALC (State approved) Alternative Education School No 4 06 12 2016   grade_11 24 2 9   0 0     1   2   20 18         *         12.0   38 24 2 9   0 0     1   2   20 18             12   38
864569 MN Unknown   school 2700014 6004 Education Districts FRESHWATER ED. DIST. 270001402222 20 FRESHWATER ED. DIST. ALC Public Area Learning Center ALC (State approved) Alternative Education School No 4 06 12 2016   grade_12 27 0 1   1 0     0   1   17 13         *         7.0   30 27 0 1   1 0     0   1   17 13             7   30
864570 MN Unknown   school 2700014 6004 Education Districts FRESHWATER ED. DIST. 270001402222 20 FRESHWATER ED. DIST. ALC Public Area Learning Center ALC (State approved) Alternative Education School No 4 06 12 2016   pk_12_total 80 2 14   1 0     1   4   57 45     0.0   11.0     64.0   31.0   102 80 2 14   1 0     1   4   57 45     0 11   64 31   102
864703 MN Unknown   school 2718780 77 Independent Districts and Schools MANKATO PUBLIC SCHOOL DISTRICT 271878002173 170 SPECIAL EDUCATION Special Education Special Education School No 4 PK 12 2016   early_childhood_special_ed 203 21 14   1 3     0   10   165 87         *         *   252 203 21 14   1 3     0   10   165 87                 252
864704 MN Unknown   school 2718780 77 Independent Districts and Schools MANKATO PUBLIC SCHOOL DISTRICT 271878002173 170 SPECIAL EDUCATION Special Education Special Education School No 4 PK 12 2016   grade_2 1 0 0   0 0     0   0   1 0         *         *   1 1 0 0   0 0     0   0   1 0                 1
864705 MN Unknown   school 2718780 77 Independent Districts and Schools MANKATO PUBLIC SCHOOL DISTRICT 271878002173 170 SPECIAL EDUCATION Special Education Special Education School No 4 PK 12 2016   pk_12_total 204 21 14   1 3     0   10   166 87     0.0   5.0     111.0   *   253 204 21 14   1 3     0   10   166 87     0 5   111     253
865873 MN Unknown   school 2723850 622 Independent Districts and Schools North St Paul-Maplewood Oakdale Public School District 272385004453 74 ANTHONY LOUIS CENTER Educational Oversight to Public Care and Treatment Day Program Alternative Education School No 3 07 12 2016   grade_10 0 1 0   1 0     0   0   0 2         *         *   2 0 1 0   1 0     0   0   0 2                 2
865874 MN Unknown   school 2723850 622 Independent Districts and Schools North St Paul-Maplewood Oakdale Public School District 272385004453 74 ANTHONY LOUIS CENTER Educational Oversight to Public Care and Treatment Day Program Alternative Education School No 3 07 12 2016   grade_11 1 0 0   0 0     0   0   0 1         *         *   1 1 0 0   0 0     0   0   0 1                 1
865875 MN Unknown   school 2723850 622 Independent Districts and Schools North St Paul-Maplewood Oakdale Public School District 272385004453 74 ANTHONY LOUIS CENTER Educational Oversight to Public Care and Treatment Day Program Alternative Education School No 3 07 12 2016   grade_12 1 1 1   0 0     0   0   3 0         *         *   3 1 1 1   0 0     0   0   3 0                 3
865876 MN Unknown   school 2723850 622 Independent Districts and Schools North St Paul-Maplewood Oakdale Public School District 272385004453 74 ANTHONY LOUIS CENTER Educational Oversight to Public Care and Treatment Day Program Alternative Education School No 3 07 12 2016   pk_12_total 2 2 1   1 0     0   0   3 3         *         *   6 2 2 1   1 0     0   0   3 3                 6
866223 MN Unknown   school 2700193 4082 Charter Schools BLUESKY CHARTER SCHOOL 270019303146 10 BLUESKY CHARTER SCHOOL Distance Learning Program OLL (State approved) Regular School Yes 3 07 12 2016   grade_7 7 0 3   0 1     0   0   9 2     0.0   0.0     5.0   3.0   11 7 0 3   0 1     0   0   9 2     0 0   5 3   11
866224 MN Unknown   school 2700193 4082 Charter Schools BLUESKY CHARTER SCHOOL 270019303146 10 BLUESKY CHARTER SCHOOL Distance Learning Program OLL (State approved) Regular School Yes 3 07 12 2016   grade_8 14 0 0   3 2     0   0   10 9     0.0   0.0     6.0   1.0   19 14 0 0   3 2     0   0   10 9     0 0   6 1   19
866225 MN Unknown   school 2700193 4082 Charter Schools BLUESKY CHARTER SCHOOL 270019303146 10 BLUESKY CHARTER SCHOOL Distance Learning Program OLL (State approved) Regular School Yes 3 07 12 2016   grade_9 27 1 3   0 2     0   0   16 17     0.0   0.0     17.0   8.0   33 27 1 3   0 2     0   0   16 17     0 0   17 8   33
866226 MN Unknown   school 2700193 4082 Charter Schools BLUESKY CHARTER SCHOOL 270019303146 10 BLUESKY CHARTER SCHOOL Distance Learning Program OLL (State approved) Regular School Yes 3 07 12 2016   grade_10 61 1 3   1 0     0   0   24 42     1.0   0.0     27.0   16.0   66 61 1 3   1 0     0   0   24 42     1 0   27 16   66
866227 MN Unknown   school 2700193 4082 Charter Schools BLUESKY CHARTER SCHOOL 270019303146 10 BLUESKY CHARTER SCHOOL Distance Learning Program OLL (State approved) Regular School Yes 3 07 12 2016   grade_11 86 4 11   3 2     0   1   39 68     0.0   1.0     36.0   17.0   107 86 4 11   3 2     0   1   39 68     0 1   36 17   107
866228 MN Unknown   school 2700193 4082 Charter Schools BLUESKY CHARTER SCHOOL 270019303146 10 BLUESKY CHARTER SCHOOL Distance Learning Program OLL (State approved) Regular School Yes 3 07 12 2016   grade_12 217 15 25   8 9     1   2   100 177     2.0   0.0     76.0   40.0   277 217 15 25   8 9     1   2   100 177     2 0   76 40   277
866229 MN Unknown   school 2700193 4082 Charter Schools BLUESKY CHARTER SCHOOL 270019303146 10 BLUESKY CHARTER SCHOOL Distance Learning Program OLL (State approved) Regular School Yes 3 07 12 2016   pk_12_total 412 21 45   15 16     1   3   198 315     3.0   1.0     167.0   85.0   513 412 21 45   15 16     1   3   198 315     3 1   167 85   513
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
866877 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_4 2 0 1   1 0     0   2   3 3         *         *   6 2 0 1   1 0     0   2   3 3                 6

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