enrollments
Data source: Big Local News · About: Big Local
29,136 rows where state = "GA" and year = 2017 sorted by asian_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1979511 | 1979511 | GA | school | 1302280 | 660 | Fulton County | 130228002560 | 203 | Northview High School | Regular School | No | High | 09 | 12 | 2017 | fall | pk_12_total | 552 | 215 | 84 | 0 | 913 | 0 | 58 | 946 | 876 | 1822 | 552 | 215 | 84 | 0 | 913 | 0 | 58 | 946 | 876 | 1822 | |||||||||||||||||||||||||||||||||
303113 | 303113 | GA | school | 1302280 | 660 | Fulton County | 130228002560 | 203 | Northview High School | Regular School | No | High | 09 | 12 | 2017 | spring | pk_12_total | 551 | 207 | 85 | 0 | 909 | 0 | 59 | 937 | 874 | 1811 | 551 | 207 | 85 | 0 | 909 | 0 | 59 | 937 | 874 | 1811 | |||||||||||||||||||||||||||||||||
1980735 | 1980735 | GA | school | 1302550 | 667 | Gwinnett County | 130255002903 | 805 | Peachtree Ridge High School | Regular School | No | High | 09 | 12 | 2017 | fall | pk_12_total | 796 | 911 | 583 | 4 | 839 | 2 | 125 | 1584 | 1676 | 3260 | 796 | 911 | 583 | 4 | 839 | 2 | 125 | 1584 | 1676 | 3260 | |||||||||||||||||||||||||||||||||
304338 | 304338 | GA | school | 1302550 | 667 | Gwinnett County | 130255002903 | 805 | Peachtree Ridge High School | Regular School | No | High | 09 | 12 | 2017 | spring | pk_12_total | 787 | 893 | 576 | 4 | 834 | 2 | 118 | 1557 | 1657 | 3214 | 787 | 893 | 576 | 4 | 834 | 2 | 118 | 1557 | 1657 | 3214 | |||||||||||||||||||||||||||||||||
302419 | 302419 | GA | school | 1302220 | 658 | Forsyth County | 130222001610 | 197 | Daves Creek Elementary School | Regular School | No | Elementary | PK | 05 | 2017 | spring | pk_12_total | 266 | 27 | 53 | 13 | 755 | 1 | 25 | 583 | 557 | 1140 | 266 | 27 | 53 | 13 | 755 | 1 | 25 | 583 | 557 | 1140 | |||||||||||||||||||||||||||||||||
1978819 | 1978819 | GA | school | 1302220 | 658 | Forsyth County | 130222001610 | 197 | Daves Creek Elementary School | Regular School | No | Elementary | PK | 05 | 2017 | fall | pk_12_total | 264 | 27 | 50 | 14 | 707 | 1 | 21 | 554 | 530 | 1084 | 264 | 27 | 50 | 14 | 707 | 1 | 21 | 554 | 530 | 1084 | |||||||||||||||||||||||||||||||||
301179 | 301179 | GA | school | 1301740 | 644 | DeKalb County | 130174000740 | 2059 | Indian Creek Elementary School | Regular School | No | Elementary | PK | 05 | 2017 | spring | pk_12_total | 72 | 439 | 39 | 5 | 691 | 8 | 3 | 655 | 602 | 1257 | 72 | 439 | 39 | 5 | 691 | 8 | 3 | 655 | 602 | 1257 | |||||||||||||||||||||||||||||||||
303128 | 303128 | GA | school | 1302280 | 660 | Fulton County | 130228002493 | 402 | River Trail Middle School | Regular School | No | Middle | 06 | 08 | 2017 | spring | pk_12_total | 287 | 125 | 51 | 2 | 682 | 0 | 45 | 605 | 587 | 1192 | 287 | 125 | 51 | 2 | 682 | 0 | 45 | 605 | 587 | 1192 | |||||||||||||||||||||||||||||||||
302425 | 302425 | GA | school | 1302220 | 658 | Forsyth County | 130222003685 | 108 | Johns Creek Elementary | Regular School | No | Elementary | PK | 05 | 2017 | spring | pk_12_total | 257 | 40 | 49 | 3 | 679 | 1 | 48 | 559 | 518 | 1077 | 257 | 40 | 49 | 3 | 679 | 1 | 48 | 559 | 518 | 1077 | |||||||||||||||||||||||||||||||||
1979526 | 1979526 | GA | school | 1302280 | 660 | Fulton County | 130228002493 | 402 | River Trail Middle School | Regular School | No | Middle | 06 | 08 | 2017 | fall | pk_12_total | 287 | 122 | 48 | 2 | 675 | 0 | 44 | 599 | 579 | 1178 | 287 | 122 | 48 | 2 | 675 | 0 | 44 | 599 | 579 | 1178 | |||||||||||||||||||||||||||||||||
1977581 | 1977581 | GA | school | 1301740 | 644 | DeKalb County | 130174000740 | 2059 | Indian Creek Elementary School | Regular School | No | Elementary | PK | 05 | 2017 | fall | pk_12_total | 51 | 396 | 36 | 6 | 661 | 7 | 3 | 599 | 561 | 1160 | 51 | 396 | 36 | 6 | 661 | 7 | 3 | 599 | 561 | 1160 | |||||||||||||||||||||||||||||||||
1978828 | 1978828 | GA | school | 1302220 | 658 | Forsyth County | 130222003954 | 214 | Lambert High School | Regular School | No | High | 09 | 12 | 2017 | fall | pk_12_total | 1926 | 110 | 155 | 8 | 657 | 0 | 78 | 1436 | 1498 | 2934 | 1926 | 110 | 155 | 8 | 657 | 0 | 78 | 1436 | 1498 | 2934 | |||||||||||||||||||||||||||||||||
302428 | 302428 | GA | school | 1302220 | 658 | Forsyth County | 130222003954 | 214 | Lambert High School | Regular School | No | High | 09 | 12 | 2017 | spring | pk_12_total | 1907 | 110 | 155 | 8 | 656 | 0 | 80 | 1421 | 1495 | 2916 | 1907 | 110 | 155 | 8 | 656 | 0 | 80 | 1421 | 1495 | 2916 | |||||||||||||||||||||||||||||||||
1978825 | 1978825 | GA | school | 1302220 | 658 | Forsyth County | 130222003685 | 108 | Johns Creek Elementary | Regular School | No | Elementary | PK | 05 | 2017 | fall | pk_12_total | 259 | 35 | 44 | 3 | 654 | 1 | 48 | 534 | 510 | 1044 | 259 | 35 | 44 | 3 | 654 | 1 | 48 | 534 | 510 | 1044 | |||||||||||||||||||||||||||||||||
1978844 | 1978844 | GA | school | 1302220 | 658 | Forsyth County | 130222001897 | 190 | South Forsyth High School | Regular School | No | High | 09 | 12 | 2017 | fall | pk_12_total | 2004 | 139 | 344 | 10 | 622 | 5 | 82 | 1558 | 1648 | 3206 | 2004 | 139 | 344 | 10 | 622 | 5 | 82 | 1558 | 1648 | 3206 | |||||||||||||||||||||||||||||||||
302444 | 302444 | GA | school | 1302220 | 658 | Forsyth County | 130222001897 | 190 | South Forsyth High School | Regular School | No | High | 09 | 12 | 2017 | spring | pk_12_total | 1978 | 150 | 325 | 10 | 620 | 4 | 80 | 1544 | 1623 | 3167 | 1978 | 150 | 325 | 10 | 620 | 4 | 80 | 1544 | 1623 | 3167 | |||||||||||||||||||||||||||||||||
302438 | 302438 | GA | school | 1302220 | 658 | Forsyth County | 130222003352 | 105 | Riverwatch Middle School | Regular School | No | Middle | 06 | 08 | 2017 | spring | pk_12_total | 592 | 55 | 68 | 5 | 617 | 1 | 34 | 706 | 666 | 1372 | 592 | 55 | 68 | 5 | 617 | 1 | 34 | 706 | 666 | 1372 | |||||||||||||||||||||||||||||||||
1978838 | 1978838 | GA | school | 1302220 | 658 | Forsyth County | 130222003352 | 105 | Riverwatch Middle School | Regular School | No | Middle | 06 | 08 | 2017 | fall | pk_12_total | 586 | 53 | 68 | 5 | 611 | 1 | 36 | 697 | 663 | 1360 | 586 | 53 | 68 | 5 | 611 | 1 | 36 | 697 | 663 | 1360 | |||||||||||||||||||||||||||||||||
1980723 | 1980723 | GA | school | 1302550 | 667 | Gwinnett County | 130255001123 | 4556 | North Gwinnett High School | Regular School | No | High | 09 | 12 | 2017 | fall | pk_12_total | 1582 | 362 | 251 | 2 | 609 | 5 | 120 | 1476 | 1455 | 2931 | 1582 | 362 | 251 | 2 | 609 | 5 | 120 | 1476 | 1455 | 2931 | |||||||||||||||||||||||||||||||||
304326 | 304326 | GA | school | 1302550 | 667 | Gwinnett County | 130255001123 | 4556 | North Gwinnett High School | Regular School | No | High | 09 | 12 | 2017 | spring | pk_12_total | 1554 | 351 | 254 | 3 | 605 | 5 | 117 | 1462 | 1427 | 2889 | 1554 | 351 | 254 | 3 | 605 | 5 | 117 | 1462 | 1427 | 2889 | |||||||||||||||||||||||||||||||||
304333 | 304333 | GA | school | 1302550 | 667 | Gwinnett County | 130255001114 | 176 | Parkview High School | Regular School | No | High | 09 | 12 | 2017 | spring | pk_12_total | 880 | 789 | 508 | 14 | 601 | 2 | 118 | 1501 | 1411 | 2912 | 880 | 789 | 508 | 14 | 601 | 2 | 118 | 1501 | 1411 | 2912 | |||||||||||||||||||||||||||||||||
1980730 | 1980730 | GA | school | 1302550 | 667 | Gwinnett County | 130255001114 | 176 | Parkview High School | Regular School | No | High | 09 | 12 | 2017 | fall | pk_12_total | 903 | 809 | 538 | 13 | 598 | 3 | 120 | 1533 | 1451 | 2984 | 903 | 809 | 538 | 13 | 598 | 3 | 120 | 1533 | 1451 | 2984 | |||||||||||||||||||||||||||||||||
304327 | 304327 | GA | school | 1302550 | 667 | Gwinnett County | 130255003945 | 1510 | North Gwinnett Middle School | Regular School | No | Middle | 06 | 08 | 2017 | spring | pk_12_total | 1152 | 232 | 195 | 1 | 593 | 3 | 109 | 1132 | 1153 | 2285 | 1152 | 232 | 195 | 1 | 593 | 3 | 109 | 1132 | 1153 | 2285 | |||||||||||||||||||||||||||||||||
1980724 | 1980724 | GA | school | 1302550 | 667 | Gwinnett County | 130255003945 | 1510 | North Gwinnett Middle School | Regular School | No | Middle | 06 | 08 | 2017 | fall | pk_12_total | 1154 | 225 | 188 | 1 | 575 | 3 | 108 | 1121 | 1133 | 2254 | 1154 | 225 | 188 | 1 | 575 | 3 | 108 | 1121 | 1133 | 2254 | |||||||||||||||||||||||||||||||||
304252 | 304252 | GA | school | 1302550 | 667 | Gwinnett County | 130255001906 | 182 | Brookwood High School | Regular School | No | High | 09 | 12 | 2017 | spring | pk_12_total | 1322 | 947 | 470 | 14 | 571 | 5 | 146 | 1759 | 1716 | 3475 | 1322 | 947 | 470 | 14 | 571 | 5 | 146 | 1759 | 1716 | 3475 | |||||||||||||||||||||||||||||||||
1980649 | 1980649 | GA | school | 1302550 | 667 | Gwinnett County | 130255001906 | 182 | Brookwood High School | Regular School | No | High | 09 | 12 | 2017 | fall | pk_12_total | 1342 | 957 | 474 | 15 | 561 | 6 | 147 | 1766 | 1736 | 3502 | 1342 | 957 | 474 | 15 | 561 | 6 | 147 | 1766 | 1736 | 3502 | |||||||||||||||||||||||||||||||||
303095 | 303095 | GA | school | 1302280 | 660 | Fulton County | 130228003935 | 910 | Johns Creek High School | Regular School | No | High | 09 | 12 | 2017 | spring | pk_12_total | 1175 | 184 | 148 | 6 | 521 | 4 | 48 | 1045 | 1041 | 2086 | 1175 | 184 | 148 | 6 | 521 | 4 | 48 | 1045 | 1041 | 2086 | |||||||||||||||||||||||||||||||||
1979493 | 1979493 | GA | school | 1302280 | 660 | Fulton County | 130228003935 | 910 | Johns Creek High School | Regular School | No | High | 09 | 12 | 2017 | fall | pk_12_total | 1182 | 187 | 145 | 5 | 520 | 4 | 47 | 1051 | 1039 | 2090 | 1182 | 187 | 145 | 5 | 520 | 4 | 47 | 1051 | 1039 | 2090 | |||||||||||||||||||||||||||||||||
302440 | 302440 | GA | school | 1302220 | 658 | Forsyth County | 130222002320 | 100 | Settles Bridge Elementary School | Regular School | No | Elementary | PK | 05 | 2017 | spring | pk_12_total | 447 | 50 | 69 | 4 | 508 | 0 | 41 | 568 | 551 | 1119 | 447 | 50 | 69 | 4 | 508 | 0 | 41 | 568 | 551 | 1119 | |||||||||||||||||||||||||||||||||
1976010 | 1976010 | GA | school | 1301290 | 633 | Cobb County | 130129000513 | 175 | Walton High School | Regular School | Yes | High | 09 | 12 | 2017 | fall | pk_12_total | 1830 | 165 | 134 | 3 | 502 | 2 | 57 | 1401 | 1292 | 2693 | 1830 | 165 | 134 | 3 | 502 | 2 | 57 | 1401 | 1292 | 2693 | |||||||||||||||||||||||||||||||||
1977543 | 1977543 | GA | school | 1301740 | 644 | DeKalb County | 130174000708 | 4053 | Clarkston High School | Regular School | No | High | 09 | 12 | 2017 | fall | pk_12_total | 37 | 950 | 61 | 1 | 502 | 2 | 16 | 785 | 784 | 1569 | 37 | 950 | 61 | 1 | 502 | 2 | 16 | 785 | 784 | 1569 | |||||||||||||||||||||||||||||||||
299605 | 299605 | GA | school | 1301290 | 633 | Cobb County | 130129000513 | 175 | Walton High School | Regular School | Yes | High | 09 | 12 | 2017 | spring | pk_12_total | 1807 | 168 | 136 | 3 | 500 | 2 | 59 | 1394 | 1281 | 2675 | 1807 | 168 | 136 | 3 | 500 | 2 | 59 | 1394 | 1281 | 2675 | |||||||||||||||||||||||||||||||||
1978840 | 1978840 | GA | school | 1302220 | 658 | Forsyth County | 130222002320 | 100 | Settles Bridge Elementary School | Regular School | No | Elementary | PK | 05 | 2017 | fall | pk_12_total | 442 | 48 | 67 | 4 | 499 | 0 | 42 | 563 | 539 | 1102 | 442 | 48 | 67 | 4 | 499 | 0 | 42 | 563 | 539 | 1102 | |||||||||||||||||||||||||||||||||
301141 | 301141 | GA | school | 1301740 | 644 | DeKalb County | 130174000708 | 4053 | Clarkston High School | Regular School | No | High | 09 | 12 | 2017 | spring | pk_12_total | 46 | 944 | 63 | 2 | 482 | 2 | 18 | 780 | 777 | 1557 | 46 | 944 | 63 | 2 | 482 | 2 | 18 | 780 | 777 | 1557 | |||||||||||||||||||||||||||||||||
304272 | 304272 | GA | school | 1302550 | 667 | Gwinnett County | 130255001118 | 5550 | Duluth High School | Regular School | No | High | 09 | 12 | 2017 | spring | pk_12_total | 472 | 806 | 826 | 4 | 474 | 7 | 101 | 1381 | 1309 | 2690 | 472 | 806 | 826 | 4 | 474 | 7 | 101 | 1381 | 1309 | 2690 | |||||||||||||||||||||||||||||||||
1979459 | 1979459 | GA | school | 1302280 | 660 | Fulton County | 130228002172 | 392 | Chattahoochee High School | Regular School | No | High | 09 | 12 | 2017 | fall | pk_12_total | 942 | 264 | 184 | 1 | 473 | 1 | 95 | 1032 | 928 | 1960 | 942 | 264 | 184 | 1 | 473 | 1 | 95 | 1032 | 928 | 1960 | |||||||||||||||||||||||||||||||||
303061 | 303061 | GA | school | 1302280 | 660 | Fulton County | 130228002172 | 392 | Chattahoochee High School | Regular School | No | High | 09 | 12 | 2017 | spring | pk_12_total | 934 | 256 | 184 | 1 | 471 | 1 | 90 | 1020 | 917 | 1937 | 934 | 256 | 184 | 1 | 471 | 1 | 90 | 1020 | 917 | 1937 | |||||||||||||||||||||||||||||||||
302442 | 302442 | GA | school | 1302220 | 658 | Forsyth County | 130222003353 | 106 | Shiloh Point Elementary | Regular School | No | Elementary | PK | 05 | 2017 | spring | pk_12_total | 553 | 33 | 148 | 8 | 470 | 1 | 34 | 637 | 610 | 1247 | 553 | 33 | 148 | 8 | 470 | 1 | 34 | 637 | 610 | 1247 | |||||||||||||||||||||||||||||||||
304294 | 304294 | GA | school | 1302550 | 667 | Gwinnett County | 130255001633 | 297 | Hull Middle School | Regular School | No | Middle | 06 | 08 | 2017 | spring | pk_12_total | 299 | 316 | 133 | 3 | 464 | 3 | 55 | 654 | 619 | 1273 | 299 | 316 | 133 | 3 | 464 | 3 | 55 | 654 | 619 | 1273 | |||||||||||||||||||||||||||||||||
1980669 | 1980669 | GA | school | 1302550 | 667 | Gwinnett County | 130255001118 | 5550 | Duluth High School | Regular School | No | High | 09 | 12 | 2017 | fall | pk_12_total | 489 | 815 | 850 | 5 | 464 | 7 | 101 | 1394 | 1337 | 2731 | 489 | 815 | 850 | 5 | 464 | 7 | 101 | 1394 | 1337 | 2731 | |||||||||||||||||||||||||||||||||
304365 | 304365 | GA | school | 1302550 | 667 | Gwinnett County | 130255001115 | 108 | Trickum Middle School | Regular School | No | Middle | 06 | 08 | 2017 | spring | pk_12_total | 583 | 474 | 470 | 2 | 461 | 2 | 96 | 1059 | 1029 | 2088 | 583 | 474 | 470 | 2 | 461 | 2 | 96 | 1059 | 1029 | 2088 | |||||||||||||||||||||||||||||||||
1980691 | 1980691 | GA | school | 1302550 | 667 | Gwinnett County | 130255001633 | 297 | Hull Middle School | Regular School | No | Middle | 06 | 08 | 2017 | fall | pk_12_total | 301 | 312 | 129 | 3 | 451 | 3 | 52 | 646 | 605 | 1251 | 301 | 312 | 129 | 3 | 451 | 3 | 52 | 646 | 605 | 1251 | |||||||||||||||||||||||||||||||||
1980762 | 1980762 | GA | school | 1302550 | 667 | Gwinnett County | 130255001115 | 108 | Trickum Middle School | Regular School | No | Middle | 06 | 08 | 2017 | fall | pk_12_total | 574 | 475 | 456 | 2 | 450 | 2 | 97 | 1042 | 1014 | 2056 | 574 | 475 | 456 | 2 | 450 | 2 | 97 | 1042 | 1014 | 2056 | |||||||||||||||||||||||||||||||||
303148 | 303148 | GA | school | 1302280 | 660 | Fulton County | 130228003367 | 405 | Wilson Creek Elementary School | Regular School | No | Elementary | PK | 05 | 2017 | spring | pk_12_total | 214 | 103 | 39 | 3 | 442 | 0 | 36 | 429 | 408 | 837 | 214 | 103 | 39 | 3 | 442 | 0 | 36 | 429 | 408 | 837 | |||||||||||||||||||||||||||||||||
303135 | 303135 | GA | school | 1302280 | 660 | Fulton County | 130228002190 | 398 | Shakerag Elementary School | Regular School | No | Elementary | PK | 05 | 2017 | spring | pk_12_total | 171 | 63 | 37 | 0 | 437 | 0 | 32 | 360 | 380 | 740 | 171 | 63 | 37 | 0 | 437 | 0 | 32 | 360 | 380 | 740 | |||||||||||||||||||||||||||||||||
1978842 | 1978842 | GA | school | 1302220 | 658 | Forsyth County | 130222003353 | 106 | Shiloh Point Elementary | Regular School | No | Elementary | PK | 05 | 2017 | fall | pk_12_total | 551 | 37 | 150 | 6 | 433 | 1 | 35 | 623 | 590 | 1213 | 551 | 37 | 150 | 6 | 433 | 1 | 35 | 623 | 590 | 1213 | |||||||||||||||||||||||||||||||||
1979533 | 1979533 | GA | school | 1302280 | 660 | Fulton County | 130228002190 | 398 | Shakerag Elementary School | Regular School | No | Elementary | PK | 05 | 2017 | fall | pk_12_total | 165 | 61 | 36 | 0 | 433 | 0 | 34 | 351 | 378 | 729 | 165 | 61 | 36 | 0 | 433 | 0 | 34 | 351 | 378 | 729 | |||||||||||||||||||||||||||||||||
302412 | 302412 | GA | school | 1302220 | 658 | Forsyth County | 130222000954 | 1050 | Big Creek Elementary School | Regular School | No | Elementary | PK | 05 | 2017 | spring | pk_12_total | 284 | 26 | 43 | 0 | 431 | 0 | 23 | 414 | 393 | 807 | 284 | 26 | 43 | 0 | 431 | 0 | 23 | 414 | 393 | 807 | |||||||||||||||||||||||||||||||||
1980685 | 1980685 | GA | school | 1302550 | 667 | Gwinnett County | 130255003553 | 1019 | Gwinnett School of Mathematics, Science and Technology | Regular School | No | High | 09 | 12 | 2017 | fall | pk_12_total | 192 | 223 | 100 | 1 | 428 | 1 | 34 | 546 | 433 | 979 | 192 | 223 | 100 | 1 | 428 | 1 | 34 | 546 | 433 | 979 | |||||||||||||||||||||||||||||||||
1978812 | 1978812 | GA | school | 1302220 | 658 | Forsyth County | 130222000954 | 1050 | Big Creek Elementary School | Regular School | No | Elementary | PK | 05 | 2017 | fall | pk_12_total | 286 | 24 | 42 | 0 | 420 | 0 | 23 | 408 | 387 | 795 | 286 | 24 | 42 | 0 | 420 | 0 | 23 | 408 | 387 | 795 | |||||||||||||||||||||||||||||||||
1979546 | 1979546 | GA | school | 1302280 | 660 | Fulton County | 130228003367 | 405 | Wilson Creek Elementary School | Regular School | No | Elementary | PK | 05 | 2017 | fall | pk_12_total | 213 | 100 | 39 | 3 | 416 | 0 | 37 | 410 | 398 | 808 | 213 | 100 | 39 | 3 | 416 | 0 | 37 | 410 | 398 | 808 | |||||||||||||||||||||||||||||||||
304288 | 304288 | GA | school | 1302550 | 667 | Gwinnett County | 130255003553 | 1019 | Gwinnett School of Mathematics, Science and Technology | Regular School | No | High | 09 | 12 | 2017 | spring | pk_12_total | 180 | 197 | 87 | 1 | 415 | 1 | 27 | 506 | 402 | 908 | 180 | 197 | 87 | 1 | 415 | 1 | 27 | 506 | 402 | 908 | |||||||||||||||||||||||||||||||||
1979467 | 1979467 | GA | school | 1302280 | 660 | Fulton County | 130228002489 | 102 | Creek View Elementary School | Regular School | No | Elementary | PK | 05 | 2017 | fall | pk_12_total | 287 | 83 | 76 | 0 | 412 | 0 | 33 | 436 | 455 | 891 | 287 | 83 | 76 | 0 | 412 | 0 | 33 | 436 | 455 | 891 | |||||||||||||||||||||||||||||||||
1980658 | 1980658 | GA | school | 1302550 | 667 | Gwinnett County | 130255000959 | 195 | Collins Hill High School | Regular School | No | High | 09 | 12 | 2017 | fall | pk_12_total | 871 | 909 | 801 | 5 | 404 | 3 | 152 | 1636 | 1509 | 3145 | 871 | 909 | 801 | 5 | 404 | 3 | 152 | 1636 | 1509 | 3145 | |||||||||||||||||||||||||||||||||
303069 | 303069 | GA | school | 1302280 | 660 | Fulton County | 130228002489 | 102 | Creek View Elementary School | Regular School | No | Elementary | PK | 05 | 2017 | spring | pk_12_total | 287 | 83 | 69 | 0 | 402 | 0 | 32 | 427 | 446 | 873 | 287 | 83 | 69 | 0 | 402 | 0 | 32 | 427 | 446 | 873 | |||||||||||||||||||||||||||||||||
1979448 | 1979448 | GA | school | 1302280 | 660 | Fulton County | 130228002886 | 305 | Autrey Mill Middle School | Regular School | No | Middle | 06 | 08 | 2017 | fall | pk_12_total | 753 | 147 | 110 | 0 | 401 | 1 | 62 | 747 | 727 | 1474 | 753 | 147 | 110 | 0 | 401 | 1 | 62 | 747 | 727 | 1474 | |||||||||||||||||||||||||||||||||
303050 | 303050 | GA | school | 1302280 | 660 | Fulton County | 130228002886 | 305 | Autrey Mill Middle School | Regular School | No | Middle | 06 | 08 | 2017 | spring | pk_12_total | 751 | 146 | 110 | 0 | 400 | 1 | 63 | 747 | 724 | 1471 | 751 | 146 | 110 | 0 | 400 | 1 | 63 | 747 | 724 | 1471 | |||||||||||||||||||||||||||||||||
304261 | 304261 | GA | school | 1302550 | 667 | Gwinnett County | 130255000959 | 195 | Collins Hill High School | Regular School | No | High | 09 | 12 | 2017 | spring | pk_12_total | 863 | 883 | 799 | 5 | 398 | 3 | 148 | 1591 | 1508 | 3099 | 863 | 883 | 799 | 5 | 398 | 3 | 148 | 1591 | 1508 | 3099 | |||||||||||||||||||||||||||||||||
1979445 | 1979445 | GA | school | 1302280 | 660 | Fulton County | 130228003364 | 205 | Alpharetta High School | Regular School | No | High | 09 | 12 | 2017 | fall | pk_12_total | 1017 | 436 | 221 | 5 | 396 | 1 | 76 | 1060 | 1092 | 2152 | 1017 | 436 | 221 | 5 | 396 | 1 | 76 | 1060 | 1092 | 2152 | |||||||||||||||||||||||||||||||||
303047 | 303047 | GA | school | 1302280 | 660 | Fulton County | 130228003364 | 205 | Alpharetta High School | Regular School | No | High | 09 | 12 | 2017 | spring | pk_12_total | 1010 | 418 | 222 | 6 | 395 | 1 | 73 | 1049 | 1076 | 2125 | 1010 | 418 | 222 | 6 | 395 | 1 | 73 | 1049 | 1076 | 2125 | |||||||||||||||||||||||||||||||||
301170 | 301170 | GA | school | 1301740 | 644 | DeKalb County | 130174002370 | 201 | Freedom Middle School | Regular School | No | Middle | 06 | 08 | 2017 | spring | pk_12_total | 45 | 717 | 44 | 1 | 387 | 1 | 8 | 630 | 573 | 1203 | 45 | 717 | 44 | 1 | 387 | 1 | 8 | 630 | 573 | 1203 | |||||||||||||||||||||||||||||||||
303145 | 303145 | GA | school | 1302280 | 660 | Fulton County | 130228001627 | 497 | Webb Bridge Middle School | Regular School | No | Middle | 06 | 08 | 2017 | spring | pk_12_total | 598 | 133 | 109 | 2 | 387 | 1 | 45 | 666 | 609 | 1275 | 598 | 133 | 109 | 2 | 387 | 1 | 45 | 666 | 609 | 1275 | |||||||||||||||||||||||||||||||||
1977572 | 1977572 | GA | school | 1301740 | 644 | DeKalb County | 130174002370 | 201 | Freedom Middle School | Regular School | No | Middle | 06 | 08 | 2017 | fall | pk_12_total | 27 | 703 | 42 | 1 | 386 | 1 | 7 | 616 | 551 | 1167 | 27 | 703 | 42 | 1 | 386 | 1 | 7 | 616 | 551 | 1167 | |||||||||||||||||||||||||||||||||
1979543 | 1979543 | GA | school | 1302280 | 660 | Fulton County | 130228001627 | 497 | Webb Bridge Middle School | Regular School | No | Middle | 06 | 08 | 2017 | fall | pk_12_total | 597 | 141 | 111 | 2 | 382 | 1 | 42 | 667 | 609 | 1276 | 597 | 141 | 111 | 2 | 382 | 1 | 42 | 667 | 609 | 1276 | |||||||||||||||||||||||||||||||||
302445 | 302445 | GA | school | 1302220 | 658 | Forsyth County | 130222002262 | 598 | South Forsyth Middle School | Regular School | No | Middle | 06 | 08 | 2017 | spring | pk_12_total | 775 | 38 | 59 | 0 | 369 | 1 | 36 | 676 | 602 | 1278 | 775 | 38 | 59 | 0 | 369 | 1 | 36 | 676 | 602 | 1278 | |||||||||||||||||||||||||||||||||
303142 | 303142 | GA | school | 1302280 | 660 | Fulton County | 130228002123 | 591 | Taylor Road Middle School | Regular School | No | Middle | 06 | 08 | 2017 | spring | pk_12_total | 606 | 174 | 137 | 2 | 367 | 1 | 57 | 689 | 655 | 1344 | 606 | 174 | 137 | 2 | 367 | 1 | 57 | 689 | 655 | 1344 | |||||||||||||||||||||||||||||||||
304334 | 304334 | GA | school | 1302550 | 667 | Gwinnett County | 130255002902 | 705 | Parsons Elementary School | Regular School | No | Elementary | PK | 05 | 2017 | spring | pk_12_total | 194 | 133 | 64 | 2 | 365 | 0 | 32 | 403 | 387 | 790 | 194 | 133 | 64 | 2 | 365 | 0 | 32 | 403 | 387 | 790 | |||||||||||||||||||||||||||||||||
1978845 | 1978845 | GA | school | 1302220 | 658 | Forsyth County | 130222002262 | 598 | South Forsyth Middle School | Regular School | No | Middle | 06 | 08 | 2017 | fall | pk_12_total | 774 | 36 | 57 | 0 | 364 | 1 | 36 | 671 | 597 | 1268 | 774 | 36 | 57 | 0 | 364 | 1 | 36 | 671 | 597 | 1268 | |||||||||||||||||||||||||||||||||
1979540 | 1979540 | GA | school | 1302280 | 660 | Fulton County | 130228002123 | 591 | Taylor Road Middle School | Regular School | No | Middle | 06 | 08 | 2017 | fall | pk_12_total | 606 | 173 | 134 | 2 | 364 | 1 | 57 | 684 | 653 | 1337 | 606 | 173 | 134 | 2 | 364 | 1 | 57 | 684 | 653 | 1337 | |||||||||||||||||||||||||||||||||
1980708 | 1980708 | GA | school | 1302550 | 667 | Gwinnett County | 130255002197 | 298 | Mason Elementary School | Regular School | No | Elementary | PK | 05 | 2017 | fall | pk_12_total | 150 | 241 | 119 | 4 | 358 | 1 | 52 | 483 | 442 | 925 | 150 | 241 | 119 | 4 | 358 | 1 | 52 | 483 | 442 | 925 | |||||||||||||||||||||||||||||||||
1980731 | 1980731 | GA | school | 1302550 | 667 | Gwinnett County | 130255002902 | 705 | Parsons Elementary School | Regular School | No | Elementary | PK | 05 | 2017 | fall | pk_12_total | 191 | 124 | 64 | 1 | 358 | 0 | 33 | 397 | 374 | 771 | 191 | 124 | 64 | 1 | 358 | 0 | 33 | 397 | 374 | 771 | |||||||||||||||||||||||||||||||||
304311 | 304311 | GA | school | 1302550 | 667 | Gwinnett County | 130255002197 | 298 | Mason Elementary School | Regular School | No | Elementary | PK | 05 | 2017 | spring | pk_12_total | 157 | 243 | 114 | 4 | 356 | 1 | 54 | 481 | 448 | 929 | 157 | 243 | 114 | 4 | 356 | 1 | 54 | 481 | 448 | 929 | |||||||||||||||||||||||||||||||||
1977585 | 1977585 | GA | school | 1301740 | 644 | DeKalb County | 130174000722 | 3059 | Jolly Elementary School | Regular School | No | Elementary | PK | 05 | 2017 | fall | pk_12_total | 51 | 372 | 37 | 4 | 352 | 3 | 15 | 418 | 416 | 834 | 51 | 372 | 37 | 4 | 352 | 3 | 15 | 418 | 416 | 834 | |||||||||||||||||||||||||||||||||
302414 | 302414 | GA | school | 1302220 | 658 | Forsyth County | 130222003923 | 211 | Brookwood Elementary | Regular School | No | Elementary | PK | 05 | 2017 | spring | pk_12_total | 590 | 30 | 73 | 5 | 350 | 0 | 32 | 588 | 492 | 1080 | 590 | 30 | 73 | 5 | 350 | 0 | 32 | 588 | 492 | 1080 | |||||||||||||||||||||||||||||||||
301183 | 301183 | GA | school | 1301740 | 644 | DeKalb County | 130174000722 | 3059 | Jolly Elementary School | Regular School | No | Elementary | PK | 05 | 2017 | spring | pk_12_total | 59 | 398 | 36 | 4 | 348 | 2 | 18 | 436 | 429 | 865 | 59 | 398 | 36 | 4 | 348 | 2 | 18 | 436 | 429 | 865 | |||||||||||||||||||||||||||||||||
302437 | 302437 | GA | school | 1302220 | 658 | Forsyth County | 130222003357 | 407 | Piney Grove Middle School | Regular School | No | Middle | 06 | 08 | 2017 | spring | pk_12_total | 538 | 39 | 81 | 4 | 339 | 1 | 27 | 534 | 495 | 1029 | 538 | 39 | 81 | 4 | 339 | 1 | 27 | 534 | 495 | 1029 | |||||||||||||||||||||||||||||||||
1978837 | 1978837 | GA | school | 1302220 | 658 | Forsyth County | 130222003357 | 407 | Piney Grove Middle School | Regular School | No | Middle | 06 | 08 | 2017 | fall | pk_12_total | 545 | 39 | 84 | 4 | 338 | 1 | 27 | 539 | 499 | 1038 | 545 | 39 | 84 | 4 | 338 | 1 | 27 | 539 | 499 | 1038 | |||||||||||||||||||||||||||||||||
1978814 | 1978814 | GA | school | 1302220 | 658 | Forsyth County | 130222003923 | 211 | Brookwood Elementary | Regular School | No | Elementary | PK | 05 | 2017 | fall | pk_12_total | 590 | 30 | 72 | 6 | 330 | 0 | 31 | 576 | 483 | 1059 | 590 | 30 | 72 | 6 | 330 | 0 | 31 | 576 | 483 | 1059 | |||||||||||||||||||||||||||||||||
304239 | 304239 | GA | school | 1302550 | 667 | Gwinnett County | 130255001902 | 382 | Arcado Elementary School | Regular School | No | Elementary | PK | 05 | 2017 | spring | pk_12_total | 172 | 237 | 274 | 1 | 329 | 0 | 29 | 550 | 492 | 1042 | 172 | 237 | 274 | 1 | 329 | 0 | 29 | 550 | 492 | 1042 | |||||||||||||||||||||||||||||||||
1980636 | 1980636 | GA | school | 1302550 | 667 | Gwinnett County | 130255001902 | 382 | Arcado Elementary School | Regular School | No | Elementary | PK | 05 | 2017 | fall | pk_12_total | 172 | 234 | 268 | 1 | 322 | 0 | 29 | 546 | 480 | 1026 | 172 | 234 | 268 | 1 | 322 | 0 | 29 | 546 | 480 | 1026 | |||||||||||||||||||||||||||||||||
302413 | 302413 | GA | school | 1302220 | 658 | Forsyth County | 130222004233 | 699 | Brandywine Elementary School | Regular School | No | Elementary | PK | 05 | 2017 | spring | pk_12_total | 307 | 107 | 309 | 8 | 321 | 0 | 23 | 532 | 543 | 1075 | 307 | 107 | 309 | 8 | 321 | 0 | 23 | 532 | 543 | 1075 | |||||||||||||||||||||||||||||||||
304316 | 304316 | GA | school | 1302550 | 667 | Gwinnett County | 130255003376 | 105 | Mill Creek High School | Regular School | No | High | 09 | 12 | 2017 | spring | pk_12_total | 2099 | 672 | 490 | 3 | 308 | 5 | 135 | 1801 | 1911 | 3712 | 2099 | 672 | 490 | 3 | 308 | 5 | 135 | 1801 | 1911 | 3712 | |||||||||||||||||||||||||||||||||
1978813 | 1978813 | GA | school | 1302220 | 658 | Forsyth County | 130222004233 | 699 | Brandywine Elementary School | Regular School | No | Elementary | PK | 05 | 2017 | fall | pk_12_total | 315 | 96 | 315 | 6 | 308 | 0 | 25 | 527 | 538 | 1065 | 315 | 96 | 315 | 6 | 308 | 0 | 25 | 527 | 538 | 1065 | |||||||||||||||||||||||||||||||||
1980713 | 1980713 | GA | school | 1302550 | 667 | Gwinnett County | 130255003376 | 105 | Mill Creek High School | Regular School | No | High | 09 | 12 | 2017 | fall | pk_12_total | 2134 | 689 | 486 | 4 | 305 | 3 | 138 | 1827 | 1932 | 3759 | 2134 | 689 | 486 | 4 | 305 | 3 | 138 | 1827 | 1932 | 3759 | |||||||||||||||||||||||||||||||||
299530 | 299530 | GA | school | 1301290 | 633 | Cobb County | 130129000535 | 114 | East Side Elementary School | Regular School | No | Elementary | PK | 05 | 2017 | spring | pk_12_total | 820 | 66 | 77 | 1 | 302 | 0 | 37 | 659 | 644 | 1303 | 820 | 66 | 77 | 1 | 302 | 0 | 37 | 659 | 644 | 1303 | |||||||||||||||||||||||||||||||||
1977649 | 1977649 | GA | school | 1301740 | 644 | DeKalb County | 130174000638 | 173 | Vanderlyn Elementary School | Regular School | No | Elementary | PK | 05 | 2017 | fall | pk_12_total | 333 | 23 | 32 | 0 | 297 | 1 | 20 | 388 | 318 | 706 | 333 | 23 | 32 | 0 | 297 | 1 | 20 | 388 | 318 | 706 | |||||||||||||||||||||||||||||||||
304266 | 304266 | GA | school | 1302550 | 667 | Gwinnett County | 130255001632 | 197 | Creekland Middle School | Regular School | No | Middle | 06 | 08 | 2017 | spring | pk_12_total | 514 | 627 | 628 | 4 | 290 | 2 | 106 | 1142 | 1029 | 2171 | 514 | 627 | 628 | 4 | 290 | 2 | 106 | 1142 | 1029 | 2171 | |||||||||||||||||||||||||||||||||
1975935 | 1975935 | GA | school | 1301290 | 633 | Cobb County | 130129000535 | 114 | East Side Elementary School | Regular School | No | Elementary | PK | 05 | 2017 | fall | pk_12_total | 831 | 64 | 76 | 1 | 290 | 0 | 38 | 656 | 644 | 1300 | 831 | 64 | 76 | 1 | 290 | 0 | 38 | 656 | 644 | 1300 | |||||||||||||||||||||||||||||||||
301159 | 301159 | GA | school | 1301740 | 644 | DeKalb County | 130174003914 | 214 | Dunwoody Elementary School | Regular School | No | Elementary | PK | 05 | 2017 | spring | pk_12_total | 422 | 174 | 107 | 2 | 288 | 3 | 36 | 527 | 505 | 1032 | 422 | 174 | 107 | 2 | 288 | 3 | 36 | 527 | 505 | 1032 | |||||||||||||||||||||||||||||||||
1980663 | 1980663 | GA | school | 1302550 | 667 | Gwinnett County | 130255001632 | 197 | Creekland Middle School | Regular School | No | Middle | 06 | 08 | 2017 | fall | pk_12_total | 526 | 631 | 621 | 4 | 287 | 2 | 104 | 1153 | 1022 | 2175 | 526 | 631 | 621 | 4 | 287 | 2 | 104 | 1153 | 1022 | 2175 | |||||||||||||||||||||||||||||||||
301247 | 301247 | GA | school | 1301740 | 644 | DeKalb County | 130174000638 | 173 | Vanderlyn Elementary School | Regular School | No | Elementary | PK | 05 | 2017 | spring | pk_12_total | 333 | 24 | 35 | 1 | 286 | 1 | 19 | 379 | 320 | 699 | 333 | 24 | 35 | 1 | 286 | 1 | 19 | 379 | 320 | 699 | |||||||||||||||||||||||||||||||||
1977561 | 1977561 | GA | school | 1301740 | 644 | DeKalb County | 130174003914 | 214 | Dunwoody Elementary School | Regular School | No | Elementary | PK | 05 | 2017 | fall | pk_12_total | 423 | 175 | 106 | 2 | 284 | 3 | 40 | 531 | 502 | 1033 | 423 | 175 | 106 | 2 | 284 | 3 | 40 | 531 | 502 | 1033 | |||||||||||||||||||||||||||||||||
1979504 | 1979504 | GA | school | 1302280 | 660 | Fulton County | 130228002122 | 491 | Medlock Bridge Elementary School | Regular School | No | Elementary | PK | 05 | 2017 | fall | pk_12_total | 250 | 77 | 52 | 0 | 278 | 0 | 28 | 358 | 327 | 685 | 250 | 77 | 52 | 0 | 278 | 0 | 28 | 358 | 327 | 685 | |||||||||||||||||||||||||||||||||
1986767 | 1986767 | GA | school | 1300232 | 7820120 | State Charter Schools- Georgia Cyber Academy | 130023204148 | 120 | Georgia Cyber Academy | Regular School | Yes | Other | KG | 12 | 2017 | fall | pk_12_total | 7086 | 4966 | 1091 | 46 | 277 | 22 | 831 | 6883 | 7436 | 14319 | 7086 | 4966 | 1091 | 46 | 277 | 22 | 831 | 6883 | 7436 | 14319 | |||||||||||||||||||||||||||||||||
303106 | 303106 | GA | school | 1302280 | 660 | Fulton County | 130228002122 | 491 | Medlock Bridge Elementary School | Regular School | No | Elementary | PK | 05 | 2017 | spring | pk_12_total | 254 | 72 | 49 | 0 | 275 | 0 | 28 | 358 | 320 | 678 | 254 | 72 | 49 | 0 | 275 | 0 | 28 | 358 | 320 | 678 | |||||||||||||||||||||||||||||||||
299595 | 299595 | GA | school | 1301290 | 633 | Cobb County | 130129000540 | 478 | Sope Creek Elementary School | Regular School | No | Elementary | PK | 05 | 2017 | spring | pk_12_total | 720 | 67 | 55 | 7 | 272 | 0 | 43 | 606 | 558 | 1164 | 720 | 67 | 55 | 7 | 272 | 0 | 43 | 606 | 558 | 1164 | |||||||||||||||||||||||||||||||||
310373 | 310373 | GA | school | 1300232 | 7820120 | State Charter Schools- Georgia Cyber Academy | 130023204148 | 120 | Georgia Cyber Academy | Regular School | Yes | Other | KG | 12 | 2017 | spring | pk_12_total | 6316 | 4459 | 953 | 38 | 267 | 18 | 690 | 6100 | 6641 | 12741 | 6316 | 4459 | 953 | 38 | 267 | 18 | 690 | 6100 | 6641 | 12741 | |||||||||||||||||||||||||||||||||
1980712 | 1980712 | GA | school | 1302550 | 667 | Gwinnett County | 130255001980 | 187 | Meadowcreek High School | Regular School | No | High | 09 | 12 | 2017 | fall | pk_12_total | 89 | 660 | 2193 | 6 | 266 | 3 | 43 | 1679 | 1581 | 3260 | 89 | 660 | 2193 | 6 | 266 | 3 | 43 | 1679 | 1581 | 3260 | |||||||||||||||||||||||||||||||||
304315 | 304315 | GA | school | 1302550 | 667 | Gwinnett County | 130255001980 | 187 | Meadowcreek High School | Regular School | No | High | 09 | 12 | 2017 | spring | pk_12_total | 90 | 631 | 2074 | 3 | 265 | 3 | 43 | 1593 | 1516 | 3109 | 90 | 631 | 2074 | 3 | 265 | 3 | 43 | 1593 | 1516 | 3109 | |||||||||||||||||||||||||||||||||
301244 | 301244 | GA | school | 1301740 | 644 | DeKalb County | 130174000669 | 1070 | Tucker High School | Regular School | No | High | 09 | 12 | 2017 | spring | pk_12_total | 163 | 1077 | 182 | 5 | 262 | 2 | 39 | 876 | 854 | 1730 | 163 | 1077 | 182 | 5 | 262 | 2 | 39 | 876 | 854 | 1730 |
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]);