enrollments

Data source: Big Local News · About: Big Local

7,371 rows where grade = "grade_2" and state = "IN" sorted by district

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_2 · 7,371 ✖
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
1171008 1171008 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_2                         28.0 30.0                       58.0                         28 30                 58
1292385 1292385 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_2                         28.0 39.0                       67.0                         28 39                 67
1304418 1304418 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_2                         42.0 31.0                       73.0                         42 31                 73
1763029 1763029 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_2                         32.0 41.0                       73.0                         32 41                 73
1798759 1798759 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_2                         28.0 47.0                       75.0                         28 47                 75
1918498 1918498 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_2                         50.0 47.0                       97.0                         50 47                 97
1930493 1930493 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_2                         37.0 50.0                       87.0                         37 50                 87
1763495 1763495 IN     school 1800172 9970   ACE Preparatory Academy 180017202604 1111 ACE Preparatory Academy   Regular School Yes Elementary KG 03 2019   grade_2                         9.0 8.0                       17.0                         9 8                 17
1799270 1799270 IN     school 1800172 9970   ACE Preparatory Academy 180017202604 1111 ACE Preparatory Academy   Regular School Yes Elementary KG 02 2018   grade_2                         5.0 7.0                       12.0                         5 7                 12
1918904 1918904 IN     school 1800172 9970   ACE Preparatory Academy 180017202604 1111 ACE Preparatory Academy   Regular School Yes Elementary KG 04 2020   grade_2                         18.0 22.0                       40.0                         18 22                 40
1930902 1930902 IN     school 1800172 9970   ACE Preparatory Academy 180017202604 1111 ACE Preparatory Academy   Regular School Yes Elementary KG 05 2021   grade_2                         15.0 15.0                       30.0                         15 15                 30
1159467 1159467 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary Sch   Regular School No 1.0 KG 05 2015   grade_2                         50.0 50.0                       100.0                         50 50                 100
1280857 1280857 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No 1.0 KG 05 2016   grade_2                         64.0 38.0                       102.0                         64 38                 102
1292919 1292919 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2017   grade_2                         53.0 52.0                       105.0                         53 52                 105
1751551 1751551 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2019   grade_2                         60.0 39.0                       99.0                         60 39                 99
1787292 1787292 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2018   grade_2                         52.0 42.0                       94.0                         52 42                 94
1906992 1906992 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2020   grade_2                         61.0 63.0                       124.0                         61 63                 124
1918958 1918958 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2021   grade_2                         56.0 43.0                       99.0                         56 43                 99
1930218 1930218 IN     school 1800216 9130   Adelante Schools 180021602702 9993 Emma Donnan Elementary and Middle   Regular School Yes Elementary KG 08 2021   grade_2                         13.0 12.0                       25.0                         13 12                 25
1165533 1165533 IN     school 1800120 5265   Alexandria Com School Corp 180012000009 5069 Alexandria-Monroe Elementary   Regular School No 1.0 PK 03 2015   grade_2                         52.0 47.0                       99.0                         52 47                 99
1286929 1286929 IN     school 1800120 5265   Alexandria Community School Corp 180012000009 5069 Alexandria-Monroe Elementary   Regular School No 1.0 PK 02 2016   grade_2                         57.0 49.0                       106.0                         57 49                 106
1298964 1298964 IN     school 1800120 5265   Alexandria Community School Corp 180012000009 5069 Alexandria-Monroe Elementary   Regular School No Elementary PK 02 2017   grade_2                         63.0 64.0                       127.0                         63 64                 127
1757495 1757495 IN     school 1800120 5265   Alexandria Community School Corp 180012000009 5069 Alexandria-Monroe Elementary   Regular School No Elementary PK 02 2019   grade_2                         52.0 54.0                       106.0                         52 54                 106
1793286 1793286 IN     school 1800120 5265   Alexandria Community School Corp 180012000009 5069 Alexandria-Monroe Elementary   Regular School No Elementary PK 02 2018   grade_2                         64.0 49.0                       113.0                         64 49                 113
1912918 1912918 IN     school 1800120 5265   Alexandria Community School Corp 180012000009 5069 Alexandria-Monroe Elementary   Regular School No Elementary PK 02 2020   grade_2                         66.0 54.0                       120.0                         66 54                 120
1924835 1924835 IN     school 1800120 5265   Alexandria Community School Corp 180012000010 5065 Alexandria Monroe Elementary Schoo   Regular School No Elementary PK 06 2021   grade_2                         55.0 43.0                       98.0                         55 43                 98
1918188 1918188 IN     school 1800199 9065   Allegiant Preparatory Academy 180019902648 1002 Allegiant Preparatory Academy   Regular School Yes Elementary KG 02 2020   grade_2                         4.0 4.0                       8.0                         4 4                 8
1930141 1930141 IN     school 1800199 9065   Allegiant Preparatory Academy 180019902648 1002 Allegiant Preparatory Academy   Regular School Yes Elementary KG 03 2021   grade_2                         15.0 10.0                       25.0                         15 10                 25
1165544 1165544 IN     school 1800150 5275   Anderson Community School Corp 180015000020 4953 Edgewood Elementary School   Regular School No 1.0 KG 05 2015   grade_2                         28.0 29.0                       57.0                         28 29                 57
1165551 1165551 IN     school 1800150 5275   Anderson Community School Corp 180015000041 4977 Tenth Street Elementary Sch   Regular School No 1.0 KG 05 2015   grade_2                         67.0 55.0                       122.0                         67 55                 122
1165560 1165560 IN     school 1800150 5275   Anderson Community School Corp 180015000044 5033 Valley Grove Elementary Sch   Regular School No 1.0 KG 05 2015   grade_2                         67.0 68.0                       135.0                         67 68                 135
1165571 1165571 IN     school 1800150 5275   Anderson Community School Corp 180015002109 5102 Eastside Elementary School   Regular School No 1.0 KG 05 2015   grade_2                         61.0 51.0                       112.0                         61 51                 112
1165578 1165578 IN     school 1800150 5275   Anderson Community School Corp 180015001847 5142 Anderson Elementary School   Regular School No 1.0 KG 05 2015   grade_2                         52.0 55.0                       107.0                         52 55                 107
1165585 1165585 IN     school 1800150 5275   Anderson Community School Corp 180015002110 5146 Erskine Elementary School   Regular School No 1.0 KG 05 2015   grade_2                         51.0 31.0                       82.0                         51 31                 82
1286939 1286939 IN     school 1800150 5275   Anderson Community School Corp 180015000020 4953 Edgewood Elementary School   Regular School No 1.0 KG 05 2016   grade_2                         23.0 32.0                       55.0                         23 32                 55
1286946 1286946 IN     school 1800150 5275   Anderson Community School Corp 180015000041 4977 Tenth Street Elementary School   Regular School No 1.0 KG 05 2016   grade_2                         54.0 48.0                       102.0                         54 48                 102
1286955 1286955 IN     school 1800150 5275   Anderson Community School Corp 180015000044 5033 Valley Grove Elementary School   Regular School No 1.0 KG 05 2016   grade_2                         72.0 51.0                       123.0                         72 51                 123
1286966 1286966 IN     school 1800150 5275   Anderson Community School Corp 180015002109 5102 Eastside Elementary School   Regular School No 1.0 KG 05 2016   grade_2                         52.0 44.0                       96.0                         52 44                 96
1286973 1286973 IN     school 1800150 5275   Anderson Community School Corp 180015001847 5142 Anderson Elementary School   Regular School No 1.0 KG 05 2016   grade_2                         62.0 41.0                       103.0                         62 41                 103
1286980 1286980 IN     school 1800150 5275   Anderson Community School Corp 180015002110 5146 Erskine Elementary School   Regular School No 1.0 KG 05 2016   grade_2                         50.0 49.0                       99.0                         50 49                 99
1298974 1298974 IN     school 1800150 5275   Anderson Community School Corp 180015000020 4953 Edgewood Elementary School   Regular School No Elementary KG 05 2017   grade_2                         25.0 23.0                       48.0                         25 23                 48
1298981 1298981 IN     school 1800150 5275   Anderson Community School Corp 180015000041 4977 Tenth Street Elementary School   Regular School No Elementary KG 05 2017   grade_2                         75.0 45.0                       120.0                         75 45                 120
1298990 1298990 IN     school 1800150 5275   Anderson Community School Corp 180015000044 5033 Valley Grove Elementary School   Regular School No Elementary KG 05 2017   grade_2                         62.0 43.0                       105.0                         62 43                 105
1299001 1299001 IN     school 1800150 5275   Anderson Community School Corp 180015002109 5102 Eastside Elementary School   Regular School No Elementary KG 05 2017   grade_2                         45.0 49.0                       94.0                         45 49                 94
1299008 1299008 IN     school 1800150 5275   Anderson Community School Corp 180015001847 5142 Anderson Elementary School   Regular School No Elementary KG 05 2017   grade_2                         45.0 58.0                       103.0                         45 58                 103
1299015 1299015 IN     school 1800150 5275   Anderson Community School Corp 180015002110 5146 Erskine Elementary School   Regular School No Elementary KG 05 2017   grade_2                         60.0 40.0                       100.0                         60 40                 100
1757511 1757511 IN     school 1800150 5275   Anderson Community School Corp 180015000020 4953 Edgewood Elementary School   Regular School No Elementary KG 05 2019   grade_2                         23.0 26.0                       49.0                         23 26                 49
1757518 1757518 IN     school 1800150 5275   Anderson Community School Corp 180015000041 4977 Tenth Street Elementary School   Regular School No Elementary KG 05 2019   grade_2                         72.0 53.0                       125.0                         72 53                 125
1757527 1757527 IN     school 1800150 5275   Anderson Community School Corp 180015000044 5033 Valley Grove Elementary School   Regular School No Elementary KG 05 2019   grade_2                         47.0 51.0                       98.0                         47 51                 98
1757538 1757538 IN     school 1800150 5275   Anderson Community School Corp 180015002109 5102 Eastside Elementary School   Regular School No Elementary KG 05 2019   grade_2                         38.0 39.0                       77.0                         38 39                 77
1757545 1757545 IN     school 1800150 5275   Anderson Community School Corp 180015001847 5142 Anderson Elementary School   Regular School No Elementary KG 05 2019   grade_2                         46.0 45.0                       91.0                         46 45                 91
1757552 1757552 IN     school 1800150 5275   Anderson Community School Corp 180015002110 5146 Erskine Elementary School   Regular School No Elementary KG 05 2019   grade_2                         57.0 49.0                       106.0                         57 49                 106
1793301 1793301 IN     school 1800150 5275   Anderson Community School Corp 180015000020 4953 Edgewood Elementary School   Regular School No Elementary KG 05 2018   grade_2                         27.0 26.0                       53.0                         27 26                 53
1793308 1793308 IN     school 1800150 5275   Anderson Community School Corp 180015000041 4977 Tenth Street Elementary School   Regular School No Elementary KG 05 2018   grade_2                         68.0 41.0                       109.0                         68 41                 109
1793317 1793317 IN     school 1800150 5275   Anderson Community School Corp 180015000044 5033 Valley Grove Elementary School   Regular School No Elementary KG 05 2018   grade_2                         61.0 48.0                       109.0                         61 48                 109
1793328 1793328 IN     school 1800150 5275   Anderson Community School Corp 180015002109 5102 Eastside Elementary School   Regular School No Elementary KG 05 2018   grade_2                         46.0 35.0                       81.0                         46 35                 81
1793335 1793335 IN     school 1800150 5275   Anderson Community School Corp 180015001847 5142 Anderson Elementary School   Regular School No Elementary KG 05 2018   grade_2                         54.0 39.0                       93.0                         54 39                 93
1793342 1793342 IN     school 1800150 5275   Anderson Community School Corp 180015002110 5146 Erskine Elementary School   Regular School No Elementary KG 05 2018   grade_2                         60.0 54.0                       114.0                         60 54                 114
1912933 1912933 IN     school 1800150 5275   Anderson Community School Corp 180015000020 4953 Edgewood Elementary School   Regular School No Elementary KG 04 2020   grade_2                         24.0 27.0                       51.0                         24 27                 51
1912942 1912942 IN     school 1800150 5275   Anderson Community School Corp 180015000041 4977 Tenth Street Elementary School   Regular School No Elementary KG 04 2020   grade_2                         44.0 47.0                       91.0                         44 47                 91
1912950 1912950 IN     school 1800150 5275   Anderson Community School Corp 180015000044 5033 Valley Grove Elementary School   Regular School No Elementary KG 04 2020   grade_2                         46.0 38.0                       84.0                         46 38                 84
1912959 1912959 IN     school 1800150 5275   Anderson Community School Corp 180015002109 5102 Eastside Elementary School   Regular School No Elementary KG 04 2020   grade_2                         58.0 57.0                       115.0                         58 57                 115
1912965 1912965 IN     school 1800150 5275   Anderson Community School Corp 180015001847 5142 Anderson Elementary School   Regular School No Elementary KG 04 2020   grade_2                         50.0 52.0                       102.0                         50 52                 102
1912971 1912971 IN     school 1800150 5275   Anderson Community School Corp 180015002110 5146 Erskine Elementary School   Regular School No Elementary KG 04 2020   grade_2                         62.0 40.0                       102.0                         62 40                 102
1924858 1924858 IN     school 1800150 5275   Anderson Community School Corp 180015000020 4953 Edgewood Elementary School   Regular School No Elementary KG 04 2021   grade_2                         24.0 27.0                       51.0                         24 27                 51
1924867 1924867 IN     school 1800150 5275   Anderson Community School Corp 180015000041 4977 Tenth Street Elementary School   Regular School No Elementary KG 04 2021   grade_2                         44.0 56.0                       100.0                         44 56                 100
1924875 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
1924884 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
1924890 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
1924896 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
1171301 1171301 IN     school 1800077 9790   Anderson Preparatory Academy 180007702425 5092 Anderson Preparatory Academy   Regular School Yes 4.0 KG 12 2015   grade_2                         43.0 33.0                       76.0                         43 33                 76
1292661 1292661 IN     school 1800077 9790   Anderson Preparatory Academy 180007702425 5092 Anderson Preparatory Academy   Regular School Yes 4.0 KG 12 2016   grade_2                         47.0 26.0                       73.0                         47 26                 73
1304701 1304701 IN     school 1800077 9790   Anderson Preparatory Academy 180007702425 5092 Anderson Preparatory Academy   Regular School Yes Other KG 12 2017   grade_2                         43.0 31.0                       74.0                         43 31                 74
1763283 1763283 IN     school 1800077 9790   Anderson Preparatory Academy 180007702425 5092 Anderson Preparatory Academy   Regular School Yes Other KG 12 2019   grade_2                         27.0 28.0                       55.0                         27 28                 55
1799028 1799028 IN     school 1800077 9790   Anderson Preparatory Academy 180007702425 5092 Anderson Preparatory Academy   Regular School Yes Other KG 12 2018   grade_2                         29.0 20.0                       49.0                         29 20                 49
1918730 1918730 IN     school 1800077 9790   Anderson Preparatory Academy 180007702425 5092 Anderson Preparatory Academy   Regular School Yes Other KG 12 2020   grade_2                         32.0 26.0                       58.0                         32 26                 58
1930718 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
1171188 1171188 IN     school 1800092 9715   Andrew Academy 180009202493 5785 Andrew Academy   Regular School Yes 1.0 KG 08 2015   grade_2                         12.0 15.0                       27.0                         12 15                 27
1171083 1171083 IN     school 1800042 9615   Andrew J Brown Academy 180004201816 5488 Andrew J Brown Academy   Regular School Yes 1.0 KG 08 2015   grade_2                         47.0 36.0                       83.0                         47 36                 83
1292460 1292460 IN     school 1800042 9615   Andrew J Brown Academy 180004201816 5488 Andrew J Brown Academy   Regular School Yes 1.0 KG 08 2016   grade_2                         47.0 34.0                       81.0                         47 34                 81
1304493 1304493 IN     school 1800042 9615   Andrew J Brown Academy 180004201816 5488 Andrew J Brown Academy   Regular School Yes Elementary KG 08 2017   grade_2                         44.0 49.0                       93.0                         44 49                 93
1763105 1763105 IN     school 1800042 9615   Andrew J Brown Academy 180004201816 5488 Andrew J Brown Academy   Regular School Yes Elementary KG 08 2019   grade_2                         38.0 35.0                       73.0                         38 35                 73
1798835 1798835 IN     school 1800042 9615   Andrew J Brown Academy 180004201816 5488 Andrew J Brown Academy   Regular School Yes Elementary KG 08 2018   grade_2                         43.0 47.0                       90.0                         43 47                 90
1918574 1918574 IN     school 1800042 9615   Andrew J Brown Academy 180004201816 5488 Andrew J Brown Academy   Regular School Yes Elementary KG 08 2020   grade_2                         44.0 41.0                       85.0                         44 41                 85
1930570 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
1166882 1166882 IN     school 1800180 5470   Argos Community Schools 180018000047 5936 Argos Community Elementary   Regular School No 1.0 KG 06 2015   grade_2                         21.0 18.0                       39.0                         21 18                 39
1288281 1288281 IN     school 1800180 5470   Argos Community Schools 180018000047 5936 Argos Community Elementary   Regular School No 1.0 PK 06 2016   grade_2                         21.0 23.0                       44.0                         21 23                 44
1300304 1300304 IN     school 1800180 5470   Argos Community Schools 180018000047 5936 Argos Community Elementary   Regular School No Elementary PK 06 2017   grade_2                         25.0 37.0                       62.0                         25 37                 62
1758808 1758808 IN     school 1800180 5470   Argos Community Schools 180018000047 5936 Argos Community Elementary   Regular School No Elementary PK 06 2019   grade_2                         17.0 22.0                       39.0                         17 22                 39
1794621 1794621 IN     school 1800180 5470   Argos Community Schools 180018000047 5936 Argos Community Elementary   Regular School No Elementary PK 06 2018   grade_2                         17.0 15.0                       32.0                         17 15                 32
1914226 1914226 IN     school 1800180 5470   Argos Community Schools 180018000047 5936 Argos Community Elementary   Regular School No Elementary PK 05 2020   grade_2                         26.0 18.0                       44.0                         26 18                 44
1926108 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
1171160 1171160 IN     school 1800071 9685   Aspire Charter Academy 180007102443 4043 Aspire Charter Academy   Regular School Yes 1.0 KG 08 2015   grade_2                         39.0 42.0                       81.0                         39 42                 81
1292541 1292541 IN     school 1800071 9685   Aspire Charter Academy 180007102443 4043 Aspire Charter Academy   Regular School Yes 1.0 KG 08 2016   grade_2                         31.0 49.0                       80.0                         31 49                 80
1304580 1304580 IN     school 1800071 9685   Aspire Charter Academy 180007102443 4043 Aspire Charter Academy   Regular School Yes Elementary KG 08 2017   grade_2                         40.0 40.0                       80.0                         40 40                 80
1763182 1763182 IN     school 1800071 9685   Aspire Charter Academy 180007102443 4043 Aspire Charter Academy   Regular School Yes Elementary KG 08 2019   grade_2                         44.0 29.0                       73.0                         44 29                 73
1798914 1798914 IN     school 1800071 9685   Aspire Charter Academy 180007102443 4043 Aspire Charter Academy   Regular School Yes Elementary KG 08 2018   grade_2                         50.0 29.0                       79.0                         50 29                 79
1918652 1918652 IN     school 1800071 9685   Aspire Charter Academy 180007102443 4043 Aspire Charter Academy   Regular School Yes Elementary KG 08 2020   grade_2                         34.0 37.0                       71.0                         34 37                 71
1930639 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
1161988 1161988 IN     school 1800210 2435   Attica Consolidated Sch Corp 180021000049 2057 Attica Elementary School   Regular School No 1.0 PK 06 2015   grade_2                         22.0 21.0                       43.0                         22 21                 43

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