enrollments

Data source: Big Local News · About: Big Local

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

✎ 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
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
1160684 1160684 IN     school 1803940 1010   Greater Clark County Schools 180394000832 886 Old Corden Porter School   Special Education School No 4.0 04 12 2015   grade_8                         8.0 0.0                       8.0                         8 0                 8
1162677 1162677 IN     school 1807650 3070   Noblesville Schools 180765002369 2514 MOSAICS School   Special Education School No 3.0 07 12 2015   grade_8                         4.0 0.0                       4.0                         4 0                 4
1163378 1163378 IN     school 1804470 3490   Western School Corp 180447000756 2921 Western High School   Regular School No 4.0 04 12 2015   grade_8                         3.0 0.0                       3.0                         3 0                 3
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
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
1170745 1170745 IN     school 1800006 9100   IN Department of Correction 180000601946 732 Logansport Juvenile Cor Fac   Regular School No 3.0 07 12 2015   grade_8                         3.0 0.0                       3.0                         3 0                 3
1170757 1170757 IN     school 1800006 9100   IN Department of Correction 180000601935 5055 Pendleton Juv Correctional Fac   Regular School No 3.0 08 12 2015   grade_8                         2.0 0.0                       2.0                         2 0                 2
1171062 1171062 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 Indiana School For The Blind   Alternative Education School No 4.0 PK 12 2015   grade_8                         8.0 0.0                       8.0                         8 0                 8
1171242 1171242 IN     school 1800128 9745   Tindley Preparatory Academy 180012802545 5336 Tindley Preparatory Academy   Regular School Yes 2.0 05 08 2015   grade_8                         85.0 0.0                       85.0                         85 0                 85
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
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
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
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
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
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
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
1161482 1161482 IN     school 1803480 2155   Fairfield Community Schools 180348000491 1613 Fairfield Jr-Sr High School   Regular School No 3.0 07 12 2015   grade_8                         85.0 101.0                       186.0                         85 101                 186
1170731 1170731 IN     school 1800127 8825   CSUSA Donnan 180012700823 5572 Emma Donnan Middle School   Regular School No 2.0 07 08 2015   grade_8                         91.0 101.0                       192.0                         91 101                 192
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
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
1160938 1160938 IN     school 1812450 1405   Washington Com Schools 181245002007 1123 Washington Junior High School   Regular School No 2.0 07 08 2015   grade_8                         93.0 103.0                       196.0                         93 103                 196
1168798 1168798 IN     school 1810290 7205   South Bend Community Sch Corp 181029001709 7512 LaSalle Intermediate Academy   Regular School No 2.0 05 08 2015   grade_8                         93.0 103.0                       196.0                         93 103                 196
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
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
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
1170640 1170640 IN     school 1811580 8565   Twin Lakes School Corp 181158001862 9153 Roosevelt Middle Sch   Regular School No 2.0 06 08 2015   grade_8                         94.0 107.0                       201.0                         94 107                 201
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
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
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
1171346 1171346 IN     school 1800083 9835   The Bloomington Project School 180008302446 6215 The Bloomington Project School   Regular School Yes 1.0 KG 08 2015   grade_8                         17.0 11.0                       28.0                         17 11                 28
1170464 1170464 IN     school 1809510 8385   Richmond Community Schools 180951001555 9001 Dennis Intermediate School   Regular School No 2.0 05 08 2015   grade_8                         98.0 110.0                       208.0                         98 110                 208
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
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
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
1169567 1169567 IN     school 1811340 7865   Tippecanoe School Corp 181134001920 8049 Wea Ridge Middle School   Regular School No 2.0 06 08 2015   grade_8                         89.0 113.0                       202.0                         89 113                 202
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
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
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
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
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
1159697 1159697 IN     school 1803630 235   Fort Wayne Community Schools 180363000548 128 Miami Middle School   Regular School No 2.0 06 08 2015   grade_8                         151.0 117.0                       268.0                         151 117                 268
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
1163245 1163245 IN     school 1807440 3445   New Castle Community Sch Corp 180744001288 2829 New Castle Middle School   Regular School No 2.0 07 08 2015   grade_8                         160.0 118.0                       278.0                         160 118                 278
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
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
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
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
1160629 1160629 IN     school 1803940 1010   Greater Clark County Schools 180394000674 853 Parkview Middle School   Regular School No 2.0 06 08 2015   grade_8                         160.0 120.0                       280.0                         160 120                 280
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
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
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
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
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
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
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
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
1170687 1170687 IN     school 1802280 8665   Whitley Co Cons Schools 180228000824 9180 Indian Springs Middle Sch   Regular School No 2.0 06 08 2015   grade_8                         149.0 124.0                       273.0                         149 124                 273
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
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
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
1168033 1168033 IN     school 1809150 6550   Portage Township Schools 180915001519 6859 William Fegely Middle School   Regular School No 2.0 06 08 2015   grade_8                         149.0 127.0                       276.0                         149 127                 276
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
1160732 1160732 IN     school 1800840 1125   Clay Community Schools 180084000165 925 North Clay Middle School   Regular School No 2.0 06 08 2015   grade_8                         149.0 129.0                       278.0                         149 129                 278
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
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
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
1169698 1169698 IN     school 1803450 7995   Evansville Vanderburgh Sch Corp 180345000475 8251 Lincoln School   Regular School No 1.0 KG 08 2015   grade_8                         19.0 13.0                       32.0                         19 13                 32
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
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
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
1161698 1161698 IN     school 1803270 2305   Elkhart Community Schools 180327000440 1763 Pierre Moran Middle School   Regular School No 2.0 07 08 2015   grade_8                         156.0 132.0                       288.0                         156 132                 288
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
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
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
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
1162827 1162827 IN     school 1807260 3135   Mt Vernon Community Sch Corp 180726001222 2559 Mt Vernon Middle School   Regular School No 2.0 06 08 2015   grade_8                         154.0 136.0                       290.0                         154 136                 290
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
1160324 1160324 IN     school 1805790 665   Lebanon Community School Corp 180579001040 557 Lebanon Middle School   Regular School No 2.0 06 08 2015   grade_8                         151.0 137.0                       288.0                         151 137                 288
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
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
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
1159664 1159664 IN     school 1803630 235   Fort Wayne Community Schools 180363000516 107 Blackhawk Middle School   Regular School No 2.0 06 08 2015   grade_8                         152.0 139.0                       291.0                         152 139                 291
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
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
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
1167786 1167786 IN     school 1801170 6340   Cannelton City Schools 180117000191 6733 Cannelton Elem & High School   Regular School No 4.0 PK 12 2015   grade_8                         9.0 14.0                       23.0                         9 14                 23
1171176 1171176 IN     school 1800065 9690   Renaissance Academy Charter School 180006502415 4711 Renaissance Academy Charter Schl   Regular School Yes 1.0 KG 08 2015   grade_8                         6.0 14.0                       20.0                         6 14                 20
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
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
1163919 1163919 IN     school 1801440 4205   Center Grove Com Sch Corp 180144000210 3441 Center Grove Middle Schl Central   Regular School No 2.0 06 08 2015   grade_8                         180.0 142.0                       322.0                         180 142                 322
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
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
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
1161158 1161158 IN     school 1801590 1835   DeKalb Co Ctl United Sch Dist 180159000221 1346 DeKalb Middle School   Regular School No 2.0 06 08 2015   grade_8                         149.0 144.0                       293.0                         149 144                 293
1169113 1169113 IN     school 1810140 7365   Shelbyville Central Schools 181014001630 7721 Shelbyville Middle School   Regular School No 2.0 06 08 2015   grade_8                         157.0 144.0                       301.0                         157 144                 301
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
1164159 1164159 IN     school 1812420 4415   Warsaw Community Schools 181242002364 3607 Lakeview Middle School   Regular School No 2.0 07 08 2015   grade_8                         163.0 145.0                       308.0                         163 145                 308
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

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