enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2016 · 420 ✖

grade ✖

  • grade_11 · 420 ✖
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
1286498 1286498 IN     school 1813200 4760   School City of Whiting 181320002082 4353 Whiting High School   Regular School No 3.0 09 12 2016   grade_11                         59.0 40.0                       99.0                         59 40                 99
1281937 1281937 IN     school 1801920 1000   Clarksville Com School Corp 180192000249 833 Clarksville Senior High School   Regular School No 3.0 09 12 2016   grade_11                         54.0 44.0                       98.0                         54 44                 98
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
1289191 1289191 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 2016   grade_11                         54.0 44.0                       98.0                         54 44                 98
1285698 1285698 IN     school 1813110 4525   Westview School Corporation 181311002079 3697 Westview Jr-Sr High School   Regular School No 4.0 06 12 2016   grade_11                         50.0 47.0                       97.0                         50 47                 97
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
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
1289876 1289876 IN     school 1806630 6910   Milan Community Schools 180663001168 7205 Milan High School   Regular School No 3.0 09 12 2016   grade_11                         56.0 39.0                       95.0                         56 39                 95
1291203 1291203 IN     school 1803450 7995   Evansville Vanderburgh Sch Corp 180345002464 8326 New Tech Institute   Regular School No 3.0 09 12 2016   grade_11                         48.0 47.0                       95.0                         48 47                 95
1285178 1285178 IN     school 1810800 4000   Southwestern-Jefferson Co Con 181080001767 3337 Southwestern High School   Regular School No 3.0 09 12 2016   grade_11                         45.0 49.0                       94.0                         45 49                 94
1289624 1289624 IN     school 1807110 6620   Eastern Pulaski Com Sch Corp 180711001205 6997 Winamac Community High School   Regular School No 3.0 09 12 2016   grade_11                         49.0 45.0                       94.0                         49 45                 94
1289694 1289694 IN     school 1802220 6750   Cloverdale Community Schools 180222000265 7077 Cloverdale High School   Regular School No 3.0 09 12 2016   grade_11                         51.0 43.0                       94.0                         51 43                 94
1284720 1284720 IN     school 1811250 3460   Taylor Community School Corp 181125001814 2894 Taylor High School   Regular School No 3.0 09 12 2016   grade_11                         46.0 47.0                       93.0                         46 47                 93
1285480 1285480 IN     school 1810410 4325   South Knox School Corp 181041001706 3490 South Knox Middle-High School   Regular School No 3.0 07 12 2016   grade_11                         44.0 49.0                       93.0                         44 49                 93
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
1287407 1287407 IN     school 1812360 5360   M S D Warren Township 181236001973 5361 Warren Central High School   Regular School No 3.0 09 12 2016   grade_11                         441.0 465.0                       906.0                         441 465                 906
1286197 1286197 IN     school 1803870 4690   Gary Community School Corp 180387002199 4168 Wm A Wirt/Emerson VPA   Regular School No 4.0 05 12 2016   grade_11                         34.0 56.0                       90.0                         34 56                 90
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
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
1283532 1283532 IN     school 1802940 2725   East Gibson School Corporation 180294000386 2233 Waldo J Wood Memorial High   Regular School No 3.0 09 12 2016   grade_11                         43.0 46.0                       89.0                         43 46                 89
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
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
1290608 1290608 IN     school 1807800 7515   North Judson-San Pierre Sch Corp 180780001330 7849 North Judson-San Pierre High Sch   Regular School No 3.0 09 12 2016   grade_11                         41.0 47.0                       88.0                         41 47                 88
1292165 1292165 IN     school 1800021 9315   Signature School Inc 180002100319 8295 Signature School Inc   Regular School Yes 3.0 09 12 2016   grade_11                         37.0 51.0                       88.0                         37 51                 88
1287548 1287548 IN     school 1812720 5370   M S D Washington Township 181272002021 5451 North Central High School   Regular School No 3.0 09 12 2016   grade_11                         421.0 449.0                       870.0                         421 449                 870
1283740 1283740 IN     school 1805910 2950   Linton-Stockton School Corp 180591001049 2437 Linton-Stockton High School   Regular School No 3.0 09 12 2016   grade_11                         48.0 39.0                       87.0                         48 39                 87
1285460 1285460 IN     school 1807830 4315   North Knox School Corp 180783001334 3537 North Knox Jr-Sr High School   Regular School No 3.0 07 12 2016   grade_11                         34.0 53.0                       87.0                         34 53                 87
1287733 1287733 IN     school 1804770 5385   Indianapolis Public Schools 180477002238 5485 Shortridge High School   Regular School No 3.0 09 12 2016   grade_11                         40.0 47.0                       87.0                         40 47                 87
1289664 1289664 IN     school 1810500 6705   South Putnam Community Schools 181050001726 7071 South Putnam High School   Regular School No 3.0 09 12 2016   grade_11                         47.0 40.0                       87.0                         47 40                 87
1282225 1282225 IN     school 1809720 1180   Rossville Con School District 180972001590 1021 Rossville Middle/Senior High Sch   Regular School No 4.0 06 12 2016   grade_11                         47.0 39.0                       86.0                         47 39                 86
1285692 1285692 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_11                         47.0 39.0                       86.0                         47 39                 86
1286082 1286082 IN     school 1802910 4680   Lake Station Community Schools 180291000380 3965 Thomas A Edison Jr-Sr HS   Regular School No 3.0 07 12 2016   grade_11                         41.0 45.0                       86.0                         41 45                 86
1292100 1292100 IN     school 1800126 8810   CSUSA Howe 180012601445 5639 Thomas Carr Howe Comm High School   Regular School No 3.0 07 12 2016   grade_11                         51.0 35.0                       86.0                         51 35                 86
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
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
1289997 1289997 IN     school 1808760 7175   Penn-Harris-Madison Sch Corp 180876001451 7353 Penn High School   Regular School No 3.0 09 12 2016   grade_11                         430.0 411.0                       841.0                         430 411                 841
1290992 1290992 IN     school 1808040 7935   Tri-Central Community Schools 180804001379 8155 Tri Central Middle-High School   Regular School No 4.0 06 12 2016   grade_11                         43.0 41.0                       84.0                         43 41                 84
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
1288416 1288416 IN     school 1807890 5620   North Miami Community Schools 180789001351 6049 North Miami Middle/High School   Regular School No 3.0 07 12 2016   grade_11                         41.0 42.0                       83.0                         41 42                 83
1290341 1290341 IN     school 1811910 7215   Union-North United School Corp 181191001879 7399 LaVille Jr-Sr High School   Regular School No 3.0 07 12 2016   grade_11                         48.0 34.0                       82.0                         48 34                 82
1286664 1286664 IN     school 1802190 4940   South Central Com School Corp 180219000263 4737 South Central Jr-Sr High School   Regular School No 3.0 07 12 2016   grade_11                         39.0 42.0                       81.0                         39 42                 81
1287700 1287700 IN     school 1804770 5385   Indianapolis Public Schools 180477000799 5465 Arlington Community High School   Regular School No 3.0 09 12 2016   grade_11                         37.0 44.0                       81.0                         37 44                 81
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
1291919 1291919 IN     school 1810770 8425   Southern Wells Com Schools 181077001765 9058 Southern Wells Jr-Sr High Sch   Regular School No 3.0 07 12 2016   grade_11                         41.0 40.0                       81.0                         41 40                 81
1289765 1289765 IN     school 1807080 6820   Monroe Central School Corp 180708001202 7151 Monroe Central Jr-Sr High Sch   Regular School No 3.0 07 12 2016   grade_11                         47.0 33.0                       80.0                         47 33                 80
1287339 1287339 IN     school 1808910 5350   M S D Pike Township 180891001489 5353 Pike High School   Regular School No 3.0 09 12 2016   grade_11                         361.0 437.0                       798.0                         361 437                 798
1282183 1282183 IN     school 1802160 1160   Clinton Prairie School Corp 180216000258 977 Clinton Prairie Jr-Sr High School   Regular School No 3.0 07 12 2016   grade_11                         29.0 50.0                       79.0                         29 50                 79
1289145 1289145 IN     school 1810900 6260   Southwest Parke Com Sch Corp 181090002287 6627 Riverton Parke Jr-Sr High School   Regular School No 3.0 07 12 2016   grade_11                         44.0 35.0                       79.0                         44 35                 79
1283408 1283408 IN     school 1802430 2440   Covington Community Sch Corp 180243000275 2005 Covington Community High School   Regular School No 3.0 09 12 2016   grade_11                         44.0 34.0                       78.0                         44 34                 78
1291604 1291604 IN     school 1806080 8115   M S D Warren County 180608001073 8737 Seeger Memorial Jr-Sr HS   Regular School No 3.0 07 12 2016   grade_11                         41.0 37.0                       78.0                         41 37                 78
1285853 1285853 IN     school 1805450 4615   Lake Central School Corp 180545000984 3833 Lake Central High School   Regular School No 3.0 09 12 2016   grade_11                         400.0 371.0                       771.0                         400 371                 771
1281440 1281440 IN     school 1802850 255   East Allen County Schools 180285002532 394 East Allen University   Regular School No 3.0 09 12 2016   grade_11                         33.0 44.0                       77.0                         33 44                 77
1286555 1286555 IN     school 1807470 4860   M S D of New Durham Township 180747001294 4701 Westville High School   Regular School No 3.0 07 12 2016   grade_11                         39.0 38.0                       77.0                         39 38                 77
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
1282484 1282484 IN     school 1802610 1655   Decatur County Com Schools 180261000309 1267 North Decatur Jr-Sr High School   Regular School No 3.0 07 12 2016   grade_11                         34.0 42.0                       76.0                         34 42                 76
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
1282681 1282681 IN     school 1809840 1940   Daleville Community Schools 180984001603 1401 Daleville Jr-Sr High School   Regular School No 3.0 07 12 2016   grade_11                         36.0 39.0                       75.0                         36 39                 75
1284614 1284614 IN     school 1810380 3415   South Henry School Corp 181038001702 2773 Tri Junior-Senior High School   Regular School No 3.0 07 12 2016   grade_11                         37.0 38.0                       75.0                         37 38                 75
1291785 1291785 IN     school 1813050 8355   Western Wayne Schools 181305002069 8961 Lincoln Sr High School   Regular School No 3.0 09 12 2016   grade_11                         38.0 37.0                       75.0                         38 37                 75
1282317 1282317 IN     school 1807710 1375   North Daviess Com Schools 180771001319 1121 North Daviess Jr-Sr High Sch   Regular School No 3.0 07 12 2016   grade_11                         37.0 37.0                       74.0                         37 37                 74
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
1283972 1283972 IN     school 1806480 3055   Sheridan Community Schools 180648001127 2463 Sheridan High School   Regular School No 3.0 09 12 2016   grade_11                         42.0 31.0                       73.0                         42 31                 73
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
1282460 1282460 IN     school 1802610 1655   Decatur County Com Schools 180261000311 1263 South Decatur Jr-Sr High School   Regular School No 3.0 07 12 2016   grade_11                         35.0 37.0                       72.0                         35 37                 72
1289808 1289808 IN     school 1803180 6835   Randolph Eastern School Corp 180318000415 7161 Union City Community Jr/Sr HS   Regular School No 3.0 07 12 2016   grade_11                         34.0 38.0                       72.0                         34 38                 72
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
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
1282167 1282167 IN     school 1802130 1150   Clinton Central School Corp 180213000257 957 Clinton Central Junior-Senior HS   Regular School No 3.0 07 12 2016   grade_11                         43.0 28.0                       71.0                         43 28                 71
1284282 1284282 IN     school 1803720 3160   Lanesville Community School Corp 180372000593 2613 Lanesville Jr-Sr HS   Regular School No 3.0 07 12 2016   grade_11                         38.0 33.0                       71.0                         38 33                 71
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
1289836 1289836 IN     school 1810530 6865   South Ripley Com Sch Corp 181053001729 7182 South Ripley High School   Regular School No 3.0 09 12 2016   grade_11                         32.0 39.0                       71.0                         32 39                 71
1291529 1291529 IN     school 1812180 8050   M S D Wabash County Schools 181218001945 8651 Northfield Jr-Sr High School   Regular School No 3.0 07 12 2016   grade_11                         33.0 38.0                       71.0                         33 38                 71
1283505 1283505 IN     school 1801410 2650   Caston School Corporation 180141000207 2159 Caston Jr-Sr High School   Regular School No 3.0 07 12 2016   grade_11                         39.0 31.0                       70.0                         39 31                 70
1288265 1288265 IN     school 1802520 5455   Culver Community Schools Corp 180252000301 5245 Culver Community High School   Regular School No 3.0 09 12 2016   grade_11                         36.0 33.0                       69.0                         36 33                 69
1289630 1289630 IN     school 1809360 6630   West Central School Corp 180936001529 7025 West Central Senior High School   Regular School No 3.0 09 12 2016   grade_11                         36.0 33.0                       69.0                         36 33                 69
1291536 1291536 IN     school 1812180 8050   M S D Wabash County Schools 181218001948 8655 Southwood Jr-Sr High School   Regular School No 3.0 07 12 2016   grade_11                         38.0 31.0                       69.0                         38 31                 69
1284487 1284487 IN     school 1800270 3315   Avon Community School Corp 180027000057 2737 Avon High School   Regular School No 3.0 09 12 2016   grade_11                         360.0 328.0                       688.0                         360 328                 688
1283716 1283716 IN     school 1800600 2920   Bloomfield School District 180060000113 2419 Bloomfield Jr-Sr High School   Regular School No 3.0 07 12 2016   grade_11                         30.0 38.0                       68.0                         30 38                 68
1283756 1283756 IN     school 1810110 2960   M S D Shakamak Schools 181011001623 2445 Shakamak Jr-Sr High School   Regular School No 3.0 07 12 2016   grade_11                         31.0 37.0                       68.0                         31 37                 68
1285989 1285989 IN     school 1802490 4660   Crown Point Community Sch Corp 180249000293 3901 Crown Point High School   Regular School No 3.0 09 12 2016   grade_11                         346.0 329.0                       675.0                         346 329                 675
1290715 1290715 IN     school 1808160 7645   Northeast School Corp 180816001402 7917 North Central High School   Regular School No 3.0 09 12 2016   grade_11                         37.0 30.0                       67.0                         37 30                 67
1291282 1291282 IN     school 1808070 8010   North Vermillion Com Sch Corp 180807001384 8394 North Vermillion High School   Regular School No 3.0 07 12 2016   grade_11                         40.0 26.0                       66.0                         40 26                 66
1291645 1291645 IN     school 1812390 8130   Warrick County School Corp 181239001986 8772 Tecumseh Jr-Sr High School   Regular School No 3.0 07 12 2016   grade_11                         35.0 31.0                       66.0                         35 31                 66
1281994 1281994 IN     school 1803940 1010   Greater Clark County Schools 180394000672 809 New Washington Middle/High School   Regular School No 4.0 06 12 2016   grade_11                         30.0 35.0                       65.0                         30 35                 65
1291754 1291754 IN     school 1812930 8220   West Washington School Corp 181293002063 8869 West Washington Jr-Sr High School   Regular School No 3.0 07 12 2016   grade_11                         32.0 33.0                       65.0                         32 33                 65
1284091 1284091 IN     school 1807650 3070   Noblesville Schools 180765001309 2517 Noblesville High School   Regular School No 3.0 09 12 2016   grade_11                         334.0 312.0                       646.0                         334 312                 646
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
1282105 1282105 IN     school 1800840 1125   Clay Community Schools 180084000157 897 Clay City Jr-Sr High School   Regular School No 3.0 07 12 2016   grade_11                         36.0 28.0                       64.0                         36 28                 64
1282617 1282617 IN     school 1804500 1885   Wes-Del Community Schools 180450000761 1372 Wes-Del Middle/Senior High Sch   Regular School No 4.0 06 12 2016   grade_11                         40.0 24.0                       64.0                         40 24                 64
1286170 1286170 IN     school 1803870 4690   Gary Community School Corp 180387002513 4113 New Tech Innovative Institute   Regular School No 3.0 09 12 2016   grade_11                         41.0 23.0                       64.0                         41 23                 64
1288393 1288393 IN     school 1806060 5525   Loogootee Community Sch Corp 180606001067 6003 Loogootee High School   Regular School No 3.0 09 12 2016   grade_11                         34.0 30.0                       64.0                         34 30                 64
1290462 1290462 IN     school 1810830 7360   Southwestern Con Sch Shelby Co 181083001769 7701 Southwestern High School   Regular School No 3.0 07 12 2016   grade_11                         27.0 37.0                       64.0                         27 37                 64
1289418 1289418 IN     school 1809150 6550   Portage Township Schools 180915001514 6853 Portage High School   Regular School No 3.0 09 12 2016   grade_11                         327.0 308.0                       635.0                         327 308                 635
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
1287215 1287215 IN     school 1808820 5340   Perry Township Schools 180882001464 5307 Perry Meridian High School   Regular School No 3.0 09 12 2016   grade_11                         336.0 288.0                       624.0                         336 288                 624
1284400 1284400 IN     school 1801020 3305   Brownsburg Community Sch Corp 180102000176 2709 Brownsburg High School   Regular School No 3.0 09 12 2016   grade_11                         293.0 328.0                       621.0                         293 328                 621
1282656 1282656 IN     school 1807020 1900   Cowan Community School Corp 180702001200 1386 Cowan High School   Regular School No 3.0 07 12 2016   grade_11                         24.0 38.0                       62.0                         24 38                 62
1288358 1288358 IN     school 1811490 5495   Triton School Corporation 181149001856 5923 Triton Jr-Sr High School   Regular School No 3.0 07 12 2016   grade_11                         35.0 27.0                       62.0                         35 27                 62
1292776 1292776 IN     school 1800101 9880   Career Academy High School 180010102521 7564 Career Academy High School   Regular School Yes 3.0 09 12 2016   grade_11                         38.0 24.0                       62.0                         38 24                 62
1285305 1285305 IN     school 1801440 4205   Center Grove Com Sch Corp 180144000209 3437 Center Grove High School   Regular School No 3.0 09 12 2016   grade_11                         317.0 296.0                       613.0                         317 296                 613

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