enrollments

Data source: Big Local News · About: Big Local

2,939 rows where grade = "grade_10" and state = "IN" sorted by female_int

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_10 · 2,939 ✖
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
1159634 1159634 IN     school 1808250 225   Northwest Allen County Schools 180825002160 145 Allen Co Youth Services Ctr   Alternative Education School No 4.0 04 11 2015   grade_10                         3.0 0.0                       3.0                         3 0                 3
1159640 1159640 IN     school 1803630 235   Fort Wayne Community Schools 180363002174 100 Allen Co Juvenile Center   Regular School No 3.0 07 12 2015   grade_10                         2.0 0.0                       2.0                         2 0                 2
1161777 1161777 IN     school 1803930 2315   Goshen Community Schools 180393000659 1629 Goshen Middle School   Regular School No 4.0 06 10 2015   grade_10                         1.0 0.0                       1.0                         1 0                 1
1168938 1168938 IN     school 1810290 7205   South Bend Community Sch Corp 181029002574 7617 Studebaker Center   Regular School No 4.0 PK 12 2015   grade_10                         1.0 0.0                       1.0                         1 0                 1
1170741 1170741 IN     school 1800006 9100   IN Department of Correction 180000601946 732 Logansport Juvenile Cor Fac   Regular School No 3.0 07 12 2015   grade_10                         17.0 0.0                       17.0                         17 0                 17
1170748 1170748 IN     school 1800006 9100   IN Department of Correction 180000601996 4846 Camp Summit Juv Facility   Regular School No 3.0 09 12 2015   grade_10                         25.0 0.0                       25.0                         25 0                 25
1170754 1170754 IN     school 1800006 9100   IN Department of Correction 180000601935 5055 Pendleton Juv Correctional Fac   Regular School No 3.0 08 12 2015   grade_10                         40.0 0.0                       40.0                         40 0                 40
1171258 1171258 IN     school 1800131 9760   Smith Academy for Excellence 180013102539 242 Smith Academy for Excellence   Regular School Yes 4.0 03 11 2015   grade_10                         11.0 0.0                       11.0                         11 0                 11
1281033 1281033 IN     school 1803630 235   Fort Wayne Community Schools 180363002174 100 Allen Co Juvenile Center   Regular School No 3.0 08 12 2016   grade_10                         1.0 0.0                       1.0                         1 0                 1
1287633 1287633 IN     school   5375   M S D Wayne Township   5271 Sanders School             2016   grade_10                         9.0 0.0                       9.0                         9 0                 9
1292123 1292123 IN     school 1800006 9100   IN Department of Correction 180000601946 732 Logansport Juvenile Cor Facility   Regular School No 3.0 08 12 2016   grade_10                         25.0 0.0                       25.0                         25 0                 25
1292130 1292130 IN     school 1800006 9100   IN Department of Correction 180000601996 4846 Camp Summit Juv Facility   Regular School No 3.0 09 12 2016   grade_10                         27.0 0.0                       27.0                         27 0                 27
1292136 1292136 IN     school 1800006 9100   IN Department of Correction 180000601935 5055 Pendleton Juv Correctional Fac   Regular School No 3.0 07 12 2016   grade_10                         40.0 0.0                       40.0                         40 0                 40
1292625 1292625 IN     school 1800131 9760   Smith Academy for Excellence 180013102539 242 Smith Academy for Excellence   Regular School Yes 4.0 02 12 2016   grade_10                         7.0 0.0                       7.0                         7 0                 7
1292709 1292709 IN     school 1800159 9840   Excel Center - Univ Heights 180015902592 5749 Excel Center - Univ Heights   Regular School Yes 3.0 10 12 2016   grade_10                         5.0 0.0                       5.0                         5 0                 5
1294967 1294967 IN     school 1802400 2270   Concord Community Schools 180240000271 1713 Concord Junior High School   Regular School No Other 07 10 2017   grade_10                         1.0 0.0                       1.0                         1 0                 1
1297034 1297034 IN     school 1801050 3695   Brownstown Cnt Com Sch Corp 180105001408 3108 Jackson Co Juvenile Detention Cntr   Alternative School No Other 10 10 2017   grade_10                         1.0 0.0                       1.0                         1 0                 1
1299670 1299670 IN     school   5375   M S D Wayne Township   5271 Sanders School             2017   grade_10                         8.0 0.0                       8.0                         8 0                 8
1304145 1304145 IN     school 1800006 9100   Indiana Department of Corrections 180000601946 732 Logansport Juvenile Correctional   Regular School No High 07 12 2017   grade_10                         32.0 0.0                       32.0                         32 0                 32
1304152 1304152 IN     school 1800006 9100   Indiana Department of Corrections 180000601996 4846 Camp Summit Juvenile Facility   Regular School No High 08 12 2017   grade_10                         19.0 0.0                       19.0                         19 0                 19
1304159 1304159 IN     school 1800006 9100   Indiana Department of Corrections 180000601935 5055 Pendleton Juvenile Correctional   Regular School No High 08 12 2017   grade_10                         47.0 0.0                       47.0                         47 0                 47
1304340 1304340 IN     school 1800166 9440   Christel House DORS West 180016602586 5873 Christel House DORS West   Regular School Yes High 09 12 2017   grade_10                         1.0 0.0                       1.0                         1 0                 1
1304665 1304665 IN     school 1800131 9760   Smith Academy for Excellence 180013102539 242 Smith Academy for Excellence   Regular School Yes Other 04 12 2017   grade_10                         7.0 0.0                       7.0                         7 0                 7
1751719 1751719 IN     school 1803630 235   Fort Wayne Community Schools 180363002174 100 Allen Co Juvenile Center   Regular School No High 08 12 2019   grade_10                         2.0 0.0                       2.0                         2 0                 2
1753617 1753617 IN     school 1806600 2275   Middlebury Community Schools 180660001162 1657 Northridge Middle School   Regular School No Middle 06 10 2019   grade_10                         1.0 0.0                       1.0                         1 0                 1
1760859 1760859 IN     school 1810290 7205   South Bend Community School Corp 181029000898 7632 Juvenile Justice Center   Alternative School No High 07 12 2019   grade_10                         4.0 0.0                       4.0                         4 0                 4
1762776 1762776 IN     school 1800006 9100   Indiana Department of Correction 180000601935 5055 Pendleton Juvenile Correctional   Regular School No High 07 12 2019   grade_10                         61.0 0.0                       61.0                         61 0                 61
1762876 1762876 IN     school 1800138 9335   Excel Center - Lafayette Square 180013802554 5912 Excel Center - Lafayette Square   Regular School Yes High 09 12 2019   grade_10                         1.0 0.0                       1.0                         1 0                 1
1763244 1763244 IN     school 1800131 9760   Smith Academy for Excellence 180013102539 242 Smith Academy for Excellence   Regular School Yes Other 04 12 2019   grade_10                         11.0 0.0                       11.0                         11 0                 11
1789571 1789571 IN     school 1803930 2315   Goshen Community Schools 180393000659 1629 Goshen Middle School   Regular School No Middle 05 12 2018   grade_10                         1.0 0.0                       1.0                         1 0                 1
1790091 1790091 IN     school   2865   Marion Community Schools   2416 Grant County Comm Justice Center             2018   grade_10                         1.0 0.0                       1.0                         1 0                 1
1798497 1798497 IN     school 1800185 9055   Excel Center - Hammond 180018502624 2018 Excel Center - Hammond   Regular School Yes Secondary 10 11 2018   grade_10                         1.0 0.0                       1.0                         1 0                 1
1798501 1798501 IN     school 1800006 9100   Indiana Department of Correction 180000601946 732 Logansport Juvenile Correctional   Regular School No High 07 12 2018   grade_10                         36.0 0.0                       36.0                         36 0                 36
1798509 1798509 IN     school 1800006 9100   Indiana Department of Correction 180000601996 4846 Camp Summit Juvenile Facility   Regular School No High 09 12 2018   grade_10                         16.0 0.0                       16.0                         16 0                 16
1798515 1798515 IN     school 1800006 9100   Indiana Department of Correction 180000601935 5055 Pendleton Juvenile Correctional   Regular School No High 08 12 2018   grade_10                         41.0 0.0                       41.0                         41 0                 41
1798605 1798605 IN     school 1800142 9345   Excel Center - Lafayette 180014202548 8094 Excel Center - Lafayette   Regular School Yes High 10 12 2018   grade_10                         2.0 0.0                       2.0                         2 0                 2
1798990 1798990 IN     school 1800131 9760   Smith Academy for Excellence 180013102539 242 Smith Academy for Excellence   Regular School Yes Other 04 12 2018   grade_10                         9.0 0.0                       9.0                         9 0                 9
1799084 1799084 IN     school 1800163 9855   Excel Center - Noblesville 180016302576 5748 Excel Center - Noblesville   Regular School Yes High 10 12 2018   grade_10                         2.0 0.0                       2.0                         2 0                 2
1799302 1799302 IN     school 1800175 9995   Excel Center - Shelbyville 180017502606 1117 Excel Center - Shelbyville   Regular School Yes High 10 12 2018   grade_10                         1.0 0.0                       1.0                         1 0                 1
1907160 1907160 IN     school 1803630 235   Fort Wayne Community Schools 180363002174 100 Allen Co Juvenile Center   Regular School No Secondary 08 11 2020   grade_10                         1.0 0.0                       1.0                         1 0                 1
1908192 1908192 IN     school 1803940 1010   Greater Clark County Schools 180394000832 886 Old Corden Porter School   Special Education School No High 06 12 2020   grade_10                         11.0 0.0                       11.0                         11 0                 11
1909787 1909787 IN     school   2865   Marion Community Schools   2416 Grant County Comm Justice Center             2020   grade_10                         1.0 0.0                       1.0                         1 0                 1
1915639 1915639 IN     school 1803990 6755   Greencastle Community School Corp 180399000689 7093 Greencastle Middle School   Regular School No Middle 06 10 2020   grade_10                         1.0 0.0                       1.0                         1 0                 1
1916154 1916154 IN     school 1810290 7205   South Bend Community School Corp 181029001878 7534 Rise Up Academy at Eggleston   Regular School No High 10 12 2020   grade_10                         2.0 0.0                       2.0                         2 0                 2
1916267 1916267 IN     school 1810290 7205   South Bend Community School Corp 181029000898 7632 Juvenile Justice Center   Alternative School No Secondary 06 11 2020   grade_10                         3.0 0.0                       3.0                         3 0                 3
1918227 1918227 IN     school 1800006 9100   Indiana Department of Correction 180000601946 732 Logansport Juvenile Correctional   Regular School No High 08 12 2020   grade_10                         30.0 0.0                       30.0                         30 0                 30
1918234 1918234 IN     school 1800006 9100   Indiana Department of Correction 180000601935 5055 Pendleton Juvenile Correctional   Regular School No High 08 12 2020   grade_10                         74.0 0.0                       74.0                         74 0                 74
1918279 1918279 IN     school 1800200 9190   Excel Center - Gary 180020002652 1024 Excel Center - Gary   Regular School Yes High 10 12 2020   grade_10                         1.0 0.0                       1.0                         1 0                 1
1918706 1918706 IN     school 1800131 9760   Smith Academy for Excellence 180013102539 242 Smith Academy for Excellence   Regular School Yes Other 04 12 2020   grade_10                         14.0 0.0                       14.0                         14 0                 14
1918763 1918763 IN     school 1800163 9855   Excel Center - Noblesville 180016302576 5748 Excel Center - Noblesville   Regular School Yes High 10 12 2020   grade_10                         1.0 0.0                       1.0                         1 0                 1
1919126 1919126 IN     school 1803630 235   Fort Wayne Community Schools 180363002174 100 Allen Co Juvenile Center   Regular School No Secondary 06 11 2021   grade_10                         1.0 0.0                       1.0                         1 0                 1
1922622 1922622 IN     school 1808970 3330   Plainfield Community School Corp 180897002694 3331 Pride Academy   Regular School No Secondary 05 11 2021   grade_10                         1.0 0.0                       1.0                         1 0                 1
1924843 1924843 IN     school 1800120 5265   Alexandria Community School Corp 180012000009 5069 Alexandria Monroe Academy and Cent   Regular School No High 10 12 2021   grade_10                         1.0 0.0                       1.0                         1 0                 1
1927240 1927240 IN     school   6550   Portage Township Schools   6811 Porter County Education Services             2021   grade_10                         3.0 0.0                       3.0                         3 0                 3
1927324 1927324 IN     school   6560   Valparaiso Community Schools   6811 Porter County Education Services             2021   grade_10                         1.0 0.0                       1.0                         1 0                 1
1928089 1928089 IN     school 1810290 7205   South Bend Community School Corp 181029001878 7534 Rise Up Academy at Eggleston   Regular School No High 09 12 2021   grade_10                         2.0 0.0                       2.0                         2 0                 2
1930061 1930061 IN     school 1800214 8960   Purdue Polytechnic High School Sou 180021402689 9963 Purdue Polytechnic High School Sou   Regular School Yes Secondary 09 11 2021   grade_10                         5.0 0.0                       5.0                         5 0                 5
1930082 1930082 IN     school 1800222 9000   Phalen Virtual Leadership Academy 180022202707 9992 Phalen Virtual Leadership Academy   Regular School Yes Other 02 12 2021   grade_10                         1.0 0.0                       1.0                         1 0                 1
1930127 1930127 IN     school 1800182 9050   Excel Center - Clarksville 180018202619 2006 Excel Center - Clarksville   Regular School Yes High 10 12 2021   grade_10                         1.0 0.0                       1.0                         1 0                 1
1930181 1930181 IN     school 1800006 9100   Indiana Department of Correction 180000601946 732 Logansport Juvenile Correctional   Regular School No High 08 12 2021   grade_10                         21.0 0.0                       21.0                         21 0                 21
1930188 1930188 IN     school 1800006 9100   Indiana Department of Correction 180000601935 5055 Pendleton Juvenile Correctional   Regular School No High 08 12 2021   grade_10                         34.0 0.0                       34.0                         34 0                 34
1930244 1930244 IN     school 1800197 9160   Excel Center - Muncie 180019702662 1016 Excel Center - Muncie   Regular School Yes High 10 12 2021   grade_10                         1.0 0.0                       1.0                         1 0                 1
1930694 1930694 IN     school 1800131 9760   Smith Academy for Excellence 180013102539 242 Smith Academy for Excellence   Regular School Yes Other 04 12 2021   grade_10                         13.0 0.0                       13.0                         13 0                 13
1930951 1930951 IN     school 1800175 9995   Excel Center - Shelbyville 180017502606 1117 Excel Center - Shelbyville   Regular School Yes High 10 12 2021   grade_10                         1.0 0.0                       1.0                         1 0                 1
1160677 1160677 IN     school 1803940 1010   Greater Clark County Schools 180394000832 886 Old Corden Porter School   Special Education School No 4.0 04 12 2015   grade_10                         11.0 1.0                       12.0                         11 1                 12
1162673 1162673 IN     school 1807650 3070   Noblesville Schools 180765002369 2514 MOSAICS School   Special Education School No 3.0 07 12 2015   grade_10                         2.0 1.0                       3.0                         2 1                 3
1164353 1164353 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_10                         1.0 1.0                       2.0                         1 1                 2
1168949 1168949 IN     school 1810290 7205   South Bend Community Sch Corp 181029000898 7632 Juvenile Justice Center   Alternative Education School No 3.0 07 12 2015   grade_10                         6.0 1.0                       7.0                         6 1                 7
1281025 1281025 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_10                         1.0 1.0                       2.0                         1 1                 2
1282079 1282079 IN     school 1803940 1010   Greater Clark County Schools 180394000832 886 Old Corden Porter School   Special Education School No 4.0 05 12 2016   grade_10                         6.0 1.0                       7.0                         6 1                 7
1290334 1290334 IN     school 1810290 7205   South Bend Community Sch Corp 181029000898 7632 Juvenile Justice Center   Alternative Education School No 3.0 07 12 2016   grade_10                         7.0 1.0                       8.0                         7 1                 8
1292150 1292150 IN     school 1800134 9305   Excel Center - Richmond 180013402549 9012 Excel Center - Richmond   Regular School Yes 3.0 10 12 2016   grade_10                         2.0 1.0                       3.0                         2 1                 3
1295011 1295011 IN     school 1806600 2275   Middlebury Community Schools 180660001162 1657 Northridge Middle School   Regular School No Other 05 10 2017   grade_10                         0.0 1.0                       1.0                         0 1                 1
1302361 1302361 IN     school 1810290 7205   South Bend Community School Corp 181029000898 7632 Juvenile Justice Center   Alternative School No High 07 12 2017   grade_10                         9.0 1.0                       10.0                         9 1                 10
1302506 1302506 IN     school 1810140 7365   Shelbyville Central Schools 181014002496 7671 Especially Kidz Health & Rehab Cnt   Regular School No Other KG 12 2017   grade_10                         1.0 1.0                       2.0                         1 1                 2
1304516 1304516 IN     school 1800041 9625   IN Acad for Sci Math & Humanities 180004102348 1443 IN Acad for Sci Math & Humanities   Regular School No High 10 12 2017   grade_10                         0.0 1.0                       1.0                         0 1                 1
1752756 1752756 IN     school 1803940 1010   Greater Clark County Schools 180394000832 886 Old Corden Porter School   Special Education School No High 06 12 2019   grade_10                         6.0 1.0                       7.0                         6 1                 7
1753832 1753832 IN     school 1803930 2315   Goshen Community Schools 180393000659 1629 Goshen Middle School   Regular School No High 05 12 2019   grade_10                         0.0 1.0                       1.0                         0 1                 1
1762718 1762718 IN     school 1800182 9050   Excel Center - Clarksville 180018202619 2006 Excel Center - Clarksville   Regular School Yes High 10 12 2019   grade_10                         1.0 1.0                       2.0                         1 1                 2
1762768 1762768 IN     school 1800006 9100   Indiana Department of Correction 180000601946 732 Logansport Juvenile Correctional   Regular School No High 07 12 2019   grade_10                         33.0 1.0                       34.0                         33 1                 34
1763514 1763514 IN     school 1800176 9985   Seven Oaks Classical School 180017602603 1114 Seven Oaks Classical School   Regular School Yes Other KG 10 2019   grade_10                         11.0 1.0                       12.0                         11 1                 12
1763534 1763534 IN     school 1800175 9995   Excel Center - Shelbyville 180017502606 1117 Excel Center - Shelbyville   Regular School Yes High 10 12 2019   grade_10                         0.0 1.0                       1.0                         0 1                 1
1787460 1787460 IN     school 1808250 225   Northwest Allen County Schools 180825002160 145 Allen Co Youth Services Center   Alternative School No Secondary 08 11 2018   grade_10                         2.0 1.0                       3.0                         2 1                 3
1793998 1793998 IN     school   5375   M S D Wayne Township   5271 Sanders School             2018   grade_10                         12.0 1.0                       13.0                         12 1                 13
1798601 1798601 IN     school 1800138 9335   Excel Center - Lafayette Square 180013802554 5912 Excel Center - Lafayette Square   Regular School Yes High 10 12 2018   grade_10                         1.0 1.0                       2.0                         1 1                 2
1798617 1798617 IN     school 1800135 9355   Excel Center - Kokomo 180013502553 2976 Excel Center - Kokomo   Regular School Yes High 10 12 2018   grade_10                         0.0 1.0                       1.0                         0 1                 1
1798986 1798986 IN     school 1800116 9750   Excel Center - Anderson 180011602533 4904 Excel Center - Anderson   Regular School Yes High 10 12 2018   grade_10                         1.0 1.0                       2.0                         1 1                 2
1799210 1799210 IN     school 1800136 9930   Nexus Academy of Indianapolis 180013602552 5302 Nexus Academy of Indianapolis   Regular School Yes High 09 12 2018   grade_10                         4.0 1.0                       5.0                         4 1                 5
1913636 1913636 IN     school   5375   M S D Wayne Township   5271 Sanders School             2020   grade_10                         4.0 1.0                       5.0                         4 1                 5
1917879 1917879 IN     school 1809510 8385   Richmond Community Schools 180951000366 9056 Community Youth Services   Special Education School No Other KG 12 2020   grade_10                         6.0 1.0                       7.0                         6 1                 7
1918173 1918173 IN     school 1800182 9050   Excel Center - Clarksville 180018202619 2006 Excel Center - Clarksville   Regular School Yes High 10 12 2020   grade_10                         1.0 1.0                       2.0                         1 1                 2
1918339 1918339 IN     school 1800138 9335   Excel Center - Lafayette Square 180013802554 5912 Excel Center - Lafayette Square   Regular School Yes High 10 12 2020   grade_10                         0.0 1.0                       1.0                         0 1                 1
1918831 1918831 IN     school 1800093 9910   Excel Center for Adult Learners 180009302475 5669 Excel Center For Adult Learners   Regular School Yes High 10 12 2020   grade_10                         2.0 1.0                       3.0                         2 1                 3
1918837 1918837 IN     school 1800108 9920   Damar Charter Academy 180010802503 5191 Damar Charter Academy   Regular School Yes Other 01 12 2020   grade_10                         20.0 1.0                       21.0                         20 1                 21
1928203 1928203 IN     school 1810290 7205   South Bend Community School Corp 181029000898 7632 Juvenile Justice Center   Alternative School No High 08 12 2021   grade_10                         3.0 1.0                       4.0                         3 1                 4
1930608 1930608 IN     school 1800217 9651   The Hope Academy, Inc. 180021702703 5304 The Hope Academy, Inc.   Regular School Yes High 09 12 2021   grade_10                         5.0 1.0                       6.0                         5 1                 6
1166231 1166231 IN     school   5375   M S D Wayne Township   5271 Sanders School             2015   grade_10                         8.0 2.0                       10.0                         8 2                 10
1169092 1169092 IN     school 1810140 7365   Shelbyville Central Schools 181014002496 7671 Especially Kidz Health & Rehab Cnt   Regular School No 4.0 PK 12 2015   grade_10                         5.0 2.0                       7.0                         5 2                 7
1283188 1283188 IN     school 1803930 2315   Goshen Community Schools 180393000659 1629 Goshen Middle School   Regular School No 4.0 06 10 2016   grade_10                         0.0 2.0                       2.0                         0 2                 2
1288161 1288161 IN     school 1804770 5385   Indianapolis Public Schools 180477001434 5631 Key Learning Community High School   Regular School No 3.0 09 12 2016   grade_10                         9.0 2.0                       11.0                         9 2                 11

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