enrollments

Data source: Big Local News · About: Big Local

3,530 rows where grade = "grade_7" and state = "IN"

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_7 · 3,330 ✖
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
1164573 1164573 IN     school 1805460 4650   Lake Ridge Schools 180546000992 3893 Lake Ridge Middle School   Regular School No 2.0 06 08 2015   grade_7                         83.0 61.0                       144.0                         83 61                 144
1164577 1164577 IN     school 1802490 4660   Crown Point Community Sch Corp 180249000297 3761 Robert Taft Middle School   Regular School No 2.0 06 08 2015   grade_7                         151.0 151.0                       302.0                         151 151                 302
1164631 1164631 IN     school 1802490 4660   Crown Point Community Sch Corp 180249002417 3915 Colonel John Wheeler Middle Schl   Regular School No 2.0 06 08 2015   grade_7                         148.0 148.0                       296.0                         148 148                 296
1164646 1164646 IN     school 1802880 4670   School City of East Chicago 180288000365 3937 Carrie Gosch Elementary School   Regular School No 1.0 PK 08 2015   grade_7                         3.0 2.0                       5.0                         3 2                 5
1164684 1164684 IN     school 1802880 4670   School City of East Chicago 180288000370 3963 Joseph Block Middle School   Regular School No 2.0 06 08 2015   grade_7                         77.0 80.0                       157.0                         77 80                 157
1164688 1164688 IN     school 1802880 4670   School City of East Chicago 180288000374 3967 West Side Middle School   Regular School No 2.0 06 08 2015   grade_7                         77.0 98.0                       175.0                         77 98                 175
1164694 1164694 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_7                         65.0 56.0                       121.0                         65 56                 121
1164726 1164726 IN     school 1803870 4690   Gary Community School Corp 180387000613 4053 Benjamin Banneker Achievement Ctr   Regular School No 1.0 KG 08 2015   grade_7                         27.0 31.0                       58.0                         27 31                 58
1164754 1164754 IN     school 1803870 4690   Gary Community School Corp 180387000620 4086 Frankie W McCullough Acad for Girl   Regular School No 1.0 KG 07 2015   grade_7                         0.0 47.0                       47.0                         0 47                 47
1164786 1164786 IN     school 1803870 4690   Gary Community School Corp 180387000621 4145 Dunbar-Pulaski Academic & Career   Regular School No 2.0 07 08 2015   grade_7                         205.0 115.0                       320.0                         205 115                 320
1164808 1164808 IN     school 1803870 4690   Gary Community School Corp 180387002199 4168 Wm A Wirt/Emerson VPA   Regular School No 4.0 05 12 2015   grade_7                         35.0 48.0                       83.0                         35 48                 83
1164833 1164833 IN     school 1804170 4700   Griffith Public Schools 180417000721 4177 Griffith Middle School   Regular School No 2.0 07 08 2015   grade_7                         80.0 87.0                       167.0                         80 87                 167
1164858 1164858 IN     school 1804320 4710   School City of Hammond 180432000735 4411 George Rogers Clark Md/HS   Regular School No 4.0 06 12 2015   grade_7                         98.0 80.0                       178.0                         98 80                 178
1164867 1164867 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_7                         116.0 112.0                       228.0                         116 112                 228
1164892 1164892 IN     school 1804320 4710   School City of Hammond 180432000738 4425 Henry W Eggers Elem/Md Sch   Regular School No 2.0 06 08 2015   grade_7                         129.0 112.0                       241.0                         129 112                 241
1164896 1164896 IN     school 1804320 4710   School City of Hammond 180432000732 4433 Charles N Scott Middle School   Regular School No 2.0 06 08 2015   grade_7                         145.0 135.0                       280.0                         145 135                 280
1165005 1165005 IN     school 1804560 4720   School Town of Highland 180456000764 4283 Highland Middle School   Regular School No 2.0 06 08 2015   grade_7                         133.0 119.0                       252.0                         133 119                 252
1165043 1165043 IN     school 1804590 4730   School City of Hobart 180459000773 4309 Hobart Middle School   Regular School No 2.0 06 08 2015   grade_7                         169.0 165.0                       334.0                         169 165                 334
1165077 1165077 IN     school 1807350 4740   School Town of Munster 180735001259 4333 Wilbur Wright Middle School   Regular School No 2.0 06 08 2015   grade_7                         167.0 152.0                       319.0                         167 152                 319
1165108 1165108 IN     school 1813200 4760   Whiting School City 181320000398 4356 Whiting Middle School   Regular School No 2.0 06 08 2015   grade_7                         45.0 44.0                       89.0                         45 44                 89
1165140 1165140 IN     school 1807560 4805   New Prairie United School Corp 180756001299 7345 New Prairie Middle School   Regular School No 2.0 06 08 2015   grade_7                         140.0 110.0                       250.0                         140 110                 250
1165162 1165162 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_7                         39.0 40.0                       79.0                         39 40                 79
1165177 1165177 IN     school 1800107 4915   Tri-Township Cons School Corp 180010702520 4696 Wanatah School   Regular School No 1.0 KG 08 2015   grade_7                         17.0 22.0                       39.0                         17 22                 39
1165197 1165197 IN     school 1806570 4925   Michigan City Area Schools 180657001154 4788 Martin T Krueger Middle Sch   Regular School No 2.0 07 08 2015   grade_7                         117.0 107.0                       224.0                         117 107                 224
1165200 1165200 IN     school 1806570 4925   Michigan City Area Schools 180657001140 4789 Barker Middle Sch   Regular School No 2.0 07 08 2015   grade_7                         115.0 92.0                       207.0                         115 92                 207
1165271 1165271 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_7                         31.0 35.0                       66.0                         31 35                 66
1165284 1165284 IN     school 1805580 4945   LaPorte Community School Corp 180558001012 4717 Kesling Middle School   Regular School No 2.0 06 08 2015   grade_7                         113.0 118.0                       231.0                         113 118                 231
1165310 1165310 IN     school 1805580 4945   LaPorte Community School Corp 180558001019 4745 Paul F Boston Middle School   Regular School No 2.0 06 08 2015   grade_7                         138.0 106.0                       244.0                         138 106                 244
1165382 1165382 IN     school 1807860 5075   North Lawrence Com Schools 180786000446 4878 Oolitic Middle School   Regular School No 2.0 06 08 2015   grade_7                         58.0 52.0                       110.0                         58 52                 110
1165400 1165400 IN     school 1807860 5075   North Lawrence Com Schools 180786000461 4891 Shawswick Middle School   Regular School No 2.0 06 08 2015   grade_7                         36.0 34.0                       70.0                         36 34                 70
1165404 1165404 IN     school 1807860 5075   North Lawrence Com Schools 180786001336 4905 Bedford Middle School   Regular School No 2.0 06 08 2015   grade_7                         104.0 107.0                       211.0                         104 107                 211
1165446 1165446 IN     school 1806900 5085   Mitchell Community Schools 180690002151 4924 Mitchell Jr High School   Regular School No 2.0 06 08 2015   grade_7                         70.0 67.0                       137.0                         70 67                 137
1165457 1165457 IN     school 1812880 5245   Frankton-Lapel Community Schs 181288002050 5005 Frankton Jr-Sr High Sch   Regular School No 3.0 07 12 2015   grade_7                         60.0 58.0                       118.0                         60 58                 118
1165476 1165476 IN     school 1812880 5245   Frankton-Lapel Community Schs 181288002418 5012 Lapel Middle School   Regular School No 2.0 06 08 2015   grade_7                         62.0 51.0                       113.0                         62 51                 113
1165500 1165500 IN     school 1810440 5255   South Madison Com Sch Corp 181044001712 5057 Pendleton Heights Middle Sch   Regular School No 2.0 07 08 2015   grade_7                         187.0 173.0                       360.0                         187 173                 360
1165523 1165523 IN     school 1800120 5265   Alexandria Com School Corp 180012000011 5041 Alexandria-Monroe High School   Regular School No 3.0 07 12 2015   grade_7                         79.0 53.0                       132.0                         79 53                 132
1165567 1165567 IN     school 1800150 5275   Anderson Community School Corp 180015002483 5076 Highland Middle School   Regular School No 2.0 06 08 2015   grade_7                         255.0 256.0                       511.0                         255 256                 511
1165594 1165594 IN     school 1803300 5280   Elwood Community School Corp 180330000449 5149 Elwood Jr-Sr High School   Regular School No 3.0 07 12 2015   grade_7                         47.0 65.0                       112.0                         47 65                 112
1165628 1165628 IN     school 1802640 5300   M S D Decatur Township 180264000313 5181 Decatur Middle Sch   Regular School No 2.0 07 08 2015   grade_7                         265.0 229.0                       494.0                         265 229                 494
1165674 1165674 IN     school 1803750 5310   Franklin Township Com Sch Corp 180375002436 5195 Franklin Township Middle Schl East   Regular School No 2.0 06 08 2015   grade_7                         200.0 198.0                       398.0                         200 198                 398
1165678 1165678 IN     school 1803750 5310   Franklin Township Com Sch Corp 180375000598 5197 Franklin Township Middle Sch West   Regular School No 2.0 06 08 2015   grade_7                         161.0 154.0                       315.0                         161 154                 315
1165729 1165729 IN     school 1805670 5330   M S D Lawrence Township 180567001023 5277 Belzer Middle School   Regular School No 2.0 07 08 2015   grade_7                         294.0 270.0                       564.0                         294 270                 564
1165770 1165770 IN     school 1805670 5330   M S D Lawrence Township 180567000139 5291 Fall Creek Valley Middle Sch   Regular School No 2.0 07 08 2015   grade_7                         271.0 277.0                       548.0                         271 277                 548
1165832 1165832 IN     school 1808820 5340   Perry Township Schools 180882001462 5315 Southport Middle School   Regular School No 2.0 07 08 2015   grade_7                         258.0 247.0                       505.0                         258 247                 505
1165835 1165835 IN     school 1808820 5340   Perry Township Schools 180882001463 5319 Perry Meridian Middle School   Regular School No 2.0 07 08 2015   grade_7                         307.0 265.0                       572.0                         307 265                 572
1165949 1165949 IN     school 1808910 5350   M S D Pike Township 180891001488 5355 Lincoln Middle School   Regular School No 2.0 06 08 2015   grade_7                         153.0 106.0                       259.0                         153 106                 259
1165953 1165953 IN     school 1808910 5350   M S D Pike Township 180891001487 5356 Guion Creek Middle School   Regular School No 2.0 06 08 2015   grade_7                         162.0 134.0                       296.0                         162 134                 296
1166001 1166001 IN     school 1808910 5350   M S D Pike Township 180891000513 5380 New Augusta Public Academy-North   Regular School No 2.0 06 08 2015   grade_7                         122.0 146.0                       268.0                         122 146                 268
1166009 1166009 IN     school 1812360 5360   M S D Warren Township 181236001961 5364 Creston Middle School   Regular School No 2.0 07 08 2015   grade_7                         157.0 140.0                       297.0                         157 140                 297
1166012 1166012 IN     school 1812360 5360   M S D Warren Township 181236001970 5367 Stonybrook Middle School   Regular School No 2.0 07 08 2015   grade_7                         185.0 147.0                       332.0                         185 147                 332
1166015 1166015 IN     school 1812360 5360   M S D Warren Township 181236000229 5368 Raymond Park Middle School   Regular School No 2.0 07 08 2015   grade_7                         155.0 154.0                       309.0                         155 154                 309
1166134 1166134 IN     school 1812720 5370   M S D Washington Township 181272002013 5442 Eastwood Middle School   Regular School No 2.0 06 08 2015   grade_7                         153.0 127.0                       280.0                         153 127                 280
1166138 1166138 IN     school 1812720 5370   M S D Washington Township 181272002022 5445 Northview Middle School   Regular School No 2.0 06 08 2015   grade_7                         143.0 121.0                       264.0                         143 121                 264
1166142 1166142 IN     school 1812720 5370   M S D Washington Township 181272002024 5448 Westlane Middle School   Regular School No 2.0 06 08 2015   grade_7                         149.0 130.0                       279.0                         149 130                 279
1166156 1166156 IN     school 1812810 5375   M S D Wayne Township 181281002032 5221 Chapel Hill 7th & 8th Grade Center   Regular School No 2.0 07 08 2015   grade_7                         264.0 256.0                       520.0                         264 256                 520
1166159 1166159 IN     school 1812810 5375   M S D Wayne Township 181281002039 5222 Lynhurst 7th & 8th Grade Center   Regular School No 2.0 07 08 2015   grade_7                         283.0 325.0                       608.0                         283 325                 608
1166239 1166239 IN     school   5375   M S D Wayne Township   5271 Sanders School             2015   grade_7                         11.0 1.0                       12.0                         11 1                 12
1166282 1166282 IN     school 1800450 5380   Beech Grove City Schools 180045000092 5453 Beech Grove Middle School   Regular School No 2.0 07 08 2015   grade_7                         106.0 124.0                       230.0                         106 124                 230
1166340 1166340 IN     school 1804770 5385   Indianapolis Public Schools 180477002527 5503 Key Learning Community Jr High Sch   Regular School No 2.0 06 08 2015   grade_7                         35.0 17.0                       52.0                         35 17                 52
1166344 1166344 IN     school 1804770 5385   Indianapolis Public Schools 180477002525 5507 Shortridge Law & Pub Pol Mag Jr HS   Regular School No 2.0 06 08 2015   grade_7                         99.0 71.0                       170.0                         99 71                 170
1166348 1166348 IN     school 1804770 5385   Indianapolis Public Schools 180477002530 5509 Broad Ripple Mgnt Jr HS-Prfm Arts   Regular School No 2.0 06 08 2015   grade_7                         64.0 93.0                       157.0                         64 93                 157
1166352 1166352 IN     school 1804770 5385   Indianapolis Public Schools 180477002529 5512 Crispus Attucks Med Mgnt Jr HS   Regular School No 2.0 06 08 2015   grade_7                         90.0 211.0                       301.0                         90 211                 301
1166355 1166355 IN     school 1804770 5385   Indianapolis Public Schools 180477002526 5513 George Washington Comm Jr HS   Regular School No 2.0 07 08 2015   grade_7                         136.0 114.0                       250.0                         136 114                 250
1166376 1166376 IN     school 1804770 5385   Indianapolis Public Schools 180477002528 5516 Northwest Community Jr High School   Regular School No 2.0 07 08 2015   grade_7                         104.0 68.0                       172.0                         104 68                 172
1166379 1166379 IN     school 1804770 5385   Indianapolis Public Schools 180477002524 5517 John Marshall Community Jr HS   Regular School No 2.0 07 08 2015   grade_7                         88.0 68.0                       156.0                         88 68                 156
1166395 1166395 IN     school 1804770 5385   Indianapolis Public Schools 180477000866 5531 James A Garfield Sch 31   Regular School No 1.0 KG 08 2015   grade_7                         18.0 14.0                       32.0                         18 14                 32
1166432 1166432 IN     school 1804770 5385   Indianapolis Public Schools 180477000854 5543 James Whitcomb Riley Sch 43   Regular School No 1.0 KG 08 2015   grade_7                         9.0 13.0                       22.0                         9 13                 22
1166451 1166451 IN     school 1804770 5385   Indianapolis Public Schools 180477000817 5546 Daniel Webster School 46   Regular School No 1.0 KG 08 2015   grade_7                         14.0 15.0                       29.0                         14 15                 29
1166504 1166504 IN     school 1804770 5385   Indianapolis Public Schools 180477000831 5556 Francis W Parker School 56   Regular School No 1.0 PK 08 2015   grade_7                         11.0 9.0                       20.0                         11 9                 20
1166587 1166587 IN     school 1804770 5385   Indianapolis Public Schools 180477002439 5577 Merle Sidener Gifted Academy   Regular School No 1.0 02 08 2015   grade_7                         30.0 26.0                       56.0                         30 26                 56
1166620 1166620 IN     school 1804770 5385   Indianapolis Public Schools 180477002555 5587 George W Carver School 87   Regular School No 1.0 PK 08 2015   grade_7                         1.0 6.0                       7.0                         1 6                 7
1166649 1166649 IN     school 1804770 5385   Indianapolis Public Schools 180477002277 5591 Rousseau Mc Clellan 91   Regular School No 1.0 KG 08 2015   grade_7                         15.0 14.0                       29.0                         15 14                 29
1166669 1166669 IN     school 1804770 5385   Indianapolis Public Schools 180477000844 5601 H L Harshman Middle School   Regular School No 2.0 07 08 2015   grade_7                         167.0 124.0                       291.0                         167 124                 291
1166697 1166697 IN     school 1804770 5385   Indianapolis Public Schools 180477000887 5606 Robert Lee Frost School 106   Regular School No 1.0 KG 08 2015   grade_7                         8.0 8.0                       16.0                         8 8                 16
1166754 1166754 IN     school 1804770 5385   Indianapolis Public Schools 180477001440 5635 Center For Inquiry   Regular School No 1.0 KG 08 2015   grade_7                         23.0 23.0                       46.0                         23 23                 46
1166770 1166770 IN     school 1804770 5385   Indianapolis Public Schools 180477002391 5659 Center for Inquiry II   Regular School No 1.0 KG 08 2015   grade_7                         13.0 16.0                       29.0                         13 16                 29
1166788 1166788 IN     school 1804770 5385   Indianapolis Public Schools 180477002510 5668 Center for Inquiry III   Regular School No 1.0 PK 08 2015   grade_7                         8.0 13.0                       21.0                         8 13                 21
1166799 1166799 IN     school 1804770 5385   Indianapolis Public Schools 180477002395 5674 Frederick Douglass School 19   Regular School No 1.0 PK 08 2015   grade_7                         25.0 26.0                       51.0                         25 26                 51
1166818 1166818 IN     school 1800105 5390   Southside Sp Srvs Of Marion Co 180010502502 5320 RISE Learning Center   Regular School No 4.0 KG 12 2015   grade_7                         4.0 1.0                       5.0                         4 1                 5
1166823 1166823 IN     school 1810920 5400   School Town of Speedway 181092001784 5889 Speedway Junior High School   Regular School No 2.0 07 08 2015   grade_7                         77.0 61.0                       138.0                         77 61                 138
1166878 1166878 IN     school 1802520 5455   Culver Community Schools Corp 180252001700 5931 Culver Community Middle Sch   Regular School No 2.0 07 08 2015   grade_7                         31.0 41.0                       72.0                         31 41                 72
1166892 1166892 IN     school 1800180 5470   Argos Community Schools 180018000048 5937 Argos Comm Jr-Sr High School   Regular School No 3.0 07 12 2015   grade_7                         28.0 25.0                       53.0                         28 25                 53
1166908 1166908 IN     school 1800900 5480   Bremen Public Schools 180090000166 5943 Bremen Elem/Middle School   Regular School No 1.0 KG 08 2015   grade_7                         57.0 47.0                       104.0                         57 47                 104
1166925 1166925 IN     school 1809060 5485   Plymouth Community School Corp 180906001499 5949 Lincoln Junior High School   Regular School No 2.0 07 08 2015   grade_7                         144.0 126.0                       270.0                         144 126                 270
1166961 1166961 IN     school 1811490 5495   Triton School Corporation 181149001856 5923 Triton Jr-Sr High Sch   Regular School No 3.0 07 12 2015   grade_7                         30.0 29.0                       59.0                         30 29                 59
1166969 1166969 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_7                         21.0 20.0                       41.0                         21 20                 41
1166990 1166990 IN     school 1806060 5525   Loogootee Community Sch Corp 180606001070 6001 Loogootee Middle School   Regular School No 2.0 05 08 2015   grade_7                         38.0 37.0                       75.0                         38 37                 75
1167009 1167009 IN     school 1806090 5615   Maconaquah School Corp 180609001079 6033 Maconaquah Middle School   Regular School No 2.0 06 08 2015   grade_7                         83.0 80.0                       163.0                         83 80                 163
1167020 1167020 IN     school 1807890 5620   North Miami Community Schools 180789001351 6049 North Miami Middle/High School   Regular School No 3.0 07 12 2015   grade_7                         52.0 37.0                       89.0                         52 37                 89
1167033 1167033 IN     school 1808340 5625   Oak Hill United School Corp 180834001430 2305 Oak Hill Junior High School   Regular School No 2.0 07 08 2015   grade_7                         75.0 72.0                       147.0                         75 72                 147
1167062 1167062 IN     school 1808850 5635   Peru Community Schools 180885001477 6089 Peru Junior High School   Regular School No 2.0 04 09 2015   grade_7                         96.0 74.0                       170.0                         96 74                 170
1167095 1167095 IN     school 1809480 5705   Richland-Bean Blossom C S C 180948001547 6147 Edgewood Junior High School   Regular School No 2.0 06 08 2015   grade_7                         108.0 101.0                       209.0                         108 101                 209
1167162 1167162 IN     school 1800630 5740   Monroe County Com Sch Corp 180063002232 6170 Tri-North Middle School   Regular School No 2.0 07 08 2015   grade_7                         132.0 124.0                       256.0                         132 124                 256
1167165 1167165 IN     school 1800630 5740   Monroe County Com Sch Corp 180063000130 6172 Lora L Batchelor Middle Sch   Regular School No 2.0 07 08 2015   grade_7                         121.0 144.0                       265.0                         121 144                 265
1167231 1167231 IN     school 1800630 5740   Monroe County Com Sch Corp 180063001123 6223 Jackson Creek Middle Sch   Regular School No 2.0 07 08 2015   grade_7                         137.0 156.0                       293.0                         137 156                 293
1167268 1167268 IN     school 1807900 5835   North Montgomery Com Sch Corp 180790002293 6244 Northridge Middle School   Regular School No 2.0 06 08 2015   grade_7                         82.0 75.0                       157.0                         82 75                 157
1167304 1167304 IN     school 1810450 5845   South Montgomery Com Sch Corp 181045002325 6261 Southmont Jr High School   Regular School No 2.0 07 08 2015   grade_7                         75.0 66.0                       141.0                         75 66                 141
1167322 1167322 IN     school 1802460 5855   Crawfordsville Com Schools 180246000289 6281 Crawfordsville Middle School   Regular School No 2.0 06 08 2015   grade_7                         87.0 88.0                       175.0                         87 88                 175
1167337 1167337 IN     school 1804140 5900   Monroe-Gregg School District 180414002129 6315 Monrovia Middle School   Regular School No 2.0 06 08 2015   grade_7                         70.0 65.0                       135.0                         70 65                 135
1167357 1167357 IN     school 1803330 5910   Eminence Community School Corp 180333000454 6325 Eminence Jr-Sr High School   Regular School No 4.0 06 12 2015   grade_7                         16.0 19.0                       35.0                         16 19                 35

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