Data source: Big Local News · About: Big Local

96,319 rows where state = "MN" sorted by ell_int

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
1880696 MN Watonwan 83 school 2718570 837 Independent Districts and Schools Madelia Public School District 271857000860 20 Madelia Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_11 25.0 1.0 19.0   0.0 1.0     0.0   0.0   25.0 21.0     *   *     *   *   46.0 25 1 19   0 1     0   0   25 21                 46
1880697 MN Watonwan 83 school 2718570 837 Independent Districts and Schools Madelia Public School District 271857000860 20 Madelia Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_12 34.0 1.0 15.0   0.0 0.0     0.0   1.0   22.0 29.0     *   *     *   *   51.0 34 1 15   0 0     0   1   22 29                 51
1880704 MN Watonwan 83 school 2733600 840 Independent Districts and Schools St. James Public School District 273360001505 111 St. James Middle/High School Secondary School (Grades 7-12) Regular School No High 06 12 2018   grade_11 50.0 0.0 38.0   0.0 1.0     0.0   0.0   47.0 42.0     *   0.0     44.0   11.0   89.0 50 0 38   0 1     0   0   47 42       0   44 11   89
1880706 MN Watonwan 83 school 2733600 840 Independent Districts and Schools St. James Public School District 273360001505 111 St. James Middle/High School Secondary School (Grades 7-12) Regular School No High 06 12 2018   pk_12_total 260.0 0.0 271.0   0.0 4.0     0.0   3.0   283.0 255.0     *   2.0     293.0   84.0   538.0 260 0 271   0 4     0   3   283 255       2   293 84   538
1880714 MN Wilkin 84 school 2707450 852 Independent Districts and Schools Campbell-Tintah Public School District 270745000320 20 Campbell-Tintah Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_7 5.0 0.0 0.0   0.0 0.0     0.0   1.0   4.0 2.0     *   *     *   *   6.0 5 0 0   0 0     0   1   4 2                 6
1880715 MN Wilkin 84 school 2707450 852 Independent Districts and Schools Campbell-Tintah Public School District 270745000320 20 Campbell-Tintah Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_8 12.0 0.0 2.0   0.0 0.0     0.0   0.0   7.0 7.0     *   *     5.0   *   14.0 12 0 2   0 0     0   0   7 7           5     14
1880752 MN Mille Lacs 48 school 2720670 912 Independent Districts and Schools Milaca Public School District 272067000924 30 Milaca Secondary High Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_10 138.0 0.0 3.0   1.0 1.0     0.0   2.0   84.0 61.0     *   *     *   *   145.0 138 0 3   1 1     0   2   84 61                 145
1880753 MN Mille Lacs 48 school 2720670 912 Independent Districts and Schools Milaca Public School District 272067000924 30 Milaca Secondary High Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_11 122.0 1.0 2.0   3.0 1.0     0.0   1.0   59.0 71.0     *   *     *   *   130.0 122 1 2   3 1     0   1   59 71                 130
1880821 MN Pope 61 school 2700019 2149 Independent Districts and Schools Minnewaska School District 270001902298 50 Minnewaska Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_9 93.0 2.0 3.0   0.0 1.0     0.0   5.0   55.0 49.0     *   *     *   *   104.0 93 2 3   0 1     0   5   55 49                 104
1880822 MN Pope 61 school 2700019 2149 Independent Districts and Schools Minnewaska School District 270001902298 50 Minnewaska Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_10 77.0 2.0 3.0   0.0 1.0     0.0   1.0   45.0 39.0     *   *     *   *   84.0 77 2 3   0 1     0   1   45 39                 84
1880823 MN Pope 61 school 2700019 2149 Independent Districts and Schools Minnewaska School District 270001902298 50 Minnewaska Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_11 61.0 0.0 1.0   1.0 1.0     0.0   2.0   35.0 31.0     *   *     *   *   66.0 61 0 1   1 1     0   2   35 31                 66
1880824 MN Pope 61 school 2700019 2149 Independent Districts and Schools Minnewaska School District 270001902298 50 Minnewaska Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_12 81.0 1.0 1.0   0.0 2.0     0.0   0.0   44.0 41.0     *   *     *   *   85.0 81 1 1   0 2     0   0   44 41                 85
1880843 MN Pine 58 school 2714070 2165 Independent Districts and Schools Hinckley-Finlayson School District 271407000729 20 Hinckley-Finlayson Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_9 49.0 1.0 2.0   9.0 0.0     0.0   0.0   37.0 24.0     *   *     *   *   61.0 49 1 2   9 0     0   0   37 24                 61
1880844 MN Pine 58 school 2714070 2165 Independent Districts and Schools Hinckley-Finlayson School District 271407000729 20 Hinckley-Finlayson Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_10 43.0 5.0 2.0   6.0 1.0     0.0   1.0   33.0 25.0     *   *     *   *   58.0 43 5 2   6 1     0   1   33 25                 58
1880845 MN Pine 58 school 2714070 2165 Independent Districts and Schools Hinckley-Finlayson School District 271407000729 20 Hinckley-Finlayson Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_11 49.0 3.0 2.0   7.0 2.0     0.0   2.0   34.0 31.0     *   *     *   *   65.0 49 3 2   7 2     0   2   34 31                 65
1880846 MN Pine 58 school 2714070 2165 Independent Districts and Schools Hinckley-Finlayson School District 271407000729 20 Hinckley-Finlayson Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_12 49.0 1.0 0.0   6.0 1.0     0.0   0.0   28.0 29.0     *   *     21.0   *   57.0 49 1 0   6 1     0   0   28 29           21     57
1880880 MN Cass 11 school 2728970 2174 Independent Districts and Schools Pine River-Backus School District 272897000041 20 Pine River-Backus High School Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_10 55.0 0.0 4.0   0.0 0.0     0.0   1.0   31.0 29.0     *   *     *   *   60.0 55 0 4   0 0     0   1   31 29                 60
1880882 MN Cass 11 school 2728970 2174 Independent Districts and Schools Pine River-Backus School District 272897000041 20 Pine River-Backus High School Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_12 44.0 0.0 1.0   0.0 1.0     0.0   0.0   21.0 25.0     *   0.0     12.0   6.0   46.0 44 0 1   0 1     0   0   21 25       0   12 6   46
1880893 MN Chippewa 12 school 2700091 2180 Independent Districts and Schools MACCRAY School District 270009100365 20 Maccray Senior High Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_8 50.0 1.0 7.0   0.0 0.0     0.0   2.0   24.0 36.0     *   *     *   *   60.0 50 1 7   0 0     0   2   24 36                 60
1880895 MN Chippewa 12 school 2700091 2180 Independent Districts and Schools MACCRAY School District 270009100365 20 Maccray Senior High Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_10 38.0 0.0 3.0   0.0 0.0     0.0   0.0   19.0 22.0     *   *     *   *   41.0 38 0 3   0 0     0   0   19 22                 41
1880896 MN Chippewa 12 school 2700091 2180 Independent Districts and Schools MACCRAY School District 270009100365 20 Maccray Senior High Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_11 31.0 0.0 2.0   0.0 0.0     0.0   0.0   13.0 20.0     *   *     *   *   33.0 31 0 2   0 0     0   0   13 20                 33
1880902 MN Fillmore 23 school 2700100 2198 Independent Districts and Schools Fillmore Central 270010000691 456 Fillmore Central Senior High Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_10 42.0 0.0 0.0   0.0 0.0     0.0   3.0   19.0 26.0     *   *     *   *   45.0 42 0 0   0 0     0   3   19 26                 45
1880903 MN Fillmore 23 school 2700100 2198 Independent Districts and Schools Fillmore Central 270010000691 456 Fillmore Central Senior High Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_11 41.0 0.0 1.0   0.0 0.0     0.0   0.0   19.0 23.0     *   *     *   *   42.0 41 0 1   0 0     0   0   19 23                 42
1880904 MN Fillmore 23 school 2700100 2198 Independent Districts and Schools Fillmore Central 270010000691 456 Fillmore Central Senior High Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_12 50.0 0.0 0.0   0.0 0.0     0.0   0.0   21.0 29.0     *   *     *   *   50.0 50 0 0   0 0     0   0   21 29                 50
1880920 MN Kittson 35 school 2791446 2358 Independent Districts and Schools Tri-County School District 279144602314 20 Tri-County Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_7 9.0 0.0 0.0   0.0 0.0     0.0   0.0   4.0 5.0     *   *     *   *   9.0 9 0 0   0 0     0   0   4 5                 9
1880921 MN Kittson 35 school 2791446 2358 Independent Districts and Schools Tri-County School District 279144602314 20 Tri-County Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_8 15.0 0.0 0.0   0.0 0.0     0.0   0.0   8.0 7.0     *   *     10.0   3.0   15.0 15 0 0   0 0     0   0   8 7           10 3   15
1880941 MN Norman 54 school 2791448 2527 Independent Districts and Schools Martin County West School District 279144802318 20 Norman County West Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_7 7.0 1.0 7.0   0.0 0.0     0.0   0.0   10.0 5.0     *   2.0     5.0   4.0   15.0 7 1 7   0 0     0   0   10 5       2   5 4   15
1880945 MN Norman 54 school 2791448 2527 Independent Districts and Schools Martin County West School District 279144802318 20 Norman County West Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_11 5.0 0.0 2.0   1.0 0.0     0.0   1.0   8.0 1.0     *   *     *   *   9.0 5 0 2   1 0     0   1   8 1                 9
1880949 MN Renville 65 school 2705660 2534 Independent Districts and Schools Bird Island-Olivia-Lake Lillian Public School District 270566000147 20 BOLD Senior High Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_7 34.0 0.0 8.0   0.0 1.0     0.0   0.0   16.0 27.0     *   *     *   *   43.0 34 0 8   0 1     0   0   16 27                 43
1880950 MN Renville 65 school 2705660 2534 Independent Districts and Schools Bird Island-Olivia-Lake Lillian Public School District 270566000147 20 BOLD Senior High Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_8 40.0 0.0 4.0   0.0 0.0     0.0   2.0   24.0 22.0     *   *     *   *   46.0 40 0 4   0 0     0   2   24 22                 46
1880951 MN Renville 65 school 2705660 2534 Independent Districts and Schools Bird Island-Olivia-Lake Lillian Public School District 270566000147 20 BOLD Senior High Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_9 48.0 0.0 6.0   0.0 0.0     0.0   3.0   37.0 20.0     *   *     *   *   57.0 48 0 6   0 0     0   3   37 20                 57
1880952 MN Renville 65 school 2705660 2534 Independent Districts and Schools Bird Island-Olivia-Lake Lillian Public School District 270566000147 20 BOLD Senior High Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_10 52.0 1.0 5.0   0.0 1.0     0.0   1.0   30.0 30.0     *   *     *   *   60.0 52 1 5   0 1     0   1   30 30                 60
1880953 MN Renville 65 school 2705660 2534 Independent Districts and Schools Bird Island-Olivia-Lake Lillian Public School District 270566000147 20 BOLD Senior High Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_11 44.0 0.0 4.0   0.0 0.0     0.0   1.0   26.0 23.0     *   *     *   *   49.0 44 0 4   0 0     0   1   26 23                 49
1880954 MN Renville 65 school 2705660 2534 Independent Districts and Schools Bird Island-Olivia-Lake Lillian Public School District 270566000147 20 BOLD Senior High Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_12 39.0 0.0 2.0   1.0 0.0     0.0   0.0   13.0 29.0     *   *     *   *   42.0 39 0 2   1 0     0   0   13 29                 42
1880961 MN Martin 46 school 2713040 2536 Independent Districts and Schools Granada Huntley East Chain 271304000155 20 Granada Huntley East Chain High School Secondary School (Grades 7-12) Regular School No High 06 12 2018   grade_11 7.0 0.0 0.0   0.0 2.0     0.0   0.0   3.0 6.0     *   *     *   *   9.0 7 0 0   0 2     0   0   3 6                 9
1880962 MN Martin 46 school 2713040 2536 Independent Districts and Schools Granada Huntley East Chain 271304000155 20 Granada Huntley East Chain High School Secondary School (Grades 7-12) Regular School No High 06 12 2018   grade_12 19.0 0.0 1.0   0.0 0.0     0.0   1.0   10.0 11.0     *   1.0     *   3.0   21.0 19 0 1   0 0     0   1   10 11       1     3   21
1880966 MN Pine 58 school 2711085 2580 Independent Districts and Schools East Central School District 271108500189 30 East Central Senior Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_9 51.0 4.0 2.0   3.0 0.0     0.0   1.0   30.0 31.0     *   *     *   *   61.0 51 4 2   3 0     0   1   30 31                 61
1880967 MN Pine 58 school 2711085 2580 Independent Districts and Schools East Central School District 271108500189 30 East Central Senior Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_10 41.0 5.0 0.0   4.0 0.0     0.0   1.0   22.0 29.0     *   *     *   *   51.0 41 5 0   4 0     0   1   22 29                 51
1880968 MN Pine 58 school 2711085 2580 Independent Districts and Schools East Central School District 271108500189 30 East Central Senior Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_11 39.0 0.0 2.0   3.0 0.0     0.0   1.0   21.0 24.0     *   *     *   *   45.0 39 0 2   3 0     0   1   21 24                 45
1881023 MN Waseca 81 school 2791451 2835 Independent Districts and Schools Janesville-Waldorf-Pemberton 279145102330 20 Janesville-Waldorf-Pemberton Sec Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_9 48.0 1.0 1.0   0.0 1.0     0.0   2.0   20.0 33.0     *   *     *   *   53.0 48 1 1   0 1     0   2   20 33                 53
1881024 MN Waseca 81 school 2791451 2835 Independent Districts and Schools Janesville-Waldorf-Pemberton 279145102330 20 Janesville-Waldorf-Pemberton Sec Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_10 56.0 0.0 2.0   0.0 0.0     0.0   1.0   25.0 34.0     *   *     *   *   59.0 56 0 2   0 0     0   1   25 34                 59
1881025 MN Waseca 81 school 2791451 2835 Independent Districts and Schools Janesville-Waldorf-Pemberton 279145102330 20 Janesville-Waldorf-Pemberton Sec Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_11 38.0 0.0 0.0   0.0 1.0     0.0   1.0   21.0 19.0     *   *     *   *   40.0 38 0 0   0 1     0   1   21 19                 40
1881026 MN Waseca 81 school 2791451 2835 Independent Districts and Schools Janesville-Waldorf-Pemberton 279145102330 20 Janesville-Waldorf-Pemberton Sec Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_12 51.0 0.0 1.0   0.0 0.0     0.0   1.0   24.0 29.0     *   *     *   *   53.0 51 0 1   0 0     0   1   24 29                 53
1881072 MN Big Stone 6 school 2700150 2888 Independent Districts and Schools Clinton-Graceville-Beardsley 270015000652 3 Clinton-Graceville-Beardsley Sr. Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_7 24.0 0.0 0.0   0.0 0.0     0.0   1.0   9.0 16.0     *   *     *   *   25.0 24 0 0   0 0     0   1   9 16                 25
1881073 MN Big Stone 6 school 2700150 2888 Independent Districts and Schools Clinton-Graceville-Beardsley 270015000652 3 Clinton-Graceville-Beardsley Sr. Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_8 20.0 0.0 0.0   0.0 0.0     0.0   0.0   11.0 9.0     *   *     *   *   20.0 20 0 0   0 0     0   0   11 9                 20
1881074 MN Big Stone 6 school 2700150 2888 Independent Districts and Schools Clinton-Graceville-Beardsley 270015000652 3 Clinton-Graceville-Beardsley Sr. Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_9 23.0 0.0 1.0   0.0 0.0     0.0   2.0   14.0 12.0     *   *     *   *   26.0 23 0 1   0 0     0   2   14 12                 26
1881075 MN Big Stone 6 school 2700150 2888 Independent Districts and Schools Clinton-Graceville-Beardsley 270015000652 3 Clinton-Graceville-Beardsley Sr. Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_10 20.0 0.0 0.0   0.0 0.0     0.0   1.0   10.0 11.0     *   *     *   *   21.0 20 0 0   0 0     0   1   10 11                 21
1881077 MN Big Stone 6 school 2700150 2888 Independent Districts and Schools Clinton-Graceville-Beardsley 270015000652 3 Clinton-Graceville-Beardsley Sr. Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_12 24.0 0.0 0.0   0.0 0.0     0.0   1.0   9.0 16.0     *   *     *   *   25.0 24 0 0   0 0     0   1   9 16                 25
1881132 MN Dakota 19 school 2733270 6 Special Districts and Schools South St. Paul Public School District 273327001456 120 South St. Paul Secondary Secondary School (Grades 7-12) Regular School No High 06 12 2018   grade_9 141.0 23.0 58.0   2.0 8.0     0.0   16.0   121.0 127.0     *   *     *   *   248.0 141 23 58   2 8     0   16   121 127                 248
1881133 MN Dakota 19 school 2733270 6 Special Districts and Schools South St. Paul Public School District 273327001456 120 South St. Paul Secondary Secondary School (Grades 7-12) Regular School No High 06 12 2018   grade_10 160.0 11.0 57.0   1.0 2.0     0.0   11.0   129.0 113.0     *   *     110.0   30.0   242.0 160 11 57   1 2     0   11   129 113           110 30   242
1881137 MN Ramsey 62 school 2708955 4000 Charter Schools City Academy 270895500016 10 City Academy Secondary School (Grades 7-12) Regular School Yes High 09 12 2018   grade_10 1.0 0.0 0.0   0.0 0.0     0.0   0.0   1.0 0.0     *   *     *   *   1.0 1 0 0   0 0     0   0   1 0                 1
1881138 MN Ramsey 62 school 2708955 4000 Charter Schools City Academy 270895500016 10 City Academy Secondary School (Grades 7-12) Regular School Yes High 09 12 2018   grade_11 1.0 0.0 3.0   0.0 5.0     0.0   0.0   5.0 4.0     *   *     *   *   9.0 1 0 3   0 5     0   0   5 4                 9
1881155 MN Hennepin 27 school 2700117 4017 Charter Schools Minnesota Transitions Charter School 270011703262 12 MTS High School Secondary School (Grades 7-12) Regular School Yes High 07 12 2018   grade_7 2.0 37.0 5.0   1.0 0.0     0.0   1.0   21.0 25.0     *   5.0     *   *   46.0 2 37 5   1 0     0   1   21 25       5         46
1881160 MN Hennepin 27 school 2700117 4017 Charter Schools Minnesota Transitions Charter School 270011703262 12 MTS High School Secondary School (Grades 7-12) Regular School Yes High 07 12 2018   grade_12 3.0 12.0 10.0   1.0 1.0     0.0   1.0   20.0 8.0     *   4.0     *   9.0   28.0 3 12 10   1 1     0   1   20 8       4     9   28
1881185 MN Houston 28 school 2700178 4054 Charter Schools La Crescent Montessori and STEM School 270017804750 20 La Crescent Secondary Montessori and STEM Academy Secondary School (Grades 7-12) Regular School Yes High 07 12 2018   grade_7 1.0 0.0 0.0   0.0 0.0     0.0   0.0   1.0 0.0     *   *     *   *   1.0 1 0 0   0 0     0   0   1 0                 1
1881186 MN Houston 28 school 2700178 4054 Charter Schools La Crescent Montessori and STEM School 270017804750 20 La Crescent Secondary Montessori and STEM Academy Secondary School (Grades 7-12) Regular School Yes High 07 12 2018   grade_8 3.0 0.0 0.0   0.0 1.0     0.0   0.0   3.0 1.0     *   *     *   *   4.0 3 0 0   0 1     0   0   3 1                 4
1881187 MN Houston 28 school 2700178 4054 Charter Schools La Crescent Montessori and STEM School 270017804750 20 La Crescent Secondary Montessori and STEM Academy Secondary School (Grades 7-12) Regular School Yes High 07 12 2018   grade_9 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
1881188 MN Houston 28 school 2700178 4054 Charter Schools La Crescent Montessori and STEM School 270017804750 20 La Crescent Secondary Montessori and STEM Academy Secondary School (Grades 7-12) Regular School Yes High 07 12 2018   grade_10 2.0 0.0 0.0   0.0 0.0     0.0   0.0   0.0 2.0     *   *     *   *   2.0 2 0 0   0 0     0   0   0 2                 2
1881189 MN Houston 28 school 2700178 4054 Charter Schools La Crescent Montessori and STEM School 270017804750 20 La Crescent Secondary Montessori and STEM Academy Secondary School (Grades 7-12) Regular School Yes High 07 12 2018   grade_11 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
1881190 MN Houston 28 school 2700178 4054 Charter Schools La Crescent Montessori and STEM School 270017804750 20 La Crescent Secondary Montessori and STEM Academy Secondary School (Grades 7-12) Regular School Yes High 07 12 2018   grade_12 1.0 0.0 0.0   0.0 0.0     0.0   0.0   0.0 1.0     *   *     *   *   1.0 1 0 0   0 0     0   0   0 1                 1
1881193 MN Winona 85 school 2700221 4064 Charter Schools Riverway Learning Community Charter 270022103136 20 Riverway Secondary Secondary School (Grades 7-12) Regular School Yes High 07 12 2018   grade_8 6.0 0.0 0.0   0.0 0.0     0.0   0.0   3.0 3.0     *   *     *   *   6.0 6 0 0   0 0     0   0   3 3                 6
1881194 MN Winona 85 school 2700221 4064 Charter Schools Riverway Learning Community Charter 270022103136 20 Riverway Secondary Secondary School (Grades 7-12) Regular School Yes High 07 12 2018   grade_9 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
1881195 MN Winona 85 school 2700221 4064 Charter Schools Riverway Learning Community Charter 270022103136 20 Riverway Secondary Secondary School (Grades 7-12) Regular School Yes High 07 12 2018   grade_10 5.0 1.0 0.0   0.0 0.0     0.0   0.0   4.0 2.0     *   *     *   *   6.0 5 1 0   0 0     0   0   4 2                 6
1881197 MN Winona 85 school 2700221 4064 Charter Schools Riverway Learning Community Charter 270022103136 20 Riverway Secondary Secondary School (Grades 7-12) Regular School Yes High 07 12 2018   grade_12 3.0 1.0 0.0   0.0 0.0     0.0   2.0   4.0 2.0     *   *     *   *   6.0 3 1 0   0 0     0   2   4 2                 6
1881199 MN Blue Earth 7 school 2700226 4066 Charter Schools Kato Public Charter School 270022603471 10 Kato Public Charter School Secondary School (Grades 7-12) Regular School Yes High 06 12 2018   grade_6 2.0 0.0 1.0   0.0 0.0     0.0   1.0   3.0 1.0     *   *     *   *   4.0 2 0 1   0 0     0   1   3 1                 4
1881200 MN Blue Earth 7 school 2700226 4066 Charter Schools Kato Public Charter School 270022603471 10 Kato Public Charter School Secondary School (Grades 7-12) Regular School Yes High 06 12 2018   grade_7 5.0 0.0 0.0   0.0 0.0     0.0   0.0   4.0 1.0     *   *     *   *   5.0 5 0 0   0 0     0   0   4 1                 5
1881201 MN Blue Earth 7 school 2700226 4066 Charter Schools Kato Public Charter School 270022603471 10 Kato Public Charter School Secondary School (Grades 7-12) Regular School Yes High 06 12 2018   grade_8 7.0 1.0 0.0   0.0 0.0     0.0   1.0   1.0 8.0     *   *     *   *   9.0 7 1 0   0 0     0   1   1 8                 9
1881202 MN Blue Earth 7 school 2700226 4066 Charter Schools Kato Public Charter School 270022603471 10 Kato Public Charter School Secondary School (Grades 7-12) Regular School Yes High 06 12 2018   grade_9 7.0 1.0 1.0   0.0 0.0     0.0   0.0   5.0 4.0     *   *     *   *   9.0 7 1 1   0 0     0   0   5 4                 9
1881214 MN Rice 66 school 2700192 4081 Charter Schools Discovery Public School Faribault 270019203145 10 Discovery Public School Faribault Secondary School (Grades 7-12) Regular School Yes High 06 12 2018   grade_6 1.0 0.0 0.0   0.0 0.0     0.0   0.0   0.0 1.0     *   *     *   *   1.0 1 0 0   0 0     0   0   0 1                 1
1881215 MN Rice 66 school 2700192 4081 Charter Schools Discovery Public School Faribault 270019203145 10 Discovery Public School Faribault Secondary School (Grades 7-12) Regular School Yes High 06 12 2018   grade_7 0.0 0.0 1.0   0.0 0.0     0.0   1.0   0.0 2.0     *   *     *   *   2.0 0 0 1   0 0     0   1   0 2                 2
1881216 MN Rice 66 school 2700192 4081 Charter Schools Discovery Public School Faribault 270019203145 10 Discovery Public School Faribault Secondary School (Grades 7-12) Regular School Yes High 06 12 2018   grade_8 5.0 0.0 1.0   0.0 0.0     0.0   1.0   5.0 2.0     *   *     *   *   7.0 5 0 1   0 0     0   1   5 2                 7
1881218 MN Rice 66 school 2700192 4081 Charter Schools Discovery Public School Faribault 270019203145 10 Discovery Public School Faribault Secondary School (Grades 7-12) Regular School Yes High 06 12 2018   grade_10 7.0 0.0 1.0   0.0 0.0     0.0   0.0   5.0 3.0     *   *     *   *   8.0 7 0 1   0 0     0   0   5 3                 8
1881222 MN Rice 66 school 2700355 4091 Charter Schools Arcadia Charter School 270035504151 10 Arcadia Charter School Secondary School (Grades 7-12) Regular School Yes High 06 12 2018   grade_6 13.0 0.0 0.0   0.0 0.0     0.0   0.0   6.0 7.0     *   *     *   *   13.0 13 0 0   0 0     0   0   6 7                 13
1881225 MN Rice 66 school 2700355 4091 Charter Schools Arcadia Charter School 270035504151 10 Arcadia Charter School Secondary School (Grades 7-12) Regular School Yes High 06 12 2018   grade_9 9.0 0.0 0.0   0.0 0.0     0.0   0.0   4.0 5.0     *   *     *   *   9.0 9 0 0   0 0     0   0   4 5                 9
1881257 MN Washington 82 school 2700358 4116 Charter Schools Lakes International Language Academy 270035804828 20 Lakes International Language Academy-Headwaters Campus Secondary School (Grades 7-12) Regular School Yes High 06 12 2018   grade_11 4.0 0.0 0.0   0.0 1.0     0.0   0.0   0.0 5.0     *   *     *   *   5.0 4 0 0   0 1     0   0   0 5                 5
1881258 MN Washington 82 school 2700358 4116 Charter Schools Lakes International Language Academy 270035804828 20 Lakes International Language Academy-Headwaters Campus Secondary School (Grades 7-12) Regular School Yes High 06 12 2018   grade_12 5.0 0.0 0.0   0.0 0.0     0.0   0.0   1.0 4.0     *   *     *   *   5.0 5 0 0   0 0     0   0   1 4                 5
1881281 MN Itasca 31 school 2700256 4146 Charter Schools Northern Lights Community School 270025603314 10 Northern Lights Community School Secondary School (Grades 7-12) Regular School Yes High 06 12 2018   grade_6 9.0 0.0 0.0   0.0 0.0     0.0   1.0   6.0 4.0     *   *     8.0   5.0   10.0 9 0 0   0 0     0   1   6 4           8 5   10
1881282 MN Itasca 31 school 2700256 4146 Charter Schools Northern Lights Community School 270025603314 10 Northern Lights Community School Secondary School (Grades 7-12) Regular School Yes High 06 12 2018   grade_7 4.0 0.0 0.0   0.0 0.0     0.0   3.0   4.0 3.0     *   *     *   *   7.0 4 0 0   0 0     0   3   4 3                 7
1881297 MN Hennepin 27 school 2700315 4183 Charter Schools Lionsgate Academy 270031504325 10 Lionsgate Academy Secondary School (Grades 7-12) Regular School Yes High 07 12 2018   grade_8 19.0 1.0 0.0   0.0 1.0     0.0   2.0   18.0 5.0     *   *     *   *   23.0 19 1 0   0 1     0   2   18 5                 23
1881299 MN Hennepin 27 school 2700315 4183 Charter Schools Lionsgate Academy 270031504325 10 Lionsgate Academy Secondary School (Grades 7-12) Regular School Yes High 07 12 2018   grade_10 22.0 0.0 0.0   0.0 3.0     0.0   2.0   18.0 9.0     *   *     *   *   27.0 22 0 0   0 3     0   2   18 9                 27
1881300 MN Hennepin 27 school 2700315 4183 Charter Schools Lionsgate Academy 270031504325 10 Lionsgate Academy Secondary School (Grades 7-12) Regular School Yes High 07 12 2018   grade_11 19.0 2.0 0.0   0.0 3.0     0.0   2.0   25.0 1.0     *   *     *   *   26.0 19 2 0   0 3     0   2   25 1                 26
1881301 MN Hennepin 27 school 2700315 4183 Charter Schools Lionsgate Academy 270031504325 10 Lionsgate Academy Secondary School (Grades 7-12) Regular School Yes High 07 12 2018   grade_12 20.0 0.0 0.0   0.0 0.0     0.0   1.0   16.0 5.0     *   *     *   18.0   21.0 20 0 0   0 0     0   1   16 5             18   21
1881302 MN Hennepin 27 school 2700315 4183 Charter Schools Lionsgate Academy 270031504325 10 Lionsgate Academy Secondary School (Grades 7-12) Regular School Yes High 07 12 2018   pk_12_total 117.0 11.0 2.0   0.0 9.0     0.0   10.0   116.0 33.0     *   *     23.0   *   149.0 117 11 2   0 9     0   10   116 33           23     149
1881310 MN Saint Louis 69 school 2700372 4207 Charter Schools Vermilion Country School 270037204555 10 Vermilion Country School Secondary School (Grades 7-12) Regular School Yes High 07 12 2018   grade_7 0.0 0.0 0.0   1.0 0.0     0.0   0.0   0.0 1.0     *   *     *   *   1.0 0 0 0   1 0     0   0   0 1                 1
1881311 MN Saint Louis 69 school 2700372 4207 Charter Schools Vermilion Country School 270037204555 10 Vermilion Country School Secondary School (Grades 7-12) Regular School Yes High 07 12 2018   grade_8 3.0 0.0 0.0   2.0 0.0     0.0   1.0   4.0 2.0     *   *     *   *   6.0 3 0 0   2 0     0   1   4 2                 6
1881312 MN Saint Louis 69 school 2700372 4207 Charter Schools Vermilion Country School 270037204555 10 Vermilion Country School Secondary School (Grades 7-12) Regular School Yes High 07 12 2018   grade_9 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
1881313 MN Saint Louis 69 school 2700372 4207 Charter Schools Vermilion Country School 270037204555 10 Vermilion Country School Secondary School (Grades 7-12) Regular School Yes High 07 12 2018   grade_10 6.0 0.0 0.0   1.0 0.0     0.0   0.0   3.0 4.0     *   *     *   *   7.0 6 0 0   1 0     0   0   3 4                 7
1881317 MN Kandiyohi 34 school 2700389 4217 Charter Schools Technical Academies of Minnesota 270038904696 10 DREAM Technical Academy Secondary School (Grades 7-12) Regular School Yes High 07 12 2018   grade_7 0.0 0.0 6.0   0.0 0.0     0.0   0.0   5.0 1.0     *   *     *   *   6.0 0 0 6   0 0     0   0   5 1                 6
1881318 MN Kandiyohi 34 school 2700389 4217 Charter Schools Technical Academies of Minnesota 270038904696 10 DREAM Technical Academy Secondary School (Grades 7-12) Regular School Yes High 07 12 2018   grade_8 9.0 0.0 6.0   0.0 0.0     0.0   2.0   6.0 11.0     *   *     *   *   17.0 9 0 6   0 0     0   2   6 11                 17
1881320 MN Kandiyohi 34 school 2700389 4217 Charter Schools Technical Academies of Minnesota 270038904696 10 DREAM Technical Academy Secondary School (Grades 7-12) Regular School Yes High 07 12 2018   grade_10 11.0 0.0 4.0   1.0 0.0     0.0   1.0   8.0 9.0     *   *     *   *   17.0 11 0 4   1 0     0   1   8 9                 17
1881321 MN Kandiyohi 34 school 2700389 4217 Charter Schools Technical Academies of Minnesota 270038904696 10 DREAM Technical Academy Secondary School (Grades 7-12) Regular School Yes High 07 12 2018   grade_11 15.0 0.0 2.0   0.0 0.0     0.0   1.0   5.0 13.0     *   *     *   *   18.0 15 0 2   0 0     0   1   5 13                 18
1881322 MN Kandiyohi 34 school 2700389 4217 Charter Schools Technical Academies of Minnesota 270038904696 10 DREAM Technical Academy Secondary School (Grades 7-12) Regular School Yes High 07 12 2018   grade_12 6.0 0.0 5.0   0.0 0.0     0.0   0.0   4.0 7.0     *   *     *   *   11.0 6 0 5   0 0     0   0   4 7                 11
1881324 MN Steele 74 school 2700389 4217 Charter Schools Technical Academies of Minnesota 270038904954 20 CHOICE Technical Academy Secondary School (Grades 7-12) Regular School Yes High 07 12 2018   grade_7 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
1881325 MN Steele 74 school 2700389 4217 Charter Schools Technical Academies of Minnesota 270038904954 20 CHOICE Technical Academy Secondary School (Grades 7-12) Regular School Yes High 07 12 2018   grade_8 9.0 0.0 0.0   0.0 0.0     0.0   0.0   6.0 3.0     *   *     *   *   9.0 9 0 0   0 0     0   0   6 3                 9
1881327 MN Steele 74 school 2700389 4217 Charter Schools Technical Academies of Minnesota 270038904954 20 CHOICE Technical Academy Secondary School (Grades 7-12) Regular School Yes High 07 12 2018   grade_10 4.0 0.0 4.0   0.0 0.0     0.0   1.0   8.0 1.0     *   *     *   *   9.0 4 0 4   0 0     0   1   8 1                 9
1881328 MN Steele 74 school 2700389 4217 Charter Schools Technical Academies of Minnesota 270038904954 20 CHOICE Technical Academy Secondary School (Grades 7-12) Regular School Yes High 07 12 2018   grade_11 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
1881329 MN Steele 74 school 2700389 4217 Charter Schools Technical Academies of Minnesota 270038904954 20 CHOICE Technical Academy Secondary School (Grades 7-12) Regular School Yes High 07 12 2018   grade_12 3.0 0.0 2.0   0.0 0.0     0.0   0.0   5.0 0.0     *   *     *   *   5.0 3 0 2   0 0     0   0   5 0                 5
1881337 MN Wright 86 school 2700403 4229 Charter Schools Jane Goodall Environmental Science Academy 270040304850 10 Jane Goodall Environmental Science Academy Secondary School (Grades 7-12) Regular School Yes High 06 12 2018   grade_6 7.0 0.0 0.0   0.0 0.0     0.0   0.0   5.0 2.0     *   *     *   *   7.0 7 0 0   0 0     0   0   5 2                 7
1881338 MN Wright 86 school 2700403 4229 Charter Schools Jane Goodall Environmental Science Academy 270040304850 10 Jane Goodall Environmental Science Academy Secondary School (Grades 7-12) Regular School Yes High 06 12 2018   grade_7 14.0 1.0 0.0   0.0 0.0     0.0   1.0   11.0 5.0     *   *     *   9.0   16.0 14 1 0   0 0     0   1   11 5             9   16
1881345 MN Ramsey 62 school 2700402 4237 Charter Schools Career Pathways 270040204836 10 Career Pathways Secondary School (Grades 7-12) Regular School Yes High 06 12 2018   grade_6 0.0 0.0 0.0   0.0 0.0     0.0   1.0   0.0 1.0     *   *     *   *   1.0 0 0 0   0 0     0   1   0 1                 1

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