enrollments

Data source: Big Local News · About: Big Local

828 rows where grade = "kindergarten_4_year_old", state = "WI" and year = 2018 sorted by school

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2018 · 828 ✖

grade ✖

  • kindergarten_4_year_old · 828 ✖
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
3088713 3088713 WI Green   school 5500120 63 Public school Albany 550012000013 20 Albany Elementary   Regular School No Elementary PK 05 2018   kindergarten_4_year_old                                                   25                                             25
3095752 3095752 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001121 75 Alcott Elementary   Regular School No Elementary PK 08 2018   kindergarten_4_year_old                                                   27                                             27
3092317 3092317 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000610 20 Aldo Leopold Community School K-8   Regular School No Elementary PK 08 2018   kindergarten_4_year_old                                                   41                                             41
3088728 3088728 WI Kewaunee   school 5500150 70 Public school Algoma 550015000015 20 Algoma Elementary   Regular School No Elementary PK 06 2018   kindergarten_4_year_old                                                   36                                             36
3099252 3099252 WI Racine   school 5512360 4620 Public school Racine Unified 551236002657 113 All District 4 Year Old Kindergarten   Regular School No Prekindergarten PK PK 2018   kindergarten_4_year_old                                                   20                                             20
3095761 3095761 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001122 73 Allen-Field Elementary   Regular School No Elementary PK 05 2018   kindergarten_4_year_old                                                   61                                             61
3100565 3100565 WI Washington   school 5513950 5390 Public school Slinger 551395001818 10 Allenton Elementary   Regular School No Elementary PK 05 2018   kindergarten_4_year_old                                                   55                                             55
3094571 3094571 WI Dane   school 5508520 3269 Public school Madison Metropolitan 550852000929 225 Allis Elementary   Regular School No Elementary PK 05 2018   kindergarten_4_year_old                                                   90                                             90
3088747 3088747 WI Buffalo   school 5500180 84 Public school Alma 550018000017 20 Alma Elementary   Regular School No Elementary PK 08 2018   kindergarten_4_year_old                                                   12                                             12
3088779 3088779 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000023 20 Almond-Bancroft Elementary   Regular School No Elementary PK 05 2018   kindergarten_4_year_old                                                   22                                             22
3088795 3088795 WI Eau Claire   school 5500270 112 Public school Altoona 550027000028 80 Altoona Elementary   Regular School No Elementary PK 03 2018   kindergarten_4_year_old                                                   104                                             104
3101410 3101410 WI Portage   school 5500330 126 Public school Tomorrow River 550033000032 20 Amherst Elementary   Regular School No Elementary PK 04 2018   kindergarten_4_year_old                                                   52                                             52
3095777 3095777 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960003056 124 Andrew Douglas School   Regular School No Elementary PK 08 2018   kindergarten_4_year_old                                                   12                                             12
3088903 3088903 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002976 165 Appleton Community 4K   Regular School No Prekindergarten PK PK 2018   kindergarten_4_year_old                                                   934                                             934
3088918 3088918 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002583 145 Appleton Public Montessori charter Regular School Yes Elementary PK 06 2018   kindergarten_4_year_old                                                   20                                             20
3103307 3103307 WI Vilas   school 5517160 6720 Public school Woodruff J1 551716002227 20 Arbor Vitae-Woodruff Elementary   Regular School No Elementary PK 08 2018   kindergarten_4_year_old                                                   44                                             44
3089157 3089157 WI Trempealeau   school 5500420 154 Public school Arcadia 550042003040 190 Arcadia Elementary   Regular School No Elementary PK 04 2018   kindergarten_4_year_old                                                   94                                             94
3089176 3089176 WI Lafayette   school 5500450 161 Public school Argyle 550045000069 20 Argyle Elementary   Regular School No Elementary PK 05 2018   kindergarten_4_year_old                                                   20                                             20
3100480 3100480 WI Milwaukee   school 5513800 5355 Public school Shorewood 551380001809 20 Atwater Elementary   Regular School No Elementary PK 06 2018   kindergarten_4_year_old                                                   41                                             41
3089282 3089282 WI Wood   school 5500600 203 Public school Auburndale 550060000090 40 Auburndale Elementary   Regular School No Elementary PK 05 2018   kindergarten_4_year_old                                                   68                                             68
3095803 3095803 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001124 77 Auer Avenue Elementary   Regular School No Elementary PK 08 2018   kindergarten_4_year_old                                                   22                                             22
3089302 3089302 WI Eau Claire   school 5500630 217 Public school Augusta 550063000092 20 Augusta Elementary   Regular School No Elementary PK 05 2018   kindergarten_4_year_old                                                   42                                             42
3099087 3099087 WI Crawford   school 5512150 4543 Public school Prairie du Chien Area 551215002508 10 BA Kennedy School   Regular School No Elementary PK 01 2018   kindergarten_4_year_old                                                   71                                             71
3089345 3089345 WI La Crosse   school 5500780 245 Public school Bangor 550078000100 20 Bangor Elementary   Regular School No Elementary PK 05 2018   kindergarten_4_year_old                                                   40                                             40
3101891 3101891 WI Waukesha   school 5515780 6174 Public school Waukesha 551578002004 20 Banting Elementary   Regular School No Elementary PK 05 2018   kindergarten_4_year_old                                                   40                                             40
3089364 3089364 WI Sauk   school 5500810 280 Public school Baraboo 550081002803 150 Baraboo Early Learning Cooperative   Regular School No Prekindergarten PK PK 2018   kindergarten_4_year_old                                                   160                                             160
3089366 3089366 WI Sauk   school 5500810 280 Public school Baraboo 550081002802 160 Baraboo Early Learning Cooperative Renewal Head Start of Baraboo   Regular School No Prekindergarten PK PK 2018   kindergarten_4_year_old                                                   16                                             16
3095818 3095818 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001170 188 Barbee Elementary   Regular School No Elementary PK 06 2018   kindergarten_4_year_old                                                   42                                             42
3099794 3099794 WI Fond du Lac   school 5513020 4872 Public school Ripon Area 551302001893 110 Barlow Park Elementary   Regular School No Elementary PK 02 2018   kindergarten_4_year_old                                                   97                                             97
3089407 3089407 WI Iowa   school 5500840 287 Public school Barneveld 550084000111 20 Barneveld Elementary   Regular School No Elementary PK 05 2018   kindergarten_4_year_old                                                   38                                             38
3089439 3089439 WI Barron   school 5500870 308 Public school Barron Area 550087002717 100 Barron Area Montessori School charter Regular School Yes Elementary PK 03 2018   kindergarten_4_year_old                                                   9                                             9
3095827 3095827 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001126 81 Barton Elementary   Regular School No Elementary PK 05 2018   kindergarten_4_year_old                                                   32                                             32
3095840 3095840 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002911 112 Bay View Montessori School   Regular School No Elementary PK 04 2018   kindergarten_4_year_old                                                   47                                             47
3092344 3092344 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000613 60 Beaumont Elementary   Regular School No Elementary PK 05 2018   kindergarten_4_year_old                                                   34                                             34
3089568 3089568 WI Dane   school 5500990 350 Public school Belleville 550099000131 20 Belleville Elementary   Regular School No Elementary PK 01 2018   kindergarten_4_year_old                                                   55                                             55
3089591 3089591 WI Lafayette   school 5501020 364 Public school Belmont Community 550102000134 20 Belmont Elementary   Regular School No Elementary PK 05 2018   kindergarten_4_year_old                                                   26                                             26
3089608 3089608 WI Rock   school 5501050 413 Public school Beloit 550105002855 150 Beloit Early Learning   Regular School No Prekindergarten PK PK 2018   kindergarten_4_year_old                                                   42                                             42
3095412 3095412 WI Waukesha   school 5509060 3437 Public school Menomonee Falls 550906001061 40 Benjamin Franklin Elementary and Early Learning Center   Regular School No Elementary PK 02 2018   kindergarten_4_year_old                                                   117                                             117
3089728 3089728 WI Lafayette   school 5501110 427 Public school Benton 550111000160 20 Benton Elementary   Regular School No Elementary PK 06 2018   kindergarten_4_year_old                                                   16                                             16
3101900 3101900 WI Waukesha   school 5515780 6174 Public school Waukesha 551578002006 60 Bethesda Elementary   Regular School No Elementary PK 05 2018   kindergarten_4_year_old                                                   39                                             39
3095852 3095852 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001256 356 Bethune Academy   Regular School No Elementary PK 08 2018   kindergarten_4_year_old                                                   19                                             19
3089779 3089779 WI Washburn   school 5501170 441 Public school Birchwood 550117000168 20 Birchwood Elementary   Regular School No Elementary PK 05 2018   kindergarten_4_year_old                                                   14                                             14
3089798 3089798 WI Washburn   school 5501170 441 Public school Birchwood 550117002937 130 Birchwood Public Montessori charter Regular School Yes Elementary PK 06 2018   kindergarten_4_year_old                                                   5                                             5
3103238 3103238 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002218 20 Birnamwood Elementary   Regular School No Elementary PK 08 2018   kindergarten_4_year_old                                                   28                                             28
3100203 3100203 WI Outagamie   school 5513530 5138 Public school Seymour Community 551353001769 20 Black Creek Elementary   Regular School No Elementary PK 08 2018   kindergarten_4_year_old                                                   39                                             39
3103129 3103129 WI Dane   school 5501230 469 Public school Wisconsin Heights 550123000170 20 Black Earth Elementary   Regular School No Elementary PK 02 2018   kindergarten_4_year_old                                                   60                                             60
3089814 3089814 WI Lafayette   school 5505730 2240 Public school Black Hawk 550573000608 160 Black Hawk Elementary   Regular School No Elementary PK 05 2018   kindergarten_4_year_old                                                   32                                             32
3101909 3101909 WI Waukesha   school 5515780 6174 Public school Waukesha 551578002007 80 Blair Elementary   Regular School No Elementary PK 05 2018   kindergarten_4_year_old                                                   20                                             20
3089852 3089852 WI Trempealeau   school 5500016 485 Public school Blair-Taylor 550001602380 34 Blair-Taylor Elementary   Regular School No Elementary PK 06 2018   kindergarten_4_year_old                                                   43                                             43
3100624 3100624 WI Milwaukee   school 5514040 5439 Public school South Milwaukee 551404001826 10 Blakewood Elementary   Regular School No Elementary PK 05 2018   kindergarten_4_year_old                                                   44                                             44
3089874 3089874 WI Chippewa   school 5501350 497 Public school Bloomer 550135000183 20 Bloomer Elementary   Regular School No Elementary PK 04 2018   kindergarten_4_year_old                                                   86                                             86
3089894 3089894 WI Shawano   school 5501470 602 Public school Bonduel 550147000188 20 Bonduel Elementary   Regular School No Elementary PK 06 2018   kindergarten_4_year_old                                                   43                                             43
3089912 3089912 WI Grant   school 5501500 609 Public school Boscobel Area 550150000192 20 Boscobel Elementary   Regular School No Elementary PK 06 2018   kindergarten_4_year_old                                                   58                                             58
3093536 3093536 WI Kenosha   school 5507320 2793 Public school Kenosha 550732000800 50 Bose Elementary   Regular School No Elementary PK 05 2018   kindergarten_4_year_old                                                   35                                             35
3089930 3089930 WI Shawano   school 5501560 623 Public school Bowler 550156000199 20 Bowler Elementary   Regular School No Elementary PK 06 2018   kindergarten_4_year_old                                                   17                                             17
3100837 3100837 WI Chippewa   school 5514430 5593 Public school Stanley-Boyd Area 551443001864 20 Boyd Elementary   Regular School No Prekindergarten PK PK 2018   kindergarten_4_year_old                                                   56                                             56
3099948 3099948 WI Fond du Lac   school 5513100 4956 Public school Rosendale-Brandon 551310001727 25 Brandon Elementary   Regular School No Elementary PK 05 2018   kindergarten_4_year_old                                                   17                                             17
3093550 3093550 WI Kenosha   school 5507320 2793 Public school Kenosha 550732000816 340 Brass Community School   Regular School No Elementary PK 05 2018   kindergarten_4_year_old                                                   54                                             54
3100099 3100099 WI Sauk   school 5513410 5100 Public school Sauk Prairie 551341001761 150 Bridges Elementary   Regular School No Elementary PK 02 2018   kindergarten_4_year_old                                                   153                                             153
3095555 3095555 WI Lincoln   school 5509210 3500 Public school Merrill Area 550921002927 800 Bridges Virtual Academy charter Regular School Yes Other PK 12 2018   kindergarten_4_year_old                                                   59                                             59
3089972 3089972 WI Kenosha   school 5501650 657 Public school Brighton #1 550165000205 20 Brighton Elementary   Regular School No Elementary PK 08 2018   kindergarten_4_year_old                                                   17                                             17
3089980 3089980 WI Calumet   school 5501680 658 Public school Brillion 550168000206 20 Brillion Elementary   Regular School No Elementary PK 05 2018   kindergarten_4_year_old                                                   43                                             43
3090001 3090001 WI Kenosha   school 5501710 665 Public school Bristol #1 550171000209 20 Bristol Elementary   Regular School No Elementary PK 08 2018   kindergarten_4_year_old                                                   67                                             67
3092059 3092059 WI Walworth   school 5505130 2051 Public school Genoa City J2 550513000547 20 Brookwood Elementary   Regular School No Elementary PK 03 2018   kindergarten_4_year_old                                                   34                                             34
3090028 3090028 WI Milwaukee   school 5501800 721 Public school Brown Deer 550180000232 80 Brown Deer Elementary   Regular School No Elementary PK 06 2018   kindergarten_4_year_old                                                   73                                             73
3095866 3095866 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002395 89 Brown Street Academy   Regular School No Elementary PK 05 2018   kindergarten_4_year_old                                                   30                                             30
3095875 3095875 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001132 92 Browning Elementary   Regular School No Elementary PK 05 2018   kindergarten_4_year_old                                                   27                                             27
3090044 3090044 WI Rusk   school 5501830 735 Public school Bruce 550183000234 20 Bruce Elementary   Regular School No Elementary PK 05 2018   kindergarten_4_year_old                                                   22                                             22
3095884 3095884 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001133 93 Bruce Elementary   Regular School No Elementary PK 05 2018   kindergarten_4_year_old                                                   28                                             28
3090065 3090065 WI Milwaukee   school 5500059 8123 Non District Charter Schools Bruce Guadalupe 550005900772 100 Bruce Guadalupe charter Regular School Yes Elementary PK 08 2018   kindergarten_4_year_old                                                   143                                             143
3095893 3095893 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001134 94 Bryant Elementary   Regular School No Elementary PK 05 2018   kindergarten_4_year_old                                                   26                                             26
3101159 3101159 WI Douglas   school 5514670 5663 Public school Superior 551467001906 40 Bryant Elementary   Regular School No Elementary PK 05 2018   kindergarten_4_year_old                                                   17                                             17
3095905 3095905 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001135 95 Burbank Elementary   Regular School No Elementary PK 08 2018   kindergarten_4_year_old                                                   56                                             56
3095916 3095916 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001136 98 Burdick Elementary   Regular School No Elementary PK 08 2018   kindergarten_4_year_old                                                   55                                             55
3095355 3095355 WI Winnebago   school 5509030 3430 Public school Menasha Joint 550903001054 40 Butte des Morts Elementary   Regular School No Elementary PK 05 2018   kindergarten_4_year_old                                                   50                                             50
3090116 3090116 WI Ashland   school 5501920 840 Public school Butternut 550192000245 20 Butternut Elementary   Regular School No Elementary PK 05 2018   kindergarten_4_year_old                                                   6                                             6
3102982 3102982 WI Milwaukee   school 5506000 6470 Public school Whitnall 550600002673 130 CORE4 Collaborating on Readiness Education for Four-Year-Olds charter Regular School Yes Prekindergarten PK PK 2018   kindergarten_4_year_old                                                   113                                             113
3091182 3091182 WI Pepin   school 5503840 1499 Public school Durand-Arkansaw 550384000116 20 Caddie Woodlawn Elementary   Regular School No Elementary PK 05 2018   kindergarten_4_year_old                                                   79                                             79
3090137 3090137 WI Chippewa   school 5502040 870 Public school Cadott Community 550204000247 20 Cadott Elementary   Regular School No Elementary PK 06 2018   kindergarten_4_year_old                                                   48                                             48
3090154 3090154 WI Columbia   school 5502070 882 Public school Cambria-Friesland 550207000253 60 Cambria Friesland Elementary   Regular School No Elementary PK 05 2018   kindergarten_4_year_old                                                   23                                             23
3090171 3090171 WI Dane   school 5502100 896 Public school Cambridge 550210000254 20 Cambridge Elementary   Regular School No Elementary PK 05 2018   kindergarten_4_year_old                                                   53                                             53
3090202 3090202 WI Barron   school 5502130 903 Public school Cameron 550213000256 20 Cameron Elementary   Regular School No Elementary PK 04 2018   kindergarten_4_year_old                                                   54                                             54
3090224 3090224 WI Fond du Lac   school 5502160 910 Public school Campbellsport 550216000258 20 Campbellsport Elementary   Regular School No Elementary PK 05 2018   kindergarten_4_year_old                                                   40                                             40
3090254 3090254 WI Milwaukee   school 5500114 8114 Non District Charter Schools Capitol West Academy 550011403355 100 Capitol West Academy charter Regular School Yes Elementary PK 08 2018   kindergarten_4_year_old                                                   12                                             12
3095944 3095944 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001829 108 Carson Academy   Regular School No Elementary PK 08 2018   kindergarten_4_year_old                                                   40                                             40
3095956 3095956 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002602 178 Carver Academy   Regular School No Elementary PK 08 2018   kindergarten_4_year_old                                                   27                                             27

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