enrollments

Data source: Big Local News · About: Big Local

420 rows where grade = "grade_11", state = "IN" and year = 2016 sorted by school

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2016 · 320 ✖

grade ✖

  • grade_11 · 320 ✖
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
1286024 1286024 IN     school 1802880 4670   School City of East Chicago 180288002272 3924 East Chicago Central High School   Regular School No 3.0 09 12 2016   grade_11                         141.0 163.0                       304.0                         141 163                 304
1288968 1288968 IN     school 1802970 6060   East Noble School Corp 180297000389 6458 East Noble High School   Regular School No 3.0 07 12 2016   grade_11                         149.0 161.0                       310.0                         149 161                 310
1283618 1283618 IN     school 1803030 2815   Eastbrook Community Sch Corp 180303000399 2293 Eastbrook High School   Regular School No 3.0 09 12 2016   grade_11                         62.0 57.0                       119.0                         62 57                 119
1283730 1283730 IN     school 1803090 2940   Eastern Greene Schools 180309000408 2435 Eastern Greene High School   Regular School No 3.0 09 12 2016   grade_11                         53.0 38.0                       91.0                         53 38                 91
1284262 1284262 IN     school 1803120 3145   Eastern Hancock Co Com Sch Corp 180312000410 2585 Eastern Hancock High School   Regular School No 3.0 09 12 2016   grade_11                         55.0 64.0                       119.0                         55 64                 119
1284773 1284773 IN     school 1803150 3480   Eastern Howard School Corporation 180315000413 2919 Eastern High School   Regular School No 3.0 09 12 2016   grade_11                         48.0 54.0                       102.0                         48 54                 102
1291744 1291744 IN     school 1803000 8215   East Washington School Corp 180300000395 8905 Eastern High School   Regular School No 3.0 09 12 2016   grade_11                         48.0 59.0                       107.0                         48 59                 107
1282508 1282508 IN     school 1803060 1805   DeKalb Co Eastern Com Sch Dist 180306000405 1317 Eastside Junior-Senior High School   Regular School No 3.0 07 12 2016   grade_11                         46.0 52.0                       98.0                         46 52                 98
1288487 1288487 IN     school 1809480 5705   Richland-Bean Blossom C S C 180948001546 6146 Edgewood High School   Regular School No 3.0 09 12 2016   grade_11                         100.0 106.0                       206.0                         100 106                 206
1285339 1285339 IN     school 1803240 4215   Edinburgh Community Sch Corp 180324000422 3447 Edinburgh Community High School   Regular School No 3.0 09 12 2016   grade_11                         39.0 32.0                       71.0                         39 32                 71
1283093 1283093 IN     school 1803270 2305   Elkhart Community Schools 180327002585 1752 Elkhart Alternative Education   Regular School No 4.0 01 12 2016   grade_11                         33.0 43.0                       76.0                         33 43                 76
1283081 1283081 IN     school 1803270 2305   Elkhart Community Schools 180327000429 1749 Elkhart Central High School   Regular School No 3.0 09 12 2016   grade_11                         226.0 235.0                       461.0                         226 235                 461
1283087 1283087 IN     school 1803270 2305   Elkhart Community Schools 180327000430 1750 Elkhart Memorial High School   Regular School No 3.0 09 12 2016   grade_11                         228.0 196.0                       424.0                         228 196                 424
1286988 1286988 IN     school 1803300 5280   Elwood Community School Corp 180330000449 5149 Elwood Jr-Sr High School   Regular School No 3.0 07 12 2016   grade_11                         45.0 65.0                       110.0                         45 65                 110
1288753 1288753 IN     school 1803330 5910   Eminence Community School Corp 180333000454 6325 Eminence Jr-Sr High School   Regular School No 4.0 06 12 2016   grade_11                         16.0 11.0                       27.0                         16 11                 27
1292107 1292107 IN     school 1800112 8815   CSUSA Manual 180011200825 5481 Emmerich Manual High School   Regular School No 3.0 09 12 2016   grade_11                         94.0 78.0                       172.0                         94 78                 172
1290477 1290477 IN     school 1810140 7365   Shelbyville Central Schools 181014002496 7671 Especially Kidz Health & Rehab Cnt   Regular School No 4.0 02 12 2016   grade_11                         4.0 2.0                       6.0                         4 2                 6
1292614 1292614 IN     school 1800116 9750   Excel Center - Anderson 180011602533 4904 Excel Center - Anderson   Regular School Yes 3.0 10 12 2016   grade_11                         85.0 163.0                       248.0                         85 163                 248
1292232 1292232 IN     school 1800135 9355   Excel Center - Kokomo 180013502553 2976 Excel Center - Kokomo   Regular School Yes 3.0 10 12 2016   grade_11                         115.0 165.0                       280.0                         115 165                 280
1292219 1292219 IN     school 1800142 9345   Excel Center - Lafayette 180014202548 8094 Excel Center - Lafayette   Regular School Yes 3.0 10 12 2016   grade_11                         89.0 135.0                       224.0                         89 135                 224
1292204 1292204 IN     school 1800138 9335   Excel Center - Lafayette Square 180013802554 5912 Excel Center - Lafayette Square   Regular School Yes 3.0 10 12 2016   grade_11                         87.0 171.0                       258.0                         87 171                 258
1292733 1292733 IN     school 1800163 9855   Excel Center - Noblesville 180016302576 5748 Excel Center - Noblesville   Regular School Yes 4.0 11 11 2016   grade_11                         55.0 82.0                       137.0                         55 82                 137
1292151 1292151 IN     school 1800134 9305   Excel Center - Richmond 180013402549 9012 Excel Center - Richmond   Regular School Yes 3.0 10 12 2016   grade_11                         104.0 134.0                       238.0                         104 134                 238
1292807 1292807 IN     school 1800169 9900   Excel Center - South Bend 180016902596 7566 Excel Center - South Bend   Regular School Yes 4.0 11 11 2016   grade_11                         59.0 195.0                       254.0                         59 195                 254
1292710 1292710 IN     school 1800159 9840   Excel Center - Univ Heights 180015902592 5749 Excel Center - Univ Heights   Regular School Yes 3.0 10 12 2016   grade_11                         90.0 206.0                       296.0                         90 206                 296
1292825 1292825 IN     school 1800093 9910   Excel Center for Adult Learners 180009302475 5669 Excel Center For Adult Learners   Regular School Yes 3.0 09 12 2016   grade_11                         329.0 519.0                       848.0                         329 519                 848
1282882 1282882 IN     school 1803480 2155   Fairfield Community Schools 180348000491 1613 Fairfield Jr-Sr High School   Regular School No 3.0 07 12 2016   grade_11                         91.0 68.0                       159.0                         91 68                 159
1283874 1283874 IN     school 1810650 3005   Hamilton Southeastern Schools 181065002392 2487 Fishers High School   Regular School No 3.0 09 12 2016   grade_11                         375.0 364.0                       739.0                         375 364                 739
1283322 1283322 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741001265 1930 Floyd Central High School   Regular School No 3.0 09 12 2016   grade_11                         226.0 212.0                       438.0                         226 212                 438
1282821 1282821 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_11                         52.0 58.0                       110.0                         52 58                 110
1283433 1283433 IN     school 1810620 2455   Southeast Fountain School Corp 181062001742 2022 Fountain Central High School   Regular School No 3.0 07 12 2016   grade_11                         44.0 45.0                       89.0                         44 45                 89
1291077 1291077 IN     school 1803450 7995   Evansville Vanderburgh Sch Corp 180345000466 8245 Francis Joseph Reitz High School   Regular School No 3.0 09 12 2016   grade_11                         146.0 152.0                       298.0                         146 152                 298
1282199 1282199 IN     school 1803660 1170   Community Schools of Frankfort 180366000574 997 Frankfort Senior High School   Regular School No 3.0 09 12 2016   grade_11                         90.0 89.0                       179.0                         90 89                 179
1287060 1287060 IN     school 1803750 5310   Franklin Township Com Sch Corp 180375000597 5193 Franklin Central High School   Regular School No 3.0 09 12 2016   grade_11                         323.0 320.0                       643.0                         323 320                 643
1285368 1285368 IN     school 1803690 4225   Franklin Community School Corp 180369000581 3445 Franklin Community High Sch   Regular School No 3.0 09 12 2016   grade_11                         207.0 190.0                       397.0                         207 190                 397
1283451 1283451 IN     school 1803700 2475   Franklin County Com Sch Corp 180370002336 2083 Franklin County High   Regular School No 3.0 09 12 2016   grade_11                         105.0 110.0                       215.0                         105 110                 215
1286851 1286851 IN     school 1812880 5245   Frankton-Lapel Community Schs 181288002050 5005 Frankton Jr-Sr High School   Regular School No 3.0 07 12 2016   grade_11                         62.0 51.0                       113.0                         62 51                 113
1290642 1290642 IN     school 1803780 7605   Fremont Community Schools 180378000601 7877 Fremont High School   Regular School No 3.0 09 12 2016   grade_11                         31.0 41.0                       72.0                         31 41                 72
1291993 1291993 IN     school 1803810 8525   Frontier School Corporation 180381000603 9137 Frontier Jr-Sr High School   Regular School No 3.0 07 12 2016   grade_11                         28.0 28.0                       56.0                         28 28                 56
1282531 1282531 IN     school 1803840 1820   Garrett-Keyser-Butler Com 180384000605 1325 Garrett High School   Regular School No 3.0 09 12 2016   grade_11                         69.0 78.0                       147.0                         69 78                 147
1292369 1292369 IN     school 1800052 9535   Gary Lighthouse Charter School 180005202155 4130 Gary Lighthouse Charter School   Regular School Yes 4.0 KG 12 2016   grade_11                         55.0 71.0                       126.0                         55 71                 126
1292781 1292781 IN     school 1800102 9885   Gary Middle College 180010202535 4027 Gary Middle College   Regular School Yes 3.0 09 12 2016   grade_11                         20.0 32.0                       52.0                         20 32                 52
1286250 1286250 IN     school 1804320 4710   School City of Hammond 180432000735 4411 George Rogers Clark Md/HS   Regular School No 4.0 06 12 2016   grade_11                         105.0 93.0                       198.0                         105 93                 198
1288178 1288178 IN     school 1804770 5385   Indianapolis Public Schools 180477001446 5643 George Washington Community HS   Regular School No 3.0 09 12 2016   grade_11                         43.0 38.0                       81.0                         43 38                 81
1283575 1283575 IN     school 1810350 2765   South Gibson School Corp 181035001688 2211 Gibson Southern High School   Regular School No 3.0 09 12 2016   grade_11                         56.0 93.0                       149.0                         56 93                 149
1283209 1283209 IN     school 1803930 2315   Goshen Community Schools 180393000654 1821 Goshen High School   Regular School No 3.0 09 12 2016   grade_11                         228.0 212.0                       440.0                         228 212                 440
1289711 1289711 IN     school 1803990 6755   Greencastle Community Sch Corp 180399000690 7089 Greencastle Senior High School   Regular School No 3.0 09 12 2016   grade_11                         70.0 65.0                       135.0                         70 65                 135
1284212 1284212 IN     school 1804050 3125   Greenfield-Central Com Schools 180405000696 2595 Greenfield-Central High Sch   Regular School No 3.0 09 12 2016   grade_11                         169.0 177.0                       346.0                         169 177                 346
1282491 1282491 IN     school 1804080 1730   Greensburg Community Schools 180408000704 1268 Greensburg Community High School   Regular School No 3.0 09 12 2016   grade_11                         93.0 89.0                       182.0                         93 89                 182
1285399 1285399 IN     school 1804110 4245   Greenwood Community Sch Corp 180411000709 3473 Greenwood Community High Sch   Regular School No 3.0 09 12 2016   grade_11                         149.0 141.0                       290.0                         149 141                 290
1286224 1286224 IN     school 1804170 4700   Griffith Public Schools 180417000722 4173 Griffith Senior High School   Regular School No 3.0 09 12 2016   grade_11                         105.0 91.0                       196.0                         105 91                 196
1291769 1291769 IN     school 1807380 8305   Nettle Creek School Corp 180738001261 8985 Hagerstown Jr-Sr High School   Regular School No 3.0 07 12 2016   grade_11                         51.0 38.0                       89.0                         51 38                 89
1290658 1290658 IN     school 1804230 7610   Hamilton Community Schools 180423000724 7885 Hamilton Community High Sch   Regular School No 3.0 07 12 2016   grade_11                         20.0 16.0                       36.0                         20 16                 36
1283901 1283901 IN     school 1804260 3025   Hamilton Heights School Corp 180426000728 2477 Hamilton Heights High School   Regular School No 3.0 09 12 2016   grade_11                         87.0 76.0                       163.0                         87 76                 163
1283893 1283893 IN     school 1810650 3005   Hamilton Southeastern Schools 181065001752 2499 Hamilton Southeastern HS   Regular School No 3.0 09 12 2016   grade_11                         366.0 349.0                       715.0                         366 349                 715
1292561 1292561 IN     school 1800082 9705   Hammond Academy of Science & Tech 180008202466 4486 Hammond Academy of Science & Tech   Regular School Yes 4.0 06 12 2016   grade_11                         39.0 34.0                       73.0                         39 34                 73
1286268 1286268 IN     school 1804320 4710   School City of Hammond 180432000736 4415 Hammond High School   Regular School No 3.0 09 12 2016   grade_11                         113.0 89.0                       202.0                         113 89                 202
1285777 1285777 IN     school 1804350 4580   Hanover Community School Corp 180435000753 3785 Hanover Central High Sch   Regular School No 3.0 09 12 2016   grade_11                         88.0 87.0                       175.0                         88 87                 175
1281567 1281567 IN     school 1803570 370   Flat Rock-Hawcreek School Corp 180357000509 410 Hauser Jr-Sr High School   Regular School No 3.0 07 12 2016   grade_11                         31.0 30.0                       61.0                         31 30                 61
1289271 1289271 IN     school 1800750 6460   M S D Boone Township 180075000153 6813 Hebron High School   Regular School No 3.0 09 12 2016   grade_11                         52.0 44.0                       96.0                         52 44                 96
1281886 1281886 IN     school 1809370 940   West Clark Community Schools 180937001531 765 Henryville Jr & Sr High School   Regular School No 3.0 07 12 2016   grade_11                         43.0 46.0                       89.0                         43 46                 89
1290551 1290551 IN     school 1808010 7385   North Spencer County Sch Corp 180801001376 7759 Heritage Hills High School   Regular School No 3.0 09 12 2016   grade_11                         71.0 71.0                       142.0                         71 71                 142
1281375 1281375 IN     school 1802850 255   East Allen County Schools 180285000344 81 Heritage Jr/Sr High School   Regular School No 3.0 07 12 2016   grade_11                         70.0 74.0                       144.0                         70 74                 144
1292505 1292505 IN     school 1800058 9650   Herron Charter 180005802315 5724 Herron High School   Regular School Yes 3.0 09 12 2016   grade_11                         74.0 104.0                       178.0                         74 104                 178
1286395 1286395 IN     school 1804560 4720   School Town of Highland 180456000763 4281 Highland High School   Regular School No 3.0 09 12 2016   grade_11                         146.0 133.0                       279.0                         146 133                 279
1286433 1286433 IN     school 1804590 4730   School City of Hobart 180459000774 4305 Hobart High School   Regular School No 3.0 09 12 2016   grade_11                         149.0 158.0                       307.0                         149 158                 307
1280921 1280921 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000002 47 Homestead Senior High School   Regular School No 3.0 09 12 2016   grade_11                         294.0 298.0                       592.0                         294 298                 592
1292738 1292738 IN     school 1800081 9865   Hoosier Acad Virtual Charter 180008102458 5290 Hoosier Acad Virtual Charter Sch   Regular School Yes 4.0 KG 12 2016   grade_11                         224.0 358.0                       582.0                         224 358                 582
1292681 1292681 IN     school 1800072 9805   Hoosier Academy - Indianapolis 180007202422 2527 Hoosier Academy - Indianapolis   Regular School Yes 4.0 KG 12 2016   grade_11                         14.0 14.0                       28.0                         14 14                 28
1292510 1292510 IN     school 1800059 9655   Hope Academy 180005902386 5292 Hope Academy   Regular School Yes 3.0 09 12 2016   grade_11                         5.0 6.0                       11.0                         5 6                 11
1284907 1284907 IN     school 1804710 3625   Huntington Co Com Sch Corp 180471000786 3065 Huntington North High School   Regular School No 3.0 09 12 2016   grade_11                         214.0 217.0                       431.0                         214 217                 431
1292483 1292483 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_11                         75.0 98.0                       173.0                         75 98                 173
1292795 1292795 IN     school 1800094 9895   Indiana Math Science Academy North 180009402487 5444 IN Math & Science Acad North   Regular School Yes 4.0 KG 12 2016   grade_11                         10.0 22.0                       32.0                         10 22                 32
1285450 1285450 IN     school 1807620 4255   Nineveh-Hensley-Jackson United 180762001303 3419 Indian Creek Sr High School   Regular School No 3.0 09 12 2016   grade_11                         86.0 69.0                       155.0                         86 69                 155
1292811 1292811 IN     school 1800098 9905   Indiana Connections Academy 180009802474 7944 Indiana Connections Academy   Regular School Yes 4.0 KG 12 2016   grade_11                         210.0 338.0                       548.0                         210 338                 548
1292431 1292431 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_11                         5.0 10.0                       15.0                         5 10                 15
1292446 1292446 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Alternative Education School No 4.0 PK 12 2016   grade_11                         21.0 12.0                       33.0                         21 12                 33
1292786 1292786 IN     school 1800106 9890   Indiana Virtual School 180010602515 2488 Indiana Virtual School   Regular School Yes 4.0 06 12 2016   grade_11                         101.0 158.0                       259.0                         101 158                 259
1292526 1292526 IN     school 1800064 9670   Indianapolis Metropolitan High Sch 180006402408 5664 Indianapolis Metropolitan High Sch   Regular School Yes 3.0 09 12 2016   grade_11                         37.0 40.0                       77.0                         37 40                 77
1292407 1292407 IN     school 1800051 9575   Indpls Lighthouse Charter School 180005102165 5523 Indpls Lighthouse Charter School   Regular School Yes 4.0 KG 12 2016   grade_11                         38.0 47.0                       85.0                         38 47                 85
1292190 1292190 IN     school 1800014 9330   Irvington Community School 180001401756 1537 Irvington Community School   Regular School Yes 4.0 KG 12 2016   grade_11                         41.0 43.0                       84.0                         41 43                 84
1289860 1289860 IN     school 1804800 6900   Jac-Cen-Del Community Sch Corp 180480000907 7193 Jac-Cen-Del MS/HS   Regular School No 3.0 07 12 2016   grade_11                         21.0 42.0                       63.0                         21 42                 63
1282868 1282868 IN     school 1803960 2120   Greater Jasper Con Schs 180396000685 1593 Jasper High School   Regular School No 3.0 09 12 2016   grade_11                         125.0 143.0                       268.0                         125 143                 268
1285076 1285076 IN     school 1804980 3945   Jay School Corp 180498000914 3239 Jay County High School   Regular School No 3.0 09 12 2016   grade_11                         127.0 141.0                       268.0                         127 141                 268
1290796 1290796 IN     school 1805400 7855   Lafayette School Corporation 180540000968 8069 Jefferson High School   Regular School No 3.0 09 12 2016   grade_11                         253.0 237.0                       490.0                         253 237                 490
1282023 1282023 IN     school 1803940 1010   Greater Clark County Schools 180394000666 849 Jeffersonville High School   Regular School No 3.0 09 12 2016   grade_11                         242.0 234.0                       476.0                         242 234                 476
1285195 1285195 IN     school 1805190 4015   Jennings County School Corporation 180519000923 3345 Jennings County High School   Regular School No 3.0 09 12 2016   grade_11                         162.0 184.0                       346.0                         162 184                 346
1282913 1282913 IN     school 1800420 2260   Baugo Community Schools 180042000090 1701 Jimtown High School   Regular School No 3.0 09 12 2016   grade_11                         70.0 83.0                       153.0                         70 83                 153
1289937 1289937 IN     school 1809120 7150   John Glenn School Corporation 180912001505 7453 John Glenn High School   Regular School No 3.0 09 12 2016   grade_11                         86.0 77.0                       163.0                         86 77                 163
1287739 1287739 IN     school 1804770 5385   Indianapolis Public Schools 180477000856 5494 John Marshall Community High Sch   Regular School No 3.0 09 12 2016   grade_11                         51.0 46.0                       97.0                         51 46                 97
1290077 1290077 IN     school 1806840 7200   School City of Mishawaka 180684000531 7467 Joint Service Campus Program   Special Education School No 4.0 04 12 2016   grade_11                         10.0 3.0                       13.0                         10 3                 13
1290335 1290335 IN     school 1810290 7205   South Bend Community Sch Corp 181029000898 7632 Juvenile Justice Center   Alternative Education School No 3.0 07 12 2016   grade_11                         9.0 2.0                       11.0                         9 2                 11
1285031 1285031 IN     school 1805280 3785   Kankakee Valley School Corp 180528000933 3181 Kankakee Valley High School   Regular School No 3.0 09 12 2016   grade_11                         152.0 138.0                       290.0                         152 138                 290
1288162 1288162 IN     school 1804770 5385   Indianapolis Public Schools 180477001434 5631 Key Learning Community High School   Regular School No 3.0 09 12 2016   grade_11                         8.0 3.0                       11.0                         8 3                 11
1284703 1284703 IN     school 1801060 3455   C A Beard Memorial School Corp 180106000189 2869 Knightstown High School   Regular School No 3.0 09 12 2016   grade_11                         51.0 38.0                       89.0                         51 38                 89
1290625 1290625 IN     school 1805340 7525   Knox Community School Corp 180534000938 7833 Knox Community High School   Regular School No 3.0 09 12 2016   grade_11                         68.0 63.0                       131.0                         68 63                 131
1284866 1284866 IN     school 1805370 3500   Kokomo School Corporation 180537000947 3013 Kokomo High School   Regular School No 3.0 09 12 2016   grade_11                         241.0 229.0                       470.0                         241 229                 470
1289346 1289346 IN     school 1809000 6510   East Porter County School Corp 180900001497 6833 Kouts Middle/High School   Regular School No 4.0 06 12 2016   grade_11                         23.0 33.0                       56.0                         23 33                 56
1286562 1286562 IN     school 1800107 4915   Tri-Township Cons School Corp 180010702511 4692 LaCrosse School   Regular School No 3.0 09 12 2016   grade_11                         11.0 8.0                       19.0                         11 8                 19
1286699 1286699 IN     school 1805580 4945   LaPorte Community School Corp 180558001015 4741 LaPorte High School   Regular School No 3.0 09 12 2016   grade_11                         238.0 267.0                       505.0                         238 267                 505

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