Data source: Big Local News · About: Big Local

11,966 rows where state = "IN" and year = 2020 sorted by female descending

View and edit SQL

grade

year

  • 2020 · 11,966
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
1916128 IN     school 1810290 7205   South Bend Community School Corp 181029001662 7505 Adams High School   Regular School No High 09 12 2020   pk_12_total 692.0 479.0 516.0 5.0   46.0     2.0   152.0   902.0 990.0     256.0         1011.0   221.0   1892.0 692 479 516 5   46     2   152   902 990     256     1011 221   1892
1907198 IN     school 1803630 235   Fort Wayne Community Schools 180363000537 121 Kekionga Middle School   Regular School No Middle 06 08 2020   grade_7                         98.0 99.0                       197.0                         98 99                 197
1908683 IN     school 1802660 1875   Delaware Community School Corp 180266000323 1367 Delta Middle School   Regular School No Middle 06 08 2020   grade_8                         105.0 99.0                       204.0                         105 99                 204
1908752 IN     school 1807230 1910   Yorktown Community Schools 180723001218 1387 Yorktown Middle School   Regular School No Middle 06 08 2020   grade_6                         117.0 99.0                       216.0                         117 99                 216
1908754 IN     school 1807230 1910   Yorktown Community Schools 180723001218 1387 Yorktown Middle School   Regular School No Middle 06 08 2020   grade_8                         89.0 99.0                       188.0                         89 99                 188
1910392 IN     school 1800690 3180   North Harrison Com School Corp 180069000144 2629 North Harrison High School   Regular School No High 09 12 2020   grade_11                         77.0 99.0                       176.0                         77 99                 176
1911235 IN     school 1806120 3995   Madison Consolidated Schools 180612001093 3321 Rykers' Ridge Elementary School   Regular School No Elementary PK 04 2020   pk_12_total 180.0 1.0 4.0 1.0   1.0         9.0   97.0 99.0     0.0         127.0   20.0   196.0 180 1 4 1   1         9   97 99     0     127 20   196
1915046 IN     school 1810950 6195   Spencer-Owen Community Schools 181095001791 6613 Owen Valley Community High School   Regular School No High 09 12 2020   grade_9                         106.0 99.0                       205.0                         106 99                 205
1916329 IN     school 1810020 7255   Scott County School District 2 181002001611 7645 Scottsburg Middle School   Regular School No Middle 06 08 2020   grade_8                         94.0 99.0                       193.0                         94 99                 193
1916915 IN     school 1812870 7875   West Lafayette Com School Corp 181287002043 8138 West Lafayette Elementary School   Regular School No Elementary KG 03 2020   grade_2                         86.0 99.0                       185.0                         86 99                 185
1917002 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345000456 8237 Benjamin Bosse High School   Regular School No High 09 12 2020   grade_10                         116.0 99.0                       215.0                         116 99                 215
1917826 IN     school 1809510 8385   Richmond Community Schools 180951001561 8997 Test Intermediate School   Regular School No Middle 05 08 2020   grade_5                         126.0 99.0                       225.0                         126 99                 225
1918287 IN     school 1800134 9305   Excel Center - Richmond 180013402549 9012 Excel Center - Richmond   Regular School Yes High 11 12 2020   grade_11                         72.0 99.0                       171.0                         72 99                 171
1918692 IN     school 1800113 9730   Neighbors' New Vistas High School 180011302544 6864 Neighbors' New Vistas High School   Regular School Yes High 09 12 2020   pk_12_total 112.0 35.0 51.0     1.0         15.0   115.0 99.0     3.0         129.0   44.0   214.0 112 35 51     1         15   115 99     3     129 44   214
1908125 IN     school 1803940 1010   Greater Clark County Schools 180394000663 821 Charlestown Senior High School   Regular School No High 09 12 2020   grade_9                         81.0 98.0                       179.0                         81 98                 179
1908685 IN     school 1802660 1875   Delaware Community School Corp 180266000320 1369 Delta High School   Regular School No High 09 12 2020   grade_10                         106.0 98.0                       204.0                         106 98                 204
1908900 IN     school 1810640 2100   Southeast Dubois Co Sch Corp 181064002177 1586 Cedar Crest Intermediate School   Regular School No Middle 05 06 2020   pk_12_total 169.0   10.0     1.0         4.0   86.0 98.0     3.0         41.0   33.0   184.0 169   10     1         4   86 98     3     41 33   184
1909985 IN     school 1804260 3025   Hamilton Heights School Corp 180426000728 2477 Hamilton Heights High School   Regular School No High 09 12 2020   grade_10                         105.0 98.0                       203.0                         105 98                 203
1910624 IN     school 1802550 3325   Danville Community School Corp 180255000305 2743 Danville Middle School   Regular School No Other 04 09 2020   grade_8                         96.0 98.0                       194.0                         96 98                 194
1910882 IN     school 1804470 3490   Western School Corporation 180447002225 2922 Western Middle School   Regular School No Middle 06 08 2020   grade_7                         113.0 98.0                       211.0                         113 98                 211
1910885 IN     school 1804470 3490   Western School Corporation 180447002224 2923 Western Intermediate School   Regular School No Middle 03 08 2020   grade_3                         93.0 98.0                       191.0                         93 98                 191
1910977 IN     school 1804710 3625   Huntington Co Com Sch Corp 180471000790 3025 Riverview School   Regular School No Middle 06 08 2020   grade_6                         105.0 98.0                       203.0                         105 98                 203
1910996 IN     school 1804710 3625   Huntington Co Com Sch Corp 180471000784 3061 Crestview Middle School   Regular School No Middle 06 08 2020   grade_7                         121.0 98.0                       219.0                         121 98                 219
1911228 IN     school 1806120 3995   Madison Consolidated Schools 180612001091 3313 Madison Consolidated Jr High Sch   Regular School No Middle 05 08 2020   grade_8                         113.0 98.0                       211.0                         113 98                 211
1911592 IN     school 1812120 4335   Vincennes Community School Corp 181212001931 3553 Lincoln High School   Regular School No High 09 12 2020   grade_11                         92.0 98.0                       190.0                         92 98                 190
1911812 IN     school 1813110 4525   Westview School Corporation 181311002365 3702 Westview Elementary School   Regular School No Middle 05 06 2020   grade_5                         112.0 98.0                       210.0                         112 98                 210
1911872 IN     school 1804350 4580   Hanover Community School Corp 180435000753 3785 Hanover Central High School   Regular School No High 09 12 2020   grade_9                         95.0 98.0                       193.0                         95 98                 193
1912068 IN     school 1802490 4660   Crown Point Community School Corp 180249000300 3854 Winfield Elementary School   Regular School No Elementary KG 02 2020   grade_1                         72.0 98.0                       170.0                         72 98                 170
1912597 IN     school 1806570 4925   Michigan City Area Schools 180657001140 4789 Barker Middle School   Regular School No Middle 07 08 2020   grade_7                         121.0 98.0                       219.0                         121 98                 219
1913692 IN     school 1800450 5380   Beech Grove City Schools 180045000094 5457 Central Elementary School   Regular School No Elementary 02 03 2020   grade_2                         112.0 98.0                       210.0                         112 98                 210
1914443 IN     school 1809480 5705   Richland-Bean Blossom C S C 180948001708 6153 Edgewood Intermediate School   Regular School No Elementary 03 05 2020   grade_3                         102.0 98.0                       200.0                         102 98                 200
1914636 IN     school 1810450 5845   South Montgomery Com Sch Corp 181045001714 6233 Ladoga Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 176.0 1.0 9.0               15.0   103.0 98.0     1.0         103.0   42.0   201.0 176 1 9               15   103 98     1     103 42   201
1915873 IN     school 1809750 6995   Rush County Schools 180975001596 7285 Rushville Consolidated High School   Regular School No High 09 12 2020   grade_9                         102.0 98.0                       200.0                         102 98                 200
1916187 IN     school 1810290 7205   South Bend Community School Corp 181029001667 7557 Lafayette Early Childhood Center   Regular School No Prekindergarten PK PK 2020   pk_12_total 29.0 108.0 45.0     1.0         17.0   102.0 98.0     0.0         158.0   23.0   200.0 29 108 45     1         17   102 98     0     158 23   200
1916188 IN     school 1810290 7205   South Bend Community School Corp 181029001667 7557 Lafayette Early Childhood Center   Regular School No Prekindergarten PK PK 2020   pre_kindergarten                         102.0 98.0                       200.0                         102 98                 200
1916327 IN     school 1810020 7255   Scott County School District 2 181002001611 7645 Scottsburg Middle School   Regular School No Middle 06 08 2020   grade_6                         109.0 98.0                       207.0                         109 98                 207
1916508 IN     school 1810560 7445   South Spencer County Sch Corp 181056001731 7789 Luce Elementary School   Regular School No Elementary KG 05 2020   pk_12_total 216.0   3.0 1.0             4.0   126.0 98.0     0.0         75.0   46.0   224.0 216   3 1             4   126 98     0     75 46   224
1917924 IN     school 1808220 8435   Northern Wells Community Schools 180822001410 9087 Norwell High School   Regular School No High 09 12 2020   grade_12                         104.0 98.0                       202.0                         104 98                 202
1918006 IN     school 1811580 8565   Twin Lakes School Corp 181158001863 9149 Twin Lakes Senior High School   Regular School No High 09 12 2020   grade_11                         97.0 98.0                       195.0                         97 98                 195
1909289 IN     school 1803930 2315   Goshen Community Schools 180393000654 1821 Goshen High School   Regular School No High 09 12 2020   pk_12_total 749.0 55.0 1078.0 2.0   30.0         70.0   1012.0 972.0     325.0         1125.0   220.0   1984.0 749 55 1078 2   30         70   1012 972     325     1125 220   1984
1908056 IN     school   940   West Clark Community Schools   818 Silver Creek Primary School             2020   kindergarten                         91.0 97.0                       188.0                         91 97                 188
1908509 IN     school 1800240 1600   South Dearborn Community Sch Corp 180024000056 1179 South Dearborn High School   Regular School No High 09 12 2020   grade_10                         103.0 97.0                       200.0                         103 97                 200
1908510 IN     school 1800240 1600   South Dearborn Community Sch Corp 180024000056 1179 South Dearborn High School   Regular School No High 09 12 2020   grade_11                         107.0 97.0                       204.0                         107 97                 204
1908524 IN     school 1805700 1620   Lawrenceburg Community School Corp 180570001037 1177 Lawrenceburg High School   Regular School No High 08 12 2020   grade_10                         89.0 97.0                       186.0                         89 97                 186
1908764 IN     school 1807230 1910   Yorktown Community Schools 180723001216 1393 Yorktown Elementary School   Regular School No Elementary 03 05 2020   grade_5                         93.0 97.0                       190.0                         93 97                 190
1908794 IN     school 1807320 1970   Muncie Community Schools 180732001252 1437 Southside Middle School   Regular School No Middle 06 08 2020   grade_6                         103.0 97.0                       200.0                         103 97                 200
1910074 IN     school 1806480 3055   Sheridan Community Schools 180648001655 6780 Sheridan Middle School   Regular School No Middle 06 08 2020   pk_12_total 211.0   13.0               5.0   132.0 97.0     2.0         96.0   45.0   229.0 211   13               5   132 97     2     96 45   229
1910881 IN     school 1804470 3490   Western School Corporation 180447002225 2922 Western Middle School   Regular School No Middle 06 08 2020   grade_6                         118.0 97.0                       215.0                         118 97                 215
1910924 IN     school 1805370 3500   Kokomo School Corporation 180537000995 2951 Bon Air Middle School   Regular School No Middle 06 08 2020   pk_12_total 121.0 47.0 17.0               32.0   120.0 97.0     2.0         188.0   60.0   217.0 121 47 17               32   120 97     2     188 60   217
1911594 IN     school 1812120 4335   Vincennes Community School Corp 181212001931 3553 Lincoln High School   Regular School No High 09 12 2020   grade_9                         90.0 97.0                       187.0                         90 97                 187
1912789 IN     school 1807860 5075   North Lawrence Com Schools 180786001336 4905 Bedford Middle School   Regular School No Middle 06 08 2020   grade_6                         104.0 97.0                       201.0                         104 97                 201
1913094 IN     school 1803750 5310   Franklin Township Com Sch Corp 180375002499 5203 Lillie Idella Kitley Elementary   Regular School No Elementary KG 05 2020   grade_1                         93.0 97.0                       190.0                         93 97                 190
1913271 IN     school 1808820 5340   Perry Township Schools 180882001455 5337 Abraham Lincoln Elementary School   Regular School No Elementary PK 05 2020   kindergarten                         104.0 97.0                       201.0                         104 97                 201
1913693 IN     school 1800450 5380   Beech Grove City Schools 180045000094 5457 Central Elementary School   Regular School No Elementary 02 03 2020   grade_3                         119.0 97.0                       216.0                         119 97                 216
1914362 IN     school 1806090 5615   Maconaquah School Corp 180609001077 6035 Maconaquah Elementary School   Regular School No Elementary 02 05 2020   grade_5                         84.0 97.0                       181.0                         84 97                 181
1914679 IN     school 1802460 5855   Crawfordsville Community Schools 180246000291 6301 Meredith Nicholson Elementary Sch   Regular School No Elementary 02 03 2020   grade_2                         103.0 97.0                       200.0                         103 97                 200
1917659 IN     school 1812390 8130   Warrick County School Corp 181239001975 8789 Boonville High School   Regular School No High 09 12 2020   grade_12                         131.0 97.0                       228.0                         131 97                 228
1917829 IN     school 1809510 8385   Richmond Community Schools 180951001561 8997 Test Intermediate School   Regular School No Middle 05 08 2020   grade_8                         100.0 97.0                       197.0                         100 97                 197
1917922 IN     school 1808220 8435   Northern Wells Community Schools 180822001410 9087 Norwell High School   Regular School No High 09 12 2020   grade_10                         108.0 97.0                       205.0                         108 97                 205
1917679 IN     school 1812390 8130   Warrick County School Corp 181239001977 8809 Castle High School   Regular School No High 09 12 2020   pk_12_total 1647.0 43.0 55.0 2.0   65.0         93.0   945.0 960.0     18.0         403.0   209.0   1905.0 1647 43 55 2   65         93   945 960     18     403 209   1905
1907203 IN     school 1803630 235   Fort Wayne Community Schools 180363000538 125 Lakeside Middle School   Regular School No Middle 06 08 2020   grade_8                         84.0 96.0                       180.0                         84 96                 180
1907211 IN     school 1803630 235   Fort Wayne Community Schools 180363000546 127 Memorial Park Middle School   Regular School No Middle 06 08 2020   grade_8                         94.0 96.0                       190.0                         94 96                 190
1908123 IN     school 1803940 1010   Greater Clark County Schools 180394000663 821 Charlestown Senior High School   Regular School No High 09 12 2020   grade_11                         92.0 96.0                       188.0                         92 96                 188
1908577 IN     school 1804080 1730   Greensburg Community Schools 180408000704 1268 Greensburg Community High School   Regular School No High 09 12 2020   grade_12                         79.0 96.0                       175.0                         79 96                 175
1908682 IN     school 1802660 1875   Delaware Community School Corp 180266000323 1367 Delta Middle School   Regular School No Middle 06 08 2020   grade_7                         117.0 96.0                       213.0                         117 96                 213
1909407 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741001271 1933 Hazelwood Middle School   Regular School No Middle 05 08 2020   grade_5                         130.0 96.0                       226.0                         130 96                 226
1909530 IN     school 1803700 2475   Franklin County Community Sch Corp 180370002336 2083 Franklin County High   Regular School No High 09 12 2020   grade_9                         86.0 96.0                       182.0                         86 96                 182
1910405 IN     school 1810360 3190   South Harrison Com Schools 181036002282 2640 Corydon Central High School   Regular School No High 09 12 2020   grade_11                         85.0 96.0                       181.0                         85 96                 181
1910409 IN     school 1810360 3190   South Harrison Com Schools 181036002283 2643 Corydon Central Jr High School   Regular School No Middle 07 08 2020   grade_7                         98.0 96.0                       194.0                         98 96                 194
1911173 IN     school 1804980 3945   Jay School Corporation 180498000914 3239 Jay County High School   Regular School No High 09 12 2020   grade_9                         125.0 96.0                       221.0                         125 96                 221
1911188 IN     school 1804980 3945   Jay School Corporation 180498000917 3247 Redkey Elementary School   Regular School No Elementary KG 05 2020   pk_12_total 198.0 1.0                 8.0   111.0 96.0     1.0         136.0   60.0   207.0 198 1                 8   111 96     1     136 60   207
1911200 IN     school 1804980 3945   Jay School Corporation 180498000918 3285 West Jay County Middle School   Regular School No Middle 06 08 2020   pk_12_total 178.0   7.0               2.0   91.0 96.0     1.0         104.0   38.0   187.0 178   7               2   91 96     1     104 38   187
1911437 IN     school 1803240 4215   Edinburgh Community School Corp 180324000213 3449 Edinburgh Comm Middle School   Regular School No Middle 06 08 2020   pk_12_total 173.0   17.0     1.0         7.0   102.0 96.0     4.0         144.0   40.0   198.0 173   17     1         7   102 96     4     144 40   198
1912273 IN     school 1804320 4710   School City of Hammond 180432000735 4411 George Rogers Clark Md/HS   Regular School No High 06 12 2020   grade_9                         98.0 96.0                       194.0                         98 96                 194
1913247 IN     school 1808820 5340   Perry Township Schools 180882002280 5322 Mary Bryan Elementary School   Regular School No Elementary PK 05 2020   kindergarten                         87.0 96.0                       183.0                         87 96                 183
1916914 IN     school 1812870 7875   West Lafayette Com School Corp 181287002043 8138 West Lafayette Elementary School   Regular School No Elementary KG 03 2020   grade_1                         97.0 96.0                       193.0                         97 96                 193
1918003 IN     school 1811580 8565   Twin Lakes School Corp 181158001859 9129 Eastlawn Elementary School   Regular School No Elementary PK 04 2020   pk_12_total 207.0 2.0 12.0               3.0   128.0 96.0     8.0         130.0   46.0   224.0 207 2 12               3   128 96     8     130 46   224
1918324 IN     school 1800016 9325   Options Charter School - Carmel 180001601738 2524 Options Charter School - Carmel   Regular School Yes High 09 12 2020   pk_12_total 153.0 27.0 19.0 1.0   4.0         13.0   121.0 96.0     4.0         69.0   57.0   217.0 153 27 19 1   4         13   121 96     4     69 57   217
1912700 IN     school 1805580 4945   LaPorte Community School Corp 180558001015 4741 LaPorte High School   Regular School No High 09 12 2020   pk_12_total 1485.0 72.0 316.0 2.0   7.0     3.0   90.0   1018.0 957.0     52.0         991.0   427.0   1975.0 1485 72 316 2   7     3   90   1018 957     52     991 427   1975
1913720 IN     school 1804770 5385   Indianapolis Public Schools 180477000801 5462 Arsenal Technical High School   Regular School No High 09 12 2020   pk_12_total 187.0 1044.0 812.0 1.0   16.0         93.0   1201.0 952.0     481.0         1457.0   410.0   2153.0 187 1044 812 1   16         93   1201 952     481     1457 410   2153
1915411 IN     school 1811970 6560   Valparaiso Community Schools 181197001891 6881 Valparaiso High School   Regular School No High 09 12 2020   pk_12_total 1584.0 78.0 197.0 2.0   51.0     1.0   72.0   1035.0 950.0     37.0         477.0   283.0   1985.0 1584 78 197 2   51     1   72   1035 950     37     477 283   1985
1907210 IN     school 1803630 235   Fort Wayne Community Schools 180363000546 127 Memorial Park Middle School   Regular School No Middle 06 08 2020   grade_7                         109.0 95.0                       204.0                         109 95                 204
1907489 IN     school 1802850 255   East Allen County Schools 180285000348 53 Leo Elementary School   Regular School No Middle 04 06 2020   grade_6                         113.0 95.0                       208.0                         113 95                 208
1908030 IN     school   940   West Clark Community Schools   781 Silver Creek Middle School             2020   grade_6                         114.0 95.0                       209.0                         114 95                 209
1908259 IN     school 1800840 1125   Clay Community Schools 180084000159 942 Forest Park Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 232.0   10.0     1.0         7.0   155.0 95.0     1.0         187.0   126.0   250.0 232   10     1         7   155 95     1     187 126   250
1908511 IN     school 1800240 1600   South Dearborn Community Sch Corp 180024000056 1179 South Dearborn High School   Regular School No High 09 12 2020   grade_12                         89.0 95.0                       184.0                         89 95                 184
1909727 IN     school 1806870 2855   Mississinewa Community School Corp 180687001189 2333 Mississinewa High School   Regular School No High 09 12 2020   grade_10                         106.0 95.0                       201.0                         106 95                 201
1909729 IN     school 1806870 2855   Mississinewa Community School Corp 180687001189 2333 Mississinewa High School   Regular School No High 09 12 2020   grade_12                         110.0 95.0                       205.0                         110 95                 205
1909999 IN     school 1804260 3025   Hamilton Heights School Corp 180426001653 2502 Hamilton Heights Primary School   Regular School No Elementary PK 03 2020   grade_3                         94.0 95.0                       189.0                         94 95                 189
1910610 IN     school 1802550 3325   Danville Community School Corp 180255000306 2721 North Elementary School   Regular School No Elementary KG 03 2020   grade_2                         87.0 95.0                       182.0                         87 95                 182
1911813 IN     school 1813110 4525   Westview School Corporation 181311002365 3702 Westview Elementary School   Regular School No Middle 05 06 2020   grade_6                         92.0 95.0                       187.0                         92 95                 187
1912242 IN     school 1804170 4700   Griffith Public Schools 180417000722 4173 Griffith Senior High School   Regular School No High 09 12 2020   grade_10                         111.0 95.0                       206.0                         111 95                 206
1912278 IN     school 1804320 4710   School City of Hammond 180432000734 4413 Donald E Gavit Middle/High School   Regular School No High 06 12 2020   grade_12                         117.0 95.0                       212.0                         117 95                 212
1913757 IN     school 1804770 5385   Indianapolis Public Schools 180477002528 5516 Northwest Community Middle School   Regular School No Middle 07 08 2020   grade_8                         130.0 95.0                       225.0                         130 95                 225
1914409 IN     school 1808850 5635   Peru Community Schools 180885001476 6085 Peru High School   Regular School No High 08 12 2020   grade_9                         72.0 95.0                       167.0                         72 95                 167
1914564 IN     school 1800630 5740   Monroe County Community Sch Corp 180063000131 6213 Marlin Elementary School   Regular School No Elementary KG 06 2020   pk_12_total 195.0 1.0             1.0   7.0   109.0 95.0     0.0         58.0   19.0   204.0 195 1             1   7   109 95     0     58 19   204
1914667 IN     school 1802460 5855   Crawfordsville Community Schools 180246000287 6277 Crawfordsville Sr High School   Regular School No High 09 12 2020   grade_9                         80.0 95.0                       175.0                         80 95                 175
1914943 IN     school 1812900 6065   West Noble School Corporation 181290002058 6489 West Noble High School   Regular School No High 09 12 2020   grade_10                         96.0 95.0                       191.0                         96 95                 191
1914955 IN     school 1812900 6065   West Noble School Corporation 181290002059 6509 West Noble Middle School   Regular School No Middle 05 08 2020   grade_8                         77.0 95.0                       172.0                         77 95                 172
1915875 IN     school 1809750 6995   Rush County Schools 180975002240 7290 Benjamin Rush Middle School   Regular School No Middle 07 08 2020   grade_7                         86.0 95.0                       181.0                         86 95                 181

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