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
1162009 IN     school 1802430 2440   Covington Community Sch Corp 180243000277 2013 Covington Middle School   Regular School No 2.0 06 08 2015   grade_6                         36.0 30.0                       66.0                         36 30                 66
1162010 IN     school 1802430 2440   Covington Community Sch Corp 180243000277 2013 Covington Middle School   Regular School No 2.0 06 08 2015   grade_7                         36.0 38.0                       74.0                         36 38                 74
1162011 IN     school 1802430 2440   Covington Community Sch Corp 180243000277 2013 Covington Middle School   Regular School No 2.0 06 08 2015   grade_8                         39.0 34.0                       73.0                         39 34                 73
1162012 IN     school 1802430 2440   Covington Community Sch Corp 180243000277 2013 Covington Middle School   Regular School No 2.0 06 08 2015   pk_12_total 193.0   14.0     2.0         4.0   111.0 102.0     2.0             42.0   213.0 193   14     2         4   111 102     2       42   213
1162013 IN     school 1810620 2455   Southeast Fountain School Corp 181062001743 2021 Southeast Fountain Elementary   Regular School No 1.0 KG 06 2015   grade_1                         36.0 52.0                       88.0                         36 52                 88
1162014 IN     school 1810620 2455   Southeast Fountain School Corp 181062001743 2021 Southeast Fountain Elementary   Regular School No 1.0 KG 06 2015   grade_2                         29.0 50.0                       79.0                         29 50                 79
1162015 IN     school 1810620 2455   Southeast Fountain School Corp 181062001743 2021 Southeast Fountain Elementary   Regular School No 1.0 KG 06 2015   grade_3                         48.0 31.0                       79.0                         48 31                 79
1162016 IN     school 1810620 2455   Southeast Fountain School Corp 181062001743 2021 Southeast Fountain Elementary   Regular School No 1.0 KG 06 2015   grade_4                         43.0 21.0                       64.0                         43 21                 64
1162017 IN     school 1810620 2455   Southeast Fountain School Corp 181062001743 2021 Southeast Fountain Elementary   Regular School No 1.0 KG 06 2015   grade_5                         45.0 41.0                       86.0                         45 41                 86
1162018 IN     school 1810620 2455   Southeast Fountain School Corp 181062001743 2021 Southeast Fountain Elementary   Regular School No 1.0 KG 06 2015   grade_6                         49.0 37.0                       86.0                         49 37                 86
1162019 IN     school 1810620 2455   Southeast Fountain School Corp 181062001743 2021 Southeast Fountain Elementary   Regular School No 1.0 KG 06 2015   kindergarten                         39.0 40.0                       79.0                         39 40                 79
1162020 IN     school 1810620 2455   Southeast Fountain School Corp 181062001743 2021 Southeast Fountain Elementary   Regular School No 1.0 KG 06 2015   pk_12_total 505.0   40.0 2.0             14.0   289.0 272.0     13.0             85.0   561.0 505   40 2             14   289 272     13       85   561
1162021 IN     school 1810620 2455   Southeast Fountain School Corp 181062001742 2022 Fountain Central High School   Regular School No 3.0 07 12 2015   adult                         0.0 1.0                       1.0                         0 1                 1
1162022 IN     school 1810620 2455   Southeast Fountain School Corp 181062001742 2022 Fountain Central High School   Regular School No 3.0 07 12 2015   grade_10                         47.0 52.0                       99.0                         47 52                 99
1162023 IN     school 1810620 2455   Southeast Fountain School Corp 181062001742 2022 Fountain Central High School   Regular School No 3.0 07 12 2015   grade_11                         48.0 49.0                       97.0                         48 49                 97
1162024 IN     school 1810620 2455   Southeast Fountain School Corp 181062001742 2022 Fountain Central High School   Regular School No 3.0 07 12 2015   grade_12                         46.0 41.0                       87.0                         46 41                 87
1162025 IN     school 1810620 2455   Southeast Fountain School Corp 181062001742 2022 Fountain Central High School   Regular School No 3.0 07 12 2015   grade_7                         44.0 38.0                       82.0                         44 38                 82
1162026 IN     school 1810620 2455   Southeast Fountain School Corp 181062001742 2022 Fountain Central High School   Regular School No 3.0 07 12 2015   grade_8                         65.0 39.0                       104.0                         65 39                 104
1162027 IN     school 1810620 2455   Southeast Fountain School Corp 181062001742 2022 Fountain Central High School   Regular School No 3.0 07 12 2015   grade_9                         41.0 49.0                       90.0                         41 49                 90
1162028 IN     school 1810620 2455   Southeast Fountain School Corp 181062001742 2022 Fountain Central High School   Regular School No 3.0 07 12 2015   pk_12_total 516.0   27.0 5.0   2.0         10.0   291.0 269.0     11.0             75.0   560.0 516   27 5   2         10   291 269     11       75   560
1162029 IN     school 1803700 2475   Franklin County Com Sch Corp 180370002221 2082 Laurel School   Regular School No 1.0 PK 08 2015   grade_1                         31.0 25.0                       56.0                         31 25                 56
1162030 IN     school 1803700 2475   Franklin County Com Sch Corp 180370002221 2082 Laurel School   Regular School No 1.0 PK 08 2015   grade_2                         21.0 19.0                       40.0                         21 19                 40
1162031 IN     school 1803700 2475   Franklin County Com Sch Corp 180370002221 2082 Laurel School   Regular School No 1.0 PK 08 2015   grade_3                         26.0 20.0                       46.0                         26 20                 46
1162032 IN     school 1803700 2475   Franklin County Com Sch Corp 180370002221 2082 Laurel School   Regular School No 1.0 PK 08 2015   grade_4                         29.0 25.0                       54.0                         29 25                 54
1162033 IN     school 1803700 2475   Franklin County Com Sch Corp 180370002221 2082 Laurel School   Regular School No 1.0 PK 08 2015   grade_5                         24.0 14.0                       38.0                         24 14                 38
1162034 IN     school 1803700 2475   Franklin County Com Sch Corp 180370002221 2082 Laurel School   Regular School No 1.0 PK 08 2015   grade_6                         34.0 28.0                       62.0                         34 28                 62
1162035 IN     school 1803700 2475   Franklin County Com Sch Corp 180370002221 2082 Laurel School   Regular School No 1.0 PK 08 2015   grade_7                         25.0 18.0                       43.0                         25 18                 43
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

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