Data source: Big Local News · About: Big Local

942 rows where grade = "grade_1", state = "MN" and year = 2019 sorted by ccd_school_high_grade

View and edit SQL

year

  • 2019 · 942

grade

  • grade_1 · 942
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
1948464 MN Mcleod 43 school 2714970 423 Independent Districts and Schools HUTCHINSON PUBLIC SCHOOL DISTRICT 271497002198 60 HUTCHINSON WEST ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 01 2019   grade_1 157.0 0.0 19.0   0.0 1.0     1.0   7.0   80.0 105.0     7.0   1.0     56.0   27.0   185.0 157 0 19   0 1     1   7   80 105     7 1   56 27   185
1948721 MN Nicollet 52 school 2733870 508 Independent Districts and Schools ST. PETER PUBLIC SCHOOL DISTRICT 273387001639 50 South Elementary Center Elementary School (Grades PK-6) Regular School No Elementary KG 01 2019   grade_1 116.0 14.0 18.0   0.0 0.0     0.0   6.0   88.0 66.0     15.0   0.0     57.0   35.0   154.0 116 14 18   0 0     0   6   88 66     15 0   57 35   154
1948917 MN Otter Tail 56 school 2711880 544 Independent Districts and Schools FERGUS FALLS PUBLIC SCHOOL DISTRICT 271188000581 180 MCKINLEY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 01 2019   grade_1 38.0 4.0 1.0   0.0 1.0     0.0   1.0   23.0 22.0     *   0.0     19.0   *   45.0 38 4 1   0 1     0   1   23 22       0   19     45
1949028 MN Polk 60 school 2709720 593 Independent Districts and Schools CROOKSTON PUBLIC SCHOOL DISTRICT 270972000416 10 WASHINGTON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 01 2019   grade_1 54.0 1.0 24.0   3.0 0.0     0.0   5.0   38.0 49.0     5.0   8.0     46.0   13.0   87.0 54 1 24   3 0     0   5   38 49     5 8   46 13   87
1949286 MN Washington 82 school 2742360 624 Independent Districts and Schools WHITE BEAR LAKE SCHOOL DISTRICT 274236004409 830 HUGO ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 01 2019   grade_1 131.0 7.0 5.0   2.0 5.0     1.0   8.0   79.0 80.0     5.0   0.0     26.0   20.0   159.0 131 7 5   2 5     1   8   79 80     5 0   26 20   159
1951439 MN Pipestone 59 school 2700108 2689 Independent Districts and Schools PIPESTONE AREA SCHOOL DISTRICT 270010801261 2 BROWN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 01 2019   grade_1 59.0 0.0 10.0   0.0 0.0     0.0   6.0   40.0 35.0     *   0.0     36.0   *   75.0 59 0 10   0 0     0   6   40 35       0   36     75
1952889 MN Ramsey 62 school 2700380 4213 Charter Schools Prodeo Academy 270038005150 20 Prodeo Academy St. Paul Elementary School (Grades PK-6) Regular School Yes Elementary KG 01 2019   grade_1 0.0 8.0 3.0   0.0 22.0     0.0   1.0   20.0 14.0     25.0   0.0     30.0   1.0   34.0 0 8 3   0 22     0   1   20 14     25 0   30 1   34
1956127 MN Hennepin 27 school 2731780 281 Independent Districts and Schools ROBBINSDALE PUBLIC SCHOOL DISTRICT 273178002441 103 EARLY CHILDHOOD SPECIAL EDUCATION Special Education Special Education School No Elementary PK 01 2019   grade_1 0.0 1.0 0.0   0.0 0.0     0.0   0.0   1.0 0.0     *   *         *   1.0 0 1 0   0 0     0   0   1 0                 1
1947440 MN Goodhue 25 school 2730480 256 Independent Districts and Schools RED WING PUBLIC SCHOOL DISTRICT 273048001297 541 SUNNYSIDE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 02 2019   grade_1 168.0 10.0 18.0   6.0 1.0     0.0   21.0   120.0 104.0     9.0   5.0     84.0   43.0   224.0 168 10 18   6 1     0   21   120 104     9 5   84 43   224
1947744 MN Hennepin 27 school 2725080 278 Independent Districts and Schools ORONO PUBLIC SCHOOL DISTRICT 272508001200 661 SCHUMANN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 02 2019   grade_1 159.0 3.0 11.0   0.0 3.0     0.0   12.0   109.0 79.0     7.0   0.0     13.0   14.0   188.0 159 3 11   0 3     0   12   109 79     7 0   13 14   188
1948432 MN Lyon 42 school 2718940 413 Independent Districts and Schools MARSHALL PUBLIC SCHOOL DISTRICT 271894000891 2 PARK SIDE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 02 2019   grade_1 95.0 17.0 32.0   0.0 21.0     0.0   9.0   84.0 90.0     46.0   0.0     93.0   29.0   174.0 95 17 32   0 21     0   9   84 90     46 0   93 29   174
1948503 MN Marshall 45 school 2723550 441 Independent Districts and Schools MARSHALL COUNTY CENTRAL SCHOOLS 272355001159 30 VIKING ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 02 2019   grade_1 28.0 0.0 0.0   0.0 0.0     0.0   1.0   11.0 18.0     0.0   0.0     10.0   3.0   29.0 28 0 0   0 0     0   1   11 18     0 0   10 3   29
1948568 MN Mille Lacs 48 school 2730030 477 Independent Districts and Schools PRINCETON PUBLIC SCHOOL DISTRICT 273003001274 1 Princeton Primary School Elementary School (Grades PK-6) Regular School No Elementary PK 02 2019   grade_1 246.0 1.0 2.0   1.0 2.0     0.0   7.0   141.0 118.0     *   *         *   259.0 246 1 2   1 2     0   7   141 118                 259
1948578 MN Mille Lacs 48 school 2725050 480 Independent Districts and Schools ONAMIA PUBLIC SCHOOL DISTRICT 272505001195 10 Onamia Primary School Elementary School (Grades PK-6) Regular School No Elementary PK 02 2019   grade_1 13.0 0.0 0.0   10.0 0.0     0.0   2.0   11.0 14.0     0.0   0.0     19.0   7.0   25.0 13 0 0   10 0     0   2   11 14     0 0   19 7   25
1948753 MN Olmsted 55 school 2707350 531 Independent Districts and Schools BYRON PUBLIC SCHOOL DISTRICT 270735004958 60 Byron Primary School Elementary School (Grades PK-6) Regular School No Elementary PK 02 2019   grade_1 140.0 0.0 2.0   0.0 1.0     0.0   7.0   74.0 76.0     1.0   0.0     14.0   23.0   150.0 140 0 2   0 1     0   7   74 76     1 0   14 23   150
1948769 MN Olmsted 55 school 2738160 534 Independent Districts and Schools STEWARTVILLE PUBLIC SCHOOL DISTRICT 273816001651 11 BONNER ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 02 2019   grade_1 151.0 0.0 7.0   0.0 0.0     0.0   8.0   83.0 83.0     3.0   2.0     36.0   35.0   166.0 151 0 7   0 0     0   8   83 83     3 2   36 35   166
1948788 MN Olmsted 55 school 2731800 535 Independent Districts and Schools ROCHESTER PUBLIC SCHOOL DISTRICT 273180000987 116 CHURCHILL ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 02 2019   grade_1 58.0 10.0 3.0   0.0 8.0     0.0   2.0   40.0 41.0     10.0   0.0     24.0   10.0   81.0 58 10 3   0 8     0   2   40 41     10 0   24 10   81
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
1949042 MN Polk 60 school 2711130 595 Independent Districts and Schools EAST GRAND FORKS PUBLIC SCHOOL DIST 271113000497 120 NEW HEIGHTS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 02 2019   grade_1 112.0 21.0 15.0   1.0 0.0     0.0   12.0   86.0 75.0     18.0   0.0     65.0   29.0   161.0 112 21 15   1 0     0   12   86 75     18 0   65 29   161
1949436 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384004682 463 L'etoile Du Nord French Immersion L Elementary School (Grades PK-6) Regular School No Elementary PK 02 2019   grade_1 41.0 23.0 13.0   1.0 4.0     0.0   9.0   33.0 58.0     18.0   0.0     38.0   2.0   91.0 41 23 13   1 4     0   9   33 58     18 0   38 2   91
1949831 MN Saint Louis 69 school 2713980 701 Independent Districts and Schools HIBBING PUBLIC SCHOOL DISTRICT 271398001520 140 GREENHAVEN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 02 2019   grade_1 69.0 3.0 3.0   0.0 0.0     0.0   8.0   44.0 39.0     0.0   0.0     42.0   16.0   83.0 69 3 3   0 0     0   8   44 39     0 0   42 16   83
1949835 MN Saint Louis 69 school 2713980 701 Independent Districts and Schools HIBBING PUBLIC SCHOOL DISTRICT 271398001528 160 WASHINGTON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 02 2019   grade_1 77.0 1.0 1.0   1.0 0.0     0.0   7.0   46.0 41.0     1.0   0.0     41.0   17.0   87.0 77 1 1   1 0     0   7   46 41     1 0   41 17   87
1949865 MN Saint Louis 69 school 2741040 706 Independent Districts and Schools VIRGINIA PUBLIC SCHOOL DISTRICT 274104002552 112 PARKVIEW ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 02 2019   grade_1 101.0 3.0 4.0   3.0 0.0     0.0   13.0   74.0 50.0     0.0   2.0     61.0   22.0   124.0 101 3 4   3 0     0   13   74 50     0 2   61 22   124
1949956 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 2019   grade_1 109.0 0.0 9.0   2.0 2.0     1.0   4.0   54.0 73.0     3.0   0.0     30.0   17.0   127.0 109 0 9   2 2     1   4   54 73     3 0   30 17   127
1950081 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 2019   grade_1 191.0 2.0 4.0   1.0 1.0     0.0   7.0   88.0 118.0     5.0   1.0     47.0   24.0   206.0 191 2 4   1 1     0   7   88 118     5 1   47 24   206
1950090 MN Sherburne 71 school 2705460 727 Independent Districts and Schools BIG LAKE PUBLIC SCHOOL DISTRICT 270546004180 40 LIBERTY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 02 2019   grade_1 195.0 8.0 8.0   1.0 3.0     0.0   7.0   112.0 110.0     4.0   0.0     56.0   31.0   222.0 195 8 8   1 3     0   7   112 110     4 0   56 31   222
1950131 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 2019   grade_1 170.0 1.0 4.0   0.0 1.0     0.0   9.0   91.0 94.0     2.0   *     46.0   25.0   185.0 170 1 4   0 1     0   9   91 94     2     46 25   185
1950551 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 2019   grade_1 171.0 11.0 6.0   0.0 4.0     0.0   12.0   106.0 98.0     6.0   0.0     17.0   26.0   204.0 171 11 6   0 4     0   12   106 98     6 0   17 26   204
1950937 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 2019   grade_1 138.0 1.0 6.0   0.0 3.0     0.0   9.0   80.0 77.0     4.0   *     52.0   20.0   157.0 138 1 6   0 3     0   9   80 77     4     52 20   157
1950942 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 2019   grade_1 132.0 0.0 6.0   0.0 0.0     0.0   5.0   83.0 60.0     0.0   *     33.0   31.0   143.0 132 0 6   0 0     0   5   83 60     0     33 31   143
1951085 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 2019   grade_1 168.0 1.0 2.0   0.0 2.0     0.0   8.0   87.0 94.0     0.0   0.0     35.0   35.0   181.0 168 1 2   0 2     0   8   87 94     0 0   35 35   181
1951361 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 KG 02 2019   grade_1 53.0 0.0 4.0   0.0 0.0     0.0   0.0   28.0 29.0     *   *     27.0   10.0   57.0 53 0 4   0 0     0   0   28 29           27 10   57
1951506 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 2019   grade_1 100.0 0.0 3.0   0.0 1.0     0.0   1.0   53.0 52.0     0.0   0.0     24.0   12.0   105.0 100 0 3   0 1     0   1   53 52     0 0   24 12   105
1951553 MN Mcleod 43 school 2700128 2859 Independent Districts and Schools GLENCOE-SILVER LAKE SCHOOL DISTRICT 270012800632 10 Lincoln Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 02 2019   grade_1 85.0 0.0 21.0   1.0 1.0     0.0   2.0   60.0 50.0     6.0   3.0     33.0   16.0   110.0 85 0 21   1 1     0   2   60 50     6 3   33 16   110
1951805 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 KG 02 2019   grade_1 64.0 15.0 7.0   2.0 0.0     0.0   7.0   48.0 47.0     7.0   0.0     28.0   8.0   95.0 64 15 7   2 0     0   7   48 47     7 0   28 8   95
1951907 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 2019   grade_1 70.0 13.0 12.0   3.0 1.0     0.0   8.0   59.0 48.0     6.0   1.0     48.0   19.0   107.0 70 13 12   3 1     0   8   59 48     6 1   48 19   107
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
1946284 MN Beltrami 4 school 2704440 31 Independent Districts and Schools BEMIDJI PUBLIC SCHOOL DISTRICT 270444000196 40 J.W. SMITH ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 03 2019   grade_1 12.0 2.0 1.0   31.0 0.0     0.0   9.0   30.0 25.0     0.0   3.0     47.0   *   55.0 12 2 1   31 0     0   9   30 25     0 3   47     55
1946291 MN Beltrami 4 school 2704440 31 Independent Districts and Schools BEMIDJI PUBLIC SCHOOL DISTRICT 270444000191 50 CENTRAL ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 03 2019   grade_1 18.0 0.0 1.0   4.0 0.0     0.0   6.0   15.0 14.0     0.0   1.0     24.0   9.0   29.0 18 0 1   4 0     0   6   15 14     0 1   24 9   29
1946297 MN Beltrami 4 school 2704440 31 Independent Districts and Schools BEMIDJI PUBLIC SCHOOL DISTRICT 270444000192 60 Lincoln Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 03 2019   grade_1 74.0 0.0 0.0   17.0 0.0     0.0   13.0   71.0 33.0     0.0   4.0     52.0   21.0   104.0 74 0 0   17 0     0   13   71 33     0 4   52 21   104
1946303 MN Beltrami 4 school 2704440 31 Independent Districts and Schools BEMIDJI PUBLIC SCHOOL DISTRICT 270444000197 80 SOLWAY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 03 2019   grade_1 24.0 0.0 2.0   6.0 0.0     0.0   1.0   20.0 13.0     0.0   0.0     22.0   *   33.0 24 0 2   6 0     0   1   20 13     0 0   22     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
1946376 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 2019   grade_1 145.0 0.0 1.0   2.0 0.0     0.0   0.0   77.0 71.0     0.0   1.0     43.0   19.0   148.0 145 0 1   2 0     0   0   77 71     0 1   43 19   148
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
1946795 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 2019   grade_1 56.0 1.0 21.0   0.0 3.0     1.0   2.0   45.0 39.0     18.0   0.0     40.0   15.0   84.0 56 1 21   0 3     1   2   45 39     18 0   40 15   84
1949797 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 2019   grade_1 39.0 2.0 0.0   0.0 0.0     0.0   2.0   24.0 19.0     0.0   0.0     12.0   9.0   43.0 39 2 0   0 0     0   2   24 19     0 0   12 9   43
1950489 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 2019   grade_1 88.0 7.0 14.0   0.0 0.0     0.0   5.0   61.0 53.0     6.0   0.0     49.0   17.0   114.0 88 7 14   0 0     0   5   61 53     6 0   49 17   114
1950510 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 PK 03 2019   grade_1 73.0 6.0 11.0   0.0 5.0     0.0   7.0   42.0 60.0     8.0   1.0     43.0   20.0   102.0 73 6 11   0 5     0   7   42 60     8 1   43 20   102
1950873 MN Wright 86 school 2710170 879 Independent Districts and Schools DELANO PUBLIC SCHOOL DISTRICT 271017000436 10 DELANO ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 03 2019   grade_1 146.0 1.0 2.0   0.0 0.0     0.0   6.0   83.0 72.0     1.0   1.0     16.0   30.0   155.0 146 1 2   0 0     0   6   83 72     1 1   16 30   155
1951100 MN Pope 61 school 2700019 2149 Independent Districts and Schools MINNEWASKA SCHOOL DISTRICT 270001903536 70 MINNEWASKA AREA ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 03 2019   grade_1 89.0 0.0 4.0   0.0 1.0     0.0   2.0   50.0 46.0     *   *         *   96.0 89 0 4   0 1     0   2   50 46                 96
1951192 MN Todd 77 school 2733900 2170 Independent Districts and Schools STAPLES-MOTLEY SCHOOL DISTRICT 273390001643 30 Staples-Motley Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 03 2019   grade_1 75.0 1.0 3.0   0.0 3.0     0.0   5.0   45.0 42.0     0.0   3.0     42.0   13.0   87.0 75 1 3   0 3     0   5   45 42     0 3   42 13   87
1951650 MN Wabasha 79 school 2700287 2899 Independent Districts and Schools PLAINVIEW-ELGIN-MILLVILLE 270028703701 10 PLAINVIEW-ELGIN-MILLVILLE PK-3 Elementary School (Grades PK-6) Regular School No Elementary PK 03 2019   grade_1 95.0 0.0 12.0   0.0 0.0     0.0   0.0   57.0 50.0     5.0   0.0     30.0   10.0   107.0 95 0 12   0 0     0   0   57 50     5 0   30 10   107
1951738 MN Douglas 21 school 2700382 2908 Independent Districts and Schools BRANDON-EVANSVILLE PUBLIC SCHOOLS 270038204738 1 Brandon Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 03 2019   grade_1 48.0 0.0 0.0   0.0 0.0     0.0   2.0   29.0 21.0     0.0   1.0     11.0   10.0   50.0 48 0 0   0 0     0   2   29 21     0 1   11 10   50
1951754 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124001861 104 LAKE HARRIET LOWER ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 03 2019   grade_1 118.0 3.0 2.0   0.0 5.0     0.0   10.0   64.0 74.0     2.0   0.0     3.0   8.0   138.0 118 3 2   0 5     0   10   64 74     2 0   3 8   138
1945922 MN Aitkin 1 school 2714010 2 Independent Districts and Schools HILL CITY PUBLIC SCHOOL DISTRICT 271401000723 1 HILL CITY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2019   grade_1 18.0 0.0 0.0   0.0 0.0     0.0   1.0   10.0 9.0     0.0   0.0     11.0   5.0   19.0 18 0 0   0 0     0   1   10 9     0 0   11 5   19
1946174 MN Anoka 2 school 2712420 14 Independent Districts and Schools FRIDLEY PUBLIC SCHOOL DISTRICT 271242000612 546 HAYES ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2019   grade_1 28.0 32.0 8.0   1.0 6.0     0.0   9.0   45.0 39.0     17.0   1.0     51.0   12.0   84.0 28 32 8   1 6     0   9   45 39     17 1   51 12   84
1946180 MN Anoka 2 school 2712420 14 Independent Districts and Schools FRIDLEY PUBLIC SCHOOL DISTRICT 271242000614 550 STEVENSON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2019   grade_1 38.0 38.0 19.0   2.0 6.0     0.0   6.0   63.0 46.0     19.0   1.0     76.0   19.0   109.0 38 38 19   2 6     0   6   63 46     19 1   76 19   109
1946207 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 04 2019   grade_1 85.0 10.0 2.0   1.0 5.0     1.0   7.0   63.0 48.0     *   *     12.0   *   111.0 85 10 2   1 5     1   7   63 48           12     111
1946213 MN Anoka 2 school 2733330 16 Independent Districts and Schools SPRING LAKE PARK PUBLIC SCHOOLS 273333001467 774 Woodcrest Elementary Spanish Immersion Elementary School (Grades PK-6) Regular School No Elementary KG 04 2019   grade_1 41.0 4.0 51.0   0.0 1.0     0.0   7.0   49.0 55.0     28.0   0.0     36.0   *   104.0 41 4 51   0 1     0   7   49 55     28 0   36     104
1946221 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 PK 04 2019   grade_1 39.0 14.0 15.0   2.0 10.0     0.0   14.0   53.0 41.0     *   *     50.0   15.0   94.0 39 14 15   2 10     0   14   53 41           50 15   94
1946227 MN Unknown   school 2733330 16 Independent Districts and Schools SPRING LAKE PARK PUBLIC SCHOOLS 273333005028 776 Centerview Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 04 2019   grade_1 60.0 16.0 4.0   0.0 12.0     0.0   9.0   53.0 48.0     18.0   0.0     33.0   18.0   101.0 60 16 4   0 12     0   9   53 48     18 0   33 18   101
1946247 MN Becker 3 school 2710230 22 Independent Districts and Schools DETROIT LAKES PUBLIC SCHOOL DIST. 271023002268 60 ROOSEVELT ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2019   grade_1 74.0 2.0 2.0   11.0 0.0     0.0   14.0   46.0 57.0     1.0   3.0     45.0   29.0   103.0 74 2 2   11 0     0   14   46 57     1 3   45 29   103
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
1946600 MN Carver 10 school 2741910 111 Independent Districts and Schools WATERTOWN-MAYER PUBLIC SCHOOL DIST. 274191003674 839 WATERTOWN-MAYER ELEMENTARY SCHOOL Elementary School (Grades PK-6) Regular School No Elementary KG 04 2019   grade_1 99.0 0.0 0.0   1.0 0.0     0.0   2.0   50.0 52.0     1.0   0.0     19.0   14.0   102.0 99 0 0   1 0     0   2   50 52     1 0   19 14   102
1946675 MN Cass 11 school 2708070 115 Independent Districts and Schools CASS LAKE-BENA PUBLIC SCHOOLS 270807000330 10 CASS LAKE-BENA ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2019   grade_1 3.0 0.0 4.0   75.0 0.0     0.0   13.0   52.0 43.0     0.0   1.0     82.0   25.0   95.0 3 0 4   75 0     0   13   52 43     0 1   82 25   95
1946682 MN Cass 11 school 2728350 116 Independent Districts and Schools PILLAGER PUBLIC SCHOOL DISTRICT 272835001253 10 PILLAGER ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2019   grade_1 102.0 0.0 1.0   0.0 0.0     0.0   3.0   51.0 55.0     0.0   0.0     43.0   5.0   106.0 102 0 1   0 0     0   3   51 55     0 0   43 5   106
1946705 MN Chisago 13 school 2723820 138 Independent Districts and Schools NORTH BRANCH PUBLIC SCHOOLS 272382003514 45 SUNRISE RIVER ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 04 2019   grade_1 141.0 1.0 9.0   2.0 6.0     0.0   4.0   87.0 76.0     9.0   2.0     61.0   22.0   163.0 141 1 9   2 6     0   4   87 76     9 2   61 22   163
1946743 MN Clay 14 school 2721420 152 Independent Districts and Schools MOORHEAD PUBLIC SCHOOL DISTRICT 272142005026 185 Dorothy Dodds Elementary School Elementary School (Grades PK-6) Regular School No Elementary KG 04 2019   grade_1 97.0 15.0 14.0   4.0 1.0     0.0   8.0   83.0 56.0     11.0   0.0     53.0   23.0   139.0 97 15 14   4 1     0   8   83 56     11 0   53 23   139
1946749 MN Clay 14 school 2721420 152 Independent Districts and Schools MOORHEAD PUBLIC SCHOOL DISTRICT 272142003509 187 Robert Asp Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 04 2019   grade_1 83.0 8.0 15.0   8.0 0.0     1.0   13.0   62.0 66.0     7.0   6.0     71.0   29.0   128.0 83 8 15   8 0     1   13   62 66     7 6   71 29   128
1946755 MN Clay 14 school 2721420 152 Independent Districts and Schools MOORHEAD PUBLIC SCHOOL DISTRICT 272142003510 188 ELLEN HOPKINS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 04 2019   grade_1 101.0 17.0 10.0   3.0 3.0     0.0   9.0   75.0 68.0     7.0   0.0     44.0   22.0   143.0 101 17 10   3 3     0   9   75 68     7 0   44 22   143
1946761 MN Clay 14 school 2721420 152 Independent Districts and Schools MOORHEAD PUBLIC SCHOOL DISTRICT 272142003511 189 S.G.REINERTSEN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 04 2019   grade_1 104.0 15.0 4.0   1.0 0.0     0.0   4.0   69.0 59.0     21.0   0.0     51.0   18.0   128.0 104 15 4   1 0     0   4   69 59     21 0   51 18   128
1946800 MN Crow Wing 18 school 2706090 181 Independent Districts and Schools BRAINERD PUBLIC SCHOOL DISTRICT 270609000248 4 BAXTER ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2019   grade_1 100.0 0.0 1.0   2.0 1.0     0.0   7.0   52.0 59.0     2.0   0.0     43.0   19.0   111.0 100 0 1   2 1     0   7   52 59     2 0   43 19   111
1946806 MN Crow Wing 18 school 2706090 181 Independent Districts and Schools BRAINERD PUBLIC SCHOOL DISTRICT 270609000252 8 GARFIELD ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 04 2019   grade_1 59.0 1.0 1.0   2.0 0.0     0.0   3.0   35.0 31.0     0.0   0.0     39.0   17.0   66.0 59 1 1   2 0     0   3   35 31     0 0   39 17   66
1946812 MN Crow Wing 18 school 2706090 181 Independent Districts and Schools BRAINERD PUBLIC SCHOOL DISTRICT 270609000254 9 HARRISON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 04 2019   grade_1 39.0 0.0 0.0   1.0 0.0     0.0   1.0   22.0 19.0     0.0   0.0     21.0   9.0   41.0 39 0 0   1 0     0   1   22 19     0 0   21 9   41
1946818 MN Crow Wing 18 school 2706090 181 Independent Districts and Schools BRAINERD PUBLIC SCHOOL DISTRICT 270609000256 11 Lowell Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 04 2019   grade_1 89.0 1.0 1.0   3.0 1.0     0.0   4.0   46.0 53.0     1.0   2.0     40.0   14.0   99.0 89 1 1   3 1     0   4   46 53     1 2   40 14   99
1946824 MN Crow Wing 18 school 2706090 181 Independent Districts and Schools BRAINERD PUBLIC SCHOOL DISTRICT 270609000259 12 RIVERSIDE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 04 2019   grade_1 104.0 1.0 5.0   1.0 0.0     0.0   7.0   63.0 55.0     1.0   0.0     64.0   29.0   118.0 104 1 5   1 0     0   7   63 55     1 0   64 29   118
1946830 MN Crow Wing 18 school 2706090 181 Independent Districts and Schools BRAINERD PUBLIC SCHOOL DISTRICT 270609000257 15 NISSWA ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2019   grade_1 50.0 0.0 1.0   0.0 0.0     0.0   1.0   30.0 22.0     0.0   0.0     20.0   9.0   52.0 50 0 1   0 0     0   1   30 22     0 0   20 9   52
1946846 MN Crow Wing 18 school 2728200 186 Independent Districts and Schools PEQUOT LAKES PUBLIC SCHOOLS 272820001244 10 EAGLE VIEW ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2019   grade_1 109.0 2.0 1.0   3.0 0.0     0.0   0.0   66.0 49.0     1.0   0.0     40.0   19.0   115.0 109 2 1   3 0     0   0   66 49     1 0   40 19   115
1947191 MN Dakota 19 school 2742270 197 Independent Districts and Schools WEST ST. PAUL-MENDOTA HTS.-EAGAN 274227001776 815 MORELAND ART/HEALTH SCIENCE MAGNET Elementary School (Grades PK-6) Regular School No Elementary PK 04 2019   grade_1 29.0 10.0 37.0   0.0 4.0     0.0   6.0   53.0 33.0     27.0   0.0     54.0   17.0   86.0 29 10 37   0 4     0   6   53 33     27 0   54 17   86
1947197 MN Dakota 19 school 2742270 197 Independent Districts and Schools WEST ST. PAUL-MENDOTA HTS.-EAGAN 274227002202 816 MENDOTA ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2019   grade_1 79.0 0.0 7.0   0.0 1.0     0.0   5.0   49.0 43.0     4.0   0.0     6.0   10.0   92.0 79 0 7   0 1     0   5   49 43     4 0   6 10   92
1947203 MN Dakota 19 school 2742270 197 Independent Districts and Schools WEST ST. PAUL-MENDOTA HTS.-EAGAN 274227001773 817 GARLOUGH ENVIRONMENTAL MAGNET Elementary School (Grades PK-6) Regular School No Elementary KG 04 2019   grade_1 41.0 6.0 42.0   2.0 1.0     0.0   5.0   40.0 57.0     27.0   0.0     55.0   12.0   97.0 41 6 42   2 1     0   5   40 57     27 0   55 12   97
1947209 MN Dakota 19 school 2742270 197 Independent Districts and Schools WEST ST. PAUL-MENDOTA HTS.-EAGAN 274227001780 819 SOMERSET ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2019   grade_1 61.0 4.0 13.0   0.0 1.0     0.0   10.0   45.0 44.0     4.0   0.0     18.0   11.0   89.0 61 4 13   0 1     0   10   45 44     4 0   18 11   89
1947215 MN Dakota 19 school 2742270 197 Independent Districts and Schools WEST ST. PAUL-MENDOTA HTS.-EAGAN 274227001778 820 PILOT KNOB STEM MAGNET SCHOOL Elementary School (Grades PK-6) Regular School No Elementary KG 04 2019   grade_1 25.0 29.0 3.0   0.0 18.0     0.0   8.0   38.0 45.0     9.0   0.0     42.0   15.0   83.0 25 29 3   0 18     0   8   38 45     9 0   42 15   83
1947251 MN Dakota 19 school 2713530 200 Independent Districts and Schools HASTINGS PUBLIC SCHOOL DISTRICT 271353000695 609 KENNEDY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 04 2019   grade_1 70.0 2.0 7.0   1.0 0.0     0.0   4.0   41.0 43.0     0.0   0.0     27.0   12.0   84.0 70 2 7   1 0     0   4   41 43     0 0   27 12   84
1947257 MN Dakota 19 school 2713530 200 Independent Districts and Schools HASTINGS PUBLIC SCHOOL DISTRICT 271353000696 610 PINECREST ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 04 2019   grade_1 89.0 1.0 9.0   0.0 2.0     0.0   7.0   55.0 53.0     2.0   0.0     27.0   15.0   108.0 89 1 9   0 2     0   7   55 53     2 0   27 15   108
1947263 MN Dakota 19 school 2713530 200 Independent Districts and Schools HASTINGS PUBLIC SCHOOL DISTRICT 271353002239 612 CHRISTA MCAULIFFE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 04 2019   grade_1 96.0 2.0 4.0   0.0 1.0     1.0   8.0   58.0 54.0     3.0   2.0     31.0   15.0   112.0 96 2 4   0 1     1   8   58 54     3 2   31 15   112
1947278 MN Dodge 20 school 2716980 204 Independent Districts and Schools KASSON-MANTORVILLE SCHOOL DISTRICT 271698000783 10 KASSON-MANTORVILLE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2019   grade_1 154.0 1.0 11.0   0.0 0.0     0.0   6.0   99.0 73.0     5.0   0.0     32.0   21.0   172.0 154 1 11   0 0     0   6   99 73     5 0   32 21   172
1947430 MN Goodhue 25 school 2728950 255 Independent Districts and Schools PINE ISLAND PUBLIC SCHOOL DIST. 272895001257 10 PINE ISLAND ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2019   grade_1 120.0 4.0 1.0   0.0 2.0     0.0   2.0   69.0 60.0     0.0   0.0     20.0   11.0   129.0 120 4 1   0 2     0   2   69 60     0 0   20 11   129
1947732 MN Hennepin 27 school 2722920 277 Independent Districts and Schools WESTONKA PUBLIC SCHOOL DISTRICT 272292001113 615 SHIRLEY HILLS PRIMARY SCHOOL Elementary School (Grades PK-6) Regular School No Elementary KG 04 2019   grade_1 67.0 2.0 8.0   0.0 4.0     0.0   5.0   46.0 40.0     2.0   1.0     16.0   12.0   86.0 67 2 8   0 4     0   5   46 40     2 1   16 12   86
1947738 MN Hennepin 27 school 2722920 277 Independent Districts and Schools WESTONKA PUBLIC SCHOOL DISTRICT 272292001110 616 HILLTOP PRIMARY SCHOOL Elementary School (Grades PK-6) Regular School No Elementary KG 04 2019   grade_1 89.0 0.0 4.0   0.0 0.0     0.0   3.0   53.0 43.0     0.0   0.0     7.0   11.0   96.0 89 0 4   0 0     0   3   53 43     0 0   7 11   96
1947991 MN Hennepin 27 school 2731780 281 Independent Districts and Schools ROBBINSDALE PUBLIC SCHOOL DISTRICT 273178005078 20 FAIR School Pilgrim Lane Elementary School (Grades PK-6) Regular School No Elementary KG 04 2019   grade_1 40.0 22.0 7.0   0.0 2.0     0.0   5.0   35.0 41.0     3.0   1.0     32.0   6.0   76.0 40 22 7   0 2     0   5   35 41     3 1   32 6   76
1948146 MN Houston 28 school 2717250 300 Independent Districts and Schools LA CRESCENT-HOKAH SCHOOL DISTRICT 271725000799 10 LA CRESCENT-HOKAH ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2019   grade_1 69.0 2.0 1.0   0.0 1.0     0.0   3.0   46.0 30.0     0.0   0.0     16.0   15.0   76.0 69 2 1   0 1     0   3   46 30     0 0   16 15   76
1948176 MN Hubbard 29 school 2728080 309 Independent Districts and Schools PARK RAPIDS PUBLIC SCHOOL DISTRICT 272808001233 30 PARK RAPIDS AREA CENTURY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2019   grade_1 105.0 0.0 6.0   1.0 0.0     0.0   8.0   50.0 70.0     *   0.0         21.0   120.0 105 0 6   1 0     0   8   50 70       0     21   120
1948193 MN Itasca 31 school 2709480 316 Independent Districts and Schools GREENWAY PUBLIC SCHOOL DISTRICT 270948000394 110 VANDYKE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2019   grade_1 66.0 1.0 2.0   7.0 0.0     0.0   1.0   45.0 32.0     0.0   0.0     42.0   14.0   77.0 66 1 2   7 0     0   1   45 32     0 0   42 14   77
1948210 MN Itasca 31 school 2713170 318 Independent Districts and Schools GRAND RAPIDS PUBLIC SCHOOL DISTRICT 271317000661 110 COHASSET ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 04 2019   grade_1 54.0 0.0 1.0   4.0 0.0     0.0   3.0   41.0 21.0     0.0   0.0     19.0   8.0   62.0 54 0 1   4 0     0   3   41 21     0 0   19 8   62
1948226 MN Itasca 31 school 2713170 318 Independent Districts and Schools GRAND RAPIDS PUBLIC SCHOOL DISTRICT 271317000662 120 FOREST LAKE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 04 2019   grade_1 56.0 0.0 2.0   0.0 0.0     0.0   2.0   33.0 27.0     0.0   0.0     26.0   7.0   60.0 56 0 2   0 0     0   2   33 27     0 0   26 7   60
1948232 MN Itasca 31 school 2713170 318 Independent Districts and Schools GRAND RAPIDS PUBLIC SCHOOL DISTRICT 271317000907 125 MURPHY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 04 2019   grade_1 53.0 0.0 4.0   3.0 0.0     0.0   7.0   38.0 29.0     0.0   0.0     29.0   9.0   67.0 53 0 4   3 0     0   7   38 29     0 0   29 9   67
1948238 MN Itasca 31 school 2713170 318 Independent Districts and Schools GRAND RAPIDS PUBLIC SCHOOL DISTRICT 271317000915 135 SOUTHWEST ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 04 2019   grade_1 56.0 0.0 3.0   2.0 0.0     0.0   5.0   31.0 35.0     0.0   0.0     20.0   10.0   66.0 56 0 3   2 0     0   5   31 35     0 0   20 10   66
1948281 MN Kandiyohi 34 school 2723400 345 Independent Districts and Schools NEW LONDON-SPICER SCHOOL DISTRICT 272340001141 10 PRAIRIE WOODS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2019   grade_1 97.0 0.0 7.0   0.0 0.0     0.0   0.0   48.0 56.0     4.0   1.0     26.0   13.0   104.0 97 0 7   0 0     0   0   48 56     4 1   26 13   104
1948491 MN Becker 3 school 2742120 435 Independent Districts and Schools WAUBUN-OGEMA-WHITE EARTH PUBLIC SCH 274212001754 20 OGEMA ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2019   grade_1 10.0 0.0 0.0   45.0 0.0     0.0   5.0   29.0 31.0     0.0   *     45.0   6.0   60.0 10 0 0   45 0     0   5   29 31     0     45 6   60

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