enrollments

Data source: Big Local News · About: Big Local

84,143 rows where state = "IN" sorted by school_state_id

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

year ✖

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
1906997 1906997 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 585.0 5.0 29.0 1.0   1.0         16.0   334.0 303.0     24.0         161.0   112.0   637.0 585 5 29 1   1         16   334 303     24     161 112   637
1906998 1906998 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten                         13.0 13.0                       26.0                         13 13                 26
1918957 1918957 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2021   grade_1                         48.0 47.0                       95.0                         48 47                 95
1918958 1918958 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2021   grade_2                         56.0 43.0                       99.0                         56 43                 99
1918959 1918959 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2021   grade_3                         53.0 65.0                       118.0                         53 65                 118
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
1918961 1918961 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2021   grade_5                         58.0 48.0                       106.0                         58 48                 106
1918962 1918962 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2021   kindergarten                         46.0 37.0                       83.0                         46 37                 83
1918963 1918963 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2021   pk_12_total 603.0 4.0 34.0 1.0   1.0         18.0   352.0 309.0     19.0         154.0   110.0   661.0 603 4 34 1   1         18   352 309     19     154 110   661
1918964 1918964 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2021   pre_kindergarten                         33.0 28.0                       61.0                         33 28                 61
1159473 1159473 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No 3.0 09 12 2015   adult                         1.0 1.0                       2.0                         1 1                 2
1159474 1159474 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No 3.0 09 12 2015   grade_10                         45.0 51.0                       96.0                         45 51                 96
1159475 1159475 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No 3.0 09 12 2015   grade_11                         52.0 39.0                       91.0                         52 39                 91
1159476 1159476 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No 3.0 09 12 2015   grade_12                         43.0 50.0                       93.0                         43 50                 93
1159477 1159477 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No 3.0 09 12 2015   grade_9                         49.0 34.0                       83.0                         49 34                 83
1159478 1159478 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No 3.0 09 12 2015   pk_12_total 347.0   13.0 2.0   2.0     1.0       190.0 175.0     7.0             37.0   365.0 347   13 2   2     1       190 175     7       37   365
1280863 1280863 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No 3.0 09 12 2016   adult                         2.0 1.0                       3.0                         2 1                 3
1280864 1280864 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No 3.0 09 12 2016   grade_10                         48.0 34.0                       82.0                         48 34                 82
1280865 1280865 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No 3.0 09 12 2016   grade_11                         47.0 53.0                       100.0                         47 53                 100
1280866 1280866 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No 3.0 09 12 2016   grade_12                         51.0 38.0                       89.0                         51 38                 89
1280867 1280867 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No 3.0 09 12 2016   grade_9                         47.0 53.0                       100.0                         47 53                 100
1280868 1280868 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No 3.0 09 12 2016   pk_12_total 357.0 1.0 12.0 1.0         1.0   2.0   195.0 179.0     6.0             35.0   374.0 357 1 12 1         1   2   195 179     6       35   374
1292926 1292926 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No High 09 12 2017   adult                         2.0 1.0                       3.0                         2 1                 3
1292927 1292927 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No High 09 12 2017   grade_10                         46.0 55.0                       101.0                         46 55                 101
1292928 1292928 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No High 09 12 2017   grade_11                         48.0 33.0                       81.0                         48 33                 81
1292929 1292929 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No High 09 12 2017   grade_12                         45.0 57.0                       102.0                         45 57                 102
1292930 1292930 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No High 09 12 2017   grade_9                         42.0 49.0                       91.0                         42 49                 91
1292931 1292931 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No High 09 12 2017   pk_12_total 358.0   9.0 2.0   8.0         1.0   183.0 195.0     8.0             28.0   378.0 358   9 2   8         1   183 195     8       28   378
1751558 1751558 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No High 09 12 2019   adult                         3.0 0.0                       3.0                         3 0                 3
1751559 1751559 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No High 09 12 2019   grade_10                         48.0 55.0                       103.0                         48 55                 103
1751560 1751560 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No High 09 12 2019   grade_11                         40.0 52.0                       92.0                         40 52                 92
1751561 1751561 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No High 09 12 2019   grade_12                         48.0 50.0                       98.0                         48 50                 98
1751562 1751562 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No High 09 12 2019   grade_9                         38.0 40.0                       78.0                         38 40                 78
1751563 1751563 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No High 09 12 2019   pk_12_total 350.0 5.0 5.0 1.0   7.0         6.0   177.0 197.0     6.0         74.0   22.0   374.0 350 5 5 1   7         6   177 197     6     74 22   374
1787299 1787299 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No High 09 12 2018   adult                         1.0 0.0                       1.0                         1 0                 1
1787300 1787300 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No High 09 12 2018   grade_10                         41.0 53.0                       94.0                         41 53                 94
1787301 1787301 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No High 09 12 2018   grade_11                         45.0 53.0                       98.0                         45 53                 98
1787302 1787302 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No High 09 12 2018   grade_12                         50.0 33.0                       83.0                         50 33                 83
1787303 1787303 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No High 09 12 2018   grade_9                         49.0 53.0                       102.0                         49 53                 102
1787304 1787304 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No High 09 12 2018   pk_12_total 356.0 1.0 9.0 1.0   6.0         5.0   186.0 192.0     9.0         86.0   21.0   378.0 356 1 9 1   6         5   186 192     9     86 21   378
1906999 1906999 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No High 09 12 2020   adult                         1.0 1.0                       2.0                         1 1                 2
1907000 1907000 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No High 09 12 2020   grade_10                         38.0 42.0                       80.0                         38 42                 80
1907001 1907001 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No High 09 12 2020   grade_11                         51.0 56.0                       107.0                         51 56                 107
1907002 1907002 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No High 09 12 2020   grade_12                         39.0 44.0                       83.0                         39 44                 83
1907003 1907003 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No High 09 12 2020   grade_9                         50.0 33.0                       83.0                         50 33                 83
1907004 1907004 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No High 09 12 2020   pk_12_total 334.0 2.0 10.0 1.0   5.0         3.0   179.0 176.0     6.0         75.0   20.0   355.0 334 2 10 1   5         3   179 176     6     75 20   355
1918965 1918965 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No High 09 12 2021   adult                         1.0 1.0                       2.0                         1 1                 2
1918966 1918966 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No High 09 12 2021   grade_10                         49.0 32.0                       81.0                         49 32                 81
1918967 1918967 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No High 09 12 2021   grade_11                         39.0 43.0                       82.0                         39 43                 82
1918968 1918968 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No High 09 12 2021   grade_12                         50.0 54.0                       104.0                         50 54                 104
1918969 1918969 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No High 09 12 2021   grade_9                         53.0 48.0                       101.0                         53 48                 101
1918970 1918970 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No High 09 12 2021   pk_12_total 351.0 2.0 13.0 1.0   1.0         2.0   192.0 178.0     4.0         79.0   23.0   370.0 351 2 13 1   1         2   192 178     4     79 23   370
1159501 1159501 IN     school 1810260 35   South Adams Schools 181026001642 23 South Adams High School   Regular School No 3.0 09 12 2015   adult                         1.0 0.0                       1.0                         1 0                 1
1159502 1159502 IN     school 1810260 35   South Adams Schools 181026001642 23 South Adams High School   Regular School No 3.0 09 12 2015   grade_10                         58.0 54.0                       112.0                         58 54                 112
1159503 1159503 IN     school 1810260 35   South Adams Schools 181026001642 23 South Adams High School   Regular School No 3.0 09 12 2015   grade_11                         35.0 50.0                       85.0                         35 50                 85
1159504 1159504 IN     school 1810260 35   South Adams Schools 181026001642 23 South Adams High School   Regular School No 3.0 09 12 2015   grade_12                         40.0 40.0                       80.0                         40 40                 80
1159505 1159505 IN     school 1810260 35   South Adams Schools 181026001642 23 South Adams High School   Regular School No 3.0 09 12 2015   grade_9                         53.0 60.0                       113.0                         53 60                 113
1159506 1159506 IN     school 1810260 35   South Adams Schools 181026001642 23 South Adams High School   Regular School No 3.0 09 12 2015   pk_12_total 331.0 5.0 44.0 2.0   4.0         5.0   187.0 204.0     19.0             40.0   391.0 331 5 44 2   4         5   187 204     19       40   391
1280891 1280891 IN     school 1810260 35   South Adams Schools 181026001642 23 South Adams High School   Regular School No 3.0 09 12 2016   adult                         1.0 0.0                       1.0                         1 0                 1
1280892 1280892 IN     school 1810260 35   South Adams Schools 181026001642 23 South Adams High School   Regular School No 3.0 09 12 2016   grade_10                         45.0 49.0                       94.0                         45 49                 94
1280893 1280893 IN     school 1810260 35   South Adams Schools 181026001642 23 South Adams High School   Regular School No 3.0 09 12 2016   grade_11                         54.0 50.0                       104.0                         54 50                 104
1280894 1280894 IN     school 1810260 35   South Adams Schools 181026001642 23 South Adams High School   Regular School No 3.0 09 12 2016   grade_12                         31.0 44.0                       75.0                         31 44                 75
1280895 1280895 IN     school 1810260 35   South Adams Schools 181026001642 23 South Adams High School   Regular School No 3.0 09 12 2016   grade_9                         46.0 49.0                       95.0                         46 49                 95
1280896 1280896 IN     school 1810260 35   South Adams Schools 181026001642 23 South Adams High School   Regular School No 3.0 09 12 2016   pk_12_total 306.0 6.0 47.0 2.0   2.0         6.0   177.0 192.0     13.0             44.0   369.0 306 6 47 2   2         6   177 192     13       44   369
1292954 1292954 IN     school 1810260 35   South Adams Schools 181026001642 23 South Adams High School   Regular School No High 09 12 2017   grade_10                         37.0 42.0                       79.0                         37 42                 79
1292955 1292955 IN     school 1810260 35   South Adams Schools 181026001642 23 South Adams High School   Regular School No High 09 12 2017   grade_11                         41.0 50.0                       91.0                         41 50                 91
1292956 1292956 IN     school 1810260 35   South Adams Schools 181026001642 23 South Adams High School   Regular School No High 09 12 2017   grade_12                         51.0 47.0                       98.0                         51 47                 98
1292957 1292957 IN     school 1810260 35   South Adams Schools 181026001642 23 South Adams High School   Regular School No High 09 12 2017   grade_9                         57.0 44.0                       101.0                         57 44                 101
1292958 1292958 IN     school 1810260 35   South Adams Schools 181026001642 23 South Adams High School   Regular School No High 09 12 2017   pk_12_total 310.0 2.0 43.0 3.0   6.0         5.0   186.0 183.0     10.0             36.0   369.0 310 2 43 3   6         5   186 183     10       36   369
1751585 1751585 IN     school 1810260 35   South Adams Schools 181026001642 23 South Adams High School   Regular School No High 09 12 2019   adult                         3.0 0.0                       3.0                         3 0                 3
1751586 1751586 IN     school 1810260 35   South Adams Schools 181026001642 23 South Adams High School   Regular School No High 09 12 2019   grade_10                         55.0 39.0                       94.0                         55 39                 94
1751587 1751587 IN     school 1810260 35   South Adams Schools 181026001642 23 South Adams High School   Regular School No High 09 12 2019   grade_11                         44.0 43.0                       87.0                         44 43                 87
1751588 1751588 IN     school 1810260 35   South Adams Schools 181026001642 23 South Adams High School   Regular School No High 09 12 2019   grade_12                         32.0 34.0                       66.0                         32 34                 66
1751589 1751589 IN     school 1810260 35   South Adams Schools 181026001642 23 South Adams High School   Regular School No High 09 12 2019   grade_9                         56.0 49.0                       105.0                         56 49                 105
1751590 1751590 IN     school 1810260 35   South Adams Schools 181026001642 23 South Adams High School   Regular School No High 09 12 2019   pk_12_total 302.0 5.0 34.0 1.0   8.0         5.0   190.0 165.0     15.0         136.0   35.0   355.0 302 5 34 1   8         5   190 165     15     136 35   355
1787327 1787327 IN     school 1810260 35   South Adams Schools 181026001642 23 South Adams High School   Regular School No High 09 12 2018   grade_10                         50.0 41.0                       91.0                         50 41                 91
1787328 1787328 IN     school 1810260 35   South Adams Schools 181026001642 23 South Adams High School   Regular School No High 09 12 2018   grade_11                         30.0 37.0                       67.0                         30 37                 67
1787329 1787329 IN     school 1810260 35   South Adams Schools 181026001642 23 South Adams High School   Regular School No High 09 12 2018   grade_12                         42.0 39.0                       81.0                         42 39                 81
1787330 1787330 IN     school 1810260 35   South Adams Schools 181026001642 23 South Adams High School   Regular School No High 09 12 2018   grade_9                         60.0 43.0                       103.0                         60 43                 103
1787331 1787331 IN     school 1810260 35   South Adams Schools 181026001642 23 South Adams High School   Regular School No High 09 12 2018   pk_12_total 289.0 4.0 42.0 1.0   4.0         2.0   182.0 160.0     5.0         134.0   29.0   342.0 289 4 42 1   4         2   182 160     5     134 29   342
1907026 1907026 IN     school 1810260 35   South Adams Schools 181026001642 23 South Adams High School   Regular School No High 09 12 2020   adult                         4.0 1.0                       5.0                         4 1                 5
1907027 1907027 IN     school 1810260 35   South Adams Schools 181026001642 23 South Adams High School   Regular School No High 09 12 2020   grade_10                         41.0 45.0                       86.0                         41 45                 86
1907028 1907028 IN     school 1810260 35   South Adams Schools 181026001642 23 South Adams High School   Regular School No High 09 12 2020   grade_11                         53.0 45.0                       98.0                         53 45                 98
1907029 1907029 IN     school 1810260 35   South Adams Schools 181026001642 23 South Adams High School   Regular School No High 09 12 2020   grade_12                         46.0 38.0                       84.0                         46 38                 84
1907030 1907030 IN     school 1810260 35   South Adams Schools 181026001642 23 South Adams High School   Regular School No High 09 12 2020   grade_9                         37.0 41.0                       78.0                         37 41                 78
1907031 1907031 IN     school 1810260 35   South Adams Schools 181026001642 23 South Adams High School   Regular School No High 09 12 2020   pk_12_total 299.0 5.0 31.0 1.0   12.0         3.0   181.0 170.0     26.0         118.0   37.0   351.0 299 5 31 1   12         3   181 170     26     118 37   351
1918992 1918992 IN     school 1810260 35   South Adams Schools 181026001642 23 South Adams High School   Regular School No High 09 12 2021   adult                         2.0 1.0                       3.0                         2 1                 3
1918993 1918993 IN     school 1810260 35   South Adams Schools 181026001642 23 South Adams High School   Regular School No High 09 12 2021   grade_10                         38.0 40.0                       78.0                         38 40                 78
1918994 1918994 IN     school 1810260 35   South Adams Schools 181026001642 23 South Adams High School   Regular School No High 09 12 2021   grade_11                         43.0 47.0                       90.0                         43 47                 90
1918995 1918995 IN     school 1810260 35   South Adams Schools 181026001642 23 South Adams High School   Regular School No High 09 12 2021   grade_12                         52.0 37.0                       89.0                         52 37                 89
1918996 1918996 IN     school 1810260 35   South Adams Schools 181026001642 23 South Adams High School   Regular School No High 09 12 2021   grade_9                         39.0 50.0                       89.0                         39 50                 89
1918997 1918997 IN     school 1810260 35   South Adams Schools 181026001642 23 South Adams High School   Regular School No High 09 12 2021   pk_12_total 300.0 3.0 34.0     7.0         5.0   174.0 175.0     21.0         119.0   46.0   349.0 300 3 34     7         5   174 175     21     119 46   349
1159507 1159507 IN     school 1810260 35   South Adams Schools 181026001640 25 South Adams Elem School   Regular School No 1.0 PK 05 2015   grade_1                         39.0 54.0                       93.0                         39 54                 93
1159508 1159508 IN     school 1810260 35   South Adams Schools 181026001640 25 South Adams Elem School   Regular School No 1.0 PK 05 2015   grade_2                         44.0 48.0                       92.0                         44 48                 92
1159509 1159509 IN     school 1810260 35   South Adams Schools 181026001640 25 South Adams Elem School   Regular School No 1.0 PK 05 2015   grade_3                         39.0 52.0                       91.0                         39 52                 91
1159510 1159510 IN     school 1810260 35   South Adams Schools 181026001640 25 South Adams Elem School   Regular School No 1.0 PK 05 2015   grade_4                         50.0 51.0                       101.0                         50 51                 101
1159511 1159511 IN     school 1810260 35   South Adams Schools 181026001640 25 South Adams Elem School   Regular School No 1.0 PK 05 2015   grade_5                         51.0 48.0                       99.0                         51 48                 99
1159512 1159512 IN     school 1810260 35   South Adams Schools 181026001640 25 South Adams Elem School   Regular School No 1.0 PK 05 2015   kindergarten                         40.0 43.0                       83.0                         40 43                 83
1159513 1159513 IN     school 1810260 35   South Adams Schools 181026001640 25 South Adams Elem School   Regular School No 1.0 PK 05 2015   pk_12_total 511.0 2.0 73.0 2.0   6.0         12.0   294.0 312.0     61.0             104.0   606.0 511 2 73 2   6         12   294 312     61       104   606
1159514 1159514 IN     school 1810260 35   South Adams Schools 181026001640 25 South Adams Elem School   Regular School No 1.0 PK 05 2015   pre_kindergarten                         31.0 16.0                       47.0                         31 16                 47

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