enrollments

Data source: Big Local News · About: Big Local

84,143 rows where state = "IN" sorted by grade

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

year ✖

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
1159473 1159473 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No 3.0 09 12 2015   adult                         1.0 1.0                       2.0                         1 1                 2
1159501 1159501 IN     school 1810260 35   South Adams Schools 181026001642 23 South Adams High School   Regular School No 3.0 09 12 2015   adult                         1.0 0.0                       1.0                         1 0                 1
1160016 1160016 IN     school 1802850 255   East Allen County Schools 180285000353 297 New Haven High School   Regular School No 3.0 09 12 2015   adult                         0.0 2.0                       2.0                         0 2                 2
1160271 1160271 IN     school 1802830 630   Zionsville Community Schools 180283000341 512 Zionsville Community High Sch   Regular School No 3.0 09 12 2015   adult                         7.0 0.0                       7.0                         7 0                 7
1160350 1160350 IN     school 1800960 670   Brown County School Corporation 180096000169 573 Brown County High School   Regular School No 3.0 09 12 2015   adult                         2.0 2.0                       4.0                         2 2                 4
1160414 1160414 IN     school 1808940 775   Pioneer Regional School Corp 180894001491 645 Pioneer Jr-Sr High School   Regular School No 3.0 07 12 2015   adult                         2.0 3.0                       5.0                         2 3                 5
1160488 1160488 IN     school 1809370 940   West Clark Community Schools 180937001531 765 Henryville Jr & Sr High Sch   Regular School No 3.0 07 12 2015   adult                         2.0 0.0                       2.0                         2 0                 2
1160519 1160519 IN     school 1809370 940   West Clark Community Schools 180937001540 813 William W Borden High School   Regular School No 3.0 07 12 2015   adult                         1.0 1.0                       2.0                         1 1                 2
1160540 1160540 IN     school 1801920 1000   Clarksville Com School Corp 180192000249 833 Clarksville Senior High Sch   Regular School No 3.0 09 12 2015   adult                         0.0 2.0                       2.0                         0 2                 2
1160863 1160863 IN     school 1802440 1300   Crawford Co Com School Corp 180244000279 1059 Crawford County Jr-Sr HS   Regular School No 3.0 07 12 2015   adult                         1.0 0.0                       1.0                         1 0                 1
1160940 1160940 IN     school 1812450 1405   Washington Com Schools 181245002006 1125 Washington High School   Regular School No 3.0 09 12 2015   adult                         4.0 1.0                       5.0                         4 1                 5
1160988 1160988 IN     school 1811190 1560   Sunman-Dearborn Com Sch Corp 181119001802 7213 East Central High School   Regular School No 3.0 09 12 2015   adult                         3.0 1.0                       4.0                         3 1                 4
1161021 1161021 IN     school 1800240 1600   South Dearborn Com School Corp 180024000056 1179 South Dearborn High School   Regular School No 3.0 09 12 2015   adult                         8.0 5.0                       13.0                         8 5                 13
1161036 1161036 IN     school 1805700 1620   Lawrenceburg Com School Corp 180570001037 1177 Lawrenceburg High School   Regular School No 3.0 09 12 2015   adult                         1.0 2.0                       3.0                         1 2                 3
1161055 1161055 IN     school 1802610 1655   Decatur County Com Schools 180261000311 1263 South Decatur Jr-Sr High Sch   Regular School No 3.0 07 12 2015   adult                         1.0 1.0                       2.0                         1 1                 2
1161080 1161080 IN     school 1802610 1655   Decatur County Com Schools 180261000309 1267 North Decatur Jr-Sr High Sch   Regular School No 3.0 07 12 2015   adult                         0.0 1.0                       1.0                         0 1                 1
1161263 1161263 IN     school 1807230 1910   Yorktown Community Schools 180723001217 1389 Yorktown High School   Regular School No 3.0 09 12 2015   adult                         2.0 1.0                       3.0                         2 1                 3
1161416 1161416 IN     school 1810640 2100   Southeast Dubois Co Sch Corp 181064001745 1583 Forest Park Jr-Sr High Sch   Regular School No 3.0 07 12 2015   adult                         1.0 2.0                       3.0                         1 2                 3
1161463 1161463 IN     school 1803960 2120   Greater Jasper Con Schs 180396000685 1593 Jasper High School   Regular School No 3.0 09 12 2015   adult                         6.0 1.0                       7.0                         6 1                 7
1161509 1161509 IN     school 1800420 2260   Baugo Community Schools 180042000090 1701 Jimtown High School   Regular School No 3.0 09 12 2015   adult                         0.0 1.0                       1.0                         0 1                 1
1161527 1161527 IN     school 1802400 2270   Concord Community Schools 180240000271 1713 Concord Junior High School   Regular School No 4.0 06 12 2015   adult                         0.0 1.0                       1.0                         0 1                 1
1161533 1161533 IN     school 1802400 2270   Concord Community Schools 180240000269 1715 Concord Community High School   Regular School No 3.0 09 12 2015   adult                         2.0 1.0                       3.0                         2 1                 3
1161617 1161617 IN     school 1812240 2285   Wa-Nee Community Schools 181224001956 1737 North Wood High School   Regular School No 3.0 09 12 2015   adult                         0.0 1.0                       1.0                         0 1                 1
1161679 1161679 IN     school 1803270 2305   Elkhart Community Schools 180327000429 1749 Elkhart Central High School   Regular School No 3.0 09 12 2015   adult                         2.0 2.0                       4.0                         2 2                 4
1161685 1161685 IN     school 1803270 2305   Elkhart Community Schools 180327000430 1750 Elkhart Memorial High School   Regular School No 3.0 09 12 2015   adult                         13.0 15.0                       28.0                         13 15                 28
1161846 1161846 IN     school 1803510 2395   Fayette County School Corp 180351000498 1889 Connersville Sr High School   Regular School No 3.0 09 12 2015   adult                         1.0 0.0                       1.0                         1 0                 1
1162021 1162021 IN     school 1810620 2455   Southeast Fountain School Corp 181062001742 2022 Fountain Central High School   Regular School No 3.0 07 12 2015   adult                         0.0 1.0                       1.0                         0 1                 1
1162067 1162067 IN     school 1809630 2645   Rochester Community Sch Corp 180963001576 2173 Rochester Community High Sch   Regular School No 3.0 09 12 2015   adult                         1.0 2.0                       3.0                         1 2                 3
1162302 1162302 IN     school 1800600 2920   Bloomfield School District 180060000113 2419 Bloomfield Jr-Sr High School   Regular School No 3.0 07 12 2015   adult                         1.0 0.0                       1.0                         1 0                 1
1162327 1162327 IN     school 1805910 2950   Linton-Stockton School Corp 180591001049 2437 Linton-Stockton High School   Regular School No 3.0 09 12 2015   adult                         2.0 3.0                       5.0                         2 3                 5
1162359 1162359 IN     school 1800008 2980   White River Valley Sch Dist 180000802302 2429 White River Valley Jr/Sr High Sch   Regular School No 3.0 07 12 2015   adult                         0.0 2.0                       2.0                         0 2                 2
1162513 1162513 IN     school 1813080 3030   Westfield-Washington Schools 181308002075 2493 Westfield High School   Regular School No 3.0 09 12 2015   adult                         4.0 2.0                       6.0                         4 2                 6
1162763 1162763 IN     school 1810710 3115   Southern Hancock Co Com Sch Corp 181071001761 2565 New Palestine High School   Regular School No 3.0 09 12 2015   adult                         1.0 1.0                       2.0                         1 1                 2
1162978 1162978 IN     school 1808100 3295   North West Hendricks Schools 180810001387 2731 Tri-West Senior High School   Regular School No 3.0 09 12 2015   adult                         2.0 1.0                       3.0                         2 1                 3
1162993 1162993 IN     school 1801020 3305   Brownsburg Community Sch Corp 180102000176 2709 Brownsburg High School   Regular School No 3.0 09 12 2015   adult                         5.0 1.0                       6.0                         5 1                 6
1163079 1163079 IN     school 1800270 3315   Avon Community School Corp 180027000057 2737 Avon High School   Regular School No 3.0 09 12 2015   adult                         7.0 1.0                       8.0                         7 1                 8
1163111 1163111 IN     school 1802550 3325   Danville Community School Corp 180255000304 2741 Danville Community High Sch   Regular School No 3.0 09 12 2015   adult                         2.0 0.0                       2.0                         2 0                 2
1163133 1163133 IN     school 1808970 3330   Plainfield Community Sch Corp 180897001494 2749 Plainfield High School   Regular School No 3.0 09 12 2015   adult                         5.0 1.0                       6.0                         5 1                 6
1163206 1163206 IN     school 1810380 3415   South Henry School Corp 181038001702 2773 Tri Junior-Senior High School   Regular School No 3.0 07 12 2015   adult                         1.0 0.0                       1.0                         1 0                 1
1163312 1163312 IN     school 1811250 3460   Taylor Community School Corp 181125001814 2894 Taylor High School   Regular School No 3.0 09 12 2015   adult                         0.0 1.0                       1.0                         0 1                 1
1163370 1163370 IN     school 1804470 3490   Western School Corp 180447000756 2921 Western High School   Regular School No 4.0 04 12 2015   adult                         4.0 0.0                       4.0                         4 0                 4
1163459 1163459 IN     school 1805370 3500   Kokomo School Corporation 180537000947 3013 Kokomo High School   Regular School No 3.0 09 12 2015   adult                         4.0 1.0                       5.0                         4 1                 5
1163646 1163646 IN     school 1809420 3815   Rensselaer Central School Corp 180942001543 3201 Rensselaer Central High Sch   Regular School No 3.0 09 12 2015   adult                         2.0 0.0                       2.0                         2 0                 2
1163668 1163668 IN     school 1804980 3945   Jay School Corp 180498000914 3239 Jay County High School   Regular School No 3.0 09 12 2015   adult                         6.0 4.0                       10.0                         6 4                 10
1163739 1163739 IN     school 1806120 3995   Madison Consolidated Schools 180612001090 3309 Madison Consolidated High Sch   Regular School No 3.0 09 12 2015   adult                         2.0 1.0                       3.0                         2 1                 3
1163851 1163851 IN     school 1801890 4145   Clark-Pleasant Com School Corp 180189000246 3421 Whiteland Community High Sch   Regular School No 3.0 09 12 2015   adult                         3.0 1.0                       4.0                         3 1                 4
1163991 1163991 IN     school 1804110 4245   Greenwood Community Sch Corp 180411000709 3473 Greenwood Community High Sch   Regular School No 3.0 09 12 2015   adult                         9.0 3.0                       12.0                         9 3                 12
1164351 1164351 IN     school 1808320 4570   Northwest Indiana Spec Ed Coop 180832002208 4287 Eagle Park Community School   Special Education School No 4.0 KG 12 2015   adult                         24.0 14.0                       38.0                         24 14                 38
1164389 1164389 IN     school 1804620 4590   River Forest Community Sch Corp 180462000781 3791 River Forest Jr-Sr High School   Regular School No 4.0 06 12 2015   adult                         1.0 0.0                       1.0                         1 0                 1
1164464 1164464 IN     school 1805450 4615   Lake Central School Corp 180545000984 3833 Lake Central High School   Regular School No 3.0 09 12 2015   adult                         20.0 10.0                       30.0                         20 10                 30
1164552 1164552 IN     school 1805460 4650   Lake Ridge Schools 180546000989 3869 Calumet High School   Regular School No 3.0 09 12 2015   adult                         0.0 1.0                       1.0                         0 1                 1
1164599 1164599 IN     school 1802490 4660   Crown Point Community Sch Corp 180249000293 3901 Crown Point High School   Regular School No 3.0 09 12 2015   adult                         6.0 3.0                       9.0                         6 3                 9
1164634 1164634 IN     school 1802880 4670   School City of East Chicago 180288002272 3924 East Chicago Central High Sch   Regular School No 3.0 09 12 2015   adult                         1.0 0.0                       1.0                         1 0                 1
1164797 1164797 IN     school 1803870 4690   Gary Community School Corp 180387000648 4163 West Side Leadership Academy   Regular School No 3.0 09 12 2015   adult                         2.0 0.0                       2.0                         2 0                 2
1164853 1164853 IN     school 1804320 4710   School City of Hammond 180432000735 4411 George Rogers Clark Md/HS   Regular School No 4.0 06 12 2015   adult                         1.0 2.0                       3.0                         1 2                 3
1164862 1164862 IN     school 1804320 4710   School City of Hammond 180432000734 4413 Donald E Gavit Mdl/High Sch   Regular School No 4.0 06 12 2015   adult                         6.0 2.0                       8.0                         6 2                 8
1164871 1164871 IN     school 1804320 4710   School City of Hammond 180432000736 4415 Hammond High School   Regular School No 3.0 09 12 2015   adult                         5.0 3.0                       8.0                         5 3                 8
1164877 1164877 IN     school 1804320 4710   School City of Hammond 180432000746 4417 Morton Senior High School   Regular School No 3.0 09 12 2015   adult                         1.0 2.0                       3.0                         1 2                 3
1165070 1165070 IN     school 1807350 4740   School Town of Munster 180735001257 4332 Munster High School   Regular School No 3.0 09 12 2015   adult                         4.0 7.0                       11.0                         4 7                 11
1165203 1165203 IN     school 1806570 4925   Michigan City Area Schools 180657001160 4795 Michigan City High Sch   Regular School No 3.0 09 12 2015   adult                         7.0 4.0                       11.0                         7 4                 11
1165414 1165414 IN     school 1807860 5075   North Lawrence Com Schools 180786001337 4911 Bedford-North Lawrence High School   Regular School No 3.0 09 12 2015   adult                         12.0 5.0                       17.0                         12 5                 17
1165608 1165608 IN     school 1802640 5300   M S D Decatur Township 180264000312 5177 Decatur Central High School   Regular School No 3.0 09 12 2015   adult                         1.0 2.0                       3.0                         1 2                 3
1165717 1165717 IN     school 1805670 5330   M S D Lawrence Township 180567001029 5275 Lawrence Central High School   Regular School No 3.0 09 12 2015   adult                         8.0 9.0                       17.0                         8 9                 17
1165723 1165723 IN     school 1805670 5330   M S D Lawrence Township 180567001031 5276 Lawrence North High School   Regular School No 3.0 09 12 2015   adult                         10.0 6.0                       16.0                         10 6                 16
1165816 1165816 IN     school 1808820 5340   Perry Township Schools 180882001464 5307 Perry Meridian High School   Regular School No 3.0 09 12 2015   adult                         1.0 2.0                       3.0                         1 2                 3
1165822 1165822 IN     school 1808820 5340   Perry Township Schools 180882001467 5309 Southport High School   Regular School No 3.0 09 12 2015   adult                         5.0 5.0                       10.0                         5 5                 10
1166296 1166296 IN     school 1804770 5385   Indianapolis Public Schools 180477000801 5469 Arsenal Technical High School   Regular School No 3.0 09 12 2015   adult                         13.0 8.0                       21.0                         13 8                 21
1166307 1166307 IN     school 1804770 5385   Indianapolis Public Schools 180477000804 5477 Broad Ripple Mgnt HS for Prfm Arts   Regular School No 3.0 09 12 2015   adult                         4.0 3.0                       7.0                         4 3                 7
1166313 1166313 IN     school 1804770 5385   Indianapolis Public Schools 180477000878 5483 Northwest Community High School   Regular School No 3.0 09 12 2015   adult                         5.0 3.0                       8.0                         5 3                 8
1166319 1166319 IN     school 1804770 5385   Indianapolis Public Schools 180477002238 5485 Shortridge Law & Public Plcy Mg HS   Regular School No 3.0 09 12 2015   adult                         1.0 3.0                       4.0                         1 3                 4
1166325 1166325 IN     school 1804770 5385   Indianapolis Public Schools 180477000856 5494 John Marshall Community High Sch   Regular School No 3.0 09 12 2015   adult                         6.0 4.0                       10.0                         6 4                 10
1166758 1166758 IN     school 1804770 5385   Indianapolis Public Schools 180477001446 5643 George Washington Community HS   Regular School No 3.0 09 12 2015   adult                         32.0 17.0                       49.0                         32 17                 49
1166808 1166808 IN     school 1800105 5390   Southside Sp Srvs Of Marion Co 180010502502 5320 RISE Learning Center   Regular School No 4.0 KG 12 2015   adult                         13.0 5.0                       18.0                         13 5                 18
1166896 1166896 IN     school 1800900 5480   Bremen Public Schools 180090000168 5941 Bremen Senior High School   Regular School No 3.0 09 12 2015   adult                         1.0 0.0                       1.0                         1 0                 1
1166919 1166919 IN     school 1809060 5485   Plymouth Community School Corp 180906001500 5945 Plymouth High School   Regular School No 3.0 09 12 2015   adult                         2.0 2.0                       4.0                         2 2                 4
1166965 1166965 IN     school 1810170 5520   Shoals Community School Corp 181017001635 5985 Shoals Comm Jr-Sr High Sch   Regular School No 3.0 07 12 2015   adult                         0.0 1.0                       1.0                         0 1                 1
1166993 1166993 IN     school 1806060 5525   Loogootee Community Sch Corp 180606001067 6003 Loogootee High School   Regular School No 3.0 09 12 2015   adult                         0.0 2.0                       2.0                         0 2                 2
1167039 1167039 IN     school 1808340 5625   Oak Hill United School Corp 180834001429 6069 Oak Hill High School   Regular School No 3.0 09 12 2015   adult                         1.0 0.0                       1.0                         1 0                 1
1167053 1167053 IN     school 1808850 5635   Peru Community Schools 180885001476 6085 Peru High School   Regular School No 3.0 09 12 2015   adult                         3.0 0.0                       3.0                         3 0                 3
1167088 1167088 IN     school 1809480 5705   Richland-Bean Blossom C S C 180948001546 6146 Edgewood High School   Regular School No 3.0 09 12 2015   adult                         4.0 2.0                       6.0                         4 2                 6
1167150 1167150 IN     school 1800630 5740   Monroe County Com Sch Corp 180063000120 6166 Bloomington High School South   Regular School No 3.0 09 12 2015   adult                         2.0 4.0                       6.0                         2 4                 6
1167156 1167156 IN     school 1800630 5740   Monroe County Com Sch Corp 180063000119 6168 Bloomington High School North   Regular School No 3.0 09 12 2015   adult                         3.0 1.0                       4.0                         3 1                 4
1167315 1167315 IN     school 1802460 5855   Crawfordsville Com Schools 180246000287 6277 Crawfordsville Sr High School   Regular School No 3.0 09 12 2015   adult                         2.0 1.0                       3.0                         2 1                 3
1167511 1167511 IN     school 1807920 5945   North Newton School Corp 180792001363 6411 North Newton Jr-Sr High Sch   Regular School No 3.0 07 12 2015   adult                         2.0 0.0                       2.0                         2 0                 2
1167543 1167543 IN     school 1801710 6055   Central Noble Com School Corp 180171000230 6453 Central Noble Junior Senior HS   Regular School No 4.0 06 12 2015   adult                         0.0 2.0                       2.0                         0 2                 2
1167614 1167614 IN     school 1812900 6065   West Noble School Corporation 181290002058 6489 West Noble High School   Regular School No 3.0 09 12 2015   adult                         1.0 3.0                       4.0                         1 3                 4
1167744 1167744 IN     school 1810900 6260   Southwest Parke Com Sch Corp 181090002287 6627 Riverton Parke Jr-Sr High School   Regular School No 3.0 07 12 2015   adult                         3.0 0.0                       3.0                         3 0                 3
1167791 1167791 IN     school 1811260 6350   Tell City-Troy Twp School Corp 181126001819 6741 Tell City Jr-Sr High School   Regular School No 3.0 07 12 2015   adult                         0.0 1.0                       1.0                         0 1                 1
1167846 1167846 IN     school 1808900 6445   Pike County School Corp 180890001482 6763 Pike Central High Sch   Regular School No 3.0 09 12 2015   adult                         0.0 1.0                       1.0                         0 1                 1
1167980 1167980 IN     school 1809180 6520   Porter Township School Corp 180918001521 6838 Boone Grove High School   Regular School No 3.0 09 12 2015   adult                         2.0 3.0                       5.0                         2 3                 5
1168018 1168018 IN     school 1809150 6550   Portage Township Schools 180915001514 6853 Portage High School   Regular School No 3.0 09 12 2015   adult                         5.0 3.0                       8.0                         5 3                 8
1168263 1168263 IN     school 1810500 6705   South Putnam Community Schools 181050001726 7071 South Putnam High School   Regular School No 3.0 09 12 2015   adult                         1.0 0.0                       1.0                         1 0                 1
1168288 1168288 IN     school 1807980 6715   North Putnam Community Schools 180798001369 7061 North Putnam Sr High Sch   Regular School No 3.0 09 12 2015   adult                         0.0 1.0                       1.0                         0 1                 1
1168294 1168294 IN     school   6720   Old National Trail Spec Serv Coop   7034 Old Nat'l Trail Sp Srvs             2015   adult                         4.0 3.0                       7.0                         4 3                 7
1168300 1168300 IN     school 1802220 6750   Cloverdale Community Schools 180222000265 7077 Cloverdale High School   Regular School No 3.0 09 12 2015   adult                         1.0 0.0                       1.0                         1 0                 1
1168386 1168386 IN     school 1801770 6825   Randolph Central School Corp 180177000242 7125 Winchester Community High Sch   Regular School No 3.0 09 12 2015   adult                         2.0 2.0                       4.0                         2 2                 4
1168439 1168439 IN     school 1810530 6865   South Ripley Com Sch Corp 181053001729 7182 South Ripley High School   Regular School No 3.0 09 12 2015   adult                         2.0 0.0                       2.0                         2 0                 2
1168445 1168445 IN     school 1800390 6895   Batesville Community Sch Corp 180039000084 7217 Batesville High School   Regular School No 3.0 09 12 2015   adult                         3.0 2.0                       5.0                         3 2                 5
1168479 1168479 IN     school 1806630 6910   Milan Community Schools 180663001168 7205 Milan High School   Regular School No 3.0 09 12 2015   adult                         3.0 1.0                       4.0                         3 1                 4
1168537 1168537 IN     school 1809750 6995   Rush County Schools 180975001596 7285 Rushville Consolidated High Sch   Regular School No 3.0 09 12 2015   adult                         6.0 11.0                       17.0                         6 11                 17

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