Data source: Big Local News · About: Big Local

96,319 rows where state = "MN" sorted by ell_int

View and edit SQL

grade

year

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
1879821 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 2018   grade_9 98.0 2.0 1.0   0.0 0.0     0.0   1.0   51.0 51.0     *   *     *   *   102.0 98 2 1   0 0     0   1   51 51                 102
1879822 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 2018   grade_10 63.0 0.0 1.0   0.0 0.0     0.0   3.0   33.0 34.0     *   *     *   *   67.0 63 0 1   0 0     0   3   33 34                 67
1879823 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 2018   grade_11 78.0 1.0 2.0   1.0 0.0     0.0   4.0   46.0 40.0     *   *     *   *   86.0 78 1 2   1 0     0   4   46 40                 86
1879824 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 2018   grade_12 76.0 2.0 1.0   0.0 1.0     0.0   2.0   37.0 45.0     *   *     *   *   82.0 76 2 1   0 1     0   2   37 45                 82
1879825 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 2018   pk_12_total 511.0 6.0 8.0   1.0 1.0     0.0   17.0   279.0 265.0     *   *     *   *   544.0 511 6 8   1 1     0   17   279 265                 544
1879826 MN Aitkin 1 school 2719170 4 Independent Districts and Schools McGregor Public School District 271917000904 40 McGregor Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_7 26.0 0.0 1.0   8.0 1.0     0.0   1.0   22.0 15.0     *   *     22.0   10.0   37.0 26 0 1   8 1     0   1   22 15           22 10   37
1879829 MN Aitkin 1 school 2719170 4 Independent Districts and Schools McGregor Public School District 271917000904 40 McGregor Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_10 24.0 1.0 1.0   7.0 0.0     0.0   0.0   21.0 12.0     *   *     *   *   33.0 24 1 1   7 0     0   0   21 12                 33
1879835 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 2018   grade_9 5.0 0.0 0.0   0.0 0.0     0.0   1.0   4.0 2.0     *   *     *   *   6.0 5 0 0   0 0     0   1   4 2                 6
1879836 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 2018   grade_10 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
1879837 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 2018   grade_11 5.0 0.0 0.0   0.0 0.0     0.0   1.0   4.0 2.0     *   *     *   *   6.0 5 0 0   0 0     0   1   4 2                 6
1879838 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 2018   grade_12 4.0 0.0 0.0   0.0 0.0     0.0   0.0   3.0 1.0     *   *     *   *   4.0 4 0 0   0 0     0   0   3 1                 4
1879901 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 2018   grade_11 23.0 0.0 3.0   2.0 0.0     0.0   1.0   18.0 11.0     *   *     *   *   29.0 23 0 3   2 0     0   1   18 11                 29
1879902 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 2018   grade_12 32.0 0.0 0.0   1.0 0.0     0.0   1.0   16.0 18.0     *   *     *   *   34.0 32 0 0   1 0     0   1   16 18                 34
1879903 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 2018   pk_12_total 196.0 1.0 4.0   31.0 1.0     0.0   6.0   135.0 104.0     *   *     *   *   239.0 196 1 4   31 1     0   6   135 104                 239
1879933 MN Cass 11 school 2702910 113 Independent Districts and Schools Walker-Hackensack-Akeley School District 270291001737 20 Walker-Hackensack-Akeley Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_8 41.0 1.0 3.0   13.0 0.0     0.0   2.0   26.0 34.0     *   *     *   *   60.0 41 1 3   13 0     0   2   26 34                 60
1879934 MN Cass 11 school 2702910 113 Independent Districts and Schools Walker-Hackensack-Akeley School District 270291001737 20 Walker-Hackensack-Akeley Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_9 52.0 0.0 1.0   14.0 1.0     0.0   2.0   40.0 30.0     *   *     *   *   70.0 52 0 1   14 1     0   2   40 30                 70
1879935 MN Cass 11 school 2702910 113 Independent Districts and Schools Walker-Hackensack-Akeley School District 270291001737 20 Walker-Hackensack-Akeley Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_10 44.0 1.0 1.0   7.0 1.0     0.0   2.0   31.0 25.0     *   *     *   *   56.0 44 1 1   7 1     0   2   31 25                 56
1879936 MN Cass 11 school 2702910 113 Independent Districts and Schools Walker-Hackensack-Akeley School District 270291001737 20 Walker-Hackensack-Akeley Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_11 53.0 0.0 2.0   5.0 0.0     0.0   2.0   37.0 25.0     *   *     *   *   62.0 53 0 2   5 0     0   2   37 25                 62
1879937 MN Cass 11 school 2702910 113 Independent Districts and Schools Walker-Hackensack-Akeley School District 270291001737 20 Walker-Hackensack-Akeley Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_12 42.0 0.0 0.0   4.0 1.0     0.0   3.0   24.0 26.0     *   *     *   *   50.0 42 0 0   4 1     0   3   24 26                 50
1879941 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 2018   grade_9 7.0 0.0 0.0   4.0 1.0     0.0   0.0   10.0 2.0     *   *     *   *   12.0 7 0 0   4 1     0   0   10 2                 12
1879942 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 2018   grade_10 15.0 0.0 0.0   8.0 0.0     0.0   3.0   12.0 14.0     *   *     *   *   26.0 15 0 0   8 0     0   3   12 14                 26
1879943 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 2018   grade_11 10.0 0.0 0.0   3.0 0.0     0.0   2.0   8.0 7.0     *   *     *   *   15.0 10 0 0   3 0     0   2   8 7                 15
1879944 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 2018   grade_12 16.0 0.0 0.0   4.0 0.0     0.0   2.0   7.0 15.0     *   *     *   *   22.0 16 0 0   4 0     0   2   7 15                 22
1879971 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 2018   grade_11 52.0 2.0 1.0   20.0 0.0     0.0   6.0   47.0 34.0     *   *     *   *   81.0 52 2 1   20 0     0   6   47 34                 81
1879972 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 2018   grade_12 56.0 0.0 1.0   16.0 0.0     0.0   0.0   38.0 35.0     *   *     *   *   73.0 56 0 1   16 0     0   0   38 35                 73
1880014 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 2018   grade_11 47.0 1.0 1.0   1.0 0.0     0.0   3.0   31.0 22.0     *   *     *   *   53.0 47 1 1   1 0     0   3   31 22                 53
1880015 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 2018   grade_12 59.0 1.0 2.0   0.0 0.0     0.0   0.0   40.0 22.0     *   *     *   *   62.0 59 1 2   0 0     0   0   40 22                 62
1880066 MN Grant 26 school 2713890 264 Independent Districts and Schools Herman-Norcross School District 271389000714 2 Herman Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_7 4.0 0.0 0.0   0.0 0.0     0.0   0.0   2.0 2.0     *   *     *   *   4.0 4 0 0   0 0     0   0   2 2                 4
1880068 MN Grant 26 school 2713890 264 Independent Districts and Schools Herman-Norcross School District 271389000714 2 Herman Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_9 3.0 0.0 2.0   0.0 0.0     0.0   0.0   3.0 2.0     *   *     *   *   5.0 3 0 2   0 0     0   0   3 2                 5
1880070 MN Grant 26 school 2713890 264 Independent Districts and Schools Herman-Norcross School District 271389000714 2 Herman Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_11 3.0 0.0 1.0   0.0 0.0     0.0   0.0   2.0 2.0     *   *     *   *   4.0 3 0 1   0 0     0   0   2 2                 4
1880118 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 2018   grade_10 27.0 0.0 4.0   16.0 0.0     0.0   4.0   31.0 20.0     *   *     *   *   51.0 27 0 4   16 0     0   4   31 20                 51
1880119 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 2018   grade_11 37.0 1.0 2.0   12.0 0.0     0.0   3.0   28.0 27.0     *   *     *   *   55.0 37 1 2   12 0     0   3   28 27                 55
1880120 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 2018   grade_12 27.0 0.0 2.0   14.0 0.0     0.0   3.0   22.0 24.0     *   *     *   *   46.0 27 0 2   14 0     0   3   22 24                 46
1880121 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 2018   pk_12_total 225.0 2.0 20.0   131.0 0.0     0.0   51.0   227.0 202.0     *   *     280.0   81.0   429.0 225 2 20   131 0     0   51   227 202           280 81   429
1880122 MN Itasca 31 school 2713170 318 Independent Districts and Schools Grand Rapids Public School District 271317000934 350 Bigfork Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_7 19.0 0.0 0.0   0.0 0.0     0.0   3.0   13.0 9.0     *   *     *   3.0   22.0 19 0 0   0 0     0   3   13 9             3   22
1880123 MN Itasca 31 school 2713170 318 Independent Districts and Schools Grand Rapids Public School District 271317000934 350 Bigfork Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_8 27.0 0.0 0.0   1.0 0.0     0.0   3.0   17.0 14.0     *   *     *   6.0   31.0 27 0 0   1 0     0   3   17 14             6   31
1880124 MN Itasca 31 school 2713170 318 Independent Districts and Schools Grand Rapids Public School District 271317000934 350 Bigfork Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_9 18.0 0.0 0.0   0.0 0.0     0.0   2.0   10.0 10.0     *   0.0     *   *   20.0 18 0 0   0 0     0   2   10 10       0         20
1880132 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 2018   grade_10 37.0 1.0 0.0   0.0 1.0     0.0   3.0   22.0 20.0     *   *     *   *   42.0 37 1 0   0 1     0   3   22 20                 42
1880133 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 2018   grade_11 36.0 0.0 0.0   1.0 0.0     0.0   3.0   22.0 18.0     *   *     *   *   40.0 36 0 0   1 0     0   3   22 18                 40
1880134 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 2018   grade_12 33.0 0.0 0.0   1.0 0.0     0.0   2.0   20.0 16.0     *   *     *   *   36.0 33 0 0   1 0     0   2   20 16                 36
1880145 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 2018   grade_9 119.0 2.0 4.0   2.0 0.0     0.0   4.0   69.0 62.0     *   *     *   *   131.0 119 2 4   2 0     0   4   69 62                 131
1880147 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 2018   grade_11 119.0 1.0 4.0   1.0 0.0     0.0   1.0   72.0 54.0     *   0.0     *   *   126.0 119 1 4   1 0     0   1   72 54       0         126
1880158 MN Kittson 35 school 2717880 356 Independent Districts and Schools Lancaster Public School District 271788000822 20 Lancaster Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_7 11.0 1.0 2.0   0.0 0.0     0.0   0.0   9.0 5.0     *   *     7.0   6.0   14.0 11 1 2   0 0     0   0   9 5           7 6   14
1880160 MN Kittson 35 school 2717880 356 Independent Districts and Schools Lancaster Public School District 271788000822 20 Lancaster Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_9 6.0 1.0 1.0   0.0 0.0     0.0   0.0   2.0 6.0     *   *     *   *   8.0 6 1 1   0 0     0   0   2 6                 8
1880180 MN Koochiching 36 school 2732700 363 Independent Districts and Schools South Koochiching School District 273270001413 60 Indus Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_7 5.0 2.0 1.0   0.0 0.0     0.0   0.0   4.0 4.0     *   *     *   *   8.0 5 2 1   0 0     0   0   4 4                 8
1880182 MN Koochiching 36 school 2732700 363 Independent Districts and Schools South Koochiching School District 273270001413 60 Indus Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_9 7.0 0.0 0.0   0.0 1.0     0.0   0.0   3.0 5.0     *   *     *   *   8.0 7 0 0   0 1     0   0   3 5                 8
1880183 MN Koochiching 36 school 2732700 363 Independent Districts and Schools South Koochiching School District 273270001413 60 Indus Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_10 9.0 0.0 0.0   0.0 0.0     0.0   0.0   3.0 6.0     *   *     *   *   9.0 9 0 0   0 0     0   0   3 6                 9
1880184 MN Koochiching 36 school 2732700 363 Independent Districts and Schools South Koochiching School District 273270001413 60 Indus Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_11 7.0 1.0 0.0   1.0 0.0     0.0   0.0   4.0 5.0     *   *     *   *   9.0 7 1 0   1 0     0   0   4 5                 9
1880185 MN Koochiching 36 school 2732700 363 Independent Districts and Schools South Koochiching School District 273270001413 60 Indus Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_12 7.0 1.0 0.0   0.0 0.0     0.0   0.0   5.0 3.0     *   *     *   *   8.0 7 1 0   0 0     0   0   5 3                 8
1880187 MN Koochiching 36 school 2732700 363 Independent Districts and Schools South Koochiching School District 273270001416 70 Northome Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_7 12.0 2.0 0.0   0.0 0.0     0.0   1.0   6.0 9.0     *   *     *   *   15.0 12 2 0   0 0     0   1   6 9                 15
1880189 MN Koochiching 36 school 2732700 363 Independent Districts and Schools South Koochiching School District 273270001416 70 Northome Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_9 9.0 0.0 0.0   1.0 1.0     0.0   1.0   5.0 7.0     *   *     *   *   12.0 9 0 0   1 1     0   1   5 7                 12
1880190 MN Koochiching 36 school 2732700 363 Independent Districts and Schools South Koochiching School District 273270001416 70 Northome Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_10 10.0 0.0 0.0   1.0 0.0     0.0   1.0   7.0 5.0     *   *     *   *   12.0 10 0 0   1 0     0   1   7 5                 12
1880191 MN Koochiching 36 school 2732700 363 Independent Districts and Schools South Koochiching School District 273270001416 70 Northome Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_11 14.0 1.0 0.0   0.0 0.0     0.0   1.0   8.0 8.0     *   *     *   *   16.0 14 1 0   0 0     0   1   8 8                 16
1880192 MN Koochiching 36 school 2732700 363 Independent Districts and Schools South Koochiching School District 273270001416 70 Northome Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_12 5.0 0.0 2.0   1.0 0.0     0.0   0.0   1.0 7.0     *   *     *   *   8.0 5 0 2   1 0     0   0   1 7                 8
1880193 MN Koochiching 36 school 2732700 363 Independent Districts and Schools South Koochiching School District 273270001416 70 Northome Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   pk_12_total 56.0 4.0 3.0   5.0 1.0     0.0   5.0   32.0 42.0     *   0.0     28.0   12.0   74.0 56 4 3   5 1     0   5   32 42       0   28 12   74
1880205 MN Lake 38 school 2740740 381 Independent Districts and Schools Lake Superior Public School District 274074001697 90 Wm. M. Kelley Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_11 26.0 0.0 0.0   0.0 0.0     1.0   0.0   13.0 14.0     *   *     *   *   27.0 26 0 0   0 0     1   0   13 14                 27
1880206 MN Lake 38 school 2740740 381 Independent Districts and Schools Lake Superior Public School District 274074001697 90 Wm. M. Kelley Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_12 28.0 0.0 1.0   0.0 1.0     0.0   0.0   17.0 13.0     *   *     *   *   30.0 28 0 1   0 1     0   0   17 13                 30
1880244 MN Mahnomen 44 school 2718660 432 Independent Districts and Schools Mahnomen Public School District 271866000866 20 Mahnomen Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_7 9.0 0.0 2.0   14.0 0.0     0.0   34.0   34.0 25.0     *   *     *   *   59.0 9 0 2   14 0     0   34   34 25                 59
1880245 MN Mahnomen 44 school 2718660 432 Independent Districts and Schools Mahnomen Public School District 271866000866 20 Mahnomen Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_8 11.0 0.0 1.0   15.0 0.0     0.0   28.0   32.0 23.0     *   *     *   *   55.0 11 0 1   15 0     0   28   32 23                 55
1880246 MN Mahnomen 44 school 2718660 432 Independent Districts and Schools Mahnomen Public School District 271866000866 20 Mahnomen Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_9 13.0 0.0 1.0   21.0 0.0     0.0   20.0   26.0 29.0     *   *     *   *   55.0 13 0 1   21 0     0   20   26 29                 55
1880248 MN Mahnomen 44 school 2718660 432 Independent Districts and Schools Mahnomen Public School District 271866000866 20 Mahnomen Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_11 5.0 0.0 1.0   3.0 0.0     0.0   25.0   16.0 18.0     *   *     *   *   34.0 5 0 1   3 0     0   25   16 18                 34
1880251 MN Mahnomen 44 school 2742120 435 Independent Districts and Schools Waubun-Ogema-White Earth Public Schools 274212001756 30 Waubun Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_7 8.0 0.0 1.0   27.0 0.0     0.0   13.0   22.0 27.0     *   2.0     34.0   8.0   49.0 8 0 1   27 0     0   13   22 27       2   34 8   49
1880253 MN Mahnomen 44 school 2742120 435 Independent Districts and Schools Waubun-Ogema-White Earth Public Schools 274212001756 30 Waubun Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_9 4.0 0.0 1.0   20.0 0.0     0.0   6.0   18.0 13.0     *   *     21.0   14.0   31.0 4 0 1   20 0     0   6   18 13           21 14   31
1880274 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 2018   grade_9 8.0 0.0 0.0   0.0 0.0     0.0   0.0   5.0 3.0     *   *     *   *   8.0 8 0 0   0 0     0   0   5 3                 8
1880275 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 2018   grade_10 6.0 1.0 2.0   0.0 0.0     0.0   0.0   5.0 4.0     *   *     *   *   9.0 6 1 2   0 0     0   0   5 4                 9
1880288 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 2018   grade_9 27.0 0.0 2.0   2.0 1.0     0.0   2.0   18.0 16.0     *   *     *   *   34.0 27 0 2   2 1     0   2   18 16                 34
1880289 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 2018   grade_10 22.0 0.0 0.0   5.0 0.0     0.0   1.0   16.0 12.0     *   *     *   *   28.0 22 0 0   5 0     0   1   16 12                 28
1880290 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 2018   grade_11 34.0 1.0 1.0   1.0 1.0     0.0   0.0   23.0 15.0     *   *     *   *   38.0 34 1 1   1 1     0   0   23 15                 38
1880298 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 2018   grade_12 84.0 0.0 1.0   1.0 1.0     0.0   0.0   44.0 43.0     *   *     *   *   87.0 84 0 1   1 1     0   0   44 43                 87
1880299 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 2018   pk_12_total 566.0 0.0 8.0   1.0 2.0     0.0   4.0   304.0 277.0     *   0.0     *   *   581.0 566 0 8   1 2     0   4   304 277       0         581
1880341 MN Nobles 53 school 2711460 514 Independent Districts and Schools Ellsworth Public School District 271146000526 20 Ellsworth Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_7 6.0 0.0 1.0   0.0 0.0     0.0   0.0   2.0 5.0     *   *     *   *   7.0 6 0 1   0 0     0   0   2 5                 7
1880342 MN Nobles 53 school 2711460 514 Independent Districts and Schools Ellsworth Public School District 271146000526 20 Ellsworth Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_8 8.0 0.0 0.0   0.0 0.0     0.0   0.0   4.0 4.0     *   *     *   *   8.0 8 0 0   0 0     0   0   4 4                 8
1880346 MN Nobles 53 school 2711460 514 Independent Districts and Schools Ellsworth Public School District 271146000526 20 Ellsworth Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_12 5.0 0.0 0.0   0.0 0.0     0.0   0.0   1.0 4.0     *   *     *   *   5.0 5 0 0   0 0     0   0   1 4                 5
1880370 MN Otter Tail 56 school 2728170 548 Independent Districts and Schools Pelican Rapids Public School District 272817001243 20 Pelican Rapids Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_8 26.0 4.0 17.0   0.0 0.0     0.0   1.0   22.0 26.0     *   0.0     *   *   48.0 26 4 17   0 0     0   1   22 26       0         48
1880372 MN Otter Tail 56 school 2728170 548 Independent Districts and Schools Pelican Rapids Public School District 272817001243 20 Pelican Rapids Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_10 35.0 12.0 16.0   2.0 2.0     0.0   1.0   31.0 37.0     *   *     *   *   68.0 35 12 16   2 2     0   1   31 37                 68
1880373 MN Otter Tail 56 school 2728170 548 Independent Districts and Schools Pelican Rapids Public School District 272817001243 20 Pelican Rapids Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_11 34.0 7.0 14.0   1.0 2.0     0.0   2.0   27.0 33.0     *   *     *   *   60.0 34 7 14   1 2     0   2   27 33                 60
1880374 MN Otter Tail 56 school 2728170 548 Independent Districts and Schools Pelican Rapids Public School District 272817001243 20 Pelican Rapids Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_12 37.0 10.0 14.0   1.0 1.0     0.0   2.0   34.0 31.0     *   *     *   *   65.0 37 10 14   1 1     0   2   34 31                 65
1880390 MN Pennington 57 school 2713020 561 Independent Districts and Schools Goodridge Public School District 271302000650 20 Goodridge Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_7 18.0 0.0 1.0   3.0 0.0     0.0   0.0   7.0 15.0     *   *     10.0   3.0   22.0 18 0 1   3 0     0   0   7 15           10 3   22
1880395 MN Pennington 57 school 2713020 561 Independent Districts and Schools Goodridge Public School District 271302000650 20 Goodridge Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_12 7.0 0.0 0.0   0.0 0.0     0.0   0.0   5.0 2.0     *   *     *   *   7.0 7 0 0   0 0     0   0   5 2                 7
1880404 MN Pine 58 school 2728380 578 Independent Districts and Schools Pine City Public School District 272838001256 20 Pine City Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_7 124.0 0.0 8.0   0.0 0.0     0.0   7.0   81.0 58.0     *   *     *   15.0   139.0 124 0 8   0 0     0   7   81 58             15   139
1880405 MN Pine 58 school 2728380 578 Independent Districts and Schools Pine City Public School District 272838001256 20 Pine City Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_8 121.0 1.0 9.0   2.0 0.0     0.0   4.0   73.0 64.0     *   *     *   17.0   137.0 121 1 9   2 0     0   4   73 64             17   137
1880406 MN Pine 58 school 2728380 578 Independent Districts and Schools Pine City Public School District 272838001256 20 Pine City Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_9 127.0 1.0 4.0   1.0 1.0     0.0   5.0   64.0 75.0     *   *     *   21.0   139.0 127 1 4   1 1     0   5   64 75             21   139
1880409 MN Pine 58 school 2728380 578 Independent Districts and Schools Pine City Public School District 272838001256 20 Pine City Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_12 104.0 1.0 3.0   0.0 0.0     0.0   6.0   56.0 58.0     *   2.0     27.0   11.0   114.0 104 1 3   0 0     0   6   56 58       2   27 11   114
1880428 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 2018   grade_9 57.0 1.0 14.0   4.0 2.0     0.0   5.0   46.0 37.0     *   0.0     36.0   20.0   83.0 57 1 14   4 2     0   5   46 37       0   36 20   83
1880430 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 2018   grade_11 48.0 1.0 11.0   1.0 0.0     0.0   2.0   34.0 29.0     *   0.0     *   *   63.0 48 1 11   1 0     0   2   34 29       0         63
1880454 MN Washington 82 school 2742360 624 Independent Districts and Schools White Bear Lake School District 274236004372 20 AWARE Secondary School (Grades 7-12) Regular School No High 06 12 2018   grade_11 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
1880455 MN Washington 82 school 2742360 624 Independent Districts and Schools White Bear Lake School District 274236004372 20 AWARE Secondary School (Grades 7-12) Regular School No High 06 12 2018   pk_12_total 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
1880538 MN Saint Louis 69 school 2712210 698 Independent Districts and Schools Floodwood Public School District 271221000589 20 Floodwood Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_7 12.0 1.0 0.0   0.0 0.0     0.0   2.0   5.0 10.0     *   *     6.0   1.0   15.0 12 1 0   0 0     0   2   5 10           6 1   15
1880543 MN Saint Louis 69 school 2712210 698 Independent Districts and Schools Floodwood Public School District 271221000589 20 Floodwood Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_12 23.0 0.0 0.0   0.0 0.0     0.0   1.0   16.0 8.0     *   *     *   *   24.0 23 0 0   0 0     0   1   16 8                 24
1880547 MN Saint Louis 69 school 2713980 701 Independent Districts and Schools Hibbing Public School District 271398001539 350 Hibbing High Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_9 157.0 6.0 2.0   2.0 5.0     0.0   9.0   86.0 95.0     *   *     *   *   181.0 157 6 2   2 5     0   9   86 95                 181
1880548 MN Saint Louis 69 school 2713980 701 Independent Districts and Schools Hibbing Public School District 271398001539 350 Hibbing High Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_10 130.0 6.0 1.0   2.0 1.0     0.0   8.0   64.0 84.0     *   *     *   *   148.0 130 6 1   2 1     0   8   64 84                 148
1880549 MN Saint Louis 69 school 2713980 701 Independent Districts and Schools Hibbing Public School District 271398001539 350 Hibbing High Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_11 158.0 4.0 2.0   1.0 3.0     0.0   8.0   89.0 87.0     *   *     *   *   176.0 158 4 2   1 3     0   8   89 87                 176
1880614 MN Stevens 75 school 2708940 771 Independent Districts and Schools Chokio-Alberta Public School District 270894000361 2 Chokio-Alberta Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_7 9.0 0.0 0.0   0.0 0.0     0.0   0.0   5.0 4.0     *   *     *   *   9.0 9 0 0   0 0     0   0   5 4                 9
1880618 MN Stevens 75 school 2708940 771 Independent Districts and Schools Chokio-Alberta Public School District 270894000361 2 Chokio-Alberta Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_11 8.0 0.0 0.0   0.0 0.0     0.0   0.0   7.0 1.0     *   *     *   *   8.0 8 0 0   0 0     0   0   7 1                 8
1880628 MN Swift 76 school 2704470 777 Independent Districts and Schools Benson Public School District 270447000199 101 Benson Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_7 49.0 1.0 7.0   0.0 0.0     0.0   0.0   28.0 29.0     *   *     28.0   9.0   57.0 49 1 7   0 0     0   0   28 29           28 9   57
1880634 MN Swift 76 school 2704470 777 Independent Districts and Schools Benson Public School District 270447000199 101 Benson Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   pk_12_total 312.0 3.0 28.0   0.0 1.0     0.0   5.0   172.0 177.0     *   *     108.0   64.0   349.0 312 3 28   0 1     0   5   172 177           108 64   349
1880685 MN Watonwan 83 school 2707320 836 Independent Districts and Schools Butterfield Public School District 270732000305 30 Butterfield Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_7 5.0 1.0 7.0   0.0 0.0     0.0   0.0   8.0 5.0     *   *     9.0   4.0   13.0 5 1 7   0 0     0   0   8 5           9 4   13
1880687 MN Watonwan 83 school 2707320 836 Independent Districts and Schools Butterfield Public School District 270732000305 30 Butterfield Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_9 3.0 0.0 3.0   0.0 0.0     0.0   0.0   2.0 4.0     *   *     *   *   6.0 3 0 3   0 0     0   0   2 4                 6
1880694 MN Watonwan 83 school 2718570 837 Independent Districts and Schools Madelia Public School District 271857000860 20 Madelia Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_9 20.0 2.0 20.0   0.0 0.0     0.0   1.0   25.0 18.0     *   *     *   *   43.0 20 2 20   0 0     0   1   25 18                 43
1880695 MN Watonwan 83 school 2718570 837 Independent Districts and Schools Madelia Public School District 271857000860 20 Madelia Secondary Secondary School (Grades 7-12) Regular School No High 07 12 2018   grade_10 18.0 0.0 21.0   0.0 0.0     0.0   0.0   19.0 20.0     *   *     *   *   39.0 18 0 21   0 0     0   0   19 20                 39

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