Data source: Big Local News · About: Big Local

13,914 rows where state = "MN" and year = 2021 sorted by ccd_school_low_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
1713544 MN Anoka 2 school 2733330 16 Independent Districts and Schools Spring Lake Park Public Schools 273333004657 787 Elementary Lighthouse Elementary School (Grades PK-6) Regular School No Elementary 01 06 2021   grade_1 0 0 1   0 0     0   0   1 0     *   *     *   *   1 0 0 1   0 0     0   0   1 0                 1
1713545 MN Anoka 2 school 2733330 16 Independent Districts and Schools Spring Lake Park Public Schools 273333004657 787 Elementary Lighthouse Elementary School (Grades PK-6) Regular School No Elementary 01 06 2021   grade_2 0 0 0   0 1     0   0   1 0     *   *     *   *   1 0 0 0   0 1     0   0   1 0                 1
1713546 MN Anoka 2 school 2733330 16 Independent Districts and Schools Spring Lake Park Public Schools 273333004657 787 Elementary Lighthouse Elementary School (Grades PK-6) Regular School No Elementary 01 06 2021   grade_3 4 0 1   0 0     0   0   4 1     *   *     *   *   5 4 0 1   0 0     0   0   4 1                 5
1713547 MN Anoka 2 school 2733330 16 Independent Districts and Schools Spring Lake Park Public Schools 273333004657 787 Elementary Lighthouse Elementary School (Grades PK-6) Regular School No Elementary 01 06 2021   grade_4 5 0 0   0 0     0   1   2 4     *   *     *   *   6 5 0 0   0 0     0   1   2 4                 6
1713548 MN Anoka 2 school 2733330 16 Independent Districts and Schools Spring Lake Park Public Schools 273333004657 787 Elementary Lighthouse Elementary School (Grades PK-6) Regular School No Elementary 01 06 2021   grade_5 8 2 0   0 1     0   1   10 2     0.0   0.0     2.0   3.0   12 8 2 0   0 1     0   1   10 2     0 0   2 3   12
1713549 MN Anoka 2 school 2733330 16 Independent Districts and Schools Spring Lake Park Public Schools 273333004657 787 Elementary Lighthouse Elementary School (Grades PK-6) Regular School No Elementary 01 06 2021   grade_6 9 0 0   0 0     0   2   7 4     0.0   0.0     0.0   2.0   11 9 0 0   0 0     0   2   7 4     0 0   0 2   11
1713550 MN Anoka 2 school 2733330 16 Independent Districts and Schools Spring Lake Park Public Schools 273333004657 787 Elementary Lighthouse Elementary School (Grades PK-6) Regular School No Elementary 01 06 2021   pk_12_total 26 2 2   0 2     0   4   25 11     0.0   0.0     *   6.0   36 26 2 2   0 2     0   4   25 11     0 0     6   36
1713644 MN Beltrami 4 school 2730510 38 Independent Districts and Schools Red Lake Public School District 273051001302 10 Red Lake Elementary Elementary School (Grades PK-6) Regular School No Elementary 01 05 2021   grade_1 0 0 0   109 0     0   0   41 68     *   4.0     *   25.0   109 0 0 0   109 0     0   0   41 68       4     25   109
1713645 MN Beltrami 4 school 2730510 38 Independent Districts and Schools Red Lake Public School District 273051001302 10 Red Lake Elementary Elementary School (Grades PK-6) Regular School No Elementary 01 05 2021   grade_2 0 0 0   111 0     0   0   57 54     0.0   7.0     *   22.0   111 0 0 0   111 0     0   0   57 54     0 7     22   111
1713646 MN Beltrami 4 school 2730510 38 Independent Districts and Schools Red Lake Public School District 273051001302 10 Red Lake Elementary Elementary School (Grades PK-6) Regular School No Elementary 01 05 2021   grade_3 0 0 0   126 0     0   0   74 52     0.0   17.0     *   34.0   126 0 0 0   126 0     0   0   74 52     0 17     34   126
1713647 MN Beltrami 4 school 2730510 38 Independent Districts and Schools Red Lake Public School District 273051001302 10 Red Lake Elementary Elementary School (Grades PK-6) Regular School No Elementary 01 05 2021   grade_4 0 0 0   115 0     0   0   58 57     0.0   18.0     *   22.0   115 0 0 0   115 0     0   0   58 57     0 18     22   115
1713648 MN Beltrami 4 school 2730510 38 Independent Districts and Schools Red Lake Public School District 273051001302 10 Red Lake Elementary Elementary School (Grades PK-6) Regular School No Elementary 01 05 2021   grade_5 0 0 0   117 0     0   1   55 63     0.0   29.0     *   27.0   118 0 0 0   117 0     0   1   55 63     0 29     27   118
1713649 MN Beltrami 4 school 2730510 38 Independent Districts and Schools Red Lake Public School District 273051001302 10 Red Lake Elementary Elementary School (Grades PK-6) Regular School No Elementary 01 05 2021   pk_12_total 0 0 0   578 0     0   1   285 294     *   75.0     521.0   130.0   579 0 0 0   578 0     0   1   285 294       75   521 130   579
1713807 MN Brown 8 school 2723490 88 Independent Districts and Schools New Ulm Public School District 272349001150 20 Jefferson Elementary Elementary School (Grades PK-6) Regular School No Elementary 01 04 2021   grade_1 122 1 16   0 0     0   2   83 58     0.0   0.0     42.0   23.0   141 122 1 16   0 0     0   2   83 58     0 0   42 23   141
1713808 MN Brown 8 school 2723490 88 Independent Districts and Schools New Ulm Public School District 272349001150 20 Jefferson Elementary Elementary School (Grades PK-6) Regular School No Elementary 01 04 2021   grade_2 142 1 10   0 0     0   3   83 73     3.0   0.0     51.0   22.0   156 142 1 10   0 0     0   3   83 73     3 0   51 22   156
1713809 MN Brown 8 school 2723490 88 Independent Districts and Schools New Ulm Public School District 272349001150 20 Jefferson Elementary Elementary School (Grades PK-6) Regular School No Elementary 01 04 2021   grade_3 143 2 6   0 1     0   2   84 70     3.0   1.0     43.0   32.0   154 143 2 6   0 1     0   2   84 70     3 1   43 32   154
1713810 MN Brown 8 school 2723490 88 Independent Districts and Schools New Ulm Public School District 272349001150 20 Jefferson Elementary Elementary School (Grades PK-6) Regular School No Elementary 01 04 2021   grade_4 132 1 11   0 1     0   6   66 85     3.0   0.0     52.0   31.0   151 132 1 11   0 1     0   6   66 85     3 0   52 31   151
1713811 MN Brown 8 school 2723490 88 Independent Districts and Schools New Ulm Public School District 272349001150 20 Jefferson Elementary Elementary School (Grades PK-6) Regular School No Elementary 01 04 2021   pk_12_total 539 5 43   0 2     0   13   316 286     9.0   1.0     188.0   108.0   602 539 5 43   0 2     0   13   316 286     9 1   188 108   602
1714009 MN Chippewa 12 school 2721320 129 Independent Districts and Schools Montevideo Public School District 272132001073 10 Ramsey Elementary Elementary School (Grades PK-6) Regular School No Elementary 01 03 2021   grade_1 67 0 24   1 0     0   3   48 47     18.0   1.0     42.0   16.0   95 67 0 24   1 0     0   3   48 47     18 1   42 16   95
1714010 MN Chippewa 12 school 2721320 129 Independent Districts and Schools Montevideo Public School District 272132001073 10 Ramsey Elementary Elementary School (Grades PK-6) Regular School No Elementary 01 03 2021   grade_2 70 1 14   1 0     0   3   41 48     11.0   1.0     40.0   22.0   89 70 1 14   1 0     0   3   41 48     11 1   40 22   89
1714011 MN Chippewa 12 school 2721320 129 Independent Districts and Schools Montevideo Public School District 272132001073 10 Ramsey Elementary Elementary School (Grades PK-6) Regular School No Elementary 01 03 2021   grade_3 70 2 19   3 0     1   5   49 51     14.0   0.0     47.0   22.0   100 70 2 19   3 0     1   5   49 51     14 0   47 22   100
1714012 MN Chippewa 12 school 2721320 129 Independent Districts and Schools Montevideo Public School District 272132001073 10 Ramsey Elementary Elementary School (Grades PK-6) Regular School No Elementary 01 03 2021   pk_12_total 207 3 57   5 0     1   11   138 146     43.0   2.0     129.0   60.0   284 207 3 57   5 0     1   11   138 146     43 2   129 60   284
1714018 MN Chisago 13 school 2723820 138 Independent Districts and Schools North Branch Public Schools 272382003514 45 Sunrise River Elementary Elementary School (Grades PK-6) Regular School No Elementary 01 05 2021   grade_1 119 1 7   1 5     0   8   71 70     5.0   0.0     33.0   18.0   141 119 1 7   1 5     0   8   71 70     5 0   33 18   141
1714019 MN Chisago 13 school 2723820 138 Independent Districts and Schools North Branch Public Schools 272382003514 45 Sunrise River Elementary Elementary School (Grades PK-6) Regular School No Elementary 01 05 2021   grade_2 123 0 5   0 5     0   11   80 64     4.0   0.0     24.0   21.0   144 123 0 5   0 5     0   11   80 64     4 0   24 21   144
1714020 MN Chisago 13 school 2723820 138 Independent Districts and Schools North Branch Public Schools 272382003514 45 Sunrise River Elementary Elementary School (Grades PK-6) Regular School No Elementary 01 05 2021   grade_3 120 2 9   1 4     0   3   74 65     7.0   0.0     43.0   20.0   139 120 2 9   1 4     0   3   74 65     7 0   43 20   139
1714021 MN Chisago 13 school 2723820 138 Independent Districts and Schools North Branch Public Schools 272382003514 45 Sunrise River Elementary Elementary School (Grades PK-6) Regular School No Elementary 01 05 2021   grade_4 136 4 4   1 5     0   2   77 75     4.0   0.0     29.0   22.0   152 136 4 4   1 5     0   2   77 75     4 0   29 22   152
1714022 MN Chisago 13 school 2723820 138 Independent Districts and Schools North Branch Public Schools 272382003514 45 Sunrise River Elementary Elementary School (Grades PK-6) Regular School No Elementary 01 05 2021   grade_5 127 2 9   1 5     0   10   89 65     6.0   0.0     29.0   27.0   154 127 2 9   1 5     0   10   89 65     6 0   29 27   154
1714023 MN Chisago 13 school 2723820 138 Independent Districts and Schools North Branch Public Schools 272382003514 45 Sunrise River Elementary Elementary School (Grades PK-6) Regular School No Elementary 01 05 2021   pk_12_total 625 9 34   4 24     0   34   391 339     26.0   0.0     158.0   108.0   730 625 9 34   4 24     0   34   391 339     26 0   158 108   730
1715986 MN Mower 50 school 2703450 492 Independent Districts and Schools Austin Public School District 270345000149 10 Banfield Elementary Elementary School (Grades PK-6) Regular School No Elementary 01 04 2021   grade_1 70 21 23   0 14     2   4   68 66     40.0   0.0     65.0   13.0   134 70 21 23   0 14     2   4   68 66     40 0   65 13   134
1715987 MN Mower 50 school 2703450 492 Independent Districts and Schools Austin Public School District 270345000149 10 Banfield Elementary Elementary School (Grades PK-6) Regular School No Elementary 01 04 2021   grade_2 55 7 18   0 9     1   1   42 49     22.0   0.0     42.0   18.0   91 55 7 18   0 9     1   1   42 49     22 0   42 18   91
1715988 MN Mower 50 school 2703450 492 Independent Districts and Schools Austin Public School District 270345000149 10 Banfield Elementary Elementary School (Grades PK-6) Regular School No Elementary 01 04 2021   grade_3 59 10 26   0 8     1   5   63 46     25.0   0.0     41.0   28.0   109 59 10 26   0 8     1   5   63 46     25 0   41 28   109
1715989 MN Mower 50 school 2703450 492 Independent Districts and Schools Austin Public School District 270345000149 10 Banfield Elementary Elementary School (Grades PK-6) Regular School No Elementary 01 04 2021   grade_4 61 15 18   0 6     1   0   62 39     19.0   0.0     51.0   25.0   101 61 15 18   0 6     1   0   62 39     19 0   51 25   101
1715990 MN Mower 50 school 2703450 492 Independent Districts and Schools Austin Public School District 270345000149 10 Banfield Elementary Elementary School (Grades PK-6) Regular School No Elementary 01 04 2021   pk_12_total 245 53 85   0 37     5   10   235 200     106.0   0.0     199.0   84.0   435 245 53 85   0 37     5   10   235 200     106 0   199 84   435
1715991 MN Mower 50 school 2703450 492 Independent Districts and Schools Austin Public School District 270345000153 40 Neveln Elementary Elementary School (Grades PK-6) Regular School No Elementary 01 04 2021   grade_1 32 2 25   0 8     3   4   32 42     24.0   0.0     40.0   8.0   74 32 2 25   0 8     3   4   32 42     24 0   40 8   74
1715992 MN Mower 50 school 2703450 492 Independent Districts and Schools Austin Public School District 270345000153 40 Neveln Elementary Elementary School (Grades PK-6) Regular School No Elementary 01 04 2021   grade_2 37 4 11   0 9     1   4   36 30     16.0   0.0     38.0   18.0   66 37 4 11   0 9     1   4   36 30     16 0   38 18   66
1715993 MN Mower 50 school 2703450 492 Independent Districts and Schools Austin Public School District 270345000153 40 Neveln Elementary Elementary School (Grades PK-6) Regular School No Elementary 01 04 2021   grade_3 33 4 30   0 7     3   2   36 43     29.0   0.0     42.0   17.0   79 33 4 30   0 7     3   2   36 43     29 0   42 17   79
1715994 MN Mower 50 school 2703450 492 Independent Districts and Schools Austin Public School District 270345000153 40 Neveln Elementary Elementary School (Grades PK-6) Regular School No Elementary 01 04 2021   grade_4 33 5 17   0 6     3   2   26 40     18.0   0.0     36.0   11.0   66 33 5 17   0 6     3   2   26 40     18 0   36 11   66
1715995 MN Mower 50 school 2703450 492 Independent Districts and Schools Austin Public School District 270345000153 40 Neveln Elementary Elementary School (Grades PK-6) Regular School No Elementary 01 04 2021   pk_12_total 135 15 83   0 30     10   12   130 155     87.0   0.0     156.0   54.0   285 135 15 83   0 30     10   12   130 155     87 0   156 54   285
1715996 MN Mower 50 school 2703450 492 Independent Districts and Schools Austin Public School District 270345002230 70 Southgate Elementary Elementary School (Grades PK-6) Regular School No Elementary 01 04 2021   grade_1 73 5 34   0 14     2   2   62 68     37.0   0.0     69.0   26.0   130 73 5 34   0 14     2   2   62 68     37 0   69 26   130
1715997 MN Mower 50 school 2703450 492 Independent Districts and Schools Austin Public School District 270345002230 70 Southgate Elementary Elementary School (Grades PK-6) Regular School No Elementary 01 04 2021   grade_2 66 6 44   0 15     1   2   74 60     37.0   2.0     78.0   34.0   134 66 6 44   0 15     1   2   74 60     37 2   78 34   134
1715998 MN Mower 50 school 2703450 492 Independent Districts and Schools Austin Public School District 270345002230 70 Southgate Elementary Elementary School (Grades PK-6) Regular School No Elementary 01 04 2021   grade_3 73 7 21   0 18     3   3   60 65     26.0   2.0     56.0   23.0   125 73 7 21   0 18     3   3   60 65     26 2   56 23   125
1715999 MN Mower 50 school 2703450 492 Independent Districts and Schools Austin Public School District 270345002230 70 Southgate Elementary Elementary School (Grades PK-6) Regular School No Elementary 01 04 2021   grade_4 56 11 42   0 8     2   8   57 70     24.0   2.0     57.0   22.0   127 56 11 42   0 8     2   8   57 70     24 2   57 22   127
1716000 MN Mower 50 school 2703450 492 Independent Districts and Schools Austin Public School District 270345002230 70 Southgate Elementary Elementary School (Grades PK-6) Regular School No Elementary 01 04 2021   pk_12_total 268 29 141   0 55     8   15   253 263     124.0   6.0     260.0   105.0   516 268 29 141   0 55     8   15   253 263     124 6   260 105   516
1716001 MN Mower 50 school 2703450 492 Independent Districts and Schools Austin Public School District 270345000156 80 Sumner Elementary Elementary School (Grades PK-6) Regular School No Elementary 01 04 2021   grade_1 8 13 23   0 9     2   4   27 32     38.0   1.0     46.0   7.0   59 8 13 23   0 9     2   4   27 32     38 1   46 7   59
1716002 MN Mower 50 school 2703450 492 Independent Districts and Schools Austin Public School District 270345000156 80 Sumner Elementary Elementary School (Grades PK-6) Regular School No Elementary 01 04 2021   grade_2 2 15 17   0 9     3   0   21 25     30.0   1.0     38.0   6.0   46 2 15 17   0 9     3   0   21 25     30 1   38 6   46
1716003 MN Mower 50 school 2703450 492 Independent Districts and Schools Austin Public School District 270345000156 80 Sumner Elementary Elementary School (Grades PK-6) Regular School No Elementary 01 04 2021   grade_3 8 9 25   0 19     2   2   43 22     40.0   2.0     51.0   16.0   65 8 9 25   0 19     2   2   43 22     40 2   51 16   65
1716004 MN Mower 50 school 2703450 492 Independent Districts and Schools Austin Public School District 270345000156 80 Sumner Elementary Elementary School (Grades PK-6) Regular School No Elementary 01 04 2021   grade_4 7 15 31   0 16     4   2   37 38     43.0   0.0     54.0   18.0   75 7 15 31   0 16     4   2   37 38     43 0   54 18   75
1716005 MN Mower 50 school 2703450 492 Independent Districts and Schools Austin Public School District 270345000156 80 Sumner Elementary Elementary School (Grades PK-6) Regular School No Elementary 01 04 2021   pk_12_total 25 52 96   0 53     11   8   128 117     151.0   4.0     189.0   47.0   245 25 52 96   0 53     11   8   128 117     151 4   189 47   245
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
1716369 MN Polk 60 school 2709720 593 Independent Districts and Schools Crookston Public School District 270972000414 80 Highland Elementary Elementary School (Grades PK-6) Regular School No Elementary 01 06 2021   grade_1 45 1 22   2 0     0   2   37 35     10.0   0.0     41.0   9.0   72 45 1 22   2 0     0   2   37 35     10 0   41 9   72
1716370 MN Polk 60 school 2709720 593 Independent Districts and Schools Crookston Public School District 270972000414 80 Highland Elementary Elementary School (Grades PK-6) Regular School No Elementary 01 06 2021   grade_2 35 2 19   5 1     0   3   39 26     4.0   6.0     40.0   16.0   65 35 2 19   5 1     0   3   39 26     4 6   40 16   65
1716371 MN Polk 60 school 2709720 593 Independent Districts and Schools Crookston Public School District 270972000414 80 Highland Elementary Elementary School (Grades PK-6) Regular School No Elementary 01 06 2021   grade_3 55 2 22   6 0     1   5   40 51     5.0   6.0     50.0   17.0   91 55 2 22   6 0     1   5   40 51     5 6   50 17   91
1716372 MN Polk 60 school 2709720 593 Independent Districts and Schools Crookston Public School District 270972000414 80 Highland Elementary Elementary School (Grades PK-6) Regular School No Elementary 01 06 2021   grade_4 48 1 12   5 1     0   1   35 33     2.0   6.0     33.0   15.0   68 48 1 12   5 1     0   1   35 33     2 6   33 15   68
1716373 MN Polk 60 school 2709720 593 Independent Districts and Schools Crookston Public School District 270972000414 80 Highland Elementary Elementary School (Grades PK-6) Regular School No Elementary 01 06 2021   grade_5 53 2 22   6 0     0   2   43 42     1.0   4.0     44.0   22.0   85 53 2 22   6 0     0   2   43 42     1 4   44 22   85
1716374 MN Polk 60 school 2709720 593 Independent Districts and Schools Crookston Public School District 270972000414 80 Highland Elementary Elementary School (Grades PK-6) Regular School No Elementary 01 06 2021   grade_6 52 1 26   4 0     0   5   37 51     1.0   3.0     45.0   19.0   88 52 1 26   4 0     0   5   37 51     1 3   45 19   88
1716375 MN Polk 60 school 2709720 593 Independent Districts and Schools Crookston Public School District 270972000414 80 Highland Elementary Elementary School (Grades PK-6) Regular School No Elementary 01 06 2021   pk_12_total 288 9 123   28 2     1   18   231 238     23.0   25.0     253.0   98.0   469 288 9 123   28 2     1   18   231 238     23 25   253 98   469
1716417 MN Ramsey 62 school 2722950 621 Independent Districts and Schools Mounds View Public School District 272295001114 25 Bel Air Elementary Elementary School (Grades PK-6) Regular School No Elementary 01 05 2021   grade_1 76 17 18   0 11     0   13   66 69     24.0   0.0     50.0   15.0   135 76 17 18   0 11     0   13   66 69     24 0   50 15   135
1716418 MN Ramsey 62 school 2722950 621 Independent Districts and Schools Mounds View Public School District 272295001114 25 Bel Air Elementary Elementary School (Grades PK-6) Regular School No Elementary 01 05 2021   grade_2 91 18 11   0 12     0   13   71 74     14.0   0.0     47.0   11.0   145 91 18 11   0 12     0   13   71 74     14 0   47 11   145
1716419 MN Ramsey 62 school 2722950 621 Independent Districts and Schools Mounds View Public School District 272295001114 25 Bel Air Elementary Elementary School (Grades PK-6) Regular School No Elementary 01 05 2021   grade_3 93 25 12   2 13     0   10   75 80     19.0   *     43.0   16.0   155 93 25 12   2 13     0   10   75 80     19     43 16   155
1716420 MN Ramsey 62 school 2722950 621 Independent Districts and Schools Mounds View Public School District 272295001114 25 Bel Air Elementary Elementary School (Grades PK-6) Regular School No Elementary 01 05 2021   grade_4 85 20 14   1 7     0   14   73 68     19.0   *     48.0   11.0   141 85 20 14   1 7     0   14   73 68     19     48 11   141
1716421 MN Ramsey 62 school 2722950 621 Independent Districts and Schools Mounds View Public School District 272295001114 25 Bel Air Elementary Elementary School (Grades PK-6) Regular School No Elementary 01 05 2021   grade_5 91 32 18   0 5     0   10   90 66     18.0   2.0     53.0   15.0   156 91 32 18   0 5     0   10   90 66     18 2   53 15   156
1716422 MN Ramsey 62 school 2722950 621 Independent Districts and Schools Mounds View Public School District 272295001114 25 Bel Air Elementary Elementary School (Grades PK-6) Regular School No Elementary 01 05 2021   pk_12_total 436 112 73   3 48     0   60   375 357     94.0   5.0     241.0   68.0   732 436 112 73   3 48     0   60   375 357     94 5   241 68   732
1716423 MN Ramsey 62 school 2722950 621 Independent Districts and Schools Mounds View Public School District 272295001119 26 Island Lake Elementary Elementary School (Grades PK-6) Regular School No Elementary 01 05 2021   grade_1 87 9 5   0 22     0   11   63 71     *   0.0     *   15.0   134 87 9 5   0 22     0   11   63 71       0     15   134
1716424 MN Ramsey 62 school 2722950 621 Independent Districts and Schools Mounds View Public School District 272295001119 26 Island Lake Elementary Elementary School (Grades PK-6) Regular School No Elementary 01 05 2021   grade_2 95 13 9   0 22     0   16   87 68     13.0   *     *   15.0   155 95 13 9   0 22     0   16   87 68     13       15   155
1716425 MN Ramsey 62 school 2722950 621 Independent Districts and Schools Mounds View Public School District 272295001119 26 Island Lake Elementary Elementary School (Grades PK-6) Regular School No Elementary 01 05 2021   grade_3 102 5 8   0 22     0   10   88 59     8.0   0.0     *   15.0   147 102 5 8   0 22     0   10   88 59     8 0     15   147
1716426 MN Ramsey 62 school 2722950 621 Independent Districts and Schools Mounds View Public School District 272295001119 26 Island Lake Elementary Elementary School (Grades PK-6) Regular School No Elementary 01 05 2021   grade_4 98 10 6   0 29     0   11   86 68     8.0   0.0     25.0   14.0   154 98 10 6   0 29     0   11   86 68     8 0   25 14   154
1716427 MN Ramsey 62 school 2722950 621 Independent Districts and Schools Mounds View Public School District 272295001119 26 Island Lake Elementary Elementary School (Grades PK-6) Regular School No Elementary 01 05 2021   grade_5 90 8 8   0 20     0   6   69 63     *   0.0     *   13.0   132 90 8 8   0 20     0   6   69 63       0     13   132
1716428 MN Ramsey 62 school 2722950 621 Independent Districts and Schools Mounds View Public School District 272295001119 26 Island Lake Elementary Elementary School (Grades PK-6) Regular School No Elementary 01 05 2021   pk_12_total 472 45 36   0 115     0   54   393 329     38.0   *     91.0   72.0   722 472 45 36   0 115     0   54   393 329     38     91 72   722
1716429 MN Ramsey 62 school 2722950 621 Independent Districts and Schools Mounds View Public School District 272295001124 30 Pinewood Elementary Elementary School (Grades PK-6) Regular School No Elementary 01 05 2021   grade_1 49 14 16   2 18     0   6   61 44     23.0   *     50.0   17.0   105 49 14 16   2 18     0   6   61 44     23     50 17   105
1716430 MN Ramsey 62 school 2722950 621 Independent Districts and Schools Mounds View Public School District 272295001124 30 Pinewood Elementary Elementary School (Grades PK-6) Regular School No Elementary 01 05 2021   grade_2 60 17 8   1 13     1   17   66 51     21.0   *     58.0   18.0   117 60 17 8   1 13     1   17   66 51     21     58 18   117
1716431 MN Ramsey 62 school 2722950 621 Independent Districts and Schools Mounds View Public School District 272295001124 30 Pinewood Elementary Elementary School (Grades PK-6) Regular School No Elementary 01 05 2021   grade_3 46 9 15   1 12     0   7   38 52     14.0   0.0     43.0   15.0   90 46 9 15   1 12     0   7   38 52     14 0   43 15   90
1716432 MN Ramsey 62 school 2722950 621 Independent Districts and Schools Mounds View Public School District 272295001124 30 Pinewood Elementary Elementary School (Grades PK-6) Regular School No Elementary 01 05 2021   grade_4 53 18 13   0 11     0   11   47 59     16.0   0.0     51.0   15.0   106 53 18 13   0 11     0   11   47 59     16 0   51 15   106
1716433 MN Ramsey 62 school 2722950 621 Independent Districts and Schools Mounds View Public School District 272295001124 30 Pinewood Elementary Elementary School (Grades PK-6) Regular School No Elementary 01 05 2021   grade_5 43 12 13   0 22     1   13   55 49     18.0   2.0     56.0   10.0   104 43 12 13   0 22     1   13   55 49     18 2   56 10   104
1716434 MN Ramsey 62 school 2722950 621 Independent Districts and Schools Mounds View Public School District 272295001124 30 Pinewood Elementary Elementary School (Grades PK-6) Regular School No Elementary 01 05 2021   pk_12_total 251 70 65   4 76     2   54   267 255     92.0   4.0     258.0   75.0   522 251 70 65   4 76     2   54   267 255     92 4   258 75   522
1716435 MN Ramsey 62 school 2722950 621 Independent Districts and Schools Mounds View Public School District 272295001128 34 Sunnyside Elementary Elementary School (Grades PK-6) Regular School No Elementary 01 05 2021   grade_1 45 8 20   0 4     0   5   47 35     12.0   1.0     32.0   15.0   82 45 8 20   0 4     0   5   47 35     12 1   32 15   82
1716436 MN Ramsey 62 school 2722950 621 Independent Districts and Schools Mounds View Public School District 272295001128 34 Sunnyside Elementary Elementary School (Grades PK-6) Regular School No Elementary 01 05 2021   grade_2 61 18 12   0 14     0   11   48 68     9.0   2.0     60.0   19.0   116 61 18 12   0 14     0   11   48 68     9 2   60 19   116
1716437 MN Ramsey 62 school 2722950 621 Independent Districts and Schools Mounds View Public School District 272295001128 34 Sunnyside Elementary Elementary School (Grades PK-6) Regular School No Elementary 01 05 2021   grade_3 55 9 17   0 8     0   9   57 41     18.0   *     34.0   16.0   98 55 9 17   0 8     0   9   57 41     18     34 16   98
1716438 MN Ramsey 62 school 2722950 621 Independent Districts and Schools Mounds View Public School District 272295001128 34 Sunnyside Elementary Elementary School (Grades PK-6) Regular School No Elementary 01 05 2021   grade_4 58 9 11   0 11     0   10   60 39     13.0   0.0     41.0   17.0   99 58 9 11   0 11     0   10   60 39     13 0   41 17   99
1716439 MN Ramsey 62 school 2722950 621 Independent Districts and Schools Mounds View Public School District 272295001128 34 Sunnyside Elementary Elementary School (Grades PK-6) Regular School No Elementary 01 05 2021   grade_5 68 22 18   0 8     0   11   66 61     14.0   *     56.0   19.0   127 68 22 18   0 8     0   11   66 61     14     56 19   127
1716440 MN Ramsey 62 school 2722950 621 Independent Districts and Schools Mounds View Public School District 272295001128 34 Sunnyside Elementary Elementary School (Grades PK-6) Regular School No Elementary 01 05 2021   pk_12_total 287 66 78   0 45     0   46   278 244     66.0   5.0     223.0   86.0   522 287 66 78   0 45     0   46   278 244     66 5   223 86   522
1716441 MN Ramsey 62 school 2722950 621 Independent Districts and Schools Mounds View Public School District 272295001129 35 Turtle Lake Elementary Elementary School (Grades PK-6) Regular School No Elementary 01 05 2021   grade_1 144 7 8   0 22     0   13   104 90     14.0   1.0     *   25.0   194 144 7 8   0 22     0   13   104 90     14 1     25   194
1716442 MN Ramsey 62 school 2722950 621 Independent Districts and Schools Mounds View Public School District 272295001129 35 Turtle Lake Elementary Elementary School (Grades PK-6) Regular School No Elementary 01 05 2021   grade_2 147 4 10   0 19     0   17   100 97     *   0.0     21.0   16.0   197 147 4 10   0 19     0   17   100 97       0   21 16   197
1716443 MN Ramsey 62 school 2722950 621 Independent Districts and Schools Mounds View Public School District 272295001129 35 Turtle Lake Elementary Elementary School (Grades PK-6) Regular School No Elementary 01 05 2021   grade_3 139 7 4   0 35     0   17   106 96     *   0.0     18.0   25.0   202 139 7 4   0 35     0   17   106 96       0   18 25   202
1716444 MN Ramsey 62 school 2722950 621 Independent Districts and Schools Mounds View Public School District 272295001129 35 Turtle Lake Elementary Elementary School (Grades PK-6) Regular School No Elementary 01 05 2021   grade_4 158 3 12   0 32     0   11   117 99     *   0.0     *   19.0   216 158 3 12   0 32     0   11   117 99       0     19   216
1716445 MN Ramsey 62 school 2722950 621 Independent Districts and Schools Mounds View Public School District 272295001129 35 Turtle Lake Elementary Elementary School (Grades PK-6) Regular School No Elementary 01 05 2021   grade_5 142 3 5   0 35     0   15   113 87     6.0   0.0     22.0   18.0   200 142 3 5   0 35     0   15   113 87     6 0   22 18   200
1716446 MN Ramsey 62 school 2722950 621 Independent Districts and Schools Mounds View Public School District 272295001129 35 Turtle Lake Elementary Elementary School (Grades PK-6) Regular School No Elementary 01 05 2021   pk_12_total 730 24 39   0 143     0   73   540 469     37.0   1.0     97.0   103.0   1009 730 24 39   0 143     0   73   540 469     37 1   97 103   1009
1716447 MN Ramsey 62 school 2722950 621 Independent Districts and Schools Mounds View Public School District 272295001130 36 Valentine Hills Elementary Elementary School (Grades PK-6) Regular School No Elementary 01 05 2021   grade_1 96 25 18   0 9     0   9   71 86     17.0   0.0     49.0   15.0   157 96 25 18   0 9     0   9   71 86     17 0   49 15   157
1716448 MN Ramsey 62 school 2722950 621 Independent Districts and Schools Mounds View Public School District 272295001130 36 Valentine Hills Elementary Elementary School (Grades PK-6) Regular School No Elementary 01 05 2021   grade_2 67 24 24   1 10     0   10   71 65     28.0   0.0     58.0   16.0   136 67 24 24   1 10     0   10   71 65     28 0   58 16   136
1716449 MN Ramsey 62 school 2722950 621 Independent Districts and Schools Mounds View Public School District 272295001130 36 Valentine Hills Elementary Elementary School (Grades PK-6) Regular School No Elementary 01 05 2021   grade_3 90 16 18   0 7     0   9   69 71     10.0   0.0     50.0   12.0   140 90 16 18   0 7     0   9   69 71     10 0   50 12   140
1716450 MN Ramsey 62 school 2722950 621 Independent Districts and Schools Mounds View Public School District 272295001130 36 Valentine Hills Elementary Elementary School (Grades PK-6) Regular School No Elementary 01 05 2021   grade_4 68 21 13   1 5     0   13   66 55     10.0   0.0     41.0   14.0   121 68 21 13   1 5     0   13   66 55     10 0   41 14   121
1716451 MN Ramsey 62 school 2722950 621 Independent Districts and Schools Mounds View Public School District 272295001130 36 Valentine Hills Elementary Elementary School (Grades PK-6) Regular School No Elementary 01 05 2021   grade_5 74 27 16   0 8     0   11   69 67     11.0   1.0     56.0   14.0   136 74 27 16   0 8     0   11   69 67     11 1   56 14   136
1716452 MN Ramsey 62 school 2722950 621 Independent Districts and Schools Mounds View Public School District 272295001130 36 Valentine Hills Elementary Elementary School (Grades PK-6) Regular School No Elementary 01 05 2021   pk_12_total 395 113 89   2 39     0   52   346 344     76.0   1.0     254.0   71.0   690 395 113 89   2 39     0   52   346 344     76 1   254 71   690
1716864 MN Ramsey 62 school 2733840 625 Independent Districts and Schools St. Paul Public School District 273384001594 494 Capitol Hill Magnet/Rondo Elementary School (Grades PK-6) Regular School No Elementary 01 08 2021   grade_1 46 12 2   0 15     0   11   41 45     8.0   0.0     30.0   6.0   86 46 12 2   0 15     0   11   41 45     8 0   30 6   86
1716865 MN Ramsey 62 school 2733840 625 Independent Districts and Schools St. Paul Public School District 273384001594 494 Capitol Hill Magnet/Rondo Elementary School (Grades PK-6) Regular School No Elementary 01 08 2021   grade_2 49 17 6   0 27     0   11   57 53     14.0   0.0     37.0   4.0   110 49 17 6   0 27     0   11   57 53     14 0   37 4   110
1716866 MN Ramsey 62 school 2733840 625 Independent Districts and Schools St. Paul Public School District 273384001594 494 Capitol Hill Magnet/Rondo Elementary School (Grades PK-6) Regular School No Elementary 01 08 2021   grade_3 48 24 10   0 33     0   20   69 66     25.0   0.0     50.0   7.0   135 48 24 10   0 33     0   20   69 66     25 0   50 7   135
1716867 MN Ramsey 62 school 2733840 625 Independent Districts and Schools St. Paul Public School District 273384001594 494 Capitol Hill Magnet/Rondo Elementary School (Grades PK-6) Regular School No Elementary 01 08 2021   grade_4 57 33 5   0 31     0   16   79 63     16.0   0.0     65.0   8.0   142 57 33 5   0 31     0   16   79 63     16 0   65 8   142
1716868 MN Ramsey 62 school 2733840 625 Independent Districts and Schools St. Paul Public School District 273384001594 494 Capitol Hill Magnet/Rondo Elementary School (Grades PK-6) Regular School No Elementary 01 08 2021   grade_5 62 32 9   0 30     0   14   76 71     12.0   0.0     46.0   10.0   147 62 32 9   0 30     0   14   76 71     12 0   46 10   147
1716869 MN Ramsey 62 school 2733840 625 Independent Districts and Schools St. Paul Public School District 273384001594 494 Capitol Hill Magnet/Rondo Elementary School (Grades PK-6) Regular School No Elementary 01 08 2021   grade_6 62 45 13   0 45     0   23   97 91     6.0   0.0     97.0   13.0   188 62 45 13   0 45     0   23   97 91     6 0   97 13   188

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