enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2018 · 502 ✖

grade ✖

  • grade_8 · 502 ✖
Link rowid state county county_state_id admin_level district_nces_id district_state_id district_state_type district school_nces_id school_state_id school school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ccd_school_high_grade year term grade white black hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female ▼ non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
1787467 1787467 IN     school 1803630 235   Fort Wayne Community Schools 180363002174 100 Allen Co Juvenile Center   Regular School No Secondary 08 11 2018   grade_8                         1.0 0.0                       1.0                         1 0                 1
1788509 1788509 IN     school 1803940 1010   Greater Clark County Schools 180394000839 891 Clark County Middle/High School   Alternative School No High 07 12 2018   grade_8                         7.0 0.0                       7.0                         7 0                 7
1791173 1791173 IN     school 1804470 3490   Western School Corporation 180447000756 2921 Western High School   Regular School No High 08 12 2018   grade_8                         3.0 0.0                       3.0                         3 0                 3
1791395 1791395 IN     school 1801050 3695   Brownstown Cnt Com Sch Corp 180105001408 3108 Jackson Co Juvenile Detention Cntr   Alternative School No High 08 12 2018   grade_8                         1.0 0.0                       1.0                         1 0                 1
1794800 1794800 IN     school 1808850 5635   Peru Community Schools 180885001476 6085 Peru High School   Regular School No High 08 12 2018   grade_8                         1.0 0.0                       1.0                         1 0                 1
1798505 1798505 IN     school 1800006 9100   Indiana Department of Correction 180000601946 732 Logansport Juvenile Correctional   Regular School No High 07 12 2018   grade_8                         7.0 0.0                       7.0                         7 0                 7
1798518 1798518 IN     school 1800006 9100   Indiana Department of Correction 180000601935 5055 Pendleton Juvenile Correctional   Regular School No High 08 12 2018   grade_8                         5.0 0.0                       5.0                         5 0                 5
1798984 1798984 IN     school 1800128 9745   Tindley Preparatory Academy 180012802545 5336 Tindley Preparatory Academy   Regular School Yes Middle 06 08 2018   grade_8                         54.0 0.0                       54.0                         54 0                 54
1798997 1798997 IN     school 1800131 9760   Smith Academy for Excellence 180013102539 242 Smith Academy for Excellence   Regular School Yes Other 04 12 2018   grade_8                         6.0 0.0                       6.0                         6 0                 6
1789159 1789159 IN     school 1807320 1970   Muncie Community Schools 180732001232 1524 Youth Opportunity Center   Alternative School No Other 03 12 2018   grade_8                         10.0 1.0                       11.0                         10 1                 11
1790910 1790910 IN     school 1802550 3325   Danville Community School Corp 180255000304 2741 Danville Community High School   Regular School No High 08 12 2018   grade_8                         0.0 1.0                       1.0                         0 1                 1
1791039 1791039 IN     school 1807440 3445   New Castle Community School Corp 180744001290 2825 New Castle High School   Regular School No High 07 12 2018   grade_8                         0.0 1.0                       1.0                         0 1                 1
1791185 1791185 IN     school 1804470 3490   Western School Corporation 180447002224 2923 Western Intermediate School   Regular School No Middle 03 08 2018   grade_8                         0.0 1.0                       1.0                         0 1                 1
1792347 1792347 IN     school 1811460 4645   Tri-Creek School Corporation 181146001852 3865 Lowell Senior High School   Regular School No High 08 12 2018   grade_8                         2.0 1.0                       3.0                         2 1                 3
1794007 1794007 IN     school   5375   M S D Wayne Township   5271 Sanders School             2018   grade_8                         7.0 1.0                       8.0                         7 1                 8
1796677 1796677 IN     school 1810290 7205   South Bend Community School Corp 181029000898 7632 Juvenile Justice Center   Alternative School No High 08 12 2018   grade_8                         1.0 1.0                       2.0                         1 1                 2
1798252 1798252 IN     school 1809510 8385   Richmond Community Schools 180951000366 9056 Community Youth Services   Special Education School No Other KG 12 2018   grade_8                         10.0 1.0                       11.0                         10 1                 11
1798814 1798814 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 IN Sch for the Blind & Vis Imprd   Special Education School No Other PK 12 2018   grade_8                         2.0 1.0                       3.0                         2 1                 3
1798930 1798930 IN     school 1800065 9690   Renaissance Academy Charter School 180006502415 4711 Renaissance Academy Charter School   Regular School Yes Elementary KG 08 2018   grade_8                         10.0 10.0                       20.0                         10 10                 20
1799067 1799067 IN     school 1800083 9835   The Bloomington Project School 180008302446 6215 The Bloomington Project School   Regular School Yes Elementary KG 08 2018   grade_8                         23.0 10.0                       33.0                         23 10                 33
1799110 1799110 IN     school 1800088 9870   Discovery Charter School 180008802495 6824 Discovery Charter School   Regular School Yes Elementary KG 08 2018   grade_8                         13.0 10.0                       23.0                         13 10                 23
1797316 1797316 IN     school 1812870 7875   West Lafayette Com School Corp 181287002048 8129 West Lafayette Jr/Sr High School   Regular School No High 07 12 2018   grade_8                         101.0 100.0                       201.0                         101 100                 201
1787523 1787523 IN     school 1803630 235   Fort Wayne Community Schools 180363000553 129 Northwood Middle School   Regular School No Middle 06 08 2018   grade_8                         106.0 101.0                       207.0                         106 101                 207
1788991 1788991 IN     school 1802660 1875   Delaware Community School Corp 180266000323 1367 Delta Middle School   Regular School No Middle 06 08 2018   grade_8                         112.0 101.0                       213.0                         112 101                 213
1790042 1790042 IN     school 1806870 2855   Mississinewa Community School Corp 180687001190 2335 R J Baskett Middle School   Regular School No Middle 06 08 2018   grade_8                         108.0 101.0                       209.0                         108 101                 209
1792591 1792591 IN     school 1804170 4700   Griffith Public Schools 180417000721 4177 Griffith Middle School   Regular School No Middle 07 08 2018   grade_8                         120.0 101.0                       221.0                         120 101                 221
1794132 1794132 IN     school 1804770 5385   Indianapolis Public Schools 180477002528 5516 Northwest Community Middle School   Regular School No Middle 08 08 2018   grade_8                         119.0 101.0                       220.0                         119 101                 220
1794432 1794432 IN     school 1804770 5385   Indianapolis Public Schools 180477000844 5601 H L Harshman Middle School   Regular School No Middle 07 08 2018   grade_8                         155.0 101.0                       256.0                         155 101                 256
1797263 1797263 IN     school 1811340 7865   Tippecanoe School Corp 181134001822 8025 Battle Ground Middle School   Regular School No Middle 06 08 2018   grade_8                         109.0 101.0                       210.0                         109 101                 210
1787831 1787831 IN     school 1802850 255   East Allen County Schools 180285002509 294 Paul Harding Jr High School   Regular School No Middle 07 08 2018   grade_8                         74.0 102.0                       176.0                         74 102                 176
1787712 1787712 IN     school 1803630 235   Fort Wayne Community Schools 180363000560 240 Shawnee Middle School   Regular School No Middle 06 08 2018   grade_8                         96.0 103.0                       199.0                         96 103                 199
1788446 1788446 IN     school 1803940 1010   Greater Clark County Schools 180394000674 853 Parkview Middle School   Regular School No Middle 06 08 2018   grade_8                         125.0 103.0                       228.0                         125 103                 228
1789062 1789062 IN     school 1807230 1910   Yorktown Community Schools 180723001218 1387 Yorktown Middle School   Regular School No Middle 06 08 2018   grade_8                         94.0 103.0                       197.0                         94 103                 197
1797538 1797538 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345000486 8323 Thompkins Middle School   Regular School No Middle 06 08 2018   grade_8                         135.0 103.0                       238.0                         135 103                 238
1797023 1797023 IN     school 1811100 7615   M S D Steuben County 181110001798 7895 Angola Middle School   Regular School No Middle 06 08 2018   grade_8                         114.0 104.0                       218.0                         114 104                 218
1798030 1798030 IN     school 1812390 8130   Warrick County School Corp 181239001976 8793 Boonville Middle School   Regular School No Middle 06 08 2018   grade_8                         118.0 104.0                       222.0                         118 104                 222
1787789 1787789 IN     school 1802850 255   East Allen County Schools 180285000349 49 Leo Junior/Senior High School   Regular School No High 07 12 2018   grade_8                         109.0 107.0                       216.0                         109 107                 216
1797302 1797302 IN     school 1811340 7865   Tippecanoe School Corp 181134001920 8049 Wea Ridge Middle School   Regular School No Middle 06 08 2018   grade_8                         112.0 107.0                       219.0                         112 107                 219
1788332 1788332 IN     school 1809370 940   West Clark Community Schools 180937001537 781 Silver Creek Middle School   Regular School No Middle 06 08 2018   grade_8                         98.0 109.0                       207.0                         98 109                 207
1789720 1789720 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741001271 1933 Hazelwood Middle School   Regular School No Middle 05 08 2018   grade_8                         117.0 109.0                       226.0                         117 109                 226
1791546 1791546 IN     school 1806120 3995   Madison Consolidated Schools 180612001091 3313 Madison Consolidated Jr High Sch   Regular School No Middle 03 08 2018   grade_8                         124.0 109.0                       233.0                         124 109                 233
1792649 1792649 IN     school 1804320 4710   School City of Hammond 180432000738 4425 Henry W Eggers Middle School   Regular School No Middle 06 08 2018   grade_8                         123.0 109.0                       232.0                         123 109                 232
1794051 1794051 IN     school 1800450 5380   Beech Grove City Schools 180045000092 5453 Beech Grove Middle School   Regular School No Middle 07 08 2018   grade_8                         121.0 109.0                       230.0                         121 109                 230
1794548 1794548 IN     school 1804770 5385   Indianapolis Public Schools 180477002510 5668 Center for Inquiry School 27   Regular School No Elementary PK 08 2018   grade_8                         16.0 11.0                       27.0                         16 11                 27
1797088 1797088 IN     school 1810860 7715   Southwest School Corporation 181086002584 7954 Carlisle Middle School   Regular School No Middle 06 08 2018   grade_8                         14.0 11.0                       25.0                         14 11                 25
1799081 1799081 IN     school 1800087 9845   Xavier School of Excellence 180008702445 7571 Xavier School of Excellence   Regular School Yes Elementary KG 08 2018   grade_8                         4.0 11.0                       15.0                         4 11                 15
1799185 1799185 IN     school 1800160 9915   Marion Academy 180016002588 5903 Marion Academy   Regular School Yes High 06 12 2018   grade_8                         17.0 11.0                       28.0                         17 11                 28
1799290 1799290 IN     school 1800176 9985   Seven Oaks Classical School 180017602603 1114 Seven Oaks Classical School   Regular School Yes Other KG 09 2018   grade_8                         4.0 11.0                       15.0                         4 11                 15
1787515 1787515 IN     school 1803630 235   Fort Wayne Community Schools 180363000546 127 Memorial Park Middle School   Regular School No Middle 06 08 2018   grade_8                         73.0 110.0                       183.0                         73 110                 183
1791178 1791178 IN     school 1804470 3490   Western School Corporation 180447002225 2922 Western Middle School   Regular School No Middle 06 08 2018   grade_8                         110.0 110.0                       220.0                         110 110                 220
1796531 1796531 IN     school 1810290 7205   South Bend Community School Corp 181029001709 7512 LaSalle Academy   Regular School No Middle 05 08 2018   grade_8                         90.0 110.0                       200.0                         90 110                 200
1789494 1789494 IN     school 1803270 2305   Elkhart Community Schools 180327000440 1763 Pierre Moran Middle School   Regular School No Middle 07 08 2018   grade_8                         143.0 111.0                       254.0                         143 111                 254
1792261 1792261 IN     school 1805450 4615   Lake Central School Corporation 180545000985 3831 Michael Grimmer Middle School   Regular School No Middle 05 08 2018   grade_8                         99.0 112.0                       211.0                         99 112                 211
1792341 1792341 IN     school 1811460 4645   Tri-Creek School Corporation 181146001851 3851 Lowell Middle School   Regular School No Middle 06 08 2018   grade_8                         133.0 112.0                       245.0                         133 112                 245
1794906 1794906 IN     school 1800630 5740   Monroe County Community Sch Corp 180063002232 6170 Tri-North Middle School   Regular School No Middle 07 08 2018   grade_8                         159.0 112.0                       271.0                         159 112                 271
1797963 1797963 IN     school 1812390 8130   Warrick County School Corp 181239002454 8760 Castle South Middle School   Regular School No Middle 06 08 2018   grade_8                         113.0 113.0                       226.0                         113 113                 226
1794838 1794838 IN     school 1809480 5705   Richland-Bean Blossom C S C 180948001547 6147 Edgewood Junior High School   Regular School No Middle 06 08 2018   grade_8                         104.0 114.0                       218.0                         104 114                 218
1795320 1795320 IN     school 1802970 6060   East Noble School Corporation 180297002335 6461 East Noble Middle School   Regular School No Middle 07 08 2018   grade_8                         161.0 114.0                       275.0                         161 114                 275
1789387 1789387 IN     school 1812240 2285   Wa-Nee Community Schools 181224001958 1669 North Wood Middle School   Regular School No Middle 06 09 2018   grade_8                         123.0 115.0                       238.0                         123 115                 238
1795770 1795770 IN     school 1809150 6550   Portage Township Schools 180915001519 6859 William Fegely Middle School   Regular School No Middle 06 08 2018   grade_8                         127.0 115.0                       242.0                         127 115                 242
1787499 1787499 IN     school 1803630 235   Fort Wayne Community Schools 180363000534 119 Jefferson Middle School   Regular School No Middle 06 08 2018   grade_8                         102.0 116.0                       218.0                         102 116                 218
1792954 1792954 IN     school 1806570 4925   Michigan City Area Schools 180657001140 4789 Barker Middle School   Regular School No Middle 07 08 2018   grade_8                         86.0 116.0                       202.0                         86 116                 202
1788081 1788081 IN     school 1802830 630   Zionsville Community Schools 180283002046 510 Zionsville West Middle School   Regular School No Middle 05 08 2018   grade_8                         144.0 117.0                       261.0                         144 117                 261
1792624 1792624 IN     school 1804320 4710   School City of Hammond 180432000734 4413 Donald E Gavit Middle/High School   Regular School No High 06 12 2018   grade_8                         126.0 117.0                       243.0                         126 117                 243
1787362 1787362 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000116 63 Summit Middle School   Regular School No Middle 06 08 2018   grade_8                         132.0 118.0                       250.0                         132 118                 250
1789243 1789243 IN     school 1803960 2120   Greater Jasper Consolidated Schs 180396000686 1575 Jasper Middle School   Regular School No Middle 06 08 2018   grade_8                         143.0 118.0                       261.0                         143 118                 261
1792930 1792930 IN     school 1800107 4915   Tri-Township Cons School Corp 180010702520 4696 Wanatah School   Regular School No Elementary PK 08 2018   grade_8                         15.0 12.0                       27.0                         15 12                 27
1794250 1794250 IN     school 1804770 5385   Indianapolis Public Schools 180477000831 5556 Francis W Parker School 56   Regular School No Elementary PK 08 2018   grade_8                         12.0 12.0                       24.0                         12 12                 24
1795578 1795578 IN     school 1800118 6375   North Central Parke Comm Schl Corp 180011801858 6649 Turkey Run Jr-Sr High School   Regular School No High 07 12 2018   grade_8                         17.0 12.0                       29.0                         17 12                 29
1798493 1798493 IN     school 1800188 9045   J & R Phalen Leadership Academy 180018802618 4894 J & R Phalen Leadership Academy   Regular School Yes Middle 07 08 2018   grade_8                         25.0 12.0                       37.0                         25 12                 37
1792297 1792297 IN     school 1805450 4615   Lake Central School Corporation 180545000982 3841 Kahler Middle School   Regular School No Middle 05 08 2018   grade_8                         142.0 120.0                       262.0                         142 120                 262
1792893 1792893 IN     school 1807560 4805   New Prairie United School Corp 180756001299 7345 New Prairie Middle School   Regular School No Middle 06 08 2018   grade_8                         128.0 121.0                       249.0                         128 121                 249
1793038 1793038 IN     school 1805580 4945   LaPorte Community School Corp 180558001012 4717 Kesling Middle School   Regular School No Middle 06 08 2018   grade_8                         121.0 121.0                       242.0                         121 121                 242
1797680 1797680 IN     school 1812090 8030   Vigo County School Corp 181209001907 8445 Honey Creek Middle School   Regular School No Middle 06 08 2018   grade_8                         132.0 121.0                       253.0                         132 121                 253
1791043 1791043 IN     school 1807440 3445   New Castle Community School Corp 180744001288 2829 New Castle Middle School   Regular School No Middle 07 08 2018   grade_8                         127.0 122.0                       249.0                         127 122                 249
1793065 1793065 IN     school 1805580 4945   LaPorte Community School Corp 180558001019 4745 Paul F Boston Middle School   Regular School No Middle 06 08 2018   grade_8                         118.0 123.0                       241.0                         118 123                 241
1794909 1794909 IN     school 1800630 5740   Monroe County Community Sch Corp 180063000130 6172 Lora L Batchelor Middle School   Regular School No Middle 07 08 2018   grade_8                         120.0 123.0                       243.0                         120 123                 243
1794978 1794978 IN     school 1800630 5740   Monroe County Community Sch Corp 180063001123 6223 Jackson Creek Middle School   Regular School No Middle 07 08 2018   grade_8                         154.0 123.0                       277.0                         154 123                 277
1787511 1787511 IN     school 1803630 235   Fort Wayne Community Schools 180363000539 126 Lane Middle School   Regular School No Middle 06 08 2018   grade_8                         93.0 124.0                       217.0                         93 124                 217
1790063 1790063 IN     school 1806390 2865   Marion Community Schools 180639001112 2357 John L McCulloch Junior High Sch   Regular School No Middle 07 08 2018   grade_8                         125.0 124.0                       249.0                         125 124                 249
1788956 1788956 IN     school 1801590 1835   DeKalb Co Ctl United Sch Dist 180159000221 1346 DeKalb Middle School   Regular School No Middle 06 08 2018   grade_8                         127.0 125.0                       252.0                         127 125                 252
1789725 1789725 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741001276 1937 Nathaniel Scribner Middle School   Regular School No Middle 05 08 2018   grade_8                         112.0 125.0                       237.0                         112 125                 237
1791727 1791727 IN     school 1801440 4205   Center Grove Community School Corp 180144000210 3441 Center Grove Middle School Central   Regular School No Middle 06 08 2018   grade_8                         139.0 126.0                       265.0                         139 126                 265
1795833 1795833 IN     school 1811970 6560   Valparaiso Community Schools 181197001881 6885 Benjamin Franklin Middle School   Regular School No Middle 06 08 2018   grade_8                         143.0 126.0                       269.0                         143 126                 269
1788145 1788145 IN     school 1805790 665   Lebanon Community School Corp 180579001040 557 Lebanon Middle School   Regular School No Middle 06 08 2018   grade_8                         131.0 127.0                       258.0                         131 127                 258
1790566 1790566 IN     school 1810710 3115   Southern Hancock Co Com Sch Corp 181071001759 2566 New Palestine Jr High School   Regular School No Middle 07 08 2018   grade_8                         158.0 127.0                       285.0                         158 127                 285
1787405 1787405 IN     school 1808250 225   Northwest Allen County Schools 180825001380 79 Maple Creek Middle School   Regular School No Middle 06 08 2018   grade_8                         132.0 128.0                       260.0                         132 128                 260
1788344 1788344 IN     school 1809370 940   West Clark Community Schools 180937001540 813 William W Borden High School   Regular School No High 07 12 2018   grade_8                         41.0 13.0                       54.0                         41 13                 54
1789274 1789274 IN     school 1803480 2155   Fairfield Community Schools 180348000492 1621 Millersburg Elementary- Middle Sch   Regular School No Elementary KG 08 2018   grade_8                         16.0 13.0                       29.0                         16 13                 29
1794374 1794374 IN     school 1804770 5385   Indianapolis Public Schools 180477002555 5587 George Washington Carver School 87   Regular School No Elementary PK 08 2018   grade_8                         12.0 13.0                       25.0                         12 13                 25
1797470 1797470 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002462 8270 Academy for Innovative Studies   Regular School No Other 01 12 2018   grade_8                         25.0 13.0                       38.0                         25 13                 38
1798829 1798829 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Special Education School No Other PK 12 2018   grade_8                         7.0 13.0                       20.0                         7 13                 20
1787486 1787486 IN     school 1803630 235   Fort Wayne Community Schools 180363000516 107 Blackhawk Middle School   Regular School No Middle 06 08 2018   grade_8                         142.0 130.0                       272.0                         142 130                 272
1790264 1790264 IN     school 1810650 3005   Hamilton Southeastern Schools 181065000133 2489 Hamilton SE Int and Jr High Sch   Regular School No Middle 05 08 2018   grade_8                         152.0 130.0                       282.0                         152 130                 282
1793901 1793901 IN     school 1812720 5370   M S D Washington Township 181272002013 5442 Eastwood Middle School   Regular School No Middle 06 08 2018   grade_8                         140.0 130.0                       270.0                         140 130                 270
1797698 1797698 IN     school 1812090 8030   Vigo County School Corp 181209001911 8477 Otter Creek Middle School   Regular School No Middle 06 08 2018   grade_8                         145.0 132.0                       277.0                         145 132                 277
1792762 1792762 IN     school 1804560 4720   School Town of Highland 180456000764 4283 Highland Middle School   Regular School No Middle 06 08 2018   grade_8                         124.0 133.0                       257.0                         124 133                 257
1789649 1789649 IN     school 1803510 2395   Fayette County School Corporation 180351000496 1895 Connersville Middle School   Regular School No Middle 07 08 2018   grade_8                         148.0 134.0                       282.0                         148 134                 282
1791434 1791434 IN     school 1805280 3785   Kankakee Valley School Corp 180528000934 3183 Kankakee Valley Middle School   Regular School No Middle 06 08 2018   grade_8                         134.0 134.0                       268.0                         134 134                 268
1792474 1792474 IN     school 1802880 4670   School City of East Chicago 180288000370 3963 Joseph Block Middle School   Regular School No Middle 07 08 2018   grade_8                         144.0 134.0                       278.0                         144 134                 278

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