enrollments
Data source: Big Local News · About: Big Local
8,246 rows where grade = "grade_7" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12230 | 12230 | GA | school | 1300001 | 741 | Troup County | 130000103620 | 207 | Ault Academy | Special Education School | No | 4 | 06 | 11 | 2015 | fall | grade_7 | 2 | 3 | 0 | 0 | 0 | 0 | 0 | 5 | 0 | 5 | 2 | 3 | 0 | 0 | 0 | 0 | 0 | 5 | 0 | 5 | |||||||||||||||||||||||||||||||||
12231 | 12231 | GA | school | 1300001 | 741 | Troup County | 130000102443 | 204 | Callaway Middle School | Regular School | No | 2 | 06 | 08 | 2015 | fall | grade_7 | 107 | 105 | 4 | 1 | 5 | 0 | 7 | 112 | 117 | 229 | 107 | 105 | 4 | 1 | 5 | 0 | 7 | 112 | 117 | 229 | |||||||||||||||||||||||||||||||||
12232 | 12232 | GA | school | 1300001 | 741 | Troup County | 130000100593 | 191 | Gardner-Newman Middle School | Regular School | No | 2 | 06 | 08 | 2015 | fall | grade_7 | 152 | 132 | 14 | 0 | 15 | 0 | 12 | 174 | 151 | 325 | 152 | 132 | 14 | 0 | 15 | 0 | 12 | 174 | 151 | 325 | |||||||||||||||||||||||||||||||||
12233 | 12233 | GA | school | 1300001 | 741 | Troup County | 130000101852 | 297 | Long Cane Middle School | Regular School | No | 2 | 06 | 08 | 2015 | fall | grade_7 | 202 | 118 | 4 | 0 | 5 | 1 | 11 | 184 | 157 | 341 | 202 | 118 | 4 | 0 | 5 | 1 | 11 | 184 | 157 | 341 | |||||||||||||||||||||||||||||||||
308554 | 308554 | GA | school | 1300001 | 741 | Troup County | 130000103620 | 207 | Ault Academy | Special Education School | No | Other | 06 | 12 | 2017 | spring | grade_7 | 2 | 1 | 1 | 0 | 0 | 0 | 0 | 4 | 0 | 4 | 2 | 1 | 1 | 0 | 0 | 0 | 0 | 4 | 0 | 4 | |||||||||||||||||||||||||||||||||
308555 | 308555 | GA | school | 1300001 | 741 | Troup County | 130000102443 | 204 | Callaway Middle School | Regular School | No | Middle | 06 | 08 | 2017 | spring | grade_7 | 81 | 102 | 9 | 0 | 7 | 0 | 7 | 121 | 85 | 206 | 81 | 102 | 9 | 0 | 7 | 0 | 7 | 121 | 85 | 206 | |||||||||||||||||||||||||||||||||
308556 | 308556 | GA | school | 1300001 | 741 | Troup County | 130000100593 | 191 | Gardner-Newman Middle School | Regular School | No | Middle | 06 | 08 | 2017 | spring | grade_7 | 120 | 136 | 16 | 1 | 9 | 1 | 10 | 149 | 144 | 293 | 120 | 136 | 16 | 1 | 9 | 1 | 10 | 149 | 144 | 293 | |||||||||||||||||||||||||||||||||
308557 | 308557 | GA | school | 1300001 | 741 | Troup County | 130000101852 | 297 | Long Cane Middle School | Regular School | No | Middle | 06 | 08 | 2017 | spring | grade_7 | 196 | 120 | 17 | 0 | 3 | 0 | 10 | 179 | 167 | 346 | 196 | 120 | 17 | 0 | 3 | 0 | 10 | 179 | 167 | 346 | |||||||||||||||||||||||||||||||||
323110 | 323110 | GA | school | 1300001 | 741 | Troup County | 130000103620 | 207 | Ault Academy | Regular School | No | Secondary | 06 | 11 | 2020 | spring | grade_7 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | |||||||||||||||||||||||||||||||||
323111 | 323111 | GA | school | 1300001 | 741 | Troup County | 130000102443 | 204 | Callaway Middle School | Regular School | No | Middle | 06 | 08 | 2020 | spring | grade_7 | 75 | 123 | 22 | 1 | 4 | 0 | 12 | 125 | 112 | 237 | 75 | 123 | 22 | 1 | 4 | 0 | 12 | 125 | 112 | 237 | |||||||||||||||||||||||||||||||||
323112 | 323112 | GA | school | 1300001 | 741 | Troup County | 130000100593 | 191 | Gardner-Newman Middle School | Regular School | No | Middle | 06 | 08 | 2020 | spring | grade_7 | 135 | 145 | 44 | 1 | 10 | 1 | 14 | 179 | 171 | 350 | 135 | 145 | 44 | 1 | 10 | 1 | 14 | 179 | 171 | 350 | |||||||||||||||||||||||||||||||||
323113 | 323113 | GA | school | 1300001 | 741 | Troup County | 130000101852 | 297 | Long Cane Middle School | Regular School | No | Middle | 06 | 08 | 2020 | spring | grade_7 | 161 | 140 | 17 | 2 | 7 | 0 | 17 | 179 | 165 | 344 | 161 | 140 | 17 | 2 | 7 | 0 | 17 | 179 | 165 | 344 | |||||||||||||||||||||||||||||||||
323114 | 323114 | GA | school | 1300001 | 741 | Troup County | 130000104369 | 699 | The Hope Academy School | Regular School | No | High | 06 | 12 | 2020 | spring | grade_7 | 1 | 11 | 0 | 0 | 0 | 0 | 1 | 10 | 3 | 13 | 1 | 11 | 0 | 0 | 0 | 0 | 1 | 10 | 3 | 13 | |||||||||||||||||||||||||||||||||
415039 | 415039 | GA | school | 1300001 | 741 | Troup County | 130000103620 | 207 | Ault Academy | Regular School | No | High | 07 | 12 | 2021 | fall | grade_7 | 1 | 3 | 0 | 0 | 0 | 0 | 1 | 5 | 0 | 5 | 1 | 3 | 0 | 0 | 0 | 0 | 1 | 5 | 0 | 5 | |||||||||||||||||||||||||||||||||
415040 | 415040 | GA | school | 1300001 | 741 | Troup County | 130000102443 | 204 | Callaway Middle School | Regular School | No | Middle | 06 | 08 | 2021 | fall | grade_7 | 97 | 127 | 14 | 0 | 3 | 0 | 11 | 128 | 124 | 252 | 97 | 127 | 14 | 0 | 3 | 0 | 11 | 128 | 124 | 252 | |||||||||||||||||||||||||||||||||
415041 | 415041 | GA | school | 1300001 | 741 | Troup County | 130000100593 | 191 | Gardner-Newman Middle School | Regular School | No | Middle | 06 | 08 | 2021 | fall | grade_7 | 116 | 153 | 39 | 0 | 6 | 1 | 16 | 161 | 170 | 331 | 116 | 153 | 39 | 0 | 6 | 1 | 16 | 161 | 170 | 331 | |||||||||||||||||||||||||||||||||
415042 | 415042 | GA | school | 1300001 | 741 | Troup County | 130000101852 | 297 | Long Cane Middle School | Regular School | No | Middle | 06 | 08 | 2021 | fall | grade_7 | 195 | 142 | 22 | 2 | 3 | 1 | 15 | 196 | 184 | 380 | 195 | 142 | 22 | 2 | 3 | 1 | 15 | 196 | 184 | 380 | |||||||||||||||||||||||||||||||||
415043 | 415043 | GA | school | 1300001 | 741 | Troup County | 130000104369 | 699 | The Hope Academy School | Regular School | No | High | 07 | 12 | 2021 | fall | grade_7 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 2 | 0 | 2 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 2 | 0 | 2 | |||||||||||||||||||||||||||||||||
429763 | 429763 | GA | school | 1300001 | 741 | Troup County | 130000103620 | 207 | Ault Academy | Regular School | No | Secondary | 06 | 11 | 2020 | fall | grade_7 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | |||||||||||||||||||||||||||||||||
429764 | 429764 | GA | school | 1300001 | 741 | Troup County | 130000102443 | 204 | Callaway Middle School | Regular School | No | Middle | 06 | 08 | 2020 | fall | grade_7 | 78 | 120 | 20 | 1 | 5 | 0 | 14 | 132 | 106 | 238 | 78 | 120 | 20 | 1 | 5 | 0 | 14 | 132 | 106 | 238 | |||||||||||||||||||||||||||||||||
429765 | 429765 | GA | school | 1300001 | 741 | Troup County | 130000100593 | 191 | Gardner-Newman Middle School | Regular School | No | Middle | 06 | 08 | 2020 | fall | grade_7 | 137 | 156 | 46 | 1 | 11 | 1 | 14 | 189 | 177 | 366 | 137 | 156 | 46 | 1 | 11 | 1 | 14 | 189 | 177 | 366 | |||||||||||||||||||||||||||||||||
429766 | 429766 | GA | school | 1300001 | 741 | Troup County | 130000101852 | 297 | Long Cane Middle School | Regular School | No | Middle | 06 | 08 | 2020 | fall | grade_7 | 162 | 137 | 14 | 2 | 5 | 0 | 17 | 171 | 166 | 337 | 162 | 137 | 14 | 2 | 5 | 0 | 17 | 171 | 166 | 337 | |||||||||||||||||||||||||||||||||
429767 | 429767 | GA | school | 1300001 | 741 | Troup County | 130000104369 | 699 | The Hope Academy School | Regular School | No | High | 06 | 12 | 2020 | fall | grade_7 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | |||||||||||||||||||||||||||||||||
733271 | 733271 | GA | school | 1300001 | 741 | Troup County | 130000103620 | 207 | Ault Academy | Special Education School | No | Secondary | 06 | 11 | 2018 | spring | grade_7 | 1 | 4 | 1 | 0 | 0 | 0 | 0 | 6 | 0 | 6 | 1 | 4 | 1 | 0 | 0 | 0 | 0 | 6 | 0 | 6 | |||||||||||||||||||||||||||||||||
733272 | 733272 | GA | school | 1300001 | 741 | Troup County | 130000102443 | 204 | Callaway Middle School | Regular School | No | Middle | 06 | 08 | 2018 | spring | grade_7 | 97 | 111 | 5 | 1 | 6 | 0 | 13 | 122 | 111 | 233 | 97 | 111 | 5 | 1 | 6 | 0 | 13 | 122 | 111 | 233 | |||||||||||||||||||||||||||||||||
733273 | 733273 | GA | school | 1300001 | 741 | Troup County | 130000100593 | 191 | Gardner-Newman Middle School | Regular School | No | Middle | 06 | 08 | 2018 | spring | grade_7 | 101 | 151 | 39 | 1 | 5 | 1 | 11 | 161 | 148 | 309 | 101 | 151 | 39 | 1 | 5 | 1 | 11 | 161 | 148 | 309 | |||||||||||||||||||||||||||||||||
733274 | 733274 | GA | school | 1300001 | 741 | Troup County | 130000101852 | 297 | Long Cane Middle School | Regular School | No | Middle | 06 | 08 | 2018 | spring | grade_7 | 199 | 119 | 9 | 0 | 7 | 0 | 14 | 170 | 178 | 348 | 199 | 119 | 9 | 0 | 7 | 0 | 14 | 170 | 178 | 348 | |||||||||||||||||||||||||||||||||
930331 | 930331 | GA | school | 1300001 | 741 | Troup County | 130000103620 | 207 | Ault Academy | Special Education School | No | 4 | 06 | 11 | 2015 | spring | grade_7 | 2 | 3 | 0 | 0 | 0 | 0 | 0 | 5 | 0 | 5 | 2 | 3 | 0 | 0 | 0 | 0 | 0 | 5 | 0 | 5 | |||||||||||||||||||||||||||||||||
930332 | 930332 | GA | school | 1300001 | 741 | Troup County | 130000102443 | 204 | Callaway Middle School | Regular School | No | 2 | 06 | 08 | 2015 | spring | grade_7 | 106 | 102 | 3 | 1 | 5 | 0 | 7 | 109 | 115 | 224 | 106 | 102 | 3 | 1 | 5 | 0 | 7 | 109 | 115 | 224 | |||||||||||||||||||||||||||||||||
930333 | 930333 | GA | school | 1300001 | 741 | Troup County | 130000100593 | 191 | Gardner-Newman Middle School | Regular School | No | 2 | 06 | 08 | 2015 | spring | grade_7 | 146 | 129 | 15 | 0 | 14 | 0 | 13 | 165 | 152 | 317 | 146 | 129 | 15 | 0 | 14 | 0 | 13 | 165 | 152 | 317 | |||||||||||||||||||||||||||||||||
930334 | 930334 | GA | school | 1300001 | 741 | Troup County | 130000101852 | 297 | Long Cane Middle School | Regular School | No | 2 | 06 | 08 | 2015 | spring | grade_7 | 200 | 123 | 4 | 0 | 5 | 1 | 11 | 185 | 159 | 344 | 200 | 123 | 4 | 0 | 5 | 1 | 11 | 185 | 159 | 344 | |||||||||||||||||||||||||||||||||
1259044 | 1259044 | GA | school | 1300001 | 741 | Troup County | 130000103620 | 207 | Ault Academy | Special Education School | No | Secondary | 06 | 11 | 2018 | fall | grade_7 | 0 | 5 | 0 | 0 | 0 | 0 | 0 | 5 | 0 | 5 | 0 | 5 | 0 | 0 | 0 | 0 | 0 | 5 | 0 | 5 | |||||||||||||||||||||||||||||||||
1259045 | 1259045 | GA | school | 1300001 | 741 | Troup County | 130000102443 | 204 | Callaway Middle School | Regular School | No | Middle | 06 | 08 | 2018 | fall | grade_7 | 98 | 105 | 5 | 1 | 6 | 0 | 13 | 119 | 109 | 228 | 98 | 105 | 5 | 1 | 6 | 0 | 13 | 119 | 109 | 228 | |||||||||||||||||||||||||||||||||
1259046 | 1259046 | GA | school | 1300001 | 741 | Troup County | 130000100593 | 191 | Gardner-Newman Middle School | Regular School | No | Middle | 06 | 08 | 2018 | fall | grade_7 | 102 | 150 | 37 | 1 | 7 | 1 | 13 | 165 | 146 | 311 | 102 | 150 | 37 | 1 | 7 | 1 | 13 | 165 | 146 | 311 | |||||||||||||||||||||||||||||||||
1259047 | 1259047 | GA | school | 1300001 | 741 | Troup County | 130000101852 | 297 | Long Cane Middle School | Regular School | No | Middle | 06 | 08 | 2018 | fall | grade_7 | 201 | 120 | 11 | 0 | 7 | 1 | 11 | 173 | 178 | 351 | 201 | 120 | 11 | 0 | 7 | 1 | 11 | 173 | 178 | 351 | |||||||||||||||||||||||||||||||||
1273715 | 1273715 | GA | school | 1300001 | 741 | Troup County | 130000103620 | 207 | Ault Academy | Regular School | No | Secondary | 05 | 11 | 2019 | fall | grade_7 | 2 | 1 | 1 | 0 | 0 | 0 | 0 | 4 | 0 | 4 | 2 | 1 | 1 | 0 | 0 | 0 | 0 | 4 | 0 | 4 | |||||||||||||||||||||||||||||||||
1273716 | 1273716 | GA | school | 1300001 | 741 | Troup County | 130000102443 | 204 | Callaway Middle School | Regular School | No | Middle | 06 | 08 | 2019 | fall | grade_7 | 103 | 138 | 16 | 1 | 3 | 0 | 12 | 138 | 135 | 273 | 103 | 138 | 16 | 1 | 3 | 0 | 12 | 138 | 135 | 273 | |||||||||||||||||||||||||||||||||
1273717 | 1273717 | GA | school | 1300001 | 741 | Troup County | 130000100593 | 191 | Gardner-Newman Middle School | Regular School | No | Middle | 06 | 08 | 2019 | fall | grade_7 | 101 | 164 | 22 | 0 | 7 | 0 | 14 | 153 | 155 | 308 | 101 | 164 | 22 | 0 | 7 | 0 | 14 | 153 | 155 | 308 | |||||||||||||||||||||||||||||||||
1273718 | 1273718 | GA | school | 1300001 | 741 | Troup County | 130000101852 | 297 | Long Cane Middle School | Regular School | No | Middle | 06 | 08 | 2019 | fall | grade_7 | 170 | 123 | 16 | 0 | 3 | 1 | 13 | 172 | 154 | 326 | 170 | 123 | 16 | 0 | 3 | 1 | 13 | 172 | 154 | 326 | |||||||||||||||||||||||||||||||||
1970484 | 1970484 | GA | school | 1300001 | 741 | Troup County | 130000103620 | 207 | Ault Academy | Special Education School | No | 3 | 07 | 12 | 2016 | fall | grade_7 | 1 | 1 | 1 | 0 | 0 | 0 | 1 | 4 | 0 | 4 | 1 | 1 | 1 | 0 | 0 | 0 | 1 | 4 | 0 | 4 | |||||||||||||||||||||||||||||||||
1970485 | 1970485 | GA | school | 1300001 | 741 | Troup County | 130000102443 | 204 | Callaway Middle School | Regular School | No | 2 | 06 | 08 | 2016 | fall | grade_7 | 104 | 109 | 5 | 0 | 4 | 0 | 17 | 129 | 110 | 239 | 104 | 109 | 5 | 0 | 4 | 0 | 17 | 129 | 110 | 239 | |||||||||||||||||||||||||||||||||
1970486 | 1970486 | GA | school | 1300001 | 741 | Troup County | 130000100593 | 191 | Gardner-Newman Middle School | Regular School | No | 2 | 06 | 08 | 2016 | fall | grade_7 | 127 | 140 | 18 | 1 | 10 | 0 | 13 | 152 | 157 | 309 | 127 | 140 | 18 | 1 | 10 | 0 | 13 | 152 | 157 | 309 | |||||||||||||||||||||||||||||||||
1970487 | 1970487 | GA | school | 1300001 | 741 | Troup County | 130000101852 | 297 | Long Cane Middle School | Regular School | No | 2 | 06 | 08 | 2016 | fall | grade_7 | 180 | 117 | 11 | 0 | 1 | 0 | 21 | 163 | 167 | 330 | 180 | 117 | 11 | 0 | 1 | 0 | 21 | 163 | 167 | 330 | |||||||||||||||||||||||||||||||||
1984946 | 1984946 | GA | school | 1300001 | 741 | Troup County | 130000103620 | 207 | Ault Academy | Special Education School | No | Other | 06 | 12 | 2017 | fall | grade_7 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | |||||||||||||||||||||||||||||||||
1984947 | 1984947 | GA | school | 1300001 | 741 | Troup County | 130000102443 | 204 | Callaway Middle School | Regular School | No | Middle | 06 | 08 | 2017 | fall | grade_7 | 84 | 102 | 10 | 0 | 5 | 0 | 8 | 118 | 91 | 209 | 84 | 102 | 10 | 0 | 5 | 0 | 8 | 118 | 91 | 209 | |||||||||||||||||||||||||||||||||
1984948 | 1984948 | GA | school | 1300001 | 741 | Troup County | 130000100593 | 191 | Gardner-Newman Middle School | Regular School | No | Middle | 06 | 08 | 2017 | fall | grade_7 | 115 | 135 | 14 | 1 | 9 | 1 | 9 | 144 | 140 | 284 | 115 | 135 | 14 | 1 | 9 | 1 | 9 | 144 | 140 | 284 | |||||||||||||||||||||||||||||||||
1984949 | 1984949 | GA | school | 1300001 | 741 | Troup County | 130000101852 | 297 | Long Cane Middle School | Regular School | No | Middle | 06 | 08 | 2017 | fall | grade_7 | 194 | 117 | 16 | 0 | 3 | 0 | 10 | 179 | 161 | 340 | 194 | 117 | 16 | 0 | 3 | 0 | 10 | 179 | 161 | 340 | |||||||||||||||||||||||||||||||||
2258508 | 2258508 | GA | school | 1300001 | 741 | Troup County | 130000103620 | 207 | Ault Academy | Special Education School | No | 3 | 07 | 12 | 2016 | spring | grade_7 | 1 | 2 | 1 | 0 | 0 | 0 | 1 | 5 | 0 | 5 | 1 | 2 | 1 | 0 | 0 | 0 | 1 | 5 | 0 | 5 | |||||||||||||||||||||||||||||||||
2258509 | 2258509 | GA | school | 1300001 | 741 | Troup County | 130000102443 | 204 | Callaway Middle School | Regular School | No | 2 | 06 | 08 | 2016 | spring | grade_7 | 103 | 111 | 6 | 0 | 3 | 0 | 18 | 127 | 114 | 241 | 103 | 111 | 6 | 0 | 3 | 0 | 18 | 127 | 114 | 241 | |||||||||||||||||||||||||||||||||
2258510 | 2258510 | GA | school | 1300001 | 741 | Troup County | 130000100593 | 191 | Gardner-Newman Middle School | Regular School | No | 2 | 06 | 08 | 2016 | spring | grade_7 | 127 | 140 | 20 | 1 | 10 | 0 | 12 | 155 | 155 | 310 | 127 | 140 | 20 | 1 | 10 | 0 | 12 | 155 | 155 | 310 | |||||||||||||||||||||||||||||||||
2258511 | 2258511 | GA | school | 1300001 | 741 | Troup County | 130000101852 | 297 | Long Cane Middle School | Regular School | No | 2 | 06 | 08 | 2016 | spring | grade_7 | 186 | 117 | 11 | 0 | 1 | 0 | 20 | 167 | 168 | 335 | 186 | 117 | 11 | 0 | 1 | 0 | 20 | 167 | 168 | 335 | |||||||||||||||||||||||||||||||||
2272960 | 2272960 | GA | school | 1300001 | 741 | Troup County | 130000103620 | 207 | Ault Academy | Regular School | No | High | 07 | 12 | 2021 | spring | grade_7 | 2 | 3 | 0 | 0 | 0 | 0 | 1 | 6 | 0 | 6 | 2 | 3 | 0 | 0 | 0 | 0 | 1 | 6 | 0 | 6 | |||||||||||||||||||||||||||||||||
2272961 | 2272961 | GA | school | 1300001 | 741 | Troup County | 130000102443 | 204 | Callaway Middle School | Regular School | No | Middle | 06 | 08 | 2021 | spring | grade_7 | 95 | 131 | 15 | 0 | 3 | 0 | 11 | 134 | 121 | 255 | 95 | 131 | 15 | 0 | 3 | 0 | 11 | 134 | 121 | 255 | |||||||||||||||||||||||||||||||||
2272962 | 2272962 | GA | school | 1300001 | 741 | Troup County | 130000100593 | 191 | Gardner-Newman Middle School | Regular School | No | Middle | 06 | 08 | 2021 | spring | grade_7 | 118 | 150 | 38 | 0 | 5 | 1 | 18 | 160 | 170 | 330 | 118 | 150 | 38 | 0 | 5 | 1 | 18 | 160 | 170 | 330 | |||||||||||||||||||||||||||||||||
2272963 | 2272963 | GA | school | 1300001 | 741 | Troup County | 130000101852 | 297 | Long Cane Middle School | Regular School | No | Middle | 06 | 08 | 2021 | spring | grade_7 | 189 | 148 | 20 | 2 | 3 | 1 | 14 | 193 | 184 | 377 | 189 | 148 | 20 | 2 | 3 | 1 | 14 | 193 | 184 | 377 | |||||||||||||||||||||||||||||||||
2272964 | 2272964 | GA | school | 1300001 | 741 | Troup County | 130000104369 | 699 | The Hope Academy School | Regular School | No | High | 07 | 12 | 2021 | spring | grade_7 | 2 | 3 | 0 | 1 | 0 | 0 | 0 | 3 | 3 | 6 | 2 | 3 | 0 | 1 | 0 | 0 | 0 | 3 | 3 | 6 | |||||||||||||||||||||||||||||||||
2567906 | 2567906 | GA | school | 1300001 | 741 | Troup County | 130000103620 | 207 | Ault Academy | Regular School | No | Secondary | 05 | 11 | 2019 | spring | grade_7 | 3 | 4 | 1 | 0 | 0 | 0 | 0 | 8 | 0 | 8 | 3 | 4 | 1 | 0 | 0 | 0 | 0 | 8 | 0 | 8 | |||||||||||||||||||||||||||||||||
2567907 | 2567907 | GA | school | 1300001 | 741 | Troup County | 130000102443 | 204 | Callaway Middle School | Regular School | No | Middle | 06 | 08 | 2019 | spring | grade_7 | 100 | 133 | 16 | 1 | 4 | 0 | 9 | 130 | 133 | 263 | 100 | 133 | 16 | 1 | 4 | 0 | 9 | 130 | 133 | 263 | |||||||||||||||||||||||||||||||||
2567908 | 2567908 | GA | school | 1300001 | 741 | Troup County | 130000100593 | 191 | Gardner-Newman Middle School | Regular School | No | Middle | 06 | 08 | 2019 | spring | grade_7 | 98 | 165 | 20 | 0 | 6 | 0 | 15 | 151 | 153 | 304 | 98 | 165 | 20 | 0 | 6 | 0 | 15 | 151 | 153 | 304 | |||||||||||||||||||||||||||||||||
2567909 | 2567909 | GA | school | 1300001 | 741 | Troup County | 130000101852 | 297 | Long Cane Middle School | Regular School | No | Middle | 06 | 08 | 2019 | spring | grade_7 | 170 | 122 | 13 | 0 | 3 | 1 | 12 | 165 | 156 | 321 | 170 | 122 | 13 | 0 | 3 | 1 | 12 | 165 | 156 | 321 | |||||||||||||||||||||||||||||||||
14160 | 14160 | 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_7 | 20 | 4 | 1 | 0 | 1 | 0 | 1 | 19 | 8 | 27 | 20 | 4 | 1 | 0 | 1 | 0 | 1 | 19 | 8 | 27 | |||||||||||||||||||||||||||||||||
310451 | 310451 | 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_7 | 12 | 7 | 1 | 0 | 0 | 0 | 0 | 16 | 4 | 20 | 12 | 7 | 1 | 0 | 0 | 0 | 0 | 16 | 4 | 20 | |||||||||||||||||||||||||||||||||
325018 | 325018 | 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_7 | 16 | 8 | 2 | 0 | 0 | 1 | 1 | 19 | 9 | 28 | 16 | 8 | 2 | 0 | 0 | 1 | 1 | 19 | 9 | 28 | |||||||||||||||||||||||||||||||||
416944 | 416944 | 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_7 | 14 | 13 | 0 | 0 | 0 | 0 | 1 | 15 | 13 | 28 | 14 | 13 | 0 | 0 | 0 | 0 | 1 | 15 | 13 | 28 | |||||||||||||||||||||||||||||||||
431672 | 431672 | 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_7 | 17 | 8 | 1 | 0 | 0 | 1 | 1 | 18 | 10 | 28 | 17 | 8 | 1 | 0 | 0 | 1 | 1 | 18 | 10 | 28 | |||||||||||||||||||||||||||||||||
735192 | 735192 | 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_7 | 19 | 6 | 1 | 0 | 1 | 0 | 1 | 13 | 15 | 28 | 19 | 6 | 1 | 0 | 1 | 0 | 1 | 13 | 15 | 28 | |||||||||||||||||||||||||||||||||
932261 | 932261 | 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_7 | 20 | 4 | 1 | 0 | 1 | 0 | 1 | 21 | 6 | 27 | 20 | 4 | 1 | 0 | 1 | 0 | 1 | 21 | 6 | 27 | |||||||||||||||||||||||||||||||||
1260960 | 1260960 | 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_7 | 19 | 6 | 1 | 0 | 1 | 0 | 1 | 13 | 15 | 28 | 19 | 6 | 1 | 0 | 1 | 0 | 1 | 13 | 15 | 28 | |||||||||||||||||||||||||||||||||
1275628 | 1275628 | 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_7 | 21 | 6 | 3 | 0 | 0 | 0 | 1 | 17 | 14 | 31 | 21 | 6 | 3 | 0 | 0 | 0 | 1 | 17 | 14 | 31 | |||||||||||||||||||||||||||||||||
1972420 | 1972420 | 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_7 | 22 | 11 | 0 | 0 | 0 | 0 | 0 | 13 | 20 | 33 | 22 | 11 | 0 | 0 | 0 | 0 | 0 | 13 | 20 | 33 | |||||||||||||||||||||||||||||||||
1986845 | 1986845 | 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_7 | 12 | 7 | 1 | 0 | 0 | 0 | 0 | 16 | 4 | 20 | 12 | 7 | 1 | 0 | 0 | 0 | 0 | 16 | 4 | 20 | |||||||||||||||||||||||||||||||||
2260436 | 2260436 | 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_7 | 21 | 10 | 0 | 0 | 0 | 0 | 0 | 10 | 21 | 31 | 21 | 10 | 0 | 0 | 0 | 0 | 0 | 10 | 21 | 31 | |||||||||||||||||||||||||||||||||
2274864 | 2274864 | 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_7 | 13 | 13 | 0 | 0 | 0 | 0 | 2 | 14 | 14 | 28 | 13 | 13 | 0 | 0 | 0 | 0 | 2 | 14 | 14 | 28 | |||||||||||||||||||||||||||||||||
2569811 | 2569811 | 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_7 | 19 | 6 | 3 | 0 | 0 | 0 | 1 | 17 | 12 | 29 | 19 | 6 | 3 | 0 | 0 | 0 | 1 | 17 | 12 | 29 | |||||||||||||||||||||||||||||||||
14084 | 14084 | GA | school | 1300023 | 7820110 | State Charter Schools- Odyssey Charter School | 130002303482 | 110 | Odyssey Charter School | Regular School | Yes | 1 | KG | 08 | 2015 | fall | grade_7 | 17 | 7 | 1 | 0 | 2 | 0 | 2 | 17 | 12 | 29 | 17 | 7 | 1 | 0 | 2 | 0 | 2 | 17 | 12 | 29 | |||||||||||||||||||||||||||||||||
310351 | 310351 | GA | school | 1300023 | 7820110 | State Charter Schools- Odyssey Charter School | 130002303482 | 110 | Odyssey Charter School | Regular School | Yes | Elementary | KG | 08 | 2017 | spring | grade_7 | 15 | 16 | 5 | 0 | 1 | 0 | 5 | 23 | 19 | 42 | 15 | 16 | 5 | 0 | 1 | 0 | 5 | 23 | 19 | 42 | |||||||||||||||||||||||||||||||||
324916 | 324916 | GA | school | 1300023 | 7820110 | State Charter Schools- Odyssey Charter School | 130002303482 | 110 | Odyssey Charter School | Regular School | Yes | Elementary | KG | 08 | 2020 | spring | grade_7 | 12 | 10 | 1 | 0 | 0 | 0 | 3 | 19 | 7 | 26 | 12 | 10 | 1 | 0 | 0 | 0 | 3 | 19 | 7 | 26 | |||||||||||||||||||||||||||||||||
416841 | 416841 | GA | school | 1300023 | 7820110 | State Charter Schools- Odyssey Charter School | 130002303482 | 110 | Odyssey Charter School | Regular School | No | Elementary | KG | 08 | 2021 | fall | grade_7 | 24 | 14 | 2 | 0 | 0 | 0 | 3 | 25 | 18 | 43 | 24 | 14 | 2 | 0 | 0 | 0 | 3 | 25 | 18 | 43 | |||||||||||||||||||||||||||||||||
431570 | 431570 | GA | school | 1300023 | 7820110 | State Charter Schools- Odyssey Charter School | 130002303482 | 110 | Odyssey Charter School | Regular School | Yes | Elementary | KG | 08 | 2020 | fall | grade_7 | 13 | 11 | 1 | 0 | 0 | 0 | 3 | 21 | 7 | 28 | 13 | 11 | 1 | 0 | 0 | 0 | 3 | 21 | 7 | 28 | |||||||||||||||||||||||||||||||||
735085 | 735085 | GA | school | 1300023 | 7820110 | State Charter Schools- Odyssey Charter School | 130002303482 | 110 | Odyssey Charter School | Regular School | Yes | Elementary | KG | 08 | 2018 | spring | grade_7 | 15 | 14 | 4 | 0 | 1 | 0 | 4 | 15 | 23 | 38 | 15 | 14 | 4 | 0 | 1 | 0 | 4 | 15 | 23 | 38 | |||||||||||||||||||||||||||||||||
932185 | 932185 | GA | school | 1300023 | 7820110 | State Charter Schools- Odyssey Charter School | 130002303482 | 110 | Odyssey Charter School | Regular School | Yes | 1 | KG | 08 | 2015 | spring | grade_7 | 21 | 6 | 1 | 0 | 2 | 0 | 3 | 19 | 14 | 33 | 21 | 6 | 1 | 0 | 2 | 0 | 3 | 19 | 14 | 33 | |||||||||||||||||||||||||||||||||
1260853 | 1260853 | GA | school | 1300023 | 7820110 | State Charter Schools- Odyssey Charter School | 130002303482 | 110 | Odyssey Charter School | Regular School | Yes | Elementary | KG | 08 | 2018 | fall | grade_7 | 15 | 13 | 3 | 0 | 2 | 0 | 4 | 16 | 21 | 37 | 15 | 13 | 3 | 0 | 2 | 0 | 4 | 16 | 21 | 37 | |||||||||||||||||||||||||||||||||
1275530 | 1275530 | GA | school | 1300023 | 7820110 | State Charter Schools- Odyssey Charter School | 130002303482 | 110 | Odyssey Charter School | Regular School | Yes | Elementary | KG | 08 | 2019 | fall | grade_7 | 22 | 12 | 2 | 0 | 0 | 0 | 2 | 21 | 17 | 38 | 22 | 12 | 2 | 0 | 0 | 0 | 2 | 21 | 17 | 38 | |||||||||||||||||||||||||||||||||
1972310 | 1972310 | GA | school | 1300023 | 7820110 | State Charter Schools- Odyssey Charter School | 130002303482 | 110 | Odyssey Charter School | Regular School | Yes | 1 | KG | 08 | 2016 | fall | grade_7 | 26 | 9 | 6 | 0 | 2 | 0 | 3 | 28 | 18 | 46 | 26 | 9 | 6 | 0 | 2 | 0 | 3 | 28 | 18 | 46 | |||||||||||||||||||||||||||||||||
1986745 | 1986745 | GA | school | 1300023 | 7820110 | State Charter Schools- Odyssey Charter School | 130002303482 | 110 | Odyssey Charter School | Regular School | Yes | Elementary | KG | 08 | 2017 | fall | grade_7 | 16 | 17 | 6 | 0 | 2 | 0 | 5 | 26 | 20 | 46 | 16 | 17 | 6 | 0 | 2 | 0 | 5 | 26 | 20 | 46 | |||||||||||||||||||||||||||||||||
2260329 | 2260329 | GA | school | 1300023 | 7820110 | State Charter Schools- Odyssey Charter School | 130002303482 | 110 | Odyssey Charter School | Regular School | Yes | 1 | KG | 08 | 2016 | spring | grade_7 | 27 | 9 | 6 | 0 | 2 | 0 | 2 | 30 | 16 | 46 | 27 | 9 | 6 | 0 | 2 | 0 | 2 | 30 | 16 | 46 | |||||||||||||||||||||||||||||||||
2274761 | 2274761 | GA | school | 1300023 | 7820110 | State Charter Schools- Odyssey Charter School | 130002303482 | 110 | Odyssey Charter School | Regular School | No | Elementary | KG | 08 | 2021 | spring | grade_7 | 22 | 13 | 2 | 0 | 0 | 0 | 3 | 22 | 18 | 40 | 22 | 13 | 2 | 0 | 0 | 0 | 3 | 22 | 18 | 40 | |||||||||||||||||||||||||||||||||
2569713 | 2569713 | GA | school | 1300023 | 7820110 | State Charter Schools- Odyssey Charter School | 130002303482 | 110 | Odyssey Charter School | Regular School | Yes | Elementary | KG | 08 | 2019 | spring | grade_7 | 20 | 11 | 2 | 0 | 0 | 0 | 2 | 21 | 14 | 35 | 20 | 11 | 2 | 0 | 0 | 0 | 2 | 21 | 14 | 35 | |||||||||||||||||||||||||||||||||
310799 | 310799 | 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_7 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 2 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 2 | |||||||||||||||||||||||||||||||||
310800 | 310800 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002604089 | 104 | Atlanta Youth Detention Center | Special Education School | No | High | 08 | 12 | 2017 | spring | grade_7 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | |||||||||||||||||||||||||||||||||
310801 | 310801 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603498 | 1498 | Augusta Regional Youth Detention Center | Alternative School | No | High | 07 | 12 | 2017 | spring | grade_7 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | |||||||||||||||||||||||||||||||||
310802 | 310802 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603488 | 298 | Augusta Youth Development Campus | Alternative School | No | High | 07 | 12 | 2017 | spring | grade_7 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | |||||||||||||||||||||||||||||||||
310803 | 310803 | 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_7 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | |||||||||||||||||||||||||||||||||
310804 | 310804 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603501 | 1798 | Claxton Regional Youth Detention Center | Alternative School | No | Other | 07 | 11 | 2017 | spring | grade_7 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | |||||||||||||||||||||||||||||||||
310805 | 310805 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603487 | 205 | Crisp RYDC | Alternative School | No | Other | 05 | 10 | 2017 | spring | grade_7 | 0 | 3 | 0 | 0 | 0 | 0 | 0 | 3 | 0 | 3 | 0 | 3 | 0 | 0 | 0 | 0 | 0 | 3 | 0 | 3 | |||||||||||||||||||||||||||||||||
310806 | 310806 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603504 | 2098 | DeKalb Regional Youth Detention Center | Alternative School | No | Other | 07 | 10 | 2017 | spring | grade_7 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | |||||||||||||||||||||||||||||||||
310807 | 310807 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603490 | 598 | Macon Youth Development Campus | Alternative School | No | High | 07 | 12 | 2017 | spring | grade_7 | 1 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 3 | 3 | 1 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 3 | 3 | |||||||||||||||||||||||||||||||||
310808 | 310808 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603517 | 4198 | Metro Regional Youth Detention Center | Alternative School | No | Other | 06 | 11 | 2017 | spring | grade_7 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | |||||||||||||||||||||||||||||||||
310809 | 310809 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603650 | 405 | Muscogee Youth Development Center | Alternative School | No | Other | 07 | 11 | 2017 | spring | grade_7 | 1 | 4 | 1 | 0 | 0 | 0 | 0 | 6 | 0 | 6 | 1 | 4 | 1 | 0 | 0 | 0 | 0 | 6 | 0 | 6 | |||||||||||||||||||||||||||||||||
310810 | 310810 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002604141 | 414 | Rockdale RYDC | Special Education School | No | Other | 08 | 10 | 2017 | spring | grade_7 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 |
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]);