enrollments

Data source: Big Local News · About: Big Local

6,726 rows where grade = "grade_5" and state = "IN" sorted by male

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_5 · 6,726 ✖
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
1161574 1161574 IN     school 1806600 2275   Middlebury Community Schools 180660001162 1657 Northridge Middle School   Regular School No 2.0 04 09 2015   grade_5                         0.0 2.0                       2.0                         0 2                 2
1164413 1164413 IN     school 1804620 4590   River Forest Community Sch Corp 180462000779 3805 John I Meister Elementary School   Regular School No 1.0 KG 06 2015   grade_5                         0.0 1.0                       1.0                         0 1                 1
1164752 1164752 IN     school 1803870 4690   Gary Community School Corp 180387000620 4086 Frankie W McCullough Acad for Girl   Regular School No 1.0 KG 07 2015   grade_5                         0.0 47.0                       47.0                         0 47                 47
1169098 1169098 IN     school 1810140 7365   Shelbyville Central Schools 181014002496 7671 Especially Kidz Health & Rehab Cnt   Regular School No 4.0 PK 12 2015   grade_5                         0.0 2.0                       2.0                         0 2                 2
1171495 1171495 IN     school 1800139 9940   Tindley Collegiate Academy 180013902559 5914 Tindley Collegiate Academy   Regular School Yes 2.0 05 08 2015   grade_5                         0.0 41.0                       41.0                         0 41                 41
1283004 1283004 IN     school 1812240 2285   Wa-Nee Community Schools 181224001958 1669 North Wood Middle School   Regular School No 2.0 05 09 2016   grade_5                         0.0 1.0                       1.0                         0 1                 1
1284513 1284513 IN     school 1802550 3325   Danville Community School Corp 180255000306 2721 North Elementary School   Regular School No 1.0 PK 05 2016   grade_5                         0.0 1.0                       1.0                         0 1                 1
1286144 1286144 IN     school 1803870 4690   Gary Community School Corp 180387000620 4086 Frankie W McCullough Acad for Girl   Regular School No 1.0 KG 08 2016   grade_5                         0.0 49.0                       49.0                         0 49                 49
1288315 1288315 IN     school 1809060 5485   Plymouth Community School Corp 180906001503 5933 Menominee Elementary School   Regular School No 1.0 KG 05 2016   grade_5                         0.0 2.0                       2.0                         0 2                 2
1296550 1296550 IN     school 1802550 3325   Danville Community School Corp 180255000306 2721 North Elementary School   Regular School No Elementary PK 05 2017   grade_5                         0.0 1.0                       1.0                         0 1                 1
1296718 1296718 IN     school 1807440 3445   New Castle Community School Corp 180744001289 2853 Sunnyside Elementary School   Regular School No Elementary KG 07 2017   grade_5                         0.0 1.0                       1.0                         0 1                 1
1298187 1298187 IN     school 1803870 4690   Gary Community School Corp 180387000620 4086 Frankie W McCullough Acad for Girl   Regular School No Elementary KG 08 2017   grade_5                         0.0 42.0                       42.0                         0 42                 42
1300476 1300476 IN     school 1808340 5625   Oak Hill United School Corp 180834001432 6081 Sweetser Elementary School   Regular School No Elementary KG 05 2017   grade_5                         0.0 1.0                       1.0                         0 1                 1
1753597 1753597 IN     school 1802400 2270   Concord Community Schools 180240000272 1723 Concord Ox-Bow Elementary School   Regular School No Elementary KG 05 2019   grade_5                         0.0 1.0                       1.0                         0 1                 1
1753835 1753835 IN     school 1803930 2315   Goshen Community Schools 180393000659 1629 Goshen Middle School   Regular School No High 05 12 2019   grade_5                         0.0 1.0                       1.0                         0 1                 1
1754562 1754562 IN     school 1813080 3030   Westfield-Washington Schools 181308002074 2491 Westfield Middle School   Regular School No Middle 05 08 2019   grade_5                         0.0 1.0                       1.0                         0 1                 1
1756751 1756751 IN     school 1803870 4690   Gary Community School Corp 180387000620 4086 Frankie W McCullough Acad for Girl   Regular School No Elementary KG 05 2019   grade_5                         0.0 41.0                       41.0                         0 41                 41
1758992 1758992 IN     school 1808850 5635   Peru Community Schools 180885001477 6089 Peru Junior High School   Regular School No Middle 05 08 2019   grade_5                         0.0 2.0                       2.0                         0 2                 2
1789573 1789573 IN     school 1803930 2315   Goshen Community Schools 180393000659 1629 Goshen Middle School   Regular School No Middle 05 12 2018   grade_5                         0.0 1.0                       1.0                         0 1                 1
1792522 1792522 IN     school 1803870 4690   Gary Community School Corp 180387000620 4086 Frankie W McCullough Acad for Girl   Regular School No Elementary KG 08 2018   grade_5                         0.0 51.0                       51.0                         0 51                 51
1914261 1914261 IN     school 1809060 5485   Plymouth Community School Corp 180906001503 5933 Menominee Elementary School   Regular School No Elementary KG 05 2020   grade_5                         0.0 2.0                       2.0                         0 2                 2
1916418 1916418 IN     school 1810140 7365   Shelbyville Central Schools 181014002496 7671 Especially Kidz Health & Rehab Cnt   Regular School No Other 01 12 2020   grade_5                         0.0 2.0                       2.0                         0 2                 2
1921047 1921047 IN     school 1806600 2275   Middlebury Community Schools 180660000199 1734 Orchard View School   Regular School No Elementary KG 05 2021   grade_5                         0.0 1.0                       1.0                         0 1                 1
1163107 1163107 IN     school 1802550 3325   Danville Community School Corp 180255000306 2721 North Elementary School   Regular School No 1.0 PK 05 2015   grade_5                         1.0 0.0                       1.0                         1 0                 1
1163660 1163660 IN     school 1809420 3815   Rensselaer Central School Corp 180942001542 3213 Rensselaer Central Primary School   Regular School No 1.0 PK 05 2015   grade_5                         1.0 1.0                       2.0                         1 1                 2
1164402 1164402 IN     school 1804620 4590   River Forest Community Sch Corp 180462000778 3797 Henry S Evans Elementary Sch   Regular School No 1.0 KG 06 2015   grade_5                         1.0 0.0                       1.0                         1 0                 1
1167060 1167060 IN     school 1808850 5635   Peru Community Schools 180885001477 6089 Peru Junior High School   Regular School No 2.0 04 09 2015   grade_5                         1.0 0.0                       1.0                         1 0                 1
1168689 1168689 IN     school 1806840 7200   School City of Mishawaka 180684000531 7467 Joint Service Campus Program   Special Education School No 4.0 03 12 2015   grade_5                         1.0 0.0                       1.0                         1 0                 1
1171233 1171233 IN     school 1800121 9740   Thurgood Marshall Leadership Acad 180012102540 138 Thurgood Marshall Leadership Acad   Regular School Yes 1.0 KG 08 2015   grade_5                         1.0 4.0                       5.0                         1 4                 5
1281027 1281027 IN     school 1808250 225   Northwest Allen County Schools 180825002160 145 Allen Co Youth Services Center   Alternative Education School No 4.0 01 10 2016   grade_5                         1.0 1.0                       2.0                         1 1                 2
1285066 1285066 IN     school 1809420 3815   Rensselaer Central School Corp 180942001542 3213 Rensselaer Central Primary School   Regular School No 1.0 PK 05 2016   grade_5                         1.0 1.0                       2.0                         1 1                 2
1285718 1285718 IN     school 1813110 4525   Westview School Corporation 181311001587 3704 Meadowview Elementary School   Regular School No 1.0 KG 06 2016   grade_5                         1.0 1.0                       2.0                         1 1                 2
1292870 1292870 IN     school 1800139 9940   Tindley Collegiate Academy 180013902559 5914 Tindley Collegiate Academy   Regular School Yes 2.0 05 08 2016   grade_5                         1.0 61.0                       62.0                         1 61                 62
1293089 1293089 IN     school 1808250 225   Northwest Allen County Schools 180825002160 145 Allen Co Youth Services Center   Alternative School No Other 05 11 2017   grade_5                         1.0 0.0                       1.0                         1 0                 1
1294141 1294141 IN     school 1803940 1010   Greater Clark County Schools 180394000832 886 Old Corden Porter School   Special Education School No Other 04 12 2017   grade_5                         1.0 1.0                       2.0                         1 1                 2
1297101 1297101 IN     school 1809420 3815   Rensselaer Central School Corp 180942001542 3213 Rensselaer Central Primary School   Regular School No Elementary PK 05 2017   grade_5                         1.0 0.0                       1.0                         1 0                 1
1300338 1300338 IN     school 1809060 5485   Plymouth Community School Corp 180906001503 5933 Menominee Elementary School   Regular School No Elementary KG 05 2017   grade_5                         1.0 0.0                       1.0                         1 0                 1
1300347 1300347 IN     school 1809060 5485   Plymouth Community School Corp 180906001499 5949 Lincoln Junior High School   Regular School No Middle 05 08 2017   grade_5                         1.0 0.0                       1.0                         1 0                 1
1302106 1302106 IN     school 1806840 7200   School City of Mishawaka 180684000531 7467 Oaklawn Campus Program   Special Education School No Other 03 12 2017   grade_5                         1.0 0.0                       1.0                         1 0                 1
1302511 1302511 IN     school 1810140 7365   Shelbyville Central Schools 181014002496 7671 Especially Kidz Health & Rehab Cnt   Regular School No Other KG 12 2017   grade_5                         1.0 1.0                       2.0                         1 1                 2
1755714 1755714 IN     school 1809420 3815   Rensselaer Central School Corp 180942001542 3213 Rensselaer Central Primary School   Regular School No Elementary PK 05 2019   grade_5                         1.0 0.0                       1.0                         1 0                 1
1755805 1755805 IN     school 1806120 3995   Madison Consolidated Schools 180612001088 3333 Emery O Muncie Elementary School   Regular School No Elementary KG 05 2019   grade_5                         1.0 0.0                       1.0                         1 0                 1
1761673 1761673 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002649 8271 Harwood Career Prep High School   Regular School No Other 01 12 2019   grade_5                         1.0 0.0                       1.0                         1 0                 1
1788499 1788499 IN     school 1803940 1010   Greater Clark County Schools 180394000832 886 Old Corden Porter School   Special Education School No High 05 12 2018   grade_5                         1.0 0.0                       1.0                         1 0                 1
1789355 1789355 IN     school 1806600 2275   Middlebury Community Schools 180660001162 1657 Northridge Middle School   Regular School No Other 04 11 2018   grade_5                         1.0 0.0                       1.0                         1 0                 1
1789382 1789382 IN     school 1806600 2275   Middlebury Community Schools 180660000199 1734 Orchard View School   Regular School No Elementary KG 05 2018   grade_5                         1.0 0.0                       1.0                         1 0                 1
1791073 1791073 IN     school 1807440 3445   New Castle Community School Corp 180744001289 2853 Sunnyside Elementary School   Regular School No Elementary KG 06 2018   grade_5                         1.0 1.0                       2.0                         1 1                 2
1791840 1791840 IN     school 1807620 4255   Nineveh-Hensley-Jackson United 180762001306 3409 Indian Creek Elementary School   Regular School No Elementary PK 05 2018   grade_5                         1.0 0.0                       1.0                         1 0                 1
1792124 1792124 IN     school 1813110 4525   Westview School Corporation 181311001587 3704 Meadowview Elementary School   Regular School No Elementary PK 06 2018   grade_5                         1.0 2.0                       3.0                         1 2                 3
1794656 1794656 IN     school 1809060 5485   Plymouth Community School Corp 180906001503 5933 Menominee Elementary School   Regular School No Elementary KG 05 2018   grade_5                         1.0 0.0                       1.0                         1 0                 1
1908001 1908001 IN     school 1806030 875   Logansport Community Sch Corp 180603001052 715 Columbia 6th Grade Academy   Regular School No Other 02 09 2020   grade_5                         1.0 0.0                       1.0                         1 0                 1
1909028 1909028 IN     school 1802400 2270   Concord Community Schools 180240000272 1723 Concord Ox-Bow Elementary School   Regular School No Elementary KG 05 2020   grade_5                         1.0 0.0                       1.0                         1 0                 1
1910003 1910003 IN     school 1813080 3030   Westfield-Washington Schools 181308002074 2491 Westfield Middle School   Regular School No Middle 05 08 2020   grade_5                         1.0 0.0                       1.0                         1 0                 1
1912191 1912191 IN     school 1803870 4690   Gary Community School Corp 180387002684 4068 Gary Virtual Academy   Regular School No Other 02 09 2020   grade_5                         1.0 1.0                       2.0                         1 1                 2
1917495 1917495 IN     school 1806270 8045   Manchester Community Schools 180627001101 8633 Manchester Elementary School   Regular School No Elementary PK 06 2020   grade_5                         1.0 0.0                       1.0                         1 0                 1
1917662 1917662 IN     school 1812390 8130   Warrick County School Corp 181239001976 8793 Boonville Middle School   Regular School No Middle 05 08 2020   grade_5                         1.0 0.0                       1.0                         1 0                 1
1919968 1919968 IN     school 1806030 875   Logansport Community Sch Corp 180603001052 715 Columbia 6th Grade Academy   Regular School No Other 03 12 2021   grade_5                         1.0 0.0                       1.0                         1 0                 1
1921018 1921018 IN     school 1806600 2275   Middlebury Community Schools 180660001162 1657 Northridge Middle School   Regular School No Middle 05 09 2021   grade_5                         1.0 0.0                       1.0                         1 0                 1
1921563 1921563 IN     school 1802940 2725   East Gibson School Corporation 180294000382 2201 Francisco Elementary School   Regular School No Elementary KG 06 2021   grade_5                         1.0 9.0                       10.0                         1 9                 10
1923122 1923122 IN     school 1809420 3815   Rensselaer Central School Corp 180942001544 3221 Rensselaer Middle School   Regular School No Middle 05 08 2021   grade_5                         1.0 0.0                       1.0                         1 0                 1
1926143 1926143 IN     school 1809060 5485   Plymouth Community School Corp 180906001503 5933 Menominee Elementary School   Regular School No Elementary KG 05 2021   grade_5                         1.0 1.0                       2.0                         1 1                 2
1926632 1926632 IN     school 1806510 5925   MSD Martinsville Schools 180651002355 6344 South Elementary School of Communi   Regular School No Elementary PK 06 2021   grade_5                         1.0 2.0                       3.0                         1 2                 3
1927087 1927087 IN     school   6470   Duneland School Corporation   6811 Porter County Education Services             2021   grade_5                         1.0 0.0                       1.0                         1 0                 1
1927139 1927139 IN     school   6510   East Porter County School Corp   6811 Porter County Education Services             2021   grade_5                         1.0 0.0                       1.0                         1 0                 1
1927246 1927246 IN     school   6550   Portage Township Schools   6811 Porter County Education Services             2021   grade_5                         1.0 0.0                       1.0                         1 0                 1
1160884 1160884 IN     school 1802440 1300   Crawford Co Com School Corp 180244000283 1065 Milltown School   Regular School No 1.0 PK 06 2015   grade_5                         10.0 16.0                       26.0                         10 16                 26
1160933 1160933 IN     school 1812450 1405   Washington Com Schools 181245002005 1105 Veale Elementary School   Regular School No 1.0 KG 06 2015   grade_5                         10.0 14.0                       24.0                         10 14                 24
1162105 1162105 IN     school 1802940 2725   East Gibson School Corporation 180294000383 2189 Barton Twp Elementary   Regular School No 1.0 KG 06 2015   grade_5                         10.0 14.0                       24.0                         10 14                 24
1162931 1162931 IN     school 1810360 3190   South Harrison Com Schools 181036001696 2653 Heth-Washington Elem School   Regular School No 1.0 PK 06 2015   grade_5                         10.0 15.0                       25.0                         10 15                 25
1163549 1163549 IN     school 1810080 3675   Seymour Community Schools 181008001615 3105 Cortland Elementary School   Regular School No 1.0 KG 05 2015   grade_5                         10.0 13.0                       23.0                         10 13                 23
1163685 1163685 IN     school 1804980 3945   Jay School Corp 180498000917 3247 Redkey Elementary School   Regular School No 1.0 KG 05 2015   grade_5                         10.0 13.0                       23.0                         10 13                 23
1168605 1168605 IN     school 1808760 7175   Penn-Harris-Madison Sch Corp 180876001447 7341 Madison Elementary School   Regular School No 1.0 KG 05 2015   grade_5                         10.0 17.0                       27.0                         10 17                 27
1170203 1170203 IN     school 1806080 8115   M S D Warren County 180608001075 8729 Williamsport Elementary Sch   Regular School No 1.0 KG 06 2015   grade_5                         10.0 16.0                       26.0                         10 16                 26
1171326 1171326 IN     school 1800072 9805   Hoosier Academy - Indianapolis 180007202422 2527 Hoosier Academy - Indianapolis   Regular School Yes 4.0 KG 12 2015   grade_5                         10.0 5.0                       15.0                         10 5                 15
1281249 1281249 IN     school 1803630 235   Fort Wayne Community Schools 180363000549 213 Nebraska Elementary School   Regular School No 1.0 KG 05 2016   grade_5                         10.0 11.0                       21.0                         10 11                 21
1282047 1282047 IN     school 1803940 1010   Greater Clark County Schools 180394000668 869 Maple Elementary School   Regular School No 1.0 PK 05 2016   grade_5                         10.0 20.0                       30.0                         10 20                 30
1283526 1283526 IN     school 1802940 2725   East Gibson School Corporation 180294000382 2201 Francisco Elementary School   Regular School No 1.0 PK 06 2016   grade_5                         10.0 8.0                       18.0                         10 8                 18
1285091 1285091 IN     school 1804980 3945   Jay School Corp 180498000917 3247 Redkey Elementary School   Regular School No 1.0 KG 05 2016   grade_5                         10.0 12.0                       22.0                         10 12                 22
1286570 1286570 IN     school 1800107 4915   Tri-Township Cons School Corp 180010702520 4696 Wanatah School   Regular School No 1.0 KG 08 2016   grade_5                         10.0 18.0                       28.0                         10 18                 28
1288686 1288686 IN     school 1810450 5845   South Montgomery Com Sch Corp 181045001714 6233 Ladoga Elementary School   Regular School No 1.0 KG 06 2016   grade_5                         10.0 10.0                       20.0                         10 10                 20
1289660 1289660 IN     school 1810500 6705   South Putnam Community Schools 181050001724 7057 Fillmore Elementary School   Regular School No 1.0 KG 05 2016   grade_5                         10.0 10.0                       20.0                         10 10                 20
1294776 1294776 IN     school 1807320 1970   Muncie Community Schools 180732001239 1494 Mitchell Elementary School   Regular School No Elementary KG 05 2017   grade_5                         10.0 17.0                       27.0                         10 17                 27
1300267 1300267 IN     school 1810920 5400   School Town of Speedway 181092001781 5897 Carl G Fisher Elementary School 1   Regular School No Elementary PK 06 2017   grade_5                         10.0 6.0                       16.0                         10 6                 16
1300276 1300276 IN     school 1810920 5400   School Town of Speedway 181092001780 5901 Arthur C Newby Elementary School 2   Regular School No Elementary KG 06 2017   grade_5                         10.0 16.0                       26.0                         10 16                 26
1302017 1302017 IN     school 1808760 7175   Penn-Harris-Madison School Corp 180876001447 7341 Madison Elementary School   Regular School No Elementary KG 05 2017   grade_5                         10.0 7.0                       17.0                         10 7                 17
1304684 1304684 IN     school 1800152 9780   Indianapolis Academy of Excellence 180015202570 5761 Indianapolis Academy of Excellence   Regular School Yes Elementary KG 05 2017   grade_5                         10.0 6.0                       16.0                         10 6                 16
1304726 1304726 IN     school 1800072 9805   Hoosier Academy - Indianapolis 180007202422 2527 Hoosier Academy - Indianapolis   Regular School Yes Other KG 12 2017   grade_5                         10.0 13.0                       23.0                         10 13                 23
1304870 1304870 IN     school 1800108 9920   Damar Charter Academy 180010802503 5191 Damar Charter Academy   Regular School Yes Other KG 12 2017   grade_5                         10.0 0.0                       10.0                         10 0                 10
1304928 1304928 IN     school 1800168 9955   Mays Community Academy 180016802582 7231 Mays Community Academy   Regular School Yes Elementary KG 06 2017   grade_5                         10.0 10.0                       20.0                         10 10                 20
1304957 1304957 IN     school 1800176 9985   Seven Oaks Classical School 180017602603 1114 Seven Oaks Classical School   Regular School Yes Elementary KG 08 2017   grade_5                         10.0 8.0                       18.0                         10 8                 18
1752261 1752261 IN     school 1800480 395   Benton Community School Corp 180048000098 433 Boswell Elementary School   Regular School No Elementary PK 06 2019   grade_5                         10.0 9.0                       19.0                         10 9                 19
1753070 1753070 IN     school 1800240 1600   South Dearborn Community Sch Corp 180024000055 1169 Moores Hill Elementary School   Regular School No Elementary KG 06 2019   grade_5                         10.0 9.0                       19.0                         10 9                 19
1754122 1754122 IN     school 1803700 2475   Franklin County Community Sch Corp 180370000591 2127 Mount Carmel School   Regular School No Elementary KG 06 2019   grade_5                         10.0 20.0                       30.0                         10 20                 30
1755672 1755672 IN     school 1812060 3710   Crothersville Community Schools 181206001892 3122 Crothersville Elementary School   Regular School No Elementary PK 05 2019   grade_5                         10.0 19.0                       29.0                         10 19                 29
1757135 1757135 IN     school 1800107 4915   Tri-Township Cons School Corp 180010702520 4696 Wanatah School   Regular School No Elementary PK 08 2019   grade_5                         10.0 21.0                       31.0                         10 21                 31
1758443 1758443 IN     school 1804770 5385   Indianapolis Public Schools 180477000831 5556 Francis W Parker School 56   Regular School No Elementary PK 08 2019   grade_5                         10.0 25.0                       35.0                         10 25                 35
1760251 1760251 IN     school 1811730 6795   Union School Corporation 181173001874 7117 Union Elementary School   Regular School No Elementary KG 06 2019   grade_5                         10.0 11.0                       21.0                         10 11                 21
1761662 1761662 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002462 8270 Academy for Innovative Studies   Regular School No Other 01 12 2019   grade_5                         10.0 1.0                       11.0                         10 1                 11
1762739 1762739 IN     school 1800193 9080   Vanguard Collegiate of Indy 180019302639 1004 Vanguard Collegiate of Indy   Regular School Yes Middle 05 07 2019   grade_5                         10.0 10.0                       20.0                         10 10                 20
1762980 1762980 IN     school 1800043 9465   Rural Community Schools Inc 180004302138 7951 Rural Community Academy   Regular School Yes Elementary KG 08 2019   grade_5                         10.0 6.0                       16.0                         10 6                 16

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