enrollments

Data source: Big Local News · About: Big Local

1,037 rows where grade = "grade_1", state = "IN" and year = 2021 sorted by total

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2021 · 1,037 ✖

grade ✖

  • grade_1 · 1,037 ✖
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
1921135 1921135 IN     school 1803270 2305   Elkhart Community Schools 180327002585 1752 Elkhart Alternative Education   Regular School No Other 01 12 2021   grade_1                         1.0 0.0                       1.0                         1 0                 1
1927188 1927188 IN     school   6520   Porter Township School Corp   6811 Porter County Education Services             2021   grade_1                         0.0 1.0                       1.0                         0 1                 1
1927239 1927239 IN     school   6550   Portage Township Schools   6811 Porter County Education Services             2021   grade_1                         0.0 1.0                       1.0                         0 1                 1
1921559 1921559 IN     school 1802940 2725   East Gibson School Corporation 180294000382 2201 Francisco Elementary School   Regular School No Elementary KG 06 2021   grade_1                         5.0 5.0                       10.0                         5 5                 10
1925278 1925278 IN     school 1808910 5350   MSD Pike Township 180891001485 5359 Eastbrook Elementary School   Regular School No Elementary KG 05 2021   grade_1                         53.0 47.0                       100.0                         53 47                 100
1925415 1925415 IN     school 1812720 5370   MSD Washington Township 181272002016 5418 Greenbriar Elementary School   Regular School No Elementary KG 05 2021   grade_1                         54.0 46.0                       100.0                         54 46                 100
1925438 1925438 IN     school 1812720 5370   MSD Washington Township 181272002376 5436 Fox Hill Elementary School   Regular School No Elementary KG 05 2021   grade_1                         61.0 39.0                       100.0                         61 39                 100
1927922 1927922 IN     school 1808760 7175   Penn-Harris-Madison School Corp 180876001148 7390 Northpoint Elementary School   Regular School No Elementary KG 05 2021   grade_1                         59.0 41.0                       100.0                         59 41                 100
1928383 1928383 IN     school 1810140 7365   Shelbyville Central Schools 181014001633 7733 William F Loper Elementary School   Regular School No Elementary KG 05 2021   grade_1                         54.0 46.0                       100.0                         54 46                 100
1928727 1928727 IN     school 1811340 7865   Tippecanoe School Corp 181134001829 8005 Mayflower Mill Elementary School   Regular School No Elementary KG 05 2021   grade_1                         48.0 52.0                       100.0                         48 52                 100
1928826 1928826 IN     school 1811340 7865   Tippecanoe School Corp 181134002441 8111 Woodland Elementary School   Regular School No Elementary KG 05 2021   grade_1                         49.0 51.0                       100.0                         49 51                 100
1930489 1930489 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2021   grade_1                         51.0 49.0                       100.0                         51 49                 100
1919579 1919579 IN     school 1800360 365   Bartholomew Con School Corp 180036000071 369 Lillian Schmitt Elementary School   Regular School No Elementary PK 06 2021   grade_1                         56.0 45.0                       101.0                         56 45                 101
1919883 1919883 IN     school 1802700 755   Delphi Community School Corp 180270000328 641 Delphi Community Elementary School   Regular School No Elementary KG 05 2021   grade_1                         53.0 48.0                       101.0                         53 48                 101
1922781 1922781 IN     school 1811250 3460   Taylor Community School Corp 181125001812 2895 Taylor Elementary School   Regular School No Elementary PK 04 2021   grade_1                         46.0 55.0                       101.0                         46 55                 101
1923387 1923387 IN     school 1801440 4205   Center Grove Community School Corp 180144002333 3444 Pleasant Grove Elementary School   Regular School No Elementary KG 05 2021   grade_1                         63.0 38.0                       101.0                         63 38                 101
1924794 1924794 IN     school 1810440 5255   South Madison Com Sch Corp 181044002167 4935 East Elementary School   Regular School No Elementary KG 06 2021   grade_1                         58.0 43.0                       101.0                         58 43                 101
1925343 1925343 IN     school 1812360 5360   MSD Warren Township 181236001963 5373 Grassy Creek Elementary School   Regular School No Elementary KG 04 2021   grade_1                         54.0 47.0                       101.0                         54 47                 101
1927007 1927007 IN     school 1811260 6350   Tell City-Troy Twp School Corp 181126001282 6745 William Tell Elementary School   Regular School No Elementary PK 06 2021   grade_1                         54.0 47.0                       101.0                         54 47                 101
1928684 1928684 IN     school 1805400 7855   Lafayette School Corporation 180540000971 8103 Miami Elementary School   Regular School No Elementary KG 04 2021   grade_1                         52.0 49.0                       101.0                         52 49                 101
1922177 1922177 IN     school 1807650 3070   Noblesville Schools 180765002546 2539 Promise Road Elementary   Regular School No Elementary PK 05 2021   grade_1                         50.0 52.0                       102.0                         50 52                 102
1922409 1922409 IN     school 1808100 3295   North West Hendricks Schools 180810002465 2684 Pittsboro Primary School   Regular School No Elementary PK 02 2021   grade_1                         51.0 51.0                       102.0                         51 51                 102
1923056 1923056 IN     school 1801050 3695   Brownstown Cnt Com Sch Corp 180105000182 3129 Brownstown Elementary School   Regular School No Elementary PK 05 2021   grade_1                         49.0 53.0                       102.0                         49 53                 102
1923826 1923826 IN     school 1804350 4580   Hanover Community School Corp 180435000871 3782 Lincoln Elementary School   Regular School No Elementary KG 04 2021   grade_1                         43.0 59.0                       102.0                         43 59                 102
1925191 1925191 IN     school 1808820 5340   Perry Township Schools 180882001460 5345 Homecroft Elementary School   Regular School No Elementary PK 05 2021   grade_1                         51.0 51.0                       102.0                         51 51                 102
1926360 1926360 IN     school 1800630 5740   Monroe County Community Sch Corp 180063002127 6164 Summit Elementary School   Regular School No Elementary PK 06 2021   grade_1                         49.0 53.0                       102.0                         49 53                 102
1928098 1928098 IN     school 1810290 7205   South Bend Community School Corp 181029001646 7545 Harrison Elementary School   Regular School No Elementary KG 05 2021   grade_1                         56.0 46.0                       102.0                         56 46                 102
1928228 1928228 IN     school 1809990 7230   Scott County School District 1 180999001604 7630 Austin Elementary School   Regular School No Elementary KG 05 2021   grade_1                         56.0 46.0                       102.0                         56 46                 102
1929979 1929979 IN     school 1802280 8665   Whitley County Con Schools 180228002135 9178 Little Turtle Elementary School   Regular School No Elementary KG 05 2021   grade_1                         45.0 57.0                       102.0                         45 57                 102
1918998 1918998 IN     school 1810260 35   South Adams Schools 181026001640 25 South Adams Elementary School   Regular School No Elementary PK 05 2021   grade_1                         48.0 55.0                       103.0                         48 55                 103
1919240 1919240 IN     school 1803630 235   Fort Wayne Community Schools 180363000527 154 Fred H Croninger Elementary School   Regular School No Elementary KG 05 2021   grade_1                         52.0 51.0                       103.0                         52 51                 103
1919554 1919554 IN     school 1800360 365   Bartholomew Con School Corp 180036000077 357 Parkside Elementary School   Regular School No Elementary PK 06 2021   grade_1                         54.0 49.0                       103.0                         54 49                 103
1924156 1924156 IN     school 1803870 4690   Gary Community School Corp 180387000620 4086 Frankie Woods McCullough Academy   Regular School No Elementary KG 05 2021   grade_1                         47.0 56.0                       103.0                         47 56                 103
1928708 1928708 IN     school 1805400 7855   Lafayette School Corporation 180540000978 8117 Vinton Elementary School   Regular School No Elementary KG 04 2021   grade_1                         57.0 46.0                       103.0                         57 46                 103
1928866 1928866 IN     school 1811400 7945   Tipton Community School Corp 181140001844 8163 Tipton Elementary School   Regular School No Elementary PK 05 2021   grade_1                         48.0 55.0                       103.0                         48 55                 103
1919097 1919097 IN     school 1808250 225   Northwest Allen County Schools 180825001416 92 Perry Hill Elementary School   Regular School No Elementary KG 05 2021   grade_1                         58.0 46.0                       104.0                         58 46                 104
1919527 1919527 IN     school 1800360 365   Bartholomew Con School Corp 180036002188 328 Clifty Creek Elementary School   Regular School No Elementary PK 06 2021   grade_1                         50.0 54.0                       104.0                         50 54                 104
1921397 1921397 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741001268 1957 Grant Line Elementary School   Regular School No Elementary KG 04 2021   grade_1                         43.0 61.0                       104.0                         43 61                 104
1922431 1922431 IN     school 1801020 3305   Brownsburg Community School Corp 180102000994 2706 Brown Elementary School   Regular School No Elementary KG 05 2021   grade_1                         50.0 54.0                       104.0                         50 54                 104
1923884 1923884 IN     school 1809690 4600   Merrillville Community School Corp 180969001583 3822 Homer Iddings Elementary School   Regular School No Elementary KG 04 2021   grade_1                         54.0 50.0                       104.0                         54 50                 104
1924819 1924819 IN     school 1810440 5255   South Madison Com Sch Corp 181044001676 5064 Maple Ridge Elementary School   Regular School No Elementary KG 06 2021   grade_1                         48.0 56.0                       104.0                         48 56                 104
1925491 1925491 IN     school 1812810 5375   MSD Wayne Township 181281002033 5241 Garden City Elementary School   Regular School No Elementary PK 06 2021   grade_1                         65.0 39.0                       104.0                         65 39                 104
1921063 1921063 IN     school 1812240 2285   Wa-Nee Community Schools 181224000028 1735 Wakarusa Elementary School   Regular School No Elementary KG 05 2021   grade_1                         44.0 61.0                       105.0                         44 61                 105
1922240 1922240 IN     school 1804050 3125   Greenfield-Central Com Schools 180405001665 2588 JB Stephens Elementary School   Regular School No Elementary PK 03 2021   grade_1                         57.0 48.0                       105.0                         57 48                 105
1923956 1923956 IN     school 1805450 4615   Lake Central School Corporation 180545002143 4349 Homan Elementary School   Regular School No Elementary PK 04 2021   grade_1                         51.0 54.0                       105.0                         51 54                 105
1924180 1924180 IN     school 1803870 4690   Gary Community School Corp 180387002104 4169 Daniel Hale Williams Elem Sch   Regular School No Elementary KG 05 2021   grade_1                         52.0 53.0                       105.0                         52 53                 105
1924442 1924442 IN     school 1807350 4740   School Town of Munster 180735001254 4343 Frank H Hammond Elementary School   Regular School No Elementary PK 05 2021   grade_1                         49.0 56.0                       105.0                         49 56                 105
1920594 1920594 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_1                         51.0 55.0                       106.0                         51 55                 106
1920630 1920630 IN     school 1801590 1835   DeKalb Co Ctl United Sch Dist 180159000225 1357 McKenney-Harrison Elementary Sch   Regular School No Elementary PK 05 2021   grade_1                         51.0 55.0                       106.0                         51 55                 106
1921416 1921416 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741002204 1974 Mount Tabor Elementary School   Regular School No Elementary KG 04 2021   grade_1                         56.0 50.0                       106.0                         56 50                 106
1922206 1922206 IN     school 1810710 3115   Southern Hancock Co Com Sch Corp 181071001760 2564 New Palestine Elementary School   Regular School No Elementary PK 04 2021   grade_1                         53.0 53.0                       106.0                         53 53                 106
1922527 1922527 IN     school 1800270 3315   Avon Community School Corp 180027000390 2735 Sycamore Elementary School   Regular School No Elementary KG 04 2021   grade_1                         55.0 51.0                       106.0                         55 51                 106
1923903 1923903 IN     school 1809690 4600   Merrillville Community School Corp 180969001585 3829 Jonas E Salk Elementary School   Regular School No Elementary KG 04 2021   grade_1                         50.0 56.0                       106.0                         50 56                 106
1921856 1921856 IN     school 1810650 3005   Hamilton Southeastern Schools 181065001750 2473 Fall Creek Elementary School   Regular School No Elementary PK 04 2021   grade_1                         53.0 54.0                       107.0                         53 54                 107
1923528 1923528 IN     school 1810410 4325   South Knox School Corp 181041001705 3489 South Knox Elementary School   Regular School No Elementary KG 06 2021   grade_1                         51.0 56.0                       107.0                         51 56                 107
1924398 1924398 IN     school 1804590 4730   School City of Hobart 180459000775 4317 Liberty Elementary School   Regular School No Elementary 01 05 2021   grade_1                         53.0 54.0                       107.0                         53 54                 107
1927107 1927107 IN     school 1802800 6470   Duneland School Corporation 180280000335 6823 Liberty Elementary School   Regular School No Elementary KG 04 2021   grade_1                         58.0 49.0                       107.0                         58 49                 107
1930890 1930890 IN     school 1800161 9960   Success Academy Primary School 180016102583 7562 Success Academy Primary School   Regular School Yes Elementary KG 05 2021   grade_1                         53.0 54.0                       107.0                         53 54                 107
1919247 1919247 IN     school 1803630 235   Fort Wayne Community Schools 180363000522 157 Forest Park Elementary School   Regular School No Elementary PK 05 2021   grade_1                         60.0 48.0                       108.0                         60 48                 108
1921990 1921990 IN     school 1813080 3030   Westfield-Washington Schools 181308001392 2496 Oak Trace Elementary School   Regular School No Elementary PK 04 2021   grade_1                         52.0 56.0                       108.0                         52 56                 108
1924243 1924243 IN     school 1804320 4710   School City of Hammond 180432002413 4422 Joseph Hess Elementary School   Regular School No Elementary PK 05 2021   grade_1                         61.0 47.0                       108.0                         61 47                 108
1924866 1924866 IN     school 1800150 5275   Anderson Community School Corp 180015000041 4977 Tenth Street Elementary School   Regular School No Elementary KG 04 2021   grade_1                         59.0 49.0                       108.0                         59 49                 108
1924923 1924923 IN     school 1802640 5300   MSD Decatur Township 180264002111 5178 Gold Academy   Regular School No Elementary 01 06 2021   grade_1                         52.0 56.0                       108.0                         52 56                 108
1925075 1925075 IN     school 1805670 5330   MSD Lawrence Township 180567002278 5293 Indian Creek Elementary School   Regular School No Elementary 01 06 2021   grade_1                         61.0 47.0                       108.0                         61 47                 108
1925500 1925500 IN     school 1812810 5375   MSD Wayne Township 181281002035 5257 McClelland Elementary School   Regular School No Elementary KG 06 2021   grade_1                         57.0 51.0                       108.0                         57 51                 108
1928769 1928769 IN     school 1811340 7865   Tippecanoe School Corp 181134001305 8021 Wea Ridge Elementary School   Regular School No Elementary KG 05 2021   grade_1                         51.0 57.0                       108.0                         51 57                 108
1921843 1921843 IN     school 1810650 3005   Hamilton Southeastern Schools 181065002168 2470 Cumberland Road Elem School   Regular School No Elementary KG 04 2021   grade_1                         51.0 58.0                       109.0                         51 58                 109
1922457 1922457 IN     school 1801020 3305   Brownsburg Community School Corp 180102002430 2714 Reagan Elementary School   Regular School No Elementary KG 05 2021   grade_1                         49.0 60.0                       109.0                         49 60                 109
1922475 1922475 IN     school 1801020 3305   Brownsburg Community School Corp 180102001671 2723 White Lick Elementary School   Regular School No Elementary KG 05 2021   grade_1                         52.0 57.0                       109.0                         52 57                 109
1930396 1930396 IN     school 1800147 9410   KIPP Indy Unite Elementary 180014702571 5741 KIPP Indy Unite Elementary   Regular School Yes Elementary KG 05 2021   grade_1                         53.0 56.0                       109.0                         53 56                 109
1921548 1921548 IN     school 1802940 2725   East Gibson School Corporation 180294000383 2189 Barton Township Elementary   Regular School No Elementary KG 06 2021   grade_1                         7.0 4.0                       11.0                         7 4                 11
1921007 1921007 IN     school 1802400 2270   Concord Community Schools 180240000274 1729 Concord West Side Elem School   Regular School No Elementary KG 04 2021   grade_1                         50.0 60.0                       110.0                         50 60                 110
1923806 1923806 IN     school 1805520 4535   Lakeland School Corporation 180552002670 3732 Lakeland Primary School   Regular School No Elementary KG 02 2021   grade_1                         47.0 63.0                       110.0                         47 63                 110
1924047 1924047 IN     school 1802490 4660   Crown Point Community School Corp 180249000296 3903 Lake Street Elementary School   Regular School No Elementary KG 05 2021   grade_1                         57.0 53.0                       110.0                         57 53                 110
1924930 1924930 IN     school 1802640 5300   MSD Decatur Township 180264002112 5179 Blue Academy   Regular School No Elementary 01 06 2021   grade_1                         55.0 55.0                       110.0                         55 55                 110
1925065 1925065 IN     school 1805670 5330   MSD Lawrence Township 180567001027 5289 Harrison Hill Elementary School   Regular School No Elementary 01 06 2021   grade_1                         58.0 52.0                       110.0                         58 52                 110
1925143 1925143 IN     school 1808820 5340   Perry Township Schools 180882001469 5321 William Henry Burkhart Elementary   Regular School No Elementary PK 05 2021   grade_1                         57.0 53.0                       110.0                         57 53                 110
1928678 1928678 IN     school 1805400 7855   Lafayette School Corporation 180540000965 8091 Glen Acres Elementary School   Regular School No Elementary KG 04 2021   grade_1                         55.0 55.0                       110.0                         55 55                 110
1930628 1930628 IN     school 1800086 9680   Paramount Brookside 180008602478 5508 Paramount Brookside   Regular School Yes Elementary KG 08 2021   grade_1                         53.0 57.0                       110.0                         53 57                 110
1921849 1921849 IN     school 1810650 3005   Hamilton Southeastern Schools 181065001560 2471 Hoosier Road Elementary School   Regular School No Elementary PK 04 2021   grade_1                         65.0 46.0                       111.0                         65 46                 111
1921963 1921963 IN     school 1813080 3030   Westfield-Washington Schools 181308000134 2492 Shamrock Springs Elementary School   Regular School No Elementary PK 04 2021   grade_1                         59.0 52.0                       111.0                         59 52                 111
1922189 1922189 IN     school 1807650 3070   Noblesville Schools 180765001246 2547 White River Elementary School   Regular School No Elementary PK 05 2021   grade_1                         59.0 52.0                       111.0                         59 52                 111
1923365 1923365 IN     school 1801440 4205   Center Grove Community School Corp 180144002105 3439 Maple Grove Elementary School   Regular School No Elementary KG 05 2021   grade_1                         62.0 49.0                       111.0                         62 49                 111
1924947 1924947 IN     school 1802640 5300   MSD Decatur Township 180264002271 5187 Valley Mills Elementary School   Regular School No Elementary 01 06 2021   grade_1                         59.0 52.0                       111.0                         59 52                 111
1925199 1925199 IN     school 1808820 5340   Perry Township Schools 180882001466 5347 Southport Elementary School   Regular School No Elementary PK 05 2021   grade_1                         58.0 53.0                       111.0                         58 53                 111
1925401 1925401 IN     school 1812720 5370   MSD Washington Township 181272002657 5407 Clearwater Elementary School   Regular School No Elementary KG 05 2021   grade_1                         49.0 62.0                       111.0                         49 62                 111
1929485 1929485 IN     school 1812150 8060   Wabash City Schools 181215001937 8706 O J Neighbours Elementary School   Regular School No Elementary PK 04 2021   grade_1                         66.0 45.0                       111.0                         66 45                 111
1921894 1921894 IN     school 1810650 3005   Hamilton Southeastern Schools 181065002429 2483 Thorpe Creek Elementary   Regular School No Elementary KG 04 2021   grade_1                         59.0 53.0                       112.0                         59 53                 112
1925159 1925159 IN     school 1808820 5340   Perry Township Schools 180882001456 5325 Clinton Young Elementary School   Regular School No Elementary PK 05 2021   grade_1                         63.0 49.0                       112.0                         63 49                 112
1927205 1927205 IN     school 1809180 6520   Porter Township School Corp 180918001522 6840 Porter Lakes Elementary School   Regular School No Elementary PK 03 2021   grade_1                         55.0 57.0                       112.0                         55 57                 112
1928762 1928762 IN     school 1811340 7865   Tippecanoe School Corp 181134001304 8019 Burnett Creek Elementary School   Regular School No Elementary KG 05 2021   grade_1                         48.0 64.0                       112.0                         48 64                 112
1918980 1918980 IN     school 1807680 25   North Adams Community Schools 180768001316 37 Bellmont Elementary   Regular School No Elementary PK 05 2021   grade_1                         60.0 53.0                       113.0                         60 53                 113
1920423 1920423 IN     school 1811190 1560   Sunman-Dearborn Com Sch Corp 181119001803 1189 North Dearborn Elementary School   Regular School No Elementary PK 05 2021   grade_1                         61.0 52.0                       113.0                         61 52                 113
1921997 1921997 IN     school 1813080 3030   Westfield-Washington Schools 181308002449 2498 Monon Trail Elementary School   Regular School No Elementary KG 04 2021   grade_1                         58.0 55.0                       113.0                         58 55                 113
1922102 1922102 IN     school 1801200 3060   Carmel Clay Schools 180120002101 2518 Forest Dale Elementary School   Regular School No Elementary PK 05 2021   grade_1                         50.0 63.0                       113.0                         50 63                 113
1922222 1922222 IN     school 1810710 3115   Southern Hancock Co Com Sch Corp 181071001407 2567 Sugar Creek Elementary Sch   Regular School No Elementary KG 04 2021   grade_1                         56.0 57.0                       113.0                         56 57                 113
1922817 1922817 IN     school 1803150 3480   Eastern Howard School Corporation 180315000412 2909 Eastern Elementary School   Regular School No Elementary KG 05 2021   grade_1                         60.0 53.0                       113.0                         60 53                 113
1924786 1924786 IN     school 1812880 5245   Frankton-Lapel Community Schools 181288002052 5025 Lapel Elementary School   Regular School No Elementary PK 05 2021   grade_1                         64.0 49.0                       113.0                         64 49                 113
1929065 1929065 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345000470 8317 Hebron Elementary School   Regular School No Elementary PK 05 2021   grade_1                         66.0 47.0                       113.0                         66 47                 113
1920646 1920646 IN     school 1802660 1875   Delaware Community School Corp 180266000324 1365 Royerton Elementary School   Regular School No Elementary KG 05 2021   grade_1                         61.0 53.0                       114.0                         61 53                 114

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