Data source: Big Local News · About: Big Local

943 rows where grade = "grade_1", state = "MN" and year = 2017 sorted by white

View and edit SQL

year

  • 2017 · 843

grade

  • grade_1 · 843
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
697448 MN Anoka 2 school 2700390 4224 Charter Schools Star of the North Academy Charter School 270039004759 10 Star of the North Academy Charter School Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2017   grade_1 10.0 9.0 0.0   0.0 7.0     0.0   0.0   11.0 15.0     11.0   0.0     12.0   0.0   26.0 10 9 0   0 7     0   0   11 15     11 0   12 0   26
691801 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239002519 765 RED PINE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_1 100.0 4.0 4.0   1.0 10.0     0.0   5.0   62.0 62.0     9.0   0.0     14.0   12.0   124.0 100 4 4   1 10     0   5   62 62     9 0   14 12   124
692255 MN Hennepin 27 school 2711250 273 Independent Districts and Schools EDINA PUBLIC SCHOOL DISTRICT 271125000505 526 CONCORD ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_1 100.0 5.0 6.0   0.0 6.0     0.0   5.0   65.0 57.0     5.0   0.0     10.0   9.0   122.0 100 5 6   0 6     0   5   65 57     5 0   10 9   122
692867 MN Kandiyohi 34 school 2723400 345 Independent Districts and Schools NEW LONDON-SPICER SCHOOL DISTRICT 272340001141 10 PRAIRIE WOODS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2017   grade_1 100.0 0.0 7.0   0.0 0.0     1.0   0.0   57.0 51.0     1.0   1.0     27.0   8.0   108.0 100 0 7   0 0     1   0   57 51     1 1   27 8   108
690822 MN Anoka 2 school 2733540 15 Independent Districts and Schools ST. FRANCIS PUBLIC SCHOOL DISTRICT 273354000230 782 ST. FRANCIS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_1 101.0 1.0 5.0   2.0 1.0     0.0   7.0   57.0 60.0     0.0   0.0     38.0   23.0   117.0 101 1 5   2 1     0   7   57 60     0 0   38 23   117
692311 MN Hennepin 27 school 2711670 276 Independent Districts and Schools MINNETONKA PUBLIC SCHOOL DISTRICT 271167000543 603 EXCELSIOR ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_1 101.0 5.0 6.0   0.0 17.0     0.0   8.0   75.0 62.0     7.0   0.0     12.0   20.0   137.0 101 5 6   0 17     0   8   75 62     7 0   12 20   137
694540 MN Scott 70 school 2733000 720 Independent Districts and Schools SHAKOPEE PUBLIC SCHOOL DISTRICT 273300004391 866 JACKSON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_1 101.0 9.0 20.0   0.0 19.0     0.0   11.0   88.0 72.0     24.0   2.0     39.0   21.0   160.0 101 9 20   0 19     0   11   88 72     24 2   39 21   160
694613 MN Sherburne 71 school 2711370 728 Independent Districts and Schools ELK RIVER PUBLIC SCHOOL DISTRICT 271137003689 170 TWIN LAKES ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_1 101.0 3.0 4.0   2.0 5.0     0.0   7.0   66.0 56.0     5.0   0.0     16.0   16.0   122.0 101 3 4   2 5     0   7   66 56     5 0   16 16   122
690773 MN Anoka 2 school 2708100 12 Independent Districts and Schools CENTENNIAL PUBLIC SCHOOL DISTRICT 270810003172 515 BLUE HERON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_1 102.0 4.0 4.0   0.0 10.0     0.0   5.0   59.0 66.0     5.0   0.0     15.0   17.0   125.0 102 4 4   0 10     0   5   59 66     5 0   15 17   125
696177 MN Wabasha 79 school 2700287 2899 Independent Districts and Schools PLAINVIEW-ELGIN-MILLVILLE 270028703701 10 PLAINVIEW-ELGIN-MILLVILLE PK-3 Elementary School (Grades PK-6) Regular School No Elementary PK 03 2017   grade_1 102.0 1.0 7.0   0.0 0.0     0.0   1.0   66.0 45.0     3.0   0.0     41.0   13.0   111.0 102 1 7   0 0     0   1   66 45     3 0   41 13   111
696323 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124000970 123 HALE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 04 2017   grade_1 102.0 6.0 8.0   0.0 3.0     0.0   17.0   63.0 73.0     2.0   0.0     13.0   9.0   136.0 102 6 8   0 3     0   17   63 73     2 0   13 9   136
690829 MN Anoka 2 school 2733540 15 Independent Districts and Schools ST. FRANCIS PUBLIC SCHOOL DISTRICT 273354000233 784 CEDAR CREEK COMMUNITY SCHOOL Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_1 104.0 2.0 4.0   2.0 4.0     0.0   4.0   56.0 64.0     7.0   2.0     30.0   21.0   120.0 104 2 4   2 4     0   4   56 64     7 2   30 21   120
692044 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 2017   grade_1 104.0 5.0 4.0   0.0 1.0     0.0   3.0   61.0 56.0     0.0   1.0     21.0   14.0   117.0 104 5 4   0 1     0   3   61 56     0 1   21 14   117
692375 MN Hennepin 27 school 2725200 279 Independent Districts and Schools OSSEO PUBLIC SCHOOL DISTRICT 272520002522 669 RUSH CREEK ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_1 104.0 1.0 5.0   0.0 10.0     0.0   8.0   57.0 71.0         *         5.0   128.0 104 1 5   0 10     0   8   57 71             5   128
693006 MN Lyon 42 school 2718940 413 Independent Districts and Schools MARSHALL PUBLIC SCHOOL DISTRICT 271894000891 2 PARK SIDE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 02 2017   grade_1 104.0 24.0 37.0   0.0 19.0     0.0   6.0   104.0 86.0     60.0   1.0     109.0   33.0   190.0 104 24 37   0 19     0   6   104 86     60 1   109 33   190
694577 MN Sherburne 71 school 2705460 727 Independent Districts and Schools BIG LAKE PUBLIC SCHOOL DISTRICT 270546000205 10 INDEPENDENCE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_1 105.0 3.0 6.0   0.0 2.0     0.0   4.0   62.0 58.0     2.0   0.0     31.0   11.0   120.0 105 3 6   0 2     0   4   62 58     2 0   31 11   120
695415 MN Hennepin 27 school 2732070 883 Independent Districts and Schools ROCKFORD PUBLIC SCHOOL DISTRICT 273207001367 2 ROCKFORD ELEMENTARY ARTS MAGNET SCH Elementary School (Grades PK-6) Regular School No Elementary PK 04 2017   grade_1 105.0 2.0 10.0   1.0 3.0     0.0   2.0   67.0 56.0     11.0   0.0     37.0   17.0   123.0 105 2 10   1 3     0   2   67 56     11 0   37 17   123
694359 MN Saint Louis 69 school 2741040 706 Independent Districts and Schools VIRGINIA PUBLIC SCHOOL DISTRICT 274104002552 112 PARKVIEW ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 02 2017   grade_1 107.0 2.0 9.0   2.0 0.0     0.0   12.0   71.0 61.0     0.0   0.0     59.0   16.0   132.0 107 2 9   2 0     0   12   71 61     0 0   59 16   132
696310 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124000945 110 BURROUGHS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_1 107.0 10.0 1.0   1.0 4.0     0.0   10.0   65.0 68.0     2.0   1.0     14.0   11.0   133.0 107 10 1   1 4     0   10   65 68     2 1   14 11   133
691216 MN Carver 10 school 2741460 110 Independent Districts and Schools WACONIA PUBLIC SCHOOL DISTRICT 274146000363 110 SOUTHVIEW ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_1 108.0 1.0 3.0   0.0 1.0     0.0   3.0   55.0 61.0     1.0   0.0     9.0   13.0   116.0 108 1 3   0 1     0   3   55 61     1 0   9 13   116
691780 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239002283 719 SHANNON PARK ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_1 108.0 1.0 1.0   0.0 9.0     0.0   8.0   65.0 62.0     6.0   0.0     10.0   9.0   127.0 108 1 1   0 9     0   8   65 62     6 0   10 9   127
693573 MN Pine 58 school 2728380 578 Independent Districts and Schools PINE CITY PUBLIC SCHOOL DISTRICT 272838001255 10 PINE CITY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_1 108.0 3.0 1.0   0.0 0.0     0.0   0.0   69.0 43.0     0.0   1.0     47.0   11.0   112.0 108 3 1   0 0     0   0   69 43     0 1   47 11   112
695423 MN Wright 86 school 2733790 885 Independent Districts and Schools ST. MICHAEL-ALBERTVILLE SCHOOL DIST 273379000032 40 ST. MICHAEL ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 01 04 2017   grade_1 108.0 2.0 5.0   0.0 4.0     0.0   7.0   61.0 65.0     4.0   0.0     13.0   4.0   126.0 108 2 5   0 4     0   7   61 65     4 0   13 4   126
693090 MN Martin 46 school 2740680 458 Independent Districts and Schools TRUMAN PUBLIC SCHOOL DISTRICT 274068001692 10 TRUMAN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_1 11.0 0.0 2.0   0.0 0.0     0.0   2.0   9.0 6.0     0.0   0.0     9.0   1.0   15.0 11 0 2   0 0     0   2   9 6     0 0   9 1   15
693885 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384001555 422 BATTLE CREEK ELEMENTARY SCHOOL Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_1 11.0 26.0 8.0   1.0 23.0     0.0   4.0   42.0 31.0     31.0   1.0     58.0   13.0   73.0 11 26 8   1 23     0   4   42 31     31 1   58 13   73
693954 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384002671 460 FOUR SEASONS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_1 11.0 30.0 12.0   0.0 12.0     0.0   5.0   37.0 33.0     25.0   2.0     61.0   11.0   70.0 11 30 12   0 12     0   5   37 33     25 2   61 11   70
695539 MN Saint Louis 69 school 2700008 2142 Independent Districts and Schools ST. LOUIS COUNTY SCHOOL DISTRICT 270000800158 10 BABBITT ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_1 11.0 0.0 0.0   0.0 0.0     0.0   0.0   4.0 7.0     0.0   2.0         4.0   11.0 11 0 0   0 0     0   0   4 7     0 2     4   11
696254 MN Nobles 53 school 2700388 2907 Independent Districts and Schools ROUND LAKE-BREWSTER PUBLIC SCHOOLS 270038804736 10 Round Lake-Brewster Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 08 2017   grade_1 11.0 1.0 24.0   0.0 0.0     0.0   3.0   20.0 19.0     20.0   0.0     28.0   2.0   39.0 11 1 24   0 0     0   3   20 19     20 0   28 2   39
696389 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124002296 155 PILLSBURY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_1 11.0 30.0 13.0   0.0 3.0     0.0   2.0   29.0 30.0     22.0   1.0     41.0   8.0   59.0 11 30 13   0 3     0   2   29 30     22 1   41 8   59
696397 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124003434 156 PRATT ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_1 11.0 24.0 3.0   2.0 2.0     0.0   2.0   20.0 24.0     12.0   *         3.0   44.0 11 24 3   2 2     0   2   20 24     12       3   44
696544 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124001882 260 EMERSON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_1 11.0 9.0 61.0   0.0 1.0     0.0   6.0   43.0 45.0     46.0   0.0     70.0   6.0   88.0 11 9 61   0 1     0   6   43 45     46 0   70 6   88
697515 MN Ramsey 62 school 2700408 4233 Charter Schools Level Up Academy 270040804800 10 Level Up Academy Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2017   grade_1 11.0 1.0 0.0   0.0 0.0     0.0   1.0   10.0 3.0     0.0   0.0     6.0   2.0   13.0 11 1 0   0 0     0   1   10 3     0 0   6 2   13
697539 MN Ramsey 62 school 2700423 4243 Charter Schools North Metro Flex Academy 270042304942 10 North Metro Flex Academy Elementary School (Grades PK-6) Regular School Yes Elementary KG 04 2017   grade_1 11.0 14.0 7.0   0.0 0.0     0.0   3.0   17.0 18.0     10.0   0.0     27.0   4.0   35.0 11 14 7   0 0     0   3   17 18     10 0   27 4   35
694547 MN Scott 70 school 2723430 721 Independent Districts and Schools NEW PRAGUE AREA SCHOOLS 272343002842 345 RAVEN STREAM ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_1 110.0 1.0 5.0   0.0 2.0     0.0   2.0   59.0 61.0         *     28.0   6.0   120.0 110 1 5   0 2     0   2   59 61           28 6   120
695474 MN Mille Lacs 48 school 2720670 912 Independent Districts and Schools MILACA PUBLIC SCHOOL DISTRICT 272067000923 10 MILACA ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_1 110.0 1.0 0.0   1.0 0.0     0.0   5.0   61.0 56.0     0.0   2.0     60.0   20.0   117.0 110 1 0   1 0     0   5   61 56     0 2   60 20   117
691708 MN Dakota 19 school 2732390 196 Independent Districts and Schools ROSEMOUNT-APPLE VALLEY-EAGAN 273239001378 709 PARKVIEW ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_1 111.0 10.0 12.0   2.0 13.0     1.0   12.0   79.0 82.0     14.0   0.0     40.0   18.0   161.0 111 10 12   2 13     1   12   79 82     14 0   40 18   161
694503 MN Scott 70 school 2730060 719 Independent Districts and Schools PRIOR LAKE-SAVAGE AREA SCHOOLS 273006004305 18 REDTAIL RIDGE ELEMENTARY SCHOOL Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_1 112.0 7.0 6.0   0.0 5.0     0.0   3.0   67.0 66.0     8.0   0.0     19.0   11.0   133.0 112 7 6   0 5     0   3   67 66     8 0   19 11   133
694592 MN Hennepin 27 school 2711370 728 Independent Districts and Schools ELK RIVER PUBLIC SCHOOL DISTRICT 271137000521 70 ROGERS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_1 112.0 1.0 2.0   0.0 1.0     0.0   2.0   53.0 65.0     3.0   0.0         *   118.0 112 1 2   0 1     0   2   53 65     3 0         118
691006 MN Benton 5 school 2732880 47 Independent Districts and Schools SAUK RAPIDS-RICE PUBLIC SCHOOLS 273288001431 7 PLEASANT VIEW ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_1 113.0 5.0 3.0   2.0 7.0     0.0   2.0   69.0 63.0     5.0   2.0     66.0   31.0   132.0 113 5 3   2 7     0   2   69 63     5 2   66 31   132
691239 MN Carver 10 school 2741910 111 Independent Districts and Schools WATERTOWN-MAYER PUBLIC SCHOOL DIST. 274191003674 839 WATERTOWN-MAYER ELEMENTARY SCHOOL Elementary School (Grades PK-6) Regular School No Elementary 01 05 2017   grade_1 113.0 2.0 2.0   3.0 0.0     0.0   5.0   63.0 62.0     0.0   0.0     31.0   25.0   125.0 113 2 2   3 0     0   5   63 62     0 0   31 25   125
692297 MN Hennepin 27 school 2711670 276 Independent Districts and Schools MINNETONKA PUBLIC SCHOOL DISTRICT 271167000541 601 CLEAR SPRINGS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_1 113.0 7.0 7.0   1.0 4.0     0.0   6.0   70.0 68.0     5.0   0.0     6.0   17.0   138.0 113 7 7   1 4     0   6   70 68     5 0   6 17   138
692850 MN Kanabec 33 school 2721480 332 Independent Districts and Schools MORA PUBLIC SCHOOL DISTRICT 272148001095 20 FAIRVIEW ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 02 2017   grade_1 113.0 1.0 2.0   1.0 1.0     0.0   5.0   65.0 58.0     0.0   1.0     60.0   26.0   123.0 113 1 2   1 1     0   5   65 58     0 1   60 26   123
691484 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 2017   grade_1 114.0 2.0 0.0   3.0 0.0     0.0   0.0   69.0 50.0     0.0   0.0     40.0   20.0   119.0 114 2 0   3 0     0   0   69 50     0 0   40 20   119
694772 MN Stearns 73 school 2732820 748 Independent Districts and Schools SARTELL-ST. STEPHEN SCHOOL DISTRICT 273282002187 40 PINE MEADOW ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 04 2017   grade_1 116.0 2.0 2.0   0.0 4.0     0.0   1.0   65.0 60.0     2.0   0.0     25.0   23.0   125.0 116 2 2   0 4     0   1   65 60     2 0   25 23   125
690618 MN Anoka 2 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318000111 407 JOHNSVILLE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_1 117.0 3.0 2.0   1.0 9.0     0.0   5.0   63.0 74.0     4.0   1.0     16.0   8.0   137.0 117 3 2   1 9     0   5   63 74     4 1   16 8   137
692325 MN Hennepin 27 school 2711670 276 Independent Districts and Schools MINNETONKA PUBLIC SCHOOL DISTRICT 271167000548 605 MINNEWASHTA ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_1 117.0 0.0 5.0   0.0 2.0     0.0   11.0   67.0 68.0     1.0   0.0     3.0   13.0   135.0 117 0 5   0 2     0   11   67 68     1 0   3 13   135
694448 MN Scott 70 school 2704050 716 Independent Districts and Schools BELLE PLAINE PUBLIC SCHOOL DISTRICT 270405000183 10 CHATFIELD ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 02 2017   grade_1 117.0 0.0 6.0   0.0 1.0     1.0   8.0   66.0 67.0     2.0   0.0     29.0   9.0   133.0 117 0 6   0 1     1   8   66 67     2 0   29 9   133
695100 MN Washington 82 school 2733810 833 Independent Districts and Schools SOUTH WASHINGTON COUNTY SCHOOL DIST 273381003198 41 LIBERTY RIDGE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_1 117.0 9.0 8.0   0.0 28.0     0.0   8.0   91.0 79.0     21.0   0.0     11.0   12.0   170.0 117 9 8   0 28     0   8   91 79     21 0   11 12   170
696998 MN Washington 82 school 2700358 4116 Charter Schools Lakes International Language Academy 270035804102 10 Lakes International Language Academy Elementary School (Grades PK-6) Regular School Yes Elementary KG 05 2017   grade_1 117.0 0.0 8.0   0.0 3.0     0.0   11.0   59.0 80.0     0.0   0.0     12.0   9.0   139.0 117 0 8   0 3     0   11   59 80     0 0   12 9   139
691593 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 05 2017   grade_1 118.0 1.0 6.0   0.0 3.0     0.0   5.0   61.0 72.0     1.0   0.0     13.0   21.0   133.0 118 1 6   0 3     0   5   61 72     1 0   13 21   133
693407 MN Olmsted 55 school 2731800 535 Independent Districts and Schools ROCHESTER PUBLIC SCHOOL DISTRICT 273180004287 129 GEORGE W. GIBBS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_1 118.0 8.0 7.0   1.0 13.0     0.0   8.0   82.0 73.0     11.0   0.0     32.0   13.0   155.0 118 8 7   1 13     0   8   82 73     11 0   32 13   155
691384 MN Clay 14 school 2721420 152 Independent Districts and Schools MOORHEAD PUBLIC SCHOOL DISTRICT 272142003509 187 Robert Asp Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_1 119.0 13.0 20.0   9.0 2.0     0.0   11.0   92.0 82.0     14.0   3.0     82.0   32.0   174.0 119 13 20   9 2     0   11   92 82     14 3   82 32   174
691904 MN Douglas 21 school 2703060 206 Independent Districts and Schools ALEXANDRIA PUBLIC SCHOOL DISTRICT 270306000084 120 GARFIELD ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_1 12.0 1.0 1.0   0.0 0.0     0.0   0.0   6.0 8.0     0.0   0.0     4.0   2.0   14.0 12 1 1   0 0     0   0   6 8     0 0   4 2   14
692841 MN Jackson 32 school 2713930 330 Independent Districts and Schools HERON LAKE-OKABENA SCHOOL DISTRICT 271393000015 10 HERON LAKE-OKABENA ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_1 12.0 0.0 2.0   0.0 0.0     0.0   0.0   10.0 4.0     0.0   0.0     9.0   2.0   14.0 12 0 2   0 0     0   0   10 4     0 0   9 2   14
694256 MN Roseau 68 school 2703540 676 Independent Districts and Schools BADGER PUBLIC SCHOOL DISTRICT 270354000162 10 BADGER ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_1 12.0 2.0 1.0   0.0 1.0     0.0   0.0   6.0 10.0     0.0   0.0     12.0   2.0   16.0 12 2 1   0 1     0   0   6 10     0 0   12 2   16
694310 MN Saint Louis 69 school 2712210 698 Independent Districts and Schools FLOODWOOD PUBLIC SCHOOL DISTRICT 271221000588 10 FLOODWOOD ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_1 12.0 0.0 0.0   1.0 0.0     0.0   3.0   7.0 9.0     0.0   0.0     6.0   2.0   16.0 12 0 0   1 0     0   3   7 9     0 0   6 2   16
695835 MN Kittson 35 school 2791446 2358 Independent Districts and Schools TRI-COUNTY SCHOOL DISTRICT 279144602313 10 KARLSTAD ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_1 12.0 0.0 0.0   0.0 0.0     0.0   0.0   5.0 7.0     0.0   0.0     7.0   0.0   12.0 12 0 0   0 0     0   0   5 7     0 0   7 0   12
695891 MN Norman 54 school 2791448 2527 Independent Districts and Schools NORMAN COUNTY WEST SCHOOL DISTRICT 279144802317 1 NORMAN COUNTY WEST ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_1 12.0 0.0 4.0   0.0 0.0     0.0   0.0   10.0 6.0     0.0   0.0     9.0   2.0   16.0 12 0 4   0 0     0   0   10 6     0 0   9 2   16
696443 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_1 12.0 26.0 48.0   4.0 2.0     0.0   4.0   42.0 54.0     43.0   3.0     85.0   9.0   96.0 12 26 48   4 2     0   4   42 54     43 3   85 9   96
691014 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 2017   grade_1 120.0 0.0 0.0   0.0 0.0     0.0   0.0   57.0 63.0     0.0   0.0     35.0   16.0   120.0 120 0 0   0 0     0   0   57 63     0 0   35 16   120
693555 MN Pennington 57 school 2738850 564 Independent Districts and Schools THIEF RIVER FALLS SCHOOL DISTRICT 273885002451 31 CHALLENGER ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_1 120.0 0.0 7.0   2.0 2.0     0.0   7.0   63.0 75.0     5.0   0.0     56.0   12.0   138.0 120 0 7   2 2     0   7   63 75     5 0   56 12   138
693612 MN Polk 60 school 2711130 595 Independent Districts and Schools EAST GRAND FORKS PUBLIC SCHOOL DIST 271113000497 120 NEW HEIGHTS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 02 2017   grade_1 123.0 18.0 9.0   0.0 0.0     0.0   2.0   76.0 76.0     13.0   0.0     62.0   9.0   152.0 123 18 9   0 0     0   2   76 76     13 0   62 9   152
691461 MN Crow Wing 18 school 2706090 181 Independent Districts and Schools BRAINERD PUBLIC SCHOOL DISTRICT 270609000259 12 RIVERSIDE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 04 2017   grade_1 125.0 2.0 2.0   2.0 0.0     0.0   5.0   73.0 63.0     0.0   1.0     71.0   34.0   136.0 125 2 2   2 0     0   5   73 63     0 1   71 34   136
691857 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 KG 05 2017   grade_1 13.0 4.0 21.0   0.0 1.0     0.0   3.0   26.0 16.0     11.0   0.0     24.0   6.0   42.0 13 4 21   0 1     0   3   26 16     11 0   24 6   42
692891 MN Kittson 35 school 2717880 356 Independent Districts and Schools LANCASTER PUBLIC SCHOOL DISTRICT 271788000821 10 LANCASTER ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_1 13.0 0.0 0.0   0.0 0.0     0.0   0.0   7.0 6.0     0.0   0.0     2.0   3.0   13.0 13 0 0   0 0     0   0   7 6     0 0   2 3   13
693734 MN Ramsey 62 school 2723850 622 Independent Districts and Schools North St Paul-Maplewood Oakdale Public School District 272385001179 36 WEBSTER ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_1 13.0 24.0 10.0   0.0 8.0     0.0   5.0   29.0 31.0     11.0   1.0     52.0   9.0   60.0 13 24 10   0 8     0   5   29 31     11 1   52 9   60
693774 MN Ramsey 62 school 2732430 623 Independent Districts and Schools ROSEVILLE PUBLIC SCHOOL DISTRICT 273243001388 722 CENTRAL PARK ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 06 2017   grade_1 13.0 16.0 8.0   0.0 12.0     0.0   6.0   26.0 29.0     23.0   0.0     40.0   3.0   55.0 13 16 8   0 12     0   6   26 29     23 0   40 3   55
694018 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384001587 488 THE HEIGHTS COMMUNITY SCHOOL Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_1 13.0 23.0 18.0   0.0 28.0     0.0   5.0   48.0 39.0     41.0   3.0     64.0   14.0   87.0 13 23 18   0 28     0   5   48 39     41 3   64 14   87
695786 MN Norman 54 school 2700101 2215 Independent Districts and Schools NORMAN COUNTY EAST SCHOOL DISTRICT 270010100622 10 NORMAN COUNTY EAST ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_1 13.0 0.0 0.0   0.0 0.0     0.0   5.0   13.0 5.0     0.0   0.0     11.0   4.0   18.0 13 0 0   0 0     0   5   13 5     0 0   11 4   18
696013 MN Todd 77 school 2700112 2759 Independent Districts and Schools EAGLE VALLEY PUBLIC SCHOOL DISTRICT 270011200368 10 EAGLE VALLEY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_1 13.0 0.0 1.0   0.0 0.0     0.0   2.0   9.0 7.0     0.0   0.0     8.0   1.0   16.0 13 0 1   0 0     0   2   9 7     0 0   8 1   16
696107 MN Freeborn 24 school 2700148 2886 Independent Districts and Schools GLENVILLE-EMMONS SCHOOL DISTRICT 270014800634 100 GLENVILLE EMMONS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_1 13.0 0.0 2.0   0.0 0.0     0.0   0.0   7.0 8.0     0.0   0.0         0.0   15.0 13 0 2   0 0     0   0   7 8     0 0     0   15
696826 MN Beltrami 4 school 2700225 4058 Charter Schools SCHOOLCRAFT LEARNING COMMUNITY CHTR 270022503464 10 SCHOOLCRAFT LEARNING COMMUNITY CHTR Elementary School (Grades PK-6) Regular School Yes Other KG 09 2017   grade_1 13.0 0.0 0.0   5.0 0.0     0.0   2.0   11.0 9.0     0.0   0.0     11.0   9.0   20.0 13 0 0   5 0     0   2   11 9     0 0   11 9   20
696983 MN Ramsey 62 school 2700344 4105 Charter Schools GREAT RIVER SCHOOL 270034404665 20 Great River Elementary School Elementary School (Grades PK-6) Regular School Yes Elementary 01 06 2017   grade_1 13.0 2.0 1.0   1.0 1.0     0.0   2.0   5.0 15.0     0.0   0.0     7.0   2.0   20.0 13 2 1   1 1     0   2   5 15     0 0   7 2   20
697345 MN Crow Wing 18 school 2700369 4198 Charter Schools DISCOVERY WOODS MONTESSORI SCHOOL 270036904444 10 DISCOVERY WOODS MONTESSORI SCHOOL Elementary School (Grades PK-6) Regular School Yes Elementary KG 06 2017   grade_1 13.0 0.0 1.0   0.0 0.0     0.0   1.0   11.0 4.0     0.0   0.0     8.0   2.0   15.0 13 0 1   0 0     0   1   11 4     0 0   8 2   15
697374 MN Hennepin 27 school 2700378 4208 Charter Schools NASHA SHKOLA CHARTER SCHOOL 270037804635 10 NASHA SHKOLA CHARTER SCHOOL Elementary School (Grades PK-6) Regular School Yes Elementary KG 08 2017   grade_1 13.0 0.0 0.0   0.0 0.0     0.0   0.0   7.0 6.0     11.0   0.0     11.0   0.0   13.0 13 0 0   0 0     0   0   7 6     11 0   11 0   13
691891 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 2017   grade_1 130.0 1.0 10.0   1.0 1.0     0.0   2.0   83.0 62.0     1.0   0.0     20.0   23.0   145.0 130 1 10   1 1     0   2   83 62     1 0   20 23   145
692318 MN Hennepin 27 school 2711670 276 Independent Districts and Schools MINNETONKA PUBLIC SCHOOL DISTRICT 271167000544 604 GROVELAND ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_1 130.0 2.0 3.0   0.0 3.0     0.0   3.0   77.0 64.0     2.0   0.0     4.0   10.0   141.0 130 2 3   0 3     0   3   77 64     2 0   4 10   141
694778 MN Stearns 73 school 2732820 748 Independent Districts and Schools SARTELL-ST. STEPHEN SCHOOL DISTRICT 273282004210 60 OAK RIDGE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 04 2017   grade_1 130.0 2.0 1.0   1.0 2.0     0.0   4.0   67.0 73.0     1.0   1.0     19.0   30.0   140.0 130 2 1   1 2     0   4   67 73     1 1   19 30   140
690843 MN Anoka 2 school 2733330 16 Independent Districts and Schools SPRING LAKE PARK PUBLIC SCHOOLS 273333001461 772 NORTHPOINT ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 03 2017   grade_1 132.0 11.0 10.0   0.0 10.0     0.0   21.0   109.0 75.0     14.0   0.0     50.0   21.0   184.0 132 11 10   0 10     0   21   109 75     14 0   50 21   184
691131 MN Brown 8 school 2723490 88 Independent Districts and Schools NEW ULM PUBLIC SCHOOL DISTRICT 272349001150 20 JEFFERSON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 01 04 2017   grade_1 132.0 1.0 7.0   0.0 0.0     0.0   2.0   82.0 60.0     0.0   2.0     39.0   18.0   142.0 132 1 7   0 0     0   2   82 60     0 2   39 18   142
693482 MN Otter Tail 56 school 2711880 544 Independent Districts and Schools FERGUS FALLS PUBLIC SCHOOL DISTRICT 271188000571 130 ADAMS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 01 02 2017   grade_1 134.0 4.0 5.0   1.0 0.0     1.0   2.0   70.0 77.0         *     64.0   *   147.0 134 4 5   1 0     1   2   70 77           64     147
694318 MN Saint Louis 69 school 2713920 700 Independent Districts and Schools HERMANTOWN PUBLIC SCHOOL DISTRICT 271392000715 10 HERMANTOWN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 04 2017   grade_1 136.0 2.0 4.0   1.0 1.0     0.0   2.0   78.0 68.0     1.0   0.0     25.0   13.0   146.0 136 2 4   1 1     0   2   78 68     1 0   25 13   146
695334 MN Wright 86 school 2703150 876 Independent Districts and Schools ANNANDALE PUBLIC SCHOOL DISTRICT 270315000094 1 ANNANDALE ELEMENTARY SCHOOL Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_1 136.0 2.0 4.0   0.0 1.0     0.0   8.0   83.0 68.0     2.0   1.0     48.0   33.0   151.0 136 2 4   0 1     0   8   83 68     2 1   48 33   151
692382 MN Hennepin 27 school 2725200 279 Independent Districts and Schools OSSEO PUBLIC SCHOOL DISTRICT 272520002523 670 BASSWOOD ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_1 137.0 11.0 6.0   0.0 17.0     0.0   10.0   106.0 75.0     10.0   0.0     19.0   19.0   181.0 137 11 6   0 17     0   10   106 75     10 0   19 19   181
693328 MN Olmsted 55 school 2707350 531 Independent Districts and Schools BYRON PUBLIC SCHOOL DISTRICT 270735004958 60 Byron Primary School Elementary School (Grades PK-6) Regular School No Elementary PK 02 2017   grade_1 137.0 1.0 3.0   1.0 3.0     0.0   9.0   91.0 63.0     2.0   0.0     19.0   20.0   154.0 137 1 3   1 3     0   9   91 63     2 0   19 20   154
695433 MN Wright 86 school 2733790 885 Independent Districts and Schools ST. MICHAEL-ALBERTVILLE SCHOOL DIST 273379003673 70 FIELDSTONE ELEMENTARY SCHOOL Elementary School (Grades PK-6) Regular School No Elementary 01 04 2017   grade_1 138.0 2.0 6.0   1.0 2.0     0.0   6.0   82.0 73.0     4.0   0.0     22.0   17.0   155.0 138 2 6   1 2     0   6   82 73     4 0   22 17   155
695038 MN Washington 82 school 2718750 832 Independent Districts and Schools MAHTOMEDI PUBLIC SCHOOL DISTRICT 271875000871 20 WILDWOOD ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 02 2017   grade_1 139.0 6.0 8.0   0.0 5.0     0.0   15.0   85.0 88.0     4.0   0.0     16.0   16.0   173.0 139 6 8   0 5     0   15   85 88     4 0   16 16   173
695428 MN Wright 86 school 2733790 885 Independent Districts and Schools ST. MICHAEL-ALBERTVILLE SCHOOL DIST 273379004187 60 BIG WOODS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 01 04 2017   grade_1 139.0 4.0 3.0   1.0 2.0     0.0   5.0   77.0 77.0     5.0   0.0     15.0   13.0   154.0 139 4 3   1 2     0   5   77 77     5 0   15 13   154
691328 MN Cass 11 school 2730870 118 Independent Districts and Schools NORTHLAND COMMUNITY SCHOOLS 273087001307 10 REMER ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_1 14.0 0.0 0.0   4.0 0.0     0.0   6.0   10.0 14.0     0.0   0.0     17.0   3.0   24.0 14 0 0   4 0     0   6   10 14     0 0   17 3   24
692988 MN Lincoln 41 school 2715540 403 Independent Districts and Schools IVANHOE PUBLIC SCHOOL DISTRICT 271554004539 10 Lincoln Elementary - Ivanhoe Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_1 14.0 0.0 0.0   0.0 0.0     0.0   0.0   7.0 7.0     0.0   0.0     6.0   2.0   14.0 14 0 0   0 0     0   0   7 7     0 0   6 2   14
693309 MN Nobles 53 school 2711460 514 Independent Districts and Schools ELLSWORTH PUBLIC SCHOOL DISTRICT 271146000525 10 ELLSWORTH ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_1 14.0 0.0 0.0   0.0 0.0     0.0   0.0   4.0 10.0     0.0   0.0     5.0   2.0   14.0 14 0 0   0 0     0   0   4 10     0 0   5 2   14
693758 MN Ramsey 62 school 2732430 623 Independent Districts and Schools ROSEVILLE PUBLIC SCHOOL DISTRICT 273243004842 525 Harambee Elementary School Elementary School (Grades PK-6) Regular School No Elementary KG 06 2017   grade_1 14.0 15.0 2.0   0.0 11.0     0.0   4.0   25.0 21.0     13.0   0.0     29.0   4.0   46.0 14 15 2   0 11     0   4   25 21     13 0   29 4   46
697044 MN Waseca 81 school 2700241 4127 Charter Schools TEAM ACADEMY 270024103341 10 TEAM ACADEMY Elementary School (Grades PK-6) Regular School Yes Elementary KG 06 2017   grade_1 14.0 0.0 7.0   0.0 0.0     0.0   0.0   9.0 12.0     3.0   1.0     14.0   3.0   21.0 14 0 7   0 0     0   0   9 12     3 1   14 3   21
691390 MN Clay 14 school 2721420 152 Independent Districts and Schools MOORHEAD PUBLIC SCHOOL DISTRICT 272142003510 188 ELLEN HOPKINS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_1 140.0 21.0 33.0   6.0 1.0     0.0   25.0   116.0 110.0     26.0   4.0     118.0   32.0   226.0 140 21 33   6 1     0   25   116 110     26 4   118 32   226
695454 MN Isanti 30 school 2707410 911 Independent Districts and Schools CAMBRIDGE-ISANTI PUBLIC SCHOOL DIST 270741003686 102 ISANTI PRIMARY SCHOOL Elementary School (Grades PK-6) Regular School No Elementary PK 02 2017   grade_1 140.0 4.0 5.0   1.0 3.0     0.0   9.0   80.0 82.0     4.0   3.0     55.0   26.0   162.0 140 4 5   1 3     0   9   80 82     4 3   55 26   162
690990 MN Benton 5 school 2732880 47 Independent Districts and Schools SAUK RAPIDS-RICE PUBLIC SCHOOLS 273288001430 3 MISSISSIPPI HEIGHTS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_1 144.0 6.0 4.0   1.0 1.0     0.0   5.0   87.0 74.0     3.0   5.0     52.0   25.0   161.0 144 6 4   1 1     0   5   87 74     3 5   52 25   161
693670 MN Ramsey 62 school 2722950 621 Independent Districts and Schools MOUNDS VIEW PUBLIC SCHOOL DISTRICT 272295001129 35 Turtle Lake Elementary Elementary School (Grades PK-6) Regular School No Elementary 01 05 2017   grade_1 144.0 2.0 2.0   0.0 25.0     0.0   12.0   101.0 84.0         0.0         12.0   185.0 144 2 2   0 25     0   12   101 84       0     12   185
690717 MN Hennepin 27 school 2703180 11 Independent Districts and Schools Anoka-Hennepin Public School District 270318002193 425 OXBOW CREEK ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_1 145.0 18.0 4.0   0.0 15.0     0.0   17.0   113.0 86.0     16.0   2.0     43.0   26.0   199.0 145 18 4   0 15     0   17   113 86     16 2   43 26   199
693833 MN Washington 82 school 2742360 624 Independent Districts and Schools WHITE BEAR LAKE SCHOOL DISTRICT 274236004409 830 HUGO ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 01 2017   grade_1 145.0 6.0 7.0   0.0 3.0     0.0   7.0   95.0 73.0     5.0   0.0     22.0   15.0   168.0 145 6 7   0 3     0   7   95 73     5 0   22 15   168
692054 MN Goodhue 25 school 2730480 256 Independent Districts and Schools RED WING PUBLIC SCHOOL DISTRICT 273048001297 541 SUNNYSIDE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 02 2017   grade_1 146.0 6.0 12.0   5.0 0.0     0.0   9.0   78.0 100.0     4.0   6.0     71.0   28.0   178.0 146 6 12   5 0     0   9   78 100     4 6   71 28   178

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