enrollments

Data source: Big Local News · About: Big Local

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

✎ 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
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
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
289437 289437 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002911 112 Howard Avenue Montessori School   Regular School No 1.0 PK 02 2016   kindergarten_3_year_old                                                   42                                             42
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
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
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
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
333308 333308 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002911 112 Howard Avenue Montessori School   Regular School No Elementary PK 03 2017   kindergarten_3_year_old                                                   43                                             43
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
3095839 3095839 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002911 112 Bay View Montessori School   Regular School No Elementary PK 04 2018   kindergarten_3_year_old                                                   40                                             40
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
119771 119771 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002340 140 Milwaukee French Immersion   Regular School No 1.0 PK 05 2015   kindergarten_3_year_old                                                   2                                             2
119780 119780 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001155 146 Milwaukee German Immersion   Regular School No 1.0 PK 05 2015   kindergarten_3_year_old                                                   6                                             6
119826 119826 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001161 167 Milwaukee Spanish Immersion   Regular School No 1.0 PK 05 2015   kindergarten_3_year_old                                                   18                                             18
119867 119867 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001224 283 Neeskara Elementary   Regular School No 1.0 PK 05 2015   kindergarten_3_year_old                                                   11                                             11
119882 119882 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001225 289 Ninety-Fifth Street Elementary   Regular School No 1.0 PK 05 2015   kindergarten_3_year_old                                                   1                                             1
119924 119924 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001231 301 Parkview Elementary   Regular School No 1.0 PK 05 2015   kindergarten_3_year_old                                                   4                                             4
119933 119933 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001233 307 Pierce Elementary   Regular School No 1.0 PK 05 2015   kindergarten_3_year_old                                                   29                                             29
119961 119961 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001236 313 Riley Elementary   Regular School No 1.0 PK 05 2015   kindergarten_3_year_old                                                   14                                             14
120022 120022 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002744 107 Siefert Elementary   Regular School No 1.0 PK 05 2015   kindergarten_3_year_old                                                   45                                             45
120032 120032 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001243 325 Silver Spring Elementary   Regular School No 1.0 PK 05 2015   kindergarten_3_year_old                                                   31                                             31
120083 120083 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001250 344 Stuart Elementary   Regular School No 1.0 PK 05 2015   kindergarten_3_year_old                                                   4                                             4
120243 120243 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002342 295 Zablocki Elementary   Regular School No 1.0 PK 05 2015   kindergarten_3_year_old                                                   15                                             15
288788 288788 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001239 316 Academy of Accelerated Learning   Regular School No 1.0 PK 05 2016   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
288817 288817 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001122 73 Allen-Field Elementary   Regular School No 1.0 PK 05 2016   kindergarten_3_year_old                                                   13                                             13
288903 288903 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002395 89 Brown Street Academy   Regular School No 1.0 PK 05 2016   kindergarten_3_year_old                                                   4                                             4
288912 288912 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001132 92 Browning Elementary   Regular School No 1.0 PK 05 2016   kindergarten_3_year_old                                                   5                                             5
288921 288921 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001133 93 Bruce Elementary   Regular School No 1.0 PK 05 2016   kindergarten_3_year_old                                                   1                                             1
288930 288930 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001134 94 Bryant Elementary   Regular School No 1.0 PK 05 2016   kindergarten_3_year_old                                                   4                                             4
289032 289032 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001141 114 Clemens Elementary   Regular School No 1.0 PK 05 2016   kindergarten_3_year_old                                                   1                                             1
289151 289151 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001157 150 Emerson Elementary   Regular School No 1.0 PK 05 2016   kindergarten_3_year_old                                                   5                                             5
289160 289160 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001158 152 Engleburg Elementary   Regular School No 1.0 PK 05 2016   kindergarten_3_year_old                                                   4                                             4
289205 289205 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001163 173 Forest Home Elementary   Regular School No 1.0 PK 05 2016   kindergarten_3_year_old                                                   67                                             67
289226 289226 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001166 182 Fratney Elementary   Regular School No 1.0 PK 05 2016   kindergarten_3_year_old                                                   2                                             2
289259 289259 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001173 192 Goodrich Elementary   Regular School No 1.0 PK 05 2016   kindergarten_3_year_old                                                   4                                             4
289362 289362 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001185 212 Hawthorne Elementary   Regular School No 1.0 PK 05 2016   kindergarten_3_year_old                                                   30                                             30
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
289469 289469 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001261 377 Jackson Elementary   Regular School No 1.0 PK 05 2016   kindergarten_3_year_old                                                   43                                             43
289483 289483 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001195 232 Kagel Elementary   Regular School No 1.0 PK 05 2016   kindergarten_3_year_old                                                   23                                             23
289505 289505 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001197 237 Kilbourn Elementary   Regular School No 1.0 PK 05 2016   kindergarten_3_year_old                                                   39                                             39
289535 289535 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001200 337 Kluge Elementary   Regular School No 1.0 PK 05 2016   kindergarten_3_year_old                                                   22                                             22
289584 289584 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001206 250 Lincoln Avenue Elementary   Regular School No 1.0 PK 05 2016   kindergarten_3_year_old                                                   60                                             60
289609 289609 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001210 257 Lowell Elementary   Regular School No 1.0 PK 05 2016   kindergarten_3_year_old                                                   6                                             6
289646 289646 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001214 267 Maple Tree Elementary   Regular School No 1.0 PK 05 2016   kindergarten_3_year_old                                                   57                                             57
289742 289742 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002340 140 Milwaukee French Immersion   Regular School No 1.0 PK 05 2016   kindergarten_3_year_old                                                   3                                             3
289796 289796 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001161 167 Milwaukee Spanish Immersion   Regular School No 1.0 PK 05 2016   kindergarten_3_year_old                                                   11                                             11
289837 289837 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001224 283 Neeskara Elementary   Regular School No 1.0 PK 05 2016   kindergarten_3_year_old                                                   6                                             6
289853 289853 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001225 289 Ninety-Fifth Street Elementary   Regular School No 1.0 PK 05 2016   kindergarten_3_year_old                                                   1                                             1
289893 289893 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001231 301 Parkview Elementary   Regular School No 1.0 PK 05 2016   kindergarten_3_year_old                                                   2                                             2
289902 289902 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001233 307 Pierce Elementary   Regular School No 1.0 PK 05 2016   kindergarten_3_year_old                                                   31                                             31
289926 289926 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001236 313 Riley Elementary   Regular School No 1.0 PK 05 2016   kindergarten_3_year_old                                                   5                                             5
289985 289985 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002744 107 Siefert Elementary   Regular School No 1.0 PK 05 2016   kindergarten_3_year_old                                                   45                                             45
289994 289994 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001243 325 Silver Spring Elementary   Regular School No 1.0 PK 05 2016   kindergarten_3_year_old                                                   37                                             37
290040 290040 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001250 344 Stuart Elementary   Regular School No 1.0 PK 05 2016   kindergarten_3_year_old                                                   1                                             1
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
290200 290200 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002342 295 Zablocki Elementary   Regular School No 1.0 PK 05 2016   kindergarten_3_year_old                                                   16                                             16
332658 332658 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001239 316 Academy of Accelerated Learning   Regular School No Elementary PK 05 2017   kindergarten_3_year_old                                                   5                                             5
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
332688 332688 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001122 73 Allen-Field Elementary   Regular School No Elementary PK 05 2017   kindergarten_3_year_old                                                   11                                             11
332776 332776 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002395 89 Brown Street Academy   Regular School No Elementary PK 05 2017   kindergarten_3_year_old                                                   1                                             1
332785 332785 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001132 92 Browning Elementary   Regular School No Elementary PK 05 2017   kindergarten_3_year_old                                                   3                                             3
332794 332794 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001133 93 Bruce Elementary   Regular School No Elementary PK 05 2017   kindergarten_3_year_old                                                   1                                             1
333014 333014 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002438 148 Elm Creative Arts Elementary   Regular School No Elementary PK 05 2017   kindergarten_3_year_old                                                   1                                             1
333023 333023 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001157 150 Emerson Elementary   Regular School No Elementary PK 05 2017   kindergarten_3_year_old                                                   3                                             3
333032 333032 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001158 152 Engleburg Elementary   Regular School No Elementary PK 05 2017   kindergarten_3_year_old                                                   1                                             1
333077 333077 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001163 173 Forest Home Elementary   Regular School No Elementary PK 05 2017   kindergarten_3_year_old                                                   62                                             62
333098 333098 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001166 182 Fratney Elementary   Regular School No Elementary PK 05 2017   kindergarten_3_year_old                                                   4                                             4
333131 333131 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001173 192 Goodrich Elementary   Regular School No Elementary PK 05 2017   kindergarten_3_year_old                                                   4                                             4
333224 333224 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001184 211 Hawley Environmental School   Regular School No Elementary PK 05 2017   kindergarten_3_year_old                                                   3                                             3
333233 333233 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001185 212 Hawthorne Elementary   Regular School No Elementary PK 05 2017   kindergarten_3_year_old                                                   31                                             31
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
333340 333340 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001261 377 Jackson Elementary   Regular School No Elementary PK 05 2017   kindergarten_3_year_old                                                   28                                             28
333354 333354 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001195 232 Kagel Elementary   Regular School No Elementary PK 05 2017   kindergarten_3_year_old                                                   21                                             21
333375 333375 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001197 237 Kilbourn Elementary   Regular School No Elementary PK 05 2017   kindergarten_3_year_old                                                   32                                             32
333405 333405 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001200 337 Kluge Elementary   Regular School No Elementary PK 05 2017   kindergarten_3_year_old                                                   6                                             6
333454 333454 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001206 250 Lincoln Avenue Elementary   Regular School No Elementary PK 05 2017   kindergarten_3_year_old                                                   51                                             51

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