Data source: Big Local News · About: Big Local

13,903 rows where state = "MN" and year = 2019 sorted by ccd_school_low_grade

View and edit SQL

year

  • 2019 · 13,903
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
1946232 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 2019   grade_3 5.0 1.0 0.0   0.0 0.0     0.0   1.0   5.0 2.0     *   *         *   7.0 5 1 0   0 0     0   1   5 2                 7
1946233 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 2019   grade_4 7.0 0.0 0.0   0.0 2.0     0.0   0.0   8.0 1.0     *   *         *   9.0 7 0 0   0 2     0   0   8 1                 9
1946234 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 2019   grade_5 9.0 1.0 0.0   0.0 0.0     0.0   0.0   6.0 4.0     0.0   0.0     0.0   0.0   10.0 9 1 0   0 0     0   0   6 4     0 0   0 0   10
1946235 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 2019   grade_6 8.0 1.0 1.0   0.0 2.0     0.0   1.0   7.0 6.0     0.0   0.0     3.0   2.0   13.0 8 1 1   0 2     0   1   7 6     0 0   3 2   13
1946236 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 2019   pk_12_total 29.0 3.0 1.0   0.0 4.0     0.0   2.0   26.0 13.0     0.0   0.0         3.0   39.0 29 3 1   0 4     0   2   26 13     0 0     3   39
1946274 MN Beltrami 4 school 2704440 31 Independent Districts and Schools BEMIDJI PUBLIC SCHOOL DISTRICT 270444000194 16 NORTHERN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 01 03 2019   early_childhood_special_ed 16.0 0.0 0.0   4.0 0.0     0.0   0.0   12.0 8.0     0.0   *     9.0   *   20.0 16 0 0   4 0     0   0   12 8     0     9     20
1946275 MN Beltrami 4 school 2704440 31 Independent Districts and Schools BEMIDJI PUBLIC SCHOOL DISTRICT 270444000194 16 NORTHERN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 01 03 2019   grade_1 83.0 0.0 0.0   11.0 0.0     0.0   4.0   54.0 44.0     0.0   1.0     44.0   14.0   98.0 83 0 0   11 0     0   4   54 44     0 1   44 14   98
1946276 MN Beltrami 4 school 2704440 31 Independent Districts and Schools BEMIDJI PUBLIC SCHOOL DISTRICT 270444000194 16 NORTHERN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 01 03 2019   grade_2 76.0 0.0 2.0   6.0 1.0     0.0   7.0   41.0 51.0     1.0   0.0     32.0   9.0   92.0 76 0 2   6 1     0   7   41 51     1 0   32 9   92
1946277 MN Beltrami 4 school 2704440 31 Independent Districts and Schools BEMIDJI PUBLIC SCHOOL DISTRICT 270444000194 16 NORTHERN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 01 03 2019   grade_3 63.0 0.0 1.0   7.0 0.0     0.0   10.0   37.0 44.0     *   *     25.0   11.0   81.0 63 0 1   7 0     0   10   37 44           25 11   81
1946278 MN Beltrami 4 school 2704440 31 Independent Districts and Schools BEMIDJI PUBLIC SCHOOL DISTRICT 270444000194 16 NORTHERN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 01 03 2019   pk_12_total 238.0 0.0 3.0   28.0 1.0     0.0   21.0   144.0 147.0     *   3.0     110.0   54.0   291.0 238 0 3   28 1     0   21   144 147       3   110 54   291
1946307 MN Beltrami 4 school 2704440 31 Independent Districts and Schools BEMIDJI PUBLIC SCHOOL DISTRICT 270444000193 100 HORACE MAY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 01 03 2019   early_childhood_special_ed 21.0 0.0 0.0   11.0 0.0     0.0   1.0   23.0 10.0     0.0   0.0     19.0   *   33.0 21 0 0   11 0     0   1   23 10     0 0   19     33
1946308 MN Beltrami 4 school 2704440 31 Independent Districts and Schools BEMIDJI PUBLIC SCHOOL DISTRICT 270444000193 100 HORACE MAY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 01 03 2019   grade_1 78.0 2.0 1.0   5.0 1.0     0.0   2.0   49.0 40.0     0.0   2.0     33.0   19.0   89.0 78 2 1   5 1     0   2   49 40     0 2   33 19   89
1946309 MN Beltrami 4 school 2704440 31 Independent Districts and Schools BEMIDJI PUBLIC SCHOOL DISTRICT 270444000193 100 HORACE MAY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 01 03 2019   grade_2 72.0 3.0 3.0   6.0 1.0     0.0   0.0   42.0 43.0     0.0   0.0     23.0   16.0   85.0 72 3 3   6 1     0   0   42 43     0 0   23 16   85
1946310 MN Beltrami 4 school 2704440 31 Independent Districts and Schools BEMIDJI PUBLIC SCHOOL DISTRICT 270444000193 100 HORACE MAY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 01 03 2019   grade_3 82.0 0.0 1.0   3.0 1.0     0.0   3.0   52.0 38.0     0.0   1.0     34.0   18.0   90.0 82 0 1   3 1     0   3   52 38     0 1   34 18   90
1946311 MN Beltrami 4 school 2704440 31 Independent Districts and Schools BEMIDJI PUBLIC SCHOOL DISTRICT 270444000193 100 HORACE MAY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 01 03 2019   pk_12_total 253.0 5.0 5.0   25.0 3.0     0.0   6.0   166.0 131.0     0.0   3.0     109.0   86.0   297.0 253 5 5   25 3     0   6   166 131     0 3   109 86   297
1946332 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 2019   grade_1 0.0 0.0 0.0   128.0 0.0     0.0   0.0   74.0 54.0     *   *     114.0   34.0   128.0 0 0 0   128 0     0   0   74 54           114 34   128
1946333 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 2019   grade_2 0.0 0.0 0.0   129.0 0.0     0.0   0.0   65.0 64.0     0.0   14.0         25.0   129.0 0 0 0   129 0     0   0   65 64     0 14     25   129
1946334 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 2019   grade_3 0.0 0.0 0.0   113.0 0.0     0.0   1.0   49.0 65.0     0.0   18.0         18.0   114.0 0 0 0   113 0     0   1   49 65     0 18     18   114
1946335 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 2019   grade_4 0.0 0.0 0.0   125.0 0.0     0.0   0.0   70.0 55.0     0.0   22.0         24.0   125.0 0 0 0   125 0     0   0   70 55     0 22     24   125
1946336 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 2019   grade_5 0.0 0.0 0.0   93.0 0.0     0.0   0.0   50.0 43.0     0.0   *     81.0   16.0   93.0 0 0 0   93 0     0   0   50 43     0     81 16   93
1946337 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 2019   pk_12_total 0.0 0.0 0.0   588.0 0.0     0.0   1.0   308.0 281.0     *   85.0     498.0   117.0   589.0 0 0 0   588 0     0   1   308 281       85   498 117   589
1946495 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 2019   grade_1 141.0 3.0 5.0   0.0 0.0     0.0   5.0   82.0 72.0     2.0   0.0     46.0   21.0   154.0 141 3 5   0 0     0   5   82 72     2 0   46 21   154
1946496 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 2019   grade_2 130.0 1.0 9.0   0.0 0.0     0.0   6.0   66.0 80.0     1.0   0.0     55.0   33.0   146.0 130 1 9   0 0     0   6   66 80     1 0   55 33   146
1946497 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 2019   grade_3 127.0 1.0 9.0   0.0 0.0     0.0   3.0   75.0 65.0     1.0   2.0     41.0   30.0   140.0 127 1 9   0 0     0   3   75 65     1 2   41 30   140
1946498 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 2019   grade_4 153.0 3.0 8.0   0.0 0.0     0.0   2.0   96.0 70.0     3.0   0.0     48.0   30.0   166.0 153 3 8   0 0     0   2   96 70     3 0   48 30   166
1946499 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 2019   pk_12_total 551.0 8.0 31.0   0.0 0.0     0.0   16.0   319.0 287.0     7.0   2.0     190.0   114.0   606.0 551 8 31   0 0     0   16   319 287     7 2   190 114   606
1946697 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 2019   grade_1 75.0 0.0 23.0   1.0 0.0     1.0   7.0   55.0 52.0     14.0   0.0     54.0   19.0   107.0 75 0 23   1 0     1   7   55 52     14 0   54 19   107
1946698 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 2019   grade_2 81.0 3.0 23.0   0.0 0.0     1.0   8.0   61.0 55.0     17.0   0.0     53.0   25.0   116.0 81 3 23   0 0     1   8   61 55     17 0   53 25   116
1946699 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 2019   grade_3 85.0 4.0 25.0   1.0 0.0     0.0   1.0   61.0 55.0     20.0   0.0     61.0   32.0   116.0 85 4 25   1 0     0   1   61 55     20 0   61 32   116
1946700 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 2019   pk_12_total 241.0 7.0 71.0   2.0 0.0     2.0   16.0   177.0 162.0     51.0   0.0     168.0   76.0   339.0 241 7 71   2 0     2   16   177 162     51 0   168 76   339
1948640 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 2019   grade_1 63.0 12.0 30.0   0.0 10.0     2.0   8.0   72.0 53.0     37.0   0.0     64.0   *   125.0 63 12 30   0 10     2   8   72 53     37 0   64     125
1948641 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 2019   grade_2 65.0 11.0 22.0   0.0 8.0     0.0   2.0   66.0 42.0     24.0   1.0     63.0   23.0   108.0 65 11 22   0 8     0   2   66 42     24 1   63 23   108
1948642 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 2019   grade_3 61.0 12.0 19.0   0.0 5.0     0.0   4.0   40.0 61.0     21.0   0.0         18.0   101.0 61 12 19   0 5     0   4   40 61     21 0     18   101
1948643 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 2019   grade_4 49.0 10.0 28.0   0.0 11.0     2.0   3.0   54.0 49.0     25.0   0.0         *   103.0 49 10 28   0 11     2   3   54 49     25 0         103
1948644 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 2019   pk_12_total 238.0 45.0 99.0   0.0 34.0     4.0   17.0   232.0 205.0     107.0   1.0     229.0   68.0   437.0 238 45 99   0 34     4   17   232 205     107 1   229 68   437
1948645 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 2019   grade_1 38.0 3.0 33.0   0.0 6.0     2.0   3.0   42.0 43.0     31.0   0.0     54.0   *   85.0 38 3 33   0 6     2   3   42 43     31 0   54     85
1948646 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 2019   grade_2 35.0 4.0 20.0   0.0 7.0     1.0   5.0   29.0 43.0     16.0   0.0     44.0   12.0   72.0 35 4 20   0 7     1   5   29 43     16 0   44 12   72
1948647 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 2019   grade_3 50.0 4.0 23.0   0.0 5.0     1.0   0.0   32.0 51.0     *   0.0     51.0   *   83.0 50 4 23   0 5     1   0   32 51       0   51     83
1948648 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 2019   grade_4 38.0 5.0 23.0   0.0 13.0     1.0   2.0   48.0 34.0     *   0.0     58.0   21.0   82.0 38 5 23   0 13     1   2   48 34       0   58 21   82
1948649 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 2019   pk_12_total 161.0 16.0 99.0   0.0 31.0     5.0   10.0   151.0 171.0     85.0   0.0     207.0   52.0   322.0 161 16 99   0 31     5   10   151 171     85 0   207 52   322
1948650 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 2019   grade_1 73.0 5.0 28.0   0.0 19.0     0.0   4.0   67.0 62.0     27.0   0.0     68.0   18.0   129.0 73 5 28   0 19     0   4   67 62     27 0   68 18   129
1948651 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 2019   grade_2 56.0 6.0 37.0   0.0 10.0     1.0   7.0   52.0 65.0     26.0   0.0     66.0   21.0   117.0 56 6 37   0 10     1   7   52 65     26 0   66 21   117
1948652 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 2019   grade_3 65.0 8.0 42.0   0.0 6.0     1.0   9.0   65.0 66.0     34.0   *     68.0   32.0   131.0 65 8 42   0 6     1   9   65 66     34     68 32   131
1948653 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 2019   grade_4 71.0 9.0 38.0   0.0 12.0     0.0   6.0   68.0 68.0     30.0   0.0     72.0   25.0   136.0 71 9 38   0 12     0   6   68 68     30 0   72 25   136
1948654 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 2019   pk_12_total 265.0 28.0 145.0   0.0 47.0     2.0   26.0   252.0 261.0     117.0   *     274.0   96.0   513.0 265 28 145   0 47     2   26   252 261     117     274 96   513
1948655 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 2019   pre_kindergarten 5.0 13.0 13.0   0.0 4.0     0.0   0.0   13.0 22.0     *   0.0         0.0   35.0 5 13 13   0 4     0   0   13 22       0     0   35
1948656 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 2019   grade_1 13.0 9.0 22.0   0.0 19.0     2.0   1.0   43.0 23.0     37.0   0.0     51.0   12.0   66.0 13 9 22   0 19     2   1   43 23     37 0   51 12   66
1948657 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 2019   grade_2 9.0 12.0 22.0   0.0 11.0     2.0   3.0   28.0 31.0     33.0   0.0     51.0   6.0   59.0 9 12 22   0 11     2   3   28 31     33 0   51 6   59
1948658 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 2019   grade_3 12.0 17.0 30.0   0.0 24.0     0.0   0.0   47.0 36.0     47.0   *         12.0   83.0 12 17 30   0 24     0   0   47 36     47       12   83
1948659 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 2019   grade_4 19.0 13.0 33.0   0.0 12.0     1.0   7.0   40.0 45.0     *   *     72.0   21.0   85.0 19 13 33   0 12     1   7   40 45           72 21   85
1948660 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 2019   pk_12_total 58.0 64.0 120.0   0.0 70.0     5.0   11.0   171.0 157.0     148.0   4.0     276.0   51.0   328.0 58 64 120   0 70     5   11   171 157     148 4   276 51   328
1948910 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 2019   grade_1 129.0 3.0 8.0   1.0 4.0     0.0   2.0   83.0 64.0     *   *     59.0   19.0   147.0 129 3 8   1 4     0   2   83 64           59 19   147
1948911 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 2019   grade_2 158.0 7.0 2.0   0.0 0.0     2.0   3.0   84.0 88.0     *   *     64.0   7.0   172.0 158 7 2   0 0     2   3   84 88           64 7   172
1948912 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 2019   pk_12_total 287.0 10.0 10.0   1.0 4.0     2.0   5.0   167.0 152.0     8.0   0.0     123.0   26.0   319.0 287 10 10   1 4     2   5   167 152     8 0   123 26   319
1949077 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 2019   grade_1 94.0 28.0 7.0   2.0 15.0     0.0   9.0   74.0 81.0     16.0   2.0     46.0   17.0   155.0 94 28 7   2 15     0   9   74 81     16 2   46 17   155
1949078 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 2019   grade_2 81.0 21.0 14.0   1.0 4.0     0.0   15.0   69.0 67.0     22.0   *     49.0   7.0   136.0 81 21 14   1 4     0   15   69 67     22     49 7   136
1949079 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 2019   grade_3 86.0 29.0 15.0   0.0 7.0     0.0   8.0   86.0 59.0     16.0   1.0     50.0   12.0   145.0 86 29 15   0 7     0   8   86 59     16 1   50 12   145
1949080 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 2019   grade_4 82.0 25.0 13.0   0.0 12.0     0.0   10.0   65.0 77.0     15.0   *     54.0   13.0   142.0 82 25 13   0 12     0   10   65 77     15     54 13   142
1949081 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 2019   grade_5 74.0 24.0 16.0   1.0 13.0     0.0   13.0   71.0 70.0     9.0   3.0     58.0   12.0   141.0 74 24 16   1 13     0   13   71 70     9 3   58 12   141
1949082 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 2019   pk_12_total 417.0 127.0 65.0   4.0 51.0     0.0   55.0   365.0 354.0     78.0   8.0     257.0   61.0   719.0 417 127 65   4 51     0   55   365 354     78 8   257 61   719
1949083 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 2019   grade_1 114.0 8.0 8.0   0.0 30.0     0.0   10.0   103.0 67.0     14.0   0.0         17.0   170.0 114 8 8   0 30     0   10   103 67     14 0     17   170
1949084 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 2019   grade_2 101.0 8.0 5.0   0.0 32.0     0.0   10.0   85.0 71.0     13.0   0.0     27.0   14.0   156.0 101 8 5   0 32     0   10   85 71     13 0   27 14   156
1949085 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 2019   grade_3 102.0 9.0 6.0   0.0 22.0     0.0   7.0   76.0 70.0     *   0.0     23.0   18.0   146.0 102 9 6   0 22     0   7   76 70       0   23 18   146
1949086 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 2019   grade_4 104.0 7.0 8.0   2.0 23.0     0.0   9.0   83.0 70.0     9.0   0.0     25.0   11.0   153.0 104 7 8   2 23     0   9   83 70     9 0   25 11   153
1949087 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 2019   grade_5 111.0 7.0 7.0   1.0 17.0     0.0   7.0   85.0 65.0     *   0.0         10.0   150.0 111 7 7   1 17     0   7   85 65       0     10   150
1949088 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 2019   pk_12_total 532.0 39.0 34.0   3.0 124.0     0.0   43.0   432.0 343.0     44.0   0.0     112.0   70.0   775.0 532 39 34   3 124     0   43   432 343     44 0   112 70   775
1949089 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 2019   grade_1 54.0 10.0 17.0   1.0 10.0     0.0   9.0   40.0 61.0     14.0   0.0     51.0   9.0   101.0 54 10 17   1 10     0   9   40 61     14 0   51 9   101
1949090 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 2019   grade_2 56.0 13.0 12.0   1.0 21.0     0.0   11.0   52.0 62.0     25.0   1.0     54.0   15.0   114.0 56 13 12   1 21     0   11   52 62     25 1   54 15   114
1949091 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 2019   grade_3 45.0 12.0 13.0   0.0 19.0     1.0   16.0   52.0 54.0     22.0   5.0     60.0   11.0   106.0 45 12 13   0 19     1   16   52 54     22 5   60 11   106
1949092 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 2019   grade_4 67.0 16.0 12.0   1.0 14.0     0.0   7.0   68.0 49.0     14.0   3.0     63.0   21.0   117.0 67 16 12   1 14     0   7   68 49     14 3   63 21   117
1949093 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 2019   grade_5 69.0 15.0 20.0   0.0 14.0     0.0   10.0   64.0 64.0     10.0   0.0     62.0   17.0   128.0 69 15 20   0 14     0   10   64 64     10 0   62 17   128
1949094 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 2019   pk_12_total 291.0 66.0 74.0   3.0 78.0     1.0   53.0   276.0 290.0     85.0   9.0     290.0   73.0   566.0 291 66 74   3 78     1   53   276 290     85 9   290 73   566
1949095 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 2019   grade_1 54.0 5.0 12.0   0.0 10.0     0.0   12.0   49.0 44.0     16.0   0.0     37.0   18.0   93.0 54 5 12   0 10     0   12   49 44     16 0   37 18   93
1949096 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 2019   grade_2 65.0 8.0 8.0   0.0 12.0     0.0   9.0   62.0 40.0     10.0   0.0     37.0   18.0   102.0 65 8 8   0 12     0   9   62 40     10 0   37 18   102
1949097 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 2019   grade_3 61.0 17.0 16.0   0.0 7.0     0.0   13.0   60.0 54.0     15.0   1.0     55.0   15.0   114.0 61 17 16   0 7     0   13   60 54     15 1   55 15   114
1949098 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 2019   grade_4 60.0 15.0 12.0   0.0 11.0     1.0   7.0   51.0 55.0     11.0   4.0     42.0   9.0   106.0 60 15 12   0 11     1   7   51 55     11 4   42 9   106
1949099 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 2019   grade_5 61.0 15.0 16.0   1.0 5.0     0.0   7.0   57.0 48.0     13.0   0.0     45.0   15.0   105.0 61 15 16   1 5     0   7   57 48     13 0   45 15   105
1949100 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 2019   pk_12_total 301.0 60.0 64.0   1.0 45.0     1.0   48.0   279.0 241.0     65.0   5.0     216.0   75.0   520.0 301 60 64   1 45     1   48   279 241     65 5   216 75   520
1949101 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 2019   grade_1 143.0 3.0 6.0   0.0 28.0     1.0   15.0   105.0 91.0     *   *         16.0   196.0 143 3 6   0 28     1   15   105 91             16   196
1949102 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 2019   grade_2 158.0 2.0 8.0   1.0 32.0     0.0   10.0   115.0 96.0     *   0.0         14.0   211.0 158 2 8   1 32     0   10   115 96       0     14   211
1949103 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 2019   grade_3 146.0 3.0 5.0   0.0 34.0     0.0   12.0   114.0 86.0     8.0   0.0     24.0   17.0   200.0 146 3 5   0 34     0   12   114 86     8 0   24 17   200
1949104 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 2019   grade_4 147.0 3.0 11.0   1.0 24.0     0.0   8.0   106.0 88.0     *   *         20.0   194.0 147 3 11   1 24     0   8   106 88             20   194
1949105 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 2019   grade_5 142.0 7.0 9.0   1.0 34.0     0.0   13.0   105.0 101.0     7.0   0.0     24.0   23.0   206.0 142 7 9   1 34     0   13   105 101     7 0   24 23   206
1949106 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 2019   pk_12_total 736.0 18.0 39.0   3.0 152.0     1.0   58.0   545.0 462.0     35.0   2.0     99.0   90.0   1007.0 736 18 39   3 152     1   58   545 462     35 2   99 90   1007
1949107 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 2019   grade_1 99.0 15.0 13.0   0.0 11.0     0.0   10.0   71.0 77.0     10.0   0.0     51.0   14.0   148.0 99 15 13   0 11     0   10   71 77     10 0   51 14   148
1949108 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 2019   grade_2 78.0 18.0 16.0   1.0 4.0     0.0   15.0   71.0 61.0     12.0   *     52.0   12.0   132.0 78 18 16   1 4     0   15   71 61     12     52 12   132
1949109 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 2019   grade_3 75.0 17.0 11.0   0.0 12.0     0.0   9.0   70.0 54.0     15.0   1.0     49.0   9.0   124.0 75 17 11   0 12     0   9   70 54     15 1   49 9   124
1949110 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 2019   grade_4 69.0 25.0 18.0   2.0 11.0     0.0   13.0   74.0 64.0     14.0   3.0     61.0   13.0   138.0 69 25 18   2 11     0   13   74 64     14 3   61 13   138
1949111 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 2019   grade_5 70.0 17.0 25.0   2.0 10.0     0.0   7.0   78.0 53.0     15.0   *     64.0   17.0   131.0 70 17 25   2 10     0   7   78 53     15     64 17   131
1949112 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 2019   pk_12_total 391.0 92.0 83.0   5.0 48.0     0.0   54.0   364.0 309.0     66.0   6.0     277.0   65.0   673.0 391 92 83   5 48     0   54   364 309     66 6   277 65   673
1949528 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 2019   grade_1 40.0 12.0 5.0   0.0 18.0     0.0   11.0   50.0 36.0     14.0   0.0     23.0   5.0   86.0 40 12 5   0 18     0   11   50 36     14 0   23 5   86
1949529 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 2019   grade_2 49.0 23.0 6.0   0.0 28.0     0.0   11.0   61.0 56.0     22.0   0.0     43.0   5.0   117.0 49 23 6   0 28     0   11   61 56     22 0   43 5   117
1949530 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 2019   grade_3 58.0 26.0 7.0   0.0 33.0     0.0   13.0   69.0 68.0     23.0   0.0     44.0   5.0   137.0 58 26 7   0 33     0   13   69 68     23 0   44 5   137
1949531 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 2019   grade_4 54.0 23.0 14.0   0.0 39.0     0.0   17.0   71.0 76.0     22.0   0.0     61.0   8.0   147.0 54 23 14   0 39     0   17   71 76     22 0   61 8   147
1949532 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 2019   grade_5 60.0 32.0 12.0   0.0 31.0     0.0   15.0   70.0 80.0     13.0   1.0     69.0   12.0   150.0 60 32 12   0 31     0   15   70 80     13 1   69 12   150
1949533 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 2019   grade_6 75.0 53.0 12.0   0.0 58.0     1.0   12.0   122.0 89.0     15.0   1.0     100.0   14.0   211.0 75 53 12   0 58     1   12   122 89     15 1   100 14   211
1949534 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 2019   grade_7 68.0 57.0 11.0   0.0 54.0     0.0   13.0   111.0 92.0     12.0   1.0     97.0   10.0   203.0 68 57 11   0 54     0   13   111 92     12 1   97 10   203
1949535 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 2019   grade_8 76.0 58.0 12.0   0.0 52.0     0.0   5.0   111.0 92.0     11.0   1.0     88.0   10.0   203.0 76 58 12   0 52     0   5   111 92     11 1   88 10   203
1949536 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 2019   pk_12_total 480.0 284.0 79.0   0.0 313.0     1.0   97.0   665.0 589.0     132.0   4.0     525.0   69.0   1254.0 480 284 79   0 313     1   97   665 589     132 4   525 69   1254
1950911 MN Wright 86 school 2733790 885 Independent Districts and Schools ST. MICHAEL-ALBERTVILLE SCHOOL DIST 273379000032 40 ST. MICHAEL ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 01 04 2019   grade_1 108.0 8.0 2.0   0.0 5.0     0.0   3.0   75.0 51.0     3.0   0.0     19.0   18.0   126.0 108 8 2   0 5     0   3   75 51     3 0   19 18   126

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