Data source: Big Local News · About: Big Local

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

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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
1950735 MN Watonwan 83 school 2718570 837 Independent Districts and Schools MADELIA PUBLIC SCHOOL DISTRICT 271857000859 10 MADELIA ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   pre_kindergarten 25.0 0.0 20.0   0.0 0.0     0.0   0.0   21.0 24.0     12.0   *     19.0   0.0   45.0 25 0 20   0 0     0   0   21 24     12     19 0   45
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
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
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
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
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
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
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
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
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
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
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
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
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
1951407 MN Polk 60 school 2791449 2609 Independent Districts and Schools WIN-E-MAC SCHOOL DISTRICT 279144902320 10 WIN-E-MAC ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   pre_kindergarten 25.0 0.0 1.0   1.0 0.0     0.0   0.0   14.0 13.0     *   *         0.0   27.0 25 0 1   1 0     0   0   14 13             0   27
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
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
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
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
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
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
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
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
1951718 MN Red Lake 63 school 2700385 2906 Independent Districts and Schools Red Lake County Central Public Schools 270038504734 11 Red Lake County Central Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   pre_kindergarten 25.0 0.0 3.0   0.0 0.0     0.0   0.0   19.0 9.0     *   *     15.0   0.0   28.0 25 0 3   0 0     0   0   19 9           15 0   28
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
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
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
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
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
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
1948244 MN Itasca 31 school 2723310 319 Independent Districts and Schools NASHWAUK-KEEWATIN SCHOOL DISTRICT 272331001136 20 Keewatin-Nashwauk Elementary School Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   pre_kindergarten 25.0 1.0 2.0   0.0 0.0     0.0   3.0   17.0 14.0     *   0.0     19.0   0.0   31.0 25 1 2   0 0     0   3   17 14       0   19 0   31
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
1946852 MN Dakota 19 school 2707290 191 Independent Districts and Schools BURNSVILLE PUBLIC SCHOOL DISTRICT 270729004990 480 Diamondhead Ready to Learn Elementary School (Grades PK-6) Regular School No Prekindergarten PK PK 2019   pre_kindergarten 25.0 2.0 1.0   0.0 1.0     0.0   5.0   16.0 18.0     *   *         *   34.0 25 2 1   0 1     0   5   16 18                 34
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
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
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
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
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
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
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
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
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
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
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

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