enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_2 · 7,271 ✖
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
1293066 1293066 IN     school 1808250 225   Northwest Allen County Schools 180825000016 94 Oak View Elementary School   Regular School No Elementary KG 05 2017   grade_2                         41.0 36.0                       77.0                         41 36                 77
1751698 1751698 IN     school 1808250 225   Northwest Allen County Schools 180825000016 94 Oak View Elementary School   Regular School No Elementary KG 05 2019   grade_2                         52.0 50.0                       102.0                         52 50                 102
1787439 1787439 IN     school 1808250 225   Northwest Allen County Schools 180825000016 94 Oak View Elementary School   Regular School No Elementary KG 05 2018   grade_2                         41.0 31.0                       72.0                         41 31                 72
1907139 1907139 IN     school 1808250 225   Northwest Allen County Schools 180825000016 94 Oak View Elementary School   Regular School No Elementary KG 05 2020   grade_2                         55.0 43.0                       98.0                         55 43                 98
1919105 1919105 IN     school 1808250 225   Northwest Allen County Schools 180825000016 94 Oak View Elementary School   Regular School No Elementary KG 05 2021   grade_2                         31.0 41.0                       72.0                         31 41                 72
1159620 1159620 IN     school 1808250 225   Northwest Allen County Schools 180825002166 95 Cedar Canyon Elementary Sch   Regular School No 1.0 PK 05 2015   grade_2                         48.0 40.0                       88.0                         48 40                 88
1281010 1281010 IN     school 1808250 225   Northwest Allen County Schools 180825002166 95 Cedar Canyon Elementary School   Regular School No 1.0 PK 05 2016   grade_2                         44.0 43.0                       87.0                         44 43                 87
1293073 1293073 IN     school 1808250 225   Northwest Allen County Schools 180825002166 95 Cedar Canyon Elementary School   Regular School No Elementary PK 05 2017   grade_2                         41.0 41.0                       82.0                         41 41                 82
1751705 1751705 IN     school 1808250 225   Northwest Allen County Schools 180825002166 95 Cedar Canyon Elementary School   Regular School No Elementary PK 05 2019   grade_2                         41.0 51.0                       92.0                         41 51                 92
1787446 1787446 IN     school 1808250 225   Northwest Allen County Schools 180825002166 95 Cedar Canyon Elementary School   Regular School No Elementary PK 05 2018   grade_2                         41.0 38.0                       79.0                         41 38                 79
1907146 1907146 IN     school 1808250 225   Northwest Allen County Schools 180825002166 95 Cedar Canyon Elementary School   Regular School No Elementary PK 05 2020   grade_2                         46.0 54.0                       100.0                         46 54                 100
1919112 1919112 IN     school 1808250 225   Northwest Allen County Schools 180825002166 95 Cedar Canyon Elementary School   Regular School No Elementary PK 05 2021   grade_2                         57.0 37.0                       94.0                         57 37                 94
1159628 1159628 IN     school 1808250 225   Northwest Allen County Schools 180825002457 96 Eel River Elementary School   Regular School No 1.0 KG 05 2015   grade_2                         48.0 41.0                       89.0                         48 41                 89
1281018 1281018 IN     school 1808250 225   Northwest Allen County Schools 180825002457 96 Eel River Elementary School   Regular School No 1.0 KG 05 2016   grade_2                         47.0 47.0                       94.0                         47 47                 94
1293081 1293081 IN     school 1808250 225   Northwest Allen County Schools 180825002457 96 Eel River Elementary School   Regular School No Elementary KG 05 2017   grade_2                         43.0 34.0                       77.0                         43 34                 77
1751713 1751713 IN     school 1808250 225   Northwest Allen County Schools 180825002457 96 Eel River Elementary School   Regular School No Elementary KG 05 2019   grade_2                         50.0 55.0                       105.0                         50 55                 105
1787454 1787454 IN     school 1808250 225   Northwest Allen County Schools 180825002457 96 Eel River Elementary School   Regular School No Elementary KG 05 2018   grade_2                         38.0 33.0                       71.0                         38 33                 71
1907154 1907154 IN     school 1808250 225   Northwest Allen County Schools 180825002457 96 Eel River Elementary School   Regular School No Elementary KG 05 2020   grade_2                         53.0 38.0                       91.0                         53 38                 91
1919120 1919120 IN     school 1808250 225   Northwest Allen County Schools 180825002457 96 Eel River Elementary School   Regular School No Elementary KG 05 2021   grade_2                         50.0 59.0                       109.0                         50 59                 109
1159667 1159667 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No 1.0 01 08 2015   grade_2                         35.0 36.0                       71.0                         35 36                 71
1281059 1281059 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No 1.0 01 08 2016   grade_2                         33.0 36.0                       69.0                         33 36                 69
1293120 1293120 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No Elementary 01 08 2017   grade_2                         36.0 39.0                       75.0                         36 39                 75
1751745 1751745 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No Elementary 01 08 2019   grade_2                         31.0 35.0                       66.0                         31 35                 66
1787489 1787489 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No Elementary 01 08 2018   grade_2                         43.0 33.0                       76.0                         43 33                 76
1907185 1907185 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No Elementary 01 08 2020   grade_2                         42.0 33.0                       75.0                         42 33                 75
1919151 1919151 IN     school 1803630 235   Fort Wayne Community Schools 180363002175 118 Jeff H Towles Intermediate School   Regular School No Elementary 01 08 2021   grade_2                         31.0 35.0                       66.0                         31 35                 66
1159708 1159708 IN     school 1803630 235   Fort Wayne Community Schools 180363000570 134 Weisser Park Elem Sch   Regular School No 1.0 01 05 2015   grade_2                         69.0 49.0                       118.0                         69 49                 118
1281100 1281100 IN     school 1803630 235   Fort Wayne Community Schools 180363000570 134 Weisser Park Elementary School   Regular School No 1.0 01 05 2016   grade_2                         54.0 58.0                       112.0                         54 58                 112
1293161 1293161 IN     school 1803630 235   Fort Wayne Community Schools 180363000570 134 Weisser Park Elementary School   Regular School No Elementary 01 05 2017   grade_2                         55.0 65.0                       120.0                         55 65                 120
1751786 1751786 IN     school 1803630 235   Fort Wayne Community Schools 180363000570 134 Weisser Park Elementary School   Regular School No Elementary 01 05 2019   grade_2                         67.0 55.0                       122.0                         67 55                 122
1787530 1787530 IN     school 1803630 235   Fort Wayne Community Schools 180363000570 134 Weisser Park Elementary School   Regular School No Elementary 01 05 2018   grade_2                         62.0 58.0                       120.0                         62 58                 120
1907226 1907226 IN     school 1803630 235   Fort Wayne Community Schools 180363000570 134 Weisser Park Elementary School   Regular School No Elementary 01 05 2020   grade_2                         60.0 64.0                       124.0                         60 64                 124
1919192 1919192 IN     school 1803630 235   Fort Wayne Community Schools 180363000570 134 Weisser Park Elementary School   Regular School No Elementary 01 05 2021   grade_2                         60.0 55.0                       115.0                         60 55                 115
1159714 1159714 IN     school 1803630 235   Fort Wayne Community Schools 180363002197 136 Fairfield Elementary School   Regular School No 1.0 PK 05 2015   grade_2                         48.0 32.0                       80.0                         48 32                 80
1281106 1281106 IN     school 1803630 235   Fort Wayne Community Schools 180363002197 136 Fairfield Elementary School   Regular School No 1.0 PK 05 2016   grade_2                         46.0 52.0                       98.0                         46 52                 98
1293167 1293167 IN     school 1803630 235   Fort Wayne Community Schools 180363002197 136 Fairfield Elementary School   Regular School No Elementary PK 05 2017   grade_2                         44.0 46.0                       90.0                         44 46                 90
1751792 1751792 IN     school 1803630 235   Fort Wayne Community Schools 180363002197 136 Fairfield Elementary School   Regular School No Elementary PK 05 2019   grade_2                         39.0 48.0                       87.0                         39 48                 87
1787536 1787536 IN     school 1803630 235   Fort Wayne Community Schools 180363002197 136 Fairfield Elementary School   Regular School No Elementary PK 05 2018   grade_2                         32.0 31.0                       63.0                         32 31                 63
1907232 1907232 IN     school 1803630 235   Fort Wayne Community Schools 180363002197 136 Fairfield Elementary School   Regular School No Elementary PK 05 2020   grade_2                         39.0 46.0                       85.0                         39 46                 85
1919198 1919198 IN     school 1803630 235   Fort Wayne Community Schools 180363002197 136 Fairfield Elementary School   Regular School No Elementary PK 05 2021   grade_2                         39.0 35.0                       74.0                         39 35                 74
1159722 1159722 IN     school 1803630 235   Fort Wayne Community Schools 180363000547 137 Merle J Abbett Elementary Sch   Regular School No 1.0 PK 05 2015   grade_2                         44.0 25.0                       69.0                         44 25                 69
1281114 1281114 IN     school 1803630 235   Fort Wayne Community Schools 180363000547 137 Merle J Abbett Elementary School   Regular School No 1.0 PK 05 2016   grade_2                         35.0 31.0                       66.0                         35 31                 66
1293175 1293175 IN     school 1803630 235   Fort Wayne Community Schools 180363000547 137 Merle J Abbett Elementary School   Regular School No Elementary PK 05 2017   grade_2                         34.0 40.0                       74.0                         34 40                 74
1751800 1751800 IN     school 1803630 235   Fort Wayne Community Schools 180363000547 137 Merle J Abbett Elementary School   Regular School No Elementary PK 05 2019   grade_2                         53.0 48.0                       101.0                         53 48                 101
1787544 1787544 IN     school 1803630 235   Fort Wayne Community Schools 180363000547 137 Merle J Abbett Elementary School   Regular School No Elementary PK 05 2018   grade_2                         31.0 31.0                       62.0                         31 31                 62
1907240 1907240 IN     school 1803630 235   Fort Wayne Community Schools 180363000547 137 Merle J Abbett Elementary School   Regular School No Elementary PK 05 2020   grade_2                         35.0 34.0                       69.0                         35 34                 69
1919206 1919206 IN     school 1803630 235   Fort Wayne Community Schools 180363000547 137 Merle J Abbett Elementary School   Regular School No Elementary PK 05 2021   grade_2                         42.0 41.0                       83.0                         42 41                 83
1171230 1171230 IN     school 1800121 9740   Thurgood Marshall Leadership Acad 180012102540 138 Thurgood Marshall Leadership Acad   Regular School Yes 1.0 KG 08 2015   grade_2                         7.0 8.0                       15.0                         7 8                 15
1292598 1292598 IN     school 1800121 9740   Thurgood Marshall Leadership Acad 180012102540 138 Thurgood Marshall Leadership Acad   Regular School Yes 1.0 KG 08 2016   grade_2                         10.0 12.0                       22.0                         10 12                 22
1304640 1304640 IN     school 1800121 9740   Thurgood Marshall Leadership Acad 180012102540 138 Thurgood Marshall Leadership Acad   Regular School Yes Elementary KG 08 2017   grade_2                         11.0 9.0                       20.0                         11 9                 20
1763234 1763234 IN     school 1800121 9740   Thurgood Marshall Leadership Acad 180012102540 138 Thurgood Marshall Leadership Acad   Regular School Yes Elementary KG 06 2019   grade_2                         13.0 10.0                       23.0                         13 10                 23
1798973 1798973 IN     school 1800121 9740   Thurgood Marshall Leadership Acad 180012102540 138 Thurgood Marshall Leadership Acad   Regular School Yes Elementary KG 08 2018   grade_2                         8.0 16.0                       24.0                         8 16                 24
1762726 1762726 IN     school 1800196 9060   Paramount Community Heights 180019602643 139 Paramount Community Heights   Regular School Yes Elementary KG 04 2019   grade_2                         9.0 10.0                       19.0                         9 10                 19
1918181 1918181 IN     school 1800196 9060   Paramount Community Heights 180019602643 139 Paramount Community Heights   Regular School Yes Elementary KG 05 2020   grade_2                         10.0 14.0                       24.0                         10 14                 24
1930135 1930135 IN     school 1800196 9060   Paramount Cottage Home 180019602643 139 Paramount Cottage Home   Regular School Yes Elementary KG 04 2021   grade_2                         23.0 12.0                       35.0                         23 12                 35
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
1159738 1159738 IN     school 1803630 235   Fort Wayne Community Schools 180363000517 149 Bloomingdale Elementary Sch   Regular School No 1.0 PK 05 2015   grade_2                         24.0 20.0                       44.0                         24 20                 44
1281130 1281130 IN     school 1803630 235   Fort Wayne Community Schools 180363000517 149 Bloomingdale Elementary School   Regular School No 1.0 PK 05 2016   grade_2                         33.0 22.0                       55.0                         33 22                 55
1293191 1293191 IN     school 1803630 235   Fort Wayne Community Schools 180363000517 149 Bloomingdale Elementary School   Regular School No Elementary PK 05 2017   grade_2                         28.0 21.0                       49.0                         28 21                 49
1751816 1751816 IN     school 1803630 235   Fort Wayne Community Schools 180363000517 149 Bloomingdale Elementary School   Regular School No Elementary PK 05 2019   grade_2                         20.0 24.0                       44.0                         20 24                 44
1787560 1787560 IN     school 1803630 235   Fort Wayne Community Schools 180363000517 149 Bloomingdale Elementary School   Regular School No Elementary PK 05 2018   grade_2                         31.0 32.0                       63.0                         31 32                 63
1907256 1907256 IN     school 1803630 235   Fort Wayne Community Schools 180363000517 149 Bloomingdale Elementary School   Regular School No Elementary PK 05 2020   grade_2                         25.0 25.0                       50.0                         25 25                 50
1919222 1919222 IN     school 1803630 235   Fort Wayne Community Schools 180363000517 149 Bloomingdale Elementary School   Regular School No Elementary PK 05 2021   grade_2                         27.0 22.0                       49.0                         27 22                 49
1159749 1159749 IN     school 1803630 235   Fort Wayne Community Schools 180363000518 153 Brentwood Elementary School   Regular School No 1.0 PK 05 2015   grade_2                         35.0 36.0                       71.0                         35 36                 71
1281141 1281141 IN     school 1803630 235   Fort Wayne Community Schools 180363000518 153 Brentwood Elementary School   Regular School No 1.0 PK 05 2016   grade_2                         49.0 27.0                       76.0                         49 27                 76
1293202 1293202 IN     school 1803630 235   Fort Wayne Community Schools 180363000518 153 Brentwood Elementary School   Regular School No Elementary PK 05 2017   grade_2                         38.0 33.0                       71.0                         38 33                 71
1751827 1751827 IN     school 1803630 235   Fort Wayne Community Schools 180363000518 153 Brentwood Elementary School   Regular School No Elementary PK 05 2019   grade_2                         42.0 24.0                       66.0                         42 24                 66
1787571 1787571 IN     school 1803630 235   Fort Wayne Community Schools 180363000518 153 Brentwood Elementary School   Regular School No Elementary PK 05 2018   grade_2                         36.0 38.0                       74.0                         36 38                 74
1907267 1907267 IN     school 1803630 235   Fort Wayne Community Schools 180363000518 153 Brentwood Elementary School   Regular School No Elementary PK 05 2020   grade_2                         34.0 33.0                       67.0                         34 33                 67
1919233 1919233 IN     school 1803630 235   Fort Wayne Community Schools 180363000518 153 Brentwood Elementary School   Regular School No Elementary PK 05 2021   grade_2                         31.0 33.0                       64.0                         31 33                 64
1159757 1159757 IN     school 1803630 235   Fort Wayne Community Schools 180363000527 154 Fred H Croninger Elem Sch   Regular School No 1.0 KG 05 2015   grade_2                         48.0 53.0                       101.0                         48 53                 101
1281149 1281149 IN     school 1803630 235   Fort Wayne Community Schools 180363000527 154 Fred H Croninger Elementary School   Regular School No 1.0 KG 05 2016   grade_2                         50.0 50.0                       100.0                         50 50                 100
1293210 1293210 IN     school 1803630 235   Fort Wayne Community Schools 180363000527 154 Fred H Croninger Elementary School   Regular School No Elementary KG 05 2017   grade_2                         60.0 43.0                       103.0                         60 43                 103
1751835 1751835 IN     school 1803630 235   Fort Wayne Community Schools 180363000527 154 Fred H Croninger Elementary School   Regular School No Elementary KG 05 2019   grade_2                         68.0 62.0                       130.0                         68 62                 130
1787579 1787579 IN     school 1803630 235   Fort Wayne Community Schools 180363000527 154 Fred H Croninger Elementary School   Regular School No Elementary KG 05 2018   grade_2                         57.0 46.0                       103.0                         57 46                 103
1907275 1907275 IN     school 1803630 235   Fort Wayne Community Schools 180363000527 154 Fred H Croninger Elementary School   Regular School No Elementary KG 05 2020   grade_2                         66.0 38.0                       104.0                         66 38                 104
1919241 1919241 IN     school 1803630 235   Fort Wayne Community Schools 180363000527 154 Fred H Croninger Elementary School   Regular School No Elementary KG 05 2021   grade_2                         55.0 49.0                       104.0                         55 49                 104
1159764 1159764 IN     school 1803630 235   Fort Wayne Community Schools 180363000522 157 Forest Park Elementary School   Regular School No 1.0 PK 05 2015   grade_2                         42.0 41.0                       83.0                         42 41                 83
1281156 1281156 IN     school 1803630 235   Fort Wayne Community Schools 180363000522 157 Forest Park Elementary School   Regular School No 1.0 PK 05 2016   grade_2                         41.0 56.0                       97.0                         41 56                 97
1293217 1293217 IN     school 1803630 235   Fort Wayne Community Schools 180363000522 157 Forest Park Elementary School   Regular School No Elementary PK 05 2017   grade_2                         38.0 41.0                       79.0                         38 41                 79
1751842 1751842 IN     school 1803630 235   Fort Wayne Community Schools 180363000522 157 Forest Park Elementary School   Regular School No Elementary PK 05 2019   grade_2                         42.0 44.0                       86.0                         42 44                 86
1787586 1787586 IN     school 1803630 235   Fort Wayne Community Schools 180363000522 157 Forest Park Elementary School   Regular School No Elementary PK 05 2018   grade_2                         52.0 50.0                       102.0                         52 50                 102
1907282 1907282 IN     school 1803630 235   Fort Wayne Community Schools 180363000522 157 Forest Park Elementary School   Regular School No Elementary PK 05 2020   grade_2                         50.0 40.0                       90.0                         50 40                 90
1919248 1919248 IN     school 1803630 235   Fort Wayne Community Schools 180363000522 157 Forest Park Elementary School   Regular School No Elementary PK 05 2021   grade_2                         39.0 54.0                       93.0                         39 54                 93
1159772 1159772 IN     school 1803630 235   Fort Wayne Community Schools 180363000525 161 Franke Park Elementary School   Regular School No 1.0 PK 05 2015   grade_2                         46.0 47.0                       93.0                         46 47                 93
1281164 1281164 IN     school 1803630 235   Fort Wayne Community Schools 180363000525 161 Franke Park Elementary School   Regular School No 1.0 PK 05 2016   grade_2                         56.0 45.0                       101.0                         56 45                 101
1293225 1293225 IN     school 1803630 235   Fort Wayne Community Schools 180363000525 161 Franke Park Elementary School   Regular School No Elementary PK 05 2017   grade_2                         35.0 36.0                       71.0                         35 36                 71
1751850 1751850 IN     school 1803630 235   Fort Wayne Community Schools 180363000525 161 Franke Park Elementary School   Regular School No Elementary PK 05 2019   grade_2                         37.0 37.0                       74.0                         37 37                 74
1787594 1787594 IN     school 1803630 235   Fort Wayne Community Schools 180363000525 161 Franke Park Elementary School   Regular School No Elementary PK 05 2018   grade_2                         49.0 35.0                       84.0                         49 35                 84
1907290 1907290 IN     school 1803630 235   Fort Wayne Community Schools 180363000525 161 Franke Park Elementary School   Regular School No Elementary PK 05 2020   grade_2                         37.0 28.0                       65.0                         37 28                 65
1919256 1919256 IN     school 1803630 235   Fort Wayne Community Schools 180363000525 161 Franke Park Elementary School   Regular School No Elementary PK 05 2021   grade_2                         26.0 27.0                       53.0                         26 27                 53
1159780 1159780 IN     school 1803630 235   Fort Wayne Community Schools 180363000529 162 Glenwood Park Elementary Sch   Regular School No 1.0 KG 05 2015   grade_2                         56.0 50.0                       106.0                         56 50                 106
1281172 1281172 IN     school 1803630 235   Fort Wayne Community Schools 180363000529 162 Glenwood Park Elementary School   Regular School No 1.0 KG 05 2016   grade_2                         55.0 67.0                       122.0                         55 67                 122
1293233 1293233 IN     school 1803630 235   Fort Wayne Community Schools 180363000529 162 Glenwood Park Elementary School   Regular School No Elementary KG 05 2017   grade_2                         48.0 49.0                       97.0                         48 49                 97

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