enrollments

Data source: Big Local News · About: Big Local

6,726 rows where grade = "grade_5" and state = "IN" sorted by district

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_5 · 6,726 ✖
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
1171011 1171011 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_5                         29.0 22.0                       51.0                         29 22                 51
1292388 1292388 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_5                         30.0 26.0                       56.0                         30 26                 56
1304421 1304421 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_5                         38.0 23.0                       61.0                         38 23                 61
1763032 1763032 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_5                         25.0 30.0                       55.0                         25 30                 55
1798762 1798762 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_5                         28.0 34.0                       62.0                         28 34                 62
1918501 1918501 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_5                         44.0 46.0                       90.0                         44 46                 90
1930496 1930496 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_5                         49.0 38.0                       87.0                         49 38                 87
1930905 1930905 IN     school 1800172 9970   ACE Preparatory Academy 180017202604 1111 ACE Preparatory Academy   Regular School Yes Elementary KG 05 2021   grade_5                         6.0 4.0                       10.0                         6 4                 10
1159470 1159470 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary Sch   Regular School No 1.0 KG 05 2015   grade_5                         38.0 40.0                       78.0                         38 40                 78
1280860 1280860 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No 1.0 KG 05 2016   grade_5                         51.0 35.0                       86.0                         51 35                 86
1292922 1292922 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2017   grade_5                         50.0 51.0                       101.0                         50 51                 101
1751554 1751554 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2019   grade_5                         64.0 41.0                       105.0                         64 41                 105
1787295 1787295 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2018   grade_5                         51.0 57.0                       108.0                         51 57                 108
1906995 1906995 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2020   grade_5                         54.0 51.0                       105.0                         54 51                 105
1918961 1918961 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2021   grade_5                         58.0 48.0                       106.0                         58 48                 106
1930221 1930221 IN     school 1800216 9130   Adelante Schools 180021602702 9993 Emma Donnan Elementary and Middle   Regular School Yes Elementary KG 08 2021   grade_5                         15.0 22.0                       37.0                         15 22                 37
1165529 1165529 IN     school 1800120 5265   Alexandria Com School Corp 180012000010 5065 Alexandria-Monroe Intermediate   Regular School No 1.0 03 06 2015   grade_5                         47.0 55.0                       102.0                         47 55                 102
1286925 1286925 IN     school 1800120 5265   Alexandria Community School Corp 180012000010 5065 Alexandria-Monroe Intermediate   Regular School No 1.0 03 06 2016   grade_5                         47.0 59.0                       106.0                         47 59                 106
1298960 1298960 IN     school 1800120 5265   Alexandria Community School Corp 180012000010 5065 Alexandria-Monroe Intermediate   Regular School No Elementary 03 06 2017   grade_5                         71.0 54.0                       125.0                         71 54                 125
1757491 1757491 IN     school 1800120 5265   Alexandria Community School Corp 180012000010 5065 Alexandria-Monroe Intermediate   Regular School No Elementary 03 06 2019   grade_5                         63.0 48.0                       111.0                         63 48                 111
1793282 1793282 IN     school 1800120 5265   Alexandria Community School Corp 180012000010 5065 Alexandria-Monroe Intermediate   Regular School No Elementary 03 06 2018   grade_5                         49.0 51.0                       100.0                         49 51                 100
1912914 1912914 IN     school 1800120 5265   Alexandria Community School Corp 180012000010 5065 Alexandria-Monroe Intermediate   Regular School No Elementary 03 06 2020   grade_5                         68.0 68.0                       136.0                         68 68                 136
1924838 1924838 IN     school 1800120 5265   Alexandria Community School Corp 180012000010 5065 Alexandria Monroe Elementary Schoo   Regular School No Elementary PK 06 2021   grade_5                         74.0 50.0                       124.0                         74 50                 124
1165547 1165547 IN     school 1800150 5275   Anderson Community School Corp 180015000020 4953 Edgewood Elementary School   Regular School No 1.0 KG 05 2015   grade_5                         30.0 34.0                       64.0                         30 34                 64
1165554 1165554 IN     school 1800150 5275   Anderson Community School Corp 180015000041 4977 Tenth Street Elementary Sch   Regular School No 1.0 KG 05 2015   grade_5                         48.0 41.0                       89.0                         48 41                 89
1165563 1165563 IN     school 1800150 5275   Anderson Community School Corp 180015000044 5033 Valley Grove Elementary Sch   Regular School No 1.0 KG 05 2015   grade_5                         54.0 35.0                       89.0                         54 35                 89
1165574 1165574 IN     school 1800150 5275   Anderson Community School Corp 180015002109 5102 Eastside Elementary School   Regular School No 1.0 KG 05 2015   grade_5                         44.0 48.0                       92.0                         44 48                 92
1165581 1165581 IN     school 1800150 5275   Anderson Community School Corp 180015001847 5142 Anderson Elementary School   Regular School No 1.0 KG 05 2015   grade_5                         43.0 38.0                       81.0                         43 38                 81
1165588 1165588 IN     school 1800150 5275   Anderson Community School Corp 180015002110 5146 Erskine Elementary School   Regular School No 1.0 KG 05 2015   grade_5                         34.0 30.0                       64.0                         34 30                 64
1286942 1286942 IN     school 1800150 5275   Anderson Community School Corp 180015000020 4953 Edgewood Elementary School   Regular School No 1.0 KG 05 2016   grade_5                         22.0 17.0                       39.0                         22 17                 39
1286949 1286949 IN     school 1800150 5275   Anderson Community School Corp 180015000041 4977 Tenth Street Elementary School   Regular School No 1.0 KG 05 2016   grade_5                         32.0 39.0                       71.0                         32 39                 71
1286958 1286958 IN     school 1800150 5275   Anderson Community School Corp 180015000044 5033 Valley Grove Elementary School   Regular School No 1.0 KG 05 2016   grade_5                         52.0 44.0                       96.0                         52 44                 96
1286969 1286969 IN     school 1800150 5275   Anderson Community School Corp 180015002109 5102 Eastside Elementary School   Regular School No 1.0 KG 05 2016   grade_5                         70.0 48.0                       118.0                         70 48                 118
1286976 1286976 IN     school 1800150 5275   Anderson Community School Corp 180015001847 5142 Anderson Elementary School   Regular School No 1.0 KG 05 2016   grade_5                         47.0 47.0                       94.0                         47 47                 94
1286983 1286983 IN     school 1800150 5275   Anderson Community School Corp 180015002110 5146 Erskine Elementary School   Regular School No 1.0 KG 05 2016   grade_5                         42.0 35.0                       77.0                         42 35                 77
1298977 1298977 IN     school 1800150 5275   Anderson Community School Corp 180015000020 4953 Edgewood Elementary School   Regular School No Elementary KG 05 2017   grade_5                         18.0 21.0                       39.0                         18 21                 39
1298984 1298984 IN     school 1800150 5275   Anderson Community School Corp 180015000041 4977 Tenth Street Elementary School   Regular School No Elementary KG 05 2017   grade_5                         46.0 47.0                       93.0                         46 47                 93
1298993 1298993 IN     school 1800150 5275   Anderson Community School Corp 180015000044 5033 Valley Grove Elementary School   Regular School No Elementary KG 05 2017   grade_5                         52.0 40.0                       92.0                         52 40                 92
1299004 1299004 IN     school 1800150 5275   Anderson Community School Corp 180015002109 5102 Eastside Elementary School   Regular School No Elementary KG 05 2017   grade_5                         54.0 52.0                       106.0                         54 52                 106
1299011 1299011 IN     school 1800150 5275   Anderson Community School Corp 180015001847 5142 Anderson Elementary School   Regular School No Elementary KG 05 2017   grade_5                         46.0 57.0                       103.0                         46 57                 103
1299018 1299018 IN     school 1800150 5275   Anderson Community School Corp 180015002110 5146 Erskine Elementary School   Regular School No Elementary KG 05 2017   grade_5                         46.0 45.0                       91.0                         46 45                 91
1757514 1757514 IN     school 1800150 5275   Anderson Community School Corp 180015000020 4953 Edgewood Elementary School   Regular School No Elementary KG 05 2019   grade_5                         29.0 22.0                       51.0                         29 22                 51
1757521 1757521 IN     school 1800150 5275   Anderson Community School Corp 180015000041 4977 Tenth Street Elementary School   Regular School No Elementary KG 05 2019   grade_5                         44.0 48.0                       92.0                         44 48                 92
1757530 1757530 IN     school 1800150 5275   Anderson Community School Corp 180015000044 5033 Valley Grove Elementary School   Regular School No Elementary KG 05 2019   grade_5                         48.0 48.0                       96.0                         48 48                 96
1757541 1757541 IN     school 1800150 5275   Anderson Community School Corp 180015002109 5102 Eastside Elementary School   Regular School No Elementary KG 05 2019   grade_5                         59.0 55.0                       114.0                         59 55                 114
1757548 1757548 IN     school 1800150 5275   Anderson Community School Corp 180015001847 5142 Anderson Elementary School   Regular School No Elementary KG 05 2019   grade_5                         65.0 49.0                       114.0                         65 49                 114
1757555 1757555 IN     school 1800150 5275   Anderson Community School Corp 180015002110 5146 Erskine Elementary School   Regular School No Elementary KG 05 2019   grade_5                         44.0 51.0                       95.0                         44 51                 95
1793304 1793304 IN     school 1800150 5275   Anderson Community School Corp 180015000020 4953 Edgewood Elementary School   Regular School No Elementary KG 05 2018   grade_5                         24.0 18.0                       42.0                         24 18                 42
1793311 1793311 IN     school 1800150 5275   Anderson Community School Corp 180015000041 4977 Tenth Street Elementary School   Regular School No Elementary KG 05 2018   grade_5                         59.0 49.0                       108.0                         59 49                 108
1793320 1793320 IN     school 1800150 5275   Anderson Community School Corp 180015000044 5033 Valley Grove Elementary School   Regular School No Elementary KG 05 2018   grade_5                         54.0 42.0                       96.0                         54 42                 96
1793331 1793331 IN     school 1800150 5275   Anderson Community School Corp 180015002109 5102 Eastside Elementary School   Regular School No Elementary KG 05 2018   grade_5                         72.0 64.0                       136.0                         72 64                 136
1793338 1793338 IN     school 1800150 5275   Anderson Community School Corp 180015001847 5142 Anderson Elementary School   Regular School No Elementary KG 05 2018   grade_5                         49.0 62.0                       111.0                         49 62                 111
1793345 1793345 IN     school 1800150 5275   Anderson Community School Corp 180015002110 5146 Erskine Elementary School   Regular School No Elementary KG 05 2018   grade_5                         48.0 40.0                       88.0                         48 40                 88
1912938 1912938 IN     school 1800150 5275   Anderson Community School Corp 180015002682 4967 Anderson Intermediate School   Regular School No Middle 05 06 2020   grade_5                         276.0 253.0                       529.0                         276 253                 529
1924863 1924863 IN     school 1800150 5275   Anderson Community School Corp 180015002682 4967 Anderson Intermediate School   Regular School No Middle 05 06 2021   grade_5                         270.0 244.0                       514.0                         270 244                 514
1171304 1171304 IN     school 1800077 9790   Anderson Preparatory Academy 180007702425 5092 Anderson Preparatory Academy   Regular School Yes 4.0 KG 12 2015   grade_5                         30.0 12.0                       42.0                         30 12                 42
1292664 1292664 IN     school 1800077 9790   Anderson Preparatory Academy 180007702425 5092 Anderson Preparatory Academy   Regular School Yes 4.0 KG 12 2016   grade_5                         29.0 24.0                       53.0                         29 24                 53
1304704 1304704 IN     school 1800077 9790   Anderson Preparatory Academy 180007702425 5092 Anderson Preparatory Academy   Regular School Yes Other KG 12 2017   grade_5                         34.0 24.0                       58.0                         34 24                 58
1763286 1763286 IN     school 1800077 9790   Anderson Preparatory Academy 180007702425 5092 Anderson Preparatory Academy   Regular School Yes Other KG 12 2019   grade_5                         29.0 24.0                       53.0                         29 24                 53
1799031 1799031 IN     school 1800077 9790   Anderson Preparatory Academy 180007702425 5092 Anderson Preparatory Academy   Regular School Yes Other KG 12 2018   grade_5                         31.0 21.0                       52.0                         31 21                 52
1918733 1918733 IN     school 1800077 9790   Anderson Preparatory Academy 180007702425 5092 Anderson Preparatory Academy   Regular School Yes Other KG 12 2020   grade_5                         43.0 29.0                       72.0                         43 29                 72
1930721 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
1171191 1171191 IN     school 1800092 9715   Andrew Academy 180009202493 5785 Andrew Academy   Regular School Yes 1.0 KG 08 2015   grade_5                         8.0 10.0                       18.0                         8 10                 18
1171086 1171086 IN     school 1800042 9615   Andrew J Brown Academy 180004201816 5488 Andrew J Brown Academy   Regular School Yes 1.0 KG 08 2015   grade_5                         38.0 28.0                       66.0                         38 28                 66
1292463 1292463 IN     school 1800042 9615   Andrew J Brown Academy 180004201816 5488 Andrew J Brown Academy   Regular School Yes 1.0 KG 08 2016   grade_5                         38.0 41.0                       79.0                         38 41                 79
1304496 1304496 IN     school 1800042 9615   Andrew J Brown Academy 180004201816 5488 Andrew J Brown Academy   Regular School Yes Elementary KG 08 2017   grade_5                         39.0 36.0                       75.0                         39 36                 75
1763108 1763108 IN     school 1800042 9615   Andrew J Brown Academy 180004201816 5488 Andrew J Brown Academy   Regular School Yes Elementary KG 08 2019   grade_5                         40.0 27.0                       67.0                         40 27                 67
1798838 1798838 IN     school 1800042 9615   Andrew J Brown Academy 180004201816 5488 Andrew J Brown Academy   Regular School Yes Elementary KG 08 2018   grade_5                         38.0 38.0                       76.0                         38 38                 76
1918577 1918577 IN     school 1800042 9615   Andrew J Brown Academy 180004201816 5488 Andrew J Brown Academy   Regular School Yes Elementary KG 08 2020   grade_5                         32.0 45.0                       77.0                         32 45                 77
1930573 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
1166885 1166885 IN     school 1800180 5470   Argos Community Schools 180018000047 5936 Argos Community Elementary   Regular School No 1.0 KG 06 2015   grade_5                         25.0 25.0                       50.0                         25 25                 50
1288284 1288284 IN     school 1800180 5470   Argos Community Schools 180018000047 5936 Argos Community Elementary   Regular School No 1.0 PK 06 2016   grade_5                         23.0 16.0                       39.0                         23 16                 39
1300307 1300307 IN     school 1800180 5470   Argos Community Schools 180018000047 5936 Argos Community Elementary   Regular School No Elementary PK 06 2017   grade_5                         16.0 22.0                       38.0                         16 22                 38
1758811 1758811 IN     school 1800180 5470   Argos Community Schools 180018000047 5936 Argos Community Elementary   Regular School No Elementary PK 06 2019   grade_5                         26.0 18.0                       44.0                         26 18                 44
1794624 1794624 IN     school 1800180 5470   Argos Community Schools 180018000047 5936 Argos Community Elementary   Regular School No Elementary PK 06 2018   grade_5                         25.0 21.0                       46.0                         25 21                 46
1914229 1914229 IN     school 1800180 5470   Argos Community Schools 180018000047 5936 Argos Community Elementary   Regular School No Elementary PK 05 2020   grade_5                         24.0 32.0                       56.0                         24 32                 56
1926111 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
1171163 1171163 IN     school 1800071 9685   Aspire Charter Academy 180007102443 4043 Aspire Charter Academy   Regular School Yes 1.0 KG 08 2015   grade_5                         41.0 39.0                       80.0                         41 39                 80
1292544 1292544 IN     school 1800071 9685   Aspire Charter Academy 180007102443 4043 Aspire Charter Academy   Regular School Yes 1.0 KG 08 2016   grade_5                         43.0 36.0                       79.0                         43 36                 79
1304583 1304583 IN     school 1800071 9685   Aspire Charter Academy 180007102443 4043 Aspire Charter Academy   Regular School Yes Elementary KG 08 2017   grade_5                         42.0 37.0                       79.0                         42 37                 79
1763185 1763185 IN     school 1800071 9685   Aspire Charter Academy 180007102443 4043 Aspire Charter Academy   Regular School Yes Elementary KG 08 2019   grade_5                         43.0 38.0                       81.0                         43 38                 81
1798917 1798917 IN     school 1800071 9685   Aspire Charter Academy 180007102443 4043 Aspire Charter Academy   Regular School Yes Elementary KG 08 2018   grade_5                         37.0 42.0                       79.0                         37 42                 79
1918655 1918655 IN     school 1800071 9685   Aspire Charter Academy 180007102443 4043 Aspire Charter Academy   Regular School Yes Elementary KG 08 2020   grade_5                         38.0 32.0                       70.0                         38 32                 70
1930642 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
1161991 1161991 IN     school 1800210 2435   Attica Consolidated Sch Corp 180021000049 2057 Attica Elementary School   Regular School No 1.0 PK 06 2015   grade_5                         16.0 28.0                       44.0                         16 28                 44
1283402 1283402 IN     school 1800210 2435   Attica Consolidated School Corp 180021000049 2057 Attica Elementary School   Regular School No 1.0 PK 06 2016   grade_5                         36.0 31.0                       67.0                         36 31                 67
1295446 1295446 IN     school 1800210 2435   Attica Consolidated School Corp 180021000049 2057 Attica Elementary School   Regular School No Elementary PK 06 2017   grade_5                         25.0 30.0                       55.0                         25 30                 55
1754055 1754055 IN     school 1800210 2435   Attica Consolidated School Corp 180021000049 2057 Attica Elementary School   Regular School No Elementary PK 05 2019   grade_5                         27.0 24.0                       51.0                         27 24                 51
1789788 1789788 IN     school 1800210 2435   Attica Consolidated School Corp 180021000049 2057 Attica Elementary School   Regular School No Elementary PK 06 2018   grade_5                         20.0 14.0                       34.0                         20 14                 34
1909481 1909481 IN     school 1800210 2435   Attica Consolidated School Corp 180021000049 2057 Attica Elementary School   Regular School No Elementary PK 05 2020   grade_5                         25.0 24.0                       49.0                         25 24                 49
1921443 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
1163048 1163048 IN     school 1800270 3315   Avon Community School Corp 180027001256 2728 Avon Intermediate School East   Regular School No 2.0 05 06 2015   grade_5                         200.0 179.0                       379.0                         200 179                 379
1163051 1163051 IN     school 1800270 3315   Avon Community School Corp 180027002092 2729 Avon Intermediate School West   Regular School No 2.0 05 06 2015   grade_5                         179.0 165.0                       344.0                         179 165                 344
1284453 1284453 IN     school 1800270 3315   Avon Community School Corp 180027001256 2728 Avon Intermediate School East   Regular School No 2.0 05 06 2016   grade_5                         210.0 166.0                       376.0                         210 166                 376
1284457 1284457 IN     school 1800270 3315   Avon Community School Corp 180027002092 2729 Avon Intermediate School West   Regular School No 2.0 04 06 2016   grade_5                         164.0 180.0                       344.0                         164 180                 344
1296491 1296491 IN     school 1800270 3315   Avon Community School Corp 180027001256 2728 Avon Intermediate School East   Regular School No Middle 05 06 2017   grade_5                         198.0 149.0                       347.0                         198 149                 347
1296495 1296495 IN     school 1800270 3315   Avon Community School Corp 180027002092 2729 Avon Intermediate School West   Regular School No Elementary 04 06 2017   grade_5                         198.0 159.0                       357.0                         198 159                 357
1755106 1755106 IN     school 1800270 3315   Avon Community School Corp 180027001256 2728 Avon Intermediate School East   Regular School No Middle 05 06 2019   grade_5                         209.0 158.0                       367.0                         209 158                 367
1755110 1755110 IN     school 1800270 3315   Avon Community School Corp 180027002092 2729 Avon Intermediate School West   Regular School No Middle 04 06 2019   grade_5                         208.0 162.0                       370.0                         208 162                 370
1790844 1790844 IN     school 1800270 3315   Avon Community School Corp 180027001256 2728 Avon Intermediate School East   Regular School No Middle 05 06 2018   grade_5                         192.0 197.0                       389.0                         192 197                 389

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