Data source: Big Local News · About: Big Local

3,050 rows where grade = "pre_kindergarten" and state = "IN" sorted by male_int descending

View and edit SQL

year

grade

  • pre_kindergarten · 3,050
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
1303238 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002491 8327 Culver Family Learning Center   Regular School No Elementary PK PK 2017   pre_kindergarten                         339.0 153.0                       492.0                         339 153                 492
1291208 IN     school 1803450 7995   Evansville Vanderburgh Sch Corp 180345002491 8327 Culver Family Learning Center   Regular School No 1.0 PK PK 2016   pre_kindergarten                         330.0 151.0                       481.0                         330 151                 481
1761761 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002491 8327 Culver Family Learning Center   Regular School No Prekindergarten PK PK 2019   pre_kindergarten                         290.0 138.0                       428.0                         290 138                 428
1797553 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002491 8327 Culver Family Learning Center   Regular School No Prekindergarten PK PK 2018   pre_kindergarten                         289.0 142.0                       431.0                         289 142                 431
1286121 IN     school 1803870 4690   Gary Community School Corp 180387000640 4057 Mary M Bethune Early Child Dev Ctr   Regular School No 1.0 PK PK 2016   pre_kindergarten                         280.0 253.0                       533.0                         280 253                 533
1917166 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002491 8327 Culver Family Learning Center   Regular School No Prekindergarten PK PK 2020   pre_kindergarten                         279.0 137.0                       416.0                         279 137                 416
1298164 IN     school 1803870 4690   Gary Community School Corp 180387000640 4057 Mary M Bethune Early Child Dev Ctr   Regular School No Elementary PK PK 2017   pre_kindergarten                         270.0 277.0                       547.0                         270 277                 547
1757722 IN     school 1805670 5330   M S D Lawrence Township 180567002205 5284 Early Learning Center   Regular School No Elementary PK KG 2019   pre_kindergarten                         266.0 197.0                       463.0                         266 197                 463
1793511 IN     school 1805670 5330   M S D Lawrence Township 180567002205 5284 Early Learning Center   Regular School No Elementary PK KG 2018   pre_kindergarten                         264.0 175.0                       439.0                         264 175                 439
1792509 IN     school 1803870 4690   Gary Community School Corp 180387000640 4057 Mary M Bethune Early Child Dev Ctr   Regular School No Prekindergarten PK PK 2018   pre_kindergarten                         241.0 269.0                       510.0                         241 269                 510
1913141 IN     school 1805670 5330   M S D Lawrence Township 180567002205 5284 Early Learning Center   Regular School No Elementary PK KG 2020   pre_kindergarten                         241.0 164.0                       405.0                         241 164                 405
1929101 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002491 8327 Culver Family Learning Center   Regular School No Prekindergarten PK PK 2021   pre_kindergarten                         234.0 95.0                       329.0                         234 95                 329
1299184 IN     school 1805670 5330   M S D Lawrence Township 180567002205 5284 Early Learning Center   Regular School No Elementary PK KG 2017   pre_kindergarten                         226.0 191.0                       417.0                         226 191                 417
1164731 IN     school 1803870 4690   Gary Community School Corp 180387000640 4057 Mary M Bethune Early Child Dev Ctr   Regular School No 1.0 PK PK 2015   pre_kindergarten                         224.0 294.0                       518.0                         224 294                 518
1286953 IN     school 1800150 5275   Anderson Community School Corp 180015002557 5023 Southview Preschool Center   Regular School No 1.0 PK PK 2016   pre_kindergarten                         206.0 137.0                       343.0                         206 137                 343
1916790 IN     school 1805400 7855   Lafayette School Corporation 180540000966 8125 Greater Lafayette Area SE   Special Education School No Prekindergarten PK PK 2020   pre_kindergarten                         203.0 81.0                       284.0                         203 81                 284
1298988 IN     school 1800150 5275   Anderson Community School Corp 180015002557 5023 Southview Preschool Center   Regular School No Elementary PK PK 2017   pre_kindergarten                         199.0 126.0                       325.0                         199 126                 325
1163431 IN     school 1805370 3500   Kokomo School Corporation 180537000946 2961 Elwood Haynes Elementary School   Regular School No 1.0 PK 05 2015   pre_kindergarten                         198.0 209.0                       407.0                         198 209                 407
1165558 IN     school 1800150 5275   Anderson Community School Corp 180015002557 5023 Southview Preschool Center   Regular School No 1.0 PK PK 2015   pre_kindergarten                         195.0 118.0                       313.0                         195 118                 313
1290855 IN     school 1805400 7855   Lafayette School Corporation 180540000966 8125 Greater Lafayette Area SE   Special Education School No 1.0 PK PK 2016   pre_kindergarten                         194.0 75.0                       269.0                         194 75                 269
1793833 IN     school 1812360 5360   M S D Warren Township 181236000726 5395 Warren Early Childhood Center   Regular School No Prekindergarten PK PK 2018   pre_kindergarten                         193.0 140.0                       333.0                         193 140                 333
1287144 IN     school 1805670 5330   M S D Lawrence Township 180567002205 5284 Early Learning Center   Regular School No 1.0 PK KG 2016   pre_kindergarten                         191.0 162.0                       353.0                         191 162                 353
1758044 IN     school 1812360 5360   M S D Warren Township 181236000726 5395 Warren Early Childhood Center   Regular School No Prekindergarten PK PK 2019   pre_kindergarten                         191.0 127.0                       318.0                         191 127                 318
1793315 IN     school 1800150 5275   Anderson Community School Corp 180015002557 5023 Southview Preschool Center   Regular School No Prekindergarten PK PK 2018   pre_kindergarten                         190.0 129.0                       319.0                         190 129                 319
1165748 IN     school 1805670 5330   M S D Lawrence Township 180567002205 5284 Early Learning Center   Regular School No 1.0 PK KG 2015   pre_kindergarten                         188.0 158.0                       346.0                         188 158                 346
1168942 IN     school 1810290 7205   South Bend Community Sch Corp 181029002574 7617 Studebaker Center   Regular School No 4.0 PK 12 2015   pre_kindergarten                         186.0 114.0                       300.0                         186 114                 300
1299506 IN     school 1812360 5360   M S D Warren Township 181236000726 5395 Warren Early Childhood Center   Regular School No Elementary PK PK 2017   pre_kindergarten                         186.0 141.0                       327.0                         186 141                 327
1302883 IN     school 1805400 7855   Lafayette School Corporation 180540000966 8125 Greater Lafayette Area SE   Special Education School No Elementary PK PK 2017   pre_kindergarten                         186.0 74.0                       260.0                         186 74                 260
1169464 IN     school 1805400 7855   Lafayette School Corporation 180540000966 8125 Greater Lafayette Area SE   Special Education School No 1.0 PK PK 2015   pre_kindergarten                         184.0 66.0                       250.0                         184 66                 250
1284836 IN     school 1805370 3500   Kokomo School Corporation 180537000946 2961 Elwood Haynes Elementary School   Regular School No 1.0 PK 05 2016   pre_kindergarten                         181.0 213.0                       394.0                         181 213                 394
1913469 IN     school 1812360 5360   M S D Warren Township 181236000726 5395 Warren Early Childhood Center   Regular School No Prekindergarten PK PK 2020   pre_kindergarten                         175.0 147.0                       322.0                         175 147                 322
1290327 IN     school 1810290 7205   South Bend Community Sch Corp 181029002574 7617 Studebaker Center   Regular School No 4.0 PK 12 2016   pre_kindergarten                         174.0 110.0                       284.0                         174 110                 284
1295730 IN     school 1806390 2865   Marion Community Schools 180639002396 2370 Marion Early Childhood Ed Cntr   Regular School No Elementary PK PK 2017   pre_kindergarten                         174.0 176.0                       350.0                         174 176                 350
1928368 IN     school 1810140 7365   Shelbyville Central Schools 181014002687 7723 Golden Bear Preschool   Regular School No Elementary PK KG 2021   pre_kindergarten                         174.0 113.0                       287.0                         174 113                 287
1909877 IN     school 1810650 3005   Hamilton Southeastern Schools 181065001866 2466 Brooks School Elementary   Regular School No Elementary PK 04 2020   pre_kindergarten                         170.0 118.0                       288.0                         170 118                 288
1283686 IN     school 1806390 2865   Marion Community Schools 180639002396 2370 Marion Early Childhood Ed Cntr   Regular School No 1.0 PK PK 2016   pre_kindergarten                         167.0 154.0                       321.0                         167 154                 321
1296871 IN     school 1805370 3500   Kokomo School Corporation 180537000946 2961 Elwood Haynes Elementary School   Regular School No Elementary PK 05 2017   pre_kindergarten                         167.0 161.0                       328.0                         167 161                 328
1928721 IN     school 1805400 7855   Lafayette School Corporation 180540000966 8125 Greater Lafayette Area SE   Special Education School No Prekindergarten PK PK 2021   pre_kindergarten                         166.0 60.0                       226.0                         166 60                 226
1761383 IN     school 1805400 7855   Lafayette School Corporation 180540000966 8125 Greater Lafayette Area SE   Special Education School No Prekindergarten PK PK 2019   pre_kindergarten                         164.0 79.0                       243.0                         164 79                 243
1283800 IN     school 1810650 3005   Hamilton Southeastern Schools 181065001866 2466 Brooks School Elementary   Regular School No 1.0 PK 04 2016   pre_kindergarten                         163.0 102.0                       265.0                         163 102                 265
1791228 IN     school 1805370 3500   Kokomo School Corporation 180537000946 2961 Elwood Haynes Elementary School   Regular School No Elementary PK 05 2018   pre_kindergarten                         162.0 157.0                       319.0                         162 157                 319
1162390 IN     school 1810650 3005   Hamilton Southeastern Schools 181065001866 2466 Brooks School Elementary   Regular School No 1.0 PK 04 2015   pre_kindergarten                         161.0 88.0                       249.0                         161 88                 249
1756739 IN     school 1803870 4690   Gary Community School Corp 180387000640 4057 Mary M Bethune Early Child Dev Ctr   Regular School No Prekindergarten PK PK 2019   pre_kindergarten                         156.0 183.0                       339.0                         156 183                 339
1790072 IN     school 1806390 2865   Marion Community Schools 180639002396 2370 Marion Early Childhood Ed Cntr   Regular School No Prekindergarten PK PK 2018   pre_kindergarten                         156.0 182.0                       338.0                         156 182                 338
1755490 IN     school 1805370 3500   Kokomo School Corporation 180537000946 2961 Elwood Haynes Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         150.0 138.0                       288.0                         150 138                 288
1166067 IN     school 1812360 5360   M S D Warren Township 181236000726 5395 Warren Early Childhood Ctr   Regular School No 1.0 PK PK 2015   pre_kindergarten                         149.0 112.0                       261.0                         149 112                 261
1792437 IN     school 1802880 4670   School City of East Chicago 180288000365 3937 Carrie Gosch PK Center   Regular School No Prekindergarten PK PK 2018   pre_kindergarten                         149.0 116.0                       265.0                         149 116                 265
1284397 IN     school 1801020 3305   Brownsburg Community Sch Corp 180102002562 2707 Brownsburg Early Childhood Center   Regular School No 1.0 PK PK 2016   pre_kindergarten                         148.0 94.0                       242.0                         148 94                 242
1797199 IN     school 1805400 7855   Lafayette School Corporation 180540000966 8125 Greater Lafayette Area SE   Special Education School No Prekindergarten PK PK 2018   pre_kindergarten                         148.0 65.0                       213.0                         148 65                 213
1295835 IN     school 1810650 3005   Hamilton Southeastern Schools 181065001866 2466 Brooks School Elementary   Regular School No Elementary PK 04 2017   pre_kindergarten                         147.0 80.0                       227.0                         147 80                 227
1790788 IN     school 1801020 3305   Brownsburg Community School Corp 180102002562 2707 Brownsburg Early Childhood Center   Regular School No Prekindergarten PK PK 2018   pre_kindergarten                         145.0 99.0                       244.0                         145 99                 244
1296435 IN     school 1801020 3305   Brownsburg Community School Corp 180102002562 2707 Brownsburg Early Childhood Center   Regular School No Elementary PK PK 2017   pre_kindergarten                         144.0 103.0                       247.0                         144 103                 247
1755043 IN     school 1801020 3305   Brownsburg Community School Corp 180102002562 2707 Brownsburg Early Childhood Center   Regular School No Prekindergarten PK PK 2019   pre_kindergarten                         144.0 104.0                       248.0                         144 104                 248
1916435 IN     school 1810140 7365   Shelbyville Central Schools 181014002687 7723 Golden Bear Preschool   Regular School No Elementary PK KG 2020   pre_kindergarten                         144.0 125.0                       269.0                         144 125                 269
1168863 IN     school 1810290 7205   South Bend Community Sch Corp 181029001667 7557 Lafayette Early Childhood Center   Regular School No 1.0 PK PK 2015   pre_kindergarten                         143.0 85.0                       228.0                         143 85                 228
1754337 IN     school 1806390 2865   Marion Community Schools 180639002396 2370 Marion Early Childhood Ed Cntr   Regular School No Prekindergarten PK PK 2019   pre_kindergarten                         143.0 164.0                       307.0                         143 164                 307
1290317 IN     school   7205   South Bend Community Sch Corp   7605 South Bend SNAP             2016   pre_kindergarten                         142.0 54.0                       196.0                         142 54                 196
1916256 IN     school   7205   South Bend Community School Corp   7605 South Bend SNAP             2020   pre_kindergarten                         142.0 59.0                       201.0                         142 59                 201
1910936 IN     school 1805370 3500   Kokomo School Corporation 180537000946 2961 Elwood Haynes Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten                         141.0 148.0                       289.0                         141 148                 289
1921830 IN     school 1810650 3005   Hamilton Southeastern Schools 181065001866 2466 Brooks School Elementary   Regular School No Elementary PK 04 2021   pre_kindergarten                         141.0 65.0                       206.0                         141 65                 206
1287469 IN     school 1812360 5360   M S D Warren Township 181236000726 5395 Warren Early Childhood Center   Regular School No 1.0 PK PK 2016   pre_kindergarten                         139.0 146.0                       285.0                         139 146                 285
1924148 IN     school 1803870 4690   Gary Community School Corp 180387000640 4057 Mary M Bethune Early Child Dev Ctr   Regular School No Prekindergarten PK PK 2021   pre_kindergarten                         138.0 155.0                       293.0                         138 155                 293
1757525 IN     school 1800150 5275   Anderson Community School Corp 180015002557 5023 Southview Preschool Center   Regular School No Prekindergarten PK PK 2019   pre_kindergarten                         137.0 89.0                       226.0                         137 89                 226
1912948 IN     school 1800150 5275   Anderson Community School Corp 180015002557 5023 Southview Preschool Center   Regular School No Prekindergarten PK PK 2020   pre_kindergarten                         135.0 108.0                       243.0                         135 108                 243
1760851 IN     school 1810290 7205   South Bend Community School Corp 181029002574 7617 Studebaker Center   Regular School No Prekindergarten PK PK 2019   pre_kindergarten                         134.0 90.0                       224.0                         134 90                 224
1913109 IN     school 1803750 5310   Franklin Township Com Sch Corp 180375002678 5317 Wanamaker Early Learning Center   Regular School No Prekindergarten PK PK 2020   pre_kindergarten                         133.0 71.0                       204.0                         133 71                 204
1925018 IN     school 1803750 5310   Franklin Township Com Sch Corp 180375002678 5317 Wanamaker Early Learning Center   Regular School No Prekindergarten PK PK 2021   pre_kindergarten                         133.0 90.0                       223.0                         133 90                 223
1925050 IN     school 1805670 5330   MSD Lawrence Township 180567002205 5284 Early Learning Center   Regular School No Elementary PK KG 2021   pre_kindergarten                         133.0 104.0                       237.0                         133 104                 237
1760848 IN     school   7205   South Bend Community School Corp   7605 South Bend SNAP             2019   pre_kindergarten                         132.0 87.0                       219.0                         132 87                 219
1916259 IN     school 1810290 7205   South Bend Community School Corp 181029002574 7617 Studebaker Center   Regular School No Prekindergarten PK PK 2020   pre_kindergarten                         130.0 82.0                       212.0                         130 82                 212
1928192 IN     school   7205   South Bend Community School Corp   7605 South Bend SNAP             2021   pre_kindergarten                         130.0 71.0                       201.0                         130 71                 201
1912180 IN     school 1803870 4690   Gary Community School Corp 180387000640 4057 Mary M Bethune Early Child Dev Ctr   Regular School No Elementary PK KG 2020   pre_kindergarten                         126.0 159.0                       285.0                         126 159                 285
1302354 IN     school 1810290 7205   South Bend Community School Corp 181029002574 7617 Studebaker Center   Regular School No Elementary PK PK 2017   pre_kindergarten                         123.0 77.0                       200.0                         123 77                 200
1162992 IN     school 1801020 3305   Brownsburg Community Sch Corp 180102002562 2707 Brownsburg Early Childhood Center   Regular School No 1.0 PK PK 2015   pre_kindergarten                         121.0 74.0                       195.0                         121 74                 195
1756673 IN     school 1802880 4670   School City of East Chicago 180288000365 3937 Carrie Gosch PK Center   Regular School No Prekindergarten PK PK 2019   pre_kindergarten                         121.0 119.0                       240.0                         121 119                 240
1796658 IN     school   7205   South Bend Community School Corp   7605 South Bend SNAP             2018   pre_kindergarten                         120.0 58.0                       178.0                         120 58                 178
1911346 IN     school 1801890 4145   Clark-Pleasant Community Sch Corp 180189001028 3423 Sawmill Woods Elementary School   Regular School No Prekindergarten PK PK 2020   pre_kindergarten                         119.0 70.0                       189.0                         119 70                 189
1912113 IN     school 1802880 4670   School City of East Chicago 180288000365 3937 Carrie Gosch PK Center   Regular School No Prekindergarten PK PK 2020   pre_kindergarten                         119.0 120.0                       239.0                         119 120                 239
1922895 IN     school 1805370 3500   Kokomo School Corporation 180537000946 2961 Elwood Haynes Elementary School   Regular School No Elementary PK 05 2021   pre_kindergarten                         119.0 110.0                       229.0                         119 110                 229
1790947 IN     school 1808970 3330   Plainfield Community School Corp 180897002569 2753 Little Quakers Academy   Regular School No Prekindergarten PK PK 2018   pre_kindergarten                         118.0 71.0                       189.0                         118 71                 189
1298741 IN     school 1805580 4945   LaPorte Community School Corp 180558001015 4741 LaPorte High School   Regular School No High 09 12 2017   pre_kindergarten                         116.0 67.0                       183.0                         116 67                 183
1168930 IN     school   7205   South Bend Community Sch Corp   7605 South Bend SNAP             2015   pre_kindergarten                         114.0 39.0                       153.0                         114 39                 153
1793365 IN     school 1803300 5280   Elwood Community School Corp 180330000448 5157 Elwood Elementary School   Regular School No Elementary PK 02 2018   pre_kindergarten                         112.0 94.0                       206.0                         112 94                 206
1755903 IN     school 1801890 4145   Clark-Pleasant Community Sch Corp 180189001028 3423 Sawmill Woods Elementary School   Regular School No Prekindergarten PK PK 2019   pre_kindergarten                         111.0 74.0                       185.0                         111 74                 185
1925380 IN     school 1812360 5360   MSD Warren Township 181236000726 5395 Warren Early Childhood Center   Regular School No Prekindergarten PK PK 2021   pre_kindergarten                         111.0 88.0                       199.0                         111 88                 199
1796668 IN     school 1810290 7205   South Bend Community School Corp 181029002574 7617 Studebaker Center   Regular School No High 12 12 2018   pre_kindergarten                         110.0 72.0                       182.0                         110 72                 182
1921339 IN     school 1803510 2395   Fayette County School Corporation 180351000504 1913 Grandview Elementary School   Regular School No Elementary PK 06 2021   pre_kindergarten                         110.0 72.0                       182.0                         110 72                 182
1924969 IN     school 1802640 5300   MSD Decatur Township 180264001065 5192 Liberty Early Elementary School   Regular School No Elementary PK KG 2021   pre_kindergarten                         109.0 58.0                       167.0                         109 58                 167
1283187 IN     school 1803270 2305   Elkhart Community Schools 180327000447 1817 Woodland Elementary School   Regular School No 1.0 PK 06 2016   pre_kindergarten                         108.0 48.0                       156.0                         108 48                 156
1910655 IN     school 1808970 3330   Plainfield Community School Corp 180897002569 2753 Little Quakers Academy   Regular School No Prekindergarten PK PK 2020   pre_kindergarten                         108.0 89.0                       197.0                         108 89                 197
1295227 IN     school 1803270 2305   Elkhart Community Schools 180327000447 1817 Woodland Elementary School   Regular School No Elementary PK 06 2017   pre_kindergarten                         106.0 46.0                       152.0                         106 46                 152
1909739 IN     school 1806870 2855   Mississinewa Community School Corp 180687001193 2344 Westview Elementary School   Regular School No Elementary PK 01 2020   pre_kindergarten                         106.0 71.0                       177.0                         106 71                 177
1790181 IN     school 1810650 3005   Hamilton Southeastern Schools 181065001866 2466 Brooks School Elementary   Regular School No Elementary PK 04 2018   pre_kindergarten                         105.0 68.0                       173.0                         105 68                 173
1913044 IN     school 1802640 5300   M S D Decatur Township 180264001065 5192 Liberty Early Elementary School   Regular School No Elementary PK KG 2020   pre_kindergarten                         105.0 81.0                       186.0                         105 81                 186
1924873 IN     school 1800150 5275   Anderson Community School Corp 180015002557 5023 Southview Preschool Center   Regular School No Prekindergarten PK PK 2021   pre_kindergarten                         103.0 64.0                       167.0                         103 64                 167
1302345 IN     school   7205   South Bend Community School Corp   7605 South Bend SNAP             2017   pre_kindergarten                         102.0 55.0                       157.0                         102 55                 157
1916188 IN     school 1810290 7205   South Bend Community School Corp 181029001667 7557 Lafayette Early Childhood Center   Regular School No Prekindergarten PK PK 2020   pre_kindergarten                         102.0 98.0                       200.0                         102 98                 200
1793062 IN     school 1805580 4945   LaPorte Community School Corp 180558001015 4741 LaPorte High School   Regular School No High 09 12 2018   pre_kindergarten                         101.0 66.0                       167.0                         101 66                 167
1288734 IN     school 1802460 5855   Crawfordsville Com Schools 180246000285 6305 Anna Willson School   Regular School No 1.0 PK PK 2016   pre_kindergarten                         99.0 49.0                       148.0                         99 49                 148
1755209 IN     school 1808970 3330   Plainfield Community School Corp 180897002569 2753 Little Quakers Academy   Regular School No Prekindergarten PK PK 2019   pre_kindergarten                         99.0 78.0                       177.0                         99 78                 177

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