Data source: Big Local News · About: Big Local

29,136 rows where state = "GA" and year = 2017 sorted by black_int

View and edit SQL

grade

year

  • 2017 · 29,136
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
296344 GA     school 1300060 601   Appling County 130006000008 5050 Fourth District Elementary School   Regular School No Elementary PK 05 2017 spring kindergarten 26 0 4 0   0       0 1   17 14                       31 26 0 4 0   0       0 1   17 14                 31
296550 GA     school 1300290 607   Barrow County 130029000178 1050 Auburn Elementary School   Regular School No Elementary PK 05 2017 spring pre_kindergarten 56 0 14 0   5       0 6   50 31                       81 56 0 14 0   5       0 6   50 31                 81
296567 GA     school 1300330 608   Bartow County 130033003586 106 Pine Log Elementary   Regular School No Elementary PK 05 2017 spring grade_1 49 0 6 0   0       0 2   30 27                       57 49 0 6 0   0       0 2   30 27                 57
296568 GA     school 1300330 608   Bartow County 130033000187 396 Taylorsville Elementary School   Regular School No Elementary PK 05 2017 spring grade_1 58 0 8 0   0       0 2   33 35                       68 58 0 8 0   0       0 2   33 35                 68
296588 GA     school 1300330 608   Bartow County 130033003586 106 Pine Log Elementary   Regular School No Elementary PK 05 2017 spring grade_2 54 0 1 1   0       0 1   29 28                       57 54 0 1 1   0       0 1   29 28                 57
296600 GA     school 1300330 608   Bartow County 130033003586 106 Pine Log Elementary   Regular School No Elementary PK 05 2017 spring grade_3 58 0 1 1   0       0 0   33 27                       60 58 0 1 1   0       0 0   33 27                 60
296624 GA     school 1300330 608   Bartow County 130033003586 106 Pine Log Elementary   Regular School No Elementary PK 05 2017 spring grade_5 55 0 7 1   0       0 4   40 27                       67 55 0 7 1   0       0 4   40 27                 67
296651 GA     school 1300330 608   Bartow County 130033003586 106 Pine Log Elementary   Regular School No Elementary PK 05 2017 spring kindergarten 49 0 3 0   0       0 2   27 27                       54 49 0 3 0   0       0 2   27 27                 54
297025 GA     school 1300480 613   Brantley County 130048002295 101 Waynesville Primary School   Regular School No Elementary PK 03 2017 spring kindergarten 91 0 2 0   0       0 4   44 53                       97 91 0 2 0   0       0 4   44 53                 97
297033 GA     school 1300480 613   Brantley County 130048000257 2050 Hoboken Elementary School   Regular School No Elementary PK 06 2017 spring pre_kindergarten 38 0 1 0   0       0 1   24 16                       40 38 0 1 0   0       0 1   24 16                 40
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
297053 GA     school 1300540 614   Brooks County 130054000263 110 Brooks County High School   Regular School No Other 06 12 2017 spring grade_8 1 0 0 0   0       0 0   1 0                       1 1 0 0 0   0       0 0   1 0                 1
297399 GA     school 1300840 622   Carroll County 130084000328 377 Roopville Elementary School   Regular School No Elementary PK 05 2017 spring grade_1 44 0 2 0   1       0 2   29 20                       49 44 0 2 0   1       0 2   29 20                 49
297419 GA     school 1300840 622   Carroll County 130084003483 112 KidsPeace   Regular School No High 07 12 2017 spring grade_12 1 0 0 0   0       0 0   1 0                       1 1 0 0 0   0       0 0   1 0                 1
297453 GA     school 1300840 622   Carroll County 130084000328 377 Roopville Elementary School   Regular School No Elementary PK 05 2017 spring grade_4 53 0 2 0   1       0 2   29 29                       58 53 0 2 0   1       0 2   29 29                 58
297540 GA     school 1300840 622   Carroll County 130084000328 377 Roopville Elementary School   Regular School No Elementary PK 05 2017 spring pre_kindergarten 40 0 1 0   0       0 2   21 22                       43 40 0 1 0   0       0 2   21 22                 43
297553 GA     school 1300930 623   Catoosa County 130093003304 105 Woodstation Elementary School   Regular School No Elementary PK 05 2017 spring grade_1 70 0 2 0   0       0 1   45 28                       73 70 0 2 0   0       0 1   45 28                 73
297564 GA     school 1300930 623   Catoosa County 130093000845 1050 Boynton Elementary School   Regular School No Elementary PK 05 2017 spring grade_2 81 0 5 0   2       0 0   46 42                       88 81 0 5 0   2       0 0   46 42                 88
297567 GA     school 1300930 623   Catoosa County 130093002300 100 Ringgold Primary School   Regular School No Elementary PK 02 2017 spring grade_2 139 0 3 0   3       0 8   80 73                       153 139 0 3 0   3       0 8   80 73                 153
297568 GA     school 1300930 623   Catoosa County 130093001934 185 Tiger Creek Elementary School   Regular School No Elementary PK 05 2017 spring grade_2 72 0 2 1   0       0 0   35 40                       75 72 0 2 1   0       0 0   35 40                 75
297570 GA     school 1300930 623   Catoosa County 130093003304 105 Woodstation Elementary School   Regular School No Elementary PK 05 2017 spring grade_2 68 0 1 0   0       0 1   36 34                       70 68 0 1 0   0       0 1   36 34                 70
297574 GA     school 1300930 623   Catoosa County 130093000352 5050 Graysville Elementary School   Regular School No Elementary PK 05 2017 spring grade_3 81 0 3 0   3       0 2   38 51                       89 81 0 3 0   3       0 2   38 51                 89
297584 GA     school 1300930 623   Catoosa County 130093001934 185 Tiger Creek Elementary School   Regular School No Elementary PK 05 2017 spring grade_4 68 0 6 0   0       0 4   42 36                       78 68 0 6 0   0       0 4   42 36                 78
297592 GA     school 1300930 623   Catoosa County 130093001934 185 Tiger Creek Elementary School   Regular School No Elementary PK 05 2017 spring grade_5 62 0 5 1   0       0 1   29 40                       69 62 0 5 1   0       0 1   29 40                 69
297610 GA     school 1300930 623   Catoosa County 130093000352 5050 Graysville Elementary School   Regular School No Elementary PK 05 2017 spring kindergarten 58 0 6 0   2       0 6   38 34                       72 58 0 6 0   2       0 6   38 34                 72
297634 GA     school 1300930 623   Catoosa County 130093001934 185 Tiger Creek Elementary School   Regular School No Elementary PK 05 2017 spring pre_kindergarten 21 0 0 0   0       0 1   14 8                       22 21 0 0 0   0       0 1   14 8                 22
297635 GA     school 1300930 623   Catoosa County 130093000349 1054 West Side Elementary School   Regular School No Elementary PK 05 2017 spring pre_kindergarten 37 0 2 0   4       0 2   26 19                       45 37 0 2 0   4       0 2   26 19                 45
297638 GA     school 1300990 624   Charlton County 130099000359 4050 St. George Elementary School   Regular School No Elementary PK 06 2017 spring grade_1 23 0 1 0   0       0 0   10 14                       24 23 0 1 0   0       0 0   10 14                 24
297643 GA     school 1300990 624   Charlton County 130099000359 4050 St. George Elementary School   Regular School No Elementary PK 06 2017 spring grade_2 18 0 1 0   0       0 2   12 9                       21 18 0 1 0   0       0 2   12 9                 21
297656 GA     school 1300990 624   Charlton County 130099000359 4050 St. George Elementary School   Regular School No Elementary PK 06 2017 spring kindergarten 18 0 0 1   0       0 0   14 5                       19 18 0 0 1   0       0 0   14 5                 19
297662 GA     school 1300990 624   Charlton County 130099000359 4050 St. George Elementary School   Regular School No Elementary PK 06 2017 spring pre_kindergarten 19 0 1 0   0       0 1   13 8                       21 19 0 1 0   0       0 1   13 8                 21
297715 GA     school 1301020 625   Savannah-Chatham County 130102000410 3062 Low Elementary School   Regular School No Other PK 11 2017 spring grade_11 2 0 0 0   0       0 0   1 1                       2 2 0 0 0   0       0 0   1 1                 2
298082 GA     school 1301080 627   Chattooga County 130108003571 111 Chattooga Academy   Alternative School No Other 01 12 2017 spring grade_1 1 0 0 0   0       0 0   0 1                       1 1 0 0 0   0       0 0   0 1                 1
298084 GA     school 1301080 627   Chattooga County 130108000417 2050 Lyerly Elementary School   Regular School No Elementary PK 08 2017 spring grade_1 32 0 2 0   0       0 0   20 14                       34 32 0 2 0   0       0 0   20 14                 34
298085 GA     school 1301080 627   Chattooga County 130108000421 3050 Menlo Elementary School   Regular School No Elementary PK 08 2017 spring grade_1 29 0 1 1   0       0 3   14 20                       34 29 0 1 1   0       0 3   14 20                 34
298093 GA     school 1301080 627   Chattooga County 130108000417 2050 Lyerly Elementary School   Regular School No Elementary PK 08 2017 spring grade_2 38 0 2 0   0       0 0   17 23                       40 38 0 2 0   0       0 0   17 23                 40
298094 GA     school 1301080 627   Chattooga County 130108000421 3050 Menlo Elementary School   Regular School No Elementary PK 08 2017 spring grade_2 35 0 0 1   0       0 1   17 20                       37 35 0 0 1   0       0 1   17 20                 37
298102 GA     school 1301080 627   Chattooga County 130108000421 3050 Menlo Elementary School   Regular School No Elementary PK 08 2017 spring grade_4 37 0 1 0   0       0 0   24 14                       38 37 0 1 0   0       0 0   24 14                 38
298105 GA     school 1301080 627   Chattooga County 130108000421 3050 Menlo Elementary School   Regular School No Elementary PK 08 2017 spring grade_5 38 0 0 0   1       0 1   19 21                       40 38 0 0 0   1       0 1   19 21                 40
298106 GA     school 1301080 627   Chattooga County 130108003571 111 Chattooga Academy   Alternative School No Other 01 12 2017 spring grade_6 1 0 0 0   0       0 0   1 0                       1 1 0 0 0   0       0 0   1 0                 1
298107 GA     school 1301080 627   Chattooga County 130108000417 2050 Lyerly Elementary School   Regular School No Elementary PK 08 2017 spring grade_6 28 0 2 0   0       0 0   16 14                       30 28 0 2 0   0       0 0   16 14                 30
298108 GA     school 1301080 627   Chattooga County 130108000421 3050 Menlo Elementary School   Regular School No Elementary PK 08 2017 spring grade_6 29 0 2 0   1       0 1   16 17                       33 29 0 2 0   1       0 1   16 17                 33
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
298112 GA     school 1301080 627   Chattooga County 130108000421 3050 Menlo Elementary School   Regular School No Elementary PK 08 2017 spring grade_7 37 0 1 0   0       0 1   16 23                       39 37 0 1 0   0       0 1   16 23                 39
298114 GA     school 1301080 627   Chattooga County 130108003571 111 Chattooga Academy   Alternative School No Other 01 12 2017 spring grade_8 8 0 0 0   0       0 2   6 4                       10 8 0 0 0   0       0 2   6 4                 10
298115 GA     school 1301080 627   Chattooga County 130108000417 2050 Lyerly Elementary School   Regular School No Elementary PK 08 2017 spring grade_8 33 0 1 0   0       0 1   22 13                       35 33 0 1 0   0       0 1   22 13                 35
298116 GA     school 1301080 627   Chattooga County 130108000421 3050 Menlo Elementary School   Regular School No Elementary PK 08 2017 spring grade_8 25 0 1 0   1       0 2   17 12                       29 25 0 1 0   1       0 2   17 12                 29
298121 GA     school 1301080 627   Chattooga County 130108000417 2050 Lyerly Elementary School   Regular School No Elementary PK 08 2017 spring kindergarten 35 0 0 0   0       0 1   22 14                       36 35 0 0 0   0       0 1   22 14                 36
298122 GA     school 1301080 627   Chattooga County 130108000421 3050 Menlo Elementary School   Regular School No Elementary PK 08 2017 spring kindergarten 33 0 0 0   0       0 1   14 20                       34 33 0 0 0   0       0 1   14 20                 34
298131 GA     school 1301080 627   Chattooga County 130108000421 3050 Menlo Elementary School   Regular School No Elementary PK 08 2017 spring pre_kindergarten 20 0 1 0   0       0 1   9 13                       22 20 0 1 0   0       0 1   9 13                 22
298134 GA     school 1301110 628   Cherokee County 130111000429 213 Ball Ground Elementary School   Regular School No Elementary PK 05 2017 spring grade_1 80 0 0 0   0       0 1   39 42                       81 80 0 0 0   0       0 1   39 42                 81
298140 GA     school 1301110 628   Cherokee County 130111000428 1052 Clayton Elementary School   Regular School No Elementary PK 05 2017 spring grade_1 43 0 1 0   0       0 1   21 24                       45 43 0 1 0   0       0 1   21 24                 45
298146 GA     school 1301110 628   Cherokee County 130111001878 182 Johnston Elementary School   Regular School No Elementary PK 05 2017 spring grade_1 56 0 21 0   1       0 1   48 31                       79 56 0 21 0   1       0 1   48 31                 79
298152 GA     school 1301110 628   Cherokee County 130111002055 198 R. M. Moore Elementary School   Regular School No Elementary PK 05 2017 spring grade_1 61 0 3 0   1       0 0   32 33                       65 61 0 3 0   1       0 0   32 33                 65
298182 GA     school 1301110 628   Cherokee County 130111000428 1052 Clayton Elementary School   Regular School No Elementary PK 05 2017 spring grade_2 39 0 1 0   0       0 2   22 20                       42 39 0 1 0   0       0 2   22 20                 42
298206 GA     school 1301110 628   Cherokee County 130111000428 1052 Clayton Elementary School   Regular School No Elementary PK 05 2017 spring grade_3 33 0 1 0   0       0 2   17 19                       36 33 0 1 0   0       0 2   17 19                 36
298207 GA     school 1301110 628   Cherokee County 130111000438 505 Free Home Elementary School   Regular School No Elementary PK 05 2017 spring grade_3 50 0 7 0   1       0 3   32 29                       61 50 0 7 0   1       0 3   32 29                 61
298218 GA     school 1301110 628   Cherokee County 130111002055 198 R. M. Moore Elementary School   Regular School No Elementary PK 05 2017 spring grade_3 73 0 4 0   2       0 0   44 35                       79 73 0 4 0   2       0 0   44 35                 79
298230 GA     school 1301110 628   Cherokee County 130111000428 1052 Clayton Elementary School   Regular School No Elementary PK 05 2017 spring grade_4 37 0 4 0   0       0 4   25 20                       45 37 0 4 0   0       0 4   25 20                 45
298255 GA     school 1301110 628   Cherokee County 130111000438 505 Free Home Elementary School   Regular School No Elementary PK 05 2017 spring grade_5 59 0 5 0   0       0 2   33 33                       66 59 0 5 0   0       0 2   33 33                 66
298305 GA     school 1301110 628   Cherokee County 130111000428 1052 Clayton Elementary School   Regular School No Elementary PK 05 2017 spring kindergarten 30 0 1 0   0       0 0   14 17                       31 30 0 1 0   0       0 0   14 17                 31
298306 GA     school 1301110 628   Cherokee County 130111000438 505 Free Home Elementary School   Regular School No Elementary PK 05 2017 spring kindergarten 42 0 10 0   2       0 2   29 27                       56 42 0 10 0   2       0 2   29 27                 56
298317 GA     school 1301110 628   Cherokee County 130111002055 198 R. M. Moore Elementary School   Regular School No Elementary PK 05 2017 spring kindergarten 50 0 5 0   1       0 0   28 28                       56 50 0 5 0   1       0 0   28 28                 56
298358 GA     school 1301110 628   Cherokee County 130111001443 397 Arnold Mill Elementary School   Regular School No Elementary PK 05 2017 spring pre_kindergarten 15 0 2 0   0       0 0   11 6                       17 15 0 2 0   0       0 0   11 6                 17
298360 GA     school 1301110 628   Cherokee County 130111000429 213 Ball Ground Elementary School   Regular School No Elementary PK 05 2017 spring pre_kindergarten 26 0 0 0   0       0 1   16 11                       27 26 0 0 0   0       0 1   16 11                 27
298361 GA     school 1301110 628   Cherokee County 130111001105 196 Bascomb Elementary School   Regular School No Elementary PK 05 2017 spring pre_kindergarten 25 0 3 0   0       0 0   19 9                       28 25 0 3 0   0       0 0   19 9                 28
298362 GA     school 1301110 628   Cherokee County 130111002020 189 Boston Elementary School   Regular School No Elementary PK 05 2017 spring pre_kindergarten 17 0 1 0   0       0 0   11 7                       18 17 0 1 0   0       0 0   11 7                 18
298366 GA     school 1301110 628   Cherokee County 130111000428 1052 Clayton Elementary School   Regular School No Elementary PK 05 2017 spring pre_kindergarten 4 0 0 0   0       0 0   2 2                       4 4 0 0 0   0       0 0   2 2                 4
298368 GA     school 1301110 628   Cherokee County 130111000435 3052 Hickory Flat Elementary School   Regular School No Elementary PK 05 2017 spring pre_kindergarten 1 0 1 0   0       0 0   1 1                       2 1 0 1 0   0       0 0   1 1                 2
298371 GA     school 1301110 628   Cherokee County 130111003769 509 J. Knox Elementary   Regular School No Elementary PK 05 2017 spring pre_kindergarten 21 0 3 0   0       0 1   19 6                       25 21 0 3 0   0       0 1   19 6                 25
298373 GA     school 1301110 628   Cherokee County 130111002521 203 Liberty Elementary School   Regular School No Elementary PK 05 2017 spring pre_kindergarten 13 0 6 1   1       0 2   17 6                       23 13 0 6 1   1       0 2   17 6                 23
298375 GA     school 1301110 628   Cherokee County 130111000431 5052 Macedonia Elementary School   Regular School No Elementary PK 05 2017 spring pre_kindergarten 23 0 3 0   0       0 1   19 8                       27 23 0 3 0   0       0 1   19 8                 27
298378 GA     school 1301110 628   Cherokee County 130111002055 198 R. M. Moore Elementary School   Regular School No Elementary PK 05 2017 spring pre_kindergarten 29 0 3 0   0       0 0   12 20                       32 29 0 3 0   0       0 0   12 20                 32
298379 GA     school 1301110 628   Cherokee County 130111000114 193 Sixes Elementary School   Regular School No Elementary PK 05 2017 spring pre_kindergarten 11 0 1 0   0       0 0   8 4                       12 11 0 1 0   0       0 0   8 4                 12
299053 GA     school 1301290 633   Cobb County 130129003679 807 Devereux Ackerman Academy   Special Education School No Other 05 12 2017 spring grade_12 1 0 0 0   0       0 0   1 0                       1 1 0 0 0   0       0 0   1 0                 1
299130 GA     school 1301290 633   Cobb County 130129002110 491 Timber Ridge Elementary School   Regular School No Elementary PK 05 2017 spring grade_2 60 0 7 0   12       0 3   41 41                       82 60 0 7 0   12       0 3   41 41                 82
299625 GA     school 1301290 633   Cobb County 130129000535 114 East Side Elementary School   Regular School No Elementary PK 05 2017 spring pre_kindergarten 14 0 2 0   2       0 2   15 5                       20 14 0 2 0   2       0 2   15 5                 20
299627 GA     school 1301290 633   Cobb County 130129000573 3058 Fair Oaks Elementary School   Regular School No Elementary PK 05 2017 spring pre_kindergarten 1 0 12 0   0       0 0   8 5                       13 1 0 12 0   0       0 0   8 5                 13
299628 GA     school 1301290 633   Cobb County 130129002154 292 Ford Elementary School   Regular School No Elementary PK 05 2017 spring pre_kindergarten 3 0 0 0   0       0 0   2 1                       3 3 0 0 0   0       0 0   2 1                 3
299635 GA     school 1301290 633   Cobb County 130129001972 187 Keheley Elementary School   Regular School No Elementary PK 05 2017 spring pre_kindergarten 2 0 0 0   0       0 0   2 0                       2 2 0 0 0   0       0 0   2 0                 2
299638 GA     school 1301290 633   Cobb County 130129000509 273 Kincaid Elementary School   Regular School No Elementary PK 05 2017 spring pre_kindergarten 2 0 0 0   0       0 1   1 2                       3 2 0 0 0   0       0 1   1 2                 3
299644 GA     school 1301290 633   Cobb County 130129000507 278 Mount Bethel Elementary School   Regular School No Elementary PK 05 2017 spring pre_kindergarten 2 0 0 0   0       0 0   2 0                       2 2 0 0 0   0       0 0   2 0                 2
299646 GA     school 1301290 633   Cobb County 130129000544 375 Murdock Elementary School   Regular School No Elementary PK 05 2017 spring pre_kindergarten 3 0 1 0   0       0 0   3 1                       4 3 0 1 0   0       0 0   3 1                 4
299677 GA     school 1301350 634   Coffee County 130135003323 308 George Washington Carver Freshman Campus   Regular School No Other 09 10 2017 spring grade_10 0 0 3 0   0       0 0   2 1                       3 0 0 3 0   0       0 0   2 1                 3
299789 GA     school 1301380 635   Colquitt County 130138000597 4052 Hamilton Elementary School   Regular School No Elementary PK 05 2017 spring grade_4 45 0 2 0   0       0 2   31 18                       49 45 0 2 0   0       0 2   31 18                 49
299799 GA     school 1301380 635   Colquitt County 130138000597 4052 Hamilton Elementary School   Regular School No Elementary PK 05 2017 spring grade_5 34 0 2 0   1       0 2   18 21                       39 34 0 2 0   1       0 2   18 21                 39
299816 GA     school 1301380 635   Colquitt County 130138000597 4052 Hamilton Elementary School   Regular School No Elementary PK 05 2017 spring kindergarten 30 0 4 0   3       0 2   22 17                       39 30 0 4 0   3       0 2   22 17                 39
300039 GA     school 1301410 636   Columbia County 130141000606 2052 Martinez Elementary School   Regular School No Elementary PK 05 2017 spring pre_kindergarten 9 0 0 0   0       0 0   6 3                       9 9 0 0 0   0       0 0   6 3                 9
300040 GA     school 1301410 636   Columbia County 130141000604 3052 North Columbia Elementary School   Regular School No Elementary PK 05 2017 spring pre_kindergarten 25 0 0 0   0       0 0   15 10                       25 25 0 0 0   0       0 0   15 10                 25
300044 GA     school 1301410 636   Columbia County 130141000248 194 Riverside Elementary School   Regular School No Elementary PK 05 2017 spring pre_kindergarten 2 0 0 0   0       0 1   1 2                       3 2 0 0 0   0       0 1   1 2                 3
300046 GA     school 1301410 636   Columbia County 130141002161 192 Stevens Creek Elementary School   Regular School No Elementary PK 05 2017 spring pre_kindergarten 4 0 2 0   0       0 1   6 1                       7 4 0 2 0   0       0 1   6 1                 7
300293 GA     school 1301590 641   Dade County 130159000868 101 Dade Elementary School   Regular School No Elementary PK 05 2017 spring grade_1 104 0 2 0   3       0 3   61 51                       112 104 0 2 0   3       0 3   61 51                 112
300294 GA     school 1301590 641   Dade County 130159000778 275 Davis Elementary School   Regular School No Elementary PK 05 2017 spring grade_1 35 0 1 2   0       0 2   14 26                       40 35 0 1 2   0       0 2   14 26                 40
300296 GA     school 1301590 641   Dade County 130159000775 195 Dade County High School   Regular School No High 09 12 2017 spring grade_11 129 0 2 0   2       0 0   72 61                       133 129 0 2 0   2       0 0   72 61                 133
300299 GA     school 1301590 641   Dade County 130159000778 275 Davis Elementary School   Regular School No Elementary PK 05 2017 spring grade_2 36 0 1 0   0       0 1   15 23                       38 36 0 1 0   0       0 1   15 23                 38
300301 GA     school 1301590 641   Dade County 130159000778 275 Davis Elementary School   Regular School No Elementary PK 05 2017 spring grade_3 53 0 3 0   0       0 1   28 29                       57 53 0 3 0   0       0 1   28 29                 57
300303 GA     school 1301590 641   Dade County 130159000778 275 Davis Elementary School   Regular School No Elementary PK 05 2017 spring grade_4 53 0 2 0   0       0 1   31 25                       56 53 0 2 0   0       0 1   31 25                 56
300305 GA     school 1301590 641   Dade County 130159000778 275 Davis Elementary School   Regular School No Elementary PK 05 2017 spring grade_5 54 0 2 0   0       0 1   24 33                       57 54 0 2 0   0       0 1   24 33                 57
300311 GA     school 1301590 641   Dade County 130159000778 275 Davis Elementary School   Regular School No Elementary PK 05 2017 spring kindergarten 40 0 0 0   0       0 1   22 19                       41 40 0 0 0   0       0 1   22 19                 41
300315 GA     school 1301590 641   Dade County 130159000778 275 Davis Elementary School   Regular School No Elementary PK 05 2017 spring pk_12_total 317 0 9 2   0       0 7   158 177                       335 317 0 9 2   0       0 7   158 177                 335

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