enrollments

Data source: Big Local News · About: Big Local

1,060 rows where grade = "grade_2", 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_2 · 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
1166234 1166234 IN     school   5375   M S D Wayne Township   5271 Sanders School             2015   grade_2                         2.0 1.0                       3.0                         2 1                 3
1159667 1159667 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No 1.0 01 08 2015   grade_2                         35.0 36.0                       71.0                         35 36                 71
1159708 1159708 IN     school 1803630 235   Fort Wayne Community Schools 180363000570 134 Weisser Park Elem Sch   Regular School No 1.0 01 05 2015   grade_2                         69.0 49.0                       118.0                         69 49                 118
1162135 1162135 IN     school 1807770 2735   North Gibson School Corp 180777001324 2223 Princeton Comm Intermediate School   Regular School No 1.0 01 05 2015   grade_2                         4.0 0.0                       4.0                         4 0                 4
1163265 1163265 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_2                         22.0 24.0                       46.0                         22 24                 46
1163281 1163281 IN     school 1807440 3445   New Castle Community Sch Corp 180744001291 2861 Westwood Elementary School   Regular School No 1.0 01 06 2015   grade_2                         18.0 25.0                       43.0                         18 25                 43
1164699 1164699 IN     school 1802910 4680   Lake Station Community Schools 180291000376 3973 Alexander Hamilton Elementary Sch   Regular School No 1.0 01 06 2015   grade_2                         15.0 33.0                       48.0                         15 33                 48
1164714 1164714 IN     school 1802910 4680   Lake Station Community Schools 180291000377 3985 Carl J Polk Elementary School   Regular School No 1.0 01 06 2015   grade_2                         24.0 17.0                       41.0                         24 17                 41
1165057 1165057 IN     school 1804590 4730   School City of Hobart 180459000777 4325 Ridge View Elementary School   Regular School No 1.0 01 05 2015   grade_2                         40.0 37.0                       77.0                         40 37                 77
1165615 1165615 IN     school 1802640 5300   M S D Decatur Township 180264002111 5178 Gold Academy   Regular School No 1.0 01 06 2015   grade_2                         44.0 44.0                       88.0                         44 44                 88
1165622 1165622 IN     school 1802640 5300   M S D Decatur Township 180264002112 5179 Blue Academy   Regular School No 1.0 01 06 2015   grade_2                         47.0 55.0                       102.0                         47 55                 102
1165632 1165632 IN     school 1802640 5300   M S D Decatur Township 180264000315 5185 Stephen Decatur Elem Sch   Regular School No 1.0 01 06 2015   grade_2                         39.0 42.0                       81.0                         39 42                 81
1165639 1165639 IN     school 1802640 5300   M S D Decatur Township 180264002271 5187 Valley Mills Elementary Sch   Regular School No 1.0 01 06 2015   grade_2                         47.0 39.0                       86.0                         47 39                 86
1165652 1165652 IN     school 1802640 5300   M S D Decatur Township 180264000317 5189 West Newton Elementary School   Regular School No 1.0 01 06 2015   grade_2                         57.0 55.0                       112.0                         57 55                 112
1165733 1165733 IN     school 1805670 5330   M S D Lawrence Township 180567001024 5281 Brook Park Elementary School   Regular School No 1.0 01 06 2015   grade_2                         54.0 61.0                       115.0                         54 61                 115
1165740 1165740 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_2                         66.0 52.0                       118.0                         66 52                 118
1165750 1165750 IN     school 1805670 5330   M S D Lawrence Township 180567001026 5285 Crestview Elementary School   Regular School No 1.0 01 06 2015   grade_2                         50.0 31.0                       81.0                         50 31                 81
1165757 1165757 IN     school 1805670 5330   M S D Lawrence Township 180567002339 5287 Amy Beverland Elementary   Regular School No 1.0 01 06 2015   grade_2                         68.0 47.0                       115.0                         68 47                 115
1165764 1165764 IN     school 1805670 5330   M S D Lawrence Township 180567001027 5289 Harrison Hill Elem Sch   Regular School No 1.0 01 06 2015   grade_2                         56.0 61.0                       117.0                         56 61                 117
1165774 1165774 IN     school 1805670 5330   M S D Lawrence Township 180567002278 5293 Indian Creek Elem Sch   Regular School No 1.0 01 06 2015   grade_2                         70.0 53.0                       123.0                         70 53                 123
1165789 1165789 IN     school 1805670 5330   M S D Lawrence Township 180567002114 5295 Winding Ridge Elementary School   Regular School No 1.0 01 06 2015   grade_2                         46.0 52.0                       98.0                         46 52                 98
1165796 1165796 IN     school 1805670 5330   M S D Lawrence Township 180567001033 5296 Oaklandon Elementary School   Regular School No 1.0 01 06 2015   grade_2                         43.0 49.0                       92.0                         43 49                 92
1165803 1165803 IN     school 1805670 5330   M S D Lawrence Township 180567001034 5298 Skiles Test Elementary School   Regular School No 1.0 01 06 2015   grade_2                         48.0 40.0                       88.0                         48 40                 88
1165810 1165810 IN     school 1805670 5330   M S D Lawrence Township 180567001066 5299 Sunnyside Elementary Sch   Regular School No 1.0 01 06 2015   grade_2                         49.0 55.0                       104.0                         49 55                 104
1166084 1166084 IN     school 1812720 5370   M S D Washington Township 181272002010 5403 Allisonville Elementary Sch   Regular School No 1.0 01 05 2015   grade_2                         68.0 76.0                       144.0                         68 76                 144
1159489 1159489 IN     school 1807680 25   North Adams Community Schools 180768001316 37 Northwest Elementary   Regular School No 1.0 02 04 2015   grade_2                         54.0 59.0                       113.0                         54 59                 113
1160514 1160514 IN     school 1809370 940   West Clark Community Schools 180937001538 789 Silver Creek Elementary School   Regular School No 1.0 02 05 2015   grade_2                         103.0 100.0                       203.0                         103 100                 203
1160900 1160900 IN     school 1800330 1315   Barr-Reeve Com Schools Inc 180033000060 1075 Barr Reeve Elementary School   Regular School No 1.0 02 05 2015   grade_2                         38.0 31.0                       69.0                         38 31                 69
1162253 1162253 IN     school 1806870 2855   Mississinewa Community School Corp 180687001191 2346 Northview Elementary School   Regular School No 1.0 02 05 2015   grade_2                         101.0 95.0                       196.0                         101 95                 196
1163385 1163385 IN     school 1804470 3490   Western School Corp 180447002224 2923 Western Intermediate School   Regular School No 1.0 02 05 2015   grade_2                         3.0 1.0                       4.0                         3 1                 4
1163873 1163873 IN     school 1801890 4145   Clark-Pleasant Com School Corp 180189000243 3429 Break-O-Day Elementary School   Regular School No 1.0 02 04 2015   grade_2                         78.0 84.0                       162.0                         78 84                 162
1166285 1166285 IN     school 1800450 5380   Beech Grove City Schools 180045000094 5457 Central Elementary School   Regular School No 1.0 02 03 2015   grade_2                         124.0 119.0                       243.0                         124 119                 243
1166582 1166582 IN     school 1804770 5385   Indianapolis Public Schools 180477002439 5577 Merle Sidener Gifted Academy   Regular School No 1.0 02 08 2015   grade_2                         26.0 22.0                       48.0                         26 22                 48
1167012 1167012 IN     school 1806090 5615   Maconaquah School Corp 180609001077 6035 Maconaquah Elementary School   Regular School No 1.0 02 05 2015   grade_2                         100.0 88.0                       188.0                         100 88                 188
1167331 1167331 IN     school 1802460 5855   Crawfordsville Com Schools 180246000291 6301 Meredith Nicholson Elem Sch   Regular School No 1.0 02 03 2015   grade_2                         87.0 101.0                       188.0                         87 101                 188
1167629 1167629 IN     school 1812900 6065   West Noble School Corporation 181290002231 6510 West Noble Elementary School   Regular School No 1.0 02 04 2015   grade_2                         105.0 93.0                       198.0                         105 93                 198
1159467 1159467 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary Sch   Regular School No 1.0 KG 05 2015   grade_2                         50.0 50.0                       100.0                         50 50                 100
1159516 1159516 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_2                         55.0 42.0                       97.0                         55 42                 97
1159540 1159540 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_2                         44.0 37.0                       81.0                         44 37                 81
1159551 1159551 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_2                         26.0 28.0                       54.0                         26 28                 54
1159558 1159558 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_2                         39.0 41.0                       80.0                         39 41                 80
1159565 1159565 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_2                         58.0 59.0                       117.0                         58 59                 117
1159572 1159572 IN     school 1808250 225   Northwest Allen County Schools 180825001413 69 Arcola School   Regular School No 1.0 KG 05 2015   grade_2                         14.0 18.0                       32.0                         14 18                 32
1159583 1159583 IN     school 1808250 225   Northwest Allen County Schools 180825000937 87 Hickory Center Elementary Sch   Regular School No 1.0 KG 05 2015   grade_2                         27.0 37.0                       64.0                         27 37                 64
1159590 1159590 IN     school 1808250 225   Northwest Allen County Schools 180825001415 89 Huntertown Elementary School   Regular School No 1.0 KG 05 2015   grade_2                         58.0 42.0                       100.0                         58 42                 100
1159606 1159606 IN     school 1808250 225   Northwest Allen County Schools 180825001416 92 Perry Hill Elementary School   Regular School No 1.0 KG 05 2015   grade_2                         37.0 36.0                       73.0                         37 36                 73
1159613 1159613 IN     school 1808250 225   Northwest Allen County Schools 180825000016 94 Oak View Elementary Sch   Regular School No 1.0 KG 05 2015   grade_2                         37.0 33.0                       70.0                         37 33                 70
1159628 1159628 IN     school 1808250 225   Northwest Allen County Schools 180825002457 96 Eel River Elementary School   Regular School No 1.0 KG 05 2015   grade_2                         48.0 41.0                       89.0                         48 41                 89
1159757 1159757 IN     school 1803630 235   Fort Wayne Community Schools 180363000527 154 Fred H Croninger Elem Sch   Regular School No 1.0 KG 05 2015   grade_2                         48.0 53.0                       101.0                         48 53                 101
1159780 1159780 IN     school 1803630 235   Fort Wayne Community Schools 180363000529 162 Glenwood Park Elementary Sch   Regular School No 1.0 KG 05 2015   grade_2                         56.0 50.0                       106.0                         56 50                 106
1159824 1159824 IN     school 1803630 235   Fort Wayne Community Schools 180363000535 193 John S Irwin Elementary Sch   Regular School No 1.0 KG 05 2015   grade_2                         25.0 27.0                       52.0                         25 27                 52
1159847 1159847 IN     school 1803630 235   Fort Wayne Community Schools 180363000572 209 Willard Shambaugh Elem Sch   Regular School No 1.0 KG 05 2015   grade_2                         28.0 36.0                       64.0                         28 36                 64
1159883 1159883 IN     school 1803630 235   Fort Wayne Community Schools 180363000559 233 Saint Joseph Central School   Regular School No 1.0 KG 05 2015   grade_2                         39.0 38.0                       77.0                         39 38                 77
1159890 1159890 IN     school 1803630 235   Fort Wayne Community Schools 180363000558 239 Robert C Harris Elem Sch   Regular School No 1.0 KG 05 2015   grade_2                         41.0 38.0                       79.0                         41 38                 79
1159944 1159944 IN     school 1803630 235   Fort Wayne Community Schools 180363000540 270 Lincoln Elementary School   Regular School No 1.0 KG 05 2015   grade_2                         73.0 64.0                       137.0                         73 64                 137
1159951 1159951 IN     school 1803630 235   Fort Wayne Community Schools 180363000569 273 Waynedale Elementary School   Regular School No 1.0 KG 05 2015   grade_2                         29.0 45.0                       74.0                         29 45                 74
1159958 1159958 IN     school 1803630 235   Fort Wayne Community Schools 180363000514 275 Arlington Elementary School   Regular School No 1.0 KG 05 2015   grade_2                         32.0 45.0                       77.0                         32 45                 77
1159994 1159994 IN     school 1802850 255   East Allen County Schools 180285000346 281 Heritage Elementary School   Regular School No 1.0 KG 06 2015   grade_2                         27.0 23.0                       50.0                         27 23                 50
1160009 1160009 IN     school 1802850 255   East Allen County Schools 180285000954 291 Cedarville Elementary Sch   Regular School No 1.0 KG 03 2015   grade_2                         82.0 80.0                       162.0                         82 80                 162
1160038 1160038 IN     school 1802850 255   East Allen County Schools 180285002514 323 Woodlan Elementary School   Regular School No 1.0 KG 06 2015   grade_2                         43.0 36.0                       79.0                         43 36                 79
1160059 1160059 IN     school 1800360 365   Bartholomew Con School Corp 180036002421 346 CSA Lincoln Campus   Regular School No 1.0 KG 06 2015   grade_2                         21.0 30.0                       51.0                         21 30                 51
1160105 1160105 IN     school 1800360 365   Bartholomew Con School Corp 180036000071 369 Lillian Schmitt Elem School   Regular School No 1.0 KG 06 2015   grade_2                         55.0 52.0                       107.0                         55 52                 107
1160165 1160165 IN     school 1803570 370   Flat Rock-Hawcreek School Corp 180357000510 409 Hope Elementary School   Regular School No 1.0 KG 06 2015   grade_2                         42.0 32.0                       74.0                         42 32                 74
1160180 1160180 IN     school 1800480 395   Benton Community School Corp 180048000100 421 Otterbein Elementary School   Regular School No 1.0 KG 06 2015   grade_2                         26.0 16.0                       42.0                         26 16                 42
1160188 1160188 IN     school 1800480 395   Benton Community School Corp 180048000098 433 Boswell Elementary School   Regular School No 1.0 KG 06 2015   grade_2                         11.0 8.0                       19.0                         11 8                 19
1160203 1160203 IN     school 1800480 395   Benton Community School Corp 180048002403 446 Prairie Crossing Elementary Sch   Regular School No 1.0 KG 06 2015   grade_2                         33.0 33.0                       66.0                         33 33                 66
1160211 1160211 IN     school 1800570 515   Blackford County Schools 180057000107 485 Montpelier School   Regular School No 1.0 KG 06 2015   grade_2                         17.0 14.0                       31.0                         17 14                 31
1160231 1160231 IN     school 1800570 515   Blackford County Schools 180057000126 501 Southside Elementary School   Regular School No 1.0 KG 03 2015   grade_2                         53.0 48.0                       101.0                         53 48                 101
1160278 1160278 IN     school 1802830 630   Zionsville Community Schools 180283001219 514 Eagle Elementary School   Regular School No 1.0 KG 04 2015   grade_2                         38.0 34.0                       72.0                         38 34                 72
1160298 1160298 IN     school 1802830 630   Zionsville Community Schools 180283001854 542 Stonegate Elementary   Regular School No 1.0 KG 04 2015   grade_2                         45.0 59.0                       104.0                         45 59                 104
1160311 1160311 IN     school 1805790 665   Lebanon Community School Corp 180579001042 534 Perry Worth Elementary School   Regular School No 1.0 KG 05 2015   grade_2                         25.0 38.0                       63.0                         25 38                 63
1160327 1160327 IN     school 1805790 665   Lebanon Community School Corp 180579001038 561 Central Elementary School   Regular School No 1.0 KG 05 2015   grade_2                         38.0 26.0                       64.0                         38 26                 64
1160334 1160334 IN     school 1805790 665   Lebanon Community School Corp 180579001039 565 Harney Elementary School   Regular School No 1.0 KG 05 2015   grade_2                         47.0 49.0                       96.0                         47 49                 96
1160341 1160341 IN     school 1805790 665   Lebanon Community School Corp 180579001043 569 Hattie B Stokes Elementary School   Regular School No 1.0 KG 05 2015   grade_2                         45.0 38.0                       83.0                         45 38                 83
1160423 1160423 IN     school 1808940 775   Pioneer Regional School Corp 180894001490 649 Pioneer Elementary School   Regular School No 1.0 KG 06 2015   grade_2                         44.0 32.0                       76.0                         44 32                 76
1160442 1160442 IN     school 1810680 815   Southeastern School Corp 181068002169 695 Thompson Elementary School   Regular School No 1.0 KG 03 2015   grade_2                         49.0 42.0                       91.0                         49 42                 91
1160456 1160456 IN     school 1806030 875   Logansport Community Sch Corp 180603001056 705 Franklin Elementary School   Regular School No 1.0 KG 05 2015   grade_2                         41.0 24.0                       65.0                         41 24                 65
1160471 1160471 IN     school 1806030 875   Logansport Community Sch Corp 180603002366 711 Landis Elementary School   Regular School No 1.0 KG 05 2015   grade_2                         63.0 56.0                       119.0                         63 56                 119
1160478 1160478 IN     school 1806030 875   Logansport Community Sch Corp 180603001051 713 Columbia Elementary School   Regular School No 1.0 KG 05 2015   grade_2                         43.0 30.0                       73.0                         43 30                 73
1160567 1160567 IN     school 1803940 1010   Greater Clark County Schools 180394000680 761 Thomas Jefferson Elem Sch   Regular School No 1.0 KG 05 2015   grade_2                         27.0 35.0                       62.0                         27 35                 62
1160574 1160574 IN     school 1803940 1010   Greater Clark County Schools 180394000673 801 Northaven Elementary School   Regular School No 1.0 KG 05 2015   grade_2                         36.0 40.0                       76.0                         36 40                 76
1160581 1160581 IN     school 1803940 1010   Greater Clark County Schools 180394000681 805 Utica Elementary School   Regular School No 1.0 KG 05 2015   grade_2                         49.0 39.0                       88.0                         49 39                 88
1160609 1160609 IN     school 1803940 1010   Greater Clark County Schools 180394000667 825 Jonathan Jennings Elem Sch   Regular School No 1.0 KG 05 2015   grade_2                         44.0 37.0                       81.0                         44 37                 81
1160616 1160616 IN     school 1803940 1010   Greater Clark County Schools 180394000676 829 Pleasant Ridge Elem School   Regular School No 1.0 KG 05 2015   grade_2                         38.0 42.0                       80.0                         38 42                 80
1160644 1160644 IN     school 1803940 1010   Greater Clark County Schools 180394000668 869 Maple Elementary School   Regular School No 1.0 KG 05 2015   grade_2                         24.0 21.0                       45.0                         24 21                 45
1160667 1160667 IN     school 1803940 1010   Greater Clark County Schools 180394000675 879 Parkwood Elementary School   Regular School No 1.0 KG 05 2015   grade_2                         40.0 47.0                       87.0                         40 47                 87
1160695 1160695 IN     school 1800840 1125   Clay Community Schools 180084000156 895 Clay City Elementary School   Regular School No 1.0 KG 06 2015   grade_2                         31.0 23.0                       54.0                         31 23                 54
1160710 1160710 IN     school 1800840 1125   Clay Community Schools 180084000160 901 Jackson Township Elem School   Regular School No 1.0 KG 05 2015   grade_2                         22.0 27.0                       49.0                         22 27                 49
1160717 1160717 IN     school 1800840 1125   Clay Community Schools 180084000162 907 Staunton Elementary School   Regular School No 1.0 KG 05 2015   grade_2                         30.0 15.0                       45.0                         30 15                 45
1160724 1160724 IN     school 1800840 1125   Clay Community Schools 180084000164 923 Van Buren Elementary School   Regular School No 1.0 KG 05 2015   grade_2                         31.0 15.0                       46.0                         31 15                 46
1160788 1160788 IN     school 1802160 1160   Clinton Prairie School Corp 180216002245 981 Clinton Prairie Elem School   Regular School No 1.0 KG 06 2015   grade_2                         48.0 42.0                       90.0                         48 42                 90
1160830 1160830 IN     school 1809720 1180   Rossville Con School District 180972001589 1033 Rossville Elementary School   Regular School No 1.0 KG 05 2015   grade_2                         35.0 27.0                       62.0                         35 27                 62
1160922 1160922 IN     school 1812450 1405   Washington Com Schools 181245002003 1103 Lena Dunn Elementary School   Regular School No 1.0 KG 06 2015   grade_2                         37.0 34.0                       71.0                         37 34                 71
1160930 1160930 IN     school 1812450 1405   Washington Com Schools 181245002005 1105 Veale Elementary School   Regular School No 1.0 KG 06 2015   grade_2                         13.0 12.0                       25.0                         13 12                 25
1160947 1160947 IN     school 1812450 1405   Washington Com Schools 181245002004 1129 North Elementary School   Regular School No 1.0 KG 06 2015   grade_2                         28.0 25.0                       53.0                         28 25                 53
1160955 1160955 IN     school 1812450 1405   Washington Com Schools 181245002002 1133 Helen Griffith Elementary School   Regular School No 1.0 KG 06 2015   grade_2                         35.0 33.0                       68.0                         35 33                 68
1160976 1160976 IN     school 1811190 1560   Sunman-Dearborn Com Sch Corp 181119000371 1193 Bright Elementary Sch   Regular School No 1.0 KG 04 2015   grade_2                         45.0 41.0                       86.0                         45 41                 86
1160995 1160995 IN     school 1800240 1600   South Dearborn Com School Corp 180024000053 1141 Dillsboro Elementary School   Regular School No 1.0 KG 06 2015   grade_2                         16.0 10.0                       26.0                         16 10                 26
1161003 1161003 IN     school 1800240 1600   South Dearborn Com School Corp 180024000054 1165 Manchester Elementary School   Regular School No 1.0 KG 06 2015   grade_2                         18.0 21.0                       39.0                         18 21                 39
1161011 1161011 IN     school 1800240 1600   South Dearborn Com School Corp 180024000055 1169 Moores Hill Elementary School   Regular School No 1.0 KG 06 2015   grade_2                         8.0 9.0                       17.0                         8 9                 17

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