Data source: Big Local News · About: Big Local

12,062 rows where state = "IN" and year = 2016 sorted by ccd_school_high_grade

View and edit SQL

grade

year

  • 2016 · 12,062
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
1287632 IN     school   5375   M S D Wayne Township   5271 Sanders School             2016   grade_1                         3.0 0.0                       3.0                         3 0                 3
1287633 IN     school   5375   M S D Wayne Township   5271 Sanders School             2016   grade_10                         9.0 0.0                       9.0                         9 0                 9
1287634 IN     school   5375   M S D Wayne Township   5271 Sanders School             2016   grade_11                         4.0 1.0                       5.0                         4 1                 5
1287635 IN     school   5375   M S D Wayne Township   5271 Sanders School             2016   grade_12                         9.0 2.0                       11.0                         9 2                 11
1287636 IN     school   5375   M S D Wayne Township   5271 Sanders School             2016   grade_2                         6.0 1.0                       7.0                         6 1                 7
1287637 IN     school   5375   M S D Wayne Township   5271 Sanders School             2016   grade_3                         4.0 1.0                       5.0                         4 1                 5
1287638 IN     school   5375   M S D Wayne Township   5271 Sanders School             2016   grade_4                         1.0 1.0                       2.0                         1 1                 2
1287639 IN     school   5375   M S D Wayne Township   5271 Sanders School             2016   grade_5                         4.0 2.0                       6.0                         4 2                 6
1287640 IN     school   5375   M S D Wayne Township   5271 Sanders School             2016   grade_6                         11.0 1.0                       12.0                         11 1                 12
1287641 IN     school   5375   M S D Wayne Township   5271 Sanders School             2016   grade_7                         5.0 1.0                       6.0                         5 1                 6
1287642 IN     school   5375   M S D Wayne Township   5271 Sanders School             2016   grade_8                         12.0 1.0                       13.0                         12 1                 13
1287643 IN     school   5375   M S D Wayne Township   5271 Sanders School             2016   grade_9                         8.0 0.0                       8.0                         8 0                 8
1287644 IN     school   5375   M S D Wayne Township   5271 Sanders School             2016   pk_12_total 47.0 24.0 7.0               9.0   76.0 11.0     4.0             84.0   87.0 47 24 7               9   76 11     4       84   87
1290316 IN     school   7205   South Bend Community Sch Corp   7605 South Bend SNAP             2016   pk_12_total 107.0 38.0 31.0     1.0         19.0   142.0 54.0     0.0             135.0   196.0 107 38 31     1         19   142 54     0       135   196
1290317 IN     school   7205   South Bend Community Sch Corp   7605 South Bend SNAP             2016   pre_kindergarten                         142.0 54.0                       196.0                         142 54                 196
1280883 IN     school 1807680 25   North Adams Community Schools 180768001317 41 Southeast Elementary School   Regular School No 1.0 PK 01 2016   grade_1                         60.0 61.0                       121.0                         60 61                 121
1280884 IN     school 1807680 25   North Adams Community Schools 180768001317 41 Southeast Elementary School   Regular School No 1.0 PK 01 2016   kindergarten                         65.0 49.0                       114.0                         65 49                 114
1280885 IN     school 1807680 25   North Adams Community Schools 180768001317 41 Southeast Elementary School   Regular School No 1.0 PK 01 2016   pk_12_total 234.0 7.0 29.0     2.0     2.0   10.0   155.0 129.0     1.0             44.0   284.0 234 7 29     2     2   10   155 129     1       44   284
1280886 IN     school 1807680 25   North Adams Community Schools 180768001317 41 Southeast Elementary School   Regular School No 1.0 PK 01 2016   pre_kindergarten                         30.0 19.0                       49.0                         30 19                 49
1281931 IN     school 1809370 940   West Clark Community Schools 180937002469 818 Silver Creek Primary School   Regular School No 1.0 PK 01 2016   grade_1                         109.0 98.0                       207.0                         109 98                 207
1281932 IN     school 1809370 940   West Clark Community Schools 180937002469 818 Silver Creek Primary School   Regular School No 1.0 PK 01 2016   kindergarten                         102.0 97.0                       199.0                         102 97                 199
1281933 IN     school 1809370 940   West Clark Community Schools 180937002469 818 Silver Creek Primary School   Regular School No 1.0 PK 01 2016   pk_12_total 344.0 4.0 38.0 1.0   8.0     1.0   12.0   213.0 195.0     37.0             42.0   408.0 344 4 38 1   8     1   12   213 195     37       42   408
1281934 IN     school 1809370 940   West Clark Community Schools 180937002469 818 Silver Creek Primary School   Regular School No 1.0 PK 01 2016   pre_kindergarten                         2.0 0.0                       2.0                         2 0                 2
1282299 IN     school 1800330 1315   Barr-Reeve Com Schools Inc 180033000062 1073 Barr Reeve Primary Grade School   Regular School No 1.0 KG 01 2016   grade_1                         39.0 35.0                       74.0                         39 35                 74
1282300 IN     school 1800330 1315   Barr-Reeve Com Schools Inc 180033000062 1073 Barr Reeve Primary Grade School   Regular School No 1.0 KG 01 2016   kindergarten                         50.0 41.0                       91.0                         50 41                 91
1282301 IN     school 1800330 1315   Barr-Reeve Com Schools Inc 180033000062 1073 Barr Reeve Primary Grade School   Regular School No 1.0 KG 01 2016   pk_12_total 164.0 1.0                     89.0 76.0     0.0             13.0   165.0 164 1                     89 76     0       13   165
1283659 IN     school 1806870 2855   Mississinewa Community School Corp 180687001193 2344 Westview Elementary School   Regular School No 1.0 PK 01 2016   grade_1                         82.0 69.0                       151.0                         82 69                 151
1283660 IN     school 1806870 2855   Mississinewa Community School Corp 180687001193 2344 Westview Elementary School   Regular School No 1.0 PK 01 2016   kindergarten                         74.0 72.0                       146.0                         74 72                 146
1283661 IN     school 1806870 2855   Mississinewa Community School Corp 180687001193 2344 Westview Elementary School   Regular School No 1.0 PK 01 2016   pk_12_total 327.0 6.0 12.0     4.0         35.0   203.0 181.0     4.0             50.0   384.0 327 6 12     4         35   203 181     4       50   384
1283662 IN     school 1806870 2855   Mississinewa Community School Corp 180687001193 2344 Westview Elementary School   Regular School No 1.0 PK 01 2016   pre_kindergarten                         47.0 40.0                       87.0                         47 40                 87
1285266 IN     school 1801890 4145   Clark-Pleasant Com School Corp 180189001028 3423 Sawmill Woods Elementary School   Regular School No 1.0 KG 01 2016   grade_1                         85.0 64.0                       149.0                         85 64                 149
1285267 IN     school 1801890 4145   Clark-Pleasant Com School Corp 180189001028 3423 Sawmill Woods Elementary School   Regular School No 1.0 KG 01 2016   kindergarten                         84.0 81.0                       165.0                         84 81                 165
1285268 IN     school 1801890 4145   Clark-Pleasant Com School Corp 180189001028 3423 Sawmill Woods Elementary School   Regular School No 1.0 KG 01 2016   pk_12_total 252.0 5.0 18.0     16.0         23.0   169.0 145.0     15.0             31.0   314.0 252 5 18     16         23   169 145     15       31   314
1287054 IN     school 1802640 5300   M S D Decatur Township 180264001065 5192 Liberty Early Elementary School   Regular School No 1.0 PK 01 2016   grade_1                         1.0 1.0                       2.0                         1 1                 2
1287055 IN     school 1802640 5300   M S D Decatur Township 180264001065 5192 Liberty Early Elementary School   Regular School No 1.0 PK 01 2016   kindergarten                         227.0 218.0                       445.0                         227 218                 445
1287056 IN     school 1802640 5300   M S D Decatur Township 180264001065 5192 Liberty Early Elementary School   Regular School No 1.0 PK 01 2016   pk_12_total 416.0 62.0 55.0 4.0   2.0     2.0   37.0   304.0 274.0     33.0             102.0   578.0 416 62 55 4   2     2   37   304 274     33       102   578
1287057 IN     school 1802640 5300   M S D Decatur Township 180264001065 5192 Liberty Early Elementary School   Regular School No 1.0 PK 01 2016   pre_kindergarten                         76.0 55.0                       131.0                         76 55                 131
1287694 IN     school 1800450 5380   Beech Grove City Schools 180045000881 5463 Hornet Park Elementary School   Regular School No 1.0 PK 01 2016   grade_1                         126.0 115.0                       241.0                         126 115                 241
1287695 IN     school 1800450 5380   Beech Grove City Schools 180045000881 5463 Hornet Park Elementary School   Regular School No 1.0 PK 01 2016   kindergarten                         109.0 115.0                       224.0                         109 115                 224
1287696 IN     school 1800450 5380   Beech Grove City Schools 180045000881 5463 Hornet Park Elementary School   Regular School No 1.0 PK 01 2016   pk_12_total 372.0 31.0 32.0     3.0         48.0   250.0 236.0     21.0             71.0   486.0 372 31 32     3         48   250 236     21       71   486
1287697 IN     school 1800450 5380   Beech Grove City Schools 180045000881 5463 Hornet Park Elementary School   Regular School No 1.0 PK 01 2016   pre_kindergarten                         15.0 6.0                       21.0                         15 6                 21
1288397 IN     school 1806090 5615   Maconaquah School Corp 180609002318 6012 Pipe Creek Elementary School   Regular School No 1.0 PK 01 2016   grade_1                         86.0 99.0                       185.0                         86 99                 185
1288398 IN     school 1806090 5615   Maconaquah School Corp 180609002318 6012 Pipe Creek Elementary School   Regular School No 1.0 PK 01 2016   kindergarten                         62.0 62.0                       124.0                         62 62                 124
1288399 IN     school 1806090 5615   Maconaquah School Corp 180609002318 6012 Pipe Creek Elementary School   Regular School No 1.0 PK 01 2016   pk_12_total 318.0 10.0 9.0 2.0   5.0         48.0   188.0 204.0     4.0             52.0   392.0 318 10 9 2   5         48   188 204     4       52   392
1288400 IN     school 1806090 5615   Maconaquah School Corp 180609002318 6012 Pipe Creek Elementary School   Regular School No 1.0 PK 01 2016   pre_kindergarten                         40.0 43.0                       83.0                         40 43                 83
1288727 IN     school 1802460 5855   Crawfordsville Com Schools 180246000290 6293 Laura Hose Elementary School   Regular School No 1.0 KG 01 2016   grade_1                         93.0 120.0                       213.0                         93 120                 213
1288728 IN     school 1802460 5855   Crawfordsville Com Schools 180246000290 6293 Laura Hose Elementary School   Regular School No 1.0 KG 01 2016   kindergarten                         110.0 100.0                       210.0                         110 100                 210
1288729 IN     school 1802460 5855   Crawfordsville Com Schools 180246000290 6293 Laura Hose Elementary School   Regular School No 1.0 KG 01 2016   pk_12_total 319.0 13.0 85.0     3.0         3.0   203.0 220.0     60.0             68.0   423.0 319 13 85     3         3   203 220     60       68   423
1289018 IN     school 1812900 6065   West Noble School Corporation 181290002055 6491 West Noble Primary School   Regular School No 1.0 PK 01 2016   grade_1                         122.0 95.0                       217.0                         122 95                 217
1289019 IN     school 1812900 6065   West Noble School Corporation 181290002055 6491 West Noble Primary School   Regular School No 1.0 PK 01 2016   kindergarten                         106.0 86.0                       192.0                         106 86                 192
1289020 IN     school 1812900 6065   West Noble School Corporation 181290002055 6491 West Noble Primary School   Regular School No 1.0 PK 01 2016   pk_12_total 209.0 2.0 202.0     4.0         3.0   238.0 182.0     158.0             50.0   420.0 209 2 202     4         3   238 182     158       50   420
1289021 IN     school 1812900 6065   West Noble School Corporation 181290002055 6491 West Noble Primary School   Regular School No 1.0 PK 01 2016   pre_kindergarten                         10.0 1.0                       11.0                         10 1                 11
1292293 IN     school 1800147 9410   KIPP Indy Unite Elementary 180014702571 5741 KIPP Indy Unite Elementary   Regular School Yes 1.0 KG 01 2016   grade_1                         58.0 47.0                       105.0                         58 47                 105
1292294 IN     school 1800147 9410   KIPP Indy Unite Elementary 180014702571 5741 KIPP Indy Unite Elementary   Regular School Yes 1.0 KG 01 2016   kindergarten                         48.0 48.0                       96.0                         48 48                 96
1292295 IN     school 1800147 9410   KIPP Indy Unite Elementary 180014702571 5741 KIPP Indy Unite Elementary   Regular School Yes 1.0 KG 01 2016   pk_12_total   196.0 2.0 1.0             2.0   106.0 95.0     0.0             16.0   201.0   196 2 1             2   106 95     0       16   201
1281381 IN     school 1802850 255   East Allen County Schools 180285000345 83 New Haven Primary School   Regular School No 1.0 PK 02 2016   grade_1                         63.0 75.0                       138.0                         63 75                 138
1281382 IN     school 1802850 255   East Allen County Schools 180285000345 83 New Haven Primary School   Regular School No 1.0 PK 02 2016   grade_2                         76.0 81.0                       157.0                         76 81                 157
1281383 IN     school 1802850 255   East Allen County Schools 180285000345 83 New Haven Primary School   Regular School No 1.0 PK 02 2016   kindergarten                         80.0 69.0                       149.0                         80 69                 149
1281384 IN     school 1802850 255   East Allen County Schools 180285000345 83 New Haven Primary School   Regular School No 1.0 PK 02 2016   pk_12_total 372.0 58.0 32.0 1.0   2.0         38.0   248.0 255.0     6.0             64.0   503.0 372 58 32 1   2         38   248 255     6       64   503
1281385 IN     school 1802850 255   East Allen County Schools 180285000345 83 New Haven Primary School   Regular School No 1.0 PK 02 2016   pre_kindergarten                         29.0 30.0                       59.0                         29 30                 59
1281424 IN     school 1802850 255   East Allen County Schools 180285000356 310 Southwick Elementary School   Regular School No 1.0 PK 02 2016   grade_1                         98.0 97.0                       195.0                         98 97                 195
1281425 IN     school 1802850 255   East Allen County Schools 180285000356 310 Southwick Elementary School   Regular School No 1.0 PK 02 2016   grade_2                         83.0 87.0                       170.0                         83 87                 170
1281426 IN     school 1802850 255   East Allen County Schools 180285000356 310 Southwick Elementary School   Regular School No 1.0 PK 02 2016   kindergarten                         97.0 97.0                       194.0                         97 97                 194
1281427 IN     school 1802850 255   East Allen County Schools 180285000356 310 Southwick Elementary School   Regular School No 1.0 PK 02 2016   pk_12_total 54.0 193.0 86.0     220.0         36.0   296.0 293.0     237.0             42.0   589.0 54 193 86     220         36   296 293     237       42   589
1281428 IN     school 1802850 255   East Allen County Schools 180285000356 310 Southwick Elementary School   Regular School No 1.0 PK 02 2016   pre_kindergarten                         18.0 12.0                       30.0                         18 12                 30
1282207 IN     school 1803660 1170   Community Schools of Frankfort 180366002423 1014 Blue Ridge Primary Elementary Sch   Regular School No 1.0 PK 02 2016   grade_1                         77.0 78.0                       155.0                         77 78                 155
1282208 IN     school 1803660 1170   Community Schools of Frankfort 180366002423 1014 Blue Ridge Primary Elementary Sch   Regular School No 1.0 PK 02 2016   grade_2                         78.0 73.0                       151.0                         78 73                 151
1282209 IN     school 1803660 1170   Community Schools of Frankfort 180366002423 1014 Blue Ridge Primary Elementary Sch   Regular School No 1.0 PK 02 2016   kindergarten                         76.0 61.0                       137.0                         76 61                 137
1282210 IN     school 1803660 1170   Community Schools of Frankfort 180366002423 1014 Blue Ridge Primary Elementary Sch   Regular School No 1.0 PK 02 2016   pk_12_total 232.0 6.0 248.0 1.0   1.0         2.0   268.0 222.0     190.0             77.0   490.0 232 6 248 1   1         2   268 222     190       77   490
1282211 IN     school 1803660 1170   Community Schools of Frankfort 180366002423 1014 Blue Ridge Primary Elementary Sch   Regular School No 1.0 PK 02 2016   pre_kindergarten                         37.0 10.0                       47.0                         37 10                 47
1282449 IN     school 1805700 1620   Lawrenceburg Com School Corp 180570001695 1210 Lawrenceburg Primary School   Regular School No 1.0 PK 02 2016   grade_1                         80.0 79.0                       159.0                         80 79                 159
1282450 IN     school 1805700 1620   Lawrenceburg Com School Corp 180570001695 1210 Lawrenceburg Primary School   Regular School No 1.0 PK 02 2016   grade_2                         84.0 78.0                       162.0                         84 78                 162
1282451 IN     school 1805700 1620   Lawrenceburg Com School Corp 180570001695 1210 Lawrenceburg Primary School   Regular School No 1.0 PK 02 2016   kindergarten                         76.0 65.0                       141.0                         76 65                 141
1282452 IN     school 1805700 1620   Lawrenceburg Com School Corp 180570001695 1210 Lawrenceburg Primary School   Regular School No 1.0 PK 02 2016   pk_12_total 437.0 7.0 3.0 1.0   5.0         38.0   262.0 229.0     2.0             68.0   491.0 437 7 3 1   5         38   262 229     2       68   491
1282453 IN     school 1805700 1620   Lawrenceburg Com School Corp 180570001695 1210 Lawrenceburg Primary School   Regular School No 1.0 PK 02 2016   pre_kindergarten                         22.0 7.0                       29.0                         22 7                 29
1282676 IN     school 1807230 1910   Yorktown Community Schools 180723001215 1395 Pleasant View Elementary School   Regular School No 1.0 KG 02 2016   grade_1                         77.0 91.0                       168.0                         77 91                 168
1282677 IN     school 1807230 1910   Yorktown Community Schools 180723001215 1395 Pleasant View Elementary School   Regular School No 1.0 KG 02 2016   grade_2                         115.0 88.0                       203.0                         115 88                 203
1282678 IN     school 1807230 1910   Yorktown Community Schools 180723001215 1395 Pleasant View Elementary School   Regular School No 1.0 KG 02 2016   kindergarten                         105.0 106.0                       211.0                         105 106                 211
1282679 IN     school 1807230 1910   Yorktown Community Schools 180723001215 1395 Pleasant View Elementary School   Regular School No 1.0 KG 02 2016   pk_12_total 513.0 17.0 12.0     13.0         27.0   297.0 285.0     13.0             61.0   582.0 513 17 12     13         27   297 285     13       61   582
1282872 IN     school 1803960 2120   Greater Jasper Con Schs 180396000683 1597 Fifth Street Elementary School   Regular School No 1.0 PK 02 2016   grade_1                         65.0 66.0                       131.0                         65 66                 131
1282873 IN     school 1803960 2120   Greater Jasper Con Schs 180396000683 1597 Fifth Street Elementary School   Regular School No 1.0 PK 02 2016   grade_2                         67.0 67.0                       134.0                         67 67                 134
1282874 IN     school 1803960 2120   Greater Jasper Con Schs 180396000683 1597 Fifth Street Elementary School   Regular School No 1.0 PK 02 2016   kindergarten                         65.0 65.0                       130.0                         65 65                 130
1282875 IN     school 1803960 2120   Greater Jasper Con Schs 180396000683 1597 Fifth Street Elementary School   Regular School No 1.0 PK 02 2016   pk_12_total 290.0 4.0 114.0     3.0         11.0   213.0 209.0     78.0             103.0   422.0 290 4 114     3         11   213 209     78       103   422
1282876 IN     school 1803960 2120   Greater Jasper Con Schs 180396000683 1597 Fifth Street Elementary School   Regular School No 1.0 PK 02 2016   pre_kindergarten                         16.0 11.0                       27.0                         16 11                 27
1282920 IN     school 1800420 2260   Baugo Community Schools 180042000089 1705 Jimtown Elementary School   Regular School No 1.0 KG 02 2016   grade_1                         64.0 68.0                       132.0                         64 68                 132
1282921 IN     school 1800420 2260   Baugo Community Schools 180042000089 1705 Jimtown Elementary School   Regular School No 1.0 KG 02 2016   grade_2                         72.0 67.0                       139.0                         72 67                 139
1282922 IN     school 1800420 2260   Baugo Community Schools 180042000089 1705 Jimtown Elementary School   Regular School No 1.0 KG 02 2016   kindergarten                         62.0 64.0                       126.0                         62 64                 126
1282923 IN     school 1800420 2260   Baugo Community Schools 180042000089 1705 Jimtown Elementary School   Regular School No 1.0 KG 02 2016   pk_12_total 330.0 5.0 28.0     5.0         29.0   198.0 199.0     24.0             39.0   397.0 330 5 28     5         29   198 199     24       39   397
1283487 IN     school 1809630 2645   Rochester Community Sch Corp 180963001574 2181 Columbia Elementary School   Regular School No 1.0 PK 02 2016   grade_1                         70.0 74.0                       144.0                         70 74                 144
1283488 IN     school 1809630 2645   Rochester Community Sch Corp 180963001574 2181 Columbia Elementary School   Regular School No 1.0 PK 02 2016   grade_2                         86.0 70.0                       156.0                         86 70                 156
1283489 IN     school 1809630 2645   Rochester Community Sch Corp 180963001574 2181 Columbia Elementary School   Regular School No 1.0 PK 02 2016   kindergarten                         54.0 66.0                       120.0                         54 66                 120
1283490 IN     school 1809630 2645   Rochester Community Sch Corp 180963001574 2181 Columbia Elementary School   Regular School No 1.0 PK 02 2016   pk_12_total 407.0 4.0 23.0               11.0   225.0 220.0     4.0             58.0   445.0 407 4 23               11   225 220     4       58   445
1283491 IN     school 1809630 2645   Rochester Community Sch Corp 180963001574 2181 Columbia Elementary School   Regular School No 1.0 PK 02 2016   pre_kindergarten                         15.0 10.0                       25.0                         15 10                 25
1283559 IN     school 1807770 2735   North Gibson School Corp 180777001325 2257 Princeton Comm Primary School   Regular School No 1.0 PK 02 2016   grade_1                         74.0 60.0                       134.0                         74 60                 134
1283560 IN     school 1807770 2735   North Gibson School Corp 180777001325 2257 Princeton Comm Primary School   Regular School No 1.0 PK 02 2016   grade_2                         91.0 84.0                       175.0                         91 84                 175
1283561 IN     school 1807770 2735   North Gibson School Corp 180777001325 2257 Princeton Comm Primary School   Regular School No 1.0 PK 02 2016   kindergarten                         97.0 58.0                       155.0                         97 58                 155
1283562 IN     school 1807770 2735   North Gibson School Corp 180777001325 2257 Princeton Comm Primary School   Regular School No 1.0 PK 02 2016   pk_12_total 394.0 22.0 22.0     2.0         37.0   273.0 204.0     5.0             135.0   477.0 394 22 22     2         37   273 204     5       135   477
1283563 IN     school 1807770 2735   North Gibson School Corp 180777001325 2257 Princeton Comm Primary School   Regular School No 1.0 PK 02 2016   pre_kindergarten                         11.0 2.0                       13.0                         11 2                 13
1283913 IN     school 1804260 3025   Hamilton Heights School Corp 180426001653 2502 Hamilton Heights Primary School   Regular School No 1.0 PK 02 2016   grade_1                         69.0 79.0                       148.0                         69 79                 148
1283914 IN     school 1804260 3025   Hamilton Heights School Corp 180426001653 2502 Hamilton Heights Primary School   Regular School No 1.0 PK 02 2016   grade_2                         89.0 69.0                       158.0                         89 69                 158

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