Data source: Big Local News · About: Big Local

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

View and edit SQL

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 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
112013 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002583 145 Appleton Public Montessori charter Regular School Yes 1.0 PK 06 2015   kindergarten_4_year_old                                                   20                                             20
112529 WI Barron   school 5500870 308 Public school Barron Area 550087002717 100 Barron Area Montessori School charter Regular School Yes 1.0 PK 04 2015   kindergarten_4_year_old                                                   19                                             19
112879 WI Washburn   school 5501170 441 Public school Birchwood 550117002937 130 Birchwood Public Montessori charter Regular School Yes 1.0 PK 06 2015   kindergarten_4_year_old                                                   10                                             10
113134 WI Milwaukee   school 5500059 8123 Non District Charter Schools Bruce Guadalupe 550005900772 100 Bruce Guadalupe charter Regular School Yes 1.0 PK 08 2015   kindergarten_4_year_old                                                   144                                             144
113320 WI Milwaukee   school 5500114 8114 Non District Charter Schools Capitol West Academy 550011403355 100 Capitol West Academy charter Regular School Yes 1.0 PK 08 2015   kindergarten_4_year_old                                                   24                                             24
113414 WI Milwaukee   school 5500041 8105 Non District Charter Schools Central City Cyberschool 550004102171 1211 Central City Cyberschool charter Regular School Yes 1.0 PK 08 2015   kindergarten_4_year_old                                                   19                                             19
113478 WI Barron   school 5500061 1080 Public school Chetek-Weyerhaeuser Area 550006102897 800 Link2Learn Virtual Charter School charter Regular School Yes 4.0 PK 12 2015   kindergarten_4_year_old                                                   2                                             2
114149 WI Milwaukee   school 5500047 8109 Non District Charter Schools DLH Academy 550004702536 100 DLH Academy charter Regular School Yes 1.0 PK 08 2015   kindergarten_4_year_old                                                   28                                             28
114214 WI Milwaukee   school 5500039 8101 Non District Charter Schools Downtown Montessori 550003902153 1056 Downtown Montessori charter Regular School Yes 1.0 PK 08 2015   kindergarten_4_year_old                                                   44                                             44
114275 WI Eau Claire   school 5504050 1554 Public school Eau Claire Area 550405002544 111 Chippewa Valley Montessori Charter School charter Regular School Yes 1.0 PK 05 2015   kindergarten_4_year_old                                                   33                                             33
115715 WI Milwaukee   school 5505910 2296 Public school Greendale 550591003347 110 Time 4 Learning Charter School charter Regular School Yes 1.0 PK PK 2015   kindergarten_4_year_old                                                   102                                             102
115902 WI Sawyer   school 5506270 2478 Public school Hayward Community 550627003339 800 Hayward Ctr for Individualized Learning charter Regular School Yes 4.0 PK 12 2015   kindergarten_4_year_old                                                   5                                             5
115933 WI Sawyer   school 5506270 2478 Public school Hayward Community 550627002491 120 Waadookodaading charter Regular School Yes 1.0 PK 05 2015   kindergarten_4_year_old                                                   7                                             7
115953 WI Iowa   school 5506420 2527 Public school Highland 550642000698 20 Highland Community Elementary charter Regular School Yes 1.0 PK 05 2015   kindergarten_4_year_old                                                   13                                             13
116752 WI Kenosha   school 5507320 2793 Public school Kenosha 550732002758 190 Kenosha School of Technology Enhanced Curriculum charter Regular School Yes 1.0 PK 08 2015   kindergarten_4_year_old                                                   62                                             62
117052 WI Manitowoc   school 5507440 2828 Public school Kiel Area 550744002593 110 Meeme LEADS Charter charter Regular School Yes 1.0 PK 02 2015   kindergarten_4_year_old                                                   11                                             11
117157 WI La Crosse   school 5507530 2849 Public school La Crosse 550753001463 140 Coulee Montessori Charter School charter Regular School Yes 1.0 PK 08 2015   kindergarten_4_year_old                                                   12                                             12
118349 WI Taylor   school 5508940 3409 Public school Medford Area Public 550894002598 9100 Rural Virtual Academy charter Regular School Yes 4.0 PK 09 2015   kindergarten_4_year_old                                                   7                                             7
118612 WI Lincoln   school 5509210 3500 Public school Merrill Area 550921002927 800 Bridges Virtual Academy charter Regular School Yes 4.0 PK 12 2015   kindergarten_4_year_old                                                   43                                             43
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
118981 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002498 109 Business and Economics Academy of Milwaukee charter Regular School Yes 1.0 PK 08 2015   kindergarten_4_year_old                                                   66                                             66
119126 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002870 820 Daniels University Preparatory Academy charter Regular School Yes 1.0 PK 08 2015   kindergarten_4_year_old                                                   9                                             9
119353 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002979 880 HAPA-Hmong Amer Peace Academy K3-12 charter Regular School Yes 4.0 PK 12 2015   kindergarten_4_year_old                                                   127                                             127
119373 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001184 211 Hawley Environmental School charter Regular School Yes 1.0 PK 05 2015   kindergarten_4_year_old                                                   57                                             57
119420 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001847 852 Highland Community School charter Regular School Yes 1.0 PK 08 2015   kindergarten_4_year_old                                                   47                                             47
119441 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001246 334 Honey Creek Elementary charter Regular School Yes 1.0 PK 05 2015   kindergarten_4_year_old                                                   66                                             66
119481 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002493 165 IDEAL charter Regular School Yes 1.0 PK 08 2015   kindergarten_4_year_old                                                   27                                             27
119570 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001317 1121 La Causa Charter School charter Regular School Yes 1.0 PK 08 2015   kindergarten_4_year_old                                                   68                                             68
119733 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002853 111 Milwaukee College Preparatory School -- 38th Street charter Regular School Yes 1.0 PK 07 2015   kindergarten_4_year_old                                                   45                                             45
119744 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002860 145 Milwaukee College Preparatory School -- Lloyd Street charter Regular School Yes 1.0 PK 08 2015   kindergarten_4_year_old                                                   50                                             50
119763 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002949 118 Milwaukee Environmental Sciences charter Regular School Yes 1.0 PK 06 2015   kindergarten_4_year_old                                                   32                                             32
119874 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001341 1141 Next Door Charter charter Regular School Yes 1.0 PK KG 2015   kindergarten_4_year_old                                                   230                                             230
120149 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002967 875 Universal Academy for the College Bound charter Regular School Yes 4.0 PK 12 2015   kindergarten_4_year_old                                                   69                                             69
120214 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001271 398 Whittier Elementary charter Regular School Yes 1.0 PK 05 2015   kindergarten_4_year_old                                                   36                                             36
120259 WI Milwaukee   school 5500042 8106 Non District Charter Schools Milwaukee Academy of Science 550004202234 1251 Milwaukee Academy of Science charter Regular School Yes 4.0 PK 12 2015   kindergarten_4_year_old                                                   90                                             90
120270 WI Milwaukee   school 5500048 8103 Non District Charter Schools Milwaukee College Preparatory School -- 550004802537 100 Milwaukee College Preparatory School -- 36th Street charter Regular School Yes 1.0 PK 08 2015   kindergarten_4_year_old                                                   45                                             45
120281 WI Milwaukee   school 5500072 8134 Non District Charter Schools Milwaukee College Preparatory School: 550007203006 100 Milwaukee College Preparatory School: Lola Rowe North Campus charter Regular School Yes 1.0 PK 08 2015   kindergarten_4_year_old                                                   36                                             36
120297 WI Milwaukee   school 5500067 8128 Non District Charter Schools Milwaukee Math and Science Academy 550006702898 800 Milwaukee Math and Science Academy charter Regular School Yes 1.0 PK 08 2015   kindergarten_4_year_old                                                   33                                             33
120308 WI Milwaukee   school 5500065 8129 Non District Charter Schools Milwaukee Scholars Charter School 550006502894 100 Milwaukee Scholars Charter School charter Regular School Yes 1.0 PK 08 2015   kindergarten_4_year_old                                                   70                                             70
120459 WI Marquette   school 5509870 3689 Public school Montello 550987001302 10 Forest Lane Community School charter Regular School Yes 1.0 PK 06 2015   kindergarten_4_year_old                                                   41                                             41
121029 WI Saint Croix   school 5510620 3962 Public school New Richmond 551062002757 150 NR4Kids Charter School charter Regular School Yes 1.0 PK PK 2015   kindergarten_4_year_old                                                   226                                             226
121138 WI Milwaukee   school 5500068 8130 Non District Charter Schools North Point Lighthouse Charter School 550006802922 800 North Point Lighthouse Charter School charter Regular School Yes 1.0 PK 06 2015   kindergarten_4_year_old                                                   33                                             33
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
121223 WI Washburn   school 5509720 3654 Public school Northwood 550972003015 100 Northwood Elementary charter Regular School Yes 1.0 PK 05 2015   kindergarten_4_year_old                                                   20                                             20
121448 WI Oconto   school 5510920 4067 Public school Oconto Unified 551092002710 170 Oconto Literacy Charter School charter Regular School Yes 1.0 PK 02 2015   kindergarten_4_year_old                                                   82                                             82
121560 WI Polk   school 5511160 4165 Public school Osceola 551116002619 100 Osceola Charter Preschool charter Regular School Yes 1.0 PK PK 2015   kindergarten_4_year_old                                                   110                                             110
121605 WI Winnebago   school 5511190 4179 Public school Oshkosh Area 551119002719 110 Jacob Shapiro Brain Based Instruction Laboratory School charter Regular School Yes 1.0 PK 05 2015   kindergarten_4_year_old                                                   41                                             41
121651 WI Winnebago   school 5511190 4179 Public school Oshkosh Area 551119003340 185 Oakwood Environmental Education Charter School charter Regular School Yes 1.0 PK 05 2015   kindergarten_4_year_old                                                   41                                             41
122495 WI Racine   school 5512360 4620 Public school Racine Unified 551236002997 100 Racine Civil Leaders Academy charter Regular School Yes 1.0 PK 05 2015   kindergarten_4_year_old                                                   28                                             28
122702 WI Oneida   school 5512720 4781 Public school Rhinelander 551272001673 20 Northwoods Community Elementary charter Regular School Yes 1.0 PK 05 2015   kindergarten_4_year_old                                                   14                                             14
123041 WI Milwaukee   school 5500071 8133 Non District Charter Schools Rocketship Southside Community Prep 550007102969 100 Rocketship Southside Community Prep charter Regular School Yes 1.0 PK 05 2015   kindergarten_4_year_old                                                   74                                             74
123241 WI Milwaukee   school 5500043 8107 Non District Charter Schools School for Early Development and 550004302497 1279 School for Early Development and Achievement (SEDA) charter Regular School Yes 1.0 PK 02 2015   kindergarten_4_year_old                                                   8                                             8
123252 WI Milwaukee   school 5500057 8121 Non District Charter Schools Seeds of Health Elementary Program 550005702692 100 Seeds of Health Elementary Program charter Regular School Yes 1.0 PK 08 2015   kindergarten_4_year_old                                                   39                                             39
123343 WI Shawano   school 5513620 5264 Public school Shawano 551362002908 110 LEADS Primary Charter School charter Regular School Yes 1.0 PK 02 2015   kindergarten_4_year_old                                                   3                                             3
123443 WI Sheboygan   school 5513650 5271 Public school Sheboygan Area 551365002733 150 Lake Country Academy - Charter charter Regular School Yes 1.0 PK 08 2015   kindergarten_4_year_old                                                   48                                             48
123494 WI Sheboygan   school 5513650 5271 Public school Sheboygan Area 551365002872 105 Sheboygan Leadership Academy charter Regular School Yes 1.0 PK 08 2015   kindergarten_4_year_old                                                   8                                             8
123830 WI Monroe   school 5514160 5460 Public school Sparta Area 551416003358 170 Lakeview Montessori School charter Regular School Yes 1.0 PK 06 2015   kindergarten_4_year_old                                                   21                                             21
123852 WI Monroe   school 5514160 5460 Public school Sparta Area 551416002465 130 Sparta Charter Prekindergarten charter Regular School Yes 1.0 PK PK 2015   kindergarten_4_year_old                                                   162                                             162
123912 WI Washburn   school 5514220 5474 Public school Spooner Area 551422002971 850 Spooner Area Virtual Education Academy charter Regular School Yes 4.0 PK 12 2015   kindergarten_4_year_old                                                   6                                             6
124534 WI Portage   school 5500330 126 Public school Tomorrow River 550033002968 100 Tomorrow River Community Charter charter Regular School Yes 1.0 PK 06 2015   kindergarten_4_year_old                                                   18                                             18
124668 WI Milwaukee   school 5500063 8125 Non District Charter Schools Urban Day School 550006302832 100 Urban Day School charter Regular School Yes 1.0 PK 08 2015   kindergarten_4_year_old                                                   74                                             74
124779 WI Vernon   school 5515360 5985 Public school Viroqua Area 551536002972 140 Viroqua Area Montessori School charter Regular School Yes 1.0 PK 03 2015   kindergarten_4_year_old                                                   17                                             17
126036 WI Milwaukee   school 5506000 6470 Public school Whitnall 550600002673 130 CORE4 charter Regular School Yes 1.0 PK PK 2015   kindergarten_4_year_old                                                   112                                             112
126230 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002781 170 Mead Elementary Charter School charter Regular School Yes 1.0 PK 05 2015   kindergarten_4_year_old                                                   27                                             27
126243 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002212 220 THINK Academy charter Regular School Yes 1.0 PK 05 2015   kindergarten_4_year_old                                                   30                                             30
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
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
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
281988 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002583 145 Appleton Public Montessori charter Regular School Yes 1.0 PK 06 2016   kindergarten_4_year_old                                                   19                                             19
282509 WI Barron   school 5500870 308 Public school Barron Area 550087002717 100 Barron Area Montessori School charter Regular School Yes 1.0 PK 04 2016   kindergarten_4_year_old                                                   11                                             11
282857 WI Washburn   school 5501170 441 Public school Birchwood 550117002937 130 Birchwood Public Montessori charter Regular School Yes 1.0 PK 06 2016   kindergarten_4_year_old                                                   3                                             3
283116 WI Milwaukee   school 5500059 8123 Non District Charter Schools Bruce Guadalupe 550005900772 100 Bruce Guadalupe charter Regular School Yes 1.0 PK 08 2016   kindergarten_4_year_old                                                   144                                             144
283302 WI Milwaukee   school 5500114 8114 Non District Charter Schools Capitol West Academy 550011403355 100 Capitol West Academy charter Regular School Yes 1.0 PK 08 2016   kindergarten_4_year_old                                                   24                                             24
283396 WI Milwaukee   school 5500041 8105 Non District Charter Schools Central City Cyberschool 550004102171 1211 Central City Cyberschool charter Regular School Yes 1.0 PK 08 2016   kindergarten_4_year_old                                                   41                                             41
283456 WI Barron   school 5500061 1080 Public school Chetek-Weyerhaeuser Area 550006102897 800 Link2Learn Virtual Charter School charter Regular School Yes 4.0 PK 12 2016   kindergarten_4_year_old                                                   1                                             1
284129 WI Milwaukee   school 5500047 8109 Non District Charter Schools DLH Academy 550004702536 100 DLH Academy charter Regular School Yes 1.0 PK 08 2016   kindergarten_4_year_old                                                   20                                             20
284195 WI Milwaukee   school 5500039 8101 Non District Charter Schools Downtown Montessori 550003902153 1056 Downtown Montessori charter Regular School Yes 1.0 PK 08 2016   kindergarten_4_year_old                                                   44                                             44
284257 WI Eau Claire   school 5504050 1554 Public school Eau Claire Area 550405002544 111 Chippewa Valley Montessori Charter School charter Regular School Yes 1.0 PK 05 2016   kindergarten_4_year_old                                                   32                                             32
284515 WI Walworth   school 5504290 1638 Public school Elkhorn Area 550429003038 800 Elkhorn Options Virtual School charter Regular School Yes 4.0 PK 12 2016   kindergarten_4_year_old                                                   4                                             4
285720 WI Milwaukee   school 5505910 2296 Public school Greendale 550591003347 110 Time 4 Learning Charter School charter Regular School Yes 1.0 PK PK 2016   kindergarten_4_year_old                                                   100                                             100
285905 WI Sawyer   school 5506270 2478 Public school Hayward Community 550627003339 800 Hayward Ctr for Individualized Learning charter Regular School Yes 4.0 PK 12 2016   kindergarten_4_year_old                                                   10                                             10
285948 WI Iowa   school 5506420 2527 Public school Highland 550642000698 20 Highland Community Elementary charter Regular School Yes 1.0 PK 05 2016   kindergarten_4_year_old                                                   14                                             14
286569 WI Outagamie   school 5507290 2758 Public school Kaukauna Area 550729002878 110 New Directions Learning Community charter Regular School Yes 1.0 PK 04 2016   kindergarten_4_year_old                                                   33                                             33
286759 WI Kenosha   school 5507320 2793 Public school Kenosha 550732002758 190 Kenosha School of Technology Enhanced Curriculum charter Regular School Yes 1.0 PK 08 2016   kindergarten_4_year_old                                                   62                                             62
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
287129 WI Waukesha   school 5500073 8135 Non District Charter Schools La Casa de Esperanza Charter School 550007303031 100 La Casa de Esperanza Charter School charter Regular School Yes 1.0 PK 08 2016   kindergarten_4_year_old                                                   48                                             48
287149 WI La Crosse   school 5507530 2849 Public school La Crosse 550753001463 140 Coulee Montessori Charter School charter Regular School Yes 1.0 PK 08 2016   kindergarten_4_year_old                                                   13                                             13
288250 WI Juneau   school 5508850 3360 Public school Mauston 550885003030 110 Mauston Montessori Charter School charter Regular School Yes 1.0 PK 02 2016   kindergarten_4_year_old                                                   3                                             3
288345 WI Taylor   school 5508940 3409 Public school Medford Area Public 550894002598 9100 Rural Virtual Academy charter Regular School Yes 4.0 PK 10 2016   kindergarten_4_year_old                                                   13                                             13
288612 WI Lincoln   school 5509210 3500 Public school Merrill Area 550921002927 800 Bridges Virtual Academy charter Regular School Yes 4.0 PK 12 2016   kindergarten_4_year_old                                                   39                                             39
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
288966 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002498 109 Business and Economics Academy of Milwaukee charter Regular School Yes 1.0 PK 08 2016   kindergarten_4_year_old                                                   56                                             56
289110 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002870 820 Daniels University Preparatory Academy charter Regular School Yes 1.0 PK 08 2016   kindergarten_4_year_old                                                   20                                             20
289334 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002979 880 HAPA-Hmong Amer Peace Academy K3-12 charter Regular School Yes 4.0 PK 12 2016   kindergarten_4_year_old                                                   132                                             132
289399 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001847 852 Highland Community School charter Regular School Yes 1.0 PK 08 2016   kindergarten_4_year_old                                                   54                                             54
289420 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001246 334 Honey Creek Elementary charter Regular School Yes 1.0 PK 05 2016   kindergarten_4_year_old                                                   54                                             54
289461 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002493 165 IDEAL charter Regular School Yes 1.0 PK 08 2016   kindergarten_4_year_old                                                   26                                             26
289547 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001317 1121 La Causa Charter School charter Regular School Yes 1.0 PK 08 2016   kindergarten_4_year_old                                                   67                                             67
289703 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002853 111 Milwaukee College Preparatory School -- 38th Street charter Regular School Yes 1.0 PK 08 2016   kindergarten_4_year_old                                                   55                                             55

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