enrollments

Data source: Big Local News · About: Big Local

507 rows where grade = "grade_8", state = "IN" and year = 2017 sorted by male

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2017 · 507 ✖

grade ✖

  • grade_8 · 507 ✖
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
1296827 1296827 IN     school 1804470 3490   Western School Corporation 180447002224 2923 Western Intermediate School   Regular School No Elementary 03 08 2017   grade_8                         0.0 1.0                       1.0                         0 1                 1
1298190 1298190 IN     school 1803870 4690   Gary Community School Corp 180387000620 4086 Frankie W McCullough Acad for Girl   Regular School No Elementary KG 08 2017   grade_8                         0.0 24.0                       24.0                         0 24                 24
1304169 1304169 IN     school 1800006 9100   Indiana Department of Corrections 180000601943 5452 Madison Juvenile Correctional   Regular School No High 08 12 2017   grade_8                         0.0 1.0                       1.0                         0 1                 1
1304901 1304901 IN     school 1800139 9940   Tindley Collegiate Academy 180013902559 5914 Tindley Collegiate Academy   Regular School Yes Middle 06 08 2017   grade_8                         0.0 83.0                       83.0                         0 83                 83
1293091 1293091 IN     school 1808250 225   Northwest Allen County Schools 180825002160 145 Allen Co Youth Services Center   Alternative School No Other 05 11 2017   grade_8                         1.0 1.0                       2.0                         1 1                 2
1296684 1296684 IN     school 1807440 3445   New Castle Community School Corp 180744001290 2825 New Castle High School   Regular School No High 08 12 2017   grade_8                         1.0 0.0                       1.0                         1 0                 1
1298038 1298038 IN     school 1802490 4660   Crown Point Community School Corp 180249000293 3901 Crown Point High School   Regular School No High 08 12 2017   grade_8                         1.0 0.0                       1.0                         1 0                 1
1302365 1302365 IN     school 1810290 7205   South Bend Community School Corp 181029000898 7632 Juvenile Justice Center   Alternative School No High 07 12 2017   grade_8                         1.0 0.0                       1.0                         1 0                 1
1302514 1302514 IN     school 1810140 7365   Shelbyville Central Schools 181014002496 7671 Especially Kidz Health & Rehab Cnt   Regular School No Other KG 12 2017   grade_8                         1.0 1.0                       2.0                         1 1                 2
1304155 1304155 IN     school 1800006 9100   Indiana Department of Corrections 180000601996 4846 Camp Summit Juvenile Facility   Regular School No High 08 12 2017   grade_8                         1.0 0.0                       1.0                         1 0                 1
1295139 1295139 IN     school 1803270 2305   Elkhart Community Schools 180327002585 1752 Elkhart Alternative Education   Regular School No Other 01 12 2017   grade_8                         10.0 7.0                       17.0                         10 7                 17
1299827 1299827 IN     school 1804770 5385   Indianapolis Public Schools 180477000866 5531 James A Garfield School 31   Regular School No Elementary KG 08 2017   grade_8                         10.0 15.0                       25.0                         10 15                 25
1300009 1300009 IN     school 1804770 5385   Indianapolis Public Schools 180477000872 5570 Edison School of the Arts 47   Regular School No Elementary KG 08 2017   grade_8                         10.0 19.0                       29.0                         10 19                 29
1300060 1300060 IN     school 1804770 5385   Indianapolis Public Schools 180477002555 5587 George Washington Carver School 87   Regular School No Elementary PK 08 2017   grade_8                         10.0 10.0                       20.0                         10 10                 20
1304162 1304162 IN     school 1800006 9100   Indiana Department of Corrections 180000601935 5055 Pendleton Juvenile Correctional   Regular School No High 08 12 2017   grade_8                         10.0 0.0                       10.0                         10 0                 10
1304729 1304729 IN     school 1800072 9805   Hoosier Academy - Indianapolis 180007202422 2527 Hoosier Academy - Indianapolis   Regular School Yes Other KG 12 2017   grade_8                         10.0 16.0                       26.0                         10 16                 26
1304873 1304873 IN     school 1800108 9920   Damar Charter Academy 180010802503 5191 Damar Charter Academy   Regular School Yes Other KG 12 2017   grade_8                         10.0 2.0                       12.0                         10 2                 12
1304920 1304920 IN     school 1800165 9950   Dugger Union Community School Corp 180016502590 7952 Dugger Union Community School Corp   Regular School Yes Other KG 12 2017   grade_8                         10.0 8.0                       18.0                         10 8                 18
1293463 1293463 IN     school 1802850 255   East Allen County Schools 180285002509 294 Paul Harding Jr High School   Regular School No Middle 07 08 2017   grade_8                         101.0 83.0                       184.0                         101 83                 184
1293150 1293150 IN     school 1803630 235   Fort Wayne Community Schools 180363000548 128 Miami Middle School   Regular School No Middle 06 08 2017   grade_8                         102.0 78.0                       180.0                         102 78                 180
1294745 1294745 IN     school 1807320 1970   Muncie Community Schools 180732002320 1431 Northside Middle School   Regular School No Middle 06 08 2017   grade_8                         102.0 101.0                       203.0                         102 101                 203
1298744 1298744 IN     school 1805580 4945   LaPorte Community School Corp 180558001019 4745 Paul F Boston Middle School   Regular School No Middle 06 08 2017   grade_8                         102.0 88.0                       190.0                         102 88                 190
1300433 1300433 IN     school 1806090 5615   Maconaquah School Corp 180609001079 6033 Maconaquah Middle School   Regular School No Middle 06 08 2017   grade_8                         102.0 97.0                       199.0                         102 97                 199
1304051 1304051 IN     school 1811580 8565   Twin Lakes School Corp 181158001862 9153 Roosevelt Middle School   Regular School No Middle 06 08 2017   grade_8                         102.0 96.0                       198.0                         102 96                 198
1296820 1296820 IN     school 1804470 3490   Western School Corporation 180447002225 2922 Western Middle School   Regular School No Middle 06 08 2017   grade_8                         103.0 93.0                       196.0                         103 93                 196
1298295 1298295 IN     school 1804320 4710   School City of Hammond 180432000735 4411 George Rogers Clark Md/HS   Regular School No Other 06 12 2017   grade_8                         103.0 109.0                       212.0                         103 109                 212
1295701 1295701 IN     school 1806870 2855   Mississinewa Community School Corp 180687001190 2335 R J Baskett Middle School   Regular School No Middle 06 08 2017   grade_8                         104.0 93.0                       197.0                         104 93                 197
1301124 1301124 IN     school 1810950 6195   Spencer-Owen Community Schools 181095001790 6597 Owen Valley Middle School   Regular School No Middle 07 08 2017   grade_8                         105.0 86.0                       191.0                         105 86                 191
1302011 1302011 IN     school 1808760 7175   Penn-Harris-Madison School Corp 180876001453 7336 Virgil I Grissom Middle School   Regular School No Middle 06 08 2017   grade_8                         105.0 99.0                       204.0                         105 99                 204
1301452 1301452 IN     school 1809150 6550   Portage Township Schools 180915001519 6859 William Fegely Middle School   Regular School No Middle 06 08 2017   grade_8                         106.0 113.0                       219.0                         106 113                 219
1301955 1301955 IN     school 1809750 6995   Rush County Schools 180975002240 7290 Benjamin Rush Middle School   Regular School No Middle 07 08 2017   grade_8                         106.0 93.0                       199.0                         106 93                 199
1294377 1294377 IN     school 1812450 1405   Washington Community Schools 181245002007 1123 Washington Junior High School   Regular School No Middle 07 08 2017   grade_8                         107.0 109.0                       216.0                         107 109                 216
1294532 1294532 IN     school 1804080 1730   Greensburg Community Schools 180408000705 1269 Greensburg Community Jr High   Regular School No Middle 06 08 2017   grade_8                         107.0 73.0                       180.0                         107 73                 180
1297546 1297546 IN     school 1812120 4335   Vincennes Community School Corp 181212001928 3557 George Rogers Clark School   Regular School No Middle 06 08 2017   grade_8                         107.0 107.0                       214.0                         107 107                 214
1293142 1293142 IN     school 1803630 235   Fort Wayne Community Schools 180363000539 126 Lane Middle School   Regular School No Middle 06 08 2017   grade_8                         108.0 114.0                       222.0                         108 114                 222
1293154 1293154 IN     school 1803630 235   Fort Wayne Community Schools 180363000553 129 Northwood Middle School   Regular School No Middle 06 08 2017   grade_8                         108.0 89.0                       197.0                         108 89                 197
1298574 1298574 IN     school 1807560 4805   New Prairie United School Corp 180756001299 7345 New Prairie Middle School   Regular School No Middle 06 08 2017   grade_8                         108.0 113.0                       221.0                         108 113                 221
1294930 1294930 IN     school 1803480 2155   Fairfield Community Schools 180348000492 1621 Millersburg Elementary- Middle Sch   Regular School No Elementary KG 08 2017   grade_8                         11.0 4.0                       15.0                         11 4                 15
1298180 1298180 IN     school 1803870 4690   Gary Community School Corp 180387000617 4081 Dr Bernard C Watson Acad for Boys   Regular School No Elementary KG 08 2017   grade_8                         11.0 0.0                       11.0                         11 0                 11
1298610 1298610 IN     school 1800107 4915   Tri-Township Cons School Corp 180010702520 4696 Wanatah School   Regular School No Elementary KG 08 2017   grade_8                         11.0 13.0                       24.0                         11 13                 24
1299940 1299940 IN     school 1804770 5385   Indianapolis Public Schools 180477000831 5556 Francis W Parker School 56   Regular School No Elementary PK 08 2017   grade_8                         11.0 6.0                       17.0                         11 6                 17
1298633 1298633 IN     school 1806570 4925   Michigan City Area Schools 180657001140 4789 Barker Middle School   Regular School No Middle 07 08 2017   grade_8                         110.0 94.0                       204.0                         110 94                 204
1294087 1294087 IN     school 1803940 1010   Greater Clark County Schools 180394000674 853 Parkview Middle School   Regular School No Middle 06 08 2017   grade_8                         111.0 108.0                       219.0                         111 108                 219
1296914 1296914 IN     school 1804710 3625   Huntington Co Com Sch Corp 180471000790 3025 Riverview School   Regular School No Middle 06 08 2017   grade_8                         111.0 103.0                       214.0                         111 103                 214
1302707 1302707 IN     school 1811100 7615   M S D Steuben County 181110001798 7895 Angola Middle School   Regular School No Middle 06 08 2017   grade_8                         111.0 114.0                       225.0                         111 114                 225
1302986 1302986 IN     school 1811340 7865   Tippecanoe School Corp 181134001920 8049 Wea Ridge Middle School   Regular School No Middle 06 08 2017   grade_8                         111.0 105.0                       216.0                         111 105                 216
1297072 1297072 IN     school 1805280 3785   Kankakee Valley School Corp 180528000934 3183 Kankakee Valley Middle School   Regular School No Middle 06 08 2017   grade_8                         112.0 152.0                       264.0                         112 152                 264
1301518 1301518 IN     school 1811970 6560   Valparaiso Community Schools 181197001890 6887 Thomas Jefferson Middle School   Regular School No Middle 06 08 2017   grade_8                         113.0 94.0                       207.0                         113 94                 207
1302947 1302947 IN     school 1811340 7865   Tippecanoe School Corp 181134001822 8025 Battle Ground Middle School   Regular School No Middle 06 08 2017   grade_8                         115.0 84.0                       199.0                         115 84                 199
1304142 1304142 IN     school 1800127 8825   CSUSA Donnan 180012700823 5572 Emma Donnan Middle School   Regular School No Middle 07 08 2017   grade_8                         116.0 85.0                       201.0                         116 85                 201
1293713 1293713 IN     school 1802830 630   Zionsville Community Schools 180283002046 510 Zionsville West Middle School   Regular School No Middle 05 08 2017   grade_8                         117.0 112.0                       229.0                         117 112                 229
1297187 1297187 IN     school 1806120 3995   Madison Consolidated Schools 180612001091 3313 Madison Consolidated Jr High Sch   Regular School No Middle 06 08 2017   grade_8                         117.0 96.0                       213.0                         117 96                 213
1298328 1298328 IN     school 1804320 4710   School City of Hammond 180432000738 4425 Henry W Eggers Middle School   Regular School No Middle 06 08 2017   grade_8                         117.0 119.0                       236.0                         117 119                 236
1303223 1303223 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345000486 8323 Thompkins Middle School   Regular School No Middle 06 08 2017   grade_8                         117.0 125.0                       242.0                         117 125                 242
1303392 1303392 IN     school 1812090 8030   Vigo County School Corp 181209001925 8485 Woodrow Wilson Middle School   Regular School No Middle 06 08 2017   grade_8                         117.0 124.0                       241.0                         117 124                 241
1293420 1293420 IN     school 1802850 255   East Allen County Schools 180285000349 49 Leo Junior/Senior High School   Regular School No High 07 12 2017   grade_8                         118.0 92.0                       210.0                         118 92                 210
1294262 1294262 IN     school 1803660 1170   Community Schools of Frankfort 180366000573 999 Frankfort Middle School   Regular School No Middle 06 08 2017   grade_8                         118.0 128.0                       246.0                         118 128                 246
1294457 1294457 IN     school 1800240 1600   South Dearborn Community Sch Corp 180024000958 1172 South Dearborn Middle School   Regular School No Middle 07 08 2017   grade_8                         118.0 98.0                       216.0                         118 98                 216
1297644 1297644 IN     school 1812420 4415   Warsaw Community Schools 181242002000 3653 Edgewood Middle School   Regular School No Middle 07 08 2017   grade_8                         118.0 129.0                       247.0                         118 129                 247
1298717 1298717 IN     school 1805580 4945   LaPorte Community School Corp 180558001012 4717 Kesling Middle School   Regular School No Middle 06 08 2017   grade_8                         118.0 138.0                       256.0                         118 138                 256
1293966 1293966 IN     school 1809370 940   West Clark Community Schools 180937001537 781 Silver Creek Middle School   Regular School No Middle 06 08 2017   grade_8                         119.0 124.0                       243.0                         119 124                 243
1294631 1294631 IN     school 1802660 1875   Delaware Community School Corp 180266000323 1367 Delta Middle School   Regular School No Middle 06 08 2017   grade_8                         119.0 91.0                       210.0                         119 91                 210
1294815 1294815 IN     school 1807320 1970   Muncie Community Schools 180732001232 1524 Youth Opportunity Center   Alternative School No Other 02 12 2017   grade_8                         12.0 10.0                       22.0                         12 10                 22
1301214 1301214 IN     school 1801170 6340   Cannelton City Schools 180117000191 6733 Cannelton Elementary & High School   Regular School No Other PK 12 2017   grade_8                         12.0 9.0                       21.0                         12 9                 21
1303117 1303117 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345000475 8251 Lincoln School   Regular School No Elementary KG 08 2017   grade_8                         12.0 18.0                       30.0                         12 18                 30
1304560 1304560 IN     school 1800061 9665   Geist Montessori Academy 180006102387 2572 Geist Montessori Academy   Regular School Yes Elementary KG 08 2017   grade_8                         12.0 10.0                       22.0                         12 10                 22
1303641 1303641 IN     school 1812390 8130   Warrick County School Corp 181239002454 8760 Castle South Middle School   Regular School No Middle 06 08 2017   grade_8                         120.0 96.0                       216.0                         120 96                 216
1293130 1293130 IN     school 1803630 235   Fort Wayne Community Schools 180363000534 119 Jefferson Middle School   Regular School No Middle 06 08 2017   grade_8                         121.0 115.0                       236.0                         121 115                 236
1295377 1295377 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741001271 1933 Hazelwood Middle School   Regular School No Middle 05 08 2017   grade_8                         121.0 115.0                       236.0                         121 115                 236
1295721 1295721 IN     school 1806390 2865   Marion Community Schools 180639001112 2357 John L McCulloch Junior High Sch   Regular School No Middle 07 08 2017   grade_8                         121.0 118.0                       239.0                         121 118                 239
1302217 1302217 IN     school 1810290 7205   South Bend Community School Corp 181029001709 7512 LaSalle Intermediate Academy   Regular School No Middle 05 08 2017   grade_8                         121.0 106.0                       227.0                         121 106                 227
1292989 1292989 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000116 63 Summit Middle School   Regular School No Middle 06 08 2017   grade_8                         122.0 108.0                       230.0                         122 108                 230
1295146 1295146 IN     school 1803270 2305   Elkhart Community Schools 180327000445 1761 West Side Middle School   Regular School No Middle 07 08 2017   grade_8                         124.0 169.0                       293.0                         124 169                 293
1300589 1300589 IN     school 1800630 5740   Monroe County Community Sch Corp 180063002232 6170 Tri-North Middle School   Regular School No Middle 07 08 2017   grade_8                         124.0 137.0                       261.0                         124 137                 261
1295045 1295045 IN     school 1812240 2285   Wa-Nee Community Schools 181224001958 1669 North Wood Middle School   Regular School No Middle 06 08 2017   grade_8                         125.0 98.0                       223.0                         125 98                 223
1295382 1295382 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741001276 1937 Nathaniel Scribner Middle School   Regular School No Middle 05 08 2017   grade_8                         125.0 91.0                       216.0                         125 91                 216
1297935 1297935 IN     school 1805450 4615   Lake Central School Corporation 180545000982 3841 Kahler Middle School   Regular School No Middle 05 08 2017   grade_8                         126.0 110.0                       236.0                         126 110                 236
1302422 1302422 IN     school 1810020 7255   Scott County School District 2 181002001611 7645 Scottsburg Middle School   Regular School No Middle 06 08 2017   grade_8                         126.0 96.0                       222.0                         126 96                 222
1300350 1300350 IN     school 1809060 5485   Plymouth Community School Corp 180906001499 5949 Lincoln Junior High School   Regular School No Middle 05 08 2017   grade_8                         127.0 144.0                       271.0                         127 144                 271
1299722 1299722 IN     school 1800450 5380   Beech Grove City Schools 180045000092 5453 Beech Grove Middle School   Regular School No Middle 07 08 2017   grade_8                         129.0 117.0                       246.0                         129 117                 246
1303583 1303583 IN     school 1812180 8050   M S D Wabash County Schools 181218001951 8673 White's Jr-Sr High School   Regular School No Other 06 12 2017   grade_8                         13.0 3.0                       16.0                         13 3                 16
1293343 1293343 IN     school 1803630 235   Fort Wayne Community Schools 180363000560 240 Shawnee Middle School   Regular School No Middle 06 08 2017   grade_8                         131.0 100.0                       231.0                         131 100                 231
1301514 1301514 IN     school 1811970 6560   Valparaiso Community Schools 181197001881 6885 Benjamin Franklin Middle School   Regular School No Middle 06 08 2017   grade_8                         131.0 119.0                       250.0                         131 119                 250
1294899 1294899 IN     school 1803960 2120   Greater Jasper Consolidated Schs 180396000686 1575 Jasper Middle School   Regular School No Middle 06 08 2017   grade_8                         132.0 126.0                       258.0                         132 126                 258
1295149 1295149 IN     school 1803270 2305   Elkhart Community Schools 180327000440 1763 Pierre Moran Middle School   Regular School No Middle 07 08 2017   grade_8                         132.0 118.0                       250.0                         132 118                 250
1301003 1301003 IN     school 1802970 6060   East Noble School Corporation 180297002335 6461 East Noble Middle School   Regular School No Middle 07 08 2017   grade_8                         132.0 155.0                       287.0                         132 155                 287
1303682 1303682 IN     school 1812390 8130   Warrick County School Corp 181239001978 8775 Castle North Middle School   Regular School No Middle 06 08 2017   grade_8                         132.0 125.0                       257.0                         132 125                 257
1300592 1300592 IN     school 1800630 5740   Monroe County Community Sch Corp 180063000130 6172 Lora L Batchelor Middle School   Regular School No Middle 07 08 2017   grade_8                         133.0 119.0                       252.0                         133 119                 252
1297899 1297899 IN     school 1805450 4615   Lake Central School Corporation 180545000985 3831 Michael Grimmer Middle School   Regular School No Middle 05 08 2017   grade_8                         135.0 122.0                       257.0                         135 122                 257
1300659 1300659 IN     school 1800630 5740   Monroe County Community Sch Corp 180063001123 6223 Jackson Creek Middle School   Regular School No Middle 07 08 2017   grade_8                         135.0 153.0                       288.0                         135 153                 288
1293117 1293117 IN     school 1803630 235   Fort Wayne Community Schools 180363000516 107 Blackhawk Middle School   Regular School No Middle 06 08 2017   grade_8                         136.0 126.0                       262.0                         136 126                 262
1296688 1296688 IN     school 1807440 3445   New Castle Community School Corp 180744001288 2829 New Castle Middle School   Regular School No Middle 07 08 2017   grade_8                         136.0 126.0                       262.0                         136 126                 262
1297979 1297979 IN     school 1811460 4645   Tri-Creek School Corporation 181146001851 3851 Lowell Middle School   Regular School No Middle 06 08 2017   grade_8                         136.0 112.0                       248.0                         136 112                 248
1298441 1298441 IN     school 1804560 4720   School Town of Highland 180456000764 4283 Highland Middle School   Regular School No Middle 06 08 2017   grade_8                         137.0 117.0                       254.0                         137 117                 254
1296214 1296214 IN     school 1810710 3115   Southern Hancock Co Com Sch Corp 181071001759 2566 Doe Creek Middle School   Regular School No Middle 07 08 2017   grade_8                         138.0 153.0                       291.0                         138 153                 291
1299109 1299109 IN     school 1803750 5310   Franklin Township Com Sch Corp 180375000598 5197 Franklin Township Middle Sch West   Regular School No Middle 06 08 2017   grade_8                         138.0 149.0                       287.0                         138 149                 287
1296451 1296451 IN     school 1801020 3305   Brownsburg Community School Corp 180102000178 2713 Brownsburg West Middle School   Regular School No Middle 06 08 2017   grade_8                         139.0 160.0                       299.0                         139 160                 299
1297370 1297370 IN     school 1801440 4205   Center Grove Community School Corp 180144000210 3441 Center Grove Middle School Central   Regular School No Middle 06 08 2017   grade_8                         139.0 168.0                       307.0                         139 168                 307
1297612 1297612 IN     school 1812420 4415   Warsaw Community Schools 181242002364 3607 Lakeview Middle School   Regular School No Middle 07 08 2017   grade_8                         139.0 123.0                       262.0                         139 123                 262
1298304 1298304 IN     school 1804320 4710   School City of Hammond 180432000734 4413 Donald E Gavit Middle/High School   Regular School No Other 06 12 2017   grade_8                         139.0 98.0                       237.0                         139 98                 237

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