enrollments

Data source: Big Local News · About: Big Local

5,797 rows where grade = "kindergarten_4_year_old" and state = "WI" sorted by school

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • kindergarten_4_year_old · 5,797 ✖
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
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
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
325606 325606 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 2017   kindergarten_4_year_old                                                   41                                             41
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
2332935 2332935 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 2021   kindergarten_4_year_old                                                   37                                             37
3073897 3073897 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 2019   kindergarten_4_year_old                                                   58                                             58
3088646 3088646 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 2018   kindergarten_4_year_old                                                   40                                             40
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
330943 330943 WI Outagamie   school 5507470 2835 Public school Kimberly Area 550747003029 150 4K Center for Literacy   Regular School No Elementary PK PK 2017   kindergarten_4_year_old                                                   22                                             22
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
2338396 2338396 WI Outagamie   school 5507470 2835 Public school Kimberly Area 550747003029 150 4K Center for Literacy   Regular School No Prekindergarten PK PK 2021   kindergarten_4_year_old                                                   292                                             292
3079262 3079262 WI Outagamie   school 5507470 2835 Public school Kimberly Area 550747003029 150 4K Center for Literacy   Regular School No Prekindergarten PK PK 2019   kindergarten_4_year_old                                                   314                                             314
3094011 3094011 WI Outagamie   school 5507470 2835 Public school Kimberly Area 550747003029 150 4K Center for Literacy   Regular School No Prekindergarten PK PK 2018   kindergarten_4_year_old                                                   279                                             279
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
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
327016 327016 WI Racine   school 5501890 777 Public school Burlington Area 550189002987 150 4K Community School   Regular School No Elementary PK PK 2017   kindergarten_4_year_old                                                   38                                             38
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
2334298 2334298 WI Racine   school 5501890 777 Public school Burlington Area 550189002987 150 4K Community School   Regular School No Prekindergarten PK PK 2021   kindergarten_4_year_old                                                   31                                             31
3075304 3075304 WI Racine   school 5501890 777 Public school Burlington Area 550189002987 150 4K Community School   Regular School No Prekindergarten PK PK 2019   kindergarten_4_year_old                                                   46                                             46
3090068 3090068 WI Racine   school 5501890 777 Public school Burlington Area 550189002987 150 4K Community School   Regular School No Prekindergarten PK PK 2018   kindergarten_4_year_old                                                   39                                             39
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
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
336482 336482 WI Sauk   school 5512660 4753 Public school Reedsburg 551266002889 150 4K Community-Based   Regular School No Elementary PK PK 2017   kindergarten_4_year_old                                                   89                                             89
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
2343998 2343998 WI Sauk   school 5512660 4753 Public school Reedsburg 551266002889 150 4K Community-Based   Regular School No Prekindergarten PK PK 2021   kindergarten_4_year_old                                                   66                                             66
3084836 3084836 WI Sauk   school 5512660 4753 Public school Reedsburg 551266002889 150 4K Community-Based   Regular School No Prekindergarten PK PK 2019   kindergarten_4_year_old                                                   110                                             110
3099555 3099555 WI Sauk   school 5512660 4753 Public school Reedsburg 551266002889 150 4K Community-Based   Regular School No Prekindergarten PK PK 2018   kindergarten_4_year_old                                                   102                                             102
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
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
332149 332149 WI Dane   school 5508910 3381 Public school McFarland 550891002902 150 4K McFarland   Regular School No Elementary PK PK 2017   kindergarten_4_year_old                                                   149                                             149
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
2339669 2339669 WI Dane   school 5508910 3381 Public school McFarland 550891002902 150 4K McFarland   Regular School No Prekindergarten PK PK 2021   kindergarten_4_year_old                                                   104                                             104
3080508 3080508 WI Dane   school 5508910 3381 Public school McFarland 550891002902 150 4K McFarland   Regular School No Prekindergarten PK PK 2019   kindergarten_4_year_old                                                   162                                             162
3095224 3095224 WI Dane   school 5508910 3381 Public school McFarland 550891002902 150 4K McFarland   Regular School No Prekindergarten PK PK 2018   kindergarten_4_year_old                                                   150                                             150
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
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
331487 331487 WI Dane   school 5508520 3269 Public school Madison Metropolitan 550852002475 190 4K PK Off Site   Regular School No Elementary PK PK 2017   kindergarten_4_year_old                                                   709                                             709
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
2338973 2338973 WI Dane   school 5508520 3269 Public school Madison Metropolitan 550852002475 190 4K PK Off Site   Regular School No Prekindergarten PK PK 2021   kindergarten_4_year_old                                                   522                                             522
3079827 3079827 WI Dane   school 5508520 3269 Public school Madison Metropolitan 550852002475 190 4K PK Off Site   Regular School No Prekindergarten PK PK 2019   kindergarten_4_year_old                                                   716                                             716
3094564 3094564 WI Dane   school 5508520 3269 Public school Madison Metropolitan 550852002475 190 4K PK Off Site   Regular School No Prekindergarten PK PK 2018   kindergarten_4_year_old                                                   744                                             744
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
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
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
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
332668 332668 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960003371 162 ALBA - Academia de Lenguaje y Bellas Artes charter Regular School Yes Elementary PK 05 2017   kindergarten_4_year_old                                                   73                                             73
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
2340191 2340191 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960003371 162 ALBA - Academia de Lenguaje y Bellas Artes charter Regular School Yes Elementary PK 07 2021   kindergarten_4_year_old                                                   59                                             59
3081025 3081025 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960003371 162 ALBA - Academia de Lenguaje y Bellas Artes charter Regular School Yes Elementary PK 05 2019   kindergarten_4_year_old                                                   77                                             77
3095740 3095740 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960003371 162 ALBA - Academia de Lenguaje y Bellas Artes charter Regular School Yes Elementary PK 05 2018   kindergarten_4_year_old                                                   65                                             65
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
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
325614 325614 WI Clark   school 5500030 7 Public school Abbotsford 550003000001 20 Abbotsford Elementary   Regular School No Elementary PK 05 2017   kindergarten_4_year_old                                                   43                                             43
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
2332943 2332943 WI Clark   school 5500030 7 Public school Abbotsford 550003000001 20 Abbotsford Elementary   Regular School No Elementary PK 05 2021   kindergarten_4_year_old                                                   37                                             37
3073905 3073905 WI Clark   school 5500030 7 Public school Abbotsford 550003000001 20 Abbotsford Elementary   Regular School No Elementary PK 05 2019   kindergarten_4_year_old                                                   34                                             34
3088654 3088654 WI Clark   school 5500030 7 Public school Abbotsford 550003000001 20 Abbotsford Elementary   Regular School No Elementary PK 05 2018   kindergarten_4_year_old                                                   42                                             42
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
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
334254 334254 WI Green   school 5509840 3682 Public school Monroe 550984002771 10 Abraham Lincoln Elementary   Regular School No Elementary PK 05 2017   kindergarten_4_year_old                                                   149                                             149
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
2341725 2341725 WI Green   school 5509840 3682 Public school Monroe 550984002771 10 Abraham Lincoln Elementary   Regular School No Elementary PK 05 2021   kindergarten_4_year_old                                                   130                                             130
3082624 3082624 WI Green   school 5509840 3682 Public school Monroe 550984002771 10 Abraham Lincoln Elementary   Regular School No Elementary PK 05 2019   kindergarten_4_year_old                                                   165                                             165
3097327 3097327 WI Green   school 5509840 3682 Public school Monroe 550984002771 10 Abraham Lincoln Elementary   Regular School No Elementary PK 05 2018   kindergarten_4_year_old                                                   171                                             171
121400 121400 WI Oconto   school 5510950 4074 Public school Oconto Falls Public 551095001431 20 Abrams Elementary   Regular School No 1.0 PK 05 2015   kindergarten_4_year_old                                                   30                                             30
291364 291364 WI Oconto   school 5510950 4074 Public school Oconto Falls Public 551095001431 20 Abrams Elementary   Regular School No 1.0 PK 05 2016   kindergarten_4_year_old                                                   32                                             32
335231 335231 WI Oconto   school 5510950 4074 Public school Oconto Falls Public 551095001431 20 Abrams Elementary   Regular School No Elementary PK 05 2017   kindergarten_4_year_old                                                   31                                             31
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
2342766 2342766 WI Oconto   school 5510950 4074 Public school Oconto Falls Public 551095001431 20 Abrams Elementary   Regular School No Elementary PK 05 2021   kindergarten_4_year_old                                                   25                                             25
3083612 3083612 WI Oconto   school 5510950 4074 Public school Oconto Falls Public 551095001431 20 Abrams Elementary   Regular School No Elementary PK 05 2019   kindergarten_4_year_old                                                   21                                             21
3098311 3098311 WI Oconto   school 5510950 4074 Public school Oconto Falls Public 551095001431 20 Abrams Elementary   Regular School No Elementary PK 05 2018   kindergarten_4_year_old                                                   44                                             44
118788 118788 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001239 316 Academy of Accelerated Learning   Regular School No 1.0 PK 05 2015   kindergarten_4_year_old                                                   86                                             86
288789 288789 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001239 316 Academy of Accelerated Learning   Regular School No 1.0 PK 05 2016   kindergarten_4_year_old                                                   96                                             96
332659 332659 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001239 316 Academy of Accelerated Learning   Regular School No Elementary PK 05 2017   kindergarten_4_year_old                                                   91                                             91
2325287 2325287 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001239 316 Academy of Accelerated Learning   Regular School No Elementary PK 05 2020   kindergarten_4_year_old                                                   89                                             89
2340180 2340180 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001239 316 Academy of Accelerated Learning   Regular School No Elementary PK 05 2021   kindergarten_4_year_old                                                   67                                             67
3081016 3081016 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001239 316 Academy of Accelerated Learning   Regular School No Elementary PK 05 2019   kindergarten_4_year_old                                                   94                                             94
3095731 3095731 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001239 316 Academy of Accelerated Learning   Regular School No Elementary PK 05 2018   kindergarten_4_year_old                                                   84                                             84
116328 116328 WI Rock   school 5507020 2695 Public school Janesville 550702000756 20 Adams Elementary   Regular School No 1.0 PK 05 2015   kindergarten_4_year_old                                                   15                                             15
286327 286327 WI Rock   school 5507020 2695 Public school Janesville 550702000756 20 Adams Elementary   Regular School No 1.0 PK 05 2016   kindergarten_4_year_old                                                   17                                             17
330201 330201 WI Rock   school 5507020 2695 Public school Janesville 550702000756 20 Adams Elementary   Regular School No Elementary PK 05 2017   kindergarten_4_year_old                                                   15                                             15
2322778 2322778 WI Rock   school 5507020 2695 Public school Janesville 550702000756 20 Adams Elementary   Regular School No Elementary PK 05 2020   kindergarten_4_year_old                                                   26                                             26
2337637 2337637 WI Rock   school 5507020 2695 Public school Janesville 550702000756 20 Adams Elementary   Regular School No Elementary PK 05 2021   kindergarten_4_year_old                                                   30                                             30
3078527 3078527 WI Rock   school 5507020 2695 Public school Janesville 550702000756 20 Adams Elementary   Regular School No Elementary PK 05 2019   kindergarten_4_year_old                                                   28                                             28
3093273 3093273 WI Rock   school 5507020 2695 Public school Janesville 550702000756 20 Adams Elementary   Regular School No Elementary PK 05 2018   kindergarten_4_year_old                                                   13                                             13
111763 111763 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No 1.0 PK 05 2015   kindergarten_4_year_old                                                   69                                             69
281737 281737 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No 1.0 PK 05 2016   kindergarten_4_year_old                                                   53                                             53
325633 325633 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No Elementary PK 05 2017   kindergarten_4_year_old                                                   39                                             39
2318157 2318157 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No Elementary PK 04 2020   kindergarten_4_year_old                                                   79                                             79
2332960 2332960 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No Elementary PK 04 2021   kindergarten_4_year_old                                                   43                                             43
3073926 3073926 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No Elementary PK 04 2019   kindergarten_4_year_old                                                   73                                             73
3088675 3088675 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No Elementary PK 05 2018   kindergarten_4_year_old                                                   60                                             60
123656 123656 WI Washington   school 5513950 5390 Public school Slinger 551395002540 100 Addison Elementary   Regular School No 1.0 PK 05 2015   kindergarten_4_year_old                                                   45                                             45
293611 293611 WI Washington   school 5513950 5390 Public school Slinger 551395002540 100 Addison Elementary   Regular School No 1.0 PK 05 2016   kindergarten_4_year_old                                                   50                                             50
337501 337501 WI Washington   school 5513950 5390 Public school Slinger 551395002540 100 Addison Elementary   Regular School No Elementary PK 05 2017   kindergarten_4_year_old                                                   63                                             63
2330095 2330095 WI Washington   school 5513950 5390 Public school Slinger 551395002540 100 Addison Elementary   Regular School No Elementary PK 05 2020   kindergarten_4_year_old                                                   48                                             48
2344992 2344992 WI Washington   school 5513950 5390 Public school Slinger 551395002540 100 Addison Elementary   Regular School No Elementary PK 05 2021   kindergarten_4_year_old                                                   49                                             49
3085827 3085827 WI Washington   school 5513950 5390 Public school Slinger 551395002540 100 Addison Elementary   Regular School No Elementary PK 05 2019   kindergarten_4_year_old                                                   50                                             50
3100556 3100556 WI Washington   school 5513950 5390 Public school Slinger 551395002540 100 Addison Elementary   Regular School No Elementary PK 05 2018   kindergarten_4_year_old                                                   54                                             54
111802 111802 WI Green   school 5500120 63 Public school Albany 550012000013 20 Albany Elementary   Regular School No 1.0 PK 04 2015   kindergarten_4_year_old                                                   24                                             24

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