enrollments
Data source: Big Local News · About: Big Local
1,195 rows where grade = "grade_7", state = "GA" and year = 2020 sorted by white
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
310973 | 310973 | GA | school | 1300180 | 604 | Baker County | 130018001867 | 105 | Baker County K12 School | Regular School | No | Other | PK | 12 | 2020 | spring | grade_7 | 0 | 8 | 5 | 0 | 0 | 0 | 1 | 6 | 8 | 14 | 0 | 8 | 5 | 0 | 0 | 0 | 1 | 6 | 8 | 14 | |||||||||||||||||||||||||||||||||
311836 | 311836 | GA | school | 1300750 | 619 | Calhoun County | 130075004098 | 213 | Calhoun County Middle School | Regular School | No | Middle | 06 | 08 | 2020 | spring | grade_7 | 0 | 45 | 2 | 0 | 0 | 0 | 0 | 27 | 20 | 47 | 0 | 45 | 2 | 0 | 0 | 0 | 0 | 27 | 20 | 47 | |||||||||||||||||||||||||||||||||
312464 | 312464 | GA | school | 1301020 | 625 | Savannah-Chatham County | 130102004135 | 128 | Savannah Classical Academy Charter School | Regular School | Yes | Elementary | KG | 08 | 2020 | spring | grade_7 | 0 | 18 | 3 | 0 | 0 | 0 | 2 | 14 | 9 | 23 | 0 | 18 | 3 | 0 | 0 | 0 | 2 | 14 | 9 | 23 | |||||||||||||||||||||||||||||||||
312465 | 312465 | GA | school | 1301020 | 625 | Savannah-Chatham County | 130102004294 | 514 | School of Humanities at Juliette Gordon Low | Regular School | No | Other | PK | 12 | 2020 | spring | grade_7 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | |||||||||||||||||||||||||||||||||
313068 | 313068 | GA | school | 1301200 | 630 | Clay County | 130120002833 | 104 | Clay County Middle School | Regular School | No | Middle | 06 | 08 | 2020 | spring | grade_7 | 0 | 22 | 0 | 0 | 0 | 0 | 0 | 9 | 13 | 22 | 0 | 22 | 0 | 0 | 0 | 0 | 0 | 9 | 13 | 22 | |||||||||||||||||||||||||||||||||
313916 | 313916 | GA | school | 1301290 | 633 | Cobb County | 130129003679 | 807 | Devereux Ackerman Academy | Regular School | No | Other | 04 | 11 | 2020 | spring | grade_7 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | |||||||||||||||||||||||||||||||||
315473 | 315473 | GA | school | 1301740 | 644 | DeKalb County | 130174002480 | 301 | Columbia Middle School | Regular School | No | Middle | 06 | 08 | 2020 | spring | grade_7 | 0 | 253 | 2 | 0 | 1 | 0 | 2 | 134 | 124 | 258 | 0 | 253 | 2 | 0 | 1 | 0 | 2 | 134 | 124 | 258 | |||||||||||||||||||||||||||||||||
315474 | 315474 | GA | school | 1301740 | 644 | DeKalb County | 130174003955 | 1010 | DeKalb Agriculture Technology and Environment School | Regular School | Yes | Elementary | KG | 08 | 2020 | spring | grade_7 | 0 | 79 | 6 | 0 | 1 | 0 | 0 | 41 | 45 | 86 | 0 | 79 | 6 | 0 | 1 | 0 | 0 | 41 | 45 | 86 | |||||||||||||||||||||||||||||||||
315477 | 315477 | GA | school | 1301740 | 644 | DeKalb County | 130174003339 | 705 | DeKalb PATH Academy Charter School | Regular School | Yes | Middle | 05 | 08 | 2020 | spring | grade_7 | 0 | 16 | 73 | 0 | 5 | 0 | 0 | 45 | 49 | 94 | 0 | 16 | 73 | 0 | 5 | 0 | 0 | 45 | 49 | 94 | |||||||||||||||||||||||||||||||||
315478 | 315478 | GA | school | 1301740 | 644 | DeKalb County | 130174004071 | 113 | DeKalb Preparatory Academy Charter | Regular School | Yes | Elementary | KG | 08 | 2020 | spring | grade_7 | 0 | 58 | 2 | 0 | 0 | 0 | 1 | 28 | 33 | 61 | 0 | 58 | 2 | 0 | 0 | 0 | 1 | 28 | 33 | 61 | |||||||||||||||||||||||||||||||||
315480 | 315480 | GA | school | 1301740 | 644 | DeKalb County | 130174002642 | 503 | East DeKalb Special Education Center | Special Education School | No | Other | PK | 12 | 2020 | spring | grade_7 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | |||||||||||||||||||||||||||||||||
315484 | 315484 | GA | school | 1301740 | 644 | DeKalb County | 130174004006 | 311 | Leadership Preparatory Academy | Regular School | Yes | Elementary | KG | 08 | 2020 | spring | grade_7 | 0 | 50 | 2 | 0 | 0 | 0 | 0 | 24 | 28 | 52 | 0 | 50 | 2 | 0 | 0 | 0 | 0 | 24 | 28 | 52 | |||||||||||||||||||||||||||||||||
315489 | 315489 | GA | school | 1301740 | 644 | DeKalb County | 130174001568 | 597 | Miller Grove Middle School | Regular School | No | Middle | 06 | 08 | 2020 | spring | grade_7 | 0 | 279 | 10 | 1 | 0 | 1 | 5 | 147 | 149 | 296 | 0 | 279 | 10 | 1 | 0 | 1 | 5 | 147 | 149 | 296 | |||||||||||||||||||||||||||||||||
315495 | 315495 | GA | school | 1301740 | 644 | DeKalb County | 130174001547 | 397 | Stephenson Middle School | Regular School | No | Middle | 06 | 08 | 2020 | spring | grade_7 | 0 | 287 | 15 | 0 | 1 | 1 | 4 | 160 | 148 | 308 | 0 | 287 | 15 | 0 | 1 | 1 | 4 | 160 | 148 | 308 | |||||||||||||||||||||||||||||||||
315498 | 315498 | GA | school | 1301740 | 644 | DeKalb County | 130174003643 | 507 | The Champion Middle Theme School | Regular School | No | Middle | 06 | 08 | 2020 | spring | grade_7 | 0 | 254 | 0 | 1 | 0 | 1 | 1 | 122 | 135 | 257 | 0 | 254 | 0 | 1 | 0 | 1 | 1 | 122 | 135 | 257 | |||||||||||||||||||||||||||||||||
315892 | 315892 | GA | school | 1301800 | 646 | Dooly County | 130180004286 | 205 | Dooly County Prep Academy | Regular School | No | High | 07 | 12 | 2020 | spring | grade_7 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | |||||||||||||||||||||||||||||||||
317451 | 317451 | GA | school | 1302280 | 660 | Fulton County | 130228002035 | 189 | McNair Middle School | Regular School | No | Middle | 06 | 08 | 2020 | spring | grade_7 | 0 | 289 | 11 | 2 | 1 | 1 | 2 | 158 | 148 | 306 | 0 | 289 | 11 | 2 | 1 | 1 | 2 | 158 | 148 | 306 | |||||||||||||||||||||||||||||||||
317454 | 317454 | GA | school | 1302280 | 660 | Fulton County | 130228004187 | 1313 | RISE Prep School | Regular School | Yes | Middle | 06 | 08 | 2020 | spring | grade_7 | 0 | 62 | 14 | 0 | 0 | 0 | 2 | 44 | 34 | 78 | 0 | 62 | 14 | 0 | 0 | 0 | 2 | 44 | 34 | 78 | |||||||||||||||||||||||||||||||||
318600 | 318600 | GA | school | 1302550 | 667 | Gwinnett County | 130255003690 | 1114 | Gwinnett Intervention Education Center (GIVE) West | Regular School | No | High | 06 | 12 | 2020 | spring | grade_7 | 0 | 13 | 28 | 0 | 0 | 0 | 1 | 29 | 13 | 42 | 0 | 13 | 28 | 0 | 0 | 0 | 1 | 29 | 13 | 42 | |||||||||||||||||||||||||||||||||
319327 | 319327 | GA | school | 1302640 | 670 | Hancock County | 130264003539 | 106 | Hancock Central Middle School | Regular School | No | Middle | 06 | 08 | 2020 | spring | grade_7 | 0 | 66 | 0 | 0 | 0 | 0 | 0 | 31 | 35 | 66 | 0 | 66 | 0 | 0 | 0 | 0 | 0 | 31 | 35 | 66 | |||||||||||||||||||||||||||||||||
319656 | 319656 | GA | school | 1302820 | 675 | Henry County | 130282004214 | 804 | EXCEL Academy | Regular School | No | High | 06 | 12 | 2020 | spring | grade_7 | 0 | 16 | 2 | 0 | 0 | 0 | 0 | 10 | 8 | 18 | 0 | 16 | 2 | 0 | 0 | 0 | 0 | 10 | 8 | 18 | |||||||||||||||||||||||||||||||||
320773 | 320773 | GA | school | 1303690 | 701 | Mitchell County | 130369004330 | 298 | Eagle's Landing Academy | Regular School | No | Elementary | 01 | 02 | 2020 | spring | grade_7 | 0 | 14 | 1 | 0 | 0 | 0 | 1 | 14 | 2 | 16 | 0 | 14 | 1 | 0 | 0 | 0 | 1 | 14 | 2 | 16 | |||||||||||||||||||||||||||||||||
322217 | 322217 | GA | school | 1304380 | 721 | Richmond County | 130438004358 | 396 | Innovation Academy for Girls | Regular School | No | High | 06 | 12 | 2020 | spring | grade_7 | 0 | 16 | 0 | 0 | 0 | 0 | 1 | 0 | 17 | 17 | 0 | 16 | 0 | 0 | 0 | 0 | 1 | 0 | 17 | 17 | |||||||||||||||||||||||||||||||||
323110 | 323110 | GA | school | 1300001 | 741 | Troup County | 130000103620 | 207 | Ault Academy | Regular School | No | Secondary | 06 | 11 | 2020 | spring | grade_7 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | |||||||||||||||||||||||||||||||||
324249 | 324249 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012002798 | 403 | APS-Forrest Hills Academy | Alternative School | No | High | 06 | 12 | 2020 | spring | grade_7 | 0 | 33 | 1 | 0 | 0 | 0 | 0 | 21 | 13 | 34 | 0 | 33 | 1 | 0 | 0 | 0 | 0 | 21 | 13 | 34 | |||||||||||||||||||||||||||||||||
324251 | 324251 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012003558 | 1411 | B.E.S.T Academy | Regular School | No | High | 06 | 12 | 2020 | spring | grade_7 | 0 | 39 | 4 | 0 | 0 | 0 | 0 | 43 | 0 | 43 | 0 | 39 | 4 | 0 | 0 | 0 | 0 | 43 | 0 | 43 | |||||||||||||||||||||||||||||||||
324252 | 324252 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012002344 | 100 | Brown Middle School | Regular School | No | Middle | 06 | 08 | 2020 | spring | grade_7 | 0 | 129 | 2 | 0 | 0 | 1 | 1 | 68 | 65 | 133 | 0 | 129 | 2 | 0 | 0 | 1 | 1 | 68 | 65 | 133 | |||||||||||||||||||||||||||||||||
324256 | 324256 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012003980 | 1410 | Corretta Scott King Womens' Leadership Academy | Regular School | No | High | 06 | 12 | 2020 | spring | grade_7 | 0 | 58 | 3 | 0 | 0 | 1 | 0 | 0 | 62 | 62 | 0 | 58 | 3 | 0 | 0 | 1 | 0 | 0 | 62 | 62 | |||||||||||||||||||||||||||||||||
324260 | 324260 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012003992 | 122 | KIPP VISION | Regular School | Yes | Middle | 05 | 08 | 2020 | spring | grade_7 | 0 | 77 | 3 | 0 | 0 | 0 | 1 | 38 | 43 | 81 | 0 | 77 | 3 | 0 | 0 | 0 | 1 | 38 | 43 | 81 | |||||||||||||||||||||||||||||||||
324261 | 324261 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012003031 | 605 | KIPP West Atlanta Young Scholars Academy | Regular School | Yes | Middle | 05 | 08 | 2020 | spring | grade_7 | 0 | 93 | 1 | 0 | 0 | 0 | 2 | 53 | 43 | 96 | 0 | 93 | 1 | 0 | 0 | 0 | 2 | 53 | 43 | 96 | |||||||||||||||||||||||||||||||||
324263 | 324263 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012004277 | 1417 | Kindezi Old 4th Ward | Regular School | Yes | Elementary | KG | 08 | 2020 | spring | grade_7 | 0 | 43 | 1 | 0 | 0 | 0 | 1 | 26 | 19 | 45 | 0 | 43 | 1 | 0 | 0 | 0 | 1 | 26 | 19 | 45 | |||||||||||||||||||||||||||||||||
324265 | 324265 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012003823 | 115 | Kipp Strive Academy | Regular School | Yes | Middle | 05 | 08 | 2020 | spring | grade_7 | 0 | 100 | 2 | 0 | 0 | 0 | 1 | 51 | 52 | 103 | 0 | 100 | 2 | 0 | 0 | 0 | 1 | 51 | 52 | 103 | |||||||||||||||||||||||||||||||||
324266 | 324266 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012000017 | 173 | Long Middle School | Regular School | No | Middle | 06 | 08 | 2020 | spring | grade_7 | 0 | 213 | 19 | 0 | 0 | 0 | 3 | 125 | 110 | 235 | 0 | 213 | 19 | 0 | 0 | 0 | 3 | 125 | 110 | 235 | |||||||||||||||||||||||||||||||||
324267 | 324267 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012004237 | 1414 | Michael R. Hollis Innovation Academy | Regular School | No | Elementary | PK | 08 | 2020 | spring | grade_7 | 0 | 73 | 2 | 1 | 0 | 0 | 2 | 39 | 39 | 78 | 0 | 73 | 2 | 1 | 0 | 0 | 2 | 39 | 39 | 78 | |||||||||||||||||||||||||||||||||
324269 | 324269 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012000060 | 288 | Price Middle School | Regular School | No | Middle | 06 | 08 | 2020 | spring | grade_7 | 0 | 130 | 2 | 0 | 0 | 0 | 1 | 65 | 68 | 133 | 0 | 130 | 2 | 0 | 0 | 0 | 1 | 65 | 68 | 133 | |||||||||||||||||||||||||||||||||
324271 | 324271 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012000058 | 188 | Sylvan Hills Middle School | Regular School | No | Middle | 06 | 08 | 2020 | spring | grade_7 | 0 | 163 | 2 | 0 | 0 | 0 | 1 | 85 | 81 | 166 | 0 | 163 | 2 | 0 | 0 | 0 | 1 | 85 | 81 | 166 | |||||||||||||||||||||||||||||||||
324273 | 324273 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012004139 | 314 | Westside Atlanta Charter School | Regular School | Yes | Elementary | KG | 08 | 2020 | spring | grade_7 | 0 | 26 | 0 | 0 | 1 | 0 | 0 | 10 | 17 | 27 | 0 | 26 | 0 | 0 | 1 | 0 | 0 | 10 | 17 | 27 | |||||||||||||||||||||||||||||||||
324274 | 324274 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012001866 | 282 | Young Middle School | Regular School | No | Middle | 06 | 08 | 2020 | spring | grade_7 | 0 | 240 | 26 | 0 | 0 | 0 | 2 | 144 | 124 | 268 | 0 | 240 | 26 | 0 | 0 | 0 | 2 | 144 | 124 | 268 | |||||||||||||||||||||||||||||||||
324746 | 324746 | GA | school | 1301870 | 774 | Dublin City | 130187004050 | 412 | Moore Street Facility | Regular School | No | High | 06 | 12 | 2020 | spring | grade_7 | 0 | 3 | 0 | 0 | 0 | 0 | 0 | 2 | 1 | 3 | 0 | 3 | 0 | 0 | 0 | 0 | 0 | 2 | 1 | 3 | |||||||||||||||||||||||||||||||||
324935 | 324935 | 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 | 2020 | spring | grade_7 | 0 | 89 | 5 | 0 | 0 | 0 | 0 | 48 | 46 | 94 | 0 | 89 | 5 | 0 | 0 | 0 | 0 | 48 | 46 | 94 | |||||||||||||||||||||||||||||||||
324963 | 324963 | GA | school | 1300226 | 7820612 | State Charter Schools- Ivy Preparatory Academy, Inc | 130022604023 | 612 | Ivy Preparatory Academy, Inc | Regular School | Yes | Elementary | KG | 08 | 2020 | spring | grade_7 | 0 | 56 | 5 | 0 | 0 | 0 | 1 | 0 | 62 | 62 | 0 | 56 | 5 | 0 | 0 | 0 | 1 | 0 | 62 | 62 | |||||||||||||||||||||||||||||||||
325040 | 325040 | GA | school | 1300217 | 7830310 | State Charter Schools II- Fulton Leadership Academy | 130021703961 | 310 | Fulton Leadership Academy | Regular School | Yes | High | 06 | 12 | 2020 | spring | grade_7 | 0 | 73 | 1 | 0 | 0 | 0 | 2 | 76 | 0 | 76 | 0 | 73 | 1 | 0 | 0 | 0 | 2 | 76 | 0 | 76 | |||||||||||||||||||||||||||||||||
325050 | 325050 | GA | school | 1300221 | 7830410 | State Charter Schools II- Atlanta Heights Charter School | 130022104021 | 410 | Atlanta Heights Charter School | Regular School | Yes | Elementary | KG | 08 | 2020 | spring | grade_7 | 0 | 74 | 3 | 0 | 0 | 0 | 2 | 33 | 46 | 79 | 0 | 74 | 3 | 0 | 0 | 0 | 2 | 33 | 46 | 79 | |||||||||||||||||||||||||||||||||
325112 | 325112 | GA | school | 1300248 | 7830615 | State Charter Schools II- Genesis Innovation Academy for Boys | 130024804288 | 615 | Genesis Innovation Academy for Boys | Regular School | Yes | Elementary | KG | 08 | 2020 | spring | grade_7 | 0 | 30 | 5 | 0 | 0 | 0 | 0 | 35 | 0 | 35 | 0 | 30 | 5 | 0 | 0 | 0 | 0 | 35 | 0 | 35 | |||||||||||||||||||||||||||||||||
325122 | 325122 | GA | school | 1300244 | 7830616 | State Charter Schools II- Genesis Innovation Academy for Girls | 130024404272 | 616 | Genesis Innovation Academy for Girls | Regular School | Yes | Elementary | KG | 08 | 2020 | spring | grade_7 | 0 | 32 | 0 | 0 | 0 | 0 | 0 | 0 | 32 | 32 | 0 | 32 | 0 | 0 | 0 | 0 | 0 | 0 | 32 | 32 | |||||||||||||||||||||||||||||||||
325515 | 325515 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603498 | 1498 | Augusta Regional Youth Detention Center | Alternative School | No | Middle | 06 | 10 | 2020 | spring | grade_7 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | |||||||||||||||||||||||||||||||||
325516 | 325516 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603488 | 298 | Augusta Youth Development Campus | Alternative School | No | High | 08 | 12 | 2020 | spring | grade_7 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | |||||||||||||||||||||||||||||||||
325518 | 325518 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603504 | 2098 | DeKalb Regional Youth Detention Center | Alternative School | No | Secondary | 08 | 10 | 2020 | spring | grade_7 | 0 | 3 | 0 | 0 | 0 | 0 | 0 | 3 | 0 | 3 | 0 | 3 | 0 | 0 | 0 | 0 | 0 | 3 | 0 | 3 | |||||||||||||||||||||||||||||||||
325520 | 325520 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603490 | 598 | Macon Youth Development Campus | Alternative School | No | High | 07 | 12 | 2020 | spring | grade_7 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | |||||||||||||||||||||||||||||||||
325521 | 325521 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603517 | 4198 | Metro Regional Youth Detention Center | Alternative School | No | Secondary | 06 | 10 | 2020 | spring | grade_7 | 0 | 4 | 0 | 0 | 0 | 0 | 0 | 3 | 1 | 4 | 0 | 4 | 0 | 0 | 0 | 0 | 0 | 3 | 1 | 4 | |||||||||||||||||||||||||||||||||
325523 | 325523 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603514 | 3098 | T J Loftiss II Regional Youth Detention Center | Alternative School | No | Secondary | 07 | 10 | 2020 | spring | grade_7 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | |||||||||||||||||||||||||||||||||
418495 | 418495 | GA | school | 1300750 | 619 | Calhoun County | 130075004098 | 213 | Calhoun County Middle School | Regular School | No | Middle | 06 | 08 | 2020 | fall | grade_7 | 0 | 46 | 2 | 0 | 0 | 0 | 0 | 28 | 20 | 48 | 0 | 46 | 2 | 0 | 0 | 0 | 0 | 28 | 20 | 48 | |||||||||||||||||||||||||||||||||
419122 | 419122 | GA | school | 1301020 | 625 | Savannah-Chatham County | 130102004135 | 128 | Savannah Classical Academy Charter School | Regular School | Yes | Elementary | KG | 08 | 2020 | fall | grade_7 | 0 | 17 | 2 | 0 | 0 | 0 | 1 | 13 | 7 | 20 | 0 | 17 | 2 | 0 | 0 | 0 | 1 | 13 | 7 | 20 | |||||||||||||||||||||||||||||||||
419123 | 419123 | GA | school | 1301020 | 625 | Savannah-Chatham County | 130102004294 | 514 | School of Humanities at Juliette Gordon Low | Regular School | No | Other | PK | 12 | 2020 | fall | grade_7 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | |||||||||||||||||||||||||||||||||
419726 | 419726 | GA | school | 1301200 | 630 | Clay County | 130120002833 | 104 | Clay County Middle School | Regular School | No | Middle | 06 | 08 | 2020 | fall | grade_7 | 0 | 21 | 0 | 0 | 0 | 0 | 0 | 9 | 12 | 21 | 0 | 21 | 0 | 0 | 0 | 0 | 0 | 9 | 12 | 21 | |||||||||||||||||||||||||||||||||
419969 | 419969 | GA | school | 1301230 | 631 | Clayton County | 130123004279 | 378 | Eula Wilburn Ponds Perry Center for Learning | Regular School | No | High | 07 | 12 | 2020 | fall | grade_7 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | |||||||||||||||||||||||||||||||||
422135 | 422135 | GA | school | 1301740 | 644 | DeKalb County | 130174002310 | 200 | Cedar Grove Middle School | Regular School | No | Middle | 06 | 08 | 2020 | fall | grade_7 | 0 | 266 | 9 | 2 | 1 | 0 | 7 | 144 | 141 | 285 | 0 | 266 | 9 | 2 | 1 | 0 | 7 | 144 | 141 | 285 | |||||||||||||||||||||||||||||||||
422138 | 422138 | GA | school | 1301740 | 644 | DeKalb County | 130174002480 | 301 | Columbia Middle School | Regular School | No | Middle | 06 | 08 | 2020 | fall | grade_7 | 0 | 273 | 2 | 0 | 1 | 0 | 2 | 143 | 135 | 278 | 0 | 273 | 2 | 0 | 1 | 0 | 2 | 143 | 135 | 278 | |||||||||||||||||||||||||||||||||
422139 | 422139 | GA | school | 1301740 | 644 | DeKalb County | 130174003955 | 1010 | DeKalb Agriculture Technology and Environment School | Regular School | Yes | Elementary | KG | 08 | 2020 | fall | grade_7 | 0 | 78 | 6 | 0 | 1 | 0 | 0 | 41 | 44 | 85 | 0 | 78 | 6 | 0 | 1 | 0 | 0 | 41 | 44 | 85 | |||||||||||||||||||||||||||||||||
422140 | 422140 | GA | school | 1301740 | 644 | DeKalb County | 130174002313 | 500 | DeKalb Alternative School | Alternative School | No | High | 06 | 12 | 2020 | fall | grade_7 | 0 | 16 | 7 | 1 | 1 | 0 | 0 | 20 | 5 | 25 | 0 | 16 | 7 | 1 | 1 | 0 | 0 | 20 | 5 | 25 | |||||||||||||||||||||||||||||||||
422142 | 422142 | GA | school | 1301740 | 644 | DeKalb County | 130174003339 | 705 | DeKalb PATH Academy Charter School | Regular School | Yes | Middle | 05 | 08 | 2020 | fall | grade_7 | 0 | 15 | 74 | 0 | 5 | 0 | 0 | 44 | 50 | 94 | 0 | 15 | 74 | 0 | 5 | 0 | 0 | 44 | 50 | 94 | |||||||||||||||||||||||||||||||||
422143 | 422143 | GA | school | 1301740 | 644 | DeKalb County | 130174004071 | 113 | DeKalb Preparatory Academy Charter | Regular School | Yes | Elementary | KG | 08 | 2020 | fall | grade_7 | 0 | 61 | 2 | 0 | 0 | 0 | 1 | 30 | 34 | 64 | 0 | 61 | 2 | 0 | 0 | 0 | 1 | 30 | 34 | 64 | |||||||||||||||||||||||||||||||||
422148 | 422148 | GA | school | 1301740 | 644 | DeKalb County | 130174004006 | 311 | Leadership Preparatory Academy | Regular School | Yes | Elementary | KG | 08 | 2020 | fall | grade_7 | 0 | 57 | 2 | 0 | 0 | 0 | 0 | 29 | 30 | 59 | 0 | 57 | 2 | 0 | 0 | 0 | 0 | 29 | 30 | 59 | |||||||||||||||||||||||||||||||||
422150 | 422150 | GA | school | 1301740 | 644 | DeKalb County | 130174003868 | 510 | Margaret Harris Comprehensive School | Regular School | No | Other | PK | 12 | 2020 | fall | grade_7 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | |||||||||||||||||||||||||||||||||
422162 | 422162 | GA | school | 1301740 | 644 | DeKalb County | 130174003643 | 507 | The Champion Middle Theme School | Regular School | No | Middle | 06 | 08 | 2020 | fall | grade_7 | 0 | 259 | 0 | 1 | 0 | 1 | 1 | 127 | 135 | 262 | 0 | 259 | 0 | 1 | 0 | 1 | 1 | 127 | 135 | 262 | |||||||||||||||||||||||||||||||||
422556 | 422556 | GA | school | 1301800 | 646 | Dooly County | 130180004286 | 205 | Dooly County Prep Academy | Regular School | No | High | 07 | 12 | 2020 | fall | grade_7 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | |||||||||||||||||||||||||||||||||
424107 | 424107 | GA | school | 1302280 | 660 | Fulton County | 130228003651 | 307 | Georgia Baptist Children's Home and Family Ministries | Regular School | No | Other | 03 | 11 | 2020 | fall | grade_7 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | |||||||||||||||||||||||||||||||||
424114 | 424114 | GA | school | 1302280 | 660 | Fulton County | 130228002035 | 189 | McNair Middle School | Regular School | No | Middle | 06 | 08 | 2020 | fall | grade_7 | 0 | 285 | 11 | 1 | 1 | 1 | 2 | 154 | 147 | 301 | 0 | 285 | 11 | 1 | 1 | 1 | 2 | 154 | 147 | 301 | |||||||||||||||||||||||||||||||||
424117 | 424117 | GA | school | 1302280 | 660 | Fulton County | 130228004187 | 1313 | RISE Prep School | Regular School | Yes | Middle | 06 | 08 | 2020 | fall | grade_7 | 0 | 65 | 14 | 0 | 0 | 0 | 2 | 44 | 37 | 81 | 0 | 65 | 14 | 0 | 0 | 0 | 2 | 44 | 37 | 81 | |||||||||||||||||||||||||||||||||
424121 | 424121 | GA | school | 1302280 | 660 | Fulton County | 130228003368 | 505 | Sandtown Middle School | Regular School | No | Middle | 06 | 08 | 2020 | fall | grade_7 | 0 | 290 | 15 | 0 | 5 | 0 | 8 | 145 | 173 | 318 | 0 | 290 | 15 | 0 | 5 | 0 | 8 | 145 | 173 | 318 | |||||||||||||||||||||||||||||||||
425262 | 425262 | GA | school | 1302550 | 667 | Gwinnett County | 130255003690 | 1114 | Gwinnett Intervention Education Center (GIVE) West | Regular School | No | High | 06 | 12 | 2020 | fall | grade_7 | 0 | 10 | 19 | 0 | 2 | 0 | 1 | 24 | 8 | 32 | 0 | 10 | 19 | 0 | 2 | 0 | 1 | 24 | 8 | 32 | |||||||||||||||||||||||||||||||||
425989 | 425989 | GA | school | 1302640 | 670 | Hancock County | 130264003539 | 106 | Hancock Central Middle School | Regular School | No | Middle | 06 | 08 | 2020 | fall | grade_7 | 0 | 60 | 0 | 0 | 0 | 0 | 0 | 27 | 33 | 60 | 0 | 60 | 0 | 0 | 0 | 0 | 0 | 27 | 33 | 60 | |||||||||||||||||||||||||||||||||
426318 | 426318 | GA | school | 1302820 | 675 | Henry County | 130282004214 | 804 | EXCEL Academy | Regular School | No | High | 06 | 12 | 2020 | fall | grade_7 | 0 | 6 | 2 | 0 | 0 | 0 | 0 | 6 | 2 | 8 | 0 | 6 | 2 | 0 | 0 | 0 | 0 | 6 | 2 | 8 | |||||||||||||||||||||||||||||||||
427380 | 427380 | GA | school | 1303630 | 699 | Meriwether County | 130363003633 | 207 | Good Sheperd Therapeutic Center | Regular School | No | Secondary | 07 | 10 | 2020 | fall | grade_7 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | |||||||||||||||||||||||||||||||||
428868 | 428868 | GA | school | 1304380 | 721 | Richmond County | 130438004368 | 395 | Innovation Academy for Boys | Regular School | No | High | 06 | 12 | 2020 | fall | grade_7 | 0 | 13 | 0 | 0 | 0 | 0 | 0 | 13 | 0 | 13 | 0 | 13 | 0 | 0 | 0 | 0 | 0 | 13 | 0 | 13 | |||||||||||||||||||||||||||||||||
428869 | 428869 | GA | school | 1304380 | 721 | Richmond County | 130438004358 | 396 | Innovation Academy for Girls | Regular School | No | High | 06 | 12 | 2020 | fall | grade_7 | 0 | 9 | 0 | 0 | 0 | 0 | 1 | 0 | 10 | 10 | 0 | 9 | 0 | 0 | 0 | 0 | 1 | 0 | 10 | 10 | |||||||||||||||||||||||||||||||||
429763 | 429763 | GA | school | 1300001 | 741 | Troup County | 130000103620 | 207 | Ault Academy | Regular School | No | Secondary | 06 | 11 | 2020 | fall | grade_7 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | |||||||||||||||||||||||||||||||||
429767 | 429767 | GA | school | 1300001 | 741 | Troup County | 130000104369 | 699 | The Hope Academy School | Regular School | No | High | 06 | 12 | 2020 | fall | grade_7 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | |||||||||||||||||||||||||||||||||
430902 | 430902 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012002798 | 403 | APS-Forrest Hills Academy | Alternative School | No | High | 06 | 12 | 2020 | fall | grade_7 | 0 | 20 | 0 | 0 | 0 | 0 | 0 | 6 | 14 | 20 | 0 | 20 | 0 | 0 | 0 | 0 | 0 | 6 | 14 | 20 | |||||||||||||||||||||||||||||||||
430904 | 430904 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012003558 | 1411 | B.E.S.T Academy | Regular School | No | High | 06 | 12 | 2020 | fall | grade_7 | 0 | 37 | 2 | 0 | 0 | 0 | 0 | 39 | 0 | 39 | 0 | 37 | 2 | 0 | 0 | 0 | 0 | 39 | 0 | 39 | |||||||||||||||||||||||||||||||||
430905 | 430905 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012002344 | 100 | Brown Middle School | Regular School | No | Middle | 06 | 08 | 2020 | fall | grade_7 | 0 | 134 | 1 | 0 | 0 | 1 | 1 | 75 | 62 | 137 | 0 | 134 | 1 | 0 | 0 | 1 | 1 | 75 | 62 | 137 | |||||||||||||||||||||||||||||||||
430909 | 430909 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012003980 | 1410 | Corretta Scott King Womens' Leadership Academy | Regular School | No | High | 06 | 12 | 2020 | fall | grade_7 | 0 | 62 | 3 | 0 | 0 | 1 | 0 | 0 | 66 | 66 | 0 | 62 | 3 | 0 | 0 | 1 | 0 | 0 | 66 | 66 | |||||||||||||||||||||||||||||||||
430913 | 430913 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012003992 | 122 | KIPP VISION | Regular School | Yes | Middle | 05 | 08 | 2020 | fall | grade_7 | 0 | 82 | 3 | 0 | 0 | 0 | 0 | 44 | 41 | 85 | 0 | 82 | 3 | 0 | 0 | 0 | 0 | 44 | 41 | 85 | |||||||||||||||||||||||||||||||||
430914 | 430914 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012003031 | 605 | KIPP West Atlanta Young Scholars Academy | Regular School | Yes | Middle | 05 | 08 | 2020 | fall | grade_7 | 0 | 96 | 1 | 0 | 0 | 0 | 2 | 55 | 44 | 99 | 0 | 96 | 1 | 0 | 0 | 0 | 2 | 55 | 44 | 99 | |||||||||||||||||||||||||||||||||
430916 | 430916 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012004277 | 1417 | Kindezi Old 4th Ward | Regular School | Yes | Elementary | KG | 08 | 2020 | fall | grade_7 | 0 | 41 | 2 | 0 | 0 | 0 | 2 | 26 | 19 | 45 | 0 | 41 | 2 | 0 | 0 | 0 | 2 | 26 | 19 | 45 | |||||||||||||||||||||||||||||||||
430918 | 430918 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012003823 | 115 | Kipp Strive Academy | Regular School | Yes | Middle | 05 | 08 | 2020 | fall | grade_7 | 0 | 98 | 2 | 0 | 0 | 0 | 1 | 50 | 51 | 101 | 0 | 98 | 2 | 0 | 0 | 0 | 1 | 50 | 51 | 101 | |||||||||||||||||||||||||||||||||
430919 | 430919 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012000017 | 173 | Long Middle School | Regular School | No | Middle | 06 | 08 | 2020 | fall | grade_7 | 0 | 231 | 20 | 0 | 0 | 0 | 2 | 133 | 120 | 253 | 0 | 231 | 20 | 0 | 0 | 0 | 2 | 133 | 120 | 253 | |||||||||||||||||||||||||||||||||
430922 | 430922 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012000060 | 288 | Price Middle School | Regular School | No | Middle | 06 | 08 | 2020 | fall | grade_7 | 0 | 124 | 2 | 0 | 0 | 0 | 1 | 62 | 65 | 127 | 0 | 124 | 2 | 0 | 0 | 0 | 1 | 62 | 65 | 127 | |||||||||||||||||||||||||||||||||
430924 | 430924 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012000058 | 188 | Sylvan Hills Middle School | Regular School | No | Middle | 06 | 08 | 2020 | fall | grade_7 | 0 | 171 | 3 | 0 | 0 | 0 | 1 | 89 | 86 | 175 | 0 | 171 | 3 | 0 | 0 | 0 | 1 | 89 | 86 | 175 | |||||||||||||||||||||||||||||||||
430926 | 430926 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012004139 | 314 | Westside Atlanta Charter School | Regular School | Yes | Elementary | KG | 08 | 2020 | fall | grade_7 | 0 | 28 | 1 | 0 | 1 | 0 | 0 | 13 | 17 | 30 | 0 | 28 | 1 | 0 | 1 | 0 | 0 | 13 | 17 | 30 | |||||||||||||||||||||||||||||||||
430927 | 430927 | GA | school | 1300120 | 761 | Atlanta Public Schools | 130012001866 | 282 | Young Middle School | Regular School | No | Middle | 06 | 08 | 2020 | fall | grade_7 | 0 | 234 | 29 | 0 | 0 | 0 | 2 | 139 | 126 | 265 | 0 | 234 | 29 | 0 | 0 | 0 | 2 | 139 | 126 | 265 | |||||||||||||||||||||||||||||||||
431398 | 431398 | GA | school | 1301870 | 774 | Dublin City | 130187004050 | 412 | Moore Street Facility | Regular School | No | High | 06 | 12 | 2020 | fall | grade_7 | 0 | 3 | 0 | 0 | 0 | 0 | 0 | 3 | 0 | 3 | 0 | 3 | 0 | 0 | 0 | 0 | 0 | 3 | 0 | 3 | |||||||||||||||||||||||||||||||||
431617 | 431617 | GA | school | 1300226 | 7820612 | State Charter Schools- Ivy Preparatory Academy, Inc | 130022604023 | 612 | Ivy Preparatory Academy, Inc | Regular School | Yes | Elementary | KG | 08 | 2020 | fall | grade_7 | 0 | 57 | 5 | 0 | 0 | 0 | 1 | 0 | 63 | 63 | 0 | 57 | 5 | 0 | 0 | 0 | 1 | 0 | 63 | 63 | |||||||||||||||||||||||||||||||||
431694 | 431694 | GA | school | 1300217 | 7830310 | State Charter Schools II- Fulton Leadership Academy | 130021703961 | 310 | Fulton Leadership Academy | Regular School | Yes | High | 06 | 12 | 2020 | fall | grade_7 | 0 | 71 | 1 | 0 | 0 | 0 | 2 | 74 | 0 | 74 | 0 | 71 | 1 | 0 | 0 | 0 | 2 | 74 | 0 | 74 | |||||||||||||||||||||||||||||||||
431704 | 431704 | GA | school | 1300221 | 7830410 | State Charter Schools II- Atlanta Heights Charter School | 130022104021 | 410 | Atlanta Heights Charter School | Regular School | Yes | Elementary | KG | 08 | 2020 | fall | grade_7 | 0 | 80 | 3 | 0 | 0 | 0 | 1 | 36 | 48 | 84 | 0 | 80 | 3 | 0 | 0 | 0 | 1 | 36 | 48 | 84 | |||||||||||||||||||||||||||||||||
431766 | 431766 | GA | school | 1300248 | 7830615 | State Charter Schools II- Genesis Innovation Academy for Boys | 130024804288 | 615 | Genesis Innovation Academy for Boys | Regular School | Yes | Elementary | KG | 08 | 2020 | fall | grade_7 | 0 | 32 | 5 | 0 | 0 | 0 | 0 | 37 | 0 | 37 | 0 | 32 | 5 | 0 | 0 | 0 | 0 | 37 | 0 | 37 | |||||||||||||||||||||||||||||||||
431776 | 431776 | GA | school | 1300244 | 7830616 | State Charter Schools II- Genesis Innovation Academy for Girls | 130024404272 | 616 | Genesis Innovation Academy for Girls | Regular School | Yes | Elementary | KG | 08 | 2020 | fall | grade_7 | 0 | 33 | 0 | 0 | 0 | 0 | 0 | 0 | 33 | 33 | 0 | 33 | 0 | 0 | 0 | 0 | 0 | 0 | 33 | 33 | |||||||||||||||||||||||||||||||||
432172 | 432172 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603806 | 1898 | Aaron Cohn Regional Youth Detention Center | Alternative School | No | Secondary | 07 | 10 | 2020 | fall | grade_7 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | |||||||||||||||||||||||||||||||||
432173 | 432173 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002603498 | 1498 | Augusta Regional Youth Detention Center | Alternative School | No | Middle | 06 | 10 | 2020 | fall | grade_7 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | |||||||||||||||||||||||||||||||||
432174 | 432174 | GA | school | 1300026 | 891 | Department of Juvenile Justice | 130002604354 | 4205 | Cadwell RYDC | Special Education School | No | Secondary | 06 | 11 | 2020 | fall | grade_7 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 |
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]);