Data source: Big Local News · About: Big Local

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

View and edit SQL

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 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 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 IN     school   5375   M S D Wayne Township   5271 Sanders School             2015   grade_1                         2.0 1.0                       3.0                         2 1                 3
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 IN     school   5375   M S D Wayne Township   5271 Sanders School             2015   grade_11                         4.0 2.0                       6.0                         4 2                 6
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 IN     school   5375   M S D Wayne Township   5271 Sanders School             2015   grade_2                         2.0 1.0                       3.0                         2 1                 3
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 IN     school   5375   M S D Wayne Township   5271 Sanders School             2015   grade_4                         5.0 1.0                       6.0                         5 1                 6
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 IN     school   5375   M S D Wayne Township   5271 Sanders School             2015   grade_6                         7.0 0.0                       7.0                         7 0                 7
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 IN     school   5375   M S D Wayne Township   5271 Sanders School             2015   grade_8                         6.0 0.0                       6.0                         6 0                 6
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 IN     school   5375   M S D Wayne Township   5271 Sanders School             2015   kindergarten                         2.0 0.0                       2.0                         2 0                 2
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 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 IN     school   5855   Crawfordsville Com Schools   6305 Anna Willson School             2015   pre_kindergarten                         86.0 51.0                       137.0                         86 51                 137
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 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 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 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 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 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 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 IN     school   7205   South Bend Community Sch Corp   7605 South Bend SNAP             2015   pre_kindergarten                         114.0 39.0                       153.0                         114 39                 153
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 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 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 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
1160536 IN     school 1809370 940   West Clark Community Schools 180937002469 818 Silver Creek Primary School   Regular School No 1.0 PK 01 2015   grade_1                         104.0 93.0                       197.0                         104 93                 197
1160537 IN     school 1809370 940   West Clark Community Schools 180937002469 818 Silver Creek Primary School   Regular School No 1.0 PK 01 2015   kindergarten                         107.0 96.0                       203.0                         107 96                 203
1160538 IN     school 1809370 940   West Clark Community Schools 180937002469 818 Silver Creek Primary School   Regular School No 1.0 PK 01 2015   pk_12_total 365.0 8.0 38.0     8.0         14.0   229.0 204.0     30.0             53.0   433.0 365 8 38     8         14   229 204     30       53   433
1160539 IN     school 1809370 940   West Clark Community Schools 180937002469 818 Silver Creek Primary School   Regular School No 1.0 PK 01 2015   pre_kindergarten                         18.0 15.0                       33.0                         18 15                 33
1160897 IN     school 1800330 1315   Barr-Reeve Com Schools Inc 180033000062 1073 Barr Reeve Primary Grade Sch   Regular School No 1.0 KG 01 2015   grade_1                         32.0 48.0                       80.0                         32 48                 80
1160898 IN     school 1800330 1315   Barr-Reeve Com Schools Inc 180033000062 1073 Barr Reeve Primary Grade Sch   Regular School No 1.0 KG 01 2015   kindergarten                         43.0 42.0                       85.0                         43 42                 85
1160899 IN     school 1800330 1315   Barr-Reeve Com Schools Inc 180033000062 1073 Barr Reeve Primary Grade Sch   Regular School No 1.0 KG 01 2015   pk_12_total 165.0                       75.0 90.0     0.0             10.0   165.0 165                       75 90     0       10   165
1162249 IN     school 1806870 2855   Mississinewa Community School Corp 180687001193 2344 Westview Elementary School   Regular School No 1.0 PK 01 2015   grade_1                         76.0 77.0                       153.0                         76 77                 153
1162250 IN     school 1806870 2855   Mississinewa Community School Corp 180687001193 2344 Westview Elementary School   Regular School No 1.0 PK 01 2015   kindergarten                         80.0 70.0                       150.0                         80 70                 150
1162251 IN     school 1806870 2855   Mississinewa Community School Corp 180687001193 2344 Westview Elementary School   Regular School No 1.0 PK 01 2015   pk_12_total 340.0 5.0 13.0     2.0     1.0   22.0   201.0 182.0     6.0             47.0   383.0 340 5 13     2     1   22   201 182     6       47   383
1162252 IN     school 1806870 2855   Mississinewa Community School Corp 180687001193 2344 Westview Elementary School   Regular School No 1.0 PK 01 2015   pre_kindergarten                         45.0 35.0                       80.0                         45 35                 80
1163860 IN     school 1801890 4145   Clark-Pleasant Com School Corp 180189001028 3423 Sawmill Woods Elementary School   Regular School No 1.0 KG 01 2015   grade_1                         89.0 84.0                       173.0                         89 84                 173
1163861 IN     school 1801890 4145   Clark-Pleasant Com School Corp 180189001028 3423 Sawmill Woods Elementary School   Regular School No 1.0 KG 01 2015   kindergarten                         89.0 60.0                       149.0                         89 60                 149
1163862 IN     school 1801890 4145   Clark-Pleasant Com School Corp 180189001028 3423 Sawmill Woods Elementary School   Regular School No 1.0 KG 01 2015   pk_12_total 259.0 4.0 12.0 1.0   15.0     2.0   29.0   178.0 144.0     29.0             42.0   322.0 259 4 12 1   15     2   29   178 144     29       42   322
1165658 IN     school 1802640 5300   M S D Decatur Township 180264001065 5192 Liberty Early Elementary School   Regular School No 1.0 KG 01 2015   grade_1                         6.0 1.0                       7.0                         6 1                 7
1165659 IN     school 1802640 5300   M S D Decatur Township 180264001065 5192 Liberty Early Elementary School   Regular School No 1.0 KG 01 2015   kindergarten                         243.0 225.0                       468.0                         243 225                 468
1165660 IN     school 1802640 5300   M S D Decatur Township 180264001065 5192 Liberty Early Elementary School   Regular School No 1.0 KG 01 2015   pk_12_total 345.0 46.0 56.0 4.0   3.0     1.0   20.0   249.0 226.0     44.0             38.0   475.0 345 46 56 4   3     1   20   249 226     44       38   475
1166292 IN     school 1800450 5380   Beech Grove City Schools 180045000881 5463 Hornet Park Elementary School   Regular School No 1.0 PK 01 2015   grade_1                         131.0 105.0                       236.0                         131 105                 236
1166293 IN     school 1800450 5380   Beech Grove City Schools 180045000881 5463 Hornet Park Elementary School   Regular School No 1.0 PK 01 2015   kindergarten                         116.0 123.0                       239.0                         116 123                 239
1166294 IN     school 1800450 5380   Beech Grove City Schools 180045000881 5463 Hornet Park Elementary School   Regular School No 1.0 PK 01 2015   pk_12_total 386.0 30.0 27.0 3.0   3.0         48.0   261.0 236.0     18.0             81.0   497.0 386 30 27 3   3         48   261 236     18       81   497
1166295 IN     school 1800450 5380   Beech Grove City Schools 180045000881 5463 Hornet Park Elementary School   Regular School No 1.0 PK 01 2015   pre_kindergarten                         14.0 8.0                       22.0                         14 8                 22
1166999 IN     school 1806090 5615   Maconaquah School Corp 180609002318 6012 Pipe Creek Elementary School   Regular School No 1.0 PK 01 2015   grade_1                         94.0 89.0                       183.0                         94 89                 183
1167000 IN     school 1806090 5615   Maconaquah School Corp 180609002318 6012 Pipe Creek Elementary School   Regular School No 1.0 PK 01 2015   kindergarten                         90.0 92.0                       182.0                         90 92                 182
1167001 IN     school 1806090 5615   Maconaquah School Corp 180609002318 6012 Pipe Creek Elementary School   Regular School No 1.0 PK 01 2015   pk_12_total 366.0 10.0 10.0 4.0   4.0         55.0   225.0 224.0     4.0             53.0   449.0 366 10 10 4   4         55   225 224     4       53   449
1167002 IN     school 1806090 5615   Maconaquah School Corp 180609002318 6012 Pipe Creek Elementary School   Regular School No 1.0 PK 01 2015   pre_kindergarten                         41.0 43.0                       84.0                         41 43                 84
1167328 IN     school 1802460 5855   Crawfordsville Com Schools 180246000290 6293 Laura Hose Elementary School   Regular School No 1.0 KG 01 2015   grade_1                         89.0 100.0                       189.0                         89 100                 189
1167329 IN     school 1802460 5855   Crawfordsville Com Schools 180246000290 6293 Laura Hose Elementary School   Regular School No 1.0 KG 01 2015   kindergarten                         107.0 124.0                       231.0                         107 124                 231
1167330 IN     school 1802460 5855   Crawfordsville Com Schools 180246000290 6293 Laura Hose Elementary School   Regular School No 1.0 KG 01 2015   pk_12_total 315.0 10.0 86.0     5.0         4.0   196.0 224.0     73.0             79.0   420.0 315 10 86     5         4   196 224     73       79   420
1167620 IN     school 1812900 6065   West Noble School Corporation 181290002055 6491 West Noble Primary School   Regular School No 1.0 PK 01 2015   grade_1                         108.0 98.0                       206.0                         108 98                 206
1167621 IN     school 1812900 6065   West Noble School Corporation 181290002055 6491 West Noble Primary School   Regular School No 1.0 PK 01 2015   kindergarten                         129.0 90.0                       219.0                         129 90                 219
1167622 IN     school 1812900 6065   West Noble School Corporation 181290002055 6491 West Noble Primary School   Regular School No 1.0 PK 01 2015   pk_12_total 216.0 2.0 211.0     6.0         4.0   250.0 189.0     192.0             42.0   439.0 216 2 211     6         4   250 189     192       42   439
1167623 IN     school 1812900 6065   West Noble School Corporation 181290002055 6491 West Noble Primary School   Regular School No 1.0 PK 01 2015   pre_kindergarten                         13.0 1.0                       14.0                         13 1                 14
1159988 IN     school 1802850 255   East Allen County Schools 180285000345 83 New Haven Primary School   Regular School No 1.0 PK 02 2015   grade_1                         81.0 72.0                       153.0                         81 72                 153
1159989 IN     school 1802850 255   East Allen County Schools 180285000345 83 New Haven Primary School   Regular School No 1.0 PK 02 2015   grade_2                         76.0 66.0                       142.0                         76 66                 142
1159990 IN     school 1802850 255   East Allen County Schools 180285000345 83 New Haven Primary School   Regular School No 1.0 PK 02 2015   kindergarten                         58.0 70.0                       128.0                         58 70                 128
1159991 IN     school 1802850 255   East Allen County Schools 180285000345 83 New Haven Primary School   Regular School No 1.0 PK 02 2015   pk_12_total 354.0 47.0 33.0 1.0   5.0         28.0   237.0 231.0     5.0             70.0   468.0 354 47 33 1   5         28   237 231     5       70   468
1159992 IN     school 1802850 255   East Allen County Schools 180285000345 83 New Haven Primary School   Regular School No 1.0 PK 02 2015   pre_kindergarten                         22.0 23.0                       45.0                         22 23                 45
1160030 IN     school 1802850 255   East Allen County Schools 180285000356 310 Southwick Elementary School   Regular School No 1.0 PK 02 2015   grade_1                         82.0 80.0                       162.0                         82 80                 162
1160031 IN     school 1802850 255   East Allen County Schools 180285000356 310 Southwick Elementary School   Regular School No 1.0 PK 02 2015   grade_2                         80.0 84.0                       164.0                         80 84                 164
1160032 IN     school 1802850 255   East Allen County Schools 180285000356 310 Southwick Elementary School   Regular School No 1.0 PK 02 2015   kindergarten                         89.0 96.0                       185.0                         89 96                 185
1160033 IN     school 1802850 255   East Allen County Schools 180285000356 310 Southwick Elementary School   Regular School No 1.0 PK 02 2015   pk_12_total 53.0 182.0 87.0 2.0   184.0         33.0   266.0 275.0     207.0             46.0   541.0 53 182 87 2   184         33   266 275     207       46   541
1160034 IN     school 1802850 255   East Allen County Schools 180285000356 310 Southwick Elementary School   Regular School No 1.0 PK 02 2015   pre_kindergarten                         15.0 15.0                       30.0                         15 15                 30
1160804 IN     school 1803660 1170   Community Schools of Frankfort 180366002423 1014 Blue Ridge Primary Elementary Schl   Regular School No 1.0 PK 02 2015   grade_1                         87.0 72.0                       159.0                         87 72                 159
1160805 IN     school 1803660 1170   Community Schools of Frankfort 180366002423 1014 Blue Ridge Primary Elementary Schl   Regular School No 1.0 PK 02 2015   grade_2                         75.0 74.0                       149.0                         75 74                 149
1160806 IN     school 1803660 1170   Community Schools of Frankfort 180366002423 1014 Blue Ridge Primary Elementary Schl   Regular School No 1.0 PK 02 2015   kindergarten                         80.0 74.0                       154.0                         80 74                 154
1160807 IN     school 1803660 1170   Community Schools of Frankfort 180366002423 1014 Blue Ridge Primary Elementary Schl   Regular School No 1.0 PK 02 2015   pk_12_total 229.0 4.0 270.0 1.0   2.0         1.0   274.0 233.0     206.0             69.0   507.0 229 4 270 1   2         1   274 233     206       69   507
1160808 IN     school 1803660 1170   Community Schools of Frankfort 180366002423 1014 Blue Ridge Primary Elementary Schl   Regular School No 1.0 PK 02 2015   pre_kindergarten                         32.0 13.0                       45.0                         32 13                 45
1161046 IN     school 1805700 1620   Lawrenceburg Com School Corp 180570001695 1210 Lawrenceburg Primary School   Regular School No 1.0 PK 02 2015   grade_1                         77.0 82.0                       159.0                         77 82                 159
1161047 IN     school 1805700 1620   Lawrenceburg Com School Corp 180570001695 1210 Lawrenceburg Primary School   Regular School No 1.0 PK 02 2015   grade_2                         75.0 76.0                       151.0                         75 76                 151
1161048 IN     school 1805700 1620   Lawrenceburg Com School Corp 180570001695 1210 Lawrenceburg Primary School   Regular School No 1.0 PK 02 2015   kindergarten                         74.0 77.0                       151.0                         74 77                 151
1161049 IN     school 1805700 1620   Lawrenceburg Com School Corp 180570001695 1210 Lawrenceburg Primary School   Regular School No 1.0 PK 02 2015   pk_12_total 423.0 9.0 2.0 1.0   3.0         42.0   240.0 240.0     3.0             72.0   480.0 423 9 2 1   3         42   240 240     3       72   480
1161050 IN     school 1805700 1620   Lawrenceburg Com School Corp 180570001695 1210 Lawrenceburg Primary School   Regular School No 1.0 PK 02 2015   pre_kindergarten                         14.0 5.0                       19.0                         14 5                 19
1161273 IN     school 1807230 1910   Yorktown Community Schools 180723001215 1395 Pleasant View Elementary School   Regular School No 1.0 KG 02 2015   grade_1                         111.0 77.0                       188.0                         111 77                 188
1161274 IN     school 1807230 1910   Yorktown Community Schools 180723001215 1395 Pleasant View Elementary School   Regular School No 1.0 KG 02 2015   grade_2                         95.0 88.0                       183.0                         95 88                 183
1161275 IN     school 1807230 1910   Yorktown Community Schools 180723001215 1395 Pleasant View Elementary School   Regular School No 1.0 KG 02 2015   kindergarten                         87.0 90.0                       177.0                         87 90                 177
1161276 IN     school 1807230 1910   Yorktown Community Schools 180723001215 1395 Pleasant View Elementary School   Regular School No 1.0 KG 02 2015   pk_12_total 488.0 18.0 6.0     12.0         24.0   293.0 255.0     13.0             64.0   548.0 488 18 6     12         24   293 255     13       64   548
1161469 IN     school 1803960 2120   Greater Jasper Con Schs 180396000683 1597 Fifth Street Elementary Sch   Regular School No 1.0 PK 02 2015   grade_1                         61.0 65.0                       126.0                         61 65                 126
1161470 IN     school 1803960 2120   Greater Jasper Con Schs 180396000683 1597 Fifth Street Elementary Sch   Regular School No 1.0 PK 02 2015   grade_2                         54.0 54.0                       108.0                         54 54                 108
1161471 IN     school 1803960 2120   Greater Jasper Con Schs 180396000683 1597 Fifth Street Elementary Sch   Regular School No 1.0 PK 02 2015   kindergarten                         72.0 65.0                       137.0                         72 65                 137
1161472 IN     school 1803960 2120   Greater Jasper Con Schs 180396000683 1597 Fifth Street Elementary Sch   Regular School No 1.0 PK 02 2015   pk_12_total 281.0 4.0 105.0     1.0         10.0   204.0 197.0     69.0             83.0   401.0 281 4 105     1         10   204 197     69       83   401
1161473 IN     school 1803960 2120   Greater Jasper Con Schs 180396000683 1597 Fifth Street Elementary Sch   Regular School No 1.0 PK 02 2015   pre_kindergarten                         17.0 13.0                       30.0                         17 13                 30
1161518 IN     school 1800420 2260   Baugo Community Schools 180042000089 1705 Jimtown Elementary School   Regular School No 1.0 KG 02 2015   grade_1                         70.0 67.0                       137.0                         70 67                 137
1161519 IN     school 1800420 2260   Baugo Community Schools 180042000089 1705 Jimtown Elementary School   Regular School No 1.0 KG 02 2015   grade_2                         76.0 77.0                       153.0                         76 77                 153
1161520 IN     school 1800420 2260   Baugo Community Schools 180042000089 1705 Jimtown Elementary School   Regular School No 1.0 KG 02 2015   kindergarten                         58.0 70.0                       128.0                         58 70                 128
1161521 IN     school 1800420 2260   Baugo Community Schools 180042000089 1705 Jimtown Elementary School   Regular School No 1.0 KG 02 2015   pk_12_total 338.0 10.0 34.0 1.0   5.0         30.0   204.0 214.0     30.0             37.0   418.0 338 10 34 1   5         30   204 214     30       37   418
1162077 IN     school 1809630 2645   Rochester Community Sch Corp 180963001574 2181 Columbia Elementary School   Regular School No 1.0 PK 02 2015   grade_1                         89.0 74.0                       163.0                         89 74                 163
1162078 IN     school 1809630 2645   Rochester Community Sch Corp 180963001574 2181 Columbia Elementary School   Regular School No 1.0 PK 02 2015   grade_2                         72.0 72.0                       144.0                         72 72                 144
1162079 IN     school 1809630 2645   Rochester Community Sch Corp 180963001574 2181 Columbia Elementary School   Regular School No 1.0 PK 02 2015   kindergarten                         73.0 86.0                       159.0                         73 86                 159
1162080 IN     school 1809630 2645   Rochester Community Sch Corp 180963001574 2181 Columbia Elementary School   Regular School No 1.0 PK 02 2015   pk_12_total 456.0 1.0 20.0     1.0         11.0   248.0 241.0     5.0             54.0   489.0 456 1 20     1         11   248 241     5       54   489
1162081 IN     school 1809630 2645   Rochester Community Sch Corp 180963001574 2181 Columbia Elementary School   Regular School No 1.0 PK 02 2015   pre_kindergarten                         14.0 9.0                       23.0                         14 9                 23

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