enrollments
Data source: Big Local News · About: Big Local
8,341 rows where grade = "grade_8" and state = "GA" sorted by multiracial_int descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1260872 | 1260872 | GA | school | 1300232 | 7820120 | State Charter Schools- Georgia Cyber Academy | 130023204148 | 120 | Georgia Cyber Academy | Regular School | Yes | Other | KG | 12 | 2018 | fall | grade_8 | 837 | 517 | 122 | 4 | 32 | 3 | 93 | 764 | 844 | 1608 | 837 | 517 | 122 | 4 | 32 | 3 | 93 | 764 | 844 | 1608 | |||||||||||||||||||||||||||||||||
1972329 | 1972329 | GA | school | 1300232 | 7820120 | State Charter Schools- Georgia Cyber Academy | 130023204148 | 120 | Georgia Cyber Academy | Regular School | Yes | 4 | KG | 12 | 2016 | fall | grade_8 | 808 | 528 | 111 | 4 | 34 | 4 | 85 | 760 | 814 | 1574 | 808 | 528 | 111 | 4 | 34 | 4 | 85 | 760 | 814 | 1574 | |||||||||||||||||||||||||||||||||
735104 | 735104 | GA | school | 1300232 | 7820120 | State Charter Schools- Georgia Cyber Academy | 130023204148 | 120 | Georgia Cyber Academy | Regular School | Yes | Other | KG | 12 | 2018 | spring | grade_8 | 678 | 438 | 98 | 3 | 33 | 3 | 83 | 636 | 700 | 1336 | 678 | 438 | 98 | 3 | 33 | 3 | 83 | 636 | 700 | 1336 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
2260348 | 2260348 | GA | school | 1300232 | 7820120 | State Charter Schools- Georgia Cyber Academy | 130023204148 | 120 | Georgia Cyber Academy | Regular School | Yes | 4 | KG | 12 | 2016 | spring | grade_8 | 817 | 519 | 120 | 5 | 33 | 4 | 75 | 743 | 830 | 1573 | 817 | 519 | 120 | 5 | 33 | 4 | 75 | 743 | 830 | 1573 | |||||||||||||||||||||||||||||||||
1275544 | 1275544 | GA | school | 1300232 | 7820120 | State Charter Schools- Georgia Cyber Academy | 130023204148 | 120 | Georgia Cyber Academy | Regular School | Yes | Other | KG | 12 | 2019 | fall | grade_8 | 543 | 453 | 100 | 4 | 37 | 2 | 73 | 596 | 616 | 1212 | 543 | 453 | 100 | 4 | 37 | 2 | 73 | 596 | 616 | 1212 | |||||||||||||||||||||||||||||||||
1986764 | 1986764 | GA | school | 1300232 | 7820120 | State Charter Schools- Georgia Cyber Academy | 130023204148 | 120 | Georgia Cyber Academy | Regular School | Yes | Other | KG | 12 | 2017 | fall | grade_8 | 796 | 487 | 112 | 5 | 38 | 1 | 73 | 716 | 796 | 1512 | 796 | 487 | 112 | 5 | 38 | 1 | 73 | 716 | 796 | 1512 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
2569727 | 2569727 | GA | school | 1300232 | 7820120 | State Charter Schools- Georgia Cyber Academy | 130023204148 | 120 | Georgia Cyber Academy | Regular School | Yes | Other | KG | 12 | 2019 | spring | grade_8 | 463 | 408 | 84 | 4 | 35 | 0 | 64 | 513 | 545 | 1058 | 463 | 408 | 84 | 4 | 35 | 0 | 64 | 513 | 545 | 1058 | |||||||||||||||||||||||||||||||||
431584 | 431584 | GA | school | 1300232 | 7820120 | State Charter Schools- Georgia Cyber Academy | 130023204148 | 120 | Georgia Cyber Academy | Regular School | Yes | Other | KG | 12 | 2020 | fall | grade_8 | 405 | 349 | 66 | 3 | 17 | 0 | 59 | 379 | 520 | 899 | 405 | 349 | 66 | 3 | 17 | 0 | 59 | 379 | 520 | 899 | |||||||||||||||||||||||||||||||||
310370 | 310370 | GA | school | 1300232 | 7820120 | State Charter Schools- Georgia Cyber Academy | 130023204148 | 120 | Georgia Cyber Academy | Regular School | Yes | Other | KG | 12 | 2017 | spring | grade_8 | 660 | 401 | 90 | 3 | 35 | 0 | 58 | 584 | 663 | 1247 | 660 | 401 | 90 | 3 | 35 | 0 | 58 | 584 | 663 | 1247 | |||||||||||||||||||||||||||||||||
2268516 | 2268516 | GA | school | 1302550 | 667 | Gwinnett County | 130255003945 | 1510 | North Gwinnett Middle School | Regular School | No | Middle | 06 | 08 | 2021 | spring | grade_8 | 314 | 94 | 57 | 0 | 228 | 0 | 54 | 362 | 385 | 747 | 314 | 94 | 57 | 0 | 228 | 0 | 54 | 362 | 385 | 747 | |||||||||||||||||||||||||||||||||
416855 | 416855 | GA | school | 1300232 | 7820120 | State Charter Schools- Georgia Cyber Academy | 130023204148 | 120 | Georgia Cyber Academy | Regular School | No | Other | KG | 12 | 2021 | fall | grade_8 | 391 | 404 | 88 | 3 | 25 | 0 | 53 | 449 | 515 | 964 | 391 | 404 | 88 | 3 | 25 | 0 | 53 | 449 | 515 | 964 | |||||||||||||||||||||||||||||||||
416879 | 416879 | GA | school | 1300227 | 7820412 | State Charter Schools- Georgia Connections Academy | 130022704031 | 412 | Georgia Connections Academy | Regular School | No | High | 05 | 12 | 2021 | fall | grade_8 | 384 | 298 | 77 | 1 | 21 | 1 | 53 | 391 | 444 | 835 | 384 | 298 | 77 | 1 | 21 | 1 | 53 | 391 | 444 | 835 | |||||||||||||||||||||||||||||||||
431608 | 431608 | GA | school | 1300227 | 7820412 | State Charter Schools- Georgia Connections Academy | 130022704031 | 412 | Georgia Connections Academy | Regular School | Yes | High | 05 | 12 | 2020 | fall | grade_8 | 408 | 243 | 70 | 0 | 12 | 2 | 53 | 377 | 411 | 788 | 408 | 243 | 70 | 0 | 12 | 2 | 53 | 377 | 411 | 788 | |||||||||||||||||||||||||||||||||
410621 | 410621 | GA | school | 1302550 | 667 | Gwinnett County | 130255003945 | 1510 | North Gwinnett Middle School | Regular School | No | Middle | 06 | 08 | 2021 | fall | grade_8 | 317 | 93 | 57 | 0 | 221 | 0 | 51 | 356 | 383 | 739 | 317 | 93 | 57 | 0 | 221 | 0 | 51 | 356 | 383 | 739 | |||||||||||||||||||||||||||||||||
2274799 | 2274799 | GA | school | 1300227 | 7820412 | State Charter Schools- Georgia Connections Academy | 130022704031 | 412 | Georgia Connections Academy | Regular School | No | High | 05 | 12 | 2021 | spring | grade_8 | 338 | 267 | 71 | 1 | 19 | 1 | 51 | 349 | 399 | 748 | 338 | 267 | 71 | 1 | 19 | 1 | 51 | 349 | 399 | 748 | |||||||||||||||||||||||||||||||||
2274775 | 2274775 | GA | school | 1300232 | 7820120 | State Charter Schools- Georgia Cyber Academy | 130023204148 | 120 | Georgia Cyber Academy | Regular School | No | Other | KG | 12 | 2021 | spring | grade_8 | 352 | 371 | 77 | 3 | 22 | 0 | 48 | 404 | 469 | 873 | 352 | 371 | 77 | 3 | 22 | 0 | 48 | 404 | 469 | 873 | |||||||||||||||||||||||||||||||||
1269242 | 1269242 | GA | school | 1302550 | 667 | Gwinnett County | 130255003945 | 1510 | North Gwinnett Middle School | Regular School | No | Middle | 06 | 08 | 2019 | fall | grade_8 | 356 | 83 | 63 | 0 | 234 | 0 | 45 | 411 | 370 | 781 | 356 | 83 | 63 | 0 | 234 | 0 | 45 | 411 | 370 | 781 | |||||||||||||||||||||||||||||||||
324930 | 324930 | GA | school | 1300232 | 7820120 | State Charter Schools- Georgia Cyber Academy | 130023204148 | 120 | Georgia Cyber Academy | Regular School | Yes | Other | KG | 12 | 2020 | spring | grade_8 | 314 | 305 | 55 | 3 | 16 | 0 | 43 | 306 | 430 | 736 | 314 | 305 | 55 | 3 | 16 | 0 | 43 | 306 | 430 | 736 | |||||||||||||||||||||||||||||||||
2563403 | 2563403 | GA | school | 1302550 | 667 | Gwinnett County | 130255001632 | 197 | Creekland Middle School | Regular School | No | Middle | 06 | 08 | 2019 | spring | grade_8 | 148 | 200 | 211 | 0 | 91 | 1 | 43 | 367 | 327 | 694 | 148 | 200 | 211 | 0 | 91 | 1 | 43 | 367 | 327 | 694 | |||||||||||||||||||||||||||||||||
2563421 | 2563421 | GA | school | 1302550 | 667 | Gwinnett County | 130255003945 | 1510 | North Gwinnett Middle School | Regular School | No | Middle | 06 | 08 | 2019 | spring | grade_8 | 356 | 84 | 63 | 0 | 237 | 0 | 43 | 414 | 369 | 783 | 356 | 84 | 63 | 0 | 237 | 0 | 43 | 414 | 369 | 783 | |||||||||||||||||||||||||||||||||
406479 | 406479 | GA | school | 1301410 | 636 | Columbia County | 130141002528 | 103 | Grovetown Middle School | Regular School | No | Middle | 06 | 08 | 2021 | fall | grade_8 | 123 | 145 | 55 | 1 | 5 | 1 | 41 | 190 | 181 | 371 | 123 | 145 | 55 | 1 | 5 | 1 | 41 | 190 | 181 | 371 | |||||||||||||||||||||||||||||||||
728825 | 728825 | GA | school | 1302550 | 667 | Gwinnett County | 130255003945 | 1510 | North Gwinnett Middle School | Regular School | No | Middle | 06 | 08 | 2018 | spring | grade_8 | 398 | 80 | 77 | 0 | 215 | 1 | 41 | 380 | 432 | 812 | 398 | 80 | 77 | 0 | 215 | 1 | 41 | 380 | 432 | 812 | |||||||||||||||||||||||||||||||||
2264373 | 2264373 | GA | school | 1301410 | 636 | Columbia County | 130141002528 | 103 | Grovetown Middle School | Regular School | No | Middle | 06 | 08 | 2021 | spring | grade_8 | 123 | 150 | 58 | 1 | 7 | 1 | 41 | 196 | 185 | 381 | 123 | 150 | 58 | 1 | 7 | 1 | 41 | 196 | 185 | 381 | |||||||||||||||||||||||||||||||||
324954 | 324954 | GA | school | 1300227 | 7820412 | State Charter Schools- Georgia Connections Academy | 130022704031 | 412 | Georgia Connections Academy | Regular School | Yes | High | 05 | 12 | 2020 | spring | grade_8 | 309 | 185 | 44 | 0 | 9 | 1 | 40 | 280 | 308 | 588 | 309 | 185 | 44 | 0 | 9 | 1 | 40 | 280 | 308 | 588 | |||||||||||||||||||||||||||||||||
1269224 | 1269224 | GA | school | 1302550 | 667 | Gwinnett County | 130255001632 | 197 | Creekland Middle School | Regular School | No | Middle | 06 | 08 | 2019 | fall | grade_8 | 152 | 207 | 212 | 0 | 95 | 1 | 40 | 377 | 330 | 707 | 152 | 207 | 212 | 0 | 95 | 1 | 40 | 377 | 330 | 707 | |||||||||||||||||||||||||||||||||
304112 | 304112 | GA | school | 1302550 | 667 | Gwinnett County | 130255003945 | 1510 | North Gwinnett Middle School | Regular School | No | Middle | 06 | 08 | 2017 | spring | grade_8 | 426 | 80 | 61 | 1 | 203 | 1 | 39 | 404 | 407 | 811 | 426 | 80 | 61 | 1 | 203 | 1 | 39 | 404 | 407 | 811 | |||||||||||||||||||||||||||||||||
721800 | 721800 | GA | school | 1300570 | 615 | Bryan County | 130057002235 | 199 | Richmond Hill Middle School | Regular School | No | Middle | 06 | 08 | 2018 | spring | grade_8 | 382 | 80 | 43 | 1 | 20 | 1 | 39 | 307 | 259 | 566 | 382 | 80 | 43 | 1 | 20 | 1 | 39 | 307 | 259 | 566 | |||||||||||||||||||||||||||||||||
1254605 | 1254605 | GA | school | 1302550 | 667 | Gwinnett County | 130255003945 | 1510 | North Gwinnett Middle School | Regular School | No | Middle | 06 | 08 | 2018 | fall | grade_8 | 399 | 80 | 77 | 0 | 208 | 1 | 39 | 377 | 427 | 804 | 399 | 80 | 77 | 0 | 208 | 1 | 39 | 377 | 427 | 804 | |||||||||||||||||||||||||||||||||
1275567 | 1275567 | GA | school | 1300227 | 7820412 | State Charter Schools- Georgia Connections Academy | 130022704031 | 412 | Georgia Connections Academy | Regular School | Yes | High | 06 | 12 | 2019 | fall | grade_8 | 367 | 237 | 63 | 2 | 12 | 1 | 39 | 317 | 404 | 721 | 367 | 237 | 63 | 2 | 12 | 1 | 39 | 317 | 404 | 721 | |||||||||||||||||||||||||||||||||
1980509 | 1980509 | GA | school | 1302550 | 667 | Gwinnett County | 130255003945 | 1510 | North Gwinnett Middle School | Regular School | No | Middle | 06 | 08 | 2017 | fall | grade_8 | 422 | 76 | 58 | 1 | 195 | 1 | 39 | 398 | 394 | 792 | 422 | 76 | 58 | 1 | 195 | 1 | 39 | 398 | 394 | 792 | |||||||||||||||||||||||||||||||||
2556397 | 2556397 | GA | school | 1300570 | 615 | Bryan County | 130057002235 | 199 | Richmond Hill Middle School | Regular School | No | Middle | 06 | 08 | 2019 | spring | grade_8 | 390 | 85 | 64 | 3 | 22 | 1 | 39 | 289 | 315 | 604 | 390 | 85 | 64 | 3 | 22 | 1 | 39 | 289 | 315 | 604 | |||||||||||||||||||||||||||||||||
2254040 | 2254040 | GA | school | 1302550 | 667 | Gwinnett County | 130255001632 | 197 | Creekland Middle School | Regular School | No | 2 | 06 | 08 | 2016 | spring | grade_8 | 196 | 209 | 220 | 3 | 106 | 1 | 38 | 405 | 368 | 773 | 196 | 209 | 220 | 3 | 106 | 1 | 38 | 405 | 368 | 773 | |||||||||||||||||||||||||||||||||
403858 | 403858 | GA | school | 1300780 | 620 | Camden County | 130078001875 | 182 | Camden Middle School | Regular School | No | Middle | 06 | 08 | 2021 | fall | grade_8 | 213 | 85 | 35 | 1 | 2 | 0 | 37 | 197 | 176 | 373 | 213 | 85 | 35 | 1 | 2 | 0 | 37 | 197 | 176 | 373 | |||||||||||||||||||||||||||||||||
1247596 | 1247596 | GA | school | 1300570 | 615 | Bryan County | 130057002235 | 199 | Richmond Hill Middle School | Regular School | No | Middle | 06 | 08 | 2018 | fall | grade_8 | 379 | 76 | 42 | 1 | 19 | 1 | 37 | 299 | 256 | 555 | 379 | 76 | 42 | 1 | 19 | 1 | 37 | 299 | 256 | 555 | |||||||||||||||||||||||||||||||||
1247848 | 1247848 | GA | school | 1300780 | 620 | Camden County | 130078001875 | 182 | Camden Middle School | Regular School | No | Middle | 06 | 08 | 2018 | fall | grade_8 | 195 | 75 | 18 | 3 | 7 | 2 | 37 | 181 | 156 | 337 | 195 | 75 | 18 | 3 | 7 | 2 | 37 | 181 | 156 | 337 | |||||||||||||||||||||||||||||||||
1254608 | 1254608 | GA | school | 1302550 | 667 | Gwinnett County | 130255003380 | 204 | Osborne Middle School | Regular School | No | Middle | 06 | 08 | 2018 | fall | grade_8 | 381 | 82 | 75 | 1 | 44 | 1 | 37 | 326 | 295 | 621 | 381 | 82 | 75 | 1 | 44 | 1 | 37 | 326 | 295 | 621 | |||||||||||||||||||||||||||||||||
1262212 | 1262212 | GA | school | 1300570 | 615 | Bryan County | 130057002235 | 199 | Richmond Hill Middle School | Regular School | No | Middle | 06 | 08 | 2019 | fall | grade_8 | 392 | 80 | 61 | 3 | 22 | 0 | 37 | 287 | 308 | 595 | 392 | 80 | 61 | 3 | 22 | 0 | 37 | 287 | 308 | 595 | |||||||||||||||||||||||||||||||||
2261751 | 2261751 | GA | school | 1300780 | 620 | Camden County | 130078001875 | 182 | Camden Middle School | Regular School | No | Middle | 06 | 08 | 2021 | spring | grade_8 | 216 | 86 | 35 | 1 | 2 | 0 | 37 | 196 | 181 | 377 | 216 | 86 | 35 | 1 | 2 | 0 | 37 | 196 | 181 | 377 | |||||||||||||||||||||||||||||||||
297090 | 297090 | GA | school | 1300570 | 615 | Bryan County | 130057002235 | 199 | Richmond Hill Middle School | Regular School | No | Middle | 06 | 08 | 2017 | spring | grade_8 | 371 | 93 | 48 | 1 | 18 | 0 | 36 | 301 | 266 | 567 | 371 | 93 | 48 | 1 | 18 | 0 | 36 | 301 | 266 | 567 | |||||||||||||||||||||||||||||||||
722052 | 722052 | GA | school | 1300780 | 620 | Camden County | 130078001875 | 182 | Camden Middle School | Regular School | No | Middle | 06 | 08 | 2018 | spring | grade_8 | 196 | 77 | 19 | 3 | 7 | 2 | 36 | 186 | 154 | 340 | 196 | 77 | 19 | 3 | 7 | 2 | 36 | 186 | 154 | 340 | |||||||||||||||||||||||||||||||||
728828 | 728828 | GA | school | 1302550 | 667 | Gwinnett County | 130255003380 | 204 | Osborne Middle School | Regular School | No | Middle | 06 | 08 | 2018 | spring | grade_8 | 382 | 87 | 77 | 1 | 44 | 1 | 36 | 328 | 300 | 628 | 382 | 87 | 77 | 1 | 44 | 1 | 36 | 328 | 300 | 628 | |||||||||||||||||||||||||||||||||
1269253 | 1269253 | GA | school | 1302550 | 667 | Gwinnett County | 130255001115 | 108 | Trickum Middle School | Regular School | No | Middle | 06 | 08 | 2019 | fall | grade_8 | 187 | 180 | 176 | 0 | 157 | 1 | 36 | 375 | 362 | 737 | 187 | 180 | 176 | 0 | 157 | 1 | 36 | 375 | 362 | 737 | |||||||||||||||||||||||||||||||||
304125 | 304125 | GA | school | 1302550 | 667 | Gwinnett County | 130255003912 | 1610 | Twin Rivers Middle School | Regular School | No | Middle | 06 | 08 | 2017 | spring | grade_8 | 271 | 190 | 157 | 4 | 66 | 1 | 35 | 373 | 351 | 724 | 271 | 190 | 157 | 4 | 66 | 1 | 35 | 373 | 351 | 724 | |||||||||||||||||||||||||||||||||
311645 | 311645 | GA | school | 1300570 | 615 | Bryan County | 130057002235 | 199 | Richmond Hill Middle School | Regular School | No | Middle | 06 | 08 | 2020 | spring | grade_8 | 377 | 95 | 57 | 1 | 20 | 2 | 35 | 290 | 297 | 587 | 377 | 95 | 57 | 1 | 20 | 2 | 35 | 290 | 297 | 587 | |||||||||||||||||||||||||||||||||
318627 | 318627 | GA | school | 1302550 | 667 | Gwinnett County | 130255001632 | 197 | Creekland Middle School | Regular School | No | Middle | 06 | 08 | 2020 | spring | grade_8 | 147 | 209 | 206 | 1 | 73 | 0 | 35 | 316 | 355 | 671 | 147 | 209 | 206 | 1 | 73 | 0 | 35 | 316 | 355 | 671 | |||||||||||||||||||||||||||||||||
410618 | 410618 | GA | school | 1302550 | 667 | Gwinnett County | 130255001638 | 497 | McConnell Middle School | Regular School | No | Middle | 06 | 08 | 2021 | fall | grade_8 | 198 | 415 | 159 | 2 | 25 | 0 | 35 | 428 | 406 | 834 | 198 | 415 | 159 | 2 | 25 | 0 | 35 | 428 | 406 | 834 | |||||||||||||||||||||||||||||||||
418304 | 418304 | GA | school | 1300570 | 615 | Bryan County | 130057002235 | 199 | Richmond Hill Middle School | Regular School | No | Middle | 06 | 08 | 2020 | fall | grade_8 | 378 | 91 | 58 | 1 | 22 | 2 | 35 | 296 | 291 | 587 | 378 | 91 | 58 | 1 | 22 | 2 | 35 | 296 | 291 | 587 | |||||||||||||||||||||||||||||||||
1254616 | 1254616 | GA | school | 1302550 | 667 | Gwinnett County | 130255001115 | 108 | Trickum Middle School | Regular School | No | Middle | 06 | 08 | 2018 | fall | grade_8 | 203 | 166 | 157 | 1 | 161 | 2 | 35 | 358 | 367 | 725 | 203 | 166 | 157 | 1 | 161 | 2 | 35 | 358 | 367 | 725 | |||||||||||||||||||||||||||||||||
1966018 | 1966018 | GA | school | 1302550 | 667 | Gwinnett County | 130255001632 | 197 | Creekland Middle School | Regular School | No | 2 | 06 | 08 | 2016 | fall | grade_8 | 197 | 209 | 215 | 3 | 105 | 1 | 35 | 399 | 366 | 765 | 197 | 209 | 215 | 3 | 105 | 1 | 35 | 399 | 366 | 765 | |||||||||||||||||||||||||||||||||
1973493 | 1973493 | GA | school | 1300570 | 615 | Bryan County | 130057002235 | 199 | Richmond Hill Middle School | Regular School | No | Middle | 06 | 08 | 2017 | fall | grade_8 | 374 | 92 | 48 | 1 | 19 | 0 | 35 | 299 | 270 | 569 | 374 | 92 | 48 | 1 | 19 | 0 | 35 | 299 | 270 | 569 | |||||||||||||||||||||||||||||||||
1976375 | 1976375 | GA | school | 1301410 | 636 | Columbia County | 130141002528 | 103 | Grovetown Middle School | Regular School | No | Middle | 06 | 08 | 2017 | fall | grade_8 | 112 | 144 | 43 | 1 | 3 | 2 | 35 | 181 | 159 | 340 | 112 | 144 | 43 | 1 | 3 | 2 | 35 | 181 | 159 | 340 | |||||||||||||||||||||||||||||||||
1980522 | 1980522 | GA | school | 1302550 | 667 | Gwinnett County | 130255003912 | 1610 | Twin Rivers Middle School | Regular School | No | Middle | 06 | 08 | 2017 | fall | grade_8 | 268 | 189 | 152 | 4 | 68 | 1 | 35 | 362 | 355 | 717 | 268 | 189 | 152 | 4 | 68 | 1 | 35 | 362 | 355 | 717 | |||||||||||||||||||||||||||||||||
299971 | 299971 | GA | school | 1301410 | 636 | Columbia County | 130141002528 | 103 | Grovetown Middle School | Regular School | No | Middle | 06 | 08 | 2017 | spring | grade_8 | 110 | 142 | 46 | 1 | 3 | 2 | 34 | 174 | 164 | 338 | 110 | 142 | 46 | 1 | 3 | 2 | 34 | 174 | 164 | 338 | |||||||||||||||||||||||||||||||||
304095 | 304095 | GA | school | 1302550 | 667 | Gwinnett County | 130255001632 | 197 | Creekland Middle School | Regular School | No | Middle | 06 | 08 | 2017 | spring | grade_8 | 188 | 211 | 207 | 2 | 94 | 0 | 34 | 385 | 351 | 736 | 188 | 211 | 207 | 2 | 94 | 0 | 34 | 385 | 351 | 736 | |||||||||||||||||||||||||||||||||
403604 | 403604 | GA | school | 1300570 | 615 | Bryan County | 130057002235 | 199 | Richmond Hill Middle School | Regular School | No | Middle | 06 | 08 | 2021 | fall | grade_8 | 386 | 99 | 71 | 2 | 22 | 3 | 34 | 319 | 298 | 617 | 386 | 99 | 71 | 2 | 22 | 3 | 34 | 319 | 298 | 617 | |||||||||||||||||||||||||||||||||
416223 | 416223 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012000107 | 3067 | Sutton Middle School | Regular School | No | Middle | 06 | 08 | 2021 | fall | grade_8 | 191 | 168 | 128 | 6 | 12 | 0 | 34 | 281 | 258 | 539 | 191 | 168 | 128 | 6 | 12 | 0 | 34 | 281 | 258 | 539 | |||||||||||||||||||||||||||||||||
728836 | 728836 | GA | school | 1302550 | 667 | Gwinnett County | 130255001115 | 108 | Trickum Middle School | Regular School | No | Middle | 06 | 08 | 2018 | spring | grade_8 | 197 | 171 | 153 | 2 | 163 | 2 | 34 | 363 | 359 | 722 | 197 | 171 | 153 | 2 | 163 | 2 | 34 | 363 | 359 | 722 | |||||||||||||||||||||||||||||||||
1966035 | 1966035 | GA | school | 1302550 | 667 | Gwinnett County | 130255003945 | 1510 | North Gwinnett Middle School | Regular School | No | 2 | 06 | 08 | 2016 | fall | grade_8 | 385 | 87 | 53 | 2 | 161 | 1 | 34 | 353 | 370 | 723 | 385 | 87 | 53 | 2 | 161 | 1 | 34 | 353 | 370 | 723 | |||||||||||||||||||||||||||||||||
1980521 | 1980521 | GA | school | 1302550 | 667 | Gwinnett County | 130255001115 | 108 | Trickum Middle School | Regular School | No | Middle | 06 | 08 | 2017 | fall | grade_8 | 198 | 166 | 153 | 0 | 145 | 0 | 34 | 345 | 351 | 696 | 198 | 166 | 153 | 0 | 145 | 0 | 34 | 345 | 351 | 696 | |||||||||||||||||||||||||||||||||
2254057 | 2254057 | GA | school | 1302550 | 667 | Gwinnett County | 130255003945 | 1510 | North Gwinnett Middle School | Regular School | No | 2 | 06 | 08 | 2016 | spring | grade_8 | 386 | 86 | 54 | 2 | 165 | 1 | 34 | 357 | 371 | 728 | 386 | 86 | 54 | 2 | 165 | 1 | 34 | 357 | 371 | 728 | |||||||||||||||||||||||||||||||||
2261497 | 2261497 | GA | school | 1300570 | 615 | Bryan County | 130057002235 | 199 | Richmond Hill Middle School | Regular School | No | Middle | 06 | 08 | 2021 | spring | grade_8 | 392 | 98 | 71 | 2 | 21 | 3 | 34 | 323 | 298 | 621 | 392 | 98 | 71 | 2 | 21 | 3 | 34 | 323 | 298 | 621 | |||||||||||||||||||||||||||||||||
2268513 | 2268513 | GA | school | 1302550 | 667 | Gwinnett County | 130255001638 | 497 | McConnell Middle School | Regular School | No | Middle | 06 | 08 | 2021 | spring | grade_8 | 200 | 414 | 164 | 2 | 25 | 0 | 34 | 434 | 405 | 839 | 200 | 414 | 164 | 2 | 25 | 0 | 34 | 434 | 405 | 839 | |||||||||||||||||||||||||||||||||
2274143 | 2274143 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012000107 | 3067 | Sutton Middle School | Regular School | No | Middle | 06 | 08 | 2021 | spring | grade_8 | 187 | 167 | 127 | 7 | 11 | 0 | 34 | 278 | 255 | 533 | 187 | 167 | 127 | 7 | 11 | 0 | 34 | 278 | 255 | 533 | |||||||||||||||||||||||||||||||||
2563432 | 2563432 | GA | school | 1302550 | 667 | Gwinnett County | 130255001115 | 108 | Trickum Middle School | Regular School | No | Middle | 06 | 08 | 2019 | spring | grade_8 | 189 | 178 | 170 | 0 | 162 | 1 | 34 | 367 | 367 | 734 | 189 | 178 | 170 | 0 | 162 | 1 | 34 | 367 | 367 | 734 | |||||||||||||||||||||||||||||||||
404799 | 404799 | GA | school | 1301110 | 628 | Cherokee County | 130111001438 | 297 | Woodstock Middle School | Regular School | No | Middle | 06 | 08 | 2021 | fall | grade_8 | 213 | 77 | 97 | 1 | 10 | 0 | 33 | 212 | 219 | 431 | 213 | 77 | 97 | 1 | 10 | 0 | 33 | 212 | 219 | 431 | |||||||||||||||||||||||||||||||||
724100 | 724100 | GA | school | 1301290 | 633 | Cobb County | 130129000566 | 4050 | Awtrey Middle School | Regular School | No | Middle | 06 | 08 | 2018 | spring | grade_8 | 106 | 81 | 45 | 0 | 14 | 1 | 33 | 130 | 150 | 280 | 106 | 81 | 45 | 0 | 14 | 1 | 33 | 130 | 150 | 280 | |||||||||||||||||||||||||||||||||
1260900 | 1260900 | GA | school | 1300227 | 7820412 | State Charter Schools- Georgia Connections Academy | 130022704031 | 412 | Georgia Connections Academy | Regular School | Yes | Other | KG | 12 | 2018 | fall | grade_8 | 216 | 129 | 30 | 3 | 3 | 0 | 33 | 195 | 219 | 414 | 216 | 129 | 30 | 3 | 3 | 0 | 33 | 195 | 219 | 414 | |||||||||||||||||||||||||||||||||
1980492 | 1980492 | GA | school | 1302550 | 667 | Gwinnett County | 130255001632 | 197 | Creekland Middle School | Regular School | No | Middle | 06 | 08 | 2017 | fall | grade_8 | 195 | 207 | 203 | 2 | 94 | 0 | 33 | 386 | 348 | 734 | 195 | 207 | 203 | 2 | 94 | 0 | 33 | 386 | 348 | 734 | |||||||||||||||||||||||||||||||||
2262693 | 2262693 | GA | school | 1301110 | 628 | Cherokee County | 130111001438 | 297 | Woodstock Middle School | Regular School | No | Middle | 06 | 08 | 2021 | spring | grade_8 | 206 | 78 | 96 | 1 | 10 | 0 | 33 | 212 | 212 | 424 | 206 | 78 | 96 | 1 | 10 | 0 | 33 | 212 | 212 | 424 | |||||||||||||||||||||||||||||||||
7745 | 7745 | GA | school | 1302550 | 667 | Gwinnett County | 130255001122 | 905 | Duluth Middle School | Regular School | No | 2 | 06 | 08 | 2015 | fall | grade_8 | 152 | 197 | 210 | 1 | 115 | 1 | 32 | 366 | 342 | 708 | 152 | 197 | 210 | 1 | 115 | 1 | 32 | 366 | 342 | 708 | |||||||||||||||||||||||||||||||||
311896 | 311896 | GA | school | 1300780 | 620 | Camden County | 130078001875 | 182 | Camden Middle School | Regular School | No | Middle | 06 | 08 | 2020 | spring | grade_8 | 171 | 88 | 20 | 1 | 4 | 1 | 32 | 157 | 160 | 317 | 171 | 88 | 20 | 1 | 4 | 1 | 32 | 157 | 160 | 317 | |||||||||||||||||||||||||||||||||
319929 | 319929 | GA | school | 1302880 | 676 | Houston County | 130288001677 | 296 | Bonaire Middle School | Regular School | No | Middle | 06 | 08 | 2020 | spring | grade_8 | 211 | 85 | 31 | 0 | 7 | 1 | 32 | 191 | 176 | 367 | 211 | 85 | 31 | 0 | 7 | 1 | 32 | 191 | 176 | 367 | |||||||||||||||||||||||||||||||||
412371 | 412371 | GA | school | 1303300 | 689 | Liberty County | 130330002504 | 101 | Midway Middle School | Regular School | No | Middle | 06 | 08 | 2021 | fall | grade_8 | 101 | 138 | 32 | 0 | 1 | 0 | 32 | 148 | 156 | 304 | 101 | 138 | 32 | 0 | 1 | 0 | 32 | 148 | 156 | 304 | |||||||||||||||||||||||||||||||||
418555 | 418555 | GA | school | 1300780 | 620 | Camden County | 130078001875 | 182 | Camden Middle School | Regular School | No | Middle | 06 | 08 | 2020 | fall | grade_8 | 170 | 87 | 21 | 1 | 5 | 1 | 32 | 155 | 162 | 317 | 170 | 87 | 21 | 1 | 5 | 1 | 32 | 155 | 162 | 317 | |||||||||||||||||||||||||||||||||
730571 | 730571 | GA | school | 1303300 | 689 | Liberty County | 130330001736 | 197 | Lewis Frasier Middle School | Regular School | No | Middle | 06 | 08 | 2018 | spring | grade_8 | 43 | 136 | 33 | 1 | 5 | 4 | 32 | 129 | 125 | 254 | 43 | 136 | 33 | 1 | 5 | 4 | 32 | 129 | 125 | 254 | |||||||||||||||||||||||||||||||||
1249890 | 1249890 | GA | school | 1301290 | 633 | Cobb County | 130129000566 | 4050 | Awtrey Middle School | Regular School | No | Middle | 06 | 08 | 2018 | fall | grade_8 | 106 | 84 | 46 | 0 | 15 | 1 | 32 | 134 | 150 | 284 | 106 | 84 | 46 | 0 | 15 | 1 | 32 | 134 | 150 | 284 | |||||||||||||||||||||||||||||||||
1263408 | 1263408 | GA | school | 1301110 | 628 | Cherokee County | 130111001860 | 181 | E. T. Booth Middle School | Regular School | No | Middle | 06 | 08 | 2019 | fall | grade_8 | 367 | 63 | 131 | 0 | 12 | 0 | 32 | 315 | 290 | 605 | 367 | 63 | 131 | 0 | 12 | 0 | 32 | 315 | 290 | 605 | |||||||||||||||||||||||||||||||||
1961952 | 1961952 | GA | school | 1301410 | 636 | Columbia County | 130141002528 | 103 | Grovetown Middle School | Regular School | No | 2 | 06 | 08 | 2016 | fall | grade_8 | 102 | 109 | 57 | 0 | 10 | 0 | 32 | 159 | 151 | 310 | 102 | 109 | 57 | 0 | 10 | 0 | 32 | 159 | 151 | 310 | |||||||||||||||||||||||||||||||||
2268498 | 2268498 | GA | school | 1302550 | 667 | Gwinnett County | 130255001632 | 197 | Creekland Middle School | Regular School | No | Middle | 06 | 08 | 2021 | spring | grade_8 | 110 | 223 | 197 | 0 | 79 | 0 | 32 | 342 | 299 | 641 | 110 | 223 | 197 | 0 | 79 | 0 | 32 | 342 | 299 | 641 | |||||||||||||||||||||||||||||||||
2274553 | 2274553 | GA | school | 1301680 | 773 | City Schools of Decatur | 130168000796 | 1552 | Renfroe Middle School | Regular School | No | Middle | 06 | 08 | 2021 | spring | grade_8 | 271 | 94 | 23 | 2 | 12 | 0 | 32 | 222 | 212 | 434 | 271 | 94 | 23 | 2 | 12 | 0 | 32 | 222 | 212 | 434 | |||||||||||||||||||||||||||||||||
2563433 | 2563433 | GA | school | 1302550 | 667 | Gwinnett County | 130255003912 | 1610 | Twin Rivers Middle School | Regular School | No | Middle | 06 | 08 | 2019 | spring | grade_8 | 214 | 201 | 154 | 2 | 86 | 0 | 32 | 346 | 343 | 689 | 214 | 201 | 154 | 2 | 86 | 0 | 32 | 346 | 343 | 689 | |||||||||||||||||||||||||||||||||
304124 | 304124 | GA | school | 1302550 | 667 | Gwinnett County | 130255001115 | 108 | Trickum Middle School | Regular School | No | Middle | 06 | 08 | 2017 | spring | grade_8 | 199 | 172 | 158 | 0 | 152 | 0 | 31 | 358 | 354 | 712 | 199 | 172 | 158 | 0 | 152 | 0 | 31 | 358 | 354 | 712 | |||||||||||||||||||||||||||||||||
416633 | 416633 | GA | school | 1301680 | 773 | City Schools of Decatur | 130168000796 | 1552 | Renfroe Middle School | Regular School | No | Middle | 06 | 08 | 2021 | fall | grade_8 | 273 | 94 | 23 | 2 | 11 | 0 | 31 | 222 | 212 | 434 | 273 | 94 | 23 | 2 | 11 | 0 | 31 | 222 | 212 | 434 | |||||||||||||||||||||||||||||||||
425289 | 425289 | GA | school | 1302550 | 667 | Gwinnett County | 130255001632 | 197 | Creekland Middle School | Regular School | No | Middle | 06 | 08 | 2020 | fall | grade_8 | 149 | 219 | 203 | 1 | 73 | 0 | 31 | 323 | 353 | 676 | 149 | 219 | 203 | 1 | 73 | 0 | 31 | 323 | 353 | 676 | |||||||||||||||||||||||||||||||||
425310 | 425310 | GA | school | 1302550 | 667 | Gwinnett County | 130255003380 | 204 | Osborne Middle School | Regular School | No | Middle | 06 | 08 | 2020 | fall | grade_8 | 327 | 95 | 70 | 0 | 46 | 0 | 31 | 284 | 285 | 569 | 327 | 95 | 70 | 0 | 46 | 0 | 31 | 284 | 285 | 569 | |||||||||||||||||||||||||||||||||
425318 | 425318 | GA | school | 1302550 | 667 | Gwinnett County | 130255001115 | 108 | Trickum Middle School | Regular School | No | Middle | 06 | 08 | 2020 | fall | grade_8 | 180 | 192 | 190 | 3 | 156 | 2 | 31 | 399 | 355 | 754 | 180 | 192 | 190 | 3 | 156 | 2 | 31 | 399 | 355 | 754 | |||||||||||||||||||||||||||||||||
735132 | 735132 | GA | school | 1300227 | 7820412 | State Charter Schools- Georgia Connections Academy | 130022704031 | 412 | Georgia Connections Academy | Regular School | Yes | Other | KG | 12 | 2018 | spring | grade_8 | 192 | 131 | 29 | 2 | 3 | 0 | 31 | 186 | 202 | 388 | 192 | 131 | 29 | 2 | 3 | 0 | 31 | 186 | 202 | 388 | |||||||||||||||||||||||||||||||||
1254587 | 1254587 | GA | school | 1302550 | 667 | Gwinnett County | 130255001632 | 197 | Creekland Middle School | Regular School | No | Middle | 06 | 08 | 2018 | fall | grade_8 | 155 | 221 | 238 | 1 | 100 | 2 | 31 | 389 | 359 | 748 | 155 | 221 | 238 | 1 | 100 | 2 | 31 | 389 | 359 | 748 | |||||||||||||||||||||||||||||||||
1269254 | 1269254 | GA | school | 1302550 | 667 | Gwinnett County | 130255003912 | 1610 | Twin Rivers Middle School | Regular School | No | Middle | 06 | 08 | 2019 | fall | grade_8 | 216 | 203 | 148 | 1 | 83 | 0 | 31 | 346 | 336 | 682 | 216 | 203 | 148 | 1 | 83 | 0 | 31 | 346 | 336 | 682 | |||||||||||||||||||||||||||||||||
1275322 | 1275322 | GA | school | 1301680 | 773 | City Schools of Decatur | 130168000796 | 1552 | Renfroe Middle School | Regular School | No | Middle | 06 | 08 | 2019 | fall | grade_8 | 258 | 100 | 23 | 1 | 13 | 1 | 31 | 236 | 191 | 427 | 258 | 100 | 23 | 1 | 13 | 1 | 31 | 236 | 191 | 427 | |||||||||||||||||||||||||||||||||
2249980 | 2249980 | GA | school | 1301410 | 636 | Columbia County | 130141002528 | 103 | Grovetown Middle School | Regular School | No | 2 | 06 | 08 | 2016 | spring | grade_8 | 104 | 110 | 57 | 0 | 11 | 0 | 31 | 165 | 148 | 313 | 104 | 110 | 57 | 0 | 11 | 0 | 31 | 165 | 148 | 313 | |||||||||||||||||||||||||||||||||
2261752 | 2261752 | GA | school | 1300780 | 620 | Camden County | 130078003299 | 105 | Saint Marys Middle School | Regular School | No | Middle | 06 | 08 | 2021 | spring | grade_8 | 236 | 74 | 30 | 1 | 3 | 0 | 31 | 191 | 184 | 375 | 236 | 74 | 30 | 1 | 3 | 0 | 31 | 191 | 184 | 375 | |||||||||||||||||||||||||||||||||
2270272 | 2270272 | GA | school | 1303300 | 689 | Liberty County | 130330002504 | 101 | Midway Middle School | Regular School | No | Middle | 06 | 08 | 2021 | spring | grade_8 | 101 | 132 | 32 | 0 | 1 | 2 | 31 | 145 | 154 | 299 | 101 | 132 | 32 | 0 | 1 | 2 | 31 | 145 | 154 | 299 | |||||||||||||||||||||||||||||||||
2557592 | 2557592 | GA | school | 1301110 | 628 | Cherokee County | 130111001860 | 181 | E. T. Booth Middle School | Regular School | No | Middle | 06 | 08 | 2019 | spring | grade_8 | 362 | 66 | 132 | 0 | 12 | 0 | 31 | 315 | 288 | 603 | 362 | 66 | 132 | 0 | 12 | 0 | 31 | 315 | 288 | 603 | |||||||||||||||||||||||||||||||||
2569506 | 2569506 | GA | school | 1301680 | 773 | City Schools of Decatur | 130168000796 | 1552 | Renfroe Middle School | Regular School | No | Middle | 06 | 08 | 2019 | spring | grade_8 | 256 | 96 | 22 | 1 | 12 | 1 | 31 | 229 | 190 | 419 | 256 | 96 | 22 | 1 | 12 | 1 | 31 | 229 | 190 | 419 | |||||||||||||||||||||||||||||||||
304107 | 304107 | GA | school | 1302550 | 667 | Gwinnett County | 130255003738 | 209 | Lanier Middle School | Regular School | No | Middle | 06 | 08 | 2017 | spring | grade_8 | 183 | 82 | 109 | 1 | 28 | 0 | 30 | 227 | 206 | 433 | 183 | 82 | 109 | 1 | 28 | 0 | 30 | 227 | 206 | 433 | |||||||||||||||||||||||||||||||||
318645 | 318645 | GA | school | 1302550 | 667 | Gwinnett County | 130255003945 | 1510 | North Gwinnett Middle School | Regular School | No | Middle | 06 | 08 | 2020 | spring | grade_8 | 334 | 82 | 75 | 0 | 221 | 2 | 30 | 398 | 346 | 744 | 334 | 82 | 75 | 0 | 221 | 2 | 30 | 398 | 346 | 744 | |||||||||||||||||||||||||||||||||
318656 | 318656 | GA | school | 1302550 | 667 | Gwinnett County | 130255001115 | 108 | Trickum Middle School | Regular School | No | Middle | 06 | 08 | 2020 | spring | grade_8 | 179 | 192 | 198 | 3 | 157 | 2 | 30 | 410 | 351 | 761 | 179 | 192 | 198 | 3 | 157 | 2 | 30 | 410 | 351 | 761 |
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]);