enrollments
Data source: Big Local News · About: Big Local
1,193 rows where grade = "grade_8", state = "GA" and year = 2017 sorted by hispanic
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
296882 | 296882 | GA | school | 1300420 | 611 | Bibb County | 130042003621 | 307 | Price Academy | Special Education School | No | Elementary | 04 | 08 | 2017 | spring | grade_8 | 3 | 4 | 0 | 0 | 0 | 0 | 0 | 2 | 5 | 7 | 3 | 4 | 0 | 0 | 0 | 0 | 0 | 2 | 5 | 7 | |||||||||||||||||||||||||||||||||
296988 | 296988 | GA | school | 1300440 | 612 | Bleckley County | 130044004162 | 115 | Bleckley County Success Academy | Regular School | No | Other | 06 | 12 | 2017 | spring | grade_8 | 7 | 1 | 0 | 0 | 0 | 0 | 1 | 6 | 3 | 9 | 7 | 1 | 0 | 0 | 0 | 0 | 1 | 6 | 3 | 9 | |||||||||||||||||||||||||||||||||
297053 | 297053 | GA | school | 1300540 | 614 | Brooks County | 130054000263 | 110 | Brooks County High School | Regular School | No | Other | 06 | 12 | 2017 | spring | grade_8 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | |||||||||||||||||||||||||||||||||
297919 | 297919 | GA | school | 1301020 | 625 | Savannah-Chatham County | 130102000410 | 3062 | Low Elementary School | Regular School | No | Other | PK | 11 | 2017 | spring | grade_8 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 2 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 2 | |||||||||||||||||||||||||||||||||
297927 | 297927 | GA | school | 1301020 | 625 | Savannah-Chatham County | 130102003610 | 107 | UHS of Savannah Coastal Harbor Treatment Center | Regular School | No | Other | 03 | 11 | 2017 | spring | grade_8 | 7 | 1 | 0 | 0 | 0 | 0 | 0 | 4 | 4 | 8 | 7 | 1 | 0 | 0 | 0 | 0 | 0 | 4 | 4 | 8 | |||||||||||||||||||||||||||||||||
298114 | 298114 | GA | school | 1301080 | 627 | Chattooga County | 130108003571 | 111 | Chattooga Academy | Alternative School | No | Other | 01 | 12 | 2017 | spring | grade_8 | 8 | 0 | 0 | 0 | 0 | 0 | 2 | 6 | 4 | 10 | 8 | 0 | 0 | 0 | 0 | 0 | 2 | 6 | 4 | 10 | |||||||||||||||||||||||||||||||||
299392 | 299392 | GA | school | 1301290 | 633 | Cobb County | 130129003679 | 807 | Devereux Ackerman Academy | Special Education School | No | Other | 05 | 12 | 2017 | spring | grade_8 | 1 | 12 | 0 | 0 | 0 | 0 | 0 | 7 | 6 | 13 | 1 | 12 | 0 | 0 | 0 | 0 | 0 | 7 | 6 | 13 | |||||||||||||||||||||||||||||||||
300391 | 300391 | GA | school | 1301710 | 643 | Decatur County | 130171004170 | 116 | New Beginning Learning Center | Regular School | No | Other | 06 | 12 | 2017 | spring | grade_8 | 4 | 1 | 0 | 0 | 0 | 0 | 0 | 2 | 3 | 5 | 4 | 1 | 0 | 0 | 0 | 0 | 0 | 2 | 3 | 5 | |||||||||||||||||||||||||||||||||
300986 | 300986 | GA | school | 1301740 | 644 | DeKalb County | 130174004071 | 113 | DeKalb Preparatory Academy Charter | Regular School | Yes | Elementary | KG | 08 | 2017 | spring | grade_8 | 0 | 26 | 0 | 0 | 1 | 0 | 1 | 14 | 14 | 28 | 0 | 26 | 0 | 0 | 1 | 0 | 1 | 14 | 14 | 28 | |||||||||||||||||||||||||||||||||
300989 | 300989 | GA | school | 1301740 | 644 | DeKalb County | 130174002642 | 503 | East DeKalb Special Education Center | Special Education School | No | Other | PK | 11 | 2017 | spring | grade_8 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | |||||||||||||||||||||||||||||||||
301006 | 301006 | GA | school | 1301740 | 644 | DeKalb County | 130174004159 | 315 | Tapestry Public Charter School | Regular School | Yes | Other | 06 | 10 | 2017 | spring | grade_8 | 16 | 14 | 0 | 0 | 2 | 0 | 2 | 20 | 14 | 34 | 16 | 14 | 0 | 0 | 2 | 0 | 2 | 20 | 14 | 34 | |||||||||||||||||||||||||||||||||
301009 | 301009 | GA | school | 1301740 | 644 | DeKalb County | 130174003613 | 707 | UHS of Laurel Heights | Special Education School | No | Other | 02 | 12 | 2017 | spring | grade_8 | 2 | 3 | 0 | 0 | 0 | 0 | 0 | 3 | 2 | 5 | 2 | 3 | 0 | 0 | 0 | 0 | 0 | 3 | 2 | 5 | |||||||||||||||||||||||||||||||||
301348 | 301348 | GA | school | 1301770 | 645 | Dodge County | 130177004186 | 292 | DAC (Dodge County Achievement Center) | Regular School | No | High | 07 | 12 | 2017 | spring | grade_8 | 3 | 3 | 0 | 0 | 0 | 0 | 0 | 6 | 0 | 6 | 3 | 3 | 0 | 0 | 0 | 0 | 0 | 6 | 0 | 6 | |||||||||||||||||||||||||||||||||
301473 | 301473 | GA | school | 1301830 | 647 | Dougherty County | 130183000835 | 5060 | Southside Middle School | Regular School | No | Middle | 06 | 08 | 2017 | spring | grade_8 | 2 | 156 | 0 | 0 | 0 | 0 | 0 | 87 | 71 | 158 | 2 | 156 | 0 | 0 | 0 | 0 | 0 | 87 | 71 | 158 | |||||||||||||||||||||||||||||||||
302375 | 302375 | GA | school | 1302220 | 658 | Forsyth County | 130222003995 | 219 | Forsyth Virtual Academy | Regular School | No | Other | 06 | 12 | 2017 | spring | grade_8 | 11 | 0 | 0 | 0 | 2 | 0 | 0 | 3 | 10 | 13 | 11 | 0 | 0 | 0 | 2 | 0 | 0 | 3 | 10 | 13 | |||||||||||||||||||||||||||||||||
302942 | 302942 | GA | school | 1302280 | 660 | Fulton County | 130228003651 | 307 | Georgia Baptist Children's Home and Family Ministries | Special Education School | No | Other | 05 | 11 | 2017 | spring | grade_8 | 5 | 4 | 0 | 0 | 0 | 0 | 0 | 4 | 5 | 9 | 5 | 4 | 0 | 0 | 0 | 0 | 0 | 4 | 5 | 9 | |||||||||||||||||||||||||||||||||
303246 | 303246 | GA | school | 1302370 | 662 | Glascock County | 130237001055 | 196 | Glascock County Middle/High School | Regular School | No | Other | PK | 12 | 2017 | spring | grade_8 | 40 | 3 | 0 | 0 | 0 | 0 | 1 | 23 | 21 | 44 | 40 | 3 | 0 | 0 | 0 | 0 | 1 | 23 | 21 | 44 | |||||||||||||||||||||||||||||||||
303322 | 303322 | GA | school | 1302400 | 663 | Glynn County | 130240003697 | 107 | Morningstar Treatment Services, Inc. Youth Estate | Special Education School | No | Other | 06 | 12 | 2017 | spring | grade_8 | 5 | 3 | 0 | 0 | 0 | 0 | 0 | 5 | 3 | 8 | 5 | 3 | 0 | 0 | 0 | 0 | 0 | 5 | 3 | 8 | |||||||||||||||||||||||||||||||||
304111 | 304111 | GA | school | 1302550 | 667 | Gwinnett County | 130255003991 | 1020 | New Life Academy of Excellence | Regular School | Yes | Elementary | KG | 08 | 2017 | spring | grade_8 | 2 | 8 | 0 | 0 | 0 | 0 | 2 | 3 | 9 | 12 | 2 | 8 | 0 | 0 | 0 | 0 | 2 | 3 | 9 | 12 | |||||||||||||||||||||||||||||||||
304115 | 304115 | GA | school | 1302550 | 667 | Gwinnett County | 130255003627 | 708 | Oakland Meadow School | Regular School | No | Other | PK | 12 | 2017 | spring | grade_8 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 1 | |||||||||||||||||||||||||||||||||
304506 | 304506 | GA | school | 1302580 | 668 | Habersham County | 130258004144 | 114 | Habersham Success Academy | Regular School | No | High | 07 | 12 | 2017 | spring | grade_8 | 3 | 2 | 0 | 0 | 0 | 0 | 0 | 4 | 1 | 5 | 3 | 2 | 0 | 0 | 0 | 0 | 0 | 4 | 1 | 5 | |||||||||||||||||||||||||||||||||
304775 | 304775 | GA | school | 1302640 | 670 | Hancock County | 130264003539 | 106 | Hancock Central Middle School | Regular School | No | Middle | 06 | 08 | 2017 | spring | grade_8 | 0 | 60 | 0 | 1 | 0 | 0 | 0 | 31 | 30 | 61 | 0 | 60 | 0 | 1 | 0 | 0 | 0 | 31 | 30 | 61 | |||||||||||||||||||||||||||||||||
305686 | 305686 | GA | school | 1303150 | 684 | Jones County | 130315002502 | 101 | Clifton Ridge Middle School | Regular School | No | Middle | 06 | 08 | 2017 | spring | grade_8 | 117 | 58 | 0 | 0 | 1 | 0 | 3 | 90 | 89 | 179 | 117 | 58 | 0 | 0 | 1 | 0 | 3 | 90 | 89 | 179 | |||||||||||||||||||||||||||||||||
305803 | 305803 | GA | school | 1303270 | 688 | Lee County | 130327003761 | 209 | Lee High School 9th Grade Campus | Regular School | No | Other | 08 | 10 | 2017 | spring | grade_8 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | |||||||||||||||||||||||||||||||||
306184 | 306184 | GA | school | 1303630 | 699 | Meriwether County | 130363004238 | 401 | Greenville Middle School | Regular School | No | Middle | 06 | 08 | 2017 | spring | grade_8 | 24 | 43 | 0 | 0 | 0 | 0 | 0 | 30 | 37 | 67 | 24 | 43 | 0 | 0 | 0 | 0 | 0 | 30 | 37 | 67 | |||||||||||||||||||||||||||||||||
306373 | 306373 | GA | school | 1303840 | 705 | Murray County | 130384003574 | 108 | Pleasant Valley Innovative School | Regular School | No | High | 08 | 12 | 2017 | spring | grade_8 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 1 | 6 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 1 | 6 | |||||||||||||||||||||||||||||||||
307418 | 307418 | GA | school | 1304290 | 718 | Quitman County | 130429001518 | 199 | Quitman County Elementary | Regular School | No | Elementary | PK | 08 | 2017 | spring | grade_8 | 7 | 27 | 0 | 0 | 0 | 0 | 0 | 17 | 17 | 34 | 7 | 27 | 0 | 0 | 0 | 0 | 0 | 17 | 17 | 34 | |||||||||||||||||||||||||||||||||
307705 | 307705 | GA | school | 1304380 | 721 | Richmond County | 130438004211 | 391 | Alternative Education Center at Morgan | Regular School | No | Other | 06 | 12 | 2017 | spring | grade_8 | 4 | 37 | 0 | 1 | 0 | 0 | 1 | 30 | 13 | 43 | 4 | 37 | 0 | 1 | 0 | 0 | 1 | 30 | 13 | 43 | |||||||||||||||||||||||||||||||||
307712 | 307712 | GA | school | 1304380 | 721 | Richmond County | 130438003486 | 107 | Lighthouse Care Center of Augusta | Special Education School | No | Other | 04 | 11 | 2017 | spring | grade_8 | 2 | 1 | 0 | 0 | 0 | 0 | 0 | 3 | 0 | 3 | 2 | 1 | 0 | 0 | 0 | 0 | 0 | 3 | 0 | 3 | |||||||||||||||||||||||||||||||||
307719 | 307719 | GA | school | 1304380 | 721 | Richmond County | 130438003924 | 115 | W.S. Hornsby Middle School | Regular School | No | Middle | 06 | 08 | 2017 | spring | grade_8 | 1 | 111 | 0 | 0 | 0 | 0 | 0 | 54 | 58 | 112 | 1 | 111 | 0 | 0 | 0 | 0 | 0 | 54 | 58 | 112 | |||||||||||||||||||||||||||||||||
308177 | 308177 | GA | school | 1304590 | 728 | Stewart County | 130459002431 | 101 | Stewart County Middle School | Regular School | No | Middle | 06 | 08 | 2017 | spring | grade_8 | 2 | 33 | 0 | 0 | 0 | 0 | 0 | 22 | 13 | 35 | 2 | 33 | 0 | 0 | 0 | 0 | 0 | 22 | 13 | 35 | |||||||||||||||||||||||||||||||||
308226 | 308226 | GA | school | 1304650 | 730 | Talbot County | 130465001637 | 190 | Central Elementary/High School | Regular School | No | Other | PK | 12 | 2017 | spring | grade_8 | 1 | 34 | 0 | 0 | 0 | 0 | 0 | 19 | 16 | 35 | 1 | 34 | 0 | 0 | 0 | 0 | 0 | 19 | 16 | 35 | |||||||||||||||||||||||||||||||||
308338 | 308338 | GA | school | 1304860 | 735 | Terrell County | 130486003735 | 109 | Terrell Middle School | Regular School | No | Middle | 06 | 08 | 2017 | spring | grade_8 | 2 | 89 | 0 | 0 | 1 | 0 | 0 | 53 | 39 | 92 | 2 | 89 | 0 | 0 | 1 | 0 | 0 | 53 | 39 | 92 | |||||||||||||||||||||||||||||||||
308365 | 308365 | GA | school | 1304890 | 736 | Thomas County | 130489004152 | 115 | The Renaissance Center for Academic and Career Development | Regular School | No | Other | 06 | 12 | 2017 | spring | grade_8 | 1 | 3 | 0 | 0 | 0 | 0 | 0 | 3 | 1 | 4 | 1 | 3 | 0 | 0 | 0 | 0 | 0 | 3 | 1 | 4 | |||||||||||||||||||||||||||||||||
308478 | 308478 | GA | school | 1305100 | 740 | Treutlen County | 130510001699 | 213 | Treutlen Middle/High School | Regular School | No | Other | 06 | 12 | 2017 | spring | grade_8 | 36 | 31 | 0 | 0 | 0 | 0 | 0 | 32 | 35 | 67 | 36 | 31 | 0 | 0 | 0 | 0 | 0 | 32 | 35 | 67 | |||||||||||||||||||||||||||||||||
308622 | 308622 | GA | school | 1305190 | 742 | Turner County | 130519001714 | 1050 | Turner County Specialty School | Alternative School | No | Other | 06 | 12 | 2017 | spring | grade_8 | 1 | 3 | 0 | 0 | 0 | 0 | 0 | 1 | 3 | 4 | 1 | 3 | 0 | 0 | 0 | 0 | 0 | 1 | 3 | 4 | |||||||||||||||||||||||||||||||||
308641 | 308641 | GA | school | 1305220 | 743 | Twiggs County | 130522003611 | 207 | Twiggs Middle School | Regular School | No | Middle | 06 | 08 | 2017 | spring | grade_8 | 28 | 36 | 0 | 0 | 0 | 0 | 2 | 33 | 33 | 66 | 28 | 36 | 0 | 0 | 0 | 0 | 2 | 33 | 33 | 66 | |||||||||||||||||||||||||||||||||
308669 | 308669 | GA | school | 1305250 | 744 | Union County | 130525001721 | 3050 | Woody Gap High/Elementary School | Regular School | No | Other | KG | 12 | 2017 | spring | grade_8 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 2 | 4 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 2 | 4 | |||||||||||||||||||||||||||||||||
308968 | 308968 | GA | school | 1305460 | 749 | Warren County | 130546003462 | 105 | Warren County Middle School | Regular School | No | Middle | 06 | 08 | 2017 | spring | grade_8 | 4 | 43 | 0 | 0 | 0 | 0 | 0 | 23 | 24 | 47 | 4 | 43 | 0 | 0 | 0 | 0 | 0 | 23 | 24 | 47 | |||||||||||||||||||||||||||||||||
309729 | 309729 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012003031 | 605 | KIPP West Atlanta Young Scholars Academy | Regular School | Yes | Middle | 05 | 08 | 2017 | spring | grade_8 | 0 | 82 | 0 | 0 | 0 | 0 | 0 | 38 | 44 | 82 | 0 | 82 | 0 | 0 | 0 | 0 | 0 | 38 | 44 | 82 | |||||||||||||||||||||||||||||||||
309730 | 309730 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012004012 | 123 | Kindezi | Regular School | Yes | Elementary | KG | 08 | 2017 | spring | grade_8 | 0 | 30 | 0 | 0 | 0 | 0 | 0 | 18 | 12 | 30 | 0 | 30 | 0 | 0 | 0 | 0 | 0 | 18 | 12 | 30 | |||||||||||||||||||||||||||||||||
310190 | 310190 | GA | school | 1301870 | 774 | Dublin City | 130187004050 | 412 | Moore Street Facility | Regular School | No | High | 07 | 12 | 2017 | spring | grade_8 | 0 | 5 | 0 | 0 | 0 | 0 | 0 | 3 | 2 | 5 | 0 | 5 | 0 | 0 | 0 | 0 | 0 | 3 | 2 | 5 | |||||||||||||||||||||||||||||||||
310376 | 310376 | GA | school | 1300233 | 7820121 | State Charter Schools- Utopian Academy for the Arts Charter School | 130023304164 | 121 | Utopian Academy for the Arts Charter School | Regular School | Yes | Middle | 06 | 08 | 2017 | spring | grade_8 | 0 | 71 | 0 | 0 | 2 | 0 | 0 | 32 | 41 | 73 | 0 | 71 | 0 | 0 | 2 | 0 | 0 | 32 | 41 | 73 | |||||||||||||||||||||||||||||||||
310409 | 310409 | GA | school | 1300226 | 7820612 | State Charter Schools- Ivy Preparatory Academy, Inc | 130022604023 | 612 | Ivy Preparatory Academy, Inc | Regular School | Yes | Elementary | KG | 08 | 2017 | spring | grade_8 | 0 | 27 | 0 | 0 | 0 | 0 | 0 | 0 | 27 | 27 | 0 | 27 | 0 | 0 | 0 | 0 | 0 | 0 | 27 | 27 | |||||||||||||||||||||||||||||||||
310452 | 310452 | GA | school | 1300005 | 7830103 | State Charter Schools II- Statesboro STEAM Academy | 130000502626 | 103 | Statesboro STEAM Academy | Regular School | Yes | Other | 06 | 12 | 2017 | spring | grade_8 | 17 | 8 | 0 | 0 | 0 | 0 | 0 | 9 | 16 | 25 | 17 | 8 | 0 | 0 | 0 | 0 | 0 | 9 | 16 | 25 | |||||||||||||||||||||||||||||||||
310814 | 310814 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603806 | 1898 | Aaron Cohn Regional Youth Detention Center | Alternative School | No | Other | 05 | 10 | 2017 | spring | grade_8 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | |||||||||||||||||||||||||||||||||
310815 | 310815 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002604089 | 104 | Atlanta Youth Detention Center | Special Education School | No | High | 08 | 12 | 2017 | spring | grade_8 | 0 | 5 | 0 | 0 | 0 | 0 | 0 | 5 | 0 | 5 | 0 | 5 | 0 | 0 | 0 | 0 | 0 | 5 | 0 | 5 | |||||||||||||||||||||||||||||||||
310816 | 310816 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603498 | 1498 | Augusta Regional Youth Detention Center | Alternative School | No | High | 07 | 12 | 2017 | spring | grade_8 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | |||||||||||||||||||||||||||||||||
310817 | 310817 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603488 | 298 | Augusta Youth Development Campus | Alternative School | No | High | 07 | 12 | 2017 | spring | grade_8 | 2 | 4 | 0 | 0 | 0 | 0 | 0 | 6 | 0 | 6 | 2 | 4 | 0 | 0 | 0 | 0 | 0 | 6 | 0 | 6 | |||||||||||||||||||||||||||||||||
310818 | 310818 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603511 | 2798 | Bob Richards Regional Youth Detention Center | Alternative School | No | Other | 09 | 10 | 2017 | spring | grade_8 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | |||||||||||||||||||||||||||||||||
310819 | 310819 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603487 | 205 | Crisp RYDC | Alternative School | No | Other | 05 | 10 | 2017 | spring | grade_8 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | |||||||||||||||||||||||||||||||||
310820 | 310820 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603504 | 2098 | DeKalb Regional Youth Detention Center | Alternative School | No | Other | 07 | 10 | 2017 | spring | grade_8 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | |||||||||||||||||||||||||||||||||
310821 | 310821 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603505 | 2198 | Eastman Regional Youth Detention Center | Alternative School | No | Other | 07 | 10 | 2017 | spring | grade_8 | 1 | 6 | 0 | 0 | 0 | 0 | 0 | 7 | 0 | 7 | 1 | 6 | 0 | 0 | 0 | 0 | 0 | 7 | 0 | 7 | |||||||||||||||||||||||||||||||||
310822 | 310822 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603506 | 2298 | Gainesville Regional Youth Detention Center | Alternative School | No | Other | 07 | 11 | 2017 | spring | grade_8 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | |||||||||||||||||||||||||||||||||
310823 | 310823 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603509 | 2598 | Macon Regional Youth Detention Center | Alternative School | No | Other | 07 | 09 | 2017 | spring | grade_8 | 0 | 3 | 0 | 0 | 0 | 0 | 0 | 3 | 0 | 3 | 0 | 3 | 0 | 0 | 0 | 0 | 0 | 3 | 0 | 3 | |||||||||||||||||||||||||||||||||
310824 | 310824 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603490 | 598 | Macon Youth Development Campus | Alternative School | No | High | 07 | 12 | 2017 | spring | grade_8 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 2 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 2 | |||||||||||||||||||||||||||||||||
310825 | 310825 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603510 | 2698 | Marietta Regional Youth Detention Center | Alternative School | No | Other | 07 | 11 | 2017 | spring | grade_8 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | |||||||||||||||||||||||||||||||||
310826 | 310826 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603500 | 1698 | Martha K. Glaze Regional Youth Detention Center | Alternative School | No | Other | 07 | 11 | 2017 | spring | grade_8 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | |||||||||||||||||||||||||||||||||
310827 | 310827 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603517 | 4198 | Metro Regional Youth Detention Center | Alternative School | No | Other | 06 | 11 | 2017 | spring | grade_8 | 0 | 4 | 0 | 0 | 0 | 0 | 0 | 4 | 0 | 4 | 0 | 4 | 0 | 0 | 0 | 0 | 0 | 4 | 0 | 4 | |||||||||||||||||||||||||||||||||
310828 | 310828 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603650 | 405 | Muscogee Youth Development Center | Alternative School | No | Other | 07 | 11 | 2017 | spring | grade_8 | 1 | 5 | 0 | 0 | 0 | 0 | 1 | 7 | 0 | 7 | 1 | 5 | 0 | 0 | 0 | 0 | 1 | 7 | 0 | 7 | |||||||||||||||||||||||||||||||||
310830 | 310830 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603512 | 2898 | Sandersville Regional Youth Detention Center | Alternative School | No | Other | 08 | 10 | 2017 | spring | grade_8 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | |||||||||||||||||||||||||||||||||
310831 | 310831 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603513 | 2998 | Savannah Regional Youth Detention Center | Alternative School | No | Other | 07 | 10 | 2017 | spring | grade_8 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | |||||||||||||||||||||||||||||||||
310832 | 310832 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603518 | 5001 | Sumter Youth Development Campus | Alternative School | No | High | 08 | 12 | 2017 | spring | grade_8 | 0 | 3 | 0 | 0 | 0 | 0 | 0 | 3 | 0 | 3 | 0 | 3 | 0 | 0 | 0 | 0 | 0 | 3 | 0 | 3 | |||||||||||||||||||||||||||||||||
310833 | 310833 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603514 | 3098 | T J Loftiss II Regional Youth Detention Center | Alternative School | No | Other | 07 | 10 | 2017 | spring | grade_8 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | |||||||||||||||||||||||||||||||||
310834 | 310834 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603515 | 3198 | Waycross Regional Youth Detention Center | Alternative School | No | Other | 09 | 09 | 2017 | spring | grade_8 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | |||||||||||||||||||||||||||||||||
1973282 | 1973282 | GA | school | 1300420 | 611 | Bibb County | 130042003676 | 407 | LakeBridge Behavioral Health System | Special Education School | No | Other | 03 | 12 | 2017 | fall | grade_8 | 5 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 5 | 6 | 5 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 5 | 6 | |||||||||||||||||||||||||||||||||
1973284 | 1973284 | GA | school | 1300420 | 611 | Bibb County | 130042003621 | 307 | Price Academy | Special Education School | No | Elementary | 04 | 08 | 2017 | fall | grade_8 | 3 | 4 | 0 | 0 | 0 | 0 | 0 | 3 | 4 | 7 | 3 | 4 | 0 | 0 | 0 | 0 | 0 | 3 | 4 | 7 | |||||||||||||||||||||||||||||||||
1973392 | 1973392 | GA | school | 1300440 | 612 | Bleckley County | 130044004162 | 115 | Bleckley County Success Academy | Regular School | No | Other | 06 | 12 | 2017 | fall | grade_8 | 6 | 1 | 0 | 0 | 0 | 0 | 1 | 5 | 3 | 8 | 6 | 1 | 0 | 0 | 0 | 0 | 1 | 5 | 3 | 8 | |||||||||||||||||||||||||||||||||
1974324 | 1974324 | GA | school | 1301020 | 625 | Savannah-Chatham County | 130102000410 | 3062 | Low Elementary School | Regular School | No | Other | PK | 11 | 2017 | fall | grade_8 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 2 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 2 | |||||||||||||||||||||||||||||||||
1974332 | 1974332 | GA | school | 1301020 | 625 | Savannah-Chatham County | 130102003610 | 107 | UHS of Savannah Coastal Harbor Treatment Center | Regular School | No | Other | 03 | 11 | 2017 | fall | grade_8 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 2 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 2 | |||||||||||||||||||||||||||||||||
1974520 | 1974520 | GA | school | 1301080 | 627 | Chattooga County | 130108003571 | 111 | Chattooga Academy | Alternative School | No | Other | 01 | 12 | 2017 | fall | grade_8 | 7 | 0 | 0 | 0 | 0 | 0 | 2 | 5 | 4 | 9 | 7 | 0 | 0 | 0 | 0 | 0 | 2 | 5 | 4 | 9 | |||||||||||||||||||||||||||||||||
1974938 | 1974938 | GA | school | 1301200 | 630 | Clay County | 130120002833 | 104 | Clay County Middle School | Regular School | No | Middle | 06 | 08 | 2017 | fall | grade_8 | 0 | 14 | 0 | 0 | 0 | 0 | 0 | 10 | 4 | 14 | 0 | 14 | 0 | 0 | 0 | 0 | 0 | 10 | 4 | 14 | |||||||||||||||||||||||||||||||||
1976712 | 1976712 | GA | school | 1301590 | 641 | Dade County | 130159000777 | 295 | Dade Middle School | Regular School | No | Middle | 06 | 08 | 2017 | fall | grade_8 | 144 | 3 | 0 | 0 | 0 | 0 | 1 | 76 | 72 | 148 | 144 | 3 | 0 | 0 | 0 | 0 | 1 | 76 | 72 | 148 | |||||||||||||||||||||||||||||||||
1976795 | 1976795 | GA | school | 1301710 | 643 | Decatur County | 130171004170 | 116 | New Beginning Learning Center | Regular School | No | Other | 06 | 12 | 2017 | fall | grade_8 | 2 | 3 | 0 | 0 | 0 | 0 | 0 | 3 | 2 | 5 | 2 | 3 | 0 | 0 | 0 | 0 | 0 | 3 | 2 | 5 | |||||||||||||||||||||||||||||||||
1977386 | 1977386 | GA | school | 1301740 | 644 | DeKalb County | 130174002313 | 500 | DeKalb Alternative School | Alternative School | No | Other | 06 | 12 | 2017 | fall | grade_8 | 1 | 19 | 0 | 0 | 0 | 0 | 0 | 18 | 2 | 20 | 1 | 19 | 0 | 0 | 0 | 0 | 0 | 18 | 2 | 20 | |||||||||||||||||||||||||||||||||
1977388 | 1977388 | GA | school | 1301740 | 644 | DeKalb County | 130174004071 | 113 | DeKalb Preparatory Academy Charter | Regular School | Yes | Elementary | KG | 08 | 2017 | fall | grade_8 | 0 | 27 | 0 | 0 | 1 | 0 | 1 | 14 | 15 | 29 | 0 | 27 | 0 | 0 | 1 | 0 | 1 | 14 | 15 | 29 | |||||||||||||||||||||||||||||||||
1977391 | 1977391 | GA | school | 1301740 | 644 | DeKalb County | 130174002642 | 503 | East DeKalb Special Education Center | Special Education School | No | Other | PK | 11 | 2017 | fall | grade_8 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | |||||||||||||||||||||||||||||||||
1977408 | 1977408 | GA | school | 1301740 | 644 | DeKalb County | 130174004159 | 315 | Tapestry Public Charter School | Regular School | Yes | Other | 06 | 10 | 2017 | fall | grade_8 | 17 | 16 | 0 | 0 | 2 | 0 | 2 | 23 | 14 | 37 | 17 | 16 | 0 | 0 | 2 | 0 | 2 | 23 | 14 | 37 | |||||||||||||||||||||||||||||||||
1977411 | 1977411 | GA | school | 1301740 | 644 | DeKalb County | 130174003613 | 707 | UHS of Laurel Heights | Special Education School | No | Other | 02 | 12 | 2017 | fall | grade_8 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | |||||||||||||||||||||||||||||||||
1977749 | 1977749 | GA | school | 1301770 | 645 | Dodge County | 130177004186 | 292 | DAC (Dodge County Achievement Center) | Regular School | No | High | 07 | 12 | 2017 | fall | grade_8 | 1 | 3 | 0 | 0 | 0 | 0 | 0 | 4 | 0 | 4 | 1 | 3 | 0 | 0 | 0 | 0 | 0 | 4 | 0 | 4 | |||||||||||||||||||||||||||||||||
1977874 | 1977874 | GA | school | 1301830 | 647 | Dougherty County | 130183000835 | 5060 | Southside Middle School | Regular School | No | Middle | 06 | 08 | 2017 | fall | grade_8 | 0 | 158 | 0 | 0 | 0 | 0 | 0 | 86 | 72 | 158 | 0 | 158 | 0 | 0 | 0 | 0 | 0 | 86 | 72 | 158 | |||||||||||||||||||||||||||||||||
1978082 | 1978082 | GA | school | 1301860 | 648 | Douglas County | 130186003689 | 507 | Youth Villages at Inner Harbour | Special Education School | No | Other | 03 | 12 | 2017 | fall | grade_8 | 6 | 8 | 0 | 0 | 0 | 0 | 0 | 9 | 5 | 14 | 6 | 8 | 0 | 0 | 0 | 0 | 0 | 9 | 5 | 14 | |||||||||||||||||||||||||||||||||
1978775 | 1978775 | GA | school | 1302220 | 658 | Forsyth County | 130222003995 | 219 | Forsyth Virtual Academy | Regular School | No | Other | 06 | 12 | 2017 | fall | grade_8 | 9 | 0 | 0 | 0 | 1 | 0 | 0 | 3 | 7 | 10 | 9 | 0 | 0 | 0 | 1 | 0 | 0 | 3 | 7 | 10 | |||||||||||||||||||||||||||||||||
1979643 | 1979643 | GA | school | 1302370 | 662 | Glascock County | 130237001055 | 196 | Glascock County Middle/High School | Regular School | No | Other | PK | 12 | 2017 | fall | grade_8 | 43 | 3 | 0 | 0 | 0 | 0 | 1 | 24 | 23 | 47 | 43 | 3 | 0 | 0 | 0 | 0 | 1 | 24 | 23 | 47 | |||||||||||||||||||||||||||||||||
1979719 | 1979719 | GA | school | 1302400 | 663 | Glynn County | 130240003697 | 107 | Morningstar Treatment Services, Inc. Youth Estate | Special Education School | No | Other | 06 | 12 | 2017 | fall | grade_8 | 4 | 2 | 0 | 0 | 0 | 0 | 1 | 5 | 2 | 7 | 4 | 2 | 0 | 0 | 0 | 0 | 1 | 5 | 2 | 7 | |||||||||||||||||||||||||||||||||
1980508 | 1980508 | GA | school | 1302550 | 667 | Gwinnett County | 130255003991 | 1020 | New Life Academy of Excellence | Regular School | Yes | Elementary | KG | 08 | 2017 | fall | grade_8 | 2 | 8 | 0 | 0 | 0 | 0 | 2 | 3 | 9 | 12 | 2 | 8 | 0 | 0 | 0 | 0 | 2 | 3 | 9 | 12 | |||||||||||||||||||||||||||||||||
1980512 | 1980512 | GA | school | 1302550 | 667 | Gwinnett County | 130255003627 | 708 | Oakland Meadow School | Regular School | No | Other | PK | 12 | 2017 | fall | grade_8 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 1 | |||||||||||||||||||||||||||||||||
1980903 | 1980903 | GA | school | 1302580 | 668 | Habersham County | 130258004144 | 114 | Habersham Success Academy | Regular School | No | High | 07 | 12 | 2017 | fall | grade_8 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 1 | 6 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 1 | 6 | |||||||||||||||||||||||||||||||||
1981171 | 1981171 | GA | school | 1302640 | 670 | Hancock County | 130264003539 | 106 | Hancock Central Middle School | Regular School | No | Middle | 06 | 08 | 2017 | fall | grade_8 | 0 | 60 | 0 | 0 | 0 | 0 | 0 | 32 | 28 | 60 | 0 | 60 | 0 | 0 | 0 | 0 | 0 | 32 | 28 | 60 | |||||||||||||||||||||||||||||||||
1981504 | 1981504 | GA | school | 1302820 | 675 | Henry County | 130282004214 | 804 | EXCEL Academy | Regular School | No | Other | 06 | 12 | 2017 | fall | grade_8 | 9 | 8 | 0 | 0 | 1 | 0 | 1 | 13 | 6 | 19 | 9 | 8 | 0 | 0 | 1 | 0 | 1 | 13 | 6 | 19 | |||||||||||||||||||||||||||||||||
1981766 | 1981766 | GA | school | 1302880 | 676 | Houston County | 130288004150 | 116 | Houston County WIN Academy | Regular School | No | Other | 06 | 12 | 2017 | fall | grade_8 | 5 | 18 | 0 | 0 | 1 | 0 | 1 | 20 | 5 | 25 | 5 | 18 | 0 | 0 | 1 | 0 | 1 | 20 | 5 | 25 | |||||||||||||||||||||||||||||||||
1982081 | 1982081 | GA | school | 1303150 | 684 | Jones County | 130315002502 | 101 | Clifton Ridge Middle School | Regular School | No | Middle | 06 | 08 | 2017 | fall | grade_8 | 116 | 58 | 0 | 0 | 1 | 0 | 4 | 90 | 89 | 179 | 116 | 58 | 0 | 0 | 1 | 0 | 4 | 90 | 89 | 179 | |||||||||||||||||||||||||||||||||
1982198 | 1982198 | GA | school | 1303270 | 688 | Lee County | 130327003761 | 209 | Lee High School 9th Grade Campus | Regular School | No | Other | 08 | 10 | 2017 | fall | grade_8 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 2 | |||||||||||||||||||||||||||||||||
1982578 | 1982578 | GA | school | 1303630 | 699 | Meriwether County | 130363004238 | 401 | Greenville Middle School | Regular School | No | Middle | 06 | 08 | 2017 | fall | grade_8 | 24 | 42 | 0 | 0 | 0 | 0 | 0 | 29 | 37 | 66 | 24 | 42 | 0 | 0 | 0 | 0 | 0 | 29 | 37 | 66 | |||||||||||||||||||||||||||||||||
1982765 | 1982765 | GA | school | 1303840 | 705 | Murray County | 130384003574 | 108 | Pleasant Valley Innovative School | Regular School | No | High | 08 | 12 | 2017 | fall | grade_8 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 1 | 3 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 1 | 3 | |||||||||||||||||||||||||||||||||
1983810 | 1983810 | GA | school | 1304290 | 718 | Quitman County | 130429001518 | 199 | Quitman County Elementary | Regular School | No | Elementary | PK | 08 | 2017 | fall | grade_8 | 6 | 27 | 0 | 0 | 0 | 0 | 0 | 17 | 16 | 33 | 6 | 27 | 0 | 0 | 0 | 0 | 0 | 17 | 16 | 33 | |||||||||||||||||||||||||||||||||
1984096 | 1984096 | GA | school | 1304380 | 721 | Richmond County | 130438004211 | 391 | Alternative Education Center at Morgan | Regular School | No | Other | 06 | 12 | 2017 | fall | grade_8 | 1 | 33 | 0 | 0 | 0 | 0 | 1 | 27 | 8 | 35 | 1 | 33 | 0 | 0 | 0 | 0 | 1 | 27 | 8 | 35 | |||||||||||||||||||||||||||||||||
1984103 | 1984103 | GA | school | 1304380 | 721 | Richmond County | 130438003486 | 107 | Lighthouse Care Center of Augusta | Special Education School | No | Other | 04 | 11 | 2017 | fall | grade_8 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 2 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 2 | |||||||||||||||||||||||||||||||||
1984110 | 1984110 | GA | school | 1304380 | 721 | Richmond County | 130438003924 | 115 | W.S. Hornsby Middle School | Regular School | No | Middle | 06 | 08 | 2017 | fall | grade_8 | 1 | 109 | 0 | 0 | 0 | 0 | 0 | 52 | 58 | 110 | 1 | 109 | 0 | 0 | 0 | 0 | 0 | 52 | 58 | 110 | |||||||||||||||||||||||||||||||||
1984568 | 1984568 | GA | school | 1304590 | 728 | Stewart County | 130459002431 | 101 | Stewart County Middle School | Regular School | No | Middle | 06 | 08 | 2017 | fall | grade_8 | 2 | 37 | 0 | 0 | 0 | 0 | 0 | 24 | 15 | 39 | 2 | 37 | 0 | 0 | 0 | 0 | 0 | 24 | 15 | 39 |
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]);