enrollments

Data source: Big Local News · About: Big Local

7,359 rows where grade = "grade_1" and state = "IN" sorted by school_state_id

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_1 · 7,259 ✖
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
1293065 1293065 IN     school 1808250 225   Northwest Allen County Schools 180825000016 94 Oak View Elementary School   Regular School No Elementary KG 05 2017   grade_1                         44.0 33.0                       77.0                         44 33                 77
1751697 1751697 IN     school 1808250 225   Northwest Allen County Schools 180825000016 94 Oak View Elementary School   Regular School No Elementary KG 05 2019   grade_1                         48.0 45.0                       93.0                         48 45                 93
1787438 1787438 IN     school 1808250 225   Northwest Allen County Schools 180825000016 94 Oak View Elementary School   Regular School No Elementary KG 05 2018   grade_1                         46.0 51.0                       97.0                         46 51                 97
1907138 1907138 IN     school 1808250 225   Northwest Allen County Schools 180825000016 94 Oak View Elementary School   Regular School No Elementary KG 05 2020   grade_1                         36.0 41.0                       77.0                         36 41                 77
1919104 1919104 IN     school 1808250 225   Northwest Allen County Schools 180825000016 94 Oak View Elementary School   Regular School No Elementary KG 05 2021   grade_1                         48.0 33.0                       81.0                         48 33                 81
1159619 1159619 IN     school 1808250 225   Northwest Allen County Schools 180825002166 95 Cedar Canyon Elementary Sch   Regular School No 1.0 PK 05 2015   grade_1                         41.0 36.0                       77.0                         41 36                 77
1281009 1281009 IN     school 1808250 225   Northwest Allen County Schools 180825002166 95 Cedar Canyon Elementary School   Regular School No 1.0 PK 05 2016   grade_1                         41.0 36.0                       77.0                         41 36                 77
1293072 1293072 IN     school 1808250 225   Northwest Allen County Schools 180825002166 95 Cedar Canyon Elementary School   Regular School No Elementary PK 05 2017   grade_1                         37.0 35.0                       72.0                         37 35                 72
1751704 1751704 IN     school 1808250 225   Northwest Allen County Schools 180825002166 95 Cedar Canyon Elementary School   Regular School No Elementary PK 05 2019   grade_1                         40.0 47.0                       87.0                         40 47                 87
1787445 1787445 IN     school 1808250 225   Northwest Allen County Schools 180825002166 95 Cedar Canyon Elementary School   Regular School No Elementary PK 05 2018   grade_1                         35.0 50.0                       85.0                         35 50                 85
1907145 1907145 IN     school 1808250 225   Northwest Allen County Schools 180825002166 95 Cedar Canyon Elementary School   Regular School No Elementary PK 05 2020   grade_1                         53.0 33.0                       86.0                         53 33                 86
1919111 1919111 IN     school 1808250 225   Northwest Allen County Schools 180825002166 95 Cedar Canyon Elementary School   Regular School No Elementary PK 05 2021   grade_1                         60.0 58.0                       118.0                         60 58                 118
1159627 1159627 IN     school 1808250 225   Northwest Allen County Schools 180825002457 96 Eel River Elementary School   Regular School No 1.0 KG 05 2015   grade_1                         47.0 45.0                       92.0                         47 45                 92
1281017 1281017 IN     school 1808250 225   Northwest Allen County Schools 180825002457 96 Eel River Elementary School   Regular School No 1.0 KG 05 2016   grade_1                         47.0 32.0                       79.0                         47 32                 79
1293080 1293080 IN     school 1808250 225   Northwest Allen County Schools 180825002457 96 Eel River Elementary School   Regular School No Elementary KG 05 2017   grade_1                         37.0 35.0                       72.0                         37 35                 72
1751712 1751712 IN     school 1808250 225   Northwest Allen County Schools 180825002457 96 Eel River Elementary School   Regular School No Elementary KG 05 2019   grade_1                         58.0 41.0                       99.0                         58 41                 99
1787453 1787453 IN     school 1808250 225   Northwest Allen County Schools 180825002457 96 Eel River Elementary School   Regular School No Elementary KG 05 2018   grade_1                         57.0 46.0                       103.0                         57 46                 103
1907153 1907153 IN     school 1808250 225   Northwest Allen County Schools 180825002457 96 Eel River Elementary School   Regular School No Elementary KG 05 2020   grade_1                         48.0 69.0                       117.0                         48 69                 117
1919119 1919119 IN     school 1808250 225   Northwest Allen County Schools 180825002457 96 Eel River Elementary School   Regular School No Elementary KG 05 2021   grade_1                         50.0 40.0                       90.0                         50 40                 90
1159666 1159666 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No 1.0 01 08 2015   grade_1                         37.0 39.0                       76.0                         37 39                 76
1281058 1281058 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No 1.0 01 08 2016   grade_1                         35.0 33.0                       68.0                         35 33                 68
1293119 1293119 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No Elementary 01 08 2017   grade_1                         41.0 29.0                       70.0                         41 29                 70
1751744 1751744 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No Elementary 01 08 2019   grade_1                         40.0 31.0                       71.0                         40 31                 71
1787488 1787488 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No Elementary 01 08 2018   grade_1                         30.0 31.0                       61.0                         30 31                 61
1907184 1907184 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No Elementary 01 08 2020   grade_1                         37.0 34.0                       71.0                         37 34                 71
1919150 1919150 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No Elementary 01 08 2021   grade_1                         31.0 35.0                       66.0                         31 35                 66
1159707 1159707 IN     school 1803630 235   Fort Wayne Community Schools 180363000570 134 Weisser Park Elem Sch   Regular School No 1.0 01 05 2015   grade_1                         57.0 62.0                       119.0                         57 62                 119
1281099 1281099 IN     school 1803630 235   Fort Wayne Community Schools 180363000570 134 Weisser Park Elementary School   Regular School No 1.0 01 05 2016   grade_1                         58.0 66.0                       124.0                         58 66                 124
1293160 1293160 IN     school 1803630 235   Fort Wayne Community Schools 180363000570 134 Weisser Park Elementary School   Regular School No Elementary 01 05 2017   grade_1                         62.0 55.0                       117.0                         62 55                 117
1751785 1751785 IN     school 1803630 235   Fort Wayne Community Schools 180363000570 134 Weisser Park Elementary School   Regular School No Elementary 01 05 2019   grade_1                         59.0 59.0                       118.0                         59 59                 118
1787529 1787529 IN     school 1803630 235   Fort Wayne Community Schools 180363000570 134 Weisser Park Elementary School   Regular School No Elementary 01 05 2018   grade_1                         67.0 56.0                       123.0                         67 56                 123
1907225 1907225 IN     school 1803630 235   Fort Wayne Community Schools 180363000570 134 Weisser Park Elementary School   Regular School No Elementary 01 05 2020   grade_1                         63.0 54.0                       117.0                         63 54                 117
1919191 1919191 IN     school 1803630 235   Fort Wayne Community Schools 180363000570 134 Weisser Park Elementary School   Regular School No Elementary 01 05 2021   grade_1                         51.0 64.0                       115.0                         51 64                 115
1159713 1159713 IN     school 1803630 235   Fort Wayne Community Schools 180363002197 136 Fairfield Elementary School   Regular School No 1.0 PK 05 2015   grade_1                         45.0 55.0                       100.0                         45 55                 100
1281105 1281105 IN     school 1803630 235   Fort Wayne Community Schools 180363002197 136 Fairfield Elementary School   Regular School No 1.0 PK 05 2016   grade_1                         37.0 46.0                       83.0                         37 46                 83
1293166 1293166 IN     school 1803630 235   Fort Wayne Community Schools 180363002197 136 Fairfield Elementary School   Regular School No Elementary PK 05 2017   grade_1                         27.0 38.0                       65.0                         27 38                 65
1751791 1751791 IN     school 1803630 235   Fort Wayne Community Schools 180363002197 136 Fairfield Elementary School   Regular School No Elementary PK 05 2019   grade_1                         32.0 33.0                       65.0                         32 33                 65
1787535 1787535 IN     school 1803630 235   Fort Wayne Community Schools 180363002197 136 Fairfield Elementary School   Regular School No Elementary PK 05 2018   grade_1                         42.0 51.0                       93.0                         42 51                 93
1907231 1907231 IN     school 1803630 235   Fort Wayne Community Schools 180363002197 136 Fairfield Elementary School   Regular School No Elementary PK 05 2020   grade_1                         37.0 40.0                       77.0                         37 40                 77
1919197 1919197 IN     school 1803630 235   Fort Wayne Community Schools 180363002197 136 Fairfield Elementary School   Regular School No Elementary PK 05 2021   grade_1                         44.0 35.0                       79.0                         44 35                 79
1159721 1159721 IN     school 1803630 235   Fort Wayne Community Schools 180363000547 137 Merle J Abbett Elementary Sch   Regular School No 1.0 PK 05 2015   grade_1                         39.0 41.0                       80.0                         39 41                 80
1281113 1281113 IN     school 1803630 235   Fort Wayne Community Schools 180363000547 137 Merle J Abbett Elementary School   Regular School No 1.0 PK 05 2016   grade_1                         33.0 39.0                       72.0                         33 39                 72
1293174 1293174 IN     school 1803630 235   Fort Wayne Community Schools 180363000547 137 Merle J Abbett Elementary School   Regular School No Elementary PK 05 2017   grade_1                         37.0 33.0                       70.0                         37 33                 70
1751799 1751799 IN     school 1803630 235   Fort Wayne Community Schools 180363000547 137 Merle J Abbett Elementary School   Regular School No Elementary PK 05 2019   grade_1                         33.0 34.0                       67.0                         33 34                 67
1787543 1787543 IN     school 1803630 235   Fort Wayne Community Schools 180363000547 137 Merle J Abbett Elementary School   Regular School No Elementary PK 05 2018   grade_1                         45.0 48.0                       93.0                         45 48                 93
1907239 1907239 IN     school 1803630 235   Fort Wayne Community Schools 180363000547 137 Merle J Abbett Elementary School   Regular School No Elementary PK 05 2020   grade_1                         37.0 33.0                       70.0                         37 33                 70
1919205 1919205 IN     school 1803630 235   Fort Wayne Community Schools 180363000547 137 Merle J Abbett Elementary School   Regular School No Elementary PK 05 2021   grade_1                         41.0 51.0                       92.0                         41 51                 92
1171229 1171229 IN     school 1800121 9740   Thurgood Marshall Leadership Acad 180012102540 138 Thurgood Marshall Leadership Acad   Regular School Yes 1.0 KG 08 2015   grade_1                         18.0 12.0                       30.0                         18 12                 30
1292597 1292597 IN     school 1800121 9740   Thurgood Marshall Leadership Acad 180012102540 138 Thurgood Marshall Leadership Acad   Regular School Yes 1.0 KG 08 2016   grade_1                         10.0 12.0                       22.0                         10 12                 22
1304639 1304639 IN     school 1800121 9740   Thurgood Marshall Leadership Acad 180012102540 138 Thurgood Marshall Leadership Acad   Regular School Yes Elementary KG 08 2017   grade_1                         10.0 18.0                       28.0                         10 18                 28
1763233 1763233 IN     school 1800121 9740   Thurgood Marshall Leadership Acad 180012102540 138 Thurgood Marshall Leadership Acad   Regular School Yes Elementary KG 06 2019   grade_1                         9.0 10.0                       19.0                         9 10                 19
1798972 1798972 IN     school 1800121 9740   Thurgood Marshall Leadership Acad 180012102540 138 Thurgood Marshall Leadership Acad   Regular School Yes Elementary KG 08 2018   grade_1                         15.0 13.0                       28.0                         15 13                 28
1762725 1762725 IN     school 1800196 9060   Paramount Community Heights 180019602643 139 Paramount Community Heights   Regular School Yes Elementary KG 04 2019   grade_1                         9.0 12.0                       21.0                         9 12                 21
1918180 1918180 IN     school 1800196 9060   Paramount Community Heights 180019602643 139 Paramount Community Heights   Regular School Yes Elementary KG 05 2020   grade_1                         18.0 5.0                       23.0                         18 5                 23
1930134 1930134 IN     school 1800196 9060   Paramount Cottage Home 180019602643 139 Paramount Cottage Home   Regular School Yes Elementary KG 04 2021   grade_1                         21.0 12.0                       33.0                         21 12                 33
1159729 1159729 IN     school 1803630 235   Fort Wayne Community Schools 180363000511 141 Adams Elementary School   Regular School No 1.0 PK 05 2015   grade_1                         26.0 18.0                       44.0                         26 18                 44
1281121 1281121 IN     school 1803630 235   Fort Wayne Community Schools 180363000511 141 Adams Elementary School   Regular School No 1.0 PK 05 2016   grade_1                         22.0 29.0                       51.0                         22 29                 51
1293182 1293182 IN     school 1803630 235   Fort Wayne Community Schools 180363000511 141 Adams Elementary School   Regular School No Elementary PK 05 2017   grade_1                         19.0 21.0                       40.0                         19 21                 40
1751807 1751807 IN     school 1803630 235   Fort Wayne Community Schools 180363000511 141 Adams Elementary School   Regular School No Elementary PK 05 2019   grade_1                         20.0 22.0                       42.0                         20 22                 42
1787551 1787551 IN     school 1803630 235   Fort Wayne Community Schools 180363000511 141 Adams Elementary School   Regular School No Elementary PK 05 2018   grade_1                         18.0 26.0                       44.0                         18 26                 44
1907247 1907247 IN     school 1803630 235   Fort Wayne Community Schools 180363000511 141 Adams Elementary School   Regular School No Elementary PK 05 2020   grade_1                         21.0 28.0                       49.0                         21 28                 49
1919213 1919213 IN     school 1803630 235   Fort Wayne Community Schools 180363000511 141 Adams Elementary School   Regular School No Elementary PK 05 2021   grade_1                         21.0 23.0                       44.0                         21 23                 44
1281024 1281024 IN     school 1808250 225   Northwest Allen County Schools 180825002160 145 Allen Co Youth Services Center   Alternative Education School No 4.0 01 10 2016   grade_1                         0.0 1.0                       1.0                         0 1                 1
1159737 1159737 IN     school 1803630 235   Fort Wayne Community Schools 180363000517 149 Bloomingdale Elementary Sch   Regular School No 1.0 PK 05 2015   grade_1                         31.0 23.0                       54.0                         31 23                 54
1281129 1281129 IN     school 1803630 235   Fort Wayne Community Schools 180363000517 149 Bloomingdale Elementary School   Regular School No 1.0 PK 05 2016   grade_1                         24.0 21.0                       45.0                         24 21                 45
1293190 1293190 IN     school 1803630 235   Fort Wayne Community Schools 180363000517 149 Bloomingdale Elementary School   Regular School No Elementary PK 05 2017   grade_1                         32.0 29.0                       61.0                         32 29                 61
1751815 1751815 IN     school 1803630 235   Fort Wayne Community Schools 180363000517 149 Bloomingdale Elementary School   Regular School No Elementary PK 05 2019   grade_1                         27.0 24.0                       51.0                         27 24                 51
1787559 1787559 IN     school 1803630 235   Fort Wayne Community Schools 180363000517 149 Bloomingdale Elementary School   Regular School No Elementary PK 05 2018   grade_1                         27.0 27.0                       54.0                         27 27                 54
1907255 1907255 IN     school 1803630 235   Fort Wayne Community Schools 180363000517 149 Bloomingdale Elementary School   Regular School No Elementary PK 05 2020   grade_1                         28.0 22.0                       50.0                         28 22                 50
1919221 1919221 IN     school 1803630 235   Fort Wayne Community Schools 180363000517 149 Bloomingdale Elementary School   Regular School No Elementary PK 05 2021   grade_1                         34.0 25.0                       59.0                         34 25                 59
1159748 1159748 IN     school 1803630 235   Fort Wayne Community Schools 180363000518 153 Brentwood Elementary School   Regular School No 1.0 PK 05 2015   grade_1                         53.0 37.0                       90.0                         53 37                 90
1281140 1281140 IN     school 1803630 235   Fort Wayne Community Schools 180363000518 153 Brentwood Elementary School   Regular School No 1.0 PK 05 2016   grade_1                         39.0 32.0                       71.0                         39 32                 71
1293201 1293201 IN     school 1803630 235   Fort Wayne Community Schools 180363000518 153 Brentwood Elementary School   Regular School No Elementary PK 05 2017   grade_1                         41.0 38.0                       79.0                         41 38                 79
1751826 1751826 IN     school 1803630 235   Fort Wayne Community Schools 180363000518 153 Brentwood Elementary School   Regular School No Elementary PK 05 2019   grade_1                         40.0 36.0                       76.0                         40 36                 76
1787570 1787570 IN     school 1803630 235   Fort Wayne Community Schools 180363000518 153 Brentwood Elementary School   Regular School No Elementary PK 05 2018   grade_1                         36.0 26.0                       62.0                         36 26                 62
1907266 1907266 IN     school 1803630 235   Fort Wayne Community Schools 180363000518 153 Brentwood Elementary School   Regular School No Elementary PK 05 2020   grade_1                         29.0 30.0                       59.0                         29 30                 59
1919232 1919232 IN     school 1803630 235   Fort Wayne Community Schools 180363000518 153 Brentwood Elementary School   Regular School No Elementary PK 05 2021   grade_1                         32.0 31.0                       63.0                         32 31                 63
1159756 1159756 IN     school 1803630 235   Fort Wayne Community Schools 180363000527 154 Fred H Croninger Elem Sch   Regular School No 1.0 KG 05 2015   grade_1                         54.0 50.0                       104.0                         54 50                 104
1281148 1281148 IN     school 1803630 235   Fort Wayne Community Schools 180363000527 154 Fred H Croninger Elementary School   Regular School No 1.0 KG 05 2016   grade_1                         62.0 50.0                       112.0                         62 50                 112
1293209 1293209 IN     school 1803630 235   Fort Wayne Community Schools 180363000527 154 Fred H Croninger Elementary School   Regular School No Elementary KG 05 2017   grade_1                         56.0 45.0                       101.0                         56 45                 101
1751834 1751834 IN     school 1803630 235   Fort Wayne Community Schools 180363000527 154 Fred H Croninger Elementary School   Regular School No Elementary KG 05 2019   grade_1                         65.0 39.0                       104.0                         65 39                 104
1787578 1787578 IN     school 1803630 235   Fort Wayne Community Schools 180363000527 154 Fred H Croninger Elementary School   Regular School No Elementary KG 05 2018   grade_1                         73.0 57.0                       130.0                         73 57                 130
1907274 1907274 IN     school 1803630 235   Fort Wayne Community Schools 180363000527 154 Fred H Croninger Elementary School   Regular School No Elementary KG 05 2020   grade_1                         57.0 47.0                       104.0                         57 47                 104
1919240 1919240 IN     school 1803630 235   Fort Wayne Community Schools 180363000527 154 Fred H Croninger Elementary School   Regular School No Elementary KG 05 2021   grade_1                         52.0 51.0                       103.0                         52 51                 103
1159763 1159763 IN     school 1803630 235   Fort Wayne Community Schools 180363000522 157 Forest Park Elementary School   Regular School No 1.0 PK 05 2015   grade_1                         49.0 57.0                       106.0                         49 57                 106
1281155 1281155 IN     school 1803630 235   Fort Wayne Community Schools 180363000522 157 Forest Park Elementary School   Regular School No 1.0 PK 05 2016   grade_1                         55.0 45.0                       100.0                         55 45                 100
1293216 1293216 IN     school 1803630 235   Fort Wayne Community Schools 180363000522 157 Forest Park Elementary School   Regular School No Elementary PK 05 2017   grade_1                         56.0 56.0                       112.0                         56 56                 112
1751841 1751841 IN     school 1803630 235   Fort Wayne Community Schools 180363000522 157 Forest Park Elementary School   Regular School No Elementary PK 05 2019   grade_1                         58.0 44.0                       102.0                         58 44                 102
1787585 1787585 IN     school 1803630 235   Fort Wayne Community Schools 180363000522 157 Forest Park Elementary School   Regular School No Elementary PK 05 2018   grade_1                         42.0 47.0                       89.0                         42 47                 89
1907281 1907281 IN     school 1803630 235   Fort Wayne Community Schools 180363000522 157 Forest Park Elementary School   Regular School No Elementary PK 05 2020   grade_1                         46.0 53.0                       99.0                         46 53                 99
1919247 1919247 IN     school 1803630 235   Fort Wayne Community Schools 180363000522 157 Forest Park Elementary School   Regular School No Elementary PK 05 2021   grade_1                         60.0 48.0                       108.0                         60 48                 108
1159771 1159771 IN     school 1803630 235   Fort Wayne Community Schools 180363000525 161 Franke Park Elementary School   Regular School No 1.0 PK 05 2015   grade_1                         58.0 47.0                       105.0                         58 47                 105
1281163 1281163 IN     school 1803630 235   Fort Wayne Community Schools 180363000525 161 Franke Park Elementary School   Regular School No 1.0 PK 05 2016   grade_1                         34.0 36.0                       70.0                         34 36                 70
1293224 1293224 IN     school 1803630 235   Fort Wayne Community Schools 180363000525 161 Franke Park Elementary School   Regular School No Elementary PK 05 2017   grade_1                         56.0 36.0                       92.0                         56 36                 92
1751849 1751849 IN     school 1803630 235   Fort Wayne Community Schools 180363000525 161 Franke Park Elementary School   Regular School No Elementary PK 05 2019   grade_1                         35.0 34.0                       69.0                         35 34                 69
1787593 1787593 IN     school 1803630 235   Fort Wayne Community Schools 180363000525 161 Franke Park Elementary School   Regular School No Elementary PK 05 2018   grade_1                         36.0 38.0                       74.0                         36 38                 74
1907289 1907289 IN     school 1803630 235   Fort Wayne Community Schools 180363000525 161 Franke Park Elementary School   Regular School No Elementary PK 05 2020   grade_1                         31.0 32.0                       63.0                         31 32                 63
1919255 1919255 IN     school 1803630 235   Fort Wayne Community Schools 180363000525 161 Franke Park Elementary School   Regular School No Elementary PK 05 2021   grade_1                         43.0 26.0                       69.0                         43 26                 69
1159779 1159779 IN     school 1803630 235   Fort Wayne Community Schools 180363000529 162 Glenwood Park Elementary Sch   Regular School No 1.0 KG 05 2015   grade_1                         57.0 68.0                       125.0                         57 68                 125
1281171 1281171 IN     school 1803630 235   Fort Wayne Community Schools 180363000529 162 Glenwood Park Elementary School   Regular School No 1.0 KG 05 2016   grade_1                         49.0 50.0                       99.0                         49 50                 99

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