enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • kindergarten · 7,128 ✖
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
1162273 1162273 IN     school 1806390 2865   Marion Community Schools 180639001107 2369 Allen Elementary School   Regular School No 1.0 KG 04 2015   kindergarten                         42.0 36.0                       78.0                         42 36                 78
1283683 1283683 IN     school 1806390 2865   Marion Community Schools 180639001107 2369 Allen Elementary School   Regular School No 1.0 KG 04 2016   kindergarten                         45.0 22.0                       67.0                         45 22                 67
1295727 1295727 IN     school 1806390 2865   Marion Community Schools 180639001107 2369 Allen Elementary School   Regular School No Elementary KG 04 2017   kindergarten                         28.0 29.0                       57.0                         28 29                 57
1754334 1754334 IN     school 1806390 2865   Marion Community Schools 180639001107 2369 Allen Elementary School   Regular School No Elementary KG 04 2019   kindergarten                         23.0 38.0                       61.0                         23 38                 61
1790069 1790069 IN     school 1806390 2865   Marion Community Schools 180639001107 2369 Allen Elementary School   Regular School No Elementary KG 04 2018   kindergarten                         31.0 32.0                       63.0                         31 32                 63
1909761 1909761 IN     school 1806390 2865   Marion Community Schools 180639001107 2369 Allen Elementary School   Regular School No Elementary PK 04 2020   kindergarten                         38.0 24.0                       62.0                         38 24                 62
1921717 1921717 IN     school 1806390 2865   Marion Community Schools 180639001107 2369 Allen Elementary School   Regular School No Elementary PK 04 2021   kindergarten                         33.0 28.0                       61.0                         33 28                 61
1165035 1165035 IN     school 1804560 4720   School Town of Highland 180456000762 4303 Allen J Warren Elem Sch   Regular School No 1.0 KG 05 2015   kindergarten                         25.0 25.0                       50.0                         25 25                 50
1286430 1286430 IN     school 1804560 4720   School Town of Highland 180456000762 4303 Allen J Warren Elem Sch   Regular School No 1.0 KG 05 2016   kindergarten                         32.0 20.0                       52.0                         32 20                 52
1298469 1298469 IN     school 1804560 4720   School Town of Highland 180456000762 4303 Allen J Warren Elementary School   Regular School No Elementary KG 05 2017   kindergarten                         32.0 15.0                       47.0                         32 15                 47
1756998 1756998 IN     school 1804560 4720   School Town of Highland 180456000762 4303 Allen J Warren Elementary School   Regular School No Elementary KG 05 2019   kindergarten                         17.0 26.0                       43.0                         17 26                 43
1792790 1792790 IN     school 1804560 4720   School Town of Highland 180456000762 4303 Allen J Warren Elementary School   Regular School No Elementary KG 05 2018   kindergarten                         27.0 26.0                       53.0                         27 26                 53
1912434 1912434 IN     school 1804560 4720   School Town of Highland 180456000762 4303 Allen J Warren Elementary School   Regular School No Elementary KG 05 2020   kindergarten                         18.0 27.0                       45.0                         18 27                 45
1924383 1924383 IN     school 1804560 4720   School Town of Highland 180456000762 4303 Allen J Warren Elementary School   Regular School No Elementary KG 05 2021   kindergarten                         28.0 18.0                       46.0                         28 18                 46
1913481 1913481 IN     school 1812720 5370   M S D Washington Township 181272002010 5403 Allisonville Elementary School   Regular School No Elementary KG 05 2020   kindergarten                         54.0 51.0                       105.0                         54 51                 105
1925392 1925392 IN     school 1812720 5370   MSD Washington Township 181272002010 5403 Allisonville Elementary School   Regular School No Elementary KG 05 2021   kindergarten                         43.0 57.0                       100.0                         43 57                 100
1169461 1169461 IN     school 1805400 7855   Lafayette School Corporation 180540000545 8119 Amelia Earhart Elem Sch   Regular School No 1.0 KG 04 2015   kindergarten                         49.0 59.0                       108.0                         49 59                 108
1290852 1290852 IN     school 1805400 7855   Lafayette School Corporation 180540000545 8119 Amelia Earhart Elem Sch   Regular School No 1.0 KG 04 2016   kindergarten                         33.0 44.0                       77.0                         33 44                 77
1302880 1302880 IN     school 1805400 7855   Lafayette School Corporation 180540000545 8119 Amelia Earhart Elementary School   Regular School No Elementary KG 04 2017   kindergarten                         51.0 31.0                       82.0                         51 31                 82
1761380 1761380 IN     school 1805400 7855   Lafayette School Corporation 180540000545 8119 Amelia Earhart Elementary School   Regular School No Elementary KG 04 2019   kindergarten                         47.0 41.0                       88.0                         47 41                 88
1797196 1797196 IN     school 1805400 7855   Lafayette School Corporation 180540000545 8119 Amelia Earhart Elementary School   Regular School No Elementary KG 04 2018   kindergarten                         51.0 54.0                       105.0                         51 54                 105
1916787 1916787 IN     school 1805400 7855   Lafayette School Corporation 180540000545 8119 Amelia Earhart Elementary School   Regular School No Elementary KG 04 2020   kindergarten                         41.0 50.0                       91.0                         41 50                 91
1928718 1928718 IN     school 1805400 7855   Lafayette School Corporation 180540000545 8119 Amelia Earhart Elementary School   Regular School No Elementary KG 04 2021   kindergarten                         51.0 40.0                       91.0                         51 40                 91
1165582 1165582 IN     school 1800150 5275   Anderson Community School Corp 180015001847 5142 Anderson Elementary School   Regular School No 1.0 KG 05 2015   kindergarten                         46.0 55.0                       101.0                         46 55                 101
1286977 1286977 IN     school 1800150 5275   Anderson Community School Corp 180015001847 5142 Anderson Elementary School   Regular School No 1.0 KG 05 2016   kindergarten                         47.0 44.0                       91.0                         47 44                 91
1299012 1299012 IN     school 1800150 5275   Anderson Community School Corp 180015001847 5142 Anderson Elementary School   Regular School No Elementary KG 05 2017   kindergarten                         48.0 52.0                       100.0                         48 52                 100
1757549 1757549 IN     school 1800150 5275   Anderson Community School Corp 180015001847 5142 Anderson Elementary School   Regular School No Elementary KG 05 2019   kindergarten                         39.0 47.0                       86.0                         39 47                 86
1793339 1793339 IN     school 1800150 5275   Anderson Community School Corp 180015001847 5142 Anderson Elementary School   Regular School No Elementary KG 05 2018   kindergarten                         60.0 46.0                       106.0                         60 46                 106
1911248 1911248 IN     school 1806120 3995   Madison Consolidated Schools 180612001088 3333 Anderson Elementary School   Regular School No Elementary PK 04 2020   kindergarten                         56.0 27.0                       83.0                         56 27                 83
1912968 1912968 IN     school 1800150 5275   Anderson Community School Corp 180015001847 5142 Anderson Elementary School   Regular School No Elementary KG 04 2020   kindergarten                         54.0 33.0                       87.0                         54 33                 87
1923205 1923205 IN     school 1806120 3995   Madison Consolidated Schools 180612001088 3333 Anderson Elementary School   Regular School No Elementary PK 04 2021   kindergarten                         43.0 33.0                       76.0                         43 33                 76
1924893 1924893 IN     school 1800150 5275   Anderson Community School Corp 180015001847 5142 Anderson Elementary School   Regular School No Elementary KG 04 2021   kindergarten                         32.0 31.0                       63.0                         32 31                 63
1171309 1171309 IN     school 1800077 9790   Anderson Preparatory Academy 180007702425 5092 Anderson Preparatory Academy   Regular School Yes 4.0 KG 12 2015   kindergarten                         33.0 24.0                       57.0                         33 24                 57
1292669 1292669 IN     school 1800077 9790   Anderson Preparatory Academy 180007702425 5092 Anderson Preparatory Academy   Regular School Yes 4.0 KG 12 2016   kindergarten                         29.0 28.0                       57.0                         29 28                 57
1304709 1304709 IN     school 1800077 9790   Anderson Preparatory Academy 180007702425 5092 Anderson Preparatory Academy   Regular School Yes Other KG 12 2017   kindergarten                         34.0 33.0                       67.0                         34 33                 67
1763291 1763291 IN     school 1800077 9790   Anderson Preparatory Academy 180007702425 5092 Anderson Preparatory Academy   Regular School Yes Other KG 12 2019   kindergarten                         30.0 18.0                       48.0                         30 18                 48
1799036 1799036 IN     school 1800077 9790   Anderson Preparatory Academy 180007702425 5092 Anderson Preparatory Academy   Regular School Yes Other KG 12 2018   kindergarten                         30.0 20.0                       50.0                         30 20                 50
1918738 1918738 IN     school 1800077 9790   Anderson Preparatory Academy 180007702425 5092 Anderson Preparatory Academy   Regular School Yes Other KG 12 2020   kindergarten                         28.0 23.0                       51.0                         28 23                 51
1930726 1930726 IN     school 1800077 9790   Anderson Preparatory Academy 180007702425 5092 Anderson Preparatory Academy   Regular School Yes Other KG 12 2021   kindergarten                         31.0 22.0                       53.0                         31 22                 53
1171195 1171195 IN     school 1800092 9715   Andrew Academy 180009202493 5785 Andrew Academy   Regular School Yes 1.0 KG 08 2015   kindergarten                         15.0 11.0                       26.0                         15 11                 26
1171090 1171090 IN     school 1800042 9615   Andrew J Brown Academy 180004201816 5488 Andrew J Brown Academy   Regular School Yes 1.0 KG 08 2015   kindergarten                         45.0 56.0                       101.0                         45 56                 101
1292467 1292467 IN     school 1800042 9615   Andrew J Brown Academy 180004201816 5488 Andrew J Brown Academy   Regular School Yes 1.0 KG 08 2016   kindergarten                         41.0 35.0                       76.0                         41 35                 76
1304500 1304500 IN     school 1800042 9615   Andrew J Brown Academy 180004201816 5488 Andrew J Brown Academy   Regular School Yes Elementary KG 08 2017   kindergarten                         51.0 31.0                       82.0                         51 31                 82
1763112 1763112 IN     school 1800042 9615   Andrew J Brown Academy 180004201816 5488 Andrew J Brown Academy   Regular School Yes Elementary KG 08 2019   kindergarten                         55.0 36.0                       91.0                         55 36                 91
1798842 1798842 IN     school 1800042 9615   Andrew J Brown Academy 180004201816 5488 Andrew J Brown Academy   Regular School Yes Elementary KG 08 2018   kindergarten                         40.0 40.0                       80.0                         40 40                 80
1918581 1918581 IN     school 1800042 9615   Andrew J Brown Academy 180004201816 5488 Andrew J Brown Academy   Regular School Yes Elementary KG 08 2020   kindergarten                         51.0 40.0                       91.0                         51 40                 91
1930577 1930577 IN     school 1800042 9615   Andrew J Brown Academy 180004201816 5488 Andrew J Brown Academy   Regular School Yes Elementary KG 08 2021   kindergarten                         46.0 45.0                       91.0                         46 45                 91
1163470 1163470 IN     school 1804710 3625   Huntington Co Com Sch Corp 180471000782 3021 Andrews Elementary School   Regular School No 1.0 KG 05 2015   kindergarten                         35.0 30.0                       65.0                         35 30                 65
1284875 1284875 IN     school 1804710 3625   Huntington Co Com Sch Corp 180471000782 3021 Andrews Elementary School   Regular School No 1.0 KG 05 2016   kindergarten                         40.0 27.0                       67.0                         40 27                 67
1296910 1296910 IN     school 1804710 3625   Huntington Co Com Sch Corp 180471000782 3021 Andrews Elementary School   Regular School No Elementary KG 05 2017   kindergarten                         26.0 36.0                       62.0                         26 36                 62
1755529 1755529 IN     school 1804710 3625   Huntington Co Com Sch Corp 180471000782 3021 Andrews Elementary School   Regular School No Elementary KG 05 2019   kindergarten                         23.0 26.0                       49.0                         23 26                 49
1791267 1791267 IN     school 1804710 3625   Huntington Co Com Sch Corp 180471000782 3021 Andrews Elementary School   Regular School No Elementary KG 05 2018   kindergarten                         32.0 31.0                       63.0                         32 31                 63
1910975 1910975 IN     school 1804710 3625   Huntington Co Com Sch Corp 180471000782 3021 Andrews Elementary School   Regular School No Elementary KG 05 2020   kindergarten                         21.0 37.0                       58.0                         21 37                 58
1922934 1922934 IN     school 1804710 3625   Huntington Co Com Sch Corp 180471000782 3021 Andrews Elementary School   Regular School No Elementary KG 05 2021   kindergarten                         27.0 22.0                       49.0                         27 22                 49
1166631 1166631 IN     school 1804770 5385   Indianapolis Public Schools 180477000797 5588 Anna Brochhausen School 88   Regular School No 1.0 PK 06 2015   kindergarten                         24.0 23.0                       47.0                         24 23                 47
1288042 1288042 IN     school 1804770 5385   Indianapolis Public Schools 180477000797 5588 Anna Brochhausen School 88   Regular School No 1.0 PK 06 2016   kindergarten                         20.0 23.0                       43.0                         20 23                 43
1300070 1300070 IN     school 1804770 5385   Indianapolis Public Schools 180477000797 5588 Anna Brochhausen School 88   Regular School No Elementary PK 06 2017   kindergarten                         19.0 23.0                       42.0                         19 23                 42
1758571 1758571 IN     school 1804770 5385   Indianapolis Public Schools 180477000797 5588 Anna Brochhausen School 88   Regular School No Elementary PK 06 2019   kindergarten                         20.0 17.0                       37.0                         20 17                 37
1794384 1794384 IN     school 1804770 5385   Indianapolis Public Schools 180477000797 5588 Anna Brochhausen School 88   Regular School No Elementary PK 06 2018   kindergarten                         23.0 31.0                       54.0                         23 31                 54
1913998 1913998 IN     school 1804770 5385   Indianapolis Public Schools 180477000797 5588 Anna Brochhausen School 88   Regular School No Elementary PK 06 2020   kindergarten                         22.0 28.0                       50.0                         22 28                 50
1925894 1925894 IN     school 1804770 5385   Indianapolis Public Schools 180477000797 5588 Anna Brochhausen School 88   Regular School No Elementary PK 06 2021   kindergarten                         14.0 7.0                       21.0                         14 7                 21
1159576 1159576 IN     school 1808250 225   Northwest Allen County Schools 180825001413 69 Arcola School   Regular School No 1.0 KG 05 2015   kindergarten                         19.0 11.0                       30.0                         19 11                 30
1280966 1280966 IN     school 1808250 225   Northwest Allen County Schools 180825001413 69 Arcola School   Regular School No 1.0 KG 05 2016   kindergarten                         17.0 19.0                       36.0                         17 19                 36
1293028 1293028 IN     school 1808250 225   Northwest Allen County Schools 180825001413 69 Arcola School   Regular School No Elementary KG 05 2017   kindergarten                         14.0 10.0                       24.0                         14 10                 24
1751660 1751660 IN     school 1808250 225   Northwest Allen County Schools 180825001413 69 Arcola School   Regular School No Elementary KG 05 2019   kindergarten                         17.0 21.0                       38.0                         17 21                 38
1787401 1787401 IN     school 1808250 225   Northwest Allen County Schools 180825001413 69 Arcola School   Regular School No Elementary KG 05 2018   kindergarten                         14.0 13.0                       27.0                         14 13                 27
1907101 1907101 IN     school 1808250 225   Northwest Allen County Schools 180825001413 69 Arcola School   Regular School No Elementary KG 05 2020   kindergarten                         19.0 10.0                       29.0                         19 10                 29
1919067 1919067 IN     school 1808250 225   Northwest Allen County Schools 180825001413 69 Arcola School   Regular School No Elementary KG 05 2021   kindergarten                         19.0 22.0                       41.0                         19 22                 41
1166887 1166887 IN     school 1800180 5470   Argos Community Schools 180018000047 5936 Argos Community Elementary   Regular School No 1.0 KG 06 2015   kindergarten                         26.0 32.0                       58.0                         26 32                 58
1288286 1288286 IN     school 1800180 5470   Argos Community Schools 180018000047 5936 Argos Community Elementary   Regular School No 1.0 PK 06 2016   kindergarten                         25.0 17.0                       42.0                         25 17                 42
1300309 1300309 IN     school 1800180 5470   Argos Community Schools 180018000047 5936 Argos Community Elementary   Regular School No Elementary PK 06 2017   kindergarten                         19.0 17.0                       36.0                         19 17                 36
1758813 1758813 IN     school 1800180 5470   Argos Community Schools 180018000047 5936 Argos Community Elementary   Regular School No Elementary PK 06 2019   kindergarten                         19.0 26.0                       45.0                         19 26                 45
1794626 1794626 IN     school 1800180 5470   Argos Community Schools 180018000047 5936 Argos Community Elementary   Regular School No Elementary PK 06 2018   kindergarten                         25.0 24.0                       49.0                         25 24                 49
1914230 1914230 IN     school 1800180 5470   Argos Community Schools 180018000047 5936 Argos Community Elementary   Regular School No Elementary PK 05 2020   kindergarten                         23.0 19.0                       42.0                         23 19                 42
1926112 1926112 IN     school 1800180 5470   Argos Community Schools 180018000047 5936 Argos Community Elementary   Regular School No Elementary PK 05 2021   kindergarten                         23.0 24.0                       47.0                         23 24                 47
1159962 1159962 IN     school 1803630 235   Fort Wayne Community Schools 180363000514 275 Arlington Elementary School   Regular School No 1.0 KG 05 2015   kindergarten                         35.0 40.0                       75.0                         35 40                 75
1165700 1165700 IN     school 1803750 5310   Franklin Township Com Sch Corp 180375002222 5202 Arlington Elementary School   Regular School No 1.0 KG 05 2015   kindergarten                         50.0 48.0                       98.0                         50 48                 98
1168518 1168518 IN     school 1809750 6995   Rush County Schools 180975001591 7253 Arlington Elementary School   Regular School No 1.0 KG 06 2015   kindergarten                         14.0 18.0                       32.0                         14 18                 32
1281354 1281354 IN     school 1803630 235   Fort Wayne Community Schools 180363000514 275 Arlington Elementary School   Regular School No 1.0 KG 05 2016   kindergarten                         33.0 34.0                       67.0                         33 34                 67
1287098 1287098 IN     school 1803750 5310   Franklin Township Com Sch Corp 180375002222 5202 Arlington Elementary School   Regular School No 1.0 KG 05 2016   kindergarten                         56.0 25.0                       81.0                         56 25                 81
1289905 1289905 IN     school 1809750 6995   Rush County Schools 180975001591 7253 Arlington Elementary School   Regular School No 1.0 KG 06 2016   kindergarten                         11.0 7.0                       18.0                         11 7                 18
1293408 1293408 IN     school 1803630 235   Fort Wayne Community Schools 180363000514 275 Arlington Elementary School   Regular School No Elementary KG 05 2017   kindergarten                         49.0 36.0                       85.0                         49 36                 85
1299137 1299137 IN     school 1803750 5310   Franklin Township Com Sch Corp 180375002222 5202 Arlington Elementary School   Regular School No Elementary KG 05 2017   kindergarten                         52.0 43.0                       95.0                         52 43                 95
1301929 1301929 IN     school 1809750 6995   Rush County Schools 180975001591 7253 Arlington Elementary School   Regular School No Elementary KG 06 2017   kindergarten                         16.0 13.0                       29.0                         16 13                 29
1752032 1752032 IN     school 1803630 235   Fort Wayne Community Schools 180363000514 275 Arlington Elementary School   Regular School No Elementary KG 05 2019   kindergarten                         33.0 29.0                       62.0                         33 29                 62
1757675 1757675 IN     school 1803750 5310   Franklin Township Com Sch Corp 180375002222 5202 Arlington Elementary School   Regular School No Elementary KG 05 2019   kindergarten                         51.0 46.0                       97.0                         51 46                 97
1760439 1760439 IN     school 1809750 6995   Rush County Schools 180975001591 7253 Arlington Elementary School   Regular School No Elementary KG 06 2019   kindergarten                         8.0 12.0                       20.0                         8 12                 20
1787777 1787777 IN     school 1803630 235   Fort Wayne Community Schools 180363000514 275 Arlington Elementary School   Regular School No Elementary KG 05 2018   kindergarten                         40.0 32.0                       72.0                         40 32                 72
1793465 1793465 IN     school 1803750 5310   Franklin Township Com Sch Corp 180375002222 5202 Arlington Elementary School   Regular School No Elementary KG 05 2018   kindergarten                         37.0 48.0                       85.0                         37 48                 85
1796247 1796247 IN     school 1809750 6995   Rush County Schools 180975001591 7253 Arlington Elementary School   Regular School No Elementary KG 06 2018   kindergarten                         15.0 11.0                       26.0                         15 11                 26
1907472 1907472 IN     school 1803630 235   Fort Wayne Community Schools 180363000514 275 Arlington Elementary School   Regular School No Elementary KG 05 2020   kindergarten                         33.0 30.0                       63.0                         33 30                 63
1913092 1913092 IN     school 1803750 5310   Franklin Township Com Sch Corp 180375002222 5202 Arlington Elementary School   Regular School No Elementary KG 05 2020   kindergarten                         58.0 53.0                       111.0                         58 53                 111
1915850 1915850 IN     school 1809750 6995   Rush County Schools 180975001591 7253 Arlington Elementary School   Regular School No Elementary KG 06 2020   kindergarten                         11.0 12.0                       23.0                         11 12                 23
1919438 1919438 IN     school 1803630 235   Fort Wayne Community Schools 180363000514 275 Arlington Elementary School   Regular School No Elementary KG 05 2021   kindergarten                         36.0 23.0                       59.0                         36 23                 59
1925002 1925002 IN     school 1803750 5310   Franklin Township Com Sch Corp 180375002222 5202 Arlington Elementary School   Regular School No Elementary KG 03 2021   kindergarten                         79.0 67.0                       146.0                         79 67                 146
1927775 1927775 IN     school 1809750 6995   Rush County Schools 180975001591 7253 Arlington Elementary School   Regular School No Elementary KG 06 2021   kindergarten                         7.0 10.0                       17.0                         7 10                 17
1167180 1167180 IN     school 1800630 5740   Monroe County Com Sch Corp 180063000117 6181 Arlington Heights Elem Sch   Regular School No 1.0 KG 06 2015   kindergarten                         30.0 24.0                       54.0                         30 24                 54
1288578 1288578 IN     school 1800630 5740   Monroe County Com Sch Corp 180063000117 6181 Arlington Heights Elementary Sch   Regular School No 1.0 PK 06 2016   kindergarten                         28.0 29.0                       57.0                         28 29                 57
1300606 1300606 IN     school 1800630 5740   Monroe County Community Sch Corp 180063000117 6181 Arlington Heights Elementary Sch   Regular School No Elementary PK 06 2017   kindergarten                         28.0 22.0                       50.0                         28 22                 50
1759105 1759105 IN     school 1800630 5740   Monroe County Community Sch Corp 180063000117 6181 Arlington Heights Elementary Sch   Regular School No Elementary PK 06 2019   kindergarten                         19.0 17.0                       36.0                         19 17                 36

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