Data source: Big Local News · About: Big Local

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

View and edit SQL

year

  • 2017 · 1,084

grade

  • grade_7 · 1,084
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
298776 GA     school 1301230 631   Clayton County 130123000478 277 Pointe South Middle School   Regular School No Middle 06 08 2017 spring grade_7 7 214 44 0   3       1 6   146 129                       275 7 214 44 0   3       1 6   146 129                 275
298777 GA     school 1301230 631   Clayton County 130123003319 207 Rex Mill Middle School   Regular School No Middle 06 08 2017 spring grade_7 11 257 85 0   9       1 20   181 202                       383 11 257 85 0   9       1 20   181 202                 383
298778 GA     school 1301230 631   Clayton County 130123000491 3060 Riverdale Middle School   Regular School No Middle 06 08 2017 spring grade_7 1 189 29 0   13       0 3   135 100                       235 1 189 29 0   13       0 3   135 100                 235
298779 GA     school 1301230 631   Clayton County 130123003317 107 Sequoyah Middle School   Regular School No Middle 06 08 2017 spring grade_7 3 187 99 0   13       0 9   148 163                       311 3 187 99 0   13       0 9   148 163                 311
298780 GA     school 1301230 631   Clayton County 130123003687 307 Unidos Dual Language School   Regular School No Elementary PK 08 2017 spring grade_7 1 13 30 0   0       0 1   19 26                       45 1 13 30 0   0       0 1   19 26                 45
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
299361 GA     school 1301290 633   Cobb County 130129000566 4050 Awtrey Middle School   Regular School No Middle 06 08 2017 spring grade_7 115 79 40 0   15       1 31   133 148                       281 115 79 40 0   15       1 31   133 148                 281
299362 GA     school 1301290 633   Cobb County 130129003531 407 Barber Middle School   Regular School No Middle 06 08 2017 spring grade_7 85 127 52 1   15       1 15   162 134                       296 85 127 52 1   15       1 15   162 134                 296
299363 GA     school 1301290 633   Cobb County 130129002070 290 Campbell Middle School   Regular School No Middle 06 08 2017 spring grade_7 51 211 197 2   10       0 11   247 235                       482 51 211 197 2   10       0 11   247 235                 482
299364 GA     school 1301290 633   Cobb County 130129002475 502 Cooper Middle School   Regular School No Middle 06 08 2017 spring grade_7 29 255 60 1   2       2 15   162 202                       364 29 255 60 1   2       2 15   162 202                 364
299365 GA     school 1301290 633   Cobb County 130129000564 4056 Daniell Middle School   Regular School No Middle 06 08 2017 spring grade_7 118 99 65 1   34       0 13   163 167                       330 118 99 65 1   34       0 13   163 167                 330
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
299367 GA     school 1301290 633   Cobb County 130129001880 281 Dickerson Middle School   Regular School No Middle 06 08 2017 spring grade_7 305 21 23 0   84       0 11   209 235                       444 305 21 23 0   84       0 11   209 235                 444
299368 GA     school 1301290 633   Cobb County 130129000508 275 Dodgen Middle School   Regular School No Middle 06 08 2017 spring grade_7 293 24 22 0   85       1 10   208 227                       435 293 24 22 0   85       1 10   208 227                 435
299369 GA     school 1301290 633   Cobb County 130129002248 299 Durham Middle School   Regular School No Middle 06 08 2017 spring grade_7 268 37 22 1   13       0 9   175 175                       350 268 37 22 1   13       0 9   175 175                 350
299370 GA     school 1301290 633   Cobb County 130129000536 1056 East Cobb Middle School   Regular School No Middle 06 08 2017 spring grade_7 87 205 99 4   19       0 10   220 204                       424 87 205 99 4   19       0 10   220 204                 424
299371 GA     school 1301290 633   Cobb County 130129000553 5058 Floyd Middle School   Regular School No Middle 06 08 2017 spring grade_7 33 136 128 1   6       0 7   146 165                       311 33 136 128 1   6       0 7   146 165                 311
299372 GA     school 1301290 633   Cobb County 130129000534 1060 Garrett Middle School   Regular School No Middle 06 08 2017 spring grade_7 25 182 94 1   0       0 10   150 162                       312 25 182 94 1   0       0 10   150 162                 312
299373 GA     school 1301290 633   Cobb County 130129000518 2560 Griffin Middle School   Regular School No Middle 06 08 2017 spring grade_7 73 115 219 0   8       0 12   204 223                       427 73 115 219 0   8       0 12   204 223                 427
299374 GA     school 1301290 633   Cobb County 130129000244 394 Hightower Trail Middle School   Regular School No Middle 06 08 2017 spring grade_7 257 29 14 0   42       0 20   194 168                       362 257 29 14 0   42       0 20   194 168                 362
299375 GA     school 1301290 633   Cobb County 130129003580 110 International Academy of Smyrna   Regular School Yes Elementary KG 08 2017 spring grade_7 4 58 8 0   2       0 4   36 40                       76 4 58 8 0   2       0 4   36 40                 76
299376 GA     school 1301290 633   Cobb County 130129000561 202 Lindley Middle School   Regular School No Middle 06 08 2017 spring grade_7 16 299 156 0   2       0 10   245 238                       483 16 299 156 0   2       0 10   245 238                 483
299377 GA     school 1301290 633   Cobb County 130129002250 499 Lost Mountain Middle School   Regular School No Middle 06 08 2017 spring grade_7 285 69 26 0   15       0 9   207 197                       404 285 69 26 0   15       0 9   207 197                 404
299378 GA     school 1301290 633   Cobb County 130129003622 607 Lovinggood Middle School   Regular School No Middle 06 08 2017 spring grade_7 202 149 57 2   15       1 25   223 228                       451 202 149 57 2   15       1 25   223 228                 451
299379 GA     school 1301290 633   Cobb County 130129000512 178 Mabry Middle School   Regular School No Middle 06 08 2017 spring grade_7 216 19 28 1   27       0 13   147 157                       304 216 19 28 1   27       0 13   147 157                 304
299380 GA     school 1301290 633   Cobb County 130129001926 184 McCleskey Middle School   Regular School No Middle 06 08 2017 spring grade_7 143 37 33 0   12       0 14   123 116                       239 143 37 33 0   12       0 14   123 116                 239
299381 GA     school 1301290 633   Cobb County 130129003632 507 McClure Middle School   Regular School No Middle 06 08 2017 spring grade_7 285 78 41 4   19       0 12   232 207                       439 285 78 41 4   19       0 12   232 207                 439
299382 GA     school 1301290 633   Cobb County 130129002476 602 Palmer Middle School   Regular School No Middle 06 08 2017 spring grade_7 140 80 67 2   12       1 13   167 148                       315 140 80 67 2   12       1 13   167 148                 315
299383 GA     school 1301290 633   Cobb County 130129000511 280 Pine Mountain Middle School   Regular School No Middle 06 08 2017 spring grade_7 58 74 42 2   12       1 4   100 93                       193 58 74 42 2   12       1 4   100 93                 193
299384 GA     school 1301290 633   Cobb County 130129002023 389 Simpson Middle School   Regular School No Middle 06 08 2017 spring grade_7 224 27 33 0   31       0 16   172 159                       331 224 27 33 0   31       0 16   172 159                 331
299385 GA     school 1301290 633   Cobb County 130129000242 294 Smitha Middle School   Regular School No Middle 06 08 2017 spring grade_7 22 125 155 0   5       1 9   179 138                       317 22 125 155 0   5       1 9   179 138                 317
299386 GA     school 1301290 633   Cobb County 130129000541 475 Tapp Middle School   Regular School No Middle 06 08 2017 spring grade_7 28 158 62 1   5       0 11   139 126                       265 28 158 62 1   5       0 11   139 126                 265
299717 GA     school 1301350 634   Coffee County 130135003321 108 Coffee Middle School   Regular School No Middle 06 08 2017 spring grade_7 267 161 100 0   8       0 14   252 298                       550 267 161 100 0   8       0 14   252 298                 550
299807 GA     school 1301380 635   Colquitt County 130138000595 111 Willie J. Williams Middle School   Regular School No Middle 06 07 2017 spring grade_7 260 180 192 0   7       0 18   359 298                       657 260 180 192 0   7       0 18   359 298                 657
299960 GA     school 1301410 636   Columbia County 130141000607 2050 Columbia Middle School   Regular School No Middle 06 08 2017 spring grade_7 227 79 39 1   14       0 23   193 190                       383 227 79 39 1   14       0 23   193 190                 383
299961 GA     school 1301410 636   Columbia County 130141000601 107 Evans Middle School   Regular School No Middle 06 08 2017 spring grade_7 211 56 31 1   4       1 19   156 167                       323 211 56 31 1   4       1 19   156 167                 323
299962 GA     school 1301410 636   Columbia County 130141002366 101 Greenbrier Middle School   Regular School No Middle 06 08 2017 spring grade_7 149 29 18 1   8       1 6   106 106                       212 149 29 18 1   8       1 6   106 106                 212
299963 GA     school 1301410 636   Columbia County 130141002528 103 Grovetown Middle School   Regular School No Middle 06 08 2017 spring grade_7 127 106 49 1   5       1 25   145 169                       314 127 106 49 1   5       1 25   145 169                 314
299964 GA     school 1301410 636   Columbia County 130141001886 283 Harlem Middle School   Regular School No Middle 06 08 2017 spring grade_7 133 30 14 0   1       0 11   97 92                       189 133 30 14 0   1       0 11   97 92                 189
299965 GA     school 1301410 636   Columbia County 130141002073 290 Lakeside Middle School   Regular School No Middle 06 08 2017 spring grade_7 110 45 13 0   12       2 7   90 99                       189 110 45 13 0   12       2 7   90 99                 189
299966 GA     school 1301410 636   Columbia County 130141000126 193 Riverside Middle School   Regular School No Middle 06 08 2017 spring grade_7 162 27 14 0   10       0 8   115 106                       221 162 27 14 0   10       0 8   115 106                 221
299967 GA     school 1301410 636   Columbia County 130141003694 108 Stallings Island Middle School   Regular School No Middle 06 08 2017 spring grade_7 142 26 10 0   18       0 7   105 98                       203 142 26 10 0   18       0 7   105 98                 203
300057 GA     school 1301470 637   Cook County 130147000628 101 Cook County Middle School   Regular School No Middle 06 08 2017 spring grade_7 132 68 16 0   1       0 8   117 108                       225 132 68 16 0   1       0 8   117 108                 225
300176 GA     school 1301500 638   Coweta County 130150000825 395 Arnall Middle School   Regular School No Middle 06 08 2017 spring grade_7 140 89 38 4   9       1 13   172 122                       294 140 89 38 4   9       1 13   172 122                 294
300177 GA     school 1301500 638   Coweta County 130150002027 289 East Coweta Middle School   Regular School No Middle 06 08 2017 spring grade_7 171 42 25 3   2       0 8   112 139                       251 171 42 25 3   2       0 8   112 139                 251
300178 GA     school 1301500 638   Coweta County 130150000750 1056 Evans Middle School   Regular School No Middle 06 08 2017 spring grade_7 149 76 22 0   3       0 11   135 126                       261 149 76 22 0   3       0 11   135 126                 261
300179 GA     school 1301500 638   Coweta County 130150003328 106 Lee Middle School   Regular School No Middle 06 08 2017 spring grade_7 202 63 27 0   12       0 17   171 150                       321 202 63 27 0   12       0 17   171 150                 321
300180 GA     school 1301500 638   Coweta County 130150002252 299 Madras Middle School   Regular School No Middle 06 08 2017 spring grade_7 251 50 31 3   10       0 18   194 169                       363 251 50 31 3   10       0 18   194 169                 363
300181 GA     school 1301500 638   Coweta County 130150002367 301 Smokey Road Middle School   Regular School No Middle 06 08 2017 spring grade_7 129 62 15 0   0       0 9   112 103                       215 129 62 15 0   0       0 9   112 103                 215
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
300283 GA     school 1301560 640   Crisp County 130156001508 197 Crisp County Middle School   Regular School No Middle 06 08 2017 spring grade_7 81 174 14 0   6       0 9   131 153                       284 81 174 14 0   6       0 9   131 153                 284
300307 GA     school 1301590 641   Dade County 130159000777 295 Dade Middle School   Regular School No Middle 06 08 2017 spring grade_7 154 4 2 0   1       0 1   89 73                       162 154 4 2 0   1       0 1   89 73                 162
300342 GA     school 1301650 642   Dawson County 130165001952 106 Dawson County Middle School   Regular School No Middle 06 07 2017 spring grade_7 270 0 23 0   2       0 3   152 146                       298 270 0 23 0   2       0 3   152 146                 298
300388 GA     school 1301710 643   Decatur County 130171000614 2050 Bainbridge Middle School   Regular School No Middle 07 08 2017 spring grade_7 143 187 33 0   1       1 13   194 184                       378 143 187 33 0   1       1 13   194 184                 378
300389 GA     school 1301710 643   Decatur County 130171004170 116 New Beginning Learning Center   Regular School No Other 06 12 2017 spring grade_7 0 5 0 0   0       0 0   1 4                       5 0 5 0 0   0       0 0   1 4                 5
300948 GA     school 1301740 644   DeKalb County 130174002310 200 Cedar Grove Middle School   Regular School No Middle 06 08 2017 spring grade_7 0 238 7 0   0       0 2   122 125                       247 0 238 7 0   0       0 2   122 125                 247
300949 GA     school 1301740 644   DeKalb County 130174003336 406 Chamblee Middle School   Regular School No Middle 06 08 2017 spring grade_7 166 92 51 1   53       0 14   185 192                       377 166 92 51 1   53       0 14   185 192                 377
300950 GA     school 1301740 644   DeKalb County 130174000083 193 Chapel Hill Middle School   Regular School No Middle 06 08 2017 spring grade_7 4 263 2 0   3       1 3   148 128                       276 4 263 2 0   3       1 3   148 128                 276
300951 GA     school 1301740 644   DeKalb County 130174002480 301 Columbia Middle School   Regular School No Middle 06 08 2017 spring grade_7 0 279 6 0   1       0 4   136 154                       290 0 279 6 0   1       0 4   136 154                 290
300952 GA     school 1301740 644   DeKalb County 130174003955 1010 DeKalb Agriculture Technology and Environment School   Regular School Yes Elementary KG 08 2017 spring grade_7 0 74 9 0   0       0 1   41 43                       84 0 74 9 0   0       0 1   41 43                 84
300953 GA     school 1301740 644   DeKalb County 130174002313 500 DeKalb Alternative School   Alternative School No Other 06 12 2017 spring grade_7 0 25 2 0   0       0 0   19 8                       27 0 25 2 0   0       0 0   19 8                 27
300954 GA     school 1301740 644   DeKalb County 130174000656 1050 DeKalb Elementary School of the Arts   Regular School No Elementary KG 07 2017 spring grade_7 1 87 0 0   0       0 1   25 64                       89 1 87 0 0   0       0 1   25 64                 89
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
300956 GA     school 1301740 644   DeKalb County 130174004071 113 DeKalb Preparatory Academy Charter   Regular School Yes Elementary KG 08 2017 spring grade_7 0 46 0 0   0       0 0   25 21                       46 0 46 0 0   0       0 0   25 21                 46
300957 GA     school 1301740 644   DeKalb County 130174001589 897 Druid Hills Middle School   Regular School No Middle 06 08 2017 spring grade_7 77 128 33 0   34       0 9   142 139                       281 77 128 33 0   34       0 9   142 139                 281
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
300959 GA     school 1301740 644   DeKalb County 130174002370 201 Freedom Middle School   Regular School No Middle 06 08 2017 spring grade_7 17 236 18 0   132       0 3   219 187                       406 17 236 18 0   132       0 3   219 187                 406
300960 GA     school 1301740 644   DeKalb County 130174001586 797 Henderson Middle School   Regular School No Middle 06 08 2017 spring grade_7 162 123 202 4   36       4 15   291 255                       546 162 123 202 4   36       4 15   291 255                 546
300961 GA     school 1301740 644   DeKalb County 130174003559 1100 International Student Center   Regular School No Middle 07 08 2017 spring grade_7 7 81 90 0   33       0 0   133 78                       211 7 81 90 0   33       0 0   133 78                 211
300962 GA     school 1301740 644   DeKalb County 130174004006 311 Leadership Preparatory Academy   Regular School Yes Elementary KG 08 2017 spring grade_7 0 52 3 0   0       0 1   28 28                       56 0 52 3 0   0       0 1   28 28                 56
300963 GA     school 1301740 644   DeKalb County 130174002858 203 Lithonia Middle School   Regular School No Middle 06 08 2017 spring grade_7 2 344 19 0   1       0 10   197 179                       376 2 344 19 0   1       0 10   197 179                 376
300964 GA     school 1301740 644   DeKalb County 130174003868 510 Margaret Harris Comprehensive School   Regular School No Other PK 12 2017 spring grade_7 0 3 0 0   0       0 1   4 0                       4 0 3 0 0   0       0 1   4 0                 4
300965 GA     school 1301740 644   DeKalb County 130174002482 401 Mary McLeod Bethune Middle School   Regular School No Middle 06 08 2017 spring grade_7 4 247 17 0   8       0 3   137 142                       279 4 247 17 0   8       0 3   137 142                 279
300966 GA     school 1301740 644   DeKalb County 130174000649 1057 McNair Middle School   Regular School No Middle 06 08 2017 spring grade_7 2 232 3 2   1       1 2   120 123                       243 2 232 3 2   1       1 2   120 123                 243
300967 GA     school 1301740 644   DeKalb County 130174001568 597 Miller Grove Middle School   Regular School No Middle 06 08 2017 spring grade_7 0 310 6 1   4       1 6   171 157                       328 0 310 6 1   4       1 6   171 157                 328
300968 GA     school 1301740 644   DeKalb County 130174004039 215 Museum School Avondale Estates   Regular School Yes Elementary KG 08 2017 spring grade_7 23 16 4 0   1       0 4   23 25                       48 23 16 4 0   1       0 4   23 25                 48
300969 GA     school 1301740 644   DeKalb County 130174002031 189 Peachtree Middle School   Regular School Yes Middle 06 08 2017 spring grade_7 212 79 157 0   31       0 15   262 232                       494 212 79 157 0   31       0 15   262 232                 494
300970 GA     school 1301740 644   DeKalb County 130174002859 205 Redan Middle School   Regular School No Middle 06 08 2017 spring grade_7 1 227 12 0   0       0 2   129 113                       242 1 227 12 0   0       0 2   129 113                 242
300971 GA     school 1301740 644   DeKalb County 130174000222 291 Salem Middle School   Regular School No Middle 06 08 2017 spring grade_7 1 313 14 1   1       1 5   158 178                       336 1 313 14 1   1       1 5   158 178                 336
300972 GA     school 1301740 644   DeKalb County 130174000672 290 Sequoyah Middle School   Regular School No Middle 06 08 2017 spring grade_7 5 8 438 0   32       0 1   244 240                       484 5 8 438 0   32       0 1   244 240                 484
300973 GA     school 1301740 644   DeKalb County 130174001547 397 Stephenson Middle School   Regular School No Middle 06 08 2017 spring grade_7 3 308 8 0   2       0 4   181 144                       325 3 308 8 0   2       0 4   181 144                 325
300974 GA     school 1301740 644   DeKalb County 130174003337 506 Stone Mountain Middle School   Regular School No Middle 06 08 2017 spring grade_7 7 227 30 1   23       1 3   154 138                       292 7 227 30 1   23       1 3   154 138                 292
300975 GA     school 1301740 644   DeKalb County 130174004159 315 Tapestry Public Charter School   Regular School Yes Other 06 10 2017 spring grade_7 18 8 3 0   2       0 1   20 12                       32 18 8 3 0   2       0 1   20 12                 32
300976 GA     school 1301740 644   DeKalb County 130174003643 507 The Champion Middle Theme School   Regular School No Middle 06 08 2017 spring grade_7 0 251 7 1   0       0 2   125 136                       261 0 251 7 1   0       0 2   125 136                 261
300977 GA     school 1301740 644   DeKalb County 130174003338 605 Tucker Middle School   Regular School No Middle 06 08 2017 spring grade_7 48 266 63 1   66       1 9   263 191                       454 48 266 63 1   66       1 9   263 191                 454
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
301346 GA     school 1301770 645   Dodge County 130177004186 292 DAC (Dodge County Achievement Center)   Regular School No High 07 12 2017 spring grade_7 3 0 0 0   0       0 0   1 2                       3 3 0 0 0   0       0 0   1 2                 3
301347 GA     school 1301770 645   Dodge County 130177000803 180 Dodge County Middle School   Regular School No Middle 06 08 2017 spring grade_7 141 79 6 0   0       0 11   120 117                       237 141 79 6 0   0       0 11   120 117                 237
301369 GA     school 1301800 646   Dooly County 130180002075 204 Dooly County Middle School   Regular School No Middle 06 08 2017 spring grade_7 11 52 14 1   0       0 1   28 51                       79 11 52 14 1   0       0 1   28 51                 79
301464 GA     school 1301830 647   Dougherty County 130183000833 101 Albany Middle School   Regular School No Middle 06 08 2017 spring grade_7 11 274 1 0   0       1 2   148 141                       289 11 274 1 0   0       1 2   148 141                 289
301465 GA     school 1301830 647   Dougherty County 130183000842 4056 Merry Acres Middle School   Regular School No Middle 06 08 2017 spring grade_7 3 196 2 0   2       0 3   107 99                       206 3 196 2 0   2       0 3   107 99                 206
301466 GA     school 1301830 647   Dougherty County 130183003343 106 Radium Springs Middle School   Regular School No Middle 06 08 2017 spring grade_7 9 151 12 2   0       0 3   88 89                       177 9 151 12 2   0       0 3   88 89                 177
301467 GA     school 1301830 647   Dougherty County 130183002546 103 Robert A. Cross Middle Magnet   Regular School No Middle 06 08 2017 spring grade_7 19 145 4 5   3       1 4   76 105                       181 19 145 4 5   3       1 4   76 105                 181
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
301661 GA     school 1301860 648   Douglas County 130186003670 407 Brighten Academy   Regular School Yes Elementary KG 08 2017 spring grade_7 20 31 2 0   1       0 2   30 26                       56 20 31 2 0   1       0 2   30 26                 56
301662 GA     school 1301860 648   Douglas County 130186000865 3550 Chapel Hill Middle School   Regular School No Middle 06 08 2017 spring grade_7 80 247 41 0   6       2 22   222 176                       398 80 247 41 0   6       2 22   222 176                 398
301663 GA     school 1301860 648   Douglas County 130186002000 188 Chestnut Log Middle School   Regular School No Middle 06 08 2017 spring grade_7 30 138 42 0   3       1 5   126 93                       219 30 138 42 0   3       1 5   126 93                 219
301664 GA     school 1301860 648   Douglas County 130186003557 108 Factory Shoals Middle School   Regular School No Middle 06 08 2017 spring grade_7 16 216 36 2   1       0 4   142 133                       275 16 216 36 2   1       0 4   142 133                 275
301665 GA     school 1301860 648   Douglas County 130186000851 180 Fairplay Middle School   Regular School No Middle 06 08 2017 spring grade_7 127 16 9 0   1       0 4   79 78                       157 127 16 9 0   1       0 4   79 78                 157
301666 GA     school 1301860 648   Douglas County 130186003890 113 Mason Creek Middle School   Regular School No Middle 06 08 2017 spring grade_7 110 129 34 1   4       0 10   153 135                       288 110 129 34 1   4       0 10   153 135                 288

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