Data source: Big Local News · About: Big Local

7,228 rows where grade = "kindergarten" and state = "IN" sorted by ccd_school_high_grade descending

View and edit SQL

year

grade

  • kindergarten · 7,228
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
1159745 IN     school 1803630 235   Fort Wayne Community Schools 180363000519 151 Bunche Elementary School   Regular School No 1.0 PK KG 2015   kindergarten                         44.0 39.0                       83.0                         44 39                 83
1159900 IN     school 1803630 235   Fort Wayne Community Schools 180363001541 241 Whitney M Young Early Childhood   Regular School No 1.0 PK KG 2015   kindergarten                         63.0 56.0                       119.0                         63 56                 119
1165046 IN     school 1804590 4730   School City of Hobart 180459000772 4311 The Early Lrn Cntr at George Earle   Regular School No 1.0 PK KG 2015   kindergarten                         144.0 150.0                       294.0                         144 150                 294
1165746 IN     school 1805670 5330   M S D Lawrence Township 180567002205 5284 Early Learning Center   Regular School No 1.0 PK KG 2015   kindergarten                         504.0 433.0                       937.0                         504 433                 937
1170923 IN     school 1800147 9410   KIPP Indy Unite Elementary 180014702571 5741 KIPP Indy Unite Elementary   Regular School Yes 1.0 KG KG 2015   kindergarten                         55.0 48.0                       103.0                         55 48                 103
1281137 IN     school 1803630 235   Fort Wayne Community Schools 180363000519 151 Bunche Elementary School   Regular School No 1.0 PK KG 2016   kindergarten                         46.0 30.0                       76.0                         46 30                 76
1281291 IN     school 1803630 235   Fort Wayne Community Schools 180363001541 241 Whitney M Young Early Childhood   Regular School No 1.0 PK KG 2016   kindergarten                         56.0 58.0                       114.0                         56 58                 114
1286441 IN     school 1804590 4730   School City of Hobart 180459000772 4311 The Early Lrn Cntr at George Earle   Regular School No 1.0 PK KG 2016   kindergarten                         162.0 115.0                       277.0                         162 115                 277
1287142 IN     school 1805670 5330   M S D Lawrence Township 180567002205 5284 Early Learning Center   Regular School No 1.0 PK KG 2016   kindergarten                         515.0 441.0                       956.0                         515 441                 956
1293198 IN     school 1803630 235   Fort Wayne Community Schools 180363000519 151 Bunche Elementary School   Regular School No Elementary PK KG 2017   kindergarten                         41.0 35.0                       76.0                         41 35                 76
1293345 IN     school 1803630 235   Fort Wayne Community Schools 180363001541 241 Whitney M Young Early Childhood   Regular School No Elementary PK KG 2017   kindergarten                         66.0 54.0                       120.0                         66 54                 120
1298480 IN     school 1804590 4730   School City of Hobart 180459000772 4311 Early Learning Center-George Earle   Regular School No Elementary PK KG 2017   kindergarten                         142.0 146.0                       288.0                         142 146                 288
1299087 IN     school 1802640 5300   M S D Decatur Township 180264001065 5192 Liberty Early Elementary School   Regular School No Elementary PK KG 2017   kindergarten                         225.0 241.0                       466.0                         225 241                 466
1299182 IN     school 1805670 5330   M S D Lawrence Township 180567002205 5284 Early Learning Center   Regular School No Elementary PK KG 2017   kindergarten                         473.0 465.0                       938.0                         473 465                 938
1751823 IN     school 1803630 235   Fort Wayne Community Schools 180363000519 151 Bunche Elementary School   Regular School No Elementary PK KG 2019   kindergarten                         39.0 39.0                       78.0                         39 39                 78
1751970 IN     school 1803630 235   Fort Wayne Community Schools 180363001541 241 Whitney M Young Early Childhood   Regular School No Elementary PK KG 2019   kindergarten                         67.0 53.0                       120.0                         67 53                 120
1757009 IN     school 1804590 4730   School City of Hobart 180459000772 4311 Early Learning Center-George Earle   Regular School No Elementary PK KG 2019   kindergarten                         153.0 150.0                       303.0                         153 150                 303
1757624 IN     school 1802640 5300   M S D Decatur Township 180264001065 5192 Liberty Early Elementary School   Regular School No Elementary PK KG 2019   kindergarten                         218.0 199.0                       417.0                         218 199                 417
1757720 IN     school 1805670 5330   M S D Lawrence Township 180567002205 5284 Early Learning Center   Regular School No Elementary PK KG 2019   kindergarten                         417.0 391.0                       808.0                         417 391                 808
1787567 IN     school 1803630 235   Fort Wayne Community Schools 180363000519 151 Bunche Elementary School   Regular School No Elementary PK KG 2018   kindergarten                         39.0 42.0                       81.0                         39 42                 81
1787714 IN     school 1803630 235   Fort Wayne Community Schools 180363001541 241 Whitney M Young Early Childhood   Regular School No Elementary PK KG 2018   kindergarten                         66.0 53.0                       119.0                         66 53                 119
1792801 IN     school 1804590 4730   School City of Hobart 180459000772 4311 Early Learning Center-George Earle   Regular School No Elementary PK KG 2018   kindergarten                         154.0 148.0                       302.0                         154 148                 302
1793415 IN     school 1802640 5300   M S D Decatur Township 180264001065 5192 Liberty Early Elementary School   Regular School No Elementary PK KG 2018   kindergarten                         257.0 219.0                       476.0                         257 219                 476
1793509 IN     school 1805670 5330   M S D Lawrence Township 180567002205 5284 Early Learning Center   Regular School No Elementary PK KG 2018   kindergarten                         492.0 456.0                       948.0                         492 456                 948
1907263 IN     school 1803630 235   Fort Wayne Community Schools 180363000519 151 Bunche Elementary School   Regular School No Elementary PK KG 2020   kindergarten                         36.0 43.0                       79.0                         36 43                 79
1907410 IN     school 1803630 235   Fort Wayne Community Schools 180363001541 241 Whitney M Young Early Childhood   Regular School No Elementary PK KG 2020   kindergarten                         52.0 68.0                       120.0                         52 68                 120
1912178 IN     school 1803870 4690   Gary Community School Corp 180387000640 4057 Mary M Bethune Early Child Dev Ctr   Regular School No Elementary PK KG 2020   kindergarten                         42.0 36.0                       78.0                         42 36                 78
1912446 IN     school 1804590 4730   School City of Hobart 180459000772 4311 Early Learning Center-George Earle   Regular School No Elementary PK KG 2020   kindergarten                         152.0 144.0                       296.0                         152 144                 296
1913042 IN     school 1802640 5300   M S D Decatur Township 180264001065 5192 Liberty Early Elementary School   Regular School No Elementary PK KG 2020   kindergarten                         238.0 232.0                       470.0                         238 232                 470
1913139 IN     school 1805670 5330   M S D Lawrence Township 180567002205 5284 Early Learning Center   Regular School No Elementary PK KG 2020   kindergarten                         488.0 461.0                       949.0                         488 461                 949
1916433 IN     school 1810140 7365   Shelbyville Central Schools 181014002687 7723 Golden Bear Preschool   Regular School No Elementary PK KG 2020   kindergarten                         19.0 13.0                       32.0                         19 13                 32
1919229 IN     school 1803630 235   Fort Wayne Community Schools 180363000519 151 Bunche Elementary School   Regular School No Elementary PK KG 2021   kindergarten                         28.0 33.0                       61.0                         28 33                 61
1919375 IN     school 1803630 235   Fort Wayne Community Schools 180363001541 241 Whitney M Young Early Childhood   Regular School No Elementary PK KG 2021   kindergarten                         56.0 54.0                       110.0                         56 54                 110
1924395 IN     school 1804590 4730   School City of Hobart 180459000772 4311 Early Learning Center-George Earle   Regular School No Elementary PK KG 2021   kindergarten                         136.0 122.0                       258.0                         136 122                 258
1924967 IN     school 1802640 5300   MSD Decatur Township 180264001065 5192 Liberty Early Elementary School   Regular School No Elementary PK KG 2021   kindergarten                         240.0 238.0                       478.0                         240 238                 478
1925048 IN     school 1805670 5330   MSD Lawrence Township 180567002205 5284 Early Learning Center   Regular School No Elementary PK KG 2021   kindergarten                         427.0 403.0                       830.0                         427 403                 830
1928366 IN     school 1810140 7365   Shelbyville Central Schools 181014002687 7723 Golden Bear Preschool   Regular School No Elementary PK KG 2021   kindergarten                         4.0 3.0                       7.0                         4 3                 7
1164364 IN     school 1808320 4570   Northwest Indiana Spec Ed Coop 180832002208 4287 Eagle Park Community School   Special Education School No 4.0 KG 12 2015   kindergarten                         2.0 1.0                       3.0                         2 1                 3
1166821 IN     school 1800105 5390   Southside Sp Srvs Of Marion Co 180010502502 5320 RISE Learning Center   Regular School No 4.0 KG 12 2015   kindergarten                         2.0 0.0                       2.0                         2 0                 2
1167788 IN     school 1801170 6340   Cannelton City Schools 180117000191 6733 Cannelton Elem & High School   Regular School No 4.0 PK 12 2015   kindergarten                         8.0 12.0                       20.0                         8 12                 20
1169103 IN     school 1810140 7365   Shelbyville Central Schools 181014002496 7671 Especially Kidz Health & Rehab Cnt   Regular School No 4.0 PK 12 2015   kindergarten                         0.0 1.0                       1.0                         0 1                 1
1169737 IN     school 1803450 7995   Evansville Vanderburgh Sch Corp 180345002462 8270 Academy for Innovative Studies   Regular School No 4.0 KG 12 2015   kindergarten                         1.0 1.0                       2.0                         1 1                 2
1170520 IN     school 1809510 8385   Richmond Community Schools 180951000366 9056 Community Youth Services   Special Education School No 4.0 KG 12 2015   kindergarten                         2.0 0.0                       2.0                         2 0                 2
1170785 IN     school 1800027 9310   Charter School of the Dunes 180002701815 1535 Charter School of the Dunes   Regular School Yes 4.0 KG 12 2015   kindergarten                         34.0 26.0                       60.0                         34 26                 60
1170804 IN     school 1800011 9320   Community Montessori Inc 180001101737 1536 Community Montessori   Regular School Yes 4.0 KG 12 2015   kindergarten                         35.0 19.0                       54.0                         35 19                 54
1170823 IN     school 1800014 9330   Irvington Community School 180001401756 1537 Irvington Community School   Regular School Yes 4.0 KG 12 2015   kindergarten                         33.0 37.0                       70.0                         33 37                 70
1170907 IN     school 1800018 9380   Christel House Academy South 180001801789 5874 Christel House Academy South   Regular School Yes 4.0 KG 12 2015   kindergarten                         30.0 24.0                       54.0                         30 24                 54
1170952 IN     school 1800025 9460   Thea Bowman Leadership Academy 180002501807 4022 Thea Bowman Leadership Academy   Regular School Yes 4.0 KG 12 2015   kindergarten                         54.0 48.0                       102.0                         54 48                 102
1171002 IN     school 1800052 9535   Gary Lighthouse Charter School 180005202155 4130 Gary Lighthouse Charter School   Regular School Yes 4.0 KG 12 2015   kindergarten                         29.0 37.0                       66.0                         29 37                 66
1171016 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   kindergarten                         38.0 24.0                       62.0                         38 24                 62
1171040 IN     school 1800051 9575   Indpls Lighthouse Charter School 180005102165 5523 Indpls Lighthouse Charter School   Regular School Yes 4.0 KG 12 2015   kindergarten                         24.0 22.0                       46.0                         24 22                 46
1171064 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   kindergarten                         3.0 3.0                       6.0                         3 3                 6
1171079 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   kindergarten                         7.0 5.0                       12.0                         7 5                 12
1171105 IN     school 1800038 9620   Burris Laboratory School 180003800185 1441 Burris Laboratory School   Regular School No 4.0 KG 12 2015   kindergarten                         21.0 23.0                       44.0                         21 23                 44
1171280 IN     school 1800115 9765   Indiana Cyber Charter Sch Inc 180011502537 4421 Indiana Cyber Charter School   Regular School Yes 4.0 KG 12 2015   kindergarten                         22.0 17.0                       39.0                         22 17                 39
1171309 IN     school 1800077 9790   Anderson Preparatory Academy 180007702425 5092 Anderson Preparatory Academy   Regular School Yes 4.0 KG 12 2015   kindergarten                         33.0 24.0                       57.0                         33 24                 57
1171331 IN     school 1800072 9805   Hoosier Academy - Indianapolis 180007202422 2527 Hoosier Academy - Indianapolis   Regular School Yes 4.0 KG 12 2015   kindergarten                         6.0 6.0                       12.0                         6 6                 12
1171381 IN     school 1800081 9865   Hoosier Acad Virtual Charter 180008102458 5290 Hoosier Acad Virtual Charter Sch   Regular School Yes 4.0 KG 12 2015   kindergarten                         75.0 76.0                       151.0                         75 76                 151
1171405 IN     school 1800099 9875   Rock Creek Community Academy 180009902497 771 Rock Creek Community Academy   Regular School Yes 4.0 KG 12 2015   kindergarten                         19.0 22.0                       41.0                         19 22                 41
1171441 IN     school 1800094 9895   Indiana Math Science Academy North 180009402487 5444 IN Math & Science Acad North   Regular School Yes 4.0 KG 12 2015   kindergarten                         30.0 46.0                       76.0                         30 46                 76
1171455 IN     school 1800098 9905   Indiana Connections Academy 180009802474 7944 Indiana Connections Academy   Regular School Yes 4.0 KG 12 2015   kindergarten                         42.0 42.0                       84.0                         42 42                 84
1171475 IN     school 1800108 9920   Damar Charter Academy 180010802503 5191 Damar Charter Academy   Regular School Yes 4.0 KG 12 2015   kindergarten                         0.0 1.0                       1.0                         0 1                 1
1289187 IN     school 1801170 6340   Cannelton City Schools 180117000191 6733 Cannelton Elem & High School   Regular School No 4.0 PK 12 2016   kindergarten                         9.0 14.0                       23.0                         9 14                 23
1290487 IN     school 1810140 7365   Shelbyville Central Schools 181014002496 7671 Especially Kidz Health & Rehab Cnt   Regular School No 4.0 02 12 2016   kindergarten                         2.0 0.0                       2.0                         2 0                 2
1291907 IN     school 1809510 8385   Richmond Community Schools 180951000366 9056 Community Youth Services   Special Education School No 4.0 KG 12 2016   kindergarten                         1.0 0.0                       1.0                         1 0                 1
1292181 IN     school 1800011 9320   Community Montessori Inc 180001101737 1536 Community Montessori   Regular School Yes 4.0 KG 12 2016   kindergarten                         25.0 28.0                       53.0                         25 28                 53
1292200 IN     school 1800014 9330   Irvington Community School 180001401756 1537 Irvington Community School   Regular School Yes 4.0 KG 12 2016   kindergarten                         37.0 38.0                       75.0                         37 38                 75
1292274 IN     school 1800018 9380   Christel House Academy South 180001801789 5874 Christel House Academy South   Regular School Yes 4.0 KG 12 2016   kindergarten                         29.0 24.0                       53.0                         29 24                 53
1292327 IN     school 1800025 9460   Thea Bowman Leadership Academy 180002501807 4022 Thea Bowman Leadership Academy   Regular School Yes 4.0 KG 12 2016   kindergarten                         46.0 53.0                       99.0                         46 53                 99
1292379 IN     school 1800052 9535   Gary Lighthouse Charter School 180005202155 4130 Gary Lighthouse Charter School   Regular School Yes 4.0 KG 12 2016   kindergarten                         40.0 31.0                       71.0                         40 31                 71
1292393 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   kindergarten                         27.0 36.0                       63.0                         27 36                 63
1292417 IN     school 1800051 9575   Indpls Lighthouse Charter School 180005102165 5523 Indpls Lighthouse Charter School   Regular School Yes 4.0 KG 12 2016   kindergarten                         26.0 30.0                       56.0                         26 30                 56
1292441 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   kindergarten                         2.0 2.0                       4.0                         2 2                 4
1292456 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   kindergarten                         7.0 7.0                       14.0                         7 7                 14
1292481 IN     school 1800038 9620   Burris Laboratory School 180003800185 1441 Burris Laboratory School   Regular School No 4.0 KG 12 2016   kindergarten                         22.0 22.0                       44.0                         22 22                 44
1292669 IN     school 1800077 9790   Anderson Preparatory Academy 180007702425 5092 Anderson Preparatory Academy   Regular School Yes 4.0 KG 12 2016   kindergarten                         29.0 28.0                       57.0                         29 28                 57
1292691 IN     school 1800072 9805   Hoosier Academy - Indianapolis 180007202422 2527 Hoosier Academy - Indianapolis   Regular School Yes 4.0 KG 12 2016   kindergarten                         4.0 5.0                       9.0                         4 5                 9
1292748 IN     school 1800081 9865   Hoosier Acad Virtual Charter 180008102458 5290 Hoosier Acad Virtual Charter Sch   Regular School Yes 4.0 KG 12 2016   kindergarten                         77.0 59.0                       136.0                         77 59                 136
1292772 IN     school 1800099 9875   Rock Creek Community Academy 180009902497 771 Rock Creek Community Academy   Regular School Yes 4.0 KG 12 2016   kindergarten                         20.0 22.0                       42.0                         20 22                 42
1292805 IN     school 1800094 9895   Indiana Math Science Academy North 180009402487 5444 IN Math & Science Acad North   Regular School Yes 4.0 KG 12 2016   kindergarten                         26.0 22.0                       48.0                         26 22                 48
1292821 IN     school 1800098 9905   Indiana Connections Academy 180009802474 7944 Indiana Connections Academy   Regular School Yes 4.0 KG 12 2016   kindergarten                         35.0 44.0                       79.0                         35 44                 79
1292848 IN     school 1800108 9920   Damar Charter Academy 180010802503 5191 Damar Charter Academy   Regular School Yes 4.0 KG 12 2016   kindergarten                         2.0 0.0                       2.0                         2 0                 2
1292893 IN     school 1800165 9950   Dugger Union Community School Corp 180016502590 7952 Dugger Union Community School Corp   Regular School Yes 4.0 KG 12 2016   kindergarten                         7.0 6.0                       13.0                         7 6                 13
1301216 IN     school 1801170 6340   Cannelton City Schools 180117000191 6733 Cannelton Elementary & High School   Regular School No Other PK 12 2017   kindergarten                         12.0 10.0                       22.0                         12 10                 22
1302516 IN     school 1810140 7365   Shelbyville Central Schools 181014002496 7671 Especially Kidz Health & Rehab Cnt   Regular School No Other KG 12 2017   kindergarten                         1.0 2.0                       3.0                         1 2                 3
1303156 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002462 8270 Academy for Innovative Studies   Regular School No Other KG 12 2017   kindergarten                         1.0 0.0                       1.0                         1 0                 1
1304215 IN     school 1800011 9320   Community Montessori Inc 180001101737 1536 Community Montessori   Regular School Yes Other KG 12 2017   kindergarten                         25.0 23.0                       48.0                         25 23                 48
1304234 IN     school 1800014 9330   Irvington Community School 180001401756 1537 Irvington Community School   Regular School Yes Other KG 12 2017   kindergarten                         34.0 41.0                       75.0                         34 41                 75
1304306 IN     school 1800018 9380   Christel House Academy South 180001801789 5874 Christel House Academy South   Regular School Yes Other KG 12 2017   kindergarten                         28.0 27.0                       55.0                         28 27                 55
1304360 IN     school 1800025 9460   Thea Bowman Leadership Academy 180002501807 4022 Thea Bowman Leadership Academy   Regular School Yes Other KG 12 2017   kindergarten                         39.0 28.0                       67.0                         39 28                 67
1304412 IN     school 1800052 9535   Gary Lighthouse Charter School 180005202155 4130 Gary Lighthouse Charter School   Regular School Yes Other KG 12 2017   kindergarten                         60.0 40.0                       100.0                         60 40                 100
1304426 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   kindergarten                         37.0 36.0                       73.0                         37 36                 73
1304450 IN     school 1800051 9575   Indpls Lighthouse Charter School 180005102165 5523 Indpls Lighthouse Charter School   Regular School Yes Other KG 12 2017   kindergarten                         27.0 24.0                       51.0                         27 24                 51
1304474 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   kindergarten                         2.0 1.0                       3.0                         2 1                 3
1304489 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Alternative School No Other PK 12 2017   kindergarten                         12.0 13.0                       25.0                         12 13                 25
1304514 IN     school 1800038 9620   Burris Laboratory School 180003800185 1441 Burris Laboratory School   Regular School No Other KG 12 2017   kindergarten                         20.0 23.0                       43.0                         20 23                 43
1304709 IN     school 1800077 9790   Anderson Preparatory Academy 180007702425 5092 Anderson Preparatory Academy   Regular School Yes Other KG 12 2017   kindergarten                         34.0 33.0                       67.0                         34 33                 67
1304731 IN     school 1800072 9805   Hoosier Academy - Indianapolis 180007202422 2527 Hoosier Academy - Indianapolis   Regular School Yes Other KG 12 2017   kindergarten                         10.0 3.0                       13.0                         10 3                 13
1304774 IN     school 1800081 9865   Hoosier Acad Virtual Charter 180008102458 5290 Hoosier Acad Virtual Charter Sch   Regular School Yes Other KG 12 2017   kindergarten                         82.0 88.0                       170.0                         82 88                 170
1304798 IN     school 1800099 9875   Rock Creek Community Academy 180009902497 771 Rock Creek Community Academy   Regular School Yes Other KG 12 2017   kindergarten                         19.0 21.0                       40.0                         19 21                 40

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