Data source: Big Local News · About: Big Local

694 rows where grade = "grade_7", state = "MN" and year = 2021

View and edit SQL

year

  • 2021 · 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
1711653 MN Aitkin 1 school 2702760 1 Independent Districts and Schools Aitkin Public School District 270276000057 1 Aitkin Secondary School Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 85 1 1   1 2     0   3   42 51     1.0   0.0     29.0   16.0   93 85 1 1   1 2     0   3   42 51     1 0   29 16   93
1711660 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 2021   grade_7 25 0 0   4 0     0   1   17 13     0.0   0.0     9.0   8.0   30 25 0 0   4 0     0   1   17 13     0 0   9 8   30
1711667 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 2021   grade_7 11 1 0   0 0     0   0   6 6     0.0   0.0     1.0   0.0   12 11 1 0   0 0     0   0   6 6     0 0   1 0   12
1711674 MN Becker 3 school 2712360 23 Independent Districts and Schools Frazee-Vergas Public School District 271236000606 20 Frazee Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 66 0 1   2 0     0   5   39 35     0.0   0.0     29.0   14.0   74 66 0 1   2 0     0   5   39 35     0 0   29 14   74
1711681 MN Beltrami 4 school 2705730 32 Independent Districts and Schools Blackduck Public School District 270573000213 20 Blackduck Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 40 0 2   5 0     0   4   25 26     0.0   1.0     21.0   11.0   51 40 0 2   5 0     0   4   25 26     0 1   21 11   51
1711688 MN Beltrami 4 school 2717010 36 Independent Districts and Schools Kelliher Public School District 271701000787 20 Kelliher Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 14 0 0   13 0     0   0   15 12     0.0   0.0     22.0   5.0   27 14 0 0   13 0     0   0   15 12     0 0   22 5   27
1711695 MN Blue Earth 7 school 2733480 75 Independent Districts and Schools St. Clair Public School District 273348001478 20 St. Clair Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 70 0 0   0 0     0   0   38 32     0.0   0.0     11.0   10.0   70 70 0 0   0 0     0   0   38 32     0 0   11 10   70
1711702 MN Brown 8 school 2709540 81 Independent Districts and Schools Comfrey Public School District 270954000404 20 Comfrey Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 8 0 1   0 0     0   0   2 7     *   *     *   *   9 8 0 1   0 0     0   0   2 7                 9
1711709 MN Brown 8 school 2733210 84 Independent Districts and Schools Sleepy Eye Public School District 273321001451 20 Sleepy Eye Sec. Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 24 3 17   0 0     0   1   23 22     2.0   1.0     16.0   10.0   45 24 3 17   0 0     0   1   23 22     2 1   16 10   45
1711716 MN Brown 8 school 2733390 85 Independent Districts and Schools Springfield Public School District 273339001471 1 Springfield Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 47 0 4   0 1     0   0   27 25     1.0   0.0     22.0   1.0   52 47 0 4   0 1     0   0   27 25     1 0   22 1   52
1711723 MN Carlton 9 school 2703690 91 Independent Districts and Schools Barnum Public School District 270369000172 2 Barnum Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 57 0 3   0 0     0   8   29 39     0.0   0.0     19.0   9.0   68 57 0 3   0 0     0   8   29 39     0 0   19 9   68
1711731 MN Carlton 9 school 2707590 93 Independent Districts and Schools Carlton Public School District 270759000327 1 Carlton Secondary Secondary School (Grades 7-12) Regular School No High 06 12 2021   grade_7 21 1 0   5 0     0   0   13 14     0.0   0.0     7.0   4.0   27 21 1 0   5 0     0   0   13 14     0 0   7 4   27
1711738 MN Carlton 9 school 2709690 95 Independent Districts and Schools Cromwell-Wright Public Schools 270969000409 20 Cromwell-Wright Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 23 0 1   2 0     0   1   15 12     0.0   0.0     7.0   4.0   27 23 0 1   2 0     0   1   15 12     0 0   7 4   27
1711745 MN Carlton 9 school 2721450 97 Independent Districts and Schools Moose Lake Public School District 272145001094 10 Moose Lake Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 42 0 0   0 0     0   4   29 17     0.0   1.0     9.0   4.0   46 42 0 0   0 0     0   4   29 17     0 1   9 4   46
1711752 MN Carlton 9 school 2738880 99 Independent Districts and Schools Esko Public School District 273888001681 1 Lincoln Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 95 0 2   0 0     0   7   56 48     0.0   0.0     7.0   17.0   104 95 0 2   0 0     0   7   56 48     0 0   7 17   104
1711759 MN Carlton 9 school 2744190 100 Independent Districts and Schools Wrenshall Public School District 274419001843 2 Wrenshall Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 29 0 1   1 0     0   2   18 15     0.0   0.0     18.0   7.0   33 29 0 1   1 0     0   2   18 15     0 0   18 7   33
1711766 MN Cass 11 school 2702910 113 Independent Districts and Schools Walker-Hackensack-Akeley School District 270291001737 20 Walker-Hackensack-Akeley Sec. Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 30 1 0   11 0     0   7   32 17     0.0   1.0     28.0   7.0   49 30 1 0   11 0     0   7   32 17     0 1   28 7   49
1711773 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 2021   grade_7 15 0 1   10 0     0   0   7 19     *   *     *   *   26 15 0 1   10 0     0   0   7 19                 26
1711780 MN Chisago 13 school 2732550 139 Independent Districts and Schools Rush City Public School District 273255001406 20 Rush City Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 47 1 2   1 1     0   5   29 28     0.0   0.0     16.0   9.0   57 47 1 2   1 1     0   5   29 28     0 0   16 9   57
1711787 MN Clay 14 school 2703660 146 Independent Districts and Schools Barnesville Public School District 270366000170 40 Barnesville Secondary Secondary School (Grades 7-12) Regular School No High 06 12 2021   grade_7 64 2 0   2 0     0   4   39 33     0.0   0.0     15.0   6.0   72 64 2 0   2 0     0   4   39 33     0 0   15 6   72
1711794 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 2021   grade_7 60 1 2   0 1     0   2   37 29     0.0   0.0     6.0   6.0   66 60 1 2   0 1     0   2   37 29     0 0   6 6   66
1711801 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 2021   grade_7 54 0 0   11 0     0   8   32 41     *   0.0     38.0   10.0   73 54 0 0   11 0     0   8   32 41       0   38 10   73
1711808 MN Cottonwood 17 school 2723010 173 Independent Districts and Schools Mountain Lake Public Schools 272301001135 20 Mountain Lake Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 17 0 11   0 10     0   0   18 20     0.0   0.0     21.0   8.0   38 17 0 11   0 10     0   0   18 20     0 0   21 8   38
1711815 MN Crow Wing 18 school 2709750 182 Independent Districts and Schools Crosby-Ironton Public School District 270975000417 1 Crosby-Ironton Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 76 0 0   0 1     0   6   47 36     0.0   0.0     27.0   20.0   83 76 0 0   0 1     0   6   47 36     0 0   27 20   83
1711822 MN Dakota 19 school 2730150 195 Independent Districts and Schools Randolph Public School District 273015001287 20 Randolph Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 50 0 2   0 0     0   1   34 19     0.0   2.0     8.0   11.0   53 50 0 2   0 0     0   1   34 19     0 2   8 11   53
1711830 MN Dodge 20 school 2713590 203 Independent Districts and Schools Hayfield Public School District 271359000702 1 HAYFIELD SECONDARY Secondary School (Grades 7-12) Regular School No High 06 12 2021   grade_7 51 0 6   0 0     0   2   25 34     0.0   0.0     16.0   9.0   59 51 0 6   0 0     0   2   25 34     0 0   16 9   59
1711837 MN Douglas 21 school 2725140 213 Independent Districts and Schools Osakis Public School District 272514001204 20 Osakis Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 56 0 2   0 0     0   1   31 28     0.0   0.0     15.0   9.0   59 56 0 2   0 0     0   1   31 28     0 0   15 9   59
1711844 MN Olmsted 55 school 2708220 227 Independent Districts and Schools Chatfield Public Schools 270822000348 1 Chatfield Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 69 0 1   0 1     0   3   37 37     0.0   0.0     10.0   11.0   74 69 0 1   0 1     0   3   37 37     0 0   10 11   74
1711851 MN Fillmore 23 school 2717910 229 Independent Districts and Schools Lanesboro Public School District 271791000824 20 Lanesboro Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 25 0 0   0 0     0   0   10 15     0.0   0.0     6.0   0.0   25 25 0 0   0 0     0   0   10 15     0 0   6 0   25
1711858 MN Fillmore 23 school 2718540 238 Independent Districts and Schools Mabel-Canton Public School Dist. 271854000858 2 Mabel-Canton Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 22 0 0   0 0     0   0   17 5     0.0   0.0     7.0   3.0   22 22 0 0   0 0     0   0   17 5     0 0   7 3   22
1711865 MN Freeborn 24 school 2703030 242 Independent Districts and Schools Alden-Conger Public School District 270303000080 1 Alden-Conger Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 34 0 0   0 0     0   0   15 19     0.0   0.0     12.0   7.0   34 34 0 0   0 0     0   0   15 19     0 0   12 7   34
1711873 MN Goodhue 25 school 2707500 252 Independent Districts and Schools Cannon Falls Public School District 270750000324 2 Cannon Falls Secondary Secondary School (Grades 7-12) Regular School No High 06 12 2021   grade_7 89 0 3   0 2     0   2   52 44     1.0   0.0     13.0   16.0   96 89 0 3   0 2     0   2   52 44     1 0   13 16   96
1711880 MN Goodhue 25 school 2712900 253 Independent Districts and Schools Goodhue Public School District 271290000648 2 Goodhue Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 41 0 8   0 0     0   3   22 30     4.0   0.0     9.0   6.0   52 41 0 8   0 0     0   3   22 30     4 0   9 6   52
1711887 MN Goodhue 25 school 2730480 256 Independent Districts and Schools Red Wing Public School District 273048001293 108 Red Wing Senior High Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 146 8 21   5 1     0   13   87 107     4.0   1.0     57.0   19.0   194 146 8 21   5 1     0   13   87 107     4 1   57 19   194
1711894 MN Grant 26 school 2703300 261 Independent Districts and Schools Ashby Public School District 270330000137 20 Ashby Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 22 0 0   1 0     0   0   10 13     0.0   0.0     9.0   2.0   23 22 0 0   1 0     0   0   10 13     0 0   9 2   23
1711901 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 2021   grade_7 6 0 1   0 0     0   1   3 5     *   *     *   *   8 6 0 1   0 0     0   1   3 5                 8
1711914 MN Houston 28 school 2714280 294 Independent Districts and Schools Houston Public School District 271428000749 20 Houston Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 31 1 1   0 0     0   1   14 20     0.0   0.0     11.0   6.0   34 31 1 1   0 0     0   1   14 20     0 0   11 6   34
1711921 MN Houston 28 school 2733300 297 Independent Districts and Schools Spring Grove School District 273330001459 20 Spring Grove Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 33 1 0   0 0     0   1   17 18     0.0   0.0     7.0   3.0   35 33 1 0   0 0     0   1   17 18     0 0   7 3   35
1711928 MN Hubbard 29 school 2723370 308 Independent Districts and Schools Nevis Public School District 272337001140 20 Nevis Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 47 0 1   1 0     0   0   18 31     0.0   0.0     25.0   9.0   49 47 0 1   1 0     0   0   18 31     0 0   25 9   49
1711935 MN Isanti 30 school 2706060 314 Independent Districts and Schools Braham Public School District 270606000247 1 Braham Area Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 58 1 3   0 0     0   6   32 36     0.0   0.0     28.0   5.0   68 58 1 3   0 0     0   6   32 36     0 0   28 5   68
1711943 MN Itasca 31 school 2710140 317 Independent Districts and Schools Deer River Public School District 271014000433 1 Deer River Secondary Secondary School (Grades 7-12) Regular School No High 06 12 2021   grade_7 37 0 2   23 0     0   8   37 33     0.0   9.0     46.0   13.0   70 37 0 2   23 0     0   8   37 33     0 9   46 13   70
1711950 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 2021   grade_7 13 0 0   2 0     0   1   8 8     *   0.0     *   6.0   16 13 0 0   2 0     0   1   8 8       0     6   16
1711957 MN Itasca 31 school 2723310 319 Independent Districts and Schools Nashwauk-Keewatin School District 272331001138 50 Nashwauk Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 33 0 0   0 1     0   7   20 21     0.0   0.0     23.0   10.0   41 33 0 0   0 1     0   7   20 21     0 0   23 10   41
1711964 MN Jackson 32 school 2713930 330 Independent Districts and Schools Heron Lake-Okabena School District 271393000017 30 Heron Lake-Okabena Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 23 1 5   0 0     0   0   14 15     2.0   0.0     19.0   3.0   29 23 1 5   0 0     0   0   14 15     2 0   19 3   29
1711971 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 2021   grade_7 102 2 4   1 0     0   3   43 69     0.0   0.0     31.0   18.0   112 102 2 4   1 0     0   3   43 69     0 0   31 18   112
1711979 MN Kanabec 33 school 2723970 333 Independent Districts and Schools Ogilvie Public School District 272397001189 20 Ogilvie Secondary Secondary School (Grades 7-12) Regular School No High 06 12 2021   grade_7 29 0 0   0 0     0   1   19 11     0.0   0.0     5.0   2.0   30 29 0 0   0 0     0   1   19 11     0 0   5 2   30
1711986 MN Kittson 35 school 2717880 356 Independent Districts and Schools Lancaster Public School District 271788000822 20 Lancaster Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 17 1 0   0 0     0   0   7 11     0.0   0.0     6.0   6.0   18 17 1 0   0 0     0   0   7 11     0 0   6 6   18
1711994 MN Koochiching 36 school 2715000 361 Independent Districts and Schools International Falls School District 271500000761 1 Falls Secondary Secondary School (Grades 7-12) Regular School No High 06 12 2021   grade_7 79 0 1   5 0     0   2   43 44     0.0   0.0     30.0   11.0   87 79 0 1   5 0     0   2   43 44     0 0   30 11   87
1712001 MN Koochiching 36 school 2718270 362 Independent Districts and Schools Littlefork-Big Falls School Dist. 271827000848 30 Littlefork-Big Falls Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 26 0 0   0 0     0   0   13 13     0.0   0.0     9.0   5.0   26 26 0 0   0 0     0   0   13 13     0 0   9 5   26
1712008 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 2021   grade_7 12 0 0   0 0     0   0   5 7     0.0   0.0     5.0   3.0   12 12 0 0   0 0     0   0   5 7     0 0   5 3   12
1712015 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 2021   grade_7 8 0 0   4 0     0   0   5 7     0.0   0.0     6.0   3.0   12 8 0 0   4 0     0   0   5 7     0 0   6 3   12
1712022 MN Lac qui Parle 37 school 2710090 378 Independent Districts and Schools Dawson-Boyd Public School District 271009000430 20 Dawson-Boyd Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 40 0 3   0 0     0   1   23 21     0.0   0.0     11.0   12.0   44 40 0 3   0 0     0   1   23 21     0 0   11 12   44
1712029 MN Lake 38 school 2740740 381 Independent Districts and Schools Lake Superior Public School Dist. 274074001697 90 Wm. M. Kelley Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 32 0 0   0 0     0   0   10 22     0.0   0.0     8.0   6.0   32 32 0 0   0 0     0   0   10 22     0 0   8 6   32
1712037 MN Lake 38 school 2740740 381 Independent Districts and Schools Lake Superior Public School Dist. 274074001701 200 Two Harbors Secondary Secondary School (Grades 7-12) Regular School No High 06 12 2021   grade_7 83 0 0   1 0     0   2   45 41     0.0   0.0     17.0   14.0   86 83 0 0   1 0     0   2   45 41     0 0   17 14   86
1712044 MN Lake of the Woods 39 school 2717570 390 Independent Districts and Schools Lake of The Woods School District 271757000809 222 Lake of The Woods Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 24 0 0   0 1     0   1   13 13     0.0   0.0     8.0   4.0   26 24 0 0   0 1     0   1   13 13     0 0   8 4   26
1712051 MN Lesueur 40 school 2709330 391 Independent Districts and Schools Cleveland Public School District 270933000375 20 Cleveland Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 36 0 5   0 0     0   0   26 15     0.0   1.0     11.0   5.0   41 36 0 5   0 0     0   0   26 15     0 1   11 5   41
1712058 MN Lincoln 41 school 2717460 404 Independent Districts and Schools Lake Benton Public School District 271746000802 20 Lake Benton Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 1 0 0   0 0     0   0   0 1     *   *     *   *   1 1 0 0   0 0     0   0   0 1                 1
1712060 MN Lyon 42 school 2721270 414 Independent Districts and Schools Minneota Public School District 272127001068 2 Minneota Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 36 0 9   0 0     0   2   35 12     3.0   0.0     11.0   6.0   47 36 0 9   0 0     0   2   35 12     3 0   11 6   47
1712067 MN Mcleod 43 school 2702640 424 Independent Districts and Schools Lester Prairie Public School Dist. 270264000049 20 Lester Prairie Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 32 0 10   0 0     0   0   18 24     1.0   0.0     11.0   2.0   42 32 0 10   0 0     0   0   18 24     1 0   11 2   42
1712074 MN Mahnomen 44 school 2718660 432 Independent Districts and Schools Mahnomen Public School District 271866000866 20 Mahnomen Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 14 0 5   46 0     0   4   33 36     *   *     *   *   69 14 0 5   46 0     0   4   33 36                 69
1712081 MN Mahnomen 44 school 2742120 435 Independent Districts and Schools Waubun-Ogema-White Earth Public Sch 274212001756 30 Waubun Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 6 0 2   32 0     0   7   29 18     0.0   0.0     28.0   5.0   47 6 0 2   32 0     0   7   29 18     0 0   28 5   47
1712088 MN Marshall 45 school 2723550 441 Independent Districts and Schools Marshall County Central Schools 272355001157 20 Marshall County Central High Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 40 0 0   0 0     0   1   27 14     0.0   0.0     8.0   3.0   41 40 0 0   0 0     0   1   27 14     0 0   8 3   41
1712095 MN Marshall 45 school 2718920 447 Independent Districts and Schools Grygla Public School District 271892000897 3 Grygla Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 7 0 1   0 0     0   0   3 5     *   *     *   *   8 7 0 1   0 0     0   0   3 5                 8
1712102 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 2021   grade_7 20 0 0   0 1     0   0   10 11     *   *     13.0   *   21 20 0 0   0 1     0   0   10 11           13     21
1712109 MN Meeker 47 school 2711190 463 Independent Districts and Schools Eden Valley-Watkins School District 271119000502 20 Eden Valley Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 88 1 1   0 0     0   1   56 35     0.0   0.0     17.0   17.0   91 88 1 1   0 0     0   1   56 35     0 0   17 17   91
1712116 MN Mille Lacs 48 school 2715510 473 Independent Districts and Schools Isle Public School District 271551000770 20 Isle Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 34 0 0   4 0     0   1   26 13     *   *     *   *   39 34 0 0   4 0     0   1   26 13                 39
1712123 MN Morrison 49 school 2728320 484 Independent Districts and Schools Pierz Public School District 272832001252 30 Healy Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 109 0 2   0 0     0   1   53 59     0.0   0.0     23.0   11.0   112 109 0 2   0 0     0   1   53 59     0 0   23 11   112
1712130 MN Morrison 49 school 2738280 486 Independent Districts and Schools Swanville Public School District 273828001671 20 Swanville Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 25 0 0   0 0     0   1   15 11     0.0   0.0     10.0   2.0   26 25 0 0   0 0     0   1   15 11     0 0   10 2   26
1712137 MN Morrison 49 school 2740860 487 Independent Districts and Schools Upsala Public School District 274086001709 20 Upsala Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 22 1 1   0 0     0   0   15 9     0.0   0.0     0.0   1.0   24 22 1 1   0 0     0   0   15 9     0 0   0 1   24
1712145 MN Mower 50 school 2718360 497 Independent Districts and Schools Lyle Public School District 271836000854 20 Lyle Secondary Secondary School (Grades 7-12) Regular School No High 06 12 2021   grade_7 17 0 3   0 0     0   1   13 8     3.0   0.0     8.0   7.0   21 17 0 3   0 0     0   1   13 8     3 0   8 7   21
1712153 MN Mower 50 school 2718060 499 Independent Districts and Schools LeRoy-Ostrander Public Schools 271806000832 30 LeRoy Secondary Secondary School (Grades 7-12) Regular School No High 06 12 2021   grade_7 28 0 4   0 0     0   2   18 16     1.0   0.0     12.0   7.0   34 28 0 4   0 0     0   2   18 16     1 0   12 7   34
1712160 MN Murray 51 school 2712480 505 Independent Districts and Schools Fulda Public School District 271248000618 20 Fulda Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 24 1 6   0 0     0   1   16 16     5.0   1.0     11.0   10.0   32 24 1 6   0 0     0   1   16 16     5 1   11 10   32
1712172 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 2021   grade_7 6 0 0   0 0     0   1   2 5     *   *     *   *   7 6 0 0   0 0     0   1   2 5                 7
1712179 MN Otter Tail 56 school 2703750 542 Independent Districts and Schools Battle Lake Public School District 270375000176 20 Battle Lake Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 30 0 1   0 0     0   3   17 17     0.0   0.0     10.0   4.0   34 30 0 1   0 0     0   3   17 17     0 0   10 4   34
1712186 MN Otter Tail 56 school 2713860 545 Independent Districts and Schools Henning Public School District 271386000712 20 Henning Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 29 0 0   0 2     0   1   17 15     1.0   0.0     9.0   1.0   32 29 0 0   0 2     0   1   17 15     1 0   9 1   32
1712193 MN Otter Tail 56 school 2728110 547 Independent Districts and Schools Parkers Prairie Public School Dist. 272811001238 20 Parkers Prairie Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 53 0 1   0 0     0   1   23 32     0.0   0.0     12.0   7.0   55 53 0 1   0 0     0   1   23 32     0 0   12 7   55
1712200 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 2021   grade_7 34 8 16   0 1     0   0   35 24     7.0   0.0     26.0   11.0   59 34 8 16   0 1     0   0   35 24     7 0   26 11   59
1712207 MN Otter Tail 56 school 2740830 550 Independent Districts and Schools Underwood Public School District 274083001707 20 Underwood Secondary Secondary School (Grades 7-12) Regular School No High 05 12 2021   grade_7 47 1 0   0 0     0   0   28 20     1.0   0.0     22.0   9.0   48 47 1 0   0 0     0   0   28 20     1 0   22 9   48
1712214 MN Otter Tail 56 school 2723520 553 Independent Districts and Schools New York Mills Public School Dist. 272352001156 20 New York Mills Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 49 0 1   0 0     0   0   24 26     0.0   0.0     17.0   11.0   50 49 0 1   0 0     0   0   24 26     0 0   17 11   50
1712221 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 2021   grade_7 15 0 3   2 0     0   0   13 7     *   *     12.0   3.0   20 15 0 3   2 0     0   0   13 7           12 3   20
1712228 MN Pine 58 school 2742750 577 Independent Districts and Schools Willow River Public School District 274275001812 40 Willow River Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 35 0 0   1 0     0   3   22 17     0.0   0.0     15.0   5.0   39 35 0 0   1 0     0   3   22 17     0 0   15 5   39
1712235 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 2021   grade_7 104 0 5   1 2     0   10   54 68     0.0   2.0     39.0   14.0   122 104 0 5   1 2     0   10   54 68     0 2   39 14   122
1712243 MN Pipestone 59 school 2711220 581 Independent Districts and Schools Edgerton Public School District 271122000504 10 Edgerton Secondary Secondary School (Grades 7-12) Regular School No High 06 12 2021   grade_7 27 1 6   0 0     0   1   20 15     3.0   0.0     18.0   7.0   35 27 1 6   0 0     0   1   20 15     3 0   18 7   35
1712250 MN Polk 60 school 2709360 592 Independent Districts and Schools Climax-Shelly Public Schools 270936000376 20 Climax Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 15 0 2   1 0     0   0   8 10     0.0   0.0     9.0   5.0   18 15 0 2   1 0     0   0   8 10     0 0   9 5   18
1712257 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 2021   grade_7 70 0 22   7 0     0   5   57 47     *   *     *   *   104 70 0 22   7 0     0   5   57 47                 104
1712264 MN Polk 60 school 2711910 599 Independent Districts and Schools Fertile-Beltrami School District 271191000583 20 Fertile-Beltrami Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 43 0 3   0 0     0   1   26 21     0.0   0.0     10.0   8.0   47 43 0 3   0 0     0   1   26 21     0 0   10 8   47
1712271 MN Polk 60 school 2712180 600 Independent Districts and Schools Fisher Public School District 271218000586 2 Fisher Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 19 0 0   0 0     0   0   10 9     0.0   0.0     6.0   4.0   19 19 0 0   0 0     0   0   10 9     0 0   6 4   19
1712278 MN Polk 60 school 2712300 601 Independent Districts and Schools Fosston Public School District 271230000602 20 Fosston Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 38 1 0   8 0     0   1   21 27     0.0   0.0     11.0   12.0   48 38 1 0   8 0     0   1   21 27     0 0   11 12   48
1712286 MN Ramsey 62 school 2733840 625 Independent Districts and Schools St. Paul Public School District 273384004680 211 Creative Arts Secondary School Secondary School (Grades 7-12) Regular School No High 06 12 2021   grade_7 9 35 8   0 17     0   9   25 53     14.0   0.0     61.0   14.0   78 9 35 8   0 17     0   9   25 53     14 0   61 14   78
1712294 MN Ramsey 62 school 2733840 625 Independent Districts and Schools St. Paul Public School District 273384001598 225 HUMBOLDT HIGH SCHOOL Secondary School (Grades 7-12) Regular School No High 06 12 2021   grade_7 9 34 26   1 41     0   11   64 58     43.0   *     *   23.0   122 9 34 26   1 41     0   11   64 58     43       23   122
1712302 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 2021   grade_7 37 5 15   0 4     0   9   32 38     *   0.0     23.0   8.0   70 37 5 15   0 4     0   9   32 38       0   23 8   70
1712310 MN Ramsey 62 school 2733840 625 Independent Districts and Schools St. Paul Public School District 273384004429 252 Washington Tech Secondary Magnet Secondary School (Grades 7-12) Regular School No High 06 12 2021   grade_7 10 90 37   3 149     0   17   151 155     101.0   2.0     270.0   54.0   306 10 90 37   3 149     0   17   151 155     101 2   270 54   306
1712317 MN Red Lake 63 school 2730450 630 Independent Districts and Schools Red Lake Falls Public School Dist. 273045001290 20 Lafayette Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 30 0 2   1 0     0   2   18 17     0.0   0.0     10.0   6.0   35 30 0 2   1 0     0   2   18 17     0 0   10 6   35
1712324 MN Redwood 64 school 2741430 640 Independent Districts and Schools Wabasso Public School District 274143001728 20 Wabasso Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 44 0 2   0 0     0   1   19 28     0.0   0.0     13.0   5.0   47 44 0 2   0 0     0   1   19 28     0 0   13 5   47
1712332 MN Rock 67 school 2714040 671 Independent Districts and Schools Hills-Beaver Creek School District 271404000727 20 Hills-Beaver Creek Secondary Secondary School (Grades 7-12) Regular School No High 06 12 2021   grade_7 36 0 2   0 0     1   0   23 16     1.0   0.0     8.0   3.0   39 36 0 2   0 0     1   0   23 16     1 0   8 3   39
1712339 MN Roseau 68 school 2703540 676 Independent Districts and Schools Badger Public School District 270354000163 20 Badger Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 15 0 0   0 0     0   1   12 4     0.0   0.0     3.0   3.0   16 15 0 0   0 0     0   1   12 4     0 0   3 3   16
1712346 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 2021   grade_7 85 0 0   2 1     0   4   40 52     0.0   0.0     14.0   12.0   92 85 0 0   2 1     0   4   40 52     0 0   14 12   92
1712353 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 2021   grade_7 65 0 2   5 5     0   14   46 45     3.0   0.0     32.0   18.0   91 65 0 2   5 5     0   14   46 45     3 0   32 18   91
1712360 MN Saint Louis 69 school 2708910 695 Independent Districts and Schools Chisholm Public School District 270891000357 302 Chisholm Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 61 1 0   0 0     0   2   32 32     0.0   0.0     27.0   6.0   64 61 1 0   0 0     0   2   32 32     0 0   27 6   64
1712367 MN Saint Louis 69 school 2712210 698 Independent Districts and Schools Floodwood Public School District 271221000589 20 Floodwood Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2021   grade_7 12 1 1   0 0     0   1   7 8     0.0   0.0     7.0   2.0   15 12 1 1   0 0     0   1   7 8     0 0   7 2   15

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