enrollments

Data source: Big Local News · About: Big Local

7,343 rows where grade = "grade_4" and state = "IN" sorted by school

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_4 · 7,343 ✖
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
1171010 1171010 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_4                         30.0 26.0                       56.0                         30 26                 56
1292387 1292387 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_4                         33.0 24.0                       57.0                         33 24                 57
1304420 1304420 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_4                         24.0 36.0                       60.0                         24 36                 60
1763031 1763031 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_4                         36.0 33.0                       69.0                         36 33                 69
1798761 1798761 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_4                         34.0 38.0                       72.0                         34 38                 72
1918500 1918500 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_4                         46.0 38.0                       84.0                         46 38                 84
1930495 1930495 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_4                         50.0 47.0                       97.0                         50 47                 97
1918906 1918906 IN     school 1800172 9970   ACE Preparatory Academy 180017202604 1111 ACE Preparatory Academy   Regular School Yes Elementary KG 04 2020   grade_4                         9.0 5.0                       14.0                         9 5                 14
1930904 1930904 IN     school 1800172 9970   ACE Preparatory Academy 180017202604 1111 ACE Preparatory Academy   Regular School Yes Elementary KG 05 2021   grade_4                         8.0 9.0                       17.0                         8 9                 17
1159518 1159518 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_4                         52.0 54.0                       106.0                         52 54                 106
1280908 1280908 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_4                         53.0 45.0                       98.0                         53 45                 98
1292970 1292970 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2017   grade_4                         60.0 47.0                       107.0                         60 47                 107
1751602 1751602 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2019   grade_4                         56.0 45.0                       101.0                         56 45                 101
1787343 1787343 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2018   grade_4                         41.0 52.0                       93.0                         41 52                 93
1907043 1907043 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2020   grade_4                         56.0 44.0                       100.0                         56 44                 100
1919009 1919009 IN     school 1800030 125   MSD Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No Elementary KG 05 2021   grade_4                         52.0 39.0                       91.0                         52 39                 91
1164963 1164963 IN     school 1804320 4710   School City of Hammond 180432000730 4463 Abraham Lincoln Elem Sch   Regular School No 1.0 PK 05 2015   grade_4                         41.0 48.0                       89.0                         41 48                 89
1165872 1165872 IN     school 1808820 5340   Perry Township Schools 180882001455 5337 Abraham Lincoln Elem Sch   Regular School No 1.0 KG 05 2015   grade_4                         62.0 51.0                       113.0                         62 51                 113
1164662 1164662 IN     school 1802880 4670   School City of East Chicago 180288000362 3945 Abraham Lincoln Elementary Sch   Regular School No 1.0 PK 05 2015   grade_4                         32.0 19.0                       51.0                         32 19                 51
1286051 1286051 IN     school 1802880 4670   School City of East Chicago 180288000362 3945 Abraham Lincoln Elementary School   Regular School No 1.0 PK 06 2016   grade_4                         19.0 15.0                       34.0                         19 15                 34
1286358 1286358 IN     school 1804320 4710   School City of Hammond 180432000730 4463 Abraham Lincoln Elementary School   Regular School No 1.0 PK 05 2016   grade_4                         49.0 46.0                       95.0                         49 46                 95
1287270 1287270 IN     school 1808820 5340   Perry Township Schools 180882001455 5337 Abraham Lincoln Elementary School   Regular School No 1.0 PK 05 2016   grade_4                         72.0 56.0                       128.0                         72 56                 128
1298097 1298097 IN     school 1802880 4670   School City of East Chicago 180288000362 3945 Abraham Lincoln Elementary School   Regular School No Elementary PK 06 2017   grade_4                         22.0 22.0                       44.0                         22 22                 44
1298398 1298398 IN     school 1804320 4710   School City of Hammond 180432000730 4463 Abraham Lincoln Elementary School   Regular School No Elementary PK 05 2017   grade_4                         50.0 53.0                       103.0                         50 53                 103
1299309 1299309 IN     school 1808820 5340   Perry Township Schools 180882001455 5337 Abraham Lincoln Elementary School   Regular School No Elementary PK 05 2017   grade_4                         73.0 59.0                       132.0                         73 59                 132
1756685 1756685 IN     school 1802880 4670   School City of East Chicago 180288000362 3945 Abraham Lincoln Elementary School   Regular School No Elementary KG 06 2019   grade_4                         28.0 15.0                       43.0                         28 15                 43
1756927 1756927 IN     school 1804320 4710   School City of Hammond 180432000730 4463 Abraham Lincoln Elementary School   Regular School No Elementary PK 05 2019   grade_4                         56.0 51.0                       107.0                         56 51                 107
1757850 1757850 IN     school 1808820 5340   Perry Township Schools 180882001455 5337 Abraham Lincoln Elementary School   Regular School No Elementary PK 05 2019   grade_4                         77.0 75.0                       152.0                         77 75                 152
1792449 1792449 IN     school 1802880 4670   School City of East Chicago 180288000362 3945 Abraham Lincoln Elementary School   Regular School No Elementary KG 07 2018   grade_4                         19.0 26.0                       45.0                         19 26                 45
1792719 1792719 IN     school 1804320 4710   School City of Hammond 180432000730 4463 Abraham Lincoln Elementary School   Regular School No Elementary PK 05 2018   grade_4                         58.0 42.0                       100.0                         58 42                 100
1793637 1793637 IN     school 1808820 5340   Perry Township Schools 180882001455 5337 Abraham Lincoln Elementary School   Regular School No Elementary PK 05 2018   grade_4                         80.0 66.0                       146.0                         80 66                 146
1912125 1912125 IN     school 1802880 4670   School City of East Chicago 180288000362 3945 Abraham Lincoln Elementary School   Regular School No Elementary KG 06 2020   grade_4                         31.0 23.0                       54.0                         31 23                 54
1912361 1912361 IN     school 1804320 4710   School City of Hammond 180432000730 4463 Abraham Lincoln Elementary School   Regular School No Elementary PK 05 2020   grade_4                         42.0 50.0                       92.0                         42 50                 92
1913269 1913269 IN     school 1808820 5340   Perry Township Schools 180882001455 5337 Abraham Lincoln Elementary School   Regular School No Elementary PK 05 2020   grade_4                         83.0 75.0                       158.0                         83 75                 158
1924094 1924094 IN     school 1802880 4670   School City of East Chicago 180288000362 3945 Abraham Lincoln Elementary School   Regular School No Elementary KG 06 2021   grade_4                         25.0 20.0                       45.0                         25 20                 45
1924310 1924310 IN     school 1804320 4710   School City of Hammond 180432000730 4463 Abraham Lincoln Elementary School   Regular School No Elementary PK 05 2021   grade_4                         38.0 47.0                       85.0                         38 47                 85
1925178 1925178 IN     school 1808820 5340   Perry Township Schools 180882001455 5337 Abraham Lincoln Elementary School   Regular School No Elementary PK 05 2021   grade_4                         57.0 80.0                       137.0                         57 80                 137
1169731 1169731 IN     school 1803450 7995   Evansville Vanderburgh Sch Corp 180345002462 8270 Academy for Innovative Studies   Regular School No 4.0 KG 12 2015   grade_4                         13.0 1.0                       14.0                         13 1                 14
1291121 1291121 IN     school 1803450 7995   Evansville Vanderburgh Sch Corp 180345002462 8270 Academy for Innovative Studies   Regular School No 4.0 01 12 2016   grade_4                         6.0 0.0                       6.0                         6 0                 6
1303150 1303150 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002462 8270 Academy for Innovative Studies   Regular School No Other KG 12 2017   grade_4                         2.0 0.0                       2.0                         2 0                 2
1761661 1761661 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002462 8270 Academy for Innovative Studies   Regular School No Other 01 12 2019   grade_4                         7.0 0.0                       7.0                         7 0                 7
1797466 1797466 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002462 8270 Academy for Innovative Studies   Regular School No Other 01 12 2018   grade_4                         7.0 0.0                       7.0                         7 0                 7
1917067 1917067 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002462 8270 Academy for Innovative Studies   Regular School No Other 01 12 2020   grade_4                         13.0 0.0                       13.0                         13 0                 13
1928997 1928997 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002462 8270 Academy for Innovative Studies   Regular School No Other 02 12 2021   grade_4                         9.0 2.0                       11.0                         9 2                 11
1299128 1299128 IN     school 1803750 5310   Franklin Township Com Sch Corp 180375000595 5201 Acton Elementary School   Regular School No Elementary KG 05 2017   grade_4                         28.0 40.0                       68.0                         28 40                 68
1757666 1757666 IN     school 1803750 5310   Franklin Township Com Sch Corp 180375000595 5201 Acton Elementary School   Regular School No Elementary KG 05 2019   grade_4                         49.0 34.0                       83.0                         49 34                 83
1793456 1793456 IN     school 1803750 5310   Franklin Township Com Sch Corp 180375000595 5201 Acton Elementary School   Regular School No Elementary KG 05 2018   grade_4                         48.0 27.0                       75.0                         48 27                 75
1913083 1913083 IN     school 1803750 5310   Franklin Township Com Sch Corp 180375000595 5201 Acton Elementary School   Regular School No Elementary KG 05 2020   grade_4                         35.0 34.0                       69.0                         35 34                 69
1159469 1159469 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary Sch   Regular School No 1.0 KG 05 2015   grade_4                         52.0 35.0                       87.0                         52 35                 87
1280859 1280859 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No 1.0 KG 05 2016   grade_4                         50.0 51.0                       101.0                         50 51                 101
1292921 1292921 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2017   grade_4                         51.0 52.0                       103.0                         51 52                 103
1751553 1751553 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2019   grade_4                         54.0 52.0                       106.0                         54 52                 106
1787294 1787294 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2018   grade_4                         63.0 38.0                       101.0                         63 38                 101
1906994 1906994 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2020   grade_4                         52.0 44.0                       96.0                         52 44                 96
1918960 1918960 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2021   grade_4                         58.0 41.0                       99.0                         58 41                 99
1159732 1159732 IN     school 1803630 235   Fort Wayne Community Schools 180363000511 141 Adams Elementary School   Regular School No 1.0 PK 05 2015   grade_4                         22.0 20.0                       42.0                         22 20                 42
1281124 1281124 IN     school 1803630 235   Fort Wayne Community Schools 180363000511 141 Adams Elementary School   Regular School No 1.0 PK 05 2016   grade_4                         21.0 12.0                       33.0                         21 12                 33
1293185 1293185 IN     school 1803630 235   Fort Wayne Community Schools 180363000511 141 Adams Elementary School   Regular School No Elementary PK 05 2017   grade_4                         16.0 10.0                       26.0                         16 10                 26
1751810 1751810 IN     school 1803630 235   Fort Wayne Community Schools 180363000511 141 Adams Elementary School   Regular School No Elementary PK 05 2019   grade_4                         25.0 34.0                       59.0                         25 34                 59
1787554 1787554 IN     school 1803630 235   Fort Wayne Community Schools 180363000511 141 Adams Elementary School   Regular School No Elementary PK 05 2018   grade_4                         29.0 15.0                       44.0                         29 15                 44
1907250 1907250 IN     school 1803630 235   Fort Wayne Community Schools 180363000511 141 Adams Elementary School   Regular School No Elementary PK 05 2020   grade_4                         20.0 18.0                       38.0                         20 18                 38
1919216 1919216 IN     school 1803630 235   Fort Wayne Community Schools 180363000511 141 Adams Elementary School   Regular School No Elementary PK 05 2021   grade_4                         25.0 27.0                       52.0                         25 27                 52
1170000 1170000 IN     school 1812090 8030   Vigo County School Corp 181209002172 8510 Adelaide De Vaney Elem Sch   Regular School No 1.0 KG 05 2015   grade_4                         32.0 39.0                       71.0                         32 39                 71
1291390 1291390 IN     school 1812090 8030   Vigo County School Corp 181209002172 8510 Adelaide De Vaney Elementary Sch   Regular School No 1.0 KG 05 2016   grade_4                         39.0 34.0                       73.0                         39 34                 73
1303418 1303418 IN     school 1812090 8030   Vigo County School Corp 181209002172 8510 Adelaide De Vaney Elementary Sch   Regular School No Elementary KG 05 2017   grade_4                         34.0 43.0                       77.0                         34 43                 77
1761944 1761944 IN     school 1812090 8030   Vigo County School Corp 181209002172 8510 Adelaide De Vaney Elementary Sch   Regular School No Elementary PK 05 2019   grade_4                         34.0 30.0                       64.0                         34 30                 64
1797733 1797733 IN     school 1812090 8030   Vigo County School Corp 181209002172 8510 Adelaide De Vaney Elementary Sch   Regular School No Elementary PK 05 2018   grade_4                         29.0 53.0                       82.0                         29 53                 82
1917358 1917358 IN     school 1812090 8030   Vigo County School Corp 181209002172 8510 Adelaide De Vaney Elementary Sch   Regular School No Elementary PK 05 2020   grade_4                         29.0 36.0                       65.0                         29 36                 65
1929297 1929297 IN     school 1812090 8030   Vigo County School Corp 181209002172 8510 Adelaide De Vaney Elementary Sch   Regular School No Elementary KG 05 2021   grade_4                         28.0 40.0                       68.0                         28 40                 68
1164229 1164229 IN     school 1811370 4445   Tippecanoe Valley School Corp 181137001836 2139 Akron Elementary School   Regular School No 1.0 KG 05 2015   grade_4                         33.0 33.0                       66.0                         33 33                 66
1285636 1285636 IN     school 1811370 4445   Tippecanoe Valley School Corp 181137001836 2139 Akron Elementary School   Regular School No 1.0 KG 05 2016   grade_4                         27.0 24.0                       51.0                         27 24                 51
1297682 1297682 IN     school 1811370 4445   Tippecanoe Valley School Corp 181137001836 2139 Akron Elementary School   Regular School No Elementary KG 05 2017   grade_4                         31.0 27.0                       58.0                         31 27                 58
1756279 1756279 IN     school 1811370 4445   Tippecanoe Valley School Corp 181137001836 2139 Akron Elementary School   Regular School No Elementary KG 05 2019   grade_4                         25.0 30.0                       55.0                         25 30                 55
1792040 1792040 IN     school 1811370 4445   Tippecanoe Valley School Corp 181137001836 2139 Akron Elementary School   Regular School No Elementary KG 05 2018   grade_4                         37.0 33.0                       70.0                         37 33                 70
1911735 1911735 IN     school 1811370 4445   Tippecanoe Valley School Corp 181137001836 2139 Akron Elementary School   Regular School No Elementary KG 05 2020   grade_4                         33.0 37.0                       70.0                         33 37                 70
1923703 1923703 IN     school 1811370 4445   Tippecanoe Valley School Corp 181137001836 2139 Akron Elementary School   Regular School No Elementary KG 05 2021   grade_4                         34.0 30.0                       64.0                         34 30                 64
1161209 1161209 IN     school 1802660 1875   Delaware Community School Corp 180266000318 1520 Albany Elementary School   Regular School No 1.0 KG 05 2015   grade_4                         26.0 29.0                       55.0                         26 29                 55
1282611 1282611 IN     school 1802660 1875   Delaware Community School Corp 180266000318 1520 Albany Elementary School   Regular School No 1.0 KG 06 2016   grade_4                         20.0 25.0                       45.0                         20 25                 45
1294648 1294648 IN     school 1802660 1875   Delaware Community School Corp 180266000318 1520 Albany Elementary School   Regular School No Elementary KG 05 2017   grade_4                         27.0 27.0                       54.0                         27 27                 54
1753269 1753269 IN     school 1802660 1875   Delaware Community School Corp 180266000318 1520 Albany Elementary School   Regular School No Elementary KG 05 2019   grade_4                         24.0 26.0                       50.0                         24 26                 50
1789008 1789008 IN     school 1802660 1875   Delaware Community School Corp 180266000318 1520 Albany Elementary School   Regular School No Elementary KG 05 2018   grade_4                         21.0 28.0                       49.0                         21 28                 49
1908700 1908700 IN     school 1802660 1875   Delaware Community School Corp 180266000318 1520 Albany Elementary School   Regular School No Elementary KG 05 2020   grade_4                         32.0 23.0                       55.0                         32 23                 55
1920673 1920673 IN     school 1802660 1875   Delaware Community School Corp 180266000318 1520 Albany Elementary School   Regular School No Elementary KG 05 2021   grade_4                         33.0 14.0                       47.0                         33 14                 47
1167555 1167555 IN     school 1801710 6055   Central Noble Com School Corp 180171000228 6454 Albion Elementary School   Regular School No 1.0 KG 05 2015   grade_4                         15.0 27.0                       42.0                         15 27                 42
1288953 1288953 IN     school 1801710 6055   Central Noble Com School Corp 180171000228 6454 Albion Elementary School   Regular School No 1.0 KG 05 2016   grade_4                         25.0 25.0                       50.0                         25 25                 50
1300982 1300982 IN     school 1801710 6055   Central Noble Com School Corp 180171000228 6454 Albion Elementary School   Regular School No Elementary KG 05 2017   grade_4                         28.0 23.0                       51.0                         28 23                 51
1164701 1164701 IN     school 1802910 4680   Lake Station Community Schools 180291000376 3973 Alexander Hamilton Elementary Sch   Regular School No 1.0 01 06 2015   grade_4                         24.0 20.0                       44.0                         24 20                 44
1286091 1286091 IN     school 1802910 4680   Lake Station Community Schools 180291000376 3973 Alexander Hamilton Elementary Sch   Regular School No 1.0 01 06 2016   grade_4                         28.0 22.0                       50.0                         28 22                 50
1298134 1298134 IN     school 1802910 4680   Lake Station Community Schools 180291000376 3973 Alexander Hamilton Elementary Sch   Regular School No Elementary 01 06 2017   grade_4                         20.0 20.0                       40.0                         20 20                 40
1756720 1756720 IN     school 1802910 4680   Lake Station Community Schools 180291000376 3973 Alexander Hamilton Elementary Sch   Regular School No Elementary KG 05 2019   grade_4                         23.0 14.0                       37.0                         23 14                 37
1792487 1792487 IN     school 1802910 4680   Lake Station Community Schools 180291000376 3973 Alexander Hamilton Elementary Sch   Regular School No Elementary KG 05 2018   grade_4                         32.0 25.0                       57.0                         32 25                 57
1912160 1912160 IN     school 1802910 4680   Lake Station Community Schools 180291000376 3973 Alexander Hamilton Elementary Sch   Regular School No Elementary KG 05 2020   grade_4                         30.0 18.0                       48.0                         30 18                 48
1924129 1924129 IN     school 1802910 4680   Lake Station Community Schools 180291000376 3973 Alexander Hamilton Elementary Sch   Regular School No Elementary KG 05 2021   grade_4                         16.0 8.0                       24.0                         16 8                 24
1924837 1924837 IN     school 1800120 5265   Alexandria Community School Corp 180012000010 5065 Alexandria Monroe Elementary Schoo   Regular School No Elementary PK 06 2021   grade_4                         61.0 54.0                       115.0                         61 54                 115
1165528 1165528 IN     school 1800120 5265   Alexandria Com School Corp 180012000010 5065 Alexandria-Monroe Intermediate   Regular School No 1.0 03 06 2015   grade_4                         47.0 57.0                       104.0                         47 57                 104
1286924 1286924 IN     school 1800120 5265   Alexandria Community School Corp 180012000010 5065 Alexandria-Monroe Intermediate   Regular School No 1.0 03 06 2016   grade_4                         65.0 43.0                       108.0                         65 43                 108
1298959 1298959 IN     school 1800120 5265   Alexandria Community School Corp 180012000010 5065 Alexandria-Monroe Intermediate   Regular School No Elementary 03 06 2017   grade_4                         54.0 51.0                       105.0                         54 51                 105
1757490 1757490 IN     school 1800120 5265   Alexandria Community School Corp 180012000010 5065 Alexandria-Monroe Intermediate   Regular School No Elementary 03 06 2019   grade_4                         65.0 67.0                       132.0                         65 67                 132
1793281 1793281 IN     school 1800120 5265   Alexandria Community School Corp 180012000010 5065 Alexandria-Monroe Intermediate   Regular School No Elementary 03 06 2018   grade_4                         63.0 42.0                       105.0                         63 42                 105
1912913 1912913 IN     school 1800120 5265   Alexandria Community School Corp 180012000010 5065 Alexandria-Monroe Intermediate   Regular School No Elementary 03 06 2020   grade_4                         74.0 57.0                       131.0                         74 57                 131

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