Data source: Big Local News · About: Big Local

11,992 rows where state = "IN" and year = 2019 sorted by ccd_school_high_grade

View and edit SQL

grade

year

  • 2019 · 11,992
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
1752107 IN     school   255   East Allen County Schools   318 EACS Early Childhood Preschool             2019   pk_12_total 36.0 1.0 6.0     2.0         1.0   33.0 13.0     0.0         17.0   38.0   46.0 36 1 6     2         1   33 13     0     17 38   46
1752108 IN     school   255   East Allen County Schools   318 EACS Early Childhood Preschool             2019   pre_kindergarten                         33.0 13.0                       46.0                         33 13                 46
1754356 IN     school   2865   Marion Community Schools   2416 Grant County Comm Justice Center             2019   grade_11                         1.0 0.0                       1.0                         1 0                 1
1754357 IN     school   2865   Marion Community Schools   2416 Grant County Comm Justice Center             2019   pk_12_total 1.0                       1.0 0.0     0.0             0.0   1.0 1                       1 0     0       0   1
1758207 IN     school   5375   M S D Wayne Township   5271 Sanders School             2019   grade_1                         6.0 0.0                       6.0                         6 0                 6
1758208 IN     school   5375   M S D Wayne Township   5271 Sanders School             2019   grade_10                         5.0 2.0                       7.0                         5 2                 7
1758209 IN     school   5375   M S D Wayne Township   5271 Sanders School             2019   grade_11                         6.0 0.0                       6.0                         6 0                 6
1758210 IN     school   5375   M S D Wayne Township   5271 Sanders School             2019   grade_12                         6.0 0.0                       6.0                         6 0                 6
1758211 IN     school   5375   M S D Wayne Township   5271 Sanders School             2019   grade_2                         7.0 1.0                       8.0                         7 1                 8
1758212 IN     school   5375   M S D Wayne Township   5271 Sanders School             2019   grade_3                         5.0 0.0                       5.0                         5 0                 5
1758213 IN     school   5375   M S D Wayne Township   5271 Sanders School             2019   grade_4                         3.0 0.0                       3.0                         3 0                 3
1758214 IN     school   5375   M S D Wayne Township   5271 Sanders School             2019   grade_5                         6.0 1.0                       7.0                         6 1                 7
1758215 IN     school   5375   M S D Wayne Township   5271 Sanders School             2019   grade_6                         7.0 4.0                       11.0                         7 4                 11
1758216 IN     school   5375   M S D Wayne Township   5271 Sanders School             2019   grade_7                         7.0 1.0                       8.0                         7 1                 8
1758217 IN     school   5375   M S D Wayne Township   5271 Sanders School             2019   grade_8                         5.0 1.0                       6.0                         5 1                 6
1758218 IN     school   5375   M S D Wayne Township   5271 Sanders School             2019   grade_9                         10.0 0.0                       10.0                         10 0                 10
1758219 IN     school   5375   M S D Wayne Township   5271 Sanders School             2019   kindergarten                         1.0 0.0                       1.0                         1 0                 1
1758220 IN     school   5375   M S D Wayne Township   5271 Sanders School             2019   pk_12_total 40.0 35.0 2.0               7.0   74.0 10.0     4.0         51.0   82.0   84.0 40 35 2               7   74 10     4     51 82   84
1760847 IN     school   7205   South Bend Community School Corp   7605 South Bend SNAP             2019   pk_12_total 86.0 47.0 39.0     2.0         45.0   132.0 87.0     0.0         12.0   99.0   219.0 86 47 39     2         45   132 87     0     12 99   219
1760848 IN     school   7205   South Bend Community School Corp   7605 South Bend SNAP             2019   pre_kindergarten                         132.0 87.0                       219.0                         132 87                 219
1752616 IN     school 1809370 940   West Clark Community Schools 180937002469 818 Silver Creek Primary School   Regular School No Elementary PK 01 2019   grade_1                         91.0 98.0                       189.0                         91 98                 189
1752617 IN     school 1809370 940   West Clark Community Schools 180937002469 818 Silver Creek Primary School   Regular School No Elementary PK 01 2019   kindergarten                         86.0 86.0                       172.0                         86 86                 172
1752618 IN     school 1809370 940   West Clark Community Schools 180937002469 818 Silver Creek Primary School   Regular School No Elementary PK 01 2019   pk_12_total 349.0 3.0 35.0 3.0   7.0         14.0   198.0 213.0     29.0         121.0   82.0   411.0 349 3 35 3   7         14   198 213     29     121 82   411
1752619 IN     school 1809370 940   West Clark Community Schools 180937002469 818 Silver Creek Primary School   Regular School No Elementary PK 01 2019   pre_kindergarten                         21.0 29.0                       50.0                         21 29                 50
1752954 IN     school 1800330 1315   Barr-Reeve Community Schools Inc 180033000062 1073 Barr Reeve Primary Grade School   Regular School No Elementary KG 01 2019   grade_1                         31.0 32.0                       63.0                         31 32                 63
1752955 IN     school 1800330 1315   Barr-Reeve Community Schools Inc 180033000062 1073 Barr Reeve Primary Grade School   Regular School No Elementary KG 01 2019   kindergarten                         53.0 56.0                       109.0                         53 56                 109
1752956 IN     school 1800330 1315   Barr-Reeve Community Schools Inc 180033000062 1073 Barr Reeve Primary Grade School   Regular School No Elementary KG 01 2019   pk_12_total 165.0 1.0 2.0     3.0         1.0   84.0 88.0     0.0         60.0   10.0   172.0 165 1 2     3         1   84 88     0     60 10   172
1754309 IN     school 1806870 2855   Mississinewa Community School Corp 180687001193 2344 Westview Elementary School   Regular School No Elementary PK 01 2019   grade_1                         69.0 69.0                       138.0                         69 69                 138
1754310 IN     school 1806870 2855   Mississinewa Community School Corp 180687001193 2344 Westview Elementary School   Regular School No Elementary PK 01 2019   kindergarten                         80.0 70.0                       150.0                         80 70                 150
1754311 IN     school 1806870 2855   Mississinewa Community School Corp 180687001193 2344 Westview Elementary School   Regular School No Elementary PK 01 2019   pk_12_total 364.0 6.0 23.0     3.0         55.0   235.0 216.0     0.0         297.0   51.0   451.0 364 6 23     3         55   235 216     0     297 51   451
1754312 IN     school 1806870 2855   Mississinewa Community School Corp 180687001193 2344 Westview Elementary School   Regular School No Elementary PK 01 2019   pre_kindergarten                         86.0 77.0                       163.0                         86 77                 163
1758270 IN     school 1800450 5380   Beech Grove City Schools 180045000881 5463 Hornet Park Elementary School   Regular School No Elementary PK 01 2019   grade_1                         117.0 103.0                       220.0                         117 103                 220
1758271 IN     school 1800450 5380   Beech Grove City Schools 180045000881 5463 Hornet Park Elementary School   Regular School No Elementary PK 01 2019   kindergarten                         110.0 100.0                       210.0                         110 100                 210
1758272 IN     school 1800450 5380   Beech Grove City Schools 180045000881 5463 Hornet Park Elementary School   Regular School No Elementary PK 01 2019   pk_12_total 324.0 46.0 41.0 1.0   1.0         45.0   245.0 213.0     21.0         269.0   89.0   458.0 324 46 41 1   1         45   245 213     21     269 89   458
1758273 IN     school 1800450 5380   Beech Grove City Schools 180045000881 5463 Hornet Park Elementary School   Regular School No Elementary PK 01 2019   pre_kindergarten                         18.0 10.0                       28.0                         18 10                 28
1758928 IN     school 1806090 5615   Maconaquah School Corp 180609002318 6012 Pipe Creek Elementary School   Regular School No Elementary PK 01 2019   grade_1                         71.0 76.0                       147.0                         71 76                 147
1758929 IN     school 1806090 5615   Maconaquah School Corp 180609002318 6012 Pipe Creek Elementary School   Regular School No Elementary PK 01 2019   kindergarten                         70.0 60.0                       130.0                         70 60                 130
1758930 IN     school 1806090 5615   Maconaquah School Corp 180609002318 6012 Pipe Creek Elementary School   Regular School No Elementary PK 01 2019   pk_12_total 319.0 4.0 20.0 1.0   1.0         29.0   187.0 187.0     3.0         235.0   64.0   374.0 319 4 20 1   1         29   187 187     3     235 64   374
1758931 IN     school 1806090 5615   Maconaquah School Corp 180609002318 6012 Pipe Creek Elementary School   Regular School No Elementary PK 01 2019   pre_kindergarten                         46.0 51.0                       97.0                         46 51                 97
1759259 IN     school 1802460 5855   Crawfordsville Community Schools 180246000290 6293 Laura Hose Elementary School   Regular School No Elementary KG 01 2019   grade_1                         107.0 96.0                       203.0                         107 96                 203
1759260 IN     school 1802460 5855   Crawfordsville Community Schools 180246000290 6293 Laura Hose Elementary School   Regular School No Elementary KG 01 2019   kindergarten                         103.0 87.0                       190.0                         103 87                 190
1759261 IN     school 1802460 5855   Crawfordsville Community Schools 180246000290 6293 Laura Hose Elementary School   Regular School No Elementary KG 01 2019   pk_12_total 302.0 14.0 68.0     3.0         6.0   210.0 183.0     49.0         256.0   79.0   393.0 302 14 68     3         6   210 183     49     256 79   393
1759538 IN     school 1812900 6065   West Noble School Corporation 181290002055 6491 West Noble Primary School   Regular School No Elementary PK 01 2019   grade_1                         92.0 84.0                       176.0                         92 84                 176
1759539 IN     school 1812900 6065   West Noble School Corporation 181290002055 6491 West Noble Primary School   Regular School No Elementary PK 01 2019   kindergarten                         84.0 82.0                       166.0                         84 82                 166
1759540 IN     school 1812900 6065   West Noble School Corporation 181290002055 6491 West Noble Primary School   Regular School No Elementary PK 01 2019   pk_12_total 157.0 3.0 194.0 1.0             7.0   191.0 171.0     152.0         221.0   63.0   362.0 157 3 194 1             7   191 171     152     221 63   362
1759541 IN     school 1812900 6065   West Noble School Corporation 181290002055 6491 West Noble Primary School   Regular School No Elementary PK 01 2019   pre_kindergarten                         15.0 5.0                       20.0                         15 5                 20
1762731 IN     school 1800199 9065   Allegiant Preparatory Academy 180019902648 1002 Allegiant Preparatory Academy   Regular School Yes Elementary KG 01 2019   grade_1                         9.0 5.0                       14.0                         9 5                 14
1762732 IN     school 1800199 9065   Allegiant Preparatory Academy 180019902648 1002 Allegiant Preparatory Academy   Regular School Yes Elementary KG 01 2019   kindergarten                         12.0 11.0                       23.0                         12 11                 23
1762733 IN     school 1800199 9065   Allegiant Preparatory Academy 180019902648 1002 Allegiant Preparatory Academy   Regular School Yes Elementary KG 01 2019   pk_12_total 1.0 33.0 1.0               2.0   21.0 16.0     1.0         36.0   4.0   37.0 1 33 1               2   21 16     1     36 4   37
1752059 IN     school 1802850 255   East Allen County Schools 180285000345 83 New Haven Primary School   Regular School No Elementary PK 02 2019   grade_1                         62.0 69.0                       131.0                         62 69                 131
1752060 IN     school 1802850 255   East Allen County Schools 180285000345 83 New Haven Primary School   Regular School No Elementary PK 02 2019   grade_2                         77.0 58.0                       135.0                         77 58                 135
1752061 IN     school 1802850 255   East Allen County Schools 180285000345 83 New Haven Primary School   Regular School No Elementary PK 02 2019   kindergarten                         80.0 74.0                       154.0                         80 74                 154
1752062 IN     school 1802850 255   East Allen County Schools 180285000345 83 New Haven Primary School   Regular School No Elementary PK 02 2019   pk_12_total 340.0 41.0 31.0     5.0         33.0   234.0 216.0     11.0         313.0   60.0   450.0 340 41 31     5         33   234 216     11     313 60   450
1752063 IN     school 1802850 255   East Allen County Schools 180285000345 83 New Haven Primary School   Regular School No Elementary PK 02 2019   pre_kindergarten                         15.0 15.0                       30.0                         15 15                 30
1752102 IN     school 1802850 255   East Allen County Schools 180285000356 310 Southwick Elementary School   Regular School No Elementary PK 02 2019   grade_1                         86.0 85.0                       171.0                         86 85                 171
1752103 IN     school 1802850 255   East Allen County Schools 180285000356 310 Southwick Elementary School   Regular School No Elementary PK 02 2019   grade_2                         97.0 91.0                       188.0                         97 91                 188
1752104 IN     school 1802850 255   East Allen County Schools 180285000356 310 Southwick Elementary School   Regular School No Elementary PK 02 2019   kindergarten                         100.0 79.0                       179.0                         100 79                 179
1752105 IN     school 1802850 255   East Allen County Schools 180285000356 310 Southwick Elementary School   Regular School No Elementary PK 02 2019   pk_12_total 58.0 171.0 97.0     246.0         24.0   314.0 282.0     262.0         503.0   51.0   596.0 58 171 97     246         24   314 282     262     503 51   596
1752106 IN     school 1802850 255   East Allen County Schools 180285000356 310 Southwick Elementary School   Regular School No Elementary PK 02 2019   pre_kindergarten                         31.0 27.0                       58.0                         31 27                 58
1752302 IN     school 1800570 515   Blackford County Schools 180057000126 501 Southside Elementary School   Regular School No Elementary KG 02 2019   grade_1                         44.0 47.0                       91.0                         44 47                 91
1752303 IN     school 1800570 515   Blackford County Schools 180057000126 501 Southside Elementary School   Regular School No Elementary KG 02 2019   grade_2                         42.0 39.0                       81.0                         42 39                 81
1752304 IN     school 1800570 515   Blackford County Schools 180057000126 501 Southside Elementary School   Regular School No Elementary KG 02 2019   kindergarten                         57.0 49.0                       106.0                         57 49                 106
1752305 IN     school 1800570 515   Blackford County Schools 180057000126 501 Southside Elementary School   Regular School No Elementary KG 02 2019   pk_12_total 255.0 2.0 6.0 1.0             14.0   143.0 135.0     0.0         174.0   50.0   278.0 255 2 6 1             14   143 135     0     174 50   278
1752695 IN     school 1803940 1010   Greater Clark County Schools 180394000676 829 Pleasant Ridge Elementary School   Regular School No Elementary PK 02 2019   grade_1                         67.0 76.0                       143.0                         67 76                 143
1752696 IN     school 1803940 1010   Greater Clark County Schools 180394000676 829 Pleasant Ridge Elementary School   Regular School No Elementary PK 02 2019   grade_2                         91.0 80.0                       171.0                         91 80                 171
1752697 IN     school 1803940 1010   Greater Clark County Schools 180394000676 829 Pleasant Ridge Elementary School   Regular School No Elementary PK 02 2019   kindergarten                         87.0 67.0                       154.0                         87 67                 154
1752698 IN     school 1803940 1010   Greater Clark County Schools 180394000676 829 Pleasant Ridge Elementary School   Regular School No Elementary PK 02 2019   pk_12_total 406.0 14.0 44.0     3.0     2.0   40.0   268.0 241.0     26.0         273.0   75.0   509.0 406 14 44     3     2   40   268 241     26     273 75   509
1752699 IN     school 1803940 1010   Greater Clark County Schools 180394000676 829 Pleasant Ridge Elementary School   Regular School No Elementary PK 02 2019   pre_kindergarten                         23.0 18.0                       41.0                         23 18                 41
1752880 IN     school 1803660 1170   Community Schools of Frankfort 180366002423 1014 Blue Ridge Primary Elementary Sch   Regular School No Elementary PK 02 2019   grade_1                         79.0 68.0                       147.0                         79 68                 147
1752881 IN     school 1803660 1170   Community Schools of Frankfort 180366002423 1014 Blue Ridge Primary Elementary Sch   Regular School No Elementary PK 02 2019   grade_2                         79.0 72.0                       151.0                         79 72                 151
1752882 IN     school 1803660 1170   Community Schools of Frankfort 180366002423 1014 Blue Ridge Primary Elementary Sch   Regular School No Elementary PK 02 2019   kindergarten                         77.0 78.0                       155.0                         77 78                 155
1752883 IN     school 1803660 1170   Community Schools of Frankfort 180366002423 1014 Blue Ridge Primary Elementary Sch   Regular School No Elementary PK 02 2019   pk_12_total 247.0 8.0 237.0 1.0   2.0         11.0   267.0 239.0     151.0         369.0   100.0   506.0 247 8 237 1   2         11   267 239     151     369 100   506
1752884 IN     school 1803660 1170   Community Schools of Frankfort 180366002423 1014 Blue Ridge Primary Elementary Sch   Regular School No Elementary PK 02 2019   pre_kindergarten                         32.0 21.0                       53.0                         32 21                 53
1753102 IN     school 1805700 1620   Lawrenceburg Community School Corp 180570001695 1210 Lawrenceburg Primary School   Regular School No Elementary PK 02 2019   grade_1                         94.0 67.0                       161.0                         94 67                 161
1753103 IN     school 1805700 1620   Lawrenceburg Community School Corp 180570001695 1210 Lawrenceburg Primary School   Regular School No Elementary PK 02 2019   grade_2                         67.0 77.0                       144.0                         67 77                 144
1753104 IN     school 1805700 1620   Lawrenceburg Community School Corp 180570001695 1210 Lawrenceburg Primary School   Regular School No Elementary PK 02 2019   kindergarten                         66.0 60.0                       126.0                         66 60                 126
1753105 IN     school 1805700 1620   Lawrenceburg Community School Corp 180570001695 1210 Lawrenceburg Primary School   Regular School No Elementary PK 02 2019   pk_12_total 415.0 3.0 15.0     5.0         30.0   256.0 212.0     6.0         173.0   92.0   468.0 415 3 15     5         30   256 212     6     173 92   468
1753106 IN     school 1805700 1620   Lawrenceburg Community School Corp 180570001695 1210 Lawrenceburg Primary School   Regular School No Elementary PK 02 2019   pre_kindergarten                         29.0 8.0                       37.0                         29 8                 37
1753335 IN     school 1807230 1910   Yorktown Community Schools 180723001215 1395 Pleasant View Elementary School   Regular School No Elementary KG 02 2019   grade_1                         114.0 94.0                       208.0                         114 94                 208
1753336 IN     school 1807230 1910   Yorktown Community Schools 180723001215 1395 Pleasant View Elementary School   Regular School No Elementary KG 02 2019   grade_2                         109.0 87.0                       196.0                         109 87                 196
1753337 IN     school 1807230 1910   Yorktown Community Schools 180723001215 1395 Pleasant View Elementary School   Regular School No Elementary KG 02 2019   kindergarten                         104.0 113.0                       217.0                         104 113                 217
1753338 IN     school 1807230 1910   Yorktown Community Schools 180723001215 1395 Pleasant View Elementary School   Regular School No Elementary KG 02 2019   pk_12_total 529.0 27.0 9.0 2.0   18.0         36.0   327.0 294.0     15.0         244.0   87.0   621.0 529 27 9 2   18         36   327 294     15     244 87   621
1753513 IN     school 1803960 2120   Greater Jasper Consolidated Schs 180396000683 1597 Fifth Street Elementary School   Regular School No Elementary PK 02 2019   grade_1                         70.0 73.0                       143.0                         70 73                 143
1753514 IN     school 1803960 2120   Greater Jasper Consolidated Schs 180396000683 1597 Fifth Street Elementary School   Regular School No Elementary PK 02 2019   grade_2                         51.0 71.0                       122.0                         51 71                 122
1753515 IN     school 1803960 2120   Greater Jasper Consolidated Schs 180396000683 1597 Fifth Street Elementary School   Regular School No Elementary PK 02 2019   kindergarten                         74.0 63.0                       137.0                         74 63                 137
1753516 IN     school 1803960 2120   Greater Jasper Consolidated Schs 180396000683 1597 Fifth Street Elementary School   Regular School No Elementary PK 02 2019   pk_12_total 294.0 4.0 107.0 3.0   4.0         13.0   207.0 218.0     85.0         245.0   100.0   425.0 294 4 107 3   4         13   207 218     85     245 100   425
1753517 IN     school 1803960 2120   Greater Jasper Consolidated Schs 180396000683 1597 Fifth Street Elementary School   Regular School No Elementary PK 02 2019   pre_kindergarten                         12.0 11.0                       23.0                         12 11                 23
1753564 IN     school 1800420 2260   Baugo Community Schools 180042000089 1705 Jimtown Elementary School   Regular School No Elementary KG 02 2019   grade_1                         65.0 75.0                       140.0                         65 75                 140
1753565 IN     school 1800420 2260   Baugo Community Schools 180042000089 1705 Jimtown Elementary School   Regular School No Elementary KG 02 2019   grade_2                         61.0 65.0                       126.0                         61 65                 126
1753566 IN     school 1800420 2260   Baugo Community Schools 180042000089 1705 Jimtown Elementary School   Regular School No Elementary KG 02 2019   kindergarten                         61.0 71.0                       132.0                         61 71                 132
1753567 IN     school 1800420 2260   Baugo Community Schools 180042000089 1705 Jimtown Elementary School   Regular School No Elementary KG 02 2019   pk_12_total 312.0 4.0 40.0 3.0   3.0         36.0   187.0 211.0     29.0         189.0   52.0   398.0 312 4 40 3   3         36   187 211     29     189 52   398
1754136 IN     school 1809630 2645   Rochester Community School Corp 180963001574 2181 Columbia Elementary School   Regular School No Elementary PK 02 2019   grade_1                         59.0 57.0                       116.0                         59 57                 116
1754137 IN     school 1809630 2645   Rochester Community School Corp 180963001574 2181 Columbia Elementary School   Regular School No Elementary PK 02 2019   grade_2                         72.0 65.0                       137.0                         72 65                 137
1754138 IN     school 1809630 2645   Rochester Community School Corp 180963001574 2181 Columbia Elementary School   Regular School No Elementary PK 02 2019   kindergarten                         71.0 60.0                       131.0                         71 60                 131
1754139 IN     school 1809630 2645   Rochester Community School Corp 180963001574 2181 Columbia Elementary School   Regular School No Elementary PK 02 2019   pk_12_total 397.0 1.0 28.0               17.0   239.0 204.0     4.0         267.0   78.0   443.0 397 1 28               17   239 204     4     267 78   443
1754140 IN     school 1809630 2645   Rochester Community School Corp 180963001574 2181 Columbia Elementary School   Regular School No Elementary PK 02 2019   pre_kindergarten                         37.0 22.0                       59.0                         37 22                 59
1754210 IN     school 1807770 2735   North Gibson School Corporation 180777001325 2257 Princeton Comm Primary School   Regular School No Elementary PK 02 2019   grade_1                         66.0 76.0                       142.0                         66 76                 142
1754211 IN     school 1807770 2735   North Gibson School Corporation 180777001325 2257 Princeton Comm Primary School   Regular School No Elementary PK 02 2019   grade_2                         75.0 65.0                       140.0                         75 65                 140
1754212 IN     school 1807770 2735   North Gibson School Corporation 180777001325 2257 Princeton Comm Primary School   Regular School No Elementary PK 02 2019   kindergarten                         86.0 71.0                       157.0                         86 71                 157
1754213 IN     school 1807770 2735   North Gibson School Corporation 180777001325 2257 Princeton Comm Primary School   Regular School No Elementary PK 02 2019   pk_12_total 369.0 19.0 15.0               46.0   233.0 216.0     11.0         275.0   106.0   449.0 369 19 15               46   233 216     11     275 106   449

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