Data source: Big Local News · About: Big Local

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

View and edit SQL

grade

year

  • 2021 · 11,902
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
1924873 IN     school 1800150 5275   Anderson Community School Corp 180015002557 5023 Southview Preschool Center   Regular School No Prekindergarten PK PK 2021   pre_kindergarten                         103.0 64.0                       167.0                         103 64                 167
1924874 IN     school 1800150 5275   Anderson Community School Corp 180015000044 5033 Valley Grove Elementary School   Regular School No Elementary KG 04 2021   grade_1                         43.0 42.0                       85.0                         43 42                 85
1924875 IN     school 1800150 5275   Anderson Community School Corp 180015000044 5033 Valley Grove Elementary School   Regular School No Elementary KG 04 2021   grade_2                         39.0 42.0                       81.0                         39 42                 81
1924876 IN     school 1800150 5275   Anderson Community School Corp 180015000044 5033 Valley Grove Elementary School   Regular School No Elementary KG 04 2021   grade_3                         43.0 30.0                       73.0                         43 30                 73
1924877 IN     school 1800150 5275   Anderson Community School Corp 180015000044 5033 Valley Grove Elementary School   Regular School No Elementary KG 04 2021   grade_4                         40.0 39.0                       79.0                         40 39                 79
1924878 IN     school 1800150 5275   Anderson Community School Corp 180015000044 5033 Valley Grove Elementary School   Regular School No Elementary KG 04 2021   kindergarten                         43.0 40.0                       83.0                         43 40                 83
1924879 IN     school 1800150 5275   Anderson Community School Corp 180015000044 5033 Valley Grove Elementary School   Regular School No Elementary KG 04 2021   pk_12_total 241.0 76.0 38.0               46.0   208.0 193.0     15.0         310.0   65.0   401.0 241 76 38               46   208 193     15     310 65   401
1924880 IN     school 1800150 5275   Anderson Community School Corp 180015002483 5076 Highland Middle School   Regular School No Middle 07 08 2021   grade_7                         258.0 249.0                       507.0                         258 249                 507
1924881 IN     school 1800150 5275   Anderson Community School Corp 180015002483 5076 Highland Middle School   Regular School No Middle 07 08 2021   grade_8                         260.0 236.0                       496.0                         260 236                 496
1924882 IN     school 1800150 5275   Anderson Community School Corp 180015002483 5076 Highland Middle School   Regular School No Middle 07 08 2021   pk_12_total 526.0 214.0 157.0 1.0             105.0   518.0 485.0     51.0         733.0   201.0   1003.0 526 214 157 1             105   518 485     51     733 201   1003
1924883 IN     school 1800150 5275   Anderson Community School Corp 180015002109 5102 Eastside Elementary School   Regular School No Elementary KG 04 2021   grade_1                         49.0 36.0                       85.0                         49 36                 85
1924884 IN     school 1800150 5275   Anderson Community School Corp 180015002109 5102 Eastside Elementary School   Regular School No Elementary KG 04 2021   grade_2                         45.0 56.0                       101.0                         45 56                 101
1924885 IN     school 1800150 5275   Anderson Community School Corp 180015002109 5102 Eastside Elementary School   Regular School No Elementary KG 04 2021   grade_3                         65.0 72.0                       137.0                         65 72                 137
1924886 IN     school 1800150 5275   Anderson Community School Corp 180015002109 5102 Eastside Elementary School   Regular School No Elementary KG 04 2021   grade_4                         55.0 47.0                       102.0                         55 47                 102
1924887 IN     school 1800150 5275   Anderson Community School Corp 180015002109 5102 Eastside Elementary School   Regular School No Elementary KG 04 2021   kindergarten                         48.0 39.0                       87.0                         48 39                 87
1924888 IN     school 1800150 5275   Anderson Community School Corp 180015002109 5102 Eastside Elementary School   Regular School No Elementary KG 04 2021   pk_12_total 321.0 93.0 38.0     6.0         54.0   262.0 250.0     12.0         379.0   127.0   512.0 321 93 38     6         54   262 250     12     379 127   512
1924889 IN     school 1800150 5275   Anderson Community School Corp 180015001847 5142 Anderson Elementary School   Regular School No Elementary KG 04 2021   grade_1                         51.0 30.0                       81.0                         51 30                 81
1924890 IN     school 1800150 5275   Anderson Community School Corp 180015001847 5142 Anderson Elementary School   Regular School No Elementary KG 04 2021   grade_2                         46.0 46.0                       92.0                         46 46                 92
1924891 IN     school 1800150 5275   Anderson Community School Corp 180015001847 5142 Anderson Elementary School   Regular School No Elementary KG 04 2021   grade_3                         44.0 50.0                       94.0                         44 50                 94
1924892 IN     school 1800150 5275   Anderson Community School Corp 180015001847 5142 Anderson Elementary School   Regular School No Elementary KG 04 2021   grade_4                         46.0 42.0                       88.0                         46 42                 88
1924893 IN     school 1800150 5275   Anderson Community School Corp 180015001847 5142 Anderson Elementary School   Regular School No Elementary KG 04 2021   kindergarten                         32.0 31.0                       63.0                         32 31                 63
1924894 IN     school 1800150 5275   Anderson Community School Corp 180015001847 5142 Anderson Elementary School   Regular School No Elementary KG 04 2021   pk_12_total 93.0 108.0 183.0               34.0   219.0 199.0     168.0         361.0   65.0   418.0 93 108 183               34   219 199     168     361 65   418
1924895 IN     school 1800150 5275   Anderson Community School Corp 180015002110 5146 Erskine Elementary School   Regular School No Elementary KG 04 2021   grade_1                         50.0 39.0                       89.0                         50 39                 89
1924896 IN     school 1800150 5275   Anderson Community School Corp 180015002110 5146 Erskine Elementary School   Regular School No Elementary KG 04 2021   grade_2                         44.0 45.0                       89.0                         44 45                 89
1924897 IN     school 1800150 5275   Anderson Community School Corp 180015002110 5146 Erskine Elementary School   Regular School No Elementary KG 04 2021   grade_3                         53.0 34.0                       87.0                         53 34                 87
1924898 IN     school 1800150 5275   Anderson Community School Corp 180015002110 5146 Erskine Elementary School   Regular School No Elementary KG 04 2021   grade_4                         44.0 36.0                       80.0                         44 36                 80
1924899 IN     school 1800150 5275   Anderson Community School Corp 180015002110 5146 Erskine Elementary School   Regular School No Elementary KG 04 2021   kindergarten                         43.0 42.0                       85.0                         43 42                 85
1924900 IN     school 1800150 5275   Anderson Community School Corp 180015002110 5146 Erskine Elementary School   Regular School No Elementary KG 04 2021   pk_12_total 229.0 90.0 48.0     1.0         62.0   234.0 196.0     11.0         344.0   83.0   430.0 229 90 48     1         62   234 196     11     344 83   430
1930714 IN     school 1800077 9790   Anderson Preparatory Academy 180007702425 5092 Anderson Preparatory Academy   Regular School Yes Other KG 12 2021   grade_1                         32.0 25.0                       57.0                         32 25                 57
1930715 IN     school 1800077 9790   Anderson Preparatory Academy 180007702425 5092 Anderson Preparatory Academy   Regular School Yes Other KG 12 2021   grade_10                         30.0 33.0                       63.0                         30 33                 63
1930716 IN     school 1800077 9790   Anderson Preparatory Academy 180007702425 5092 Anderson Preparatory Academy   Regular School Yes Other KG 12 2021   grade_11                         30.0 17.0                       47.0                         30 17                 47
1930717 IN     school 1800077 9790   Anderson Preparatory Academy 180007702425 5092 Anderson Preparatory Academy   Regular School Yes Other KG 12 2021   grade_12                         35.0 27.0                       62.0                         35 27                 62
1930718 IN     school 1800077 9790   Anderson Preparatory Academy 180007702425 5092 Anderson Preparatory Academy   Regular School Yes Other KG 12 2021   grade_2                         38.0 22.0                       60.0                         38 22                 60
1930719 IN     school 1800077 9790   Anderson Preparatory Academy 180007702425 5092 Anderson Preparatory Academy   Regular School Yes Other KG 12 2021   grade_3                         32.0 28.0                       60.0                         32 28                 60
1930720 IN     school 1800077 9790   Anderson Preparatory Academy 180007702425 5092 Anderson Preparatory Academy   Regular School Yes Other KG 12 2021   grade_4                         29.0 25.0                       54.0                         29 25                 54
1930721 IN     school 1800077 9790   Anderson Preparatory Academy 180007702425 5092 Anderson Preparatory Academy   Regular School Yes Other KG 12 2021   grade_5                         36.0 26.0                       62.0                         36 26                 62
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
1930723 IN     school 1800077 9790   Anderson Preparatory Academy 180007702425 5092 Anderson Preparatory Academy   Regular School Yes Other KG 12 2021   grade_7                         46.0 24.0                       70.0                         46 24                 70
1930724 IN     school 1800077 9790   Anderson Preparatory Academy 180007702425 5092 Anderson Preparatory Academy   Regular School Yes Other KG 12 2021   grade_8                         47.0 37.0                       84.0                         47 37                 84
1930725 IN     school 1800077 9790   Anderson Preparatory Academy 180007702425 5092 Anderson Preparatory Academy   Regular School Yes Other KG 12 2021   grade_9                         48.0 38.0                       86.0                         48 38                 86
1930726 IN     school 1800077 9790   Anderson Preparatory Academy 180007702425 5092 Anderson Preparatory Academy   Regular School Yes Other KG 12 2021   kindergarten                         31.0 22.0                       53.0                         31 22                 53
1930727 IN     school 1800077 9790   Anderson Preparatory Academy 180007702425 5092 Anderson Preparatory Academy   Regular School Yes Other KG 12 2021   pk_12_total 479.0 157.0 139.0           1.0   73.0   483.0 366.0     49.0         529.0   207.0   849.0 479 157 139           1   73   483 366     49     529 207   849
1930569 IN     school 1800042 9615   Andrew J Brown Academy 180004201816 5488 Andrew J Brown Academy   Regular School Yes Elementary KG 08 2021   grade_1                         42.0 32.0                       74.0                         42 32                 74
1930570 IN     school 1800042 9615   Andrew J Brown Academy 180004201816 5488 Andrew J Brown Academy   Regular School Yes Elementary KG 08 2021   grade_2                         46.0 32.0                       78.0                         46 32                 78
1930571 IN     school 1800042 9615   Andrew J Brown Academy 180004201816 5488 Andrew J Brown Academy   Regular School Yes Elementary KG 08 2021   grade_3                         41.0 39.0                       80.0                         41 39                 80
1930572 IN     school 1800042 9615   Andrew J Brown Academy 180004201816 5488 Andrew J Brown Academy   Regular School Yes Elementary KG 08 2021   grade_4                         40.0 27.0                       67.0                         40 27                 67
1930573 IN     school 1800042 9615   Andrew J Brown Academy 180004201816 5488 Andrew J Brown Academy   Regular School Yes Elementary KG 08 2021   grade_5                         33.0 42.0                       75.0                         33 42                 75
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
1930575 IN     school 1800042 9615   Andrew J Brown Academy 180004201816 5488 Andrew J Brown Academy   Regular School Yes Elementary KG 08 2021   grade_7                         42.0 39.0                       81.0                         42 39                 81
1930576 IN     school 1800042 9615   Andrew J Brown Academy 180004201816 5488 Andrew J Brown Academy   Regular School Yes Elementary KG 08 2021   grade_8                         35.0 22.0                       57.0                         35 22                 57
1930577 IN     school 1800042 9615   Andrew J Brown Academy 180004201816 5488 Andrew J Brown Academy   Regular School Yes Elementary KG 08 2021   kindergarten                         46.0 45.0                       91.0                         46 45                 91
1930578 IN     school 1800042 9615   Andrew J Brown Academy 180004201816 5488 Andrew J Brown Academy   Regular School Yes Elementary KG 08 2021   pk_12_total 20.0 319.0 297.0           1.0   32.0   348.0 321.0     257.0         648.0   74.0   669.0 20 319 297           1   32   348 321     257     648 74   669
1926107 IN     school 1800180 5470   Argos Community Schools 180018000047 5936 Argos Community Elementary   Regular School No Elementary PK 05 2021   grade_1                         25.0 17.0                       42.0                         25 17                 42
1926108 IN     school 1800180 5470   Argos Community Schools 180018000047 5936 Argos Community Elementary   Regular School No Elementary PK 05 2021   grade_2                         19.0 21.0                       40.0                         19 21                 40
1926109 IN     school 1800180 5470   Argos Community Schools 180018000047 5936 Argos Community Elementary   Regular School No Elementary PK 05 2021   grade_3                         26.0 21.0                       47.0                         26 21                 47
1926110 IN     school 1800180 5470   Argos Community Schools 180018000047 5936 Argos Community Elementary   Regular School No Elementary PK 05 2021   grade_4                         18.0 19.0                       37.0                         18 19                 37
1926111 IN     school 1800180 5470   Argos Community Schools 180018000047 5936 Argos Community Elementary   Regular School No Elementary PK 05 2021   grade_5                         15.0 20.0                       35.0                         15 20                 35
1926112 IN     school 1800180 5470   Argos Community Schools 180018000047 5936 Argos Community Elementary   Regular School No Elementary PK 05 2021   kindergarten                         23.0 24.0                       47.0                         23 24                 47
1926113 IN     school 1800180 5470   Argos Community Schools 180018000047 5936 Argos Community Elementary   Regular School No Elementary PK 05 2021   pk_12_total 242.0 1.0 20.0     1.0         4.0   137.0 131.0     6.0         150.0   65.0   268.0 242 1 20     1         4   137 131     6     150 65   268
1926114 IN     school 1800180 5470   Argos Community Schools 180018000047 5936 Argos Community Elementary   Regular School No Elementary PK 05 2021   pre_kindergarten                         11.0 9.0                       20.0                         11 9                 20
1926115 IN     school 1800180 5470   Argos Community Schools 180018000048 5937 Argos Comm Jr-Sr High School   Regular School No High 06 12 2021   adult                         0.0 2.0                       2.0                         0 2                 2
1926116 IN     school 1800180 5470   Argos Community Schools 180018000048 5937 Argos Comm Jr-Sr High School   Regular School No High 06 12 2021   grade_10                         22.0 16.0                       38.0                         22 16                 38
1926117 IN     school 1800180 5470   Argos Community Schools 180018000048 5937 Argos Comm Jr-Sr High School   Regular School No High 06 12 2021   grade_11                         35.0 29.0                       64.0                         35 29                 64
1926118 IN     school 1800180 5470   Argos Community Schools 180018000048 5937 Argos Comm Jr-Sr High School   Regular School No High 06 12 2021   grade_12                         23.0 25.0                       48.0                         23 25                 48
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
1926120 IN     school 1800180 5470   Argos Community Schools 180018000048 5937 Argos Comm Jr-Sr High School   Regular School No High 06 12 2021   grade_7                         28.0 21.0                       49.0                         28 21                 49
1926121 IN     school 1800180 5470   Argos Community Schools 180018000048 5937 Argos Comm Jr-Sr High School   Regular School No High 06 12 2021   grade_8                         26.0 18.0                       44.0                         26 18                 44
1926122 IN     school 1800180 5470   Argos Community Schools 180018000048 5937 Argos Comm Jr-Sr High School   Regular School No High 06 12 2021   grade_9                         20.0 28.0                       48.0                         20 28                 48
1926123 IN     school 1800180 5470   Argos Community Schools 180018000048 5937 Argos Comm Jr-Sr High School   Regular School No High 06 12 2021   pk_12_total 321.0 3.0 16.0               7.0   177.0 170.0     3.0         162.0   65.0   347.0 321 3 16               7   177 170     3     162 65   347
1930638 IN     school 1800071 9685   Aspire Charter Academy 180007102443 4043 Aspire Charter Academy   Regular School Yes Elementary KG 08 2021   grade_1                         35.0 47.0                       82.0                         35 47                 82
1930639 IN     school 1800071 9685   Aspire Charter Academy 180007102443 4043 Aspire Charter Academy   Regular School Yes Elementary KG 08 2021   grade_2                         42.0 33.0                       75.0                         42 33                 75
1930640 IN     school 1800071 9685   Aspire Charter Academy 180007102443 4043 Aspire Charter Academy   Regular School Yes Elementary KG 08 2021   grade_3                         32.0 35.0                       67.0                         32 35                 67
1930641 IN     school 1800071 9685   Aspire Charter Academy 180007102443 4043 Aspire Charter Academy   Regular School Yes Elementary KG 08 2021   grade_4                         44.0 20.0                       64.0                         44 20                 64
1930642 IN     school 1800071 9685   Aspire Charter Academy 180007102443 4043 Aspire Charter Academy   Regular School Yes Elementary KG 08 2021   grade_5                         39.0 35.0                       74.0                         39 35                 74
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
1930644 IN     school 1800071 9685   Aspire Charter Academy 180007102443 4043 Aspire Charter Academy   Regular School Yes Elementary KG 08 2021   grade_7                         36.0 38.0                       74.0                         36 38                 74
1930645 IN     school 1800071 9685   Aspire Charter Academy 180007102443 4043 Aspire Charter Academy   Regular School Yes Elementary KG 08 2021   grade_8                         20.0 36.0                       56.0                         20 36                 56
1930646 IN     school 1800071 9685   Aspire Charter Academy 180007102443 4043 Aspire Charter Academy   Regular School Yes Elementary KG 08 2021   kindergarten                         47.0 32.0                       79.0                         47 32                 79
1930647 IN     school 1800071 9685   Aspire Charter Academy 180007102443 4043 Aspire Charter Academy   Regular School Yes Elementary KG 08 2021   pk_12_total 7.0 572.0 33.0 1.0             34.0   340.0 307.0     1.0         620.0   86.0   647.0 7 572 33 1             34   340 307     1     620 86   647
1921431 IN     school 1800210 2435   Attica Consolidated School Corp 180021000050 2053 Attica High School   Regular School No High 06 12 2021   grade_10                         31.0 25.0                       56.0                         31 25                 56
1921432 IN     school 1800210 2435   Attica Consolidated School Corp 180021000050 2053 Attica High School   Regular School No High 06 12 2021   grade_11                         18.0 25.0                       43.0                         18 25                 43
1921433 IN     school 1800210 2435   Attica Consolidated School Corp 180021000050 2053 Attica High School   Regular School No High 06 12 2021   grade_12                         21.0 19.0                       40.0                         21 19                 40
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
1921435 IN     school 1800210 2435   Attica Consolidated School Corp 180021000050 2053 Attica High School   Regular School No High 06 12 2021   grade_7                         28.0 20.0                       48.0                         28 20                 48
1921436 IN     school 1800210 2435   Attica Consolidated School Corp 180021000050 2053 Attica High School   Regular School No High 06 12 2021   grade_8                         14.0 21.0                       35.0                         14 21                 35
1921437 IN     school 1800210 2435   Attica Consolidated School Corp 180021000050 2053 Attica High School   Regular School No High 06 12 2021   grade_9                         25.0 19.0                       44.0                         25 19                 44
1921438 IN     school 1800210 2435   Attica Consolidated School Corp 180021000050 2053 Attica High School   Regular School No High 06 12 2021   pk_12_total 289.0 6.0 14.0               6.0   162.0 153.0     3.0         157.0   56.0   315.0 289 6 14               6   162 153     3     157 56   315
1921439 IN     school 1800210 2435   Attica Consolidated School Corp 180021000049 2057 Attica Elementary School   Regular School No Elementary PK 05 2021   grade_1                         18.0 15.0                       33.0                         18 15                 33
1921440 IN     school 1800210 2435   Attica Consolidated School Corp 180021000049 2057 Attica Elementary School   Regular School No Elementary PK 05 2021   grade_2                         25.0 16.0                       41.0                         25 16                 41
1921441 IN     school 1800210 2435   Attica Consolidated School Corp 180021000049 2057 Attica Elementary School   Regular School No Elementary PK 05 2021   grade_3                         25.0 18.0                       43.0                         25 18                 43
1921442 IN     school 1800210 2435   Attica Consolidated School Corp 180021000049 2057 Attica Elementary School   Regular School No Elementary PK 05 2021   grade_4                         30.0 25.0                       55.0                         30 25                 55
1921443 IN     school 1800210 2435   Attica Consolidated School Corp 180021000049 2057 Attica Elementary School   Regular School No Elementary PK 05 2021   grade_5                         24.0 15.0                       39.0                         24 15                 39
1921444 IN     school 1800210 2435   Attica Consolidated School Corp 180021000049 2057 Attica Elementary School   Regular School No Elementary PK 05 2021   kindergarten                         28.0 21.0                       49.0                         28 21                 49
1921445 IN     school 1800210 2435   Attica Consolidated School Corp 180021000049 2057 Attica Elementary School   Regular School No Elementary PK 05 2021   pk_12_total 276.0 2.0 14.0           1.0   5.0   173.0 125.0     10.0         172.0   87.0   298.0 276 2 14           1   5   173 125     10     172 87   298
1921446 IN     school 1800210 2435   Attica Consolidated School Corp 180021000049 2057 Attica Elementary School   Regular School No Elementary PK 05 2021   pre_kindergarten                         23.0 15.0                       38.0                         23 15                 38
1922496 IN     school 1800270 3315   Avon Community School Corp 180027002480 2726 River Birch Elementary School   Regular School No Elementary KG 04 2021   grade_1                         93.0 73.0                       166.0                         93 73                 166
1922497 IN     school 1800270 3315   Avon Community School Corp 180027002480 2726 River Birch Elementary School   Regular School No Elementary KG 04 2021   grade_2                         72.0 73.0                       145.0                         72 73                 145
1922498 IN     school 1800270 3315   Avon Community School Corp 180027002480 2726 River Birch Elementary School   Regular School No Elementary KG 04 2021   grade_3                         80.0 83.0                       163.0                         80 83                 163
1922499 IN     school 1800270 3315   Avon Community School Corp 180027002480 2726 River Birch Elementary School   Regular School No Elementary KG 04 2021   grade_4                         90.0 84.0                       174.0                         90 84                 174
1922500 IN     school 1800270 3315   Avon Community School Corp 180027002480 2726 River Birch Elementary School   Regular School No Elementary KG 04 2021   kindergarten                         70.0 64.0                       134.0                         70 64                 134

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