Data source: Big Local News · About: Big Local

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

View and edit SQL

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 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 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 IN     school   5375   M S D Wayne Township   5271 Sanders School             2017   grade_1                         3.0 0.0                       3.0                         3 0                 3
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 IN     school   5375   M S D Wayne Township   5271 Sanders School             2017   grade_11                         5.0 0.0                       5.0                         5 0                 5
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 IN     school   5375   M S D Wayne Township   5271 Sanders School             2017   grade_2                         6.0 0.0                       6.0                         6 0                 6
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 IN     school   5375   M S D Wayne Township   5271 Sanders School             2017   grade_4                         5.0 1.0                       6.0                         5 1                 6
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 IN     school   5375   M S D Wayne Township   5271 Sanders School             2017   grade_6                         4.0 1.0                       5.0                         4 1                 5
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 IN     school   5375   M S D Wayne Township   5271 Sanders School             2017   grade_8                         6.0 1.0                       7.0                         6 1                 7
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 IN     school   5375   M S D Wayne Township   5271 Sanders School             2017   kindergarten                         1.0 2.0                       3.0                         1 2                 3
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 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 IN     school   7205   South Bend Community School Corp   7605 South Bend SNAP             2017   pre_kindergarten                         102.0 55.0                       157.0                         102 55                 157
1292946 IN     school 1807680 25   North Adams Community Schools 180768001317 41 Southeast Elementary School   Regular School No Elementary PK 01 2017   grade_1                         66.0 49.0                       115.0                         66 49                 115
1292947 IN     school 1807680 25   North Adams Community Schools 180768001317 41 Southeast Elementary School   Regular School No Elementary PK 01 2017   kindergarten                         63.0 62.0                       125.0                         63 62                 125
1292948 IN     school 1807680 25   North Adams Community Schools 180768001317 41 Southeast Elementary School   Regular School No Elementary PK 01 2017   pk_12_total 230.0 9.0 38.0     1.0     1.0   14.0   156.0 137.0     1.0             49.0   293.0 230 9 38     1     1   14   156 137     1       49   293
1292949 IN     school 1807680 25   North Adams Community Schools 180768001317 41 Southeast Elementary School   Regular School No Elementary PK 01 2017   pre_kindergarten                         27.0 26.0                       53.0                         27 26                 53
1293989 IN     school 1809370 940   West Clark Community Schools 180937002469 818 Silver Creek Primary School   Regular School No Elementary PK 01 2017   grade_1                         102.0 98.0                       200.0                         102 98                 200
1293990 IN     school 1809370 940   West Clark Community Schools 180937002469 818 Silver Creek Primary School   Regular School No Elementary PK 01 2017   kindergarten                         125.0 101.0                       226.0                         125 101                 226
1293991 IN     school 1809370 940   West Clark Community Schools 180937002469 818 Silver Creek Primary School   Regular School No Elementary PK 01 2017   pk_12_total 396.0 5.0 55.0     4.0         18.0   259.0 219.0     45.0             81.0   478.0 396 5 55     4         18   259 219     45       81   478
1293992 IN     school 1809370 940   West Clark Community Schools 180937002469 818 Silver Creek Primary School   Regular School No Elementary PK 01 2017   pre_kindergarten                         32.0 20.0                       52.0                         32 20                 52
1294337 IN     school 1800330 1315   Barr-Reeve Community Schools Inc 180033000062 1073 Barr Reeve Primary Grade School   Regular School No Elementary KG 01 2017   grade_1                         39.0 31.0                       70.0                         39 31                 70
1294338 IN     school 1800330 1315   Barr-Reeve Community Schools Inc 180033000062 1073 Barr Reeve Primary Grade School   Regular School No Elementary KG 01 2017   kindergarten                         39.0 38.0                       77.0                         39 38                 77
1294339 IN     school 1800330 1315   Barr-Reeve Community Schools Inc 180033000062 1073 Barr Reeve Primary Grade School   Regular School No Elementary KG 01 2017   pk_12_total 145.0         1.0         1.0   78.0 69.0     0.0             12.0   147.0 145         1         1   78 69     0       12   147
1295703 IN     school 1806870 2855   Mississinewa Community School Corp 180687001193 2344 Westview Elementary School   Regular School No Elementary PK 01 2017   grade_1                         68.0 71.0                       139.0                         68 71                 139
1295704 IN     school 1806870 2855   Mississinewa Community School Corp 180687001193 2344 Westview Elementary School   Regular School No Elementary PK 01 2017   kindergarten                         98.0 90.0                       188.0                         98 90                 188
1295705 IN     school 1806870 2855   Mississinewa Community School Corp 180687001193 2344 Westview Elementary School   Regular School No Elementary PK 01 2017   pk_12_total 356.0 8.0 12.0     4.0     1.0   39.0   211.0 209.0     2.0             53.0   420.0 356 8 12     4     1   39   211 209     2       53   420
1295706 IN     school 1806870 2855   Mississinewa Community School Corp 180687001193 2344 Westview Elementary School   Regular School No Elementary PK 01 2017   pre_kindergarten                         45.0 48.0                       93.0                         45 48                 93
1299732 IN     school 1800450 5380   Beech Grove City Schools 180045000881 5463 Hornet Park Elementary School   Regular School No Elementary KG 01 2017   grade_1                         107.0 129.0                       236.0                         107 129                 236
1299733 IN     school 1800450 5380   Beech Grove City Schools 180045000881 5463 Hornet Park Elementary School   Regular School No Elementary KG 01 2017   kindergarten                         143.0 108.0                       251.0                         143 108                 251
1299734 IN     school 1800450 5380   Beech Grove City Schools 180045000881 5463 Hornet Park Elementary School   Regular School No Elementary KG 01 2017   pk_12_total 363.0 33.0 36.0     2.0     1.0   52.0   250.0 237.0     19.0             63.0   487.0 363 33 36     2     1   52   250 237     19       63   487
1300422 IN     school 1806090 5615   Maconaquah School Corp 180609002318 6012 Pipe Creek Elementary School   Regular School No Elementary PK 01 2017   grade_1                         69.0 67.0                       136.0                         69 67                 136
1300423 IN     school 1806090 5615   Maconaquah School Corp 180609002318 6012 Pipe Creek Elementary School   Regular School No Elementary PK 01 2017   kindergarten                         70.0 60.0                       130.0                         70 60                 130
1300424 IN     school 1806090 5615   Maconaquah School Corp 180609002318 6012 Pipe Creek Elementary School   Regular School No Elementary PK 01 2017   pk_12_total 279.0 10.0 18.0 3.0   2.0     1.0   36.0   182.0 167.0     8.0             52.0   349.0 279 10 18 3   2     1   36   182 167     8       52   349
1300425 IN     school 1806090 5615   Maconaquah School Corp 180609002318 6012 Pipe Creek Elementary School   Regular School No Elementary PK 01 2017   pre_kindergarten                         43.0 40.0                       83.0                         43 40                 83
1300756 IN     school 1802460 5855   Crawfordsville Community Schools 180246000290 6293 Laura Hose Elementary School   Regular School No Elementary KG 01 2017   grade_1                         97.0 98.0                       195.0                         97 98                 195
1300757 IN     school 1802460 5855   Crawfordsville Community Schools 180246000290 6293 Laura Hose Elementary School   Regular School No Elementary KG 01 2017   kindergarten                         119.0 109.0                       228.0                         119 109                 228
1300758 IN     school 1802460 5855   Crawfordsville Community Schools 180246000290 6293 Laura Hose Elementary School   Regular School No Elementary KG 01 2017   pk_12_total 334.0 18.0 65.0     2.0     1.0   3.0   216.0 207.0     43.0             75.0   423.0 334 18 65     2     1   3   216 207     43       75   423
1301047 IN     school 1812900 6065   West Noble School Corporation 181290002055 6491 West Noble Primary School   Regular School No Elementary PK 01 2017   grade_1                         108.0 93.0                       201.0                         108 93                 201
1301048 IN     school 1812900 6065   West Noble School Corporation 181290002055 6491 West Noble Primary School   Regular School No Elementary PK 01 2017   kindergarten                         88.0 84.0                       172.0                         88 84                 172
1301049 IN     school 1812900 6065   West Noble School Corporation 181290002055 6491 West Noble Primary School   Regular School No Elementary PK 01 2017   pk_12_total 194.0 2.0 189.0 1.0   1.0         3.0   209.0 181.0     140.0             51.0   390.0 194 2 189 1   1         3   209 181     140       51   390
1301050 IN     school 1812900 6065   West Noble School Corporation 181290002055 6491 West Noble Primary School   Regular School No Elementary PK 01 2017   pre_kindergarten                         13.0 4.0                       17.0                         13 4                 17
1304943 IN     school 1800172 9970   ACE Preparatory Academy 180017202604 1111 ACE Preparatory Academy   Regular School Yes Elementary KG 01 2017   grade_1                         3.0 7.0                       10.0                         3 7                 10
1304944 IN     school 1800172 9970   ACE Preparatory Academy 180017202604 1111 ACE Preparatory Academy   Regular School Yes Elementary KG 01 2017   kindergarten                         11.0 15.0                       26.0                         11 15                 26
1304945 IN     school 1800172 9970   ACE Preparatory Academy 180017202604 1111 ACE Preparatory Academy   Regular School Yes Elementary KG 01 2017   pk_12_total 6.0 23.0 4.0               3.0   14.0 22.0     1.0             2.0   36.0 6 23 4               3   14 22     1       2   36
1293436 IN     school 1802850 255   East Allen County Schools 180285000345 83 New Haven Primary School   Regular School No Elementary PK 02 2017   grade_1                         73.0 70.0                       143.0                         73 70                 143
1293437 IN     school 1802850 255   East Allen County Schools 180285000345 83 New Haven Primary School   Regular School No Elementary PK 02 2017   grade_2                         72.0 72.0                       144.0                         72 72                 144
1293438 IN     school 1802850 255   East Allen County Schools 180285000345 83 New Haven Primary School   Regular School No Elementary PK 02 2017   kindergarten                         78.0 68.0                       146.0                         78 68                 146
1293439 IN     school 1802850 255   East Allen County Schools 180285000345 83 New Haven Primary School   Regular School No Elementary PK 02 2017   pk_12_total 354.0 53.0 35.0 1.0   2.0         44.0   249.0 240.0     9.0             64.0   489.0 354 53 35 1   2         44   249 240     9       64   489
1293440 IN     school 1802850 255   East Allen County Schools 180285000345 83 New Haven Primary School   Regular School No Elementary PK 02 2017   pre_kindergarten                         26.0 30.0                       56.0                         26 30                 56
1293479 IN     school 1802850 255   East Allen County Schools 180285000356 310 Southwick Elementary School   Regular School No Elementary PK 02 2017   grade_1                         114.0 93.0                       207.0                         114 93                 207
1293480 IN     school 1802850 255   East Allen County Schools 180285000356 310 Southwick Elementary School   Regular School No Elementary PK 02 2017   grade_2                         95.0 96.0                       191.0                         95 96                 191
1293481 IN     school 1802850 255   East Allen County Schools 180285000356 310 Southwick Elementary School   Regular School No Elementary PK 02 2017   kindergarten                         105.0 90.0                       195.0                         105 90                 195
1293482 IN     school 1802850 255   East Allen County Schools 180285000356 310 Southwick Elementary School   Regular School No Elementary PK 02 2017   pk_12_total 59.0 194.0 83.0     249.0         38.0   333.0 290.0     255.0             36.0   623.0 59 194 83     249         38   333 290     255       36   623
1293483 IN     school 1802850 255   East Allen County Schools 180285000356 310 Southwick Elementary School   Regular School No Elementary PK 02 2017   pre_kindergarten                         19.0 11.0                       30.0                         19 11                 30
1294264 IN     school 1803660 1170   Community Schools of Frankfort 180366002423 1014 Blue Ridge Primary Elementary Sch   Regular School No Elementary PK 02 2017   grade_1                         79.0 69.0                       148.0                         79 69                 148
1294265 IN     school 1803660 1170   Community Schools of Frankfort 180366002423 1014 Blue Ridge Primary Elementary Sch   Regular School No Elementary PK 02 2017   grade_2                         82.0 77.0                       159.0                         82 77                 159
1294266 IN     school 1803660 1170   Community Schools of Frankfort 180366002423 1014 Blue Ridge Primary Elementary Sch   Regular School No Elementary PK 02 2017   kindergarten                         100.0 75.0                       175.0                         100 75                 175
1294267 IN     school 1803660 1170   Community Schools of Frankfort 180366002423 1014 Blue Ridge Primary Elementary Sch   Regular School No Elementary PK 02 2017   pk_12_total 238.0 6.0 269.0 2.0   1.0         7.0   286.0 237.0     173.0             86.0   523.0 238 6 269 2   1         7   286 237     173       86   523
1294268 IN     school 1803660 1170   Community Schools of Frankfort 180366002423 1014 Blue Ridge Primary Elementary Sch   Regular School No Elementary PK 02 2017   pre_kindergarten                         25.0 16.0                       41.0                         25 16                 41
1294484 IN     school 1805700 1620   Lawrenceburg Community School Corp 180570001695 1210 Lawrenceburg Primary School   Regular School No Elementary PK 02 2017   grade_1                         77.0 67.0                       144.0                         77 67                 144
1294485 IN     school 1805700 1620   Lawrenceburg Community School Corp 180570001695 1210 Lawrenceburg Primary School   Regular School No Elementary PK 02 2017   grade_2                         75.0 76.0                       151.0                         75 76                 151
1294486 IN     school 1805700 1620   Lawrenceburg Community School Corp 180570001695 1210 Lawrenceburg Primary School   Regular School No Elementary PK 02 2017   kindergarten                         76.0 87.0                       163.0                         76 87                 163
1294487 IN     school 1805700 1620   Lawrenceburg Community School Corp 180570001695 1210 Lawrenceburg Primary School   Regular School No Elementary PK 02 2017   pk_12_total 440.0 4.0 9.0 1.0   1.0         41.0   255.0 241.0     3.0             78.0   496.0 440 4 9 1   1         41   255 241     3       78   496
1294488 IN     school 1805700 1620   Lawrenceburg Community School Corp 180570001695 1210 Lawrenceburg Primary School   Regular School No Elementary PK 02 2017   pre_kindergarten                         27.0 11.0                       38.0                         27 11                 38
1294711 IN     school 1807230 1910   Yorktown Community Schools 180723001215 1395 Pleasant View Elementary School   Regular School No Elementary KG 02 2017   grade_1                         110.0 108.0                       218.0                         110 108                 218
1294712 IN     school 1807230 1910   Yorktown Community Schools 180723001215 1395 Pleasant View Elementary School   Regular School No Elementary KG 02 2017   grade_2                         82.0 92.0                       174.0                         82 92                 174
1294713 IN     school 1807230 1910   Yorktown Community Schools 180723001215 1395 Pleasant View Elementary School   Regular School No Elementary KG 02 2017   kindergarten                         101.0 83.0                       184.0                         101 83                 184
1294714 IN     school 1807230 1910   Yorktown Community Schools 180723001215 1395 Pleasant View Elementary School   Regular School No Elementary KG 02 2017   pk_12_total 502.0 21.0 8.0 1.0   12.0         32.0   293.0 283.0     14.0             64.0   576.0 502 21 8 1   12         32   293 283     14       64   576
1294907 IN     school 1803960 2120   Greater Jasper Consolidated Schs 180396000683 1597 Fifth Street Elementary School   Regular School No Elementary PK 02 2017   grade_1                         66.0 59.0                       125.0                         66 59                 125
1294908 IN     school 1803960 2120   Greater Jasper Consolidated Schs 180396000683 1597 Fifth Street Elementary School   Regular School No Elementary PK 02 2017   grade_2                         68.0 70.0                       138.0                         68 70                 138
1294909 IN     school 1803960 2120   Greater Jasper Consolidated Schs 180396000683 1597 Fifth Street Elementary School   Regular School No Elementary PK 02 2017   kindergarten                         58.0 81.0                       139.0                         58 81                 139
1294910 IN     school 1803960 2120   Greater Jasper Consolidated Schs 180396000683 1597 Fifth Street Elementary School   Regular School No Elementary PK 02 2017   pk_12_total 284.0 2.0 129.0 1.0   3.0         13.0   208.0 224.0     83.0             106.0   432.0 284 2 129 1   3         13   208 224     83       106   432
1294911 IN     school 1803960 2120   Greater Jasper Consolidated Schs 180396000683 1597 Fifth Street Elementary School   Regular School No Elementary PK 02 2017   pre_kindergarten                         16.0 14.0                       30.0                         16 14                 30
1294957 IN     school 1800420 2260   Baugo Community Schools 180042000089 1705 Jimtown Elementary School   Regular School No Elementary KG 02 2017   grade_1                         61.0 63.0                       124.0                         61 63                 124
1294958 IN     school 1800420 2260   Baugo Community Schools 180042000089 1705 Jimtown Elementary School   Regular School No Elementary KG 02 2017   grade_2                         57.0 74.0                       131.0                         57 74                 131
1294959 IN     school 1800420 2260   Baugo Community Schools 180042000089 1705 Jimtown Elementary School   Regular School No Elementary KG 02 2017   kindergarten                         52.0 67.0                       119.0                         52 67                 119
1294960 IN     school 1800420 2260   Baugo Community Schools 180042000089 1705 Jimtown Elementary School   Regular School No Elementary KG 02 2017   pk_12_total 302.0 5.0 33.0     6.0         28.0   170.0 204.0     22.0             43.0   374.0 302 5 33     6         28   170 204     22       43   374
1295532 IN     school 1809630 2645   Rochester Community School Corp 180963001574 2181 Columbia Elementary School   Regular School No Elementary PK 02 2017   grade_1                         62.0 75.0                       137.0                         62 75                 137
1295533 IN     school 1809630 2645   Rochester Community School Corp 180963001574 2181 Columbia Elementary School   Regular School No Elementary PK 02 2017   grade_2                         65.0 76.0                       141.0                         65 76                 141
1295534 IN     school 1809630 2645   Rochester Community School Corp 180963001574 2181 Columbia Elementary School   Regular School No Elementary PK 02 2017   kindergarten                         81.0 65.0                       146.0                         81 65                 146
1295535 IN     school 1809630 2645   Rochester Community School Corp 180963001574 2181 Columbia Elementary School   Regular School No Elementary PK 02 2017   pk_12_total 403.0 3.0 28.0               15.0   226.0 223.0     8.0             69.0   449.0 403 3 28               15   226 223     8       69   449
1295536 IN     school 1809630 2645   Rochester Community School Corp 180963001574 2181 Columbia Elementary School   Regular School No Elementary PK 02 2017   pre_kindergarten                         18.0 7.0                       25.0                         18 7                 25
1295603 IN     school 1807770 2735   North Gibson School Corp 180777001325 2257 Princeton Comm Primary School   Regular School No Elementary PK 02 2017   grade_1                         75.0 56.0                       131.0                         75 56                 131
1295604 IN     school 1807770 2735   North Gibson School Corp 180777001325 2257 Princeton Comm Primary School   Regular School No Elementary PK 02 2017   grade_2                         75.0 64.0                       139.0                         75 64                 139
1295605 IN     school 1807770 2735   North Gibson School Corp 180777001325 2257 Princeton Comm Primary School   Regular School No Elementary PK 02 2017   kindergarten                         86.0 79.0                       165.0                         86 79                 165
1295606 IN     school 1807770 2735   North Gibson School Corp 180777001325 2257 Princeton Comm Primary School   Regular School No Elementary PK 02 2017   pk_12_total 367.0 19.0 23.0               43.0   247.0 205.0     9.0             116.0   452.0 367 19 23               43   247 205     9       116   452
1295607 IN     school 1807770 2735   North Gibson School Corp 180777001325 2257 Princeton Comm Primary School   Regular School No Elementary PK 02 2017   pre_kindergarten                         11.0 6.0                       17.0                         11 6                 17
1295949 IN     school 1804260 3025   Hamilton Heights School Corp 180426001653 2502 Hamilton Heights Primary School   Regular School No Elementary PK 02 2017   grade_1                         81.0 77.0                       158.0                         81 77                 158
1295950 IN     school 1804260 3025   Hamilton Heights School Corp 180426001653 2502 Hamilton Heights Primary School   Regular School No Elementary PK 02 2017   grade_2                         73.0 77.0                       150.0                         73 77                 150
1295951 IN     school 1804260 3025   Hamilton Heights School Corp 180426001653 2502 Hamilton Heights Primary School   Regular School No Elementary PK 02 2017   kindergarten                         86.0 88.0                       174.0                         86 88                 174
1295952 IN     school 1804260 3025   Hamilton Heights School Corp 180426001653 2502 Hamilton Heights Primary School   Regular School No Elementary PK 02 2017   pk_12_total 499.0 6.0 18.0     1.0         11.0   272.0 263.0     9.0             49.0   535.0 499 6 18     1         11   272 263     9       49   535
1295953 IN     school 1804260 3025   Hamilton Heights School Corp 180426001653 2502 Hamilton Heights Primary School   Regular School No Elementary PK 02 2017   pre_kindergarten                         32.0 21.0                       53.0                         32 21                 53
1296405 IN     school 1808100 3295   North West Hendricks Schools 180810002465 2684 Pittsboro Primary School   Regular School No Elementary PK 02 2017   grade_1                         53.0 36.0                       89.0                         53 36                 89
1296406 IN     school 1808100 3295   North West Hendricks Schools 180810002465 2684 Pittsboro Primary School   Regular School No Elementary PK 02 2017   grade_2                         51.0 43.0                       94.0                         51 43                 94

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