Data source: Big Local News · About: Big Local

84,143 rows where state = "IN"

View and edit SQL

grade

year

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
1162036 IN     school 1803700 2475   Franklin County Com Sch Corp 180370002221 2082 Laurel School   Regular School No 1.0 PK 08 2015   grade_8                         27.0 22.0                       49.0                         27 22                 49
1162037 IN     school 1803700 2475   Franklin County Com Sch Corp 180370002221 2082 Laurel School   Regular School No 1.0 PK 08 2015   kindergarten                         23.0 18.0                       41.0                         23 18                 41
1162038 IN     school 1803700 2475   Franklin County Com Sch Corp 180370002221 2082 Laurel School   Regular School No 1.0 PK 08 2015   pk_12_total 454.0   2.0     1.0         2.0   257.0 202.0     0.0             81.0   459.0 454   2     1         2   257 202     0       81   459
1162039 IN     school 1803700 2475   Franklin County Com Sch Corp 180370002221 2082 Laurel School   Regular School No 1.0 PK 08 2015   pre_kindergarten                         17.0 13.0                       30.0                         17 13                 30
1162040 IN     school 1803700 2475   Franklin County Com Sch Corp 180370002336 2083 Franklin County High   Regular School No 3.0 09 12 2015   grade_10                         108.0 115.0                       223.0                         108 115                 223
1162041 IN     school 1803700 2475   Franklin County Com Sch Corp 180370002336 2083 Franklin County High   Regular School No 3.0 09 12 2015   grade_11                         103.0 115.0                       218.0                         103 115                 218
1162042 IN     school 1803700 2475   Franklin County Com Sch Corp 180370002336 2083 Franklin County High   Regular School No 3.0 09 12 2015   grade_12                         106.0 104.0                       210.0                         106 104                 210
1162043 IN     school 1803700 2475   Franklin County Com Sch Corp 180370002336 2083 Franklin County High   Regular School No 3.0 09 12 2015   grade_9                         121.0 117.0                       238.0                         121 117                 238
1162044 IN     school 1803700 2475   Franklin County Com Sch Corp 180370002336 2083 Franklin County High   Regular School No 3.0 09 12 2015   pk_12_total 875.0   7.0     1.0         6.0   438.0 451.0     0.0             102.0   889.0 875   7     1         6   438 451     0       102   889
1162045 IN     school 1803700 2475   Franklin County Com Sch Corp 180370000589 2123 Brookville Middle Sch   Regular School No 2.0 05 08 2015   grade_5                         55.0 55.0                       110.0                         55 55                 110
1162046 IN     school 1803700 2475   Franklin County Com Sch Corp 180370000589 2123 Brookville Middle Sch   Regular School No 2.0 05 08 2015   grade_6                         46.0 48.0                       94.0                         46 48                 94
1162047 IN     school 1803700 2475   Franklin County Com Sch Corp 180370000589 2123 Brookville Middle Sch   Regular School No 2.0 05 08 2015   grade_7                         56.0 59.0                       115.0                         56 59                 115
1162048 IN     school 1803700 2475   Franklin County Com Sch Corp 180370000589 2123 Brookville Middle Sch   Regular School No 2.0 05 08 2015   grade_8                         47.0 58.0                       105.0                         47 58                 105
1162049 IN     school 1803700 2475   Franklin County Com Sch Corp 180370000589 2123 Brookville Middle Sch   Regular School No 2.0 05 08 2015   pk_12_total 417.0   3.0               4.0   204.0 220.0     0.0             63.0   424.0 417   3               4   204 220     0       63   424
1162050 IN     school 1803700 2475   Franklin County Com Sch Corp 180370000587 2125 Brookville Elementary School   Regular School No 1.0 PK 04 2015   grade_1                         41.0 51.0                       92.0                         41 51                 92
1162051 IN     school 1803700 2475   Franklin County Com Sch Corp 180370000587 2125 Brookville Elementary School   Regular School No 1.0 PK 04 2015   grade_2                         56.0 58.0                       114.0                         56 58                 114
1162052 IN     school 1803700 2475   Franklin County Com Sch Corp 180370000587 2125 Brookville Elementary School   Regular School No 1.0 PK 04 2015   grade_3                         55.0 56.0                       111.0                         55 56                 111
1162053 IN     school 1803700 2475   Franklin County Com Sch Corp 180370000587 2125 Brookville Elementary School   Regular School No 1.0 PK 04 2015   grade_4                         45.0 45.0                       90.0                         45 45                 90
1162054 IN     school 1803700 2475   Franklin County Com Sch Corp 180370000587 2125 Brookville Elementary School   Regular School No 1.0 PK 04 2015   kindergarten                         37.0 32.0                       69.0                         37 32                 69
1162055 IN     school 1803700 2475   Franklin County Com Sch Corp 180370000587 2125 Brookville Elementary School   Regular School No 1.0 PK 04 2015   pk_12_total 486.0 1.0 3.0     2.0         2.0   245.0 249.0     2.0             86.0   494.0 486 1 3     2         2   245 249     2       86   494
1162056 IN     school 1803700 2475   Franklin County Com Sch Corp 180370000587 2125 Brookville Elementary School   Regular School No 1.0 PK 04 2015   pre_kindergarten                         11.0 7.0                       18.0                         11 7                 18
1162057 IN     school 1803700 2475   Franklin County Com Sch Corp 180370000591 2127 Mount Carmel School   Regular School No 1.0 KG 08 2015   grade_1                         18.0 22.0                       40.0                         18 22                 40
1162058 IN     school 1803700 2475   Franklin County Com Sch Corp 180370000591 2127 Mount Carmel School   Regular School No 1.0 KG 08 2015   grade_2                         26.0 30.0                       56.0                         26 30                 56
1162059 IN     school 1803700 2475   Franklin County Com Sch Corp 180370000591 2127 Mount Carmel School   Regular School No 1.0 KG 08 2015   grade_3                         31.0 22.0                       53.0                         31 22                 53
1162060 IN     school 1803700 2475   Franklin County Com Sch Corp 180370000591 2127 Mount Carmel School   Regular School No 1.0 KG 08 2015   grade_4                         26.0 32.0                       58.0                         26 32                 58
1162061 IN     school 1803700 2475   Franklin County Com Sch Corp 180370000591 2127 Mount Carmel School   Regular School No 1.0 KG 08 2015   grade_5                         25.0 28.0                       53.0                         25 28                 53
1162062 IN     school 1803700 2475   Franklin County Com Sch Corp 180370000591 2127 Mount Carmel School   Regular School No 1.0 KG 08 2015   grade_6                         31.0 19.0                       50.0                         31 19                 50
1162063 IN     school 1803700 2475   Franklin County Com Sch Corp 180370000591 2127 Mount Carmel School   Regular School No 1.0 KG 08 2015   grade_7                         21.0 12.0                       33.0                         21 12                 33
1162064 IN     school 1803700 2475   Franklin County Com Sch Corp 180370000591 2127 Mount Carmel School   Regular School No 1.0 KG 08 2015   grade_8                         24.0 23.0                       47.0                         24 23                 47
1162065 IN     school 1803700 2475   Franklin County Com Sch Corp 180370000591 2127 Mount Carmel School   Regular School No 1.0 KG 08 2015   kindergarten                         23.0 20.0                       43.0                         23 20                 43
1162066 IN     school 1803700 2475   Franklin County Com Sch Corp 180370000591 2127 Mount Carmel School   Regular School No 1.0 KG 08 2015   pk_12_total 427.0 3.0                 3.0   225.0 208.0     0.0             48.0   433.0 427 3                 3   225 208     0       48   433
1162067 IN     school 1809630 2645   Rochester Community Sch Corp 180963001576 2173 Rochester Community High Sch   Regular School No 3.0 09 12 2015   adult                         1.0 2.0                       3.0                         1 2                 3
1162068 IN     school 1809630 2645   Rochester Community Sch Corp 180963001576 2173 Rochester Community High Sch   Regular School No 3.0 09 12 2015   grade_10                         58.0 68.0                       126.0                         58 68                 126
1162069 IN     school 1809630 2645   Rochester Community Sch Corp 180963001576 2173 Rochester Community High Sch   Regular School No 3.0 09 12 2015   grade_11                         74.0 65.0                       139.0                         74 65                 139
1162070 IN     school 1809630 2645   Rochester Community Sch Corp 180963001576 2173 Rochester Community High Sch   Regular School No 3.0 09 12 2015   grade_12                         73.0 53.0                       126.0                         73 53                 126
1162071 IN     school 1809630 2645   Rochester Community Sch Corp 180963001576 2173 Rochester Community High Sch   Regular School No 3.0 09 12 2015   grade_9                         70.0 68.0                       138.0                         70 68                 138
1162072 IN     school 1809630 2645   Rochester Community Sch Corp 180963001576 2173 Rochester Community High Sch   Regular School No 3.0 09 12 2015   pk_12_total 473.0 2.0 26.0 5.0   4.0     3.0   19.0   276.0 256.0     6.0             90.0   532.0 473 2 26 5   4     3   19   276 256     6       90   532
1162073 IN     school 1809630 2645   Rochester Community Sch Corp 180963001577 2177 Rochester Community Md Sch   Regular School No 2.0 06 08 2015   grade_6                         67.0 66.0                       133.0                         67 66                 133
1162074 IN     school 1809630 2645   Rochester Community Sch Corp 180963001577 2177 Rochester Community Md Sch   Regular School No 2.0 06 08 2015   grade_7                         67.0 73.0                       140.0                         67 73                 140
1162075 IN     school 1809630 2645   Rochester Community Sch Corp 180963001577 2177 Rochester Community Md Sch   Regular School No 2.0 06 08 2015   grade_8                         73.0 62.0                       135.0                         73 62                 135
1162076 IN     school 1809630 2645   Rochester Community Sch Corp 180963001577 2177 Rochester Community Md Sch   Regular School No 2.0 06 08 2015   pk_12_total 367.0 1.0 25.0 6.0             9.0   207.0 201.0     3.0             63.0   408.0 367 1 25 6             9   207 201     3       63   408
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
1162082 IN     school 1809630 2645   Rochester Community Sch Corp 180963001575 2185 George M Riddle Elem School   Regular School No 1.0 03 05 2015   grade_3                         77.0 81.0                       158.0                         77 81                 158
1162083 IN     school 1809630 2645   Rochester Community Sch Corp 180963001575 2185 George M Riddle Elem School   Regular School No 1.0 03 05 2015   grade_4                         84.0 78.0                       162.0                         84 78                 162
1162084 IN     school 1809630 2645   Rochester Community Sch Corp 180963001575 2185 George M Riddle Elem School   Regular School No 1.0 03 05 2015   grade_5                         66.0 80.0                       146.0                         66 80                 146
1162085 IN     school 1809630 2645   Rochester Community Sch Corp 180963001575 2185 George M Riddle Elem School   Regular School No 1.0 03 05 2015   pk_12_total 414.0 6.0 23.0     3.0         20.0   227.0 239.0     5.0             82.0   466.0 414 6 23     3         20   227 239     5       82   466
1162086 IN     school 1801410 2650   Caston School Corporation 180141000206 2157 Caston Elementary School   Regular School No 1.0 KG 06 2015   grade_1                         21.0 23.0                       44.0                         21 23                 44
1162087 IN     school 1801410 2650   Caston School Corporation 180141000206 2157 Caston Elementary School   Regular School No 1.0 KG 06 2015   grade_2                         20.0 21.0                       41.0                         20 21                 41
1162088 IN     school 1801410 2650   Caston School Corporation 180141000206 2157 Caston Elementary School   Regular School No 1.0 KG 06 2015   grade_3                         29.0 25.0                       54.0                         29 25                 54
1162089 IN     school 1801410 2650   Caston School Corporation 180141000206 2157 Caston Elementary School   Regular School No 1.0 KG 06 2015   grade_4                         25.0 25.0                       50.0                         25 25                 50
1162090 IN     school 1801410 2650   Caston School Corporation 180141000206 2157 Caston Elementary School   Regular School No 1.0 KG 06 2015   grade_5                         27.0 33.0                       60.0                         27 33                 60
1162091 IN     school 1801410 2650   Caston School Corporation 180141000206 2157 Caston Elementary School   Regular School No 1.0 KG 06 2015   grade_6                         25.0 23.0                       48.0                         25 23                 48
1162092 IN     school 1801410 2650   Caston School Corporation 180141000206 2157 Caston Elementary School   Regular School No 1.0 KG 06 2015   kindergarten                         20.0 19.0                       39.0                         20 19                 39
1162093 IN     school 1801410 2650   Caston School Corporation 180141000206 2157 Caston Elementary School   Regular School No 1.0 KG 06 2015   pk_12_total 307.0 2.0 19.0               8.0   167.0 169.0     4.0             27.0   336.0 307 2 19               8   167 169     4       27   336
1162094 IN     school 1801410 2650   Caston School Corporation 180141000207 2159 Caston Jr-Sr High Sch   Regular School No 3.0 07 12 2015   grade_10                         39.0 34.0                       73.0                         39 34                 73
1162095 IN     school 1801410 2650   Caston School Corporation 180141000207 2159 Caston Jr-Sr High Sch   Regular School No 3.0 07 12 2015   grade_11                         39.0 24.0                       63.0                         39 24                 63
1162096 IN     school 1801410 2650   Caston School Corporation 180141000207 2159 Caston Jr-Sr High Sch   Regular School No 3.0 07 12 2015   grade_12                         49.0 30.0                       79.0                         49 30                 79
1162097 IN     school 1801410 2650   Caston School Corporation 180141000207 2159 Caston Jr-Sr High Sch   Regular School No 3.0 07 12 2015   grade_7                         27.0 31.0                       58.0                         27 31                 58
1162098 IN     school 1801410 2650   Caston School Corporation 180141000207 2159 Caston Jr-Sr High Sch   Regular School No 3.0 07 12 2015   grade_8                         24.0 23.0                       47.0                         24 23                 47
1162099 IN     school 1801410 2650   Caston School Corporation 180141000207 2159 Caston Jr-Sr High Sch   Regular School No 3.0 07 12 2015   grade_9                         36.0 39.0                       75.0                         36 39                 75
1162100 IN     school 1801410 2650   Caston School Corporation 180141000207 2159 Caston Jr-Sr High Sch   Regular School No 3.0 07 12 2015   pk_12_total 365.0 2.0 20.0 1.0   3.0         4.0   214.0 181.0     2.0             59.0   395.0 365 2 20 1   3         4   214 181     2       59   395
1162101 IN     school 1802940 2725   East Gibson School Corporation 180294000383 2189 Barton Twp Elementary   Regular School No 1.0 KG 06 2015   grade_1                         9.0 10.0                       19.0                         9 10                 19
1162102 IN     school 1802940 2725   East Gibson School Corporation 180294000383 2189 Barton Twp Elementary   Regular School No 1.0 KG 06 2015   grade_2                         6.0 10.0                       16.0                         6 10                 16
1162103 IN     school 1802940 2725   East Gibson School Corporation 180294000383 2189 Barton Twp Elementary   Regular School No 1.0 KG 06 2015   grade_3                         14.0 8.0                       22.0                         14 8                 22
1162104 IN     school 1802940 2725   East Gibson School Corporation 180294000383 2189 Barton Twp Elementary   Regular School No 1.0 KG 06 2015   grade_4                         5.0 6.0                       11.0                         5 6                 11
1162105 IN     school 1802940 2725   East Gibson School Corporation 180294000383 2189 Barton Twp Elementary   Regular School No 1.0 KG 06 2015   grade_5                         10.0 14.0                       24.0                         10 14                 24
1162106 IN     school 1802940 2725   East Gibson School Corporation 180294000383 2189 Barton Twp Elementary   Regular School No 1.0 KG 06 2015   grade_6                         9.0 6.0                       15.0                         9 6                 15
1162107 IN     school 1802940 2725   East Gibson School Corporation 180294000383 2189 Barton Twp Elementary   Regular School No 1.0 KG 06 2015   kindergarten                         11.0 9.0                       20.0                         11 9                 20
1162108 IN     school 1802940 2725   East Gibson School Corporation 180294000383 2189 Barton Twp Elementary   Regular School No 1.0 KG 06 2015   pk_12_total 124.0                   3.0   64.0 63.0     0.0             23.0   127.0 124                   3   64 63     0       23   127
1162109 IN     school 1802940 2725   East Gibson School Corporation 180294000622 2194 Waldo J Wood Memorial JHS   Regular School No 2.0 07 08 2015   grade_7                         33.0 29.0                       62.0                         33 29                 62
1162110 IN     school 1802940 2725   East Gibson School Corporation 180294000622 2194 Waldo J Wood Memorial JHS   Regular School No 2.0 07 08 2015   grade_8                         42.0 35.0                       77.0                         42 35                 77
1162111 IN     school 1802940 2725   East Gibson School Corporation 180294000622 2194 Waldo J Wood Memorial JHS   Regular School No 2.0 07 08 2015   pk_12_total 136.0 1.0                 2.0   75.0 64.0     0.0             21.0   139.0 136 1                 2   75 64     0       21   139
1162112 IN     school 1802940 2725   East Gibson School Corporation 180294000382 2201 Francisco Elementary School   Regular School No 1.0 KG 06 2015   grade_1                         8.0 4.0                       12.0                         8 4                 12
1162113 IN     school 1802940 2725   East Gibson School Corporation 180294000382 2201 Francisco Elementary School   Regular School No 1.0 KG 06 2015   grade_2                         6.0 6.0                       12.0                         6 6                 12
1162114 IN     school 1802940 2725   East Gibson School Corporation 180294000382 2201 Francisco Elementary School   Regular School No 1.0 KG 06 2015   grade_3                         7.0 10.0                       17.0                         7 10                 17
1162115 IN     school 1802940 2725   East Gibson School Corporation 180294000382 2201 Francisco Elementary School   Regular School No 1.0 KG 06 2015   grade_4                         11.0 7.0                       18.0                         11 7                 18
1162116 IN     school 1802940 2725   East Gibson School Corporation 180294000382 2201 Francisco Elementary School   Regular School No 1.0 KG 06 2015   grade_5                         3.0 8.0                       11.0                         3 8                 11
1162117 IN     school 1802940 2725   East Gibson School Corporation 180294000382 2201 Francisco Elementary School   Regular School No 1.0 KG 06 2015   grade_6                         9.0 10.0                       19.0                         9 10                 19
1162118 IN     school 1802940 2725   East Gibson School Corporation 180294000382 2201 Francisco Elementary School   Regular School No 1.0 KG 06 2015   kindergarten                         6.0 4.0                       10.0                         6 4                 10
1162119 IN     school 1802940 2725   East Gibson School Corporation 180294000382 2201 Francisco Elementary School   Regular School No 1.0 KG 06 2015   pk_12_total 97.0                   2.0   50.0 49.0     0.0             18.0   99.0 97                   2   50 49     0       18   99
1162120 IN     school 1802940 2725   East Gibson School Corporation 180294000386 2233 Waldo J Wood Memorial High   Regular School No 3.0 09 12 2015   grade_10                         48.0 45.0                       93.0                         48 45                 93
1162121 IN     school 1802940 2725   East Gibson School Corporation 180294000386 2233 Waldo J Wood Memorial High   Regular School No 3.0 09 12 2015   grade_11                         27.0 31.0                       58.0                         27 31                 58
1162122 IN     school 1802940 2725   East Gibson School Corporation 180294000386 2233 Waldo J Wood Memorial High   Regular School No 3.0 09 12 2015   grade_12                         33.0 26.0                       59.0                         33 26                 59
1162123 IN     school 1802940 2725   East Gibson School Corporation 180294000386 2233 Waldo J Wood Memorial High   Regular School No 3.0 09 12 2015   grade_9                         36.0 28.0                       64.0                         36 28                 64
1162124 IN     school 1802940 2725   East Gibson School Corporation 180294000386 2233 Waldo J Wood Memorial High   Regular School No 3.0 09 12 2015   pk_12_total 268.0 1.0 3.0     1.0         1.0   144.0 130.0     2.0             51.0   274.0 268 1 3     1         1   144 130     2       51   274
1162125 IN     school 1802940 2725   East Gibson School Corporation 180294000384 2237 Oakland City Elementary School   Regular School No 1.0 PK 06 2015   grade_1                         23.0 12.0                       35.0                         23 12                 35
1162126 IN     school 1802940 2725   East Gibson School Corporation 180294000384 2237 Oakland City Elementary School   Regular School No 1.0 PK 06 2015   grade_2                         26.0 15.0                       41.0                         26 15                 41
1162127 IN     school 1802940 2725   East Gibson School Corporation 180294000384 2237 Oakland City Elementary School   Regular School No 1.0 PK 06 2015   grade_3                         17.0 18.0                       35.0                         17 18                 35
1162128 IN     school 1802940 2725   East Gibson School Corporation 180294000384 2237 Oakland City Elementary School   Regular School No 1.0 PK 06 2015   grade_4                         22.0 21.0                       43.0                         22 21                 43
1162129 IN     school 1802940 2725   East Gibson School Corporation 180294000384 2237 Oakland City Elementary School   Regular School No 1.0 PK 06 2015   grade_5                         18.0 15.0                       33.0                         18 15                 33
1162130 IN     school 1802940 2725   East Gibson School Corporation 180294000384 2237 Oakland City Elementary School   Regular School No 1.0 PK 06 2015   grade_6                         19.0 24.0                       43.0                         19 24                 43
1162131 IN     school 1802940 2725   East Gibson School Corporation 180294000384 2237 Oakland City Elementary School   Regular School No 1.0 PK 06 2015   kindergarten                         18.0 21.0                       39.0                         18 21                 39
1162132 IN     school 1802940 2725   East Gibson School Corporation 180294000384 2237 Oakland City Elementary School   Regular School No 1.0 PK 06 2015   pk_12_total 281.0 2.0 2.0               8.0   161.0 132.0     0.0             103.0   293.0 281 2 2               8   161 132     0       103   293
1162133 IN     school 1802940 2725   East Gibson School Corporation 180294000384 2237 Oakland City Elementary School   Regular School No 1.0 PK 06 2015   pre_kindergarten                         18.0 6.0                       24.0                         18 6                 24
1162134 IN     school 1807770 2735   North Gibson School Corp 180777001324 2223 Princeton Comm Intermediate School   Regular School No 1.0 01 05 2015   grade_1                         1.0 0.0                       1.0                         1 0                 1
1162135 IN     school 1807770 2735   North Gibson School Corp 180777001324 2223 Princeton Comm Intermediate School   Regular School No 1.0 01 05 2015   grade_2                         4.0 0.0                       4.0                         4 0                 4

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