enrollments

Data source: Big Local News · About: Big Local

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

✎ 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
1283017 1283017 IN     school 1812240 2285   Wa-Nee Community Schools 181224001956 1737 North Wood High School   Regular School No 3.0 09 12 2016   grade_10                         118.0 99.0                       217.0                         118 99                 217
1291678 1291678 IN     school 1812390 8130   Warrick County School Corp 181239001975 8789 Boonville High School   Regular School No 3.0 09 12 2016   grade_10                         139.0 99.0                       238.0                         139 99                 238
1301042 1301042 IN     school 1812900 6065   West Noble School Corporation 181290002058 6489 West Noble High School   Regular School No High 09 12 2017   grade_10                         94.0 99.0                       193.0                         94 99                 193
1761596 1761596 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345000456 8237 Benjamin Bosse High School   Regular School No High 09 12 2019   grade_10                         92.0 99.0                       191.0                         92 99                 191
1762796 1762796 IN     school 1800179 9120   Insight School of Indiana 180017902601 2528 Insight School of Indiana   Regular School Yes High 07 12 2019   grade_10                         77.0 99.0                       176.0                         77 99                 176
1796267 1796267 IN     school 1809750 6995   Rush County Schools 180975001596 7285 Rushville Consolidated High School   Regular School No High 09 12 2018   grade_10                         94.0 99.0                       193.0                         94 99                 193
1798286 1798286 IN     school 1808220 8435   Northern Wells Community Schools 180822001410 9087 Norwell High School   Regular School No High 09 12 2018   grade_10                         104.0 99.0                       203.0                         104 99                 203
1917002 1917002 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345000456 8237 Benjamin Bosse High School   Regular School No High 09 12 2020   grade_10                         116.0 99.0                       215.0                         116 99                 215
1920104 1920104 IN     school 1803940 1010   Greater Clark County Schools 180394000663 821 Charlestown Senior High School   Regular School No High 09 12 2021   grade_10                         86.0 99.0                       185.0                         86 99                 185
1923837 1923837 IN     school 1804350 4580   Hanover Community School Corp 180435000753 3785 Hanover Central High School   Regular School No High 09 12 2021   grade_10                         98.0 99.0                       197.0                         98 99                 197
1160941 1160941 IN     school 1812450 1405   Washington Com Schools 181245002006 1125 Washington High School   Regular School No 3.0 09 12 2015   grade_10                         102.0 98.0                       200.0                         102 98                 200
1162164 1162164 IN     school 1810350 2765   South Gibson School Corp 181035001688 2211 Gibson Southern High School   Regular School No 3.0 09 12 2015   grade_10                         56.0 98.0                       154.0                         56 98                 154
1162240 1162240 IN     school 1806870 2855   Mississinewa Community School Corp 180687001189 2333 Mississinewa High School   Regular School No 3.0 09 12 2015   grade_10                         96.0 98.0                       194.0                         96 98                 194
1164086 1164086 IN     school 1812120 4335   Vincennes Community Sch Corp 181212001931 3553 Lincoln High School   Regular School No 3.0 09 12 2015   grade_10                         91.0 98.0                       189.0                         91 98                 189
1166759 1166759 IN     school 1804770 5385   Indianapolis Public Schools 180477001446 5643 George Washington Community HS   Regular School No 3.0 09 12 2015   grade_10                         173.0 98.0                       271.0                         173 98                 271
1292106 1292106 IN     school 1800112 8815   CSUSA Manual 180011200825 5481 Emmerich Manual High School   Regular School No 3.0 09 12 2016   grade_10                         107.0 98.0                       205.0                         107 98                 205
1304128 1304128 IN     school 1800112 8815   CSUSA Manual 180011200825 5481 Emmerich Manual High School   Regular School No High 09 12 2017   grade_10                         88.0 98.0                       186.0                         88 98                 186
1752997 1752997 IN     school 1812450 1405   Washington Community Schools 181245002006 1125 Washington High School   Regular School No High 09 12 2019   grade_10                         105.0 98.0                       203.0                         105 98                 203
1753078 1753078 IN     school 1800240 1600   South Dearborn Community Sch Corp 180024000056 1179 South Dearborn High School   Regular School No High 09 12 2019   grade_10                         117.0 98.0                       215.0                         117 98                 215
1754945 1754945 IN     school 1800690 3180   North Harrison Com School Corp 180069000144 2629 North Harrison High School   Regular School No High 09 12 2019   grade_10                         76.0 98.0                       174.0                         76 98                 174
1789065 1789065 IN     school 1807230 1910   Yorktown Community Schools 180723001217 1389 Yorktown High School   Regular School No High 09 12 2018   grade_10                         99.0 98.0                       197.0                         99 98                 197
1908685 1908685 IN     school 1802660 1875   Delaware Community School Corp 180266000320 1369 Delta High School   Regular School No High 09 12 2020   grade_10                         106.0 98.0                       204.0                         106 98                 204
1909985 1909985 IN     school 1804260 3025   Hamilton Heights School Corp 180426000728 2477 Hamilton Heights High School   Regular School No High 09 12 2020   grade_10                         105.0 98.0                       203.0                         105 98                 203
1928938 1928938 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345000459 8241 Central High School   Regular School No High 09 12 2021   grade_10                         120.0 98.0                       218.0                         120 98                 218
1169290 1169290 IN     school 1811100 7615   M S D Steuben County 181110001797 7893 Angola High School   Regular School No 3.0 09 12 2015   grade_10                         93.0 97.0                       190.0                         93 97                 190
1169676 1169676 IN     school 1803450 7995   Evansville Vanderburgh Sch Corp 180345000456 8237 Benjamin Bosse High School   Regular School No 3.0 09 12 2015   grade_10                         97.0 97.0                       194.0                         97 97                 194
1287674 1287674 IN     school 1812810 5375   M S D Wayne Township 181281002410 5447 Ben Davis University High School   Regular School No 3.0 10 12 2016   grade_10                         58.0 97.0                       155.0                         58 97                 155
1287714 1287714 IN     school 1804770 5385   Indianapolis Public Schools 180477000815 5473 Crispus Attucks Medical Magnet HS   Regular School No 3.0 09 12 2016   grade_10                         74.0 97.0                       171.0                         74 97                 171
1303964 1303964 IN     school 1808220 8435   Northern Wells Community Schools 180822001410 9087 Norwell High School   Regular School No High 09 12 2017   grade_10                         107.0 97.0                       204.0                         107 97                 204
1788882 1788882 IN     school 1804080 1730   Greensburg Community Schools 180408000704 1268 Greensburg Community High School   Regular School No High 09 12 2018   grade_10                         92.0 97.0                       189.0                         92 97                 189
1788993 1788993 IN     school 1802660 1875   Delaware Community School Corp 180266000320 1369 Delta High School   Regular School No High 09 12 2018   grade_10                         120.0 97.0                       217.0                         120 97                 217
1789836 1789836 IN     school 1803700 2475   Franklin County Community Sch Corp 180370002336 2083 Franklin County High   Regular School No High 09 12 2018   grade_10                         101.0 97.0                       198.0                         101 97                 198
1791536 1791536 IN     school 1806120 3995   Madison Consolidated Schools 180612001090 3309 Madison Consolidated High School   Regular School No High 09 12 2018   grade_10                         109.0 97.0                       206.0                         109 97                 206
1792628 1792628 IN     school 1804320 4710   School City of Hammond 180432000736 4415 Hammond High School   Regular School No High 09 12 2018   grade_10                         117.0 97.0                       214.0                         117 97                 214
1908509 1908509 IN     school 1800240 1600   South Dearborn Community Sch Corp 180024000056 1179 South Dearborn High School   Regular School No High 09 12 2020   grade_10                         103.0 97.0                       200.0                         103 97                 200
1908524 1908524 IN     school 1805700 1620   Lawrenceburg Community School Corp 180570001037 1177 Lawrenceburg High School   Regular School No High 08 12 2020   grade_10                         89.0 97.0                       186.0                         89 97                 186
1917922 1917922 IN     school 1808220 8435   Northern Wells Community Schools 180822001410 9087 Norwell High School   Regular School No High 09 12 2020   grade_10                         108.0 97.0                       205.0                         108 97                 205
1921489 1921489 IN     school 1803700 2475   Franklin County Community Sch Corp 180370002336 2083 Franklin County High   Regular School No High 09 12 2021   grade_10                         88.0 97.0                       185.0                         88 97                 185
1168446 1168446 IN     school 1800390 6895   Batesville Community Sch Corp 180039000084 7217 Batesville High School   Regular School No 3.0 09 12 2015   grade_10                         89.0 96.0                       185.0                         89 96                 185
1168538 1168538 IN     school 1809750 6995   Rush County Schools 180975001596 7285 Rushville Consolidated High Sch   Regular School No 3.0 09 12 2015   grade_10                         95.0 96.0                       191.0                         95 96                 191
1289113 1289113 IN     school 1810950 6195   Spencer-Owen Community Schools 181095001791 6613 Owen Valley Community High School   Regular School No 3.0 09 12 2016   grade_10                         117.0 96.0                       213.0                         117 96                 213
1294380 1294380 IN     school 1812450 1405   Washington Community Schools 181245002006 1125 Washington High School   Regular School No High 09 12 2017   grade_10                         107.0 96.0                       203.0                         107 96                 203
1754225 1754225 IN     school 1810350 2765   South Gibson School Corporation 181035001688 2211 Gibson Southern High School   Regular School No High 09 12 2019   grade_10                         93.0 96.0                       189.0                         93 96                 189
1755774 1755774 IN     school 1806120 3995   Madison Consolidated Schools 180612001090 3309 Madison Consolidated High School   Regular School No High 08 12 2019   grade_10                         108.0 96.0                       204.0                         108 96                 204
1756836 1756836 IN     school 1804320 4710   School City of Hammond 180432000736 4415 Hammond High School   Regular School No High 09 12 2019   grade_10                         103.0 96.0                       199.0                         103 96                 199
1760732 1760732 IN     school 1810290 7205   South Bend Community School Corp 181029001684 7517 Washington High School   Regular School No High 09 12 2019   grade_10                         102.0 96.0                       198.0                         102 96                 198
1928256 1928256 IN     school 1810020 7255   Scott County School District 2 181002001612 7641 Scottsburg Senior High School   Regular School No High 09 12 2021   grade_10                         83.0 96.0                       179.0                         83 96                 179
1164828 1164828 IN     school 1804170 4700   Griffith Public Schools 180417000722 4173 Griffith Senior High School   Regular School No 3.0 09 12 2015   grade_10                         105.0 95.0                       200.0                         105 95                 200
1296555 1296555 IN     school 1802550 3325   Danville Community School Corp 180255000304 2741 Danville Community High School   Regular School No High 09 12 2017   grade_10                         110.0 95.0                       205.0                         110 95                 205
1300514 1300514 IN     school 1809480 5705   Richland-Bean Blossom C S C 180948001546 6146 Edgewood High School   Regular School No High 09 12 2017   grade_10                         112.0 95.0                       207.0                         112 95                 207
1762586 1762586 IN     school 1811580 8565   Twin Lakes School Corp 181158001863 9149 Twin Lakes Senior High School   Regular School No High 09 12 2019   grade_10                         93.0 95.0                       188.0                         93 95                 188
1797411 1797411 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345000456 8237 Benjamin Bosse High School   Regular School No High 09 12 2018   grade_10                         100.0 95.0                       195.0                         100 95                 195
1798452 1798452 IN     school 1800112 8815   CSUSA Manual 180011200825 5481 Emmerich Manual High School   Regular School No High 09 12 2018   grade_10                         103.0 95.0                       198.0                         103 95                 198
1909727 1909727 IN     school 1806870 2855   Mississinewa Community School Corp 180687001189 2333 Mississinewa High School   Regular School No High 09 12 2020   grade_10                         106.0 95.0                       201.0                         106 95                 201
1912242 1912242 IN     school 1804170 4700   Griffith Public Schools 180417000722 4173 Griffith Senior High School   Regular School No High 09 12 2020   grade_10                         111.0 95.0                       206.0                         111 95                 206
1914943 1914943 IN     school 1812900 6065   West Noble School Corporation 181290002058 6489 West Noble High School   Regular School No High 09 12 2020   grade_10                         96.0 95.0                       191.0                         96 95                 191
1164872 1164872 IN     school 1804320 4710   School City of Hammond 180432000736 4415 Hammond High School   Regular School No 3.0 09 12 2015   grade_10                         124.0 94.0                       218.0                         124 94                 218
1281748 1281748 IN     school 1800960 670   Brown County School Corporation 180096000169 573 Brown County High School   Regular School No 3.0 09 12 2016   grade_10                         86.0 94.0                       180.0                         86 94                 180
1284518 1284518 IN     school 1802550 3325   Danville Community School Corp 180255000304 2741 Danville Community High School   Regular School No 3.0 09 12 2016   grade_10                         93.0 94.0                       187.0                         93 94                 187
1754300 1754300 IN     school 1806870 2855   Mississinewa Community School Corp 180687001189 2333 Mississinewa High School   Regular School No High 09 12 2019   grade_10                         105.0 94.0                       199.0                         105 94                 199
1755169 1755169 IN     school 1802550 3325   Danville Community School Corp 180255000304 2741 Danville Community High School   Regular School No High 09 12 2019   grade_10                         93.0 94.0                       187.0                         93 94                 187
1758932 1758932 IN     school 1806090 5615   Maconaquah School Corp 180609001078 6032 Maconaquah High School   Regular School No High 09 12 2019   grade_10                         83.0 94.0                       177.0                         83 94                 177
1790702 1790702 IN     school 1810360 3190   South Harrison Com Schools 181036002282 2640 Corydon Central High School   Regular School No High 09 12 2018   grade_10                         103.0 94.0                       197.0                         103 94                 197
1794831 1794831 IN     school 1809480 5705   Richland-Bean Blossom C S C 180948001546 6146 Edgewood High School   Regular School No High 09 12 2018   grade_10                         100.0 94.0                       194.0                         100 94                 194
1798367 1798367 IN     school 1811580 8565   Twin Lakes School Corp 181158001863 9149 Twin Lakes Senior High School   Regular School No High 09 12 2018   grade_10                         107.0 94.0                       201.0                         107 94                 201
1912267 1912267 IN     school 1804320 4710   School City of Hammond 180432000735 4411 George Rogers Clark Md/HS   Regular School No High 06 12 2020   grade_10                         103.0 94.0                       197.0                         103 94                 197
1914664 1914664 IN     school 1802460 5855   Crawfordsville Community Schools 180246000287 6277 Crawfordsville Sr High School   Regular School No High 09 12 2020   grade_10                         90.0 94.0                       184.0                         90 94                 184
1159479 1159479 IN     school 1807680 25   North Adams Community Schools 180768001314 29 Bellmont Senior High School   Regular School No 3.0 09 12 2015   grade_10                         96.0 93.0                       189.0                         96 93                 189
1166273 1166273 IN     school 1812810 5375   M S D Wayne Township 181281002410 5447 Ben Davis University High School   Regular School No 3.0 10 12 2015   grade_10                         47.0 93.0                       140.0                         47 93                 140
1296336 1296336 IN     school 1800690 3180   North Harrison Com School Corp 180069000144 2629 North Harrison High School   Regular School No High 09 12 2017   grade_10                         105.0 93.0                       198.0                         105 93                 198
1302415 1302415 IN     school 1810020 7255   Scott County School District 2 181002001612 7641 Scottsburg Senior High School   Regular School No High 09 12 2017   grade_10                         96.0 93.0                       189.0                         96 93                 189
1754101 1754101 IN     school 1803700 2475   Franklin County Community Sch Corp 180370002336 2083 Franklin County High   Regular School No High 09 12 2019   grade_10                         95.0 93.0                       188.0                         95 93                 188
1754544 1754544 IN     school 1804260 3025   Hamilton Heights School Corp 180426000728 2477 Hamilton Heights High School   Regular School No High 09 12 2019   grade_10                         101.0 93.0                       194.0                         101 93                 194
1792585 1792585 IN     school 1804170 4700   Griffith Public Schools 180417000722 4173 Griffith Senior High School   Regular School No High 09 12 2018   grade_10                         93.0 93.0                       186.0                         93 93                 186
1915043 1915043 IN     school 1810950 6195   Spencer-Owen Community Schools 181095001791 6613 Owen Valley Community High School   Regular School No High 09 12 2020   grade_10                         94.0 93.0                       187.0                         94 93                 187
1916322 1916322 IN     school 1810020 7255   Scott County School District 2 181002001612 7641 Scottsburg Senior High School   Regular School No High 09 12 2020   grade_10                         99.0 93.0                       192.0                         99 93                 192
1924214 1924214 IN     school 1804320 4710   School City of Hammond 180432000735 4411 George Rogers Clark Md/HS   Regular School No High 06 12 2021   grade_10                         88.0 93.0                       181.0                         88 93                 181
1926232 1926232 IN     school 1806090 5615   Maconaquah School Corp 180609001078 6032 Maconaquah High School   Regular School No High 09 12 2021   grade_10                         78.0 93.0                       171.0                         78 93                 171
1926283 1926283 IN     school 1808850 5635   Peru Community Schools 180885001476 6085 Peru High School   Regular School No High 08 12 2021   grade_10                         82.0 93.0                       175.0                         82 93                 175
1926543 1926543 IN     school 1802460 5855   Crawfordsville Community Schools 180246000287 6277 Crawfordsville Sr High School   Regular School No High 09 12 2021   grade_10                         80.0 93.0                       173.0                         80 93                 173
1927795 1927795 IN     school 1809750 6995   Rush County Schools 180975001596 7285 Rushville Consolidated High School   Regular School No High 09 12 2021   grade_10                         102.0 93.0                       195.0                         102 93                 195
1161088 1161088 IN     school 1804080 1730   Greensburg Community Schools 180408000704 1268 Greensburg Community High Sch   Regular School No 3.0 09 12 2015   grade_10                         99.0 92.0                       191.0                         99 92                 191
1164863 1164863 IN     school 1804320 4710   School City of Hammond 180432000734 4413 Donald E Gavit Mdl/High Sch   Regular School No 4.0 06 12 2015   grade_10                         114.0 92.0                       206.0                         114 92                 206
1169577 1169577 IN     school 1812870 7875   West Lafayette Com School Corp 181287002048 8129 West Lafayette Jr/Sr High Sch   Regular School No 3.0 07 12 2015   grade_10                         99.0 92.0                       191.0                         99 92                 191
1301949 1301949 IN     school 1809750 6995   Rush County Schools 180975001596 7285 Rushville Consolidated High School   Regular School No High 09 12 2017   grade_10                         109.0 92.0                       201.0                         109 92                 201
1753661 1753661 IN     school 1812240 2285   Wa-Nee Community Schools 181224001956 1737 North Wood High School   Regular School No High 09 12 2019   grade_10                         122.0 92.0                       214.0                         122 92                 214
1755429 1755429 IN     school 1804470 3490   Western School Corporation 180447000756 2921 Western High School   Regular School No High 08 12 2019   grade_10                         102.0 92.0                       194.0                         102 92                 194
1795457 1795457 IN     school 1810950 6195   Spencer-Owen Community Schools 181095001791 6613 Owen Valley Community High School   Regular School No High 09 12 2018   grade_10                         108.0 92.0                       200.0                         108 92                 200
1910404 1910404 IN     school 1810360 3190   South Harrison Com Schools 181036002282 2640 Corydon Central High School   Regular School No High 09 12 2020   grade_10                         85.0 92.0                       177.0                         85 92                 177
1920658 1920658 IN     school 1802660 1875   Delaware Community School Corp 180266000320 1369 Delta High School   Regular School No High 09 12 2021   grade_10                         111.0 92.0                       203.0                         111 92                 203
1922834 1922834 IN     school 1804470 3490   Western School Corporation 180447000756 2921 Western High School   Regular School No High 08 12 2021   grade_10                         107.0 92.0                       199.0                         107 92                 199
1930690 1930690 IN     school 1800116 9750   Excel Center - Anderson 180011602533 4904 Excel Center - Anderson   Regular School Yes High 10 12 2021   grade_10                         26.0 92.0                       118.0                         26 92                 118
1164384 1164384 IN     school 1804350 4580   Hanover Community School Corp 180435000753 3785 Hanover Central High Sch   Regular School No 3.0 09 12 2015   grade_10                         89.0 91.0                       180.0                         89 91                 180
1294525 1294525 IN     school 1804080 1730   Greensburg Community Schools 180408000704 1268 Greensburg Community High School   Regular School No High 09 12 2017   grade_10                         105.0 91.0                       196.0                         105 91                 196
1753254 1753254 IN     school 1802660 1875   Delaware Community School Corp 180266000320 1369 Delta High School   Regular School No High 09 12 2019   grade_10                         122.0 91.0                       213.0                         122 91                 213
1760459 1760459 IN     school 1809750 6995   Rush County Schools 180975001596 7285 Rushville Consolidated High School   Regular School No High 09 12 2019   grade_10                         97.0 91.0                       188.0                         97 91                 188
1787305 1787305 IN     school 1807680 25   North Adams Community Schools 180768001314 29 Bellmont Senior High School   Regular School No High 09 12 2018   grade_10                         83.0 91.0                       174.0                         83 91                 174
1788832 1788832 IN     school 1805700 1620   Lawrenceburg Community School Corp 180570001037 1177 Lawrenceburg High School   Regular School No High 09 12 2018   grade_10                         79.0 91.0                       170.0                         79 91                 170
1799090 1799090 IN     school 1800081 9865   Hoosier Acad Virtual Charter 180008102458 5290 Hoosier Acad Virtual Charter Sch   Regular School Yes Other KG 12 2018   grade_10                         73.0 91.0                       164.0                         73 91                 164
1909527 1909527 IN     school 1803700 2475   Franklin County Community Sch Corp 180370002336 2083 Franklin County High   Regular School No High 09 12 2020   grade_10                         108.0 91.0                       199.0                         108 91                 199

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