Data source: Big Local News · About: Big Local

13,757 rows where state = "MN" and year = 2017 sorted by ccd_school_high_grade

View and edit SQL

year

  • 2017 · 13,657
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
694448 MN Scott 70 school 2704050 716 Independent Districts and Schools BELLE PLAINE PUBLIC SCHOOL DISTRICT 270405000183 10 CHATFIELD ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 02 2017   grade_1 117.0 0.0 6.0   0.0 1.0     1.0   8.0   66.0 67.0     2.0   0.0     29.0   9.0   133.0 117 0 6   0 1     1   8   66 67     2 0   29 9   133
694449 MN Scott 70 school 2704050 716 Independent Districts and Schools BELLE PLAINE PUBLIC SCHOOL DISTRICT 270405000183 10 CHATFIELD ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 02 2017   grade_2 97.0 1.0 8.0   1.0 0.0     0.0   4.0   59.0 52.0     1.0   0.0     23.0   11.0   111.0 97 1 8   1 0     0   4   59 52     1 0   23 11   111
694450 MN Scott 70 school 2704050 716 Independent Districts and Schools BELLE PLAINE PUBLIC SCHOOL DISTRICT 270405000183 10 CHATFIELD ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 02 2017   pk_12_total 347.0 2.0 19.0   1.0 2.0     1.0   17.0   210.0 179.0     3.0   *     76.0   41.0   389.0 347 2 19   1 2     1   17   210 179     3     76 41   389
694462 MN Scott 70 school 2730060 719 Independent Districts and Schools PRIOR LAKE-SAVAGE AREA SCHOOLS 273006003449 9 EDGEWOOD ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 02 2017   early_childhood_special_ed 103.0 2.0 5.0   1.0 3.0     0.0   3.0   76.0 41.0     0.0   *     11.0   *   117.0 103 2 5   1 3     0   3   76 41     0     11     117
694463 MN Scott 70 school 2730060 719 Independent Districts and Schools PRIOR LAKE-SAVAGE AREA SCHOOLS 273006003449 9 EDGEWOOD ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 02 2017   kindergarten 62.0 2.0 12.0   0.0 2.0     0.0   0.0   29.0 49.0     4.0   *     5.0   4.0   78.0 62 2 12   0 2     0   0   29 49     4     5 4   78
694464 MN Scott 70 school 2730060 719 Independent Districts and Schools PRIOR LAKE-SAVAGE AREA SCHOOLS 273006003449 9 EDGEWOOD ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 02 2017   grade_1 52.0 0.0 10.0   0.0 0.0     0.0   5.0   25.0 42.0     4.0   0.0         0.0   67.0 52 0 10   0 0     0   5   25 42     4 0     0   67
694465 MN Scott 70 school 2730060 719 Independent Districts and Schools PRIOR LAKE-SAVAGE AREA SCHOOLS 273006003449 9 EDGEWOOD ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 02 2017   grade_2 46.0 0.0 11.0   0.0 1.0     0.0   1.0   19.0 40.0     1.0   0.0     6.0   2.0   59.0 46 0 11   0 1     0   1   19 40     1 0   6 2   59
694466 MN Scott 70 school 2730060 719 Independent Districts and Schools PRIOR LAKE-SAVAGE AREA SCHOOLS 273006003449 9 EDGEWOOD ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 02 2017   pk_12_total 263.0 4.0 38.0   1.0 6.0     0.0   9.0   149.0 172.0     9.0   0.0         123.0   321.0 263 4 38   1 6     0   9   149 172     9 0     123   321
694571 MN Sherburne 71 school 2703870 726 Independent Districts and Schools BECKER PUBLIC SCHOOL DISTRICT 270387003092 40 BECKER PRIMARY Elementary School (Grades PK-6) Regular School No Elementary PK 02 2017   early_childhood_special_ed 25.0 2.0 1.0   1.0 0.0     0.0   0.0   22.0 7.0     0.0   1.0     7.0   *   29.0 25 2 1   1 0     0   0   22 7     0 1   7     29
694572 MN Sherburne 71 school 2703870 726 Independent Districts and Schools BECKER PUBLIC SCHOOL DISTRICT 270387003092 40 BECKER PRIMARY Elementary School (Grades PK-6) Regular School No Elementary PK 02 2017   kindergarten 179.0 1.0 4.0   0.0 1.0     0.0   8.0   105.0 88.0     2.0   2.0     42.0   29.0   193.0 179 1 4   0 1     0   8   105 88     2 2   42 29   193
694573 MN Sherburne 71 school 2703870 726 Independent Districts and Schools BECKER PUBLIC SCHOOL DISTRICT 270387003092 40 BECKER PRIMARY Elementary School (Grades PK-6) Regular School No Elementary PK 02 2017   grade_1 206.0 1.0 4.0   0.0 0.0     0.0   13.0   105.0 119.0     2.0   1.0     37.0   19.0   224.0 206 1 4   0 0     0   13   105 119     2 1   37 19   224
694574 MN Sherburne 71 school 2703870 726 Independent Districts and Schools BECKER PUBLIC SCHOOL DISTRICT 270387003092 40 BECKER PRIMARY Elementary School (Grades PK-6) Regular School No Elementary PK 02 2017   grade_2 205.0 3.0 9.0   0.0 1.0     0.0   8.0   125.0 101.0     4.0   3.0     47.0   21.0   226.0 205 3 9   0 1     0   8   125 101     4 3   47 21   226
694575 MN Sherburne 71 school 2703870 726 Independent Districts and Schools BECKER PUBLIC SCHOOL DISTRICT 270387003092 40 BECKER PRIMARY Elementary School (Grades PK-6) Regular School No Elementary PK 02 2017   pk_12_total 615.0 7.0 18.0   1.0 2.0     0.0   29.0   357.0 315.0     8.0   7.0     133.0   98.0   672.0 615 7 18   1 2     0   29   357 315     8 7   133 98   672
694619 MN Sherburne 71 school 2711370 728 Independent Districts and Schools ELK RIVER PUBLIC SCHOOL DISTRICT 271137000522 200 ZIMMERMAN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 02 2017   kindergarten 158.0 3.0 1.0   0.0 1.0     0.0   8.0   95.0 76.0     4.0   1.0     54.0   25.0   171.0 158 3 1   0 1     0   8   95 76     4 1   54 25   171
694620 MN Sherburne 71 school 2711370 728 Independent Districts and Schools ELK RIVER PUBLIC SCHOOL DISTRICT 271137000522 200 ZIMMERMAN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 02 2017   grade_1 159.0 0.0 5.0   0.0 1.0     0.0   8.0   96.0 77.0     2.0   0.0     50.0   32.0   173.0 159 0 5   0 1     0   8   96 77     2 0   50 32   173
694621 MN Sherburne 71 school 2711370 728 Independent Districts and Schools ELK RIVER PUBLIC SCHOOL DISTRICT 271137000522 200 ZIMMERMAN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 02 2017   grade_2 165.0 0.0 2.0   0.0 2.0     0.0   7.0   95.0 81.0     3.0   0.0     43.0   24.0   176.0 165 0 2   0 2     0   7   95 81     3 0   43 24   176
694622 MN Sherburne 71 school 2711370 728 Independent Districts and Schools ELK RIVER PUBLIC SCHOOL DISTRICT 271137000522 200 ZIMMERMAN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 02 2017   pk_12_total 482.0 3.0 8.0   0.0 4.0     0.0   23.0   286.0 234.0     9.0   1.0     147.0   81.0   520.0 482 3 8   0 4     0   23   286 234     9 1   147 81   520
695037 MN Washington 82 school 2718750 832 Independent Districts and Schools MAHTOMEDI PUBLIC SCHOOL DISTRICT 271875000871 20 WILDWOOD ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 02 2017   kindergarten 120.0 11.0 3.0   0.0 1.0     0.0   6.0   77.0 64.0     6.0   0.0     13.0   24.0   141.0 120 11 3   0 1     0   6   77 64     6 0   13 24   141
695038 MN Washington 82 school 2718750 832 Independent Districts and Schools MAHTOMEDI PUBLIC SCHOOL DISTRICT 271875000871 20 WILDWOOD ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 02 2017   grade_1 139.0 6.0 8.0   0.0 5.0     0.0   15.0   85.0 88.0     4.0   0.0     16.0   16.0   173.0 139 6 8   0 5     0   15   85 88     4 0   16 16   173
695039 MN Washington 82 school 2718750 832 Independent Districts and Schools MAHTOMEDI PUBLIC SCHOOL DISTRICT 271875000871 20 WILDWOOD ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 02 2017   grade_2 181.0 5.0 8.0   0.0 4.0     0.0   9.0   102.0 105.0     7.0   0.0     18.0   25.0   207.0 181 5 8   0 4     0   9   102 105     7 0   18 25   207
695040 MN Washington 82 school 2718750 832 Independent Districts and Schools MAHTOMEDI PUBLIC SCHOOL DISTRICT 271875000871 20 WILDWOOD ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 02 2017   pk_12_total 440.0 22.0 19.0   0.0 10.0     0.0   30.0   264.0 257.0     17.0   0.0     47.0   65.0   521.0 440 22 19   0 10     0   30   264 257     17 0   47 65   521
695447 MN Isanti 30 school 2707410 911 Independent Districts and Schools CAMBRIDGE-ISANTI PUBLIC SCHOOL DIST 270741003638 101 CAMBRIDGE PRIMARY SCHOOL Elementary School (Grades PK-6) Regular School No Elementary PK 02 2017   early_childhood_special_ed 59.0 0.0 3.0   1.0 0.0     0.0   2.0   43.0 22.0     0.0   1.0     26.0   *   65.0 59 0 3   1 0     0   2   43 22     0 1   26     65
695448 MN Isanti 30 school 2707410 911 Independent Districts and Schools CAMBRIDGE-ISANTI PUBLIC SCHOOL DIST 270741003638 101 CAMBRIDGE PRIMARY SCHOOL Elementary School (Grades PK-6) Regular School No Elementary PK 02 2017   kindergarten 177.0 2.0 7.0   0.0 2.0     0.0   12.0   98.0 102.0     3.0   4.0     62.0   20.0   200.0 177 2 7   0 2     0   12   98 102     3 4   62 20   200
695449 MN Isanti 30 school 2707410 911 Independent Districts and Schools CAMBRIDGE-ISANTI PUBLIC SCHOOL DIST 270741003638 101 CAMBRIDGE PRIMARY SCHOOL Elementary School (Grades PK-6) Regular School No Elementary PK 02 2017   grade_1 157.0 1.0 6.0   0.0 4.0     0.0   12.0   96.0 84.0     6.0   1.0     62.0   35.0   180.0 157 1 6   0 4     0   12   96 84     6 1   62 35   180
695450 MN Isanti 30 school 2707410 911 Independent Districts and Schools CAMBRIDGE-ISANTI PUBLIC SCHOOL DIST 270741003638 101 CAMBRIDGE PRIMARY SCHOOL Elementary School (Grades PK-6) Regular School No Elementary PK 02 2017   grade_2 163.0 4.0 6.0   2.0 3.0     1.0   13.0   99.0 93.0     6.0   3.0     75.0   23.0   192.0 163 4 6   2 3     1   13   99 93     6 3   75 23   192
695451 MN Isanti 30 school 2707410 911 Independent Districts and Schools CAMBRIDGE-ISANTI PUBLIC SCHOOL DIST 270741003638 101 CAMBRIDGE PRIMARY SCHOOL Elementary School (Grades PK-6) Regular School No Elementary PK 02 2017   pk_12_total 556.0 7.0 22.0   3.0 9.0     1.0   39.0   336.0 301.0     15.0   9.0     225.0   143.0   637.0 556 7 22   3 9     1   39   336 301     15 9   225 143   637
695452 MN Isanti 30 school 2707410 911 Independent Districts and Schools CAMBRIDGE-ISANTI PUBLIC SCHOOL DIST 270741003686 102 ISANTI PRIMARY SCHOOL Elementary School (Grades PK-6) Regular School No Elementary PK 02 2017   early_childhood_special_ed 47.0 0.0 2.0   0.0 1.0     0.0   1.0   33.0 18.0     0.0   0.0     23.0   *   51.0 47 0 2   0 1     0   1   33 18     0 0   23     51
695453 MN Isanti 30 school 2707410 911 Independent Districts and Schools CAMBRIDGE-ISANTI PUBLIC SCHOOL DIST 270741003686 102 ISANTI PRIMARY SCHOOL Elementary School (Grades PK-6) Regular School No Elementary PK 02 2017   kindergarten 121.0 1.0 4.0   0.0 1.0     0.0   5.0   64.0 68.0     2.0   1.0     43.0   21.0   132.0 121 1 4   0 1     0   5   64 68     2 1   43 21   132
695454 MN Isanti 30 school 2707410 911 Independent Districts and Schools CAMBRIDGE-ISANTI PUBLIC SCHOOL DIST 270741003686 102 ISANTI PRIMARY SCHOOL Elementary School (Grades PK-6) Regular School No Elementary PK 02 2017   grade_1 140.0 4.0 5.0   1.0 3.0     0.0   9.0   80.0 82.0     4.0   3.0     55.0   26.0   162.0 140 4 5   1 3     0   9   80 82     4 3   55 26   162
695455 MN Isanti 30 school 2707410 911 Independent Districts and Schools CAMBRIDGE-ISANTI PUBLIC SCHOOL DIST 270741003686 102 ISANTI PRIMARY SCHOOL Elementary School (Grades PK-6) Regular School No Elementary PK 02 2017   grade_2 119.0 0.0 0.0   2.0 3.0     0.0   3.0   72.0 55.0     0.0   0.0     41.0   11.0   127.0 119 0 0   2 3     0   3   72 55     0 0   41 11   127
695456 MN Isanti 30 school 2707410 911 Independent Districts and Schools CAMBRIDGE-ISANTI PUBLIC SCHOOL DIST 270741003686 102 ISANTI PRIMARY SCHOOL Elementary School (Grades PK-6) Regular School No Elementary PK 02 2017   pk_12_total 427.0 5.0 11.0   3.0 8.0     0.0   18.0   249.0 223.0     6.0   4.0     162.0   109.0   472.0 427 5 11   3 8     0   18   249 223     6 4   162 109   472
695593 MN Chisago 13 school 2700017 2144 Independent Districts and Schools CHISAGO LAKES SCHOOL DISTRICT 270001700352 1 CHISAGO LAKES EL. Elementary School (Grades PK-6) Regular School No Elementary PK 02 2017   kindergarten 134.0 1.0 2.0   0.0 1.0     0.0   2.0   73.0 67.0     2.0   0.0     25.0   19.0   140.0 134 1 2   0 1     0   2   73 67     2 0   25 19   140
695594 MN Chisago 13 school 2700017 2144 Independent Districts and Schools CHISAGO LAKES SCHOOL DISTRICT 270001700352 1 CHISAGO LAKES EL. Elementary School (Grades PK-6) Regular School No Elementary PK 02 2017   grade_1 178.0 0.0 5.0   0.0 1.0     0.0   2.0   92.0 94.0     2.0   2.0     45.0   12.0   186.0 178 0 5   0 1     0   2   92 94     2 2   45 12   186
695595 MN Chisago 13 school 2700017 2144 Independent Districts and Schools CHISAGO LAKES SCHOOL DISTRICT 270001700352 1 CHISAGO LAKES EL. Elementary School (Grades PK-6) Regular School No Elementary PK 02 2017   grade_2 158.0 0.0 4.0   0.0 2.0     0.0   5.0   77.0 92.0     3.0   0.0     41.0   18.0   169.0 158 0 4   0 2     0   5   77 92     3 0   41 18   169
695596 MN Chisago 13 school 2700017 2144 Independent Districts and Schools CHISAGO LAKES SCHOOL DISTRICT 270001700352 1 CHISAGO LAKES EL. Elementary School (Grades PK-6) Regular School No Elementary PK 02 2017   pk_12_total 470.0 1.0 11.0   0.0 4.0     0.0   9.0   242.0 253.0     7.0   2.0     111.0   49.0   495.0 470 1 11   0 4     0   9   242 253     7 2   111 49   495
695877 MN Martin 46 school 2718960 2448 Independent Districts and Schools MARTIN COUNTY WEST SCHOOL DISTRICT 271896000067 10 SHERBURN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 02 2017   early_childhood_special_ed 2.0 0.0 1.0   0.0 0.0     0.0   0.0   2.0 1.0         *         *   3.0 2 0 1   0 0     0   0   2 1                 3
695878 MN Martin 46 school 2718960 2448 Independent Districts and Schools MARTIN COUNTY WEST SCHOOL DISTRICT 271896000067 10 SHERBURN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 02 2017   kindergarten 31.0 0.0 0.0   0.0 0.0     0.0   1.0   16.0 16.0         *         3.0   32.0 31 0 0   0 0     0   1   16 16             3   32
695879 MN Martin 46 school 2718960 2448 Independent Districts and Schools MARTIN COUNTY WEST SCHOOL DISTRICT 271896000067 10 SHERBURN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 02 2017   grade_1 46.0 0.0 0.0   1.0 0.0     0.0   3.0   31.0 19.0     0.0   0.0     20.0   5.0   50.0 46 0 0   1 0     0   3   31 19     0 0   20 5   50
695880 MN Martin 46 school 2718960 2448 Independent Districts and Schools MARTIN COUNTY WEST SCHOOL DISTRICT 271896000067 10 SHERBURN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 02 2017   grade_2 45.0 2.0 3.0   0.0 0.0     0.0   2.0   25.0 27.0     0.0   0.0     27.0   8.0   52.0 45 2 3   0 0     0   2   25 27     0 0   27 8   52
695881 MN Martin 46 school 2718960 2448 Independent Districts and Schools MARTIN COUNTY WEST SCHOOL DISTRICT 271896000067 10 SHERBURN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 02 2017   pk_12_total 124.0 2.0 4.0   1.0 0.0     0.0   6.0   74.0 63.0     0.0   0.0     58.0   19.0   137.0 124 2 4   1 0     0   6   74 63     0 0   58 19   137
696034 MN Goodhue 25 school 2745735 2805 Independent Districts and Schools ZUMBROTA-MAZEPPA SCHOOL DISTRICT 274573504730 30 Zumbrota-Mazeppa Primary School Elementary School (Grades PK-6) Regular School No Elementary PK 02 2017   early_childhood_special_ed 17.0 1.0 0.0   0.0 1.0     0.0   0.0   10.0 9.0     0.0   0.0     5.0   *   19.0 17 1 0   0 1     0   0   10 9     0 0   5     19
696035 MN Goodhue 25 school 2745735 2805 Independent Districts and Schools ZUMBROTA-MAZEPPA SCHOOL DISTRICT 274573504730 30 Zumbrota-Mazeppa Primary School Elementary School (Grades PK-6) Regular School No Elementary PK 02 2017   kindergarten 77.0 1.0 3.0   0.0 2.0     0.0   2.0   47.0 38.0     1.0   0.0     22.0   12.0   85.0 77 1 3   0 2     0   2   47 38     1 0   22 12   85
696036 MN Goodhue 25 school 2745735 2805 Independent Districts and Schools ZUMBROTA-MAZEPPA SCHOOL DISTRICT 274573504730 30 Zumbrota-Mazeppa Primary School Elementary School (Grades PK-6) Regular School No Elementary PK 02 2017   grade_1 94.0 1.0 4.0   0.0 1.0     0.0   3.0   59.0 44.0     2.0   0.0     21.0   8.0   103.0 94 1 4   0 1     0   3   59 44     2 0   21 8   103
696037 MN Goodhue 25 school 2745735 2805 Independent Districts and Schools ZUMBROTA-MAZEPPA SCHOOL DISTRICT 274573504730 30 Zumbrota-Mazeppa Primary School Elementary School (Grades PK-6) Regular School No Elementary PK 02 2017   grade_2 81.0 1.0 2.0   0.0 0.0     0.0   4.0   53.0 35.0     0.0   0.0     25.0   12.0   88.0 81 1 2   0 0     0   4   53 35     0 0   25 12   88
696038 MN Goodhue 25 school 2745735 2805 Independent Districts and Schools ZUMBROTA-MAZEPPA SCHOOL DISTRICT 274573504730 30 Zumbrota-Mazeppa Primary School Elementary School (Grades PK-6) Regular School No Elementary PK 02 2017   pk_12_total 269.0 4.0 9.0   0.0 4.0     0.0   9.0   169.0 126.0     3.0   0.0     73.0   51.0   295.0 269 4 9   0 4     0   9   169 126     3 0   73 51   295
696080 MN Mcleod 43 school 2700128 2859 Independent Districts and Schools GLENCOE-SILVER LAKE SCHOOL DISTRICT 270012800632 10 BAKER ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 02 2017   early_childhood_special_ed 18.0 0.0 3.0   0.0 0.0     0.0   2.0   12.0 11.0     0.0   0.0     7.0   *   23.0 18 0 3   0 0     0   2   12 11     0 0   7     23
696081 MN Mcleod 43 school 2700128 2859 Independent Districts and Schools GLENCOE-SILVER LAKE SCHOOL DISTRICT 270012800632 10 BAKER ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 02 2017   kindergarten 84.0 0.0 24.0   0.0 0.0     0.0   6.0   63.0 51.0     13.0   0.0     45.0   9.0   114.0 84 0 24   0 0     0   6   63 51     13 0   45 9   114
696082 MN Mcleod 43 school 2700128 2859 Independent Districts and Schools GLENCOE-SILVER LAKE SCHOOL DISTRICT 270012800632 10 BAKER ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 02 2017   grade_1 84.0 0.0 28.0   0.0 0.0     0.0   5.0   61.0 56.0     8.0   0.0     52.0   9.0   117.0 84 0 28   0 0     0   5   61 56     8 0   52 9   117
696083 MN Mcleod 43 school 2700128 2859 Independent Districts and Schools GLENCOE-SILVER LAKE SCHOOL DISTRICT 270012800632 10 BAKER ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 02 2017   grade_2 77.0 0.0 30.0   0.0 0.0     0.0   4.0   54.0 57.0     12.0   0.0     58.0   8.0   111.0 77 0 30   0 0     0   4   54 57     12 0   58 8   111
696084 MN Mcleod 43 school 2700128 2859 Independent Districts and Schools GLENCOE-SILVER LAKE SCHOOL DISTRICT 270012800632 10 BAKER ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 02 2017   pk_12_total 263.0 0.0 85.0   0.0 0.0     0.0   17.0   190.0 175.0     33.0   0.0     162.0   49.0   365.0 263 0 85   0 0     0   17   190 175     33 0   162 49   365
696328 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124000978 130 HIAWATHA ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 02 2017   kindergarten 53.0 12.0 10.0   0.0 2.0     0.0   6.0   48.0 35.0     15.0   0.0     26.0   5.0   83.0 53 12 10   0 2     0   6   48 35     15 0   26 5   83
696329 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124000978 130 HIAWATHA ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 02 2017   grade_1 48.0 12.0 11.0   2.0 1.0     0.0   5.0   39.0 40.0     9.0   0.0     33.0   11.0   79.0 48 12 11   2 1     0   5   39 40     9 0   33 11   79
696330 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124000978 130 HIAWATHA ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 02 2017   grade_2 52.0 13.0 6.0   2.0 4.0     0.0   6.0   44.0 39.0     4.0   *     26.0   7.0   83.0 52 13 6   2 4     0   6   44 39     4     26 7   83
696331 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124000978 130 HIAWATHA ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 02 2017   pk_12_total 153.0 37.0 27.0   4.0 7.0     0.0   17.0   131.0 114.0     28.0   *     85.0   23.0   245.0 153 37 27   4 7     0   17   131 114     28     85 23   245
696429 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124001057 167 LK NOKOMIS COMM-WENONAH CAMPUS Elementary School (Grades PK-6) Regular School No Elementary KG 02 2017   kindergarten 83.0 10.0 11.0   0.0 1.0     0.0   4.0   59.0 50.0     7.0   2.0     41.0   7.0   109.0 83 10 11   0 1     0   4   59 50     7 2   41 7   109
696430 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124001057 167 LK NOKOMIS COMM-WENONAH CAMPUS Elementary School (Grades PK-6) Regular School No Elementary KG 02 2017   grade_1 63.0 7.0 13.0   2.0 6.0     0.0   3.0   51.0 43.0     9.0   0.0     41.0   12.0   94.0 63 7 13   2 6     0   3   51 43     9 0   41 12   94
696431 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124001057 167 LK NOKOMIS COMM-WENONAH CAMPUS Elementary School (Grades PK-6) Regular School No Elementary KG 02 2017   grade_2 57.0 16.0 16.0   2.0 5.0     0.0   6.0   53.0 49.0     14.0   3.0     45.0   12.0   102.0 57 16 16   2 5     0   6   53 49     14 3   45 12   102
696432 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124001057 167 LK NOKOMIS COMM-WENONAH CAMPUS Elementary School (Grades PK-6) Regular School No Elementary KG 02 2017   pk_12_total 203.0 33.0 40.0   4.0 12.0     0.0   13.0   163.0 142.0     30.0   5.0     127.0   31.0   305.0 203 33 40   4 12     0   13   163 142     30 5   127 31   305
690842 MN Anoka 2 school 2733330 16 Independent Districts and Schools SPRING LAKE PARK PUBLIC SCHOOLS 273333001461 772 NORTHPOINT ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 03 2017   kindergarten 127.0 8.0 14.0   0.0 19.0     0.0   15.0   92.0 91.0     18.0   1.0     44.0   24.0   183.0 127 8 14   0 19     0   15   92 91     18 1   44 24   183
690843 MN Anoka 2 school 2733330 16 Independent Districts and Schools SPRING LAKE PARK PUBLIC SCHOOLS 273333001461 772 NORTHPOINT ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 03 2017   grade_1 132.0 11.0 10.0   0.0 10.0     0.0   21.0   109.0 75.0     14.0   0.0     50.0   21.0   184.0 132 11 10   0 10     0   21   109 75     14 0   50 21   184
690844 MN Anoka 2 school 2733330 16 Independent Districts and Schools SPRING LAKE PARK PUBLIC SCHOOLS 273333001461 772 NORTHPOINT ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 03 2017   grade_2 114.0 17.0 6.0   1.0 16.0     0.0   13.0   87.0 80.0     11.0   0.0     42.0   13.0   167.0 114 17 6   1 16     0   13   87 80     11 0   42 13   167
690845 MN Anoka 2 school 2733330 16 Independent Districts and Schools SPRING LAKE PARK PUBLIC SCHOOLS 273333001461 772 NORTHPOINT ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 03 2017   grade_3 137.0 13.0 18.0   1.0 14.0     0.0   14.0   111.0 86.0     17.0   0.0     49.0   23.0   197.0 137 13 18   1 14     0   14   111 86     17 0   49 23   197
690846 MN Anoka 2 school 2733330 16 Independent Districts and Schools SPRING LAKE PARK PUBLIC SCHOOLS 273333001461 772 NORTHPOINT ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 03 2017   pk_12_total 510.0 49.0 48.0   2.0 59.0     0.0   63.0   399.0 332.0     60.0   1.0     185.0   81.0   731.0 510 49 48   2 59     0   63   399 332     60 1   185 81   731
690857 MN Anoka 2 school 2733330 16 Independent Districts and Schools SPRING LAKE PARK PUBLIC SCHOOLS 273333001462 775 Park Terrace Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 03 2017   kindergarten 94.0 17.0 29.0   0.0 13.0     1.0   25.0   92.0 87.0     35.0   2.0     103.0   24.0   179.0 94 17 29   0 13     1   25   92 87     35 2   103 24   179
690858 MN Anoka 2 school 2733330 16 Independent Districts and Schools SPRING LAKE PARK PUBLIC SCHOOLS 273333001462 775 Park Terrace Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 03 2017   grade_1 86.0 29.0 20.0   0.0 19.0     0.0   22.0   87.0 89.0     35.0   *     104.0   29.0   176.0 86 29 20   0 19     0   22   87 89     35     104 29   176
690859 MN Anoka 2 school 2733330 16 Independent Districts and Schools SPRING LAKE PARK PUBLIC SCHOOLS 273333001462 775 Park Terrace Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 03 2017   grade_2 80.0 28.0 24.0   1.0 16.0     0.0   18.0   88.0 79.0     30.0   1.0     98.0   23.0   167.0 80 28 24   1 16     0   18   88 79     30 1   98 23   167
690860 MN Anoka 2 school 2733330 16 Independent Districts and Schools SPRING LAKE PARK PUBLIC SCHOOLS 273333001462 775 Park Terrace Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 03 2017   grade_3 95.0 32.0 29.0   1.0 14.0     0.0   18.0   96.0 93.0     33.0   *     113.0   26.0   189.0 95 32 29   1 14     0   18   96 93     33     113 26   189
690861 MN Anoka 2 school 2733330 16 Independent Districts and Schools SPRING LAKE PARK PUBLIC SCHOOLS 273333001462 775 Park Terrace Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 03 2017   pk_12_total 355.0 106.0 102.0   2.0 62.0     1.0   83.0   363.0 348.0     133.0   6.0     418.0   102.0   711.0 355 106 102   2 62     1   83   363 348     133 6   418 102   711
691012 MN Benton 5 school 2712240 51 Independent Districts and Schools FOLEY PUBLIC SCHOOL DISTRICT 271224000590 10 FOLEY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 03 2017   early_childhood_special_ed 26.0 0.0 0.0   0.0 0.0     0.0   0.0   20.0 6.0     0.0   0.0     10.0   *   26.0 26 0 0   0 0     0   0   20 6     0 0   10     26
691013 MN Benton 5 school 2712240 51 Independent Districts and Schools FOLEY PUBLIC SCHOOL DISTRICT 271224000590 10 FOLEY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 03 2017   kindergarten 140.0 0.0 1.0   1.0 0.0     0.0   1.0   65.0 78.0     0.0   0.0     40.0   14.0   143.0 140 0 1   1 0     0   1   65 78     0 0   40 14   143
691014 MN Benton 5 school 2712240 51 Independent Districts and Schools FOLEY PUBLIC SCHOOL DISTRICT 271224000590 10 FOLEY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 03 2017   grade_1 120.0 0.0 0.0   0.0 0.0     0.0   0.0   57.0 63.0     0.0   0.0     35.0   16.0   120.0 120 0 0   0 0     0   0   57 63     0 0   35 16   120
691015 MN Benton 5 school 2712240 51 Independent Districts and Schools FOLEY PUBLIC SCHOOL DISTRICT 271224000590 10 FOLEY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 03 2017   grade_2 135.0 0.0 1.0   3.0 0.0     0.0   3.0   77.0 65.0     0.0   0.0     47.0   26.0   142.0 135 0 1   3 0     0   3   77 65     0 0   47 26   142
691016 MN Benton 5 school 2712240 51 Independent Districts and Schools FOLEY PUBLIC SCHOOL DISTRICT 271224000590 10 FOLEY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 03 2017   grade_3 126.0 1.0 1.0   0.0 1.0     0.0   0.0   76.0 53.0     0.0   1.0     40.0   20.0   129.0 126 1 1   0 1     0   0   76 53     0 1   40 20   129
691017 MN Benton 5 school 2712240 51 Independent Districts and Schools FOLEY PUBLIC SCHOOL DISTRICT 271224000590 10 FOLEY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 03 2017   pk_12_total 547.0 1.0 3.0   4.0 1.0     0.0   4.0   295.0 265.0     0.0   1.0     172.0   102.0   560.0 547 1 3   4 1     0   4   295 265     0 1   172 102   560
691335 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 2017   grade_1 85.0 2.0 25.0   2.0 0.0     0.0   3.0   64.0 53.0     16.0   0.0     69.0   25.0   117.0 85 2 25   2 0     0   3   64 53     16 0   69 25   117
691336 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 2017   grade_2 82.0 2.0 18.0   2.0 0.0     1.0   3.0   57.0 51.0     14.0   0.0     53.0   25.0   108.0 82 2 18   2 0     1   3   57 51     14 0   53 25   108
691337 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 2017   grade_3 79.0 2.0 18.0   1.0 0.0     0.0   3.0   52.0 51.0     16.0   0.0     46.0   22.0   103.0 79 2 18   1 0     0   3   52 51     16 0   46 22   103
691338 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 2017   pk_12_total 246.0 6.0 61.0   5.0 0.0     1.0   9.0   173.0 155.0     46.0   0.0     168.0   72.0   328.0 246 6 61   5 0     1   9   173 155     46 0   168 72   328
691430 MN Cottonwood 17 school 2742780 177 Independent Districts and Schools WINDOM PUBLIC SCHOOL DISTRICT 274278001816 30 WINFAIR ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 03 2017   kindergarten 61.0 3.0 15.0   0.0 2.0     2.0   3.0   41.0 45.0     10.0   0.0     39.0   9.0   86.0 61 3 15   0 2     2   3   41 45     10 0   39 9   86
691431 MN Cottonwood 17 school 2742780 177 Independent Districts and Schools WINDOM PUBLIC SCHOOL DISTRICT 274278001816 30 WINFAIR ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 03 2017   grade_1 60.0 0.0 13.0   0.0 1.0     2.0   5.0   40.0 41.0     11.0   0.0     43.0   12.0   81.0 60 0 13   0 1     2   5   40 41     11 0   43 12   81
691432 MN Cottonwood 17 school 2742780 177 Independent Districts and Schools WINDOM PUBLIC SCHOOL DISTRICT 274278001816 30 WINFAIR ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 03 2017   grade_2 56.0 0.0 18.0   0.0 2.0     1.0   1.0   47.0 31.0     16.0   0.0     41.0   9.0   78.0 56 0 18   0 2     1   1   47 31     16 0   41 9   78
691433 MN Cottonwood 17 school 2742780 177 Independent Districts and Schools WINDOM PUBLIC SCHOOL DISTRICT 274278001816 30 WINFAIR ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 03 2017   grade_3 66.0 1.0 13.0   1.0 5.0     0.0   1.0   49.0 38.0     7.0   0.0     34.0   13.0   87.0 66 1 13   1 5     0   1   49 38     7 0   34 13   87
691434 MN Cottonwood 17 school 2742780 177 Independent Districts and Schools WINDOM PUBLIC SCHOOL DISTRICT 274278001816 30 WINFAIR ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 03 2017   pk_12_total 243.0 4.0 59.0   1.0 10.0     5.0   10.0   177.0 155.0     44.0   0.0     157.0   43.0   332.0 243 4 59   1 10     5   10   177 155     44 0   157 43   332
694071 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384002540 510 LINWOOD MONROE ARTS PLUS LOWER Elementary School (Grades PK-6) Regular School No Elementary KG 03 2017   kindergarten 18.0 20.0 9.0   0.0 22.0     0.0   7.0   42.0 34.0     39.0   2.0     56.0   10.0   76.0 18 20 9   0 22     0   7   42 34     39 2   56 10   76
694072 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384002540 510 LINWOOD MONROE ARTS PLUS LOWER Elementary School (Grades PK-6) Regular School No Elementary KG 03 2017   grade_1 26.0 20.0 12.0   0.0 16.0     0.0   7.0   40.0 41.0     30.0   0.0     54.0   18.0   81.0 26 20 12   0 16     0   7   40 41     30 0   54 18   81
694073 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384002540 510 LINWOOD MONROE ARTS PLUS LOWER Elementary School (Grades PK-6) Regular School No Elementary KG 03 2017   grade_2 28.0 17.0 9.0   0.0 24.0     0.0   2.0   41.0 39.0     36.0   1.0     56.0   10.0   80.0 28 17 9   0 24     0   2   41 39     36 1   56 10   80
694074 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384002540 510 LINWOOD MONROE ARTS PLUS LOWER Elementary School (Grades PK-6) Regular School No Elementary KG 03 2017   grade_3 15.0 32.0 9.0   0.0 17.0     0.0   7.0   36.0 44.0     36.0   2.0     57.0   11.0   80.0 15 32 9   0 17     0   7   36 44     36 2   57 11   80
694075 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384002540 510 LINWOOD MONROE ARTS PLUS LOWER Elementary School (Grades PK-6) Regular School No Elementary KG 03 2017   pk_12_total 87.0 89.0 39.0   0.0 79.0     0.0   23.0   159.0 158.0     141.0   5.0     223.0   49.0   317.0 87 89 39   0 79     0   23   159 158     141 5   223 49   317
694289 MN Saint Louis 69 school 2708910 695 Independent Districts and Schools CHISHOLM PUBLIC SCHOOL DISTRICT 270891000360 101 VAUGHAN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 03 2017   early_childhood_special_ed 8.0 0.0 0.0   1.0 0.0     0.0   0.0   7.0 2.0         *         *   9.0 8 0 0   1 0     0   0   7 2                 9
694290 MN Saint Louis 69 school 2708910 695 Independent Districts and Schools CHISHOLM PUBLIC SCHOOL DISTRICT 270891000360 101 VAUGHAN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 03 2017   kindergarten 55.0 1.0 0.0   0.0 0.0     0.0   1.0   27.0 30.0         *     30.0   6.0   57.0 55 1 0   0 0     0   1   27 30           30 6   57
694291 MN Saint Louis 69 school 2708910 695 Independent Districts and Schools CHISHOLM PUBLIC SCHOOL DISTRICT 270891000360 101 VAUGHAN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 03 2017   grade_1 50.0 1.0 1.0   1.0 0.0     0.0   0.0   19.0 34.0     0.0   0.0         9.0   53.0 50 1 1   1 0     0   0   19 34     0 0     9   53
694292 MN Saint Louis 69 school 2708910 695 Independent Districts and Schools CHISHOLM PUBLIC SCHOOL DISTRICT 270891000360 101 VAUGHAN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 03 2017   grade_2 54.0 2.0 0.0   5.0 0.0     0.0   0.0   27.0 34.0     0.0   0.0     29.0   7.0   61.0 54 2 0   5 0     0   0   27 34     0 0   29 7   61
694293 MN Saint Louis 69 school 2708910 695 Independent Districts and Schools CHISHOLM PUBLIC SCHOOL DISTRICT 270891000360 101 VAUGHAN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 03 2017   grade_3 52.0 1.0 1.0   0.0 0.0     0.0   2.0   31.0 25.0     0.0   0.0     32.0   5.0   56.0 52 1 1   0 0     0   2   31 25     0 0   32 5   56
694294 MN Saint Louis 69 school 2708910 695 Independent Districts and Schools CHISHOLM PUBLIC SCHOOL DISTRICT 270891000360 101 VAUGHAN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 03 2017   pk_12_total 219.0 5.0 2.0   7.0 0.0     0.0   3.0   111.0 125.0     0.0   0.0     122.0   36.0   236.0 219 5 2   7 0     0   3   111 125     0 0   122 36   236
694966 MN Waseca 81 school 2741880 829 Independent Districts and Schools WASECA PUBLIC SCHOOL DISTRICT 274188001747 20 HARTLEY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 03 2017   kindergarten 94.0 5.0 12.0   3.0 3.0     0.0   5.0   69.0 53.0     4.0   0.0     62.0   25.0   122.0 94 5 12   3 3     0   5   69 53     4 0   62 25   122
694967 MN Waseca 81 school 2741880 829 Independent Districts and Schools WASECA PUBLIC SCHOOL DISTRICT 274188001747 20 HARTLEY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 03 2017   grade_1 68.0 7.0 14.0   0.0 3.0     0.0   2.0   41.0 53.0     8.0   1.0     37.0   16.0   94.0 68 7 14   0 3     0   2   41 53     8 1   37 16   94
694968 MN Waseca 81 school 2741880 829 Independent Districts and Schools WASECA PUBLIC SCHOOL DISTRICT 274188001747 20 HARTLEY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 03 2017   grade_2 103.0 5.0 10.0   0.0 0.0     0.0   7.0   60.0 65.0     6.0   0.0     46.0   18.0   125.0 103 5 10   0 0     0   7   60 65     6 0   46 18   125
694969 MN Waseca 81 school 2741880 829 Independent Districts and Schools WASECA PUBLIC SCHOOL DISTRICT 274188001747 20 HARTLEY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 03 2017   grade_3 97.0 5.0 10.0   0.0 1.0     0.0   4.0   57.0 60.0     7.0   1.0     51.0   18.0   117.0 97 5 10   0 1     0   4   57 60     7 1   51 18   117
694970 MN Waseca 81 school 2741880 829 Independent Districts and Schools WASECA PUBLIC SCHOOL DISTRICT 274188001747 20 HARTLEY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 03 2017   pk_12_total 362.0 22.0 46.0   3.0 7.0     0.0   18.0   227.0 231.0     25.0   2.0     196.0   77.0   458.0 362 22 46   3 7     0   18   227 231     25 2   196 77   458
694988 MN Washington 82 school 2712270 831 Independent Districts and Schools FOREST LAKE PUBLIC SCHOOL DISTRICT 271227000596 627 Forest View Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 03 2017   kindergarten 88.0 1.0 7.0   0.0 2.0     0.0   5.0   51.0 52.0     4.0   0.0     34.0   18.0   103.0 88 1 7   0 2     0   5   51 52     4 0   34 18   103

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