enrollments

Data source: Big Local News · About: Big Local

627 rows where grade = "kindergarten_3_year_old" and state = "WI" sorted by ccd_charter_school descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • kindergarten_3_year_old · 627 ✖
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
118803 118803 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_3_year_old                                                   48                                             48
119419 119419 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001847 852 Highland Community School charter Regular School Yes 1.0 PK 08 2015   kindergarten_3_year_old                                                   55                                             55
119440 119440 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001246 334 Honey Creek Elementary charter Regular School Yes 1.0 PK 05 2015   kindergarten_3_year_old                                                   3                                             3
123240 123240 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_3_year_old                                                   4                                             4
288797 288797 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_3_year_old                                                   49                                             49
289398 289398 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001847 852 Highland Community School charter Regular School Yes 1.0 PK 08 2016   kindergarten_3_year_old                                                   47                                             47
289419 289419 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001246 334 Honey Creek Elementary charter Regular School Yes 1.0 PK 05 2016   kindergarten_3_year_old                                                   5                                             5
289844 289844 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001341 1141 Next Door Charter charter Regular School Yes 1.0 PK KG 2016   kindergarten_3_year_old                                                   2                                             2
290170 290170 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001271 398 Whittier Elementary charter Regular School Yes 1.0 PK 05 2016   kindergarten_3_year_old                                                   2                                             2
293193 293193 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 2016   kindergarten_3_year_old                                                   5                                             5
328092 328092 WI Milwaukee   school 5500039 8101 Non District Charter Schools Downtown Montessori 550003902153 1056 Downtown Montessori charter Regular School Yes Elementary PK 08 2017   kindergarten_3_year_old                                                   24                                             24
332667 332667 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960003371 162 ALBA - Academia de Lenguaje y Bellas Artes charter Regular School Yes Elementary PK 05 2017   kindergarten_3_year_old                                                   55                                             55
333269 333269 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001847 852 Highland Community School charter Regular School Yes Elementary PK 08 2017   kindergarten_3_year_old                                                   50                                             50
333290 333290 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001246 334 Honey Creek Elementary charter Regular School Yes Elementary PK 05 2017   kindergarten_3_year_old                                                   3                                             3
334062 334062 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001271 398 Whittier Elementary charter Regular School Yes Elementary PK 05 2017   kindergarten_3_year_old                                                   1                                             1
335690 335690 WI Milwaukee   school 5500078 8138 Non District Charter Schools Penfield Montessori Academy 550007803048 8138 Penfield Montessori Academy charter Regular School Yes Elementary PK 08 2017   kindergarten_3_year_old                                                   19                                             19
337073 337073 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 Elementary PK 02 2017   kindergarten_3_year_old                                                   5                                             5
2320632 2320632 WI Milwaukee   school 5500039 8101 Non District Charter Schools Downtown Montessori 550003902153 1056 Downtown Montessori charter Regular School Yes Elementary PK 08 2020   kindergarten_3_year_old                                                   21                                             21
2325296 2325296 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960003371 162 ALBA - Academia de Lenguaje y Bellas Artes charter Regular School Yes Elementary PK 06 2020   kindergarten_3_year_old                                                   35                                             35
2325900 2325900 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001847 852 Highland Community School charter Regular School Yes Elementary PK 08 2020   kindergarten_3_year_old                                                   47                                             47
2325920 2325920 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001246 334 Honey Creek Elementary charter Regular School Yes Elementary PK 05 2020   kindergarten_3_year_old                                                   5                                             5
2328326 2328326 WI Milwaukee   school 5500078 8138 Non District Charter Schools Penfield Montessori Academy 550007803048 8138 Penfield Montessori Academy charter Regular School Yes Elementary PK 08 2020   kindergarten_3_year_old                                                   18                                             18
2335433 2335433 WI Milwaukee   school 5500039 8101 Non District Charter Schools Downtown Montessori 550003902153 1056 Downtown Montessori charter Regular School Yes Elementary PK 08 2021   kindergarten_3_year_old                                                   15                                             15
2340190 2340190 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960003371 162 ALBA - Academia de Lenguaje y Bellas Artes charter Regular School Yes Elementary PK 07 2021   kindergarten_3_year_old                                                   20                                             20
2340795 2340795 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001847 852 Highland Community School charter Regular School Yes Elementary PK 08 2021   kindergarten_3_year_old                                                   44                                             44
2343217 2343217 WI Milwaukee   school 5500078 8138 Non District Charter Schools Penfield Montessori Academy 550007803048 8138 Penfield Montessori Academy charter Regular School Yes Elementary PK 04 2021   kindergarten_3_year_old                                                   15                                             15
3076409 3076409 WI Milwaukee   school 5500039 8101 Non District Charter Schools Downtown Montessori 550003902153 1056 Downtown Montessori charter Regular School Yes Elementary PK 08 2019   kindergarten_3_year_old                                                   21                                             21
3081024 3081024 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960003371 162 ALBA - Academia de Lenguaje y Bellas Artes charter Regular School Yes Elementary PK 05 2019   kindergarten_3_year_old                                                   37                                             37
3081645 3081645 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001847 852 Highland Community School charter Regular School Yes Elementary PK 08 2019   kindergarten_3_year_old                                                   52                                             52
3081666 3081666 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001246 334 Honey Creek Elementary charter Regular School Yes Elementary PK 05 2019   kindergarten_3_year_old                                                   8                                             8
3081702 3081702 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002493 165 IDEAL Individualized Developmental Educational Approaches to Learning charter Regular School Yes Elementary PK 08 2019   kindergarten_3_year_old                                                   1                                             1
3082432 3082432 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001271 398 Whittier Elementary charter Regular School Yes Elementary PK 05 2019   kindergarten_3_year_old                                                   1                                             1
3085401 3085401 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 Elementary PK 02 2019   kindergarten_3_year_old                                                   2                                             2
3091156 3091156 WI Milwaukee   school 5500039 8101 Non District Charter Schools Downtown Montessori 550003902153 1056 Downtown Montessori charter Regular School Yes Elementary PK 08 2018   kindergarten_3_year_old                                                   23                                             23
3095739 3095739 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_3_year_old                                                   35                                             35
3096354 3096354 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001847 852 Highland Community School charter Regular School Yes Elementary PK 08 2018   kindergarten_3_year_old                                                   42                                             42
3096375 3096375 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001246 334 Honey Creek Elementary charter Regular School Yes Elementary PK 05 2018   kindergarten_3_year_old                                                   1                                             1
3098773 3098773 WI Milwaukee   school 5500078 8138 Non District Charter Schools Penfield Montessori Academy 550007803048 8138 Penfield Montessori Academy charter Regular School Yes Elementary PK 08 2018   kindergarten_3_year_old                                                   39                                             39
3100133 3100133 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 Elementary PK 02 2018   kindergarten_3_year_old                                                   4                                             4
118787 118787 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001239 316 Academy of Accelerated Learning   Regular School No 1.0 PK 05 2015   kindergarten_3_year_old                                                   6                                             6
118816 118816 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001121 75 Alcott Elementary   Regular School No 1.0 PK 08 2015   kindergarten_3_year_old                                                   1                                             1
118825 118825 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001122 73 Allen-Field Elementary   Regular School No 1.0 PK 05 2015   kindergarten_3_year_old                                                   15                                             15
118856 118856 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001124 77 Auer Avenue Elementary   Regular School No 1.0 PK 08 2015   kindergarten_3_year_old                                                   4                                             4
118875 118875 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001170 188 Barbee Elementary   Regular School No 1.0 PK 06 2015   kindergarten_3_year_old                                                   74                                             74
118885 118885 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001126 81 Barton Elementary   Regular School No 1.0 PK 06 2015   kindergarten_3_year_old                                                   3                                             3
118903 118903 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001256 356 Bethune Academy   Regular School No 1.0 PK 08 2015   kindergarten_3_year_old                                                   1                                             1
118918 118918 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002395 89 Brown Street Academy   Regular School No 1.0 PK 05 2015   kindergarten_3_year_old                                                   4                                             4
118927 118927 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001132 92 Browning Elementary   Regular School No 1.0 PK 05 2015   kindergarten_3_year_old                                                   3                                             3
118936 118936 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001133 93 Bruce Elementary   Regular School No 1.0 PK 05 2015   kindergarten_3_year_old                                                   2                                             2
118945 118945 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001134 94 Bryant Elementary   Regular School No 1.0 PK 05 2015   kindergarten_3_year_old                                                   3                                             3
118957 118957 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001135 95 Burbank Elementary   Regular School No 1.0 PK 08 2015   kindergarten_3_year_old                                                   3                                             3
118969 118969 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001136 98 Burdick Elementary   Regular School No 1.0 PK 08 2015   kindergarten_3_year_old                                                   6                                             6
119003 119003 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001829 108 Carson Academy   Regular School No 1.0 PK 08 2015   kindergarten_3_year_old                                                   37                                             37
119016 119016 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002602 178 Carver Academy   Regular School No 1.0 PK 08 2015   kindergarten_3_year_old                                                   1                                             1
119039 119039 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001140 110 Clarke Street Elementary   Regular School No 1.0 PK 08 2015   kindergarten_3_year_old                                                   3                                             3
119048 119048 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001141 114 Clemens Elementary   Regular School No 1.0 PK 05 2015   kindergarten_3_year_old                                                   1                                             1
119060 119060 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001142 113 Clement Avenue Elementary   Regular School No 1.0 PK 08 2015   kindergarten_3_year_old                                                   6                                             6
119077 119077 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001143 116 Congress Elementary   Regular School No 1.0 PK 08 2015   kindergarten_3_year_old                                                   83                                             83
119090 119090 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001144 117 Cooper Elementary   Regular School No 1.0 PK 08 2015   kindergarten_3_year_old                                                   1                                             1
119102 119102 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001045 501 Craig Montessori School   Regular School No 1.0 PK 08 2015   kindergarten_3_year_old                                                   78                                             78
119114 119114 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001146 122 Curtin Elementary   Regular School No 1.0 PK 08 2015   kindergarten_3_year_old                                                   2                                             2
119137 119137 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001148 125 Doerfler Elementary   Regular School No 1.0 PK 08 2015   kindergarten_3_year_old                                                   12                                             12
119149 119149 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001154 143 Eighty-First Street Elementary   Regular School No 1.0 PK 08 2015   kindergarten_3_year_old                                                   45                                             45
119158 119158 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002438 148 Elm Creative Arts Elementary   Regular School No 1.0 PK 05 2015   kindergarten_3_year_old                                                   6                                             6
119167 119167 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001157 150 Emerson Elementary   Regular School No 1.0 PK 05 2015   kindergarten_3_year_old                                                   4                                             4
119176 119176 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001158 152 Engleburg Elementary   Regular School No 1.0 PK 05 2015   kindergarten_3_year_old                                                   4                                             4
119199 119199 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001160 158 Fernwood Montessori   Regular School No 1.0 PK 08 2015   kindergarten_3_year_old                                                   73                                             73
119211 119211 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001162 170 Fifty-Third Street Elementary   Regular School No 1.0 PK 08 2015   kindergarten_3_year_old                                                   2                                             2
119220 119220 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001163 173 Forest Home Elementary   Regular School No 1.0 PK 05 2015   kindergarten_3_year_old                                                   65                                             65
119233 119233 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001165 179 Franklin Elementary   Regular School No 1.0 PK 08 2015   kindergarten_3_year_old                                                   12                                             12
119242 119242 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001166 182 Fratney Elementary   Regular School No 1.0 PK 05 2015   kindergarten_3_year_old                                                   5                                             5
119254 119254 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001169 185 Gaenslen Elementary   Regular School No 1.0 PK 08 2015   kindergarten_3_year_old                                                   8                                             8
119266 119266 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001172 191 Garland Elementary   Regular School No 1.0 PK 08 2015   kindergarten_3_year_old                                                   1                                             1
119275 119275 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001173 192 Goodrich Elementary   Regular School No 1.0 PK 05 2015   kindergarten_3_year_old                                                   6                                             6
119292 119292 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001175 193 Grant Elementary   Regular School No 1.0 PK 08 2015   kindergarten_3_year_old                                                   3                                             3
119305 119305 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001176 196 Grantosa Drive Elementary   Regular School No 1.0 PK 08 2015   kindergarten_3_year_old                                                   13                                             13
119317 119317 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001179 202 Greenfield Bilingual   Regular School No 1.0 PK 08 2015   kindergarten_3_year_old                                                   5                                             5
119336 119336 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001181 205 Hampton Elementary   Regular School No 1.0 PK 05 2015   kindergarten_3_year_old                                                   28                                             28
119364 119364 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001183 208 Hartford Avenue Elementary   Regular School No 1.0 PK 08 2015   kindergarten_3_year_old                                                   1                                             1
119381 119381 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001185 212 Hawthorne Elementary   Regular School No 1.0 PK 05 2015   kindergarten_3_year_old                                                   32                                             32
119394 119394 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960000680 214 Hayes Bilingual School   Regular School No 1.0 PK 08 2015   kindergarten_3_year_old                                                   33                                             33
119407 119407 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001187 217 Hi-Mount Elementary   Regular School No 1.0 PK 08 2015   kindergarten_3_year_old                                                   3                                             3
119431 119431 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001188 218 Holmes Elementary   Regular School No 1.0 PK 08 2015   kindergarten_3_year_old                                                   4                                             4
119452 119452 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001208 253 Hopkins Lloyd   Regular School No 1.0 PK 08 2015   kindergarten_3_year_old                                                   3                                             3
119457 119457 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002911 112 Howard Avenue Montessori School   Regular School No 1.0 PK 01 2015   kindergarten_3_year_old                                                   40                                             40
119469 119469 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001190 223 Humboldt Park Elementary   Regular School No 1.0 PK 08 2015   kindergarten_3_year_old                                                   8                                             8
119489 119489 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001261 377 Jackson Elementary   Regular School No 1.0 PK 05 2015   kindergarten_3_year_old                                                   34                                             34
119504 119504 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001195 232 Kagel Elementary   Regular School No 1.0 PK 05 2015   kindergarten_3_year_old                                                   30                                             30
119517 119517 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001196 235 Keefe Avenue Elementary   Regular School No 1.0 PK 08 2015   kindergarten_3_year_old                                                   24                                             24
119527 119527 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001197 237 Kilbourn Elementary   Regular School No 1.0 PK 05 2015   kindergarten_3_year_old                                                   47                                             47
119549 119549 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001178 199 King Jr Elementary   Regular School No 1.0 PK 08 2015   kindergarten_3_year_old                                                   24                                             24
119558 119558 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001200 337 Kluge Elementary   Regular School No 1.0 PK 05 2015   kindergarten_3_year_old                                                   12                                             12
119592 119592 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001202 238 LaFollette Elementary   Regular School No 1.0 PK 08 2015   kindergarten_3_year_old                                                   2                                             2
119604 119604 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001204 241 Lancaster Elementary   Regular School No 1.0 PK 08 2015   kindergarten_3_year_old                                                   2                                             2
119613 119613 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001206 250 Lincoln Avenue Elementary   Regular School No 1.0 PK 05 2015   kindergarten_3_year_old                                                   60                                             60
119630 119630 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001209 256 Longfellow Elementary   Regular School No 1.0 PK 08 2015   kindergarten_3_year_old                                                   16                                             16
119640 119640 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001210 257 Lowell Elementary   Regular School No 1.0 PK 05 2015   kindergarten_3_year_old                                                   6                                             6
119656 119656 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002931 870 MacDowell Montessori School K3-12   Regular School No 4.0 PK 12 2015   kindergarten_3_year_old                                                   85                                             85
119668 119668 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001213 265 Manitoba Elementary   Regular School No 1.0 PK 08 2015   kindergarten_3_year_old                                                   2                                             2
119677 119677 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001214 267 Maple Tree Elementary   Regular School No 1.0 PK 05 2015   kindergarten_3_year_old                                                   58                                             58

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