Data source: Big Local News · About: Big Local

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

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
298110 GA     school 1301080 627   Chattooga County 130108003571 111 Chattooga Academy   Alternative School No Other 01 12 2017 spring grade_7 2 0 0 0   0       0 0   1 1                       2 2 0 0 0   0       0 0   1 1                 2
1974516 GA     school 1301080 627   Chattooga County 130108003571 111 Chattooga Academy   Alternative School No Other 01 12 2017 fall grade_7 1 0 1 0   0       0 0   2 0                       2 1 0 1 0   0       0 0   2 0                 2
300978 GA     school 1301740 644   DeKalb County 130174003613 707 UHS of Laurel Heights   Special Education School No Other 02 12 2017 spring grade_7 1 1 0 0   0       0 0   2 0                       2 1 1 0 0   0       0 0   2 0                 2
309704 GA     school 1300120 761   Atlanta Public Schools 130012003660 207 Hillside Conant School   Regular School No Other 02 12 2017 spring grade_7 3 2 1 0   1       0 0   5 2                       7 3 2 1 0   1       0 0   5 2                 7
1977380 GA     school 1301740 644   DeKalb County 130174003613 707 UHS of Laurel Heights   Special Education School No Other 02 12 2017 fall grade_7 0 2 1 0   0       0 0   1 2                       3 0 2 1 0   0       0 0   1 2                 3
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
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
297907 GA     school 1301020 625   Savannah-Chatham County 130102003610 107 UHS of Savannah Coastal Harbor Treatment Center   Regular School No Other 03 11 2017 spring grade_7 3 3 0 0   0       0 0   2 4                       6 3 3 0 0   0       0 0   2 4                 6
301670 GA     school 1301860 648   Douglas County 130186003689 507 Youth Villages at Inner Harbour   Special Education School No Other 03 12 2017 spring grade_7 6 9 0 0   0       0 0   12 3                       15 6 9 0 0   0       0 0   12 3                 15
310531 GA     school 1300241 7830614   State Charter Schools II- Liberty Tech Charter Academy 130024104229 614 Liberty Tech Charter Academy   Regular School Yes Elementary 03 08 2017 spring grade_7 35 11 0 0   1       0 2   15 34                       49 35 11 0 0   1       0 2   15 34                 49
1973273 GA     school 1300420 611   Bibb County 130042003676 407 LakeBridge Behavioral Health System   Special Education School No Other 03 12 2017 fall grade_7 4 0 0 0   0       0 0   2 2                       4 4 0 0 0   0       0 0   2 2                 4
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
1974312 GA     school 1301020 625   Savannah-Chatham County 130102003610 107 UHS of Savannah Coastal Harbor Treatment Center   Regular School No Other 03 11 2017 fall grade_7 0 2 0 0   0       0 0   1 1                       2 0 2 0 0   0       0 0   1 1                 2
1978072 GA     school 1301860 648   Douglas County 130186003689 507 Youth Villages at Inner Harbour   Special Education School No Other 03 12 2017 fall grade_7 1 4 0 0   0       0 0   4 1                       5 1 4 0 0   0       0 0   4 1                 5
1986925 GA     school 1300241 7830614   State Charter Schools II- Liberty Tech Charter Academy 130024104229 614 Liberty Tech Charter Academy   Regular School Yes Elementary 03 08 2017 fall grade_7 35 11 0 0   2       0 2   18 32                       50 35 11 0 0   2       0 2   18 32                 50
296874 GA     school 1300420 611   Bibb County 130042003621 307 Price Academy   Special Education School No Elementary 04 08 2017 spring grade_7 3 2 1 0   0       0 0   1 5                       6 3 2 1 0   0       0 0   1 5                 6
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
304068 GA     school 1302550 667   Gwinnett County 130255004057 1214 Gwinnett Online Campus   Regular School No Other 04 12 2017 spring grade_7 27 5 8 0   1       0 0   19 22                       41 27 5 8 0   1       0 0   19 22                 41
307696 GA     school 1304380 721   Richmond County 130438003486 107 Lighthouse Care Center of Augusta   Special Education School No Other 04 11 2017 spring grade_7 2 0 0 0   0       0 0   0 2                       2 2 0 0 0   0       0 0   0 2                 2
1973275 GA     school 1300420 611   Bibb County 130042003621 307 Price Academy   Special Education School No Elementary 04 08 2017 fall grade_7 2 2 0 0   0       0 0   1 3                       4 2 2 0 0   0       0 0   1 3                 4
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
1980465 GA     school 1302550 667   Gwinnett County 130255004057 1214 Gwinnett Online Campus   Regular School No Other 04 12 2017 fall grade_7 24 5 9 0   4       0 1   20 23                       43 24 5 9 0   4       0 1   20 23                 43
1984087 GA     school 1304380 721   Richmond County 130438003486 107 Lighthouse Care Center of Augusta   Special Education School No Other 04 11 2017 fall grade_7 0 1 1 0   0       0 0   0 2                       2 0 1 1 0   0       0 0   0 2                 2
298943 GA     school 1301260 632   Clinch County 130126002106 201 Clinch County Middle School   Regular School No Middle 05 07 2017 spring grade_7 52 33 9 0   0       0 3   55 42                       97 52 33 9 0   0       0 3   55 42                 97
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
300955 GA     school 1301740 644   DeKalb County 130174003339 705 DeKalb PATH Academy Charter School   Regular School Yes Middle 05 08 2017 spring grade_7 0 13 79 0   1       0 0   48 45                       93 0 13 79 0   1       0 0   48 45                 93
301881 GA     school 1302010 652   Elbert County 130201002871 104 Elbert County Middle School   Regular School No Middle 05 08 2017 spring grade_7 119 63 21 0   4       0 6   112 101                       213 119 63 21 0   4       0 6   112 101                 213
302916 GA     school 1302280 660   Fulton County 130228003651 307 Georgia Baptist Children's Home and Family Ministries   Special Education School No Other 05 11 2017 spring grade_7 1 2 0 0   0       0 0   3 0                       3 1 2 0 0   0       0 0   3 0                 3
302921 GA     school 1302280 660   Fulton County 130228002885 204 KIPP South Fulton Academy School   Regular School Yes Middle 05 08 2017 spring grade_7 1 69 8 0   1       0 2   39 42                       81 1 69 8 0   1       0 2   39 42                 81
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
308363 GA     school 1304890 736   Thomas County 130489002147 205 Thomas County Middle School   Regular School No Middle 05 08 2017 spring grade_7 233 135 38 2   4       0 10   231 191                       422 233 135 38 2   4       0 10   231 191                 422
309705 GA     school 1300120 761   Atlanta Public Schools 130012003992 122 KIPP VISION   Regular School Yes Middle 05 08 2017 spring grade_7 0 77 4 1   0       0 0   39 43                       82 0 77 4 1   0       0 0   39 43                 82
309706 GA     school 1300120 761   Atlanta Public Schools 130012003031 605 KIPP West Atlanta Young Scholars Academy   Regular School Yes Middle 05 08 2017 spring grade_7 0 83 3 0   0       0 1   41 46                       87 0 83 3 0   0       0 1   41 46                 87
309709 GA     school 1300120 761   Atlanta Public Schools 130012003823 115 Kipp Strive Academy   Regular School Yes Middle 05 08 2017 spring grade_7 0 89 0 0   0       0 0   51 38                       89 0 89 0 0   0       0 0   51 38                 89
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
310187 GA     school 1301870 774   Dublin City 130187000869 102 Dublin Middle School   Regular School No Middle 05 08 2017 spring grade_7 6 135 2 0   2       0 6   76 75                       151 6 135 2 0   2       0 6   76 75                 151
310799 GA     school 1300026 891   Department of Juvenile Justice 130002603806 1898 Aaron Cohn Regional Youth Detention Center   Alternative School No Other 05 10 2017 spring grade_7 0 2 0 0   0       0 0   0 2                       2 0 2 0 0   0       0 0   0 2                 2
310805 GA     school 1300026 891   Department of Juvenile Justice 130002603487 205 Crisp RYDC   Alternative School No Other 05 10 2017 spring grade_7 0 3 0 0   0       0 0   3 0                       3 0 3 0 0   0       0 0   3 0                 3
1975349 GA     school 1301260 632   Clinch County 130126002106 201 Clinch County Middle School   Regular School No Middle 05 07 2017 fall grade_7 48 34 9 0   0       0 3   51 43                       94 48 34 9 0   0       0 3   51 43                 94
1975771 GA     school 1301290 633   Cobb County 130129003679 807 Devereux Ackerman Academy   Special Education School No Other 05 12 2017 fall grade_7 1 4 0 0   0       0 0   3 2                       5 1 4 0 0   0       0 0   3 2                 5
1977357 GA     school 1301740 644   DeKalb County 130174003339 705 DeKalb PATH Academy Charter School   Regular School Yes Middle 05 08 2017 fall grade_7 0 13 79 0   2       0 0   48 46                       94 0 13 79 0   2       0 0   48 46                 94
1978281 GA     school 1302010 652   Elbert County 130201002871 104 Elbert County Middle School   Regular School No Middle 05 08 2017 fall grade_7 117 65 20 0   3       0 6   112 99                       211 117 65 20 0   3       0 6   112 99                 211
1979315 GA     school 1302280 660   Fulton County 130228003651 307 Georgia Baptist Children's Home and Family Ministries   Special Education School No Other 05 11 2017 fall grade_7 1 2 0 0   0       0 0   3 0                       3 1 2 0 0   0       0 0   3 0                 3
1979320 GA     school 1302280 660   Fulton County 130228002885 204 KIPP South Fulton Academy School   Regular School Yes Middle 05 08 2017 fall grade_7 1 70 8 0   1       0 2   39 43                       82 1 70 8 0   1       0 2   39 43                 82
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
1984754 GA     school 1304890 736   Thomas County 130489002147 205 Thomas County Middle School   Regular School No Middle 05 08 2017 fall grade_7 237 136 38 1   3       0 13   233 195                       428 237 136 38 1   3       0 13   233 195                 428
1986099 GA     school 1300120 761   Atlanta Public Schools 130012003992 122 KIPP VISION   Regular School Yes Middle 05 08 2017 fall grade_7 0 75 4 1   0       0 0   35 45                       80 0 75 4 1   0       0 0   35 45                 80
1986100 GA     school 1300120 761   Atlanta Public Schools 130012003031 605 KIPP West Atlanta Young Scholars Academy   Regular School Yes Middle 05 08 2017 fall grade_7 0 82 2 0   0       0 1   41 44                       85 0 82 2 0   0       0 1   41 44                 85
1986103 GA     school 1300120 761   Atlanta Public Schools 130012003823 115 Kipp Strive Academy   Regular School Yes Middle 05 08 2017 fall grade_7 0 89 0 0   0       0 0   50 39                       89 0 89 0 0   0       0 0   50 39                 89
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
1986581 GA     school 1301870 774   Dublin City 130187000869 102 Dublin Middle School   Regular School No Middle 05 08 2017 fall grade_7 6 134 2 0   1       0 7   74 76                       150 6 134 2 0   1       0 7   74 76                 150
1987201 GA     school 1300026 891   Department of Juvenile Justice 130002603487 205 Crisp RYDC   Alternative School No Other 05 10 2017 fall grade_7 0 3 0 0   0       0 0   3 0                       3 0 3 0 0   0       0 0   3 0                 3
296339 GA     school 1300060 601   Appling County 130006000009 195 Appling County Middle School   Regular School No Middle 06 08 2017 spring grade_7 165 46 33 1   1       0 7   131 122                       253 165 46 33 1   1       0 7   131 122                 253
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
296388 GA     school 1300150 603   Bacon County 130015002349 202 Bacon County Middle School   Regular School No Middle 06 08 2017 spring grade_7 104 34 20 0   0       0 3   66 95                       161 104 34 20 0   0       0 3   66 95                 161
296436 GA     school 1300210 605   Baldwin County 130021002347 100 Oak Hill MS   Regular School No Middle 06 08 2017 spring grade_7 86 265 7 0   4       0 12   195 179                       374 86 265 7 0   4       0 12   195 179                 374
296459 GA     school 1300240 606   Banks County 130024002015 105 Banks County Middle School   Regular School No Middle 06 08 2017 spring grade_7 172 4 20 0   0       0 5   101 100                       201 172 4 20 0   0       0 5   101 100                 201
296518 GA     school 1300290 607   Barrow County 130029000175 114 Bear Creek Middle School   Regular School No Middle 06 08 2017 spring grade_7 175 47 49 0   10       0 13   152 142                       294 175 47 49 0   10       0 13   152 142                 294
296519 GA     school 1300290 607   Barrow County 130029003285 106 Haymon-Morris Middle School   Regular School No Middle 06 08 2017 spring grade_7 172 35 39 1   7       0 8   132 130                       262 172 35 39 1   7       0 8   132 130                 262
296520 GA     school 1300290 607   Barrow County 130029002017 289 Russell Middle School   Regular School No Middle 06 08 2017 spring grade_7 162 24 38 0   17       0 7   130 118                       248 162 24 38 0   17       0 7   130 118                 248
296521 GA     school 1300290 607   Barrow County 130029001913 198 Westside Middle School   Regular School No Middle 06 08 2017 spring grade_7 142 25 44 2   12       0 16   125 116                       241 142 25 44 2   12       0 16   125 116                 241
296631 GA     school 1300330 608   Bartow County 130033002351 301 Adairsville Middle School   Regular School No Middle 06 08 2017 spring grade_7 216 20 18 0   0       0 11   124 141                       265 216 20 18 0   0       0 11   124 141                 265
296632 GA     school 1300330 608   Bartow County 130033001868 195 Cass Middle School   Regular School No Middle 06 08 2017 spring grade_7 205 49 50 0   4       0 13   165 156                       321 205 49 50 0   4       0 13   165 156                 321
296633 GA     school 1300330 608   Bartow County 130033002060 190 Red Top Middle School   Regular School No Middle 06 08 2017 spring grade_7 143 20 41 0   3       0 13   108 112                       220 143 20 41 0   3       0 13   108 112                 220
296634 GA     school 1300330 608   Bartow County 130033002294 101 Woodland Middle School at Euharlee   Regular School No Middle 06 08 2017 spring grade_7 221 15 20 1   0       0 7   138 126                       264 221 15 20 1   0       0 7   138 126                 264
296694 GA     school 1300360 609   Ben Hill County 130036002149 296 Ben Hill County Middle School   Regular School No Middle 06 08 2017 spring grade_7 98 81 33 1   1       0 8   105 117                       222 98 81 33 1   1       0 8   105 117                 222
296715 GA     school 1300390 610   Berrien County 130039000228 194 Berrien Middle School   Regular School No Middle 06 08 2017 spring grade_7 190 27 17 1   0       0 6   127 114                       241 190 27 17 1   0       0 6   127 114                 241
296870 GA     school 1300420 611   Bibb County 130042000212 5050 Appling Middle School   Regular School No Middle 06 08 2017 spring grade_7 6 198 2 0   0       0 1   120 87                       207 6 198 2 0   0       0 1   120 87                 207
296871 GA     school 1300420 611   Bibb County 130042003667 108 Ballard Hudson Middle School   Regular School No Middle 06 08 2017 spring grade_7 6 249 9 0   0       1 2   141 126                       267 6 249 9 0   0       1 2   141 126                 267
296872 GA     school 1300420 611   Bibb County 130042003290 205 Howard Middle School   Regular School No Middle 06 08 2017 spring grade_7 72 206 14 0   17       0 9   166 152                       318 72 206 14 0   17       0 9   166 152                 318
296873 GA     school 1300420 611   Bibb County 130042002234 298 Miller Magnet Middle School   Regular School No Middle 06 08 2017 spring grade_7 6 245 7 0   0       0 11   138 131                       269 6 245 7 0   0       0 11   138 131                 269
296875 GA     school 1300420 611   Bibb County 130042002620 305 Rutland Middle School   Regular School No Middle 06 08 2017 spring grade_7 96 159 35 0   8       1 7   154 152                       306 96 159 35 0   8       1 7   154 152                 306
296876 GA     school 1300420 611   Bibb County 130042001416 505 Weaver Middle School   Regular School No Middle 06 08 2017 spring grade_7 25 229 9 0   6       0 3   145 127                       272 25 229 9 0   6       0 3   145 127                 272
296986 GA     school 1300440 612   Bleckley County 130044004162 115 Bleckley County Success Academy   Regular School No Other 06 12 2017 spring grade_7 3 2 0 0   0       0 0   2 3                       5 3 2 0 0   0       0 0   2 3                 5
296987 GA     school 1300440 612   Bleckley County 130044000254 112 Bleckley Middle School   Regular School No Middle 06 08 2017 spring grade_7 117 44 8 0   0       0 6   72 103                       175 117 44 8 0   0       0 6   72 103                 175
297051 GA     school 1300540 614   Brooks County 130054000263 110 Brooks County High School   Regular School No Other 06 12 2017 spring grade_7 2 0 0 0   0       0 0   2 0                       2 2 0 0 0   0       0 0   2 0                 2
297052 GA     school 1300540 614   Brooks County 130054001417 197 Brooks County Middle School   Regular School No Middle 06 08 2017 spring grade_7 41 89 15 0   2       0 4   77 74                       151 41 89 15 0   2       0 4   77 74                 151
297087 GA     school 1300570 615   Bryan County 130057002395 402 Bryan County Middle School   Regular School No Middle 06 08 2017 spring grade_7 105 32 6 0   1       0 12   87 69                       156 105 32 6 0   1       0 12   87 69                 156
297088 GA     school 1300570 615   Bryan County 130057002235 199 Richmond Hill Middle School   Regular School No Middle 06 08 2017 spring grade_7 375 65 39 1   20       1 29   287 243                       530 375 65 39 1   20       1 29   287 243                 530
297167 GA     school 1300630 616   Bulloch County 130063002238 299 Langston Chapel Middle School   Regular School No Middle 06 08 2017 spring grade_7 63 138 21 0   4       1 8   113 122                       235 63 138 21 0   4       1 8   113 122                 235
297168 GA     school 1300630 616   Bulloch County 130063000281 4052 Portal Middle/High School   Regular School No Other 06 12 2017 spring grade_7 34 7 2 0   0       1 2   22 24                       46 34 7 2 0   0       1 2   22 24                 46
297169 GA     school 1300630 616   Bulloch County 130063002297 300 Southeast Bulloch Middle School   Regular School No Middle 06 08 2017 spring grade_7 235 27 13 0   1       0 11   151 136                       287 235 27 13 0   1       0 11   151 136                 287
297170 GA     school 1300630 616   Bulloch County 130063002236 198 William James Middle School   Regular School No Middle 06 08 2017 spring grade_7 101 97 8 0   6       0 4   109 107                       216 101 97 8 0   6       0 4   109 107                 216
297228 GA     school 1300660 617   Burke County 130066001990 188 Burke County Middle School   Regular School No Middle 06 08 2017 spring grade_7 93 216 11 0   2       0 10   177 155                       332 93 216 11 0   2       0 10   177 155                 332
297259 GA     school 1300690 618   Butts County 130069002353 100 Henderson Middle School   Regular School No Middle 06 08 2017 spring grade_7 157 83 6 0   1       0 3   125 125                       250 157 83 6 0   1       0 3   125 125                 250
297282 GA     school 1300750 619   Calhoun County 130075004098 213 Calhoun County Middle School   Regular School No Middle 06 08 2017 spring grade_7 3 40 2 0   0       0 0   20 25                       45 3 40 2 0   0       0 0   20 25                 45
297340 GA     school 1300780 620   Camden County 130078001875 182 Camden Middle School   Regular School No Middle 06 08 2017 spring grade_7 205 72 20 3   7       2 35   186 158                       344 205 72 20 3   7       2 35   186 158                 344
297341 GA     school 1300780 620   Camden County 130078003299 105 Saint Marys Middle School   Regular School No Middle 06 08 2017 spring grade_7 189 68 32 3   5       0 18   154 161                       315 189 68 32 3   5       0 18   154 161                 315
297384 GA     school 1300810 621   Candler County 130081000318 102 Metter Middle School   Regular School No Middle 06 08 2017 spring grade_7 86 46 37 0   1       0 0   96 74                       170 86 46 37 0   1       0 0   96 74                 170
297478 GA     school 1300840 622   Carroll County 130084002239 198 Bay Springs Middle School   Regular School No Middle 06 08 2017 spring grade_7 151 53 25 1   1       0 21   141 111                       252 151 53 25 1   1       0 21   141 111                 252
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
297480 GA     school 1300840 622   Carroll County 130084000321 177 Central Middle School   Regular School No Middle 06 08 2017 spring grade_7 203 35 26 1   0       0 9   134 140                       274 203 35 26 1   0       0 9   134 140                 274
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
297483 GA     school 1300840 622   Carroll County 130084002452 102 Temple Middle School   Regular School No Middle 06 08 2017 spring grade_7 97 23 10 0   3       1 4   71 67                       138 97 23 10 0   3       1 4   71 67                 138
297484 GA     school 1300840 622   Carroll County 130084003301 305 Villa Rica Middle   Regular School No Middle 06 08 2017 spring grade_7 95 47 15 0   0       0 12   87 82                       169 95 47 15 0   0       0 12   87 82                 169
297598 GA     school 1300930 623   Catoosa County 130093003305 205 Heritage Middle School   Regular School No Middle 06 08 2017 spring grade_7 289 6 5 1   4       0 9   171 143                       314 289 6 5 1   4       0 9   171 143                 314
297599 GA     school 1300930 623   Catoosa County 130093000348 2552 Lakeview Middle School   Regular School No Middle 06 08 2017 spring grade_7 202 15 15 0   7       1 10   135 115                       250 202 15 15 0   7       1 10   135 115                 250
297600 GA     school 1300930 623   Catoosa County 130093000351 5052 Ringgold Middle School   Regular School No Middle 06 08 2017 spring grade_7 226 8 10 1   5       0 5   136 119                       255 226 8 10 1   5       0 5   136 119                 255
297890 GA     school 1301020 625   Savannah-Chatham County 130102002019 311 Coastal Middle School   Regular School No Middle 06 08 2017 spring grade_7 151 63 7 0   13       0 14   124 124                       248 151 63 7 0   13       0 14   124 124                 248
297891 GA     school 1301020 625   Savannah-Chatham County 130102000362 201 DeRenne Middle School   Regular School No Middle 06 08 2017 spring grade_7 5 190 2 0   0       0 5   98 104                       202 5 190 2 0   0       0 5   98 104                 202

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