Data source: Big Local News · About: Big Local

678 rows where grade = "grade_7", state = "MN" and year = 2018 sorted by ccd_school_lvl

View and edit SQL

year

  • 2018 · 678

grade

  • grade_7 · 678
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
1881715 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_7 0.0 0.0 0.0   6.0 0.0     0.0   0.0   1.0 5.0     *   *     *   *   6.0 0 0 0   6 0     0   0   1 5                 6
1881806 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_7 0.0 0.0 0.0   21.0 0.0     0.0   1.0   15.0 7.0     *   *     *   *   22.0 0 0 0   21 0     0   1   15 7                 22
1884308 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_7 37.0 1.0 3.0   0.0 0.0     0.0   7.0   23.0 25.0     0.0   0.0     5.0   *   48.0 37 1 3   0 0     0   7   23 25     0 0   5     48
1884641 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_7 56.0 7.0 10.0   0.0 16.0     0.0   2.0   49.0 42.0     *   0.0     18.0   16.0   91.0 56 7 10   0 16     0   2   49 42       0   18 16   91
1884928 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_7 8.0 33.0 11.0   1.0 35.0     0.0   3.0   39.0 52.0     19.0   3.0     71.0   16.0   91.0 8 33 11   1 35     0   3   39 52     19 3   71 16   91
1884951 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_7 82.0 65.0 12.0   0.0 54.0     0.0   4.0   119.0 98.0     13.0   1.0     97.0   9.0   217.0 82 65 12   0 54     0   4   119 98     13 1   97 9   217
1885080 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_7 3.0 15.0 9.0   12.0 14.0     0.0   5.0   31.0 27.0     *   3.0     50.0   16.0   58.0 3 15 9   12 14     0   5   31 27       3   50 16   58
1885608 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_7 61.0 15.0 3.0   1.0 3.0     0.0   5.0   37.0 51.0     9.0   1.0     29.0   14.0   88.0 61 15 3   1 3     0   5   37 51     9 1   29 14   88
1886255 MN Wright 86 school 2707200 877 Independent Districts and Schools Buffalo-Hanover-Montrose Public Schools 270720000286 20 Hanover Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 07 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
1886870 MN Pipestone 59 school 2700108 2689 Independent Districts and Schools Pipestone Area School District 270010803015 6 Heartland Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 08 2018   grade_7 5.0 0.0 0.0   0.0 0.0     0.0   0.0   2.0 3.0     *   *     *   *   5.0 5 0 0   0 0     0   0   2 3                 5
1887112 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_7 14.0 0.0 13.0   0.0 0.0     0.0   3.0   21.0 9.0     7.0   2.0     15.0   6.0   30.0 14 0 13   0 0     0   3   21 9     7 2   15 6   30
1887123 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_7 83.0 1.0 10.0   0.0 0.0     0.0   2.0   56.0 40.0     3.0   0.0     35.0   11.0   96.0 83 1 10   0 0     0   2   56 40     3 0   35 11   96
1887190 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_7 48.0 29.0 5.0   1.0 3.0     1.0   2.0   41.0 48.0     13.0   2.0     35.0   7.0   89.0 48 29 5   1 3     1   2   41 48     13 2   35 7   89
1887304 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_7 40.0 45.0 4.0   3.0 2.0     0.0   1.0   44.0 51.0     26.0   3.0     55.0   7.0   95.0 40 45 4   3 2     0   1   44 51     26 3   55 7   95
1887343 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_7 11.0 22.0 61.0   3.0 1.0     0.0   2.0   57.0 43.0     34.0   0.0     86.0   19.0   100.0 11 22 61   3 1     0   2   57 43     34 0   86 19   100
1887355 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_7 1.0 27.0 27.0   1.0 1.0     0.0   1.0   32.0 26.0     *   2.0     52.0   16.0   58.0 1 27 27   1 1     0   1   32 26       2   52 16   58
1887374 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_7 3.0 33.0 65.0   6.0 1.0     0.0   0.0   52.0 56.0     55.0   6.0     *   20.0   108.0 3 33 65   6 1     0   0   52 56     55 6     20   108
1887386 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_7 0.0 56.0 2.0   2.0 0.0     0.0   1.0   32.0 29.0     39.0   7.0     *   3.0   61.0 0 56 2   2 0     0   1   32 29     39 7     3   61
1887415 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_7 38.0 38.0 11.0   2.0 4.0     0.0   0.0   53.0 40.0     13.0   0.0     50.0   13.0   93.0 38 38 11   2 4     0   0   53 40     13 0   50 13   93
1887489 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_7 0.0 24.0 1.0   0.0 17.0     0.0   2.0   23.0 21.0     14.0   0.0     36.0   10.0   44.0 0 24 1   0 17     0   2   23 21     14 0   36 10   44
1887531 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_7 18.0 1.0 2.0   0.0 0.0     0.0   1.0   11.0 11.0     0.0   0.0     6.0   4.0   22.0 18 1 2   0 0     0   1   11 11     0 0   6 4   22
1887542 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_7 0.0 13.0 0.0   0.0 0.0     0.0   0.0   6.0 7.0     7.0   0.0     *   3.0   13.0 0 13 0   0 0     0   0   6 7     7 0     3   13
1887568 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_7 7.0 53.0 7.0   2.0 3.0     0.0   10.0   36.0 46.0     9.0   0.0     62.0   14.0   82.0 7 53 7   2 3     0   10   36 46     9 0   62 14   82
1887587 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_7 19.0 3.0 0.0   0.0 0.0     0.0   1.0   10.0 13.0     2.0   0.0     2.0   5.0   23.0 19 3 0   0 0     0   1   10 13     2 0   2 5   23
1887622 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_7 3.0 5.0 14.0   1.0 22.0     0.0   1.0   25.0 21.0     22.0   2.0     22.0   6.0   46.0 3 5 14   1 22     0   1   25 21     22 2   22 6   46
1887632 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_7 116.0 5.0 6.0   2.0 0.0     0.0   20.0   83.0 66.0     0.0   1.0     53.0   40.0   149.0 116 5 6   2 0     0   20   83 66     0 1   53 40   149
1887649 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_7 0.0 69.0 0.0   0.0 0.0     0.0   0.0   39.0 30.0     10.0   0.0     *   4.0   69.0 0 69 0   0 0     0   0   39 30     10 0     4   69
1887684 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_7 0.0 33.0 11.0   0.0 0.0     0.0   1.0   22.0 23.0     5.0   5.0     *   9.0   45.0 0 33 11   0 0     0   1   22 23     5 5     9   45
1887694 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_7 10.0 0.0 0.0   0.0 0.0     0.0   0.0   6.0 4.0     0.0   0.0     1.0   1.0   10.0 10 0 0   0 0     0   0   6 4     0 0   1 1   10
1887737 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_7 20.0 0.0 0.0   0.0 0.0     0.0   0.0   12.0 8.0     *   *     *   *   20.0 20 0 0   0 0     0   0   12 8                 20
1887765 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_7 0.0 29.0 3.0   0.0 0.0     0.0   0.0   17.0 15.0     6.0   2.0     *   7.0   32.0 0 29 3   0 0     0   0   17 15     6 2     7   32
1887775 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_7 1.0 3.0 0.0   0.0 46.0     1.0   0.0   25.0 26.0     18.0   0.0     40.0   6.0   51.0 1 3 0   0 46     1   0   25 26     18 0   40 6   51
1887787 MN Ramsey 62 school 2700185 4073 Charter Schools Academia Cesar Chavez Charter School 270018503138 10 Academia Cesar Chavez Charter School Elementary School (Grades PK-6) Regular School Yes Elementary PK 07 2018   grade_7 4.0 0.0 52.0   0.0 1.0     0.0   1.0   26.0 32.0     28.0   2.0     *   11.0   58.0 4 0 52   0 1     0   1   26 32     28 2     11   58
1887835 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_7 7.0 9.0 0.0   0.0 1.0     0.0   2.0   11.0 8.0     4.0   0.0     11.0   1.0   19.0 7 9 0   0 1     0   2   11 8     4 0   11 1   19
1887868 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_7 12.0 0.0 0.0   0.0 0.0     0.0   0.0   7.0 5.0     0.0   0.0     5.0   4.0   12.0 12 0 0   0 0     0   0   7 5     0 0   5 4   12
1887878 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_7 0.0 0.0 1.0   0.0 174.0     0.0   0.0   94.0 81.0     44.0   1.0     148.0   19.0   175.0 0 0 1   0 174     0   0   94 81     44 1   148 19   175
1887932 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_7 34.0 14.0 3.0   0.0 0.0     0.0   0.0   26.0 25.0     1.0   0.0     15.0   6.0   51.0 34 14 3   0 0     0   0   26 25     1 0   15 6   51
1887957 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_7 0.0 41.0 0.0   0.0 0.0     0.0   0.0   25.0 16.0     9.0   0.0     *   5.0   41.0 0 41 0   0 0     0   0   25 16     9 0     5   41
1887981 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_7 0.0 14.0 1.0   0.0 0.0     0.0   0.0   8.0 7.0     0.0   0.0     *   2.0   15.0 0 14 1   0 0     0   0   8 7     0 0     2   15
1887991 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_7 24.0 2.0 2.0   0.0 31.0     0.0   0.0   31.0 28.0     2.0   0.0     5.0   2.0   59.0 24 2 2   0 31     0   0   31 28     2 0   5 2   59
1888009 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_7 0.0 2.0 2.0   0.0 61.0     0.0   0.0   34.0 31.0     32.0   0.0     39.0   8.0   65.0 0 2 2   0 61     0   0   34 31     32 0   39 8   65
1888034 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_7 40.0 0.0 1.0   0.0 0.0     0.0   4.0   14.0 31.0     1.0   0.0     2.0   6.0   45.0 40 0 1   0 0     0   4   14 31     1 0   2 6   45
1888044 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_7 0.0 25.0 0.0   0.0 0.0     0.0   0.0   11.0 14.0     21.0   0.0     *   1.0   25.0 0 25 0   0 0     0   0   11 14     21 0     1   25
1888083 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_7 5.0 3.0 2.0   0.0 0.0     0.0   3.0   6.0 7.0     1.0   0.0     4.0   6.0   13.0 5 3 2   0 0     0   3   6 7     1 0   4 6   13
1888129 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_7 1.0 10.0 1.0   0.0 75.0     0.0   0.0   52.0 35.0     26.0   0.0     42.0   6.0   87.0 1 10 1   0 75     0   0   52 35     26 0   42 6   87
1888147 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_7 0.0 0.0 1.0   0.0 133.0     0.0   0.0   77.0 57.0     64.0   0.0     110.0   19.0   134.0 0 0 1   0 133     0   0   77 57     64 0   110 19   134
1888157 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_7 28.0 4.0 0.0   0.0 3.0     0.0   1.0   18.0 18.0     1.0   0.0     9.0   3.0   36.0 28 4 0   0 3     0   1   18 18     1 0   9 3   36
1888167 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_7 36.0 4.0 2.0   1.0 8.0     0.0   1.0   25.0 27.0     0.0   0.0     10.0   4.0   52.0 36 4 2   1 8     0   1   25 27     0 0   10 4   52
1888177 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_7 9.0 37.0 0.0   0.0 1.0     0.0   0.0   17.0 30.0     5.0   0.0     40.0   5.0   47.0 9 37 0   0 1     0   0   17 30     5 0   40 5   47
1888194 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_7 45.0 1.0 4.0   0.0 1.0     0.0   2.0   29.0 24.0     0.0   0.0     1.0   12.0   53.0 45 1 4   0 1     0   2   29 24     0 0   1 12   53
1888216 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_7 1.0 79.0 1.0   0.0 0.0     0.0   2.0   44.0 39.0     11.0   1.0     72.0   13.0   83.0 1 79 1   0 0     0   2   44 39     11 1   72 13   83
1888234 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_7 33.0 0.0 3.0   1.0 0.0     0.0   0.0   16.0 21.0     0.0   1.0     16.0   7.0   37.0 33 0 3   1 0     0   0   16 21     0 1   16 7   37
1888290 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_7 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
1888307 MN Ramsey 62 school 2700374 4212 Charter Schools West Side Summit Charter School 270037404588 10 West Side Summit Charter School Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2018   grade_7 0.0 5.0 8.0   0.0 0.0     0.0   0.0   5.0 8.0     *   4.0     10.0   2.0   13.0 0 5 8   0 0     0   0   5 8       4   10 2   13
1888325 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_7 0.0 1.0 0.0   0.0 19.0     0.0   0.0   8.0 12.0     *   0.0     *   1.0   20.0 0 1 0   0 19     0   0   8 12       0     1   20
1888366 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_7 6.0 3.0 0.0   0.0 2.0     0.0   0.0   10.0 1.0     *   0.0     7.0   2.0   11.0 6 3 0   0 2     0   0   10 1       0   7 2   11
1888377 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_7 0.0 21.0 0.0   0.0 0.0     0.0   0.0   12.0 9.0     *   0.0     *   2.0   21.0 0 21 0   0 0     0   0   12 9       0     2   21
1888437 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_7 4.0 0.0 0.0   0.0 0.0     0.0   0.0   0.0 4.0     *   *     *   *   4.0 4 0 0   0 0     0   0   0 4                 4
1888470 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_7 17.0 3.0 1.0   0.0 2.0     0.0   2.0   12.0 13.0     1.0   0.0     5.0   8.0   25.0 17 3 1   0 2     0   2   12 13     1 0   5 8   25
1888480 MN Stearns 73 school 2700430 4250 Charter Schools Athlos Academy of Saint Cloud 270043004959 10 Athlos Academy of Saint Cloud Elementary School (Grades PK-6) Regular School Yes Elementary KG 07 2018   grade_7 32.0 26.0 4.0   0.0 1.0     0.0   6.0   38.0 31.0     18.0   1.0     37.0   9.0   69.0 32 26 4   0 1     0   6   38 31     18 1   37 9   69
1891637 MN Ramsey 62 school 2722950 621 Independent Districts and Schools Mounds View Public School District 272295002998 39 Mounds View Bridges Program Special Education Special Education School No Elementary KG 07 2018   grade_7 1.0 1.0 1.0   0.0 0.0     0.0   0.0   3.0 0.0     *   *     *   *   3.0 1 1 1   0 0     0   0   3 0                 3
1891703 MN Ramsey 62 school 2733840 625 Independent Districts and Schools St. Paul Public School District 273384004275 607 Rivereast Program Special Education Special Education School No Elementary KG 08 2018   grade_7 0.0 11.0 2.0   0.0 0.0     0.0   2.0   13.0 2.0     1.0   1.0     11.0   *   15.0 0 11 2   0 0     0   2   13 2     1 1   11     15
1892039 MN Anoka 2 school 2702264 916 Intermediate Districts and Schools Northeast Metro 916 270226404643 40 Karner Blue Education Center Special Education Special Education School No Elementary KG 08 2018   grade_7 4.0 2.0 0.0   0.0 1.0     0.0   0.0   4.0 3.0     *   *     *   *   7.0 4 2 0   0 1     0   0   4 3                 7
1892056 MN Washington 82 school 2702264 916 Intermediate Districts and Schools Northeast Metro 916 270226404951 58 Pankalo Special Education Special Education School No Elementary KG 08 2018   grade_7 3.0 1.0 2.0   0.0 0.0     0.0   1.0   6.0 1.0     *   *     *   *   7.0 3 1 2   0 0     0   1   6 1                 7
1892215 MN Wright 86 school 2700045 938 Special Education Cooperatives Meeker and Wright Special Education 270004502732 18 Eastern Wright Program Special Education Special Education School No Elementary KG 07 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
1879819 MN Aitkin 1 school 2702760 1 Independent Districts and Schools Aitkin Public School District 270276000057 1 Aitkin Secondary School Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_7 93.0 1.0 2.0   0.0 0.0     0.0   4.0   58.0 42.0     1.0   0.0     43.0   17.0   100.0 93 1 2   0 0     0   4   58 42     1 0   43 17   100
1879826 MN Aitkin 1 school 2719170 4 Independent Districts and Schools McGregor Public School District 271917000904 40 McGregor Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_7 26.0 0.0 1.0   8.0 1.0     0.0   1.0   22.0 15.0     *   *     22.0   10.0   37.0 26 0 1   8 1     0   1   22 15           22 10   37
1879833 MN Anoka 2 school 2733330 16 Independent Districts and Schools Spring Lake Park Public Schools 273333004658 788 Secondary Lighthouse Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_7 10.0 0.0 0.0   0.0 0.0     0.0   1.0   6.0 5.0     0.0   0.0     2.0   0.0   11.0 10 0 0   0 0     0   1   6 5     0 0   2 0   11
1879840 MN Becker 3 school 2712360 23 Independent Districts and Schools Frazee-Vergas Public School District 271236000606 20 Frazee Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_7 64.0 1.0 1.0   0.0 0.0     0.0   7.0   32.0 41.0     0.0   3.0     31.0   13.0   73.0 64 1 1   0 0     0   7   32 41     0 3   31 13   73
1879847 MN Beltrami 4 school 2705730 32 Independent Districts and Schools Blackduck Public School District 270573000213 20 Blackduck Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_7 45.0 0.0 0.0   7.0 0.0     0.0   5.0   28.0 29.0     0.0   1.0     40.0   14.0   57.0 45 0 0   7 0     0   5   28 29     0 1   40 14   57
1879854 MN Beltrami 4 school 2717010 36 Independent Districts and Schools Kelliher Public School District 271701000787 20 Kelliher Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_7 9.0 1.0 0.0   15.0 0.0     0.0   0.0   15.0 10.0     0.0   0.0     17.0   9.0   25.0 9 1 0   15 0     0   0   15 10     0 0   17 9   25
1879861 MN Blue Earth 7 school 2733480 75 Independent Districts and Schools St. Clair Public School District 273348001478 20 St. Clair Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_7 53.0 0.0 3.0   0.0 0.0     0.0   2.0   20.0 38.0     0.0   0.0     8.0   5.0   58.0 53 0 3   0 0     0   2   20 38     0 0   8 5   58
1879868 MN Brown 8 school 2709540 81 Independent Districts and Schools Comfrey Public School District 270954000404 20 Comfrey Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_7 11.0 0.0 0.0   0.0 0.0     0.0   0.0   3.0 8.0     0.0   0.0     4.0   1.0   11.0 11 0 0   0 0     0   0   3 8     0 0   4 1   11
1879875 MN Brown 8 school 2733210 84 Independent Districts and Schools Sleepy Eye Public School District 273321001451 20 Sleepy Eye Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_7 22.0 1.0 13.0   0.0 1.0     0.0   0.0   23.0 14.0     5.0   0.0     16.0   5.0   37.0 22 1 13   0 1     0   0   23 14     5 0   16 5   37
1879882 MN Brown 8 school 2733390 85 Independent Districts and Schools Springfield Public School District 273339001471 1 Springfield Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_7 33.0 0.0 5.0   0.0 0.0     0.0   0.0   22.0 16.0     1.0   0.0     15.0   2.0   38.0 33 0 5   0 0     0   0   22 16     1 0   15 2   38
1879889 MN Carlton 9 school 2703690 91 Independent Districts and Schools Barnum Public School District 270369000172 2 Barnum Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_7 50.0 1.0 1.0   0.0 0.0     0.0   4.0   36.0 20.0     0.0   0.0     21.0   7.0   56.0 50 1 1   0 0     0   4   36 20     0 0   21 7   56
1879897 MN Carlton 9 school 2707590 93 Independent Districts and Schools Carlton Public School District 270759000327 1 Carlton Secondary Secondary School (Grades 7-12) Regular School No High 06 12 2018   grade_7 31.0 0.0 0.0   2.0 0.0     0.0   0.0   18.0 15.0     0.0   0.0     15.0   7.0   33.0 31 0 0   2 0     0   0   18 15     0 0   15 7   33
1879904 MN Carlton 9 school 2709690 95 Independent Districts and Schools Cromwell-Wright Public Schools 270969000409 20 Cromwell-Wright Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_7 25.0 0.0 0.0   2.0 0.0     0.0   0.0   15.0 12.0     0.0   0.0     11.0   4.0   27.0 25 0 0   2 0     0   0   15 12     0 0   11 4   27
1879911 MN Carlton 9 school 2721450 97 Independent Districts and Schools Moose Lake Public School District 272145001094 10 Moose Lake Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_7 42.0 0.0 1.0   0.0 0.0     0.0   1.0   24.0 20.0     0.0   0.0     11.0   5.0   44.0 42 0 1   0 0     0   1   24 20     0 0   11 5   44
1879918 MN Carlton 9 school 2738880 99 Independent Districts and Schools Esko Public School District 273888001681 1 Lincoln Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_7 77.0 0.0 1.0   0.0 0.0     0.0   3.0   47.0 34.0     0.0   0.0     8.0   6.0   81.0 77 0 1   0 0     0   3   47 34     0 0   8 6   81
1879925 MN Carlton 9 school 2744190 100 Independent Districts and Schools Wrenshall Public School District 274419001843 2 Wrenshall Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_7 22.0 1.0 0.0   0.0 0.0     0.0   2.0   11.0 14.0     0.0   0.0     19.0   5.0   25.0 22 1 0   0 0     0   2   11 14     0 0   19 5   25
1879932 MN Cass 11 school 2702910 113 Independent Districts and Schools Walker-Hackensack-Akeley School District 270291001737 20 Walker-Hackensack-Akeley Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_7 42.0 2.0 3.0   11.0 0.0     0.0   3.0   31.0 30.0     0.0   3.0     33.0   15.0   61.0 42 2 3   11 0     0   3   31 30     0 3   33 15   61
1879939 MN Cass 11 school 2730870 118 Independent Districts and Schools Northland Community Schools 273087001308 20 Northland Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_7 15.0 0.0 0.0   4.0 0.0     0.0   6.0   14.0 11.0     0.0   0.0     17.0   5.0   25.0 15 0 0   4 0     0   6   14 11     0 0   17 5   25
1879946 MN Chisago 13 school 2732550 139 Independent Districts and Schools Rush City Public School District 273255001406 20 Rush City Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_7 62.0 0.0 1.0   1.0 2.0     0.0   0.0   38.0 28.0     0.0   1.0     23.0   8.0   66.0 62 0 1   1 2     0   0   38 28     0 1   23 8   66
1879953 MN Clay 14 school 2703660 146 Independent Districts and Schools Barnesville Public School District 270366000170 40 Barnesville Secondary Secondary School (Grades 7-12) Regular School No High 06 12 2018   grade_7 65.0 0.0 0.0   0.0 0.0     0.0   2.0   38.0 29.0     0.0   0.0     4.0   3.0   67.0 65 0 0   0 0     0   2   38 29     0 0   4 3   67
1879960 MN Clay 14 school 2713560 150 Independent Districts and Schools Hawley Public School District 271356000699 20 Hawley Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_7 60.0 0.0 1.0   0.0 0.0     1.0   2.0   40.0 24.0     4.0   0.0     9.0   8.0   64.0 60 0 1   0 0     1   2   40 24     4 0   9 8   64
1879967 MN Clearwater 15 school 2703570 162 Independent Districts and Schools Bagley Public School District 270357000165 20 Bagley Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_7 51.0 1.0 1.0   22.0 1.0     0.0   4.0   43.0 37.0     0.0   0.0     44.0   15.0   80.0 51 1 1   22 1     0   4   43 37     0 0   44 15   80
1879974 MN Cottonwood 17 school 2723010 173 Independent Districts and Schools Mountain Lake Public Schools 272301001135 20 Mountain Lake Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_7 27.0 0.0 6.0   0.0 2.0     0.0   1.0   16.0 20.0     2.0   0.0     20.0   6.0   36.0 27 0 6   0 2     0   1   16 20     2 0   20 6   36
1879981 MN Crow Wing 18 school 2709750 182 Independent Districts and Schools Crosby-Ironton Public School District 270975000417 1 Crosby-Ironton Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_7 76.0 0.0 1.0   0.0 0.0     0.0   4.0   46.0 35.0     0.0   0.0     41.0   16.0   81.0 76 0 1   0 0     0   4   46 35     0 0   41 16   81
1879988 MN Dakota 19 school 2730150 195 Independent Districts and Schools Randolph Public School District 273015001287 20 Randolph Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_7 46.0 0.0 0.0   0.0 0.0     0.0   1.0   27.0 20.0     0.0   0.0     5.0   6.0   47.0 46 0 0   0 0     0   1   27 20     0 0   5 6   47
1879996 MN Dodge 20 school 2713590 203 Independent Districts and Schools Hayfield Public School District 271359000702 1 Hayfield Secondary Secondary School (Grades 7-12) Regular School No High 06 12 2018   grade_7 51.0 0.0 5.0   0.0 0.0     0.0   2.0   28.0 30.0     1.0   0.0     17.0   6.0   58.0 51 0 5   0 0     0   2   28 30     1 0   17 6   58
1880003 MN Douglas 21 school 2725140 213 Independent Districts and Schools Osakis Public School District 272514001204 20 Osakis Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_7 73.0 1.0 2.0   0.0 1.0     0.0   0.0   45.0 32.0     0.0   1.0     29.0   9.0   77.0 73 1 2   0 1     0   0   45 32     0 1   29 9   77
1880010 MN Olmsted 55 school 2708220 227 Independent Districts and Schools Chatfield Public Schools 270822000348 1 Chatfield Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_7 86.0 1.0 1.0   0.0 1.0     0.0   0.0   43.0 46.0     0.0   0.0     17.0   11.0   89.0 86 1 1   0 1     0   0   43 46     0 0   17 11   89
1880017 MN Fillmore 23 school 2717910 229 Independent Districts and Schools Lanesboro Public School District 271791000824 20 Lanesboro Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_7 28.0 0.0 1.0   0.0 0.0     0.0   0.0   17.0 12.0     0.0   0.0     16.0   3.0   29.0 28 0 1   0 0     0   0   17 12     0 0   16 3   29
1880024 MN Fillmore 23 school 2718540 238 Independent Districts and Schools Mabel-Canton Public School District 271854000858 2 Mabel-Canton Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_7 20.0 0.0 1.0   0.0 0.0     0.0   0.0   13.0 8.0     0.0   0.0     8.0   4.0   21.0 20 0 1   0 0     0   0   13 8     0 0   8 4   21
1880031 MN Freeborn 24 school 2703030 242 Independent Districts and Schools Alden-Conger Public School District 270303000080 1 Alden-Conger Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_7 37.0 0.0 3.0   0.0 0.0     0.0   1.0   15.0 26.0     0.0   0.0     11.0   6.0   41.0 37 0 3   0 0     0   1   15 26     0 0   11 6   41
1880039 MN Goodhue 25 school 2707500 252 Independent Districts and Schools Cannon Falls Public School District 270750000324 2 Cannon Falls Secondary Secondary School (Grades 7-12) Regular School No High 06 12 2018   grade_7 83.0 1.0 4.0   1.0 0.0     0.0   7.0   50.0 46.0     0.0   0.0     29.0   11.0   96.0 83 1 4   1 0     0   7   50 46     0 0   29 11   96
1880046 MN Goodhue 25 school 2712900 253 Independent Districts and Schools Goodhue Public School District 271290000648 2 Goodhue Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_7 44.0 0.0 6.0   0.0 0.0     0.0   0.0   27.0 23.0     5.0   0.0     4.0   3.0   50.0 44 0 6   0 0     0   0   27 23     5 0   4 3   50
1880059 MN Grant 26 school 2703300 261 Independent Districts and Schools Ashby Public School District 270330000137 20 Ashby Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_7 16.0 0.0 1.0   0.0 0.0     0.0   0.0   7.0 10.0     0.0   0.0     6.0   2.0   17.0 16 0 1   0 0     0   0   7 10     0 0   6 2   17
1880066 MN Grant 26 school 2713890 264 Independent Districts and Schools Herman-Norcross School District 271389000714 2 Herman Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_7 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

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