enrollments

Data source: Big Local News · About: Big Local

416 rows where grade = "grade_12", state = "IN" and year = 2016 sorted by total

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2016 · 416 ✖

grade ✖

  • grade_12 · 416 ✖
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
1281035 1281035 IN     school 1803630 235   Fort Wayne Community Schools 180363002174 100 Allen Co Juvenile Center   Regular School No 3.0 08 12 2016   grade_12                         1.0 0.0                       1.0                         1 0                 1
1291898 1291898 IN     school 1809510 8385   Richmond Community Schools 180951000366 9056 Community Youth Services   Special Education School No 4.0 KG 12 2016   grade_12                         9.0 1.0                       10.0                         9 1                 10
1292233 1292233 IN     school 1800135 9355   Excel Center - Kokomo 180013502553 2976 Excel Center - Kokomo   Regular School Yes 3.0 10 12 2016   grade_12                         4.0 6.0                       10.0                         4 6                 10
1286989 1286989 IN     school 1803300 5280   Elwood Community School Corp 180330000449 5149 Elwood Jr-Sr High School   Regular School No 3.0 07 12 2016   grade_12                         58.0 42.0                       100.0                         58 42                 100
1289625 1289625 IN     school 1807110 6620   Eastern Pulaski Com Sch Corp 180711001205 6997 Winamac Community High School   Regular School No 3.0 09 12 2016   grade_12                         47.0 53.0                       100.0                         47 53                 100
1282268 1282268 IN     school 1802440 1300   Crawford Co Com School Corp 180244000279 1059 Crawford County Jr-Sr HS   Regular School No 3.0 07 12 2016   grade_12                         55.0 46.0                       101.0                         55 46                 101
1291572 1291572 IN     school 1812150 8060   Wabash City Schools 181215001940 8693 Wabash High School   Regular School No 3.0 09 12 2016   grade_12                         58.0 43.0                       101.0                         58 43                 101
1281938 1281938 IN     school 1801920 1000   Clarksville Com School Corp 180192000249 833 Clarksville Senior High School   Regular School No 3.0 09 12 2016   grade_12                         43.0 59.0                       102.0                         43 59                 102
1284721 1284721 IN     school 1811250 3460   Taylor Community School Corp 181125001814 2894 Taylor High School   Regular School No 3.0 09 12 2016   grade_12                         66.0 36.0                       102.0                         66 36                 102
1285699 1285699 IN     school 1813110 4525   Westview School Corporation 181311002079 3697 Westview Jr-Sr High School   Regular School No 4.0 06 12 2016   grade_12                         50.0 52.0                       102.0                         50 52                 102
1287722 1287722 IN     school 1804770 5385   Indianapolis Public Schools 180477000804 5477 Broad Ripple Mgnt HS for Prfm Arts   Regular School No 3.0 09 12 2016   grade_12                         46.0 56.0                       102.0                         46 56                 102
1292318 1292318 IN     school 1800025 9460   Thea Bowman Leadership Academy 180002501807 4022 Thea Bowman Leadership Academy   Regular School Yes 4.0 KG 12 2016   grade_12                         51.0 51.0                       102.0                         51 51                 102
1287663 1287663 IN     school 1812810 5375   M S D Wayne Township 181281002516 5288 Achieve Virtual Education Academy   Regular School No 3.0 09 12 2016   grade_12                         36.0 67.0                       103.0                         36 67                 103
1287676 1287676 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_12                         43.0 60.0                       103.0                         43 60                 103
1287716 1287716 IN     school 1804770 5385   Indianapolis Public Schools 180477000815 5473 Crispus Attucks Medical Magnet HS   Regular School No 3.0 09 12 2016   grade_12                         37.0 66.0                       103.0                         37 66                 103
1289695 1289695 IN     school 1802220 6750   Cloverdale Community Schools 180222000265 7077 Cloverdale High School   Regular School No 3.0 09 12 2016   grade_12                         42.0 61.0                       103.0                         42 61                 103
1285783 1285783 IN     school 1804620 4590   River Forest Community Sch Corp 180462000781 3791 River Forest High School   Regular School No 3.0 09 12 2016   grade_12                         53.0 51.0                       104.0                         53 51                 104
1282822 1282822 IN     school 1810640 2100   Southeast Dubois Co Sch Corp 181064001745 1583 Forest Park Jr-Sr High School   Regular School No 3.0 07 12 2016   grade_12                         52.0 53.0                       105.0                         52 53                 105
1292370 1292370 IN     school 1800052 9535   Gary Lighthouse Charter School 180005202155 4130 Gary Lighthouse Charter School   Regular School Yes 4.0 KG 12 2016   grade_12                         44.0 61.0                       105.0                         44 61                 105
1281799 1281799 IN     school 1802700 755   Delphi Community School Corp 180270000326 637 Delphi Community High School   Regular School No 3.0 09 12 2016   grade_12                         52.0 54.0                       106.0                         52 54                 106
1290576 1290576 IN     school 1810560 7445   South Spencer County Sch Corp 181056001733 7795 South Spencer High School   Regular School No 3.0 09 12 2016   grade_12                         50.0 56.0                       106.0                         50 56                 106
1292046 1292046 IN     school 1810230 8625   Smith-Green Community Schools 181023001638 9193 Churubusco Jr-Sr High School   Regular School No 4.0 06 12 2016   grade_12                         61.0 46.0                       107.0                         61 46                 107
1291314 1291314 IN     school 1810590 8020   South Vermillion Com Sch Corp 181059001739 8432 South Vermillion High School   Regular School No 3.0 09 12 2016   grade_12                         54.0 54.0                       108.0                         54 54                 108
1287554 1287554 IN     school 1812810 5375   M S D Wayne Township 181281002028 5213 Ben Davis High School   Regular School No 3.0 10 12 2016   grade_12                         540.0 540.0                       1080.0                         540 540                 1080
1290216 1290216 IN     school 1810290 7205   South Bend Community Sch Corp 181029001878 7534 Rise Up Academy at Eggleston   Regular School No 3.0 09 12 2016   grade_12                         55.0 54.0                       109.0                         55 54                 109
1287635 1287635 IN     school   5375   M S D Wayne Township   5271 Sanders School             2016   grade_12                         9.0 2.0                       11.0                         9 2                 11
1284738 1284738 IN     school 1802040 3470   Northwestern School Corp 180204000255 2897 Northwestern Sr High Sch   Regular School No 3.0 09 12 2016   grade_12                         52.0 58.0                       110.0                         52 58                 110
1288944 1288944 IN     school 1801710 6055   Central Noble Com School Corp 180171000230 6453 Central Noble Junior Senior HS   Regular School No 4.0 06 12 2016   grade_12                         63.0 47.0                       110.0                         63 47                 110
1289592 1289592 IN     school 1807950 6600   M S D North Posey Co Schools 180795001366 6975 North Posey Sr High School   Regular School No 3.0 09 12 2016   grade_12                         48.0 62.0                       110.0                         48 62                 110
1284594 1284594 IN     school 1806660 3335   Mill Creek Community Sch Corp 180666001171 2692 Cascade Senior High School   Regular School No 3.0 09 12 2016   grade_12                         55.0 56.0                       111.0                         55 56                 111
1281397 1281397 IN     school 1802850 255   East Allen County Schools 180285000361 285 Woodlan Jr/Sr High School   Regular School No 3.0 07 12 2016   grade_12                         63.0 49.0                       112.0                         63 49                 112
1286852 1286852 IN     school 1812880 5245   Frankton-Lapel Community Schs 181288002050 5005 Frankton Jr-Sr High School   Regular School No 3.0 07 12 2016   grade_12                         57.0 55.0                       112.0                         57 55                 112
1290778 1290778 IN     school 1811220 7775   Switzerland County School Corp 181122001811 7993 Switzerland Co Senior High Sch   Regular School No 3.0 09 12 2016   grade_12                         58.0 54.0                       112.0                         58 54                 112
1291952 1291952 IN     school 1800720 8445   M S D Bluffton-Harrison 180072000146 9089 Bluffton High School   Regular School No 3.0 09 12 2016   grade_12                         49.0 64.0                       113.0                         49 64                 113
1289690 1289690 IN     school 1807980 6715   North Putnam Community Schools 180798001369 7061 North Putnam Sr High Sch   Regular School No 3.0 09 12 2016   grade_12                         62.0 52.0                       114.0                         62 52                 114
1288439 1288439 IN     school 1808340 5625   Oak Hill United School Corp 180834001429 6069 Oak Hill High School   Regular School No 3.0 09 12 2016   grade_12                         60.0 55.0                       115.0                         60 55                 115
1288741 1288741 IN     school 1804140 5900   Monroe-Gregg School District 180414000716 6321 Monrovia High School   Regular School No 3.0 09 12 2016   grade_12                         60.0 56.0                       116.0                         60 56                 116
1291513 1291513 IN     school 1806270 8045   Manchester Community Schools 180627001103 8625 Manchester Jr-Sr High School   Regular School No 3.0 07 12 2016   grade_12                         62.0 54.0                       116.0                         62 54                 116
1290445 1290445 IN     school 1808310 7350   Northwestern Con School Corp 180831001423 7689 Triton Central High School   Regular School No 3.0 09 12 2016   grade_12                         56.0 61.0                       117.0                         56 61                 117
1281591 1281591 IN     school 1800480 395   Benton Community School Corp 180048000097 445 Benton Central Jr-Sr High School   Regular School No 3.0 07 12 2016   grade_12                         60.0 58.0                       118.0                         60 58                 118
1291745 1291745 IN     school 1803000 8215   East Washington School Corp 180300000395 8905 Eastern High School   Regular School No 3.0 09 12 2016   grade_12                         71.0 47.0                       118.0                         71 47                 118
1282081 1282081 IN     school 1803940 1010   Greater Clark County Schools 180394000832 886 Old Corden Porter School   Special Education School No 4.0 05 12 2016   grade_12                         10.0 2.0                       12.0                         10 2                 12
1292145 1292145 IN     school 1800006 9100   IN Department of Correction 180000601943 5452 Madison Juvenile Corr Fac   Regular School No 3.0 08 12 2016   grade_12                         0.0 12.0                       12.0                         0 12                 12
1292619 1292619 IN     school 1800125 9755   Carpe Diem - Meridian Campus 180012502536 5979 Carpe Diem - Meridian Campus   Regular School Yes 4.0 06 12 2016   grade_12                         6.0 6.0                       12.0                         6 6                 12
1286868 1286868 IN     school 1812880 5245   Frankton-Lapel Community Schs 181288002328 5011 Lapel Sr High School   Regular School No 3.0 09 12 2016   grade_12                         57.0 65.0                       122.0                         57 65                 122
1286918 1286918 IN     school 1800120 5265   Alexandria Community School Corp 180012000011 5041 Alexandria-Monroe High School   Regular School No 3.0 07 12 2016   grade_12                         58.0 64.0                       122.0                         58 64                 122
1291018 1291018 IN     school 1811610 7950   Union Co/Clg Corner Joint Sch Dist 181161001869 8193 Union County High School   Regular School No 3.0 09 12 2016   grade_12                         64.0 58.0                       122.0                         64 58                 122
1292494 1292494 IN     school 1800056 9640   Options Charter Sch - Noblesville 180005602313 2551 Options Charter School Noblesville   Regular School Yes 3.0 09 12 2016   grade_12                         59.0 63.0                       122.0                         59 63                 122
1285693 1285693 IN     school 1809300 4515   Prairie Heights Com Sch Corp 180930001526 3690 Prairie Heights Sr High Sch   Regular School No 3.0 09 12 2016   grade_12                         64.0 59.0                       123.0                         64 59                 123
1287728 1287728 IN     school 1804770 5385   Indianapolis Public Schools 180477000878 5483 Northwest Community High School   Regular School No 3.0 09 12 2016   grade_12                         57.0 66.0                       123.0                         57 66                 123
1285451 1285451 IN     school 1807620 4255   Nineveh-Hensley-Jackson United 180762001303 3419 Indian Creek Sr High School   Regular School No 3.0 09 12 2016   grade_12                         65.0 59.0                       124.0                         65 59                 124
1288298 1288298 IN     school 1800900 5480   Bremen Public Schools 180090000168 5941 Bremen Senior High School   Regular School No 3.0 09 12 2016   grade_12                         67.0 57.0                       124.0                         67 57                 124
1292585 1292585 IN     school 1800113 9730   Neighbors' New Vistas High School 180011302544 6864 Neighbors' New Vistas High School   Regular School Yes 3.0 09 12 2016   grade_12                         67.0 57.0                       124.0                         67 57                 124
1288403 1288403 IN     school 1806090 5615   Maconaquah School Corp 180609001078 6032 Maconaquah High School   Regular School No 3.0 09 12 2016   grade_12                         61.0 64.0                       125.0                         61 64                 125
1283990 1283990 IN     school 1801200 3060   Carmel Clay Schools 180120000193 2505 Carmel High School   Regular School No 3.0 09 12 2016   grade_12                         637.0 618.0                       1255.0                         637 618                 1255
1285677 1285677 IN     school 1813230 4455   Whitko Community School Corp 181323002089 9191 Whitko High School   Regular School No 3.0 09 12 2016   grade_12                         59.0 67.0                       126.0                         59 67                 126
1289247 1289247 IN     school 1808900 6445   Pike County School Corp 180890001482 6763 Pike Central High Sch   Regular School No 3.0 09 12 2016   grade_12                         65.0 61.0                       126.0                         65 61                 126
1290626 1290626 IN     school 1805340 7525   Knox Community School Corp 180534000938 7833 Knox Community High School   Regular School No 3.0 09 12 2016   grade_12                         67.0 59.0                       126.0                         67 59                 126
1291340 1291340 IN     school 1812090 8030   Vigo County School Corp 181209001923 8453 West Vigo High School   Regular School No 3.0 09 12 2016   grade_12                         62.0 64.0                       126.0                         62 64                 126
1283619 1283619 IN     school 1803030 2815   Eastbrook Community Sch Corp 180303000399 2293 Eastbrook High School   Regular School No 3.0 09 12 2016   grade_12                         63.0 64.0                       127.0                         63 64                 127
1289381 1289381 IN     school 1809180 6520   Porter Township School Corp 180918001521 6838 Boone Grove High School   Regular School No 3.0 09 12 2016   grade_12                         70.0 57.0                       127.0                         70 57                 127
1285055 1285055 IN     school 1809420 3815   Rensselaer Central School Corp 180942001543 3201 Rensselaer Central High School   Regular School No 3.0 09 12 2016   grade_12                         70.0 58.0                       128.0                         70 58                 128
1286847 1286847 IN     school 1806900 5085   Mitchell Community Schools 180690001198 4925 Mitchell High School   Regular School No 3.0 09 12 2016   grade_12                         66.0 63.0                       129.0                         66 63                 129
1291804 1291804 IN     school 1801560 8360   Centerville-Abington Com Schs 180156000217 8981 Centerville Sr High School   Regular School No 3.0 09 12 2016   grade_12                         65.0 64.0                       129.0                         65 64                 129
1292132 1292132 IN     school 1800006 9100   IN Department of Correction 180000601996 4846 Camp Summit Juv Facility   Regular School No 3.0 09 12 2016   grade_12                         13.0 0.0                       13.0                         13 0                 13
1289712 1289712 IN     school 1803990 6755   Greencastle Community Sch Corp 180399000690 7089 Greencastle Senior High School   Regular School No 3.0 09 12 2016   grade_12                         55.0 75.0                       130.0                         55 75                 130
1282914 1282914 IN     school 1800420 2260   Baugo Community Schools 180042000090 1701 Jimtown High School   Regular School No 3.0 09 12 2016   grade_12                         58.0 73.0                       131.0                         58 73                 131
1290552 1290552 IN     school 1808010 7385   North Spencer County Sch Corp 180801001376 7759 Heritage Hills High School   Regular School No 3.0 09 12 2016   grade_12                         71.0 60.0                       131.0                         71 60                 131
1291723 1291723 IN     school 1809810 8205   Salem Community Schools 180981001600 8857 Salem High School   Regular School No 3.0 09 12 2016   grade_12                         71.0 60.0                       131.0                         71 60                 131
1292108 1292108 IN     school 1800112 8815   CSUSA Manual 180011200825 5481 Emmerich Manual High School   Regular School No 3.0 09 12 2016   grade_12                         77.0 54.0                       131.0                         77 54                 131
1291013 1291013 IN     school 1811400 7945   Tipton Community School Corp 181140001843 8177 Tipton High School   Regular School No 3.0 09 12 2016   grade_12                         74.0 58.0                       132.0                         74 58                 132
1288679 1288679 IN     school 1807900 5835   North Montgomery Com Sch Corp 180790001357 6271 North Montgomery High School   Regular School No 3.0 09 12 2016   grade_12                         68.0 68.0                       136.0                         68 68                 136
1290749 1290749 IN     school 1810860 7715   Southwest School Corp 181086001773 7957 Sullivan High School   Regular School No 3.0 09 12 2016   grade_12                         69.0 67.0                       136.0                         69 67                 136
1281614 1281614 IN     school 1800570 515   Blackford County Schools 180057000102 489 Blackford High School   Regular School No 3.0 09 12 2016   grade_12                         74.0 63.0                       137.0                         74 63                 137
1282883 1282883 IN     school 1803480 2155   Fairfield Community Schools 180348000491 1613 Fairfield Jr-Sr High School   Regular School No 3.0 07 12 2016   grade_12                         69.0 68.0                       137.0                         69 68                 137
1283480 1283480 IN     school 1809630 2645   Rochester Community Sch Corp 180963001576 2173 Rochester Community High Sch   Regular School No 3.0 09 12 2016   grade_12                         77.0 60.0                       137.0                         77 60                 137
1282844 1282844 IN     school 1810870 2110   Southwest Dubois Co Sch Corp 181087001779 1588 Southridge High School   Regular School No 3.0 09 12 2016   grade_12                         57.0 81.0                       138.0                         57 81                 138
1292185 1292185 IN     school 1800016 9325   Options Charter School - Carmel 180001601738 2524 Options Charter School - Carmel   Regular School Yes 3.0 09 12 2016   grade_12                         73.0 65.0                       138.0                         73 65                 138
1282532 1282532 IN     school 1803840 1820   Garrett-Keyser-Butler Com 180384000605 1325 Garrett High School   Regular School No 3.0 09 12 2016   grade_12                         76.0 63.0                       139.0                         76 63                 139
1281831 1281831 IN     school 1810680 815   Southeastern School Corp 181068001755 689 Lewis Cass Jr-Sr High School   Regular School No 3.0 07 12 2016   grade_12                         70.0 70.0                       140.0                         70 70                 140
1292484 1292484 IN     school 1800041 9625   IN Acad for Sci Math Humanities 180004102348 1443 IN Aca for Sci Math & Humanities   Regular School No 3.0 11 12 2016   grade_12                         49.0 93.0                       142.0                         49 93                 142
1284386 1284386 IN     school 1808100 3295   North West Hendricks Schools 180810001387 2731 Tri-West Senior High School   Regular School No 3.0 09 12 2016   grade_12                         70.0 73.0                       143.0                         70 73                 143
1285003 1285003 IN     school 1801050 3695   Brownstown Cnt Com Sch Corp 180105000180 3126 Brownstown Central High School   Regular School No 3.0 09 12 2016   grade_12                         76.0 67.0                       143.0                         76 67                 143
1281649 1281649 IN     school 1812990 615   Western Boone Co Com Sch Dist 181299002066 539 Western Boone Jr-Sr High School   Regular School No 3.0 07 12 2016   grade_12                         71.0 73.0                       144.0                         71 73                 144
1291068 1291068 IN     school 1803450 7995   Evansville Vanderburgh Sch Corp 180345000456 8237 Benjamin Bosse High School   Regular School No 3.0 09 12 2016   grade_12                         67.0 77.0                       144.0                         67 77                 144
1285942 1285942 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_12                         59.0 87.0                       146.0                         59 87                 146
1282442 1282442 IN     school 1805700 1620   Lawrenceburg Com School Corp 180570001037 1177 Lawrenceburg High School   Regular School No 3.0 09 12 2016   grade_12                         67.0 80.0                       147.0                         67 80                 147
1289395 1289395 IN     school 1811700 6530   Union Township School Corp 181170001873 6841 Wheeler High School   Regular School No 3.0 09 12 2016   grade_12                         84.0 65.0                       149.0                         84 65                 149
1292432 1292432 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 Indiana School For The Blind   Alternative Education School No 4.0 PK 12 2016   grade_12                         8.0 7.0                       15.0                         8 7                 15
1292682 1292682 IN     school 1800072 9805   Hoosier Academy - Indianapolis 180007202422 2527 Hoosier Academy - Indianapolis   Regular School Yes 4.0 KG 12 2016   grade_12                         9.0 6.0                       15.0                         9 6                 15
1284301 1284301 IN     school 1800690 3180   North Harrison Com School Corp 180069000144 2629 North Harrison High School   Regular School No 3.0 09 12 2016   grade_12                         76.0 74.0                       150.0                         76 74                 150
1292782 1292782 IN     school 1800102 9885   Gary Middle College 180010202535 4027 Gary Middle College   Regular School Yes 3.0 09 12 2016   grade_12                         66.0 87.0                       153.0                         66 87                 153
1286260 1286260 IN     school 1804320 4710   School City of Hammond 180432000734 4413 Donald E Gavit Middle/High School   Regular School No 4.0 06 12 2016   grade_12                         69.0 85.0                       154.0                         69 85                 154
1289015 1289015 IN     school 1812900 6065   West Noble School Corporation 181290002058 6489 West Noble High School   Regular School No 3.0 09 12 2016   grade_12                         74.0 80.0                       154.0                         74 80                 154
1285730 1285730 IN     school 1805520 4535   Lakeland School Corporation 180552000996 3730 Lakeland High School   Regular School No 3.0 09 12 2016   grade_12                         85.0 70.0                       155.0                         85 70                 155
1288717 1288717 IN     school 1802460 5855   Crawfordsville Com Schools 180246000287 6277 Crawfordsville Sr High School   Regular School No 3.0 09 12 2016   grade_12                         74.0 81.0                       155.0                         74 81                 155
1285642 1285642 IN     school 1811370 4445   Tippecanoe Valley School Corp 181137001839 3602 Tippecanoe Valley High School   Regular School No 3.0 09 12 2016   grade_12                         76.0 82.0                       158.0                         76 82                 158
1288453 1288453 IN     school 1808850 5635   Peru Community Schools 180885001476 6085 Peru High School   Regular School No 3.0 09 12 2016   grade_12                         75.0 84.0                       159.0                         75 84                 159
1281376 1281376 IN     school 1802850 255   East Allen County Schools 180285000344 81 Heritage Jr/Sr High School   Regular School No 3.0 07 12 2016   grade_12                         92.0 68.0                       160.0                         92 68                 160
1281750 1281750 IN     school 1800960 670   Brown County School Corporation 180096000169 573 Brown County High School   Regular School No 3.0 09 12 2016   grade_12                         101.0 59.0                       160.0                         101 59                 160

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "enrollments" (
   [state] TEXT,
   [county] TEXT,
   [county_state_id] INTEGER,
   [admin_level] TEXT,
   [district_nces_id] INTEGER,
   [district_state_id] TEXT,
   [district_state_type] TEXT,
   [district] TEXT,
   [school_nces_id] INTEGER,
   [school_state_id] INTEGER,
   [school] TEXT,
   [school_state_type] TEXT,
   [ccd_school_type] TEXT,
   [ccd_charter_school] TEXT,
   [ccd_school_lvl] TEXT,
   [ccd_school_low_grade] TEXT,
   [ccd_school_high_grade] TEXT,
   [year] INTEGER,
   [term] TEXT,
   [grade] TEXT,
   [white] TEXT,
   [black] TEXT,
   [hispanic] TEXT,
   [native_american] TEXT,
   [native_american_alaskan_native] TEXT,
   [asian] TEXT,
   [native_hawaiian] TEXT,
   [asian_pacific_islander] TEXT,
   [native_hawaiian_pacific_islander] TEXT,
   [pacific_islander] TEXT,
   [multiracial] TEXT,
   [unknown_race] TEXT,
   [male] TEXT,
   [female] TEXT,
   [non_binary] TEXT,
   [unknown_gender] TEXT,
   [ell] TEXT,
   [ell_percent] TEXT,
   [homeless] TEXT,
   [homeless_percent] TEXT,
   [low_income] TEXT,
   [free_and_reduced] TEXT,
   [free_and_reduced_percent] TEXT,
   [disability] TEXT,
   [section_504] TEXT,
   [total] TEXT
, [white_int] INTEGER, [black_int] INTEGER, [hispanic_int] INTEGER, [native_american_int] INTEGER, [native_american_alaskan_native_int] INTEGER, [asian_int] INTEGER, [native_hawaiian_int] INTEGER, [asian_pacific_islander_int] INTEGER, [native_hawaiian_pacific_islander_int] INTEGER, [pacific_islander_int] INTEGER, [multiracial_int] INTEGER, [unknown_race_int] INTEGER, [male_int] INTEGER, [female_int] INTEGER, [non_binary_int] INTEGER, [unknown_gender_int] INTEGER, [ell_int] INTEGER, [homeless_int] INTEGER, [low_income_int] INTEGER, [free_and_reduced_int] INTEGER, [disability_int] INTEGER, [section_504_int] INTEGER, [total_int] INTEGER);
CREATE INDEX [idx_enrollments_state_grade]
    ON [enrollments] ([state], [grade]);
CREATE INDEX [idx_enrollments_grade]
    ON [enrollments] ([grade]);
CREATE INDEX [idx_enrollments_year]
    ON [enrollments] ([year]);
CREATE INDEX [idx_enrollments_state_year]
    ON [enrollments] ([state], [year]);
CREATE INDEX [idx_enrollments_school_nces_id]
    ON [enrollments] ([school_nces_id]);
CREATE INDEX [idx_enrollments_district_nces_id]
    ON [enrollments] ([district_nces_id]);