enrollments

Data source: Big Local News · About: Big Local

1,048 rows where grade = "grade_1", state = "IN" and year = 2018 sorted by total

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2018 · 1,048 ✖

grade ✖

  • grade_1 · 1,048 ✖
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
1789474 1789474 IN     school 1803270 2305   Elkhart Community Schools 180327002585 1752 Elkhart Alternative Education   Regular School No Other 01 12 2018   grade_1                         0.0 1.0                       1.0                         0 1                 1
1794790 1794790 IN     school 1808340 5625   Oak Hill United School Corp 180834001432 6081 Sweetser Elementary School   Regular School No Elementary KG 04 2018   grade_1                         1.0 0.0                       1.0                         1 0                 1
1794808 1794808 IN     school 1808850 5635   Peru Community Schools 180885001471 6093 Blair Pointe Upper Elementary   Regular School No Elementary KG 06 2018   grade_1                         0.0 1.0                       1.0                         0 1                 1
1788958 1788958 IN     school 1801590 1835   DeKalb Co Ctl United Sch Dist 180159000222 1351 James R Watson Elementary School   Regular School No Elementary PK 05 2018   grade_1                         50.0 50.0                       100.0                         50 50                 100
1790446 1790446 IN     school 1801200 3060   Carmel Clay Schools 180120002101 2518 Forest Dale Elementary School   Regular School No Elementary PK 05 2018   grade_1                         50.0 50.0                       100.0                         50 50                 100
1793334 1793334 IN     school 1800150 5275   Anderson Community School Corp 180015001847 5142 Anderson Elementary School   Regular School No Elementary KG 05 2018   grade_1                         51.0 49.0                       100.0                         51 49                 100
1793737 1793737 IN     school 1808910 5350   M S D Pike Township 180891001485 5359 Eastbrook Elementary School   Regular School No Elementary KG 05 2018   grade_1                         51.0 49.0                       100.0                         51 49                 100
1797344 1797344 IN     school 1811400 7945   Tipton Community School Corp 181140001844 8163 Tipton Elementary School   Regular School No Elementary PK 05 2018   grade_1                         54.0 46.0                       100.0                         54 46                 100
1798172 1798172 IN     school 1808190 8375   Northeastern Wayne Schools 180819002228 8928 Northeastern Elementary School   Regular School No Elementary PK 05 2018   grade_1                         57.0 43.0                       100.0                         57 43                 100
1787291 1787291 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2018   grade_1                         59.0 42.0                       101.0                         59 42                 101
1787332 1787332 IN     school 1810260 35   South Adams Schools 181026001640 25 South Adams Elementary School   Regular School No Elementary PK 05 2018   grade_1                         60.0 41.0                       101.0                         60 41                 101
1791131 1791131 IN     school 1802040 3470   Northwestern School Corp 180204000254 2904 Northwestern Elementary School   Regular School No Elementary KG 06 2018   grade_1                         48.0 53.0                       101.0                         48 53                 101
1791793 1791793 IN     school 1803690 4225   Franklin Community School Corp 180369001030 3467 Creekside Elementary School   Regular School No Elementary KG 04 2018   grade_1                         51.0 50.0                       101.0                         51 50                 101
1792804 1792804 IN     school 1804590 4730   School City of Hobart 180459000775 4317 Liberty Elementary School   Regular School No Elementary 01 05 2018   grade_1                         45.0 56.0                       101.0                         45 56                 101
1793446 1793446 IN     school 1803750 5310   Franklin Township Com Sch Corp 180375002349 5200 Mary Adams Elementary School   Regular School No Elementary KG 05 2018   grade_1                         56.0 45.0                       101.0                         56 45                 101
1798660 1798660 IN     school 1800147 9410   KIPP Indy Unite Elementary 180014702571 5741 KIPP Indy Unite Elementary   Regular School Yes Elementary KG 03 2018   grade_1                         57.0 44.0                       101.0                         57 44                 101
1798903 1798903 IN     school 1800086 9680   Paramount Brookside 180008602478 5508 Paramount Brookside   Regular School Yes Elementary KG 08 2018   grade_1                         51.0 50.0                       101.0                         51 50                 101
1787621 1787621 IN     school 1803630 235   Fort Wayne Community Schools 180363000530 178 Harrison Hill Elementary School   Regular School No Elementary PK 05 2018   grade_1                         59.0 43.0                       102.0                         59 43                 102
1788982 1788982 IN     school 1802660 1875   Delaware Community School Corp 180266000324 1365 Royerton Elementary School   Regular School No Elementary KG 05 2018   grade_1                         63.0 39.0                       102.0                         63 39                 102
1789348 1789348 IN     school 1806600 2275   Middlebury Community Schools 180660001163 1656 Jefferson Elementary School   Regular School No Elementary KG 03 2018   grade_1                         59.0 43.0                       102.0                         59 43                 102
1791857 1791857 IN     school 1807830 4315   North Knox School Corp 180783001332 3521 North Knox Primary School   Regular School No Elementary KG 02 2018   grade_1                         54.0 48.0                       102.0                         54 48                 102
1793808 1793808 IN     school 1812360 5360   M S D Warren Township 181236001967 5377 Lowell Elementary School   Regular School No Elementary KG 04 2018   grade_1                         47.0 55.0                       102.0                         47 55                 102
1787453 1787453 IN     school 1808250 225   Northwest Allen County Schools 180825002457 96 Eel River Elementary School   Regular School No Elementary KG 05 2018   grade_1                         57.0 46.0                       103.0                         57 46                 103
1790458 1790458 IN     school 1801200 3060   Carmel Clay Schools 180120001405 2522 Towne Meadow Elementary School   Regular School No Elementary KG 05 2018   grade_1                         50.0 53.0                       103.0                         50 53                 103
1791873 1791873 IN     school 1810410 4325   South Knox School Corp 181041001705 3489 South Knox Elementary School   Regular School No Elementary KG 06 2018   grade_1                         59.0 44.0                       103.0                         59 44                 103
1793526 1793526 IN     school 1805670 5330   M S D Lawrence Township 180567001027 5289 Harrison Hill Elementary School   Regular School No Elementary 01 06 2018   grade_1                         50.0 53.0                       103.0                         50 53                 103
1793696 1793696 IN     school 1808910 5350   M S D Pike Township 180891002374 5352 Deer Run Elementary   Regular School No Elementary KG 05 2018   grade_1                         54.0 49.0                       103.0                         54 49                 103
1794019 1794019 IN     school 1812810 5375   M S D Wayne Township 181281002031 5274 Chapelwood Elementary School   Regular School No Elementary KG 06 2018   grade_1                         46.0 57.0                       103.0                         46 57                 103
1796855 1796855 IN     school 1810140 7365   Shelbyville Central Schools 181014001633 7733 William F Loper Elementary School   Regular School No Elementary PK 05 2018   grade_1                         61.0 42.0                       103.0                         61 42                 103
1798082 1798082 IN     school 1803000 8215   East Washington School Corp 180300002195 8904 East Washington Elementary School   Regular School No Elementary KG 04 2018   grade_1                         50.0 53.0                       103.0                         50 53                 103
1798741 1798741 IN     school 1800052 9535   Gary Lighthouse Charter School 180005202155 4130 Gary Lighthouse Charter School   Regular School Yes Other KG 12 2018   grade_1                         56.0 47.0                       103.0                         56 47                 103
1793256 1793256 IN     school 1810440 5255   South Madison Com Sch Corp 181044001713 5061 Pendleton Elementary School   Regular School No Elementary PK 06 2018   grade_1                         64.0 40.0                       104.0                         64 40                 104
1793988 1793988 IN     school 1812810 5375   M S D Wayne Township 181281002040 5270 Stout Field Elementary School   Regular School No Elementary PK 06 2018   grade_1                         54.0 50.0                       104.0                         54 50                 104
1798200 1798200 IN     school 1809510 8385   Richmond Community Schools 180951001553 9013 Charles Elementary School   Regular School No Elementary PK 04 2018   grade_1                         52.0 52.0                       104.0                         52 52                 104
1787608 1787608 IN     school 1803630 235   Fort Wayne Community Schools 180363000533 164 J Wilbur Haley Elementary School   Regular School No Elementary PK 05 2018   grade_1                         51.0 54.0                       105.0                         51 54                 105
1790327 1790327 IN     school 1813080 3030   Westfield-Washington Schools 181308002073 2495 Washington Woods Elementary School   Regular School No Elementary PK 04 2018   grade_1                         58.0 47.0                       105.0                         58 47                 105
1791114 1791114 IN     school 1811250 3460   Taylor Community School Corp 181125001812 2895 Taylor Elementary School   Regular School No Elementary PK 05 2018   grade_1                         53.0 52.0                       105.0                         53 52                 105
1791372 1791372 IN     school 1810080 3675   Seymour Community Schools 181008001619 3153 Seymour-Jackson Elementary School   Regular School No Elementary PK 05 2018   grade_1                         51.0 54.0                       105.0                         51 54                 105
1791380 1791380 IN     school 1810080 3675   Seymour Community Schools 181008001620 3157 Seymour-Redding Elementary School   Regular School No Elementary KG 05 2018   grade_1                         51.0 54.0                       105.0                         51 54                 105
1793408 1793408 IN     school 1802640 5300   M S D Decatur Township 180264000317 5189 West Newton Elementary School   Regular School No Elementary 01 06 2018   grade_1                         49.0 56.0                       105.0                         49 56                 105
1794785 1794785 IN     school 1808340 5625   Oak Hill United School Corp 180834001428 6073 Converse Elementary School   Regular School No Elementary PK 02 2018   grade_1                         54.0 51.0                       105.0                         54 51                 105
1795415 1795415 IN     school 1808640 6155   Paoli Community School Corp 180864001439 6587 Throop Elementary School   Regular School No Elementary KG 06 2018   grade_1                         56.0 49.0                       105.0                         56 49                 105
1790506 1790506 IN     school 1807650 3070   Noblesville Schools 180765002414 2537 Noble Crossing Elementary School   Regular School No Elementary PK 05 2018   grade_1                         56.0 50.0                       106.0                         56 50                 106
1790824 1790824 IN     school 1801020 3305   Brownsburg Community School Corp 180102001671 2723 White Lick Elementary School   Regular School No Elementary KG 05 2018   grade_1                         57.0 49.0                       106.0                         57 49                 106
1791150 1791150 IN     school 1803150 3480   Eastern Howard School Corporation 180315000412 2909 Eastern Elementary School   Regular School No Elementary PK 07 2018   grade_1                         50.0 56.0                       106.0                         50 56                 106
1793475 1793475 IN     school 1803750 5310   Franklin Township Com Sch Corp 180375000596 5205 Bunker Hill Elementary School   Regular School No Elementary KG 05 2018   grade_1                         53.0 53.0                       106.0                         53 53                 106
1797150 1797150 IN     school 1805400 7855   Lafayette School Corporation 180540000963 8089 Edgelea Elementary School   Regular School No Elementary KG 04 2018   grade_1                         49.0 57.0                       106.0                         49 57                 106
1787319 1787319 IN     school 1807680 25   North Adams Community Schools 180768001317 41 Southeast Elementary School   Regular School No Elementary PK 01 2018   grade_1                         51.0 56.0                       107.0                         51 56                 107
1789578 1789578 IN     school 1803930 2315   Goshen Community Schools 180393000656 1633 Model Elementary School   Regular School No Elementary KG 05 2018   grade_1                         53.0 54.0                       107.0                         53 54                 107
1790498 1790498 IN     school 1807650 3070   Noblesville Schools 180765001312 2533 Stony Creek Elementary School   Regular School No Elementary PK 05 2018   grade_1                         59.0 48.0                       107.0                         59 48                 107
1790638 1790638 IN     school 1807260 3135   Mt Vernon Community School Corp 180726002192 2570 McCordsville Elementary School   Regular School No Elementary KG 05 2018   grade_1                         51.0 56.0                       107.0                         51 56                 107
1795543 1795543 IN     school 1811260 6350   Tell City-Troy Twp School Corp 181126001282 6745 William Tell Elementary School   Regular School No Elementary KG 06 2018   grade_1                         55.0 52.0                       107.0                         55 52                 107
1796847 1796847 IN     school 1810140 7365   Shelbyville Central Schools 181014001632 7729 Thomas A Hendricks Elementary Sch   Regular School No Elementary PK 05 2018   grade_1                         51.0 56.0                       107.0                         51 56                 107
1797304 1797304 IN     school 1811340 7865   Tippecanoe School Corp 181134002441 8111 Woodland Elementary School   Regular School No Elementary KG 05 2018   grade_1                         53.0 54.0                       107.0                         53 54                 107
1797738 1797738 IN     school 1812090 8030   Vigo County School Corp 181209001903 8511 Dixie Bee Elementary School   Regular School No Elementary KG 05 2018   grade_1                         44.0 63.0                       107.0                         44 63                 107
1788703 1788703 IN     school 1807710 1375   North Daviess Com Schools 180771001648 1090 North Daviess Elementary School   Regular School No Elementary KG 06 2018   grade_1                         47.0 61.0                       108.0                         47 61                 108
1790868 1790868 IN     school 1800270 3315   Avon Community School Corp 180027000390 2735 Sycamore Elementary School   Regular School No Elementary KG 04 2018   grade_1                         68.0 40.0                       108.0                         68 40                 108
1791403 1791403 IN     school 1801050 3695   Brownstown Cnt Com Sch Corp 180105000182 3129 Brownstown Elementary School   Regular School No Elementary PK 05 2018   grade_1                         57.0 51.0                       108.0                         57 51                 108
1792252 1792252 IN     school 1809690 4600   Merrillville Community School Corp 180969001585 3829 Jonas E Salk Elementary School   Regular School No Elementary KG 04 2018   grade_1                         55.0 53.0                       108.0                         55 53                 108
1792305 1792305 IN     school 1805450 4615   Lake Central School Corporation 180545002143 4349 Homan Elementary School   Regular School No Elementary PK 04 2018   grade_1                         56.0 52.0                       108.0                         56 52                 108
1793316 1793316 IN     school 1800150 5275   Anderson Community School Corp 180015000044 5033 Valley Grove Elementary School   Regular School No Elementary KG 05 2018   grade_1                         50.0 58.0                       108.0                         50 58                 108
1793372 1793372 IN     school 1802640 5300   M S D Decatur Township 180264002111 5178 Gold Academy   Regular School No Elementary 01 06 2018   grade_1                         60.0 48.0                       108.0                         60 48                 108
1793674 1793674 IN     school 1808820 5340   Perry Township Schools 180882001687 5366 Jeremiah Gray Elementary School   Regular School No Elementary KG 05 2018   grade_1                         55.0 53.0                       108.0                         55 53                 108
1794011 1794011 IN     school 1812810 5375   M S D Wayne Township 181281002042 5273 Westlake Elementary School   Regular School No Elementary KG 06 2018   grade_1                         49.0 59.0                       108.0                         49 59                 108
1795638 1795638 IN     school 1802800 6470   Duneland School Corporation 180280000335 6823 Liberty Elementary School   Regular School No Elementary KG 04 2018   grade_1                         57.0 51.0                       108.0                         57 51                 108
1790320 1790320 IN     school 1813080 3030   Westfield-Washington Schools 181308000977 2494 Carey Ridge Elementary School   Regular School No Elementary PK 04 2018   grade_1                         57.0 52.0                       109.0                         57 52                 109
1790780 1790780 IN     school 1801020 3305   Brownsburg Community School Corp 180102000994 2706 Brown Elementary School   Regular School No Elementary KG 05 2018   grade_1                         69.0 40.0                       109.0                         69 40                 109
1797162 1797162 IN     school 1805400 7855   Lafayette School Corporation 180540000971 8103 Miami Elementary School   Regular School No Elementary KG 04 2018   grade_1                         67.0 42.0                       109.0                         67 42                 109
1798059 1798059 IN     school 1812390 8130   Warrick County School Corp 181239002179 8819 Sharon Elementary School   Regular School No Elementary KG 05 2018   grade_1                         53.0 56.0                       109.0                         53 56                 109
1799038 1799038 IN     school 1800074 9795   Dr Robert H Faulkner Academy 180007402426 2411 Dr Robert H Faulkner Academy   Regular School Yes Elementary KG 06 2018   grade_1                         5.0 6.0                       11.0                         5 6                 11
1790405 1790405 IN     school 1801200 3060   Carmel Clay Schools 180120000196 2510 College Wood Elementary School   Regular School No Elementary KG 05 2018   grade_1                         54.0 56.0                       110.0                         54 56                 110
1790568 1790568 IN     school 1810710 3115   Southern Hancock Co Com Sch Corp 181071001407 2567 Sugar Creek Elementary Sch   Regular School No Elementary KG 06 2018   grade_1                         64.0 46.0                       110.0                         64 46                 110
1797859 1797859 IN     school 1806270 8045   Manchester Community Schools 180627001101 8633 Manchester Elementary School   Regular School No Elementary PK 03 2018   grade_1                         61.0 49.0                       110.0                         61 49                 110
1799273 1799273 IN     school 1800170 9975   Global Preparatory Academy 180017002610 1112 Global Preparatory Academy   Regular School Yes Elementary KG 03 2018   grade_1                         50.0 60.0                       110.0                         50 60                 110
1787895 1787895 IN     school 1800360 365   Bartholomew Con School Corp 180036000077 357 Parkside Elementary School   Regular School No Elementary PK 06 2018   grade_1                         51.0 60.0                       111.0                         51 60                 111
1790350 1790350 IN     school 1813080 3030   Westfield-Washington Schools 181308002184 2504 Maple Glen Elementary   Regular School No Elementary PK 04 2018   grade_1                         61.0 50.0                       111.0                         61 50                 111
1793285 1793285 IN     school 1800120 5265   Alexandria Community School Corp 180012000009 5069 Alexandria-Monroe Elementary   Regular School No Elementary PK 02 2018   grade_1                         57.0 54.0                       111.0                         57 54                 111
1796379 1796379 IN     school 1808760 7175   Penn-Harris-Madison School Corp 180876000526 7383 Horizon Elementary School   Regular School No Elementary PK 05 2018   grade_1                         54.0 57.0                       111.0                         54 57                 111
1797825 1797825 IN     school 1812090 8030   Vigo County School Corp 181209001919 8607 Terre Town Elementary School   Regular School No Elementary KG 05 2018   grade_1                         53.0 58.0                       111.0                         53 58                 111
1798052 1798052 IN     school 1812390 8130   Warrick County School Corp 181239001984 8817 Newburgh Elementary School   Regular School No Elementary KG 05 2018   grade_1                         58.0 53.0                       111.0                         58 53                 111
1789342 1789342 IN     school 1802400 2270   Concord Community Schools 180240000274 1729 Concord West Side Elem School   Regular School No Elementary KG 04 2018   grade_1                         62.0 50.0                       112.0                         62 50                 112
1790390 1790390 IN     school 1801200 3060   Carmel Clay Schools 180120002332 2508 Cherry Tree Elementary School   Regular School No Elementary PK 05 2018   grade_1                         60.0 52.0                       112.0                         60 52                 112
1791733 1791733 IN     school 1801440 4205   Center Grove Community School Corp 180144002333 3444 Pleasant Grove Elementary School   Regular School No Elementary KG 05 2018   grade_1                         44.0 68.0                       112.0                         44 68                 112
1793544 1793544 IN     school 1805670 5330   M S D Lawrence Township 180567000150 5294 Forest Glen Elementary School   Regular School No Elementary KG 06 2018   grade_1                         52.0 60.0                       112.0                         52 60                 112
1793980 1793980 IN     school 1812810 5375   M S D Wayne Township 181281000238 5267 North Wayne Elementary School   Regular School No Elementary KG 06 2018   grade_1                         64.0 48.0                       112.0                         64 48                 112
1789324 1789324 IN     school 1802400 2270   Concord Community Schools 180240000270 1721 Concord East Side Elementary Sch   Regular School No Elementary KG 04 2018   grade_1                         53.0 60.0                       113.0                         53 60                 113
1791461 1791461 IN     school 1809420 3815   Rensselaer Central School Corp 180942001542 3213 Rensselaer Central Primary School   Regular School No Elementary PK 05 2018   grade_1                         58.0 55.0                       113.0                         58 55                 113
1791718 1791718 IN     school 1801440 4205   Center Grove Community School Corp 180144000211 3440 North Grove Elementary School   Regular School No Elementary KG 05 2018   grade_1                         50.0 63.0                       113.0                         50 63                 113
1790534 1790534 IN     school 1807650 3070   Noblesville Schools 180765001246 2547 White River Elementary School   Regular School No Elementary PK 05 2018   grade_1                         49.0 65.0                       114.0                         49 65                 114
1790588 1790588 IN     school 1804050 3125   Greenfield-Central Com Schools 180405001665 2588 JB Stephens Elementary School   Regular School No Elementary PK 03 2018   grade_1                         54.0 60.0                       114.0                         54 60                 114
1792233 1792233 IN     school 1809690 4600   Merrillville Community School Corp 180969001583 3822 Homer Iddings Elementary School   Regular School No Elementary KG 04 2018   grade_1                         60.0 54.0                       114.0                         60 54                 114
1790194 1790194 IN     school 1810650 3005   Hamilton Southeastern Schools 181065002168 2470 Cumberland Road Elem School   Regular School No Elementary PK 04 2018   grade_1                         62.0 53.0                       115.0                         62 53                 115
1790465 1790465 IN     school 1801200 3060   Carmel Clay Schools 180120002185 2526 West Clay Elementary School   Regular School No Elementary KG 05 2018   grade_1                         64.0 51.0                       115.0                         64 51                 115
1793666 1793666 IN     school 1808820 5340   Perry Township Schools 180882001470 5351 Winchester Village Elementary   Regular School No Elementary PK 05 2018   grade_1                         59.0 56.0                       115.0                         59 56                 115
1793744 1793744 IN     school 1808910 5350   M S D Pike Township 180891001486 5360 Guion Creek Elementary School   Regular School No Elementary KG 05 2018   grade_1                         56.0 59.0                       115.0                         56 59                 115
1797619 1797619 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345000489 8381 West Terrace Elementary School   Regular School No Elementary KG 05 2018   grade_1                         58.0 57.0                       115.0                         58 57                 115
1790813 1790813 IN     school 1801020 3305   Brownsburg Community School Corp 180102001567 2718 Delaware Trail Elementary School   Regular School No Elementary KG 05 2018   grade_1                         65.0 51.0                       116.0                         65 51                 116
1793232 1793232 IN     school 1812880 5245   Frankton-Lapel Community Schools 181288002052 5025 Lapel Elementary School   Regular School No Elementary PK 05 2018   grade_1                         58.0 58.0                       116.0                         58 58                 116
1793240 1793240 IN     school 1810440 5255   South Madison Com Sch Corp 181044002167 4935 East Elementary School   Regular School No Elementary KG 06 2018   grade_1                         54.0 62.0                       116.0                         54 62                 116
1793626 1793626 IN     school 1808820 5340   Perry Township Schools 180882001459 5333 Glenns Valley Elementary School   Regular School No Elementary PK 05 2018   grade_1                         61.0 55.0                       116.0                         61 55                 116

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