enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • kindergarten · 7,228 ✖
Link rowid state county county_state_id admin_level district_nces_id district_state_id ▼ district_state_type district school_nces_id school_state_id school school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ccd_school_high_grade year term grade white black hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
1160550 1160550 IN     school 1801920 1000   Clarksville Com School Corp 180192000251 845 Clarksville Elementary School   Regular School No 1.0 PK 04 2015   kindergarten                         49.0 52.0                       101.0                         49 52                 101
1281945 1281945 IN     school 1801920 1000   Clarksville Com School Corp 180192000251 845 Clarksville Elementary School   Regular School No 1.0 PK 04 2016   kindergarten                         54.0 61.0                       115.0                         54 61                 115
1294003 1294003 IN     school 1801920 1000   Clarksville Community School Corp 180192000251 845 Clarksville Elementary School   Regular School No Elementary PK 04 2017   kindergarten                         47.0 50.0                       97.0                         47 50                 97
1752630 1752630 IN     school 1801920 1000   Clarksville Community School Corp 180192000251 845 Clarksville Elementary School   Regular School No Elementary PK 04 2019   kindergarten                         52.0 57.0                       109.0                         52 57                 109
1788369 1788369 IN     school 1801920 1000   Clarksville Community School Corp 180192000251 845 Clarksville Elementary School   Regular School No Elementary PK 04 2018   kindergarten                         53.0 49.0                       102.0                         53 49                 102
1908069 1908069 IN     school 1801920 1000   Clarksville Community School Corp 180192000251 845 Clarksville Elementary School   Regular School No Elementary PK 04 2020   kindergarten                         57.0 51.0                       108.0                         57 51                 108
1920034 1920034 IN     school 1801920 1000   Clarksville Community School Corp 180192000251 845 Clarksville Elementary School   Regular School No Elementary PK 04 2021   kindergarten                         57.0 53.0                       110.0                         57 53                 110
1920054 1920054 IN     school 1801920 1000   Clarksville Community School Corp 180192002690 1007 Indiana Gateway Digital Academy   Regular School No Other KG 12 2021   kindergarten                         106.0 109.0                       215.0                         106 109                 215
1160563 1160563 IN     school 1803940 1010   Greater Clark County Schools 180394000682 755 W E Wilson Elementary   Regular School No 1.0 PK 05 2015   kindergarten                         61.0 45.0                       106.0                         61 45                 106
1160571 1160571 IN     school 1803940 1010   Greater Clark County Schools 180394000680 761 Thomas Jefferson Elem Sch   Regular School No 1.0 KG 05 2015   kindergarten                         34.0 25.0                       59.0                         34 25                 59
1160578 1160578 IN     school 1803940 1010   Greater Clark County Schools 180394000673 801 Northaven Elementary School   Regular School No 1.0 KG 05 2015   kindergarten                         43.0 40.0                       83.0                         43 40                 83
1160585 1160585 IN     school 1803940 1010   Greater Clark County Schools 180394000681 805 Utica Elementary School   Regular School No 1.0 KG 05 2015   kindergarten                         48.0 50.0                       98.0                         48 50                 98
1160592 1160592 IN     school 1803940 1010   Greater Clark County Schools 180394000671 807 New Washington Elem School   Regular School No 1.0 PK 05 2015   kindergarten                         23.0 30.0                       53.0                         23 30                 53
1160613 1160613 IN     school 1803940 1010   Greater Clark County Schools 180394000667 825 Jonathan Jennings Elem Sch   Regular School No 1.0 KG 05 2015   kindergarten                         40.0 40.0                       80.0                         40 40                 80
1160620 1160620 IN     school 1803940 1010   Greater Clark County Schools 180394000676 829 Pleasant Ridge Elem School   Regular School No 1.0 KG 05 2015   kindergarten                         30.0 29.0                       59.0                         30 29                 59
1160640 1160640 IN     school 1803940 1010   Greater Clark County Schools 180394000665 865 Bridgepoint Elementary School   Regular School No 1.0 PK 05 2015   kindergarten                         39.0 26.0                       65.0                         39 26                 65
1160648 1160648 IN     school 1803940 1010   Greater Clark County Schools 180394000668 869 Maple Elementary School   Regular School No 1.0 KG 05 2015   kindergarten                         33.0 19.0                       52.0                         33 19                 52
1160655 1160655 IN     school 1803940 1010   Greater Clark County Schools 180394000677 871 Riverside Elementary School   Regular School No 1.0 PK 05 2015   kindergarten                         47.0 35.0                       82.0                         47 35                 82
1160663 1160663 IN     school 1803940 1010   Greater Clark County Schools 180394000679 877 Spring Hill Elementary School   Regular School No 1.0 PK 05 2015   kindergarten                         20.0 18.0                       38.0                         20 18                 38
1160671 1160671 IN     school 1803940 1010   Greater Clark County Schools 180394000675 879 Parkwood Elementary School   Regular School No 1.0 KG 05 2015   kindergarten                         53.0 50.0                       103.0                         53 50                 103
1281958 1281958 IN     school 1803940 1010   Greater Clark County Schools 180394000682 755 W E Wilson Elementary   Regular School No 1.0 PK 05 2016   kindergarten                         43.0 37.0                       80.0                         43 37                 80
1281966 1281966 IN     school 1803940 1010   Greater Clark County Schools 180394000680 761 Thomas Jefferson Elementary School   Regular School No 1.0 PK 05 2016   kindergarten                         25.0 21.0                       46.0                         25 21                 46
1281974 1281974 IN     school 1803940 1010   Greater Clark County Schools 180394000673 801 Northaven Elementary School   Regular School No 1.0 PK 05 2016   kindergarten                         35.0 44.0                       79.0                         35 44                 79
1281982 1281982 IN     school 1803940 1010   Greater Clark County Schools 180394000681 805 Utica Elementary School   Regular School No 1.0 PK 05 2016   kindergarten                         43.0 33.0                       76.0                         43 33                 76
1281990 1281990 IN     school 1803940 1010   Greater Clark County Schools 180394000671 807 New Washington Elementary School   Regular School No 1.0 PK 05 2016   kindergarten                         27.0 24.0                       51.0                         27 24                 51
1282011 1282011 IN     school 1803940 1010   Greater Clark County Schools 180394000667 825 Jonathan Jennings Elementary Sch   Regular School No 1.0 PK 05 2016   kindergarten                         37.0 33.0                       70.0                         37 33                 70
1282019 1282019 IN     school 1803940 1010   Greater Clark County Schools 180394000676 829 Pleasant Ridge Elementary School   Regular School No 1.0 PK 05 2016   kindergarten                         30.0 38.0                       68.0                         30 38                 68
1282040 1282040 IN     school 1803940 1010   Greater Clark County Schools 180394000665 865 Bridgepoint Elementary School   Regular School No 1.0 PK 05 2016   kindergarten                         31.0 24.0                       55.0                         31 24                 55
1282048 1282048 IN     school 1803940 1010   Greater Clark County Schools 180394000668 869 Maple Elementary School   Regular School No 1.0 PK 05 2016   kindergarten                         18.0 18.0                       36.0                         18 18                 36
1282056 1282056 IN     school 1803940 1010   Greater Clark County Schools 180394000677 871 Riverside Elementary School   Regular School No 1.0 PK 05 2016   kindergarten                         38.0 38.0                       76.0                         38 38                 76
1282064 1282064 IN     school 1803940 1010   Greater Clark County Schools 180394000679 877 Spring Hill Elementary School   Regular School No 1.0 PK 05 2016   kindergarten                         16.0 18.0                       34.0                         16 18                 34
1282072 1282072 IN     school 1803940 1010   Greater Clark County Schools 180394000675 879 Parkwood Elementary School   Regular School No 1.0 PK 05 2016   kindergarten                         51.0 44.0                       95.0                         51 44                 95
1294016 1294016 IN     school 1803940 1010   Greater Clark County Schools 180394000682 755 W E Wilson Elementary   Regular School No Elementary PK 05 2017   kindergarten                         32.0 42.0                       74.0                         32 42                 74
1294024 1294024 IN     school 1803940 1010   Greater Clark County Schools 180394000680 761 Thomas Jefferson Elementary School   Regular School No Elementary PK 05 2017   kindergarten                         31.0 24.0                       55.0                         31 24                 55
1294032 1294032 IN     school 1803940 1010   Greater Clark County Schools 180394000673 801 Northaven Elementary School   Regular School No Elementary PK 05 2017   kindergarten                         44.0 36.0                       80.0                         44 36                 80
1294040 1294040 IN     school 1803940 1010   Greater Clark County Schools 180394000681 805 Utica Elementary School   Regular School No Elementary PK 05 2017   kindergarten                         45.0 35.0                       80.0                         45 35                 80
1294048 1294048 IN     school 1803940 1010   Greater Clark County Schools 180394000671 807 New Washington Elementary School   Regular School No Elementary PK 05 2017   kindergarten                         17.0 21.0                       38.0                         17 21                 38
1294069 1294069 IN     school 1803940 1010   Greater Clark County Schools 180394000667 825 Jonathan Jennings Elementary Sch   Regular School No Elementary PK 05 2017   kindergarten                         34.0 44.0                       78.0                         34 44                 78
1294077 1294077 IN     school 1803940 1010   Greater Clark County Schools 180394000676 829 Pleasant Ridge Elementary School   Regular School No Elementary PK 05 2017   kindergarten                         58.0 33.0                       91.0                         58 33                 91
1294098 1294098 IN     school 1803940 1010   Greater Clark County Schools 180394000665 865 Bridgepoint Elementary School   Regular School No Elementary PK 05 2017   kindergarten                         34.0 25.0                       59.0                         34 25                 59
1294106 1294106 IN     school 1803940 1010   Greater Clark County Schools 180394000668 869 Maple Elementary School   Regular School No Elementary PK 05 2017   kindergarten                         23.0 19.0                       42.0                         23 19                 42
1294114 1294114 IN     school 1803940 1010   Greater Clark County Schools 180394000677 871 Riverside Elementary School   Regular School No Elementary PK 05 2017   kindergarten                         44.0 41.0                       85.0                         44 41                 85
1294122 1294122 IN     school 1803940 1010   Greater Clark County Schools 180394000679 877 Spring Hill Elementary School   Regular School No Elementary PK 05 2017   kindergarten                         14.0 14.0                       28.0                         14 14                 28
1294130 1294130 IN     school 1803940 1010   Greater Clark County Schools 180394000675 879 Parkwood Elementary School   Regular School No Elementary PK 05 2017   kindergarten                         51.0 42.0                       93.0                         51 42                 93
1752643 1752643 IN     school 1803940 1010   Greater Clark County Schools 180394000682 755 W E Wilson Elementary   Regular School No Elementary PK 05 2019   kindergarten                         44.0 40.0                       84.0                         44 40                 84
1752651 1752651 IN     school 1803940 1010   Greater Clark County Schools 180394000680 761 Thomas Jefferson Elementary School   Regular School No Elementary PK 05 2019   kindergarten                         42.0 32.0                       74.0                         42 32                 74
1752659 1752659 IN     school 1803940 1010   Greater Clark County Schools 180394000673 801 Northaven Elementary School   Regular School No Elementary PK 05 2019   kindergarten                         49.0 37.0                       86.0                         49 37                 86
1752667 1752667 IN     school 1803940 1010   Greater Clark County Schools 180394000681 805 Utica Elementary School   Regular School No Elementary PK 05 2019   kindergarten                         46.0 42.0                       88.0                         46 42                 88
1752675 1752675 IN     school 1803940 1010   Greater Clark County Schools 180394000671 807 New Washington Elementary School   Regular School No Elementary PK 05 2019   kindergarten                         22.0 22.0                       44.0                         22 22                 44
1752697 1752697 IN     school 1803940 1010   Greater Clark County Schools 180394000676 829 Pleasant Ridge Elementary School   Regular School No Elementary PK 02 2019   kindergarten                         87.0 67.0                       154.0                         87 67                 154
1752718 1752718 IN     school 1803940 1010   Greater Clark County Schools 180394000665 865 Bridgepoint Elementary School   Regular School No Elementary PK 05 2019   kindergarten                         37.0 18.0                       55.0                         37 18                 55
1752726 1752726 IN     school 1803940 1010   Greater Clark County Schools 180394000668 869 Maple Elementary School   Regular School No Elementary KG 05 2019   kindergarten                         14.0 11.0                       25.0                         14 11                 25
1752733 1752733 IN     school 1803940 1010   Greater Clark County Schools 180394000677 871 Riverside Elementary School   Regular School No Elementary PK 05 2019   kindergarten                         43.0 40.0                       83.0                         43 40                 83
1752741 1752741 IN     school 1803940 1010   Greater Clark County Schools 180394000679 877 Spring Hill Elementary School   Regular School No Elementary PK 05 2019   kindergarten                         9.0 12.0                       21.0                         9 12                 21
1752749 1752749 IN     school 1803940 1010   Greater Clark County Schools 180394000675 879 Parkwood Elementary School   Regular School No Elementary PK 05 2019   kindergarten                         40.0 26.0                       66.0                         40 26                 66
1788382 1788382 IN     school 1803940 1010   Greater Clark County Schools 180394000682 755 W E Wilson Elementary   Regular School No Elementary PK 05 2018   kindergarten                         36.0 32.0                       68.0                         36 32                 68
1788390 1788390 IN     school 1803940 1010   Greater Clark County Schools 180394000680 761 Thomas Jefferson Elementary School   Regular School No Elementary PK 05 2018   kindergarten                         31.0 23.0                       54.0                         31 23                 54
1788398 1788398 IN     school 1803940 1010   Greater Clark County Schools 180394000673 801 Northaven Elementary School   Regular School No Elementary PK 05 2018   kindergarten                         49.0 41.0                       90.0                         49 41                 90
1788406 1788406 IN     school 1803940 1010   Greater Clark County Schools 180394000681 805 Utica Elementary School   Regular School No Elementary PK 05 2018   kindergarten                         42.0 41.0                       83.0                         42 41                 83
1788414 1788414 IN     school 1803940 1010   Greater Clark County Schools 180394000671 807 New Washington Elementary School   Regular School No Elementary PK 05 2018   kindergarten                         20.0 35.0                       55.0                         20 35                 55
1788436 1788436 IN     school 1803940 1010   Greater Clark County Schools 180394000676 829 Pleasant Ridge Elementary School   Regular School No Elementary PK 02 2018   kindergarten                         61.0 72.0                       133.0                         61 72                 133
1788457 1788457 IN     school 1803940 1010   Greater Clark County Schools 180394000665 865 Bridgepoint Elementary School   Regular School No Elementary PK 05 2018   kindergarten                         27.0 17.0                       44.0                         27 17                 44
1788465 1788465 IN     school 1803940 1010   Greater Clark County Schools 180394000668 869 Maple Elementary School   Regular School No Elementary PK 05 2018   kindergarten                         17.0 22.0                       39.0                         17 22                 39
1788473 1788473 IN     school 1803940 1010   Greater Clark County Schools 180394000677 871 Riverside Elementary School   Regular School No Elementary PK 05 2018   kindergarten                         46.0 29.0                       75.0                         46 29                 75
1788481 1788481 IN     school 1803940 1010   Greater Clark County Schools 180394000679 877 Spring Hill Elementary School   Regular School No Elementary PK 05 2018   kindergarten                         16.0 15.0                       31.0                         16 15                 31
1788489 1788489 IN     school 1803940 1010   Greater Clark County Schools 180394000675 879 Parkwood Elementary School   Regular School No Elementary PK 05 2018   kindergarten                         45.0 34.0                       79.0                         45 34                 79
1908082 1908082 IN     school 1803940 1010   Greater Clark County Schools 180394000682 755 W E Wilson Elementary   Regular School No Elementary KG 05 2020   kindergarten                         44.0 34.0                       78.0                         44 34                 78
1908089 1908089 IN     school 1803940 1010   Greater Clark County Schools 180394000680 761 Thomas Jefferson Elementary School   Regular School No Elementary KG 05 2020   kindergarten                         32.0 31.0                       63.0                         32 31                 63
1908096 1908096 IN     school 1803940 1010   Greater Clark County Schools 180394000673 801 Northaven Elementary School   Regular School No Elementary PK 05 2020   kindergarten                         42.0 45.0                       87.0                         42 45                 87
1908104 1908104 IN     school 1803940 1010   Greater Clark County Schools 180394000681 805 Utica Elementary School   Regular School No Elementary KG 05 2020   kindergarten                         44.0 45.0                       89.0                         44 45                 89
1908111 1908111 IN     school 1803940 1010   Greater Clark County Schools 180394000671 807 New Washington Elementary School   Regular School No Elementary PK 05 2020   kindergarten                         24.0 18.0                       42.0                         24 18                 42
1908133 1908133 IN     school 1803940 1010   Greater Clark County Schools 180394000676 829 Pleasant Ridge Elementary School   Regular School No Elementary PK 02 2020   kindergarten                         80.0 68.0                       148.0                         80 68                 148
1908154 1908154 IN     school 1803940 1010   Greater Clark County Schools 180394000665 865 Bridgepoint Elementary School   Regular School No Elementary PK 05 2020   kindergarten                         43.0 33.0                       76.0                         43 33                 76
1908162 1908162 IN     school 1803940 1010   Greater Clark County Schools 180394000668 869 Maple Elementary School   Regular School No Elementary KG 05 2020   kindergarten                         17.0 10.0                       27.0                         17 10                 27
1908169 1908169 IN     school 1803940 1010   Greater Clark County Schools 180394000677 871 Riverside Elementary School   Regular School No Elementary PK 05 2020   kindergarten                         40.0 39.0                       79.0                         40 39                 79
1908177 1908177 IN     school 1803940 1010   Greater Clark County Schools 180394000679 877 Spring Hill Elementary School   Regular School No Elementary PK 05 2020   kindergarten                         12.0 16.0                       28.0                         12 16                 28
1908185 1908185 IN     school 1803940 1010   Greater Clark County Schools 180394000675 879 Parkwood Elementary School   Regular School No Elementary PK 05 2020   kindergarten                         37.0 44.0                       81.0                         37 44                 81
1920061 1920061 IN     school 1803940 1010   Greater Clark County Schools 180394000682 755 W E Wilson Elementary   Regular School No Elementary PK 05 2021   kindergarten                         52.0 41.0                       93.0                         52 41                 93
1920069 1920069 IN     school 1803940 1010   Greater Clark County Schools 180394000680 761 Thomas Jefferson Elementary School   Regular School No Elementary PK 05 2021   kindergarten                         30.0 19.0                       49.0                         30 19                 49
1920077 1920077 IN     school 1803940 1010   Greater Clark County Schools 180394000673 801 Northaven Elementary School   Regular School No Elementary PK 05 2021   kindergarten                         41.0 32.0                       73.0                         41 32                 73
1920085 1920085 IN     school 1803940 1010   Greater Clark County Schools 180394000681 805 Utica Elementary School   Regular School No Elementary PK 05 2021   kindergarten                         43.0 53.0                       96.0                         43 53                 96
1920093 1920093 IN     school 1803940 1010   Greater Clark County Schools 180394000671 807 New Washington Elementary School   Regular School No Elementary PK 05 2021   kindergarten                         24.0 26.0                       50.0                         24 26                 50
1920115 1920115 IN     school 1803940 1010   Greater Clark County Schools 180394000676 829 Pleasant Ridge Elementary School   Regular School No Elementary PK 02 2021   kindergarten                         78.0 76.0                       154.0                         78 76                 154
1920136 1920136 IN     school 1803940 1010   Greater Clark County Schools 180394000665 865 Bridgepoint Elementary School   Regular School No Elementary PK 05 2021   kindergarten                         23.0 28.0                       51.0                         23 28                 51
1920144 1920144 IN     school 1803940 1010   Greater Clark County Schools 180394000677 871 Riverside Elementary School   Regular School No Elementary PK 05 2021   kindergarten                         35.0 30.0                       65.0                         35 30                 65
1920152 1920152 IN     school 1803940 1010   Greater Clark County Schools 180394002691 874 Franklin Square Elementary School   Regular School No Elementary PK 05 2021   kindergarten                         38.0 29.0                       67.0                         38 29                 67
1920160 1920160 IN     school 1803940 1010   Greater Clark County Schools 180394000675 879 Parkwood Elementary School   Regular School No Elementary PK 05 2021   kindergarten                         39.0 53.0                       92.0                         39 53                 92
1160700 1160700 IN     school 1800840 1125   Clay Community Schools 180084000156 895 Clay City Elementary School   Regular School No 1.0 KG 06 2015   kindergarten                         21.0 24.0                       45.0                         21 24                 45
1160714 1160714 IN     school 1800840 1125   Clay Community Schools 180084000160 901 Jackson Township Elem School   Regular School No 1.0 KG 05 2015   kindergarten                         23.0 27.0                       50.0                         23 27                 50
1160721 1160721 IN     school 1800840 1125   Clay Community Schools 180084000162 907 Staunton Elementary School   Regular School No 1.0 KG 05 2015   kindergarten                         19.0 29.0                       48.0                         19 29                 48
1160728 1160728 IN     school 1800840 1125   Clay Community Schools 180084000164 923 Van Buren Elementary School   Regular School No 1.0 KG 05 2015   kindergarten                         20.0 20.0                       40.0                         20 20                 40
1160744 1160744 IN     school 1800840 1125   Clay Community Schools 180084000158 941 East Side Elementary School   Regular School No 1.0 PK 05 2015   kindergarten                         18.0 21.0                       39.0                         18 21                 39
1160753 1160753 IN     school 1800840 1125   Clay Community Schools 180084000159 942 Forest Park Elementary School   Regular School No 1.0 PK 07 2015   kindergarten                         27.0 20.0                       47.0                         27 20                 47
1160761 1160761 IN     school 1800840 1125   Clay Community Schools 180084000161 949 Meridian Street Elem School   Regular School No 1.0 PK 05 2015   kindergarten                         23.0 24.0                       47.0                         23 24                 47
1282102 1282102 IN     school 1800840 1125   Clay Community Schools 180084000156 895 Clay City Elementary School   Regular School No 1.0 KG 06 2016   kindergarten                         20.0 21.0                       41.0                         20 21                 41
1282116 1282116 IN     school 1800840 1125   Clay Community Schools 180084000160 901 Jackson Township Elem School   Regular School No 1.0 KG 05 2016   kindergarten                         29.0 14.0                       43.0                         29 14                 43
1282123 1282123 IN     school 1800840 1125   Clay Community Schools 180084000162 907 Staunton Elementary School   Regular School No 1.0 KG 05 2016   kindergarten                         29.0 26.0                       55.0                         29 26                 55
1282130 1282130 IN     school 1800840 1125   Clay Community Schools 180084000164 923 Van Buren Elementary School   Regular School No 1.0 KG 05 2016   kindergarten                         34.0 23.0                       57.0                         34 23                 57
1282146 1282146 IN     school 1800840 1125   Clay Community Schools 180084000158 941 East Side Elementary School   Regular School No 1.0 PK 05 2016   kindergarten                         19.0 17.0                       36.0                         19 17                 36
1282155 1282155 IN     school 1800840 1125   Clay Community Schools 180084000159 942 Forest Park Elementary School   Regular School No 1.0 PK 08 2016   kindergarten                         21.0 25.0                       46.0                         21 25                 46

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