Data source: Big Local News · About: Big Local

13,914 rows where state = "MN" and year = 2021 sorted by ccd_school_high_grade

View and edit SQL

year

  • 2021 · 13,914
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
1715811 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 2021   early_childhood_special_ed 42 1 7   0 0     0   1   37 14     0.0   0.0     11.0   *   51 42 1 7   0 0     0   1   37 14     0 0   11     51
1715812 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 2021   kindergarten 136 2 26   0 0     1   6   92 79     18.0   0.0     55.0   15.0   171 136 2 26   0 0     1   6   92 79     18 0   55 15   171
1715813 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 2021   grade_1 146 2 25   0 1     0   6   95 85     18.0   0.0     55.0   36.0   180 146 2 25   0 1     0   6   95 85     18 0   55 36   180
1715814 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 2021   pk_12_total 324 5 58   0 1     1   13   224 178     36.0   0.0     121.0   102.0   402 324 5 58   0 1     1   13   224 178     36 0   121 102   402
1716063 MN Nicollet 52 school 2733870 508 Independent Districts and Schools St. Peter Public School District 273387001639 50 South Elementary School Elementary School (Grades PK-6) Regular School No Elementary KG 01 2021   kindergarten 73 17 23   0 1     1   4   61 58     14.0   3.0     46.0   33.0   119 73 17 23   0 1     1   4   61 58     14 3   46 33   119
1716064 MN Nicollet 52 school 2733870 508 Independent Districts and Schools St. Peter Public School District 273387001639 50 South Elementary School Elementary School (Grades PK-6) Regular School No Elementary KG 01 2021   grade_1 95 13 29   0 0     0   8   70 75     13.0   2.0     46.0   33.0   145 95 13 29   0 0     0   8   70 75     13 2   46 33   145
1716065 MN Nicollet 52 school 2733870 508 Independent Districts and Schools St. Peter Public School District 273387001639 50 South Elementary School Elementary School (Grades PK-6) Regular School No Elementary KG 01 2021   pk_12_total 168 30 52   0 1     1   12   131 133     27.0   5.0     92.0   66.0   264 168 30 52   0 1     1   12   131 133     27 5   92 66   264
1716254 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 2021   kindergarten 152 1 2   1 0     0   12   91 77     1.0   0.0     68.0   17.0   168 152 1 2   1 0     0   12   91 77     1 0   68 17   168
1716255 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 2021   grade_1 54 0 1   1 1     0   6   27 36     1.0   0.0     29.0   6.0   63 54 0 1   1 1     0   6   27 36     1 0   29 6   63
1716256 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 2021   pk_12_total 206 1 3   2 1     0   18   118 113     2.0   0.0     97.0   23.0   231 206 1 3   2 1     0   18   118 113     2 0   97 23   231
1716619 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 2021   kindergarten 132 5 5   0 6     0   7   68 87     *   0.0     13.0   19.0   155 132 5 5   0 6     0   7   68 87       0   13 19   155
1716620 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 2021   grade_1 124 3 2   0 4     0   10   76 67     0.0   0.0     18.0   22.0   143 124 3 2   0 4     0   10   76 67     0 0   18 22   143
1716621 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 2021   pk_12_total 256 8 7   0 10     0   17   144 154     *   0.0     31.0   41.0   298 256 8 7   0 10     0   17   144 154       0   31 41   298
1718396 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 2021   kindergarten 167 0 7   0 2     0   12   102 86     1.0   0.0     26.0   *   188 167 0 7   0 2     0   12   102 86     1 0   26     188
1718397 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 2021   grade_1 181 2 4   0 4     0   7   103 95     1.0   1.0     22.0   19.0   198 181 2 4   0 4     0   7   103 95     1 1   22 19   198
1718398 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 2021   pk_12_total 348 2 11   0 6     0   19   205 181     2.0   1.0     48.0   *   386 348 2 11   0 6     0   19   205 181     2 1   48     386
1718736 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 2021   early_childhood_special_ed 23 0 2   0 0     0   0   14 11     0.0   0.0     11.0   *   25 23 0 2   0 0     0   0   14 11     0 0   11     25
1718737 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 2021   kindergarten 63 1 14   0 0     0   6   43 41     *   *     *   *   84 63 1 14   0 0     0   6   43 41                 84
1718738 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 2021   grade_1 55 1 18   1 1     0   2   42 36     *   *     *   *   78 55 1 18   1 1     0   2   42 36                 78
1718739 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 2021   pk_12_total 141 2 34   1 1     0   8   99 88     21.0   0.0     87.0   54.0   187 141 2 34   1 1     0   8   99 88     21 0   87 54   187
1719042 MN Douglas 21 school 2700382 2908 Independent Districts and Schools Brandon-Evansville Public Schools 270038204738 1 Brandon Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 01 2021   early_childhood_special_ed 30 0 0   0 0     0   1   19 12     0.0   0.0     12.0   *   31 30 0 0   0 0     0   1   19 12     0 0   12     31
1719043 MN Douglas 21 school 2700382 2908 Independent Districts and Schools Brandon-Evansville Public Schools 270038204738 1 Brandon Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 01 2021   kindergarten 32 0 1   0 1     0   2   18 18     0.0   0.0     9.0   9.0   36 32 0 1   0 1     0   2   18 18     0 0   9 9   36
1719044 MN Douglas 21 school 2700382 2908 Independent Districts and Schools Brandon-Evansville Public Schools 270038204738 1 Brandon Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 01 2021   grade_1 34 1 0   0 0     0   1   22 14     0.0   0.0     10.0   3.0   36 34 1 0   0 0     0   1   22 14     0 0   10 3   36
1719045 MN Douglas 21 school 2700382 2908 Independent Districts and Schools Brandon-Evansville Public Schools 270038204738 1 Brandon Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 01 2021   pk_12_total 96 1 1   0 1     0   4   59 44     0.0   0.0     31.0   43.0   103 96 1 1   0 1     0   4   59 44     0 0   31 43   103
1719691 MN Hennepin 27 school 2700190 4079 Charter Schools Friendship Academy of Fine Arts Charter 270019003143 10 Friendship Academy of Fine Arts Charter Elementary School (Grades PK-6) Regular School Yes Elementary KG 01 2021   kindergarten 2 34 0   0 0     0   0   17 19     0.0   1.0     26.0   4.0   36 2 34 0   0 0     0   0   17 19     0 1   26 4   36
1719692 MN Hennepin 27 school 2700190 4079 Charter Schools Friendship Academy of Fine Arts Charter 270019003143 10 Friendship Academy of Fine Arts Charter Elementary School (Grades PK-6) Regular School Yes Elementary KG 01 2021   grade_1 1 25 0   0 0     0   0   10 16     0.0   3.0     22.0   1.0   26 1 25 0   0 0     0   0   10 16     0 3   22 1   26
1719693 MN Hennepin 27 school 2700190 4079 Charter Schools Friendship Academy of Fine Arts Charter 270019003143 10 Friendship Academy of Fine Arts Charter Elementary School (Grades PK-6) Regular School Yes Elementary KG 01 2021   pk_12_total 3 59 0   0 0     0   0   27 35     0.0   4.0     48.0   5.0   62 3 59 0   0 0     0   0   27 35     0 4   48 5   62
1720207 MN Anoka 2 school 2700380 4213 Charter Schools Prodeo Academy 270038004642 10 Prodeo Academy Columbia Heights Primary Elementary School (Grades PK-6) Regular School Yes Elementary PK 01 2021   early_childhood_special_ed 0 4 0   0 0     0   0   2 2     *   *     *   *   4 0 4 0   0 0     0   0   2 2                 4
1720208 MN Anoka 2 school 2700380 4213 Charter Schools Prodeo Academy 270038004642 10 Prodeo Academy Columbia Heights Primary Elementary School (Grades PK-6) Regular School Yes Elementary PK 01 2021   pre_kindergarten 2 39 11   0 0     0   0   25 27     10.0   0.0     34.0   0.0   52 2 39 11   0 0     0   0   25 27     10 0   34 0   52
1720209 MN Anoka 2 school 2700380 4213 Charter Schools Prodeo Academy 270038004642 10 Prodeo Academy Columbia Heights Primary Elementary School (Grades PK-6) Regular School Yes Elementary PK 01 2021   kindergarten 0 96 19   0 0     0   4   55 64     15.0   14.0     *   *   119 0 96 19   0 0     0   4   55 64     15 14         119
1720210 MN Anoka 2 school 2700380 4213 Charter Schools Prodeo Academy 270038004642 10 Prodeo Academy Columbia Heights Primary Elementary School (Grades PK-6) Regular School Yes Elementary PK 01 2021   grade_1 0 5 0   0 0     0   0   2 3     *   *     *   *   5 0 5 0   0 0     0   0   2 3                 5
1720211 MN Anoka 2 school 2700380 4213 Charter Schools Prodeo Academy 270038004642 10 Prodeo Academy Columbia Heights Primary Elementary School (Grades PK-6) Regular School Yes Elementary PK 01 2021   pk_12_total 2 144 30   0 0     0   4   84 96     26.0   16.0     *   10.0   180 2 144 30   0 0     0   4   84 96     26 16     10   180
1720508 MN Hennepin 27 school 2700459 4276 Charter Schools Notre Ecole Academy 270045905245 10 Notre Ecole Academy Elementary School (Grades PK-6) Regular School Yes Elementary KG 01 2021   kindergarten 9 2 1   0 0     0   0   4 8     0.0   0.0     1.0   1.0   12 9 2 1   0 0     0   0   4 8     0 0   1 1   12
1720509 MN Hennepin 27 school 2700459 4276 Charter Schools Notre Ecole Academy 270045905245 10 Notre Ecole Academy Elementary School (Grades PK-6) Regular School Yes Elementary KG 01 2021   grade_1 11 3 0   0 0     0   0   6 8     2.0   0.0     2.0   1.0   14 11 3 0   0 0     0   0   6 8     2 0   2 1   14
1720510 MN Hennepin 27 school 2700459 4276 Charter Schools Notre Ecole Academy 270045905245 10 Notre Ecole Academy Elementary School (Grades PK-6) Regular School Yes Elementary KG 01 2021   pk_12_total 20 5 1   0 0     0   0   10 16     2.0   0.0     3.0   2.0   26 20 5 1   0 0     0   0   10 16     2 0   3 2   26
1723966 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 2021   early_childhood_special_ed 5 1 1   0 2     0   0   8 1     *   *     *   *   9 5 1 1   0 2     0   0   8 1                 9
1723967 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 2021   pk_12_total 5 1 1   0 2     0   0   8 1     *   *     *   *   9 5 1 1   0 2     0   0   8 1                 9
1715080 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 2021   kindergarten 155 3 7   0 3     0   17   99 86     0.0   0.0     7.0   15.0   185 155 3 7   0 3     0   17   99 86     0 0   7 15   185
1715081 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 2021   grade_1 172 0 6   0 2     0   9   99 90     5.0   0.0     12.0   13.0   189 172 0 6   0 2     0   9   99 90     5 0   12 13   189
1715082 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 2021   grade_2 173 0 8   0 1     0   11   107 86     5.0   2.0     9.0   18.0   193 173 0 8   0 1     0   11   107 86     5 2   9 18   193
1715083 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 2021   pk_12_total 500 3 21   0 6     0   37   305 262     10.0   2.0     28.0   46.0   567 500 3 21   0 6     0   37   305 262     10 2   28 46   567
1715779 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 2021   early_childhood_special_ed 24 1 5   0 6     0   1   22 15     0.0   0.0     10.0   *   37 24 1 5   0 6     0   1   22 15     0 0   10     37
1715780 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 2021   kindergarten 80 14 35   1 23     0   14   75 92     45.0   2.0     79.0   18.0   167 80 14 35   1 23     0   14   75 92     45 2   79 18   167
1715781 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 2021   grade_1 96 11 36   1 18     1   11   84 90     47.0   2.0     77.0   29.0   174 96 11 36   1 18     1   11   84 90     47 2   77 29   174
1715782 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 2021   grade_2 73 10 36   1 25     0   12   92 65     47.0   1.0     84.0   28.0   157 73 10 36   1 25     0   12   92 65     47 1   84 28   157
1715783 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 2021   pk_12_total 273 36 112   3 72     1   38   273 262     139.0   5.0     250.0   112.0   535 273 36 112   3 72     1   38   273 262     139 5   250 112   535
1715850 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 2021   kindergarten 27 0 2   0 0     0   1   15 15     0.0   0.0     8.0   1.0   30 27 0 2   0 0     0   1   15 15     0 0   8 1   30
1715851 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 2021   grade_1 32 1 1   0 0     0   1   16 19     0.0   0.0     6.0   1.0   35 32 1 1   0 0     0   1   16 19     0 0   6 1   35
1715852 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 2021   grade_2 27 0 0   0 0     0   1   18 10     0.0   0.0     10.0   4.0   28 27 0 0   0 0     0   1   18 10     0 0   10 4   28
1715853 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 2021   pk_12_total 86 1 3   0 0     0   3   49 44     0.0   0.0     24.0   6.0   93 86 1 3   0 0     0   3   49 44     0 0   24 6   93
1715913 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 2021   kindergarten 214 1 8   3 0     0   10   129 107     3.0   0.0     70.0   33.0   236 214 1 8   3 0     0   10   129 107     3 0   70 33   236
1715914 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 2021   grade_1 166 1 9   3 2     0   6   92 95     1.0   0.0     56.0   34.0   187 166 1 9   3 2     0   6   92 95     1 0   56 34   187
1715915 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 2021   grade_2 215 3 5   1 1     0   8   107 126     4.0   3.0     67.0   31.0   233 215 3 5   1 1     0   8   107 126     4 3   67 31   233
1715916 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 2021   pk_12_total 595 5 22   7 3     0   24   328 328     8.0   3.0     193.0   98.0   656 595 5 22   7 3     0   24   328 328     8 3   193 98   656
1715921 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 2021   early_childhood_special_ed 3 0 0   6 0     0   3   8 4     0.0   0.0     5.0   *   12 3 0 0   6 0     0   3   8 4     0 0   5     12
1715922 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 2021   pre_kindergarten 11 0 0   4 0     0   3   6 12     0.0   0.0     12.0   0.0   18 11 0 0   4 0     0   3   6 12     0 0   12 0   18
1715923 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 2021   kindergarten 13 1 0   14 1     0   2   16 15     0.0   0.0     18.0   10.0   31 13 1 0   14 1     0   2   16 15     0 0   18 10   31
1715924 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 2021   grade_1 15 2 1   11 0     0   6   15 20     0.0   0.0     20.0   8.0   35 15 2 1   11 0     0   6   15 20     0 0   20 8   35
1715925 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 2021   grade_2 8 0 0   10 0     0   2   7 13     0.0   0.0     9.0   5.0   20 8 0 0   10 0     0   2   7 13     0 0   9 5   20
1715926 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 2021   pk_12_total 50 3 1   45 1     0   16   52 64     0.0   0.0     64.0   35.0   116 50 3 1   45 1     0   16   52 64     0 0   64 35   116
1716093 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 2021   early_childhood_special_ed 14 1 1   0 0     0   4   15 5     0.0   0.0     1.0   *   20 14 1 1   0 0     0   4   15 5     0 0   1     20
1716094 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 2021   kindergarten 160 2 3   0 2     0   5   81 91     0.0   0.0     17.0   16.0   172 160 2 3   0 2     0   5   81 91     0 0   17 16   172
1716095 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 2021   grade_1 177 1 10   0 6     0   4   93 105     6.0   1.0     17.0   25.0   198 177 1 10   0 6     0   4   93 105     6 1   17 25   198
1716096 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 2021   grade_2 161 0 7   0 9     0   6   92 91     6.0   1.0     17.0   20.0   183 161 0 7   0 9     0   6   92 91     6 1   17 20   183
1716097 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 2021   pk_12_total 512 4 21   0 17     0   19   281 292     12.0   2.0     52.0   81.0   573 512 4 21   0 17     0   19   281 292     12 2   52 81   573
1716110 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 2021   kindergarten 133 1 2   1 1     0   5   77 66     1.0   1.0     23.0   27.0   143 133 1 2   1 1     0   5   77 66     1 1   23 27   143
1716111 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 2021   grade_1 142 0 9   0 0     0   2   72 81     1.0   0.0     30.0   32.0   153 142 0 9   0 0     0   2   72 81     1 0   30 32   153
1716112 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 2021   grade_2 144 2 11   0 0     0   8   78 87     1.0   1.0     23.0   27.0   165 144 2 11   0 0     0   8   78 87     1 1   23 27   165
1716113 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 2021   pk_12_total 419 3 22   1 1     0   15   227 234     3.0   2.0     76.0   86.0   461 419 3 22   1 1     0   15   227 234     3 2   76 86   461
1716128 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 2021   kindergarten 55 15 12   1 10     1   12   47 59     14.0   1.0     34.0   16.0   106 55 15 12   1 10     1   12   47 59     14 1   34 16   106
1716129 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 2021   grade_1 53 9 9   0 7     0   11   38 51     5.0   0.0     21.0   12.0   89 53 9 9   0 7     0   11   38 51     5 0   21 12   89
1716130 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 2021   grade_2 63 13 8   0 7     1   5   49 48     14.0   2.0     32.0   20.0   97 63 13 8   0 7     1   5   49 48     14 2   32 20   97
1716131 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 2021   pk_12_total 171 37 29   1 24     2   28   134 158     33.0   3.0     87.0   48.0   292 171 37 29   1 24     2   28   134 158     33 3   87 48   292
1716247 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 2021   grade_1 107 3 2   0 0     0   6   60 58     5.0   0.0     40.0   12.0   118 107 3 2   0 0     0   6   60 58     5 0   40 12   118
1716248 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 2021   grade_2 109 3 3   1 1     1   15   71 62     4.0   0.0     41.0   16.0   133 109 3 3   1 1     1   15   71 62     4 0   41 16   133
1716249 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 2021   pk_12_total 216 6 5   1 1     1   21   131 120     9.0   0.0     81.0   28.0   251 216 6 5   1 1     1   21   131 120     9 0   81 28   251
1716380 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 2021   early_childhood_special_ed 29 7 4   2 1     1   0   28 16     0.0   0.0     16.0   *   44 29 7 4   2 1     1   0   28 16     0 0   16     44
1716381 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 2021   kindergarten 113 22 22   2 0     0   10   96 73     0.0   0.0     65.0   29.0   169 113 22 22   2 0     0   10   96 73     0 0   65 29   169
1716382 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 2021   grade_1 100 20 17   2 0     0   6   83 62     14.0   1.0     55.0   19.0   145 100 20 17   2 0     0   6   83 62     14 1   55 19   145
1716383 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 2021   grade_2 92 25 13   2 1     0   8   72 69     19.0   0.0     56.0   19.0   141 92 25 13   2 1     0   8   72 69     19 0   56 19   141
1716384 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 2021   pk_12_total 334 74 56   8 2     1   24   279 220     33.0   1.0     192.0   111.0   499 334 74 56   8 2     1   24   279 220     33 1   192 111   499
1716770 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 2021   early_childhood_special_ed 1 0 1   0 2     0   1   2 3     *   *     *   *   5 1 0 1   0 2     0   1   2 3                 5
1716771 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 2021   kindergarten 29 15 7   0 4     0   5   32 28     19.0   0.0     20.0   4.0   60 29 15 7   0 4     0   5   32 28     19 0   20 4   60
1716772 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 2021   grade_1 23 18 6   0 6     0   9   26 36     *   *     *   0.0   62 23 18 6   0 6     0   9   26 36             0   62
1716773 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 2021   pk_12_total 53 33 14   0 12     0   15   60 67     30.0   1.0     42.0   9.0   127 53 33 14   0 12     0   15   60 67     30 1   42 9   127
1717164 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 2021   early_childhood_special_ed 37 1 0   0 0     0   2   28 12     0.0   0.0     26.0   *   40 37 1 0   0 0     0   2   28 12     0 0   26     40
1717165 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 2021   kindergarten 73 0 0   1 0     0   6   44 36     0.0   0.0     39.0   25.0   80 73 0 0   1 0     0   6   44 36     0 0   39 25   80
1717166 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 2021   grade_1 65 4 1   4 0     0   4   34 44     0.0   0.0     38.0   17.0   78 65 4 1   4 0     0   4   34 44     0 0   38 17   78
1717167 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 2021   grade_2 78 1 5   2 0     0   4   46 44     0.0   0.0     41.0   18.0   90 78 1 5   2 0     0   4   46 44     0 0   41 18   90
1717168 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 2021   pk_12_total 253 6 6   7 0     0   16   152 136     0.0   0.0     144.0   100.0   288 253 6 6   7 0     0   16   152 136     0 0   144 100   288
1717169 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 2021   kindergarten 70 3 1   1 2     0   8   43 42     0.0   1.0     45.0   13.0   85 70 3 1   1 2     0   8   43 42     0 1   45 13   85
1717170 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 2021   grade_1 54 1 3   1 0     0   15   31 43     0.0   1.0     40.0   13.0   74 54 1 3   1 0     0   15   31 43     0 1   40 13   74
1717171 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 2021   grade_2 66 3 5   2 1     0   8   52 33     1.0   0.0     39.0   20.0   85 66 3 5   2 1     0   8   52 33     1 0   39 20   85
1717172 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 2021   pk_12_total 190 7 9   4 3     0   31   126 118     1.0   2.0     124.0   46.0   244 190 7 9   4 3     0   31   126 118     1 2   124 46   244
1717285 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 2021   early_childhood_special_ed 31 1 3   0 0     0   3   17 21     0.0   0.0     16.0   *   38 31 1 3   0 0     0   3   17 21     0 0   16     38
1717286 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 2021   kindergarten 97 5 9   0 0     0   7   67 51     2.0   0.0     28.0   28.0   118 97 5 9   0 0     0   7   67 51     2 0   28 28   118
1717287 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 2021   grade_1 73 6 6   0 1     0   5   51 40     2.0   0.0     24.0   17.0   91 73 6 6   0 1     0   5   51 40     2 0   24 17   91
1717288 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 2021   grade_2 81 3 2   1 5     0   6   51 47     3.0   0.0     25.0   18.0   98 81 3 2   1 5     0   6   51 47     3 0   25 18   98
1717289 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 2021   pk_12_total 282 15 20   1 6     0   21   186 159     7.0   0.0     93.0   101.0   345 282 15 20   1 6     0   21   186 159     7 0   93 101   345
1717410 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 2021   early_childhood_special_ed 37 3 1   0 1     0   2   24 20     0.0   0.0     8.0   *   44 37 3 1   0 1     0   2   24 20     0 0   8     44

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