Data source: Big Local News · About: Big Local

207 rows where grade = "pre_kindergarten", state = "MN" and year = 2019 sorted by white descending

View and edit SQL

year

  • 2019 · 207

grade

  • pre_kindergarten · 207
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
1946162 MN Anoka 2 school 2709510 13 Independent Districts and Schools COLUMBIA HEIGHTS PUBLIC SCHOOL DIST 270951000402 520 VALLEY VIEW ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   pre_kindergarten 9.0 14.0 19.0   0.0 1.0     0.0   3.0   26.0 20.0     *   0.0         0.0   46.0 9 14 19   0 1     0   3   26 20       0     0   46
1946323 MN Beltrami 4 school 2717010 36 Independent Districts and Schools KELLIHER PUBLIC SCHOOL DISTRICT 271701000786 10 KELLIHER ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   pre_kindergarten 9.0 0.0 0.0   3.0 0.0     0.0   0.0   5.0 7.0     *   *         0.0   12.0 9 0 0   3 0     0   0   5 7             0   12
1946882 MN Dakota 19 school 2707290 191 Independent Districts and Schools BURNSVILLE PUBLIC SCHOOL DISTRICT 270729000301 485 SIOUX TRAIL ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   pre_kindergarten 9.0 2.0 4.0   0.0 0.0     0.0   1.0   5.0 11.0     0.0   0.0         0.0   16.0 9 2 4   0 0     0   1   5 11     0 0     0   16
1947116 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   pre_kindergarten 9.0 19.0 7.0   0.0 1.0     0.0   4.0   18.0 22.0     *   0.0         0.0   40.0 9 19 7   0 1     0   4   18 22       0     0   40
1947522 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   pre_kindergarten 9.0 12.0 7.0   0.0 6.0     0.0   3.0   20.0 17.0     18.0   0.0     24.0   0.0   37.0 9 12 7   0 6     0   3   20 17     18 0   24 0   37
1947759 MN Hennepin 27 school 2725200 279 Independent Districts and Schools OSSEO PUBLIC SCHOOL DISTRICT 272520002211 668 EDINBROOK ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   pre_kindergarten 9.0 15.0 4.0   1.0 17.0     0.0   3.0   18.0 31.0     16.0   0.0     21.0   0.0   49.0 9 15 4   1 17     0   3   18 31     16 0   21 0   49
1947782 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   pre_kindergarten 9.0 5.0 2.0   0.0 4.0     0.0   4.0   10.0 14.0     *   0.0         0.0   24.0 9 5 2   0 4     0   4   10 14       0     0   24
1947907 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   pre_kindergarten 9.0 3.0 4.0   0.0 7.0     0.0   4.0   15.0 12.0     *   0.0         0.0   27.0 9 3 4   0 7     0   4   15 12       0     0   27
1948110 MN Hennepin 27 school 2706240 286 Independent Districts and Schools BROOKLYN CENTER SCHOOL DISTRICT 270624000274 480 EARLE BROWN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   pre_kindergarten 9.0 43.0 16.0   1.0 11.0     0.0   10.0   42.0 48.0     0.0   1.0     68.0   0.0   90.0 9 43 16   1 11     0   10   42 48     0 1   68 0   90
1949714 MN Rice 66 school 2711760 656 Independent Districts and Schools FARIBAULT PUBLIC SCHOOL DISTRICT 271176002675 45 ROOSEVELT ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   pre_kindergarten 9.0 2.0 4.0   1.0 0.0     0.0   0.0   4.0 12.0     0.0   0.0     11.0   0.0   16.0 9 2 4   1 0     0   0   4 12     0 0   11 0   16
1949723 MN Rice 66 school 2711760 656 Independent Districts and Schools FARIBAULT PUBLIC SCHOOL DISTRICT 271176004988 220 McKinley PreK Elementary School (Grades PK-6) Regular School No Prekindergarten PK PK 2019   pre_kindergarten 9.0 17.0 13.0   0.0 2.0     0.0   3.0   22.0 22.0     *   *         0.0   44.0 9 17 13   0 2     0   3   22 22             0   44
1946916 MN Dakota 19 school 2707290 191 Independent Districts and Schools BURNSVILLE PUBLIC SCHOOL DISTRICT 270729000302 489 SKY OAKS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   pre_kindergarten 8.0 13.0 3.0   0.0 0.0     0.0   6.0   11.0 19.0     0.0   0.0         0.0   30.0 8 13 3   0 0     0   6   11 19     0 0     0   30
1948254 MN Jackson 32 school 2713930 330 Independent Districts and Schools HERON LAKE-OKABENA SCHOOL DISTRICT 271393000015 10 HERON LAKE-OKABENA ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   pre_kindergarten 8.0 0.0 1.0   0.0 0.0     0.0   0.0   6.0 3.0     *   *         *   9.0 8 0 1   0 0     0   0   6 3                 9
1949309 MN Ramsey 62 school 2742360 624 Independent Districts and Schools WHITE BEAR LAKE SCHOOL DISTRICT 274236001795 834 VADNAIS HEIGHTS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   pre_kindergarten 8.0 2.0 1.0   0.0 8.0     0.0   1.0   5.0 15.0     *   *         *   20.0 8 2 1   0 8     0   1   5 15                 20
1949654 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384001634 578 OBAMA SERVICE LEARNING ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   pre_kindergarten 8.0 29.0 2.0   0.0 8.0     0.0   7.0   29.0 25.0     17.0   *     38.0   0.0   54.0 8 29 2   0 8     0   7   29 25     17     38 0   54
1949726 MN Rice 66 school 2711760 656 Independent Districts and Schools FARIBAULT PUBLIC SCHOOL DISTRICT 271176005109 230 FEC Pre K Elementary School (Grades PK-6) Regular School No Prekindergarten PK PK 2019   pre_kindergarten 8.0 4.0 4.0   0.0 0.0     0.0   1.0   7.0 10.0     *   *         0.0   17.0 8 4 4   0 0     0   1   7 10             0   17
1950359 MN Steele 74 school 2728050 761 Independent Districts and Schools OWATONNA PUBLIC SCHOOL DISTRICT 272805005202 907 Bright Beginnings Elementary School (Grades PK-6) Regular School No Prekindergarten PK PK 2019   pre_kindergarten 8.0 12.0 3.0   0.0 0.0     0.0   0.0   7.0 16.0     0.0   0.0     17.0   0.0   23.0 8 12 3   0 0     0   0   7 16     0 0   17 0   23
1950429 MN Traverse 78 school 2707110 801 Independent Districts and Schools BROWNS VALLEY PUBLIC SCHOOL DIST. 270711000279 10 BROWNS VALLEY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2019   pre_kindergarten 8.0 0.0 0.0   10.0 0.0     0.0   0.0   12.0 6.0     *   *     13.0   0.0   18.0 8 0 0   10 0     0   0   12 6           13 0   18
1950774 MN Wilkin 84 school 2707450 852 Independent Districts and Schools CAMPBELL-TINTAH PUBLIC SCHOOL DIST. 270745000319 10 CAMPBELL-TINTAH ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   pre_kindergarten 8.0 0.0 0.0   0.0 0.0     0.0   0.0   2.0 6.0     *   *         *   8.0 8 0 0   0 0     0   0   2 6                 8
1951155 MN Pine 58 school 2714070 2165 Independent Districts and Schools HINCKLEY-FINLAYSON SCHOOL DISTRICT 271407000585 30 FINLAYSON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   pre_kindergarten 8.0 0.0 0.0   0.0 0.0     0.0   0.0   4.0 4.0     *   *         *   8.0 8 0 0   0 0     0   0   4 4                 8
1951676 MN Lyon 42 school 2700326 2904 Independent Districts and Schools TRACY AREA PUBLIC SCHOOL DISTRICT 270032604393 2 TRACY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   pre_kindergarten 8.0 0.0 0.0   0.0 0.0     0.0   0.0   6.0 2.0     *   *         *   8.0 8 0 0   0 0     0   0   6 2                 8
1947538 MN Hennepin 27 school 2705790 271 Independent Districts and Schools BLOOMINGTON PUBLIC SCHOOL DISTRICT 270579000218 446 INDIAN MOUNDS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   pre_kindergarten 7.0 10.0 5.0   1.0 5.0     0.0   2.0   11.0 19.0     16.0   0.0         0.0   30.0 7 10 5   1 5     0   2   11 19     16 0     0   30
1947554 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   pre_kindergarten 7.0 9.0 7.0   0.0 7.0     0.0   5.0   23.0 12.0     *   0.0         0.0   35.0 7 9 7   0 7     0   5   23 12       0     0   35
1948305 MN Kandiyohi 34 school 2742720 347 Independent Districts and Schools WILLMAR PUBLIC SCHOOL DISTRICT 274272005083 110 Lakeland Elementary School Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   pre_kindergarten 7.0 16.0 22.0   0.0 0.0     1.0   0.0   22.0 24.0     0.0   0.0         0.0   46.0 7 16 22   0 0     1   0   22 24     0 0     0   46
1948898 MN Olmsted 55 school 2731800 535 Independent Districts and Schools ROCHESTER PUBLIC SCHOOL DISTRICT 273180005129 590 Hawthorne Readiness Plus Elementary School (Grades PK-6) Regular School No Prekindergarten PK PK 2019   pre_kindergarten 7.0 4.0 3.0   0.0 1.0     0.0   3.0   9.0 9.0     *   *         0.0   18.0 7 4 3   0 1     0   3   9 9             0   18
1949921 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   pre_kindergarten 7.0 1.0 0.0   0.0 0.0     0.0   0.0   3.0 5.0     *   *         *   8.0 7 1 0   0 0     0   0   3 5                 8
1949863 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   pre_kindergarten 69.0 1.0 1.0   1.0 0.0     0.0   1.0   32.0 41.0     0.0   0.0     19.0   0.0   73.0 69 1 1   1 0     0   1   32 41     0 0   19 0   73
1946171 MN Anoka 2 school 2712420 14 Independent Districts and Schools FRIDLEY PUBLIC SCHOOL DISTRICT 271242005082 6 Voluntary Prekindergarten School Elementary School (Grades PK-6) Regular School No Prekindergarten PK PK 2019   pre_kindergarten 66.0 30.0 10.0   0.0 7.0     0.0   13.0   53.0 73.0     0.0   0.0     52.0   0.0   126.0 66 30 10   0 7     0   13   53 73     0 0   52 0   126
1952090 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   pre_kindergarten 63.0 8.0 23.0   1.0 2.0     0.0   5.0   50.0 52.0     0.0   0.0         0.0   102.0 63 8 23   1 2     0   5   50 52     0 0     0   102
1952081 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   pre_kindergarten 62.0 6.0 12.0   0.0 1.0     0.0   4.0   37.0 48.0     0.0   0.0         0.0   85.0 62 6 12   0 1     0   4   37 48     0 0     0   85
1948172 MN Hubbard 29 school 2728080 309 Independent Districts and Schools PARK RAPIDS PUBLIC SCHOOL DISTRICT 272808004965 20 Frank White Education Center Elementary School (Grades PK-6) Regular School No Prekindergarten PK PK 2019   pre_kindergarten 60.0 0.0 1.0   1.0 0.0     0.0   2.0   28.0 36.0     *   *         0.0   64.0 60 0 1   1 0     0   2   28 36             0   64
1946051 MN Hennepin 27 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000104 421 EVERGREEN PARK ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   pre_kindergarten 6.0 23.0 3.0   0.0 22.0     0.0   2.0   25.0 31.0     0.0   0.0     37.0   0.0   56.0 6 23 3   0 22     0   2   25 31     0 0   37 0   56
1946873 MN Scott 70 school 2707290 191 Independent Districts and Schools BURNSVILLE PUBLIC SCHOOL DISTRICT 270729000300 484 M.W. SAVAGE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   pre_kindergarten 6.0 11.0 1.0   0.0 1.0     0.0   1.0   9.0 11.0     0.0   0.0         0.0   20.0 6 11 1   0 1     0   1   9 11     0 0     0   20
1947886 MN Hennepin 27 school 2731750 280 Independent Districts and Schools RICHFIELD PUBLIC SCHOOL DISTRICT 273175005189 10 Central Education Center Elementary School (Grades PK-6) Regular School No Prekindergarten PK PK 2019   pre_kindergarten 6.0 3.0 2.0   1.0 4.0     0.0   4.0   5.0 15.0     7.0   1.0     9.0   0.0   20.0 6 3 2   1 4     0   4   5 15     7 1   9 0   20
1948410 MN Lincoln 41 school 2713680 402 Independent Districts and Schools HENDRICKS PUBLIC SCHOOL DISTRICT 271368004987 120 Hendricks Preschool Elementary School (Grades PK-6) Regular School No Prekindergarten PK PK 2019   pre_kindergarten 6.0 0.0 0.0   0.0 0.0     0.0   0.0   4.0 2.0     *   *         *   6.0 6 0 0   0 0     0   0   4 2                 6
1949157 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   pre_kindergarten 6.0 9.0 2.0   0.0 19.0     0.0   3.0   17.0 22.0     *   0.0         0.0   39.0 6 9 2   0 19     0   3   17 22       0     0   39
1948439 MN Lyon 42 school 2718940 413 Independent Districts and Schools MARSHALL PUBLIC SCHOOL DISTRICT 271894005106 16 Marshall Early Childhood Voluntary PreK Elementary School (Grades PK-6) Regular School No Prekindergarten PK PK 2019   pre_kindergarten 55.0 1.0 8.0   0.0 4.0     0.0   1.0   34.0 35.0     0.0   0.0     26.0   0.0   69.0 55 1 8   0 4     0   1   34 35     0 0   26 0   69
1951464 MN Martin 46 school 2700124 2752 Independent Districts and Schools FAIRMONT AREA SCHOOL DISTRICT 270012400554 50 FAIRMONT ELEMENTARY SCHOOL Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   pre_kindergarten 55.0 1.0 8.0   1.0 0.0     0.0   1.0   29.0 37.0     0.0   0.0     30.0   0.0   66.0 55 1 8   1 0     0   1   29 37     0 0   30 0   66
1945920 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   pre_kindergarten 5.0 0.0 0.0   0.0 0.0     0.0   0.0   4.0 1.0     *   *         *   5.0 5 0 0   0 0     0   0   4 1                 5
1946153 MN Anoka 2 school 2709510 13 Independent Districts and Schools COLUMBIA HEIGHTS PUBLIC SCHOOL DIST 270951000400 517 NORTH PARK ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   pre_kindergarten 5.0 21.0 9.0   0.0 1.0     0.0   3.0   19.0 20.0     *   0.0         0.0   39.0 5 21 9   0 1     0   3   19 20       0     0   39
1947189 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   pre_kindergarten 5.0 3.0 10.0   0.0 0.0     0.0   0.0   9.0 9.0     0.0   0.0     8.0   0.0   18.0 5 3 10   0 0     0   0   9 9     0 0   8 0   18
1947825 MN Hennepin 27 school 2725200 279 Independent Districts and Schools OSSEO PUBLIC SCHOOL DISTRICT 272520001219 678 PALMER LAKE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   pre_kindergarten 5.0 5.0 2.0   0.0 12.0     0.0   1.0   17.0 8.0     11.0   0.0     11.0   0.0   25.0 5 5 2   0 12     0   1   17 8     11 0   11 0   25
1948347 MN Koochiching 36 school 2732700 363 Independent Districts and Schools SOUTH KOOCHICHING SCHOOL DISTRICT 273270001945 90 INDUS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   pre_kindergarten 5.0 0.0 0.0   0.0 0.0     0.0   0.0   3.0 2.0     *   *         *   5.0 5 0 0   0 0     0   0   3 2                 5
1948476 MN Mahnomen 44 school 2718660 432 Independent Districts and Schools MAHNOMEN PUBLIC SCHOOL DISTRICT 271866000865 10 MAHNOMEN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   pre_kindergarten 5.0 0.0 1.0   11.0 0.0     0.0   0.0   10.0 7.0     0.0   0.0     10.0   0.0   17.0 5 0 1   11 0     0   0   10 7     0 0   10 0   17
1948655 MN Mower 50 school 2703450 492 Independent Districts and Schools AUSTIN PUBLIC SCHOOL DISTRICT 270345000156 80 SUMNER ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 01 04 2019   pre_kindergarten 5.0 13.0 13.0   0.0 4.0     0.0   0.0   13.0 22.0     *   0.0         0.0   35.0 5 13 13   0 4     0   0   13 22       0     0   35
1949205 MN Ramsey 62 school 2732430 623 Independent Districts and Schools ROSEVILLE PUBLIC SCHOOL DISTRICT 273243005099 505 Fairview School Readiness Plus Elementary School (Grades PK-6) Regular School No Prekindergarten PK PK 2019   pre_kindergarten 5.0 10.0 1.0   0.0 16.0     0.0   2.0   20.0 14.0     *   *         0.0   34.0 5 10 1   0 16     0   2   20 14             0   34
1950218 MN Stearns 73 school 2733510 742 Independent Districts and Schools ST. CLOUD PUBLIC SCHOOL DISTRICT 273351001487 31 MADISON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   pre_kindergarten 5.0 19.0 0.0   1.0 2.0     0.0   3.0   20.0 10.0     0.0   *     23.0   0.0   30.0 5 19 0   1 2     0   3   20 10     0     23 0   30
1951561 MN Faribault 22 school 2700130 2860 Independent Districts and Schools BLUE EARTH AREA PUBLIC SCHOOL 270013000241 10 Blue Earth Area Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   pre_kindergarten 5.0 0.0 3.0   0.0 0.0     0.0   0.0   3.0 5.0     *   *         *   8.0 5 0 3   0 0     0   0   3 5                 8
1951777 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124000943 107 BETHUNE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   pre_kindergarten 5.0 26.0 2.0   0.0 0.0     0.0   3.0   15.0 21.0     0.0   *         0.0   36.0 5 26 2   0 0     0   3   15 21     0       0   36
1952035 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124002580 287 HALL INTERNATIONAL Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   pre_kindergarten 5.0 15.0 1.0   0.0 2.0     0.0   5.0   17.0 11.0     0.0   4.0     25.0   0.0   28.0 5 15 1   0 2     0   5   17 11     0 4   25 0   28
1950400 MN Swift 76 school 2704470 777 Independent Districts and Schools BENSON PUBLIC SCHOOL DISTRICT 270447000201 103 NORTHSIDE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   pre_kindergarten 49.0 0.0 0.0   0.0 0.0     0.0   1.0   31.0 19.0     0.0   0.0     17.0   0.0   50.0 49 0 0   0 0     0   1   31 19     0 0   17 0   50
1951570 MN Redwood 64 school 2700132 2884 Independent Districts and Schools RED ROCK CENTRAL SCHOOL DISTRICT 270013201419 30 RED ROCK CENTRAL ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2019   pre_kindergarten 45.0 0.0 2.0   0.0 0.0     0.0   0.0   22.0 25.0     *   *     16.0   0.0   47.0 45 0 2   0 0     0   0   22 25           16 0   47
1950993 MN Faribault 22 school 2700005 2134 Independent Districts and Schools UNITED SOUTH CENTRAL SCHOOL DIST. 270000501769 10 UNITED SOUTH CENTRAL ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   pre_kindergarten 42.0 1.0 3.0   0.0 0.0     0.0   4.0   24.0 26.0     0.0   *     24.0   0.0   50.0 42 1 3   0 0     0   4   24 26     0     24 0   50
1951223 MN Marshall 45 school 2700024 2176 Independent Districts and Schools WARREN-ALVARADO-OSLO SCHOOL DIST. 270002401742 10 WARREN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   pre_kindergarten 42.0 0.0 7.0   0.0 0.0     0.0   3.0   32.0 20.0     0.0   0.0     17.0   0.0   52.0 42 0 7   0 0     0   3   32 20     0 0   17 0   52
1948201 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   pre_kindergarten 40.0 1.0 1.0   15.0 0.0     0.0   6.0   33.0 30.0     0.0   0.0     42.0   0.0   63.0 40 1 1   15 0     0   6   33 30     0 0   42 0   63
1946864 MN Dakota 19 school 2707290 191 Independent Districts and Schools BURNSVILLE PUBLIC SCHOOL DISTRICT 270729000296 483 EDWARD NEILL ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   pre_kindergarten 4.0 13.0 3.0   1.0 1.0     0.0   1.0   8.0 15.0     0.0   0.0         0.0   23.0 4 13 3   1 1     0   1   8 15     0 0     0   23
1946891 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   pre_kindergarten 4.0 13.0 8.0   0.0 2.0     0.0   1.0   12.0 16.0     0.0   0.0         0.0   28.0 4 13 8   0 2     0   1   12 16     0 0     0   28
1947834 MN Hennepin 27 school 2725200 279 Independent Districts and Schools OSSEO PUBLIC SCHOOL DISTRICT 272520001220 679 PARK BROOK ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   pre_kindergarten 4.0 11.0 2.0   0.0 6.0     0.0   1.0   12.0 12.0     9.0   0.0         0.0   24.0 4 11 2   0 6     0   1   12 12     9 0     0   24
1948807 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   pre_kindergarten 4.0 5.0 7.0   0.0 1.0     0.0   1.0   11.0 7.0     *   0.0     11.0   0.0   18.0 4 5 7   0 1     0   1   11 7       0   11 0   18
1948823 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   pre_kindergarten 4.0 10.0 4.0   0.0 3.0     0.0   1.0   13.0 9.0     0.0   0.0         0.0   22.0 4 10 4   0 3     0   1   13 9     0 0     0   22
1949173 MN Ramsey 62 school 2723850 622 Independent Districts and Schools North St Paul-Maplewood Oakdale Public School District 272385001179 36 WEBSTER ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   pre_kindergarten 4.0 11.0 8.0   0.0 14.0     0.0   0.0   17.0 20.0     10.0   0.0         0.0   37.0 4 11 8   0 14     0   0   17 20     10 0     0   37
1949381 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384001571 433 DAYTONS BLUFF ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   pre_kindergarten 4.0 13.0 4.0   0.0 23.0     0.0   1.0   23.0 22.0     23.0   *     33.0   0.0   45.0 4 13 4   0 23     0   1   23 22     23     33 0   45
1950725 MN Watonwan 83 school 2707320 836 Independent Districts and Schools BUTTERFIELD PUBLIC SCHOOL DISTRICT 270732000304 10 BUTTERFIELD ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   pre_kindergarten 4.0 0.0 7.0   0.0 0.0     0.0   0.0   6.0 5.0     0.0   *         0.0   11.0 4 0 7   0 0     0   0   6 5     0       0   11
1951036 MN Saint Louis 69 school 2700008 2142 Independent Districts and Schools ST. LOUIS COUNTY SCHOOL DISTRICT 270000801684 20 Tower-Soudan Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   pre_kindergarten 4.0 0.0 0.0   5.0 0.0     0.0   1.0   5.0 5.0     *   0.0         0.0   10.0 4 0 0   5 0     0   1   5 5       0     0   10
1951372 MN Norman 54 school 2791448 2527 Independent Districts and Schools NORMAN COUNTY WEST SCHOOL DISTRICT 279144802317 1 NORMAN COUNTY WEST ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   pre_kindergarten 4.0 0.0 5.0   0.0 0.0     0.0   0.0   4.0 5.0     *   *         *   9.0 4 0 5   0 0     0   0   4 5                 9
1951949 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124000932 190 ANDERSEN COMMUNITY Elementary School (Grades PK-6) Regular School No Elementary PK 08 2019   pre_kindergarten 4.0 14.0 19.0   0.0 1.0     0.0   0.0   18.0 20.0     0.0   0.0     31.0   0.0   38.0 4 14 19   0 1     0   0   18 20     0 0   31 0   38
1951980 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124004172 225 ANISHINABE ACADEMY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   pre_kindergarten 4.0 7.0 6.0   16.0 0.0     0.0   6.0   15.0 24.0     0.0   3.0     34.0   0.0   39.0 4 7 6   16 0     0   6   15 24     0 3   34 0   39
1952072 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124004778 293 Cityview Community Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   pre_kindergarten 4.0 24.0 4.0   1.0 1.0     0.0   4.0   15.0 23.0     1.0   *         0.0   38.0 4 24 4   1 1     0   4   15 23     1       0   38
1952312 MN Winona 85 school 2700221 4064 Charter Schools RIVERWAY LEARNING COMMUNITY CHTR 270022103478 10 Riverway Learning Community Charter Elementary School (Grades PK-6) Regular School Yes Elementary PK 06 2019   pre_kindergarten 4.0 1.0 0.0   0.0 0.0     0.0   2.0   2.0 5.0     *   *         *   7.0 4 1 0   0 0     0   2   2 5                 7
1951454 MN Saint Louis 69 school 2791450 2711 Independent Districts and Schools MESABI EAST SCHOOL DISTRICT 279145002323 10 MESABI EAST ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   pre_kindergarten 37.0 0.0 0.0   0.0 0.0     0.0   3.0   19.0 21.0     0.0   0.0     12.0   0.0   40.0 37 0 0   0 0     0   3   19 21     0 0   12 0   40
1947242 MN Dakota 19 school 2715030 199 Independent Districts and Schools INVER GROVE HEIGHTS SCHOOLS 271503000766 578 SALEM HILLS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   pre_kindergarten 36.0 4.0 12.0   1.0 4.0     0.0   1.0   27.0 31.0     6.0   0.0         0.0   58.0 36 4 12   1 4     0   1   27 31     6 0     0   58
1951213 MN Cass 11 school 2728970 2174 Independent Districts and Schools PINE RIVER-BACKUS SCHOOL DISTRICT 272897000039 10 PINE RIVER-BACKUS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   pre_kindergarten 36.0 0.0 0.0   0.0 0.0     0.0   0.0   16.0 20.0     0.0   0.0     16.0   0.0   36.0 36 0 0   0 0     0   0   16 20     0 0   16 0   36
1951534 MN Norman 54 school 2700126 2854 Independent Districts and Schools ADA-BORUP PUBLIC SCHOOL DISTRICT 270012600050 10 ADA ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   pre_kindergarten 36.0 0.0 1.0   0.0 0.0     0.0   1.0   23.0 15.0     0.0   0.0     16.0   0.0   38.0 36 0 1   0 0     0   1   23 15     0 0   16 0   38
1951623 MN Jackson 32 school 2700231 2895 Independent Districts and Schools JACKSON COUNTY CENTRAL SCHOOL DIST. 270023100774 112 RIVERSIDE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   pre_kindergarten 36.0 1.0 2.0   0.0 0.0     0.0   1.0   19.0 21.0     0.0   0.0     19.0   0.0   40.0 36 1 2   0 0     0   1   19 21     0 0   19 0   40
1948191 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   pre_kindergarten 34.0 0.0 0.0   1.0 0.0     0.0   6.0   20.0 21.0     0.0   1.0     28.0   0.0   41.0 34 0 0   1 0     0   6   20 21     0 1   28 0   41
1948662 MN Mower 50 school 2703450 492 Independent Districts and Schools AUSTIN PUBLIC SCHOOL DISTRICT 270345005043 105 CLC - Pre-Kindergarten Elementary School (Grades PK-6) Regular School No Prekindergarten PK PK 2019   pre_kindergarten 34.0 7.0 28.0   0.0 23.0     0.0   5.0   49.0 48.0     *   0.0         0.0   97.0 34 7 28   0 23     0   5   49 48       0     0   97
1950362 MN Unknown   school 2728050 761 Independent Districts and Schools OWATONNA PUBLIC SCHOOL DISTRICT 272805005195 908 Owatonna School Readiness Elementary School (Grades PK-6) Regular School No Prekindergarten PK PK 2019   pre_kindergarten 34.0 14.0 12.0   0.0 4.0     0.0   1.0   32.0 33.0     0.0   0.0     50.0   0.0   65.0 34 14 12   0 4     0   1   32 33     0 0   50 0   65
1946767 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   pre_kindergarten 33.0 0.0 0.0   1.0 0.0     0.0   2.0   22.0 14.0     0.0   0.0     7.0   0.0   36.0 33 0 0   1 0     0   2   22 14     0 0   7 0   36
1948162 MN Hubbard 29 school 2723370 308 Independent Districts and Schools NEVIS PUBLIC SCHOOL DISTRICT 272337001139 10 NEVIS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   pre_kindergarten 33.0 0.0 2.0   0.0 0.0     0.0   1.0   20.0 16.0     *   *         0.0   36.0 33 0 2   0 0     0   1   20 16             0   36
1951146 MN Pine 58 school 2714070 2165 Independent Districts and Schools HINCKLEY-FINLAYSON SCHOOL DISTRICT 271407000728 10 HINCKLEY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   pre_kindergarten 33.0 0.0 2.0   5.0 3.0     0.0   2.0   19.0 26.0     *   *         *   45.0 33 0 2   5 3     0   2   19 26                 45
1949072 MN Ramsey 62 school 2722950 621 Independent Districts and Schools MOUNDS VIEW PUBLIC SCHOOL DISTRICT 272295004813 20 Pike Lake Kindergarten Center Elementary School (Grades PK-6) Regular School No Elementary PK KG 2019   pre_kindergarten 32.0 29.0 28.0   0.0 15.0     0.0   4.0   52.0 56.0     0.0   0.0     84.0   0.0   108.0 32 29 28   0 15     0   4   52 56     0 0   84 0   108
1951397 MN Pine 58 school 2711085 2580 Independent Districts and Schools EAST CENTRAL SCHOOL DISTRICT 271108500157 10 EAST CENTRAL ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   pre_kindergarten 32.0 1.0 1.0   1.0 0.0     0.0   2.0   24.0 13.0     0.0   0.0     19.0   0.0   37.0 32 1 1   1 0     0   2   24 13     0 0   19 0   37
1947924 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   pre_kindergarten 31.0 13.0 10.0   0.0 1.0     0.0   10.0   28.0 37.0     0.0   0.0     18.0   0.0   65.0 31 13 10   0 1     0   10   28 37     0 0   18 0   65
1947372 MN Freeborn 24 school 2702970 241 Independent Districts and Schools ALBERT LEA PUBLIC SCHOOL DISTRICT 270297000070 110 HALVERSON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   pre_kindergarten 30.0 3.0 13.0   0.0 9.0     0.0   3.0   23.0 35.0     0.0   0.0         0.0   58.0 30 3 13   0 9     0   3   23 35     0 0     0   58
1951046 MN Saint Louis 69 school 2700008 2142 Independent Districts and Schools ST. LOUIS COUNTY SCHOOL DISTRICT 270000804509 40 SOUTH RIDGE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   pre_kindergarten 30.0 0.0 1.0   0.0 0.0     0.0   0.0   17.0 14.0     0.0   0.0     13.0   0.0   31.0 30 0 1   0 0     0   0   17 14     0 0   13 0   31
1947807 MN Hennepin 27 school 2725200 279 Independent Districts and Schools OSSEO PUBLIC SCHOOL DISTRICT 272520001212 674 FAIR OAKS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   pre_kindergarten 3.0 11.0 8.0   0.0 15.0     0.0   0.0   9.0 28.0     14.0   0.0     20.0   0.0   37.0 3 11 8   0 15     0   0   9 28     14 0   20 0   37
1948900 MN Olmsted 55 school 2731800 535 Independent Districts and Schools ROCHESTER PUBLIC SCHOOL DISTRICT 273180005132 595 Northrop Readiness Plus Elementary School (Grades PK-6) Regular School No Prekindergarten PK PK 2019   pre_kindergarten 3.0 8.0 1.0   0.0 0.0     0.0   1.0   6.0 7.0     0.0   *     11.0   0.0   13.0 3 8 1   0 0     0   1   6 7     0     11 0   13
1949317 MN Ramsey 62 school 2742360 624 Independent Districts and Schools WHITE BEAR LAKE SCHOOL DISTRICT 274236001798 836 WILLOW LANE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   pre_kindergarten 3.0 6.0 5.0   0.0 3.0     2.0   1.0   12.0 8.0     0.0   0.0     17.0   0.0   20.0 3 6 5   0 3     2   1   12 8     0 0   17 0   20
1949568 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384001609 524 MAXFIELD ELEMENTARY SCHOOL Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   pre_kindergarten 3.0 17.0 5.0   1.0 3.0     0.0   9.0   16.0 22.0     8.0   4.0     26.0   0.0   38.0 3 17 5   1 3     0   9   16 22     8 4   26 0   38
1951930 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124000986 179 JEFFERSON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 08 2019   pre_kindergarten 3.0 10.0 9.0   0.0 1.0     0.0   1.0   10.0 14.0     0.0   0.0         0.0   24.0 3 10 9   0 1     0   1   10 14     0 0     0   24
1952151 MN Ramsey 62 school 2700115 4015 Charter Schools COMMUNITY OF PEACE ACADEMY 270011502605 10 Community of Peace Academy Elementary School Elementary School (Grades PK-6) Regular School Yes Elementary PK 06 2019   pre_kindergarten 3.0 8.0 3.0   0.0 20.0     0.0   0.0   16.0 18.0     0.0   0.0         0.0   34.0 3 8 3   0 20     0   0   16 18     0 0     0   34
1952426 MN Hennepin 27 school 2700237 4097 Charter Schools PARTNERSHIP ACADEMY, INC. 270023704966 20 Early Wonders Preschool Partnership Academy Elementary School (Grades PK-6) Regular School Yes Prekindergarten PK PK 2019   pre_kindergarten 3.0 4.0 7.0   0.0 1.0     0.0   2.0   9.0 8.0     8.0   0.0     8.0   0.0   17.0 3 4 7   0 1     0   2   9 8     8 0   8 0   17
1950752 MN Watonwan 83 school 2733600 840 Independent Districts and Schools ST. JAMES PUBLIC SCHOOL DISTRICT 273360004814 25 Armstrong School Elementary School (Grades PK-6) Regular School No Prekindergarten PK PK 2019   pre_kindergarten 29.0 0.0 20.0   0.0 0.0     0.0   1.0   22.0 28.0     0.0   0.0     17.0   0.0   50.0 29 0 20   0 0     0   1   22 28     0 0   17 0   50
1951605 MN Renville 65 school 2700163 2890 Independent Districts and Schools RENVILLE COUNTY WEST SCHOOL DIST. 270016301417 1 RENVILLE COUNTY WEST ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   pre_kindergarten 29.0 1.0 3.0   0.0 0.0     0.0   3.0   14.0 22.0     0.0   *         0.0   36.0 29 1 3   0 0     0   3   14 22     0       0   36
1946313 MN Beltrami 4 school 2705730 32 Independent Districts and Schools BLACKDUCK PUBLIC SCHOOL DISTRICT 270573000212 10 BLACKDUCK ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   pre_kindergarten 28.0 0.0 1.0   1.0 0.0     0.0   2.0   14.0 18.0     *   *         0.0   32.0 28 0 1   1 0     0   2   14 18             0   32
1951065 MN Saint Louis 69 school 2700008 2142 Independent Districts and Schools ST. LOUIS COUNTY SCHOOL DISTRICT 270000801513 96 CHERRY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   pre_kindergarten 28.0 0.0 0.0   0.0 0.0     0.0   3.0   16.0 15.0     *   0.0         0.0   31.0 28 0 0   0 0     0   3   16 15       0     0   31
1946477 MN Brown 8 school 2733210 84 Independent Districts and Schools SLEEPY EYE PUBLIC SCHOOL DISTRICT 273321001450 10 SLEEPY EYE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   pre_kindergarten 27.0 0.0 13.0   0.0 0.0     0.0   0.0   18.0 22.0     0.0   0.0     17.0   0.0   40.0 27 0 13   0 0     0   0   18 22     0 0   17 0   40
1946777 MN Cook 16 school 2713110 166 Independent Districts and Schools COOK COUNTY PUBLIC SCHOOLS 271311000658 60 SAWTOOTH MOUNTAIN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   pre_kindergarten 27.0 0.0 5.0   0.0 0.0     1.0   1.0   19.0 15.0     0.0   0.0     9.0   0.0   34.0 27 0 5   0 0     1   1   19 15     0 0   9 0   34
1947949 MN Hennepin 27 school 2731780 281 Independent Districts and Schools ROBBINSDALE PUBLIC SCHOOL DISTRICT 273178001326 10 MEADOW LAKE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   pre_kindergarten 26.0 22.0 12.0   1.0 5.0     1.0   1.0   25.0 43.0     0.0   0.0         0.0   68.0 26 22 12   1 5     1   1   25 43     0 0     0   68
1952636 MN Mcleod 43 school 2700277 4161 Charter Schools NEW DISCOVERIES MONTESSORI ACADEMY 270027703616 10 NEW DISCOVERIES MONTESSORI ACADEMY Elementary School (Grades PK-6) Regular School Yes Elementary PK 07 2019   pre_kindergarten 26.0 1.0 2.0   0.0 0.0     0.0   1.0   10.0 20.0     *   *     13.0   0.0   30.0 26 1 2   0 0     0   1   10 20           13 0   30

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