enrollments

Data source: Big Local News · About: Big Local

7,371 rows where grade = "grade_2" and state = "IN" sorted by school_state_id descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_2 · 7,371 ✖
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
1171071 1171071 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Alternative Education School No 4.0 PK 12 2015   grade_2                         10.0 11.0                       21.0                         10 11                 21
1292448 1292448 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Alternative Education School No 4.0 PK 12 2016   grade_2                         3.0 9.0                       12.0                         3 9                 12
1304481 1304481 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Alternative School No Other PK 12 2017   grade_2                         6.0 4.0                       10.0                         6 4                 10
1763093 1763093 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Special Education School No Other PK 12 2019   grade_2                         14.0 7.0                       21.0                         14 7                 21
1798823 1798823 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Special Education School No Other PK 12 2018   grade_2                         8.0 9.0                       17.0                         8 9                 17
1918562 1918562 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Special Education School No Other PK 12 2020   grade_2                         7.0 20.0                       27.0                         7 20                 27
1930558 1930558 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Special Education School No Other PK 12 2021   grade_2                         9.0 10.0                       19.0                         9 10                 19
1171056 1171056 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 Indiana School For The Blind   Alternative Education School No 4.0 PK 12 2015   grade_2                         2.0 0.0                       2.0                         2 0                 2
1292433 1292433 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 Indiana School For The Blind   Alternative Education School No 4.0 PK 12 2016   grade_2                         2.0 1.0                       3.0                         2 1                 3
1304466 1304466 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 IN Sch for the Blind & Vis Imprd   Alternative School No Other PK 12 2017   grade_2                         4.0 3.0                       7.0                         4 3                 7
1763078 1763078 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 IN Sch for the Blind & Vis Imprd   Special Education School No Other PK 12 2019   grade_2                         7.0 0.0                       7.0                         7 0                 7
1798808 1798808 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 IN Sch for the Blind & Vis Imprd   Special Education School No Other PK 12 2018   grade_2                         2.0 1.0                       3.0                         2 1                 3
1918547 1918547 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 IN Sch for the Blind & Vis Imprd   Special Education School No Other PK 12 2020   grade_2                         5.0 3.0                       8.0                         5 3                 8
1930542 1930542 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 IN Sch for the Blind & Vis Imprd   Special Education School No Other PK 12 2021   grade_2                         2.0 2.0                       4.0                         2 2                 4
1930218 1930218 IN     school 1800216 9130   Adelante Schools 180021602702 9993 Emma Donnan Elementary and Middle   Regular School Yes Elementary KG 08 2021   grade_2                         13.0 12.0                       25.0                         13 12                 25
1930085 1930085 IN     school 1800222 9000   Phalen Virtual Leadership Academy 180022202707 9992 Phalen Virtual Leadership Academy   Regular School Yes Other 02 12 2021   grade_2                         3.0 0.0                       3.0                         3 0                 3
1930079 1930079 IN     school 1800221 8990   HIM By HER Collegiate School for t 180022102706 9991 HIM By HER Collegiate School for t   Regular School Yes Elementary KG 02 2021   grade_2                         5.0 3.0                       8.0                         5 3                 8
1930069 1930069 IN     school 1800220 8980   The PATH School 180022002705 9971 The PATH School   Regular School Yes Elementary KG 08 2021   grade_2                         18.0 25.0                       43.0                         18 25                 43
1918089 1918089 IN     school 1800207 8675   Invent Learning Hub 180020702683 9532 Invent Learning Hub   Regular School Yes Elementary KG 05 2020   grade_2                         7.0 7.0                       14.0                         7 7                 14
1930019 1930019 IN     school 1800207 8675   Invent Learning Hub 180020702683 9532 Invent Learning Hub   Regular School Yes Elementary KG 07 2021   grade_2                         9.0 10.0                       19.0                         9 10                 19
1170664 1170664 IN     school 1810230 8625   Smith-Green Community Schools 181023001637 9197 Churubusco Elementary School   Regular School No 1.0 PK 05 2015   grade_2                         38.0 41.0                       79.0                         38 41                 79
1292053 1292053 IN     school 1810230 8625   Smith-Green Community Schools 181023001637 9197 Churubusco Elementary School   Regular School No 1.0 PK 05 2016   grade_2                         44.0 50.0                       94.0                         44 50                 94
1304076 1304076 IN     school 1810230 8625   Smith-Green Community Schools 181023001637 9197 Churubusco Elementary School   Regular School No Elementary KG 05 2017   grade_2                         42.0 47.0                       89.0                         42 47                 89
1762618 1762618 IN     school 1810230 8625   Smith-Green Community Schools 181023001637 9197 Churubusco Elementary School   Regular School No Elementary PK 05 2019   grade_2                         48.0 41.0                       89.0                         48 41                 89
1798399 1798399 IN     school 1810230 8625   Smith-Green Community Schools 181023001637 9197 Churubusco Elementary School   Regular School No Elementary PK 05 2018   grade_2                         45.0 43.0                       88.0                         45 43                 88
1918037 1918037 IN     school 1810230 8625   Smith-Green Community Schools 181023001637 9197 Churubusco Elementary School   Regular School No Elementary PK 05 2020   grade_2                         44.0 35.0                       79.0                         44 35                 79
1929964 1929964 IN     school 1810230 8625   Smith-Green Community Schools 181023001637 9197 Churubusco Elementary School   Regular School No Elementary PK 05 2021   grade_2                         39.0 39.0                       78.0                         39 39                 78
1170703 1170703 IN     school 1802280 8665   Whitley Co Cons Schools 180228002108 9196 Mary Raber Elementary School   Regular School No 1.0 PK 05 2015   grade_2                         19.0 36.0                       55.0                         19 36                 55
1292092 1292092 IN     school 1802280 8665   Whitley Co Cons Schools 180228002108 9196 Mary Raber Elementary School   Regular School No 1.0 PK 05 2016   grade_2                         20.0 24.0                       44.0                         20 24                 44
1304114 1304114 IN     school 1802280 8665   Whitley County Con Schools 180228002108 9196 Mary Raber Elementary School   Regular School No Elementary PK 05 2017   grade_2                         21.0 21.0                       42.0                         21 21                 42
1762657 1762657 IN     school 1802280 8665   Whitley County Con Schools 180228002108 9196 Mary Raber Elementary School   Regular School No Elementary PK 05 2019   grade_2                         8.0 21.0                       29.0                         8 21                 29
1798438 1798438 IN     school 1802280 8665   Whitley County Con Schools 180228002108 9196 Mary Raber Elementary School   Regular School No Elementary PK 05 2018   grade_2                         22.0 29.0                       51.0                         22 29                 51
1918081 1918081 IN     school 1802280 8665   Whitley County Con Schools 180228002108 9196 Mary Raber Elementary School   Regular School No Elementary PK 05 2020   grade_2                         14.0 20.0                       34.0                         14 20                 34
1930011 1930011 IN     school 1802280 8665   Whitley County Con Schools 180228002108 9196 Mary Raber Elementary School   Regular School No Elementary PK 05 2021   grade_2                         19.0 18.0                       37.0                         19 18                 37
1170690 1170690 IN     school 1802280 8665   Whitley Co Cons Schools 180228001185 9186 Northern Heights Elementary Sch   Regular School No 1.0 KG 05 2015   grade_2                         48.0 32.0                       80.0                         48 32                 80
1292079 1292079 IN     school 1802280 8665   Whitley Co Cons Schools 180228001185 9186 Northern Heights Elementary School   Regular School No 1.0 KG 05 2016   grade_2                         53.0 44.0                       97.0                         53 44                 97
1304101 1304101 IN     school 1802280 8665   Whitley County Con Schools 180228001185 9186 Northern Heights Elementary School   Regular School No Elementary KG 05 2017   grade_2                         55.0 29.0                       84.0                         55 29                 84
1762644 1762644 IN     school 1802280 8665   Whitley County Con Schools 180228001185 9186 Northern Heights Elementary School   Regular School No Elementary KG 05 2019   grade_2                         42.0 30.0                       72.0                         42 30                 72
1798425 1798425 IN     school 1802280 8665   Whitley County Con Schools 180228001185 9186 Northern Heights Elementary School   Regular School No Elementary KG 05 2018   grade_2                         47.0 32.0                       79.0                         47 32                 79
1918068 1918068 IN     school 1802280 8665   Whitley County Con Schools 180228001185 9186 Northern Heights Elementary School   Regular School No Elementary KG 05 2020   grade_2                         32.0 41.0                       73.0                         32 41                 73
1929998 1929998 IN     school 1802280 8665   Whitley County Con Schools 180228001185 9186 Northern Heights Elementary School   Regular School No Elementary KG 05 2021   grade_2                         41.0 41.0                       82.0                         41 41                 82
1170679 1170679 IN     school 1802280 8665   Whitley Co Cons Schools 180228001871 9179 Coesse School   Regular School No 1.0 KG 05 2015   grade_2                         29.0 25.0                       54.0                         29 25                 54
1292068 1292068 IN     school 1802280 8665   Whitley Co Cons Schools 180228001871 9179 Coesse School   Regular School No 1.0 KG 05 2016   grade_2                         16.0 30.0                       46.0                         16 30                 46
1304090 1304090 IN     school 1802280 8665   Whitley County Con Schools 180228001871 9179 Coesse School   Regular School No Elementary KG 05 2017   grade_2                         36.0 18.0                       54.0                         36 18                 54
1762633 1762633 IN     school 1802280 8665   Whitley County Con Schools 180228001871 9179 Coesse School   Regular School No Elementary KG 05 2019   grade_2                         24.0 26.0                       50.0                         24 26                 50
1798414 1798414 IN     school 1802280 8665   Whitley County Con Schools 180228001871 9179 Coesse School   Regular School No Elementary KG 05 2018   grade_2                         20.0 31.0                       51.0                         20 31                 51
1918057 1918057 IN     school 1802280 8665   Whitley County Con Schools 180228001871 9179 Coesse School   Regular School No Elementary KG 05 2020   grade_2                         23.0 25.0                       48.0                         23 25                 48
1929987 1929987 IN     school 1802280 8665   Whitley County Con Schools 180228001871 9179 Coesse School   Regular School No Elementary KG 05 2021   grade_2                         22.0 18.0                       40.0                         22 18                 40
1170672 1170672 IN     school 1802280 8665   Whitley Co Cons Schools 180228002135 9178 Little Turtle Elementary School   Regular School No 1.0 KG 05 2015   grade_2                         57.0 34.0                       91.0                         57 34                 91
1292061 1292061 IN     school 1802280 8665   Whitley Co Cons Schools 180228002135 9178 Little Turtle Elementary School   Regular School No 1.0 KG 05 2016   grade_2                         52.0 42.0                       94.0                         52 42                 94
1304083 1304083 IN     school 1802280 8665   Whitley County Con Schools 180228002135 9178 Little Turtle Elementary School   Regular School No Elementary KG 05 2017   grade_2                         44.0 37.0                       81.0                         44 37                 81
1762626 1762626 IN     school 1802280 8665   Whitley County Con Schools 180228002135 9178 Little Turtle Elementary School   Regular School No Elementary KG 05 2019   grade_2                         45.0 40.0                       85.0                         45 40                 85
1798407 1798407 IN     school 1802280 8665   Whitley County Con Schools 180228002135 9178 Little Turtle Elementary School   Regular School No Elementary KG 05 2018   grade_2                         51.0 46.0                       97.0                         51 46                 97
1918050 1918050 IN     school 1802280 8665   Whitley County Con Schools 180228002135 9178 Little Turtle Elementary School   Regular School No Elementary KG 05 2020   grade_2                         44.0 43.0                       87.0                         44 43                 87
1929980 1929980 IN     school 1802280 8665   Whitley County Con Schools 180228002135 9178 Little Turtle Elementary School   Regular School No Elementary KG 05 2021   grade_2                         55.0 47.0                       102.0                         55 47                 102
1164262 1164262 IN     school 1813230 4455   Whitko Community School Corp 181323002087 9173 South Whitley Elementary Sch   Regular School No 1.0 PK 05 2015   grade_2                         21.0 32.0                       53.0                         21 32                 53
1285669 1285669 IN     school 1813230 4455   Whitko Community School Corp 181323002087 9173 South Whitley Elementary School   Regular School No 1.0 KG 05 2016   grade_2                         27.0 29.0                       56.0                         27 29                 56
1297715 1297715 IN     school 1813230 4455   Whitko Community School Corp 181323002087 9173 South Whitley Elementary School   Regular School No Elementary PK 05 2017   grade_2                         19.0 21.0                       40.0                         19 21                 40
1756309 1756309 IN     school 1813230 4455   Whitko Community School Corp 181323002087 9173 South Whitley Elementary School   Regular School No Elementary KG 06 2019   grade_2                         16.0 27.0                       43.0                         16 27                 43
1792073 1792073 IN     school 1813230 4455   Whitko Community School Corp 181323002087 9173 South Whitley Elementary School   Regular School No Elementary PK 05 2018   grade_2                         25.0 17.0                       42.0                         25 17                 42
1911766 1911766 IN     school 1813230 4455   Whitko Community School Corp 181323002087 9173 South Whitley Elementary School   Regular School No Elementary KG 06 2020   grade_2                         16.0 23.0                       39.0                         16 23                 39
1923734 1923734 IN     school 1813230 4455   Whitko Community School Corp 181323002087 9173 South Whitley Elementary School   Regular School No Elementary KG 06 2021   grade_2                         19.0 17.0                       36.0                         19 17                 36
1170649 1170649 IN     school 1811580 8565   Twin Lakes School Corp 181158001860 9163 Meadowlawn Elementary School   Regular School No 1.0 KG 05 2015   grade_2                         33.0 31.0                       64.0                         33 31                 64
1292038 1292038 IN     school 1811580 8565   Twin Lakes School Corp 181158001860 9163 Meadowlawn Elementary School   Regular School No 1.0 KG 05 2016   grade_2                         39.0 34.0                       73.0                         39 34                 73
1304060 1304060 IN     school 1811580 8565   Twin Lakes School Corp 181158001860 9163 Meadowlawn Elementary School   Regular School No Elementary KG 05 2017   grade_2                         45.0 38.0                       83.0                         45 38                 83
1762602 1762602 IN     school 1811580 8565   Twin Lakes School Corp 181158001860 9163 Meadowlawn Elementary School   Regular School No Elementary KG 05 2019   grade_2                         38.0 37.0                       75.0                         38 37                 75
1798383 1798383 IN     school 1811580 8565   Twin Lakes School Corp 181158001860 9163 Meadowlawn Elementary School   Regular School No Elementary KG 05 2018   grade_2                         30.0 31.0                       61.0                         30 31                 61
1918021 1918021 IN     school 1811580 8565   Twin Lakes School Corp 181158001860 9163 Meadowlawn Elementary School   Regular School No Elementary KG 05 2020   grade_2                         32.0 38.0                       70.0                         32 38                 70
1929948 1929948 IN     school 1811580 8565   Twin Lakes School Corp 181158001860 9163 Meadowlawn Elementary School   Regular School No Elementary KG 05 2021   grade_2                         28.0 28.0                       56.0                         28 28                 56
1170643 1170643 IN     school 1811580 8565   Twin Lakes School Corp 181158001861 9157 Oaklawn Elementary School   Regular School No 1.0 KG 04 2015   grade_2                         28.0 30.0                       58.0                         28 30                 58
1292032 1292032 IN     school 1811580 8565   Twin Lakes School Corp 181158001861 9157 Oaklawn Elementary School   Regular School No 1.0 KG 04 2016   grade_2                         37.0 32.0                       69.0                         37 32                 69
1304054 1304054 IN     school 1811580 8565   Twin Lakes School Corp 181158001861 9157 Oaklawn Elementary School   Regular School No Elementary KG 04 2017   grade_2                         30.0 31.0                       61.0                         30 31                 61
1762596 1762596 IN     school 1811580 8565   Twin Lakes School Corp 181158001861 9157 Oaklawn Elementary School   Regular School No Elementary KG 04 2019   grade_2                         25.0 25.0                       50.0                         25 25                 50
1798377 1798377 IN     school 1811580 8565   Twin Lakes School Corp 181158001861 9157 Oaklawn Elementary School   Regular School No Elementary KG 04 2018   grade_2                         37.0 34.0                       71.0                         37 34                 71
1918015 1918015 IN     school 1811580 8565   Twin Lakes School Corp 181158001861 9157 Oaklawn Elementary School   Regular School No Elementary KG 04 2020   grade_2                         45.0 26.0                       71.0                         45 26                 71
1929942 1929942 IN     school 1811580 8565   Twin Lakes School Corp 181158001861 9157 Oaklawn Elementary School   Regular School No Elementary KG 04 2021   grade_2                         39.0 29.0                       68.0                         39 29                 68
1170627 1170627 IN     school 1811580 8565   Twin Lakes School Corp 181158001859 9129 Eastlawn Elementary School   Regular School No 1.0 PK 04 2015   grade_2                         19.0 14.0                       33.0                         19 14                 33
1292016 1292016 IN     school 1811580 8565   Twin Lakes School Corp 181158001859 9129 Eastlawn Elementary School   Regular School No 1.0 PK 04 2016   grade_2                         11.0 19.0                       30.0                         11 19                 30
1304038 1304038 IN     school 1811580 8565   Twin Lakes School Corp 181158001859 9129 Eastlawn Elementary School   Regular School No Elementary PK 04 2017   grade_2                         19.0 13.0                       32.0                         19 13                 32
1762580 1762580 IN     school 1811580 8565   Twin Lakes School Corp 181158001859 9129 Eastlawn Elementary School   Regular School No Elementary PK 04 2019   grade_2                         19.0 9.0                       28.0                         19 9                 28
1798361 1798361 IN     school 1811580 8565   Twin Lakes School Corp 181158001859 9129 Eastlawn Elementary School   Regular School No Elementary PK 04 2018   grade_2                         26.0 20.0                       46.0                         26 20                 46
1917999 1917999 IN     school 1811580 8565   Twin Lakes School Corp 181158001859 9129 Eastlawn Elementary School   Regular School No Elementary PK 04 2020   grade_2                         18.0 21.0                       39.0                         18 21                 39
1929925 1929925 IN     school 1811580 8565   Twin Lakes School Corp 181158001859 9129 Eastlawn Elementary School   Regular School No Elementary PK 04 2021   grade_2                         11.0 24.0                       35.0                         11 24                 35
1170578 1170578 IN     school 1808130 8515   North White School Corp 180813002500 9119 North White Primary School   Regular School No 1.0 PK 03 2015   grade_2                         29.0 33.0                       62.0                         29 33                 62
1291967 1291967 IN     school 1808130 8515   North White School Corp 180813002500 9119 North White Primary School   Regular School No 1.0 PK 03 2016   grade_2                         29.0 39.0                       68.0                         29 39                 68
1303990 1303990 IN     school 1808130 8515   North White School Corp 180813002500 9119 North White Elementary School   Regular School No Elementary KG 05 2017   grade_2                         33.0 31.0                       64.0                         33 31                 64
1762529 1762529 IN     school 1808130 8515   North White School Corp 180813002500 9119 North White Elementary School   Regular School No Elementary KG 05 2019   grade_2                         36.0 31.0                       67.0                         36 31                 67
1798312 1798312 IN     school 1808130 8515   North White School Corp 180813002500 9119 North White Elementary School   Regular School No Elementary KG 05 2018   grade_2                         44.0 37.0                       81.0                         44 37                 81
1917949 1917949 IN     school 1808130 8515   North White School Corp 180813002500 9119 North White Elementary School   Regular School No Elementary KG 05 2020   grade_2                         32.0 26.0                       58.0                         32 26                 58
1929875 1929875 IN     school 1808130 8515   North White School Corp 180813002500 9119 North White Elementary School   Regular School No Elementary KG 05 2021   grade_2                         34.0 43.0                       77.0                         34 43                 77
1170595 1170595 IN     school 1803810 8525   Frontier School Corporation 180381000604 9113 Frontier Elementary   Regular School No 1.0 KG 06 2015   grade_2                         15.0 33.0                       48.0                         15 33                 48
1291984 1291984 IN     school 1803810 8525   Frontier School Corporation 180381000604 9113 Frontier Elementary   Regular School No 1.0 KG 06 2016   grade_2                         31.0 34.0                       65.0                         31 34                 65
1304006 1304006 IN     school 1803810 8525   Frontier School Corporation 180381000604 9113 Frontier Elementary   Regular School No Elementary PK 06 2017   grade_2                         26.0 20.0                       46.0                         26 20                 46
1762546 1762546 IN     school 1803810 8525   Frontier School Corporation 180381000604 9113 Frontier Elementary   Regular School No Elementary PK 06 2019   grade_2                         23.0 30.0                       53.0                         23 30                 53
1798328 1798328 IN     school 1803810 8525   Frontier School Corporation 180381000604 9113 Frontier Elementary   Regular School No Elementary PK 06 2018   grade_2                         20.0 28.0                       48.0                         20 28                 48
1917965 1917965 IN     school 1803810 8525   Frontier School Corporation 180381000604 9113 Frontier Elementary   Regular School No Elementary PK 06 2020   grade_2                         22.0 22.0                       44.0                         22 22                 44
1929891 1929891 IN     school 1803810 8525   Frontier School Corporation 180381000604 9113 Frontier Elementary   Regular School No Elementary PK 06 2021   grade_2                         32.0 20.0                       52.0                         32 20                 52
1170572 1170572 IN     school 1800720 8445   M S D Bluffton-Harrison 180072000149 9098 Bluffton-Harrison Elem Sch   Regular School No 1.0 KG 04 2015   grade_2                         54.0 46.0                       100.0                         54 46                 100
1291961 1291961 IN     school 1800720 8445   M S D Bluffton-Harrison 180072000149 9098 Bluffton-Harrison Elem Sch   Regular School No 1.0 KG 04 2016   grade_2                         70.0 53.0                       123.0                         70 53                 123
1303984 1303984 IN     school 1800720 8445   M S D Bluffton-Harrison 180072000149 9098 Bluffton-Harrison Elementary Sch   Regular School No Elementary KG 04 2017   grade_2                         91.0 69.0                       160.0                         91 69                 160

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