Data source: Big Local News · About: Big Local

13,757 rows where state = "MN" and year = 2017 sorted by total descending

View and edit SQL

year

  • 2017 · 13,757
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
697979 MN Hennepin 27 school 2725200 279 Independent Districts and Schools OSSEO PUBLIC SCHOOL DISTRICT 272520001217 34 Osseo Middle School Middle School (Grades 5-8) Regular School No Middle 06 08 2017   pk_12_total 584.0 180.0 68.0   4.0 85.0     0.0   75.0   507.0 489.0     32.0   6.0     354.0   111.0   996.0 584 180 68   4 85     0   75   507 489     32 6   354 111   996
699530 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124001026 360 ROOSEVELT SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 09 12 2017   pk_12_total 214.0 357.0 329.0   53.0 34.0     0.0   4.0   540.0 451.0     285.0   49.0     673.0   207.0   991.0 214 357 329   53 34     0   4   540 451     285 49   673 207   991
689051 MN Beltrami 4 school 2717010 36 Independent Districts and Schools KELLIHER PUBLIC SCHOOL DISTRICT 271701000787 20 KELLIHER SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   pk_12_total 53.0 0.0 0.0   46.0 0.0     0.0   0.0   44.0 55.0     0.0   0.0     73.0   17.0   99.0 53 0 0   46 0     0   0   44 55     0 0   73 17   99
689110 MN Carlton 9 school 2738880 99 Independent Districts and Schools ESKO PUBLIC SCHOOL DISTRICT 273888001681 1 LINCOLN SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   grade_8 94.0 0.0 0.0   1.0 0.0     0.0   4.0   48.0 51.0     0.0   1.0     14.0   14.0   99.0 94 0 0   1 0     0   4   48 51     0 1   14 14   99
689503 MN Morrison 49 school 2728320 484 Independent Districts and Schools PIERZ PUBLIC SCHOOL DISTRICT 272832001252 30 HEALY SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   grade_10 98.0 0.0 0.0   0.0 1.0     0.0   0.0   57.0 42.0     1.0   0.0     30.0   14.0   99.0 98 0 0   0 1     0   0   57 42     1 0   30 14   99
689775 MN Stearns 73 school 2714190 738 Independent Districts and Schools HOLDINGFORD PUBLIC SCHOOL DISTRICT 271419000733 2 HOLDINGFORD SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   grade_11 95.0 0.0 0.0   0.0 0.0     0.0   4.0   54.0 45.0     0.0   0.0     19.0   17.0   99.0 95 0 0   0 0     0   4   54 45     0 0   19 17   99
689868 MN Wabasha 79 school 2717520 813 Independent Districts and Schools LAKE CITY PUBLIC SCHOOL DISTRICT 271752000804 40 LINCOLN SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   grade_7 95.0 0.0 3.0   0.0 1.0     0.0   0.0   45.0 54.0     0.0   0.0     19.0   17.0   99.0 95 0 3   0 1     0   0   45 54     0 0   19 17   99
690677 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000126 418 UNIVERSITY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_4 67.0 19.0 6.0   1.0 2.0     0.0   4.0   45.0 54.0     9.0   1.0     60.0   17.0   99.0 67 19 6   1 2     0   4   45 54     9 1   60 17   99
690765 MN Anoka 2 school 2708100 12 Independent Districts and Schools CENTENNIAL PUBLIC SCHOOL DISTRICT 270810000022 513 RICE LAKE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   kindergarten 92.0 0.0 1.0   0.0 1.0     0.0   5.0   42.0 57.0     1.0   0.0     8.0   16.0   99.0 92 0 1   0 1     0   5   42 57     1 0   8 16   99
690853 MN Anoka 2 school 2733330 16 Independent Districts and Schools SPRING LAKE PARK PUBLIC SCHOOLS 273333001467 774 Woodcrest Elementary Spanish Immersion Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_3 59.0 2.0 24.0   1.0 3.0     0.0   10.0   38.0 61.0         0.0         *   99.0 59 2 24   1 3     0   10   38 61       0         99
691166 MN Carlton 9 school 2709420 94 Independent Districts and Schools CLOQUET PUBLIC SCHOOL DISTRICT 270942000384 105 WASHINGTON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_2 69.0 0.0 1.0   12.0 0.0     1.0   16.0   45.0 54.0         1.0     50.0   *   99.0 69 0 1   12 0     1   16   45 54       1   50     99
691194 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 2017   grade_4 92.0 0.0 3.0   0.0 1.0     0.0   3.0   50.0 49.0     0.0   0.0     10.0   9.0   99.0 92 0 3   0 1     0   3   50 49     0 0   10 9   99
691229 MN Carver 10 school 2741460 110 Independent Districts and Schools WACONIA PUBLIC SCHOOL DISTRICT 274146004916 130 Laketown Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   kindergarten 91.0 0.0 3.0   0.0 0.0     0.0   5.0   53.0 46.0     1.0   0.0     6.0   13.0   99.0 91 0 3   0 0     0   5   53 46     1 0   6 13   99
691440 MN Crow Wing 18 school 2706090 181 Independent Districts and Schools BRAINERD PUBLIC SCHOOL DISTRICT 270609000248 4 BAXTER ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2017   grade_4 89.0 1.0 3.0   0.0 1.0     0.0   5.0   43.0 56.0     0.0   0.0     35.0   21.0   99.0 89 1 3   0 1     0   5   43 56     0 0   35 21   99
691608 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 2017   grade_1 76.0 1.0 7.0   0.0 9.0     0.0   6.0   49.0 50.0     9.0   1.0     19.0   12.0   99.0 76 1 7   0 9     0   6   49 50     9 1   19 12   99
691656 MN Dakota 19 school 2717780 194 Independent Districts and Schools LAKEVILLE PUBLIC SCHOOL DISTRICT 271778002643 598 EASTVIEW ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   kindergarten 81.0 0.0 2.0   0.0 6.0     1.0   9.0   41.0 58.0     2.0   *         *   99.0 81 0 2   0 6     1   9   41 58     2           99
691761 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239000511 716 DEERWOOD ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_3 56.0 13.0 10.0   0.0 8.0     0.0   12.0   48.0 51.0     6.0   0.0     25.0   11.0   99.0 56 13 10   0 8     0   12   48 51     6 0   25 11   99
692225 MN Hennepin 27 school 2714220 272 Independent Districts and Schools EDEN PRAIRIE PUBLIC SCHOOL DISTRICT 271422000736 882 FOREST HILLS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 06 2017   grade_3 48.0 18.0 7.0   0.0 19.0     0.0   7.0   57.0 42.0     23.0   0.0     27.0   19.0   99.0 48 18 7   0 19     0   7   57 42     23 0   27 19   99
692467 MN Hennepin 27 school 2725200 279 Independent Districts and Schools OSSEO PUBLIC SCHOOL DISTRICT 272520001939 684 ELM CREEK ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_3 59.0 10.0 12.0   0.0 1.0     0.0   17.0   54.0 45.0     8.0   2.0     38.0   10.0   99.0 59 10 12   0 1     0   17   54 45     8 2   38 10   99
692580 MN Hennepin 27 school 2731780 281 Independent Districts and Schools ROBBINSDALE PUBLIC SCHOOL DISTRICT 273178001330 19 NORTHPORT ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_5 10.0 44.0 26.0   0.0 14.0     0.0   5.0   56.0 43.0     20.0   4.0     82.0   9.0   99.0 10 44 26   0 14     0   5   56 43     20 4   82 9   99
692587 MN Hennepin 27 school 2731780 281 Independent Districts and Schools ROBBINSDALE PUBLIC SCHOOL DISTRICT 273178001337 22 SONNESYN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_5 25.0 35.0 20.0   2.0 4.0     0.0   13.0   48.0 51.0     12.0   *     64.0   19.0   99.0 25 35 20   2 4     0   13   48 51     12     64 19   99
692593 MN Hennepin 27 school 2731780 281 Independent Districts and Schools ROBBINSDALE PUBLIC SCHOOL DISTRICT 273178001339 30 ZACHARY LANE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_4 66.0 12.0 8.0   0.0 6.0     0.0   7.0   51.0 48.0         1.0     23.0   8.0   99.0 66 12 8   0 6     0   7   51 48       1   23 8   99
692672 MN Hennepin 27 school 2742160 284 Independent Districts and Schools WAYZATA PUBLIC SCHOOL DISTRICT 274216001763 808 SUNSET HILL ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_5 66.0 15.0 8.0   1.0 5.0     0.0   4.0   47.0 52.0     0.0   2.0     27.0   14.0   99.0 66 15 8   1 5     0   4   47 52     0 2   27 14   99
693167 MN Morrison 49 school 2718240 482 Independent Districts and Schools LITTLE FALLS PUBLIC SCHOOL DISTRICT 271824000961 120 LINDBERGH ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_3 87.0 4.0 3.0   0.0 0.0     0.0   5.0   49.0 50.0     1.0   0.0     42.0   15.0   99.0 87 4 3   0 0     0   5   49 50     1 0   42 15   99
693385 MN Olmsted 55 school 2731800 535 Independent Districts and Schools ROCHESTER PUBLIC SCHOOL DISTRICT 273180000993 124 FRANKLIN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_2 42.0 18.0 28.0   1.0 4.0     0.0   6.0   59.0 40.0     31.0   0.0     58.0   19.0   99.0 42 18 28   1 4     0   6   59 40     31 0   58 19   99
693387 MN Olmsted 55 school 2731800 535 Independent Districts and Schools ROCHESTER PUBLIC SCHOOL DISTRICT 273180000993 124 FRANKLIN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_4 44.0 20.0 27.0   0.0 5.0     1.0   2.0   50.0 49.0     25.0   2.0     60.0   11.0   99.0 44 20 27   0 5     1   2   50 49     25 2   60 11   99
693524 MN Otter Tail 56 school 2728230 549 Independent Districts and Schools PERHAM-DENT PUBLIC SCHOOL DISTRICT 272823001247 10 HEART OF THE LAKE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2017   grade_4 80.0 3.0 11.0   1.0 0.0     0.0   4.0   48.0 51.0     9.0   0.0     46.0   19.0   99.0 80 3 11   1 0     0   4   48 51     9 0   46 19   99
693661 MN Ramsey 62 school 2722950 621 Independent Districts and Schools MOUNDS VIEW PUBLIC SCHOOL DISTRICT 272295001124 30 PINEWOOD ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 01 05 2017   grade_4 47.0 16.0 11.0   2.0 15.0     1.0   7.0   55.0 44.0     11.0   2.0     59.0   13.0   99.0 47 16 11   2 15     1   7   55 44     11 2   59 13   99
693715 MN Washington 82 school 2723850 622 Independent Districts and Schools North St Paul-Maplewood Oakdale Public School District 272385001175 33 OAKDALE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_5 46.0 18.0 11.0   0.0 14.0     0.0   10.0   56.0 43.0     7.0   4.0     66.0   23.0   99.0 46 18 11   0 14     0   10   56 43     7 4   66 23   99
693741 MN Washington 82 school 2723850 622 Independent Districts and Schools North St Paul-Maplewood Oakdale Public School District 272385002665 37 SKYVIEW COMMUNITY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_1 36.0 16.0 7.0   0.0 31.0     0.0   9.0   51.0 48.0     4.0   3.0     47.0   11.0   99.0 36 16 7   0 31     0   9   51 48     4 3   47 11   99
693970 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384001581 464 FROST LAKE ELEMENTARY SCHOOL Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_2 6.0 21.0 16.0   1.0 49.0     0.0   6.0   56.0 43.0     61.0   4.0     85.0   14.0   99.0 6 21 16   1 49     0   6   56 43     61 4   85 14   99
694489 MN Scott 70 school 2730060 719 Independent Districts and Schools PRIOR LAKE-SAVAGE AREA SCHOOLS 273006002679 14 GLENDALE EL. Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_1 81.0 3.0 6.0   0.0 5.0     0.0   4.0   50.0 49.0     6.0   0.0     10.0   8.0   99.0 81 3 6   0 5     0   4   50 49     6 0   10 8   99
694490 MN Scott 70 school 2730060 719 Independent Districts and Schools PRIOR LAKE-SAVAGE AREA SCHOOLS 273006002679 14 GLENDALE EL. Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_2 77.0 2.0 7.0   0.0 8.0     0.0   5.0   46.0 53.0     7.0   0.0     14.0   11.0   99.0 77 2 7   0 8     0   5   46 53     7 0   14 11   99
694553 MN Scott 70 school 2723430 721 Independent Districts and Schools NEW PRAGUE AREA SCHOOLS 272343003641 521 EAGLE VIEW Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   kindergarten 92.0 1.0 1.0   1.0 1.0     0.0   3.0   46.0 53.0     0.0   0.0     12.0   12.0   99.0 92 1 1   1 1     0   3   46 53     0 0   12 12   99
694652 MN Stearns 73 school 2714190 738 Independent Districts and Schools HOLDINGFORD PUBLIC SCHOOL DISTRICT 271419000732 1 HOLDINGFORD ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_3 98.0 1.0 0.0   0.0 0.0     0.0   0.0   52.0 47.0     1.0   0.0     25.0   11.0   99.0 98 1 0   0 0     0   0   52 47     1 0   25 11   99
694821 MN Steele 74 school 2728050 761 Independent Districts and Schools OWATONNA PUBLIC SCHOOL DISTRICT 272805001226 902 MCKINLEY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   kindergarten 65.0 14.0 15.0   0.0 1.0     0.0   4.0   51.0 48.0     19.0   5.0     50.0   20.0   99.0 65 14 15   0 1     0   4   51 48     19 5   50 20   99
695020 MN Washington 82 school 2712270 831 Independent Districts and Schools FOREST LAKE PUBLIC SCHOOL DISTRICT 271227000601 631 Wyoming Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_3 96.0 1.0 1.0   0.0 0.0     0.0   1.0   49.0 50.0     0.0   0.0     20.0   10.0   99.0 96 1 1   0 0     0   1   49 50     0 0   20 10   99
695123 MN Washington 82 school 2733810 833 Independent Districts and Schools SOUTH WASHINGTON COUNTY SCHOOL DIST 273381001546 44 ROYAL OAKS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_3 69.0 9.0 7.0   1.0 4.0     0.0   9.0   55.0 44.0     8.0   0.0     21.0   16.0   99.0 69 9 7   1 4     0   9   55 44     8 0   21 16   99
695643 MN Clay 14 school 2710260 2164 Independent Districts and Schools DILWORTH-GLYNDON-FELTON 271026000447 1 DILWORTH ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2017   kindergarten 85.0 1.0 5.0   2.0 0.0     0.0   6.0   48.0 51.0     3.0   0.0     32.0   12.0   99.0 85 1 5   2 0     0   6   48 51     3 0   32 12   99
695645 MN Clay 14 school 2710260 2164 Independent Districts and Schools DILWORTH-GLYNDON-FELTON 271026000447 1 DILWORTH ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2017   grade_2 88.0 3.0 3.0   1.0 0.0     0.0   4.0   55.0 44.0     6.0   0.0     30.0   13.0   99.0 88 3 3   1 0     0   4   55 44     6 0   30 13   99
695762 MN Rock 67 school 2718330 2184 Independent Districts and Schools LUVERNE PUBLIC SCHOOL DISTRICT 271833000851 2 LUVERNE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_3 84.0 1.0 5.0   1.0 2.0     0.0   6.0   48.0 51.0     5.0   0.0     38.0   18.0   99.0 84 1 5   1 2     0   6   48 51     5 0   38 18   99
695960 MN Pipestone 59 school 2700108 2689 Independent Districts and Schools PIPESTONE AREA SCHOOL DISTRICT 270010801261 2 BROWN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 01 2017   kindergarten 64.0 3.0 22.0   0.0 2.0     0.0   8.0   51.0 48.0         *         *   99.0 64 3 22   0 2     0   8   51 48                 99
696181 MN Wabasha 79 school 2700287 2899 Independent Districts and Schools PLAINVIEW-ELGIN-MILLVILLE 270028703667 20 PLAINVIEW-ELGIN-MILLVILLE 4-6 Elementary School (Grades PK-6) Regular School No Elementary 04 06 2017   grade_4 88.0 0.0 9.0   0.0 0.0     0.0   2.0   59.0 40.0     1.0   0.0     37.0   19.0   99.0 88 0 9   0 0     0   2   59 40     1 0   37 19   99
696446 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124001866 175 FOLWELL ARTS MAGNET Elementary School (Grades PK-6) Regular School No Elementary PK 08 2017   grade_4 13.0 21.0 60.0   2.0 0.0     0.0   3.0   48.0 51.0     45.0   6.0         20.0   99.0 13 21 60   2 0     0   3   48 51     45 6     20   99
696475 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   grade_3 0.0 33.0 60.0   5.0 0.0     0.0   1.0   54.0 45.0     78.0   5.0         12.0   99.0 0 33 60   5 0     0   1   54 45     78 5     12   99
697089 MN Hennepin 27 school 2700281 4140 Charter Schools YINGHUA ACADEMY 270028103611 10 YINGHUA ACADEMY Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2017   grade_4 45.0 8.0 2.0   1.0 43.0     0.0   0.0   45.0 54.0     3.0   0.0     8.0   9.0   99.0 45 8 2   1 43     0   0   45 54     3 0   8 9   99
698457 MN Pipestone 59 school 2700108 2689 Independent Districts and Schools PIPESTONE AREA SCHOOL DISTRICT 270010801264 7 PIPESTONE MIDDLE Middle School (Grades 5-8) Regular School No Middle 05 08 2017   grade_5 70.0 0.0 18.0   2.0 1.0     0.0   8.0   51.0 48.0         *         *   99.0 70 0 18   2 1     0   8   51 48                 99
698511 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124002581 318 OLSON MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_8 3.0 70.0 9.0   4.0 12.0     0.0   1.0   58.0 41.0     9.0   11.0         33.0   99.0 3 70 9   4 12     0   1   58 41     9 11     33   99
699672 MN Hennepin 27 school 2700350 4111 Charter Schools AUGSBURG FAIRVIEW ACADEMY 270035004097 10 AUGSBURG FAIRVIEW ACADEMY Senior High School (Grades 9-12) Regular School Yes High 09 12 2017   pk_12_total 4.0 41.0 6.0   28.0 1.0     1.0   18.0   44.0 55.0     0.0   30.0         39.0   99.0 4 41 6   28 1     1   18   44 55     0 30     39   99
699828 MN Carver 10 school 2708190 112 Independent Districts and Schools EASTERN CARVER COUNTY PUBLIC SCHOOL 270819004310 65 INTEGRATED ARTS ACADEMY Public Area Learning Center ALC (State approved) Alternative School No High 09 12 2017   pk_12_total 64.0 4.0 23.0   0.0 1.0     0.0   7.0   44.0 55.0         0.0     38.0   26.0   99.0 64 4 23   0 1     0   7   44 55       0   38 26   99
699881 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239000500 58 ROSEMOUNT AREA LEARNING CENTER Public Area Learning Center ALC (State approved) Alternative School No High 09 12 2017   pk_12_total 46.0 20.0 24.0   1.0 1.0     0.0   7.0   48.0 51.0         6.0     48.0   27.0   99.0 46 20 24   1 1     0   7   48 51       6   48 27   99
701782 MN Hennepin 27 school 2706240 286 Independent Districts and Schools BROOKLYN CENTER SCHOOL DISTRICT 270624004306 221 INSIGHT SCHOOL OF MINNESOTA Distance Learning Program OLL (State approved) Regular School No Other 06 12 2017   grade_12 79.0 5.0 6.0   2.0 6.0     0.0   1.0   46.0 53.0     0.0   0.0     31.0   24.0   99.0 79 5 6   2 6     0   1   46 53     0 0   31 24   99
689369 MN Koochiching 36 school 2715000 361 Independent Districts and Schools INTERNATIONAL FALLS SCHOOL DISTRICT 271500000761 1 FALLS SECONDARY Secondary School (Grades 7-12) Regular School No Other 06 12 2017   grade_11 90.0 0.0 2.0   3.0 1.0     0.0   2.0   52.0 46.0     1.0   1.0     25.0   12.0   98.0 90 0 2   3 1     0   2   52 46     1 1   25 12   98
689500 MN Morrison 49 school 2728320 484 Independent Districts and Schools PIERZ PUBLIC SCHOOL DISTRICT 272832001252 30 HEALY SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   grade_7 95.0 0.0 2.0   0.0 0.0     0.0   1.0   49.0 49.0     0.0   0.0     39.0   12.0   98.0 95 0 2   0 0     0   1   49 49     0 0   39 12   98
689722 MN Roseau 68 school 2732250 682 Independent Districts and Schools ROSEAU PUBLIC SCHOOL DISTRICT 273225001371 20 ROSEAU SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   grade_7 92.0 2.0 2.0   0.0 0.0     0.0   2.0   50.0 48.0     0.0   *     24.0   16.0   98.0 92 2 2   0 0     0   2   50 48     0     24 16   98
689772 MN Stearns 73 school 2714190 738 Independent Districts and Schools HOLDINGFORD PUBLIC SCHOOL DISTRICT 271419000733 2 HOLDINGFORD SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   grade_8 95.0 0.0 1.0   1.0 0.0     0.0   1.0   57.0 41.0     0.0   0.0     23.0   9.0   98.0 95 0 1   1 0     0   1   57 41     0 0   23 9   98
690459 MN Hennepin 27 school 2700364 4122 Charter Schools EAGLE RIDGE ACADEMY CHARTER SCHOOL 270036404108 10 EAGLE RIDGE ACADEMY CHARTER SCHOOL Secondary School (Grades 7-12) Regular School Yes Other 06 12 2017   grade_6 39.0 22.0 0.0   0.0 31.0     0.0   6.0   40.0 58.0     3.0   0.0     24.0   6.0   98.0 39 22 0   0 31     0   6   40 58     3 0   24 6   98
690555 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 2017   grade_6 90.0 1.0 2.0   0.0 0.0     0.0   5.0   61.0 37.0     1.0   0.0     48.0   12.0   98.0 90 1 2   0 0     0   5   61 37     1 0   48 12   98
690807 MN Anoka 2 school 2712420 14 Independent Districts and Schools FRIDLEY PUBLIC SCHOOL DISTRICT 271242000612 546 HAYES ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2017   kindergarten 46.0 28.0 8.0   0.0 4.0     0.0   12.0   55.0 43.0     15.0   0.0     55.0   7.0   98.0 46 28 8   0 4     0   12   55 43     15 0   55 7   98
690809 MN Anoka 2 school 2712420 14 Independent Districts and Schools FRIDLEY PUBLIC SCHOOL DISTRICT 271242000612 546 HAYES ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2017   grade_2 46.0 33.0 8.0   0.0 4.0     0.0   7.0   49.0 49.0     24.0   2.0     61.0   16.0   98.0 46 33 8   0 4     0   7   49 49     24 2   61 16   98
690869 MN Becker 3 school 2710230 22 Independent Districts and Schools DETROIT LAKES PUBLIC SCHOOL DIST. 271023000445 10 ROSSMAN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_1 83.0 0.0 3.0   5.0 1.0     0.0   6.0   48.0 50.0     0.0   2.0     34.0   20.0   98.0 83 0 3   5 1     0   6   48 50     0 2   34 20   98
690871 MN Becker 3 school 2710230 22 Independent Districts and Schools DETROIT LAKES PUBLIC SCHOOL DIST. 271023000445 10 ROSSMAN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_3 76.0 0.0 3.0   6.0 0.0     0.0   13.0   54.0 44.0     0.0   2.0     39.0   16.0   98.0 76 0 3   6 0     0   13   54 44     0 2   39 16   98
691044 MN Nicollet 52 school 2718780 77 Independent Districts and Schools MANKATO PUBLIC SCHOOL DISTRICT 271878000875 20 HOOVER ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_2 77.0 12.0 3.0   0.0 1.0     0.0   5.0   47.0 51.0     9.0   1.0     31.0   11.0   98.0 77 12 3   0 1     0   5   47 51     9 1   31 11   98
691297 MN Carver 10 school 2708190 112 Independent Districts and Schools EASTERN CARVER COUNTY PUBLIC SCHOOL 270819002294 513 JONATHAN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_2 82.0 2.0 5.0   0.0 3.0     0.0   6.0   56.0 42.0         1.0     13.0   10.0   98.0 82 2 5   0 3     0   6   56 42       1   13 10   98
691299 MN Carver 10 school 2708190 112 Independent Districts and Schools EASTERN CARVER COUNTY PUBLIC SCHOOL 270819002294 513 JONATHAN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_4 68.0 6.0 8.0   0.0 5.0     0.0   11.0   51.0 47.0     5.0   0.0     19.0   18.0   98.0 68 6 8   0 5     0   11   51 47     5 0   19 18   98
691571 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 2017   grade_3 81.0 9.0 3.0   0.0 2.0     0.0   3.0   45.0 53.0     6.0   0.0     31.0   15.0   98.0 81 9 3   0 2     0   3   45 53     6 0   31 15   98
691639 MN Dakota 19 school 2717780 194 Independent Districts and Schools LAKEVILLE PUBLIC SCHOOL DISTRICT 271778002273 595 LAKE MARION ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_4 75.0 6.0 12.0   0.0 2.0     0.0   3.0   42.0 56.0     4.0   1.0     30.0   14.0   98.0 75 6 12   0 2     0   3   42 56     4 1   30 14   98
691749 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   grade_5 37.0 26.0 16.0   2.0 7.0     0.0   10.0   44.0 54.0         3.0     48.0   9.0   98.0 37 26 16   2 7     0   10   44 54       3   48 9   98
691768 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239002216 717 WOODLAND ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_3 65.0 6.0 9.0   3.0 12.0     1.0   2.0   56.0 42.0     10.0   0.0     16.0   11.0   98.0 65 6 9   3 12     1   2   56 42     10 0   16 11   98
692215 MN Hennepin 27 school 2714220 272 Independent Districts and Schools EDEN PRAIRIE PUBLIC SCHOOL DISTRICT 271422000737 881 PRAIRIE VIEW ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 06 2017   grade_1 63.0 13.0 7.0   0.0 9.0     0.0   6.0   52.0 46.0     13.0   0.0     23.0   5.0   98.0 63 13 7   0 9     0   6   52 46     13 0   23 5   98
692216 MN Hennepin 27 school 2714220 272 Independent Districts and Schools EDEN PRAIRIE PUBLIC SCHOOL DISTRICT 271422000737 881 PRAIRIE VIEW ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 06 2017   grade_2 60.0 11.0 10.0   0.0 13.0     0.0   4.0   54.0 44.0     14.0   0.0     19.0   13.0   98.0 60 11 10   0 13     0   4   54 44     14 0   19 13   98
692217 MN Hennepin 27 school 2714220 272 Independent Districts and Schools EDEN PRAIRIE PUBLIC SCHOOL DISTRICT 271422000737 881 PRAIRIE VIEW ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 06 2017   grade_3 64.0 15.0 6.0   0.0 10.0     0.0   3.0   53.0 45.0     23.0   1.0     28.0   14.0   98.0 64 15 6   0 10     0   3   53 45     23 1   28 14   98
692265 MN Hennepin 27 school 2711250 273 Independent Districts and Schools EDINA PUBLIC SCHOOL DISTRICT 271125000506 527 CORNELIA ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_4 53.0 8.0 10.0   0.0 23.0     0.0   4.0   49.0 49.0     10.0   0.0     18.0   12.0   98.0 53 8 10   0 23     0   4   49 49     10 0   18 12   98
692474 MN Hennepin 27 school 2725200 279 Independent Districts and Schools OSSEO PUBLIC SCHOOL DISTRICT 272520001940 685 RICE LAKE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_3 55.0 11.0 7.0   0.0 14.0     0.0   11.0   49.0 49.0     16.0   1.0     35.0   11.0   98.0 55 11 7   0 14     0   11   49 49     16 1   35 11   98
692614 MN Hennepin 27 school 2733780 283 Independent Districts and Schools ST. LOUIS PARK PUBLIC SCHOOL DIST. 273378001525 745 AQUILA ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_3 43.0 25.0 15.0   0.0 3.0     0.0   12.0   55.0 43.0     24.0   *     43.0   13.0   98.0 43 25 15   0 3     0   12   55 43     24     43 13   98
692691 MN Hennepin 27 school 2742160 284 Independent Districts and Schools WAYZATA PUBLIC SCHOOL DISTRICT 274216002307 812 KIMBERLY LANE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_3 50.0 1.0 7.0   0.0 36.0     0.0   4.0   60.0 38.0     1.0   0.0     1.0   13.0   98.0 50 1 7   0 36     0   4   60 38     1 0   1 13   98
693388 MN Olmsted 55 school 2731800 535 Independent Districts and Schools ROCHESTER PUBLIC SCHOOL DISTRICT 273180000993 124 FRANKLIN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_5 45.0 22.0 21.0   1.0 5.0     0.0   4.0   48.0 50.0     27.0   3.0     61.0   17.0   98.0 45 22 21   1 5     0   4   48 50     27 3   61 17   98
693452 MN Olmsted 55 school 2731800 535 Independent Districts and Schools ROCHESTER PUBLIC SCHOOL DISTRICT 273180003077 147 RIVERSIDE CENTRAL ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_1 37.0 21.0 22.0   2.0 9.0     0.0   7.0   48.0 50.0     42.0   3.0     80.0   29.0   98.0 37 21 22   2 9     0   7   48 50     42 3   80 29   98
693521 MN Otter Tail 56 school 2728230 549 Independent Districts and Schools PERHAM-DENT PUBLIC SCHOOL DISTRICT 272823001247 10 HEART OF THE LAKE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2017   grade_1 85.0 2.0 7.0   2.0 0.0     0.0   2.0   58.0 40.0     3.0   0.0     44.0   14.0   98.0 85 2 7   2 0     0   2   58 40     3 0   44 14   98
693687 MN Ramsey 62 school 2723850 622 Independent Districts and Schools North St Paul-Maplewood Oakdale Public School District 272385001166 27 CARVER ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_5 37.0 19.0 18.0   0.0 14.0     0.0   10.0   54.0 44.0     8.0   *     60.0   14.0   98.0 37 19 18   0 14     0   10   54 44     8     60 14   98
693801 MN Ramsey 62 school 2732430 623 Independent Districts and Schools ROSEVILLE PUBLIC SCHOOL DISTRICT 273243001394 728 LITTLE CANADA ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 06 2017   grade_4 34.0 10.0 32.0   0.0 13.0     0.0   9.0   45.0 53.0     19.0   0.0     60.0   13.0   98.0 34 10 32   0 13     0   9   45 53     19 0   60 13   98
693827 MN Ramsey 62 school 2742360 624 Independent Districts and Schools WHITE BEAR LAKE SCHOOL DISTRICT 274236001050 828 OTTER LAKE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_2 75.0 3.0 8.0   0.0 8.0     0.0   4.0   48.0 50.0     8.0   0.0     24.0   17.0   98.0 75 3 8   0 8     0   4   48 50     8 0   24 17   98
694495 MN Scott 70 school 2730060 719 Independent Districts and Schools PRIOR LAKE-SAVAGE AREA SCHOOLS 273006003711 17 JEFFERS POND ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   kindergarten 83.0 0.0 0.0   2.0 7.0     0.0   6.0   48.0 50.0     2.0   0.0         9.0   98.0 83 0 0   2 7     0   6   48 50     2 0     9   98
694516 MN Scott 70 school 2733000 720 Independent Districts and Schools SHAKOPEE PUBLIC SCHOOL DISTRICT 273300001437 861 SUN PATH ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   kindergarten 58.0 15.0 9.0   0.0 12.0     0.0   4.0   45.0 53.0     27.0   0.0         11.0   98.0 58 15 9   0 12     0   4   45 53     27 0     11   98
694526 MN Scott 70 school 2733000 720 Independent Districts and Schools SHAKOPEE PUBLIC SCHOOL DISTRICT 273300003166 864 RED OAK ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_1 51.0 8.0 19.0   3.0 10.0     0.0   7.0   53.0 45.0     31.0   0.0     43.0   11.0   98.0 51 8 19   3 10     0   7   53 45     31 0   43 11   98
694741 MN Stearns 73 school 2733510 742 Independent Districts and Schools ST. CLOUD PUBLIC SCHOOL DISTRICT 273351002285 51 OAK HILL COMMUNITY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_1 44.0 40.0 6.0   0.0 1.0     0.0   7.0   45.0 53.0     32.0   *     55.0   9.0   98.0 44 40 6   0 1     0   7   45 53     32     55 9   98
694803 MN Stearns 73 school 2709440 750 Independent Districts and Schools ROCORI PUBLIC SCHOOL DISTRICT 270944000385 30 COLD SPRING ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_5 77.0 1.0 18.0   0.0 0.0     0.0   2.0   49.0 49.0     10.0   2.0     27.0   16.0   98.0 77 1 18   0 0     0   2   49 49     10 2   27 16   98
695121 MN Washington 82 school 2733810 833 Independent Districts and Schools SOUTH WASHINGTON COUNTY SCHOOL DIST 273381001546 44 ROYAL OAKS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_1 65.0 4.0 8.0   1.0 14.0     0.0   6.0   56.0 42.0     14.0   0.0     16.0   18.0   98.0 65 4 8   1 14     0   6   56 42     14 0   16 18   98
695142 MN Washington 82 school 2733810 833 Independent Districts and Schools SOUTH WASHINGTON COUNTY SCHOOL DIST 273381002306 47 MIDDLETON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_1 68.0 8.0 6.0   0.0 11.0     0.0   5.0   57.0 41.0     7.0   1.0     16.0   11.0   98.0 68 8 6   0 11     0   5   57 41     7 1   16 11   98
695364 MN Wright 86 school 2707200 877 Independent Districts and Schools BUFFALO-HANOVER-MONTROSE PUBLIC SCH 270720001875 60 TATANKA ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_2 87.0 1.0 1.0   1.0 0.0     0.0   8.0   50.0 48.0         2.0     33.0   12.0   98.0 87 1 1   1 0     0   8   50 48       2   33 12   98
695502 MN Dodge 20 school 2740665 2125 Independent Districts and Schools TRITON SCHOOL DISTRICT 274066500036 10 TRITON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_3 72.0 0.0 22.0   0.0 0.0     0.0   4.0   50.0 48.0     9.0   0.0     50.0   10.0   98.0 72 0 22   0 0     0   4   50 48     9 0   50 10   98
695622 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 2017   grade_6 88.0 1.0 1.0   1.0 0.0     0.0   7.0   49.0 49.0     0.0   0.0         12.0   98.0 88 1 1   1 0     0   7   49 49     0 0     12   98
696274 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124000938 103 ARMATAGE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_4 62.0 22.0 4.0   1.0 4.0     0.0   5.0   50.0 48.0     13.0   2.0     31.0   8.0   98.0 62 22 4   1 4     0   5   50 48     13 2   31 8   98
696285 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124000941 105 BANCROFT ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_2 15.0 43.0 25.0   11.0 0.0     0.0   4.0   51.0 47.0     37.0   5.0     82.0   12.0   98.0 15 43 25   11 0     0   4   51 47     37 5   82 12   98
696972 MN Cook 16 school 2700339 4100 Charter Schools GREAT EXPECTATIONS 270033904177 10 GREAT EXPECTATIONS Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2017   pk_12_total 95.0 0.0 0.0   3.0 0.0     0.0   0.0   43.0 55.0     0.0   0.0     42.0   25.0   98.0 95 0 0   3 0     0   0   43 55     0 0   42 25   98
697095 MN Stearns 73 school 2700252 4142 Charter Schools Stride Academy Charter School 270025204405 20 Stride Academy K-8 Charter School Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2017   kindergarten 66.0 19.0 4.0   0.0 4.0     0.0   5.0   54.0 44.0     18.0   1.0     52.0   8.0   98.0 66 19 4   0 4     0   5   54 44     18 1   52 8   98
698428 MN Rock 67 school 2718330 2184 Independent Districts and Schools LUVERNE PUBLIC SCHOOL DISTRICT 271833002471 3 LUVERNE MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_8 87.0 1.0 4.0   0.0 3.0     0.0   3.0   48.0 50.0         *         *   98.0 87 1 4   0 3     0   3   48 50                 98
698472 MN Jackson 32 school 2700231 2895 Independent Districts and Schools JACKSON COUNTY CENTRAL SCHOOL DIST. 270023102042 115 JACKSON COUNTY CENTRAL MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 08 2017   grade_7 86.0 0.0 3.0   0.0 4.0     0.0   5.0   61.0 37.0     0.0   0.0     37.0   13.0   98.0 86 0 3   0 4     0   5   61 37     0 0   37 13   98
698883 MN Goodhue 25 school 2728950 255 Independent Districts and Schools PINE ISLAND PUBLIC SCHOOL DIST. 272895001258 20 PINE ISLAND SECONDARY Senior High School (Grades 9-12) Regular School No High 09 12 2017   grade_12 95.0 1.0 1.0   0.0 1.0     0.0   0.0   49.0 49.0     0.0   1.0     8.0   5.0   98.0 95 1 1   0 1     0   0   49 49     0 1   8 5   98
699553 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124004557 375 NORTH ACADEMY SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 09 12 2017   grade_11 7.0 87.0 1.0   0.0 3.0     0.0   0.0   44.0 54.0     3.0   9.0     83.0   31.0   98.0 7 87 1   0 3     0   0   44 54     3 9   83 31   98

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