Data source: Big Local News · About: Big Local

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

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
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
689722 MN Roseau 68 school 2732250 682 Independent Districts and Schools ROSEAU PUBLIC SCHOOL DISTRICT 273225001371 20 ROSEAU SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   grade_7 92.0 2.0 2.0   0.0 0.0     0.0   2.0   50.0 48.0     0.0   *     24.0   16.0   98.0 92 2 2   0 0     0   2   50 48     0     24 16   98
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
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
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
696703 MN Hennepin 27 school 2700117 4017 Charter Schools Minnesota Transitions Charter School 270011703566 17 Banaadir Academy Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2017   grade_7 0.0 31.0 0.0   0.0 0.0     0.0   0.0   14.0 17.0     23.0   *         *   31.0 0 31 0   0 0     0   0   14 17     23           31
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
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
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
697718 MN Anoka 2 school 2712420 14 Independent Districts and Schools FRIDLEY PUBLIC SCHOOL DISTRICT 271242000610 23 FRIDLEY MIDDLE Middle School (Grades 5-8) Regular School No Middle 05 08 2017   grade_7 98.0 71.0 26.0   1.0 18.0     1.0   21.0   118.0 118.0     18.0   *     148.0   *   236.0 98 71 26   1 18     1   21   118 118     18     148     236
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
697751 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 2017   grade_7 212.0 54.0 26.0   1.0 5.0     0.0   13.0   166.0 145.0     26.0   *     132.0   36.0   311.0 212 54 26   1 5     0   13   166 145     26     132 36   311
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
697776 MN Carver 10 school 2708190 112 Independent Districts and Schools EASTERN CARVER COUNTY PUBLIC SCHOOL 270819000345 61 CHASKA MIDDLE SCHOOL EAST Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_7 174.0 4.0 15.0   0.0 3.0     0.0   9.0   98.0 107.0     5.0   *         *   205.0 174 4 15   0 3     0   9   98 107     5           205
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
697823 MN Crow Wing 18 school 2706090 181 Independent Districts and Schools BRAINERD PUBLIC SCHOOL DISTRICT 270609004196 22 FORESTVIEW MIDDLE Middle School (Grades 5-8) Regular School No Middle 05 08 2017   grade_7 458.0 9.0 6.0   12.0 5.0     0.0   7.0   264.0 233.0     0.0   *     178.0   70.0   497.0 458 9 6   12 5     0   7   264 233     0     178 70   497
697844 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 2017   grade_7 220.0 6.0 20.0   3.0 12.0     1.0   6.0   129.0 139.0     8.0   *         *   268.0 220 6 20   3 12     1   6   129 139     8           268
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
697868 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239002437 32 BLACK HAWK MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_7 172.0 61.0 29.0   1.0 27.0     0.0   13.0   144.0 159.0     15.0   *     91.0   48.0   303.0 172 61 29   1 27     0   13   144 159     15     91 48   303
697903 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 2017   grade_7 326.0 4.0 18.0   3.0 5.0     0.0   11.0   188.0 179.0     7.0   *     87.0   40.0   367.0 326 4 18   3 5     0   11   188 179     7     87 40   367
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
697973 MN Hennepin 27 school 2725200 279 Independent Districts and Schools OSSEO PUBLIC SCHOOL DISTRICT 272520001208 33 Brooklyn Middle School, a Science, Technology, Engineering, Art and Math School Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_7 63.0 112.0 34.0   0.0 88.0     0.0   21.0   162.0 156.0     42.0   *     194.0   45.0   318.0 63 112 34   0 88     0   21   162 156     42     194 45   318
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
697981 MN Hennepin 27 school 2725200 279 Independent Districts and Schools OSSEO PUBLIC SCHOOL DISTRICT 272520001214 86 North View Middle School, an IB World School Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_7 20.0 118.0 35.0   2.0 55.0     1.0   12.0   134.0 109.0     39.0   *     210.0   56.0   243.0 20 118 35   2 55     1   12   134 109     39     210 56   243
698005 MN Hennepin 27 school 2733780 283 Independent Districts and Schools ST. LOUIS PARK PUBLIC SCHOOL DIST. 273378001533 42 ST. LOUIS PARK MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_7 175.0 67.0 54.0   0.0 15.0     0.0   27.0   176.0 162.0     34.0   *         37.0   338.0 175 67 54   0 15     0   27   176 162     34       37   338
698013 MN Hennepin 27 school 2742160 284 Independent Districts and Schools WAYZATA PUBLIC SCHOOL DISTRICT 274216001762 52 WAYZATA EAST MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_7 144.0 11.0 10.0   1.0 50.0     0.0   10.0   120.0 106.0     6.0   *     29.0   12.0   226.0 144 11 10   1 50     0   10   120 106     6     29 12   226
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
698143 MN Olmsted 55 school 2731800 535 Independent Districts and Schools ROCHESTER PUBLIC SCHOOL DISTRICT 273180002449 340 FRIEDELL MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_7 101.0 22.0 7.0   0.0 20.0     0.0   8.0   84.0 74.0     10.0   *     31.0   14.0   158.0 101 22 7   0 20     0   8   84 74     10     31 14   158
698180 MN Ramsey 62 school 2723850 622 Independent Districts and Schools North St Paul-Maplewood Oakdale Public School District 272385001170 55 JOHN GLENN MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_7 77.0 48.0 39.0   1.0 62.0     1.0   23.0   115.0 136.0     35.0   *     167.0   47.0   251.0 77 48 39   1 62     1   23   115 136     35     167 47   251
698241 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 2017   grade_7 130.0 0.0 7.0   0.0 0.0     0.0   4.0   73.0 68.0     1.0   *     44.0   29.0   141.0 130 0 7   0 0     0   4   73 68     1     44 29   141
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
698286 MN Sherburne 71 school 2711370 728 Independent Districts and Schools ELK RIVER PUBLIC SCHOOL DISTRICT 271137000517 400 VANDENBERGE MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_7 144.0 1.0 6.0   2.0 1.0     0.0   6.0   92.0 68.0     2.0   *         30.0   160.0 144 1 6   2 1     0   6   92 68     2       30   160
698362 MN Wright 86 school 2721390 882 Independent Districts and Schools MONTICELLO PUBLIC SCHOOL DISTRICT 272139002209 30 MONTICELLO MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_7 296.0 5.0 23.0   1.0 5.0     0.0   4.0   176.0 158.0     10.0   *     90.0   39.0   334.0 296 5 23   1 5     0   4   176 158     10     90 39   334
698385 MN Isanti 30 school 2707410 911 Independent Districts and Schools CAMBRIDGE-ISANTI PUBLIC SCHOOL DIST 270741003629 302 ISANTI MIDDLE SCHOOL Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_7 124.0 3.0 10.0   2.0 2.0     0.0   5.0   78.0 68.0     6.0   *     51.0   18.0   146.0 124 3 10   2 2     0   5   78 68     6     51 18   146
698389 MN Isanti 30 school 2707410 911 Independent Districts and Schools CAMBRIDGE-ISANTI PUBLIC SCHOOL DIST 270741003634 303 MINNESOTA CENTER Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_7 23.0 0.0 1.0   0.0 1.0     0.0   5.0   18.0 12.0     0.0   *         *   30.0 23 0 1   0 1     0   5   18 12     0           30
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
698625 MN Hennepin 27 school 2700405 4235 Charter Schools Flex Academy 270040504794 10 Flex Academy Middle School (Grades 5-8) Regular School Yes Middle 05 08 2017   grade_7 9.0 11.0 16.0   1.0 0.0     0.0   0.0   15.0 22.0     9.0   *     28.0   7.0   37.0 9 11 16   1 0     0   0   15 22     9     28 7   37
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
699753 MN Anoka 2 school 2712420 14 Independent Districts and Schools FRIDLEY PUBLIC SCHOOL DISTRICT 271242003427 652 FRIDLEY MIDDLE AREA LEARNING CENTER Public Area Learning Center ALC (State approved) Alternative School No Middle 05 08 2017   grade_7 8.0 12.0 1.0   0.0 0.0     0.0   2.0   13.0 10.0     2.0   *     14.0   *   23.0 8 12 1   0 0     0   2   13 10     2     14     23
699759 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 2017   grade_7 34.0 0.0 0.0   0.0 0.0     0.0   3.0   20.0 17.0     0.0   *         *   37.0 34 0 0   0 0     0   3   20 17     0           37
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
699921 MN Hennepin 27 school 2742160 284 Independent Districts and Schools WAYZATA PUBLIC SCHOOL DISTRICT 274216003743 952 EAST MIDDLE ALTERNATIVE (EMAP) Public Area Learning Center ALC (State approved) Alternative School No Middle 06 08 2017   grade_7 7.0 4.0 3.0   0.0 1.0     0.0   0.0   8.0 7.0     2.0   *         6.0   15.0 7 4 3   0 1     0   0   8 7     2       6   15
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

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