Data source: Big Local News · About: Big Local

14,034 rows where state = "MN" and year = 2020 sorted by ccd_school_high_grade

View and edit SQL

year

  • 2020 · 14,034
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
1829350 MN Mcleod 43 school 2714970 423 Independent Districts and Schools Hutchinson Public School District 271497002198 60 Hutchinson West Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 01 2020   early_childhood_special_ed 62.0 1.0 8.0   0.0 0.0     0.0   1.0   50.0 22.0     0.0   2.0     25.0   *   72.0 62 1 8   0 0     0   1   50 22     0 2   25     72
1829351 MN Mcleod 43 school 2714970 423 Independent Districts and Schools Hutchinson Public School District 271497002198 60 Hutchinson West Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 01 2020   kindergarten 165.0 3.0 26.0   0.0 1.0     0.0   7.0   110.0 92.0     18.0   5.0     68.0   34.0   202.0 165 3 26   0 1     0   7   110 92     18 5   68 34   202
1829352 MN Mcleod 43 school 2714970 423 Independent Districts and Schools Hutchinson Public School District 271497002198 60 Hutchinson West Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 01 2020   grade_1 171.0 1.0 21.0   0.0 2.0     0.0   12.0   100.0 107.0     14.0   2.0     62.0   32.0   207.0 171 1 21   0 2     0   12   100 107     14 2   62 32   207
1829353 MN Mcleod 43 school 2714970 423 Independent Districts and Schools Hutchinson Public School District 271497002198 60 Hutchinson West Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 01 2020   pk_12_total 398.0 5.0 55.0   0.0 3.0     0.0   20.0   260.0 221.0     32.0   9.0     155.0   138.0   481.0 398 5 55   0 3     0   20   260 221     32 9   155 138   481
1829604 MN Nicollet 52 school 2733870 508 Independent Districts and Schools St. Peter Public School District 273387001639 50 South Elementary Center Elementary School (Grades PK-6) Regular School No Elementary KG 01 2020   kindergarten 103.0 9.0 30.0   0.0 0.0     0.0   9.0   79.0 72.0     10.0   1.0     59.0   39.0   151.0 103 9 30   0 0     0   9   79 72     10 1   59 39   151
1829605 MN Nicollet 52 school 2733870 508 Independent Districts and Schools St. Peter Public School District 273387001639 50 South Elementary Center Elementary School (Grades PK-6) Regular School No Elementary KG 01 2020   grade_1 91.0 17.0 26.0   0.0 0.0     0.0   7.0   78.0 63.0     11.0   1.0     61.0   27.0   141.0 91 17 26   0 0     0   7   78 63     11 1   61 27   141
1829606 MN Nicollet 52 school 2733870 508 Independent Districts and Schools St. Peter Public School District 273387001639 50 South Elementary Center Elementary School (Grades PK-6) Regular School No Elementary KG 01 2020   pk_12_total 194.0 26.0 56.0   0.0 0.0     0.0   16.0   157.0 135.0     21.0   2.0     120.0   66.0   292.0 194 26 56   0 0     0   16   157 135     21 2   120 66   292
1829799 MN Otter Tail 56 school 2711880 544 Independent Districts and Schools Fergus Falls Public School District 271188000581 180 McKinley Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 01 2020   kindergarten 185.0 3.0 3.0   3.0 1.0     0.0   10.0   108.0 97.0     6.0   0.0     73.0   14.0   205.0 185 3 3   3 1     0   10   108 97     6 0   73 14   205
1829800 MN Otter Tail 56 school 2711880 544 Independent Districts and Schools Fergus Falls Public School District 271188000581 180 McKinley Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 01 2020   grade_1 41.0 2.0 0.0   0.0 0.0     1.0   1.0   23.0 22.0     3.0   0.0     21.0   7.0   45.0 41 2 0   0 0     1   1   23 22     3 0   21 7   45
1829801 MN Otter Tail 56 school 2711880 544 Independent Districts and Schools Fergus Falls Public School District 271188000581 180 McKinley Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 01 2020   pk_12_total 226.0 5.0 3.0   3.0 1.0     1.0   11.0   131.0 119.0     9.0   0.0     94.0   21.0   250.0 226 5 3   3 1     1   11   131 119     9 0   94 21   250
1830172 MN Washington 82 school 2742360 624 Independent Districts and Schools White Bear Lake School District 274236004409 830 Hugo Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 01 2020   kindergarten 135.0 4.0 4.0   0.0 3.0     0.0   9.0   82.0 73.0     *   0.0     19.0   23.0   155.0 135 4 4   0 3     0   9   82 73       0   19 23   155
1830173 MN Washington 82 school 2742360 624 Independent Districts and Schools White Bear Lake School District 274236004409 830 Hugo Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 01 2020   grade_1 142.0 3.0 4.0   1.0 6.0     0.0   8.0   82.0 82.0     3.0   0.0     20.0   18.0   164.0 142 3 4   1 6     0   8   82 82     3 0   20 18   164
1830174 MN Washington 82 school 2742360 624 Independent Districts and Schools White Bear Lake School District 274236004409 830 Hugo Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 01 2020   pk_12_total 277.0 7.0 8.0   1.0 9.0     0.0   17.0   164.0 155.0     *   0.0     39.0   41.0   319.0 277 7 8   1 9     0   17   164 155       0   39 41   319
1831963 MN Chisago 13 school 2700017 2144 Independent Districts and Schools Chisago Lakes School District 270001700352 1 Chisago Lakes El. Elementary School (Grades PK-6) Regular School No Elementary PK 01 2020   kindergarten 186.0 2.0 3.0   1.0 4.0     0.0   6.0   99.0 103.0     0.0   0.0     31.0   16.0   202.0 186 2 3   1 4     0   6   99 103     0 0   31 16   202
1831964 MN Chisago 13 school 2700017 2144 Independent Districts and Schools Chisago Lakes School District 270001700352 1 Chisago Lakes El. Elementary School (Grades PK-6) Regular School No Elementary PK 01 2020   grade_1 185.0 1.0 1.0   0.0 1.0     0.0   1.0   98.0 91.0     *   0.0     35.0   26.0   189.0 185 1 1   0 1     0   1   98 91       0   35 26   189
1831965 MN Chisago 13 school 2700017 2144 Independent Districts and Schools Chisago Lakes School District 270001700352 1 Chisago Lakes El. Elementary School (Grades PK-6) Regular School No Elementary PK 01 2020   pk_12_total 371.0 3.0 4.0   1.0 5.0     0.0   7.0   197.0 194.0     0.0   0.0     66.0   42.0   391.0 371 3 4   1 5     0   7   197 194     0 0   66 42   391
1832313 MN Pipestone 59 school 2700108 2689 Independent Districts and Schools Pipestone Area School District 270010801261 2 Brown Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 01 2020   early_childhood_special_ed 21.0 0.0 4.0   0.0 0.0     0.0   0.0   16.0 9.0     0.0   0.0     13.0   *   25.0 21 0 4   0 0     0   0   16 9     0 0   13     25
1832314 MN Pipestone 59 school 2700108 2689 Independent Districts and Schools Pipestone Area School District 270010801261 2 Brown Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 01 2020   kindergarten 74.0 4.0 20.0   1.0 1.0     0.0   5.0   56.0 49.0     *   *         *   105.0 74 4 20   1 1     0   5   56 49                 105
1832315 MN Pipestone 59 school 2700108 2689 Independent Districts and Schools Pipestone Area School District 270010801261 2 Brown Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 01 2020   grade_1 63.0 0.0 22.0   0.0 0.0     0.0   4.0   49.0 40.0     *   *         *   89.0 63 0 22   0 0     0   4   49 40                 89
1832316 MN Pipestone 59 school 2700108 2689 Independent Districts and Schools Pipestone Area School District 270010801261 2 Brown Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 01 2020   pk_12_total 158.0 4.0 46.0   1.0 1.0     0.0   9.0   121.0 98.0     27.0   3.0     109.0   56.0   219.0 158 4 46   1 1     0   9   121 98     27 3   109 56   219
1837521 MN Washington 82 school 2702264 916 Intermediate Districts and Schools Northeast Metro 916 270226403259 20 A/O Program Special Education Special Education School No Elementary PK 01 2020   early_childhood_special_ed 4.0 1.0 0.0   0.0 1.0     0.0   0.0   5.0 1.0     *   *         *   6.0 4 1 0   0 1     0   0   5 1                 6
1837522 MN Washington 82 school 2702264 916 Intermediate Districts and Schools Northeast Metro 916 270226403259 20 A/O Program Special Education Special Education School No Elementary PK 01 2020   pk_12_total 4.0 1.0 0.0   0.0 1.0     0.0   0.0   5.0 1.0     *   *         *   6.0 4 1 0   0 1     0   0   5 1                 6
1828314 MN Goodhue 25 school 2730480 256 Independent Districts and Schools Red Wing Public School District 273048001297 541 Sunnyside Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 02 2020   kindergarten 151.0 10.0 22.0   5.0 1.0     0.0   16.0   109.0 96.0     6.0   2.0     74.0   37.0   205.0 151 10 22   5 1     0   16   109 96     6 2   74 37   205
1828315 MN Goodhue 25 school 2730480 256 Independent Districts and Schools Red Wing Public School District 273048001297 541 Sunnyside Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 02 2020   grade_1 139.0 5.0 18.0   8.0 3.0     0.0   14.0   90.0 97.0     10.0   0.0     63.0   35.0   187.0 139 5 18   8 3     0   14   90 97     10 0   63 35   187
1828316 MN Goodhue 25 school 2730480 256 Independent Districts and Schools Red Wing Public School District 273048001297 541 Sunnyside Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 02 2020   grade_2 40.0 1.0 2.0   3.0 0.0     0.0   4.0   22.0 28.0     0.0   0.0     12.0   2.0   50.0 40 1 2   3 0     0   4   22 28     0 0   12 2   50
1828317 MN Goodhue 25 school 2730480 256 Independent Districts and Schools Red Wing Public School District 273048001297 541 Sunnyside Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 02 2020   pk_12_total 330.0 16.0 42.0   16.0 4.0     0.0   34.0   221.0 221.0     16.0   2.0     149.0   74.0   442.0 330 16 42   16 4     0   34   221 221     16 2   149 74   442
1828622 MN Hennepin 27 school 2725080 278 Independent Districts and Schools Orono Public School District 272508001200 661 Schumann Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 02 2020   kindergarten 164.0 0.0 6.0   0.0 2.0     0.0   10.0   99.0 83.0     5.0   0.0     14.0   8.0   182.0 164 0 6   0 2     0   10   99 83     5 0   14 8   182
1828623 MN Hennepin 27 school 2725080 278 Independent Districts and Schools Orono Public School District 272508001200 661 Schumann Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 02 2020   grade_1 173.0 1.0 9.0   0.0 1.0     0.0   9.0   107.0 86.0     3.0   0.0     12.0   16.0   193.0 173 1 9   0 1     0   9   107 86     3 0   12 16   193
1828624 MN Hennepin 27 school 2725080 278 Independent Districts and Schools Orono Public School District 272508001200 661 Schumann Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 02 2020   grade_2 162.0 3.0 11.0   0.0 3.0     0.0   12.0   108.0 83.0     7.0   0.0     10.0   14.0   191.0 162 3 11   0 3     0   12   108 83     7 0   10 14   191
1828625 MN Hennepin 27 school 2725080 278 Independent Districts and Schools Orono Public School District 272508001200 661 Schumann Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 02 2020   pk_12_total 499.0 4.0 26.0   0.0 6.0     0.0   31.0   314.0 252.0     15.0   0.0     36.0   38.0   566.0 499 4 26   0 6     0   31   314 252     15 0   36 38   566
1829318 MN Lyon 42 school 2718940 413 Independent Districts and Schools Marshall Public School District 271894000891 2 Park Side Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 02 2020   early_childhood_special_ed 25.0 2.0 5.0   0.0 5.0     0.0   1.0   23.0 15.0     0.0   0.0     13.0   *   38.0 25 2 5   0 5     0   1   23 15     0 0   13     38
1829319 MN Lyon 42 school 2718940 413 Independent Districts and Schools Marshall Public School District 271894000891 2 Park Side Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 02 2020   kindergarten 97.0 13.0 34.0   0.0 20.0     1.0   9.0   88.0 86.0     52.0   0.0     91.0   28.0   174.0 97 13 34   0 20     1   9   88 86     52 0   91 28   174
1829320 MN Lyon 42 school 2718940 413 Independent Districts and Schools Marshall Public School District 271894000891 2 Park Side Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 02 2020   grade_1 76.0 11.0 39.0   1.0 27.0     0.0   15.0   98.0 71.0     53.0   1.0     102.0   35.0   169.0 76 11 39   1 27     0   15   98 71     53 1   102 35   169
1829321 MN Lyon 42 school 2718940 413 Independent Districts and Schools Marshall Public School District 271894000891 2 Park Side Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 02 2020   grade_2 97.0 15.0 33.0   1.0 18.0     0.0   11.0   82.0 93.0     45.0   0.0     94.0   33.0   175.0 97 15 33   1 18     0   11   82 93     45 0   94 33   175
1829322 MN Lyon 42 school 2718940 413 Independent Districts and Schools Marshall Public School District 271894000891 2 Park Side Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 02 2020   pk_12_total 295.0 41.0 111.0   2.0 70.0     1.0   36.0   291.0 265.0     150.0   1.0     300.0   134.0   556.0 295 41 111   2 70     1   36   291 265     150 1   300 134   556
1829389 MN Marshall 45 school 2723550 441 Independent Districts and Schools Marshall County Central Schools 272355001159 30 Viking Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 02 2020   early_childhood_special_ed 2.0 0.0 0.0   0.0 0.0     0.0   0.0   2.0 0.0     *   *         *   2.0 2 0 0   0 0     0   0   2 0                 2
1829390 MN Marshall 45 school 2723550 441 Independent Districts and Schools Marshall County Central Schools 272355001159 30 Viking Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 02 2020   kindergarten 35.0 1.0 1.0   0.0 0.0     0.0   1.0   19.0 19.0     *   *     13.0   1.0   38.0 35 1 1   0 0     0   1   19 19           13 1   38
1829391 MN Marshall 45 school 2723550 441 Independent Districts and Schools Marshall County Central Schools 272355001159 30 Viking Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 02 2020   grade_1 25.0 0.0 0.0   0.0 0.0     0.0   1.0   15.0 11.0     0.0   0.0         2.0   26.0 25 0 0   0 0     0   1   15 11     0 0     2   26
1829392 MN Marshall 45 school 2723550 441 Independent Districts and Schools Marshall County Central Schools 272355001159 30 Viking Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 02 2020   grade_2 29.0 0.0 0.0   0.0 0.0     0.0   1.0   11.0 19.0     0.0   0.0     10.0   3.0   30.0 29 0 0   0 0     0   1   11 19     0 0   10 3   30
1829393 MN Marshall 45 school 2723550 441 Independent Districts and Schools Marshall County Central Schools 272355001159 30 Viking Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 02 2020   pk_12_total 91.0 1.0 1.0   0.0 0.0     0.0   3.0   47.0 49.0     0.0   0.0     33.0   8.0   96.0 91 1 1   0 0     0   3   47 49     0 0   33 8   96
1829452 MN Mille Lacs 48 school 2730030 477 Independent Districts and Schools Princeton Public School District 273003001274 1 Princeton Primary School Elementary School (Grades PK-6) Regular School No Elementary KG 02 2020   kindergarten 176.0 0.0 8.0   1.0 2.0     0.0   7.0   103.0 91.0     0.0   *     73.0   *   194.0 176 0 8   1 2     0   7   103 91     0     73     194
1829453 MN Mille Lacs 48 school 2730030 477 Independent Districts and Schools Princeton Public School District 273003001274 1 Princeton Primary School Elementary School (Grades PK-6) Regular School No Elementary KG 02 2020   grade_1 209.0 2.0 7.0   0.0 1.0     0.0   5.0   106.0 118.0     *   6.0         36.0   224.0 209 2 7   0 1     0   5   106 118       6     36   224
1829454 MN Mille Lacs 48 school 2730030 477 Independent Districts and Schools Princeton Public School District 273003001274 1 Princeton Primary School Elementary School (Grades PK-6) Regular School No Elementary KG 02 2020   grade_2 238.0 1.0 5.0   3.0 2.0     0.0   10.0   140.0 119.0     *   *         *   259.0 238 1 5   3 2     0   10   140 119                 259
1829455 MN Mille Lacs 48 school 2730030 477 Independent Districts and Schools Princeton Public School District 273003001274 1 Princeton Primary School Elementary School (Grades PK-6) Regular School No Elementary KG 02 2020   pk_12_total 623.0 3.0 20.0   4.0 5.0     0.0   22.0   349.0 328.0     5.0   10.0     223.0   111.0   677.0 623 3 20   4 5     0   22   349 328     5 10   223 111   677
1829460 MN Mille Lacs 48 school 2725050 480 Independent Districts and Schools Onamia Public School District 272505001195 10 Onamia Primary School Elementary School (Grades PK-6) Regular School No Elementary PK 02 2020   early_childhood_special_ed 6.0 0.0 0.0   15.0 0.0     1.0   1.0   16.0 7.0     0.0   0.0     12.0   *   23.0 6 0 0   15 0     1   1   16 7     0 0   12     23
1829461 MN Mille Lacs 48 school 2725050 480 Independent Districts and Schools Onamia Public School District 272505001195 10 Onamia Primary School Elementary School (Grades PK-6) Regular School No Elementary PK 02 2020   pre_kindergarten 9.0 0.0 0.0   4.0 1.0     0.0   2.0   5.0 11.0     0.0   0.0     8.0   0.0   16.0 9 0 0   4 1     0   2   5 11     0 0   8 0   16
1829462 MN Mille Lacs 48 school 2725050 480 Independent Districts and Schools Onamia Public School District 272505001195 10 Onamia Primary School Elementary School (Grades PK-6) Regular School No Elementary PK 02 2020   kindergarten 18.0 1.0 0.0   11.0 0.0     0.0   5.0   17.0 18.0     0.0   0.0     21.0   12.0   35.0 18 1 0   11 0     0   5   17 18     0 0   21 12   35
1829463 MN Mille Lacs 48 school 2725050 480 Independent Districts and Schools Onamia Public School District 272505001195 10 Onamia Primary School Elementary School (Grades PK-6) Regular School No Elementary PK 02 2020   grade_1 10.0 0.0 0.0   8.0 0.0     0.0   3.0   9.0 12.0     0.0   0.0     10.0   7.0   21.0 10 0 0   8 0     0   3   9 12     0 0   10 7   21
1829464 MN Mille Lacs 48 school 2725050 480 Independent Districts and Schools Onamia Public School District 272505001195 10 Onamia Primary School Elementary School (Grades PK-6) Regular School No Elementary PK 02 2020   grade_2 13.0 0.0 0.0   11.0 0.0     0.0   1.0   11.0 14.0     0.0   1.0     20.0   5.0   25.0 13 0 0   11 0     0   1   11 14     0 1   20 5   25
1829465 MN Mille Lacs 48 school 2725050 480 Independent Districts and Schools Onamia Public School District 272505001195 10 Onamia Primary School Elementary School (Grades PK-6) Regular School No Elementary PK 02 2020   pk_12_total 56.0 1.0 0.0   49.0 1.0     1.0   12.0   58.0 62.0     0.0   1.0     71.0   47.0   120.0 56 1 0   49 1     1   12   58 62     0 1   71 47   120
1829634 MN Olmsted 55 school 2707350 531 Independent Districts and Schools Byron Public School District 270735004958 60 Byron Primary School Elementary School (Grades PK-6) Regular School No Elementary PK 02 2020   early_childhood_special_ed 21.0 1.0 1.0   0.0 0.0     0.0   1.0   16.0 8.0     0.0   0.0     2.0   *   24.0 21 1 1   0 0     0   1   16 8     0 0   2     24
1829635 MN Olmsted 55 school 2707350 531 Independent Districts and Schools Byron Public School District 270735004958 60 Byron Primary School Elementary School (Grades PK-6) Regular School No Elementary PK 02 2020   kindergarten 198.0 2.0 12.0   0.0 3.0     0.0   2.0   108.0 109.0     4.0   0.0     27.0   27.0   217.0 198 2 12   0 3     0   2   108 109     4 0   27 27   217
1829636 MN Olmsted 55 school 2707350 531 Independent Districts and Schools Byron Public School District 270735004958 60 Byron Primary School Elementary School (Grades PK-6) Regular School No Elementary PK 02 2020   grade_1 155.0 0.0 3.0   0.0 7.0     0.0   5.0   86.0 84.0     5.0   0.0     17.0   17.0   170.0 155 0 3   0 7     0   5   86 84     5 0   17 17   170
1829637 MN Olmsted 55 school 2707350 531 Independent Districts and Schools Byron Public School District 270735004958 60 Byron Primary School Elementary School (Grades PK-6) Regular School No Elementary PK 02 2020   grade_2 145.0 0.0 3.0   0.0 1.0     0.0   8.0   78.0 79.0     1.0   1.0     15.0   21.0   157.0 145 0 3   0 1     0   8   78 79     1 1   15 21   157
1829638 MN Olmsted 55 school 2707350 531 Independent Districts and Schools Byron Public School District 270735004958 60 Byron Primary School Elementary School (Grades PK-6) Regular School No Elementary PK 02 2020   pk_12_total 519.0 3.0 19.0   0.0 11.0     0.0   16.0   288.0 280.0     10.0   1.0     61.0   89.0   568.0 519 3 19   0 11     0   16   288 280     10 1   61 89   568
1829651 MN Olmsted 55 school 2738160 534 Independent Districts and Schools Stewartville Public School District 273816001651 11 Bonner Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 02 2020   kindergarten 144.0 0.0 9.0   0.0 0.0     0.0   4.0   75.0 82.0     2.0   1.0     41.0   30.0   157.0 144 0 9   0 0     0   4   75 82     2 1   41 30   157
1829652 MN Olmsted 55 school 2738160 534 Independent Districts and Schools Stewartville Public School District 273816001651 11 Bonner Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 02 2020   grade_1 151.0 1.0 10.0   0.0 0.0     0.0   7.0   82.0 87.0     0.0   0.0     33.0   26.0   169.0 151 1 10   0 0     0   7   82 87     0 0   33 26   169
1829653 MN Olmsted 55 school 2738160 534 Independent Districts and Schools Stewartville Public School District 273816001651 11 Bonner Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 02 2020   grade_2 150.0 3.0 9.0   0.0 0.0     0.0   8.0   87.0 83.0     4.0   0.0     41.0   29.0   170.0 150 3 9   0 0     0   8   87 83     4 0   41 29   170
1829654 MN Olmsted 55 school 2738160 534 Independent Districts and Schools Stewartville Public School District 273816001651 11 Bonner Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 02 2020   pk_12_total 445.0 4.0 28.0   0.0 0.0     0.0   19.0   244.0 252.0     6.0   1.0     115.0   85.0   496.0 445 4 28   0 0     0   19   244 252     6 1   115 85   496
1829669 MN Olmsted 55 school 2731800 535 Independent Districts and Schools Rochester Public School District 273180000987 116 Churchill Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 02 2020   kindergarten 55.0 11.0 10.0   0.0 9.0     0.0   10.0   46.0 49.0     13.0   0.0     28.0   11.0   95.0 55 11 10   0 9     0   10   46 49     13 0   28 11   95
1829670 MN Olmsted 55 school 2731800 535 Independent Districts and Schools Rochester Public School District 273180000987 116 Churchill Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 02 2020   grade_1 67.0 12.0 7.0   0.0 7.0     1.0   6.0   52.0 48.0     12.0   3.0     31.0   18.0   100.0 67 12 7   0 7     1   6   52 48     12 3   31 18   100
1829671 MN Olmsted 55 school 2731800 535 Independent Districts and Schools Rochester Public School District 273180000987 116 Churchill Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 02 2020   grade_2 61.0 10.0 4.0   0.0 10.0     0.0   4.0   43.0 46.0     12.0   2.0     32.0   12.0   89.0 61 10 4   0 10     0   4   43 46     12 2   32 12   89
1829672 MN Olmsted 55 school 2731800 535 Independent Districts and Schools Rochester Public School District 273180000987 116 Churchill Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 02 2020   pk_12_total 183.0 33.0 21.0   0.0 26.0     1.0   20.0   141.0 143.0     37.0   5.0     91.0   41.0   284.0 183 33 21   0 26     1   20   141 143     37 5   91 41   284
1829792 MN Otter Tail 56 school 2711880 544 Independent Districts and Schools Fergus Falls Public School District 271188000571 130 Adams Elementary Elementary School (Grades PK-6) Regular School No Elementary 01 02 2020   grade_1 131.0 1.0 4.0   0.0 2.0     0.0   16.0   79.0 75.0     2.0   0.0     50.0   15.0   154.0 131 1 4   0 2     0   16   79 75     2 0   50 15   154
1829793 MN Otter Tail 56 school 2711880 544 Independent Districts and Schools Fergus Falls Public School District 271188000571 130 Adams Elementary Elementary School (Grades PK-6) Regular School No Elementary 01 02 2020   grade_2 113.0 4.0 11.0   0.0 3.0     0.0   11.0   81.0 61.0     7.0   0.0     53.0   16.0   142.0 113 4 11   0 3     0   11   81 61     7 0   53 16   142
1829794 MN Otter Tail 56 school 2711880 544 Independent Districts and Schools Fergus Falls Public School District 271188000571 130 Adams Elementary Elementary School (Grades PK-6) Regular School No Elementary 01 02 2020   pk_12_total 244.0 5.0 15.0   0.0 5.0     0.0   27.0   160.0 136.0     9.0   0.0     103.0   31.0   296.0 244 5 15   0 5     0   27   160 136     9 0   103 31   296
1829926 MN Polk 60 school 2711130 595 Independent Districts and Schools East Grand Forks Public School Dist 271113000497 120 New Heights Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 02 2020   early_childhood_special_ed 23.0 4.0 7.0   3.0 0.0     0.0   0.0   21.0 16.0     0.0   0.0     8.0   *   37.0 23 4 7   3 0     0   0   21 16     0 0   8     37
1829927 MN Polk 60 school 2711130 595 Independent Districts and Schools East Grand Forks Public School Dist 271113000497 120 New Heights Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 02 2020   kindergarten 110.0 17.0 12.0   2.0 1.0     0.0   5.0   87.0 60.0     3.0   2.0     57.0   18.0   147.0 110 17 12   2 1     0   5   87 60     3 2   57 18   147
1829928 MN Polk 60 school 2711130 595 Independent Districts and Schools East Grand Forks Public School Dist 271113000497 120 New Heights Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 02 2020   grade_1 94.0 23.0 13.0   2.0 1.0     0.0   7.0   72.0 68.0     15.0   0.0     52.0   23.0   140.0 94 23 13   2 1     0   7   72 68     15 0   52 23   140
1829929 MN Polk 60 school 2711130 595 Independent Districts and Schools East Grand Forks Public School Dist 271113000497 120 New Heights Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 02 2020   grade_2 117.0 14.0 14.0   2.0 0.0     0.0   11.0   88.0 70.0     17.0   1.0     67.0   27.0   158.0 117 14 14   2 0     0   11   88 70     17 1   67 27   158
1829930 MN Polk 60 school 2711130 595 Independent Districts and Schools East Grand Forks Public School Dist 271113000497 120 New Heights Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 02 2020   pk_12_total 344.0 58.0 46.0   9.0 2.0     0.0   23.0   268.0 214.0     35.0   3.0     184.0   105.0   482.0 344 58 46   9 2     0   23   268 214     35 3   184 105   482
1830321 MN Ramsey 62 school 2733840 625 Independent Districts and Schools St. Paul Public School District 273384004682 463 L'etoile Du Nord French Immersion L Elementary School (Grades PK-6) Regular School No Elementary PK 02 2020   early_childhood_special_ed 0.0 1.0 1.0   0.0 0.0     0.0   0.0   2.0 0.0     *   *         *   2.0 0 1 1   0 0     0   0   2 0                 2
1830322 MN Ramsey 62 school 2733840 625 Independent Districts and Schools St. Paul Public School District 273384004682 463 L'etoile Du Nord French Immersion L Elementary School (Grades PK-6) Regular School No Elementary PK 02 2020   kindergarten 34.0 20.0 11.0   0.0 11.0     0.0   15.0   42.0 49.0     18.0   *     38.0   2.0   91.0 34 20 11   0 11     0   15   42 49     18     38 2   91
1830323 MN Ramsey 62 school 2733840 625 Independent Districts and Schools St. Paul Public School District 273384004682 463 L'etoile Du Nord French Immersion L Elementary School (Grades PK-6) Regular School No Elementary PK 02 2020   grade_1 37.0 6.0 10.0   0.0 5.0     0.0   14.0   26.0 46.0     *   0.0         3.0   72.0 37 6 10   0 5     0   14   26 46       0     3   72
1830324 MN Ramsey 62 school 2733840 625 Independent Districts and Schools St. Paul Public School District 273384004682 463 L'etoile Du Nord French Immersion L Elementary School (Grades PK-6) Regular School No Elementary PK 02 2020   pk_12_total 71.0 27.0 22.0   0.0 16.0     0.0   29.0   70.0 95.0     26.0   0.0     67.0   7.0   165.0 71 27 22   0 16     0   29   70 95     26 0   67 7   165
1830717 MN Saint Louis 69 school 2713980 701 Independent Districts and Schools Hibbing Public School District 271398001520 140 Greenhaven Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 02 2020   early_childhood_special_ed 30.0 1.0 0.0   0.0 0.0     0.0   1.0   25.0 7.0     *   *         *   32.0 30 1 0   0 0     0   1   25 7                 32
1830718 MN Saint Louis 69 school 2713980 701 Independent Districts and Schools Hibbing Public School District 271398001520 140 Greenhaven Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 02 2020   kindergarten 76.0 1.0 0.0   3.0 0.0     0.0   9.0   45.0 44.0     0.0   0.0     41.0   *   89.0 76 1 0   3 0     0   9   45 44     0 0   41     89
1830719 MN Saint Louis 69 school 2713980 701 Independent Districts and Schools Hibbing Public School District 271398001520 140 Greenhaven Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 02 2020   grade_1 82.0 2.0 5.0   0.0 0.0     0.0   6.0   50.0 45.0     0.0   0.0         *   95.0 82 2 5   0 0     0   6   50 45     0 0         95
1830720 MN Saint Louis 69 school 2713980 701 Independent Districts and Schools Hibbing Public School District 271398001520 140 Greenhaven Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 02 2020   grade_2 67.0 0.0 1.0   1.0 0.0     0.0   10.0   40.0 39.0     *   *     38.0   *   79.0 67 0 1   1 0     0   10   40 39           38     79
1830721 MN Saint Louis 69 school 2713980 701 Independent Districts and Schools Hibbing Public School District 271398001520 140 Greenhaven Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 02 2020   pk_12_total 255.0 4.0 6.0   4.0 0.0     0.0   26.0   160.0 135.0     0.0   0.0     136.0   94.0   295.0 255 4 6   4 0     0   26   160 135     0 0   136 94   295
1830722 MN Saint Louis 69 school 2713980 701 Independent Districts and Schools Hibbing Public School District 271398001528 160 Washington Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 02 2020   kindergarten 65.0 2.0 2.0   0.0 0.0     0.0   15.0   36.0 48.0     0.0   2.0     56.0   *   84.0 65 2 2   0 0     0   15   36 48     0 2   56     84
1830723 MN Saint Louis 69 school 2713980 701 Independent Districts and Schools Hibbing Public School District 271398001528 160 Washington Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 02 2020   grade_1 70.0 4.0 5.0   1.0 1.0     0.0   8.0   51.0 38.0     1.0   0.0         *   89.0 70 4 5   1 1     0   8   51 38     1 0         89
1830724 MN Saint Louis 69 school 2713980 701 Independent Districts and Schools Hibbing Public School District 271398001528 160 Washington Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 02 2020   grade_2 70.0 1.0 3.0   0.0 0.0     0.0   8.0   43.0 39.0     0.0   0.0         22.0   82.0 70 1 3   0 0     0   8   43 39     0 0     22   82
1830725 MN Saint Louis 69 school 2713980 701 Independent Districts and Schools Hibbing Public School District 271398001528 160 Washington Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 02 2020   pk_12_total 205.0 7.0 10.0   1.0 1.0     0.0   31.0   130.0 125.0     1.0   2.0     141.0   57.0   255.0 205 7 10   1 1     0   31   130 125     1 2   141 57   255
1830751 MN Saint Louis 69 school 2741040 706 Independent Districts and Schools Virginia Public School District 274104002552 112 Parkview Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 02 2020   early_childhood_special_ed 29.0 3.0 0.0   1.0 0.0     0.0   3.0   26.0 10.0     0.0   0.0     19.0   *   36.0 29 3 0   1 0     0   3   26 10     0 0   19     36
1830752 MN Saint Louis 69 school 2741040 706 Independent Districts and Schools Virginia Public School District 274104002552 112 Parkview Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 02 2020   pre_kindergarten 79.0 2.0 3.0   0.0 0.0     0.0   5.0   47.0 42.0     0.0   0.0     27.0   0.0   89.0 79 2 3   0 0     0   5   47 42     0 0   27 0   89
1830753 MN Saint Louis 69 school 2741040 706 Independent Districts and Schools Virginia Public School District 274104002552 112 Parkview Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 02 2020   kindergarten 106.0 3.0 5.0   3.0 0.0     0.0   13.0   58.0 72.0     0.0   1.0     52.0   17.0   130.0 106 3 5   3 0     0   13   58 72     0 1   52 17   130
1830754 MN Saint Louis 69 school 2741040 706 Independent Districts and Schools Virginia Public School District 274104002552 112 Parkview Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 02 2020   grade_1 108.0 6.0 4.0   2.0 1.0     0.0   19.0   77.0 63.0     0.0   1.0     55.0   29.0   140.0 108 6 4   2 1     0   19   77 63     0 1   55 29   140
1830755 MN Saint Louis 69 school 2741040 706 Independent Districts and Schools Virginia Public School District 274104002552 112 Parkview Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 02 2020   grade_2 100.0 2.0 5.0   5.0 0.0     0.0   8.0   70.0 50.0     0.0   0.0     57.0   20.0   120.0 100 2 5   5 0     0   8   70 50     0 0   57 20   120
1830756 MN Saint Louis 69 school 2741040 706 Independent Districts and Schools Virginia Public School District 274104002552 112 Parkview Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 02 2020   pk_12_total 422.0 16.0 17.0   11.0 1.0     0.0   48.0   278.0 237.0     0.0   2.0     210.0   102.0   515.0 422 16 17   11 1     0   48   278 237     0 2   210 102   515
1830851 MN Scott 70 school 2704050 716 Independent Districts and Schools Belle Plaine Public School District 270405000183 10 Chatfield Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 02 2020   kindergarten 96.0 4.0 9.0   0.0 1.0     0.0   6.0   65.0 51.0     3.0   0.0     24.0   20.0   116.0 96 4 9   0 1     0   6   65 51     3 0   24 20   116
1830852 MN Scott 70 school 2704050 716 Independent Districts and Schools Belle Plaine Public School District 270405000183 10 Chatfield Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 02 2020   grade_1 78.0 5.0 5.0   1.0 4.0     0.0   5.0   52.0 46.0     4.0   0.0     29.0   15.0   98.0 78 5 5   1 4     0   5   52 46     4 0   29 15   98
1830853 MN Scott 70 school 2704050 716 Independent Districts and Schools Belle Plaine Public School District 270405000183 10 Chatfield Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 02 2020   grade_2 109.0 0.0 10.0   3.0 2.0     1.0   4.0   57.0 72.0     3.0   0.0     32.0   16.0   129.0 109 0 10   3 2     1   4   57 72     3 0   32 16   129
1830854 MN Scott 70 school 2704050 716 Independent Districts and Schools Belle Plaine Public School District 270405000183 10 Chatfield Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 02 2020   pk_12_total 283.0 9.0 24.0   4.0 7.0     1.0   15.0   174.0 169.0     10.0   0.0     85.0   51.0   343.0 283 9 24   4 7     1   15   174 169     10 0   85 51   343
1830976 MN Sherburne 71 school 2703870 726 Independent Districts and Schools Becker Public School District 270387003092 40 Becker Primary Elementary School (Grades PK-6) Regular School No Elementary PK 02 2020   early_childhood_special_ed 37.0 0.0 1.0   0.0 1.0     0.0   4.0   26.0 17.0     0.0   0.0     8.0   *   43.0 37 0 1   0 1     0   4   26 17     0 0   8     43
1830977 MN Sherburne 71 school 2703870 726 Independent Districts and Schools Becker Public School District 270387003092 40 Becker Primary Elementary School (Grades PK-6) Regular School No Elementary PK 02 2020   kindergarten 213.0 0.0 9.0   0.0 1.0     0.0   6.0   133.0 96.0     5.0   0.0     45.0   45.0   229.0 213 0 9   0 1     0   6   133 96     5 0   45 45   229
1830978 MN Sherburne 71 school 2703870 726 Independent Districts and Schools Becker Public School District 270387003092 40 Becker Primary Elementary School (Grades PK-6) Regular School No Elementary PK 02 2020   grade_1 201.0 1.0 1.0   0.0 1.0     0.0   9.0   97.0 116.0     2.0   0.0     37.0   47.0   213.0 201 1 1   0 1     0   9   97 116     2 0   37 47   213
1830979 MN Sherburne 71 school 2703870 726 Independent Districts and Schools Becker Public School District 270387003092 40 Becker Primary Elementary School (Grades PK-6) Regular School No Elementary PK 02 2020   grade_2 201.0 2.0 4.0   0.0 1.0     0.0   5.0   94.0 119.0     5.0   1.0     40.0   26.0   213.0 201 2 4   0 1     0   5   94 119     5 1   40 26   213
1830980 MN Sherburne 71 school 2703870 726 Independent Districts and Schools Becker Public School District 270387003092 40 Becker Primary Elementary School (Grades PK-6) Regular School No Elementary PK 02 2020   pk_12_total 652.0 3.0 15.0   0.0 4.0     0.0   24.0   350.0 348.0     12.0   1.0     130.0   161.0   698.0 652 3 15   0 4     0   24   350 348     12 1   130 161   698
1830985 MN Sherburne 71 school 2705460 727 Independent Districts and Schools Big Lake Public School District 270546004180 40 Liberty Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 02 2020   early_childhood_special_ed 32.0 4.0 3.0   0.0 1.0     0.0   2.0   25.0 17.0     0.0   0.0     9.0   *   42.0 32 4 3   0 1     0   2   25 17     0 0   9     42

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