Data source: Big Local News · About: Big Local

13,903 rows where state = "MN" and year = 2019 sorted by ccd_school_high_grade descending

View and edit SQL

year

  • 2019 · 13,903
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
1946170 MN Anoka 2 school 2712420 14 Independent Districts and Schools FRIDLEY PUBLIC SCHOOL DISTRICT 271242005082 6 Voluntary Prekindergarten School Elementary School (Grades PK-6) Regular School No Prekindergarten PK PK 2019   early_childhood_special_ed 11.0 1.0 0.0   0.0 2.0     0.0   0.0   10.0 4.0     0.0   0.0         *   14.0 11 1 0   0 2     0   0   10 4     0 0         14
1946171 MN Anoka 2 school 2712420 14 Independent Districts and Schools FRIDLEY PUBLIC SCHOOL DISTRICT 271242005082 6 Voluntary Prekindergarten School Elementary School (Grades PK-6) Regular School No Prekindergarten PK PK 2019   pre_kindergarten 66.0 30.0 10.0   0.0 7.0     0.0   13.0   53.0 73.0     0.0   0.0     52.0   0.0   126.0 66 30 10   0 7     0   13   53 73     0 0   52 0   126
1946172 MN Anoka 2 school 2712420 14 Independent Districts and Schools FRIDLEY PUBLIC SCHOOL DISTRICT 271242005082 6 Voluntary Prekindergarten School Elementary School (Grades PK-6) Regular School No Prekindergarten PK PK 2019   pk_12_total 77.0 31.0 10.0   0.0 9.0     0.0   13.0   63.0 77.0     0.0   0.0     58.0   14.0   140.0 77 31 10   0 9     0   13   63 77     0 0   58 14   140
1946244 MN Becker 3 school 2710230 22 Independent Districts and Schools DETROIT LAKES PUBLIC SCHOOL DIST. 271023004362 55 LINCOLN EARLY CHILDHOOD ED. CENTER Elementary School (Grades PK-6) Regular School No Prekindergarten PK PK 2019   early_childhood_special_ed 68.0 2.0 1.0   19.0 1.0     0.0   13.0   67.0 37.0     0.0   4.0     72.0   *   104.0 68 2 1   19 1     0   13   67 37     0 4   72     104
1946245 MN Becker 3 school 2710230 22 Independent Districts and Schools DETROIT LAKES PUBLIC SCHOOL DIST. 271023004362 55 LINCOLN EARLY CHILDHOOD ED. CENTER Elementary School (Grades PK-6) Regular School No Prekindergarten PK PK 2019   pk_12_total 68.0 2.0 1.0   19.0 1.0     0.0   13.0   67.0 37.0     0.0   4.0     72.0   *   104.0 68 2 1   19 1     0   13   67 37     0 4   72     104
1946597 MN Carver 10 school 2741910 111 Independent Districts and Schools WATERTOWN-MAYER PUBLIC SCHOOL DIST. 274191003623 837 WATERTOWN-MAYER PRIMARY SCHOOL Elementary School (Grades PK-6) Regular School No Prekindergarten PK PK 2019   early_childhood_special_ed 42.0 1.0 0.0   0.0 0.0     0.0   1.0   34.0 10.0     0.0   0.0     7.0   *   44.0 42 1 0   0 0     0   1   34 10     0 0   7     44
1946598 MN Carver 10 school 2741910 111 Independent Districts and Schools WATERTOWN-MAYER PUBLIC SCHOOL DIST. 274191003623 837 WATERTOWN-MAYER PRIMARY SCHOOL Elementary School (Grades PK-6) Regular School No Prekindergarten PK PK 2019   pk_12_total 42.0 1.0 0.0   0.0 0.0     0.0   1.0   34.0 10.0     0.0   0.0     7.0   *   44.0 42 1 0   0 0     0   1   34 10     0 0   7     44
1946851 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   early_childhood_special_ed 1.0 0.0 0.0   0.0 1.0     0.0   0.0   2.0 0.0     *   *         *   2.0 1 0 0   0 1     0   0   2 0                 2
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
1946853 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   pk_12_total 26.0 2.0 1.0   0.0 2.0     0.0   5.0   18.0 18.0     0.0   0.0     0.0   *   36.0 26 2 1   0 2     0   5   18 18     0 0   0     36
1947325 MN Douglas 21 school 2703060 206 Independent Districts and Schools ALEXANDRIA PUBLIC SCHOOL DISTRICT 270306003516 170 EARLY EDUCATION CENTER Elementary School (Grades PK-6) Regular School No Prekindergarten PK PK 2019   early_childhood_special_ed 104.0 0.0 3.0   0.0 0.0     0.0   0.0   55.0 52.0     0.0   1.0     45.0   *   107.0 104 0 3   0 0     0   0   55 52     0 1   45     107
1947326 MN Douglas 21 school 2703060 206 Independent Districts and Schools ALEXANDRIA PUBLIC SCHOOL DISTRICT 270306003516 170 EARLY EDUCATION CENTER Elementary School (Grades PK-6) Regular School No Prekindergarten PK PK 2019   pk_12_total 104.0 0.0 3.0   0.0 0.0     0.0   0.0   55.0 52.0     0.0   1.0     45.0   *   107.0 104 0 3   0 0     0   0   55 52     0 1   45     107
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
1947887 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   pk_12_total 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
1948171 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   early_childhood_special_ed 6.0 0.0 1.0   0.0 0.0     0.0   0.0   5.0 2.0     *   *         *   7.0 6 0 1   0 0     0   0   5 2                 7
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
1948173 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   pk_12_total 66.0 0.0 2.0   1.0 0.0     0.0   2.0   33.0 38.0     0.0   0.0     35.0   7.0   71.0 66 0 2   1 0     0   2   33 38     0 0   35 7   71
1948198 MN Itasca 31 school 2709480 316 Independent Districts and Schools GREENWAY PUBLIC SCHOOL DISTRICT 270948000391 120 MARBLE EARLY CHILDHOOD CENTER Elementary School (Grades PK-6) Regular School No Prekindergarten PK PK 2019   early_childhood_special_ed 24.0 0.0 0.0   1.0 0.0     0.0   1.0   17.0 9.0     0.0   0.0     14.0   *   26.0 24 0 0   1 0     0   1   17 9     0 0   14     26
1948199 MN Itasca 31 school 2709480 316 Independent Districts and Schools GREENWAY PUBLIC SCHOOL DISTRICT 270948000391 120 MARBLE EARLY CHILDHOOD CENTER Elementary School (Grades PK-6) Regular School No Prekindergarten PK PK 2019   pk_12_total 24.0 0.0 0.0   1.0 0.0     0.0   1.0   17.0 9.0     0.0   0.0     14.0   *   26.0 24 0 0   1 0     0   1   17 9     0 0   14     26
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
1948411 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   pk_12_total 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
1948438 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   early_childhood_special_ed 17.0 3.0 2.0   0.0 1.0     1.0   3.0   19.0 8.0     0.0   0.0     12.0   *   27.0 17 3 2   0 1     1   3   19 8     0 0   12     27
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
1948440 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   pk_12_total 72.0 4.0 10.0   0.0 5.0     1.0   4.0   53.0 43.0     0.0   0.0     38.0   27.0   96.0 72 4 10   0 5     1   4   53 43     0 0   38 27   96
1948661 MN Mower 50 school 2703450 492 Independent Districts and Schools AUSTIN PUBLIC SCHOOL DISTRICT 270345005043 105 CLC - Pre-Kindergarten Elementary School (Grades PK-6) Regular School No Prekindergarten PK PK 2019   early_childhood_special_ed 7.0 2.0 5.0   0.0 2.0     0.0   3.0   15.0 4.0     *   0.0         *   19.0 7 2 5   0 2     0   3   15 4       0         19
1948662 MN Mower 50 school 2703450 492 Independent Districts and Schools AUSTIN PUBLIC SCHOOL DISTRICT 270345005043 105 CLC - Pre-Kindergarten Elementary School (Grades PK-6) Regular School No Prekindergarten PK PK 2019   pre_kindergarten 34.0 7.0 28.0   0.0 23.0     0.0   5.0   49.0 48.0     *   0.0         0.0   97.0 34 7 28   0 23     0   5   49 48       0     0   97
1948663 MN Mower 50 school 2703450 492 Independent Districts and Schools AUSTIN PUBLIC SCHOOL DISTRICT 270345005043 105 CLC - Pre-Kindergarten Elementary School (Grades PK-6) Regular School No Prekindergarten PK PK 2019   pk_12_total 41.0 9.0 33.0   0.0 25.0     0.0   8.0   64.0 52.0     0.0   0.0     58.0   19.0   116.0 41 9 33   0 25     0   8   64 52     0 0   58 19   116
1948897 MN Olmsted 55 school 2731800 535 Independent Districts and Schools ROCHESTER PUBLIC SCHOOL DISTRICT 273180005129 590 Hawthorne Readiness Plus Elementary School (Grades PK-6) Regular School No Prekindergarten PK PK 2019   early_childhood_special_ed 0.0 0.0 0.0   0.0 0.0     0.0   1.0   1.0 0.0     *   *         *   1.0 0 0 0   0 0     0   1   1 0                 1
1948898 MN Olmsted 55 school 2731800 535 Independent Districts and Schools ROCHESTER PUBLIC SCHOOL DISTRICT 273180005129 590 Hawthorne Readiness Plus Elementary School (Grades PK-6) Regular School No Prekindergarten PK PK 2019   pre_kindergarten 7.0 4.0 3.0   0.0 1.0     0.0   3.0   9.0 9.0     *   *         0.0   18.0 7 4 3   0 1     0   3   9 9             0   18
1948899 MN Olmsted 55 school 2731800 535 Independent Districts and Schools ROCHESTER PUBLIC SCHOOL DISTRICT 273180005129 590 Hawthorne Readiness Plus Elementary School (Grades PK-6) Regular School No Prekindergarten PK PK 2019   pk_12_total 7.0 4.0 3.0   0.0 1.0     0.0   4.0   10.0 9.0     0.0   0.0     10.0   1.0   19.0 7 4 3   0 1     0   4   10 9     0 0   10 1   19
1948900 MN Olmsted 55 school 2731800 535 Independent Districts and Schools ROCHESTER PUBLIC SCHOOL DISTRICT 273180005132 595 Northrop Readiness Plus Elementary School (Grades PK-6) Regular School No Prekindergarten PK PK 2019   pre_kindergarten 3.0 8.0 1.0   0.0 0.0     0.0   1.0   6.0 7.0     0.0   *     11.0   0.0   13.0 3 8 1   0 0     0   1   6 7     0     11 0   13
1948901 MN Olmsted 55 school 2731800 535 Independent Districts and Schools ROCHESTER PUBLIC SCHOOL DISTRICT 273180005132 595 Northrop Readiness Plus Elementary School (Grades PK-6) Regular School No Prekindergarten PK PK 2019   pk_12_total 3.0 8.0 1.0   0.0 0.0     0.0   1.0   6.0 7.0     0.0   *     11.0   0.0   13.0 3 8 1   0 0     0   1   6 7     0     11 0   13
1948999 MN Pine 58 school 2728380 578 Independent Districts and Schools PINE CITY PUBLIC SCHOOL DISTRICT 272838003883 8 EARLY CHILDHOOD Elementary School (Grades PK-6) Regular School No Prekindergarten PK PK 2019   early_childhood_special_ed 10.0 0.0 0.0   0.0 0.0     0.0   0.0   8.0 2.0     0.0   0.0     3.0   *   10.0 10 0 0   0 0     0   0   8 2     0 0   3     10
1949000 MN Pine 58 school 2728380 578 Independent Districts and Schools PINE CITY PUBLIC SCHOOL DISTRICT 272838003883 8 EARLY CHILDHOOD Elementary School (Grades PK-6) Regular School No Prekindergarten PK PK 2019   pk_12_total 10.0 0.0 0.0   0.0 0.0     0.0   0.0   8.0 2.0     0.0   0.0     3.0   *   10.0 10 0 0   0 0     0   0   8 2     0 0   3     10
1949188 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   early_childhood_special_ed 3.0 3.0 1.0   0.0 2.0     0.0   2.0   8.0 3.0     0.0   0.0     4.0   *   11.0 3 3 1   0 2     0   2   8 3     0 0   4     11
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
1949190 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   pk_12_total 14.0 8.0 6.0   0.0 22.0     0.0   7.0   29.0 28.0     12.0   0.0     18.0   11.0   57.0 14 8 6   0 22     0   7   29 28     12 0   18 11   57
1949191 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   early_childhood_special_ed 11.0 4.0 1.0   0.0 1.0     0.0   2.0   15.0 4.0     0.0   0.0     6.0   *   19.0 11 4 1   0 1     0   2   15 4     0 0   6     19
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
1949193 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   pk_12_total 23.0 9.0 3.0   0.0 17.0     0.0   5.0   39.0 18.0     13.0   0.0     14.0   19.0   57.0 23 9 3   0 17     0   5   39 18     13 0   14 19   57
1949204 MN Ramsey 62 school 2732430 623 Independent Districts and Schools ROSEVILLE PUBLIC SCHOOL DISTRICT 273243005099 505 Fairview School Readiness Plus Elementary School (Grades PK-6) Regular School No Prekindergarten PK PK 2019   early_childhood_special_ed 0.0 0.0 0.0   0.0 1.0     0.0   0.0   1.0 0.0     *   *         *   1.0 0 0 0   0 1     0   0   1 0                 1
1949205 MN Ramsey 62 school 2732430 623 Independent Districts and Schools ROSEVILLE PUBLIC SCHOOL DISTRICT 273243005099 505 Fairview School Readiness Plus Elementary School (Grades PK-6) Regular School No Prekindergarten PK PK 2019   pre_kindergarten 5.0 10.0 1.0   0.0 16.0     0.0   2.0   20.0 14.0     *   *         0.0   34.0 5 10 1   0 16     0   2   20 14             0   34
1949206 MN Ramsey 62 school 2732430 623 Independent Districts and Schools ROSEVILLE PUBLIC SCHOOL DISTRICT 273243005099 505 Fairview School Readiness Plus Elementary School (Grades PK-6) Regular School No Prekindergarten PK PK 2019   pk_12_total 5.0 10.0 1.0   0.0 17.0     0.0   2.0   21.0 14.0     10.0   0.0     24.0   1.0   35.0 5 10 1   0 17     0   2   21 14     10 0   24 1   35
1949722 MN Rice 66 school 2711760 656 Independent Districts and Schools FARIBAULT PUBLIC SCHOOL DISTRICT 271176004988 220 McKinley PreK Elementary School (Grades PK-6) Regular School No Prekindergarten PK PK 2019   early_childhood_special_ed 6.0 0.0 3.0   0.0 0.0     0.0   0.0   5.0 4.0     *   *         *   9.0 6 0 3   0 0     0   0   5 4                 9
1949723 MN Rice 66 school 2711760 656 Independent Districts and Schools FARIBAULT PUBLIC SCHOOL DISTRICT 271176004988 220 McKinley PreK Elementary School (Grades PK-6) Regular School No Prekindergarten PK PK 2019   pre_kindergarten 9.0 17.0 13.0   0.0 2.0     0.0   3.0   22.0 22.0     *   *         0.0   44.0 9 17 13   0 2     0   3   22 22             0   44
1949724 MN Rice 66 school 2711760 656 Independent Districts and Schools FARIBAULT PUBLIC SCHOOL DISTRICT 271176004988 220 McKinley PreK Elementary School (Grades PK-6) Regular School No Prekindergarten PK PK 2019   pk_12_total 15.0 17.0 16.0   0.0 2.0     0.0   3.0   27.0 26.0     0.0   0.0     38.0   9.0   53.0 15 17 16   0 2     0   3   27 26     0 0   38 9   53
1949725 MN Rice 66 school 2711760 656 Independent Districts and Schools FARIBAULT PUBLIC SCHOOL DISTRICT 271176005109 230 FEC Pre K Elementary School (Grades PK-6) Regular School No Prekindergarten PK PK 2019   early_childhood_special_ed 0.0 0.0 1.0   0.0 0.0     0.0   0.0   1.0 0.0     *   *         *   1.0 0 0 1   0 0     0   0   1 0                 1
1949726 MN Rice 66 school 2711760 656 Independent Districts and Schools FARIBAULT PUBLIC SCHOOL DISTRICT 271176005109 230 FEC Pre K Elementary School (Grades PK-6) Regular School No Prekindergarten PK PK 2019   pre_kindergarten 8.0 4.0 4.0   0.0 0.0     0.0   1.0   7.0 10.0     *   *         0.0   17.0 8 4 4   0 0     0   1   7 10             0   17
1949727 MN Rice 66 school 2711760 656 Independent Districts and Schools FARIBAULT PUBLIC SCHOOL DISTRICT 271176005109 230 FEC Pre K Elementary School (Grades PK-6) Regular School No Prekindergarten PK PK 2019   pk_12_total 8.0 4.0 5.0   0.0 0.0     0.0   1.0   8.0 10.0     1.0   0.0     13.0   1.0   18.0 8 4 5   0 0     0   1   8 10     1 0   13 1   18
1949735 MN Rice 66 school 2723880 659 Independent Districts and Schools NORTHFIELD PUBLIC SCHOOL DISTRICT 272388001499 4 LONGFELLOW ELEMENTARY Elementary School (Grades PK-6) Regular School No Prekindergarten PK PK 2019   early_childhood_special_ed 52.0 0.0 13.0   0.0 1.0     0.0   2.0   44.0 24.0     0.0   0.0     24.0   *   68.0 52 0 13   0 1     0   2   44 24     0 0   24     68
1949736 MN Rice 66 school 2723880 659 Independent Districts and Schools NORTHFIELD PUBLIC SCHOOL DISTRICT 272388001499 4 LONGFELLOW ELEMENTARY Elementary School (Grades PK-6) Regular School No Prekindergarten PK PK 2019   pk_12_total 52.0 0.0 13.0   0.0 1.0     0.0   2.0   44.0 24.0     0.0   0.0     24.0   *   68.0 52 0 13   0 1     0   2   44 24     0 0   24     68
1950358 MN Steele 74 school 2728050 761 Independent Districts and Schools OWATONNA PUBLIC SCHOOL DISTRICT 272805005202 907 Bright Beginnings Elementary School (Grades PK-6) Regular School No Prekindergarten PK PK 2019   early_childhood_special_ed 10.0 0.0 2.0   0.0 0.0     0.0   0.0   10.0 2.0     0.0   0.0     7.0   *   12.0 10 0 2   0 0     0   0   10 2     0 0   7     12
1950359 MN Steele 74 school 2728050 761 Independent Districts and Schools OWATONNA PUBLIC SCHOOL DISTRICT 272805005202 907 Bright Beginnings Elementary School (Grades PK-6) Regular School No Prekindergarten PK PK 2019   pre_kindergarten 8.0 12.0 3.0   0.0 0.0     0.0   0.0   7.0 16.0     0.0   0.0     17.0   0.0   23.0 8 12 3   0 0     0   0   7 16     0 0   17 0   23
1950360 MN Steele 74 school 2728050 761 Independent Districts and Schools OWATONNA PUBLIC SCHOOL DISTRICT 272805005202 907 Bright Beginnings Elementary School (Grades PK-6) Regular School No Prekindergarten PK PK 2019   pk_12_total 18.0 12.0 5.0   0.0 0.0     0.0   0.0   17.0 18.0     0.0   0.0     24.0   12.0   35.0 18 12 5   0 0     0   0   17 18     0 0   24 12   35
1950361 MN Unknown   school 2728050 761 Independent Districts and Schools OWATONNA PUBLIC SCHOOL DISTRICT 272805005195 908 Owatonna School Readiness Elementary School (Grades PK-6) Regular School No Prekindergarten PK PK 2019   early_childhood_special_ed 32.0 1.0 3.0   0.0 0.0     1.0   1.0   25.0 13.0     0.0   0.0     23.0   *   38.0 32 1 3   0 0     1   1   25 13     0 0   23     38
1950362 MN Unknown   school 2728050 761 Independent Districts and Schools OWATONNA PUBLIC SCHOOL DISTRICT 272805005195 908 Owatonna School Readiness Elementary School (Grades PK-6) Regular School No Prekindergarten PK PK 2019   pre_kindergarten 34.0 14.0 12.0   0.0 4.0     0.0   1.0   32.0 33.0     0.0   0.0     50.0   0.0   65.0 34 14 12   0 4     0   1   32 33     0 0   50 0   65
1950363 MN Unknown   school 2728050 761 Independent Districts and Schools OWATONNA PUBLIC SCHOOL DISTRICT 272805005195 908 Owatonna School Readiness Elementary School (Grades PK-6) Regular School No Prekindergarten PK PK 2019   pk_12_total 66.0 15.0 15.0   0.0 4.0     1.0   2.0   57.0 46.0     0.0   0.0     73.0   38.0   103.0 66 15 15   0 4     1   2   57 46     0 0   73 38   103
1950751 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   early_childhood_special_ed 5.0 0.0 6.0   0.0 0.0     0.0   0.0   7.0 4.0     0.0   0.0     8.0   *   11.0 5 0 6   0 0     0   0   7 4     0 0   8     11
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
1950753 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   pk_12_total 34.0 0.0 26.0   0.0 0.0     0.0   1.0   29.0 32.0     0.0   0.0     25.0   11.0   61.0 34 0 26   0 0     0   1   29 32     0 0   25 11   61
1951715 MN Red Lake 63 school 2700385 2906 Independent Districts and Schools Red Lake County Central Public Schools 270038504733 10 RLCC Elementary at Oklee Elementary School (Grades PK-6) Regular School No Prekindergarten PK PK 2019   early_childhood_special_ed 3.0 0.0 0.0   0.0 0.0     0.0   0.0   2.0 1.0     *   *         *   3.0 3 0 0   0 0     0   0   2 1                 3
1951716 MN Red Lake 63 school 2700385 2906 Independent Districts and Schools Red Lake County Central Public Schools 270038504733 10 RLCC Elementary at Oklee Elementary School (Grades PK-6) Regular School No Prekindergarten PK PK 2019   pk_12_total 3.0 0.0 0.0   0.0 0.0     0.0   0.0   2.0 1.0     *   *         *   3.0 3 0 0   0 0     0   0   2 1                 3
1951998 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124005048 230 Prekindergarten North Elementary School (Grades PK-6) Regular School No Prekindergarten PK PK 2019   early_childhood_special_ed 1.0 4.0 0.0   0.0 0.0     0.0   1.0   5.0 1.0     *   *         *   6.0 1 4 0   0 0     0   1   5 1                 6
1951999 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124005048 230 Prekindergarten North Elementary School (Grades PK-6) Regular School No Prekindergarten PK PK 2019   pk_12_total 1.0 4.0 0.0   0.0 0.0     0.0   1.0   5.0 1.0     *   *         *   6.0 1 4 0   0 0     0   1   5 1                 6
1952426 MN Hennepin 27 school 2700237 4097 Charter Schools PARTNERSHIP ACADEMY, INC. 270023704966 20 Early Wonders Preschool Partnership Academy Elementary School (Grades PK-6) Regular School Yes Prekindergarten PK PK 2019   pre_kindergarten 3.0 4.0 7.0   0.0 1.0     0.0   2.0   9.0 8.0     8.0   0.0     8.0   0.0   17.0 3 4 7   0 1     0   2   9 8     8 0   8 0   17
1952427 MN Hennepin 27 school 2700237 4097 Charter Schools PARTNERSHIP ACADEMY, INC. 270023704966 20 Early Wonders Preschool Partnership Academy Elementary School (Grades PK-6) Regular School Yes Prekindergarten PK PK 2019   pk_12_total 3.0 4.0 7.0   0.0 1.0     0.0   2.0   9.0 8.0     8.0   0.0     8.0   0.0   17.0 3 4 7   0 1     0   2   9 8     8 0   8 0   17
1955964 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318002168 437 EARLY CHILDHOOD/SPECIAL EDUCATION Special Education Special Education School No Prekindergarten PK PK 2019   early_childhood_special_ed 589.0 81.0 77.0   11.0 55.0     2.0   58.0   577.0 296.0     0.0   19.0     162.0   *   873.0 589 81 77   11 55     2   58   577 296     0 19   162     873
1955965 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318002168 437 EARLY CHILDHOOD/SPECIAL EDUCATION Special Education Special Education School No Prekindergarten PK PK 2019   pk_12_total 589.0 81.0 77.0   11.0 55.0     2.0   58.0   577.0 296.0     0.0   19.0     162.0   *   873.0 589 81 77   11 55     2   58   577 296     0 19   162     873
1955986 MN Anoka 2 school 2708100 12 Independent Districts and Schools CENTENNIAL PUBLIC SCHOOL DISTRICT 270810000009 514 Early Childhood Center Special Education Special Education School No Prekindergarten PK PK 2019   early_childhood_special_ed 94.0 3.0 5.0   1.0 7.0     1.0   5.0   74.0 42.0     0.0   0.0     13.0   *   116.0 94 3 5   1 7     1   5   74 42     0 0   13     116
1955987 MN Anoka 2 school 2708100 12 Independent Districts and Schools CENTENNIAL PUBLIC SCHOOL DISTRICT 270810000009 514 Early Childhood Center Special Education Special Education School No Prekindergarten PK PK 2019   pk_12_total 94.0 3.0 5.0   1.0 7.0     1.0   5.0   74.0 42.0     0.0   0.0     13.0   *   116.0 94 3 5   1 7     1   5   74 42     0 0   13     116
1955988 MN Anoka 2 school 2709510 13 Independent Districts and Schools COLUMBIA HEIGHTS PUBLIC SCHOOL DIST 270951000011 813 EARLY CHILDHOOD Special Education Special Education School No Prekindergarten PK PK 2019   early_childhood_special_ed 20.0 15.0 21.0   0.0 2.0     0.0   5.0   36.0 27.0     0.0   0.0     28.0   *   63.0 20 15 21   0 2     0   5   36 27     0 0   28     63
1955989 MN Anoka 2 school 2709510 13 Independent Districts and Schools COLUMBIA HEIGHTS PUBLIC SCHOOL DIST 270951000011 813 EARLY CHILDHOOD Special Education Special Education School No Prekindergarten PK PK 2019   pk_12_total 20.0 15.0 21.0   0.0 2.0     0.0   5.0   36.0 27.0     0.0   0.0     28.0   *   63.0 20 15 21   0 2     0   5   36 27     0 0   28     63
1955992 MN Anoka 2 school 2712420 14 Independent Districts and Schools FRIDLEY PUBLIC SCHOOL DISTRICT 271242005079 549 Early Childhood Special Education School Special Education Special Education School No Prekindergarten PK PK 2019   early_childhood_special_ed 21.0 2.0 7.0   2.0 3.0     0.0   0.0   16.0 19.0     0.0   0.0         *   35.0 21 2 7   2 3     0   0   16 19     0 0         35
1955993 MN Anoka 2 school 2712420 14 Independent Districts and Schools FRIDLEY PUBLIC SCHOOL DISTRICT 271242005079 549 Early Childhood Special Education School Special Education Special Education School No Prekindergarten PK PK 2019   pk_12_total 21.0 2.0 7.0   2.0 3.0     0.0   0.0   16.0 19.0     0.0   0.0         *   35.0 21 2 7   2 3     0   0   16 19     0 0         35
1955998 MN Anoka 2 school 2733540 15 Independent Districts and Schools St. Francis Area Schools 273354000229 780 ECSE@ ISD 15 LIFELONG LEARNING Special Education Special Education School No Prekindergarten PK PK 2019   early_childhood_special_ed 116.0 0.0 4.0   1.0 1.0     0.0   7.0   82.0 47.0     0.0   2.0     39.0   *   129.0 116 0 4   1 1     0   7   82 47     0 2   39     129
1955999 MN Anoka 2 school 2733540 15 Independent Districts and Schools St. Francis Area Schools 273354000229 780 ECSE@ ISD 15 LIFELONG LEARNING Special Education Special Education School No Prekindergarten PK PK 2019   pk_12_total 116.0 0.0 4.0   1.0 1.0     0.0   7.0   82.0 47.0     0.0   2.0     39.0   *   129.0 116 0 4   1 1     0   7   82 47     0 2   39     129
1956000 MN Anoka 2 school 2733330 16 Independent Districts and Schools SPRING LAKE PARK PUBLIC SCHOOLS 273333000290 46 EARLY EDUCATION Special Education Special Education School No Prekindergarten PK PK 2019   early_childhood_special_ed 55.0 16.0 15.0   2.0 6.0     0.0   2.0   56.0 40.0     *   *         *   96.0 55 16 15   2 6     0   2   56 40                 96
1956001 MN Anoka 2 school 2733330 16 Independent Districts and Schools SPRING LAKE PARK PUBLIC SCHOOLS 273333000290 46 EARLY EDUCATION Special Education Special Education School No Prekindergarten PK PK 2019   pk_12_total 55.0 16.0 15.0   2.0 6.0     0.0   2.0   56.0 40.0     *   *         *   96.0 55 16 15   2 6     0   2   56 40                 96
1956008 MN Beltrami 4 school 2730510 38 Independent Districts and Schools RED LAKE PUBLIC SCHOOL DISTRICT 273051004840 110 Red Lake Early Childhood Special Education Extended Year Special Education Special Education School No Prekindergarten PK PK 2019   early_childhood_special_ed 0.0 0.0 0.0   14.0 0.0     0.0   0.0   8.0 6.0     0.0   0.0         *   14.0 0 0 0   14 0     0   0   8 6     0 0         14
1956009 MN Beltrami 4 school 2730510 38 Independent Districts and Schools RED LAKE PUBLIC SCHOOL DISTRICT 273051004840 110 Red Lake Early Childhood Special Education Extended Year Special Education Special Education School No Prekindergarten PK PK 2019   pk_12_total 0.0 0.0 0.0   14.0 0.0     0.0   0.0   8.0 6.0     0.0   0.0         *   14.0 0 0 0   14 0     0   0   8 6     0 0         14
1956010 MN Unknown   school 2732880 47 Independent Districts and Schools SAUK RAPIDS-RICE PUBLIC SCHOOLS 273288005206 140 Hillside Early Childhood Center Special Education Special Education School No Prekindergarten PK PK 2019   early_childhood_special_ed 43.0 2.0 1.0   0.0 0.0     0.0   3.0   33.0 16.0     0.0   0.0     16.0   *   49.0 43 2 1   0 0     0   3   33 16     0 0   16     49
1956011 MN Unknown   school 2732880 47 Independent Districts and Schools SAUK RAPIDS-RICE PUBLIC SCHOOLS 273288005206 140 Hillside Early Childhood Center Special Education Special Education School No Prekindergarten PK PK 2019   pk_12_total 43.0 2.0 1.0   0.0 0.0     0.0   3.0   33.0 16.0     0.0   0.0     16.0   *   49.0 43 2 1   0 0     0   3   33 16     0 0   16     49
1956026 MN Carlton 9 school 2709420 94 Independent Districts and Schools CLOQUET PUBLIC SCHOOL DISTRICT 270942003063 106 CLOQUET EARLY CHILDHOOD EDUCATION Special Education Special Education School No Prekindergarten PK PK 2019   early_childhood_special_ed 51.0 0.0 1.0   19.0 0.0     0.0   9.0   58.0 22.0     0.0   *         *   80.0 51 0 1   19 0     0   9   58 22     0           80
1956027 MN Carlton 9 school 2709420 94 Independent Districts and Schools CLOQUET PUBLIC SCHOOL DISTRICT 270942003063 106 CLOQUET EARLY CHILDHOOD EDUCATION Special Education Special Education School No Prekindergarten PK PK 2019   pk_12_total 51.0 0.0 1.0   19.0 0.0     0.0   9.0   58.0 22.0     0.0   *         *   80.0 51 0 1   19 0     0   9   58 22     0           80
1956028 MN Carver 10 school 2741460 110 Independent Districts and Schools WACONIA PUBLIC SCHOOL DISTRICT 274146003709 115 EARLY CHILDHOOD SPECIAL EDUCATION Special Education Special Education School No Prekindergarten PK PK 2019   early_childhood_special_ed 56.0 3.0 4.0   0.0 0.0     0.0   3.0   47.0 19.0     0.0   0.0     11.0   *   66.0 56 3 4   0 0     0   3   47 19     0 0   11     66
1956029 MN Carver 10 school 2741460 110 Independent Districts and Schools WACONIA PUBLIC SCHOOL DISTRICT 274146003709 115 EARLY CHILDHOOD SPECIAL EDUCATION Special Education Special Education School No Prekindergarten PK PK 2019   pk_12_total 56.0 3.0 4.0   0.0 0.0     0.0   3.0   47.0 19.0     0.0   0.0     11.0   *   66.0 56 3 4   0 0     0   3   47 19     0 0   11     66
1956034 MN Carver 10 school 2708190 112 Independent Districts and Schools EASTERN CARVER COUNTY PUBLIC SCHOOL 270819000397 508 EARLY CHILDHOOD SPECIAL EDUCATION Special Education Special Education School No Prekindergarten PK PK 2019   early_childhood_special_ed 124.0 6.0 10.0   1.0 7.0     0.0   2.0   102.0 48.0     0.0   0.0     12.0   *   150.0 124 6 10   1 7     0   2   102 48     0 0   12     150
1956035 MN Carver 10 school 2708190 112 Independent Districts and Schools EASTERN CARVER COUNTY PUBLIC SCHOOL 270819000397 508 EARLY CHILDHOOD SPECIAL EDUCATION Special Education Special Education School No Prekindergarten PK PK 2019   pk_12_total 124.0 6.0 10.0   1.0 7.0     0.0   2.0   102.0 48.0     0.0   0.0     12.0   *   150.0 124 6 10   1 7     0   2   102 48     0 0   12     150
1956036 MN Chisago 13 school 2723820 138 Independent Districts and Schools NORTH BRANCH PUBLIC SCHOOLS 272382001163 10 North Branch Early Childhood Special Education Special Education School No Prekindergarten PK PK 2019   early_childhood_special_ed 36.0 0.0 4.0   0.0 3.0     0.0   1.0   30.0 14.0     0.0   0.0     12.0   *   44.0 36 0 4   0 3     0   1   30 14     0 0   12     44
1956037 MN Chisago 13 school 2723820 138 Independent Districts and Schools NORTH BRANCH PUBLIC SCHOOLS 272382001163 10 North Branch Early Childhood Special Education Special Education School No Prekindergarten PK PK 2019   pk_12_total 36.0 0.0 4.0   0.0 3.0     0.0   1.0   30.0 14.0     0.0   0.0     12.0   *   44.0 36 0 4   0 3     0   1   30 14     0 0   12     44
1956038 MN Clay 14 school 2721420 152 Independent Districts and Schools MOORHEAD PUBLIC SCHOOL DISTRICT 272142003508 6 PROBSTFIELD CENTER FOR EDUCATION Special Education Special Education School No Prekindergarten PK PK 2019   early_childhood_special_ed 155.0 18.0 18.0   6.0 2.0     0.0   13.0   146.0 66.0     0.0   0.0     97.0   *   212.0 155 18 18   6 2     0   13   146 66     0 0   97     212
1956039 MN Clay 14 school 2721420 152 Independent Districts and Schools MOORHEAD PUBLIC SCHOOL DISTRICT 272142003508 6 PROBSTFIELD CENTER FOR EDUCATION Special Education Special Education School No Prekindergarten PK PK 2019   pk_12_total 155.0 18.0 18.0   6.0 2.0     0.0   13.0   146.0 66.0     0.0   0.0     97.0   *   212.0 155 18 18   6 2     0   13   146 66     0 0   97     212
1956040 MN Cottonwood 17 school 2742780 177 Independent Districts and Schools WINDOM PUBLIC SCHOOL DISTRICT 274278004510 10 EARLY CHILDHOOD LEARNING CENTER Special Education Special Education School No Prekindergarten PK PK 2019   early_childhood_special_ed 15.0 0.0 4.0   0.0 0.0     0.0   0.0   9.0 10.0     0.0   0.0     10.0   *   19.0 15 0 4   0 0     0   0   9 10     0 0   10     19
1956041 MN Cottonwood 17 school 2742780 177 Independent Districts and Schools WINDOM PUBLIC SCHOOL DISTRICT 274278004510 10 EARLY CHILDHOOD LEARNING CENTER Special Education Special Education School No Prekindergarten PK PK 2019   pk_12_total 15.0 0.0 4.0   0.0 0.0     0.0   0.0   9.0 10.0     0.0   0.0     10.0   *   19.0 15 0 4   0 0     0   0   9 10     0 0   10     19
1956042 MN Crow Wing 18 school 2706090 181 Independent Districts and Schools BRAINERD PUBLIC SCHOOL DISTRICT 270609002430 3 BRAINERD EARLY CHILDHOOD SP. ED. Special Education Special Education School No Prekindergarten PK PK 2019   early_childhood_special_ed 221.0 3.0 2.0   6.0 0.0     0.0   3.0   161.0 74.0     0.0   0.0     147.0   *   235.0 221 3 2   6 0     0   3   161 74     0 0   147     235
1956043 MN Crow Wing 18 school 2706090 181 Independent Districts and Schools BRAINERD PUBLIC SCHOOL DISTRICT 270609002430 3 BRAINERD EARLY CHILDHOOD SP. ED. Special Education Special Education School No Prekindergarten PK PK 2019   pk_12_total 221.0 3.0 2.0   6.0 0.0     0.0   3.0   161.0 74.0     0.0   0.0     147.0   *   235.0 221 3 2   6 0     0   3   161 74     0 0   147     235
1956046 MN Dakota 19 school 2707290 191 Independent Districts and Schools BURNSVILLE PUBLIC SCHOOL DISTRICT 270729002171 481 EARLY EDUCATION PROGRAM & SERVICES Special Education Special Education School No Prekindergarten PK PK 2019   early_childhood_special_ed 72.0 49.0 36.0   0.0 11.0     0.0   12.0   116.0 64.0     0.0   0.0     63.0   *   180.0 72 49 36   0 11     0   12   116 64     0 0   63     180
1956047 MN Dakota 19 school 2707290 191 Independent Districts and Schools BURNSVILLE PUBLIC SCHOOL DISTRICT 270729002171 481 EARLY EDUCATION PROGRAM & SERVICES Special Education Special Education School No Prekindergarten PK PK 2019   pk_12_total 72.0 49.0 36.0   0.0 11.0     0.0   12.0   116.0 64.0     0.0   0.0     63.0   *   180.0 72 49 36   0 11     0   12   116 64     0 0   63     180
1956048 MN Dakota 19 school 2717780 194 Independent Districts and Schools LAKEVILLE PUBLIC SCHOOL DISTRICT 271778004179 500 LAKEVILLE EARLY CHILDHOOD PROGRAM Special Education Special Education School No Prekindergarten PK PK 2019   early_childhood_special_ed 157.0 11.0 14.0   0.0 8.0     0.0   9.0   140.0 59.0     0.0   0.0     36.0   *   199.0 157 11 14   0 8     0   9   140 59     0 0   36     199
1956049 MN Dakota 19 school 2717780 194 Independent Districts and Schools LAKEVILLE PUBLIC SCHOOL DISTRICT 271778004179 500 LAKEVILLE EARLY CHILDHOOD PROGRAM Special Education Special Education School No Prekindergarten PK PK 2019   pk_12_total 157.0 11.0 14.0   0.0 8.0     0.0   9.0   140.0 59.0     0.0   0.0     36.0   *   199.0 157 11 14   0 8     0   9   140 59     0 0   36     199

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