enrollments

Data source: Big Local News · About: Big Local

12,019 rows where state = "IN" and year = 2018 sorted by ccd_school_type

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

year ✖

  • 2018 · 12,019 ✖
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
1787852 1787852 IN     school   255   East Allen County Schools   318 EACS Early Childhood Preschool             2018   pk_12_total 36.0 4.0 6.0     2.0             32.0 16.0     0.0         24.0   43.0   48.0 36 4 6     2             32 16     0     24 43   48
1787853 1787853 IN     school   255   East Allen County Schools   318 EACS Early Childhood Preschool             2018   pre_kindergarten                         32.0 16.0                       48.0                         32 16                 48
1790091 1790091 IN     school   2865   Marion Community Schools   2416 Grant County Comm Justice Center             2018   grade_10                         1.0 0.0                       1.0                         1 0                 1
1790092 1790092 IN     school   2865   Marion Community Schools   2416 Grant County Comm Justice Center             2018   pk_12_total 1.0                       1.0 0.0     0.0             0.0   1.0 1                       1 0     0       0   1
1793997 1793997 IN     school   5375   M S D Wayne Township   5271 Sanders School             2018   grade_1                         2.0 2.0                       4.0                         2 2                 4
1793998 1793998 IN     school   5375   M S D Wayne Township   5271 Sanders School             2018   grade_10                         12.0 1.0                       13.0                         12 1                 13
1793999 1793999 IN     school   5375   M S D Wayne Township   5271 Sanders School             2018   grade_11                         8.0 0.0                       8.0                         8 0                 8
1794000 1794000 IN     school   5375   M S D Wayne Township   5271 Sanders School             2018   grade_12                         5.0 0.0                       5.0                         5 0                 5
1794001 1794001 IN     school   5375   M S D Wayne Township   5271 Sanders School             2018   grade_2                         7.0 0.0                       7.0                         7 0                 7
1794002 1794002 IN     school   5375   M S D Wayne Township   5271 Sanders School             2018   grade_3                         3.0 0.0                       3.0                         3 0                 3
1794003 1794003 IN     school   5375   M S D Wayne Township   5271 Sanders School             2018   grade_4                         11.0 2.0                       13.0                         11 2                 13
1794004 1794004 IN     school   5375   M S D Wayne Township   5271 Sanders School             2018   grade_5                         5.0 2.0                       7.0                         5 2                 7
1794005 1794005 IN     school   5375   M S D Wayne Township   5271 Sanders School             2018   grade_6                         5.0 1.0                       6.0                         5 1                 6
1794006 1794006 IN     school   5375   M S D Wayne Township   5271 Sanders School             2018   grade_7                         4.0 1.0                       5.0                         4 1                 5
1794007 1794007 IN     school   5375   M S D Wayne Township   5271 Sanders School             2018   grade_8                         7.0 1.0                       8.0                         7 1                 8
1794008 1794008 IN     school   5375   M S D Wayne Township   5271 Sanders School             2018   grade_9                         10.0 1.0                       11.0                         10 1                 11
1794009 1794009 IN     school   5375   M S D Wayne Township   5271 Sanders School             2018   kindergarten                         1.0 0.0                       1.0                         1 0                 1
1794010 1794010 IN     school   5375   M S D Wayne Township   5271 Sanders School             2018   pk_12_total 46.0 30.0 7.0               8.0   80.0 11.0     6.0         58.0   88.0   91.0 46 30 7               8   80 11     6     58 88   91
1796657 1796657 IN     school   7205   South Bend Community School Corp   7605 South Bend SNAP             2018   pk_12_total 90.0 38.0 33.0               17.0   120.0 58.0     0.0         87.0   119.0   178.0 90 38 33               17   120 58     0     87 119   178
1796658 1796658 IN     school   7205   South Bend Community School Corp   7605 South Bend SNAP             2018   pre_kindergarten                         120.0 58.0                       178.0                         120 58                 178
1787460 1787460 IN     school 1808250 225   Northwest Allen County Schools 180825002160 145 Allen Co Youth Services Center   Alternative School No Secondary 08 11 2018   grade_10                         2.0 1.0                       3.0                         2 1                 3
1787461 1787461 IN     school 1808250 225   Northwest Allen County Schools 180825002160 145 Allen Co Youth Services Center   Alternative School No Secondary 08 11 2018   grade_11                         1.0 1.0                       2.0                         1 1                 2
1787462 1787462 IN     school 1808250 225   Northwest Allen County Schools 180825002160 145 Allen Co Youth Services Center   Alternative School No Secondary 08 11 2018   grade_8                         0.0 3.0                       3.0                         0 3                 3
1787463 1787463 IN     school 1808250 225   Northwest Allen County Schools 180825002160 145 Allen Co Youth Services Center   Alternative School No Secondary 08 11 2018   grade_9                         0.0 1.0                       1.0                         0 1                 1
1787464 1787464 IN     school 1808250 225   Northwest Allen County Schools 180825002160 145 Allen Co Youth Services Center   Alternative School No Secondary 08 11 2018   pk_12_total 8.0 1.0                     3.0 6.0     0.0         9.0   2.0   9.0 8 1                     3 6     0     9 2   9
1788505 1788505 IN     school 1803940 1010   Greater Clark County Schools 180394000839 891 Clark County Middle/High School   Alternative School No High 07 12 2018   grade_10                         10.0 2.0                       12.0                         10 2                 12
1788506 1788506 IN     school 1803940 1010   Greater Clark County Schools 180394000839 891 Clark County Middle/High School   Alternative School No High 07 12 2018   grade_11                         17.0 6.0                       23.0                         17 6                 23
1788507 1788507 IN     school 1803940 1010   Greater Clark County Schools 180394000839 891 Clark County Middle/High School   Alternative School No High 07 12 2018   grade_12                         16.0 17.0                       33.0                         16 17                 33
1788508 1788508 IN     school 1803940 1010   Greater Clark County Schools 180394000839 891 Clark County Middle/High School   Alternative School No High 07 12 2018   grade_7                         3.0 2.0                       5.0                         3 2                 5
1788509 1788509 IN     school 1803940 1010   Greater Clark County Schools 180394000839 891 Clark County Middle/High School   Alternative School No High 07 12 2018   grade_8                         7.0 0.0                       7.0                         7 0                 7
1788510 1788510 IN     school 1803940 1010   Greater Clark County Schools 180394000839 891 Clark County Middle/High School   Alternative School No High 07 12 2018   grade_9                         6.0 1.0                       7.0                         6 1                 7
1788511 1788511 IN     school 1803940 1010   Greater Clark County Schools 180394000839 891 Clark County Middle/High School   Alternative School No High 07 12 2018   pk_12_total 43.0 28.0 4.0               12.0   59.0 28.0     1.0         50.0   4.0   87.0 43 28 4               12   59 28     1     50 4   87
1789151 1789151 IN     school 1807320 1970   Muncie Community Schools 180732001232 1524 Youth Opportunity Center   Alternative School No Other 03 12 2018   grade_10                         23.0 14.0                       37.0                         23 14                 37
1789152 1789152 IN     school 1807320 1970   Muncie Community Schools 180732001232 1524 Youth Opportunity Center   Alternative School No Other 03 12 2018   grade_11                         17.0 6.0                       23.0                         17 6                 23
1789153 1789153 IN     school 1807320 1970   Muncie Community Schools 180732001232 1524 Youth Opportunity Center   Alternative School No Other 03 12 2018   grade_12                         3.0 4.0                       7.0                         3 4                 7
1789154 1789154 IN     school 1807320 1970   Muncie Community Schools 180732001232 1524 Youth Opportunity Center   Alternative School No Other 03 12 2018   grade_3                         1.0 0.0                       1.0                         1 0                 1
1789155 1789155 IN     school 1807320 1970   Muncie Community Schools 180732001232 1524 Youth Opportunity Center   Alternative School No Other 03 12 2018   grade_4                         1.0 0.0                       1.0                         1 0                 1
1789156 1789156 IN     school 1807320 1970   Muncie Community Schools 180732001232 1524 Youth Opportunity Center   Alternative School No Other 03 12 2018   grade_5                         3.0 2.0                       5.0                         3 2                 5
1789157 1789157 IN     school 1807320 1970   Muncie Community Schools 180732001232 1524 Youth Opportunity Center   Alternative School No Other 03 12 2018   grade_6                         6.0 1.0                       7.0                         6 1                 7
1789158 1789158 IN     school 1807320 1970   Muncie Community Schools 180732001232 1524 Youth Opportunity Center   Alternative School No Other 03 12 2018   grade_7                         6.0 2.0                       8.0                         6 2                 8
1789159 1789159 IN     school 1807320 1970   Muncie Community Schools 180732001232 1524 Youth Opportunity Center   Alternative School No Other 03 12 2018   grade_8                         10.0 1.0                       11.0                         10 1                 11
1789160 1789160 IN     school 1807320 1970   Muncie Community Schools 180732001232 1524 Youth Opportunity Center   Alternative School No Other 03 12 2018   grade_9                         21.0 9.0                       30.0                         21 9                 30
1789161 1789161 IN     school 1807320 1970   Muncie Community Schools 180732001232 1524 Youth Opportunity Center   Alternative School No Other 03 12 2018   pk_12_total 84.0 22.0 7.0 2.0   1.0     1.0   13.0   91.0 39.0     5.0         129.0   72.0   130.0 84 22 7 2   1     1   13   91 39     5     129 72   130
1791391 1791391 IN     school 1801050 3695   Brownstown Cnt Com Sch Corp 180105001408 3108 Jackson Co Juvenile Detention Cntr   Alternative School No High 08 12 2018   adult                         1.0 0.0                       1.0                         1 0                 1
1791392 1791392 IN     school 1801050 3695   Brownstown Cnt Com Sch Corp 180105001408 3108 Jackson Co Juvenile Detention Cntr   Alternative School No High 08 12 2018   grade_10                         0.0 2.0                       2.0                         0 2                 2
1791393 1791393 IN     school 1801050 3695   Brownstown Cnt Com Sch Corp 180105001408 3108 Jackson Co Juvenile Detention Cntr   Alternative School No High 08 12 2018   grade_11                         2.0 0.0                       2.0                         2 0                 2
1791394 1791394 IN     school 1801050 3695   Brownstown Cnt Com Sch Corp 180105001408 3108 Jackson Co Juvenile Detention Cntr   Alternative School No High 08 12 2018   grade_12                         3.0 0.0                       3.0                         3 0                 3
1791395 1791395 IN     school 1801050 3695   Brownstown Cnt Com Sch Corp 180105001408 3108 Jackson Co Juvenile Detention Cntr   Alternative School No High 08 12 2018   grade_8                         1.0 0.0                       1.0                         1 0                 1
1791396 1791396 IN     school 1801050 3695   Brownstown Cnt Com Sch Corp 180105001408 3108 Jackson Co Juvenile Detention Cntr   Alternative School No High 08 12 2018   grade_9                         1.0 1.0                       2.0                         1 1                 2
1791397 1791397 IN     school 1801050 3695   Brownstown Cnt Com Sch Corp 180105001408 3108 Jackson Co Juvenile Detention Cntr   Alternative School No High 08 12 2018   pk_12_total 8.0     1.0             2.0   8.0 3.0     0.0             1.0   11.0 8     1             2   8 3     0       1   11
1793290 1793290 IN     school 1800150 5275   Anderson Community School Corp 180015002623 4906 COMPASS Alternative School   Alternative School No Middle 06 09 2018   grade_6                         8.0 3.0                       11.0                         8 3                 11
1793291 1793291 IN     school 1800150 5275   Anderson Community School Corp 180015002623 4906 COMPASS Alternative School   Alternative School No Middle 06 09 2018   grade_7                         24.0 4.0                       28.0                         24 4                 28
1793292 1793292 IN     school 1800150 5275   Anderson Community School Corp 180015002623 4906 COMPASS Alternative School   Alternative School No Middle 06 09 2018   grade_8                         14.0 7.0                       21.0                         14 7                 21
1793293 1793293 IN     school 1800150 5275   Anderson Community School Corp 180015002623 4906 COMPASS Alternative School   Alternative School No Middle 06 09 2018   grade_9                         12.0 5.0                       17.0                         12 5                 17
1793294 1793294 IN     school 1800150 5275   Anderson Community School Corp 180015002623 4906 COMPASS Alternative School   Alternative School No Middle 06 09 2018   pk_12_total 26.0 32.0 10.0               9.0   58.0 19.0     3.0         76.0   22.0   77.0 26 32 10               9   58 19     3     76 22   77
1796675 1796675 IN     school 1810290 7205   South Bend Community School Corp 181029000898 7632 Juvenile Justice Center   Alternative School No High 08 12 2018   grade_10                         5.0 2.0                       7.0                         5 2                 7
1796676 1796676 IN     school 1810290 7205   South Bend Community School Corp 181029000898 7632 Juvenile Justice Center   Alternative School No High 08 12 2018   grade_12                         2.0 0.0                       2.0                         2 0                 2
1796677 1796677 IN     school 1810290 7205   South Bend Community School Corp 181029000898 7632 Juvenile Justice Center   Alternative School No High 08 12 2018   grade_8                         1.0 1.0                       2.0                         1 1                 2
1796678 1796678 IN     school 1810290 7205   South Bend Community School Corp 181029000898 7632 Juvenile Justice Center   Alternative School No High 08 12 2018   grade_9                         3.0 0.0                       3.0                         3 0                 3
1796679 1796679 IN     school 1810290 7205   South Bend Community School Corp 181029000898 7632 Juvenile Justice Center   Alternative School No High 08 12 2018   pk_12_total 4.0 5.0 1.0     1.0         3.0   11.0 3.0     0.0         6.0   3.0   14.0 4 5 1     1         3   11 3     0     6 3   14
1797840 1797840 IN     school 1812090 8030   Vigo County School Corp 181209002344 8611 Booker T Washington Alt Sch   Alternative School No High 09 12 2018   grade_10                         1.0 14.0                       15.0                         1 14                 15
1797841 1797841 IN     school 1812090 8030   Vigo County School Corp 181209002344 8611 Booker T Washington Alt Sch   Alternative School No High 09 12 2018   grade_11                         5.0 10.0                       15.0                         5 10                 15
1797842 1797842 IN     school 1812090 8030   Vigo County School Corp 181209002344 8611 Booker T Washington Alt Sch   Alternative School No High 09 12 2018   grade_12                         3.0 18.0                       21.0                         3 18                 21
1797843 1797843 IN     school 1812090 8030   Vigo County School Corp 181209002344 8611 Booker T Washington Alt Sch   Alternative School No High 09 12 2018   grade_9                         2.0 2.0                       4.0                         2 2                 4
1797844 1797844 IN     school 1812090 8030   Vigo County School Corp 181209002344 8611 Booker T Washington Alt Sch   Alternative School No High 09 12 2018   pk_12_total 46.0 1.0 4.0 1.0             3.0   11.0 44.0     0.0         42.0   15.0   55.0 46 1 4 1             3   11 44     0     42 15   55
1787287 1787287 IN     school 1800060 15   Adams Central Community Schools 180006000008 13 Adams Central Middle School   Regular School No Middle 06 08 2018   grade_6                         51.0 51.0                       102.0                         51 51                 102
1787288 1787288 IN     school 1800060 15   Adams Central Community Schools 180006000008 13 Adams Central Middle School   Regular School No Middle 06 08 2018   grade_7                         49.0 33.0                       82.0                         49 33                 82
1787289 1787289 IN     school 1800060 15   Adams Central Community Schools 180006000008 13 Adams Central Middle School   Regular School No Middle 06 08 2018   grade_8                         41.0 42.0                       83.0                         41 42                 83
1787290 1787290 IN     school 1800060 15   Adams Central Community Schools 180006000008 13 Adams Central Middle School   Regular School No Middle 06 08 2018   pk_12_total 251.0 3.0 10.0     2.0         1.0   141.0 126.0     1.0         63.0   16.0   267.0 251 3 10     2         1   141 126     1     63 16   267
1787291 1787291 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2018   grade_1                         59.0 42.0                       101.0                         59 42                 101
1787292 1787292 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2018   grade_2                         52.0 42.0                       94.0                         52 42                 94
1787293 1787293 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2018   grade_3                         56.0 50.0                       106.0                         56 50                 106
1787294 1787294 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2018   grade_4                         63.0 38.0                       101.0                         63 38                 101
1787295 1787295 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2018   grade_5                         51.0 57.0                       108.0                         51 57                 108
1787296 1787296 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2018   kindergarten                         59.0 63.0                       122.0                         59 63                 122
1787297 1787297 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2018   pk_12_total 586.0 6.0 25.0 1.0   5.0         13.0   341.0 295.0     22.0         172.0   106.0   636.0 586 6 25 1   5         13   341 295     22     172 106   636
1787298 1787298 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2018   pre_kindergarten                         1.0 3.0                       4.0                         1 3                 4
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
1787305 1787305 IN     school 1807680 25   North Adams Community Schools 180768001314 29 Bellmont Senior High School   Regular School No High 09 12 2018   grade_10                         83.0 91.0                       174.0                         83 91                 174
1787306 1787306 IN     school 1807680 25   North Adams Community Schools 180768001314 29 Bellmont Senior High School   Regular School No High 09 12 2018   grade_11                         91.0 89.0                       180.0                         91 89                 180
1787307 1787307 IN     school 1807680 25   North Adams Community Schools 180768001314 29 Bellmont Senior High School   Regular School No High 09 12 2018   grade_12                         75.0 71.0                       146.0                         75 71                 146
1787308 1787308 IN     school 1807680 25   North Adams Community Schools 180768001314 29 Bellmont Senior High School   Regular School No High 09 12 2018   grade_9                         86.0 88.0                       174.0                         86 88                 174
1787309 1787309 IN     school 1807680 25   North Adams Community Schools 180768001314 29 Bellmont Senior High School   Regular School No High 09 12 2018   pk_12_total 558.0 9.0 82.0 5.0   4.0         16.0   335.0 339.0     3.0         232.0   56.0   674.0 558 9 82 5   4         16   335 339     3     232 56   674
1787310 1787310 IN     school 1807680 25   North Adams Community Schools 180768001313 33 Bellmont Middle School   Regular School No Middle 05 08 2018   grade_5                         55.0 61.0                       116.0                         55 61                 116
1787311 1787311 IN     school 1807680 25   North Adams Community Schools 180768001313 33 Bellmont Middle School   Regular School No Middle 05 08 2018   grade_6                         49.0 51.0                       100.0                         49 51                 100
1787312 1787312 IN     school 1807680 25   North Adams Community Schools 180768001313 33 Bellmont Middle School   Regular School No Middle 05 08 2018   grade_7                         49.0 59.0                       108.0                         49 59                 108
1787313 1787313 IN     school 1807680 25   North Adams Community Schools 180768001313 33 Bellmont Middle School   Regular School No Middle 05 08 2018   grade_8                         69.0 57.0                       126.0                         69 57                 126
1787314 1787314 IN     school 1807680 25   North Adams Community Schools 180768001313 33 Bellmont Middle School   Regular School No Middle 05 08 2018   pk_12_total 364.0 11.0 50.0 1.0   3.0     1.0   20.0   222.0 228.0     2.0         251.0   89.0   450.0 364 11 50 1   3     1   20   222 228     2     251 89   450
1787315 1787315 IN     school 1807680 25   North Adams Community Schools 180768001316 37 Bellmont Elementary   Regular School No Elementary 02 04 2018   grade_2                         71.0 52.0                       123.0                         71 52                 123
1787316 1787316 IN     school 1807680 25   North Adams Community Schools 180768001316 37 Bellmont Elementary   Regular School No Elementary 02 04 2018   grade_3                         62.0 66.0                       128.0                         62 66                 128
1787317 1787317 IN     school 1807680 25   North Adams Community Schools 180768001316 37 Bellmont Elementary   Regular School No Elementary 02 04 2018   grade_4                         58.0 67.0                       125.0                         58 67                 125
1787318 1787318 IN     school 1807680 25   North Adams Community Schools 180768001316 37 Bellmont Elementary   Regular School No Elementary 02 04 2018   pk_12_total 301.0 13.0 39.0     3.0     2.0   18.0   191.0 185.0     0.0         251.0   81.0   376.0 301 13 39     3     2   18   191 185     0     251 81   376
1787319 1787319 IN     school 1807680 25   North Adams Community Schools 180768001317 41 Southeast Elementary School   Regular School No Elementary PK 01 2018   grade_1                         51.0 56.0                       107.0                         51 56                 107
1787320 1787320 IN     school 1807680 25   North Adams Community Schools 180768001317 41 Southeast Elementary School   Regular School No Elementary PK 01 2018   kindergarten                         65.0 46.0                       111.0                         65 46                 111
1787321 1787321 IN     school 1807680 25   North Adams Community Schools 180768001317 41 Southeast Elementary School   Regular School No Elementary PK 01 2018   pk_12_total 222.0 13.0 35.0     1.0         17.0   148.0 140.0     1.0         191.0   50.0   288.0 222 13 35     1         17   148 140     1     191 50   288

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