Data source: Big Local News · About: Big Local

535 rows where grade = "early_childhood_special_ed", state = "MN" and year = 2019 sorted by ccd_school_low_grade

View and edit SQL

year

  • 2019 · 535

grade

  • early_childhood_special_ed · 535
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
1946274 MN Beltrami 4 school 2704440 31 Independent Districts and Schools BEMIDJI PUBLIC SCHOOL DISTRICT 270444000194 16 NORTHERN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 01 03 2019   early_childhood_special_ed 16.0 0.0 0.0   4.0 0.0     0.0   0.0   12.0 8.0     0.0   *     9.0   *   20.0 16 0 0   4 0     0   0   12 8     0     9     20
1946307 MN Beltrami 4 school 2704440 31 Independent Districts and Schools BEMIDJI PUBLIC SCHOOL DISTRICT 270444000193 100 HORACE MAY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 01 03 2019   early_childhood_special_ed 21.0 0.0 0.0   11.0 0.0     0.0   1.0   23.0 10.0     0.0   0.0     19.0   *   33.0 21 0 0   11 0     0   1   23 10     0 0   19     33
1956330 MN Scott 70 school 2723430 721 Independent Districts and Schools NEW PRAGUE AREA SCHOOLS 272343003677 510 CENTRAL EDUCATION CAMPUS Special Education Special Education School No Elementary 02 03 2019   early_childhood_special_ed 72.0 2.0 4.0   2.0 0.0     1.0   0.0   49.0 32.0     0.0   0.0     19.0   *   81.0 72 2 4   2 0     1   0   49 32     0 0   19     81
1951364 MN Martin 46 school 2718960 2448 Independent Districts and Schools MARTIN COUNTY WEST SCHOOL DISTRICT 271896000072 15 TRIMONT ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 03 06 2019   early_childhood_special_ed 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
1951111 MN Saint Louis 69 school 2700021 2154 Independent Districts and Schools EVELETH-GILBERT SCHOOL DISTRICT 270002100629 20 NELLE SHEAN ELEMENTARY Elementary School (Grades PK-6) Regular School No Middle 05 06 2019   early_childhood_special_ed 7.0 0.0 0.0   1.0 0.0     0.0   0.0   5.0 3.0     *   *         *   8.0 7 0 0   1 0     0   0   5 3                 8
1945496 MN Renville 65 school 2705660 2534 Independent Districts and Schools Bird Island-Olivia-Lake Lillian Public School District 270566000147 20 BOLD SENIOR HIGH Secondary School (Grades 7-12) Regular School No High 07 12 2019   early_childhood_special_ed 8.0 0.0 4.0   1.0 0.0     0.0   0.0   9.0 4.0     0.0   0.0     8.0   *   13.0 8 0 4   1 0     0   0   9 4     0 0   8     13
1945910 MN Aitkin 1 school 2702760 1 Independent Districts and Schools AITKIN PUBLIC SCHOOL DISTRICT 270276000059 2 RIPPLESIDE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   early_childhood_special_ed 17.0 0.0 0.0   0.0 0.0     0.0   0.0   12.0 5.0     0.0   0.0     9.0   *   17.0 17 0 0   0 0     0   0   12 5     0 0   9     17
1945919 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   early_childhood_special_ed 11.0 0.0 0.0   0.0 0.0     0.0   0.0   7.0 4.0     *   *     9.0   *   11.0 11 0 0   0 0     0   0   7 4           9     11
1945927 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   early_childhood_special_ed 12.0 0.0 0.0   2.0 0.0     0.0   0.0   13.0 1.0     0.0   0.0     4.0   *   14.0 12 0 0   2 0     0   0   13 1     0 0   4     14
1946143 MN Anoka 2 school 2709510 13 Independent Districts and Schools COLUMBIA HEIGHTS PUBLIC SCHOOL DIST 270951000398 515 HIGHLAND ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   early_childhood_special_ed 0.0 1.0 3.0   0.0 1.0     0.0   1.0   5.0 1.0     *   *         *   6.0 0 1 3   0 1     0   1   5 1                 6
1946152 MN Anoka 2 school 2709510 13 Independent Districts and Schools COLUMBIA HEIGHTS PUBLIC SCHOOL DIST 270951000400 517 NORTH PARK ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   early_childhood_special_ed 4.0 3.0 2.0   0.0 0.0     0.0   0.0   4.0 5.0     *   *         *   9.0 4 3 2   0 0     0   0   4 5                 9
1946161 MN Anoka 2 school 2709510 13 Independent Districts and Schools COLUMBIA HEIGHTS PUBLIC SCHOOL DIST 270951000402 520 VALLEY VIEW ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   early_childhood_special_ed 1.0 1.0 1.0   0.0 0.0     0.0   1.0   2.0 2.0     *   *         *   4.0 1 1 1   0 0     0   1   2 2                 4
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
1946218 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   early_childhood_special_ed 0.0 0.0 1.0   1.0 0.0     0.0   0.0   1.0 1.0     *   *         *   2.0 0 0 1   1 0     0   0   1 1                 2
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
1946252 MN Becker 3 school 2712360 23 Independent Districts and Schools FRAZEE-VERGAS PUBLIC SCHOOL DIST. 271236000607 10 FRAZEE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   early_childhood_special_ed 7.0 0.0 0.0   1.0 0.0     0.0   0.0   4.0 4.0     *   *         *   8.0 7 0 0   1 0     0   0   4 4                 8
1946281 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   early_childhood_special_ed 18.0 0.0 1.0   11.0 0.0     0.0   2.0   18.0 14.0     0.0   *         *   32.0 18 0 1   11 0     0   2   18 14     0           32
1946288 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   early_childhood_special_ed 11.0 0.0 0.0   5.0 0.0     0.0   1.0   14.0 3.0     0.0   0.0         *   17.0 11 0 0   5 0     0   1   14 3     0 0         17
1946295 MN Beltrami 4 school 2704440 31 Independent Districts and Schools BEMIDJI PUBLIC SCHOOL DISTRICT 270444000192 60 Lincoln Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 03 2019   early_childhood_special_ed 17.0 0.0 1.0   8.0 0.0     0.0   1.0   22.0 5.0     0.0   0.0     15.0   *   27.0 17 0 1   8 0     0   1   22 5     0 0   15     27
1946301 MN Beltrami 4 school 2704440 31 Independent Districts and Schools BEMIDJI PUBLIC SCHOOL DISTRICT 270444000197 80 SOLWAY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 03 2019   early_childhood_special_ed 6.0 0.0 1.0   3.0 0.0     0.0   1.0   5.0 6.0     0.0   0.0         *   11.0 6 0 1   3 0     0   1   5 6     0 0         11
1946312 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   early_childhood_special_ed 4.0 0.0 0.0   1.0 0.0     0.0   0.0   4.0 1.0     *   *         *   5.0 4 0 0   1 0     0   0   4 1                 5
1946322 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   early_childhood_special_ed 2.0 0.0 0.0   0.0 0.0     0.0   0.0   1.0 1.0     *   *         *   2.0 2 0 0   0 0     0   0   1 1                 2
1946338 MN Beltrami 4 school 2730510 38 Independent Districts and Schools RED LAKE PUBLIC SCHOOL DISTRICT 273051003303 11 RED LAKE EARLY CHILDHOOD CENTER Elementary School (Grades PK-6) Regular School No Elementary PK KG 2019   early_childhood_special_ed 0.0 0.0 0.0   17.0 0.0     0.0   0.0   9.0 8.0     *   *         *   17.0 0 0 0   17 0     0   0   9 8                 17
1946341 MN Beltrami 4 school 2730510 38 Independent Districts and Schools RED LAKE PUBLIC SCHOOL DISTRICT 273051001301 20 PONEMAH ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 08 2019   early_childhood_special_ed 0.0 0.0 0.0   5.0 0.0     0.0   0.0   2.0 3.0     *   *         *   5.0 0 0 0   5 0     0   0   2 3                 5
1946359 MN Benton 5 school 2732880 47 Independent Districts and Schools SAUK RAPIDS-RICE PUBLIC SCHOOLS 273288001433 6 RICE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   early_childhood_special_ed 16.0 0.0 0.0   0.0 0.0     0.0   0.0   12.0 4.0     0.0   0.0     6.0   *   16.0 16 0 0   0 0     0   0   12 4     0 0   6     16
1946374 MN Benton 5 school 2712240 51 Independent Districts and Schools FOLEY PUBLIC SCHOOL DISTRICT 271224000590 10 FOLEY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 03 2019   early_childhood_special_ed 21.0 0.0 0.0   1.0 0.0     0.0   0.0   12.0 10.0     0.0   0.0     10.0   *   22.0 21 0 0   1 0     0   0   12 10     0 0   10     22
1946386 MN Blue Earth 7 school 2733480 75 Independent Districts and Schools ST. CLAIR PUBLIC SCHOOL DISTRICT 273348001477 10 ST. CLAIR ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   early_childhood_special_ed 9.0 0.0 0.0   0.0 0.0     0.0   0.0   6.0 3.0     *   *         *   9.0 9 0 0   0 0     0   0   6 3                 9
1946395 MN Blue Earth 7 school 2718780 77 Independent Districts and Schools MANKATO PUBLIC SCHOOL DISTRICT 271878000877 10 KENNEDY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   early_childhood_special_ed 8.0 1.0 1.0   0.0 0.0     0.0   0.0   6.0 4.0     0.0   1.0     6.0   *   10.0 8 1 1   0 0     0   0   6 4     0 1   6     10
1946467 MN Brown 8 school 2709540 81 Independent Districts and Schools COMFREY PUBLIC SCHOOL DISTRICT 270954000403 10 COMFREY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   early_childhood_special_ed 2.0 0.0 0.0   0.0 0.0     0.0   0.0   0.0 2.0     *   *         *   2.0 2 0 0   0 0     0   0   0 2                 2
1946476 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   early_childhood_special_ed 8.0 0.0 2.0   0.0 0.0     0.0   0.0   7.0 3.0     0.0   0.0     3.0   *   10.0 8 0 2   0 0     0   0   7 3     0 0   3     10
1946486 MN Brown 8 school 2733390 85 Independent Districts and Schools SPRINGFIELD PUBLIC SCHOOL DISTRICT 273339001470 2 SPRINGFIELD ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   early_childhood_special_ed 4.0 0.0 0.0   0.0 0.0     0.0   0.0   4.0 0.0     *   *         *   4.0 4 0 0   0 0     0   0   4 0                 4
1946500 MN Brown 8 school 2723490 88 Independent Districts and Schools NEW ULM PUBLIC SCHOOL DISTRICT 272349001154 30 WASHINGTON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK KG 2019   early_childhood_special_ed 34.0 0.0 9.0   0.0 0.0     0.0   0.0   29.0 14.0     0.0   0.0     21.0   *   43.0 34 0 9   0 0     0   0   29 14     0 0   21     43
1946503 MN Carlton 9 school 2703690 91 Independent Districts and Schools BARNUM PUBLIC SCHOOL DISTRICT 270369000171 1 BARNUM ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   early_childhood_special_ed 7.0 0.0 0.0   1.0 0.0     0.0   0.0   7.0 1.0     *   *         *   8.0 7 0 0   1 0     0   0   7 1                 8
1946512 MN Carlton 9 school 2707590 93 Independent Districts and Schools CARLTON PUBLIC SCHOOL DISTRICT 270759000328 2 SOUTH TERRACE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   early_childhood_special_ed 7.0 0.0 0.0   1.0 0.0     0.0   0.0   5.0 3.0     *   *         *   8.0 7 0 0   1 0     0   0   5 3                 8
1946532 MN Carlton 9 school 2709690 95 Independent Districts and Schools CROMWELL-WRIGHT PUBLIC SCHOOLS 270969000410 10 CROMWELL-WRIGHT ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   early_childhood_special_ed 2.0 0.0 0.0   1.0 0.0     0.0   0.0   2.0 1.0     *   *         *   3.0 2 0 0   1 0     0   0   2 1                 3
1946541 MN Carlton 9 school 2721450 97 Independent Districts and Schools MOOSE LAKE PUBLIC SCHOOL DISTRICT 272145001093 20 MOOSE LAKE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   early_childhood_special_ed 8.0 0.0 0.0   1.0 0.0     0.0   0.0   2.0 7.0     *   *         *   9.0 8 0 0   1 0     0   0   2 7                 9
1946550 MN Carlton 9 school 2738880 99 Independent Districts and Schools ESKO PUBLIC SCHOOL DISTRICT 273888001683 30 WINTERQUIST ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   early_childhood_special_ed 16.0 0.0 0.0   0.0 0.0     0.0   1.0   10.0 7.0     0.0   0.0     2.0   *   17.0 16 0 0   0 0     0   1   10 7     0 0   2     17
1946559 MN Carlton 9 school 2744190 100 Independent Districts and Schools WRENSHALL PUBLIC SCHOOL DISTRICT 274419001842 1 WRENSHALL ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   early_childhood_special_ed 4.0 0.0 0.0   0.0 0.0     0.0   2.0   5.0 1.0     *   *         *   6.0 4 0 0   0 0     0   2   5 1                 6
1946568 MN Carver 10 school 2723910 108 Independent Districts and Schools CENTRAL PUBLIC SCHOOL DISTRICT 272391001187 40 CENTRAL ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   early_childhood_special_ed 24.0 2.0 2.0   0.0 0.0     0.0   2.0   20.0 10.0     0.0   0.0     10.0   *   30.0 24 2 2   0 0     0   2   20 10     0 0   10     30
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
1946663 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   early_childhood_special_ed 13.0 0.0 0.0   4.0 0.0     0.0   0.0   9.0 8.0     0.0   0.0     9.0   *   17.0 13 0 0   4 0     0   0   9 8     0 0   9     17
1946673 MN Cass 11 school 2708070 115 Independent Districts and Schools CASS LAKE-BENA PUBLIC SCHOOLS 270807000330 10 CASS LAKE-BENA ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2019   early_childhood_special_ed 0.0 0.0 0.0   29.0 0.0     0.0   1.0   22.0 8.0     0.0   0.0         *   30.0 0 0 0   29 0     0   1   22 8     0 0         30
1946680 MN Cass 11 school 2728350 116 Independent Districts and Schools PILLAGER PUBLIC SCHOOL DISTRICT 272835001253 10 PILLAGER ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2019   early_childhood_special_ed 18.0 0.0 0.0   0.0 0.0     0.0   1.0   13.0 6.0     0.0   0.0     13.0   *   19.0 18 0 0   0 0     0   1   13 6     0 0   13     19
1946687 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   early_childhood_special_ed 1.0 0.0 0.0   1.0 0.0     0.0   0.0   1.0 1.0     *   *         *   2.0 1 0 0   1 0     0   0   1 1                 2
1946701 MN Chippewa 12 school 2721320 129 Independent Districts and Schools MONTEVIDEO PUBLIC SCHOOL DISTRICT 272132001074 20 SANFORD EDUCATION CENTER Elementary School (Grades PK-6) Regular School No Elementary PK KG 2019   early_childhood_special_ed 29.0 2.0 9.0   0.0 1.0     0.0   2.0   30.0 13.0     0.0   0.0     28.0   *   43.0 29 2 9   0 1     0   2   30 13     0 0   28     43
1946710 MN Chisago 13 school 2732550 139 Independent Districts and Schools RUSH CITY PUBLIC SCHOOL DISTRICT 273255001405 10 C.E. JACOBSON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   early_childhood_special_ed 8.0 1.0 2.0   0.0 0.0     0.0   1.0   8.0 4.0     0.0   0.0     3.0   *   12.0 8 1 2   0 0     0   1   8 4     0 0   3     12
1946766 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   early_childhood_special_ed 9.0 0.0 0.0   2.0 0.0     0.0   1.0   8.0 4.0     *   *     6.0   *   12.0 9 0 0   2 0     0   1   8 4           6     12
1946776 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   early_childhood_special_ed 6.0 0.0 0.0   4.0 0.0     0.0   3.0   8.0 5.0     0.0   0.0     6.0   *   13.0 6 0 0   4 0     0   3   8 5     0 0   6     13
1946785 MN Cottonwood 17 school 2723010 173 Independent Districts and Schools MOUNTAIN LAKE PUBLIC SCHOOLS 272301001134 10 MOUNTAIN LAKE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   early_childhood_special_ed 6.0 0.0 1.0   0.0 0.0     0.0   0.0   3.0 4.0     *   *         *   7.0 6 0 1   0 0     0   0   3 4                 7
1946835 MN Crow Wing 18 school 2709750 182 Independent Districts and Schools CROSBY-IRONTON PUBLIC SCHOOL DIST. 270975000291 6 CUYUNA RANGE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   early_childhood_special_ed 31.0 0.0 0.0   0.0 0.0     0.0   3.0   19.0 15.0     0.0   0.0     19.0   *   34.0 31 0 0   0 0     0   3   19 15     0 0   19     34
1946844 MN Crow Wing 18 school 2728200 186 Independent Districts and Schools PEQUOT LAKES PUBLIC SCHOOLS 272820001244 10 EAGLE VIEW ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2019   early_childhood_special_ed 24.0 0.0 0.0   0.0 0.0     0.0   0.0   16.0 8.0     0.0   0.0     12.0   *   24.0 24 0 0   0 0     0   0   16 8     0 0   12     24
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
1946854 MN Dakota 19 school 2707290 191 Independent Districts and Schools BURNSVILLE PUBLIC SCHOOL DISTRICT 270729000298 482 GIDEON POND ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   early_childhood_special_ed 4.0 3.0 0.0   0.0 0.0     0.0   0.0   4.0 3.0     *   *         *   7.0 4 3 0   0 0     0   0   4 3                 7
1946863 MN Dakota 19 school 2707290 191 Independent Districts and Schools BURNSVILLE PUBLIC SCHOOL DISTRICT 270729000296 483 EDWARD NEILL ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   early_childhood_special_ed 2.0 1.0 3.0   0.0 0.0     0.0   0.0   4.0 2.0     *   *         *   6.0 2 1 3   0 0     0   0   4 2                 6
1946872 MN Scott 70 school 2707290 191 Independent Districts and Schools BURNSVILLE PUBLIC SCHOOL DISTRICT 270729000300 484 M.W. SAVAGE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   early_childhood_special_ed 0.0 1.0 1.0   0.0 0.0     0.0   1.0   2.0 1.0     *   *         *   3.0 0 1 1   0 0     0   1   2 1                 3
1946881 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   early_childhood_special_ed 0.0 2.0 1.0   0.0 0.0     0.0   1.0   3.0 1.0     *   *         *   4.0 0 2 1   0 0     0   1   3 1                 4
1946890 MN Dakota 19 school 2707290 191 Independent Districts and Schools BURNSVILLE PUBLIC SCHOOL DISTRICT 270729000303 486 VISTA VIEW ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   early_childhood_special_ed 4.0 3.0 1.0   0.0 0.0     0.0   0.0   5.0 3.0     *   *         *   8.0 4 3 1   0 0     0   0   5 3                 8
1946906 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 2019   early_childhood_special_ed 7.0 3.0 3.0   0.0 3.0     0.0   0.0   11.0 5.0     0.0   0.0     6.0   *   16.0 7 3 3   0 3     0   0   11 5     0 0   6     16
1946915 MN Dakota 19 school 2707290 191 Independent Districts and Schools BURNSVILLE PUBLIC SCHOOL DISTRICT 270729000302 489 SKY OAKS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   early_childhood_special_ed 1.0 3.0 2.0   0.0 0.0     0.0   0.0   3.0 3.0     *   *         *   6.0 1 3 2   0 0     0   0   3 3                 6
1946924 MN Scott 70 school 2707290 191 Independent Districts and Schools BURNSVILLE PUBLIC SCHOOL DISTRICT 270729002233 490 HIDDEN VALLEY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   early_childhood_special_ed 4.0 1.0 3.0   0.0 1.0     0.0   1.0   7.0 3.0     0.0   0.0     4.0   *   10.0 4 1 3   0 1     0   1   7 3     0 0   4     10
1946940 MN Dakota 19 school 2711820 192 Independent Districts and Schools FARMINGTON PUBLIC SCHOOL DISTRICT 271182000569 10 FARMINGTON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   early_childhood_special_ed 29.0 4.0 2.0   0.0 2.0     0.0   5.0   30.0 12.0     0.0   0.0     4.0   *   42.0 29 4 2   0 2     0   5   30 12     0 0   4     42
1946948 MN Dakota 19 school 2711820 192 Independent Districts and Schools FARMINGTON PUBLIC SCHOOL DISTRICT 271182002642 40 NORTH TRAIL ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   early_childhood_special_ed 20.0 1.0 4.0   0.0 1.0     0.0   0.0   21.0 5.0     0.0   0.0         *   26.0 20 1 4   0 1     0   0   21 5     0 0         26
1946956 MN Dakota 19 school 2711820 192 Independent Districts and Schools FARMINGTON PUBLIC SCHOOL DISTRICT 271182003183 80 MEADOWVIEW ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   early_childhood_special_ed 18.0 1.0 2.0   0.0 2.0     0.0   1.0   16.0 8.0     0.0   0.0     2.0   *   24.0 18 1 2   0 2     0   1   16 8     0 0   2     24
1946964 MN Dakota 19 school 2711820 192 Independent Districts and Schools FARMINGTON PUBLIC SCHOOL DISTRICT 271182004376 100 RIVERVIEW ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   early_childhood_special_ed 26.0 0.0 1.0   0.0 1.0     0.0   1.0   22.0 7.0     0.0   0.0         *   29.0 26 0 1   0 1     0   1   22 7     0 0         29
1946979 MN Dakota 19 school 2711820 192 Independent Districts and Schools FARMINGTON PUBLIC SCHOOL DISTRICT 271182002205 621 AKIN ROAD ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   early_childhood_special_ed 31.0 0.0 5.0   0.0 1.0     0.0   0.0   22.0 15.0     0.0   0.0     6.0   *   37.0 31 0 5   0 1     0   0   22 15     0 0   6     37
1947043 MN Dakota 19 school 2730150 195 Independent Districts and Schools RANDOLPH PUBLIC SCHOOL DISTRICT 273015001286 10 RANDOLPH ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   early_childhood_special_ed 8.0 0.0 0.0   0.0 0.0     0.0   0.0   5.0 3.0     *   *         *   8.0 8 0 0   0 0     0   0   5 3                 8
1947115 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239001942 714 Echo Park Elementary School of Leadership, Engineering and Technology Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   early_childhood_special_ed 8.0 3.0 5.0   0.0 0.0     0.0   0.0   12.0 4.0     *   0.0         *   16.0 8 3 5   0 0     0   0   12 4       0         16
1947159 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239002302 720 Oak Ridge Elementary School of Leadership, Environmental and Health Sciences Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   early_childhood_special_ed 3.0 1.0 0.0   0.0 0.0     0.0   0.0   4.0 0.0     *   *         *   4.0 3 1 0   0 0     0   0   4 0                 4
1947232 MN Dakota 19 school 2715030 199 Independent Districts and Schools INVER GROVE HEIGHTS SCHOOLS 271503000547 577 PINE BEND ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   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
1947241 MN Dakota 19 school 2715030 199 Independent Districts and Schools INVER GROVE HEIGHTS SCHOOLS 271503000766 578 SALEM HILLS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   early_childhood_special_ed 6.0 1.0 2.0   0.0 0.0     0.0   0.0   6.0 3.0     *   *         *   9.0 6 1 2   0 0     0   0   6 3                 9
1947268 MN Dodge 20 school 2713590 203 Independent Districts and Schools HAYFIELD PUBLIC SCHOOL DISTRICT 271359000701 3 HAYFIELD ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   early_childhood_special_ed 4.0 0.0 0.0   0.0 0.0     0.0   0.0   2.0 2.0     *   *         *   4.0 4 0 0   0 0     0   0   2 2                 4
1947276 MN Dodge 20 school 2716980 204 Independent Districts and Schools KASSON-MANTORVILLE SCHOOL DISTRICT 271698000783 10 KASSON-MANTORVILLE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2019   early_childhood_special_ed 29.0 1.0 4.0   0.0 0.0     0.0   1.0   27.0 8.0     0.0   0.0     12.0   *   35.0 29 1 4   0 0     0   1   27 8     0 0   12     35
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
1947327 MN Douglas 21 school 2725140 213 Independent Districts and Schools OSAKIS PUBLIC SCHOOL DISTRICT 272514001203 10 OSAKIS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 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
1947336 MN Fillmore 23 school 2708220 227 Independent Districts and Schools CHATFIELD PUBLIC SCHOOLS 270822000349 2 CHATFIELD ELEMENTARY SCHOOL Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   early_childhood_special_ed 11.0 0.0 1.0   0.0 0.0     0.0   1.0   9.0 4.0     0.0   0.0     1.0   *   13.0 11 0 1   0 0     0   1   9 4     0 0   1     13
1947345 MN Fillmore 23 school 2717910 229 Independent Districts and Schools LANESBORO PUBLIC SCHOOL DISTRICT 271791000823 10 LANESBORO ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   early_childhood_special_ed 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
1947354 MN Fillmore 23 school 2718540 238 Independent Districts and Schools MABEL-CANTON PUBLIC SCHOOL DIST. 271854000857 1 MABEL-CANTON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   early_childhood_special_ed 1.0 0.0 0.0   0.0 0.0     0.0   0.0   1.0 0.0     *   *         *   1.0 1 0 0   0 0     0   0   1 0                 1
1947363 MN Fillmore 23 school 2728290 239 Independent Districts and Schools RUSHFORD-PETERSON PUBLIC SCHOOLS 272829001407 1 RUSHFORD-PETERSON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   early_childhood_special_ed 6.0 0.0 0.0   0.0 0.0     0.0   0.0   5.0 1.0     *   *         *   6.0 6 0 0   0 0     0   0   5 1                 6
1947371 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   early_childhood_special_ed 5.0 2.0 3.0   0.0 0.0     0.0   0.0   3.0 7.0     *   *         *   10.0 5 2 3   0 0     0   0   3 7                 10
1947380 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   early_childhood_special_ed 3.0 0.0 3.0   0.0 0.0     0.0   0.0   4.0 2.0     *   *         *   6.0 3 0 3   0 0     0   0   4 2                 6
1947403 MN Freeborn 24 school 2703030 242 Independent Districts and Schools ALDEN-CONGER PUBLIC SCHOOL DISTRICT 270303000079 2 ALDEN-CONGER ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   early_childhood_special_ed 3.0 0.0 1.0   0.0 0.0     0.0   1.0   4.0 1.0     *   *         *   5.0 3 0 1   0 0     0   1   4 1                 5
1947412 MN Goodhue 25 school 2707500 252 Independent Districts and Schools CANNON FALLS PUBLIC SCHOOL DISTRICT 270750000323 1 CANNON FALLS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   early_childhood_special_ed 11.0 0.0 1.0   0.0 0.0     0.0   0.0   9.0 3.0     0.0   0.0     2.0   *   12.0 11 0 1   0 0     0   0   9 3     0 0   2     12
1947428 MN Goodhue 25 school 2728950 255 Independent Districts and Schools PINE ISLAND PUBLIC SCHOOL DIST. 272895001257 10 PINE ISLAND ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2019   early_childhood_special_ed 23.0 1.0 0.0   0.0 0.0     0.0   0.0   20.0 4.0     0.0   0.0     2.0   *   24.0 23 1 0   0 0     0   0   20 4     0 0   2     24
1947443 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   early_childhood_special_ed 2.0 0.0 0.0   0.0 0.0     0.0   0.0   1.0 1.0     *   *         *   2.0 2 0 0   0 0     0   0   1 1                 2
1947453 MN Grant 26 school 2713890 264 Independent Districts and Schools HERMAN-NORCROSS SCHOOL DISTRICT 271389000713 1 HERMAN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   early_childhood_special_ed 2.0 0.0 0.0   0.0 0.0     0.0   0.0   1.0 1.0     *   *         *   2.0 2 0 0   0 0     0   0   1 1                 2
1947478 MN Hennepin 27 school 2714260 270 Independent Districts and Schools HOPKINS PUBLIC SCHOOL DISTRICT 271426002206 566 EISENHOWER ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   early_childhood_special_ed 2.0 2.0 1.0   0.0 1.0     0.0   2.0   7.0 1.0     *   *         *   8.0 2 2 1   0 1     0   2   7 1                 8
1947504 MN Hennepin 27 school 2714260 270 Independent Districts and Schools HOPKINS PUBLIC SCHOOL DISTRICT 271426001880 569 GATEWOOD ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2019   early_childhood_special_ed 4.0 4.0 2.0   0.0 0.0     0.0   0.0   9.0 1.0     0.0   0.0         *   10.0 4 4 2   0 0     0   0   9 1     0 0         10
1947537 MN Hennepin 27 school 2705790 271 Independent Districts and Schools BLOOMINGTON PUBLIC SCHOOL DISTRICT 270579000218 446 INDIAN MOUNDS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   early_childhood_special_ed 7.0 0.0 2.0   0.0 0.0     0.0   0.0   5.0 4.0     *   *         *   9.0 7 0 2   0 0     0   0   5 4                 9
1947553 MN Hennepin 27 school 2705790 271 Independent Districts and Schools BLOOMINGTON PUBLIC SCHOOL DISTRICT 270579000223 448 OAK GROVE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   early_childhood_special_ed 2.0 4.0 2.0   0.0 0.0     0.0   0.0   6.0 2.0     *   *         *   8.0 2 4 2   0 0     0   0   6 2                 8
1947583 MN Hennepin 27 school 2705790 271 Independent Districts and Schools BLOOMINGTON PUBLIC SCHOOL DISTRICT 270579000238 459 VALLEY VIEW ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   early_childhood_special_ed 3.0 0.0 2.0   0.0 2.0     0.0   1.0   3.0 5.0     *   *         *   8.0 3 0 2   0 2     0   1   3 5                 8
1947758 MN Hennepin 27 school 2725200 279 Independent Districts and Schools OSSEO PUBLIC SCHOOL DISTRICT 272520002211 668 EDINBROOK ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   early_childhood_special_ed 8.0 2.0 1.0   0.0 3.0     0.0   4.0   12.0 6.0     1.0   0.0     2.0   *   18.0 8 2 1   0 3     0   4   12 6     1 0   2     18
1947781 MN Hennepin 27 school 2725200 279 Independent Districts and Schools OSSEO PUBLIC SCHOOL DISTRICT 272520001207 671 BIRCH GROVE SCHOOL FOR THE ARTS Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   early_childhood_special_ed 3.0 1.0 0.0   0.0 0.0     0.0   0.0   2.0 2.0     *   *         *   4.0 3 1 0   0 0     0   0   2 2                 4
1947790 MN Hennepin 27 school 2725200 279 Independent Districts and Schools OSSEO PUBLIC SCHOOL DISTRICT 272520001210 672 CREST VIEW ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   early_childhood_special_ed 1.0 1.0 2.0   0.0 0.0     0.0   2.0   4.0 2.0     *   *         *   6.0 1 1 2   0 0     0   2   4 2                 6
1947806 MN Hennepin 27 school 2725200 279 Independent Districts and Schools OSSEO PUBLIC SCHOOL DISTRICT 272520001212 674 FAIR OAKS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   early_childhood_special_ed 6.0 2.0 2.0   0.0 0.0     0.0   1.0   7.0 4.0     3.0   0.0     5.0   *   11.0 6 2 2   0 0     0   1   7 4     3 0   5     11
1947815 MN Hennepin 27 school 2725200 279 Independent Districts and Schools OSSEO PUBLIC SCHOOL DISTRICT 272520001213 675 GARDEN CITY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   early_childhood_special_ed 5.0 0.0 2.0   1.0 4.0     0.0   3.0   13.0 2.0     1.0   1.0     9.0   *   15.0 5 0 2   1 4     0   3   13 2     1 1   9     15
1947824 MN Hennepin 27 school 2725200 279 Independent Districts and Schools OSSEO PUBLIC SCHOOL DISTRICT 272520001219 678 PALMER LAKE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   early_childhood_special_ed 2.0 5.0 0.0   0.0 2.0     0.0   2.0   5.0 6.0     1.0   0.0     5.0   *   11.0 2 5 0   0 2     0   2   5 6     1 0   5     11
1947833 MN Hennepin 27 school 2725200 279 Independent Districts and Schools OSSEO PUBLIC SCHOOL DISTRICT 272520001220 679 PARK BROOK ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   early_childhood_special_ed 4.0 1.0 2.0   1.0 0.0     0.0   1.0   8.0 1.0     *   *         *   9.0 4 1 2   1 0     0   1   8 1                 9
1947842 MN Hennepin 27 school 2725200 279 Independent Districts and Schools OSSEO PUBLIC SCHOOL DISTRICT 272520001224 681 ZANEWOOD COMMUNITY SCHOOL Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   early_childhood_special_ed 0.0 5.0 1.0   0.0 1.0     0.0   0.0   2.0 5.0     *   *         *   7.0 0 5 1   0 1     0   0   2 5                 7
1947888 MN Hennepin 27 school 2731750 280 Independent Districts and Schools RICHFIELD PUBLIC SCHOOL DISTRICT 273175001312 36 RICHFIELD STEM SCHOOL Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   early_childhood_special_ed 1.0 0.0 3.0   0.0 0.0     0.0   0.0   4.0 0.0     *   *         *   4.0 1 0 3   0 0     0   0   4 0                 4
1947897 MN Hennepin 27 school 2731750 280 Independent Districts and Schools RICHFIELD PUBLIC SCHOOL DISTRICT 273175001311 695 CENTENNIAL ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2019   early_childhood_special_ed 2.0 0.0 2.0   0.0 0.0     0.0   0.0   4.0 0.0     *   *         *   4.0 2 0 2   0 0     0   0   4 0                 4

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