Data source: Big Local News · About: Big Local

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

View and edit SQL

year

grade

  • pre_kindergarten · 2,950
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
1915598 IN     school 1807980 6715   North Putnam Community Schools 180798001368 7041 Bainbridge Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten                         18.0 23.0                       41.0                         18 23                 41
1927526 IN     school 1807980 6715   North Putnam Community Schools 180798001368 7041 Bainbridge Elementary School   Regular School No Elementary PK 05 2021   pre_kindergarten                         16.0 13.0                       29.0                         16 13                 29
1168455 IN     school 1800390 6895   Batesville Community Sch Corp 180039002381 7218 Batesville Primary School   Regular School No 1.0 PK 02 2015   pre_kindergarten                         7.0 1.0                       8.0                         7 1                 8
1289850 IN     school 1800390 6895   Batesville Community School Corp 180039002381 7218 Batesville Primary School   Regular School No 1.0 PK 02 2016   pre_kindergarten                         2.0 5.0                       7.0                         2 5                 7
1301873 IN     school 1800390 6895   Batesville Community School Corp 180039002381 7218 Batesville Primary School   Regular School No Elementary PK 02 2017   pre_kindergarten                         13.0 7.0                       20.0                         13 7                 20
1760383 IN     school 1800390 6895   Batesville Community School Corp 180039002381 7218 Batesville Primary School   Regular School No Elementary PK 02 2019   pre_kindergarten                         24.0 7.0                       31.0                         24 7                 31
1796191 IN     school 1800390 6895   Batesville Community School Corp 180039002381 7218 Batesville Primary School   Regular School No Elementary PK 02 2018   pre_kindergarten                         8.0 2.0                       10.0                         8 2                 10
1915794 IN     school 1800390 6895   Batesville Community School Corp 180039002381 7218 Batesville Primary School   Regular School No Elementary PK 02 2020   pre_kindergarten                         20.0 18.0                       38.0                         20 18                 38
1927719 IN     school 1800390 6895   Batesville Community School Corp 180039002381 7218 Batesville Primary School   Regular School No Elementary PK 02 2021   pre_kindergarten                         19.0 16.0                       35.0                         19 16                 35
1168711 IN     school 1806840 7200   School City of Mishawaka 180684001175 7473 Beiger Elementary School   Regular School No 1.0 PK 06 2015   pre_kindergarten                         66.0 23.0                       89.0                         66 23                 89
1290102 IN     school 1806840 7200   School City of Mishawaka 180684001175 7473 Beiger Elementary School   Regular School No 1.0 PK 06 2016   pre_kindergarten                         53.0 17.0                       70.0                         53 17                 70
1302128 IN     school 1806840 7200   School City of Mishawaka 180684001175 7473 Beiger Elementary School   Regular School No Elementary PK 06 2017   pre_kindergarten                         83.0 58.0                       141.0                         83 58                 141
1760636 IN     school 1806840 7200   School City of Mishawaka 180684001175 7473 Beiger Elementary School   Regular School No Elementary PK 06 2019   pre_kindergarten                         77.0 67.0                       144.0                         77 67                 144
1796445 IN     school 1806840 7200   School City of Mishawaka 180684001175 7473 Beiger Elementary School   Regular School No Elementary PK 06 2018   pre_kindergarten                         74.0 61.0                       135.0                         74 61                 135
1916046 IN     school 1806840 7200   School City of Mishawaka 180684001175 7473 Beiger Elementary School   Regular School No Elementary PK 06 2020   pre_kindergarten                         64.0 45.0                       109.0                         64 45                 109
1927970 IN     school 1806840 7200   School City of Mishawaka 180684001175 7473 Beiger Elementary School   Regular School No Elementary PK 06 2021   pre_kindergarten                         39.0 16.0                       55.0                         39 16                 55
1792584 IN     school 1804170 4700   Griffith Public Schools 180417000717 4171 Beiriger Elementary School   Regular School No Elementary PK 06 2018   pre_kindergarten                         28.0 10.0                       38.0                         28 10                 38
1912240 IN     school 1804170 4700   Griffith Public Schools 180417000717 4171 Beiriger Elementary School   Regular School No Elementary PK 06 2020   pre_kindergarten                         9.0 3.0                       12.0                         9 3                 12
1751580 IN     school 1807680 25   North Adams Community Schools 180768001316 37 Bellmont Elementary   Regular School No Elementary PK 05 2019   pre_kindergarten                         41.0 31.0                       72.0                         41 31                 72
1907021 IN     school 1807680 25   North Adams Community Schools 180768001316 37 Bellmont Elementary   Regular School No Elementary PK 05 2020   pre_kindergarten                         41.0 32.0                       73.0                         41 32                 73
1918987 IN     school 1807680 25   North Adams Community Schools 180768001316 37 Bellmont Elementary   Regular School No Elementary PK 05 2021   pre_kindergarten                         30.0 20.0                       50.0                         30 20                 50
1170040 IN     school 1812090 8030   Vigo County School Corp 181209001894 8533 Benjamin Franklin Elem School   Regular School No 1.0 PK 05 2015   pre_kindergarten                         34.0 23.0                       57.0                         34 23                 57
1291429 IN     school 1812090 8030   Vigo County School Corp 181209001894 8533 Benjamin Franklin Elem School   Regular School No 1.0 PK 05 2016   pre_kindergarten                         32.0 25.0                       57.0                         32 25                 57
1761986 IN     school 1812090 8030   Vigo County School Corp 181209001894 8533 Benjamin Franklin Elem School   Regular School No Elementary PK 05 2019   pre_kindergarten                         16.0 14.0                       30.0                         16 14                 30
1797774 IN     school 1812090 8030   Vigo County School Corp 181209001894 8533 Benjamin Franklin Elem School   Regular School No Elementary PK 05 2018   pre_kindergarten                         0.0 1.0                       1.0                         0 1                 1
1917400 IN     school 1812090 8030   Vigo County School Corp 181209001894 8533 Benjamin Franklin Elem School   Regular School No Elementary PK 05 2020   pre_kindergarten                         31.0 17.0                       48.0                         31 17                 48
1929338 IN     school 1812090 8030   Vigo County School Corp 181209001894 8533 Benjamin Franklin Elem School   Regular School No Elementary PK 05 2021   pre_kindergarten                         10.0 5.0                       15.0                         10 5                 15
1924274 IN     school 1804320 4710   School City of Hammond 180432000731 4451 Benjamin Franklin Elementary Sch   Regular School No Elementary PK 05 2021   pre_kindergarten                         5.0 3.0                       8.0                         5 3                 8
1164658 IN     school 1802880 4670   School City of East Chicago 180288000364 3941 Benjamin Harrison Elementary Sch   Regular School No 1.0 PK 05 2015   pre_kindergarten                         53.0 58.0                       111.0                         53 58                 111
1286047 IN     school 1802880 4670   School City of East Chicago 180288000364 3941 Benjamin Harrison Elementary Sch   Regular School No 1.0 PK 06 2016   pre_kindergarten                         18.0 39.0                       57.0                         18 39                 57
1298093 IN     school 1802880 4670   School City of East Chicago 180288000364 3941 Benjamin Harrison Elementary Sch   Regular School No Elementary PK 06 2017   pre_kindergarten                         25.0 27.0                       52.0                         25 27                 52
1167173 IN     school 1800630 5740   Monroe County Com Sch Corp 180063000118 6173 Binford Elementary School   Regular School No 1.0 03 06 2015   pre_kindergarten                         11.0 4.0                       15.0                         11 4                 15
1288571 IN     school 1800630 5740   Monroe County Com Sch Corp 180063000118 6173 Binford Elementary School   Regular School No 1.0 03 06 2016   pre_kindergarten                         8.0 12.0                       20.0                         8 12                 20
1300599 IN     school 1800630 5740   Monroe County Community Sch Corp 180063000118 6173 Binford Elementary School   Regular School No Elementary 03 06 2017   pre_kindergarten                         6.0 12.0                       18.0                         6 12                 18
1759098 IN     school 1800630 5740   Monroe County Community Sch Corp 180063000118 6173 Binford Elementary School   Regular School No Elementary 03 06 2019   pre_kindergarten                         11.0 9.0                       20.0                         11 9                 20
1794916 IN     school 1800630 5740   Monroe County Community Sch Corp 180063000118 6173 Binford Elementary School   Regular School No Elementary 03 06 2018   pre_kindergarten                         6.0 11.0                       17.0                         6 11                 17
1914513 IN     school 1800630 5740   Monroe County Community Sch Corp 180063000118 6173 Binford Elementary School   Regular School No Elementary 03 06 2020   pre_kindergarten                         14.0 3.0                       17.0                         14 3                 17
1926392 IN     school 1800630 5740   Monroe County Community Sch Corp 180063000118 6173 Binford Elementary School   Regular School No Elementary 03 06 2021   pre_kindergarten                         7.0 4.0                       11.0                         7 4                 11
1290035 IN     school 1808760 7175   Penn-Harris-Madison Sch Corp 180876002161 7379 Bittersweet Elementary School   Regular School No 1.0 PK 05 2016   pre_kindergarten                         60.0 32.0                       92.0                         60 32                 92
1302060 IN     school 1808760 7175   Penn-Harris-Madison School Corp 180876002161 7379 Bittersweet Elementary School   Regular School No Elementary PK 05 2017   pre_kindergarten                         37.0 27.0                       64.0                         37 27                 64
1760570 IN     school 1808760 7175   Penn-Harris-Madison School Corp 180876002161 7379 Bittersweet Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         31.0 30.0                       61.0                         31 30                 61
1796378 IN     school 1808760 7175   Penn-Harris-Madison School Corp 180876002161 7379 Bittersweet Elementary School   Regular School No Elementary PK 05 2018   pre_kindergarten                         44.0 27.0                       71.0                         44 27                 71
1915981 IN     school 1808760 7175   Penn-Harris-Madison School Corp 180876002161 7379 Bittersweet Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten                         2.0 2.0                       4.0                         2 2                 4
1927906 IN     school 1808760 7175   Penn-Harris-Madison School Corp 180876002161 7379 Bittersweet Elementary School   Regular School No Elementary PK 05 2021   pre_kindergarten                         24.0 16.0                       40.0                         24 16                 40
1170048 IN     school 1812090 8030   Vigo County School Corp 181209001895 8537 Blanche E Fuqua Elem Sch   Regular School No 1.0 PK 05 2015   pre_kindergarten                         18.0 6.0                       24.0                         18 6                 24
1291437 IN     school 1812090 8030   Vigo County School Corp 181209001895 8537 Blanche E Fuqua Elementary School   Regular School No 1.0 PK 05 2016   pre_kindergarten                         24.0 10.0                       34.0                         24 10                 34
1761994 IN     school 1812090 8030   Vigo County School Corp 181209001895 8537 Blanche E Fuqua Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         26.0 15.0                       41.0                         26 15                 41
1917408 IN     school 1812090 8030   Vigo County School Corp 181209001895 8537 Blanche E Fuqua Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten                         33.0 16.0                       49.0                         33 16                 49
1929346 IN     school 1812090 8030   Vigo County School Corp 181209001895 8537 Blanche E Fuqua Elementary School   Regular School No Elementary PK 05 2021   pre_kindergarten                         13.0 2.0                       15.0                         13 2                 15
1162301 IN     school 1800600 2920   Bloomfield School District 180060000112 2417 Bloomfield Elementary School   Regular School No 1.0 PK 06 2015   pre_kindergarten                         2.0 1.0                       3.0                         2 1                 3
1283713 IN     school 1800600 2920   Bloomfield School District 180060000112 2417 Bloomfield Elementary School   Regular School No 1.0 PK 06 2016   pre_kindergarten                         2.0 1.0                       3.0                         2 1                 3
1909798 IN     school 1800600 2920   Bloomfield School District 180060000112 2417 Bloomfield Elementary School   Regular School No Elementary PK 06 2020   pre_kindergarten                         9.0 12.0                       21.0                         9 12                 21
1921749 IN     school 1800600 2920   Bloomfield School District 180060000112 2417 Bloomfield Elementary School   Regular School No Elementary PK 06 2021   pre_kindergarten                         0.0 1.0                       1.0                         0 1                 1
1159744 IN     school 1803630 235   Fort Wayne Community Schools 180363000517 149 Bloomingdale Elementary Sch   Regular School No 1.0 PK 05 2015   pre_kindergarten                         18.0 14.0                       32.0                         18 14                 32
1281136 IN     school 1803630 235   Fort Wayne Community Schools 180363000517 149 Bloomingdale Elementary School   Regular School No 1.0 PK 05 2016   pre_kindergarten                         12.0 19.0                       31.0                         12 19                 31
1293197 IN     school 1803630 235   Fort Wayne Community Schools 180363000517 149 Bloomingdale Elementary School   Regular School No Elementary PK 05 2017   pre_kindergarten                         11.0 15.0                       26.0                         11 15                 26
1751822 IN     school 1803630 235   Fort Wayne Community Schools 180363000517 149 Bloomingdale Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         17.0 16.0                       33.0                         17 16                 33
1787566 IN     school 1803630 235   Fort Wayne Community Schools 180363000517 149 Bloomingdale Elementary School   Regular School No Elementary PK 05 2018   pre_kindergarten                         18.0 14.0                       32.0                         18 14                 32
1907262 IN     school 1803630 235   Fort Wayne Community Schools 180363000517 149 Bloomingdale Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten                         20.0 16.0                       36.0                         20 16                 36
1919228 IN     school 1803630 235   Fort Wayne Community Schools 180363000517 149 Bloomingdale Elementary School   Regular School No Elementary PK 05 2021   pre_kindergarten                         10.0 14.0                       24.0                         10 14                 24
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
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
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
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
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
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
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
1163205 IN     school 1800660 3405   Blue River Valley Schools 180066000140 2803 Blue River Valley Elem School   Regular School No 1.0 PK 06 2015   pre_kindergarten                         14.0 9.0                       23.0                         14 9                 23
1284612 IN     school 1800660 3405   Blue River Valley Schools 180066000140 2803 Blue River Valley Elem School   Regular School No 1.0 PK 06 2016   pre_kindergarten                         15.0 16.0                       31.0                         15 16                 31
1296648 IN     school 1800660 3405   Blue River Valley Schools 180066000140 2803 Blue River Valley Elementary Sch   Regular School No Elementary PK 06 2017   pre_kindergarten                         24.0 13.0                       37.0                         24 13                 37
1755263 IN     school 1800660 3405   Blue River Valley Schools 180066000140 2803 Blue River Valley Elementary Sch   Regular School No Elementary PK 06 2019   pre_kindergarten                         25.0 12.0                       37.0                         25 12                 37
1791001 IN     school 1800660 3405   Blue River Valley Schools 180066000140 2803 Blue River Valley Elementary Sch   Regular School No Elementary PK 06 2018   pre_kindergarten                         10.0 7.0                       17.0                         10 7                 17
1910710 IN     school 1800660 3405   Blue River Valley Schools 180066000140 2803 Blue River Valley Elementary Sch   Regular School No Elementary PK 06 2020   pre_kindergarten                         22.0 23.0                       45.0                         22 23                 45
1922669 IN     school 1800660 3405   Blue River Valley Schools 180066000140 2803 Blue River Valley Elementary Sch   Regular School No Elementary PK 06 2021   pre_kindergarten                         15.0 15.0                       30.0                         15 15                 30
1755466 IN     school 1805370 3500   Kokomo School Corporation 180537000942 2945 Bon Air Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         20.0 19.0                       39.0                         20 19                 39
1910912 IN     school 1805370 3500   Kokomo School Corporation 180537000942 2945 Bon Air Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten                         12.0 14.0                       26.0                         12 14                 26
1922871 IN     school 1805370 3500   Kokomo School Corporation 180537000942 2945 Bon Air Elementary School   Regular School No Elementary PK 05 2021   pre_kindergarten                         4.0 12.0                       16.0                         4 12                 16
1160309 IN     school 1802830 630   Zionsville Community Schools 180283002481 544 Boone Meadow   Regular School No 1.0 PK 04 2015   pre_kindergarten                         62.0 31.0                       93.0                         62 31                 93
1281706 IN     school 1802830 630   Zionsville Community Schools 180283002481 544 Boone Meadow   Regular School No 1.0 PK 04 2016   pre_kindergarten                         21.0 16.0                       37.0                         21 16                 37
1293761 IN     school 1802830 630   Zionsville Community Schools 180283002481 544 Boone Meadow   Regular School No Elementary PK 04 2017   pre_kindergarten                         16.0 23.0                       39.0                         16 23                 39
1752382 IN     school 1802830 630   Zionsville Community Schools 180283002481 544 Boone Meadow   Regular School No Elementary PK 04 2019   pre_kindergarten                         19.0 18.0                       37.0                         19 18                 37
1788129 IN     school 1802830 630   Zionsville Community Schools 180283002481 544 Boone Meadow   Regular School No Elementary PK 04 2018   pre_kindergarten                         15.0 25.0                       40.0                         15 25                 40
1907819 IN     school 1802830 630   Zionsville Community Schools 180283002481 544 Boone Meadow   Regular School No Elementary PK 04 2020   pre_kindergarten                         10.0 10.0                       20.0                         10 10                 20
1293644 IN     school 1800480 395   Benton Community School Corp 180048000098 433 Boswell Elementary School   Regular School No Elementary PK 06 2017   pre_kindergarten                         13.0 7.0                       20.0                         13 7                 20
1752265 IN     school 1800480 395   Benton Community School Corp 180048000098 433 Boswell Elementary School   Regular School No Elementary PK 06 2019   pre_kindergarten                         16.0 4.0                       20.0                         16 4                 20
1788011 IN     school 1800480 395   Benton Community School Corp 180048000098 433 Boswell Elementary School   Regular School No Elementary PK 06 2018   pre_kindergarten                         9.0 5.0                       14.0                         9 5                 14
1907703 IN     school 1800480 395   Benton Community School Corp 180048000098 433 Boswell Elementary School   Regular School No Elementary PK 06 2020   pre_kindergarten                         8.0 8.0                       16.0                         8 8                 16
1919670 IN     school 1800480 395   Benton Community School Corp 180048000098 433 Boswell Elementary School   Regular School No Elementary PK 06 2021   pre_kindergarten                         10.0 7.0                       17.0                         10 7                 17
1163415 IN     school 1805370 3500   Kokomo School Corporation 180537000943 2947 Boulevard Elementary School   Regular School No 1.0 PK 05 2015   pre_kindergarten                         15.0 24.0                       39.0                         15 24                 39
1284820 IN     school 1805370 3500   Kokomo School Corporation 180537000943 2947 Boulevard Elementary School   Regular School No 1.0 PK 05 2016   pre_kindergarten                         15.0 18.0                       33.0                         15 18                 33
1296855 IN     school 1805370 3500   Kokomo School Corporation 180537000943 2947 Boulevard Elementary School   Regular School No Elementary PK 05 2017   pre_kindergarten                         17.0 24.0                       41.0                         17 24                 41
1755474 IN     school 1805370 3500   Kokomo School Corporation 180537000943 2947 Boulevard Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         27.0 29.0                       56.0                         27 29                 56
1791212 IN     school 1805370 3500   Kokomo School Corporation 180537000943 2947 Boulevard Elementary School   Regular School No Elementary PK 05 2018   pre_kindergarten                         23.0 29.0                       52.0                         23 29                 52
1910920 IN     school 1805370 3500   Kokomo School Corporation 180537000943 2947 Boulevard Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten                         24.0 27.0                       51.0                         24 27                 51
1922879 IN     school 1805370 3500   Kokomo School Corporation 180537000943 2947 Boulevard Elementary School   Regular School No Elementary PK 05 2021   pre_kindergarten                         18.0 17.0                       35.0                         18 17                 35
1762297 IN     school 1809810 8205   Salem Community Schools 180981000357 8864 Bradie Shrum Elementary   Regular School No Elementary PK 05 2019   pre_kindergarten                         12.0 1.0                       13.0                         12 1                 13
1917717 IN     school 1809810 8205   Salem Community Schools 180981000357 8864 Bradie Shrum Elementary   Regular School No Elementary PK 05 2020   pre_kindergarten                         7.0 4.0                       11.0                         7 4                 11
1929645 IN     school 1809810 8205   Salem Community Schools 180981000357 8864 Bradie Shrum Elementary   Regular School No Elementary PK 05 2021   pre_kindergarten                         8.0 5.0                       13.0                         8 5                 13
1159755 IN     school 1803630 235   Fort Wayne Community Schools 180363000518 153 Brentwood Elementary School   Regular School No 1.0 PK 05 2015   pre_kindergarten                         9.0 9.0                       18.0                         9 9                 18
1281147 IN     school 1803630 235   Fort Wayne Community Schools 180363000518 153 Brentwood Elementary School   Regular School No 1.0 PK 05 2016   pre_kindergarten                         9.0 7.0                       16.0                         9 7                 16

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