Data source: Big Local News · About: Big Local

14,034 rows where state = "MN" and year = 2020 sorted by ell

View and edit SQL

year

  • 2020 · 13,934
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
1826033 MN Swift 76 school 2704470 777 Independent Districts and Schools Benson Public School District 270447000199 101 Benson Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2020   grade_12 46.0 0.0 4.0   0.0 1.0     0.0   1.0   19.0 33.0     *   *     14.0   8.0   52.0 46 0 4   0 1     0   1   19 33           14 8   52
1826057 MN Wabasha 79 school 2741060 811 Independent Districts and Schools Wabasha-Kellogg Public School Dist. 274106001722 40 Wabasha-Kellogg Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2020   grade_7 44.0 2.0 2.0   0.0 0.0     0.0   0.0   22.0 26.0     *   *         *   48.0 44 2 2   0 0     0   0   22 26                 48
1826058 MN Wabasha 79 school 2741060 811 Independent Districts and Schools Wabasha-Kellogg Public School Dist. 274106001722 40 Wabasha-Kellogg Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2020   grade_8 39.0 2.0 2.0   0.0 0.0     0.0   0.0   23.0 20.0     *   *         *   43.0 39 2 2   0 0     0   0   23 20                 43
1826060 MN Wabasha 79 school 2741060 811 Independent Districts and Schools Wabasha-Kellogg Public School Dist. 274106001722 40 Wabasha-Kellogg Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2020   grade_10 33.0 0.0 3.0   0.0 0.0     0.0   0.0   21.0 15.0     *   *         *   36.0 33 0 3   0 0     0   0   21 15                 36
1826085 MN Waseca 81 school 2741880 829 Independent Districts and Schools Waseca Public School District 274188001749 50 Waseca Senior High Secondary School (Grades 7-12) Regular School No High 07 12 2020   grade_9 143.0 5.0 24.0   2.0 0.0     0.0   0.0   80.0 94.0     *   *         *   174.0 143 5 24   2 0     0   0   80 94                 174
1826087 MN Waseca 81 school 2741880 829 Independent Districts and Schools Waseca Public School District 274188001749 50 Waseca Senior High Secondary School (Grades 7-12) Regular School No High 07 12 2020   grade_11 133.0 7.0 22.0   0.0 1.0     0.0   2.0   82.0 83.0     *   *         *   165.0 133 7 22   0 1     0   2   82 83                 165
1826094 MN Watonwan 83 school 2707320 836 Independent Districts and Schools Butterfield Public School District 270732000305 30 Butterfield Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2020   grade_11 5.0 0.0 2.0   0.0 0.0     0.0   0.0   2.0 5.0     *   *         *   7.0 5 0 2   0 0     0   0   2 5                 7
1826095 MN Watonwan 83 school 2707320 836 Independent Districts and Schools Butterfield Public School District 270732000305 30 Butterfield Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2020   grade_12 9.0 0.0 11.0   0.0 0.0     0.0   0.0   12.0 8.0     *   0.0     14.0   4.0   20.0 9 0 11   0 0     0   0   12 8       0   14 4   20
1826100 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 2020   grade_10 21.0 1.0 24.0   0.0 1.0     0.0   1.0   28.0 20.0     *   *         *   48.0 21 1 24   0 1     0   1   28 20                 48
1826101 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 2020   grade_11 18.0 1.0 22.0   0.0 1.0     0.0   4.0   28.0 18.0     *   *         *   46.0 18 1 22   0 1     0   4   28 18                 46
1826103 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 2020   pk_12_total 118.0 5.0 131.0   0.0 2.0     0.0   7.0   142.0 121.0     *   0.0         *   263.0 118 5 131   0 2     0   7   142 121       0         263
1826105 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 2020   grade_7 25.0 0.0 37.0   0.0 0.0     0.0   2.0   30.0 34.0     *   0.0     33.0   8.0   64.0 25 0 37   0 0     0   2   30 34       0   33 8   64
1826111 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 2020   pk_12_total 239.0 0.0 256.0   0.0 2.0     0.0   5.0   254.0 248.0     *   *     260.0   68.0   502.0 239 0 256   0 2     0   5   254 248           260 68   502
1826121 MN Wilkin 84 school 2707450 852 Independent Districts and Schools Campbell-Tintah Public School Dist. 270745000320 20 Campbell-Tintah Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2020   grade_9 6.0 0.0 0.0   0.0 0.0     0.0   1.0   4.0 3.0     *   *         *   7.0 6 0 0   0 0     0   1   4 3                 7
1826124 MN Wilkin 84 school 2707450 852 Independent Districts and Schools Campbell-Tintah Public School Dist. 270745000320 20 Campbell-Tintah Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2020   grade_12 5.0 0.0 1.0   0.0 0.0     0.0   1.0   4.0 3.0     *   *         *   7.0 5 0 1   0 0     0   1   4 3                 7
1826126 MN Winona 85 school 2718090 857 Independent Districts and Schools Lewiston-Altura Public School Dist. 271809000836 30 Lewiston-Altura Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2020   early_childhood_special_ed 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
1826131 MN Winona 85 school 2718090 857 Independent Districts and Schools Lewiston-Altura Public School Dist. 271809000836 30 Lewiston-Altura Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2020   grade_11 56.0 1.0 2.0   0.0 0.0     0.0   0.0   28.0 31.0     *   0.0         7.0   59.0 56 1 2   0 0     0   0   28 31       0     7   59
1826164 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 2020   grade_9 154.0 0.0 2.0   1.0 0.0     0.0   3.0   85.0 75.0     *   *         *   160.0 154 0 2   1 0     0   3   85 75                 160
1826165 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 2020   grade_10 113.0 1.0 2.0   0.0 0.0     0.0   0.0   59.0 57.0     *   *         *   116.0 113 1 2   0 0     0   0   59 57                 116
1826166 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 2020   grade_11 114.0 0.0 3.0   2.0 2.0     0.0   4.0   60.0 65.0     *   *         *   125.0 114 0 3   2 2     0   4   60 65                 125
1826178 MN Blue Earth 7 school 2791445 2071 Independent Districts and Schools Lake Crystal-Wellcome Memorial 279144502312 30 LK CRYSTAL-WELLCOME MEMORIAL SECONDARY Secondary School (Grades 7-12) Regular School No High 06 12 2020   grade_8 64.0 1.0 1.0   0.0 0.0     0.0   1.0   38.0 29.0     *   *         *   67.0 64 1 1   0 0     0   1   38 29                 67
1826180 MN Blue Earth 7 school 2791445 2071 Independent Districts and Schools Lake Crystal-Wellcome Memorial 279144502312 30 LK CRYSTAL-WELLCOME MEMORIAL SECONDARY Secondary School (Grades 7-12) Regular School No High 06 12 2020   grade_10 59.0 1.0 3.0   0.0 0.0     0.0   0.0   30.0 33.0     *   *         *   63.0 59 1 3   0 0     0   0   30 33                 63
1826181 MN Blue Earth 7 school 2791445 2071 Independent Districts and Schools Lake Crystal-Wellcome Memorial 279144502312 30 LK CRYSTAL-WELLCOME MEMORIAL SECONDARY Secondary School (Grades 7-12) Regular School No High 06 12 2020   grade_11 46.0 2.0 2.0   0.0 2.0     0.0   1.0   27.0 26.0     *   *         *   53.0 46 2 2   0 2     0   1   27 26                 53
1826234 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 2020   grade_9 78.0 2.0 2.0   1.0 2.0     0.0   2.0   48.0 39.0     *   *         *   87.0 78 2 2   1 2     0   2   48 39                 87
1826235 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 2020   grade_10 90.0 1.0 3.0   1.0 3.0     0.0   4.0   65.0 37.0     *   *         *   102.0 90 1 3   1 3     0   4   65 37                 102
1826236 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 2020   grade_11 90.0 2.0 2.0   0.0 1.0     0.0   5.0   53.0 47.0     *   *         *   100.0 90 2 2   0 1     0   5   53 47                 100
1826237 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 2020   grade_12 74.0 1.0 4.0   0.0 1.0     0.0   1.0   46.0 35.0     *   *         *   81.0 74 1 4   0 1     0   1   46 35                 81
1826256 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 2020   grade_9 52.0 0.0 3.0   10.0 2.0     0.0   3.0   38.0 32.0     *   *         *   70.0 52 0 3   10 2     0   3   38 32                 70
1826258 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 2020   grade_11 49.0 0.0 2.0   5.0 0.0     0.0   2.0   34.0 24.0     *   *         *   58.0 49 0 2   5 0     0   2   34 24                 58
1826259 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 2020   grade_12 40.0 2.0 2.0   4.0 0.0     0.0   4.0   31.0 21.0     *   *         *   52.0 40 2 2   4 0     0   4   31 21                 52
1826292 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 2020   grade_9 68.0 2.0 0.0   1.0 0.0     0.0   1.0   42.0 30.0     *   *         *   72.0 68 2 0   1 0     0   1   42 30                 72
1826293 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 2020   grade_10 49.0 0.0 1.0   0.0 0.0     1.0   0.0   28.0 23.0     *   *         *   51.0 49 0 1   0 0     1   0   28 23                 51
1826294 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 2020   grade_11 54.0 3.0 0.0   2.0 1.0     0.0   0.0   31.0 29.0     *   *         *   60.0 54 3 0   2 1     0   0   31 29                 60
1826334 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 2020   grade_8 5.0 1.0 0.0   0.0 0.0     0.0   0.0   1.0 5.0     *   *         *   6.0 5 1 0   0 0     0   0   1 5                 6
1826335 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 2020   grade_9 8.0 0.0 0.0   0.0 0.0     0.0   0.0   4.0 4.0     *   *         *   8.0 8 0 0   0 0     0   0   4 4                 8
1826361 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 2020   grade_7 40.0 1.0 3.0   10.0 0.0     0.0   3.0   23.0 34.0     *   *         *   57.0 40 1 3   10 0     0   3   23 34                 57
1826362 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 2020   grade_8 59.0 0.0 0.0   6.0 0.0     0.0   2.0   32.0 35.0     *   *         *   67.0 59 0 0   6 0     0   2   32 35                 67
1826363 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 2020   grade_9 45.0 0.0 3.0   6.0 0.0     0.0   2.0   31.0 25.0     *   *         *   56.0 45 0 3   6 0     0   2   31 25                 56
1826364 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 2020   grade_10 36.0 0.0 3.0   2.0 0.0     0.0   1.0   20.0 22.0     *   *         *   42.0 36 0 3   2 0     0   1   20 22                 42
1826470 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 2020   grade_8 19.0 0.0 0.0   0.0 0.0     0.0   0.0   8.0 11.0     *   *         *   19.0 19 0 0   0 0     0   0   8 11                 19
1826471 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 2020   grade_9 22.0 0.0 1.0   0.0 0.0     0.0   1.0   10.0 14.0     *   *         *   24.0 22 0 1   0 0     0   1   10 14                 24
1826472 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 2020   grade_10 18.0 0.0 0.0   0.0 0.0     0.0   0.0   10.0 8.0     *   *         *   18.0 18 0 0   0 0     0   0   10 8                 18
1826512 MN Red Lake 63 school 2700385 2906 Independent Districts and Schools Red Lake County Central Public Schools 270038504735 20 Red Lake County Central High School Secondary School (Grades 7-12) Regular School No High 07 12 2020   grade_8 22.0 0.0 2.0   1.0 0.0     0.0   0.0   12.0 13.0     *   0.0     12.0   4.0   25.0 22 0 2   1 0     0   0   12 13       0   12 4   25
1826517 MN Red Lake 63 school 2700385 2906 Independent Districts and Schools Red Lake County Central Public Schools 270038504735 20 Red Lake County Central High School Secondary School (Grades 7-12) Regular School No High 07 12 2020   pk_12_total 147.0 2.0 11.0   6.0 0.0     0.0   5.0   89.0 82.0     *   0.0         *   171.0 147 2 11   6 0     0   5   89 82       0         171
1826532 MN Dakota 19 school 2733270 6 Special Districts and Schools South St. Paul Public School Dist. 273327001456 120 South St. Paul Secondary Secondary School (Grades 7-12) Regular School No High 06 12 2020   grade_12 134.0 10.0 45.0   1.0 1.0     0.0   11.0   109.0 93.0     *   1.0     68.0   25.0   202.0 134 10 45   1 1     0   11   109 93       1   68 25   202
1826534 MN Ramsey 62 school 2702264 916 Intermediate Districts and Schools Northeast Metro 916 270226404818 29 Assessment Center Secondary School (Grades 7-12) Regular School No Other KG 12 2020   grade_6 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
1826535 MN Ramsey 62 school 2702264 916 Intermediate Districts and Schools Northeast Metro 916 270226404818 29 Assessment Center Secondary School (Grades 7-12) Regular School No Other KG 12 2020   grade_7 0.0 1.0 0.0   0.0 0.0     0.0   0.0   0.0 1.0     *   *         *   1.0 0 1 0   0 0     0   0   0 1                 1
1826536 MN Ramsey 62 school 2702264 916 Intermediate Districts and Schools Northeast Metro 916 270226404818 29 Assessment Center Secondary School (Grades 7-12) Regular School No Other KG 12 2020   grade_8 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
1826537 MN Ramsey 62 school 2702264 916 Intermediate Districts and Schools Northeast Metro 916 270226404818 29 Assessment Center Secondary School (Grades 7-12) Regular School No Other KG 12 2020   grade_12 0.0 1.0 0.0   0.0 0.0     0.0   0.0   1.0 0.0     *   *         *   1.0 0 1 0   0 0     0   0   1 0                 1
1826538 MN Ramsey 62 school 2702264 916 Intermediate Districts and Schools Northeast Metro 916 270226404818 29 Assessment Center Secondary School (Grades 7-12) Regular School No Other KG 12 2020   pk_12_total 2.0 2.0 0.0   0.0 0.0     0.0   0.0   2.0 2.0     *   *         *   4.0 2 2 0   0 0     0   0   2 2                 4
1826539 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 2020   grade_10 1.0 0.0 0.0   0.0 1.0     0.0   0.0   0.0 2.0     *   *         *   2.0 1 0 0   0 1     0   0   0 2                 2
1826540 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 2020   grade_11 1.0 5.0 3.0   0.0 3.0     0.0   3.0   7.0 8.0     *   0.0     12.0   *   15.0 1 5 3   0 3     0   3   7 8       0   12     15
1826594 MN Houston 28 school 2700178 4054 Charter Schools LA CRESCENT MONTESSORI ACADEMY 270017804750 20 La Crescent Secondary Montessori & STEM Academy Secondary School (Grades 7-12) Regular School Yes High 07 12 2020   grade_7 9.0 0.0 0.0   0.0 0.0     0.0   0.0   7.0 2.0     *   *         *   9.0 9 0 0   0 0     0   0   7 2                 9
1826596 MN Houston 28 school 2700178 4054 Charter Schools LA CRESCENT MONTESSORI ACADEMY 270017804750 20 La Crescent Secondary Montessori & STEM Academy Secondary School (Grades 7-12) Regular School Yes High 07 12 2020   grade_9 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
1826597 MN Houston 28 school 2700178 4054 Charter Schools LA CRESCENT MONTESSORI ACADEMY 270017804750 20 La Crescent Secondary Montessori & STEM Academy Secondary School (Grades 7-12) Regular School Yes High 07 12 2020   grade_10 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
1826598 MN Houston 28 school 2700178 4054 Charter Schools LA CRESCENT MONTESSORI ACADEMY 270017804750 20 La Crescent Secondary Montessori & STEM Academy Secondary School (Grades 7-12) Regular School Yes High 07 12 2020   grade_11 4.0 0.0 0.0   0.0 0.0     0.0   0.0   1.0 3.0     *   *         *   4.0 4 0 0   0 0     0   0   1 3                 4
1826599 MN Houston 28 school 2700178 4054 Charter Schools LA CRESCENT MONTESSORI ACADEMY 270017804750 20 La Crescent Secondary Montessori & STEM Academy Secondary School (Grades 7-12) Regular School Yes High 07 12 2020   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
1826602 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 2020   grade_8 4.0 2.0 0.0   0.0 0.0     0.0   1.0   3.0 4.0     *   *         *   7.0 4 2 0   0 0     0   1   3 4                 7
1826604 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 2020   grade_10 7.0 1.0 0.0   0.0 0.0     0.0   1.0   5.0 4.0     *   *         *   9.0 7 1 0   0 0     0   1   5 4                 9
1826605 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 2020   grade_11 7.0 0.0 0.0   0.0 0.0     0.0   1.0   4.0 4.0     *   *         *   8.0 7 0 0   0 0     0   1   4 4                 8
1826606 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 2020   grade_12 8.0 0.0 0.0   0.0 0.0     0.0   1.0   6.0 3.0     *   *         *   9.0 8 0 0   0 0     0   1   6 3                 9
1826608 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 2020   grade_6 5.0 3.0 0.0   0.0 0.0     0.0   0.0   7.0 1.0     *   *         *   8.0 5 3 0   0 0     0   0   7 1                 8
1826609 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 2020   grade_7 1.0 0.0 0.0   0.0 0.0     0.0   1.0   1.0 1.0     *   *         *   2.0 1 0 0   0 0     0   1   1 1                 2
1826611 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 2020   grade_9 1.0 1.0 0.0   1.0 0.0     0.0   0.0   1.0 2.0     *   *         *   3.0 1 1 0   1 0     0   0   1 2                 3
1826616 MN Ramsey 62 school 2700186 4074 Charter Schools AFSA High School 270018603139 10 AFSA High School Secondary School (Grades 7-12) Regular School Yes High 07 12 2020   grade_8 0.0 1.0 0.0   0.0 0.0     0.0   0.0   1.0 0.0     *   *         *   1.0 0 1 0   0 0     0   0   1 0                 1
1826617 MN Ramsey 62 school 2700186 4074 Charter Schools AFSA High School 270018603139 10 AFSA High School Secondary School (Grades 7-12) Regular School Yes High 07 12 2020   grade_9 27.0 6.0 7.0   0.0 0.0     0.0   1.0   19.0 22.0     *   *     17.0   *   41.0 27 6 7   0 0     0   1   19 22           17     41
1826622 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 2020   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
1826623 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 2020   grade_7 6.0 1.0 0.0   0.0 0.0     0.0   0.0   6.0 1.0     *   *         *   7.0 6 1 0   0 0     0   0   6 1                 7
1826624 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 2020   grade_8 6.0 0.0 3.0   0.0 0.0     0.0   0.0   7.0 2.0     *   *         *   9.0 6 0 3   0 0     0   0   7 2                 9
1826632 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 2020   grade_8 11.0 0.0 1.0   1.0 0.0     0.0   1.0   9.0 5.0     *   0.0         5.0   14.0 11 0 1   1 0     0   1   9 5       0     5   14
1826635 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 2020   grade_11 7.0 0.0 2.0   0.0 0.0     0.0   0.0   5.0 4.0     *   *         *   9.0 7 0 2   0 0     0   0   5 4                 9
1826638 MN Mcleod 43 school 2700214 4093 Charter Schools New Century Academy 270021403275 10 New Century Academy Secondary School (Grades 7-12) Regular School Yes High 06 12 2020   grade_6 6.0 0.0 0.0   0.0 0.0     0.0   0.0   4.0 2.0     *   *         *   6.0 6 0 0   0 0     0   0   4 2                 6
1826639 MN Mcleod 43 school 2700214 4093 Charter Schools New Century Academy 270021403275 10 New Century Academy Secondary School (Grades 7-12) Regular School Yes High 06 12 2020   grade_7 9.0 0.0 0.0   0.0 0.0     0.0   0.0   2.0 7.0     *   *         *   9.0 9 0 0   0 0     0   0   2 7                 9
1826690 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 2020   grade_6 5.0 0.0 0.0   0.0 0.0     0.0   0.0   3.0 2.0     *   *         *   5.0 5 0 0   0 0     0   0   3 2                 5
1826691 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 2020   grade_7 5.0 0.0 2.0   1.0 0.0     0.0   0.0   5.0 3.0     *   *         *   8.0 5 0 2   1 0     0   0   5 3                 8
1826695 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 2020   grade_11 7.0 0.0 0.0   0.0 0.0     0.0   2.0   3.0 6.0     *   *         *   9.0 7 0 0   0 0     0   2   3 6                 9
1826704 MN Hennepin 27 school 2700315 4183 Charter Schools Lionsgate Academy 270031504325 10 Lionsgate Academy - Minnetonka Secondary School (Grades 7-12) Regular School Yes High 07 12 2020   grade_8 16.0 2.0 2.0   0.0 0.0     0.0   3.0   20.0 3.0     *   *     4.0   *   23.0 16 2 2   0 0     0   3   20 3           4     23
1826705 MN Hennepin 27 school 2700315 4183 Charter Schools Lionsgate Academy 270031504325 10 Lionsgate Academy - Minnetonka Secondary School (Grades 7-12) Regular School Yes High 07 12 2020   grade_9 15.0 4.0 1.0   0.0 1.0     0.0   3.0   19.0 5.0     *   *         *   24.0 15 4 1   0 1     0   3   19 5                 24
1826707 MN Hennepin 27 school 2700315 4183 Charter Schools Lionsgate Academy 270031504325 10 Lionsgate Academy - Minnetonka Secondary School (Grades 7-12) Regular School Yes High 07 12 2020   grade_11 21.0 4.0 1.0   0.0 1.0     0.0   0.0   17.0 10.0     *   *     8.0   *   27.0 21 4 1   0 1     0   0   17 10           8     27
1826708 MN Hennepin 27 school 2700315 4183 Charter Schools Lionsgate Academy 270031504325 10 Lionsgate Academy - Minnetonka Secondary School (Grades 7-12) Regular School Yes High 07 12 2020   grade_12 22.0 0.0 0.0   0.0 3.0     0.0   2.0   17.0 10.0     *   *         *   27.0 22 0 0   0 3     0   2   17 10                 27
1826709 MN Hennepin 27 school 2700315 4183 Charter Schools Lionsgate Academy 270031504325 10 Lionsgate Academy - Minnetonka Secondary School (Grades 7-12) Regular School Yes High 07 12 2020   pk_12_total 109.0 14.0 5.0   0.0 9.0     0.0   11.0   107.0 41.0     *   0.0     23.0   *   148.0 109 14 5   0 9     0   11   107 41       0   23     148
1826713 MN Ramsey 62 school 2700315 4183 Charter Schools Lionsgate Academy 270031505148 50 Lionsgate Academy - Shoreview Secondary School (Grades 7-12) Regular School Yes Secondary 07 11 2020   grade_10 19.0 2.0 1.0   1.0 0.0     0.0   1.0   20.0 4.0     *   0.0     7.0   *   24.0 19 2 1   1 0     0   1   20 4       0   7     24
1826715 MN Ramsey 62 school 2700315 4183 Charter Schools Lionsgate Academy 270031505148 50 Lionsgate Academy - Shoreview Secondary School (Grades 7-12) Regular School Yes Secondary 07 11 2020   pk_12_total 83.0 6.0 8.0   1.0 3.0     0.0   10.0   88.0 23.0     *   0.0     26.0   *   111.0 83 6 8   1 3     0   10   88 23       0   26     111
1826724 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 2020   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
1826725 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 2020   grade_8 3.0 0.0 0.0   0.0 0.0     0.0   0.0   2.0 1.0     *   *         *   3.0 3 0 0   0 0     0   0   2 1                 3
1826726 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 2020   grade_9 2.0 0.0 0.0   3.0 0.0     0.0   0.0   0.0 5.0     *   *         *   5.0 2 0 0   3 0     0   0   0 5                 5
1826727 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 2020   grade_10 3.0 0.0 0.0   2.0 0.0     0.0   0.0   2.0 3.0     *   *         *   5.0 3 0 0   2 0     0   0   2 3                 5
1826729 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 2020   grade_12 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
1826733 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 2020   grade_7 6.0 0.0 1.0   0.0 0.0     0.0   0.0   4.0 3.0     *   *         *   7.0 6 0 1   0 0     0   0   4 3                 7
1826734 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 2020   grade_8 4.0 0.0 1.0   0.0 0.0     0.0   2.0   6.0 1.0     *   *         *   7.0 4 0 1   0 0     0   2   6 1                 7
1826735 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 2020   grade_9 3.0 0.0 5.0   0.0 0.0     0.0   3.0   5.0 6.0     *   *         *   11.0 3 0 5   0 0     0   3   5 6                 11
1826736 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 2020   grade_10 11.0 0.0 6.0   0.0 0.0     0.0   1.0   9.0 9.0     *   *         *   18.0 11 0 6   0 0     0   1   9 9                 18
1826737 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 2020   grade_11 5.0 0.0 4.0   0.0 0.0     0.0   0.0   5.0 4.0     *   *         *   9.0 5 0 4   0 0     0   0   5 4                 9
1826740 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 2020   grade_7 3.0 0.0 1.0   0.0 0.0     0.0   0.0   1.0 3.0     *   *         *   4.0 3 0 1   0 0     0   0   1 3                 4
1826741 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 2020   grade_8 2.0 0.0 1.0   0.0 0.0     0.0   0.0   1.0 2.0     *   *         *   3.0 2 0 1   0 0     0   0   1 2                 3
1826742 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 2020   grade_9 4.0 0.0 3.0   0.0 0.0     0.0   1.0   4.0 4.0     *   *         *   8.0 4 0 3   0 0     0   1   4 4                 8
1826743 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 2020   grade_10 5.0 0.0 4.0   0.0 0.0     0.0   0.0   6.0 3.0     *   *         *   9.0 5 0 4   0 0     0   0   6 3                 9
1826744 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 2020   grade_11 7.0 0.0 1.0   0.0 0.0     0.0   3.0   9.0 2.0     *   *         *   11.0 7 0 1   0 0     0   3   9 2                 11
1826755 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 2020   grade_6 11.0 0.0 0.0   0.0 0.0     0.0   0.0   7.0 4.0     *   *     5.0   *   11.0 11 0 0   0 0     0   0   7 4           5     11
1826761 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 2020   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

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