Data source: Big Local News · About: Big Local

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

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
1948740 MN Nobles 53 school 2744160 518 Independent Districts and Schools WORTHINGTON PUBLIC SCHOOL DISTRICT 274416001836 1 PRAIRIE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2019   pre_kindergarten 0.0 1.0 23.0   0.0 4.0     0.0   0.0   15.0 13.0     0.0   0.0     6.0   0.0   28.0 0 1 23   0 4     0   0   15 13     0 0   6 0   28
1949270 MN Ramsey 62 school 2742360 624 Independent Districts and Schools WHITE BEAR LAKE SCHOOL DISTRICT 274236001786 827 BIRCH LAKE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   pre_kindergarten 0.0 1.0 1.0   0.0 0.0     0.0   0.0   0.0 2.0     *   *         *   2.0 0 1 1   0 0     0   0   0 2                 2
1949645 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384004491 558 SAINT PAUL MUSIC ACADEMY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   pre_kindergarten 0.0 4.0 7.0   0.0 27.0     0.0   0.0   16.0 22.0     *   0.0     34.0   0.0   38.0 0 4 7   0 27     0   0   16 22       0   34 0   38
1952113 MN Hennepin 27 school 2700027 4004 Charter Schools CEDAR RIVERSIDE COMMUNITY SCHOOL 270002702340 10 CEDAR RIVERSIDE COMMUNITY SCHOOL Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2019   pre_kindergarten 0.0 19.0 1.0   0.0 0.0     0.0   0.0   8.0 12.0     0.0   *         0.0   20.0 0 19 1   0 0     0   0   8 12     0       0   20
1952193 MN Ramsey 62 school 2700118 4018 Charter Schools ACHIEVE LANGUAGE ACADEMY 270011802608 10 ACHIEVE LANGUAGE ACADEMY Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2019   pre_kindergarten 0.0 3.0 13.0   0.0 16.0     0.0   3.0   14.0 21.0     0.0   0.0     21.0   0.0   35.0 0 3 13   0 16     0   3   14 21     0 0   21 0   35
1952232 MN Ramsey 62 school 2700142 4029 Charter Schools ST. PAUL CITY SCHOOL 270014202721 10 ST. PAUL CITY PRIMARY SCHOOL Elementary School (Grades PK-6) Regular School Yes Elementary PK 05 2019   pre_kindergarten 0.0 7.0 10.0   0.0 16.0     0.0   0.0   16.0 17.0     0.0   *     28.0   0.0   33.0 0 7 10   0 16     0   0   16 17     0     28 0   33
1952249 MN Hennepin 27 school 2700159 4038 Charter Schools SOJOURNER TRUTH ACADEMY 270015902954 10 SOJOURNER TRUTH ACADEMY Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2019   pre_kindergarten 0.0 16.0 4.0   0.0 0.0     0.0   4.0   15.0 9.0     0.0   1.0         0.0   24.0 0 16 4   0 0     0   4   15 9     0 1     0   24
1952322 MN Hennepin 27 school 2700220 4067 Charter Schools AURORA CHARTER SCHOOL 270022003473 10 AURORA CHARTER SCHOOL Elementary School (Grades PK-6) Regular School Yes Elementary PK 04 2019   pre_kindergarten 0.0 0.0 19.0   0.0 0.0     0.0   0.0   13.0 6.0     17.0   *     17.0   0.0   19.0 0 0 19   0 0     0   0   13 6     17     17 0   19
1952351 MN Ramsey 62 school 2700185 4073 Charter Schools Academia Cesar Chavez Charter School 270018503138 10 Academia Cesar Chavez Charter School Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2019   pre_kindergarten 0.0 1.0 36.0   0.0 0.0     0.0   0.0   15.0 22.0     0.0   *     25.0   0.0   37.0 0 1 36   0 0     0   0   15 22     0     25 0   37
1952711 MN Ramsey 62 school 2700304 4181 Charter Schools COMMUNITY SCHOOL OF EXCELLENCE 270030403728 10 COMMUNITY SCHOOL OF EXCELLENCE Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2019   pre_kindergarten 0.0 0.0 0.0   0.0 40.0     0.0   0.0   19.0 21.0     33.0   0.0     29.0   0.0   40.0 0 0 0   0 40     0   0   19 21     33 0   29 0   40
1952891 MN Ramsey 62 school 2700386 4215 Charter Schools Sejong Academy of Minnesota 270038604695 10 Sejong Academy of Minnesota Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2019   pre_kindergarten 0.0 0.0 0.0   0.0 10.0     0.0   0.0   8.0 2.0     *   0.0         0.0   10.0 0 0 0   0 10     0   0   8 2       0     0   10
1947791 MN Hennepin 27 school 2725200 279 Independent Districts and Schools OSSEO PUBLIC SCHOOL DISTRICT 272520001210 672 CREST VIEW ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   pre_kindergarten 1.0 25.0 3.0   0.0 9.0     0.0   3.0   15.0 26.0     *   *     25.0   0.0   41.0 1 25 3   0 9     0   3   15 26           25 0   41
1947816 MN Hennepin 27 school 2725200 279 Independent Districts and Schools OSSEO PUBLIC SCHOOL DISTRICT 272520001213 675 GARDEN CITY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   pre_kindergarten 1.0 10.0 11.0   0.0 19.0     0.0   4.0   20.0 25.0     18.0   1.0     19.0   0.0   45.0 1 10 11   0 19     0   4   20 25     18 1   19 0   45
1947843 MN Hennepin 27 school 2725200 279 Independent Districts and Schools OSSEO PUBLIC SCHOOL DISTRICT 272520001224 681 ZANEWOOD COMMUNITY SCHOOL Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   pre_kindergarten 1.0 25.0 9.0   1.0 9.0     0.0   3.0   23.0 25.0     15.0   *     33.0   0.0   48.0 1 25 9   1 9     0   3   23 25     15     33 0   48
1951961 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124002297 193 SULLIVAN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 08 2019   pre_kindergarten 1.0 22.0 1.0   0.0 0.0     0.0   0.0   11.0 13.0     0.0   3.0     21.0   0.0   24.0 1 22 1   0 0     0   0   11 13     0 3   21 0   24
1952240 MN Ramsey 62 school 2700156 4035 Charter Schools Life Prep 270015602951 10 LIFE Prep Elementary School (Grades PK-6) Regular School Yes Elementary PK 06 2019   pre_kindergarten 1.0 20.0 0.0   0.0 16.0     0.0   2.0   13.0 26.0     0.0   0.0     33.0   0.0   39.0 1 20 0   0 16     0   2   13 26     0 0   33 0   39
1952329 MN Hennepin 27 school 2700184 4068 Charter Schools EXCELL ACADEMY CHARTER 270018403137 10 EXCELL ACADEMY CHARTER Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2019   pre_kindergarten 1.0 40.0 6.0   0.0 0.0     0.0   1.0   22.0 26.0     0.0   0.0     37.0   0.0   48.0 1 40 6   0 0     0   1   22 26     0 0   37 0   48
1952392 MN Ramsey 62 school 2700353 4088 Charter Schools URBAN ACADEMY CHARTER SCHOOL 270035304173 10 URBAN ACADEMY CHARTER SCHOOL Elementary School (Grades PK-6) Regular School Yes Elementary PK 06 2019   pre_kindergarten 1.0 11.0 3.0   1.0 25.0     0.0   0.0   17.0 24.0     0.0   0.0         0.0   41.0 1 11 3   1 25     0   0   17 24     0 0     0   41
1952880 MN Hennepin 27 school 2700380 4213 Charter Schools Prodeo Academy 270038004642 10 Prodeo Academy Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2019   pre_kindergarten 1.0 44.0 5.0   0.0 1.0     1.0   3.0   26.0 29.0     16.0   0.0     0.0   0.0   55.0 1 44 5   0 1     1   3   26 29     16 0   0 0   55
1952981 MN Hennepin 27 school 2700406 4230 Charter Schools Minnesota Excellence in Learning Academy 270040604843 10 Minnesota Excellence in Learning Academy Elementary School (Grades PK-6) Regular School Yes Elementary PK 06 2019   pre_kindergarten 1.0 16.0 0.0   0.0 0.0     0.0   2.0   8.0 11.0     0.0   0.0     15.0   0.0   19.0 1 16 0   0 0     0   2   8 11     0 0   15 0   19
1946282 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   pre_kindergarten 10.0 1.0 1.0   1.0 0.0     0.0   2.0   7.0 8.0     0.0   0.0         0.0   15.0 10 1 1   1 0     0   2   7 8     0 0     0   15
1946289 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   pre_kindergarten 10.0 0.0 0.0   1.0 0.0     0.0   4.0   11.0 4.0     0.0   0.0         0.0   15.0 10 0 0   1 0     0   4   11 4     0 0     0   15
1946664 MN Cass 11 school 2702910 113 Independent Districts and Schools WALKER-HACKENSACK-AKELEY SCHL. DIST 270291001736 10 W.H.A. ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   pre_kindergarten 10.0 0.0 0.0   0.0 0.0     0.0   2.0   3.0 9.0     0.0   0.0     2.0   0.0   12.0 10 0 0   0 0     0   2   3 9     0 0   2 0   12
1946925 MN Scott 70 school 2707290 191 Independent Districts and Schools BURNSVILLE PUBLIC SCHOOL DISTRICT 270729002233 490 HIDDEN VALLEY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   pre_kindergarten 10.0 19.0 24.0   0.0 0.0     0.0   2.0   22.0 33.0     0.0   0.0     37.0   0.0   55.0 10 19 24   0 0     0   2   22 33     0 0   37 0   55
1947898 MN Hennepin 27 school 2731750 280 Independent Districts and Schools RICHFIELD PUBLIC SCHOOL DISTRICT 273175001311 695 CENTENNIAL ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   pre_kindergarten 10.0 8.0 19.0   1.0 1.0     0.0   7.0   22.0 24.0     *   0.0     31.0   0.0   46.0 10 8 19   1 1     0   7   22 24       0   31 0   46
1949114 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   pre_kindergarten 10.0 12.0 6.0   0.0 7.0     0.0   3.0   17.0 21.0     *   0.0         0.0   38.0 10 12 6   0 7     0   3   17 21       0     0   38
1950209 MN Benton 5 school 2733510 742 Independent Districts and Schools ST. CLOUD PUBLIC SCHOOL DISTRICT 273351001486 28 Lincoln Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   pre_kindergarten 10.0 14.0 4.0   1.0 0.0     0.0   1.0   14.0 16.0     0.0   0.0         0.0   30.0 10 14 4   1 0     0   1   14 16     0 0     0   30
1949189 MN Ramsey 62 school 2723850 622 Independent Districts and Schools North St Paul-Maplewood Oakdale Public School District 272385005100 38 Gladstone Voluntary Pre-K Elementary School (Grades PK-6) Regular School No Prekindergarten PK PK 2019   pre_kindergarten 11.0 5.0 5.0   0.0 20.0     0.0   5.0   21.0 25.0     12.0   0.0     14.0   0.0   46.0 11 5 5   0 20     0   5   21 25     12 0   14 0   46
1947444 MN Grant 26 school 2703300 261 Independent Districts and Schools ASHBY PUBLIC SCHOOL DISTRICT 270330000136 10 ASHBY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   pre_kindergarten 12.0 0.0 0.0   0.0 0.0     0.0   0.0   8.0 4.0     0.0   0.0     0.0   0.0   12.0 12 0 0   0 0     0   0   8 4     0 0   0 0   12
1948450 MN Lyon 42 school 2718390 415 Independent Districts and Schools LYND PUBLIC SCHOOL DISTRICT 271839000856 10 LYND ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   pre_kindergarten 12.0 0.0 2.0   0.0 0.0     0.0   2.0   11.0 5.0     1.0   0.0     8.0   0.0   16.0 12 0 2   0 0     0   2   11 5     1 0   8 0   16
1948557 MN Mille Lacs 48 school 2715510 473 Independent Districts and Schools ISLE PUBLIC SCHOOL DISTRICT 271551000769 10 ISLE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   pre_kindergarten 12.0 0.0 1.0   1.0 0.0     0.0   1.0   6.0 9.0     *   *         0.0   15.0 12 0 1   1 0     0   1   6 9             0   15
1949192 MN Unknown   school 2723850 622 Independent Districts and Schools North St Paul-Maplewood Oakdale Public School District 272385005156 42 Beaver Lake Voluntary Pre-K Elementary School (Grades PK-6) Regular School No Prekindergarten PK PK 2019   pre_kindergarten 12.0 5.0 2.0   0.0 16.0     0.0   3.0   24.0 14.0     13.0   0.0     8.0   0.0   38.0 12 5 2   0 16     0   3   24 14     13 0   8 0   38
1950808 MN Winona 85 school 2744070 861 Independent Districts and Schools WINONA AREA PUBLIC SCHOOL DISTRICT 274407001829 12 WASHINGTON-KOSCIUSKO ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2019   pre_kindergarten 12.0 1.0 0.0   0.0 0.0     0.0   1.0   5.0 9.0     0.0   0.0     8.0   0.0   14.0 12 1 0   0 0     0   1   5 9     0 0   8 0   14
1951587 MN Big Stone 6 school 2700150 2888 Independent Districts and Schools CLINTON-GRACEVILLE-BEARDSLEY 270015000378 1 CLINTON-GRACEVILLE-BEARDSLEY EL. Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   pre_kindergarten 12.0 0.0 2.0   0.0 0.0     0.0   0.0   7.0 7.0     *   *     3.0   0.0   14.0 12 0 2   0 0     0   0   7 7           3 0   14
1946219 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   pre_kindergarten 13.0 2.0 6.0   0.0 5.0     0.0   2.0   15.0 13.0     0.0   0.0         0.0   28.0 13 2 6   0 5     0   2   15 13     0 0     0   28
1946855 MN Dakota 19 school 2707290 191 Independent Districts and Schools BURNSVILLE PUBLIC SCHOOL DISTRICT 270729000298 482 GIDEON POND ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   pre_kindergarten 13.0 11.0 2.0   0.0 2.0     0.0   2.0   17.0 13.0     *   *         *   30.0 13 11 2   0 2     0   2   17 13                 30
1948678 MN Mower 50 school 2718360 497 Independent Districts and Schools LYLE PUBLIC SCHOOL DISTRICT 271836000853 10 LYLE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   pre_kindergarten 13.0 0.0 1.0   0.0 0.0     0.0   1.0   9.0 6.0     0.0   *         0.0   15.0 13 0 1   0 0     0   1   9 6     0       0   15
1948973 MN Pennington 57 school 2713020 561 Independent Districts and Schools GOODRIDGE PUBLIC SCHOOL DISTRICT 271302000649 10 GOODRIDGE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   pre_kindergarten 13.0 0.0 0.0   1.0 0.0     0.0   2.0   7.0 9.0     *   *     8.0   0.0   16.0 13 0 0   1 0     0   2   7 9           8 0   16
1949026 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   pre_kindergarten 13.0 1.0 11.0   2.0 0.0     0.0   1.0   16.0 12.0     0.0   2.0     24.0   0.0   28.0 13 1 11   2 0     0   1   16 12     0 2   24 0   28
1950227 MN Stearns 73 school 2733510 742 Independent Districts and Schools ST. CLOUD PUBLIC SCHOOL DISTRICT 273351002287 35 DISCOVERY COMMUNITY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   pre_kindergarten 13.0 32.0 6.0   1.0 0.0     0.0   4.0   32.0 24.0     *   0.0     39.0   0.0   56.0 13 32 6   1 0     0   4   32 24       0   39 0   56
1950569 MN Washington 82 school 2733810 833 Independent Districts and Schools SOUTH WASHINGTON COUNTY SCHOOL DIST 273381001538 32 CRESTVIEW ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   pre_kindergarten 13.0 1.0 2.0   0.0 2.0     0.0   2.0   12.0 8.0     *   0.0         0.0   20.0 13 1 2   0 2     0   2   12 8       0     0   20
1950764 MN Wilkin 84 school 2732460 850 Independent Districts and Schools ROTHSAY PUBLIC SCHOOL DISTRICT 273246001400 10 ROTHSAY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   pre_kindergarten 13.0 0.0 1.0   0.0 0.0     0.0   0.0   7.0 7.0     *   0.0     0.0   0.0   14.0 13 0 1   0 0     0   0   7 7       0   0 0   14
1951273 MN Norman 54 school 2700101 2215 Independent Districts and Schools NORMAN COUNTY EAST SCHOOL DISTRICT 270010100622 10 NORMAN COUNTY EAST ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   pre_kindergarten 13.0 0.0 1.0   0.0 0.0     0.0   0.0   5.0 9.0     0.0   0.0     8.0   0.0   14.0 13 0 1   0 0     0   0   5 9     0 0   8 0   14
1946036 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   pre_kindergarten 14.0 5.0 5.0   0.0 3.0     0.0   2.0   16.0 13.0     0.0   0.0     9.0   0.0   29.0 14 5 5   0 3     0   2   16 13     0 0   9 0   29
1947160 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   pre_kindergarten 14.0 16.0 12.0   0.0 7.0     0.0   5.0   28.0 26.0     *   0.0         0.0   54.0 14 16 12   0 7     0   5   28 26       0     0   54
1947584 MN Hennepin 27 school 2705790 271 Independent Districts and Schools BLOOMINGTON PUBLIC SCHOOL DISTRICT 270579000238 459 VALLEY VIEW ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   pre_kindergarten 14.0 13.0 18.0   0.0 6.0     0.0   7.0   25.0 33.0     *   0.0         0.0   58.0 14 13 18   0 6     0   7   25 33       0     0   58
1947973 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   pre_kindergarten 14.0 10.0 4.0   0.0 1.0     0.0   6.0   20.0 15.0     0.0   0.0         0.0   35.0 14 10 4   0 1     0   6   20 15     0 0     0   35
1948576 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   pre_kindergarten 14.0 2.0 2.0   3.0 0.0     0.0   2.0   8.0 15.0     0.0   2.0     16.0   0.0   23.0 14 2 2   3 0     0   2   8 15     0 2   16 0   23
1949132 MN Ramsey 62 school 2723850 622 Independent Districts and Schools North St Paul-Maplewood Oakdale Public School District 272385001168 29 COWERN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   pre_kindergarten 14.0 5.0 3.0   0.0 7.0     0.0   5.0   15.0 19.0     5.0   *         0.0   34.0 14 5 3   0 7     0   5   15 19     5       0   34
1949148 MN Washington 82 school 2723850 622 Independent Districts and Schools North St Paul-Maplewood Oakdale Public School District 272385001175 33 OAKDALE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   pre_kindergarten 14.0 5.0 4.0   0.0 10.0     0.0   4.0   17.0 20.0     *   0.0         0.0   37.0 14 5 4   0 10     0   4   17 20       0     0   37
1949913 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   pre_kindergarten 14.0 2.0 0.0   3.0 0.0     0.0   2.0   8.0 13.0     *   *         *   21.0 14 2 0   3 0     0   2   8 13                 21
1950236 MN Sherburne 71 school 2733510 742 Independent Districts and Schools ST. CLOUD PUBLIC SCHOOL DISTRICT 273351002286 36 TALAHI COMMUNITY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   pre_kindergarten 14.0 31.0 4.0   0.0 1.0     0.0   6.0   31.0 25.0     *   *     42.0   0.0   56.0 14 31 4   0 1     0   6   31 25           42 0   56
1951314 MN Kittson 35 school 2791446 2358 Independent Districts and Schools TRI-COUNTY SCHOOL DISTRICT 279144602313 10 KARLSTAD ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   pre_kindergarten 14.0 0.0 0.0   0.0 0.0     0.0   0.0   4.0 10.0     *   *     12.0   0.0   14.0 14 0 0   0 0     0   0   4 10           12 0   14
1946144 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   pre_kindergarten 15.0 17.0 10.0   1.0 4.0     0.0   6.0   28.0 25.0     0.0   0.0         0.0   53.0 15 17 10   1 4     0   6   28 25     0 0     0   53
1947233 MN Dakota 19 school 2715030 199 Independent Districts and Schools INVER GROVE HEIGHTS SCHOOLS 271503000547 577 PINE BEND ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   pre_kindergarten 15.0 5.0 7.0   0.0 0.0     0.0   1.0   11.0 17.0     7.0   0.0         0.0   28.0 15 5 7   0 0     0   1   11 17     7 0     0   28
1947505 MN Hennepin 27 school 2714260 270 Independent Districts and Schools HOPKINS PUBLIC SCHOOL DISTRICT 271426001880 569 GATEWOOD ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   pre_kindergarten 15.0 12.0 2.0   0.0 1.0     0.0   4.0   17.0 17.0     0.0   0.0         0.0   34.0 15 12 2   0 1     0   4   17 17     0 0     0   34
1947915 MN Hennepin 27 school 2731750 280 Independent Districts and Schools RICHFIELD PUBLIC SCHOOL DISTRICT 273175004212 705 RICHFIELD DUAL LANGUAGE SCHOOL Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   pre_kindergarten 15.0 1.0 22.0   0.0 0.0     0.0   2.0   11.0 29.0     17.0   0.0     22.0   0.0   40.0 15 1 22   0 0     0   2   11 29     17 0   22 0   40
1948216 MN Itasca 31 school 2713170 318 Independent Districts and Schools GRAND RAPIDS PUBLIC SCHOOL DISTRICT 271317000882 115 BIGFORK ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   pre_kindergarten 15.0 0.0 0.0   0.0 0.0     0.0   1.0   9.0 7.0     *   *         0.0   16.0 15 0 0   0 0     0   1   9 7             0   16
1948489 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   pre_kindergarten 15.0 0.0 1.0   28.0 0.0     0.0   7.0   23.0 28.0     *   3.0         0.0   51.0 15 0 1   28 0     0   7   23 28       3     0   51
1949795 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   pre_kindergarten 15.0 0.0 0.0   1.0 1.0     0.0   0.0   10.0 7.0     *   *         0.0   17.0 15 0 0   1 1     0   0   10 7             0   17
1949930 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   pre_kindergarten 15.0 0.0 0.0   0.0 0.0     0.0   2.0   6.0 11.0     0.0   0.0         0.0   17.0 15 0 0   0 0     0   2   6 11     0 0     0   17
1950599 MN Washington 82 school 2733810 833 Independent Districts and Schools SOUTH WASHINGTON COUNTY SCHOOL DIST 273381001541 38 NEWPORT ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   pre_kindergarten 15.0 3.0 1.0   0.0 6.0     0.0   0.0   10.0 15.0     6.0   0.0         0.0   25.0 15 3 1   0 6     0   0   10 15     6 0     0   25
1946396 MN Blue Earth 7 school 2718780 77 Independent Districts and Schools MANKATO PUBLIC SCHOOL DISTRICT 271878000877 10 KENNEDY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   pre_kindergarten 16.0 6.0 4.0   0.0 0.0     0.0   0.0   14.0 12.0     0.0   1.0     11.0   0.0   26.0 16 6 4   0 0     0   0   14 12     0 1   11 0   26
1947996 MN Hennepin 27 school 2731780 281 Independent Districts and Schools ROBBINSDALE PUBLIC SCHOOL DISTRICT 273178001337 22 SONNESYN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   pre_kindergarten 16.0 8.0 5.0   0.0 3.0     0.0   3.0   21.0 14.0     0.0   0.0         0.0   35.0 16 8 5   0 3     0   3   21 14     0 0     0   35
1948296 MN Kandiyohi 34 school 2742720 347 Independent Districts and Schools WILLMAR PUBLIC SCHOOL DISTRICT 274272002445 109 KENNEDY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   pre_kindergarten 16.0 15.0 15.0   0.0 1.0     0.0   1.0   33.0 15.0     0.0   0.0         0.0   48.0 16 15 15   0 1     0   1   33 15     0 0     0   48
1949009 MN Pipestone 59 school 2711220 581 Independent Districts and Schools EDGERTON PUBLIC SCHOOL DISTRICT 271122000503 20 EDGERTON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   pre_kindergarten 16.0 0.0 2.0   1.0 0.0     0.0   1.0   13.0 7.0     0.0   0.0     4.0   0.0   20.0 16 0 2   1 0     0   1   13 7     0 0   4 0   20
1949123 MN Washington 82 school 2723850 622 Independent Districts and Schools North St Paul-Maplewood Oakdale Public School District 272385002182 28 CASTLE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   pre_kindergarten 16.0 6.0 2.0   0.0 10.0     0.0   3.0   19.0 18.0     *   *         0.0   37.0 16 6 2   0 10     0   3   19 18             0   37
1949939 MN Saint Louis 69 school 2711040 709 Independent Districts and Schools DULUTH PUBLIC SCHOOL DISTRICT 271104000485 565 STOWE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   pre_kindergarten 16.0 0.0 0.0   1.0 0.0     0.0   2.0   7.0 12.0     0.0   0.0         0.0   19.0 16 0 0   1 0     0   2   7 12     0 0     0   19
1950622 MN Washington 82 school 2733810 833 Independent Districts and Schools SOUTH WASHINGTON COUNTY SCHOOL DIST 273381001545 42 PULLMAN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   pre_kindergarten 16.0 1.0 1.0   0.0 2.0     0.0   2.0   14.0 8.0     *   0.0     7.0   0.0   22.0 16 1 1   0 2     0   2   14 8       0   7 0   22
1951526 MN Swift 76 school 2700125 2853 Independent Districts and Schools LAC QUI PARLE VALLEY SCHOOL DIST. 270012500129 20 APPLETON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2019   pre_kindergarten 16.0 0.0 2.0   0.0 0.0     10.0   0.0   16.0 12.0     0.0   *     21.0   0.0   28.0 16 0 2   0 0     10   0   16 12     0     21 0   28
1947933 MN Hennepin 27 school 2731780 281 Independent Districts and Schools ROBBINSDALE PUBLIC SCHOOL DISTRICT 273178001323 6 LAKEVIEW ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   pre_kindergarten 17.0 5.0 10.0   0.0 1.0     0.0   3.0   19.0 17.0     0.0   0.0         0.0   36.0 17 5 10   0 1     0   3   19 17     0 0     0   36
1948152 MN Hubbard 29 school 2717940 306 Independent Districts and Schools LAPORTE PUBLIC SCHOOL DISTRICT 271794000825 10 LAPORTE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   pre_kindergarten 17.0 0.0 0.0   1.0 0.0     0.0   0.0   8.0 10.0     0.0   0.0     5.0   0.0   18.0 17 0 0   1 0     0   0   8 10     0 0   5 0   18
1948516 MN Martin 46 school 2740680 458 Independent Districts and Schools TRUMAN PUBLIC SCHOOL DISTRICT 274068001692 10 TRUMAN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   pre_kindergarten 17.0 0.0 0.0   0.0 0.0     2.0   0.0   10.0 9.0     *   *     12.0   0.0   19.0 17 0 0   0 0     2   0   10 9           12 0   19
1946688 MN Cass 11 school 2730870 118 Independent Districts and Schools NORTHLAND COMMUNITY SCHOOLS 273087001307 10 REMER ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   pre_kindergarten 18.0 0.0 0.0   6.0 0.0     0.0   2.0   16.0 10.0     *   *     19.0   0.0   26.0 18 0 0   6 0     0   2   16 10           19 0   26
1947957 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   pre_kindergarten 18.0 7.0 0.0   0.0 3.0     0.0   8.0   13.0 23.0     0.0   0.0     10.0   0.0   36.0 18 7 0   0 3     0   8   13 23     0 0   10 0   36
1950253 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   pre_kindergarten 18.0 32.0 1.0   0.0 2.0     0.0   0.0   28.0 25.0     0.0   0.0         0.0   53.0 18 32 1   0 2     0   0   28 25     0 0     0   53
1950410 MN Todd 77 school 2705430 786 Independent Districts and Schools Bertha-Hewitt Public School District 270543000203 10 BERTHA ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   pre_kindergarten 18.0 0.0 0.0   0.0 0.0     0.0   0.0   12.0 6.0     *   0.0         0.0   18.0 18 0 0   0 0     0   0   12 6       0     0   18
1945937 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000095 400 ADAMS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   pre_kindergarten 19.0 4.0 1.0   0.0 8.0     0.0   2.0   12.0 22.0     0.0   0.0     13.0   0.0   34.0 19 4 1   0 8     0   2   12 22     0 0   13 0   34
1947889 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   pre_kindergarten 19.0 7.0 11.0   1.0 10.0     0.0   6.0   27.0 27.0     19.0   0.0         0.0   54.0 19 7 11   1 10     0   6   27 27     19 0     0   54
1948287 MN Kandiyohi 34 school 2742720 347 Independent Districts and Schools WILLMAR PUBLIC SCHOOL DISTRICT 274272002221 108 ROOSEVELT ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   pre_kindergarten 19.0 11.0 5.0   0.0 0.0     0.0   1.0   17.0 19.0     0.0   0.0     18.0   0.0   36.0 19 11 5   0 0     0   1   17 19     0 0   18 0   36
1948383 MN Lake of the Woods 39 school 2717570 390 Independent Districts and Schools LAKE OF THE WOODS SCHOOL DISTRICT 271757000808 224 LAKE OF THE WOODS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   pre_kindergarten 19.0 1.0 0.0   0.0 0.0     0.0   0.0   10.0 10.0     *   0.0         0.0   20.0 19 1 0   0 0     0   0   10 10       0     0   20
1949814 MN Saint Louis 69 school 2712210 698 Independent Districts and Schools FLOODWOOD PUBLIC SCHOOL DISTRICT 271221000588 10 FLOODWOOD ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   pre_kindergarten 19.0 2.0 1.0   0.0 0.0     0.0   1.0   12.0 11.0     0.0   0.0     14.0   0.0   23.0 19 2 1   0 0     0   1   12 11     0 0   14 0   23
1950437 MN Traverse 78 school 2742330 803 Independent Districts and Schools WHEATON AREA PUBLIC SCHOOL DISTRICT 274233001783 1 PEARSON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   pre_kindergarten 19.0 0.0 3.0   0.0 0.0     0.0   1.0   13.0 10.0     0.0   *         0.0   23.0 19 0 3   0 0     0   1   13 10     0       0   23
1949207 MN Ramsey 62 school 2732430 623 Independent Districts and Schools ROSEVILLE PUBLIC SCHOOL DISTRICT 273243004842 525 Harambee Elementary School Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   pre_kindergarten 2.0 4.0 3.0   0.0 5.0     0.0   1.0   6.0 9.0     *   *         0.0   15.0 2 4 3   0 5     0   1   6 9             0   15
1949333 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384003454 415 JOHN A. JOHNSON ACHIEVEMENT PLUS EL. Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   pre_kindergarten 2.0 9.0 3.0   0.0 10.0     0.0   2.0   10.0 16.0     16.0   1.0     21.0   0.0   26.0 2 9 3   0 10     0   2   10 16     16 1   21 0   26
1949398 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384001575 449 BRUCE F VENTO ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   pre_kindergarten 2.0 8.0 5.0   1.0 56.0     0.0   3.0   31.0 44.0     55.0   0.0     58.0   0.0   75.0 2 8 5   1 56     0   3   31 44     55 0   58 0   75
1949439 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384001581 464 FROST LAKE ELEMENTARY SCHOOL Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   pre_kindergarten 2.0 4.0 4.0   0.0 21.0     0.0   1.0   8.0 24.0     25.0   0.0         0.0   32.0 2 4 4   0 21     0   1   8 24     25 0     0   32
1949538 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384001593 496 HIGHWOOD HILLS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   pre_kindergarten 2.0 25.0 2.0   0.0 6.0     0.0   1.0   21.0 15.0     28.0   *         0.0   36.0 2 25 2   0 6     0   1   21 15     28       0   36
1949577 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384001611 527 Mississippi Creative Arts Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   pre_kindergarten 2.0 4.0 3.0   0.0 31.0     0.0   2.0   28.0 14.0     31.0   0.0     31.0   0.0   42.0 2 4 3   0 31     0   2   28 14     31 0   31 0   42
1949663 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   pre_kindergarten 2.0 5.0 6.0   3.0 6.0     0.0   10.0   8.0 24.0     *   0.0     26.0   0.0   32.0 2 5 6   3 6     0   10   8 24       0   26 0   32
1951639 MN Redwood 64 school 2700183 2898 Independent Districts and Schools WESTBROOK-WALNUT GROVE SCHOOLS 270018301738 15 WALNUT GROVE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   pre_kindergarten 2.0 0.0 0.0   0.0 2.0     0.0   0.0   2.0 2.0     *   *         *   4.0 2 0 0   0 2     0   0   2 2                 4
1952009 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124001879 256 GREEN CENTRAL PARK ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   pre_kindergarten 2.0 9.0 17.0   2.0 2.0     0.0   0.0   16.0 16.0     1.0   0.0     28.0   0.0   32.0 2 9 17   2 2     0   0   16 16     1 0   28 0   32
1952026 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124002476 282 LUCY LANEY @ CLEVELAND PARK ELEM. Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   pre_kindergarten 2.0 9.0 0.0   0.0 1.0     0.0   6.0   9.0 9.0     0.0   0.0         0.0   18.0 2 9 0   0 1     0   6   9 9     0 0     0   18
1952044 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124002699 288 NELLIE STONE JOHNSON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   pre_kindergarten 2.0 24.0 7.0   0.0 2.0     0.0   2.0   20.0 17.0     0.0   4.0         0.0   37.0 2 24 7   0 2     0   2   20 17     0 4     0   37
1945928 MN Aitkin 1 school 2719170 4 Independent Districts and Schools MCGREGOR PUBLIC SCHOOL DISTRICT 271917000903 10 MCGREGOR ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   pre_kindergarten 20.0 0.0 0.0   0.0 0.0     0.0   0.0   8.0 12.0     0.0   0.0     3.0   0.0   20.0 20 0 0   0 0     0   0   8 12     0 0   3 0   20
1947982 MN Hennepin 27 school 2731780 281 Independent Districts and Schools ROBBINSDALE PUBLIC SCHOOL DISTRICT 273178001330 19 NORTHPORT ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   pre_kindergarten 20.0 18.0 14.0   0.0 7.0     0.0   7.0   28.0 38.0     0.0   0.0         0.0   66.0 20 18 14   0 7     0   7   28 38     0 0     0   66
1948622 MN Morrison 49 school 2738280 486 Independent Districts and Schools SWANVILLE PUBLIC SCHOOL DISTRICT 273828001670 10 SWANVILLE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   pre_kindergarten 22.0 0.0 1.0   0.0 0.0     0.0   1.0   7.0 17.0     0.0   *         0.0   24.0 22 0 1   0 0     0   1   7 17     0       0   24
1948938 MN Otter Tail 56 school 2728170 548 Independent Districts and Schools PELICAN RAPIDS PUBLIC SCHOOL DIST. 272817001242 10 VIKING ELEMENTARY SCHOOL Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   pre_kindergarten 22.0 2.0 11.0   0.0 1.0     0.0   0.0   18.0 18.0     0.0   0.0         0.0   36.0 22 2 11   0 1     0   0   18 18     0 0     0   36
1947381 MN Freeborn 24 school 2702970 241 Independent Districts and Schools ALBERT LEA PUBLIC SCHOOL DISTRICT 270297000071 120 HAWTHORNE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   pre_kindergarten 23.0 1.0 5.0   0.0 1.0     0.0   1.0   15.0 16.0     0.0   0.0         0.0   31.0 23 1 5   0 1     0   1   15 16     0 0     0   31
1951728 MN Nobles 53 school 2700388 2907 Independent Districts and Schools ROUND LAKE-BREWSTER PUBLIC SCHOOLS 270038804736 10 Round Lake-Brewster Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 08 2019   pre_kindergarten 23.0 1.0 31.0   0.0 1.0     0.0   1.0   25.0 32.0     0.0   *     31.0   0.0   57.0 23 1 31   0 1     0   1   25 32     0     31 0   57

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