enrollments
Data source: Big Local News · About: Big Local
29,136 rows where state = "GA" and year = 2017 sorted by district
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1972753 | 1972753 | GA | school | 1300090 | 602 | Atkinson County | 130009000013 | 190 | Pearson Elementary School | Regular School | No | Elementary | PK | 05 | 2017 | fall | grade_3 | 37 | 13 | 49 | 0 | 0 | 0 | 0 | 58 | 41 | 99 | 37 | 13 | 49 | 0 | 0 | 0 | 0 | 58 | 41 | 99 | |||||||||||||||||||||||||||||||||
1972754 | 1972754 | GA | school | 1300090 | 602 | Atkinson County | 130009001965 | 187 | Willacoochee Elementary School | Regular School | No | Elementary | PK | 05 | 2017 | fall | grade_3 | 21 | 13 | 8 | 0 | 0 | 0 | 0 | 20 | 22 | 42 | 21 | 13 | 8 | 0 | 0 | 0 | 0 | 20 | 22 | 42 | |||||||||||||||||||||||||||||||||
1972755 | 1972755 | GA | school | 1300090 | 602 | Atkinson County | 130009000013 | 190 | Pearson Elementary School | Regular School | No | Elementary | PK | 05 | 2017 | fall | grade_4 | 39 | 10 | 47 | 0 | 0 | 0 | 3 | 55 | 44 | 99 | 39 | 10 | 47 | 0 | 0 | 0 | 3 | 55 | 44 | 99 | |||||||||||||||||||||||||||||||||
1972756 | 1972756 | GA | school | 1300090 | 602 | Atkinson County | 130009001965 | 187 | Willacoochee Elementary School | Regular School | No | Elementary | PK | 05 | 2017 | fall | grade_4 | 11 | 2 | 12 | 0 | 0 | 0 | 0 | 13 | 12 | 25 | 11 | 2 | 12 | 0 | 0 | 0 | 0 | 13 | 12 | 25 | |||||||||||||||||||||||||||||||||
1972757 | 1972757 | GA | school | 1300090 | 602 | Atkinson County | 130009000013 | 190 | Pearson Elementary School | Regular School | No | Elementary | PK | 05 | 2017 | fall | grade_5 | 52 | 12 | 44 | 0 | 0 | 0 | 2 | 53 | 57 | 110 | 52 | 12 | 44 | 0 | 0 | 0 | 2 | 53 | 57 | 110 | |||||||||||||||||||||||||||||||||
1972758 | 1972758 | GA | school | 1300090 | 602 | Atkinson County | 130009001965 | 187 | Willacoochee Elementary School | Regular School | No | Elementary | PK | 05 | 2017 | fall | grade_5 | 7 | 6 | 11 | 0 | 0 | 0 | 0 | 13 | 11 | 24 | 7 | 6 | 11 | 0 | 0 | 0 | 0 | 13 | 11 | 24 | |||||||||||||||||||||||||||||||||
1972759 | 1972759 | GA | school | 1300090 | 602 | Atkinson County | 130009003996 | 111 | Atkinson County Middle School | Regular School | No | Middle | 06 | 08 | 2017 | fall | grade_6 | 54 | 23 | 39 | 1 | 1 | 0 | 4 | 54 | 68 | 122 | 54 | 23 | 39 | 1 | 1 | 0 | 4 | 54 | 68 | 122 | |||||||||||||||||||||||||||||||||
1972760 | 1972760 | GA | school | 1300090 | 602 | Atkinson County | 130009003996 | 111 | Atkinson County Middle School | Regular School | No | Middle | 06 | 08 | 2017 | fall | grade_7 | 49 | 19 | 40 | 0 | 0 | 0 | 2 | 58 | 52 | 110 | 49 | 19 | 40 | 0 | 0 | 0 | 2 | 58 | 52 | 110 | |||||||||||||||||||||||||||||||||
1972761 | 1972761 | GA | school | 1300090 | 602 | Atkinson County | 130009003996 | 111 | Atkinson County Middle School | Regular School | No | Middle | 06 | 08 | 2017 | fall | grade_8 | 77 | 18 | 37 | 0 | 0 | 0 | 2 | 77 | 57 | 134 | 77 | 18 | 37 | 0 | 0 | 0 | 2 | 77 | 57 | 134 | |||||||||||||||||||||||||||||||||
1972762 | 1972762 | GA | school | 1300090 | 602 | Atkinson County | 130009000015 | 103 | Atkinson County High School | Regular School | No | High | 09 | 12 | 2017 | fall | grade_9 | 53 | 22 | 63 | 0 | 0 | 0 | 3 | 73 | 68 | 141 | 53 | 22 | 63 | 0 | 0 | 0 | 3 | 73 | 68 | 141 | |||||||||||||||||||||||||||||||||
1972763 | 1972763 | GA | school | 1300090 | 602 | Atkinson County | 130009000013 | 190 | Pearson Elementary School | Regular School | No | Elementary | PK | 05 | 2017 | fall | kindergarten | 37 | 9 | 49 | 0 | 0 | 0 | 0 | 37 | 58 | 95 | 37 | 9 | 49 | 0 | 0 | 0 | 0 | 37 | 58 | 95 | |||||||||||||||||||||||||||||||||
1972764 | 1972764 | GA | school | 1300090 | 602 | Atkinson County | 130009001965 | 187 | Willacoochee Elementary School | Regular School | No | Elementary | PK | 05 | 2017 | fall | kindergarten | 14 | 5 | 12 | 0 | 0 | 0 | 0 | 14 | 17 | 31 | 14 | 5 | 12 | 0 | 0 | 0 | 0 | 14 | 17 | 31 | |||||||||||||||||||||||||||||||||
1972765 | 1972765 | GA | school | 1300090 | 602 | Atkinson County | 130009000015 | 103 | Atkinson County High School | Regular School | No | High | 09 | 12 | 2017 | fall | pk_12_total | 217 | 88 | 170 | 0 | 0 | 0 | 10 | 246 | 239 | 485 | 217 | 88 | 170 | 0 | 0 | 0 | 10 | 246 | 239 | 485 | |||||||||||||||||||||||||||||||||
1972766 | 1972766 | GA | school | 1300090 | 602 | Atkinson County | 130009003996 | 111 | Atkinson County Middle School | Regular School | No | Middle | 06 | 08 | 2017 | fall | pk_12_total | 180 | 60 | 116 | 1 | 1 | 0 | 8 | 189 | 177 | 366 | 180 | 60 | 116 | 1 | 1 | 0 | 8 | 189 | 177 | 366 | |||||||||||||||||||||||||||||||||
1972767 | 1972767 | GA | school | 1300090 | 602 | Atkinson County | 130009000013 | 190 | Pearson Elementary School | Regular School | No | Elementary | PK | 05 | 2017 | fall | pk_12_total | 284 | 85 | 308 | 0 | 0 | 0 | 12 | 352 | 337 | 689 | 284 | 85 | 308 | 0 | 0 | 0 | 12 | 352 | 337 | 689 | |||||||||||||||||||||||||||||||||
1972768 | 1972768 | GA | school | 1300090 | 602 | Atkinson County | 130009001965 | 187 | Willacoochee Elementary School | Regular School | No | Elementary | PK | 05 | 2017 | fall | pk_12_total | 85 | 42 | 69 | 0 | 0 | 0 | 0 | 97 | 99 | 196 | 85 | 42 | 69 | 0 | 0 | 0 | 0 | 97 | 99 | 196 | |||||||||||||||||||||||||||||||||
1972769 | 1972769 | GA | school | 1300090 | 602 | Atkinson County | 130009000013 | 190 | Pearson Elementary School | Regular School | No | Elementary | PK | 05 | 2017 | fall | pre_kindergarten | 36 | 12 | 31 | 0 | 0 | 0 | 3 | 41 | 41 | 82 | 36 | 12 | 31 | 0 | 0 | 0 | 3 | 41 | 41 | 82 | |||||||||||||||||||||||||||||||||
1972770 | 1972770 | GA | school | 1300090 | 602 | Atkinson County | 130009001965 | 187 | Willacoochee Elementary School | Regular School | No | Elementary | PK | 05 | 2017 | fall | pre_kindergarten | 5 | 4 | 8 | 0 | 0 | 0 | 0 | 9 | 8 | 17 | 5 | 4 | 8 | 0 | 0 | 0 | 0 | 9 | 8 | 17 | |||||||||||||||||||||||||||||||||
309336 | 309336 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012004067 | 413 | Adamsville Primary School | Regular School | No | Elementary | PK | 02 | 2017 | spring | grade_1 | 1 | 95 | 3 | 0 | 0 | 0 | 2 | 45 | 56 | 101 | 1 | 95 | 3 | 0 | 0 | 0 | 2 | 45 | 56 | 101 | |||||||||||||||||||||||||||||||||
309337 | 309337 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012004145 | 415 | Atlanta Classical Academy | Regular School | Yes | Other | KG | 10 | 2017 | spring | grade_1 | 51 | 1 | 1 | 0 | 1 | 0 | 1 | 26 | 29 | 55 | 51 | 1 | 1 | 0 | 1 | 0 | 1 | 26 | 29 | 55 | |||||||||||||||||||||||||||||||||
309338 | 309338 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012000077 | 5066 | Barack and Michelle Obama Academy | Regular School | No | Elementary | PK | 05 | 2017 | spring | grade_1 | 0 | 31 | 1 | 0 | 0 | 0 | 0 | 14 | 18 | 32 | 0 | 31 | 1 | 0 | 0 | 0 | 0 | 14 | 18 | 32 | |||||||||||||||||||||||||||||||||
309339 | 309339 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012003030 | 604 | Bazoline E. Usher/Collier Heights Elmentary School | Regular School | No | Elementary | PK | 05 | 2017 | spring | grade_1 | 0 | 57 | 2 | 0 | 1 | 0 | 1 | 30 | 31 | 61 | 0 | 57 | 2 | 0 | 1 | 0 | 1 | 30 | 31 | 61 | |||||||||||||||||||||||||||||||||
309340 | 309340 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012000118 | 3051 | Beecher Hills Elementary School | Regular School | No | Elementary | PK | 05 | 2017 | spring | grade_1 | 0 | 47 | 1 | 0 | 0 | 0 | 0 | 25 | 23 | 48 | 0 | 47 | 1 | 0 | 0 | 0 | 0 | 25 | 23 | 48 | |||||||||||||||||||||||||||||||||
309341 | 309341 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012000073 | 5051 | Benteen Elementary School | Regular School | No | Elementary | PK | 05 | 2017 | spring | grade_1 | 0 | 26 | 19 | 0 | 0 | 0 | 0 | 26 | 19 | 45 | 0 | 26 | 19 | 0 | 0 | 0 | 0 | 26 | 19 | 45 | |||||||||||||||||||||||||||||||||
309342 | 309342 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012003028 | 303 | Bolton Academy | Regular School | No | Elementary | PK | 05 | 2017 | spring | grade_1 | 21 | 30 | 27 | 0 | 0 | 0 | 1 | 37 | 42 | 79 | 21 | 30 | 27 | 0 | 0 | 0 | 1 | 37 | 42 | 79 | |||||||||||||||||||||||||||||||||
309343 | 309343 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012000022 | 1053 | Boyd Elementary School | Regular School | No | Elementary | PK | 05 | 2017 | spring | grade_1 | 0 | 82 | 6 | 0 | 0 | 0 | 0 | 52 | 36 | 88 | 0 | 82 | 6 | 0 | 0 | 0 | 0 | 52 | 36 | 88 | |||||||||||||||||||||||||||||||||
309344 | 309344 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012000127 | 2053 | Brandon Elementary School | Regular School | No | Elementary | KG | 05 | 2017 | spring | grade_1 | 136 | 17 | 5 | 1 | 7 | 0 | 6 | 82 | 90 | 172 | 136 | 17 | 5 | 1 | 7 | 0 | 6 | 82 | 90 | 172 | |||||||||||||||||||||||||||||||||
309345 | 309345 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012003471 | 305 | Burgess-Peterson Elementary School | Regular School | No | Elementary | PK | 05 | 2017 | spring | grade_1 | 13 | 48 | 2 | 0 | 0 | 0 | 1 | 32 | 32 | 64 | 13 | 48 | 2 | 0 | 0 | 0 | 1 | 32 | 32 | 64 | |||||||||||||||||||||||||||||||||
309346 | 309346 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012000092 | 196 | Cascade Elementary School | Regular School | No | Elementary | PK | 05 | 2017 | spring | grade_1 | 0 | 85 | 1 | 0 | 0 | 0 | 0 | 50 | 36 | 86 | 0 | 85 | 1 | 0 | 0 | 0 | 0 | 50 | 36 | 86 | |||||||||||||||||||||||||||||||||
309347 | 309347 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012002290 | 199 | Centennial Academy | Regular School | Yes | Elementary | KG | 08 | 2017 | spring | grade_1 | 6 | 84 | 4 | 0 | 0 | 0 | 5 | 45 | 54 | 99 | 6 | 84 | 4 | 0 | 0 | 0 | 5 | 45 | 54 | 99 | |||||||||||||||||||||||||||||||||
309348 | 309348 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012002453 | 201 | Charles R. Drew Charter School | Regular School | Yes | Elementary | PK | 05 | 2017 | spring | grade_1 | 32 | 112 | 4 | 1 | 0 | 0 | 9 | 80 | 78 | 158 | 32 | 112 | 4 | 1 | 0 | 0 | 9 | 80 | 78 | 158 | |||||||||||||||||||||||||||||||||
309349 | 309349 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012000091 | 4056 | Cleveland Elementary School | Regular School | No | Elementary | PK | 05 | 2017 | spring | grade_1 | 0 | 52 | 6 | 0 | 0 | 0 | 1 | 34 | 25 | 59 | 0 | 52 | 6 | 0 | 0 | 0 | 1 | 34 | 25 | 59 | |||||||||||||||||||||||||||||||||
309350 | 309350 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012000113 | 3057 | Continental Colony Elementary School | Regular School | No | Elementary | PK | 05 | 2017 | spring | grade_1 | 0 | 76 | 1 | 0 | 0 | 0 | 0 | 45 | 32 | 77 | 0 | 76 | 1 | 0 | 0 | 0 | 0 | 45 | 32 | 77 | |||||||||||||||||||||||||||||||||
309351 | 309351 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012003470 | 304 | Deerwood Academy School | Regular School | No | Elementary | PK | 05 | 2017 | spring | grade_1 | 0 | 105 | 1 | 0 | 0 | 0 | 2 | 62 | 46 | 108 | 0 | 105 | 1 | 0 | 0 | 0 | 2 | 62 | 46 | 108 | |||||||||||||||||||||||||||||||||
309352 | 309352 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012003025 | 104 | Dobbs Elementary School | Regular School | No | Elementary | PK | 05 | 2017 | spring | grade_1 | 1 | 75 | 1 | 0 | 0 | 0 | 0 | 41 | 36 | 77 | 1 | 75 | 1 | 0 | 0 | 0 | 0 | 41 | 36 | 77 | |||||||||||||||||||||||||||||||||
309353 | 309353 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012000054 | 5558 | Dunbar Elementary School | Regular School | No | Elementary | KG | 05 | 2017 | spring | grade_1 | 0 | 77 | 0 | 0 | 0 | 0 | 0 | 40 | 37 | 77 | 0 | 77 | 0 | 0 | 0 | 0 | 0 | 40 | 37 | 77 | |||||||||||||||||||||||||||||||||
309354 | 309354 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012002615 | 505 | Elementary | Regular School | Yes | Elementary | KG | 05 | 2017 | spring | grade_1 | 53 | 5 | 5 | 0 | 1 | 0 | 2 | 36 | 30 | 66 | 53 | 5 | 5 | 0 | 1 | 0 | 2 | 36 | 30 | 66 | |||||||||||||||||||||||||||||||||
309355 | 309355 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012000045 | 5566 | F. L. Stanton Elementary School | Regular School | No | Elementary | PK | 05 | 2017 | spring | grade_1 | 0 | 53 | 0 | 0 | 0 | 0 | 0 | 26 | 27 | 53 | 0 | 53 | 0 | 0 | 0 | 0 | 0 | 26 | 27 | 53 | |||||||||||||||||||||||||||||||||
309356 | 309356 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012000110 | 3059 | Fain Elementary School | Regular School | No | Elementary | PK | 05 | 2017 | spring | grade_1 | 0 | 81 | 10 | 0 | 0 | 0 | 0 | 37 | 54 | 91 | 0 | 81 | 10 | 0 | 0 | 0 | 0 | 37 | 54 | 91 | |||||||||||||||||||||||||||||||||
309357 | 309357 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012000103 | 3559 | Fickett Elementary School | Regular School | No | Elementary | PK | 05 | 2017 | spring | grade_1 | 0 | 81 | 2 | 0 | 0 | 0 | 1 | 42 | 42 | 84 | 0 | 81 | 2 | 0 | 0 | 0 | 1 | 42 | 42 | 84 | |||||||||||||||||||||||||||||||||
309358 | 309358 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012003468 | 105 | Finch Elementary | Regular School | No | Elementary | PK | 05 | 2017 | spring | grade_1 | 0 | 91 | 2 | 0 | 0 | 0 | 0 | 47 | 46 | 93 | 0 | 91 | 2 | 0 | 0 | 0 | 0 | 47 | 46 | 93 | |||||||||||||||||||||||||||||||||
309359 | 309359 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012000029 | 1560 | Garden Hills Elementary School | Regular School | No | Elementary | PK | 05 | 2017 | spring | grade_1 | 17 | 16 | 44 | 0 | 2 | 0 | 4 | 48 | 35 | 83 | 17 | 16 | 44 | 0 | 2 | 0 | 4 | 48 | 35 | 83 | |||||||||||||||||||||||||||||||||
309360 | 309360 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012000139 | 2560 | Gideons Elementary School | Regular School | No | Elementary | PK | 05 | 2017 | spring | grade_1 | 0 | 46 | 0 | 0 | 0 | 0 | 0 | 22 | 24 | 46 | 0 | 46 | 0 | 0 | 0 | 0 | 0 | 22 | 24 | 46 | |||||||||||||||||||||||||||||||||
309361 | 309361 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012002613 | 103 | Heritage Academy Elementary | Regular School | No | Elementary | PK | 05 | 2017 | spring | grade_1 | 0 | 70 | 3 | 0 | 2 | 0 | 1 | 44 | 32 | 76 | 0 | 70 | 3 | 0 | 2 | 0 | 1 | 44 | 32 | 76 | |||||||||||||||||||||||||||||||||
309362 | 309362 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012000043 | 5562 | Humphries Elementary School | Regular School | No | Elementary | PK | 05 | 2017 | spring | grade_1 | 0 | 47 | 6 | 1 | 0 | 0 | 0 | 26 | 28 | 54 | 0 | 47 | 6 | 1 | 0 | 0 | 0 | 26 | 28 | 54 | |||||||||||||||||||||||||||||||||
309363 | 309363 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012000039 | 1063 | Hutchinson Elementary School | Regular School | No | Elementary | PK | 05 | 2017 | spring | grade_1 | 0 | 78 | 13 | 1 | 0 | 0 | 3 | 57 | 38 | 95 | 0 | 78 | 13 | 1 | 0 | 0 | 3 | 57 | 38 | 95 | |||||||||||||||||||||||||||||||||
309364 | 309364 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012000137 | 2563 | Jackson Elementary School | Regular School | No | Elementary | KG | 05 | 2017 | spring | grade_1 | 93 | 21 | 7 | 0 | 8 | 0 | 3 | 71 | 61 | 132 | 93 | 21 | 7 | 0 | 8 | 0 | 3 | 71 | 61 | 132 | |||||||||||||||||||||||||||||||||
309365 | 309365 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012004091 | 213 | KIPP Strive Primary | Regular School | Yes | Elementary | KG | 04 | 2017 | spring | grade_1 | 0 | 92 | 1 | 0 | 0 | 0 | 1 | 51 | 43 | 94 | 0 | 92 | 1 | 0 | 0 | 0 | 1 | 51 | 43 | 94 | |||||||||||||||||||||||||||||||||
309366 | 309366 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012004124 | 214 | KIPP Vision Primary | Regular School | Yes | Elementary | KG | 03 | 2017 | spring | grade_1 | 0 | 97 | 5 | 0 | 0 | 0 | 0 | 46 | 56 | 102 | 0 | 97 | 5 | 0 | 0 | 0 | 0 | 46 | 56 | 102 | |||||||||||||||||||||||||||||||||
309367 | 309367 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012000038 | 1064 | Kimberly Elementary School | Regular School | No | Elementary | PK | 05 | 2017 | spring | grade_1 | 0 | 61 | 4 | 0 | 0 | 0 | 0 | 30 | 35 | 65 | 0 | 61 | 4 | 0 | 0 | 0 | 0 | 30 | 35 | 65 | |||||||||||||||||||||||||||||||||
309368 | 309368 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012004012 | 123 | Kindezi | Regular School | Yes | Elementary | KG | 08 | 2017 | spring | grade_1 | 16 | 86 | 3 | 0 | 0 | 0 | 8 | 52 | 61 | 113 | 16 | 86 | 3 | 0 | 0 | 0 | 8 | 52 | 61 | 113 | |||||||||||||||||||||||||||||||||
309369 | 309369 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012004155 | 215 | Kipp WAYS Primary School | Regular School | Yes | Elementary | KG | 02 | 2017 | spring | grade_1 | 0 | 101 | 1 | 1 | 0 | 0 | 2 | 62 | 43 | 105 | 0 | 101 | 1 | 1 | 0 | 0 | 2 | 62 | 43 | 105 | |||||||||||||||||||||||||||||||||
309370 | 309370 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012000136 | 2564 | Lin Elementary School | Regular School | No | Elementary | KG | 05 | 2017 | spring | grade_1 | 80 | 10 | 11 | 0 | 1 | 1 | 5 | 56 | 52 | 108 | 80 | 10 | 11 | 0 | 1 | 1 | 5 | 56 | 52 | 108 | |||||||||||||||||||||||||||||||||
309371 | 309371 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012000085 | 4063 | M. A. Jones Elementary School | Regular School | No | Elementary | PK | 05 | 2017 | spring | grade_1 | 0 | 81 | 2 | 0 | 2 | 0 | 0 | 51 | 34 | 85 | 0 | 81 | 2 | 0 | 2 | 0 | 0 | 51 | 34 | 85 | |||||||||||||||||||||||||||||||||
309372 | 309372 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012004237 | 1414 | Michael R. Hollis Innovation Academy | Regular School | No | Elementary | PK | 05 | 2017 | spring | grade_1 | 0 | 76 | 7 | 0 | 0 | 0 | 2 | 48 | 37 | 85 | 0 | 76 | 7 | 0 | 0 | 0 | 2 | 48 | 37 | 85 | |||||||||||||||||||||||||||||||||
309373 | 309373 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012000130 | 1664 | Morningside Elementary School | Regular School | No | Elementary | KG | 05 | 2017 | spring | grade_1 | 110 | 20 | 13 | 0 | 10 | 0 | 14 | 81 | 86 | 167 | 110 | 20 | 13 | 0 | 10 | 0 | 14 | 81 | 86 | 167 | |||||||||||||||||||||||||||||||||
309374 | 309374 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012002517 | 101 | Parkside Elementary School | Regular School | No | Elementary | PK | 05 | 2017 | spring | grade_1 | 14 | 76 | 7 | 0 | 0 | 0 | 6 | 50 | 53 | 103 | 14 | 76 | 7 | 0 | 0 | 0 | 6 | 50 | 53 | 103 | |||||||||||||||||||||||||||||||||
309375 | 309375 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012000122 | 296 | Perkerson Elementary School | Regular School | No | Elementary | PK | 05 | 2017 | spring | grade_1 | 0 | 70 | 3 | 0 | 0 | 0 | 0 | 32 | 41 | 73 | 0 | 70 | 3 | 0 | 0 | 0 | 0 | 32 | 41 | 73 | |||||||||||||||||||||||||||||||||
309376 | 309376 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012000106 | 3065 | Peyton Forest Elementary School | Regular School | No | Elementary | PK | 05 | 2017 | spring | grade_1 | 0 | 68 | 2 | 0 | 0 | 0 | 0 | 35 | 35 | 70 | 0 | 68 | 2 | 0 | 0 | 0 | 0 | 35 | 35 | 70 | |||||||||||||||||||||||||||||||||
309377 | 309377 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012000036 | 1066 | Rivers Elementary School | Regular School | No | Elementary | PK | 05 | 2017 | spring | grade_1 | 62 | 30 | 20 | 4 | 8 | 1 | 4 | 65 | 64 | 129 | 62 | 30 | 20 | 4 | 8 | 1 | 4 | 65 | 64 | 129 | |||||||||||||||||||||||||||||||||
309378 | 309378 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012000099 | 3566 | Scott Elementary School | Regular School | No | Elementary | PK | 05 | 2017 | spring | grade_1 | 0 | 59 | 4 | 0 | 0 | 0 | 0 | 34 | 29 | 63 | 0 | 59 | 4 | 0 | 0 | 0 | 0 | 34 | 29 | 63 | |||||||||||||||||||||||||||||||||
309379 | 309379 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012000059 | 4066 | Slater Elementary School | Regular School | No | Elementary | PK | 05 | 2017 | spring | grade_1 | 0 | 104 | 3 | 0 | 0 | 0 | 0 | 52 | 55 | 107 | 0 | 104 | 3 | 0 | 0 | 0 | 0 | 52 | 55 | 107 | |||||||||||||||||||||||||||||||||
309380 | 309380 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012000124 | 1567 | Smith Elementary School | Regular School | No | Elementary | KG | 05 | 2017 | spring | grade_1 | 76 | 26 | 41 | 0 | 15 | 0 | 6 | 73 | 91 | 164 | 76 | 26 | 41 | 0 | 15 | 0 | 6 | 73 | 91 | 164 | |||||||||||||||||||||||||||||||||
309381 | 309381 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012003841 | 116 | Springdale Park Elementary School | Regular School | No | Elementary | KG | 05 | 2017 | spring | grade_1 | 58 | 19 | 10 | 0 | 8 | 0 | 12 | 56 | 51 | 107 | 58 | 19 | 10 | 0 | 8 | 0 | 12 | 56 | 51 | 107 | |||||||||||||||||||||||||||||||||
309382 | 309382 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012000143 | 2062 | The John Hope-Charles Walter Hill Elementary Schools | Regular School | No | Elementary | PK | 05 | 2017 | spring | grade_1 | 0 | 73 | 2 | 0 | 0 | 0 | 1 | 35 | 41 | 76 | 0 | 73 | 2 | 0 | 0 | 0 | 1 | 35 | 41 | 76 | |||||||||||||||||||||||||||||||||
309383 | 309383 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012000069 | 5067 | Thomasville Heights Elementary School | Regular School | No | Elementary | PK | 05 | 2017 | spring | grade_1 | 0 | 86 | 0 | 0 | 0 | 0 | 1 | 51 | 36 | 87 | 0 | 86 | 0 | 0 | 0 | 0 | 1 | 51 | 36 | 87 | |||||||||||||||||||||||||||||||||
309384 | 309384 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012000052 | 5567 | Toomer Elementary School | Regular School | No | Elementary | PK | 05 | 2017 | spring | grade_1 | 17 | 33 | 1 | 0 | 0 | 0 | 1 | 28 | 24 | 52 | 17 | 33 | 1 | 0 | 0 | 0 | 1 | 28 | 24 | 52 | |||||||||||||||||||||||||||||||||
309385 | 309385 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012000034 | 1068 | Towns Elementary School | Regular School | No | Elementary | PK | 05 | 2017 | spring | grade_1 | 1 | 42 | 8 | 0 | 0 | 0 | 0 | 29 | 22 | 51 | 1 | 42 | 8 | 0 | 0 | 0 | 0 | 29 | 22 | 51 | |||||||||||||||||||||||||||||||||
309386 | 309386 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012004244 | 1416 | Tuskegee Airman Global Academy | Regular School | No | Elementary | PK | 05 | 2017 | spring | grade_1 | 0 | 119 | 0 | 0 | 0 | 0 | 0 | 69 | 50 | 119 | 0 | 119 | 0 | 0 | 0 | 0 | 0 | 69 | 50 | 119 | |||||||||||||||||||||||||||||||||
309387 | 309387 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012003589 | 1208 | Wesley International Academy Charter Facility | Regular School | Yes | Elementary | KG | 08 | 2017 | spring | grade_1 | 10 | 66 | 4 | 0 | 1 | 0 | 7 | 44 | 44 | 88 | 10 | 66 | 4 | 0 | 1 | 0 | 7 | 44 | 44 | 88 | |||||||||||||||||||||||||||||||||
309388 | 309388 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012000121 | 2569 | West Manor Elementary School | Regular School | No | Elementary | KG | 05 | 2017 | spring | grade_1 | 0 | 29 | 4 | 0 | 0 | 0 | 0 | 20 | 13 | 33 | 0 | 29 | 4 | 0 | 0 | 0 | 0 | 20 | 13 | 33 | |||||||||||||||||||||||||||||||||
309389 | 309389 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012004139 | 314 | Westside Atlanta Charter School | Regular School | Yes | Elementary | KG | 05 | 2017 | spring | grade_1 | 18 | 18 | 3 | 0 | 1 | 0 | 1 | 16 | 25 | 41 | 18 | 18 | 3 | 0 | 1 | 0 | 1 | 16 | 25 | 41 | |||||||||||||||||||||||||||||||||
309390 | 309390 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012000097 | 3569 | Whitefoord Elementary School | Regular School | No | Elementary | PK | 05 | 2017 | spring | grade_1 | 0 | 50 | 0 | 0 | 1 | 0 | 2 | 27 | 26 | 53 | 0 | 50 | 0 | 0 | 1 | 0 | 2 | 27 | 26 | 53 | |||||||||||||||||||||||||||||||||
309391 | 309391 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012004224 | 1415 | Woodson Park Academy | Regular School | No | Elementary | PK | 05 | 2017 | spring | grade_1 | 1 | 99 | 2 | 0 | 0 | 0 | 1 | 42 | 61 | 103 | 1 | 99 | 2 | 0 | 0 | 0 | 1 | 42 | 61 | 103 | |||||||||||||||||||||||||||||||||
309392 | 309392 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012002798 | 403 | APS-Forrest Hills Academy | Alternative School | No | Other | 06 | 12 | 2017 | spring | grade_10 | 0 | 13 | 0 | 0 | 0 | 0 | 0 | 9 | 4 | 13 | 0 | 13 | 0 | 0 | 0 | 0 | 0 | 9 | 4 | 13 | |||||||||||||||||||||||||||||||||
309393 | 309393 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012004145 | 415 | Atlanta Classical Academy | Regular School | Yes | Other | KG | 10 | 2017 | spring | grade_10 | 27 | 9 | 5 | 0 | 0 | 0 | 1 | 14 | 28 | 42 | 27 | 9 | 5 | 0 | 0 | 0 | 1 | 14 | 28 | 42 | |||||||||||||||||||||||||||||||||
309394 | 309394 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012003558 | 1411 | B.E.S.T Academy | Regular School | No | Other | 06 | 12 | 2017 | spring | grade_10 | 0 | 64 | 1 | 0 | 0 | 0 | 0 | 65 | 0 | 65 | 0 | 64 | 1 | 0 | 0 | 0 | 0 | 65 | 0 | 65 | |||||||||||||||||||||||||||||||||
309395 | 309395 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012004174 | 315 | Booker T. Washington High School | Regular School | No | High | 09 | 12 | 2017 | spring | grade_10 | 0 | 194 | 4 | 0 | 0 | 0 | 0 | 91 | 107 | 198 | 0 | 194 | 4 | 0 | 0 | 0 | 0 | 91 | 107 | 198 | |||||||||||||||||||||||||||||||||
309396 | 309396 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012004223 | 1413 | Carver High School | Regular School | No | High | 09 | 12 | 2017 | spring | grade_10 | 0 | 142 | 0 | 0 | 0 | 0 | 0 | 70 | 72 | 142 | 0 | 142 | 0 | 0 | 0 | 0 | 0 | 70 | 72 | 142 | |||||||||||||||||||||||||||||||||
309397 | 309397 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012004161 | 515 | Charles Drew Charter School JA/SA | Regular School | Yes | Other | 06 | 12 | 2017 | spring | grade_10 | 1 | 80 | 3 | 0 | 2 | 0 | 1 | 37 | 50 | 87 | 1 | 80 | 3 | 0 | 2 | 0 | 1 | 37 | 50 | 87 | |||||||||||||||||||||||||||||||||
309398 | 309398 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012003980 | 1410 | Corretta Scott King Womens' Leadership Academy | Regular School | No | Other | 06 | 12 | 2017 | spring | grade_10 | 0 | 72 | 1 | 0 | 0 | 0 | 0 | 0 | 73 | 73 | 0 | 72 | 1 | 0 | 0 | 0 | 0 | 0 | 73 | 73 | |||||||||||||||||||||||||||||||||
309399 | 309399 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012000120 | 2664 | Crim High School | Alternative School | No | High | 09 | 12 | 2017 | spring | grade_10 | 0 | 35 | 0 | 0 | 0 | 0 | 0 | 19 | 16 | 35 | 0 | 35 | 0 | 0 | 0 | 0 | 0 | 19 | 16 | 35 | |||||||||||||||||||||||||||||||||
309400 | 309400 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012000089 | 4058 | Douglass High School | Regular School | No | High | 09 | 12 | 2017 | spring | grade_10 | 0 | 194 | 10 | 0 | 0 | 0 | 1 | 105 | 100 | 205 | 0 | 194 | 10 | 0 | 0 | 0 | 1 | 105 | 100 | 205 | |||||||||||||||||||||||||||||||||
309401 | 309401 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012003540 | 106 | Early College High School at Carver | Regular School | No | High | 09 | 12 | 2017 | spring | grade_10 | 0 | 103 | 6 | 1 | 1 | 0 | 0 | 51 | 60 | 111 | 0 | 103 | 6 | 1 | 1 | 0 | 0 | 51 | 60 | 111 | |||||||||||||||||||||||||||||||||
309402 | 309402 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012000066 | 4560 | Grady High School | Regular School | No | High | 09 | 12 | 2017 | spring | grade_10 | 121 | 178 | 24 | 0 | 5 | 0 | 12 | 160 | 180 | 340 | 121 | 178 | 24 | 0 | 5 | 0 | 12 | 160 | 180 | 340 | |||||||||||||||||||||||||||||||||
309403 | 309403 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012003660 | 207 | Hillside Conant School | Regular School | No | Other | 02 | 12 | 2017 | spring | grade_10 | 7 | 4 | 0 | 0 | 0 | 0 | 1 | 3 | 9 | 12 | 7 | 4 | 0 | 0 | 0 | 0 | 1 | 3 | 9 | 12 | |||||||||||||||||||||||||||||||||
309404 | 309404 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012004059 | 212 | KIPP Atlanta Collegiate Academy | Regular School | Yes | High | 09 | 12 | 2017 | spring | grade_10 | 0 | 191 | 1 | 0 | 0 | 0 | 2 | 87 | 107 | 194 | 0 | 191 | 1 | 0 | 0 | 0 | 2 | 87 | 107 | 194 | |||||||||||||||||||||||||||||||||
309405 | 309405 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012001939 | 186 | Maynard H. Jackson, Jr. High School | Regular School | No | High | 09 | 12 | 2017 | spring | grade_10 | 27 | 256 | 9 | 0 | 2 | 0 | 6 | 146 | 154 | 300 | 27 | 256 | 9 | 0 | 2 | 0 | 6 | 146 | 154 | 300 | |||||||||||||||||||||||||||||||||
309406 | 309406 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012001865 | 182 | Mays High School | Regular School | No | High | 09 | 12 | 2017 | spring | grade_10 | 0 | 342 | 10 | 0 | 0 | 0 | 0 | 153 | 199 | 352 | 0 | 342 | 10 | 0 | 0 | 0 | 0 | 153 | 199 | 352 | |||||||||||||||||||||||||||||||||
309407 | 309407 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012002212 | 192 | North Atlanta High School | Regular School | No | High | 09 | 12 | 2017 | spring | grade_10 | 136 | 183 | 95 | 0 | 9 | 1 | 20 | 219 | 225 | 444 | 136 | 183 | 95 | 0 | 9 | 1 | 20 | 219 | 225 | 444 | |||||||||||||||||||||||||||||||||
309408 | 309408 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012003542 | 306 | School of Technology at Carver | Regular School | No | High | 10 | 12 | 2017 | spring | grade_10 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | |||||||||||||||||||||||||||||||||
309409 | 309409 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012004240 | 1412 | South Atlanta High School | Regular School | No | High | 09 | 12 | 2017 | spring | grade_10 | 1 | 184 | 13 | 0 | 1 | 0 | 1 | 95 | 105 | 200 | 1 | 184 | 13 | 0 | 1 | 0 | 1 | 95 | 105 | 200 | |||||||||||||||||||||||||||||||||
309410 | 309410 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012004215 | 1409 | Therrell High School | Regular School | No | High | 09 | 12 | 2017 | spring | grade_10 | 1 | 193 | 4 | 0 | 0 | 0 | 1 | 94 | 105 | 199 | 1 | 193 | 4 | 0 | 0 | 0 | 1 | 94 | 105 | 199 | |||||||||||||||||||||||||||||||||
309411 | 309411 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012002798 | 403 | APS-Forrest Hills Academy | Alternative School | No | Other | 06 | 12 | 2017 | spring | grade_11 | 0 | 7 | 0 | 0 | 0 | 0 | 0 | 7 | 0 | 7 | 0 | 7 | 0 | 0 | 0 | 0 | 0 | 7 | 0 | 7 | |||||||||||||||||||||||||||||||||
309412 | 309412 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012003558 | 1411 | B.E.S.T Academy | Regular School | No | Other | 06 | 12 | 2017 | spring | grade_11 | 0 | 56 | 1 | 0 | 0 | 1 | 0 | 58 | 0 | 58 | 0 | 56 | 1 | 0 | 0 | 1 | 0 | 58 | 0 | 58 | |||||||||||||||||||||||||||||||||
309413 | 309413 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012004174 | 315 | Booker T. Washington High School | Regular School | No | High | 09 | 12 | 2017 | spring | grade_11 | 1 | 142 | 1 | 0 | 0 | 0 | 1 | 62 | 83 | 145 | 1 | 142 | 1 | 0 | 0 | 0 | 1 | 62 | 83 | 145 | |||||||||||||||||||||||||||||||||
309414 | 309414 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012004223 | 1413 | Carver High School | Regular School | No | High | 09 | 12 | 2017 | spring | grade_11 | 0 | 122 | 1 | 1 | 0 | 0 | 0 | 39 | 85 | 124 | 0 | 122 | 1 | 1 | 0 | 0 | 0 | 39 | 85 | 124 | |||||||||||||||||||||||||||||||||
309415 | 309415 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012004161 | 515 | Charles Drew Charter School JA/SA | Regular School | Yes | Other | 06 | 12 | 2017 | spring | grade_11 | 0 | 67 | 0 | 0 | 0 | 0 | 1 | 28 | 40 | 68 | 0 | 67 | 0 | 0 | 0 | 0 | 1 | 28 | 40 | 68 | |||||||||||||||||||||||||||||||||
309416 | 309416 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012003980 | 1410 | Corretta Scott King Womens' Leadership Academy | Regular School | No | Other | 06 | 12 | 2017 | spring | grade_11 | 0 | 42 | 1 | 0 | 0 | 0 | 0 | 0 | 43 | 43 | 0 | 42 | 1 | 0 | 0 | 0 | 0 | 0 | 43 | 43 | |||||||||||||||||||||||||||||||||
309417 | 309417 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012000120 | 2664 | Crim High School | Alternative School | No | High | 09 | 12 | 2017 | spring | grade_11 | 0 | 29 | 0 | 0 | 0 | 0 | 0 | 18 | 11 | 29 | 0 | 29 | 0 | 0 | 0 | 0 | 0 | 18 | 11 | 29 |
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]);