enrollments
Data source: Big Local News · About: Big Local
8,341 rows where grade = "grade_8" and state = "GA" sorted by white_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
1263406 | 1263406 | GA | school | 1301110 | 628 | Cherokee County | 130111003312 | 305 | Creekland Middle School | Regular School | No | Middle | 06 | 08 | 2019 | fall | grade_8 | 475 | 12 | 41 | 0 | 4 | 0 | 7 | 278 | 261 | 539 | 475 | 12 | 41 | 0 | 4 | 0 | 7 | 278 | 261 | 539 | |||||||||||||||||||||||||||||||||
2557590 | 2557590 | GA | school | 1301110 | 628 | Cherokee County | 130111003312 | 305 | Creekland Middle School | Regular School | No | Middle | 06 | 08 | 2019 | spring | grade_8 | 473 | 11 | 40 | 0 | 5 | 0 | 8 | 280 | 257 | 537 | 473 | 11 | 40 | 0 | 5 | 0 | 8 | 280 | 257 | 537 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
2248295 | 2248295 | GA | school | 1301110 | 628 | Cherokee County | 130111003312 | 305 | Creekland Middle School | Regular School | No | 2 | 06 | 08 | 2016 | spring | grade_8 | 461 | 11 | 36 | 0 | 7 | 0 | 5 | 263 | 257 | 520 | 461 | 11 | 36 | 0 | 7 | 0 | 5 | 263 | 257 | 520 | |||||||||||||||||||||||||||||||||
1960267 | 1960267 | GA | school | 1301110 | 628 | Cherokee County | 130111003312 | 305 | Creekland Middle School | Regular School | No | 2 | 06 | 08 | 2016 | fall | grade_8 | 456 | 11 | 34 | 0 | 6 | 0 | 6 | 258 | 255 | 513 | 456 | 11 | 34 | 0 | 6 | 0 | 6 | 258 | 255 | 513 | |||||||||||||||||||||||||||||||||
312824 | 312824 | GA | school | 1301110 | 628 | Cherokee County | 130111003312 | 305 | Creekland Middle School | Regular School | No | Middle | 06 | 08 | 2020 | spring | grade_8 | 447 | 11 | 55 | 1 | 4 | 0 | 14 | 283 | 249 | 532 | 447 | 11 | 55 | 1 | 4 | 0 | 14 | 283 | 249 | 532 | |||||||||||||||||||||||||||||||||
723000 | 723000 | GA | school | 1301110 | 628 | Cherokee County | 130111003312 | 305 | Creekland Middle School | Regular School | No | Middle | 06 | 08 | 2018 | spring | grade_8 | 447 | 13 | 32 | 0 | 4 | 0 | 11 | 267 | 240 | 507 | 447 | 13 | 32 | 0 | 4 | 0 | 11 | 267 | 240 | 507 | |||||||||||||||||||||||||||||||||
1248793 | 1248793 | GA | school | 1301110 | 628 | Cherokee County | 130111003312 | 305 | Creekland Middle School | Regular School | No | Middle | 06 | 08 | 2018 | fall | grade_8 | 444 | 12 | 30 | 0 | 4 | 0 | 12 | 268 | 234 | 502 | 444 | 12 | 30 | 0 | 4 | 0 | 12 | 268 | 234 | 502 | |||||||||||||||||||||||||||||||||
419482 | 419482 | GA | school | 1301110 | 628 | Cherokee County | 130111003312 | 305 | Creekland Middle School | Regular School | No | Middle | 06 | 08 | 2020 | fall | grade_8 | 443 | 10 | 52 | 1 | 4 | 0 | 15 | 278 | 247 | 525 | 443 | 10 | 52 | 1 | 4 | 0 | 15 | 278 | 247 | 525 | |||||||||||||||||||||||||||||||||
920090 | 920090 | GA | school | 1301110 | 628 | Cherokee County | 130111003312 | 305 | Creekland Middle School | Regular School | No | 2 | 06 | 08 | 2015 | spring | grade_8 | 440 | 14 | 34 | 0 | 4 | 0 | 10 | 260 | 242 | 502 | 440 | 14 | 34 | 0 | 4 | 0 | 10 | 260 | 242 | 502 | |||||||||||||||||||||||||||||||||
298286 | 298286 | GA | school | 1301110 | 628 | Cherokee County | 130111001860 | 181 | E. T. Booth Middle School | Regular School | No | Middle | 06 | 08 | 2017 | spring | grade_8 | 438 | 64 | 103 | 4 | 6 | 0 | 25 | 316 | 324 | 640 | 438 | 64 | 103 | 4 | 6 | 0 | 25 | 316 | 324 | 640 | |||||||||||||||||||||||||||||||||
1992 | 1992 | GA | school | 1301110 | 628 | Cherokee County | 130111003312 | 305 | Creekland Middle School | Regular School | No | 2 | 06 | 08 | 2015 | fall | grade_8 | 436 | 14 | 35 | 0 | 4 | 0 | 11 | 258 | 242 | 500 | 436 | 14 | 35 | 0 | 4 | 0 | 11 | 258 | 242 | 500 | |||||||||||||||||||||||||||||||||
1974692 | 1974692 | GA | school | 1301110 | 628 | Cherokee County | 130111001860 | 181 | E. T. Booth Middle School | Regular School | No | Middle | 06 | 08 | 2017 | fall | grade_8 | 435 | 61 | 101 | 4 | 6 | 0 | 25 | 310 | 322 | 632 | 435 | 61 | 101 | 4 | 6 | 0 | 25 | 310 | 322 | 632 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
298284 | 298284 | GA | school | 1301110 | 628 | Cherokee County | 130111003312 | 305 | Creekland Middle School | Regular School | No | Middle | 06 | 08 | 2017 | spring | grade_8 | 424 | 8 | 54 | 0 | 6 | 0 | 10 | 271 | 231 | 502 | 424 | 8 | 54 | 0 | 6 | 0 | 10 | 271 | 231 | 502 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
1974690 | 1974690 | GA | school | 1301110 | 628 | Cherokee County | 130111003312 | 305 | Creekland Middle School | Regular School | No | Middle | 06 | 08 | 2017 | fall | grade_8 | 417 | 6 | 53 | 0 | 7 | 0 | 10 | 268 | 225 | 493 | 417 | 6 | 53 | 0 | 7 | 0 | 10 | 268 | 225 | 493 | |||||||||||||||||||||||||||||||||
2262687 | 2262687 | GA | school | 1301110 | 628 | Cherokee County | 130111003312 | 305 | Creekland Middle School | Regular School | No | Middle | 06 | 08 | 2021 | spring | grade_8 | 417 | 12 | 48 | 0 | 4 | 0 | 13 | 245 | 249 | 494 | 417 | 12 | 48 | 0 | 4 | 0 | 13 | 245 | 249 | 494 | |||||||||||||||||||||||||||||||||
419483 | 419483 | GA | school | 1301110 | 628 | Cherokee County | 130111001970 | 187 | Dean Rusk Middle School | Regular School | No | Middle | 06 | 08 | 2020 | fall | grade_8 | 415 | 39 | 67 | 1 | 5 | 0 | 21 | 296 | 252 | 548 | 415 | 39 | 67 | 1 | 5 | 0 | 21 | 296 | 252 | 548 | |||||||||||||||||||||||||||||||||
312825 | 312825 | GA | school | 1301110 | 628 | Cherokee County | 130111001970 | 187 | Dean Rusk Middle School | Regular School | No | Middle | 06 | 08 | 2020 | spring | grade_8 | 413 | 43 | 70 | 1 | 5 | 0 | 23 | 298 | 257 | 555 | 413 | 43 | 70 | 1 | 5 | 0 | 23 | 298 | 257 | 555 | |||||||||||||||||||||||||||||||||
925859 | 925859 | GA | school | 1302550 | 667 | Gwinnett County | 130255003945 | 1510 | North Gwinnett Middle School | Regular School | No | 2 | 06 | 08 | 2015 | spring | grade_8 | 411 | 82 | 53 | 0 | 147 | 1 | 21 | 379 | 336 | 715 | 411 | 82 | 53 | 0 | 147 | 1 | 21 | 379 | 336 | 715 | |||||||||||||||||||||||||||||||||
7758 | 7758 | GA | school | 1302550 | 667 | Gwinnett County | 130255003945 | 1510 | North Gwinnett Middle School | Regular School | No | 2 | 06 | 08 | 2015 | fall | grade_8 | 410 | 79 | 52 | 0 | 145 | 1 | 20 | 375 | 332 | 707 | 410 | 79 | 52 | 0 | 145 | 1 | 20 | 375 | 332 | 707 | |||||||||||||||||||||||||||||||||
404793 | 404793 | GA | school | 1301110 | 628 | Cherokee County | 130111003312 | 305 | Creekland Middle School | Regular School | No | Middle | 06 | 08 | 2021 | fall | grade_8 | 409 | 12 | 46 | 0 | 3 | 0 | 13 | 240 | 243 | 483 | 409 | 12 | 46 | 0 | 3 | 0 | 13 | 240 | 243 | 483 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
419484 | 419484 | GA | school | 1301110 | 628 | Cherokee County | 130111001860 | 181 | E. T. Booth Middle School | Regular School | No | Middle | 06 | 08 | 2020 | fall | grade_8 | 401 | 64 | 150 | 0 | 16 | 0 | 27 | 332 | 326 | 658 | 401 | 64 | 150 | 0 | 16 | 0 | 27 | 332 | 326 | 658 | |||||||||||||||||||||||||||||||||
1248794 | 1248794 | GA | school | 1301110 | 628 | Cherokee County | 130111001970 | 187 | Dean Rusk Middle School | Regular School | No | Middle | 06 | 08 | 2018 | fall | grade_8 | 400 | 29 | 69 | 1 | 9 | 0 | 11 | 259 | 260 | 519 | 400 | 29 | 69 | 1 | 9 | 0 | 11 | 259 | 260 | 519 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
920092 | 920092 | GA | school | 1301110 | 628 | Cherokee County | 130111001860 | 181 | E. T. Booth Middle School | Regular School | No | 2 | 06 | 08 | 2015 | spring | grade_8 | 398 | 45 | 86 | 3 | 8 | 1 | 11 | 286 | 266 | 552 | 398 | 45 | 86 | 3 | 8 | 1 | 11 | 286 | 266 | 552 | |||||||||||||||||||||||||||||||||
1994 | 1994 | GA | school | 1301110 | 628 | Cherokee County | 130111001860 | 181 | E. T. Booth Middle School | Regular School | No | 2 | 06 | 08 | 2015 | fall | grade_8 | 394 | 41 | 83 | 3 | 8 | 1 | 10 | 279 | 261 | 540 | 394 | 41 | 83 | 3 | 8 | 1 | 10 | 279 | 261 | 540 | |||||||||||||||||||||||||||||||||
723001 | 723001 | GA | school | 1301110 | 628 | Cherokee County | 130111001970 | 187 | Dean Rusk Middle School | Regular School | No | Middle | 06 | 08 | 2018 | spring | grade_8 | 394 | 28 | 71 | 1 | 9 | 0 | 12 | 259 | 256 | 515 | 394 | 28 | 71 | 1 | 9 | 0 | 12 | 259 | 256 | 515 | |||||||||||||||||||||||||||||||||
312826 | 312826 | GA | school | 1301110 | 628 | Cherokee County | 130111001860 | 181 | E. T. Booth Middle School | Regular School | No | Middle | 06 | 08 | 2020 | spring | grade_8 | 393 | 65 | 156 | 0 | 15 | 0 | 29 | 326 | 332 | 658 | 393 | 65 | 156 | 0 | 15 | 0 | 29 | 326 | 332 | 658 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
404794 | 404794 | GA | school | 1301110 | 628 | Cherokee County | 130111001970 | 187 | Dean Rusk Middle School | Regular School | No | Middle | 06 | 08 | 2021 | fall | grade_8 | 390 | 31 | 89 | 0 | 9 | 1 | 20 | 260 | 280 | 540 | 390 | 31 | 89 | 0 | 9 | 1 | 20 | 260 | 280 | 540 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
2262688 | 2262688 | GA | school | 1301110 | 628 | Cherokee County | 130111001970 | 187 | Dean Rusk Middle School | Regular School | No | Middle | 06 | 08 | 2021 | spring | grade_8 | 387 | 29 | 86 | 0 | 11 | 0 | 20 | 255 | 278 | 533 | 387 | 29 | 86 | 0 | 11 | 0 | 20 | 255 | 278 | 533 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
7760 | 7760 | GA | school | 1302550 | 667 | Gwinnett County | 130255003380 | 204 | Osborne Middle School | Regular School | No | 2 | 06 | 08 | 2015 | fall | grade_8 | 377 | 92 | 58 | 0 | 29 | 0 | 20 | 300 | 276 | 576 | 377 | 92 | 58 | 0 | 29 | 0 | 20 | 300 | 276 | 576 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
925861 | 925861 | GA | school | 1302550 | 667 | Gwinnett County | 130255003380 | 204 | Osborne Middle School | Regular School | No | 2 | 06 | 08 | 2015 | spring | grade_8 | 377 | 95 | 58 | 0 | 29 | 0 | 21 | 303 | 277 | 580 | 377 | 95 | 58 | 0 | 29 | 0 | 21 | 303 | 277 | 580 | |||||||||||||||||||||||||||||||||
2247098 | 2247098 | GA | school | 1300570 | 615 | Bryan County | 130057002235 | 199 | Richmond Hill Middle School | Regular School | No | 2 | 06 | 08 | 2016 | spring | grade_8 | 377 | 82 | 55 | 0 | 17 | 1 | 23 | 295 | 260 | 555 | 377 | 82 | 55 | 0 | 17 | 1 | 23 | 295 | 260 | 555 | |||||||||||||||||||||||||||||||||
2254060 | 2254060 | GA | school | 1302550 | 667 | Gwinnett County | 130255003380 | 204 | Osborne Middle School | Regular School | No | 2 | 06 | 08 | 2016 | spring | grade_8 | 377 | 79 | 61 | 1 | 36 | 2 | 27 | 274 | 309 | 583 | 377 | 79 | 61 | 1 | 36 | 2 | 27 | 274 | 309 | 583 | |||||||||||||||||||||||||||||||||
1959070 | 1959070 | GA | school | 1300570 | 615 | Bryan County | 130057002235 | 199 | Richmond Hill Middle School | Regular School | No | 2 | 06 | 08 | 2016 | fall | grade_8 | 374 | 78 | 53 | 0 | 16 | 1 | 25 | 288 | 259 | 547 | 374 | 78 | 53 | 0 | 16 | 1 | 25 | 288 | 259 | 547 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
1248795 | 1248795 | GA | school | 1301110 | 628 | Cherokee County | 130111001860 | 181 | E. T. Booth Middle School | Regular School | No | Middle | 06 | 08 | 2018 | fall | grade_8 | 372 | 52 | 111 | 2 | 13 | 1 | 17 | 283 | 285 | 568 | 372 | 52 | 111 | 2 | 13 | 1 | 17 | 283 | 285 | 568 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
1966038 | 1966038 | GA | school | 1302550 | 667 | Gwinnett County | 130255003380 | 204 | Osborne Middle School | Regular School | No | 2 | 06 | 08 | 2016 | fall | grade_8 | 371 | 78 | 62 | 1 | 35 | 1 | 26 | 269 | 305 | 574 | 371 | 78 | 62 | 1 | 35 | 1 | 26 | 269 | 305 | 574 | |||||||||||||||||||||||||||||||||
723002 | 723002 | GA | school | 1301110 | 628 | Cherokee County | 130111001860 | 181 | E. T. Booth Middle School | Regular School | No | Middle | 06 | 08 | 2018 | spring | grade_8 | 370 | 53 | 113 | 2 | 13 | 1 | 19 | 293 | 278 | 571 | 370 | 53 | 113 | 2 | 13 | 1 | 19 | 293 | 278 | 571 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
1263407 | 1263407 | GA | school | 1301110 | 628 | Cherokee County | 130111001970 | 187 | Dean Rusk Middle School | Regular School | No | Middle | 06 | 08 | 2019 | fall | grade_8 | 363 | 40 | 78 | 2 | 6 | 1 | 21 | 257 | 254 | 511 | 363 | 40 | 78 | 2 | 6 | 1 | 21 | 257 | 254 | 511 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
809 | 809 | GA | school | 1300570 | 615 | Bryan County | 130057002235 | 199 | Richmond Hill Middle School | Regular School | No | 2 | 06 | 08 | 2015 | fall | grade_8 | 361 | 77 | 45 | 0 | 16 | 2 | 28 | 275 | 254 | 529 | 361 | 77 | 45 | 0 | 16 | 2 | 28 | 275 | 254 | 529 | |||||||||||||||||||||||||||||||||
918904 | 918904 | GA | school | 1300570 | 615 | Bryan County | 130057002235 | 199 | Richmond Hill Middle School | Regular School | No | 2 | 06 | 08 | 2015 | spring | grade_8 | 360 | 78 | 47 | 0 | 17 | 1 | 27 | 276 | 254 | 530 | 360 | 78 | 47 | 0 | 17 | 1 | 27 | 276 | 254 | 530 | |||||||||||||||||||||||||||||||||
2262689 | 2262689 | GA | school | 1301110 | 628 | Cherokee County | 130111001860 | 181 | E. T. Booth Middle School | Regular School | No | Middle | 06 | 08 | 2021 | spring | grade_8 | 360 | 62 | 137 | 0 | 17 | 0 | 26 | 331 | 271 | 602 | 360 | 62 | 137 | 0 | 17 | 0 | 26 | 331 | 271 | 602 | |||||||||||||||||||||||||||||||||
920091 | 920091 | GA | school | 1301110 | 628 | Cherokee County | 130111001970 | 187 | Dean Rusk Middle School | Regular School | No | 2 | 07 | 08 | 2015 | spring | grade_8 | 359 | 35 | 39 | 2 | 7 | 0 | 16 | 253 | 205 | 458 | 359 | 35 | 39 | 2 | 7 | 0 | 16 | 253 | 205 | 458 | |||||||||||||||||||||||||||||||||
1993 | 1993 | GA | school | 1301110 | 628 | Cherokee County | 130111001970 | 187 | Dean Rusk Middle School | Regular School | No | 2 | 07 | 08 | 2015 | fall | grade_8 | 358 | 37 | 44 | 2 | 6 | 0 | 17 | 252 | 212 | 464 | 358 | 37 | 44 | 2 | 6 | 0 | 17 | 252 | 212 | 464 | |||||||||||||||||||||||||||||||||
2248296 | 2248296 | GA | school | 1301110 | 628 | Cherokee County | 130111001970 | 187 | Dean Rusk Middle School | Regular School | No | 2 | 07 | 08 | 2016 | spring | grade_8 | 357 | 26 | 58 | 1 | 8 | 1 | 17 | 240 | 228 | 468 | 357 | 26 | 58 | 1 | 8 | 1 | 17 | 240 | 228 | 468 | |||||||||||||||||||||||||||||||||
2557591 | 2557591 | GA | school | 1301110 | 628 | Cherokee County | 130111001970 | 187 | Dean Rusk Middle School | Regular School | No | Middle | 06 | 08 | 2019 | spring | grade_8 | 357 | 41 | 78 | 2 | 6 | 1 | 21 | 250 | 256 | 506 | 357 | 41 | 78 | 2 | 6 | 1 | 21 | 250 | 256 | 506 | |||||||||||||||||||||||||||||||||
404795 | 404795 | GA | school | 1301110 | 628 | Cherokee County | 130111001860 | 181 | E. T. Booth Middle School | Regular School | No | Middle | 06 | 08 | 2021 | fall | grade_8 | 356 | 59 | 134 | 0 | 17 | 0 | 25 | 333 | 258 | 591 | 356 | 59 | 134 | 0 | 17 | 0 | 25 | 333 | 258 | 591 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
298285 | 298285 | GA | school | 1301110 | 628 | Cherokee County | 130111001970 | 187 | Dean Rusk Middle School | Regular School | No | Middle | 06 | 08 | 2017 | spring | grade_8 | 354 | 31 | 74 | 2 | 10 | 2 | 20 | 272 | 221 | 493 | 354 | 31 | 74 | 2 | 10 | 2 | 20 | 272 | 221 | 493 | |||||||||||||||||||||||||||||||||
1974691 | 1974691 | GA | school | 1301110 | 628 | Cherokee County | 130111001970 | 187 | Dean Rusk Middle School | Regular School | No | Middle | 06 | 08 | 2017 | fall | grade_8 | 354 | 31 | 71 | 2 | 10 | 2 | 19 | 271 | 218 | 489 | 354 | 31 | 71 | 2 | 10 | 2 | 19 | 271 | 218 | 489 | |||||||||||||||||||||||||||||||||
2248297 | 2248297 | GA | school | 1301110 | 628 | Cherokee County | 130111001860 | 181 | E. T. Booth Middle School | Regular School | No | 2 | 06 | 08 | 2016 | spring | grade_8 | 354 | 54 | 101 | 0 | 14 | 1 | 18 | 281 | 261 | 542 | 354 | 54 | 101 | 0 | 14 | 1 | 18 | 281 | 261 | 542 | |||||||||||||||||||||||||||||||||
413578 | 413578 | GA | school | 1304020 | 710 | Paulding County | 130402003693 | 108 | Sammy McClure Sr. Middle School | Regular School | No | Middle | 06 | 08 | 2021 | fall | grade_8 | 353 | 82 | 42 | 0 | 6 | 0 | 24 | 279 | 228 | 507 | 353 | 82 | 42 | 0 | 6 | 0 | 24 | 279 | 228 | 507 | |||||||||||||||||||||||||||||||||
1960269 | 1960269 | GA | school | 1301110 | 628 | Cherokee County | 130111001860 | 181 | E. T. Booth Middle School | Regular School | No | 2 | 06 | 08 | 2016 | fall | grade_8 | 353 | 59 | 96 | 0 | 14 | 1 | 19 | 289 | 253 | 542 | 353 | 59 | 96 | 0 | 14 | 1 | 19 | 289 | 253 | 542 | |||||||||||||||||||||||||||||||||
6082 | 6082 | GA | school | 1302220 | 658 | Forsyth County | 130222003352 | 105 | Riverwatch Middle School | Regular School | No | 2 | 06 | 08 | 2015 | fall | grade_8 | 352 | 16 | 24 | 1 | 119 | 0 | 12 | 257 | 267 | 524 | 352 | 16 | 24 | 1 | 119 | 0 | 12 | 257 | 267 | 524 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
1960268 | 1960268 | GA | school | 1301110 | 628 | Cherokee County | 130111001970 | 187 | Dean Rusk Middle School | Regular School | No | 2 | 07 | 08 | 2016 | fall | grade_8 | 351 | 26 | 59 | 1 | 8 | 1 | 16 | 237 | 225 | 462 | 351 | 26 | 59 | 1 | 8 | 1 | 16 | 237 | 225 | 462 | |||||||||||||||||||||||||||||||||
924182 | 924182 | GA | school | 1302220 | 658 | Forsyth County | 130222003352 | 105 | Riverwatch Middle School | Regular School | No | 2 | 06 | 08 | 2015 | spring | grade_8 | 348 | 15 | 25 | 1 | 121 | 0 | 12 | 256 | 266 | 522 | 348 | 15 | 25 | 1 | 121 | 0 | 12 | 256 | 266 | 522 | |||||||||||||||||||||||||||||||||
2271496 | 2271496 | GA | school | 1304020 | 710 | Paulding County | 130402003693 | 108 | Sammy McClure Sr. Middle School | Regular School | No | Middle | 06 | 08 | 2021 | spring | grade_8 | 347 | 86 | 40 | 0 | 7 | 0 | 27 | 277 | 230 | 507 | 347 | 86 | 40 | 0 | 7 | 0 | 27 | 277 | 230 | 507 | |||||||||||||||||||||||||||||||||
2269260 | 2269260 | GA | school | 1302700 | 672 | Harris County | 130270002271 | 399 | Harris County Carver Middle School | Regular School | No | Middle | 07 | 08 | 2021 | spring | grade_8 | 345 | 54 | 32 | 1 | 2 | 2 | 22 | 240 | 218 | 458 | 345 | 54 | 32 | 1 | 2 | 2 | 22 | 240 | 218 | 458 | |||||||||||||||||||||||||||||||||
413711 | 413711 | GA | school | 1304110 | 712 | Pickens County | 130411002048 | 189 | Pickens County Junior High School | Regular School | No | Middle | 07 | 08 | 2021 | fall | grade_8 | 340 | 4 | 24 | 1 | 1 | 0 | 4 | 193 | 181 | 374 | 340 | 4 | 24 | 1 | 1 | 0 | 4 | 193 | 181 | 374 | |||||||||||||||||||||||||||||||||
2252382 | 2252382 | GA | school | 1302220 | 658 | Forsyth County | 130222002261 | 199 | Vickery Creek Middle School | Regular School | No | 2 | 06 | 08 | 2016 | spring | grade_8 | 339 | 18 | 34 | 2 | 40 | 0 | 10 | 206 | 237 | 443 | 339 | 18 | 34 | 2 | 40 | 0 | 10 | 206 | 237 | 443 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
428286 | 428286 | GA | school | 1304020 | 710 | Paulding County | 130402003693 | 108 | Sammy McClure Sr. Middle School | Regular School | No | Middle | 06 | 08 | 2020 | fall | grade_8 | 337 | 69 | 51 | 3 | 4 | 0 | 17 | 248 | 233 | 481 | 337 | 69 | 51 | 3 | 4 | 0 | 17 | 248 | 233 | 481 | |||||||||||||||||||||||||||||||||
425307 | 425307 | GA | school | 1302550 | 667 | Gwinnett County | 130255003945 | 1510 | North Gwinnett Middle School | Regular School | No | Middle | 06 | 08 | 2020 | fall | grade_8 | 336 | 82 | 74 | 0 | 217 | 2 | 28 | 394 | 345 | 739 | 336 | 82 | 74 | 0 | 217 | 2 | 28 | 394 | 345 | 739 | |||||||||||||||||||||||||||||||||
1964359 | 1964359 | GA | school | 1302220 | 658 | Forsyth County | 130222002261 | 199 | Vickery Creek Middle School | Regular School | No | 2 | 06 | 08 | 2016 | fall | grade_8 | 336 | 18 | 33 | 2 | 39 | 0 | 10 | 204 | 234 | 438 | 336 | 18 | 33 | 2 | 39 | 0 | 10 | 204 | 234 | 438 | |||||||||||||||||||||||||||||||||
411362 | 411362 | GA | school | 1302700 | 672 | Harris County | 130270002271 | 399 | Harris County Carver Middle School | Regular School | No | Middle | 07 | 08 | 2021 | fall | grade_8 | 335 | 51 | 31 | 1 | 2 | 2 | 24 | 236 | 210 | 446 | 335 | 51 | 31 | 1 | 2 | 2 | 24 | 236 | 210 | 446 |
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]);