Data source: Big Local News · About: Big Local

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

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
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
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
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
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
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
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
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
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
1880107 MN Isanti 30 school 2706060 314 Independent Districts and Schools Braham Public School District 270606000247 1 Braham Area Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_7 52.0 1.0 1.0   0.0 0.0     0.0   2.0   23.0 33.0     0.0   0.0     24.0   6.0   56.0 52 1 1   0 0     0   2   23 33     0 0   24 6   56
1880115 MN Itasca 31 school 2710140 317 Independent Districts and Schools Deer River Public School District 271014000433 1 Deer River Secondary Secondary School (Grades 7-12) Regular School No High 06 12 2018   grade_7 27.0 0.0 6.0   21.0 0.0     0.0   12.0   39.0 27.0     0.0   1.0     48.0   18.0   66.0 27 0 6   21 0     0   12   39 27     0 1   48 18   66
1880166 MN Koochiching 36 school 2715000 361 Independent Districts and Schools International Falls School District 271500000761 1 Falls Secondary Secondary School (Grades 7-12) Regular School No High 06 12 2018   grade_7 70.0 1.0 0.0   7.0 0.0     0.0   2.0   44.0 36.0     0.0   0.0     24.0   13.0   80.0 70 1 0   7 0     0   2   44 36     0 0   24 13   80
1880826 MN Wadena 80 school 2700022 2155 Independent Districts and Schools Wadena-Deer Creek School District 270002201733 1 Wadena-Deer Creek Senior High Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_7 74.0 5.0 2.0   0.0 1.0     0.0   3.0   47.0 38.0     0.0   0.0     44.0   19.0   85.0 74 5 2   0 1     0   3   47 38     0 0   44 19   85
1881107 MN Lyon 42 school 2700326 2904 Independent Districts and Schools Tracy Area Public School District 270032604389 1 Tracy Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_7 49.0 2.0 2.0   0.0 9.0     0.0   0.0   25.0 37.0     5.0   0.0     33.0   9.0   62.0 49 2 2   0 9     0   0   25 37     5 0   33 9   62
1889202 MN Saint Louis 69 school 2711520 696 Independent Districts and Schools Ely Public School District 271152004645 1 Memorial Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2018   grade_7 47.0 1.0 0.0   0.0 0.0     0.0   4.0   27.0 25.0     0.0   0.0     16.0   7.0   52.0 47 1 0   0 0     0   4   27 25     0 0   16 7   52
1891879 MN Rice 66 school 2700129 160 State Operated Schools (which include MN Academy Deaf & Blind, School for the Arts) Minnesota State Academies 270012903056 1 Minnesota Academy for the Blind Special Education Special Education School No Other PK 12 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
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
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
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
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
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
1880230 MN Lyon 42 school 2721270 414 Independent Districts and Schools Minneota Public School District 272127001068 2 Minneota Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_7 34.0 0.0 5.0   0.0 0.0     0.0   0.0   20.0 19.0     5.0   0.0     12.0   2.0   39.0 34 0 5   0 0     0   0   20 19     5 0   12 2   39
1880440 MN Polk 60 school 2712180 600 Independent Districts and Schools Fisher Public School District 271218000586 2 Fisher Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_7 16.0 3.0 2.0   0.0 1.0     0.0   1.0   13.0 10.0     1.0   0.0     18.0   7.0   23.0 16 3 2   0 1     0   1   13 10     1 0   18 7   23
1880566 MN Stearns 73 school 2714190 738 Independent Districts and Schools Holdingford Public School District 271419000733 2 Holdingford Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_7 68.0 1.0 1.0   0.0 0.0     0.0   0.0   34.0 36.0     0.0   0.0     24.0   11.0   70.0 68 1 1   0 0     0   0   34 36     0 0   24 11   70
1880614 MN Stevens 75 school 2708940 771 Independent Districts and Schools Chokio-Alberta Public School District 270894000361 2 Chokio-Alberta Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_7 9.0 0.0 0.0   0.0 0.0     0.0   0.0   5.0 4.0     *   *     *   *   9.0 9 0 0   0 0     0   0   5 4                 9
1880650 MN Traverse 78 school 2742330 803 Independent Districts and Schools Wheaton Area Public School District 274233001784 2 Wheaton Secondary Secondary School (Grades 7-12) Regular School No High 06 12 2018   grade_7 24.0 0.0 3.0   0.0 0.0     0.0   2.0   22.0 7.0     0.0   0.0     8.0   4.0   29.0 24 0 3   0 0     0   2   22 7     0 0   8 4   29
1880678 MN Wadena 80 school 2732970 820 Independent Districts and Schools Sebeka Public School District 273297001436 2 Sebeka Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_7 55.0 0.0 0.0   0.0 0.0     0.0   1.0   29.0 27.0     0.0   0.0     25.0   13.0   56.0 55 0 0   0 0     0   1   29 27     0 0   25 13   56
1880756 MN Clay 14 school 2740810 914 Independent Districts and Schools Ulen-Hitterdal Public School District 274081001705 2 Ulen-Hitterdal Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_7 16.0 1.0 1.0   2.0 1.0     0.0   0.0   12.0 9.0     0.0   0.0     4.0   6.0   21.0 16 1 1   2 1     0   0   12 9     0 0   4 6   21
1880906 MN Norman 54 school 2700101 2215 Independent Districts and Schools Norman County East School District 270010101695 2 Norman County East Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_7 17.0 0.0 4.0   1.0 0.0     0.0   2.0   12.0 12.0     0.0   1.0     9.0   3.0   24.0 17 0 4   1 0     0   2   12 12     0 1   9 3   24
1880927 MN Stearns 73 school 2700105 2364 Independent Districts and Schools Belgrade-Brooten-Elrosa Public School District 270010502567 2 Belgrade-Brooten-Elrosa Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_7 52.0 0.0 3.0   0.0 0.0     0.0   0.0   28.0 27.0     2.0   0.0     13.0   6.0   55.0 52 0 3   0 0     0   0   28 27     2 0   13 6   55
1881007 MN Redwood 64 school 2700110 2754 Independent Districts and Schools Cedar Mountain School District 270011001099 2 Cedar Mountain Secondary Secondary School (Grades 7-12) Regular School No High 06 12 2018   grade_7 34.0 0.0 3.0   5.0 0.0     0.0   1.0   25.0 18.0     0.0   0.0     25.0   7.0   43.0 34 0 3   5 0     0   1   25 18     0 0   25 7   43
1888631 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_7 19.0 0.0 0.0   1.0 0.0     0.0   2.0   12.0 10.0     0.0   0.0     12.0   2.0   22.0 19 0 0   1 0     0   2   12 10     0 0   12 2   22
1889198 MN Rice 66 school 2723880 659 Independent Districts and Schools Northfield Public School District 272388001182 2 Northfield Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2018   grade_7 249.0 5.0 35.0   1.0 6.0     0.0   6.0   148.0 154.0     8.0   0.0     81.0   42.0   302.0 249 5 35   1 6     0   6   148 154     8 0   81 42   302
1889211 MN Saint Louis 69 school 2730090 704 Independent Districts and Schools Proctor Public School District 273009001552 2 A.I. Jedlicka Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2018   grade_7 127.0 0.0 5.0   0.0 0.0     0.0   13.0   66.0 79.0     0.0   0.0     41.0   22.0   145.0 127 0 5   0 0     0   13   66 79     0 0   41 22   145
1889268 MN Stearns 73 school 2728140 741 Independent Districts and Schools Paynesville Public School District 272814001241 2 Paynesville Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2018   grade_7 60.0 0.0 9.0   0.0 0.0     0.0   3.0   29.0 43.0     3.0   0.0     25.0   16.0   72.0 60 0 9   0 0     0   3   29 43     3 0   25 16   72
1889335 MN Wright 86 school 2703150 876 Independent Districts and Schools Annandale Public School District 270315000093 2 Annandale Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2018   grade_7 132.0 1.0 5.0   0.0 0.0     0.0   4.0   71.0 71.0     2.0   0.0     31.0   23.0   142.0 132 1 5   0 0     0   4   71 71     2 0   31 23   142
1889379 MN Dodge 20 school 2740665 2125 Independent Districts and Schools Triton School District 274066500035 2 Triton Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2018   grade_7 80.0 1.0 14.0   0.0 0.0     0.0   4.0   58.0 41.0     6.0   1.0     27.0   13.0   99.0 80 1 14   0 0     0   4   58 41     6 1   27 13   99
1889419 MN Renville 65 school 2712580 2365 Independent Districts and Schools G.F.W. Public School District 271258000043 2 G.F.W. Middle School Middle School (Grades 5-8) Regular School No Middle 05 08 2018   grade_7 36.0 1.0 6.0   0.0 0.0     0.0   1.0   18.0 26.0     1.0   1.0     15.0   10.0   44.0 36 1 6   0 0     0   1   18 26     1 1   15 10   44
1891893 MN Rice 66 school 2700129 160 State Operated Schools (which include MN Academy Deaf & Blind, School for the Arts) Minnesota State Academies 270012902409 2 Minnesota Academy for the Deaf Special Education Special Education School No Other PK 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
1893488 MN Redwood 64 school 2721210 635 Independent Districts and Schools Milroy Public School District 272121000928 2 Milroy Junior High Junior High School (Grades 7-8 or 7-9) Regular School No Middle 07 08 2018   grade_7 3.0 0.0 0.0   1.0 0.0     0.0   0.0   1.0 3.0     *   *     *   *   4.0 3 0 0   1 0     0   0   1 3                 4
1880265 MN Marshall 45 school 2718920 447 Independent Districts and Schools Grygla Public School District 271892000897 3 Grygla 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   7.0 4.0     0.0   0.0     4.0   3.0   11.0 11 0 0   0 0     0   0   7 4     0 0   4 3   11
1880559 MN Saint Louis 69 school 2700001 712 Independent Districts and Schools Mountain Iron-Buhl School District 270000101613 3 Mountain Iron-Buhl Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_7 33.0 0.0 1.0   1.0 0.0     0.0   4.0   22.0 17.0     0.0   0.0     14.0   5.0   39.0 33 0 1   1 0     0   4   22 17     0 0   14 5   39
1880728 MN Winona 85 school 2733450 858 Independent Districts and Schools St. Charles Public School District 273345001476 3 St. Charles Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_7 65.0 0.0 14.0   0.0 2.0     0.0   3.0   41.0 43.0     5.0   0.0     25.0   1.0   84.0 65 0 14   0 2     0   3   41 43     5 0   25 1   84
1880856 MN Waseca 81 school 2700089 2168 Independent Districts and Schools NRHEG School District 270008901148 3 NRHEG Secondary Secondary School (Grades 7-12) Regular School No High 06 12 2018   grade_7 76.0 0.0 2.0   0.0 1.0     0.0   0.0   42.0 37.0     0.0   0.0     30.0   11.0   79.0 76 0 2   0 1     0   0   42 37     0 0   30 11   79
1881072 MN Big Stone 6 school 2700150 2888 Independent Districts and Schools Clinton-Graceville-Beardsley 270015000652 3 Clinton-Graceville-Beardsley Sr. Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_7 24.0 0.0 0.0   0.0 0.0     0.0   1.0   9.0 16.0     *   *     *   *   25.0 24 0 0   0 0     0   1   9 16                 25
1888635 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_7 459.0 55.0 29.0   7.0 22.0     1.0   24.0   270.0 327.0     20.0   9.0     200.0   66.0   597.0 459 55 29   7 22     1   24   270 327     20 9   200 66   597
1888869 MN Fillmore 23 school 2728290 239 Independent Districts and Schools Rushford-Peterson Public Schools 272829001249 3 Rushford-Peterson Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2018   grade_7 49.0 0.0 2.0   0.0 0.0     0.0   1.0   25.0 27.0     3.0   0.0     18.0   5.0   52.0 49 0 2   0 0     0   1   25 27     3 0   18 5   52
1889353 MN Wright 86 school 2732070 883 Independent Districts and Schools Rockford Public School District 273207001941 3 Rockford Middle Middle School (Grades 5-8) Regular School No Middle 05 08 2018   grade_7 96.0 6.0 14.0   2.0 4.0     0.0   5.0   56.0 71.0     4.0   0.0     39.0   10.0   127.0 96 6 14   2 4     0   5   56 71     4 0   39 10   127
1889383 MN Chisago 13 school 2700017 2144 Independent Districts and Schools Chisago Lakes School District 270001700351 3 Chisago Lakes Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2018   grade_7 252.0 3.0 5.0   0.0 1.0     0.0   4.0   130.0 135.0     *   0.0     51.0   24.0   265.0 252 3 5   0 1     0   4   130 135       0   51 24   265
1889391 MN Clay 14 school 2710260 2164 Independent Districts and Schools Dilworth-Glyndon-Felton 271026000448 3 Dilworth-Glyndon-Felton Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2018   grade_7 110.0 1.0 10.0   4.0 0.0     0.0   3.0   75.0 53.0     1.0   0.0     37.0   25.0   128.0 110 1 10   4 0     0   3   75 53     1 0   37 25   128
1889405 MN Rock 67 school 2718330 2184 Independent Districts and Schools Luverne Public School District 271833002471 3 Luverne Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2018   grade_7 79.0 2.0 6.0   0.0 0.0     0.0   4.0   40.0 51.0     1.0   0.0     26.0   13.0   91.0 79 2 6   0 0     0   4   40 51     1 0   26 13   91
1889451 MN Redwood 64 school 2700182 2897 Independent Districts and Schools Redwood Area School District 270018202301 3 Redwood Valley Middle Middle School (Grades 5-8) Regular School No Middle 05 08 2018   grade_7 52.0 2.0 4.0   12.0 0.0     0.0   5.0   46.0 29.0     0.0   1.0     27.0   16.0   75.0 52 2 4   12 0     0   5   46 29     0 1   27 16   75
1889463 MN Douglas 21 school 2700382 2908 Independent Districts and Schools Brandon-Evansville Public Schools 270038204740 3 Brandon-Evansville Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2018   grade_7 33.0 0.0 0.0   0.0 0.0     0.0   1.0   16.0 18.0     0.0   0.0     14.0   1.0   34.0 33 0 0   0 0     0   1   16 18     0 0   14 1   34
1888639 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_7 228.0 63.0 41.0   5.0 29.0     0.0   26.0   205.0 187.0     21.0   6.0     202.0   54.0   392.0 228 63 41   5 29     0   26   205 187     21 6   202 54   392
1888681 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_7 192.0 2.0 5.0   14.0 2.0     0.0   23.0   119.0 119.0     *   *     *   *   238.0 192 2 5   14 2     0   23   119 119                 238
1889033 MN Wright 86 school 2710060 466 Independent Districts and Schools Dassel-Cokato Public School District 271006002267 4 Dassel-Cokato Middle Middle School (Grades 5-8) Regular School No Middle 05 08 2018   grade_7 143.0 1.0 6.0   1.0 2.0     0.0   2.0   89.0 66.0     3.0   0.0     48.0   19.0   155.0 143 1 6   1 2     0   2   89 66     3 0   48 19   155
1889084 MN Nobles 53 school 2744160 518 Independent Districts and Schools Worthington Public School District 274416001840 4 Worthington Middle Middle School (Grades 5-8) Regular School No Middle 05 08 2018   grade_7 67.0 20.0 110.0   1.0 29.0     1.0   4.0   124.0 108.0     *   *     158.0   *   232.0 67 20 110   1 29     1   4   124 108           158     232
1889414 MN Grant 26 school 2700104 2342 Independent Districts and Schools West Central Area 270010404375 4 WCA Middle School Middle School (Grades 5-8) Regular School No Middle 05 08 2018   grade_7 58.0 0.0 4.0   0.0 0.0     0.0   1.0   38.0 25.0     0.0   0.0     23.0   14.0   63.0 58 0 4   0 0     0   1   38 25     0 0   23 14   63
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
1888643 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_7 413.0 113.0 52.0   5.0 94.0     0.0   40.0   337.0 380.0     33.0   9.0     237.0   88.0   717.0 413 113 52   5 94     0   40   337 380     33 9   237 88   717
1889014 MN Lyon 42 school 2718940 413 Independent Districts and Schools Marshall Public School District 271894003715 6 Marshall Middle School Middle School (Grades 5-8) Regular School No Middle 05 08 2018   grade_7 100.0 9.0 17.0   0.0 7.0     0.0   5.0   65.0 73.0     *   0.0     51.0   12.0   138.0 100 9 17   0 7     0   5   65 73       0   51 12   138
1889331 MN Winona 85 school 2744070 861 Independent Districts and Schools Winona Area Public School District 274407001830 6 Winona Middle Middle School (Grades 5-8) Regular School No Middle 05 08 2018   grade_7 184.0 7.0 7.0   1.0 7.0     0.0   13.0   107.0 112.0     8.0   0.0     68.0   39.0   219.0 184 7 7   1 7     0   13   107 112     8 0   68 39   219
1890995 MN Nobles 53 school 2744160 518 Independent Districts and Schools Worthington Public School District 274416002335 6 Worthington Area Learning Center Public Area Learning Center ALC (State approved) Alternative School No High 07 12 2018   grade_7 0.0 0.0 1.0   0.0 0.0     0.0   0.0   0.0 1.0     *   *     *   *   1.0 0 0 1   0 0     0   0   0 1                 1
1893621 MN Big Stone 6 school 2700150 2888 Independent Districts and Schools Clinton-Graceville-Beardsley 270015003019 6 Lismore Colony School Elementary/Secondary Combined (Grades K-12 limited to District Type 34 Bureau of Indian Education) Regular School No Other KG 12 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
1889433 MN Pipestone 59 school 2700108 2689 Independent Districts and Schools Pipestone Area School District 270010801264 7 Pipestone Middle Middle School (Grades 5-8) Regular School No Middle 05 08 2018   grade_7 74.0 0.0 8.0   1.0 0.0     0.0   3.0   46.0 40.0     *   *     *   *   86.0 74 0 8   1 0     0   3   46 40                 86
1890932 MN Lyon 42 school 2718940 413 Independent Districts and Schools Marshall Public School District 271894002816 8 MATEC Public Area Learning Center ALC (State approved) Alternative School No High 07 12 2018   grade_7 14.0 12.0 3.0   0.0 8.0     0.0   1.0   25.0 13.0     *   0.0     30.0   7.0   38.0 14 12 3   0 8     0   1   25 13       0   30 7   38
1888693 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_7 285.0 14.0 17.0   4.0 8.0     0.0   13.0   163.0 178.0     4.0   3.0     122.0   48.0   341.0 285 14 17   4 8     0   13   163 178     4 3   122 48   341
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
1880412 MN Pipestone 59 school 2711220 581 Independent Districts and Schools Edgerton Public School District 271122000504 10 Edgerton Secondary Secondary School (Grades 7-12) Regular School No High 06 12 2018   grade_7 22.0 0.0 5.0   0.0 0.0     0.0   0.0   12.0 15.0     1.0   0.0     15.0   1.0   27.0 22 0 5   0 0     0   0   12 15     1 0   15 1   27
1880742 MN Yellow Medicine 87 school 2707470 891 Independent Districts and Schools Canby Public School District 270747000322 10 Canby Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_7 39.0 0.0 1.0   0.0 0.0     0.0   1.0   20.0 21.0     0.0   0.0     13.0   6.0   41.0 39 0 1   0 0     0   1   20 21     0 0   13 6   41
1881014 MN Stevens 75 school 2700383 2769 Independent Districts and Schools Morris Area Public Schools 270038304728 10 Morris Area Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_7 74.0 0.0 10.0   1.0 2.0     0.0   2.0   51.0 38.0     1.0   0.0     22.0   17.0   89.0 74 0 10   1 2     0   2   51 38     1 0   22 17   89
1881141 MN Sibley 72 school 2700092 4007 Charter Schools Minnesota New Country School 270009202487 10 Minnesota New Country School Secondary School (Grades 7-12) Regular School Yes High 07 12 2018   grade_7 15.0 0.0 0.0   0.0 0.0     0.0   2.0   9.0 8.0     0.0   0.0     5.0   3.0   17.0 15 0 0   0 0     0   2   9 8     0 0   5 3   17
1881168 MN Washington 82 school 2700167 4043 Charter Schools Math and Science Academy 270016703035 10 Math and Science Academy Secondary School (Grades 7-12) Regular School Yes High 06 12 2018   grade_7 47.0 6.0 2.0   0.0 25.0     0.0   8.0   48.0 40.0     0.0   0.0     2.0   8.0   88.0 47 6 2   0 25     0   8   48 40     0 0   2 8   88
1881200 MN Blue Earth 7 school 2700226 4066 Charter Schools Kato Public Charter School 270022603471 10 Kato Public Charter School Secondary School (Grades 7-12) Regular School Yes High 06 12 2018   grade_7 5.0 0.0 0.0   0.0 0.0     0.0   0.0   4.0 1.0     *   *     *   *   5.0 5 0 0   0 0     0   0   4 1                 5
1881207 MN Ramsey 62 school 2700186 4074 Charter Schools AFSA High School 270018603139 10 AFSA High School Secondary School (Grades 7-12) Regular School Yes High 07 12 2018   grade_7 17.0 5.0 5.0   0.0 2.0     0.0   0.0   14.0 15.0     0.0   0.0     15.0   5.0   29.0 17 5 5   0 2     0   0   14 15     0 0   15 5   29
1881215 MN Rice 66 school 2700192 4081 Charter Schools Discovery Public School Faribault 270019203145 10 Discovery Public School Faribault Secondary School (Grades 7-12) Regular School Yes High 06 12 2018   grade_7 0.0 0.0 1.0   0.0 0.0     0.0   1.0   0.0 2.0     *   *     *   *   2.0 0 0 1   0 0     0   1   0 2                 2
1881223 MN Rice 66 school 2700355 4091 Charter Schools Arcadia Charter School 270035504151 10 Arcadia Charter School Secondary School (Grades 7-12) Regular School Yes High 06 12 2018   grade_7 21.0 1.0 0.0   0.0 0.0     0.0   0.0   9.0 13.0     0.0   0.0     4.0   6.0   22.0 21 1 0   0 0     0   0   9 13     0 0   4 6   22
1881230 MN Mcleod 43 school 2700214 4093 Charter Schools New Century Academy 270021403275 10 New Century Academy Secondary School (Grades 7-12) Regular School Yes High 07 12 2018   grade_7 13.0 0.0 3.0   0.0 0.0     0.0   1.0   11.0 6.0     0.0   0.0     13.0   8.0   17.0 13 0 3   0 0     0   1   11 6     0 0   13 8   17
1881245 MN Ramsey 62 school 2700344 4105 Charter Schools Great River School 270034404093 10 Great River School Secondary School (Grades 7-12) Regular School Yes High 07 12 2018   grade_7 36.0 5.0 3.0   0.0 6.0     0.0   0.0   28.0 22.0     0.0   0.0     9.0   7.0   50.0 36 5 3   0 6     0   0   28 22     0 0   9 7   50
1881266 MN Hennepin 27 school 2700364 4122 Charter Schools Eagle Ridge Academy Charter School 270036404108 10 Eagle Ridge Academy Charter School Secondary School (Grades 7-12) Regular School Yes High 06 12 2018   grade_7 43.0 31.0 0.0   0.0 23.0     0.0   4.0   43.0 58.0     3.0   0.0     35.0   8.0   101.0 43 31 0   0 23     0   4   43 58     3 0   35 8   101
1881274 MN Ramsey 62 school 2700246 4132 Charter Schools Twin Cities Academy 270024603307 10 Twin Cities Academy Secondary School (Grades 7-12) Regular School Yes High 06 12 2018   grade_7 43.0 21.0 14.0   0.0 10.0     0.0   12.0   45.0 55.0     5.0   0.0     33.0   8.0   100.0 43 21 14   0 10     0   12   45 55     5 0   33 8   100
1881282 MN Itasca 31 school 2700256 4146 Charter Schools Northern Lights Community School 270025603314 10 Northern Lights Community School Secondary School (Grades 7-12) Regular School Yes High 06 12 2018   grade_7 4.0 0.0 0.0   0.0 0.0     0.0   3.0   4.0 3.0     *   *     *   *   7.0 4 0 0   0 0     0   3   4 3                 7
1881289 MN Sherburne 71 school 2700276 4160 Charter Schools Spectrum High School 270027603615 10 Spectrum High School Secondary School (Grades 7-12) Regular School Yes High 07 12 2018   grade_7 105.0 1.0 4.0   0.0 6.0     0.0   5.0   64.0 57.0     1.0   1.0     20.0   10.0   121.0 105 1 4   0 6     0   5   64 57     1 1   20 10   121
1881296 MN Hennepin 27 school 2700315 4183 Charter Schools Lionsgate Academy 270031504325 10 Lionsgate Academy Secondary School (Grades 7-12) Regular School Yes High 07 12 2018   grade_7 15.0 4.0 0.0   0.0 1.0     0.0   2.0   18.0 4.0     0.0   0.0     3.0   *   22.0 15 4 0   0 1     0   2   18 4     0 0   3     22
1881303 MN Ramsey 62 school 2700367 4200 Charter Schools STEP Academy Charter School 270036704507 10 STEP Academy Charter School Secondary School (Grades 7-12) Regular School Yes High 06 12 2018   grade_7 0.0 43.0 0.0   0.0 0.0     0.0   0.0   25.0 18.0     25.0   0.0     *   1.0   43.0 0 43 0   0 0     0   0   25 18     25 0     1   43
1881310 MN Saint Louis 69 school 2700372 4207 Charter Schools Vermilion Country School 270037204555 10 Vermilion Country School Secondary School (Grades 7-12) Regular School Yes High 07 12 2018   grade_7 0.0 0.0 0.0   1.0 0.0     0.0   0.0   0.0 1.0     *   *     *   *   1.0 0 0 0   1 0     0   0   0 1                 1
1881317 MN Kandiyohi 34 school 2700389 4217 Charter Schools Technical Academies of Minnesota 270038904696 10 DREAM Technical Academy Secondary School (Grades 7-12) Regular School Yes High 07 12 2018   grade_7 0.0 0.0 6.0   0.0 0.0     0.0   0.0   5.0 1.0     *   *     *   *   6.0 0 0 6   0 0     0   0   5 1                 6
1881332 MN Hennepin 27 school 2700384 4218 Charter Schools Venture Academy 270038404697 10 Venture Academy Secondary School (Grades 7-12) Regular School Yes Middle 06 10 2018   grade_7 4.0 18.0 29.0   5.0 0.0     0.0   5.0   37.0 24.0     21.0   5.0     *   12.0   61.0 4 18 29   5 0     0   5   37 24     21 5     12   61
1881338 MN Wright 86 school 2700403 4229 Charter Schools Jane Goodall Environmental Science Academy 270040304850 10 Jane Goodall Environmental Science Academy Secondary School (Grades 7-12) Regular School Yes High 06 12 2018   grade_7 14.0 1.0 0.0   0.0 0.0     0.0   1.0   11.0 5.0     *   *     *   9.0   16.0 14 1 0   0 0     0   1   11 5             9   16
1881346 MN Ramsey 62 school 2700402 4237 Charter Schools Career Pathways 270040204836 10 Career Pathways Secondary School (Grades 7-12) Regular School Yes High 06 12 2018   grade_7 1.0 0.0 0.0   0.0 0.0     0.0   0.0   0.0 1.0     *   *     *   *   1.0 1 0 0   0 0     0   0   0 1                 1
1881353 MN Olmsted 55 school 2700412 4238 Charter Schools Rochester Beacon Academy 270041204878 10 Rochester Beacon Academy Secondary School (Grades 7-12) Regular School Yes High 06 12 2018   grade_7 14.0 0.0 1.0   1.0 0.0     0.0   1.0   12.0 5.0     0.0   0.0     7.0   14.0   17.0 14 0 1   1 0     0   1   12 5     0 0   7 14   17
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
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

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