Data source: Big Local News · About: Big Local

680 rows where grade = "grade_7", state = "MN" and year = 2016 sorted by ccd_school_lvl

View and edit SQL

year

  • 2016 · 680

grade

  • grade_7 · 680
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
855285 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 1 PK 08 2016   grade_7 0 0 0   3 0     0   0   1 2         *         *   3 0 0 0   3 0     0   0   1 2                 3
855371 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 1 PK 08 2016   grade_7 0 0 0   24 0     0   0   10 14         *         *   24 0 0 0   24 0     0   0   10 14                 24
855980 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 1 03 07 2016   grade_7 16 0 1   0 0     0   1   10 8     0.0   0.0     2.0   3.0   18 16 0 1   0 0     0   1   10 8     0 0   2 3   18
857748 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 1 KG 08 2016   grade_7 39 4 0   0 1     0   0   21 23     2.0   0.0     11.0   9.0   44 39 4 0   0 1     0   0   21 23     2 0   11 9   44
858069 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 1 PK 08 2016   grade_7 62 5 4   0 16     0   1   43 45         *     14.0   14.0   88 62 5 4   0 16     0   1   43 45           14 14   88
858345 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 1 PK 08 2016   grade_7 6 43 15   0 42     1   7   56 58     39.0   2.0     91.0   14.0   114 6 43 15   0 42     1   7   56 58     39 2   91 14   114
858368 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 1 01 08 2016   grade_7 84 45 13   3 64     0   5   119 95     24.0   0.0     90.0   9.0   214 84 45 13   3 64     0   5   119 95     24 0   90 9   214
858487 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 1 PK 08 2016   grade_7 5 12 10   10 21     0   2   26 34     26.0   0.0     53.0   11.0   60 5 12 10   10 21     0   2   26 34     26 0   53 11   60
859000 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 1 PK 08 2016   grade_7 54 3 5   0 0     0   1   29 34     0.0   0.0     17.0   11.0   63 54 3 5   0 0     0   1   29 34     0 0   17 11   63
860263 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 1 KG 08 2016   grade_7 2 0 0   0 0     0   0   1 1         *         *   2 2 0 0   0 0     0   0   1 1                 2
860504 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 1 PK 08 2016   grade_7 29 2 14   0 0     0   0   19 26     3.0   0.0     18.0   1.0   45 29 2 14   0 0     0   0   19 26     3 0   18 1   45
860515 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 1 PK 08 2016   grade_7 75 0 3   0 0     0   0   44 34     3.0   1.0     21.0   12.0   78 75 0 3   0 0     0   0   44 34     3 1   21 12   78
860580 MN Hennepin 27 school 2721240 1 Special Districts and Schools MINNEAPOLIS PUBLIC SCHOOL DIST. 272124000942 106 BARTON OPEN ELEMENTARY Elementary School (Grades PK-6) Regular School No 1 KG 08 2016   grade_7 54 24 8   2 4     0   1   47 46     14.0   1.0     28.0   6.0   93 54 24 8   2 4     0   1   47 46     14 1   28 6   93
860622 MN Hennepin 27 school 2721240 1 Special Districts and Schools MINNEAPOLIS PUBLIC SCHOOL DIST. 272124000988 134 LK NOKOMIS COMM-KEEWAYDIN CAMPUS Elementary School (Grades PK-6) Regular School No 1 03 08 2016   grade_7 30 15 11   3 0     1   3   26 37     7.0   6.0     39.0   11.0   63 30 15 11   3 0     1   3   26 37     7 6   39 11   63
860693 MN Hennepin 27 school 2721240 1 Special Districts and Schools MINNEAPOLIS PUBLIC SCHOOL DIST. 272124001031 160 SEWARD ELEMENTARY Elementary School (Grades PK-6) Regular School No 1 KG 08 2016   grade_7 32 44 6   2 5     0   0   48 41     25.0   1.0     50.0   7.0   89 32 44 6   2 5     0   0   48 41     25 1   50 7   89
860732 MN Hennepin 27 school 2721240 1 Special Districts and Schools MINNEAPOLIS PUBLIC SCHOOL DIST. 272124001866 175 FOLWELL ARTS MAGNET Elementary School (Grades PK-6) Regular School No 1 PK 08 2016   grade_7 8 29 52   1 3     0   0   41 52         7.0     80.0   11.0   93 8 29 52   1 3     0   0   41 52       7   80 11   93
860743 MN Hennepin 27 school 2721240 1 Special Districts and Schools MINNEAPOLIS PUBLIC SCHOOL DIST. 272124000986 179 JEFFERSON ELEMENTARY Elementary School (Grades PK-6) Regular School No 1 PK 08 2016   grade_7 0 20 25   0 3     0   0   26 22     30.0   6.0         5.0   48 0 20 25   0 3     0   0   26 22     30 6     5   48
860761 MN Hennepin 27 school 2721240 1 Special Districts and Schools MINNEAPOLIS PUBLIC SCHOOL DIST. 272124000932 190 ANDERSEN COMMUNITY Elementary School (Grades PK-6) Regular School No 1 PK 08 2016   grade_7 5 41 66   6 4     0   0   59 63     86.0   14.0         31.0   122 5 41 66   6 4     0   0   59 63     86 14     31   122
860772 MN Hennepin 27 school 2721240 1 Special Districts and Schools MINNEAPOLIS PUBLIC SCHOOL DIST. 272124002297 193 SULLIVAN ELEMENTARY Elementary School (Grades PK-6) Regular School No 1 PK 08 2016   grade_7 3 51 2   4 2     0   1   27 36     36.0   2.0         8.0   63 3 51 2   4 2     0   1   27 36     36 2     8   63
860792 MN Hennepin 27 school 2721240 1 Special Districts and Schools MINNEAPOLIS PUBLIC SCHOOL DIST. 272124004172 225 ANISHINABE ACADEMY Elementary School (Grades PK-6) Regular School No 1 PK 08 2016   grade_7 0 3 3   21 0     0   3   16 14     2.0   7.0         4.0   30 0 3 3   21 0     0   3   16 14     2 7     4   30
860802 MN Hennepin 27 school 2721240 1 Special Districts and Schools MINNEAPOLIS PUBLIC SCHOOL DIST. 272124002144 226 MARCY OPEN ELEMENTARY Elementary School (Grades PK-6) Regular School No 1 KG 08 2016   grade_7 35 27 0   1 4     0   0   36 31     13.0   1.0     34.0   10.0   67 35 27 0   1 4     0   0   36 31     13 1   34 10   67
860868 MN Hennepin 27 school 2721240 1 Special Districts and Schools MINNEAPOLIS PUBLIC SCHOOL DIST. 272124004239 291 HMONG INTERNATIONAL ACADEMY Elementary School (Grades PK-6) Regular School No 1 PK 08 2016   grade_7 1 13 1   0 35     0   0   27 23     27.0   2.0         8.0   50 1 13 1   0 35     0   0   27 23     27 2     8   50
860902 MN Winona 85 school 2705850 4001 Charter Schools BLUFFVIEW MONTESSORI 270585000018 10 BLUFFVIEW MONTESSORI Elementary School (Grades PK-6) Regular School Yes 1 KG 08 2016   grade_7 14 1 0   0 0     0   0   5 10     0.0   0.0     5.0   3.0   15 14 1 0   0 0     0   0   5 10     0 0   5 3   15
860912 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 1 KG 08 2016   grade_7 0 14 1   0 1     0   0   10 6         0.0         3.0   16 0 14 1   0 1     0   0   10 6       0     3   16
860938 MN Hennepin 27 school 2700096 4011 Charter Schools Athlos Leadership Academy 270009601892 10 Athlos Leadership Academy Elementary School (Grades PK-6) Regular School Yes 1 PK 08 2016   grade_7 15 37 6   0 5     0   6   44 25     4.0   0.0     46.0   13.0   69 15 37 6   0 5     0   6   44 25     4 0   46 13   69
860948 MN Ramsey 62 school 2700115 4015 Charter Schools COMMUNITY OF PEACE ACADEMY 270011502605 10 COMMUNITY OF PEACE ACADEMY Elementary School (Grades PK-6) Regular School Yes 1 KG 08 2016   grade_7 7 17 18   0 28     0   2   36 36     11.0   1.0         9.0   72 7 17 18   0 28     0   2   36 36     11 1     9   72
860957 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 1 01 08 2016   grade_7 22 0 0   0 0     0   0   9 13     0.0   0.0     2.0   2.0   22 22 0 0   0 0     0   0   9 13     0 0   2 2   22
860974 MN Hennepin 27 school 2700117 4017 Charter Schools Minnesota Transitions Charter School 270011703566 17 Banaadir Academy Elementary School (Grades PK-6) Regular School Yes 1 KG 08 2016   grade_7 0 37 0   0 0     0   0   19 18         *         *   37 0 37 0   0 0     0   0   19 18                 37
860984 MN Ramsey 62 school 2700118 4018 Charter Schools ACHIEVE LANGUAGE ACADEMY 270011802608 10 ACHIEVE LANGUAGE ACADEMY Elementary School (Grades PK-6) Regular School Yes 1 PK 08 2016   grade_7 2 5 12   0 24     0   1   18 26     29.0   0.0     38.0   11.0   44 2 5 12   0 24     0   1   18 26     29 0   38 11   44
860994 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 1 KG 08 2016   grade_7 111 4 6   4 2     0   20   85 62     1.0   1.0     68.0   31.0   147 111 4 6   4 2     0   20   85 62     1 1   68 31   147
861011 MN Ramsey 62 school 2700140 4027 Charter Schools HIGHER GROUND ACADEMY 270014002719 10 HIGHER GROUND ACADEMY Elementary School (Grades PK-6) Regular School Yes 1 KG 08 2016   grade_7 0 58 0   0 0     0   0   27 31     3.0   0.0         8.0   58 0 58 0   0 0     0   0   27 31     3 0     8   58
861028 MN Hennepin 27 school 2700151 4030 Charter Schools ODYSSEY ACADEMY 270015102946 10 ODYSSEY ACADEMY Elementary School (Grades PK-6) Regular School Yes 1 KG 08 2016   grade_7 5 25 2   0 0     0   2   17 17     5.0   0.0     30.0   5.0   34 5 25 2   0 0     0   2   17 17     5 0   30 5   34
861052 MN Hennepin 27 school 2700159 4038 Charter Schools SOJOURNER TRUTH ACADEMY 270015902954 10 SOJOURNER TRUTH ACADEMY Elementary School (Grades PK-6) Regular School Yes 1 PK 08 2016   grade_7 2 26 10   0 0     0   1   22 17     7.0   2.0     35.0   17.0   39 2 26 10   0 0     0   1   22 17     7 2   35 17   39
861062 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 1 PK 08 2016   grade_7 3 0 1   0 0     0   0   2 2         *         *   4 3 0 1   0 0     0   0   2 2                 4
861104 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 1 KG 08 2016   grade_7 11 0 0   0 0     0   0   9 2     0.0   0.0         4.0   11 11 0 0   0 0     0   0   9 2     0 0     4   11
861128 MN Hennepin 27 school 2700184 4068 Charter Schools EXCELL ACADEMY CHARTER 270018403137 10 EXCELL ACADEMY CHARTER Elementary School (Grades PK-6) Regular School Yes 1 PK 08 2016   grade_7 0 22 1   0 0     0   1   14 10     6.0   2.0         4.0   24 0 22 1   0 0     0   1   14 10     6 2     4   24
861138 MN Ramsey 62 school 2700230 4070 Charter Schools HOPE COMMUNITY ACADEMY 270023003482 10 HOPE COMMUNITY ACADEMY Elementary School (Grades PK-6) Regular School Yes 1 KG 08 2016   grade_7 0 1 0   0 43     0   0   18 26     19.0   0.0     34.0   3.0   44 0 1 0   0 43     0   0   18 26     19 0   34 3   44
861194 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 1 KG 08 2016   grade_7 7 4 0   1 1     0   3   8 8     2.0   0.0     5.0   2.0   16 7 4 0   1 1     0   3   8 8     2 0   5 2   16
861225 MN Cook 16 school 2700339 4100 Charter Schools GREAT EXPECTATIONS 270033904177 10 GREAT EXPECTATIONS Elementary School (Grades PK-6) Regular School Yes 1 KG 08 2016   grade_7 9 0 0   0 0     0   0   5 4         *         *   9 9 0 0   0 0     0   0   5 4                 9
861235 MN Ramsey 62 school 2700342 4103 Charter Schools HMONG COLLEGE PREP ACADEMY 270034203700 20 HMONG COLLEGE PREP MIDDLE ACADEMY Elementary School (Grades PK-6) Regular School Yes 1 KG 08 2016   grade_7 0 0 0   0 108     0   0   63 45     48.0   1.0     95.0   10.0   108 0 0 0   0 108     0   0   63 45     48 1   95 10   108
861285 MN Hennepin 27 school 2700366 4124 Charter Schools BEACON ACADEMY 270036604110 10 BEACON ACADEMY Elementary School (Grades PK-6) Regular School Yes 1 KG 08 2016   grade_7 32 2 4   0 1     0   2   20 21     0.0   0.0     7.0   9.0   41 32 2 4   0 1     0   2   20 21     0 0   7 9   41
861310 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 1 KG 08 2016   grade_7 1 38 0   0 0     0   0   17 22     22.0   0.0         2.0   39 1 38 0   0 0     0   0   17 22     22 0     2   39
861334 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 1 KG 08 2016   grade_7 0 21 0   0 0     0   0   8 13     0.0   0.0     18.0   6.0   21 0 21 0   0 0     0   0   8 13     0 0   18 6   21
861344 MN Hennepin 27 school 2700281 4140 Charter Schools YINGHUA ACADEMY 270028103611 10 YINGHUA ACADEMY Elementary School (Grades PK-6) Regular School Yes 1 KG 08 2016   grade_7 18 1 1   0 32     0   0   18 34     5.0   0.0     5.0   6.0   52 18 1 1   0 32     0   0   18 34     5 0   5 6   52
861354 MN Dakota 19 school 2700251 4141 Charter Schools PAIDEIA ACADEMY CHARTER SCHOOL 270025103576 10 PAIDEIA ACADEMY CHARTER SCHOOL Elementary School (Grades PK-6) Regular School Yes 1 KG 08 2016   grade_7 11 3 3   0 0     0   0   10 7     2.0   0.0     3.0   5.0   17 11 3 3   0 0     0   0   10 7     2 0   3 5   17
861364 MN Stearns 73 school 2700252 4142 Charter Schools Stride Academy Charter School 270025204405 20 Stride Academy K-8 Charter School Elementary School (Grades PK-6) Regular School Yes 1 KG 08 2016   grade_7 26 21 0   0 1     0   0   26 22     13.0   0.0     33.0   6.0   48 26 21 0   0 1     0   0   26 22     13 0   33 6   48
861374 MN Hennepin 27 school 2700253 4143 Charter Schools NEW MILLENNIUM ACADEMY CHARTER SCH 270025303311 10 New Millenium Academy Charter School Elementary School (Grades PK-6) Regular School Yes 1 KG 08 2016   grade_7 0 0 0   0 52     0   1   26 27         0.0     43.0   6.0   53 0 0 0   0 52     0   1   26 27       0   43 6   53
861399 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 1 KG 08 2016   grade_7 33 0 0   0 0     0   1   12 22     0.0   0.0     2.0   5.0   34 33 0 0   0 0     0   1   12 22     0 0   2 5   34
861409 MN Ramsey 62 school 2700263 4153 Charter Schools DUGSI ACADEMY 270026303320 10 DUGSI ACADEMY Elementary School (Grades PK-6) Regular School Yes 1 KG 08 2016   grade_7 0 27 0   0 0     0   0   15 12     19.0   0.0         2.0   27 0 27 0   0 0     0   0   15 12     19 0     2   27
861442 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 1 KG 08 2016   grade_7 4 3 1   1 0     0   1   6 4     0.0   0.0     6.0   1.0   10 4 3 1   1 0     0   1   6 4     0 0   6 1   10
861486 MN Hennepin 27 school 2700295 4171 Charter Schools NOBLE ACADEMY 270029503727 10 NOBLE ACADEMY Elementary School (Grades PK-6) Regular School Yes 1 KG 08 2016   grade_7 0 4 0   0 39     0   0   21 22     26.0   0.0     31.0   7.0   43 0 4 0   0 39     0   0   21 22     26 0   31 7   43
861504 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 1 KG 08 2016   grade_7 0 0 0   0 106     0   0   54 52     75.0   0.0         10.0   106 0 0 0   0 106     0   0   54 52     75 0     10   106
861514 MN Scott 70 school 2700311 4184 Charter Schools ASPEN ACADEMY 270031104282 10 ASPEN ACADEMY Elementary School (Grades PK-6) Regular School Yes 1 KG 08 2016   grade_7 21 1 0   0 1     0   0   10 13     3.0   0.0     5.0   4.0   23 21 1 0   0 1     0   0   10 13     3 0   5 4   23
861524 MN Anoka 2 school 2700320 4185 Charter Schools DAVINCI ACADEMY 270032004268 10 DAVINCI ACADEMY Elementary School (Grades PK-6) Regular School Yes 1 KG 08 2016   grade_7 33 5 3   1 4     0   2   19 29     1.0   0.0     9.0   5.0   48 33 5 3   1 4     0   2   19 29     1 0   9 5   48
861534 MN Anoka 2 school 2700313 4186 Charter Schools GLOBAL ACADEMY 270031304294 10 GLOBAL ACADEMY Elementary School (Grades PK-6) Regular School Yes 1 KG 08 2016   grade_7 11 37 1   0 0     0   1   23 27     7.0   0.0     40.0   3.0   50 11 37 1   0 0     0   1   23 27     7 0   40 3   50
861551 MN Carver 10 school 2700319 4188 Charter Schools COLOGNE ACADEMY 270031904320 10 COLOGNE ACADEMY Elementary School (Grades PK-6) Regular School Yes 1 KG 08 2016   grade_7 39 1 2   0 0     4   0   21 25     0.0   0.0     8.0   9.0   46 39 1 2   0 0     4   0   21 25     0 0   8 9   46
861585 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 1 KG 08 2016   grade_7 14 2 2   0 0     0   1   11 8     2.0   1.0     5.0   3.0   19 14 2 2   0 0     0   1   11 8     2 1   5 3   19
861631 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 1 KG 08 2016   grade_7 6 0 0   0 0     0   0   3 3         *         *   6 6 0 0   0 0     0   0   3 3                 6
861658 MN Dodge 20 school 2700375 4214 Charter Schools WEST CONCORD PUBLIC CHARTER SCHOOL 270037504607 10 WEST CONCORD PUBLIC CHARTER SCHOOL Elementary School (Grades PK-6) Regular School Yes 1 KG 07 2016   grade_7 6 0 0   0 0     0   0   5 1         *         *   6 6 0 0   0 0     0   0   5 1                 6
861667 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 1 PK 08 2016   grade_7 0 0 0   0 7     0   0   4 3         *         *   7 0 0 0   0 7     0   0   4 3                 7
861722 MN Isanti 30 school 2700397 4227 Charter Schools Art and Science Academy 270039704766 10 Art and Science Academy Elementary School (Grades PK-6) Regular School Yes 1 KG 07 2016   grade_7 11 0 0   0 0     0   0   8 3     0.0   0.0     4.0   0.0   11 11 0 0   0 0     0   0   8 3     0 0   4 0   11
861731 MN Washington 82 school 2700401 4228 Charter Schools Woodbury Leadership Academy 270040104812 10 Woodbury Leadership Academy Elementary School (Grades PK-6) Regular School Yes 1 KG 07 2016   grade_7 15 0 0   0 1     0   1   9 8     0.0   0.0     1.0   3.0   17 15 0 0   0 1     0   1   9 8     0 0   1 3   17
861744 MN Ramsey 62 school 2700399 4231 Charter Schools Minnesota Math and Science Academy 270039904788 10 Minnesota Math and Science Academy Elementary School (Grades PK-6) Regular School Yes 1 KG 08 2016   grade_7 0 36 0   0 4     0   3   23 20     23.0   0.0     38.0   0.0   43 0 36 0   0 4     0   3   23 20     23 0   38 0   43
862794 MN Hennepin 27 school 2700309 4192 Charter Schools BEST ACADEMY 270030904773 20 Best Academy K-8 at Penn Middle School (Grades 5-8) Regular School Yes 1 KG 08 2016   grade_7 0 68 2   0 0     0   1   36 35     4.0   0.0     52.0   13.0   71 0 68 2   0 0     0   1   36 35     4 0   52 13   71
864790 MN Hennepin 27 school 2705790 271 Independent Districts and Schools BLOOMINGTON PUBLIC SCHOOL DISTRICT 270579004809 503 SUN Center Special Education Special Education School No 1 KG 08 2016   grade_7 3 3 0   0 1     0   0   6 1         *         *   7 3 3 0   0 1     0   0   6 1                 7
864928 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 1 KG 07 2016   grade_7 1 2 0   0 0     0   1   4 0         *         *   4 1 2 0   0 0     0   1   4 0                 4
864995 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 1 KG 08 2016   grade_7 1 3 1   0 0     0   0   5 0         *         *   5 1 3 1   0 0     0   0   5 0                 5
865113 MN Steele 74 school 2728050 761 Independent Districts and Schools OWATONNA PUBLIC SCHOOL DISTRICT 272805004822 155 Elementary Actions Special Education Special Education School No 1 KG 07 2016   grade_7 0 1 0   0 0     0   0   1 0         *         *   1 0 1 0   0 0     0   0   1 0                 1
865342 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 1 KG 08 2016   grade_7 6 3 1   0 0     0   0   8 2     0.0   0.0     3.0   *   10 6 3 1   0 0     0   0   8 2     0 0   3     10
865516 MN Wright 86 school 2700045 938 Special Education Cooperatives MEEKER AND WRIGHT SPECIAL EDUCATION 270004504351 17 JOURNEYS ALTERNATIVE PROGRAM Special Education Special Education School No 1 KG 08 2016   grade_7 1 0 0   0 0     0   0   1 0         *         *   1 1 0 0   0 0     0   0   1 0                 1
855406 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 2 04 08 2016   grade_7 157 0 2   0 0     0   2   86 75     0.0   2.0     46.0   24.0   161 157 0 2   0 0     0   2   86 75     0 2   46 24   161
856950 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 2 04 08 2016   grade_7 51 38 4   2 2     0   4   44 57     1.0   2.0     41.0   *   101 51 38 4   2 2     0   4   44 57     1 2   41     101
858414 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 2 04 08 2016   grade_7 40 30 19   4 25     0   4   44 78     31.0   1.0     82.0   29.0   122 40 30 19   4 25     0   4   44 78     31 1   82 29   122
860600 MN Hennepin 27 school 2721240 1 Special Districts and Schools MINNEAPOLIS PUBLIC SCHOOL DIST. 272124000969 121 LAKE HARRIET UPPER SCHOOL Elementary School (Grades PK-6) Regular School No 2 04 08 2016   grade_7 108 11 5   0 2     0   1   66 61     5.0   2.0     16.0   15.0   127 108 11 5   0 2     0   1   66 61     5 2   16 15   127
861880 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 2 05 08 2016   grade_7 19 0 0   0 0     0   1   11 9     0.0   0.0     16.0   5.0   20 19 0 0   0 0     0   1   11 9     0 0   16 5   20
861884 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 2 06 08 2016   grade_7 490 50 16   7 23     0   19   281 324     15.0   4.0     215.0   100.0   605 490 50 16   7 23     0   19   281 324     15 4   215 100   605
861888 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 2 06 08 2016   grade_7 258 72 27   2 31     0   16   206 200     29.0   6.0     205.0   54.0   406 258 72 27   2 31     0   16   206 200     29 6   205 54   406
861892 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 2 06 08 2016   grade_7 391 105 44   5 84     0   35   322 342     42.0   6.0     240.0   89.0   664 391 105 44   5 84     0   35   322 342     42 6   240 89   664
861896 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 2 06 08 2016   grade_7 246 39 29   5 36     0   16   187 184     9.0   9.0     153.0   65.0   371 246 39 29   5 36     0   16   187 184     9 9   153 65   371
861900 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 2 06 08 2016   grade_7 357 9 18   3 15     0   8   210 200         *     62.0   *   410 357 9 18   3 15     0   8   210 200           62     410
861904 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 2 06 08 2016   grade_7 306 22 17   2 21     1   11   193 187     6.0   2.0     78.0   45.0   380 306 22 17   2 21     1   11   193 187     6 2   78 45   380
861908 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 2 06 08 2016   grade_7 445 10 23   2 20     0   8   240 268     7.0   4.0     88.0   81.0   508 445 10 23   2 20     0   8   240 268     7 4   88 81   508
861912 MN Anoka 2 school 2709510 13 Independent Districts and Schools COLUMBIA HEIGHTS PUBLIC SCHOOL DIST 270951000395 17 COLUMBIA ACADEMY Middle School (Grades 5-8) Regular School No 2 06 08 2016   grade_7 38 69 71   5 12     2   15   118 94     28.0   4.0     180.0   35.0   212 38 69 71   5 12     2   15   118 94     28 4   180 35   212
861917 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 2 05 08 2016   grade_7 95 68 33   3 20     0   7   113 113         *         *   226 95 68 33   3 20     0   7   113 113                 226
861921 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 2 06 08 2016   grade_7 342 4 10   3 15     0   8   190 192         *         *   382 342 4 10   3 15     0   8   190 192                 382
861925 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 2 06 08 2016   grade_7 231 45 55   1 34     2   25   197 196     30.0   *     174.0   57.0   393 231 45 55   1 34     2   25   197 196     30     174 57   393
861930 MN Becker 3 school 2710230 22 Independent Districts and Schools DETROIT LAKES PUBLIC SCHOOL DIST. 271023000443 4 DETROIT LAKES MIDDLE Middle School (Grades 5-8) Regular School No 2 05 08 2016   grade_7 188 4 5   18 3     0   17   120 115         *         *   235 188 4 5   18 3     0   17   120 115                 235
861934 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 2 06 08 2016   grade_7 271 10 8   61 6     0   14   193 177         *         *   370 271 10 8   61 6     0   14   193 177                 370
861938 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 2 06 08 2016   grade_7 0 0 0   85 0     0   0   42 43     0.0   6.0     76.0   11.0   85 0 0 0   85 0     0   0   42 43     0 6   76 11   85
861942 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 2 06 08 2016   grade_7 301 13 12   1 5     1   14   166 181     0.0   3.0     122.0   56.0   347 301 13 12   1 5     1   14   166 181     0 3   122 56   347
861946 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 2 06 08 2016   grade_7 252 30 11   1 6     0   6   163 143     10.0   *     106.0   38.0   306 252 30 11   1 6     0   6   163 143     10     106 38   306
861950 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 2 06 08 2016   grade_7 131 1 4   27 2     0   19   97 87     0.0   3.0     87.0   30.0   184 131 1 4   27 2     0   19   97 87     0 3   87 30   184
861954 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 2 06 08 2016   grade_7 64 1 0   0 3     0   4   38 34     0.0   1.0     12.0   8.0   72 64 1 0   0 3     0   4   38 34     0 1   12 8   72
861959 MN Carver 10 school 2741460 110 Independent Districts and Schools WACONIA PUBLIC SCHOOL DISTRICT 274146003066 220 CLEARWATER MIDDLE Middle School (Grades 5-8) Regular School No 2 05 08 2016   grade_7 267 2 15   0 5     0   5   147 147     1.0   0.0     34.0   28.0   294 267 2 15   0 5     0   5   147 147     1 0   34 28   294
861963 MN Carver 10 school 2741910 111 Independent Districts and Schools WATERTOWN-MAYER PUBLIC SCHOOL DIST. 274191000024 841 WATERTOWN-MAYER MIDDLE Middle School (Grades 5-8) Regular School No 2 06 08 2016   grade_7 101 0 4   0 2     0   1   50 58     2.0   1.0     19.0   12.0   108 101 0 4   0 2     0   1   50 58     2 1   19 12   108
861967 MN Carver 10 school 2708190 112 Independent Districts and Schools EASTERN CARVER COUNTY PUBLIC SCHOOL 270819000345 61 CHASKA MIDDLE SCHOOL EAST Middle School (Grades 5-8) Regular School No 2 06 08 2016   grade_7 201 3 21   1 10     0   3   141 98     3.0   2.0     29.0   24.0   239 201 3 21   1 10     0   3   141 98     3 2   29 24   239
861971 MN Carver 10 school 2708190 112 Independent Districts and Schools EASTERN CARVER COUNTY PUBLIC SCHOOL 270819002798 62 CHASKA MIDDLE SCHOOL WEST Middle School (Grades 5-8) Regular School No 2 06 08 2016   grade_7 198 10 9   2 17     0   10   125 121     6.0   0.0     43.0   38.0   246 198 10 9   2 17     0   10   125 121     6 0   43 38   246
861975 MN Carver 10 school 2708190 112 Independent Districts and Schools EASTERN CARVER COUNTY PUBLIC SCHOOL 270819003180 63 PIONEER RIDGE MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No 2 06 08 2016   grade_7 137 10 27   1 8     1   2   94 92     8.0   0.0     52.0   27.0   186 137 10 27   1 8     1   2   94 92     8 0   52 27   186
861980 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 2 05 08 2016   grade_7 6 0 4   61 0     0   6   37 40         *         *   77 6 0 4   61 0     0   6   37 40                 77
861985 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 2 05 08 2016   grade_7 67 0 1   0 0     0   0   32 36     0.0   0.0     31.0   15.0   68 67 0 1   0 0     0   0   32 36     0 0   31 15   68

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