Data source: Big Local News · About: Big Local

711 rows where grade = "grade_8", state = "MN" and year = 2018 sorted by ccd_school_high_grade

View and edit SQL

year

  • 2018 · 711

grade

  • grade_8 · 711
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
1881716 MN Becker 3 school 2728960 25 Independent Districts and Schools Pine Point Public School District 272896000034 70 Pine Point Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 08 2018   grade_8 0.0 0.0 0.0   2.0 0.0     0.0   0.0   1.0 1.0     *   *     *   *   2.0 0 0 0   2 0     0   0   1 1                 2
1881807 MN Beltrami 4 school 2730510 38 Independent Districts and Schools Red Lake Public School District 273051001301 20 Ponemah Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 08 2018   grade_8 0.0 0.0 0.0   6.0 0.0     0.0   0.0   5.0 1.0     *   *     *   *   6.0 0 0 0   6 0     0   0   5 1                 6
1881842 MN Benton 5 school 2712240 51 Independent Districts and Schools Foley Public School District 271224002270 30 Foley Intermediate Elementary Elementary School (Grades PK-6) Regular School No Middle 04 08 2018   grade_8 145.0 0.0 0.0   0.0 0.0     0.0   2.0   78.0 69.0     0.0   0.0     33.0   23.0   147.0 145 0 0   0 0     0   2   78 69     0 0   33 23   147
1882429 MN Dakota 19 school 2711820 192 Independent Districts and Schools Farmington Public School District 271182004816 155 Gateway Academy Elementary School (Grades PK-6) Regular School No Middle 04 08 2018   grade_8 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
1883461 MN Hennepin 27 school 2731780 281 Independent Districts and Schools Robbinsdale Public School District 273178004952 401 The FAIR School - Crystal Elementary School (Grades PK-6) Regular School No Middle 04 08 2018   grade_8 31.0 53.0 8.0   2.0 5.0     0.0   13.0   49.0 63.0     *   *     *   *   112.0 31 53 8   2 5     0   13   49 63                 112
1884309 MN Olmsted 55 school 2731800 535 Independent Districts and Schools Rochester Public School District 273180001005 138 Lincoln K-8 Choice Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 08 2018   grade_8 31.0 4.0 2.0   0.0 4.0     0.0   2.0   19.0 24.0     3.0   0.0     9.0   7.0   43.0 31 4 2   0 4     0   2   19 24     3 0   9 7   43
1884642 MN Ramsey 62 school 2732430 623 Independent Districts and Schools Roseville Public School District 273243001046 73 Parkview Center School Elementary School (Grades PK-6) Regular School No Elementary PK 08 2018   grade_8 62.0 15.0 3.0   0.0 6.0     0.0   2.0   45.0 43.0     *   0.0     19.0   11.0   88.0 62 15 3   0 6     0   2   45 43       0   19 11   88
1884929 MN Ramsey 62 school 2733840 625 Independent Districts and Schools St. Paul Public School District 273384004457 489 Hazel Park Preparatory Academy Elementary School (Grades PK-6) Regular School No Elementary PK 08 2018   grade_8 5.0 37.0 21.0   2.0 34.0     0.0   2.0   55.0 46.0     25.0   6.0     84.0   14.0   101.0 5 37 21   2 34     0   2   55 46     25 6   84 14   101
1884952 MN Ramsey 62 school 2733840 625 Independent Districts and Schools St. Paul Public School District 273384001594 494 Capitol Hill Magnet/Rondo Elementary School (Grades PK-6) Regular School No Elementary 01 08 2018   grade_8 59.0 57.0 12.0   0.0 71.0     0.0   2.0   100.0 101.0     14.0   1.0     104.0   7.0   201.0 59 57 12   0 71     0   2   100 101     14 1   104 7   201
1885002 MN Ramsey 62 school 2733840 625 Independent Districts and Schools St. Paul Public School District 273384001612 528 Linwood Monroe Arts Plus Upper Elementary School (Grades PK-6) Regular School No Middle 04 08 2018   grade_8 48.0 38.0 12.0   0.0 20.0     0.0   5.0   54.0 69.0     28.0   0.0     68.0   22.0   123.0 48 38 12   0 20     0   5   54 69     28 0   68 22   123
1885081 MN Ramsey 62 school 2733840 625 Independent Districts and Schools St. Paul Public School District 273384002303 579 American Indian Magnet School Elementary School (Grades PK-6) Regular School No Elementary PK 08 2018   grade_8 3.0 8.0 14.0   12.0 21.0     0.0   2.0   28.0 32.0     19.0   *     51.0   13.0   60.0 3 8 14   12 21     0   2   28 32     19     51 13   60
1885609 MN Stearns 73 school 2733510 742 Independent Districts and Schools St. Cloud Public School District 273351001485 25 Kennedy Community School Elementary School (Grades PK-6) Regular School No Elementary PK 08 2018   grade_8 57.0 8.0 5.0   0.0 0.0     0.0   1.0   37.0 34.0     6.0   0.0     30.0   12.0   71.0 57 8 5   0 0     0   1   37 34     6 0   30 12   71
1887113 MN Lesueur 40 school 2700379 2905 Independent Districts and Schools Tri-City United School District 270037904626 10 Le Center Pre K-8 Elementary School (Grades PK-6) Regular School No Elementary PK 08 2018   grade_8 41.0 1.0 15.0   0.0 0.0     0.0   0.0   27.0 30.0     *   0.0     27.0   1.0   57.0 41 1 15   0 0     0   0   27 30       0   27 1   57
1887124 MN Lesueur 40 school 2700379 2905 Independent Districts and Schools Tri-City United School District 270037904625 30 Montgomery Pre K-8 Elementary School (Grades PK-6) Regular School No Elementary PK 08 2018   grade_8 73.0 0.0 17.0   0.0 1.0     0.0   3.0   47.0 47.0     *   4.0     41.0   12.0   94.0 73 0 17   0 1     0   3   47 47       4   41 12   94
1887191 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124000942 106 Barton Open Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 08 2018   grade_8 56.0 23.0 3.0   1.0 3.0     0.0   1.0   41.0 46.0     12.0   0.0     23.0   4.0   87.0 56 23 3   1 3     0   1   41 46     12 0   23 4   87
1887213 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124000969 121 Lake Harriet Upper School Elementary School (Grades PK-6) Regular School No Middle 04 08 2018   grade_8 126.0 6.0 11.0   1.0 10.0     0.0   4.0   82.0 76.0     3.0   0.0     10.0   14.0   158.0 126 6 11   1 10     0   4   82 76     3 0   10 14   158
1887234 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124000988 134 Lake Nokomis Community-Keewaydin Campus Elementary School (Grades PK-6) Regular School No Middle 03 08 2018   grade_8 27.0 13.0 14.0   3.0 6.0     0.0   1.0   39.0 25.0     9.0   5.0     30.0   14.0   64.0 27 13 14   3 6     0   1   39 25     9 5   30 14   64
1887305 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124001031 160 Seward Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 08 2018   grade_8 27.0 49.0 8.0   1.0 7.0     0.0   3.0   47.0 48.0     24.0   0.0     50.0   7.0   95.0 27 49 8   1 7     0   3   47 48     24 0   50 7   95
1887344 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124001866 175 Folwell Arts Magnet Elementary School (Grades PK-6) Regular School No Elementary PK 08 2018   grade_8 7.0 27.0 58.0   1.0 2.0     0.0   1.0   48.0 48.0     47.0   1.0     78.0   10.0   96.0 7 27 58   1 2     0   1   48 48     47 1   78 10   96
1887356 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124000986 179 Jefferson Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 08 2018   grade_8 3.0 16.0 31.0   3.0 0.0     0.0   0.0   35.0 18.0     28.0   3.0     44.0   13.0   53.0 3 16 31   3 0     0   0   35 18     28 3   44 13   53
1887375 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124000932 190 Andersen Community Elementary School (Grades PK-6) Regular School No Elementary PK 08 2018   grade_8 1.0 38.0 59.0   2.0 0.0     0.0   0.0   57.0 43.0     59.0   9.0     *   27.0   100.0 1 38 59   2 0     0   0   57 43     59 9     27   100
1887387 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124002297 193 Sullivan Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 08 2018   grade_8 0.0 57.0 5.0   3.0 1.0     0.0   1.0   40.0 27.0     40.0   5.0     *   8.0   67.0 0 57 5   3 1     0   1   40 27     40 5     8   67
1887416 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124002144 226 Marcy Open Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 08 2018   grade_8 40.0 36.0 10.0   2.0 1.0     0.0   1.0   42.0 48.0     12.0   1.0     41.0   12.0   90.0 40 36 10   2 1     0   1   42 48     12 1   41 12   90
1887490 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124004239 291 Hmong International Academy Elementary School (Grades PK-6) Regular School No Elementary PK 08 2018   grade_8 0.0 27.0 1.0   0.0 27.0     0.0   0.0   30.0 25.0     20.0   1.0     48.0   9.0   55.0 0 27 1   0 27     0   0   30 25     20 1   48 9   55
1887532 MN Winona 85 school 2705850 4001 Charter Schools Bluffview Montessori 270585000018 10 Bluffview Montessori Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2018   grade_8 17.0 0.0 0.0   0.0 0.0     0.0   0.0   9.0 8.0     0.0   0.0     3.0   1.0   17.0 17 0 0   0 0     0   0   9 8     0 0   3 1   17
1887543 MN Hennepin 27 school 2700027 4004 Charter Schools Cedar Riverside Community School 270002702340 10 Cedar Riverside Community School Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2018   grade_8 0.0 12.0 1.0   0.0 0.0     0.0   0.0   6.0 7.0     5.0   0.0     *   3.0   13.0 0 12 1   0 0     0   0   6 7     5 0     3   13
1887569 MN Hennepin 27 school 2700096 4011 Charter Schools Athlos Leadership Academy 270009601892 10 Athlos Leadership Academy Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2018   grade_8 9.0 36.0 8.0   0.0 3.0     0.0   16.0   26.0 46.0     4.0   2.0     42.0   9.0   72.0 9 36 8   0 3     0   16   26 46     4 2   42 9   72
1887588 MN Carver 10 school 2700116 4016 Charter Schools World Learner Charter School 270011602606 10 World Learner Charter School Elementary School (Grades PK-6) Regular School Yes Elementary 01 08 2018   grade_8 23.0 1.0 2.0   0.0 1.0     0.0   0.0   14.0 13.0     1.0   0.0     2.0   5.0   27.0 23 1 2   0 1     0   0   14 13     1 0   2 5   27
1887623 MN Ramsey 62 school 2700118 4018 Charter Schools Achieve Language Academy 270011802608 10 Achieve Language Academy Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2018   grade_8 3.0 5.0 16.0   0.0 21.0     0.0   2.0   20.0 27.0     23.0   1.0     25.0   8.0   47.0 3 5 16   0 21     0   2   20 27     23 1   25 8   47
1887633 MN Saint Louis 69 school 2700133 4020 Charter Schools Duluth Public Schools Academy 270013302711 10 North Star Academy Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2018   grade_8 121.0 6.0 7.0   5.0 2.0     0.0   11.0   81.0 71.0     1.0   0.0     51.0   32.0   152.0 121 6 7   5 2     0   11   81 71     1 0   51 32   152
1887650 MN Ramsey 62 school 2700140 4027 Charter Schools Higher Ground Academy 270014002719 10 Higher Ground Academy Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2018   grade_8 0.0 48.0 0.0   0.0 0.0     0.0   0.0   20.0 28.0     5.0   0.0     *   2.0   48.0 0 48 0   0 0     0   0   20 28     5 0     2   48
1887685 MN Hennepin 27 school 2700159 4038 Charter Schools Sojourner Truth Academy 270015902954 10 Sojourner Truth Academy Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2018   grade_8 0.0 24.0 11.0   0.0 0.0     0.0   1.0   15.0 21.0     7.0   2.0     *   9.0   36.0 0 24 11   0 0     0   1   15 21     7 2     9   36
1887695 MN Nicollet 52 school 2700174 4050 Charter Schools Lafayette Public Charter School 270017403042 10 Lafayette Public Charter School Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2018   grade_8 1.0 0.0 0.0   0.0 0.0     0.0   1.0   0.0 2.0     *   *     *   *   2.0 1 0 0   0 0     0   1   0 2                 2
1887703 MN Nicollet 52 school 2700174 4050 Charter Schools Lafayette Public Charter School 270017404126 20 Starland Elementary Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2018   grade_8 3.0 0.0 0.0   0.0 0.0     0.0   0.0   1.0 2.0     *   *     *   *   3.0 3 0 0   0 0     0   0   1 2                 3
1887738 MN Crow Wing 18 school 2700218 4059 Charter Schools Crosslake Community Charter School 270021803475 10 Crosslake Community Charter School Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2018   grade_8 14.0 0.0 0.0   0.0 0.0     0.0   0.0   8.0 6.0     *   *     *   *   14.0 14 0 0   0 0     0   0   8 6                 14
1887766 MN Hennepin 27 school 2700184 4068 Charter Schools Excell Academy Charter 270018403137 10 Excell Academy Charter Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2018   grade_8 0.0 26.0 2.0   0.0 0.0     0.0   0.0   16.0 12.0     7.0   3.0     24.0   11.0   28.0 0 26 2   0 0     0   0   16 12     7 3   24 11   28
1887776 MN Ramsey 62 school 2700230 4070 Charter Schools Hope Community Academy 270023003482 10 Hope Community Academy Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2018   grade_8 0.0 3.0 1.0   0.0 43.0     0.0   0.0   21.0 26.0     14.0   0.0     34.0   5.0   47.0 0 3 1   0 43     0   0   21 26     14 0   34 5   47
1887836 MN Hennepin 27 school 2700354 4089 Charter Schools New City School 270035404849 20 New City School - East Campus Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2018   grade_8 11.0 8.0 2.0   1.0 1.0     0.0   0.0   13.0 10.0     1.0   0.0     9.0   3.0   23.0 11 8 2   1 1     0   0   13 10     1 0   9 3   23
1887869 MN Cook 16 school 2700339 4100 Charter Schools Great Expectations 270033904177 10 Great Expectations Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2018   grade_8 9.0 0.0 0.0   0.0 0.0     0.0   0.0   1.0 8.0     *   *     *   *   9.0 9 0 0   0 0     0   0   1 8                 9
1887879 MN Ramsey 62 school 2700342 4103 Charter Schools Hmong College Prep Academy 270034203700 20 Hmong College Prep Academy MS Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2018   grade_8 0.0 2.0 0.0   0.0 163.0     0.0   0.0   99.0 66.0     35.0   1.0     138.0   18.0   165.0 0 2 0   0 163     0   0   99 66     35 1   138 18   165
1887933 MN Hennepin 27 school 2700366 4124 Charter Schools Beacon Academy 270036604110 10 Beacon Academy Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2018   grade_8 20.0 6.0 3.0   0.0 0.0     0.0   3.0   17.0 15.0     0.0   0.0     10.0   5.0   32.0 20 6 3   0 0     0   3   17 15     0 0   10 5   32
1887958 MN Olmsted 55 school 2700247 4135 Charter Schools Rochester Math and Science Academy 270024703308 10 Rochester Math and Science Academy Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2018   grade_8 1.0 40.0 0.0   0.0 0.0     0.0   0.0   22.0 19.0     12.0   0.0     *   2.0   41.0 1 40 0   0 0     0   0   22 19     12 0     2   41
1887982 MN Hennepin 27 school 2700273 4139 Charter Schools LoveWorks Academy for Arts 270027303575 10 LoveWorks Academy for Arts Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2018   grade_8 0.0 17.0 2.0   0.0 0.0     0.0   0.0   8.0 11.0     1.0   1.0     *   6.0   19.0 0 17 2   0 0     0   0   8 11     1 1     6   19
1887992 MN Hennepin 27 school 2700281 4140 Charter Schools Yinghua Academy 270028103611 10 Yinghua Academy Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2018   grade_8 28.0 2.0 2.0   1.0 17.0     0.0   0.0   22.0 28.0     0.0   0.0     4.0   6.0   50.0 28 2 2   1 17     0   0   22 28     0 0   4 6   50
1888010 MN Hennepin 27 school 2700253 4143 Charter Schools New Millennium Academy Charter School 270025303311 10 New Millenium Academy Charter School Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2018   grade_8 0.0 4.0 3.0   0.0 41.0     0.0   0.0   16.0 32.0     17.0   1.0     30.0   6.0   48.0 0 4 3   0 41     0   0   16 32     17 1   30 6   48
1888035 MN Ramsey 62 school 2700262 4152 Charter Schools Twin Cities German Immersion Charter School 270026203578 10 Twin Cities German Immersion Charter School Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2018   grade_8 31.0 0.0 2.0   0.0 0.0     0.0   2.0   12.0 23.0     1.0   0.0     4.0   4.0   35.0 31 0 2   0 0     0   2   12 23     1 0   4 4   35
1888045 MN Ramsey 62 school 2700263 4153 Charter Schools Dugsi Academy 270026303320 10 Dugsi Academy Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2018   grade_8 0.0 34.0 0.0   0.0 0.0     0.0   0.0   16.0 18.0     30.0   0.0     *   0.0   34.0 0 34 0   0 0     0   0   16 18     30 0     0   34
1888084 MN Hennepin 27 school 2700278 4162 Charter Schools Southside Family Charter School 270027803617 10 Southside Family Charter School Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2018   grade_8 4.0 5.0 2.0   0.0 0.0     0.0   0.0   1.0 10.0     0.0   0.0     5.0   2.0   11.0 4 5 2   0 0     0   0   1 10     0 0   5 2   11
1888130 MN Hennepin 27 school 2700295 4171 Charter Schools Noble Academy 270029503727 10 Noble Academy Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2018   grade_8 0.0 9.0 0.0   0.0 67.0     0.0   1.0   41.0 36.0     35.0   0.0     37.0   1.0   77.0 0 9 0   0 67     0   1   41 36     35 0   37 1   77
1888148 MN Ramsey 62 school 2700304 4181 Charter Schools Community School of Excellence 270030403728 10 Community School of Excellence Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2018   grade_8 0.0 0.0 0.0   0.0 90.0     0.0   0.0   56.0 34.0     45.0   0.0     80.0   8.0   90.0 0 0 0   0 90     0   0   56 34     45 0   80 8   90
1888158 MN Scott 70 school 2700311 4184 Charter Schools Aspen Academy 270031104282 10 Aspen Academy Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2018   grade_8 22.0 0.0 1.0   0.0 2.0     0.0   0.0   4.0 21.0     1.0   1.0     4.0   5.0   25.0 22 0 1   0 2     0   0   4 21     1 1   4 5   25
1888168 MN Anoka 2 school 2700320 4185 Charter Schools DaVinci Academy 270032004268 10 DaVinci Academy Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2018   grade_8 28.0 5.0 2.0   1.0 5.0     0.0   3.0   25.0 19.0     0.0   0.0     9.0   10.0   44.0 28 5 2   1 5     0   3   25 19     0 0   9 10   44
1888178 MN Anoka 2 school 2700313 4186 Charter Schools Global Academy 270031304294 10 Global Academy Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2018   grade_8 9.0 33.0 0.0   0.0 1.0     0.0   0.0   16.0 27.0     6.0   0.0     *   1.0   43.0 9 33 0   0 1     0   0   16 27     6 0     1   43
1888195 MN Carver 10 school 2700319 4188 Charter Schools Cologne Academy 270031904320 10 Cologne Academy Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2018   grade_8 36.0 1.0 2.0   0.0 1.0     1.0   0.0   21.0 20.0     0.0   0.0     3.0   4.0   41.0 36 1 2   0 1     1   0   21 20     0 0   3 4   41
1888217 MN Hennepin 27 school 2700309 4192 Charter Schools Best Academy 270030904261 10 Best Academy East at Olson Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2018   grade_8 0.0 67.0 1.0   0.0 0.0     0.0   1.0   33.0 36.0     16.0   0.0     59.0   11.0   69.0 0 67 1   0 0     0   1   33 36     16 0   59 11   69
1888235 MN Rice 66 school 2700324 4194 Charter Schools Cannon River STEM School 270032404271 10 Cannon River STEM School Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2018   grade_8 22.0 3.0 4.0   0.0 0.0     0.0   0.0   20.0 9.0     2.0   0.0     11.0   4.0   29.0 22 3 4   0 0     0   0   20 9     2 0   11 4   29
1888291 MN Hennepin 27 school 2700378 4208 Charter Schools Nasha Shkola Charter School 270037804635 10 Nasha Shkola Charter School Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2018   grade_8 3.0 0.0 0.0   0.0 0.0     0.0   0.0   1.0 2.0     *   *     *   *   3.0 3 0 0   0 0     0   0   1 2                 3
1888326 MN Ramsey 62 school 2700386 4215 Charter Schools Sejong Academy of Minnesota 270038604695 10 Sejong Academy of Minnesota Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2018   grade_8 0.0 1.0 0.0   0.0 8.0     0.0   0.0   3.0 6.0     *   *     *   *   9.0 0 1 0   0 8     0   0   3 6                 9
1888367 MN Anoka 2 school 2700390 4224 Charter Schools Star of the North Academy Charter School 270039004759 10 Star of the North Academy Charter School Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2018   grade_8 2.0 6.0 0.0   0.0 1.0     0.0   0.0   5.0 4.0     *   *     *   *   9.0 2 6 0   0 1     0   0   5 4                 9
1888378 MN Ramsey 62 school 2700393 4225 Charter Schools Universal Academy Charter School 270039304758 10 Universal Academy Charter School Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2018   grade_8 0.0 18.0 0.0   0.0 1.0     0.0   0.0   5.0 14.0     *   0.0     *   0.0   19.0 0 18 0   0 1     0   0   5 14       0     0   19
1888438 MN Ramsey 62 school 2700408 4233 Charter Schools Level Up Academy 270040804800 10 Level Up Academy Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2018   grade_8 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
1888471 MN Dakota 19 school 2700425 4244 Charter Schools FIT Academy 270042504902 10 FIT Academy Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2018   grade_8 11.0 3.0 1.0   0.0 0.0     0.0   0.0   6.0 9.0     0.0   0.0     5.0   5.0   15.0 11 3 1   0 0     0   0   6 9     0 0   5 5   15
1888632 MN Aitkin 1 school 2714010 2 Independent Districts and Schools Hill City Public School District 271401004653 2 Hill City Middle School Middle School (Grades 5-8) Regular School No Middle 05 08 2018   grade_8 31.0 0.0 0.0   0.0 0.0     0.0   3.0   17.0 17.0     0.0   0.0     20.0   3.0   34.0 31 0 0   0 0     0   3   17 17     0 0   20 3   34
1888636 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000117 3 Anoka Middle School for the Arts Middle School (Grades 5-8) Regular School No Middle 06 08 2018   grade_8 472.0 68.0 39.0   7.0 39.0     0.0   16.0   324.0 317.0     23.0   7.0     213.0   99.0   641.0 472 68 39   7 39     0   16   324 317     23 7   213 99   641
1888640 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000099 4 Coon Rapids Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2018   grade_8 251.0 64.0 38.0   5.0 21.0     0.0   16.0   178.0 217.0     22.0   6.0     183.0   51.0   395.0 251 64 38   5 21     0   16   178 217     22 6   183 51   395
1888644 MN Hennepin 27 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000108 6 Jackson Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2018   grade_8 374.0 128.0 63.0   2.0 111.0     0.0   55.0   384.0 349.0     50.0   7.0     256.0   75.0   733.0 374 128 63   2 111     0   55   384 349     50 7   256 75   733
1888648 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000119 90 Northdale Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2018   grade_8 259.0 48.0 44.0   7.0 39.0     0.0   28.0   220.0 205.0     28.0   11.0     187.0   70.0   425.0 259 48 44   7 39     0   28   220 205     28 11   187 70   425
1888652 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318002501 193 Oak View Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2018   grade_8 369.0 16.0 13.0   5.0 12.0     1.0   7.0   225.0 198.0     2.0   5.0     69.0   *   423.0 369 16 13   5 12     1   7   225 198     2 5   69     423
1888656 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000122 195 Roosevelt Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2018   grade_8 337.0 37.0 18.0   0.0 33.0     0.0   30.0   231.0 224.0     7.0   4.0     114.0   50.0   455.0 337 37 18   0 33     0   30   231 224     7 4   114 50   455
1888660 MN Anoka 2 school 2708100 12 Independent Districts and Schools Centennial Public School District 270810002784 166 Centennial Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2018   grade_8 437.0 15.0 25.0   4.0 21.0     0.0   22.0   262.0 262.0     3.0   5.0     78.0   70.0   524.0 437 15 25   4 21     0   22   262 262     3 5   78 70   524
1888664 MN Anoka 2 school 2709510 13 Independent Districts and Schools Columbia Heights Public School District 270951000395 17 Columbia Academy Middle School (Grades 5-8) Regular School No Middle 06 08 2018   grade_8 43.0 97.0 96.0   1.0 10.0     0.0   19.0   125.0 141.0     50.0   8.0     206.0   36.0   266.0 43 97 96   1 10     0   19   125 141     50 8   206 36   266
1888669 MN Anoka 2 school 2712420 14 Independent Districts and Schools Fridley Public School District 271242000610 23 Fridley Middle Middle School (Grades 5-8) Regular School No Middle 05 08 2018   grade_8 96.0 80.0 29.0   0.0 17.0     0.0   22.0   126.0 118.0     23.0   1.0     157.0   30.0   244.0 96 80 29   0 17     0   22   126 118     23 1   157 30   244
1888673 MN Anoka 2 school 2733540 15 Independent Districts and Schools St. Francis Public School District 273354000013 123 St. Francis Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2018   grade_8 268.0 5.0 11.0   2.0 11.0     0.0   19.0   158.0 158.0     4.0   5.0     71.0   46.0   316.0 268 5 11   2 11     0   19   158 158     4 5   71 46   316
1888677 MN Anoka 2 school 2733330 16 Independent Districts and Schools Spring Lake Park Public Schools 273333001466 92 Westwood Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2018   grade_8 252.0 32.0 73.0   1.0 40.0     1.0   31.0   196.0 234.0     31.0   4.0     135.0   40.0   430.0 252 32 73   1 40     1   31   196 234     31 4   135 40   430
1888682 MN Becker 3 school 2710230 22 Independent Districts and Schools Detroit Lakes Public School District 271023000443 4 Detroit Lakes Middle Middle School (Grades 5-8) Regular School No Middle 05 08 2018   grade_8 152.0 4.0 6.0   17.0 0.0     0.0   32.0   101.0 110.0     *   *     *   *   211.0 152 4 6   17 0     0   32   101 110                 211
1888686 MN Beltrami 4 school 2704440 31 Independent Districts and Schools Bemidji Public School District 270444002031 15 Bemidji Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2018   grade_8 249.0 5.0 9.0   59.0 4.0     0.0   13.0   181.0 158.0     1.0   3.0     149.0   46.0   339.0 249 5 9   59 4     0   13   181 158     1 3   149 46   339
1888690 MN Beltrami 4 school 2730510 38 Independent Districts and Schools Red Lake Public School District 273051002427 40 Red Lake Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2018   grade_8 0.0 0.0 0.0   69.0 0.0     0.0   0.0   35.0 34.0     0.0   11.0     *   *   69.0 0 0 0   69 0     0   0   35 34     0 11         69
1888694 MN Benton 5 school 2732880 47 Independent Districts and Schools Sauk Rapids-Rice Public Schools 273288002246 9 Sauk Rapids-Rice Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2018   grade_8 312.0 10.0 11.0   0.0 3.0     0.0   12.0   176.0 172.0     2.0   2.0     111.0   61.0   348.0 312 10 11   0 3     0   12   176 172     2 2   111 61   348
1888698 MN Nicollet 52 school 2718780 77 Independent Districts and Schools Mankato Public School District 271878002046 190 Dakota Meadows Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2018   grade_8 251.0 27.0 14.0   1.0 7.0     1.0   11.0   179.0 133.0     *   *     *   34.0   312.0 251 27 14   1 7     1   11   179 133             34   312
1888702 MN Blue Earth 7 school 2718780 77 Independent Districts and Schools Mankato Public School District 271878002045 200 Prairie Winds Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2018   grade_8 202.0 50.0 29.0   0.0 6.0     0.0   16.0   167.0 136.0     21.0   *     128.0   30.0   303.0 202 50 29   0 6     0   16   167 136     21     128 30   303
1888707 MN Brown 8 school 2723490 88 Independent Districts and Schools New Ulm Public School District 272349005035 40 New Ulm Middle School Middle School (Grades 5-8) Regular School No Middle 05 08 2018   grade_8 143.0 1.0 6.0   0.0 0.0     0.0   0.0   71.0 79.0     0.0   0.0     38.0   22.0   150.0 143 1 6   0 0     0   0   71 79     0 0   38 22   150
1888712 MN Carlton 9 school 2709420 94 Independent Districts and Schools Cloquet Public School District 270942000381 201 Cloquet Middle Middle School (Grades 5-8) Regular School No Middle 05 08 2018   grade_8 146.0 1.0 1.0   21.0 2.0     0.0   28.0   101.0 98.0     *   *     *   *   199.0 146 1 1   21 2     0   28   101 98                 199
1888716 MN Carver 10 school 2723910 108 Independent Districts and Schools Central Public School District 272391002507 30 Central Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2018   grade_8 68.0 1.0 2.0   0.0 1.0     0.0   3.0   33.0 42.0     2.0   0.0     16.0   8.0   75.0 68 1 2   0 1     0   3   33 42     2 0   16 8   75
1888720 MN Carver 10 school 2741460 110 Independent Districts and Schools Waconia Public School District 274146003066 220 Waconia Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2018   grade_8 274.0 1.0 13.0   1.0 2.0     0.0   5.0   162.0 134.0     3.0   1.0     31.0   35.0   296.0 274 1 13   1 2     0   5   162 134     3 1   31 35   296
1888724 MN Carver 10 school 2741910 111 Independent Districts and Schools Watertown-Mayer Public School District 274191000024 841 Watertown-Mayer Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2018   grade_8 107.0 1.0 2.0   0.0 0.0     0.0   4.0   58.0 56.0     0.0   0.0     27.0   13.0   114.0 107 1 2   0 0     0   4   58 56     0 0   27 13   114
1888728 MN Carver 10 school 2708190 112 Independent Districts and Schools Eastern Carver County Public Schools 270819000345 61 Chaska Middle School East Middle School (Grades 5-8) Regular School No Middle 06 08 2018   grade_8 183.0 3.0 14.0   0.0 2.0     0.0   10.0   98.0 114.0     3.0   *     *   *   212.0 183 3 14   0 2     0   10   98 114     3           212
1888732 MN Carver 10 school 2708190 112 Independent Districts and Schools Eastern Carver County Public Schools 270819002798 62 Chaska Middle School West Middle School (Grades 5-8) Regular School No Middle 06 08 2018   grade_8 169.0 6.0 9.0   0.0 15.0     0.0   10.0   96.0 113.0     *   0.0     21.0   19.0   209.0 169 6 9   0 15     0   10   96 113       0   21 19   209
1888736 MN Carver 10 school 2708190 112 Independent Districts and Schools Eastern Carver County Public Schools 270819003180 63 Pioneer Ridge Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2018   grade_8 165.0 5.0 14.0   0.0 6.0     0.0   11.0   93.0 108.0     4.0   *     28.0   *   201.0 165 5 14   0 6     0   11   93 108     4     28     201
1888741 MN Cass 11 school 2708070 115 Independent Districts and Schools Cass Lake-Bena Public Schools 270807003181 20 Cass Lake-Bena Middle School Middle School (Grades 5-8) Regular School No Middle 05 08 2018   grade_8 6.0 0.0 1.0   68.0 0.0     0.0   6.0   51.0 30.0     *   *     *   *   81.0 6 0 1   68 0     0   6   51 30                 81
1888746 MN Cass 11 school 2728350 116 Independent Districts and Schools Pillager Public School District 272835004841 40 Pillager Middle School Middle School (Grades 5-8) Regular School No Middle 05 08 2018   grade_8 86.0 1.0 2.0   0.0 0.0     0.0   2.0   43.0 48.0     0.0   0.0     46.0   15.0   91.0 86 1 2   0 0     0   2   43 48     0 0   46 15   91
1888756 MN Chisago 13 school 2723820 138 Independent Districts and Schools North Branch Public Schools 272382001164 20 North Branch Middle Middle School (Grades 5-8) Regular School No Middle 05 08 2018   grade_8 235.0 4.0 7.0   3.0 6.0     0.0   2.0   125.0 132.0     *   1.0     79.0   39.0   257.0 235 4 7   3 6     0   2   125 132       1   79 39   257
1888761 MN Clay 14 school 2721420 152 Independent Districts and Schools Moorhead Public School District 272142003512 380 Horizon Middle School Middle School (Grades 5-8) Regular School No Middle 05 08 2018   grade_8 331.0 41.0 41.0   18.0 3.0     1.0   32.0   215.0 252.0     23.0   *     198.0   74.0   467.0 331 41 41   18 3     1   32   215 252     23     198 74   467
1888765 MN Cook 16 school 2713110 166 Independent Districts and Schools Cook County Public Schools 271311002635 40 Cook County Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2018   grade_8 19.0 0.0 2.0   7.0 0.0     0.0   1.0   11.0 18.0     0.0   0.0     12.0   8.0   29.0 19 0 2   7 0     0   1   11 18     0 0   12 8   29
1888771 MN Cottonwood 17 school 2742780 177 Independent Districts and Schools Windom Public School District 274278003068 60 Windom Middle Middle School (Grades 5-8) Regular School No Middle 04 08 2018   grade_8 57.0 2.0 17.0   0.0 2.0     1.0   5.0   47.0 37.0     1.0   0.0     38.0   8.0   84.0 57 2 17   0 2     1   5   47 37     1 0   38 8   84
1888782 MN Crow Wing 18 school 2728200 186 Independent Districts and Schools Pequot Lakes Public Schools 272820003069 15 Pequot Lakes Middle Middle School (Grades 5-8) Regular School No Middle 05 08 2018   grade_8 131.0 1.0 2.0   0.0 0.0     0.0   3.0   75.0 62.0     0.0   0.0     44.0   17.0   137.0 131 1 2   0 0     0   3   75 62     0 0   44 17   137
1888786 MN Dakota 19 school 2707290 191 Independent Districts and Schools Burnsville Public School District 270729000295 15 John Metcalf Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2018   grade_8 57.0 21.0 16.0   0.0 17.0     0.0   12.0   66.0 57.0     *   0.0     42.0   15.0   123.0 57 21 16   0 17     0   12   66 57       0   42 15   123
1888790 MN Scott 70 school 2707290 191 Independent Districts and Schools Burnsville Public School District 270729002639 66 Eagle Ridge Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2018   grade_8 68.0 18.0 20.0   0.0 22.0     0.0   7.0   71.0 64.0     13.0   3.0     46.0   18.0   135.0 68 18 20   0 22     0   7   71 64     13 3   46 18   135
1888794 MN Dakota 19 school 2707290 191 Independent Districts and Schools Burnsville Public School District 270729000297 85 Joseph Nicollet Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2018   grade_8 24.0 7.0 5.0   0.0 2.0     0.0   2.0   26.0 14.0     *   0.0     21.0   13.0   40.0 24 7 5   0 2     0   2   26 14       0   21 13   40
1888798 MN Dakota 19 school 2711820 192 Independent Districts and Schools Farmington Public School District 271182000570 30 Levi P. Dodge Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2018   grade_8 209.0 8.0 20.0   3.0 11.0     0.0   5.0   127.0 129.0     *   0.0     *   *   256.0 209 8 20   3 11     0   5   127 129       0         256
1888802 MN Dakota 19 school 2711820 192 Independent Districts and Schools Farmington Public School District 271182002983 60 Robert Boeckman Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2018   grade_8 255.0 10.0 25.0   0.0 8.0     0.0   14.0   161.0 151.0     10.0   *     65.0   40.0   312.0 255 10 25   0 8     0   14   161 151     10     65 40   312

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