enrollments

Data source: Big Local News · About: Big Local

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

✎ 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
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
1159469 1159469 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary Sch   Regular School No 1.0 KG 05 2015   grade_4                         52.0 35.0                       87.0                         52 35                 87
1159470 1159470 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary Sch   Regular School No 1.0 KG 05 2015   grade_5                         38.0 40.0                       78.0                         38 40                 78
1159471 1159471 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary Sch   Regular School No 1.0 KG 05 2015   kindergarten                         54.0 54.0                       108.0                         54 54                 108
1159472 1159472 IN     school 1800060 15   Adams Central Community Schools 180006000006 20 Adams Central Elementary Sch   Regular School No 1.0 KG 05 2015   pk_12_total 551.0 7.0 13.0     4.0         4.0   307.0 272.0     30.0             81.0   579.0 551 7 13     4         4   307 272     30       81   579
1159489 1159489 IN     school 1807680 25   North Adams Community Schools 180768001316 37 Northwest Elementary   Regular School No 1.0 02 04 2015   grade_2                         54.0 59.0                       113.0                         54 59                 113
1159490 1159490 IN     school 1807680 25   North Adams Community Schools 180768001316 37 Northwest Elementary   Regular School No 1.0 02 04 2015   grade_3                         54.0 48.0                       102.0                         54 48                 102
1159491 1159491 IN     school 1807680 25   North Adams Community Schools 180768001316 37 Northwest Elementary   Regular School No 1.0 02 04 2015   grade_4                         42.0 62.0                       104.0                         42 62                 104
1159492 1159492 IN     school 1807680 25   North Adams Community Schools 180768001316 37 Northwest Elementary   Regular School No 1.0 02 04 2015   pk_12_total 262.0 4.0 39.0 1.0         1.0   12.0   150.0 169.0     4.0             74.0   319.0 262 4 39 1         1   12   150 169     4       74   319
1159493 1159493 IN     school 1807680 25   North Adams Community Schools 180768001317 41 Southeast Elementary School   Regular School No 1.0 PK 01 2015   grade_1                         59.0 62.0                       121.0                         59 62                 121
1159494 1159494 IN     school 1807680 25   North Adams Community Schools 180768001317 41 Southeast Elementary School   Regular School No 1.0 PK 01 2015   kindergarten                         65.0 55.0                       120.0                         65 55                 120
1159495 1159495 IN     school 1807680 25   North Adams Community Schools 180768001317 41 Southeast Elementary School   Regular School No 1.0 PK 01 2015   pk_12_total 240.0 6.0 34.0     2.0     2.0   7.0   154.0 137.0     0.0             40.0   291.0 240 6 34     2     2   7   154 137     0       40   291
1159496 1159496 IN     school 1807680 25   North Adams Community Schools 180768001317 41 Southeast Elementary School   Regular School No 1.0 PK 01 2015   pre_kindergarten                         30.0 20.0                       50.0                         30 20                 50
1159507 1159507 IN     school 1810260 35   South Adams Schools 181026001640 25 South Adams Elem School   Regular School No 1.0 PK 05 2015   grade_1                         39.0 54.0                       93.0                         39 54                 93
1159508 1159508 IN     school 1810260 35   South Adams Schools 181026001640 25 South Adams Elem School   Regular School No 1.0 PK 05 2015   grade_2                         44.0 48.0                       92.0                         44 48                 92
1159509 1159509 IN     school 1810260 35   South Adams Schools 181026001640 25 South Adams Elem School   Regular School No 1.0 PK 05 2015   grade_3                         39.0 52.0                       91.0                         39 52                 91
1159510 1159510 IN     school 1810260 35   South Adams Schools 181026001640 25 South Adams Elem School   Regular School No 1.0 PK 05 2015   grade_4                         50.0 51.0                       101.0                         50 51                 101
1159511 1159511 IN     school 1810260 35   South Adams Schools 181026001640 25 South Adams Elem School   Regular School No 1.0 PK 05 2015   grade_5                         51.0 48.0                       99.0                         51 48                 99
1159512 1159512 IN     school 1810260 35   South Adams Schools 181026001640 25 South Adams Elem School   Regular School No 1.0 PK 05 2015   kindergarten                         40.0 43.0                       83.0                         40 43                 83
1159513 1159513 IN     school 1810260 35   South Adams Schools 181026001640 25 South Adams Elem School   Regular School No 1.0 PK 05 2015   pk_12_total 511.0 2.0 73.0 2.0   6.0         12.0   294.0 312.0     61.0             104.0   606.0 511 2 73 2   6         12   294 312     61       104   606
1159514 1159514 IN     school 1810260 35   South Adams Schools 181026001640 25 South Adams Elem School   Regular School No 1.0 PK 05 2015   pre_kindergarten                         31.0 16.0                       47.0                         31 16                 47
1159515 1159515 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No 1.0 KG 05 2015   grade_1                         27.0 28.0                       55.0                         27 28                 55
1159516 1159516 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No 1.0 KG 05 2015   grade_2                         55.0 42.0                       97.0                         55 42                 97
1159517 1159517 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No 1.0 KG 05 2015   grade_3                         57.0 47.0                       104.0                         57 47                 104
1159518 1159518 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No 1.0 KG 05 2015   grade_4                         52.0 54.0                       106.0                         52 54                 106
1159519 1159519 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No 1.0 KG 05 2015   grade_5                         59.0 64.0                       123.0                         59 64                 123
1159520 1159520 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No 1.0 KG 05 2015   kindergarten                         30.0 21.0                       51.0                         30 21                 51
1159521 1159521 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000001 45 Aboite Elementary School   Regular School No 1.0 KG 05 2015   pk_12_total 431.0 10.0 24.0     41.0     2.0   28.0   280.0 256.0     3.0             11.0   536.0 431 10 24     41     2   28   280 256     3       11   536
1159522 1159522 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000083 46 Whispering Meadow Elem Sch   Regular School No 1.0 PK 05 2015   grade_1                         43.0 38.0                       81.0                         43 38                 81
1159523 1159523 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000083 46 Whispering Meadow Elem Sch   Regular School No 1.0 PK 05 2015   grade_2                         34.0 45.0                       79.0                         34 45                 79
1159524 1159524 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000083 46 Whispering Meadow Elem Sch   Regular School No 1.0 PK 05 2015   grade_3                         27.0 40.0                       67.0                         27 40                 67
1159525 1159525 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000083 46 Whispering Meadow Elem Sch   Regular School No 1.0 PK 05 2015   grade_4                         33.0 34.0                       67.0                         33 34                 67
1159526 1159526 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000083 46 Whispering Meadow Elem Sch   Regular School No 1.0 PK 05 2015   grade_5                         34.0 38.0                       72.0                         34 38                 72
1159527 1159527 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000083 46 Whispering Meadow Elem Sch   Regular School No 1.0 PK 05 2015   kindergarten                         38.0 36.0                       74.0                         38 36                 74
1159528 1159528 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000083 46 Whispering Meadow Elem Sch   Regular School No 1.0 PK 05 2015   pk_12_total 323.0 31.0 31.0     45.0     3.0   32.0   226.0 239.0     36.0             46.0   465.0 323 31 31     45     3   32   226 239     36       46   465
1159529 1159529 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000083 46 Whispering Meadow Elem Sch   Regular School No 1.0 PK 05 2015   pre_kindergarten                         17.0 8.0                       25.0                         17 8                 25
1159539 1159539 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002044 64 Lafayette Meadow School   Regular School No 1.0 KG 05 2015   grade_1                         54.0 32.0                       86.0                         54 32                 86
1159540 1159540 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002044 64 Lafayette Meadow School   Regular School No 1.0 KG 05 2015   grade_2                         44.0 37.0                       81.0                         44 37                 81
1159541 1159541 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002044 64 Lafayette Meadow School   Regular School No 1.0 KG 05 2015   grade_3                         36.0 43.0                       79.0                         36 43                 79
1159542 1159542 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002044 64 Lafayette Meadow School   Regular School No 1.0 KG 05 2015   grade_4                         38.0 35.0                       73.0                         38 35                 73
1159543 1159543 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002044 64 Lafayette Meadow School   Regular School No 1.0 KG 05 2015   grade_5                         58.0 42.0                       100.0                         58 42                 100
1159544 1159544 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002044 64 Lafayette Meadow School   Regular School No 1.0 KG 05 2015   kindergarten                         52.0 45.0                       97.0                         52 45                 97
1159545 1159545 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002044 64 Lafayette Meadow School   Regular School No 1.0 KG 05 2015   pk_12_total 457.0 16.0 17.0 4.0   12.0         10.0   282.0 234.0     3.0             32.0   516.0 457 16 17 4   12         10   282 234     3       32   516
1159550 1159550 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002186 68 Haverhill Elementary School   Regular School No 1.0 KG 05 2015   grade_1                         27.0 31.0                       58.0                         27 31                 58
1159551 1159551 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002186 68 Haverhill Elementary School   Regular School No 1.0 KG 05 2015   grade_2                         26.0 28.0                       54.0                         26 28                 54
1159552 1159552 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002186 68 Haverhill Elementary School   Regular School No 1.0 KG 05 2015   grade_3                         31.0 37.0                       68.0                         31 37                 68
1159553 1159553 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002186 68 Haverhill Elementary School   Regular School No 1.0 KG 05 2015   grade_4                         31.0 31.0                       62.0                         31 31                 62
1159554 1159554 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002186 68 Haverhill Elementary School   Regular School No 1.0 KG 05 2015   grade_5                         31.0 34.0                       65.0                         31 34                 65
1159555 1159555 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002186 68 Haverhill Elementary School   Regular School No 1.0 KG 05 2015   kindergarten                         41.0 29.0                       70.0                         41 29                 70
1159556 1159556 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002186 68 Haverhill Elementary School   Regular School No 1.0 KG 05 2015   pk_12_total 337.0 11.0 11.0 2.0   1.0         15.0   187.0 190.0     4.0             39.0   377.0 337 11 11 2   1         15   187 190     4       39   377
1159557 1159557 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002329 71 Deer Ridge Elementary   Regular School No 1.0 KG 05 2015   grade_1                         28.0 34.0                       62.0                         28 34                 62
1159558 1159558 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002329 71 Deer Ridge Elementary   Regular School No 1.0 KG 05 2015   grade_2                         39.0 41.0                       80.0                         39 41                 80
1159559 1159559 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002329 71 Deer Ridge Elementary   Regular School No 1.0 KG 05 2015   grade_3                         39.0 24.0                       63.0                         39 24                 63
1159560 1159560 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002329 71 Deer Ridge Elementary   Regular School No 1.0 KG 05 2015   grade_4                         35.0 36.0                       71.0                         35 36                 71
1159561 1159561 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002329 71 Deer Ridge Elementary   Regular School No 1.0 KG 05 2015   grade_5                         42.0 38.0                       80.0                         42 38                 80
1159562 1159562 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002329 71 Deer Ridge Elementary   Regular School No 1.0 KG 05 2015   kindergarten                         31.0 37.0                       68.0                         31 37                 68
1159563 1159563 IN     school 1800030 125   M S D Southwest Allen County Schls 180003002329 71 Deer Ridge Elementary   Regular School No 1.0 KG 05 2015   pk_12_total 365.0 14.0 12.0 2.0   20.0         11.0   214.0 210.0     5.0             33.0   424.0 365 14 12 2   20         11   214 210     5       33   424
1159564 1159564 IN     school 1800030 125   M S D Southwest Allen County Schls 180003001810 72 Covington Elementary School   Regular School No 1.0 KG 05 2015   grade_1                         53.0 70.0                       123.0                         53 70                 123
1159565 1159565 IN     school 1800030 125   M S D Southwest Allen County Schls 180003001810 72 Covington Elementary School   Regular School No 1.0 KG 05 2015   grade_2                         58.0 59.0                       117.0                         58 59                 117
1159566 1159566 IN     school 1800030 125   M S D Southwest Allen County Schls 180003001810 72 Covington Elementary School   Regular School No 1.0 KG 05 2015   grade_3                         54.0 62.0                       116.0                         54 62                 116
1159567 1159567 IN     school 1800030 125   M S D Southwest Allen County Schls 180003001810 72 Covington Elementary School   Regular School No 1.0 KG 05 2015   grade_4                         71.0 55.0                       126.0                         71 55                 126
1159568 1159568 IN     school 1800030 125   M S D Southwest Allen County Schls 180003001810 72 Covington Elementary School   Regular School No 1.0 KG 05 2015   grade_5                         75.0 78.0                       153.0                         75 78                 153
1159569 1159569 IN     school 1800030 125   M S D Southwest Allen County Schls 180003001810 72 Covington Elementary School   Regular School No 1.0 KG 05 2015   kindergarten                         68.0 55.0                       123.0                         68 55                 123
1159570 1159570 IN     school 1800030 125   M S D Southwest Allen County Schls 180003001810 72 Covington Elementary School   Regular School No 1.0 KG 05 2015   pk_12_total 580.0 72.0 36.0 2.0   32.0         36.0   379.0 379.0     7.0             61.0   758.0 580 72 36 2   32         36   379 379     7       61   758
1159571 1159571 IN     school 1808250 225   Northwest Allen County Schools 180825001413 69 Arcola School   Regular School No 1.0 KG 05 2015   grade_1                         12.0 16.0                       28.0                         12 16                 28
1159572 1159572 IN     school 1808250 225   Northwest Allen County Schools 180825001413 69 Arcola School   Regular School No 1.0 KG 05 2015   grade_2                         14.0 18.0                       32.0                         14 18                 32
1159573 1159573 IN     school 1808250 225   Northwest Allen County Schools 180825001413 69 Arcola School   Regular School No 1.0 KG 05 2015   grade_3                         13.0 12.0                       25.0                         13 12                 25
1159574 1159574 IN     school 1808250 225   Northwest Allen County Schools 180825001413 69 Arcola School   Regular School No 1.0 KG 05 2015   grade_4                         13.0 19.0                       32.0                         13 19                 32
1159575 1159575 IN     school 1808250 225   Northwest Allen County Schools 180825001413 69 Arcola School   Regular School No 1.0 KG 05 2015   grade_5                         17.0 8.0                       25.0                         17 8                 25
1159576 1159576 IN     school 1808250 225   Northwest Allen County Schools 180825001413 69 Arcola School   Regular School No 1.0 KG 05 2015   kindergarten                         19.0 11.0                       30.0                         19 11                 30
1159577 1159577 IN     school 1808250 225   Northwest Allen County Schools 180825001413 69 Arcola School   Regular School No 1.0 KG 05 2015   pk_12_total 144.0 4.0 15.0 3.0             6.0   88.0 84.0     3.0             26.0   172.0 144 4 15 3             6   88 84     3       26   172
1159582 1159582 IN     school 1808250 225   Northwest Allen County Schools 180825000937 87 Hickory Center Elementary Sch   Regular School No 1.0 KG 05 2015   grade_1                         30.0 41.0                       71.0                         30 41                 71

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