enrollments

Data source: Big Local News · About: Big Local

2,924 rows where grade = "grade_9" and state = "IN" sorted by male_int

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_9 · 2,824 ✖
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
1928206 1928206 IN     school 1810290 7205   South Bend Community School Corp 181029000898 7632 Juvenile Justice Center   Alternative School No High 08 12 2021   grade_9                         2.0 2.0                       4.0                         2 2                 4
1171337 1171337 IN     school 1800075 9830   Beacon Academy 180007502428 8411 Beacon Academy   Regular School Yes 3.0 08 12 2015   grade_9                         3.0 0.0                       3.0                         3 0                 3
1292586 1292586 IN     school 1800113 9730   Neighbors' New Vistas High School 180011302544 6864 Neighbors' New Vistas High School   Regular School Yes 3.0 09 12 2016   grade_9                         3.0 3.0                       6.0                         3 3                 6
1292783 1292783 IN     school 1800102 9885   Gary Middle College 180010202535 4027 Gary Middle College   Regular School Yes 3.0 09 12 2016   grade_9                         3.0 6.0                       9.0                         3 6                 9
1295233 1295233 IN     school 1803930 2315   Goshen Community Schools 180393000659 1629 Goshen Middle School   Regular School No Other 06 11 2017   grade_9                         3.0 0.0                       3.0                         3 0                 3
1302366 1302366 IN     school 1810290 7205   South Bend Community School Corp 181029000898 7632 Juvenile Justice Center   Alternative School No High 07 12 2017   grade_9                         3.0 0.0                       3.0                         3 0                 3
1304220 1304220 IN     school 1800016 9325   Options Charter School - Carmel 180001601738 2524 Options Charter School - Carmel   Regular School Yes High 09 12 2017   grade_9                         3.0 2.0                       5.0                         3 2                 5
1304534 1304534 IN     school 1800056 9640   Options Charter School Noblesville 180005602313 2551 Options Charter School Noblesville   Regular School Yes Other 06 12 2017   grade_9                         3.0 0.0                       3.0                         3 0                 3
1752769 1752769 IN     school 1803940 1010   Greater Clark County Schools 180394000839 891 Clark County Middle/High School   Alternative School No High 07 12 2019   grade_9                         3.0 2.0                       5.0                         3 2                 5
1759157 1759157 IN     school 1800630 5740   Monroe County Community Sch Corp 180063002498 6220 Bloomington Graduation School   Regular School No High 09 12 2019   grade_9                         3.0 5.0                       8.0                         3 5                 8
1763085 1763085 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_9                         3.0 2.0                       5.0                         3 2                 5
1763522 1763522 IN     school 1800176 9985   Seven Oaks Classical School 180017602603 1114 Seven Oaks Classical School   Regular School Yes Other KG 10 2019   grade_9                         3.0 13.0                       16.0                         3 13                 16
1796678 1796678 IN     school 1810290 7205   South Bend Community School Corp 181029000898 7632 Juvenile Justice Center   Alternative School No High 08 12 2018   grade_9                         3.0 0.0                       3.0                         3 0                 3
1798885 1798885 IN     school 1800059 9655   Hope Academy 180005902386 5292 Hope Academy   Regular School Yes High 09 12 2018   grade_9                         3.0 2.0                       5.0                         3 2                 5
1799135 1799135 IN     school 1800102 9885   Gary Middle College 180010202535 4027 Gary Middle College   Regular School Yes High 09 12 2018   grade_9                         3.0 10.0                       13.0                         3 10                 13
1907163 1907163 IN     school 1803630 235   Fort Wayne Community Schools 180363002174 100 Allen Co Juvenile Center   Regular School No Secondary 08 11 2020   grade_9                         3.0 0.0                       3.0                         3 0                 3
1908198 1908198 IN     school 1803940 1010   Greater Clark County Schools 180394000832 886 Old Corden Porter School   Special Education School No High 06 12 2020   grade_9                         3.0 0.0                       3.0                         3 0                 3
1913646 1913646 IN     school   5375   M S D Wayne Township   5271 Sanders School             2020   grade_9                         3.0 3.0                       6.0                         3 3                 6
1914572 1914572 IN     school 1800630 5740   Monroe County Community Sch Corp 180063002498 6220 Bloomington Graduation School   Regular School No High 09 12 2020   grade_9                         3.0 6.0                       9.0                         3 6                 9
1925552 1925552 IN     school   5375   MSD Wayne Township   5271 Sanders School             2021   grade_9                         3.0 2.0                       5.0                         3 2                 5
1928014 1928014 IN     school 1810290 7205   South Bend Community School Corp 181029002699 7248 South Bend Virtual School   Regular School No Other 01 12 2021   grade_9                         3.0 4.0                       7.0                         3 4                 7
1159645 1159645 IN     school 1803630 235   Fort Wayne Community Schools 180363002174 100 Allen Co Juvenile Center   Regular School No 3.0 07 12 2015   grade_9                         4.0 0.0                       4.0                         4 0                 4
1160685 1160685 IN     school 1803940 1010   Greater Clark County Schools 180394000832 886 Old Corden Porter School   Special Education School No 4.0 04 12 2015   grade_9                         4.0 0.0                       4.0                         4 0                 4
1168298 1168298 IN     school   6720   Old National Trail Spec Serv Coop   7034 Old Nat'l Trail Sp Srvs             2015   grade_9                         4.0 1.0                       5.0                         4 1                 5
1171219 1171219 IN     school 1800113 9730   Neighbors' New Vistas High School 180011302544 6864 Neighbors' New Vistas High School   Regular School Yes 3.0 09 12 2015   grade_9                         4.0 0.0                       4.0                         4 0                 4
1292697 1292697 IN     school 1800075 9830   Beacon Academy 180007502428 8411 Beacon Academy   Regular School Yes 3.0 08 12 2016   grade_9                         4.0 3.0                       7.0                         4 3                 7
1299702 1299702 IN     school 1812810 5375   M S D Wayne Township 181281002516 5288 Achieve Virtual Education Academy   Regular School No High 09 12 2017   grade_9                         4.0 5.0                       9.0                         4 5                 9
1302821 1302821 IN     school 1805400 7855   Lafayette School Corporation 180540002518 8015 Oakland High School   Regular School No High 09 12 2017   grade_9                         4.0 5.0                       9.0                         4 5                 9
1304627 1304627 IN     school 1800113 9730   Neighbors' New Vistas High School 180011302544 6864 Neighbors' New Vistas High School   Regular School Yes High 09 12 2017   grade_9                         4.0 4.0                       8.0                         4 4                 8
1763221 1763221 IN     school 1800113 9730   Neighbors' New Vistas High School 180011302544 6864 Neighbors' New Vistas High School   Regular School Yes High 09 12 2019   grade_9                         4.0 10.0                       14.0                         4 10                 14
1788503 1788503 IN     school 1803940 1010   Greater Clark County Schools 180394000832 886 Old Corden Porter School   Special Education School No High 05 12 2018   grade_9                         4.0 2.0                       6.0                         4 2                 6
1791331 1791331 IN     school 1801230 3640   Medora Community School Corp 180123000201 3093 Medora Jr & Sr High School   Regular School No High 07 12 2018   grade_9                         4.0 8.0                       12.0                         4 8                 12
1794975 1794975 IN     school 1800630 5740   Monroe County Community Sch Corp 180063002498 6220 Bloomington Graduation School   Regular School No High 09 12 2018   grade_9                         4.0 1.0                       5.0                         4 1                 5
1796427 1796427 IN     school 1806840 7200   School City of Mishawaka 180684000531 7467 Oaklawn Campus Program   Special Education School No Other 03 12 2018   grade_9                         4.0 5.0                       9.0                         4 5                 9
1918194 1918194 IN     school 1800195 9070   Gary Middle College West 180019502641 1003 Gary Middle College West   Regular School Yes High 09 12 2020   grade_9                         4.0 7.0                       11.0                         4 7                 11
1918323 1918323 IN     school 1800016 9325   Options Charter School - Carmel 180001601738 2524 Options Charter School - Carmel   Regular School Yes High 09 12 2020   grade_9                         4.0 3.0                       7.0                         4 3                 7
1926451 1926451 IN     school 1800630 5740   Monroe County Community Sch Corp 180063002498 6220 Bloomington Graduation School   Regular School No High 09 12 2021   grade_9                         4.0 2.0                       6.0                         4 2                 6
1930302 1930302 IN     school 1800016 9325   Options Charter Schools 180001601738 2524 Options Charter School - Carmel   Regular School Yes High 06 12 2021   grade_9                         4.0 7.0                       11.0                         4 7                 11
1166263 1166263 IN     school 1812810 5375   M S D Wayne Township 181281002516 5288 Achieve Virtual Education Academy   Regular School No 3.0 09 12 2015   grade_9                         5.0 11.0                       16.0                         5 11                 16
1166820 1166820 IN     school 1800105 5390   Southside Sp Srvs Of Marion Co 180010502502 5320 RISE Learning Center   Regular School No 4.0 KG 12 2015   grade_9                         5.0 4.0                       9.0                         5 4                 9
1167787 1167787 IN     school 1801170 6340   Cannelton City Schools 180117000191 6733 Cannelton Elem & High School   Regular School No 4.0 PK 12 2015   grade_9                         5.0 6.0                       11.0                         5 6                 11
1170771 1170771 IN     school 1800134 9305   The Excel Center - Richmond 180013402549 9012 The Excel Center - Richmond   Regular School Yes 3.0 09 12 2015   grade_9                         5.0 9.0                       14.0                         5 9                 14
1283192 1283192 IN     school 1803930 2315   Goshen Community Schools 180393000659 1629 Goshen Middle School   Regular School No 4.0 06 10 2016   grade_9                         5.0 2.0                       7.0                         5 2                 7
1292186 1292186 IN     school 1800016 9325   Options Charter School - Carmel 180001601738 2524 Options Charter School - Carmel   Regular School Yes 3.0 09 12 2016   grade_9                         5.0 1.0                       6.0                         5 1                 6
1292490 1292490 IN     school 1800162 9630   Carpe Diem - Shadeland 180016202575 5978 Carpe Diem - Shadeland   Regular School Yes 4.0 06 10 2016   grade_9                         5.0 7.0                       12.0                         5 7                 12
1294153 1294153 IN     school 1803940 1010   Greater Clark County Schools 180394000839 891 Clark County Middle/High School   Alternative School No Other 06 12 2017   grade_9                         5.0 0.0                       5.0                         5 0                 5
1301771 1301771 IN     school 1811730 6795   Union School Corporation 181173001875 7119 Union Junior & High School   Regular School No High 07 12 2017   grade_9                         5.0 7.0                       12.0                         5 7                 12
1755586 1755586 IN     school 1801230 3640   Medora Community School Corp 180123000201 3093 Medora Jr & Sr High School   Regular School No High 07 12 2019   grade_9                         5.0 8.0                       13.0                         5 8                 13
1758240 1758240 IN     school 1812810 5375   M S D Wayne Township 181281002516 5288 Achieve Virtual Education Academy   Regular School No High 09 12 2019   grade_9                         5.0 10.0                       15.0                         5 10                 15
1762068 1762068 IN     school 1812090 8030   Vigo County School Corp 181209000926 8612 McLean Education Center (Alt)   Regular School No High 07 12 2019   grade_9                         5.0 3.0                       8.0                         5 3                 8
1762860 1762860 IN     school 1800016 9325   Options Charter School - Carmel 180001601738 2524 Options Charter School - Carmel   Regular School Yes High 09 12 2019   grade_9                         5.0 2.0                       7.0                         5 2                 7
1797137 1797137 IN     school 1805400 7855   Lafayette School Corporation 180540002518 8015 Oakland High School   Regular School No High 09 12 2018   grade_9                         5.0 4.0                       9.0                         5 4                 9
1798960 1798960 IN     school 1800113 9730   Neighbors' New Vistas High School 180011302544 6864 Neighbors' New Vistas High School   Regular School Yes High 09 12 2018   grade_9                         5.0 2.0                       7.0                         5 2                 7
1916728 1916728 IN     school 1805400 7855   Lafayette School Corporation 180540002518 8015 Oakland High School   Regular School No High 09 12 2020   grade_9                         5.0 2.0                       7.0                         5 2                 7
1930185 1930185 IN     school 1800006 9100   Indiana Department of Correction 180000601946 732 Logansport Juvenile Correctional   Regular School No High 08 12 2021   grade_9                         5.0 0.0                       5.0                         5 0                 5
1930318 1930318 IN     school 1800016 9325   Options Charter Schools 180001602700 9329 Options Indiana   Regular School Yes High 06 12 2021   grade_9                         5.0 7.0                       12.0                         5 7                 12
1170809 1170809 IN     school 1800016 9325   Options Charter School - Carmel 180001601738 2524 Options Charter School - Carmel   Regular School Yes 3.0 09 12 2015   grade_9                         6.0 5.0                       11.0                         6 5                 11
1171063 1171063 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 2015   grade_9                         6.0 3.0                       9.0                         6 3                 9
1171113 1171113 IN     school 1800056 9640   Options Charter Sch - Noblesville 180005602313 2551 Options Charter School Noblesville   Regular School Yes 3.0 09 12 2015   grade_9                         6.0 5.0                       11.0                         6 5                 11
1282086 1282086 IN     school 1803940 1010   Greater Clark County Schools 180394000832 886 Old Corden Porter School   Special Education School No 4.0 05 12 2016   grade_9                         6.0 1.0                       7.0                         6 1                 7
1282094 1282094 IN     school 1803940 1010   Greater Clark County Schools 180394000839 891 Clark County Middle/High School   Alternative Education School No 4.0 06 12 2016   grade_9                         6.0 2.0                       8.0                         6 2                 8
1302110 1302110 IN     school 1806840 7200   School City of Mishawaka 180684000531 7467 Oaklawn Campus Program   Special Education School No Other 03 12 2017   grade_9                         6.0 8.0                       14.0                         6 8                 14
1788510 1788510 IN     school 1803940 1010   Greater Clark County Schools 180394000839 891 Clark County Middle/High School   Alternative School No High 07 12 2018   grade_9                         6.0 1.0                       7.0                         6 1                 7
1797005 1797005 IN     school 1804230 7610   Hamilton Community Schools 180423000724 7885 Hamilton Community High School   Regular School No High 07 12 2018   grade_9                         6.0 5.0                       11.0                         6 5                 11
1798547 1798547 IN     school 1800186 9155   Indiana Virtual Pathways Academy 180018602629 5468 Indiana Virtual Pathways Academy   Regular School Yes High 09 12 2018   grade_9                         6.0 6.0                       12.0                         6 6                 12
1798585 1798585 IN     school 1800016 9325   Options Charter School - Carmel 180001601738 2524 Options Charter School - Carmel   Regular School Yes High 09 12 2018   grade_9                         6.0 0.0                       6.0                         6 0                 6
1799291 1799291 IN     school 1800176 9985   Seven Oaks Classical School 180017602603 1114 Seven Oaks Classical School   Regular School Yes Other KG 09 2018   grade_9                         6.0 2.0                       8.0                         6 2                 8
1916028 1916028 IN     school 1806840 7200   School City of Mishawaka 180684000531 7467 Oaklawn Campus Program   Special Education School No High 06 12 2020   grade_9                         6.0 5.0                       11.0                         6 5                 11
1916272 1916272 IN     school 1810290 7205   South Bend Community School Corp 181029000898 7632 Juvenile Justice Center   Alternative School No Secondary 06 11 2020   grade_9                         6.0 0.0                       6.0                         6 0                 6
1920173 1920173 IN     school 1803940 1010   Greater Clark County Schools 180394000832 886 Old Corden Porter School   Special Education School No High 06 12 2021   grade_9                         6.0 3.0                       9.0                         6 3                 9
1921144 1921144 IN     school 1803270 2305   Elkhart Community Schools 180327002585 1752 Elkhart Alternative Education   Regular School No Other 01 12 2021   grade_9                         6.0 4.0                       10.0                         6 4                 10
1923214 1923214 IN     school 1806120 3995   Madison Consolidated Schools 180612002695 3358 E.O. Muncie Jr/Sr High School   Regular School No High 07 12 2021   grade_9                         6.0 0.0                       6.0                         6 0                 6
1930549 1930549 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 2021   grade_9                         6.0 5.0                       11.0                         6 5                 11
1930678 1930678 IN     school 1800113 9730   Neighbors' New Vistas High School 180011302544 6864 Neighbors' New Vistas High School   Regular School Yes High 09 12 2021   grade_9                         6.0 3.0                       9.0                         6 3                 9
1930938 1930938 IN     school 1800176 9985   Seven Oaks Classical School 180017602603 1114 Seven Oaks Classical School   Regular School Yes Other KG 12 2021   grade_9                         6.0 10.0                       16.0                         6 10                 16
1160692 1160692 IN     school 1803940 1010   Greater Clark County Schools 180394000839 891 Clark County Middle/High School   Alternative Education School No 3.0 07 12 2015   grade_9                         7.0 8.0                       15.0                         7 8                 15
1170933 1170933 IN     school 1800154 9435   Indiana Achievement Academy 180015402572 5771 Indiana Achievement Academy   Regular School Yes 3.0 09 12 2015   grade_9                         7.0 13.0                       20.0                         7 13                 20
1171266 1171266 IN     school 1800131 9760   Smith Academy for Excellence 180013102539 242 Smith Academy for Excellence   Regular School Yes 4.0 03 11 2015   grade_9                         7.0 0.0                       7.0                         7 0                 7
1295140 1295140 IN     school 1803270 2305   Elkhart Community Schools 180327002585 1752 Elkhart Alternative Education   Regular School No Other 01 12 2017   grade_9                         7.0 10.0                       17.0                         7 10                 17
1303931 1303931 IN     school 1809510 8385   Richmond Community Schools 180951000366 9056 Community Youth Services   Special Education School No Other 01 12 2017   grade_9                         7.0 3.0                       10.0                         7 3                 10
1761677 1761677 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002649 8271 Harwood Career Prep High School   Regular School No Other 01 12 2019   grade_9                         7.0 1.0                       8.0                         7 1                 8
1913668 1913668 IN     school 1812810 5375   M S D Wayne Township 181281002516 5288 Achieve Virtual Education Academy   Regular School No High 09 12 2020   grade_9                         7.0 11.0                       18.0                         7 11                 18
1918937 1918937 IN     school 1800176 9985   Seven Oaks Classical School 180017602603 1114 Seven Oaks Classical School   Regular School Yes Other KG 11 2020   grade_9                         7.0 11.0                       18.0                         7 11                 18
1929413 1929413 IN     school 1812090 8030   Vigo County School Corp 181209002344 8611 Booker T Washington Alt Sch   Alternative School No High 06 12 2021   grade_9                         7.0 4.0                       11.0                         7 4                 11
1930046 1930046 IN     school 1800205 8690   Dynamic Minds Academy 180020502673 8692 Dynamic Minds Academy   Regular School Yes Other KG 12 2021   grade_9                         7.0 1.0                       8.0                         7 1                 8
1930787 1930787 IN     school 1800102 9885   Gary Middle College 180010202535 4027 Gary Middle College   Regular School Yes High 09 12 2021   grade_9                         7.0 10.0                       17.0                         7 10                 17
1166241 1166241 IN     school   5375   M S D Wayne Township   5271 Sanders School             2015   grade_9                         8.0 0.0                       8.0                         8 0                 8
1171330 1171330 IN     school 1800072 9805   Hoosier Academy - Indianapolis 180007202422 2527 Hoosier Academy - Indianapolis   Regular School Yes 4.0 KG 12 2015   grade_9                         8.0 12.0                       20.0                         8 12                 20
1287643 1287643 IN     school   5375   M S D Wayne Township   5271 Sanders School             2016   grade_9                         8.0 0.0                       8.0                         8 0                 8
1287664 1287664 IN     school 1812810 5375   M S D Wayne Township 181281002516 5288 Achieve Virtual Education Academy   Regular School No 3.0 09 12 2016   grade_9                         8.0 17.0                       25.0                         8 17                 25
1292133 1292133 IN     school 1800006 9100   IN Department of Correction 180000601996 4846 Camp Summit Juv Facility   Regular School No 3.0 09 12 2016   grade_9                         8.0 0.0                       8.0                         8 0                 8
1292308 1292308 IN     school 1800166 9440   Christel House DORS West 180016602586 5873 Christel House DORS West   Regular School Yes 4.0 09 11 2016   grade_9                         8.0 35.0                       43.0                         8 35                 43
1292440 1292440 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_9                         8.0 0.0                       8.0                         8 0                 8
1292623 1292623 IN     school 1800125 9755   Carpe Diem - Meridian Campus 180012502536 5979 Carpe Diem - Meridian Campus   Regular School Yes 4.0 06 12 2016   grade_9                         8.0 11.0                       19.0                         8 11                 19
1292892 1292892 IN     school 1800165 9950   Dugger Union Community School Corp 180016502590 7952 Dugger Union Community School Corp   Regular School Yes 4.0 KG 12 2016   grade_9                         8.0 15.0                       23.0                         8 15                 23
1304156 1304156 IN     school 1800006 9100   Indiana Department of Corrections 180000601996 4846 Camp Summit Juvenile Facility   Regular School No High 08 12 2017   grade_9                         8.0 0.0                       8.0                         8 0                 8
1304921 1304921 IN     school 1800165 9950   Dugger Union Community School Corp 180016502590 7952 Dugger Union Community School Corp   Regular School Yes Other KG 12 2017   grade_9                         8.0 21.0                       29.0                         8 21                 29
1752762 1752762 IN     school 1803940 1010   Greater Clark County Schools 180394000832 886 Old Corden Porter School   Special Education School No High 06 12 2019   grade_9                         8.0 2.0                       10.0                         8 2                 10
1760279 1760279 IN     school 1811730 6795   Union School Corporation 181173002660 7142 Indiana Digital Alternative School   Regular School No High 09 12 2019   grade_9                         8.0 4.0                       12.0                         8 4                 12
1763312 1763312 IN     school 1800072 9805   Hoosier Academy - Indianapolis 180007202422 2527 Hoosier Academy - Indianapolis   Regular School Yes Other KG 12 2019   grade_9                         8.0 4.0                       12.0                         8 4                 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]);