Data source: Big Local News · About: Big Local

12,044 rows where state = "IN" and year = 2015 sorted by ccd_school_lvl descending

View and edit SQL

grade

year

  • 2015 · 12,044
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
1159634 IN     school 1808250 225   Northwest Allen County Schools 180825002160 145 Allen Co Youth Services Ctr   Alternative Education School No 4.0 04 11 2015   grade_10                         3.0 0.0                       3.0                         3 0                 3
1159635 IN     school 1808250 225   Northwest Allen County Schools 180825002160 145 Allen Co Youth Services Ctr   Alternative Education School No 4.0 04 11 2015   grade_11                         2.0 2.0                       4.0                         2 2                 4
1159636 IN     school 1808250 225   Northwest Allen County Schools 180825002160 145 Allen Co Youth Services Ctr   Alternative Education School No 4.0 04 11 2015   grade_4                         2.0 0.0                       2.0                         2 0                 2
1159637 IN     school 1808250 225   Northwest Allen County Schools 180825002160 145 Allen Co Youth Services Ctr   Alternative Education School No 4.0 04 11 2015   grade_6                         2.0 0.0                       2.0                         2 0                 2
1159638 IN     school 1808250 225   Northwest Allen County Schools 180825002160 145 Allen Co Youth Services Ctr   Alternative Education School No 4.0 04 11 2015   grade_9                         0.0 1.0                       1.0                         0 1                 1
1159639 IN     school 1808250 225   Northwest Allen County Schools 180825002160 145 Allen Co Youth Services Ctr   Alternative Education School No 4.0 04 11 2015   pk_12_total 8.0 1.0 1.0               2.0   9.0 3.0     0.0             5.0   12.0 8 1 1               2   9 3     0       5   12
1160045 IN     school 1802850 255   East Allen County Schools 180285002532 394 East Allen University   Regular School No 4.0 09 11 2015   grade_10                         41.0 48.0                       89.0                         41 48                 89
1160046 IN     school 1802850 255   East Allen County Schools 180285002532 394 East Allen University   Regular School No 4.0 09 11 2015   grade_11                         28.0 58.0                       86.0                         28 58                 86
1160047 IN     school 1802850 255   East Allen County Schools 180285002532 394 East Allen University   Regular School No 4.0 09 11 2015   grade_9                         22.0 61.0                       83.0                         22 61                 83
1160048 IN     school 1802850 255   East Allen County Schools 180285002532 394 East Allen University   Regular School No 4.0 09 11 2015   pk_12_total 145.0 43.0 30.0     21.0         19.0   91.0 167.0     11.0             4.0   258.0 145 43 30     21         19   91 167     11       4   258
1160595 IN     school 1803940 1010   Greater Clark County Schools 180394000672 809 New Washington Middle/High School   Regular School No 4.0 06 12 2015   grade_10                         33.0 34.0                       67.0                         33 34                 67
1160596 IN     school 1803940 1010   Greater Clark County Schools 180394000672 809 New Washington Middle/High School   Regular School No 4.0 06 12 2015   grade_11                         33.0 27.0                       60.0                         33 27                 60
1160597 IN     school 1803940 1010   Greater Clark County Schools 180394000672 809 New Washington Middle/High School   Regular School No 4.0 06 12 2015   grade_12                         35.0 30.0                       65.0                         35 30                 65
1160598 IN     school 1803940 1010   Greater Clark County Schools 180394000672 809 New Washington Middle/High School   Regular School No 4.0 06 12 2015   grade_6                         18.0 27.0                       45.0                         18 27                 45
1160599 IN     school 1803940 1010   Greater Clark County Schools 180394000672 809 New Washington Middle/High School   Regular School No 4.0 06 12 2015   grade_7                         26.0 28.0                       54.0                         26 28                 54
1160600 IN     school 1803940 1010   Greater Clark County Schools 180394000672 809 New Washington Middle/High School   Regular School No 4.0 06 12 2015   grade_8                         38.0 37.0                       75.0                         38 37                 75
1160601 IN     school 1803940 1010   Greater Clark County Schools 180394000672 809 New Washington Middle/High School   Regular School No 4.0 06 12 2015   grade_9                         22.0 36.0                       58.0                         22 36                 58
1160602 IN     school 1803940 1010   Greater Clark County Schools 180394000672 809 New Washington Middle/High School   Regular School No 4.0 06 12 2015   pk_12_total 411.0   7.0     1.0         5.0   205.0 219.0     0.0             66.0   424.0 411   7     1         5   205 219     0       66   424
1160677 IN     school 1803940 1010   Greater Clark County Schools 180394000832 886 Old Corden Porter School   Special Education School No 4.0 04 12 2015   grade_10                         11.0 1.0                       12.0                         11 1                 12
1160678 IN     school 1803940 1010   Greater Clark County Schools 180394000832 886 Old Corden Porter School   Special Education School No 4.0 04 12 2015   grade_11                         10.0 1.0                       11.0                         10 1                 11
1160679 IN     school 1803940 1010   Greater Clark County Schools 180394000832 886 Old Corden Porter School   Special Education School No 4.0 04 12 2015   grade_12                         4.0 0.0                       4.0                         4 0                 4
1160680 IN     school 1803940 1010   Greater Clark County Schools 180394000832 886 Old Corden Porter School   Special Education School No 4.0 04 12 2015   grade_4                         1.0 0.0                       1.0                         1 0                 1
1160681 IN     school 1803940 1010   Greater Clark County Schools 180394000832 886 Old Corden Porter School   Special Education School No 4.0 04 12 2015   grade_5                         3.0 0.0                       3.0                         3 0                 3
1160682 IN     school 1803940 1010   Greater Clark County Schools 180394000832 886 Old Corden Porter School   Special Education School No 4.0 04 12 2015   grade_6                         3.0 1.0                       4.0                         3 1                 4
1160683 IN     school 1803940 1010   Greater Clark County Schools 180394000832 886 Old Corden Porter School   Special Education School No 4.0 04 12 2015   grade_7                         10.0 0.0                       10.0                         10 0                 10
1160684 IN     school 1803940 1010   Greater Clark County Schools 180394000832 886 Old Corden Porter School   Special Education School No 4.0 04 12 2015   grade_8                         8.0 0.0                       8.0                         8 0                 8
1160685 IN     school 1803940 1010   Greater Clark County Schools 180394000832 886 Old Corden Porter School   Special Education School No 4.0 04 12 2015   grade_9                         4.0 0.0                       4.0                         4 0                 4
1160686 IN     school 1803940 1010   Greater Clark County Schools 180394000832 886 Old Corden Porter School   Special Education School No 4.0 04 12 2015   pk_12_total 39.0 6.0 2.0               10.0   54.0 3.0     0.0             54.0   57.0 39 6 2               10   54 3     0       54   57
1160821 IN     school 1809720 1180   Rossville Con School District 180972001590 1021 Rossville Middle/Senior High Sch   Regular School No 4.0 06 12 2015   grade_10                         45.0 40.0                       85.0                         45 40                 85
1160822 IN     school 1809720 1180   Rossville Con School District 180972001590 1021 Rossville Middle/Senior High Sch   Regular School No 4.0 06 12 2015   grade_11                         40.0 38.0                       78.0                         40 38                 78
1160823 IN     school 1809720 1180   Rossville Con School District 180972001590 1021 Rossville Middle/Senior High Sch   Regular School No 4.0 06 12 2015   grade_12                         36.0 41.0                       77.0                         36 41                 77
1160824 IN     school 1809720 1180   Rossville Con School District 180972001590 1021 Rossville Middle/Senior High Sch   Regular School No 4.0 06 12 2015   grade_6                         51.0 41.0                       92.0                         51 41                 92
1160825 IN     school 1809720 1180   Rossville Con School District 180972001590 1021 Rossville Middle/Senior High Sch   Regular School No 4.0 06 12 2015   grade_7                         41.0 44.0                       85.0                         41 44                 85
1160826 IN     school 1809720 1180   Rossville Con School District 180972001590 1021 Rossville Middle/Senior High Sch   Regular School No 4.0 06 12 2015   grade_8                         35.0 47.0                       82.0                         35 47                 82
1160827 IN     school 1809720 1180   Rossville Con School District 180972001590 1021 Rossville Middle/Senior High Sch   Regular School No 4.0 06 12 2015   grade_9                         32.0 49.0                       81.0                         32 49                 81
1160828 IN     school 1809720 1180   Rossville Con School District 180972001590 1021 Rossville Middle/Senior High Sch   Regular School No 4.0 06 12 2015   pk_12_total 549.0 5.0 11.0     5.0         10.0   280.0 300.0     6.0             56.0   580.0 549 5 11     5         10   280 300     6       56   580
1160889 IN     school 1800330 1315   Barr-Reeve Com Schools Inc 180033000061 1069 Barr Reeve Middle/High School   Regular School No 4.0 06 12 2015   grade_10                         31.0 25.0                       56.0                         31 25                 56
1160890 IN     school 1800330 1315   Barr-Reeve Com Schools Inc 180033000061 1069 Barr Reeve Middle/High School   Regular School No 4.0 06 12 2015   grade_11                         30.0 19.0                       49.0                         30 19                 49
1160891 IN     school 1800330 1315   Barr-Reeve Com Schools Inc 180033000061 1069 Barr Reeve Middle/High School   Regular School No 4.0 06 12 2015   grade_12                         26.0 28.0                       54.0                         26 28                 54
1160892 IN     school 1800330 1315   Barr-Reeve Com Schools Inc 180033000061 1069 Barr Reeve Middle/High School   Regular School No 4.0 06 12 2015   grade_6                         29.0 35.0                       64.0                         29 35                 64
1160893 IN     school 1800330 1315   Barr-Reeve Com Schools Inc 180033000061 1069 Barr Reeve Middle/High School   Regular School No 4.0 06 12 2015   grade_7                         35.0 22.0                       57.0                         35 22                 57
1160894 IN     school 1800330 1315   Barr-Reeve Com Schools Inc 180033000061 1069 Barr Reeve Middle/High School   Regular School No 4.0 06 12 2015   grade_8                         33.0 27.0                       60.0                         33 27                 60
1160895 IN     school 1800330 1315   Barr-Reeve Com Schools Inc 180033000061 1069 Barr Reeve Middle/High School   Regular School No 4.0 06 12 2015   grade_9                         22.0 19.0                       41.0                         22 19                 41
1160896 IN     school 1800330 1315   Barr-Reeve Com Schools Inc 180033000061 1069 Barr Reeve Middle/High School   Regular School No 4.0 06 12 2015   pk_12_total 373.0 1.0       5.0         2.0   206.0 175.0     0.0             42.0   381.0 373 1       5         2   206 175     0       42   381
1161213 IN     school 1804500 1885   Wes-Del Community Schools 180450000761 1372 Wes-Del Middle/Senior High Sch   Regular School No 4.0 06 12 2015   grade_10                         39.0 29.0                       68.0                         39 29                 68
1161214 IN     school 1804500 1885   Wes-Del Community Schools 180450000761 1372 Wes-Del Middle/Senior High Sch   Regular School No 4.0 06 12 2015   grade_11                         40.0 44.0                       84.0                         40 44                 84
1161215 IN     school 1804500 1885   Wes-Del Community Schools 180450000761 1372 Wes-Del Middle/Senior High Sch   Regular School No 4.0 06 12 2015   grade_12                         33.0 34.0                       67.0                         33 34                 67
1161216 IN     school 1804500 1885   Wes-Del Community Schools 180450000761 1372 Wes-Del Middle/Senior High Sch   Regular School No 4.0 06 12 2015   grade_6                         35.0 25.0                       60.0                         35 25                 60
1161217 IN     school 1804500 1885   Wes-Del Community Schools 180450000761 1372 Wes-Del Middle/Senior High Sch   Regular School No 4.0 06 12 2015   grade_7                         33.0 34.0                       67.0                         33 34                 67
1161218 IN     school 1804500 1885   Wes-Del Community Schools 180450000761 1372 Wes-Del Middle/Senior High Sch   Regular School No 4.0 06 12 2015   grade_8                         32.0 33.0                       65.0                         32 33                 65
1161219 IN     school 1804500 1885   Wes-Del Community Schools 180450000761 1372 Wes-Del Middle/Senior High Sch   Regular School No 4.0 06 12 2015   grade_9                         46.0 32.0                       78.0                         46 32                 78
1161220 IN     school 1804500 1885   Wes-Del Community Schools 180450000761 1372 Wes-Del Middle/Senior High Sch   Regular School No 4.0 06 12 2015   pk_12_total 456.0   13.0 1.0   2.0         17.0   258.0 231.0     0.0             47.0   489.0 456   13 1   2         17   258 231     0       47   489
1161368 IN     school 1807320 1970   Muncie Community Schools 180732001232 1524 Youth Opportunity Center   Alternative Education School No 4.0 03 12 2015   grade_10                         13.0 9.0                       22.0                         13 9                 22
1161369 IN     school 1807320 1970   Muncie Community Schools 180732001232 1524 Youth Opportunity Center   Alternative Education School No 4.0 03 12 2015   grade_11                         6.0 5.0                       11.0                         6 5                 11
1161370 IN     school 1807320 1970   Muncie Community Schools 180732001232 1524 Youth Opportunity Center   Alternative Education School No 4.0 03 12 2015   grade_12                         2.0 2.0                       4.0                         2 2                 4
1161371 IN     school 1807320 1970   Muncie Community Schools 180732001232 1524 Youth Opportunity Center   Alternative Education School No 4.0 03 12 2015   grade_3                         0.0 1.0                       1.0                         0 1                 1
1161372 IN     school 1807320 1970   Muncie Community Schools 180732001232 1524 Youth Opportunity Center   Alternative Education School No 4.0 03 12 2015   grade_4                         2.0 0.0                       2.0                         2 0                 2
1161373 IN     school 1807320 1970   Muncie Community Schools 180732001232 1524 Youth Opportunity Center   Alternative Education School No 4.0 03 12 2015   grade_5                         6.0 1.0                       7.0                         6 1                 7
1161374 IN     school 1807320 1970   Muncie Community Schools 180732001232 1524 Youth Opportunity Center   Alternative Education School No 4.0 03 12 2015   grade_6                         7.0 2.0                       9.0                         7 2                 9
1161375 IN     school 1807320 1970   Muncie Community Schools 180732001232 1524 Youth Opportunity Center   Alternative Education School No 4.0 03 12 2015   grade_7                         3.0 2.0                       5.0                         3 2                 5
1161376 IN     school 1807320 1970   Muncie Community Schools 180732001232 1524 Youth Opportunity Center   Alternative Education School No 4.0 03 12 2015   grade_8                         14.0 4.0                       18.0                         14 4                 18
1161377 IN     school 1807320 1970   Muncie Community Schools 180732001232 1524 Youth Opportunity Center   Alternative Education School No 4.0 03 12 2015   grade_9                         18.0 10.0                       28.0                         18 10                 28
1161378 IN     school 1807320 1970   Muncie Community Schools 180732001232 1524 Youth Opportunity Center   Alternative Education School No 4.0 03 12 2015   pk_12_total 70.0 20.0 6.0 1.0   1.0         9.0   71.0 36.0     3.0             53.0   107.0 70 20 6 1   1         9   71 36     3       53   107
1161527 IN     school 1802400 2270   Concord Community Schools 180240000271 1713 Concord Junior High School   Regular School No 4.0 06 12 2015   adult                         0.0 1.0                       1.0                         0 1                 1
1161528 IN     school 1802400 2270   Concord Community Schools 180240000271 1713 Concord Junior High School   Regular School No 4.0 06 12 2015   grade_6                         1.0 1.0                       2.0                         1 1                 2
1161529 IN     school 1802400 2270   Concord Community Schools 180240000271 1713 Concord Junior High School   Regular School No 4.0 06 12 2015   grade_7                         193.0 184.0                       377.0                         193 184                 377
1161530 IN     school 1802400 2270   Concord Community Schools 180240000271 1713 Concord Junior High School   Regular School No 4.0 06 12 2015   grade_8                         218.0 233.0                       451.0                         218 233                 451
1161531 IN     school 1802400 2270   Concord Community Schools 180240000271 1713 Concord Junior High School   Regular School No 4.0 06 12 2015   grade_9                         0.0 2.0                       2.0                         0 2                 2
1161532 IN     school 1802400 2270   Concord Community Schools 180240000271 1713 Concord Junior High School   Regular School No 4.0 06 12 2015   pk_12_total 435.0 68.0 257.0     12.0         61.0   412.0 421.0     163.0             100.0   833.0 435 68 257     12         61   412 421     163       100   833
1161777 IN     school 1803930 2315   Goshen Community Schools 180393000659 1629 Goshen Middle School   Regular School No 4.0 06 10 2015   grade_10                         1.0 0.0                       1.0                         1 0                 1
1161778 IN     school 1803930 2315   Goshen Community Schools 180393000659 1629 Goshen Middle School   Regular School No 4.0 06 10 2015   grade_6                         261.0 222.0                       483.0                         261 222                 483
1161779 IN     school 1803930 2315   Goshen Community Schools 180393000659 1629 Goshen Middle School   Regular School No 4.0 06 10 2015   grade_7                         238.0 248.0                       486.0                         238 248                 486
1161780 IN     school 1803930 2315   Goshen Community Schools 180393000659 1629 Goshen Middle School   Regular School No 4.0 06 10 2015   grade_8                         273.0 240.0                       513.0                         273 240                 513
1161781 IN     school 1803930 2315   Goshen Community Schools 180393000659 1629 Goshen Middle School   Regular School No 4.0 06 10 2015   grade_9                         0.0 2.0                       2.0                         0 2                 2
1161782 IN     school 1803930 2315   Goshen Community Schools 180393000659 1629 Goshen Middle School   Regular School No 4.0 06 10 2015   pk_12_total 648.0 31.0 738.0 4.0   21.0         43.0   773.0 712.0     417.0             171.0   1485.0 648 31 738 4   21         43   773 712     417       171   1485
1162949 IN     school 1810360 3190   South Harrison Com Schools 181036002285 2670 South Central Jr & Sr HS   Regular School No 4.0 06 12 2015   grade_10                         26.0 30.0                       56.0                         26 30                 56
1162950 IN     school 1810360 3190   South Harrison Com Schools 181036002285 2670 South Central Jr & Sr HS   Regular School No 4.0 06 12 2015   grade_11                         21.0 23.0                       44.0                         21 23                 44
1162951 IN     school 1810360 3190   South Harrison Com Schools 181036002285 2670 South Central Jr & Sr HS   Regular School No 4.0 06 12 2015   grade_12                         36.0 20.0                       56.0                         36 20                 56
1162952 IN     school 1810360 3190   South Harrison Com Schools 181036002285 2670 South Central Jr & Sr HS   Regular School No 4.0 06 12 2015   grade_6                         28.0 28.0                       56.0                         28 28                 56
1162953 IN     school 1810360 3190   South Harrison Com Schools 181036002285 2670 South Central Jr & Sr HS   Regular School No 4.0 06 12 2015   grade_7                         31.0 34.0                       65.0                         31 34                 65
1162954 IN     school 1810360 3190   South Harrison Com Schools 181036002285 2670 South Central Jr & Sr HS   Regular School No 4.0 06 12 2015   grade_8                         28.0 20.0                       48.0                         28 20                 48
1162955 IN     school 1810360 3190   South Harrison Com Schools 181036002285 2670 South Central Jr & Sr HS   Regular School No 4.0 06 12 2015   grade_9                         25.0 32.0                       57.0                         25 32                 57
1162956 IN     school 1810360 3190   South Harrison Com Schools 181036002285 2670 South Central Jr & Sr HS   Regular School No 4.0 06 12 2015   pk_12_total 365.0 1.0 4.0     2.0         10.0   195.0 187.0     0.0             49.0   382.0 365 1 4     2         10   195 187     0       49   382
1163370 IN     school 1804470 3490   Western School Corp 180447000756 2921 Western High School   Regular School No 4.0 04 12 2015   adult                         4.0 0.0                       4.0                         4 0                 4
1163371 IN     school 1804470 3490   Western School Corp 180447000756 2921 Western High School   Regular School No 4.0 04 12 2015   grade_10                         107.0 108.0                       215.0                         107 108                 215
1163372 IN     school 1804470 3490   Western School Corp 180447000756 2921 Western High School   Regular School No 4.0 04 12 2015   grade_11                         88.0 118.0                       206.0                         88 118                 206
1163373 IN     school 1804470 3490   Western School Corp 180447000756 2921 Western High School   Regular School No 4.0 04 12 2015   grade_12                         89.0 97.0                       186.0                         89 97                 186
1163374 IN     school 1804470 3490   Western School Corp 180447000756 2921 Western High School   Regular School No 4.0 04 12 2015   grade_4                         0.0 1.0                       1.0                         0 1                 1
1163375 IN     school 1804470 3490   Western School Corp 180447000756 2921 Western High School   Regular School No 4.0 04 12 2015   grade_5                         2.0 0.0                       2.0                         2 0                 2
1163376 IN     school 1804470 3490   Western School Corp 180447000756 2921 Western High School   Regular School No 4.0 04 12 2015   grade_6                         1.0 2.0                       3.0                         1 2                 3
1163377 IN     school 1804470 3490   Western School Corp 180447000756 2921 Western High School   Regular School No 4.0 04 12 2015   grade_7                         2.0 2.0                       4.0                         2 2                 4
1163378 IN     school 1804470 3490   Western School Corp 180447000756 2921 Western High School   Regular School No 4.0 04 12 2015   grade_8                         3.0 0.0                       3.0                         3 0                 3
1163379 IN     school 1804470 3490   Western School Corp 180447000756 2921 Western High School   Regular School No 4.0 04 12 2015   grade_9                         111.0 108.0                       219.0                         111 108                 219
1163380 IN     school 1804470 3490   Western School Corp 180447000756 2921 Western High School   Regular School No 4.0 04 12 2015   pk_12_total 746.0 30.0 15.0 3.0   17.0     1.0   31.0   407.0 436.0     5.0             124.0   843.0 746 30 15 3   17     1   31   407 436     5       124   843
1163529 IN     school 1801230 3640   Medora Community School Corp 180123000201 3093 Medora Jr & Sr High School   Regular School No 4.0 06 12 2015   grade_10                         10.0 13.0                       23.0                         10 13                 23
1163530 IN     school 1801230 3640   Medora Community School Corp 180123000201 3093 Medora Jr & Sr High School   Regular School No 4.0 06 12 2015   grade_11                         16.0 12.0                       28.0                         16 12                 28
1163531 IN     school 1801230 3640   Medora Community School Corp 180123000201 3093 Medora Jr & Sr High School   Regular School No 4.0 06 12 2015   grade_12                         15.0 8.0                       23.0                         15 8                 23
1163532 IN     school 1801230 3640   Medora Community School Corp 180123000201 3093 Medora Jr & Sr High School   Regular School No 4.0 06 12 2015   grade_6                         11.0 9.0                       20.0                         11 9                 20
1163533 IN     school 1801230 3640   Medora Community School Corp 180123000201 3093 Medora Jr & Sr High School   Regular School No 4.0 06 12 2015   grade_7                         14.0 6.0                       20.0                         14 6                 20
1163534 IN     school 1801230 3640   Medora Community School Corp 180123000201 3093 Medora Jr & Sr High School   Regular School No 4.0 06 12 2015   grade_8                         11.0 10.0                       21.0                         11 10                 21

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