Data source: Big Local News · About: Big Local

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

View and edit SQL

year

grade

  • pre_kindergarten · 2,850
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
1790453 IN     school 1801200 3060   Carmel Clay Schools 180120002101 2518 Forest Dale Elementary School   Regular School No Elementary PK 05 2018   pre_kindergarten                         16.0 8.0                       24.0                         16 8                 24
1910098 IN     school 1801200 3060   Carmel Clay Schools 180120002332 2508 Cherry Tree Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten                         19.0 11.0                       30.0                         19 11                 30
1910124 IN     school 1801200 3060   Carmel Clay Schools 180120000036 2512 Smoky Row Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten                         17.0 18.0                       35.0                         17 18                 35
1910132 IN     school 1801200 3060   Carmel Clay Schools 180120002267 2513 Orchard Park Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten                         31.0 7.0                       38.0                         31 7                 38
1910154 IN     school 1801200 3060   Carmel Clay Schools 180120002101 2518 Forest Dale Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten                         21.0 2.0                       23.0                         21 2                 23
1922053 IN     school 1801200 3060   Carmel Clay Schools 180120002332 2508 Cherry Tree Elementary School   Regular School No Elementary PK 05 2021   pre_kindergarten                         22.0 10.0                       32.0                         22 10                 32
1922079 IN     school 1801200 3060   Carmel Clay Schools 180120000036 2512 Smoky Row Elementary School   Regular School No Elementary PK 05 2021   pre_kindergarten                         13.0 7.0                       20.0                         13 7                 20
1922087 IN     school 1801200 3060   Carmel Clay Schools 180120002267 2513 Orchard Park Elementary School   Regular School No Elementary PK 05 2021   pre_kindergarten                         16.0 3.0                       19.0                         16 3                 19
1922109 IN     school 1801200 3060   Carmel Clay Schools 180120002101 2518 Forest Dale Elementary School   Regular School No Elementary PK 05 2021   pre_kindergarten                         11.0 6.0                       17.0                         11 6                 17
1160396 IN     school 1801290 750   Carroll Consolidated Sch Corp 180129002103 629 Carroll Elementary   Regular School No 1.0 PK 06 2015   pre_kindergarten                         1.0 0.0                       1.0                         1 0                 1
1293849 IN     school 1801290 750   Carroll Consolidated School Corp 180129002103 629 Carroll Elementary School   Regular School No Elementary PK 06 2017   pre_kindergarten                         3.0 1.0                       4.0                         3 1                 4
1752468 IN     school 1801290 750   Carroll Consolidated School Corp 180129002103 629 Carroll Elementary School   Regular School No Elementary PK 06 2019   pre_kindergarten                         1.0 1.0                       2.0                         1 1                 2
1788217 IN     school 1801290 750   Carroll Consolidated School Corp 180129002103 629 Carroll Elementary School   Regular School No Elementary PK 06 2018   pre_kindergarten                         15.0 17.0                       32.0                         15 17                 32
1907906 IN     school 1801290 750   Carroll Consolidated School Corp 180129002103 629 Carroll Elementary School   Regular School No Elementary PK 06 2020   pre_kindergarten                         10.0 11.0                       21.0                         10 11                 21
1919873 IN     school 1801290 750   Carroll Consolidated School Corp 180129002103 629 Carroll Elementary School   Regular School No Elementary PK 06 2021   pre_kindergarten                         12.0 8.0                       20.0                         12 8                 20
1163897 IN     school 1801440 4205   Center Grove Com Sch Corp 180144000208 3435 Center Grove Elem School   Regular School No 1.0 PK 05 2015   pre_kindergarten                         27.0 8.0                       35.0                         27 8                 35
1297348 IN     school 1801440 4205   Center Grove Community School Corp 180144000208 3435 Center Grove Elementary School   Regular School No Elementary PK 05 2017   pre_kindergarten                         43.0 26.0                       69.0                         43 26                 69
1297383 IN     school 1801440 4205   Center Grove Community School Corp 180144002333 3444 Pleasant Grove Elementary School   Regular School No Elementary PK 05 2017   pre_kindergarten                         2.0 0.0                       2.0                         2 0                 2
1755936 IN     school 1801440 4205   Center Grove Community School Corp 180144000662 3434 Sugar Grove Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         47.0 24.0                       71.0                         47 24                 71
1791698 IN     school 1801440 4205   Center Grove Community School Corp 180144000662 3434 Sugar Grove Elementary School   Regular School No Elementary PK 05 2018   pre_kindergarten                         34.0 15.0                       49.0                         34 15                 49
1911379 IN     school 1801440 4205   Center Grove Community School Corp 180144000662 3434 Sugar Grove Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten                         78.0 37.0                       115.0                         78 37                 115
1923345 IN     school 1801440 4205   Center Grove Community School Corp 180144000662 3434 Sugar Grove Elementary School   Regular School No Elementary PK 05 2021   pre_kindergarten                         69.0 36.0                       105.0                         69 36                 105
1170432 IN     school 1801560 8360   Centerville-Abington Com Schs 180156000218 8984 Rose Hamilton Elementary Sch   Regular School No 1.0 PK 02 2015   pre_kindergarten                         21.0 14.0                       35.0                         21 14                 35
1291819 IN     school 1801560 8360   Centerville-Abington Com Schs 180156000218 8984 Rose Hamilton Elementary Sch   Regular School No 1.0 PK 02 2016   pre_kindergarten                         23.0 12.0                       35.0                         23 12                 35
1303844 IN     school 1801560 8360   Centerville-Abington Com Schs 180156000218 8984 Rose Hamilton Elementary School   Regular School No Elementary PK 02 2017   pre_kindergarten                         21.0 13.0                       34.0                         21 13                 34
1762382 IN     school 1801560 8360   Centerville-Abington Com Schs 180156000218 8984 Rose Hamilton Elementary School   Regular School No Elementary PK 02 2019   pre_kindergarten                         16.0 17.0                       33.0                         16 17                 33
1798166 IN     school 1801560 8360   Centerville-Abington Com Schs 180156000218 8984 Rose Hamilton Elementary School   Regular School No Elementary PK 02 2018   pre_kindergarten                         17.0 10.0                       27.0                         17 10                 27
1917802 IN     school 1801560 8360   Centerville-Abington Com Schs 180156000218 8984 Rose Hamilton Elementary School   Regular School No Elementary PK 02 2020   pre_kindergarten                         22.0 21.0                       43.0                         22 21                 43
1929729 IN     school 1801560 8360   Centerville-Abington Com Schs 180156000218 8984 Rose Hamilton Elementary School   Regular School No Elementary PK 02 2021   pre_kindergarten                         22.0 13.0                       35.0                         22 13                 35
1163869 IN     school 1801890 4145   Clark-Pleasant Com School Corp 180189000247 3425 Whiteland Elementary School   Regular School No 1.0 PK 04 2015   pre_kindergarten                         52.0 30.0                       82.0                         52 30                 82
1285275 IN     school 1801890 4145   Clark-Pleasant Com School Corp 180189000247 3425 Whiteland Elementary School   Regular School No 1.0 PK 04 2016   pre_kindergarten                         45.0 39.0                       84.0                         45 39                 84
1297308 IN     school 1801890 4145   Clark-Pleasant Community Sch Corp 180189001028 3423 Sawmill Woods Elementary School   Regular School No Elementary PK PK 2017   pre_kindergarten                         52.0 46.0                       98.0                         52 46                 98
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
1791665 IN     school 1801890 4145   Clark-Pleasant Community Sch Corp 180189001028 3423 Sawmill Woods Elementary School   Regular School No Prekindergarten PK PK 2018   pre_kindergarten                         95.0 74.0                       169.0                         95 74                 169
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
1923312 IN     school 1801890 4145   Clark-Pleasant Community Sch Corp 180189001028 3423 Sawmill Woods Elementary School   Regular School No Prekindergarten PK PK 2021   pre_kindergarten                         74.0 54.0                       128.0                         74 54                 128
1160552 IN     school 1801920 1000   Clarksville Com School Corp 180192000251 845 Clarksville Elementary School   Regular School No 1.0 PK 04 2015   pre_kindergarten                         9.0 13.0                       22.0                         9 13                 22
1281947 IN     school 1801920 1000   Clarksville Com School Corp 180192000251 845 Clarksville Elementary School   Regular School No 1.0 PK 04 2016   pre_kindergarten                         17.0 10.0                       27.0                         17 10                 27
1294005 IN     school 1801920 1000   Clarksville Community School Corp 180192000251 845 Clarksville Elementary School   Regular School No Elementary PK 04 2017   pre_kindergarten                         12.0 13.0                       25.0                         12 13                 25
1752632 IN     school 1801920 1000   Clarksville Community School Corp 180192000251 845 Clarksville Elementary School   Regular School No Elementary PK 04 2019   pre_kindergarten                         16.0 5.0                       21.0                         16 5                 21
1788371 IN     school 1801920 1000   Clarksville Community School Corp 180192000251 845 Clarksville Elementary School   Regular School No Elementary PK 04 2018   pre_kindergarten                         14.0 12.0                       26.0                         14 12                 26
1908071 IN     school 1801920 1000   Clarksville Community School Corp 180192000251 845 Clarksville Elementary School   Regular School No Elementary PK 04 2020   pre_kindergarten                         10.0 12.0                       22.0                         10 12                 22
1920036 IN     school 1801920 1000   Clarksville Community School Corp 180192000251 845 Clarksville Elementary School   Regular School No Elementary PK 04 2021   pre_kindergarten                         8.0 17.0                       25.0                         8 17                 25
1160746 IN     school 1800840 1125   Clay Community Schools 180084000158 941 East Side Elementary School   Regular School No 1.0 PK 05 2015   pre_kindergarten                         11.0 15.0                       26.0                         11 15                 26
1160755 IN     school 1800840 1125   Clay Community Schools 180084000159 942 Forest Park Elementary School   Regular School No 1.0 PK 07 2015   pre_kindergarten                         19.0 12.0                       31.0                         19 12                 31
1160763 IN     school 1800840 1125   Clay Community Schools 180084000161 949 Meridian Street Elem School   Regular School No 1.0 PK 05 2015   pre_kindergarten                         14.0 16.0                       30.0                         14 16                 30
1282148 IN     school 1800840 1125   Clay Community Schools 180084000158 941 East Side Elementary School   Regular School No 1.0 PK 05 2016   pre_kindergarten                         16.0 14.0                       30.0                         16 14                 30
1282157 IN     school 1800840 1125   Clay Community Schools 180084000159 942 Forest Park Elementary School   Regular School No 1.0 PK 08 2016   pre_kindergarten                         10.0 6.0                       16.0                         10 6                 16
1282165 IN     school 1800840 1125   Clay Community Schools 180084000161 949 Meridian Street Elem School   Regular School No 1.0 PK 05 2016   pre_kindergarten                         15.0 12.0                       27.0                         15 12                 27
1294207 IN     school 1800840 1125   Clay Community Schools 180084000158 941 East Side Elementary School   Regular School No Elementary PK 05 2017   pre_kindergarten                         14.0 13.0                       27.0                         14 13                 27
1294215 IN     school 1800840 1125   Clay Community Schools 180084000159 942 Forest Park Elementary School   Regular School No Elementary PK 05 2017   pre_kindergarten                         15.0 10.0                       25.0                         15 10                 25
1294223 IN     school 1800840 1125   Clay Community Schools 180084000161 949 Meridian Street Elementary School   Regular School No Elementary PK 05 2017   pre_kindergarten                         17.0 14.0                       31.0                         17 14                 31
1752823 IN     school 1800840 1125   Clay Community Schools 180084000158 941 East Side Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         17.0 12.0                       29.0                         17 12                 29
1752831 IN     school 1800840 1125   Clay Community Schools 180084000159 942 Forest Park Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         16.0 9.0                       25.0                         16 9                 25
1752839 IN     school 1800840 1125   Clay Community Schools 180084000161 949 Meridian Street Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         11.0 19.0                       30.0                         11 19                 30
1788564 IN     school 1800840 1125   Clay Community Schools 180084000158 941 East Side Elementary School   Regular School No Elementary PK 05 2018   pre_kindergarten                         15.0 14.0                       29.0                         15 14                 29
1788572 IN     school 1800840 1125   Clay Community Schools 180084000159 942 Forest Park Elementary School   Regular School No Elementary PK 05 2018   pre_kindergarten                         16.0 7.0                       23.0                         16 7                 23
1788580 IN     school 1800840 1125   Clay Community Schools 180084000161 949 Meridian Street Elementary School   Regular School No Elementary PK 05 2018   pre_kindergarten                         10.0 21.0                       31.0                         10 21                 31
1908252 IN     school 1800840 1125   Clay Community Schools 180084000158 941 East Side Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten                         17.0 11.0                       28.0                         17 11                 28
1908260 IN     school 1800840 1125   Clay Community Schools 180084000159 942 Forest Park Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten                         17.0 10.0                       27.0                         17 10                 27
1908268 IN     school 1800840 1125   Clay Community Schools 180084000161 949 Meridian Street Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten                         13.0 15.0                       28.0                         13 15                 28
1920227 IN     school 1800840 1125   Clay Community Schools 180084000158 941 East Side Elementary School   Regular School No Elementary PK 05 2021   pre_kindergarten                         10.0 10.0                       20.0                         10 10                 20
1920235 IN     school 1800840 1125   Clay Community Schools 180084000159 942 Forest Park Elementary School   Regular School No Elementary PK 05 2021   pre_kindergarten                         16.0 9.0                       25.0                         16 9                 25
1920243 IN     school 1800840 1125   Clay Community Schools 180084000161 949 Meridian Street Elementary School   Regular School No Elementary PK 05 2021   pre_kindergarten                         11.0 17.0                       28.0                         11 17                 28
1160779 IN     school 1802130 1150   Clinton Central School Corp 180213000256 961 Clinton Central Elem School   Regular School No 1.0 PK 06 2015   pre_kindergarten                         7.0 4.0                       11.0                         7 4                 11
1282181 IN     school 1802130 1150   Clinton Central School Corp 180213000256 961 Clinton Central Elementary School   Regular School No 1.0 PK 06 2016   pre_kindergarten                         2.0 0.0                       2.0                         2 0                 2
1920259 IN     school 1802130 1150   Clinton Central School Corporation 180213000256 961 Clinton Central Elementary School   Regular School No Elementary PK 06 2021   pre_kindergarten                         3.0 3.0                       6.0                         3 3                 6
1282197 IN     school 1802160 1160   Clinton Prairie School Corp 180216002245 981 Clinton Prairie Elementary School   Regular School No 1.0 PK 06 2016   pre_kindergarten                         11.0 6.0                       17.0                         11 6                 17
1294254 IN     school 1802160 1160   Clinton Prairie School Corporation 180216002245 981 Clinton Prairie Elementary School   Regular School No Elementary PK 06 2017   pre_kindergarten                         10.0 5.0                       15.0                         10 5                 15
1752870 IN     school 1802160 1160   Clinton Prairie School Corporation 180216002245 981 Clinton Prairie Elementary School   Regular School No Elementary PK 06 2019   pre_kindergarten                         31.0 18.0                       49.0                         31 18                 49
1788611 IN     school 1802160 1160   Clinton Prairie School Corporation 180216002245 981 Clinton Prairie Elementary School   Regular School No Elementary PK 06 2018   pre_kindergarten                         8.0 3.0                       11.0                         8 3                 11
1908299 IN     school 1802160 1160   Clinton Prairie School Corporation 180216002245 981 Clinton Prairie Elementary School   Regular School No Elementary PK 06 2020   pre_kindergarten                         17.0 19.0                       36.0                         17 19                 36
1920275 IN     school 1802160 1160   Clinton Prairie School Corporation 180216002245 981 Clinton Prairie Elementary School   Regular School No Elementary PK 06 2021   pre_kindergarten                         16.0 22.0                       38.0                         16 22                 38
1168312 IN     school 1802220 6750   Cloverdale Community Schools 180222000264 7082 Cloverdale Elementary School   Regular School No 1.0 PK 04 2015   pre_kindergarten                         26.0 16.0                       42.0                         26 16                 42
1289704 IN     school 1802220 6750   Cloverdale Community Schools 180222000264 7082 Cloverdale Elementary School   Regular School No 1.0 PK 04 2016   pre_kindergarten                         27.0 19.0                       46.0                         27 19                 46
1301728 IN     school 1802220 6750   Cloverdale Community Schools 180222000264 7082 Cloverdale Elementary School   Regular School No Elementary PK 04 2017   pre_kindergarten                         33.0 18.0                       51.0                         33 18                 51
1760217 IN     school 1802220 6750   Cloverdale Community Schools 180222000264 7082 Cloverdale Elementary School   Regular School No Elementary PK 04 2019   pre_kindergarten                         33.0 16.0                       49.0                         33 16                 49
1796047 IN     school 1802220 6750   Cloverdale Community Schools 180222000264 7082 Cloverdale Elementary School   Regular School No Elementary PK 04 2018   pre_kindergarten                         21.0 20.0                       41.0                         21 20                 41
1915628 IN     school 1802220 6750   Cloverdale Community Schools 180222000264 7082 Cloverdale Elementary School   Regular School No Elementary PK 04 2020   pre_kindergarten                         27.0 19.0                       46.0                         27 19                 46
1927555 IN     school 1802220 6750   Cloverdale Community Schools 180222000264 7082 Cloverdale Elementary School   Regular School No Elementary PK 04 2021   pre_kindergarten                         21.0 20.0                       41.0                         21 20                 41
1762856 IN     school 1800011 9320   Community Montessori Inc 180001101737 1536 Community Montessori   Regular School Yes Other PK 12 2019   pre_kindergarten                         1.0 5.0                       6.0                         1 5                 6
1918319 IN     school 1800011 9320   Community Montessori Inc 180001101737 1536 Community Montessori   Regular School Yes Other PK 12 2020   pre_kindergarten                         4.0 3.0                       7.0                         4 3                 7
1930295 IN     school 1800011 9320   Community Montessori Inc 180001101737 1536 Community Montessori   Regular School Yes Other PK 12 2021   pre_kindergarten                         3.0 0.0                       3.0                         3 0                 3
1160808 IN     school 1803660 1170   Community Schools of Frankfort 180366002423 1014 Blue Ridge Primary Elementary Schl   Regular School No 1.0 PK 02 2015   pre_kindergarten                         32.0 13.0                       45.0                         32 13                 45
1160820 IN     school 1803660 1170   Community Schools of Frankfort 180366000602 1020 Suncrest Elementary Sch   Regular School No 1.0 PK 05 2015   pre_kindergarten                         20.0 8.0                       28.0                         20 8                 28
1282211 IN     school 1803660 1170   Community Schools of Frankfort 180366002423 1014 Blue Ridge Primary Elementary Sch   Regular School No 1.0 PK 02 2016   pre_kindergarten                         37.0 10.0                       47.0                         37 10                 47
1282223 IN     school 1803660 1170   Community Schools of Frankfort 180366000602 1020 Suncrest Elementary School   Regular School No 1.0 PK 05 2016   pre_kindergarten                         21.0 14.0                       35.0                         21 14                 35
1294268 IN     school 1803660 1170   Community Schools of Frankfort 180366002423 1014 Blue Ridge Primary Elementary Sch   Regular School No Elementary PK 02 2017   pre_kindergarten                         25.0 16.0                       41.0                         25 16                 41
1294280 IN     school 1803660 1170   Community Schools of Frankfort 180366000602 1020 Suncrest Elementary School   Regular School No Elementary PK 05 2017   pre_kindergarten                         19.0 10.0                       29.0                         19 10                 29
1752884 IN     school 1803660 1170   Community Schools of Frankfort 180366002423 1014 Blue Ridge Primary Elementary Sch   Regular School No Elementary PK 02 2019   pre_kindergarten                         32.0 21.0                       53.0                         32 21                 53
1752896 IN     school 1803660 1170   Community Schools of Frankfort 180366000602 1020 Suncrest Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         31.0 22.0                       53.0                         31 22                 53
1788625 IN     school 1803660 1170   Community Schools of Frankfort 180366002423 1014 Blue Ridge Primary Elementary Sch   Regular School No Elementary PK 02 2018   pre_kindergarten                         26.0 18.0                       44.0                         26 18                 44
1788637 IN     school 1803660 1170   Community Schools of Frankfort 180366000602 1020 Suncrest Elementary School   Regular School No Elementary PK 05 2018   pre_kindergarten                         17.0 7.0                       24.0                         17 7                 24
1908313 IN     school 1803660 1170   Community Schools of Frankfort 180366002423 1014 Blue Ridge Primary Elementary Sch   Regular School No Elementary PK 02 2020   pre_kindergarten                         25.0 18.0                       43.0                         25 18                 43
1908325 IN     school 1803660 1170   Community Schools of Frankfort 180366000602 1020 Suncrest Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten                         25.0 21.0                       46.0                         25 21                 46
1920289 IN     school 1803660 1170   Community Schools of Frankfort 180366002423 1014 Blue Ridge Primary Elementary Sch   Regular School No Elementary PK 02 2021   pre_kindergarten                         26.0 15.0                       41.0                         26 15                 41
1920301 IN     school 1803660 1170   Community Schools of Frankfort 180366000602 1020 Suncrest Elementary School   Regular School No Elementary PK 05 2021   pre_kindergarten                         24.0 27.0                       51.0                         24 27                 51
1162008 IN     school 1802430 2440   Covington Community Sch Corp 180243000276 2009 Covington Elementary School   Regular School No 1.0 PK 05 2015   pre_kindergarten                         31.0 34.0                       65.0                         31 34                 65
1283419 IN     school 1802430 2440   Covington Community Sch Corp 180243000276 2009 Covington Elementary School   Regular School No 1.0 PK 05 2016   pre_kindergarten                         19.0 22.0                       41.0                         19 22                 41
1295463 IN     school 1802430 2440   Covington Community School Corp 180243000276 2009 Covington Elementary School   Regular School No Elementary PK 05 2017   pre_kindergarten                         22.0 18.0                       40.0                         22 18                 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]);