enrollments

Data source: Big Local News · About: Big Local

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

✎ 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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
1166237 1166237 IN     school   5375   M S D Wayne Township   5271 Sanders School             2015   grade_5                         9.0 1.0                       10.0                         9 1                 10
1171211 1171211 IN     school 1800129 9725   Canaan Community Academy 180012902534 3312 Canaan Community Academy   Regular School Yes 1.0 KG 06 2015   grade_5                         4.0 6.0                       10.0                         4 6                 10
1283515 1283515 IN     school 1802940 2725   East Gibson School Corporation 180294000383 2189 Barton Twp Elementary   Regular School No 1.0 KG 06 2016   grade_5                         4.0 6.0                       10.0                         4 6                 10
1292899 1292899 IN     school 1800168 9955   Mays Community Academy 180016802582 7231 Mays Community Academy   Regular School Yes 1.0 KG 06 2016   grade_5                         7.0 3.0                       10.0                         7 3                 10
1304288 1304288 IN     school 1800143 9375   IN Math & Science Academy - South 180014302561 5671 IN Math & Science Academy - South   Regular School Yes Elementary KG 08 2017   grade_5                         3.0 7.0                       10.0                         3 7                 10
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
1754175 1754175 IN     school 1802940 2725   East Gibson School Corporation 180294000382 2201 Francisco Elementary School   Regular School No Elementary KG 06 2019   grade_5                         5.0 5.0                       10.0                         5 5                 10
1755592 1755592 IN     school 1801230 3640   Medora Community School Corp 180123002268 3095 Medora Elementary School   Regular School No Elementary PK 06 2019   grade_5                         4.0 6.0                       10.0                         4 6                 10
1917653 1917653 IN     school 1812390 8130   Warrick County School Corp 181239001987 8785 Tennyson Elementary School   Regular School No Elementary KG 05 2020   grade_5                         7.0 3.0                       10.0                         7 3                 10
1918156 1918156 IN     school 1800189 9030   Otwell Miller Academy 180018902616 2019 Otwell Miller Academy   Regular School Yes Elementary KG 05 2020   grade_5                         5.0 5.0                       10.0                         5 5                 10
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
1928998 1928998 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002462 8270 Academy for Innovative Studies   Regular School No Other 02 12 2021   grade_5                         10.0 0.0                       10.0                         10 0                 10
1930905 1930905 IN     school 1800172 9970   ACE Preparatory Academy 180017202604 1111 ACE Preparatory Academy   Regular School Yes Elementary KG 05 2021   grade_5                         6.0 4.0                       10.0                         6 4                 10
1159543 1159543 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002044 64 Lafayette Meadow School   Regular School No 1.0 KG 05 2015   grade_5                         58.0 42.0                       100.0                         58 42                 100
1161164 1161164 IN     school 1801590 1835   DeKalb Co Ctl United Sch Dist 180159000222 1351 James R Watson Elem School   Regular School No 1.0 PK 05 2015   grade_5                         56.0 44.0                       100.0                         56 44                 100
1162723 1162723 IN     school 1807650 3070   Noblesville Schools 180765002340 2538 Hazel Dell Elementary School   Regular School No 1.0 PK 05 2015   grade_5                         51.0 49.0                       100.0                         51 49                 100
1162988 1162988 IN     school 1801020 3305   Brownsburg Community Sch Corp 180102000994 2706 Brown Elementary Sch   Regular School No 1.0 KG 05 2015   grade_5                         57.0 43.0                       100.0                         57 43                 100
1164591 1164591 IN     school 1802490 4660   Crown Point Community Sch Corp 180249000295 3773 Dwight D Eisenhower Elem Sch   Regular School No 1.0 PK 05 2015   grade_5                         46.0 54.0                       100.0                         46 54                 100
1166200 1166200 IN     school 1812810 5375   M S D Wayne Township 181281002036 5261 Rhoades Elementary School   Regular School No 1.0 PK 06 2015   grade_5                         54.0 46.0                       100.0                         54 46                 100
1166225 1166225 IN     school 1812810 5375   M S D Wayne Township 181281002040 5270 Stout Field Elementary School   Regular School No 1.0 PK 06 2015   grade_5                         50.0 50.0                       100.0                         50 50                 100
1170187 1170187 IN     school 1812150 8060   Wabash City Schools 181215002301 8694 Wabash Middle School   Regular School No 2.0 05 08 2015   grade_5                         58.0 42.0                       100.0                         58 42                 100
1283198 1283198 IN     school 1803930 2315   Goshen Community Schools 180393000656 1633 Model Elementary School   Regular School No 1.0 KG 05 2016   grade_5                         52.0 48.0                       100.0                         52 48                 100
1284381 1284381 IN     school 1808100 3295   North West Hendricks Schools 180810001386 2725 Pittsboro Elementary   Regular School No 1.0 03 05 2016   grade_5                         48.0 52.0                       100.0                         48 52                 100
1287090 1287090 IN     school 1803750 5310   Franklin Township Com Sch Corp 180375002349 5200 Mary Adams Elementary School   Regular School No 1.0 KG 05 2016   grade_5                         53.0 47.0                       100.0                         53 47                 100
1287303 1287303 IN     school 1808820 5340   Perry Township Schools 180882001470 5351 Winchester Village Elementary   Regular School No 1.0 PK 05 2016   grade_5                         61.0 39.0                       100.0                         61 39                 100
1292909 1292909 IN     school 1800164 9965   Career Academy Middle School 180016402593 7563 Career Academy Middle School   Regular School Yes 2.0 05 08 2016   grade_5                         47.0 53.0                       100.0                         47 53                 100
1296780 1296780 IN     school 1802040 3470   Northwestern School Corp 180204000254 2904 Northwestern Elementary School   Regular School No Elementary KG 06 2017   grade_5                         63.0 37.0                       100.0                         63 37                 100
1299920 1299920 IN     school 1804770 5385   Indianapolis Public Schools 180477000805 5554 Brookside School 54   Regular School No Elementary KG 06 2017   grade_5                         52.0 48.0                       100.0                         52 48                 100
1302186 1302186 IN     school 1810290 7205   South Bend Community School Corp 181029001650 7425 Clay Intermediate Center   Regular School No Middle 05 08 2017   grade_5                         53.0 47.0                       100.0                         53 47                 100
1302539 1302539 IN     school 1810140 7365   Shelbyville Central Schools 181014001632 7729 Thomas A Hendricks Elementary Sch   Regular School No Elementary PK 05 2017   grade_5                         52.0 48.0                       100.0                         52 48                 100
1302788 1302788 IN     school 1810860 7715   Southwest School Corporation 181086001771 7965 Sullivan Elementary School   Regular School No Elementary PK 05 2017   grade_5                         52.0 48.0                       100.0                         52 48                 100
1304079 1304079 IN     school 1810230 8625   Smith-Green Community Schools 181023001637 9197 Churubusco Elementary School   Regular School No Elementary KG 05 2017   grade_5                         51.0 49.0                       100.0                         51 49                 100
1753034 1753034 IN     school 1811190 1560   Sunman-Dearborn Com Sch Corp 181119000371 1193 Bright Elementary School   Regular School No Elementary KG 05 2019   grade_5                         54.0 46.0                       100.0                         54 46                 100
1753845 1753845 IN     school 1803930 2315   Goshen Community Schools 180393000656 1633 Model Elementary School   Regular School No Elementary KG 05 2019   grade_5                         55.0 45.0                       100.0                         55 45                 100
1756874 1756874 IN     school 1804320 4710   School City of Hammond 180432002236 4449 Thomas A Edison Elementary School   Regular School No Elementary PK 05 2019   grade_5                         45.0 55.0                       100.0                         45 55                 100
1756889 1756889 IN     school 1804320 4710   School City of Hammond 180432000750 4453 Warren G Harding Elementary School   Regular School No Elementary PK 05 2019   grade_5                         56.0 44.0                       100.0                         56 44                 100
1757688 1757688 IN     school 1803750 5310   Franklin Township Com Sch Corp 180375000596 5205 Bunker Hill Elementary School   Regular School No Elementary KG 05 2019   grade_5                         50.0 50.0                       100.0                         50 50                 100
1793282 1793282 IN     school 1800120 5265   Alexandria Community School Corp 180012000010 5065 Alexandria-Monroe Intermediate   Regular School No Elementary 03 06 2018   grade_5                         49.0 51.0                       100.0                         49 51                 100
1793563 1793563 IN     school 1805670 5330   M S D Lawrence Township 180567001033 5296 Oaklandon Elementary School   Regular School No Elementary 01 06 2018   grade_5                         47.0 53.0                       100.0                         47 53                 100
1794993 1794993 IN     school 1800630 5740   Monroe County Community Sch Corp 180063000138 6226 University Elementary School   Regular School No Elementary PK 06 2018   grade_5                         52.0 48.0                       100.0                         52 48                 100
1796348 1796348 IN     school 1808760 7175   Penn-Harris-Madison School Corp 180876001442 7361 Elm Road Elementary School   Regular School No Elementary PK 05 2018   grade_5                         57.0 43.0                       100.0                         57 43                 100
1797388 1797388 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345000460 8225 Cynthia Heights Elementary School   Regular School No Elementary KG 05 2018   grade_5                         55.0 45.0                       100.0                         55 45                 100
1797829 1797829 IN     school 1812090 8030   Vigo County School Corp 181209001919 8607 Terre Town Elementary School   Regular School No Elementary KG 05 2018   grade_5                         52.0 48.0                       100.0                         52 48                 100
1907617 1907617 IN     school 1800360 365   Bartholomew Con School Corp 180036000071 369 Lillian Schmitt Elementary School   Regular School No Elementary KG 06 2020   grade_5                         57.0 43.0                       100.0                         57 43                 100
1910536 1910536 IN     school 1801020 3305   Brownsburg Community School Corp 180102001570 2727 Cardinal Elementary School   Regular School No Elementary KG 05 2020   grade_5                         47.0 53.0                       100.0                         47 53                 100
1912089 1912089 IN     school 1802490 4660   Crown Point Community School Corp 180249000298 3905 Solon Robinson Elementary School   Regular School No Elementary KG 05 2020   grade_5                         61.0 39.0                       100.0                         61 39                 100
1914251 1914251 IN     school 1800900 5480   Bremen Public Schools 180090000166 5943 Bremen Elementary/Middle School   Regular School No Elementary KG 08 2020   grade_5                         55.0 45.0                       100.0                         55 45                 100
1915004 1915004 IN     school 1808640 6155   Paoli Community School Corp 180864001439 6587 Throop Elementary School   Regular School No Elementary KG 06 2020   grade_5                         56.0 44.0                       100.0                         56 44                 100
1916285 1916285 IN     school 1811910 7215   Union-North United School Corp 181191002242 7400 LaVille Elementary School   Regular School No Elementary KG 06 2020   grade_5                         58.0 42.0                       100.0                         58 42                 100
1916814 1916814 IN     school 1811340 7865   Tippecanoe School Corp 181134001826 8007 Hershey Elementary School   Regular School No Elementary KG 05 2020   grade_5                         49.0 51.0                       100.0                         49 51                 100
1919010 1919010 IN     school 1800030 125   MSD Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2021   grade_5                         57.0 43.0                       100.0                         57 43                 100
1919085 1919085 IN     school 1808250 225   Northwest Allen County Schools 180825001415 89 Huntertown Elementary School   Regular School No Elementary KG 05 2021   grade_5                         51.0 49.0                       100.0                         51 49                 100
1924319 1924319 IN     school 1804320 4710   School City of Hammond 180432000744 4465 Maywood Elementary School   Regular School No Elementary PK 05 2021   grade_5                         47.0 53.0                       100.0                         47 53                 100
1925102 1925102 IN     school 1805670 5330   MSD Lawrence Township 180567001033 5296 Oaklandon Elementary School   Regular School No Elementary 01 06 2021   grade_5                         49.0 51.0                       100.0                         49 51                 100
1928870 1928870 IN     school 1811400 7945   Tipton Community School Corp 181140001844 8163 Tipton Elementary School   Regular School No Elementary PK 05 2021   grade_5                         50.0 50.0                       100.0                         50 50                 100
1162643 1162643 IN     school 1801200 3060   Carmel Clay Schools 180120000198 2516 Mohawk Trails Elementary Sch   Regular School No 1.0 KG 05 2015   grade_5                         51.0 50.0                       101.0                         51 50                 101
1163654 1163654 IN     school 1809420 3815   Rensselaer Central School Corp 180942001545 3205 Van Rensselaer Elementary School   Regular School No 1.0 03 05 2015   grade_5                         52.0 49.0                       101.0                         52 49                 101
1165655 1165655 IN     school 1802640 5300   M S D Decatur Township 180264000317 5189 West Newton Elementary School   Regular School No 1.0 01 06 2015   grade_5                         50.0 51.0                       101.0                         50 51                 101
1165967 1165967 IN     school 1808910 5350   M S D Pike Township 180891002250 5358 Eagle Creek Elementary School   Regular School No 1.0 KG 05 2015   grade_5                         49.0 52.0                       101.0                         49 52                 101
1167723 1167723 IN     school 1810950 6195   Spencer-Owen Community Schools 181095001794 6617 Spencer Elementary School   Regular School No 1.0 PK 06 2015   grade_5                         56.0 45.0                       101.0                         56 45                 101
1171119 1171119 IN     school 1800057 9645   Challenge Foundation Academy 180005702314 5716 Avondale Meadows Academy   Regular School Yes 1.0 KG 05 2015   grade_5                         55.0 46.0                       101.0                         55 46                 101

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