enrollments

Data source: Big Local News · About: Big Local

14,702 rows where state = "WI" and year = 2018

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2018 · 14,502 ✖
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
3088837 3088837 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000036 50 Antigo Middle   Regular School No Middle 06 08 2018   grade_8                                                   177                                             177
3088838 3088838 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000038 80 Crestwood Elementary   Regular School No Elementary PK 05 2018   pk_12_total 108.0   13.0 1.0   1.0         2.0   61.0 64.0             60     23   125 108   13 1   1         2   61 64         60   23   125
3088839 3088839 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000038 80 Crestwood Elementary   Regular School No Elementary PK 05 2018   grade_1                                                   15                                             15
3088840 3088840 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000038 80 Crestwood Elementary   Regular School No Elementary PK 05 2018   grade_2                                                   25                                             25
3088841 3088841 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000038 80 Crestwood Elementary   Regular School No Elementary PK 05 2018   grade_3                                                   18                                             18
3088842 3088842 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000038 80 Crestwood Elementary   Regular School No Elementary PK 05 2018   grade_4                                                   20                                             20
3088843 3088843 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000038 80 Crestwood Elementary   Regular School No Elementary PK 05 2018   grade_5                                                   24                                             24
3088844 3088844 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000038 80 Crestwood Elementary   Regular School No Elementary PK 05 2018   kindergarten                                                   22                                             22
3088845 3088845 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000038 80 Crestwood Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten                                                   1                                             1
3088846 3088846 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000039 100 East Elementary   Regular School No Elementary PK 05 2018   pk_12_total 121.0 1.0                 3.0   76.0 49.0             72     32   125 121 1                 3   76 49         72   32   125
3088847 3088847 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000039 100 East Elementary   Regular School No Elementary PK 05 2018   grade_1                                                   22                                             22
3088848 3088848 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000039 100 East Elementary   Regular School No Elementary PK 05 2018   grade_2                                                   20                                             20
3088849 3088849 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000039 100 East Elementary   Regular School No Elementary PK 05 2018   grade_3                                                   21                                             21
3088850 3088850 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000039 100 East Elementary   Regular School No Elementary PK 05 2018   grade_4                                                   13                                             13
3088851 3088851 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000039 100 East Elementary   Regular School No Elementary PK 05 2018   grade_5                                                   26                                             26
3088852 3088852 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000039 100 East Elementary   Regular School No Elementary PK 05 2018   kindergarten                                                   16                                             16
3088853 3088853 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000039 100 East Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten                                                   7                                             7
3088854 3088854 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000042 180 North Elementary   Regular School No Elementary PK 05 2018   pk_12_total 116.0 1.0 10.0 7.0             12.0   86.0 60.0             117     32   146 116 1 10 7             12   86 60         117   32   146
3088855 3088855 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000042 180 North Elementary   Regular School No Elementary PK 05 2018   grade_1                                                   20                                             20
3088856 3088856 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000042 180 North Elementary   Regular School No Elementary PK 05 2018   grade_2                                                   28                                             28
3088857 3088857 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000042 180 North Elementary   Regular School No Elementary PK 05 2018   grade_3                                                   29                                             29
3088858 3088858 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000042 180 North Elementary   Regular School No Elementary PK 05 2018   grade_4                                                   28                                             28
3088859 3088859 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000042 180 North Elementary   Regular School No Elementary PK 05 2018   grade_5                                                   24                                             24
3088860 3088860 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000042 180 North Elementary   Regular School No Elementary PK 05 2018   kindergarten                                                   17                                             17
3088861 3088861 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000043 200 Pleasant View Elementary   Regular School No Elementary PK 05 2018   pk_12_total 239.0 2.0 6.0 4.0             5.0   130.0 126.0             122     29   256 239 2 6 4             5   130 126         122   29   256
3088862 3088862 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000043 200 Pleasant View Elementary   Regular School No Elementary PK 05 2018   grade_1                                                   17                                             17
3088863 3088863 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000043 200 Pleasant View Elementary   Regular School No Elementary PK 05 2018   grade_2                                                   18                                             18
3088864 3088864 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000043 200 Pleasant View Elementary   Regular School No Elementary PK 05 2018   grade_3                                                   22                                             22
3088865 3088865 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000043 200 Pleasant View Elementary   Regular School No Elementary PK 05 2018   grade_4                                                   17                                             17
3088866 3088866 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000043 200 Pleasant View Elementary   Regular School No Elementary PK 05 2018   grade_5                                                   19                                             19
3088867 3088867 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000043 200 Pleasant View Elementary   Regular School No Elementary PK 05 2018   kindergarten_4_year_old                                                   144                                             144
3088868 3088868 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000043 200 Pleasant View Elementary   Regular School No Elementary PK 05 2018   kindergarten                                                   19                                             19
3088869 3088869 WI Langlade   school   140 Public Schools-Multidistrict Charters Antigo Unified   9100 Rural Virtual Academy charter           2018   pk_12_total 26.0   4.0 2.0                 17.0 15.0             9     8   32 26   4 2                 17 15         9   8   32
3088870 3088870 WI Langlade   school   140 Public Schools-Multidistrict Charters Antigo Unified   9100 Rural Virtual Academy charter           2018   grade_11                                                   5                                             5
3088871 3088871 WI Langlade   school   140 Public Schools-Multidistrict Charters Antigo Unified   9100 Rural Virtual Academy charter           2018   grade_12                                                   9                                             9
3088872 3088872 WI Langlade   school   140 Public Schools-Multidistrict Charters Antigo Unified   9100 Rural Virtual Academy charter           2018   grade_2                                                   1                                             1
3088873 3088873 WI Langlade   school   140 Public Schools-Multidistrict Charters Antigo Unified   9100 Rural Virtual Academy charter           2018   grade_3                                                   2                                             2
3088874 3088874 WI Langlade   school   140 Public Schools-Multidistrict Charters Antigo Unified   9100 Rural Virtual Academy charter           2018   grade_4                                                   1                                             1
3088875 3088875 WI Langlade   school   140 Public Schools-Multidistrict Charters Antigo Unified   9100 Rural Virtual Academy charter           2018   grade_5                                                   1                                             1
3088876 3088876 WI Langlade   school   140 Public Schools-Multidistrict Charters Antigo Unified   9100 Rural Virtual Academy charter           2018   grade_6                                                   2                                             2
3088877 3088877 WI Langlade   school   140 Public Schools-Multidistrict Charters Antigo Unified   9100 Rural Virtual Academy charter           2018   grade_7                                                   2                                             2
3088878 3088878 WI Langlade   school   140 Public Schools-Multidistrict Charters Antigo Unified   9100 Rural Virtual Academy charter           2018   grade_8                                                   5                                             5
3088879 3088879 WI Langlade   school   140 Public Schools-Multidistrict Charters Antigo Unified   9100 Rural Virtual Academy charter           2018   grade_9                                                   4                                             4
3088880 3088880 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000045 260 Spring Valley Elementary   Regular School No Elementary PK 05 2018   pk_12_total 111.0   4.0 1.0             3.0   65.0 54.0             56     14   119 111   4 1             3   65 54         56   14   119
3088881 3088881 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000045 260 Spring Valley Elementary   Regular School No Elementary PK 05 2018   grade_1                                                   17                                             17
3088882 3088882 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000045 260 Spring Valley Elementary   Regular School No Elementary PK 05 2018   grade_2                                                   20                                             20
3088883 3088883 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000045 260 Spring Valley Elementary   Regular School No Elementary PK 05 2018   grade_3                                                   17                                             17
3088884 3088884 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000045 260 Spring Valley Elementary   Regular School No Elementary PK 05 2018   grade_4                                                   25                                             25
3088885 3088885 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000045 260 Spring Valley Elementary   Regular School No Elementary PK 05 2018   grade_5                                                   23                                             23
3088886 3088886 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000045 260 Spring Valley Elementary   Regular School No Elementary PK 05 2018   kindergarten                                                   17                                             17
3088887 3088887 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000046 280 West Elementary   Regular School No Elementary PK 05 2018   pk_12_total 180.0 5.0 23.0 3.0   3.0         15.0   118.0 111.0             170     63   229 180 5 23 3   3         15   118 111         170   63   229
3088888 3088888 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000046 280 West Elementary   Regular School No Elementary PK 05 2018   grade_1                                                   41                                             41
3088889 3088889 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000046 280 West Elementary   Regular School No Elementary PK 05 2018   grade_2                                                   35                                             35
3088890 3088890 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000046 280 West Elementary   Regular School No Elementary PK 05 2018   grade_3                                                   45                                             45
3088891 3088891 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000046 280 West Elementary   Regular School No Elementary PK 05 2018   grade_4                                                   35                                             35
3088892 3088892 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000046 280 West Elementary   Regular School No Elementary PK 05 2018   grade_5                                                   42                                             42
3088893 3088893 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000046 280 West Elementary   Regular School No Elementary PK 05 2018   kindergarten                                                   31                                             31
3088894 3088894 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002880 155 Appleton Bilingual School charter Regular School Yes Elementary KG 06 2018   pk_12_total 49.0   116.0               7.0   79.0 93.0             71     10   172 49   116               7   79 93         71   10   172
3088895 3088895 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002880 155 Appleton Bilingual School charter Regular School Yes Elementary KG 06 2018   grade_1                                                   28                                             28
3088896 3088896 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002880 155 Appleton Bilingual School charter Regular School Yes Elementary KG 06 2018   grade_2                                                   27                                             27
3088897 3088897 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002880 155 Appleton Bilingual School charter Regular School Yes Elementary KG 06 2018   grade_3                                                   28                                             28
3088898 3088898 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002880 155 Appleton Bilingual School charter Regular School Yes Elementary KG 06 2018   grade_4                                                   25                                             25
3088899 3088899 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002880 155 Appleton Bilingual School charter Regular School Yes Elementary KG 06 2018   grade_5                                                   19                                             19
3088900 3088900 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002880 155 Appleton Bilingual School charter Regular School Yes Elementary KG 06 2018   grade_6                                                   18                                             18
3088901 3088901 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002880 155 Appleton Bilingual School charter Regular School Yes Elementary KG 06 2018   kindergarten                                                   27                                             27
3088902 3088902 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002976 165 Appleton Community 4K   Regular School No Prekindergarten PK PK 2018   pk_12_total 589.0 34.0 116.0 7.0   123.0       2.0 63.0   466.0 468.0             313     127   934 589 34 116 7   123       2 63   466 468         313   127   934
3088903 3088903 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002976 165 Appleton Community 4K   Regular School No Prekindergarten PK PK 2018   kindergarten_4_year_old                                                   934                                             934
3088904 3088904 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002679 800 Appleton Cooperative Educational Center   Alternative School No Other 04 12 2018   pk_12_total 1.0 1.0       2.0             4.0               *     *   4 1 1       2             4                   4
3088905 3088905 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002679 800 Appleton Cooperative Educational Center   Alternative School No Other 04 12 2018   grade_12                                                   4                                             4
3088906 3088906 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002549 440 Appleton eSchool charter Regular School Yes High 07 12 2018   pk_12_total 15.0 1.0 2.0                   6.0 12.0             2         18 15 1 2                   6 12         2       18
3088907 3088907 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002549 440 Appleton eSchool charter Regular School Yes High 07 12 2018   grade_10                                                   1                                             1
3088908 3088908 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002549 440 Appleton eSchool charter Regular School Yes High 07 12 2018   grade_11                                                   5                                             5
3088909 3088909 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002549 440 Appleton eSchool charter Regular School Yes High 07 12 2018   grade_12                                                   10                                             10
3088910 3088910 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002549 440 Appleton eSchool charter Regular School Yes High 07 12 2018   grade_9                                                   2                                             2
3088911 3088911 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002583 145 Appleton Public Montessori charter Regular School Yes Elementary PK 06 2018   pk_12_total 142.0 1.0 9.0     2.0         3.0   73.0 84.0             23     9   157 142 1 9     2         3   73 84         23   9   157
3088912 3088912 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002583 145 Appleton Public Montessori charter Regular School Yes Elementary PK 06 2018   grade_1                                                   19                                             19
3088913 3088913 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002583 145 Appleton Public Montessori charter Regular School Yes Elementary PK 06 2018   grade_2                                                   21                                             21
3088914 3088914 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002583 145 Appleton Public Montessori charter Regular School Yes Elementary PK 06 2018   grade_3                                                   19                                             19
3088915 3088915 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002583 145 Appleton Public Montessori charter Regular School Yes Elementary PK 06 2018   grade_4                                                   20                                             20
3088916 3088916 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002583 145 Appleton Public Montessori charter Regular School Yes Elementary PK 06 2018   grade_5                                                   19                                             19
3088917 3088917 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002583 145 Appleton Public Montessori charter Regular School Yes Elementary PK 06 2018   grade_6                                                   19                                             19
3088918 3088918 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002583 145 Appleton Public Montessori charter Regular School Yes Elementary PK 06 2018   kindergarten_4_year_old                                                   20                                             20
3088919 3088919 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002583 145 Appleton Public Montessori charter Regular School Yes Elementary PK 06 2018   kindergarten                                                   20                                             20
3088920 3088920 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002964 490 Appleton Technical Academy charter Career and Technical School Yes High 09 12 2018   pk_12_total 60.0 4.0 11.0     2.0             72.0 5.0             22     24   77 60 4 11     2             72 5         22   24   77
3088921 3088921 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002964 490 Appleton Technical Academy charter Career and Technical School Yes High 09 12 2018   grade_10                                                   20                                             20
3088922 3088922 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002964 490 Appleton Technical Academy charter Career and Technical School Yes High 09 12 2018   grade_11                                                   16                                             16
3088923 3088923 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002964 490 Appleton Technical Academy charter Career and Technical School Yes High 09 12 2018   grade_12                                                   22                                             22
3088924 3088924 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002964 490 Appleton Technical Academy charter Career and Technical School Yes High 09 12 2018   grade_9                                                   19                                             19
3088925 3088925 WI Outagamie   school 5500390 147 Public school Appleton Area 550039003021 820 Appleview   Special Education School No Other PK 12 2018   pk_12_total 26.0 1.0 1.0                   20.0 8.0             4     *   28 26 1 1                   20 8         4       28
3088926 3088926 WI Outagamie   school 5500390 147 Public school Appleton Area 550039003021 820 Appleview   Special Education School No Other PK 12 2018   pre_kindergarten                                                   28                                             28
3088927 3088927 WI Outagamie   school 5500390 147 Public school Appleton Area 550039000049 60 Badger Elementary   Regular School No Elementary PK 06 2018   pk_12_total 181.0 28.0 58.0 5.0   48.0         25.0   166.0 179.0             167     61   345 181 28 58 5   48         25   166 179         167   61   345
3088928 3088928 WI Outagamie   school 5500390 147 Public school Appleton Area 550039000049 60 Badger Elementary   Regular School No Elementary PK 06 2018   grade_1                                                   59                                             59
3088929 3088929 WI Outagamie   school 5500390 147 Public school Appleton Area 550039000049 60 Badger Elementary   Regular School No Elementary PK 06 2018   grade_2                                                   43                                             43
3088930 3088930 WI Outagamie   school 5500390 147 Public school Appleton Area 550039000049 60 Badger Elementary   Regular School No Elementary PK 06 2018   grade_3                                                   47                                             47
3088931 3088931 WI Outagamie   school 5500390 147 Public school Appleton Area 550039000049 60 Badger Elementary   Regular School No Elementary PK 06 2018   grade_4                                                   60                                             60
3088932 3088932 WI Outagamie   school 5500390 147 Public school Appleton Area 550039000049 60 Badger Elementary   Regular School No Elementary PK 06 2018   grade_5                                                   46                                             46
3088933 3088933 WI Outagamie   school 5500390 147 Public school Appleton Area 550039000049 60 Badger Elementary   Regular School No Elementary PK 06 2018   grade_6                                                   34                                             34
3088934 3088934 WI Outagamie   school 5500390 147 Public school Appleton Area 550039000049 60 Badger Elementary   Regular School No Elementary PK 06 2018   kindergarten                                                   56                                             56
3088935 3088935 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002427 220 Berry Elementary   Regular School No Elementary PK 06 2018   pk_12_total 382.0 7.0 17.0     20.0         12.0   241.0 197.0             63     73   438 382 7 17     20         12   241 197         63   73   438
3088936 3088936 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002427 220 Berry Elementary   Regular School No Elementary PK 06 2018   grade_1                                                   61                                             61

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