enrollments

Data source: Big Local News · About: Big Local

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

✎ 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
1161621 1161621 IN     school 1812240 2285   Wa-Nee Community Schools 181224001956 1737 North Wood High School   Regular School No 3.0 09 12 2015   grade_9                         123.0 99.0                       222.0                         123 99                 222
1292378 1292378 IN     school 1800052 9535   Gary Lighthouse Charter School 180005202155 4130 Gary Lighthouse Charter School   Regular School Yes 4.0 KG 12 2016   grade_9                         74.0 99.0                       173.0                         74 99                 173
1297183 1297183 IN     school 1806120 3995   Madison Consolidated Schools 180612001090 3309 Madison Consolidated High School   Regular School No High 09 12 2017   grade_9                         112.0 99.0                       211.0                         112 99                 211
1753146 1753146 IN     school 1804080 1730   Greensburg Community Schools 180408000704 1268 Greensburg Community High School   Regular School No High 09 12 2019   grade_9                         92.0 99.0                       191.0                         92 99                 191
1761599 1761599 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345000456 8237 Benjamin Bosse High School   Regular School No High 09 12 2019   grade_9                         116.0 99.0                       215.0                         116 99                 215
1788821 1788821 IN     school 1800240 1600   South Dearborn Community Sch Corp 180024000056 1179 South Dearborn High School   Regular School No High 09 12 2018   grade_9                         116.0 99.0                       215.0                         116 99                 215
1792631 1792631 IN     school 1804320 4710   School City of Hammond 180432000736 4415 Hammond High School   Regular School No High 09 12 2018   grade_9                         102.0 99.0                       201.0                         102 99                 201
1915046 1915046 IN     school 1810950 6195   Spencer-Owen Community Schools 181095001791 6613 Owen Valley Community High School   Regular School No High 09 12 2020   grade_9                         106.0 99.0                       205.0                         106 99                 205
1928259 1928259 IN     school 1810020 7255   Scott County School District 2 181002001612 7641 Scottsburg Senior High School   Regular School No High 09 12 2021   grade_9                         103.0 99.0                       202.0                         103 99                 202
1163115 1163115 IN     school 1802550 3325   Danville Community School Corp 180255000304 2741 Danville Community High Sch   Regular School No 3.0 09 12 2015   grade_9                         96.0 98.0                       194.0                         96 98                 194
1171001 1171001 IN     school 1800052 9535   Gary Lighthouse Charter School 180005202155 4130 Gary Lighthouse Charter School   Regular School Yes 4.0 KG 12 2015   grade_9                         88.0 98.0                       186.0                         88 98                 186
1289016 1289016 IN     school 1812900 6065   West Noble School Corporation 181290002058 6489 West Noble High School   Regular School No 3.0 09 12 2016   grade_9                         95.0 98.0                       193.0                         95 98                 193
1289927 1289927 IN     school 1809750 6995   Rush County Schools 180975001596 7285 Rushville Consolidated High School   Regular School No 3.0 09 12 2016   grade_9                         119.0 98.0                       217.0                         119 98                 217
1292935 1292935 IN     school 1807680 25   North Adams Community Schools 180768001314 29 Bellmont Senior High School   Regular School No High 09 12 2017   grade_9                         85.0 98.0                       183.0                         85 98                 183
1754303 1754303 IN     school 1806870 2855   Mississinewa Community School Corp 180687001189 2333 Mississinewa High School   Regular School No High 09 12 2019   grade_9                         112.0 98.0                       210.0                         112 98                 210
1762506 1762506 IN     school 1808220 8435   Northern Wells Community Schools 180822001410 9087 Norwell High School   Regular School No High 09 12 2019   grade_9                         103.0 98.0                       201.0                         103 98                 201
1794068 1794068 IN     school 1804770 5385   Indianapolis Public Schools 180477000799 5465 Arlington High   Regular School No High 09 12 2018   grade_9                         147.0 98.0                       245.0                         147 98                 245
1908125 1908125 IN     school 1803940 1010   Greater Clark County Schools 180394000663 821 Charlestown Senior High School   Regular School No High 09 12 2020   grade_9                         81.0 98.0                       179.0                         81 98                 179
1911872 1911872 IN     school 1804350 4580   Hanover Community School Corp 180435000753 3785 Hanover Central High School   Regular School No High 09 12 2020   grade_9                         95.0 98.0                       193.0                         95 98                 193
1915873 1915873 IN     school 1809750 6995   Rush County Schools 180975001596 7285 Rushville Consolidated High School   Regular School No High 09 12 2020   grade_9                         102.0 98.0                       200.0                         102 98                 200
1920661 1920661 IN     school 1802660 1875   Delaware Community School Corp 180266000320 1369 Delta High School   Regular School No High 09 12 2021   grade_9                         108.0 98.0                       206.0                         108 98                 206
1926310 1926310 IN     school 1809480 5705   Richland-Bean Blossom C S C 180948001546 6146 Edgewood High School   Regular School No High 09 12 2021   grade_9                         104.0 98.0                       202.0                         104 98                 202
1167006 1167006 IN     school 1806090 5615   Maconaquah School Corp 180609001078 6032 Maconaquah High School   Regular School No 3.0 09 12 2015   grade_9                         118.0 97.0                       215.0                         118 97                 215
1167717 1167717 IN     school 1810950 6195   Spencer-Owen Community Schools 181095001791 6613 Owen Valley Community HS   Regular School No 3.0 09 12 2015   grade_9                         124.0 97.0                       221.0                         124 97                 221
1170294 1170294 IN     school 1812390 8130   Warrick County School Corp 181239001975 8789 Boonville High School   Regular School No 3.0 09 12 2015   grade_9                         129.0 97.0                       226.0                         129 97                 226
1288180 1288180 IN     school 1804770 5385   Indianapolis Public Schools 180477001446 5643 George Washington Community HS   Regular School No 3.0 09 12 2016   grade_9                         136.0 97.0                       233.0                         136 97                 233
1295498 1295498 IN     school 1803700 2475   Franklin County Community Sch Corp 180370002336 2083 Franklin County High   Regular School No High 09 12 2017   grade_9                         104.0 97.0                       201.0                         104 97                 201
1296352 1296352 IN     school 1810360 3190   South Harrison Com Schools 181036002282 2640 Corydon Central High School   Regular School No High 09 12 2017   grade_9                         97.0 97.0                       194.0                         97 97                 194
1753081 1753081 IN     school 1800240 1600   South Dearborn Community Sch Corp 180024000056 1179 South Dearborn High School   Regular School No High 09 12 2019   grade_9                         99.0 97.0                       196.0                         99 97                 196
1753096 1753096 IN     school 1805700 1620   Lawrenceburg Community School Corp 180570001037 1177 Lawrenceburg High School   Regular School No High 09 12 2019   grade_9                         85.0 97.0                       182.0                         85 97                 182
1754547 1754547 IN     school 1804260 3025   Hamilton Heights School Corp 180426000728 2477 Hamilton Heights High School   Regular School No High 09 12 2019   grade_9                         104.0 97.0                       201.0                         104 97                 201
1791539 1791539 IN     school 1806120 3995   Madison Consolidated Schools 180612001090 3309 Madison Consolidated High School   Regular School No High 09 12 2018   grade_9                         119.0 97.0                       216.0                         119 97                 216
1798370 1798370 IN     school 1811580 8565   Twin Lakes School Corp 181158001863 9149 Twin Lakes Senior High School   Regular School No High 09 12 2018   grade_9                         94.0 97.0                       191.0                         94 97                 191
1911594 1911594 IN     school 1812120 4335   Vincennes Community School Corp 181212001931 3553 Lincoln High School   Regular School No High 09 12 2020   grade_9                         90.0 97.0                       187.0                         90 97                 187
1922570 1922570 IN     school 1802550 3325   Danville Community School Corp 180255000304 2741 Danville Community High School   Regular School No High 09 12 2021   grade_9                         98.0 97.0                       195.0                         98 97                 195
1282346 1282346 IN     school 1812450 1405   Washington Com Schools 181245002006 1125 Washington High School   Regular School No 3.0 09 12 2016   grade_9                         104.0 96.0                       200.0                         104 96                 200
1303967 1303967 IN     school 1808220 8435   Northern Wells Community Schools 180822001410 9087 Norwell High School   Regular School No High 09 12 2017   grade_9                         105.0 96.0                       201.0                         105 96                 201
1756138 1756138 IN     school 1812120 4335   Vincennes Community School Corp 181212001931 3553 Lincoln High School   Regular School No High 09 12 2019   grade_9                         114.0 96.0                       210.0                         114 96                 210
1909530 1909530 IN     school 1803700 2475   Franklin County Community Sch Corp 180370002336 2083 Franklin County High   Regular School No High 09 12 2020   grade_9                         86.0 96.0                       182.0                         86 96                 182
1911173 1911173 IN     school 1804980 3945   Jay School Corporation 180498000914 3239 Jay County High School   Regular School No High 09 12 2020   grade_9                         125.0 96.0                       221.0                         125 96                 221
1912273 1912273 IN     school 1804320 4710   School City of Hammond 180432000735 4411 George Rogers Clark Md/HS   Regular School No High 06 12 2020   grade_9                         98.0 96.0                       194.0                         98 96                 194
1298267 1298267 IN     school 1804170 4700   Griffith Public Schools 180417000722 4173 Griffith Senior High School   Regular School No High 09 12 2017   grade_9                         99.0 95.0                       194.0                         99 95                 194
1788428 1788428 IN     school 1803940 1010   Greater Clark County Schools 180394000663 821 Charlestown Senior High School   Regular School No High 09 12 2018   grade_9                         88.0 95.0                       183.0                         88 95                 183
1789402 1789402 IN     school 1812240 2285   Wa-Nee Community Schools 181224001956 1737 North Wood High School   Regular School No High 09 12 2018   grade_9                         121.0 95.0                       216.0                         121 95                 216
1790038 1790038 IN     school 1806870 2855   Mississinewa Community School Corp 180687001189 2333 Mississinewa High School   Regular School No High 09 12 2018   grade_9                         109.0 95.0                       204.0                         109 95                 204
1914409 1914409 IN     school 1808850 5635   Peru Community Schools 180885001476 6085 Peru High School   Regular School No High 08 12 2020   grade_9                         72.0 95.0                       167.0                         72 95                 167
1914667 1914667 IN     school 1802460 5855   Crawfordsville Community Schools 180246000287 6277 Crawfordsville Sr High School   Regular School No High 09 12 2020   grade_9                         80.0 95.0                       175.0                         80 95                 175
1924229 1924229 IN     school 1804320 4710   School City of Hammond 180432000734 4413 Donald E Gavit Middle/High School   Regular School No High 06 12 2021   grade_9                         112.0 95.0                       207.0                         112 95                 207
1927407 1927407 IN     school 1807290 6590   MSD Mount Vernon 180729001226 6949 Mount Vernon High School   Regular School No High 09 12 2021   grade_9                         83.0 95.0                       178.0                         83 95                 178
1928839 1928839 IN     school 1812870 7875   West Lafayette Com School Corp 181287002048 8129 West Lafayette Jr/Sr High School   Regular School No High 07 12 2021   grade_9                         106.0 95.0                       201.0                         106 95                 201
1164801 1164801 IN     school 1803870 4690   Gary Community School Corp 180387000648 4163 West Side Leadership Academy   Regular School No 3.0 09 12 2015   grade_9                         120.0 94.0                       214.0                         120 94                 214
1170555 1170555 IN     school 1808220 8435   Northern Wells Com Schools 180822001410 9087 Norwell High School   Regular School No 3.0 09 12 2015   grade_9                         82.0 94.0                       176.0                         82 94                 176
1294528 1294528 IN     school 1804080 1730   Greensburg Community Schools 180408000704 1268 Greensburg Community High School   Regular School No High 09 12 2017   grade_9                         98.0 94.0                       192.0                         98 94                 192
1301146 1301146 IN     school 1810950 6195   Spencer-Owen Community Schools 181095001791 6613 Owen Valley Community High School   Regular School No High 09 12 2017   grade_9                         102.0 94.0                       196.0                         102 94                 196
1794747 1794747 IN     school 1806090 5615   Maconaquah School Corp 180609001078 6032 Maconaquah High School   Regular School No High 09 12 2018   grade_9                         86.0 94.0                       180.0                         86 94                 180
1796730 1796730 IN     school 1810020 7255   Scott County School District 2 181002001612 7641 Scottsburg Senior High School   Regular School No High 09 12 2018   grade_9                         135.0 94.0                       229.0                         135 94                 229
1798647 1798647 IN     school 1800122 9385   Christel House DORS 180012202538 5532 Christel House DORS   Regular School Yes High 09 12 2018   grade_9                         107.0 94.0                       201.0                         107 94                 201
1923179 1923179 IN     school 1806120 3995   Madison Consolidated Schools 180612001090 3309 Madison Consolidated High School   Regular School No High 09 12 2021   grade_9                         111.0 94.0                       205.0                         111 94                 205
1926823 1926823 IN     school 1812900 6065   West Noble School Corporation 181290002058 6489 West Noble High School   Regular School No High 09 12 2021   grade_9                         73.0 94.0                       167.0                         73 94                 167
1160354 1160354 IN     school 1800960 670   Brown County School Corporation 180096000169 573 Brown County High School   Regular School No 3.0 09 12 2015   grade_9                         90.0 93.0                       183.0                         90 93                 183
1167319 1167319 IN     school 1802460 5855   Crawfordsville Com Schools 180246000287 6277 Crawfordsville Sr High School   Regular School No 3.0 09 12 2015   grade_9                         85.0 93.0                       178.0                         85 93                 178
1288404 1288404 IN     school 1806090 5615   Maconaquah School Corp 180609001078 6032 Maconaquah High School   Regular School No 3.0 09 12 2016   grade_9                         117.0 93.0                       210.0                         117 93                 210
1291069 1291069 IN     school 1803450 7995   Evansville Vanderburgh Sch Corp 180345000456 8237 Benjamin Bosse High School   Regular School No 3.0 09 12 2016   grade_9                         89.0 93.0                       182.0                         89 93                 182
1296774 1296774 IN     school 1802040 3470   Northwestern School Corp 180204000255 2897 Northwestern Senior High School   Regular School No High 09 12 2017   grade_9                         69.0 93.0                       162.0                         69 93                 162
1759250 1759250 IN     school 1802460 5855   Crawfordsville Community Schools 180246000287 6277 Crawfordsville Sr High School   Regular School No High 09 12 2019   grade_9                         89.0 93.0                       182.0                         89 93                 182
1795361 1795361 IN     school 1812900 6065   West Noble School Corporation 181290002058 6489 West Noble High School   Regular School No High 09 12 2018   grade_9                         75.0 93.0                       168.0                         75 93                 168
1908578 1908578 IN     school 1804080 1730   Greensburg Community Schools 180408000704 1268 Greensburg Community High School   Regular School No High 09 12 2020   grade_9                         72.0 93.0                       165.0                         72 93                 165
1161091 1161091 IN     school 1804080 1730   Greensburg Community Schools 180408000704 1268 Greensburg Community High Sch   Regular School No 3.0 09 12 2015   grade_9                         94.0 92.0                       186.0                         94 92                 186
1164860 1164860 IN     school 1804320 4710   School City of Hammond 180432000735 4411 George Rogers Clark Md/HS   Regular School No 4.0 06 12 2015   grade_9                         108.0 92.0                       200.0                         108 92                 200
1166311 1166311 IN     school 1804770 5385   Indianapolis Public Schools 180477000804 5477 Broad Ripple Mgnt HS for Prfm Arts   Regular School No 3.0 09 12 2015   grade_9                         55.0 92.0                       147.0                         55 92                 147
1280872 1280872 IN     school 1807680 25   North Adams Community Schools 180768001314 29 Bellmont Senior High School   Regular School No 3.0 09 12 2016   grade_9                         94.0 92.0                       186.0                         94 92                 186
1291944 1291944 IN     school 1808220 8435   Northern Wells Com Schools 180822001410 9087 Norwell High School   Regular School No 3.0 09 12 2016   grade_9                         111.0 92.0                       203.0                         111 92                 203
1294478 1294478 IN     school 1805700 1620   Lawrenceburg Community School Corp 180570001037 1177 Lawrenceburg High School   Regular School No High 09 12 2017   grade_9                         75.0 92.0                       167.0                         75 92                 167
1295622 1295622 IN     school 1810350 2765   South Gibson School Corporation 181035001688 2211 Gibson Southern High School   Regular School No High 09 12 2017   grade_9                         81.0 92.0                       173.0                         81 92                 173
1300517 1300517 IN     school 1809480 5705   Richland-Bean Blossom C S C 180948001546 6146 Edgewood High School   Regular School No High 09 12 2017   grade_9                         108.0 92.0                       200.0                         108 92                 200
1300747 1300747 IN     school 1802460 5855   Crawfordsville Community Schools 180246000287 6277 Crawfordsville Sr High School   Regular School No High 09 12 2017   grade_9                         84.0 92.0                       176.0                         84 92                 176
1754104 1754104 IN     school 1803700 2475   Franklin County Community Sch Corp 180370002336 2083 Franklin County High   Regular School No High 09 12 2019   grade_9                         108.0 92.0                       200.0                         108 92                 200
1760730 1760730 IN     school 1810290 7205   South Bend Community School Corp 181029001660 7513 Riley High School   Regular School No High 09 12 2019   grade_9                         185.0 92.0                       277.0                         185 92                 277
1792625 1792625 IN     school 1804320 4710   School City of Hammond 180432000734 4413 Donald E Gavit Middle/High School   Regular School No High 06 12 2018   grade_9                         133.0 92.0                       225.0                         133 92                 225
1794087 1794087 IN     school 1804770 5385   Indianapolis Public Schools 180477000804 5477 Broad Ripple Mgnt HS for Prfm Arts   Regular School No High 09 12 2018   grade_9                         95.0 92.0                       187.0                         95 92                 187
1907709 1907709 IN     school 1800480 395   Benton Community School Corp 180048000097 445 Benton Central Jr-Sr High School   Regular School No High 07 12 2020   grade_9                         58.0 92.0                       150.0                         58 92                 150
1910879 1910879 IN     school 1804470 3490   Western School Corporation 180447000756 2921 Western High School   Regular School No High 09 12 2020   grade_9                         110.0 92.0                       202.0                         110 92                 202
1914353 1914353 IN     school 1806090 5615   Maconaquah School Corp 180609001078 6032 Maconaquah High School   Regular School No High 09 12 2020   grade_9                         76.0 92.0                       168.0                         76 92                 168
1918974 1918974 IN     school 1807680 25   North Adams Community Schools 180768001314 29 Bellmont Senior High School   Regular School No High 09 12 2021   grade_9                         68.0 92.0                       160.0                         68 92                 160
1920550 1920550 IN     school 1804080 1730   Greensburg Community Schools 180408000704 1268 Greensburg Community High School   Regular School No High 09 12 2021   grade_9                         90.0 92.0                       182.0                         90 92                 182
1160944 1160944 IN     school 1812450 1405   Washington Com Schools 181245002006 1125 Washington High School   Regular School No 3.0 09 12 2015   grade_9                         92.0 91.0                       183.0                         92 91                 183
1284302 1284302 IN     school 1800690 3180   North Harrison Com School Corp 180069000144 2629 North Harrison High School   Regular School No 3.0 09 12 2016   grade_9                         106.0 91.0                       197.0                         106 91                 197
1285943 1285943 IN     school 1805460 4650   Lake Ridge New Tech Schools 180546000989 3869 Calumet New Tech High School   Regular School No 3.0 09 12 2016   grade_9                         89.0 91.0                       180.0                         89 91                 180
1287741 1287741 IN     school 1804770 5385   Indianapolis Public Schools 180477000856 5494 John Marshall Community High Sch   Regular School No 3.0 09 12 2016   grade_9                         113.0 91.0                       204.0                         113 91                 204
1759536 1759536 IN     school 1812900 6065   West Noble School Corporation 181290002058 6489 West Noble High School   Regular School No High 09 12 2019   grade_9                         95.0 91.0                       186.0                         95 91                 186
1763022 1763022 IN     school 1800052 9535   Gary Lighthouse Charter School 180005202155 4130 Gary Lighthouse Charter School   Regular School Yes Other KG 12 2019   grade_9                         80.0 91.0                       171.0                         80 91                 171
1791174 1791174 IN     school 1804470 3490   Western School Corporation 180447000756 2921 Western High School   Regular School No High 08 12 2018   grade_9                         101.0 91.0                       192.0                         101 91                 192
1799143 1799143 IN     school 1800106 9890   Indiana Virtual School 180010602515 2488 Indiana Virtual School   Regular School Yes High 06 12 2018   grade_9                         47.0 91.0                       138.0                         47 91                 138
1916325 1916325 IN     school 1810020 7255   Scott County School District 2 181002001612 7641 Scottsburg Senior High School   Regular School No High 09 12 2020   grade_9                         88.0 91.0                       179.0                         88 91                 179
1921944 1921944 IN     school 1804260 3025   Hamilton Heights School Corp 180426000728 2477 Hamilton Heights High School   Regular School No High 09 12 2021   grade_9                         113.0 91.0                       204.0                         113 91                 204
1928543 1928543 IN     school 1811100 7615   MSD Steuben County 181110001797 7893 Angola High School   Regular School No High 09 12 2021   grade_9                         122.0 91.0                       213.0                         122 91                 213
1164236 1164236 IN     school 1811370 4445   Tippecanoe Valley School Corp 181137001839 3602 Tippecanoe Valley High School   Regular School No 3.0 09 12 2015   grade_9                         99.0 90.0                       189.0                         99 90                 189
1164831 1164831 IN     school 1804170 4700   Griffith Public Schools 180417000722 4173 Griffith Senior High School   Regular School No 3.0 09 12 2015   grade_9                         106.0 90.0                       196.0                         106 90                 196
1282493 1282493 IN     school 1804080 1730   Greensburg Community Schools 180408000704 1268 Greensburg Community High School   Regular School No 3.0 09 12 2016   grade_9                         110.0 90.0                       200.0                         110 90                 200
1304047 1304047 IN     school 1811580 8565   Twin Lakes School Corp 181158001863 9149 Twin Lakes Senior High School   Regular School No High 09 12 2017   grade_9                         109.0 90.0                       199.0                         109 90                 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]);