Data source: Big Local News · About: Big Local

965 rows where grade = "grade_4", state = "MN" and year = 2019 sorted by multiracial_int descending

View and edit SQL

year

  • 2019 · 965

grade

  • grade_4 · 965
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
1946271 MN Beltrami 4 school 2704440 31 Independent Districts and Schools BEMIDJI PUBLIC SCHOOL DISTRICT 270444005094 11 Gene Dillon Elementary School Elementary School (Grades PK-6) Regular School No Elementary 03 05 2019   grade_4 269.0 7.0 9.0   76.0 2.0     0.0   41.0   219.0 185.0     *   *     216.0   *   404.0 269 7 9   76 2     0   41   219 185           216     404
1951802 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124000970 123 HALE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 04 2019   grade_4 75.0 12.0 4.0   1.0 3.0     0.0   22.0   59.0 58.0     3.0   1.0     24.0   13.0   117.0 75 12 4   1 3     0   22   59 58     3 1   24 13   117
1947437 MN Goodhue 25 school 2730480 256 Independent Districts and Schools RED WING PUBLIC SCHOOL DISTRICT 273048001292 537 BURNSIDE ELEMENTARY. Elementary School (Grades PK-6) Regular School No Elementary 02 04 2019   grade_4 143.0 5.0 17.0   7.0 1.0     0.0   21.0   105.0 89.0     6.0   0.0     69.0   27.0   194.0 143 5 17   7 1     0   21   105 89     6 0   69 27   194
1949935 MN Saint Louis 69 school 2711040 709 Independent Districts and Schools DULUTH PUBLIC SCHOOL DISTRICT 271104000482 550 PIEDMONT ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   grade_4 45.0 5.0 2.0   4.0 1.0     0.0   20.0   42.0 35.0     0.0   3.0     52.0   21.0   77.0 45 5 2   4 1     0   20   42 35     0 3   52 21   77
1946530 MN Carlton 9 school 2709420 94 Independent Districts and Schools CLOQUET PUBLIC SCHOOL DISTRICT 270942000384 105 WASHINGTON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   grade_4 71.0 0.0 1.0   9.0 1.0     0.0   19.0   50.0 51.0     2.0   0.0     53.0   *   101.0 71 0 1   9 1     0   19   50 51     2 0   53     101
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
1947084 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239001378 709 PARKVIEW ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   grade_4 76.0 6.0 10.0   2.0 15.0     0.0   16.0   67.0 58.0     13.0   0.0     29.0   23.0   125.0 76 6 10   2 15     0   16   67 58     13 0   29 23   125
1947098 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239001376 711 GREENLEAF ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   grade_4 99.0 17.0 33.0   1.0 8.0     0.0   16.0   96.0 78.0     14.0   1.0     59.0   30.0   174.0 99 17 33   1 8     0   16   96 78     14 1   59 30   174
1947929 MN Hennepin 27 school 2731780 281 Independent Districts and Schools ROBBINSDALE PUBLIC SCHOOL DISTRICT 273178001321 4 FOREST ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   grade_4 24.0 27.0 16.0   1.0 6.0     0.0   16.0   38.0 52.0     19.0   2.0     48.0   14.0   90.0 24 27 16   1 6     0   16   38 52     19 2   48 14   90
1947969 MN Hennepin 27 school 2731780 281 Independent Districts and Schools ROBBINSDALE PUBLIC SCHOOL DISTRICT 273178000747 12 ROBBINSDALE SPANISH IMMERSION EL. Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   grade_4 61.0 7.0 26.0   0.0 2.0     0.0   16.0   61.0 51.0     8.0   0.0     37.0   7.0   112.0 61 7 26   0 2     0   16   61 51     8 0   37 7   112
1952095 MN Dakota 19 school 2733270 6 Special Districts and Schools SOUTH ST. PAUL PUBLIC SCHOOL DIST. 273327001457 737 KAPOSIA EDUCATION CENTER ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   grade_4 45.0 8.0 33.0   3.0 0.0     0.0   16.0   52.0 53.0     *   0.0     66.0   12.0   105.0 45 8 33   3 0     0   16   52 53       0   66 12   105
1947121 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239001942 714 Echo Park Elementary School of Leadership, Engineering and Technology Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   grade_4 47.0 28.0 28.0   1.0 6.0     0.0   15.0   60.0 65.0     37.0   0.0     63.0   17.0   125.0 47 28 28   1 6     0   15   60 65     37 0   63 17   125
1949668 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384002303 579 AMERICAN INDIAN MAGNET SCHOOL Elementary School (Grades PK-6) Regular School No Elementary PK 08 2019   grade_4 4.0 14.0 14.0   4.0 15.0     0.0   15.0   39.0 27.0     17.0   3.0     57.0   16.0   66.0 4 14 14   4 15     0   15   39 27     17 3   57 16   66
1949839 MN Saint Louis 69 school 2713980 701 Independent Districts and Schools HIBBING PUBLIC SCHOOL DISTRICT 271398001529 310 Lincoln Elementary Elementary School (Grades PK-6) Regular School No Elementary 03 06 2019   grade_4 154.0 5.0 5.0   3.0 0.0     2.0   15.0   91.0 93.0     0.0   0.0     86.0   32.0   184.0 154 5 5   3 0     2   15   91 93     0 0   86 32   184
1950044 MN Scott 70 school 2733000 720 Independent Districts and Schools SHAKOPEE PUBLIC SCHOOL DISTRICT 273300003719 865 EAGLE CREEK ELEMENTARY SCHOOL Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   grade_4 58.0 24.0 15.0   5.0 15.0     0.0   15.0   71.0 61.0     21.0   1.0     55.0   18.0   132.0 58 24 15   5 15     0   15   71 61     21 1   55 18   132
1950085 MN Sherburne 71 school 2705460 727 Independent Districts and Schools BIG LAKE PUBLIC SCHOOL DISTRICT 270546000205 10 INDEPENDENCE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 03 05 2019   grade_4 182.0 5.0 14.0   1.0 5.0     0.0   15.0   112.0 110.0     6.0   0.0     57.0   40.0   222.0 182 5 14   1 5     0   15   112 110     6 0   57 40   222
1952144 MN Hennepin 27 school 2700096 4011 Charter Schools Athlos Leadership Academy 270009601892 10 Athlos Leadership Academy Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2019   grade_4 21.0 67.0 7.0   1.0 3.0     0.0   15.0   58.0 56.0     12.0   0.0     77.0   3.0   114.0 21 67 7   1 3     0   15   58 56     12 0   77 3   114
1946105 MN Hennepin 27 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318004406 430 CHAMPLIN/BROOKLYN PK ACD MATH ENSCI Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   grade_4 100.0 20.0 6.0   1.0 15.0     0.0   14.0   78.0 78.0     14.0   1.0     46.0   23.0   156.0 100 20 6   1 15     0   14   78 78     14 1   46 23   156
1947056 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239001380 705 ROSEMOUNT ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   grade_4 80.0 7.0 9.0   0.0 7.0     0.0   14.0   62.0 55.0     *   0.0     21.0   13.0   117.0 80 7 9   0 7     0   14   62 55       0   21 13   117
1948179 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_4 118.0 0.0 11.0   0.0 0.0     0.0   14.0   69.0 74.0     4.0   0.0     79.0   36.0   143.0 118 0 11   0 0     0   14   69 74     4 0   79 36   143
1948436 MN Lyon 42 school 2718940 413 Independent Districts and Schools MARSHALL PUBLIC SCHOOL DISTRICT 271894000894 3 WEST SIDE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 03 04 2019   grade_4 116.0 13.0 27.0   1.0 17.0     0.0   14.0   95.0 93.0     35.0   0.0     104.0   32.0   188.0 116 13 27   1 17     0   14   95 93     35 0   104 32   188
1952475 MN Washington 82 school 2700358 4116 Charter Schools Lakes International Language Academy 270035804102 10 Lakes International Language Academy Elementary School (Grades PK-6) Regular School Yes Elementary KG 05 2019   grade_4 98.0 1.0 14.0   1.0 2.0     0.0   14.0   63.0 67.0     6.0   0.0     11.0   13.0   130.0 98 1 14   1 2     0   14   63 67     6 0   11 13   130
1946224 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_4 53.0 25.0 27.0   2.0 11.0     1.0   13.0   65.0 67.0     23.0   3.0     84.0   20.0   132.0 53 25 27   2 11     1   13   65 67     23 3   84 20   132
1947962 MN Hennepin 27 school 2731780 281 Independent Districts and Schools ROBBINSDALE PUBLIC SCHOOL DISTRICT 273178001327 11 NEILL ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   grade_4 19.0 35.0 5.0   0.0 10.0     0.0   13.0   40.0 42.0     9.0   1.0     57.0   17.0   82.0 19 35 5   0 10     0   13   40 42     9 1   57 17   82
1948022 MN Hennepin 27 school 2733420 282 Independent Districts and Schools ST. ANTHONY-NEW BRIGHTON SCHOOLS 273342001474 40 WILSHIRE PARK ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   grade_4 81.0 14.0 4.0   1.0 13.0     0.0   13.0   62.0 64.0     *   0.0     28.0   7.0   126.0 81 14 4   1 13     0   13   62 64       0   28 7   126
1948029 MN Hennepin 27 school 2733780 283 Independent Districts and Schools ST. LOUIS PARK PUBLIC SCHOOL DIST. 273378001525 745 AQUILA ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   grade_4 41.0 25.0 10.0   0.0 8.0     0.0   13.0   49.0 48.0     22.0   0.0     41.0   10.0   97.0 41 25 10   0 8     0   13   49 48     22 0   41 10   97
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
1950662 MN Washington 82 school 2733810 833 Independent Districts and Schools SOUTH WASHINGTON COUNTY SCHOOL DIST 273381002306 47 MIDDLETON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   grade_4 86.0 10.0 6.0   0.0 15.0     0.0   13.0   71.0 59.0     6.0   0.0     10.0   23.0   130.0 86 10 6   0 15     0   13   71 59     6 0   10 23   130
1946953 MN Dakota 19 school 2711820 192 Independent Districts and Schools FARMINGTON PUBLIC SCHOOL DISTRICT 271182002642 40 NORTH TRAIL ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   grade_4 79.0 5.0 5.0   0.0 6.0     0.0   12.0   63.0 44.0     5.0   1.0         19.0   107.0 79 5 5   0 6     0   12   63 44     5 1     19   107
1947091 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239001375 710 Diamond Path Elementary School of International Studies Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   grade_4 66.0 19.0 6.0   0.0 13.0     0.0   12.0   55.0 61.0     13.0   *     28.0   9.0   116.0 66 19 6   0 13     0   12   55 61     13     28 9   116
1947518 MN Hennepin 27 school 2714260 270 Independent Districts and Schools HOPKINS PUBLIC SCHOOL DISTRICT 271426001884 570 MEADOWBROOK ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   grade_4 85.0 14.0 7.0   1.0 1.0     0.0   12.0   61.0 59.0     2.0   1.0     20.0   17.0   120.0 85 14 7   1 1     0   12   61 59     2 1   20 17   120
1947728 MN Hennepin 27 school 2711670 276 Independent Districts and Schools MINNETONKA PUBLIC SCHOOL DISTRICT 271167000549 606 SCENIC HEIGHTS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   grade_4 112.0 3.0 3.0   0.0 22.0     0.0   12.0   74.0 78.0     5.0   2.0     10.0   25.0   152.0 112 3 3   0 22     0   12   74 78     5 2   10 25   152
1947894 MN Hennepin 27 school 2731750 280 Independent Districts and Schools RICHFIELD PUBLIC SCHOOL DISTRICT 273175001312 36 RICHFIELD STEM SCHOOL Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   grade_4 42.0 18.0 25.0   1.0 8.0     0.0   12.0   62.0 44.0     24.0   *     68.0   24.0   106.0 42 18 25   1 8     0   12   62 44     24     68 24   106
1948106 MN Hennepin 27 school 2742160 284 Independent Districts and Schools WAYZATA PUBLIC SCHOOL DISTRICT 274216002307 812 KIMBERLY LANE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   grade_4 60.0 6.0 8.0   0.0 61.0     1.0   12.0   80.0 68.0     3.0   0.0     6.0   7.0   148.0 60 6 8   0 61     1   12   80 68     3 0   6 7   148
1949119 MN Ramsey 62 school 2723850 622 Independent Districts and Schools North St Paul-Maplewood Oakdale Public School District 272385001166 27 CARVER ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   grade_4 27.0 12.0 18.0   0.0 19.0     0.0   12.0   44.0 44.0     19.0   2.0     52.0   *   88.0 27 12 18   0 19     0   12   44 44     19 2   52     88
1949266 MN Washington 82 school 2742360 624 Independent Districts and Schools WHITE BEAR LAKE SCHOOL DISTRICT 274236003699 824 ONEKA ELEMENTARY SCHOOL Elementary School (Grades PK-6) Regular School No Elementary 02 05 2019   grade_4 125.0 2.0 9.0   0.0 8.0     0.0   12.0   73.0 83.0     6.0   0.0     34.0   24.0   156.0 125 2 9   0 8     0   12   73 83     6 0   34 24   156
1949306 MN Ramsey 62 school 2742360 624 Independent Districts and Schools WHITE BEAR LAKE SCHOOL DISTRICT 274236002191 833 MATOSKA INTERNATIONAL Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   grade_4 70.0 4.0 4.0   0.0 10.0     0.0   12.0   44.0 56.0     5.0   0.0     22.0   14.0   100.0 70 4 4   0 10     0   12   44 56     5 0   22 14   100
1949858 MN Saint Louis 69 school 2741040 706 Independent Districts and Schools VIRGINIA PUBLIC SCHOOL DISTRICT 274104001716 30 ROOSEVELT ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 03 06 2019   grade_4 93.0 3.0 5.0   3.0 0.0     0.0   12.0   61.0 55.0     0.0   1.0     51.0   23.0   116.0 93 3 5   3 0     0   12   61 55     0 1   51 23   116
1950135 MN Sherburne 71 school 2711370 728 Independent Districts and Schools ELK RIVER PUBLIC SCHOOL DISTRICT 271137004141 210 WESTWOOD ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 03 05 2019   grade_4 181.0 1.0 4.0   0.0 2.0     0.0   12.0   113.0 87.0     1.0   0.0     46.0   28.0   200.0 181 1 4   0 2     0   12   113 87     1 0   46 28   200
1950258 MN Stearns 73 school 2733510 742 Independent Districts and Schools ST. CLOUD PUBLIC SCHOOL DISTRICT 273351002285 51 OAK HILL COMMUNITY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   grade_4 61.0 50.0 7.0   1.0 4.0     0.0   12.0   82.0 53.0     30.0   1.0     80.0   26.0   135.0 61 50 7   1 4     0   12   82 53     30 1   80 26   135
1946177 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_4 45.0 38.0 12.0   0.0 5.0     0.0   11.0   60.0 51.0     29.0   2.0     70.0   15.0   111.0 45 38 12   0 5     0   11   60 51     29 2   70 15   111
1946250 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_4 80.0 1.0 6.0   13.0 0.0     0.0   11.0   52.0 59.0     3.0   1.0     58.0   18.0   111.0 80 1 6   13 0     0   11   52 59     3 1   58 18   111
1946903 MN Dakota 19 school 2707290 191 Independent Districts and Schools BURNSVILLE PUBLIC SCHOOL DISTRICT 270729000293 487 WILLIAM BYRNE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   grade_4 35.0 19.0 14.0   0.0 5.0     0.0   11.0   35.0 49.0     18.0   0.0     45.0   14.0   84.0 35 19 14   0 5     0   11   35 49     18 0   45 14   84
1947077 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239001382 708 SOUTHVIEW ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   grade_4 60.0 24.0 14.0   0.0 5.0     0.0   11.0   58.0 56.0     14.0   0.0     38.0   22.0   114.0 60 24 14   0 5     0   11   58 56     14 0   38 22   114
1947105 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239001374 712 Cedar Park Elementary School of Science, Technology, Engineering and Math Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   grade_4 46.0 32.0 17.0   0.0 17.0     0.0   11.0   67.0 56.0     13.0   0.0     52.0   20.0   123.0 46 32 17   0 17     0   11   67 56     13 0   52 20   123
1947179 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239000512 764 Glacier Hills Elementary School of Arts and Science Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   grade_4 62.0 14.0 18.0   0.0 41.0     0.0   11.0   71.0 75.0     21.0   0.0     33.0   9.0   146.0 62 14 18   0 41     0   11   71 75     21 0   33 9   146
1947229 MN Dakota 19 school 2715030 199 Independent Districts and Schools INVER GROVE HEIGHTS SCHOOLS 271503000763 575 HILLTOP ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   grade_4 45.0 17.0 29.0   0.0 5.0     0.0   11.0   65.0 42.0     15.0   *     55.0   25.0   107.0 45 17 29   0 5     0   11   65 42     15     55 25   107
1947707 MN Hennepin 27 school 2711670 276 Independent Districts and Schools MINNETONKA PUBLIC SCHOOL DISTRICT 271167000543 603 EXCELSIOR ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   grade_4 115.0 1.0 3.0   2.0 6.0     0.0   11.0   77.0 61.0     6.0   1.0     12.0   22.0   138.0 115 1 3   2 6     0   11   77 61     6 1   12 22   138
1947778 MN Hennepin 27 school 2725200 279 Independent Districts and Schools OSSEO PUBLIC SCHOOL DISTRICT 272520002523 670 BASSWOOD ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   grade_4 144.0 10.0 3.0   0.0 11.0     0.0   11.0   103.0 76.0     4.0   1.0     15.0   18.0   179.0 144 10 3   0 11     0   11   103 76     4 1   15 18   179
1947787 MN Hennepin 27 school 2725200 279 Independent Districts and Schools OSSEO PUBLIC SCHOOL DISTRICT 272520001207 671 BIRCH GROVE SCHOOL FOR THE ARTS Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   grade_4 11.0 30.0 7.0   1.0 9.0     0.0   11.0   38.0 31.0     11.0   2.0     48.0   10.0   69.0 11 30 7   1 9     0   11   38 31     11 2   48 10   69
1947876 MN Hennepin 27 school 2725200 279 Independent Districts and Schools OSSEO PUBLIC SCHOOL DISTRICT 272520002212 689 FERNBROOK ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   grade_4 105.0 17.0 3.0   0.0 12.0     0.0   11.0   73.0 75.0     7.0   1.0     25.0   24.0   148.0 105 17 3   0 12     0   11   73 75     7 1   25 24   148
1948043 MN Hennepin 27 school 2733780 283 Independent Districts and Schools ST. LOUIS PARK PUBLIC SCHOOL DIST. 273378001531 755 SUSAN LINDGREN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   grade_4 47.0 13.0 6.0   0.0 2.0     0.0   11.0   40.0 39.0     7.0   1.0     30.0   5.0   79.0 47 13 6   0 2     0   11   40 39     7 1   30 5   79
1948064 MN Hennepin 27 school 2742160 284 Independent Districts and Schools WAYZATA PUBLIC SCHOOL DISTRICT 274216001759 804 BIRCHVIEW ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   grade_4 48.0 6.0 3.0   0.0 5.0     0.0   11.0   47.0 26.0     0.0   1.0     18.0   1.0   73.0 48 6 3   0 5     0   11   47 26     0 1   18 1   73
1948828 MN Olmsted 55 school 2731800 535 Independent Districts and Schools ROCHESTER PUBLIC SCHOOL DISTRICT 273180000996 126 GAGE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   grade_4 33.0 29.0 16.0   0.0 23.0     0.0   11.0   52.0 60.0     37.0   1.0     78.0   18.0   112.0 33 29 16   0 23     0   11   52 60     37 1   78 18   112
1949162 MN Ramsey 62 school 2723850 622 Independent Districts and Schools North St Paul-Maplewood Oakdale Public School District 272385001176 34 RICHARDSON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   grade_4 16.0 16.0 17.0   0.0 21.0     0.0   11.0   38.0 43.0     15.0   3.0     59.0   12.0   81.0 16 16 17   0 21     0   11   38 43     15 3   59 12   81
1949918 MN Saint Louis 69 school 2711040 709 Independent Districts and Schools DULUTH PUBLIC SCHOOL DISTRICT 271104000476 525 LAURA MACARTHUR ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   grade_4 46.0 4.0 2.0   8.0 0.0     0.0   11.0   40.0 31.0     0.0   4.0     50.0   18.0   71.0 46 4 2   8 0     0   11   40 31     0 4   50 18   71
1950953 MN Isanti 30 school 2707410 911 Independent Districts and Schools CAMBRIDGE-ISANTI PUBLIC SCHOOL DIST 270741003657 201 CAMBRIDGE INTERMEDIATE SCHOOL Elementary School (Grades PK-6) Regular School No Elementary 03 05 2019   grade_4 167.0 4.0 2.0   3.0 3.0     0.0   11.0   98.0 92.0     *   1.0     69.0   32.0   190.0 167 4 2   3 3     0   11   98 92       1   69 32   190
1952086 MN Dakota 19 school 2733270 6 Special Districts and Schools SOUTH ST. PAUL PUBLIC SCHOOL DIST. 273327001453 735 LINCOLN CENTER ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   grade_4 91.0 16.0 29.0   0.0 9.0     0.0   11.0   93.0 63.0     *   0.0     65.0   24.0   156.0 91 16 29   0 9     0   11   93 63       0   65 24   156
1952503 MN Hennepin 27 school 2700366 4124 Charter Schools BEACON ACADEMY 270036604110 10 BEACON ACADEMY Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2019   grade_4 46.0 11.0 6.0   0.0 1.0     0.0   11.0   40.0 35.0     2.0   0.0     26.0   13.0   75.0 46 11 6   0 1     0   11   40 35     2 0   26 13   75
1957372 MN Houston 28 school 2714280 294 Independent Districts and Schools HOUSTON PUBLIC SCHOOL DISTRICT 271428003187 12 MINNESOTA VIRTUAL ACADEMY Distance Learning Program OLL (State approved) Regular School No Other KG 12 2019   grade_4 34.0 6.0 7.0   2.0 3.0     0.0   11.0   40.0 23.0     3.0   1.0     21.0   6.0   63.0 34 6 7   2 3     0   11   40 23     3 1   21 6   63
1946112 MN Anoka 2 school 2708100 12 Independent Districts and Schools CENTENNIAL PUBLIC SCHOOL DISTRICT 270810000332 510 CENTENNIAL ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   grade_4 73.0 3.0 7.0   1.0 7.0     0.0   10.0   54.0 47.0     5.0   0.0     23.0   16.0   101.0 73 3 7   1 7     0   10   54 47     5 0   23 16   101
1946216 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_4 47.0 3.0 43.0   0.0 1.0     0.0   10.0   41.0 63.0     28.0   1.0     33.0   8.0   104.0 47 3 43   0 1     0   10   41 63     28 1   33 8   104
1946241 MN Becker 3 school 2710230 22 Independent Districts and Schools DETROIT LAKES PUBLIC SCHOOL DIST. 271023000445 10 ROSSMAN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   grade_4 80.0 0.0 4.0   7.0 1.0     0.0   10.0   46.0 56.0     0.0   3.0     30.0   21.0   102.0 80 0 4   7 1     0   10   46 56     0 3   30 21   102
1946746 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_4 107.0 16.0 7.0   1.0 2.0     0.0   10.0   76.0 67.0     15.0   2.0     47.0   32.0   143.0 107 16 7   1 2     0   10   76 67     15 2   47 32   143
1946752 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_4 96.0 8.0 18.0   10.0 2.0     0.0   10.0   74.0 70.0     13.0   6.0     80.0   25.0   144.0 96 8 18   10 2     0   10   74 70     13 6   80 25   144
1946758 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_4 83.0 20.0 12.0   1.0 1.0     0.0   10.0   52.0 75.0     15.0   1.0     45.0   21.0   127.0 83 20 12   1 1     0   10   52 75     15 1   45 21   127
1946772 MN Clearwater 15 school 2703570 162 Independent Districts and Schools BAGLEY PUBLIC SCHOOL DISTRICT 270357000164 10 BAGLEY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   grade_4 60.0 4.0 1.0   14.0 0.0     0.0   10.0   45.0 44.0     0.0   0.0     46.0   12.0   89.0 60 4 1   14 0     0   10   45 44     0 0   46 12   89
1947218 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_4 27.0 23.0 5.0   1.0 9.0     0.0   10.0   40.0 35.0     11.0   0.0     28.0   8.0   75.0 27 23 5   1 9     0   10   40 35     11 0   28 8   75
1947260 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_4 105.0 0.0 5.0   1.0 0.0     0.0   10.0   50.0 71.0     2.0   1.0     34.0   17.0   121.0 105 0 5   1 0     0   10   50 71     2 1   34 17   121
1947527 MN Hennepin 27 school 2705790 271 Independent Districts and Schools BLOOMINGTON PUBLIC SCHOOL DISTRICT 270579000640 432 WASHBURN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   grade_4 22.0 17.0 17.0   1.0 5.0     0.0   10.0   31.0 41.0     14.0   1.0     37.0   8.0   72.0 22 17 17   1 5     0   10   31 41     14 1   37 8   72
1947559 MN Hennepin 27 school 2705790 271 Independent Districts and Schools BLOOMINGTON PUBLIC SCHOOL DISTRICT 270579000223 448 OAK GROVE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   grade_4 36.0 20.0 15.0   0.0 11.0     0.0   10.0   63.0 29.0     17.0   3.0     39.0   14.0   92.0 36 20 15   0 11     0   10   63 29     17 3   39 14   92
1947748 MN Hennepin 27 school 2725080 278 Independent Districts and Schools ORONO PUBLIC SCHOOL DISTRICT 272508003444 662 ORONO INTERMEDIATE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 03 05 2019   grade_4 188.0 4.0 8.0   1.0 4.0     0.0   10.0   116.0 99.0     6.0   0.0     23.0   32.0   215.0 188 4 8   1 4     0   10   116 99     6 0   23 32   215
1947912 MN Hennepin 27 school 2731750 280 Independent Districts and Schools RICHFIELD PUBLIC SCHOOL DISTRICT 273175001316 701 SHERIDAN HILLS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   grade_4 27.0 11.0 24.0   0.0 4.0     0.0   10.0   33.0 43.0     21.0   *         8.0   76.0 27 11 24   0 4     0   10   33 43     21       8   76
1947978 MN Hennepin 27 school 2731780 281 Independent Districts and Schools ROBBINSDALE PUBLIC SCHOOL DISTRICT 273178001329 17 NOBLE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   grade_4 8.0 22.0 11.0   1.0 8.0     0.0   10.0   34.0 26.0     8.0   *     42.0   11.0   60.0 8 22 11   1 8     0   10   34 26     8     42 11   60
1948206 MN Itasca 31 school 2710140 317 Independent Districts and Schools DEER RIVER PUBLIC SCHOOL DISTRICT 271014000434 4 KING ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   grade_4 36.0 0.0 3.0   27.0 0.0     0.0   10.0   45.0 31.0     *   *         20.0   76.0 36 0 3   27 0     0   10   45 31             20   76
1948459 MN Mcleod 43 school 2714970 423 Independent Districts and Schools HUTCHINSON PUBLIC SCHOOL DISTRICT 271497000754 10 HUTCHINSON PARK ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 02 05 2019   grade_4 170.0 0.0 21.0   0.0 0.0     0.0   10.0   116.0 85.0     13.0   4.0     70.0   38.0   201.0 170 0 21   0 0     0   10   116 85     13 4   70 38   201
1948776 MN Olmsted 55 school 2731800 535 Independent Districts and Schools ROCHESTER PUBLIC SCHOOL DISTRICT 273180000982 110 BAMBER VALLEY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   grade_4 84.0 10.0 28.0   0.0 14.0     0.0   10.0   68.0 78.0     16.0   1.0     45.0   20.0   146.0 84 10 28   0 14     0   10   68 78     16 1   45 20   146
1948812 MN Olmsted 55 school 2731800 535 Independent Districts and Schools ROCHESTER PUBLIC SCHOOL DISTRICT 273180000993 124 FRANKLIN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   grade_4 49.0 20.0 31.0   1.0 7.0     0.0   10.0   73.0 45.0     28.0   2.0     66.0   27.0   118.0 49 20 31   1 7     0   10   73 45     28 2   66 27   118
1948914 MN Otter Tail 56 school 2711880 544 Independent Districts and Schools FERGUS FALLS PUBLIC SCHOOL DISTRICT 271188000574 140 CLEVELAND ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 03 04 2019   grade_4 173.0 9.0 6.0   1.0 1.0     1.0   10.0   108.0 93.0     *   0.0     70.0   25.0   201.0 173 9 6   1 1     1   10   108 93       0   70 25   201
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
1949198 MN Ramsey 62 school 2732430 623 Independent Districts and Schools ROSEVILLE PUBLIC SCHOOL DISTRICT 273243001046 73 PARKVIEW CENTER SCHOOL Elementary School (Grades PK-6) Regular School No Elementary PK 08 2019   grade_4 53.0 5.0 6.0   1.0 13.0     0.0   10.0   39.0 49.0     6.0   0.0     19.0   17.0   88.0 53 5 6   1 13     0   10   39 49     6 0   19 17   88
1949394 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384001167 435 EXPO FOR EXCELLENCE ELEMENTARY SCH Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   grade_4 52.0 29.0 8.0   0.0 7.0     1.0   10.0   56.0 51.0     16.0   2.0     47.0   15.0   107.0 52 29 8   0 7     1   10   56 51     16 2   47 15   107
1949909 MN Saint Louis 69 school 2711040 709 Independent Districts and Schools DULUTH PUBLIC SCHOOL DISTRICT 271104000475 520 Lowell Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   grade_4 32.0 1.0 2.0   7.0 0.0     1.0   10.0   19.0 34.0     2.0   2.0     17.0   2.0   53.0 32 1 2   7 0     1   10   19 34     2 2   17 2   53
1949926 MN Saint Louis 69 school 2711040 709 Independent Districts and Schools DULUTH PUBLIC SCHOOL DISTRICT 271104000479 540 MYERS-WILKINS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   grade_4 35.0 14.0 2.0   9.0 0.0     0.0   10.0   45.0 25.0     *   5.0     51.0   19.0   70.0 35 14 2   9 0     0   10   45 25       5   51 19   70
1950547 MN Washington 82 school 2718750 832 Independent Districts and Schools MAHTOMEDI PUBLIC SCHOOL DISTRICT 271875000868 10 O.H. ANDERSON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 03 05 2019   grade_4 205.0 7.0 9.0   0.0 7.0     0.0   10.0   122.0 116.0     6.0   0.0     27.0   39.0   238.0 205 7 9   0 7     0   10   122 116     6 0   27 39   238
1952208 MN Saint Louis 69 school 2700133 4020 Charter Schools DULUTH PUBLIC SCHOOLS ACADEMY 270013302711 10 NORTH STAR ACADEMY Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2019   grade_4 89.0 7.0 3.0   2.0 1.0     0.0   10.0   57.0 55.0     0.0   0.0     36.0   28.0   112.0 89 7 3   2 1     0   10   57 55     0 0   36 28   112
1953947 MN Wright 86 school 2710170 879 Independent Districts and Schools DELANO PUBLIC SCHOOL DISTRICT 271017000437 15 Delano Intermediate School Middle School (Grades 5-8) Regular School No Middle 04 06 2019   grade_4 155.0 1.0 4.0   0.0 3.0     0.0   10.0   79.0 94.0     4.0   0.0     22.0   34.0   173.0 155 1 4   0 3     0   10   79 94     4 0   22 34   173
1946019 MN Hennepin 27 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000116 413 MONROE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   grade_4 28.0 31.0 8.0   2.0 35.0     0.0   9.0   58.0 55.0     29.0   1.0     56.0   17.0   113.0 28 31 8   2 35     0   9   58 55     29 1   56 17   113
1946041 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000126 418 UNIVERSITY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   grade_4 62.0 31.0 3.0   0.0 3.0     0.0   9.0   58.0 50.0     9.0   6.0     56.0   23.0   108.0 62 31 3   0 3     0   9   58 50     9 6   56 23   108
1946070 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000120 423 RAMSEY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   grade_4 208.0 20.0 8.0   2.0 11.0     0.0   9.0   145.0 113.0     19.0   2.0     77.0   33.0   258.0 208 20 8   2 11     0   9   145 113     19 2   77 33   258
1946084 MN Hennepin 27 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318002193 425 OXBOW CREEK ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   grade_4 125.0 26.0 9.0   0.0 14.0     2.0   9.0   93.0 92.0     13.0   1.0     40.0   22.0   185.0 125 26 9   0 14     2   9   93 92     13 1   40 22   185
1946149 MN Anoka 2 school 2709510 13 Independent Districts and Schools COLUMBIA HEIGHTS PUBLIC SCHOOL DIST 270951000398 515 HIGHLAND ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   grade_4 15.0 26.0 27.0   2.0 2.0     0.0   9.0   37.0 44.0     30.0   2.0     59.0   14.0   81.0 15 26 27   2 2     0   9   37 44     30 2   59 14   81
1946210 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_4 88.0 9.0 1.0   1.0 9.0     0.0   9.0   53.0 64.0     *   *         *   117.0 88 9 1   1 9     0   9   53 64                 117
1946356 MN Benton 5 school 2732880 47 Independent Districts and Schools SAUK RAPIDS-RICE PUBLIC SCHOOLS 273288001430 3 MISSISSIPPI HEIGHTS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   grade_4 148.0 3.0 3.0   1.0 0.0     1.0   9.0   77.0 88.0     2.0   2.0     49.0   33.0   165.0 148 3 3   1 0     1   9   77 88     2 2   49 33   165
1946524 MN Carlton 9 school 2709420 94 Independent Districts and Schools CLOQUET PUBLIC SCHOOL DISTRICT 270942000380 101 CHURCHILL ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   grade_4 69.0 1.0 0.0   20.0 0.0     0.0   9.0   48.0 51.0     0.0   1.0     52.0   *   99.0 69 1 0   20 0     0   9   48 51     0 1   52     99
1946623 MN Carver 10 school 2708190 112 Independent Districts and Schools EASTERN CARVER COUNTY PUBLIC SCHOOL 270819000342 506 CHANHASSEN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   grade_4 63.0 5.0 7.0   0.0 3.0     0.0   9.0   48.0 39.0     4.0   0.0     19.0   15.0   87.0 63 5 7   0 3     0   9   48 39     4 0   19 15   87
1946708 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_4 155.0 1.0 5.0   0.0 6.0     0.0   9.0   89.0 87.0     5.0   0.0     55.0   28.0   176.0 155 1 5   0 6     0   9   89 87     5 0   55 28   176
1946896 MN Dakota 19 school 2707290 191 Independent Districts and Schools BURNSVILLE PUBLIC SCHOOL DISTRICT 270729000303 486 VISTA VIEW ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   grade_4 18.0 18.0 15.0   0.0 6.0     0.0   9.0   36.0 30.0     16.0   4.0     37.0   12.0   66.0 18 18 15   0 6     0   9   36 30     16 4   37 12   66
1947156 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239002283 719 SHANNON PARK ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2019   grade_4 100.0 2.0 6.0   0.0 16.0     0.0   9.0   66.0 67.0     5.0   0.0         12.0   133.0 100 2 6   0 16     0   9   66 67     5 0     12   133
1947165 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239002302 720 Oak Ridge Elementary School of Leadership, Environmental and Health Sciences Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   grade_4 36.0 33.0 5.0   1.0 5.0     0.0   9.0   44.0 45.0     18.0   1.0     46.0   18.0   89.0 36 33 5   1 5     0   9   44 45     18 1   46 18   89

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