enrollments

Data source: Big Local News · About: Big Local

7,359 rows where grade = "grade_1" and state = "IN" sorted by total

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_1 · 7,359 ✖
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
1162134 1162134 IN     school 1807770 2735   North Gibson School Corp 180777001324 2223 Princeton Comm Intermediate School   Regular School No 1.0 01 05 2015   grade_1                         1.0 0.0                       1.0                         1 0                 1
1169091 1169091 IN     school 1810140 7365   Shelbyville Central Schools 181014002496 7671 Especially Kidz Health & Rehab Cnt   Regular School No 4.0 PK 12 2015   grade_1                         1.0 0.0                       1.0                         1 0                 1
1281024 1281024 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_1                         0.0 1.0                       1.0                         0 1                 1
1289719 1289719 IN     school 1803990 6755   Greencastle Community Sch Corp 180399000693 7102 Tzouanakis Intermediate School   Regular School No 1.0 01 06 2016   grade_1                         1.0 0.0                       1.0                         1 0                 1
1295129 1295129 IN     school 1803270 2305   Elkhart Community Schools 180327002585 1752 Elkhart Alternative Education   Regular School No Other 01 12 2017   grade_1                         0.0 1.0                       1.0                         0 1                 1
1300473 1300473 IN     school 1808340 5625   Oak Hill United School Corp 180834001432 6081 Sweetser Elementary School   Regular School No Elementary KG 05 2017   grade_1                         0.0 1.0                       1.0                         0 1                 1
1300492 1300492 IN     school 1808850 5635   Peru Community Schools 180885001471 6093 Blair Pointe Upper Elementary   Regular School No Elementary 01 06 2017   grade_1                         0.0 1.0                       1.0                         0 1                 1
1303920 1303920 IN     school 1809510 8385   Richmond Community Schools 180951000366 9056 Community Youth Services   Special Education School No Other 01 12 2017   grade_1                         1.0 0.0                       1.0                         1 0                 1
1758980 1758980 IN     school 1808340 5625   Oak Hill United School Corp 180834001432 6081 Sweetser Elementary School   Regular School No Elementary KG 04 2019   grade_1                         0.0 1.0                       1.0                         0 1                 1
1761668 1761668 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002649 8271 Harwood Career Prep High School   Regular School No Other 01 12 2019   grade_1                         0.0 1.0                       1.0                         0 1                 1
1789474 1789474 IN     school 1803270 2305   Elkhart Community Schools 180327002585 1752 Elkhart Alternative Education   Regular School No Other 01 12 2018   grade_1                         0.0 1.0                       1.0                         0 1                 1
1794790 1794790 IN     school 1808340 5625   Oak Hill United School Corp 180834001432 6081 Sweetser Elementary School   Regular School No Elementary KG 04 2018   grade_1                         1.0 0.0                       1.0                         1 0                 1
1794808 1794808 IN     school 1808850 5635   Peru Community Schools 180885001471 6093 Blair Pointe Upper Elementary   Regular School No Elementary KG 06 2018   grade_1                         0.0 1.0                       1.0                         0 1                 1
1909167 1909167 IN     school 1803270 2305   Elkhart Community Schools 180327002585 1752 Elkhart Alternative Education   Regular School No Other KG 12 2020   grade_1                         1.0 0.0                       1.0                         1 0                 1
1911151 1911151 IN     school 1809420 3815   Rensselaer Central School Corp 180942001545 3205 Van Rensselaer Elementary School   Regular School No Elementary 01 06 2020   grade_1                         1.0 0.0                       1.0                         1 0                 1
1914414 1914414 IN     school 1808850 5635   Peru Community Schools 180885001471 6093 Blair Pointe Upper Elementary   Regular School No Elementary 01 07 2020   grade_1                         1.0 0.0                       1.0                         1 0                 1
1918836 1918836 IN     school 1800108 9920   Damar Charter Academy 180010802503 5191 Damar Charter Academy   Regular School Yes Other 01 12 2020   grade_1                         1.0 0.0                       1.0                         1 0                 1
1921135 1921135 IN     school 1803270 2305   Elkhart Community Schools 180327002585 1752 Elkhart Alternative Education   Regular School No Other 01 12 2021   grade_1                         1.0 0.0                       1.0                         1 0                 1
1927188 1927188 IN     school   6520   Porter Township School Corp   6811 Porter County Education Services             2021   grade_1                         0.0 1.0                       1.0                         0 1                 1
1927239 1927239 IN     school   6550   Portage Township Schools   6811 Porter County Education Services             2021   grade_1                         0.0 1.0                       1.0                         0 1                 1
1304943 1304943 IN     school 1800172 9970   ACE Preparatory Academy 180017202604 1111 ACE Preparatory Academy   Regular School Yes Elementary KG 01 2017   grade_1                         3.0 7.0                       10.0                         3 7                 10
1917649 1917649 IN     school 1812390 8130   Warrick County School Corp 181239001987 8785 Tennyson Elementary School   Regular School No Elementary KG 05 2020   grade_1                         7.0 3.0                       10.0                         7 3                 10
1918088 1918088 IN     school 1800207 8675   Invent Learning Hub 180020702683 9532 Invent Learning Hub   Regular School Yes Elementary KG 05 2020   grade_1                         4.0 6.0                       10.0                         4 6                 10
1921559 1921559 IN     school 1802940 2725   East Gibson School Corporation 180294000382 2201 Francisco Elementary School   Regular School No Elementary KG 06 2021   grade_1                         5.0 5.0                       10.0                         5 5                 10
1159713 1159713 IN     school 1803630 235   Fort Wayne Community Schools 180363002197 136 Fairfield Elementary School   Regular School No 1.0 PK 05 2015   grade_1                         45.0 55.0                       100.0                         45 55                 100
1164428 1164428 IN     school 1809690 4600   Merrillville Community School 180969001582 3821 Henry P Fieler Elem Sch   Regular School No 1.0 KG 04 2015   grade_1                         60.0 40.0                       100.0                         60 40                 100
1164778 1164778 IN     school 1803870 4690   Gary Community School Corp 180387002096 4121 Jacques Marquette Elem School   Regular School No 1.0 KG 06 2015   grade_1                         55.0 45.0                       100.0                         55 45                 100
1165780 1165780 IN     school 1805670 5330   M S D Lawrence Township 180567000150 5294 Forest Glen Elem Sch   Regular School No 1.0 KG 06 2015   grade_1                         44.0 56.0                       100.0                         44 56                 100
1166205 1166205 IN     school 1812810 5375   M S D Wayne Township 181281002037 5265 Robey Elementary School   Regular School No 1.0 KG 06 2015   grade_1                         54.0 46.0                       100.0                         54 46                 100
1166774 1166774 IN     school 1804770 5385   Indianapolis Public Schools 180477002393 5662 Clarence Farrington School 61   Regular School No 1.0 KG 06 2015   grade_1                         51.0 49.0                       100.0                         51 49                 100
1169484 1169484 IN     school 1811340 7865   Tippecanoe School Corp 181134001826 8007 Hershey Elementary School   Regular School No 1.0 KG 05 2015   grade_1                         46.0 54.0                       100.0                         46 54                 100
1281155 1281155 IN     school 1803630 235   Fort Wayne Community Schools 180363000522 157 Forest Park Elementary School   Regular School No 1.0 PK 05 2016   grade_1                         55.0 45.0                       100.0                         55 45                 100
1281802 1281802 IN     school 1802700 755   Delphi Community School Corp 180270000328 641 Delphi Community Elementary School   Regular School No 1.0 PK 05 2016   grade_1                         49.0 51.0                       100.0                         49 51                 100
1283424 1283424 IN     school 1810620 2455   Southeast Fountain School Corp 181062001743 2021 Southeast Fountain Elementary   Regular School No 1.0 KG 06 2016   grade_1                         48.0 52.0                       100.0                         48 52                 100
1283722 1283722 IN     school 1803090 2940   Eastern Greene Schools 180309000407 2433 Eastern Greene Elementary School   Regular School No 1.0 PK 04 2016   grade_1                         52.0 48.0                       100.0                         52 48                 100
1284061 1284061 IN     school 1801200 3060   Carmel Clay Schools 180120002101 2518 Forest Dale Elementary School   Regular School No 1.0 PK 05 2016   grade_1                         59.0 41.0                       100.0                         59 41                 100
1287108 1287108 IN     school 1803750 5310   Franklin Township Com Sch Corp 180375000596 5205 Bunker Hill Elementary School   Regular School No 1.0 KG 05 2016   grade_1                         51.0 49.0                       100.0                         51 49                 100
1287307 1287307 IN     school 1808820 5340   Perry Township Schools 180882001687 5366 Jeremiah Gray-Edison Elementary   Regular School No 1.0 PK 05 2016   grade_1                         45.0 55.0                       100.0                         45 55                 100
1291394 1291394 IN     school 1812090 8030   Vigo County School Corp 181209001903 8511 Dixie Bee Elementary School   Regular School No 1.0 KG 05 2016   grade_1                         50.0 50.0                       100.0                         50 50                 100
1293680 1293680 IN     school 1800570 515   Blackford County Schools 180057000126 501 Southside Elementary School   Regular School No Elementary KG 03 2017   grade_1                         52.0 48.0                       100.0                         52 48                 100
1294401 1294401 IN     school 1811190 1560   Sunman-Dearborn Com Sch Corp 181119001803 1189 North Dearborn Elementary School   Regular School No Elementary KG 05 2017   grade_1                         55.0 45.0                       100.0                         55 45                 100
1295764 1295764 IN     school 1803090 2940   Eastern Greene Schools 180309000407 2433 Eastern Greene Elementary School   Regular School No Elementary PK 04 2017   grade_1                         53.0 47.0                       100.0                         53 47                 100
1296341 1296341 IN     school 1800690 3180   North Harrison Com School Corp 180069000143 2633 North Harrison Elementary School   Regular School No Elementary PK 05 2017   grade_1                         48.0 52.0                       100.0                         48 52                 100
1296795 1296795 IN     school 1803150 3480   Eastern Howard School Corporation 180315000412 2909 Eastern Elementary School   Regular School No Elementary KG 05 2017   grade_1                         46.0 54.0                       100.0                         46 54                 100
1298395 1298395 IN     school 1804320 4710   School City of Hammond 180432000730 4463 Abraham Lincoln Elementary School   Regular School No Elementary PK 05 2017   grade_1                         51.0 49.0                       100.0                         51 49                 100
1299691 1299691 IN     school 1812810 5375   M S D Wayne Township 181281002031 5274 Chapelwood Elementary School   Regular School No Elementary KG 06 2017   grade_1                         55.0 45.0                       100.0                         55 45                 100
1303214 1303214 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345000483 8321 Stockwell Elementary School   Regular School No Elementary KG 05 2017   grade_1                         57.0 43.0                       100.0                         57 43                 100
1755691 1755691 IN     school 1805280 3785   Kankakee Valley School Corp 180528000935 3197 Wheatfield Elementary School   Regular School No Elementary KG 03 2019   grade_1                         54.0 46.0                       100.0                         54 46                 100
1757948 1757948 IN     school 1808910 5350   M S D Pike Township 180891001485 5359 Eastbrook Elementary School   Regular School No Elementary KG 05 2019   grade_1                         56.0 44.0                       100.0                         56 44                 100
1758087 1758087 IN     school 1812720 5370   M S D Washington Township 181272002020 5427 Nora Elementary School   Regular School No Elementary KG 05 2019   grade_1                         48.0 52.0                       100.0                         48 52                 100
1760125 1760125 IN     school 1807110 6620   Eastern Pulaski Community Sch Corp 180711001204 6994 Eastern Pulaski Elementary School   Regular School No Elementary PK 05 2019   grade_1                         48.0 52.0                       100.0                         48 52                 100
1761041 1761041 IN     school 1810140 7365   Shelbyville Central Schools 181014001633 7733 William F Loper Elementary School   Regular School No Elementary PK 05 2019   grade_1                         55.0 45.0                       100.0                         55 45                 100
1761431 1761431 IN     school 1811340 7865   Tippecanoe School Corp 181134001305 8021 Wea Ridge Elementary School   Regular School No Elementary KG 05 2019   grade_1                         57.0 43.0                       100.0                         57 43                 100
1761807 1761807 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345000487 8365 Vogel Elementary School   Regular School No Elementary KG 06 2019   grade_1                         59.0 41.0                       100.0                         59 41                 100
1762260 1762260 IN     school 1812390 8130   Warrick County School Corp 181239001979 8813 Chandler Elementary School   Regular School No Elementary KG 05 2019   grade_1                         63.0 37.0                       100.0                         63 37                 100
1788958 1788958 IN     school 1801590 1835   DeKalb Co Ctl United Sch Dist 180159000222 1351 James R Watson Elementary School   Regular School No Elementary PK 05 2018   grade_1                         50.0 50.0                       100.0                         50 50                 100
1790446 1790446 IN     school 1801200 3060   Carmel Clay Schools 180120002101 2518 Forest Dale Elementary School   Regular School No Elementary PK 05 2018   grade_1                         50.0 50.0                       100.0                         50 50                 100
1793334 1793334 IN     school 1800150 5275   Anderson Community School Corp 180015001847 5142 Anderson Elementary School   Regular School No Elementary KG 05 2018   grade_1                         51.0 49.0                       100.0                         51 49                 100
1793737 1793737 IN     school 1808910 5350   M S D Pike Township 180891001485 5359 Eastbrook Elementary School   Regular School No Elementary KG 05 2018   grade_1                         51.0 49.0                       100.0                         51 49                 100
1797344 1797344 IN     school 1811400 7945   Tipton Community School Corp 181140001844 8163 Tipton Elementary School   Regular School No Elementary PK 05 2018   grade_1                         54.0 46.0                       100.0                         54 46                 100
1798172 1798172 IN     school 1808190 8375   Northeastern Wayne Schools 180819002228 8928 Northeastern Elementary School   Regular School No Elementary PK 05 2018   grade_1                         57.0 43.0                       100.0                         57 43                 100
1907115 1907115 IN     school 1808250 225   Northwest Allen County Schools 180825001415 89 Huntertown Elementary School   Regular School No Elementary KG 05 2020   grade_1                         62.0 38.0                       100.0                         62 38                 100
1907131 1907131 IN     school 1808250 225   Northwest Allen County Schools 180825001416 92 Perry Hill Elementary School   Regular School No Elementary KG 05 2020   grade_1                         43.0 57.0                       100.0                         43 57                 100
1908291 1908291 IN     school 1802160 1160   Clinton Prairie School Corporation 180216002245 981 Clinton Prairie Elementary School   Regular School No Elementary PK 06 2020   grade_1                         52.0 48.0                       100.0                         52 48                 100
1908730 1908730 IN     school 1805880 1895   Liberty-Perry Community Sch Corp 180588001045 1381 Selma Elementary School   Regular School No Elementary KG 05 2020   grade_1                         49.0 51.0                       100.0                         49 51                 100
1909903 1909903 IN     school 1810650 3005   Hamilton Southeastern Schools 181065001750 2473 Fall Creek Elementary School   Regular School No Elementary KG 04 2020   grade_1                         46.0 54.0                       100.0                         46 54                 100
1910117 1910117 IN     school 1801200 3060   Carmel Clay Schools 180120000036 2512 Smoky Row Elementary School   Regular School No Elementary PK 05 2020   grade_1                         49.0 51.0                       100.0                         49 51                 100
1910481 1910481 IN     school 1801020 3305   Brownsburg Community School Corp 180102000994 2706 Brown Elementary School   Regular School No Elementary KG 05 2020   grade_1                         55.0 45.0                       100.0                         55 45                 100
1912873 1912873 IN     school 1810440 5255   South Madison Com Sch Corp 181044002167 4935 East Elementary School   Regular School No Elementary KG 06 2020   grade_1                         54.0 46.0                       100.0                         54 46                 100
1912999 1912999 IN     school 1802640 5300   M S D Decatur Township 180264002111 5178 Gold Academy   Regular School No Elementary 01 06 2020   grade_1                         44.0 56.0                       100.0                         44 56                 100
1913599 1913599 IN     school 1812810 5375   M S D Wayne Township 181281002036 5261 Rhoades Elementary School   Regular School No Elementary PK 06 2020   grade_1                         49.0 51.0                       100.0                         49 51                 100
1916747 1916747 IN     school 1805400 7855   Lafayette School Corporation 180540000965 8091 Glen Acres Elementary School   Regular School No Elementary KG 04 2020   grade_1                         52.0 48.0                       100.0                         52 48                 100
1917907 1917907 IN     school 1808220 8435   Northern Wells Community Schools 180822001411 9081 Ossian Elementary   Regular School No Elementary KG 05 2020   grade_1                         58.0 42.0                       100.0                         58 42                 100
1925278 1925278 IN     school 1808910 5350   MSD Pike Township 180891001485 5359 Eastbrook Elementary School   Regular School No Elementary KG 05 2021   grade_1                         53.0 47.0                       100.0                         53 47                 100
1925415 1925415 IN     school 1812720 5370   MSD Washington Township 181272002016 5418 Greenbriar Elementary School   Regular School No Elementary KG 05 2021   grade_1                         54.0 46.0                       100.0                         54 46                 100
1925438 1925438 IN     school 1812720 5370   MSD Washington Township 181272002376 5436 Fox Hill Elementary School   Regular School No Elementary KG 05 2021   grade_1                         61.0 39.0                       100.0                         61 39                 100
1927922 1927922 IN     school 1808760 7175   Penn-Harris-Madison School Corp 180876001148 7390 Northpoint Elementary School   Regular School No Elementary KG 05 2021   grade_1                         59.0 41.0                       100.0                         59 41                 100
1928383 1928383 IN     school 1810140 7365   Shelbyville Central Schools 181014001633 7733 William F Loper Elementary School   Regular School No Elementary KG 05 2021   grade_1                         54.0 46.0                       100.0                         54 46                 100
1928727 1928727 IN     school 1811340 7865   Tippecanoe School Corp 181134001829 8005 Mayflower Mill Elementary School   Regular School No Elementary KG 05 2021   grade_1                         48.0 52.0                       100.0                         48 52                 100
1928826 1928826 IN     school 1811340 7865   Tippecanoe School Corp 181134002441 8111 Woodland Elementary School   Regular School No Elementary KG 05 2021   grade_1                         49.0 51.0                       100.0                         49 51                 100
1930489 1930489 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2021   grade_1                         51.0 49.0                       100.0                         51 49                 100
1160962 1160962 IN     school 1811190 1560   Sunman-Dearborn Com Sch Corp 181119001803 1189 North Dearborn Elementary School   Regular School No 1.0 PK 04 2015   grade_1                         50.0 51.0                       101.0                         50 51                 101
1162646 1162646 IN     school 1801200 3060   Carmel Clay Schools 180120002101 2518 Forest Dale Elementary School   Regular School No 1.0 PK 05 2015   grade_1                         49.0 52.0                       101.0                         49 52                 101
1163097 1163097 IN     school 1800270 3315   Avon Community School Corp 180027001675 2740 Hickory Elementary School   Regular School No 1.0 KG 04 2015   grade_1                         64.0 37.0                       101.0                         64 37                 101
1164991 1164991 IN     school 1804320 4710   School City of Hammond 180432002106 4484 Frank O'Bannon Elementary School   Regular School No 1.0 PK 05 2015   grade_1                         45.0 56.0                       101.0                         45 56                 101
1165651 1165651 IN     school 1802640 5300   M S D Decatur Township 180264000317 5189 West Newton Elementary School   Regular School No 1.0 01 06 2015   grade_1                         49.0 52.0                       101.0                         49 52                 101
1166367 1166367 IN     school 1804770 5385   Indianapolis Public Schools 180477000896 5515 Thomas D Gregg School 15   Regular School No 1.0 PK 06 2015   grade_1                         55.0 46.0                       101.0                         55 46                 101
1166938 1166938 IN     school 1809060 5485   Plymouth Community School Corp 180906001501 5965 Washington Discovery Academy   Regular School No 1.0 KG 04 2015   grade_1                         48.0 53.0                       101.0                         48 53                 101
1168911 1168911 IN     school 1810290 7205   South Bend Community Sch Corp 181029001674 7593 Muessel Primary Center   Regular School No 1.0 KG 04 2015   grade_1                         49.0 52.0                       101.0                         49 52                 101
1283807 1283807 IN     school 1810650 3005   Hamilton Southeastern Schools 181065001751 2469 Fishers Elementary School   Regular School No 1.0 KG 04 2016   grade_1                         53.0 48.0                       101.0                         53 48                 101
1284628 1284628 IN     school 1808280 3435   Shenandoah School Corporation 180828002356 2815 Shenandoah Elementary School   Regular School No 1.0 PK 05 2016   grade_1                         52.0 49.0                       101.0                         52 49                 101
1284741 1284741 IN     school 1802040 3470   Northwestern School Corp 180204000254 2904 Northwestern Elementary Sch   Regular School No 1.0 KG 06 2016   grade_1                         54.0 47.0                       101.0                         54 47                 101
1286899 1286899 IN     school 1810440 5255   South Madison Com Sch Corp 181044001713 5061 Pendleton Elementary School   Regular School No 1.0 PK 06 2016   grade_1                         54.0 47.0                       101.0                         54 47                 101
1286972 1286972 IN     school 1800150 5275   Anderson Community School Corp 180015001847 5142 Anderson Elementary School   Regular School No 1.0 KG 05 2016   grade_1                         45.0 56.0                       101.0                         45 56                 101
1287283 1287283 IN     school 1808820 5340   Perry Township Schools 180882001460 5345 Homecroft Elementary School   Regular School No 1.0 PK 05 2016   grade_1                         50.0 51.0                       101.0                         50 51                 101
1287456 1287456 IN     school 1812360 5360   M S D Warren Township 181236001971 5389 Sunny Heights Elementary School   Regular School No 1.0 KG 04 2016   grade_1                         45.0 56.0                       101.0                         45 56                 101
1293209 1293209 IN     school 1803630 235   Fort Wayne Community Schools 180363000527 154 Fred H Croninger Elementary School   Regular School No Elementary KG 05 2017   grade_1                         56.0 45.0                       101.0                         56 45                 101
1294345 1294345 IN     school 1807710 1375   North Daviess Com Schools 180771001648 1090 North Daviess Elementary School   Regular School No Elementary KG 06 2017   grade_1                         49.0 52.0                       101.0                         49 52                 101
1296285 1296285 IN     school 1807260 3135   Mt Vernon Community School Corp 180726002192 2570 McCordsville Elementary School   Regular School No Elementary KG 05 2017   grade_1                         46.0 55.0                       101.0                         46 55                 101
1302251 1302251 IN     school 1810290 7205   South Bend Community School Corp 181029001646 7545 Harrison Primary Center   Regular School No Elementary PK 04 2017   grade_1                         56.0 45.0                       101.0                         56 45                 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]);