enrollments

Data source: Big Local News · About: Big Local

2,960 rows where grade = "grade_11" and state = "IN" sorted by school_nces_id

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_11 · 2,960 ✖
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
1170755 1170755 IN     school 1800006 9100   IN Department of Correction 180000601935 5055 Pendleton Juv Correctional Fac   Regular School No 3.0 08 12 2015   grade_11                         11.0 0.0                       11.0                         11 0                 11
1292137 1292137 IN     school 1800006 9100   IN Department of Correction 180000601935 5055 Pendleton Juv Correctional Fac   Regular School No 3.0 07 12 2016   grade_11                         18.0 0.0                       18.0                         18 0                 18
1304160 1304160 IN     school 1800006 9100   Indiana Department of Corrections 180000601935 5055 Pendleton Juvenile Correctional   Regular School No High 08 12 2017   grade_11                         9.0 0.0                       9.0                         9 0                 9
1762777 1762777 IN     school 1800006 9100   Indiana Department of Correction 180000601935 5055 Pendleton Juvenile Correctional   Regular School No High 07 12 2019   grade_11                         15.0 0.0                       15.0                         15 0                 15
1798516 1798516 IN     school 1800006 9100   Indiana Department of Correction 180000601935 5055 Pendleton Juvenile Correctional   Regular School No High 08 12 2018   grade_11                         17.0 0.0                       17.0                         17 0                 17
1918235 1918235 IN     school 1800006 9100   Indiana Department of Correction 180000601935 5055 Pendleton Juvenile Correctional   Regular School No High 08 12 2020   grade_11                         49.0 0.0                       49.0                         49 0                 49
1930189 1930189 IN     school 1800006 9100   Indiana Department of Correction 180000601935 5055 Pendleton Juvenile Correctional   Regular School No High 08 12 2021   grade_11                         33.0 0.0                       33.0                         33 0                 33
1170762 1170762 IN     school 1800006 9100   IN Department of Correction 180000601943 5452 Madison Juvenile Corr Fac   Regular School No 3.0 08 12 2015   grade_11                         0.0 7.0                       7.0                         0 7                 7
1292144 1292144 IN     school 1800006 9100   IN Department of Correction 180000601943 5452 Madison Juvenile Corr Fac   Regular School No 3.0 08 12 2016   grade_11                         0.0 14.0                       14.0                         0 14                 14
1304167 1304167 IN     school 1800006 9100   Indiana Department of Corrections 180000601943 5452 Madison Juvenile Correctional   Regular School No High 08 12 2017   grade_11                         0.0 20.0                       20.0                         0 20                 20
1762784 1762784 IN     school 1800006 9100   Indiana Department of Correction 180000601943 5452 Madison Juvenile Correctional   Regular School No High 08 12 2019   grade_11                         0.0 4.0                       4.0                         0 4                 4
1798522 1798522 IN     school 1800006 9100   Indiana Department of Correction 180000601943 5452 Madison Juvenile Correctional   Regular School No High 09 12 2018   grade_11                         0.0 5.0                       5.0                         0 5                 5
1918241 1918241 IN     school 1800006 9100   Indiana Department of Correction 180000601943 5452 LaPorte Juvenile Correctional   Regular School No High 08 12 2020   grade_11                         0.0 11.0                       11.0                         0 11                 11
1930195 1930195 IN     school 1800006 9100   Indiana Department of Correction 180000601943 5452 LaPorte Juvenile Correctional   Regular School No High 08 12 2021   grade_11                         0.0 5.0                       5.0                         0 5                 5
1170742 1170742 IN     school 1800006 9100   IN Department of Correction 180000601946 732 Logansport Juvenile Cor Fac   Regular School No 3.0 07 12 2015   grade_11                         3.0 0.0                       3.0                         3 0                 3
1292124 1292124 IN     school 1800006 9100   IN Department of Correction 180000601946 732 Logansport Juvenile Cor Facility   Regular School No 3.0 08 12 2016   grade_11                         10.0 0.0                       10.0                         10 0                 10
1304146 1304146 IN     school 1800006 9100   Indiana Department of Corrections 180000601946 732 Logansport Juvenile Correctional   Regular School No High 07 12 2017   grade_11                         14.0 0.0                       14.0                         14 0                 14
1762769 1762769 IN     school 1800006 9100   Indiana Department of Correction 180000601946 732 Logansport Juvenile Correctional   Regular School No High 07 12 2019   grade_11                         19.0 0.0                       19.0                         19 0                 19
1798502 1798502 IN     school 1800006 9100   Indiana Department of Correction 180000601946 732 Logansport Juvenile Correctional   Regular School No High 07 12 2018   grade_11                         15.0 0.0                       15.0                         15 0                 15
1918228 1918228 IN     school 1800006 9100   Indiana Department of Correction 180000601946 732 Logansport Juvenile Correctional   Regular School No High 08 12 2020   grade_11                         48.0 0.0                       48.0                         48 0                 48
1930182 1930182 IN     school 1800006 9100   Indiana Department of Correction 180000601946 732 Logansport Juvenile Correctional   Regular School No High 08 12 2021   grade_11                         32.0 0.0                       32.0                         32 0                 32
1170749 1170749 IN     school 1800006 9100   IN Department of Correction 180000601996 4846 Camp Summit Juv Facility   Regular School No 3.0 09 12 2015   grade_11                         23.0 0.0                       23.0                         23 0                 23
1292131 1292131 IN     school 1800006 9100   IN Department of Correction 180000601996 4846 Camp Summit Juv Facility   Regular School No 3.0 09 12 2016   grade_11                         25.0 0.0                       25.0                         25 0                 25
1304153 1304153 IN     school 1800006 9100   Indiana Department of Corrections 180000601996 4846 Camp Summit Juvenile Facility   Regular School No High 08 12 2017   grade_11                         19.0 0.0                       19.0                         19 0                 19
1798510 1798510 IN     school 1800006 9100   Indiana Department of Correction 180000601996 4846 Camp Summit Juvenile Facility   Regular School No High 09 12 2018   grade_11                         24.0 0.0                       24.0                         24 0                 24
1162361 1162361 IN     school 1800008 2980   White River Valley Sch Dist 180000802302 2429 White River Valley Jr/Sr High Sch   Regular School No 3.0 07 12 2015   grade_11                         35.0 35.0                       70.0                         35 35                 70
1283771 1283771 IN     school 1800008 2980   White River Valley Sch Dist 180000802302 2429 White River Valley Jr/Sr High Sch   Regular School No 3.0 07 12 2016   grade_11                         17.0 32.0                       49.0                         17 32                 49
1295813 1295813 IN     school 1800008 2980   White River Valley School District 180000802302 2429 White River Valley High School   Regular School No High 08 12 2017   grade_11                         38.0 30.0                       68.0                         38 30                 68
1754422 1754422 IN     school 1800008 2980   White River Valley School District 180000802302 2429 White River Valley High School   Regular School No High 09 12 2019   grade_11                         37.0 35.0                       72.0                         37 35                 72
1790159 1790159 IN     school 1800008 2980   White River Valley School District 180000802302 2429 White River Valley High School   Regular School No High 09 12 2018   grade_11                         32.0 40.0                       72.0                         32 40                 72
1909855 1909855 IN     school 1800008 2980   White River Valley School District 180000802302 2429 White River Valley High School   Regular School No High 09 12 2020   grade_11                         23.0 32.0                       55.0                         23 32                 55
1921808 1921808 IN     school 1800008 2980   White River Valley School District 180000802302 2429 White River Valley High School   Regular School No High 09 12 2021   grade_11                         35.0 35.0                       70.0                         35 35                 70
1170794 1170794 IN     school 1800011 9320   Community Montessori Inc 180001101737 1536 Community Montessori   Regular School Yes 4.0 KG 12 2015   grade_11                         23.0 15.0                       38.0                         23 15                 38
1292171 1292171 IN     school 1800011 9320   Community Montessori Inc 180001101737 1536 Community Montessori   Regular School Yes 4.0 KG 12 2016   grade_11                         26.0 19.0                       45.0                         26 19                 45
1304205 1304205 IN     school 1800011 9320   Community Montessori Inc 180001101737 1536 Community Montessori   Regular School Yes Other KG 12 2017   grade_11                         17.0 20.0                       37.0                         17 20                 37
1762844 1762844 IN     school 1800011 9320   Community Montessori Inc 180001101737 1536 Community Montessori   Regular School Yes Other PK 12 2019   grade_11                         20.0 16.0                       36.0                         20 16                 36
1798570 1798570 IN     school 1800011 9320   Community Montessori Inc 180001101737 1536 Community Montessori   Regular School Yes Other KG 12 2018   grade_11                         22.0 19.0                       41.0                         22 19                 41
1918307 1918307 IN     school 1800011 9320   Community Montessori Inc 180001101737 1536 Community Montessori   Regular School Yes Other PK 12 2020   grade_11                         16.0 17.0                       33.0                         16 17                 33
1930283 1930283 IN     school 1800011 9320   Community Montessori Inc 180001101737 1536 Community Montessori   Regular School Yes Other PK 12 2021   grade_11                         23.0 21.0                       44.0                         23 21                 44
1170813 1170813 IN     school 1800014 9330   Irvington Community School 180001401756 1537 Irvington Community School   Regular School Yes 4.0 KG 12 2015   grade_11                         36.0 26.0                       62.0                         36 26                 62
1292190 1292190 IN     school 1800014 9330   Irvington Community School 180001401756 1537 Irvington Community School   Regular School Yes 4.0 KG 12 2016   grade_11                         41.0 43.0                       84.0                         41 43                 84
1304224 1304224 IN     school 1800014 9330   Irvington Community School 180001401756 1537 Irvington Community School   Regular School Yes Other KG 12 2017   grade_11                         43.0 38.0                       81.0                         43 38                 81
1762864 1762864 IN     school 1800014 9330   Irvington Community School 180001401756 1537 Irvington Community School   Regular School Yes Other KG 12 2019   grade_11                         44.0 26.0                       70.0                         44 26                 70
1798589 1798589 IN     school 1800014 9330   Irvington Community School 180001401756 1537 Irvington Community School   Regular School Yes Other KG 12 2018   grade_11                         49.0 49.0                       98.0                         49 49                 98
1918327 1918327 IN     school 1800014 9330   Irvington Community School 180001401756 1537 Irvington Community School   Regular School Yes Other KG 12 2020   grade_11                         48.0 36.0                       84.0                         48 36                 84
1930322 1930322 IN     school 1800014 9330   Irvington Community School 180001401756 1537 Irvington Community School   Regular School Yes Other KG 12 2021   grade_11                         44.0 39.0                       83.0                         44 39                 83
1170807 1170807 IN     school 1800016 9325   Options Charter School - Carmel 180001601738 2524 Options Charter School - Carmel   Regular School Yes 3.0 09 12 2015   grade_11                         17.0 9.0                       26.0                         17 9                 26
1292184 1292184 IN     school 1800016 9325   Options Charter School - Carmel 180001601738 2524 Options Charter School - Carmel   Regular School Yes 3.0 09 12 2016   grade_11                         17.0 15.0                       32.0                         17 15                 32
1304218 1304218 IN     school 1800016 9325   Options Charter School - Carmel 180001601738 2524 Options Charter School - Carmel   Regular School Yes High 09 12 2017   grade_11                         10.0 11.0                       21.0                         10 11                 21
1762858 1762858 IN     school 1800016 9325   Options Charter School - Carmel 180001601738 2524 Options Charter School - Carmel   Regular School Yes High 09 12 2019   grade_11                         14.0 24.0                       38.0                         14 24                 38
1798583 1798583 IN     school 1800016 9325   Options Charter School - Carmel 180001601738 2524 Options Charter School - Carmel   Regular School Yes High 09 12 2018   grade_11                         19.0 17.0                       36.0                         19 17                 36
1918321 1918321 IN     school 1800016 9325   Options Charter School - Carmel 180001601738 2524 Options Charter School - Carmel   Regular School Yes High 09 12 2020   grade_11                         32.0 17.0                       49.0                         32 17                 49
1930297 1930297 IN     school 1800016 9325   Options Charter Schools 180001601738 2524 Options Charter School - Carmel   Regular School Yes High 06 12 2021   grade_11                         22.0 12.0                       34.0                         22 12                 34
1930305 1930305 IN     school 1800016 9325   Options Charter Schools 180001602313 2551 Options Charter School Noblesville   Regular School Yes High 06 12 2021   grade_11                         19.0 13.0                       32.0                         19 13                 32
1930313 1930313 IN     school 1800016 9325   Options Charter Schools 180001602700 9329 Options Indiana   Regular School Yes High 06 12 2021   grade_11                         25.0 33.0                       58.0                         25 33                 58
1170878 1170878 IN     school 1800017 9370   Fall Creek Academy 180001701788 5870 Fall Creek Academy   Regular School Yes 4.0 06 12 2015   grade_11                         15.0 16.0                       31.0                         15 16                 31
1170897 1170897 IN     school 1800018 9380   Christel House Academy South 180001801789 5874 Christel House Academy South   Regular School Yes 4.0 KG 12 2015   grade_11                         17.0 17.0                       34.0                         17 17                 34
1292264 1292264 IN     school 1800018 9380   Christel House Academy South 180001801789 5874 Christel House Academy South   Regular School Yes 4.0 KG 12 2016   grade_11                         24.0 21.0                       45.0                         24 21                 45
1304296 1304296 IN     school 1800018 9380   Christel House Academy South 180001801789 5874 Christel House Academy South   Regular School Yes Other KG 12 2017   grade_11                         33.0 26.0                       59.0                         33 26                 59
1762908 1762908 IN     school 1800018 9380   Christel House Academy South 180001801789 5874 Christel House Academy South   Regular School Yes Other KG 12 2019   grade_11                         17.0 24.0                       41.0                         17 24                 41
1798632 1798632 IN     school 1800018 9380   Christel House Academy South 180001801789 5874 Christel House Academy South   Regular School Yes Other KG 12 2018   grade_11                         29.0 10.0                       39.0                         29 10                 39
1918370 1918370 IN     school 1800018 9380   Christel House Academy South 180001801789 5874 Christel House Academy South   Regular School Yes Other KG 12 2020   grade_11                         22.0 23.0                       45.0                         22 23                 45
1930365 1930365 IN     school 1800018 9380   Christel House Academy South 180001801789 5874 Christel House Academy South   Regular School Yes Other KG 12 2021   grade_11                         26.0 18.0                       44.0                         26 18                 44
1170788 1170788 IN     school 1800021 9315   Signature School Inc 180002100319 8295 Signature School Inc   Regular School Yes 3.0 09 12 2015   grade_11                         33.0 45.0                       78.0                         33 45                 78
1292165 1292165 IN     school 1800021 9315   Signature School Inc 180002100319 8295 Signature School Inc   Regular School Yes 3.0 09 12 2016   grade_11                         37.0 51.0                       88.0                         37 51                 88
1304199 1304199 IN     school 1800021 9315   Signature School Inc 180002100319 8295 Signature School Inc   Regular School Yes High 09 12 2017   grade_11                         34.0 40.0                       74.0                         34 40                 74
1762838 1762838 IN     school 1800021 9315   Signature School Inc 180002100319 8295 Signature School Inc   Regular School Yes High 09 12 2019   grade_11                         51.0 50.0                       101.0                         51 50                 101
1798564 1798564 IN     school 1800021 9315   Signature School Inc 180002100319 8295 Signature School Inc   Regular School Yes High 09 12 2018   grade_11                         31.0 53.0                       84.0                         31 53                 84
1918301 1918301 IN     school 1800021 9315   Signature School Inc 180002100319 8295 Signature School Inc   Regular School Yes High 09 12 2020   grade_11                         44.0 54.0                       98.0                         44 54                 98
1930277 1930277 IN     school 1800021 9315   Signature School Inc 180002100319 8295 Signature School Inc   Regular School Yes High 09 12 2021   grade_11                         38.0 53.0                       91.0                         38 53                 91
1171054 1171054 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 Indiana School For The Blind   Alternative Education School No 4.0 PK 12 2015   grade_11                         6.0 6.0                       12.0                         6 6                 12
1292431 1292431 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 Indiana School For The Blind   Alternative Education School No 4.0 PK 12 2016   grade_11                         5.0 10.0                       15.0                         5 10                 15
1304464 1304464 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 IN Sch for the Blind & Vis Imprd   Alternative School No Other PK 12 2017   grade_11                         10.0 5.0                       15.0                         10 5                 15
1763076 1763076 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 IN Sch for the Blind & Vis Imprd   Special Education School No Other PK 12 2019   grade_11                         8.0 6.0                       14.0                         8 6                 14
1798806 1798806 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 IN Sch for the Blind & Vis Imprd   Special Education School No Other PK 12 2018   grade_11                         7.0 1.0                       8.0                         7 1                 8
1918545 1918545 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 IN Sch for the Blind & Vis Imprd   Special Education School No Other PK 12 2020   grade_11                         2.0 5.0                       7.0                         2 5                 7
1930540 1930540 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 IN Sch for the Blind & Vis Imprd   Special Education School No Other PK 12 2021   grade_11                         7.0 3.0                       10.0                         7 3                 10
1171069 1171069 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Alternative Education School No 4.0 PK 12 2015   grade_11                         12.0 7.0                       19.0                         12 7                 19
1292446 1292446 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Alternative Education School No 4.0 PK 12 2016   grade_11                         21.0 12.0                       33.0                         21 12                 33
1304479 1304479 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Alternative School No Other PK 12 2017   grade_11                         14.0 8.0                       22.0                         14 8                 22
1763091 1763091 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Special Education School No Other PK 12 2019   grade_11                         10.0 12.0                       22.0                         10 12                 22
1798821 1798821 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Special Education School No Other PK 12 2018   grade_11                         16.0 10.0                       26.0                         16 10                 26
1918560 1918560 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Special Education School No Other PK 12 2020   grade_11                         16.0 18.0                       34.0                         16 18                 34
1930556 1930556 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Special Education School No Other PK 12 2021   grade_11                         7.0 16.0                       23.0                         7 16                 23
1170942 1170942 IN     school 1800025 9460   Thea Bowman Leadership Academy 180002501807 4022 Thea Bowman Leadership Academy   Regular School Yes 4.0 KG 12 2015   grade_11                         52.0 58.0                       110.0                         52 58                 110
1292317 1292317 IN     school 1800025 9460   Thea Bowman Leadership Academy 180002501807 4022 Thea Bowman Leadership Academy   Regular School Yes 4.0 KG 12 2016   grade_11                         52.0 56.0                       108.0                         52 56                 108
1304350 1304350 IN     school 1800025 9460   Thea Bowman Leadership Academy 180002501807 4022 Thea Bowman Leadership Academy   Regular School Yes Other KG 12 2017   grade_11                         63.0 50.0                       113.0                         63 50                 113
1762964 1762964 IN     school 1800025 9460   Thea Bowman Leadership Academy 180002501807 4022 Thea Bowman Leadership Academy   Regular School Yes Other KG 12 2019   grade_11                         56.0 50.0                       106.0                         56 50                 106
1798691 1798691 IN     school 1800025 9460   Thea Bowman Leadership Academy 180002501807 4022 Thea Bowman Leadership Academy   Regular School Yes Other KG 12 2018   grade_11                         45.0 57.0                       102.0                         45 57                 102
1918432 1918432 IN     school 1800025 9460   Thea Bowman Leadership Academy 180002501807 4022 Thea Bowman Leadership Academy   Regular School Yes Other KG 12 2020   grade_11                         48.0 37.0                       85.0                         48 37                 85
1930428 1930428 IN     school 1800025 9460   Thea Bowman Leadership Academy 180002501807 4022 Thea Bowman Leadership Academy   Regular School Yes Other KG 12 2021   grade_11                         34.0 33.0                       67.0                         34 33                 67
1170775 1170775 IN     school 1800027 9310   Charter School of the Dunes 180002701815 1535 Charter School of the Dunes   Regular School Yes 4.0 KG 12 2015   grade_11                         18.0 20.0                       38.0                         18 20                 38
1159531 1159531 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000002 47 Homestead Senior High School   Regular School No 3.0 09 12 2015   grade_11                         287.0 285.0                       572.0                         287 285                 572
1280921 1280921 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000002 47 Homestead Senior High School   Regular School No 3.0 09 12 2016   grade_11                         294.0 298.0                       592.0                         294 298                 592
1292983 1292983 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000002 47 Homestead Senior High School   Regular School No High 09 12 2017   grade_11                         292.0 279.0                       571.0                         292 279                 571
1751615 1751615 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000002 47 Homestead Senior High School   Regular School No High 09 12 2019   grade_11                         289.0 297.0                       586.0                         289 297                 586
1787356 1787356 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000002 47 Homestead Senior High School   Regular School No High 09 12 2018   grade_11                         291.0 301.0                       592.0                         291 301                 592
1907056 1907056 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000002 47 Homestead Senior High School   Regular School No High 09 12 2020   grade_11                         299.0 287.0                       586.0                         299 287                 586
1919022 1919022 IN     school 1800030 125   MSD Southwest Allen County Schls 180003000002 47 Homestead Senior High School   Regular School No High 09 12 2021   grade_11                         334.0 324.0                       658.0                         334 324                 658
1170965 1170965 IN     school 1800031 9480   University Heights Preparatory Acd 180003102223 5864 University Heights Preparatory Acd   Regular School Yes 4.0 06 12 2015   grade_11                         11.0 14.0                       25.0                         11 14                 25

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