enrollments

Data source: Big Local News · About: Big Local

14,806 rows where state = "WI" and year = 2020 sorted by district_nces_id

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2020 · 14,806 ✖
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
2323768 2323768 WI Waukesha   school 5500013 3862 Public school Lake Country 550001300578 30 Lake Country School   Regular School No Elementary PK 08 2020   pk_12_total 450.0 6.0 28.0 1.0   21.0         27.0   284.0 249.0             55     58   533 450 6 28 1   21         27   284 249         55   58   533
2323769 2323769 WI Waukesha   school 5500013 3862 Public school Lake Country 550001300578 30 Lake Country School   Regular School No Elementary PK 08 2020   grade_1                                                   49                                             49
2323770 2323770 WI Waukesha   school 5500013 3862 Public school Lake Country 550001300578 30 Lake Country School   Regular School No Elementary PK 08 2020   grade_2                                                   52                                             52
2323771 2323771 WI Waukesha   school 5500013 3862 Public school Lake Country 550001300578 30 Lake Country School   Regular School No Elementary PK 08 2020   grade_3                                                   57                                             57
2323772 2323772 WI Waukesha   school 5500013 3862 Public school Lake Country 550001300578 30 Lake Country School   Regular School No Elementary PK 08 2020   grade_4                                                   49                                             49
2323773 2323773 WI Waukesha   school 5500013 3862 Public school Lake Country 550001300578 30 Lake Country School   Regular School No Elementary PK 08 2020   grade_5                                                   50                                             50
2323774 2323774 WI Waukesha   school 5500013 3862 Public school Lake Country 550001300578 30 Lake Country School   Regular School No Elementary PK 08 2020   grade_6                                                   67                                             67
2323775 2323775 WI Waukesha   school 5500013 3862 Public school Lake Country 550001300578 30 Lake Country School   Regular School No Elementary PK 08 2020   grade_7                                                   65                                             65
2323776 2323776 WI Waukesha   school 5500013 3862 Public school Lake Country 550001300578 30 Lake Country School   Regular School No Elementary PK 08 2020   grade_8                                                   59                                             59
2323777 2323777 WI Waukesha   school 5500013 3862 Public school Lake Country 550001300578 30 Lake Country School   Regular School No Elementary PK 08 2020   kindergarten_4_year_old                                                   35                                             35
2323778 2323778 WI Waukesha   school 5500013 3862 Public school Lake Country 550001300578 30 Lake Country School   Regular School No Elementary PK 08 2020   kindergarten                                                   44                                             44
2323779 2323779 WI Waukesha   school 5500013 3862 Public school Lake Country 550001300578 30 Lake Country School   Regular School No Elementary PK 08 2020   pre_kindergarten                                                   6                                             6
2319298 2319298 WI Trempealeau   school 5500016 485 Public school Blair-Taylor 550001602380 34 Blair-Taylor Elementary   Regular School No Elementary PK 06 2020   pk_12_total 322.0 5.0 13.0 1.0   2.0         7.0   172.0 178.0             163     63   350 322 5 13 1   2         7   172 178         163   63   350
2319299 2319299 WI Trempealeau   school 5500016 485 Public school Blair-Taylor 550001602380 34 Blair-Taylor Elementary   Regular School No Elementary PK 06 2020   grade_1                                                   49                                             49
2319300 2319300 WI Trempealeau   school 5500016 485 Public school Blair-Taylor 550001602380 34 Blair-Taylor Elementary   Regular School No Elementary PK 06 2020   grade_2                                                   41                                             41
2319301 2319301 WI Trempealeau   school 5500016 485 Public school Blair-Taylor 550001602380 34 Blair-Taylor Elementary   Regular School No Elementary PK 06 2020   grade_3                                                   49                                             49
2319302 2319302 WI Trempealeau   school 5500016 485 Public school Blair-Taylor 550001602380 34 Blair-Taylor Elementary   Regular School No Elementary PK 06 2020   grade_4                                                   42                                             42
2319303 2319303 WI Trempealeau   school 5500016 485 Public school Blair-Taylor 550001602380 34 Blair-Taylor Elementary   Regular School No Elementary PK 06 2020   grade_5                                                   38                                             38
2319304 2319304 WI Trempealeau   school 5500016 485 Public school Blair-Taylor 550001602380 34 Blair-Taylor Elementary   Regular School No Elementary PK 06 2020   grade_6                                                   50                                             50
2319305 2319305 WI Trempealeau   school 5500016 485 Public school Blair-Taylor 550001602380 34 Blair-Taylor Elementary   Regular School No Elementary PK 06 2020   kindergarten_4_year_old                                                   35                                             35
2319306 2319306 WI Trempealeau   school 5500016 485 Public school Blair-Taylor 550001602380 34 Blair-Taylor Elementary   Regular School No Elementary PK 06 2020   kindergarten                                                   38                                             38
2319307 2319307 WI Trempealeau   school 5500016 485 Public school Blair-Taylor 550001602380 34 Blair-Taylor Elementary   Regular School No Elementary PK 06 2020   pre_kindergarten                                                   8                                             8
2319308 2319308 WI Trempealeau   school 5500016 485 Public school Blair-Taylor 550001602378 11 Blair-Taylor Middle/High   Regular School No High 07 12 2020   pk_12_total 268.0 4.0 14.0 3.0   1.0         4.0   148.0 146.0             127     46   294 268 4 14 3   1         4   148 146         127   46   294
2319309 2319309 WI Trempealeau   school 5500016 485 Public school Blair-Taylor 550001602378 11 Blair-Taylor Middle/High   Regular School No High 07 12 2020   grade_10                                                   50                                             50
2319310 2319310 WI Trempealeau   school 5500016 485 Public school Blair-Taylor 550001602378 11 Blair-Taylor Middle/High   Regular School No High 07 12 2020   grade_11                                                   54                                             54
2319311 2319311 WI Trempealeau   school 5500016 485 Public school Blair-Taylor 550001602378 11 Blair-Taylor Middle/High   Regular School No High 07 12 2020   grade_12                                                   44                                             44
2319312 2319312 WI Trempealeau   school 5500016 485 Public school Blair-Taylor 550001602378 11 Blair-Taylor Middle/High   Regular School No High 07 12 2020   grade_7                                                   55                                             55
2319313 2319313 WI Trempealeau   school 5500016 485 Public school Blair-Taylor 550001602378 11 Blair-Taylor Middle/High   Regular School No High 07 12 2020   grade_8                                                   44                                             44
2319314 2319314 WI Trempealeau   school 5500016 485 Public school Blair-Taylor 550001602378 11 Blair-Taylor Middle/High   Regular School No High 07 12 2020   grade_9                                                   47                                             47
2329417 2329417 WI Grant   school 5500017 4904 Public school River Ridge 550001700684 20 River Ridge Elementary   Regular School No Elementary PK 04 2020   pk_12_total 174.0 4.0 12.0     1.0         6.0   102.0 95.0             100     29   197 174 4 12     1         6   102 95         100   29   197
2329418 2329418 WI Grant   school 5500017 4904 Public school River Ridge 550001700684 20 River Ridge Elementary   Regular School No Elementary PK 04 2020   grade_1                                                   32                                             32
2329419 2329419 WI Grant   school 5500017 4904 Public school River Ridge 550001700684 20 River Ridge Elementary   Regular School No Elementary PK 04 2020   grade_2                                                   36                                             36
2329420 2329420 WI Grant   school 5500017 4904 Public school River Ridge 550001700684 20 River Ridge Elementary   Regular School No Elementary PK 04 2020   grade_3                                                   33                                             33
2329421 2329421 WI Grant   school 5500017 4904 Public school River Ridge 550001700684 20 River Ridge Elementary   Regular School No Elementary PK 04 2020   grade_4                                                   38                                             38
2329422 2329422 WI Grant   school 5500017 4904 Public school River Ridge 550001700684 20 River Ridge Elementary   Regular School No Elementary PK 04 2020   kindergarten_4_year_old                                                   29                                             29
2329423 2329423 WI Grant   school 5500017 4904 Public school River Ridge 550001700684 20 River Ridge Elementary   Regular School No Elementary PK 04 2020   kindergarten                                                   24                                             24
2329424 2329424 WI Grant   school 5500017 4904 Public school River Ridge 550001700684 20 River Ridge Elementary   Regular School No Elementary PK 04 2020   pre_kindergarten                                                   5                                             5
2329425 2329425 WI Grant   school 5500017 4904 Public school River Ridge 550001700686 80 River Ridge High   Regular School No High 09 12 2020   pk_12_total 184.0   12.0 2.0             2.0   109.0 91.0             91     20   200 184   12 2             2   109 91         91   20   200
2329426 2329426 WI Grant   school 5500017 4904 Public school River Ridge 550001700686 80 River Ridge High   Regular School No High 09 12 2020   grade_10                                                   53                                             53
2329427 2329427 WI Grant   school 5500017 4904 Public school River Ridge 550001700686 80 River Ridge High   Regular School No High 09 12 2020   grade_11                                                   46                                             46
2329428 2329428 WI Grant   school 5500017 4904 Public school River Ridge 550001700686 80 River Ridge High   Regular School No High 09 12 2020   grade_12                                                   49                                             49
2329429 2329429 WI Grant   school 5500017 4904 Public school River Ridge 550001700686 80 River Ridge High   Regular School No High 09 12 2020   grade_9                                                   52                                             52
2329430 2329430 WI Grant   school 5500017 4904 Public school River Ridge 550001700685 40 River Ridge Middle   Regular School No Middle 05 08 2020   pk_12_total 131.0   12.0     1.0         4.0   69.0 79.0             74     19   148 131   12     1         4   69 79         74   19   148
2329431 2329431 WI Grant   school 5500017 4904 Public school River Ridge 550001700685 40 River Ridge Middle   Regular School No Middle 05 08 2020   grade_5                                                   39                                             39
2329432 2329432 WI Grant   school 5500017 4904 Public school River Ridge 550001700685 40 River Ridge Middle   Regular School No Middle 05 08 2020   grade_6                                                   35                                             35
2329433 2329433 WI Grant   school 5500017 4904 Public school River Ridge 550001700685 40 River Ridge Middle   Regular School No Middle 05 08 2020   grade_7                                                   40                                             40
2329434 2329434 WI Grant   school 5500017 4904 Public school River Ridge 550001700685 40 River Ridge Middle   Regular School No Middle 05 08 2020   grade_8                                                   34                                             34
2318131 2318131 WI Clark   school 5500030 7 Public school Abbotsford 550003000001 20 Abbotsford Elementary   Regular School No Elementary PK 05 2020   pk_12_total 139.0 3.0 217.0     1.0         3.0   195.0 168.0             285     51   363 139 3 217     1         3   195 168         285   51   363
2318132 2318132 WI Clark   school 5500030 7 Public school Abbotsford 550003000001 20 Abbotsford Elementary   Regular School No Elementary PK 05 2020   grade_1                                                   55                                             55
2318133 2318133 WI Clark   school 5500030 7 Public school Abbotsford 550003000001 20 Abbotsford Elementary   Regular School No Elementary PK 05 2020   grade_2                                                   58                                             58
2318134 2318134 WI Clark   school 5500030 7 Public school Abbotsford 550003000001 20 Abbotsford Elementary   Regular School No Elementary PK 05 2020   grade_3                                                   55                                             55
2318135 2318135 WI Clark   school 5500030 7 Public school Abbotsford 550003000001 20 Abbotsford Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   50                                             50
2318136 2318136 WI Clark   school 5500030 7 Public school Abbotsford 550003000001 20 Abbotsford Elementary   Regular School No Elementary PK 05 2020   grade_5                                                   58                                             58
2318137 2318137 WI Clark   school 5500030 7 Public school Abbotsford 550003000001 20 Abbotsford Elementary   Regular School No Elementary PK 05 2020   kindergarten_4_year_old                                                   46                                             46
2318138 2318138 WI Clark   school 5500030 7 Public school Abbotsford 550003000001 20 Abbotsford Elementary   Regular School No Elementary PK 05 2020   kindergarten                                                   40                                             40
2318139 2318139 WI Clark   school 5500030 7 Public school Abbotsford 550003000001 20 Abbotsford Elementary   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   1                                             1
2318140 2318140 WI Clark   school 5500030 7 Public school Abbotsford 550003000002 40 Abbotsford Middle/Senior High   Regular School No High 06 12 2020   pk_12_total 186.0 4.0 189.0     1.0         2.0   194.0 188.0             246     49   382 186 4 189     1         2   194 188         246   49   382
2318141 2318141 WI Clark   school 5500030 7 Public school Abbotsford 550003000002 40 Abbotsford Middle/Senior High   Regular School No High 06 12 2020   grade_10                                                   49                                             49
2318142 2318142 WI Clark   school 5500030 7 Public school Abbotsford 550003000002 40 Abbotsford Middle/Senior High   Regular School No High 06 12 2020   grade_11                                                   50                                             50
2318143 2318143 WI Clark   school 5500030 7 Public school Abbotsford 550003000002 40 Abbotsford Middle/Senior High   Regular School No High 06 12 2020   grade_12                                                   44                                             44
2318144 2318144 WI Clark   school 5500030 7 Public school Abbotsford 550003000002 40 Abbotsford Middle/Senior High   Regular School No High 06 12 2020   grade_6                                                   54                                             54
2318145 2318145 WI Clark   school 5500030 7 Public school Abbotsford 550003000002 40 Abbotsford Middle/Senior High   Regular School No High 06 12 2020   grade_7                                                   67                                             67
2318146 2318146 WI Clark   school 5500030 7 Public school Abbotsford 550003000002 40 Abbotsford Middle/Senior High   Regular School No High 06 12 2020   grade_8                                                   59                                             59
2318147 2318147 WI Clark   school 5500030 7 Public school Abbotsford 550003000002 40 Abbotsford Middle/Senior High   Regular School No High 06 12 2020   grade_9                                                   59                                             59
2320623 2320623 WI Milwaukee   school 5500039 8101 Non District Charter Schools Downtown Montessori 550003902153 1056 Downtown Montessori charter Regular School Yes Elementary PK 08 2020   pk_12_total 212.0 23.0 53.0 3.0   5.0       1.0 16.0   147.0 166.0             57     13   313 212 23 53 3   5       1 16   147 166         57   13   313
2320624 2320624 WI Milwaukee   school 5500039 8101 Non District Charter Schools Downtown Montessori 550003902153 1056 Downtown Montessori charter Regular School Yes Elementary PK 08 2020   grade_1                                                   37                                             37
2320625 2320625 WI Milwaukee   school 5500039 8101 Non District Charter Schools Downtown Montessori 550003902153 1056 Downtown Montessori charter Regular School Yes Elementary PK 08 2020   grade_2                                                   32                                             32
2320626 2320626 WI Milwaukee   school 5500039 8101 Non District Charter Schools Downtown Montessori 550003902153 1056 Downtown Montessori charter Regular School Yes Elementary PK 08 2020   grade_3                                                   35                                             35
2320627 2320627 WI Milwaukee   school 5500039 8101 Non District Charter Schools Downtown Montessori 550003902153 1056 Downtown Montessori charter Regular School Yes Elementary PK 08 2020   grade_4                                                   30                                             30
2320628 2320628 WI Milwaukee   school 5500039 8101 Non District Charter Schools Downtown Montessori 550003902153 1056 Downtown Montessori charter Regular School Yes Elementary PK 08 2020   grade_5                                                   24                                             24
2320629 2320629 WI Milwaukee   school 5500039 8101 Non District Charter Schools Downtown Montessori 550003902153 1056 Downtown Montessori charter Regular School Yes Elementary PK 08 2020   grade_6                                                   24                                             24
2320630 2320630 WI Milwaukee   school 5500039 8101 Non District Charter Schools Downtown Montessori 550003902153 1056 Downtown Montessori charter Regular School Yes Elementary PK 08 2020   grade_7                                                   15                                             15
2320631 2320631 WI Milwaukee   school 5500039 8101 Non District Charter Schools Downtown Montessori 550003902153 1056 Downtown Montessori charter Regular School Yes Elementary PK 08 2020   grade_8                                                   19                                             19
2320632 2320632 WI Milwaukee   school 5500039 8101 Non District Charter Schools Downtown Montessori 550003902153 1056 Downtown Montessori charter Regular School Yes Elementary PK 08 2020   kindergarten_3_year_old                                                   21                                             21
2320633 2320633 WI Milwaukee   school 5500039 8101 Non District Charter Schools Downtown Montessori 550003902153 1056 Downtown Montessori charter Regular School Yes Elementary PK 08 2020   kindergarten_4_year_old                                                   34                                             34
2320634 2320634 WI Milwaukee   school 5500039 8101 Non District Charter Schools Downtown Montessori 550003902153 1056 Downtown Montessori charter Regular School Yes Elementary PK 08 2020   kindergarten                                                   42                                             42
2319815 2319815 WI Milwaukee   school 5500041 8105 Non District Charter Schools Central City Cyberschool 550004102171 1211 Central City Cyberschool charter Regular School Yes Other PK 10 2020   pk_12_total   458.0 12.0 1.0             3.0   231.0 243.0             *     39   474   458 12 1             3   231 243             39   474
2319816 2319816 WI Milwaukee   school 5500041 8105 Non District Charter Schools Central City Cyberschool 550004102171 1211 Central City Cyberschool charter Regular School Yes Other PK 10 2020   grade_1                                                   40                                             40
2319817 2319817 WI Milwaukee   school 5500041 8105 Non District Charter Schools Central City Cyberschool 550004102171 1211 Central City Cyberschool charter Regular School Yes Other PK 10 2020   grade_10                                                   7                                             7
2319818 2319818 WI Milwaukee   school 5500041 8105 Non District Charter Schools Central City Cyberschool 550004102171 1211 Central City Cyberschool charter Regular School Yes Other PK 10 2020   grade_2                                                   45                                             45
2319819 2319819 WI Milwaukee   school 5500041 8105 Non District Charter Schools Central City Cyberschool 550004102171 1211 Central City Cyberschool charter Regular School Yes Other PK 10 2020   grade_3                                                   39                                             39
2319820 2319820 WI Milwaukee   school 5500041 8105 Non District Charter Schools Central City Cyberschool 550004102171 1211 Central City Cyberschool charter Regular School Yes Other PK 10 2020   grade_4                                                   44                                             44
2319821 2319821 WI Milwaukee   school 5500041 8105 Non District Charter Schools Central City Cyberschool 550004102171 1211 Central City Cyberschool charter Regular School Yes Other PK 10 2020   grade_5                                                   47                                             47
2319822 2319822 WI Milwaukee   school 5500041 8105 Non District Charter Schools Central City Cyberschool 550004102171 1211 Central City Cyberschool charter Regular School Yes Other PK 10 2020   grade_6                                                   50                                             50
2319823 2319823 WI Milwaukee   school 5500041 8105 Non District Charter Schools Central City Cyberschool 550004102171 1211 Central City Cyberschool charter Regular School Yes Other PK 10 2020   grade_7                                                   50                                             50
2319824 2319824 WI Milwaukee   school 5500041 8105 Non District Charter Schools Central City Cyberschool 550004102171 1211 Central City Cyberschool charter Regular School Yes Other PK 10 2020   grade_8                                                   50                                             50
2319825 2319825 WI Milwaukee   school 5500041 8105 Non District Charter Schools Central City Cyberschool 550004102171 1211 Central City Cyberschool charter Regular School Yes Other PK 10 2020   grade_9                                                   44                                             44
2319826 2319826 WI Milwaukee   school 5500041 8105 Non District Charter Schools Central City Cyberschool 550004102171 1211 Central City Cyberschool charter Regular School Yes Other PK 10 2020   kindergarten_4_year_old                                                   29                                             29
2319827 2319827 WI Milwaukee   school 5500041 8105 Non District Charter Schools Central City Cyberschool 550004102171 1211 Central City Cyberschool charter Regular School Yes Other PK 10 2020   kindergarten                                                   29                                             29
2326700 2326700 WI Milwaukee   school 5500042 8106 Non District Charter Schools Milwaukee Academy of Science 550004202234 1251 Milwaukee Academy of Science charter Regular School Yes Other PK 12 2020   pk_12_total 4.0 1194.0 15.0 1.0   3.0         3.0   565.0 655.0             1129     97   1220 4 1194 15 1   3         3   565 655         1129   97   1220
2326701 2326701 WI Milwaukee   school 5500042 8106 Non District Charter Schools Milwaukee Academy of Science 550004202234 1251 Milwaukee Academy of Science charter Regular School Yes Other PK 12 2020   grade_1                                                   91                                             91
2326702 2326702 WI Milwaukee   school 5500042 8106 Non District Charter Schools Milwaukee Academy of Science 550004202234 1251 Milwaukee Academy of Science charter Regular School Yes Other PK 12 2020   grade_10                                                   78                                             78
2326703 2326703 WI Milwaukee   school 5500042 8106 Non District Charter Schools Milwaukee Academy of Science 550004202234 1251 Milwaukee Academy of Science charter Regular School Yes Other PK 12 2020   grade_11                                                   41                                             41
2326704 2326704 WI Milwaukee   school 5500042 8106 Non District Charter Schools Milwaukee Academy of Science 550004202234 1251 Milwaukee Academy of Science charter Regular School Yes Other PK 12 2020   grade_12                                                   39                                             39
2326705 2326705 WI Milwaukee   school 5500042 8106 Non District Charter Schools Milwaukee Academy of Science 550004202234 1251 Milwaukee Academy of Science charter Regular School Yes Other PK 12 2020   grade_2                                                   95                                             95
2326706 2326706 WI Milwaukee   school 5500042 8106 Non District Charter Schools Milwaukee Academy of Science 550004202234 1251 Milwaukee Academy of Science charter Regular School Yes Other PK 12 2020   grade_3                                                   115                                             115
2326707 2326707 WI Milwaukee   school 5500042 8106 Non District Charter Schools Milwaukee Academy of Science 550004202234 1251 Milwaukee Academy of Science charter Regular School Yes Other PK 12 2020   grade_4                                                   106                                             106
2326708 2326708 WI Milwaukee   school 5500042 8106 Non District Charter Schools Milwaukee Academy of Science 550004202234 1251 Milwaukee Academy of Science charter Regular School Yes Other PK 12 2020   grade_5                                                   113                                             113
2326709 2326709 WI Milwaukee   school 5500042 8106 Non District Charter Schools Milwaukee Academy of Science 550004202234 1251 Milwaukee Academy of Science charter Regular School Yes Other PK 12 2020   grade_6                                                   88                                             88
2326710 2326710 WI Milwaukee   school 5500042 8106 Non District Charter Schools Milwaukee Academy of Science 550004202234 1251 Milwaukee Academy of Science charter Regular School Yes Other PK 12 2020   grade_7                                                   90                                             90

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