Data source: Big Local News · About: Big Local

84,143 rows where state = "IN" sorted by district_state_id

View and edit SQL

grade

year

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
1908069 IN     school 1801920 1000   Clarksville Community School Corp 180192000251 845 Clarksville Elementary School   Regular School No Elementary PK 04 2020   kindergarten                         57.0 51.0                       108.0                         57 51                 108
1908070 IN     school 1801920 1000   Clarksville Community School Corp 180192000251 845 Clarksville Elementary School   Regular School No Elementary PK 04 2020   pk_12_total 332.0 55.0 105.0 1.0   1.0     1.0   50.0   275.0 270.0     71.0         330.0   91.0   545.0 332 55 105 1   1     1   50   275 270     71     330 91   545
1908071 IN     school 1801920 1000   Clarksville Community School Corp 180192000251 845 Clarksville Elementary School   Regular School No Elementary PK 04 2020   pre_kindergarten                         10.0 12.0                       22.0                         10 12                 22
1908072 IN     school 1801920 1000   Clarksville Community School Corp 180192000248 851 Clarksville Middle School   Regular School No Middle 05 08 2020   grade_5                         39.0 66.0                       105.0                         39 66                 105
1908073 IN     school 1801920 1000   Clarksville Community School Corp 180192000248 851 Clarksville Middle School   Regular School No Middle 05 08 2020   grade_6                         48.0 42.0                       90.0                         48 42                 90
1908074 IN     school 1801920 1000   Clarksville Community School Corp 180192000248 851 Clarksville Middle School   Regular School No Middle 05 08 2020   grade_7                         47.0 59.0                       106.0                         47 59                 106
1908075 IN     school 1801920 1000   Clarksville Community School Corp 180192000248 851 Clarksville Middle School   Regular School No Middle 05 08 2020   grade_8                         63.0 31.0                       94.0                         63 31                 94
1908076 IN     school 1801920 1000   Clarksville Community School Corp 180192000248 851 Clarksville Middle School   Regular School No Middle 05 08 2020   pk_12_total 260.0 30.0 62.0 1.0   2.0         40.0   197.0 198.0     27.0         228.0   83.0   395.0 260 30 62 1   2         40   197 198     27     228 83   395
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
1160558 IN     school 1803940 1010   Greater Clark County Schools 180394000682 755 W E Wilson Elementary   Regular School No 1.0 PK 05 2015   grade_1                         52.0 42.0                       94.0                         52 42                 94
1160559 IN     school 1803940 1010   Greater Clark County Schools 180394000682 755 W E Wilson Elementary   Regular School No 1.0 PK 05 2015   grade_2                         54.0 37.0                       91.0                         54 37                 91
1160560 IN     school 1803940 1010   Greater Clark County Schools 180394000682 755 W E Wilson Elementary   Regular School No 1.0 PK 05 2015   grade_3                         41.0 38.0                       79.0                         41 38                 79
1160561 IN     school 1803940 1010   Greater Clark County Schools 180394000682 755 W E Wilson Elementary   Regular School No 1.0 PK 05 2015   grade_4                         36.0 40.0                       76.0                         36 40                 76
1160562 IN     school 1803940 1010   Greater Clark County Schools 180394000682 755 W E Wilson Elementary   Regular School No 1.0 PK 05 2015   grade_5                         47.0 31.0                       78.0                         47 31                 78
1160563 IN     school 1803940 1010   Greater Clark County Schools 180394000682 755 W E Wilson Elementary   Regular School No 1.0 PK 05 2015   kindergarten                         61.0 45.0                       106.0                         61 45                 106
1160564 IN     school 1803940 1010   Greater Clark County Schools 180394000682 755 W E Wilson Elementary   Regular School No 1.0 PK 05 2015   pk_12_total 299.0 128.0 53.0 3.0   9.0     1.0   61.0   310.0 244.0     19.0             84.0   554.0 299 128 53 3   9     1   61   310 244     19       84   554
1160565 IN     school 1803940 1010   Greater Clark County Schools 180394000682 755 W E Wilson Elementary   Regular School No 1.0 PK 05 2015   pre_kindergarten                         19.0 11.0                       30.0                         19 11                 30
1160566 IN     school 1803940 1010   Greater Clark County Schools 180394000680 761 Thomas Jefferson Elem Sch   Regular School No 1.0 KG 05 2015   grade_1                         32.0 39.0                       71.0                         32 39                 71
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
1160568 IN     school 1803940 1010   Greater Clark County Schools 180394000680 761 Thomas Jefferson Elem Sch   Regular School No 1.0 KG 05 2015   grade_3                         38.0 32.0                       70.0                         38 32                 70
1160569 IN     school 1803940 1010   Greater Clark County Schools 180394000680 761 Thomas Jefferson Elem Sch   Regular School No 1.0 KG 05 2015   grade_4                         32.0 19.0                       51.0                         32 19                 51
1160570 IN     school 1803940 1010   Greater Clark County Schools 180394000680 761 Thomas Jefferson Elem Sch   Regular School No 1.0 KG 05 2015   grade_5                         28.0 30.0                       58.0                         28 30                 58
1160571 IN     school 1803940 1010   Greater Clark County Schools 180394000680 761 Thomas Jefferson Elem Sch   Regular School No 1.0 KG 05 2015   kindergarten                         34.0 25.0                       59.0                         34 25                 59
1160572 IN     school 1803940 1010   Greater Clark County Schools 180394000680 761 Thomas Jefferson Elem Sch   Regular School No 1.0 KG 05 2015   pk_12_total 269.0 39.0 16.0 2.0   5.0         40.0   191.0 180.0     12.0             56.0   371.0 269 39 16 2   5         40   191 180     12       56   371
1160573 IN     school 1803940 1010   Greater Clark County Schools 180394000673 801 Northaven Elementary School   Regular School No 1.0 KG 05 2015   grade_1                         38.0 31.0                       69.0                         38 31                 69
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
1160575 IN     school 1803940 1010   Greater Clark County Schools 180394000673 801 Northaven Elementary School   Regular School No 1.0 KG 05 2015   grade_3                         37.0 30.0                       67.0                         37 30                 67
1160576 IN     school 1803940 1010   Greater Clark County Schools 180394000673 801 Northaven Elementary School   Regular School No 1.0 KG 05 2015   grade_4                         44.0 27.0                       71.0                         44 27                 71
1160577 IN     school 1803940 1010   Greater Clark County Schools 180394000673 801 Northaven Elementary School   Regular School No 1.0 KG 05 2015   grade_5                         43.0 37.0                       80.0                         43 37                 80
1160578 IN     school 1803940 1010   Greater Clark County Schools 180394000673 801 Northaven Elementary School   Regular School No 1.0 KG 05 2015   kindergarten                         43.0 40.0                       83.0                         43 40                 83
1160579 IN     school 1803940 1010   Greater Clark County Schools 180394000673 801 Northaven Elementary School   Regular School No 1.0 KG 05 2015   pk_12_total 184.0 70.0 109.0 1.0   22.0     1.0   59.0   241.0 205.0     95.0             72.0   446.0 184 70 109 1   22     1   59   241 205     95       72   446
1160580 IN     school 1803940 1010   Greater Clark County Schools 180394000681 805 Utica Elementary School   Regular School No 1.0 KG 05 2015   grade_1                         38.0 35.0                       73.0                         38 35                 73
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
1160582 IN     school 1803940 1010   Greater Clark County Schools 180394000681 805 Utica Elementary School   Regular School No 1.0 KG 05 2015   grade_3                         39.0 47.0                       86.0                         39 47                 86
1160583 IN     school 1803940 1010   Greater Clark County Schools 180394000681 805 Utica Elementary School   Regular School No 1.0 KG 05 2015   grade_4                         50.0 41.0                       91.0                         50 41                 91
1160584 IN     school 1803940 1010   Greater Clark County Schools 180394000681 805 Utica Elementary School   Regular School No 1.0 KG 05 2015   grade_5                         36.0 38.0                       74.0                         36 38                 74
1160585 IN     school 1803940 1010   Greater Clark County Schools 180394000681 805 Utica Elementary School   Regular School No 1.0 KG 05 2015   kindergarten                         48.0 50.0                       98.0                         48 50                 98
1160586 IN     school 1803940 1010   Greater Clark County Schools 180394000681 805 Utica Elementary School   Regular School No 1.0 KG 05 2015   pk_12_total 389.0 37.0 28.0     12.0         44.0   260.0 250.0     9.0             61.0   510.0 389 37 28     12         44   260 250     9       61   510
1160587 IN     school 1803940 1010   Greater Clark County Schools 180394000671 807 New Washington Elem School   Regular School No 1.0 PK 05 2015   grade_1                         27.0 25.0                       52.0                         27 25                 52
1160588 IN     school 1803940 1010   Greater Clark County Schools 180394000671 807 New Washington Elem School   Regular School No 1.0 PK 05 2015   grade_2                         17.0 24.0                       41.0                         17 24                 41
1160589 IN     school 1803940 1010   Greater Clark County Schools 180394000671 807 New Washington Elem School   Regular School No 1.0 PK 05 2015   grade_3                         29.0 25.0                       54.0                         29 25                 54
1160590 IN     school 1803940 1010   Greater Clark County Schools 180394000671 807 New Washington Elem School   Regular School No 1.0 PK 05 2015   grade_4                         21.0 25.0                       46.0                         21 25                 46
1160591 IN     school 1803940 1010   Greater Clark County Schools 180394000671 807 New Washington Elem School   Regular School No 1.0 PK 05 2015   grade_5                         25.0 33.0                       58.0                         25 33                 58
1160592 IN     school 1803940 1010   Greater Clark County Schools 180394000671 807 New Washington Elem School   Regular School No 1.0 PK 05 2015   kindergarten                         23.0 30.0                       53.0                         23 30                 53
1160593 IN     school 1803940 1010   Greater Clark County Schools 180394000671 807 New Washington Elem School   Regular School No 1.0 PK 05 2015   pk_12_total 314.0 1.0 7.0               9.0   159.0 172.0     2.0             74.0   331.0 314 1 7               9   159 172     2       74   331
1160594 IN     school 1803940 1010   Greater Clark County Schools 180394000671 807 New Washington Elem School   Regular School No 1.0 PK 05 2015   pre_kindergarten                         17.0 10.0                       27.0                         17 10                 27
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
1160603 IN     school 1803940 1010   Greater Clark County Schools 180394000663 821 Charlestown Senior High Sch   Regular School No 3.0 09 12 2015   grade_10                         86.0 75.0                       161.0                         86 75                 161
1160604 IN     school 1803940 1010   Greater Clark County Schools 180394000663 821 Charlestown Senior High Sch   Regular School No 3.0 09 12 2015   grade_11                         97.0 82.0                       179.0                         97 82                 179
1160605 IN     school 1803940 1010   Greater Clark County Schools 180394000663 821 Charlestown Senior High Sch   Regular School No 3.0 09 12 2015   grade_12                         109.0 90.0                       199.0                         109 90                 199
1160606 IN     school 1803940 1010   Greater Clark County Schools 180394000663 821 Charlestown Senior High Sch   Regular School No 3.0 09 12 2015   grade_9                         106.0 81.0                       187.0                         106 81                 187
1160607 IN     school 1803940 1010   Greater Clark County Schools 180394000663 821 Charlestown Senior High Sch   Regular School No 3.0 09 12 2015   pk_12_total 603.0 14.0 71.0               38.0   398.0 328.0     8.0             107.0   726.0 603 14 71               38   398 328     8       107   726
1160608 IN     school 1803940 1010   Greater Clark County Schools 180394000667 825 Jonathan Jennings Elem Sch   Regular School No 1.0 KG 05 2015   grade_1                         35.0 39.0                       74.0                         35 39                 74
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
1160610 IN     school 1803940 1010   Greater Clark County Schools 180394000667 825 Jonathan Jennings Elem Sch   Regular School No 1.0 KG 05 2015   grade_3                         32.0 55.0                       87.0                         32 55                 87
1160611 IN     school 1803940 1010   Greater Clark County Schools 180394000667 825 Jonathan Jennings Elem Sch   Regular School No 1.0 KG 05 2015   grade_4                         33.0 38.0                       71.0                         33 38                 71
1160612 IN     school 1803940 1010   Greater Clark County Schools 180394000667 825 Jonathan Jennings Elem Sch   Regular School No 1.0 KG 05 2015   grade_5                         45.0 45.0                       90.0                         45 45                 90
1160613 IN     school 1803940 1010   Greater Clark County Schools 180394000667 825 Jonathan Jennings Elem Sch   Regular School No 1.0 KG 05 2015   kindergarten                         40.0 40.0                       80.0                         40 40                 80
1160614 IN     school 1803940 1010   Greater Clark County Schools 180394000667 825 Jonathan Jennings Elem Sch   Regular School No 1.0 KG 05 2015   pk_12_total 391.0 13.0 57.0     1.0         21.0   229.0 254.0     26.0             65.0   483.0 391 13 57     1         21   229 254     26       65   483
1160615 IN     school 1803940 1010   Greater Clark County Schools 180394000676 829 Pleasant Ridge Elem School   Regular School No 1.0 KG 05 2015   grade_1                         41.0 39.0                       80.0                         41 39                 80
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
1160617 IN     school 1803940 1010   Greater Clark County Schools 180394000676 829 Pleasant Ridge Elem School   Regular School No 1.0 KG 05 2015   grade_3                         39.0 43.0                       82.0                         39 43                 82
1160618 IN     school 1803940 1010   Greater Clark County Schools 180394000676 829 Pleasant Ridge Elem School   Regular School No 1.0 KG 05 2015   grade_4                         33.0 41.0                       74.0                         33 41                 74

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