enrollments
Data source: Big Local News · About: Big Local
1,216 rows where grade = "grade_8", state = "GA" and year = 2019 sorted by male
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1266106 | 1266106 | GA | school | 1301740 | 644 | DeKalb County | 130174002642 | 503 | East DeKalb Special Education Center | Special Education School | No | Other | PK | 12 | 2019 | fall | grade_8 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | |||||||||||||||||||||||||||||||||
1268071 | 1268071 | GA | school | 1302280 | 660 | Fulton County | 130228003651 | 307 | Georgia Baptist Children's Home and Family Ministries | Regular School | No | Other | 04 | 12 | 2019 | fall | grade_8 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | |||||||||||||||||||||||||||||||||
1268089 | 1268089 | GA | school | 1302280 | 660 | Fulton County | 130228004261 | 1321 | Wellspring Living | Regular School | No | Secondary | 08 | 11 | 2019 | fall | grade_8 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | |||||||||||||||||||||||||||||||||
1269244 | 1269244 | GA | school | 1302550 | 667 | Gwinnett County | 130255003627 | 708 | Oakland Meadow School | Regular School | No | Other | PK | 12 | 2019 | fall | grade_8 | 1 | 0 | 1 | 0 | 2 | 0 | 0 | 0 | 4 | 4 | 1 | 0 | 1 | 0 | 2 | 0 | 0 | 0 | 4 | 4 | |||||||||||||||||||||||||||||||||
1274894 | 1274894 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012003980 | 1410 | Corretta Scott King Womens' Leadership Academy | Regular School | No | High | 06 | 12 | 2019 | fall | grade_8 | 0 | 49 | 4 | 0 | 0 | 0 | 0 | 0 | 53 | 53 | 0 | 49 | 4 | 0 | 0 | 0 | 0 | 0 | 53 | 53 | |||||||||||||||||||||||||||||||||
1275577 | 1275577 | GA | school | 1300226 | 7820612 | State Charter Schools- Ivy Preparatory Academy, Inc | 130022604023 | 612 | Ivy Preparatory Academy, Inc | Regular School | Yes | Elementary | KG | 08 | 2019 | fall | grade_8 | 0 | 47 | 1 | 0 | 0 | 0 | 0 | 0 | 48 | 48 | 0 | 47 | 1 | 0 | 0 | 0 | 0 | 0 | 48 | 48 | |||||||||||||||||||||||||||||||||
1276053 | 1276053 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603490 | 598 | Macon Youth Development Campus | Alternative School | No | High | 07 | 12 | 2019 | fall | grade_8 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 2 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 2 | |||||||||||||||||||||||||||||||||
2560280 | 2560280 | GA | school | 1301740 | 644 | DeKalb County | 130174002642 | 503 | East DeKalb Special Education Center | Special Education School | No | Other | PK | 12 | 2019 | spring | grade_8 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | |||||||||||||||||||||||||||||||||
2569078 | 2569078 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012003980 | 1410 | Corretta Scott King Womens' Leadership Academy | Regular School | No | High | 06 | 12 | 2019 | spring | grade_8 | 0 | 43 | 3 | 0 | 0 | 0 | 0 | 0 | 46 | 46 | 0 | 43 | 3 | 0 | 0 | 0 | 0 | 0 | 46 | 46 | |||||||||||||||||||||||||||||||||
2569760 | 2569760 | GA | school | 1300226 | 7820612 | State Charter Schools- Ivy Preparatory Academy, Inc | 130022604023 | 612 | Ivy Preparatory Academy, Inc | Regular School | Yes | Elementary | KG | 08 | 2019 | spring | grade_8 | 0 | 43 | 1 | 0 | 0 | 0 | 0 | 0 | 44 | 44 | 0 | 43 | 1 | 0 | 0 | 0 | 0 | 0 | 44 | 44 | |||||||||||||||||||||||||||||||||
2570240 | 2570240 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603490 | 598 | Macon Youth Development Campus | Alternative School | No | High | 07 | 12 | 2019 | spring | grade_8 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 2 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 2 | |||||||||||||||||||||||||||||||||
2570251 | 2570251 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603515 | 3198 | Waycross Regional Youth Detention Center | Alternative School | No | Middle | 06 | 10 | 2019 | spring | grade_8 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | |||||||||||||||||||||||||||||||||
1262105 | 1262105 | GA | school | 1300440 | 612 | Bleckley County | 130044004162 | 115 | Bleckley County Success Academy | Regular School | No | High | 06 | 12 | 2019 | fall | grade_8 | 1 | 2 | 0 | 0 | 0 | 0 | 0 | 1 | 2 | 3 | 1 | 2 | 0 | 0 | 0 | 0 | 0 | 1 | 2 | 3 | |||||||||||||||||||||||||||||||||
1266487 | 1266487 | GA | school | 1301800 | 646 | Dooly County | 130180004286 | 205 | Dooly County Prep Academy | Regular School | No | High | 07 | 12 | 2019 | fall | grade_8 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | |||||||||||||||||||||||||||||||||
1270948 | 1270948 | GA | school | 1303270 | 688 | Lee County | 130327003761 | 209 | Lee High School 9th Grade Campus | Regular School | No | Secondary | 08 | 10 | 2019 | fall | grade_8 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | |||||||||||||||||||||||||||||||||
1271325 | 1271325 | GA | school | 1303630 | 699 | Meriwether County | 130363003633 | 207 | Good Sheperd Therapeutic Center | Regular School | No | Secondary | 08 | 10 | 2019 | fall | grade_8 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | |||||||||||||||||||||||||||||||||
1272851 | 1272851 | GA | school | 1304380 | 721 | Richmond County | 130438003486 | 107 | Lighthouse Care Center of Augusta | Regular School | No | Secondary | 06 | 11 | 2019 | fall | grade_8 | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 1 | 3 | 4 | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 1 | 3 | 4 | |||||||||||||||||||||||||||||||||
1273828 | 1273828 | GA | school | 1305250 | 744 | Union County | 130525001721 | 3050 | Woody Gap High/Elementary School | Regular School | No | Other | KG | 12 | 2019 | fall | grade_8 | 6 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 6 | 7 | 6 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 6 | 7 | |||||||||||||||||||||||||||||||||
1276045 | 1276045 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603498 | 1498 | Augusta Regional Youth Detention Center | Alternative School | No | Secondary | 06 | 11 | 2019 | fall | grade_8 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | |||||||||||||||||||||||||||||||||
1276047 | 1276047 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603511 | 2798 | Bob Richards Regional Youth Detention Center | Alternative School | No | Middle | 07 | 09 | 2019 | fall | grade_8 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 2 | |||||||||||||||||||||||||||||||||
1276049 | 1276049 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603487 | 205 | Crisp RYDC | Alternative School | No | Secondary | 07 | 10 | 2019 | fall | grade_8 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | |||||||||||||||||||||||||||||||||
1276054 | 1276054 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603510 | 2698 | Marietta Regional Youth Detention Center | Alternative School | No | Secondary | 08 | 11 | 2019 | fall | grade_8 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | |||||||||||||||||||||||||||||||||
1276055 | 1276055 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603500 | 1698 | Martha K. Glaze Regional Youth Detention Center | Alternative School | No | Secondary | 07 | 11 | 2019 | fall | grade_8 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | |||||||||||||||||||||||||||||||||
1276057 | 1276057 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002604194 | 4199 | Millegeville ITU | Special Education School | No | High | 08 | 12 | 2019 | fall | grade_8 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | |||||||||||||||||||||||||||||||||
1276061 | 1276061 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603514 | 3098 | T J Loftiss II Regional Youth Detention Center | Alternative School | No | Secondary | 08 | 10 | 2019 | fall | grade_8 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | |||||||||||||||||||||||||||||||||
1276063 | 1276063 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603515 | 3198 | Waycross Regional Youth Detention Center | Alternative School | No | Middle | 06 | 10 | 2019 | fall | grade_8 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | |||||||||||||||||||||||||||||||||
2560635 | 2560635 | GA | school | 1301770 | 645 | Dodge County | 130177004186 | 292 | DAC (Dodge County Achievement Center) | Regular School | No | High | 07 | 12 | 2019 | spring | grade_8 | 3 | 2 | 0 | 0 | 0 | 0 | 1 | 1 | 5 | 6 | 3 | 2 | 0 | 0 | 0 | 0 | 1 | 1 | 5 | 6 | |||||||||||||||||||||||||||||||||
2560663 | 2560663 | GA | school | 1301800 | 646 | Dooly County | 130180004286 | 205 | Dooly County Prep Academy | Regular School | No | High | 07 | 12 | 2019 | spring | grade_8 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | |||||||||||||||||||||||||||||||||
2562249 | 2562249 | GA | school | 1302280 | 660 | Fulton County | 130228003651 | 307 | Georgia Baptist Children's Home and Family Ministries | Regular School | No | Other | 04 | 12 | 2019 | spring | grade_8 | 3 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 3 | 4 | 3 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 3 | 4 | |||||||||||||||||||||||||||||||||
2563423 | 2563423 | GA | school | 1302550 | 667 | Gwinnett County | 130255003627 | 708 | Oakland Meadow School | Regular School | No | Other | PK | 12 | 2019 | spring | grade_8 | 1 | 1 | 1 | 0 | 2 | 0 | 0 | 1 | 4 | 5 | 1 | 1 | 1 | 0 | 2 | 0 | 0 | 1 | 4 | 5 | |||||||||||||||||||||||||||||||||
2565507 | 2565507 | GA | school | 1303630 | 699 | Meriwether County | 130363003633 | 207 | Good Sheperd Therapeutic Center | Regular School | No | Secondary | 08 | 10 | 2019 | spring | grade_8 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | |||||||||||||||||||||||||||||||||
2565570 | 2565570 | GA | school | 701 | Mitchell County | 298 | Eagle's Landing Academy | 2019 | spring | grade_8 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 2 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 2 | ||||||||||||||||||||||||||||||||||||||||
2568013 | 2568013 | GA | school | 1305250 | 744 | Union County | 130525001721 | 3050 | Woody Gap High/Elementary School | Regular School | No | Other | KG | 12 | 2019 | spring | grade_8 | 6 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 6 | 7 | 6 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 6 | 7 | |||||||||||||||||||||||||||||||||
2569546 | 2569546 | GA | school | 1301870 | 774 | Dublin City | 130187004050 | 412 | Moore Street Facility | Regular School | No | High | 06 | 12 | 2019 | spring | grade_8 | 0 | 3 | 0 | 0 | 0 | 0 | 1 | 1 | 3 | 4 | 0 | 3 | 0 | 0 | 0 | 0 | 1 | 1 | 3 | 4 | |||||||||||||||||||||||||||||||||
2570231 | 2570231 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603498 | 1498 | Augusta Regional Youth Detention Center | Alternative School | No | Secondary | 06 | 11 | 2019 | spring | grade_8 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | |||||||||||||||||||||||||||||||||
2570234 | 2570234 | GA | school | 891 | Department of Juvenile Justice | 4205 | Cadwell RYDC | 2019 | spring | grade_8 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | ||||||||||||||||||||||||||||||||||||||||
2570235 | 2570235 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603501 | 1798 | Claxton Regional Youth Detention Center | Alternative School | No | Secondary | 07 | 11 | 2019 | spring | grade_8 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | |||||||||||||||||||||||||||||||||
2570236 | 2570236 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603487 | 205 | Crisp RYDC | Alternative School | No | Secondary | 07 | 10 | 2019 | spring | grade_8 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | |||||||||||||||||||||||||||||||||
2570237 | 2570237 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603504 | 2098 | DeKalb Regional Youth Detention Center | Alternative School | No | Secondary | 07 | 11 | 2019 | spring | grade_8 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | |||||||||||||||||||||||||||||||||
2570239 | 2570239 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603509 | 2598 | Macon Regional Youth Detention Center | Alternative School | No | Secondary | 07 | 10 | 2019 | spring | grade_8 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 2 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 2 | |||||||||||||||||||||||||||||||||
2570244 | 2570244 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002604194 | 4199 | Millegeville ITU | Special Education School | No | High | 08 | 12 | 2019 | spring | grade_8 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | |||||||||||||||||||||||||||||||||
2570248 | 2570248 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603518 | 5001 | Sumter Youth Development Campus | Alternative School | No | High | 09 | 12 | 2019 | spring | grade_8 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | |||||||||||||||||||||||||||||||||
2570249 | 2570249 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603514 | 3098 | T J Loftiss II Regional Youth Detention Center | Alternative School | No | Secondary | 08 | 10 | 2019 | spring | grade_8 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | |||||||||||||||||||||||||||||||||
1263243 | 1263243 | GA | school | 1301080 | 627 | Chattooga County | 130108000421 | 3050 | Menlo Elementary School | Regular School | No | Elementary | PK | 08 | 2019 | fall | grade_8 | 21 | 0 | 1 | 0 | 1 | 0 | 0 | 10 | 13 | 23 | 21 | 0 | 1 | 0 | 1 | 0 | 0 | 10 | 13 | 23 | |||||||||||||||||||||||||||||||||
2561674 | 2561674 | GA | school | 1302220 | 658 | Forsyth County | 130222003995 | 219 | Forsyth Virtual Academy | Regular School | No | High | 06 | 12 | 2019 | spring | grade_8 | 15 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 5 | 15 | 15 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 5 | 15 | |||||||||||||||||||||||||||||||||
2565704 | 2565704 | GA | school | 1303840 | 705 | Murray County | 130384003574 | 108 | Pleasant Valley Innovative School | Regular School | No | High | 07 | 12 | 2019 | spring | grade_8 | 11 | 0 | 2 | 0 | 0 | 0 | 0 | 10 | 3 | 13 | 11 | 0 | 2 | 0 | 0 | 0 | 0 | 10 | 3 | 13 | |||||||||||||||||||||||||||||||||
1263036 | 1263036 | GA | school | 1301020 | 625 | Savannah-Chatham County | 130102000362 | 201 | DeRenne Middle School | Regular School | No | Middle | 06 | 08 | 2019 | fall | grade_8 | 3 | 199 | 4 | 0 | 0 | 0 | 1 | 100 | 107 | 207 | 3 | 199 | 4 | 0 | 0 | 0 | 1 | 100 | 107 | 207 | |||||||||||||||||||||||||||||||||
1266790 | 1266790 | GA | school | 1301860 | 648 | Douglas County | 130186002547 | 103 | Yeager Middle School | Regular School | No | Middle | 06 | 08 | 2019 | fall | grade_8 | 72 | 77 | 41 | 0 | 3 | 0 | 9 | 100 | 102 | 202 | 72 | 77 | 41 | 0 | 3 | 0 | 9 | 100 | 102 | 202 | |||||||||||||||||||||||||||||||||
1269639 | 1269639 | GA | school | 1302580 | 668 | Habersham County | 130258001147 | 196 | North Habersham Middle School | Regular School | No | Middle | 06 | 08 | 2019 | fall | grade_8 | 154 | 5 | 24 | 0 | 0 | 0 | 3 | 100 | 86 | 186 | 154 | 5 | 24 | 0 | 0 | 0 | 3 | 100 | 86 | 186 | |||||||||||||||||||||||||||||||||
2558717 | 2558717 | GA | school | 1301290 | 633 | Cobb County | 130129001926 | 184 | McCleskey Middle School | Regular School | No | Middle | 06 | 08 | 2019 | spring | grade_8 | 101 | 42 | 45 | 0 | 5 | 0 | 6 | 100 | 99 | 199 | 101 | 42 | 45 | 0 | 5 | 0 | 6 | 100 | 99 | 199 | |||||||||||||||||||||||||||||||||
2561486 | 2561486 | GA | school | 1302190 | 657 | Floyd County | 130219000934 | 273 | Pepperell Middle School | Regular School | No | Middle | 06 | 08 | 2019 | spring | grade_8 | 168 | 16 | 20 | 0 | 1 | 0 | 6 | 100 | 111 | 211 | 168 | 16 | 20 | 0 | 1 | 0 | 6 | 100 | 111 | 211 | |||||||||||||||||||||||||||||||||
1265098 | 1265098 | GA | school | 1301410 | 636 | Columbia County | 130141002366 | 101 | Greenbrier Middle School | Regular School | No | Middle | 06 | 08 | 2019 | fall | grade_8 | 152 | 28 | 21 | 0 | 5 | 0 | 13 | 101 | 118 | 219 | 152 | 28 | 21 | 0 | 5 | 0 | 13 | 101 | 118 | 219 | |||||||||||||||||||||||||||||||||
1274099 | 1274099 | GA | school | 1305430 | 748 | Ware County | 130543002204 | 295 | Waycross Middle School | Regular School | No | Middle | 06 | 08 | 2019 | fall | grade_8 | 66 | 98 | 8 | 0 | 2 | 0 | 11 | 101 | 84 | 185 | 66 | 98 | 8 | 0 | 2 | 0 | 11 | 101 | 84 | 185 | |||||||||||||||||||||||||||||||||
2555992 | 2555992 | GA | school | 1300360 | 609 | Ben Hill County | 130036002149 | 296 | Ben Hill County Middle School | Regular School | No | Middle | 06 | 08 | 2019 | spring | grade_8 | 67 | 104 | 36 | 1 | 1 | 0 | 7 | 101 | 115 | 216 | 67 | 104 | 36 | 1 | 1 | 0 | 7 | 101 | 115 | 216 | |||||||||||||||||||||||||||||||||
1266114 | 1266114 | GA | school | 1301740 | 644 | DeKalb County | 130174000649 | 1057 | McNair Middle School | Regular School | No | Middle | 06 | 08 | 2019 | fall | grade_8 | 1 | 190 | 5 | 0 | 0 | 1 | 1 | 102 | 96 | 198 | 1 | 190 | 5 | 0 | 0 | 1 | 1 | 102 | 96 | 198 | |||||||||||||||||||||||||||||||||
1267308 | 1267308 | GA | school | 1302190 | 657 | Floyd County | 130219000934 | 273 | Pepperell Middle School | Regular School | No | Middle | 06 | 08 | 2019 | fall | grade_8 | 169 | 16 | 22 | 0 | 1 | 0 | 6 | 102 | 112 | 214 | 169 | 16 | 22 | 0 | 1 | 0 | 6 | 102 | 112 | 214 | |||||||||||||||||||||||||||||||||
1273233 | 1273233 | GA | school | 1302520 | 726 | Griffin-Spalding County | 130252002430 | 201 | Cowan Road Middle School | Regular School | No | Middle | 06 | 08 | 2019 | fall | grade_8 | 68 | 89 | 23 | 0 | 0 | 0 | 8 | 102 | 86 | 188 | 68 | 89 | 23 | 0 | 0 | 0 | 8 | 102 | 86 | 188 | |||||||||||||||||||||||||||||||||
1274184 | 1274184 | GA | school | 1305550 | 751 | Wayne County | 130555000685 | 294 | Arthur Williams Middle School | Regular School | No | Middle | 06 | 08 | 2019 | fall | grade_8 | 118 | 55 | 13 | 0 | 2 | 0 | 5 | 102 | 91 | 193 | 118 | 55 | 13 | 0 | 2 | 0 | 5 | 102 | 91 | 193 | |||||||||||||||||||||||||||||||||
2560288 | 2560288 | GA | school | 1301740 | 644 | DeKalb County | 130174000649 | 1057 | McNair Middle School | Regular School | No | Middle | 06 | 08 | 2019 | spring | grade_8 | 2 | 194 | 5 | 0 | 0 | 1 | 0 | 102 | 100 | 202 | 2 | 194 | 5 | 0 | 0 | 1 | 0 | 102 | 100 | 202 | |||||||||||||||||||||||||||||||||
2560966 | 2560966 | GA | school | 1301860 | 648 | Douglas County | 130186002547 | 103 | Yeager Middle School | Regular School | No | Middle | 06 | 08 | 2019 | spring | grade_8 | 74 | 77 | 40 | 0 | 3 | 0 | 8 | 102 | 100 | 202 | 74 | 77 | 40 | 0 | 3 | 0 | 8 | 102 | 100 | 202 | |||||||||||||||||||||||||||||||||
2563819 | 2563819 | GA | school | 1302580 | 668 | Habersham County | 130258001147 | 196 | North Habersham Middle School | Regular School | No | Middle | 06 | 08 | 2019 | spring | grade_8 | 158 | 4 | 25 | 0 | 0 | 0 | 3 | 102 | 88 | 190 | 158 | 4 | 25 | 0 | 0 | 0 | 3 | 102 | 88 | 190 | |||||||||||||||||||||||||||||||||
2568369 | 2568369 | GA | school | 1305550 | 751 | Wayne County | 130555000685 | 294 | Arthur Williams Middle School | Regular School | No | Middle | 06 | 08 | 2019 | spring | grade_8 | 119 | 53 | 14 | 0 | 2 | 0 | 6 | 102 | 92 | 194 | 119 | 53 | 14 | 0 | 2 | 0 | 6 | 102 | 92 | 194 | |||||||||||||||||||||||||||||||||
1270832 | 1270832 | GA | school | 1303150 | 684 | Jones County | 130315003424 | 106 | Gray Station Middle School | Regular School | No | Middle | 06 | 08 | 2019 | fall | grade_8 | 170 | 40 | 3 | 0 | 0 | 0 | 4 | 103 | 114 | 217 | 170 | 40 | 3 | 0 | 0 | 0 | 4 | 103 | 114 | 217 | |||||||||||||||||||||||||||||||||
1272245 | 1272245 | GA | school | 1304020 | 710 | Paulding County | 130402004074 | 213 | P. B. Ritch Middle School | Regular School | No | Middle | 06 | 08 | 2019 | fall | grade_8 | 48 | 112 | 41 | 1 | 3 | 0 | 16 | 103 | 118 | 221 | 48 | 112 | 41 | 1 | 3 | 0 | 16 | 103 | 118 | 221 | |||||||||||||||||||||||||||||||||
2566433 | 2566433 | GA | school | 1304020 | 710 | Paulding County | 130402001786 | 297 | J. A. Dobbins Middle School | Regular School | No | Middle | 06 | 08 | 2019 | spring | grade_8 | 99 | 64 | 30 | 0 | 3 | 0 | 12 | 103 | 105 | 208 | 99 | 64 | 30 | 0 | 3 | 0 | 12 | 103 | 105 | 208 | |||||||||||||||||||||||||||||||||
2566739 | 2566739 | GA | school | 1304260 | 717 | Putnam County | 130426003878 | 111 | Putnam County Middle School | Regular School | No | Middle | 06 | 08 | 2019 | spring | grade_8 | 90 | 77 | 24 | 1 | 1 | 0 | 15 | 103 | 105 | 208 | 90 | 77 | 24 | 1 | 1 | 0 | 15 | 103 | 105 | 208 | |||||||||||||||||||||||||||||||||
1263591 | 1263591 | GA | school | 1301170 | 629 | Clarke County | 130117000450 | 5058 | Hilsman Middle School | Regular School | No | Middle | 06 | 08 | 2019 | fall | grade_8 | 32 | 124 | 25 | 0 | 7 | 0 | 8 | 104 | 92 | 196 | 32 | 124 | 25 | 0 | 7 | 0 | 8 | 104 | 92 | 196 | |||||||||||||||||||||||||||||||||
1266584 | 1266584 | GA | school | 1301830 | 647 | Dougherty County | 130183000842 | 4056 | Merry Acres Middle School | Regular School | No | Middle | 06 | 08 | 2019 | fall | grade_8 | 5 | 194 | 1 | 1 | 0 | 0 | 4 | 104 | 101 | 205 | 5 | 194 | 1 | 1 | 0 | 0 | 4 | 104 | 101 | 205 | |||||||||||||||||||||||||||||||||
1272549 | 1272549 | GA | school | 1304260 | 717 | Putnam County | 130426003878 | 111 | Putnam County Middle School | Regular School | No | Middle | 06 | 08 | 2019 | fall | grade_8 | 88 | 79 | 24 | 1 | 1 | 0 | 15 | 104 | 104 | 208 | 88 | 79 | 24 | 1 | 1 | 0 | 15 | 104 | 104 | 208 | |||||||||||||||||||||||||||||||||
1274485 | 1274485 | GA | school | 1305850 | 759 | Worth County | 130585000733 | 193 | Worth County Middle School | Regular School | No | Middle | 06 | 08 | 2019 | fall | grade_8 | 118 | 81 | 4 | 1 | 4 | 1 | 5 | 104 | 110 | 214 | 118 | 81 | 4 | 1 | 4 | 1 | 5 | 104 | 110 | 214 | |||||||||||||||||||||||||||||||||
2557220 | 2557220 | GA | school | 1301020 | 625 | Savannah-Chatham County | 130102000362 | 201 | DeRenne Middle School | Regular School | No | Middle | 06 | 08 | 2019 | spring | grade_8 | 4 | 195 | 4 | 0 | 0 | 0 | 1 | 104 | 100 | 204 | 4 | 195 | 4 | 0 | 0 | 0 | 1 | 104 | 100 | 204 | |||||||||||||||||||||||||||||||||
2560964 | 2560964 | GA | school | 1301860 | 648 | Douglas County | 130186000861 | 5050 | Stewart Middle School | Regular School | No | Middle | 06 | 08 | 2019 | spring | grade_8 | 10 | 173 | 21 | 0 | 0 | 0 | 3 | 104 | 103 | 207 | 10 | 173 | 21 | 0 | 0 | 0 | 3 | 104 | 103 | 207 | |||||||||||||||||||||||||||||||||
2565947 | 2565947 | GA | school | 1303870 | 706 | Muscogee County | 130387001413 | 2050 | Arnold Middle School | Regular School | No | Middle | 06 | 08 | 2019 | spring | grade_8 | 47 | 87 | 43 | 0 | 6 | 0 | 16 | 104 | 95 | 199 | 47 | 87 | 43 | 0 | 6 | 0 | 16 | 104 | 95 | 199 | |||||||||||||||||||||||||||||||||
1263905 | 1263905 | GA | school | 1301230 | 631 | Clayton County | 130123000480 | 177 | Adamson Middle School | Regular School | No | Middle | 06 | 08 | 2019 | fall | grade_8 | 4 | 153 | 46 | 0 | 3 | 0 | 1 | 105 | 102 | 207 | 4 | 153 | 46 | 0 | 3 | 0 | 1 | 105 | 102 | 207 | |||||||||||||||||||||||||||||||||
1272239 | 1272239 | GA | school | 1304020 | 710 | Paulding County | 130402003822 | 410 | Carl Scoggins Sr. Middle school | Regular School | No | Middle | 06 | 08 | 2019 | fall | grade_8 | 173 | 30 | 18 | 1 | 0 | 0 | 13 | 105 | 130 | 235 | 173 | 30 | 18 | 1 | 0 | 0 | 13 | 105 | 130 | 235 | |||||||||||||||||||||||||||||||||
1272243 | 1272243 | GA | school | 1304020 | 710 | Paulding County | 130402001786 | 297 | J. A. Dobbins Middle School | Regular School | No | Middle | 06 | 08 | 2019 | fall | grade_8 | 99 | 66 | 26 | 0 | 2 | 0 | 12 | 105 | 100 | 205 | 99 | 66 | 26 | 0 | 2 | 0 | 12 | 105 | 100 | 205 | |||||||||||||||||||||||||||||||||
2565092 | 2565092 | GA | school | 1301890 | 687 | Laurens County | 130189001729 | 297 | East Laurens Middle School | Regular School | No | Middle | 06 | 08 | 2019 | spring | grade_8 | 111 | 64 | 6 | 1 | 0 | 0 | 4 | 105 | 81 | 186 | 111 | 64 | 6 | 1 | 0 | 0 | 4 | 105 | 81 | 186 | |||||||||||||||||||||||||||||||||
2569086 | 2569086 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012000025 | 373 | King Middle School | Regular School | No | Middle | 06 | 08 | 2019 | spring | grade_8 | 3 | 193 | 12 | 0 | 2 | 0 | 1 | 105 | 106 | 211 | 3 | 193 | 12 | 0 | 2 | 0 | 1 | 105 | 106 | 211 | |||||||||||||||||||||||||||||||||
1261808 | 1261808 | GA | school | 1300360 | 609 | Ben Hill County | 130036002149 | 296 | Ben Hill County Middle School | Regular School | No | Middle | 06 | 08 | 2019 | fall | grade_8 | 70 | 109 | 36 | 1 | 1 | 0 | 7 | 106 | 118 | 224 | 70 | 109 | 36 | 1 | 1 | 0 | 7 | 106 | 118 | 224 | |||||||||||||||||||||||||||||||||
1269817 | 1269817 | GA | school | 1302610 | 669 | Hall County | 130261004308 | 390 | Cherokee Bluff Middle | Regular School | No | Middle | 06 | 08 | 2019 | fall | grade_8 | 136 | 15 | 48 | 0 | 2 | 0 | 8 | 106 | 103 | 209 | 136 | 15 | 48 | 0 | 2 | 0 | 8 | 106 | 103 | 209 | |||||||||||||||||||||||||||||||||
1270910 | 1270910 | GA | school | 1301890 | 687 | Laurens County | 130189001729 | 297 | East Laurens Middle School | Regular School | No | Middle | 06 | 08 | 2019 | fall | grade_8 | 112 | 63 | 7 | 1 | 0 | 0 | 3 | 106 | 80 | 186 | 112 | 63 | 7 | 1 | 0 | 0 | 3 | 106 | 80 | 186 | |||||||||||||||||||||||||||||||||
1273923 | 1273923 | GA | school | 1305370 | 746 | Walker County | 130537003800 | 206 | Rossville Middle School | Regular School | No | Middle | 06 | 08 | 2019 | fall | grade_8 | 133 | 17 | 18 | 0 | 1 | 0 | 8 | 106 | 71 | 177 | 133 | 17 | 18 | 0 | 1 | 0 | 8 | 106 | 71 | 177 | |||||||||||||||||||||||||||||||||
2564441 | 2564441 | GA | school | 1302820 | 675 | Henry County | 130282001663 | 397 | Austin Road Middle School | Regular School | No | Middle | 06 | 08 | 2019 | spring | grade_8 | 17 | 182 | 19 | 0 | 3 | 0 | 1 | 106 | 116 | 222 | 17 | 182 | 19 | 0 | 3 | 0 | 1 | 106 | 116 | 222 | |||||||||||||||||||||||||||||||||
2564907 | 2564907 | GA | school | 1303000 | 680 | Jeff Davis County | 130300001256 | 111 | Jeff Davis Middle School | Regular School | No | Middle | 06 | 08 | 2019 | spring | grade_8 | 137 | 28 | 55 | 0 | 0 | 0 | 6 | 106 | 120 | 226 | 137 | 28 | 55 | 0 | 0 | 0 | 6 | 106 | 120 | 226 | |||||||||||||||||||||||||||||||||
2565014 | 2565014 | GA | school | 1303150 | 684 | Jones County | 130315003424 | 106 | Gray Station Middle School | Regular School | No | Middle | 06 | 08 | 2019 | spring | grade_8 | 173 | 40 | 2 | 0 | 0 | 0 | 4 | 106 | 113 | 219 | 173 | 40 | 2 | 0 | 0 | 0 | 4 | 106 | 113 | 219 | |||||||||||||||||||||||||||||||||
2566435 | 2566435 | GA | school | 1304020 | 710 | Paulding County | 130402004074 | 213 | P. B. Ritch Middle School | Regular School | No | Middle | 06 | 08 | 2019 | spring | grade_8 | 50 | 117 | 41 | 1 | 3 | 0 | 17 | 106 | 123 | 229 | 50 | 117 | 41 | 1 | 3 | 0 | 17 | 106 | 123 | 229 | |||||||||||||||||||||||||||||||||
2567423 | 2567423 | GA | school | 1302520 | 726 | Griffin-Spalding County | 130252002430 | 201 | Cowan Road Middle School | Regular School | No | Middle | 06 | 08 | 2019 | spring | grade_8 | 66 | 95 | 24 | 0 | 0 | 0 | 9 | 106 | 88 | 194 | 66 | 95 | 24 | 0 | 0 | 0 | 9 | 106 | 88 | 194 | |||||||||||||||||||||||||||||||||
1266788 | 1266788 | GA | school | 1301860 | 648 | Douglas County | 130186000861 | 5050 | Stewart Middle School | Regular School | No | Middle | 06 | 08 | 2019 | fall | grade_8 | 9 | 168 | 23 | 0 | 0 | 0 | 4 | 107 | 97 | 204 | 9 | 168 | 23 | 0 | 0 | 0 | 4 | 107 | 97 | 204 | |||||||||||||||||||||||||||||||||
2559279 | 2559279 | GA | school | 1301410 | 636 | Columbia County | 130141002366 | 101 | Greenbrier Middle School | Regular School | No | Middle | 06 | 08 | 2019 | spring | grade_8 | 156 | 27 | 20 | 0 | 6 | 0 | 12 | 107 | 114 | 221 | 156 | 27 | 20 | 0 | 6 | 0 | 12 | 107 | 114 | 221 | |||||||||||||||||||||||||||||||||
2565958 | 2565958 | GA | school | 1303870 | 706 | Muscogee County | 130387003680 | 204 | Veterans Memorial Middle School | Regular School | No | Middle | 06 | 08 | 2019 | spring | grade_8 | 120 | 67 | 16 | 0 | 11 | 0 | 10 | 107 | 117 | 224 | 120 | 67 | 16 | 0 | 11 | 0 | 10 | 107 | 117 | 224 | |||||||||||||||||||||||||||||||||
2568012 | 2568012 | GA | school | 1305250 | 744 | Union County | 130525003456 | 108 | Union County Middle School | Regular School | No | Middle | 06 | 08 | 2019 | spring | grade_8 | 194 | 0 | 8 | 0 | 1 | 0 | 6 | 107 | 102 | 209 | 194 | 0 | 8 | 0 | 1 | 0 | 6 | 107 | 102 | 209 | |||||||||||||||||||||||||||||||||
1268078 | 1268078 | GA | school | 1302280 | 660 | Fulton County | 130228002035 | 189 | McNair Middle School | Regular School | No | Middle | 06 | 08 | 2019 | fall | grade_8 | 2 | 222 | 8 | 0 | 0 | 0 | 4 | 108 | 128 | 236 | 2 | 222 | 8 | 0 | 0 | 0 | 4 | 108 | 128 | 236 | |||||||||||||||||||||||||||||||||
1271765 | 1271765 | GA | school | 1303870 | 706 | Muscogee County | 130387001400 | 2066 | Richards Middle School | Regular School | No | Middle | 06 | 08 | 2019 | fall | grade_8 | 67 | 110 | 20 | 1 | 14 | 0 | 8 | 108 | 112 | 220 | 67 | 110 | 20 | 1 | 14 | 0 | 8 | 108 | 112 | 220 | |||||||||||||||||||||||||||||||||
2562715 | 2562715 | GA | school | 1302430 | 664 | Gordon County | 130243002175 | 292 | Ashworth Middle School | Regular School | No | Middle | 06 | 08 | 2019 | spring | grade_8 | 158 | 5 | 56 | 0 | 3 | 0 | 6 | 108 | 120 | 228 | 158 | 5 | 56 | 0 | 3 | 0 | 6 | 108 | 120 | 228 | |||||||||||||||||||||||||||||||||
2568108 | 2568108 | GA | school | 1305370 | 746 | Walker County | 130537003800 | 206 | Rossville Middle School | Regular School | No | Middle | 06 | 08 | 2019 | spring | grade_8 | 127 | 20 | 17 | 0 | 1 | 0 | 8 | 108 | 65 | 173 | 127 | 20 | 17 | 0 | 1 | 0 | 8 | 108 | 65 | 173 | |||||||||||||||||||||||||||||||||
1268536 | 1268536 | GA | school | 1302430 | 664 | Gordon County | 130243002175 | 292 | Ashworth Middle School | Regular School | No | Middle | 06 | 08 | 2019 | fall | grade_8 | 161 | 7 | 56 | 0 | 2 | 0 | 4 | 109 | 121 | 230 | 161 | 7 | 56 | 0 | 2 | 0 | 4 | 109 | 121 | 230 | |||||||||||||||||||||||||||||||||
1270725 | 1270725 | GA | school | 1303000 | 680 | Jeff Davis County | 130300001256 | 111 | Jeff Davis Middle School | Regular School | No | Middle | 06 | 08 | 2019 | fall | grade_8 | 131 | 31 | 54 | 0 | 0 | 0 | 7 | 109 | 114 | 223 | 131 | 31 | 54 | 0 | 0 | 0 | 7 | 109 | 114 | 223 | |||||||||||||||||||||||||||||||||
2557775 | 2557775 | GA | school | 1301170 | 629 | Clarke County | 130117000450 | 5058 | Hilsman Middle School | Regular School | No | Middle | 06 | 08 | 2019 | spring | grade_8 | 33 | 129 | 24 | 0 | 5 | 0 | 8 | 109 | 90 | 199 | 33 | 129 | 24 | 0 | 5 | 0 | 8 | 109 | 90 | 199 | |||||||||||||||||||||||||||||||||
2558088 | 2558088 | GA | school | 1301230 | 631 | Clayton County | 130123000480 | 177 | Adamson Middle School | Regular School | No | Middle | 06 | 08 | 2019 | spring | grade_8 | 4 | 156 | 48 | 0 | 3 | 0 | 1 | 109 | 103 | 212 | 4 | 156 | 48 | 0 | 3 | 0 | 1 | 109 | 103 | 212 | |||||||||||||||||||||||||||||||||
2565013 | 2565013 | GA | school | 1303150 | 684 | Jones County | 130315002502 | 101 | Clifton Ridge Middle School | Regular School | No | Middle | 06 | 08 | 2019 | spring | grade_8 | 129 | 80 | 1 | 0 | 1 | 0 | 5 | 109 | 107 | 216 | 129 | 80 | 1 | 0 | 1 | 0 | 5 | 109 | 107 | 216 |
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]);