Data source: Big Local News · About: Big Local

694 rows where grade = "grade_7", state = "MN" and year = 2020 sorted by ell_int

View and edit SQL

year

  • 2020 · 694

grade

  • grade_7 · 694
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
1825229 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 2020   grade_7 31.0 0.0 0.0   8.0 0.0     0.0   0.0   15.0 24.0     *   0.0     19.0   7.0   39.0 31 0 0   8 0     0   0   15 24       0   19 7   39
1825236 MN Anoka 2 school 2733330 16 Independent Districts and Schools Spring Lake Park Public Schools 273333004658 788 Secondary Lighthouse Secondary School (Grades 7-12) Regular School No High 07 12 2020   grade_7 9.0 1.0 1.0   0.0 2.0     0.0   2.0   8.0 7.0     *   0.0         *   15.0 9 1 1   0 2     0   2   8 7       0         15
1825342 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 2020   grade_7 10.0 0.0 0.0   16.0 0.0     0.0   0.0   13.0 13.0     *   *     21.0   6.0   26.0 10 0 0   16 0     0   0   13 13           21 6   26
1825370 MN Clearwater 15 school 2703570 162 Independent Districts and Schools Bagley Public School District 270357000165 20 Bagley Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2020   grade_7 69.0 0.0 0.0   15.0 1.0     0.0   10.0   45.0 50.0     *   0.0     46.0   13.0   95.0 69 0 0   15 1     0   10   45 50       0   46 13   95
1825469 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 2020   grade_7 5.0 0.0 1.0   0.0 0.0     0.0   2.0   3.0 5.0     *   *         *   8.0 5 0 1   0 0     0   2   3 5                 8
1825576 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 2020   grade_7 8.0 0.0 0.0   0.0 0.0     0.0   0.0   6.0 2.0     *   *         *   8.0 8 0 0   0 0     0   0   6 2                 8
1825583 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 2020   grade_7 14.0 0.0 1.0   4.0 0.0     0.0   0.0   8.0 11.0     *   *         *   19.0 14 0 1   4 0     0   0   8 11                 19
1825670 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 2020   grade_7 14.0 0.0 0.0   0.0 0.0     0.0   1.0   11.0 4.0     *   *     9.0   3.0   15.0 14 0 0   0 0     0   1   11 4           9 3   15
1825768 MN Otter Tail 56 school 2728170 548 Independent Districts and Schools Pelican Rapids Public School Dist. 272817001243 20 Pelican Rapids Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2020   grade_7 31.0 8.0 12.0   0.0 0.0     0.0   2.0   24.0 29.0     *   *     30.0   *   53.0 31 8 12   0 0     0   2   24 29           30     53
1825873 MN Ramsey 62 school 2733840 625 Independent Districts and Schools St. Paul Public School District 273384004443 250 Open World Learning Secondary Secondary School (Grades 7-12) Regular School No High 06 12 2020   grade_7 41.0 3.0 14.0   1.0 6.0     0.0   8.0   43.0 30.0     *   1.0     21.0   8.0   73.0 41 3 14   1 6     0   8   43 30       1   21 8   73
1825924 MN Roseau 68 school 2741850 690 Independent Districts and Schools Warroad Public School District 274185001745 30 Warroad High School Secondary School (Grades 7-12) Regular School No High 07 12 2020   grade_7 39.0 1.0 1.0   5.0 7.0     0.0   5.0   30.0 28.0     *   *     23.0   15.0   58.0 39 1 1   5 7     0   5   30 28           23 15   58
1826014 MN Stevens 75 school 2708940 771 Independent Districts and Schools Chokio-Alberta Public School Dist. 270894000361 2 Chokio-Alberta Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2020   grade_7 8.0 0.0 0.0   0.0 0.0     0.0   0.0   3.0 5.0     *   *         *   8.0 8 0 0   0 0     0   0   3 5                 8
1826057 MN Wabasha 79 school 2741060 811 Independent Districts and Schools Wabasha-Kellogg Public School Dist. 274106001722 40 Wabasha-Kellogg Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2020   grade_7 44.0 2.0 2.0   0.0 0.0     0.0   0.0   22.0 26.0     *   *         *   48.0 44 2 2   0 0     0   0   22 26                 48
1826105 MN Watonwan 83 school 2733600 840 Independent Districts and Schools St. James Public School District 273360001505 111 St. James Middle/High School Secondary School (Grades 7-12) Regular School No High 06 12 2020   grade_7 25.0 0.0 37.0   0.0 0.0     0.0   2.0   30.0 34.0     *   0.0     33.0   8.0   64.0 25 0 37   0 0     0   2   30 34       0   33 8   64
1826361 MN Pine 58 school 2711085 2580 Independent Districts and Schools East Central School District 271108500189 30 East Central Senior Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2020   grade_7 40.0 1.0 3.0   10.0 0.0     0.0   3.0   23.0 34.0     *   *         *   57.0 40 1 3   10 0     0   3   23 34                 57
1826535 MN Ramsey 62 school 2702264 916 Intermediate Districts and Schools Northeast Metro 916 270226404818 29 Assessment Center Secondary School (Grades 7-12) Regular School No Other KG 12 2020   grade_7 0.0 1.0 0.0   0.0 0.0     0.0   0.0   0.0 1.0     *   *         *   1.0 0 1 0   0 0     0   0   0 1                 1
1826594 MN Houston 28 school 2700178 4054 Charter Schools LA CRESCENT MONTESSORI ACADEMY 270017804750 20 La Crescent Secondary Montessori & STEM Academy Secondary School (Grades 7-12) Regular School Yes High 07 12 2020   grade_7 9.0 0.0 0.0   0.0 0.0     0.0   0.0   7.0 2.0     *   *         *   9.0 9 0 0   0 0     0   0   7 2                 9
1826609 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 2020   grade_7 1.0 0.0 0.0   0.0 0.0     0.0   1.0   1.0 1.0     *   *         *   2.0 1 0 0   0 0     0   1   1 1                 2
1826623 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 2020   grade_7 6.0 1.0 0.0   0.0 0.0     0.0   0.0   6.0 1.0     *   *         *   7.0 6 1 0   0 0     0   0   6 1                 7
1826639 MN Mcleod 43 school 2700214 4093 Charter Schools New Century Academy 270021403275 10 New Century Academy Secondary School (Grades 7-12) Regular School Yes High 06 12 2020   grade_7 9.0 0.0 0.0   0.0 0.0     0.0   0.0   2.0 7.0     *   *         *   9.0 9 0 0   0 0     0   0   2 7                 9
1826691 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 2020   grade_7 5.0 0.0 2.0   1.0 0.0     0.0   0.0   5.0 3.0     *   *         *   8.0 5 0 2   1 0     0   0   5 3                 8
1826724 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 2020   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
1826733 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 2020   grade_7 6.0 0.0 1.0   0.0 0.0     0.0   0.0   4.0 3.0     *   *         *   7.0 6 0 1   0 0     0   0   4 3                 7
1826740 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 2020   grade_7 3.0 0.0 1.0   0.0 0.0     0.0   0.0   1.0 3.0     *   *         *   4.0 3 0 1   0 0     0   0   1 3                 4
1826764 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 2020   grade_7 1.0 6.0 0.0   0.0 0.0     0.0   0.0   6.0 1.0     *   *         *   7.0 1 6 0   0 0     0   0   6 1                 7
1827151 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 2020   grade_7 0.0 0.0 2.0   2.0 0.0     0.0   0.0   2.0 2.0     *   *         *   4.0 0 0 2   2 0     0   0   2 2                 4
1827229 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 2020   grade_7 0.0 0.0 0.0   18.0 0.0     0.0   0.0   9.0 9.0     *   *         *   18.0 0 0 0   18 0     0   0   9 9                 18
1828895 MN Hennepin 27 school 2731780 281 Independent Districts and Schools Robbinsdale Public School District 273178004952 401 The FAIR School - Crystal Elementary School (Grades PK-6) Regular School No Middle 05 08 2020   grade_7 29.0 47.0 12.0   1.0 1.0     0.0   14.0   49.0 55.0     *   3.0         *   104.0 29 47 12   1 1     0   14   49 55       3         104
1829732 MN Olmsted 55 school 2731800 535 Independent Districts and Schools Rochester Public School District 273180001004 136 Jefferson Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 07 2020   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
1832326 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 2020   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
1833132 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 2020   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
1833178 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 2020   grade_7 11.0 0.0 0.0   0.0 0.0     0.0   0.0   7.0 4.0     *   *         *   11.0 11 0 0   0 0     0   0   7 4                 11
1833305 MN Hennepin 27 school 2700237 4097 Charter Schools Partnership Academy, Inc. 270023703278 10 Partnership Academy, Inc. Elementary School (Grades PK-6) Regular School Yes Elementary KG 07 2020   grade_7 0.0 3.0 43.0   0.0 0.0     0.0   0.0   24.0 22.0     *   0.0     35.0   6.0   46.0 0 3 43   0 0     0   0   24 22       0   35 6   46
1833323 MN Cook 16 school 2700339 4100 Charter Schools Great Expectations 270033904177 10 Great Expectations Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2020   grade_7 8.0 0.0 0.0   0.0 0.0     0.0   0.0   3.0 5.0     *   *         *   8.0 8 0 0   0 0     0   0   3 5                 8
1833749 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 2020   grade_7 6.0 0.0 0.0   0.0 0.0     0.0   1.0   3.0 4.0     *   *         *   7.0 6 0 0   0 0     0   1   3 4                 7
1833831 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 2020   grade_7 1.0 4.0 0.0   0.0 2.0     0.0   0.0   3.0 4.0     *   *         *   7.0 1 4 0   0 2     0   0   3 4                 7
1833852 MN Hennepin 27 school 2700396 4226 Charter Schools Bdote Learning Center 270039604763 10 Bdote Learning Center Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2020   grade_7 0.0 0.0 2.0   6.0 0.0     0.0   0.0   2.0 6.0     *   *         *   8.0 0 0 2   6 0     0   0   2 6                 8
1833987 MN Hennepin 27 school 2700439 4261 Charter Schools SciTech Academy Charter School 270043905072 10 SciTech Academy Charter School Elementary School (Grades PK-6) Regular School Yes Elementary KG 07 2020   grade_7 0.0 23.0 0.0   0.0 0.0     0.0   0.0   16.0 7.0     *   0.0         6.0   23.0 0 23 0   0 0     0   0   16 7       0     6   23
1834178 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 2020   grade_7 417.0 29.0 30.0   2.0 31.0     0.0   33.0   260.0 282.0     *   4.0     90.0   83.0   542.0 417 29 30   2 31     0   33   260 282       4   90 83   542
1834182 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 2020   grade_7 35.0 73.0 107.0   4.0 7.0     0.0   15.0   128.0 113.0     *   *         *   241.0 35 73 107   4 7     0   15   128 113                 241
1834191 MN Anoka 2 school 2733540 15 Independent Districts and Schools St. Francis Area Schools 273354000013 123 St. Francis Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2020   grade_7 160.0 1.0 10.0   4.0 7.0     0.0   12.0   101.0 93.0     *   0.0         *   194.0 160 1 10   4 7     0   12   101 93       0         194
1834196 MN Anoka 2 school 2733330 16 Independent Districts and Schools Spring Lake Park Public Schools 273333001466 92 Westwood Intermediate and Middle School Middle School (Grades 5-8) Regular School No Middle 05 08 2020   grade_7 261.0 67.0 72.0   5.0 30.0     2.0   32.0   251.0 218.0     *   6.0         *   469.0 261 67 72   5 30     2   32   251 218       6         469
1834201 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 2020   grade_7 178.0 5.0 8.0   28.0 2.0     0.0   28.0   132.0 117.0     *   3.0     97.0   42.0   249.0 178 5 8   28 2     0   28   132 117       3   97 42   249
1834231 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 2020   grade_7 143.0 0.0 6.0   27.0 1.0     0.0   36.0   106.0 107.0     *   *         *   213.0 143 0 6   27 1     0   36   106 107                 213
1834261 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 2020   grade_7 6.0 0.0 1.0   81.0 0.0     0.0   0.0   49.0 39.0     *   *         *   88.0 6 0 1   81 0     0   0   49 39                 88
1834325 MN Dakota 19 school 2717780 194 Independent Districts and Schools Lakeville Public School District 271778002435 89 McGuire Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2020   grade_7 255.0 14.0 20.0   1.0 13.0     1.0   18.0   163.0 159.0     *   *     39.0   33.0   322.0 255 14 20   1 13     1   18   163 159           39 33   322
1834341 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 2020   grade_7 145.0 56.0 29.0   0.0 24.0     0.0   18.0   119.0 153.0     *   0.0     84.0   53.0   272.0 145 56 29   0 24     0   18   119 153       0   84 53   272
1834345 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 2020   grade_7 328.0 22.0 20.0   1.0 31.0     0.0   28.0   208.0 222.0     *   *         38.0   430.0 328 22 20   1 31     0   28   208 222             38   430
1834362 MN Dakota 19 school 2742270 197 Independent Districts and Schools West St. Paul-Mendota Hts.-Eagan 274227002646 52 Friendly Hills Middle Middle School (Grades 5-8) Regular School No Middle 05 08 2020   grade_7 104.0 31.0 48.0   3.0 9.0     0.0   14.0   109.0 100.0     *   *         33.0   209.0 104 31 48   3 9     0   14   109 100             33   209
1834367 MN Dakota 19 school 2742270 197 Independent Districts and Schools West St. Paul-Mendota Hts.-Eagan 274227001774 54 Heritage E-STEM Magnet School Middle School (Grades 5-8) Regular School No Middle 05 08 2020   grade_7 88.0 19.0 71.0   3.0 6.0     0.0   14.0   109.0 92.0     *   4.0     106.0   45.0   201.0 88 19 71   3 6     0   14   109 92       4   106 45   201
1834393 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 2020   grade_7 162.0 10.0 58.0   1.0 23.0     0.0   12.0   129.0 137.0     *   *         *   266.0 162 10 58   1 23     0   12   129 137                 266
1834456 MN Hennepin 27 school 2725200 279 Independent Districts and Schools Osseo Public School District 272520002278 94 Maple Grove Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2020   grade_7 370.0 70.0 46.0   3.0 49.0     0.0   33.0   304.0 267.0     *   1.0         56.0   571.0 370 70 46   3 49     0   33   304 267       1     56   571
1834484 MN Hennepin 27 school 2742160 284 Independent Districts and Schools Wayzata Public School District 274216001764 51 Wayzata West Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2020   grade_7 165.0 14.0 13.0   1.0 49.0     0.0   19.0   128.0 133.0     *   1.0         21.0   261.0 165 14 13   1 49     0   19   128 133       1     21   261
1834496 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 2020   grade_7 4.0 57.0 27.0   2.0 29.0     0.0   8.0   70.0 57.0     *   *         *   127.0 4 57 27   2 29     0   8   70 57                 127
1834524 MN Itasca 31 school 2713170 318 Independent Districts and Schools Grand Rapids Public School District 271317000939 370 Robert J. Elkington Middle School Middle School (Grades 5-8) Regular School No Middle 05 08 2020   grade_7 290.0 1.0 5.0   5.0 1.0     0.0   23.0   177.0 148.0     *   0.0     114.0   45.0   325.0 290 1 5   5 1     0   23   177 148       0   114 45   325
1834547 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 2020   grade_7 198.0 1.0 16.0   0.0 3.0     0.0   8.0   111.0 115.0     *   *     53.0   *   226.0 198 1 16   0 3     0   8   111 115           53     226
1834561 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 2020   grade_7 257.0 0.0 5.0   3.0 0.0     0.0   7.0   135.0 137.0     *   *         *   272.0 257 0 5   3 0     0   7   135 137                 272
1834568 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 2020   grade_7 17.0 0.0 3.0   21.0 0.0     0.0   5.0   20.0 26.0     *   *         *   46.0 17 0 3   21 0     0   5   20 26                 46
1834599 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 2020   grade_7 120.0 18.0 28.0   1.0 3.0     0.0   3.0   106.0 67.0     *   *         *   173.0 120 18 28   1 3     0   3   106 67                 173
1834608 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 2020   grade_7 59.0 15.0 148.0   0.0 23.0     0.0   5.0   117.0 133.0     *   *     188.0   37.0   250.0 59 15 148   0 23     0   5   117 133           188 37   250
1834628 MN Olmsted 55 school 2731800 535 Independent Districts and Schools Rochester Public School District 273180005219 329 Middle School Right Fit Middle School (Grades 5-8) Regular School No Middle 06 08 2020   grade_7 3.0 2.0 1.0   0.0 0.0     0.0   0.0   5.0 1.0     *   *         *   6.0 3 2 1   0 0     0   0   5 1                 6
1834637 MN Olmsted 55 school 2731800 535 Independent Districts and Schools Rochester Public School District 273180001020 335 Kellogg Middle Middle School (Grades 5-8) Regular School No Middle 05 08 2020   grade_7 240.0 42.0 32.0   1.0 49.0     0.0   21.0   193.0 192.0     *   4.0         48.0   385.0 240 42 32   1 49     0   21   193 192       4     48   385
1834750 MN Saint Louis 69 school 2711040 709 Independent Districts and Schools Duluth Public School District 271104000489 335 Ordean East Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2020   grade_7 310.0 7.0 9.0   7.0 3.0     0.0   21.0   169.0 188.0     *   2.0     60.0   24.0   357.0 310 7 9   7 3     0   21   169 188       2   60 24   357
1834799 MN Sherburne 71 school 2711370 728 Independent Districts and Schools Elk River School District 271137000517 400 VandenBerge Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2020   grade_7 158.0 6.0 9.0   2.0 4.0     0.0   6.0   91.0 94.0     *   0.0     35.0   34.0   185.0 158 6 9   2 4     0   6   91 94       0   35 34   185
1834827 MN Stearns 73 school 2709440 750 Independent Districts and Schools Rocori Public School District 270944001682 60 Rocori Middle Middle School (Grades 5-8) Regular School No Middle 06 08 2020   grade_7 175.0 1.0 22.0   0.0 0.0     0.0   3.0   106.0 95.0     *   *         *   201.0 175 1 22   0 0     0   3   106 95                 201
1834951 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 2020   grade_7 90.0 2.0 6.0   0.0 2.0     0.0   2.0   55.0 47.0     *   *         *   102.0 90 2 6   0 2     0   2   55 47                 102
1834982 MN Wright 86 school 2700123 2687 Independent Districts and Schools Howard Lake-Waverly-Winsted 270012303350 86 Howard Lake-Waverly-Winsted Middle School Middle School (Grades 5-8) Regular School No Middle 05 08 2020   grade_7 108.0 0.0 4.0   1.0 1.0     0.0   4.0   66.0 52.0     *   0.0     27.0   13.0   118.0 108 0 4   1 1     0   4   66 52       0   27 13   118
1834987 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 2020   grade_7 59.0 2.0 12.0   0.0 0.0     0.0   5.0   48.0 30.0     *   *         *   78.0 59 2 12   0 0     0   5   48 30                 78
1835064 MN Hennepin 27 school 2700220 4067 Charter Schools Aurora Charter School 270022004420 20 Aurora Middle School Middle School (Grades 5-8) Regular School Yes Middle 05 08 2020   grade_7 0.0 0.0 48.0   0.0 0.0     0.0   0.0   17.0 31.0     *   0.0     43.0   4.0   48.0 0 0 48   0 0     0   0   17 31       0   43 4   48
1835544 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 2020   grade_7 5.0 0.0 0.0   0.0 0.0     0.0   0.0   3.0 2.0     *   *         *   5.0 5 0 0   0 0     0   0   3 2                 5
1836110 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 2020   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
1836285 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 2020   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
1836332 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 2020   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
1836347 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 2020   grade_7 0.0 0.0 0.0   0.0 0.0     0.0   1.0   1.0 0.0     *   *         *   1.0 0 0 0   0 0     0   1   1 0                 1
1836374 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 2020   grade_7 0.0 0.0 0.0   1.0 0.0     0.0   0.0   1.0 0.0     *   *         *   1.0 0 0 0   1 0     0   0   1 0                 1
1836397 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 2020   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
1836425 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 High 06 12 2020   grade_7 4.0 0.0 1.0   0.0 0.0     0.0   0.0   3.0 2.0     *   *         *   5.0 4 0 1   0 0     0   0   3 2                 5
1836443 MN Hennepin 27 school 2731780 281 Independent Districts and Schools Robbinsdale Public School District 273178004630 903 Robbinsdale TASC ALC Public Area Learning Center ALC (State approved) Alternative School No High 07 12 2020   grade_7 0.0 1.0 0.0   0.0 0.0     0.0   0.0   0.0 1.0     *   *         *   1.0 0 1 0   0 0     0   0   0 1                 1
1836451 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 2020   grade_7 4.0 6.0 1.0   0.0 2.0     0.0   2.0   8.0 7.0     *   *         0.0   15.0 4 6 1   0 2     0   2   8 7             0   15
1836454 MN Hennepin 27 school 2742160 284 Independent Districts and Schools Wayzata Public School District 274216003740 953 Central Middle Alternative (CMAP) Public Area Learning Center ALC (State approved) Alternative School No Middle 06 08 2020   grade_7 3.0 4.0 0.0   0.0 0.0     0.0   1.0   6.0 2.0     *   *         *   8.0 3 4 0   0 0     0   1   6 2                 8
1836487 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 2020   grade_7 0.0 1.0 3.0   0.0 0.0     0.0   0.0   4.0 0.0     *   *         *   4.0 0 1 3   0 0     0   0   4 0                 4
1836506 MN Mcleod 43 school 2714970 423 Independent Districts and Schools Hutchinson Public School District 271497003522 75 Hutchinson Middle School A.L.C. Public Area Learning Center ALC (State approved) Alternative School No Middle 06 08 2020   grade_7 9.0 1.0 3.0   0.0 0.0     0.0   2.0   8.0 7.0     *   0.0         *   15.0 9 1 3   0 0     0   2   8 7       0         15
1836554 MN Nobles 53 school 2744160 518 Independent Districts and Schools Worthington Public School District 274416002335 6 Learning Center Public Area Learning Center ALC (State approved) Alternative School No High 07 12 2020   grade_7 0.0 0.0 0.0   0.0 1.0     0.0   0.0   1.0 0.0     *   *         *   1.0 0 0 0   0 1     0   0   1 0                 1
1836578 MN Otter Tail 56 school 2728170 548 Independent Districts and Schools Pelican Rapids Public School Dist. 272817004487 60 Pelican Rapids Alt Center Mid-Level Public Area Learning Center ALC (State approved) Alternative School No Middle 07 10 2020   grade_7 6.0 2.0 6.0   0.0 0.0     0.0   0.0   6.0 8.0     *   *     9.0   *   14.0 6 2 6   0 0     0   0   6 8           9     14
1836679 MN Stearns 73 school 2709440 750 Independent Districts and Schools Rocori Public School District 270944004629 70 Rocori ALC Public Area Learning Center ALC (State approved) Alternative School No High 07 12 2020   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
1836734 MN Pine 58 school 2711085 2580 Independent Districts and Schools East Central School District 271108500222 35 Crossroads Area Learning Center Public Area Learning Center ALC (State approved) Alternative School No High 07 12 2020   grade_7 0.0 0.0 0.0   0.0 0.0     0.0   1.0   1.0 0.0     *   *         *   1.0 0 0 0   0 0     0   1   1 0                 1
1836853 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 High 06 12 2020   grade_7 2.0 1.0 0.0   0.0 0.0     0.0   0.0   1.0 2.0     *   *         *   3.0 2 1 0   0 0     0   0   1 2                 3
1836869 MN Chippewa 12 school 2700058 6018 Education Districts MN River Valley Education District 270005802245 20 MN River Valley ALC-Seatbased Public Area Learning Center ALC (State approved) Alternative School No High 07 12 2020   grade_7 0.0 0.0 1.0   0.0 0.0     0.0   0.0   1.0 0.0     *   *         *   1.0 0 0 1   0 0     0   0   1 0                 1
1836876 MN Stearns 73 school 2791455 6026 Education Districts West Central Education District 279145502388 20 West Central Area Learning Center Public Area Learning Center ALC (State approved) Alternative School No High 06 12 2020   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
1836883 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 2020   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
1836904 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 2020   grade_7 0.0 0.0 0.0   0.0 0.0     0.0   1.0   1.0 0.0     *   *         *   1.0 0 0 0   0 0     0   1   1 0                 1
1836929 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 2020   grade_7 5.0 1.0 1.0   0.0 0.0     0.0   0.0   6.0 1.0     *   *         *   7.0 5 1 1   0 0     0   0   6 1                 7
1836958 MN Beltrami 4 school 2704440 31 Independent Districts and Schools Bemidji Public School District 270444004194 70 Lakeside Learning Center Special Education Special Education School No High 06 12 2020   grade_7 0.0 0.0 0.0   1.0 0.0     0.0   0.0   1.0 0.0     *   *         *   1.0 0 0 0   1 0     0   0   1 0                 1
1836976 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 2020   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
1837028 MN Dakota 19 school 2742270 197 Independent Districts and Schools West St. Paul-Mendota Hts.-Eagan 274227005008 827 Special Education Special Education Special Education School No Other KG 12 2020   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
1837072 MN Hennepin 27 school 2725200 279 Independent Districts and Schools Osseo Public School District 272520003593 45 Achieve Special Education Special Education School No Other KG 12 2020   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
1837155 MN Olmsted 55 school 2731800 535 Independent Districts and Schools Rochester Public School District 273180000985 342 Rochester Phoenix Academy Special Education Special Education School No Other KG 12 2020   grade_7 0.0 3.0 0.0   0.0 0.0     0.0   3.0   2.0 4.0     *   *         *   6.0 0 3 0   0 0     0   3   2 4                 6
1837173 MN Ramsey 62 school 2722950 621 Independent Districts and Schools Mounds View Public School District 272295002998 39 Mounds View Bridges Program Special Education Special Education School No Elementary KG 07 2020   grade_7 4.0 2.0 0.0   0.0 0.0     0.0   0.0   6.0 0.0     *   *         *   6.0 4 2 0   0 0     0   0   6 0                 6
1837199 MN Ramsey 62 school 2723850 622 Independent Districts and Schools North St. Paul-Maplewood Oakdale Public School District 272385003374 41 Harmony Learning Center Special Education Special Education School No Other KG 12 2020   grade_7 2.0 3.0 0.0   0.0 0.0     0.0   2.0   4.0 3.0     *   *         *   7.0 2 3 0   0 0     0   2   4 3                 7
1837224 MN Ramsey 62 school 2733840 625 Independent Districts and Schools St. Paul Public School District 273384002189 430 Bridge View Special Education Special Education Special Education School No Other KG 12 2020   grade_7 1.0 4.0 0.0   0.0 4.0     0.0   0.0   7.0 2.0     *   *         *   9.0 1 4 0   0 4     0   0   7 2                 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]);