Data source: Big Local News · About: Big Local

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

View and edit SQL

year

  • 2017 · 13,657
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
690562 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_4 16.0 0.0 1.0   0.0 0.0     0.0   1.0   11.0 7.0     0.0   0.0     9.0   3.0   18.0 16 0 1   0 0     0   1   11 7     0 0   9 3   18
690563 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   pk_12_total 86.0 0.0 5.0   0.0 0.0     0.0   5.0   46.0 50.0     0.0   0.0     61.0   30.0   96.0 86 0 5   0 0     0   5   46 50     0 0   61 30   96
691139 MN Carlton 9 school 2703690 91 Independent Districts and Schools BARNUM PUBLIC SCHOOL DISTRICT 270369000171 1 BARNUM ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   early_childhood_special_ed 15.0 0.0 1.0   0.0 0.0     0.0   0.0   14.0 2.0     0.0   0.0     3.0   *   16.0 15 0 1   0 0     0   0   14 2     0 0   3     16
691140 MN Carlton 9 school 2703690 91 Independent Districts and Schools BARNUM PUBLIC SCHOOL DISTRICT 270369000171 1 BARNUM ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   kindergarten 58.0 0.0 2.0   0.0 0.0     0.0   0.0   26.0 34.0     0.0   0.0     20.0   12.0   60.0 58 0 2   0 0     0   0   26 34     0 0   20 12   60
691141 MN Carlton 9 school 2703690 91 Independent Districts and Schools BARNUM PUBLIC SCHOOL DISTRICT 270369000171 1 BARNUM ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_1 57.0 0.0 1.0   0.0 0.0     0.0   2.0   34.0 26.0     0.0   0.0     15.0   10.0   60.0 57 0 1   0 0     0   2   34 26     0 0   15 10   60
691142 MN Carlton 9 school 2703690 91 Independent Districts and Schools BARNUM PUBLIC SCHOOL DISTRICT 270369000171 1 BARNUM ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_2 44.0 0.0 1.0   2.0 0.0     0.0   3.0   23.0 27.0     0.0   0.0     15.0   7.0   50.0 44 0 1   2 0     0   3   23 27     0 0   15 7   50
691143 MN Carlton 9 school 2703690 91 Independent Districts and Schools BARNUM PUBLIC SCHOOL DISTRICT 270369000171 1 BARNUM ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_3 59.0 0.0 1.0   0.0 0.0     0.0   3.0   30.0 33.0     0.0   0.0     26.0   7.0   63.0 59 0 1   0 0     0   3   30 33     0 0   26 7   63
691144 MN Carlton 9 school 2703690 91 Independent Districts and Schools BARNUM PUBLIC SCHOOL DISTRICT 270369000171 1 BARNUM ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_4 46.0 0.0 1.0   0.0 0.0     0.0   5.0   26.0 26.0     0.0   0.0     17.0   10.0   52.0 46 0 1   0 0     0   5   26 26     0 0   17 10   52
691145 MN Carlton 9 school 2703690 91 Independent Districts and Schools BARNUM PUBLIC SCHOOL DISTRICT 270369000171 1 BARNUM ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_5 58.0 0.0 2.0   1.0 0.0     0.0   6.0   39.0 28.0     0.0   0.0     18.0   11.0   67.0 58 0 2   1 0     0   6   39 28     0 0   18 11   67
691146 MN Carlton 9 school 2703690 91 Independent Districts and Schools BARNUM PUBLIC SCHOOL DISTRICT 270369000171 1 BARNUM ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_6 52.0 0.0 1.0   0.0 0.0     0.0   5.0   36.0 22.0     0.0   0.0     18.0   8.0   58.0 52 0 1   0 0     0   5   36 22     0 0   18 8   58
691147 MN Carlton 9 school 2703690 91 Independent Districts and Schools BARNUM PUBLIC SCHOOL DISTRICT 270369000171 1 BARNUM ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   pk_12_total 389.0 0.0 10.0   3.0 0.0     0.0   24.0   228.0 198.0     0.0   0.0     132.0   81.0   426.0 389 0 10   3 0     0   24   228 198     0 0   132 81   426
691198 MN Carlton 9 school 2744190 100 Independent Districts and Schools WRENSHALL PUBLIC SCHOOL DISTRICT 274419001842 1 WRENSHALL ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   early_childhood_special_ed 8.0 0.0 0.0   0.0 0.0     0.0   0.0   4.0 4.0         *         *   8.0 8 0 0   0 0     0   0   4 4                 8
691199 MN Carlton 9 school 2744190 100 Independent Districts and Schools WRENSHALL PUBLIC SCHOOL DISTRICT 274419001842 1 WRENSHALL ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   kindergarten 20.0 0.0 0.0   0.0 0.0     0.0   2.0   6.0 16.0         *         1.0   22.0 20 0 0   0 0     0   2   6 16             1   22
691200 MN Carlton 9 school 2744190 100 Independent Districts and Schools WRENSHALL PUBLIC SCHOOL DISTRICT 274419001842 1 WRENSHALL ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_1 29.0 0.0 0.0   0.0 0.0     0.0   1.0   13.0 17.0     0.0   0.0     17.0   2.0   30.0 29 0 0   0 0     0   1   13 17     0 0   17 2   30
691201 MN Carlton 9 school 2744190 100 Independent Districts and Schools WRENSHALL PUBLIC SCHOOL DISTRICT 274419001842 1 WRENSHALL ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_2 29.0 0.0 0.0   0.0 1.0     0.0   0.0   11.0 19.0     0.0   0.0     10.0   5.0   30.0 29 0 0   0 1     0   0   11 19     0 0   10 5   30
691202 MN Carlton 9 school 2744190 100 Independent Districts and Schools WRENSHALL PUBLIC SCHOOL DISTRICT 274419001842 1 WRENSHALL ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_3 26.0 0.0 0.0   0.0 0.0     0.0   1.0   13.0 14.0     0.0   0.0     19.0   2.0   27.0 26 0 0   0 0     0   1   13 14     0 0   19 2   27
691203 MN Carlton 9 school 2744190 100 Independent Districts and Schools WRENSHALL PUBLIC SCHOOL DISTRICT 274419001842 1 WRENSHALL ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_4 20.0 0.0 0.0   0.0 0.0     0.0   2.0   10.0 12.0     0.0   0.0     9.0   3.0   22.0 20 0 0   0 0     0   2   10 12     0 0   9 3   22
691204 MN Carlton 9 school 2744190 100 Independent Districts and Schools WRENSHALL PUBLIC SCHOOL DISTRICT 274419001842 1 WRENSHALL ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_5 29.0 0.0 0.0   0.0 0.0     0.0   2.0   21.0 10.0     0.0   0.0     8.0   7.0   31.0 29 0 0   0 0     0   2   21 10     0 0   8 7   31
691205 MN Carlton 9 school 2744190 100 Independent Districts and Schools WRENSHALL PUBLIC SCHOOL DISTRICT 274419001842 1 WRENSHALL ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_6 20.0 0.0 0.0   0.0 0.0     0.0   0.0   10.0 10.0     0.0   0.0     15.0   6.0   20.0 20 0 0   0 0     0   0   10 10     0 0   15 6   20
691206 MN Carlton 9 school 2744190 100 Independent Districts and Schools WRENSHALL PUBLIC SCHOOL DISTRICT 274419001842 1 WRENSHALL ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   pk_12_total 181.0 0.0 0.0   0.0 1.0     0.0   8.0   88.0 102.0     0.0   0.0     89.0   34.0   190.0 181 0 0   0 1     0   8   88 102     0 0   89 34   190
691967 MN Fillmore 23 school 2718540 238 Independent Districts and Schools MABEL-CANTON PUBLIC SCHOOL DIST. 271854000857 1 MABEL-CANTON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   early_childhood_special_ed 2.0 0.0 0.0   0.0 0.0     0.0   0.0   0.0 2.0         *         *   2.0 2 0 0   0 0     0   0   0 2                 2
691968 MN Fillmore 23 school 2718540 238 Independent Districts and Schools MABEL-CANTON PUBLIC SCHOOL DIST. 271854000857 1 MABEL-CANTON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   kindergarten 31.0 0.0 1.0   0.0 0.0     0.0   0.0   15.0 17.0         *     6.0   2.0   32.0 31 0 1   0 0     0   0   15 17           6 2   32
691969 MN Fillmore 23 school 2718540 238 Independent Districts and Schools MABEL-CANTON PUBLIC SCHOOL DIST. 271854000857 1 MABEL-CANTON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_1 18.0 0.0 2.0   0.0 0.0     0.0   0.0   15.0 5.0     1.0   0.0     8.0   4.0   20.0 18 0 2   0 0     0   0   15 5     1 0   8 4   20
691970 MN Fillmore 23 school 2718540 238 Independent Districts and Schools MABEL-CANTON PUBLIC SCHOOL DIST. 271854000857 1 MABEL-CANTON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_2 15.0 1.0 0.0   0.0 0.0     0.0   0.0   10.0 6.0     0.0   0.0     7.0   1.0   16.0 15 1 0   0 0     0   0   10 6     0 0   7 1   16
691971 MN Fillmore 23 school 2718540 238 Independent Districts and Schools MABEL-CANTON PUBLIC SCHOOL DIST. 271854000857 1 MABEL-CANTON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_3 13.0 0.0 2.0   0.0 0.0     0.0   0.0   12.0 3.0     1.0   0.0     5.0   1.0   15.0 13 0 2   0 0     0   0   12 3     1 0   5 1   15
691972 MN Fillmore 23 school 2718540 238 Independent Districts and Schools MABEL-CANTON PUBLIC SCHOOL DIST. 271854000857 1 MABEL-CANTON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_4 27.0 0.0 1.0   0.0 0.0     0.0   1.0   14.0 15.0     1.0   0.0     8.0   4.0   29.0 27 0 1   0 0     0   1   14 15     1 0   8 4   29
691973 MN Fillmore 23 school 2718540 238 Independent Districts and Schools MABEL-CANTON PUBLIC SCHOOL DIST. 271854000857 1 MABEL-CANTON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_5 11.0 0.0 0.0   0.0 0.0     0.0   0.0   8.0 3.0     0.0   0.0         1.0   11.0 11 0 0   0 0     0   0   8 3     0 0     1   11
691974 MN Fillmore 23 school 2718540 238 Independent Districts and Schools MABEL-CANTON PUBLIC SCHOOL DIST. 271854000857 1 MABEL-CANTON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_6 17.0 0.0 1.0   0.0 0.0     0.0   0.0   11.0 7.0     0.0   0.0     7.0   4.0   18.0 17 0 1   0 0     0   0   11 7     0 0   7 4   18
691975 MN Fillmore 23 school 2718540 238 Independent Districts and Schools MABEL-CANTON PUBLIC SCHOOL DIST. 271854000857 1 MABEL-CANTON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   pk_12_total 134.0 1.0 7.0   0.0 0.0     0.0   1.0   85.0 58.0     4.0   0.0     44.0   19.0   143.0 134 1 7   0 0     0   1   85 58     4 0   44 19   143
691976 MN Fillmore 23 school 2728290 239 Independent Districts and Schools RUSHFORD-PETERSON PUBLIC SCHOOLS 272829001407 1 RUSHFORD-PETERSON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   early_childhood_special_ed 4.0 0.0 0.0   0.0 0.0     0.0   0.0   4.0 0.0         *         *   4.0 4 0 0   0 0     0   0   4 0                 4
691977 MN Fillmore 23 school 2728290 239 Independent Districts and Schools RUSHFORD-PETERSON PUBLIC SCHOOLS 272829001407 1 RUSHFORD-PETERSON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   kindergarten 39.0 0.0 0.0   0.0 0.0     0.0   3.0   24.0 18.0     0.0   *     17.0   3.0   42.0 39 0 0   0 0     0   3   24 18     0     17 3   42
691978 MN Fillmore 23 school 2728290 239 Independent Districts and Schools RUSHFORD-PETERSON PUBLIC SCHOOLS 272829001407 1 RUSHFORD-PETERSON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_1 53.0 0.0 0.0   0.0 0.0     0.0   0.0   30.0 23.0     0.0   0.0         5.0   53.0 53 0 0   0 0     0   0   30 23     0 0     5   53
691979 MN Fillmore 23 school 2728290 239 Independent Districts and Schools RUSHFORD-PETERSON PUBLIC SCHOOLS 272829001407 1 RUSHFORD-PETERSON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_2 53.0 0.0 1.0   0.0 0.0     0.0   1.0   33.0 22.0     0.0   0.0     25.0   8.0   55.0 53 0 1   0 0     0   1   33 22     0 0   25 8   55
691980 MN Fillmore 23 school 2728290 239 Independent Districts and Schools RUSHFORD-PETERSON PUBLIC SCHOOLS 272829001407 1 RUSHFORD-PETERSON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_3 60.0 0.0 0.0   0.0 0.0     0.0   0.0   24.0 36.0     0.0   0.0     23.0   6.0   60.0 60 0 0   0 0     0   0   24 36     0 0   23 6   60
691981 MN Fillmore 23 school 2728290 239 Independent Districts and Schools RUSHFORD-PETERSON PUBLIC SCHOOLS 272829001407 1 RUSHFORD-PETERSON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_4 44.0 0.0 0.0   0.0 0.0     0.0   1.0   25.0 20.0     0.0   0.0     17.0   4.0   45.0 44 0 0   0 0     0   1   25 20     0 0   17 4   45
691982 MN Fillmore 23 school 2728290 239 Independent Districts and Schools RUSHFORD-PETERSON PUBLIC SCHOOLS 272829001407 1 RUSHFORD-PETERSON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_5 47.0 0.0 1.0   0.0 0.0     0.0   0.0   23.0 25.0         0.0     15.0   3.0   48.0 47 0 1   0 0     0   0   23 25       0   15 3   48
691983 MN Fillmore 23 school 2728290 239 Independent Districts and Schools RUSHFORD-PETERSON PUBLIC SCHOOLS 272829001407 1 RUSHFORD-PETERSON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   pk_12_total 300.0 0.0 2.0   0.0 0.0     0.0   5.0   163.0 144.0     1.0   0.0     111.0   33.0   307.0 300 0 2   0 0     0   5   163 144     1 0   111 33   307
692025 MN Goodhue 25 school 2707500 252 Independent Districts and Schools CANNON FALLS PUBLIC SCHOOL DISTRICT 270750000323 1 CANNON FALLS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   early_childhood_special_ed 16.0 0.0 1.0   0.0 0.0     0.0   0.0   11.0 6.0     0.0   0.0     2.0   *   17.0 16 0 1   0 0     0   0   11 6     0 0   2     17
692026 MN Goodhue 25 school 2707500 252 Independent Districts and Schools CANNON FALLS PUBLIC SCHOOL DISTRICT 270750000323 1 CANNON FALLS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   kindergarten 71.0 0.0 1.0   1.0 0.0     0.0   3.0   35.0 41.0     0.0   0.0     16.0   4.0   76.0 71 0 1   1 0     0   3   35 41     0 0   16 4   76
692027 MN Goodhue 25 school 2707500 252 Independent Districts and Schools CANNON FALLS PUBLIC SCHOOL DISTRICT 270750000323 1 CANNON FALLS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_1 80.0 1.0 2.0   0.0 0.0     0.0   1.0   50.0 34.0     0.0   0.0     24.0   9.0   84.0 80 1 2   0 0     0   1   50 34     0 0   24 9   84
692028 MN Goodhue 25 school 2707500 252 Independent Districts and Schools CANNON FALLS PUBLIC SCHOOL DISTRICT 270750000323 1 CANNON FALLS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_2 80.0 0.0 0.0   0.0 3.0     0.0   3.0   40.0 46.0     3.0   0.0     21.0   3.0   86.0 80 0 0   0 3     0   3   40 46     3 0   21 3   86
692029 MN Goodhue 25 school 2707500 252 Independent Districts and Schools CANNON FALLS PUBLIC SCHOOL DISTRICT 270750000323 1 CANNON FALLS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_3 78.0 0.0 0.0   0.0 2.0     0.0   4.0   43.0 41.0     2.0   0.0     26.0   10.0   84.0 78 0 0   0 2     0   4   43 41     2 0   26 10   84
692030 MN Goodhue 25 school 2707500 252 Independent Districts and Schools CANNON FALLS PUBLIC SCHOOL DISTRICT 270750000323 1 CANNON FALLS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_4 85.0 0.0 3.0   1.0 0.0     0.0   4.0   46.0 47.0     2.0   1.0     33.0   12.0   93.0 85 0 3   1 0     0   4   46 47     2 1   33 12   93
692031 MN Goodhue 25 school 2707500 252 Independent Districts and Schools CANNON FALLS PUBLIC SCHOOL DISTRICT 270750000323 1 CANNON FALLS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_5 73.0 0.0 2.0   1.0 1.0     0.0   6.0   40.0 43.0     2.0   0.0     33.0   9.0   83.0 73 0 2   1 1     0   6   40 43     2 0   33 9   83
692032 MN Goodhue 25 school 2707500 252 Independent Districts and Schools CANNON FALLS PUBLIC SCHOOL DISTRICT 270750000323 1 CANNON FALLS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   pk_12_total 483.0 1.0 9.0   3.0 6.0     0.0   21.0   265.0 258.0     9.0   1.0     155.0   64.0   523.0 483 1 9   3 6     0   21   265 258     9 1   155 64   523
692033 MN Goodhue 25 school 2712900 253 Independent Districts and Schools GOODHUE PUBLIC SCHOOL DISTRICT 271290000647 1 GOODHUE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   early_childhood_special_ed 5.0 0.0 1.0   0.0 0.0     0.0   0.0   5.0 1.0         *         *   6.0 5 0 1   0 0     0   0   5 1                 6
692034 MN Goodhue 25 school 2712900 253 Independent Districts and Schools GOODHUE PUBLIC SCHOOL DISTRICT 271290000647 1 GOODHUE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   kindergarten 24.0 0.0 2.0   0.0 0.0     0.0   0.0   17.0 9.0         *         4.0   26.0 24 0 2   0 0     0   0   17 9             4   26
692035 MN Goodhue 25 school 2712900 253 Independent Districts and Schools GOODHUE PUBLIC SCHOOL DISTRICT 271290000647 1 GOODHUE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_1 43.0 0.0 5.0   0.0 0.0     0.0   1.0   23.0 26.0     1.0   0.0     9.0   1.0   49.0 43 0 5   0 0     0   1   23 26     1 0   9 1   49
692036 MN Goodhue 25 school 2712900 253 Independent Districts and Schools GOODHUE PUBLIC SCHOOL DISTRICT 271290000647 1 GOODHUE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_2 50.0 0.0 4.0   0.0 0.0     0.0   0.0   24.0 30.0     3.0   0.0     10.0   3.0   54.0 50 0 4   0 0     0   0   24 30     3 0   10 3   54
692037 MN Goodhue 25 school 2712900 253 Independent Districts and Schools GOODHUE PUBLIC SCHOOL DISTRICT 271290000647 1 GOODHUE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_3 39.0 0.0 6.0   0.0 0.0     0.0   0.0   20.0 25.0     3.0   0.0     8.0   5.0   45.0 39 0 6   0 0     0   0   20 25     3 0   8 5   45
692038 MN Goodhue 25 school 2712900 253 Independent Districts and Schools GOODHUE PUBLIC SCHOOL DISTRICT 271290000647 1 GOODHUE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_4 51.0 0.0 4.0   0.0 0.0     0.0   0.0   22.0 33.0     4.0   0.0     14.0   5.0   55.0 51 0 4   0 0     0   0   22 33     4 0   14 5   55
692039 MN Goodhue 25 school 2712900 253 Independent Districts and Schools GOODHUE PUBLIC SCHOOL DISTRICT 271290000647 1 GOODHUE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_5 39.0 0.0 6.0   0.0 0.0     0.0   0.0   26.0 19.0     1.0   0.0     8.0   4.0   45.0 39 0 6   0 0     0   0   26 19     1 0   8 4   45
692040 MN Goodhue 25 school 2712900 253 Independent Districts and Schools GOODHUE PUBLIC SCHOOL DISTRICT 271290000647 1 GOODHUE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_6 44.0 0.0 6.0   0.0 0.0     0.0   0.0   27.0 23.0     5.0   0.0     12.0   7.0   50.0 44 0 6   0 0     0   0   27 23     5 0   12 7   50
692041 MN Goodhue 25 school 2712900 253 Independent Districts and Schools GOODHUE PUBLIC SCHOOL DISTRICT 271290000647 1 GOODHUE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   pk_12_total 295.0 0.0 34.0   0.0 0.0     0.0   1.0   164.0 166.0     18.0   0.0     65.0   35.0   330.0 295 0 34   0 0     0   1   164 166     18 0   65 35   330
692065 MN Grant 26 school 2713890 264 Independent Districts and Schools HERMAN-NORCROSS SCHOOL DISTRICT 271389000713 1 HERMAN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   early_childhood_special_ed 2.0 0.0 0.0   0.0 0.0     0.0   0.0   2.0 0.0         *         *   2.0 2 0 0   0 0     0   0   2 0                 2
692066 MN Grant 26 school 2713890 264 Independent Districts and Schools HERMAN-NORCROSS SCHOOL DISTRICT 271389000713 1 HERMAN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   kindergarten 5.0 1.0 1.0   0.0 0.0     0.0   3.0   7.0 3.0     0.0   0.0     6.0   5.0   10.0 5 1 1   0 0     0   3   7 3     0 0   6 5   10
692067 MN Grant 26 school 2713890 264 Independent Districts and Schools HERMAN-NORCROSS SCHOOL DISTRICT 271389000713 1 HERMAN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_1 10.0 0.0 1.0   1.0 0.0     0.0   0.0   6.0 6.0     0.0   0.0     5.0   1.0   12.0 10 0 1   1 0     0   0   6 6     0 0   5 1   12
692068 MN Grant 26 school 2713890 264 Independent Districts and Schools HERMAN-NORCROSS SCHOOL DISTRICT 271389000713 1 HERMAN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_2 12.0 0.0 0.0   0.0 0.0     0.0   0.0   7.0 5.0     0.0   0.0     4.0   2.0   12.0 12 0 0   0 0     0   0   7 5     0 0   4 2   12
692069 MN Grant 26 school 2713890 264 Independent Districts and Schools HERMAN-NORCROSS SCHOOL DISTRICT 271389000713 1 HERMAN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_3 8.0 0.0 0.0   0.0 0.0     0.0   1.0   4.0 5.0         *         *   9.0 8 0 0   0 0     0   1   4 5                 9
692070 MN Grant 26 school 2713890 264 Independent Districts and Schools HERMAN-NORCROSS SCHOOL DISTRICT 271389000713 1 HERMAN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_4 5.0 0.0 0.0   0.0 0.0     0.0   2.0   2.0 5.0         *         *   7.0 5 0 0   0 0     0   2   2 5                 7
692071 MN Grant 26 school 2713890 264 Independent Districts and Schools HERMAN-NORCROSS SCHOOL DISTRICT 271389000713 1 HERMAN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_5 9.0 0.0 0.0   0.0 0.0     0.0   1.0   6.0 4.0     0.0   0.0     3.0   1.0   10.0 9 0 0   0 0     0   1   6 4     0 0   3 1   10
692072 MN Grant 26 school 2713890 264 Independent Districts and Schools HERMAN-NORCROSS SCHOOL DISTRICT 271389000713 1 HERMAN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_6 4.0 0.0 0.0   0.0 0.0     0.0   0.0   2.0 2.0         *         *   4.0 4 0 0   0 0     0   0   2 2                 4
692073 MN Grant 26 school 2713890 264 Independent Districts and Schools HERMAN-NORCROSS SCHOOL DISTRICT 271389000713 1 HERMAN ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   pk_12_total 55.0 1.0 2.0   1.0 0.0     0.0   7.0   36.0 30.0     0.0   0.0     26.0   15.0   66.0 55 1 2   1 0     0   7   36 30     0 0   26 15   66
693012 MN Lyon 42 school 2721270 414 Independent Districts and Schools MINNEOTA PUBLIC SCHOOL DISTRICT 272127001067 1 MINNEOTA ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   early_childhood_special_ed 3.0 0.0 0.0   0.0 0.0     0.0   1.0   2.0 2.0         *         *   4.0 3 0 0   0 0     0   1   2 2                 4
693013 MN Lyon 42 school 2721270 414 Independent Districts and Schools MINNEOTA PUBLIC SCHOOL DISTRICT 272127001067 1 MINNEOTA ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   kindergarten 23.0 0.0 2.0   0.0 0.0     0.0   1.0   20.0 6.0     0.0   *     9.0   4.0   26.0 23 0 2   0 0     0   1   20 6     0     9 4   26
693014 MN Lyon 42 school 2721270 414 Independent Districts and Schools MINNEOTA PUBLIC SCHOOL DISTRICT 272127001067 1 MINNEOTA ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_1 25.0 0.0 5.0   0.0 0.0     0.0   1.0   18.0 13.0     3.0   0.0     9.0   4.0   31.0 25 0 5   0 0     0   1   18 13     3 0   9 4   31
693015 MN Lyon 42 school 2721270 414 Independent Districts and Schools MINNEOTA PUBLIC SCHOOL DISTRICT 272127001067 1 MINNEOTA ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_2 28.0 0.0 4.0   0.0 0.0     0.0   0.0   15.0 17.0     4.0   0.0     10.0   2.0   32.0 28 0 4   0 0     0   0   15 17     4 0   10 2   32
693016 MN Lyon 42 school 2721270 414 Independent Districts and Schools MINNEOTA PUBLIC SCHOOL DISTRICT 272127001067 1 MINNEOTA ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_3 26.0 0.0 8.0   0.0 0.0     0.0   2.0   24.0 12.0     4.0   0.0     21.0   3.0   36.0 26 0 8   0 0     0   2   24 12     4 0   21 3   36
693017 MN Lyon 42 school 2721270 414 Independent Districts and Schools MINNEOTA PUBLIC SCHOOL DISTRICT 272127001067 1 MINNEOTA ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_4 30.0 0.0 1.0   0.0 0.0     0.0   0.0   15.0 16.0         0.0         7.0   31.0 30 0 1   0 0     0   0   15 16       0     7   31
693018 MN Lyon 42 school 2721270 414 Independent Districts and Schools MINNEOTA PUBLIC SCHOOL DISTRICT 272127001067 1 MINNEOTA ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_5 26.0 0.0 3.0   0.0 1.0     0.0   2.0   17.0 15.0     2.0   0.0     20.0   7.0   32.0 26 0 3   0 1     0   2   17 15     2 0   20 7   32
693019 MN Lyon 42 school 2721270 414 Independent Districts and Schools MINNEOTA PUBLIC SCHOOL DISTRICT 272127001067 1 MINNEOTA ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_6 24.0 0.0 4.0   0.0 0.0     0.0   0.0   13.0 15.0     4.0   0.0     10.0   0.0   28.0 24 0 4   0 0     0   0   13 15     4 0   10 0   28
693020 MN Lyon 42 school 2721270 414 Independent Districts and Schools MINNEOTA PUBLIC SCHOOL DISTRICT 272127001067 1 MINNEOTA ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   pk_12_total 185.0 0.0 27.0   0.0 1.0     0.0   7.0   124.0 96.0     18.0   0.0     88.0   31.0   220.0 185 0 27   0 1     0   7   124 96     18 0   88 31   220
693078 MN Marshall 45 school 2718920 447 Independent Districts and Schools GRYGLA PUBLIC SCHOOL DISTRICT 271892000896 1 GRYGLA ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   early_childhood_special_ed 3.0 0.0 0.0   0.0 1.0     0.0   0.0   4.0 0.0         *         *   4.0 3 0 0   0 1     0   0   4 0                 4
693079 MN Marshall 45 school 2718920 447 Independent Districts and Schools GRYGLA PUBLIC SCHOOL DISTRICT 271892000896 1 GRYGLA ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   kindergarten 14.0 0.0 0.0   0.0 1.0     0.0   0.0   4.0 11.0     0.0   0.0     8.0   1.0   15.0 14 0 0   0 1     0   0   4 11     0 0   8 1   15
693080 MN Marshall 45 school 2718920 447 Independent Districts and Schools GRYGLA PUBLIC SCHOOL DISTRICT 271892000896 1 GRYGLA ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_1 7.0 0.0 1.0   0.0 0.0     0.0   0.0   5.0 3.0         *         *   8.0 7 0 1   0 0     0   0   5 3                 8
693081 MN Marshall 45 school 2718920 447 Independent Districts and Schools GRYGLA PUBLIC SCHOOL DISTRICT 271892000896 1 GRYGLA ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_2 13.0 0.0 1.0   0.0 0.0     0.0   1.0   9.0 6.0     0.0   0.0     8.0   1.0   15.0 13 0 1   0 0     0   1   9 6     0 0   8 1   15
693082 MN Marshall 45 school 2718920 447 Independent Districts and Schools GRYGLA PUBLIC SCHOOL DISTRICT 271892000896 1 GRYGLA ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_3 9.0 0.0 0.0   0.0 0.0     0.0   0.0   3.0 6.0         *         *   9.0 9 0 0   0 0     0   0   3 6                 9
693083 MN Marshall 45 school 2718920 447 Independent Districts and Schools GRYGLA PUBLIC SCHOOL DISTRICT 271892000896 1 GRYGLA ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_4 13.0 0.0 0.0   0.0 0.0     0.0   0.0   5.0 8.0     0.0   0.0     4.0   1.0   13.0 13 0 0   0 0     0   0   5 8     0 0   4 1   13
693084 MN Marshall 45 school 2718920 447 Independent Districts and Schools GRYGLA PUBLIC SCHOOL DISTRICT 271892000896 1 GRYGLA ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_5 10.0 0.0 1.0   0.0 0.0     0.0   0.0   7.0 4.0     0.0   0.0     7.0   0.0   11.0 10 0 1   0 0     0   0   7 4     0 0   7 0   11
693085 MN Marshall 45 school 2718920 447 Independent Districts and Schools GRYGLA PUBLIC SCHOOL DISTRICT 271892000896 1 GRYGLA ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_6 10.0 0.0 0.0   0.0 0.0     0.0   0.0   6.0 4.0     0.0   0.0     3.0   4.0   10.0 10 0 0   0 0     0   0   6 4     0 0   3 4   10
693086 MN Marshall 45 school 2718920 447 Independent Districts and Schools GRYGLA PUBLIC SCHOOL DISTRICT 271892000896 1 GRYGLA ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   pk_12_total 79.0 0.0 3.0   0.0 2.0     0.0   1.0   43.0 42.0     0.0   0.0     35.0   12.0   85.0 79 0 3   0 2     0   1   43 42     0 0   35 12   85
693114 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   early_childhood_special_ed 21.0 0.0 2.0   0.0 0.0     0.0   0.0   16.0 7.0     0.0   0.0     6.0   *   23.0 21 0 2   0 0     0   0   16 7     0 0   6     23
693115 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   kindergarten 89.0 0.0 1.0   0.0 1.0     0.0   3.0   43.0 51.0     1.0   0.0     26.0   12.0   94.0 89 0 1   0 1     0   3   43 51     1 0   26 12   94
693116 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_1 90.0 0.0 6.0   0.0 0.0     0.0   4.0   48.0 52.0     1.0   0.0     23.0   14.0   100.0 90 0 6   0 0     0   4   48 52     1 0   23 14   100
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
693118 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_3 79.0 1.0 6.0   0.0 2.0     0.0   0.0   45.0 43.0     3.0   0.0     20.0   11.0   88.0 79 1 6   0 2     0   0   45 43     3 0   20 11   88
693119 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_4 106.0 0.0 3.0   0.0 1.0     0.0   2.0   52.0 60.0     1.0   0.0     30.0   13.0   112.0 106 0 3   0 1     0   2   52 60     1 0   30 13   112
693120 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   pk_12_total 487.0 2.0 21.0   0.0 5.0     0.0   13.0   266.0 262.0     10.0   0.0     147.0   91.0   528.0 487 2 21   0 5     0   13   266 262     10 0   147 91   528
693138 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   early_childhood_special_ed 54.0 0.0 2.0   3.0 0.0     0.0   0.0   48.0 11.0     0.0   0.0         *   59.0 54 0 2   3 0     0   0   48 11     0 0         59
693139 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   kindergarten 202.0 0.0 11.0   1.0 0.0     0.0   4.0   116.0 102.0     0.0   2.0     70.0   32.0   218.0 202 0 11   1 0     0   4   116 102     0 2   70 32   218
693140 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_1 211.0 1.0 6.0   2.0 0.0     0.0   3.0   114.0 109.0         *         *   223.0 211 1 6   2 0     0   3   114 109                 223
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
693142 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   pk_12_total 694.0 2.0 26.0   9.0 3.0     0.0   12.0   401.0 345.0     3.0   3.0     246.0   141.0   746.0 694 2 26   9 3     0   12   401 345     3 3   246 141   746
693316 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   kindergarten 70.0 22.0 128.0   0.0 32.0     0.0   6.0   115.0 143.0     156.0   0.0     184.0   22.0   258.0 70 22 128   0 32     0   6   115 143     156 0   184 22   258
693317 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_1 48.0 15.0 139.0   1.0 23.0     0.0   5.0   121.0 110.0     130.0   1.0     176.0   20.0   231.0 48 15 139   1 23     0   5   121 110     130 1   176 20   231
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
693319 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_3 52.0 9.0 144.0   0.0 31.0     0.0   6.0   120.0 122.0     119.0   0.0     188.0   33.0   242.0 52 9 144   0 31     0   6   120 122     119 0   188 33   242
693320 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_4 57.0 17.0 126.0   0.0 24.0     0.0   5.0   107.0 122.0     85.0   0.0     177.0   28.0   229.0 57 17 126   0 24     0   5   107 122     85 0   177 28   229
693321 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   pk_12_total 278.0 81.0 688.0   1.0 137.0     0.0   25.0   594.0 616.0     616.0   3.0     927.0   125.0   1210.0 278 81 688   1 137     0   25   594 616     616 3   927 125   1210
693624 MN Polk 60 school 2712180 600 Independent Districts and Schools FISHER PUBLIC SCHOOL DISTRICT 271218000587 1 FISHER ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   early_childhood_special_ed 2.0 0.0 0.0   0.0 0.0     0.0   0.0   0.0 2.0         *         *   2.0 2 0 0   0 0     0   0   0 2                 2

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