enrollments
Data source: Big Local News · About: Big Local
2,495 rows where grade = "grade_1", state = "GA" and year = 2018 sorted by district_nces_id
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
733202 | 733202 | GA | school | 1300001 | 741 | Troup County | 130000100643 | 5052 | Berta Weathersbee Elementary School | Regular School | No | Elementary | PK | 05 | 2018 | spring | grade_1 | 6 | 48 | 3 | 0 | 0 | 0 | 2 | 30 | 29 | 59 | 6 | 48 | 3 | 0 | 0 | 0 | 2 | 30 | 29 | 59 | |||||||||||||||||||||||||||||||||
733203 | 733203 | GA | school | 1300001 | 741 | Troup County | 130000103789 | 109 | Callaway Elementary School | Regular School | No | Elementary | PK | 05 | 2018 | spring | grade_1 | 30 | 50 | 6 | 0 | 8 | 0 | 7 | 57 | 44 | 101 | 30 | 50 | 6 | 0 | 8 | 0 | 7 | 57 | 44 | 101 | |||||||||||||||||||||||||||||||||
733204 | 733204 | GA | school | 1300001 | 741 | Troup County | 130000101856 | 597 | Ethel W. Kight Elementary School | Regular School | No | Elementary | PK | 05 | 2018 | spring | grade_1 | 7 | 78 | 14 | 0 | 2 | 0 | 6 | 55 | 52 | 107 | 7 | 78 | 14 | 0 | 2 | 0 | 6 | 55 | 52 | 107 | |||||||||||||||||||||||||||||||||
733205 | 733205 | GA | school | 1300001 | 741 | Troup County | 130000103455 | 205 | Franklin Forest Elementary | Regular School | No | Elementary | PK | 05 | 2018 | spring | grade_1 | 41 | 74 | 11 | 0 | 1 | 0 | 7 | 63 | 71 | 134 | 41 | 74 | 11 | 0 | 1 | 0 | 7 | 63 | 71 | 134 | |||||||||||||||||||||||||||||||||
733206 | 733206 | GA | school | 1300001 | 741 | Troup County | 130000101706 | 3050 | Hillcrest Elementary School | Regular School | No | Elementary | PK | 05 | 2018 | spring | grade_1 | 50 | 6 | 3 | 1 | 3 | 0 | 1 | 32 | 32 | 64 | 50 | 6 | 3 | 1 | 3 | 0 | 1 | 32 | 32 | 64 | |||||||||||||||||||||||||||||||||
733207 | 733207 | GA | school | 1300001 | 741 | Troup County | 130000101853 | 397 | Hogansville Elementary School | Regular School | No | Elementary | PK | 05 | 2018 | spring | grade_1 | 34 | 35 | 4 | 0 | 0 | 0 | 6 | 47 | 32 | 79 | 34 | 35 | 4 | 0 | 0 | 0 | 6 | 47 | 32 | 79 | |||||||||||||||||||||||||||||||||
733208 | 733208 | GA | school | 1300001 | 741 | Troup County | 130000100596 | 194 | Hollis Hand Elementary School | Regular School | No | Elementary | PK | 05 | 2018 | spring | grade_1 | 56 | 24 | 11 | 0 | 2 | 0 | 3 | 49 | 47 | 96 | 56 | 24 | 11 | 0 | 2 | 0 | 3 | 49 | 47 | 96 | |||||||||||||||||||||||||||||||||
733209 | 733209 | GA | school | 1300001 | 741 | Troup County | 130000102011 | 189 | Long Cane Elementary School | Regular School | No | Elementary | PK | 05 | 2018 | spring | grade_1 | 58 | 13 | 0 | 0 | 2 | 0 | 2 | 36 | 39 | 75 | 58 | 13 | 0 | 0 | 2 | 0 | 2 | 36 | 39 | 75 | |||||||||||||||||||||||||||||||||
733210 | 733210 | GA | school | 1300001 | 741 | Troup County | 130000101710 | 5050 | Rosemont Elementary School | Regular School | No | Elementary | PK | 05 | 2018 | spring | grade_1 | 85 | 10 | 2 | 0 | 5 | 1 | 2 | 61 | 44 | 105 | 85 | 10 | 2 | 0 | 5 | 1 | 2 | 61 | 44 | 105 | |||||||||||||||||||||||||||||||||
733211 | 733211 | GA | school | 1300001 | 741 | Troup County | 130000101962 | 187 | West Point Elementary School | Regular School | No | Elementary | PK | 05 | 2018 | spring | grade_1 | 18 | 37 | 2 | 0 | 0 | 0 | 1 | 33 | 25 | 58 | 18 | 37 | 2 | 0 | 0 | 0 | 1 | 33 | 25 | 58 | |||||||||||||||||||||||||||||||||
733212 | 733212 | GA | school | 1300001 | 741 | Troup County | 130000101855 | 497 | Whitesville Road Elementary School | Regular School | No | Elementary | PK | 05 | 2018 | spring | grade_1 | 14 | 67 | 7 | 0 | 0 | 0 | 1 | 43 | 46 | 89 | 14 | 67 | 7 | 0 | 0 | 0 | 1 | 43 | 46 | 89 | |||||||||||||||||||||||||||||||||
1258974 | 1258974 | GA | school | 1300001 | 741 | Troup County | 130000100643 | 5052 | Berta Weathersbee Elementary School | Regular School | No | Elementary | PK | 05 | 2018 | fall | grade_1 | 4 | 54 | 3 | 0 | 0 | 0 | 2 | 32 | 31 | 63 | 4 | 54 | 3 | 0 | 0 | 0 | 2 | 32 | 31 | 63 | |||||||||||||||||||||||||||||||||
1258975 | 1258975 | GA | school | 1300001 | 741 | Troup County | 130000103789 | 109 | Callaway Elementary School | Regular School | No | Elementary | PK | 05 | 2018 | fall | grade_1 | 29 | 49 | 7 | 0 | 8 | 0 | 8 | 60 | 41 | 101 | 29 | 49 | 7 | 0 | 8 | 0 | 8 | 60 | 41 | 101 | |||||||||||||||||||||||||||||||||
1258976 | 1258976 | GA | school | 1300001 | 741 | Troup County | 130000101856 | 597 | Ethel W. Kight Elementary School | Regular School | No | Elementary | PK | 05 | 2018 | fall | grade_1 | 6 | 79 | 15 | 0 | 2 | 0 | 6 | 55 | 53 | 108 | 6 | 79 | 15 | 0 | 2 | 0 | 6 | 55 | 53 | 108 | |||||||||||||||||||||||||||||||||
1258977 | 1258977 | GA | school | 1300001 | 741 | Troup County | 130000103455 | 205 | Franklin Forest Elementary | Regular School | No | Elementary | PK | 05 | 2018 | fall | grade_1 | 42 | 80 | 11 | 0 | 1 | 0 | 7 | 68 | 73 | 141 | 42 | 80 | 11 | 0 | 1 | 0 | 7 | 68 | 73 | 141 | |||||||||||||||||||||||||||||||||
1258978 | 1258978 | GA | school | 1300001 | 741 | Troup County | 130000101706 | 3050 | Hillcrest Elementary School | Regular School | No | Elementary | PK | 05 | 2018 | fall | grade_1 | 51 | 6 | 3 | 1 | 4 | 0 | 1 | 32 | 34 | 66 | 51 | 6 | 3 | 1 | 4 | 0 | 1 | 32 | 34 | 66 | |||||||||||||||||||||||||||||||||
1258979 | 1258979 | GA | school | 1300001 | 741 | Troup County | 130000101853 | 397 | Hogansville Elementary School | Regular School | No | Elementary | PK | 05 | 2018 | fall | grade_1 | 39 | 36 | 4 | 0 | 0 | 0 | 6 | 52 | 33 | 85 | 39 | 36 | 4 | 0 | 0 | 0 | 6 | 52 | 33 | 85 | |||||||||||||||||||||||||||||||||
1258980 | 1258980 | GA | school | 1300001 | 741 | Troup County | 130000100596 | 194 | Hollis Hand Elementary School | Regular School | No | Elementary | PK | 05 | 2018 | fall | grade_1 | 55 | 23 | 11 | 0 | 2 | 0 | 3 | 49 | 45 | 94 | 55 | 23 | 11 | 0 | 2 | 0 | 3 | 49 | 45 | 94 | |||||||||||||||||||||||||||||||||
1258981 | 1258981 | GA | school | 1300001 | 741 | Troup County | 130000102011 | 189 | Long Cane Elementary School | Regular School | No | Elementary | PK | 05 | 2018 | fall | grade_1 | 58 | 13 | 0 | 0 | 3 | 0 | 2 | 36 | 40 | 76 | 58 | 13 | 0 | 0 | 3 | 0 | 2 | 36 | 40 | 76 | |||||||||||||||||||||||||||||||||
1258982 | 1258982 | GA | school | 1300001 | 741 | Troup County | 130000101710 | 5050 | Rosemont Elementary School | Regular School | No | Elementary | PK | 05 | 2018 | fall | grade_1 | 84 | 11 | 3 | 0 | 5 | 1 | 2 | 61 | 45 | 106 | 84 | 11 | 3 | 0 | 5 | 1 | 2 | 61 | 45 | 106 | |||||||||||||||||||||||||||||||||
1258983 | 1258983 | GA | school | 1300001 | 741 | Troup County | 130000101962 | 187 | West Point Elementary School | Regular School | No | Elementary | PK | 05 | 2018 | fall | grade_1 | 18 | 39 | 2 | 0 | 0 | 0 | 1 | 32 | 28 | 60 | 18 | 39 | 2 | 0 | 0 | 0 | 1 | 32 | 28 | 60 | |||||||||||||||||||||||||||||||||
1258984 | 1258984 | GA | school | 1300001 | 741 | Troup County | 130000101855 | 497 | Whitesville Road Elementary School | Regular School | No | Elementary | PK | 05 | 2018 | fall | grade_1 | 14 | 66 | 5 | 0 | 0 | 0 | 2 | 42 | 45 | 87 | 14 | 66 | 5 | 0 | 0 | 0 | 2 | 42 | 45 | 87 | |||||||||||||||||||||||||||||||||
735079 | 735079 | GA | school | 1300023 | 7820110 | State Charter Schools- Odyssey Charter School | 130002303482 | 110 | Odyssey Charter School | Regular School | Yes | Elementary | KG | 08 | 2018 | spring | grade_1 | 19 | 16 | 4 | 0 | 0 | 0 | 0 | 21 | 18 | 39 | 19 | 16 | 4 | 0 | 0 | 0 | 0 | 21 | 18 | 39 | |||||||||||||||||||||||||||||||||
1260847 | 1260847 | GA | school | 1300023 | 7820110 | State Charter Schools- Odyssey Charter School | 130002303482 | 110 | Odyssey Charter School | Regular School | Yes | Elementary | KG | 08 | 2018 | fall | grade_1 | 19 | 17 | 4 | 0 | 0 | 0 | 0 | 22 | 18 | 40 | 19 | 17 | 4 | 0 | 0 | 0 | 0 | 22 | 18 | 40 | |||||||||||||||||||||||||||||||||
721024 | 721024 | GA | school | 1300060 | 601 | Appling County | 130006000011 | 1050 | Altamaha Elementary School | Regular School | No | Elementary | PK | 05 | 2018 | spring | grade_1 | 49 | 7 | 4 | 0 | 1 | 1 | 1 | 33 | 30 | 63 | 49 | 7 | 4 | 0 | 1 | 1 | 1 | 33 | 30 | 63 | |||||||||||||||||||||||||||||||||
721025 | 721025 | GA | school | 1300060 | 601 | Appling County | 130006000006 | 277 | Appling County Primary School | Regular School | No | Elementary | PK | 02 | 2018 | spring | grade_1 | 50 | 41 | 40 | 0 | 4 | 0 | 2 | 68 | 69 | 137 | 50 | 41 | 40 | 0 | 4 | 0 | 2 | 68 | 69 | 137 | |||||||||||||||||||||||||||||||||
721026 | 721026 | GA | school | 1300060 | 601 | Appling County | 130006000008 | 5050 | Fourth District Elementary School | Regular School | No | Elementary | PK | 05 | 2018 | spring | grade_1 | 21 | 1 | 4 | 0 | 0 | 0 | 1 | 13 | 14 | 27 | 21 | 1 | 4 | 0 | 0 | 0 | 1 | 13 | 14 | 27 | |||||||||||||||||||||||||||||||||
1246822 | 1246822 | GA | school | 1300060 | 601 | Appling County | 130006000011 | 1050 | Altamaha Elementary School | Regular School | No | Elementary | PK | 05 | 2018 | fall | grade_1 | 49 | 7 | 4 | 0 | 1 | 1 | 1 | 33 | 30 | 63 | 49 | 7 | 4 | 0 | 1 | 1 | 1 | 33 | 30 | 63 | |||||||||||||||||||||||||||||||||
1246823 | 1246823 | GA | school | 1300060 | 601 | Appling County | 130006000006 | 277 | Appling County Primary School | Regular School | No | Elementary | PK | 02 | 2018 | fall | grade_1 | 51 | 42 | 40 | 0 | 4 | 0 | 2 | 70 | 69 | 139 | 51 | 42 | 40 | 0 | 4 | 0 | 2 | 70 | 69 | 139 | |||||||||||||||||||||||||||||||||
1246824 | 1246824 | GA | school | 1300060 | 601 | Appling County | 130006000008 | 5050 | Fourth District Elementary School | Regular School | No | Elementary | PK | 05 | 2018 | fall | grade_1 | 24 | 2 | 4 | 0 | 0 | 0 | 1 | 17 | 14 | 31 | 24 | 2 | 4 | 0 | 0 | 0 | 1 | 17 | 14 | 31 | |||||||||||||||||||||||||||||||||
721058 | 721058 | GA | school | 1300090 | 602 | Atkinson County | 130009000013 | 190 | Pearson Elementary School | Regular School | No | Elementary | PK | 05 | 2018 | spring | grade_1 | 37 | 12 | 48 | 0 | 0 | 0 | 1 | 38 | 60 | 98 | 37 | 12 | 48 | 0 | 0 | 0 | 1 | 38 | 60 | 98 | |||||||||||||||||||||||||||||||||
721059 | 721059 | GA | school | 1300090 | 602 | Atkinson County | 130009001965 | 187 | Willacoochee Elementary School | Regular School | No | Elementary | PK | 05 | 2018 | spring | grade_1 | 16 | 8 | 10 | 0 | 0 | 0 | 0 | 16 | 18 | 34 | 16 | 8 | 10 | 0 | 0 | 0 | 0 | 16 | 18 | 34 | |||||||||||||||||||||||||||||||||
1246856 | 1246856 | GA | school | 1300090 | 602 | Atkinson County | 130009000013 | 190 | Pearson Elementary School | Regular School | No | Elementary | PK | 05 | 2018 | fall | grade_1 | 38 | 12 | 48 | 0 | 0 | 0 | 1 | 38 | 61 | 99 | 38 | 12 | 48 | 0 | 0 | 0 | 1 | 38 | 61 | 99 | |||||||||||||||||||||||||||||||||
1246857 | 1246857 | GA | school | 1300090 | 602 | Atkinson County | 130009001965 | 187 | Willacoochee Elementary School | Regular School | No | Elementary | PK | 05 | 2018 | fall | grade_1 | 15 | 7 | 10 | 0 | 0 | 0 | 0 | 16 | 16 | 32 | 15 | 7 | 10 | 0 | 0 | 0 | 0 | 16 | 16 | 32 | |||||||||||||||||||||||||||||||||
734053 | 734053 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012004145 | 415 | Atlanta Classical Academy | Regular School | Yes | Other | KG | 11 | 2018 | spring | grade_1 | 41 | 3 | 5 | 0 | 4 | 0 | 1 | 20 | 34 | 54 | 41 | 3 | 5 | 0 | 4 | 0 | 1 | 20 | 34 | 54 | |||||||||||||||||||||||||||||||||
734054 | 734054 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012000077 | 5066 | Barack and Michelle Obama Academy | Regular School | No | Elementary | PK | 05 | 2018 | spring | grade_1 | 0 | 57 | 0 | 0 | 0 | 0 | 0 | 32 | 25 | 57 | 0 | 57 | 0 | 0 | 0 | 0 | 0 | 32 | 25 | 57 | |||||||||||||||||||||||||||||||||
734055 | 734055 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012003030 | 604 | Bazoline E. Usher/Collier Heights Elmentary School | Regular School | No | Elementary | PK | 05 | 2018 | spring | grade_1 | 0 | 77 | 4 | 0 | 0 | 0 | 1 | 47 | 35 | 82 | 0 | 77 | 4 | 0 | 0 | 0 | 1 | 47 | 35 | 82 | |||||||||||||||||||||||||||||||||
734056 | 734056 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012000118 | 3051 | Beecher Hills Elementary School | Regular School | No | Elementary | PK | 05 | 2018 | spring | grade_1 | 2 | 51 | 1 | 0 | 0 | 0 | 0 | 26 | 28 | 54 | 2 | 51 | 1 | 0 | 0 | 0 | 0 | 26 | 28 | 54 | |||||||||||||||||||||||||||||||||
734057 | 734057 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012000073 | 5051 | Benteen Elementary School | Regular School | No | Elementary | PK | 05 | 2018 | spring | grade_1 | 1 | 25 | 14 | 0 | 0 | 0 | 0 | 24 | 16 | 40 | 1 | 25 | 14 | 0 | 0 | 0 | 0 | 24 | 16 | 40 | |||||||||||||||||||||||||||||||||
734058 | 734058 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012003028 | 303 | Bolton Academy | Regular School | No | Elementary | PK | 05 | 2018 | spring | grade_1 | 19 | 30 | 38 | 0 | 0 | 0 | 3 | 48 | 42 | 90 | 19 | 30 | 38 | 0 | 0 | 0 | 3 | 48 | 42 | 90 | |||||||||||||||||||||||||||||||||
734059 | 734059 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012000022 | 1053 | Boyd Elementary School | Regular School | No | Elementary | PK | 05 | 2018 | spring | grade_1 | 0 | 81 | 4 | 0 | 0 | 0 | 2 | 48 | 39 | 87 | 0 | 81 | 4 | 0 | 0 | 0 | 2 | 48 | 39 | 87 | |||||||||||||||||||||||||||||||||
734060 | 734060 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012000127 | 2053 | Brandon Elementary School | Regular School | No | Elementary | KG | 05 | 2018 | spring | grade_1 | 104 | 25 | 10 | 0 | 5 | 0 | 8 | 81 | 71 | 152 | 104 | 25 | 10 | 0 | 5 | 0 | 8 | 81 | 71 | 152 | |||||||||||||||||||||||||||||||||
734061 | 734061 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012003471 | 305 | Burgess-Peterson Elementary School | Regular School | No | Elementary | PK | 05 | 2018 | spring | grade_1 | 8 | 57 | 2 | 1 | 0 | 0 | 2 | 35 | 35 | 70 | 8 | 57 | 2 | 1 | 0 | 0 | 2 | 35 | 35 | 70 | |||||||||||||||||||||||||||||||||
734062 | 734062 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012000092 | 196 | Cascade Elementary School | Regular School | No | Elementary | PK | 05 | 2018 | spring | grade_1 | 0 | 75 | 1 | 0 | 0 | 0 | 0 | 34 | 42 | 76 | 0 | 75 | 1 | 0 | 0 | 0 | 0 | 34 | 42 | 76 | |||||||||||||||||||||||||||||||||
734063 | 734063 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012002290 | 199 | Centennial Academy | Regular School | Yes | Elementary | KG | 08 | 2018 | spring | grade_1 | 3 | 93 | 4 | 0 | 1 | 0 | 5 | 53 | 53 | 106 | 3 | 93 | 4 | 0 | 1 | 0 | 5 | 53 | 53 | 106 | |||||||||||||||||||||||||||||||||
734064 | 734064 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012002453 | 201 | Charles R. Drew Charter School | Regular School | Yes | Elementary | PK | 05 | 2018 | spring | grade_1 | 48 | 96 | 5 | 0 | 0 | 2 | 4 | 79 | 76 | 155 | 48 | 96 | 5 | 0 | 0 | 2 | 4 | 79 | 76 | 155 | |||||||||||||||||||||||||||||||||
734065 | 734065 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012000091 | 4056 | Cleveland Elementary School | Regular School | No | Elementary | PK | 05 | 2018 | spring | grade_1 | 0 | 53 | 1 | 0 | 0 | 0 | 1 | 32 | 23 | 55 | 0 | 53 | 1 | 0 | 0 | 0 | 1 | 32 | 23 | 55 | |||||||||||||||||||||||||||||||||
734066 | 734066 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012000113 | 3057 | Continental Colony Elementary School | Regular School | No | Elementary | PK | 05 | 2018 | spring | grade_1 | 0 | 64 | 0 | 0 | 0 | 0 | 0 | 32 | 32 | 64 | 0 | 64 | 0 | 0 | 0 | 0 | 0 | 32 | 32 | 64 | |||||||||||||||||||||||||||||||||
734067 | 734067 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012003470 | 304 | Deerwood Academy School | Regular School | No | Elementary | PK | 05 | 2018 | spring | grade_1 | 1 | 112 | 3 | 0 | 0 | 0 | 1 | 59 | 58 | 117 | 1 | 112 | 3 | 0 | 0 | 0 | 1 | 59 | 58 | 117 | |||||||||||||||||||||||||||||||||
734068 | 734068 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012003025 | 104 | Dobbs Elementary School | Regular School | No | Elementary | PK | 05 | 2018 | spring | grade_1 | 1 | 69 | 4 | 0 | 0 | 1 | 0 | 47 | 28 | 75 | 1 | 69 | 4 | 0 | 0 | 1 | 0 | 47 | 28 | 75 | |||||||||||||||||||||||||||||||||
734069 | 734069 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012000054 | 5558 | Dunbar Elementary School | Regular School | No | Elementary | KG | 05 | 2018 | spring | grade_1 | 0 | 59 | 2 | 1 | 0 | 0 | 1 | 33 | 30 | 63 | 0 | 59 | 2 | 1 | 0 | 0 | 1 | 33 | 30 | 63 | |||||||||||||||||||||||||||||||||
734070 | 734070 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012002615 | 505 | Elementary | Regular School | Yes | Elementary | KG | 05 | 2018 | spring | grade_1 | 42 | 12 | 2 | 0 | 0 | 0 | 10 | 40 | 26 | 66 | 42 | 12 | 2 | 0 | 0 | 0 | 10 | 40 | 26 | 66 | |||||||||||||||||||||||||||||||||
734071 | 734071 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012000045 | 5566 | F. L. Stanton Elementary School | Regular School | No | Elementary | PK | 05 | 2018 | spring | grade_1 | 0 | 30 | 0 | 0 | 0 | 0 | 0 | 14 | 16 | 30 | 0 | 30 | 0 | 0 | 0 | 0 | 0 | 14 | 16 | 30 | |||||||||||||||||||||||||||||||||
734072 | 734072 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012000110 | 3059 | Fain Elementary School | Regular School | No | Elementary | PK | 05 | 2018 | spring | grade_1 | 0 | 61 | 6 | 0 | 0 | 0 | 0 | 42 | 25 | 67 | 0 | 61 | 6 | 0 | 0 | 0 | 0 | 42 | 25 | 67 | |||||||||||||||||||||||||||||||||
734073 | 734073 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012000103 | 3559 | Fickett Elementary School | Regular School | No | Elementary | PK | 05 | 2018 | spring | grade_1 | 0 | 77 | 1 | 0 | 0 | 0 | 2 | 39 | 41 | 80 | 0 | 77 | 1 | 0 | 0 | 0 | 2 | 39 | 41 | 80 | |||||||||||||||||||||||||||||||||
734074 | 734074 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012003468 | 105 | Finch Elementary | Regular School | No | Elementary | PK | 05 | 2018 | spring | grade_1 | 0 | 76 | 1 | 0 | 0 | 0 | 0 | 40 | 37 | 77 | 0 | 76 | 1 | 0 | 0 | 0 | 0 | 40 | 37 | 77 | |||||||||||||||||||||||||||||||||
734075 | 734075 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012000029 | 1560 | Garden Hills Elementary School | Regular School | No | Elementary | PK | 05 | 2018 | spring | grade_1 | 24 | 12 | 47 | 0 | 2 | 0 | 3 | 43 | 45 | 88 | 24 | 12 | 47 | 0 | 2 | 0 | 3 | 43 | 45 | 88 | |||||||||||||||||||||||||||||||||
734076 | 734076 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012000139 | 2560 | Gideons Elementary School | Regular School | No | Elementary | PK | 05 | 2018 | spring | grade_1 | 1 | 51 | 0 | 0 | 0 | 0 | 0 | 30 | 22 | 52 | 1 | 51 | 0 | 0 | 0 | 0 | 0 | 30 | 22 | 52 | |||||||||||||||||||||||||||||||||
734077 | 734077 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012002613 | 103 | Heritage Academy Elementary | Regular School | No | Elementary | PK | 05 | 2018 | spring | grade_1 | 0 | 75 | 0 | 0 | 0 | 0 | 1 | 34 | 42 | 76 | 0 | 75 | 0 | 0 | 0 | 0 | 1 | 34 | 42 | 76 | |||||||||||||||||||||||||||||||||
734078 | 734078 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012000043 | 5562 | Humphries Elementary School | Regular School | No | Elementary | PK | 05 | 2018 | spring | grade_1 | 0 | 36 | 5 | 0 | 0 | 0 | 2 | 23 | 20 | 43 | 0 | 36 | 5 | 0 | 0 | 0 | 2 | 23 | 20 | 43 | |||||||||||||||||||||||||||||||||
734079 | 734079 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012000039 | 1063 | Hutchinson Elementary School | Regular School | No | Elementary | PK | 05 | 2018 | spring | grade_1 | 0 | 63 | 13 | 0 | 0 | 0 | 1 | 38 | 39 | 77 | 0 | 63 | 13 | 0 | 0 | 0 | 1 | 38 | 39 | 77 | |||||||||||||||||||||||||||||||||
734080 | 734080 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012000137 | 2563 | Jackson Elementary School | Regular School | No | Elementary | PK | 05 | 2018 | spring | grade_1 | 69 | 12 | 11 | 0 | 10 | 0 | 7 | 59 | 50 | 109 | 69 | 12 | 11 | 0 | 10 | 0 | 7 | 59 | 50 | 109 | |||||||||||||||||||||||||||||||||
734081 | 734081 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012004091 | 213 | KIPP Strive Primary | Regular School | Yes | Elementary | KG | 04 | 2018 | spring | grade_1 | 0 | 100 | 2 | 0 | 0 | 0 | 0 | 41 | 61 | 102 | 0 | 100 | 2 | 0 | 0 | 0 | 0 | 41 | 61 | 102 | |||||||||||||||||||||||||||||||||
734082 | 734082 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012004124 | 214 | KIPP Vision Primary | Regular School | Yes | Elementary | KG | 04 | 2018 | spring | grade_1 | 0 | 102 | 1 | 0 | 0 | 0 | 1 | 51 | 53 | 104 | 0 | 102 | 1 | 0 | 0 | 0 | 1 | 51 | 53 | 104 | |||||||||||||||||||||||||||||||||
734083 | 734083 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012000038 | 1064 | Kimberly Elementary School | Regular School | No | Elementary | PK | 05 | 2018 | spring | grade_1 | 0 | 73 | 3 | 0 | 1 | 0 | 0 | 48 | 29 | 77 | 0 | 73 | 3 | 0 | 1 | 0 | 0 | 48 | 29 | 77 | |||||||||||||||||||||||||||||||||
734084 | 734084 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012004012 | 123 | Kindezi | Regular School | Yes | Elementary | KG | 08 | 2018 | spring | grade_1 | 1 | 54 | 0 | 0 | 0 | 1 | 1 | 34 | 23 | 57 | 1 | 54 | 0 | 0 | 0 | 1 | 1 | 34 | 23 | 57 | |||||||||||||||||||||||||||||||||
734085 | 734085 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012004277 | 1417 | Kindezi Old 4th Ward | Regular School | Yes | Elementary | KG | 07 | 2018 | spring | grade_1 | 17 | 33 | 3 | 0 | 1 | 0 | 5 | 31 | 28 | 59 | 17 | 33 | 3 | 0 | 1 | 0 | 5 | 31 | 28 | 59 | |||||||||||||||||||||||||||||||||
734086 | 734086 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012004155 | 215 | Kipp WAYS Primary School | Regular School | Yes | Elementary | KG | 03 | 2018 | spring | grade_1 | 0 | 99 | 0 | 1 | 0 | 0 | 1 | 49 | 52 | 101 | 0 | 99 | 0 | 1 | 0 | 0 | 1 | 49 | 52 | 101 | |||||||||||||||||||||||||||||||||
734087 | 734087 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012000136 | 2564 | Lin Elementary School | Regular School | No | Elementary | KG | 05 | 2018 | spring | grade_1 | 81 | 9 | 9 | 0 | 2 | 0 | 7 | 49 | 59 | 108 | 81 | 9 | 9 | 0 | 2 | 0 | 7 | 49 | 59 | 108 | |||||||||||||||||||||||||||||||||
734088 | 734088 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012000085 | 4063 | M. A. Jones Elementary School | Regular School | No | Elementary | PK | 05 | 2018 | spring | grade_1 | 0 | 58 | 0 | 0 | 0 | 1 | 0 | 37 | 22 | 59 | 0 | 58 | 0 | 0 | 0 | 1 | 0 | 37 | 22 | 59 | |||||||||||||||||||||||||||||||||
734089 | 734089 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012004237 | 1414 | Michael R. Hollis Innovation Academy | Regular School | No | Elementary | PK | 06 | 2018 | spring | grade_1 | 0 | 74 | 1 | 0 | 0 | 0 | 0 | 41 | 34 | 75 | 0 | 74 | 1 | 0 | 0 | 0 | 0 | 41 | 34 | 75 | |||||||||||||||||||||||||||||||||
734090 | 734090 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012000063 | 513 | Miles Elementary School | Regular School | No | Elementary | PK | 05 | 2018 | spring | grade_1 | 0 | 96 | 5 | 0 | 0 | 0 | 0 | 43 | 58 | 101 | 0 | 96 | 5 | 0 | 0 | 0 | 0 | 43 | 58 | 101 | |||||||||||||||||||||||||||||||||
734091 | 734091 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012000130 | 1664 | Morningside Elementary School | Regular School | No | Elementary | KG | 05 | 2018 | spring | grade_1 | 88 | 17 | 21 | 0 | 14 | 0 | 17 | 79 | 78 | 157 | 88 | 17 | 21 | 0 | 14 | 0 | 17 | 79 | 78 | 157 | |||||||||||||||||||||||||||||||||
734092 | 734092 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012002517 | 101 | Parkside Elementary School | Regular School | No | Elementary | PK | 05 | 2018 | spring | grade_1 | 36 | 56 | 6 | 0 | 0 | 0 | 6 | 51 | 53 | 104 | 36 | 56 | 6 | 0 | 0 | 0 | 6 | 51 | 53 | 104 | |||||||||||||||||||||||||||||||||
734093 | 734093 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012000122 | 296 | Perkerson Elementary School | Regular School | No | Elementary | PK | 05 | 2018 | spring | grade_1 | 0 | 66 | 4 | 0 | 0 | 0 | 0 | 40 | 30 | 70 | 0 | 66 | 4 | 0 | 0 | 0 | 0 | 40 | 30 | 70 | |||||||||||||||||||||||||||||||||
734094 | 734094 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012000106 | 3065 | Peyton Forest Elementary School | Regular School | No | Elementary | PK | 05 | 2018 | spring | grade_1 | 0 | 69 | 8 | 0 | 0 | 0 | 0 | 43 | 34 | 77 | 0 | 69 | 8 | 0 | 0 | 0 | 0 | 43 | 34 | 77 | |||||||||||||||||||||||||||||||||
734095 | 734095 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012000036 | 1066 | Rivers Elementary School | Regular School | No | Elementary | PK | 05 | 2018 | spring | grade_1 | 55 | 36 | 21 | 5 | 5 | 0 | 3 | 63 | 62 | 125 | 55 | 36 | 21 | 5 | 5 | 0 | 3 | 63 | 62 | 125 | |||||||||||||||||||||||||||||||||
734096 | 734096 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012000099 | 3566 | Scott Elementary School | Regular School | No | Elementary | PK | 05 | 2018 | spring | grade_1 | 0 | 55 | 4 | 0 | 0 | 0 | 0 | 32 | 27 | 59 | 0 | 55 | 4 | 0 | 0 | 0 | 0 | 32 | 27 | 59 | |||||||||||||||||||||||||||||||||
734097 | 734097 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012000059 | 4066 | Slater Elementary School | Regular School | No | Elementary | PK | 05 | 2018 | spring | grade_1 | 0 | 74 | 2 | 0 | 0 | 0 | 0 | 38 | 38 | 76 | 0 | 74 | 2 | 0 | 0 | 0 | 0 | 38 | 38 | 76 | |||||||||||||||||||||||||||||||||
734098 | 734098 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012000124 | 1567 | Smith Elementary School | Regular School | No | Elementary | KG | 05 | 2018 | spring | grade_1 | 78 | 21 | 33 | 1 | 11 | 0 | 15 | 79 | 80 | 159 | 78 | 21 | 33 | 1 | 11 | 0 | 15 | 79 | 80 | 159 | |||||||||||||||||||||||||||||||||
734099 | 734099 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012003841 | 116 | Springdale Park Elementary School | Regular School | No | Elementary | KG | 05 | 2018 | spring | grade_1 | 83 | 16 | 14 | 0 | 5 | 0 | 9 | 60 | 67 | 127 | 83 | 16 | 14 | 0 | 5 | 0 | 9 | 60 | 67 | 127 | |||||||||||||||||||||||||||||||||
734100 | 734100 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012000143 | 2062 | The John Hope-Charles Walter Hill Elementary Schools | Regular School | No | Elementary | PK | 05 | 2018 | spring | grade_1 | 4 | 69 | 3 | 0 | 1 | 0 | 0 | 29 | 48 | 77 | 4 | 69 | 3 | 0 | 1 | 0 | 0 | 29 | 48 | 77 | |||||||||||||||||||||||||||||||||
734101 | 734101 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012000069 | 5067 | Thomasville Heights Elementary School | Regular School | No | Elementary | PK | 05 | 2018 | spring | grade_1 | 0 | 76 | 2 | 0 | 1 | 0 | 0 | 37 | 42 | 79 | 0 | 76 | 2 | 0 | 1 | 0 | 0 | 37 | 42 | 79 | |||||||||||||||||||||||||||||||||
734102 | 734102 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012000052 | 5567 | Toomer Elementary School | Regular School | No | Elementary | PK | 05 | 2018 | spring | grade_1 | 15 | 52 | 2 | 0 | 1 | 0 | 1 | 37 | 34 | 71 | 15 | 52 | 2 | 0 | 1 | 0 | 1 | 37 | 34 | 71 | |||||||||||||||||||||||||||||||||
734103 | 734103 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012000034 | 1068 | Towns Elementary School | Regular School | No | Elementary | PK | 05 | 2018 | spring | grade_1 | 0 | 53 | 8 | 0 | 0 | 0 | 2 | 35 | 28 | 63 | 0 | 53 | 8 | 0 | 0 | 0 | 2 | 35 | 28 | 63 | |||||||||||||||||||||||||||||||||
734104 | 734104 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012004244 | 1416 | Tuskegee Airman Global Academy | Regular School | No | Elementary | PK | 05 | 2018 | spring | grade_1 | 0 | 121 | 0 | 1 | 0 | 0 | 0 | 70 | 52 | 122 | 0 | 121 | 0 | 1 | 0 | 0 | 0 | 70 | 52 | 122 | |||||||||||||||||||||||||||||||||
734105 | 734105 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012003589 | 1208 | Wesley International Academy Charter Facility | Regular School | Yes | Elementary | KG | 08 | 2018 | spring | grade_1 | 12 | 62 | 7 | 0 | 0 | 0 | 6 | 42 | 45 | 87 | 12 | 62 | 7 | 0 | 0 | 0 | 6 | 42 | 45 | 87 | |||||||||||||||||||||||||||||||||
734106 | 734106 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012000121 | 2569 | West Manor Elementary School | Regular School | No | Elementary | KG | 05 | 2018 | spring | grade_1 | 0 | 42 | 5 | 0 | 0 | 0 | 0 | 28 | 19 | 47 | 0 | 42 | 5 | 0 | 0 | 0 | 0 | 28 | 19 | 47 | |||||||||||||||||||||||||||||||||
734107 | 734107 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012004139 | 314 | Westside Atlanta Charter School | Regular School | Yes | Elementary | KG | 06 | 2018 | spring | grade_1 | 18 | 20 | 1 | 0 | 0 | 0 | 1 | 23 | 17 | 40 | 18 | 20 | 1 | 0 | 0 | 0 | 1 | 23 | 17 | 40 | |||||||||||||||||||||||||||||||||
734108 | 734108 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012004224 | 1415 | Woodson Park Academy | Regular School | No | Elementary | PK | 05 | 2018 | spring | grade_1 | 0 | 92 | 1 | 0 | 1 | 0 | 0 | 50 | 44 | 94 | 0 | 92 | 1 | 0 | 1 | 0 | 0 | 50 | 44 | 94 | |||||||||||||||||||||||||||||||||
1259823 | 1259823 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012004145 | 415 | Atlanta Classical Academy | Regular School | Yes | Other | KG | 11 | 2018 | fall | grade_1 | 41 | 3 | 5 | 0 | 4 | 0 | 1 | 20 | 34 | 54 | 41 | 3 | 5 | 0 | 4 | 0 | 1 | 20 | 34 | 54 | |||||||||||||||||||||||||||||||||
1259824 | 1259824 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012000077 | 5066 | Barack and Michelle Obama Academy | Regular School | No | Elementary | PK | 05 | 2018 | fall | grade_1 | 0 | 51 | 0 | 0 | 0 | 0 | 0 | 29 | 22 | 51 | 0 | 51 | 0 | 0 | 0 | 0 | 0 | 29 | 22 | 51 | |||||||||||||||||||||||||||||||||
1259825 | 1259825 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012003030 | 604 | Bazoline E. Usher/Collier Heights Elmentary School | Regular School | No | Elementary | PK | 05 | 2018 | fall | grade_1 | 0 | 79 | 3 | 0 | 0 | 0 | 1 | 46 | 37 | 83 | 0 | 79 | 3 | 0 | 0 | 0 | 1 | 46 | 37 | 83 | |||||||||||||||||||||||||||||||||
1259826 | 1259826 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012000118 | 3051 | Beecher Hills Elementary School | Regular School | No | Elementary | PK | 05 | 2018 | fall | grade_1 | 2 | 54 | 0 | 0 | 0 | 0 | 0 | 27 | 29 | 56 | 2 | 54 | 0 | 0 | 0 | 0 | 0 | 27 | 29 | 56 | |||||||||||||||||||||||||||||||||
1259827 | 1259827 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012000073 | 5051 | Benteen Elementary School | Regular School | No | Elementary | PK | 05 | 2018 | fall | grade_1 | 1 | 25 | 14 | 0 | 0 | 0 | 0 | 26 | 14 | 40 | 1 | 25 | 14 | 0 | 0 | 0 | 0 | 26 | 14 | 40 | |||||||||||||||||||||||||||||||||
1259828 | 1259828 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012003028 | 303 | Bolton Academy | Regular School | No | Elementary | PK | 05 | 2018 | fall | grade_1 | 18 | 27 | 39 | 0 | 0 | 0 | 3 | 46 | 41 | 87 | 18 | 27 | 39 | 0 | 0 | 0 | 3 | 46 | 41 | 87 | |||||||||||||||||||||||||||||||||
1259829 | 1259829 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012000022 | 1053 | Boyd Elementary School | Regular School | No | Elementary | PK | 05 | 2018 | fall | grade_1 | 0 | 79 | 4 | 0 | 0 | 0 | 2 | 47 | 38 | 85 | 0 | 79 | 4 | 0 | 0 | 0 | 2 | 47 | 38 | 85 | |||||||||||||||||||||||||||||||||
1259830 | 1259830 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012000127 | 2053 | Brandon Elementary School | Regular School | No | Elementary | KG | 05 | 2018 | fall | grade_1 | 104 | 25 | 10 | 0 | 7 | 0 | 8 | 83 | 71 | 154 | 104 | 25 | 10 | 0 | 7 | 0 | 8 | 83 | 71 | 154 | |||||||||||||||||||||||||||||||||
1259831 | 1259831 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012003471 | 305 | Burgess-Peterson Elementary School | Regular School | No | Elementary | PK | 05 | 2018 | fall | grade_1 | 8 | 53 | 2 | 1 | 0 | 0 | 3 | 33 | 34 | 67 | 8 | 53 | 2 | 1 | 0 | 0 | 3 | 33 | 34 | 67 | |||||||||||||||||||||||||||||||||
1259832 | 1259832 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012000092 | 196 | Cascade Elementary School | Regular School | No | Elementary | PK | 05 | 2018 | fall | grade_1 | 0 | 72 | 1 | 0 | 1 | 0 | 0 | 33 | 41 | 74 | 0 | 72 | 1 | 0 | 1 | 0 | 0 | 33 | 41 | 74 |
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]);