enrollments

Data source: Big Local News · About: Big Local

3,528 rows where grade = "grade_8" and state = "IN" sorted by female

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_8 · 3,428 ✖
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
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
1910747 1910747 IN     school 1807440 3445   New Castle Community School Corp 180744001290 2825 New Castle High School   Regular School No High 07 12 2020   grade_8                         1.0 1.0                       2.0                         1 1                 2
1911541 1911541 IN     school 1807620 4255   Nineveh-Hensley-Jackson United 180762002686 3414 Indiana Academy Online   Regular School No High 07 12 2020   grade_8                         1.0 1.0                       2.0                         1 1                 2
1914408 1914408 IN     school 1808850 5635   Peru Community Schools 180885001476 6085 Peru High School   Regular School No High 08 12 2020   grade_8                         2.0 1.0                       3.0                         2 1                 3
1918113 1918113 IN     school 1800205 8690   Dynamic Minds Academy 180020502673 8692 Dynamic Minds Academy   Regular School Yes Other KG 12 2020   grade_8                         8.0 1.0                       9.0                         8 1                 9
1919971 1919971 IN     school 1806030 875   Logansport Community Sch Corp 180603001052 715 Columbia 6th Grade Academy   Regular School No Other 03 12 2021   grade_8                         3.0 1.0                       4.0                         3 1                 4
1920987 1920987 IN     school 1802400 2270   Concord Community Schools 180240002484 1718 Concord Intermediate School   Regular School No Middle 04 08 2021   grade_8                         0.0 1.0                       1.0                         0 1                 1
1922706 1922706 IN     school 1807440 3445   New Castle Community School Corp 180744001290 2825 New Castle High School   Regular School No High 07 12 2021   grade_8                         1.0 1.0                       2.0                         1 1                 2
1922849 1922849 IN     school 1804470 3490   Western School Corporation 180447002224 2923 Western Intermediate School   Regular School No Middle 03 08 2021   grade_8                         1.0 1.0                       2.0                         1 1                 2
1923213 1923213 IN     school 1806120 3995   Madison Consolidated Schools 180612002695 3358 E.O. Muncie Jr/Sr High School   Regular School No High 07 12 2021   grade_8                         2.0 1.0                       3.0                         2 1                 3
1925551 1925551 IN     school   5375   MSD Wayne Township   5271 Sanders School             2021   grade_8                         6.0 1.0                       7.0                         6 1                 7
1926286 1926286 IN     school 1808850 5635   Peru Community Schools 180885001476 6085 Peru High School   Regular School No High 08 12 2021   grade_8                         4.0 1.0                       5.0                         4 1                 5
1929412 1929412 IN     school 1812090 8030   Vigo County School Corp 181209002344 8611 Booker T Washington Alt Sch   Alternative School No High 06 12 2021   grade_8                         9.0 1.0                       10.0                         9 1                 10
1930091 1930091 IN     school 1800222 9000   Phalen Virtual Leadership Academy 180022202707 9992 Phalen Virtual Leadership Academy   Regular School Yes Other 02 12 2021   grade_8                         2.0 1.0                       3.0                         2 1                 3
1930548 1930548 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 2021   grade_8                         2.0 1.0                       3.0                         2 1                 3
1163534 1163534 IN     school 1801230 3640   Medora Community School Corp 180123000201 3093 Medora Jr & Sr High School   Regular School No 4.0 06 12 2015   grade_8                         11.0 10.0                       21.0                         11 10                 21
1165178 1165178 IN     school 1800107 4915   Tri-Township Cons School Corp 180010702520 4696 Wanatah School   Regular School No 1.0 KG 08 2015   grade_8                         18.0 10.0                       28.0                         18 10                 28
1171140 1171140 IN     school 1800061 9665   Geist Montessori Academy 180006102387 2572 Geist Montessori Academy   Regular School Yes 1.0 KG 08 2015   grade_8                         13.0 10.0                       23.0                         13 10                 23
1283474 1283474 IN     school 1803700 2475   Franklin County Com Sch Corp 180370000591 2127 Mount Carmel School   Regular School No 1.0 KG 08 2016   grade_8                         22.0 10.0                       32.0                         22 10                 32
1287804 1287804 IN     school 1804770 5385   Indianapolis Public Schools 180477000866 5531 James A Garfield Sch 31   Regular School No 1.0 KG 08 2016   grade_8                         15.0 10.0                       25.0                         15 10                 25
1288208 1288208 IN     school 1804770 5385   Indianapolis Public Schools 180477002510 5668 Center for Inquiry III   Regular School No 1.0 PK 08 2016   grade_8                         6.0 10.0                       16.0                         6 10                 16
1294815 1294815 IN     school 1807320 1970   Muncie Community Schools 180732001232 1524 Youth Opportunity Center   Alternative School No Other 02 12 2017   grade_8                         12.0 10.0                       22.0                         12 10                 22
1300060 1300060 IN     school 1804770 5385   Indianapolis Public Schools 180477002555 5587 George Washington Carver School 87   Regular School No Elementary PK 08 2017   grade_8                         10.0 10.0                       20.0                         10 10                 20
1300231 1300231 IN     school 1804770 5385   Indianapolis Public Schools 180477002510 5668 Center for Inquiry School 27   Regular School No Elementary PK 08 2017   grade_8                         22.0 10.0                       32.0                         22 10                 32
1304560 1304560 IN     school 1800061 9665   Geist Montessori Academy 180006102387 2572 Geist Montessori Academy   Regular School Yes Elementary KG 08 2017   grade_8                         12.0 10.0                       22.0                         12 10                 22
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
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
1913785 1913785 IN     school 1804770 5385   Indianapolis Public Schools 180477002605 5538 Center for Inquiry School 70   Regular School No Elementary KG 08 2020   grade_8                         15.0 10.0                       25.0                         15 10                 25
1918199 1918199 IN     school 1800193 9080   Vanguard Collegiate of Indy 180019302639 1004 Vanguard Collegiate of Indy   Regular School Yes Middle 05 08 2020   grade_8                         4.0 10.0                       14.0                         4 10                 14
1918277 1918277 IN     school 1800208 9165   Paramount Englewood 180020802655 7861 Paramount Englewood   Regular School Yes Middle 05 08 2020   grade_8                         8.0 10.0                       18.0                         8 10                 18
1923586 1923586 IN     school 1812120 4335   Vincennes Community School Corp 181212002696 4319 Washington Learning Academy   Regular School No High 06 12 2021   grade_8                         13.0 10.0                       23.0                         13 10                 23
1924849 1924849 IN     school 1800150 5275   Anderson Community School Corp 180015002623 4906 COMPASS Alternative School   Alternative School No Secondary 07 10 2021   grade_8                         19.0 10.0                       29.0                         19 10                 29
1926994 1926994 IN     school 1801170 6340   Cannelton City Schools 180117000191 6733 Cannelton Elementary & High School   Regular School No Other PK 12 2021   grade_8                         9.0 10.0                       19.0                         9 10                 19
1928965 1928965 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345000475 8251 Lincoln School   Regular School No Elementary KG 08 2021   grade_8                         8.0 10.0                       18.0                         8 10                 18
1930762 1930762 IN     school 1800088 9870   Discovery Charter School 180008802495 6824 Discovery Charter School   Regular School Yes Elementary KG 08 2021   grade_8                         17.0 10.0                       27.0                         17 10                 27
1930948 1930948 IN     school 1800178 9990   Higher Institute of Arts & Tech 180017802602 1116 Higher Institute of Arts & Tech   Regular School Yes Elementary KG 08 2021   grade_8                         11.0 10.0                       21.0                         11 10                 21
1167627 1167627 IN     school 1812900 6065   West Noble School Corporation 181290002059 6509 West Noble Middle School   Regular School No 2.0 05 08 2015   grade_8                         102.0 100.0                       202.0                         102 100                 202
1169804 1169804 IN     school 1803450 7995   Evansville Vanderburgh Sch Corp 180345000486 8323 Thompkins Middle School   Regular School No 2.0 06 08 2015   grade_8                         137.0 100.0                       237.0                         137 100                 237
1281848 1281848 IN     school 1806030 875   Logansport Community Sch Corp 180603001058 702 Lincoln Middle School   Regular School No 2.0 06 08 2016   grade_8                         93.0 100.0                       193.0                         93 100                 193
1285152 1285152 IN     school 1806120 3995   Madison Consolidated Schools 180612001091 3313 Madison Consolidated Jr High Sch   Regular School No 2.0 06 08 2016   grade_8                         101.0 100.0                       201.0                         101 100                 201
1288787 1288787 IN     school 1806510 5925   M S D Martinsville Schools 180651001134 6333 Ronald K Bell East Middle School   Regular School No 2.0 06 08 2016   grade_8                         91.0 100.0                       191.0                         91 100                 191
1293343 1293343 IN     school 1803630 235   Fort Wayne Community Schools 180363000560 240 Shawnee Middle School   Regular School No Middle 06 08 2017   grade_8                         131.0 100.0                       231.0                         131 100                 231
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
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
1914437 1914437 IN     school 1809480 5705   Richland-Bean Blossom C S C 180948001547 6147 Edgewood Junior High School   Regular School No Middle 06 08 2020   grade_8                         100.0 100.0                       200.0                         100 100                 200
1923557 1923557 IN     school 1812120 4335   Vincennes Community School Corp 181212001928 3557 George Rogers Clark School   Regular School No Middle 06 08 2021   grade_8                         107.0 100.0                       207.0                         107 100                 207
1925668 1925668 IN     school 1804770 5385   Indianapolis Public Schools 180477002528 5516 Northwest Community Middle School   Regular School No Middle 07 08 2021   grade_8                         95.0 100.0                       195.0                         95 100                 195
1926314 1926314 IN     school 1809480 5705   Richland-Bean Blossom C S C 180948001547 6147 Edgewood Junior High School   Regular School No Middle 06 08 2021   grade_8                         102.0 100.0                       202.0                         102 100                 202
1161482 1161482 IN     school 1803480 2155   Fairfield Community Schools 180348000491 1613 Fairfield Jr-Sr High School   Regular School No 3.0 07 12 2015   grade_8                         85.0 101.0                       186.0                         85 101                 186
1170731 1170731 IN     school 1800127 8825   CSUSA Donnan 180012700823 5572 Emma Donnan Middle School   Regular School No 2.0 07 08 2015   grade_8                         91.0 101.0                       192.0                         91 101                 192
1282029 1282029 IN     school 1803940 1010   Greater Clark County Schools 180394000674 853 Parkview Middle School   Regular School No 2.0 06 08 2016   grade_8                         131.0 101.0                       232.0                         131 101                 232
1282594 1282594 IN     school 1802660 1875   Delaware Community School Corp 180266000323 1367 Delta Middle School   Regular School No 2.0 06 08 2016   grade_8                         115.0 101.0                       216.0                         115 101                 216
1283657 1283657 IN     school 1806870 2855   Mississinewa Community School Corp 180687001190 2335 R J Baskett Middle School   Regular School No 2.0 06 08 2016   grade_8                         121.0 101.0                       222.0                         121 101                 222
1288783 1288783 IN     school 1806510 5925   M S D Martinsville Schools 180651001136 6331 Martinsville West Middle School   Regular School No 2.0 06 08 2016   grade_8                         95.0 101.0                       196.0                         95 101                 196
1290189 1290189 IN     school 1810290 7205   South Bend Community Sch Corp 181029001709 7512 LaSalle Intermediate Academy   Regular School No 2.0 05 08 2016   grade_8                         89.0 101.0                       190.0                         89 101                 190
1294745 1294745 IN     school 1807320 1970   Muncie Community Schools 180732002320 1431 Northside Middle School   Regular School No Middle 06 08 2017   grade_8                         102.0 101.0                       203.0                         102 101                 203
1303259 1303259 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345000481 8349 Plaza Park International Prep Acad   Regular School No Middle 06 08 2017   grade_8                         99.0 101.0                       200.0                         99 101                 200
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
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
1911945 1911945 IN     school 1805450 4615   Lake Central School Corporation 180545000985 3831 Michael Grimmer Middle School   Regular School No Middle 05 08 2020   grade_8                         127.0 101.0                       228.0                         127 101                 228
1914357 1914357 IN     school 1806090 5615   Maconaquah School Corp 180609001079 6033 Maconaquah Middle School   Regular School No Middle 06 08 2020   grade_8                         89.0 101.0                       190.0                         89 101                 190
1922956 1922956 IN     school 1804710 3625   Huntington Co Com Sch Corp 180471000784 3061 Crestview Middle School   Regular School No Middle 06 08 2021   grade_8                         120.0 101.0                       221.0                         120 101                 221
1167096 1167096 IN     school 1809480 5705   Richland-Bean Blossom C S C 180948001547 6147 Edgewood Junior High School   Regular School No 2.0 06 08 2015   grade_8                         121.0 102.0                       223.0                         121 102                 223
1168599 1168599 IN     school 1808760 7175   Penn-Harris-Madison Sch Corp 180876001453 7336 Virgil I Grissom Middle Sch   Regular School No 2.0 06 08 2015   grade_8                         107.0 102.0                       209.0                         107 102                 209
1296939 1296939 IN     school 1804710 3625   Huntington Co Com Sch Corp 180471000784 3061 Crestview Middle School   Regular School No Middle 06 08 2017   grade_8                         91.0 102.0                       193.0                         91 102                 193
1303000 1303000 IN     school 1812870 7875   West Lafayette Com School Corp 181287002048 8129 West Lafayette Jr/Sr High School   Regular School No High 07 12 2017   grade_8                         79.0 102.0                       181.0                         79 102                 181
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
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
1907526 1907526 IN     school 1802850 255   East Allen County Schools 180285002509 294 Paul Harding Jr High School   Regular School No Middle 07 08 2020   grade_8                         106.0 102.0                       208.0                         106 102                 208
1908147 1908147 IN     school 1803940 1010   Greater Clark County Schools 180394002128 863 Charlestown Middle School   Regular School No Middle 06 08 2020   grade_8                         91.0 102.0                       193.0                         91 102                 193
1923912 1923912 IN     school 1805450 4615   Lake Central School Corporation 180545000985 3831 Michael Grimmer Middle School   Regular School No Middle 05 08 2021   grade_8                         105.0 102.0                       207.0                         105 102                 207
1160938 1160938 IN     school 1812450 1405   Washington Com Schools 181245002007 1123 Washington Junior High School   Regular School No 2.0 07 08 2015   grade_8                         93.0 103.0                       196.0                         93 103                 196
1168798 1168798 IN     school 1810290 7205   South Bend Community Sch Corp 181029001709 7512 LaSalle Intermediate Academy   Regular School No 2.0 05 08 2015   grade_8                         93.0 103.0                       196.0                         93 103                 196
1296914 1296914 IN     school 1804710 3625   Huntington Co Com Sch Corp 180471000790 3025 Riverview School   Regular School No Middle 06 08 2017   grade_8                         111.0 103.0                       214.0                         111 103                 214
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
1928547 1928547 IN     school 1811100 7615   MSD Steuben County 181110001798 7895 Angola Middle School   Regular School No Middle 06 08 2021   grade_8                         106.0 103.0                       209.0                         106 103                 209
1929592 1929592 IN     school 1812390 8130   Warrick County School Corp 181239001976 8793 Boonville Middle School   Regular School No Middle 06 08 2021   grade_8                         124.0 103.0                       227.0                         124 103                 227
1289930 1289930 IN     school 1809750 6995   Rush County Schools 180975002240 7290 Benjamin Rush Middle School   Regular School No 2.0 07 08 2016   grade_8                         98.0 104.0                       202.0                         98 104                 202
1290394 1290394 IN     school 1810020 7255   Scott County School District 2 181002001611 7645 Scottsburg Middle School   Regular School No 2.0 06 08 2016   grade_8                         81.0 104.0                       185.0                         81 104                 185
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

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