enrollments
Data source: Big Local News · About: Big Local
8,341 rows where grade = "grade_8" and state = "GA" sorted by district_nces_id
This data as json, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12234 | 12234 | GA | school | 1300001 | 741 | Troup County | 130000103620 | 207 | Ault Academy | Special Education School | No | 4 | 06 | 11 | 2015 | fall | grade_8 | 3 | 5 | 0 | 0 | 0 | 0 | 0 | 8 | 0 | 8 | 3 | 5 | 0 | 0 | 0 | 0 | 0 | 8 | 0 | 8 | |||||||||||||||||||||||||||||||||
12235 | 12235 | GA | school | 1300001 | 741 | Troup County | 130000102443 | 204 | Callaway Middle School | Regular School | No | 2 | 06 | 08 | 2015 | fall | grade_8 | 84 | 124 | 8 | 0 | 7 | 0 | 7 | 114 | 116 | 230 | 84 | 124 | 8 | 0 | 7 | 0 | 7 | 114 | 116 | 230 | |||||||||||||||||||||||||||||||||
12236 | 12236 | GA | school | 1300001 | 741 | Troup County | 130000100593 | 191 | Gardner-Newman Middle School | Regular School | No | 2 | 06 | 08 | 2015 | fall | grade_8 | 142 | 159 | 22 | 1 | 6 | 0 | 14 | 177 | 167 | 344 | 142 | 159 | 22 | 1 | 6 | 0 | 14 | 177 | 167 | 344 | |||||||||||||||||||||||||||||||||
12237 | 12237 | GA | school | 1300001 | 741 | Troup County | 130000101852 | 297 | Long Cane Middle School | Regular School | No | 2 | 06 | 08 | 2015 | fall | grade_8 | 199 | 110 | 19 | 0 | 3 | 0 | 18 | 185 | 164 | 349 | 199 | 110 | 19 | 0 | 3 | 0 | 18 | 185 | 164 | 349 | |||||||||||||||||||||||||||||||||
308558 | 308558 | GA | school | 1300001 | 741 | Troup County | 130000103620 | 207 | Ault Academy | Special Education School | No | Other | 06 | 12 | 2017 | spring | grade_8 | 8 | 5 | 1 | 0 | 0 | 0 | 0 | 14 | 0 | 14 | 8 | 5 | 1 | 0 | 0 | 0 | 0 | 14 | 0 | 14 | |||||||||||||||||||||||||||||||||
308559 | 308559 | GA | school | 1300001 | 741 | Troup County | 130000102443 | 204 | Callaway Middle School | Regular School | No | Middle | 06 | 08 | 2017 | spring | grade_8 | 89 | 109 | 7 | 0 | 3 | 0 | 18 | 119 | 107 | 226 | 89 | 109 | 7 | 0 | 3 | 0 | 18 | 119 | 107 | 226 | |||||||||||||||||||||||||||||||||
308560 | 308560 | GA | school | 1300001 | 741 | Troup County | 130000100593 | 191 | Gardner-Newman Middle School | Regular School | No | Middle | 06 | 08 | 2017 | spring | grade_8 | 120 | 141 | 24 | 1 | 11 | 0 | 13 | 153 | 157 | 310 | 120 | 141 | 24 | 1 | 11 | 0 | 13 | 153 | 157 | 310 | |||||||||||||||||||||||||||||||||
308561 | 308561 | GA | school | 1300001 | 741 | Troup County | 130000101852 | 297 | Long Cane Middle School | Regular School | No | Middle | 06 | 08 | 2017 | spring | grade_8 | 180 | 112 | 11 | 0 | 1 | 0 | 21 | 163 | 162 | 325 | 180 | 112 | 11 | 0 | 1 | 0 | 21 | 163 | 162 | 325 | |||||||||||||||||||||||||||||||||
323115 | 323115 | GA | school | 1300001 | 741 | Troup County | 130000103620 | 207 | Ault Academy | Regular School | No | Secondary | 06 | 11 | 2020 | spring | grade_8 | 4 | 6 | 0 | 0 | 0 | 0 | 1 | 11 | 0 | 11 | 4 | 6 | 0 | 0 | 0 | 0 | 1 | 11 | 0 | 11 | |||||||||||||||||||||||||||||||||
323116 | 323116 | GA | school | 1300001 | 741 | Troup County | 130000102443 | 204 | Callaway Middle School | Regular School | No | Middle | 06 | 08 | 2020 | spring | grade_8 | 89 | 139 | 17 | 1 | 3 | 0 | 8 | 131 | 126 | 257 | 89 | 139 | 17 | 1 | 3 | 0 | 8 | 131 | 126 | 257 | |||||||||||||||||||||||||||||||||
323117 | 323117 | GA | school | 1300001 | 741 | Troup County | 130000100593 | 191 | Gardner-Newman Middle School | Regular School | No | Middle | 06 | 08 | 2020 | spring | grade_8 | 95 | 155 | 18 | 1 | 4 | 0 | 15 | 151 | 137 | 288 | 95 | 155 | 18 | 1 | 4 | 0 | 15 | 151 | 137 | 288 | |||||||||||||||||||||||||||||||||
323118 | 323118 | GA | school | 1300001 | 741 | Troup County | 130000101852 | 297 | Long Cane Middle School | Regular School | No | Middle | 06 | 08 | 2020 | spring | grade_8 | 172 | 128 | 16 | 0 | 4 | 1 | 12 | 167 | 166 | 333 | 172 | 128 | 16 | 0 | 4 | 1 | 12 | 167 | 166 | 333 | |||||||||||||||||||||||||||||||||
323119 | 323119 | GA | school | 1300001 | 741 | Troup County | 130000104369 | 699 | The Hope Academy School | Regular School | No | High | 06 | 12 | 2020 | spring | grade_8 | 1 | 11 | 0 | 0 | 0 | 0 | 1 | 8 | 5 | 13 | 1 | 11 | 0 | 0 | 0 | 0 | 1 | 8 | 5 | 13 | |||||||||||||||||||||||||||||||||
415044 | 415044 | GA | school | 1300001 | 741 | Troup County | 130000103620 | 207 | Ault Academy | Regular School | No | High | 07 | 12 | 2021 | fall | grade_8 | 0 | 4 | 1 | 0 | 0 | 0 | 0 | 5 | 0 | 5 | 0 | 4 | 1 | 0 | 0 | 0 | 0 | 5 | 0 | 5 | |||||||||||||||||||||||||||||||||
415045 | 415045 | GA | school | 1300001 | 741 | Troup County | 130000102443 | 204 | Callaway Middle School | Regular School | No | Middle | 06 | 08 | 2021 | fall | grade_8 | 73 | 125 | 23 | 1 | 3 | 0 | 13 | 122 | 116 | 238 | 73 | 125 | 23 | 1 | 3 | 0 | 13 | 122 | 116 | 238 | |||||||||||||||||||||||||||||||||
415046 | 415046 | GA | school | 1300001 | 741 | Troup County | 130000100593 | 191 | Gardner-Newman Middle School | Regular School | No | Middle | 06 | 08 | 2021 | fall | grade_8 | 138 | 142 | 43 | 1 | 11 | 1 | 15 | 176 | 175 | 351 | 138 | 142 | 43 | 1 | 11 | 1 | 15 | 176 | 175 | 351 | |||||||||||||||||||||||||||||||||
415047 | 415047 | GA | school | 1300001 | 741 | Troup County | 130000101852 | 297 | Long Cane Middle School | Regular School | No | Middle | 06 | 08 | 2021 | fall | grade_8 | 174 | 141 | 17 | 2 | 6 | 0 | 17 | 185 | 172 | 357 | 174 | 141 | 17 | 2 | 6 | 0 | 17 | 185 | 172 | 357 | |||||||||||||||||||||||||||||||||
415048 | 415048 | GA | school | 1300001 | 741 | Troup County | 130000104369 | 699 | The Hope Academy School | Regular School | No | High | 07 | 12 | 2021 | fall | grade_8 | 0 | 5 | 0 | 0 | 0 | 0 | 0 | 3 | 2 | 5 | 0 | 5 | 0 | 0 | 0 | 0 | 0 | 3 | 2 | 5 | |||||||||||||||||||||||||||||||||
429768 | 429768 | GA | school | 1300001 | 741 | Troup County | 130000103620 | 207 | Ault Academy | Regular School | No | Secondary | 06 | 11 | 2020 | fall | grade_8 | 2 | 6 | 0 | 0 | 0 | 0 | 0 | 8 | 0 | 8 | 2 | 6 | 0 | 0 | 0 | 0 | 0 | 8 | 0 | 8 | |||||||||||||||||||||||||||||||||
429769 | 429769 | GA | school | 1300001 | 741 | Troup County | 130000102443 | 204 | Callaway Middle School | Regular School | No | Middle | 06 | 08 | 2020 | fall | grade_8 | 91 | 133 | 17 | 1 | 3 | 0 | 9 | 126 | 128 | 254 | 91 | 133 | 17 | 1 | 3 | 0 | 9 | 126 | 128 | 254 | |||||||||||||||||||||||||||||||||
429770 | 429770 | GA | school | 1300001 | 741 | Troup County | 130000100593 | 191 | Gardner-Newman Middle School | Regular School | No | Middle | 06 | 08 | 2020 | fall | grade_8 | 97 | 169 | 18 | 1 | 5 | 0 | 14 | 157 | 147 | 304 | 97 | 169 | 18 | 1 | 5 | 0 | 14 | 157 | 147 | 304 | |||||||||||||||||||||||||||||||||
429771 | 429771 | GA | school | 1300001 | 741 | Troup County | 130000101852 | 297 | Long Cane Middle School | Regular School | No | Middle | 06 | 08 | 2020 | fall | grade_8 | 171 | 130 | 15 | 0 | 3 | 1 | 13 | 174 | 159 | 333 | 171 | 130 | 15 | 0 | 3 | 1 | 13 | 174 | 159 | 333 | |||||||||||||||||||||||||||||||||
429772 | 429772 | GA | school | 1300001 | 741 | Troup County | 130000104369 | 699 | The Hope Academy School | Regular School | No | High | 06 | 12 | 2020 | fall | grade_8 | 0 | 5 | 0 | 0 | 0 | 0 | 0 | 4 | 1 | 5 | 0 | 5 | 0 | 0 | 0 | 0 | 0 | 4 | 1 | 5 | |||||||||||||||||||||||||||||||||
733275 | 733275 | GA | school | 1300001 | 741 | Troup County | 130000103620 | 207 | Ault Academy | Special Education School | No | Secondary | 06 | 11 | 2018 | spring | grade_8 | 4 | 4 | 0 | 0 | 0 | 0 | 0 | 8 | 0 | 8 | 4 | 4 | 0 | 0 | 0 | 0 | 0 | 8 | 0 | 8 | |||||||||||||||||||||||||||||||||
733276 | 733276 | GA | school | 1300001 | 741 | Troup County | 130000102443 | 204 | Callaway Middle School | Regular School | No | Middle | 06 | 08 | 2018 | spring | grade_8 | 82 | 99 | 9 | 0 | 5 | 0 | 7 | 118 | 84 | 202 | 82 | 99 | 9 | 0 | 5 | 0 | 7 | 118 | 84 | 202 | |||||||||||||||||||||||||||||||||
733277 | 733277 | GA | school | 1300001 | 741 | Troup County | 130000100593 | 191 | Gardner-Newman Middle School | Regular School | No | Middle | 06 | 08 | 2018 | spring | grade_8 | 120 | 127 | 18 | 1 | 8 | 2 | 11 | 145 | 142 | 287 | 120 | 127 | 18 | 1 | 8 | 2 | 11 | 145 | 142 | 287 | |||||||||||||||||||||||||||||||||
733278 | 733278 | GA | school | 1300001 | 741 | Troup County | 130000101852 | 297 | Long Cane Middle School | Regular School | No | Middle | 06 | 08 | 2018 | spring | grade_8 | 195 | 123 | 16 | 0 | 3 | 0 | 11 | 176 | 172 | 348 | 195 | 123 | 16 | 0 | 3 | 0 | 11 | 176 | 172 | 348 | |||||||||||||||||||||||||||||||||
930335 | 930335 | GA | school | 1300001 | 741 | Troup County | 130000103620 | 207 | Ault Academy | Special Education School | No | 4 | 06 | 11 | 2015 | spring | grade_8 | 4 | 6 | 1 | 0 | 0 | 0 | 0 | 11 | 0 | 11 | 4 | 6 | 1 | 0 | 0 | 0 | 0 | 11 | 0 | 11 | |||||||||||||||||||||||||||||||||
930336 | 930336 | GA | school | 1300001 | 741 | Troup County | 130000102443 | 204 | Callaway Middle School | Regular School | No | 2 | 06 | 08 | 2015 | spring | grade_8 | 85 | 127 | 9 | 0 | 6 | 0 | 7 | 121 | 113 | 234 | 85 | 127 | 9 | 0 | 6 | 0 | 7 | 121 | 113 | 234 | |||||||||||||||||||||||||||||||||
930337 | 930337 | GA | school | 1300001 | 741 | Troup County | 130000100593 | 191 | Gardner-Newman Middle School | Regular School | No | 2 | 06 | 08 | 2015 | spring | grade_8 | 148 | 156 | 23 | 1 | 7 | 0 | 14 | 175 | 174 | 349 | 148 | 156 | 23 | 1 | 7 | 0 | 14 | 175 | 174 | 349 | |||||||||||||||||||||||||||||||||
930338 | 930338 | GA | school | 1300001 | 741 | Troup County | 130000101852 | 297 | Long Cane Middle School | Regular School | No | 2 | 06 | 08 | 2015 | spring | grade_8 | 199 | 113 | 20 | 0 | 3 | 0 | 17 | 184 | 168 | 352 | 199 | 113 | 20 | 0 | 3 | 0 | 17 | 184 | 168 | 352 | |||||||||||||||||||||||||||||||||
1259048 | 1259048 | GA | school | 1300001 | 741 | Troup County | 130000103620 | 207 | Ault Academy | Special Education School | No | Secondary | 06 | 11 | 2018 | fall | grade_8 | 1 | 3 | 0 | 0 | 0 | 0 | 0 | 4 | 0 | 4 | 1 | 3 | 0 | 0 | 0 | 0 | 0 | 4 | 0 | 4 | |||||||||||||||||||||||||||||||||
1259049 | 1259049 | GA | school | 1300001 | 741 | Troup County | 130000102443 | 204 | Callaway Middle School | Regular School | No | Middle | 06 | 08 | 2018 | fall | grade_8 | 81 | 103 | 9 | 0 | 5 | 0 | 8 | 120 | 86 | 206 | 81 | 103 | 9 | 0 | 5 | 0 | 8 | 120 | 86 | 206 | |||||||||||||||||||||||||||||||||
1259050 | 1259050 | GA | school | 1300001 | 741 | Troup County | 130000100593 | 191 | Gardner-Newman Middle School | Regular School | No | Middle | 06 | 08 | 2018 | fall | grade_8 | 120 | 129 | 18 | 1 | 8 | 1 | 12 | 147 | 142 | 289 | 120 | 129 | 18 | 1 | 8 | 1 | 12 | 147 | 142 | 289 | |||||||||||||||||||||||||||||||||
1259051 | 1259051 | GA | school | 1300001 | 741 | Troup County | 130000101852 | 297 | Long Cane Middle School | Regular School | No | Middle | 06 | 08 | 2018 | fall | grade_8 | 196 | 127 | 17 | 0 | 3 | 0 | 12 | 184 | 171 | 355 | 196 | 127 | 17 | 0 | 3 | 0 | 12 | 184 | 171 | 355 | |||||||||||||||||||||||||||||||||
1273719 | 1273719 | GA | school | 1300001 | 741 | Troup County | 130000103620 | 207 | Ault Academy | Regular School | No | Secondary | 05 | 11 | 2019 | fall | grade_8 | 0 | 6 | 1 | 0 | 0 | 0 | 0 | 7 | 0 | 7 | 0 | 6 | 1 | 0 | 0 | 0 | 0 | 7 | 0 | 7 | |||||||||||||||||||||||||||||||||
1273720 | 1273720 | GA | school | 1300001 | 741 | Troup County | 130000102443 | 204 | Callaway Middle School | Regular School | No | Middle | 06 | 08 | 2019 | fall | grade_8 | 94 | 104 | 7 | 2 | 5 | 0 | 13 | 121 | 104 | 225 | 94 | 104 | 7 | 2 | 5 | 0 | 13 | 121 | 104 | 225 | |||||||||||||||||||||||||||||||||
1273721 | 1273721 | GA | school | 1300001 | 741 | Troup County | 130000100593 | 191 | Gardner-Newman Middle School | Regular School | No | Middle | 06 | 08 | 2019 | fall | grade_8 | 110 | 158 | 38 | 1 | 5 | 1 | 13 | 165 | 161 | 326 | 110 | 158 | 38 | 1 | 5 | 1 | 13 | 165 | 161 | 326 | |||||||||||||||||||||||||||||||||
1273722 | 1273722 | GA | school | 1300001 | 741 | Troup County | 130000101852 | 297 | Long Cane Middle School | Regular School | No | Middle | 06 | 08 | 2019 | fall | grade_8 | 195 | 120 | 11 | 0 | 7 | 0 | 14 | 171 | 176 | 347 | 195 | 120 | 11 | 0 | 7 | 0 | 14 | 171 | 176 | 347 | |||||||||||||||||||||||||||||||||
1970488 | 1970488 | GA | school | 1300001 | 741 | Troup County | 130000103620 | 207 | Ault Academy | Special Education School | No | 3 | 07 | 12 | 2016 | fall | grade_8 | 4 | 4 | 1 | 0 | 0 | 0 | 0 | 9 | 0 | 9 | 4 | 4 | 1 | 0 | 0 | 0 | 0 | 9 | 0 | 9 | |||||||||||||||||||||||||||||||||
1970489 | 1970489 | GA | school | 1300001 | 741 | Troup County | 130000102443 | 204 | Callaway Middle School | Regular School | No | 2 | 06 | 08 | 2016 | fall | grade_8 | 104 | 102 | 3 | 1 | 3 | 0 | 7 | 107 | 113 | 220 | 104 | 102 | 3 | 1 | 3 | 0 | 7 | 107 | 113 | 220 | |||||||||||||||||||||||||||||||||
1970490 | 1970490 | GA | school | 1300001 | 741 | Troup County | 130000100593 | 191 | Gardner-Newman Middle School | Regular School | No | 2 | 06 | 08 | 2016 | fall | grade_8 | 134 | 136 | 22 | 0 | 13 | 0 | 13 | 169 | 149 | 318 | 134 | 136 | 22 | 0 | 13 | 0 | 13 | 169 | 149 | 318 | |||||||||||||||||||||||||||||||||
1970491 | 1970491 | GA | school | 1300001 | 741 | Troup County | 130000101852 | 297 | Long Cane Middle School | Regular School | No | 2 | 06 | 08 | 2016 | fall | grade_8 | 207 | 122 | 5 | 0 | 4 | 0 | 13 | 186 | 165 | 351 | 207 | 122 | 5 | 0 | 4 | 0 | 13 | 186 | 165 | 351 | |||||||||||||||||||||||||||||||||
1984950 | 1984950 | GA | school | 1300001 | 741 | Troup County | 130000103620 | 207 | Ault Academy | Special Education School | No | Other | 06 | 12 | 2017 | fall | grade_8 | 6 | 5 | 2 | 0 | 0 | 0 | 1 | 14 | 0 | 14 | 6 | 5 | 2 | 0 | 0 | 0 | 1 | 14 | 0 | 14 | |||||||||||||||||||||||||||||||||
1984951 | 1984951 | GA | school | 1300001 | 741 | Troup County | 130000102443 | 204 | Callaway Middle School | Regular School | No | Middle | 06 | 08 | 2017 | fall | grade_8 | 91 | 106 | 8 | 0 | 2 | 0 | 16 | 119 | 104 | 223 | 91 | 106 | 8 | 0 | 2 | 0 | 16 | 119 | 104 | 223 | |||||||||||||||||||||||||||||||||
1984952 | 1984952 | GA | school | 1300001 | 741 | Troup County | 130000100593 | 191 | Gardner-Newman Middle School | Regular School | No | Middle | 06 | 08 | 2017 | fall | grade_8 | 122 | 141 | 20 | 1 | 10 | 0 | 13 | 152 | 155 | 307 | 122 | 141 | 20 | 1 | 10 | 0 | 13 | 152 | 155 | 307 | |||||||||||||||||||||||||||||||||
1984953 | 1984953 | GA | school | 1300001 | 741 | Troup County | 130000101852 | 297 | Long Cane Middle School | Regular School | No | Middle | 06 | 08 | 2017 | fall | grade_8 | 177 | 115 | 12 | 0 | 1 | 0 | 18 | 162 | 161 | 323 | 177 | 115 | 12 | 0 | 1 | 0 | 18 | 162 | 161 | 323 | |||||||||||||||||||||||||||||||||
2258512 | 2258512 | GA | school | 1300001 | 741 | Troup County | 130000103620 | 207 | Ault Academy | Special Education School | No | 3 | 07 | 12 | 2016 | spring | grade_8 | 5 | 4 | 1 | 0 | 0 | 0 | 0 | 10 | 0 | 10 | 5 | 4 | 1 | 0 | 0 | 0 | 0 | 10 | 0 | 10 | |||||||||||||||||||||||||||||||||
2258513 | 2258513 | GA | school | 1300001 | 741 | Troup County | 130000102443 | 204 | Callaway Middle School | Regular School | No | 2 | 06 | 08 | 2016 | spring | grade_8 | 105 | 101 | 3 | 1 | 3 | 0 | 7 | 112 | 108 | 220 | 105 | 101 | 3 | 1 | 3 | 0 | 7 | 112 | 108 | 220 | |||||||||||||||||||||||||||||||||
2258514 | 2258514 | GA | school | 1300001 | 741 | Troup County | 130000100593 | 191 | Gardner-Newman Middle School | Regular School | No | 2 | 06 | 08 | 2016 | spring | grade_8 | 131 | 135 | 21 | 0 | 12 | 0 | 13 | 167 | 145 | 312 | 131 | 135 | 21 | 0 | 12 | 0 | 13 | 167 | 145 | 312 | |||||||||||||||||||||||||||||||||
2258515 | 2258515 | GA | school | 1300001 | 741 | Troup County | 130000101852 | 297 | Long Cane Middle School | Regular School | No | 2 | 06 | 08 | 2016 | spring | grade_8 | 211 | 119 | 7 | 0 | 5 | 0 | 11 | 184 | 169 | 353 | 211 | 119 | 7 | 0 | 5 | 0 | 11 | 184 | 169 | 353 | |||||||||||||||||||||||||||||||||
2272965 | 2272965 | GA | school | 1300001 | 741 | Troup County | 130000103620 | 207 | Ault Academy | Regular School | No | High | 07 | 12 | 2021 | spring | grade_8 | 2 | 3 | 1 | 0 | 0 | 0 | 0 | 6 | 0 | 6 | 2 | 3 | 1 | 0 | 0 | 0 | 0 | 6 | 0 | 6 | |||||||||||||||||||||||||||||||||
2272966 | 2272966 | GA | school | 1300001 | 741 | Troup County | 130000102443 | 204 | Callaway Middle School | Regular School | No | Middle | 06 | 08 | 2021 | spring | grade_8 | 74 | 131 | 25 | 1 | 3 | 0 | 13 | 125 | 122 | 247 | 74 | 131 | 25 | 1 | 3 | 0 | 13 | 125 | 122 | 247 | |||||||||||||||||||||||||||||||||
2272967 | 2272967 | GA | school | 1300001 | 741 | Troup County | 130000100593 | 191 | Gardner-Newman Middle School | Regular School | No | Middle | 06 | 08 | 2021 | spring | grade_8 | 135 | 139 | 44 | 2 | 11 | 1 | 17 | 172 | 177 | 349 | 135 | 139 | 44 | 2 | 11 | 1 | 17 | 172 | 177 | 349 | |||||||||||||||||||||||||||||||||
2272968 | 2272968 | GA | school | 1300001 | 741 | Troup County | 130000101852 | 297 | Long Cane Middle School | Regular School | No | Middle | 06 | 08 | 2021 | spring | grade_8 | 174 | 136 | 17 | 1 | 4 | 0 | 15 | 178 | 169 | 347 | 174 | 136 | 17 | 1 | 4 | 0 | 15 | 178 | 169 | 347 | |||||||||||||||||||||||||||||||||
2272969 | 2272969 | GA | school | 1300001 | 741 | Troup County | 130000104369 | 699 | The Hope Academy School | Regular School | No | High | 07 | 12 | 2021 | spring | grade_8 | 3 | 14 | 0 | 0 | 0 | 0 | 0 | 10 | 7 | 17 | 3 | 14 | 0 | 0 | 0 | 0 | 0 | 10 | 7 | 17 | |||||||||||||||||||||||||||||||||
2567910 | 2567910 | GA | school | 1300001 | 741 | Troup County | 130000103620 | 207 | Ault Academy | Regular School | No | Secondary | 05 | 11 | 2019 | spring | grade_8 | 4 | 4 | 1 | 0 | 0 | 0 | 0 | 9 | 0 | 9 | 4 | 4 | 1 | 0 | 0 | 0 | 0 | 9 | 0 | 9 | |||||||||||||||||||||||||||||||||
2567911 | 2567911 | GA | school | 1300001 | 741 | Troup County | 130000102443 | 204 | Callaway Middle School | Regular School | No | Middle | 06 | 08 | 2019 | spring | grade_8 | 91 | 108 | 8 | 2 | 5 | 0 | 14 | 127 | 101 | 228 | 91 | 108 | 8 | 2 | 5 | 0 | 14 | 127 | 101 | 228 | |||||||||||||||||||||||||||||||||
2567912 | 2567912 | GA | school | 1300001 | 741 | Troup County | 130000100593 | 191 | Gardner-Newman Middle School | Regular School | No | Middle | 06 | 08 | 2019 | spring | grade_8 | 112 | 157 | 37 | 1 | 5 | 1 | 16 | 162 | 167 | 329 | 112 | 157 | 37 | 1 | 5 | 1 | 16 | 162 | 167 | 329 | |||||||||||||||||||||||||||||||||
2567913 | 2567913 | GA | school | 1300001 | 741 | Troup County | 130000101852 | 297 | Long Cane Middle School | Regular School | No | Middle | 06 | 08 | 2019 | spring | grade_8 | 190 | 119 | 12 | 0 | 7 | 0 | 15 | 166 | 177 | 343 | 190 | 119 | 12 | 0 | 7 | 0 | 15 | 166 | 177 | 343 | |||||||||||||||||||||||||||||||||
14161 | 14161 | GA | school | 1300005 | 7830103 | State Charter Schools II- Statesboro STEAM Academy | 130000502626 | 103 | Statesboro STEAM Academy | Regular School | Yes | 4 | 06 | 12 | 2015 | fall | grade_8 | 13 | 5 | 0 | 0 | 0 | 0 | 0 | 8 | 10 | 18 | 13 | 5 | 0 | 0 | 0 | 0 | 0 | 8 | 10 | 18 | |||||||||||||||||||||||||||||||||
310452 | 310452 | GA | school | 1300005 | 7830103 | State Charter Schools II- Statesboro STEAM Academy | 130000502626 | 103 | Statesboro STEAM Academy | Regular School | Yes | Other | 06 | 12 | 2017 | spring | grade_8 | 17 | 8 | 0 | 0 | 0 | 0 | 0 | 9 | 16 | 25 | 17 | 8 | 0 | 0 | 0 | 0 | 0 | 9 | 16 | 25 | |||||||||||||||||||||||||||||||||
325019 | 325019 | GA | school | 1300005 | 7830103 | State Charter Schools II- Statesboro STEAM Academy | 130000502626 | 103 | Statesboro STEAM Academy | Regular School | Yes | High | 06 | 12 | 2020 | spring | grade_8 | 14 | 7 | 2 | 0 | 0 | 0 | 0 | 15 | 8 | 23 | 14 | 7 | 2 | 0 | 0 | 0 | 0 | 15 | 8 | 23 | |||||||||||||||||||||||||||||||||
416945 | 416945 | GA | school | 1300005 | 7830103 | State Charter Schools II- Statesboro STEAM Academy | 130000502626 | 103 | Statesboro STEAM Academy | Regular School | No | High | 06 | 12 | 2021 | fall | grade_8 | 16 | 7 | 1 | 0 | 0 | 1 | 1 | 18 | 8 | 26 | 16 | 7 | 1 | 0 | 0 | 1 | 1 | 18 | 8 | 26 | |||||||||||||||||||||||||||||||||
431673 | 431673 | GA | school | 1300005 | 7830103 | State Charter Schools II- Statesboro STEAM Academy | 130000502626 | 103 | Statesboro STEAM Academy | Regular School | Yes | High | 06 | 12 | 2020 | fall | grade_8 | 13 | 6 | 2 | 0 | 0 | 0 | 0 | 14 | 7 | 21 | 13 | 6 | 2 | 0 | 0 | 0 | 0 | 14 | 7 | 21 | |||||||||||||||||||||||||||||||||
735193 | 735193 | GA | school | 1300005 | 7830103 | State Charter Schools II- Statesboro STEAM Academy | 130000502626 | 103 | Statesboro STEAM Academy | Regular School | Yes | High | 06 | 12 | 2018 | spring | grade_8 | 16 | 9 | 1 | 0 | 0 | 0 | 0 | 17 | 9 | 26 | 16 | 9 | 1 | 0 | 0 | 0 | 0 | 17 | 9 | 26 | |||||||||||||||||||||||||||||||||
932262 | 932262 | GA | school | 1300005 | 7830103 | State Charter Schools II- Statesboro STEAM Academy | 130000502626 | 103 | Statesboro STEAM Academy | Regular School | Yes | 4 | 06 | 12 | 2015 | spring | grade_8 | 13 | 5 | 0 | 0 | 0 | 0 | 0 | 9 | 9 | 18 | 13 | 5 | 0 | 0 | 0 | 0 | 0 | 9 | 9 | 18 | |||||||||||||||||||||||||||||||||
1260961 | 1260961 | GA | school | 1300005 | 7830103 | State Charter Schools II- Statesboro STEAM Academy | 130000502626 | 103 | Statesboro STEAM Academy | Regular School | Yes | High | 06 | 12 | 2018 | fall | grade_8 | 13 | 9 | 1 | 0 | 0 | 0 | 0 | 16 | 7 | 23 | 13 | 9 | 1 | 0 | 0 | 0 | 0 | 16 | 7 | 23 | |||||||||||||||||||||||||||||||||
1275629 | 1275629 | GA | school | 1300005 | 7830103 | State Charter Schools II- Statesboro STEAM Academy | 130000502626 | 103 | Statesboro STEAM Academy | Regular School | Yes | High | 06 | 12 | 2019 | fall | grade_8 | 21 | 5 | 1 | 0 | 1 | 0 | 1 | 13 | 16 | 29 | 21 | 5 | 1 | 0 | 1 | 0 | 1 | 13 | 16 | 29 | |||||||||||||||||||||||||||||||||
1972421 | 1972421 | GA | school | 1300005 | 7830103 | State Charter Schools II- Statesboro STEAM Academy | 130000502626 | 103 | Statesboro STEAM Academy | Regular School | Yes | 4 | 06 | 12 | 2016 | fall | grade_8 | 22 | 6 | 1 | 0 | 1 | 0 | 1 | 24 | 7 | 31 | 22 | 6 | 1 | 0 | 1 | 0 | 1 | 24 | 7 | 31 | |||||||||||||||||||||||||||||||||
1986846 | 1986846 | GA | school | 1300005 | 7830103 | State Charter Schools II- Statesboro STEAM Academy | 130000502626 | 103 | Statesboro STEAM Academy | Regular School | Yes | Other | 06 | 12 | 2017 | fall | grade_8 | 17 | 8 | 0 | 0 | 0 | 0 | 0 | 9 | 16 | 25 | 17 | 8 | 0 | 0 | 0 | 0 | 0 | 9 | 16 | 25 | |||||||||||||||||||||||||||||||||
2260437 | 2260437 | GA | school | 1300005 | 7830103 | State Charter Schools II- Statesboro STEAM Academy | 130000502626 | 103 | Statesboro STEAM Academy | Regular School | Yes | 4 | 06 | 12 | 2016 | spring | grade_8 | 22 | 5 | 1 | 0 | 0 | 0 | 1 | 24 | 5 | 29 | 22 | 5 | 1 | 0 | 0 | 0 | 1 | 24 | 5 | 29 | |||||||||||||||||||||||||||||||||
2274865 | 2274865 | GA | school | 1300005 | 7830103 | State Charter Schools II- Statesboro STEAM Academy | 130000502626 | 103 | Statesboro STEAM Academy | Regular School | No | High | 06 | 12 | 2021 | spring | grade_8 | 16 | 7 | 1 | 0 | 0 | 1 | 1 | 18 | 8 | 26 | 16 | 7 | 1 | 0 | 0 | 1 | 1 | 18 | 8 | 26 | |||||||||||||||||||||||||||||||||
2569812 | 2569812 | GA | school | 1300005 | 7830103 | State Charter Schools II- Statesboro STEAM Academy | 130000502626 | 103 | Statesboro STEAM Academy | Regular School | Yes | High | 06 | 12 | 2019 | spring | grade_8 | 23 | 5 | 1 | 0 | 1 | 0 | 1 | 14 | 17 | 31 | 23 | 5 | 1 | 0 | 1 | 0 | 1 | 14 | 17 | 31 | |||||||||||||||||||||||||||||||||
14085 | 14085 | GA | school | 1300023 | 7820110 | State Charter Schools- Odyssey Charter School | 130002303482 | 110 | Odyssey Charter School | Regular School | Yes | 1 | KG | 08 | 2015 | fall | grade_8 | 26 | 8 | 2 | 0 | 1 | 0 | 3 | 21 | 19 | 40 | 26 | 8 | 2 | 0 | 1 | 0 | 3 | 21 | 19 | 40 | |||||||||||||||||||||||||||||||||
310352 | 310352 | GA | school | 1300023 | 7820110 | State Charter Schools- Odyssey Charter School | 130002303482 | 110 | Odyssey Charter School | Regular School | Yes | Elementary | KG | 08 | 2017 | spring | grade_8 | 23 | 7 | 5 | 0 | 1 | 0 | 1 | 23 | 14 | 37 | 23 | 7 | 5 | 0 | 1 | 0 | 1 | 23 | 14 | 37 | |||||||||||||||||||||||||||||||||
324917 | 324917 | GA | school | 1300023 | 7820110 | State Charter Schools- Odyssey Charter School | 130002303482 | 110 | Odyssey Charter School | Regular School | Yes | Elementary | KG | 08 | 2020 | spring | grade_8 | 15 | 11 | 2 | 0 | 0 | 0 | 2 | 18 | 12 | 30 | 15 | 11 | 2 | 0 | 0 | 0 | 2 | 18 | 12 | 30 | |||||||||||||||||||||||||||||||||
416842 | 416842 | GA | school | 1300023 | 7820110 | State Charter Schools- Odyssey Charter School | 130002303482 | 110 | Odyssey Charter School | Regular School | No | Elementary | KG | 08 | 2021 | fall | grade_8 | 10 | 9 | 0 | 0 | 0 | 0 | 1 | 14 | 6 | 20 | 10 | 9 | 0 | 0 | 0 | 0 | 1 | 14 | 6 | 20 | |||||||||||||||||||||||||||||||||
431571 | 431571 | GA | school | 1300023 | 7820110 | State Charter Schools- Odyssey Charter School | 130002303482 | 110 | Odyssey Charter School | Regular School | Yes | Elementary | KG | 08 | 2020 | fall | grade_8 | 17 | 12 | 2 | 0 | 0 | 0 | 2 | 21 | 12 | 33 | 17 | 12 | 2 | 0 | 0 | 0 | 2 | 21 | 12 | 33 | |||||||||||||||||||||||||||||||||
735086 | 735086 | GA | school | 1300023 | 7820110 | State Charter Schools- Odyssey Charter School | 130002303482 | 110 | Odyssey Charter School | Regular School | Yes | Elementary | KG | 08 | 2018 | spring | grade_8 | 12 | 12 | 5 | 0 | 0 | 0 | 4 | 17 | 16 | 33 | 12 | 12 | 5 | 0 | 0 | 0 | 4 | 17 | 16 | 33 | |||||||||||||||||||||||||||||||||
932186 | 932186 | GA | school | 1300023 | 7820110 | State Charter Schools- Odyssey Charter School | 130002303482 | 110 | Odyssey Charter School | Regular School | Yes | 1 | KG | 08 | 2015 | spring | grade_8 | 28 | 7 | 2 | 0 | 1 | 1 | 2 | 22 | 19 | 41 | 28 | 7 | 2 | 0 | 1 | 1 | 2 | 22 | 19 | 41 | |||||||||||||||||||||||||||||||||
1260854 | 1260854 | GA | school | 1300023 | 7820110 | State Charter Schools- Odyssey Charter School | 130002303482 | 110 | Odyssey Charter School | Regular School | Yes | Elementary | KG | 08 | 2018 | fall | grade_8 | 12 | 12 | 4 | 0 | 0 | 0 | 4 | 17 | 15 | 32 | 12 | 12 | 4 | 0 | 0 | 0 | 4 | 17 | 15 | 32 | |||||||||||||||||||||||||||||||||
1275531 | 1275531 | GA | school | 1300023 | 7820110 | State Charter Schools- Odyssey Charter School | 130002303482 | 110 | Odyssey Charter School | Regular School | Yes | Elementary | KG | 08 | 2019 | fall | grade_8 | 15 | 12 | 2 | 0 | 0 | 0 | 3 | 11 | 21 | 32 | 15 | 12 | 2 | 0 | 0 | 0 | 3 | 11 | 21 | 32 | |||||||||||||||||||||||||||||||||
1972311 | 1972311 | GA | school | 1300023 | 7820110 | State Charter Schools- Odyssey Charter School | 130002303482 | 110 | Odyssey Charter School | Regular School | Yes | 1 | KG | 08 | 2016 | fall | grade_8 | 20 | 6 | 0 | 0 | 2 | 0 | 1 | 15 | 14 | 29 | 20 | 6 | 0 | 0 | 2 | 0 | 1 | 15 | 14 | 29 | |||||||||||||||||||||||||||||||||
1986746 | 1986746 | GA | school | 1300023 | 7820110 | State Charter Schools- Odyssey Charter School | 130002303482 | 110 | Odyssey Charter School | Regular School | Yes | Elementary | KG | 08 | 2017 | fall | grade_8 | 25 | 5 | 5 | 0 | 1 | 0 | 1 | 25 | 12 | 37 | 25 | 5 | 5 | 0 | 1 | 0 | 1 | 25 | 12 | 37 | |||||||||||||||||||||||||||||||||
2260330 | 2260330 | GA | school | 1300023 | 7820110 | State Charter Schools- Odyssey Charter School | 130002303482 | 110 | Odyssey Charter School | Regular School | Yes | 1 | KG | 08 | 2016 | spring | grade_8 | 22 | 6 | 0 | 0 | 2 | 0 | 1 | 18 | 13 | 31 | 22 | 6 | 0 | 0 | 2 | 0 | 1 | 18 | 13 | 31 | |||||||||||||||||||||||||||||||||
2274762 | 2274762 | GA | school | 1300023 | 7820110 | State Charter Schools- Odyssey Charter School | 130002303482 | 110 | Odyssey Charter School | Regular School | No | Elementary | KG | 08 | 2021 | spring | grade_8 | 10 | 8 | 0 | 0 | 0 | 0 | 1 | 13 | 6 | 19 | 10 | 8 | 0 | 0 | 0 | 0 | 1 | 13 | 6 | 19 | |||||||||||||||||||||||||||||||||
2569714 | 2569714 | GA | school | 1300023 | 7820110 | State Charter Schools- Odyssey Charter School | 130002303482 | 110 | Odyssey Charter School | Regular School | Yes | Elementary | KG | 08 | 2019 | spring | grade_8 | 15 | 11 | 2 | 0 | 0 | 0 | 3 | 11 | 20 | 31 | 15 | 11 | 2 | 0 | 0 | 0 | 3 | 11 | 20 | 31 | |||||||||||||||||||||||||||||||||
310814 | 310814 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603806 | 1898 | Aaron Cohn Regional Youth Detention Center | Alternative School | No | Other | 05 | 10 | 2017 | spring | grade_8 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | |||||||||||||||||||||||||||||||||
310815 | 310815 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002604089 | 104 | Atlanta Youth Detention Center | Special Education School | No | High | 08 | 12 | 2017 | spring | grade_8 | 0 | 5 | 0 | 0 | 0 | 0 | 0 | 5 | 0 | 5 | 0 | 5 | 0 | 0 | 0 | 0 | 0 | 5 | 0 | 5 | |||||||||||||||||||||||||||||||||
310816 | 310816 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603498 | 1498 | Augusta Regional Youth Detention Center | Alternative School | No | High | 07 | 12 | 2017 | spring | grade_8 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | |||||||||||||||||||||||||||||||||
310817 | 310817 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603488 | 298 | Augusta Youth Development Campus | Alternative School | No | High | 07 | 12 | 2017 | spring | grade_8 | 2 | 4 | 0 | 0 | 0 | 0 | 0 | 6 | 0 | 6 | 2 | 4 | 0 | 0 | 0 | 0 | 0 | 6 | 0 | 6 | |||||||||||||||||||||||||||||||||
310818 | 310818 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603511 | 2798 | Bob Richards Regional Youth Detention Center | Alternative School | No | Other | 09 | 10 | 2017 | spring | grade_8 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | |||||||||||||||||||||||||||||||||
310819 | 310819 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603487 | 205 | Crisp RYDC | Alternative School | No | Other | 05 | 10 | 2017 | spring | grade_8 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | |||||||||||||||||||||||||||||||||
310820 | 310820 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603504 | 2098 | DeKalb Regional Youth Detention Center | Alternative School | No | Other | 07 | 10 | 2017 | spring | grade_8 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | |||||||||||||||||||||||||||||||||
310821 | 310821 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603505 | 2198 | Eastman Regional Youth Detention Center | Alternative School | No | Other | 07 | 10 | 2017 | spring | grade_8 | 1 | 6 | 0 | 0 | 0 | 0 | 0 | 7 | 0 | 7 | 1 | 6 | 0 | 0 | 0 | 0 | 0 | 7 | 0 | 7 | |||||||||||||||||||||||||||||||||
310822 | 310822 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603506 | 2298 | Gainesville Regional Youth Detention Center | Alternative School | No | Other | 07 | 11 | 2017 | spring | grade_8 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | |||||||||||||||||||||||||||||||||
310823 | 310823 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603509 | 2598 | Macon Regional Youth Detention Center | Alternative School | No | Other | 07 | 09 | 2017 | spring | grade_8 | 0 | 3 | 0 | 0 | 0 | 0 | 0 | 3 | 0 | 3 | 0 | 3 | 0 | 0 | 0 | 0 | 0 | 3 | 0 | 3 | |||||||||||||||||||||||||||||||||
310824 | 310824 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603490 | 598 | Macon Youth Development Campus | Alternative School | No | High | 07 | 12 | 2017 | spring | grade_8 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 2 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 2 | |||||||||||||||||||||||||||||||||
310825 | 310825 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603510 | 2698 | Marietta Regional Youth Detention Center | Alternative School | No | Other | 07 | 11 | 2017 | spring | grade_8 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 |
Advanced export
JSON shape: default, array, newline-delimited
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]);