enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

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
694760 694760 MN Stearns 73 school 2702930 745 Independent Districts and Schools ALBANY PUBLIC SCHOOL DISTRICT 270293000062 10 ALBANY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 01 06 2017   grade_5 70.0 0.0 4.0   0.0 0.0     0.0   2.0   34.0 42.0     4.0   1.0     23.0   11.0   76.0 70 0 4   0 0     0   2   34 42     4 1   23 11   76
694761 694761 MN Stearns 73 school 2702930 745 Independent Districts and Schools ALBANY PUBLIC SCHOOL DISTRICT 270293000062 10 ALBANY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 01 06 2017   grade_6 61.0 0.0 5.0   0.0 0.0     0.0   1.0   30.0 37.0     2.0   0.0     19.0   13.0   67.0 61 0 5   0 0     0   1   30 37     2 0   19 13   67
694762 694762 MN Stearns 73 school 2702930 745 Independent Districts and Schools ALBANY PUBLIC SCHOOL DISTRICT 270293000062 10 ALBANY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary 01 06 2017   pk_12_total 446.0 0.0 19.0   0.0 0.0     0.0   8.0   232.0 241.0     13.0   3.0     122.0   72.0   473.0 446 0 19   0 0     0   8   232 241     13 3   122 72   473
694763 694763 MN Stearns 73 school 2702930 745 Independent Districts and Schools ALBANY PUBLIC SCHOOL DISTRICT 270293000065 30 AVON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   kindergarten 124.0 0.0 0.0   0.0 0.0     0.0   2.0   65.0 61.0     0.0   0.0     23.0   19.0   126.0 124 0 0   0 0     0   2   65 61     0 0   23 19   126
694764 694764 MN Stearns 73 school 2702930 745 Independent Districts and Schools ALBANY PUBLIC SCHOOL DISTRICT 270293000065 30 AVON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_1 54.0 1.0 0.0   0.0 0.0     0.0   2.0   23.0 34.0     0.0   0.0     8.0   17.0   57.0 54 1 0   0 0     0   2   23 34     0 0   8 17   57
694765 694765 MN Stearns 73 school 2702930 745 Independent Districts and Schools ALBANY PUBLIC SCHOOL DISTRICT 270293000065 30 AVON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_2 47.0 1.0 0.0   0.0 0.0     0.0   1.0   28.0 21.0     0.0   0.0     11.0   6.0   49.0 47 1 0   0 0     0   1   28 21     0 0   11 6   49
694766 694766 MN Stearns 73 school 2702930 745 Independent Districts and Schools ALBANY PUBLIC SCHOOL DISTRICT 270293000065 30 AVON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_3 56.0 0.0 2.0   0.0 0.0     0.0   2.0   27.0 33.0     0.0   0.0     9.0   8.0   60.0 56 0 2   0 0     0   2   27 33     0 0   9 8   60
694767 694767 MN Stearns 73 school 2702930 745 Independent Districts and Schools ALBANY PUBLIC SCHOOL DISTRICT 270293000065 30 AVON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_4 51.0 0.0 3.0   0.0 0.0     0.0   1.0   26.0 29.0     0.0   0.0     7.0   16.0   55.0 51 0 3   0 0     0   1   26 29     0 0   7 16   55
694768 694768 MN Stearns 73 school 2702930 745 Independent Districts and Schools ALBANY PUBLIC SCHOOL DISTRICT 270293000065 30 AVON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_5 35.0 0.0 0.0   0.0 0.0     0.0   1.0   21.0 15.0     0.0   0.0     6.0   6.0   36.0 35 0 0   0 0     0   1   21 15     0 0   6 6   36
694769 694769 MN Stearns 73 school 2702930 745 Independent Districts and Schools ALBANY PUBLIC SCHOOL DISTRICT 270293000065 30 AVON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_6 48.0 0.0 1.0   0.0 0.0     0.0   0.0   21.0 28.0     0.0   0.0     9.0   7.0   49.0 48 0 1   0 0     0   0   21 28     0 0   9 7   49
694770 694770 MN Stearns 73 school 2702930 745 Independent Districts and Schools ALBANY PUBLIC SCHOOL DISTRICT 270293000065 30 AVON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   pk_12_total 415.0 2.0 6.0   0.0 0.0     0.0   9.0   211.0 221.0     0.0   0.0     73.0   79.0   432.0 415 2 6   0 0     0   9   211 221     0 0   73 79   432
699278 699278 MN Stearns 73 school 2702930 745 Independent Districts and Schools ALBANY PUBLIC SCHOOL DISTRICT 270293000064 60 ALBANY SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 09 12 2017   grade_9 114.0 2.0 2.0   0.0 1.0     0.0   2.0   65.0 56.0     1.0   0.0     27.0   18.0   121.0 114 2 2   0 1     0   2   65 56     1 0   27 18   121
699279 699279 MN Stearns 73 school 2702930 745 Independent Districts and Schools ALBANY PUBLIC SCHOOL DISTRICT 270293000064 60 ALBANY SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 09 12 2017   grade_10 134.0 2.0 4.0   0.0 2.0     0.0   0.0   71.0 71.0     0.0   0.0     27.0   18.0   142.0 134 2 4   0 2     0   0   71 71     0 0   27 18   142
699280 699280 MN Stearns 73 school 2702930 745 Independent Districts and Schools ALBANY PUBLIC SCHOOL DISTRICT 270293000064 60 ALBANY SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 09 12 2017   grade_11 130.0 0.0 4.0   0.0 1.0     0.0   0.0   66.0 69.0     0.0   0.0     24.0   14.0   135.0 130 0 4   0 1     0   0   66 69     0 0   24 14   135
699281 699281 MN Stearns 73 school 2702930 745 Independent Districts and Schools ALBANY PUBLIC SCHOOL DISTRICT 270293000064 60 ALBANY SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 09 12 2017   grade_12 117.0 1.0 2.0   0.0 1.0     0.0   2.0   60.0 63.0     1.0   0.0     22.0   14.0   123.0 117 1 2   0 1     0   2   60 63     1 0   22 14   123
699282 699282 MN Stearns 73 school 2702930 745 Independent Districts and Schools ALBANY PUBLIC SCHOOL DISTRICT 270293000064 60 ALBANY SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 09 12 2017   pk_12_total 495.0 5.0 12.0   0.0 5.0     0.0   4.0   262.0 259.0     2.0   0.0     100.0   64.0   521.0 495 5 12   0 5     0   4   262 259     2 0   100 64   521
700867 700867 MN Stearns 73 school 2702930 745 Independent Districts and Schools ALBANY PUBLIC SCHOOL DISTRICT 270293004844 35 Albany Area Schools Early Childhood Center Special Education Special Education School No Elementary PK PK 2017   early_childhood_special_ed 25.0 0.0 0.0   0.0 0.0     0.0   0.0   13.0 12.0     0.0   0.0     7.0   *   25.0 25 0 0   0 0     0   0   13 12     0 0   7     25
700868 700868 MN Stearns 73 school 2702930 745 Independent Districts and Schools ALBANY PUBLIC SCHOOL DISTRICT 270293004844 35 Albany Area Schools Early Childhood Center Special Education Special Education School No Elementary PK PK 2017   pk_12_total 25.0 0.0 0.0   0.0 0.0     0.0   0.0   13.0 12.0     0.0   0.0     7.0   *   25.0 25 0 0   0 0     0   0   13 12     0 0   7     25
702566 702566 MN Stearns 73 school 2702930 745 Independent Districts and Schools ALBANY PUBLIC SCHOOL DISTRICT 270293000063 50 ALBANY JUNIOR HIGH Junior High School (Grades 7-8 or 7-9) Regular School No Middle 07 08 2017   grade_7 129.0 0.0 4.0   0.0 1.0     1.0   4.0   57.0 82.0     0.0   0.0     31.0   19.0   139.0 129 0 4   0 1     1   4   57 82     0 0   31 19   139
702567 702567 MN Stearns 73 school 2702930 745 Independent Districts and Schools ALBANY PUBLIC SCHOOL DISTRICT 270293000063 50 ALBANY JUNIOR HIGH Junior High School (Grades 7-8 or 7-9) Regular School No Middle 07 08 2017   grade_8 131.0 1.0 3.0   0.0 1.0     1.0   4.0   65.0 76.0     1.0   1.0     33.0   17.0   141.0 131 1 3   0 1     1   4   65 76     1 1   33 17   141
702568 702568 MN Stearns 73 school 2702930 745 Independent Districts and Schools ALBANY PUBLIC SCHOOL DISTRICT 270293000063 50 ALBANY JUNIOR HIGH Junior High School (Grades 7-8 or 7-9) Regular School No Middle 07 08 2017   pk_12_total 260.0 1.0 7.0   0.0 2.0     2.0   8.0   122.0 158.0     1.0   1.0     64.0   36.0   280.0 260 1 7   0 2     2   8   122 158     1 1   64 36   280
691984 691984 MN Freeborn 24 school 2702970 241 Independent Districts and Schools ALBERT LEA PUBLIC SCHOOL DISTRICT 270297000070 110 HALVERSON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   early_childhood_special_ed 7.0 0.0 2.0   0.0 0.0     0.0   1.0   9.0 1.0         *         *   10.0 7 0 2   0 0     0   1   9 1                 10
691985 691985 MN Freeborn 24 school 2702970 241 Independent Districts and Schools ALBERT LEA PUBLIC SCHOOL DISTRICT 270297000070 110 HALVERSON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   pre_kindergarten 29.0 3.0 14.0   0.0 8.0     0.0   4.0   35.0 23.0     0.0   0.0         0.0   58.0 29 3 14   0 8     0   4   35 23     0 0     0   58
691986 691986 MN Freeborn 24 school 2702970 241 Independent Districts and Schools ALBERT LEA PUBLIC SCHOOL DISTRICT 270297000070 110 HALVERSON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   kindergarten 23.0 3.0 15.0   0.0 4.0     0.0   4.0   32.0 17.0         0.0     42.0   10.0   49.0 23 3 15   0 4     0   4   32 17       0   42 10   49
691987 691987 MN Freeborn 24 school 2702970 241 Independent Districts and Schools ALBERT LEA PUBLIC SCHOOL DISTRICT 270297000070 110 HALVERSON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_1 24.0 3.0 23.0   0.0 4.0     0.0   1.0   31.0 24.0     11.0   *     42.0   7.0   55.0 24 3 23   0 4     0   1   31 24     11     42 7   55
691988 691988 MN Freeborn 24 school 2702970 241 Independent Districts and Schools ALBERT LEA PUBLIC SCHOOL DISTRICT 270297000070 110 HALVERSON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_2 23.0 3.0 14.0   0.0 2.0     0.0   1.0   19.0 24.0     5.0   0.0     30.0   7.0   43.0 23 3 14   0 2     0   1   19 24     5 0   30 7   43
691989 691989 MN Freeborn 24 school 2702970 241 Independent Districts and Schools ALBERT LEA PUBLIC SCHOOL DISTRICT 270297000070 110 HALVERSON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_3 31.0 2.0 25.0   0.0 3.0     0.0   1.0   27.0 35.0     15.0   2.0     48.0   12.0   62.0 31 2 25   0 3     0   1   27 35     15 2   48 12   62
691990 691990 MN Freeborn 24 school 2702970 241 Independent Districts and Schools ALBERT LEA PUBLIC SCHOOL DISTRICT 270297000070 110 HALVERSON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_4 30.0 1.0 22.0   0.0 1.0     0.0   1.0   37.0 18.0     9.0   0.0     40.0   8.0   55.0 30 1 22   0 1     0   1   37 18     9 0   40 8   55
691991 691991 MN Freeborn 24 school 2702970 241 Independent Districts and Schools ALBERT LEA PUBLIC SCHOOL DISTRICT 270297000070 110 HALVERSON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_5 39.0 2.0 17.0   0.0 1.0     0.0   2.0   33.0 28.0     4.0   2.0     42.0   15.0   61.0 39 2 17   0 1     0   2   33 28     4 2   42 15   61
691992 691992 MN Freeborn 24 school 2702970 241 Independent Districts and Schools ALBERT LEA PUBLIC SCHOOL DISTRICT 270297000070 110 HALVERSON ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   pk_12_total 206.0 17.0 132.0   0.0 23.0     0.0   15.0   223.0 170.0     47.0   6.0     285.0   69.0   393.0 206 17 132   0 23     0   15   223 170     47 6   285 69   393
691993 691993 MN Freeborn 24 school 2702970 241 Independent Districts and Schools ALBERT LEA PUBLIC SCHOOL DISTRICT 270297000071 120 HAWTHORNE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   early_childhood_special_ed 3.0 0.0 0.0   0.0 0.0     0.0   0.0   3.0 0.0         *         *   3.0 3 0 0   0 0     0   0   3 0                 3
691994 691994 MN Freeborn 24 school 2702970 241 Independent Districts and Schools ALBERT LEA PUBLIC SCHOOL DISTRICT 270297000071 120 HAWTHORNE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   pre_kindergarten 22.0 0.0 6.0   1.0 0.0     0.0   2.0   17.0 14.0     0.0   0.0         0.0   31.0 22 0 6   1 0     0   2   17 14     0 0     0   31
691995 691995 MN Freeborn 24 school 2702970 241 Independent Districts and Schools ALBERT LEA PUBLIC SCHOOL DISTRICT 270297000071 120 HAWTHORNE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   kindergarten 43.0 0.0 12.0   0.0 6.0     0.0   3.0   27.0 37.0     11.0   2.0     37.0   8.0   64.0 43 0 12   0 6     0   3   27 37     11 2   37 8   64
691996 691996 MN Freeborn 24 school 2702970 241 Independent Districts and Schools ALBERT LEA PUBLIC SCHOOL DISTRICT 270297000071 120 HAWTHORNE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_1 47.0 1.0 16.0   0.0 1.0     0.0   1.0   29.0 37.0     10.0   *     41.0   11.0   66.0 47 1 16   0 1     0   1   29 37     10     41 11   66
691997 691997 MN Freeborn 24 school 2702970 241 Independent Districts and Schools ALBERT LEA PUBLIC SCHOOL DISTRICT 270297000071 120 HAWTHORNE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_2 38.0 1.0 19.0   1.0 7.0     0.0   3.0   36.0 33.0     12.0   0.0     49.0   10.0   69.0 38 1 19   1 7     0   3   36 33     12 0   49 10   69
691998 691998 MN Freeborn 24 school 2702970 241 Independent Districts and Schools ALBERT LEA PUBLIC SCHOOL DISTRICT 270297000071 120 HAWTHORNE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_3 48.0 1.0 15.0   0.0 7.0     0.0   5.0   42.0 34.0     11.0   0.0     53.0   8.0   76.0 48 1 15   0 7     0   5   42 34     11 0   53 8   76
691999 691999 MN Freeborn 24 school 2702970 241 Independent Districts and Schools ALBERT LEA PUBLIC SCHOOL DISTRICT 270297000071 120 HAWTHORNE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_4 44.0 0.0 18.0   0.0 4.0     0.0   3.0   35.0 34.0     7.0   3.0     41.0   17.0   69.0 44 0 18   0 4     0   3   35 34     7 3   41 17   69
692000 692000 MN Freeborn 24 school 2702970 241 Independent Districts and Schools ALBERT LEA PUBLIC SCHOOL DISTRICT 270297000071 120 HAWTHORNE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_5 38.0 1.0 18.0   0.0 4.0     0.0   1.0   37.0 25.0         1.0     42.0   11.0   62.0 38 1 18   0 4     0   1   37 25       1   42 11   62
692001 692001 MN Freeborn 24 school 2702970 241 Independent Districts and Schools ALBERT LEA PUBLIC SCHOOL DISTRICT 270297000071 120 HAWTHORNE ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   pk_12_total 283.0 4.0 104.0   2.0 29.0     0.0   18.0   226.0 214.0     55.0   7.0     287.0   68.0   440.0 283 4 104   2 29     0   18   226 214     55 7   287 68   440
692002 692002 MN Freeborn 24 school 2702970 241 Independent Districts and Schools ALBERT LEA PUBLIC SCHOOL DISTRICT 270297000074 130 LAKEVIEW ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   kindergarten 33.0 3.0 12.0   0.0 3.0     0.0   0.0   26.0 25.0         0.0     24.0   8.0   51.0 33 3 12   0 3     0   0   26 25       0   24 8   51
692003 692003 MN Freeborn 24 school 2702970 241 Independent Districts and Schools ALBERT LEA PUBLIC SCHOOL DISTRICT 270297000074 130 LAKEVIEW ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_1 52.0 4.0 13.0   0.0 4.0     0.0   2.0   39.0 36.0     6.0   0.0     34.0   8.0   75.0 52 4 13   0 4     0   2   39 36     6 0   34 8   75
692004 692004 MN Freeborn 24 school 2702970 241 Independent Districts and Schools ALBERT LEA PUBLIC SCHOOL DISTRICT 270297000074 130 LAKEVIEW ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_2 47.0 6.0 10.0   0.0 4.0     0.0   3.0   37.0 33.0     7.0   0.0     39.0   12.0   70.0 47 6 10   0 4     0   3   37 33     7 0   39 12   70
692005 692005 MN Freeborn 24 school 2702970 241 Independent Districts and Schools ALBERT LEA PUBLIC SCHOOL DISTRICT 270297000074 130 LAKEVIEW ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_3 47.0 5.0 13.0   0.0 4.0     0.0   3.0   41.0 31.0         0.0     36.0   16.0   72.0 47 5 13   0 4     0   3   41 31       0   36 16   72
692006 692006 MN Freeborn 24 school 2702970 241 Independent Districts and Schools ALBERT LEA PUBLIC SCHOOL DISTRICT 270297000074 130 LAKEVIEW ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_4 38.0 3.0 9.0   1.0 7.0     0.0   2.0   22.0 38.0     9.0   0.0     33.0   4.0   60.0 38 3 9   1 7     0   2   22 38     9 0   33 4   60
692007 692007 MN Freeborn 24 school 2702970 241 Independent Districts and Schools ALBERT LEA PUBLIC SCHOOL DISTRICT 270297000074 130 LAKEVIEW ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_5 45.0 0.0 9.0   0.0 1.0     0.0   2.0   27.0 30.0     2.0   0.0     26.0   7.0   57.0 45 0 9   0 1     0   2   27 30     2 0   26 7   57
692008 692008 MN Freeborn 24 school 2702970 241 Independent Districts and Schools ALBERT LEA PUBLIC SCHOOL DISTRICT 270297000074 130 LAKEVIEW ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   pk_12_total 262.0 21.0 66.0   1.0 23.0     0.0   12.0   192.0 193.0     37.0   0.0     192.0   55.0   385.0 262 21 66   1 23     0   12   192 193     37 0   192 55   385
692009 692009 MN Freeborn 24 school 2702970 241 Independent Districts and Schools ALBERT LEA PUBLIC SCHOOL DISTRICT 270297000077 140 SIBLEY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   kindergarten 49.0 3.0 5.0   0.0 6.0     0.0   0.0   33.0 30.0     6.0   0.0     27.0   4.0   63.0 49 3 5   0 6     0   0   33 30     6 0   27 4   63
692010 692010 MN Freeborn 24 school 2702970 241 Independent Districts and Schools ALBERT LEA PUBLIC SCHOOL DISTRICT 270297000077 140 SIBLEY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_1 44.0 1.0 11.0   0.0 3.0     0.0   2.0   29.0 32.0     8.0   0.0     27.0   10.0   61.0 44 1 11   0 3     0   2   29 32     8 0   27 10   61
692011 692011 MN Freeborn 24 school 2702970 241 Independent Districts and Schools ALBERT LEA PUBLIC SCHOOL DISTRICT 270297000077 140 SIBLEY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_2 54.0 1.0 15.0   0.0 4.0     0.0   2.0   37.0 39.0     6.0   1.0     34.0   3.0   76.0 54 1 15   0 4     0   2   37 39     6 1   34 3   76
692012 692012 MN Freeborn 24 school 2702970 241 Independent Districts and Schools ALBERT LEA PUBLIC SCHOOL DISTRICT 270297000077 140 SIBLEY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_3 48.0 3.0 5.0   0.0 1.0     0.0   2.0   30.0 29.0         1.0     24.0   10.0   59.0 48 3 5   0 1     0   2   30 29       1   24 10   59
692013 692013 MN Freeborn 24 school 2702970 241 Independent Districts and Schools ALBERT LEA PUBLIC SCHOOL DISTRICT 270297000077 140 SIBLEY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_4 55.0 1.0 7.0   1.0 5.0     0.0   4.0   32.0 41.0     9.0   2.0     30.0   8.0   73.0 55 1 7   1 5     0   4   32 41     9 2   30 8   73
692014 692014 MN Freeborn 24 school 2702970 241 Independent Districts and Schools ALBERT LEA PUBLIC SCHOOL DISTRICT 270297000077 140 SIBLEY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   grade_5 43.0 0.0 5.0   0.0 3.0     0.0   2.0   24.0 29.0         0.0     18.0   10.0   53.0 43 0 5   0 3     0   2   24 29       0   18 10   53
692015 692015 MN Freeborn 24 school 2702970 241 Independent Districts and Schools ALBERT LEA PUBLIC SCHOOL DISTRICT 270297000077 140 SIBLEY ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary KG 05 2017   pk_12_total 293.0 9.0 48.0   1.0 22.0     0.0   12.0   185.0 200.0     35.0   4.0     160.0   45.0   385.0 293 9 48   1 22     0   12   185 200     35 4   160 45   385
697919 697919 MN Freeborn 24 school 2702970 241 Independent Districts and Schools ALBERT LEA PUBLIC SCHOOL DISTRICT 270297000078 320 SOUTHWEST MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 07 2017   grade_6 160.0 6.0 58.0   3.0 14.0     0.0   8.0   128.0 121.0         *         *   249.0 160 6 58   3 14     0   8   128 121                 249
697920 697920 MN Freeborn 24 school 2702970 241 Independent Districts and Schools ALBERT LEA PUBLIC SCHOOL DISTRICT 270297000078 320 SOUTHWEST MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 07 2017   grade_7 194.0 9.0 54.0   0.0 13.0     0.0   13.0   145.0 138.0         *         *   283.0 194 9 54   0 13     0   13   145 138                 283
697921 697921 MN Freeborn 24 school 2702970 241 Independent Districts and Schools ALBERT LEA PUBLIC SCHOOL DISTRICT 270297000078 320 SOUTHWEST MIDDLE Middle School (Grades 5-8) Regular School No Middle 06 07 2017   pk_12_total 354.0 15.0 112.0   3.0 27.0     0.0   21.0   273.0 259.0     27.0   5.0     262.0   89.0   532.0 354 15 112   3 27     0   21   273 259     27 5   262 89   532
698874 698874 MN Freeborn 24 school 2702970 241 Independent Districts and Schools ALBERT LEA PUBLIC SCHOOL DISTRICT 270297000068 310 ALBERT LEA SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 08 12 2017   grade_8 175.0 5.0 48.0   0.0 17.0     0.0   7.0   128.0 124.0         *         *   252.0 175 5 48   0 17     0   7   128 124                 252
698875 698875 MN Freeborn 24 school 2702970 241 Independent Districts and Schools ALBERT LEA PUBLIC SCHOOL DISTRICT 270297000068 310 ALBERT LEA SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 08 12 2017   grade_9 176.0 7.0 62.0   0.0 15.0     0.0   5.0   134.0 131.0     28.0   1.0     126.0   41.0   265.0 176 7 62   0 15     0   5   134 131     28 1   126 41   265
698876 698876 MN Freeborn 24 school 2702970 241 Independent Districts and Schools ALBERT LEA PUBLIC SCHOOL DISTRICT 270297000068 310 ALBERT LEA SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 08 12 2017   grade_10 180.0 3.0 47.0   0.0 11.0     0.0   4.0   145.0 100.0     14.0   0.0     106.0   44.0   245.0 180 3 47   0 11     0   4   145 100     14 0   106 44   245
698877 698877 MN Freeborn 24 school 2702970 241 Independent Districts and Schools ALBERT LEA PUBLIC SCHOOL DISTRICT 270297000068 310 ALBERT LEA SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 08 12 2017   grade_11 189.0 3.0 36.0   1.0 11.0     0.0   4.0   116.0 128.0         0.0     82.0   *   244.0 189 3 36   1 11     0   4   116 128       0   82     244
698878 698878 MN Freeborn 24 school 2702970 241 Independent Districts and Schools ALBERT LEA PUBLIC SCHOOL DISTRICT 270297000068 310 ALBERT LEA SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 08 12 2017   grade_12 143.0 5.0 26.0   0.0 9.0     0.0   3.0   95.0 91.0     8.0   0.0         37.0   186.0 143 5 26   0 9     0   3   95 91     8 0     37   186
698879 698879 MN Freeborn 24 school 2702970 241 Independent Districts and Schools ALBERT LEA PUBLIC SCHOOL DISTRICT 270297000068 310 ALBERT LEA SENIOR HIGH Senior High School (Grades 9-12) Regular School No High 08 12 2017   pk_12_total 863.0 23.0 219.0   1.0 63.0     0.0   23.0   618.0 574.0     64.0   *     509.0   208.0   1192.0 863 23 219   1 63     0   23   618 574     64     509 208   1192
699887 699887 MN Freeborn 24 school 2702970 241 Independent Districts and Schools ALBERT LEA PUBLIC SCHOOL DISTRICT 270297002228 350 Albert Lea Area Learning Center Public Area Learning Center ALC (State approved) Alternative School No Other 06 12 2017   grade_6 5.0 2.0 3.0   0.0 0.0     0.0   1.0   6.0 5.0         *         *   11.0 5 2 3   0 0     0   1   6 5                 11
699888 699888 MN Freeborn 24 school 2702970 241 Independent Districts and Schools ALBERT LEA PUBLIC SCHOOL DISTRICT 270297002228 350 Albert Lea Area Learning Center Public Area Learning Center ALC (State approved) Alternative School No Other 06 12 2017   grade_7 5.0 0.0 3.0   0.0 1.0     0.0   0.0   5.0 4.0         *         *   9.0 5 0 3   0 1     0   0   5 4                 9
699889 699889 MN Freeborn 24 school 2702970 241 Independent Districts and Schools ALBERT LEA PUBLIC SCHOOL DISTRICT 270297002228 350 Albert Lea Area Learning Center Public Area Learning Center ALC (State approved) Alternative School No Other 06 12 2017   grade_10 2.0 0.0 3.0   0.0 0.0     0.0   1.0   3.0 3.0         *         *   6.0 2 0 3   0 0     0   1   3 3                 6
699890 699890 MN Freeborn 24 school 2702970 241 Independent Districts and Schools ALBERT LEA PUBLIC SCHOOL DISTRICT 270297002228 350 Albert Lea Area Learning Center Public Area Learning Center ALC (State approved) Alternative School No Other 06 12 2017   grade_11 17.0 2.0 4.0   0.0 0.0     0.0   0.0   13.0 10.0         0.0     14.0   *   23.0 17 2 4   0 0     0   0   13 10       0   14     23
699891 699891 MN Freeborn 24 school 2702970 241 Independent Districts and Schools ALBERT LEA PUBLIC SCHOOL DISTRICT 270297002228 350 Albert Lea Area Learning Center Public Area Learning Center ALC (State approved) Alternative School No Other 06 12 2017   grade_12 43.0 0.0 12.0   0.0 2.0     0.0   0.0   30.0 27.0     3.0   0.0         12.0   57.0 43 0 12   0 2     0   0   30 27     3 0     12   57
699892 699892 MN Freeborn 24 school 2702970 241 Independent Districts and Schools ALBERT LEA PUBLIC SCHOOL DISTRICT 270297002228 350 Albert Lea Area Learning Center Public Area Learning Center ALC (State approved) Alternative School No Other 06 12 2017   pk_12_total 72.0 4.0 25.0   0.0 3.0     0.0   2.0   57.0 49.0         0.0     73.0   *   106.0 72 4 25   0 3     0   2   57 49       0   73     106
700555 700555 MN Freeborn 24 school 2702970 241 Independent Districts and Schools ALBERT LEA PUBLIC SCHOOL DISTRICT 270297003501 111 Brookside Early Childhood Special Education Special Education Special Education School No Elementary PK PK 2017   early_childhood_special_ed 43.0 2.0 16.0   0.0 5.0     0.0   0.0   42.0 24.0     0.0   0.0         *   66.0 43 2 16   0 5     0   0   42 24     0 0         66
700556 700556 MN Freeborn 24 school 2702970 241 Independent Districts and Schools ALBERT LEA PUBLIC SCHOOL DISTRICT 270297003501 111 Brookside Early Childhood Special Education Special Education Special Education School No Elementary PK PK 2017   pk_12_total 43.0 2.0 16.0   0.0 5.0     0.0   0.0   42.0 24.0     0.0   0.0         *   66.0 43 2 16   0 5     0   0   42 24     0 0         66
701984 701984 MN Freeborn 24 school 2702970 241 Independent Districts and Schools ALBERT LEA PUBLIC SCHOOL DISTRICT 270297003503 620 HAYWARD GROUP HOME Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No Other 05 12 2017   grade_8 1.0 0.0 0.0   0.0 0.0     0.0   0.0   0.0 1.0         *         *   1.0 1 0 0   0 0     0   0   0 1                 1
701985 701985 MN Freeborn 24 school 2702970 241 Independent Districts and Schools ALBERT LEA PUBLIC SCHOOL DISTRICT 270297003503 620 HAYWARD GROUP HOME Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No Other 05 12 2017   grade_10 1.0 0.0 1.0   0.0 0.0     0.0   0.0   0.0 2.0         *         *   2.0 1 0 1   0 0     0   0   0 2                 2
701986 701986 MN Freeborn 24 school 2702970 241 Independent Districts and Schools ALBERT LEA PUBLIC SCHOOL DISTRICT 270297003503 620 HAYWARD GROUP HOME Educational Oversight to Public Residential Care & Treatment (State approved) Alternative School No Other 05 12 2017   pk_12_total 2.0 0.0 1.0   0.0 0.0     0.0   0.0   0.0 3.0         *         *   3.0 2 0 1   0 0     0   0   0 3                 3
689222 689222 MN Freeborn 24 school 2703030 242 Independent Districts and Schools ALDEN-CONGER PUBLIC SCHOOL DISTRICT 270303000080 1 ALDEN-CONGER SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   grade_7 28.0 0.0 1.0   0.0 0.0     0.0   1.0   13.0 17.0     0.0   0.0     14.0   7.0   30.0 28 0 1   0 0     0   1   13 17     0 0   14 7   30
689223 689223 MN Freeborn 24 school 2703030 242 Independent Districts and Schools ALDEN-CONGER PUBLIC SCHOOL DISTRICT 270303000080 1 ALDEN-CONGER SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   grade_8 51.0 0.0 3.0   0.0 0.0     0.0   0.0   27.0 27.0     0.0   0.0     17.0   11.0   54.0 51 0 3   0 0     0   0   27 27     0 0   17 11   54
689224 689224 MN Freeborn 24 school 2703030 242 Independent Districts and Schools ALDEN-CONGER PUBLIC SCHOOL DISTRICT 270303000080 1 ALDEN-CONGER SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   grade_9 32.0 0.0 2.0   0.0 1.0     0.0   3.0   21.0 17.0     0.0   0.0     15.0   6.0   38.0 32 0 2   0 1     0   3   21 17     0 0   15 6   38
689225 689225 MN Freeborn 24 school 2703030 242 Independent Districts and Schools ALDEN-CONGER PUBLIC SCHOOL DISTRICT 270303000080 1 ALDEN-CONGER SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   grade_10 30.0 0.0 1.0   0.0 0.0     0.0   1.0   13.0 19.0     0.0   0.0     11.0   12.0   32.0 30 0 1   0 0     0   1   13 19     0 0   11 12   32
689226 689226 MN Freeborn 24 school 2703030 242 Independent Districts and Schools ALDEN-CONGER PUBLIC SCHOOL DISTRICT 270303000080 1 ALDEN-CONGER SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   grade_11 28.0 0.0 1.0   0.0 0.0     0.0   1.0   23.0 7.0     0.0   0.0     7.0   6.0   30.0 28 0 1   0 0     0   1   23 7     0 0   7 6   30
689227 689227 MN Freeborn 24 school 2703030 242 Independent Districts and Schools ALDEN-CONGER PUBLIC SCHOOL DISTRICT 270303000080 1 ALDEN-CONGER SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   grade_12 35.0 0.0 3.0   0.0 0.0     0.0   0.0   19.0 19.0     0.0   3.0     11.0   7.0   38.0 35 0 3   0 0     0   0   19 19     0 3   11 7   38
689228 689228 MN Freeborn 24 school 2703030 242 Independent Districts and Schools ALDEN-CONGER PUBLIC SCHOOL DISTRICT 270303000080 1 ALDEN-CONGER SECONDARY Secondary School (Grades 7-12) Regular School No High 07 12 2017   pk_12_total 204.0 0.0 11.0   0.0 1.0     0.0   6.0   116.0 106.0     0.0   3.0     75.0   49.0   222.0 204 0 11   0 1     0   6   116 106     0 3   75 49   222
692016 692016 MN Freeborn 24 school 2703030 242 Independent Districts and Schools ALDEN-CONGER PUBLIC SCHOOL DISTRICT 270303000079 2 ALDEN-CONGER ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   early_childhood_special_ed 5.0 0.0 1.0   0.0 0.0     0.0   0.0   3.0 3.0         *         *   6.0 5 0 1   0 0     0   0   3 3                 6
692017 692017 MN Freeborn 24 school 2703030 242 Independent Districts and Schools ALDEN-CONGER PUBLIC SCHOOL DISTRICT 270303000079 2 ALDEN-CONGER ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   kindergarten 32.0 0.0 1.0   0.0 0.0     0.0   0.0   19.0 14.0         *         3.0   33.0 32 0 1   0 0     0   0   19 14             3   33
692018 692018 MN Freeborn 24 school 2703030 242 Independent Districts and Schools ALDEN-CONGER PUBLIC SCHOOL DISTRICT 270303000079 2 ALDEN-CONGER ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_1 37.0 0.0 1.0   0.0 0.0     0.0   0.0   20.0 18.0     0.0   0.0     11.0   2.0   38.0 37 0 1   0 0     0   0   20 18     0 0   11 2   38
692019 692019 MN Freeborn 24 school 2703030 242 Independent Districts and Schools ALDEN-CONGER PUBLIC SCHOOL DISTRICT 270303000079 2 ALDEN-CONGER ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_2 33.0 0.0 3.0   0.0 0.0     0.0   1.0   11.0 26.0     0.0   0.0     15.0   3.0   37.0 33 0 3   0 0     0   1   11 26     0 0   15 3   37
692020 692020 MN Freeborn 24 school 2703030 242 Independent Districts and Schools ALDEN-CONGER PUBLIC SCHOOL DISTRICT 270303000079 2 ALDEN-CONGER ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_3 38.0 0.0 1.0   0.0 0.0     0.0   0.0   17.0 22.0     0.0   0.0     17.0   7.0   39.0 38 0 1   0 0     0   0   17 22     0 0   17 7   39
692021 692021 MN Freeborn 24 school 2703030 242 Independent Districts and Schools ALDEN-CONGER PUBLIC SCHOOL DISTRICT 270303000079 2 ALDEN-CONGER ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_4 36.0 0.0 1.0   0.0 0.0     0.0   0.0   23.0 14.0     0.0   0.0     12.0   6.0   37.0 36 0 1   0 0     0   0   23 14     0 0   12 6   37
692022 692022 MN Freeborn 24 school 2703030 242 Independent Districts and Schools ALDEN-CONGER PUBLIC SCHOOL DISTRICT 270303000079 2 ALDEN-CONGER ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_5 31.0 0.0 2.0   0.0 0.0     0.0   0.0   18.0 15.0     0.0   0.0     11.0   6.0   33.0 31 0 2   0 0     0   0   18 15     0 0   11 6   33
692023 692023 MN Freeborn 24 school 2703030 242 Independent Districts and Schools ALDEN-CONGER PUBLIC SCHOOL DISTRICT 270303000079 2 ALDEN-CONGER ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   grade_6 42.0 0.0 3.0   0.0 0.0     0.0   1.0   18.0 28.0     0.0   0.0     15.0   10.0   46.0 42 0 3   0 0     0   1   18 28     0 0   15 10   46
692024 692024 MN Freeborn 24 school 2703030 242 Independent Districts and Schools ALDEN-CONGER PUBLIC SCHOOL DISTRICT 270303000079 2 ALDEN-CONGER ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 06 2017   pk_12_total 254.0 0.0 13.0   0.0 0.0     0.0   2.0   129.0 140.0     0.0   0.0     95.0   43.0   269.0 254 0 13   0 0     0   2   129 140     0 0   95 43   269
691896 691896 MN Douglas 21 school 2703060 206 Independent Districts and Schools ALEXANDRIA PUBLIC SCHOOL DISTRICT 270306000082 110 CARLOS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   kindergarten 21.0 0.0 0.0   0.0 0.0     0.0   0.0   9.0 12.0     0.0   0.0     5.0   *   21.0 21 0 0   0 0     0   0   9 12     0 0   5     21
691897 691897 MN Douglas 21 school 2703060 206 Independent Districts and Schools ALEXANDRIA PUBLIC SCHOOL DISTRICT 270306000082 110 CARLOS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_1 18.0 0.0 2.0   0.0 0.0     0.0   0.0   6.0 14.0     0.0   0.0     7.0   3.0   20.0 18 0 2   0 0     0   0   6 14     0 0   7 3   20
691898 691898 MN Douglas 21 school 2703060 206 Independent Districts and Schools ALEXANDRIA PUBLIC SCHOOL DISTRICT 270306000082 110 CARLOS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_2 20.0 0.0 2.0   0.0 0.0     0.0   0.0   17.0 5.0     0.0   0.0     8.0   7.0   22.0 20 0 2   0 0     0   0   17 5     0 0   8 7   22
691899 691899 MN Douglas 21 school 2703060 206 Independent Districts and Schools ALEXANDRIA PUBLIC SCHOOL DISTRICT 270306000082 110 CARLOS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_3 21.0 0.0 0.0   0.0 0.0     0.0   0.0   7.0 14.0     0.0   0.0     4.0   *   21.0 21 0 0   0 0     0   0   7 14     0 0   4     21
691900 691900 MN Douglas 21 school 2703060 206 Independent Districts and Schools ALEXANDRIA PUBLIC SCHOOL DISTRICT 270306000082 110 CARLOS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_4 14.0 0.0 1.0   0.0 0.0     0.0   0.0   8.0 7.0     0.0   0.0     6.0   4.0   15.0 14 0 1   0 0     0   0   8 7     0 0   6 4   15
691901 691901 MN Douglas 21 school 2703060 206 Independent Districts and Schools ALEXANDRIA PUBLIC SCHOOL DISTRICT 270306000082 110 CARLOS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   grade_5 14.0 0.0 0.0   0.0 0.0     0.0   0.0   9.0 5.0     0.0   0.0     3.0   2.0   14.0 14 0 0   0 0     0   0   9 5     0 0   3 2   14
691902 691902 MN Douglas 21 school 2703060 206 Independent Districts and Schools ALEXANDRIA PUBLIC SCHOOL DISTRICT 270306000082 110 CARLOS ELEMENTARY Elementary School (Grades PK-6) Regular School No Elementary PK 05 2017   pk_12_total 108.0 0.0 5.0   0.0 0.0     0.0   0.0   56.0 57.0     0.0   0.0     33.0   20.0   113.0 108 0 5   0 0     0   0   56 57     0 0   33 20   113
691903 691903 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   kindergarten 22.0 0.0 1.0   0.0 0.0     0.0   0.0   11.0 12.0     0.0   0.0     5.0   *   23.0 22 0 1   0 0     0   0   11 12     0 0   5     23
691904 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
691905 691905 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_2 26.0 0.0 0.0   0.0 0.0     0.0   0.0   12.0 14.0     0.0   1.0     8.0   5.0   26.0 26 0 0   0 0     0   0   12 14     0 1   8 5   26
691906 691906 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_3 17.0 0.0 0.0   0.0 0.0     0.0   1.0   9.0 9.0     0.0   1.0     1.0   *   18.0 17 0 0   0 0     0   1   9 9     0 1   1     18

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