enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

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
1879826 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
1880066 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
1880122 1880122 MN Itasca 31 school 2713170 318 Independent Districts and Schools Grand Rapids Public School District 271317000934 350 Bigfork Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_7 19.0 0.0 0.0   0.0 0.0     0.0   3.0   13.0 9.0     *   *     *   3.0   22.0 19 0 0   0 0     0   3   13 9             3   22
1880158 1880158 MN Kittson 35 school 2717880 356 Independent Districts and Schools Lancaster Public School District 271788000822 20 Lancaster Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_7 11.0 1.0 2.0   0.0 0.0     0.0   0.0   9.0 5.0     *   *     7.0   6.0   14.0 11 1 2   0 0     0   0   9 5           7 6   14
1880180 1880180 MN Koochiching 36 school 2732700 363 Independent Districts and Schools South Koochiching School District 273270001413 60 Indus Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_7 5.0 2.0 1.0   0.0 0.0     0.0   0.0   4.0 4.0     *   *     *   *   8.0 5 2 1   0 0     0   0   4 4                 8
1880187 1880187 MN Koochiching 36 school 2732700 363 Independent Districts and Schools South Koochiching School District 273270001416 70 Northome Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_7 12.0 2.0 0.0   0.0 0.0     0.0   1.0   6.0 9.0     *   *     *   *   15.0 12 2 0   0 0     0   1   6 9                 15
1880244 1880244 MN Mahnomen 44 school 2718660 432 Independent Districts and Schools Mahnomen Public School District 271866000866 20 Mahnomen Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_7 9.0 0.0 2.0   14.0 0.0     0.0   34.0   34.0 25.0     *   *     *   *   59.0 9 0 2   14 0     0   34   34 25                 59
1880251 1880251 MN Mahnomen 44 school 2742120 435 Independent Districts and Schools Waubun-Ogema-White Earth Public Schools 274212001756 30 Waubun Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_7 8.0 0.0 1.0   27.0 0.0     0.0   13.0   22.0 27.0     *   2.0     34.0   8.0   49.0 8 0 1   27 0     0   13   22 27       2   34 8   49
1880341 1880341 MN Nobles 53 school 2711460 514 Independent Districts and Schools Ellsworth Public School District 271146000526 20 Ellsworth Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_7 6.0 0.0 1.0   0.0 0.0     0.0   0.0   2.0 5.0     *   *     *   *   7.0 6 0 1   0 0     0   0   2 5                 7
1880390 1880390 MN Pennington 57 school 2713020 561 Independent Districts and Schools Goodridge Public School District 271302000650 20 Goodridge Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_7 18.0 0.0 1.0   3.0 0.0     0.0   0.0   7.0 15.0     *   *     10.0   3.0   22.0 18 0 1   3 0     0   0   7 15           10 3   22
1880404 1880404 MN Pine 58 school 2728380 578 Independent Districts and Schools Pine City Public School District 272838001256 20 Pine City Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_7 124.0 0.0 8.0   0.0 0.0     0.0   7.0   81.0 58.0     *   *     *   15.0   139.0 124 0 8   0 0     0   7   81 58             15   139
1880538 1880538 MN Saint Louis 69 school 2712210 698 Independent Districts and Schools Floodwood Public School District 271221000589 20 Floodwood Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_7 12.0 1.0 0.0   0.0 0.0     0.0   2.0   5.0 10.0     *   *     6.0   1.0   15.0 12 1 0   0 0     0   2   5 10           6 1   15
1880614 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
1880628 1880628 MN Swift 76 school 2704470 777 Independent Districts and Schools Benson Public School District 270447000199 101 Benson Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_7 49.0 1.0 7.0   0.0 0.0     0.0   0.0   28.0 29.0     *   *     28.0   9.0   57.0 49 1 7   0 0     0   0   28 29           28 9   57
1880685 1880685 MN Watonwan 83 school 2707320 836 Independent Districts and Schools Butterfield Public School District 270732000305 30 Butterfield Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_7 5.0 1.0 7.0   0.0 0.0     0.0   0.0   8.0 5.0     *   *     9.0   4.0   13.0 5 1 7   0 0     0   0   8 5           9 4   13
1880714 1880714 MN Wilkin 84 school 2707450 852 Independent Districts and Schools Campbell-Tintah Public School District 270745000320 20 Campbell-Tintah Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_7 5.0 0.0 0.0   0.0 0.0     0.0   1.0   4.0 2.0     *   *     *   *   6.0 5 0 0   0 0     0   1   4 2                 6
1880920 1880920 MN Kittson 35 school 2791446 2358 Independent Districts and Schools Tri-County School District 279144602314 20 Tri-County Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_7 9.0 0.0 0.0   0.0 0.0     0.0   0.0   4.0 5.0     *   *     *   *   9.0 9 0 0   0 0     0   0   4 5                 9
1880941 1880941 MN Norman 54 school 2791448 2527 Independent Districts and Schools Martin County West School District 279144802318 20 Norman County West Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_7 7.0 1.0 7.0   0.0 0.0     0.0   0.0   10.0 5.0     *   2.0     5.0   4.0   15.0 7 1 7   0 0     0   0   10 5       2   5 4   15
1880949 1880949 MN Renville 65 school 2705660 2534 Independent Districts and Schools Bird Island-Olivia-Lake Lillian Public School District 270566000147 20 BOLD Senior High Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_7 34.0 0.0 8.0   0.0 1.0     0.0   0.0   16.0 27.0     *   *     *   *   43.0 34 0 8   0 1     0   0   16 27                 43
1881072 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
1881155 1881155 MN Hennepin 27 school 2700117 4017 Charter Schools Minnesota Transitions Charter School 270011703262 12 MTS High School Secondary School (Grades 7-12) Regular School Yes High 07 12 2018   grade_7 2.0 37.0 5.0   1.0 0.0     0.0   1.0   21.0 25.0     *   5.0     *   *   46.0 2 37 5   1 0     0   1   21 25       5         46
1881185 1881185 MN Houston 28 school 2700178 4054 Charter Schools La Crescent Montessori and STEM School 270017804750 20 La Crescent Secondary Montessori and STEM Academy Secondary School (Grades 7-12) Regular School Yes High 07 12 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
1881200 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
1881215 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
1881282 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
1881310 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 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
1881324 1881324 MN Steele 74 school 2700389 4217 Charter Schools Technical Academies of Minnesota 270038904954 20 CHOICE Technical Academy Secondary School (Grades 7-12) Regular School Yes High 07 12 2018   grade_7 2.0 0.0 0.0   0.0 0.0     0.0   0.0   1.0 1.0     *   *     *   *   2.0 2 0 0   0 0     0   0   1 1                 2
1881338 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 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
1881715 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 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
1882428 1882428 MN Dakota 19 school 2711820 192 Independent Districts and Schools Farmington Public School District 271182004816 155 Gateway Academy Elementary School (Grades PK-6) Regular School No Middle 04 08 2018   grade_7 6.0 1.0 0.0   0.0 1.0     0.0   1.0   7.0 2.0     *   *     *   *   9.0 6 1 0   0 1     0   1   7 2                 9
1884641 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
1885080 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
1886255 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 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
1887355 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
1887737 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
1888290 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 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 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 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 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 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
1888659 1888659 MN Anoka 2 school 2708100 12 Independent Districts and Schools Centennial Public School District 270810002784 166 Centennial Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2018   grade_7 399.0 25.0 22.0   2.0 24.0     1.0   20.0   262.0 231.0     *   *     *   *   493.0 399 25 22   2 24     1   20   262 231                 493
1888681 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
1888685 1888685 MN Beltrami 4 school 2704440 31 Independent Districts and Schools Bemidji Public School District 270444002031 15 Bemidji Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2018   grade_7 265.0 4.0 10.0   58.0 2.0     0.0   28.0   188.0 179.0     *   *     *   *   367.0 265 4 10   58 2     0   28   188 179                 367
1888697 1888697 MN Nicollet 52 school 2718780 77 Independent Districts and Schools Mankato Public School District 271878002046 190 Dakota Meadows Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2018   grade_7 238.0 33.0 10.0   0.0 9.0     2.0   12.0   165.0 139.0     *   *     *   45.0   304.0 238 33 10   0 9     2   12   165 139             45   304
1888701 1888701 MN Blue Earth 7 school 2718780 77 Independent Districts and Schools Mankato Public School District 271878002045 200 Prairie Winds Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2018   grade_7 234.0 46.0 20.0   1.0 10.0     0.0   9.0   162.0 158.0     *   7.0     117.0   49.0   320.0 234 46 20   1 10     0   9   162 158       7   117 49   320
1888711 1888711 MN Carlton 9 school 2709420 94 Independent Districts and Schools Cloquet Public School District 270942000381 201 Cloquet Middle Middle School (Grades 5-8) Regular School No Middle 05 08 2018   grade_7 140.0 2.0 2.0   23.0 2.0     1.0   27.0   111.0 86.0     *   *     *   *   197.0 140 2 2   23 2     1   27   111 86                 197
1888731 1888731 MN Carver 10 school 2708190 112 Independent Districts and Schools Eastern Carver County Public Schools 270819002798 62 Chaska Middle School West Middle School (Grades 5-8) Regular School No Middle 06 08 2018   grade_7 157.0 4.0 11.0   0.0 12.0     0.0   10.0   109.0 85.0     *   2.0     24.0   23.0   194.0 157 4 11   0 12     0   10   109 85       2   24 23   194
1888740 1888740 MN Cass 11 school 2708070 115 Independent Districts and Schools Cass Lake-Bena Public Schools 270807003181 20 Cass Lake-Bena Middle School Middle School (Grades 5-8) Regular School No Middle 05 08 2018   grade_7 8.0 0.0 3.0   67.0 0.0     0.0   3.0   46.0 35.0     *   *     *   *   81.0 8 0 3   67 0     0   3   46 35                 81
1888755 1888755 MN Chisago 13 school 2723820 138 Independent Districts and Schools North Branch Public Schools 272382001164 20 North Branch Middle Middle School (Grades 5-8) Regular School No Middle 05 08 2018   grade_7 190.0 1.0 8.0   3.0 4.0     0.0   3.0   107.0 102.0     *   *     *   *   209.0 190 1 8   3 4     0   3   107 102                 209
1888760 1888760 MN Clay 14 school 2721420 152 Independent Districts and Schools Moorhead Public School District 272142003512 380 Horizon Middle School Middle School (Grades 5-8) Regular School No Middle 05 08 2018   grade_7 338.0 29.0 40.0   17.0 2.0     0.0   33.0   246.0 213.0     *   6.0     *   *   459.0 338 29 40   17 2     0   33   246 213       6         459
1888785 1888785 MN Dakota 19 school 2707290 191 Independent Districts and Schools Burnsville Public School District 270729000295 15 John Metcalf Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2018   grade_7 54.0 24.0 16.0   1.0 15.0     0.0   11.0   58.0 63.0     *   3.0     *   *   121.0 54 24 16   1 15     0   11   58 63       3         121
1888793 1888793 MN Dakota 19 school 2707290 191 Independent Districts and Schools Burnsville Public School District 270729000297 85 Joseph Nicollet Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2018   grade_7 4.0 2.0 1.0   0.0 0.0     0.0   0.0   4.0 3.0     *   *     *   *   7.0 4 2 1   0 0     0   0   4 3                 7
1888797 1888797 MN Dakota 19 school 2711820 192 Independent Districts and Schools Farmington Public School District 271182000570 30 Levi P. Dodge Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2018   grade_7 197.0 6.0 17.0   2.0 7.0     0.0   11.0   125.0 115.0     *   *     *   *   240.0 197 6 17   2 7     0   11   125 115                 240
1888801 1888801 MN Dakota 19 school 2711820 192 Independent Districts and Schools Farmington Public School District 271182002983 60 Robert Boeckman Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2018   grade_7 237.0 8.0 12.0   2.0 12.0     0.0   11.0   139.0 143.0     *   1.0     42.0   53.0   282.0 237 8 12   2 12     0   11   139 143       1   42 53   282
1888813 1888813 MN Dakota 19 school 2717780 194 Independent Districts and Schools Lakeville Public School District 271778002984 105 Century Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2018   grade_7 263.0 7.0 9.0   2.0 20.0     0.0   8.0   163.0 146.0     *   0.0     *   *   309.0 263 7 9   2 20     0   8   163 146       0         309
1888817 1888817 MN Dakota 19 school 2732390 196 Independent Districts and Schools Rosemount-Apple Valley-Eagan 273239000484 25 Dakota Hills Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2018   grade_7 247.0 30.0 37.0   0.0 49.0     1.0   21.0   194.0 191.0     *   *     57.0   43.0   385.0 247 30 37   0 49     1   21   194 191           57 43   385
1888825 1888825 MN Dakota 19 school 2732390 196 Independent Districts and Schools Rosemount-Apple Valley-Eagan 273239001381 39 Rosemount Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2018   grade_7 341.0 16.0 24.0   0.0 24.0     0.0   20.0   225.0 200.0     *   *     52.0   45.0   425.0 341 16 24   0 24     0   20   225 200           52 45   425
1888856 1888856 MN Dakota 19 school 2713530 200 Independent Districts and Schools Hastings Public School District 271353000693 130 Hastings Middle School Middle School (Grades 5-8) Regular School No Middle 05 08 2018   grade_7 284.0 5.0 11.0   1.0 1.0     0.0   9.0   170.0 141.0     *   *     *   *   311.0 284 5 11   1 1     0   9   170 141                 311
1888885 1888885 MN Hennepin 27 school 2705790 271 Independent Districts and Schools Bloomington Public School District 270579000226 13 Oak Grove Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2018   grade_7 142.0 44.0 42.0   0.0 9.0     0.0   24.0   129.0 132.0     *   *     *   32.0   261.0 142 44 42   0 9     0   24   129 132             32   261
1888893 1888893 MN Hennepin 27 school 2705790 271 Independent Districts and Schools Bloomington Public School District 270579000228 346 Olson Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2018   grade_7 222.0 24.0 24.0   1.0 20.0     0.0   20.0   149.0 162.0     *   *     *   52.0   311.0 222 24 24   1 20     0   20   149 162             52   311
1888928 1888928 MN Hennepin 27 school 2725200 279 Independent Districts and Schools Osseo Public School District 272520001217 34 Osseo Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2018   grade_7 193.0 71.0 29.0   1.0 32.0     0.0   23.0   173.0 176.0     *   3.0     *   38.0   349.0 193 71 29   1 32     0   23   173 176       3     38   349
1888976 1888976 MN Hennepin 27 school 2706240 286 Independent Districts and Schools Brooklyn Center School District 270624005130 11 Brooklyn Center Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2018   grade_7 12.0 54.0 25.0   1.0 14.0     0.0   3.0   56.0 53.0     *   *     *   *   109.0 12 54 25   1 14     0   3   56 53                 109
1889014 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
1889019 1889019 MN Lincoln 41 school 2718390 415 Independent Districts and Schools Lynd Public School District 271839004845 40 Lynd Middle School Middle School (Grades 5-8) Regular School No Middle 05 08 2018   grade_7 2.0 0.0 3.0   0.0 0.0     0.0   0.0   3.0 2.0     *   *     *   *   5.0 2 0 3   0 0     0   0   3 2                 5
1889023 1889023 MN Mcleod 43 school 2714970 423 Independent Districts and Schools Hutchinson Public School District 271497000755 20 Hutchinson Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2018   grade_7 207.0 0.0 17.0   0.0 1.0     0.0   5.0   118.0 112.0     *   *     62.0   *   230.0 207 0 17   0 1     0   5   118 112           62     230
1889037 1889037 MN Mille Lacs 48 school 2730030 477 Independent Districts and Schools Princeton Public School District 273003001272 20 Princeton Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2018   grade_7 240.0 0.0 5.0   1.0 0.0     0.0   9.0   148.0 107.0     *   *     *   *   255.0 240 0 5   1 0     0   9   148 107                 255
1889044 1889044 MN Mille Lacs 48 school 2725050 480 Independent Districts and Schools Onamia Public School District 272505005107 50 Onamia Intermediate School Middle School (Grades 5-8) Regular School No Other 03 09 2018   grade_7 16.0 2.0 0.0   23.0 0.0     0.0   5.0   32.0 14.0     *   *     *   *   46.0 16 2 0   23 0     0   5   32 14                 46
1889056 1889056 MN Mower 50 school 2703450 492 Independent Districts and Schools Austin Public School District 270345000150 300 Ellis Middle Middle School (Grades 5-8) Regular School No Middle 07 08 2018   grade_7 176.0 28.0 80.0   0.0 25.0     4.0   12.0   154.0 171.0     *   *     187.0   *   325.0 176 28 80   0 25     4   12   154 171           187     325
1889075 1889075 MN Nicollet 52 school 2733870 508 Independent Districts and Schools St. Peter Public School District 273387002533 80 St. Peter Middle School Middle School (Grades 5-8) Regular School No Middle 05 08 2018   grade_7 150.0 8.0 17.0   0.0 2.0     0.0   5.0   92.0 90.0     *   *     *   *   182.0 150 8 17   0 2     0   5   92 90                 182
1889084 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
1889157 1889157 MN Ramsey 62 school 2732430 623 Independent Districts and Schools Roseville Public School District 273243002667 70 Roseville Area Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2018   grade_7 171.0 94.0 74.0   4.0 96.0     0.0   21.0   249.0 211.0     *   4.0     245.0   60.0   460.0 171 94 74   4 96     0   21   249 211       4   245 60   460
1889236 1889236 MN Scott 70 school 2723430 721 Independent Districts and Schools New Prague Area Schools 272343001145 111 New Prague Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2018   grade_7 298.0 1.0 2.0   1.0 3.0     0.0   5.0   146.0 164.0     *   *     53.0   34.0   310.0 298 1 2   1 3     0   5   146 164           53 34   310
1889252 1889252 MN Sherburne 71 school 2711370 728 Independent Districts and Schools Elk River Public School District 271137003360 350 Zimmerman Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2018   grade_7 161.0 1.0 7.0   2.0 1.0     0.0   9.0   90.0 91.0     *   0.0     42.0   25.0   181.0 161 1 7   2 1     0   9   90 91       0   42 25   181
1889303 1889303 MN Washington 82 school 2733810 833 Independent Districts and Schools South Washington County School District 273381002465 20 Cottage Grove Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2018   grade_7 306.0 23.0 26.0   1.0 19.0     0.0   19.0   178.0 216.0     *   2.0     88.0   39.0   394.0 306 23 26   1 19     0   19   178 216       2   88 39   394
1889315 1889315 MN Washington 82 school 2733810 833 Independent Districts and Schools South Washington County School District 273381002219 28 Woodbury Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2018   grade_7 209.0 39.0 19.0   1.0 42.0     0.0   20.0   175.0 155.0     *   0.0     *   *   330.0 209 39 19   1 42     0   20   175 155       0         330
1889339 1889339 MN Wright 86 school 2707200 877 Independent Districts and Schools Buffalo-Hanover-Montrose Public Schools 270720000284 30 Buffalo Community Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2018   grade_7 429.0 6.0 14.0   1.0 7.0     0.0   16.0   234.0 239.0     *   *     *   *   473.0 429 6 14   1 7     0   16   234 239                 473
1889367 1889367 MN Isanti 30 school 2707410 911 Independent Districts and Schools Cambridge-Isanti Public School District 270741003671 301 Cambridge Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2018   grade_7 193.0 1.0 3.0   3.0 3.0     0.0   11.0   103.0 111.0     *   *     65.0   18.0   214.0 193 1 3   3 3     0   11   103 111           65 18   214
1889383 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
1889433 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
1889969 1889969 MN Lincoln 41 school 2713680 402 Independent Districts and Schools Hendricks Public School District 271368004530 20 Hendricks Senior High Senior High School (Grades 9-12) Regular School No High 07 12 2018   grade_7 2.0 0.0 0.0   0.0 0.0     0.0   0.0   0.0 2.0     *   *     *   *   2.0 2 0 0   0 0     0   0   0 2                 2
1890704 1890704 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318002974 812 Compass-Bell Center Public Area Learning Center ALC (State approved) Alternative School No High 06 12 2018   grade_7 1.0 2.0 0.0   0.0 0.0     0.0   0.0   3.0 0.0     *   *     *   *   3.0 1 2 0   0 0     0   0   3 0                 3
1890725 1890725 MN Anoka 2 school 2733540 15 Independent Districts and Schools St. Francis Public School District 273354004980 18 Saints Academy Public Area Learning Center ALC (State approved) Alternative School No High 07 12 2018   grade_7 31.0 0.0 1.0   3.0 0.0     0.0   1.0   25.0 11.0     *   0.0     12.0   *   36.0 31 0 1   3 0     0   1   25 11       0   12     36
1890737 1890737 MN Becker 3 school 2710230 22 Independent Districts and Schools Detroit Lakes Public School District 271023003061 32 Detroit Lakes Middle ALC Public Area Learning Center ALC (State approved) Alternative School No Middle 06 08 2018   grade_7 4.0 0.0 1.0   1.0 1.0     0.0   4.0   7.0 4.0     *   *     *   *   11.0 4 0 1   1 1     0   4   7 4                 11
1890755 1890755 MN Beltrami 4 school 2730510 38 Independent Districts and Schools Red Lake Public School District 273051002793 50 Red Lake Middle Level ALC Public Area Learning Center ALC (State approved) Alternative School No Middle 06 08 2018   grade_7 0.0 0.0 0.0   4.0 0.0     0.0   0.0   3.0 1.0     *   *     *   *   4.0 0 0 0   4 0     0   0   3 1                 4
1890768 1890768 MN Carlton 9 school 2709420 94 Independent Districts and Schools Cloquet Public School District 270942002236 103 Cloquet Area Alt. Ed. Programs Public Area Learning Center ALC (State approved) Alternative School No Other 01 12 2018   grade_7 0.0 0.0 0.0   0.0 0.0     0.0   2.0   2.0 0.0     *   *     *   *   2.0 0 0 0   0 0     0   2   2 0                 2
1890791 1890791 MN Cass 11 school 2708070 115 Independent Districts and Schools Cass Lake-Bena Public Schools 270807002234 31 Cass Lake-Bena Area Learning Center Public Area Learning Center ALC (State approved) Alternative School No High 07 12 2018   grade_7 0.0 0.0 0.0   3.0 0.0     0.0   0.0   0.0 3.0     *   *     *   *   3.0 0 0 0   3 0     0   0   0 3                 3
1890803 1890803 MN Clay 14 school 2721420 152 Independent Districts and Schools Moorhead Public School District 272142000462 980 Red River Area Learning Center Public Area Learning Center ALC (State approved) Alternative School No High 05 12 2018   grade_7 1.0 0.0 1.0   0.0 0.0     0.0   1.0   2.0 1.0     *   *     *   *   3.0 1 0 1   0 0     0   1   2 1                 3
1890816 1890816 MN Crow Wing 18 school 2706090 181 Independent Districts and Schools Brainerd Public School District 270609002982 21 Middle Level Alternative Program Public Area Learning Center ALC (State approved) Alternative School No Middle 05 08 2018   grade_7 5.0 0.0 0.0   0.0 0.0     0.0   1.0   3.0 3.0     *   *     *   *   6.0 5 0 0   0 0     0   1   3 3                 6
1890886 1890886 MN Hennepin 27 school 2706240 286 Independent Districts and Schools Brooklyn Center School District 270624004780 16 Brooklyn Center Middle School ALC Public Area Learning Center ALC (State approved) Alternative School No Middle 06 08 2018   grade_7 1.0 3.0 4.0   0.0 5.0     0.0   2.0   4.0 11.0     *   0.0     13.0   *   15.0 1 3 4   0 5     0   2   4 11       0   13     15
1890919 1890919 MN Kandiyohi 34 school 2742720 347 Independent Districts and Schools Willmar Public School District 274272000950 949 Willmar Area Learning Center Public Area Learning Center ALC (State approved) Alternative School No High 07 12 2018   grade_7 1.0 0.0 5.0   0.0 0.0     0.0   1.0   5.0 2.0     *   *     *   *   7.0 1 0 5   0 0     0   1   5 2                 7
1890932 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
1890949 1890949 MN Mahnomen 44 school 2718660 432 Independent Districts and Schools Mahnomen Public School District 271866002333 40 Mahnomen Area Learning Center Public Area Learning Center ALC (State approved) Alternative School No High 06 12 2018   grade_7 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     0   1   0 1                 1
1890995 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
1891168 1891168 MN Isanti 30 school 2707410 911 Independent Districts and Schools Cambridge-Isanti Public School District 270741005021 385 Riverside Academy MLP Public Area Learning Center ALC (State approved) Alternative School No Middle 06 08 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
1891183 1891183 MN Renville 65 school 2705660 2534 Independent Districts and Schools Bird Island-Olivia-Lake Lillian Public School District 270566004726 25 BOLD ALC Public Area Learning Center ALC (State approved) Alternative School No High 07 12 2018   grade_7 3.0 0.0 3.0   0.0 0.0     0.0   0.0   3.0 3.0     *   *     *   *   6.0 3 0 3   0 0     0   0   3 3                 6

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