enrollments

Data source: Big Local News · About: Big Local

12,058 rows where state = "IN" and year = 2017 sorted by ccd_school_type

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

year ✖

  • 2017 · 12,058 ✖
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
1293484 1293484 IN     school   255   East Allen County Schools   318 Park Hill Learning Center             2017   pk_12_total 47.0 7.0 6.0     1.0         1.0   37.0 25.0     0.0             47.0   62.0 47 7 6     1         1   37 25     0       47   62
1293485 1293485 IN     school   255   East Allen County Schools   318 Park Hill Learning Center             2017   pre_kindergarten                         37.0 25.0                       62.0                         37 25                 62
1299669 1299669 IN     school   5375   M S D Wayne Township   5271 Sanders School             2017   grade_1                         3.0 0.0                       3.0                         3 0                 3
1299670 1299670 IN     school   5375   M S D Wayne Township   5271 Sanders School             2017   grade_10                         8.0 0.0                       8.0                         8 0                 8
1299671 1299671 IN     school   5375   M S D Wayne Township   5271 Sanders School             2017   grade_11                         5.0 0.0                       5.0                         5 0                 5
1299672 1299672 IN     school   5375   M S D Wayne Township   5271 Sanders School             2017   grade_12                         6.0 1.0                       7.0                         6 1                 7
1299673 1299673 IN     school   5375   M S D Wayne Township   5271 Sanders School             2017   grade_2                         6.0 0.0                       6.0                         6 0                 6
1299674 1299674 IN     school   5375   M S D Wayne Township   5271 Sanders School             2017   grade_3                         6.0 1.0                       7.0                         6 1                 7
1299675 1299675 IN     school   5375   M S D Wayne Township   5271 Sanders School             2017   grade_4                         5.0 1.0                       6.0                         5 1                 6
1299676 1299676 IN     school   5375   M S D Wayne Township   5271 Sanders School             2017   grade_5                         7.0 1.0                       8.0                         7 1                 8
1299677 1299677 IN     school   5375   M S D Wayne Township   5271 Sanders School             2017   grade_6                         4.0 1.0                       5.0                         4 1                 5
1299678 1299678 IN     school   5375   M S D Wayne Township   5271 Sanders School             2017   grade_7                         10.0 2.0                       12.0                         10 2                 12
1299679 1299679 IN     school   5375   M S D Wayne Township   5271 Sanders School             2017   grade_8                         6.0 1.0                       7.0                         6 1                 7
1299680 1299680 IN     school   5375   M S D Wayne Township   5271 Sanders School             2017   grade_9                         19.0 1.0                       20.0                         19 1                 20
1299681 1299681 IN     school   5375   M S D Wayne Township   5271 Sanders School             2017   kindergarten                         1.0 2.0                       3.0                         1 2                 3
1299682 1299682 IN     school   5375   M S D Wayne Township   5271 Sanders School             2017   pk_12_total 48.0 35.0 6.0               8.0   86.0 11.0     5.0             89.0   97.0 48 35 6               8   86 11     5       89   97
1302344 1302344 IN     school   7205   South Bend Community School Corp   7605 South Bend SNAP             2017   pk_12_total 95.0 28.0 26.0               8.0   102.0 55.0     0.0             113.0   157.0 95 28 26               8   102 55     0       113   157
1302345 1302345 IN     school   7205   South Bend Community School Corp   7605 South Bend SNAP             2017   pre_kindergarten                         102.0 55.0                       157.0                         102 55                 157
1293087 1293087 IN     school 1808250 225   Northwest Allen County Schools 180825002160 145 Allen Co Youth Services Center   Alternative School No Other 05 11 2017   grade_10                         1.0 3.0                       4.0                         1 3                 4
1293088 1293088 IN     school 1808250 225   Northwest Allen County Schools 180825002160 145 Allen Co Youth Services Center   Alternative School No Other 05 11 2017   grade_11                         2.0 0.0                       2.0                         2 0                 2
1293089 1293089 IN     school 1808250 225   Northwest Allen County Schools 180825002160 145 Allen Co Youth Services Center   Alternative School No Other 05 11 2017   grade_5                         1.0 0.0                       1.0                         1 0                 1
1293090 1293090 IN     school 1808250 225   Northwest Allen County Schools 180825002160 145 Allen Co Youth Services Center   Alternative School No Other 05 11 2017   grade_6                         0.0 1.0                       1.0                         0 1                 1
1293091 1293091 IN     school 1808250 225   Northwest Allen County Schools 180825002160 145 Allen Co Youth Services Center   Alternative School No Other 05 11 2017   grade_8                         1.0 1.0                       2.0                         1 1                 2
1293092 1293092 IN     school 1808250 225   Northwest Allen County Schools 180825002160 145 Allen Co Youth Services Center   Alternative School No Other 05 11 2017   grade_9                         0.0 2.0                       2.0                         0 2                 2
1293093 1293093 IN     school 1808250 225   Northwest Allen County Schools 180825002160 145 Allen Co Youth Services Center   Alternative School No Other 05 11 2017   pk_12_total 2.0 4.0 4.0               2.0   5.0 7.0     1.0             2.0   12.0 2 4 4               2   5 7     1       2   12
1294147 1294147 IN     school 1803940 1010   Greater Clark County Schools 180394000839 891 Clark County Middle/High School   Alternative School No Other 06 12 2017   grade_10                         11.0 6.0                       17.0                         11 6                 17
1294148 1294148 IN     school 1803940 1010   Greater Clark County Schools 180394000839 891 Clark County Middle/High School   Alternative School No Other 06 12 2017   grade_11                         24.0 16.0                       40.0                         24 16                 40
1294149 1294149 IN     school 1803940 1010   Greater Clark County Schools 180394000839 891 Clark County Middle/High School   Alternative School No Other 06 12 2017   grade_12                         19.0 24.0                       43.0                         19 24                 43
1294150 1294150 IN     school 1803940 1010   Greater Clark County Schools 180394000839 891 Clark County Middle/High School   Alternative School No Other 06 12 2017   grade_6                         1.0 0.0                       1.0                         1 0                 1
1294151 1294151 IN     school 1803940 1010   Greater Clark County Schools 180394000839 891 Clark County Middle/High School   Alternative School No Other 06 12 2017   grade_7                         5.0 0.0                       5.0                         5 0                 5
1294152 1294152 IN     school 1803940 1010   Greater Clark County Schools 180394000839 891 Clark County Middle/High School   Alternative School No Other 06 12 2017   grade_8                         4.0 4.0                       8.0                         4 4                 8
1294153 1294153 IN     school 1803940 1010   Greater Clark County Schools 180394000839 891 Clark County Middle/High School   Alternative School No Other 06 12 2017   grade_9                         5.0 0.0                       5.0                         5 0                 5
1294154 1294154 IN     school 1803940 1010   Greater Clark County Schools 180394000839 891 Clark County Middle/High School   Alternative School No Other 06 12 2017   pk_12_total 82.0 16.0 10.0               11.0   69.0 50.0     2.0             1.0   119.0 82 16 10               11   69 50     2       1   119
1294807 1294807 IN     school 1807320 1970   Muncie Community Schools 180732001232 1524 Youth Opportunity Center   Alternative School No Other 02 12 2017   grade_10                         18.0 10.0                       28.0                         18 10                 28
1294808 1294808 IN     school 1807320 1970   Muncie Community Schools 180732001232 1524 Youth Opportunity Center   Alternative School No Other 02 12 2017   grade_11                         11.0 10.0                       21.0                         11 10                 21
1294809 1294809 IN     school 1807320 1970   Muncie Community Schools 180732001232 1524 Youth Opportunity Center   Alternative School No Other 02 12 2017   grade_12                         2.0 4.0                       6.0                         2 4                 6
1294810 1294810 IN     school 1807320 1970   Muncie Community Schools 180732001232 1524 Youth Opportunity Center   Alternative School No Other 02 12 2017   grade_2                         1.0 0.0                       1.0                         1 0                 1
1294811 1294811 IN     school 1807320 1970   Muncie Community Schools 180732001232 1524 Youth Opportunity Center   Alternative School No Other 02 12 2017   grade_3                         2.0 0.0                       2.0                         2 0                 2
1294812 1294812 IN     school 1807320 1970   Muncie Community Schools 180732001232 1524 Youth Opportunity Center   Alternative School No Other 02 12 2017   grade_4                         2.0 0.0                       2.0                         2 0                 2
1294813 1294813 IN     school 1807320 1970   Muncie Community Schools 180732001232 1524 Youth Opportunity Center   Alternative School No Other 02 12 2017   grade_5                         4.0 2.0                       6.0                         4 2                 6
1294814 1294814 IN     school 1807320 1970   Muncie Community Schools 180732001232 1524 Youth Opportunity Center   Alternative School No Other 02 12 2017   grade_7                         5.0 4.0                       9.0                         5 4                 9
1294815 1294815 IN     school 1807320 1970   Muncie Community Schools 180732001232 1524 Youth Opportunity Center   Alternative School No Other 02 12 2017   grade_8                         12.0 10.0                       22.0                         12 10                 22
1294816 1294816 IN     school 1807320 1970   Muncie Community Schools 180732001232 1524 Youth Opportunity Center   Alternative School No Other 02 12 2017   grade_9                         16.0 11.0                       27.0                         16 11                 27
1294817 1294817 IN     school 1807320 1970   Muncie Community Schools 180732001232 1524 Youth Opportunity Center   Alternative School No Other 02 12 2017   pk_12_total 84.0 25.0 4.0     1.0         10.0   73.0 51.0     2.0             49.0   124.0 84 25 4     1         10   73 51     2       49   124
1297034 1297034 IN     school 1801050 3695   Brownstown Cnt Com Sch Corp 180105001408 3108 Jackson Co Juvenile Detention Cntr   Alternative School No Other 10 10 2017   grade_10                         1.0 0.0                       1.0                         1 0                 1
1297035 1297035 IN     school 1801050 3695   Brownstown Cnt Com Sch Corp 180105001408 3108 Jackson Co Juvenile Detention Cntr   Alternative School No Other 10 10 2017   pk_12_total   1.0                     1.0 0.0     0.0             0.0   1.0   1                     1 0     0       0   1
1302361 1302361 IN     school 1810290 7205   South Bend Community School Corp 181029000898 7632 Juvenile Justice Center   Alternative School No High 07 12 2017   grade_10                         9.0 1.0                       10.0                         9 1                 10
1302362 1302362 IN     school 1810290 7205   South Bend Community School Corp 181029000898 7632 Juvenile Justice Center   Alternative School No High 07 12 2017   grade_11                         5.0 0.0                       5.0                         5 0                 5
1302363 1302363 IN     school 1810290 7205   South Bend Community School Corp 181029000898 7632 Juvenile Justice Center   Alternative School No High 07 12 2017   grade_12                         4.0 1.0                       5.0                         4 1                 5
1302364 1302364 IN     school 1810290 7205   South Bend Community School Corp 181029000898 7632 Juvenile Justice Center   Alternative School No High 07 12 2017   grade_7                         1.0 0.0                       1.0                         1 0                 1
1302365 1302365 IN     school 1810290 7205   South Bend Community School Corp 181029000898 7632 Juvenile Justice Center   Alternative School No High 07 12 2017   grade_8                         1.0 0.0                       1.0                         1 0                 1
1302366 1302366 IN     school 1810290 7205   South Bend Community School Corp 181029000898 7632 Juvenile Justice Center   Alternative School No High 07 12 2017   grade_9                         3.0 0.0                       3.0                         3 0                 3
1302367 1302367 IN     school 1810290 7205   South Bend Community School Corp 181029000898 7632 Juvenile Justice Center   Alternative School No High 07 12 2017   pk_12_total 11.0 9.0 4.0               1.0   23.0 2.0     0.0             4.0   25.0 11 9 4               1   23 2     0       4   25
1303521 1303521 IN     school 1812090 8030   Vigo County School Corp 181209002344 8611 Booker T Washington Alt Sch   Alternative School No High 09 12 2017   grade_10                         2.0 5.0                       7.0                         2 5                 7
1303522 1303522 IN     school 1812090 8030   Vigo County School Corp 181209002344 8611 Booker T Washington Alt Sch   Alternative School No High 09 12 2017   grade_11                         1.0 11.0                       12.0                         1 11                 12
1303523 1303523 IN     school 1812090 8030   Vigo County School Corp 181209002344 8611 Booker T Washington Alt Sch   Alternative School No High 09 12 2017   grade_12                         1.0 23.0                       24.0                         1 23                 24
1303524 1303524 IN     school 1812090 8030   Vigo County School Corp 181209002344 8611 Booker T Washington Alt Sch   Alternative School No High 09 12 2017   grade_9                         0.0 4.0                       4.0                         0 4                 4
1303525 1303525 IN     school 1812090 8030   Vigo County School Corp 181209002344 8611 Booker T Washington Alt Sch   Alternative School No High 09 12 2017   pk_12_total 40.0 1.0 1.0               5.0   4.0 43.0     0.0             10.0   47.0 40 1 1               5   4 43     0       10   47
1304461 1304461 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 IN Sch for the Blind & Vis Imprd   Alternative School No Other PK 12 2017   adult                         18.0 6.0                       24.0                         18 6                 24
1304462 1304462 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 IN Sch for the Blind & Vis Imprd   Alternative School No Other PK 12 2017   grade_1                         3.0 1.0                       4.0                         3 1                 4
1304463 1304463 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 IN Sch for the Blind & Vis Imprd   Alternative School No Other PK 12 2017   grade_10                         7.0 2.0                       9.0                         7 2                 9
1304464 1304464 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 IN Sch for the Blind & Vis Imprd   Alternative School No Other PK 12 2017   grade_11                         10.0 5.0                       15.0                         10 5                 15
1304465 1304465 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 IN Sch for the Blind & Vis Imprd   Alternative School No Other PK 12 2017   grade_12                         5.0 9.0                       14.0                         5 9                 14
1304466 1304466 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 IN Sch for the Blind & Vis Imprd   Alternative School No Other PK 12 2017   grade_2                         4.0 3.0                       7.0                         4 3                 7
1304467 1304467 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 IN Sch for the Blind & Vis Imprd   Alternative School No Other PK 12 2017   grade_3                         2.0 2.0                       4.0                         2 2                 4
1304468 1304468 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 IN Sch for the Blind & Vis Imprd   Alternative School No Other PK 12 2017   grade_4                         3.0 2.0                       5.0                         3 2                 5
1304469 1304469 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 IN Sch for the Blind & Vis Imprd   Alternative School No Other PK 12 2017   grade_5                         3.0 3.0                       6.0                         3 3                 6
1304470 1304470 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 IN Sch for the Blind & Vis Imprd   Alternative School No Other PK 12 2017   grade_6                         7.0 2.0                       9.0                         7 2                 9
1304471 1304471 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 IN Sch for the Blind & Vis Imprd   Alternative School No Other PK 12 2017   grade_7                         3.0 3.0                       6.0                         3 3                 6
1304472 1304472 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 IN Sch for the Blind & Vis Imprd   Alternative School No Other PK 12 2017   grade_8                         2.0 5.0                       7.0                         2 5                 7
1304473 1304473 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 IN Sch for the Blind & Vis Imprd   Alternative School No Other PK 12 2017   grade_9                         11.0 8.0                       19.0                         11 8                 19
1304474 1304474 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 IN Sch for the Blind & Vis Imprd   Alternative School No Other PK 12 2017   kindergarten                         2.0 1.0                       3.0                         2 1                 3
1304475 1304475 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 IN Sch for the Blind & Vis Imprd   Alternative School No Other PK 12 2017   pk_12_total 86.0 29.0 12.0     2.0         9.0   84.0 54.0     1.0             137.0   138.0 86 29 12     2         9   84 54     1       137   138
1304476 1304476 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 IN Sch for the Blind & Vis Imprd   Alternative School No Other PK 12 2017   pre_kindergarten                         4.0 2.0                       6.0                         4 2                 6
1304477 1304477 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Alternative School No Other PK 12 2017   grade_1                         5.0 4.0                       9.0                         5 4                 9
1304478 1304478 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Alternative School No Other PK 12 2017   grade_10                         19.0 9.0                       28.0                         19 9                 28
1304479 1304479 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Alternative School No Other PK 12 2017   grade_11                         14.0 8.0                       22.0                         14 8                 22
1304480 1304480 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Alternative School No Other PK 12 2017   grade_12                         23.0 10.0                       33.0                         23 10                 33
1304481 1304481 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Alternative School No Other PK 12 2017   grade_2                         6.0 4.0                       10.0                         6 4                 10
1304482 1304482 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Alternative School No Other PK 12 2017   grade_3                         5.0 10.0                       15.0                         5 10                 15
1304483 1304483 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Alternative School No Other PK 12 2017   grade_4                         5.0 7.0                       12.0                         5 7                 12
1304484 1304484 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Alternative School No Other PK 12 2017   grade_5                         9.0 14.0                       23.0                         9 14                 23
1304485 1304485 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Alternative School No Other PK 12 2017   grade_6                         8.0 7.0                       15.0                         8 7                 15
1304486 1304486 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Alternative School No Other PK 12 2017   grade_7                         4.0 10.0                       14.0                         4 10                 14
1304487 1304487 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Alternative School No Other PK 12 2017   grade_8                         8.0 13.0                       21.0                         8 13                 21
1304488 1304488 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Alternative School No Other PK 12 2017   grade_9                         16.0 16.0                       32.0                         16 16                 32
1304489 1304489 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Alternative School No Other PK 12 2017   kindergarten                         12.0 13.0                       25.0                         12 13                 25
1304490 1304490 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Alternative School No Other PK 12 2017   pk_12_total 175.0 36.0 39.0 1.0   10.0         14.0   137.0 138.0     30.0             270.0   275.0 175 36 39 1   10         14   137 138     30       270   275
1304491 1304491 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Alternative School No Other PK 12 2017   pre_kindergarten                         3.0 13.0                       16.0                         3 13                 16
1292914 1292914 IN     school 1800060 15   Adams Central Community Schools 180006000008 13 Adams Central Middle School   Regular School No Middle 06 08 2017   grade_6                         50.0 36.0                       86.0                         50 36                 86
1292915 1292915 IN     school 1800060 15   Adams Central Community Schools 180006000008 13 Adams Central Middle School   Regular School No Middle 06 08 2017   grade_7                         38.0 42.0                       80.0                         38 42                 80
1292916 1292916 IN     school 1800060 15   Adams Central Community Schools 180006000008 13 Adams Central Middle School   Regular School No Middle 06 08 2017   grade_8                         48.0 55.0                       103.0                         48 55                 103
1292917 1292917 IN     school 1800060 15   Adams Central Community Schools 180006000008 13 Adams Central Middle School   Regular School No Middle 06 08 2017   pk_12_total 253.0 3.0 6.0 1.0   3.0         3.0   136.0 133.0     5.0             16.0   269.0 253 3 6 1   3         3   136 133     5       16   269
1292918 1292918 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2017   grade_1                         54.0 40.0                       94.0                         54 40                 94
1292919 1292919 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2017   grade_2                         53.0 52.0                       105.0                         53 52                 105
1292920 1292920 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2017   grade_3                         63.0 38.0                       101.0                         63 38                 101
1292921 1292921 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2017   grade_4                         51.0 52.0                       103.0                         51 52                 103
1292922 1292922 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2017   grade_5                         50.0 51.0                       101.0                         50 51                 101
1292923 1292923 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2017   kindergarten                         62.0 42.0                       104.0                         62 42                 104
1292924 1292924 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary School   Regular School No Elementary PK 05 2017   pk_12_total 566.0 8.0 25.0     4.0         9.0   335.0 277.0     22.0             88.0   612.0 566 8 25     4         9   335 277     22       88   612

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