Data source: Big Local News · About: Big Local

1,184 rows where grade = "grade_7", state = "GA" and year = 2017 sorted by total

View and edit SQL

year

  • 2017 · 1,184

grade

  • grade_7 · 1,184
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
300958 GA     school 1301740 644   DeKalb County 130174002642 503 East DeKalb Special Education Center   Special Education School No Other PK 11 2017 spring grade_7 0 1 0 0   0       0 0   1 0                       1 0 1 0 0   0       0 0   1 0                 1
302934 GA     school 1302280 660   Fulton County 130228004261 1321 Wellspring Living   Regular School No Other 09 10 2017 spring grade_7 1 0 0 0   0       0 0   0 1                       1 1 0 0 0   0       0 0   0 1                 1
304080 GA     school 1302550 667   Gwinnett County 130255003627 708 Oakland Meadow School   Regular School No Other PK 12 2017 spring grade_7 0 1 0 0   0       0 0   1 0                       1 0 1 0 0   0       0 0   1 0                 1
310800 GA     school 1300026 891   Department of Juvenile Justice 130002604089 104 Atlanta Youth Detention Center   Special Education School No High 08 12 2017 spring grade_7 0 1 0 0   0       0 0   1 0                       1 0 1 0 0   0       0 0   1 0                 1
310801 GA     school 1300026 891   Department of Juvenile Justice 130002603498 1498 Augusta Regional Youth Detention Center   Alternative School No High 07 12 2017 spring grade_7 0 1 0 0   0       0 0   1 0                       1 0 1 0 0   0       0 0   1 0                 1
310802 GA     school 1300026 891   Department of Juvenile Justice 130002603488 298 Augusta Youth Development Campus   Alternative School No High 07 12 2017 spring grade_7 0 1 0 0   0       0 0   1 0                       1 0 1 0 0   0       0 0   1 0                 1
310806 GA     school 1300026 891   Department of Juvenile Justice 130002603504 2098 DeKalb Regional Youth Detention Center   Alternative School No Other 07 10 2017 spring grade_7 0 1 0 0   0       0 0   1 0                       1 0 1 0 0   0       0 0   1 0                 1
310811 GA     school 1300026 891   Department of Juvenile Justice 130002603512 2898 Sandersville Regional Youth Detention Center   Alternative School No Other 08 10 2017 spring grade_7 0 1 0 0   0       0 0   1 0                       1 0 1 0 0   0       0 0   1 0                 1
1977360 GA     school 1301740 644   DeKalb County 130174002642 503 East DeKalb Special Education Center   Special Education School No Other PK 11 2017 fall grade_7 0 1 0 0   0       0 0   1 0                       1 0 1 0 0   0       0 0   1 0                 1
1980477 GA     school 1302550 667   Gwinnett County 130255003627 708 Oakland Meadow School   Regular School No Other PK 12 2017 fall grade_7 0 1 0 0   0       0 0   1 0                       1 0 1 0 0   0       0 0   1 0                 1
1984753 GA     school 1304890 736   Thomas County 130489004152 115 The Renaissance Center for Academic and Career Development   Regular School No Other 06 12 2017 fall grade_7 0 0 0 1   0       0 0   1 0                       1 0 0 0 1   0       0 0   1 0                 1
1987199 GA     school 1300026 891   Department of Juvenile Justice 130002603488 298 Augusta Youth Development Campus   Alternative School No High 07 12 2017 fall grade_7 0 1 0 0   0       0 0   1 0                       1 0 1 0 0   0       0 0   1 0                 1
1987202 GA     school 1300026 891   Department of Juvenile Justice 130002603504 2098 DeKalb Regional Youth Detention Center   Alternative School No Other 07 10 2017 fall grade_7 0 1 0 0   0       0 0   1 0                       1 0 1 0 0   0       0 0   1 0                 1
1987203 GA     school 1300026 891   Department of Juvenile Justice 130002603505 2198 Eastman Regional Youth Detention Center   Alternative School No Other 07 10 2017 fall grade_7 0 1 0 0   0       0 0   1 0                       1 0 1 0 0   0       0 0   1 0                 1
1987204 GA     school 1300026 891   Department of Juvenile Justice 130002603506 2298 Gainesville Regional Youth Detention Center   Alternative School No Other 07 11 2017 fall grade_7 0 1 0 0   0       0 0   1 0                       1 0 1 0 0   0       0 0   1 0                 1
1987205 GA     school 1300026 891   Department of Juvenile Justice 130002603509 2598 Macon Regional Youth Detention Center   Alternative School No Other 07 09 2017 fall grade_7 0 1 0 0   0       0 0   1 0                       1 0 1 0 0   0       0 0   1 0                 1
1987207 GA     school 1300026 891   Department of Juvenile Justice 130002603510 2698 Marietta Regional Youth Detention Center   Alternative School No Other 07 11 2017 fall grade_7 0 1 0 0   0       0 0   1 0                       1 0 1 0 0   0       0 0   1 0                 1
1987208 GA     school 1300026 891   Department of Juvenile Justice 130002603500 1698 Martha K. Glaze Regional Youth Detention Center   Alternative School No Other 07 11 2017 fall grade_7 0 1 0 0   0       0 0   1 0                       1 0 1 0 0   0       0 0   1 0                 1
1987211 GA     school 1300026 891   Department of Juvenile Justice 130002603513 2998 Savannah Regional Youth Detention Center   Alternative School No Other 07 10 2017 fall grade_7 0 1 0 0   0       0 0   1 0                       1 0 1 0 0   0       0 0   1 0                 1
299366 GA     school 1301290 633   Cobb County 130129003679 807 Devereux Ackerman Academy   Special Education School No Other 05 12 2017 spring grade_7 5 5 0 0   0       0 0   3 7                       10 5 5 0 0   0       0 0   3 7                 10
308240 GA     school 1304680 731   Taliaferro County 130468002514 102 Taliaferro County School   Regular School No Other PK 12 2017 spring grade_7 0 8 1 0   1       0 0   4 6                       10 0 8 1 0   1       0 0   4 6                 10
1984631 GA     school 1304680 731   Taliaferro County 130468002514 102 Taliaferro County School   Regular School No Other PK 12 2017 fall grade_7 0 10 0 0   0       0 0   5 5                       10 0 10 0 0   0       0 0   5 5                 10
310682 GA     school 1305130 791   Trion City 130513002466 201 Trion Middle School   Regular School No Middle 06 08 2017 spring grade_7 81 0 13 0   2       0 4   52 48                       100 81 0 13 0   2       0 4   52 48                 100
1974299 GA     school 1301020 625   Savannah-Chatham County 130102002152 192 Esther F. Garrison School for the Arts   Regular School No Elementary PK 08 2017 fall grade_7 51 31 2 1   5       0 11   23 78                       101 51 31 2 1   5       0 11   23 78                 101
307988 GA     school 1304470 723   Schley County 130447002428 101 Schley Middle High School   Regular School No Other 06 12 2017 spring grade_7 84 11 5 0   1       0 1   43 59                       102 84 11 5 0   1       0 1   43 59                 102
1987076 GA     school 1305130 791   Trion City 130513002466 201 Trion Middle School   Regular School No Middle 06 08 2017 fall grade_7 82 0 13 0   2       0 5   52 50                       102 82 0 13 0   2       0 5   52 50                 102
297479 GA     school 1300840 622   Carroll County 130084002356 101 Bowdon Middle School   Regular School No Middle 06 08 2017 spring grade_7 77 14 4 0   0       0 8   56 47                       103 77 14 4 0   0       0 8   56 47                 103
1973881 GA     school 1300840 622   Carroll County 130084002356 101 Bowdon Middle School   Regular School No Middle 06 08 2017 fall grade_7 78 15 4 0   0       0 6   57 46                       103 78 15 4 0   0       0 6   57 46                 103
308299 GA     school 1304800 733   Taylor County 130480002439 205 Taylor County Middle School   Regular School No Middle 07 08 2017 spring grade_7 62 40 1 0   1       0 0   52 52                       104 62 40 1 0   1       0 0   52 52                 104
1985153 GA     school 1305370 746   Walker County 130537004121 114 Saddle Ridge Elementary and Middle School   Regular School No Elementary PK 08 2017 fall grade_7 96 2 3 0   0       0 3   57 47                       104 96 2 3 0   0       0 3   57 47                 104
1974305 GA     school 1301020 625   Savannah-Chatham County 130102000387 5062 Mercer Middle School   Regular School No Middle 06 08 2017 fall grade_7 6 72 24 0   0       0 3   58 47                       105 6 72 24 0   0       0 3   58 47                 105
1984379 GA     school 1304470 723   Schley County 130447002428 101 Schley Middle High School   Regular School No Other 06 12 2017 fall grade_7 87 12 5 0   0       0 1   44 61                       105 87 12 5 0   0       0 1   44 61                 105
1984691 GA     school 1304800 733   Taylor County 130480002439 205 Taylor County Middle School   Regular School No Middle 07 08 2017 fall grade_7 62 41 1 0   1       0 0   51 54                       105 62 41 1 0   1       0 0   51 54                 105
306239 GA     school 1303690 701   Mitchell County 130369001744 197 Mitchell County Middle School   Regular School No Middle 05 07 2017 spring grade_7 8 81 11 0   0       0 6   61 45                       106 8 81 11 0   0       0 6   61 45                 106
308761 GA     school 1305370 746   Walker County 130537004121 114 Saddle Ridge Elementary and Middle School   Regular School No Elementary PK 08 2017 spring grade_7 99 2 2 0   0       0 3   58 48                       106 99 2 2 0   0       0 3   58 48                 106
306816 GA     school 1303930 707   Newton County 130393003920 123 Newton County Theme School at Ficquett   Regular School No Elementary KG 08 2017 spring grade_7 58 45 2 0   0       0 3   49 59                       108 58 45 2 0   0       0 3   49 59                 108
1982633 GA     school 1303690 701   Mitchell County 130369001744 197 Mitchell County Middle School   Regular School No Middle 05 07 2017 fall grade_7 7 84 11 0   0       0 6   64 44                       108 7 84 11 0   0       0 6   64 44                 108
306040 GA     school 1303450 694   Macon County 130345001329 199 Macon County Middle School   Regular School No Middle 06 08 2017 spring grade_7 11 85 10 0   1       0 2   65 44                       109 11 85 10 0   1       0 2   65 44                 109
308021 GA     school 1304530 725   Seminole County 130453001391 196 Seminole County Middle/High School   Regular School No Other 06 12 2017 spring grade_7 63 40 2 0   1       0 3   55 54                       109 63 40 2 0   1       0 3   55 54                 109
1986435 GA     school 1301140 769   Chickamauga City 130114002456 111 Gordon Lee Middle School   Regular School No Middle 06 08 2017 fall grade_7 104 0 3 0   0       0 2   60 49                       109 104 0 3 0   0       0 2   60 49                 109
304672 GA     school 1302610 669   Hall County 130261003403 105 Lanier College and Career Academy   Regular School No High 07 12 2017 spring grade_7 5 0 6 0   0       0 0   9 2                       11 5 0 6 0   0       0 0   9 2                 11
1980463 GA     school 1302550 667   Gwinnett County 130255000308 388 Gwinnett InterVention Education (GIVE) Center East   Alternative School No Other 06 12 2017 fall grade_7 1 8 2 0   0       0 0   9 2                       11 1 8 2 0   0       0 0   9 2                 11
1986088 GA     school 1300120 761   Atlanta Public Schools 130012002798 403 APS-Forrest Hills Academy   Alternative School No Other 06 12 2017 fall grade_7 0 10 1 0   0       0 0   7 4                       11 0 10 1 0   0       0 0   7 4                 11
310040 GA     school 1301140 769   Chickamauga City 130114002456 111 Gordon Lee Middle School   Regular School No Middle 06 08 2017 spring grade_7 105 0 3 0   0       0 2   60 50                       110 105 0 3 0   0       0 2   60 50                 110
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
1982435 GA     school 1303450 694   Macon County 130345001329 199 Macon County Middle School   Regular School No Middle 06 08 2017 fall grade_7 10 86 11 0   1       0 2   65 45                       110 10 86 11 0   1       0 2   65 45                 110
1983208 GA     school 1303930 707   Newton County 130393003920 123 Newton County Theme School at Ficquett   Regular School No Elementary KG 08 2017 fall grade_7 59 46 2 0   0       0 3   51 59                       110 59 46 2 0   0       0 3   51 59                 110
301468 GA     school 1301830 647   Dougherty County 130183000835 5060 Southside Middle School   Regular School No Middle 06 08 2017 spring grade_7 5 105 0 0   1       0 0   71 40                       111 5 105 0 0   1       0 0   71 40                 111
302926 GA     school 1302280 660   Fulton County 130228004187 1313 RISE Prep School   Regular School Yes Middle 06 07 2017 spring grade_7 3 103 5 0   0       0 0   42 69                       111 3 103 5 0   0       0 0   42 69                 111
308268 GA     school 1304770 732   Tattnall County 130477002433 101 North Tattnall Middle School   Regular School No Middle 06 08 2017 spring grade_7 57 31 20 0   0       0 3   45 66                       111 57 31 20 0   0       0 3   45 66                 111
1984412 GA     school 1304530 725   Seminole County 130453001391 196 Seminole County Middle/High School   Regular School No Other 06 12 2017 fall grade_7 64 42 2 0   1       0 2   58 53                       111 64 42 2 0   1       0 2   58 53                 111
305608 GA     school 1303060 681   Jefferson County 130306001302 296 Louisville Middle School   Regular School No Middle 06 08 2017 spring grade_7 12 93 4 0   1       0 2   60 52                       112 12 93 4 0   1       0 2   60 52                 112
1973884 GA     school 1300840 622   Carroll County 130084003562 208 Mt. Zion Middle School   Regular School No Middle 06 08 2017 fall grade_7 86 8 10 1   1       0 6   53 59                       112 86 8 10 1   1       0 6   53 59                 112
296368 GA     school 1300090 602   Atkinson County 130009003996 111 Atkinson County Middle School   Regular School No Middle 06 08 2017 spring grade_7 51 19 42 0   0       0 2   60 54                       114 51 19 42 0   0       0 2   60 54                 114
297482 GA     school 1300840 622   Carroll County 130084003562 208 Mt. Zion Middle School   Regular School No Middle 06 08 2017 spring grade_7 88 8 10 1   1       0 6   51 63                       114 88 8 10 1   1       0 6   51 63                 114
1979325 GA     school 1302280 660   Fulton County 130228004187 1313 RISE Prep School   Regular School Yes Middle 06 07 2017 fall grade_7 3 106 5 0   0       0 0   42 72                       114 3 106 5 0   0       0 0   42 72                 114
1982003 GA     school 1303060 681   Jefferson County 130306001302 296 Louisville Middle School   Regular School No Middle 06 08 2017 fall grade_7 13 94 4 0   1       0 2   61 53                       114 13 94 4 0   1       0 2   61 53                 114
1984659 GA     school 1304770 732   Tattnall County 130477002433 101 North Tattnall Middle School   Regular School No Middle 06 08 2017 fall grade_7 62 30 20 0   0       0 2   45 69                       114 62 30 20 0   0       0 2   45 69                 114
297897 GA     school 1301020 625   Savannah-Chatham County 130102000400 4058 Hesse School   Regular School No Elementary PK 08 2017 spring grade_7 57 33 16 1   1       0 7   51 64                       115 57 33 16 1   1       0 7   51 64                 115
1974302 GA     school 1301020 625   Savannah-Chatham County 130102000400 4058 Hesse School   Regular School No Elementary PK 08 2017 fall grade_7 60 33 13 1   1       0 7   51 64                       115 60 33 13 1   1       0 7   51 64                 115
1977363 GA     school 1301740 644   DeKalb County 130174003559 1100 International Student Center   Regular School No Middle 07 08 2017 fall grade_7 0 37 54 0   24       0 0   67 48                       115 0 37 54 0   24       0 0   67 48                 115
1984660 GA     school 1304770 732   Tattnall County 130477002434 201 South Tattnall Middle School   Regular School No Middle 06 08 2017 fall grade_7 73 25 15 0   2       0 1   61 55                       116 73 25 15 0   2       0 1   61 55                 116
297900 GA     school 1301020 625   Savannah-Chatham County 130102000387 5062 Mercer Middle School   Regular School No Middle 06 08 2017 spring grade_7 6 79 28 0   0       0 4   69 48                       117 6 79 28 0   0       0 4   69 48                 117
1977869 GA     school 1301830 647   Dougherty County 130183000835 5060 Southside Middle School   Regular School No Middle 06 08 2017 fall grade_7 7 109 0 0   1       0 0   77 40                       117 7 109 0 0   1       0 0   77 40                 117
1986452 GA     school 1301440 771   Commerce City 130144000623 105 Commerce Middle School   Regular School No Middle 05 08 2017 fall grade_7 87 14 10 0   0       0 6   63 54                       117 87 14 10 0   0       0 6   63 54                 117
297903 GA     school 1301020 625   Savannah-Chatham County 130102004185 512 Rice Creek School   Regular School No Elementary 03 08 2017 spring grade_7 28 66 17 1   1       0 5   61 57                       118 28 66 17 1   1       0 5   61 57                 118
307182 GA     school 1304050 711   Peach County 130405001807 197 Byron Middle School   Regular School No Middle 06 08 2017 spring grade_7 65 35 15 0   1       0 2   53 65                       118 65 35 15 0   1       0 2   53 65                 118
308269 GA     school 1304770 732   Tattnall County 130477002434 201 South Tattnall Middle School   Regular School No Middle 06 08 2017 spring grade_7 73 26 16 0   2       0 1   61 57                       118 73 26 16 0   2       0 1   61 57                 118
309284 GA     school 1305760 757   Wilkes County 130576003942 210 Washington-Wilkes Middle School   Regular School No Middle 06 08 2017 spring grade_7 40 60 8 0   3       0 7   69 49                       118 40 60 8 0   3       0 7   69 49                 118
307690 GA     school 1304380 721   Richmond County 130438001567 4562 Davidson Magnet School   Regular School No Other 06 12 2017 spring grade_7 48 57 7 0   3       1 3   26 93                       119 48 57 7 0   3       1 3   26 93                 119
1974308 GA     school 1301020 625   Savannah-Chatham County 130102004185 512 Rice Creek School   Regular School No Elementary 03 08 2017 fall grade_7 29 64 17 1   1       0 7   66 53                       119 29 64 17 1   1       0 7   66 53                 119
1982577 GA     school 1303630 699   Meriwether County 130363001361 5050 Manchester Middle School   Regular School No Middle 06 08 2017 fall grade_7 47 66 2 0   2       0 2   62 57                       119 47 66 2 0   2       0 2   62 57                 119
1983574 GA     school 1304050 711   Peach County 130405001807 197 Byron Middle School   Regular School No Middle 06 08 2017 fall grade_7 67 35 14 0   1       0 2   53 66                       119 67 35 14 0   1       0 2   53 66                 119
296869 GA     school 1300420 611   Bibb County 130042004176 117 Academy For Classical Education   Regular School Yes Other KG 10 2017 spring grade_7 87 16 3 0   11       0 3   70 50                       120 87 16 3 0   11       0 3   70 50                 120
297652 GA     school 1300990 624   Charlton County 130099004016 112 Bethune Middle School   Regular School No Elementary 04 08 2017 spring grade_7 70 40 5 1   0       0 4   63 57                       120 70 40 5 1   0       0 4   63 57                 120
1974055 GA     school 1300990 624   Charlton County 130099004016 112 Bethune Middle School   Regular School No Elementary 04 08 2017 fall grade_7 71 39 6 0   0       0 4   61 59                       120 71 39 6 0   0       0 4   61 59                 120
1984081 GA     school 1304380 721   Richmond County 130438001567 4562 Davidson Magnet School   Regular School No Other 06 12 2017 fall grade_7 49 57 6 0   4       1 3   26 94                       120 49 57 6 0   4       1 3   26 94                 120
298113 GA     school 1301080 627   Chattooga County 130108000422 2052 Summerville Middle School   Regular School No Middle 06 08 2017 spring grade_7 94 9 10 1   0       0 7   64 57                       121 94 9 10 1   0       0 7   64 57                 121
306183 GA     school 1303630 699   Meriwether County 130363001361 5050 Manchester Middle School   Regular School No Middle 06 08 2017 spring grade_7 49 66 2 0   2       0 2   63 58                       121 49 66 2 0   2       0 2   63 58                 121
1973269 GA     school 1300420 611   Bibb County 130042004176 117 Academy For Classical Education   Regular School Yes Other KG 10 2017 fall grade_7 87 17 3 0   11       0 3   71 50                       121 87 17 3 0   11       0 3   71 50                 121
1985676 GA     school 1305760 757   Wilkes County 130576003942 210 Washington-Wilkes Middle School   Regular School No Middle 06 08 2017 fall grade_7 42 60 9 0   3       0 7   70 51                       121 42 60 9 0   3       0 7   70 51                 121
1978583 GA     school 1302190 657   Floyd County 130219002374 303 Armuchee Middle School   Regular School No Middle 06 08 2017 fall grade_7 111 6 3 0   0       0 4   53 71                       124 111 6 3 0   0       0 4   53 71                 124
1974519 GA     school 1301080 627   Chattooga County 130108000422 2052 Summerville Middle School   Regular School No Middle 06 08 2017 fall grade_7 98 10 10 1   0       0 7   65 61                       126 98 10 10 1   0       0 7   65 61                 126
302183 GA     school 1302190 657   Floyd County 130219002374 303 Armuchee Middle School   Regular School No Middle 06 08 2017 spring grade_7 114 6 3 0   0       0 4   56 71                       127 114 6 3 0   0       0 4   56 71                 127
307694 GA     school 1304380 721   Richmond County 130438001534 3556 Johnson Magnet   Regular School No Other 06 12 2017 spring grade_7 27 90 4 1   2       0 3   61 66                       127 27 90 4 1   2       0 3   61 66                 127
309700 GA     school 1300120 761   Atlanta Public Schools 130012004161 515 Charles Drew Charter School JA/SA   Regular School Yes Other 06 12 2017 spring grade_7 9 112 2 0   1       0 3   61 66                       127 9 112 2 0   1       0 3   61 66                 127
305470 GA     school 1302910 677   Irwin County 130291001243 173 Irwin County Middle School   Regular School No Middle 06 08 2017 spring grade_7 79 42 5 0   1       0 1   62 66                       128 79 42 5 0   1       0 1   62 66                 128
1985595 GA     school 1305700 755   Whitfield County 130570001821 675 Valley Point Middle School   Regular School No Middle 06 08 2017 fall grade_7 60 1 59 1   3       0 4   75 53                       128 60 1 59 1   3       0 4   75 53                 128
308004 GA     school 1304500 724   Screven County 130450002231 197 Screven County Middle School   Regular School No Middle 06 08 2017 spring grade_7 61 62 2 0   0       0 4   67 62                       129 61 62 2 0   0       0 4   67 62                 129
310057 GA     school 1301440 771   Commerce City 130144000623 105 Commerce Middle School   Regular School No Middle 05 08 2017 spring grade_7 96 16 11 0   0       0 6   71 58                       129 96 16 11 0   0       0 6   71 58                 129
1981865 GA     school 1302910 677   Irwin County 130291001243 173 Irwin County Middle School   Regular School No Middle 06 08 2017 fall grade_7 80 41 5 0   1       0 2   63 66                       129 80 41 5 0   1       0 2   63 66                 129
1984395 GA     school 1304500 724   Screven County 130450002231 197 Screven County Middle School   Regular School No Middle 06 08 2017 fall grade_7 62 61 2 0   0       0 4   65 64                       129 62 61 2 0   0       0 4   65 64                 129
1986098 GA     school 1300120 761   Atlanta Public Schools 130012003660 207 Hillside Conant School   Regular School No Other 02 12 2017 fall grade_7 7 5 0 0   0       0 1   8 5                       13 7 5 0 0   0       0 1   8 5                 13
1984085 GA     school 1304380 721   Richmond County 130438001534 3556 Johnson Magnet   Regular School No Other 06 12 2017 fall grade_7 27 92 4 1   3       0 3   63 67                       130 27 92 4 1   3       0 3   63 67                 130
1986094 GA     school 1300120 761   Atlanta Public Schools 130012004161 515 Charles Drew Charter School JA/SA   Regular School Yes Other 06 12 2017 fall grade_7 9 116 2 0   1       0 3   62 69                       131 9 116 2 0   1       0 3   62 69                 131
307697 GA     school 1304380 721   Richmond County 130438001932 184 Morgan Road Middle School   Regular School No Middle 06 08 2017 spring grade_7 7 115 4 0   2       1 3   60 72                       132 7 115 4 0   2       1 3   60 72                 132
309203 GA     school 1305700 755   Whitfield County 130570001821 675 Valley Point Middle School   Regular School No Middle 06 08 2017 spring grade_7 60 1 62 1   3       1 4   76 56                       132 60 1 62 1   3       1 4   76 56                 132
1982997 GA     school 1303870 706   Muscogee County 130387001432 5058 Eddy Middle School   Regular School No Middle 06 08 2017 fall grade_7 7 104 17 0   1       0 3   72 60                       132 7 104 17 0   1       0 3   72 60                 132
300266 GA     school 1301530 639   Crawford County 130153002151 202 Crawford County Middle School   Regular School No Middle 06 08 2017 spring grade_7 99 26 4 1   0       0 3   78 55                       133 99 26 4 1   0       0 3   78 55                 133
1984088 GA     school 1304380 721   Richmond County 130438001932 184 Morgan Road Middle School   Regular School No Middle 06 08 2017 fall grade_7 6 119 2 0   2       2 2   59 74                       133 6 119 2 0   2       2 2   59 74                 133

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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]);