Data source: Big Local News · About: Big Local

2,933 rows where grade = "grade_12" and state = "IN" sorted by ccd_charter_school descending

View and edit SQL

year

grade

  • grade_12 · 2,933
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
1170770 IN     school 1800134 9305   The Excel Center - Richmond 180013402549 9012 The Excel Center - Richmond   Regular School Yes 3.0 09 12 2015   grade_12                         8.0 19.0                       27.0                         8 19                 27
1170776 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_12                         14.0 12.0                       26.0                         14 12                 26
1170789 IN     school 1800021 9315   Signature School Inc 180002100319 8295 Signature School Inc   Regular School Yes 3.0 09 12 2015   grade_12                         31.0 45.0                       76.0                         31 45                 76
1170795 IN     school 1800011 9320   Community Montessori Inc 180001101737 1536 Community Montessori   Regular School Yes 4.0 KG 12 2015   grade_12                         16.0 16.0                       32.0                         16 16                 32
1170808 IN     school 1800016 9325   Options Charter School - Carmel 180001601738 2524 Options Charter School - Carmel   Regular School Yes 3.0 09 12 2015   grade_12                         66.0 67.0                       133.0                         66 67                 133
1170814 IN     school 1800014 9330   Irvington Community School 180001401756 1537 Irvington Community School   Regular School Yes 4.0 KG 12 2015   grade_12                         40.0 47.0                       87.0                         40 47                 87
1170828 IN     school 1800138 9335   The Excel Center-Lafayette Square 180013802554 5912 The Excel Center - Lafayette Sq   Regular School Yes 3.0 09 12 2015   grade_12                         7.0 5.0                       12.0                         7 5                 12
1170844 IN     school 1800142 9345   The Excel Center - Lafayette 180014202548 8094 The Excel Center - Lafayette   Regular School Yes 3.0 09 12 2015   grade_12                         6.0 9.0                       15.0                         6 9                 15
1170858 IN     school 1800135 9355   The Excel Center - Kokomo 180013502553 2976 The Excel Center - Kokomo   Regular School Yes 3.0 09 12 2015   grade_12                         2.0 2.0                       4.0                         2 2                 4
1170879 IN     school 1800017 9370   Fall Creek Academy 180001701788 5870 Fall Creek Academy   Regular School Yes 4.0 06 12 2015   grade_12                         14.0 8.0                       22.0                         14 8                 22
1170898 IN     school 1800018 9380   Christel House Academy South 180001801789 5874 Christel House Academy South   Regular School Yes 4.0 KG 12 2015   grade_12                         15.0 15.0                       30.0                         15 15                 30
1170911 IN     school 1800122 9385   Christel House DORS South 180012202538 5532 Christel House DORS South   Regular School Yes 3.0 09 12 2015   grade_12                         17.0 13.0                       30.0                         17 13                 30
1170932 IN     school 1800154 9435   Indiana Achievement Academy 180015402572 5771 Indiana Achievement Academy   Regular School Yes 3.0 09 12 2015   grade_12                         7.0 18.0                       25.0                         7 18                 25
1170937 IN     school 1800045 9445   Charles A Tindley Accelerated Schl 180004502137 6208 Charles A Tindley Accelerated Sch   Regular School Yes 3.0 09 12 2015   grade_12                         13.0 19.0                       32.0                         13 19                 32
1170943 IN     school 1800025 9460   Thea Bowman Leadership Academy 180002501807 4022 Thea Bowman Leadership Academy   Regular School Yes 4.0 KG 12 2015   grade_12                         49.0 48.0                       97.0                         49 48                 97
1170966 IN     school 1800031 9480   University Heights Preparatory Acd 180003102223 5864 University Heights Preparatory Acd   Regular School Yes 4.0 06 12 2015   grade_12                         7.0 11.0                       18.0                         7 11                 18
1170993 IN     school 1800052 9535   Gary Lighthouse Charter School 180005202155 4130 Gary Lighthouse Charter School   Regular School Yes 4.0 KG 12 2015   grade_12                         47.0 62.0                       109.0                         47 62                 109
1171007 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_12                         12.0 18.0                       30.0                         12 18                 30
1171031 IN     school 1800051 9575   Indpls Lighthouse Charter School 180005102165 5523 Indpls Lighthouse Charter School   Regular School Yes 4.0 KG 12 2015   grade_12                         21.0 24.0                       45.0                         21 24                 45
1171112 IN     school 1800056 9640   Options Charter Sch - Noblesville 180005602313 2551 Options Charter School Noblesville   Regular School Yes 3.0 09 12 2015   grade_12                         54.0 60.0                       114.0                         54 60                 114
1171124 IN     school 1800058 9650   Herron Charter 180005802315 5724 Herron High School   Regular School Yes 3.0 09 12 2015   grade_12                         61.0 103.0                       164.0                         61 103                 164
1171130 IN     school 1800059 9655   Hope Academy 180005902386 5292 Hope Academy   Regular School Yes 3.0 09 12 2015   grade_12                         6.0 4.0                       10.0                         6 4                 10
1171146 IN     school 1800064 9670   Indianapolis Metropolitan High Sch 180006402408 5664 Indianapolis Metropolitan High Sch   Regular School Yes 3.0 09 12 2015   grade_12                         32.0 38.0                       70.0                         32 38                 70
1171181 IN     school 1800082 9705   Hammond Academy of Science & Tech 180008202466 4486 Hammond Academy of Science & Tech   Regular School Yes 4.0 06 12 2015   grade_12                         34.0 33.0                       67.0                         34 33                 67
1171218 IN     school 1800113 9730   Neighbors' New Vistas High School 180011302544 6864 Neighbors' New Vistas High School   Regular School Yes 3.0 09 12 2015   grade_12                         49.0 46.0                       95.0                         49 46                 95
1171247 IN     school 1800116 9750   The Excel Center - Anderson 180011602533 4904 The Excel Center - Anderson   Regular School Yes 3.0 09 12 2015   grade_12                         17.0 20.0                       37.0                         17 20                 37
1171252 IN     school 1800125 9755   Carpe Diem - Meridian Campus 180012502536 5979 Carpe Diem - Meridian Campus   Regular School Yes 4.0 06 12 2015   grade_12                         9.0 6.0                       15.0                         9 6                 15
1171271 IN     school 1800115 9765   Indiana Cyber Charter Sch Inc 180011502537 4421 Indiana Cyber Charter School   Regular School Yes 4.0 KG 12 2015   grade_12                         102.0 156.0                       258.0                         102 156                 258
1171300 IN     school 1800077 9790   Anderson Preparatory Academy 180007702425 5092 Anderson Preparatory Academy   Regular School Yes 4.0 KG 12 2015   grade_12                         36.0 35.0                       71.0                         36 35                 71
1171322 IN     school 1800072 9805   Hoosier Academy - Indianapolis 180007202422 2527 Hoosier Academy - Indianapolis   Regular School Yes 4.0 KG 12 2015   grade_12                         9.0 10.0                       19.0                         9 10                 19
1171335 IN     school 1800075 9830   Beacon Academy 180007502428 8411 Beacon Academy   Regular School Yes 3.0 08 12 2015   grade_12                         6.0 2.0                       8.0                         6 2                 8
1171372 IN     school 1800081 9865   Hoosier Acad Virtual Charter 180008102458 5290 Hoosier Acad Virtual Charter Sch   Regular School Yes 4.0 KG 12 2015   grade_12                         55.0 85.0                       140.0                         55 85                 140
1171396 IN     school 1800099 9875   Rock Creek Community Academy 180009902497 771 Rock Creek Community Academy   Regular School Yes 4.0 KG 12 2015   grade_12                         22.0 17.0                       39.0                         22 17                 39
1171409 IN     school 1800101 9880   Career Academy at South Bend 180010102521 7564 Career Academy at South Bend   Regular School Yes 4.0 05 12 2015   grade_12                         19.0 22.0                       41.0                         19 22                 41
1171418 IN     school 1800102 9885   Gary Middle College 180010202535 4027 Gary Middle College   Regular School Yes 3.0 09 12 2015   grade_12                         14.0 14.0                       28.0                         14 14                 28
1171423 IN     school 1800106 9890   Indiana Virtual School 180010602515 2488 Indiana Virtual School   Regular School Yes 4.0 06 12 2015   grade_12                         46.0 73.0                       119.0                         46 73                 119
1171432 IN     school 1800094 9895   Indiana Math Science Academy North 180009402487 5444 IN Math & Science Acad North   Regular School Yes 4.0 KG 12 2015   grade_12                         18.0 10.0                       28.0                         18 10                 28
1171446 IN     school 1800098 9905   Indiana Connections Academy 180009802474 7944 Indiana Connections Academy   Regular School Yes 4.0 KG 12 2015   grade_12                         162.0 294.0                       456.0                         162 294                 456
1171460 IN     school 1800093 9910   Excel Center for Adult Learners 180009302475 5669 Excel Center For Adult Learners   Regular School Yes 3.0 09 12 2015   grade_12                         80.0 140.0                       220.0                         80 140                 220
1171466 IN     school 1800108 9920   Damar Charter Academy 180010802503 5191 Damar Charter Academy   Regular School Yes 4.0 KG 12 2015   grade_12                         16.0 2.0                       18.0                         16 2                 18
1171484 IN     school 1800136 9930   Nexus Academy of Indianapolis 180013602552 5302 Nexus Academy of Indianapolis   Regular School Yes 3.0 09 12 2015   grade_12                         11.0 17.0                       28.0                         11 17                 28
1292152 IN     school 1800134 9305   Excel Center - Richmond 180013402549 9012 Excel Center - Richmond   Regular School Yes 3.0 10 12 2016   grade_12                         12.0 29.0                       41.0                         12 29                 41
1292166 IN     school 1800021 9315   Signature School Inc 180002100319 8295 Signature School Inc   Regular School Yes 3.0 09 12 2016   grade_12                         31.0 41.0                       72.0                         31 41                 72
1292172 IN     school 1800011 9320   Community Montessori Inc 180001101737 1536 Community Montessori   Regular School Yes 4.0 KG 12 2016   grade_12                         20.0 14.0                       34.0                         20 14                 34
1292185 IN     school 1800016 9325   Options Charter School - Carmel 180001601738 2524 Options Charter School - Carmel   Regular School Yes 3.0 09 12 2016   grade_12                         73.0 65.0                       138.0                         73 65                 138
1292191 IN     school 1800014 9330   Irvington Community School 180001401756 1537 Irvington Community School   Regular School Yes 4.0 KG 12 2016   grade_12                         39.0 23.0                       62.0                         39 23                 62
1292205 IN     school 1800138 9335   Excel Center - Lafayette Square 180013802554 5912 Excel Center - Lafayette Square   Regular School Yes 3.0 10 12 2016   grade_12                         9.0 15.0                       24.0                         9 15                 24
1292220 IN     school 1800142 9345   Excel Center - Lafayette 180014202548 8094 Excel Center - Lafayette   Regular School Yes 3.0 10 12 2016   grade_12                         11.0 13.0                       24.0                         11 13                 24
1292233 IN     school 1800135 9355   Excel Center - Kokomo 180013502553 2976 Excel Center - Kokomo   Regular School Yes 3.0 10 12 2016   grade_12                         4.0 6.0                       10.0                         4 6                 10
1292265 IN     school 1800018 9380   Christel House Academy South 180001801789 5874 Christel House Academy South   Regular School Yes 4.0 KG 12 2016   grade_12                         12.0 12.0                       24.0                         12 12                 24
1292278 IN     school 1800122 9385   Christel House DORS South 180012202538 5532 Christel House DORS South   Regular School Yes 3.0 09 12 2016   grade_12                         15.0 24.0                       39.0                         15 24                 39
1292312 IN     school 1800045 9445   Charles A Tindley Accelerated Schl 180004502137 6208 Charles A Tindley Accelerated Sch   Regular School Yes 3.0 09 12 2016   grade_12                         11.0 24.0                       35.0                         11 24                 35
1292318 IN     school 1800025 9460   Thea Bowman Leadership Academy 180002501807 4022 Thea Bowman Leadership Academy   Regular School Yes 4.0 KG 12 2016   grade_12                         51.0 51.0                       102.0                         51 51                 102
1292370 IN     school 1800052 9535   Gary Lighthouse Charter School 180005202155 4130 Gary Lighthouse Charter School   Regular School Yes 4.0 KG 12 2016   grade_12                         44.0 61.0                       105.0                         44 61                 105
1292384 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_12                         20.0 17.0                       37.0                         20 17                 37
1292408 IN     school 1800051 9575   Indpls Lighthouse Charter School 180005102165 5523 Indpls Lighthouse Charter School   Regular School Yes 4.0 KG 12 2016   grade_12                         27.0 28.0                       55.0                         27 28                 55
1292494 IN     school 1800056 9640   Options Charter Sch - Noblesville 180005602313 2551 Options Charter School Noblesville   Regular School Yes 3.0 09 12 2016   grade_12                         59.0 63.0                       122.0                         59 63                 122
1292506 IN     school 1800058 9650   Herron Charter 180005802315 5724 Herron High School   Regular School Yes 3.0 09 12 2016   grade_12                         68.0 114.0                       182.0                         68 114                 182
1292511 IN     school 1800059 9655   Hope Academy 180005902386 5292 Hope Academy   Regular School Yes 3.0 09 12 2016   grade_12                         6.0 3.0                       9.0                         6 3                 9
1292527 IN     school 1800064 9670   Indianapolis Metropolitan High Sch 180006402408 5664 Indianapolis Metropolitan High Sch   Regular School Yes 3.0 09 12 2016   grade_12                         26.0 28.0                       54.0                         26 28                 54
1292562 IN     school 1800082 9705   Hammond Academy of Science & Tech 180008202466 4486 Hammond Academy of Science & Tech   Regular School Yes 4.0 06 12 2016   grade_12                         36.0 27.0                       63.0                         36 27                 63
1292585 IN     school 1800113 9730   Neighbors' New Vistas High School 180011302544 6864 Neighbors' New Vistas High School   Regular School Yes 3.0 09 12 2016   grade_12                         67.0 57.0                       124.0                         67 57                 124
1292615 IN     school 1800116 9750   Excel Center - Anderson 180011602533 4904 Excel Center - Anderson   Regular School Yes 3.0 10 12 2016   grade_12                         24.0 39.0                       63.0                         24 39                 63
1292619 IN     school 1800125 9755   Carpe Diem - Meridian Campus 180012502536 5979 Carpe Diem - Meridian Campus   Regular School Yes 4.0 06 12 2016   grade_12                         6.0 6.0                       12.0                         6 6                 12
1292627 IN     school 1800131 9760   Smith Academy for Excellence 180013102539 242 Smith Academy for Excellence   Regular School Yes 4.0 02 12 2016   grade_12                         7.0 0.0                       7.0                         7 0                 7
1292660 IN     school 1800077 9790   Anderson Preparatory Academy 180007702425 5092 Anderson Preparatory Academy   Regular School Yes 4.0 KG 12 2016   grade_12                         31.0 28.0                       59.0                         31 28                 59
1292682 IN     school 1800072 9805   Hoosier Academy - Indianapolis 180007202422 2527 Hoosier Academy - Indianapolis   Regular School Yes 4.0 KG 12 2016   grade_12                         9.0 6.0                       15.0                         9 6                 15
1292695 IN     school 1800075 9830   Beacon Academy 180007502428 8411 Beacon Academy   Regular School Yes 3.0 08 12 2016   grade_12                         5.0 2.0                       7.0                         5 2                 7
1292711 IN     school 1800159 9840   Excel Center - Univ Heights 180015902592 5749 Excel Center - Univ Heights   Regular School Yes 3.0 10 12 2016   grade_12                         1.0 4.0                       5.0                         1 4                 5
1292739 IN     school 1800081 9865   Hoosier Acad Virtual Charter 180008102458 5290 Hoosier Acad Virtual Charter Sch   Regular School Yes 4.0 KG 12 2016   grade_12                         111.0 162.0                       273.0                         111 162                 273
1292763 IN     school 1800099 9875   Rock Creek Community Academy 180009902497 771 Rock Creek Community Academy   Regular School Yes 4.0 KG 12 2016   grade_12                         14.0 6.0                       20.0                         14 6                 20
1292777 IN     school 1800101 9880   Career Academy High School 180010102521 7564 Career Academy High School   Regular School Yes 3.0 09 12 2016   grade_12                         33.0 20.0                       53.0                         33 20                 53
1292782 IN     school 1800102 9885   Gary Middle College 180010202535 4027 Gary Middle College   Regular School Yes 3.0 09 12 2016   grade_12                         66.0 87.0                       153.0                         66 87                 153
1292787 IN     school 1800106 9890   Indiana Virtual School 180010602515 2488 Indiana Virtual School   Regular School Yes 4.0 06 12 2016   grade_12                         202.0 324.0                       526.0                         202 324                 526
1292796 IN     school 1800094 9895   Indiana Math Science Academy North 180009402487 5444 IN Math & Science Acad North   Regular School Yes 4.0 KG 12 2016   grade_12                         9.0 8.0                       17.0                         9 8                 17
1292812 IN     school 1800098 9905   Indiana Connections Academy 180009802474 7944 Indiana Connections Academy   Regular School Yes 4.0 KG 12 2016   grade_12                         179.0 315.0                       494.0                         179 315                 494
1292826 IN     school 1800093 9910   Excel Center for Adult Learners 180009302475 5669 Excel Center For Adult Learners   Regular School Yes 3.0 09 12 2016   grade_12                         90.0 182.0                       272.0                         90 182                 272
1292831 IN     school 1800160 9915   Marion Academy 180016002588 5903 Marion Academy   Regular School Yes 3.0 07 12 2016   grade_12                         15.0 4.0                       19.0                         15 4                 19
1292839 IN     school 1800108 9920   Damar Charter Academy 180010802503 5191 Damar Charter Academy   Regular School Yes 4.0 KG 12 2016   grade_12                         20.0 3.0                       23.0                         20 3                 23
1292858 IN     school 1800136 9930   Nexus Academy of Indianapolis 180013602552 5302 Nexus Academy of Indianapolis   Regular School Yes 3.0 09 12 2016   grade_12                         5.0 20.0                       25.0                         5 20                 25
1292884 IN     school 1800165 9950   Dugger Union Community School Corp 180016502590 7952 Dugger Union Community School Corp   Regular School Yes 4.0 KG 12 2016   grade_12                         14.0 13.0                       27.0                         14 13                 27
1304179 IN     school 1800179 9120   Insight School of Indiana 180017902601 2528 Insight School of Indiana   Regular School Yes High 07 12 2017   grade_12                         55.0 68.0                       123.0                         55 68                 123
1304186 IN     school 1800134 9305   Excel Center - Richmond 180013402549 9012 Excel Center - Richmond   Regular School Yes High 11 12 2017   grade_12                         88.0 100.0                       188.0                         88 100                 188
1304200 IN     school 1800021 9315   Signature School Inc 180002100319 8295 Signature School Inc   Regular School Yes High 09 12 2017   grade_12                         36.0 50.0                       86.0                         36 50                 86
1304206 IN     school 1800011 9320   Community Montessori Inc 180001101737 1536 Community Montessori   Regular School Yes Other KG 12 2017   grade_12                         25.0 15.0                       40.0                         25 15                 40
1304219 IN     school 1800016 9325   Options Charter School - Carmel 180001601738 2524 Options Charter School - Carmel   Regular School Yes High 09 12 2017   grade_12                         72.0 72.0                       144.0                         72 72                 144
1304225 IN     school 1800014 9330   Irvington Community School 180001401756 1537 Irvington Community School   Regular School Yes Other KG 12 2017   grade_12                         51.0 33.0                       84.0                         51 33                 84
1304238 IN     school 1800138 9335   Excel Center - Lafayette Square 180013802554 5912 Excel Center - Lafayette Square   Regular School Yes High 11 12 2017   grade_12                         65.0 134.0                       199.0                         65 134                 199
1304252 IN     school 1800142 9345   Excel Center - Lafayette 180014202548 8094 Excel Center - Lafayette   Regular School Yes High 11 12 2017   grade_12                         60.0 95.0                       155.0                         60 95                 155
1304264 IN     school 1800135 9355   Excel Center - Kokomo 180013502553 2976 Excel Center - Kokomo   Regular School Yes High 11 12 2017   grade_12                         58.0 112.0                       170.0                         58 112                 170
1304297 IN     school 1800018 9380   Christel House Academy South 180001801789 5874 Christel House Academy South   Regular School Yes Other KG 12 2017   grade_12                         24.0 22.0                       46.0                         24 22                 46
1304310 IN     school 1800122 9385   Christel House DORS South 180012202538 5532 Christel House DORS South   Regular School Yes High 09 12 2017   grade_12                         10.0 25.0                       35.0                         10 25                 35
1304345 IN     school 1800045 9445   Charles A Tindley Accelerated Sch 180004502137 6208 Charles A Tindley Accelerated Sch   Regular School Yes High 09 12 2017   grade_12                         12.0 28.0                       40.0                         12 28                 40
1304351 IN     school 1800025 9460   Thea Bowman Leadership Academy 180002501807 4022 Thea Bowman Leadership Academy   Regular School Yes Other KG 12 2017   grade_12                         46.0 53.0                       99.0                         46 53                 99
1304403 IN     school 1800052 9535   Gary Lighthouse Charter School 180005202155 4130 Gary Lighthouse Charter School   Regular School Yes Other KG 12 2017   grade_12                         51.0 65.0                       116.0                         51 65                 116
1304417 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_12                         19.0 27.0                       46.0                         19 27                 46
1304441 IN     school 1800051 9575   Indpls Lighthouse Charter School 180005102165 5523 Indpls Lighthouse Charter School   Regular School Yes Other KG 12 2017   grade_12                         25.0 48.0                       73.0                         25 48                 73
1304522 IN     school 1800162 9630   Carpe Diem - Shadeland 180016202575 5978 Carpe Diem - Shadeland   Regular School Yes Other 06 12 2017   grade_12                         1.0 1.0                       2.0                         1 1                 2
1304530 IN     school 1800056 9640   Options Charter School Noblesville 180005602313 2551 Options Charter School Noblesville   Regular School Yes Other 06 12 2017   grade_12                         66.0 80.0                       146.0                         66 80                 146
1304545 IN     school 1800058 9650   Herron Charter 180005802315 5724 Herron High School   Regular School Yes High 09 12 2017   grade_12                         68.0 98.0                       166.0                         68 98                 166

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