enrollments
Data source: Big Local News · About: Big Local
947 rows where grade = "grade_9", state = "GA" and year = 2016 sorted by total_int
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 ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1962999 | 1962999 | GA | school | 1301740 | 644 | DeKalb County | 130174003559 | 1100 | International Student Center | Regular School | No | 2 | 07 | 09 | 2016 | fall | grade_9 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | |||||||||||||||||||||||||||||||||
1964913 | 1964913 | GA | school | 1302280 | 660 | Fulton County | 130228001958 | 386 | Independence High School | Alternative Education School | No | 3 | 09 | 12 | 2016 | fall | grade_9 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | |||||||||||||||||||||||||||||||||
1966067 | 1966067 | GA | school | 1302550 | 667 | Gwinnett County | 130255003627 | 708 | Oakland Meadow School | Regular School | No | 4 | PK | 12 | 2016 | fall | grade_9 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | |||||||||||||||||||||||||||||||||
1968098 | 1968098 | GA | school | 1303630 | 699 | Meriwether County | 130363003633 | 207 | Good Sheperd Therapeutic Center | Special Education School | No | 4 | 08 | 11 | 2016 | fall | grade_9 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | |||||||||||||||||||||||||||||||||
2251027 | 2251027 | GA | school | 1301740 | 644 | DeKalb County | 130174002642 | 503 | East DeKalb Special Education Center | Special Education School | No | 4 | PK | 12 | 2016 | spring | grade_9 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | |||||||||||||||||||||||||||||||||
2252936 | 2252936 | GA | school | 1302280 | 660 | Fulton County | 130228001958 | 386 | Independence High School | Alternative Education School | No | 3 | 09 | 12 | 2016 | spring | grade_9 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | |||||||||||||||||||||||||||||||||
2254089 | 2254089 | GA | school | 1302550 | 667 | Gwinnett County | 130255003627 | 708 | Oakland Meadow School | Regular School | No | 4 | PK | 12 | 2016 | spring | grade_9 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | |||||||||||||||||||||||||||||||||
2258360 | 2258360 | GA | school | 1304980 | 737 | Tift County | 130498002282 | 199 | Tift County High School | Regular School | No | 3 | 10 | 12 | 2016 | spring | grade_9 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | |||||||||||||||||||||||||||||||||
2260675 | 2260675 | GA | school | 1305310 | 792 | Valdosta City | 130531001734 | 103 | Valdosta Middle School | Regular School | No | 2 | 06 | 08 | 2016 | spring | grade_9 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | |||||||||||||||||||||||||||||||||
1972141 | 1972141 | GA | school | 1301870 | 774 | Dublin City | 130187003579 | 108 | Community Hope Center | Regular School | No | 4 | 06 | 11 | 2016 | fall | grade_9 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 2 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 2 | |||||||||||||||||||||||||||||||||
1959914 | 1959914 | GA | school | 1301020 | 625 | Savannah-Chatham County | 130102000410 | 3062 | Low Elementary School | Regular School | No | 4 | PK | 10 | 2016 | fall | grade_9 | 0 | 3 | 0 | 0 | 0 | 0 | 0 | 2 | 1 | 3 | 0 | 3 | 0 | 0 | 0 | 0 | 0 | 2 | 1 | 3 | |||||||||||||||||||||||||||||||||
1963002 | 1963002 | GA | school | 1301740 | 644 | DeKalb County | 130174003868 | 510 | Margaret Harris Comprehensive School | Regular School | No | 4 | PK | 12 | 2016 | fall | grade_9 | 0 | 2 | 1 | 0 | 0 | 0 | 0 | 2 | 1 | 3 | 0 | 2 | 1 | 0 | 0 | 0 | 0 | 2 | 1 | 3 | |||||||||||||||||||||||||||||||||
2247942 | 2247942 | GA | school | 1301020 | 625 | Savannah-Chatham County | 130102000410 | 3062 | Low Elementary School | Regular School | No | 4 | PK | 10 | 2016 | spring | grade_9 | 0 | 3 | 0 | 0 | 0 | 0 | 0 | 2 | 1 | 3 | 0 | 3 | 0 | 0 | 0 | 0 | 0 | 2 | 1 | 3 | |||||||||||||||||||||||||||||||||
2251030 | 2251030 | GA | school | 1301740 | 644 | DeKalb County | 130174003868 | 510 | Margaret Harris Comprehensive School | Regular School | No | 4 | PK | 12 | 2016 | spring | grade_9 | 0 | 2 | 1 | 0 | 0 | 0 | 0 | 2 | 1 | 3 | 0 | 2 | 1 | 0 | 0 | 0 | 0 | 2 | 1 | 3 | |||||||||||||||||||||||||||||||||
2258625 | 2258625 | GA | school | 1305250 | 744 | Union County | 130525001721 | 3050 | Woody Gap High/Elementary School | Regular School | No | 4 | KG | 12 | 2016 | spring | grade_9 | 2 | 0 | 0 | 0 | 1 | 0 | 0 | 2 | 1 | 3 | 2 | 0 | 0 | 0 | 1 | 0 | 0 | 2 | 1 | 3 | |||||||||||||||||||||||||||||||||
1972271 | 1972271 | GA | school | 1303510 | 781 | Marietta City | 130351003700 | 207 | George W. Hartmann Center | Alternative Education School | No | 4 | 08 | 11 | 2016 | fall | grade_9 | 1 | 2 | 1 | 0 | 0 | 0 | 0 | 4 | 0 | 4 | 1 | 2 | 1 | 0 | 0 | 0 | 0 | 4 | 0 | 4 | |||||||||||||||||||||||||||||||||
2258055 | 2258055 | GA | school | 1302520 | 726 | Griffin-Spalding County | 130252003588 | 208 | AZ Kelsey Academy | Regular School | No | 3 | 09 | 12 | 2016 | spring | grade_9 | 1 | 3 | 0 | 0 | 0 | 0 | 0 | 1 | 3 | 4 | 1 | 3 | 0 | 0 | 0 | 0 | 0 | 1 | 3 | 4 | |||||||||||||||||||||||||||||||||
2260290 | 2260290 | GA | school | 1303510 | 781 | Marietta City | 130351003700 | 207 | George W. Hartmann Center | Alternative Education School | No | 4 | 08 | 11 | 2016 | spring | grade_9 | 2 | 1 | 1 | 0 | 0 | 0 | 0 | 4 | 0 | 4 | 2 | 1 | 1 | 0 | 0 | 0 | 0 | 4 | 0 | 4 | |||||||||||||||||||||||||||||||||
1958861 | 1958861 | GA | school | 1300420 | 611 | Bibb County | 130042003676 | 407 | LakeBridge Behavioral Health System | Special Education School | No | 4 | 01 | 12 | 2016 | fall | grade_9 | 1 | 4 | 0 | 0 | 0 | 0 | 0 | 5 | 0 | 5 | 1 | 4 | 0 | 0 | 0 | 0 | 0 | 5 | 0 | 5 | |||||||||||||||||||||||||||||||||
1970601 | 1970601 | GA | school | 1305250 | 744 | Union County | 130525001721 | 3050 | Woody Gap High/Elementary School | Regular School | No | 4 | KG | 12 | 2016 | fall | grade_9 | 4 | 0 | 0 | 0 | 1 | 0 | 0 | 3 | 2 | 5 | 4 | 0 | 0 | 0 | 1 | 0 | 0 | 3 | 2 | 5 | |||||||||||||||||||||||||||||||||
2251041 | 2251041 | GA | school | 1301740 | 644 | DeKalb County | 130174003613 | 707 | UHS of Laurel Heights | Special Education School | No | 4 | 01 | 12 | 2016 | spring | grade_9 | 2 | 2 | 1 | 0 | 0 | 0 | 0 | 5 | 0 | 5 | 2 | 2 | 1 | 0 | 0 | 0 | 0 | 5 | 0 | 5 | |||||||||||||||||||||||||||||||||
1964911 | 1964911 | GA | school | 1302280 | 660 | Fulton County | 130228003651 | 307 | Georgia Baptist Children's Home and Family Ministries | Special Education School | No | 4 | 05 | 10 | 2016 | fall | grade_9 | 3 | 3 | 0 | 0 | 0 | 0 | 0 | 1 | 5 | 6 | 3 | 3 | 0 | 0 | 0 | 0 | 0 | 1 | 5 | 6 | |||||||||||||||||||||||||||||||||
1970030 | 1970030 | GA | school | 1302520 | 726 | Griffin-Spalding County | 130252003588 | 208 | AZ Kelsey Academy | Regular School | No | 3 | 09 | 12 | 2016 | fall | grade_9 | 4 | 1 | 0 | 0 | 0 | 0 | 1 | 4 | 2 | 6 | 4 | 1 | 0 | 0 | 0 | 0 | 1 | 4 | 2 | 6 | |||||||||||||||||||||||||||||||||
2251354 | 2251354 | GA | school | 1301770 | 645 | Dodge County | 130177004186 | 292 | DAC (Dodge County Achievement Center) | Regular School | No | 3 | 08 | 12 | 2016 | spring | grade_9 | 2 | 4 | 0 | 0 | 0 | 0 | 0 | 4 | 2 | 6 | 2 | 4 | 0 | 0 | 0 | 0 | 0 | 4 | 2 | 6 | |||||||||||||||||||||||||||||||||
1959919 | 1959919 | GA | school | 1301020 | 625 | Savannah-Chatham County | 130102003610 | 107 | UHS of Savannah Coastal Harbor Treatment Center | Regular School | No | 4 | 03 | 12 | 2016 | fall | grade_9 | 2 | 5 | 0 | 0 | 0 | 0 | 0 | 6 | 1 | 7 | 2 | 5 | 0 | 0 | 0 | 0 | 0 | 6 | 1 | 7 | |||||||||||||||||||||||||||||||||
1963013 | 1963013 | GA | school | 1301740 | 644 | DeKalb County | 130174003613 | 707 | UHS of Laurel Heights | Special Education School | No | 4 | 01 | 12 | 2016 | fall | grade_9 | 2 | 3 | 2 | 0 | 0 | 0 | 0 | 5 | 2 | 7 | 2 | 3 | 2 | 0 | 0 | 0 | 0 | 5 | 2 | 7 | |||||||||||||||||||||||||||||||||
2246889 | 2246889 | GA | school | 1300420 | 611 | Bibb County | 130042003676 | 407 | LakeBridge Behavioral Health System | Special Education School | No | 4 | 01 | 12 | 2016 | spring | grade_9 | 4 | 3 | 0 | 0 | 0 | 0 | 0 | 4 | 3 | 7 | 4 | 3 | 0 | 0 | 0 | 0 | 0 | 4 | 3 | 7 | |||||||||||||||||||||||||||||||||
2258578 | 2258578 | GA | school | 1305190 | 742 | Turner County | 130519001714 | 1050 | Turner County Specialty School | Alternative Education School | No | 4 | 06 | 12 | 2016 | spring | grade_9 | 1 | 6 | 0 | 0 | 0 | 0 | 0 | 6 | 1 | 7 | 1 | 6 | 0 | 0 | 0 | 0 | 0 | 6 | 1 | 7 | |||||||||||||||||||||||||||||||||
1963325 | 1963325 | GA | school | 1301770 | 645 | Dodge County | 130177004186 | 292 | DAC (Dodge County Achievement Center) | Regular School | No | 3 | 08 | 12 | 2016 | fall | grade_9 | 4 | 4 | 0 | 0 | 0 | 0 | 0 | 3 | 5 | 8 | 4 | 4 | 0 | 0 | 0 | 0 | 0 | 3 | 5 | 8 | |||||||||||||||||||||||||||||||||
1972382 | 1972382 | GA | school | 1300226 | 7820612 | State Charter Schools- Ivy Preparatory Academy, Inc | 130022604023 | 612 | Ivy Preparatory Academy, Inc | Regular School | No | 4 | KG | 10 | 2016 | fall | grade_9 | 0 | 8 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 8 | 0 | 8 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 8 | |||||||||||||||||||||||||||||||||
2248545 | 2248545 | GA | school | 1301200 | 630 | Clay County | 130120004125 | 114 | Clay County Academies | Regular School | No | 4 | 09 | 10 | 2016 | spring | grade_9 | 0 | 8 | 0 | 0 | 0 | 0 | 0 | 2 | 6 | 8 | 0 | 8 | 0 | 0 | 0 | 0 | 0 | 2 | 6 | 8 | |||||||||||||||||||||||||||||||||
2252934 | 2252934 | GA | school | 1302280 | 660 | Fulton County | 130228003651 | 307 | Georgia Baptist Children's Home and Family Ministries | Special Education School | No | 4 | 05 | 10 | 2016 | spring | grade_9 | 5 | 2 | 1 | 0 | 0 | 0 | 0 | 3 | 5 | 8 | 5 | 2 | 1 | 0 | 0 | 0 | 0 | 3 | 5 | 8 | |||||||||||||||||||||||||||||||||
1960516 | 1960516 | GA | school | 1301200 | 630 | Clay County | 130120004125 | 114 | Clay County Academies | Regular School | No | 4 | 09 | 10 | 2016 | fall | grade_9 | 0 | 9 | 0 | 0 | 0 | 0 | 0 | 3 | 6 | 9 | 0 | 9 | 0 | 0 | 0 | 0 | 0 | 3 | 6 | 9 | |||||||||||||||||||||||||||||||||
1964361 | 1964361 | GA | school | 1302220 | 658 | Forsyth County | 130222003995 | 219 | Forsyth Virtual Academy | Regular School | No | 4 | 06 | 12 | 2016 | fall | grade_9 | 8 | 0 | 0 | 0 | 1 | 0 | 0 | 6 | 3 | 9 | 8 | 0 | 0 | 0 | 1 | 0 | 0 | 6 | 3 | 9 | |||||||||||||||||||||||||||||||||
1969658 | 1969658 | GA | school | 1304380 | 721 | Richmond County | 130438003486 | 107 | Lighthouse Care Center of Augusta | Special Education School | No | 4 | 05 | 12 | 2016 | fall | grade_9 | 3 | 5 | 1 | 0 | 0 | 0 | 0 | 3 | 6 | 9 | 3 | 5 | 1 | 0 | 0 | 0 | 0 | 3 | 6 | 9 | |||||||||||||||||||||||||||||||||
1970169 | 1970169 | GA | school | 1304680 | 731 | Taliaferro County | 130468002514 | 102 | Taliaferro County School | Regular School | No | 4 | PK | 12 | 2016 | fall | grade_9 | 2 | 6 | 0 | 0 | 1 | 0 | 0 | 5 | 4 | 9 | 2 | 6 | 0 | 0 | 1 | 0 | 0 | 5 | 4 | 9 | |||||||||||||||||||||||||||||||||
2247947 | 2247947 | GA | school | 1301020 | 625 | Savannah-Chatham County | 130102003610 | 107 | UHS of Savannah Coastal Harbor Treatment Center | Regular School | No | 4 | 03 | 12 | 2016 | spring | grade_9 | 5 | 3 | 0 | 0 | 0 | 0 | 1 | 5 | 4 | 9 | 5 | 3 | 0 | 0 | 0 | 0 | 1 | 5 | 4 | 9 | |||||||||||||||||||||||||||||||||
2257683 | 2257683 | GA | school | 1304380 | 721 | Richmond County | 130438003486 | 107 | Lighthouse Care Center of Augusta | Special Education School | No | 4 | 05 | 12 | 2016 | spring | grade_9 | 5 | 3 | 0 | 1 | 0 | 0 | 0 | 3 | 6 | 9 | 5 | 3 | 0 | 1 | 0 | 0 | 0 | 3 | 6 | 9 | |||||||||||||||||||||||||||||||||
2260210 | 2260210 | GA | school | 1302310 | 776 | Gainesville City | 130231003963 | 210 | The Academy at Woods Mill | Regular School | No | 3 | 09 | 12 | 2016 | spring | grade_9 | 1 | 1 | 7 | 0 | 0 | 0 | 0 | 4 | 5 | 9 | 1 | 1 | 7 | 0 | 0 | 0 | 0 | 4 | 5 | 9 | |||||||||||||||||||||||||||||||||
1958971 | 1958971 | GA | school | 1300440 | 612 | Bleckley County | 130044004162 | 115 | Bleckley County Success Academy | Regular School | No | 4 | 06 | 12 | 2016 | fall | grade_9 | 6 | 3 | 1 | 0 | 0 | 0 | 0 | 6 | 4 | 10 | 6 | 3 | 1 | 0 | 0 | 0 | 0 | 6 | 4 | 10 | |||||||||||||||||||||||||||||||||
1962374 | 1962374 | GA | school | 1301710 | 643 | Decatur County | 130171004170 | 116 | New Beginning Learning Center | Regular School | No | 4 | 06 | 12 | 2016 | fall | grade_9 | 3 | 7 | 0 | 0 | 0 | 0 | 0 | 5 | 5 | 10 | 3 | 7 | 0 | 0 | 0 | 0 | 0 | 5 | 5 | 10 | |||||||||||||||||||||||||||||||||
1965261 | 1965261 | GA | school | 1302400 | 663 | Glynn County | 130240003697 | 107 | Morningstar Treatment Services, Inc. Youth Estate | Special Education School | No | 4 | 05 | 12 | 2016 | fall | grade_9 | 4 | 5 | 1 | 0 | 0 | 0 | 0 | 5 | 5 | 10 | 4 | 5 | 1 | 0 | 0 | 0 | 0 | 5 | 5 | 10 | |||||||||||||||||||||||||||||||||
2251888 | 2251888 | GA | school | 1302010 | 652 | Elbert County | 130201003926 | 112 | Elberton Education Center | Regular School | No | 3 | 09 | 12 | 2016 | spring | grade_9 | 6 | 3 | 1 | 0 | 0 | 0 | 0 | 8 | 2 | 10 | 6 | 3 | 1 | 0 | 0 | 0 | 0 | 8 | 2 | 10 | |||||||||||||||||||||||||||||||||
2258194 | 2258194 | GA | school | 1304680 | 731 | Taliaferro County | 130468002514 | 102 | Taliaferro County School | Regular School | No | 4 | PK | 12 | 2016 | spring | grade_9 | 2 | 7 | 0 | 0 | 1 | 0 | 0 | 5 | 5 | 10 | 2 | 7 | 0 | 0 | 1 | 0 | 0 | 5 | 5 | 10 | |||||||||||||||||||||||||||||||||
1960098 | 1960098 | GA | school | 1301080 | 627 | Chattooga County | 130108003571 | 111 | Chattooga Academy | Alternative Education School | No | 4 | 01 | 12 | 2016 | fall | grade_9 | 8 | 0 | 2 | 0 | 0 | 0 | 1 | 6 | 5 | 11 | 8 | 0 | 2 | 0 | 0 | 0 | 1 | 6 | 5 | 11 | |||||||||||||||||||||||||||||||||
1961797 | 1961797 | GA | school | 1301380 | 635 | Colquitt County | 130138004052 | 112 | Colquitt County Achievement Center | Regular School | No | 3 | 08 | 12 | 2016 | fall | grade_9 | 4 | 6 | 1 | 0 | 0 | 0 | 0 | 6 | 5 | 11 | 4 | 6 | 1 | 0 | 0 | 0 | 0 | 6 | 5 | 11 | |||||||||||||||||||||||||||||||||
1972370 | 1972370 | GA | school | 1300229 | 7820512 | State Charter Schools- Ivy Preparatory Young Men's Leadership Academy, Inc. | 130022904027 | 512 | Ivy Preparatory Young Men's Leadership Academy, Inc. | Regular School | Yes | 4 | KG | 10 | 2016 | fall | grade_9 | 0 | 11 | 0 | 0 | 0 | 0 | 0 | 11 | 0 | 11 | 0 | 11 | 0 | 0 | 0 | 0 | 0 | 11 | 0 | 11 | |||||||||||||||||||||||||||||||||
2246999 | 2246999 | GA | school | 1300440 | 612 | Bleckley County | 130044004162 | 115 | Bleckley County Success Academy | Regular School | No | 4 | 06 | 12 | 2016 | spring | grade_9 | 5 | 6 | 0 | 0 | 0 | 0 | 0 | 8 | 3 | 11 | 5 | 6 | 0 | 0 | 0 | 0 | 0 | 8 | 3 | 11 | |||||||||||||||||||||||||||||||||
2251024 | 2251024 | GA | school | 1301740 | 644 | DeKalb County | 130174004035 | 112 | Destiny Achievers Academy of Excellence | Regular School | No | 3 | 09 | 12 | 2016 | spring | grade_9 | 0 | 11 | 0 | 0 | 0 | 0 | 0 | 5 | 6 | 11 | 0 | 11 | 0 | 0 | 0 | 0 | 0 | 5 | 6 | 11 | |||||||||||||||||||||||||||||||||
2252384 | 2252384 | GA | school | 1302220 | 658 | Forsyth County | 130222003995 | 219 | Forsyth Virtual Academy | Regular School | No | 4 | 06 | 12 | 2016 | spring | grade_9 | 9 | 0 | 1 | 0 | 1 | 0 | 0 | 5 | 6 | 11 | 9 | 0 | 1 | 0 | 1 | 0 | 0 | 5 | 6 | 11 | |||||||||||||||||||||||||||||||||
1972191 | 1972191 | GA | school | 1302310 | 776 | Gainesville City | 130231003963 | 210 | The Academy at Woods Mill | Regular School | No | 3 | 09 | 12 | 2016 | fall | grade_9 | 2 | 2 | 8 | 0 | 0 | 0 | 0 | 8 | 4 | 12 | 2 | 2 | 8 | 0 | 0 | 0 | 0 | 8 | 4 | 12 | |||||||||||||||||||||||||||||||||
2249825 | 2249825 | GA | school | 1301380 | 635 | Colquitt County | 130138004052 | 112 | Colquitt County Achievement Center | Regular School | No | 3 | 08 | 12 | 2016 | spring | grade_9 | 3 | 5 | 4 | 0 | 0 | 0 | 0 | 7 | 5 | 12 | 3 | 5 | 4 | 0 | 0 | 0 | 0 | 7 | 5 | 12 | |||||||||||||||||||||||||||||||||
2254451 | 2254451 | GA | school | 1302580 | 668 | Habersham County | 130258004144 | 114 | Habersham Success Academy | Regular School | No | 4 | 06 | 12 | 2016 | spring | grade_9 | 10 | 1 | 0 | 1 | 0 | 0 | 0 | 8 | 4 | 12 | 10 | 1 | 0 | 1 | 0 | 0 | 0 | 8 | 4 | 12 | |||||||||||||||||||||||||||||||||
1963865 | 1963865 | GA | school | 1302010 | 652 | Elbert County | 130201003926 | 112 | Elberton Education Center | Regular School | No | 3 | 09 | 12 | 2016 | fall | grade_9 | 5 | 7 | 0 | 0 | 0 | 0 | 1 | 9 | 4 | 13 | 5 | 7 | 0 | 0 | 0 | 0 | 1 | 9 | 4 | 13 | |||||||||||||||||||||||||||||||||
1969277 | 1969277 | GA | school | 1304200 | 715 | Polk County | 130420003614 | 207 | Harpst Academy | Special Education School | No | 4 | 05 | 11 | 2016 | fall | grade_9 | 5 | 4 | 3 | 0 | 0 | 0 | 1 | 7 | 6 | 13 | 5 | 4 | 3 | 0 | 0 | 0 | 1 | 7 | 6 | 13 | |||||||||||||||||||||||||||||||||
1971135 | 1971135 | GA | school | 1305700 | 755 | Whitfield County | 130570001073 | 212 | Phoenix High School | Regular School | No | 3 | 09 | 12 | 2016 | fall | grade_9 | 12 | 0 | 1 | 0 | 0 | 0 | 0 | 6 | 7 | 13 | 12 | 0 | 1 | 0 | 0 | 0 | 0 | 6 | 7 | 13 | |||||||||||||||||||||||||||||||||
2249826 | 2249826 | GA | school | 1301380 | 635 | Colquitt County | 130138000591 | 1554 | Colquitt County High School | Regular School | No | 3 | 09 | 12 | 2016 | spring | grade_9 | 4 | 4 | 5 | 0 | 0 | 0 | 0 | 9 | 4 | 13 | 4 | 4 | 5 | 0 | 0 | 0 | 0 | 9 | 4 | 13 | |||||||||||||||||||||||||||||||||
2258516 | 2258516 | GA | school | 1300001 | 741 | Troup County | 130000103620 | 207 | Ault Academy | Special Education School | No | 3 | 07 | 12 | 2016 | spring | grade_9 | 8 | 5 | 0 | 0 | 0 | 0 | 0 | 13 | 0 | 13 | 8 | 5 | 0 | 0 | 0 | 0 | 0 | 13 | 0 | 13 | |||||||||||||||||||||||||||||||||
1961705 | 1961705 | GA | school | 1301350 | 634 | Coffee County | 130135000581 | 195 | Coffee County High School | Regular School | No | 3 | 09 | 12 | 2016 | fall | grade_9 | 4 | 10 | 0 | 0 | 0 | 0 | 0 | 9 | 5 | 14 | 4 | 10 | 0 | 0 | 0 | 0 | 0 | 9 | 5 | 14 | |||||||||||||||||||||||||||||||||
1961798 | 1961798 | GA | school | 1301380 | 635 | Colquitt County | 130138000591 | 1554 | Colquitt County High School | Regular School | No | 3 | 09 | 12 | 2016 | fall | grade_9 | 5 | 4 | 5 | 0 | 0 | 0 | 0 | 9 | 5 | 14 | 5 | 4 | 5 | 0 | 0 | 0 | 0 | 9 | 5 | 14 | |||||||||||||||||||||||||||||||||
1970554 | 1970554 | GA | school | 1305190 | 742 | Turner County | 130519001714 | 1050 | Turner County Specialty School | Alternative Education School | No | 4 | 06 | 12 | 2016 | fall | grade_9 | 2 | 12 | 0 | 0 | 0 | 0 | 0 | 10 | 4 | 14 | 2 | 12 | 0 | 0 | 0 | 0 | 0 | 10 | 4 | 14 | |||||||||||||||||||||||||||||||||
2248126 | 2248126 | GA | school | 1301080 | 627 | Chattooga County | 130108003571 | 111 | Chattooga Academy | Alternative Education School | No | 4 | 01 | 12 | 2016 | spring | grade_9 | 11 | 1 | 1 | 0 | 0 | 0 | 1 | 9 | 5 | 14 | 11 | 1 | 1 | 0 | 0 | 0 | 1 | 9 | 5 | 14 | |||||||||||||||||||||||||||||||||
2249733 | 2249733 | GA | school | 1301350 | 634 | Coffee County | 130135000581 | 195 | Coffee County High School | Regular School | No | 3 | 09 | 12 | 2016 | spring | grade_9 | 4 | 10 | 0 | 0 | 0 | 0 | 0 | 9 | 5 | 14 | 4 | 10 | 0 | 0 | 0 | 0 | 0 | 9 | 5 | 14 | |||||||||||||||||||||||||||||||||
2259159 | 2259159 | GA | school | 1305700 | 755 | Whitfield County | 130570001073 | 212 | Phoenix High School | Regular School | No | 3 | 09 | 12 | 2016 | spring | grade_9 | 12 | 0 | 3 | 0 | 0 | 0 | 0 | 10 | 5 | 15 | 12 | 0 | 3 | 0 | 0 | 0 | 0 | 10 | 5 | 15 | |||||||||||||||||||||||||||||||||
1962996 | 1962996 | GA | school | 1301740 | 644 | DeKalb County | 130174004035 | 112 | Destiny Achievers Academy of Excellence | Regular School | No | 3 | 09 | 12 | 2016 | fall | grade_9 | 0 | 16 | 0 | 0 | 0 | 0 | 0 | 8 | 8 | 16 | 0 | 16 | 0 | 0 | 0 | 0 | 0 | 8 | 8 | 16 | |||||||||||||||||||||||||||||||||
1966429 | 1966429 | GA | school | 1302580 | 668 | Habersham County | 130258004144 | 114 | Habersham Success Academy | Regular School | No | 4 | 06 | 12 | 2016 | fall | grade_9 | 12 | 0 | 3 | 1 | 0 | 0 | 0 | 8 | 8 | 16 | 12 | 0 | 3 | 1 | 0 | 0 | 0 | 8 | 8 | 16 | |||||||||||||||||||||||||||||||||
1970492 | 1970492 | GA | school | 1300001 | 741 | Troup County | 130000103620 | 207 | Ault Academy | Special Education School | No | 3 | 07 | 12 | 2016 | fall | grade_9 | 7 | 7 | 2 | 0 | 0 | 0 | 0 | 16 | 0 | 16 | 7 | 7 | 2 | 0 | 0 | 0 | 0 | 16 | 0 | 16 | |||||||||||||||||||||||||||||||||
1972143 | 1972143 | GA | school | 1301870 | 774 | Dublin City | 130187004050 | 412 | Moore Street Facility | Regular School | No | 3 | 07 | 12 | 2016 | fall | grade_9 | 0 | 16 | 0 | 0 | 0 | 0 | 0 | 10 | 6 | 16 | 0 | 16 | 0 | 0 | 0 | 0 | 0 | 10 | 6 | 16 | |||||||||||||||||||||||||||||||||
2253283 | 2253283 | GA | school | 1302400 | 663 | Glynn County | 130240003697 | 107 | Morningstar Treatment Services, Inc. Youth Estate | Special Education School | No | 4 | 05 | 12 | 2016 | spring | grade_9 | 7 | 8 | 1 | 0 | 0 | 0 | 0 | 10 | 6 | 16 | 7 | 8 | 1 | 0 | 0 | 0 | 0 | 10 | 6 | 16 | |||||||||||||||||||||||||||||||||
2258156 | 2258156 | GA | school | 1304620 | 729 | Sumter County | 130462000001 | 105 | Americus Sumter High School (Old Americus-Sumter HS S) | Regular School | No | 3 | 09 | 12 | 2016 | spring | grade_9 | 1 | 10 | 4 | 0 | 0 | 0 | 1 | 11 | 5 | 16 | 1 | 10 | 4 | 0 | 0 | 0 | 1 | 11 | 5 | 16 | |||||||||||||||||||||||||||||||||
1972422 | 1972422 | GA | school | 1300005 | 7830103 | State Charter Schools II- Statesboro STEAM Academy | 130000502626 | 103 | Statesboro STEAM Academy | Regular School | Yes | 4 | 06 | 12 | 2016 | fall | grade_9 | 13 | 4 | 0 | 0 | 0 | 0 | 0 | 10 | 7 | 17 | 13 | 4 | 0 | 0 | 0 | 0 | 0 | 10 | 7 | 17 | |||||||||||||||||||||||||||||||||
1972430 | 1972430 | GA | school | 1300215 | 7830110 | State Charter Schools II- Ivy Preparatory Academy at Gwinnett | 130021503748 | 110 | Ivy Preparatory Academy at Gwinnett | Regular School | Yes | 4 | 06 | 12 | 2016 | fall | grade_9 | 0 | 13 | 3 | 0 | 0 | 0 | 1 | 0 | 17 | 17 | 0 | 13 | 3 | 0 | 0 | 0 | 1 | 0 | 17 | 17 | |||||||||||||||||||||||||||||||||
2258255 | 2258255 | GA | school | 1304800 | 733 | Taylor County | 130480003673 | 107 | Georgia Center | Special Education School | No | 4 | 05 | 12 | 2016 | spring | grade_9 | 9 | 6 | 2 | 0 | 0 | 0 | 0 | 10 | 7 | 17 | 9 | 6 | 2 | 0 | 0 | 0 | 0 | 10 | 7 | 17 | |||||||||||||||||||||||||||||||||
1960457 | 1960457 | GA | school | 1301170 | 629 | Clarke County | 130117002831 | 104 | Classic City High School | Regular School | No | 3 | 09 | 12 | 2016 | fall | grade_9 | 1 | 14 | 3 | 0 | 0 | 0 | 0 | 9 | 9 | 18 | 1 | 14 | 3 | 0 | 0 | 0 | 0 | 9 | 9 | 18 | |||||||||||||||||||||||||||||||||
1971677 | 1971677 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012003660 | 207 | Hillside Conant School | Regular School | No | 4 | 02 | 11 | 2016 | fall | grade_9 | 15 | 3 | 0 | 0 | 0 | 0 | 0 | 8 | 10 | 18 | 15 | 3 | 0 | 0 | 0 | 0 | 0 | 8 | 10 | 18 | |||||||||||||||||||||||||||||||||
2260438 | 2260438 | GA | school | 1300005 | 7830103 | State Charter Schools II- Statesboro STEAM Academy | 130000502626 | 103 | Statesboro STEAM Academy | Regular School | Yes | 4 | 06 | 12 | 2016 | spring | grade_9 | 14 | 3 | 0 | 0 | 1 | 0 | 0 | 10 | 8 | 18 | 14 | 3 | 0 | 0 | 1 | 0 | 0 | 10 | 8 | 18 | |||||||||||||||||||||||||||||||||
1958668 | 1958668 | GA | school | 1300390 | 610 | Berrien County | 130039003523 | 106 | Berrien Academy Performance Learning Center | Regular School | Yes | 3 | 09 | 12 | 2016 | fall | grade_9 | 18 | 0 | 1 | 0 | 0 | 0 | 0 | 12 | 7 | 19 | 18 | 0 | 1 | 0 | 0 | 0 | 0 | 12 | 7 | 19 | |||||||||||||||||||||||||||||||||
1970232 | 1970232 | GA | school | 1304800 | 733 | Taylor County | 130480003673 | 107 | Georgia Center | Special Education School | No | 4 | 05 | 12 | 2016 | fall | grade_9 | 8 | 9 | 0 | 0 | 0 | 0 | 2 | 14 | 5 | 19 | 8 | 9 | 0 | 0 | 0 | 0 | 2 | 14 | 5 | 19 | |||||||||||||||||||||||||||||||||
2252939 | 2252939 | GA | school | 1302280 | 660 | Fulton County | 130228002037 | 383 | McClarin High School | Alternative Education School | No | 3 | 09 | 12 | 2016 | spring | grade_9 | 0 | 16 | 3 | 0 | 0 | 0 | 0 | 12 | 7 | 19 | 0 | 16 | 3 | 0 | 0 | 0 | 0 | 12 | 7 | 19 | |||||||||||||||||||||||||||||||||
2259701 | 2259701 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012003660 | 207 | Hillside Conant School | Regular School | No | 4 | 02 | 11 | 2016 | spring | grade_9 | 15 | 4 | 0 | 0 | 0 | 0 | 0 | 8 | 11 | 19 | 15 | 4 | 0 | 0 | 0 | 0 | 0 | 8 | 11 | 19 | |||||||||||||||||||||||||||||||||
2257303 | 2257303 | GA | school | 1304200 | 715 | Polk County | 130420003614 | 207 | Harpst Academy | Special Education School | No | 4 | 05 | 11 | 2016 | spring | grade_9 | 11 | 4 | 4 | 0 | 0 | 0 | 1 | 13 | 7 | 20 | 11 | 4 | 4 | 0 | 0 | 0 | 1 | 13 | 7 | 20 | |||||||||||||||||||||||||||||||||
1959472 | 1959472 | GA | school | 1300840 | 622 | Carroll County | 130084003483 | 112 | KidsPeace | Regular School | No | 3 | 07 | 12 | 2016 | fall | grade_9 | 10 | 4 | 6 | 0 | 0 | 0 | 1 | 16 | 5 | 21 | 10 | 4 | 6 | 0 | 0 | 0 | 1 | 16 | 5 | 21 | |||||||||||||||||||||||||||||||||
2254092 | 2254092 | GA | school | 1302550 | 667 | Gwinnett County | 130255002039 | 189 | Phoenix High School | Alternative Education School | No | 3 | 09 | 12 | 2016 | spring | grade_9 | 2 | 6 | 11 | 0 | 1 | 0 | 1 | 12 | 9 | 21 | 2 | 6 | 11 | 0 | 1 | 0 | 1 | 12 | 9 | 21 | |||||||||||||||||||||||||||||||||
1970131 | 1970131 | GA | school | 1304620 | 729 | Sumter County | 130462000001 | 105 | Americus Sumter High School (Old Americus-Sumter HS S) | Regular School | No | 3 | 09 | 12 | 2016 | fall | grade_9 | 2 | 15 | 4 | 0 | 0 | 0 | 1 | 16 | 6 | 22 | 2 | 15 | 4 | 0 | 0 | 0 | 1 | 16 | 6 | 22 | |||||||||||||||||||||||||||||||||
2246697 | 2246697 | GA | school | 1300390 | 610 | Berrien County | 130039003523 | 106 | Berrien Academy Performance Learning Center | Regular School | Yes | 3 | 09 | 12 | 2016 | spring | grade_9 | 22 | 0 | 1 | 0 | 0 | 0 | 0 | 12 | 11 | 23 | 22 | 0 | 1 | 0 | 0 | 0 | 0 | 12 | 11 | 23 | |||||||||||||||||||||||||||||||||
2250401 | 2250401 | GA | school | 1301710 | 643 | Decatur County | 130171004170 | 116 | New Beginning Learning Center | Regular School | No | 4 | 06 | 12 | 2016 | spring | grade_9 | 4 | 20 | 0 | 0 | 0 | 0 | 0 | 14 | 10 | 24 | 4 | 20 | 0 | 0 | 0 | 0 | 0 | 14 | 10 | 24 | |||||||||||||||||||||||||||||||||
1963663 | 1963663 | GA | school | 1301860 | 648 | Douglas County | 130186003689 | 507 | Youth Villages at Inner Harbour | Special Education School | No | 4 | 01 | 12 | 2016 | fall | grade_9 | 8 | 13 | 4 | 0 | 0 | 0 | 0 | 17 | 8 | 25 | 8 | 13 | 4 | 0 | 0 | 0 | 0 | 17 | 8 | 25 | |||||||||||||||||||||||||||||||||
1971673 | 1971673 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012000120 | 2664 | Crim High School | Alternative Education School | No | 3 | 08 | 12 | 2016 | fall | grade_9 | 0 | 25 | 0 | 0 | 0 | 0 | 0 | 12 | 13 | 25 | 0 | 25 | 0 | 0 | 0 | 0 | 0 | 12 | 13 | 25 | |||||||||||||||||||||||||||||||||
1966427 | 1966427 | GA | school | 1302580 | 668 | Habersham County | 130258001145 | 2052 | Habersham Central High School | Regular School | No | 3 | 09 | 12 | 2016 | fall | grade_9 | 13 | 1 | 12 | 0 | 0 | 0 | 0 | 16 | 10 | 26 | 13 | 1 | 12 | 0 | 0 | 0 | 0 | 16 | 10 | 26 | |||||||||||||||||||||||||||||||||
2260163 | 2260163 | GA | school | 1301870 | 774 | Dublin City | 130187004050 | 412 | Moore Street Facility | Regular School | No | 3 | 07 | 12 | 2016 | spring | grade_9 | 0 | 25 | 0 | 0 | 0 | 0 | 1 | 17 | 9 | 26 | 0 | 25 | 0 | 0 | 0 | 0 | 1 | 17 | 9 | 26 | |||||||||||||||||||||||||||||||||
2246388 | 2246388 | GA | school | 1300180 | 604 | Baker County | 130018001867 | 105 | Baker County K12 School | Regular School | No | 4 | PK | 12 | 2016 | spring | grade_9 | 5 | 18 | 4 | 1 | 0 | 0 | 0 | 10 | 18 | 28 | 5 | 18 | 4 | 1 | 0 | 0 | 0 | 10 | 18 | 28 | |||||||||||||||||||||||||||||||||
2259697 | 2259697 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012000120 | 2664 | Crim High School | Alternative Education School | No | 3 | 08 | 12 | 2016 | spring | grade_9 | 0 | 27 | 1 | 0 | 0 | 0 | 0 | 19 | 9 | 28 | 0 | 27 | 1 | 0 | 0 | 0 | 0 | 19 | 9 | 28 | |||||||||||||||||||||||||||||||||
1958359 | 1958359 | GA | school | 1300180 | 604 | Baker County | 130018001867 | 105 | Baker County K12 School | Regular School | No | 4 | PK | 12 | 2016 | fall | grade_9 | 7 | 17 | 4 | 1 | 0 | 0 | 0 | 10 | 19 | 29 | 7 | 17 | 4 | 1 | 0 | 0 | 0 | 10 | 19 | 29 | |||||||||||||||||||||||||||||||||
1964916 | 1964916 | GA | school | 1302280 | 660 | Fulton County | 130228002037 | 383 | McClarin High School | Alternative Education School | No | 3 | 09 | 12 | 2016 | fall | grade_9 | 0 | 26 | 3 | 0 | 0 | 0 | 0 | 17 | 12 | 29 | 0 | 26 | 3 | 0 | 0 | 0 | 0 | 17 | 12 | 29 | |||||||||||||||||||||||||||||||||
2257374 | 2257374 | GA | school | 1304290 | 718 | Quitman County | 130429003850 | 110 | Quitman County High School | Regular School | No | 3 | 09 | 12 | 2016 | spring | grade_9 | 9 | 20 | 0 | 0 | 0 | 0 | 0 | 14 | 15 | 29 | 9 | 20 | 0 | 0 | 0 | 0 | 0 | 14 | 15 | 29 | |||||||||||||||||||||||||||||||||
1968308 | 1968308 | GA | school | 1303840 | 705 | Murray County | 130384003574 | 108 | Pleasant Valley Innovative School | Regular School | No | 4 | 06 | 12 | 2016 | fall | grade_9 | 22 | 0 | 8 | 0 | 0 | 0 | 0 | 18 | 12 | 30 | 22 | 0 | 8 | 0 | 0 | 0 | 0 | 18 | 12 | 30 | |||||||||||||||||||||||||||||||||
2258130 | 2258130 | GA | school | 1304590 | 728 | Stewart County | 130459002432 | 201 | Stewart County High School | Regular School | No | 3 | 09 | 12 | 2016 | spring | grade_9 | 0 | 30 | 0 | 0 | 0 | 0 | 0 | 13 | 17 | 30 | 0 | 30 | 0 | 0 | 0 | 0 | 0 | 13 | 17 | 30 | |||||||||||||||||||||||||||||||||
2258321 | 2258321 | GA | school | 1304890 | 736 | Thomas County | 130489004152 | 115 | The Renaissance Center for Academic and Career Development | Regular School | No | 4 | 06 | 12 | 2016 | spring | grade_9 | 7 | 21 | 1 | 0 | 0 | 0 | 1 | 25 | 5 | 30 | 7 | 21 | 1 | 0 | 0 | 0 | 1 | 25 | 5 | 30 | |||||||||||||||||||||||||||||||||
1963010 | 1963010 | GA | school | 1301740 | 644 | DeKalb County | 130174004159 | 315 | Tapestry Public Charter School | Regular School | Yes | 2 | 06 | 09 | 2016 | fall | grade_9 | 17 | 9 | 2 | 0 | 0 | 0 | 3 | 22 | 9 | 31 | 17 | 9 | 2 | 0 | 0 | 0 | 3 | 22 | 9 | 31 | |||||||||||||||||||||||||||||||||
1969348 | 1969348 | GA | school | 1304290 | 718 | Quitman County | 130429003850 | 110 | Quitman County High School | Regular School | No | 3 | 09 | 12 | 2016 | fall | grade_9 | 8 | 23 | 0 | 0 | 0 | 0 | 0 | 16 | 15 | 31 | 8 | 23 | 0 | 0 | 0 | 0 | 0 | 16 | 15 | 31 |
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]);