enrollments

Data source: Big Local News · About: Big Local

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

✎ 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
1171008 1171008 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes 4.0 KG 12 2015   grade_2                         28.0 30.0                       58.0                         28 30                 58
1292385 1292385 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes 4.0 KG 12 2016   grade_2                         28.0 39.0                       67.0                         28 39                 67
1304418 1304418 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2017   grade_2                         42.0 31.0                       73.0                         42 31                 73
1763029 1763029 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2019   grade_2                         32.0 41.0                       73.0                         32 41                 73
1798759 1798759 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2018   grade_2                         28.0 47.0                       75.0                         28 47                 75
1918498 1918498 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2020   grade_2                         50.0 47.0                       97.0                         50 47                 97
1930493 1930493 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2021   grade_2                         37.0 50.0                       87.0                         37 50                 87
1763495 1763495 IN     school 1800172 9970   ACE Preparatory Academy 180017202604 1111 ACE Preparatory Academy   Regular School Yes Elementary KG 03 2019   grade_2                         9.0 8.0                       17.0                         9 8                 17
1799270 1799270 IN     school 1800172 9970   ACE Preparatory Academy 180017202604 1111 ACE Preparatory Academy   Regular School Yes Elementary KG 02 2018   grade_2                         5.0 7.0                       12.0                         5 7                 12
1918904 1918904 IN     school 1800172 9970   ACE Preparatory Academy 180017202604 1111 ACE Preparatory Academy   Regular School Yes Elementary KG 04 2020   grade_2                         18.0 22.0                       40.0                         18 22                 40
1930902 1930902 IN     school 1800172 9970   ACE Preparatory Academy 180017202604 1111 ACE Preparatory Academy   Regular School Yes Elementary KG 05 2021   grade_2                         15.0 15.0                       30.0                         15 15                 30
1159516 1159516 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No 1.0 KG 05 2015   grade_2                         55.0 42.0                       97.0                         55 42                 97
1280906 1280906 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No 1.0 KG 05 2016   grade_2                         36.0 42.0                       78.0                         36 42                 78
1292968 1292968 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2017   grade_2                         47.0 38.0                       85.0                         47 38                 85
1751600 1751600 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2019   grade_2                         44.0 40.0                       84.0                         44 40                 84
1787341 1787341 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2018   grade_2                         48.0 34.0                       82.0                         48 34                 82
1907041 1907041 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2020   grade_2                         44.0 33.0                       77.0                         44 33                 77
1919007 1919007 IN     school 1800030 125   MSD Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2021   grade_2                         36.0 29.0                       65.0                         36 29                 65
1164961 1164961 IN     school 1804320 4710   School City of Hammond 180432000730 4463 Abraham Lincoln Elem Sch   Regular School No 1.0 PK 05 2015   grade_2                         52.0 57.0                       109.0                         52 57                 109
1165870 1165870 IN     school 1808820 5340   Perry Township Schools 180882001455 5337 Abraham Lincoln Elem Sch   Regular School No 1.0 KG 05 2015   grade_2                         76.0 56.0                       132.0                         76 56                 132
1164660 1164660 IN     school 1802880 4670   School City of East Chicago 180288000362 3945 Abraham Lincoln Elementary Sch   Regular School No 1.0 PK 05 2015   grade_2                         27.0 33.0                       60.0                         27 33                 60
1286049 1286049 IN     school 1802880 4670   School City of East Chicago 180288000362 3945 Abraham Lincoln Elementary School   Regular School No 1.0 PK 06 2016   grade_2                         27.0 33.0                       60.0                         27 33                 60
1286356 1286356 IN     school 1804320 4710   School City of Hammond 180432000730 4463 Abraham Lincoln Elementary School   Regular School No 1.0 PK 05 2016   grade_2                         50.0 45.0                       95.0                         50 45                 95
1287268 1287268 IN     school 1808820 5340   Perry Township Schools 180882001455 5337 Abraham Lincoln Elementary School   Regular School No 1.0 PK 05 2016   grade_2                         84.0 68.0                       152.0                         84 68                 152
1298095 1298095 IN     school 1802880 4670   School City of East Chicago 180288000362 3945 Abraham Lincoln Elementary School   Regular School No Elementary PK 06 2017   grade_2                         27.0 21.0                       48.0                         27 21                 48
1298396 1298396 IN     school 1804320 4710   School City of Hammond 180432000730 4463 Abraham Lincoln Elementary School   Regular School No Elementary PK 05 2017   grade_2                         62.0 49.0                       111.0                         62 49                 111
1299307 1299307 IN     school 1808820 5340   Perry Township Schools 180882001455 5337 Abraham Lincoln Elementary School   Regular School No Elementary PK 05 2017   grade_2                         79.0 78.0                       157.0                         79 78                 157
1756683 1756683 IN     school 1802880 4670   School City of East Chicago 180288000362 3945 Abraham Lincoln Elementary School   Regular School No Elementary KG 06 2019   grade_2                         20.0 18.0                       38.0                         20 18                 38
1756925 1756925 IN     school 1804320 4710   School City of Hammond 180432000730 4463 Abraham Lincoln Elementary School   Regular School No Elementary PK 05 2019   grade_2                         38.0 47.0                       85.0                         38 47                 85
1757848 1757848 IN     school 1808820 5340   Perry Township Schools 180882001455 5337 Abraham Lincoln Elementary School   Regular School No Elementary PK 05 2019   grade_2                         61.0 76.0                       137.0                         61 76                 137
1792447 1792447 IN     school 1802880 4670   School City of East Chicago 180288000362 3945 Abraham Lincoln Elementary School   Regular School No Elementary KG 07 2018   grade_2                         32.0 20.0                       52.0                         32 20                 52
1792717 1792717 IN     school 1804320 4710   School City of Hammond 180432000730 4463 Abraham Lincoln Elementary School   Regular School No Elementary PK 05 2018   grade_2                         55.0 46.0                       101.0                         55 46                 101
1793635 1793635 IN     school 1808820 5340   Perry Township Schools 180882001455 5337 Abraham Lincoln Elementary School   Regular School No Elementary PK 05 2018   grade_2                         80.0 84.0                       164.0                         80 84                 164
1912123 1912123 IN     school 1802880 4670   School City of East Chicago 180288000362 3945 Abraham Lincoln Elementary School   Regular School No Elementary KG 06 2020   grade_2                         26.0 18.0                       44.0                         26 18                 44
1912359 1912359 IN     school 1804320 4710   School City of Hammond 180432000730 4463 Abraham Lincoln Elementary School   Regular School No Elementary PK 05 2020   grade_2                         40.0 46.0                       86.0                         40 46                 86
1913267 1913267 IN     school 1808820 5340   Perry Township Schools 180882001455 5337 Abraham Lincoln Elementary School   Regular School No Elementary PK 05 2020   grade_2                         84.0 62.0                       146.0                         84 62                 146
1924092 1924092 IN     school 1802880 4670   School City of East Chicago 180288000362 3945 Abraham Lincoln Elementary School   Regular School No Elementary KG 06 2021   grade_2                         24.0 34.0                       58.0                         24 34                 58
1924308 1924308 IN     school 1804320 4710   School City of Hammond 180432000730 4463 Abraham Lincoln Elementary School   Regular School No Elementary PK 05 2021   grade_2                         42.0 43.0                       85.0                         42 43                 85
1925176 1925176 IN     school 1808820 5340   Perry Township Schools 180882001455 5337 Abraham Lincoln Elementary School   Regular School No Elementary PK 05 2021   grade_2                         64.0 73.0                       137.0                         64 73                 137
1169729 1169729 IN     school 1803450 7995   Evansville Vanderburgh Sch Corp 180345002462 8270 Academy for Innovative Studies   Regular School No 4.0 KG 12 2015   grade_2                         1.0 2.0                       3.0                         1 2                 3
1291119 1291119 IN     school 1803450 7995   Evansville Vanderburgh Sch Corp 180345002462 8270 Academy for Innovative Studies   Regular School No 4.0 01 12 2016   grade_2                         4.0 2.0                       6.0                         4 2                 6
1303148 1303148 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002462 8270 Academy for Innovative Studies   Regular School No Other KG 12 2017   grade_2                         3.0 3.0                       6.0                         3 3                 6
1761659 1761659 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002462 8270 Academy for Innovative Studies   Regular School No Other 01 12 2019   grade_2                         7.0 1.0                       8.0                         7 1                 8
1797464 1797464 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002462 8270 Academy for Innovative Studies   Regular School No Other 01 12 2018   grade_2                         4.0 2.0                       6.0                         4 2                 6
1917065 1917065 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002462 8270 Academy for Innovative Studies   Regular School No Other 01 12 2020   grade_2                         2.0 2.0                       4.0                         2 2                 4
1928995 1928995 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002462 8270 Academy for Innovative Studies   Regular School No Other 02 12 2021   grade_2                         6.0 0.0                       6.0                         6 0                 6
1299126 1299126 IN     school 1803750 5310   Franklin Township Com Sch Corp 180375000595 5201 Acton Elementary School   Regular School No Elementary KG 05 2017   grade_2                         42.0 32.0                       74.0                         42 32                 74
1757664 1757664 IN     school 1803750 5310   Franklin Township Com Sch Corp 180375000595 5201 Acton Elementary School   Regular School No Elementary KG 05 2019   grade_2                         41.0 27.0                       68.0                         41 27                 68
1793454 1793454 IN     school 1803750 5310   Franklin Township Com Sch Corp 180375000595 5201 Acton Elementary School   Regular School No Elementary KG 05 2018   grade_2                         42.0 36.0                       78.0                         42 36                 78
1913081 1913081 IN     school 1803750 5310   Franklin Township Com Sch Corp 180375000595 5201 Acton Elementary School   Regular School No Elementary KG 05 2020   grade_2                         32.0 44.0                       76.0                         32 44                 76
1924995 1924995 IN     school 1803750 5310   Franklin Township Com Sch Corp 180375000595 5201 Acton Elementary School   Regular School No Elementary KG 03 2021   grade_2                         75.0 72.0                       147.0                         75 72                 147
1159467 1159467 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary Sch   Regular School No 1.0 KG 05 2015   grade_2                         50.0 50.0                       100.0                         50 50                 100
1280857 1280857 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No 1.0 KG 05 2016   grade_2                         64.0 38.0                       102.0                         64 38                 102
1292919 1292919 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2017   grade_2                         53.0 52.0                       105.0                         53 52                 105
1751551 1751551 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2019   grade_2                         60.0 39.0                       99.0                         60 39                 99
1787292 1787292 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2018   grade_2                         52.0 42.0                       94.0                         52 42                 94
1906992 1906992 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2020   grade_2                         61.0 63.0                       124.0                         61 63                 124
1918958 1918958 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2021   grade_2                         56.0 43.0                       99.0                         56 43                 99
1159730 1159730 IN     school 1803630 235   Fort Wayne Community Schools 180363000511 141 Adams Elementary School   Regular School No 1.0 PK 05 2015   grade_2                         28.0 27.0                       55.0                         28 27                 55
1281122 1281122 IN     school 1803630 235   Fort Wayne Community Schools 180363000511 141 Adams Elementary School   Regular School No 1.0 PK 05 2016   grade_2                         32.0 16.0                       48.0                         32 16                 48
1293183 1293183 IN     school 1803630 235   Fort Wayne Community Schools 180363000511 141 Adams Elementary School   Regular School No Elementary PK 05 2017   grade_2                         19.0 32.0                       51.0                         19 32                 51
1751808 1751808 IN     school 1803630 235   Fort Wayne Community Schools 180363000511 141 Adams Elementary School   Regular School No Elementary PK 05 2019   grade_2                         23.0 23.0                       46.0                         23 23                 46
1787552 1787552 IN     school 1803630 235   Fort Wayne Community Schools 180363000511 141 Adams Elementary School   Regular School No Elementary PK 05 2018   grade_2                         16.0 18.0                       34.0                         16 18                 34
1907248 1907248 IN     school 1803630 235   Fort Wayne Community Schools 180363000511 141 Adams Elementary School   Regular School No Elementary PK 05 2020   grade_2                         22.0 24.0                       46.0                         22 24                 46
1919214 1919214 IN     school 1803630 235   Fort Wayne Community Schools 180363000511 141 Adams Elementary School   Regular School No Elementary PK 05 2021   grade_2                         17.0 26.0                       43.0                         17 26                 43
1169998 1169998 IN     school 1812090 8030   Vigo County School Corp 181209002172 8510 Adelaide De Vaney Elem Sch   Regular School No 1.0 KG 05 2015   grade_2                         40.0 43.0                       83.0                         40 43                 83
1291388 1291388 IN     school 1812090 8030   Vigo County School Corp 181209002172 8510 Adelaide De Vaney Elementary Sch   Regular School No 1.0 KG 05 2016   grade_2                         30.0 46.0                       76.0                         30 46                 76
1303416 1303416 IN     school 1812090 8030   Vigo County School Corp 181209002172 8510 Adelaide De Vaney Elementary Sch   Regular School No Elementary KG 05 2017   grade_2                         32.0 30.0                       62.0                         32 30                 62
1761942 1761942 IN     school 1812090 8030   Vigo County School Corp 181209002172 8510 Adelaide De Vaney Elementary Sch   Regular School No Elementary PK 05 2019   grade_2                         36.0 33.0                       69.0                         36 33                 69
1797731 1797731 IN     school 1812090 8030   Vigo County School Corp 181209002172 8510 Adelaide De Vaney Elementary Sch   Regular School No Elementary PK 05 2018   grade_2                         30.0 39.0                       69.0                         30 39                 69
1917356 1917356 IN     school 1812090 8030   Vigo County School Corp 181209002172 8510 Adelaide De Vaney Elementary Sch   Regular School No Elementary PK 05 2020   grade_2                         31.0 31.0                       62.0                         31 31                 62
1929295 1929295 IN     school 1812090 8030   Vigo County School Corp 181209002172 8510 Adelaide De Vaney Elementary Sch   Regular School No Elementary KG 05 2021   grade_2                         42.0 27.0                       69.0                         42 27                 69
1164227 1164227 IN     school 1811370 4445   Tippecanoe Valley School Corp 181137001836 2139 Akron Elementary School   Regular School No 1.0 KG 05 2015   grade_2                         39.0 27.0                       66.0                         39 27                 66
1285634 1285634 IN     school 1811370 4445   Tippecanoe Valley School Corp 181137001836 2139 Akron Elementary School   Regular School No 1.0 KG 05 2016   grade_2                         35.0 29.0                       64.0                         35 29                 64
1297680 1297680 IN     school 1811370 4445   Tippecanoe Valley School Corp 181137001836 2139 Akron Elementary School   Regular School No Elementary KG 05 2017   grade_2                         27.0 28.0                       55.0                         27 28                 55
1756277 1756277 IN     school 1811370 4445   Tippecanoe Valley School Corp 181137001836 2139 Akron Elementary School   Regular School No Elementary KG 05 2019   grade_2                         32.0 28.0                       60.0                         32 28                 60
1792038 1792038 IN     school 1811370 4445   Tippecanoe Valley School Corp 181137001836 2139 Akron Elementary School   Regular School No Elementary KG 05 2018   grade_2                         30.0 31.0                       61.0                         30 31                 61
1911733 1911733 IN     school 1811370 4445   Tippecanoe Valley School Corp 181137001836 2139 Akron Elementary School   Regular School No Elementary KG 05 2020   grade_2                         37.0 34.0                       71.0                         37 34                 71
1923701 1923701 IN     school 1811370 4445   Tippecanoe Valley School Corp 181137001836 2139 Akron Elementary School   Regular School No Elementary KG 05 2021   grade_2                         30.0 31.0                       61.0                         30 31                 61
1161207 1161207 IN     school 1802660 1875   Delaware Community School Corp 180266000318 1520 Albany Elementary School   Regular School No 1.0 KG 05 2015   grade_2                         21.0 23.0                       44.0                         21 23                 44
1282609 1282609 IN     school 1802660 1875   Delaware Community School Corp 180266000318 1520 Albany Elementary School   Regular School No 1.0 KG 06 2016   grade_2                         20.0 30.0                       50.0                         20 30                 50
1294646 1294646 IN     school 1802660 1875   Delaware Community School Corp 180266000318 1520 Albany Elementary School   Regular School No Elementary KG 05 2017   grade_2                         21.0 24.0                       45.0                         21 24                 45
1753267 1753267 IN     school 1802660 1875   Delaware Community School Corp 180266000318 1520 Albany Elementary School   Regular School No Elementary KG 05 2019   grade_2                         35.0 15.0                       50.0                         35 15                 50
1789006 1789006 IN     school 1802660 1875   Delaware Community School Corp 180266000318 1520 Albany Elementary School   Regular School No Elementary KG 05 2018   grade_2                         35.0 24.0                       59.0                         35 24                 59
1908698 1908698 IN     school 1802660 1875   Delaware Community School Corp 180266000318 1520 Albany Elementary School   Regular School No Elementary KG 05 2020   grade_2                         17.0 22.0                       39.0                         17 22                 39
1920671 1920671 IN     school 1802660 1875   Delaware Community School Corp 180266000318 1520 Albany Elementary School   Regular School No Elementary KG 05 2021   grade_2                         19.0 26.0                       45.0                         19 26                 45
1167553 1167553 IN     school 1801710 6055   Central Noble Com School Corp 180171000228 6454 Albion Elementary School   Regular School No 1.0 KG 05 2015   grade_2                         23.0 23.0                       46.0                         23 23                 46
1288951 1288951 IN     school 1801710 6055   Central Noble Com School Corp 180171000228 6454 Albion Elementary School   Regular School No 1.0 KG 05 2016   grade_2                         21.0 19.0                       40.0                         21 19                 40
1300980 1300980 IN     school 1801710 6055   Central Noble Com School Corp 180171000228 6454 Albion Elementary School   Regular School No Elementary KG 05 2017   grade_2                         26.0 23.0                       49.0                         26 23                 49
1164699 1164699 IN     school 1802910 4680   Lake Station Community Schools 180291000376 3973 Alexander Hamilton Elementary Sch   Regular School No 1.0 01 06 2015   grade_2                         15.0 33.0                       48.0                         15 33                 48
1286089 1286089 IN     school 1802910 4680   Lake Station Community Schools 180291000376 3973 Alexander Hamilton Elementary Sch   Regular School No 1.0 01 06 2016   grade_2                         30.0 16.0                       46.0                         30 16                 46
1298132 1298132 IN     school 1802910 4680   Lake Station Community Schools 180291000376 3973 Alexander Hamilton Elementary Sch   Regular School No Elementary 01 06 2017   grade_2                         26.0 16.0                       42.0                         26 16                 42
1756718 1756718 IN     school 1802910 4680   Lake Station Community Schools 180291000376 3973 Alexander Hamilton Elementary Sch   Regular School No Elementary KG 05 2019   grade_2                         19.0 10.0                       29.0                         19 10                 29
1792485 1792485 IN     school 1802910 4680   Lake Station Community Schools 180291000376 3973 Alexander Hamilton Elementary Sch   Regular School No Elementary KG 05 2018   grade_2                         22.0 15.0                       37.0                         22 15                 37
1912158 1912158 IN     school 1802910 4680   Lake Station Community Schools 180291000376 3973 Alexander Hamilton Elementary Sch   Regular School No Elementary KG 05 2020   grade_2                         18.0 19.0                       37.0                         18 19                 37
1924127 1924127 IN     school 1802910 4680   Lake Station Community Schools 180291000376 3973 Alexander Hamilton Elementary Sch   Regular School No Elementary KG 05 2021   grade_2                         28.0 17.0                       45.0                         28 17                 45
1924835 1924835 IN     school 1800120 5265   Alexandria Community School Corp 180012000010 5065 Alexandria Monroe Elementary Schoo   Regular School No Elementary PK 06 2021   grade_2                         55.0 43.0                       98.0                         55 43                 98
1165533 1165533 IN     school 1800120 5265   Alexandria Com School Corp 180012000009 5069 Alexandria-Monroe Elementary   Regular School No 1.0 PK 03 2015   grade_2                         52.0 47.0                       99.0                         52 47                 99
1286929 1286929 IN     school 1800120 5265   Alexandria Community School Corp 180012000009 5069 Alexandria-Monroe Elementary   Regular School No 1.0 PK 02 2016   grade_2                         57.0 49.0                       106.0                         57 49                 106
1298964 1298964 IN     school 1800120 5265   Alexandria Community School Corp 180012000009 5069 Alexandria-Monroe Elementary   Regular School No Elementary PK 02 2017   grade_2                         63.0 64.0                       127.0                         63 64                 127

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