enrollments
Data source: Big Local News · About: Big Local
1,205 rows where grade = "grade_8", state = "GA" and year = 2018 sorted by male
This data as json, CSV (advanced)
Link | rowid | state | county | county_state_id | admin_level | district_nces_id | district_state_id | district_state_type | district | school_nces_id | school_state_id | school | school_state_type | ccd_school_type | ccd_charter_school | ccd_school_lvl | ccd_school_low_grade | ccd_school_high_grade | year | term | grade | white | black | hispanic | native_american | native_american_alaskan_native | asian | native_hawaiian | asian_pacific_islander | native_hawaiian_pacific_islander | pacific_islander | multiracial | unknown_race | male ▼ | female | non_binary | unknown_gender | ell | ell_percent | homeless | homeless_percent | low_income | free_and_reduced | free_and_reduced_percent | disability | section_504 | total | white_int | black_int | hispanic_int | native_american_int | native_american_alaskan_native_int | asian_int | native_hawaiian_int | asian_pacific_islander_int | native_hawaiian_pacific_islander_int | pacific_islander_int | multiracial_int | unknown_race_int | male_int | female_int | non_binary_int | unknown_gender_int | ell_int | homeless_int | low_income_int | free_and_reduced_int | disability_int | section_504_int | total_int |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
722637 | 722637 | GA | school | 1301020 | 625 | Savannah-Chatham County | 130102004294 | 514 | School of Humanities at Juliette Gordon Low | Regular School | No | Other | PK | 12 | 2018 | spring | grade_8 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | |||||||||||||||||||||||||||||||||
727673 | 727673 | GA | school | 1302280 | 660 | Fulton County | 130228004261 | 1321 | Wellspring Living | Regular School | No | Secondary | 09 | 10 | 2018 | spring | grade_8 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | |||||||||||||||||||||||||||||||||
732411 | 732411 | GA | school | 1304380 | 721 | Richmond County | 130438003486 | 107 | Lighthouse Care Center of Augusta | Special Education School | No | High | 06 | 12 | 2018 | spring | grade_8 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | |||||||||||||||||||||||||||||||||
734449 | 734449 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012003980 | 1410 | Corretta Scott King Womens' Leadership Academy | Regular School | No | High | 06 | 12 | 2018 | spring | grade_8 | 0 | 58 | 2 | 0 | 0 | 0 | 2 | 0 | 62 | 62 | 0 | 58 | 2 | 0 | 0 | 0 | 2 | 0 | 62 | 62 | |||||||||||||||||||||||||||||||||
735143 | 735143 | GA | school | 1300226 | 7820612 | State Charter Schools- Ivy Preparatory Academy, Inc | 130022604023 | 612 | Ivy Preparatory Academy, Inc | Regular School | Yes | Elementary | KG | 08 | 2018 | spring | grade_8 | 0 | 41 | 2 | 0 | 0 | 0 | 0 | 0 | 43 | 43 | 0 | 41 | 2 | 0 | 0 | 0 | 0 | 0 | 43 | 43 | |||||||||||||||||||||||||||||||||
735198 | 735198 | GA | school | 1300215 | 7830110 | State Charter Schools II- Ivy Preparatory Academy at Gwinnett | 130021503748 | 110 | Ivy Preparatory Academy at Gwinnett | Regular School | Yes | Middle | 06 | 08 | 2018 | spring | grade_8 | 0 | 25 | 9 | 0 | 1 | 0 | 0 | 0 | 35 | 35 | 0 | 25 | 9 | 0 | 1 | 0 | 0 | 0 | 35 | 35 | |||||||||||||||||||||||||||||||||
735597 | 735597 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603490 | 598 | Macon Youth Development Campus | Alternative School | No | High | 08 | 12 | 2018 | spring | grade_8 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 2 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 2 | |||||||||||||||||||||||||||||||||
1248432 | 1248432 | GA | school | 1301020 | 625 | Savannah-Chatham County | 130102004294 | 514 | School of Humanities at Juliette Gordon Low | Regular School | No | Other | PK | 12 | 2018 | fall | grade_8 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | |||||||||||||||||||||||||||||||||
1258186 | 1258186 | GA | school | 1304380 | 721 | Richmond County | 130438003486 | 107 | Lighthouse Care Center of Augusta | Special Education School | No | High | 06 | 12 | 2018 | fall | grade_8 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 3 | 3 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 3 | 3 | |||||||||||||||||||||||||||||||||
1260219 | 1260219 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012003980 | 1410 | Corretta Scott King Womens' Leadership Academy | Regular School | No | High | 06 | 12 | 2018 | fall | grade_8 | 0 | 65 | 2 | 0 | 0 | 0 | 2 | 0 | 69 | 69 | 0 | 65 | 2 | 0 | 0 | 0 | 2 | 0 | 69 | 69 | |||||||||||||||||||||||||||||||||
1260911 | 1260911 | GA | school | 1300226 | 7820612 | State Charter Schools- Ivy Preparatory Academy, Inc | 130022604023 | 612 | Ivy Preparatory Academy, Inc | Regular School | Yes | Elementary | KG | 08 | 2018 | fall | grade_8 | 0 | 48 | 1 | 0 | 0 | 0 | 0 | 0 | 49 | 49 | 0 | 48 | 1 | 0 | 0 | 0 | 0 | 0 | 49 | 49 | |||||||||||||||||||||||||||||||||
1260966 | 1260966 | GA | school | 1300215 | 7830110 | State Charter Schools II- Ivy Preparatory Academy at Gwinnett | 130021503748 | 110 | Ivy Preparatory Academy at Gwinnett | Regular School | Yes | Middle | 06 | 08 | 2018 | fall | grade_8 | 0 | 25 | 11 | 1 | 1 | 0 | 0 | 0 | 38 | 38 | 0 | 25 | 11 | 1 | 1 | 0 | 0 | 0 | 38 | 38 | |||||||||||||||||||||||||||||||||
1261376 | 1261376 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603490 | 598 | Macon Youth Development Campus | Alternative School | No | High | 08 | 12 | 2018 | fall | grade_8 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | |||||||||||||||||||||||||||||||||
725717 | 725717 | GA | school | 1301740 | 644 | DeKalb County | 130174003613 | 707 | UHS of Laurel Heights | Special Education School | No | Other | 02 | 12 | 2018 | spring | grade_8 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | |||||||||||||||||||||||||||||||||
726646 | 726646 | GA | school | 1302070 | 654 | Evans County | 130207004287 | 197 | Second Chance | Regular School | No | Secondary | 07 | 10 | 2018 | spring | grade_8 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 2 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 2 | |||||||||||||||||||||||||||||||||
728827 | 728827 | GA | school | 1302550 | 667 | Gwinnett County | 130255003627 | 708 | Oakland Meadow School | Regular School | No | Other | PK | 12 | 2018 | spring | grade_8 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | |||||||||||||||||||||||||||||||||
730510 | 730510 | GA | school | 1303270 | 688 | Lee County | 130327003761 | 209 | Lee High School 9th Grade Campus | Regular School | No | Secondary | 08 | 11 | 2018 | spring | grade_8 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | |||||||||||||||||||||||||||||||||
733386 | 733386 | GA | school | 1305250 | 744 | Union County | 130525001721 | 3050 | Woody Gap High/Elementary School | Regular School | No | Other | KG | 12 | 2018 | spring | grade_8 | 4 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 4 | 5 | 4 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 4 | 5 | |||||||||||||||||||||||||||||||||
735044 | 735044 | GA | school | 1303510 | 781 | Marietta City | 130351003700 | 207 | George W. Hartmann Center | Alternative School | No | Secondary | 10 | 11 | 2018 | spring | grade_8 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | |||||||||||||||||||||||||||||||||
735592 | 735592 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603511 | 2798 | Bob Richards Regional Youth Detention Center | Alternative School | No | Secondary | 07 | 11 | 2018 | spring | grade_8 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | |||||||||||||||||||||||||||||||||
735593 | 735593 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603501 | 1798 | Claxton Regional Youth Detention Center | Alternative School | No | Secondary | 08 | 11 | 2018 | spring | grade_8 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | |||||||||||||||||||||||||||||||||
735595 | 735595 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603506 | 2298 | Gainesville Regional Youth Detention Center | Alternative School | No | Secondary | 08 | 10 | 2018 | spring | grade_8 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | |||||||||||||||||||||||||||||||||
735596 | 735596 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603509 | 2598 | Macon Regional Youth Detention Center | Alternative School | No | Secondary | 07 | 11 | 2018 | spring | grade_8 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | |||||||||||||||||||||||||||||||||
735602 | 735602 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002604141 | 414 | Rockdale RYDC | Special Education School | No | Secondary | 08 | 11 | 2018 | spring | grade_8 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | |||||||||||||||||||||||||||||||||
735603 | 735603 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603513 | 2998 | Savannah Regional Youth Detention Center | Alternative School | No | Middle | 06 | 11 | 2018 | spring | grade_8 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | |||||||||||||||||||||||||||||||||
735604 | 735604 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603518 | 5001 | Sumter Youth Development Campus | Alternative School | No | High | 07 | 12 | 2018 | spring | grade_8 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | |||||||||||||||||||||||||||||||||
735607 | 735607 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603515 | 3198 | Waycross Regional Youth Detention Center | Alternative School | No | Middle | 07 | 09 | 2018 | spring | grade_8 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | |||||||||||||||||||||||||||||||||
1251504 | 1251504 | GA | school | 1301740 | 644 | DeKalb County | 130174003613 | 707 | UHS of Laurel Heights | Special Education School | No | Other | 02 | 12 | 2018 | fall | grade_8 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | |||||||||||||||||||||||||||||||||
1251841 | 1251841 | GA | school | 1301770 | 645 | Dodge County | 130177004186 | 292 | DAC (Dodge County Achievement Center) | Regular School | No | High | 07 | 12 | 2018 | fall | grade_8 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | |||||||||||||||||||||||||||||||||
1251867 | 1251867 | GA | school | 1301800 | 646 | Dooly County | 130180004286 | 205 | Dooly County Prep Academy | Regular School | No | High | 08 | 12 | 2018 | fall | grade_8 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 2 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 2 | |||||||||||||||||||||||||||||||||
1253437 | 1253437 | GA | school | 1302280 | 660 | Fulton County | 130228003651 | 307 | Georgia Baptist Children's Home and Family Ministries | Special Education School | No | Middle | 05 | 11 | 2018 | fall | grade_8 | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 1 | 3 | 4 | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 1 | 3 | 4 | |||||||||||||||||||||||||||||||||
1254607 | 1254607 | GA | school | 1302550 | 667 | Gwinnett County | 130255003627 | 708 | Oakland Meadow School | Regular School | No | Other | PK | 12 | 2018 | fall | grade_8 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | |||||||||||||||||||||||||||||||||
1256288 | 1256288 | GA | school | 1303270 | 688 | Lee County | 130327003761 | 209 | Lee High School 9th Grade Campus | Regular School | No | Secondary | 08 | 11 | 2018 | fall | grade_8 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | |||||||||||||||||||||||||||||||||
1259158 | 1259158 | GA | school | 1305250 | 744 | Union County | 130525001721 | 3050 | Woody Gap High/Elementary School | Regular School | No | Other | KG | 12 | 2018 | fall | grade_8 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 3 | 4 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 3 | 4 | |||||||||||||||||||||||||||||||||
1261368 | 1261368 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603498 | 1498 | Augusta Regional Youth Detention Center | Alternative School | No | Secondary | 08 | 09 | 2018 | fall | grade_8 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | |||||||||||||||||||||||||||||||||
1261370 | 1261370 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603511 | 2798 | Bob Richards Regional Youth Detention Center | Alternative School | No | Secondary | 07 | 11 | 2018 | fall | grade_8 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | |||||||||||||||||||||||||||||||||
1261378 | 1261378 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002604194 | 4199 | Millegeville ITU | Special Education School | No | High | 08 | 12 | 2018 | fall | grade_8 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | |||||||||||||||||||||||||||||||||
1261380 | 1261380 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002604141 | 414 | Rockdale RYDC | Special Education School | No | Secondary | 08 | 11 | 2018 | fall | grade_8 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | |||||||||||||||||||||||||||||||||
1261382 | 1261382 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603518 | 5001 | Sumter Youth Development Campus | Alternative School | No | High | 07 | 12 | 2018 | fall | grade_8 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | |||||||||||||||||||||||||||||||||
1261383 | 1261383 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603514 | 3098 | T J Loftiss II Regional Youth Detention Center | Alternative School | No | Secondary | 08 | 10 | 2018 | fall | grade_8 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | |||||||||||||||||||||||||||||||||
1261384 | 1261384 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002604269 | 4203 | Terrell Regional Youth Detention Center | Special Education School | No | Middle | 06 | 10 | 2018 | fall | grade_8 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | |||||||||||||||||||||||||||||||||
1261385 | 1261385 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603515 | 3198 | Waycross Regional Youth Detention Center | Alternative School | No | Middle | 07 | 09 | 2018 | fall | grade_8 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | |||||||||||||||||||||||||||||||||
721762 | 721762 | GA | school | 1300540 | 614 | Brooks County | 130054004264 | 394 | Delta Innovative School | Regular School | No | High | 07 | 12 | 2018 | spring | grade_8 | 1 | 11 | 1 | 0 | 0 | 0 | 0 | 10 | 3 | 13 | 1 | 11 | 1 | 0 | 0 | 0 | 0 | 10 | 3 | 13 | |||||||||||||||||||||||||||||||||
1250308 | 1250308 | GA | school | 1301380 | 635 | Colquitt County | 130138004052 | 112 | Colquitt County Achievement Center | Regular School | No | High | 08 | 12 | 2018 | fall | grade_8 | 1 | 4 | 3 | 0 | 0 | 0 | 2 | 10 | 0 | 10 | 1 | 4 | 3 | 0 | 0 | 0 | 2 | 10 | 0 | 10 | |||||||||||||||||||||||||||||||||
1258190 | 1258190 | GA | school | 1304380 | 721 | Richmond County | 130438004069 | 213 | Richmond County Technical Career Magnet School | Regular School | No | High | 06 | 12 | 2018 | fall | grade_8 | 6 | 11 | 0 | 0 | 0 | 0 | 0 | 10 | 7 | 17 | 6 | 11 | 0 | 0 | 0 | 0 | 0 | 10 | 7 | 17 | |||||||||||||||||||||||||||||||||
723506 | 723506 | GA | school | 1301230 | 631 | Clayton County | 130123002105 | 191 | Lovejoy Middle School | Regular School | No | Middle | 06 | 08 | 2018 | spring | grade_8 | 7 | 137 | 30 | 0 | 3 | 0 | 8 | 100 | 85 | 185 | 7 | 137 | 30 | 0 | 3 | 0 | 8 | 100 | 85 | 185 | |||||||||||||||||||||||||||||||||
1247891 | 1247891 | GA | school | 1300810 | 621 | Candler County | 130081000318 | 102 | Metter Middle School | Regular School | No | Middle | 06 | 08 | 2018 | fall | grade_8 | 86 | 54 | 39 | 0 | 1 | 0 | 0 | 100 | 80 | 180 | 86 | 54 | 39 | 0 | 1 | 0 | 0 | 100 | 80 | 180 | |||||||||||||||||||||||||||||||||
1257708 | 1257708 | GA | school | 1304110 | 712 | Pickens County | 130411002592 | 403 | Jasper Middle School | Regular School | No | Middle | 06 | 08 | 2018 | fall | grade_8 | 160 | 1 | 16 | 0 | 1 | 0 | 2 | 100 | 80 | 180 | 160 | 1 | 16 | 0 | 1 | 0 | 2 | 100 | 80 | 180 | |||||||||||||||||||||||||||||||||
1259429 | 1259429 | GA | school | 1305430 | 748 | Ware County | 130543002204 | 295 | Waycross Middle School | Regular School | No | Middle | 06 | 08 | 2018 | fall | grade_8 | 94 | 75 | 13 | 1 | 6 | 0 | 5 | 100 | 94 | 194 | 94 | 75 | 13 | 1 | 6 | 0 | 5 | 100 | 94 | 194 | |||||||||||||||||||||||||||||||||
725700 | 725700 | GA | school | 1301740 | 644 | DeKalb County | 130174003559 | 1100 | International Student Center | Regular School | No | Middle | 07 | 08 | 2018 | spring | grade_8 | 5 | 72 | 60 | 0 | 27 | 0 | 0 | 101 | 63 | 164 | 5 | 72 | 60 | 0 | 27 | 0 | 0 | 101 | 63 | 164 | |||||||||||||||||||||||||||||||||
1260226 | 1260226 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012000025 | 373 | King Middle School | Regular School | No | Middle | 06 | 08 | 2018 | fall | grade_8 | 5 | 182 | 13 | 0 | 0 | 0 | 3 | 101 | 102 | 203 | 5 | 182 | 13 | 0 | 0 | 0 | 3 | 101 | 102 | 203 | |||||||||||||||||||||||||||||||||
721341 | 721341 | GA | school | 1300330 | 608 | Bartow County | 130033002060 | 190 | Red Top Middle School | Regular School | No | Middle | 06 | 08 | 2018 | spring | grade_8 | 136 | 22 | 39 | 0 | 4 | 0 | 11 | 102 | 110 | 212 | 136 | 22 | 39 | 0 | 4 | 0 | 11 | 102 | 110 | 212 | |||||||||||||||||||||||||||||||||
1259515 | 1259515 | GA | school | 1305550 | 751 | Wayne County | 130555000673 | 194 | Martha Puckett Middle School | Regular School | No | Middle | 06 | 08 | 2018 | fall | grade_8 | 131 | 32 | 18 | 0 | 0 | 0 | 7 | 102 | 86 | 188 | 131 | 32 | 18 | 0 | 0 | 0 | 7 | 102 | 86 | 188 | |||||||||||||||||||||||||||||||||
722623 | 722623 | GA | school | 1301020 | 625 | Savannah-Chatham County | 130102000362 | 201 | DeRenne Middle School | Regular School | No | Middle | 06 | 08 | 2018 | spring | grade_8 | 4 | 199 | 2 | 0 | 0 | 0 | 5 | 103 | 107 | 210 | 4 | 199 | 2 | 0 | 0 | 0 | 5 | 103 | 107 | 210 | |||||||||||||||||||||||||||||||||
1248978 | 1248978 | GA | school | 1301170 | 629 | Clarke County | 130117000456 | 296 | Burney-Harris-Lyons Middle School | Regular School | No | Middle | 06 | 08 | 2018 | fall | grade_8 | 29 | 107 | 81 | 0 | 3 | 0 | 6 | 103 | 123 | 226 | 29 | 107 | 81 | 0 | 3 | 0 | 6 | 103 | 123 | 226 | |||||||||||||||||||||||||||||||||
1249299 | 1249299 | GA | school | 1301230 | 631 | Clayton County | 130123002105 | 191 | Lovejoy Middle School | Regular School | No | Middle | 06 | 08 | 2018 | fall | grade_8 | 5 | 147 | 29 | 0 | 2 | 0 | 6 | 103 | 86 | 189 | 5 | 147 | 29 | 0 | 2 | 0 | 6 | 103 | 86 | 189 | |||||||||||||||||||||||||||||||||
1253818 | 1253818 | GA | school | 1302400 | 663 | Glynn County | 130240004076 | 116 | Risley Middle School | Regular School | No | Middle | 06 | 08 | 2018 | fall | grade_8 | 92 | 96 | 16 | 0 | 1 | 0 | 9 | 103 | 111 | 214 | 92 | 96 | 16 | 0 | 1 | 0 | 9 | 103 | 111 | 214 | |||||||||||||||||||||||||||||||||
1256198 | 1256198 | GA | school | 1303210 | 685 | Lamar County | 130321002273 | 199 | Lamar County Middle School | Regular School | No | Middle | 06 | 08 | 2018 | fall | grade_8 | 124 | 65 | 7 | 0 | 0 | 0 | 9 | 103 | 102 | 205 | 124 | 65 | 7 | 0 | 0 | 0 | 9 | 103 | 102 | 205 | |||||||||||||||||||||||||||||||||
725705 | 725705 | GA | school | 1301740 | 644 | DeKalb County | 130174000649 | 1057 | McNair Middle School | Regular School | No | Middle | 06 | 08 | 2018 | spring | grade_8 | 1 | 188 | 3 | 1 | 1 | 1 | 3 | 104 | 94 | 198 | 1 | 188 | 3 | 1 | 1 | 1 | 3 | 104 | 94 | 198 | |||||||||||||||||||||||||||||||||
730419 | 730419 | GA | school | 1303210 | 685 | Lamar County | 130321002273 | 199 | Lamar County Middle School | Regular School | No | Middle | 06 | 08 | 2018 | spring | grade_8 | 123 | 63 | 7 | 0 | 0 | 0 | 9 | 104 | 98 | 202 | 123 | 63 | 7 | 0 | 0 | 0 | 9 | 104 | 98 | 202 | |||||||||||||||||||||||||||||||||
734445 | 734445 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012002344 | 100 | Brown Middle School | Regular School | No | Middle | 06 | 08 | 2018 | spring | grade_8 | 0 | 187 | 6 | 0 | 0 | 0 | 0 | 104 | 89 | 193 | 0 | 187 | 6 | 0 | 0 | 0 | 0 | 104 | 89 | 193 | |||||||||||||||||||||||||||||||||
1247380 | 1247380 | GA | school | 1300420 | 611 | Bibb County | 130042000212 | 5050 | Appling Middle School | Regular School | No | Middle | 06 | 08 | 2018 | fall | grade_8 | 3 | 184 | 2 | 0 | 0 | 0 | 1 | 104 | 86 | 190 | 3 | 184 | 2 | 0 | 0 | 0 | 1 | 104 | 86 | 190 | |||||||||||||||||||||||||||||||||
1249291 | 1249291 | GA | school | 1301230 | 631 | Clayton County | 130123000480 | 177 | Adamson Middle School | Regular School | No | Middle | 06 | 08 | 2018 | fall | grade_8 | 5 | 155 | 29 | 0 | 7 | 0 | 5 | 104 | 97 | 201 | 5 | 155 | 29 | 0 | 7 | 0 | 5 | 104 | 97 | 201 | |||||||||||||||||||||||||||||||||
1249911 | 1249911 | GA | school | 1301290 | 633 | Cobb County | 130129000511 | 280 | Pine Mountain Middle School | Regular School | No | Middle | 06 | 08 | 2018 | fall | grade_8 | 58 | 73 | 37 | 3 | 14 | 1 | 6 | 104 | 88 | 192 | 58 | 73 | 37 | 3 | 14 | 1 | 6 | 104 | 88 | 192 | |||||||||||||||||||||||||||||||||
1251842 | 1251842 | GA | school | 1301770 | 645 | Dodge County | 130177000803 | 180 | Dodge County Middle School | Regular School | No | Middle | 06 | 08 | 2018 | fall | grade_8 | 131 | 74 | 6 | 1 | 0 | 0 | 11 | 104 | 119 | 223 | 131 | 74 | 6 | 1 | 0 | 0 | 11 | 104 | 119 | 223 | |||||||||||||||||||||||||||||||||
721399 | 721399 | GA | school | 1300360 | 609 | Ben Hill County | 130036002149 | 296 | Ben Hill County Middle School | Regular School | No | Middle | 06 | 08 | 2018 | spring | grade_8 | 93 | 79 | 33 | 1 | 1 | 0 | 9 | 105 | 111 | 216 | 93 | 79 | 33 | 1 | 1 | 0 | 9 | 105 | 111 | 216 | |||||||||||||||||||||||||||||||||
721583 | 721583 | GA | school | 1300420 | 611 | Bibb County | 130042000212 | 5050 | Appling Middle School | Regular School | No | Middle | 06 | 08 | 2018 | spring | grade_8 | 2 | 183 | 1 | 0 | 0 | 0 | 2 | 105 | 83 | 188 | 2 | 183 | 1 | 0 | 0 | 0 | 2 | 105 | 83 | 188 | |||||||||||||||||||||||||||||||||
721884 | 721884 | GA | school | 1300630 | 616 | Bulloch County | 130063002236 | 198 | William James Middle School | Regular School | No | Middle | 06 | 08 | 2018 | spring | grade_8 | 107 | 87 | 7 | 0 | 4 | 0 | 7 | 105 | 107 | 212 | 107 | 87 | 7 | 0 | 4 | 0 | 7 | 105 | 107 | 212 | |||||||||||||||||||||||||||||||||
1257094 | 1257094 | GA | school | 1303870 | 706 | Muscogee County | 130387001376 | 196 | Blackmon Road Middle School | Regular School | No | Middle | 06 | 08 | 2018 | fall | grade_8 | 108 | 69 | 14 | 0 | 24 | 1 | 7 | 105 | 118 | 223 | 108 | 69 | 14 | 0 | 24 | 1 | 7 | 105 | 118 | 223 | |||||||||||||||||||||||||||||||||
726057 | 726057 | GA | school | 1301770 | 645 | Dodge County | 130177000803 | 180 | Dodge County Middle School | Regular School | No | Middle | 06 | 08 | 2018 | spring | grade_8 | 131 | 74 | 6 | 1 | 0 | 0 | 13 | 106 | 119 | 225 | 131 | 74 | 6 | 1 | 0 | 0 | 13 | 106 | 119 | 225 | |||||||||||||||||||||||||||||||||
731321 | 731321 | GA | school | 1303870 | 706 | Muscogee County | 130387002421 | 301 | East Columbus Magnet Academy | Regular School | No | Middle | 06 | 08 | 2018 | spring | grade_8 | 8 | 166 | 6 | 0 | 0 | 0 | 6 | 106 | 80 | 186 | 8 | 166 | 6 | 0 | 0 | 0 | 6 | 106 | 80 | 186 | |||||||||||||||||||||||||||||||||
731791 | 731791 | GA | school | 1304020 | 710 | Paulding County | 130402002508 | 201 | Lena Mae Moses Middle School | Regular School | No | Middle | 06 | 08 | 2018 | spring | grade_8 | 135 | 55 | 18 | 0 | 2 | 0 | 12 | 106 | 116 | 222 | 135 | 55 | 18 | 0 | 2 | 0 | 12 | 106 | 116 | 222 | |||||||||||||||||||||||||||||||||
733656 | 733656 | GA | school | 1305430 | 748 | Ware County | 130543001779 | 395 | Ware County Middle School | Regular School | No | Middle | 06 | 08 | 2018 | spring | grade_8 | 165 | 50 | 15 | 0 | 0 | 0 | 12 | 106 | 136 | 242 | 165 | 50 | 15 | 0 | 0 | 0 | 12 | 106 | 136 | 242 | |||||||||||||||||||||||||||||||||
1247138 | 1247138 | GA | school | 1300330 | 608 | Bartow County | 130033002060 | 190 | Red Top Middle School | Regular School | No | Middle | 06 | 08 | 2018 | fall | grade_8 | 136 | 23 | 38 | 0 | 3 | 0 | 11 | 106 | 105 | 211 | 136 | 23 | 38 | 0 | 3 | 0 | 11 | 106 | 105 | 211 | |||||||||||||||||||||||||||||||||
1257566 | 1257566 | GA | school | 1304020 | 710 | Paulding County | 130402002508 | 201 | Lena Mae Moses Middle School | Regular School | No | Middle | 06 | 08 | 2018 | fall | grade_8 | 130 | 55 | 16 | 0 | 1 | 0 | 11 | 106 | 107 | 213 | 130 | 55 | 16 | 0 | 1 | 0 | 11 | 106 | 107 | 213 | |||||||||||||||||||||||||||||||||
726587 | 726587 | GA | school | 1302010 | 652 | Elbert County | 130201002871 | 104 | Elbert County Middle School | Regular School | No | Middle | 05 | 08 | 2018 | spring | grade_8 | 120 | 55 | 19 | 0 | 3 | 0 | 6 | 107 | 96 | 203 | 120 | 55 | 19 | 0 | 3 | 0 | 6 | 107 | 96 | 203 | |||||||||||||||||||||||||||||||||
726902 | 726902 | GA | school | 1302190 | 657 | Floyd County | 130219002372 | 203 | Model Middle School | Regular School | No | Middle | 06 | 08 | 2018 | spring | grade_8 | 172 | 10 | 3 | 1 | 1 | 0 | 6 | 107 | 86 | 193 | 172 | 10 | 3 | 1 | 1 | 0 | 6 | 107 | 86 | 193 | |||||||||||||||||||||||||||||||||
727651 | 727651 | GA | school | 1302280 | 660 | Fulton County | 130228001956 | 186 | Camp Creek Middle School | Regular School | No | Middle | 06 | 08 | 2018 | spring | grade_8 | 2 | 190 | 10 | 0 | 0 | 0 | 4 | 107 | 99 | 206 | 2 | 190 | 10 | 0 | 0 | 0 | 4 | 107 | 99 | 206 | |||||||||||||||||||||||||||||||||
731319 | 731319 | GA | school | 1303870 | 706 | Muscogee County | 130387001376 | 196 | Blackmon Road Middle School | Regular School | No | Middle | 06 | 08 | 2018 | spring | grade_8 | 105 | 69 | 15 | 0 | 25 | 1 | 8 | 107 | 116 | 223 | 105 | 69 | 15 | 0 | 25 | 1 | 8 | 107 | 116 | 223 | |||||||||||||||||||||||||||||||||
731790 | 731790 | GA | school | 1304020 | 710 | Paulding County | 130402001786 | 297 | J. A. Dobbins Middle School | Regular School | No | Middle | 06 | 08 | 2018 | spring | grade_8 | 97 | 79 | 26 | 0 | 0 | 0 | 11 | 107 | 106 | 213 | 97 | 79 | 26 | 0 | 0 | 0 | 11 | 107 | 106 | 213 | |||||||||||||||||||||||||||||||||
1247196 | 1247196 | GA | school | 1300360 | 609 | Ben Hill County | 130036002149 | 296 | Ben Hill County Middle School | Regular School | No | Middle | 06 | 08 | 2018 | fall | grade_8 | 99 | 80 | 33 | 1 | 1 | 0 | 8 | 107 | 115 | 222 | 99 | 80 | 33 | 1 | 1 | 0 | 8 | 107 | 115 | 222 | |||||||||||||||||||||||||||||||||
1250468 | 1250468 | GA | school | 1301410 | 636 | Columbia County | 130141002366 | 101 | Greenbrier Middle School | Regular School | No | Middle | 06 | 08 | 2018 | fall | grade_8 | 151 | 31 | 13 | 1 | 9 | 1 | 6 | 107 | 105 | 212 | 151 | 31 | 13 | 1 | 9 | 1 | 6 | 107 | 105 | 212 | |||||||||||||||||||||||||||||||||
1257096 | 1257096 | GA | school | 1303870 | 706 | Muscogee County | 130387002421 | 301 | East Columbus Magnet Academy | Regular School | No | Middle | 06 | 08 | 2018 | fall | grade_8 | 8 | 170 | 6 | 0 | 0 | 0 | 4 | 107 | 81 | 188 | 8 | 170 | 6 | 0 | 0 | 0 | 4 | 107 | 81 | 188 | |||||||||||||||||||||||||||||||||
723507 | 723507 | GA | school | 1301230 | 631 | Clayton County | 130123002304 | 100 | M. D. Roberts Middle School | Regular School | No | Middle | 06 | 08 | 2018 | spring | grade_8 | 10 | 218 | 44 | 1 | 19 | 0 | 10 | 108 | 194 | 302 | 10 | 218 | 44 | 1 | 19 | 0 | 10 | 108 | 194 | 302 | |||||||||||||||||||||||||||||||||
724679 | 724679 | GA | school | 1301410 | 636 | Columbia County | 130141002366 | 101 | Greenbrier Middle School | Regular School | No | Middle | 06 | 08 | 2018 | spring | grade_8 | 151 | 32 | 14 | 1 | 10 | 1 | 7 | 108 | 108 | 216 | 151 | 32 | 14 | 1 | 10 | 1 | 7 | 108 | 108 | 216 | |||||||||||||||||||||||||||||||||
1252371 | 1252371 | GA | school | 1302010 | 652 | Elbert County | 130201002871 | 104 | Elbert County Middle School | Regular School | No | Middle | 05 | 08 | 2018 | fall | grade_8 | 120 | 55 | 20 | 0 | 3 | 0 | 6 | 108 | 96 | 204 | 120 | 55 | 20 | 0 | 3 | 0 | 6 | 108 | 96 | 204 | |||||||||||||||||||||||||||||||||
1260215 | 1260215 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012002344 | 100 | Brown Middle School | Regular School | No | Middle | 06 | 08 | 2018 | fall | grade_8 | 0 | 195 | 6 | 0 | 0 | 0 | 0 | 108 | 93 | 201 | 0 | 195 | 6 | 0 | 0 | 0 | 0 | 108 | 93 | 201 | |||||||||||||||||||||||||||||||||
723187 | 723187 | GA | school | 1301170 | 629 | Clarke County | 130117001106 | 196 | Coile Middle School | Regular School | No | Middle | 06 | 08 | 2018 | spring | grade_8 | 17 | 107 | 82 | 0 | 0 | 0 | 7 | 109 | 104 | 213 | 17 | 107 | 82 | 0 | 0 | 0 | 7 | 109 | 104 | 213 | |||||||||||||||||||||||||||||||||
723498 | 723498 | GA | school | 1301230 | 631 | Clayton County | 130123000480 | 177 | Adamson Middle School | Regular School | No | Middle | 06 | 08 | 2018 | spring | grade_8 | 6 | 159 | 28 | 0 | 7 | 0 | 5 | 109 | 96 | 205 | 6 | 159 | 28 | 0 | 7 | 0 | 5 | 109 | 96 | 205 | |||||||||||||||||||||||||||||||||
723500 | 723500 | GA | school | 1301230 | 631 | Clayton County | 130123004022 | 116 | Eddie White Middle School | Regular School | No | Elementary | KG | 08 | 2018 | spring | grade_8 | 5 | 219 | 27 | 0 | 2 | 0 | 8 | 109 | 152 | 261 | 5 | 219 | 27 | 0 | 2 | 0 | 8 | 109 | 152 | 261 | |||||||||||||||||||||||||||||||||
724121 | 724121 | GA | school | 1301290 | 633 | Cobb County | 130129000511 | 280 | Pine Mountain Middle School | Regular School | No | Middle | 06 | 08 | 2018 | spring | grade_8 | 64 | 72 | 38 | 3 | 14 | 1 | 5 | 109 | 88 | 197 | 64 | 72 | 38 | 3 | 14 | 1 | 5 | 109 | 88 | 197 | |||||||||||||||||||||||||||||||||
732412 | 732412 | GA | school | 1304380 | 721 | Richmond County | 130438001932 | 184 | Morgan Road Middle School | Regular School | No | Middle | 06 | 08 | 2018 | spring | grade_8 | 7 | 206 | 8 | 0 | 2 | 1 | 3 | 109 | 118 | 227 | 7 | 206 | 8 | 0 | 2 | 1 | 3 | 109 | 118 | 227 | |||||||||||||||||||||||||||||||||
734456 | 734456 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012000025 | 373 | King Middle School | Regular School | No | Middle | 06 | 08 | 2018 | spring | grade_8 | 4 | 190 | 15 | 0 | 0 | 0 | 3 | 109 | 103 | 212 | 4 | 190 | 15 | 0 | 0 | 0 | 3 | 109 | 103 | 212 | |||||||||||||||||||||||||||||||||
1247680 | 1247680 | GA | school | 1300630 | 616 | Bulloch County | 130063002236 | 198 | William James Middle School | Regular School | No | Middle | 06 | 08 | 2018 | fall | grade_8 | 106 | 91 | 7 | 0 | 4 | 0 | 7 | 109 | 106 | 215 | 106 | 91 | 7 | 0 | 4 | 0 | 7 | 109 | 106 | 215 | |||||||||||||||||||||||||||||||||
1249296 | 1249296 | GA | school | 1301230 | 631 | Clayton County | 130123000466 | 2054 | Forest Park Middle School | Regular School | No | Middle | 06 | 08 | 2018 | fall | grade_8 | 10 | 118 | 97 | 0 | 5 | 0 | 6 | 109 | 127 | 236 | 10 | 118 | 97 | 0 | 5 | 0 | 6 | 109 | 127 | 236 | |||||||||||||||||||||||||||||||||
1252683 | 1252683 | GA | school | 1302190 | 657 | Floyd County | 130219002372 | 203 | Model Middle School | Regular School | No | Middle | 06 | 08 | 2018 | fall | grade_8 | 172 | 9 | 3 | 1 | 1 | 0 | 5 | 109 | 82 | 191 | 172 | 9 | 3 | 1 | 1 | 0 | 5 | 109 | 82 | 191 | |||||||||||||||||||||||||||||||||
1253899 | 1253899 | GA | school | 1302430 | 664 | Gordon County | 130243002175 | 292 | Ashworth Middle School | Regular School | No | Middle | 06 | 08 | 2018 | fall | grade_8 | 147 | 6 | 49 | 1 | 1 | 0 | 3 | 109 | 98 | 207 | 147 | 6 | 49 | 1 | 1 | 0 | 3 | 109 | 98 | 207 | |||||||||||||||||||||||||||||||||
1257098 | 1257098 | GA | school | 1303870 | 706 | Muscogee County | 130387001394 | 178 | Fort Middle School | Regular School | No | Middle | 06 | 08 | 2018 | fall | grade_8 | 8 | 159 | 13 | 0 | 0 | 1 | 8 | 109 | 80 | 189 | 8 | 159 | 13 | 0 | 0 | 1 | 8 | 109 | 80 | 189 | |||||||||||||||||||||||||||||||||
1257565 | 1257565 | GA | school | 1304020 | 710 | Paulding County | 130402001786 | 297 | J. A. Dobbins Middle School | Regular School | No | Middle | 06 | 08 | 2018 | fall | grade_8 | 101 | 84 | 26 | 0 | 0 | 0 | 12 | 109 | 114 | 223 | 101 | 84 | 26 | 0 | 0 | 0 | 12 | 109 | 114 | 223 | |||||||||||||||||||||||||||||||||
722831 | 722831 | GA | school | 1301080 | 627 | Chattooga County | 130108000417 | 2050 | Lyerly Elementary School | Regular School | No | Elementary | PK | 08 | 2018 | spring | grade_8 | 30 | 4 | 0 | 0 | 0 | 0 | 1 | 11 | 24 | 35 | 30 | 4 | 0 | 0 | 0 | 0 | 1 | 11 | 24 | 35 |
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]);