enrollments

Data source: Big Local News · About: Big Local

14,617 rows where state = "WI" and year = 2016 sorted by school

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2016 · 14,617 ✖
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
281703 281703 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes 1.0 PK 08 2016   pk_12_total 71.0 202.0 139.0     2.0         31.0   219.0 226.0             311     54   445 71 202 139     2         31   219 226         311   54   445
281704 281704 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes 1.0 PK 08 2016   grade_1                                                   50                                             50
281705 281705 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes 1.0 PK 08 2016   grade_2                                                   59                                             59
281706 281706 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes 1.0 PK 08 2016   grade_3                                                   46                                             46
281707 281707 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes 1.0 PK 08 2016   grade_4                                                   45                                             45
281708 281708 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes 1.0 PK 08 2016   grade_5                                                   40                                             40
281709 281709 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes 1.0 PK 08 2016   grade_6                                                   58                                             58
281710 281710 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes 1.0 PK 08 2016   grade_7                                                   30                                             30
281711 281711 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes 1.0 PK 08 2016   grade_8                                                   25                                             25
281712 281712 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes 1.0 PK 08 2016   kindergarten_4_year_old                                                   41                                             41
281713 281713 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes 1.0 PK 08 2016   kindergarten                                                   51                                             51
288670 288670 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951002818 800 21st Century eSchool charter Regular School Yes 4.0 KG 12 2016   pk_12_total 44.0 1.0 6.0     1.0         4.0   28.0 28.0             14     9   56 44 1 6     1         4   28 28         14   9   56
288671 288671 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951002818 800 21st Century eSchool charter Regular School Yes 4.0 KG 12 2016   grade_10                                                   6                                             6
288672 288672 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951002818 800 21st Century eSchool charter Regular School Yes 4.0 KG 12 2016   grade_11                                                   4                                             4
288673 288673 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951002818 800 21st Century eSchool charter Regular School Yes 4.0 KG 12 2016   grade_12                                                   21                                             21
288674 288674 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951002818 800 21st Century eSchool charter Regular School Yes 4.0 KG 12 2016   grade_2                                                   2                                             2
288675 288675 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951002818 800 21st Century eSchool charter Regular School Yes 4.0 KG 12 2016   grade_3                                                   3                                             3
288676 288676 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951002818 800 21st Century eSchool charter Regular School Yes 4.0 KG 12 2016   grade_4                                                   2                                             2
288677 288677 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951002818 800 21st Century eSchool charter Regular School Yes 4.0 KG 12 2016   grade_5                                                   4                                             4
288678 288678 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951002818 800 21st Century eSchool charter Regular School Yes 4.0 KG 12 2016   grade_6                                                   3                                             3
288679 288679 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951002818 800 21st Century eSchool charter Regular School Yes 4.0 KG 12 2016   grade_7                                                   5                                             5
288680 288680 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951002818 800 21st Century eSchool charter Regular School Yes 4.0 KG 12 2016   grade_8                                                   3                                             3
288681 288681 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951002818 800 21st Century eSchool charter Regular School Yes 4.0 KG 12 2016   grade_9                                                   3                                             3
287059 287059 WI Outagamie   school 5507470 2835 Public school Kimberly Area 550747003029 150 4K Center for Literacy   Regular School No 1.0 PK PK 2016   pk_12_total 290.0 1.0 7.0 1.0   3.0         11.0   149.0 164.0             40     44   313 290 1 7 1   3         11   149 164         40   44   313
287060 287060 WI Outagamie   school 5507470 2835 Public school Kimberly Area 550747003029 150 4K Center for Literacy   Regular School No 1.0 PK PK 2016   kindergarten_4_year_old                                                   301                                             301
287061 287061 WI Outagamie   school 5507470 2835 Public school Kimberly Area 550747003029 150 4K Center for Literacy   Regular School No 1.0 PK PK 2016   pre_kindergarten                                                   12                                             12
283118 283118 WI Racine   school 5501890 777 Public school Burlington Area 550189002987 150 4K Community School   Regular School No 1.0 PK PK 2016   pk_12_total 41.0 1.0 7.0               1.0   23.0 27.0             13     1   50 41 1 7               1   23 27         13   1   50
283119 283119 WI Racine   school 5501890 777 Public school Burlington Area 550189002987 150 4K Community School   Regular School No 1.0 PK PK 2016   kindergarten_4_year_old                                                   50                                             50
292596 292596 WI Sauk   school 5512660 4753 Public school Reedsburg 551266002889 150 4K Community-Based   Regular School No 1.0 PK PK 2016   pk_12_total 85.0 1.0 8.0 1.0   3.0         3.0   51.0 50.0             50     12   101 85 1 8 1   3         3   51 50         50   12   101
292597 292597 WI Sauk   school 5512660 4753 Public school Reedsburg 551266002889 150 4K Community-Based   Regular School No 1.0 PK PK 2016   kindergarten_4_year_old                                                   101                                             101
288280 288280 WI Dane   school 5508910 3381 Public school McFarland 550891002902 150 4K McFarland   Regular School No 1.0 PK PK 2016   pk_12_total 109.0   2.0     4.0         10.0   67.0 58.0             6     11   125 109   2     4         10   67 58         6   11   125
288281 288281 WI Dane   school 5508910 3381 Public school McFarland 550891002902 150 4K McFarland   Regular School No 1.0 PK PK 2016   kindergarten_4_year_old                                                   125                                             125
287615 287615 WI Dane   school 5508520 3269 Public school Madison Metropolitan 550852002475 190 4K PK Off Site   Regular School No 1.0 PK PK 2016   pk_12_total 383.0 153.0 176.0     57.0         84.0   443.0 410.0             47     134   853 383 153 176     57         84   443 410         47   134   853
287616 287616 WI Dane   school 5508520 3269 Public school Madison Metropolitan 550852002475 190 4K PK Off Site   Regular School No 1.0 PK PK 2016   kindergarten_4_year_old                                                   766                                             766
287617 287617 WI Dane   school 5508520 3269 Public school Madison Metropolitan 550852002475 190 4K PK Off Site   Regular School No 1.0 PK PK 2016   pre_kindergarten                                                   87                                             87
287131 287131 WI La Crosse   school 5507530 2849 Public school La Crosse 550753002950 440 7 Rivers Community High School charter Alternative Education School Yes 4.0 09 11 2016   pk_12_total 24.0 1.0   1.0   3.0         2.0   12.0 19.0             17     4   31 24 1   1   3         2   12 19         17   4   31
287132 287132 WI La Crosse   school 5507530 2849 Public school La Crosse 550753002950 440 7 Rivers Community High School charter Alternative Education School Yes 4.0 09 11 2016   grade_10                                                   11                                             11
287133 287133 WI La Crosse   school 5507530 2849 Public school La Crosse 550753002950 440 7 Rivers Community High School charter Alternative Education School Yes 4.0 09 11 2016   grade_11                                                   9                                             9
287134 287134 WI La Crosse   school 5507530 2849 Public school La Crosse 550753002950 440 7 Rivers Community High School charter Alternative Education School Yes 4.0 09 11 2016   grade_9                                                   11                                             11
295158 295158 WI Marathon   school 5515900 6223 Public school Wausau 551590002455 10 A C Kiefer Educational Center   Regular School No 1.0 PK KG 2016   pk_12_total 258.0 17.0 23.0 3.0   47.0         9.0   196.0 161.0             79     91   357 258 17 23 3   47         9   196 161         79   91   357
295159 295159 WI Marathon   school 5515900 6223 Public school Wausau 551590002455 10 A C Kiefer Educational Center   Regular School No 1.0 PK KG 2016   kindergarten_4_year_old                                                   300                                             300
295160 295160 WI Marathon   school 5515900 6223 Public school Wausau 551590002455 10 A C Kiefer Educational Center   Regular School No 1.0 PK KG 2016   pre_kindergarten                                                   57                                             57
290643 290643 WI Winnebago   school 5510320 3892 Public school Neenah Joint 551032003366 125 ACE Charter School charter Regular School Yes 1.0 KG 05 2016   pk_12_total 103.0   4.0     6.0         3.0   74.0 42.0             11     7   116 103   4     6         3   74 42         11   7   116
290644 290644 WI Winnebago   school 5510320 3892 Public school Neenah Joint 551032003366 125 ACE Charter School charter Regular School Yes 1.0 KG 05 2016   grade_1                                                   17                                             17
290645 290645 WI Winnebago   school 5510320 3892 Public school Neenah Joint 551032003366 125 ACE Charter School charter Regular School Yes 1.0 KG 05 2016   grade_2                                                   21                                             21
290646 290646 WI Winnebago   school 5510320 3892 Public school Neenah Joint 551032003366 125 ACE Charter School charter Regular School Yes 1.0 KG 05 2016   grade_3                                                   20                                             20
290647 290647 WI Winnebago   school 5510320 3892 Public school Neenah Joint 551032003366 125 ACE Charter School charter Regular School Yes 1.0 KG 05 2016   grade_4                                                   19                                             19
290648 290648 WI Winnebago   school 5510320 3892 Public school Neenah Joint 551032003366 125 ACE Charter School charter Regular School Yes 1.0 KG 05 2016   grade_5                                                   17                                             17
290649 290649 WI Winnebago   school 5510320 3892 Public school Neenah Joint 551032003366 125 ACE Charter School charter Regular School Yes 1.0 KG 05 2016   kindergarten                                                   22                                             22
288791 288791 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960003371 162 ALBA - Academia de Lenguaje y Bellas Artes charter Regular School Yes 1.0 PK 05 2016   pk_12_total 4.0 3.0 440.0     1.0       1.0     232.0 217.0             24     75   449 4 3 440     1       1     232 217         24   75   449
288792 288792 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960003371 162 ALBA - Academia de Lenguaje y Bellas Artes charter Regular School Yes 1.0 PK 05 2016   grade_1                                                   69                                             69
288793 288793 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960003371 162 ALBA - Academia de Lenguaje y Bellas Artes charter Regular School Yes 1.0 PK 05 2016   grade_2                                                   51                                             51
288794 288794 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960003371 162 ALBA - Academia de Lenguaje y Bellas Artes charter Regular School Yes 1.0 PK 05 2016   grade_3                                                   49                                             49
288795 288795 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960003371 162 ALBA - Academia de Lenguaje y Bellas Artes charter Regular School Yes 1.0 PK 05 2016   grade_4                                                   37                                             37
288796 288796 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960003371 162 ALBA - Academia de Lenguaje y Bellas Artes charter Regular School Yes 1.0 PK 05 2016   grade_5                                                   34                                             34
288797 288797 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960003371 162 ALBA - Academia de Lenguaje y Bellas Artes charter Regular School Yes 1.0 PK 05 2016   kindergarten_3_year_old                                                   49                                             49
288798 288798 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960003371 162 ALBA - Academia de Lenguaje y Bellas Artes charter Regular School Yes 1.0 PK 05 2016   kindergarten_4_year_old                                                   73                                             73
288799 288799 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960003371 162 ALBA - Academia de Lenguaje y Bellas Artes charter Regular School Yes 1.0 PK 05 2016   kindergarten                                                   87                                             87
286330 286330 WI Rock   school 5507020 2695 Public school Janesville 550702002991 860 ARISE Virtual Academy charter Regular School Yes 4.0 KG 12 2016   pk_12_total 81.0 1.0 5.0 1.0   1.0         4.0   33.0 60.0             42     5   93 81 1 5 1   1         4   33 60         42   5   93
286331 286331 WI Rock   school 5507020 2695 Public school Janesville 550702002991 860 ARISE Virtual Academy charter Regular School Yes 4.0 KG 12 2016   grade_10                                                   10                                             10
286332 286332 WI Rock   school 5507020 2695 Public school Janesville 550702002991 860 ARISE Virtual Academy charter Regular School Yes 4.0 KG 12 2016   grade_11                                                   28                                             28
286333 286333 WI Rock   school 5507020 2695 Public school Janesville 550702002991 860 ARISE Virtual Academy charter Regular School Yes 4.0 KG 12 2016   grade_12                                                   30                                             30
286334 286334 WI Rock   school 5507020 2695 Public school Janesville 550702002991 860 ARISE Virtual Academy charter Regular School Yes 4.0 KG 12 2016   grade_2                                                   2                                             2
286335 286335 WI Rock   school 5507020 2695 Public school Janesville 550702002991 860 ARISE Virtual Academy charter Regular School Yes 4.0 KG 12 2016   grade_4                                                   2                                             2
286336 286336 WI Rock   school 5507020 2695 Public school Janesville 550702002991 860 ARISE Virtual Academy charter Regular School Yes 4.0 KG 12 2016   grade_5                                                   3                                             3
286337 286337 WI Rock   school 5507020 2695 Public school Janesville 550702002991 860 ARISE Virtual Academy charter Regular School Yes 4.0 KG 12 2016   grade_6                                                   2                                             2
286338 286338 WI Rock   school 5507020 2695 Public school Janesville 550702002991 860 ARISE Virtual Academy charter Regular School Yes 4.0 KG 12 2016   grade_7                                                   3                                             3
286339 286339 WI Rock   school 5507020 2695 Public school Janesville 550702002991 860 ARISE Virtual Academy charter Regular School Yes 4.0 KG 12 2016   grade_8                                                   5                                             5
286340 286340 WI Rock   school 5507020 2695 Public school Janesville 550702002991 860 ARISE Virtual Academy charter Regular School Yes 4.0 KG 12 2016   grade_9                                                   5                                             5
286341 286341 WI Rock   school 5507020 2695 Public school Janesville 550702002991 860 ARISE Virtual Academy charter Regular School Yes 4.0 KG 12 2016   kindergarten                                                   3                                             3
288825 288825 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960000792 1063 ASSATA   Alternative Education School No 3.0 09 12 2016   pk_12_total 2.0 110.0 3.0               5.0   53.0 67.0             102     18   120 2 110 3               5   53 67         102   18   120
288826 288826 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960000792 1063 ASSATA   Alternative Education School No 3.0 09 12 2016   grade_10                                                   36                                             36
288827 288827 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960000792 1063 ASSATA   Alternative Education School No 3.0 09 12 2016   grade_11                                                   34                                             34
288828 288828 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960000792 1063 ASSATA   Alternative Education School No 3.0 09 12 2016   grade_12                                                   16                                             16
288829 288829 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960000792 1063 ASSATA   Alternative Education School No 3.0 09 12 2016   grade_9                                                   34                                             34
281714 281714 WI Clark   school 5500030 7 Public school Abbotsford 550003000001 20 Abbotsford Elementary   Regular School No 1.0 PK 05 2016   pk_12_total 182.0 5.0 187.0 1.0   1.0         1.0   198.0 179.0             256     36   377 182 5 187 1   1         1   198 179         256   36   377
281715 281715 WI Clark   school 5500030 7 Public school Abbotsford 550003000001 20 Abbotsford Elementary   Regular School No 1.0 PK 05 2016   grade_1                                                   50                                             50
281716 281716 WI Clark   school 5500030 7 Public school Abbotsford 550003000001 20 Abbotsford Elementary   Regular School No 1.0 PK 05 2016   grade_2                                                   49                                             49
281717 281717 WI Clark   school 5500030 7 Public school Abbotsford 550003000001 20 Abbotsford Elementary   Regular School No 1.0 PK 05 2016   grade_3                                                   64                                             64
281718 281718 WI Clark   school 5500030 7 Public school Abbotsford 550003000001 20 Abbotsford Elementary   Regular School No 1.0 PK 05 2016   grade_4                                                   54                                             54
281719 281719 WI Clark   school 5500030 7 Public school Abbotsford 550003000001 20 Abbotsford Elementary   Regular School No 1.0 PK 05 2016   grade_5                                                   51                                             51
281720 281720 WI Clark   school 5500030 7 Public school Abbotsford 550003000001 20 Abbotsford Elementary   Regular School No 1.0 PK 05 2016   kindergarten_4_year_old                                                   55                                             55
281721 281721 WI Clark   school 5500030 7 Public school Abbotsford 550003000001 20 Abbotsford Elementary   Regular School No 1.0 PK 05 2016   kindergarten                                                   53                                             53
281722 281722 WI Clark   school 5500030 7 Public school Abbotsford 550003000001 20 Abbotsford Elementary   Regular School No 1.0 PK 05 2016   pre_kindergarten                                                   1                                             1
281723 281723 WI Clark   school 5500030 7 Public school Abbotsford 550003000002 40 Abbotsford Middle/Senior High   Regular School No 4.0 06 12 2016   pk_12_total 203.0 5.0 121.0     3.0         4.0   176.0 160.0             197     34   336 203 5 121     3         4   176 160         197   34   336
281724 281724 WI Clark   school 5500030 7 Public school Abbotsford 550003000002 40 Abbotsford Middle/Senior High   Regular School No 4.0 06 12 2016   grade_10                                                   47                                             47
281725 281725 WI Clark   school 5500030 7 Public school Abbotsford 550003000002 40 Abbotsford Middle/Senior High   Regular School No 4.0 06 12 2016   grade_11                                                   43                                             43
281726 281726 WI Clark   school 5500030 7 Public school Abbotsford 550003000002 40 Abbotsford Middle/Senior High   Regular School No 4.0 06 12 2016   grade_12                                                   51                                             51
281727 281727 WI Clark   school 5500030 7 Public school Abbotsford 550003000002 40 Abbotsford Middle/Senior High   Regular School No 4.0 06 12 2016   grade_6                                                   49                                             49
281728 281728 WI Clark   school 5500030 7 Public school Abbotsford 550003000002 40 Abbotsford Middle/Senior High   Regular School No 4.0 06 12 2016   grade_7                                                   50                                             50
281729 281729 WI Clark   school 5500030 7 Public school Abbotsford 550003000002 40 Abbotsford Middle/Senior High   Regular School No 4.0 06 12 2016   grade_8                                                   41                                             41
281730 281730 WI Clark   school 5500030 7 Public school Abbotsford 550003000002 40 Abbotsford Middle/Senior High   Regular School No 4.0 06 12 2016   grade_9                                                   55                                             55
290377 290377 WI Green   school 5509840 3682 Public school Monroe 550984002771 10 Abraham Lincoln Elementary   Regular School No 1.0 PK 05 2016   pk_12_total 344.0 5.0 33.0     1.0         6.0   207.0 182.0             179     56   389 344 5 33     1         6   207 182         179   56   389
290378 290378 WI Green   school 5509840 3682 Public school Monroe 550984002771 10 Abraham Lincoln Elementary   Regular School No 1.0 PK 05 2016   grade_1                                                   38                                             38
290379 290379 WI Green   school 5509840 3682 Public school Monroe 550984002771 10 Abraham Lincoln Elementary   Regular School No 1.0 PK 05 2016   grade_2                                                   43                                             43
290380 290380 WI Green   school 5509840 3682 Public school Monroe 550984002771 10 Abraham Lincoln Elementary   Regular School No 1.0 PK 05 2016   grade_3                                                   39                                             39
290381 290381 WI Green   school 5509840 3682 Public school Monroe 550984002771 10 Abraham Lincoln Elementary   Regular School No 1.0 PK 05 2016   grade_4                                                   42                                             42
290382 290382 WI Green   school 5509840 3682 Public school Monroe 550984002771 10 Abraham Lincoln Elementary   Regular School No 1.0 PK 05 2016   grade_5                                                   41                                             41
290383 290383 WI Green   school 5509840 3682 Public school Monroe 550984002771 10 Abraham Lincoln Elementary   Regular School No 1.0 PK 05 2016   kindergarten_4_year_old                                                   146                                             146
290384 290384 WI Green   school 5509840 3682 Public school Monroe 550984002771 10 Abraham Lincoln Elementary   Regular School No 1.0 PK 05 2016   kindergarten                                                   40                                             40

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