enrollments

Data source: Big Local News · About: Big Local

7,378 rows where grade = "grade_3" and state = "IN" sorted by total

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_3 · 7,378 ✖
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
1159976 1159976 IN     school 1802850 255   East Allen County Schools 180285000348 53 Leo Elementary School   Regular School No 1.0 03 06 2015   grade_3                         0.0 1.0                       1.0                         0 1                 1
1160260 1160260 IN     school 1802830 630   Zionsville Community Schools 180283002046 510 Zionsville West Middle School   Regular School No 1.0 03 08 2015   grade_3                         1.0 0.0                       1.0                         1 0                 1
1161371 1161371 IN     school 1807320 1970   Muncie Community Schools 180732001232 1524 Youth Opportunity Center   Alternative Education School No 4.0 03 12 2015   grade_3                         0.0 1.0                       1.0                         0 1                 1
1161539 1161539 IN     school 1802400 2270   Concord Community Schools 180240002484 1718 Concord Intermediate School   Regular School No 1.0 03 06 2015   grade_3                         0.0 1.0                       1.0                         0 1                 1
1162936 1162936 IN     school 1810360 3190   South Harrison Com Schools 181036000385 2663 Corydon Intermediate School   Regular School No 1.0 03 06 2015   grade_3                         0.0 1.0                       1.0                         0 1                 1
1163658 1163658 IN     school 1809420 3815   Rensselaer Central School Corp 180942001542 3213 Rensselaer Central Primary School   Regular School No 1.0 PK 05 2015   grade_3                         1.0 0.0                       1.0                         1 0                 1
1168687 1168687 IN     school 1806840 7200   School City of Mishawaka 180684000531 7467 Joint Service Campus Program   Special Education School No 4.0 03 12 2015   grade_3                         1.0 0.0                       1.0                         1 0                 1
1170164 1170164 IN     school 1812180 8050   M S D Wabash County Schools 181218002178 8657 Sharp Creek Elementary School   Regular School No 1.0 KG 06 2015   grade_3                         1.0 0.0                       1.0                         1 0                 1
1281026 1281026 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_3                         0.0 1.0                       1.0                         0 1                 1
1282774 1282774 IN     school 1807320 1970   Muncie Community Schools 180732001232 1524 Youth Opportunity Center   Alternative Education School No 4.0 03 12 2016   grade_3                         0.0 1.0                       1.0                         0 1                 1
1284511 1284511 IN     school 1802550 3325   Danville Community School Corp 180255000306 2721 North Elementary School   Regular School No 1.0 PK 05 2016   grade_3                         1.0 0.0                       1.0                         1 0                 1
1284523 1284523 IN     school 1802550 3325   Danville Community School Corp 180255000305 2743 Danville Middle School   Regular School No 1.0 03 08 2016   grade_3                         1.0 0.0                       1.0                         1 0                 1
1285984 1285984 IN     school 1802490 4660   Crown Point Community Sch Corp 180249000300 3854 Winfield Elementary School   Regular School No 1.0 KG 03 2016   grade_3                         0.0 1.0                       1.0                         0 1                 1
1287689 1287689 IN     school 1800450 5380   Beech Grove City Schools 180045000095 5461 South Grove Intermediate School   Regular School No 1.0 03 06 2016   grade_3                         0.0 1.0                       1.0                         0 1                 1
1290480 1290480 IN     school 1810140 7365   Shelbyville Central Schools 181014002496 7671 Especially Kidz Health & Rehab Cnt   Regular School No 4.0 02 12 2016   grade_3                         0.0 1.0                       1.0                         0 1                 1
1302104 1302104 IN     school 1806840 7200   School City of Mishawaka 180684000531 7467 Oaklawn Campus Program   Special Education School No Other 03 12 2017   grade_3                         1.0 0.0                       1.0                         1 0                 1
1755165 1755165 IN     school 1802550 3325   Danville Community School Corp 180255000306 2721 North Elementary School   Regular School No Elementary KG 03 2019   grade_3                         1.0 0.0                       1.0                         1 0                 1
1755448 1755448 IN     school 1804470 3490   Western School Corporation 180447000755 2935 Western Primary School   Regular School No Elementary KG 03 2019   grade_3                         1.0 0.0                       1.0                         1 0                 1
1761008 1761008 IN     school 1810140 7365   Shelbyville Central Schools 181014002496 7671 Especially Kidz Health & Rehab Cnt   Regular School No Other PK 12 2019   grade_3                         1.0 0.0                       1.0                         1 0                 1
1789154 1789154 IN     school 1807320 1970   Muncie Community Schools 180732001232 1524 Youth Opportunity Center   Alternative School No Other 03 12 2018   grade_3                         1.0 0.0                       1.0                         1 0                 1
1790903 1790903 IN     school 1802550 3325   Danville Community School Corp 180255000306 2721 North Elementary School   Regular School No Elementary KG 03 2018   grade_3                         1.0 0.0                       1.0                         1 0                 1
1791541 1791541 IN     school 1806120 3995   Madison Consolidated Schools 180612001091 3313 Madison Consolidated Jr High Sch   Regular School No Middle 03 08 2018   grade_3                         1.0 0.0                       1.0                         1 0                 1
1796422 1796422 IN     school 1806840 7200   School City of Mishawaka 180684000531 7467 Oaklawn Campus Program   Special Education School No Other 03 12 2018   grade_3                         1.0 0.0                       1.0                         1 0                 1
1796821 1796821 IN     school 1810140 7365   Shelbyville Central Schools 181014002496 7671 Especially Kidz Health & Rehab Cnt   Regular School No Other 02 12 2018   grade_3                         0.0 1.0                       1.0                         0 1                 1
1797893 1797893 IN     school 1812180 8050   M S D Wabash County Schools 181218002178 8657 Sharp Creek Elementary School   Regular School No Middle 03 07 2018   grade_3                         1.0 0.0                       1.0                         1 0                 1
1909058 1909058 IN     school 1806600 2275   Middlebury Community Schools 180660002427 1731 Heritage Intermediate School   Regular School No Elementary 03 05 2020   grade_3                         0.0 1.0                       1.0                         0 1                 1
1910894 1910894 IN     school 1804470 3490   Western School Corporation 180447000755 2935 Western Primary School   Regular School No Elementary KG 03 2020   grade_3                         1.0 0.0                       1.0                         1 0                 1
1912189 1912189 IN     school 1803870 4690   Gary Community School Corp 180387002684 4068 Gary Virtual Academy   Regular School No Other 02 09 2020   grade_3                         0.0 1.0                       1.0                         0 1                 1
1930040 1930040 IN     school 1800205 8690   Dynamic Minds Academy 180020502673 8692 Dynamic Minds Academy   Regular School Yes Other KG 12 2021   grade_3                         1.0 0.0                       1.0                         1 0                 1
1292841 1292841 IN     school 1800108 9920   Damar Charter Academy 180010802503 5191 Damar Charter Academy   Regular School Yes 4.0 KG 12 2016   grade_3                         10.0 0.0                       10.0                         10 0                 10
1754173 1754173 IN     school 1802940 2725   East Gibson School Corporation 180294000382 2201 Francisco Elementary School   Regular School No Elementary KG 06 2019   grade_3                         2.0 8.0                       10.0                         2 8                 10
1799040 1799040 IN     school 1800074 9795   Dr Robert H Faulkner Academy 180007402426 2411 Dr Robert H Faulkner Academy   Regular School Yes Elementary KG 06 2018   grade_3                         7.0 3.0                       10.0                         7 3                 10
1799051 1799051 IN     school 1800072 9805   Hoosier Academy - Indianapolis 180007202422 2527 Hoosier Academy - Indianapolis   Regular School Yes Other KG 12 2018   grade_3                         8.0 2.0                       10.0                         8 2                 10
1910780 1910780 IN     school 1807440 3445   New Castle Community School Corp 180744001289 2853 Sunnyside Elementary School   Regular School No Elementary KG 04 2020   grade_3                         8.0 2.0                       10.0                         8 2                 10
1930142 1930142 IN     school 1800199 9065   Allegiant Preparatory Academy 180019902648 1002 Allegiant Preparatory Academy   Regular School Yes Elementary KG 03 2021   grade_3                         6.0 4.0                       10.0                         6 4                 10
1160079 1160079 IN     school 1800360 365   Bartholomew Con School Corp 180036000077 357 Parkside Elementary School   Regular School No 1.0 PK 06 2015   grade_3                         49.0 51.0                       100.0                         49 51                 100
1160408 1160408 IN     school 1802700 755   Delphi Community School Corp 180270000328 641 Delphi Community Elementary School   Regular School No 1.0 PK 05 2015   grade_3                         50.0 50.0                       100.0                         50 50                 100
1161453 1161453 IN     school 1803960 2120   Greater Jasper Con Schs 180396000684 1569 Ireland Elementary School   Regular School No 1.0 PK 05 2015   grade_3                         43.0 57.0                       100.0                         43 57                 100
1161570 1161570 IN     school 1806600 2275   Middlebury Community Schools 180660001163 1656 Jefferson Elementary School   Regular School No 1.0 KG 03 2015   grade_3                         48.0 52.0                       100.0                         48 52                 100
1162618 1162618 IN     school 1801200 3060   Carmel Clay Schools 180120000036 2512 Smoky Row Elementary Sch   Regular School No 1.0 PK 05 2015   grade_3                         53.0 47.0                       100.0                         53 47                 100
1162648 1162648 IN     school 1801200 3060   Carmel Clay Schools 180120002101 2518 Forest Dale Elementary School   Regular School No 1.0 PK 05 2015   grade_3                         53.0 47.0                       100.0                         53 47                 100
1162698 1162698 IN     school 1807650 3070   Noblesville Schools 180765001311 2529 North Elementary School   Regular School No 1.0 KG 05 2015   grade_3                         55.0 45.0                       100.0                         55 45                 100
1162705 1162705 IN     school 1807650 3070   Noblesville Schools 180765001312 2533 Stony Creek Elementary School   Regular School No 1.0 PK 05 2015   grade_3                         57.0 43.0                       100.0                         57 43                 100
1162844 1162844 IN     school 1807260 3135   Mt Vernon Community Sch Corp 180726002192 2570 McCordsville Elementary School   Regular School No 1.0 KG 05 2015   grade_3                         53.0 47.0                       100.0                         53 47                 100
1162986 1162986 IN     school 1801020 3305   Brownsburg Community Sch Corp 180102000994 2706 Brown Elementary Sch   Regular School No 1.0 KG 05 2015   grade_3                         48.0 52.0                       100.0                         48 52                 100
1164978 1164978 IN     school 1804320 4710   School City of Hammond 180432002237 4469 Morton Elementary School   Regular School No 1.0 KG 05 2015   grade_3                         60.0 40.0                       100.0                         60 40                 100
1165668 1165668 IN     school 1803750 5310   Franklin Township Com Sch Corp 180375002409 5194 South Creek Elementary   Regular School No 1.0 KG 05 2015   grade_3                         47.0 53.0                       100.0                         47 53                 100
1168117 1168117 IN     school 1811970 6560   Valparaiso Community Schools 181197000163 6893 Flint Lake Elementary Sch   Regular School No 1.0 KG 05 2015   grade_3                         52.0 48.0                       100.0                         52 48                 100
1169435 1169435 IN     school 1805400 7855   Lafayette School Corporation 180540000971 8103 Miami Elementary School   Regular School No 1.0 KG 04 2015   grade_3                         59.0 41.0                       100.0                         59 41                 100
1169571 1169571 IN     school 1811340 7865   Tippecanoe School Corp 181134002441 8111 Woodland Elementary School   Regular School No 1.0 KG 05 2015   grade_3                         52.0 48.0                       100.0                         52 48                 100
1280981 1280981 IN     school 1808250 225   Northwest Allen County Schools 180825001415 89 Huntertown Elementary School   Regular School No 1.0 KG 05 2016   grade_3                         57.0 43.0                       100.0                         57 43                 100
1283012 1283012 IN     school 1812240 2285   Wa-Nee Community Schools 181224000028 1735 Wakarusa Elementary School   Regular School No 1.0 KG 05 2016   grade_3                         50.0 50.0                       100.0                         50 50                 100
1284964 1284964 IN     school 1810080 3675   Seymour Community Schools 181008001617 3135 Margaret R Brown Elementary School   Regular School No 1.0 KG 05 2016   grade_3                         53.0 47.0                       100.0                         53 47                 100
1285380 1285380 IN     school 1803690 4225   Franklin Community School Corp 180369000584 3461 Northwood Elementary School   Regular School No 1.0 PK 04 2016   grade_3                         52.0 48.0                       100.0                         52 48                 100
1285466 1285466 IN     school 1807830 4315   North Knox School Corp 180783001335 3545 North Knox Intermediate   Regular School No 1.0 03 06 2016   grade_3                         55.0 45.0                       100.0                         55 45                 100
1287147 1287147 IN     school 1805670 5330   M S D Lawrence Township 180567001026 5285 Crestview Elementary School   Regular School No 1.0 01 06 2016   grade_3                         62.0 38.0                       100.0                         62 38                 100
1287309 1287309 IN     school 1808820 5340   Perry Township Schools 180882001687 5366 Jeremiah Gray-Edison Elementary   Regular School No 1.0 PK 05 2016   grade_3                         57.0 43.0                       100.0                         57 43                 100
1289613 1289613 IN     school 1807110 6620   Eastern Pulaski Com Sch Corp 180711001204 6994 Eastern Pulaski Elementary School   Regular School No 1.0 PK 05 2016   grade_3                         46.0 54.0                       100.0                         46 54                 100
1290905 1290905 IN     school 1811340 7865   Tippecanoe School Corp 181134001305 8021 Wea Ridge Elementary School   Regular School No 1.0 KG 05 2016   grade_3                         49.0 51.0                       100.0                         49 51                 100
1291827 1291827 IN     school 1808190 8375   Northeastern Wayne Schools 180819002228 8928 Northeastern Elementary Sch   Regular School No 1.0 PK 05 2016   grade_3                         52.0 48.0                       100.0                         52 48                 100
1295039 1295039 IN     school 1806600 2275   Middlebury Community Schools 180660000199 1734 Orchard View School   Regular School No Elementary KG 04 2017   grade_3                         50.0 50.0                       100.0                         50 50                 100
1295404 1295404 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741001268 1957 Grant Line Elementary School   Regular School No Elementary KG 04 2017   grade_3                         52.0 48.0                       100.0                         52 48                 100
1296097 1296097 IN     school 1801200 3060   Carmel Clay Schools 180120002101 2518 Forest Dale Elementary School   Regular School No Elementary PK 05 2017   grade_3                         46.0 54.0                       100.0                         46 54                 100
1296109 1296109 IN     school 1801200 3060   Carmel Clay Schools 180120001405 2522 Towne Meadow Elementary School   Regular School No Elementary KG 05 2017   grade_3                         43.0 57.0                       100.0                         43 57                 100
1296455 1296455 IN     school 1801020 3305   Brownsburg Community School Corp 180102002430 2714 Reagan Elementary School   Regular School No Elementary KG 05 2017   grade_3                         51.0 49.0                       100.0                         51 49                 100
1296473 1296473 IN     school 1801020 3305   Brownsburg Community School Corp 180102001671 2723 White Lick Elementary School   Regular School No Elementary KG 05 2017   grade_3                         54.0 46.0                       100.0                         54 46                 100
1298921 1298921 IN     school 1810440 5255   South Madison Com Sch Corp 181044002167 4935 East Elementary School   Regular School No Elementary KG 06 2017   grade_3                         51.0 49.0                       100.0                         51 49                 100
1299340 1299340 IN     school 1808820 5340   Perry Township Schools 180882001470 5351 Winchester Village Elementary   Regular School No Elementary PK 05 2017   grade_3                         50.0 50.0                       100.0                         50 50                 100
1299459 1299459 IN     school 1812360 5360   M S D Warren Township 181236001962 5369 Eastridge Elementary School   Regular School No Elementary KG 04 2017   grade_3                         53.0 47.0                       100.0                         53 47                 100
1301636 1301636 IN     school 1807110 6620   Eastern Pulaski Community Sch Corp 180711001204 6994 Eastern Pulaski Elementary School   Regular School No Elementary PK 05 2017   grade_3                         53.0 47.0                       100.0                         53 47                 100
1301724 1301724 IN     school 1802220 6750   Cloverdale Community Schools 180222000264 7082 Cloverdale Elementary School   Regular School No Elementary PK 04 2017   grade_3                         49.0 51.0                       100.0                         49 51                 100
1302537 1302537 IN     school 1810140 7365   Shelbyville Central Schools 181014001632 7729 Thomas A Hendricks Elementary Sch   Regular School No Elementary PK 05 2017   grade_3                         44.0 56.0                       100.0                         44 56                 100
1303263 1303263 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345000473 8353 Evans School   Regular School No Elementary PK 06 2017   grade_3                         57.0 43.0                       100.0                         57 43                 100
1304405 1304405 IN     school 1800052 9535   Gary Lighthouse Charter School 180005202155 4130 Gary Lighthouse Charter School   Regular School Yes Other KG 12 2017   grade_3                         55.0 45.0                       100.0                         55 45                 100
1752864 1752864 IN     school 1802160 1160   Clinton Prairie School Corporation 180216002245 981 Clinton Prairie Elementary School   Regular School No Elementary PK 06 2019   grade_3                         46.0 54.0                       100.0                         46 54                 100
1756325 1756325 IN     school 1809300 4515   Prairie Heights Community Sch Corp 180930001524 3686 Prairie Heights Elementary School   Regular School No Elementary KG 04 2019   grade_3                         48.0 52.0                       100.0                         48 52                 100
1756517 1756517 IN     school 1805450 4615   Lake Central School Corporation 180545000980 3839 George Bibich Elementary School   Regular School No Elementary PK 04 2019   grade_3                         43.0 57.0                       100.0                         43 57                 100
1757686 1757686 IN     school 1803750 5310   Franklin Township Com Sch Corp 180375000596 5205 Bunker Hill Elementary School   Regular School No Elementary KG 05 2019   grade_3                         55.0 45.0                       100.0                         55 45                 100
1758141 1758141 IN     school 1812810 5375   M S D Wayne Township 181281002034 5223 Maplewood Elementary School   Regular School No Elementary PK 06 2019   grade_3                         44.0 56.0                       100.0                         44 56                 100
1760755 1760755 IN     school 1810290 7205   South Bend Community School Corp 181029001646 7545 Harrison Elementary School   Regular School No Elementary PK 05 2019   grade_3                         50.0 50.0                       100.0                         50 50                 100
1789703 1789703 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741001267 1929 Georgetown Elementary School   Regular School No Elementary KG 04 2018   grade_3                         51.0 49.0                       100.0                         51 49                 100
1790441 1790441 IN     school 1801200 3060   Carmel Clay Schools 180120000198 2516 Mohawk Trails Elementary School   Regular School No Elementary KG 05 2018   grade_3                         51.0 49.0                       100.0                         51 49                 100
1791116 1791116 IN     school 1811250 3460   Taylor Community School Corp 181125001812 2895 Taylor Elementary School   Regular School No Elementary PK 05 2018   grade_3                         46.0 54.0                       100.0                         46 54                 100
1794343 1794343 IN     school 1804770 5385   Indianapolis Public Schools 180477000808 5579 Carl Wilde School 79   Regular School No Elementary PK 06 2018   grade_3                         49.0 51.0                       100.0                         49 51                 100
1798746 1798746 IN     school 1800052 9535   Gary Lighthouse Charter School 180005202155 4130 Gary Lighthouse Charter School   Regular School Yes Other KG 12 2018   grade_3                         42.0 58.0                       100.0                         42 58                 100
1907034 1907034 IN     school 1810260 35   South Adams Schools 181026001640 25 South Adams Elementary School   Regular School No Elementary PK 05 2020   grade_3                         57.0 43.0                       100.0                         57 43                 100
1911327 1911327 IN     school 1801890 4145   Clark-Pleasant Community Sch Corp 180189000244 3401 Clark Elementary School   Regular School No Elementary KG 05 2020   grade_3                         56.0 44.0                       100.0                         56 44                 100
1911842 1911842 IN     school 1805520 4535   Lakeland School Corporation 180552002672 3739 Lakeland Intermediate School   Regular School No Elementary 03 06 2020   grade_3                         51.0 49.0                       100.0                         51 49                 100
1913127 1913127 IN     school 1805670 5330   M S D Lawrence Township 180567001024 5281 Brook Park Elementary School   Regular School No Elementary 01 06 2020   grade_3                         50.0 50.0                       100.0                         50 50                 100
1913340 1913340 IN     school 1808910 5350   M S D Pike Township 180891002324 5354 College Park Elementary School   Regular School No Elementary KG 05 2020   grade_3                         48.0 52.0                       100.0                         48 52                 100
1913440 1913440 IN     school 1812360 5360   M S D Warren Township 181236001966 5375 Lakeside Elementary School   Regular School No Elementary KG 04 2020   grade_3                         45.0 55.0                       100.0                         45 55                 100
1916743 1916743 IN     school 1805400 7855   Lafayette School Corporation 180540000963 8089 Edgelea Elementary School   Regular School No Elementary KG 04 2020   grade_3                         41.0 59.0                       100.0                         41 59                 100
1917459 1917459 IN     school 1812090 8030   Vigo County School Corp 181209001919 8607 Terre Town Elementary School   Regular School No Elementary PK 05 2020   grade_3                         44.0 56.0                       100.0                         44 56                 100
1918485 1918485 IN     school 1800052 9535   Gary Lighthouse Charter School 180005202155 4130 Gary Lighthouse Charter School   Regular School Yes Other KG 12 2020   grade_3                         51.0 49.0                       100.0                         51 49                 100
1919420 1919420 IN     school 1803630 235   Fort Wayne Community Schools 180363000540 270 Lincoln Elementary School   Regular School No Elementary KG 05 2021   grade_3                         47.0 53.0                       100.0                         47 53                 100
1919581 1919581 IN     school 1800360 365   Bartholomew Con School Corp 180036000071 369 Lillian Schmitt Elementary School   Regular School No Elementary PK 06 2021   grade_3                         52.0 48.0                       100.0                         52 48                 100
1921244 1921244 IN     school 1803930 2315   Goshen Community Schools 180393000656 1633 Model Elementary School   Regular School No Elementary KG 05 2021   grade_3                         56.0 44.0                       100.0                         56 44                 100
1922783 1922783 IN     school 1811250 3460   Taylor Community School Corp 181125001812 2895 Taylor Elementary School   Regular School No Elementary PK 04 2021   grade_3                         57.0 43.0                       100.0                         57 43                 100
1923293 1923293 IN     school 1801890 4145   Clark-Pleasant Community Sch Corp 180189000244 3401 Clark Elementary School   Regular School No Elementary KG 05 2021   grade_3                         51.0 49.0                       100.0                         51 49                 100
1923340 1923340 IN     school 1801440 4205   Center Grove Community School Corp 180144000662 3434 Sugar Grove Elementary School   Regular School No Elementary PK 05 2021   grade_3                         51.0 49.0                       100.0                         51 49                 100

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