enrollments

Data source: Big Local News · About: Big Local

12,044 rows where state = "IN" and year = 2015 sorted by ccd_school_type

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

year ✖

  • 2015 · 12,044 ✖
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
1160035 1160035 IN     school   255   East Allen County Schools   318 Park Hill Learning Center             2015   pk_12_total 34.0 11.0 5.0     1.0         2.0   37.0 16.0     0.0             47.0   53.0 34 11 5     1         2   37 16     0       47   53
1160036 1160036 IN     school   255   East Allen County Schools   318 Park Hill Learning Center             2015   pre_kindergarten                         37.0 16.0                       53.0                         37 16                 53
1166230 1166230 IN     school   5375   M S D Wayne Township   5271 Sanders School             2015   grade_1                         2.0 1.0                       3.0                         2 1                 3
1166231 1166231 IN     school   5375   M S D Wayne Township   5271 Sanders School             2015   grade_10                         8.0 2.0                       10.0                         8 2                 10
1166232 1166232 IN     school   5375   M S D Wayne Township   5271 Sanders School             2015   grade_11                         4.0 2.0                       6.0                         4 2                 6
1166233 1166233 IN     school   5375   M S D Wayne Township   5271 Sanders School             2015   grade_12                         7.0 1.0                       8.0                         7 1                 8
1166234 1166234 IN     school   5375   M S D Wayne Township   5271 Sanders School             2015   grade_2                         2.0 1.0                       3.0                         2 1                 3
1166235 1166235 IN     school   5375   M S D Wayne Township   5271 Sanders School             2015   grade_3                         4.0 0.0                       4.0                         4 0                 4
1166236 1166236 IN     school   5375   M S D Wayne Township   5271 Sanders School             2015   grade_4                         5.0 1.0                       6.0                         5 1                 6
1166237 1166237 IN     school   5375   M S D Wayne Township   5271 Sanders School             2015   grade_5                         9.0 1.0                       10.0                         9 1                 10
1166238 1166238 IN     school   5375   M S D Wayne Township   5271 Sanders School             2015   grade_6                         7.0 0.0                       7.0                         7 0                 7
1166239 1166239 IN     school   5375   M S D Wayne Township   5271 Sanders School             2015   grade_7                         11.0 1.0                       12.0                         11 1                 12
1166240 1166240 IN     school   5375   M S D Wayne Township   5271 Sanders School             2015   grade_8                         6.0 0.0                       6.0                         6 0                 6
1166241 1166241 IN     school   5375   M S D Wayne Township   5271 Sanders School             2015   grade_9                         8.0 0.0                       8.0                         8 0                 8
1166242 1166242 IN     school   5375   M S D Wayne Township   5271 Sanders School             2015   kindergarten                         2.0 0.0                       2.0                         2 0                 2
1166243 1166243 IN     school   5375   M S D Wayne Township   5271 Sanders School             2015   pk_12_total 43.0 25.0 8.0               9.0   75.0 10.0     7.0             83.0   85.0 43 25 8               9   75 10     7       83   85
1167334 1167334 IN     school   5855   Crawfordsville Com Schools   6305 Anna Willson School             2015   pk_12_total 95.0 4.0 36.0     1.0         1.0   86.0 51.0     0.0             70.0   137.0 95 4 36     1         1   86 51     0       70   137
1167335 1167335 IN     school   5855   Crawfordsville Com Schools   6305 Anna Willson School             2015   pre_kindergarten                         86.0 51.0                       137.0                         86 51                 137
1168294 1168294 IN     school   6720   Old National Trail Spec Serv Coop   7034 Old Nat'l Trail Sp Srvs             2015   adult                         4.0 3.0                       7.0                         4 3                 7
1168295 1168295 IN     school   6720   Old National Trail Spec Serv Coop   7034 Old Nat'l Trail Sp Srvs             2015   grade_10                         3.0 4.0                       7.0                         3 4                 7
1168296 1168296 IN     school   6720   Old National Trail Spec Serv Coop   7034 Old Nat'l Trail Sp Srvs             2015   grade_11                         1.0 4.0                       5.0                         1 4                 5
1168297 1168297 IN     school   6720   Old National Trail Spec Serv Coop   7034 Old Nat'l Trail Sp Srvs             2015   grade_12                         3.0 1.0                       4.0                         3 1                 4
1168298 1168298 IN     school   6720   Old National Trail Spec Serv Coop   7034 Old Nat'l Trail Sp Srvs             2015   grade_9                         4.0 1.0                       5.0                         4 1                 5
1168299 1168299 IN     school   6720   Old National Trail Spec Serv Coop   7034 Old Nat'l Trail Sp Srvs             2015   pk_12_total 28.0                       15.0 13.0                       28.0 28                       15 13                 28
1168929 1168929 IN     school   7205   South Bend Community Sch Corp   7605 South Bend SNAP             2015   pk_12_total 94.0 34.0 11.0 1.0             13.0   114.0 39.0     0.0             97.0   153.0 94 34 11 1             13   114 39     0       97   153
1168930 1168930 IN     school   7205   South Bend Community Sch Corp   7605 South Bend SNAP             2015   pre_kindergarten                         114.0 39.0                       153.0                         114 39                 153
1159634 1159634 IN     school 1808250 225   Northwest Allen County Schools 180825002160 145 Allen Co Youth Services Ctr   Alternative Education School No 4.0 04 11 2015   grade_10                         3.0 0.0                       3.0                         3 0                 3
1159635 1159635 IN     school 1808250 225   Northwest Allen County Schools 180825002160 145 Allen Co Youth Services Ctr   Alternative Education School No 4.0 04 11 2015   grade_11                         2.0 2.0                       4.0                         2 2                 4
1159636 1159636 IN     school 1808250 225   Northwest Allen County Schools 180825002160 145 Allen Co Youth Services Ctr   Alternative Education School No 4.0 04 11 2015   grade_4                         2.0 0.0                       2.0                         2 0                 2
1159637 1159637 IN     school 1808250 225   Northwest Allen County Schools 180825002160 145 Allen Co Youth Services Ctr   Alternative Education School No 4.0 04 11 2015   grade_6                         2.0 0.0                       2.0                         2 0                 2
1159638 1159638 IN     school 1808250 225   Northwest Allen County Schools 180825002160 145 Allen Co Youth Services Ctr   Alternative Education School No 4.0 04 11 2015   grade_9                         0.0 1.0                       1.0                         0 1                 1
1159639 1159639 IN     school 1808250 225   Northwest Allen County Schools 180825002160 145 Allen Co Youth Services Ctr   Alternative Education School No 4.0 04 11 2015   pk_12_total 8.0 1.0 1.0               2.0   9.0 3.0     0.0             5.0   12.0 8 1 1               2   9 3     0       5   12
1160687 1160687 IN     school 1803940 1010   Greater Clark County Schools 180394000839 891 Clark County Middle/High School   Alternative Education School No 3.0 07 12 2015   grade_10                         9.0 8.0                       17.0                         9 8                 17
1160688 1160688 IN     school 1803940 1010   Greater Clark County Schools 180394000839 891 Clark County Middle/High School   Alternative Education School No 3.0 07 12 2015   grade_11                         11.0 5.0                       16.0                         11 5                 16
1160689 1160689 IN     school 1803940 1010   Greater Clark County Schools 180394000839 891 Clark County Middle/High School   Alternative Education School No 3.0 07 12 2015   grade_12                         20.0 16.0                       36.0                         20 16                 36
1160690 1160690 IN     school 1803940 1010   Greater Clark County Schools 180394000839 891 Clark County Middle/High School   Alternative Education School No 3.0 07 12 2015   grade_7                         4.0 4.0                       8.0                         4 4                 8
1160691 1160691 IN     school 1803940 1010   Greater Clark County Schools 180394000839 891 Clark County Middle/High School   Alternative Education School No 3.0 07 12 2015   grade_8                         8.0 5.0                       13.0                         8 5                 13
1160692 1160692 IN     school 1803940 1010   Greater Clark County Schools 180394000839 891 Clark County Middle/High School   Alternative Education School No 3.0 07 12 2015   grade_9                         7.0 8.0                       15.0                         7 8                 15
1160693 1160693 IN     school 1803940 1010   Greater Clark County Schools 180394000839 891 Clark County Middle/High School   Alternative Education School No 3.0 07 12 2015   pk_12_total 58.0 36.0 6.0               5.0   59.0 46.0     3.0             5.0   105.0 58 36 6               5   59 46     3       5   105
1161368 1161368 IN     school 1807320 1970   Muncie Community Schools 180732001232 1524 Youth Opportunity Center   Alternative Education School No 4.0 03 12 2015   grade_10                         13.0 9.0                       22.0                         13 9                 22
1161369 1161369 IN     school 1807320 1970   Muncie Community Schools 180732001232 1524 Youth Opportunity Center   Alternative Education School No 4.0 03 12 2015   grade_11                         6.0 5.0                       11.0                         6 5                 11
1161370 1161370 IN     school 1807320 1970   Muncie Community Schools 180732001232 1524 Youth Opportunity Center   Alternative Education School No 4.0 03 12 2015   grade_12                         2.0 2.0                       4.0                         2 2                 4
1161371 1161371 IN     school 1807320 1970   Muncie Community Schools 180732001232 1524 Youth Opportunity Center   Alternative Education School No 4.0 03 12 2015   grade_3                         0.0 1.0                       1.0                         0 1                 1
1161372 1161372 IN     school 1807320 1970   Muncie Community Schools 180732001232 1524 Youth Opportunity Center   Alternative Education School No 4.0 03 12 2015   grade_4                         2.0 0.0                       2.0                         2 0                 2
1161373 1161373 IN     school 1807320 1970   Muncie Community Schools 180732001232 1524 Youth Opportunity Center   Alternative Education School No 4.0 03 12 2015   grade_5                         6.0 1.0                       7.0                         6 1                 7
1161374 1161374 IN     school 1807320 1970   Muncie Community Schools 180732001232 1524 Youth Opportunity Center   Alternative Education School No 4.0 03 12 2015   grade_6                         7.0 2.0                       9.0                         7 2                 9
1161375 1161375 IN     school 1807320 1970   Muncie Community Schools 180732001232 1524 Youth Opportunity Center   Alternative Education School No 4.0 03 12 2015   grade_7                         3.0 2.0                       5.0                         3 2                 5
1161376 1161376 IN     school 1807320 1970   Muncie Community Schools 180732001232 1524 Youth Opportunity Center   Alternative Education School No 4.0 03 12 2015   grade_8                         14.0 4.0                       18.0                         14 4                 18
1161377 1161377 IN     school 1807320 1970   Muncie Community Schools 180732001232 1524 Youth Opportunity Center   Alternative Education School No 4.0 03 12 2015   grade_9                         18.0 10.0                       28.0                         18 10                 28
1161378 1161378 IN     school 1807320 1970   Muncie Community Schools 180732001232 1524 Youth Opportunity Center   Alternative Education School No 4.0 03 12 2015   pk_12_total 70.0 20.0 6.0 1.0   1.0         9.0   71.0 36.0     3.0             53.0   107.0 70 20 6 1   1         9   71 36     3       53   107
1168949 1168949 IN     school 1810290 7205   South Bend Community Sch Corp 181029000898 7632 Juvenile Justice Center   Alternative Education School No 3.0 07 12 2015   grade_10                         6.0 1.0                       7.0                         6 1                 7
1168950 1168950 IN     school 1810290 7205   South Bend Community Sch Corp 181029000898 7632 Juvenile Justice Center   Alternative Education School No 3.0 07 12 2015   grade_11                         3.0 0.0                       3.0                         3 0                 3
1168951 1168951 IN     school 1810290 7205   South Bend Community Sch Corp 181029000898 7632 Juvenile Justice Center   Alternative Education School No 3.0 07 12 2015   grade_12                         2.0 1.0                       3.0                         2 1                 3
1168952 1168952 IN     school 1810290 7205   South Bend Community Sch Corp 181029000898 7632 Juvenile Justice Center   Alternative Education School No 3.0 07 12 2015   grade_7                         1.0 0.0                       1.0                         1 0                 1
1168953 1168953 IN     school 1810290 7205   South Bend Community Sch Corp 181029000898 7632 Juvenile Justice Center   Alternative Education School No 3.0 07 12 2015   grade_8                         1.0 0.0                       1.0                         1 0                 1
1168954 1168954 IN     school 1810290 7205   South Bend Community Sch Corp 181029000898 7632 Juvenile Justice Center   Alternative Education School No 3.0 07 12 2015   grade_9                         1.0 0.0                       1.0                         1 0                 1
1168955 1168955 IN     school 1810290 7205   South Bend Community Sch Corp 181029000898 7632 Juvenile Justice Center   Alternative Education School No 3.0 07 12 2015   pk_12_total 4.0 6.0 3.0               3.0   14.0 2.0     0.0             4.0   16.0 4 6 3               3   14 2     0       4   16
1170111 1170111 IN     school 1812090 8030   Vigo County School Corp 181209002344 8611 Booker T Washington Alt Sch   Alternative Education School No 3.0 09 12 2015   grade_10                         0.0 8.0                       8.0                         0 8                 8
1170112 1170112 IN     school 1812090 8030   Vigo County School Corp 181209002344 8611 Booker T Washington Alt Sch   Alternative Education School No 3.0 09 12 2015   grade_11                         1.0 13.0                       14.0                         1 13                 14
1170113 1170113 IN     school 1812090 8030   Vigo County School Corp 181209002344 8611 Booker T Washington Alt Sch   Alternative Education School No 3.0 09 12 2015   grade_12                         0.0 13.0                       13.0                         0 13                 13
1170114 1170114 IN     school 1812090 8030   Vigo County School Corp 181209002344 8611 Booker T Washington Alt Sch   Alternative Education School No 3.0 09 12 2015   grade_9                         0.0 1.0                       1.0                         0 1                 1
1170115 1170115 IN     school 1812090 8030   Vigo County School Corp 181209002344 8611 Booker T Washington Alt Sch   Alternative Education School No 3.0 09 12 2015   pk_12_total 31.0 2.0 1.0 1.0             1.0   1.0 35.0     0.0             8.0   36.0 31 2 1 1             1   1 35     0       8   36
1171051 1171051 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 Indiana School For The Blind   Alternative Education School No 4.0 PK 12 2015   adult                         11.0 8.0                       19.0                         11 8                 19
1171052 1171052 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 Indiana School For The Blind   Alternative Education School No 4.0 PK 12 2015   grade_1                         5.0 0.0                       5.0                         5 0                 5
1171053 1171053 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 Indiana School For The Blind   Alternative Education School No 4.0 PK 12 2015   grade_10                         6.0 10.0                       16.0                         6 10                 16
1171054 1171054 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 Indiana School For The Blind   Alternative Education School No 4.0 PK 12 2015   grade_11                         6.0 6.0                       12.0                         6 6                 12
1171055 1171055 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 Indiana School For The Blind   Alternative Education School No 4.0 PK 12 2015   grade_12                         14.0 6.0                       20.0                         14 6                 20
1171056 1171056 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 Indiana School For The Blind   Alternative Education School No 4.0 PK 12 2015   grade_2                         2.0 0.0                       2.0                         2 0                 2
1171057 1171057 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 Indiana School For The Blind   Alternative Education School No 4.0 PK 12 2015   grade_3                         2.0 3.0                       5.0                         2 3                 5
1171058 1171058 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 Indiana School For The Blind   Alternative Education School No 4.0 PK 12 2015   grade_4                         8.0 1.0                       9.0                         8 1                 9
1171059 1171059 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 Indiana School For The Blind   Alternative Education School No 4.0 PK 12 2015   grade_5                         3.0 5.0                       8.0                         3 5                 8
1171060 1171060 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 Indiana School For The Blind   Alternative Education School No 4.0 PK 12 2015   grade_6                         0.0 3.0                       3.0                         0 3                 3
1171061 1171061 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 Indiana School For The Blind   Alternative Education School No 4.0 PK 12 2015   grade_7                         10.0 8.0                       18.0                         10 8                 18
1171062 1171062 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 Indiana School For The Blind   Alternative Education School No 4.0 PK 12 2015   grade_8                         8.0 0.0                       8.0                         8 0                 8
1171063 1171063 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 Indiana School For The Blind   Alternative Education School No 4.0 PK 12 2015   grade_9                         6.0 3.0                       9.0                         6 3                 9
1171064 1171064 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 Indiana School For The Blind   Alternative Education School No 4.0 PK 12 2015   kindergarten                         3.0 3.0                       6.0                         3 3                 6
1171065 1171065 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 Indiana School For The Blind   Alternative Education School No 4.0 PK 12 2015   pk_12_total                         87.0 59.0                       146.0                         87 59                 146
1171066 1171066 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 Indiana School For The Blind   Alternative Education School No 4.0 PK 12 2015   pre_kindergarten                         3.0 3.0                       6.0                         3 3                 6
1171067 1171067 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Alternative Education School No 4.0 PK 12 2015   grade_1                         2.0 9.0                       11.0                         2 9                 11
1171068 1171068 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Alternative Education School No 4.0 PK 12 2015   grade_10                         22.0 11.0                       33.0                         22 11                 33
1171069 1171069 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Alternative Education School No 4.0 PK 12 2015   grade_11                         12.0 7.0                       19.0                         12 7                 19
1171070 1171070 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Alternative Education School No 4.0 PK 12 2015   grade_12                         25.0 18.0                       43.0                         25 18                 43
1171071 1171071 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Alternative Education School No 4.0 PK 12 2015   grade_2                         10.0 11.0                       21.0                         10 11                 21
1171072 1171072 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Alternative Education School No 4.0 PK 12 2015   grade_3                         11.0 11.0                       22.0                         11 11                 22
1171073 1171073 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Alternative Education School No 4.0 PK 12 2015   grade_4                         7.0 9.0                       16.0                         7 9                 16
1171074 1171074 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Alternative Education School No 4.0 PK 12 2015   grade_5                         7.0 15.0                       22.0                         7 15                 22
1171075 1171075 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Alternative Education School No 4.0 PK 12 2015   grade_6                         12.0 14.0                       26.0                         12 14                 26
1171076 1171076 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Alternative Education School No 4.0 PK 12 2015   grade_7                         15.0 14.0                       29.0                         15 14                 29
1171077 1171077 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Alternative Education School No 4.0 PK 12 2015   grade_8                         21.0 9.0                       30.0                         21 9                 30
1171078 1171078 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Alternative Education School No 4.0 PK 12 2015   grade_9                         14.0 8.0                       22.0                         14 8                 22
1171079 1171079 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Alternative Education School No 4.0 PK 12 2015   kindergarten                         7.0 5.0                       12.0                         7 5                 12
1171080 1171080 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Alternative Education School No 4.0 PK 12 2015   pk_12_total                         183.0 161.0                       344.0                         183 161                 344
1171081 1171081 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Alternative Education School No 4.0 PK 12 2015   pre_kindergarten                         18.0 20.0                       38.0                         18 20                 38
1159462 1159462 IN     school 1800060 15   Adams Central Community Schools 180006000008 13 Adams Central Middle School   Regular School No 2.0 06 08 2015   grade_6                         45.0 55.0                       100.0                         45 55                 100
1159463 1159463 IN     school 1800060 15   Adams Central Community Schools 180006000008 13 Adams Central Middle School   Regular School No 2.0 06 08 2015   grade_7                         42.0 48.0                       90.0                         42 48                 90
1159464 1159464 IN     school 1800060 15   Adams Central Community Schools 180006000008 13 Adams Central Middle School   Regular School No 2.0 06 08 2015   grade_8                         46.0 48.0                       94.0                         46 48                 94
1159465 1159465 IN     school 1800060 15   Adams Central Community Schools 180006000008 13 Adams Central Middle School   Regular School No 2.0 06 08 2015   pk_12_total 274.0 1.0 5.0     2.0         2.0   133.0 151.0     4.0             19.0   284.0 274 1 5     2         2   133 151     4       19   284
1159466 1159466 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary Sch   Regular School No 1.0 KG 05 2015   grade_1                         63.0 40.0                       103.0                         63 40                 103
1159467 1159467 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary Sch   Regular School No 1.0 KG 05 2015   grade_2                         50.0 50.0                       100.0                         50 50                 100
1159468 1159468 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary Sch   Regular School No 1.0 KG 05 2015   grade_3                         50.0 53.0                       103.0                         50 53                 103

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