Data source: Big Local News · About: Big Local

964 rows where grade = "grade_2", state = "MN" and year = 2017 sorted by ccd_school_high_grade

View and edit SQL

year

  • 2017 · 964

grade

  • grade_2 · 964
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
692055 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_2 38.0 1.0 4.0   1.0 0.0     0.0   5.0   24.0 25.0     0.0   0.0     16.0   2.0   49.0 38 1 4   1 0     0   5   24 25     0 0   16 2   49
692352 MN Hennepin 27 school 2725080 278 Independent Districts and Schools ORONO PUBLIC SCHOOL DISTRICT 272508001200 661 SCHUMANN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 02 2017   grade_2 177.0 4.0 5.0   0.0 3.0     0.0   8.0   110.0 87.0     6.0   1.0     24.0   15.0   197.0 177 4 5   0 3     0   8   110 87     6 1   24 15   197
692851 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_2 110.0 0.0 5.0   2.0 0.0     0.0   1.0   63.0 55.0     0.0   1.0     56.0   19.0   118.0 110 0 5   2 0     0   1   63 55     0 1   56 19   118
693007 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_2 111.0 20.0 26.0   1.0 14.0     0.0   12.0   99.0 85.0     41.0   0.0     97.0   25.0   184.0 111 20 26   1 14     0   12   99 85     41 0   97 25   184
693076 MN Marshall 45 school 2723550 441 Independent Districts and Schools MARSHALL COUNTY CENTRAL SCHOOLS 272355001159 30 VIKING ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 02 2017   grade_2 32.0 1.0 1.0   0.0 0.0     0.0   0.0   24.0 10.0     0.0   0.0     12.0   5.0   34.0 32 1 1   0 0     0   0   24 10     0 0   12 5   34
693141 MN Mille Lacs 48 school 2730030 477 Independent Districts and Schools PRINCETON PUBLIC SCHOOL DISTRICT 273003001274 1 Princeton Primary School Elementary School (Grades PK-6) Regular School No Elementary PK 02 2017   grade_2 227.0 1.0 7.0   3.0 3.0     0.0   5.0   123.0 123.0         *     82.0   *   246.0 227 1 7   3 3     0   5   123 123           82     246
693297 MN Nicollet 52 school 2733870 508 Independent Districts and Schools ST. PETER PUBLIC SCHOOL DISTRICT 273387001639 50 South Early Learning Center Elementary School (Grades PK-6) Regular School No Elementary PK 02 2017   grade_2 110.0 16.0 31.0   1.0 1.0     0.0   6.0   91.0 74.0     19.0   5.0     63.0   20.0   165.0 110 16 31   1 1     0   6   91 74     19 5   63 20   165
693329 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_2 121.0 1.0 2.0   1.0 3.0     0.0   6.0   59.0 75.0     1.0   1.0     14.0   11.0   134.0 121 1 2   1 3     0   6   59 75     1 1   14 11   134
693345 MN Olmsted 55 school 2738160 534 Independent Districts and Schools STEWARTVILLE PUBLIC SCHOOL DISTRICT 273816001651 11 BONNER ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 02 2017   grade_2 135.0 1.0 8.0   0.0 0.0     0.0   7.0   74.0 77.0     4.0   0.0     39.0   14.0   151.0 135 1 8   0 0     0   7   74 77     4 0   39 14   151
693366 MN Olmsted 55 school 2731800 535 Independent Districts and Schools ROCHESTER PUBLIC SCHOOL DISTRICT 273180000987 116 CHURCHILL ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 02 2017   grade_2 50.0 6.0 6.0   1.0 8.0     0.0   4.0   33.0 42.0     6.0   1.0     22.0   7.0   75.0 50 6 6   1 8     0   4   33 42     6 1   22 7   75
693483 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_2 174.0 7.0 4.0   1.0 1.0     1.0   10.0   104.0 94.0         *     68.0   *   198.0 174 7 4   1 1     1   10   104 94           68     198
693613 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_2 114.0 12.0 26.0   5.0 0.0     0.0   5.0   89.0 73.0     6.0   1.0     62.0   31.0   162.0 114 12 26   5 0     0   5   89 73     6 1   62 31   162
694326 MN Saint Louis 69 school 2713980 701 Independent Districts and Schools HIBBING PUBLIC SCHOOL DISTRICT 271398001520 140 GREENHAVEN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 02 2017   grade_2 77.0 4.0 2.0   2.0 0.0     2.0   6.0   37.0 56.0     0.0   0.0     54.0   9.0   93.0 77 4 2   2 0     2   6   37 56     0 0   54 9   93
694330 MN Saint Louis 69 school 2713980 701 Independent Districts and Schools HIBBING PUBLIC SCHOOL DISTRICT 271398001528 160 WASHINGTON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 02 2017   grade_2 74.0 0.0 1.0   1.0 1.0     0.0   14.0   47.0 44.0     1.0   2.0     43.0   19.0   91.0 74 0 1   1 1     0   14   47 44     1 2   43 19   91
694360 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_2 88.0 4.0 6.0   5.0 0.0     0.0   14.0   66.0 51.0     1.0   0.0     55.0   22.0   117.0 88 4 6   5 0     0   14   66 51     1 0   55 22   117
694449 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_2 97.0 1.0 8.0   1.0 0.0     0.0   4.0   59.0 52.0     1.0   0.0     23.0   11.0   111.0 97 1 8   1 0     0   4   59 52     1 0   23 11   111
694465 MN Scott 70 school 2730060 719 Independent Districts and Schools PRIOR LAKE-SAVAGE AREA SCHOOLS 273006003449 9 EDGEWOOD ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 02 2017   grade_2 46.0 0.0 11.0   0.0 1.0     0.0   1.0   19.0 40.0     1.0   0.0     6.0   2.0   59.0 46 0 11   0 1     0   1   19 40     1 0   6 2   59
694574 MN Sherburne 71 school 2703870 726 Independent Districts and Schools BECKER PUBLIC SCHOOL DISTRICT 270387003092 40 BECKER PRIMARY Elementary School (Grades PK-6) Regular School No Elementary PK 02 2017   grade_2 205.0 3.0 9.0   0.0 1.0     0.0   8.0   125.0 101.0     4.0   3.0     47.0   21.0   226.0 205 3 9   0 1     0   8   125 101     4 3   47 21   226
694621 MN Sherburne 71 school 2711370 728 Independent Districts and Schools ELK RIVER PUBLIC SCHOOL DISTRICT 271137000522 200 ZIMMERMAN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 02 2017   grade_2 165.0 0.0 2.0   0.0 2.0     0.0   7.0   95.0 81.0     3.0   0.0     43.0   24.0   176.0 165 0 2   0 2     0   7   95 81     3 0   43 24   176
695039 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_2 181.0 5.0 8.0   0.0 4.0     0.0   9.0   102.0 105.0     7.0   0.0     18.0   25.0   207.0 181 5 8   0 4     0   9   102 105     7 0   18 25   207
695450 MN Isanti 30 school 2707410 911 Independent Districts and Schools CAMBRIDGE-ISANTI PUBLIC SCHOOL DIST 270741003638 101 CAMBRIDGE PRIMARY SCHOOL Elementary School (Grades PK-6) Regular School No Elementary PK 02 2017   grade_2 163.0 4.0 6.0   2.0 3.0     1.0   13.0   99.0 93.0     6.0   3.0     75.0   23.0   192.0 163 4 6   2 3     1   13   99 93     6 3   75 23   192
695455 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_2 119.0 0.0 0.0   2.0 3.0     0.0   3.0   72.0 55.0     0.0   0.0     41.0   11.0   127.0 119 0 0   2 3     0   3   72 55     0 0   41 11   127
695595 MN Chisago 13 school 2700017 2144 Independent Districts and Schools CHISAGO LAKES SCHOOL DISTRICT 270001700352 1 CHISAGO LAKES EL. Elementary School (Grades PK-6) Regular School No Elementary PK 02 2017   grade_2 158.0 0.0 4.0   0.0 2.0     0.0   5.0   77.0 92.0     3.0   0.0     41.0   18.0   169.0 158 0 4   0 2     0   5   77 92     3 0   41 18   169
695880 MN Martin 46 school 2718960 2448 Independent Districts and Schools MARTIN COUNTY WEST SCHOOL DISTRICT 271896000067 10 SHERBURN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 02 2017   grade_2 45.0 2.0 3.0   0.0 0.0     0.0   2.0   25.0 27.0     0.0   0.0     27.0   8.0   52.0 45 2 3   0 0     0   2   25 27     0 0   27 8   52
696037 MN Goodhue 25 school 2745735 2805 Independent Districts and Schools ZUMBROTA-MAZEPPA SCHOOL DISTRICT 274573504730 30 Zumbrota-Mazeppa Primary School Elementary School (Grades PK-6) Regular School No Elementary PK 02 2017   grade_2 81.0 1.0 2.0   0.0 0.0     0.0   4.0   53.0 35.0     0.0   0.0     25.0   12.0   88.0 81 1 2   0 0     0   4   53 35     0 0   25 12   88
696083 MN Mcleod 43 school 2700128 2859 Independent Districts and Schools GLENCOE-SILVER LAKE SCHOOL DISTRICT 270012800632 10 BAKER ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 02 2017   grade_2 77.0 0.0 30.0   0.0 0.0     0.0   4.0   54.0 57.0     12.0   0.0     58.0   8.0   111.0 77 0 30   0 0     0   4   54 57     12 0   58 8   111
696330 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124000978 130 HIAWATHA ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 02 2017   grade_2 52.0 13.0 6.0   2.0 4.0     0.0   6.0   44.0 39.0     4.0   *     26.0   7.0   83.0 52 13 6   2 4     0   6   44 39     4     26 7   83
696431 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124001057 167 LK NOKOMIS COMM-WENONAH CAMPUS Elementary School (Grades PK-6) Regular School No Elementary KG 02 2017   grade_2 57.0 16.0 16.0   2.0 5.0     0.0   6.0   53.0 49.0     14.0   3.0     45.0   12.0   102.0 57 16 16   2 5     0   6   53 49     14 3   45 12   102
690844 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_2 114.0 17.0 6.0   1.0 16.0     0.0   13.0   87.0 80.0     11.0   0.0     42.0   13.0   167.0 114 17 6   1 16     0   13   87 80     11 0   42 13   167
690859 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 KG 03 2017   grade_2 80.0 28.0 24.0   1.0 16.0     0.0   18.0   88.0 79.0     30.0   1.0     98.0   23.0   167.0 80 28 24   1 16     0   18   88 79     30 1   98 23   167
691015 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_2 135.0 0.0 1.0   3.0 0.0     0.0   3.0   77.0 65.0     0.0   0.0     47.0   26.0   142.0 135 0 1   3 0     0   3   77 65     0 0   47 26   142
691336 MN Chippewa 12 school 2721320 129 Independent Districts and Schools MONTEVIDEO PUBLIC SCHOOL DISTRICT 272132001073 10 RAMSEY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 01 03 2017   grade_2 82.0 2.0 18.0   2.0 0.0     1.0   3.0   57.0 51.0     14.0   0.0     53.0   25.0   108.0 82 2 18   2 0     1   3   57 51     14 0   53 25   108
691432 MN Cottonwood 17 school 2742780 177 Independent Districts and Schools WINDOM PUBLIC SCHOOL DISTRICT 274278001816 30 WINFAIR ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 03 2017   grade_2 56.0 0.0 18.0   0.0 2.0     1.0   1.0   47.0 31.0     16.0   0.0     41.0   9.0   78.0 56 0 18   0 2     1   1   47 31     16 0   41 9   78
694073 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384002540 510 LINWOOD MONROE ARTS PLUS LOWER Elementary School (Grades PK-6) Regular School No Elementary KG 03 2017   grade_2 28.0 17.0 9.0   0.0 24.0     0.0   2.0   41.0 39.0     36.0   1.0     56.0   10.0   80.0 28 17 9   0 24     0   2   41 39     36 1   56 10   80
694292 MN Saint Louis 69 school 2708910 695 Independent Districts and Schools CHISHOLM PUBLIC SCHOOL DISTRICT 270891000360 101 VAUGHAN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 03 2017   grade_2 54.0 2.0 0.0   5.0 0.0     0.0   0.0   27.0 34.0     0.0   0.0     29.0   7.0   61.0 54 2 0   5 0     0   0   27 34     0 0   29 7   61
694968 MN Waseca 81 school 2741880 829 Independent Districts and Schools WASECA PUBLIC SCHOOL DISTRICT 274188001747 20 HARTLEY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 03 2017   grade_2 103.0 5.0 10.0   0.0 0.0     0.0   7.0   60.0 65.0     6.0   0.0     46.0   18.0   125.0 103 5 10   0 0     0   7   60 65     6 0   46 18   125
694990 MN Washington 82 school 2712270 831 Independent Districts and Schools FOREST LAKE PUBLIC SCHOOL DISTRICT 271227000596 627 Forest View Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 03 2017   grade_2 87.0 3.0 7.0   0.0 2.0     0.0   9.0   60.0 48.0     7.0   0.0     37.0   16.0   108.0 87 3 7   0 2     0   9   60 48     7 0   37 16   108
695534 MN Fillmore 23 school 2700007 2137 Independent Districts and Schools KINGSLAND PUBLIC SCHOOL DISTRICT 270000701468 15 Kingsland Elementary School Elementary School (Grades PK-6) Regular School No Elementary PK 03 2017   grade_2 39.0 0.0 1.0   0.0 0.0     0.0   1.0   24.0 17.0     0.0   0.0     17.0   5.0   41.0 39 0 1   0 0     0   1   24 17     0 0   17 5   41
695610 MN Pope 61 school 2700019 2149 Independent Districts and Schools MINNEWASKA SCHOOL DISTRICT 270001903536 70 MINNEWASKA AREA ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 03 2017   grade_2 89.0 0.0 2.0   0.0 0.0     0.0   0.0   48.0 43.0         *         *   91.0 89 0 2   0 0     0   0   48 43                 91
695702 MN Todd 77 school 2733900 2170 Independent Districts and Schools STAPLES-MOTLEY SCHOOL DISTRICT 273390001643 30 Staples-Motley Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 03 2017   grade_2 59.0 0.0 4.0   1.0 1.0     0.0   4.0   39.0 30.0     0.0   4.0     41.0   14.0   69.0 59 0 4   1 1     0   4   39 30     0 4   41 14   69
695871 MN Lesueur 40 school 2718070 2397 Independent Districts and Schools LE SUEUR-HENDERSON SCHOOL DISTRICT 271807000045 10 PARK ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 03 2017   grade_2 68.0 2.0 13.0   0.0 0.0     0.0   4.0   51.0 36.0     5.0   1.0     30.0   9.0   87.0 68 2 13   0 0     0   4   51 36     5 1   30 9   87
696178 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_2 85.0 0.0 14.0   0.0 0.0     0.0   3.0   38.0 64.0     5.0   0.0     33.0   9.0   102.0 85 0 14   0 0     0   3   38 64     5 0   33 9   102
696263 MN Douglas 21 school 2700382 2908 Independent Districts and Schools BRANDON-EVANSVILLE PUBLIC SCHOOLS 270038204738 1 Brandon Elementary Elementary School (Grades PK-6) Regular School No Elementary PK 03 2017   grade_2 31.0 0.0 0.0   0.0 0.0     0.0   1.0   15.0 17.0     0.0   0.0     13.0   2.0   32.0 31 0 0   0 0     0   1   15 17     0 0   13 2   32
696279 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124001861 104 LAKE HARRIET LOWER ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 03 2017   grade_2 113.0 3.0 3.0   0.0 10.0     0.0   5.0   84.0 50.0     2.0   0.0     10.0   7.0   134.0 113 3 3   0 10     0   5   84 50     2 0   10 7   134
696496 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124004885 215 WEBSTER ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 03 2017   grade_2 8.0 8.0 4.0   0.0 1.0     0.0   5.0   11.0 15.0     4.0   3.0     20.0   9.0   26.0 8 8 4   0 1     0   5   11 15     4 3   20 9   26
696500 MN Hennepin 27 school 2721240 1 Special Districts and Schools Minneapolis Public School District 272124004883 216 FAIR Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 03 2017   grade_2 8.0 27.0 0.0   0.0 0.0     0.0   2.0   17.0 20.0     2.0   2.0         6.0   37.0 8 27 0   0 0     0   2   17 20     2 2     6   37
697220 MN Hennepin 27 school 2700288 4170 Charter Schools HIAWATHA ACADEMIES 270028804669 12 Hiawatha Leadership Academy-Northrop Elementary School (Grades PK-6) Regular School Yes Elementary KG 03 2017   grade_2 1.0 6.0 69.0   0.0 0.0     0.0   1.0   39.0 38.0     66.0   1.0         11.0   77.0 1 6 69   0 0     0   1   39 38     66 1     11   77
690560 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 2017   grade_2 12.0 0.0 2.0   0.0 0.0     0.0   0.0   9.0 5.0     0.0   0.0         5.0   14.0 12 0 2   0 0     0   0   9 5     0 0     5   14
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
690817 MN Anoka 2 school 2712420 14 Independent Districts and Schools FRIDLEY PUBLIC SCHOOL DISTRICT 271242000614 550 STEVENSON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2017   grade_2 46.0 35.0 11.0   2.0 8.0     0.0   5.0   51.0 56.0     17.0   3.0     75.0   11.0   107.0 46 35 11   2 8     0   5   51 56     17 3   75 11   107
690879 MN Becker 3 school 2710230 22 Independent Districts and Schools DETROIT LAKES PUBLIC SCHOOL DIST. 271023002268 60 ROOSEVELT ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2017   grade_2 87.0 2.0 9.0   15.0 0.0     0.0   9.0   58.0 64.0     2.0   5.0     70.0   20.0   122.0 87 2 9   15 0     0   9   58 64     2 5   70 20   122
691132 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_2 151.0 3.0 9.0   0.0 0.0     0.0   7.0   94.0 76.0     3.0   0.0     54.0   20.0   170.0 151 3 9   0 0     0   7   94 76     3 0   54 20   170
691314 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 2017   grade_2 4.0 0.0 1.0   80.0 0.0     0.0   5.0   47.0 43.0     0.0   1.0     76.0   15.0   90.0 4 0 1   80 0     0   5   47 43     0 1   76 15   90
691321 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 2017   grade_2 81.0 2.0 2.0   0.0 0.0     0.0   0.0   54.0 31.0     0.0   2.0     41.0   8.0   85.0 81 2 2   0 0     0   0   54 31     0 2   41 8   85
691346 MN Chisago 13 school 2723820 138 Independent Districts and Schools NORTH BRANCH PUBLIC SCHOOLS 272382003514 45 SUNRISE RIVER ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 04 2017   grade_2 175.0 0.0 3.0   0.0 4.0     0.0   11.0   101.0 92.0     3.0   0.0     61.0   27.0   193.0 175 0 3   0 4     0   11   101 92     3 0   61 27   193
691438 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_2 87.0 0.0 2.0   0.0 1.0     0.0   2.0   51.0 41.0         0.0     28.0   14.0   92.0 87 0 2   0 1     0   2   51 41       0   28 14   92
691444 MN Crow Wing 18 school 2706090 181 Independent Districts and Schools BRAINERD PUBLIC SCHOOL DISTRICT 270609000252 8 GARFIELD ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 04 2017   grade_2 76.0 0.0 1.0   0.0 0.0     0.0   3.0   34.0 46.0     0.0   0.0     40.0   18.0   80.0 76 0 1   0 0     0   3   34 46     0 0   40 18   80
691450 MN Crow Wing 18 school 2706090 181 Independent Districts and Schools BRAINERD PUBLIC SCHOOL DISTRICT 270609000254 9 HARRISON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 04 2017   grade_2 61.0 0.0 1.0   0.0 0.0     0.0   2.0   33.0 31.0     0.0   0.0     47.0   *   64.0 61 0 1   0 0     0   2   33 31     0 0   47     64
691456 MN Crow Wing 18 school 2706090 181 Independent Districts and Schools BRAINERD PUBLIC SCHOOL DISTRICT 270609000256 11 Lowell Elementary Elementary School (Grades PK-6) Regular School No Elementary KG 04 2017   grade_2 82.0 1.0 1.0   0.0 0.0     0.0   3.0   51.0 36.0     0.0   *     35.0   12.0   87.0 82 1 1   0 0     0   3   51 36     0     35 12   87
691462 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_2 107.0 6.0 1.0   0.0 1.0     0.0   3.0   63.0 55.0     0.0   1.0     68.0   28.0   118.0 107 6 1   0 1     0   3   63 55     0 1   68 28   118
691469 MN Crow Wing 18 school 2706090 181 Independent Districts and Schools BRAINERD PUBLIC SCHOOL DISTRICT 270609000257 15 NISSWA ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2017   grade_2 67.0 0.0 0.0   0.0 0.0     0.0   1.0   38.0 30.0     0.0   0.0         *   68.0 67 0 0   0 0     0   1   38 30     0 0         68
691485 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_2 107.0 4.0 0.0   1.0 0.0     0.0   0.0   65.0 47.0     0.0   2.0     38.0   11.0   112.0 107 4 0   1 0     0   0   65 47     0 2   38 11   112
691809 MN Dakota 19 school 2742270 197 Independent Districts and Schools WEST ST. PAUL-MENDOTA HTS.-EAGAN 274227001776 815 MORELAND ART/HEALTH SCIENCE MAGNET Elementary School (Grades PK-6) Regular School No Elementary KG 04 2017   grade_2 29.0 6.0 39.0   1.0 1.0     0.0   4.0   42.0 38.0     22.0   2.0     52.0   15.0   80.0 29 6 39   1 1     0   4   42 38     22 2   52 15   80
691815 MN Dakota 19 school 2742270 197 Independent Districts and Schools WEST ST. PAUL-MENDOTA HTS.-EAGAN 274227002202 816 MENDOTA ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2017   grade_2 67.0 3.0 11.0   1.0 2.0     0.0   3.0   55.0 32.0     4.0   0.0         9.0   87.0 67 3 11   1 2     0   3   55 32     4 0     9   87
691821 MN Dakota 19 school 2742270 197 Independent Districts and Schools WEST ST. PAUL-MENDOTA HTS.-EAGAN 274227001773 817 GARLOUGH ENVIRONMENTAL MAGNET Elementary School (Grades PK-6) Regular School No Elementary KG 04 2017   grade_2 32.0 12.0 32.0   0.0 2.0     1.0   7.0   47.0 39.0     30.0   0.0     46.0   9.0   86.0 32 12 32   0 2     1   7   47 39     30 0   46 9   86
691827 MN Dakota 19 school 2742270 197 Independent Districts and Schools WEST ST. PAUL-MENDOTA HTS.-EAGAN 274227001780 819 SOMERSET ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2017   grade_2 57.0 1.0 14.0   0.0 0.0     0.0   4.0   38.0 38.0     5.0   0.0         8.0   76.0 57 1 14   0 0     0   4   38 38     5 0     8   76
691833 MN Dakota 19 school 2742270 197 Independent Districts and Schools WEST ST. PAUL-MENDOTA HTS.-EAGAN 274227001778 820 PILOT KNOB STEM MAGNET SCHOOL Elementary School (Grades PK-6) Regular School No Elementary KG 04 2017   grade_2 31.0 23.0 3.0   1.0 9.0     0.0   9.0   36.0 40.0     14.0   0.0     29.0   5.0   76.0 31 23 3   1 9     0   9   36 40     14 0   29 5   76
691865 MN Dakota 19 school 2713530 200 Independent Districts and Schools HASTINGS PUBLIC SCHOOL DISTRICT 271353000695 609 KENNEDY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 04 2017   grade_2 79.0 4.0 5.0   1.0 0.0     0.0   8.0   43.0 54.0     0.0   1.0     35.0   8.0   97.0 79 4 5   1 0     0   8   43 54     0 1   35 8   97
691871 MN Dakota 19 school 2713530 200 Independent Districts and Schools HASTINGS PUBLIC SCHOOL DISTRICT 271353000696 610 PINECREST ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 04 2017   grade_2 103.0 1.0 2.0   2.0 0.0     0.0   9.0   51.0 66.0     2.0   0.0     36.0   11.0   117.0 103 1 2   2 0     0   9   51 66     2 0   36 11   117
691877 MN Dakota 19 school 2713530 200 Independent Districts and Schools HASTINGS PUBLIC SCHOOL DISTRICT 271353002239 612 CHRISTA MCAULIFFE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 04 2017   grade_2 77.0 4.0 7.0   0.0 3.0     0.0   6.0   44.0 53.0     3.0   1.0     26.0   17.0   97.0 77 4 7   0 3     0   6   44 53     3 1   26 17   97
691892 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_2 152.0 1.0 4.0   0.0 0.0     0.0   5.0   79.0 83.0     1.0   0.0     33.0   24.0   162.0 152 1 4   0 0     0   5   79 83     1 0   33 24   162
692045 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_2 86.0 2.0 4.0   0.0 1.0     0.0   0.0   48.0 45.0     0.0   1.0     19.0   7.0   93.0 86 2 4   0 1     0   0   48 45     0 1   19 7   93
692049 MN Goodhue 25 school 2730480 256 Independent Districts and Schools RED WING PUBLIC SCHOOL DISTRICT 273048001292 537 BURNSIDE ELEMENTARY. Elementary School (Grades PK-6) Regular School No Elementary 02 04 2017   grade_2 111.0 4.0 16.0   8.0 2.0     0.0   15.0   84.0 72.0     7.0   1.0     66.0   26.0   156.0 111 4 16   8 2     0   15   84 72     7 1   66 26   156
692340 MN Hennepin 27 school 2722920 277 Independent Districts and Schools WESTONKA PUBLIC SCHOOL DISTRICT 272292001113 615 SHIRLEY HILLS PRIMARY SCHOOL Elementary School (Grades PK-6) Regular School No Elementary PK 04 2017   grade_2 74.0 3.0 5.0   0.0 2.0     0.0   3.0   34.0 53.0     2.0   0.0     18.0   10.0   87.0 74 3 5   0 2     0   3   34 53     2 0   18 10   87
692346 MN Hennepin 27 school 2722920 277 Independent Districts and Schools WESTONKA PUBLIC SCHOOL DISTRICT 272292001110 616 HILLTOP PRIMARY SCHOOL Elementary School (Grades PK-6) Regular School No Elementary PK 04 2017   grade_2 70.0 0.0 1.0   0.0 0.0     0.0   3.0   39.0 35.0     1.0   0.0     11.0   8.0   74.0 70 0 1   0 0     0   3   39 35     1 0   11 8   74
692733 MN Houston 28 school 2717250 300 Independent Districts and Schools LA CRESCENT-HOKAH SCHOOL DISTRICT 271725000799 10 LA CRESCENT-HOKAH ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2017   grade_2 65.0 4.0 1.0   1.0 0.0     0.0   0.0   37.0 34.0     0.0   0.0     17.0   9.0   71.0 65 4 1   1 0     0   0   37 34     0 0   17 9   71
692763 MN Hubbard 29 school 2728080 309 Independent Districts and Schools PARK RAPIDS PUBLIC SCHOOL DISTRICT 272808001233 30 PARK RAPIDS AREA CENTURY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2017   grade_2 112.0 1.0 4.0   0.0 0.0     0.0   14.0   61.0 70.0         0.0     73.0   24.0   131.0 112 1 4   0 0     0   14   61 70       0   73 24   131
692780 MN Itasca 31 school 2709480 316 Independent Districts and Schools GREENWAY PUBLIC SCHOOL DISTRICT 270948000394 110 VANDYKE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2017   grade_2 65.0 0.0 2.0   10.0 0.0     0.0   5.0   44.0 38.0     0.0   1.0     54.0   30.0   82.0 65 0 2   10 0     0   5   44 38     0 1   54 30   82
692797 MN Itasca 31 school 2713170 318 Independent Districts and Schools GRAND RAPIDS PUBLIC SCHOOL DISTRICT 271317000661 110 COHASSET ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 04 2017   grade_2 39.0 0.0 2.0   2.0 0.0     0.0   5.0   23.0 25.0     0.0   0.0         7.0   48.0 39 0 2   2 0     0   5   23 25     0 0     7   48
692813 MN Itasca 31 school 2713170 318 Independent Districts and Schools GRAND RAPIDS PUBLIC SCHOOL DISTRICT 271317000662 120 FOREST LAKE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 04 2017   grade_2 66.0 0.0 1.0   1.0 0.0     1.0   8.0   41.0 36.0     0.0   0.0     35.0   17.0   77.0 66 0 1   1 0     1   8   41 36     0 0   35 17   77
692819 MN Itasca 31 school 2713170 318 Independent Districts and Schools GRAND RAPIDS PUBLIC SCHOOL DISTRICT 271317000907 125 MURPHY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 04 2017   grade_2 66.0 0.0 0.0   0.0 0.0     0.0   8.0   41.0 33.0     0.0   0.0     39.0   8.0   74.0 66 0 0   0 0     0   8   41 33     0 0   39 8   74
692825 MN Itasca 31 school 2713170 318 Independent Districts and Schools GRAND RAPIDS PUBLIC SCHOOL DISTRICT 271317000915 135 SOUTHWEST ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 04 2017   grade_2 75.0 0.0 0.0   1.0 0.0     0.0   2.0   45.0 33.0     0.0   0.0     34.0   15.0   78.0 75 0 0   1 0     0   2   45 33     0 0   34 15   78
692868 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_2 107.0 0.0 8.0   0.0 0.0     0.0   0.0   67.0 48.0     2.0   1.0     37.0   11.0   115.0 107 0 8   0 0     0   0   67 48     2 1   37 11   115
693064 MN Becker 3 school 2742120 435 Independent Districts and Schools WAUBUN-OGEMA-WHITE EARTH PUBLIC SCH 274212001754 20 OGEMA ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2017   grade_2 11.0 0.0 2.0   27.0 0.0     0.0   7.0   25.0 22.0     0.0   2.0     31.0   4.0   47.0 11 0 2   27 0     0   7   25 22     0 2   31 4   47
693110 MN Meeker 47 school 2718210 465 Independent Districts and Schools LITCHFIELD PUBLIC SCHOOL DISTRICT 271821000837 10 LAKE RIPLEY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 04 2017   grade_2 104.0 1.0 11.0   0.0 0.0     0.0   1.0   63.0 54.0     5.0   0.0     52.0   13.0   117.0 104 1 11   0 0     0   1   63 54     5 0   52 13   117
693117 MN Wright 86 school 2710060 466 Independent Districts and Schools DASSEL-COKATO PUBLIC SCHOOL DIST. 271006000426 1 COKATO ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2017   grade_2 102.0 1.0 3.0   0.0 1.0     0.0   4.0   62.0 49.0     4.0   0.0     42.0   18.0   111.0 102 1 3   0 1     0   4   62 49     4 0   42 18   111
693124 MN Meeker 47 school 2710060 466 Independent Districts and Schools DASSEL-COKATO PUBLIC SCHOOL DIST. 271006000427 3 DASSEL ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2017   grade_2 65.0 0.0 2.0   0.0 0.0     0.0   2.0   35.0 34.0     0.0   0.0     14.0   9.0   69.0 65 0 2   0 0     0   2   35 34     0 0   14 9   69
693214 MN Mower 50 school 2703450 492 Independent Districts and Schools AUSTIN PUBLIC SCHOOL DISTRICT 270345000149 10 BANFIELD ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 01 04 2017   grade_2 55.0 10.0 28.0   0.0 12.0     2.0   1.0   52.0 56.0     28.0   0.0     61.0   11.0   108.0 55 10 28   0 12     2   1   52 56     28 0   61 11   108
693219 MN Mower 50 school 2703450 492 Independent Districts and Schools AUSTIN PUBLIC SCHOOL DISTRICT 270345000153 40 NEVELN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 01 04 2017   grade_2 38.0 4.0 24.0   0.0 12.0     0.0   3.0   47.0 34.0         *         *   81.0 38 4 24   0 12     0   3   47 34                 81
693224 MN Mower 50 school 2703450 492 Independent Districts and Schools AUSTIN PUBLIC SCHOOL DISTRICT 270345002230 70 SOUTHGATE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 01 04 2017   grade_2 69.0 7.0 35.0   0.0 6.0     0.0   7.0   60.0 64.0     28.0   0.0     66.0   14.0   124.0 69 7 35   0 6     0   7   60 64     28 0   66 14   124
693229 MN Mower 50 school 2703450 492 Independent Districts and Schools AUSTIN PUBLIC SCHOOL DISTRICT 270345000156 80 SUMNER ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 01 04 2017   grade_2 17.0 12.0 31.0   0.0 13.0     0.0   9.0   39.0 43.0     33.0   0.0     70.0   10.0   82.0 17 12 31   0 13     0   9   39 43     33 0   70 10   82
693245 MN Mower 50 school 2713140 495 Independent Districts and Schools GRAND MEADOW PUBLIC SCHOOL DISTRICT 271314000659 10 GRAND MEADOW ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2017   grade_2 35.0 1.0 0.0   0.0 0.0     0.0   0.0   18.0 18.0     0.0   0.0     10.0   8.0   36.0 35 1 0   0 0     0   0   18 18     0 0   10 8   36
693286 MN Nicollet 52 school 2723580 507 Independent Districts and Schools NICOLLET PUBLIC SCHOOL DISTRICT 272358001160 10 NICOLLET ELEMENTARY SCHOOL Elementary School (Grades PK-6) Regular School No Elementary PK 04 2017   grade_2 33.0 0.0 1.0   0.0 0.0     0.0   0.0   19.0 15.0     0.0   0.0     2.0   4.0   34.0 33 0 1   0 0     0   0   19 15     0 0   2 4   34
693318 MN Nobles 53 school 2744160 518 Independent Districts and Schools WORTHINGTON PUBLIC SCHOOL DISTRICT 274416001836 1 PRAIRIE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2017   grade_2 51.0 18.0 151.0   0.0 27.0     0.0   3.0   131.0 119.0     126.0   2.0     202.0   22.0   250.0 51 18 151   0 27     0   3   131 119     126 2   202 22   250
693522 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_2 88.0 2.0 8.0   1.0 2.0     1.0   4.0   54.0 52.0     8.0   0.0     44.0   13.0   106.0 88 2 8   1 2     1   4   54 52     8 0   44 13   106
693949 MN Ramsey 62 school 2733840 625 Independent Districts and Schools ST. PAUL PUBLIC SCHOOL DISTRICT 273384001172 458 FARNSWORTH AEROSPACE LOWER Elementary School (Grades PK-6) Regular School No Elementary PK 04 2017   grade_2 10.0 4.0 7.0   0.0 73.0     0.0   2.0   60.0 36.0     62.0   0.0     75.0   6.0   96.0 10 4 7   0 73     0   2   60 36     62 0   75 6   96
694319 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_2 147.0 4.0 4.0   1.0 3.0     1.0   6.0   76.0 90.0     2.0   2.0     25.0   16.0   166.0 147 4 4   1 3     1   6   76 90     2 2   25 16   166
694458 MN Scott 70 school 2715750 717 Independent Districts and Schools JORDAN PUBLIC SCHOOL DISTRICT 271575001630 637 JORDAN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 04 2017   grade_2 124.0 3.0 14.0   0.0 0.0     0.0   1.0   79.0 63.0     9.0   0.0     33.0   26.0   142.0 124 3 14   0 0     0   1   79 63     9 0   33 26   142
694773 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_2 121.0 3.0 1.0   0.0 1.0     0.0   3.0   74.0 55.0     1.0   1.0     18.0   10.0   129.0 121 3 1   0 1     0   3   74 55     1 1   18 10   129
694779 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_2 135.0 3.0 3.0   0.0 2.0     0.0   5.0   76.0 72.0     2.0   2.0     21.0   21.0   148.0 135 3 3   0 2     0   5   76 72     2 2   21 21   148

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