enrollments

Data source: Big Local News · About: Big Local

4,744 rows where grade = "grade_8" and state = "WI" sorted by district_nces_id

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_8 · 4,644 ✖
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
3073938 3073938 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001454 210 Adams-Friendship Middle   Regular School No Middle 05 08 2019   grade_8                                                   111                                             111
3088686 3088686 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001454 210 Adams-Friendship Middle   Regular School No Middle 06 08 2018   grade_8                                                   123                                             123
113455 113455 WI Barron   school 5500061 1080 Public school Chetek-Weyerhaeuser Area 550006102806 200 Chetek-Weyerhaeuser Middle   Regular School No 2.0 06 08 2015   grade_8                                                   63                                             63
113476 113476 WI Barron   school 5500061 1080 Public school Chetek-Weyerhaeuser Area 550006102897 800 Link2Learn Virtual Charter School charter Regular School Yes 4.0 PK 12 2015   grade_8                                                   7                                             7
283434 283434 WI Barron   school 5500061 1080 Public school Chetek-Weyerhaeuser Area 550006102806 200 Chetek-Weyerhaeuser Middle   Regular School No 2.0 06 08 2016   grade_8                                                   50                                             50
283454 283454 WI Barron   school 5500061 1080 Public school Chetek-Weyerhaeuser Area 550006102897 800 Link2Learn Virtual Charter School charter Regular School Yes 4.0 PK 12 2016   grade_8                                                   7                                             7
327339 327339 WI Barron   school 5500061 1080 Public school Chetek-Weyerhaeuser Area 550006102806 200 Chetek-Weyerhaeuser Middle   Regular School No Middle 06 08 2017   grade_8                                                   75                                             75
327360 327360 WI Barron   school 5500061 1080 Public school Chetek-Weyerhaeuser Area 550006102897 800 Link2Learn Virtual Charter School charter Regular School Yes Other PK 12 2017   grade_8                                                   3                                             3
2319870 2319870 WI Barron   school 5500061 1080 Public school Chetek-Weyerhaeuser Area 550006102806 200 Chetek-Weyerhaeuser Middle   Regular School No Middle 06 08 2020   grade_8                                                   68                                             68
2319891 2319891 WI Barron   school 5500061 1080 Public school Chetek-Weyerhaeuser Area 550006102897 800 Link2Learn Virtual Charter School charter Regular School Yes Other PK 12 2020   grade_8                                                   4                                             4
2334656 2334656 WI Barron   school 5500061 1080 Public school Chetek-Weyerhaeuser Area 550006102806 200 Chetek-Weyerhaeuser Middle   Regular School No Middle 06 08 2021   grade_8                                                   71                                             71
2334677 2334677 WI Barron   school 5500061 1080 Public school Chetek-Weyerhaeuser Area 550006102897 800 Link2Learn Virtual Charter School charter Regular School Yes Other PK 12 2021   grade_8                                                   4                                             4
3075646 3075646 WI Barron   school 5500061 1080 Public school Chetek-Weyerhaeuser Area 550006102806 200 Chetek-Weyerhaeuser Middle   Regular School No Middle 06 08 2019   grade_8                                                   65                                             65
3075667 3075667 WI Barron   school 5500061 1080 Public school Chetek-Weyerhaeuser Area 550006102897 800 Link2Learn Virtual Charter School charter Regular School Yes Other PK 12 2019   grade_8                                                   2                                             2
3090397 3090397 WI Barron   school 5500061 1080 Public school Chetek-Weyerhaeuser Area 550006102806 200 Chetek-Weyerhaeuser Middle   Regular School No Middle 06 08 2018   grade_8                                                   60                                             60
3090418 3090418 WI Barron   school 5500061 1080 Public school Chetek-Weyerhaeuser Area 550006102897 800 Link2Learn Virtual Charter School charter Regular School Yes Other PK 12 2018   grade_8                                                   1                                             1
117119 117119 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   grade_8                                                   21                                             21
287108 287108 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   grade_8                                                   21                                             21
124667 124667 WI Milwaukee   school 5500063 8125 Non District Charter Schools Urban Day School 550006302832 100 Urban Day School charter Regular School Yes 1.0 PK 08 2015   grade_8                                                   24                                             24
294600 294600 WI Milwaukee   school 5500063 8125 Non District Charter Schools Urban Day School 550006302832 100 Urban Day School charter Regular School Yes 1.0 PK 08 2016   grade_8                                                   19                                             19
120307 120307 WI Milwaukee   school 5500065 8129 Non District Charter Schools Milwaukee Scholars Charter School 550006502894 100 Milwaukee Scholars Charter School charter Regular School Yes 1.0 PK 08 2015   grade_8                                                   46                                             46
290264 290264 WI Milwaukee   school 5500065 8129 Non District Charter Schools Milwaukee Scholars Charter School 550006502894 100 Milwaukee Scholars Charter School charter Regular School Yes 1.0 PK 08 2016   grade_8                                                   35                                             35
334135 334135 WI Milwaukee   school 5500065 8129 Non District Charter Schools Milwaukee Scholars Charter School 550006502894 100 Milwaukee Scholars Charter School charter Regular School Yes Elementary PK 08 2017   grade_8                                                   51                                             51
2326734 2326734 WI Milwaukee   school 5500065 8129 Non District Charter Schools Milwaukee Scholars Charter School 550006502894 100 Milwaukee Scholars Charter School charter Regular School Yes Elementary PK 08 2020   grade_8                                                   55                                             55
2341603 2341603 WI Milwaukee   school 5500065 8129 Non District Charter Schools Milwaukee Scholars Charter School 550006502894 100 Milwaukee Scholars Charter School charter Regular School Yes Elementary PK 08 2021   grade_8                                                   56                                             56
3082504 3082504 WI Milwaukee   school 5500065 8129 Non District Charter Schools Milwaukee Scholars Charter School 550006502894 100 Milwaukee Scholars Charter School charter Regular School Yes Elementary PK 08 2019   grade_8                                                   59                                             59
3097210 3097210 WI Milwaukee   school 5500065 8129 Non District Charter Schools Milwaukee Scholars Charter School 550006502894 100 Milwaukee Scholars Charter School charter Regular School Yes Elementary PK 08 2018   grade_8                                                   55                                             55
120296 120296 WI Milwaukee   school 5500067 8128 Non District Charter Schools Milwaukee Math and Science Academy 550006702898 800 Milwaukee Math and Science Academy charter Regular School Yes 1.0 PK 08 2015   grade_8                                                   18                                             18
290253 290253 WI Milwaukee   school 5500067 8128 Non District Charter Schools Milwaukee Math and Science Academy 550006702898 800 Milwaukee Math and Science Academy charter Regular School Yes 1.0 PK 08 2016   grade_8                                                   24                                             24
334123 334123 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   grade_8                                                   34                                             34
2326723 2326723 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 2020   grade_8                                                   19                                             19
2341592 2341592 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   grade_8                                                   25                                             25
3082493 3082493 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 2019   grade_8                                                   21                                             21
3097199 3097199 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   grade_8                                                   28                                             28
114672 114672 WI Milwaukee   school 5500069 8131 Non District Charter Schools Escuela Verde 550006902920 400 Escuela Verde charter Regular School Yes 3.0 07 12 2015   grade_8                                                   6                                             6
284669 284669 WI Milwaukee   school 5500069 8131 Non District Charter Schools Escuela Verde 550006902920 400 Escuela Verde charter Regular School Yes 3.0 07 12 2016   grade_8                                                   3                                             3
328558 328558 WI Milwaukee   school 5500069 8131 Non District Charter Schools Escuela Verde 550006902920 400 Escuela Verde charter Regular School Yes High 07 12 2017   grade_8                                                   10                                             10
3091624 3091624 WI Milwaukee   school 5500069 8131 Non District Charter Schools Escuela Verde 550006902920 400 Escuela Verde charter Regular School Yes High 07 12 2018   grade_8                                                   3                                             3
2332881 2332881 WI Milwaukee   school 5500070 8132 Non District Charter Schools Woodlands School - State Street Campus 550007002942 100 Woodlands School - State Street Campus charter Regular School Yes Elementary PK 08 2020   grade_8                                                   24                                             24
2347888 2347888 WI Milwaukee   school 5500070 8132 Non District Charter Schools Woodlands School - State Street Campus 550007002942 100 Woodlands School - State Street Campus charter Regular School Yes Elementary PK 08 2021   grade_8                                                   35                                             35
120280 120280 WI Milwaukee   school 5500072 8134 Non District Charter Schools Milwaukee College Preparatory School: 550007203006 100 Milwaukee College Preparatory School: Lola Rowe North Campus charter Regular School Yes 1.0 PK 08 2015   grade_8                                                   37                                             37
290237 290237 WI Milwaukee   school 5500072 8134 Non District Charter Schools Milwaukee College Preparatory School: 550007203006 100 Milwaukee College Preparatory School: Lola Rowe North Campus charter Regular School Yes 1.0 PK 08 2016   grade_8                                                   39                                             39
337085 337085 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 2017   grade_8                                                   42                                             42
2329683 2329683 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   grade_8                                                   50                                             50
2344583 2344583 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   grade_8                                                   55                                             55
3085412 3085412 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 2019   grade_8                                                   50                                             50
3100144 3100144 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 2018   grade_8                                                   45                                             45
329823 329823 WI Dodge   school 5500075 2525 Public school Herman-Neosho-Rubicon 550007503034 150 Honor Intermediate   Regular School No Middle 05 08 2017   grade_8                                                   34                                             34
2322369 2322369 WI Dodge   school 5500075 2525 Public school Herman-Neosho-Rubicon 550007503034 150 Honor Intermediate   Regular School No Middle 05 08 2020   grade_8                                                   39                                             39
2337196 2337196 WI Dodge   school 5500075 2525 Public school Herman-Neosho-Rubicon 550007503034 150 Honor Intermediate   Regular School No Middle 05 08 2021   grade_8                                                   33                                             33
3078121 3078121 WI Dodge   school 5500075 2525 Public school Herman-Neosho-Rubicon 550007503034 150 Honor Intermediate   Regular School No Middle 05 08 2019   grade_8                                                   20                                             20
3092895 3092895 WI Dodge   school 5500075 2525 Public school Herman-Neosho-Rubicon 550007503034 150 Honor Intermediate   Regular School No Middle 05 08 2018   grade_8                                                   34                                             34
2331165 2331165 WI Milwaukee   school 5500077 8137 Non District Charter Schools United Community Center Acosta Middle 550007703047 8137 United Community Center Acosta Middle School charter Regular School Yes Middle 06 08 2020   grade_8                                                   56                                             56
2346092 2346092 WI Milwaukee   school 5500077 8137 Non District Charter Schools United Community Center Acosta Middle 550007703047 8137 United Community Center Acosta Middle School charter Regular School Yes Middle 06 08 2021   grade_8                                                   58                                             58
3086864 3086864 WI Milwaukee   school 5500077 8137 Non District Charter Schools United Community Center Acosta Middle 550007703047 8137 United Community Center Acosta Middle School charter Regular School Yes Middle 06 08 2019   grade_8                                                   56                                             56
2322475 2322475 WI Washington   school 5500080 2570 Public school Holy Hill Area 550008003078 290 Richfield Middle   Regular School No Middle 05 08 2020   grade_8                                                   67                                             67
2337302 2337302 WI Washington   school 5500080 2570 Public school Holy Hill Area 550008003078 290 Richfield Middle   Regular School No Middle 05 08 2021   grade_8                                                   63                                             63
3078226 3078226 WI Washington   school 5500080 2570 Public school Holy Hill Area 550008003078 290 Richfield Middle   Regular School No Middle 05 08 2019   grade_8                                                   56                                             56
2322751 2322751 WI Dane   school 5500082 8141 Non District Charter Schools Isthmus Montessori Academy Public 550008203085 8141 Isthmus Montessori Academy Public charter Regular School Yes Other PK 12 2020   grade_8                                                   11                                             11
2337610 2337610 WI Dane   school 5500082 8141 Non District Charter Schools Isthmus Montessori Academy Public 550008203085 8141 Isthmus Montessori Academy Public charter Regular School Yes Other PK 11 2021   grade_8                                                   11                                             11
3078500 3078500 WI Dane   school 5500082 8141 Non District Charter Schools Isthmus Montessori Academy Public 550008203085 8141 Isthmus Montessori Academy Public charter Regular School Yes Other PK 12 2019   grade_8                                                   14                                             14
2340130 2340130 WI Dane   school 5500085 8145 Non District Charter Schools Milestone Democratic School 550008503136 8145 Milestone Democratic School charter Regular School Yes High 07 12 2021   grade_8                                                   7                                             7
126333 126333 WI Milwaukee   school 5500113 8113 Non District Charter Schools Woodlands School 550011303353 8728 Woodlands School charter Regular School Yes 1.0 PK 08 2015   grade_8                                                   32                                             32
296270 296270 WI Milwaukee   school 5500113 8113 Non District Charter Schools Woodlands School 550011303353 8728 Woodlands School charter Regular School Yes 1.0 PK 08 2016   grade_8                                                   34                                             34
340209 340209 WI Milwaukee   school 5500113 8113 Non District Charter Schools Woodlands School 550011303353 8728 Woodlands School charter Regular School Yes Elementary PK 08 2017   grade_8                                                   33                                             33
2332870 2332870 WI Milwaukee   school 5500113 8113 Non District Charter Schools Woodlands School 550011303353 8728 Woodlands School charter Regular School Yes Elementary PK 08 2020   grade_8                                                   37                                             37
2347877 2347877 WI Milwaukee   school 5500113 8113 Non District Charter Schools Woodlands School 550011303353 8728 Woodlands School charter Regular School Yes Elementary PK 08 2021   grade_8                                                   34                                             34
3088582 3088582 WI Milwaukee   school 5500113 8113 Non District Charter Schools Woodlands School 550011303353 8728 Woodlands School charter Regular School Yes Elementary PK 08 2019   grade_8                                                   35                                             35
3103286 3103286 WI Milwaukee   school 5500113 8113 Non District Charter Schools Woodlands School 550011303353 8728 Woodlands School charter Regular School Yes Elementary PK 08 2018   grade_8                                                   36                                             36
113319 113319 WI Milwaukee   school 5500114 8114 Non District Charter Schools Capitol West Academy 550011403355 100 Capitol West Academy charter Regular School Yes 1.0 PK 08 2015   grade_8                                                   18                                             18
283301 283301 WI Milwaukee   school 5500114 8114 Non District Charter Schools Capitol West Academy 550011403355 100 Capitol West Academy charter Regular School Yes 1.0 PK 08 2016   grade_8                                                   21                                             21
327196 327196 WI Milwaukee   school 5500114 8114 Non District Charter Schools Capitol West Academy 550011403355 100 Capitol West Academy charter Regular School Yes Elementary PK 08 2017   grade_8                                                   17                                             17
2319725 2319725 WI Milwaukee   school 5500114 8114 Non District Charter Schools Capitol West Academy 550011403355 100 Capitol West Academy charter Regular School Yes Elementary PK 08 2020   grade_8                                                   28                                             28
3075503 3075503 WI Milwaukee   school 5500114 8114 Non District Charter Schools Capitol West Academy 550011403355 100 Capitol West Academy charter Regular School Yes Elementary PK 08 2019   grade_8                                                   38                                             38
3090253 3090253 WI Milwaukee   school 5500114 8114 Non District Charter Schools Capitol West Academy 550011403355 100 Capitol West Academy charter Regular School Yes Elementary PK 08 2018   grade_8                                                   22                                             22
111796 111796 WI Green   school 5500120 63 Public school Albany 550012002357 60 Albany Community Middle charter Regular School Yes 2.0 05 08 2015   grade_8                                                   27                                             27
281769 281769 WI Green   school 5500120 63 Public school Albany 550012002357 60 Albany Community Middle charter Regular School Yes 2.0 05 08 2016   grade_8                                                   18                                             18
325667 325667 WI Green   school 5500120 63 Public school Albany 550012002357 60 Albany Community Middle charter Regular School Yes Middle 06 08 2017   grade_8                                                   22                                             22
2318180 2318180 WI Green   school 5500120 63 Public school Albany 550012002357 60 Albany Community Middle   Regular School No Middle 05 08 2020   grade_8                                                   27                                             27
2332977 2332977 WI Green   school 5500120 63 Public school Albany 550012002357 60 Albany Community Middle   Regular School No Middle 05 08 2021   grade_8                                                   21                                             21
3073949 3073949 WI Green   school 5500120 63 Public school Albany 550012002357 60 Albany Community Middle   Regular School No Middle 06 08 2019   grade_8                                                   22                                             22
3088706 3088706 WI Green   school 5500120 63 Public school Albany 550012002357 60 Albany Community Middle charter Regular School Yes Middle 06 08 2018   grade_8                                                   30                                             30
111825 111825 WI Kewaunee   school 5500150 70 Public school Algoma 550015000016 40 Algoma High   Regular School No 3.0 07 12 2015   grade_8                                                   50                                             50
281797 281797 WI Kewaunee   school 5500150 70 Public school Algoma 550015000016 40 Algoma High   Regular School No 3.0 07 12 2016   grade_8                                                   46                                             46
325698 325698 WI Kewaunee   school 5500150 70 Public school Algoma 550015000016 40 Algoma High   Regular School No High 07 12 2017   grade_8                                                   38                                             38
2318208 2318208 WI Kewaunee   school 5500150 70 Public school Algoma 550015000016 40 Algoma High   Regular School No High 07 12 2020   grade_8                                                   52                                             52
2333006 2333006 WI Kewaunee   school 5500150 70 Public school Algoma 550015000016 40 Algoma High   Regular School No High 07 12 2021   grade_8                                                   54                                             54
3073978 3073978 WI Kewaunee   school 5500150 70 Public school Algoma 550015000016 40 Algoma High   Regular School No High 07 12 2019   grade_8                                                   52                                             52
3088736 3088736 WI Kewaunee   school 5500150 70 Public school Algoma 550015000016 40 Algoma High   Regular School No High 07 12 2018   grade_8                                                   52                                             52
111835 111835 WI Buffalo   school 5500180 84 Public school Alma 550018000017 20 Alma Elementary   Regular School No 1.0 PK 08 2015   grade_8                                                   20                                             20
281807 281807 WI Buffalo   school 5500180 84 Public school Alma 550018000017 20 Alma Elementary   Regular School No 1.0 PK 08 2016   grade_8                                                   21                                             21
325708 325708 WI Buffalo   school 5500180 84 Public school Alma 550018000017 20 Alma Elementary   Regular School No Elementary PK 08 2017   grade_8                                                   17                                             17
2318218 2318218 WI Buffalo   school 5500180 84 Public school Alma 550018000017 20 Alma Elementary   Regular School No Elementary PK 08 2020   grade_8                                                   12                                             12
2333016 2333016 WI Buffalo   school 5500180 84 Public school Alma 550018000017 20 Alma Elementary   Regular School No Elementary PK 08 2021   grade_8                                                   18                                             18
3073988 3073988 WI Buffalo   school 5500180 84 Public school Alma 550018000017 20 Alma Elementary   Regular School No Elementary PK 08 2019   grade_8                                                   17                                             17
3088746 3088746 WI Buffalo   school 5500180 84 Public school Alma 550018000017 20 Alma Elementary   Regular School No Elementary PK 08 2018   grade_8                                                   22                                             22
111860 111860 WI Jackson   school 5500210 91 Public school Alma Center 550021000021 70 Lincoln Junior High   Regular School No 2.0 07 08 2015   grade_8                                                   45                                             45
281832 281832 WI Jackson   school 5500210 91 Public school Alma Center 550021000021 70 Lincoln Junior High   Regular School No 2.0 07 08 2016   grade_8                                                   43                                             43
325733 325733 WI Jackson   school 5500210 91 Public school Alma Center 550021000021 70 Lincoln Junior High   Regular School No Middle 07 08 2017   grade_8                                                   44                                             44
2318244 2318244 WI Jackson   school 5500210 91 Public school Alma Center 550021000021 70 Lincoln Junior High   Regular School No Middle 07 08 2020   grade_8                                                   46                                             46

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