enrollments

Data source: Big Local News · About: Big Local

1,060 rows where grade = "grade_1", state = "IN" and year = 2015 sorted by ccd_school_low_grade

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2015 · 1,060 ✖

grade ✖

  • grade_1 · 1,060 ✖
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
1166230 1166230 IN     school   5375   M S D Wayne Township   5271 Sanders School             2015   grade_1                         2.0 1.0                       3.0                         2 1                 3
1159666 1159666 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No 1.0 01 08 2015   grade_1                         37.0 39.0                       76.0                         37 39                 76
1159707 1159707 IN     school 1803630 235   Fort Wayne Community Schools 180363000570 134 Weisser Park Elem Sch   Regular School No 1.0 01 05 2015   grade_1                         57.0 62.0                       119.0                         57 62                 119
1162134 1162134 IN     school 1807770 2735   North Gibson School Corp 180777001324 2223 Princeton Comm Intermediate School   Regular School No 1.0 01 05 2015   grade_1                         1.0 0.0                       1.0                         1 0                 1
1163264 1163264 IN     school 1807440 3445   New Castle Community Sch Corp 180744001286 2849 James Whitcomb Riley Elem School   Regular School No 1.0 01 06 2015   grade_1                         17.0 18.0                       35.0                         17 18                 35
1163280 1163280 IN     school 1807440 3445   New Castle Community Sch Corp 180744001291 2861 Westwood Elementary School   Regular School No 1.0 01 06 2015   grade_1                         15.0 12.0                       27.0                         15 12                 27
1164698 1164698 IN     school 1802910 4680   Lake Station Community Schools 180291000376 3973 Alexander Hamilton Elementary Sch   Regular School No 1.0 01 06 2015   grade_1                         22.0 14.0                       36.0                         22 14                 36
1164713 1164713 IN     school 1802910 4680   Lake Station Community Schools 180291000377 3985 Carl J Polk Elementary School   Regular School No 1.0 01 06 2015   grade_1                         17.0 20.0                       37.0                         17 20                 37
1165056 1165056 IN     school 1804590 4730   School City of Hobart 180459000777 4325 Ridge View Elementary School   Regular School No 1.0 01 05 2015   grade_1                         36.0 30.0                       66.0                         36 30                 66
1165614 1165614 IN     school 1802640 5300   M S D Decatur Township 180264002111 5178 Gold Academy   Regular School No 1.0 01 06 2015   grade_1                         56.0 46.0                       102.0                         56 46                 102
1165621 1165621 IN     school 1802640 5300   M S D Decatur Township 180264002112 5179 Blue Academy   Regular School No 1.0 01 06 2015   grade_1                         46.0 43.0                       89.0                         46 43                 89
1165631 1165631 IN     school 1802640 5300   M S D Decatur Township 180264000315 5185 Stephen Decatur Elem Sch   Regular School No 1.0 01 06 2015   grade_1                         40.0 40.0                       80.0                         40 40                 80
1165638 1165638 IN     school 1802640 5300   M S D Decatur Township 180264002271 5187 Valley Mills Elementary Sch   Regular School No 1.0 01 06 2015   grade_1                         51.0 42.0                       93.0                         51 42                 93
1165651 1165651 IN     school 1802640 5300   M S D Decatur Township 180264000317 5189 West Newton Elementary School   Regular School No 1.0 01 06 2015   grade_1                         49.0 52.0                       101.0                         49 52                 101
1165732 1165732 IN     school 1805670 5330   M S D Lawrence Township 180567001024 5281 Brook Park Elementary School   Regular School No 1.0 01 06 2015   grade_1                         57.0 58.0                       115.0                         57 58                 115
1165739 1165739 IN     school 1805670 5330   M S D Lawrence Township 180567001032 5283 Mary Evelyn Castle Elem Sch   Regular School No 1.0 01 06 2015   grade_1                         55.0 58.0                       113.0                         55 58                 113
1165749 1165749 IN     school 1805670 5330   M S D Lawrence Township 180567001026 5285 Crestview Elementary School   Regular School No 1.0 01 06 2015   grade_1                         30.0 20.0                       50.0                         30 20                 50
1165756 1165756 IN     school 1805670 5330   M S D Lawrence Township 180567002339 5287 Amy Beverland Elementary   Regular School No 1.0 01 06 2015   grade_1                         69.0 84.0                       153.0                         69 84                 153
1165763 1165763 IN     school 1805670 5330   M S D Lawrence Township 180567001027 5289 Harrison Hill Elem Sch   Regular School No 1.0 01 06 2015   grade_1                         54.0 65.0                       119.0                         54 65                 119
1165773 1165773 IN     school 1805670 5330   M S D Lawrence Township 180567002278 5293 Indian Creek Elem Sch   Regular School No 1.0 01 06 2015   grade_1                         65.0 49.0                       114.0                         65 49                 114
1165788 1165788 IN     school 1805670 5330   M S D Lawrence Township 180567002114 5295 Winding Ridge Elementary School   Regular School No 1.0 01 06 2015   grade_1                         40.0 53.0                       93.0                         40 53                 93
1165795 1165795 IN     school 1805670 5330   M S D Lawrence Township 180567001033 5296 Oaklandon Elementary School   Regular School No 1.0 01 06 2015   grade_1                         46.0 37.0                       83.0                         46 37                 83
1165802 1165802 IN     school 1805670 5330   M S D Lawrence Township 180567001034 5298 Skiles Test Elementary School   Regular School No 1.0 01 06 2015   grade_1                         63.0 45.0                       108.0                         63 45                 108
1165809 1165809 IN     school 1805670 5330   M S D Lawrence Township 180567001066 5299 Sunnyside Elementary Sch   Regular School No 1.0 01 06 2015   grade_1                         58.0 58.0                       116.0                         58 58                 116
1166083 1166083 IN     school 1812720 5370   M S D Washington Township 181272002010 5403 Allisonville Elementary Sch   Regular School No 1.0 01 05 2015   grade_1                         74.0 77.0                       151.0                         74 77                 151
1159466 1159466 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary Sch   Regular School No 1.0 KG 05 2015   grade_1                         63.0 40.0                       103.0                         63 40                 103
1159515 1159515 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No 1.0 KG 05 2015   grade_1                         27.0 28.0                       55.0                         27 28                 55
1159539 1159539 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002044 64 Lafayette Meadow School   Regular School No 1.0 KG 05 2015   grade_1                         54.0 32.0                       86.0                         54 32                 86
1159550 1159550 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002186 68 Haverhill Elementary School   Regular School No 1.0 KG 05 2015   grade_1                         27.0 31.0                       58.0                         27 31                 58
1159557 1159557 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002329 71 Deer Ridge Elementary   Regular School No 1.0 KG 05 2015   grade_1                         28.0 34.0                       62.0                         28 34                 62
1159564 1159564 IN     school 1800030 125   M S D Southwest Allen County Schls 180003001810 72 Covington Elementary School   Regular School No 1.0 KG 05 2015   grade_1                         53.0 70.0                       123.0                         53 70                 123
1159571 1159571 IN     school 1808250 225   Northwest Allen County Schools 180825001413 69 Arcola School   Regular School No 1.0 KG 05 2015   grade_1                         12.0 16.0                       28.0                         12 16                 28
1159582 1159582 IN     school 1808250 225   Northwest Allen County Schools 180825000937 87 Hickory Center Elementary Sch   Regular School No 1.0 KG 05 2015   grade_1                         30.0 41.0                       71.0                         30 41                 71
1159589 1159589 IN     school 1808250 225   Northwest Allen County Schools 180825001415 89 Huntertown Elementary School   Regular School No 1.0 KG 05 2015   grade_1                         46.0 40.0                       86.0                         46 40                 86
1159605 1159605 IN     school 1808250 225   Northwest Allen County Schools 180825001416 92 Perry Hill Elementary School   Regular School No 1.0 KG 05 2015   grade_1                         33.0 34.0                       67.0                         33 34                 67
1159612 1159612 IN     school 1808250 225   Northwest Allen County Schools 180825000016 94 Oak View Elementary Sch   Regular School No 1.0 KG 05 2015   grade_1                         32.0 35.0                       67.0                         32 35                 67
1159627 1159627 IN     school 1808250 225   Northwest Allen County Schools 180825002457 96 Eel River Elementary School   Regular School No 1.0 KG 05 2015   grade_1                         47.0 45.0                       92.0                         47 45                 92
1159756 1159756 IN     school 1803630 235   Fort Wayne Community Schools 180363000527 154 Fred H Croninger Elem Sch   Regular School No 1.0 KG 05 2015   grade_1                         54.0 50.0                       104.0                         54 50                 104
1159779 1159779 IN     school 1803630 235   Fort Wayne Community Schools 180363000529 162 Glenwood Park Elementary Sch   Regular School No 1.0 KG 05 2015   grade_1                         57.0 68.0                       125.0                         57 68                 125
1159823 1159823 IN     school 1803630 235   Fort Wayne Community Schools 180363000535 193 John S Irwin Elementary Sch   Regular School No 1.0 KG 05 2015   grade_1                         28.0 20.0                       48.0                         28 20                 48
1159846 1159846 IN     school 1803630 235   Fort Wayne Community Schools 180363000572 209 Willard Shambaugh Elem Sch   Regular School No 1.0 KG 05 2015   grade_1                         38.0 33.0                       71.0                         38 33                 71
1159882 1159882 IN     school 1803630 235   Fort Wayne Community Schools 180363000559 233 Saint Joseph Central School   Regular School No 1.0 KG 05 2015   grade_1                         42.0 40.0                       82.0                         42 40                 82
1159889 1159889 IN     school 1803630 235   Fort Wayne Community Schools 180363000558 239 Robert C Harris Elem Sch   Regular School No 1.0 KG 05 2015   grade_1                         44.0 46.0                       90.0                         44 46                 90
1159943 1159943 IN     school 1803630 235   Fort Wayne Community Schools 180363000540 270 Lincoln Elementary School   Regular School No 1.0 KG 05 2015   grade_1                         74.0 61.0                       135.0                         74 61                 135
1159950 1159950 IN     school 1803630 235   Fort Wayne Community Schools 180363000569 273 Waynedale Elementary School   Regular School No 1.0 KG 05 2015   grade_1                         55.0 29.0                       84.0                         55 29                 84
1159957 1159957 IN     school 1803630 235   Fort Wayne Community Schools 180363000514 275 Arlington Elementary School   Regular School No 1.0 KG 05 2015   grade_1                         41.0 52.0                       93.0                         41 52                 93
1159993 1159993 IN     school 1802850 255   East Allen County Schools 180285000346 281 Heritage Elementary School   Regular School No 1.0 KG 06 2015   grade_1                         30.0 31.0                       61.0                         30 31                 61
1160008 1160008 IN     school 1802850 255   East Allen County Schools 180285000954 291 Cedarville Elementary Sch   Regular School No 1.0 KG 03 2015   grade_1                         91.0 67.0                       158.0                         91 67                 158
1160037 1160037 IN     school 1802850 255   East Allen County Schools 180285002514 323 Woodlan Elementary School   Regular School No 1.0 KG 06 2015   grade_1                         30.0 31.0                       61.0                         30 31                 61
1160058 1160058 IN     school 1800360 365   Bartholomew Con School Corp 180036002421 346 CSA Lincoln Campus   Regular School No 1.0 KG 06 2015   grade_1                         25.0 26.0                       51.0                         25 26                 51
1160104 1160104 IN     school 1800360 365   Bartholomew Con School Corp 180036000071 369 Lillian Schmitt Elem School   Regular School No 1.0 KG 06 2015   grade_1                         65.0 63.0                       128.0                         65 63                 128
1160164 1160164 IN     school 1803570 370   Flat Rock-Hawcreek School Corp 180357000510 409 Hope Elementary School   Regular School No 1.0 KG 06 2015   grade_1                         34.0 31.0                       65.0                         34 31                 65
1160179 1160179 IN     school 1800480 395   Benton Community School Corp 180048000100 421 Otterbein Elementary School   Regular School No 1.0 KG 06 2015   grade_1                         32.0 20.0                       52.0                         32 20                 52
1160187 1160187 IN     school 1800480 395   Benton Community School Corp 180048000098 433 Boswell Elementary School   Regular School No 1.0 KG 06 2015   grade_1                         12.0 13.0                       25.0                         12 13                 25
1160202 1160202 IN     school 1800480 395   Benton Community School Corp 180048002403 446 Prairie Crossing Elementary Sch   Regular School No 1.0 KG 06 2015   grade_1                         32.0 32.0                       64.0                         32 32                 64
1160210 1160210 IN     school 1800570 515   Blackford County Schools 180057000107 485 Montpelier School   Regular School No 1.0 KG 06 2015   grade_1                         23.0 16.0                       39.0                         23 16                 39
1160230 1160230 IN     school 1800570 515   Blackford County Schools 180057000126 501 Southside Elementary School   Regular School No 1.0 KG 03 2015   grade_1                         52.0 53.0                       105.0                         52 53                 105
1160277 1160277 IN     school 1802830 630   Zionsville Community Schools 180283001219 514 Eagle Elementary School   Regular School No 1.0 KG 04 2015   grade_1                         35.0 32.0                       67.0                         35 32                 67
1160297 1160297 IN     school 1802830 630   Zionsville Community Schools 180283001854 542 Stonegate Elementary   Regular School No 1.0 KG 04 2015   grade_1                         40.0 43.0                       83.0                         40 43                 83
1160310 1160310 IN     school 1805790 665   Lebanon Community School Corp 180579001042 534 Perry Worth Elementary School   Regular School No 1.0 KG 05 2015   grade_1                         37.0 31.0                       68.0                         37 31                 68
1160326 1160326 IN     school 1805790 665   Lebanon Community School Corp 180579001038 561 Central Elementary School   Regular School No 1.0 KG 05 2015   grade_1                         32.0 30.0                       62.0                         32 30                 62
1160333 1160333 IN     school 1805790 665   Lebanon Community School Corp 180579001039 565 Harney Elementary School   Regular School No 1.0 KG 05 2015   grade_1                         45.0 53.0                       98.0                         45 53                 98
1160340 1160340 IN     school 1805790 665   Lebanon Community School Corp 180579001043 569 Hattie B Stokes Elementary School   Regular School No 1.0 KG 05 2015   grade_1                         43.0 42.0                       85.0                         43 42                 85
1160422 1160422 IN     school 1808940 775   Pioneer Regional School Corp 180894001490 649 Pioneer Elementary School   Regular School No 1.0 KG 06 2015   grade_1                         38.0 28.0                       66.0                         38 28                 66
1160441 1160441 IN     school 1810680 815   Southeastern School Corp 181068002169 695 Thompson Elementary School   Regular School No 1.0 KG 03 2015   grade_1                         51.0 48.0                       99.0                         51 48                 99
1160455 1160455 IN     school 1806030 875   Logansport Community Sch Corp 180603001056 705 Franklin Elementary School   Regular School No 1.0 KG 05 2015   grade_1                         36.0 38.0                       74.0                         36 38                 74
1160470 1160470 IN     school 1806030 875   Logansport Community Sch Corp 180603002366 711 Landis Elementary School   Regular School No 1.0 KG 05 2015   grade_1                         67.0 60.0                       127.0                         67 60                 127
1160477 1160477 IN     school 1806030 875   Logansport Community Sch Corp 180603001051 713 Columbia Elementary School   Regular School No 1.0 KG 05 2015   grade_1                         37.0 52.0                       89.0                         37 52                 89
1160566 1160566 IN     school 1803940 1010   Greater Clark County Schools 180394000680 761 Thomas Jefferson Elem Sch   Regular School No 1.0 KG 05 2015   grade_1                         32.0 39.0                       71.0                         32 39                 71
1160573 1160573 IN     school 1803940 1010   Greater Clark County Schools 180394000673 801 Northaven Elementary School   Regular School No 1.0 KG 05 2015   grade_1                         38.0 31.0                       69.0                         38 31                 69
1160580 1160580 IN     school 1803940 1010   Greater Clark County Schools 180394000681 805 Utica Elementary School   Regular School No 1.0 KG 05 2015   grade_1                         38.0 35.0                       73.0                         38 35                 73
1160608 1160608 IN     school 1803940 1010   Greater Clark County Schools 180394000667 825 Jonathan Jennings Elem Sch   Regular School No 1.0 KG 05 2015   grade_1                         35.0 39.0                       74.0                         35 39                 74
1160615 1160615 IN     school 1803940 1010   Greater Clark County Schools 180394000676 829 Pleasant Ridge Elem School   Regular School No 1.0 KG 05 2015   grade_1                         41.0 39.0                       80.0                         41 39                 80
1160643 1160643 IN     school 1803940 1010   Greater Clark County Schools 180394000668 869 Maple Elementary School   Regular School No 1.0 KG 05 2015   grade_1                         22.0 17.0                       39.0                         22 17                 39
1160666 1160666 IN     school 1803940 1010   Greater Clark County Schools 180394000675 879 Parkwood Elementary School   Regular School No 1.0 KG 05 2015   grade_1                         66.0 52.0                       118.0                         66 52                 118
1160694 1160694 IN     school 1800840 1125   Clay Community Schools 180084000156 895 Clay City Elementary School   Regular School No 1.0 KG 06 2015   grade_1                         19.0 24.0                       43.0                         19 24                 43
1160709 1160709 IN     school 1800840 1125   Clay Community Schools 180084000160 901 Jackson Township Elem School   Regular School No 1.0 KG 05 2015   grade_1                         28.0 23.0                       51.0                         28 23                 51
1160716 1160716 IN     school 1800840 1125   Clay Community Schools 180084000162 907 Staunton Elementary School   Regular School No 1.0 KG 05 2015   grade_1                         28.0 15.0                       43.0                         28 15                 43
1160723 1160723 IN     school 1800840 1125   Clay Community Schools 180084000164 923 Van Buren Elementary School   Regular School No 1.0 KG 05 2015   grade_1                         18.0 24.0                       42.0                         18 24                 42
1160787 1160787 IN     school 1802160 1160   Clinton Prairie School Corp 180216002245 981 Clinton Prairie Elem School   Regular School No 1.0 KG 06 2015   grade_1                         47.0 42.0                       89.0                         47 42                 89
1160829 1160829 IN     school 1809720 1180   Rossville Con School District 180972001589 1033 Rossville Elementary School   Regular School No 1.0 KG 05 2015   grade_1                         47.0 42.0                       89.0                         47 42                 89
1160897 1160897 IN     school 1800330 1315   Barr-Reeve Com Schools Inc 180033000062 1073 Barr Reeve Primary Grade Sch   Regular School No 1.0 KG 01 2015   grade_1                         32.0 48.0                       80.0                         32 48                 80
1160921 1160921 IN     school 1812450 1405   Washington Com Schools 181245002003 1103 Lena Dunn Elementary School   Regular School No 1.0 KG 06 2015   grade_1                         28.0 40.0                       68.0                         28 40                 68
1160929 1160929 IN     school 1812450 1405   Washington Com Schools 181245002005 1105 Veale Elementary School   Regular School No 1.0 KG 06 2015   grade_1                         16.0 10.0                       26.0                         16 10                 26
1160946 1160946 IN     school 1812450 1405   Washington Com Schools 181245002004 1129 North Elementary School   Regular School No 1.0 KG 06 2015   grade_1                         37.0 28.0                       65.0                         37 28                 65
1160954 1160954 IN     school 1812450 1405   Washington Com Schools 181245002002 1133 Helen Griffith Elementary School   Regular School No 1.0 KG 06 2015   grade_1                         36.0 32.0                       68.0                         36 32                 68
1160975 1160975 IN     school 1811190 1560   Sunman-Dearborn Com Sch Corp 181119000371 1193 Bright Elementary Sch   Regular School No 1.0 KG 04 2015   grade_1                         48.0 44.0                       92.0                         48 44                 92
1160994 1160994 IN     school 1800240 1600   South Dearborn Com School Corp 180024000053 1141 Dillsboro Elementary School   Regular School No 1.0 KG 06 2015   grade_1                         20.0 29.0                       49.0                         20 29                 49
1161002 1161002 IN     school 1800240 1600   South Dearborn Com School Corp 180024000054 1165 Manchester Elementary School   Regular School No 1.0 KG 06 2015   grade_1                         24.0 16.0                       40.0                         24 16                 40
1161010 1161010 IN     school 1800240 1600   South Dearborn Com School Corp 180024000055 1169 Moores Hill Elementary School   Regular School No 1.0 KG 06 2015   grade_1                         17.0 13.0                       30.0                         17 13                 30
1161072 1161072 IN     school 1802610 1655   Decatur County Com Schools 180261000308 1266 North Decatur Elementary Sch   Regular School No 1.0 KG 06 2015   grade_1                         47.0 38.0                       85.0                         47 38                 85
1161112 1161112 IN     school 1803060 1805   DeKalb Co Eastern Com Sch Dist 180306000404 1321 Butler Elementary School   Regular School No 1.0 KG 06 2015   grade_1                         27.0 21.0                       48.0                         27 21                 48
1161120 1161120 IN     school 1803060 1805   DeKalb Co Eastern Com Sch Dist 180306000406 1335 Riverdale Elementary School   Regular School No 1.0 KG 06 2015   grade_1                         25.0 17.0                       42.0                         25 17                 42
1161133 1161133 IN     school 1803840 1820   Garrett-Keyser-Butler Com 180384000606 1329 J E Ober Elementary School   Regular School No 1.0 KG 05 2015   grade_1                         64.0 68.0                       132.0                         64 68                 132
1161144 1161144 IN     school 1801590 1835   DeKalb Co Ctl United Sch Dist 180159000226 1341 Waterloo Elementary School   Regular School No 1.0 KG 05 2015   grade_1                         19.0 13.0                       32.0                         19 13                 32
1161168 1161168 IN     school 1801590 1835   DeKalb Co Ctl United Sch Dist 180159000225 1357 McKenney-Harrison Elem School   Regular School No 1.0 KG 05 2015   grade_1                         38.0 38.0                       76.0                         38 38                 76
1161175 1161175 IN     school 1801590 1835   DeKalb Co Ctl United Sch Dist 180159000847 1359 Country Meadow Elem School   Regular School No 1.0 KG 05 2015   grade_1                         24.0 23.0                       47.0                         24 23                 47
1161182 1161182 IN     school 1802660 1875   Delaware Community School Corp 180266000324 1365 Royerton Elementary School   Regular School No 1.0 KG 05 2015   grade_1                         48.0 56.0                       104.0                         48 56                 104
1161199 1161199 IN     school 1802660 1875   Delaware Community School Corp 180266000322 1409 Eaton Elementary School   Regular School No 1.0 KG 05 2015   grade_1                         26.0 19.0                       45.0                         26 19                 45
1161206 1161206 IN     school 1802660 1875   Delaware Community School Corp 180266000318 1520 Albany Elementary School   Regular School No 1.0 KG 05 2015   grade_1                         22.0 27.0                       49.0                         22 27                 49

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