enrollments

Data source: Big Local News · About: Big Local

11,992 rows where state = "IN" and year = 2019 sorted by ccd_school_type

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

year ✖

  • 2019 · 11,992 ✖
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
1752107 1752107 IN     school   255   East Allen County Schools   318 EACS Early Childhood Preschool             2019   pk_12_total 36.0 1.0 6.0     2.0         1.0   33.0 13.0     0.0         17.0   38.0   46.0 36 1 6     2         1   33 13     0     17 38   46
1752108 1752108 IN     school   255   East Allen County Schools   318 EACS Early Childhood Preschool             2019   pre_kindergarten                         33.0 13.0                       46.0                         33 13                 46
1754356 1754356 IN     school   2865   Marion Community Schools   2416 Grant County Comm Justice Center             2019   grade_11                         1.0 0.0                       1.0                         1 0                 1
1754357 1754357 IN     school   2865   Marion Community Schools   2416 Grant County Comm Justice Center             2019   pk_12_total 1.0                       1.0 0.0     0.0             0.0   1.0 1                       1 0     0       0   1
1758207 1758207 IN     school   5375   M S D Wayne Township   5271 Sanders School             2019   grade_1                         6.0 0.0                       6.0                         6 0                 6
1758208 1758208 IN     school   5375   M S D Wayne Township   5271 Sanders School             2019   grade_10                         5.0 2.0                       7.0                         5 2                 7
1758209 1758209 IN     school   5375   M S D Wayne Township   5271 Sanders School             2019   grade_11                         6.0 0.0                       6.0                         6 0                 6
1758210 1758210 IN     school   5375   M S D Wayne Township   5271 Sanders School             2019   grade_12                         6.0 0.0                       6.0                         6 0                 6
1758211 1758211 IN     school   5375   M S D Wayne Township   5271 Sanders School             2019   grade_2                         7.0 1.0                       8.0                         7 1                 8
1758212 1758212 IN     school   5375   M S D Wayne Township   5271 Sanders School             2019   grade_3                         5.0 0.0                       5.0                         5 0                 5
1758213 1758213 IN     school   5375   M S D Wayne Township   5271 Sanders School             2019   grade_4                         3.0 0.0                       3.0                         3 0                 3
1758214 1758214 IN     school   5375   M S D Wayne Township   5271 Sanders School             2019   grade_5                         6.0 1.0                       7.0                         6 1                 7
1758215 1758215 IN     school   5375   M S D Wayne Township   5271 Sanders School             2019   grade_6                         7.0 4.0                       11.0                         7 4                 11
1758216 1758216 IN     school   5375   M S D Wayne Township   5271 Sanders School             2019   grade_7                         7.0 1.0                       8.0                         7 1                 8
1758217 1758217 IN     school   5375   M S D Wayne Township   5271 Sanders School             2019   grade_8                         5.0 1.0                       6.0                         5 1                 6
1758218 1758218 IN     school   5375   M S D Wayne Township   5271 Sanders School             2019   grade_9                         10.0 0.0                       10.0                         10 0                 10
1758219 1758219 IN     school   5375   M S D Wayne Township   5271 Sanders School             2019   kindergarten                         1.0 0.0                       1.0                         1 0                 1
1758220 1758220 IN     school   5375   M S D Wayne Township   5271 Sanders School             2019   pk_12_total 40.0 35.0 2.0               7.0   74.0 10.0     4.0         51.0   82.0   84.0 40 35 2               7   74 10     4     51 82   84
1760847 1760847 IN     school   7205   South Bend Community School Corp   7605 South Bend SNAP             2019   pk_12_total 86.0 47.0 39.0     2.0         45.0   132.0 87.0     0.0         12.0   99.0   219.0 86 47 39     2         45   132 87     0     12 99   219
1760848 1760848 IN     school   7205   South Bend Community School Corp   7605 South Bend SNAP             2019   pre_kindergarten                         132.0 87.0                       219.0                         132 87                 219
1752764 1752764 IN     school 1803940 1010   Greater Clark County Schools 180394000839 891 Clark County Middle/High School   Alternative School No High 07 12 2019   grade_10                         12.0 6.0                       18.0                         12 6                 18
1752765 1752765 IN     school 1803940 1010   Greater Clark County Schools 180394000839 891 Clark County Middle/High School   Alternative School No High 07 12 2019   grade_11                         10.0 3.0                       13.0                         10 3                 13
1752766 1752766 IN     school 1803940 1010   Greater Clark County Schools 180394000839 891 Clark County Middle/High School   Alternative School No High 07 12 2019   grade_12                         19.0 10.0                       29.0                         19 10                 29
1752767 1752767 IN     school 1803940 1010   Greater Clark County Schools 180394000839 891 Clark County Middle/High School   Alternative School No High 07 12 2019   grade_7                         4.0 2.0                       6.0                         4 2                 6
1752768 1752768 IN     school 1803940 1010   Greater Clark County Schools 180394000839 891 Clark County Middle/High School   Alternative School No High 07 12 2019   grade_8                         5.0 1.0                       6.0                         5 1                 6
1752769 1752769 IN     school 1803940 1010   Greater Clark County Schools 180394000839 891 Clark County Middle/High School   Alternative School No High 07 12 2019   grade_9                         3.0 2.0                       5.0                         3 2                 5
1752770 1752770 IN     school 1803940 1010   Greater Clark County Schools 180394000839 891 Clark County Middle/High School   Alternative School No High 07 12 2019   pk_12_total 50.0 15.0 5.0               7.0   53.0 24.0     0.0         41.0   1.0   77.0 50 15 5               7   53 24     0     41 1   77
1753413 1753413 IN     school 1807320 1970   Muncie Community Schools 180732001232 1524 Youth Opportunity Center   Alternative School No Other 04 12 2019   grade_10                         20.0 10.0                       30.0                         20 10                 30
1753414 1753414 IN     school 1807320 1970   Muncie Community Schools 180732001232 1524 Youth Opportunity Center   Alternative School No Other 04 12 2019   grade_11                         16.0 9.0                       25.0                         16 9                 25
1753415 1753415 IN     school 1807320 1970   Muncie Community Schools 180732001232 1524 Youth Opportunity Center   Alternative School No Other 04 12 2019   grade_12                         5.0 0.0                       5.0                         5 0                 5
1753416 1753416 IN     school 1807320 1970   Muncie Community Schools 180732001232 1524 Youth Opportunity Center   Alternative School No Other 04 12 2019   grade_4                         1.0 0.0                       1.0                         1 0                 1
1753417 1753417 IN     school 1807320 1970   Muncie Community Schools 180732001232 1524 Youth Opportunity Center   Alternative School No Other 04 12 2019   grade_6                         4.0 0.0                       4.0                         4 0                 4
1753418 1753418 IN     school 1807320 1970   Muncie Community Schools 180732001232 1524 Youth Opportunity Center   Alternative School No Other 04 12 2019   grade_7                         8.0 3.0                       11.0                         8 3                 11
1753419 1753419 IN     school 1807320 1970   Muncie Community Schools 180732001232 1524 Youth Opportunity Center   Alternative School No Other 04 12 2019   grade_8                         10.0 8.0                       18.0                         10 8                 18
1753420 1753420 IN     school 1807320 1970   Muncie Community Schools 180732001232 1524 Youth Opportunity Center   Alternative School No Other 04 12 2019   grade_9                         23.0 6.0                       29.0                         23 6                 29
1753421 1753421 IN     school 1807320 1970   Muncie Community Schools 180732001232 1524 Youth Opportunity Center   Alternative School No Other 04 12 2019   pk_12_total 89.0 14.0 11.0 1.0   1.0         7.0   87.0 36.0     3.0         110.0   51.0   123.0 89 14 11 1   1         7   87 36     3     110 51   123
1757499 1757499 IN     school 1800150 5275   Anderson Community School Corp 180015002623 4906 COMPASS Alternative School   Alternative School No Middle 06 10 2019   grade_10                         5.0 5.0                       10.0                         5 5                 10
1757500 1757500 IN     school 1800150 5275   Anderson Community School Corp 180015002623 4906 COMPASS Alternative School   Alternative School No Middle 06 10 2019   grade_6                         5.0 1.0                       6.0                         5 1                 6
1757501 1757501 IN     school 1800150 5275   Anderson Community School Corp 180015002623 4906 COMPASS Alternative School   Alternative School No Middle 06 10 2019   grade_7                         9.0 3.0                       12.0                         9 3                 12
1757502 1757502 IN     school 1800150 5275   Anderson Community School Corp 180015002623 4906 COMPASS Alternative School   Alternative School No Middle 06 10 2019   grade_8                         25.0 5.0                       30.0                         25 5                 30
1757503 1757503 IN     school 1800150 5275   Anderson Community School Corp 180015002623 4906 COMPASS Alternative School   Alternative School No Middle 06 10 2019   grade_9                         13.0 3.0                       16.0                         13 3                 16
1757504 1757504 IN     school 1800150 5275   Anderson Community School Corp 180015002623 4906 COMPASS Alternative School   Alternative School No Middle 06 10 2019   pk_12_total 26.0 27.0 9.0               12.0   57.0 17.0     3.0         66.0   19.0   74.0 26 27 9               12   57 17     3     66 19   74
1760859 1760859 IN     school 1810290 7205   South Bend Community School Corp 181029000898 7632 Juvenile Justice Center   Alternative School No High 07 12 2019   grade_10                         4.0 0.0                       4.0                         4 0                 4
1760860 1760860 IN     school 1810290 7205   South Bend Community School Corp 181029000898 7632 Juvenile Justice Center   Alternative School No High 07 12 2019   grade_11                         3.0 1.0                       4.0                         3 1                 4
1760861 1760861 IN     school 1810290 7205   South Bend Community School Corp 181029000898 7632 Juvenile Justice Center   Alternative School No High 07 12 2019   grade_12                         1.0 2.0                       3.0                         1 2                 3
1760862 1760862 IN     school 1810290 7205   South Bend Community School Corp 181029000898 7632 Juvenile Justice Center   Alternative School No High 07 12 2019   grade_7                         1.0 1.0                       2.0                         1 1                 2
1760863 1760863 IN     school 1810290 7205   South Bend Community School Corp 181029000898 7632 Juvenile Justice Center   Alternative School No High 07 12 2019   grade_8                         2.0 1.0                       3.0                         2 1                 3
1760864 1760864 IN     school 1810290 7205   South Bend Community School Corp 181029000898 7632 Juvenile Justice Center   Alternative School No High 07 12 2019   grade_9                         1.0 2.0                       3.0                         1 2                 3
1760865 1760865 IN     school 1810290 7205   South Bend Community School Corp 181029000898 7632 Juvenile Justice Center   Alternative School No High 07 12 2019   pk_12_total 4.0 8.0 3.0               4.0   12.0 7.0     0.0         3.0   1.0   19.0 4 8 3               4   12 7     0     3 1   19
1762058 1762058 IN     school 1812090 8030   Vigo County School Corp 181209002344 8611 Booker T Washington Alt Sch   Alternative School No High 09 12 2019   grade_10                         4.0 11.0                       15.0                         4 11                 15
1762059 1762059 IN     school 1812090 8030   Vigo County School Corp 181209002344 8611 Booker T Washington Alt Sch   Alternative School No High 09 12 2019   grade_11                         3.0 10.0                       13.0                         3 10                 13
1762060 1762060 IN     school 1812090 8030   Vigo County School Corp 181209002344 8611 Booker T Washington Alt Sch   Alternative School No High 09 12 2019   grade_12                         2.0 23.0                       25.0                         2 23                 25
1762061 1762061 IN     school 1812090 8030   Vigo County School Corp 181209002344 8611 Booker T Washington Alt Sch   Alternative School No High 09 12 2019   grade_9                         1.0 4.0                       5.0                         1 4                 5
1762062 1762062 IN     school 1812090 8030   Vigo County School Corp 181209002344 8611 Booker T Washington Alt Sch   Alternative School No High 09 12 2019   pk_12_total 48.0 6.0 2.0               2.0   10.0 48.0     0.0         40.0   16.0   58.0 48 6 2               2   10 48     0     40 16   58
1751546 1751546 IN     school 1800060 15   Adams Central Community Schools 180006000008 13 Adams Central Middle School   Regular School No Middle 06 08 2019   grade_6                         55.0 51.0                       106.0                         55 51                 106
1751547 1751547 IN     school 1800060 15   Adams Central Community Schools 180006000008 13 Adams Central Middle School   Regular School No Middle 06 08 2019   grade_7                         50.0 51.0                       101.0                         50 51                 101
1751548 1751548 IN     school 1800060 15   Adams Central Community Schools 180006000008 13 Adams Central Middle School   Regular School No Middle 06 08 2019   grade_8                         52.0 30.0                       82.0                         52 30                 82
1751549 1751549 IN     school 1800060 15   Adams Central Community Schools 180006000008 13 Adams Central Middle School   Regular School No Middle 06 08 2019   pk_12_total 270.0 3.0 12.0     2.0         2.0   157.0 132.0     1.0         74.0   21.0   289.0 270 3 12     2         2   157 132     1     74 21   289
1751550 1751550 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2019   grade_1                         64.0 62.0                       126.0                         64 62                 126
1751551 1751551 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2019   grade_2                         60.0 39.0                       99.0                         60 39                 99
1751552 1751552 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2019   grade_3                         50.0 43.0                       93.0                         50 43                 93
1751553 1751553 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2019   grade_4                         54.0 52.0                       106.0                         54 52                 106
1751554 1751554 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2019   grade_5                         64.0 41.0                       105.0                         64 41                 105
1751555 1751555 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2019   kindergarten                         51.0 46.0                       97.0                         51 46                 97
1751556 1751556 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2019   pk_12_total 574.0 6.0 31.0 1.0   2.0         17.0   347.0 284.0     24.0         171.0   95.0   631.0 574 6 31 1   2         17   347 284     24     171 95   631
1751557 1751557 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         4.0 1.0                       5.0                         4 1                 5
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
1751564 1751564 IN     school 1807680 25   North Adams Community Schools 180768001314 29 Bellmont Senior High School   Regular School No High 09 12 2019   grade_10                         91.0 87.0                       178.0                         91 87                 178
1751565 1751565 IN     school 1807680 25   North Adams Community Schools 180768001314 29 Bellmont Senior High School   Regular School No High 09 12 2019   grade_11                         82.0 87.0                       169.0                         82 87                 169
1751566 1751566 IN     school 1807680 25   North Adams Community Schools 180768001314 29 Bellmont Senior High School   Regular School No High 09 12 2019   grade_12                         84.0 84.0                       168.0                         84 84                 168
1751567 1751567 IN     school 1807680 25   North Adams Community Schools 180768001314 29 Bellmont Senior High School   Regular School No High 09 12 2019   grade_9                         97.0 80.0                       177.0                         97 80                 177
1751568 1751568 IN     school 1807680 25   North Adams Community Schools 180768001314 29 Bellmont Senior High School   Regular School No High 09 12 2019   pk_12_total 572.0 13.0 79.0 3.0   5.0         20.0   354.0 338.0     7.0         246.0   64.0   692.0 572 13 79 3   5         20   354 338     7     246 64   692
1751569 1751569 IN     school 1807680 25   North Adams Community Schools 180768001313 33 Bellmont Middle School   Regular School No Middle 06 08 2019   grade_6                         57.0 63.0                       120.0                         57 63                 120
1751570 1751570 IN     school 1807680 25   North Adams Community Schools 180768001313 33 Bellmont Middle School   Regular School No Middle 06 08 2019   grade_7                         43.0 56.0                       99.0                         43 56                 99
1751571 1751571 IN     school 1807680 25   North Adams Community Schools 180768001313 33 Bellmont Middle School   Regular School No Middle 06 08 2019   grade_8                         52.0 64.0                       116.0                         52 64                 116
1751572 1751572 IN     school 1807680 25   North Adams Community Schools 180768001313 33 Bellmont Middle School   Regular School No Middle 06 08 2019   pk_12_total 273.0 11.0 34.0 1.0   2.0     1.0   13.0   152.0 183.0     3.0         179.0   52.0   335.0 273 11 34 1   2     1   13   152 183     3     179 52   335
1751573 1751573 IN     school 1807680 25   North Adams Community Schools 180768001316 37 Bellmont Elementary   Regular School No Elementary PK 05 2019   grade_1                         51.0 44.0                       95.0                         51 44                 95
1751574 1751574 IN     school 1807680 25   North Adams Community Schools 180768001316 37 Bellmont Elementary   Regular School No Elementary PK 05 2019   grade_2                         49.0 55.0                       104.0                         49 55                 104
1751575 1751575 IN     school 1807680 25   North Adams Community Schools 180768001316 37 Bellmont Elementary   Regular School No Elementary PK 05 2019   grade_3                         70.0 46.0                       116.0                         70 46                 116
1751576 1751576 IN     school 1807680 25   North Adams Community Schools 180768001316 37 Bellmont Elementary   Regular School No Elementary PK 05 2019   grade_4                         62.0 59.0                       121.0                         62 59                 121
1751577 1751577 IN     school 1807680 25   North Adams Community Schools 180768001316 37 Bellmont Elementary   Regular School No Elementary PK 05 2019   grade_5                         56.0 67.0                       123.0                         56 67                 123
1751578 1751578 IN     school 1807680 25   North Adams Community Schools 180768001316 37 Bellmont Elementary   Regular School No Elementary PK 05 2019   kindergarten                         59.0 63.0                       122.0                         59 63                 122
1751579 1751579 IN     school 1807680 25   North Adams Community Schools 180768001316 37 Bellmont Elementary   Regular School No Elementary PK 05 2019   pk_12_total 597.0 31.0 69.0     6.0     2.0   48.0   388.0 365.0     4.0         471.0   138.0   753.0 597 31 69     6     2   48   388 365     4     471 138   753
1751580 1751580 IN     school 1807680 25   North Adams Community Schools 180768001316 37 Bellmont Elementary   Regular School No Elementary PK 05 2019   pre_kindergarten                         41.0 31.0                       72.0                         41 31                 72
1751581 1751581 IN     school 1810260 35   South Adams Schools 181026001641 17 South Adams Middle School   Regular School No Middle 06 08 2019   grade_6                         47.0 49.0                       96.0                         47 49                 96
1751582 1751582 IN     school 1810260 35   South Adams Schools 181026001641 17 South Adams Middle School   Regular School No Middle 06 08 2019   grade_7                         46.0 56.0                       102.0                         46 56                 102
1751583 1751583 IN     school 1810260 35   South Adams Schools 181026001641 17 South Adams Middle School   Regular School No Middle 06 08 2019   grade_8                         42.0 38.0                       80.0                         42 38                 80
1751584 1751584 IN     school 1810260 35   South Adams Schools 181026001641 17 South Adams Middle School   Regular School No Middle 06 08 2019   pk_12_total 226.0 3.0 39.0     6.0         4.0   135.0 143.0     17.0         117.0   38.0   278.0 226 3 39     6         4   135 143     17     117 38   278
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
1751591 1751591 IN     school 1810260 35   South Adams Schools 181026001640 25 South Adams Elementary School   Regular School No Elementary PK 05 2019   grade_1                         45.0 40.0                       85.0                         45 40                 85

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