enrollments

Data source: Big Local News · About: Big Local

14,653 rows where state = "WI" and year = 2015 sorted by district_nces_id

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2015 · 14,653 ✖
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
117326 117326 WI Waukesha   school 5500013 3862 Public school Lake Country 550001300578 30 Lake Country School   Regular School No 1.0 PK 08 2015   pk_12_total 433.0 5.0 19.0 2.0   15.0         14.0   246.0 242.0             36     49   488 433 5 19 2   15         14   246 242         36   49   488
117327 117327 WI Waukesha   school 5500013 3862 Public school Lake Country 550001300578 30 Lake Country School   Regular School No 1.0 PK 08 2015   grade_1                                                   42                                             42
117328 117328 WI Waukesha   school 5500013 3862 Public school Lake Country 550001300578 30 Lake Country School   Regular School No 1.0 PK 08 2015   grade_2                                                   46                                             46
117329 117329 WI Waukesha   school 5500013 3862 Public school Lake Country 550001300578 30 Lake Country School   Regular School No 1.0 PK 08 2015   grade_3                                                   42                                             42
117330 117330 WI Waukesha   school 5500013 3862 Public school Lake Country 550001300578 30 Lake Country School   Regular School No 1.0 PK 08 2015   grade_4                                                   40                                             40
117331 117331 WI Waukesha   school 5500013 3862 Public school Lake Country 550001300578 30 Lake Country School   Regular School No 1.0 PK 08 2015   grade_5                                                   66                                             66
117332 117332 WI Waukesha   school 5500013 3862 Public school Lake Country 550001300578 30 Lake Country School   Regular School No 1.0 PK 08 2015   grade_6                                                   60                                             60
117333 117333 WI Waukesha   school 5500013 3862 Public school Lake Country 550001300578 30 Lake Country School   Regular School No 1.0 PK 08 2015   grade_7                                                   69                                             69
117334 117334 WI Waukesha   school 5500013 3862 Public school Lake Country 550001300578 30 Lake Country School   Regular School No 1.0 PK 08 2015   grade_8                                                   64                                             64
117335 117335 WI Waukesha   school 5500013 3862 Public school Lake Country 550001300578 30 Lake Country School   Regular School No 1.0 PK 08 2015   kindergarten_4_year_old                                                   28                                             28
117336 117336 WI Waukesha   school 5500013 3862 Public school Lake Country 550001300578 30 Lake Country School   Regular School No 1.0 PK 08 2015   kindergarten                                                   29                                             29
117337 117337 WI Waukesha   school 5500013 3862 Public school Lake Country 550001300578 30 Lake Country School   Regular School No 1.0 PK 08 2015   pre_kindergarten                                                   2                                             2
112919 112919 WI Trempealeau   school 5500016 485 Public school Blair-Taylor 550001602380 34 Blair-Taylor Elementary   Regular School No 1.0 PK 06 2015   pk_12_total 279.0 1.0 10.0 1.0             6.0   151.0 146.0             147     48   297 279 1 10 1             6   151 146         147   48   297
112920 112920 WI Trempealeau   school 5500016 485 Public school Blair-Taylor 550001602380 34 Blair-Taylor Elementary   Regular School No 1.0 PK 06 2015   grade_1                                                   44                                             44
112921 112921 WI Trempealeau   school 5500016 485 Public school Blair-Taylor 550001602380 34 Blair-Taylor Elementary   Regular School No 1.0 PK 06 2015   grade_2                                                   40                                             40
112922 112922 WI Trempealeau   school 5500016 485 Public school Blair-Taylor 550001602380 34 Blair-Taylor Elementary   Regular School No 1.0 PK 06 2015   grade_3                                                   33                                             33
112923 112923 WI Trempealeau   school 5500016 485 Public school Blair-Taylor 550001602380 34 Blair-Taylor Elementary   Regular School No 1.0 PK 06 2015   grade_4                                                   43                                             43
112924 112924 WI Trempealeau   school 5500016 485 Public school Blair-Taylor 550001602380 34 Blair-Taylor Elementary   Regular School No 1.0 PK 06 2015   grade_5                                                   25                                             25
112925 112925 WI Trempealeau   school 5500016 485 Public school Blair-Taylor 550001602380 34 Blair-Taylor Elementary   Regular School No 1.0 PK 06 2015   grade_6                                                   33                                             33
112926 112926 WI Trempealeau   school 5500016 485 Public school Blair-Taylor 550001602380 34 Blair-Taylor Elementary   Regular School No 1.0 PK 06 2015   kindergarten_4_year_old                                                   41                                             41
112927 112927 WI Trempealeau   school 5500016 485 Public school Blair-Taylor 550001602380 34 Blair-Taylor Elementary   Regular School No 1.0 PK 06 2015   kindergarten                                                   33                                             33
112928 112928 WI Trempealeau   school 5500016 485 Public school Blair-Taylor 550001602380 34 Blair-Taylor Elementary   Regular School No 1.0 PK 06 2015   pre_kindergarten                                                   5                                             5
112929 112929 WI Trempealeau   school 5500016 485 Public school Blair-Taylor 550001602378 11 Blair-Taylor Middle/High   Regular School No 3.0 07 12 2015   pk_12_total 250.0 2.0 11.0 1.0   4.0         1.0   128.0 141.0             139     41   269 250 2 11 1   4         1   128 141         139   41   269
112930 112930 WI Trempealeau   school 5500016 485 Public school Blair-Taylor 550001602378 11 Blair-Taylor Middle/High   Regular School No 3.0 07 12 2015   grade_10                                                   38                                             38
112931 112931 WI Trempealeau   school 5500016 485 Public school Blair-Taylor 550001602378 11 Blair-Taylor Middle/High   Regular School No 3.0 07 12 2015   grade_11                                                   55                                             55
112932 112932 WI Trempealeau   school 5500016 485 Public school Blair-Taylor 550001602378 11 Blair-Taylor Middle/High   Regular School No 3.0 07 12 2015   grade_12                                                   46                                             46
112933 112933 WI Trempealeau   school 5500016 485 Public school Blair-Taylor 550001602378 11 Blair-Taylor Middle/High   Regular School No 3.0 07 12 2015   grade_7                                                   50                                             50
112934 112934 WI Trempealeau   school 5500016 485 Public school Blair-Taylor 550001602378 11 Blair-Taylor Middle/High   Regular School No 3.0 07 12 2015   grade_8                                                   47                                             47
112935 112935 WI Trempealeau   school 5500016 485 Public school Blair-Taylor 550001602378 11 Blair-Taylor Middle/High   Regular School No 3.0 07 12 2015   grade_9                                                   33                                             33
112936 112936 WI Trempealeau   school 5500016 485 Public school Blair-Taylor 550001603359 120 SoSET Charter School charter Regular School Yes 1.0 KG 06 2015   pk_12_total 64.0   2.0                   37.0 29.0             22     5   66 64   2                   37 29         22   5   66
112937 112937 WI Trempealeau   school 5500016 485 Public school Blair-Taylor 550001603359 120 SoSET Charter School charter Regular School Yes 1.0 KG 06 2015   grade_1                                                   9                                             9
112938 112938 WI Trempealeau   school 5500016 485 Public school Blair-Taylor 550001603359 120 SoSET Charter School charter Regular School Yes 1.0 KG 06 2015   grade_2                                                   12                                             12
112939 112939 WI Trempealeau   school 5500016 485 Public school Blair-Taylor 550001603359 120 SoSET Charter School charter Regular School Yes 1.0 KG 06 2015   grade_3                                                   11                                             11
112940 112940 WI Trempealeau   school 5500016 485 Public school Blair-Taylor 550001603359 120 SoSET Charter School charter Regular School Yes 1.0 KG 06 2015   grade_4                                                   10                                             10
112941 112941 WI Trempealeau   school 5500016 485 Public school Blair-Taylor 550001603359 120 SoSET Charter School charter Regular School Yes 1.0 KG 06 2015   grade_5                                                   10                                             10
112942 112942 WI Trempealeau   school 5500016 485 Public school Blair-Taylor 550001603359 120 SoSET Charter School charter Regular School Yes 1.0 KG 06 2015   grade_6                                                   7                                             7
112943 112943 WI Trempealeau   school 5500016 485 Public school Blair-Taylor 550001603359 120 SoSET Charter School charter Regular School Yes 1.0 KG 06 2015   kindergarten                                                   7                                             7
122953 122953 WI Grant   school 5500017 4904 Public school River Ridge 550001700684 20 River Ridge Elementary   Regular School No 1.0 PK 04 2015   pk_12_total 203.0 1.0 14.0               9.0   103.0 124.0             113     36   227 203 1 14               9   103 124         113   36   227
122954 122954 WI Grant   school 5500017 4904 Public school River Ridge 550001700684 20 River Ridge Elementary   Regular School No 1.0 PK 04 2015   grade_1                                                   31                                             31
122955 122955 WI Grant   school 5500017 4904 Public school River Ridge 550001700684 20 River Ridge Elementary   Regular School No 1.0 PK 04 2015   grade_2                                                   34                                             34
122956 122956 WI Grant   school 5500017 4904 Public school River Ridge 550001700684 20 River Ridge Elementary   Regular School No 1.0 PK 04 2015   grade_3                                                   37                                             37
122957 122957 WI Grant   school 5500017 4904 Public school River Ridge 550001700684 20 River Ridge Elementary   Regular School No 1.0 PK 04 2015   grade_4                                                   46                                             46
122958 122958 WI Grant   school 5500017 4904 Public school River Ridge 550001700684 20 River Ridge Elementary   Regular School No 1.0 PK 04 2015   kindergarten_4_year_old                                                   34                                             34
122959 122959 WI Grant   school 5500017 4904 Public school River Ridge 550001700684 20 River Ridge Elementary   Regular School No 1.0 PK 04 2015   kindergarten                                                   42                                             42
122960 122960 WI Grant   school 5500017 4904 Public school River Ridge 550001700684 20 River Ridge Elementary   Regular School No 1.0 PK 04 2015   pre_kindergarten                                                   3                                             3
122961 122961 WI Grant   school 5500017 4904 Public school River Ridge 550001700686 80 River Ridge Middle/High   Regular School No 3.0 07 12 2015   pk_12_total 214.0 1.0 4.0     1.0             108.0 112.0             96     37   220 214 1 4     1             108 112         96   37   220
122962 122962 WI Grant   school 5500017 4904 Public school River Ridge 550001700686 80 River Ridge Middle/High   Regular School No 3.0 07 12 2015   grade_10                                                   30                                             30
122963 122963 WI Grant   school 5500017 4904 Public school River Ridge 550001700686 80 River Ridge Middle/High   Regular School No 3.0 07 12 2015   grade_11                                                   35                                             35
122964 122964 WI Grant   school 5500017 4904 Public school River Ridge 550001700686 80 River Ridge Middle/High   Regular School No 3.0 07 12 2015   grade_12                                                   38                                             38
122965 122965 WI Grant   school 5500017 4904 Public school River Ridge 550001700686 80 River Ridge Middle/High   Regular School No 3.0 07 12 2015   grade_7                                                   46                                             46
122966 122966 WI Grant   school 5500017 4904 Public school River Ridge 550001700686 80 River Ridge Middle/High   Regular School No 3.0 07 12 2015   grade_8                                                   38                                             38
122967 122967 WI Grant   school 5500017 4904 Public school River Ridge 550001700686 80 River Ridge Middle/High   Regular School No 3.0 07 12 2015   grade_9                                                   33                                             33
122968 122968 WI Grant   school 5500017 4904 Public school River Ridge 550001700685 40 River Ridge Upper Elementary   Regular School No 2.0 05 06 2015   pk_12_total 78.0   3.0               2.0   44.0 39.0             36     14   83 78   3               2   44 39         36   14   83
122969 122969 WI Grant   school 5500017 4904 Public school River Ridge 550001700685 40 River Ridge Upper Elementary   Regular School No 2.0 05 06 2015   grade_5                                                   45                                             45
122970 122970 WI Grant   school 5500017 4904 Public school River Ridge 550001700685 40 River Ridge Upper Elementary   Regular School No 2.0 05 06 2015   grade_6                                                   38                                             38
111741 111741 WI Clark   school 5500030 7 Public school Abbotsford 550003000001 20 Abbotsford Elementary   Regular School No 1.0 PK 05 2015   pk_12_total 192.0 5.0 160.0 1.0             1.0   188.0 171.0             254     39   359 192 5 160 1             1   188 171         254   39   359
111742 111742 WI Clark   school 5500030 7 Public school Abbotsford 550003000001 20 Abbotsford Elementary   Regular School No 1.0 PK 05 2015   grade_1                                                   45                                             45
111743 111743 WI Clark   school 5500030 7 Public school Abbotsford 550003000001 20 Abbotsford Elementary   Regular School No 1.0 PK 05 2015   grade_2                                                   65                                             65
111744 111744 WI Clark   school 5500030 7 Public school Abbotsford 550003000001 20 Abbotsford Elementary   Regular School No 1.0 PK 05 2015   grade_3                                                   58                                             58
111745 111745 WI Clark   school 5500030 7 Public school Abbotsford 550003000001 20 Abbotsford Elementary   Regular School No 1.0 PK 05 2015   grade_4                                                   54                                             54
111746 111746 WI Clark   school 5500030 7 Public school Abbotsford 550003000001 20 Abbotsford Elementary   Regular School No 1.0 PK 05 2015   grade_5                                                   45                                             45
111747 111747 WI Clark   school 5500030 7 Public school Abbotsford 550003000001 20 Abbotsford Elementary   Regular School No 1.0 PK 05 2015   kindergarten_4_year_old                                                   41                                             41
111748 111748 WI Clark   school 5500030 7 Public school Abbotsford 550003000001 20 Abbotsford Elementary   Regular School No 1.0 PK 05 2015   kindergarten                                                   51                                             51
111749 111749 WI Clark   school 5500030 7 Public school Abbotsford 550003000002 40 Abbotsford Middle/Senior High   Regular School No 4.0 06 12 2015   pk_12_total 227.0 2.0 117.0     2.0       1.0 10.0   186.0 173.0             223     42   359 227 2 117     2       1 10   186 173         223   42   359
111750 111750 WI Clark   school 5500030 7 Public school Abbotsford 550003000002 40 Abbotsford Middle/Senior High   Regular School No 4.0 06 12 2015   grade_10                                                   43                                             43
111751 111751 WI Clark   school 5500030 7 Public school Abbotsford 550003000002 40 Abbotsford Middle/Senior High   Regular School No 4.0 06 12 2015   grade_11                                                   51                                             51
111752 111752 WI Clark   school 5500030 7 Public school Abbotsford 550003000002 40 Abbotsford Middle/Senior High   Regular School No 4.0 06 12 2015   grade_12                                                   60                                             60
111753 111753 WI Clark   school 5500030 7 Public school Abbotsford 550003000002 40 Abbotsford Middle/Senior High   Regular School No 4.0 06 12 2015   grade_6                                                   57                                             57
111754 111754 WI Clark   school 5500030 7 Public school Abbotsford 550003000002 40 Abbotsford Middle/Senior High   Regular School No 4.0 06 12 2015   grade_7                                                   42                                             42
111755 111755 WI Clark   school 5500030 7 Public school Abbotsford 550003000002 40 Abbotsford Middle/Senior High   Regular School No 4.0 06 12 2015   grade_8                                                   56                                             56
111756 111756 WI Clark   school 5500030 7 Public school Abbotsford 550003000002 40 Abbotsford Middle/Senior High   Regular School No 4.0 06 12 2015   grade_9                                                   50                                             50
114205 114205 WI Milwaukee   school 5500039 8101 Non District Charter Schools Downtown Montessori 550003902153 1056 Downtown Montessori charter Regular School Yes 1.0 PK 08 2015   pk_12_total 144.0 28.0 42.0     11.0       4.0 6.0   120.0 115.0             67     13   235 144 28 42     11       4 6   120 115         67   13   235
114206 114206 WI Milwaukee   school 5500039 8101 Non District Charter Schools Downtown Montessori 550003902153 1056 Downtown Montessori charter Regular School Yes 1.0 PK 08 2015   grade_1                                                   35                                             35
114207 114207 WI Milwaukee   school 5500039 8101 Non District Charter Schools Downtown Montessori 550003902153 1056 Downtown Montessori charter Regular School Yes 1.0 PK 08 2015   grade_2                                                   25                                             25
114208 114208 WI Milwaukee   school 5500039 8101 Non District Charter Schools Downtown Montessori 550003902153 1056 Downtown Montessori charter Regular School Yes 1.0 PK 08 2015   grade_3                                                   25                                             25
114209 114209 WI Milwaukee   school 5500039 8101 Non District Charter Schools Downtown Montessori 550003902153 1056 Downtown Montessori charter Regular School Yes 1.0 PK 08 2015   grade_4                                                   16                                             16
114210 114210 WI Milwaukee   school 5500039 8101 Non District Charter Schools Downtown Montessori 550003902153 1056 Downtown Montessori charter Regular School Yes 1.0 PK 08 2015   grade_5                                                   15                                             15
114211 114211 WI Milwaukee   school 5500039 8101 Non District Charter Schools Downtown Montessori 550003902153 1056 Downtown Montessori charter Regular School Yes 1.0 PK 08 2015   grade_6                                                   16                                             16
114212 114212 WI Milwaukee   school 5500039 8101 Non District Charter Schools Downtown Montessori 550003902153 1056 Downtown Montessori charter Regular School Yes 1.0 PK 08 2015   grade_7                                                   10                                             10
114213 114213 WI Milwaukee   school 5500039 8101 Non District Charter Schools Downtown Montessori 550003902153 1056 Downtown Montessori charter Regular School Yes 1.0 PK 08 2015   grade_8                                                   14                                             14
114214 114214 WI Milwaukee   school 5500039 8101 Non District Charter Schools Downtown Montessori 550003902153 1056 Downtown Montessori charter Regular School Yes 1.0 PK 08 2015   kindergarten_4_year_old                                                   44                                             44
114215 114215 WI Milwaukee   school 5500039 8101 Non District Charter Schools Downtown Montessori 550003902153 1056 Downtown Montessori charter Regular School Yes 1.0 PK 08 2015   kindergarten                                                   35                                             35
113405 113405 WI Milwaukee   school 5500041 8105 Non District Charter Schools Central City Cyberschool 550004102171 1211 Central City Cyberschool charter Regular School Yes 1.0 PK 08 2015   pk_12_total   384.0 5.0 1.0             4.0   197.0 197.0             *     30   394   384 5 1             4   197 197             30   394
113406 113406 WI Milwaukee   school 5500041 8105 Non District Charter Schools Central City Cyberschool 550004102171 1211 Central City Cyberschool charter Regular School Yes 1.0 PK 08 2015   grade_1                                                   36                                             36
113407 113407 WI Milwaukee   school 5500041 8105 Non District Charter Schools Central City Cyberschool 550004102171 1211 Central City Cyberschool charter Regular School Yes 1.0 PK 08 2015   grade_2                                                   43                                             43
113408 113408 WI Milwaukee   school 5500041 8105 Non District Charter Schools Central City Cyberschool 550004102171 1211 Central City Cyberschool charter Regular School Yes 1.0 PK 08 2015   grade_3                                                   46                                             46
113409 113409 WI Milwaukee   school 5500041 8105 Non District Charter Schools Central City Cyberschool 550004102171 1211 Central City Cyberschool charter Regular School Yes 1.0 PK 08 2015   grade_4                                                   46                                             46
113410 113410 WI Milwaukee   school 5500041 8105 Non District Charter Schools Central City Cyberschool 550004102171 1211 Central City Cyberschool charter Regular School Yes 1.0 PK 08 2015   grade_5                                                   41                                             41
113411 113411 WI Milwaukee   school 5500041 8105 Non District Charter Schools Central City Cyberschool 550004102171 1211 Central City Cyberschool charter Regular School Yes 1.0 PK 08 2015   grade_6                                                   31                                             31
113412 113412 WI Milwaukee   school 5500041 8105 Non District Charter Schools Central City Cyberschool 550004102171 1211 Central City Cyberschool charter Regular School Yes 1.0 PK 08 2015   grade_7                                                   50                                             50
113413 113413 WI Milwaukee   school 5500041 8105 Non District Charter Schools Central City Cyberschool 550004102171 1211 Central City Cyberschool charter Regular School Yes 1.0 PK 08 2015   grade_8                                                   41                                             41
113414 113414 WI Milwaukee   school 5500041 8105 Non District Charter Schools Central City Cyberschool 550004102171 1211 Central City Cyberschool charter Regular School Yes 1.0 PK 08 2015   kindergarten_4_year_old                                                   19                                             19
113415 113415 WI Milwaukee   school 5500041 8105 Non District Charter Schools Central City Cyberschool 550004102171 1211 Central City Cyberschool charter Regular School Yes 1.0 PK 08 2015   kindergarten                                                   41                                             41
120246 120246 WI Milwaukee   school 5500042 8106 Non District Charter Schools Milwaukee Academy of Science 550004202234 1251 Milwaukee Academy of Science charter Regular School Yes 4.0 PK 12 2015   pk_12_total 7.0 1000.0 16.0 1.0             2.0   477.0 549.0             679     110   1026 7 1000 16 1             2   477 549         679   110   1026
120247 120247 WI Milwaukee   school 5500042 8106 Non District Charter Schools Milwaukee Academy of Science 550004202234 1251 Milwaukee Academy of Science charter Regular School Yes 4.0 PK 12 2015   grade_1                                                   95                                             95
120248 120248 WI Milwaukee   school 5500042 8106 Non District Charter Schools Milwaukee Academy of Science 550004202234 1251 Milwaukee Academy of Science charter Regular School Yes 4.0 PK 12 2015   grade_10                                                   40                                             40
120249 120249 WI Milwaukee   school 5500042 8106 Non District Charter Schools Milwaukee Academy of Science 550004202234 1251 Milwaukee Academy of Science charter Regular School Yes 4.0 PK 12 2015   grade_11                                                   30                                             30
120250 120250 WI Milwaukee   school 5500042 8106 Non District Charter Schools Milwaukee Academy of Science 550004202234 1251 Milwaukee Academy of Science charter Regular School Yes 4.0 PK 12 2015   grade_12                                                   38                                             38
120251 120251 WI Milwaukee   school 5500042 8106 Non District Charter Schools Milwaukee Academy of Science 550004202234 1251 Milwaukee Academy of Science charter Regular School Yes 4.0 PK 12 2015   grade_2                                                   99                                             99
120252 120252 WI Milwaukee   school 5500042 8106 Non District Charter Schools Milwaukee Academy of Science 550004202234 1251 Milwaukee Academy of Science charter Regular School Yes 4.0 PK 12 2015   grade_3                                                   81                                             81

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