enrollments

Data source: Big Local News · About: Big Local

7,228 rows where grade = "kindergarten" and state = "IN" sorted by total

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • kindergarten · 7,228 ✖
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
1165054 1165054 IN     school 1804590 4730   School City of Hobart 180459000775 4317 Liberty Elementary School   Regular School No 1.0 KG 05 2015   kindergarten                         1.0 0.0                       1.0                         1 0                 1
1165068 1165068 IN     school 1804590 4730   School City of Hobart 180459000214 4327 Joan Martin Elementary School   Regular School No 1.0 KG 06 2015   kindergarten                         1.0 0.0                       1.0                         1 0                 1
1169103 1169103 IN     school 1810140 7365   Shelbyville Central Schools 181014002496 7671 Especially Kidz Health & Rehab Cnt   Regular School No 4.0 PK 12 2015   kindergarten                         0.0 1.0                       1.0                         0 1                 1
1170168 1170168 IN     school 1812180 8050   M S D Wabash County Schools 181218002178 8657 Sharp Creek Elementary School   Regular School No 1.0 KG 06 2015   kindergarten                         1.0 0.0                       1.0                         1 0                 1
1171475 1171475 IN     school 1800108 9920   Damar Charter Academy 180010802503 5191 Damar Charter Academy   Regular School Yes 4.0 KG 12 2015   kindergarten                         0.0 1.0                       1.0                         0 1                 1
1286463 1286463 IN     school 1804590 4730   School City of Hobart 180459000214 4327 Joan Martin Elementary School   Regular School No 1.0 KG 06 2016   kindergarten                         1.0 0.0                       1.0                         1 0                 1
1287204 1287204 IN     school 1805670 5330   M S D Lawrence Township 180567001034 5298 Skiles Test Elementary School   Regular School No 1.0 KG 06 2016   kindergarten                         0.0 1.0                       1.0                         0 1                 1
1291907 1291907 IN     school 1809510 8385   Richmond Community Schools 180951000366 9056 Community Youth Services   Special Education School No 4.0 KG 12 2016   kindergarten                         1.0 0.0                       1.0                         1 0                 1
1300477 1300477 IN     school 1808340 5625   Oak Hill United School Corp 180834001432 6081 Sweetser Elementary School   Regular School No Elementary KG 05 2017   kindergarten                         0.0 1.0                       1.0                         0 1                 1
1303156 1303156 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002462 8270 Academy for Innovative Studies   Regular School No Other KG 12 2017   kindergarten                         1.0 0.0                       1.0                         1 0                 1
1757030 1757030 IN     school 1804590 4730   School City of Hobart 180459000214 4327 Joan Martin Elementary School   Regular School No Elementary KG 06 2019   kindergarten                         1.0 0.0                       1.0                         1 0                 1
1758219 1758219 IN     school   5375   M S D Wayne Township   5271 Sanders School             2019   kindergarten                         1.0 0.0                       1.0                         1 0                 1
1758984 1758984 IN     school 1808340 5625   Oak Hill United School Corp 180834001432 6081 Sweetser Elementary School   Regular School No Elementary KG 04 2019   kindergarten                         1.0 0.0                       1.0                         1 0                 1
1759003 1759003 IN     school 1808850 5635   Peru Community Schools 180885001471 6093 Blair Pointe Upper Elementary   Regular School No Elementary KG 06 2019   kindergarten                         1.0 0.0                       1.0                         1 0                 1
1763429 1763429 IN     school 1800108 9920   Damar Charter Academy 180010802503 5191 Damar Charter Academy   Regular School Yes Other KG 12 2019   kindergarten                         1.0 0.0                       1.0                         1 0                 1
1794009 1794009 IN     school   5375   M S D Wayne Township   5271 Sanders School             2018   kindergarten                         1.0 0.0                       1.0                         1 0                 1
1909178 1909178 IN     school 1803270 2305   Elkhart Community Schools 180327002585 1752 Elkhart Alternative Education   Regular School No Other KG 12 2020   kindergarten                         1.0 0.0                       1.0                         1 0                 1
1909624 1909624 IN     school 1807770 2735   North Gibson School Corporation 180777001324 2223 Princeton Comm Intermediate School   Regular School No Elementary KG 05 2020   kindergarten                         0.0 1.0                       1.0                         0 1                 1
1918555 1918555 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 IN Sch for the Blind & Vis Imprd   Special Education School No Other PK 12 2020   kindergarten                         0.0 1.0                       1.0                         0 1                 1
1921586 1921586 IN     school 1807770 2735   North Gibson School Corporation 180777001324 2223 Princeton Comm Intermediate School   Regular School No Elementary KG 05 2021   kindergarten                         1.0 0.0                       1.0                         1 0                 1
1924416 1924416 IN     school 1804590 4730   School City of Hobart 180459000214 4327 Joan Martin Elementary School   Regular School No Elementary KG 06 2021   kindergarten                         1.0 0.0                       1.0                         1 0                 1
1926297 1926297 IN     school 1808850 5635   Peru Community Schools 180885001471 6093 Blair Pointe Upper Elementary   Regular School No Elementary 02 06 2021   kindergarten                         1.0 0.0                       1.0                         1 0                 1
1927090 1927090 IN     school   6470   Duneland School Corporation   6811 Porter County Education Services             2021   kindergarten                         1.0 0.0                       1.0                         1 0                 1
1927190 1927190 IN     school   6520   Porter Township School Corp   6811 Porter County Education Services             2021   kindergarten                         0.0 1.0                       1.0                         0 1                 1
1929003 1929003 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002462 8270 Academy for Innovative Studies   Regular School No Other 02 12 2021   kindergarten                         1.0 0.0                       1.0                         1 0                 1
1930836 1930836 IN     school 1800108 9920   Damar Charter Academy 180010802503 5191 Damar Charter Academy   Regular School Yes Other KG 12 2021   kindergarten                         1.0 0.0                       1.0                         1 0                 1
1162118 1162118 IN     school 1802940 2725   East Gibson School Corporation 180294000382 2201 Francisco Elementary School   Regular School No 1.0 KG 06 2015   kindergarten                         6.0 4.0                       10.0                         6 4                 10
1164746 1164746 IN     school 1803870 4690   Gary Community School Corp 180387000617 4081 Dr Bernard C Watson Acad for Boys   Regular School No 1.0 KG 06 2015   kindergarten                         10.0 0.0                       10.0                         10 0                 10
1754978 1754978 IN     school 1810360 3190   South Harrison Com Schools 181036001698 2649 New Middletown Elementary School   Regular School No Elementary KG 06 2019   kindergarten                         5.0 5.0                       10.0                         5 5                 10
1925792 1925792 IN     school 1804770 5385   Indianapolis Public Schools 180477000841 5557 George W Julian School 57   Regular School No Elementary PK 08 2021   kindergarten                         5.0 5.0                       10.0                         5 5                 10
1161033 1161033 IN     school 1800240 1600   South Dearborn Com School Corp 180024000051 1197 Aurora Elementary School   Regular School No 1.0 PK 06 2015   kindergarten                         54.0 46.0                       100.0                         54 46                 100
1163022 1163022 IN     school 1801020 3305   Brownsburg Community Sch Corp 180102001567 2718 Delaware Trail Elementary School   Regular School No 1.0 KG 05 2015   kindergarten                         50.0 50.0                       100.0                         50 50                 100
1163888 1163888 IN     school 1801440 4205   Center Grove Com Sch Corp 180144000662 3434 Sugar Grove Elementary Sch   Regular School No 1.0 KG 05 2015   kindergarten                         52.0 48.0                       100.0                         52 48                 100
1166052 1166052 IN     school 1812360 5360   M S D Warren Township 181236001969 5386 Pleasant Run Elementary Sch   Regular School No 1.0 KG 04 2015   kindergarten                         45.0 55.0                       100.0                         45 55                 100
1281183 1281183 IN     school 1803630 235   Fort Wayne Community Schools 180363000533 164 J Wilbur Haley Elementary School   Regular School No 1.0 PK 05 2016   kindergarten                         50.0 50.0                       100.0                         50 50                 100
1281196 1281196 IN     school 1803630 235   Fort Wayne Community Schools 180363000530 178 Harrison Hill Elementary School   Regular School No 1.0 PK 05 2016   kindergarten                         53.0 47.0                       100.0                         53 47                 100
1284427 1284427 IN     school 1801020 3305   Brownsburg Community Sch Corp 180102001567 2718 Delaware Trail Elementary School   Regular School No 1.0 KG 05 2016   kindergarten                         53.0 47.0                       100.0                         53 47                 100
1286101 1286101 IN     school 1802910 4680   Lake Station Community Schools 180291000381 3975 Virgil I Bailey Elementary School   Regular School No 1.0 KG 06 2016   kindergarten                         59.0 41.0                       100.0                         59 41                 100
1287424 1287424 IN     school 1812360 5360   M S D Warren Township 181236001962 5369 Eastridge Elementary School   Regular School No 1.0 KG 04 2016   kindergarten                         49.0 51.0                       100.0                         49 51                 100
1290965 1290965 IN     school 1811340 7865   Tippecanoe School Corp 181134002441 8111 Woodland Elementary School   Regular School No 1.0 KG 05 2016   kindergarten                         59.0 41.0                       100.0                         59 41                 100
1291004 1291004 IN     school 1811400 7945   Tipton Community School Corp 181140001844 8163 Tipton Elementary School   Regular School No 1.0 PK 05 2016   kindergarten                         54.0 46.0                       100.0                         54 46                 100
1293085 1293085 IN     school 1808250 225   Northwest Allen County Schools 180825002457 96 Eel River Elementary School   Regular School No Elementary KG 05 2017   kindergarten                         56.0 44.0                       100.0                         56 44                 100
1293559 1293559 IN     school 1800360 365   Bartholomew Con School Corp 180036000071 369 Lillian Schmitt Elementary School   Regular School No Elementary KG 06 2017   kindergarten                         46.0 54.0                       100.0                         46 54                 100
1294237 1294237 IN     school 1802130 1150   Clinton Central School Corporation 180213000256 961 Clinton Central Elementary School   Regular School No Elementary KG 06 2017   kindergarten                         52.0 48.0                       100.0                         52 48                 100
1294627 1294627 IN     school 1802660 1875   Delaware Community School Corp 180266000324 1365 Royerton Elementary School   Regular School No Elementary KG 05 2017   kindergarten                         64.0 36.0                       100.0                         64 36                 100
1299012 1299012 IN     school 1800150 5275   Anderson Community School Corp 180015001847 5142 Anderson Elementary School   Regular School No Elementary KG 05 2017   kindergarten                         48.0 52.0                       100.0                         48 52                 100
1300470 1300470 IN     school 1808340 5625   Oak Hill United School Corp 180834001428 6073 Converse Elementary School   Regular School No Elementary PK 02 2017   kindergarten                         51.0 49.0                       100.0                         51 49                 100
1303476 1303476 IN     school 1812090 8030   Vigo County School Corp 181209001909 8549 Lost Creek Elementary School   Regular School No Elementary KG 05 2017   kindergarten                         52.0 48.0                       100.0                         52 48                 100
1303882 1303882 IN     school 1809510 8385   Richmond Community Schools 180951001553 9013 Charles Elementary School   Regular School No Elementary PK 04 2017   kindergarten                         55.0 45.0                       100.0                         55 45                 100
1304412 1304412 IN     school 1800052 9535   Gary Lighthouse Charter School 180005202155 4130 Gary Lighthouse Charter School   Regular School Yes Other KG 12 2017   kindergarten                         60.0 40.0                       100.0                         60 40                 100
1751596 1751596 IN     school 1810260 35   South Adams Schools 181026001640 25 South Adams Elementary School   Regular School No Elementary PK 05 2019   kindergarten                         44.0 56.0                       100.0                         44 56                 100
1753501 1753501 IN     school 1803960 2120   Greater Jasper Consolidated Schs 180396000684 1569 Ireland Elementary School   Regular School No Elementary KG 05 2019   kindergarten                         49.0 51.0                       100.0                         49 51                 100
1753796 1753796 IN     school 1803270 2305   Elkhart Community Schools 180327000441 1785 Pinewood Elementary School   Regular School No Elementary KG 06 2019   kindergarten                         45.0 55.0                       100.0                         45 55                 100
1754082 1754082 IN     school 1810620 2455   Southeast Fountain School Corp 181062001743 2021 Southeast Fountain Elementary   Regular School No Elementary PK 06 2019   kindergarten                         63.0 37.0                       100.0                         63 37                 100
1754899 1754899 IN     school 1807260 3135   Mt Vernon Community School Corp 180726002192 2570 McCordsville Elementary School   Regular School No Elementary KG 05 2019   kindergarten                         45.0 55.0                       100.0                         45 55                 100
1755073 1755073 IN     school 1801020 3305   Brownsburg Community School Corp 180102001567 2718 Delaware Trail Elementary School   Regular School No Elementary KG 05 2019   kindergarten                         52.0 48.0                       100.0                         52 48                 100
1755887 1755887 IN     school 1801890 4145   Clark-Pleasant Community Sch Corp 180189000244 3401 Clark Elementary School   Regular School No Elementary KG 05 2019   kindergarten                         47.0 53.0                       100.0                         47 53                 100
1756037 1756037 IN     school 1803690 4225   Franklin Community School Corp 180369001030 3467 Creekside Elementary School   Regular School No Elementary KG 04 2019   kindergarten                         51.0 49.0                       100.0                         51 49                 100
1760797 1760797 IN     school 1810290 7205   South Bend Community School Corp 181029001673 7569 McKinley Elementary School   Regular School No Elementary KG 05 2019   kindergarten                         53.0 47.0                       100.0                         53 47                 100
1760845 1760845 IN     school 1810290 7205   South Bend Community School Corp 181029001664 7601 Nuner Fine Arts Academy   Regular School No Elementary KG 05 2019   kindergarten                         45.0 55.0                       100.0                         45 55                 100
1760891 1760891 IN     school 1809990 7230   Scott County School District 1 180999001604 7630 Austin Elementary School   Regular School No Elementary KG 05 2019   kindergarten                         46.0 54.0                       100.0                         46 54                 100
1761338 1761338 IN     school 1805400 7855   Lafayette School Corporation 180540000963 8089 Edgelea Elementary School   Regular School No Elementary KG 04 2019   kindergarten                         47.0 53.0                       100.0                         47 53                 100
1762941 1762941 IN     school 1800147 9410   KIPP Indy Unite Elementary 180014702571 5741 KIPP Indy Unite Elementary   Regular School Yes Elementary KG 04 2019   kindergarten                         54.0 46.0                       100.0                         54 46                 100
1790211 1790211 IN     school 1810650 3005   Hamilton Southeastern Schools 181065001750 2473 Fall Creek Elementary School   Regular School No Elementary KG 04 2018   kindergarten                         48.0 52.0                       100.0                         48 52                 100
1791738 1791738 IN     school 1801440 4205   Center Grove Community School Corp 180144002333 3444 Pleasant Grove Elementary School   Regular School No Elementary KG 05 2018   kindergarten                         53.0 47.0                       100.0                         53 47                 100
1792516 1792516 IN     school 1803870 4690   Gary Community School Corp 180387000615 4061 Beveridge Elementary School   Regular School No Elementary KG 06 2018   kindergarten                         62.0 38.0                       100.0                         62 38                 100
1793451 1793451 IN     school 1803750 5310   Franklin Township Com Sch Corp 180375002349 5200 Mary Adams Elementary School   Regular School No Elementary KG 05 2018   kindergarten                         54.0 46.0                       100.0                         54 46                 100
1793806 1793806 IN     school 1812360 5360   M S D Warren Township 181236001966 5375 Lakeside Elementary School   Regular School No Elementary KG 04 2018   kindergarten                         49.0 51.0                       100.0                         49 51                 100
1793860 1793860 IN     school 1812720 5370   M S D Washington Township 181272002255 5406 Crooked Creek Elementary School   Regular School No Elementary KG 05 2018   kindergarten                         51.0 49.0                       100.0                         51 49                 100
1796568 1796568 IN     school 1810290 7205   South Bend Community School Corp 181029001646 7545 Harrison Elementary School   Regular School No Elementary PK 04 2018   kindergarten                         51.0 49.0                       100.0                         51 49                 100
1907136 1907136 IN     school 1808250 225   Northwest Allen County Schools 180825001416 92 Perry Hill Elementary School   Regular School No Elementary KG 05 2020   kindergarten                         58.0 42.0                       100.0                         58 42                 100
1907619 1907619 IN     school 1800360 365   Bartholomew Con School Corp 180036000071 369 Lillian Schmitt Elementary School   Regular School No Elementary KG 06 2020   kindergarten                         54.0 46.0                       100.0                         54 46                 100
1909117 1909117 IN     school 1803270 2305   Elkhart Community Schools 180327000426 1617 Cleveland Elementary School   Regular School No Elementary KG 06 2020   kindergarten                         52.0 48.0                       100.0                         52 48                 100
1910537 1910537 IN     school 1801020 3305   Brownsburg Community School Corp 180102001570 2727 Cardinal Elementary School   Regular School No Elementary KG 05 2020   kindergarten                         47.0 53.0                       100.0                         47 53                 100
1913365 1913365 IN     school 1808910 5350   M S D Pike Township 180891002250 5358 Eagle Creek Elementary School   Regular School No Elementary KG 05 2020   kindergarten                         52.0 48.0                       100.0                         52 48                 100
1913509 1913509 IN     school 1812720 5370   M S D Washington Township 181272002016 5418 Greenbriar Elementary School   Regular School No Elementary KG 05 2020   kindergarten                         55.0 45.0                       100.0                         55 45                 100
1919252 1919252 IN     school 1803630 235   Fort Wayne Community Schools 180363000522 157 Forest Park Elementary School   Regular School No Elementary PK 05 2021   kindergarten                         47.0 53.0                       100.0                         47 53                 100
1923534 1923534 IN     school 1810410 4325   South Knox School Corp 181041001705 3489 South Knox Elementary School   Regular School No Elementary KG 06 2021   kindergarten                         53.0 47.0                       100.0                         53 47                 100
1925392 1925392 IN     school 1812720 5370   MSD Washington Township 181272002010 5403 Allisonville Elementary School   Regular School No Elementary KG 05 2021   kindergarten                         43.0 57.0                       100.0                         43 57                 100
1926366 1926366 IN     school 1800630 5740   Monroe County Community Sch Corp 180063002127 6164 Summit Elementary School   Regular School No Elementary PK 06 2021   kindergarten                         48.0 52.0                       100.0                         48 52                 100
1927647 1927647 IN     school 1807080 6820   Monroe Central School Corp 180708002226 7152 Monroe Central Elementary School   Regular School No Elementary PK 06 2021   kindergarten                         56.0 44.0                       100.0                         56 44                 100
1160550 1160550 IN     school 1801920 1000   Clarksville Com School Corp 180192000251 845 Clarksville Elementary School   Regular School No 1.0 PK 04 2015   kindergarten                         49.0 52.0                       101.0                         49 52                 101
1162523 1162523 IN     school 1813080 3030   Westfield-Washington Schools 181308000977 2494 Carey Ridge Elementary Sch   Regular School No 1.0 PK 04 2015   kindergarten                         55.0 46.0                       101.0                         55 46                 101
1162902 1162902 IN     school 1800690 3180   North Harrison Com School Corp 180069000143 2633 North Harrison Elementary Sch   Regular School No 1.0 KG 05 2015   kindergarten                         51.0 50.0                       101.0                         51 50                 101
1165582 1165582 IN     school 1800150 5275   Anderson Community School Corp 180015001847 5142 Anderson Elementary School   Regular School No 1.0 KG 05 2015   kindergarten                         46.0 55.0                       101.0                         46 55                 101
1166040 1166040 IN     school 1812360 5360   M S D Warren Township 181236001966 5375 Lakeside Elementary School   Regular School No 1.0 KG 04 2015   kindergarten                         55.0 46.0                       101.0                         55 46                 101
1171090 1171090 IN     school 1800042 9615   Andrew J Brown Academy 180004201816 5488 Andrew J Brown Academy   Regular School Yes 1.0 KG 08 2015   kindergarten                         45.0 56.0                       101.0                         45 56                 101
1281627 1281627 IN     school 1800570 515   Blackford County Schools 180057000126 501 Southside Elementary School   Regular School No 1.0 KG 03 2016   kindergarten                         55.0 46.0                       101.0                         55 46                 101
1284309 1284309 IN     school 1800690 3180   North Harrison Com School Corp 180069000143 2633 North Harrison Elementary Sch   Regular School No 1.0 KG 05 2016   kindergarten                         48.0 53.0                       101.0                         48 53                 101
1286950 1286950 IN     school 1800150 5275   Anderson Community School Corp 180015000041 4977 Tenth Street Elementary School   Regular School No 1.0 KG 05 2016   kindergarten                         59.0 42.0                       101.0                         59 42                 101
1290915 1290915 IN     school 1811340 7865   Tippecanoe School Corp 181134001821 8024 Battle Ground Elementary School   Regular School No 1.0 KG 05 2016   kindergarten                         46.0 55.0                       101.0                         46 55                 101
1291741 1291741 IN     school 1803000 8215   East Washington School Corp 180300002195 8904 East Washington Elementary School   Regular School No 1.0 KG 04 2016   kindergarten                         47.0 54.0                       101.0                         47 54                 101
1296600 1296600 IN     school 1808970 3330   Plainfield Community School Corp 180897001495 2761 Van Buren Elementary School   Regular School No Elementary KG 05 2017   kindergarten                         50.0 51.0                       101.0                         50 51                 101
1301106 1301106 IN     school 1808640 6155   Paoli Community School Corp 180864001439 6587 Throop Elementary School   Regular School No Elementary KG 06 2017   kindergarten                         53.0 48.0                       101.0                         53 48                 101
1303448 1303448 IN     school 1812090 8030   Vigo County School Corp 181209001914 8525 Rio Grande Elementary School   Regular School No Elementary KG 05 2017   kindergarten                         60.0 41.0                       101.0                         60 41                 101
1753195 1753195 IN     school 1803840 1820   Garrett-Keyser-Butler Com Sch Corp 180384000606 1329 J E Ober Elementary School   Regular School No Elementary KG 05 2019   kindergarten                         52.0 49.0                       101.0                         52 49                 101
1754704 1754704 IN     school 1801200 3060   Carmel Clay Schools 180120000198 2516 Mohawk Trails Elementary School   Regular School No Elementary KG 05 2019   kindergarten                         52.0 49.0                       101.0                         52 49                 101
1756408 1756408 IN     school 1804350 4580   Hanover Community School Corp 180435000754 3781 Jane Ball Elementary School   Regular School No Elementary PK 04 2019   kindergarten                         56.0 45.0                       101.0                         56 45                 101
1758145 1758145 IN     school 1812810 5375   M S D Wayne Township 181281002034 5223 Maplewood Elementary School   Regular School No Elementary PK 06 2019   kindergarten                         55.0 46.0                       101.0                         55 46                 101
1761038 1761038 IN     school 1810140 7365   Shelbyville Central Schools 181014001632 7729 Thomas A Hendricks Elementary Sch   Regular School No Elementary PK 05 2019   kindergarten                         58.0 43.0                       101.0                         58 43                 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]);