enrollments

Data source: Big Local News · About: Big Local

3,996 rows where grade = "pre_kindergarten" and state = "WI" sorted by school_nces_id

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • pre_kindergarten · 3,996 ✖
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
117337 117337 WI Waukesha   school 5500013 3862 Public school Lake Country 550001300578 30 Lake Country School   Regular School No 1.0 PK 08 2015   pre_kindergarten                                                   2                                             2
287329 287329 WI Waukesha   school 5500013 3862 Public school Lake Country 550001300578 30 Lake Country School   Regular School No 1.0 PK 08 2016   pre_kindergarten                                                   1                                             1
331203 331203 WI Waukesha   school 5500013 3862 Public school Lake Country 550001300578 30 Lake Country School   Regular School No Elementary PK 08 2017   pre_kindergarten                                                   1                                             1
2323779 2323779 WI Waukesha   school 5500013 3862 Public school Lake Country 550001300578 30 Lake Country School   Regular School No Elementary PK 08 2020   pre_kindergarten                                                   6                                             6
2338659 2338659 WI Waukesha   school 5500013 3862 Public school Lake Country 550001300578 30 Lake Country School   Regular School No Elementary PK 08 2021   pre_kindergarten                                                   1                                             1
3079526 3079526 WI Waukesha   school 5500013 3862 Public school Lake Country 550001300578 30 Lake Country School   Regular School No Elementary PK 08 2019   pre_kindergarten                                                   4                                             4
3094272 3094272 WI Waukesha   school 5500013 3862 Public school Lake Country 550001300578 30 Lake Country School   Regular School No Elementary PK 08 2018   pre_kindergarten                                                   4                                             4
112928 112928 WI Trempealeau   school 5500016 485 Public school Blair-Taylor 550001602380 34 Blair-Taylor Elementary   Regular School No 1.0 PK 06 2015   pre_kindergarten                                                   5                                             5
282909 282909 WI Trempealeau   school 5500016 485 Public school Blair-Taylor 550001602380 34 Blair-Taylor Elementary   Regular School No 1.0 PK 06 2016   pre_kindergarten                                                   3                                             3
326809 326809 WI Trempealeau   school 5500016 485 Public school Blair-Taylor 550001602380 34 Blair-Taylor Elementary   Regular School No Elementary PK 06 2017   pre_kindergarten                                                   4                                             4
2319307 2319307 WI Trempealeau   school 5500016 485 Public school Blair-Taylor 550001602380 34 Blair-Taylor Elementary   Regular School No Elementary PK 06 2020   pre_kindergarten                                                   8                                             8
2334091 2334091 WI Trempealeau   school 5500016 485 Public school Blair-Taylor 550001602380 34 Blair-Taylor Elementary   Regular School No Elementary PK 06 2021   pre_kindergarten                                                   7                                             7
3075094 3075094 WI Trempealeau   school 5500016 485 Public school Blair-Taylor 550001602380 34 Blair-Taylor Elementary   Regular School No Elementary PK 06 2019   pre_kindergarten                                                   5                                             5
3089854 3089854 WI Trempealeau   school 5500016 485 Public school Blair-Taylor 550001602380 34 Blair-Taylor Elementary   Regular School No Elementary PK 06 2018   pre_kindergarten                                                   5                                             5
122960 122960 WI Grant   school 5500017 4904 Public school River Ridge 550001700684 20 River Ridge Elementary   Regular School No 1.0 PK 04 2015   pre_kindergarten                                                   3                                             3
292922 292922 WI Grant   school 5500017 4904 Public school River Ridge 550001700684 20 River Ridge Elementary   Regular School No 1.0 PK 04 2016   pre_kindergarten                                                   2                                             2
336810 336810 WI Grant   school 5500017 4904 Public school River Ridge 550001700684 20 River Ridge Elementary   Regular School No Elementary PK 04 2017   pre_kindergarten                                                   5                                             5
2329424 2329424 WI Grant   school 5500017 4904 Public school River Ridge 550001700684 20 River Ridge Elementary   Regular School No Elementary PK 04 2020   pre_kindergarten                                                   5                                             5
2344321 2344321 WI Grant   school 5500017 4904 Public school River Ridge 550001700684 20 River Ridge Elementary   Regular School No Elementary PK 04 2021   pre_kindergarten                                                   1                                             1
3085143 3085143 WI Grant   school 5500017 4904 Public school River Ridge 550001700684 20 River Ridge Elementary   Regular School No Elementary PK 04 2019   pre_kindergarten                                                   2                                             2
3099879 3099879 WI Grant   school 5500017 4904 Public school River Ridge 550001700684 20 River Ridge Elementary   Regular School No Elementary PK 04 2018   pre_kindergarten                                                   1                                             1
281722 281722 WI Clark   school 5500030 7 Public school Abbotsford 550003000001 20 Abbotsford Elementary   Regular School No 1.0 PK 05 2016   pre_kindergarten                                                   1                                             1
325616 325616 WI Clark   school 5500030 7 Public school Abbotsford 550003000001 20 Abbotsford Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten                                                   3                                             3
2318139 2318139 WI Clark   school 5500030 7 Public school Abbotsford 550003000001 20 Abbotsford Elementary   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   1                                             1
2332945 2332945 WI Clark   school 5500030 7 Public school Abbotsford 550003000001 20 Abbotsford Elementary   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   3                                             3
3073907 3073907 WI Clark   school 5500030 7 Public school Abbotsford 550003000001 20 Abbotsford Elementary   Regular School No Elementary PK 05 2019   pre_kindergarten                                                   2                                             2
3088656 3088656 WI Clark   school 5500030 7 Public school Abbotsford 550003000001 20 Abbotsford Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten                                                   2                                             2
337076 337076 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   pre_kindergarten                                                   7                                             7
124547 124547 WI Kenosha   school 5500052 5780 Public school Trevor-Wilmot Consolidated 550005202644 20 Trevor-Wilmot Grade   Regular School No 1.0 PK 08 2015   pre_kindergarten                                                   1                                             1
294478 294478 WI Kenosha   school 5500052 5780 Public school Trevor-Wilmot Consolidated 550005202644 20 Trevor-Wilmot Grade   Regular School No 1.0 PK 08 2016   pre_kindergarten                                                   2                                             2
338376 338376 WI Kenosha   school 5500052 5780 Public school Trevor-Wilmot Consolidated 550005202644 20 Trevor-Wilmot Grade   Regular School No Elementary PK 08 2017   pre_kindergarten                                                   8                                             8
2331051 2331051 WI Kenosha   school 5500052 5780 Public school Trevor-Wilmot Consolidated 550005202644 20 Trevor-Wilmot Grade   Regular School No Elementary PK 08 2020   pre_kindergarten                                                   3                                             3
2345968 2345968 WI Kenosha   school 5500052 5780 Public school Trevor-Wilmot Consolidated 550005202644 20 Trevor-Wilmot Grade   Regular School No Elementary PK 08 2021   pre_kindergarten                                                   4                                             4
3086747 3086747 WI Kenosha   school 5500052 5780 Public school Trevor-Wilmot Consolidated 550005202644 20 Trevor-Wilmot Grade   Regular School No Elementary PK 08 2019   pre_kindergarten                                                   2                                             2
3101451 3101451 WI Kenosha   school 5500052 5780 Public school Trevor-Wilmot Consolidated 550005202644 20 Trevor-Wilmot Grade   Regular School No Elementary PK 08 2018   pre_kindergarten                                                   1                                             1
115785 115785 WI Shawano   school 5500056 2415 Public school Gresham 550005602748 100 Gresham Elementary   Regular School No 1.0 PK 05 2015   pre_kindergarten                                                   2                                             2
285788 285788 WI Shawano   school 5500056 2415 Public school Gresham 550005602748 100 Gresham Elementary   Regular School No 1.0 PK 05 2016   pre_kindergarten                                                   2                                             2
329667 329667 WI Shawano   school 5500056 2415 Public school Gresham 550005602748 100 Gresham Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten                                                   2                                             2
2322215 2322215 WI Shawano   school 5500056 2415 Public school Gresham 550005602748 100 Gresham Elementary   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   2                                             2
2337055 2337055 WI Shawano   school 5500056 2415 Public school Gresham 550005602748 100 Gresham Elementary   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   2                                             2
3092740 3092740 WI Shawano   school 5500056 2415 Public school Gresham 550005602748 100 Gresham Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten                                                   3                                             3
327330 327330 WI Price   school 5500058 1071 Public school Chequamegon 550005801523 110 Park Falls Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten                                                   4                                             4
2334643 2334643 WI Price   school 5500058 1071 Public school Chequamegon 550005801523 110 Park Falls Elementary   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   2                                             2
3075637 3075637 WI Price   school 5500058 1071 Public school Chequamegon 550005801523 110 Park Falls Elementary   Regular School No Elementary PK 05 2019   pre_kindergarten                                                   3                                             3
3090388 3090388 WI Price   school 5500058 1071 Public school Chequamegon 550005801523 110 Park Falls Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten                                                   2                                             2
325654 325654 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000010 140 Grand Marsh Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten                                                   2                                             2
111791 111791 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000012 200 Roche-A-Cri Elementary   Regular School No 1.0 PK 05 2015   pre_kindergarten                                                   1                                             1
325663 325663 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000012 200 Roche-A-Cri Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten                                                   1                                             1
111765 111765 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No 1.0 PK 05 2015   pre_kindergarten                                                   8                                             8
281739 281739 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No 1.0 PK 05 2016   pre_kindergarten                                                   1                                             1
325635 325635 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten                                                   12                                             12
2318159 2318159 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No Elementary PK 04 2020   pre_kindergarten                                                   13                                             13
2332962 2332962 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No Elementary PK 04 2021   pre_kindergarten                                                   7                                             7
3073928 3073928 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No Elementary PK 04 2019   pre_kindergarten                                                   10                                             10
3088677 3088677 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten                                                   14                                             14
113464 113464 WI Barron   school 5500061 1080 Public school Chetek-Weyerhaeuser Area 550006102805 100 Chetek-Weyerhaeuser Roselawn Elementary   Regular School No 1.0 PK 05 2015   pre_kindergarten                                                   6                                             6
283443 283443 WI Barron   school 5500061 1080 Public school Chetek-Weyerhaeuser Area 550006102805 100 Chetek-Weyerhaeuser Roselawn Elementary   Regular School No 1.0 PK 05 2016   pre_kindergarten                                                   3                                             3
327348 327348 WI Barron   school 5500061 1080 Public school Chetek-Weyerhaeuser Area 550006102805 100 Chetek-Weyerhaeuser Roselawn Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten                                                   5                                             5
2319879 2319879 WI Barron   school 5500061 1080 Public school Chetek-Weyerhaeuser Area 550006102805 100 Chetek-Weyerhaeuser Roselawn Elementary   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   7                                             7
2334665 2334665 WI Barron   school 5500061 1080 Public school Chetek-Weyerhaeuser Area 550006102805 100 Chetek-Weyerhaeuser Roselawn Elementary   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   3                                             3
3075655 3075655 WI Barron   school 5500061 1080 Public school Chetek-Weyerhaeuser Area 550006102805 100 Chetek-Weyerhaeuser Roselawn Elementary   Regular School No Elementary PK 05 2019   pre_kindergarten                                                   5                                             5
3090406 3090406 WI Barron   school 5500061 1080 Public school Chetek-Weyerhaeuser Area 550006102805 100 Chetek-Weyerhaeuser Roselawn Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten                                                   4                                             4
117121 117121 WI Milwaukee   school 5500062 8126 Non District Charter Schools King's Academy 550006202850 100 King's Academy charter Regular School Yes 1.0 PK 08 2015   pre_kindergarten                                                   20                                             20
287110 287110 WI Milwaukee   school 5500062 8126 Non District Charter Schools King's Academy 550006202850 100 King's Academy charter Regular School Yes 1.0 PK 08 2016   pre_kindergarten                                                   21                                             21
334126 334126 WI Milwaukee   school 5500067 8128 Non District Charter Schools Milwaukee Math and Science Academy 550006702898 800 Milwaukee Math and Science Academy charter Regular School Yes Elementary PK 08 2017   pre_kindergarten                                                   1                                             1
2341594 2341594 WI Milwaukee   school 5500067 8128 Non District Charter Schools Milwaukee Math and Science Academy 550006702898 800 Milwaukee Math and Science Academy charter Regular School Yes Elementary PK 08 2021   pre_kindergarten                                                   12                                             12
3097201 3097201 WI Milwaukee   school 5500067 8128 Non District Charter Schools Milwaukee Math and Science Academy 550006702898 800 Milwaukee Math and Science Academy charter Regular School Yes Elementary PK 08 2018   pre_kindergarten                                                   17                                             17
331004 331004 WI Waukesha   school 5500073 8135 Non District Charter Schools La Casa de Esperanza Charter School 550007303031 100 La Casa de Esperanza Charter School charter Regular School Yes Elementary PK 08 2017   pre_kindergarten                                                   47                                             47
2329685 2329685 WI Milwaukee   school 5500074 8001 Non District Charter Schools Seeds of Health Inc 550007402692 8121 Seeds of Health Elementary Program charter Regular School Yes Elementary PK 08 2020   pre_kindergarten                                                   34                                             34
2344585 2344585 WI Milwaukee   school 5500074 8001 Non District Charter Schools Seeds of Health Inc 550007402692 8121 Seeds of Health Elementary Program charter Regular School Yes Elementary PK 08 2021   pre_kindergarten                                                   22                                             22
329818 329818 WI Dodge   school 5500075 2525 Public school Herman-Neosho-Rubicon 550007503033 100 Honor Elementary   Regular School No Elementary PK 04 2017   pre_kindergarten                                                   4                                             4
2322364 2322364 WI Dodge   school 5500075 2525 Public school Herman-Neosho-Rubicon 550007503033 100 Honor Elementary   Regular School No Elementary PK 04 2020   pre_kindergarten                                                   2                                             2
2337191 2337191 WI Dodge   school 5500075 2525 Public school Herman-Neosho-Rubicon 550007503033 100 Honor Elementary   Regular School No Elementary PK 04 2021   pre_kindergarten                                                   4                                             4
3084079 3084079 WI Milwaukee   school 5500078 8138 Non District Charter Schools Penfield Montessori Academy 550007803048 8138 Penfield Montessori Academy charter Regular School Yes Elementary PK 08 2019   pre_kindergarten                                                   26                                             26
2322470 2322470 WI Washington   school 5500080 2570 Public school Holy Hill Area 550008003077 100 Friess Lake Elementary   Regular School No Elementary PK 04 2020   pre_kindergarten                                                   2                                             2
2337297 2337297 WI Washington   school 5500080 2570 Public school Holy Hill Area 550008003077 100 Friess Lake Elementary   Regular School No Elementary PK 04 2021   pre_kindergarten                                                   4                                             4
3078221 3078221 WI Washington   school 5500080 2570 Public school Holy Hill Area 550008003077 100 Friess Lake Elementary   Regular School No Elementary PK 04 2019   pre_kindergarten                                                   7                                             7
111804 111804 WI Green   school 5500120 63 Public school Albany 550012000013 20 Albany Elementary   Regular School No 1.0 PK 04 2015   pre_kindergarten                                                   2                                             2
325676 325676 WI Green   school 5500120 63 Public school Albany 550012000013 20 Albany Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten                                                   1                                             1
2332985 2332985 WI Green   school 5500120 63 Public school Albany 550012000013 20 Albany Elementary   Regular School No Elementary PK 04 2021   pre_kindergarten                                                   1                                             1
3088715 3088715 WI Green   school 5500120 63 Public school Albany 550012000013 20 Albany Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten                                                   3                                             3
111819 111819 WI Kewaunee   school 5500150 70 Public school Algoma 550015000015 20 Algoma Elementary   Regular School No 1.0 PK 06 2015   pre_kindergarten                                                   9                                             9
281791 281791 WI Kewaunee   school 5500150 70 Public school Algoma 550015000015 20 Algoma Elementary   Regular School No 1.0 PK 06 2016   pre_kindergarten                                                   7                                             7
325692 325692 WI Kewaunee   school 5500150 70 Public school Algoma 550015000015 20 Algoma Elementary   Regular School No Elementary PK 06 2017   pre_kindergarten                                                   6                                             6
2318202 2318202 WI Kewaunee   school 5500150 70 Public school Algoma 550015000015 20 Algoma Elementary   Regular School No Elementary PK 06 2020   pre_kindergarten                                                   4                                             4
2333000 2333000 WI Kewaunee   school 5500150 70 Public school Algoma 550015000015 20 Algoma Elementary   Regular School No Elementary PK 06 2021   pre_kindergarten                                                   2                                             2
3073972 3073972 WI Kewaunee   school 5500150 70 Public school Algoma 550015000015 20 Algoma Elementary   Regular School No Elementary PK 06 2019   pre_kindergarten                                                   7                                             7
3088730 3088730 WI Kewaunee   school 5500150 70 Public school Algoma 550015000015 20 Algoma Elementary   Regular School No Elementary PK 06 2018   pre_kindergarten                                                   5                                             5
2318221 2318221 WI Buffalo   school 5500180 84 Public school Alma 550018000017 20 Alma Elementary   Regular School No Elementary PK 08 2020   pre_kindergarten                                                   1                                             1
3088749 3088749 WI Buffalo   school 5500180 84 Public school Alma 550018000017 20 Alma Elementary   Regular School No Elementary PK 08 2018   pre_kindergarten                                                   1                                             1
111852 111852 WI Jackson   school 5500210 91 Public school Alma Center 550021000022 80 Lincoln Elementary   Regular School No 1.0 PK 06 2015   pre_kindergarten                                                   1                                             1
281824 281824 WI Jackson   school 5500210 91 Public school Alma Center 550021000022 80 Lincoln Elementary   Regular School No 1.0 PK 06 2016   pre_kindergarten                                                   3                                             3
325725 325725 WI Jackson   school 5500210 91 Public school Alma Center 550021000022 80 Lincoln Elementary   Regular School No Elementary PK 06 2017   pre_kindergarten                                                   2                                             2
2318236 2318236 WI Jackson   school 5500210 91 Public school Alma Center 550021000022 80 Lincoln Elementary   Regular School No Elementary PK 06 2020   pre_kindergarten                                                   3                                             3
2333033 2333033 WI Jackson   school 5500210 91 Public school Alma Center 550021000022 80 Lincoln Elementary   Regular School No Elementary PK 06 2021   pre_kindergarten                                                   1                                             1
3074005 3074005 WI Jackson   school 5500210 91 Public school Alma Center 550021000022 80 Lincoln Elementary   Regular School No Elementary PK 06 2019   pre_kindergarten                                                   2                                             2
3088764 3088764 WI Jackson   school 5500210 91 Public school Alma Center 550021000022 80 Lincoln Elementary   Regular School No Elementary PK 06 2018   pre_kindergarten                                                   3                                             3
2318253 2318253 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000023 20 Almond-Bancroft Elementary   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   1                                             1
2333049 2333049 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000023 20 Almond-Bancroft Elementary   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   1                                             1
3074022 3074022 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000023 20 Almond-Bancroft Elementary   Regular School No Elementary PK 05 2019   pre_kindergarten                                                   3                                             3

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