enrollments

Data source: Big Local News · About: Big Local

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

✎ 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
1787462 1787462 IN     school 1808250 225   Northwest Allen County Schools 180825002160 145 Allen Co Youth Services Center   Alternative School No Secondary 08 11 2018   grade_8                         0.0 3.0                       3.0                         0 3                 3
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
1792470 1792470 IN     school 1802880 4670   School City of East Chicago 180288000368 3961 George Washington Elementary Sch   Regular School No Elementary KG 08 2018   grade_8                         0.0 2.0                       2.0                         0 2                 2
1792525 1792525 IN     school 1803870 4690   Gary Community School Corp 180387000620 4086 Frankie W McCullough Acad for Girl   Regular School No Elementary KG 08 2018   grade_8                         0.0 36.0                       36.0                         0 36                 36
1796825 1796825 IN     school 1810140 7365   Shelbyville Central Schools 181014002496 7671 Especially Kidz Health & Rehab Cnt   Regular School No Other 02 12 2018   grade_8                         0.0 2.0                       2.0                         0 2                 2
1799227 1799227 IN     school 1800139 9940   Tindley Collegiate Academy 180013902559 5914 Tindley Collegiate Academy   Regular School Yes Middle 06 08 2018   grade_8                         0.0 67.0                       67.0                         0 67                 67
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
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
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
1798979 1798979 IN     school 1800121 9740   Thurgood Marshall Leadership Acad 180012102540 138 Thurgood Marshall Leadership Acad   Regular School Yes Elementary KG 08 2018   grade_8                         1.0 2.0                       3.0                         1 2                 3
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
1796771 1796771 IN     school 1803210 7285   Shelby Eastern Schools 180321000420 7665 Waldron Jr-Sr High School   Regular School No High 06 12 2018   grade_8                         10.0 23.0                       33.0                         10 23                 33
1797004 1797004 IN     school 1804230 7610   Hamilton Community Schools 180423000724 7885 Hamilton Community High School   Regular School No High 07 12 2018   grade_8                         10.0 8.0                       18.0                         10 8                 18
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
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
1798969 1798969 IN     school 1800123 9735   Inspire Academy - A Sch of Inquiry 180012302560 1518 Inspire Academy - A Sch of Inquiry   Regular School Yes Elementary KG 08 2018   grade_8                         10.0 5.0                       15.0                         10 5                 15
1799198 1799198 IN     school 1800108 9920   Damar Charter Academy 180010802503 5191 Damar Charter Academy   Regular School Yes Other KG 12 2018   grade_8                         10.0 2.0                       12.0                         10 2                 12
1788816 1788816 IN     school 1800240 1600   South Dearborn Community Sch Corp 180024000958 1172 South Dearborn Middle School   Regular School No Middle 07 08 2018   grade_8                         100.0 91.0                       191.0                         100 91                 191
1789843 1789843 IN     school 1803700 2475   Franklin County Community Sch Corp 180370000589 2123 Franklin County Middle School   Regular School No Middle 06 08 2018   grade_8                         100.0 91.0                       191.0                         100 91                 191
1790295 1790295 IN     school 1804260 3025   Hamilton Heights School Corp 180426000727 2501 Hamilton Heights Middle School   Regular School No Middle 06 08 2018   grade_8                         100.0 97.0                       197.0                         100 97                 197
1795903 1795903 IN     school 1807290 6590   M S D Mount Vernon 180729001227 6953 Mount Vernon Jr High School   Regular School No Middle 06 08 2018   grade_8                         100.0 66.0                       166.0                         100 66                 166
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
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
1790687 1790687 IN     school 1800690 3180   North Harrison Com School Corp 180069000145 2625 North Harrison Middle School   Regular School No Middle 06 08 2018   grade_8                         102.0 89.0                       191.0                         102 89                 191
1798374 1798374 IN     school 1811580 8565   Twin Lakes School Corp 181158001862 9153 Roosevelt Middle School   Regular School No Middle 06 08 2018   grade_8                         103.0 79.0                       182.0                         103 79                 182
1793158 1793158 IN     school 1807860 5075   North Lawrence Com Schools 180786001336 4905 Bedford Middle School   Regular School No Middle 06 08 2018   grade_8                         104.0 88.0                       192.0                         104 88                 192
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
1796734 1796734 IN     school 1810020 7255   Scott County School District 2 181002001611 7645 Scottsburg Middle School   Regular School No Middle 06 08 2018   grade_8                         104.0 96.0                       200.0                         104 96                 200
1792108 1792108 IN     school 1813110 4525   Westview School Corporation 181311002079 3697 Westview Jr-Sr High School   Regular School No High 06 12 2018   grade_8                         105.0 91.0                       196.0                         105 91                 196
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
1796329 1796329 IN     school 1808760 7175   Penn-Harris-Madison School Corp 180876001453 7336 Virgil I Grissom Middle School   Regular School No Middle 06 08 2018   grade_8                         106.0 96.0                       202.0                         106 96                 202
1790917 1790917 IN     school 1802550 3325   Danville Community School Corp 180255000305 2743 Danville Middle School   Regular School No Middle 04 08 2018   grade_8                         107.0 81.0                       188.0                         107 81                 188
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
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
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
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
1789100 1789100 IN     school 1807320 1970   Muncie Community Schools 180732002320 1431 Northside Middle School   Regular School No Middle 06 08 2018   grade_8                         111.0 87.0                       198.0                         111 87                 198
1791494 1791494 IN     school 1804980 3945   Jay School Corporation 180498000912 3265 East Jay County Middle School   Regular School No Middle 06 08 2018   grade_8                         111.0 87.0                       198.0                         111 87                 198
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
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
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
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
1798466 1798466 IN     school 1800127 8825   CSUSA Donnan 180012700823 5572 Emma Donnan Middle School   Regular School No Middle 07 08 2018   grade_8                         113.0 74.0                       187.0                         113 74                 187
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
1795837 1795837 IN     school 1811970 6560   Valparaiso Community Schools 181197001890 6887 Thomas Jefferson Middle School   Regular School No Middle 06 08 2018   grade_8                         115.0 86.0                       201.0                         115 86                 201
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
1791902 1791902 IN     school 1812120 4335   Vincennes Community School Corp 181212001928 3557 George Rogers Clark School   Regular School No Middle 06 08 2018   grade_8                         117.0 94.0                       211.0                         117 94                 211
1788619 1788619 IN     school 1803660 1170   Community Schools of Frankfort 180366000573 999 Frankfort Middle School   Regular School No Middle 06 08 2018   grade_8                         118.0 95.0                       213.0                         118 95                 213
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
1797706 1797706 IN     school 1812090 8030   Vigo County School Corp 181209001925 8485 Woodrow Wilson Middle School   Regular School No Middle 06 08 2018   grade_8                         118.0 138.0                       256.0                         118 138                 256
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
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
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
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
1795106 1795106 IN     school 1803330 5910   Eminence Community School Corp 180333000454 6325 Eminence Jr-Sr High School   Regular School No High 06 12 2018   grade_8                         12.0 16.0                       28.0                         12 16                 28
1797433 1797433 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345000475 8251 Lincoln School   Regular School No Elementary KG 08 2018   grade_8                         12.0 14.0                       26.0                         12 14                 26
1797904 1797904 IN     school 1812180 8050   M S D Wabash County Schools 181218001951 8673 White's Jr-Sr High School   Regular School No High 06 12 2018   grade_8                         12.0 2.0                       14.0                         12 2                 14
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
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
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
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
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
1791271 1791271 IN     school 1804710 3625   Huntington Co Com Sch Corp 180471000790 3025 Riverview School   Regular School No Middle 06 08 2018   grade_8                         123.0 92.0                       215.0                         123 92                 215
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
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
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
1797574 1797574 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345000481 8349 Plaza Park International Prep Acad   Regular School No Middle 06 08 2018   grade_8                         124.0 78.0                       202.0                         124 78                 202
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
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
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
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
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
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
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
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
1799246 1799246 IN     school 1800165 9950   Dugger Union Community School Corp 180016502590 7952 Dugger Union Community School Corp   Regular School Yes Other KG 12 2018   grade_8                         13.0 18.0                       31.0                         13 18                 31
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
1794135 1794135 IN     school 1804770 5385   Indianapolis Public Schools 180477002524 5517 John Marshall Middle   Regular School No Middle 07 08 2018   grade_8                         131.0 93.0                       224.0                         131 93                 224
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
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
1791968 1791968 IN     school 1812420 4415   Warsaw Community Schools 181242002364 3607 Lakeview Middle School   Regular School No Middle 07 08 2018   grade_8                         132.0 139.0                       271.0                         132 139                 271
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
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
1796837 1796837 IN     school 1810140 7365   Shelbyville Central Schools 181014001630 7721 Shelbyville Middle School   Regular School No Middle 06 08 2018   grade_8                         133.0 149.0                       282.0                         133 149                 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
1793905 1793905 IN     school 1812720 5370   M S D Washington Township 181272002022 5445 Northview Middle School   Regular School No Middle 06 08 2018   grade_8                         134.0 136.0                       270.0                         134 136                 270
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
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
1789781 1789781 IN     school 1800210 2435   Attica Consolidated School Corp 180021000050 2053 Attica High School   Regular School No High 07 12 2018   grade_8                         14.0 28.0                       42.0                         14 28                 42
1791416 1791416 IN     school 1812060 3710   Crothersville Community Schools 181206001893 3121 Crothersville Jr-Sr High School   Regular School No High 06 12 2018   grade_8                         14.0 16.0                       30.0                         14 16                 30
1793292 1793292 IN     school 1800150 5275   Anderson Community School Corp 180015002623 4906 COMPASS Alternative School   Alternative School No Middle 06 09 2018   grade_8                         14.0 7.0                       21.0                         14 7                 21
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
1799056 1799056 IN     school 1800072 9805   Hoosier Academy - Indianapolis 180007202422 2527 Hoosier Academy - Indianapolis   Regular School Yes Other KG 12 2018   grade_8                         14.0 5.0                       19.0                         14 5                 19
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
1792831 1792831 IN     school 1807350 4740   School Town of Munster 180735001259 4333 Wilbur Wright Middle School   Regular School No Middle 06 08 2018   grade_8                         141.0 168.0                       309.0                         141 168                 309
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
1792002 1792002 IN     school 1812420 4415   Warsaw Community Schools 181242002000 3653 Edgewood Middle School   Regular School No Middle 07 08 2018   grade_8                         142.0 156.0                       298.0                         142 156                 298

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