Data source: Big Local News · About: Big Local

4,774 rows where grade = "grade_7" and state = "MN" sorted by ell

View and edit SQL

year

grade

  • grade_7 · 4,774
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
689017 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 2017   grade_7 25.0 0.0 0.0   6.0 0.0     0.0   1.0   12.0 20.0         *     16.0   5.0   32.0 25 0 0   6 0     0   1   12 20           16 5   32
689130 MN Cass 11 school 2730870 118 Independent Districts and Schools NORTHLAND COMMUNITY SCHOOLS 273087001308 20 NORTHLAND SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   grade_7 18.0 0.0 0.0   4.0 0.0     0.0   4.0   13.0 13.0         *         *   26.0 18 0 0   4 0     0   4   13 13                 26
689151 MN Clay 14 school 2713560 150 Independent Districts and Schools HAWLEY PUBLIC SCHOOL DISTRICT 271356000699 20 HAWLEY SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   grade_7 77.0 1.0 2.0   0.0 1.0     0.0   1.0   40.0 42.0         0.0     17.0   9.0   82.0 77 1 2   0 1     0   1   40 42       0   17 9   82
689271 MN Hennepin 27 school 2706240 286 Independent Districts and Schools BROOKLYN CENTER SCHOOL DISTRICT 270624000273 12 BROOKLYN CENTER SECONDARY Secondary School (Grades 7-12) Regular School No Other 06 12 2017   grade_7 14.0 70.0 41.0   1.0 21.0     0.0   10.0   75.0 82.0         *         *   157.0 14 70 41   1 21     0   10   75 82                 157
689321 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 2017   grade_7 25.0 0.0 0.0   1.0 0.0     0.0   3.0   16.0 13.0         *         6.0   29.0 25 0 0   1 0     0   3   16 13             6   29
689342 MN Kanabec 33 school 2721480 332 Independent Districts and Schools MORA PUBLIC SCHOOL DISTRICT 272148000944 40 MORA SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   grade_7 116.0 2.0 4.0   1.0 0.0     0.0   5.0   63.0 65.0         *         *   128.0 116 2 4   1 0     0   5   63 65                 128
689379 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 2017   grade_7 8.0 0.0 0.0   1.0 0.0     0.0   0.0   7.0 2.0         *         *   9.0 8 0 0   1 0     0   0   7 2                 9
689386 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 2017   grade_7 5.0 1.0 1.0   2.0 0.0     0.0   2.0   5.0 6.0         *         *   11.0 5 1 1   2 0     0   2   5 6                 11
689471 MN Martin 46 school 2740680 458 Independent Districts and Schools TRUMAN PUBLIC SCHOOL DISTRICT 274068001693 20 TRUMAN SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   grade_7 16.0 0.0 0.0   0.0 0.0     0.0   0.0   8.0 8.0         *     10.0   *   16.0 16 0 0   0 0     0   0   8 8           10     16
689493 MN Mille Lacs 48 school 2725050 480 Independent Districts and Schools ONAMIA PUBLIC SCHOOL DISTRICT 272505001196 20 ONAMIA SECONDARY Secondary School (Grades 7-12) Regular School No Other 06 12 2017   grade_7 16.0 0.0 0.0   27.0 0.0     0.0   3.0   24.0 22.0         *         *   46.0 16 0 0   27 0     0   3   24 22                 46
689548 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 2017   grade_7 10.0 0.0 0.0   0.0 0.0     0.0   1.0   6.0 5.0         *     8.0   5.0   11.0 10 0 0   0 0     0   1   6 5           8 5   11
689597 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 2017   grade_7 8.0 0.0 2.0   1.0 0.0     0.0   0.0   8.0 3.0         *         2.0   11.0 8 0 2   1 0     0   0   8 3             2   11
689611 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 2017   grade_7 117.0 1.0 8.0   1.0 0.0     0.0   4.0   72.0 59.0         *         17.0   131.0 117 1 8   1 0     0   4   72 59             17   131
689633 MN Polk 60 school 2709720 593 Independent Districts and Schools CROOKSTON PUBLIC SCHOOL DISTRICT 270972000412 90 CROOKSTON SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   grade_7 66.0 2.0 29.0   0.0 2.0     0.0   2.0   48.0 53.0         *         *   101.0 66 2 29   0 2     0   2   48 53                 101
689832 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 2017   grade_7 48.0 2.0 3.0   0.0 0.0     0.0   4.0   31.0 26.0         *         *   57.0 48 2 3   0 0     0   4   31 26                 57
689889 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 2017   grade_7 7.0 0.0 4.0   0.0 1.0     0.0   0.0   3.0 9.0         *         *   12.0 7 0 4   0 1     0   0   3 9                 12
689918 MN Wilkin 84 school 2707450 852 Independent Districts and Schools CAMPBELL-TINTAH PUBLIC SCHOOL DIST. 270745000320 20 CAMPBELL-TINTAH SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   grade_7 12.0 0.0 2.0   0.0 0.0     0.0   0.0   6.0 8.0         *     6.0   *   14.0 12 0 2   0 0     0   0   6 8           6     14
690073 MN Cass 11 school 2728970 2174 Independent Districts and Schools PINE RIVER-BACKUS SCHOOL DISTRICT 272897000041 20 PINE RIVER-BACKUS HIGH SCHOOL Secondary School (Grades 7-12) Regular School No High 07 12 2017   grade_7 59.0 0.0 0.0   0.0 0.0     1.0   0.0   36.0 24.0         1.0     29.0   12.0   60.0 59 0 0   0 0     1   0   36 24       1   29 12   60
690094 MN Fillmore 23 school 2700100 2198 Independent Districts and Schools FILLMORE CENTRAL 270010000691 456 FILLMORE CENTRAL SENIOR HIGH Secondary School (Grades 7-12) Regular School No High 07 12 2017   grade_7 37.0 0.0 1.0   0.0 0.0     0.0   1.0   19.0 20.0         *         *   39.0 37 0 1   0 0     0   1   19 20                 39
690115 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 2017   grade_7 17.0 0.0 0.0   0.0 0.0     0.0   0.0   9.0 8.0         *     10.0   4.0   17.0 17 0 0   0 0     0   0   9 8           10 4   17
690143 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 2017   grade_7 35.0 0.0 7.0   0.0 0.0     0.0   2.0   21.0 23.0         *         *   44.0 35 0 7   0 0     0   2   21 23                 44
690259 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 2017   grade_7 22.0 0.0 0.0   0.0 0.0     0.0   0.0   11.0 11.0         *         *   22.0 22 0 0   0 0     0   0   11 11                 22
690344 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 2017   grade_7 1.0 8.0 5.0   0.0 0.0     0.0   1.0   7.0 8.0         3.0         *   15.0 1 8 5   0 0     0   1   7 8       3         15
690374 MN Houston 28 school 2700178 4054 Charter Schools La Crescent Montessori & STEM School 270017804750 20 La Crescent Secondary Montessori & STEM Academy Secondary School (Grades 7-12) Regular School Yes High 07 12 2017   grade_7 3.0 0.0 0.0   0.0 1.0     0.0   0.0   2.0 2.0         *         *   4.0 3 0 0   0 1     0   0   2 2                 4
690380 MN Winona 85 school 2700221 4064 Charter Schools RIVERWAY LEARNING COMMUNITY CHTR 270022103136 20 RIVERWAY SECONDARY Secondary School (Grades 7-12) Regular School Yes High 07 12 2017   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
690388 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 Other 06 12 2017   grade_7 2.0 0.0 1.0   0.0 0.0     0.0   1.0   1.0 3.0         *         *   4.0 2 0 1   0 0     0   1   1 3                 4
690401 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 Other 06 12 2017   grade_7 2.0 0.0 1.0   0.0 0.0     0.0   0.0   1.0 2.0         *         *   3.0 2 0 1   0 0     0   0   1 2                 3
690490 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 2017   grade_7 18.0 1.0 0.0   0.0 1.0     0.0   1.0   16.0 5.0         *         18.0   21.0 18 1 0   0 1     0   1   16 5             18   21
690505 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 2017   grade_7 2.0 0.0 0.0   3.0 0.0     0.0   1.0   3.0 3.0         *         *   6.0 2 0 0   3 0     0   1   3 3                 6
690512 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 2017   grade_7 1.0 0.0 1.0   0.0 0.0     0.0   1.0   1.0 2.0         *         *   3.0 1 0 1   0 0     0   1   1 2                 3
690519 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 2017   grade_7 8.0 0.0 1.0   0.0 0.0     0.0   0.0   6.0 3.0         *         *   9.0 8 0 1   0 0     0   0   6 3                 9
690534 MN Unknown   school 2700402 4237 Charter Schools Metropolitan Education for Future Employment 270040204836 10 Metropolitan Education for Future Employment Charter Secondary School (Grades 7-12) Regular School Yes Other 06 12 2017   grade_7 0.0 5.0 0.0   0.0 0.0     0.0   0.0   5.0 0.0         *         *   5.0 0 5 0   0 0     0   0   5 0                 5
690899 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 2017   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
690986 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 2017   grade_7 0.0 0.0 0.0   7.0 0.0     0.0   0.0   5.0 2.0         *         *   7.0 0 0 0   7 0     0   0   5 2                 7
691603 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 Elementary 03 08 2017   grade_7 7.0 0.0 2.0   0.0 0.0     0.0   0.0   4.0 5.0         *         *   9.0 7 0 2   0 0     0   0   4 5                 9
693432 MN Olmsted 55 school 2731800 535 Independent Districts and Schools ROCHESTER PUBLIC SCHOOL DISTRICT 273180001005 138 LINCOLN K-8 CHOICE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 08 2017   grade_7 31.0 4.0 2.0   0.0 4.0     0.0   2.0   19.0 24.0         0.0         6.0   43.0 31 4 2   0 4     0   2   19 24       0     6   43
693754 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 2017   grade_7 65.0 15.0 3.0   0.0 6.0     0.0   2.0   47.0 44.0         0.0         12.0   91.0 65 15 3   0 6     0   2   47 44       0     12   91
694697 MN Stearns 73 school 2733510 742 Independent Districts and Schools ST. CLOUD PUBLIC SCHOOL DISTRICT 273351001485 25 KENNEDY COMMUNITY SCHOOL Elementary School (Grades PK-6) Regular School No Elementary PK 08 2017   grade_7 62.0 9.0 4.0   0.0 0.0     0.0   1.0   43.0 33.0         0.0     34.0   13.0   76.0 62 9 4   0 0     0   1   43 33       0   34 13   76
696801 MN Nicollet 52 school 2700174 4050 Charter Schools LAFAYETTE PUBLIC CHARTER SCHOOL 270017403042 10 LAFAYETTE PUBLIC CHARTER SCHOOL Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2017   grade_7 3.0 0.0 0.0   0.0 0.0     0.0   1.0   2.0 2.0         *         *   4.0 3 0 0   0 0     0   1   2 2                 4
696808 MN Nicollet 52 school 2700174 4050 Charter Schools LAFAYETTE PUBLIC CHARTER SCHOOL 270017404126 20 STARLAND ELEMENTARY Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2017   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
697147 MN Ramsey 62 school 2700263 4153 Charter Schools DUGSI ACADEMY 270026303320 10 DUGSI ACADEMY Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2017   grade_7 0.0 39.0 0.0   0.0 0.0     0.0   0.0   19.0 20.0         0.0         0.0   39.0 0 39 0   0 0     0   0   19 20       0     0   39
697380 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 2017   grade_7 7.0 0.0 0.0   0.0 0.0     0.0   0.0   2.0 5.0         *         *   7.0 7 0 0   0 0     0   0   2 5                 7
697409 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 2017   grade_7 0.0 1.0 0.0   0.0 8.0     0.0   0.0   3.0 6.0         *         *   9.0 0 1 0   0 8     0   0   3 6                 9
697463 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 KG 07 2017   grade_7 0.0 20.0 0.0   0.0 2.0     0.0   0.0   4.0 18.0         0.0         0.0   22.0 0 20 0   0 2     0   0   4 18       0     0   22
697521 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 2017   grade_7 6.0 3.0 0.0   0.0 0.0     0.0   0.0   6.0 3.0         *         *   9.0 6 3 0   0 0     0   0   6 3                 9
697701 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318002501 193 OAK VIEW MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_7 376.0 14.0 11.0   5.0 13.0     1.0   5.0   228.0 197.0         *         48.0   425.0 376 14 11   5 13     1   5   228 197             48   425
697709 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 2017   grade_7 441.0 13.0 26.0   4.0 22.0     0.0   24.0   264.0 266.0         *         *   530.0 441 13 26   4 22     0   24   264 266                 530
697713 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 Middle 06 08 2017   grade_7 45.0 90.0 107.0   1.0 8.0     0.0   18.0   131.0 138.0         *         41.0   269.0 45 90 107   1 8     0   18   131 138             41   269
697722 MN Anoka 2 school 2733540 15 Independent Districts and Schools ST. FRANCIS PUBLIC SCHOOL DISTRICT 273354000013 123 ST. FRANCIS MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_7 261.0 5.0 13.0   2.0 10.0     0.0   20.0   162.0 149.0         0.0         50.0   311.0 261 5 13   2 10     0   20   162 149       0     50   311
697731 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 Middle 05 08 2017   grade_7 151.0 5.0 7.0   21.0 1.0     0.0   34.0   109.0 110.0         *         *   219.0 151 5 7   21 1     0   34   109 110                 219
697735 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 2017   grade_7 245.0 7.0 8.0   57.0 4.0     0.0   15.0   181.0 155.0         *         *   336.0 245 7 8   57 4     0   15   181 155                 336
697747 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 2017   grade_7 256.0 24.0 14.0   1.0 7.0     1.0   11.0   180.0 134.0         0.0         34.0   314.0 256 24 14   1 7     1   11   180 134       0     34   314
697760 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 06 08 2017   grade_7 143.0 1.0 2.0   23.0 2.0     0.0   27.0   100.0 98.0         *         *   198.0 143 1 2   23 2     0   27   100 98                 198
697780 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 Middle 06 08 2017   grade_7 172.0 3.0 10.0   0.0 16.0     0.0   10.0   93.0 118.0         0.0     25.0   24.0   211.0 172 3 10   0 16     0   10   93 118       0   25 24   211
697784 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 Middle 06 08 2017   grade_7 152.0 4.0 11.0   0.0 5.0     0.0   6.0   84.0 94.0         *         *   178.0 152 4 11   0 5     0   6   84 94                 178
697789 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 2017   grade_7 5.0 0.0 1.0   76.0 0.0     0.0   5.0   54.0 33.0         *         *   87.0 5 0 1   76 0     0   5   54 33                 87
697804 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 2017   grade_7 218.0 4.0 5.0   4.0 5.0     0.0   1.0   120.0 117.0         *     72.0   *   237.0 218 4 5   4 5     0   1   120 117           72     237
697808 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 06 08 2017   grade_7 332.0 37.0 42.0   13.0 2.0     1.0   34.0   211.0 250.0         *         *   461.0 332 37 42   13 2     1   34   211 250                 461
697848 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 2017   grade_7 255.0 5.0 19.0   0.0 7.0     0.0   15.0   153.0 148.0         0.0     50.0   36.0   301.0 255 5 19   0 7     0   15   153 148       0   50 36   301
697860 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 2017   grade_7 248.0 11.0 7.0   0.0 19.0     0.0   17.0   145.0 157.0         *         *   302.0 248 11 7   0 19     0   17   145 157                 302
697880 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239001943 93 SCOTT HIGHLANDS MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_7 237.0 34.0 16.0   0.0 37.0     0.0   18.0   168.0 174.0         1.0     71.0   48.0   342.0 237 34 16   0 37     0   18   168 174       1   71 48   342
697920 MN Freeborn 24 school 2702970 241 Independent Districts and Schools ALBERT LEA PUBLIC SCHOOL DISTRICT 270297000078 320 SOUTHWEST MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 07 2017   grade_7 194.0 9.0 54.0   0.0 13.0     0.0   13.0   145.0 138.0         *         *   283.0 194 9 54   0 13     0   13   145 138                 283
697940 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 2017   grade_7 171.0 28.0 19.0   2.0 19.0     2.0   22.0   134.0 129.0         *         37.0   263.0 171 28 19   2 19     2   22   134 129             37   263
697977 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 2017   grade_7 185.0 63.0 20.0   2.0 30.0     0.0   33.0   176.0 157.0         *         34.0   333.0 185 63 20   2 30     0   33   176 157             34   333
698078 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 2017   grade_7 211.0 2.0 4.0   1.0 1.0     0.0   8.0   116.0 111.0         *         *   227.0 211 2 4   1 1     0   8   116 111                 227
698106 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 07 08 2017   grade_7 112.0 16.0 22.0   1.0 3.0     0.0   4.0   73.0 85.0         *         *   158.0 112 16 22   1 3     0   4   73 85                 158
698115 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 2017   grade_7 77.0 20.0 122.0   1.0 23.0     0.0   7.0   130.0 120.0         *     180.0   *   250.0 77 20 122   1 23     0   7   130 120           180     250
698176 MN Washington 82 school 2723850 622 Independent Districts and Schools North St Paul-Maplewood Oakdale Public School District 272385002666 54 SKYVIEW COMMUNITY MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_7 147.0 47.0 29.0   1.0 50.0     1.0   20.0   154.0 141.0         9.0         48.0   295.0 147 47 29   1 50     1   20   154 141       9     48   295
698187 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 2017   grade_7 202.0 76.0 76.0   2.0 103.0     0.0   20.0   245.0 234.0         2.0         53.0   479.0 202 76 76   2 103     0   20   245 234       2     53   479
698258 MN Scott 70 school 2730060 719 Independent Districts and Schools PRIOR LAKE-SAVAGE AREA SCHOOLS 273006001276 20 HIDDEN OAKS MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_7 268.0 16.0 17.0   4.0 12.0     0.0   4.0   158.0 163.0         *         *   321.0 268 16 17   4 12     0   4   158 163                 321
698262 MN Scott 70 school 2730060 719 Independent Districts and Schools PRIOR LAKE-SAVAGE AREA SCHOOLS 273006003626 21 TWIN OAKS MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_7 273.0 12.0 14.0   3.0 11.0     0.0   7.0   169.0 151.0         *         *   320.0 273 12 14   3 11     0   7   169 151                 320
698282 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 2017   grade_7 129.0 1.0 2.0   1.0 3.0     0.0   10.0   75.0 71.0         0.0         23.0   146.0 129 1 2   1 3     0   10   75 71       0     23   146
698290 MN Sherburne 71 school 2711370 728 Independent Districts and Schools ELK RIVER PUBLIC SCHOOL DISTRICT 271137002038 410 SALK MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_7 205.0 16.0 4.0   3.0 5.0     0.0   10.0   132.0 111.0         0.0     45.0   31.0   243.0 205 16 4   3 5     0   10   132 111       0   45 31   243
698321 MN Washington 82 school 2718750 832 Independent Districts and Schools MAHTOMEDI PUBLIC SCHOOL DISTRICT 271875000869 30 MAHTOMEDI MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_7 221.0 14.0 13.0   0.0 4.0     0.0   19.0   146.0 125.0         0.0     37.0   22.0   271.0 221 14 13   0 4     0   19   146 125       0   37 22   271
698381 MN Isanti 30 school 2707410 911 Independent Districts and Schools CAMBRIDGE-ISANTI PUBLIC SCHOOL DIST 270741003671 301 CAMBRIDGE MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_7 166.0 4.0 7.0   0.0 6.0     0.0   9.0   102.0 90.0         2.0     65.0   29.0   192.0 166 4 7   0 6     0   9   102 90       2   65 29   192
698405 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 2017   grade_7 261.0 2.0 4.0   0.0 6.0     0.0   8.0   141.0 140.0         *         30.0   281.0 261 2 4   0 6     0   8   141 140             30   281
698427 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 2017   grade_7 89.0 1.0 7.0   0.0 1.0     0.0   3.0   62.0 39.0         0.0     30.0   *   101.0 89 1 7   0 1     0   3   62 39       0   30     101
698575 MN Hennepin 27 school 2700245 4131 Charter Schools METRO SCHOOLS CHARTER 270024504857 20 Metro Schools Middle Charter Middle School (Grades 5-8) Regular School Yes Middle 05 08 2017   grade_7 0.0 25.0 0.0   0.0 0.0     0.0   0.0   14.0 11.0         0.0         2.0   25.0 0 25 0   0 0     0   0   14 11       0     2   25
699001 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 2017   grade_7 4.0 0.0 0.0   0.0 0.0     0.0   0.0   4.0 0.0         *         *   4.0 4 0 0   0 0     0   0   4 0                 4
699576 MN Ramsey 62 school 2700152 4031 Charter Schools Jennings Community School 270015202947 10 JENNINGS EXPERIENTIAL HIGH SCHOOL Senior High School (Grades 9-12) Regular School Yes High 07 12 2017   grade_7 0.0 0.0 0.0   0.0 1.0     0.0   0.0   0.0 1.0         *         *   1.0 0 0 0   0 1     0   0   0 1                 1
699772 MN Becker 3 school 2710230 22 Independent Districts and Schools DETROIT LAKES PUBLIC SCHOOL DIST. 271023003061 32 DETROIT LAKES MIDDLE ALC Public Area Learning Center ALC (State approved) Alternative School No Middle 06 08 2017   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
699791 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 2017   grade_7 0.0 0.0 0.0   3.0 0.0     0.0   0.0   2.0 1.0         *         *   3.0 0 0 0   3 0     0   0   2 1                 3
699807 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 2017   grade_7 2.0 0.0 0.0   0.0 0.0     0.0   0.0   2.0 0.0         *         *   2.0 2 0 0   0 0     0   0   2 0                 2
699833 MN Cass 11 school 2708070 115 Independent Districts and Schools CASS LAKE-BENA PUBLIC SCHOOLS 270807002234 31 CASS LAKE-BENA AREA LRNG. CNTR. Public Area Learning Center ALC (State approved) Alternative School No High 07 12 2017   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
699858 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 2017   grade_7 3.0 0.0 0.0   0.0 0.0     0.0   0.0   2.0 1.0         *         *   3.0 3 0 0   0 0     0   0   2 1                 3
699888 MN Freeborn 24 school 2702970 241 Independent Districts and Schools ALBERT LEA PUBLIC SCHOOL DISTRICT 270297002228 350 Albert Lea Area Learning Center Public Area Learning Center ALC (State approved) Alternative School No Other 06 12 2017   grade_7 5.0 0.0 3.0   0.0 1.0     0.0   0.0   5.0 4.0         *         *   9.0 5 0 3   0 1     0   0   5 4                 9
699957 MN Kanabec 33 school 2721480 332 Independent Districts and Schools MORA PUBLIC SCHOOL DISTRICT 272148004472 51 MORA MIDDLE LEVEL ALC Public Area Learning Center ALC (State approved) Alternative School No Middle 06 08 2017   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
700031 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 2017   grade_7 0.0 1.0 1.0   0.0 0.0     0.0   0.0   1.0 1.0         *         *   2.0 0 1 1   0 0     0   0   1 1                 2
700223 MN Isanti 30 school 2707410 911 Independent Districts and Schools CAMBRIDGE-ISANTI PUBLIC SCHOOL DIST 270741005021 385 Riverside Academy MLP Public Area Learning Center ALC (State approved) Alternative School No Middle 06 08 2017   grade_7 0.0 1.0 0.0   0.0 0.0     0.0   0.0   1.0 0.0         *         *   1.0 0 1 0   0 0     0   0   1 0                 1
700239 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 2017   grade_7 3.0 0.0 1.0   0.0 0.0     0.0   0.0   4.0 0.0         *         *   4.0 3 0 1   0 0     0   0   4 0                 4
700355 MN Wadena 80 school 2700014 6004 Education Districts FRESHWATER ED. DIST. 270001402222 20 FRESHWATER ED. DIST. ALC Public Area Learning Center ALC (State approved) Alternative School No Other 06 12 2017   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
700363 MN Olmsted 55 school 2700054 6012 Education Districts ZUMBRO EDUCATION DISTRICT 270005402492 20 ZUMBRO AREA LEARNING CENTER Public Area Learning Center ALC (State approved) Alternative School No Other 06 12 2017   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
700394 MN Brown 8 school 2791353 6049 Education Districts RIVER BEND EDUCATION DISTRICT 279135302494 20 RIVER BEND AREA LEARNING CENTER Public Area Learning Center ALC (State approved) Alternative School No High 07 12 2017   grade_7 2.0 0.0 0.0   0.0 0.0     0.0   0.0   2.0 0.0         *         *   2.0 2 0 0   0 0     0   0   2 0                 2
700402 MN Goodhue 25 school 2791443 6051 Education Districts Goodhue County Education District 279144304717 610 Pathways Program Grades 6-7 Public Area Learning Center ALC (State approved) Alternative School No Middle 06 07 2017   grade_7 3.0 0.0 1.0   2.0 0.0     0.0   0.0   1.0 5.0         *         *   6.0 3 0 1   2 0     0   0   1 5                 6
700420 MN Saint Louis 69 school 2700224 6076 Miscellaneous Cooperatives NORTHLAND LEARNING CENTER 270022403477 10 NORTHLAND LEARNING CENTER 010 Public Area Learning Center ALC (State approved) Alternative School No Other PK 12 2017   grade_7 1.0 1.0 0.0   0.0 0.0     0.0   0.0   0.0 2.0         *         *   2.0 1 1 0   0 0     0   0   0 2                 2
700428 MN Koochiching 36 school 2700224 6076 Miscellaneous Cooperatives NORTHLAND LEARNING CENTER 270022404905 15 ISD 361 - ALC Program Public Area Learning Center ALC (State approved) Alternative School No Other 06 12 2017   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
700449 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000005 467 RIVER TRAIL LEARNING CTR @ LO JACOB Special Education Special Education School No Other KG 12 2017   grade_7 8.0 1.0 0.0   0.0 0.0     0.0   0.0   6.0 3.0         *         *   9.0 8 1 0   0 0     0   0   6 3                 9
700488 MN Blue Earth 7 school 2718780 77 Independent Districts and Schools MANKATO PUBLIC SCHOOL DISTRICT 271878004374 370 FUTURES PROGRAM Special Education Special Education School No Other KG 12 2017   grade_7 1.0 0.0 1.0   0.0 0.0     0.0   0.0   2.0 0.0         *         *   2.0 1 0 1   0 0     0   0   2 0                 2
700534 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239002517 100 DAKOTA RIDGE SCHOOL Special Education Special Education School No Other KG 12 2017   grade_7 5.0 0.0 1.0   1.0 1.0     0.0   0.0   6.0 2.0         *         *   8.0 5 0 1   1 1     0   0   6 2                 8
700568 MN Hennepin 27 school 2714260 270 Independent Districts and Schools HOPKINS PUBLIC SCHOOL DISTRICT 271426005032 611 SENOPS Special Education Special Education School No Other KG 12 2017   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

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