Data source: Big Local News · About: Big Local

12,019 rows where state = "IN" and year = 2018 sorted by ccd_school_high_grade

View and edit SQL

grade

year

  • 2018 · 12,019
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
1787852 IN     school   255   East Allen County Schools   318 EACS Early Childhood Preschool             2018   pk_12_total 36.0 4.0 6.0     2.0             32.0 16.0     0.0         24.0   43.0   48.0 36 4 6     2             32 16     0     24 43   48
1787853 IN     school   255   East Allen County Schools   318 EACS Early Childhood Preschool             2018   pre_kindergarten                         32.0 16.0                       48.0                         32 16                 48
1790091 IN     school   2865   Marion Community Schools   2416 Grant County Comm Justice Center             2018   grade_10                         1.0 0.0                       1.0                         1 0                 1
1790092 IN     school   2865   Marion Community Schools   2416 Grant County Comm Justice Center             2018   pk_12_total 1.0                       1.0 0.0     0.0             0.0   1.0 1                       1 0     0       0   1
1793997 IN     school   5375   M S D Wayne Township   5271 Sanders School             2018   grade_1                         2.0 2.0                       4.0                         2 2                 4
1793998 IN     school   5375   M S D Wayne Township   5271 Sanders School             2018   grade_10                         12.0 1.0                       13.0                         12 1                 13
1793999 IN     school   5375   M S D Wayne Township   5271 Sanders School             2018   grade_11                         8.0 0.0                       8.0                         8 0                 8
1794000 IN     school   5375   M S D Wayne Township   5271 Sanders School             2018   grade_12                         5.0 0.0                       5.0                         5 0                 5
1794001 IN     school   5375   M S D Wayne Township   5271 Sanders School             2018   grade_2                         7.0 0.0                       7.0                         7 0                 7
1794002 IN     school   5375   M S D Wayne Township   5271 Sanders School             2018   grade_3                         3.0 0.0                       3.0                         3 0                 3
1794003 IN     school   5375   M S D Wayne Township   5271 Sanders School             2018   grade_4                         11.0 2.0                       13.0                         11 2                 13
1794004 IN     school   5375   M S D Wayne Township   5271 Sanders School             2018   grade_5                         5.0 2.0                       7.0                         5 2                 7
1794005 IN     school   5375   M S D Wayne Township   5271 Sanders School             2018   grade_6                         5.0 1.0                       6.0                         5 1                 6
1794006 IN     school   5375   M S D Wayne Township   5271 Sanders School             2018   grade_7                         4.0 1.0                       5.0                         4 1                 5
1794007 IN     school   5375   M S D Wayne Township   5271 Sanders School             2018   grade_8                         7.0 1.0                       8.0                         7 1                 8
1794008 IN     school   5375   M S D Wayne Township   5271 Sanders School             2018   grade_9                         10.0 1.0                       11.0                         10 1                 11
1794009 IN     school   5375   M S D Wayne Township   5271 Sanders School             2018   kindergarten                         1.0 0.0                       1.0                         1 0                 1
1794010 IN     school   5375   M S D Wayne Township   5271 Sanders School             2018   pk_12_total 46.0 30.0 7.0               8.0   80.0 11.0     6.0         58.0   88.0   91.0 46 30 7               8   80 11     6     58 88   91
1796657 IN     school   7205   South Bend Community School Corp   7605 South Bend SNAP             2018   pk_12_total 90.0 38.0 33.0               17.0   120.0 58.0     0.0         87.0   119.0   178.0 90 38 33               17   120 58     0     87 119   178
1796658 IN     school   7205   South Bend Community School Corp   7605 South Bend SNAP             2018   pre_kindergarten                         120.0 58.0                       178.0                         120 58                 178
1787319 IN     school 1807680 25   North Adams Community Schools 180768001317 41 Southeast Elementary School   Regular School No Elementary PK 01 2018   grade_1                         51.0 56.0                       107.0                         51 56                 107
1787320 IN     school 1807680 25   North Adams Community Schools 180768001317 41 Southeast Elementary School   Regular School No Elementary PK 01 2018   kindergarten                         65.0 46.0                       111.0                         65 46                 111
1787321 IN     school 1807680 25   North Adams Community Schools 180768001317 41 Southeast Elementary School   Regular School No Elementary PK 01 2018   pk_12_total 222.0 13.0 35.0     1.0         17.0   148.0 140.0     1.0         191.0   50.0   288.0 222 13 35     1         17   148 140     1     191 50   288
1787322 IN     school 1807680 25   North Adams Community Schools 180768001317 41 Southeast Elementary School   Regular School No Elementary PK 01 2018   pre_kindergarten                         32.0 38.0                       70.0                         32 38                 70
1788355 IN     school 1809370 940   West Clark Community Schools 180937002469 818 Silver Creek Primary School   Regular School No Elementary PK 01 2018   grade_1                         134.0 101.0                       235.0                         134 101                 235
1788356 IN     school 1809370 940   West Clark Community Schools 180937002469 818 Silver Creek Primary School   Regular School No Elementary PK 01 2018   kindergarten                         97.0 101.0                       198.0                         97 101                 198
1788357 IN     school 1809370 940   West Clark Community Schools 180937002469 818 Silver Creek Primary School   Regular School No Elementary PK 01 2018   pk_12_total 398.0 4.0 49.0 1.0   5.0         27.0   259.0 225.0     39.0         161.0   99.0   484.0 398 4 49 1   5         27   259 225     39     161 99   484
1788358 IN     school 1809370 940   West Clark Community Schools 180937002469 818 Silver Creek Primary School   Regular School No Elementary PK 01 2018   pre_kindergarten                         28.0 23.0                       51.0                         28 23                 51
1788695 IN     school 1800330 1315   Barr-Reeve Community Schools Inc 180033000062 1073 Barr Reeve Primary Grade School   Regular School No Elementary KG 01 2018   grade_1                         39.0 39.0                       78.0                         39 39                 78
1788696 IN     school 1800330 1315   Barr-Reeve Community Schools Inc 180033000062 1073 Barr Reeve Primary Grade School   Regular School No Elementary KG 01 2018   kindergarten                         39.0 28.0                       67.0                         39 28                 67
1788697 IN     school 1800330 1315   Barr-Reeve Community Schools Inc 180033000062 1073 Barr Reeve Primary Grade School   Regular School No Elementary KG 01 2018   pk_12_total 138.0   4.0     1.0         2.0   78.0 67.0     0.0         55.0   3.0   145.0 138   4     1         2   78 67     0     55 3   145
1790044 IN     school 1806870 2855   Mississinewa Community School Corp 180687001193 2344 Westview Elementary School   Regular School No Elementary PK 01 2018   grade_1                         91.0 92.0                       183.0                         91 92                 183
1790045 IN     school 1806870 2855   Mississinewa Community School Corp 180687001193 2344 Westview Elementary School   Regular School No Elementary PK 01 2018   kindergarten                         77.0 81.0                       158.0                         77 81                 158
1790046 IN     school 1806870 2855   Mississinewa Community School Corp 180687001193 2344 Westview Elementary School   Regular School No Elementary PK 01 2018   pk_12_total 396.0 9.0 18.0     4.0         54.0   240.0 241.0     1.0         341.0   66.0   481.0 396 9 18     4         54   240 241     1     341 66   481
1790047 IN     school 1806870 2855   Mississinewa Community School Corp 180687001193 2344 Westview Elementary School   Regular School No Elementary PK 01 2018   pre_kindergarten                         72.0 68.0                       140.0                         72 68                 140
1794060 IN     school 1800450 5380   Beech Grove City Schools 180045000881 5463 Hornet Park Elementary School   Regular School No Elementary PK 01 2018   grade_1                         136.0 103.0                       239.0                         136 103                 239
1794061 IN     school 1800450 5380   Beech Grove City Schools 180045000881 5463 Hornet Park Elementary School   Regular School No Elementary PK 01 2018   kindergarten                         118.0 112.0                       230.0                         118 112                 230
1794062 IN     school 1800450 5380   Beech Grove City Schools 180045000881 5463 Hornet Park Elementary School   Regular School No Elementary PK 01 2018   pk_12_total 339.0 41.0 48.0 2.0   3.0         53.0   262.0 224.0     24.0         345.0   91.0   486.0 339 41 48 2   3         53   262 224     24     345 91   486
1794063 IN     school 1800450 5380   Beech Grove City Schools 180045000881 5463 Hornet Park Elementary School   Regular School No Elementary PK 01 2018   pre_kindergarten                         8.0 9.0                       17.0                         8 9                 17
1794740 IN     school 1806090 5615   Maconaquah School Corp 180609002318 6012 Pipe Creek Elementary School   Regular School No Elementary PK 01 2018   grade_1                         78.0 65.0                       143.0                         78 65                 143
1794741 IN     school 1806090 5615   Maconaquah School Corp 180609002318 6012 Pipe Creek Elementary School   Regular School No Elementary PK 01 2018   kindergarten                         76.0 78.0                       154.0                         76 78                 154
1794742 IN     school 1806090 5615   Maconaquah School Corp 180609002318 6012 Pipe Creek Elementary School   Regular School No Elementary PK 01 2018   pk_12_total 315.0 8.0 22.0 3.0   1.0         24.0   200.0 173.0     6.0         251.0   60.0   373.0 315 8 22 3   1         24   200 173     6     251 60   373
1794743 IN     school 1806090 5615   Maconaquah School Corp 180609002318 6012 Pipe Creek Elementary School   Regular School No Elementary PK 01 2018   pre_kindergarten                         46.0 30.0                       76.0                         46 30                 76
1795076 IN     school 1802460 5855   Crawfordsville Community Schools 180246000290 6293 Laura Hose Elementary School   Regular School No Elementary KG 01 2018   grade_1                         108.0 115.0                       223.0                         108 115                 223
1795077 IN     school 1802460 5855   Crawfordsville Community Schools 180246000290 6293 Laura Hose Elementary School   Regular School No Elementary KG 01 2018   kindergarten                         110.0 104.0                       214.0                         110 104                 214
1795078 IN     school 1802460 5855   Crawfordsville Community Schools 180246000290 6293 Laura Hose Elementary School   Regular School No Elementary KG 01 2018   pk_12_total 335.0 14.0 78.0     5.0         5.0   218.0 219.0     57.0         274.0   82.0   437.0 335 14 78     5         5   218 219     57     274 82   437
1795363 IN     school 1812900 6065   West Noble School Corporation 181290002055 6491 West Noble Primary School   Regular School No Elementary PK 01 2018   grade_1                         93.0 82.0                       175.0                         93 82                 175
1795364 IN     school 1812900 6065   West Noble School Corporation 181290002055 6491 West Noble Primary School   Regular School No Elementary PK 01 2018   kindergarten                         103.0 84.0                       187.0                         103 84                 187
1795365 IN     school 1812900 6065   West Noble School Corporation 181290002055 6491 West Noble Primary School   Regular School No Elementary PK 01 2018   pk_12_total 187.0 1.0 188.0 1.0             5.0   208.0 174.0     156.0         240.0   66.0   382.0 187 1 188 1             5   208 174     156     240 66   382
1795366 IN     school 1812900 6065   West Noble School Corporation 181290002055 6491 West Noble Primary School   Regular School No Elementary PK 01 2018   pre_kindergarten                         12.0 8.0                       20.0                         12 8                 20
1798541 IN     school 1800181 9150   Circle City Prep Charter School 180018102617 1126 Circle City Prep Charter School   Regular School Yes Elementary KG 01 2018   grade_1                         16.0 11.0                       27.0                         16 11                 27
1798542 IN     school 1800181 9150   Circle City Prep Charter School 180018102617 1126 Circle City Prep Charter School   Regular School Yes Elementary KG 01 2018   kindergarten                         31.0 24.0                       55.0                         31 24                 55
1798543 IN     school 1800181 9150   Circle City Prep Charter School 180018102617 1126 Circle City Prep Charter School   Regular School Yes Elementary KG 01 2018   pk_12_total 3.0 74.0 1.0               4.0   47.0 35.0     1.0         53.0   15.0   82.0 3 74 1               4   47 35     1     53 15   82
1787804 IN     school 1802850 255   East Allen County Schools 180285000345 83 New Haven Primary School   Regular School No Elementary PK 02 2018   grade_1                         76.0 61.0                       137.0                         76 61                 137
1787805 IN     school 1802850 255   East Allen County Schools 180285000345 83 New Haven Primary School   Regular School No Elementary PK 02 2018   grade_2                         80.0 70.0                       150.0                         80 70                 150
1787806 IN     school 1802850 255   East Allen County Schools 180285000345 83 New Haven Primary School   Regular School No Elementary PK 02 2018   kindergarten                         72.0 77.0                       149.0                         72 77                 149
1787807 IN     school 1802850 255   East Allen County Schools 180285000345 83 New Haven Primary School   Regular School No Elementary PK 02 2018   pk_12_total 336.0 58.0 28.0     7.0         37.0   243.0 223.0     14.0         325.0   73.0   466.0 336 58 28     7         37   243 223     14     325 73   466
1787808 IN     school 1802850 255   East Allen County Schools 180285000345 83 New Haven Primary School   Regular School No Elementary PK 02 2018   pre_kindergarten                         15.0 15.0                       30.0                         15 15                 30
1787847 IN     school 1802850 255   East Allen County Schools 180285000356 310 Southwick Elementary School   Regular School No Elementary PK 02 2018   grade_1                         101.0 97.0                       198.0                         101 97                 198
1787848 IN     school 1802850 255   East Allen County Schools 180285000356 310 Southwick Elementary School   Regular School No Elementary PK 02 2018   grade_2                         112.0 99.0                       211.0                         112 99                 211
1787849 IN     school 1802850 255   East Allen County Schools 180285000356 310 Southwick Elementary School   Regular School No Elementary PK 02 2018   kindergarten                         88.0 78.0                       166.0                         88 78                 166
1787850 IN     school 1802850 255   East Allen County Schools 180285000356 310 Southwick Elementary School   Regular School No Elementary PK 02 2018   pk_12_total 60.0 181.0 85.0 1.0   243.0         35.0   316.0 289.0     261.0         543.0   54.0   605.0 60 181 85 1   243         35   316 289     261     543 54   605
1787851 IN     school 1802850 255   East Allen County Schools 180285000356 310 Southwick Elementary School   Regular School No Elementary PK 02 2018   pre_kindergarten                         15.0 15.0                       30.0                         15 15                 30
1788434 IN     school 1803940 1010   Greater Clark County Schools 180394000676 829 Pleasant Ridge Elementary School   Regular School No Elementary PK 02 2018   grade_1                         95.0 73.0                       168.0                         95 73                 168
1788435 IN     school 1803940 1010   Greater Clark County Schools 180394000676 829 Pleasant Ridge Elementary School   Regular School No Elementary PK 02 2018   grade_2                         72.0 84.0                       156.0                         72 84                 156
1788436 IN     school 1803940 1010   Greater Clark County Schools 180394000676 829 Pleasant Ridge Elementary School   Regular School No Elementary PK 02 2018   kindergarten                         61.0 72.0                       133.0                         61 72                 133
1788437 IN     school 1803940 1010   Greater Clark County Schools 180394000676 829 Pleasant Ridge Elementary School   Regular School No Elementary PK 02 2018   pk_12_total 397.0 19.0 49.0     3.0         41.0   266.0 243.0     28.0         282.0   68.0   509.0 397 19 49     3         41   266 243     28     282 68   509
1788438 IN     school 1803940 1010   Greater Clark County Schools 180394000676 829 Pleasant Ridge Elementary School   Regular School No Elementary PK 02 2018   pre_kindergarten                         38.0 14.0                       52.0                         38 14                 52
1788621 IN     school 1803660 1170   Community Schools of Frankfort 180366002423 1014 Blue Ridge Primary Elementary Sch   Regular School No Elementary PK 02 2018   grade_1                         80.0 73.0                       153.0                         80 73                 153
1788622 IN     school 1803660 1170   Community Schools of Frankfort 180366002423 1014 Blue Ridge Primary Elementary Sch   Regular School No Elementary PK 02 2018   grade_2                         70.0 63.0                       133.0                         70 63                 133
1788623 IN     school 1803660 1170   Community Schools of Frankfort 180366002423 1014 Blue Ridge Primary Elementary Sch   Regular School No Elementary PK 02 2018   kindergarten                         78.0 65.0                       143.0                         78 65                 143
1788624 IN     school 1803660 1170   Community Schools of Frankfort 180366002423 1014 Blue Ridge Primary Elementary Sch   Regular School No Elementary PK 02 2018   pk_12_total 219.0 4.0 238.0 1.0   2.0         9.0   254.0 219.0     143.0         335.0   101.0   473.0 219 4 238 1   2         9   254 219     143     335 101   473
1788625 IN     school 1803660 1170   Community Schools of Frankfort 180366002423 1014 Blue Ridge Primary Elementary Sch   Regular School No Elementary PK 02 2018   pre_kindergarten                         26.0 18.0                       44.0                         26 18                 44
1788841 IN     school 1805700 1620   Lawrenceburg Community School Corp 180570001695 1210 Lawrenceburg Primary School   Regular School No Elementary PK 02 2018   grade_1                         71.0 90.0                       161.0                         71 90                 161
1788842 IN     school 1805700 1620   Lawrenceburg Community School Corp 180570001695 1210 Lawrenceburg Primary School   Regular School No Elementary PK 02 2018   grade_2                         76.0 67.0                       143.0                         76 67                 143
1788843 IN     school 1805700 1620   Lawrenceburg Community School Corp 180570001695 1210 Lawrenceburg Primary School   Regular School No Elementary PK 02 2018   kindergarten                         88.0 62.0                       150.0                         88 62                 150
1788844 IN     school 1805700 1620   Lawrenceburg Community School Corp 180570001695 1210 Lawrenceburg Primary School   Regular School No Elementary PK 02 2018   pk_12_total 418.0 4.0 17.0     5.0         31.0   251.0 224.0     8.0         195.0   88.0   475.0 418 4 17     5         31   251 224     8     195 88   475
1788845 IN     school 1805700 1620   Lawrenceburg Community School Corp 180570001695 1210 Lawrenceburg Primary School   Regular School No Elementary PK 02 2018   pre_kindergarten                         16.0 5.0                       21.0                         16 5                 21
1789074 IN     school 1807230 1910   Yorktown Community Schools 180723001215 1395 Pleasant View Elementary School   Regular School No Elementary KG 02 2018   grade_1                         113.0 88.0                       201.0                         113 88                 201
1789075 IN     school 1807230 1910   Yorktown Community Schools 180723001215 1395 Pleasant View Elementary School   Regular School No Elementary KG 02 2018   grade_2                         107.0 112.0                       219.0                         107 112                 219
1789076 IN     school 1807230 1910   Yorktown Community Schools 180723001215 1395 Pleasant View Elementary School   Regular School No Elementary KG 02 2018   kindergarten                         104.0 103.0                       207.0                         104 103                 207
1789077 IN     school 1807230 1910   Yorktown Community Schools 180723001215 1395 Pleasant View Elementary School   Regular School No Elementary KG 02 2018   pk_12_total 525.0 29.0 7.0 2.0   17.0     1.0   46.0   324.0 303.0     16.0         237.0   80.0   627.0 525 29 7 2   17     1   46   324 303     16     237 80   627
1789251 IN     school 1803960 2120   Greater Jasper Consolidated Schs 180396000683 1597 Fifth Street Elementary School   Regular School No Elementary PK 02 2018   grade_1                         56.0 78.0                       134.0                         56 78                 134
1789252 IN     school 1803960 2120   Greater Jasper Consolidated Schs 180396000683 1597 Fifth Street Elementary School   Regular School No Elementary PK 02 2018   grade_2                         68.0 58.0                       126.0                         68 58                 126
1789253 IN     school 1803960 2120   Greater Jasper Consolidated Schs 180396000683 1597 Fifth Street Elementary School   Regular School No Elementary PK 02 2018   kindergarten                         70.0 78.0                       148.0                         70 78                 148
1789254 IN     school 1803960 2120   Greater Jasper Consolidated Schs 180396000683 1597 Fifth Street Elementary School   Regular School No Elementary PK 02 2018   pk_12_total 286.0 6.0 114.0 3.0   6.0         14.0   207.0 222.0     85.0         233.0   103.0   429.0 286 6 114 3   6         14   207 222     85     233 103   429
1789255 IN     school 1803960 2120   Greater Jasper Consolidated Schs 180396000683 1597 Fifth Street Elementary School   Regular School No Elementary PK 02 2018   pre_kindergarten                         13.0 8.0                       21.0                         13 8                 21
1789301 IN     school 1800420 2260   Baugo Community Schools 180042000089 1705 Jimtown Elementary School   Regular School No Elementary KG 02 2018   grade_1                         64.0 67.0                       131.0                         64 67                 131
1789302 IN     school 1800420 2260   Baugo Community Schools 180042000089 1705 Jimtown Elementary School   Regular School No Elementary KG 02 2018   grade_2                         67.0 66.0                       133.0                         67 66                 133
1789303 IN     school 1800420 2260   Baugo Community Schools 180042000089 1705 Jimtown Elementary School   Regular School No Elementary KG 02 2018   kindergarten                         62.0 69.0                       131.0                         62 69                 131
1789304 IN     school 1800420 2260   Baugo Community Schools 180042000089 1705 Jimtown Elementary School   Regular School No Elementary KG 02 2018   pk_12_total 319.0 5.0 30.0 2.0   3.0         36.0   193.0 202.0     24.0         181.0   56.0   395.0 319 5 30 2   3         36   193 202     24     181 56   395
1789871 IN     school 1809630 2645   Rochester Community School Corp 180963001574 2181 Columbia Elementary School   Regular School No Elementary PK 02 2018   grade_1                         72.0 68.0                       140.0                         72 68                 140
1789872 IN     school 1809630 2645   Rochester Community School Corp 180963001574 2181 Columbia Elementary School   Regular School No Elementary PK 02 2018   grade_2                         63.0 72.0                       135.0                         63 72                 135
1789873 IN     school 1809630 2645   Rochester Community School Corp 180963001574 2181 Columbia Elementary School   Regular School No Elementary PK 02 2018   kindergarten                         61.0 57.0                       118.0                         61 57                 118
1789874 IN     school 1809630 2645   Rochester Community School Corp 180963001574 2181 Columbia Elementary School   Regular School No Elementary PK 02 2018   pk_12_total 362.0 3.0 31.0               20.0   213.0 203.0     4.0         254.0   69.0   416.0 362 3 31               20   213 203     4     254 69   416
1789875 IN     school 1809630 2645   Rochester Community School Corp 180963001574 2181 Columbia Elementary School   Regular School No Elementary PK 02 2018   pre_kindergarten                         17.0 6.0                       23.0                         17 6                 23
1789944 IN     school 1807770 2735   North Gibson School Corporation 180777001325 2257 Princeton Comm Primary School   Regular School No Elementary PK 02 2018   grade_1                         85.0 69.0                       154.0                         85 69                 154
1789945 IN     school 1807770 2735   North Gibson School Corporation 180777001325 2257 Princeton Comm Primary School   Regular School No Elementary PK 02 2018   grade_2                         72.0 56.0                       128.0                         72 56                 128
1789946 IN     school 1807770 2735   North Gibson School Corporation 180777001325 2257 Princeton Comm Primary School   Regular School No Elementary PK 02 2018   kindergarten                         79.0 85.0                       164.0                         79 85                 164
1789947 IN     school 1807770 2735   North Gibson School Corporation 180777001325 2257 Princeton Comm Primary School   Regular School No Elementary PK 02 2018   pk_12_total 382.0 15.0 20.0               36.0   239.0 214.0     11.0         284.0   120.0   453.0 382 15 20               36   239 214     11     284 120   453

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