enrollments
Data source: Big Local News · About: Big Local
1,008 rows where grade = "grade_9", state = "GA" and year = 2019 sorted by ccd_school_type
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2565573 | 2565573 | GA | school | 701 | Mitchell County | 298 | Eagle's Landing Academy | 2019 | spring | grade_9 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 2 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 2 | ||||||||||||||||||||||||||||||||||||||||
1263245 | 1263245 | GA | school | 1301080 | 627 | Chattooga County | 130108003571 | 111 | Chattooga Academy | Alternative School | No | Other | 03 | 12 | 2019 | fall | grade_9 | 6 | 0 | 1 | 0 | 0 | 0 | 1 | 6 | 2 | 8 | 6 | 0 | 1 | 0 | 0 | 0 | 1 | 6 | 2 | 8 | |||||||||||||||||||||||||||||||||
1266133 | 1266133 | GA | school | 1301740 | 644 | DeKalb County | 130174002313 | 500 | DeKalb Alternative School | Alternative School | No | High | 06 | 12 | 2019 | fall | grade_9 | 3 | 56 | 2 | 0 | 0 | 0 | 1 | 47 | 15 | 62 | 3 | 56 | 2 | 0 | 0 | 0 | 1 | 47 | 15 | 62 | |||||||||||||||||||||||||||||||||
1268099 | 1268099 | GA | school | 1302280 | 660 | Fulton County | 130228001958 | 386 | Independence High School | Alternative School | No | High | 09 | 12 | 2019 | fall | grade_9 | 1 | 0 | 6 | 0 | 0 | 0 | 0 | 4 | 3 | 7 | 1 | 0 | 6 | 0 | 0 | 0 | 0 | 4 | 3 | 7 | |||||||||||||||||||||||||||||||||
1269264 | 1269264 | GA | school | 1302550 | 667 | Gwinnett County | 130255000308 | 388 | Gwinnett InterVention Education (GIVE) Center East | Alternative School | No | High | 06 | 12 | 2019 | fall | grade_9 | 22 | 52 | 21 | 0 | 4 | 0 | 4 | 70 | 33 | 103 | 22 | 52 | 21 | 0 | 4 | 0 | 4 | 70 | 33 | 103 | |||||||||||||||||||||||||||||||||
1269279 | 1269279 | GA | school | 1302550 | 667 | Gwinnett County | 130255002039 | 189 | Phoenix High School | Alternative School | No | High | 09 | 12 | 2019 | fall | grade_9 | 3 | 16 | 29 | 0 | 0 | 0 | 2 | 22 | 28 | 50 | 3 | 16 | 29 | 0 | 0 | 0 | 2 | 22 | 28 | 50 | |||||||||||||||||||||||||||||||||
1273459 | 1273459 | GA | school | 1304830 | 734 | Telfair County | 130483004302 | 202 | Telfair Alternative Preparation School | Alternative School | No | High | 07 | 12 | 2019 | fall | grade_9 | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 3 | 1 | 4 | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 3 | 1 | 4 | |||||||||||||||||||||||||||||||||
1273502 | 1273502 | GA | school | 1304890 | 736 | Thomas County | 130489002342 | 100 | Bishop Hall Charter School | Alternative School | Yes | High | 08 | 12 | 2019 | fall | grade_9 | 38 | 14 | 4 | 0 | 0 | 0 | 1 | 30 | 27 | 57 | 38 | 14 | 4 | 0 | 0 | 0 | 1 | 30 | 27 | 57 | |||||||||||||||||||||||||||||||||
1273783 | 1273783 | GA | school | 1305190 | 742 | Turner County | 130519001714 | 1050 | Turner County Specialty School | Alternative School | No | Middle | 06 | 11 | 2019 | fall | grade_9 | 1 | 2 | 0 | 0 | 0 | 0 | 0 | 2 | 1 | 3 | 1 | 2 | 0 | 0 | 0 | 0 | 0 | 2 | 1 | 3 | |||||||||||||||||||||||||||||||||
1274911 | 1274911 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012002798 | 403 | APS-Forrest Hills Academy | Alternative School | No | High | 06 | 12 | 2019 | fall | grade_9 | 0 | 55 | 3 | 0 | 0 | 0 | 1 | 43 | 16 | 59 | 0 | 55 | 3 | 0 | 0 | 0 | 1 | 43 | 16 | 59 | |||||||||||||||||||||||||||||||||
1274918 | 1274918 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012000120 | 2664 | Crim High School | Alternative School | No | High | 09 | 12 | 2019 | fall | grade_9 | 0 | 44 | 1 | 0 | 0 | 0 | 0 | 24 | 21 | 45 | 0 | 44 | 1 | 0 | 0 | 0 | 0 | 24 | 21 | 45 | |||||||||||||||||||||||||||||||||
1276064 | 1276064 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603806 | 1898 | Aaron Cohn Regional Youth Detention Center | Alternative School | No | Secondary | 07 | 10 | 2019 | fall | grade_9 | 0 | 8 | 1 | 0 | 0 | 0 | 0 | 8 | 1 | 9 | 0 | 8 | 1 | 0 | 0 | 0 | 0 | 8 | 1 | 9 | |||||||||||||||||||||||||||||||||
1276066 | 1276066 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603498 | 1498 | Augusta Regional Youth Detention Center | Alternative School | No | Secondary | 06 | 11 | 2019 | fall | grade_9 | 0 | 5 | 0 | 0 | 0 | 0 | 0 | 5 | 0 | 5 | 0 | 5 | 0 | 0 | 0 | 0 | 0 | 5 | 0 | 5 | |||||||||||||||||||||||||||||||||
1276067 | 1276067 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603488 | 298 | Augusta Youth Development Campus | Alternative School | No | High | 07 | 12 | 2019 | fall | grade_9 | 7 | 19 | 0 | 0 | 0 | 0 | 0 | 26 | 0 | 26 | 7 | 19 | 0 | 0 | 0 | 0 | 0 | 26 | 0 | 26 | |||||||||||||||||||||||||||||||||
1276068 | 1276068 | 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_9 | 4 | 2 | 0 | 0 | 0 | 0 | 0 | 6 | 0 | 6 | 4 | 2 | 0 | 0 | 0 | 0 | 0 | 6 | 0 | 6 | |||||||||||||||||||||||||||||||||
1276069 | 1276069 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603501 | 1798 | Claxton Regional Youth Detention Center | Alternative School | No | Secondary | 07 | 11 | 2019 | fall | grade_9 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 2 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 2 | |||||||||||||||||||||||||||||||||
1276070 | 1276070 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603487 | 205 | Crisp RYDC | Alternative School | No | Secondary | 07 | 10 | 2019 | fall | grade_9 | 0 | 4 | 0 | 0 | 0 | 0 | 0 | 4 | 0 | 4 | 0 | 4 | 0 | 0 | 0 | 0 | 0 | 4 | 0 | 4 | |||||||||||||||||||||||||||||||||
1276071 | 1276071 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603504 | 2098 | DeKalb Regional Youth Detention Center | Alternative School | No | Secondary | 07 | 11 | 2019 | fall | grade_9 | 0 | 4 | 2 | 0 | 0 | 0 | 0 | 6 | 0 | 6 | 0 | 4 | 2 | 0 | 0 | 0 | 0 | 6 | 0 | 6 | |||||||||||||||||||||||||||||||||
1276072 | 1276072 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603505 | 2198 | Eastman Regional Youth Detention Center | Alternative School | No | Secondary | 08 | 11 | 2019 | fall | grade_9 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | |||||||||||||||||||||||||||||||||
1276073 | 1276073 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603492 | 898 | Eastman Youth Development Campus | Alternative School | No | High | 09 | 12 | 2019 | fall | grade_9 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | |||||||||||||||||||||||||||||||||
1276074 | 1276074 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603506 | 2298 | Gainesville Regional Youth Detention Center | Alternative School | No | Secondary | 09 | 11 | 2019 | fall | grade_9 | 0 | 2 | 1 | 0 | 0 | 0 | 0 | 3 | 0 | 3 | 0 | 2 | 1 | 0 | 0 | 0 | 0 | 3 | 0 | 3 | |||||||||||||||||||||||||||||||||
1276075 | 1276075 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603509 | 2598 | Macon Regional Youth Detention Center | Alternative School | No | Secondary | 07 | 10 | 2019 | fall | grade_9 | 1 | 4 | 0 | 0 | 0 | 0 | 0 | 4 | 1 | 5 | 1 | 4 | 0 | 0 | 0 | 0 | 0 | 4 | 1 | 5 | |||||||||||||||||||||||||||||||||
1276076 | 1276076 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603490 | 598 | Macon Youth Development Campus | Alternative School | No | High | 07 | 12 | 2019 | fall | grade_9 | 1 | 9 | 0 | 0 | 0 | 0 | 1 | 0 | 11 | 11 | 1 | 9 | 0 | 0 | 0 | 0 | 1 | 0 | 11 | 11 | |||||||||||||||||||||||||||||||||
1276077 | 1276077 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603510 | 2698 | Marietta Regional Youth Detention Center | Alternative School | No | Secondary | 08 | 11 | 2019 | fall | grade_9 | 2 | 4 | 1 | 0 | 0 | 1 | 0 | 7 | 1 | 8 | 2 | 4 | 1 | 0 | 0 | 1 | 0 | 7 | 1 | 8 | |||||||||||||||||||||||||||||||||
1276078 | 1276078 | 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_9 | 0 | 10 | 0 | 0 | 0 | 0 | 0 | 10 | 0 | 10 | 0 | 10 | 0 | 0 | 0 | 0 | 0 | 10 | 0 | 10 | |||||||||||||||||||||||||||||||||
1276079 | 1276079 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603517 | 4198 | Metro Regional Youth Detention Center | Alternative School | No | Secondary | 07 | 11 | 2019 | fall | grade_9 | 0 | 21 | 1 | 0 | 0 | 0 | 0 | 19 | 3 | 22 | 0 | 21 | 1 | 0 | 0 | 0 | 0 | 19 | 3 | 22 | |||||||||||||||||||||||||||||||||
1276081 | 1276081 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603650 | 405 | Muscogee Youth Development Center | Alternative School | No | High | 08 | 12 | 2019 | fall | grade_9 | 7 | 14 | 1 | 0 | 1 | 1 | 0 | 24 | 0 | 24 | 7 | 14 | 1 | 0 | 1 | 1 | 0 | 24 | 0 | 24 | |||||||||||||||||||||||||||||||||
1276083 | 1276083 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603513 | 2998 | Savannah Regional Youth Detention Center | Alternative School | No | Secondary | 08 | 11 | 2019 | fall | grade_9 | 1 | 5 | 1 | 0 | 0 | 0 | 1 | 8 | 0 | 8 | 1 | 5 | 1 | 0 | 0 | 0 | 1 | 8 | 0 | 8 | |||||||||||||||||||||||||||||||||
1276084 | 1276084 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603518 | 5001 | Sumter Youth Development Campus | Alternative School | No | High | 09 | 12 | 2019 | fall | grade_9 | 0 | 6 | 1 | 0 | 0 | 0 | 0 | 7 | 0 | 7 | 0 | 6 | 1 | 0 | 0 | 0 | 0 | 7 | 0 | 7 | |||||||||||||||||||||||||||||||||
1276085 | 1276085 | 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_9 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | |||||||||||||||||||||||||||||||||
1276087 | 1276087 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603515 | 3198 | Waycross Regional Youth Detention Center | Alternative School | No | Middle | 06 | 10 | 2019 | fall | grade_9 | 1 | 3 | 0 | 0 | 0 | 0 | 0 | 4 | 0 | 4 | 1 | 3 | 0 | 0 | 0 | 0 | 0 | 4 | 0 | 4 | |||||||||||||||||||||||||||||||||
2557429 | 2557429 | GA | school | 1301080 | 627 | Chattooga County | 130108003571 | 111 | Chattooga Academy | Alternative School | No | Other | 03 | 12 | 2019 | spring | grade_9 | 11 | 0 | 1 | 1 | 0 | 0 | 0 | 8 | 5 | 13 | 11 | 0 | 1 | 1 | 0 | 0 | 0 | 8 | 5 | 13 | |||||||||||||||||||||||||||||||||
2560307 | 2560307 | GA | school | 1301740 | 644 | DeKalb County | 130174002313 | 500 | DeKalb Alternative School | Alternative School | No | High | 06 | 12 | 2019 | spring | grade_9 | 3 | 55 | 10 | 0 | 1 | 0 | 1 | 49 | 21 | 70 | 3 | 55 | 10 | 0 | 1 | 0 | 1 | 49 | 21 | 70 | |||||||||||||||||||||||||||||||||
2562276 | 2562276 | GA | school | 1302280 | 660 | Fulton County | 130228001958 | 386 | Independence High School | Alternative School | No | High | 09 | 12 | 2019 | spring | grade_9 | 0 | 3 | 3 | 0 | 0 | 0 | 0 | 6 | 0 | 6 | 0 | 3 | 3 | 0 | 0 | 0 | 0 | 6 | 0 | 6 | |||||||||||||||||||||||||||||||||
2562279 | 2562279 | GA | school | 1302280 | 660 | Fulton County | 130228002037 | 383 | McClarin High School | Alternative School | No | High | 10 | 12 | 2019 | spring | grade_9 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 2 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 2 | |||||||||||||||||||||||||||||||||
2563443 | 2563443 | GA | school | 1302550 | 667 | Gwinnett County | 130255000308 | 388 | Gwinnett InterVention Education (GIVE) Center East | Alternative School | No | High | 06 | 12 | 2019 | spring | grade_9 | 17 | 61 | 28 | 0 | 3 | 0 | 5 | 79 | 35 | 114 | 17 | 61 | 28 | 0 | 3 | 0 | 5 | 79 | 35 | 114 | |||||||||||||||||||||||||||||||||
2563458 | 2563458 | GA | school | 1302550 | 667 | Gwinnett County | 130255002039 | 189 | Phoenix High School | Alternative School | No | High | 09 | 12 | 2019 | spring | grade_9 | 1 | 8 | 8 | 0 | 0 | 0 | 0 | 10 | 7 | 17 | 1 | 8 | 8 | 0 | 0 | 0 | 0 | 10 | 7 | 17 | |||||||||||||||||||||||||||||||||
2567649 | 2567649 | GA | school | 1304830 | 734 | Telfair County | 130483004302 | 202 | Telfair Alternative Preparation School | Alternative School | No | High | 07 | 12 | 2019 | spring | grade_9 | 2 | 5 | 0 | 0 | 0 | 0 | 0 | 6 | 1 | 7 | 2 | 5 | 0 | 0 | 0 | 0 | 0 | 6 | 1 | 7 | |||||||||||||||||||||||||||||||||
2567692 | 2567692 | GA | school | 1304890 | 736 | Thomas County | 130489002342 | 100 | Bishop Hall Charter School | Alternative School | Yes | High | 08 | 12 | 2019 | spring | grade_9 | 32 | 13 | 5 | 0 | 0 | 0 | 1 | 28 | 23 | 51 | 32 | 13 | 5 | 0 | 0 | 0 | 1 | 28 | 23 | 51 | |||||||||||||||||||||||||||||||||
2569095 | 2569095 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012002798 | 403 | APS-Forrest Hills Academy | Alternative School | No | High | 06 | 12 | 2019 | spring | grade_9 | 0 | 57 | 8 | 1 | 0 | 0 | 0 | 58 | 8 | 66 | 0 | 57 | 8 | 1 | 0 | 0 | 0 | 58 | 8 | 66 | |||||||||||||||||||||||||||||||||
2569102 | 2569102 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012000120 | 2664 | Crim High School | Alternative School | No | High | 09 | 12 | 2019 | spring | grade_9 | 0 | 32 | 1 | 0 | 0 | 0 | 0 | 18 | 15 | 33 | 0 | 32 | 1 | 0 | 0 | 0 | 0 | 18 | 15 | 33 | |||||||||||||||||||||||||||||||||
2570253 | 2570253 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603806 | 1898 | Aaron Cohn Regional Youth Detention Center | Alternative School | No | Secondary | 07 | 10 | 2019 | spring | grade_9 | 0 | 8 | 1 | 0 | 0 | 0 | 0 | 8 | 1 | 9 | 0 | 8 | 1 | 0 | 0 | 0 | 0 | 8 | 1 | 9 | |||||||||||||||||||||||||||||||||
2570255 | 2570255 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603498 | 1498 | Augusta Regional Youth Detention Center | Alternative School | No | Secondary | 06 | 11 | 2019 | spring | grade_9 | 2 | 7 | 0 | 0 | 0 | 0 | 0 | 9 | 0 | 9 | 2 | 7 | 0 | 0 | 0 | 0 | 0 | 9 | 0 | 9 | |||||||||||||||||||||||||||||||||
2570256 | 2570256 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603488 | 298 | Augusta Youth Development Campus | Alternative School | No | High | 07 | 12 | 2019 | spring | grade_9 | 6 | 13 | 2 | 0 | 0 | 0 | 0 | 21 | 0 | 21 | 6 | 13 | 2 | 0 | 0 | 0 | 0 | 21 | 0 | 21 | |||||||||||||||||||||||||||||||||
2570257 | 2570257 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603511 | 2798 | Bob Richards Regional Youth Detention Center | Alternative School | No | Middle | 07 | 09 | 2019 | spring | grade_9 | 2 | 3 | 0 | 0 | 0 | 0 | 0 | 5 | 0 | 5 | 2 | 3 | 0 | 0 | 0 | 0 | 0 | 5 | 0 | 5 | |||||||||||||||||||||||||||||||||
2570258 | 2570258 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603501 | 1798 | Claxton Regional Youth Detention Center | Alternative School | No | Secondary | 07 | 11 | 2019 | spring | grade_9 | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 4 | 0 | 4 | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 4 | 0 | 4 | |||||||||||||||||||||||||||||||||
2570259 | 2570259 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603487 | 205 | Crisp RYDC | Alternative School | No | Secondary | 07 | 10 | 2019 | spring | grade_9 | 0 | 2 | 0 | 0 | 0 | 1 | 0 | 3 | 0 | 3 | 0 | 2 | 0 | 0 | 0 | 1 | 0 | 3 | 0 | 3 | |||||||||||||||||||||||||||||||||
2570260 | 2570260 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603504 | 2098 | DeKalb Regional Youth Detention Center | Alternative School | No | Secondary | 07 | 11 | 2019 | spring | grade_9 | 0 | 5 | 0 | 0 | 0 | 0 | 0 | 5 | 0 | 5 | 0 | 5 | 0 | 0 | 0 | 0 | 0 | 5 | 0 | 5 | |||||||||||||||||||||||||||||||||
2570261 | 2570261 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603492 | 898 | Eastman Youth Development Campus | Alternative School | No | High | 09 | 12 | 2019 | spring | grade_9 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | |||||||||||||||||||||||||||||||||
2570262 | 2570262 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603503 | 1998 | Elbert Shaw Regional Youth Detention Center | Alternative School | No | Secondary | 10 | 10 | 2019 | spring | grade_9 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | |||||||||||||||||||||||||||||||||
2570263 | 2570263 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603506 | 2298 | Gainesville Regional Youth Detention Center | Alternative School | No | Secondary | 09 | 11 | 2019 | spring | grade_9 | 2 | 6 | 1 | 0 | 0 | 0 | 0 | 7 | 2 | 9 | 2 | 6 | 1 | 0 | 0 | 0 | 0 | 7 | 2 | 9 | |||||||||||||||||||||||||||||||||
2570264 | 2570264 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603509 | 2598 | Macon Regional Youth Detention Center | Alternative School | No | Secondary | 07 | 10 | 2019 | spring | grade_9 | 0 | 2 | 0 | 0 | 0 | 1 | 0 | 3 | 0 | 3 | 0 | 2 | 0 | 0 | 0 | 1 | 0 | 3 | 0 | 3 | |||||||||||||||||||||||||||||||||
2570265 | 2570265 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603490 | 598 | Macon Youth Development Campus | Alternative School | No | High | 07 | 12 | 2019 | spring | grade_9 | 0 | 6 | 1 | 0 | 0 | 0 | 0 | 0 | 7 | 7 | 0 | 6 | 1 | 0 | 0 | 0 | 0 | 0 | 7 | 7 | |||||||||||||||||||||||||||||||||
2570266 | 2570266 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603510 | 2698 | Marietta Regional Youth Detention Center | Alternative School | No | Secondary | 08 | 11 | 2019 | spring | grade_9 | 1 | 4 | 0 | 0 | 0 | 0 | 0 | 5 | 0 | 5 | 1 | 4 | 0 | 0 | 0 | 0 | 0 | 5 | 0 | 5 | |||||||||||||||||||||||||||||||||
2570267 | 2570267 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603500 | 1698 | Martha K. Glaze Regional Youth Detention Center | Alternative School | No | Secondary | 07 | 11 | 2019 | spring | grade_9 | 1 | 6 | 0 | 0 | 0 | 0 | 0 | 7 | 0 | 7 | 1 | 6 | 0 | 0 | 0 | 0 | 0 | 7 | 0 | 7 | |||||||||||||||||||||||||||||||||
2570268 | 2570268 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603517 | 4198 | Metro Regional Youth Detention Center | Alternative School | No | Secondary | 07 | 11 | 2019 | spring | grade_9 | 0 | 22 | 1 | 0 | 0 | 0 | 0 | 17 | 6 | 23 | 0 | 22 | 1 | 0 | 0 | 0 | 0 | 17 | 6 | 23 | |||||||||||||||||||||||||||||||||
2570270 | 2570270 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603650 | 405 | Muscogee Youth Development Center | Alternative School | No | High | 08 | 12 | 2019 | spring | grade_9 | 3 | 17 | 3 | 0 | 1 | 0 | 0 | 24 | 0 | 24 | 3 | 17 | 3 | 0 | 1 | 0 | 0 | 24 | 0 | 24 | |||||||||||||||||||||||||||||||||
2570272 | 2570272 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603513 | 2998 | Savannah Regional Youth Detention Center | Alternative School | No | Secondary | 08 | 11 | 2019 | spring | grade_9 | 0 | 5 | 1 | 0 | 0 | 0 | 0 | 6 | 0 | 6 | 0 | 5 | 1 | 0 | 0 | 0 | 0 | 6 | 0 | 6 | |||||||||||||||||||||||||||||||||
2570273 | 2570273 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603518 | 5001 | Sumter Youth Development Campus | Alternative School | No | High | 09 | 12 | 2019 | spring | grade_9 | 1 | 15 | 1 | 0 | 0 | 0 | 0 | 17 | 0 | 17 | 1 | 15 | 1 | 0 | 0 | 0 | 0 | 17 | 0 | 17 | |||||||||||||||||||||||||||||||||
2570275 | 2570275 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603515 | 3198 | Waycross Regional Youth Detention Center | Alternative School | No | Middle | 06 | 10 | 2019 | spring | grade_9 | 0 | 5 | 0 | 0 | 0 | 0 | 0 | 4 | 1 | 5 | 0 | 5 | 0 | 0 | 0 | 0 | 0 | 4 | 1 | 5 | |||||||||||||||||||||||||||||||||
1261458 | 1261458 | GA | school | 1300060 | 601 | Appling County | 130006000010 | 103 | Appling County High School | Regular School | No | High | 09 | 12 | 2019 | fall | grade_9 | 163 | 60 | 30 | 1 | 2 | 0 | 8 | 146 | 118 | 264 | 163 | 60 | 30 | 1 | 2 | 0 | 8 | 146 | 118 | 264 | |||||||||||||||||||||||||||||||||
1261487 | 1261487 | GA | school | 1300090 | 602 | Atkinson County | 130009000015 | 103 | Atkinson County High School | Regular School | No | High | 09 | 12 | 2019 | fall | grade_9 | 58 | 22 | 39 | 0 | 0 | 0 | 3 | 66 | 56 | 122 | 58 | 22 | 39 | 0 | 0 | 0 | 3 | 66 | 56 | 122 | |||||||||||||||||||||||||||||||||
1261507 | 1261507 | GA | school | 1300150 | 603 | Bacon County | 130015002357 | 302 | Bacon County High School | Regular School | No | High | 09 | 12 | 2019 | fall | grade_9 | 107 | 38 | 23 | 0 | 0 | 0 | 4 | 75 | 97 | 172 | 107 | 38 | 23 | 0 | 0 | 0 | 4 | 75 | 97 | 172 | |||||||||||||||||||||||||||||||||
1261525 | 1261525 | GA | school | 1300180 | 604 | Baker County | 130018001867 | 105 | Baker County K12 School | Regular School | No | Other | PK | 12 | 2019 | fall | grade_9 | 9 | 10 | 1 | 0 | 0 | 0 | 2 | 13 | 9 | 22 | 9 | 10 | 1 | 0 | 0 | 0 | 2 | 13 | 9 | 22 | |||||||||||||||||||||||||||||||||
1261545 | 1261545 | GA | school | 1300210 | 605 | Baldwin County | 130021000158 | 189 | Baldwin High School | Regular School | No | High | 09 | 12 | 2019 | fall | grade_9 | 86 | 279 | 9 | 0 | 5 | 0 | 8 | 197 | 190 | 387 | 86 | 279 | 9 | 0 | 5 | 0 | 8 | 197 | 190 | 387 | |||||||||||||||||||||||||||||||||
1261566 | 1261566 | GA | school | 1300240 | 606 | Banks County | 130024000169 | 199 | Banks County High School | Regular School | No | High | 09 | 12 | 2019 | fall | grade_9 | 171 | 5 | 25 | 0 | 2 | 0 | 5 | 98 | 110 | 208 | 171 | 5 | 25 | 0 | 2 | 0 | 5 | 98 | 110 | 208 | |||||||||||||||||||||||||||||||||
1261636 | 1261636 | GA | school | 1300290 | 607 | Barrow County | 130029002350 | 101 | Apalachee High School | Regular School | No | High | 09 | 12 | 2019 | fall | grade_9 | 317 | 82 | 100 | 2 | 20 | 0 | 34 | 288 | 267 | 555 | 317 | 82 | 100 | 2 | 20 | 0 | 34 | 288 | 267 | 555 | |||||||||||||||||||||||||||||||||
1261637 | 1261637 | GA | school | 1300290 | 607 | Barrow County | 130029000173 | 3052 | Winder-Barrow High School | Regular School | No | High | 09 | 12 | 2019 | fall | grade_9 | 367 | 74 | 106 | 2 | 31 | 0 | 22 | 328 | 274 | 602 | 367 | 74 | 106 | 2 | 31 | 0 | 22 | 328 | 274 | 602 | |||||||||||||||||||||||||||||||||
1261752 | 1261752 | GA | school | 1300330 | 608 | Bartow County | 130033002352 | 105 | Adairsville High School | Regular School | No | High | 09 | 12 | 2019 | fall | grade_9 | 227 | 24 | 20 | 0 | 0 | 0 | 15 | 147 | 139 | 286 | 227 | 24 | 20 | 0 | 0 | 0 | 15 | 147 | 139 | 286 | |||||||||||||||||||||||||||||||||
1261753 | 1261753 | GA | school | 1300330 | 608 | Bartow County | 130033000181 | 114 | Cass High School | Regular School | No | High | 09 | 12 | 2019 | fall | grade_9 | 258 | 72 | 74 | 0 | 8 | 0 | 21 | 226 | 207 | 433 | 258 | 72 | 74 | 0 | 8 | 0 | 21 | 226 | 207 | 433 | |||||||||||||||||||||||||||||||||
1261754 | 1261754 | GA | school | 1300330 | 608 | Bartow County | 130033001914 | 198 | Woodland High School | Regular School | No | High | 09 | 12 | 2019 | fall | grade_9 | 338 | 30 | 63 | 0 | 2 | 0 | 22 | 240 | 215 | 455 | 338 | 30 | 63 | 0 | 2 | 0 | 22 | 240 | 215 | 455 | |||||||||||||||||||||||||||||||||
1261809 | 1261809 | GA | school | 1300360 | 609 | Ben Hill County | 130036000931 | 291 | Fitzgerald High School | Regular School | No | High | 09 | 12 | 2019 | fall | grade_9 | 103 | 87 | 36 | 1 | 1 | 0 | 9 | 124 | 113 | 237 | 103 | 87 | 36 | 1 | 1 | 0 | 9 | 124 | 113 | 237 | |||||||||||||||||||||||||||||||||
1261830 | 1261830 | GA | school | 1300390 | 610 | Berrien County | 130039003523 | 106 | Berrien Academy Performance Learning Center | Regular School | Yes | High | 09 | 12 | 2019 | fall | grade_9 | 19 | 1 | 1 | 0 | 0 | 0 | 0 | 11 | 10 | 21 | 19 | 1 | 1 | 0 | 0 | 0 | 0 | 11 | 10 | 21 | |||||||||||||||||||||||||||||||||
1261831 | 1261831 | GA | school | 1300390 | 610 | Berrien County | 130039000192 | 101 | Berrien High School | Regular School | No | High | 09 | 12 | 2019 | fall | grade_9 | 177 | 32 | 23 | 2 | 0 | 0 | 7 | 135 | 106 | 241 | 177 | 32 | 23 | 2 | 0 | 0 | 7 | 135 | 106 | 241 | |||||||||||||||||||||||||||||||||
1262002 | 1262002 | GA | school | 1300420 | 611 | Bibb County | 130042004176 | 117 | Academy For Classical Education | Regular School | Yes | Other | KG | 12 | 2019 | fall | grade_9 | 90 | 23 | 6 | 0 | 13 | 0 | 4 | 73 | 63 | 136 | 90 | 23 | 6 | 0 | 13 | 0 | 4 | 73 | 63 | 136 | |||||||||||||||||||||||||||||||||
1262003 | 1262003 | GA | school | 1300420 | 611 | Bibb County | 130042001942 | 186 | Central High School | Regular School | No | High | 09 | 12 | 2019 | fall | grade_9 | 17 | 318 | 11 | 0 | 2 | 0 | 7 | 176 | 179 | 355 | 17 | 318 | 11 | 0 | 2 | 0 | 7 | 176 | 179 | 355 | |||||||||||||||||||||||||||||||||
1262004 | 1262004 | GA | school | 1300420 | 611 | Bibb County | 130042003726 | 105 | Howard High School | Regular School | No | High | 09 | 12 | 2019 | fall | grade_9 | 79 | 238 | 19 | 0 | 17 | 0 | 8 | 191 | 170 | 361 | 79 | 238 | 19 | 0 | 17 | 0 | 8 | 191 | 170 | 361 | |||||||||||||||||||||||||||||||||
1262005 | 1262005 | GA | school | 1300420 | 611 | Bibb County | 130042001943 | 286 | Northeast High School | Regular School | No | High | 09 | 12 | 2019 | fall | grade_9 | 4 | 218 | 2 | 0 | 0 | 0 | 5 | 136 | 93 | 229 | 4 | 218 | 2 | 0 | 0 | 0 | 5 | 136 | 93 | 229 | |||||||||||||||||||||||||||||||||
1262006 | 1262006 | GA | school | 1300420 | 611 | Bibb County | 130042002610 | 204 | Rutland High School | Regular School | No | High | 09 | 12 | 2019 | fall | grade_9 | 99 | 148 | 38 | 0 | 6 | 0 | 7 | 152 | 146 | 298 | 99 | 148 | 38 | 0 | 6 | 0 | 7 | 152 | 146 | 298 | |||||||||||||||||||||||||||||||||
1262007 | 1262007 | GA | school | 1300420 | 611 | Bibb County | 130042001944 | 386 | Southwest High School | Regular School | No | High | 09 | 12 | 2019 | fall | grade_9 | 10 | 302 | 7 | 0 | 0 | 1 | 1 | 172 | 149 | 321 | 10 | 302 | 7 | 0 | 0 | 1 | 1 | 172 | 149 | 321 | |||||||||||||||||||||||||||||||||
1262008 | 1262008 | GA | school | 1300420 | 611 | Bibb County | 130042001918 | 198 | Westside High School | Regular School | No | High | 09 | 12 | 2019 | fall | grade_9 | 17 | 349 | 11 | 0 | 5 | 1 | 5 | 198 | 190 | 388 | 17 | 349 | 11 | 0 | 5 | 1 | 5 | 198 | 190 | 388 | |||||||||||||||||||||||||||||||||
1262107 | 1262107 | GA | school | 1300440 | 612 | Bleckley County | 130044000253 | 105 | Bleckley County High School | Regular School | No | High | 09 | 12 | 2019 | fall | grade_9 | 117 | 46 | 7 | 0 | 0 | 0 | 8 | 76 | 102 | 178 | 117 | 46 | 7 | 0 | 0 | 0 | 8 | 76 | 102 | 178 | |||||||||||||||||||||||||||||||||
1262108 | 1262108 | GA | school | 1300440 | 612 | Bleckley County | 130044004162 | 115 | Bleckley County Success Academy | Regular School | No | High | 06 | 12 | 2019 | fall | grade_9 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | |||||||||||||||||||||||||||||||||
1262139 | 1262139 | GA | school | 1300480 | 613 | Brantley County | 130048000258 | 1050 | Brantley County High School | Regular School | No | High | 09 | 12 | 2019 | fall | grade_9 | 260 | 9 | 3 | 0 | 1 | 0 | 1 | 131 | 143 | 274 | 260 | 9 | 3 | 0 | 1 | 0 | 1 | 131 | 143 | 274 | |||||||||||||||||||||||||||||||||
1262175 | 1262175 | GA | school | 1300540 | 614 | Brooks County | 130054000263 | 110 | Brooks County High School | Regular School | No | High | 09 | 12 | 2019 | fall | grade_9 | 43 | 75 | 14 | 0 | 2 | 0 | 6 | 74 | 66 | 140 | 43 | 75 | 14 | 0 | 2 | 0 | 6 | 74 | 66 | 140 | |||||||||||||||||||||||||||||||||
1262176 | 1262176 | GA | school | 1300540 | 614 | Brooks County | 130054004264 | 394 | Delta Innovative School | Regular School | No | High | 06 | 12 | 2019 | fall | grade_9 | 5 | 23 | 1 | 0 | 0 | 0 | 1 | 20 | 10 | 30 | 5 | 23 | 1 | 0 | 0 | 0 | 1 | 20 | 10 | 30 | |||||||||||||||||||||||||||||||||
1262213 | 1262213 | GA | school | 1300570 | 615 | Bryan County | 130057002396 | 502 | Bryan County High School | Regular School | No | High | 09 | 12 | 2019 | fall | grade_9 | 109 | 45 | 7 | 0 | 1 | 0 | 10 | 95 | 77 | 172 | 109 | 45 | 7 | 0 | 1 | 0 | 10 | 95 | 77 | 172 | |||||||||||||||||||||||||||||||||
1262214 | 1262214 | GA | school | 1300570 | 615 | Bryan County | 130057001873 | 182 | Richmond Hill High School | Regular School | No | High | 09 | 12 | 2019 | fall | grade_9 | 407 | 95 | 56 | 1 | 20 | 1 | 47 | 351 | 276 | 627 | 407 | 95 | 56 | 1 | 20 | 1 | 47 | 351 | 276 | 627 | |||||||||||||||||||||||||||||||||
1262297 | 1262297 | GA | school | 1300630 | 616 | Bulloch County | 130063000281 | 4052 | Portal Middle/High School | Regular School | No | High | 06 | 12 | 2019 | fall | grade_9 | 39 | 18 | 4 | 0 | 0 | 1 | 4 | 32 | 34 | 66 | 39 | 18 | 4 | 0 | 0 | 1 | 4 | 32 | 34 | 66 | |||||||||||||||||||||||||||||||||
1262298 | 1262298 | GA | school | 1300630 | 616 | Bulloch County | 130063003550 | 203 | Southeast Bulloch High School | Regular School | No | High | 09 | 12 | 2019 | fall | grade_9 | 248 | 36 | 14 | 0 | 0 | 0 | 10 | 171 | 137 | 308 | 248 | 36 | 14 | 0 | 0 | 0 | 10 | 171 | 137 | 308 | |||||||||||||||||||||||||||||||||
1262299 | 1262299 | GA | school | 1300630 | 616 | Bulloch County | 130063000285 | 2054 | Statesboro High School | Regular School | No | High | 09 | 12 | 2019 | fall | grade_9 | 174 | 312 | 44 | 1 | 7 | 2 | 14 | 286 | 268 | 554 | 174 | 312 | 44 | 1 | 7 | 2 | 14 | 286 | 268 | 554 | |||||||||||||||||||||||||||||||||
1262351 | 1262351 | GA | school | 1300660 | 617 | Burke County | 130066001991 | 288 | Burke County High School | Regular School | No | High | 09 | 12 | 2019 | fall | grade_9 | 120 | 262 | 8 | 0 | 2 | 0 | 12 | 217 | 187 | 404 | 120 | 262 | 8 | 0 | 2 | 0 | 12 | 217 | 187 | 404 | |||||||||||||||||||||||||||||||||
1262382 | 1262382 | GA | school | 1300690 | 618 | Butts County | 130069000301 | 190 | Jackson High School | Regular School | No | High | 09 | 12 | 2019 | fall | grade_9 | 153 | 87 | 9 | 0 | 1 | 0 | 6 | 126 | 130 | 256 | 153 | 87 | 9 | 0 | 1 | 0 | 6 | 126 | 130 | 256 | |||||||||||||||||||||||||||||||||
1262405 | 1262405 | GA | school | 1300750 | 619 | Calhoun County | 130075004081 | 113 | Calhoun County High School | Regular School | No | High | 09 | 12 | 2019 | fall | grade_9 | 0 | 41 | 0 | 0 | 0 | 0 | 0 | 20 | 21 | 41 | 0 | 41 | 0 | 0 | 0 | 0 | 0 | 20 | 21 | 41 | |||||||||||||||||||||||||||||||||
1262465 | 1262465 | GA | school | 1300780 | 620 | Camden County | 130078000315 | 295 | Camden County High School | Regular School | No | High | 09 | 12 | 2019 | fall | grade_9 | 406 | 169 | 67 | 4 | 12 | 2 | 45 | 371 | 334 | 705 | 406 | 169 | 67 | 4 | 12 | 2 | 45 | 371 | 334 | 705 | |||||||||||||||||||||||||||||||||
1262507 | 1262507 | GA | school | 1300810 | 621 | Candler County | 130081000317 | 101 | Metter High School | Regular School | No | High | 09 | 12 | 2019 | fall | grade_9 | 94 | 61 | 43 | 0 | 1 | 0 | 3 | 113 | 89 | 202 | 94 | 61 | 43 | 0 | 1 | 0 | 3 | 113 | 89 | 202 | |||||||||||||||||||||||||||||||||
1262611 | 1262611 | GA | school | 1300840 | 622 | Carroll County | 130084000330 | 3050 | Bowdon High School | Regular School | No | High | 09 | 12 | 2019 | fall | grade_9 | 83 | 13 | 6 | 0 | 0 | 0 | 9 | 65 | 46 | 111 | 83 | 13 | 6 | 0 | 0 | 0 | 9 | 65 | 46 | 111 | |||||||||||||||||||||||||||||||||
1262612 | 1262612 | GA | school | 1300840 | 622 | Carroll County | 130084000331 | 2052 | Central High School | Regular School | No | High | 09 | 12 | 2019 | fall | grade_9 | 226 | 32 | 32 | 1 | 0 | 0 | 10 | 154 | 147 | 301 | 226 | 32 | 32 | 1 | 0 | 0 | 10 | 154 | 147 | 301 | |||||||||||||||||||||||||||||||||
1262613 | 1262613 | GA | school | 1300840 | 622 | Carroll County | 130084003483 | 112 | KidsPeace | Regular School | No | High | 07 | 12 | 2019 | fall | grade_9 | 7 | 15 | 1 | 0 | 0 | 0 | 1 | 14 | 10 | 24 | 7 | 15 | 1 | 0 | 0 | 0 | 1 | 14 | 10 | 24 | |||||||||||||||||||||||||||||||||
1262614 | 1262614 | GA | school | 1300840 | 622 | Carroll County | 130084003582 | 212 | Mt. Zion High School | Regular School | No | High | 09 | 12 | 2019 | fall | grade_9 | 96 | 8 | 9 | 1 | 1 | 0 | 6 | 55 | 66 | 121 | 96 | 8 | 9 | 1 | 1 | 0 | 6 | 55 | 66 | 121 |
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]);