enrollments

Data source: Big Local News · About: Big Local

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

✎ 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
286985 286985 WI Washington   school 5507380 2800 Public school Kewaskum 550738000839 100 i4Learning Community School charter Regular School Yes 1.0 PK 05 2016   kindergarten_4_year_old                                                   11                                             11
330865 330865 WI Washington   school 5507380 2800 Public school Kewaskum 550738000839 100 i4Learning Community School charter Regular School Yes Elementary PK 05 2017   kindergarten_4_year_old                                                   19                                             19
2323433 2323433 WI Washington   school 5507380 2800 Public school Kewaskum 550738000839 100 i4Learning Community School charter Regular School Yes Elementary PK 05 2020   kindergarten_4_year_old                                                   20                                             20
2338304 2338304 WI Washington   school 5507380 2800 Public school Kewaskum 550738000839 100 i4Learning Community School   Regular School No Elementary PK 05 2021   kindergarten_4_year_old                                                   1                                             1
3079182 3079182 WI Washington   school 5507380 2800 Public school Kewaskum 550738000839 100 i4Learning Community School charter Regular School Yes Elementary PK 05 2019   kindergarten_4_year_old                                                   12                                             12
3093932 3093932 WI Washington   school 5507380 2800 Public school Kewaskum 550738000839 100 i4Learning Community School charter Regular School Yes Elementary PK 05 2018   kindergarten_4_year_old                                                   10                                             10
2346404 2346404 WI Jefferson   school 5515750 6125 Public school Watertown Unified 551575003127 800 eCampus Academy Charter School charter Regular School Yes Other PK 12 2021   kindergarten_4_year_old                                                   3                                             3
117059 117059 WI Manitowoc   school 5507440 2828 Public school Kiel Area 550744002333 100 Zielanis Elementary   Regular School No 1.0 PK 04 2015   kindergarten_4_year_old                                                   64                                             64
287056 287056 WI Manitowoc   school 5507440 2828 Public school Kiel Area 550744002333 100 Zielanis Elementary   Regular School No 1.0 PK 04 2016   kindergarten_4_year_old                                                   59                                             59
330939 330939 WI Manitowoc   school 5507440 2828 Public school Kiel Area 550744002333 100 Zielanis Elementary   Regular School No Elementary PK 04 2017   kindergarten_4_year_old                                                   68                                             68
2323508 2323508 WI Manitowoc   school 5507440 2828 Public school Kiel Area 550744002333 100 Zielanis Elementary   Regular School No Elementary PK 04 2020   kindergarten_4_year_old                                                   59                                             59
2338392 2338392 WI Manitowoc   school 5507440 2828 Public school Kiel Area 550744002333 100 Zielanis Elementary   Regular School No Elementary PK 04 2021   kindergarten_4_year_old                                                   45                                             45
3079258 3079258 WI Manitowoc   school 5507440 2828 Public school Kiel Area 550744002333 100 Zielanis Elementary   Regular School No Elementary PK 04 2019   kindergarten_4_year_old                                                   68                                             68
3094007 3094007 WI Manitowoc   school 5507440 2828 Public school Kiel Area 550744002333 100 Zielanis Elementary   Regular School No Elementary PK 04 2018   kindergarten_4_year_old                                                   80                                             80
120244 120244 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002342 295 Zablocki Elementary   Regular School No 1.0 PK 05 2015   kindergarten_4_year_old                                                   56                                             56
290201 290201 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002342 295 Zablocki Elementary   Regular School No 1.0 PK 05 2016   kindergarten_4_year_old                                                   67                                             67
334093 334093 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002342 295 Zablocki Elementary   Regular School No Elementary PK 05 2017   kindergarten_4_year_old                                                   50                                             50
2326698 2326698 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002342 295 Zablocki Elementary   Regular School No Elementary PK 05 2020   kindergarten_4_year_old                                                   45                                             45
2341567 2341567 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002342 295 Zablocki Elementary   Regular School No Elementary PK 05 2021   kindergarten_4_year_old                                                   35                                             35
3082463 3082463 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002342 295 Zablocki Elementary   Regular School No Elementary PK 05 2019   kindergarten_4_year_old                                                   39                                             39
3097169 3097169 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002342 295 Zablocki Elementary   Regular School No Elementary PK 05 2018   kindergarten_4_year_old                                                   45                                             45
126381 126381 WI Racine   school 5517220 6748 Public school Yorkville J2 551722002230 20 Yorkville Elementary   Regular School No 1.0 PK 08 2015   kindergarten_4_year_old                                                   24                                             24
296318 296318 WI Racine   school 5517220 6748 Public school Yorkville J2 551722002230 20 Yorkville Elementary   Regular School No 1.0 PK 08 2016   kindergarten_4_year_old                                                   29                                             29
340259 340259 WI Racine   school 5517220 6748 Public school Yorkville J2 551722002230 20 Yorkville Elementary   Regular School No Elementary PK 08 2017   kindergarten_4_year_old                                                   22                                             22
2332924 2332924 WI Racine   school 5517220 6748 Public school Yorkville J2 551722002230 20 Yorkville Elementary   Regular School No Elementary PK 08 2020   kindergarten_4_year_old                                                   18                                             18
2347930 2347930 WI Racine   school 5517220 6748 Public school Yorkville J2 551722002230 20 Yorkville Elementary   Regular School No Elementary PK 08 2021   kindergarten_4_year_old                                                   30                                             30
3088635 3088635 WI Racine   school 5517220 6748 Public school Yorkville J2 551722002230 20 Yorkville Elementary   Regular School No Elementary PK 08 2019   kindergarten_4_year_old                                                   22                                             22
3103337 3103337 WI Racine   school 5517220 6748 Public school Yorkville J2 551722002230 20 Yorkville Elementary   Regular School No Elementary PK 08 2018   kindergarten_4_year_old                                                   28                                             28
126359 126359 WI Brown   school 5517190 6734 Public school Wrightstown Community 551719002228 20 Wrightstown Elementary   Regular School No 1.0 PK 04 2015   kindergarten_4_year_old                                                   68                                             68
296296 296296 WI Brown   school 5517190 6734 Public school Wrightstown Community 551719002228 20 Wrightstown Elementary   Regular School No 1.0 PK 04 2016   kindergarten_4_year_old                                                   72                                             72
340237 340237 WI Brown   school 5517190 6734 Public school Wrightstown Community 551719002228 20 Wrightstown Elementary   Regular School No Elementary PK 04 2017   kindergarten_4_year_old                                                   63                                             63
2332902 2332902 WI Brown   school 5517190 6734 Public school Wrightstown Community 551719002228 20 Wrightstown Elementary   Regular School No Elementary PK 04 2020   kindergarten_4_year_old                                                   70                                             70
2347908 2347908 WI Brown   school 5517190 6734 Public school Wrightstown Community 551719002228 20 Wrightstown Elementary   Regular School No Elementary PK 04 2021   kindergarten_4_year_old                                                   67                                             67
3088613 3088613 WI Brown   school 5517190 6734 Public school Wrightstown Community 551719002228 20 Wrightstown Elementary   Regular School No Elementary PK 04 2019   kindergarten_4_year_old                                                   74                                             74
3103315 3103315 WI Brown   school 5517190 6734 Public school Wrightstown Community 551719002228 20 Wrightstown Elementary   Regular School No Elementary PK 04 2018   kindergarten_4_year_old                                                   74                                             74
115309 115309 WI Ozaukee   school 5505610 2217 Public school Grafton 550561002250 100 Woodview Elementary   Regular School No 1.0 PK 05 2015   kindergarten_4_year_old                                                   43                                             43
285315 285315 WI Ozaukee   school 5505610 2217 Public school Grafton 550561002250 100 Woodview Elementary   Regular School No 1.0 PK 05 2016   kindergarten_4_year_old                                                   37                                             37
329186 329186 WI Ozaukee   school 5505610 2217 Public school Grafton 550561002250 100 Woodview Elementary   Regular School No Elementary PK 05 2017   kindergarten_4_year_old                                                   40                                             40
2321729 2321729 WI Ozaukee   school 5505610 2217 Public school Grafton 550561002250 100 Woodview Elementary   Regular School No Elementary PK 05 2020   kindergarten_4_year_old                                                   43                                             43
2336571 2336571 WI Ozaukee   school 5505610 2217 Public school Grafton 550561002250 100 Woodview Elementary   Regular School No Elementary PK 05 2021   kindergarten_4_year_old                                                   41                                             41
3077490 3077490 WI Ozaukee   school 5505610 2217 Public school Grafton 550561002250 100 Woodview Elementary   Regular School No Elementary PK 05 2019   kindergarten_4_year_old                                                   36                                             36
3092262 3092262 WI Ozaukee   school 5505610 2217 Public school Grafton 550561002250 100 Woodview Elementary   Regular School No Elementary PK 05 2018   kindergarten_4_year_old                                                   32                                             32
126271 126271 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002217 300 Woodside Elementary   Regular School No 1.0 PK 05 2015   kindergarten_4_year_old                                                   34                                             34
296209 296209 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002217 300 Woodside Elementary   Regular School No 1.0 PK 05 2016   kindergarten_4_year_old                                                   36                                             36
340149 340149 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002217 300 Woodside Elementary   Regular School No Elementary PK 05 2017   kindergarten_4_year_old                                                   31                                             31
2332808 2332808 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002217 300 Woodside Elementary   Regular School No Elementary PK 05 2020   kindergarten_4_year_old                                                   34                                             34
2347798 2347798 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002217 300 Woodside Elementary   Regular School No Elementary PK 05 2021   kindergarten_4_year_old                                                   31                                             31
3088518 3088518 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002217 300 Woodside Elementary   Regular School No Elementary PK 05 2019   kindergarten_4_year_old                                                   35                                             35
3103223 3103223 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002217 300 Woodside Elementary   Regular School No Elementary PK 05 2018   kindergarten_4_year_old                                                   33                                             33
285097 285097 WI Walworth   school 5505100 2044 Public school Geneva J4 550510000546 20 Woods Elementary   Regular School No 1.0 PK 08 2016   kindergarten_4_year_old                                                   21                                             21
2336363 2336363 WI Walworth   school 5505100 2044 Public school Geneva J4 550510000546 20 Woods Elementary   Regular School No Elementary PK 08 2021   kindergarten_4_year_old                                                   19                                             19
126340 126340 WI Milwaukee   school 5500070 8132 Non District Charter Schools Woodlands School East 550007002942 100 Woodlands School East charter Regular School Yes 1.0 PK 08 2015   kindergarten_4_year_old                                                   35                                             35
296278 296278 WI Milwaukee   school 5500070 8132 Non District Charter Schools Woodlands School East 550007002942 100 Woodlands School East charter Regular School Yes 1.0 PK 08 2016   kindergarten_4_year_old                                                   34                                             34
340218 340218 WI Milwaukee   school 5500070 8132 Non District Charter Schools Woodlands School East 550007002942 100 Woodlands School East charter Regular School Yes Elementary PK 08 2017   kindergarten_4_year_old                                                   30                                             30
3103296 3103296 WI Milwaukee   school 5500070 8132 Non District Charter Schools Woodlands School East 550007002942 100 Woodlands School East charter Regular School Yes Elementary PK 08 2018   kindergarten_4_year_old                                                   31                                             31
2332882 2332882 WI Milwaukee   school 5500070 8132 Non District Charter Schools Woodlands School - State Street Campus 550007002942 100 Woodlands School - State Street Campus charter Regular School Yes Elementary PK 08 2020   kindergarten_4_year_old                                                   25                                             25
2347889 2347889 WI Milwaukee   school 5500070 8132 Non District Charter Schools Woodlands School - State Street Campus 550007002942 100 Woodlands School - State Street Campus charter Regular School Yes Elementary PK 08 2021   kindergarten_4_year_old                                                   12                                             12
3088593 3088593 WI Milwaukee   school 5500070 8132 Non District Charter Schools Woodlands School - State Street Campus 550007002942 100 Woodlands School - State Street Campus charter Regular School Yes Elementary PK 08 2019   kindergarten_4_year_old                                                   28                                             28
126334 126334 WI Milwaukee   school 5500113 8113 Non District Charter Schools Woodlands School 550011303353 8728 Woodlands School charter Regular School Yes 1.0 PK 08 2015   kindergarten_4_year_old                                                   33                                             33
296271 296271 WI Milwaukee   school 5500113 8113 Non District Charter Schools Woodlands School 550011303353 8728 Woodlands School charter Regular School Yes 1.0 PK 08 2016   kindergarten_4_year_old                                                   33                                             33
340210 340210 WI Milwaukee   school 5500113 8113 Non District Charter Schools Woodlands School 550011303353 8728 Woodlands School charter Regular School Yes Elementary PK 08 2017   kindergarten_4_year_old                                                   33                                             33
2332871 2332871 WI Milwaukee   school 5500113 8113 Non District Charter Schools Woodlands School 550011303353 8728 Woodlands School charter Regular School Yes Elementary PK 08 2020   kindergarten_4_year_old                                                   30                                             30
2347878 2347878 WI Milwaukee   school 5500113 8113 Non District Charter Schools Woodlands School 550011303353 8728 Woodlands School charter Regular School Yes Elementary PK 08 2021   kindergarten_4_year_old                                                   31                                             31
3088583 3088583 WI Milwaukee   school 5500113 8113 Non District Charter Schools Woodlands School 550011303353 8728 Woodlands School charter Regular School Yes Elementary PK 08 2019   kindergarten_4_year_old                                                   30                                             30
3103287 3103287 WI Milwaukee   school 5500113 8113 Non District Charter Schools Woodlands School 550011303353 8728 Woodlands School charter Regular School Yes Elementary PK 08 2018   kindergarten_4_year_old                                                   30                                             30
117108 117108 WI Outagamie   school 5507470 2835 Public school Kimberly Area 550747002641 130 Woodland School   Regular School No 1.0 PK 04 2015   kindergarten_4_year_old                                                   78                                             78
112556 112556 WI Barron   school 5500870 308 Public school Barron Area 550087000119 160 Woodland Elementary   Regular School No 1.0 PK 04 2015   kindergarten_4_year_old                                                   53                                             53
282537 282537 WI Barron   school 5500870 308 Public school Barron Area 550087000119 160 Woodland Elementary   Regular School No 1.0 PK 04 2016   kindergarten_4_year_old                                                   50                                             50
326435 326435 WI Barron   school 5500870 308 Public school Barron Area 550087000119 160 Woodland Elementary   Regular School No Elementary PK 04 2017   kindergarten_4_year_old                                                   47                                             47
2318934 2318934 WI Barron   school 5500870 308 Public school Barron Area 550087000119 160 Woodland Elementary   Regular School No Elementary PK 04 2020   kindergarten_4_year_old                                                   51                                             51
2333718 2333718 WI Barron   school 5500870 308 Public school Barron Area 550087000119 160 Woodland Elementary   Regular School No Elementary PK 04 2021   kindergarten_4_year_old                                                   42                                             42
3074710 3074710 WI Barron   school 5500870 308 Public school Barron Area 550087000119 160 Woodland Elementary   Regular School No Elementary PK 04 2019   kindergarten_4_year_old                                                   38                                             38
3089465 3089465 WI Barron   school 5500870 308 Public school Barron Area 550087000119 160 Woodland Elementary   Regular School No Elementary PK 04 2018   kindergarten_4_year_old                                                   47                                             47
294834 294834 WI Racine   school 5515660 6113 Public school Waterford Graded J1 551566002510 110 Woodfield Elementary   Regular School No 1.0 PK 06 2016   kindergarten_4_year_old                                                   37                                             37
2346346 2346346 WI Racine   school 5515660 6113 Public school Waterford Graded J1 551566002510 110 Woodfield Elementary   Regular School No Elementary PK 05 2021   kindergarten_4_year_old                                                   32                                             32
3101808 3101808 WI Racine   school 5515660 6113 Public school Waterford Graded J1 551566002510 110 Woodfield Elementary   Regular School No Elementary PK 06 2018   kindergarten_4_year_old                                                   32                                             32
126313 126313 WI Juneau   school 5517130 6713 Public school Wonewoc-Union Center 551713002224 60 Wonewoc-Center Elementary   Regular School No 1.0 PK 05 2015   kindergarten_4_year_old                                                   21                                             21
296251 296251 WI Juneau   school 5517130 6713 Public school Wonewoc-Union Center 551713002224 60 Wonewoc-Center Elementary   Regular School No 1.0 PK 05 2016   kindergarten_4_year_old                                                   18                                             18
340189 340189 WI Juneau   school 5517130 6713 Public school Wonewoc-Union Center 551713002224 60 Wonewoc-Center Elementary   Regular School No Elementary PK 05 2017   kindergarten_4_year_old                                                   21                                             21
2332848 2332848 WI Juneau   school 5517130 6713 Public school Wonewoc-Union Center 551713002224 60 Wonewoc-Center Elementary   Regular School No Elementary PK 05 2020   kindergarten_4_year_old                                                   30                                             30
2347843 2347843 WI Juneau   school 5517130 6713 Public school Wonewoc-Union Center 551713002224 60 Wonewoc-Center Elementary   Regular School No Elementary PK 05 2021   kindergarten_4_year_old                                                   21                                             21
3088559 3088559 WI Juneau   school 5517130 6713 Public school Wonewoc-Union Center 551713002224 60 Wonewoc-Center Elementary   Regular School No Elementary PK 05 2019   kindergarten_4_year_old                                                   17                                             17
3103264 3103264 WI Juneau   school 5517130 6713 Public school Wonewoc-Union Center 551713002224 60 Wonewoc-Center Elementary   Regular School No Elementary PK 05 2018   kindergarten_4_year_old                                                   21                                             21
126297 126297 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002223 120 Wittenberg Elementary   Regular School No 1.0 PK 08 2015   kindergarten_4_year_old                                                   48                                             48
296235 296235 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002223 120 Wittenberg Elementary   Regular School No 1.0 PK 08 2016   kindergarten_4_year_old                                                   51                                             51
340175 340175 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002223 120 Wittenberg Elementary   Regular School No Elementary PK 08 2017   kindergarten_4_year_old                                                   40                                             40
2332834 2332834 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002223 120 Wittenberg Elementary   Regular School No Elementary PK 08 2020   kindergarten_4_year_old                                                   48                                             48
2347824 2347824 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002223 120 Wittenberg Elementary   Regular School No Elementary PK 08 2021   kindergarten_4_year_old                                                   49                                             49
3088544 3088544 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002223 120 Wittenberg Elementary   Regular School No Elementary PK 08 2019   kindergarten_4_year_old                                                   46                                             46
3103249 3103249 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002223 120 Wittenberg Elementary   Regular School No Elementary PK 08 2018   kindergarten_4_year_old                                                   47                                             47
121171 121171 WI Ozaukee   school 5504890 1945 Public school Northern Ozaukee 550489002801 850 Wisconsin Virtual Learning charter Regular School Yes 4.0 PK 12 2015   kindergarten_4_year_old                                                   28                                             28
291129 291129 WI Ozaukee   school 5504890 1945 Public school Northern Ozaukee 550489002801 850 Wisconsin Virtual Learning charter Regular School Yes 4.0 PK 12 2016   kindergarten_4_year_old                                                   26                                             26
334983 334983 WI Ozaukee   school 5504890 1945 Public school Northern Ozaukee 550489002801 850 Wisconsin Virtual Learning charter Regular School Yes Other PK 12 2017   kindergarten_4_year_old                                                   17                                             17
2327625 2327625 WI Ozaukee   school 5504890 1945 Public school Northern Ozaukee 550489002801 850 Wisconsin Virtual Learning charter Regular School Yes Other PK 12 2020   kindergarten_4_year_old                                                   7                                             7
2342499 2342499 WI Ozaukee   school 5504890 1945 Public school Northern Ozaukee 550489002801 850 Wisconsin Virtual Learning charter Regular School Yes Other PK 12 2021   kindergarten_4_year_old                                                   20                                             20
3083362 3083362 WI Ozaukee   school 5504890 1945 Public school Northern Ozaukee 550489002801 850 Wisconsin Virtual Learning charter Regular School Yes Other PK 12 2019   kindergarten_4_year_old                                                   10                                             10
3098061 3098061 WI Ozaukee   school 5504890 1945 Public school Northern Ozaukee 550489002801 850 Wisconsin Virtual Learning charter Regular School Yes Other PK 12 2018   kindergarten_4_year_old                                                   19                                             19
334084 334084 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960000681 399 Wisconsin Conservatory of Lifelong Learning   Regular School No Other PK 12 2017   kindergarten_4_year_old                                                   16                                             16
2326689 2326689 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960000681 399 Wisconsin Conservatory of Lifelong Learning   Regular School No Other PK 12 2020   kindergarten_4_year_old                                                   10                                             10
2341558 2341558 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960000681 399 Wisconsin Conservatory of Lifelong Learning   Regular School No Other PK 12 2021   kindergarten_4_year_old                                                   9                                             9

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