enrollments

Data source: Big Local News · About: Big Local

3,528 rows where grade = "grade_8" and state = "IN" sorted by white

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_8 · 3,328 ✖
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
1164632 1164632 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_8                         173.0 165.0                       338.0                         173 165                 338
1164647 1164647 IN     school 1802880 4670   School City of East Chicago 180288000365 3937 Carrie Gosch Elementary School   Regular School No 1.0 PK 08 2015   grade_8                         0.0 1.0                       1.0                         0 1                 1
1164685 1164685 IN     school 1802880 4670   School City of East Chicago 180288000370 3963 Joseph Block Middle School   Regular School No 2.0 06 08 2015   grade_8                         85.0 74.0                       159.0                         85 74                 159
1164689 1164689 IN     school 1802880 4670   School City of East Chicago 180288000374 3967 West Side Middle School   Regular School No 2.0 06 08 2015   grade_8                         87.0 88.0                       175.0                         87 88                 175
1164695 1164695 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_8                         64.0 50.0                       114.0                         64 50                 114
1164727 1164727 IN     school 1803870 4690   Gary Community School Corp 180387000613 4053 Benjamin Banneker Achievement Ctr   Regular School No 1.0 KG 08 2015   grade_8                         21.0 27.0                       48.0                         21 27                 48
1164787 1164787 IN     school 1803870 4690   Gary Community School Corp 180387000621 4145 Dunbar-Pulaski Academic & Career   Regular School No 2.0 07 08 2015   grade_8                         192.0 162.0                       354.0                         192 162                 354
1164809 1164809 IN     school 1803870 4690   Gary Community School Corp 180387002199 4168 Wm A Wirt/Emerson VPA   Regular School No 4.0 05 12 2015   grade_8                         17.0 52.0                       69.0                         17 52                 69
1164834 1164834 IN     school 1804170 4700   Griffith Public Schools 180417000721 4177 Griffith Middle School   Regular School No 2.0 07 08 2015   grade_8                         101.0 95.0                       196.0                         101 95                 196
1164859 1164859 IN     school 1804320 4710   School City of Hammond 180432000735 4411 George Rogers Clark Md/HS   Regular School No 4.0 06 12 2015   grade_8                         98.0 114.0                       212.0                         98 114                 212
1164868 1164868 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_8                         126.0 120.0                       246.0                         126 120                 246
1164893 1164893 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_8                         150.0 119.0                       269.0                         150 119                 269
1164897 1164897 IN     school 1804320 4710   School City of Hammond 180432000732 4433 Charles N Scott Middle School   Regular School No 2.0 06 08 2015   grade_8                         126.0 146.0                       272.0                         126 146                 272
1165006 1165006 IN     school 1804560 4720   School Town of Highland 180456000764 4283 Highland Middle School   Regular School No 2.0 06 08 2015   grade_8                         149.0 125.0                       274.0                         149 125                 274
1165044 1165044 IN     school 1804590 4730   School City of Hobart 180459000773 4309 Hobart Middle School   Regular School No 2.0 06 08 2015   grade_8                         144.0 150.0                       294.0                         144 150                 294
1165078 1165078 IN     school 1807350 4740   School Town of Munster 180735001259 4333 Wilbur Wright Middle School   Regular School No 2.0 06 08 2015   grade_8                         160.0 177.0                       337.0                         160 177                 337
1165109 1165109 IN     school 1813200 4760   Whiting School City 181320000398 4356 Whiting Middle School   Regular School No 2.0 06 08 2015   grade_8                         49.0 42.0                       91.0                         49 42                 91
1165141 1165141 IN     school 1807560 4805   New Prairie United School Corp 180756001299 7345 New Prairie Middle School   Regular School No 2.0 06 08 2015   grade_8                         135.0 115.0                       250.0                         135 115                 250
1165163 1165163 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_8                         43.0 37.0                       80.0                         43 37                 80
1165178 1165178 IN     school 1800107 4915   Tri-Township Cons School Corp 180010702520 4696 Wanatah School   Regular School No 1.0 KG 08 2015   grade_8                         18.0 10.0                       28.0                         18 10                 28
1165198 1165198 IN     school 1806570 4925   Michigan City Area Schools 180657001154 4788 Martin T Krueger Middle Sch   Regular School No 2.0 07 08 2015   grade_8                         118.0 98.0                       216.0                         118 98                 216
1165201 1165201 IN     school 1806570 4925   Michigan City Area Schools 180657001140 4789 Barker Middle Sch   Regular School No 2.0 07 08 2015   grade_8                         124.0 124.0                       248.0                         124 124                 248
1165272 1165272 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_8                         36.0 40.0                       76.0                         36 40                 76
1165285 1165285 IN     school 1805580 4945   LaPorte Community School Corp 180558001012 4717 Kesling Middle School   Regular School No 2.0 06 08 2015   grade_8                         136.0 123.0                       259.0                         136 123                 259
1165311 1165311 IN     school 1805580 4945   LaPorte Community School Corp 180558001019 4745 Paul F Boston Middle School   Regular School No 2.0 06 08 2015   grade_8                         133.0 107.0                       240.0                         133 107                 240
1165383 1165383 IN     school 1807860 5075   North Lawrence Com Schools 180786000446 4878 Oolitic Middle School   Regular School No 2.0 06 08 2015   grade_8                         50.0 58.0                       108.0                         50 58                 108
1165401 1165401 IN     school 1807860 5075   North Lawrence Com Schools 180786000461 4891 Shawswick Middle School   Regular School No 2.0 06 08 2015   grade_8                         32.0 34.0                       66.0                         32 34                 66
1165405 1165405 IN     school 1807860 5075   North Lawrence Com Schools 180786001336 4905 Bedford Middle School   Regular School No 2.0 06 08 2015   grade_8                         98.0 89.0                       187.0                         98 89                 187
1165447 1165447 IN     school 1806900 5085   Mitchell Community Schools 180690002151 4924 Mitchell Jr High School   Regular School No 2.0 06 08 2015   grade_8                         81.0 71.0                       152.0                         81 71                 152
1165458 1165458 IN     school 1812880 5245   Frankton-Lapel Community Schs 181288002050 5005 Frankton Jr-Sr High Sch   Regular School No 3.0 07 12 2015   grade_8                         64.0 55.0                       119.0                         64 55                 119
1165477 1165477 IN     school 1812880 5245   Frankton-Lapel Community Schs 181288002418 5012 Lapel Middle School   Regular School No 2.0 06 08 2015   grade_8                         66.0 50.0                       116.0                         66 50                 116
1165501 1165501 IN     school 1810440 5255   South Madison Com Sch Corp 181044001712 5057 Pendleton Heights Middle Sch   Regular School No 2.0 07 08 2015   grade_8                         196.0 194.0                       390.0                         196 194                 390
1165524 1165524 IN     school 1800120 5265   Alexandria Com School Corp 180012000011 5041 Alexandria-Monroe High School   Regular School No 3.0 07 12 2015   grade_8                         63.0 65.0                       128.0                         63 65                 128
1165568 1165568 IN     school 1800150 5275   Anderson Community School Corp 180015002483 5076 Highland Middle School   Regular School No 2.0 06 08 2015   grade_8                         282.0 212.0                       494.0                         282 212                 494
1165595 1165595 IN     school 1803300 5280   Elwood Community School Corp 180330000449 5149 Elwood Jr-Sr High School   Regular School No 3.0 07 12 2015   grade_8                         71.0 62.0                       133.0                         71 62                 133
1165629 1165629 IN     school 1802640 5300   M S D Decatur Township 180264000313 5181 Decatur Middle Sch   Regular School No 2.0 07 08 2015   grade_8                         244.0 214.0                       458.0                         244 214                 458
1165648 1165648 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_8                         16.0 16.0                       32.0                         16 16                 32
1165675 1165675 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_8                         198.0 210.0                       408.0                         198 210                 408
1165679 1165679 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_8                         158.0 137.0                       295.0                         158 137                 295
1165730 1165730 IN     school 1805670 5330   M S D Lawrence Township 180567001023 5277 Belzer Middle School   Regular School No 2.0 07 08 2015   grade_8                         317.0 278.0                       595.0                         317 278                 595
1165771 1165771 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_8                         302.0 309.0                       611.0                         302 309                 611
1165833 1165833 IN     school 1808820 5340   Perry Township Schools 180882001462 5315 Southport Middle School   Regular School No 2.0 07 08 2015   grade_8                         264.0 265.0                       529.0                         264 265                 529
1165836 1165836 IN     school 1808820 5340   Perry Township Schools 180882001463 5319 Perry Meridian Middle School   Regular School No 2.0 07 08 2015   grade_8                         309.0 313.0                       622.0                         309 313                 622
1165950 1165950 IN     school 1808910 5350   M S D Pike Township 180891001488 5355 Lincoln Middle School   Regular School No 2.0 06 08 2015   grade_8                         151.0 145.0                       296.0                         151 145                 296
1165954 1165954 IN     school 1808910 5350   M S D Pike Township 180891001487 5356 Guion Creek Middle School   Regular School No 2.0 06 08 2015   grade_8                         164.0 146.0                       310.0                         164 146                 310
1166002 1166002 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_8                         133.0 135.0                       268.0                         133 135                 268
1166010 1166010 IN     school 1812360 5360   M S D Warren Township 181236001961 5364 Creston Middle School   Regular School No 2.0 07 08 2015   grade_8                         176.0 160.0                       336.0                         176 160                 336
1166013 1166013 IN     school 1812360 5360   M S D Warren Township 181236001970 5367 Stonybrook Middle School   Regular School No 2.0 07 08 2015   grade_8                         137.0 158.0                       295.0                         137 158                 295
1166016 1166016 IN     school 1812360 5360   M S D Warren Township 181236000229 5368 Raymond Park Middle School   Regular School No 2.0 07 08 2015   grade_8                         176.0 139.0                       315.0                         176 139                 315
1166135 1166135 IN     school 1812720 5370   M S D Washington Township 181272002013 5442 Eastwood Middle School   Regular School No 2.0 06 08 2015   grade_8                         147.0 140.0                       287.0                         147 140                 287
1166139 1166139 IN     school 1812720 5370   M S D Washington Township 181272002022 5445 Northview Middle School   Regular School No 2.0 06 08 2015   grade_8                         135.0 147.0                       282.0                         135 147                 282
1166143 1166143 IN     school 1812720 5370   M S D Washington Township 181272002024 5448 Westlane Middle School   Regular School No 2.0 06 08 2015   grade_8                         176.0 158.0                       334.0                         176 158                 334
1166157 1166157 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_8                         316.0 269.0                       585.0                         316 269                 585
1166160 1166160 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_8                         320.0 313.0                       633.0                         320 313                 633
1166240 1166240 IN     school   5375   M S D Wayne Township   5271 Sanders School             2015   grade_8                         6.0 0.0                       6.0                         6 0                 6
1166283 1166283 IN     school 1800450 5380   Beech Grove City Schools 180045000092 5453 Beech Grove Middle School   Regular School No 2.0 07 08 2015   grade_8                         127.0 124.0                       251.0                         127 124                 251
1166341 1166341 IN     school 1804770 5385   Indianapolis Public Schools 180477002527 5503 Key Learning Community Jr High Sch   Regular School No 2.0 06 08 2015   grade_8                         19.0 21.0                       40.0                         19 21                 40
1166345 1166345 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_8                         68.0 77.0                       145.0                         68 77                 145
1166349 1166349 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_8                         77.0 94.0                       171.0                         77 94                 171
1166353 1166353 IN     school 1804770 5385   Indianapolis Public Schools 180477002529 5512 Crispus Attucks Med Mgnt Jr HS   Regular School No 2.0 06 08 2015   grade_8                         80.0 161.0                       241.0                         80 161                 241
1166356 1166356 IN     school 1804770 5385   Indianapolis Public Schools 180477002526 5513 George Washington Comm Jr HS   Regular School No 2.0 07 08 2015   grade_8                         195.0 133.0                       328.0                         195 133                 328
1166377 1166377 IN     school 1804770 5385   Indianapolis Public Schools 180477002528 5516 Northwest Community Jr High School   Regular School No 2.0 07 08 2015   grade_8                         111.0 84.0                       195.0                         111 84                 195
1166380 1166380 IN     school 1804770 5385   Indianapolis Public Schools 180477002524 5517 John Marshall Community Jr HS   Regular School No 2.0 07 08 2015   grade_8                         93.0 91.0                       184.0                         93 91                 184
1166396 1166396 IN     school 1804770 5385   Indianapolis Public Schools 180477000866 5531 James A Garfield Sch 31   Regular School No 1.0 KG 08 2015   grade_8                         4.0 13.0                       17.0                         4 13                 17
1166433 1166433 IN     school 1804770 5385   Indianapolis Public Schools 180477000854 5543 James Whitcomb Riley Sch 43   Regular School No 1.0 KG 08 2015   grade_8                         9.0 7.0                       16.0                         9 7                 16
1166452 1166452 IN     school 1804770 5385   Indianapolis Public Schools 180477000817 5546 Daniel Webster School 46   Regular School No 1.0 KG 08 2015   grade_8                         17.0 20.0                       37.0                         17 20                 37
1166505 1166505 IN     school 1804770 5385   Indianapolis Public Schools 180477000831 5556 Francis W Parker School 56   Regular School No 1.0 PK 08 2015   grade_8                         5.0 8.0                       13.0                         5 8                 13
1166588 1166588 IN     school 1804770 5385   Indianapolis Public Schools 180477002439 5577 Merle Sidener Gifted Academy   Regular School No 1.0 02 08 2015   grade_8                         20.0 24.0                       44.0                         20 24                 44
1166621 1166621 IN     school 1804770 5385   Indianapolis Public Schools 180477002555 5587 George W Carver School 87   Regular School No 1.0 PK 08 2015   grade_8                         14.0 5.0                       19.0                         14 5                 19
1166650 1166650 IN     school 1804770 5385   Indianapolis Public Schools 180477002277 5591 Rousseau Mc Clellan 91   Regular School No 1.0 KG 08 2015   grade_8                         9.0 23.0                       32.0                         9 23                 32
1166670 1166670 IN     school 1804770 5385   Indianapolis Public Schools 180477000844 5601 H L Harshman Middle School   Regular School No 2.0 07 08 2015   grade_8                         184.0 112.0                       296.0                         184 112                 296
1166698 1166698 IN     school 1804770 5385   Indianapolis Public Schools 180477000887 5606 Robert Lee Frost School 106   Regular School No 1.0 KG 08 2015   grade_8                         10.0 7.0                       17.0                         10 7                 17
1166755 1166755 IN     school 1804770 5385   Indianapolis Public Schools 180477001440 5635 Center For Inquiry   Regular School No 1.0 KG 08 2015   grade_8                         8.0 18.0                       26.0                         8 18                 26
1166771 1166771 IN     school 1804770 5385   Indianapolis Public Schools 180477002391 5659 Center for Inquiry II   Regular School No 1.0 KG 08 2015   grade_8                         17.0 17.0                       34.0                         17 17                 34
1166789 1166789 IN     school 1804770 5385   Indianapolis Public Schools 180477002510 5668 Center for Inquiry III   Regular School No 1.0 PK 08 2015   grade_8                         8.0 9.0                       17.0                         8 9                 17
1166800 1166800 IN     school 1804770 5385   Indianapolis Public Schools 180477002395 5674 Frederick Douglass School 19   Regular School No 1.0 PK 08 2015   grade_8                         21.0 13.0                       34.0                         21 13                 34
1166819 1166819 IN     school 1800105 5390   Southside Sp Srvs Of Marion Co 180010502502 5320 RISE Learning Center   Regular School No 4.0 KG 12 2015   grade_8                         8.0 3.0                       11.0                         8 3                 11
1166824 1166824 IN     school 1810920 5400   School Town of Speedway 181092001784 5889 Speedway Junior High School   Regular School No 2.0 07 08 2015   grade_8                         87.0 61.0                       148.0                         87 61                 148
1166879 1166879 IN     school 1802520 5455   Culver Community Schools Corp 180252001700 5931 Culver Community Middle Sch   Regular School No 2.0 07 08 2015   grade_8                         29.0 42.0                       71.0                         29 42                 71
1166893 1166893 IN     school 1800180 5470   Argos Community Schools 180018000048 5937 Argos Comm Jr-Sr High School   Regular School No 3.0 07 12 2015   grade_8                         33.0 23.0                       56.0                         33 23                 56
1166909 1166909 IN     school 1800900 5480   Bremen Public Schools 180090000166 5943 Bremen Elem/Middle School   Regular School No 1.0 KG 08 2015   grade_8                         63.0 67.0                       130.0                         63 67                 130
1166926 1166926 IN     school 1809060 5485   Plymouth Community School Corp 180906001499 5949 Lincoln Junior High School   Regular School No 2.0 07 08 2015   grade_8                         168.0 158.0                       326.0                         168 158                 326
1166962 1166962 IN     school 1811490 5495   Triton School Corporation 181149001856 5923 Triton Jr-Sr High Sch   Regular School No 3.0 07 12 2015   grade_8                         47.0 43.0                       90.0                         47 43                 90
1166970 1166970 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_8                         26.0 23.0                       49.0                         26 23                 49
1166991 1166991 IN     school 1806060 5525   Loogootee Community Sch Corp 180606001070 6001 Loogootee Middle School   Regular School No 2.0 05 08 2015   grade_8                         48.0 36.0                       84.0                         48 36                 84
1167010 1167010 IN     school 1806090 5615   Maconaquah School Corp 180609001079 6033 Maconaquah Middle School   Regular School No 2.0 06 08 2015   grade_8                         85.0 80.0                       165.0                         85 80                 165
1167021 1167021 IN     school 1807890 5620   North Miami Community Schools 180789001351 6049 North Miami Middle/High School   Regular School No 3.0 07 12 2015   grade_8                         38.0 39.0                       77.0                         38 39                 77
1167034 1167034 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_8                         81.0 73.0                       154.0                         81 73                 154
1167063 1167063 IN     school 1808850 5635   Peru Community Schools 180885001477 6089 Peru Junior High School   Regular School No 2.0 04 09 2015   grade_8                         98.0 71.0                       169.0                         98 71                 169
1167096 1167096 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_8                         121.0 102.0                       223.0                         121 102                 223
1167163 1167163 IN     school 1800630 5740   Monroe County Com Sch Corp 180063002232 6170 Tri-North Middle School   Regular School No 2.0 07 08 2015   grade_8                         152.0 127.0                       279.0                         152 127                 279
1167166 1167166 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_8                         130.0 147.0                       277.0                         130 147                 277
1167232 1167232 IN     school 1800630 5740   Monroe County Com Sch Corp 180063001123 6223 Jackson Creek Middle Sch   Regular School No 2.0 07 08 2015   grade_8                         146.0 137.0                       283.0                         146 137                 283
1167269 1167269 IN     school 1807900 5835   North Montgomery Com Sch Corp 180790002293 6244 Northridge Middle School   Regular School No 2.0 06 08 2015   grade_8                         91.0 86.0                       177.0                         91 86                 177
1167305 1167305 IN     school 1810450 5845   South Montgomery Com Sch Corp 181045002325 6261 Southmont Jr High School   Regular School No 2.0 07 08 2015   grade_8                         80.0 56.0                       136.0                         80 56                 136
1167323 1167323 IN     school 1802460 5855   Crawfordsville Com Schools 180246000289 6281 Crawfordsville Middle School   Regular School No 2.0 06 08 2015   grade_8                         97.0 83.0                       180.0                         97 83                 180
1167338 1167338 IN     school 1804140 5900   Monroe-Gregg School District 180414002129 6315 Monrovia Middle School   Regular School No 2.0 06 08 2015   grade_8                         77.0 47.0                       124.0                         77 47                 124
1167358 1167358 IN     school 1803330 5910   Eminence Community School Corp 180333000454 6325 Eminence Jr-Sr High School   Regular School No 4.0 06 12 2015   grade_8                         22.0 16.0                       38.0                         22 16                 38
1167382 1167382 IN     school 1806510 5925   M S D Martinsville Schools 180651001136 6331 Martinsville West Middle Sch   Regular School No 2.0 06 08 2015   grade_8                         106.0 95.0                       201.0                         106 95                 201
1167386 1167386 IN     school 1806510 5925   M S D Martinsville Schools 180651001134 6333 Ronald K Bell East Middle School   Regular School No 2.0 06 08 2015   grade_8                         115.0 107.0                       222.0                         115 107                 222

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