enrollments

Data source: Big Local News · About: Big Local

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

✎ 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
2318120 2318120 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes Elementary PK 08 2020   pk_12_total 47.0 288.0 176.0               40.0   262.0 289.0             467     59   551 47 288 176               40   262 289         467   59   551
2318121 2318121 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes Elementary PK 08 2020   grade_1                                                   47                                             47
2318122 2318122 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes Elementary PK 08 2020   grade_2                                                   55                                             55
2318123 2318123 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes Elementary PK 08 2020   grade_3                                                   57                                             57
2318124 2318124 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes Elementary PK 08 2020   grade_4                                                   57                                             57
2318125 2318125 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes Elementary PK 08 2020   grade_5                                                   59                                             59
2318126 2318126 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes Elementary PK 08 2020   grade_6                                                   58                                             58
2318127 2318127 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes Elementary PK 08 2020   grade_7                                                   59                                             59
2318128 2318128 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes Elementary PK 08 2020   grade_8                                                   60                                             60
2318129 2318129 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes Elementary PK 08 2020   kindergarten_4_year_old                                                   39                                             39
2318130 2318130 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes Elementary PK 08 2020   kindergarten                                                   60                                             60
2325171 2325171 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951002818 800 21st Century eSchool charter Regular School Yes Other KG 12 2020   pk_12_total 3.0   1.0                   2.0 2.0             *     *   4 3   1                   2 2                 4
2325172 2325172 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951002818 800 21st Century eSchool charter Regular School Yes Other KG 12 2020   grade_5                                                   1                                             1
2325173 2325173 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951002818 800 21st Century eSchool charter Regular School Yes Other KG 12 2020   grade_6                                                   1                                             1
2325174 2325174 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951002818 800 21st Century eSchool charter Regular School Yes Other KG 12 2020   grade_7                                                   1                                             1
2325175 2325175 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951002818 800 21st Century eSchool charter Regular School Yes Other KG 12 2020   grade_8                                                   1                                             1
2323511 2323511 WI Outagamie   school 5507470 2835 Public school Kimberly Area 550747003029 150 4K Center for Literacy   Regular School No Prekindergarten PK PK 2020   pk_12_total 291.0 3.0 14.0     9.0         14.0   181.0 150.0             63     41   331 291 3 14     9         14   181 150         63   41   331
2323512 2323512 WI Outagamie   school 5507470 2835 Public school Kimberly Area 550747003029 150 4K Center for Literacy   Regular School No Prekindergarten PK PK 2020   kindergarten_4_year_old                                                   314                                             314
2323513 2323513 WI Outagamie   school 5507470 2835 Public school Kimberly Area 550747003029 150 4K Center for Literacy   Regular School No Prekindergarten PK PK 2020   pre_kindergarten                                                   17                                             17
2319518 2319518 WI Racine   school 5501890 777 Public school Burlington Area 550189002987 150 4K Community School   Regular School No Prekindergarten PK PK 2020   pk_12_total 34.0   7.0               3.0   20.0 24.0             16     1   44 34   7               3   20 24         16   1   44
2319519 2319519 WI Racine   school 5501890 777 Public school Burlington Area 550189002987 150 4K Community School   Regular School No Prekindergarten PK PK 2020   kindergarten_4_year_old                                                   44                                             44
2329101 2329101 WI Sauk   school 5512660 4753 Public school Reedsburg 551266002889 150 4K Community-Based   Regular School No Prekindergarten PK PK 2020   pk_12_total 60.0 2.0 5.0               3.0   39.0 31.0             7     11   70 60 2 5               3   39 31         7   11   70
2329102 2329102 WI Sauk   school 5512660 4753 Public school Reedsburg 551266002889 150 4K Community-Based   Regular School No Prekindergarten PK PK 2020   kindergarten_4_year_old                                                   70                                             70
2324779 2324779 WI Dane   school 5508910 3381 Public school McFarland 550891002902 150 4K McFarland   Regular School No Prekindergarten PK PK 2020   pk_12_total 122.0   8.0     2.0         9.0   77.0 64.0             17     17   141 122   8     2         9   77 64         17   17   141
2324780 2324780 WI Dane   school 5508910 3381 Public school McFarland 550891002902 150 4K McFarland   Regular School No Prekindergarten PK PK 2020   kindergarten_4_year_old                                                   141                                             141
2324104 2324104 WI Dane   school 5508520 3269 Public school Madison Metropolitan 550852002475 190 4K PK Off Site   Regular School No Prekindergarten PK PK 2020   pk_12_total 335.0 117.0 122.0 1.0   44.0         56.0   334.0 341.0             237     48   675 335 117 122 1   44         56   334 341         237   48   675
2324105 2324105 WI Dane   school 5508520 3269 Public school Madison Metropolitan 550852002475 190 4K PK Off Site   Regular School No Prekindergarten PK PK 2020   kindergarten_4_year_old                                                   675                                             675
2323576 2323576 WI La Crosse   school 5507530 2849 Public school La Crosse 550753002950 440 7 Rivers Community High charter Regular School Yes High 09 12 2020   pk_12_total 38.0         2.0         4.0   24.0 20.0             19     5   44 38         2         4   24 20         19   5   44
2323577 2323577 WI La Crosse   school 5507530 2849 Public school La Crosse 550753002950 440 7 Rivers Community High charter Regular School Yes High 09 12 2020   grade_10                                                   15                                             15
2323578 2323578 WI La Crosse   school 5507530 2849 Public school La Crosse 550753002950 440 7 Rivers Community High charter Regular School Yes High 09 12 2020   grade_11                                                   5                                             5
2323579 2323579 WI La Crosse   school 5507530 2849 Public school La Crosse 550753002950 440 7 Rivers Community High charter Regular School Yes High 09 12 2020   grade_12                                                   9                                             9
2323580 2323580 WI La Crosse   school 5507530 2849 Public school La Crosse 550753002950 440 7 Rivers Community High charter Regular School Yes High 09 12 2020   grade_9                                                   15                                             15
2327125 2327125 WI Winnebago   school 5510320 3892 Public school Neenah Joint 551032003366 125 ACE Alliance Charter Elementary charter Regular School Yes Elementary KG 05 2020   pk_12_total 109.0   4.0     7.0         5.0   74.0 51.0             18     9   125 109   4     7         5   74 51         18   9   125
2327126 2327126 WI Winnebago   school 5510320 3892 Public school Neenah Joint 551032003366 125 ACE Alliance Charter Elementary charter Regular School Yes Elementary KG 05 2020   grade_1                                                   23                                             23
2327127 2327127 WI Winnebago   school 5510320 3892 Public school Neenah Joint 551032003366 125 ACE Alliance Charter Elementary charter Regular School Yes Elementary KG 05 2020   grade_2                                                   21                                             21
2327128 2327128 WI Winnebago   school 5510320 3892 Public school Neenah Joint 551032003366 125 ACE Alliance Charter Elementary charter Regular School Yes Elementary KG 05 2020   grade_3                                                   23                                             23
2327129 2327129 WI Winnebago   school 5510320 3892 Public school Neenah Joint 551032003366 125 ACE Alliance Charter Elementary charter Regular School Yes Elementary KG 05 2020   grade_4                                                   24                                             24
2327130 2327130 WI Winnebago   school 5510320 3892 Public school Neenah Joint 551032003366 125 ACE Alliance Charter Elementary charter Regular School Yes Elementary KG 05 2020   grade_5                                                   12                                             12
2327131 2327131 WI Winnebago   school 5510320 3892 Public school Neenah Joint 551032003366 125 ACE Alliance Charter Elementary charter Regular School Yes Elementary KG 05 2020   kindergarten                                                   22                                             22
2325289 2325289 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960003371 162 ALBA - Academia de Lenguaje y Bellas Artes charter Regular School Yes Elementary PK 06 2020   pk_12_total 2.0   534.0             1.0 2.0   284.0 255.0             488     90   539 2   534             1 2   284 255         488   90   539
2325290 2325290 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960003371 162 ALBA - Academia de Lenguaje y Bellas Artes charter Regular School Yes Elementary PK 06 2020   grade_1                                                   75                                             75
2325291 2325291 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960003371 162 ALBA - Academia de Lenguaje y Bellas Artes charter Regular School Yes Elementary PK 06 2020   grade_2                                                   77                                             77
2325292 2325292 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960003371 162 ALBA - Academia de Lenguaje y Bellas Artes charter Regular School Yes Elementary PK 06 2020   grade_3                                                   64                                             64
2325293 2325293 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960003371 162 ALBA - Academia de Lenguaje y Bellas Artes charter Regular School Yes Elementary PK 06 2020   grade_4                                                   74                                             74
2325294 2325294 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960003371 162 ALBA - Academia de Lenguaje y Bellas Artes charter Regular School Yes Elementary PK 06 2020   grade_5                                                   54                                             54
2325295 2325295 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960003371 162 ALBA - Academia de Lenguaje y Bellas Artes charter Regular School Yes Elementary PK 06 2020   grade_6                                                   15                                             15
2325296 2325296 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960003371 162 ALBA - Academia de Lenguaje y Bellas Artes charter Regular School Yes Elementary PK 06 2020   kindergarten_3_year_old                                                   35                                             35
2325297 2325297 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960003371 162 ALBA - Academia de Lenguaje y Bellas Artes charter Regular School Yes Elementary PK 06 2020   kindergarten_4_year_old                                                   65                                             65
2325298 2325298 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960003371 162 ALBA - Academia de Lenguaje y Bellas Artes charter Regular School Yes Elementary PK 06 2020   kindergarten                                                   80                                             80
2322781 2322781 WI Rock   school 5507020 2695 Public school Janesville 550702002991 860 ARISE Virtual Academy charter Regular School Yes Other KG 12 2020   pk_12_total 95.0 2.0 9.0 1.0   2.0         3.0   49.0 63.0             63     18   112 95 2 9 1   2         3   49 63         63   18   112
2322782 2322782 WI Rock   school 5507020 2695 Public school Janesville 550702002991 860 ARISE Virtual Academy charter Regular School Yes Other KG 12 2020   grade_10                                                   16                                             16
2322783 2322783 WI Rock   school 5507020 2695 Public school Janesville 550702002991 860 ARISE Virtual Academy charter Regular School Yes Other KG 12 2020   grade_11                                                   20                                             20
2322784 2322784 WI Rock   school 5507020 2695 Public school Janesville 550702002991 860 ARISE Virtual Academy charter Regular School Yes Other KG 12 2020   grade_12                                                   32                                             32
2322785 2322785 WI Rock   school 5507020 2695 Public school Janesville 550702002991 860 ARISE Virtual Academy charter Regular School Yes Other KG 12 2020   grade_2                                                   1                                             1
2322786 2322786 WI Rock   school 5507020 2695 Public school Janesville 550702002991 860 ARISE Virtual Academy charter Regular School Yes Other KG 12 2020   grade_5                                                   2                                             2
2322787 2322787 WI Rock   school 5507020 2695 Public school Janesville 550702002991 860 ARISE Virtual Academy charter Regular School Yes Other KG 12 2020   grade_6                                                   4                                             4
2322788 2322788 WI Rock   school 5507020 2695 Public school Janesville 550702002991 860 ARISE Virtual Academy charter Regular School Yes Other KG 12 2020   grade_7                                                   10                                             10
2322789 2322789 WI Rock   school 5507020 2695 Public school Janesville 550702002991 860 ARISE Virtual Academy charter Regular School Yes Other KG 12 2020   grade_8                                                   16                                             16
2322790 2322790 WI Rock   school 5507020 2695 Public school Janesville 550702002991 860 ARISE Virtual Academy charter Regular School Yes Other KG 12 2020   grade_9                                                   11                                             11
2325329 2325329 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960000792 1063 ASSATA High   Alternative School No High 09 12 2020   pk_12_total   88.0 2.0               2.0   43.0 49.0             *     22   92   88 2               2   43 49             22   92
2325330 2325330 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960000792 1063 ASSATA High   Alternative School No High 09 12 2020   grade_10                                                   28                                             28
2325331 2325331 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960000792 1063 ASSATA High   Alternative School No High 09 12 2020   grade_11                                                   33                                             33
2325332 2325332 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960000792 1063 ASSATA High   Alternative School No High 09 12 2020   grade_12                                                   19                                             19
2325333 2325333 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960000792 1063 ASSATA High   Alternative School No High 09 12 2020   grade_9                                                   12                                             12
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
2326852 2326852 WI Green   school 5509840 3682 Public school Monroe 550984002771 10 Abraham Lincoln Elementary   Regular School No Elementary PK 05 2020   pk_12_total 306.0 1.0 24.0     1.0         5.0   179.0 158.0             165     53   337 306 1 24     1         5   179 158         165   53   337
2326853 2326853 WI Green   school 5509840 3682 Public school Monroe 550984002771 10 Abraham Lincoln Elementary   Regular School No Elementary PK 05 2020   grade_1                                                   39                                             39
2326854 2326854 WI Green   school 5509840 3682 Public school Monroe 550984002771 10 Abraham Lincoln Elementary   Regular School No Elementary PK 05 2020   grade_2                                                   33                                             33
2326855 2326855 WI Green   school 5509840 3682 Public school Monroe 550984002771 10 Abraham Lincoln Elementary   Regular School No Elementary PK 05 2020   grade_3                                                   27                                             27
2326856 2326856 WI Green   school 5509840 3682 Public school Monroe 550984002771 10 Abraham Lincoln Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   35                                             35
2326857 2326857 WI Green   school 5509840 3682 Public school Monroe 550984002771 10 Abraham Lincoln Elementary   Regular School No Elementary PK 05 2020   grade_5                                                   25                                             25
2326858 2326858 WI Green   school 5509840 3682 Public school Monroe 550984002771 10 Abraham Lincoln Elementary   Regular School No Elementary PK 05 2020   kindergarten_4_year_old                                                   144                                             144
2326859 2326859 WI Green   school 5509840 3682 Public school Monroe 550984002771 10 Abraham Lincoln Elementary   Regular School No Elementary PK 05 2020   kindergarten                                                   34                                             34
2327868 2327868 WI Oconto   school 5510950 4074 Public school Oconto Falls Public 551095001431 20 Abrams Elementary   Regular School No Elementary PK 05 2020   pk_12_total 238.0   5.0               6.0   130.0 119.0             56     27   249 238   5               6   130 119         56   27   249
2327869 2327869 WI Oconto   school 5510950 4074 Public school Oconto Falls Public 551095001431 20 Abrams Elementary   Regular School No Elementary PK 05 2020   grade_1                                                   45                                             45
2327870 2327870 WI Oconto   school 5510950 4074 Public school Oconto Falls Public 551095001431 20 Abrams Elementary   Regular School No Elementary PK 05 2020   grade_2                                                   33                                             33
2327871 2327871 WI Oconto   school 5510950 4074 Public school Oconto Falls Public 551095001431 20 Abrams Elementary   Regular School No Elementary PK 05 2020   grade_3                                                   35                                             35
2327872 2327872 WI Oconto   school 5510950 4074 Public school Oconto Falls Public 551095001431 20 Abrams Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   33                                             33
2327873 2327873 WI Oconto   school 5510950 4074 Public school Oconto Falls Public 551095001431 20 Abrams Elementary   Regular School No Elementary PK 05 2020   grade_5                                                   39                                             39
2327874 2327874 WI Oconto   school 5510950 4074 Public school Oconto Falls Public 551095001431 20 Abrams Elementary   Regular School No Elementary PK 05 2020   kindergarten_4_year_old                                                   36                                             36
2327875 2327875 WI Oconto   school 5510950 4074 Public school Oconto Falls Public 551095001431 20 Abrams Elementary   Regular School No Elementary PK 05 2020   kindergarten                                                   27                                             27
2327876 2327876 WI Oconto   school 5510950 4074 Public school Oconto Falls Public 551095001431 20 Abrams Elementary   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   1                                             1
2325280 2325280 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001239 316 Academy of Accelerated Learning   Regular School No Elementary PK 05 2020   pk_12_total 211.0 80.0 211.0 4.0   151.0       1.0 45.0   367.0 336.0             469     156   703 211 80 211 4   151       1 45   367 336         469   156   703
2325281 2325281 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001239 316 Academy of Accelerated Learning   Regular School No Elementary PK 05 2020   grade_1                                                   88                                             88

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