enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_9 · 2,924 ✖
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
1159638 1159638 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_9                         0.0 1.0                       1.0                         0 1                 1
1161531 1161531 IN     school 1802400 2270   Concord Community Schools 180240000271 1713 Concord Junior High School   Regular School No 4.0 06 12 2015   grade_9                         0.0 2.0                       2.0                         0 2                 2
1161781 1161781 IN     school 1803930 2315   Goshen Community Schools 180393000659 1629 Goshen Middle School   Regular School No 4.0 06 10 2015   grade_9                         0.0 2.0                       2.0                         0 2                 2
1167064 1167064 IN     school 1808850 5635   Peru Community Schools 180885001477 6089 Peru Junior High School   Regular School No 2.0 04 09 2015   grade_9                         0.0 1.0                       1.0                         0 1                 1
1167229 1167229 IN     school 1800630 5740   Monroe County Com Sch Corp 180063002498 6220 Bloomington Graduation School   Regular School No 3.0 09 12 2015   grade_9                         0.0 3.0                       3.0                         0 3                 3
1170114 1170114 IN     school 1812090 8030   Vigo County School Corp 181209002344 8611 Booker T Washington Alt Sch   Alternative Education School No 3.0 09 12 2015   grade_9                         0.0 1.0                       1.0                         0 1                 1
1170765 1170765 IN     school 1800006 9100   IN Department of Correction 180000601943 5452 Madison Juvenile Corr Fac   Regular School No 3.0 08 12 2015   grade_9                         0.0 25.0                       25.0                         0 25                 25
1282978 1282978 IN     school 1806600 2275   Middlebury Community Schools 180660001162 1657 Northridge Middle School   Regular School No 2.0 05 09 2016   grade_9                         0.0 1.0                       1.0                         0 1                 1
1286021 1286021 IN     school 1802490 4660   Crown Point Community Sch Corp 180249002417 3915 Colonel John Wheeler Middle School   Regular School No 2.0 06 09 2016   grade_9                         0.0 3.0                       3.0                         0 3                 3
1288461 1288461 IN     school 1808850 5635   Peru Community Schools 180885001477 6089 Peru Junior High School   Regular School No 2.0 04 09 2016   grade_9                         0.0 1.0                       1.0                         0 1                 1
1290217 1290217 IN     school 1810290 7205   South Bend Community Sch Corp 181029001878 7534 Rise Up Academy at Eggleston   Regular School No 3.0 09 12 2016   grade_9                         0.0 1.0                       1.0                         0 1                 1
1291501 1291501 IN     school 1812090 8030   Vigo County School Corp 181209002344 8611 Booker T Washington Alt Sch   Alternative Education School No 3.0 09 12 2016   grade_9                         0.0 1.0                       1.0                         0 1                 1
1292147 1292147 IN     school 1800006 9100   IN Department of Correction 180000601943 5452 Madison Juvenile Corr Fac   Regular School No 3.0 08 12 2016   grade_9                         0.0 9.0                       9.0                         0 9                 9
1292827 1292827 IN     school 1800093 9910   Excel Center for Adult Learners 180009302475 5669 Excel Center For Adult Learners   Regular School Yes 3.0 09 12 2016   grade_9                         0.0 2.0                       2.0                         0 2                 2
1293092 1293092 IN     school 1808250 225   Northwest Allen County Schools 180825002160 145 Allen Co Youth Services Center   Alternative School No Other 05 11 2017   grade_9                         0.0 2.0                       2.0                         0 2                 2
1294970 1294970 IN     school 1802400 2270   Concord Community Schools 180240000271 1713 Concord Junior High School   Regular School No Other 07 10 2017   grade_9                         0.0 1.0                       1.0                         0 1                 1
1303524 1303524 IN     school 1812090 8030   Vigo County School Corp 181209002344 8611 Booker T Washington Alt Sch   Alternative School No High 09 12 2017   grade_9                         0.0 4.0                       4.0                         0 4                 4
1304170 1304170 IN     school 1800006 9100   Indiana Department of Corrections 180000601943 5452 Madison Juvenile Correctional   Regular School No High 08 12 2017   grade_9                         0.0 8.0                       8.0                         0 8                 8
1753651 1753651 IN     school 1812240 2285   Wa-Nee Community Schools 181224001958 1669 North Wood Middle School   Regular School No Middle 06 09 2019   grade_9                         0.0 1.0                       1.0                         0 1                 1
1760747 1760747 IN     school 1810290 7205   South Bend Community School Corp 181029001878 7534 Rise Up Academy at Eggleston   Regular School No High 09 12 2019   grade_9                         0.0 1.0                       1.0                         0 1                 1
1761012 1761012 IN     school 1810140 7365   Shelbyville Central Schools 181014002496 7671 Especially Kidz Health & Rehab Cnt   Regular School No Other PK 12 2019   grade_9                         0.0 4.0                       4.0                         0 4                 4
1761083 1761083 IN     school 1808010 7385   North Spencer County Sch Corp 180801001898 7761 Heritage Hills Middle School   Regular School No Middle 07 09 2019   grade_9                         0.0 2.0                       2.0                         0 2                 2
1762787 1762787 IN     school 1800006 9100   Indiana Department of Correction 180000601943 5452 Madison Juvenile Correctional   Regular School No High 08 12 2019   grade_9                         0.0 13.0                       13.0                         0 13                 13
1762879 1762879 IN     school 1800138 9335   Excel Center - Lafayette Square 180013802554 5912 Excel Center - Lafayette Square   Regular School Yes High 09 12 2019   grade_9                         0.0 1.0                       1.0                         0 1                 1
1787463 1787463 IN     school 1808250 225   Northwest Allen County Schools 180825002160 145 Allen Co Youth Services Center   Alternative School No Secondary 08 11 2018   grade_9                         0.0 1.0                       1.0                         0 1                 1
1794030 1794030 IN     school 1812810 5375   M S D Wayne Township 181281002516 5288 Achieve Virtual Education Academy   Regular School No High 09 12 2018   grade_9                         0.0 11.0                       11.0                         0 11                 11
1796898 1796898 IN     school 1808010 7385   North Spencer County Sch Corp 180801001898 7761 Heritage Hills Middle School   Regular School No Middle 06 09 2018   grade_9                         0.0 2.0                       2.0                         0 2                 2
1798524 1798524 IN     school 1800006 9100   Indiana Department of Correction 180000601943 5452 Madison Juvenile Correctional   Regular School No High 09 12 2018   grade_9                         0.0 13.0                       13.0                         0 13                 13
1799072 1799072 IN     school 1800159 9840   Excel Center - University Heights 180015902592 5749 Excel Center - University Heights   Regular School Yes High 09 12 2018   grade_9                         0.0 1.0                       1.0                         0 1                 1
1909051 1909051 IN     school 1806600 2275   Middlebury Community Schools 180660001162 1657 Northridge Middle School   Regular School No Middle 06 09 2020   grade_9                         0.0 1.0                       1.0                         0 1                 1
1910625 1910625 IN     school 1802550 3325   Danville Community School Corp 180255000305 2743 Danville Middle School   Regular School No Other 04 09 2020   grade_9                         0.0 1.0                       1.0                         0 1                 1
1916491 1916491 IN     school 1808010 7385   North Spencer County Sch Corp 180801001898 7761 Heritage Hills Middle School   Regular School No Middle 07 09 2020   grade_9                         0.0 1.0                       1.0                         0 1                 1
1918244 1918244 IN     school 1800006 9100   Indiana Department of Correction 180000601943 5452 LaPorte Juvenile Correctional   Regular School No High 08 12 2020   grade_9                         0.0 7.0                       7.0                         0 7                 7
1921022 1921022 IN     school 1806600 2275   Middlebury Community Schools 180660001162 1657 Northridge Middle School   Regular School No Middle 05 09 2021   grade_9                         0.0 2.0                       2.0                         0 2                 2
1921061 1921061 IN     school 1812240 2285   Wa-Nee Community Schools 181224001958 1669 North Wood Middle School   Regular School No Middle 06 09 2021   grade_9                         0.0 1.0                       1.0                         0 1                 1
1927213 1927213 IN     school   6530   Union Township School Corp   6811 Porter County Education Services             2021   grade_9                         0.0 1.0                       1.0                         0 1                 1
1930198 1930198 IN     school 1800006 9100   Indiana Department of Correction 180000601943 5452 LaPorte Juvenile Correctional   Regular School No High 08 12 2021   grade_9                         0.0 8.0                       8.0                         0 8                 8
1161608 1161608 IN     school 1812240 2285   Wa-Nee Community Schools 181224001958 1669 North Wood Middle School   Regular School No 2.0 06 09 2015   grade_9                         1.0 0.0                       1.0                         1 0                 1
1168954 1168954 IN     school 1810290 7205   South Bend Community Sch Corp 181029000898 7632 Juvenile Justice Center   Alternative Education School No 3.0 07 12 2015   grade_9                         1.0 0.0                       1.0                         1 0                 1
1169102 1169102 IN     school 1810140 7365   Shelbyville Central Schools 181014002496 7671 Especially Kidz Health & Rehab Cnt   Regular School No 4.0 PK 12 2015   grade_9                         1.0 2.0                       3.0                         1 2                 3
1171131 1171131 IN     school 1800059 9655   Hope Academy 180005902386 5292 Hope Academy   Regular School Yes 3.0 09 12 2015   grade_9                         1.0 0.0                       1.0                         1 0                 1
1281031 1281031 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_9                         1.0 0.0                       1.0                         1 0                 1
1283008 1283008 IN     school 1812240 2285   Wa-Nee Community Schools 181224001958 1669 North Wood Middle School   Regular School No 2.0 05 09 2016   grade_9                         1.0 0.0                       1.0                         1 0                 1
1288628 1288628 IN     school 1800630 5740   Monroe County Com Sch Corp 180063002498 6220 Bloomington Graduation School   Regular School No 3.0 09 12 2016   grade_9                         1.0 5.0                       6.0                         1 5                 6
1290338 1290338 IN     school 1810290 7205   South Bend Community Sch Corp 181029000898 7632 Juvenile Justice Center   Alternative Education School No 3.0 07 12 2016   grade_9                         1.0 0.0                       1.0                         1 0                 1
1290486 1290486 IN     school 1810140 7365   Shelbyville Central Schools 181014002496 7671 Especially Kidz Health & Rehab Cnt   Regular School No 4.0 02 12 2016   grade_9                         1.0 1.0                       2.0                         1 1                 2
1293098 1293098 IN     school 1803630 235   Fort Wayne Community Schools 180363002174 100 Allen Co Juvenile Center   Regular School No High 08 12 2017   grade_9                         1.0 0.0                       1.0                         1 0                 1
1295016 1295016 IN     school 1806600 2275   Middlebury Community Schools 180660001162 1657 Northridge Middle School   Regular School No Other 05 10 2017   grade_9                         1.0 2.0                       3.0                         1 2                 3
1304551 1304551 IN     school 1800059 9655   Hope Academy 180005902386 5292 Hope Academy   Regular School Yes High 09 12 2017   grade_9                         1.0 1.0                       2.0                         1 1                 2
1751723 1751723 IN     school 1803630 235   Fort Wayne Community Schools 180363002174 100 Allen Co Juvenile Center   Regular School No High 08 12 2019   grade_9                         1.0 0.0                       1.0                         1 0                 1
1753621 1753621 IN     school 1806600 2275   Middlebury Community Schools 180660001162 1657 Northridge Middle School   Regular School No Middle 06 10 2019   grade_9                         1.0 2.0                       3.0                         1 2                 3
1753839 1753839 IN     school 1803930 2315   Goshen Community Schools 180393000659 1629 Goshen Middle School   Regular School No High 05 12 2019   grade_9                         1.0 1.0                       2.0                         1 1                 2
1755179 1755179 IN     school 1802550 3325   Danville Community School Corp 180255000305 2743 Danville Middle School   Regular School No Other 04 09 2019   grade_9                         1.0 0.0                       1.0                         1 0                 1
1760232 1760232 IN     school 1803990 6755   Greencastle Community School Corp 180399000689 7093 Greencastle Middle School   Regular School No Middle 06 09 2019   grade_9                         1.0 0.0                       1.0                         1 0                 1
1760864 1760864 IN     school 1810290 7205   South Bend Community School Corp 181029000898 7632 Juvenile Justice Center   Alternative School No High 07 12 2019   grade_9                         1.0 2.0                       3.0                         1 2                 3
1762061 1762061 IN     school 1812090 8030   Vigo County School Corp 181209002344 8611 Booker T Washington Alt Sch   Alternative School No High 09 12 2019   grade_9                         1.0 4.0                       5.0                         1 4                 5
1789359 1789359 IN     school 1806600 2275   Middlebury Community Schools 180660001162 1657 Northridge Middle School   Regular School No Other 04 11 2018   grade_9                         1.0 0.0                       1.0                         1 0                 1
1789388 1789388 IN     school 1812240 2285   Wa-Nee Community Schools 181224001958 1669 North Wood Middle School   Regular School No Middle 06 09 2018   grade_9                         1.0 0.0                       1.0                         1 0                 1
1791396 1791396 IN     school 1801050 3695   Brownstown Cnt Com Sch Corp 180105001408 3108 Jackson Co Juvenile Detention Cntr   Alternative School No High 08 12 2018   grade_9                         1.0 1.0                       2.0                         1 1                 2
1796826 1796826 IN     school 1810140 7365   Shelbyville Central Schools 181014002496 7671 Especially Kidz Health & Rehab Cnt   Regular School No Other 02 12 2018   grade_9                         1.0 1.0                       2.0                         1 1                 2
1799213 1799213 IN     school 1800136 9930   Nexus Academy of Indianapolis 180013602552 5302 Nexus Academy of Indianapolis   Regular School Yes High 09 12 2018   grade_9                         1.0 0.0                       1.0                         1 0                 1
1908005 1908005 IN     school 1806030 875   Logansport Community Sch Corp 180603001052 715 Columbia 6th Grade Academy   Regular School No Other 02 09 2020   grade_9                         1.0 3.0                       4.0                         1 3                 4
1909268 1909268 IN     school 1803930 2315   Goshen Community Schools 180393000659 1629 Goshen Middle School   Regular School No Middle 06 09 2020   grade_9                         1.0 0.0                       1.0                         1 0                 1
1911542 1911542 IN     school 1807620 4255   Nineveh-Hensley-Jackson United 180762002686 3414 Indiana Academy Online   Regular School No High 07 12 2020   grade_9                         1.0 3.0                       4.0                         1 3                 4
1915643 1915643 IN     school 1803990 6755   Greencastle Community School Corp 180399000689 7093 Greencastle Middle School   Regular School No Middle 06 10 2020   grade_9                         1.0 0.0                       1.0                         1 0                 1
1918356 1918356 IN     school 1800135 9355   Excel Center - Kokomo 180013502553 2976 Excel Center - Kokomo   Regular School Yes High 09 12 2020   grade_9                         1.0 0.0                       1.0                         1 0                 1
1918624 1918624 IN     school 1800059 9655   Hope Academy 180005902386 5292 Hope Academy   Regular School Yes High 09 12 2020   grade_9                         1.0 1.0                       2.0                         1 1                 2
1919972 1919972 IN     school 1806030 875   Logansport Community Sch Corp 180603001052 715 Columbia 6th Grade Academy   Regular School No Other 03 12 2021   grade_9                         1.0 0.0                       1.0                         1 0                 1
1922627 1922627 IN     school 1808970 3330   Plainfield Community School Corp 180897002694 3331 Pride Academy   Regular School No Secondary 05 11 2021   grade_9                         1.0 0.0                       1.0                         1 0                 1
1927089 1927089 IN     school   6470   Duneland School Corporation   6811 Porter County Education Services             2021   grade_9                         1.0 0.0                       1.0                         1 0                 1
1927331 1927331 IN     school   6560   Valparaiso Community Schools   6811 Porter County Education Services             2021   grade_9                         1.0 0.0                       1.0                         1 0                 1
1928092 1928092 IN     school 1810290 7205   South Bend Community School Corp 181029001878 7534 Rise Up Academy at Eggleston   Regular School No High 09 12 2021   grade_9                         1.0 0.0                       1.0                         1 0                 1
1928353 1928353 IN     school 1810140 7365   Shelbyville Central Schools 181014002496 7671 Especially Kidz Health & Rehab Cnt   Regular School No Other 02 12 2021   grade_9                         1.0 2.0                       3.0                         1 2                 3
1928659 1928659 IN     school 1805400 7855   Lafayette School Corporation 180540002518 8015 Oakland High School   Regular School No High 09 12 2021   grade_9                         1.0 6.0                       7.0                         1 6                 7
1930092 1930092 IN     school 1800222 9000   Phalen Virtual Leadership Academy 180022202707 9992 Phalen Virtual Leadership Academy   Regular School Yes Other 02 12 2021   grade_9                         1.0 2.0                       3.0                         1 2                 3
1930611 1930611 IN     school 1800217 9651   The Hope Academy, Inc. 180021702703 5304 The Hope Academy, Inc.   Regular School Yes High 09 12 2021   grade_9                         1.0 2.0                       3.0                         1 2                 3
1168693 1168693 IN     school 1806840 7200   School City of Mishawaka 180684000531 7467 Joint Service Campus Program   Special Education School No 4.0 03 12 2015   grade_9                         10.0 7.0                       17.0                         10 7                 17
1170175 1170175 IN     school 1812180 8050   M S D Wabash County Schools 181218001951 8673 White's Jr-Sr High School   Regular School No 3.0 07 12 2015   grade_9                         10.0 4.0                       14.0                         10 4                 14
1170519 1170519 IN     school 1809510 8385   Richmond Community Schools 180951000366 9056 Community Youth Services   Special Education School No 4.0 KG 12 2015   grade_9                         10.0 3.0                       13.0                         10 3                 13
1284940 1284940 IN     school 1801230 3640   Medora Community School Corp 180123000201 3093 Medora Jr & Sr High School   Regular School No 4.0 06 12 2016   grade_9                         10.0 7.0                       17.0                         10 7                 17
1289747 1289747 IN     school 1811730 6795   Union School Corporation 181173001875 7119 Union Junior & High School   Regular School No 3.0 07 12 2016   grade_9                         10.0 6.0                       16.0                         10 6                 16
1292572 1292572 IN     school 1800167 9710   Carpe Diem - Northwest 180016702579 5977 Carpe Diem - Northwest   Regular School Yes 4.0 06 10 2016   grade_9                         10.0 5.0                       15.0                         10 5                 15
1303584 1303584 IN     school 1812180 8050   M S D Wabash County Schools 181218001951 8673 White's Jr-Sr High School   Regular School No Other 06 12 2017   grade_9                         10.0 5.0                       15.0                         10 5                 15
1304673 1304673 IN     school 1800131 9760   Smith Academy for Excellence 180013102539 242 Smith Academy for Excellence   Regular School Yes Other 04 12 2017   grade_9                         10.0 0.0                       10.0                         10 0                 10
1758218 1758218 IN     school   5375   M S D Wayne Township   5271 Sanders School             2019   grade_9                         10.0 0.0                       10.0                         10 0                 10
1760959 1760959 IN     school 1803210 7285   Shelby Eastern Schools 180321000420 7665 Waldron Jr-Sr High School   Regular School No High 06 12 2019   grade_9                         10.0 20.0                       30.0                         10 20                 30
1794008 1794008 IN     school   5375   M S D Wayne Township   5271 Sanders School             2018   grade_9                         10.0 1.0                       11.0                         10 1                 11
1912565 1912565 IN     school 1800107 4915   Tri-Township Cons School Corp 180010702511 4692 LaCrosse School   Regular School No High 09 12 2020   grade_9                         10.0 15.0                       25.0                         10 15                 25
1912925 1912925 IN     school 1800150 5275   Anderson Community School Corp 180015002623 4906 COMPASS Alternative School   Alternative School No Secondary 07 10 2020   grade_9                         10.0 5.0                       15.0                         10 5                 15
1918114 1918114 IN     school 1800205 8690   Dynamic Minds Academy 180020502673 8692 Dynamic Minds Academy   Regular School Yes Other KG 12 2020   grade_9                         10.0 2.0                       12.0                         10 2                 12
1918639 1918639 IN     school 1800064 9670   Indianapolis Metropolitan High Sch 180006402408 5664 Indianapolis Metropolitan High Sch   Regular School Yes High 09 12 2020   grade_9                         10.0 28.0                       38.0                         10 28                 38
1920826 1920826 IN     school 1807320 1970   Muncie Community Schools 180732001232 1524 Youth Opportunity Center   Alternative School No High 05 12 2021   grade_9                         10.0 6.0                       16.0                         10 6                 16
1922992 1922992 IN     school 1801230 3640   Medora Community School Corp 180123000201 3093 Medora Jr & Sr High School   Regular School No High 06 12 2021   grade_9                         10.0 14.0                       24.0                         10 14                 24
1925617 1925617 IN     school 1804770 5385   Indianapolis Public Schools 180477002651 108 Impact Academy   Regular School No Other 03 12 2021   grade_9                         10.0 18.0                       28.0                         10 18                 28
1162167 1162167 IN     school 1810350 2765   South Gibson School Corp 181035001688 2211 Gibson Southern High School   Regular School No 3.0 09 12 2015   grade_9                         100.0 87.0                       187.0                         100 87                 187
1162907 1162907 IN     school 1810360 3190   South Harrison Com Schools 181036002282 2640 Corydon Central High School   Regular School No 3.0 09 12 2015   grade_9                         100.0 88.0                       188.0                         100 88                 188
1168449 1168449 IN     school 1800390 6895   Batesville Community Sch Corp 180039000084 7217 Batesville High School   Regular School No 3.0 09 12 2015   grade_9                         100.0 88.0                       188.0                         100 88                 188
1288718 1288718 IN     school 1802460 5855   Crawfordsville Com Schools 180246000287 6277 Crawfordsville Sr High School   Regular School No 3.0 09 12 2016   grade_9                         100.0 83.0                       183.0                         100 83                 183
1298236 1298236 IN     school 1803870 4690   Gary Community School Corp 180387000648 4163 West Side Leadership Academy   Regular School No High 09 12 2017   grade_9                         100.0 88.0                       188.0                         100 88                 188
1760070 1760070 IN     school 1807290 6590   M S D Mount Vernon 180729001226 6949 Mount Vernon High School   Regular School No High 09 12 2019   grade_9                         100.0 60.0                       160.0                         100 60                 160

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