enrollments

Data source: Big Local News · About: Big Local

4,822 rows where grade = "grade_6" and state = "IN" sorted by district

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_6 · 4,822 ✖
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
1171012 1171012 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes 4.0 KG 12 2015   grade_6                         36.0 26.0                       62.0                         36 26                 62
1292389 1292389 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes 4.0 KG 12 2016   grade_6                         36.0 24.0                       60.0                         36 24                 60
1304422 1304422 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2017   grade_6                         31.0 28.0                       59.0                         31 28                 59
1763033 1763033 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2019   grade_6                         27.0 30.0                       57.0                         27 30                 57
1798763 1798763 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2018   grade_6                         34.0 25.0                       59.0                         34 25                 59
1918502 1918502 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2020   grade_6                         53.0 49.0                       102.0                         53 49                 102
1930497 1930497 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2021   grade_6                         47.0 52.0                       99.0                         47 52                 99
1159462 1159462 IN     school 1800060 15   Adams Central Community Schools 180006000008 13 Adams Central Middle School   Regular School No 2.0 06 08 2015   grade_6                         45.0 55.0                       100.0                         45 55                 100
1280852 1280852 IN     school 1800060 15   Adams Central Community Schools 180006000008 13 Adams Central Middle School   Regular School No 2.0 06 08 2016   grade_6                         38.0 41.0                       79.0                         38 41                 79
1292914 1292914 IN     school 1800060 15   Adams Central Community Schools 180006000008 13 Adams Central Middle School   Regular School No Middle 06 08 2017   grade_6                         50.0 36.0                       86.0                         50 36                 86
1751546 1751546 IN     school 1800060 15   Adams Central Community Schools 180006000008 13 Adams Central Middle School   Regular School No Middle 06 08 2019   grade_6                         55.0 51.0                       106.0                         55 51                 106
1787287 1787287 IN     school 1800060 15   Adams Central Community Schools 180006000008 13 Adams Central Middle School   Regular School No Middle 06 08 2018   grade_6                         51.0 51.0                       102.0                         51 51                 102
1906987 1906987 IN     school 1800060 15   Adams Central Community Schools 180006000008 13 Adams Central Middle School   Regular School No Middle 06 08 2020   grade_6                         62.0 45.0                       107.0                         62 45                 107
1918953 1918953 IN     school 1800060 15   Adams Central Community Schools 180006000008 13 Adams Central Middle School   Regular School No Middle 06 08 2021   grade_6                         53.0 45.0                       98.0                         53 45                 98
1930222 1930222 IN     school 1800216 9130   Adelante Schools 180021602702 9993 Emma Donnan Elementary and Middle   Regular School Yes Elementary KG 08 2021   grade_6                         19.0 17.0                       36.0                         19 17                 36
1165530 1165530 IN     school 1800120 5265   Alexandria Com School Corp 180012000010 5065 Alexandria-Monroe Intermediate   Regular School No 1.0 03 06 2015   grade_6                         55.0 65.0                       120.0                         55 65                 120
1286926 1286926 IN     school 1800120 5265   Alexandria Community School Corp 180012000010 5065 Alexandria-Monroe Intermediate   Regular School No 1.0 03 06 2016   grade_6                         42.0 60.0                       102.0                         42 60                 102
1298961 1298961 IN     school 1800120 5265   Alexandria Community School Corp 180012000010 5065 Alexandria-Monroe Intermediate   Regular School No Elementary 03 06 2017   grade_6                         55.0 57.0                       112.0                         55 57                 112
1757492 1757492 IN     school 1800120 5265   Alexandria Community School Corp 180012000010 5065 Alexandria-Monroe Intermediate   Regular School No Elementary 03 06 2019   grade_6                         51.0 50.0                       101.0                         51 50                 101
1793283 1793283 IN     school 1800120 5265   Alexandria Community School Corp 180012000010 5065 Alexandria-Monroe Intermediate   Regular School No Elementary 03 06 2018   grade_6                         74.0 50.0                       124.0                         74 50                 124
1912915 1912915 IN     school 1800120 5265   Alexandria Community School Corp 180012000010 5065 Alexandria-Monroe Intermediate   Regular School No Elementary 03 06 2020   grade_6                         70.0 51.0                       121.0                         70 51                 121
1924839 1924839 IN     school 1800120 5265   Alexandria Community School Corp 180012000010 5065 Alexandria Monroe Elementary Schoo   Regular School No Elementary PK 06 2021   grade_6                         60.0 70.0                       130.0                         60 70                 130
1165566 1165566 IN     school 1800150 5275   Anderson Community School Corp 180015002483 5076 Highland Middle School   Regular School No 2.0 06 08 2015   grade_6                         234.0 214.0                       448.0                         234 214                 448
1286961 1286961 IN     school 1800150 5275   Anderson Community School Corp 180015002483 5076 Highland Middle School   Regular School No 2.0 06 08 2016   grade_6                         228.0 211.0                       439.0                         228 211                 439
1298996 1298996 IN     school 1800150 5275   Anderson Community School Corp 180015002483 5076 Highland Middle School   Regular School No Middle 06 08 2017   grade_6                         268.0 227.0                       495.0                         268 227                 495
1757500 1757500 IN     school 1800150 5275   Anderson Community School Corp 180015002623 4906 COMPASS Alternative School   Alternative School No Middle 06 10 2019   grade_6                         5.0 1.0                       6.0                         5 1                 6
1757533 1757533 IN     school 1800150 5275   Anderson Community School Corp 180015002483 5076 Highland Middle School   Regular School No Middle 06 08 2019   grade_6                         287.0 262.0                       549.0                         287 262                 549
1793290 1793290 IN     school 1800150 5275   Anderson Community School Corp 180015002623 4906 COMPASS Alternative School   Alternative School No Middle 06 09 2018   grade_6                         8.0 3.0                       11.0                         8 3                 11
1793323 1793323 IN     school 1800150 5275   Anderson Community School Corp 180015002483 5076 Highland Middle School   Regular School No Middle 06 08 2018   grade_6                         258.0 252.0                       510.0                         258 252                 510
1912939 1912939 IN     school 1800150 5275   Anderson Community School Corp 180015002682 4967 Anderson Intermediate School   Regular School No Middle 05 06 2020   grade_6                         282.0 261.0                       543.0                         282 261                 543
1924864 1924864 IN     school 1800150 5275   Anderson Community School Corp 180015002682 4967 Anderson Intermediate School   Regular School No Middle 05 06 2021   grade_6                         276.0 235.0                       511.0                         276 235                 511
1171305 1171305 IN     school 1800077 9790   Anderson Preparatory Academy 180007702425 5092 Anderson Preparatory Academy   Regular School Yes 4.0 KG 12 2015   grade_6                         35.0 30.0                       65.0                         35 30                 65
1292665 1292665 IN     school 1800077 9790   Anderson Preparatory Academy 180007702425 5092 Anderson Preparatory Academy   Regular School Yes 4.0 KG 12 2016   grade_6                         40.0 23.0                       63.0                         40 23                 63
1304705 1304705 IN     school 1800077 9790   Anderson Preparatory Academy 180007702425 5092 Anderson Preparatory Academy   Regular School Yes Other KG 12 2017   grade_6                         28.0 32.0                       60.0                         28 32                 60
1763287 1763287 IN     school 1800077 9790   Anderson Preparatory Academy 180007702425 5092 Anderson Preparatory Academy   Regular School Yes Other KG 12 2019   grade_6                         32.0 22.0                       54.0                         32 22                 54
1799032 1799032 IN     school 1800077 9790   Anderson Preparatory Academy 180007702425 5092 Anderson Preparatory Academy   Regular School Yes Other KG 12 2018   grade_6                         31.0 25.0                       56.0                         31 25                 56
1918734 1918734 IN     school 1800077 9790   Anderson Preparatory Academy 180007702425 5092 Anderson Preparatory Academy   Regular School Yes Other KG 12 2020   grade_6                         34.0 24.0                       58.0                         34 24                 58
1930722 1930722 IN     school 1800077 9790   Anderson Preparatory Academy 180007702425 5092 Anderson Preparatory Academy   Regular School Yes Other KG 12 2021   grade_6                         49.0 42.0                       91.0                         49 42                 91
1171192 1171192 IN     school 1800092 9715   Andrew Academy 180009202493 5785 Andrew Academy   Regular School Yes 1.0 KG 08 2015   grade_6                         14.0 8.0                       22.0                         14 8                 22
1171087 1171087 IN     school 1800042 9615   Andrew J Brown Academy 180004201816 5488 Andrew J Brown Academy   Regular School Yes 1.0 KG 08 2015   grade_6                         30.0 14.0                       44.0                         30 14                 44
1292464 1292464 IN     school 1800042 9615   Andrew J Brown Academy 180004201816 5488 Andrew J Brown Academy   Regular School Yes 1.0 KG 08 2016   grade_6                         37.0 26.0                       63.0                         37 26                 63
1304497 1304497 IN     school 1800042 9615   Andrew J Brown Academy 180004201816 5488 Andrew J Brown Academy   Regular School Yes Elementary KG 08 2017   grade_6                         30.0 41.0                       71.0                         30 41                 71
1763109 1763109 IN     school 1800042 9615   Andrew J Brown Academy 180004201816 5488 Andrew J Brown Academy   Regular School Yes Elementary KG 08 2019   grade_6                         43.0 33.0                       76.0                         43 33                 76
1798839 1798839 IN     school 1800042 9615   Andrew J Brown Academy 180004201816 5488 Andrew J Brown Academy   Regular School Yes Elementary KG 08 2018   grade_6                         26.0 29.0                       55.0                         26 29                 55
1918578 1918578 IN     school 1800042 9615   Andrew J Brown Academy 180004201816 5488 Andrew J Brown Academy   Regular School Yes Elementary KG 08 2020   grade_6                         41.0 34.0                       75.0                         41 34                 75
1930574 1930574 IN     school 1800042 9615   Andrew J Brown Academy 180004201816 5488 Andrew J Brown Academy   Regular School Yes Elementary KG 08 2021   grade_6                         23.0 43.0                       66.0                         23 43                 66
1166886 1166886 IN     school 1800180 5470   Argos Community Schools 180018000047 5936 Argos Community Elementary   Regular School No 1.0 KG 06 2015   grade_6                         26.0 17.0                       43.0                         26 17                 43
1288285 1288285 IN     school 1800180 5470   Argos Community Schools 180018000047 5936 Argos Community Elementary   Regular School No 1.0 PK 06 2016   grade_6                         28.0 28.0                       56.0                         28 28                 56
1300308 1300308 IN     school 1800180 5470   Argos Community Schools 180018000047 5936 Argos Community Elementary   Regular School No Elementary PK 06 2017   grade_6                         25.0 17.0                       42.0                         25 17                 42
1758812 1758812 IN     school 1800180 5470   Argos Community Schools 180018000047 5936 Argos Community Elementary   Regular School No Elementary PK 06 2019   grade_6                         25.0 20.0                       45.0                         25 20                 45
1794625 1794625 IN     school 1800180 5470   Argos Community Schools 180018000047 5936 Argos Community Elementary   Regular School No Elementary PK 06 2018   grade_6                         18.0 23.0                       41.0                         18 23                 41
1914236 1914236 IN     school 1800180 5470   Argos Community Schools 180018000048 5937 Argos Comm Jr-Sr High School   Regular School No High 06 12 2020   grade_6                         23.0 17.0                       40.0                         23 17                 40
1926119 1926119 IN     school 1800180 5470   Argos Community Schools 180018000048 5937 Argos Comm Jr-Sr High School   Regular School No High 06 12 2021   grade_6                         23.0 31.0                       54.0                         23 31                 54
1171164 1171164 IN     school 1800071 9685   Aspire Charter Academy 180007102443 4043 Aspire Charter Academy   Regular School Yes 1.0 KG 08 2015   grade_6                         44.0 31.0                       75.0                         44 31                 75
1292545 1292545 IN     school 1800071 9685   Aspire Charter Academy 180007102443 4043 Aspire Charter Academy   Regular School Yes 1.0 KG 08 2016   grade_6                         44.0 34.0                       78.0                         44 34                 78
1304584 1304584 IN     school 1800071 9685   Aspire Charter Academy 180007102443 4043 Aspire Charter Academy   Regular School Yes Elementary KG 08 2017   grade_6                         41.0 35.0                       76.0                         41 35                 76
1763186 1763186 IN     school 1800071 9685   Aspire Charter Academy 180007102443 4043 Aspire Charter Academy   Regular School Yes Elementary KG 08 2019   grade_6                         37.0 44.0                       81.0                         37 44                 81
1798918 1798918 IN     school 1800071 9685   Aspire Charter Academy 180007102443 4043 Aspire Charter Academy   Regular School Yes Elementary KG 08 2018   grade_6                         37.0 35.0                       72.0                         37 35                 72
1918656 1918656 IN     school 1800071 9685   Aspire Charter Academy 180007102443 4043 Aspire Charter Academy   Regular School Yes Elementary KG 08 2020   grade_6                         36.0 39.0                       75.0                         36 39                 75
1930643 1930643 IN     school 1800071 9685   Aspire Charter Academy 180007102443 4043 Aspire Charter Academy   Regular School Yes Elementary KG 08 2021   grade_6                         45.0 31.0                       76.0                         45 31                 76
1161992 1161992 IN     school 1800210 2435   Attica Consolidated Sch Corp 180021000049 2057 Attica Elementary School   Regular School No 1.0 PK 06 2015   grade_6                         31.0 26.0                       57.0                         31 26                 57
1283403 1283403 IN     school 1800210 2435   Attica Consolidated School Corp 180021000049 2057 Attica Elementary School   Regular School No 1.0 PK 06 2016   grade_6                         14.0 31.0                       45.0                         14 31                 45
1295447 1295447 IN     school 1800210 2435   Attica Consolidated School Corp 180021000049 2057 Attica Elementary School   Regular School No Elementary PK 06 2017   grade_6                         33.0 30.0                       63.0                         33 30                 63
1754046 1754046 IN     school 1800210 2435   Attica Consolidated School Corp 180021000050 2053 Attica High School   Regular School No High 06 12 2019   grade_6                         17.0 16.0                       33.0                         17 16                 33
1789789 1789789 IN     school 1800210 2435   Attica Consolidated School Corp 180021000049 2057 Attica Elementary School   Regular School No Elementary PK 06 2018   grade_6                         23.0 24.0                       47.0                         23 24                 47
1909472 1909472 IN     school 1800210 2435   Attica Consolidated School Corp 180021000050 2053 Attica High School   Regular School No High 06 12 2020   grade_6                         31.0 20.0                       51.0                         31 20                 51
1921434 1921434 IN     school 1800210 2435   Attica Consolidated School Corp 180021000050 2053 Attica High School   Regular School No High 06 12 2021   grade_6                         25.0 24.0                       49.0                         25 24                 49
1163049 1163049 IN     school 1800270 3315   Avon Community School Corp 180027001256 2728 Avon Intermediate School East   Regular School No 2.0 05 06 2015   grade_6                         191.0 183.0                       374.0                         191 183                 374
1163052 1163052 IN     school 1800270 3315   Avon Community School Corp 180027002092 2729 Avon Intermediate School West   Regular School No 2.0 05 06 2015   grade_6                         184.0 181.0                       365.0                         184 181                 365
1284454 1284454 IN     school 1800270 3315   Avon Community School Corp 180027001256 2728 Avon Intermediate School East   Regular School No 2.0 05 06 2016   grade_6                         192.0 176.0                       368.0                         192 176                 368
1284458 1284458 IN     school 1800270 3315   Avon Community School Corp 180027002092 2729 Avon Intermediate School West   Regular School No 2.0 04 06 2016   grade_6                         201.0 173.0                       374.0                         201 173                 374
1296492 1296492 IN     school 1800270 3315   Avon Community School Corp 180027001256 2728 Avon Intermediate School East   Regular School No Middle 05 06 2017   grade_6                         217.0 173.0                       390.0                         217 173                 390
1296496 1296496 IN     school 1800270 3315   Avon Community School Corp 180027002092 2729 Avon Intermediate School West   Regular School No Elementary 04 06 2017   grade_6                         178.0 182.0                       360.0                         178 182                 360
1755107 1755107 IN     school 1800270 3315   Avon Community School Corp 180027001256 2728 Avon Intermediate School East   Regular School No Middle 05 06 2019   grade_6                         191.0 187.0                       378.0                         191 187                 378
1755111 1755111 IN     school 1800270 3315   Avon Community School Corp 180027002092 2729 Avon Intermediate School West   Regular School No Middle 04 06 2019   grade_6                         187.0 201.0                       388.0                         187 201                 388
1790845 1790845 IN     school 1800270 3315   Avon Community School Corp 180027001256 2728 Avon Intermediate School East   Regular School No Middle 05 06 2018   grade_6                         189.0 158.0                       347.0                         189 158                 347
1790848 1790848 IN     school 1800270 3315   Avon Community School Corp 180027002092 2729 Avon Intermediate School West   Regular School No Middle 05 06 2018   grade_6                         198.0 155.0                       353.0                         198 155                 353
1790850 1790850 IN     school 1800270 3315   Avon Community School Corp 180027002450 2730 Avon Middle School North   Regular School No Middle 06 08 2018   grade_6                         1.0 3.0                       4.0                         1 3                 4
1910553 1910553 IN     school 1800270 3315   Avon Community School Corp 180027001256 2728 Avon Intermediate School East   Regular School No Middle 05 06 2020   grade_6                         213.0 172.0                       385.0                         213 172                 385
1910556 1910556 IN     school 1800270 3315   Avon Community School Corp 180027002092 2729 Avon Intermediate School West   Regular School No Middle 05 06 2020   grade_6                         218.0 158.0                       376.0                         218 158                 376
1922503 1922503 IN     school 1800270 3315   Avon Community School Corp 180027001256 2728 Avon Intermediate School East   Regular School No Middle 05 06 2021   grade_6                         215.0 202.0                       417.0                         215 202                 417
1922506 1922506 IN     school 1800270 3315   Avon Community School Corp 180027002092 2729 Avon Intermediate School West   Regular School No Middle 05 07 2021   grade_6                         208.0 201.0                       409.0                         208 201                 409
1922509 1922509 IN     school 1800270 3315   Avon Community School Corp 180027002450 2730 Avon Middle School North   Regular School No Middle 06 08 2021   grade_6                         1.0 0.0                       1.0                         1 0                 1
1762710 1762710 IN     school 1800184 9040   Avondale Meadows Middle School 180018402620 7094 Avondale Meadows Middle School   Regular School Yes Middle 06 08 2019   grade_6                         33.0 35.0                       68.0                         33 35                 68
1798489 1798489 IN     school 1800184 9040   Avondale Meadows Middle School 180018402620 7094 Avondale Meadows Middle School   Regular School Yes Middle 06 07 2018   grade_6                         29.0 28.0                       57.0                         29 28                 57
1918164 1918164 IN     school 1800184 9040   Avondale Meadows Middle School 180018402620 7094 Avondale Meadows Middle School   Regular School Yes Middle 06 08 2020   grade_6                         28.0 33.0                       61.0                         28 33                 61
1930120 1930120 IN     school 1800184 9040   Avondale Meadows Middle School 180018402620 7094 Avondale Meadows Middle School   Regular School Yes Middle 06 08 2021   grade_6                         21.0 27.0                       48.0                         21 27                 48
1160892 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
1282294 1282294 IN     school 1800330 1315   Barr-Reeve Com Schools Inc 180033000061 1069 Barr Reeve Middle/High School   Regular School No 4.0 06 12 2016   grade_6                         25.0 29.0                       54.0                         25 29                 54
1294332 1294332 IN     school 1800330 1315   Barr-Reeve Community Schools Inc 180033000061 1069 Barr Reeve Middle/High School   Regular School No Other 06 12 2017   grade_6                         22.0 39.0                       61.0                         22 39                 61
1752949 1752949 IN     school 1800330 1315   Barr-Reeve Community Schools Inc 180033000061 1069 Barr Reeve Middle/High School   Regular School No High 06 12 2019   grade_6                         38.0 37.0                       75.0                         38 37                 75
1788690 1788690 IN     school 1800330 1315   Barr-Reeve Community Schools Inc 180033000061 1069 Barr Reeve Middle/High School   Regular School No High 06 12 2018   grade_6                         40.0 36.0                       76.0                         40 36                 76
1908380 1908380 IN     school 1800330 1315   Barr-Reeve Community Schools Inc 180033000061 1069 Barr Reeve Middle/High School   Regular School No High 06 12 2020   grade_6                         34.0 46.0                       80.0                         34 46                 80
1920355 1920355 IN     school 1800330 1315   Barr-Reeve Community Schools Inc 180033000061 1069 Barr Reeve Middle/High School   Regular School No High 06 12 2021   grade_6                         43.0 43.0                       86.0                         43 43                 86
1160054 1160054 IN     school 1800360 365   Bartholomew Con School Corp 180036002188 328 Clifty Creek Elementary Sch   Regular School No 1.0 PK 06 2015   grade_6                         24.0 29.0                       53.0                         24 29                 53
1160063 1160063 IN     school 1800360 365   Bartholomew Con School Corp 180036002421 346 CSA Lincoln Campus   Regular School No 1.0 KG 06 2015   grade_6                         20.0 28.0                       48.0                         20 28                 48
1160071 1160071 IN     school 1800360 365   Bartholomew Con School Corp 180036000075 353 Mount Healthy Elementary Sch   Regular School No 1.0 PK 06 2015   grade_6                         33.0 24.0                       57.0                         33 24                 57
1160082 1160082 IN     school 1800360 365   Bartholomew Con School Corp 180036000077 357 Parkside Elementary School   Regular School No 1.0 PK 06 2015   grade_6                         55.0 64.0                       119.0                         55 64                 119
1160091 1160091 IN     school 1800360 365   Bartholomew Con School Corp 180036000082 363 W D Richards Elementary Sch   Regular School No 1.0 PK 06 2015   grade_6                         43.0 31.0                       74.0                         43 31                 74
1160100 1160100 IN     school 1800360 365   Bartholomew Con School Corp 180036000079 366 Rockcreek Elementary School   Regular School No 1.0 PK 06 2015   grade_6                         24.0 29.0                       53.0                         24 29                 53

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