enrollments

Data source: Big Local News · About: Big Local

2,933 rows where grade = "grade_12" and state = "IN" sorted by female

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_12 · 2,933 ✖
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
1159642 1159642 IN     school 1803630 235   Fort Wayne Community Schools 180363002174 100 Allen Co Juvenile Center   Regular School No 3.0 07 12 2015   grade_12                         1.0 0.0                       1.0                         1 0                 1
1160679 1160679 IN     school 1803940 1010   Greater Clark County Schools 180394000832 886 Old Corden Porter School   Special Education School No 4.0 04 12 2015   grade_12                         4.0 0.0                       4.0                         4 0                 4
1162675 1162675 IN     school 1807650 3070   Noblesville Schools 180765002369 2514 MOSAICS School   Special Education School No 3.0 07 12 2015   grade_12                         1.0 0.0                       1.0                         1 0                 1
1164355 1164355 IN     school 1808320 4570   Northwest Indiana Spec Ed Coop 180832002208 4287 Eagle Park Community School   Special Education School No 4.0 KG 12 2015   grade_12                         3.0 0.0                       3.0                         3 0                 3
1168940 1168940 IN     school 1810290 7205   South Bend Community Sch Corp 181029002574 7617 Studebaker Center   Regular School No 4.0 PK 12 2015   grade_12                         5.0 0.0                       5.0                         5 0                 5
1170743 1170743 IN     school 1800006 9100   IN Department of Correction 180000601946 732 Logansport Juvenile Cor Fac   Regular School No 3.0 07 12 2015   grade_12                         1.0 0.0                       1.0                         1 0                 1
1170750 1170750 IN     school 1800006 9100   IN Department of Correction 180000601996 4846 Camp Summit Juv Facility   Regular School No 3.0 09 12 2015   grade_12                         13.0 0.0                       13.0                         13 0                 13
1170756 1170756 IN     school 1800006 9100   IN Department of Correction 180000601935 5055 Pendleton Juv Correctional Fac   Regular School No 3.0 08 12 2015   grade_12                         7.0 0.0                       7.0                         7 0                 7
1281035 1281035 IN     school 1803630 235   Fort Wayne Community Schools 180363002174 100 Allen Co Juvenile Center   Regular School No 3.0 08 12 2016   grade_12                         1.0 0.0                       1.0                         1 0                 1
1290325 1290325 IN     school 1810290 7205   South Bend Community Sch Corp 181029002574 7617 Studebaker Center   Regular School No 4.0 PK 12 2016   grade_12                         9.0 0.0                       9.0                         9 0                 9
1290336 1290336 IN     school 1810290 7205   South Bend Community Sch Corp 181029000898 7632 Juvenile Justice Center   Alternative Education School No 3.0 07 12 2016   grade_12                         3.0 0.0                       3.0                         3 0                 3
1292125 1292125 IN     school 1800006 9100   IN Department of Correction 180000601946 732 Logansport Juvenile Cor Facility   Regular School No 3.0 08 12 2016   grade_12                         3.0 0.0                       3.0                         3 0                 3
1292132 1292132 IN     school 1800006 9100   IN Department of Correction 180000601996 4846 Camp Summit Juv Facility   Regular School No 3.0 09 12 2016   grade_12                         13.0 0.0                       13.0                         13 0                 13
1292138 1292138 IN     school 1800006 9100   IN Department of Correction 180000601935 5055 Pendleton Juv Correctional Fac   Regular School No 3.0 07 12 2016   grade_12                         9.0 0.0                       9.0                         9 0                 9
1292627 1292627 IN     school 1800131 9760   Smith Academy for Excellence 180013102539 242 Smith Academy for Excellence   Regular School Yes 4.0 02 12 2016   grade_12                         7.0 0.0                       7.0                         7 0                 7
1303923 1303923 IN     school 1809510 8385   Richmond Community Schools 180951000366 9056 Community Youth Services   Special Education School No Other 01 12 2017   grade_12                         4.0 0.0                       4.0                         4 0                 4
1304147 1304147 IN     school 1800006 9100   Indiana Department of Corrections 180000601946 732 Logansport Juvenile Correctional   Regular School No High 07 12 2017   grade_12                         5.0 0.0                       5.0                         5 0                 5
1304154 1304154 IN     school 1800006 9100   Indiana Department of Corrections 180000601996 4846 Camp Summit Juvenile Facility   Regular School No High 08 12 2017   grade_12                         10.0 0.0                       10.0                         10 0                 10
1304161 1304161 IN     school 1800006 9100   Indiana Department of Corrections 180000601935 5055 Pendleton Juvenile Correctional   Regular School No High 08 12 2017   grade_12                         5.0 0.0                       5.0                         5 0                 5
1304667 1304667 IN     school 1800131 9760   Smith Academy for Excellence 180013102539 242 Smith Academy for Excellence   Regular School Yes Other 04 12 2017   grade_12                         9.0 0.0                       9.0                         9 0                 9
1751721 1751721 IN     school 1803630 235   Fort Wayne Community Schools 180363002174 100 Allen Co Juvenile Center   Regular School No High 08 12 2019   grade_12                         1.0 0.0                       1.0                         1 0                 1
1752758 1752758 IN     school 1803940 1010   Greater Clark County Schools 180394000832 886 Old Corden Porter School   Special Education School No High 06 12 2019   grade_12                         8.0 0.0                       8.0                         8 0                 8
1753415 1753415 IN     school 1807320 1970   Muncie Community Schools 180732001232 1524 Youth Opportunity Center   Alternative School No Other 04 12 2019   grade_12                         5.0 0.0                       5.0                         5 0                 5
1758210 1758210 IN     school   5375   M S D Wayne Township   5271 Sanders School             2019   grade_12                         6.0 0.0                       6.0                         6 0                 6
1762770 1762770 IN     school 1800006 9100   Indiana Department of Correction 180000601946 732 Logansport Juvenile Correctional   Regular School No High 07 12 2019   grade_12                         7.0 0.0                       7.0                         7 0                 7
1762778 1762778 IN     school 1800006 9100   Indiana Department of Correction 180000601935 5055 Pendleton Juvenile Correctional   Regular School No High 07 12 2019   grade_12                         14.0 0.0                       14.0                         14 0                 14
1763246 1763246 IN     school 1800131 9760   Smith Academy for Excellence 180013102539 242 Smith Academy for Excellence   Regular School Yes Other 04 12 2019   grade_12                         8.0 0.0                       8.0                         8 0                 8
1788498 1788498 IN     school 1803940 1010   Greater Clark County Schools 180394000832 886 Old Corden Porter School   Special Education School No High 05 12 2018   grade_12                         5.0 0.0                       5.0                         5 0                 5
1791394 1791394 IN     school 1801050 3695   Brownstown Cnt Com Sch Corp 180105001408 3108 Jackson Co Juvenile Detention Cntr   Alternative School No High 08 12 2018   grade_12                         3.0 0.0                       3.0                         3 0                 3
1794000 1794000 IN     school   5375   M S D Wayne Township   5271 Sanders School             2018   grade_12                         5.0 0.0                       5.0                         5 0                 5
1796666 1796666 IN     school 1810290 7205   South Bend Community School Corp 181029002574 7617 Studebaker Center   Regular School No High 12 12 2018   grade_12                         1.0 0.0                       1.0                         1 0                 1
1796676 1796676 IN     school 1810290 7205   South Bend Community School Corp 181029000898 7632 Juvenile Justice Center   Alternative School No High 08 12 2018   grade_12                         2.0 0.0                       2.0                         2 0                 2
1798503 1798503 IN     school 1800006 9100   Indiana Department of Correction 180000601946 732 Logansport Juvenile Correctional   Regular School No High 07 12 2018   grade_12                         6.0 0.0                       6.0                         6 0                 6
1798511 1798511 IN     school 1800006 9100   Indiana Department of Correction 180000601996 4846 Camp Summit Juvenile Facility   Regular School No High 09 12 2018   grade_12                         9.0 0.0                       9.0                         9 0                 9
1798517 1798517 IN     school 1800006 9100   Indiana Department of Correction 180000601935 5055 Pendleton Juvenile Correctional   Regular School No High 08 12 2018   grade_12                         5.0 0.0                       5.0                         5 0                 5
1798992 1798992 IN     school 1800131 9760   Smith Academy for Excellence 180013102539 242 Smith Academy for Excellence   Regular School Yes Other 04 12 2018   grade_12                         5.0 0.0                       5.0                         5 0                 5
1910235 1910235 IN     school 1807650 3070   Noblesville Schools 180765002621 2546 Juvenile Services Center   Alternative School No High 12 12 2020   grade_12                         1.0 0.0                       1.0                         1 0                 1
1918229 1918229 IN     school 1800006 9100   Indiana Department of Correction 180000601946 732 Logansport Juvenile Correctional   Regular School No High 08 12 2020   grade_12                         34.0 0.0                       34.0                         34 0                 34
1918236 1918236 IN     school 1800006 9100   Indiana Department of Correction 180000601935 5055 Pendleton Juvenile Correctional   Regular School No High 08 12 2020   grade_12                         22.0 0.0                       22.0                         22 0                 22
1918708 1918708 IN     school 1800131 9760   Smith Academy for Excellence 180013102539 242 Smith Academy for Excellence   Regular School Yes Other 04 12 2020   grade_12                         6.0 0.0                       6.0                         6 0                 6
1919965 1919965 IN     school 1806030 875   Logansport Community Sch Corp 180603001052 715 Columbia 6th Grade Academy   Regular School No Other 03 12 2021   grade_12                         1.0 0.0                       1.0                         1 0                 1
1925544 1925544 IN     school   5375   MSD Wayne Township   5271 Sanders School             2021   grade_12                         4.0 0.0                       4.0                         4 0                 4
1927189 1927189 IN     school   6520   Porter Township School Corp   6811 Porter County Education Services             2021   grade_12                         1.0 0.0                       1.0                         1 0                 1
1927325 1927325 IN     school   6560   Valparaiso Community Schools   6811 Porter County Education Services             2021   grade_12                         2.0 0.0                       2.0                         2 0                 2
1928204 1928204 IN     school 1810290 7205   South Bend Community School Corp 181029000898 7632 Juvenile Justice Center   Alternative School No High 08 12 2021   grade_12                         2.0 0.0                       2.0                         2 0                 2
1930084 1930084 IN     school 1800222 9000   Phalen Virtual Leadership Academy 180022202707 9992 Phalen Virtual Leadership Academy   Regular School Yes Other 02 12 2021   grade_12                         1.0 0.0                       1.0                         1 0                 1
1930183 1930183 IN     school 1800006 9100   Indiana Department of Correction 180000601946 732 Logansport Juvenile Correctional   Regular School No High 08 12 2021   grade_12                         37.0 0.0                       37.0                         37 0                 37
1930190 1930190 IN     school 1800006 9100   Indiana Department of Correction 180000601935 5055 Pendleton Juvenile Correctional   Regular School No High 08 12 2021   grade_12                         16.0 0.0                       16.0                         16 0                 16
1930696 1930696 IN     school 1800131 9760   Smith Academy for Excellence 180013102539 242 Smith Academy for Excellence   Regular School Yes Other 04 12 2021   grade_12                         8.0 0.0                       8.0                         8 0                 8
1166233 1166233 IN     school   5375   M S D Wayne Township   5271 Sanders School             2015   grade_12                         7.0 1.0                       8.0                         7 1                 8
1168297 1168297 IN     school   6720   Old National Trail Spec Serv Coop   7034 Old Nat'l Trail Sp Srvs             2015   grade_12                         3.0 1.0                       4.0                         3 1                 4
1168686 1168686 IN     school 1806840 7200   School City of Mishawaka 180684000531 7467 Joint Service Campus Program   Special Education School No 4.0 03 12 2015   grade_12                         3.0 1.0                       4.0                         3 1                 4
1168951 1168951 IN     school 1810290 7205   South Bend Community Sch Corp 181029000898 7632 Juvenile Justice Center   Alternative Education School No 3.0 07 12 2015   grade_12                         2.0 1.0                       3.0                         2 1                 3
1169094 1169094 IN     school 1810140 7365   Shelbyville Central Schools 181014002496 7671 Especially Kidz Health & Rehab Cnt   Regular School No 4.0 PK 12 2015   grade_12                         2.0 1.0                       3.0                         2 1                 3
1170511 1170511 IN     school 1809510 8385   Richmond Community Schools 180951000366 9056 Community Youth Services   Special Education School No 4.0 KG 12 2015   grade_12                         8.0 1.0                       9.0                         8 1                 9
1291898 1291898 IN     school 1809510 8385   Richmond Community Schools 180951000366 9056 Community Youth Services   Special Education School No 4.0 KG 12 2016   grade_12                         9.0 1.0                       10.0                         9 1                 10
1293096 1293096 IN     school 1803630 235   Fort Wayne Community Schools 180363002174 100 Allen Co Juvenile Center   Regular School No High 08 12 2017   grade_12                         3.0 1.0                       4.0                         3 1                 4
1299672 1299672 IN     school   5375   M S D Wayne Township   5271 Sanders School             2017   grade_12                         6.0 1.0                       7.0                         6 1                 7
1302103 1302103 IN     school 1806840 7200   School City of Mishawaka 180684000531 7467 Oaklawn Campus Program   Special Education School No Other 03 12 2017   grade_12                         4.0 1.0                       5.0                         4 1                 5
1302363 1302363 IN     school 1810290 7205   South Bend Community School Corp 181029000898 7632 Juvenile Justice Center   Alternative School No High 07 12 2017   grade_12                         4.0 1.0                       5.0                         4 1                 5
1304522 1304522 IN     school 1800162 9630   Carpe Diem - Shadeland 180016202575 5978 Carpe Diem - Shadeland   Regular School Yes Other 06 12 2017   grade_12                         1.0 1.0                       2.0                         1 1                 2
1753834 1753834 IN     school 1803930 2315   Goshen Community Schools 180393000659 1629 Goshen Middle School   Regular School No High 05 12 2019   grade_12                         0.0 1.0                       1.0                         0 1                 1
1760278 1760278 IN     school 1811730 6795   Union School Corporation 181173002660 7142 Indiana Digital Alternative School   Regular School No High 09 12 2019   grade_12                         3.0 1.0                       4.0                         3 1                 4
1762461 1762461 IN     school 1809510 8385   Richmond Community Schools 180951000366 9056 Community Youth Services   Special Education School No Other KG 12 2019   grade_12                         5.0 1.0                       6.0                         5 1                 6
1763077 1763077 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_12                         7.0 1.0                       8.0                         7 1                 8
1789572 1789572 IN     school 1803930 2315   Goshen Community Schools 180393000659 1629 Goshen Middle School   Regular School No Middle 05 12 2018   grade_12                         0.0 1.0                       1.0                         0 1                 1
1911029 1911029 IN     school 1801230 3640   Medora Community School Corp 180123000201 3093 Medora Jr & Sr High School   Regular School No High 07 12 2020   grade_12                         9.0 1.0                       10.0                         9 1                 10
1917881 1917881 IN     school 1809510 8385   Richmond Community Schools 180951000366 9056 Community Youth Services   Special Education School No Other KG 12 2020   grade_12                         7.0 1.0                       8.0                         7 1                 8
1918272 1918272 IN     school 1800197 9160   Excel Center - Muncie 180019702662 1016 Excel Center - Muncie   Regular School Yes High 11 12 2020   grade_12                         0.0 1.0                       1.0                         0 1                 1
1920045 1920045 IN     school 1801920 1000   Clarksville Community School Corp 180192002690 1007 Indiana Gateway Digital Academy   Regular School No Other KG 12 2021   grade_12                         0.0 1.0                       1.0                         0 1                 1
1920821 1920821 IN     school 1807320 1970   Muncie Community Schools 180732001232 1524 Youth Opportunity Center   Alternative School No High 05 12 2021   grade_12                         6.0 1.0                       7.0                         6 1                 7
1924845 1924845 IN     school 1800120 5265   Alexandria Community School Corp 180012000009 5069 Alexandria Monroe Academy and Cent   Regular School No High 10 12 2021   grade_12                         3.0 1.0                       4.0                         3 1                 4
1927242 1927242 IN     school   6550   Portage Township Schools   6811 Porter County Education Services             2021   grade_12                         0.0 1.0                       1.0                         0 1                 1
1929809 1929809 IN     school 1809510 8385   Richmond Community Schools 180951000366 9056 Community Youth Services   Special Education School No Other 01 12 2021   grade_12                         1.0 1.0                       2.0                         1 1                 2
1163609 1163609 IN     school 1812060 3710   Crothersville Community Schools 181206001893 3121 Crothersville Jr-Sr High School   Regular School No 4.0 06 12 2015   grade_12                         14.0 10.0                       24.0                         14 10                 24
1170735 1170735 IN     school 1800114 8830   EdPower Arlington 180011400799 5465 Arlington Community High School   Regular School No 3.0 07 12 2015   grade_12                         18.0 10.0                       28.0                         18 10                 28
1171322 1171322 IN     school 1800072 9805   Hoosier Academy - Indianapolis 180007202422 2527 Hoosier Academy - Indianapolis   Regular School Yes 4.0 KG 12 2015   grade_12                         9.0 10.0                       19.0                         9 10                 19
1171432 1171432 IN     school 1800094 9895   Indiana Math Science Academy North 180009402487 5444 IN Math & Science Acad North   Regular School Yes 4.0 KG 12 2015   grade_12                         18.0 10.0                       28.0                         18 10                 28
1290792 1290792 IN     school 1805400 7855   Lafayette School Corporation 180540002518 8015 Oakland High School   Regular School No 3.0 09 12 2016   grade_12                         9.0 10.0                       19.0                         9 10                 19
1301207 1301207 IN     school 1801170 6340   Cannelton City Schools 180117000191 6733 Cannelton Elementary & High School   Regular School No Other PK 12 2017   grade_12                         5.0 10.0                       15.0                         5 10                 15
1304480 1304480 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Alternative School No Other PK 12 2017   grade_12                         23.0 10.0                       33.0                         23 10                 33
1304609 1304609 IN     school 1800167 9710   Carpe Diem - Northwest 180016702579 5977 Carpe Diem - Northwest   Regular School Yes Other 06 12 2017   grade_12                         9.0 10.0                       19.0                         9 10                 19
1752766 1752766 IN     school 1803940 1010   Greater Clark County Schools 180394000839 891 Clark County Middle/High School   Alternative School No High 07 12 2019   grade_12                         19.0 10.0                       29.0                         19 10                 29
1760257 1760257 IN     school 1811730 6795   Union School Corporation 181173001875 7119 Union Junior & High School   Regular School No High 07 12 2019   grade_12                         11.0 10.0                       21.0                         11 10                 21
1763006 1763006 IN     school 1800198 9505   Indiana Agriculture and Technology 180019802665 5472 Indiana Agriculture and Technology   Regular School Yes High 07 12 2019   grade_12                         8.0 10.0                       18.0                         8 10                 18
1797136 1797136 IN     school 1805400 7855   Lafayette School Corporation 180540002518 8015 Oakland High School   Regular School No High 09 12 2018   grade_12                         7.0 10.0                       17.0                         7 10                 17
1799191 1799191 IN     school 1800108 9920   Damar Charter Academy 180010802503 5191 Damar Charter Academy   Regular School Yes Other KG 12 2018   grade_12                         25.0 10.0                       35.0                         25 10                 35
1916415 1916415 IN     school 1810140 7365   Shelbyville Central Schools 181014002496 7671 Especially Kidz Health & Rehab Cnt   Regular School No Other 01 12 2020   grade_12                         7.0 10.0                       17.0                         7 10                 17
1918344 1918344 IN     school 1800142 9345   Excel Center - Lafayette 180014202548 8094 Excel Center - Lafayette   Regular School Yes High 11 12 2020   grade_12                         6.0 10.0                       16.0                         6 10                 16
1291118 1291118 IN     school 1803450 7995   Evansville Vanderburgh Sch Corp 180345002462 8270 Academy for Innovative Studies   Regular School No 4.0 01 12 2016   grade_12                         112.0 100.0                       212.0                         112 100                 212
1294462 1294462 IN     school 1800240 1600   South Dearborn Community Sch Corp 180024000056 1179 South Dearborn High School   Regular School No High 09 12 2017   grade_12                         111.0 100.0                       211.0                         111 100                 211
1295497 1295497 IN     school 1803700 2475   Franklin County Community Sch Corp 180370002336 2083 Franklin County High   Regular School No High 09 12 2017   grade_12                         106.0 100.0                       206.0                         106 100                 206
1303147 1303147 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002462 8270 Academy for Innovative Studies   Regular School No Other KG 12 2017   grade_12                         121.0 100.0                       221.0                         121 100                 221
1304186 1304186 IN     school 1800134 9305   Excel Center - Richmond 180013402549 9012 Excel Center - Richmond   Regular School Yes High 11 12 2017   grade_12                         88.0 100.0                       188.0                         88 100                 188
1794833 1794833 IN     school 1809480 5705   Richland-Bean Blossom C S C 180948001546 6146 Edgewood High School   Regular School No High 09 12 2018   grade_12                         97.0 100.0                       197.0                         97 100                 197
1799092 1799092 IN     school 1800081 9865   Hoosier Acad Virtual Charter 180008102458 5290 Hoosier Acad Virtual Charter Sch   Regular School Yes Other KG 12 2018   grade_12                         58.0 100.0                       158.0                         58 100                 158
1908302 1908302 IN     school 1803660 1170   Community Schools of Frankfort 180366000574 997 Frankfort High School   Regular School No High 09 12 2020   grade_12                         101.0 100.0                       201.0                         101 100                 201
1919448 1919448 IN     school 1802850 255   East Allen County Schools 180285000349 49 Leo Junior/Senior High School   Regular School No High 07 12 2021   grade_12                         124.0 100.0                       224.0                         124 100                 224
1930336 1930336 IN     school 1800138 9335   Excel Center - Lafayette Square 180013802554 5912 Excel Center - Lafayette Square   Regular School Yes High 10 12 2021   grade_12                         57.0 100.0                       157.0                         57 100                 157
1161196 1161196 IN     school 1802660 1875   Delaware Community School Corp 180266000320 1369 Delta High School   Regular School No 3.0 09 12 2015   grade_12                         94.0 101.0                       195.0                         94 101                 195

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