enrollments

Data source: Big Local News · About: Big Local

499 rows where grade = "grade_8", state = "IN" and year = 2019 sorted by female

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2019 · 499 ✖

grade ✖

  • grade_8 · 499 ✖
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
1751722 1751722 IN     school 1803630 235   Fort Wayne Community Schools 180363002174 100 Allen Co Juvenile Center   Regular School No High 08 12 2019   grade_8                         1.0 0.0                       1.0                         1 0                 1
1752761 1752761 IN     school 1803940 1010   Greater Clark County Schools 180394000832 886 Old Corden Porter School   Special Education School No High 06 12 2019   grade_8                         4.0 0.0                       4.0                         4 0                 4
1755300 1755300 IN     school 1807440 3445   New Castle Community School Corp 180744001290 2825 New Castle High School   Regular School No High 07 12 2019   grade_8                         1.0 0.0                       1.0                         1 0                 1
1755777 1755777 IN     school 1806120 3995   Madison Consolidated Schools 180612001090 3309 Madison Consolidated High School   Regular School No High 08 12 2019   grade_8                         1.0 0.0                       1.0                         1 0                 1
1762772 1762772 IN     school 1800006 9100   Indiana Department of Correction 180000601946 732 Logansport Juvenile Correctional   Regular School No High 07 12 2019   grade_8                         11.0 0.0                       11.0                         11 0                 11
1762780 1762780 IN     school 1800006 9100   Indiana Department of Correction 180000601935 5055 Pendleton Juvenile Correctional   Regular School No High 07 12 2019   grade_8                         4.0 0.0                       4.0                         4 0                 4
1763251 1763251 IN     school 1800131 9760   Smith Academy for Excellence 180013102539 242 Smith Academy for Excellence   Regular School Yes Other 04 12 2019   grade_8                         17.0 0.0                       17.0                         17 0                 17
1752768 1752768 IN     school 1803940 1010   Greater Clark County Schools 180394000839 891 Clark County Middle/High School   Alternative School No High 07 12 2019   grade_8                         5.0 1.0                       6.0                         5 1                 6
1755432 1755432 IN     school 1804470 3490   Western School Corporation 180447000756 2921 Western High School   Regular School No High 08 12 2019   grade_8                         0.0 1.0                       1.0                         0 1                 1
1755444 1755444 IN     school 1804470 3490   Western School Corporation 180447002224 2923 Western Intermediate School   Regular School No Middle 03 08 2019   grade_8                         1.0 1.0                       2.0                         1 1                 2
1758217 1758217 IN     school   5375   M S D Wayne Township   5271 Sanders School             2019   grade_8                         5.0 1.0                       6.0                         5 1                 6
1758989 1758989 IN     school 1808850 5635   Peru Community Schools 180885001476 6085 Peru High School   Regular School No High 08 12 2019   grade_8                         2.0 1.0                       3.0                         2 1                 3
1759493 1759493 IN     school 1802970 6060   East Noble School Corporation 180297000389 6458 East Noble High School   Regular School No High 08 12 2019   grade_8                         1.0 1.0                       2.0                         1 1                 2
1760863 1760863 IN     school 1810290 7205   South Bend Community School Corp 181029000898 7632 Juvenile Justice Center   Alternative School No High 07 12 2019   grade_8                         2.0 1.0                       3.0                         2 1                 3
1761676 1761676 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002649 8271 Harwood Career Prep High School   Regular School No Other 01 12 2019   grade_8                         2.0 1.0                       3.0                         2 1                 3
1762903 1762903 IN     school 1800137 9365   Enlace Academy 180013702551 5667 Enlace Academy   Regular School Yes Elementary KG 08 2019   grade_8                         25.0 10.0                       35.0                         25 10                 35
1763521 1763521 IN     school 1800176 9985   Seven Oaks Classical School 180017602603 1114 Seven Oaks Classical School   Regular School Yes Other KG 10 2019   grade_8                         5.0 10.0                       15.0                         5 10                 15
1751775 1751775 IN     school 1803630 235   Fort Wayne Community Schools 180363000548 128 Miami Middle School   Regular School No Middle 06 08 2019   grade_8                         97.0 100.0                       197.0                         97 100                 197
1757273 1757273 IN     school 1805580 4945   LaPorte Community School Corp 180558001019 4745 Paul F Boston Middle School   Regular School No Middle 06 08 2019   grade_8                         116.0 100.0                       216.0                         116 100                 216
1761486 1761486 IN     school 1811340 7865   Tippecanoe School Corp 181134001920 8049 Wea Ridge Middle School   Regular School No Middle 06 08 2019   grade_8                         125.0 101.0                       226.0                         125 101                 226
1760005 1760005 IN     school 1811970 6560   Valparaiso Community Schools 181197001881 6885 Benjamin Franklin Middle School   Regular School No Middle 06 08 2019   grade_8                         140.0 102.0                       242.0                         140 102                 242
1760465 1760465 IN     school 1809750 6995   Rush County Schools 180975002240 7290 Benjamin Rush Middle School   Regular School No Middle 07 08 2019   grade_8                         98.0 102.0                       200.0                         98 102                 200
1754964 1754964 IN     school 1810360 3190   South Harrison Com Schools 181036002283 2643 Corydon Central Jr High School   Regular School No Middle 07 08 2019   grade_8                         89.0 104.0                       193.0                         89 104                 193
1760783 1760783 IN     school 1810290 7205   South Bend Community School Corp 181029001661 7559 Dickinson Fine Arts Academy   Regular School No Middle 06 08 2019   grade_8                         109.0 104.0                       213.0                         109 104                 213
1761782 1761782 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345000481 8349 Plaza Park International Prep Acad   Regular School No Middle 06 08 2019   grade_8                         109.0 105.0                       214.0                         109 105                 214
1762510 1762510 IN     school 1808220 8435   Northern Wells Community Schools 180822002159 9088 Norwell Middle School   Regular School No Middle 06 08 2019   grade_8                         98.0 105.0                       203.0                         98 105                 203
1756782 1756782 IN     school 1803870 4690   Gary Community School Corp 180387002664 4178 Gary Middle School   Regular School No Middle 06 08 2019   grade_8                         147.0 106.0                       253.0                         147 106                 253
1754328 1754328 IN     school 1806390 2865   Marion Community Schools 180639001112 2357 John L McCulloch Junior High Sch   Regular School No Middle 07 08 2019   grade_8                         117.0 107.0                       224.0                         117 107                 224
1760521 1760521 IN     school 1808760 7175   Penn-Harris-Madison School Corp 180876001453 7336 Virgil I Grissom Middle School   Regular School No Middle 06 08 2019   grade_8                         109.0 107.0                       216.0                         109 107                 216
1760009 1760009 IN     school 1811970 6560   Valparaiso Community Schools 181197001890 6887 Thomas Jefferson Middle School   Regular School No Middle 06 08 2019   grade_8                         115.0 108.0                       223.0                         115 108                 223
1759615 1759615 IN     school 1810950 6195   Spencer-Owen Community Schools 181095001790 6597 Owen Valley Middle School   Regular School No Middle 07 08 2019   grade_8                         105.0 109.0                       214.0                         105 109                 214
1759707 1759707 IN     school 1801170 6340   Cannelton City Schools 180117000191 6733 Cannelton Elementary & High School   Regular School No Other PK 12 2019   grade_8                         10.0 11.0                       21.0                         10 11                 21
1763008 1763008 IN     school 1800198 9505   Indiana Agriculture and Technology 180019802665 5472 Indiana Agriculture and Technology   Regular School Yes High 07 12 2019   grade_8                         14.0 11.0                       25.0                         14 11                 25
1763099 1763099 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Special Education School No Other PK 12 2019   grade_8                         12.0 11.0                       23.0                         12 11                 23
1759020 1759020 IN     school 1809480 5705   Richland-Bean Blossom C S C 180948001547 6147 Edgewood Junior High School   Regular School No Middle 06 08 2019   grade_8                         96.0 110.0                       206.0                         96 110                 206
1762245 1762245 IN     school 1812390 8130   Warrick County School Corp 181239001976 8793 Boonville Middle School   Regular School No Middle 06 08 2019   grade_8                         138.0 110.0                       248.0                         138 110                 248
1752593 1752593 IN     school 1809370 940   West Clark Community Schools 180937001537 781 Silver Creek Middle School   Regular School No Middle 06 08 2019   grade_8                         108.0 111.0                       219.0                         108 111                 219
1753505 1753505 IN     school 1803960 2120   Greater Jasper Consolidated Schs 180396000686 1575 Jasper Middle School   Regular School No Middle 06 08 2019   grade_8                         109.0 111.0                       220.0                         109 111                 220
1753650 1753650 IN     school 1812240 2285   Wa-Nee Community Schools 181224001958 1669 North Wood Middle School   Regular School No Middle 06 09 2019   grade_8                         135.0 111.0                       246.0                         135 111                 246
1758261 1758261 IN     school 1800450 5380   Beech Grove City Schools 180045000092 5453 Beech Grove Middle School   Regular School No Middle 07 08 2019   grade_8                         114.0 111.0                       225.0                         114 111                 225
1761207 1761207 IN     school 1811100 7615   M S D Steuben County 181110001798 7895 Angola Middle School   Regular School No Middle 06 08 2019   grade_8                         109.0 111.0                       220.0                         109 111                 220
1756496 1756496 IN     school 1805450 4615   Lake Central School Corporation 180545000985 3831 Michael Grimmer Middle School   Regular School No Middle 05 08 2019   grade_8                         110.0 112.0                       222.0                         110 112                 222
1761890 1761890 IN     school 1812090 8030   Vigo County School Corp 181209001907 8445 Honey Creek Middle School   Regular School No Middle 06 08 2019   grade_8                         132.0 112.0                       244.0                         132 112                 244
1757246 1757246 IN     school 1805580 4945   LaPorte Community School Corp 180558001012 4717 Kesling Middle School   Regular School No Middle 06 08 2019   grade_8                         140.0 113.0                       253.0                         140 113                 253
1752044 1752044 IN     school 1802850 255   East Allen County Schools 180285000349 49 Leo Junior/Senior High School   Regular School No High 07 12 2019   grade_8                         108.0 115.0                       223.0                         108 115                 223
1752707 1752707 IN     school 1803940 1010   Greater Clark County Schools 180394000674 853 Parkview Middle School   Regular School No Middle 06 08 2019   grade_8                         113.0 115.0                       228.0                         113 115                 228
1755304 1755304 IN     school 1807440 3445   New Castle Community School Corp 180744001288 2829 New Castle Middle School   Regular School No Middle 07 08 2019   grade_8                         125.0 115.0                       240.0                         125 115                 240
1760725 1760725 IN     school 1810290 7205   South Bend Community School Corp 181029001709 7512 LaSalle Academy   Regular School No Middle 06 08 2019   grade_8                         89.0 115.0                       204.0                         89 115                 204
1752878 1752878 IN     school 1803660 1170   Community Schools of Frankfort 180366000573 999 Frankfort Middle School   Regular School No Middle 06 08 2019   grade_8                         126.0 117.0                       243.0                         126 117                 243
1755783 1755783 IN     school 1806120 3995   Madison Consolidated Schools 180612001091 3313 Madison Consolidated Jr High Sch   Regular School No Middle 05 08 2019   grade_8                         108.0 117.0                       225.0                         108 117                 225
1758620 1758620 IN     school 1804770 5385   Indianapolis Public Schools 180477000844 5601 H L Harshman Middle School   Regular School No Middle 07 08 2019   grade_8                         152.0 117.0                       269.0                         152 117                 269
1762641 1762641 IN     school 1802280 8665   Whitley County Con Schools 180228000824 9180 Indian Springs Middle School   Regular School No Middle 06 08 2019   grade_8                         139.0 117.0                       256.0                         139 117                 256
1751621 1751621 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000116 63 Summit Middle School   Regular School No Middle 06 08 2019   grade_8                         116.0 118.0                       234.0                         116 118                 234
1759943 1759943 IN     school 1809150 6550   Portage Township Schools 180915001519 6859 William Fegely Middle School   Regular School No Middle 06 08 2019   grade_8                         112.0 118.0                       230.0                         112 118                 230
1753989 1753989 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741001276 1937 Nathaniel Scribner Middle School   Regular School No Middle 05 08 2019   grade_8                         127.0 119.0                       246.0                         127 119                 246
1755665 1755665 IN     school 1812060 3710   Crothersville Community Schools 181206001893 3121 Crothersville Jr-Sr High School   Regular School No High 06 12 2019   grade_8                         8.0 12.0                       20.0                         8 12                 20
1758446 1758446 IN     school 1804770 5385   Indianapolis Public Schools 180477000831 5556 Francis W Parker School 56   Regular School No Elementary PK 08 2019   grade_8                         16.0 12.0                       28.0                         16 12                 28
1756857 1756857 IN     school 1804320 4710   School City of Hammond 180432000738 4425 Henry W Eggers Middle School   Regular School No Middle 06 08 2019   grade_8                         125.0 120.0                       245.0                         125 120                 245
1762219 1762219 IN     school 1812390 8130   Warrick County School Corp 181239001978 8775 Castle North Middle School   Regular School No Middle 06 08 2019   grade_8                         150.0 120.0                       270.0                         150 120                 270
1751771 1751771 IN     school 1803630 235   Fort Wayne Community Schools 180363000546 127 Memorial Park Middle School   Regular School No Middle 06 08 2019   grade_8                         89.0 121.0                       210.0                         89 121                 210
1756208 1756208 IN     school 1812420 4415   Warsaw Community Schools 181242002364 3607 Lakeview Middle School   Regular School No Middle 07 08 2019   grade_8                         133.0 122.0                       255.0                         133 122                 255
1756832 1756832 IN     school 1804320 4710   School City of Hammond 180432000734 4413 Donald E Gavit Middle/High School   Regular School No High 06 12 2019   grade_8                         109.0 122.0                       231.0                         109 122                 231
1758853 1758853 IN     school 1809060 5485   Plymouth Community School Corp 180906001499 5949 Lincoln Junior High School   Regular School No Middle 06 08 2019   grade_8                         148.0 122.0                       270.0                         148 122                 270
1751755 1751755 IN     school 1803630 235   Fort Wayne Community Schools 180363000534 119 Jefferson Middle School   Regular School No Middle 06 08 2019   grade_8                         150.0 123.0                       273.0                         150 123                 273
1752397 1752397 IN     school 1805790 665   Lebanon Community School Corp 180579001040 557 Lebanon Middle School   Regular School No Middle 06 08 2019   grade_8                         156.0 123.0                       279.0                         156 123                 279
1753754 1753754 IN     school 1803270 2305   Elkhart Community Schools 180327000440 1763 Pierre Moran Middle School   Regular School No Middle 07 08 2019   grade_8                         126.0 124.0                       250.0                         126 124                 250
1761908 1761908 IN     school 1812090 8030   Vigo County School Corp 181209001911 8477 Otter Creek Middle School   Regular School No Middle 06 08 2019   grade_8                         144.0 124.0                       268.0                         144 124                 268
1762178 1762178 IN     school 1812390 8130   Warrick County School Corp 181239002454 8760 Castle South Middle School   Regular School No Middle 06 08 2019   grade_8                         104.0 124.0                       228.0                         104 124                 228
1756532 1756532 IN     school 1805450 4615   Lake Central School Corporation 180545000982 3841 Kahler Middle School   Regular School No Middle 05 08 2019   grade_8                         135.0 125.0                       260.0                         135 125                 260
1756576 1756576 IN     school 1811460 4645   Tri-Creek School Corporation 181146001851 3851 Lowell Middle School   Regular School No Middle 06 08 2019   grade_8                         153.0 125.0                       278.0                         153 125                 278
1751767 1751767 IN     school 1803630 235   Fort Wayne Community Schools 180363000539 126 Lane Middle School   Regular School No Middle 06 08 2019   grade_8                         119.0 126.0                       245.0                         119 126                 245
1751968 1751968 IN     school 1803630 235   Fort Wayne Community Schools 180363000560 240 Shawnee Middle School   Regular School No Middle 06 08 2019   grade_8                         107.0 126.0                       233.0                         107 126                 233
1752809 1752809 IN     school 1800840 1125   Clay Community Schools 180084000165 925 North Clay Middle School   Regular School No Middle 06 08 2019   grade_8                         131.0 126.0                       257.0                         131 126                 257
1756970 1756970 IN     school 1804560 4720   School Town of Highland 180456000764 4283 Highland Middle School   Regular School No Middle 06 08 2019   grade_8                         109.0 126.0                       235.0                         109 126                 235
1756513 1756513 IN     school 1805450 4615   Lake Central School Corporation 180545002420 3838 Hal E Clark Middle School   Regular School No Middle 05 08 2019   grade_8                         151.0 127.0                       278.0                         151 127                 278
1756861 1756861 IN     school 1804320 4710   School City of Hammond 180432000732 4433 Charles N Scott Middle School   Regular School No Middle 06 08 2019   grade_8                         141.0 128.0                       269.0                         141 128                 269
1757102 1757102 IN     school 1807560 4805   New Prairie United School Corp 180756001299 7345 New Prairie Middle School   Regular School No Middle 06 08 2019   grade_8                         117.0 129.0                       246.0                         117 129                 246
1763322 1763322 IN     school 1800083 9835   The Bloomington Project School 180008302446 6215 The Bloomington Project School   Regular School Yes Elementary KG 08 2019   grade_8                         23.0 13.0                       36.0                         23 13                 36
1752754 1752754 IN     school 1803940 1010   Greater Clark County Schools 180394002131 883 River Valley Middle School   Regular School No Middle 06 08 2019   grade_8                         174.0 130.0                       304.0                         174 130                 304
1759160 1759160 IN     school 1800630 5740   Monroe County Community Sch Corp 180063001123 6223 Jackson Creek Middle School   Regular School No Middle 07 08 2019   grade_8                         174.0 130.0                       304.0                         174 130                 304
1756241 1756241 IN     school 1812420 4415   Warsaw Community Schools 181242002000 3653 Edgewood Middle School   Regular School No Middle 07 08 2019   grade_8                         134.0 131.0                       265.0                         134 131                 265
1751742 1751742 IN     school 1803630 235   Fort Wayne Community Schools 180363000516 107 Blackhawk Middle School   Regular School No Middle 06 08 2019   grade_8                         127.0 132.0                       259.0                         127 132                 259
1753984 1753984 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741001271 1933 Hazelwood Middle School   Regular School No Middle 05 08 2019   grade_8                         106.0 132.0                       238.0                         106 132                 238
1757987 1757987 IN     school 1812360 5360   M S D Warren Township 181236001961 5364 Creston Middle School   Regular School No Middle 07 08 2019   grade_8                         166.0 133.0                       299.0                         166 133                 299
1758112 1758112 IN     school 1812720 5370   M S D Washington Township 181272002013 5442 Eastwood Middle School   Regular School No Middle 06 08 2019   grade_8                         140.0 133.0                       273.0                         140 133                 273
1752334 1752334 IN     school 1802830 630   Zionsville Community Schools 180283002046 510 Zionsville West Middle School   Regular School No Middle 05 08 2019   grade_8                         123.0 134.0                       257.0                         123 134                 257
1755683 1755683 IN     school 1805280 3785   Kankakee Valley School Corp 180528000934 3183 Kankakee Valley Middle School   Regular School No Middle 06 08 2019   grade_8                         147.0 134.0                       281.0                         147 134                 281
1759088 1759088 IN     school 1800630 5740   Monroe County Community Sch Corp 180063002232 6170 Tri-North Middle School   Regular School No Middle 07 08 2019   grade_8                         140.0 135.0                       275.0                         140 135                 275
1755965 1755965 IN     school 1801440 4205   Center Grove Community School Corp 180144000210 3441 Center Grove Middle School Central   Regular School No Middle 06 08 2019   grade_8                         160.0 136.0                       296.0                         160 136                 296
1753217 1753217 IN     school 1801590 1835   DeKalb Co Ctl United Sch Dist 180159000221 1346 DeKalb Middle School   Regular School No Middle 06 08 2019   grade_8                         150.0 137.0                       287.0                         150 137                 287
1753913 1753913 IN     school 1803510 2395   Fayette County School Corporation 180351000496 1895 Connersville Middle School   Regular School No Middle 07 08 2019   grade_8                         157.0 137.0                       294.0                         157 137                 294
1759498 1759498 IN     school 1802970 6060   East Noble School Corporation 180297002335 6461 East Noble Middle School   Regular School No Middle 06 08 2019   grade_8                         129.0 137.0                       266.0                         129 137                 266
1754878 1754878 IN     school 1807260 3135   Mt Vernon Community School Corp 180726001222 2559 Mt Vernon Middle School   Regular School No Middle 06 08 2019   grade_8                         179.0 138.0                       317.0                         179 138                 317
1761916 1761916 IN     school 1812090 8030   Vigo County School Corp 181209001925 8485 Woodrow Wilson Middle School   Regular School No Middle 06 08 2019   grade_8                         114.0 138.0                       252.0                         114 138                 252
1755059 1755059 IN     school 1801020 3305   Brownsburg Community School Corp 180102000178 2713 Brownsburg West Middle School   Regular School No Middle 06 08 2019   grade_8                         167.0 139.0                       306.0                         167 139                 306
1761628 1761628 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345000475 8251 Lincoln School   Regular School No Elementary KG 08 2019   grade_8                         13.0 14.0                       27.0                         13 14                 27
1757993 1757993 IN     school 1812360 5360   M S D Warren Township 181236000229 5368 Raymond Park Middle School   Regular School No Middle 07 08 2019   grade_8                         155.0 140.0                       295.0                         155 140                 295
1758116 1758116 IN     school 1812720 5370   M S D Washington Township 181272002022 5445 Northview Middle School   Regular School No Middle 06 08 2019   grade_8                         156.0 140.0                       296.0                         156 140                 296
1760517 1760517 IN     school 1808760 7175   Penn-Harris-Madison School Corp 180876001452 7334 Schmucker Middle School   Regular School No Middle 06 08 2019   grade_8                         177.0 140.0                       317.0                         177 140                 317
1751664 1751664 IN     school 1808250 225   Northwest Allen County Schools 180825001380 79 Maple Creek Middle School   Regular School No Middle 06 08 2019   grade_8                         163.0 141.0                       304.0                         163 141                 304

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