enrollments
Data source: Big Local News · About: Big Local
1,133 rows where grade = "grade_8", state = "GA" and year = 2015 sorted by school_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
21 | 21 | GA | school | 1300060 | 601 | Appling County | 130006000009 | 195 | Appling County Middle School | Regular School | No | 2 | 06 | 08 | 2015 | fall | grade_8 | 161 | 59 | 34 | 1 | 1 | 0 | 8 | 134 | 130 | 264 | 161 | 59 | 34 | 1 | 1 | 0 | 8 | 134 | 130 | 264 | |||||||||||||||||||||||||||||||||
918117 | 918117 | GA | school | 1300060 | 601 | Appling County | 130006000009 | 195 | Appling County Middle School | Regular School | No | 2 | 06 | 08 | 2015 | spring | grade_8 | 157 | 61 | 32 | 1 | 1 | 0 | 8 | 130 | 130 | 260 | 157 | 61 | 32 | 1 | 1 | 0 | 8 | 130 | 130 | 260 | |||||||||||||||||||||||||||||||||
50 | 50 | GA | school | 1300090 | 602 | Atkinson County | 130009003996 | 111 | Atkinson County Middle School | Regular School | No | 2 | 06 | 08 | 2015 | fall | grade_8 | 59 | 19 | 45 | 0 | 0 | 0 | 1 | 63 | 61 | 124 | 59 | 19 | 45 | 0 | 0 | 0 | 1 | 63 | 61 | 124 | |||||||||||||||||||||||||||||||||
918146 | 918146 | GA | school | 1300090 | 602 | Atkinson County | 130009003996 | 111 | Atkinson County Middle School | Regular School | No | 2 | 06 | 08 | 2015 | spring | grade_8 | 58 | 18 | 45 | 0 | 0 | 0 | 1 | 60 | 62 | 122 | 58 | 18 | 45 | 0 | 0 | 0 | 1 | 60 | 62 | 122 | |||||||||||||||||||||||||||||||||
13423 | 13423 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012000017 | 173 | Long Middle School | Regular School | No | 2 | 06 | 08 | 2015 | fall | grade_8 | 1 | 198 | 10 | 0 | 0 | 0 | 1 | 110 | 100 | 210 | 1 | 198 | 10 | 0 | 0 | 0 | 1 | 110 | 100 | 210 | |||||||||||||||||||||||||||||||||
931521 | 931521 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012000017 | 173 | Long Middle School | Regular School | No | 2 | 06 | 08 | 2015 | spring | grade_8 | 0 | 192 | 11 | 0 | 0 | 0 | 1 | 100 | 104 | 204 | 0 | 192 | 11 | 0 | 0 | 0 | 1 | 100 | 104 | 204 | |||||||||||||||||||||||||||||||||
13420 | 13420 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012000025 | 373 | King Middle School | Regular School | No | 2 | 06 | 08 | 2015 | fall | grade_8 | 4 | 203 | 11 | 0 | 2 | 0 | 2 | 108 | 114 | 222 | 4 | 203 | 11 | 0 | 2 | 0 | 2 | 108 | 114 | 222 | |||||||||||||||||||||||||||||||||
931518 | 931518 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012000025 | 373 | King Middle School | Regular School | No | 2 | 06 | 08 | 2015 | spring | grade_8 | 4 | 207 | 11 | 0 | 1 | 0 | 2 | 109 | 116 | 225 | 4 | 207 | 11 | 0 | 1 | 0 | 2 | 109 | 116 | 225 | |||||||||||||||||||||||||||||||||
13414 | 13414 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012000027 | 1563 | David T Howard Middle School | Regular School | No | 2 | 06 | 08 | 2015 | fall | grade_8 | 124 | 145 | 21 | 1 | 5 | 0 | 13 | 148 | 161 | 309 | 124 | 145 | 21 | 1 | 5 | 0 | 13 | 148 | 161 | 309 | |||||||||||||||||||||||||||||||||
931512 | 931512 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012000027 | 1563 | David T Howard Middle School | Regular School | No | 2 | 06 | 08 | 2015 | spring | grade_8 | 125 | 145 | 21 | 0 | 6 | 0 | 13 | 148 | 162 | 310 | 125 | 145 | 21 | 0 | 6 | 0 | 13 | 148 | 162 | 310 | |||||||||||||||||||||||||||||||||
13427 | 13427 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012000058 | 188 | Sylvan Hills Middle School | Regular School | No | 2 | 06 | 08 | 2015 | fall | grade_8 | 1 | 179 | 2 | 1 | 0 | 0 | 1 | 89 | 95 | 184 | 1 | 179 | 2 | 1 | 0 | 0 | 1 | 89 | 95 | 184 | |||||||||||||||||||||||||||||||||
931525 | 931525 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012000058 | 188 | Sylvan Hills Middle School | Regular School | No | 2 | 06 | 08 | 2015 | spring | grade_8 | 1 | 169 | 2 | 1 | 0 | 0 | 1 | 87 | 87 | 174 | 1 | 169 | 2 | 1 | 0 | 0 | 1 | 87 | 87 | 174 | |||||||||||||||||||||||||||||||||
13425 | 13425 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012000060 | 288 | Price Middle School | Regular School | No | 2 | 06 | 08 | 2015 | fall | grade_8 | 0 | 100 | 3 | 0 | 0 | 0 | 0 | 50 | 53 | 103 | 0 | 100 | 3 | 0 | 0 | 0 | 0 | 50 | 53 | 103 | |||||||||||||||||||||||||||||||||
931523 | 931523 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012000060 | 288 | Price Middle School | Regular School | No | 2 | 06 | 08 | 2015 | spring | grade_8 | 0 | 95 | 2 | 0 | 0 | 0 | 0 | 46 | 51 | 97 | 0 | 95 | 2 | 0 | 0 | 0 | 0 | 46 | 51 | 97 | |||||||||||||||||||||||||||||||||
13426 | 13426 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012000107 | 3067 | Sutton Middle School | Regular School | No | 2 | 06 | 08 | 2015 | fall | grade_8 | 156 | 144 | 113 | 1 | 16 | 1 | 20 | 223 | 228 | 451 | 156 | 144 | 113 | 1 | 16 | 1 | 20 | 223 | 228 | 451 | |||||||||||||||||||||||||||||||||
931524 | 931524 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012000107 | 3067 | Sutton Middle School | Regular School | No | 2 | 06 | 08 | 2015 | spring | grade_8 | 157 | 140 | 117 | 1 | 15 | 1 | 21 | 226 | 226 | 452 | 157 | 140 | 117 | 1 | 15 | 1 | 21 | 226 | 226 | 452 | |||||||||||||||||||||||||||||||||
13411 | 13411 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012000150 | 180 | Bunche Middle School | Regular School | No | 2 | 06 | 08 | 2015 | fall | grade_8 | 1 | 280 | 9 | 0 | 0 | 0 | 2 | 155 | 137 | 292 | 1 | 280 | 9 | 0 | 0 | 0 | 2 | 155 | 137 | 292 | |||||||||||||||||||||||||||||||||
931509 | 931509 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012000150 | 180 | Bunche Middle School | Regular School | No | 2 | 06 | 08 | 2015 | spring | grade_8 | 2 | 276 | 7 | 0 | 0 | 0 | 1 | 152 | 134 | 286 | 2 | 276 | 7 | 0 | 0 | 0 | 1 | 152 | 134 | 286 | |||||||||||||||||||||||||||||||||
13430 | 13430 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012001866 | 282 | Young Middle School | Regular School | No | 2 | 06 | 08 | 2015 | fall | grade_8 | 0 | 345 | 8 | 0 | 0 | 0 | 1 | 170 | 184 | 354 | 0 | 345 | 8 | 0 | 0 | 0 | 1 | 170 | 184 | 354 | |||||||||||||||||||||||||||||||||
931528 | 931528 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012001866 | 282 | Young Middle School | Regular School | No | 2 | 06 | 08 | 2015 | spring | grade_8 | 1 | 335 | 8 | 0 | 0 | 0 | 1 | 165 | 180 | 345 | 1 | 335 | 8 | 0 | 0 | 0 | 1 | 165 | 180 | 345 | |||||||||||||||||||||||||||||||||
13410 | 13410 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012002344 | 100 | Brown Middle School | Regular School | No | 2 | 06 | 08 | 2015 | fall | grade_8 | 0 | 237 | 5 | 0 | 0 | 0 | 1 | 113 | 130 | 243 | 0 | 237 | 5 | 0 | 0 | 0 | 1 | 113 | 130 | 243 | |||||||||||||||||||||||||||||||||
931508 | 931508 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012002344 | 100 | Brown Middle School | Regular School | No | 2 | 06 | 08 | 2015 | spring | grade_8 | 0 | 229 | 5 | 0 | 0 | 0 | 1 | 113 | 122 | 235 | 0 | 229 | 5 | 0 | 0 | 0 | 1 | 113 | 122 | 235 | |||||||||||||||||||||||||||||||||
13408 | 13408 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012002798 | 403 | APS-Forrest Hills Academy | Alternative Education School | No | 4 | 06 | 12 | 2015 | fall | grade_8 | 0 | 50 | 1 | 0 | 0 | 0 | 0 | 31 | 20 | 51 | 0 | 50 | 1 | 0 | 0 | 0 | 0 | 31 | 20 | 51 | |||||||||||||||||||||||||||||||||
931506 | 931506 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012002798 | 403 | APS-Forrest Hills Academy | Alternative Education School | No | 4 | 06 | 12 | 2015 | spring | grade_8 | 0 | 39 | 1 | 0 | 0 | 0 | 0 | 30 | 10 | 40 | 0 | 39 | 1 | 0 | 0 | 0 | 0 | 30 | 10 | 40 | |||||||||||||||||||||||||||||||||
13415 | 13415 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012003029 | 504 | Harper-Archer Middle School | Regular School | No | 2 | 06 | 08 | 2015 | fall | grade_8 | 2 | 216 | 6 | 0 | 0 | 0 | 2 | 116 | 110 | 226 | 2 | 216 | 6 | 0 | 0 | 0 | 2 | 116 | 110 | 226 | |||||||||||||||||||||||||||||||||
931513 | 931513 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012003029 | 504 | Harper-Archer Middle School | Regular School | No | 2 | 06 | 08 | 2015 | spring | grade_8 | 1 | 230 | 6 | 0 | 0 | 0 | 2 | 123 | 116 | 239 | 1 | 230 | 6 | 0 | 0 | 0 | 2 | 123 | 116 | 239 | |||||||||||||||||||||||||||||||||
13419 | 13419 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012003031 | 605 | KIPP West Atlanta Young Scholars Academy | Regular School | Yes | 2 | 05 | 08 | 2015 | fall | grade_8 | 0 | 78 | 0 | 0 | 0 | 0 | 1 | 42 | 37 | 79 | 0 | 78 | 0 | 0 | 0 | 0 | 1 | 42 | 37 | 79 | |||||||||||||||||||||||||||||||||
931517 | 931517 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012003031 | 605 | KIPP West Atlanta Young Scholars Academy | Regular School | Yes | 2 | 05 | 08 | 2015 | spring | grade_8 | 0 | 78 | 0 | 0 | 0 | 0 | 1 | 42 | 37 | 79 | 0 | 78 | 0 | 0 | 0 | 0 | 1 | 42 | 37 | 79 | |||||||||||||||||||||||||||||||||
13424 | 13424 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012003541 | 206 | Middle | Regular School | Yes | 2 | 06 | 08 | 2015 | fall | grade_8 | 48 | 19 | 4 | 0 | 2 | 0 | 7 | 44 | 36 | 80 | 48 | 19 | 4 | 0 | 2 | 0 | 7 | 44 | 36 | 80 | |||||||||||||||||||||||||||||||||
931522 | 931522 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012003541 | 206 | Middle | Regular School | Yes | 2 | 06 | 08 | 2015 | spring | grade_8 | 45 | 18 | 4 | 0 | 2 | 0 | 7 | 42 | 34 | 76 | 45 | 18 | 4 | 0 | 2 | 0 | 7 | 42 | 34 | 76 | |||||||||||||||||||||||||||||||||
13428 | 13428 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012003558 | 1408 | The Best Academy at Benjamin S. Carson | Regular School | No | 2 | 06 | 08 | 2015 | fall | grade_8 | 0 | 105 | 1 | 0 | 0 | 0 | 1 | 107 | 0 | 107 | 0 | 105 | 1 | 0 | 0 | 0 | 1 | 107 | 0 | 107 | |||||||||||||||||||||||||||||||||
931526 | 931526 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012003558 | 1408 | The Best Academy at Benjamin S. Carson | Regular School | No | 2 | 06 | 08 | 2015 | spring | grade_8 | 0 | 94 | 1 | 0 | 0 | 0 | 1 | 96 | 0 | 96 | 0 | 94 | 1 | 0 | 0 | 0 | 1 | 96 | 0 | 96 | |||||||||||||||||||||||||||||||||
13429 | 13429 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012003589 | 1208 | Wesley International Academy Charter Facility | Regular School | Yes | 1 | KG | 08 | 2015 | fall | grade_8 | 1 | 32 | 3 | 0 | 0 | 0 | 0 | 19 | 17 | 36 | 1 | 32 | 3 | 0 | 0 | 0 | 0 | 19 | 17 | 36 | |||||||||||||||||||||||||||||||||
931527 | 931527 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012003589 | 1208 | Wesley International Academy Charter Facility | Regular School | Yes | 1 | KG | 08 | 2015 | spring | grade_8 | 1 | 32 | 3 | 0 | 0 | 0 | 0 | 19 | 17 | 36 | 1 | 32 | 3 | 0 | 0 | 0 | 0 | 19 | 17 | 36 | |||||||||||||||||||||||||||||||||
13416 | 13416 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012003660 | 207 | Hillside Conant School | Regular School | No | 4 | 01 | 12 | 2015 | fall | grade_8 | 4 | 5 | 1 | 0 | 0 | 0 | 0 | 8 | 2 | 10 | 4 | 5 | 1 | 0 | 0 | 0 | 0 | 8 | 2 | 10 | |||||||||||||||||||||||||||||||||
931514 | 931514 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012003660 | 207 | Hillside Conant School | Regular School | No | 4 | 01 | 12 | 2015 | spring | grade_8 | 7 | 6 | 0 | 0 | 0 | 0 | 0 | 7 | 6 | 13 | 7 | 6 | 0 | 0 | 0 | 0 | 0 | 7 | 6 | 13 | |||||||||||||||||||||||||||||||||
13421 | 13421 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012003823 | 115 | Kipp Strive Academy | Regular School | Yes | 2 | 05 | 08 | 2015 | fall | grade_8 | 0 | 84 | 0 | 0 | 0 | 0 | 0 | 35 | 49 | 84 | 0 | 84 | 0 | 0 | 0 | 0 | 0 | 35 | 49 | 84 | |||||||||||||||||||||||||||||||||
931519 | 931519 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012003823 | 115 | Kipp Strive Academy | Regular School | Yes | 2 | 05 | 08 | 2015 | spring | grade_8 | 0 | 83 | 0 | 0 | 0 | 0 | 0 | 35 | 48 | 83 | 0 | 83 | 0 | 0 | 0 | 0 | 0 | 35 | 48 | 83 | |||||||||||||||||||||||||||||||||
13412 | 13412 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012003971 | 120 | C | Regular School | No | 2 | 06 | 08 | 2015 | fall | grade_8 | 0 | 101 | 0 | 0 | 0 | 0 | 1 | 0 | 102 | 102 | 0 | 101 | 0 | 0 | 0 | 0 | 1 | 0 | 102 | 102 | |||||||||||||||||||||||||||||||||
931510 | 931510 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012003971 | 120 | C | Regular School | No | 2 | 06 | 08 | 2015 | spring | grade_8 | 0 | 103 | 0 | 0 | 0 | 0 | 1 | 0 | 104 | 104 | 0 | 103 | 0 | 0 | 0 | 0 | 1 | 0 | 104 | 104 | |||||||||||||||||||||||||||||||||
13417 | 13417 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012003973 | 124 | Intown Charter Academy | Regular School | Yes | 1 | KG | 08 | 2015 | fall | grade_8 | 0 | 27 | 0 | 0 | 0 | 0 | 0 | 10 | 17 | 27 | 0 | 27 | 0 | 0 | 0 | 0 | 0 | 10 | 17 | 27 | |||||||||||||||||||||||||||||||||
931515 | 931515 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012003973 | 124 | Intown Charter Academy | Regular School | Yes | 1 | KG | 08 | 2015 | spring | grade_8 | 0 | 23 | 0 | 0 | 0 | 0 | 0 | 8 | 15 | 23 | 0 | 23 | 0 | 0 | 0 | 0 | 0 | 8 | 15 | 23 | |||||||||||||||||||||||||||||||||
13418 | 13418 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012003992 | 122 | KIPP VISION | Regular School | Yes | 2 | 05 | 08 | 2015 | fall | grade_8 | 0 | 88 | 3 | 0 | 0 | 0 | 0 | 39 | 52 | 91 | 0 | 88 | 3 | 0 | 0 | 0 | 0 | 39 | 52 | 91 | |||||||||||||||||||||||||||||||||
931516 | 931516 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012003992 | 122 | KIPP VISION | Regular School | Yes | 2 | 05 | 08 | 2015 | spring | grade_8 | 0 | 82 | 3 | 0 | 0 | 0 | 0 | 35 | 50 | 85 | 0 | 82 | 3 | 0 | 0 | 0 | 0 | 35 | 50 | 85 | |||||||||||||||||||||||||||||||||
13422 | 13422 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012004083 | 313 | Latin Academy Charter School | Regular School | Yes | 2 | 06 | 08 | 2015 | fall | grade_8 | 0 | 82 | 0 | 0 | 0 | 0 | 0 | 24 | 58 | 82 | 0 | 82 | 0 | 0 | 0 | 0 | 0 | 24 | 58 | 82 | |||||||||||||||||||||||||||||||||
931520 | 931520 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012004083 | 313 | Latin Academy Charter School | Regular School | Yes | 2 | 06 | 08 | 2015 | spring | grade_8 | 0 | 82 | 0 | 0 | 0 | 0 | 0 | 24 | 58 | 82 | 0 | 82 | 0 | 0 | 0 | 0 | 0 | 24 | 58 | 82 | |||||||||||||||||||||||||||||||||
13409 | 13409 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012004145 | 415 | Atlanta Classical Academy | Regular School | Yes | 1 | KG | 08 | 2015 | fall | grade_8 | 35 | 9 | 10 | 0 | 0 | 0 | 0 | 24 | 30 | 54 | 35 | 9 | 10 | 0 | 0 | 0 | 0 | 24 | 30 | 54 | |||||||||||||||||||||||||||||||||
931507 | 931507 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012004145 | 415 | Atlanta Classical Academy | Regular School | Yes | 1 | KG | 08 | 2015 | spring | grade_8 | 35 | 9 | 10 | 0 | 0 | 0 | 0 | 24 | 30 | 54 | 35 | 9 | 10 | 0 | 0 | 0 | 0 | 24 | 30 | 54 | |||||||||||||||||||||||||||||||||
13413 | 13413 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012004161 | 515 | Charles Drew Charter School JA/SA | Regular School | No | 4 | 06 | 10 | 2015 | fall | grade_8 | 0 | 113 | 4 | 0 | 2 | 0 | 1 | 53 | 67 | 120 | 0 | 113 | 4 | 0 | 2 | 0 | 1 | 53 | 67 | 120 | |||||||||||||||||||||||||||||||||
931511 | 931511 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012004161 | 515 | Charles Drew Charter School JA/SA | Regular School | No | 4 | 06 | 10 | 2015 | spring | grade_8 | 0 | 108 | 4 | 0 | 2 | 0 | 1 | 51 | 64 | 115 | 0 | 108 | 4 | 0 | 2 | 0 | 1 | 51 | 64 | 115 | |||||||||||||||||||||||||||||||||
70 | 70 | GA | school | 1300150 | 603 | Bacon County | 130015002349 | 202 | Bacon County Middle School | Regular School | No | 2 | 06 | 08 | 2015 | fall | grade_8 | 114 | 24 | 22 | 0 | 0 | 0 | 6 | 91 | 75 | 166 | 114 | 24 | 22 | 0 | 0 | 0 | 6 | 91 | 75 | 166 | |||||||||||||||||||||||||||||||||
918166 | 918166 | GA | school | 1300150 | 603 | Bacon County | 130015002349 | 202 | Bacon County Middle School | Regular School | No | 2 | 06 | 08 | 2015 | spring | grade_8 | 113 | 24 | 22 | 0 | 0 | 0 | 7 | 90 | 76 | 166 | 113 | 24 | 22 | 0 | 0 | 0 | 7 | 90 | 76 | 166 | |||||||||||||||||||||||||||||||||
88 | 88 | GA | school | 1300180 | 604 | Baker County | 130018001867 | 105 | Baker County K12 School | Regular School | No | 4 | PK | 12 | 2015 | fall | grade_8 | 0 | 25 | 3 | 0 | 0 | 4 | 0 | 15 | 17 | 32 | 0 | 25 | 3 | 0 | 0 | 4 | 0 | 15 | 17 | 32 | |||||||||||||||||||||||||||||||||
918184 | 918184 | GA | school | 1300180 | 604 | Baker County | 130018001867 | 105 | Baker County K12 School | Regular School | No | 4 | PK | 12 | 2015 | spring | grade_8 | 1 | 27 | 3 | 1 | 0 | 3 | 0 | 17 | 18 | 35 | 1 | 27 | 3 | 1 | 0 | 3 | 0 | 17 | 18 | 35 | |||||||||||||||||||||||||||||||||
118 | 118 | GA | school | 1300210 | 605 | Baldwin County | 130021002347 | 100 | Oak Hill MS | Regular School | No | 2 | 06 | 08 | 2015 | fall | grade_8 | 99 | 282 | 6 | 0 | 4 | 0 | 12 | 199 | 204 | 403 | 99 | 282 | 6 | 0 | 4 | 0 | 12 | 199 | 204 | 403 | |||||||||||||||||||||||||||||||||
918214 | 918214 | GA | school | 1300210 | 605 | Baldwin County | 130021002347 | 100 | Oak Hill MS | Regular School | No | 2 | 06 | 08 | 2015 | spring | grade_8 | 99 | 282 | 7 | 0 | 3 | 0 | 12 | 199 | 204 | 403 | 99 | 282 | 7 | 0 | 3 | 0 | 12 | 199 | 204 | 403 | |||||||||||||||||||||||||||||||||
14169 | 14169 | GA | school | 1300215 | 7830110 | State Charter Schools II- Ivy Preparatory Academy at Gwinnett | 130021503748 | 110 | Ivy Preparatory Academy at Gwinnett | Regular School | Yes | 4 | 06 | 12 | 2015 | fall | grade_8 | 3 | 52 | 13 | 0 | 7 | 0 | 3 | 0 | 78 | 78 | 3 | 52 | 13 | 0 | 7 | 0 | 3 | 0 | 78 | 78 | |||||||||||||||||||||||||||||||||
932270 | 932270 | GA | school | 1300215 | 7830110 | State Charter Schools II- Ivy Preparatory Academy at Gwinnett | 130021503748 | 110 | Ivy Preparatory Academy at Gwinnett | Regular School | Yes | 4 | 06 | 12 | 2015 | spring | grade_8 | 2 | 52 | 13 | 0 | 6 | 0 | 3 | 0 | 76 | 76 | 2 | 52 | 13 | 0 | 6 | 0 | 3 | 0 | 76 | 76 | |||||||||||||||||||||||||||||||||
14187 | 14187 | GA | school | 1300217 | 7830310 | State Charter Schools II- Fulton Leadership Academy | 130021703961 | 310 | Fulton Leadership Academy | Regular School | Yes | 4 | 06 | 10 | 2015 | fall | grade_8 | 0 | 67 | 0 | 0 | 0 | 0 | 0 | 67 | 0 | 67 | 0 | 67 | 0 | 0 | 0 | 0 | 0 | 67 | 0 | 67 | |||||||||||||||||||||||||||||||||
932288 | 932288 | GA | school | 1300217 | 7830310 | State Charter Schools II- Fulton Leadership Academy | 130021703961 | 310 | Fulton Leadership Academy | Regular School | Yes | 4 | 06 | 10 | 2015 | spring | grade_8 | 0 | 64 | 0 | 0 | 0 | 0 | 0 | 64 | 0 | 64 | 0 | 64 | 0 | 0 | 0 | 0 | 0 | 64 | 0 | 64 | |||||||||||||||||||||||||||||||||
14180 | 14180 | GA | school | 1300218 | 7830210 | State Charter Schools II- Pataula Charter Academy | 130021803964 | 210 | Pataula Charter Academy | Regular School | Yes | 4 | KG | 10 | 2015 | fall | grade_8 | 35 | 2 | 1 | 0 | 0 | 0 | 1 | 21 | 18 | 39 | 35 | 2 | 1 | 0 | 0 | 0 | 1 | 21 | 18 | 39 | |||||||||||||||||||||||||||||||||
932281 | 932281 | GA | school | 1300218 | 7830210 | State Charter Schools II- Pataula Charter Academy | 130021803964 | 210 | Pataula Charter Academy | Regular School | Yes | 4 | KG | 10 | 2015 | spring | grade_8 | 36 | 1 | 1 | 0 | 0 | 0 | 1 | 21 | 18 | 39 | 36 | 1 | 1 | 0 | 0 | 0 | 1 | 21 | 18 | 39 | |||||||||||||||||||||||||||||||||
14197 | 14197 | GA | school | 1300221 | 7830410 | State Charter Schools II- Atlanta Heights Charter School | 130022104021 | 410 | Atlanta Heights Charter School | Regular School | Yes | 1 | KG | 08 | 2015 | fall | grade_8 | 0 | 37 | 4 | 0 | 0 | 0 | 0 | 22 | 19 | 41 | 0 | 37 | 4 | 0 | 0 | 0 | 0 | 22 | 19 | 41 | |||||||||||||||||||||||||||||||||
932298 | 932298 | GA | school | 1300221 | 7830410 | State Charter Schools II- Atlanta Heights Charter School | 130022104021 | 410 | Atlanta Heights Charter School | Regular School | Yes | 1 | KG | 08 | 2015 | spring | grade_8 | 0 | 35 | 3 | 0 | 0 | 0 | 0 | 20 | 18 | 38 | 0 | 35 | 3 | 0 | 0 | 0 | 0 | 20 | 18 | 38 | |||||||||||||||||||||||||||||||||
14152 | 14152 | GA | school | 1300226 | 7820612 | State Charter Schools- Ivy Preparatory Academy, Inc | 130022604023 | 612 | Ivy Preparatory Academy, Inc | Regular School | Yes | 4 | KG | 09 | 2015 | fall | grade_8 | 0 | 40 | 1 | 0 | 0 | 0 | 0 | 0 | 41 | 41 | 0 | 40 | 1 | 0 | 0 | 0 | 0 | 0 | 41 | 41 | |||||||||||||||||||||||||||||||||
932253 | 932253 | GA | school | 1300226 | 7820612 | State Charter Schools- Ivy Preparatory Academy, Inc | 130022604023 | 612 | Ivy Preparatory Academy, Inc | Regular School | Yes | 4 | KG | 09 | 2015 | spring | grade_8 | 0 | 41 | 1 | 0 | 0 | 0 | 0 | 0 | 42 | 42 | 0 | 41 | 1 | 0 | 0 | 0 | 0 | 0 | 42 | 42 | |||||||||||||||||||||||||||||||||
14130 | 14130 | GA | school | 1300227 | 7820412 | State Charter Schools- Georgia Connections Academy | 130022704031 | 412 | Georgia Connections Academy | Regular School | Yes | 4 | KG | 12 | 2015 | fall | grade_8 | 200 | 133 | 27 | 2 | 8 | 0 | 18 | 183 | 205 | 388 | 200 | 133 | 27 | 2 | 8 | 0 | 18 | 183 | 205 | 388 | |||||||||||||||||||||||||||||||||
932231 | 932231 | GA | school | 1300227 | 7820412 | State Charter Schools- Georgia Connections Academy | 130022704031 | 412 | Georgia Connections Academy | Regular School | Yes | 4 | KG | 12 | 2015 | spring | grade_8 | 200 | 133 | 27 | 2 | 8 | 2 | 17 | 177 | 212 | 389 | 200 | 133 | 27 | 2 | 8 | 2 | 17 | 177 | 212 | 389 | |||||||||||||||||||||||||||||||||
14141 | 14141 | GA | school | 1300229 | 7820512 | State Charter Schools- Ivy Preparatory Young Men's Leadership Academy, Inc. | 130022904027 | 512 | Ivy Preparatory Young Men's Leadership Academy, Inc. | Regular School | Yes | 4 | KG | 09 | 2015 | fall | grade_8 | 0 | 41 | 0 | 0 | 0 | 0 | 0 | 41 | 0 | 41 | 0 | 41 | 0 | 0 | 0 | 0 | 0 | 41 | 0 | 41 | |||||||||||||||||||||||||||||||||
932242 | 932242 | GA | school | 1300229 | 7820512 | State Charter Schools- Ivy Preparatory Young Men's Leadership Academy, Inc. | 130022904027 | 512 | Ivy Preparatory Young Men's Leadership Academy, Inc. | Regular School | Yes | 4 | KG | 09 | 2015 | spring | grade_8 | 0 | 38 | 0 | 0 | 0 | 0 | 0 | 38 | 0 | 38 | 0 | 38 | 0 | 0 | 0 | 0 | 0 | 38 | 0 | 38 | |||||||||||||||||||||||||||||||||
14117 | 14117 | GA | school | 1300230 | 7820212 | State Charter Schools- Cherokee Charter Academy | 130023004051 | 212 | Cherokee Charter Academy | Regular School | Yes | 1 | KG | 08 | 2015 | fall | grade_8 | 62 | 11 | 3 | 0 | 2 | 0 | 3 | 41 | 40 | 81 | 62 | 11 | 3 | 0 | 2 | 0 | 3 | 41 | 40 | 81 | |||||||||||||||||||||||||||||||||
932218 | 932218 | GA | school | 1300230 | 7820212 | State Charter Schools- Cherokee Charter Academy | 130023004051 | 212 | Cherokee Charter Academy | Regular School | Yes | 1 | KG | 08 | 2015 | spring | grade_8 | 59 | 11 | 3 | 0 | 2 | 0 | 3 | 39 | 39 | 78 | 59 | 11 | 3 | 0 | 2 | 0 | 3 | 39 | 39 | 78 | |||||||||||||||||||||||||||||||||
14103 | 14103 | GA | school | 1300232 | 7820120 | State Charter Schools- Georgia Cyber Academy | 130023204148 | 120 | Georgia Cyber Academy | Regular School | Yes | 4 | KG | 12 | 2015 | fall | grade_8 | 886 | 499 | 93 | 5 | 35 | 5 | 72 | 741 | 854 | 1595 | 886 | 499 | 93 | 5 | 35 | 5 | 72 | 741 | 854 | 1595 | |||||||||||||||||||||||||||||||||
932204 | 932204 | GA | school | 1300232 | 7820120 | State Charter Schools- Georgia Cyber Academy | 130023204148 | 120 | Georgia Cyber Academy | Regular School | Yes | 4 | KG | 12 | 2015 | spring | grade_8 | 832 | 492 | 102 | 5 | 33 | 5 | 75 | 720 | 824 | 1544 | 832 | 492 | 102 | 5 | 33 | 5 | 75 | 720 | 824 | 1544 | |||||||||||||||||||||||||||||||||
141 | 141 | GA | school | 1300240 | 606 | Banks County | 130024002015 | 105 | Banks County Middle School | Regular School | No | 2 | 06 | 08 | 2015 | fall | grade_8 | 210 | 3 | 17 | 0 | 3 | 0 | 5 | 122 | 116 | 238 | 210 | 3 | 17 | 0 | 3 | 0 | 5 | 122 | 116 | 238 | |||||||||||||||||||||||||||||||||
918237 | 918237 | GA | school | 1300240 | 606 | Banks County | 130024002015 | 105 | Banks County Middle School | Regular School | No | 2 | 06 | 08 | 2015 | spring | grade_8 | 217 | 3 | 17 | 0 | 3 | 0 | 6 | 126 | 120 | 246 | 217 | 3 | 17 | 0 | 3 | 0 | 6 | 126 | 120 | 246 | |||||||||||||||||||||||||||||||||
206 | 206 | GA | school | 1300290 | 607 | Barrow County | 130029000175 | 114 | Bear Creek Middle School | Regular School | No | 2 | 06 | 08 | 2015 | fall | grade_8 | 133 | 46 | 40 | 2 | 12 | 0 | 10 | 121 | 122 | 243 | 133 | 46 | 40 | 2 | 12 | 0 | 10 | 121 | 122 | 243 | |||||||||||||||||||||||||||||||||
918302 | 918302 | GA | school | 1300290 | 607 | Barrow County | 130029000175 | 114 | Bear Creek Middle School | Regular School | No | 2 | 06 | 08 | 2015 | spring | grade_8 | 137 | 47 | 38 | 2 | 12 | 0 | 10 | 126 | 120 | 246 | 137 | 47 | 38 | 2 | 12 | 0 | 10 | 126 | 120 | 246 | |||||||||||||||||||||||||||||||||
209 | 209 | GA | school | 1300290 | 607 | Barrow County | 130029001913 | 198 | Westside Middle School | Regular School | No | 2 | 06 | 08 | 2015 | fall | grade_8 | 138 | 34 | 47 | 1 | 6 | 0 | 10 | 126 | 110 | 236 | 138 | 34 | 47 | 1 | 6 | 0 | 10 | 126 | 110 | 236 | |||||||||||||||||||||||||||||||||
918305 | 918305 | GA | school | 1300290 | 607 | Barrow County | 130029001913 | 198 | Westside Middle School | Regular School | No | 2 | 06 | 08 | 2015 | spring | grade_8 | 140 | 37 | 47 | 1 | 5 | 0 | 10 | 128 | 112 | 240 | 140 | 37 | 47 | 1 | 5 | 0 | 10 | 128 | 112 | 240 | |||||||||||||||||||||||||||||||||
208 | 208 | GA | school | 1300290 | 607 | Barrow County | 130029002017 | 289 | Russell Middle School | Regular School | No | 2 | 06 | 08 | 2015 | fall | grade_8 | 179 | 18 | 38 | 0 | 23 | 0 | 12 | 151 | 119 | 270 | 179 | 18 | 38 | 0 | 23 | 0 | 12 | 151 | 119 | 270 | |||||||||||||||||||||||||||||||||
918304 | 918304 | GA | school | 1300290 | 607 | Barrow County | 130029002017 | 289 | Russell Middle School | Regular School | No | 2 | 06 | 08 | 2015 | spring | grade_8 | 179 | 20 | 36 | 0 | 23 | 0 | 9 | 149 | 118 | 267 | 179 | 20 | 36 | 0 | 23 | 0 | 9 | 149 | 118 | 267 | |||||||||||||||||||||||||||||||||
207 | 207 | GA | school | 1300290 | 607 | Barrow County | 130029003285 | 106 | Haymon-Morris Middle School | Regular School | No | 2 | 06 | 08 | 2015 | fall | grade_8 | 157 | 33 | 38 | 1 | 6 | 0 | 9 | 120 | 124 | 244 | 157 | 33 | 38 | 1 | 6 | 0 | 9 | 120 | 124 | 244 | |||||||||||||||||||||||||||||||||
918303 | 918303 | GA | school | 1300290 | 607 | Barrow County | 130029003285 | 106 | Haymon-Morris Middle School | Regular School | No | 2 | 06 | 08 | 2015 | spring | grade_8 | 155 | 34 | 41 | 1 | 6 | 0 | 9 | 123 | 123 | 246 | 155 | 34 | 41 | 1 | 6 | 0 | 9 | 123 | 123 | 246 | |||||||||||||||||||||||||||||||||
322 | 322 | GA | school | 1300330 | 608 | Bartow County | 130033001868 | 195 | Cass Middle School | Regular School | No | 2 | 06 | 08 | 2015 | fall | grade_8 | 233 | 41 | 42 | 0 | 5 | 0 | 5 | 167 | 159 | 326 | 233 | 41 | 42 | 0 | 5 | 0 | 5 | 167 | 159 | 326 | |||||||||||||||||||||||||||||||||
918418 | 918418 | GA | school | 1300330 | 608 | Bartow County | 130033001868 | 195 | Cass Middle School | Regular School | No | 2 | 06 | 08 | 2015 | spring | grade_8 | 230 | 43 | 42 | 0 | 5 | 0 | 5 | 166 | 159 | 325 | 230 | 43 | 42 | 0 | 5 | 0 | 5 | 166 | 159 | 325 | |||||||||||||||||||||||||||||||||
323 | 323 | GA | school | 1300330 | 608 | Bartow County | 130033002060 | 190 | Red Top Middle School | Regular School | No | 2 | 06 | 08 | 2015 | fall | grade_8 | 144 | 17 | 36 | 1 | 2 | 0 | 8 | 117 | 91 | 208 | 144 | 17 | 36 | 1 | 2 | 0 | 8 | 117 | 91 | 208 | |||||||||||||||||||||||||||||||||
918419 | 918419 | GA | school | 1300330 | 608 | Bartow County | 130033002060 | 190 | Red Top Middle School | Regular School | No | 2 | 06 | 08 | 2015 | spring | grade_8 | 145 | 16 | 37 | 1 | 2 | 0 | 8 | 116 | 93 | 209 | 145 | 16 | 37 | 1 | 2 | 0 | 8 | 116 | 93 | 209 |
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]);