enrollments

Data source: Big Local News · About: Big Local

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

✎ 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
111730 111730 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 2015   pk_12_total 87.0 224.0 107.0     1.0         27.0   222.0 224.0             272     56   446 87 224 107     1         27   222 224         272   56   446
111731 111731 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 2015   grade_1                                                   56                                             56
111732 111732 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 2015   grade_2                                                   54                                             54
111733 111733 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 2015   grade_3                                                   46                                             46
111734 111734 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 2015   grade_4                                                   42                                             42
111735 111735 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 2015   grade_5                                                   52                                             52
111736 111736 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 2015   grade_6                                                   35                                             35
111737 111737 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 2015   grade_7                                                   32                                             32
111738 111738 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 2015   grade_8                                                   40                                             40
111739 111739 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 2015   kindergarten_4_year_old                                                   33                                             33
111740 111740 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 2015   kindergarten                                                   56                                             56
118669 118669 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951002818 800 21st Century eSchool charter Regular School Yes 4.0 KG 12 2015   pk_12_total 34.0 3.0 6.0               4.0   24.0 23.0             5     2   47 34 3 6               4   24 23         5   2   47
118670 118670 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951002818 800 21st Century eSchool charter Regular School Yes 4.0 KG 12 2015   grade_1                                                   1                                             1
118671 118671 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951002818 800 21st Century eSchool charter Regular School Yes 4.0 KG 12 2015   grade_10                                                   2                                             2
118672 118672 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951002818 800 21st Century eSchool charter Regular School Yes 4.0 KG 12 2015   grade_11                                                   4                                             4
118673 118673 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951002818 800 21st Century eSchool charter Regular School Yes 4.0 KG 12 2015   grade_12                                                   20                                             20
118674 118674 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951002818 800 21st Century eSchool charter Regular School Yes 4.0 KG 12 2015   grade_2                                                   2                                             2
118675 118675 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951002818 800 21st Century eSchool charter Regular School Yes 4.0 KG 12 2015   grade_3                                                   2                                             2
118676 118676 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951002818 800 21st Century eSchool charter Regular School Yes 4.0 KG 12 2015   grade_4                                                   3                                             3
118677 118677 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951002818 800 21st Century eSchool charter Regular School Yes 4.0 KG 12 2015   grade_5                                                   3                                             3
118678 118678 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951002818 800 21st Century eSchool charter Regular School Yes 4.0 KG 12 2015   grade_6                                                   3                                             3
118679 118679 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951002818 800 21st Century eSchool charter Regular School Yes 4.0 KG 12 2015   grade_7                                                   1                                             1
118680 118680 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951002818 800 21st Century eSchool charter Regular School Yes 4.0 KG 12 2015   grade_8                                                   2                                             2
118681 118681 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951002818 800 21st Century eSchool charter Regular School Yes 4.0 KG 12 2015   grade_9                                                   3                                             3
118682 118682 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951002818 800 21st Century eSchool charter Regular School Yes 4.0 KG 12 2015   kindergarten                                                   1                                             1
113136 113136 WI Racine   school 5501890 777 Public school Burlington Area 550189002987 150 4K Community School   Regular School No 1.0 PK PK 2015   pk_12_total 56.0 2.0 8.0     2.0         3.0   34.0 37.0             20     4   71 56 2 8     2         3   34 37         20   4   71
113137 113137 WI Racine   school 5501890 777 Public school Burlington Area 550189002987 150 4K Community School   Regular School No 1.0 PK PK 2015   kindergarten_4_year_old                                                   71                                             71
122623 122623 WI Sauk   school 5512660 4753 Public school Reedsburg 551266002889 150 4K Community-Based   Regular School No 1.0 PK PK 2015   pk_12_total 72.0   7.0               1.0   41.0 39.0             31     8   80 72   7               1   41 39         31   8   80
122624 122624 WI Sauk   school 5512660 4753 Public school Reedsburg 551266002889 150 4K Community-Based   Regular School No 1.0 PK PK 2015   kindergarten_4_year_old                                                   80                                             80
118285 118285 WI Dane   school 5508910 3381 Public school McFarland 550891002902 150 4K McFarland   Regular School No 1.0 PK PK 2015   pk_12_total 118.0   8.0     6.0         5.0   82.0 55.0             6     19   137 118   8     6         5   82 55         6   19   137
118286 118286 WI Dane   school 5508910 3381 Public school McFarland 550891002902 150 4K McFarland   Regular School No 1.0 PK PK 2015   kindergarten_4_year_old                                                   137                                             137
117618 117618 WI Dane   school 5508520 3269 Public school Madison Metropolitan 550852002475 190 4K PK Off Site   Regular School No 1.0 PK PK 2015   pk_12_total 396.0 143.0 202.0 3.0   59.0         78.0   466.0 415.0             286     94   881 396 143 202 3   59         78   466 415         286   94   881
117619 117619 WI Dane   school 5508520 3269 Public school Madison Metropolitan 550852002475 190 4K PK Off Site   Regular School No 1.0 PK PK 2015   kindergarten_4_year_old                                                   811                                             811
117620 117620 WI Dane   school 5508520 3269 Public school Madison Metropolitan 550852002475 190 4K PK Off Site   Regular School No 1.0 PK PK 2015   pre_kindergarten                                                   70                                             70
117140 117140 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 10 2015   pk_12_total 33.0   2.0 1.0   3.0         1.0   19.0 21.0             19     3   40 33   2 1   3         1   19 21         19   3   40
117141 117141 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 10 2015   grade_10                                                   14                                             14
117142 117142 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 10 2015   grade_9                                                   26                                             26
125221 125221 WI Marathon   school 5515900 6223 Public school Wausau 551590002455 10 A C Kiefer Educational Center   Regular School No 1.0 PK KG 2015   pk_12_total 283.0 11.0 34.0 2.0   45.0       2.0 10.0   209.0 178.0             126     83   387 283 11 34 2   45       2 10   209 178         126   83   387
125222 125222 WI Marathon   school 5515900 6223 Public school Wausau 551590002455 10 A C Kiefer Educational Center   Regular School No 1.0 PK KG 2015   kindergarten_4_year_old                                                   318                                             318
125223 125223 WI Marathon   school 5515900 6223 Public school Wausau 551590002455 10 A C Kiefer Educational Center   Regular School No 1.0 PK KG 2015   pre_kindergarten                                                   69                                             69
120681 120681 WI Winnebago   school 5510320 3892 Public school Neenah Joint 551032003366 125 ACE Charter School charter Regular School Yes 1.0 KG 05 2015   pk_12_total 105.0 1.0 7.0     4.0         3.0   67.0 53.0             19     10   120 105 1 7     4         3   67 53         19   10   120
120682 120682 WI Winnebago   school 5510320 3892 Public school Neenah Joint 551032003366 125 ACE Charter School charter Regular School Yes 1.0 KG 05 2015   grade_1                                                   23                                             23
120683 120683 WI Winnebago   school 5510320 3892 Public school Neenah Joint 551032003366 125 ACE Charter School charter Regular School Yes 1.0 KG 05 2015   grade_2                                                   19                                             19
120684 120684 WI Winnebago   school 5510320 3892 Public school Neenah Joint 551032003366 125 ACE Charter School charter Regular School Yes 1.0 KG 05 2015   grade_3                                                   21                                             21
120685 120685 WI Winnebago   school 5510320 3892 Public school Neenah Joint 551032003366 125 ACE Charter School charter Regular School Yes 1.0 KG 05 2015   grade_4                                                   16                                             16
120686 120686 WI Winnebago   school 5510320 3892 Public school Neenah Joint 551032003366 125 ACE Charter School charter Regular School Yes 1.0 KG 05 2015   grade_5                                                   20                                             20
120687 120687 WI Winnebago   school 5510320 3892 Public school Neenah Joint 551032003366 125 ACE Charter School charter Regular School Yes 1.0 KG 05 2015   kindergarten                                                   21                                             21
118797 118797 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 2015   pk_12_total 3.0 1.0 422.0     1.0             212.0 215.0             391     66   427 3 1 422     1             212 215         391   66   427
118798 118798 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 2015   grade_1                                                   52                                             52
118799 118799 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 2015   grade_2                                                   47                                             47
118800 118800 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 2015   grade_3                                                   48                                             48
118801 118801 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 2015   grade_4                                                   38                                             38
118802 118802 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 2015   grade_5                                                   33                                             33
118803 118803 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 2015   kindergarten_3_year_old                                                   48                                             48
118804 118804 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 2015   kindergarten_4_year_old                                                   56                                             56
118805 118805 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 2015   kindergarten                                                   80                                             80
118806 118806 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 2015   pre_kindergarten                                                   25                                             25
116331 116331 WI Rock   school 5507020 2695 Public school Janesville 550702002991 860 ARISE Virtual Academy charter Regular School Yes 4.0 KG 12 2015   pk_12_total 70.0 2.0 5.0 1.0   1.0         6.0   35.0 50.0             38     6   85 70 2 5 1   1         6   35 50         38   6   85
116332 116332 WI Rock   school 5507020 2695 Public school Janesville 550702002991 860 ARISE Virtual Academy charter Regular School Yes 4.0 KG 12 2015   grade_1                                                   1                                             1
116333 116333 WI Rock   school 5507020 2695 Public school Janesville 550702002991 860 ARISE Virtual Academy charter Regular School Yes 4.0 KG 12 2015   grade_10                                                   13                                             13
116334 116334 WI Rock   school 5507020 2695 Public school Janesville 550702002991 860 ARISE Virtual Academy charter Regular School Yes 4.0 KG 12 2015   grade_11                                                   29                                             29
116335 116335 WI Rock   school 5507020 2695 Public school Janesville 550702002991 860 ARISE Virtual Academy charter Regular School Yes 4.0 KG 12 2015   grade_12                                                   22                                             22
116336 116336 WI Rock   school 5507020 2695 Public school Janesville 550702002991 860 ARISE Virtual Academy charter Regular School Yes 4.0 KG 12 2015   grade_3                                                   2                                             2
116337 116337 WI Rock   school 5507020 2695 Public school Janesville 550702002991 860 ARISE Virtual Academy charter Regular School Yes 4.0 KG 12 2015   grade_4                                                   3                                             3
116338 116338 WI Rock   school 5507020 2695 Public school Janesville 550702002991 860 ARISE Virtual Academy charter Regular School Yes 4.0 KG 12 2015   grade_5                                                   2                                             2
116339 116339 WI Rock   school 5507020 2695 Public school Janesville 550702002991 860 ARISE Virtual Academy charter Regular School Yes 4.0 KG 12 2015   grade_6                                                   2                                             2
116340 116340 WI Rock   school 5507020 2695 Public school Janesville 550702002991 860 ARISE Virtual Academy charter Regular School Yes 4.0 KG 12 2015   grade_7                                                   3                                             3
116341 116341 WI Rock   school 5507020 2695 Public school Janesville 550702002991 860 ARISE Virtual Academy charter Regular School Yes 4.0 KG 12 2015   grade_8                                                   3                                             3
116342 116342 WI Rock   school 5507020 2695 Public school Janesville 550702002991 860 ARISE Virtual Academy charter Regular School Yes 4.0 KG 12 2015   grade_9                                                   5                                             5
118833 118833 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960000792 1063 ASSATA   Alternative Education School No 3.0 09 12 2015   pk_12_total 6.0 113.0 2.0               1.0   51.0 71.0             104     16   122 6 113 2               1   51 71         104   16   122
118834 118834 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960000792 1063 ASSATA   Alternative Education School No 3.0 09 12 2015   grade_10                                                   39                                             39
118835 118835 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960000792 1063 ASSATA   Alternative Education School No 3.0 09 12 2015   grade_11                                                   41                                             41
118836 118836 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960000792 1063 ASSATA   Alternative Education School No 3.0 09 12 2015   grade_12                                                   8                                             8
118837 118837 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960000792 1063 ASSATA   Alternative Education School No 3.0 09 12 2015   grade_9                                                   34                                             34
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
120419 120419 WI Green   school 5509840 3682 Public school Monroe 550984002771 10 Abraham Lincoln Elementary   Regular School No 1.0 PK 05 2015   pk_12_total 387.0 6.0 31.0 1.0   4.0         10.0   223.0 216.0             206     60   439 387 6 31 1   4         10   223 216         206   60   439
120420 120420 WI Green   school 5509840 3682 Public school Monroe 550984002771 10 Abraham Lincoln Elementary   Regular School No 1.0 PK 05 2015   grade_1                                                   43                                             43
120421 120421 WI Green   school 5509840 3682 Public school Monroe 550984002771 10 Abraham Lincoln Elementary   Regular School No 1.0 PK 05 2015   grade_2                                                   44                                             44
120422 120422 WI Green   school 5509840 3682 Public school Monroe 550984002771 10 Abraham Lincoln Elementary   Regular School No 1.0 PK 05 2015   grade_3                                                   48                                             48
120423 120423 WI Green   school 5509840 3682 Public school Monroe 550984002771 10 Abraham Lincoln Elementary   Regular School No 1.0 PK 05 2015   grade_4                                                   42                                             42
120424 120424 WI Green   school 5509840 3682 Public school Monroe 550984002771 10 Abraham Lincoln Elementary   Regular School No 1.0 PK 05 2015   grade_5                                                   47                                             47
120425 120425 WI Green   school 5509840 3682 Public school Monroe 550984002771 10 Abraham Lincoln Elementary   Regular School No 1.0 PK 05 2015   kindergarten_4_year_old                                                   174                                             174
120426 120426 WI Green   school 5509840 3682 Public school Monroe 550984002771 10 Abraham Lincoln Elementary   Regular School No 1.0 PK 05 2015   kindergarten                                                   41                                             41
121394 121394 WI Oconto   school 5510950 4074 Public school Oconto Falls Public 551095001431 20 Abrams Elementary   Regular School No 1.0 PK 05 2015   pk_12_total 262.0   11.0 1.0             5.0   149.0 130.0             84     35   279 262   11 1             5   149 130         84   35   279
121395 121395 WI Oconto   school 5510950 4074 Public school Oconto Falls Public 551095001431 20 Abrams Elementary   Regular School No 1.0 PK 05 2015   grade_1                                                   35                                             35

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