Data source: Big Local News · About: Big Local

917 rows where grade = "pre_kindergarten" and state = "MN"

View and edit SQL

year

grade

  • pre_kindergarten · 917
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
690565 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 2017   pre_kindergarten 11.0 0.0 1.0   0.0 0.0     0.0   0.0   7.0 5.0     0.0   0.0     2.0   0.0   12.0 11 0 1   0 0     0   0   7 5     0 0   2 0   12
690574 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 2017   pre_kindergarten 22.0 0.0 2.0   0.0 0.0     0.0   3.0   12.0 15.0     0.0   0.0     10.0   0.0   27.0 22 0 2   0 0     0   3   12 15     0 0   10 0   27
690687 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 2017   pre_kindergarten 10.0 10.0 2.0   0.0 9.0     0.0   1.0   15.0 17.0     0.0   0.0     14.0   0.0   32.0 10 10 2   0 9     0   1   15 17     0 0   14 0   32
690780 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 2017   pre_kindergarten 18.0 11.0 7.0   1.0 2.0     0.0   9.0   25.0 23.0     0.0   *         0.0   48.0 18 11 7   1 2     0   9   25 23     0       0   48
690789 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 2017   pre_kindergarten 14.0 7.0 2.0   0.0 0.0     0.0   4.0   15.0 12.0     0.0   *         0.0   27.0 14 7 2   0 0     0   4   15 12     0       0   27
690798 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 2017   pre_kindergarten 14.0 12.0 13.0   0.0 1.0     0.0   4.0   20.0 24.0     0.0   0.0         0.0   44.0 14 12 13   0 1     0   4   20 24     0 0     0   44
690814 MN Anoka 2 school 2712420 14 Independent Districts and Schools FRIDLEY PUBLIC SCHOOL DISTRICT 271242000614 550 STEVENSON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2017   pre_kindergarten 34.0 18.0 8.0   1.0 5.0     0.0   4.0   27.0 43.0     0.0   1.0     31.0   0.0   70.0 34 18 8   1 5     0   4   27 43     0 1   31 0   70
690950 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 2017   pre_kindergarten 21.0 0.0 0.0   0.0 0.0     0.0   0.0   13.0 8.0     0.0   *         0.0   21.0 21 0 0   0 0     0   0   13 8     0       0   21
690960 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 2017   pre_kindergarten 7.0 0.0 0.0   2.0 0.0     0.0   0.0   6.0 3.0         *         *   9.0 7 0 0   2 0     0   0   6 3                 9
691034 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 2017   pre_kindergarten 12.0 4.0 2.0   0.0 0.0     0.0   1.0   6.0 13.0     0.0   0.0         0.0   19.0 12 4 2   0 0     0   1   6 13     0 0     0   19
691326 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 2017   pre_kindergarten 5.0 0.0 0.0   0.0 0.0     0.0   2.0   2.0 5.0         *         *   7.0 5 0 0   0 0     0   2   2 5                 7
691403 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 2017   pre_kindergarten 29.0 0.0 0.0   1.0 0.0     0.0   2.0   13.0 19.0     0.0   0.0     11.0   0.0   32.0 29 0 0   1 0     0   2   13 19     0 0   11 0   32
691413 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 2017   pre_kindergarten 39.0 0.0 3.0   1.0 0.0     0.0   4.0   24.0 23.0     0.0   0.0     9.0   0.0   47.0 39 0 3   1 0     0   4   24 23     0 0   9 0   47
691489 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 Elementary PK PK 2017   pre_kindergarten 16.0 0.0 2.0   0.0 0.0     0.0   1.0   10.0 9.0     0.0   *     0.0   0.0   19.0 16 0 2   0 0     0   1   10 9     0     0 0   19
691534 MN Dakota 19 school 2707290 191 Independent Districts and Schools BURNSVILLE PUBLIC SCHOOL DISTRICT 270729000299 488 RAHN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   pre_kindergarten 9.0 4.0 3.0   0.0 5.0     0.0   1.0   7.0 15.0     0.0   *         0.0   22.0 9 4 3   0 5     0   1   7 15     0       0   22
691543 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 2017   pre_kindergarten 6.0 17.0 4.0   0.0 3.0     0.0   4.0   18.0 16.0     0.0   0.0         0.0   34.0 6 17 4   0 3     0   4   18 16     0 0     0   34
691552 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 2017   pre_kindergarten 1.0 12.0 12.0   0.0 1.0     0.0   3.0   11.0 18.0     0.0   0.0     18.0   0.0   29.0 1 12 12   0 1     0   3   11 18     0 0   18 0   29
691743 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 2017   pre_kindergarten 6.0 10.0 2.0   0.0 2.0     0.0   0.0   10.0 10.0     0.0   0.0         0.0   20.0 6 10 2   0 2     0   0   10 10     0 0     0   20
691985 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 2017   pre_kindergarten 29.0 3.0 14.0   0.0 8.0     0.0   4.0   35.0 23.0     0.0   0.0         0.0   58.0 29 3 14   0 8     0   4   35 23     0 0     0   58
691994 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 2017   pre_kindergarten 22.0 0.0 6.0   1.0 0.0     0.0   2.0   17.0 14.0     0.0   0.0         0.0   31.0 22 0 6   1 0     0   2   17 14     0 0     0   31
692131 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 2017   pre_kindergarten 7.0 9.0 10.0   0.0 3.0     0.0   2.0   13.0 18.0     0.0   0.0         0.0   31.0 7 9 10   0 3     0   2   13 18     0 0     0   31
692146 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 2017   pre_kindergarten 5.0 5.0 7.0   0.0 0.0     0.0   1.0   8.0 10.0     0.0   0.0     10.0   0.0   18.0 5 5 7   0 0     0   1   8 10     0 0   10 0   18
692161 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 2017   pre_kindergarten 6.0 4.0 3.0   0.0 0.0     0.0   3.0   4.0 12.0     0.0   0.0         0.0   16.0 6 4 3   0 0     0   3   4 12     0 0     0   16
692191 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 2017   pre_kindergarten 4.0 22.0 19.0   0.0 3.0     0.0   0.0   19.0 29.0     0.0   2.0     37.0   0.0   48.0 4 22 19   0 3     0   0   19 29     0 2   37 0   48
692366 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 2017   pre_kindergarten 1.0 11.0 2.0   0.0 8.0     0.0   2.0   11.0 13.0     7.0   0.0     9.0   0.0   24.0 1 11 2   0 8     0   2   11 13     7 0   9 0   24
692388 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 2017   pre_kindergarten 6.0 5.0 6.0   0.0 5.0     0.0   7.0   14.0 15.0     9.0   0.0     14.0   0.0   29.0 6 5 6   0 5     0   7   14 15     9 0   14 0   29
692397 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 2017   pre_kindergarten 3.0 14.0 2.0   0.0 5.0     0.0   3.0   12.0 15.0         0.0     12.0   0.0   27.0 3 14 2   0 5     0   3   12 15       0   12 0   27
692413 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 2017   pre_kindergarten 1.0 11.0 6.0   0.0 4.0     0.0   1.0   13.0 10.0         0.0     16.0   0.0   23.0 1 11 6   0 4     0   1   13 10       0   16 0   23
692422 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 2017   pre_kindergarten 3.0 16.0 2.0   0.0 19.0     0.0   1.0   22.0 19.0     15.0   0.0     21.0   0.0   41.0 3 16 2   0 19     0   1   22 19     15 0   21 0   41
692431 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 2017   pre_kindergarten 4.0 7.0 1.0   0.0 10.0     0.0   2.0   12.0 12.0         0.0         0.0   24.0 4 7 1   0 10     0   2   12 12       0     0   24
692440 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 2017   pre_kindergarten 0.0 18.0 1.0   0.0 6.0     0.0   1.0   14.0 12.0     6.0   0.0     17.0   0.0   26.0 0 18 1   0 6     0   1   14 12     6 0   17 0   26
692449 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 2017   pre_kindergarten 0.0 15.0 2.0   0.0 4.0     0.0   1.0   14.0 8.0         0.0         0.0   22.0 0 15 2   0 4     0   1   14 8       0     0   22
692493 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 2017   pre_kindergarten 15.0 14.0 16.0   0.0 7.0     1.0   11.0   35.0 29.0     0.0   *         0.0   64.0 15 14 16   0 7     1   11   35 29     0       0   64
692502 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 2017   pre_kindergarten 2.0 5.0 17.0   1.0 3.0     0.0   2.0   11.0 19.0     0.0   *     26.0   0.0   30.0 2 5 17   1 3     0   2   11 19     0     26 0   30
692511 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 2017   pre_kindergarten 5.0 7.0 10.0   0.0 2.0     0.0   4.0   10.0 18.0     0.0   *         0.0   28.0 5 7 10   0 2     0   4   10 18     0       0   28
692696 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 2017   pre_kindergarten 10.0 39.0 19.0   1.0 14.0     0.0   5.0   43.0 45.0     0.0   *         0.0   88.0 10 39 19   1 14     0   5   43 45     0       0   88
692738 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 2017   pre_kindergarten 16.0 0.0 0.0   3.0 0.0     0.0   0.0   6.0 13.0         *     12.0   0.0   19.0 16 0 0   3 0     0   0   6 13           12 0   19
692748 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 2017   pre_kindergarten 33.0 0.0 0.0   0.0 0.0     0.0   0.0   22.0 11.0         0.0         0.0   33.0 33 0 0   0 0     0   0   22 11       0     0   33
692758 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 Elementary PK PK 2017   pre_kindergarten 38.0 0.0 1.0   0.0 0.0     0.0   2.0   23.0 18.0         *         0.0   41.0 38 0 1   0 0     0   2   23 18             0   41
692777 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 2017   pre_kindergarten 47.0 0.0 2.0   1.0 0.0     0.0   2.0   29.0 23.0     0.0   0.0     32.0   0.0   52.0 47 0 2   1 0     0   2   29 23     0 0   32 0   52
692787 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 2017   pre_kindergarten 30.0 0.0 1.0   11.0 0.0     0.0   11.0   29.0 24.0     0.0   1.0     35.0   0.0   53.0 30 0 1   11 0     0   11   29 24     0 1   35 0   53
692802 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 2017   pre_kindergarten 18.0 0.0 0.0   1.0 0.0     0.0   4.0   12.0 11.0         0.0     15.0   0.0   23.0 18 0 0   1 0     0   4   12 11       0   15 0   23
692839 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 2017   pre_kindergarten 14.0 0.0 0.0   0.0 0.0     0.0   0.0   8.0 6.0     0.0   *     6.0   0.0   14.0 14 0 0   0 0     0   0   8 6     0     6 0   14
692873 MN Kandiyohi 34 school 2742720 347 Independent Districts and Schools WILLMAR PUBLIC SCHOOL DISTRICT 274272005053 99 Willmar Voluntary Pre-K Elementary School (Grades PK-6) Regular School No Elementary PK PK 2017   pre_kindergarten 8.0 15.0 7.0   0.0 0.0     0.0   0.0   13.0 17.0         *         0.0   30.0 8 15 7   0 0     0   0   13 17             0   30
692984 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 Elementary PK PK 2017   pre_kindergarten 9.0 0.0 0.0   0.0 0.0     0.0   0.0   1.0 8.0         *         *   9.0 9 0 0   0 0     0   0   1 8                 9
693022 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 2017   pre_kindergarten 16.0 0.0 3.0   0.0 0.0     0.0   0.0   11.0 8.0         *         0.0   19.0 16 0 3   0 0     0   0   11 8             0   19
693048 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 2017   pre_kindergarten 5.0 0.0 1.0   2.0 0.0     0.0   7.0   8.0 7.0         *     10.0   0.0   15.0 5 0 1   2 0     0   7   8 7           10 0   15
693061 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 2017   pre_kindergarten 14.0 0.0 0.0   25.0 0.0     0.0   6.0   25.0 20.0         *         0.0   45.0 14 0 0   25 0     0   6   25 20             0   45
693088 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 2017   pre_kindergarten 17.0 0.0 1.0   0.0 1.0     0.0   1.0   11.0 9.0         *     13.0   0.0   20.0 17 0 1   0 1     0   1   11 9           13 0   20
693129 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 2017   pre_kindergarten 12.0 0.0 0.0   0.0 0.0     0.0   0.0   8.0 4.0         0.0         0.0   12.0 12 0 0   0 0     0   0   8 4       0     0   12
693148 MN Mille Lacs 48 school 2725050 480 Independent Districts and Schools ONAMIA PUBLIC SCHOOL DISTRICT 272505001195 10 ONAMIA ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   pre_kindergarten 12.0 0.0 0.0   0.0 1.0     0.0   1.0   5.0 9.0     0.0   0.0         0.0   14.0 12 0 0   0 1     0   1   5 9     0 0     0   14
693234 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 Elementary PK PK 2017   pre_kindergarten 20.0 2.0 19.0   0.0 3.0     0.0   1.0   30.0 15.0         *         0.0   45.0 20 2 19   0 3     0   1   30 15             0   45
693250 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 2017   pre_kindergarten 21.0 0.0 0.0   0.0 0.0     0.0   1.0   8.0 14.0     0.0   *     12.0   0.0   22.0 21 0 0   0 0     0   1   8 14     0     12 0   22
693510 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 2017   pre_kindergarten 17.0 2.0 7.0   0.0 0.0     0.0   1.0   19.0 8.0     0.0   0.0     12.0   0.0   27.0 17 2 7   0 0     0   1   19 8     0 0   12 0   27
693588 MN Polk 60 school 2709360 592 Independent Districts and Schools CLIMAX-SHELLY PUBLIC SCHOOLS 270936000377 10 CLIMAX ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   pre_kindergarten 11.0 0.0 3.0   0.0 0.0     0.0   0.0   7.0 7.0     0.0   0.0     8.0   0.0   14.0 11 0 3   0 0     0   0   7 7     0 0   8 0   14
693717 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 2017   pre_kindergarten 12.0 6.0 4.0   0.0 11.0     0.0   3.0   14.0 22.0     0.0   0.0     16.0   0.0   36.0 12 6 4   0 11     0   3   14 22     0 0   16 0   36
693732 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 2017   pre_kindergarten 12.0 13.0 4.0   0.0 5.0     0.0   4.0   21.0 17.0     0.0   0.0     22.0   0.0   38.0 12 13 4   0 5     0   4   21 17     0 0   22 0   38
694160 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 2017   pre_kindergarten 3.0 44.0 11.0   0.0 14.0     0.0   7.0   46.0 33.0     0.0   3.0     67.0   0.0   79.0 3 44 11   0 14     0   7   46 33     0 3   67 0   79
694221 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 Elementary PK PK 2017   pre_kindergarten 13.0 5.0 8.0   0.0 0.0     0.0   0.0   12.0 14.0         *         0.0   26.0 13 5 8   0 0     0   0   12 14             0   26
694308 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 2017   pre_kindergarten 28.0 0.0 0.0   1.0 0.0     0.0   1.0   16.0 14.0     0.0   0.0     9.0   0.0   30.0 28 0 0   1 0     0   1   16 14     0 0   9 0   30
694414 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 2017   pre_kindergarten 4.0 3.0 0.0   1.0 0.0     0.0   2.0   3.0 7.0     0.0   0.0         0.0   10.0 4 3 0   1 0     0   2   3 7     0 0     0   10
694423 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 2017   pre_kindergarten 30.0 0.0 1.0   0.0 1.0     0.0   2.0   22.0 12.0     0.0   0.0         0.0   34.0 30 0 1   0 1     0   2   22 12     0 0     0   34
694700 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 2017   pre_kindergarten 1.0 8.0 1.0   0.0 0.0     0.0   1.0   9.0 2.0     0.0   0.0         0.0   11.0 1 8 1   0 0     0   1   9 2     0 0     0   11
694716 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 2017   pre_kindergarten 3.0 14.0 0.0   0.0 0.0     0.0   1.0   9.0 9.0     0.0   0.0         0.0   18.0 3 14 0   0 0     0   1   9 9     0 0     0   18
694725 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 2017   pre_kindergarten 6.0 19.0 4.0   0.0 0.0     0.0   0.0   17.0 12.0     0.0   1.0     24.0   0.0   29.0 6 19 4   0 0     0   0   17 12     0 1   24 0   29
694880 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 2017   pre_kindergarten 30.0 0.0 1.0   0.0 0.0     0.0   0.0   16.0 15.0     0.0   *         0.0   31.0 30 0 1   0 0     0   0   16 15     0       0   31
694915 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 2017   pre_kindergarten 19.0 2.0 0.0   0.0 0.0     0.0   3.0   10.0 14.0     0.0   *     9.0   0.0   24.0 19 2 0   0 0     0   3   10 14     0     9 0   24
695084 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 2017   pre_kindergarten 18.0 1.0 5.0   0.0 1.0     0.0   1.0   11.0 15.0         *         0.0   26.0 18 1 5   0 1     0   1   11 15             0   26
695228 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 2017   pre_kindergarten 5.0 0.0 11.0   0.0 1.0     0.0   0.0   8.0 9.0     0.0   0.0     13.0   0.0   17.0 5 0 11   0 1     0   0   8 9     0 0   13 0   17
695253 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 Elementary PK KG 2017   pre_kindergarten 30.0 0.0 21.0   0.0 0.0     0.0   1.0   28.0 24.0     0.0   *         0.0   52.0 30 0 21   0 0     0   1   28 24     0       0   52
695274 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 2017   pre_kindergarten 9.0 0.0 0.0   0.0 0.0     0.0   0.0   5.0 4.0         *         *   9.0 9 0 0   0 0     0   0   5 4                 9
695507 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 2017   pre_kindergarten 32.0 2.0 6.0   0.0 0.0     0.0   1.0   20.0 21.0     0.0   0.0     21.0   0.0   41.0 32 2 6   0 0     0   1   20 21     0 0   21 0   41
695547 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 2017   pre_kindergarten 4.0 0.0 0.0   3.0 0.0     0.0   1.0   6.0 2.0         *         *   8.0 4 0 0   3 0     0   1   6 2                 8
695722 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 2017   pre_kindergarten 23.0 0.0 0.0   0.0 0.0     0.0   0.0   9.0 14.0     0.0   0.0     11.0   0.0   23.0 23 0 0   0 0     0   0   9 14     0 0   11 0   23
695732 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 2017   pre_kindergarten 27.0 0.0 1.0   0.0 0.0     0.0   2.0   17.0 13.0     0.0   *     12.0   0.0   30.0 27 0 1   0 0     0   2   17 13     0     12 0   30
695784 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 2017   pre_kindergarten 10.0 0.0 0.0   2.0 0.0     0.0   0.0   4.0 8.0         *         0.0   12.0 10 0 0   2 0     0   0   4 8             0   12
695833 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 2017   pre_kindergarten 14.0 0.0 0.0   0.0 0.0     0.0   0.0   3.0 11.0     0.0   0.0     9.0   0.0   14.0 14 0 0   0 0     0   0   3 11     0 0   9 0   14
695976 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 2017   pre_kindergarten 25.0 0.0 0.0   0.0 0.0     0.0   1.0   16.0 10.0         *         0.0   26.0 25 0 0   0 0     0   1   16 10             0   26
696063 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 2017   pre_kindergarten 24.0 0.0 4.0   0.0 0.0     0.0   5.0   10.0 23.0     0.0   2.0     16.0   0.0   33.0 24 0 4   0 0     0   5   10 23     0 2   16 0   33
696098 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 2017   pre_kindergarten 39.0 0.0 1.0   0.0 0.0     0.0   0.0   18.0 22.0         *     18.0   0.0   40.0 39 0 1   0 0     0   0   18 22           18 0   40
696115 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 2017   pre_kindergarten 10.0 0.0 0.0   0.0 0.0     0.0   0.0   3.0 7.0         *         0.0   10.0 10 0 0   0 0     0   0   3 7             0   10
696133 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 2017   pre_kindergarten 20.0 0.0 5.0   0.0 0.0     0.0   0.0   14.0 11.0     0.0   *         0.0   25.0 20 0 5   0 0     0   0   14 11     0       0   25
696166 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 2017   pre_kindergarten 7.0 0.0 0.0   0.0 4.0     0.0   0.0   6.0 5.0     0.0   0.0     4.0   0.0   11.0 7 0 0   0 4     0   0   6 5     0 0   4 0   11
696242 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 2017   pre_kindergarten 25.0 0.0 0.0   0.0 0.0     0.0   0.0   16.0 9.0         *     14.0   0.0   25.0 25 0 0   0 0     0   0   16 9           14 0   25
696252 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 2017   pre_kindergarten 21.0 3.0 28.0   0.0 0.0     0.0   5.0   21.0 36.0     0.0   *     39.0   0.0   57.0 21 3 28   0 0     0   5   21 36     0     39 0   57
696301 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 2017   pre_kindergarten 2.0 27.0 2.0   0.0 2.0     0.0   3.0   18.0 18.0     4.0   0.0         0.0   36.0 2 27 2   0 2     0   3   18 18     4 0     0   36
696471 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 2017   pre_kindergarten 5.0 6.0 19.0   2.0 2.0     0.0   1.0   13.0 22.0         *         0.0   35.0 5 6 19   2 2     0   1   13 22             0   35
696504 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 08 2017   pre_kindergarten 0.0 2.0 6.0   18.0 0.0     0.0   3.0   18.0 11.0         4.0     24.0   0.0   29.0 0 2 6   18 0     0   3   18 11       4   24 0   29
696534 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 08 2017   pre_kindergarten 2.0 14.0 13.0   0.0 0.0     0.0   2.0   15.0 16.0         0.0         0.0   31.0 2 14 13   0 0     0   2   15 16       0     0   31
696551 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 08 2017   pre_kindergarten 0.0 29.0 4.0   1.0 2.0     0.0   0.0   17.0 19.0     6.0   *     27.0   0.0   36.0 0 29 4   1 2     0   0   17 19     6     27 0   36
696610 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 2017   pre_kindergarten 57.0 5.0 15.0   0.0 1.0     0.0   0.0   37.0 41.0     0.0   *         0.0   78.0 57 5 15   0 1     0   0   37 41     0       0   78
696630 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 2017   pre_kindergarten 1.0 11.0 3.0   0.0 0.0     0.0   0.0   7.0 8.0     0.0   0.0         0.0   15.0 1 11 3   0 0     0   0   7 8     0 0     0   15
696668 MN Ramsey 62 school 2700115 4015 Charter Schools COMMUNITY OF PEACE ACADEMY 270011502605 10 COMMUNITY OF PEACE ACADEMY Elementary School (Grades PK-6) Regular School Yes Elementary PK 08 2017   pre_kindergarten 5.0 3.0 3.0   0.0 18.0     0.0   1.0   16.0 14.0     0.0   0.0     24.0   0.0   30.0 5 3 3   0 18     0   1   16 14     0 0   24 0   30
696713 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 2017   pre_kindergarten 6.0 4.0 11.0   0.0 10.0     0.0   3.0   17.0 17.0     0.0   0.0         0.0   34.0 6 4 11   0 10     0   3   17 17     0 0     0   34
696752 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 2017   pre_kindergarten 1.0 2.0 15.0   0.0 8.0     0.0   1.0   13.0 14.0     0.0   0.0         0.0   27.0 1 2 15   0 8     0   1   13 14     0 0     0   27
696854 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 2017   pre_kindergarten 0.0 0.0 18.0   0.0 0.0     0.0   0.0   12.0 6.0         *     14.0   0.0   18.0 0 0 18   0 0     0   0   12 6           14 0   18
696861 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 2017   pre_kindergarten 0.0 35.0 1.0   0.0 0.0     0.0   2.0   14.0 24.0     0.0   1.0     31.0   0.0   38.0 0 35 1   0 0     0   2   14 24     0 1   31 0   38
696883 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 06 2017   pre_kindergarten 0.0 0.0 33.0   0.0 0.0     0.0   1.0   13.0 21.0     0.0   *         0.0   34.0 0 0 33   0 0     0   1   13 21     0       0   34
696954 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 Elementary PK PK 2017   pre_kindergarten 5.0 8.0 1.0   0.0 0.0     0.0   2.0   11.0 5.0     1.0   0.0     8.0   0.0   16.0 5 8 1   0 0     0   2   11 5     1 0   8 0   16
697169 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 08 2017   pre_kindergarten 15.0 1.0 1.0   0.0 0.0     0.0   1.0   5.0 13.0         0.0         0.0   18.0 15 1 1   0 0     0   1   5 13       0     0   18

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