Data source: Big Local News · About: Big Local

12,058 rows where state = "IN" and year = 2017 sorted by female descending

View and edit SQL

grade

year

  • 2017 · 12,058
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
1294084 IN     school 1803940 1010   Greater Clark County Schools 180394000666 849 Jeffersonville High School   Regular School No High 09 12 2017   pk_12_total 1204.0 383.0 231.0 3.0   30.0     2.0   191.0   1051.0 993.0     75.0             319.0   2044.0 1204 383 231 3   30     2   191   1051 993     75       319   2044
1293462 IN     school 1802850 255   East Allen County Schools 180285002509 294 Paul Harding Jr High School   Regular School No Middle 07 08 2017   grade_7                         64.0 99.0                       163.0                         64 99                 163
1294634 IN     school 1802660 1875   Delaware Community School Corp 180266000320 1369 Delta High School   Regular School No High 09 12 2017   grade_11                         101.0 99.0                       200.0                         101 99                 200
1295420 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741002204 1974 Mount Tabor Elementary School   Regular School No Elementary KG 04 2017   grade_1                         69.0 99.0                       168.0                         69 99                 168
1296022 IN     school 1806480 3055   Sheridan Community Schools 180648001655 6780 Sheridan Middle School   Regular School No Middle 06 08 2017   pk_12_total 233.0   12.0               3.0   149.0 99.0     1.0             48.0   248.0 233   12               3   149 99     1       48   248
1296547 IN     school 1802550 3325   Danville Community School Corp 180255000306 2721 North Elementary School   Regular School No Elementary PK 05 2017   grade_1                         87.0 99.0                       186.0                         87 99                 186
1297183 IN     school 1806120 3995   Madison Consolidated Schools 180612001090 3309 Madison Consolidated High School   Regular School No High 09 12 2017   grade_9                         112.0 99.0                       211.0                         112 99                 211
1297749 IN     school 1813110 4525   Westview School Corporation 181311002079 3697 Westview Jr-Sr High School   Regular School No Other 06 12 2017   grade_8                         81.0 99.0                       180.0                         81 99                 180
1298293 IN     school 1804320 4710   School City of Hammond 180432000735 4411 George Rogers Clark Md/HS   Regular School No Other 06 12 2017   grade_6                         90.0 99.0                       189.0                         90 99                 189
1301042 IN     school 1812900 6065   West Noble School Corporation 181290002058 6489 West Noble High School   Regular School No High 09 12 2017   grade_10                         94.0 99.0                       193.0                         94 99                 193
1301053 IN     school 1812900 6065   West Noble School Corporation 181290002059 6509 West Noble Middle School   Regular School No Middle 05 08 2017   grade_7                         93.0 99.0                       192.0                         93 99                 192
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
1302702 IN     school 1811100 7615   M S D Steuben County 181110001797 7893 Angola High School   Regular School No High 09 12 2017   grade_12                         91.0 99.0                       190.0                         91 99                 190
1304045 IN     school 1811580 8565   Twin Lakes School Corp 181158001863 9149 Twin Lakes Senior High School   Regular School No High 09 12 2017   grade_11                         90.0 99.0                       189.0                         90 99                 189
1293607 IN     school 1800360 365   Bartholomew Con School Corp 180036000066 397 Columbus North High School   Regular School No High 09 12 2017   pk_12_total 1498.0 44.0 262.0 6.0   126.0     2.0   79.0   1037.0 980.0     95.0             240.0   2017.0 1498 44 262 6   126     2   79   1037 980     95       240   2017
1292935 IN     school 1807680 25   North Adams Community Schools 180768001314 29 Bellmont Senior High School   Regular School No High 09 12 2017   grade_9                         85.0 98.0                       183.0                         85 98                 183
1293904 IN     school 1806030 875   Logansport Community Sch Corp 180603001058 702 Lincoln Middle School   Regular School No Middle 06 08 2017   grade_7                         73.0 98.0                       171.0                         73 98                 171
1293989 IN     school 1809370 940   West Clark Community Schools 180937002469 818 Silver Creek Primary School   Regular School No Elementary PK 01 2017   grade_1                         102.0 98.0                       200.0                         102 98                 200
1294091 IN     school 1803940 1010   Greater Clark County Schools 180394002128 863 Charlestown Middle School   Regular School No Middle 06 08 2017   grade_8                         84.0 98.0                       182.0                         84 98                 182
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
1294709 IN     school 1807230 1910   Yorktown Community Schools 180723001216 1393 Yorktown Elementary School   Regular School No Elementary 03 05 2017   grade_5                         94.0 98.0                       192.0                         94 98                 192
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
1296929 IN     school 1804710 3625   Huntington Co Com Sch Corp 180471000792 3035 Salamonie School   Regular School No Elementary KG 05 2017   pk_12_total 176.0 1.0 4.0               16.0   99.0 98.0     0.0             48.0   197.0 176 1 4               16   99 98     0       48   197
1297545 IN     school 1812120 4335   Vincennes Community School Corp 181212001928 3557 George Rogers Clark School   Regular School No Middle 06 08 2017   grade_7                         114.0 98.0                       212.0                         114 98                 212
1297758 IN     school 1813110 4525   Westview School Corporation 181311002365 3702 Westview Elementary School   Regular School No Middle 05 06 2017   grade_5                         103.0 98.0                       201.0                         103 98                 201
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
1299141 IN     school 1803750 5310   Franklin Township Com Sch Corp 180375002499 5203 Lillie Idella Kitley Elementary   Regular School No Elementary PK 05 2017   grade_3                         93.0 98.0                       191.0                         93 98                 191
1300116 IN     school 1804770 5385   Indianapolis Public Schools 180477000844 5601 H L Harshman Middle School   Regular School No Middle 07 08 2017   grade_8                         176.0 98.0                       274.0                         176 98                 274
1300435 IN     school 1806090 5615   Maconaquah School Corp 180609001077 6035 Maconaquah Elementary School   Regular School No Elementary 02 05 2017   grade_2                         90.0 98.0                       188.0                         90 98                 188
1300756 IN     school 1802460 5855   Crawfordsville Community Schools 180246000290 6293 Laura Hose Elementary School   Regular School No Elementary KG 01 2017   grade_1                         97.0 98.0                       195.0                         97 98                 195
1301054 IN     school 1812900 6065   West Noble School Corporation 181290002059 6509 West Noble Middle School   Regular School No Middle 05 08 2017   grade_8                         74.0 98.0                       172.0                         74 98                 172
1302010 IN     school 1808760 7175   Penn-Harris-Madison School Corp 180876001453 7336 Virgil I Grissom Middle School   Regular School No Middle 06 08 2017   grade_7                         106.0 98.0                       204.0                         106 98                 204
1303817 IN     school 1813050 8355   Western Wayne Schools 181305000561 8965 Lincoln Middle School   Regular School No Middle 06 08 2017   pk_12_total 208.0   5.0               3.0   118.0 98.0     0.0             29.0   216.0 208   5               3   118 98     0       29   216
1303969 IN     school 1808220 8435   Northern Wells Community Schools 180822002159 9088 Norwell Middle School   Regular School No Middle 06 08 2017   grade_6                         107.0 98.0                       205.0                         107 98                 205
1304128 IN     school 1800112 8815   CSUSA Manual 180011200825 5481 Emmerich Manual High School   Regular School No High 09 12 2017   grade_10                         88.0 98.0                       186.0                         88 98                 186
1304545 IN     school 1800058 9650   Herron Charter 180005802315 5724 Herron High School   Regular School Yes High 09 12 2017   grade_12                         68.0 98.0                       166.0                         68 98                 166
1304766 IN     school 1800081 9865   Hoosier Acad Virtual Charter 180008102458 5290 Hoosier Acad Virtual Charter Sch   Regular School Yes Other KG 12 2017   grade_2                         93.0 98.0                       191.0                         93 98                 191
1304767 IN     school 1800081 9865   Hoosier Acad Virtual Charter 180008102458 5290 Hoosier Acad Virtual Charter Sch   Regular School Yes Other KG 12 2017   grade_3                         119.0 98.0                       217.0                         119 98                 217
1303722 IN     school 1812390 8130   Warrick County School Corp 181239001977 8809 Castle High School   Regular School No High 09 12 2017   pk_12_total 1714.0 36.0 54.0 3.0   58.0         83.0   976.0 972.0     9.0             231.0   1948.0 1714 36 54 3   58         83   976 972     9       231   1948
1293457 IN     school 1802850 255   East Allen County Schools 180285000954 291 Cedarville Elementary School   Regular School No Elementary KG 03 2017   grade_1                         99.0 97.0                       196.0                         99 97                 196
1294744 IN     school 1807320 1970   Muncie Community Schools 180732002320 1431 Northside Middle School   Regular School No Middle 06 08 2017   grade_7                         118.0 97.0                       215.0                         118 97                 215
1295467 IN     school 1802430 2440   Covington Community School Corp 180243000277 2013 Covington Middle School   Regular School No Middle 06 08 2017   pk_12_total 198.0 1.0 9.0               3.0   114.0 97.0     2.0             32.0   211.0 198 1 9               3   114 97     2       32   211
1295498 IN     school 1803700 2475   Franklin County Community Sch Corp 180370002336 2083 Franklin County High   Regular School No High 09 12 2017   grade_9                         104.0 97.0                       201.0                         104 97                 201
1296333 IN     school 1800690 3180   North Harrison Com School Corp 180069000145 2625 North Harrison Middle School   Regular School No Middle 06 08 2017   grade_8                         88.0 97.0                       185.0                         88 97                 185
1296352 IN     school 1810360 3190   South Harrison Com Schools 181036002282 2640 Corydon Central High School   Regular School No High 09 12 2017   grade_9                         97.0 97.0                       194.0                         97 97                 194
1296860 IN     school 1805370 3500   Kokomo School Corporation 180537000998 2955 Central Middle School   Regular School No Middle 06 08 2017   grade_6                         85.0 97.0                       182.0                         85 97                 182
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
1301141 IN     school 1810950 6195   Spencer-Owen Community Schools 181095001787 6605 Gosport Elementary School   Regular School No Elementary PK 06 2017   pk_12_total 169.0   2.0     1.0         7.0   82.0 97.0     0.0             40.0   179.0 169   2     1         7   82 97     0       40   179
1301318 IN     school 1802800 6470   Duneland School Corporation 180280000336 6821 Liberty Intermediate School   Regular School No Middle 05 06 2017   grade_5                         93.0 97.0                       190.0                         93 97                 190
1301667 IN     school 1809360 6630   West Central School Corp 180936001517 7031 West Central Middle School   Regular School No Middle 06 08 2017   pk_12_total 175.0   8.0               5.0   91.0 97.0     0.0             32.0   188.0 175   8               5   91 97     0       32   188
1301828 IN     school 1801770 6825   Randolph Central School Corp 180177002191 7146 Deerfield Elementary School   Regular School No Elementary PK 05 2017   pk_12_total 191.0   5.0               9.0   108.0 97.0     0.0             44.0   205.0 191   5               9   108 97     0       44   205
1303146 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002462 8270 Academy for Innovative Studies   Regular School No Other KG 12 2017   grade_11                         133.0 97.0                       230.0                         133 97                 230
1303964 IN     school 1808220 8435   Northern Wells Community Schools 180822001410 9087 Norwell High School   Regular School No High 09 12 2017   grade_10                         107.0 97.0                       204.0                         107 97                 204
1303971 IN     school 1808220 8435   Northern Wells Community Schools 180822002159 9088 Norwell Middle School   Regular School No Middle 06 08 2017   grade_8                         97.0 97.0                       194.0                         97 97                 194
1293480 IN     school 1802850 255   East Allen County Schools 180285000356 310 Southwick Elementary School   Regular School No Elementary PK 02 2017   grade_2                         95.0 96.0                       191.0                         95 96                 191
1294380 IN     school 1812450 1405   Washington Community Schools 181245002006 1125 Washington High School   Regular School No High 09 12 2017   grade_10                         107.0 96.0                       203.0                         107 96                 203
1295946 IN     school 1804260 3025   Hamilton Heights School Corp 180426000727 2501 Hamilton Heights Middle School   Regular School No Middle 06 08 2017   grade_7                         101.0 96.0                       197.0                         101 96                 197
1296823 IN     school 1804470 3490   Western School Corporation 180447002224 2923 Western Intermediate School   Regular School No Elementary 03 08 2017   grade_4                         113.0 96.0                       209.0                         113 96                 209
1296937 IN     school 1804710 3625   Huntington Co Com Sch Corp 180471000784 3061 Crestview Middle School   Regular School No Middle 06 08 2017   grade_6                         103.0 96.0                       199.0                         103 96                 199
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
1297540 IN     school 1812120 4335   Vincennes Community School Corp 181212001931 3553 Lincoln High School   Regular School No High 09 12 2017   grade_11                         104.0 96.0                       200.0                         104 96                 200
1297554 IN     school 1812120 4335   Vincennes Community School Corp 181212001929 3573 James Whitcomb Riley Elem Sch   Regular School No Elementary KG 05 2017   pk_12_total 171.0 2.0 6.0               5.0   88.0 96.0     1.0             53.0   184.0 171 2 6               5   88 96     1       53   184
1297578 IN     school 1805550 4345   Wawasee Community School Corp 180555002354 3630 Wawasee Middle School   Regular School No Middle 06 08 2017   grade_7                         91.0 96.0                       187.0                         91 96                 187
1297822 IN     school 1804350 4580   Hanover Community School Corp 180435001908 3784 Hanover Central Middle School   Regular School No Middle 06 08 2017   grade_8                         86.0 96.0                       182.0                         86 96                 182
1298137 IN     school 1802910 4680   Lake Station Community Schools 180291000376 3973 Alexander Hamilton Elementary Sch   Regular School No Elementary 01 06 2017   pk_12_total 93.0 22.0 110.0               3.0   132.0 96.0     20.0             37.0   228.0 93 22 110               3   132 96     20       37   228
1301610 IN     school 1807950 6600   M S D North Posey Co Schools 180795001365 6973 North Posey Junior High School   Regular School No Middle 07 08 2017   pk_12_total 199.0   2.0     1.0         5.0   111.0 96.0     0.0             35.0   207.0 199   2     1         5   111 96     0       35   207
1301930 IN     school 1809750 6995   Rush County Schools 180975001591 7253 Arlington Elementary School   Regular School No Elementary KG 06 2017   pk_12_total 193.0 2.0 7.0               3.0   109.0 96.0     1.0             28.0   205.0 193 2 7               3   109 96     1       28   205
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
1302984 IN     school 1811340 7865   Tippecanoe School Corp 181134001920 8049 Wea Ridge Middle School   Regular School No Middle 06 08 2017   grade_6                         125.0 96.0                       221.0                         125 96                 221
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
1303967 IN     school 1808220 8435   Northern Wells Community Schools 180822001410 9087 Norwell High School   Regular School No High 09 12 2017   grade_9                         105.0 96.0                       201.0                         105 96                 201
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
1304518 IN     school 1800041 9625   IN Acad for Sci Math & Humanities 180004102348 1443 IN Acad for Sci Math & Humanities   Regular School No High 10 12 2017   grade_12                         60.0 96.0                       156.0                         60 96                 156
1293136 IN     school 1803630 235   Fort Wayne Community Schools 180363000538 125 Lakeside Middle School   Regular School No Middle 06 08 2017   grade_6                         82.0 95.0                       177.0                         82 95                 177
1293968 IN     school 1809370 940   West Clark Community Schools 180937001538 789 Silver Creek Elementary School   Regular School No Elementary 02 05 2017   grade_2                         112.0 95.0                       207.0                         112 95                 207
1293969 IN     school 1809370 940   West Clark Community Schools 180937001538 789 Silver Creek Elementary School   Regular School No Elementary 02 05 2017   grade_3                         111.0 95.0                       206.0                         111 95                 206
1294456 IN     school 1800240 1600   South Dearborn Community Sch Corp 180024000958 1172 South Dearborn Middle School   Regular School No Middle 07 08 2017   grade_7                         103.0 95.0                       198.0                         103 95                 198
1294527 IN     school 1804080 1730   Greensburg Community Schools 180408000704 1268 Greensburg Community High School   Regular School No High 09 12 2017   grade_12                         93.0 95.0                       188.0                         93 95                 188
1294531 IN     school 1804080 1730   Greensburg Community Schools 180408000705 1269 Greensburg Community Jr High   Regular School No Middle 06 08 2017   grade_7                         77.0 95.0                       172.0                         77 95                 172
1294703 IN     school 1807230 1910   Yorktown Community Schools 180723001217 1389 Yorktown High School   Regular School No High 09 12 2017   grade_11                         106.0 95.0                       201.0                         106 95                 201
1295621 IN     school 1810350 2765   South Gibson School Corporation 181035001688 2211 Gibson Southern High School   Regular School No High 09 12 2017   grade_12                         57.0 95.0                       152.0                         57 95                 152
1296555 IN     school 1802550 3325   Danville Community School Corp 180255000304 2741 Danville Community High School   Regular School No High 09 12 2017   grade_10                         110.0 95.0                       205.0                         110 95                 205
1296561 IN     school 1802550 3325   Danville Community School Corp 180255000305 2743 Danville Middle School   Regular School No Elementary 04 08 2017   grade_5                         91.0 95.0                       186.0                         91 95                 186
1296830 IN     school 1804470 3490   Western School Corporation 180447000755 2935 Western Primary School   Regular School No Elementary KG 03 2017   grade_2                         97.0 95.0                       192.0                         97 95                 192
1298267 IN     school 1804170 4700   Griffith Public Schools 180417000722 4173 Griffith Senior High School   Regular School No High 09 12 2017   grade_9                         99.0 95.0                       194.0                         99 95                 194
1298630 IN     school 1806570 4925   Michigan City Area Schools 180657001154 4788 Martin T Krueger Middle School   Regular School No Middle 07 08 2017   grade_8                         91.0 95.0                       186.0                         91 95                 186
1300432 IN     school 1806090 5615   Maconaquah School Corp 180609001079 6033 Maconaquah Middle School   Regular School No Middle 06 08 2017   grade_7                         87.0 95.0                       182.0                         87 95                 182
1300514 IN     school 1809480 5705   Richland-Bean Blossom C S C 180948001546 6146 Edgewood High School   Regular School No High 09 12 2017   grade_10                         112.0 95.0                       207.0                         112 95                 207
1300538 IN     school 1800630 5740   Monroe County Community Sch Corp 180063000136 6123 Unionville Elementary School   Regular School No Elementary PK 06 2017   pk_12_total 208.0 1.0 2.0 1.0         1.0   7.0   125.0 95.0     0.0             28.0   220.0 208 1 2 1         1   7   125 95     0       28   220
1300749 IN     school 1802460 5855   Crawfordsville Community Schools 180246000289 6281 Crawfordsville Middle School   Regular School No Middle 06 08 2017   grade_6                         85.0 95.0                       180.0                         85 95                 180
1300950 IN     school 1810470 5995   South Newton School Corp 181047001722 6417 South Newton Senior High School   Regular School No High 09 12 2017   pk_12_total 189.0 3.0 25.0               3.0   125.0 95.0     3.0             26.0   220.0 189 3 25               3   125 95     3       26   220
1301051 IN     school 1812900 6065   West Noble School Corporation 181290002059 6509 West Noble Middle School   Regular School No Middle 05 08 2017   grade_5                         71.0 95.0                       166.0                         71 95                 166
1302421 IN     school 1810020 7255   Scott County School District 2 181002001611 7645 Scottsburg Middle School   Regular School No Middle 06 08 2017   grade_7                         111.0 95.0                       206.0                         111 95                 206
1302945 IN     school 1811340 7865   Tippecanoe School Corp 181134001822 8025 Battle Ground Middle School   Regular School No Middle 06 08 2017   grade_6                         102.0 95.0                       197.0                         102 95                 197
1302978 IN     school 1811340 7865   Tippecanoe School Corp 181134001827 8042 Klondike Elementary School   Regular School No Elementary KG 05 2017   kindergarten                         91.0 95.0                       186.0                         91 95                 186
1303652 IN     school 1812390 8130   Warrick County School Corp 181239001981 8764 John H Castle Elementary School   Regular School No Elementary KG 05 2017   grade_3                         89.0 95.0                       184.0                         89 95                 184
1303702 IN     school 1812390 8130   Warrick County School Corp 181239001975 8789 Boonville High School   Regular School No High 09 12 2017   grade_11                         116.0 95.0                       211.0                         116 95                 211
1304042 IN     school 1811580 8565   Twin Lakes School Corp 181158001859 9129 Eastlawn Elementary School   Regular School No Elementary PK 04 2017   pk_12_total 199.0 1.0 6.0 1.0   2.0         12.0   126.0 95.0     2.0             44.0   221.0 199 1 6 1   2         12   126 95     2       44   221
1304252 IN     school 1800142 9345   Excel Center - Lafayette 180014202548 8094 Excel Center - Lafayette   Regular School Yes High 11 12 2017   grade_12                         60.0 95.0                       155.0                         60 95                 155
1304899 IN     school 1800139 9940   Tindley Collegiate Academy 180013902559 5914 Tindley Collegiate Academy   Regular School Yes Middle 06 08 2017   grade_6                         0.0 95.0                       95.0                         0 95                 95

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