enrollments

Data source: Big Local News · About: Big Local

3,528 rows where grade = "grade_8" and state = "IN" sorted by male

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_8 · 3,528 ✖
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
1164647 1164647 IN     school 1802880 4670   School City of East Chicago 180288000365 3937 Carrie Gosch Elementary School   Regular School No 1.0 PK 08 2015   grade_8                         0.0 1.0                       1.0                         0 1                 1
1170764 1170764 IN     school 1800006 9100   IN Department of Correction 180000601943 5452 Madison Juvenile Corr Fac   Regular School No 3.0 08 12 2015   grade_8                         0.0 2.0                       2.0                         0 2                 2
1171498 1171498 IN     school 1800139 9940   Tindley Collegiate Academy 180013902559 5914 Tindley Collegiate Academy   Regular School Yes 2.0 05 08 2015   grade_8                         0.0 97.0                       97.0                         0 97                 97
1284649 1284649 IN     school 1807440 3445   New Castle Community Sch Corp 180744001290 2825 New Castle High School   Regular School No 3.0 07 12 2016   grade_8                         0.0 1.0                       1.0                         0 1                 1
1284793 1284793 IN     school 1804470 3490   Western School Corp 180447002224 2923 Western Intermediate School   Regular School No 1.0 02 08 2016   grade_8                         0.0 1.0                       1.0                         0 1                 1
1286035 1286035 IN     school 1802880 4670   School City of East Chicago 180288000365 3937 Carrie Gosch Elementary School   Regular School No 1.0 PK 08 2016   grade_8                         0.0 1.0                       1.0                         0 1                 1
1286147 1286147 IN     school 1803870 4690   Gary Community School Corp 180387000620 4086 Frankie W McCullough Acad for Girl   Regular School No 1.0 KG 08 2016   grade_8                         0.0 34.0                       34.0                         0 34                 34
1290485 1290485 IN     school 1810140 7365   Shelbyville Central Schools 181014002496 7671 Especially Kidz Health & Rehab Cnt   Regular School No 4.0 02 12 2016   grade_8                         0.0 2.0                       2.0                         0 2                 2
1292146 1292146 IN     school 1800006 9100   IN Department of Correction 180000601943 5452 Madison Juvenile Corr Fac   Regular School No 3.0 08 12 2016   grade_8                         0.0 2.0                       2.0                         0 2                 2
1292873 1292873 IN     school 1800139 9940   Tindley Collegiate Academy 180013902559 5914 Tindley Collegiate Academy   Regular School Yes 2.0 05 08 2016   grade_8                         0.0 87.0                       87.0                         0 87                 87
1296827 1296827 IN     school 1804470 3490   Western School Corporation 180447002224 2923 Western Intermediate School   Regular School No Elementary 03 08 2017   grade_8                         0.0 1.0                       1.0                         0 1                 1
1298190 1298190 IN     school 1803870 4690   Gary Community School Corp 180387000620 4086 Frankie W McCullough Acad for Girl   Regular School No Elementary KG 08 2017   grade_8                         0.0 24.0                       24.0                         0 24                 24
1304169 1304169 IN     school 1800006 9100   Indiana Department of Corrections 180000601943 5452 Madison Juvenile Correctional   Regular School No High 08 12 2017   grade_8                         0.0 1.0                       1.0                         0 1                 1
1304901 1304901 IN     school 1800139 9940   Tindley Collegiate Academy 180013902559 5914 Tindley Collegiate Academy   Regular School Yes Middle 06 08 2017   grade_8                         0.0 83.0                       83.0                         0 83                 83
1755432 1755432 IN     school 1804470 3490   Western School Corporation 180447000756 2921 Western High School   Regular School No High 08 12 2019   grade_8                         0.0 1.0                       1.0                         0 1                 1
1762786 1762786 IN     school 1800006 9100   Indiana Department of Correction 180000601943 5452 Madison Juvenile Correctional   Regular School No High 08 12 2019   grade_8                         0.0 3.0                       3.0                         0 3                 3
1787462 1787462 IN     school 1808250 225   Northwest Allen County Schools 180825002160 145 Allen Co Youth Services Center   Alternative School No Secondary 08 11 2018   grade_8                         0.0 3.0                       3.0                         0 3                 3
1790910 1790910 IN     school 1802550 3325   Danville Community School Corp 180255000304 2741 Danville Community High School   Regular School No High 08 12 2018   grade_8                         0.0 1.0                       1.0                         0 1                 1
1791039 1791039 IN     school 1807440 3445   New Castle Community School Corp 180744001290 2825 New Castle High School   Regular School No High 07 12 2018   grade_8                         0.0 1.0                       1.0                         0 1                 1
1791185 1791185 IN     school 1804470 3490   Western School Corporation 180447002224 2923 Western Intermediate School   Regular School No Middle 03 08 2018   grade_8                         0.0 1.0                       1.0                         0 1                 1
1792470 1792470 IN     school 1802880 4670   School City of East Chicago 180288000368 3961 George Washington Elementary Sch   Regular School No Elementary KG 08 2018   grade_8                         0.0 2.0                       2.0                         0 2                 2
1792525 1792525 IN     school 1803870 4690   Gary Community School Corp 180387000620 4086 Frankie W McCullough Acad for Girl   Regular School No Elementary KG 08 2018   grade_8                         0.0 36.0                       36.0                         0 36                 36
1796825 1796825 IN     school 1810140 7365   Shelbyville Central Schools 181014002496 7671 Especially Kidz Health & Rehab Cnt   Regular School No Other 02 12 2018   grade_8                         0.0 2.0                       2.0                         0 2                 2
1799227 1799227 IN     school 1800139 9940   Tindley Collegiate Academy 180013902559 5914 Tindley Collegiate Academy   Regular School Yes Middle 06 08 2018   grade_8                         0.0 67.0                       67.0                         0 67                 67
1916420 1916420 IN     school 1810140 7365   Shelbyville Central Schools 181014002496 7671 Especially Kidz Health & Rehab Cnt   Regular School No Other 01 12 2020   grade_8                         0.0 2.0                       2.0                         0 2                 2
1918243 1918243 IN     school 1800006 9100   Indiana Department of Correction 180000601943 5452 LaPorte Juvenile Correctional   Regular School No High 08 12 2020   grade_8                         0.0 2.0                       2.0                         0 2                 2
1920987 1920987 IN     school 1802400 2270   Concord Community Schools 180240002484 1718 Concord Intermediate School   Regular School No Middle 04 08 2021   grade_8                         0.0 1.0                       1.0                         0 1                 1
1928205 1928205 IN     school 1810290 7205   South Bend Community School Corp 181029000898 7632 Juvenile Justice Center   Alternative School No High 08 12 2021   grade_8                         0.0 2.0                       2.0                         0 2                 2
1930197 1930197 IN     school 1800006 9100   Indiana Department of Correction 180000601943 5452 LaPorte Juvenile Correctional   Regular School No High 08 12 2021   grade_8                         0.0 4.0                       4.0                         0 4                 4
1159644 1159644 IN     school 1803630 235   Fort Wayne Community Schools 180363002174 100 Allen Co Juvenile Center   Regular School No 3.0 07 12 2015   grade_8                         1.0 0.0                       1.0                         1 0                 1
1168953 1168953 IN     school 1810290 7205   South Bend Community Sch Corp 181029000898 7632 Juvenile Justice Center   Alternative Education School No 3.0 07 12 2015   grade_8                         1.0 0.0                       1.0                         1 0                 1
1169101 1169101 IN     school 1810140 7365   Shelbyville Central Schools 181014002496 7671 Especially Kidz Health & Rehab Cnt   Regular School No 4.0 PK 12 2015   grade_8                         1.0 0.0                       1.0                         1 0                 1
1171336 1171336 IN     school 1800075 9830   Beacon Academy 180007502428 8411 Beacon Academy   Regular School Yes 3.0 08 12 2015   grade_8                         1.0 2.0                       3.0                         1 2                 3
1281030 1281030 IN     school 1808250 225   Northwest Allen County Schools 180825002160 145 Allen Co Youth Services Center   Alternative Education School No 4.0 01 10 2016   grade_8                         1.0 1.0                       2.0                         1 1                 2
1281036 1281036 IN     school 1803630 235   Fort Wayne Community Schools 180363002174 100 Allen Co Juvenile Center   Regular School No 3.0 08 12 2016   grade_8                         1.0 0.0                       1.0                         1 0                 1
1282154 1282154 IN     school 1800840 1125   Clay Community Schools 180084000159 942 Forest Park Elementary School   Regular School No 1.0 PK 08 2016   grade_8                         1.0 0.0                       1.0                         1 0                 1
1285936 1285936 IN     school 1811460 4645   Tri-Creek School Corporation 181146001852 3865 Lowell Senior High School   Regular School No 3.0 08 12 2016   grade_8                         1.0 1.0                       2.0                         1 1                 2
1288032 1288032 IN     school 1804770 5385   Indianapolis Public Schools 180477002555 5587 George W Carver School 87   Regular School No 1.0 PK 08 2016   grade_8                         1.0 6.0                       7.0                         1 6                 7
1293091 1293091 IN     school 1808250 225   Northwest Allen County Schools 180825002160 145 Allen Co Youth Services Center   Alternative School No Other 05 11 2017   grade_8                         1.0 1.0                       2.0                         1 1                 2
1296684 1296684 IN     school 1807440 3445   New Castle Community School Corp 180744001290 2825 New Castle High School   Regular School No High 08 12 2017   grade_8                         1.0 0.0                       1.0                         1 0                 1
1298038 1298038 IN     school 1802490 4660   Crown Point Community School Corp 180249000293 3901 Crown Point High School   Regular School No High 08 12 2017   grade_8                         1.0 0.0                       1.0                         1 0                 1
1302365 1302365 IN     school 1810290 7205   South Bend Community School Corp 181029000898 7632 Juvenile Justice Center   Alternative School No High 07 12 2017   grade_8                         1.0 0.0                       1.0                         1 0                 1
1302514 1302514 IN     school 1810140 7365   Shelbyville Central Schools 181014002496 7671 Especially Kidz Health & Rehab Cnt   Regular School No Other KG 12 2017   grade_8                         1.0 1.0                       2.0                         1 1                 2
1304155 1304155 IN     school 1800006 9100   Indiana Department of Corrections 180000601996 4846 Camp Summit Juvenile Facility   Regular School No High 08 12 2017   grade_8                         1.0 0.0                       1.0                         1 0                 1
1751722 1751722 IN     school 1803630 235   Fort Wayne Community Schools 180363002174 100 Allen Co Juvenile Center   Regular School No High 08 12 2019   grade_8                         1.0 0.0                       1.0                         1 0                 1
1755300 1755300 IN     school 1807440 3445   New Castle Community School Corp 180744001290 2825 New Castle High School   Regular School No High 07 12 2019   grade_8                         1.0 0.0                       1.0                         1 0                 1
1755444 1755444 IN     school 1804470 3490   Western School Corporation 180447002224 2923 Western Intermediate School   Regular School No Middle 03 08 2019   grade_8                         1.0 1.0                       2.0                         1 1                 2
1755777 1755777 IN     school 1806120 3995   Madison Consolidated Schools 180612001090 3309 Madison Consolidated High School   Regular School No High 08 12 2019   grade_8                         1.0 0.0                       1.0                         1 0                 1
1759493 1759493 IN     school 1802970 6060   East Noble School Corporation 180297000389 6458 East Noble High School   Regular School No High 08 12 2019   grade_8                         1.0 1.0                       2.0                         1 1                 2
1787467 1787467 IN     school 1803630 235   Fort Wayne Community Schools 180363002174 100 Allen Co Juvenile Center   Regular School No Secondary 08 11 2018   grade_8                         1.0 0.0                       1.0                         1 0                 1
1791395 1791395 IN     school 1801050 3695   Brownstown Cnt Com Sch Corp 180105001408 3108 Jackson Co Juvenile Detention Cntr   Alternative School No High 08 12 2018   grade_8                         1.0 0.0                       1.0                         1 0                 1
1794800 1794800 IN     school 1808850 5635   Peru Community Schools 180885001476 6085 Peru High School   Regular School No High 08 12 2018   grade_8                         1.0 0.0                       1.0                         1 0                 1
1796677 1796677 IN     school 1810290 7205   South Bend Community School Corp 181029000898 7632 Juvenile Justice Center   Alternative School No High 08 12 2018   grade_8                         1.0 1.0                       2.0                         1 1                 2
1798979 1798979 IN     school 1800121 9740   Thurgood Marshall Leadership Acad 180012102540 138 Thurgood Marshall Leadership Acad   Regular School Yes Elementary KG 08 2018   grade_8                         1.0 2.0                       3.0                         1 2                 3
1907162 1907162 IN     school 1803630 235   Fort Wayne Community Schools 180363002174 100 Allen Co Juvenile Center   Regular School No Secondary 08 11 2020   grade_8                         1.0 0.0                       1.0                         1 0                 1
1908004 1908004 IN     school 1806030 875   Logansport Community Sch Corp 180603001052 715 Columbia 6th Grade Academy   Regular School No Other 02 09 2020   grade_8                         1.0 0.0                       1.0                         1 0                 1
1908527 1908527 IN     school 1805700 1620   Lawrenceburg Community School Corp 180570001037 1177 Lawrenceburg High School   Regular School No High 08 12 2020   grade_8                         1.0 0.0                       1.0                         1 0                 1
1909788 1909788 IN     school   2865   Marion Community Schools   2416 Grant County Comm Justice Center             2020   grade_8                         1.0 0.0                       1.0                         1 0                 1
1910747 1910747 IN     school 1807440 3445   New Castle Community School Corp 180744001290 2825 New Castle High School   Regular School No High 07 12 2020   grade_8                         1.0 1.0                       2.0                         1 1                 2
1910890 1910890 IN     school 1804470 3490   Western School Corporation 180447002224 2923 Western Intermediate School   Regular School No Middle 03 08 2020   grade_8                         1.0 0.0                       1.0                         1 0                 1
1911541 1911541 IN     school 1807620 4255   Nineveh-Hensley-Jackson United 180762002686 3414 Indiana Academy Online   Regular School No High 07 12 2020   grade_8                         1.0 1.0                       2.0                         1 1                 2
1916271 1916271 IN     school 1810290 7205   South Bend Community School Corp 181029000898 7632 Juvenile Justice Center   Alternative School No Secondary 06 11 2020   grade_8                         1.0 0.0                       1.0                         1 0                 1
1917081 1917081 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002649 8271 Harwood Career Prep High School   Regular School No Other 02 12 2020   grade_8                         1.0 4.0                       5.0                         1 4                 5
1918230 1918230 IN     school 1800006 9100   Indiana Department of Correction 180000601946 732 Logansport Juvenile Correctional   Regular School No High 08 12 2020   grade_8                         1.0 0.0                       1.0                         1 0                 1
1918889 1918889 IN     school 1800168 9955   Mays Community Academy 180016802582 7231 Mays Community Academy   Regular School Yes Elementary KG 08 2020   grade_8                         1.0 9.0                       10.0                         1 9                 10
1919129 1919129 IN     school 1803630 235   Fort Wayne Community Schools 180363002174 100 Allen Co Juvenile Center   Regular School No Secondary 06 11 2021   grade_8                         1.0 0.0                       1.0                         1 0                 1
1919928 1919928 IN     school 1806030 875   Logansport Community Sch Corp 180603001060 701 Logansport Community High School   Regular School No High 07 12 2021   grade_8                         1.0 0.0                       1.0                         1 0                 1
1922626 1922626 IN     school 1808970 3330   Plainfield Community School Corp 180897002694 3331 Pride Academy   Regular School No Secondary 05 11 2021   grade_8                         1.0 0.0                       1.0                         1 0                 1
1922706 1922706 IN     school 1807440 3445   New Castle Community School Corp 180744001290 2825 New Castle High School   Regular School No High 07 12 2021   grade_8                         1.0 1.0                       2.0                         1 1                 2
1922849 1922849 IN     school 1804470 3490   Western School Corporation 180447002224 2923 Western Intermediate School   Regular School No Middle 03 08 2021   grade_8                         1.0 1.0                       2.0                         1 1                 2
1927141 1927141 IN     school   6510   East Porter County School Corp   6811 Porter County Education Services             2021   grade_8                         1.0 0.0                       1.0                         1 0                 1
1930447 1930447 IN     school 1800043 9465   Rural Community Schools Inc 180004302138 7951 Rural Community Academy   Regular School Yes Elementary KG 08 2021   grade_8                         1.0 3.0                       4.0                         1 3                 4
1166698 1166698 IN     school 1804770 5385   Indianapolis Public Schools 180477000887 5606 Robert Lee Frost School 106   Regular School No 1.0 KG 08 2015   grade_8                         10.0 7.0                       17.0                         10 7                 17
1171329 1171329 IN     school 1800072 9805   Hoosier Academy - Indianapolis 180007202422 2527 Hoosier Academy - Indianapolis   Regular School Yes 4.0 KG 12 2015   grade_8                         10.0 20.0                       30.0                         10 20                 30
1171390 1171390 IN     school 1800088 9870   Discovery Charter School 180008802495 6824 Discovery Charter School   Regular School Yes 1.0 KG 08 2015   grade_8                         10.0 9.0                       19.0                         10 9                 19
1284939 1284939 IN     school 1801230 3640   Medora Community School Corp 180123000201 3093 Medora Jr & Sr High School   Regular School No 4.0 06 12 2016   grade_8                         10.0 7.0                       17.0                         10 7                 17
1289185 1289185 IN     school 1801170 6340   Cannelton City Schools 180117000191 6733 Cannelton Elem & High School   Regular School No 4.0 PK 12 2016   grade_8                         10.0 7.0                       17.0                         10 7                 17
1292259 1292259 IN     school 1800143 9375   IN Math & Science Academy - South 180014302561 5671 IN Math & Science Academy - South   Regular School Yes 1.0 KG 08 2016   grade_8                         10.0 7.0                       17.0                         10 7                 17
1292439 1292439 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 Indiana School For The Blind   Alternative Education School No 4.0 PK 12 2016   grade_8                         10.0 8.0                       18.0                         10 8                 18
1292689 1292689 IN     school 1800072 9805   Hoosier Academy - Indianapolis 180007202422 2527 Hoosier Academy - Indianapolis   Regular School Yes 4.0 KG 12 2016   grade_8                         10.0 9.0                       19.0                         10 9                 19
1292720 1292720 IN     school 1800087 9845   Xavier School of Excellence 180008702445 7571 Xavier School of Excellence   Regular School Yes 1.0 KG 08 2016   grade_8                         10.0 9.0                       19.0                         10 9                 19
1295139 1295139 IN     school 1803270 2305   Elkhart Community Schools 180327002585 1752 Elkhart Alternative Education   Regular School No Other 01 12 2017   grade_8                         10.0 7.0                       17.0                         10 7                 17
1299827 1299827 IN     school 1804770 5385   Indianapolis Public Schools 180477000866 5531 James A Garfield School 31   Regular School No Elementary KG 08 2017   grade_8                         10.0 15.0                       25.0                         10 15                 25
1300009 1300009 IN     school 1804770 5385   Indianapolis Public Schools 180477000872 5570 Edison School of the Arts 47   Regular School No Elementary KG 08 2017   grade_8                         10.0 19.0                       29.0                         10 19                 29
1300060 1300060 IN     school 1804770 5385   Indianapolis Public Schools 180477002555 5587 George Washington Carver School 87   Regular School No Elementary PK 08 2017   grade_8                         10.0 10.0                       20.0                         10 10                 20
1304162 1304162 IN     school 1800006 9100   Indiana Department of Corrections 180000601935 5055 Pendleton Juvenile Correctional   Regular School No High 08 12 2017   grade_8                         10.0 0.0                       10.0                         10 0                 10
1304729 1304729 IN     school 1800072 9805   Hoosier Academy - Indianapolis 180007202422 2527 Hoosier Academy - Indianapolis   Regular School Yes Other KG 12 2017   grade_8                         10.0 16.0                       26.0                         10 16                 26
1304873 1304873 IN     school 1800108 9920   Damar Charter Academy 180010802503 5191 Damar Charter Academy   Regular School Yes Other KG 12 2017   grade_8                         10.0 2.0                       12.0                         10 2                 12
1304920 1304920 IN     school 1800165 9950   Dugger Union Community School Corp 180016502590 7952 Dugger Union Community School Corp   Regular School Yes Other KG 12 2017   grade_8                         10.0 8.0                       18.0                         10 8                 18
1753419 1753419 IN     school 1807320 1970   Muncie Community Schools 180732001232 1524 Youth Opportunity Center   Alternative School No Other 04 12 2019   grade_8                         10.0 8.0                       18.0                         10 8                 18
1759707 1759707 IN     school 1801170 6340   Cannelton City Schools 180117000191 6733 Cannelton Elementary & High School   Regular School No Other PK 12 2019   grade_8                         10.0 11.0                       21.0                         10 11                 21
1762764 1762764 IN     school 1800192 9095   Urban ACT Academy 180019202640 9094 Urban ACT Academy   Regular School Yes Elementary KG 08 2019   grade_8                         10.0 8.0                       18.0                         10 8                 18
1763084 1763084 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 IN Sch for the Blind & Vis Imprd   Special Education School No Other PK 12 2019   grade_8                         10.0 2.0                       12.0                         10 2                 12
1789159 1789159 IN     school 1807320 1970   Muncie Community Schools 180732001232 1524 Youth Opportunity Center   Alternative School No Other 03 12 2018   grade_8                         10.0 1.0                       11.0                         10 1                 11
1796771 1796771 IN     school 1803210 7285   Shelby Eastern Schools 180321000420 7665 Waldron Jr-Sr High School   Regular School No High 06 12 2018   grade_8                         10.0 23.0                       33.0                         10 23                 33
1797004 1797004 IN     school 1804230 7610   Hamilton Community Schools 180423000724 7885 Hamilton Community High School   Regular School No High 07 12 2018   grade_8                         10.0 8.0                       18.0                         10 8                 18
1798252 1798252 IN     school 1809510 8385   Richmond Community Schools 180951000366 9056 Community Youth Services   Special Education School No Other KG 12 2018   grade_8                         10.0 1.0                       11.0                         10 1                 11
1798930 1798930 IN     school 1800065 9690   Renaissance Academy Charter School 180006502415 4711 Renaissance Academy Charter School   Regular School Yes Elementary KG 08 2018   grade_8                         10.0 10.0                       20.0                         10 10                 20
1798969 1798969 IN     school 1800123 9735   Inspire Academy - A Sch of Inquiry 180012302560 1518 Inspire Academy - A Sch of Inquiry   Regular School Yes Elementary KG 08 2018   grade_8                         10.0 5.0                       15.0                         10 5                 15
1799198 1799198 IN     school 1800108 9920   Damar Charter Academy 180010802503 5191 Damar Charter Academy   Regular School Yes Other KG 12 2018   grade_8                         10.0 2.0                       12.0                         10 2                 12

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