enrollments

Data source: Big Local News · About: Big Local

7,371 rows where grade = "grade_2" and state = "IN" sorted by male

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_2 · 7,371 ✖
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
1164749 1164749 IN     school 1803870 4690   Gary Community School Corp 180387000620 4086 Frankie W McCullough Acad for Girl   Regular School No 1.0 KG 07 2015   grade_2                         0.0 69.0                       69.0                         0 69                 69
1169095 1169095 IN     school 1810140 7365   Shelbyville Central Schools 181014002496 7671 Especially Kidz Health & Rehab Cnt   Regular School No 4.0 PK 12 2015   grade_2                         0.0 1.0                       1.0                         0 1                 1
1286141 1286141 IN     school 1803870 4690   Gary Community School Corp 180387000620 4086 Frankie W McCullough Acad for Girl   Regular School No 1.0 KG 08 2016   grade_2                         0.0 59.0                       59.0                         0 59                 59
1298184 1298184 IN     school 1803870 4690   Gary Community School Corp 180387000620 4086 Frankie W McCullough Acad for Girl   Regular School No Elementary KG 08 2017   grade_2                         0.0 66.0                       66.0                         0 66                 66
1756748 1756748 IN     school 1803870 4690   Gary Community School Corp 180387000620 4086 Frankie W McCullough Acad for Girl   Regular School No Elementary KG 05 2019   grade_2                         0.0 39.0                       39.0                         0 39                 39
1758998 1758998 IN     school 1808850 5635   Peru Community Schools 180885001471 6093 Blair Pointe Upper Elementary   Regular School No Elementary KG 06 2019   grade_2                         0.0 1.0                       1.0                         0 1                 1
1792519 1792519 IN     school 1803870 4690   Gary Community School Corp 180387000620 4086 Frankie W McCullough Acad for Girl   Regular School No Elementary KG 08 2018   grade_2                         0.0 47.0                       47.0                         0 47                 47
1794791 1794791 IN     school 1808340 5625   Oak Hill United School Corp 180834001432 6081 Sweetser Elementary School   Regular School No Elementary KG 04 2018   grade_2                         0.0 1.0                       1.0                         0 1                 1
1794809 1794809 IN     school 1808850 5635   Peru Community Schools 180885001471 6093 Blair Pointe Upper Elementary   Regular School No Elementary KG 06 2018   grade_2                         0.0 1.0                       1.0                         0 1                 1
1796062 1796062 IN     school 1803990 6755   Greencastle Community School Corp 180399000693 7102 Tzouanakis Intermediate School   Regular School No Elementary 02 05 2018   grade_2                         0.0 1.0                       1.0                         0 1                 1
1914399 1914399 IN     school 1808340 5625   Oak Hill United School Corp 180834001432 6081 Sweetser Elementary School   Regular School No Elementary KG 04 2020   grade_2                         0.0 1.0                       1.0                         0 1                 1
1914415 1914415 IN     school 1808850 5635   Peru Community Schools 180885001471 6093 Blair Pointe Upper Elementary   Regular School No Elementary 01 07 2020   grade_2                         0.0 3.0                       3.0                         0 3                 3
1917077 1917077 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002649 8271 Harwood Career Prep High School   Regular School No Other 02 12 2020   grade_2                         0.0 2.0                       2.0                         0 2                 2
1927137 1927137 IN     school   6510   East Porter County School Corp   6811 Porter County Education Services             2021   grade_2                         0.0 1.0                       1.0                         0 1                 1
1927211 1927211 IN     school   6530   Union Township School Corp   6811 Porter County Education Services             2021   grade_2                         0.0 1.0                       1.0                         0 1                 1
1169729 1169729 IN     school 1803450 7995   Evansville Vanderburgh Sch Corp 180345002462 8270 Academy for Innovative Studies   Regular School No 4.0 KG 12 2015   grade_2                         1.0 2.0                       3.0                         1 2                 3
1284787 1284787 IN     school 1804470 3490   Western School Corp 180447002224 2923 Western Intermediate School   Regular School No 1.0 02 08 2016   grade_2                         1.0 2.0                       3.0                         1 2                 3
1288464 1288464 IN     school 1808850 5635   Peru Community Schools 180885001471 6093 Blair Pointe Upper Elementary   Regular School No 1.0 KG 06 2016   grade_2                         1.0 2.0                       3.0                         1 2                 3
1290479 1290479 IN     school 1810140 7365   Shelbyville Central Schools 181014002496 7671 Especially Kidz Health & Rehab Cnt   Regular School No 4.0 02 12 2016   grade_2                         1.0 1.0                       2.0                         1 1                 2
1294810 1294810 IN     school 1807320 1970   Muncie Community Schools 180732001232 1524 Youth Opportunity Center   Alternative School No Other 02 12 2017   grade_2                         1.0 0.0                       1.0                         1 0                 1
1300493 1300493 IN     school 1808850 5635   Peru Community Schools 180885001471 6093 Blair Pointe Upper Elementary   Regular School No Elementary 01 06 2017   grade_2                         1.0 0.0                       1.0                         1 0                 1
1301743 1301743 IN     school 1803990 6755   Greencastle Community School Corp 180399000693 7102 Tzouanakis Intermediate School   Regular School No Elementary 02 06 2017   grade_2                         1.0 0.0                       1.0                         1 0                 1
1304267 1304267 IN     school 1800015 9360   Veritas Academy 180001501786 1540 Veritas Academy   Regular School Yes Elementary KG 08 2017   grade_2                         1.0 1.0                       2.0                         1 1                 2
1753738 1753738 IN     school 1803270 2305   Elkhart Community Schools 180327002585 1752 Elkhart Alternative Education   Regular School No Other 02 12 2019   grade_2                         1.0 2.0                       3.0                         1 2                 3
1754194 1754194 IN     school 1807770 2735   North Gibson School Corporation 180777001324 2223 Princeton Comm Intermediate School   Regular School No Elementary KG 05 2019   grade_2                         1.0 0.0                       1.0                         1 0                 1
1758981 1758981 IN     school 1808340 5625   Oak Hill United School Corp 180834001432 6081 Sweetser Elementary School   Regular School No Elementary KG 04 2019   grade_2                         1.0 0.0                       1.0                         1 0                 1
1789478 1789478 IN     school 1803270 2305   Elkhart Community Schools 180327002585 1752 Elkhart Alternative Education   Regular School No Other 01 12 2018   grade_2                         1.0 2.0                       3.0                         1 2                 3
1791456 1791456 IN     school 1809420 3815   Rensselaer Central School Corp 180942001545 3205 Van Rensselaer Elementary School   Regular School No Elementary 02 05 2018   grade_2                         1.0 0.0                       1.0                         1 0                 1
1796820 1796820 IN     school 1810140 7365   Shelbyville Central Schools 181014002496 7671 Especially Kidz Health & Rehab Cnt   Regular School No Other 02 12 2018   grade_2                         1.0 0.0                       1.0                         1 0                 1
1907998 1907998 IN     school 1806030 875   Logansport Community Sch Corp 180603001052 715 Columbia 6th Grade Academy   Regular School No Other 02 09 2020   grade_2                         1.0 0.0                       1.0                         1 0                 1
1916416 1916416 IN     school 1810140 7365   Shelbyville Central Schools 181014002496 7671 Especially Kidz Health & Rehab Cnt   Regular School No Other 01 12 2020   grade_2                         1.0 1.0                       2.0                         1 1                 2
1918107 1918107 IN     school 1800205 8690   Dynamic Minds Academy 180020502673 8692 Dynamic Minds Academy   Regular School Yes Other KG 12 2020   grade_2                         1.0 0.0                       1.0                         1 0                 1
1921582 1921582 IN     school 1807770 2735   North Gibson School Corporation 180777001324 2223 Princeton Comm Intermediate School   Regular School No Elementary KG 05 2021   grade_2                         1.0 2.0                       3.0                         1 2                 3
1926292 1926292 IN     school 1808850 5635   Peru Community Schools 180885001471 6093 Blair Pointe Upper Elementary   Regular School No Elementary 02 06 2021   grade_2                         1.0 0.0                       1.0                         1 0                 1
1928348 1928348 IN     school 1810140 7365   Shelbyville Central Schools 181014002496 7671 Especially Kidz Health & Rehab Cnt   Regular School No Other 02 12 2021   grade_2                         1.0 1.0                       2.0                         1 1                 2
1162368 1162368 IN     school 1800008 2980   White River Valley Sch Dist 180000802304 2457 Lyons Elementary School   Regular School No 1.0 KG 06 2015   grade_2                         10.0 17.0                       27.0                         10 17                 27
1167284 1167284 IN     school 1810450 5845   South Montgomery Com Sch Corp 181045001714 6233 Ladoga Elementary School   Regular School No 1.0 KG 06 2015   grade_2                         10.0 19.0                       29.0                         10 19                 29
1167707 1167707 IN     school 1810950 6195   Spencer-Owen Community Schools 181095001787 6605 Gosport Elementary School   Regular School No 1.0 KG 06 2015   grade_2                         10.0 13.0                       23.0                         10 13                 23
1170915 1170915 IN     school 1800149 9395   Christel House Academy West 180014902568 5871 Christel House Academy West   Regular School Yes 1.0 KG 02 2015   grade_2                         10.0 19.0                       29.0                         10 19                 29
1171071 1171071 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Alternative Education School No 4.0 PK 12 2015   grade_2                         10.0 11.0                       21.0                         10 11                 21
1281319 1281319 IN     school 1803630 235   Fort Wayne Community Schools 180363000567 265 Washington Elementary School   Regular School No 1.0 PK 05 2016   grade_2                         10.0 9.0                       19.0                         10 9                 19
1282414 1282414 IN     school 1800240 1600   South Dearborn Com School Corp 180024000055 1169 Moores Hill Elementary School   Regular School No 1.0 KG 06 2016   grade_2                         10.0 9.0                       19.0                         10 9                 19
1283512 1283512 IN     school 1802940 2725   East Gibson School Corporation 180294000383 2189 Barton Twp Elementary   Regular School No 1.0 KG 06 2016   grade_2                         10.0 9.0                       19.0                         10 9                 19
1283778 1283778 IN     school 1800008 2980   White River Valley Sch Dist 180000802304 2457 Lyons Elementary School   Regular School No 1.0 KG 06 2016   grade_2                         10.0 13.0                       23.0                         10 13                 23
1285138 1285138 IN     school 1806120 3995   Madison Consolidated Schools 180612001085 3301 Deputy Elementary School   Regular School No 1.0 PK 05 2016   grade_2                         10.0 14.0                       24.0                         10 14                 24
1286567 1286567 IN     school 1800107 4915   Tri-Township Cons School Corp 180010702520 4696 Wanatah School   Regular School No 1.0 KG 08 2016   grade_2                         10.0 16.0                       26.0                         10 16                 26
1288240 1288240 IN     school 1810920 5400   School Town of Speedway 181092001781 5897 Carl G Fisher Elem School 1   Regular School No 1.0 PK 06 2016   grade_2                         10.0 7.0                       17.0                         10 7                 17
1289892 1289892 IN     school 1809750 6995   Rush County Schools 180975001594 7233 Milroy Elementary School   Regular School No 1.0 KG 06 2016   grade_2                         10.0 14.0                       24.0                         10 14                 24
1290524 1290524 IN     school 1808010 7385   North Spencer County Sch Corp 180801001373 7751 Chrisney Elementary School   Regular School No 1.0 PK 06 2016   grade_2                         10.0 16.0                       26.0                         10 16                 26
1291596 1291596 IN     school 1806080 8115   M S D Warren County 180608001072 8733 Pine Village Elementary Sch   Regular School No 1.0 KG 06 2016   grade_2                         10.0 9.0                       19.0                         10 9                 19
1292598 1292598 IN     school 1800121 9740   Thurgood Marshall Leadership Acad 180012102540 138 Thurgood Marshall Leadership Acad   Regular School Yes 1.0 KG 08 2016   grade_2                         10.0 12.0                       22.0                         10 12                 22
1296373 1296373 IN     school 1810360 3190   South Harrison Com Schools 181036001696 2653 Heth-Washington Elementary School   Regular School No Elementary PK 06 2017   grade_2                         10.0 4.0                       14.0                         10 4                 14
1296715 1296715 IN     school 1807440 3445   New Castle Community School Corp 180744001289 2853 Sunnyside Elementary School   Regular School No Elementary KG 07 2017   grade_2                         10.0 6.0                       16.0                         10 6                 16
1299925 1299925 IN     school 1804770 5385   Indianapolis Public Schools 180477000822 5555 Eliza A Blaker School 55   Regular School No Elementary PK 06 2017   grade_2                         10.0 14.0                       24.0                         10 14                 24
1299945 1299945 IN     school 1804770 5385   Indianapolis Public Schools 180477000841 5557 George W Julian School 57   Regular School No Elementary KG 06 2017   grade_2                         10.0 10.0                       20.0                         10 10                 20
1301135 1301135 IN     school 1810950 6195   Spencer-Owen Community Schools 181095001787 6605 Gosport Elementary School   Regular School No Elementary PK 06 2017   grade_2                         10.0 13.0                       23.0                         10 13                 23
1301208 1301208 IN     school 1801170 6340   Cannelton City Schools 180117000191 6733 Cannelton Elementary & High School   Regular School No Other PK 12 2017   grade_2                         10.0 10.0                       20.0                         10 10                 20
1302014 1302014 IN     school 1808760 7175   Penn-Harris-Madison School Corp 180876001447 7341 Madison Elementary School   Regular School No Elementary KG 05 2017   grade_2                         10.0 7.0                       17.0                         10 7                 17
1304363 1304363 IN     school 1800043 9465   Rural Community Schools Inc 180004302138 7951 Rural Community Academy   Regular School Yes Elementary KG 08 2017   grade_2                         10.0 11.0                       21.0                         10 11                 21
1304590 1304590 IN     school 1800065 9690   Renaissance Academy Charter School 180006502415 4711 Renaissance Academy Charter School   Regular School Yes Elementary KG 08 2017   grade_2                         10.0 16.0                       26.0                         10 16                 26
1304723 1304723 IN     school 1800072 9805   Hoosier Academy - Indianapolis 180007202422 2527 Hoosier Academy - Indianapolis   Regular School Yes Other KG 12 2017   grade_2                         10.0 5.0                       15.0                         10 5                 15
1752986 1752986 IN     school 1812450 1405   Washington Community Schools 181245002005 1105 Veale Elementary School   Regular School No Elementary KG 06 2019   grade_2                         10.0 14.0                       24.0                         10 14                 24
1754981 1754981 IN     school 1810360 3190   South Harrison Com Schools 181036001696 2653 Heth-Washington Elementary School   Regular School No Elementary PK 06 2019   grade_2                         10.0 7.0                       17.0                         10 7                 17
1758767 1758767 IN     school 1810920 5400   School Town of Speedway 181092001781 5897 Carl G Fisher Elementary School 1   Regular School No Elementary PK 06 2019   grade_2                         10.0 8.0                       18.0                         10 8                 18
1759227 1759227 IN     school 1810450 5845   South Montgomery Com Sch Corp 181045001717 6258 Walnut Elementary School   Regular School No Elementary PK 05 2019   grade_2                         10.0 11.0                       21.0                         10 11                 21
1759701 1759701 IN     school 1801170 6340   Cannelton City Schools 180117000191 6733 Cannelton Elementary & High School   Regular School No Other PK 12 2019   grade_2                         10.0 10.0                       20.0                         10 10                 20
1761232 1761232 IN     school 1811100 7615   M S D Steuben County 181110001801 7905 Pleasant Lake Elementary School   Regular School No Elementary KG 05 2019   grade_2                         10.0 12.0                       22.0                         10 12                 22
1790717 1790717 IN     school 1810360 3190   South Harrison Com Schools 181036001698 2649 New Middletown Elementary School   Regular School No Elementary PK 06 2018   grade_2                         10.0 10.0                       20.0                         10 10                 20
1799075 1799075 IN     school 1800087 9845   Xavier School of Excellence 180008702445 7571 Xavier School of Excellence   Regular School Yes Elementary KG 08 2018   grade_2                         10.0 7.0                       17.0                         10 7                 17
1799284 1799284 IN     school 1800176 9985   Seven Oaks Classical School 180017602603 1114 Seven Oaks Classical School   Regular School Yes Other KG 09 2018   grade_2                         10.0 8.0                       18.0                         10 8                 18
1908498 1908498 IN     school 1800240 1600   South Dearborn Community Sch Corp 180024000055 1169 Moores Hill Elementary School   Regular School No Elementary KG 06 2020   grade_2                         10.0 5.0                       15.0                         10 5                 15
1909598 1909598 IN     school 1802940 2725   East Gibson School Corporation 180294000382 2201 Francisco Elementary School   Regular School No Elementary KG 06 2020   grade_2                         10.0 3.0                       13.0                         10 3                 13
1910427 1910427 IN     school 1810360 3190   South Harrison Com Schools 181036001696 2653 Heth-Washington Elementary School   Regular School No Elementary PK 06 2020   grade_2                         10.0 10.0                       20.0                         10 10                 20
1914744 1914744 IN     school 1806510 5925   M S D Martinsville Schools 180651001129 6341 Centerton Elementary School   Regular School No Elementary KG 04 2020   grade_2                         10.0 14.0                       24.0                         10 14                 24
1916031 1916031 IN     school 1806840 7200   School City of Mishawaka 180684001174 7469 Battell Elementary School   Regular School No Elementary KG 06 2020   grade_2                         10.0 24.0                       34.0                         10 24                 34
1918181 1918181 IN     school 1800196 9060   Paramount Community Heights 180019602643 139 Paramount Community Heights   Regular School Yes Elementary KG 05 2020   grade_2                         10.0 14.0                       24.0                         10 14                 24
1926708 1926708 IN     school 1807920 5945   North Newton School Corp 180792001361 6397 Morocco Elementary School   Regular School No Elementary KG 06 2021   grade_2                         10.0 9.0                       19.0                         10 9                 19
1926959 1926959 IN     school 1810900 6260   Southwest Parke Com Sch Corp 181090002288 6629 Montezuma Elementary School   Regular School No Elementary PK 06 2021   grade_2                         10.0 18.0                       28.0                         10 18                 28
1927507 1927507 IN     school 1810500 6705   South Putnam Community Schools 181050001724 7057 Fillmore Elementary School   Regular School No Elementary PK 05 2021   grade_2                         10.0 4.0                       14.0                         10 4                 14
1929493 1929493 IN     school 1806080 8115   MSD Warren County 180608001075 8729 Williamsport Elementary School   Regular School No Elementary KG 06 2021   grade_2                         10.0 12.0                       22.0                         10 12                 22
1167012 1167012 IN     school 1806090 5615   Maconaquah School Corp 180609001077 6035 Maconaquah Elementary School   Regular School No 1.0 02 05 2015   grade_2                         100.0 88.0                       188.0                         100 88                 188
1167099 1167099 IN     school 1809480 5705   Richland-Bean Blossom C S C 180948001707 6151 Edgewood Primary School   Regular School No 1.0 KG 02 2015   grade_2                         100.0 87.0                       187.0                         100 87                 187
1754505 1754505 IN     school 1810650 3005   Hamilton Southeastern Schools 181065002429 2483 Thorpe Creek Elementary   Regular School No Elementary KG 04 2019   grade_2                         100.0 80.0                       180.0                         100 80                 180
1759262 1759262 IN     school 1802460 5855   Crawfordsville Community Schools 180246000291 6301 Meredith Nicholson Elementary Sch   Regular School No Elementary 02 03 2019   grade_2                         100.0 117.0                       217.0                         100 117                 217
1787826 1787826 IN     school 1802850 255   East Allen County Schools 180285000954 291 Cedarville Elementary School   Regular School No Elementary KG 03 2018   grade_2                         100.0 107.0                       207.0                         100 107                 207
1797324 1797324 IN     school 1812870 7875   West Lafayette Com School Corp 181287002043 8138 Cumberland Elementary School   Regular School No Elementary KG 03 2018   grade_2                         100.0 87.0                       187.0                         100 87                 187
1162253 1162253 IN     school 1806870 2855   Mississinewa Community School Corp 180687001191 2346 Northview Elementary School   Regular School No 1.0 02 05 2015   grade_2                         101.0 95.0                       196.0                         101 95                 196
1759023 1759023 IN     school 1809480 5705   Richland-Bean Blossom C S C 180948001707 6151 Edgewood Primary School   Regular School No Elementary KG 02 2019   grade_2                         101.0 92.0                       193.0                         101 92                 193
1919487 1919487 IN     school 1802850 255   East Allen County Schools 180285000954 291 Cedarville Elementary School   Regular School No Elementary KG 03 2021   grade_2                         101.0 102.0                       203.0                         101 102                 203
1927716 1927716 IN     school 1800390 6895   Batesville Community School Corp 180039002381 7218 Batesville Primary School   Regular School No Elementary PK 02 2021   grade_2                         101.0 67.0                       168.0                         101 67                 168
1299140 1299140 IN     school 1803750 5310   Franklin Township Com Sch Corp 180375002499 5203 Lillie Idella Kitley Elementary   Regular School No Elementary PK 05 2017   grade_2                         102.0 89.0                       191.0                         102 89                 191
1160514 1160514 IN     school 1809370 940   West Clark Community Schools 180937001538 789 Silver Creek Elementary School   Regular School No 1.0 02 05 2015   grade_2                         103.0 100.0                       203.0                         103 100                 203
1163391 1163391 IN     school 1804470 3490   Western School Corp 180447000755 2935 Western Primary School   Regular School No 1.0 KG 02 2015   grade_2                         103.0 91.0                       194.0                         103 91                 194
1171373 1171373 IN     school 1800081 9865   Hoosier Acad Virtual Charter 180008102458 5290 Hoosier Acad Virtual Charter Sch   Regular School Yes 4.0 KG 12 2015   grade_2                         103.0 96.0                       199.0                         103 96                 199
1913095 1913095 IN     school 1803750 5310   Franklin Township Com Sch Corp 180375002499 5203 Lillie Idella Kitley Elementary   Regular School No Elementary KG 05 2020   grade_2                         103.0 91.0                       194.0                         103 91                 194
1914679 1914679 IN     school 1802460 5855   Crawfordsville Community Schools 180246000291 6301 Meredith Nicholson Elementary Sch   Regular School No Elementary 02 03 2020   grade_2                         103.0 97.0                       200.0                         103 97                 200
1788334 1788334 IN     school 1809370 940   West Clark Community Schools 180937001538 789 Silver Creek Elementary School   Regular School No Elementary 02 05 2018   grade_2                         104.0 107.0                       211.0                         104 107                 211
1919508 1919508 IN     school 1802850 255   East Allen County Schools 180285000356 310 Southwick Elementary School   Regular School No Elementary PK 02 2021   grade_2                         104.0 81.0                       185.0                         104 81                 185
1167629 1167629 IN     school 1812900 6065   West Noble School Corporation 181290002231 6510 West Noble Elementary School   Regular School No 1.0 02 04 2015   grade_2                         105.0 93.0                       198.0                         105 93                 198
1920016 1920016 IN     school 1800213 945   Silver Creek School Corporation 180021301538 789 Silver Creek Elementary School   Regular School No Elementary 02 05 2021   grade_2                         105.0 93.0                       198.0                         105 93                 198

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