enrollments

Data source: Big Local News · About: Big Local

7,343 rows where grade = "grade_4" and state = "IN" sorted by district

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_4 · 7,343 ✖
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
1171010 1171010 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_4                         30.0 26.0                       56.0                         30 26                 56
1292387 1292387 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_4                         33.0 24.0                       57.0                         33 24                 57
1304420 1304420 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_4                         24.0 36.0                       60.0                         24 36                 60
1763031 1763031 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_4                         36.0 33.0                       69.0                         36 33                 69
1798761 1798761 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_4                         34.0 38.0                       72.0                         34 38                 72
1918500 1918500 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_4                         46.0 38.0                       84.0                         46 38                 84
1930495 1930495 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_4                         50.0 47.0                       97.0                         50 47                 97
1918906 1918906 IN     school 1800172 9970   ACE Preparatory Academy 180017202604 1111 ACE Preparatory Academy   Regular School Yes Elementary KG 04 2020   grade_4                         9.0 5.0                       14.0                         9 5                 14
1930904 1930904 IN     school 1800172 9970   ACE Preparatory Academy 180017202604 1111 ACE Preparatory Academy   Regular School Yes Elementary KG 05 2021   grade_4                         8.0 9.0                       17.0                         8 9                 17
1159469 1159469 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary Sch   Regular School No 1.0 KG 05 2015   grade_4                         52.0 35.0                       87.0                         52 35                 87
1280859 1280859 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No 1.0 KG 05 2016   grade_4                         50.0 51.0                       101.0                         50 51                 101
1292921 1292921 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2017   grade_4                         51.0 52.0                       103.0                         51 52                 103
1751553 1751553 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2019   grade_4                         54.0 52.0                       106.0                         54 52                 106
1787294 1787294 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2018   grade_4                         63.0 38.0                       101.0                         63 38                 101
1906994 1906994 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2020   grade_4                         52.0 44.0                       96.0                         52 44                 96
1918960 1918960 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2021   grade_4                         58.0 41.0                       99.0                         58 41                 99
1930220 1930220 IN     school 1800216 9130   Adelante Schools 180021602702 9993 Emma Donnan Elementary and Middle   Regular School Yes Elementary KG 08 2021   grade_4                         20.0 15.0                       35.0                         20 15                 35
1165528 1165528 IN     school 1800120 5265   Alexandria Com School Corp 180012000010 5065 Alexandria-Monroe Intermediate   Regular School No 1.0 03 06 2015   grade_4                         47.0 57.0                       104.0                         47 57                 104
1286924 1286924 IN     school 1800120 5265   Alexandria Community School Corp 180012000010 5065 Alexandria-Monroe Intermediate   Regular School No 1.0 03 06 2016   grade_4                         65.0 43.0                       108.0                         65 43                 108
1298959 1298959 IN     school 1800120 5265   Alexandria Community School Corp 180012000010 5065 Alexandria-Monroe Intermediate   Regular School No Elementary 03 06 2017   grade_4                         54.0 51.0                       105.0                         54 51                 105
1757490 1757490 IN     school 1800120 5265   Alexandria Community School Corp 180012000010 5065 Alexandria-Monroe Intermediate   Regular School No Elementary 03 06 2019   grade_4                         65.0 67.0                       132.0                         65 67                 132
1793281 1793281 IN     school 1800120 5265   Alexandria Community School Corp 180012000010 5065 Alexandria-Monroe Intermediate   Regular School No Elementary 03 06 2018   grade_4                         63.0 42.0                       105.0                         63 42                 105
1912913 1912913 IN     school 1800120 5265   Alexandria Community School Corp 180012000010 5065 Alexandria-Monroe Intermediate   Regular School No Elementary 03 06 2020   grade_4                         74.0 57.0                       131.0                         74 57                 131
1924837 1924837 IN     school 1800120 5265   Alexandria Community School Corp 180012000010 5065 Alexandria Monroe Elementary Schoo   Regular School No Elementary PK 06 2021   grade_4                         61.0 54.0                       115.0                         61 54                 115
1165546 1165546 IN     school 1800150 5275   Anderson Community School Corp 180015000020 4953 Edgewood Elementary School   Regular School No 1.0 KG 05 2015   grade_4                         22.0 31.0                       53.0                         22 31                 53
1165553 1165553 IN     school 1800150 5275   Anderson Community School Corp 180015000041 4977 Tenth Street Elementary Sch   Regular School No 1.0 KG 05 2015   grade_4                         46.0 56.0                       102.0                         46 56                 102
1165562 1165562 IN     school 1800150 5275   Anderson Community School Corp 180015000044 5033 Valley Grove Elementary Sch   Regular School No 1.0 KG 05 2015   grade_4                         54.0 43.0                       97.0                         54 43                 97
1165573 1165573 IN     school 1800150 5275   Anderson Community School Corp 180015002109 5102 Eastside Elementary School   Regular School No 1.0 KG 05 2015   grade_4                         56.0 36.0                       92.0                         56 36                 92
1165580 1165580 IN     school 1800150 5275   Anderson Community School Corp 180015001847 5142 Anderson Elementary School   Regular School No 1.0 KG 05 2015   grade_4                         47.0 42.0                       89.0                         47 42                 89
1165587 1165587 IN     school 1800150 5275   Anderson Community School Corp 180015002110 5146 Erskine Elementary School   Regular School No 1.0 KG 05 2015   grade_4                         42.0 37.0                       79.0                         42 37                 79
1286941 1286941 IN     school 1800150 5275   Anderson Community School Corp 180015000020 4953 Edgewood Elementary School   Regular School No 1.0 KG 05 2016   grade_4                         17.0 26.0                       43.0                         17 26                 43
1286948 1286948 IN     school 1800150 5275   Anderson Community School Corp 180015000041 4977 Tenth Street Elementary School   Regular School No 1.0 KG 05 2016   grade_4                         45.0 46.0                       91.0                         45 46                 91
1286957 1286957 IN     school 1800150 5275   Anderson Community School Corp 180015000044 5033 Valley Grove Elementary School   Regular School No 1.0 KG 05 2016   grade_4                         53.0 48.0                       101.0                         53 48                 101
1286968 1286968 IN     school 1800150 5275   Anderson Community School Corp 180015002109 5102 Eastside Elementary School   Regular School No 1.0 KG 05 2016   grade_4                         55.0 41.0                       96.0                         55 41                 96
1286975 1286975 IN     school 1800150 5275   Anderson Community School Corp 180015001847 5142 Anderson Elementary School   Regular School No 1.0 KG 05 2016   grade_4                         48.0 53.0                       101.0                         48 53                 101
1286982 1286982 IN     school 1800150 5275   Anderson Community School Corp 180015002110 5146 Erskine Elementary School   Regular School No 1.0 KG 05 2016   grade_4                         37.0 41.0                       78.0                         37 41                 78
1298976 1298976 IN     school 1800150 5275   Anderson Community School Corp 180015000020 4953 Edgewood Elementary School   Regular School No Elementary KG 05 2017   grade_4                         17.0 23.0                       40.0                         17 23                 40
1298983 1298983 IN     school 1800150 5275   Anderson Community School Corp 180015000041 4977 Tenth Street Elementary School   Regular School No Elementary KG 05 2017   grade_4                         58.0 45.0                       103.0                         58 45                 103
1298992 1298992 IN     school 1800150 5275   Anderson Community School Corp 180015000044 5033 Valley Grove Elementary School   Regular School No Elementary KG 05 2017   grade_4                         49.0 48.0                       97.0                         49 48                 97
1299003 1299003 IN     school 1800150 5275   Anderson Community School Corp 180015002109 5102 Eastside Elementary School   Regular School No Elementary KG 05 2017   grade_4                         72.0 53.0                       125.0                         72 53                 125
1299010 1299010 IN     school 1800150 5275   Anderson Community School Corp 180015001847 5142 Anderson Elementary School   Regular School No Elementary KG 05 2017   grade_4                         49.0 57.0                       106.0                         49 57                 106
1299017 1299017 IN     school 1800150 5275   Anderson Community School Corp 180015002110 5146 Erskine Elementary School   Regular School No Elementary KG 05 2017   grade_4                         49.0 46.0                       95.0                         49 46                 95
1757513 1757513 IN     school 1800150 5275   Anderson Community School Corp 180015000020 4953 Edgewood Elementary School   Regular School No Elementary KG 05 2019   grade_4                         23.0 28.0                       51.0                         23 28                 51
1757520 1757520 IN     school 1800150 5275   Anderson Community School Corp 180015000041 4977 Tenth Street Elementary School   Regular School No Elementary KG 05 2019   grade_4                         58.0 37.0                       95.0                         58 37                 95
1757529 1757529 IN     school 1800150 5275   Anderson Community School Corp 180015000044 5033 Valley Grove Elementary School   Regular School No Elementary KG 05 2019   grade_4                         61.0 36.0                       97.0                         61 36                 97
1757540 1757540 IN     school 1800150 5275   Anderson Community School Corp 180015002109 5102 Eastside Elementary School   Regular School No Elementary KG 05 2019   grade_4                         46.0 58.0                       104.0                         46 58                 104
1757547 1757547 IN     school 1800150 5275   Anderson Community School Corp 180015001847 5142 Anderson Elementary School   Regular School No Elementary KG 05 2019   grade_4                         57.0 56.0                       113.0                         57 56                 113
1757554 1757554 IN     school 1800150 5275   Anderson Community School Corp 180015002110 5146 Erskine Elementary School   Regular School No Elementary KG 05 2019   grade_4                         47.0 44.0                       91.0                         47 44                 91
1793303 1793303 IN     school 1800150 5275   Anderson Community School Corp 180015000020 4953 Edgewood Elementary School   Regular School No Elementary KG 05 2018   grade_4                         29.0 28.0                       57.0                         29 28                 57
1793310 1793310 IN     school 1800150 5275   Anderson Community School Corp 180015000041 4977 Tenth Street Elementary School   Regular School No Elementary KG 05 2018   grade_4                         51.0 44.0                       95.0                         51 44                 95
1793319 1793319 IN     school 1800150 5275   Anderson Community School Corp 180015000044 5033 Valley Grove Elementary School   Regular School No Elementary KG 05 2018   grade_4                         54.0 43.0                       97.0                         54 43                 97
1793330 1793330 IN     school 1800150 5275   Anderson Community School Corp 180015002109 5102 Eastside Elementary School   Regular School No Elementary KG 05 2018   grade_4                         62.0 51.0                       113.0                         62 51                 113
1793337 1793337 IN     school 1800150 5275   Anderson Community School Corp 180015001847 5142 Anderson Elementary School   Regular School No Elementary KG 05 2018   grade_4                         61.0 49.0                       110.0                         61 49                 110
1793344 1793344 IN     school 1800150 5275   Anderson Community School Corp 180015002110 5146 Erskine Elementary School   Regular School No Elementary KG 05 2018   grade_4                         44.0 54.0                       98.0                         44 54                 98
1912935 1912935 IN     school 1800150 5275   Anderson Community School Corp 180015000020 4953 Edgewood Elementary School   Regular School No Elementary KG 04 2020   grade_4                         24.0 15.0                       39.0                         24 15                 39
1912944 1912944 IN     school 1800150 5275   Anderson Community School Corp 180015000041 4977 Tenth Street Elementary School   Regular School No Elementary KG 04 2020   grade_4                         56.0 41.0                       97.0                         56 41                 97
1912952 1912952 IN     school 1800150 5275   Anderson Community School Corp 180015000044 5033 Valley Grove Elementary School   Regular School No Elementary KG 04 2020   grade_4                         54.0 46.0                       100.0                         54 46                 100
1912961 1912961 IN     school 1800150 5275   Anderson Community School Corp 180015002109 5102 Eastside Elementary School   Regular School No Elementary KG 04 2020   grade_4                         54.0 41.0                       95.0                         54 41                 95
1912967 1912967 IN     school 1800150 5275   Anderson Community School Corp 180015001847 5142 Anderson Elementary School   Regular School No Elementary KG 04 2020   grade_4                         46.0 45.0                       91.0                         46 45                 91
1912973 1912973 IN     school 1800150 5275   Anderson Community School Corp 180015002110 5146 Erskine Elementary School   Regular School No Elementary KG 04 2020   grade_4                         59.0 54.0                       113.0                         59 54                 113
1924860 1924860 IN     school 1800150 5275   Anderson Community School Corp 180015000020 4953 Edgewood Elementary School   Regular School No Elementary KG 04 2021   grade_4                         21.0 21.0                       42.0                         21 21                 42
1924869 1924869 IN     school 1800150 5275   Anderson Community School Corp 180015000041 4977 Tenth Street Elementary School   Regular School No Elementary KG 04 2021   grade_4                         74.0 58.0                       132.0                         74 58                 132
1924877 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
1924886 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
1924892 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
1924898 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
1171303 1171303 IN     school 1800077 9790   Anderson Preparatory Academy 180007702425 5092 Anderson Preparatory Academy   Regular School Yes 4.0 KG 12 2015   grade_4                         32.0 28.0                       60.0                         32 28                 60
1292663 1292663 IN     school 1800077 9790   Anderson Preparatory Academy 180007702425 5092 Anderson Preparatory Academy   Regular School Yes 4.0 KG 12 2016   grade_4                         32.0 29.0                       61.0                         32 29                 61
1304703 1304703 IN     school 1800077 9790   Anderson Preparatory Academy 180007702425 5092 Anderson Preparatory Academy   Regular School Yes Other KG 12 2017   grade_4                         34.0 21.0                       55.0                         34 21                 55
1763285 1763285 IN     school 1800077 9790   Anderson Preparatory Academy 180007702425 5092 Anderson Preparatory Academy   Regular School Yes Other KG 12 2019   grade_4                         33.0 29.0                       62.0                         33 29                 62
1799030 1799030 IN     school 1800077 9790   Anderson Preparatory Academy 180007702425 5092 Anderson Preparatory Academy   Regular School Yes Other KG 12 2018   grade_4                         36.0 17.0                       53.0                         36 17                 53
1918732 1918732 IN     school 1800077 9790   Anderson Preparatory Academy 180007702425 5092 Anderson Preparatory Academy   Regular School Yes Other KG 12 2020   grade_4                         23.0 20.0                       43.0                         23 20                 43
1930720 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
1171190 1171190 IN     school 1800092 9715   Andrew Academy 180009202493 5785 Andrew Academy   Regular School Yes 1.0 KG 08 2015   grade_4                         18.0 9.0                       27.0                         18 9                 27
1171085 1171085 IN     school 1800042 9615   Andrew J Brown Academy 180004201816 5488 Andrew J Brown Academy   Regular School Yes 1.0 KG 08 2015   grade_4                         26.0 50.0                       76.0                         26 50                 76
1292462 1292462 IN     school 1800042 9615   Andrew J Brown Academy 180004201816 5488 Andrew J Brown Academy   Regular School Yes 1.0 KG 08 2016   grade_4                         30.0 28.0                       58.0                         30 28                 58
1304495 1304495 IN     school 1800042 9615   Andrew J Brown Academy 180004201816 5488 Andrew J Brown Academy   Regular School Yes Elementary KG 08 2017   grade_4                         37.0 37.0                       74.0                         37 37                 74
1763107 1763107 IN     school 1800042 9615   Andrew J Brown Academy 180004201816 5488 Andrew J Brown Academy   Regular School Yes Elementary KG 08 2019   grade_4                         28.0 48.0                       76.0                         28 48                 76
1798837 1798837 IN     school 1800042 9615   Andrew J Brown Academy 180004201816 5488 Andrew J Brown Academy   Regular School Yes Elementary KG 08 2018   grade_4                         34.0 31.0                       65.0                         34 31                 65
1918576 1918576 IN     school 1800042 9615   Andrew J Brown Academy 180004201816 5488 Andrew J Brown Academy   Regular School Yes Elementary KG 08 2020   grade_4                         46.0 39.0                       85.0                         46 39                 85
1930572 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
1166884 1166884 IN     school 1800180 5470   Argos Community Schools 180018000047 5936 Argos Community Elementary   Regular School No 1.0 KG 06 2015   grade_4                         24.0 13.0                       37.0                         24 13                 37
1288283 1288283 IN     school 1800180 5470   Argos Community Schools 180018000047 5936 Argos Community Elementary   Regular School No 1.0 PK 06 2016   grade_4                         18.0 23.0                       41.0                         18 23                 41
1300306 1300306 IN     school 1800180 5470   Argos Community Schools 180018000047 5936 Argos Community Elementary   Regular School No Elementary PK 06 2017   grade_4                         23.0 19.0                       42.0                         23 19                 42
1758810 1758810 IN     school 1800180 5470   Argos Community Schools 180018000047 5936 Argos Community Elementary   Regular School No Elementary PK 06 2019   grade_4                         24.0 35.0                       59.0                         24 35                 59
1794623 1794623 IN     school 1800180 5470   Argos Community Schools 180018000047 5936 Argos Community Elementary   Regular School No Elementary PK 06 2018   grade_4                         24.0 21.0                       45.0                         24 21                 45
1914228 1914228 IN     school 1800180 5470   Argos Community Schools 180018000047 5936 Argos Community Elementary   Regular School No Elementary PK 05 2020   grade_4                         15.0 17.0                       32.0                         15 17                 32
1926110 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
1171162 1171162 IN     school 1800071 9685   Aspire Charter Academy 180007102443 4043 Aspire Charter Academy   Regular School Yes 1.0 KG 08 2015   grade_4                         42.0 36.0                       78.0                         42 36                 78
1292543 1292543 IN     school 1800071 9685   Aspire Charter Academy 180007102443 4043 Aspire Charter Academy   Regular School Yes 1.0 KG 08 2016   grade_4                         50.0 33.0                       83.0                         50 33                 83
1304582 1304582 IN     school 1800071 9685   Aspire Charter Academy 180007102443 4043 Aspire Charter Academy   Regular School Yes Elementary KG 08 2017   grade_4                         34.0 40.0                       74.0                         34 40                 74
1763184 1763184 IN     school 1800071 9685   Aspire Charter Academy 180007102443 4043 Aspire Charter Academy   Regular School Yes Elementary KG 08 2019   grade_4                         40.0 35.0                       75.0                         40 35                 75
1798916 1798916 IN     school 1800071 9685   Aspire Charter Academy 180007102443 4043 Aspire Charter Academy   Regular School Yes Elementary KG 08 2018   grade_4                         43.0 38.0                       81.0                         43 38                 81
1918654 1918654 IN     school 1800071 9685   Aspire Charter Academy 180007102443 4043 Aspire Charter Academy   Regular School Yes Elementary KG 08 2020   grade_4                         44.0 31.0                       75.0                         44 31                 75
1930641 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
1161990 1161990 IN     school 1800210 2435   Attica Consolidated Sch Corp 180021000049 2057 Attica Elementary School   Regular School No 1.0 PK 06 2015   grade_4                         37.0 32.0                       69.0                         37 32                 69
1283401 1283401 IN     school 1800210 2435   Attica Consolidated School Corp 180021000049 2057 Attica Elementary School   Regular School No 1.0 PK 06 2016   grade_4                         34.0 28.0                       62.0                         34 28                 62
1295445 1295445 IN     school 1800210 2435   Attica Consolidated School Corp 180021000049 2057 Attica Elementary School   Regular School No Elementary PK 06 2017   grade_4                         21.0 16.0                       37.0                         21 16                 37
1754054 1754054 IN     school 1800210 2435   Attica Consolidated School Corp 180021000049 2057 Attica Elementary School   Regular School No Elementary PK 05 2019   grade_4                         30.0 24.0                       54.0                         30 24                 54
1789787 1789787 IN     school 1800210 2435   Attica Consolidated School Corp 180021000049 2057 Attica Elementary School   Regular School No Elementary PK 06 2018   grade_4                         25.0 21.0                       46.0                         25 21                 46

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