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_low_grade
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 | ||||||||||||||||||||||||||||||||||||||||
1266152 | 1266152 | GA | school | 1301740 | 644 | DeKalb County | 130174003613 | 707 | UHS of Laurel Heights | Regular School | No | Other | 01 | 12 | 2019 | fall | grade_9 | 10 | 4 | 0 | 0 | 0 | 0 | 0 | 5 | 9 | 14 | 10 | 4 | 0 | 0 | 0 | 0 | 0 | 5 | 9 | 14 | |||||||||||||||||||||||||||||||||
1274922 | 1274922 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012003660 | 207 | Hillside Conant School | Regular School | No | Other | 01 | 12 | 2019 | fall | grade_9 | 7 | 3 | 0 | 0 | 0 | 0 | 0 | 7 | 3 | 10 | 7 | 3 | 0 | 0 | 0 | 0 | 0 | 7 | 3 | 10 | |||||||||||||||||||||||||||||||||
2560326 | 2560326 | GA | school | 1301740 | 644 | DeKalb County | 130174003613 | 707 | UHS of Laurel Heights | Regular School | No | Other | 01 | 12 | 2019 | spring | grade_9 | 5 | 2 | 0 | 0 | 0 | 0 | 0 | 3 | 4 | 7 | 5 | 2 | 0 | 0 | 0 | 0 | 0 | 3 | 4 | 7 | |||||||||||||||||||||||||||||||||
2569106 | 2569106 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012003660 | 207 | Hillside Conant School | Regular School | No | Other | 01 | 12 | 2019 | spring | grade_9 | 5 | 1 | 0 | 0 | 0 | 0 | 1 | 4 | 3 | 7 | 5 | 1 | 0 | 0 | 0 | 0 | 1 | 4 | 3 | 7 | |||||||||||||||||||||||||||||||||
1263065 | 1263065 | GA | school | 1301020 | 625 | Savannah-Chatham County | 130102003610 | 107 | UHS of Savannah Coastal Harbor Treatment Center | Regular School | No | Other | 02 | 12 | 2019 | fall | grade_9 | 5 | 3 | 1 | 0 | 0 | 0 | 0 | 6 | 3 | 9 | 5 | 3 | 1 | 0 | 0 | 0 | 0 | 6 | 3 | 9 | |||||||||||||||||||||||||||||||||
1266797 | 1266797 | GA | school | 1301860 | 648 | Douglas County | 130186003689 | 507 | Youth Villages at Inner Harbour | Regular School | No | Other | 02 | 12 | 2019 | fall | grade_9 | 9 | 7 | 1 | 0 | 0 | 0 | 2 | 5 | 14 | 19 | 9 | 7 | 1 | 0 | 0 | 0 | 2 | 5 | 14 | 19 | |||||||||||||||||||||||||||||||||
2557249 | 2557249 | GA | school | 1301020 | 625 | Savannah-Chatham County | 130102003610 | 107 | UHS of Savannah Coastal Harbor Treatment Center | Regular School | No | Other | 02 | 12 | 2019 | spring | grade_9 | 9 | 3 | 0 | 0 | 1 | 0 | 0 | 8 | 5 | 13 | 9 | 3 | 0 | 0 | 1 | 0 | 0 | 8 | 5 | 13 | |||||||||||||||||||||||||||||||||
2560973 | 2560973 | GA | school | 1301860 | 648 | Douglas County | 130186003689 | 507 | Youth Villages at Inner Harbour | Regular School | No | Other | 02 | 12 | 2019 | spring | grade_9 | 7 | 10 | 2 | 0 | 0 | 0 | 1 | 7 | 13 | 20 | 7 | 10 | 2 | 0 | 0 | 0 | 1 | 7 | 13 | 20 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
1268097 | 1268097 | 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_9 | 2 | 7 | 1 | 0 | 0 | 0 | 1 | 5 | 6 | 11 | 2 | 7 | 1 | 0 | 0 | 0 | 1 | 5 | 6 | 11 | |||||||||||||||||||||||||||||||||
1269266 | 1269266 | GA | school | 1302550 | 667 | Gwinnett County | 130255004057 | 1214 | Gwinnett Online Campus | Regular School | No | Other | 04 | 12 | 2019 | fall | grade_9 | 22 | 5 | 13 | 0 | 4 | 0 | 4 | 22 | 26 | 48 | 22 | 5 | 13 | 0 | 4 | 0 | 4 | 22 | 26 | 48 | |||||||||||||||||||||||||||||||||
2562274 | 2562274 | 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_9 | 2 | 2 | 1 | 0 | 0 | 0 | 0 | 3 | 2 | 5 | 2 | 2 | 1 | 0 | 0 | 0 | 0 | 3 | 2 | 5 | |||||||||||||||||||||||||||||||||
2563445 | 2563445 | GA | school | 1302550 | 667 | Gwinnett County | 130255004057 | 1214 | Gwinnett Online Campus | Regular School | No | Other | 04 | 12 | 2019 | spring | grade_9 | 25 | 5 | 12 | 0 | 4 | 0 | 2 | 18 | 30 | 48 | 25 | 5 | 12 | 0 | 4 | 0 | 2 | 18 | 30 | 48 | |||||||||||||||||||||||||||||||||
1264544 | 1264544 | GA | school | 1301290 | 633 | Cobb County | 130129003679 | 807 | Devereux Ackerman Academy | Regular School | No | Middle | 05 | 11 | 2019 | fall | grade_9 | 6 | 29 | 1 | 0 | 0 | 0 | 0 | 19 | 17 | 36 | 6 | 29 | 1 | 0 | 0 | 0 | 0 | 19 | 17 | 36 | |||||||||||||||||||||||||||||||||
1268377 | 1268377 | GA | school | 1302370 | 662 | Glascock County | 130237001055 | 196 | Glascock County Middle/High School | Regular School | No | High | 05 | 12 | 2019 | fall | grade_9 | 34 | 1 | 0 | 0 | 0 | 0 | 1 | 20 | 16 | 36 | 34 | 1 | 0 | 0 | 0 | 0 | 1 | 20 | 16 | 36 | |||||||||||||||||||||||||||||||||
1273723 | 1273723 | GA | school | 1300001 | 741 | Troup County | 130000103620 | 207 | Ault Academy | Regular School | No | Secondary | 05 | 11 | 2019 | fall | grade_9 | 4 | 10 | 0 | 0 | 0 | 0 | 0 | 14 | 0 | 14 | 4 | 10 | 0 | 0 | 0 | 0 | 0 | 14 | 0 | 14 | |||||||||||||||||||||||||||||||||
2558727 | 2558727 | GA | school | 1301290 | 633 | Cobb County | 130129003679 | 807 | Devereux Ackerman Academy | Regular School | No | Middle | 05 | 11 | 2019 | spring | grade_9 | 10 | 22 | 0 | 0 | 0 | 0 | 0 | 17 | 15 | 32 | 10 | 22 | 0 | 0 | 0 | 0 | 0 | 17 | 15 | 32 | |||||||||||||||||||||||||||||||||
2562556 | 2562556 | GA | school | 1302370 | 662 | Glascock County | 130237001055 | 196 | Glascock County Middle/High School | Regular School | No | High | 05 | 12 | 2019 | spring | grade_9 | 36 | 1 | 0 | 0 | 0 | 0 | 1 | 22 | 16 | 38 | 36 | 1 | 0 | 0 | 0 | 0 | 1 | 22 | 16 | 38 | |||||||||||||||||||||||||||||||||
2567914 | 2567914 | GA | school | 1300001 | 741 | Troup County | 130000103620 | 207 | Ault Academy | Regular School | No | Secondary | 05 | 11 | 2019 | spring | grade_9 | 4 | 8 | 0 | 0 | 0 | 0 | 0 | 12 | 0 | 12 | 4 | 8 | 0 | 0 | 0 | 0 | 0 | 12 | 0 | 12 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
1263923 | 1263923 | GA | school | 1301230 | 631 | Clayton County | 130123003896 | 114 | Elite Scholars Academy School | Regular School | No | High | 06 | 12 | 2019 | fall | grade_9 | 0 | 90 | 12 | 0 | 8 | 0 | 4 | 46 | 68 | 114 | 0 | 90 | 12 | 0 | 8 | 0 | 4 | 46 | 68 | 114 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
1266149 | 1266149 | GA | school | 1301740 | 644 | DeKalb County | 130174004159 | 315 | Tapestry Public Charter School | Regular School | Yes | High | 06 | 12 | 2019 | fall | grade_9 | 21 | 18 | 7 | 0 | 0 | 0 | 1 | 30 | 17 | 47 | 21 | 18 | 7 | 0 | 0 | 0 | 1 | 30 | 17 | 47 | |||||||||||||||||||||||||||||||||
1267023 | 1267023 | GA | school | 1302040 | 653 | Emanuel County | 130204000905 | 2050 | Emanuel County Institute | Regular School | No | High | 06 | 12 | 2019 | fall | grade_9 | 56 | 28 | 2 | 0 | 0 | 0 | 5 | 49 | 42 | 91 | 56 | 28 | 2 | 0 | 0 | 0 | 5 | 49 | 42 | 91 | |||||||||||||||||||||||||||||||||
1267053 | 1267053 | GA | school | 1302070 | 654 | Evans County | 130207004287 | 197 | Second Chance | Regular School | No | High | 06 | 12 | 2019 | fall | grade_9 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 1 | 3 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 1 | 3 | |||||||||||||||||||||||||||||||||
1267510 | 1267510 | GA | school | 1302220 | 658 | Forsyth County | 130222003995 | 219 | Forsyth Virtual Academy | Regular School | No | High | 06 | 12 | 2019 | fall | grade_9 | 5 | 0 | 0 | 0 | 0 | 0 | 2 | 2 | 5 | 7 | 5 | 0 | 0 | 0 | 0 | 0 | 2 | 2 | 5 | 7 | |||||||||||||||||||||||||||||||||
1268458 | 1268458 | GA | school | 1302400 | 663 | Glynn County | 130240003697 | 107 | Morningstar Treatment Services, Inc. Youth Estate | Regular School | No | High | 06 | 12 | 2019 | fall | grade_9 | 6 | 7 | 0 | 0 | 0 | 0 | 0 | 8 | 5 | 13 | 6 | 7 | 0 | 0 | 0 | 0 | 0 | 8 | 5 | 13 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
1269265 | 1269265 | GA | school | 1302550 | 667 | Gwinnett County | 130255003690 | 1114 | Gwinnett Intervention Education Center (GIVE) West | Regular School | No | High | 06 | 12 | 2019 | fall | grade_9 | 3 | 28 | 46 | 1 | 1 | 0 | 1 | 62 | 18 | 80 | 3 | 28 | 46 | 1 | 1 | 0 | 1 | 62 | 18 | 80 | |||||||||||||||||||||||||||||||||
1270272 | 1270272 | GA | school | 1302820 | 675 | Henry County | 130282004214 | 804 | EXCEL Academy | Regular School | No | High | 06 | 12 | 2019 | fall | grade_9 | 7 | 21 | 2 | 0 | 0 | 0 | 2 | 25 | 7 | 32 | 7 | 21 | 2 | 0 | 0 | 0 | 2 | 25 | 7 | 32 | |||||||||||||||||||||||||||||||||
1270532 | 1270532 | GA | school | 1302880 | 676 | Houston County | 130288004150 | 116 | Houston County WIN Academy | Regular School | No | High | 06 | 12 | 2019 | fall | grade_9 | 6 | 25 | 3 | 0 | 0 | 0 | 1 | 21 | 14 | 35 | 6 | 25 | 3 | 0 | 0 | 0 | 1 | 21 | 14 | 35 | |||||||||||||||||||||||||||||||||
1271250 | 1271250 | GA | school | 1303540 | 696 | Marion County | 130354001346 | 275 | Marion County Middle/High School | Regular School | No | High | 06 | 12 | 2019 | fall | grade_9 | 43 | 28 | 18 | 0 | 0 | 0 | 0 | 48 | 41 | 89 | 43 | 28 | 18 | 0 | 0 | 0 | 0 | 48 | 41 | 89 | |||||||||||||||||||||||||||||||||
1271775 | 1271775 | GA | school | 1303870 | 706 | Muscogee County | 130387004270 | 502 | Rainey McCullers School of the Arts | Regular School | No | Secondary | 06 | 11 | 2019 | fall | grade_9 | 16 | 22 | 5 | 1 | 1 | 0 | 1 | 14 | 32 | 46 | 16 | 22 | 5 | 1 | 1 | 0 | 1 | 14 | 32 | 46 | |||||||||||||||||||||||||||||||||
1271776 | 1271776 | GA | school | 1303870 | 706 | Muscogee County | 130387001399 | 2067 | Rothschild Leadership Academy School | Regular School | No | Middle | 06 | 09 | 2019 | fall | grade_9 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | |||||||||||||||||||||||||||||||||
1272497 | 1272497 | GA | school | 1304200 | 715 | Polk County | 130420003614 | 207 | Harpst Academy | Regular School | No | High | 06 | 12 | 2019 | fall | grade_9 | 8 | 7 | 3 | 0 | 0 | 0 | 0 | 13 | 5 | 18 | 8 | 7 | 3 | 0 | 0 | 0 | 0 | 13 | 5 | 18 | |||||||||||||||||||||||||||||||||
1272861 | 1272861 | GA | school | 1304380 | 721 | Richmond County | 130438004211 | 391 | Alternative Education Center at Morgan | Regular School | No | High | 06 | 12 | 2019 | fall | grade_9 | 3 | 44 | 1 | 0 | 0 | 1 | 1 | 32 | 18 | 50 | 3 | 44 | 1 | 0 | 0 | 1 | 1 | 32 | 18 | 50 | |||||||||||||||||||||||||||||||||
1272864 | 1272864 | GA | school | 1304380 | 721 | Richmond County | 130438001567 | 4562 | Davidson Magnet School | Regular School | No | High | 06 | 12 | 2019 | fall | grade_9 | 48 | 53 | 7 | 0 | 3 | 1 | 1 | 24 | 89 | 113 | 48 | 53 | 7 | 0 | 3 | 1 | 1 | 24 | 89 | 113 | |||||||||||||||||||||||||||||||||
1272867 | 1272867 | GA | school | 1304380 | 721 | Richmond County | 130438001534 | 3556 | Johnson Magnet | Regular School | No | High | 06 | 12 | 2019 | fall | grade_9 | 28 | 65 | 8 | 1 | 1 | 0 | 4 | 51 | 56 | 107 | 28 | 65 | 8 | 1 | 1 | 0 | 4 | 51 | 56 | 107 | |||||||||||||||||||||||||||||||||
1272870 | 1272870 | GA | school | 1304380 | 721 | Richmond County | 130438003486 | 107 | Lighthouse Care Center of Augusta | Regular School | No | Secondary | 06 | 11 | 2019 | fall | grade_9 | 2 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 4 | 4 | 2 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 4 | 4 | |||||||||||||||||||||||||||||||||
1272872 | 1272872 | GA | school | 1304380 | 721 | Richmond County | 130438004069 | 213 | Richmond County Technical Career Magnet School | Regular School | No | High | 06 | 12 | 2019 | fall | grade_9 | 19 | 56 | 3 | 0 | 0 | 1 | 4 | 36 | 47 | 83 | 19 | 56 | 3 | 0 | 0 | 1 | 4 | 36 | 47 | 83 | |||||||||||||||||||||||||||||||||
1273122 | 1273122 | GA | school | 1304470 | 723 | Schley County | 130447002428 | 101 | Schley Middle High School | Regular School | No | High | 06 | 12 | 2019 | fall | grade_9 | 87 | 12 | 5 | 0 | 1 | 0 | 4 | 47 | 62 | 109 | 87 | 12 | 5 | 0 | 1 | 0 | 4 | 47 | 62 | 109 | |||||||||||||||||||||||||||||||||
1273155 | 1273155 | GA | school | 1304530 | 725 | Seminole County | 130453001391 | 196 | Seminole County Middle/High School | Regular School | No | High | 06 | 12 | 2019 | fall | grade_9 | 54 | 52 | 1 | 0 | 1 | 0 | 1 | 53 | 56 | 109 | 54 | 52 | 1 | 0 | 1 | 0 | 1 | 53 | 56 | 109 | |||||||||||||||||||||||||||||||||
1273640 | 1273640 | GA | school | 1305100 | 740 | Treutlen County | 130510001699 | 213 | Treutlen Middle/High School | Regular School | No | High | 06 | 12 | 2019 | fall | grade_9 | 57 | 29 | 1 | 0 | 0 | 0 | 2 | 45 | 44 | 89 | 57 | 29 | 1 | 0 | 0 | 0 | 2 | 45 | 44 | 89 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
1274486 | 1274486 | GA | school | 1305850 | 759 | Worth County | 130585004231 | 197 | Worth County Achievement Center | Regular School | No | High | 06 | 12 | 2019 | fall | grade_9 | 7 | 5 | 0 | 1 | 0 | 0 | 0 | 9 | 4 | 13 | 7 | 5 | 0 | 1 | 0 | 0 | 0 | 9 | 4 | 13 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
1274913 | 1274913 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012003558 | 1411 | B.E.S.T Academy | Regular School | No | High | 06 | 12 | 2019 | fall | grade_9 | 0 | 44 | 1 | 0 | 0 | 0 | 0 | 45 | 0 | 45 | 0 | 44 | 1 | 0 | 0 | 0 | 0 | 45 | 0 | 45 | |||||||||||||||||||||||||||||||||
1274916 | 1274916 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012004161 | 515 | Charles Drew Charter School JA/SA | Regular School | Yes | High | 06 | 12 | 2019 | fall | grade_9 | 13 | 114 | 3 | 0 | 1 | 0 | 5 | 76 | 60 | 136 | 13 | 114 | 3 | 0 | 1 | 0 | 5 | 76 | 60 | 136 | |||||||||||||||||||||||||||||||||
1274917 | 1274917 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012003980 | 1410 | Corretta Scott King Womens' Leadership Academy | Regular School | No | High | 06 | 12 | 2019 | fall | grade_9 | 0 | 54 | 3 | 0 | 0 | 0 | 2 | 0 | 59 | 59 | 0 | 54 | 3 | 0 | 0 | 0 | 2 | 0 | 59 | 59 | |||||||||||||||||||||||||||||||||
1275364 | 1275364 | GA | school | 1301870 | 774 | Dublin City | 130187004050 | 412 | Moore Street Facility | Regular School | No | High | 06 | 12 | 2019 | fall | grade_9 | 0 | 9 | 0 | 0 | 0 | 0 | 0 | 6 | 3 | 9 | 0 | 9 | 0 | 0 | 0 | 0 | 0 | 6 | 3 | 9 | |||||||||||||||||||||||||||||||||
1275568 | 1275568 | GA | school | 1300227 | 7820412 | State Charter Schools- Georgia Connections Academy | 130022704031 | 412 | Georgia Connections Academy | Regular School | Yes | High | 06 | 12 | 2019 | fall | grade_9 | 401 | 254 | 50 | 0 | 9 | 2 | 36 | 331 | 421 | 752 | 401 | 254 | 50 | 0 | 9 | 2 | 36 | 331 | 421 | 752 | |||||||||||||||||||||||||||||||||
1275630 | 1275630 | GA | school | 1300005 | 7830103 | State Charter Schools II- Statesboro STEAM Academy | 130000502626 | 103 | Statesboro STEAM Academy | Regular School | Yes | High | 06 | 12 | 2019 | fall | grade_9 | 15 | 9 | 1 | 1 | 0 | 0 | 0 | 17 | 9 | 26 | 15 | 9 | 1 | 1 | 0 | 0 | 0 | 17 | 9 | 26 | |||||||||||||||||||||||||||||||||
1275652 | 1275652 | GA | school | 1300217 | 7830310 | State Charter Schools II- Fulton Leadership Academy | 130021703961 | 310 | Fulton Leadership Academy | Regular School | Yes | High | 06 | 12 | 2019 | fall | grade_9 | 2 | 40 | 1 | 0 | 0 | 0 | 0 | 43 | 0 | 43 | 2 | 40 | 1 | 0 | 0 | 0 | 0 | 43 | 0 | 43 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
1276086 | 1276086 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002604269 | 4203 | Terrell Regional Youth Detention Center | Special Education School | No | Middle | 06 | 10 | 2019 | fall | grade_9 | 1 | 2 | 0 | 0 | 0 | 0 | 0 | 2 | 1 | 3 | 1 | 2 | 0 | 0 | 0 | 0 | 0 | 2 | 1 | 3 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
2556293 | 2556293 | GA | school | 1300440 | 612 | Bleckley County | 130044004162 | 115 | Bleckley County Success Academy | Regular School | No | High | 06 | 12 | 2019 | spring | grade_9 | 4 | 1 | 0 | 0 | 0 | 0 | 0 | 5 | 0 | 5 | 4 | 1 | 0 | 0 | 0 | 0 | 0 | 5 | 0 | 5 | |||||||||||||||||||||||||||||||||
2556361 | 2556361 | GA | school | 1300540 | 614 | Brooks County | 130054004264 | 394 | Delta Innovative School | Regular School | No | High | 06 | 12 | 2019 | spring | grade_9 | 6 | 28 | 2 | 0 | 0 | 0 | 1 | 24 | 13 | 37 | 6 | 28 | 2 | 0 | 0 | 0 | 1 | 24 | 13 | 37 | |||||||||||||||||||||||||||||||||
2556482 | 2556482 | GA | school | 1300630 | 616 | Bulloch County | 130063000281 | 4052 | Portal Middle/High School | Regular School | No | High | 06 | 12 | 2019 | spring | grade_9 | 38 | 16 | 4 | 0 | 0 | 1 | 4 | 31 | 32 | 63 | 38 | 16 | 4 | 0 | 0 | 1 | 4 | 31 | 32 | 63 | |||||||||||||||||||||||||||||||||
2558105 | 2558105 | GA | school | 1301230 | 631 | Clayton County | 130123003896 | 114 | Elite Scholars Academy School | Regular School | No | High | 06 | 12 | 2019 | spring | grade_9 | 0 | 77 | 12 | 0 | 7 | 0 | 3 | 38 | 61 | 99 | 0 | 77 | 12 | 0 | 7 | 0 | 3 | 38 | 61 | 99 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
2560323 | 2560323 | GA | school | 1301740 | 644 | DeKalb County | 130174004159 | 315 | Tapestry Public Charter School | Regular School | Yes | High | 06 | 12 | 2019 | spring | grade_9 | 20 | 18 | 6 | 0 | 0 | 0 | 1 | 28 | 17 | 45 | 20 | 18 | 6 | 0 | 0 | 0 | 1 | 28 | 17 | 45 | |||||||||||||||||||||||||||||||||
2561201 | 2561201 | GA | school | 1302040 | 653 | Emanuel County | 130204000905 | 2050 | Emanuel County Institute | Regular School | No | High | 06 | 12 | 2019 | spring | grade_9 | 51 | 27 | 2 | 0 | 0 | 0 | 4 | 46 | 38 | 84 | 51 | 27 | 2 | 0 | 0 | 0 | 4 | 46 | 38 | 84 | |||||||||||||||||||||||||||||||||
2561231 | 2561231 | GA | school | 1302070 | 654 | Evans County | 130207004287 | 197 | Second Chance | Regular School | No | High | 06 | 12 | 2019 | spring | grade_9 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | |||||||||||||||||||||||||||||||||
2561687 | 2561687 | GA | school | 1302220 | 658 | Forsyth County | 130222003995 | 219 | Forsyth Virtual Academy | Regular School | No | High | 06 | 12 | 2019 | spring | grade_9 | 7 | 0 | 1 | 0 | 0 | 0 | 2 | 5 | 5 | 10 | 7 | 0 | 1 | 0 | 0 | 0 | 2 | 5 | 5 | 10 | |||||||||||||||||||||||||||||||||
2562637 | 2562637 | GA | school | 1302400 | 663 | Glynn County | 130240003697 | 107 | Morningstar Treatment Services, Inc. Youth Estate | Regular School | No | High | 06 | 12 | 2019 | spring | grade_9 | 10 | 5 | 1 | 0 | 0 | 0 | 0 | 11 | 5 | 16 | 10 | 5 | 1 | 0 | 0 | 0 | 0 | 11 | 5 | 16 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
2563444 | 2563444 | GA | school | 1302550 | 667 | Gwinnett County | 130255003690 | 1114 | Gwinnett Intervention Education Center (GIVE) West | Regular School | No | High | 06 | 12 | 2019 | spring | grade_9 | 3 | 25 | 52 | 0 | 0 | 0 | 1 | 69 | 12 | 81 | 3 | 25 | 52 | 0 | 0 | 0 | 1 | 69 | 12 | 81 | |||||||||||||||||||||||||||||||||
2564454 | 2564454 | GA | school | 1302820 | 675 | Henry County | 130282004214 | 804 | EXCEL Academy | Regular School | No | High | 06 | 12 | 2019 | spring | grade_9 | 3 | 21 | 4 | 0 | 0 | 0 | 0 | 23 | 5 | 28 | 3 | 21 | 4 | 0 | 0 | 0 | 0 | 23 | 5 | 28 | |||||||||||||||||||||||||||||||||
2564714 | 2564714 | GA | school | 1302880 | 676 | Houston County | 130288004150 | 116 | Houston County WIN Academy | Regular School | No | High | 06 | 12 | 2019 | spring | grade_9 | 10 | 23 | 4 | 0 | 0 | 0 | 3 | 28 | 12 | 40 | 10 | 23 | 4 | 0 | 0 | 0 | 3 | 28 | 12 | 40 | |||||||||||||||||||||||||||||||||
2565431 | 2565431 | GA | school | 1303540 | 696 | Marion County | 130354001346 | 275 | Marion County Middle/High School | Regular School | No | High | 06 | 12 | 2019 | spring | grade_9 | 42 | 29 | 18 | 0 | 0 | 0 | 0 | 48 | 41 | 89 | 42 | 29 | 18 | 0 | 0 | 0 | 0 | 48 | 41 | 89 | |||||||||||||||||||||||||||||||||
2565966 | 2565966 | GA | school | 1303870 | 706 | Muscogee County | 130387004270 | 502 | Rainey McCullers School of the Arts | Regular School | No | Secondary | 06 | 11 | 2019 | spring | grade_9 | 16 | 22 | 5 | 1 | 1 | 0 | 1 | 14 | 32 | 46 | 16 | 22 | 5 | 1 | 1 | 0 | 1 | 14 | 32 | 46 | |||||||||||||||||||||||||||||||||
2566687 | 2566687 | GA | school | 1304200 | 715 | Polk County | 130420003614 | 207 | Harpst Academy | Regular School | No | High | 06 | 12 | 2019 | spring | grade_9 | 10 | 11 | 4 | 0 | 0 | 0 | 2 | 14 | 13 | 27 | 10 | 11 | 4 | 0 | 0 | 0 | 2 | 14 | 13 | 27 | |||||||||||||||||||||||||||||||||
2567051 | 2567051 | GA | school | 1304380 | 721 | Richmond County | 130438004211 | 391 | Alternative Education Center at Morgan | Regular School | No | High | 06 | 12 | 2019 | spring | grade_9 | 2 | 67 | 1 | 0 | 0 | 0 | 1 | 47 | 24 | 71 | 2 | 67 | 1 | 0 | 0 | 0 | 1 | 47 | 24 | 71 | |||||||||||||||||||||||||||||||||
2567054 | 2567054 | GA | school | 1304380 | 721 | Richmond County | 130438001567 | 4562 | Davidson Magnet School | Regular School | No | High | 06 | 12 | 2019 | spring | grade_9 | 48 | 53 | 7 | 0 | 3 | 1 | 1 | 24 | 89 | 113 | 48 | 53 | 7 | 0 | 3 | 1 | 1 | 24 | 89 | 113 | |||||||||||||||||||||||||||||||||
2567057 | 2567057 | GA | school | 1304380 | 721 | Richmond County | 130438001534 | 3556 | Johnson Magnet | Regular School | No | High | 06 | 12 | 2019 | spring | grade_9 | 27 | 55 | 8 | 1 | 1 | 0 | 4 | 47 | 49 | 96 | 27 | 55 | 8 | 1 | 1 | 0 | 4 | 47 | 49 | 96 | |||||||||||||||||||||||||||||||||
2567060 | 2567060 | GA | school | 1304380 | 721 | Richmond County | 130438003486 | 107 | Lighthouse Care Center of Augusta | Regular School | No | Secondary | 06 | 11 | 2019 | spring | grade_9 | 3 | 3 | 1 | 0 | 0 | 0 | 0 | 5 | 2 | 7 | 3 | 3 | 1 | 0 | 0 | 0 | 0 | 5 | 2 | 7 | |||||||||||||||||||||||||||||||||
2567062 | 2567062 | GA | school | 1304380 | 721 | Richmond County | 130438004069 | 213 | Richmond County Technical Career Magnet School | Regular School | No | High | 06 | 12 | 2019 | spring | grade_9 | 18 | 55 | 3 | 0 | 0 | 1 | 4 | 37 | 44 | 81 | 18 | 55 | 3 | 0 | 0 | 1 | 4 | 37 | 44 | 81 | |||||||||||||||||||||||||||||||||
2567312 | 2567312 | GA | school | 1304470 | 723 | Schley County | 130447002428 | 101 | Schley Middle High School | Regular School | No | High | 06 | 12 | 2019 | spring | grade_9 | 88 | 12 | 6 | 0 | 1 | 0 | 4 | 48 | 63 | 111 | 88 | 12 | 6 | 0 | 1 | 0 | 4 | 48 | 63 | 111 | |||||||||||||||||||||||||||||||||
2567345 | 2567345 | GA | school | 1304530 | 725 | Seminole County | 130453001391 | 196 | Seminole County Middle/High School | Regular School | No | High | 06 | 12 | 2019 | spring | grade_9 | 50 | 52 | 1 | 0 | 1 | 0 | 1 | 52 | 53 | 105 | 50 | 52 | 1 | 0 | 1 | 0 | 1 | 52 | 53 | 105 | |||||||||||||||||||||||||||||||||
2567830 | 2567830 | GA | school | 1305100 | 740 | Treutlen County | 130510001699 | 213 | Treutlen Middle/High School | Regular School | No | High | 06 | 12 | 2019 | spring | grade_9 | 53 | 29 | 1 | 0 | 0 | 0 | 2 | 41 | 44 | 85 | 53 | 29 | 1 | 0 | 0 | 0 | 2 | 41 | 44 | 85 | |||||||||||||||||||||||||||||||||
2568671 | 2568671 | GA | school | 1305850 | 759 | Worth County | 130585004231 | 197 | Worth County Achievement Center | Regular School | No | High | 06 | 12 | 2019 | spring | grade_9 | 5 | 5 | 0 | 0 | 0 | 0 | 1 | 7 | 4 | 11 | 5 | 5 | 0 | 0 | 0 | 0 | 1 | 7 | 4 | 11 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
2569097 | 2569097 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012003558 | 1411 | B.E.S.T Academy | Regular School | No | High | 06 | 12 | 2019 | spring | grade_9 | 0 | 36 | 1 | 0 | 0 | 0 | 0 | 37 | 0 | 37 | 0 | 36 | 1 | 0 | 0 | 0 | 0 | 37 | 0 | 37 | |||||||||||||||||||||||||||||||||
2569100 | 2569100 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012004161 | 515 | Charles Drew Charter School JA/SA | Regular School | Yes | High | 06 | 12 | 2019 | spring | grade_9 | 13 | 112 | 3 | 0 | 1 | 0 | 4 | 73 | 60 | 133 | 13 | 112 | 3 | 0 | 1 | 0 | 4 | 73 | 60 | 133 | |||||||||||||||||||||||||||||||||
2569101 | 2569101 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012003980 | 1410 | Corretta Scott King Womens' Leadership Academy | Regular School | No | High | 06 | 12 | 2019 | spring | grade_9 | 0 | 52 | 3 | 0 | 0 | 0 | 2 | 0 | 57 | 57 | 0 | 52 | 3 | 0 | 0 | 0 | 2 | 0 | 57 | 57 | |||||||||||||||||||||||||||||||||
2569548 | 2569548 | GA | school | 1301870 | 774 | Dublin City | 130187004050 | 412 | Moore Street Facility | Regular School | No | High | 06 | 12 | 2019 | spring | grade_9 | 0 | 7 | 0 | 0 | 0 | 0 | 1 | 5 | 3 | 8 | 0 | 7 | 0 | 0 | 0 | 0 | 1 | 5 | 3 | 8 | |||||||||||||||||||||||||||||||||
2569751 | 2569751 | GA | school | 1300227 | 7820412 | State Charter Schools- Georgia Connections Academy | 130022704031 | 412 | Georgia Connections Academy | Regular School | Yes | High | 06 | 12 | 2019 | spring | grade_9 | 292 | 205 | 35 | 0 | 7 | 2 | 27 | 240 | 328 | 568 | 292 | 205 | 35 | 0 | 7 | 2 | 27 | 240 | 328 | 568 | |||||||||||||||||||||||||||||||||
2569813 | 2569813 | GA | school | 1300005 | 7830103 | State Charter Schools II- Statesboro STEAM Academy | 130000502626 | 103 | Statesboro STEAM Academy | Regular School | Yes | High | 06 | 12 | 2019 | spring | grade_9 | 16 | 9 | 1 | 0 | 0 | 0 | 1 | 17 | 10 | 27 | 16 | 9 | 1 | 0 | 0 | 0 | 1 | 17 | 10 | 27 | |||||||||||||||||||||||||||||||||
2569835 | 2569835 | GA | school | 1300217 | 7830310 | State Charter Schools II- Fulton Leadership Academy | 130021703961 | 310 | Fulton Leadership Academy | Regular School | Yes | High | 06 | 12 | 2019 | spring | grade_9 | 2 | 37 | 1 | 0 | 0 | 0 | 0 | 40 | 0 | 40 | 2 | 37 | 1 | 0 | 0 | 0 | 0 | 40 | 0 | 40 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
2570274 | 2570274 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002604269 | 4203 | Terrell Regional Youth Detention Center | Special Education School | No | Middle | 06 | 10 | 2019 | spring | grade_9 | 0 | 4 | 0 | 0 | 0 | 0 | 0 | 3 | 1 | 4 | 0 | 4 | 0 | 0 | 0 | 0 | 0 | 3 | 1 | 4 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
1263924 | 1263924 | GA | school | 1301230 | 631 | Clayton County | 130123004279 | 378 | Eula Wilburn Ponds Perry Center for Learning | Regular School | No | High | 07 | 12 | 2019 | fall | grade_9 | 1 | 15 | 5 | 0 | 0 | 0 | 2 | 19 | 4 | 23 | 1 | 15 | 5 | 0 | 0 | 0 | 2 | 19 | 4 | 23 | |||||||||||||||||||||||||||||||||
1265516 | 1265516 | GA | school | 1301710 | 643 | Decatur County | 130171004170 | 116 | New Beginning Learning Center | Regular School | No | High | 07 | 12 | 2019 | fall | grade_9 | 5 | 15 | 2 | 0 | 0 | 0 | 0 | 17 | 5 | 22 | 5 | 15 | 2 | 0 | 0 | 0 | 0 | 17 | 5 | 22 |
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]);