Data source: Big Local News · About: Big Local

14,034 rows where state = "MN" and year = 2020 sorted by ccd_school_low_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
1827114 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 2020   grade_2 0.0 0.0 1.0   0.0 0.0     0.0   1.0   1.0 1.0     *   *         *   2.0 0 0 1   0 0     0   1   1 1                 2
1827115 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 2020   grade_3 1.0 0.0 0.0   0.0 0.0     0.0   1.0   1.0 1.0     *   *         *   2.0 1 0 0   0 0     0   1   1 1                 2
1827116 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 2020   grade_4 8.0 1.0 1.0   0.0 1.0     0.0   1.0   10.0 2.0     0.0   0.0     2.0   1.0   12.0 8 1 1   0 1     0   1   10 2     0 0   2 1   12
1827117 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 2020   grade_5 9.0 0.0 0.0   0.0 1.0     0.0   2.0   8.0 4.0     0.0   0.0     0.0   2.0   12.0 9 0 0   0 1     0   2   8 4     0 0   0 2   12
1827118 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 2020   grade_6 10.0 1.0 0.0   0.0 0.0     0.0   0.0   6.0 5.0     0.0   *     0.0   0.0   11.0 10 1 0   0 0     0   0   6 5     0     0 0   11
1827119 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 2020   pk_12_total 28.0 2.0 2.0   0.0 2.0     0.0   5.0   26.0 13.0     0.0   0.0     2.0   3.0   39.0 28 2 2   0 2     0   5   26 13     0 0   2 3   39
1827211 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 2020   grade_1 0.0 0.0 0.0   112.0 0.0     0.0   0.0   54.0 58.0     *   5.0         23.0   112.0 0 0 0   112 0     0   0   54 58       5     23   112
1827212 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 2020   grade_2 0.0 0.0 0.0   127.0 0.0     0.0   0.0   72.0 55.0     0.0   15.0     104.0   34.0   127.0 0 0 0   127 0     0   0   72 55     0 15   104 34   127
1827213 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 2020   grade_3 0.0 0.0 0.0   118.0 0.0     0.0   0.0   60.0 58.0     0.0   18.0         25.0   118.0 0 0 0   118 0     0   0   60 58     0 18     25   118
1827214 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 2020   grade_4 0.0 0.0 0.0   120.0 0.0     0.0   1.0   55.0 66.0     0.0   29.0         24.0   121.0 0 0 0   120 0     0   1   55 66     0 29     24   121
1827215 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 2020   grade_5 0.0 0.0 0.0   110.0 0.0     0.0   0.0   64.0 46.0     0.0   22.0     83.0   23.0   110.0 0 0 0   110 0     0   0   64 46     0 22   83 23   110
1827216 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 2020   pk_12_total 0.0 0.0 0.0   587.0 0.0     0.0   1.0   305.0 283.0     *   89.0     466.0   129.0   588.0 0 0 0   587 0     0   1   305 283       89   466 129   588
1827376 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 2020   grade_1 140.0 1.0 8.0   0.0 0.0     0.0   6.0   85.0 70.0     2.0   1.0     50.0   25.0   155.0 140 1 8   0 0     0   6   85 70     2 1   50 25   155
1827377 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 2020   grade_2 142.0 2.0 5.0   0.0 1.0     0.0   4.0   79.0 75.0     3.0   0.0     52.0   28.0   154.0 142 2 5   0 1     0   4   79 75     3 0   52 28   154
1827378 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 2020   grade_3 133.0 1.0 8.0   0.0 1.0     0.0   6.0   69.0 80.0     1.0   1.0     59.0   37.0   149.0 133 1 8   0 1     0   6   69 80     1 1   59 37   149
1827379 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 2020   grade_4 130.0 1.0 6.0   0.0 0.0     0.0   3.0   74.0 66.0     1.0   1.0     36.0   31.0   140.0 130 1 6   0 0     0   3   74 66     1 1   36 31   140
1827380 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 2020   pk_12_total 545.0 5.0 27.0   0.0 2.0     0.0   19.0   307.0 291.0     7.0   3.0     197.0   121.0   598.0 545 5 27   0 2     0   19   307 291     7 3   197 121   598
1827578 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 2020   grade_1 75.0 0.0 17.0   0.0 0.0     0.0   4.0   48.0 48.0     11.0   0.0     54.0   22.0   96.0 75 0 17   0 0     0   4   48 48     11 0   54 22   96
1827579 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 2020   grade_2 76.0 2.0 23.0   2.0 0.0     1.0   6.0   54.0 56.0     17.0   0.0     55.0   23.0   110.0 76 2 23   2 0     1   6   54 56     17 0   55 23   110
1827580 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 2020   grade_3 82.0 1.0 25.0   0.0 2.0     1.0   8.0   63.0 56.0     21.0   0.0     56.0   31.0   119.0 82 1 25   0 2     1   8   63 56     21 0   56 31   119
1827581 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 2020   pk_12_total 233.0 3.0 65.0   2.0 2.0     2.0   18.0   165.0 160.0     49.0   0.0     165.0   76.0   325.0 233 3 65   2 2     2   18   165 160     49 0   165 76   325
1829525 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 2020   grade_1 66.0 8.0 21.0   0.0 8.0     1.0   2.0   53.0 53.0     28.0   0.0     53.0   15.0   106.0 66 8 21   0 8     1   2   53 53     28 0   53 15   106
1829526 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 2020   grade_2 63.0 8.0 26.0   0.0 8.0     1.0   5.0   61.0 50.0     29.0   0.0         27.0   111.0 63 8 26   0 8     1   5   61 50     29 0     27   111
1829527 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 2020   grade_3 63.0 12.0 19.0   0.0 6.0     1.0   2.0   60.0 43.0     21.0   0.0     58.0   26.0   103.0 63 12 19   0 6     1   2   60 43     21 0   58 26   103
1829528 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 2020   grade_4 61.0 11.0 18.0   0.0 8.0     0.0   4.0   43.0 59.0     19.0   0.0         19.0   102.0 61 11 18   0 8     0   4   43 59     19 0     19   102
1829529 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 2020   pk_12_total 253.0 39.0 84.0   0.0 30.0     3.0   13.0   217.0 205.0     97.0   0.0     208.0   87.0   422.0 253 39 84   0 30     3   13   217 205     97 0   208 87   422
1829530 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 2020   grade_1 37.0 3.0 11.0   0.0 6.0     0.0   3.0   32.0 28.0     *   *         15.0   60.0 37 3 11   0 6     0   3   32 28             15   60
1829531 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 2020   grade_2 38.0 4.0 33.0   0.0 7.0     0.0   2.0   43.0 41.0     *   *     52.0   *   84.0 38 4 33   0 7     0   2   43 41           52     84
1829532 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 2020   grade_3 34.0 5.0 18.0   0.0 6.0     1.0   4.0   26.0 42.0     *   0.0         *   68.0 34 5 18   0 6     1   4   26 42       0         68
1829533 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 2020   grade_4 45.0 3.0 25.0   0.0 5.0     3.0   0.0   34.0 47.0     *   0.0         *   81.0 45 3 25   0 5     3   0   34 47       0         81
1829534 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 2020   pk_12_total 154.0 15.0 87.0   0.0 24.0     4.0   9.0   135.0 158.0     74.0   3.0     170.0   45.0   293.0 154 15 87   0 24     4   9   135 158     74 3   170 45   293
1829535 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 2020   grade_1 70.0 9.0 49.0   0.0 13.0     2.0   2.0   77.0 68.0     38.0   2.0     93.0   34.0   145.0 70 9 49   0 13     2   2   77 68     38 2   93 34   145
1829536 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 2020   grade_2 74.0 7.0 23.0   0.0 18.0     4.0   3.0   66.0 63.0     29.0   2.0     66.0   23.0   129.0 74 7 23   0 18     4   3   66 63     29 2   66 23   129
1829537 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 2020   grade_3 53.0 13.0 44.0   0.0 10.0     2.0   6.0   57.0 71.0     29.0   *     75.0   19.0   128.0 53 13 44   0 10     2   6   57 71     29     75 19   128
1829538 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 2020   grade_4 66.0 10.0 41.0   0.0 3.0     2.0   8.0   65.0 65.0     30.0   *     71.0   26.0   130.0 66 10 41   0 3     2   8   65 65     30     71 26   130
1829539 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 2020   pk_12_total 263.0 39.0 157.0   0.0 44.0     10.0   19.0   265.0 267.0     126.0   7.0     305.0   102.0   532.0 263 39 157   0 44     10   19   265 267     126 7   305 102   532
1829540 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 2020   pre_kindergarten 6.0 8.0 9.0   0.0 8.0     0.0   0.0   17.0 14.0     0.0   0.0     19.0   0.0   31.0 6 8 9   0 8     0   0   17 14     0 0   19 0   31
1829541 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 2020   grade_1 3.0 11.0 19.0   0.0 11.0     5.0   0.0   27.0 22.0     33.0   *     41.0   *   49.0 3 11 19   0 11     5   0   27 22     33     41     49
1829542 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 2020   grade_2 9.0 12.0 23.0   0.0 20.0     6.0   1.0   48.0 23.0     41.0   *     56.0   15.0   71.0 9 12 23   0 20     6   1   48 23     41     56 15   71
1829543 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 2020   grade_3 8.0 16.0 31.0   0.0 16.0     4.0   2.0   37.0 40.0     45.0   2.0     63.0   16.0   77.0 8 16 31   0 16     4   2   37 40     45 2   63 16   77
1829544 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 2020   grade_4 13.0 18.0 32.0   0.0 25.0     0.0   0.0   47.0 41.0     49.0   1.0     79.0   *   88.0 13 18 32   0 25     0   0   47 41     49 1   79     88
1829545 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 2020   pk_12_total 39.0 65.0 114.0   0.0 80.0     15.0   3.0   176.0 140.0     168.0   5.0     258.0   49.0   316.0 39 65 114   0 80     15   3   176 140     168 5   258 49   316
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
1829915 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 2020   grade_1 40.0 3.0 17.0   4.0 1.0     0.0   3.0   36.0 32.0     4.0   5.0     40.0   14.0   68.0 40 3 17   4 1     0   3   36 32     4 5   40 14   68
1829916 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 2020   grade_2 57.0 2.0 21.0   3.0 0.0     0.0   6.0   39.0 50.0     6.0   4.0     49.0   10.0   89.0 57 2 21   3 0     0   6   39 50     6 4   49 10   89
1829917 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 2020   grade_3 50.0 0.0 13.0   5.0 0.0     0.0   1.0   35.0 34.0     3.0   6.0     34.0   12.0   69.0 50 0 13   5 0     0   1   35 34     3 6   34 12   69
1829918 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 2020   grade_4 58.0 2.0 20.0   7.0 0.0     0.0   3.0   48.0 42.0     2.0   2.0     57.0   26.0   90.0 58 2 20   7 0     0   3   48 42     2 2   57 26   90
1829919 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 2020   grade_5 48.0 1.0 23.0   3.0 0.0     0.0   5.0   35.0 45.0     2.0   4.0     42.0   16.0   80.0 48 1 23   3 0     0   5   35 45     2 4   42 16   80
1829920 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 2020   grade_6 61.0 0.0 19.0   12.0 0.0     0.0   3.0   54.0 41.0     3.0   3.0     52.0   21.0   95.0 61 0 19   12 0     0   3   54 41     3 3   52 21   95
1829921 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 2020   pk_12_total 314.0 8.0 113.0   34.0 1.0     0.0   21.0   247.0 244.0     20.0   24.0     274.0   99.0   491.0 314 8 113   34 1     0   21   247 244     20 24   274 99   491
1829964 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 2020   grade_1 96.0 20.0 13.0   0.0 9.0     0.0   11.0   73.0 76.0     14.0   *     51.0   12.0   149.0 96 20 13   0 9     0   11   73 76     14     51 12   149
1829965 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 2020   grade_2 101.0 26.0 11.0   2.0 13.0     0.0   6.0   78.0 81.0     21.0   3.0     45.0   13.0   159.0 101 26 11   2 13     0   6   78 81     21 3   45 13   159
1829966 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 2020   grade_3 85.0 21.0 12.0   1.0 4.0     0.0   14.0   66.0 71.0     19.0   0.0     45.0   9.0   137.0 85 21 12   1 4     0   14   66 71     19 0   45 9   137
1829967 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 2020   grade_4 91.0 30.0 17.0   0.0 8.0     0.0   7.0   89.0 64.0     20.0   *     49.0   14.0   153.0 91 30 17   0 8     0   7   89 64     20     49 14   153
1829968 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 2020   grade_5 82.0 24.0 14.0   1.0 11.0     0.0   9.0   64.0 77.0     9.0   3.0     49.0   10.0   141.0 82 24 14   1 11     0   9   64 77     9 3   49 10   141
1829969 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 2020   pk_12_total 455.0 121.0 67.0   4.0 45.0     0.0   47.0   370.0 369.0     83.0   9.0     239.0   58.0   739.0 455 121 67   4 45     0   47   370 369     83 9   239 58   739
1829970 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 2020   grade_1 107.0 12.0 8.0   0.0 22.0     0.0   14.0   92.0 71.0     11.0   1.0         17.0   163.0 107 12 8   0 22     0   14   92 71     11 1     17   163
1829971 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 2020   grade_2 110.0 7.0 8.0   0.0 24.0     0.0   10.0   95.0 64.0     *   0.0         17.0   159.0 110 7 8   0 24     0   10   95 64       0     17   159
1829972 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 2020   grade_3 102.0 9.0 5.0   0.0 33.0     0.0   13.0   90.0 72.0     11.0   0.0     26.0   16.0   162.0 102 9 5   0 33     0   13   90 72     11 0   26 16   162
1829973 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 2020   grade_4 103.0 11.0 7.0   0.0 21.0     0.0   8.0   76.0 74.0     *   0.0     25.0   14.0   150.0 103 11 7   0 21     0   8   76 74       0   25 14   150
1829974 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 2020   grade_5 105.0 10.0 8.0   2.0 22.0     0.0   9.0   82.0 74.0     *   0.0     27.0   12.0   156.0 105 10 8   2 22     0   9   82 74       0   27 12   156
1829975 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 2020   pk_12_total 527.0 49.0 36.0   2.0 122.0     0.0   54.0   435.0 355.0     45.0   1.0     111.0   76.0   790.0 527 49 36   2 122     0   54   435 355     45 1   111 76   790
1829976 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 2020   grade_1 70.0 15.0 7.0   1.0 8.0     1.0   19.0   60.0 61.0     15.0   1.0     63.0   22.0   121.0 70 15 7   1 8     1   19   60 61     15 1   63 22   121
1829977 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 2020   grade_2 51.0 10.0 16.0   2.0 10.0     0.0   8.0   41.0 56.0     12.0   *     46.0   12.0   97.0 51 10 16   2 10     0   8   41 56     12     46 12   97
1829978 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 2020   grade_3 59.0 14.0 14.0   1.0 15.0     0.0   9.0   53.0 59.0     22.0   *     57.0   14.0   112.0 59 14 14   1 15     0   9   53 59     22     57 14   112
1829979 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 2020   grade_4 46.0 14.0 16.0   1.0 21.0     1.0   10.0   59.0 50.0     18.0   3.0     57.0   14.0   109.0 46 14 16   1 21     1   10   59 50     18 3   57 14   109
1829980 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 2020   grade_5 68.0 15.0 11.0   1.0 14.0     0.0   5.0   62.0 52.0     13.0   *     61.0   18.0   114.0 68 15 11   1 14     0   5   62 52     13     61 18   114
1829981 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 2020   pk_12_total 294.0 68.0 64.0   6.0 68.0     2.0   51.0   275.0 278.0     80.0   7.0     284.0   80.0   553.0 294 68 64   6 68     2   51   275 278     80 7   284 80   553
1829982 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 2020   grade_1 60.0 16.0 12.0   0.0 15.0     0.0   10.0   48.0 65.0     11.0   1.0     54.0   20.0   113.0 60 16 12   0 15     0   10   48 65     11 1   54 20   113
1829983 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 2020   grade_2 53.0 6.0 14.0   0.0 10.0     0.0   11.0   51.0 43.0     18.0   2.0     37.0   17.0   94.0 53 6 14   0 10     0   11   51 43     18 2   37 17   94
1829984 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 2020   grade_3 61.0 9.0 8.0   0.0 11.0     0.0   11.0   62.0 38.0     11.0   1.0     37.0   18.0   100.0 61 9 8   0 11     0   11   62 38     11 1   37 18   100
1829985 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 2020   grade_4 65.0 17.0 17.0   0.0 8.0     0.0   12.0   61.0 58.0     18.0   0.0     56.0   17.0   119.0 65 17 17   0 8     0   12   61 58     18 0   56 17   119
1829986 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 2020   grade_5 61.0 9.0 13.0   0.0 11.0     1.0   9.0   49.0 55.0     7.0   2.0     41.0   8.0   104.0 61 9 13   0 11     1   9   49 55     7 2   41 8   104
1829987 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 2020   pk_12_total 300.0 57.0 64.0   0.0 55.0     1.0   53.0   271.0 259.0     65.0   6.0     225.0   80.0   530.0 300 57 64   0 55     1   53   271 259     65 6   225 80   530
1829988 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 2020   grade_1 158.0 8.0 10.0   0.0 19.0     0.0   13.0   105.0 103.0     *   0.0     24.0   18.0   208.0 158 8 10   0 19     0   13   105 103       0   24 18   208
1829989 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 2020   grade_2 151.0 6.0 5.0   0.0 35.0     0.0   17.0   115.0 99.0     11.0   0.0     18.0   22.0   214.0 151 6 5   0 35     0   17   115 99     11 0   18 22   214
1829990 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 2020   grade_3 163.0 3.0 9.0   0.0 31.0     0.0   11.0   116.0 101.0     *   0.0         18.0   217.0 163 3 9   0 31     0   11   116 101       0     18   217
1829991 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 2020   grade_4 156.0 4.0 5.0   0.0 35.0     0.0   13.0   122.0 91.0     10.0   0.0         20.0   213.0 156 4 5   0 35     0   13   122 91     10 0     20   213
1829992 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 2020   grade_5 149.0 6.0 14.0   1.0 27.0     0.0   10.0   114.0 93.0     9.0   1.0         17.0   207.0 149 6 14   1 27     0   10   114 93     9 1     17   207
1829993 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 2020   pk_12_total 777.0 27.0 43.0   1.0 147.0     0.0   64.0   572.0 487.0     42.0   1.0     114.0   95.0   1059.0 777 27 43   1 147     0   64   572 487     42 1   114 95   1059
1829994 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 2020   grade_1 68.0 22.0 22.0   1.0 9.0     0.0   9.0   69.0 62.0     22.0   1.0     57.0   16.0   131.0 68 22 22   1 9     0   9   69 62     22 1   57 16   131
1829995 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 2020   grade_2 93.0 14.0 18.0   0.0 9.0     0.0   12.0   72.0 74.0     14.0   0.0     52.0   10.0   146.0 93 14 18   0 9     0   12   72 74     14 0   52 10   146
1829996 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 2020   grade_3 76.0 23.0 16.0   1.0 4.0     0.0   12.0   72.0 60.0     14.0   0.0     57.0   12.0   132.0 76 23 16   1 4     0   12   72 60     14 0   57 12   132
1829997 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 2020   grade_4 76.0 29.0 15.0   0.0 9.0     0.0   7.0   71.0 65.0     22.0   4.0     59.0   16.0   136.0 76 29 15   0 9     0   7   71 65     22 4   59 16   136
1829998 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 2020   grade_5 70.0 28.0 23.0   2.0 12.0     0.0   14.0   81.0 68.0     15.0   2.0     72.0   19.0   149.0 70 28 23   2 12     0   14   81 68     15 2   72 19   149
1829999 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 2020   pk_12_total 383.0 116.0 94.0   4.0 43.0     0.0   54.0   365.0 329.0     87.0   7.0     297.0   73.0   694.0 383 116 94   4 43     0   54   365 329     87 7   297 73   694
1830415 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 2020   grade_1 50.0 17.0 5.0   0.0 25.0     0.0   10.0   53.0 54.0     13.0   0.0     41.0   4.0   107.0 50 17 5   0 25     0   10   53 54     13 0   41 4   107
1830416 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 2020   grade_2 43.0 16.0 7.0   0.0 22.0     0.0   14.0   59.0 43.0     13.0   0.0     31.0   5.0   102.0 43 16 7   0 22     0   14   59 43     13 0   31 5   102
1830417 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 2020   grade_3 53.0 30.0 7.0   0.0 33.0     0.0   14.0   78.0 59.0     21.0   0.0     64.0   8.0   137.0 53 30 7   0 33     0   14   78 59     21 0   64 8   137
1830418 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 2020   grade_4 60.0 31.0 9.0   0.0 31.0     0.0   14.0   74.0 71.0     21.0   0.0     50.0   5.0   145.0 60 31 9   0 31     0   14   74 71     21 0   50 5   145
1830419 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 2020   grade_5 55.0 22.0 13.0   0.0 38.0     0.0   17.0   72.0 73.0     10.0   0.0     64.0   10.0   145.0 55 22 13   0 38     0   17   72 73     10 0   64 10   145
1830420 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 2020   grade_6 69.0 53.0 9.0   0.0 42.0     0.0   21.0   94.0 100.0     16.0   0.0     94.0   14.0   194.0 69 53 9   0 42     0   21   94 100     16 0   94 14   194
1830421 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 2020   grade_7 74.0 45.0 12.0   0.0 57.0     1.0   12.0   119.0 82.0     12.0   0.0     94.0   12.0   201.0 74 45 12   0 57     1   12   119 82     12 0   94 12   201
1830422 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 2020   grade_8 65.0 58.0 11.0   0.0 50.0     0.0   14.0   108.0 90.0     13.0   0.0     93.0   7.0   198.0 65 58 11   0 50     0   14   108 90     13 0   93 7   198
1830423 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 2020   pk_12_total 469.0 272.0 73.0   0.0 298.0     1.0   116.0   657.0 572.0     119.0   0.0     531.0   65.0   1229.0 469 272 73   0 298     1   116   657 572     119 0   531 65   1229
1831767 MN Wright 86 school 2721390 882 Independent Districts and Schools Monticello Public School District 272139001078 10 Pinewood Elementary Elementary School (Grades PK-6) Regular School No Elementary 01 05 2020   grade_1 139.0 2.0 15.0   0.0 1.0     0.0   7.0   87.0 77.0     8.0   2.0     51.0   20.0   164.0 139 2 15   0 1     0   7   87 77     8 2   51 20   164
1831768 MN Wright 86 school 2721390 882 Independent Districts and Schools Monticello Public School District 272139001078 10 Pinewood Elementary Elementary School (Grades PK-6) Regular School No Elementary 01 05 2020   grade_2 151.0 3.0 12.0   0.0 0.0     0.0   10.0   85.0 91.0     9.0   1.0     47.0   26.0   176.0 151 3 12   0 0     0   10   85 91     9 1   47 26   176
1831769 MN Wright 86 school 2721390 882 Independent Districts and Schools Monticello Public School District 272139001078 10 Pinewood Elementary Elementary School (Grades PK-6) Regular School No Elementary 01 05 2020   grade_3 134.0 2.0 14.0   0.0 0.0     0.0   5.0   91.0 64.0     10.0   0.0     41.0   24.0   155.0 134 2 14   0 0     0   5   91 64     10 0   41 24   155

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