Data source: Big Local News · About: Big Local

12,002 rows where state = "IN" and year = 2021 sorted by district_state_id

View and edit SQL

grade

year

  • 2021 · 12,002
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
1920025 IN     school 1801920 1000   Clarksville Community School Corp 180192000249 833 Clarksville Senior High School   Regular School No High 09 12 2021   grade_10                         41.0 40.0                       81.0                         41 40                 81
1920026 IN     school 1801920 1000   Clarksville Community School Corp 180192000249 833 Clarksville Senior High School   Regular School No High 09 12 2021   grade_11                         56.0 55.0                       111.0                         56 55                 111
1920027 IN     school 1801920 1000   Clarksville Community School Corp 180192000249 833 Clarksville Senior High School   Regular School No High 09 12 2021   grade_12                         37.0 42.0                       79.0                         37 42                 79
1920028 IN     school 1801920 1000   Clarksville Community School Corp 180192000249 833 Clarksville Senior High School   Regular School No High 09 12 2021   grade_9                         50.0 32.0                       82.0                         50 32                 82
1920029 IN     school 1801920 1000   Clarksville Community School Corp 180192000249 833 Clarksville Senior High School   Regular School No High 09 12 2021   pk_12_total 247.0 34.0 41.0 1.0   1.0         29.0   184.0 169.0     19.0         138.0   66.0   353.0 247 34 41 1   1         29   184 169     19     138 66   353
1920030 IN     school 1801920 1000   Clarksville Community School Corp 180192000251 845 Clarksville Elementary School   Regular School No Elementary PK 04 2021   grade_1                         48.0 39.0                       87.0                         48 39                 87
1920031 IN     school 1801920 1000   Clarksville Community School Corp 180192000251 845 Clarksville Elementary School   Regular School No Elementary PK 04 2021   grade_2                         43.0 57.0                       100.0                         43 57                 100
1920032 IN     school 1801920 1000   Clarksville Community School Corp 180192000251 845 Clarksville Elementary School   Regular School No Elementary PK 04 2021   grade_3                         41.0 52.0                       93.0                         41 52                 93
1920033 IN     school 1801920 1000   Clarksville Community School Corp 180192000251 845 Clarksville Elementary School   Regular School No Elementary PK 04 2021   grade_4                         41.0 41.0                       82.0                         41 41                 82
1920034 IN     school 1801920 1000   Clarksville Community School Corp 180192000251 845 Clarksville Elementary School   Regular School No Elementary PK 04 2021   kindergarten                         57.0 53.0                       110.0                         57 53                 110
1920035 IN     school 1801920 1000   Clarksville Community School Corp 180192000251 845 Clarksville Elementary School   Regular School No Elementary PK 04 2021   pk_12_total 303.0 36.0 100.0     3.0         55.0   238.0 259.0     57.0         270.0   91.0   497.0 303 36 100     3         55   238 259     57     270 91   497
1920036 IN     school 1801920 1000   Clarksville Community School Corp 180192000251 845 Clarksville Elementary School   Regular School No Elementary PK 04 2021   pre_kindergarten                         8.0 17.0                       25.0                         8 17                 25
1920037 IN     school 1801920 1000   Clarksville Community School Corp 180192000248 851 Clarksville Middle School   Regular School No Middle 05 08 2021   grade_5                         41.0 34.0                       75.0                         41 34                 75
1920038 IN     school 1801920 1000   Clarksville Community School Corp 180192000248 851 Clarksville Middle School   Regular School No Middle 05 08 2021   grade_6                         35.0 54.0                       89.0                         35 54                 89
1920039 IN     school 1801920 1000   Clarksville Community School Corp 180192000248 851 Clarksville Middle School   Regular School No Middle 05 08 2021   grade_7                         44.0 32.0                       76.0                         44 32                 76
1920040 IN     school 1801920 1000   Clarksville Community School Corp 180192000248 851 Clarksville Middle School   Regular School No Middle 05 08 2021   grade_8                         37.0 48.0                       85.0                         37 48                 85
1920041 IN     school 1801920 1000   Clarksville Community School Corp 180192000248 851 Clarksville Middle School   Regular School No Middle 05 08 2021   pk_12_total 220.0 25.0 51.0               29.0   157.0 168.0     20.0         164.0   62.0   325.0 220 25 51               29   157 168     20     164 62   325
1920042 IN     school 1801920 1000   Clarksville Community School Corp 180192002690 1007 Indiana Gateway Digital Academy   Regular School No Other KG 12 2021   grade_1                         81.0 87.0                       168.0                         81 87                 168
1920043 IN     school 1801920 1000   Clarksville Community School Corp 180192002690 1007 Indiana Gateway Digital Academy   Regular School No Other KG 12 2021   grade_10                         86.0 90.0                       176.0                         86 90                 176
1920044 IN     school 1801920 1000   Clarksville Community School Corp 180192002690 1007 Indiana Gateway Digital Academy   Regular School No Other KG 12 2021   grade_11                         100.0 123.0                       223.0                         100 123                 223
1920045 IN     school 1801920 1000   Clarksville Community School Corp 180192002690 1007 Indiana Gateway Digital Academy   Regular School No Other KG 12 2021   grade_12                         0.0 1.0                       1.0                         0 1                 1
1920046 IN     school 1801920 1000   Clarksville Community School Corp 180192002690 1007 Indiana Gateway Digital Academy   Regular School No Other KG 12 2021   grade_2                         94.0 78.0                       172.0                         94 78                 172
1920047 IN     school 1801920 1000   Clarksville Community School Corp 180192002690 1007 Indiana Gateway Digital Academy   Regular School No Other KG 12 2021   grade_3                         84.0 81.0                       165.0                         84 81                 165
1920048 IN     school 1801920 1000   Clarksville Community School Corp 180192002690 1007 Indiana Gateway Digital Academy   Regular School No Other KG 12 2021   grade_4                         78.0 70.0                       148.0                         78 70                 148
1920049 IN     school 1801920 1000   Clarksville Community School Corp 180192002690 1007 Indiana Gateway Digital Academy   Regular School No Other KG 12 2021   grade_5                         111.0 98.0                       209.0                         111 98                 209
1920050 IN     school 1801920 1000   Clarksville Community School Corp 180192002690 1007 Indiana Gateway Digital Academy   Regular School No Other KG 12 2021   grade_6                         75.0 114.0                       189.0                         75 114                 189
1920051 IN     school 1801920 1000   Clarksville Community School Corp 180192002690 1007 Indiana Gateway Digital Academy   Regular School No Other KG 12 2021   grade_7                         108.0 116.0                       224.0                         108 116                 224
1920052 IN     school 1801920 1000   Clarksville Community School Corp 180192002690 1007 Indiana Gateway Digital Academy   Regular School No Other KG 12 2021   grade_8                         93.0 96.0                       189.0                         93 96                 189
1920053 IN     school 1801920 1000   Clarksville Community School Corp 180192002690 1007 Indiana Gateway Digital Academy   Regular School No Other KG 12 2021   grade_9                         87.0 102.0                       189.0                         87 102                 189
1920054 IN     school 1801920 1000   Clarksville Community School Corp 180192002690 1007 Indiana Gateway Digital Academy   Regular School No Other KG 12 2021   kindergarten                         106.0 109.0                       215.0                         106 109                 215
1920055 IN     school 1801920 1000   Clarksville Community School Corp 180192002690 1007 Indiana Gateway Digital Academy   Regular School No Other KG 12 2021   pk_12_total 1551.0 345.0 219.0 4.0   11.0     2.0   136.0   1103.0 1165.0     32.0         1640.0   283.0   2268.0 1551 345 219 4   11     2   136   1103 1165     32     1640 283   2268
1920056 IN     school 1803940 1010   Greater Clark County Schools 180394000682 755 W E Wilson Elementary   Regular School No Elementary PK 05 2021   grade_1                         52.0 41.0                       93.0                         52 41                 93
1920057 IN     school 1803940 1010   Greater Clark County Schools 180394000682 755 W E Wilson Elementary   Regular School No Elementary PK 05 2021   grade_2                         37.0 28.0                       65.0                         37 28                 65
1920058 IN     school 1803940 1010   Greater Clark County Schools 180394000682 755 W E Wilson Elementary   Regular School No Elementary PK 05 2021   grade_3                         40.0 34.0                       74.0                         40 34                 74
1920059 IN     school 1803940 1010   Greater Clark County Schools 180394000682 755 W E Wilson Elementary   Regular School No Elementary PK 05 2021   grade_4                         36.0 34.0                       70.0                         36 34                 70
1920060 IN     school 1803940 1010   Greater Clark County Schools 180394000682 755 W E Wilson Elementary   Regular School No Elementary PK 05 2021   grade_5                         48.0 33.0                       81.0                         48 33                 81
1920061 IN     school 1803940 1010   Greater Clark County Schools 180394000682 755 W E Wilson Elementary   Regular School No Elementary PK 05 2021   kindergarten                         52.0 41.0                       93.0                         52 41                 93
1920062 IN     school 1803940 1010   Greater Clark County Schools 180394000682 755 W E Wilson Elementary   Regular School No Elementary PK 05 2021   pk_12_total 227.0 122.0 57.0 2.0   9.0     1.0   78.0   276.0 220.0     18.0         256.0   86.0   496.0 227 122 57 2   9     1   78   276 220     18     256 86   496
1920063 IN     school 1803940 1010   Greater Clark County Schools 180394000682 755 W E Wilson Elementary   Regular School No Elementary PK 05 2021   pre_kindergarten                         11.0 9.0                       20.0                         11 9                 20
1920064 IN     school 1803940 1010   Greater Clark County Schools 180394000680 761 Thomas Jefferson Elementary School   Regular School No Elementary PK 05 2021   grade_1                         30.0 31.0                       61.0                         30 31                 61
1920065 IN     school 1803940 1010   Greater Clark County Schools 180394000680 761 Thomas Jefferson Elementary School   Regular School No Elementary PK 05 2021   grade_2                         32.0 30.0                       62.0                         32 30                 62
1920066 IN     school 1803940 1010   Greater Clark County Schools 180394000680 761 Thomas Jefferson Elementary School   Regular School No Elementary PK 05 2021   grade_3                         29.0 23.0                       52.0                         29 23                 52
1920067 IN     school 1803940 1010   Greater Clark County Schools 180394000680 761 Thomas Jefferson Elementary School   Regular School No Elementary PK 05 2021   grade_4                         27.0 26.0                       53.0                         27 26                 53
1920068 IN     school 1803940 1010   Greater Clark County Schools 180394000680 761 Thomas Jefferson Elementary School   Regular School No Elementary PK 05 2021   grade_5                         26.0 16.0                       42.0                         26 16                 42
1920069 IN     school 1803940 1010   Greater Clark County Schools 180394000680 761 Thomas Jefferson Elementary School   Regular School No Elementary PK 05 2021   kindergarten                         30.0 19.0                       49.0                         30 19                 49
1920070 IN     school 1803940 1010   Greater Clark County Schools 180394000680 761 Thomas Jefferson Elementary School   Regular School No Elementary PK 05 2021   pk_12_total 226.0 30.0 30.0     4.0         46.0   180.0 156.0     8.0         163.0   83.0   336.0 226 30 30     4         46   180 156     8     163 83   336
1920071 IN     school 1803940 1010   Greater Clark County Schools 180394000680 761 Thomas Jefferson Elementary School   Regular School No Elementary PK 05 2021   pre_kindergarten                         6.0 11.0                       17.0                         6 11                 17
1920072 IN     school 1803940 1010   Greater Clark County Schools 180394000673 801 Northaven Elementary School   Regular School No Elementary PK 05 2021   grade_1                         44.0 41.0                       85.0                         44 41                 85
1920073 IN     school 1803940 1010   Greater Clark County Schools 180394000673 801 Northaven Elementary School   Regular School No Elementary PK 05 2021   grade_2                         48.0 38.0                       86.0                         48 38                 86
1920074 IN     school 1803940 1010   Greater Clark County Schools 180394000673 801 Northaven Elementary School   Regular School No Elementary PK 05 2021   grade_3                         43.0 41.0                       84.0                         43 41                 84
1920075 IN     school 1803940 1010   Greater Clark County Schools 180394000673 801 Northaven Elementary School   Regular School No Elementary PK 05 2021   grade_4                         49.0 35.0                       84.0                         49 35                 84
1920076 IN     school 1803940 1010   Greater Clark County Schools 180394000673 801 Northaven Elementary School   Regular School No Elementary PK 05 2021   grade_5                         30.0 43.0                       73.0                         30 43                 73
1920077 IN     school 1803940 1010   Greater Clark County Schools 180394000673 801 Northaven Elementary School   Regular School No Elementary PK 05 2021   kindergarten                         41.0 32.0                       73.0                         41 32                 73
1920078 IN     school 1803940 1010   Greater Clark County Schools 180394000673 801 Northaven Elementary School   Regular School No Elementary PK 05 2021   pk_12_total 166.0 90.0 137.0 1.0   19.0     12.0   79.0   266.0 238.0     152.0         316.0   73.0   504.0 166 90 137 1   19     12   79   266 238     152     316 73   504
1920079 IN     school 1803940 1010   Greater Clark County Schools 180394000673 801 Northaven Elementary School   Regular School No Elementary PK 05 2021   pre_kindergarten                         11.0 8.0                       19.0                         11 8                 19
1920080 IN     school 1803940 1010   Greater Clark County Schools 180394000681 805 Utica Elementary School   Regular School No Elementary PK 05 2021   grade_1                         49.0 46.0                       95.0                         49 46                 95
1920081 IN     school 1803940 1010   Greater Clark County Schools 180394000681 805 Utica Elementary School   Regular School No Elementary PK 05 2021   grade_2                         46.0 37.0                       83.0                         46 37                 83
1920082 IN     school 1803940 1010   Greater Clark County Schools 180394000681 805 Utica Elementary School   Regular School No Elementary PK 05 2021   grade_3                         47.0 42.0                       89.0                         47 42                 89
1920083 IN     school 1803940 1010   Greater Clark County Schools 180394000681 805 Utica Elementary School   Regular School No Elementary PK 05 2021   grade_4                         50.0 41.0                       91.0                         50 41                 91
1920084 IN     school 1803940 1010   Greater Clark County Schools 180394000681 805 Utica Elementary School   Regular School No Elementary PK 05 2021   grade_5                         46.0 38.0                       84.0                         46 38                 84
1920085 IN     school 1803940 1010   Greater Clark County Schools 180394000681 805 Utica Elementary School   Regular School No Elementary PK 05 2021   kindergarten                         43.0 53.0                       96.0                         43 53                 96
1920086 IN     school 1803940 1010   Greater Clark County Schools 180394000681 805 Utica Elementary School   Regular School No Elementary PK 05 2021   pk_12_total 428.0 47.0 16.0 3.0   3.0         56.0   291.0 262.0     2.0         140.0   72.0   553.0 428 47 16 3   3         56   291 262     2     140 72   553
1920087 IN     school 1803940 1010   Greater Clark County Schools 180394000681 805 Utica Elementary School   Regular School No Elementary PK 05 2021   pre_kindergarten                         10.0 5.0                       15.0                         10 5                 15
1920088 IN     school 1803940 1010   Greater Clark County Schools 180394000671 807 New Washington Elementary School   Regular School No Elementary PK 05 2021   grade_1                         24.0 19.0                       43.0                         24 19                 43
1920089 IN     school 1803940 1010   Greater Clark County Schools 180394000671 807 New Washington Elementary School   Regular School No Elementary PK 05 2021   grade_2                         22.0 24.0                       46.0                         22 24                 46
1920090 IN     school 1803940 1010   Greater Clark County Schools 180394000671 807 New Washington Elementary School   Regular School No Elementary PK 05 2021   grade_3                         21.0 34.0                       55.0                         21 34                 55
1920091 IN     school 1803940 1010   Greater Clark County Schools 180394000671 807 New Washington Elementary School   Regular School No Elementary PK 05 2021   grade_4                         20.0 25.0                       45.0                         20 25                 45
1920092 IN     school 1803940 1010   Greater Clark County Schools 180394000671 807 New Washington Elementary School   Regular School No Elementary PK 05 2021   grade_5                         31.0 21.0                       52.0                         31 21                 52
1920093 IN     school 1803940 1010   Greater Clark County Schools 180394000671 807 New Washington Elementary School   Regular School No Elementary PK 05 2021   kindergarten                         24.0 26.0                       50.0                         24 26                 50
1920094 IN     school 1803940 1010   Greater Clark County Schools 180394000671 807 New Washington Elementary School   Regular School No Elementary PK 05 2021   pk_12_total 272.0 1.0 8.0 1.0             15.0   145.0 152.0     4.0         150.0   80.0   297.0 272 1 8 1             15   145 152     4     150 80   297
1920095 IN     school 1803940 1010   Greater Clark County Schools 180394000671 807 New Washington Elementary School   Regular School No Elementary PK 05 2021   pre_kindergarten                         3.0 3.0                       6.0                         3 3                 6
1920096 IN     school 1803940 1010   Greater Clark County Schools 180394000672 809 New Washington Middle/High School   Regular School No High 06 12 2021   grade_10                         18.0 24.0                       42.0                         18 24                 42
1920097 IN     school 1803940 1010   Greater Clark County Schools 180394000672 809 New Washington Middle/High School   Regular School No High 06 12 2021   grade_11                         21.0 23.0                       44.0                         21 23                 44
1920098 IN     school 1803940 1010   Greater Clark County Schools 180394000672 809 New Washington Middle/High School   Regular School No High 06 12 2021   grade_12                         20.0 25.0                       45.0                         20 25                 45
1920099 IN     school 1803940 1010   Greater Clark County Schools 180394000672 809 New Washington Middle/High School   Regular School No High 06 12 2021   grade_6                         17.0 26.0                       43.0                         17 26                 43
1920100 IN     school 1803940 1010   Greater Clark County Schools 180394000672 809 New Washington Middle/High School   Regular School No High 06 12 2021   grade_7                         27.0 25.0                       52.0                         27 25                 52
1920101 IN     school 1803940 1010   Greater Clark County Schools 180394000672 809 New Washington Middle/High School   Regular School No High 06 12 2021   grade_8                         17.0 32.0                       49.0                         17 32                 49
1920102 IN     school 1803940 1010   Greater Clark County Schools 180394000672 809 New Washington Middle/High School   Regular School No High 06 12 2021   grade_9                         25.0 23.0                       48.0                         25 23                 48
1920103 IN     school 1803940 1010   Greater Clark County Schools 180394000672 809 New Washington Middle/High School   Regular School No High 06 12 2021   pk_12_total 302.0   7.0     1.0         13.0   145.0 178.0     0.0         141.0   41.0   323.0 302   7     1         13   145 178     0     141 41   323
1920104 IN     school 1803940 1010   Greater Clark County Schools 180394000663 821 Charlestown Senior High School   Regular School No High 09 12 2021   grade_10                         86.0 99.0                       185.0                         86 99                 185
1920105 IN     school 1803940 1010   Greater Clark County Schools 180394000663 821 Charlestown Senior High School   Regular School No High 09 12 2021   grade_11                         94.0 78.0                       172.0                         94 78                 172
1920106 IN     school 1803940 1010   Greater Clark County Schools 180394000663 821 Charlestown Senior High School   Regular School No High 09 12 2021   grade_12                         91.0 91.0                       182.0                         91 91                 182
1920107 IN     school 1803940 1010   Greater Clark County Schools 180394000663 821 Charlestown Senior High School   Regular School No High 09 12 2021   grade_9                         95.0 109.0                       204.0                         95 109                 204
1920108 IN     school 1803940 1010   Greater Clark County Schools 180394000663 821 Charlestown Senior High School   Regular School No High 09 12 2021   pk_12_total 608.0 28.0 79.0 1.0   4.0         23.0   366.0 377.0     23.0         302.0   101.0   743.0 608 28 79 1   4         23   366 377     23     302 101   743
1920109 IN     school 1803940 1010   Greater Clark County Schools 180394000667 825 Jonathan Jennings Elementary Sch   Regular School No Elementary 03 05 2021   grade_3                         70.0 76.0                       146.0                         70 76                 146
1920110 IN     school 1803940 1010   Greater Clark County Schools 180394000667 825 Jonathan Jennings Elementary Sch   Regular School No Elementary 03 05 2021   grade_4                         97.0 85.0                       182.0                         97 85                 182
1920111 IN     school 1803940 1010   Greater Clark County Schools 180394000667 825 Jonathan Jennings Elementary Sch   Regular School No Elementary 03 05 2021   grade_5                         77.0 91.0                       168.0                         77 91                 168
1920112 IN     school 1803940 1010   Greater Clark County Schools 180394000667 825 Jonathan Jennings Elementary Sch   Regular School No Elementary 03 05 2021   pk_12_total 385.0 14.0 48.0 1.0   3.0     1.0   44.0   244.0 252.0     27.0         244.0   71.0   496.0 385 14 48 1   3     1   44   244 252     27     244 71   496
1920113 IN     school 1803940 1010   Greater Clark County Schools 180394000676 829 Pleasant Ridge Elementary School   Regular School No Elementary PK 02 2021   grade_1                         75.0 62.0                       137.0                         75 62                 137
1920114 IN     school 1803940 1010   Greater Clark County Schools 180394000676 829 Pleasant Ridge Elementary School   Regular School No Elementary PK 02 2021   grade_2                         82.0 75.0                       157.0                         82 75                 157
1920115 IN     school 1803940 1010   Greater Clark County Schools 180394000676 829 Pleasant Ridge Elementary School   Regular School No Elementary PK 02 2021   kindergarten                         78.0 76.0                       154.0                         78 76                 154
1920116 IN     school 1803940 1010   Greater Clark County Schools 180394000676 829 Pleasant Ridge Elementary School   Regular School No Elementary PK 02 2021   pk_12_total 360.0 14.0 53.0     1.0     2.0   46.0   252.0 224.0     23.0         223.0   92.0   476.0 360 14 53     1     2   46   252 224     23     223 92   476
1920117 IN     school 1803940 1010   Greater Clark County Schools 180394000676 829 Pleasant Ridge Elementary School   Regular School No Elementary PK 02 2021   pre_kindergarten                         17.0 11.0                       28.0                         17 11                 28
1920118 IN     school 1803940 1010   Greater Clark County Schools 180394000666 849 Jeffersonville High School   Regular School No High 09 12 2021   grade_10                         288.0 251.0                       539.0                         288 251                 539
1920119 IN     school 1803940 1010   Greater Clark County Schools 180394000666 849 Jeffersonville High School   Regular School No High 09 12 2021   grade_11                         284.0 242.0                       526.0                         284 242                 526
1920120 IN     school 1803940 1010   Greater Clark County Schools 180394000666 849 Jeffersonville High School   Regular School No High 09 12 2021   grade_12                         255.0 229.0                       484.0                         255 229                 484
1920121 IN     school 1803940 1010   Greater Clark County Schools 180394000666 849 Jeffersonville High School   Regular School No High 09 12 2021   grade_9                         297.0 288.0                       585.0                         297 288                 585
1920122 IN     school 1803940 1010   Greater Clark County Schools 180394000666 849 Jeffersonville High School   Regular School No High 09 12 2021   pk_12_total 1080.0 444.0 345.0 8.0   33.0     3.0   221.0   1124.0 1010.0     118.0         1050.0   338.0   2134.0 1080 444 345 8   33     3   221   1124 1010     118     1050 338   2134
1920123 IN     school 1803940 1010   Greater Clark County Schools 180394000674 853 Parkview Middle School   Regular School No Middle 06 08 2021   grade_6                         146.0 120.0                       266.0                         146 120                 266
1920124 IN     school 1803940 1010   Greater Clark County Schools 180394000674 853 Parkview Middle School   Regular School No Middle 06 08 2021   grade_7                         136.0 120.0                       256.0                         136 120                 256

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