enrollments

Data source: Big Local News · About: Big Local

2,960 rows where grade = "grade_11" and state = "IN" sorted by ccd_school_type

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_11 · 2,760 ✖
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
1164322 1164322 IN     school 1805520 4535   Lakeland School Corporation 180552000996 3730 Lakeland High School   Regular School No 3.0 09 12 2015   grade_11                         89.0 67.0                       156.0                         89 67                 156
1164385 1164385 IN     school 1804350 4580   Hanover Community School Corp 180435000753 3785 Hanover Central High Sch   Regular School No 3.0 09 12 2015   grade_11                         91.0 75.0                       166.0                         91 75                 166
1164391 1164391 IN     school 1804620 4590   River Forest Community Sch Corp 180462000781 3791 River Forest Jr-Sr High School   Regular School No 4.0 06 12 2015   grade_11                         53.0 53.0                       106.0                         53 53                 106
1164418 1164418 IN     school 1809690 4600   Merrillville Community School 180969001586 3809 Merrillville High Sch   Regular School No 3.0 09 12 2015   grade_11                         257.0 271.0                       528.0                         257 271                 528
1164466 1164466 IN     school 1805450 4615   Lake Central School Corp 180545000984 3833 Lake Central High School   Regular School No 3.0 09 12 2015   grade_11                         407.0 394.0                       801.0                         407 394                 801
1164548 1164548 IN     school 1811460 4645   Tri-Creek School Corporation 181146001852 3865 Lowell Senior High School   Regular School No 3.0 09 12 2015   grade_11                         148.0 119.0                       267.0                         148 119                 267
1164554 1164554 IN     school 1805460 4650   Lake Ridge Schools 180546000989 3869 Calumet High School   Regular School No 3.0 09 12 2015   grade_11                         64.0 99.0                       163.0                         64 99                 163
1164601 1164601 IN     school 1802490 4660   Crown Point Community Sch Corp 180249000293 3901 Crown Point High School   Regular School No 3.0 09 12 2015   grade_11                         386.0 331.0                       717.0                         386 331                 717
1164636 1164636 IN     school 1802880 4670   School City of East Chicago 180288002272 3924 East Chicago Central High Sch   Regular School No 3.0 09 12 2015   grade_11                         138.0 139.0                       277.0                         138 139                 277
1164692 1164692 IN     school 1802910 4680   Lake Station Community Schools 180291000380 3965 Thomas A Edison Jr-Sr HS   Regular School No 3.0 07 12 2015   grade_11                         38.0 47.0                       85.0                         38 47                 85
1164774 1164774 IN     school 1803870 4690   Gary Community School Corp 180387002513 4113 New Tech Innovative Institute   Regular School No 3.0 09 12 2015   grade_11                         56.0 55.0                       111.0                         56 55                 111
1164799 1164799 IN     school 1803870 4690   Gary Community School Corp 180387000648 4163 West Side Leadership Academy   Regular School No 3.0 09 12 2015   grade_11                         111.0 104.0                       215.0                         111 104                 215
1164804 1164804 IN     school 1803870 4690   Gary Community School Corp 180387002199 4168 Wm A Wirt/Emerson VPA   Regular School No 4.0 05 12 2015   grade_11                         34.0 59.0                       93.0                         34 59                 93
1164829 1164829 IN     school 1804170 4700   Griffith Public Schools 180417000722 4173 Griffith Senior High School   Regular School No 3.0 09 12 2015   grade_11                         112.0 85.0                       197.0                         112 85                 197
1164855 1164855 IN     school 1804320 4710   School City of Hammond 180432000735 4411 George Rogers Clark Md/HS   Regular School No 4.0 06 12 2015   grade_11                         91.0 92.0                       183.0                         91 92                 183
1164864 1164864 IN     school 1804320 4710   School City of Hammond 180432000734 4413 Donald E Gavit Mdl/High Sch   Regular School No 4.0 06 12 2015   grade_11                         83.0 94.0                       177.0                         83 94                 177
1164873 1164873 IN     school 1804320 4710   School City of Hammond 180432000736 4415 Hammond High School   Regular School No 3.0 09 12 2015   grade_11                         111.0 84.0                       195.0                         111 84                 195
1164879 1164879 IN     school 1804320 4710   School City of Hammond 180432000746 4417 Morton Senior High School   Regular School No 3.0 09 12 2015   grade_11                         178.0 157.0                       335.0                         178 157                 335
1165000 1165000 IN     school 1804560 4720   School Town of Highland 180456000763 4281 Highland High School   Regular School No 3.0 09 12 2015   grade_11                         149.0 129.0                       278.0                         149 129                 278
1165038 1165038 IN     school 1804590 4730   School City of Hobart 180459000774 4305 Hobart High School   Regular School No 3.0 09 12 2015   grade_11                         191.0 179.0                       370.0                         191 179                 370
1165072 1165072 IN     school 1807350 4740   School Town of Munster 180735001257 4332 Munster High School   Regular School No 3.0 09 12 2015   grade_11                         169.0 179.0                       348.0                         169 179                 348
1165103 1165103 IN     school 1813200 4760   Whiting School City 181320002082 4353 Whiting High School   Regular School No 3.0 09 12 2015   grade_11                         49.0 51.0                       100.0                         49 51                 100
1165127 1165127 IN     school 1807560 4805   New Prairie United School Corp 180756001298 4689 New Prairie High School   Regular School No 3.0 09 12 2015   grade_11                         107.0 101.0                       208.0                         107 101                 208
1165160 1165160 IN     school 1807470 4860   M S D of New Durham Township 180747001294 4701 Westville High School   Regular School No 3.0 07 12 2015   grade_11                         47.0 45.0                       92.0                         47 45                 92
1165167 1165167 IN     school 1800107 4915   Tri-Township Cons School Corp 180010702511 4692 LaCrosse School   Regular School No 3.0 09 12 2015   grade_11                         11.0 20.0                       31.0                         11 20                 31
1165205 1165205 IN     school 1806570 4925   Michigan City Area Schools 180657001160 4795 Michigan City High Sch   Regular School No 3.0 09 12 2015   grade_11                         203.0 210.0                       413.0                         203 210                 413
1165269 1165269 IN     school 1802190 4940   South Central Com School Corp 180219000263 4737 South Central Jr-Sr High Sch   Regular School No 3.0 07 12 2015   grade_11                         34.0 36.0                       70.0                         34 36                 70
1165304 1165304 IN     school 1805580 4945   LaPorte Community School Corp 180558001015 4741 LaPorte High School   Regular School No 3.0 09 12 2015   grade_11                         241.0 239.0                       480.0                         241 239                 480
1165416 1165416 IN     school 1807860 5075   North Lawrence Com Schools 180786001337 4911 Bedford-North Lawrence High School   Regular School No 3.0 09 12 2015   grade_11                         223.0 178.0                       401.0                         223 178                 401
1165450 1165450 IN     school 1806900 5085   Mitchell Community Schools 180690001198 4925 Mitchell High School   Regular School No 3.0 09 12 2015   grade_11                         68.0 67.0                       135.0                         68 67                 135
1165455 1165455 IN     school 1812880 5245   Frankton-Lapel Community Schs 181288002050 5005 Frankton Jr-Sr High Sch   Regular School No 3.0 07 12 2015   grade_11                         54.0 57.0                       111.0                         54 57                 111
1165471 1165471 IN     school 1812880 5245   Frankton-Lapel Community Schs 181288002328 5011 Lapel Sr High School   Regular School No 3.0 09 12 2015   grade_11                         51.0 62.0                       113.0                         51 62                 113
1165496 1165496 IN     school 1810440 5255   South Madison Com Sch Corp 181044001711 5053 Pendleton Heights High School   Regular School No 3.0 09 12 2015   grade_11                         175.0 156.0                       331.0                         175 156                 331
1165521 1165521 IN     school 1800120 5265   Alexandria Com School Corp 180012000011 5041 Alexandria-Monroe High School   Regular School No 3.0 07 12 2015   grade_11                         68.0 73.0                       141.0                         68 73                 141
1165539 1165539 IN     school 1800150 5275   Anderson Community School Corp 180015000029 4945 Anderson High School   Regular School No 3.0 09 12 2015   grade_11                         229.0 211.0                       440.0                         229 211                 440
1165592 1165592 IN     school 1803300 5280   Elwood Community School Corp 180330000449 5149 Elwood Jr-Sr High School   Regular School No 3.0 07 12 2015   grade_11                         57.0 43.0                       100.0                         57 43                 100
1165610 1165610 IN     school 1802640 5300   M S D Decatur Township 180264000312 5177 Decatur Central High School   Regular School No 3.0 09 12 2015   grade_11                         197.0 216.0                       413.0                         197 216                 413
1165646 1165646 IN     school 1802640 5300   M S D Decatur Township 180264002463 5188 Decatur Twp Schl for Excellence   Regular School No 3.0 08 12 2015   grade_11                         39.0 31.0                       70.0                         39 31                 70
1165662 1165662 IN     school 1803750 5310   Franklin Township Com Sch Corp 180375000597 5193 Franklin Central High School   Regular School No 3.0 09 12 2015   grade_11                         337.0 297.0                       634.0                         337 297                 634
1165719 1165719 IN     school 1805670 5330   M S D Lawrence Township 180567001029 5275 Lawrence Central High School   Regular School No 3.0 09 12 2015   grade_11                         323.0 293.0                       616.0                         323 293                 616
1165725 1165725 IN     school 1805670 5330   M S D Lawrence Township 180567001031 5276 Lawrence North High School   Regular School No 3.0 09 12 2015   grade_11                         293.0 269.0                       562.0                         293 269                 562
1165818 1165818 IN     school 1808820 5340   Perry Township Schools 180882001464 5307 Perry Meridian High School   Regular School No 3.0 09 12 2015   grade_11                         286.0 260.0                       546.0                         286 260                 546
1165824 1165824 IN     school 1808820 5340   Perry Township Schools 180882001467 5309 Southport High School   Regular School No 3.0 09 12 2015   grade_11                         263.0 263.0                       526.0                         263 263                 526
1165937 1165937 IN     school 1808910 5350   M S D Pike Township 180891001489 5353 Pike High School   Regular School No 3.0 09 12 2015   grade_11                         385.0 361.0                       746.0                         385 361                 746
1166005 1166005 IN     school 1812360 5360   M S D Warren Township 181236001973 5361 Warren Central High School   Regular School No 3.0 09 12 2015   grade_11                         430.0 436.0                       866.0                         430 436                 866
1166146 1166146 IN     school 1812720 5370   M S D Washington Township 181272002021 5451 North Central High School   Regular School No 3.0 09 12 2015   grade_11                         375.0 422.0                       797.0                         375 422                 797
1166151 1166151 IN     school 1812810 5375   M S D Wayne Township 181281002028 5213 Ben Davis High School   Regular School No 3.0 10 12 2015   grade_11                         514.0 537.0                       1051.0                         514 537                 1051
1166261 1166261 IN     school 1812810 5375   M S D Wayne Township 181281002516 5288 Achieve Virtual Education Academy   Regular School No 3.0 09 12 2015   grade_11                         14.0 26.0                       40.0                         14 26                 40
1166274 1166274 IN     school 1812810 5375   M S D Wayne Township 181281002410 5447 Ben Davis University High School   Regular School No 3.0 10 12 2015   grade_11                         48.0 66.0                       114.0                         48 66                 114
1166278 1166278 IN     school 1800450 5380   Beech Grove City Schools 180045000093 5449 Beech Grove Sr High School   Regular School No 3.0 09 12 2015   grade_11                         81.0 96.0                       177.0                         81 96                 177
1166298 1166298 IN     school 1804770 5385   Indianapolis Public Schools 180477000801 5469 Arsenal Technical High School   Regular School No 3.0 09 12 2015   grade_11                         248.0 210.0                       458.0                         248 210                 458
1166303 1166303 IN     school 1804770 5385   Indianapolis Public Schools 180477000815 5473 Crispus Attucks Medical Magnet HS   Regular School No 3.0 09 12 2015   grade_11                         40.0 71.0                       111.0                         40 71                 111
1166309 1166309 IN     school 1804770 5385   Indianapolis Public Schools 180477000804 5477 Broad Ripple Mgnt HS for Prfm Arts   Regular School No 3.0 09 12 2015   grade_11                         41.0 69.0                       110.0                         41 69                 110
1166315 1166315 IN     school 1804770 5385   Indianapolis Public Schools 180477000878 5483 Northwest Community High School   Regular School No 3.0 09 12 2015   grade_11                         89.0 85.0                       174.0                         89 85                 174
1166321 1166321 IN     school 1804770 5385   Indianapolis Public Schools 180477002238 5485 Shortridge Law & Public Plcy Mg HS   Regular School No 3.0 09 12 2015   grade_11                         42.0 48.0                       90.0                         42 48                 90
1166327 1166327 IN     school 1804770 5385   Indianapolis Public Schools 180477000856 5494 John Marshall Community High Sch   Regular School No 3.0 09 12 2015   grade_11                         70.0 67.0                       137.0                         70 67                 137
1166744 1166744 IN     school 1804770 5385   Indianapolis Public Schools 180477001434 5631 Key Learning Community High School   Regular School No 3.0 09 12 2015   grade_11                         6.0 2.0                       8.0                         6 2                 8
1166760 1166760 IN     school 1804770 5385   Indianapolis Public Schools 180477001446 5643 George Washington Community HS   Regular School No 3.0 09 12 2015   grade_11                         107.0 71.0                       178.0                         107 71                 178
1166805 1166805 IN     school 1804770 5385   Indianapolis Public Schools 180477002541 5909 Gambold Preparatory Magnet HS   Regular School No 4.0 09 11 2015   grade_11                         24.0 29.0                       53.0                         24 29                 53
1166811 1166811 IN     school 1800105 5390   Southside Sp Srvs Of Marion Co 180010502502 5320 RISE Learning Center   Regular School No 4.0 KG 12 2015   grade_11                         6.0 3.0                       9.0                         6 3                 9
1166827 1166827 IN     school 1810920 5400   School Town of Speedway 181092001785 5891 Speedway Senior High School   Regular School No 3.0 09 12 2015   grade_11                         60.0 45.0                       105.0                         60 45                 105
1166865 1166865 IN     school 1802520 5455   Culver Community Schools Corp 180252000301 5245 Culver Community High Sch   Regular School No 3.0 09 12 2015   grade_11                         37.0 30.0                       67.0                         37 30                 67
1166890 1166890 IN     school 1800180 5470   Argos Community Schools 180018000048 5937 Argos Comm Jr-Sr High School   Regular School No 3.0 07 12 2015   grade_11                         27.0 14.0                       41.0                         27 14                 41
1166898 1166898 IN     school 1800900 5480   Bremen Public Schools 180090000168 5941 Bremen Senior High School   Regular School No 3.0 09 12 2015   grade_11                         69.0 52.0                       121.0                         69 52                 121
1166921 1166921 IN     school 1809060 5485   Plymouth Community School Corp 180906001500 5945 Plymouth High School   Regular School No 3.0 09 12 2015   grade_11                         141.0 126.0                       267.0                         141 126                 267
1166959 1166959 IN     school 1811490 5495   Triton School Corporation 181149001856 5923 Triton Jr-Sr High Sch   Regular School No 3.0 07 12 2015   grade_11                         42.0 43.0                       85.0                         42 43                 85
1166967 1166967 IN     school 1810170 5520   Shoals Community School Corp 181017001635 5985 Shoals Comm Jr-Sr High Sch   Regular School No 3.0 07 12 2015   grade_11                         19.0 21.0                       40.0                         19 21                 40
1166995 1166995 IN     school 1806060 5525   Loogootee Community Sch Corp 180606001067 6003 Loogootee High School   Regular School No 3.0 09 12 2015   grade_11                         46.0 42.0                       88.0                         46 42                 88
1167004 1167004 IN     school 1806090 5615   Maconaquah School Corp 180609001078 6032 Maconaquah High School   Regular School No 3.0 09 12 2015   grade_11                         63.0 68.0                       131.0                         63 68                 131
1167018 1167018 IN     school 1807890 5620   North Miami Community Schools 180789001351 6049 North Miami Middle/High School   Regular School No 3.0 07 12 2015   grade_11                         30.0 33.0                       63.0                         30 33                 63
1167041 1167041 IN     school 1808340 5625   Oak Hill United School Corp 180834001429 6069 Oak Hill High School   Regular School No 3.0 09 12 2015   grade_11                         63.0 68.0                       131.0                         63 68                 131
1167055 1167055 IN     school 1808850 5635   Peru Community Schools 180885001476 6085 Peru High School   Regular School No 3.0 09 12 2015   grade_11                         75.0 86.0                       161.0                         75 86                 161
1167090 1167090 IN     school 1809480 5705   Richland-Bean Blossom C S C 180948001546 6146 Edgewood High School   Regular School No 3.0 09 12 2015   grade_11                         108.0 86.0                       194.0                         108 86                 194
1167152 1167152 IN     school 1800630 5740   Monroe County Com Sch Corp 180063000120 6166 Bloomington High School South   Regular School No 3.0 09 12 2015   grade_11                         220.0 197.0                       417.0                         220 197                 417
1167158 1167158 IN     school 1800630 5740   Monroe County Com Sch Corp 180063000119 6168 Bloomington High School North   Regular School No 3.0 09 12 2015   grade_11                         175.0 195.0                       370.0                         175 195                 370
1167210 1167210 IN     school 1800630 5740   Monroe County Com Sch Corp 180063002467 6202 The Acad of Sci & Entrepreneurship   Regular School No 3.0 09 12 2015   grade_11                         16.0 9.0                       25.0                         16 9                 25
1167227 1167227 IN     school 1800630 5740   Monroe County Com Sch Corp 180063002498 6220 Bloomington Graduation School   Regular School No 3.0 09 12 2015   grade_11                         5.0 10.0                       15.0                         5 10                 15
1167279 1167279 IN     school 1807900 5835   North Montgomery Com Sch Corp 180790001357 6271 North Montgomery High School   Regular School No 3.0 09 12 2015   grade_11                         72.0 74.0                       146.0                         72 74                 146
1167292 1167292 IN     school 1810450 5845   South Montgomery Com Sch Corp 181045001716 6257 Southmont Sr High School   Regular School No 3.0 09 12 2015   grade_11                         57.0 55.0                       112.0                         57 55                 112
1167317 1167317 IN     school 1802460 5855   Crawfordsville Com Schools 180246000287 6277 Crawfordsville Sr High School   Regular School No 3.0 09 12 2015   grade_11                         78.0 80.0                       158.0                         78 80                 158
1167341 1167341 IN     school 1804140 5900   Monroe-Gregg School District 180414000716 6321 Monrovia High School   Regular School No 3.0 09 12 2015   grade_11                         58.0 53.0                       111.0                         58 53                 111
1167354 1167354 IN     school 1803330 5910   Eminence Community School Corp 180333000454 6325 Eminence Jr-Sr High School   Regular School No 4.0 06 12 2015   grade_11                         17.0 19.0                       36.0                         17 19                 36
1167376 1167376 IN     school 1806510 5925   M S D Martinsville Schools 180651001135 6329 Martinsville High School   Regular School No 3.0 09 12 2015   grade_11                         205.0 164.0                       369.0                         205 164                 369
1167439 1167439 IN     school 1807140 5930   Mooresville Con School Corp 180714001207 6369 Mooresville High School   Regular School No 3.0 09 12 2015   grade_11                         166.0 162.0                       328.0                         166 162                 328
1167513 1167513 IN     school 1807920 5945   North Newton School Corp 180792001363 6411 North Newton Jr-Sr High Sch   Regular School No 3.0 07 12 2015   grade_11                         55.0 47.0                       102.0                         55 47                 102
1167520 1167520 IN     school 1810470 5995   South Newton School Corp 181047001722 6417 South Newton Senior High Sch   Regular School No 3.0 09 12 2015   grade_11                         40.0 37.0                       77.0                         40 37                 77
1167545 1167545 IN     school 1801710 6055   Central Noble Com School Corp 180171000230 6453 Central Noble Junior Senior HS   Regular School No 4.0 06 12 2015   grade_11                         63.0 48.0                       111.0                         63 48                 111
1167570 1167570 IN     school 1802970 6060   East Noble School Corp 180297000389 6458 East Noble High School   Regular School No 3.0 08 12 2015   grade_11                         151.0 151.0                       302.0                         151 151                 302
1167616 1167616 IN     school 1812900 6065   West Noble School Corporation 181290002058 6489 West Noble High School   Regular School No 3.0 09 12 2015   grade_11                         87.0 90.0                       177.0                         87 90                 177
1167644 1167644 IN     school 1809600 6080   Rising Sun-Ohio Co Com 180960001573 6513 Rising Sun High School   Regular School No 3.0 09 12 2015   grade_11                         22.0 22.0                       44.0                         22 22                 44
1167649 1167649 IN     school 1808490 6145   Orleans Community Schools 180849001437 6573 Orleans Jr-Sr High Sch   Regular School No 3.0 07 12 2015   grade_11                         36.0 34.0                       70.0                         36 34                 70
1167665 1167665 IN     school 1808640 6155   Paoli Community School Corp 180864001438 6581 Paoli Jr & Sr High Sch   Regular School No 3.0 07 12 2015   grade_11                         39.0 47.0                       86.0                         39 47                 86
1167681 1167681 IN     school 1810980 6160   Springs Valley Com School Corp 181098001795 6589 Springs Valley Comm High Sch   Regular School No 4.0 06 12 2015   grade_11                         37.0 27.0                       64.0                         37 27                 64
1167715 1167715 IN     school 1810950 6195   Spencer-Owen Community Schools 181095001791 6613 Owen Valley Community HS   Regular School No 3.0 09 12 2015   grade_11                         108.0 97.0                       205.0                         108 97                 205
1167746 1167746 IN     school 1810900 6260   Southwest Parke Com Sch Corp 181090002287 6627 Riverton Parke Jr-Sr High School   Regular School No 3.0 07 12 2015   grade_11                         34.0 41.0                       75.0                         34 41                 75
1167770 1167770 IN     school 1801740 6325   Perry Central Com Schools Corp 180174000234 6708 Perry Central Jr-Sr High Sch   Regular School No 3.0 07 12 2015   grade_11                         43.0 41.0                       84.0                         43 41                 84
1167778 1167778 IN     school 1801170 6340   Cannelton City Schools 180117000191 6733 Cannelton Elem & High School   Regular School No 4.0 PK 12 2015   grade_11                         11.0 10.0                       21.0                         11 10                 21
1167793 1167793 IN     school 1811260 6350   Tell City-Troy Twp School Corp 181126001819 6741 Tell City Jr-Sr High School   Regular School No 3.0 07 12 2015   grade_11                         44.0 39.0                       83.0                         44 39                 83
1167808 1167808 IN     school 1800118 6375   North Central Parke Comm Schl Corp 180011801579 6637 Rockville Jr-Sr High School   Regular School No 3.0 07 12 2015   grade_11                         36.0 26.0                       62.0                         36 26                 62
1167833 1167833 IN     school 1800118 6375   North Central Parke Comm Schl Corp 180011801858 6649 Turkey Run Jr/Sr High School   Regular School No 3.0 07 12 2015   grade_11                         18.0 21.0                       39.0                         18 21                 39

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