enrollments
Data source: Big Local News · About: Big Local
1,212 rows where grade = "grade_8", state = "GA" and year = 2021 sorted by female
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
403215 | 403215 | GA | school | 1300360 | 609 | Ben Hill County | 130036004365 | 392 | Hurricane Transition Academy | Regular School | No | High | 08 | 12 | 2021 | fall | grade_8 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | |||||||||||||||||||||||||||||||||
404007 | 404007 | GA | school | 1300840 | 622 | Carroll County | 130084003483 | 112 | KidsPeace | Regular School | No | Secondary | 06 | 11 | 2021 | fall | grade_8 | 2 | 4 | 0 | 0 | 0 | 0 | 0 | 6 | 0 | 6 | 2 | 4 | 0 | 0 | 0 | 0 | 0 | 6 | 0 | 6 | |||||||||||||||||||||||||||||||||
405298 | 405298 | GA | school | 1301230 | 631 | Clayton County | 130123004279 | 378 | Eula Wilburn Ponds Perry Center for Learning | Regular School | No | High | 08 | 12 | 2021 | fall | grade_8 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 2 | 0 | 2 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 2 | 0 | 2 | |||||||||||||||||||||||||||||||||
407486 | 407486 | GA | school | 1301740 | 644 | DeKalb County | 130174002642 | 503 | East DeKalb Special Education Center | Special Education School | No | High | 05 | 12 | 2021 | fall | grade_8 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | |||||||||||||||||||||||||||||||||
407492 | 407492 | GA | school | 1301740 | 644 | DeKalb County | 130174003868 | 510 | Margaret Harris Comprehensive School | Regular School | No | Other | PK | 12 | 2021 | fall | grade_8 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | |||||||||||||||||||||||||||||||||
408429 | 408429 | GA | school | 1302070 | 654 | Evans County | 130207004287 | 197 | Second Chance | Regular School | No | Secondary | 07 | 11 | 2021 | fall | grade_8 | 2 | 1 | 1 | 0 | 0 | 0 | 0 | 4 | 0 | 4 | 2 | 1 | 1 | 0 | 0 | 0 | 0 | 4 | 0 | 4 | |||||||||||||||||||||||||||||||||
409450 | 409450 | GA | school | 1302280 | 660 | Fulton County | 130228003651 | 307 | Georgia Baptist Children's Home and Family Ministries | Regular School | No | Other | 04 | 11 | 2021 | fall | grade_8 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | |||||||||||||||||||||||||||||||||
412677 | 412677 | GA | school | 1303630 | 699 | Meriwether County | 130363003633 | 207 | Good Sheperd Therapeutic Center | Regular School | No | Secondary | 08 | 10 | 2021 | fall | grade_8 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | |||||||||||||||||||||||||||||||||
412850 | 412850 | GA | school | 1303840 | 705 | Murray County | 130384003574 | 108 | Pleasant Valley Innovative School | Regular School | No | High | 08 | 12 | 2021 | fall | grade_8 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | |||||||||||||||||||||||||||||||||
415044 | 415044 | GA | school | 1300001 | 741 | Troup County | 130000103620 | 207 | Ault Academy | Regular School | No | High | 07 | 12 | 2021 | fall | grade_8 | 0 | 4 | 1 | 0 | 0 | 0 | 0 | 5 | 0 | 5 | 0 | 4 | 1 | 0 | 0 | 0 | 0 | 5 | 0 | 5 | |||||||||||||||||||||||||||||||||
415806 | 415806 | GA | school | 1305850 | 759 | Worth County | 130585004231 | 197 | Worth County Achievement Center | Regular School | No | High | 07 | 12 | 2021 | fall | grade_8 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | |||||||||||||||||||||||||||||||||
416204 | 416204 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012003558 | 1411 | B.E.S.T Academy | Regular School | No | High | 06 | 12 | 2021 | fall | grade_8 | 0 | 40 | 4 | 0 | 0 | 0 | 0 | 44 | 0 | 44 | 0 | 40 | 4 | 0 | 0 | 0 | 0 | 44 | 0 | 44 | |||||||||||||||||||||||||||||||||
416967 | 416967 | GA | school | 1300217 | 7830310 | State Charter Schools II- Fulton Leadership Academy | 130021703961 | 310 | Fulton Leadership Academy | Regular School | No | High | 06 | 12 | 2021 | fall | grade_8 | 0 | 67 | 1 | 0 | 0 | 0 | 2 | 70 | 0 | 70 | 0 | 67 | 1 | 0 | 0 | 0 | 2 | 70 | 0 | 70 | |||||||||||||||||||||||||||||||||
417039 | 417039 | GA | school | 1300248 | 7830615 | State Charter Schools II- Genesis Innovation Academy for Boys | 130024804288 | 615 | Genesis Innovation Academy for Boys | Regular School | No | Other | KG | 09 | 2021 | fall | grade_8 | 0 | 31 | 5 | 1 | 0 | 0 | 0 | 37 | 0 | 37 | 0 | 31 | 5 | 1 | 0 | 0 | 0 | 37 | 0 | 37 | |||||||||||||||||||||||||||||||||
417487 | 417487 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002604089 | 104 | Atlanta Youth Detention Center | Special Education School | No | High | 08 | 12 | 2021 | fall | grade_8 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | |||||||||||||||||||||||||||||||||
417488 | 417488 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603498 | 1498 | Augusta Regional Youth Detention Center | Alternative School | No | Secondary | 08 | 10 | 2021 | fall | grade_8 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | |||||||||||||||||||||||||||||||||
417489 | 417489 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603488 | 298 | Augusta Youth Development Campus | Alternative School | No | High | 08 | 12 | 2021 | fall | grade_8 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | |||||||||||||||||||||||||||||||||
417490 | 417490 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002604354 | 4205 | Cadwell RYDC | Special Education School | No | Secondary | 08 | 10 | 2021 | fall | grade_8 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | |||||||||||||||||||||||||||||||||
417491 | 417491 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603509 | 2598 | Macon Regional Youth Detention Center | Alternative School | No | Secondary | 08 | 11 | 2021 | fall | grade_8 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | |||||||||||||||||||||||||||||||||
417493 | 417493 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603517 | 4198 | Metro Regional Youth Detention Center | Alternative School | No | Secondary | 06 | 11 | 2021 | fall | grade_8 | 0 | 5 | 0 | 0 | 0 | 0 | 0 | 5 | 0 | 5 | 0 | 5 | 0 | 0 | 0 | 0 | 0 | 5 | 0 | 5 | |||||||||||||||||||||||||||||||||
417494 | 417494 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603650 | 405 | Muscogee Youth Development Center | Alternative School | No | High | 08 | 12 | 2021 | fall | grade_8 | 1 | 3 | 0 | 0 | 0 | 0 | 0 | 4 | 0 | 4 | 1 | 3 | 0 | 0 | 0 | 0 | 0 | 4 | 0 | 4 | |||||||||||||||||||||||||||||||||
417495 | 417495 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002604141 | 414 | Rockdale RYDC | Special Education School | No | Secondary | 08 | 10 | 2021 | fall | grade_8 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | |||||||||||||||||||||||||||||||||
417496 | 417496 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603513 | 2998 | Savannah Regional Youth Detention Center | Alternative School | No | Secondary | 08 | 11 | 2021 | fall | grade_8 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | |||||||||||||||||||||||||||||||||
417497 | 417497 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603514 | 3098 | T J Loftiss II Regional Youth Detention Center | Alternative School | No | Secondary | 08 | 09 | 2021 | fall | grade_8 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | |||||||||||||||||||||||||||||||||
2261105 | 2261105 | GA | school | 1300360 | 609 | Ben Hill County | 130036004365 | 392 | Hurricane Transition Academy | Regular School | No | High | 08 | 12 | 2021 | spring | grade_8 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | |||||||||||||||||||||||||||||||||
2261899 | 2261899 | GA | school | 1300840 | 622 | Carroll County | 130084003483 | 112 | KidsPeace | Regular School | No | Secondary | 06 | 11 | 2021 | spring | grade_8 | 2 | 7 | 1 | 0 | 0 | 0 | 2 | 12 | 0 | 12 | 2 | 7 | 1 | 0 | 0 | 0 | 2 | 12 | 0 | 12 | |||||||||||||||||||||||||||||||||
2265380 | 2265380 | GA | school | 1301740 | 644 | DeKalb County | 130174002642 | 503 | East DeKalb Special Education Center | Special Education School | No | High | 05 | 12 | 2021 | spring | grade_8 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | |||||||||||||||||||||||||||||||||
2266325 | 2266325 | GA | school | 1302070 | 654 | Evans County | 130207004287 | 197 | Second Chance | Regular School | No | Secondary | 07 | 11 | 2021 | spring | grade_8 | 2 | 0 | 1 | 0 | 0 | 0 | 0 | 3 | 0 | 3 | 2 | 0 | 1 | 0 | 0 | 0 | 0 | 3 | 0 | 3 | |||||||||||||||||||||||||||||||||
2272095 | 2272095 | GA | school | 721 | Richmond County | 391 | Alternative Education Center at Morgan | 2021 | spring | grade_8 | 1 | 5 | 0 | 0 | 0 | 0 | 0 | 6 | 0 | 6 | 1 | 5 | 0 | 0 | 0 | 0 | 0 | 6 | 0 | 6 | ||||||||||||||||||||||||||||||||||||||||
2272965 | 2272965 | GA | school | 1300001 | 741 | Troup County | 130000103620 | 207 | Ault Academy | Regular School | No | High | 07 | 12 | 2021 | spring | grade_8 | 2 | 3 | 1 | 0 | 0 | 0 | 0 | 6 | 0 | 6 | 2 | 3 | 1 | 0 | 0 | 0 | 0 | 6 | 0 | 6 | |||||||||||||||||||||||||||||||||
2273727 | 2273727 | GA | school | 1305850 | 759 | Worth County | 130585004231 | 197 | Worth County Achievement Center | Regular School | No | High | 07 | 12 | 2021 | spring | grade_8 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 3 | 0 | 3 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 3 | 0 | 3 | |||||||||||||||||||||||||||||||||
2274124 | 2274124 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012003558 | 1411 | B.E.S.T Academy | Regular School | No | High | 06 | 12 | 2021 | spring | grade_8 | 0 | 41 | 3 | 0 | 0 | 0 | 0 | 44 | 0 | 44 | 0 | 41 | 3 | 0 | 0 | 0 | 0 | 44 | 0 | 44 | |||||||||||||||||||||||||||||||||
2274887 | 2274887 | GA | school | 1300217 | 7830310 | State Charter Schools II- Fulton Leadership Academy | 130021703961 | 310 | Fulton Leadership Academy | Regular School | No | High | 06 | 12 | 2021 | spring | grade_8 | 0 | 69 | 1 | 0 | 0 | 0 | 2 | 72 | 0 | 72 | 0 | 69 | 1 | 0 | 0 | 0 | 2 | 72 | 0 | 72 | |||||||||||||||||||||||||||||||||
2274959 | 2274959 | GA | school | 1300248 | 7830615 | State Charter Schools II- Genesis Innovation Academy for Boys | 130024804288 | 615 | Genesis Innovation Academy for Boys | Regular School | No | Other | KG | 09 | 2021 | spring | grade_8 | 0 | 28 | 5 | 1 | 0 | 0 | 0 | 34 | 0 | 34 | 0 | 28 | 5 | 1 | 0 | 0 | 0 | 34 | 0 | 34 | |||||||||||||||||||||||||||||||||
2275409 | 2275409 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603806 | 1898 | Aaron Cohn Regional Youth Detention Center | Alternative School | No | Secondary | 07 | 11 | 2021 | spring | grade_8 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | |||||||||||||||||||||||||||||||||
2275410 | 2275410 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002604089 | 104 | Atlanta Youth Detention Center | Special Education School | No | High | 08 | 12 | 2021 | spring | grade_8 | 0 | 3 | 0 | 0 | 0 | 0 | 0 | 3 | 0 | 3 | 0 | 3 | 0 | 0 | 0 | 0 | 0 | 3 | 0 | 3 | |||||||||||||||||||||||||||||||||
2275411 | 2275411 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603498 | 1498 | Augusta Regional Youth Detention Center | Alternative School | No | Secondary | 08 | 10 | 2021 | spring | grade_8 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 2 | 0 | 2 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 2 | 0 | 2 | |||||||||||||||||||||||||||||||||
2275412 | 2275412 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603488 | 298 | Augusta Youth Development Campus | Alternative School | No | High | 08 | 12 | 2021 | spring | grade_8 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | |||||||||||||||||||||||||||||||||
2275413 | 2275413 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002604354 | 4205 | Cadwell RYDC | Special Education School | No | Secondary | 08 | 10 | 2021 | spring | grade_8 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | |||||||||||||||||||||||||||||||||
2275414 | 2275414 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603501 | 1798 | Claxton Regional Youth Detention Center | Alternative School | No | Secondary | 07 | 10 | 2021 | spring | grade_8 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | |||||||||||||||||||||||||||||||||
2275415 | 2275415 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603487 | 205 | Crisp RYDC | Alternative School | No | Secondary | 06 | 11 | 2021 | spring | grade_8 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | |||||||||||||||||||||||||||||||||
2275416 | 2275416 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603504 | 2098 | DeKalb Regional Youth Detention Center | Alternative School | No | Secondary | 09 | 10 | 2021 | spring | grade_8 | 0 | 4 | 0 | 0 | 0 | 0 | 0 | 4 | 0 | 4 | 0 | 4 | 0 | 0 | 0 | 0 | 0 | 4 | 0 | 4 | |||||||||||||||||||||||||||||||||
2275419 | 2275419 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603500 | 1698 | Martha K. Glaze Regional Youth Detention Center | Alternative School | No | High | 09 | 12 | 2021 | spring | grade_8 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | |||||||||||||||||||||||||||||||||
2275421 | 2275421 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603650 | 405 | Muscogee Youth Development Center | Alternative School | No | High | 08 | 12 | 2021 | spring | grade_8 | 2 | 6 | 0 | 0 | 0 | 0 | 0 | 8 | 0 | 8 | 2 | 6 | 0 | 0 | 0 | 0 | 0 | 8 | 0 | 8 | |||||||||||||||||||||||||||||||||
2275422 | 2275422 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002604141 | 414 | Rockdale RYDC | Special Education School | No | Secondary | 08 | 10 | 2021 | spring | grade_8 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | |||||||||||||||||||||||||||||||||
2275423 | 2275423 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603513 | 2998 | Savannah Regional Youth Detention Center | Alternative School | No | Secondary | 08 | 11 | 2021 | spring | grade_8 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | |||||||||||||||||||||||||||||||||
2275424 | 2275424 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603514 | 3098 | T J Loftiss II Regional Youth Detention Center | Alternative School | No | Secondary | 08 | 09 | 2021 | spring | grade_8 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | |||||||||||||||||||||||||||||||||
403493 | 403493 | GA | school | 1300440 | 612 | Bleckley County | 130044004162 | 115 | Bleckley County Success Academy | Regular School | No | High | 06 | 12 | 2021 | fall | grade_8 | 1 | 2 | 0 | 0 | 0 | 0 | 0 | 2 | 1 | 3 | 1 | 2 | 0 | 0 | 0 | 0 | 0 | 2 | 1 | 3 | |||||||||||||||||||||||||||||||||
404451 | 404451 | GA | school | 1301020 | 625 | Savannah-Chatham County | 130102004294 | 514 | School of Humanities at Juliette Gordon Low | Regular School | No | Other | PK | 12 | 2021 | fall | grade_8 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | |||||||||||||||||||||||||||||||||
407842 | 407842 | GA | school | 1301770 | 645 | Dodge County | 130177004186 | 292 | DAC (Dodge County Achievement Center) | Regular School | No | High | 08 | 12 | 2021 | fall | grade_8 | 1 | 2 | 0 | 0 | 0 | 0 | 0 | 2 | 1 | 3 | 1 | 2 | 0 | 0 | 0 | 0 | 0 | 2 | 1 | 3 | |||||||||||||||||||||||||||||||||
408170 | 408170 | GA | school | 1301860 | 648 | Douglas County | 130186003689 | 507 | Youth Villages at Inner Harbour | Regular School | No | Other | 02 | 11 | 2021 | fall | grade_8 | 0 | 3 | 0 | 0 | 0 | 0 | 0 | 2 | 1 | 3 | 0 | 3 | 0 | 0 | 0 | 0 | 0 | 2 | 1 | 3 | |||||||||||||||||||||||||||||||||
409468 | 409468 | GA | school | 1302280 | 660 | Fulton County | 130228004261 | 1321 | Wellspring Living | Regular School | No | High | 08 | 12 | 2021 | fall | grade_8 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | |||||||||||||||||||||||||||||||||
411201 | 411201 | GA | school | 1302610 | 669 | Hall County | 130261004305 | 392 | The Foundry | Regular School | No | High | 08 | 12 | 2021 | fall | grade_8 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 2 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 2 | |||||||||||||||||||||||||||||||||
411326 | 411326 | GA | school | 1302670 | 671 | Haralson County | 130267004310 | 198 | Haralson County Rebel Academy | Regular School | No | High | 08 | 12 | 2021 | fall | grade_8 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 1 | 3 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 1 | 3 | |||||||||||||||||||||||||||||||||
414175 | 414175 | GA | school | 721 | Richmond County | 391 | Alternative Education Center at Morgan | 2021 | fall | grade_8 | 1 | 9 | 0 | 0 | 0 | 0 | 0 | 9 | 1 | 10 | 1 | 9 | 0 | 0 | 0 | 0 | 0 | 9 | 1 | 10 | ||||||||||||||||||||||||||||||||||||||||
417498 | 417498 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002604269 | 4203 | Terrell Regional Youth Detention Center | Special Education School | No | Secondary | 08 | 11 | 2021 | fall | grade_8 | 1 | 2 | 0 | 0 | 0 | 0 | 0 | 2 | 1 | 3 | 1 | 2 | 0 | 0 | 0 | 0 | 0 | 2 | 1 | 3 | |||||||||||||||||||||||||||||||||
417499 | 417499 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603515 | 3198 | Waycross Regional Youth Detention Center | Alternative School | No | Secondary | 07 | 11 | 2021 | fall | grade_8 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | |||||||||||||||||||||||||||||||||
2262345 | 2262345 | GA | school | 1301020 | 625 | Savannah-Chatham County | 130102004294 | 514 | School of Humanities at Juliette Gordon Low | Regular School | No | Other | PK | 12 | 2021 | spring | grade_8 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | |||||||||||||||||||||||||||||||||
2265374 | 2265374 | GA | school | 1301740 | 644 | DeKalb County | 130174002313 | 500 | DeKalb Alternative School | Alternative School | No | High | 07 | 12 | 2021 | spring | grade_8 | 0 | 2 | 1 | 0 | 0 | 0 | 0 | 2 | 1 | 3 | 0 | 2 | 1 | 0 | 0 | 0 | 0 | 2 | 1 | 3 | |||||||||||||||||||||||||||||||||
2265386 | 2265386 | GA | school | 1301740 | 644 | DeKalb County | 130174003868 | 510 | Margaret Harris Comprehensive School | Regular School | No | Other | PK | 12 | 2021 | spring | grade_8 | 1 | 2 | 0 | 0 | 0 | 0 | 0 | 2 | 1 | 3 | 1 | 2 | 0 | 0 | 0 | 0 | 0 | 2 | 1 | 3 | |||||||||||||||||||||||||||||||||
2265737 | 2265737 | GA | school | 1301770 | 645 | Dodge County | 130177004186 | 292 | DAC (Dodge County Achievement Center) | Regular School | No | High | 08 | 12 | 2021 | spring | grade_8 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 2 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 2 | |||||||||||||||||||||||||||||||||
2267343 | 2267343 | GA | school | 1302280 | 660 | Fulton County | 130228003651 | 307 | Georgia Baptist Children's Home and Family Ministries | Regular School | No | Other | 04 | 11 | 2021 | spring | grade_8 | 0 | 2 | 1 | 0 | 0 | 0 | 0 | 2 | 1 | 3 | 0 | 2 | 1 | 0 | 0 | 0 | 0 | 2 | 1 | 3 | |||||||||||||||||||||||||||||||||
2267361 | 2267361 | GA | school | 1302280 | 660 | Fulton County | 130228004261 | 1321 | Wellspring Living | Regular School | No | High | 08 | 12 | 2021 | spring | grade_8 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | |||||||||||||||||||||||||||||||||
2267731 | 2267731 | GA | school | 1302400 | 663 | Glynn County | 130240003697 | 107 | Morningstar Treatment Services, Inc. Youth Estate | Regular School | No | High | 07 | 12 | 2021 | spring | grade_8 | 0 | 4 | 0 | 0 | 0 | 0 | 0 | 3 | 1 | 4 | 0 | 4 | 0 | 0 | 0 | 0 | 0 | 3 | 1 | 4 | |||||||||||||||||||||||||||||||||
2269224 | 2269224 | GA | school | 1302670 | 671 | Haralson County | 130267004310 | 198 | Haralson County Rebel Academy | Regular School | No | High | 08 | 12 | 2021 | spring | grade_8 | 4 | 0 | 0 | 0 | 0 | 0 | 1 | 4 | 1 | 5 | 4 | 0 | 0 | 0 | 0 | 0 | 1 | 4 | 1 | 5 | |||||||||||||||||||||||||||||||||
2274122 | 2274122 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012002798 | 403 | APS-Forrest Hills Academy | Alternative School | No | High | 07 | 12 | 2021 | spring | grade_8 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 2 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 2 | |||||||||||||||||||||||||||||||||
2274594 | 2274594 | GA | school | 1301870 | 774 | Dublin City | 130187004050 | 412 | Moore Street Facility | Regular School | No | High | 06 | 12 | 2021 | spring | grade_8 | 1 | 5 | 0 | 0 | 0 | 0 | 0 | 5 | 1 | 6 | 1 | 5 | 0 | 0 | 0 | 0 | 0 | 5 | 1 | 6 | |||||||||||||||||||||||||||||||||
2275417 | 2275417 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603509 | 2598 | Macon Regional Youth Detention Center | Alternative School | No | Secondary | 08 | 11 | 2021 | spring | grade_8 | 2 | 4 | 0 | 0 | 0 | 0 | 0 | 5 | 1 | 6 | 2 | 4 | 0 | 0 | 0 | 0 | 0 | 5 | 1 | 6 | |||||||||||||||||||||||||||||||||
2275418 | 2275418 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603490 | 598 | Macon Youth Development Campus | Alternative School | No | Secondary | 09 | 11 | 2021 | spring | grade_8 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | |||||||||||||||||||||||||||||||||
2275420 | 2275420 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603517 | 4198 | Metro Regional Youth Detention Center | Alternative School | No | Secondary | 06 | 11 | 2021 | spring | grade_8 | 0 | 4 | 0 | 0 | 0 | 0 | 0 | 3 | 1 | 4 | 0 | 4 | 0 | 0 | 0 | 0 | 0 | 3 | 1 | 4 | |||||||||||||||||||||||||||||||||
2275425 | 2275425 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002604269 | 4203 | Terrell Regional Youth Detention Center | Special Education School | No | Secondary | 08 | 11 | 2021 | spring | grade_8 | 1 | 2 | 0 | 0 | 0 | 0 | 0 | 2 | 1 | 3 | 1 | 2 | 0 | 0 | 0 | 0 | 0 | 2 | 1 | 3 | |||||||||||||||||||||||||||||||||
410613 | 410613 | GA | school | 1302550 | 667 | Gwinnett County | 130255004257 | 1817 | International Transition Center | Regular School | No | Secondary | 08 | 11 | 2021 | fall | grade_8 | 0 | 1 | 27 | 0 | 0 | 0 | 0 | 18 | 10 | 28 | 0 | 1 | 27 | 0 | 0 | 0 | 0 | 18 | 10 | 28 | |||||||||||||||||||||||||||||||||
414694 | 414694 | GA | school | 1304680 | 731 | Taliaferro County | 130468002514 | 102 | Taliaferro County School | Regular School | No | Other | PK | 12 | 2021 | fall | grade_8 | 3 | 11 | 1 | 0 | 0 | 0 | 0 | 5 | 10 | 15 | 3 | 11 | 1 | 0 | 0 | 0 | 0 | 5 | 10 | 15 | |||||||||||||||||||||||||||||||||
2272614 | 2272614 | GA | school | 1304680 | 731 | Taliaferro County | 130468002514 | 102 | Taliaferro County School | Regular School | No | Other | PK | 12 | 2021 | spring | grade_8 | 3 | 11 | 1 | 0 | 0 | 0 | 0 | 5 | 10 | 15 | 3 | 11 | 1 | 0 | 0 | 0 | 0 | 5 | 10 | 15 | |||||||||||||||||||||||||||||||||
411636 | 411636 | GA | school | 1302820 | 675 | Henry County | 130282001663 | 397 | Austin Road Middle School | Regular School | No | Middle | 06 | 08 | 2021 | fall | grade_8 | 15 | 176 | 27 | 0 | 1 | 0 | 9 | 128 | 100 | 228 | 15 | 176 | 27 | 0 | 1 | 0 | 9 | 128 | 100 | 228 | |||||||||||||||||||||||||||||||||
414188 | 414188 | GA | school | 1304380 | 721 | Richmond County | 130438002089 | 390 | Spirit Creek Middle School | Regular School | No | Middle | 06 | 08 | 2021 | fall | grade_8 | 10 | 172 | 14 | 0 | 0 | 1 | 6 | 103 | 100 | 203 | 10 | 172 | 14 | 0 | 0 | 1 | 6 | 103 | 100 | 203 | |||||||||||||||||||||||||||||||||
2267345 | 2267345 | GA | school | 1302280 | 660 | Fulton County | 130228001929 | 384 | Haynes Bridge Middle School | Regular School | No | Middle | 06 | 08 | 2021 | spring | grade_8 | 97 | 47 | 49 | 0 | 11 | 0 | 18 | 122 | 100 | 222 | 97 | 47 | 49 | 0 | 11 | 0 | 18 | 122 | 100 | 222 | |||||||||||||||||||||||||||||||||
2273164 | 2273164 | GA | school | 1305370 | 746 | Walker County | 130537003457 | 106 | Chattanooga Valley Middle School | Regular School | No | Middle | 06 | 08 | 2021 | spring | grade_8 | 172 | 8 | 3 | 0 | 1 | 0 | 10 | 94 | 100 | 194 | 172 | 8 | 3 | 0 | 1 | 0 | 10 | 94 | 100 | 194 | |||||||||||||||||||||||||||||||||
2273427 | 2273427 | GA | school | 1305550 | 751 | Wayne County | 130555000685 | 294 | Arthur Williams Middle School | Regular School | No | Middle | 06 | 08 | 2021 | spring | grade_8 | 126 | 43 | 10 | 1 | 4 | 0 | 14 | 98 | 100 | 198 | 126 | 43 | 10 | 1 | 4 | 0 | 14 | 98 | 100 | 198 | |||||||||||||||||||||||||||||||||
404978 | 404978 | GA | school | 1301170 | 629 | Clarke County | 130117000450 | 5058 | Hilsman Middle School | Regular School | No | Middle | 06 | 08 | 2021 | fall | grade_8 | 33 | 143 | 33 | 1 | 2 | 0 | 11 | 122 | 101 | 223 | 33 | 143 | 33 | 1 | 2 | 0 | 11 | 122 | 101 | 223 | |||||||||||||||||||||||||||||||||
412193 | 412193 | GA | school | 1303150 | 684 | Jones County | 130315003424 | 106 | Gray Station Middle School | Regular School | No | Middle | 06 | 08 | 2021 | fall | grade_8 | 140 | 54 | 4 | 0 | 1 | 1 | 10 | 109 | 101 | 210 | 140 | 54 | 4 | 0 | 1 | 1 | 10 | 109 | 101 | 210 | |||||||||||||||||||||||||||||||||
415506 | 415506 | GA | school | 1305550 | 751 | Wayne County | 130555000685 | 294 | Arthur Williams Middle School | Regular School | No | Middle | 06 | 08 | 2021 | fall | grade_8 | 127 | 40 | 10 | 1 | 4 | 0 | 14 | 95 | 101 | 196 | 127 | 40 | 10 | 1 | 4 | 0 | 14 | 95 | 101 | 196 | |||||||||||||||||||||||||||||||||
2269534 | 2269534 | GA | school | 1302820 | 675 | Henry County | 130282001663 | 397 | Austin Road Middle School | Regular School | No | Middle | 06 | 08 | 2021 | spring | grade_8 | 16 | 175 | 27 | 0 | 1 | 0 | 8 | 126 | 101 | 227 | 16 | 175 | 27 | 0 | 1 | 0 | 8 | 126 | 101 | 227 | |||||||||||||||||||||||||||||||||
2270094 | 2270094 | GA | school | 1303150 | 684 | Jones County | 130315003424 | 106 | Gray Station Middle School | Regular School | No | Middle | 06 | 08 | 2021 | spring | grade_8 | 141 | 58 | 5 | 0 | 1 | 1 | 8 | 113 | 101 | 214 | 141 | 58 | 5 | 0 | 1 | 1 | 8 | 113 | 101 | 214 | |||||||||||||||||||||||||||||||||
2274139 | 2274139 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012000017 | 173 | Long Middle School | Regular School | No | Middle | 06 | 08 | 2021 | spring | grade_8 | 1 | 198 | 17 | 0 | 0 | 0 | 3 | 118 | 101 | 219 | 1 | 198 | 17 | 0 | 0 | 0 | 3 | 118 | 101 | 219 | |||||||||||||||||||||||||||||||||
403036 | 403036 | GA | school | 1300290 | 607 | Barrow County | 130029001913 | 198 | Westside Middle School | Regular School | No | Middle | 06 | 08 | 2021 | fall | grade_8 | 101 | 23 | 53 | 1 | 9 | 0 | 10 | 95 | 102 | 197 | 101 | 23 | 53 | 1 | 9 | 0 | 10 | 95 | 102 | 197 | |||||||||||||||||||||||||||||||||
404453 | 404453 | GA | school | 1301020 | 625 | Savannah-Chatham County | 130102000393 | 124 | The STEM Academy at Bartlett | Regular School | No | Middle | 06 | 08 | 2021 | fall | grade_8 | 93 | 64 | 33 | 3 | 9 | 0 | 27 | 127 | 102 | 229 | 93 | 64 | 33 | 3 | 9 | 0 | 27 | 127 | 102 | 229 | |||||||||||||||||||||||||||||||||
413101 | 413101 | GA | school | 1303870 | 706 | Muscogee County | 130387003680 | 204 | Veterans Memorial Middle School | Regular School | No | Middle | 06 | 08 | 2021 | fall | grade_8 | 85 | 74 | 22 | 2 | 4 | 1 | 17 | 103 | 102 | 205 | 85 | 74 | 22 | 2 | 4 | 1 | 17 | 103 | 102 | 205 | |||||||||||||||||||||||||||||||||
415244 | 415244 | GA | school | 1305370 | 746 | Walker County | 130537001741 | 180 | LaFayette Middle School | Regular School | No | Middle | 06 | 08 | 2021 | fall | grade_8 | 174 | 7 | 8 | 0 | 3 | 0 | 15 | 105 | 102 | 207 | 174 | 7 | 8 | 0 | 3 | 0 | 15 | 105 | 102 | 207 | |||||||||||||||||||||||||||||||||
415421 | 415421 | GA | school | 1305430 | 748 | Ware County | 130543002204 | 295 | Waycross Middle School | Regular School | No | Middle | 06 | 08 | 2021 | fall | grade_8 | 61 | 108 | 7 | 0 | 3 | 0 | 13 | 90 | 102 | 192 | 61 | 108 | 7 | 0 | 3 | 0 | 13 | 90 | 102 | 192 | |||||||||||||||||||||||||||||||||
2260926 | 2260926 | GA | school | 1300290 | 607 | Barrow County | 130029001913 | 198 | Westside Middle School | Regular School | No | Middle | 06 | 08 | 2021 | spring | grade_8 | 98 | 28 | 56 | 1 | 11 | 0 | 10 | 102 | 102 | 204 | 98 | 28 | 56 | 1 | 11 | 0 | 10 | 102 | 102 | 204 | |||||||||||||||||||||||||||||||||
2262330 | 2262330 | GA | school | 1301020 | 625 | Savannah-Chatham County | 130102002019 | 311 | Coastal Middle School | Regular School | No | Middle | 06 | 08 | 2021 | spring | grade_8 | 115 | 68 | 12 | 0 | 15 | 0 | 7 | 115 | 102 | 217 | 115 | 68 | 12 | 0 | 15 | 0 | 7 | 115 | 102 | 217 | |||||||||||||||||||||||||||||||||
2271015 | 2271015 | GA | school | 1303870 | 706 | Muscogee County | 130387003680 | 204 | Veterans Memorial Middle School | Regular School | No | Middle | 06 | 08 | 2021 | spring | grade_8 | 84 | 77 | 22 | 2 | 4 | 1 | 16 | 104 | 102 | 206 | 84 | 77 | 22 | 2 | 4 | 1 | 16 | 104 | 102 | 206 | |||||||||||||||||||||||||||||||||
2272108 | 2272108 | GA | school | 1304380 | 721 | Richmond County | 130438002089 | 390 | Spirit Creek Middle School | Regular School | No | Middle | 06 | 08 | 2021 | spring | grade_8 | 10 | 172 | 20 | 1 | 0 | 1 | 3 | 105 | 102 | 207 | 10 | 172 | 20 | 1 | 0 | 1 | 3 | 105 | 102 | 207 | |||||||||||||||||||||||||||||||||
2273342 | 2273342 | GA | school | 1305430 | 748 | Ware County | 130543002204 | 295 | Waycross Middle School | Regular School | No | Middle | 06 | 08 | 2021 | spring | grade_8 | 65 | 107 | 7 | 0 | 3 | 0 | 12 | 92 | 102 | 194 | 65 | 107 | 7 | 0 | 3 | 0 | 12 | 92 | 102 | 194 | |||||||||||||||||||||||||||||||||
406695 | 406695 | GA | school | 1301500 | 638 | Coweta County | 130150002367 | 301 | Smokey Road Middle School | Regular School | No | Middle | 06 | 08 | 2021 | fall | grade_8 | 112 | 88 | 22 | 1 | 0 | 0 | 5 | 125 | 103 | 228 | 112 | 88 | 22 | 1 | 0 | 0 | 5 | 125 | 103 | 228 | |||||||||||||||||||||||||||||||||
408167 | 408167 | GA | school | 1301860 | 648 | Douglas County | 130186000861 | 5050 | Stewart Middle School | Regular School | No | Middle | 06 | 08 | 2021 | fall | grade_8 | 6 | 160 | 31 | 1 | 0 | 1 | 7 | 103 | 103 | 206 | 6 | 160 | 31 | 1 | 0 | 1 | 7 | 103 | 103 | 206 | |||||||||||||||||||||||||||||||||
413089 | 413089 | GA | school | 1303870 | 706 | Muscogee County | 130387004127 | 115 | Aaron Cohn Middle School | Regular School | No | Middle | 06 | 08 | 2021 | fall | grade_8 | 73 | 82 | 21 | 0 | 8 | 0 | 11 | 92 | 103 | 195 | 73 | 82 | 21 | 0 | 8 | 0 | 11 | 92 | 103 | 195 | |||||||||||||||||||||||||||||||||
414182 | 414182 | GA | school | 1304380 | 721 | Richmond County | 130438001559 | 1058 | Langford Middle School | Regular School | No | Middle | 06 | 08 | 2021 | fall | grade_8 | 21 | 177 | 9 | 1 | 2 | 3 | 4 | 114 | 103 | 217 | 21 | 177 | 9 | 1 | 2 | 3 | 4 | 114 | 103 | 217 | |||||||||||||||||||||||||||||||||
2262872 | 2262872 | GA | school | 1301170 | 629 | Clarke County | 130117000450 | 5058 | Hilsman Middle School | Regular School | No | Middle | 06 | 08 | 2021 | spring | grade_8 | 34 | 139 | 32 | 1 | 2 | 0 | 11 | 116 | 103 | 219 | 34 | 139 | 32 | 1 | 2 | 0 | 11 | 116 | 103 | 219 |
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]);