enrollments

Data source: Big Local News · About: Big Local

502 rows where grade = "grade_8", state = "IN" and year = 2015 sorted by male

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2015 · 502 ✖

grade ✖

  • grade_8 · 502 ✖
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
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
1170764 1170764 IN     school 1800006 9100   IN Department of Correction 180000601943 5452 Madison Juvenile Corr Fac   Regular School No 3.0 08 12 2015   grade_8                         0.0 2.0                       2.0                         0 2                 2
1171498 1171498 IN     school 1800139 9940   Tindley Collegiate Academy 180013902559 5914 Tindley Collegiate Academy   Regular School Yes 2.0 05 08 2015   grade_8                         0.0 97.0                       97.0                         0 97                 97
1159644 1159644 IN     school 1803630 235   Fort Wayne Community Schools 180363002174 100 Allen Co Juvenile Center   Regular School No 3.0 07 12 2015   grade_8                         1.0 0.0                       1.0                         1 0                 1
1168953 1168953 IN     school 1810290 7205   South Bend Community Sch Corp 181029000898 7632 Juvenile Justice Center   Alternative Education School No 3.0 07 12 2015   grade_8                         1.0 0.0                       1.0                         1 0                 1
1169101 1169101 IN     school 1810140 7365   Shelbyville Central Schools 181014002496 7671 Especially Kidz Health & Rehab Cnt   Regular School No 4.0 PK 12 2015   grade_8                         1.0 0.0                       1.0                         1 0                 1
1171336 1171336 IN     school 1800075 9830   Beacon Academy 180007502428 8411 Beacon Academy   Regular School Yes 3.0 08 12 2015   grade_8                         1.0 2.0                       3.0                         1 2                 3
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
1171329 1171329 IN     school 1800072 9805   Hoosier Academy - Indianapolis 180007202422 2527 Hoosier Academy - Indianapolis   Regular School Yes 4.0 KG 12 2015   grade_8                         10.0 20.0                       30.0                         10 20                 30
1171390 1171390 IN     school 1800088 9870   Discovery Charter School 180008802495 6824 Discovery Charter School   Regular School Yes 1.0 KG 08 2015   grade_8                         10.0 9.0                       19.0                         10 9                 19
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
1167627 1167627 IN     school 1812900 6065   West Noble School Corporation 181290002059 6509 West Noble Middle School   Regular School No 2.0 05 08 2015   grade_8                         102.0 100.0                       202.0                         102 100                 202
1164125 1164125 IN     school 1805550 4345   Wawasee Community School Corp 180555002354 3630 Wawasee Middle School   Regular School No 2.0 06 08 2015   grade_8                         103.0 97.0                       200.0                         103 97                 200
1162247 1162247 IN     school 1806870 2855   Mississinewa Community School Corp 180687001190 2335 R J Baskett Middle School   Regular School No 2.0 06 08 2015   grade_8                         104.0 99.0                       203.0                         104 99                 203
1162890 1162890 IN     school 1800690 3180   North Harrison Com School Corp 180069000145 2625 North Harrison Middle School   Regular School No 2.0 06 08 2015   grade_8                         104.0 93.0                       197.0                         104 93                 197
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
1168544 1168544 IN     school 1809750 6995   Rush County Schools 180975002240 7290 Benjamin Rush Middle Sch   Regular School No 2.0 07 08 2015   grade_8                         106.0 98.0                       204.0                         106 98                 204
1169581 1169581 IN     school 1812870 7875   West Lafayette Com School Corp 181287002048 8129 West Lafayette Jr/Sr High Sch   Regular School No 3.0 07 12 2015   grade_8                         106.0 92.0                       198.0                         106 92                 198
1161019 1161019 IN     school 1800240 1600   South Dearborn Com School Corp 180024000958 1172 South Dearborn Middle Sch   Regular School No 2.0 07 08 2015   grade_8                         107.0 115.0                       222.0                         107 115                 222
1163697 1163697 IN     school 1804980 3945   Jay School Corp 180498000912 3265 East Jay County Middle School   Regular School No 2.0 06 08 2015   grade_8                         107.0 86.0                       193.0                         107 86                 193
1168599 1168599 IN     school 1808760 7175   Penn-Harris-Madison Sch Corp 180876001453 7336 Virgil I Grissom Middle Sch   Regular School No 2.0 06 08 2015   grade_8                         107.0 102.0                       209.0                         107 102                 209
1169793 1169793 IN     school 1803450 7995   Evansville Vanderburgh Sch Corp 180345000471 8318 Helfrich Park STEM Academy   Regular School No 2.0 06 08 2015   grade_8                         107.0 97.0                       204.0                         107 97                 204
1160024 1160024 IN     school 1802850 255   East Allen County Schools 180285000354 301 New Haven Middle School   Regular School No 2.0 06 08 2015   grade_8                         108.0 76.0                       184.0                         108 76                 184
1161261 1161261 IN     school 1807230 1910   Yorktown Community Schools 180723001218 1387 Yorktown Middle School   Regular School No 2.0 06 08 2015   grade_8                         108.0 105.0                       213.0                         108 105                 213
1163534 1163534 IN     school 1801230 3640   Medora Community School Corp 180123000201 3093 Medora Jr & Sr High School   Regular School No 4.0 06 12 2015   grade_8                         11.0 10.0                       21.0                         11 10                 21
1169358 1169358 IN     school 1810860 7715   Southwest School Corp 181086001770 7953 Carlisle Elem and Junior High   Regular School No 1.0 PK 08 2015   grade_8                         11.0 9.0                       20.0                         11 9                 20
1171265 1171265 IN     school 1800131 9760   Smith Academy for Excellence 180013102539 242 Smith Academy for Excellence   Regular School Yes 4.0 03 11 2015   grade_8                         11.0 0.0                       11.0                         11 0                 11
1171356 1171356 IN     school 1800087 9845   Xavier School of Excellence 180008702445 7571 Xavier School of Excellence   Regular School Yes 1.0 KG 08 2015   grade_8                         11.0 13.0                       24.0                         11 13                 24
1169840 1169840 IN     school 1803450 7995   Evansville Vanderburgh Sch Corp 180345000481 8349 Plaza Park International Prep Acad   Regular School No 2.0 06 08 2015   grade_8                         110.0 108.0                       218.0                         110 108                 218
1159973 1159973 IN     school 1802850 255   East Allen County Schools 180285000349 49 Leo Junior/Senior High School   Regular School No 3.0 07 12 2015   grade_8                         111.0 99.0                       210.0                         111 99                 210
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
1161095 1161095 IN     school 1804080 1730   Greensburg Community Schools 180408000705 1269 Greensburg Community Jr High   Regular School No 2.0 06 08 2015   grade_8                         112.0 96.0                       208.0                         112 96                 208
1161306 1161306 IN     school 1807320 1970   Muncie Community Schools 180732002320 1431 Northside Middle School   Regular School No 2.0 06 08 2015   grade_8                         112.0 116.0                       228.0                         112 116                 228
1159701 1159701 IN     school 1803630 235   Fort Wayne Community Schools 180363000553 129 Northwood Middle School   Regular School No 2.0 06 08 2015   grade_8                         113.0 126.0                       239.0                         113 126                 239
1161191 1161191 IN     school 1802660 1875   Delaware Community School Corp 180266000323 1367 Delta Middle School   Regular School No 2.0 06 09 2015   grade_8                         113.0 119.0                       232.0                         113 119                 232
1161923 1161923 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741001271 1933 Hazelwood Middle School   Regular School No 2.0 05 08 2015   grade_8                         113.0 128.0                       241.0                         113 128                 241
1167696 1167696 IN     school 1810950 6195   Spencer-Owen Community Schools 181095001790 6597 Owen Valley Middle School   Regular School No 2.0 07 08 2015   grade_8                         113.0 119.0                       232.0                         113 119                 232
1161607 1161607 IN     school 1812240 2285   Wa-Nee Community Schools 181224001958 1669 North Wood Middle School   Regular School No 2.0 06 09 2015   grade_8                         114.0 130.0                       244.0                         114 130                 244
1164093 1164093 IN     school 1812120 4335   Vincennes Community Sch Corp 181212001928 3557 George Rogers Clark Sch   Regular School No 2.0 06 08 2015   grade_8                         114.0 86.0                       200.0                         114 86                 200
1164382 1164382 IN     school 1804350 4580   Hanover Community School Corp 180435001908 3784 Hanover Central Middle School   Regular School No 2.0 06 08 2015   grade_8                         114.0 71.0                       185.0                         114 71                 185
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
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
1160264 1160264 IN     school 1802830 630   Zionsville Community Schools 180283002046 510 Zionsville West Middle School   Regular School No 1.0 03 08 2015   grade_8                         119.0 97.0                       216.0                         119 97                 216
1160512 1160512 IN     school 1809370 940   West Clark Community Schools 180937001537 781 Silver Creek Middle School   Regular School No 2.0 06 08 2015   grade_8                         119.0 135.0                       254.0                         119 135                 254
1163121 1163121 IN     school 1802550 3325   Danville Community School Corp 180255000305 2743 Danville Middle School   Regular School No 2.0 04 08 2015   grade_8                         120.0 97.0                       217.0                         120 97                 217
1159580 1159580 IN     school 1808250 225   Northwest Allen County Schools 180825001380 79 Maple Creek Middle Sch   Regular School No 2.0 06 08 2015   grade_8                         121.0 136.0                       257.0                         121 136                 257
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
1169946 1169946 IN     school 1812090 8030   Vigo County School Corp 181209001907 8445 Honey Creek Middle Sch   Regular School No 2.0 06 08 2015   grade_8                         121.0 139.0                       260.0                         121 139                 260
1164462 1164462 IN     school 1805450 4615   Lake Central School Corp 180545000985 3831 Michael Grimmer Middle School   Regular School No 2.0 05 08 2015   grade_8                         122.0 117.0                       239.0                         122 117                 239
1164296 1164296 IN     school 1813110 4525   Westview School Corporation 181311002079 3697 Westview Jr-Sr High School   Regular School No 4.0 06 12 2015   grade_8                         123.0 91.0                       214.0                         123 91                 214
1159677 1159677 IN     school 1803630 235   Fort Wayne Community Schools 180363000534 119 Jefferson Middle School   Regular School No 2.0 06 08 2015   grade_8                         124.0 108.0                       232.0                         124 108                 232
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
1169528 1169528 IN     school 1811340 7865   Tippecanoe School Corp 181134001822 8025 Battle Ground Middle School   Regular School No 2.0 06 08 2015   grade_8                         124.0 78.0                       202.0                         124 78                 202
1163383 1163383 IN     school 1804470 3490   Western School Corp 180447002225 2922 Western Middle School   Regular School No 2.0 06 08 2015   grade_8                         125.0 113.0                       238.0                         125 113                 238
1163474 1163474 IN     school 1804710 3625   Huntington Co Com Sch Corp 180471000790 3025 Riverview School   Regular School No 2.0 06 08 2015   grade_8                         125.0 92.0                       217.0                         125 92                 217
1160802 1160802 IN     school 1803660 1170   Community Schools of Frankfort 180366000573 999 Frankfort Middle School   Regular School No 2.0 06 08 2015   grade_8                         126.0 138.0                       264.0                         126 138                 264
1162770 1162770 IN     school 1810710 3115   Southern Hancock Co Com Sch Corp 181071001759 2566 Doe Creek Middle School   Regular School No 2.0 07 08 2015   grade_8                         126.0 162.0                       288.0                         126 162                 288
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
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
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
1170232 1170232 IN     school 1812390 8130   Warrick County School Corp 181239002454 8760 Castle South Middle School   Regular School No 2.0 06 08 2015   grade_8                         127.0 123.0                       250.0                         127 123                 250
1169297 1169297 IN     school 1811100 7615   M S D Steuben County 181110001798 7895 Angola Middle School   Regular School No 2.0 06 08 2015   grade_8                         128.0 122.0                       250.0                         128 122                 250
1163747 1163747 IN     school 1806120 3995   Madison Consolidated Schools 180612001091 3313 Madison Consolidated Jr High Sch   Regular School No 2.0 06 08 2015   grade_8                         129.0 113.0                       242.0                         129 113                 242
1168692 1168692 IN     school 1806840 7200   School City of Mishawaka 180684000531 7467 Joint Service Campus Program   Special Education School No 4.0 03 12 2015   grade_8                         13.0 3.0                       16.0                         13 3                 16
1171025 1171025 IN     school 1800048 9555   East Chicago Urban Enterprise Acad 180004802163 3935 East Chicago Urban Enterprise Acad   Regular School Yes 1.0 KG 08 2015   grade_8                         13.0 22.0                       35.0                         13 22                 35
1171140 1171140 IN     school 1800061 9665   Geist Montessori Academy 180006102387 2572 Geist Montessori Academy   Regular School Yes 1.0 KG 08 2015   grade_8                         13.0 10.0                       23.0                         13 10                 23
1171204 1171204 IN     school 1800096 9720   Padua Academy 180009602470 5786 Padua Academy   Regular School Yes 1.0 KG 08 2015   grade_8                         13.0 15.0                       28.0                         13 15                 28
1161928 1161928 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741001276 1937 Nathaniel Scribner Middle School   Regular School No 2.0 05 08 2015   grade_8                         130.0 129.0                       259.0                         130 129                 259
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
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
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
1159537 1159537 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000116 63 Summit Middle School   Regular School No 2.0 06 08 2015   grade_8                         134.0 109.0                       243.0                         134 109                 243
1168095 1168095 IN     school 1811970 6560   Valparaiso Community Schools 181197001881 6885 Benjamin Franklin Mid Sch   Regular School No 2.0 06 08 2015   grade_8                         134.0 143.0                       277.0                         134 143                 277
1170298 1170298 IN     school 1812390 8130   Warrick County School Corp 181239001976 8793 Boonville Middle School   Regular School No 2.0 06 08 2015   grade_8                         134.0 120.0                       254.0                         134 120                 254
1160269 1160269 IN     school 1802830 630   Zionsville Community Schools 180283000342 511 Zionsville Middle School   Regular School No 2.0 05 08 2015   grade_8                         135.0 145.0                       280.0                         135 145                 280
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
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
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
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
1169804 1169804 IN     school 1803450 7995   Evansville Vanderburgh Sch Corp 180345000486 8323 Thompkins Middle School   Regular School No 2.0 06 08 2015   grade_8                         137.0 100.0                       237.0                         137 100                 237
1159898 1159898 IN     school 1803630 235   Fort Wayne Community Schools 180363000560 240 Shawnee Middle School   Regular School No 2.0 06 08 2015   grade_8                         138.0 161.0                       299.0                         138 161                 299
1161310 1161310 IN     school 1807320 1970   Muncie Community Schools 180732001252 1437 Southside Middle School   Regular School No 2.0 06 08 2015   grade_8                         138.0 98.0                       236.0                         138 98                 236
1162267 1162267 IN     school 1806390 2865   Marion Community Schools 180639001112 2357 John L McCulloch Junior High Sch   Regular School No 2.0 07 08 2015   grade_8                         138.0 116.0                       254.0                         138 116                 254
1168099 1168099 IN     school 1811970 6560   Valparaiso Community Schools 181197001890 6887 Thomas Jefferson Middle Sch   Regular School No 2.0 06 08 2015   grade_8                         138.0 121.0                       259.0                         138 121                 259
1170273 1170273 IN     school 1812390 8130   Warrick County School Corp 181239001978 8775 Castle North Middle School   Regular School No 2.0 06 08 2015   grade_8                         138.0 136.0                       274.0                         138 136                 274
1164480 1164480 IN     school 1805450 4615   Lake Central School Corp 180545002420 3838 Hal E Clark Middle School   Regular School No 2.0 05 08 2015   grade_8                         139.0 143.0                       282.0                         139 143                 282
1164498 1164498 IN     school 1805450 4615   Lake Central School Corp 180545000982 3841 Kahler Middle School   Regular School No 2.0 05 08 2015   grade_8                         139.0 142.0                       281.0                         139 142                 281
1161376 1161376 IN     school 1807320 1970   Muncie Community Schools 180732001232 1524 Youth Opportunity Center   Alternative Education School No 4.0 03 12 2015   grade_8                         14.0 4.0                       18.0                         14 4                 18
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
1161461 1161461 IN     school 1803960 2120   Greater Jasper Con Schs 180396000686 1575 Jasper Middle School   Regular School No 2.0 06 08 2015   grade_8                         141.0 139.0                       280.0                         141 139                 280
1163630 1163630 IN     school 1805280 3785   Kankakee Valley School Corp 180528000934 3183 Kankakee Valley Middle School   Regular School No 2.0 06 08 2015   grade_8                         144.0 130.0                       274.0                         144 130                 274
1163923 1163923 IN     school 1801440 4205   Center Grove Com Sch Corp 180144001912 3443 Center Grove Middle School North   Regular School No 2.0 06 08 2015   grade_8                         144.0 140.0                       284.0                         144 140                 284
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
1169972 1169972 IN     school 1812090 8030   Vigo County School Corp 181209001925 8485 Woodrow Wilson Middle Sch   Regular School No 2.0 06 08 2015   grade_8                         144.0 154.0                       298.0                         144 154                 298
1164192 1164192 IN     school 1812420 4415   Warsaw Community Schools 181242002000 3653 Edgewood Middle School   Regular School No 2.0 07 08 2015   grade_8                         146.0 119.0                       265.0                         146 119                 265
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
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
1160970 1160970 IN     school 1811190 1560   Sunman-Dearborn Com Sch Corp 181119002300 1190 Sunman-Dearborn Middle School   Regular School No 2.0 07 08 2015   grade_8                         148.0 162.0                       310.0                         148 162                 310
1163008 1163008 IN     school 1801020 3305   Brownsburg Community Sch Corp 180102000178 2713 Brownsburg West Middle School   Regular School No 2.0 06 08 2015   grade_8                         148.0 150.0                       298.0                         148 150                 298
1164545 1164545 IN     school 1811460 4645   Tri-Creek School Corporation 181146001851 3851 Lowell Middle School   Regular School No 2.0 05 08 2015   grade_8                         148.0 152.0                       300.0                         148 152                 300

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