enrollments

Data source: Big Local News · About: Big Local

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

✎ 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
1161551 1161551 IN     school 1802400 2270   Concord Community Schools 180240000272 1723 Concord Ox-Bow Elementary Sch   Regular School No 1.0 KG 04 2015   grade_2                         58.0 41.0                       99.0                         58 41                 99
1162276 1162276 IN     school 1806390 2865   Marion Community Schools 180639001113 2393 John W Kendall Elem School   Regular School No 1.0 KG 04 2015   grade_2                         50.0 49.0                       99.0                         50 49                 99
1163098 1163098 IN     school 1800270 3315   Avon Community School Corp 180027001675 2740 Hickory Elementary School   Regular School No 1.0 KG 04 2015   grade_2                         46.0 53.0                       99.0                         46 53                 99
1164676 1164676 IN     school 1802880 4670   School City of East Chicago 180288000368 3961 George Washington Elem School   Regular School No 1.0 PK 05 2015   grade_2                         55.0 44.0                       99.0                         55 44                 99
1165533 1165533 IN     school 1800120 5265   Alexandria Com School Corp 180012000009 5069 Alexandria-Monroe Elementary   Regular School No 1.0 PK 03 2015   grade_2                         52.0 47.0                       99.0                         52 47                 99
1166482 1166482 IN     school 1804770 5385   Indianapolis Public Schools 180477000805 5554 Brookside School 54   Regular School No 1.0 KG 06 2015   grade_2                         53.0 46.0                       99.0                         53 46                 99
1281472 1281472 IN     school 1800360 365   Bartholomew Con School Corp 180036000077 357 Parkside Elementary School   Regular School No 1.0 PK 06 2016   grade_2                         64.0 35.0                       99.0                         64 35                 99
1282848 1282848 IN     school 1810870 2110   Southwest Dubois Co Sch Corp 181087001236 1590 Huntingburg Elementary School   Regular School No 1.0 KG 05 2016   grade_2                         49.0 50.0                       99.0                         49 50                 99
1283171 1283171 IN     school 1803270 2305   Elkhart Community Schools 180327000444 1801 Roosevelt Elementary School   Regular School No 1.0 PK 06 2016   grade_2                         52.0 47.0                       99.0                         52 47                 99
1284434 1284434 IN     school 1801020 3305   Brownsburg Community Sch Corp 180102001671 2723 White Lick Elementary School   Regular School No 1.0 KG 05 2016   grade_2                         52.0 47.0                       99.0                         52 47                 99
1285063 1285063 IN     school 1809420 3815   Rensselaer Central School Corp 180942001542 3213 Rensselaer Central Primary School   Regular School No 1.0 PK 05 2016   grade_2                         58.0 41.0                       99.0                         58 41                 99
1286058 1286058 IN     school 1802880 4670   School City of East Chicago 180288000375 3953 William McKinley Elementary School   Regular School No 1.0 PK 06 2016   grade_2                         46.0 53.0                       99.0                         46 53                 99
1286980 1286980 IN     school 1800150 5275   Anderson Community School Corp 180015002110 5146 Erskine Elementary School   Regular School No 1.0 KG 05 2016   grade_2                         50.0 49.0                       99.0                         50 49                 99
1287185 1287185 IN     school 1805670 5330   M S D Lawrence Township 180567002114 5295 Winding Ridge Elementary School   Regular School No 1.0 01 06 2016   grade_2                         50.0 49.0                       99.0                         50 49                 99
1295001 1295001 IN     school 1802400 2270   Concord Community Schools 180240000274 1729 Concord West Side Elem School   Regular School No Elementary KG 04 2017   grade_2                         52.0 47.0                       99.0                         52 47                 99
1295958 1295958 IN     school 1813080 3030   Westfield-Washington Schools 181308000134 2492 Shamrock Springs Elementary School   Regular School No Elementary PK 04 2017   grade_2                         56.0 43.0                       99.0                         56 43                 99
1296542 1296542 IN     school 1800270 3315   Avon Community School Corp 180027001675 2740 Hickory Elementary School   Regular School No Elementary KG 04 2017   grade_2                         51.0 48.0                       99.0                         51 48                 99
1299133 1299133 IN     school 1803750 5310   Franklin Township Com Sch Corp 180375002222 5202 Arlington Elementary School   Regular School No Elementary KG 05 2017   grade_2                         56.0 43.0                       99.0                         56 43                 99
1751551 1751551 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2019   grade_2                         60.0 39.0                       99.0                         60 39                 99
1754751 1754751 IN     school 1807650 3070   Noblesville Schools 180765001311 2529 North Elementary School   Regular School No Elementary PK 05 2019   grade_2                         52.0 47.0                       99.0                         52 47                 99
1759953 1759953 IN     school 1809150 6550   Portage Township Schools 180915001508 6865 Central Elementary School   Regular School No Elementary KG 05 2019   grade_2                         54.0 45.0                       99.0                         54 45                 99
1761390 1761390 IN     school 1811340 7865   Tippecanoe School Corp 181134001829 8005 Mayflower Mill Elementary School   Regular School No Elementary KG 05 2019   grade_2                         49.0 50.0                       99.0                         49 50                 99
1789228 1789228 IN     school 1810870 2110   Southwest Dubois Co Sch Corp 181087001236 1590 Huntingburg Elementary School   Regular School No Elementary KG 05 2018   grade_2                         49.0 50.0                       99.0                         49 50                 99
1789235 1789235 IN     school 1803960 2120   Greater Jasper Consolidated Schs 180396000684 1569 Ireland Elementary School   Regular School No Elementary KG 05 2018   grade_2                         41.0 58.0                       99.0                         41 58                 99
1790515 1790515 IN     school 1807650 3070   Noblesville Schools 180765002340 2538 Hazel Dell Elementary School   Regular School No Elementary PK 05 2018   grade_2                         49.0 50.0                       99.0                         49 50                 99
1791151 1791151 IN     school 1803150 3480   Eastern Howard School Corporation 180315000412 2909 Eastern Elementary School   Regular School No Elementary PK 07 2018   grade_2                         49.0 50.0                       99.0                         49 50                 99
1793447 1793447 IN     school 1803750 5310   Franklin Township Com Sch Corp 180375002349 5200 Mary Adams Elementary School   Regular School No Elementary KG 05 2018   grade_2                         50.0 49.0                       99.0                         50 49                 99
1797187 1797187 IN     school 1805400 7855   Lafayette School Corporation 180540000978 8117 Vinton Elementary School   Regular School No Elementary KG 04 2018   grade_2                         53.0 46.0                       99.0                         53 46                 99
1797345 1797345 IN     school 1811400 7945   Tipton Community School Corp 181140001844 8163 Tipton Elementary School   Regular School No Elementary PK 05 2018   grade_2                         53.0 46.0                       99.0                         53 46                 99
1797924 1797924 IN     school 1812150 8060   Wabash City Schools 181215001937 8706 O J Neighbours Elementary School   Regular School No Elementary PK 04 2018   grade_2                         45.0 54.0                       99.0                         45 54                 99
1908066 1908066 IN     school 1801920 1000   Clarksville Community School Corp 180192000251 845 Clarksville Elementary School   Regular School No Elementary PK 04 2020   grade_2                         51.0 48.0                       99.0                         51 48                 99
1908659 1908659 IN     school 1801590 1835   DeKalb Co Ctl United Sch Dist 180159000225 1357 McKenney-Harrison Elementary Sch   Regular School No Elementary PK 05 2020   grade_2                         51.0 48.0                       99.0                         51 48                 99
1909038 1909038 IN     school 1802400 2270   Concord Community Schools 180240000274 1729 Concord West Side Elem School   Regular School No Elementary KG 04 2020   grade_2                         53.0 46.0                       99.0                         53 46                 99
1909278 1909278 IN     school 1803930 2315   Goshen Community Schools 180393000660 1641 Waterford Elementary School   Regular School No Elementary KG 05 2020   grade_2                         50.0 49.0                       99.0                         50 49                 99
1910397 1910397 IN     school 1800690 3180   North Harrison Com School Corp 180069000143 2633 North Harrison Elementary School   Regular School No Elementary PK 05 2020   grade_2                         42.0 57.0                       99.0                         42 57                 99
1911074 1911074 IN     school 1810080 3675   Seymour Community Schools 181008001619 3153 Seymour-Jackson Elementary School   Regular School No Elementary PK 05 2020   grade_2                         50.0 49.0                       99.0                         50 49                 99
1911522 1911522 IN     school 1804110 4245   Greenwood Community Sch Corp 180411000712 3483 Southwest Elementary School   Regular School No Elementary KG 05 2020   grade_2                         48.0 51.0                       99.0                         48 51                 99
1911937 1911937 IN     school 1809690 4600   Merrillville Community School Corp 180969001585 3829 Jonas E Salk Elementary School   Regular School No Elementary KG 04 2020   grade_2                         55.0 44.0                       99.0                         55 44                 99
1913327 1913327 IN     school 1808910 5350   M S D Pike Township 180891002374 5352 Deer Run Elementary   Regular School No Elementary KG 05 2020   grade_2                         57.0 42.0                       99.0                         57 42                 99
1915220 1915220 IN     school 1802800 6470   Duneland School Corporation 180280000335 6823 Liberty Elementary School   Regular School No Elementary KG 04 2020   grade_2                         47.0 52.0                       99.0                         47 52                 99
1916444 1916444 IN     school 1810140 7365   Shelbyville Central Schools 181014001632 7729 Thomas A Hendricks Elementary Sch   Regular School No Elementary KG 05 2020   grade_2                         54.0 45.0                       99.0                         54 45                 99
1918958 1918958 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2021   grade_2                         56.0 43.0                       99.0                         56 43                 99
1919707 1919707 IN     school 1800570 515   Blackford County Schools 180057000126 501 North Side Elementary School   Regular School No Elementary KG 02 2021   grade_2                         56.0 43.0                       99.0                         56 43                 99
1920595 1920595 IN     school 1803840 1820   Garrett-Keyser-Butler Com Sch Corp 180384000606 1329 J E Ober Elementary School   Regular School No Elementary KG 05 2021   grade_2                         53.0 46.0                       99.0                         53 46                 99
1920647 1920647 IN     school 1802660 1875   Delaware Community School Corp 180266000324 1365 Royerton Elementary School   Regular School No Elementary KG 05 2021   grade_2                         54.0 45.0                       99.0                         54 45                 99
1925066 1925066 IN     school 1805670 5330   MSD Lawrence Township 180567001027 5289 Harrison Hill Elementary School   Regular School No Elementary 01 06 2021   grade_2                         54.0 45.0                       99.0                         54 45                 99
1928144 1928144 IN     school 1810290 7205   South Bend Community School Corp 181029001658 7573 Madison S.T.E.A.M. Academy   Regular School No Elementary KG 05 2021   grade_2                         50.0 49.0                       99.0                         50 49                 99
1929647 1929647 IN     school 1803000 8215   East Washington School Corp 180300002195 8904 East Washington Elementary School   Regular School No Elementary PK 04 2021   grade_2                         43.0 56.0                       99.0                         43 56                 99
1159787 1159787 IN     school 1803630 235   Fort Wayne Community Schools 180363000533 164 J Wilbur Haley Elementary Sch   Regular School No 1.0 PK 05 2015   grade_2                         60.0 38.0                       98.0                         60 38                 98
1162311 1162311 IN     school 1803090 2940   Eastern Greene Schools 180309000407 2433 Eastern Greene Elementary School   Regular School No 1.0 PK 04 2015   grade_2                         52.0 46.0                       98.0                         52 46                 98
1162428 1162428 IN     school 1810650 3005   Hamilton Southeastern Schools 181065000373 2475 Lantern Road Elementary Sch   Regular School No 1.0 KG 04 2015   grade_2                         51.0 47.0                       98.0                         51 47                 98
1165789 1165789 IN     school 1805670 5330   M S D Lawrence Township 180567002114 5295 Winding Ridge Elementary School   Regular School No 1.0 01 06 2015   grade_2                         46.0 52.0                       98.0                         46 52                 98
1166903 1166903 IN     school 1800900 5480   Bremen Public Schools 180090000166 5943 Bremen Elem/Middle School   Regular School No 1.0 KG 08 2015   grade_2                         55.0 43.0                       98.0                         55 43                 98
1167761 1167761 IN     school 1801740 6325   Perry Central Com Schools Corp 180174000232 6705 Perry Central Elem School   Regular School No 1.0 PK 06 2015   grade_2                         60.0 38.0                       98.0                         60 38                 98
1169124 1169124 IN     school 1810140 7365   Shelbyville Central Schools 181014001632 7729 Thomas A Hendricks Elem Sch   Regular School No 1.0 PK 05 2015   grade_2                         53.0 45.0                       98.0                         53 45                 98
1169458 1169458 IN     school 1805400 7855   Lafayette School Corporation 180540000545 8119 Amelia Earhart Elem Sch   Regular School No 1.0 KG 04 2015   grade_2                         48.0 50.0                       98.0                         48 50                 98
1169650 1169650 IN     school 1803450 7995   Evansville Vanderburgh Sch Corp 180345000460 8225 Cynthia Heights Elem Sch   Regular School No 1.0 KG 05 2015   grade_2                         54.0 44.0                       98.0                         54 44                 98
1170005 1170005 IN     school 1812090 8030   Vigo County School Corp 181209001903 8511 Dixie Bee Elementary School   Regular School No 1.0 KG 05 2015   grade_2                         43.0 55.0                       98.0                         43 55                 98
1281106 1281106 IN     school 1803630 235   Fort Wayne Community Schools 180363002197 136 Fairfield Elementary School   Regular School No 1.0 PK 05 2016   grade_2                         46.0 52.0                       98.0                         46 52                 98
1281803 1281803 IN     school 1802700 755   Delphi Community School Corp 180270000328 641 Delphi Community Elementary School   Regular School No 1.0 PK 05 2016   grade_2                         48.0 50.0                       98.0                         48 50                 98
1281837 1281837 IN     school 1810680 815   Southeastern School Corp 181068002169 695 Thompson Elementary School   Regular School No 1.0 KG 03 2016   grade_2                         50.0 48.0                       98.0                         50 48                 98
1282217 1282217 IN     school 1803660 1170   Community Schools of Frankfort 180366000602 1020 Suncrest Elementary School   Regular School No 1.0 PK 05 2016   grade_2                         46.0 52.0                       98.0                         46 52                 98
1282377 1282377 IN     school 1811190 1560   Sunman-Dearborn Com Sch Corp 181119000371 1193 Bright Elementary School   Regular School No 1.0 KG 05 2016   grade_2                         49.0 49.0                       98.0                         49 49                 98
1283147 1283147 IN     school 1803270 2305   Elkhart Community Schools 180327000441 1785 Pinewood Elementary School   Regular School No 1.0 KG 06 2016   grade_2                         47.0 51.0                       98.0                         47 51                 98
1283749 1283749 IN     school 1805910 2950   Linton-Stockton School Corp 180591001048 2441 Linton-Stockton Elementary   Regular School No 1.0 KG 05 2016   grade_2                         47.0 51.0                       98.0                         47 51                 98
1284062 1284062 IN     school 1801200 3060   Carmel Clay Schools 180120002101 2518 Forest Dale Elementary School   Regular School No 1.0 PK 05 2016   grade_2                         47.0 51.0                       98.0                         47 51                 98
1286183 1286183 IN     school 1803870 4690   Gary Community School Corp 180387002102 4155 Glen Park Acad for Excel in Lrn   Regular School No 1.0 KG 06 2016   grade_2                         56.0 42.0                       98.0                         56 42                 98
1289302 1289302 IN     school 1802800 6470   Duneland School Corporation 180280000335 6823 Liberty Elementary School   Regular School No 1.0 KG 04 2016   grade_2                         53.0 45.0                       98.0                         53 45                 98
1289612 1289612 IN     school 1807110 6620   Eastern Pulaski Com Sch Corp 180711001204 6994 Eastern Pulaski Elementary School   Regular School No 1.0 PK 05 2016   grade_2                         54.0 44.0                       98.0                         54 44                 98
1289827 1289827 IN     school 1810530 6865   South Ripley Com Sch Corp 181053002380 7178 South Ripley Elementary School   Regular School No 1.0 KG 06 2016   grade_2                         52.0 46.0                       98.0                         52 46                 98
1290002 1290002 IN     school 1808760 7175   Penn-Harris-Madison Sch Corp 180876001442 7361 Elm Road Elementary School   Regular School No 1.0 PK 05 2016   grade_2                         56.0 42.0                       98.0                         56 42                 98
1290361 1290361 IN     school 1809990 7230   Scott County School District 1 180999001604 7630 Austin Elementary School   Regular School No 1.0 KG 05 2016   grade_2                         49.0 49.0                       98.0                         49 49                 98
1290813 1290813 IN     school 1805400 7855   Lafayette School Corporation 180540000965 8091 Glen Acres Elementary School   Regular School No 1.0 KG 04 2016   grade_2                         52.0 46.0                       98.0                         52 46                 98
1293860 1293860 IN     school 1802700 755   Delphi Community School Corp 180270000328 641 Delphi Community Elementary School   Regular School No Elementary PK 05 2017   grade_2                         47.0 51.0                       98.0                         47 51                 98
1293894 1293894 IN     school 1810680 815   Southeastern School Corp 181068002169 695 Thompson Elementary School   Regular School No Elementary KG 03 2017   grade_2                         54.0 44.0                       98.0                         54 44                 98
1294126 1294126 IN     school 1803940 1010   Greater Clark County Schools 180394000675 879 Parkwood Elementary School   Regular School No Elementary PK 05 2017   grade_2                         46.0 52.0                       98.0                         46 52                 98
1297502 1297502 IN     school 1807830 4315   North Knox School Corp 180783001332 3521 North Knox Primary School   Regular School No Elementary KG 02 2017   grade_2                         56.0 42.0                       98.0                         56 42                 98
1298042 1298042 IN     school 1802490 4660   Crown Point Community School Corp 180249000296 3903 Lake Street Elementary School   Regular School No Elementary KG 05 2017   grade_2                         48.0 50.0                       98.0                         48 50                 98
1299081 1299081 IN     school 1802640 5300   M S D Decatur Township 180264000317 5189 West Newton Elementary School   Regular School No Elementary 01 06 2017   grade_2                         51.0 47.0                       98.0                         51 47                 98
1299470 1299470 IN     school 1812360 5360   M S D Warren Township 181236001963 5373 Grassy Creek Elementary School   Regular School No Elementary KG 04 2017   grade_2                         62.0 36.0                       98.0                         62 36                 98
1300216 1300216 IN     school 1804770 5385   Indianapolis Public Schools 180477002393 5662 Clarence Farrington School 61   Regular School No Elementary PK 06 2017   grade_2                         49.0 49.0                       98.0                         49 49                 98
1302536 1302536 IN     school 1810140 7365   Shelbyville Central Schools 181014001632 7729 Thomas A Hendricks Elementary Sch   Regular School No Elementary PK 05 2017   grade_2                         47.0 51.0                       98.0                         47 51                 98
1303423 1303423 IN     school 1812090 8030   Vigo County School Corp 181209001903 8511 Dixie Bee Elementary School   Regular School No Elementary KG 05 2017   grade_2                         47.0 51.0                       98.0                         47 51                 98
1754588 1754588 IN     school 1813080 3030   Westfield-Washington Schools 181308002073 2495 Washington Woods Elementary School   Regular School No Elementary PK 04 2019   grade_2                         52.0 46.0                       98.0                         52 46                 98
1754700 1754700 IN     school 1801200 3060   Carmel Clay Schools 180120000198 2516 Mohawk Trails Elementary School   Regular School No Elementary KG 05 2019   grade_2                         48.0 50.0                       98.0                         48 50                 98
1755883 1755883 IN     school 1801890 4145   Clark-Pleasant Community Sch Corp 180189000244 3401 Clark Elementary School   Regular School No Elementary KG 05 2019   grade_2                         56.0 42.0                       98.0                         56 42                 98
1756886 1756886 IN     school 1804320 4710   School City of Hammond 180432000750 4453 Warren G Harding Elementary School   Regular School No Elementary PK 05 2019   grade_2                         48.0 50.0                       98.0                         48 50                 98
1757527 1757527 IN     school 1800150 5275   Anderson Community School Corp 180015000044 5033 Valley Grove Elementary School   Regular School No Elementary KG 05 2019   grade_2                         47.0 51.0                       98.0                         47 51                 98
1757949 1757949 IN     school 1808910 5350   M S D Pike Township 180891001485 5359 Eastbrook Elementary School   Regular School No Elementary KG 05 2019   grade_2                         51.0 47.0                       98.0                         51 47                 98
1758046 1758046 IN     school 1812360 5360   M S D Warren Township 181236001690 5397 Liberty Park Elementary School   Regular School No Elementary KG 04 2019   grade_2                         45.0 53.0                       98.0                         45 53                 98
1759591 1759591 IN     school 1808640 6155   Paoli Community School Corp 180864001439 6587 Throop Elementary School   Regular School No Elementary PK 06 2019   grade_2                         54.0 44.0                       98.0                         54 44                 98
1761371 1761371 IN     school 1805400 7855   Lafayette School Corporation 180540000978 8117 Vinton Elementary School   Regular School No Elementary KG 04 2019   grade_2                         53.0 45.0                       98.0                         53 45                 98
1763015 1763015 IN     school 1800052 9535   Gary Lighthouse Charter School 180005202155 4130 Gary Lighthouse Charter School   Regular School Yes Other KG 12 2019   grade_2                         51.0 47.0                       98.0                         51 47                 98
1789331 1789331 IN     school 1802400 2270   Concord Community Schools 180240000272 1723 Concord Ox-Bow Elementary School   Regular School No Elementary KG 04 2018   grade_2                         56.0 42.0                       98.0                         56 42                 98
1792227 1792227 IN     school 1809690 4600   Merrillville Community School Corp 180969001582 3821 Henry P Fieler Elementary School   Regular School No Elementary PK 04 2018   grade_2                         54.0 44.0                       98.0                         54 44                 98
1793476 1793476 IN     school 1803750 5310   Franklin Township Com Sch Corp 180375000596 5205 Bunker Hill Elementary School   Regular School No Elementary KG 05 2018   grade_2                         50.0 48.0                       98.0                         50 48                 98
1794462 1794462 IN     school 1804770 5385   Indianapolis Public Schools 180477000864 5607 Lew Wallace School 107   Regular School No Elementary PK 06 2018   grade_2                         47.0 51.0                       98.0                         47 51                 98
1794533 1794533 IN     school 1804770 5385   Indianapolis Public Schools 180477002393 5662 Clarence Farrington School 61   Regular School No Elementary PK 06 2018   grade_2                         51.0 47.0                       98.0                         51 47                 98
1795727 1795727 IN     school 1809180 6520   Porter Township School Corp 180918001522 6840 Porter Lakes Elementary School   Regular School No Elementary KG 03 2018   grade_2                         49.0 49.0                       98.0                         49 49                 98
1797220 1797220 IN     school 1811340 7865   Tippecanoe School Corp 181134001826 8007 Hershey Elementary School   Regular School No Elementary KG 05 2018   grade_2                         51.0 47.0                       98.0                         51 47                 98

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