Data source: Big Local News · About: Big Local

29,417 rows where state = "GA" and year = 2020 sorted by school_state_id

View and edit SQL

grade

year

  • 2020 · 29,417
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
310992 GA     school 1300210 605   Baldwin County 130021002347 100 Oak Hill MS   Regular School No Middle 06 08 2020 spring grade_6 82 286 9 0   2       0 20   208 191                       399 82 286 9 0   2       0 20   208 191                 399
310993 GA     school 1300210 605   Baldwin County 130021002347 100 Oak Hill MS   Regular School No Middle 06 08 2020 spring grade_7 78 275 17 0   1       1 11   188 195                       383 78 275 17 0   1       1 11   188 195                 383
310994 GA     school 1300210 605   Baldwin County 130021002347 100 Oak Hill MS   Regular School No Middle 06 08 2020 spring grade_8 68 280 6 0   6       1 10   201 170                       371 68 280 6 0   6       1 10   201 170                 371
311003 GA     school 1300210 605   Baldwin County 130021002347 100 Oak Hill MS   Regular School No Middle 06 08 2020 spring pk_12_total 228 841 32 0   9       2 41   597 556                       1153 228 841 32 0   9       2 41   597 556                 1153
311668 GA     school 1300630 616   Bulloch County 130063002296 100 Mill Creek Elementary School   Regular School No Elementary PK 05 2020 spring grade_1 29 46 13 0   1       0 2   51 40                       91 29 46 13 0   1       0 2   51 40                 91
311686 GA     school 1300630 616   Bulloch County 130063002296 100 Mill Creek Elementary School   Regular School No Elementary PK 05 2020 spring grade_2 20 43 3 0   4       1 4   37 38                       75 20 43 3 0   4       1 4   37 38                 75
311695 GA     school 1300630 616   Bulloch County 130063002296 100 Mill Creek Elementary School   Regular School No Elementary PK 05 2020 spring grade_3 28 64 6 0   3       0 2   51 52                       103 28 64 6 0   3       0 2   51 52                 103
311704 GA     school 1300630 616   Bulloch County 130063002296 100 Mill Creek Elementary School   Regular School No Elementary PK 05 2020 spring grade_4 35 51 7 0   0       0 2   42 53                       95 35 51 7 0   0       0 2   42 53                 95
311713 GA     school 1300630 616   Bulloch County 130063002296 100 Mill Creek Elementary School   Regular School No Elementary PK 05 2020 spring grade_5 24 55 4 1   2       0 4   45 45                       90 24 55 4 1   2       0 4   45 45                 90
311737 GA     school 1300630 616   Bulloch County 130063002296 100 Mill Creek Elementary School   Regular School No Elementary PK 05 2020 spring kindergarten 33 54 6 0   0       0 1   49 45                       94 33 54 6 0   0       0 1   49 45                 94
311747 GA     school 1300630 616   Bulloch County 130063002296 100 Mill Creek Elementary School   Regular School No Elementary PK 05 2020 spring pk_12_total 181 343 40 1   10       1 16   295 297                       592 181 343 40 1   10       1 16   295 297                 592
311761 GA     school 1300630 616   Bulloch County 130063002296 100 Mill Creek Elementary School   Regular School No Elementary PK 05 2020 spring pre_kindergarten 12 30 1 0   0       0 1   20 24                       44 12 30 1 0   0       0 1   20 24                 44
311812 GA     school 1300690 618   Butts County 130069002353 100 Henderson Middle School   Regular School No Middle 06 08 2020 spring grade_6 141 91 10 0   0       0 15   129 128                       257 141 91 10 0   0       0 15   129 128                 257
311813 GA     school 1300690 618   Butts County 130069002353 100 Henderson Middle School   Regular School No Middle 06 08 2020 spring grade_7 147 102 12 0   2       0 20   139 144                       283 147 102 12 0   2       0 20   139 144                 283
311814 GA     school 1300690 618   Butts County 130069002353 100 Henderson Middle School   Regular School No Middle 06 08 2020 spring grade_8 156 91 11 1   2       0 12   123 150                       273 156 91 11 1   2       0 12   123 150                 273
311820 GA     school 1300690 618   Butts County 130069002353 100 Henderson Middle School   Regular School No Middle 06 08 2020 spring pk_12_total 444 284 33 1   4       0 47   391 422                       813 444 284 33 1   4       0 47   391 422                 813
311847 GA     school 1300780 620   Camden County 130078002355 100 Mamie Lou Gross Elementary School   Regular School No Elementary PK 05 2020 spring grade_1 38 21 7 0   1       0 7   34 40                       74 38 21 7 0   1       0 7   34 40                 74
311859 GA     school 1300780 620   Camden County 130078002355 100 Mamie Lou Gross Elementary School   Regular School No Elementary PK 05 2020 spring grade_2 39 26 7 0   1       0 6   39 40                       79 39 26 7 0   1       0 6   39 40                 79
311868 GA     school 1300780 620   Camden County 130078002355 100 Mamie Lou Gross Elementary School   Regular School No Elementary PK 05 2020 spring grade_3 48 31 6 0   0       0 5   58 32                       90 48 31 6 0   0       0 5   58 32                 90
311877 GA     school 1300780 620   Camden County 130078002355 100 Mamie Lou Gross Elementary School   Regular School No Elementary PK 05 2020 spring grade_4 38 20 1 0   1       0 7   42 25                       67 38 20 1 0   1       0 7   42 25                 67
311886 GA     school 1300780 620   Camden County 130078002355 100 Mamie Lou Gross Elementary School   Regular School No Elementary PK 05 2020 spring grade_5 47 31 6 0   0       0 8   55 37                       92 47 31 6 0   0       0 8   55 37                 92
311902 GA     school 1300780 620   Camden County 130078002355 100 Mamie Lou Gross Elementary School   Regular School No Elementary PK 05 2020 spring kindergarten 52 22 6 0   0       0 15   55 40                       95 52 22 6 0   0       0 15   55 40                 95
311913 GA     school 1300780 620   Camden County 130078002355 100 Mamie Lou Gross Elementary School   Regular School No Elementary PK 05 2020 spring pk_12_total 280 157 38 0   3       0 49   297 230                       527 280 157 38 0   3       0 49   297 230                 527
311923 GA     school 1300780 620   Camden County 130078002355 100 Mamie Lou Gross Elementary School   Regular School No Elementary PK 05 2020 spring pre_kindergarten 18 6 5 0   0       0 1   14 16                       30 18 6 5 0   0       0 1   14 16                 30
311959 GA     school 1300840 622   Carroll County 130084002299 100 Sharp Creek Elementary School   Regular School No Elementary PK 05 2020 spring grade_1 45 19 14 1   0       1 7   43 44                       87 45 19 14 1   0       1 7   43 44                 87
311988 GA     school 1300840 622   Carroll County 130084002299 100 Sharp Creek Elementary School   Regular School No Elementary PK 05 2020 spring grade_2 44 25 11 0   0       0 6   39 47                       86 44 25 11 0   0       0 6   39 47                 86
312000 GA     school 1300840 622   Carroll County 130084002299 100 Sharp Creek Elementary School   Regular School No Elementary PK 05 2020 spring grade_3 61 18 9 0   0       0 5   48 45                       93 61 18 9 0   0       0 5   48 45                 93
312012 GA     school 1300840 622   Carroll County 130084002299 100 Sharp Creek Elementary School   Regular School No Elementary PK 05 2020 spring grade_4 44 22 10 0   0       0 6   46 36                       82 44 22 10 0   0       0 6   46 36                 82
312024 GA     school 1300840 622   Carroll County 130084002299 100 Sharp Creek Elementary School   Regular School No Elementary PK 05 2020 spring grade_5 50 24 16 1   0       0 7   48 50                       98 50 24 16 1   0       0 7   48 50                 98
312063 GA     school 1300840 622   Carroll County 130084002299 100 Sharp Creek Elementary School   Regular School No Elementary PK 05 2020 spring kindergarten 44 14 11 0   0       0 9   46 32                       78 44 14 11 0   0       0 9   46 32                 78
312083 GA     school 1300840 622   Carroll County 130084002299 100 Sharp Creek Elementary School   Regular School No Elementary PK 05 2020 spring pk_12_total 319 136 78 2   0       1 43   304 275                       579 319 136 78 2   0       1 43   304 275                 579
312099 GA     school 1300840 622   Carroll County 130084002299 100 Sharp Creek Elementary School   Regular School No Elementary PK 05 2020 spring pre_kindergarten 31 14 7 0   0       0 3   34 21                       55 31 14 7 0   0       0 3   34 21                 55
312107 GA     school 1300930 623   Catoosa County 130093002300 100 Ringgold Primary School   Regular School No Elementary PK 02 2020 spring grade_1 148 2 3 0   1       0 8   85 77                       162 148 2 3 0   1       0 8   85 77                 162
312124 GA     school 1300930 623   Catoosa County 130093002300 100 Ringgold Primary School   Regular School No Elementary PK 02 2020 spring grade_2 127 3 1 0   4       0 11   76 70                       146 127 3 1 0   4       0 11   76 70                 146
312168 GA     school 1300930 623   Catoosa County 130093002300 100 Ringgold Primary School   Regular School No Elementary PK 02 2020 spring kindergarten 137 4 9 0   2       0 10   88 74                       162 137 4 9 0   2       0 10   88 74                 162
312184 GA     school 1300930 623   Catoosa County 130093002300 100 Ringgold Primary School   Regular School No Elementary PK 02 2020 spring pk_12_total 500 10 15 0   7       0 35   300 267                       567 500 10 15 0   7       0 35   300 267                 567
312190 GA     school 1300930 623   Catoosa County 130093002300 100 Ringgold Primary School   Regular School No Elementary PK 02 2020 spring pre_kindergarten 88 1 2 0   0       0 6   51 46                       97 88 1 2 0   0       0 6   51 46                 97
313299 GA     school 1301230 631   Clayton County 130123002304 100 M. D. Roberts Middle School   Regular School No Middle 06 08 2020 spring grade_6 6 256 55 0   8       0 11   132 204                       336 6 256 55 0   8       0 11   132 204                 336
313316 GA     school 1301230 631   Clayton County 130123002304 100 M. D. Roberts Middle School   Regular School No Middle 06 08 2020 spring grade_7 9 256 41 0   6       0 12   138 186                       324 9 256 41 0   6       0 12   138 186                 324
313333 GA     school 1301230 631   Clayton County 130123002304 100 M. D. Roberts Middle School   Regular School No Middle 06 08 2020 spring grade_8 4 226 44 1   11       1 10   162 135                       297 4 226 44 1   11       1 10   162 135                 297
313423 GA     school 1301230 631   Clayton County 130123002304 100 M. D. Roberts Middle School   Regular School No Middle 06 08 2020 spring pk_12_total 19 738 140 1   25       1 33   432 525                       957 19 738 140 1   25       1 33   432 525                 957
314219 GA     school 1301350 634   Coffee County 130135002306 100 Indian Creek Elementary   Regular School No Elementary PK 05 2020 spring grade_1 51 16 24 0   2       0 4   53 44                       97 51 16 24 0   2       0 4   53 44                 97
314233 GA     school 1301350 634   Coffee County 130135002306 100 Indian Creek Elementary   Regular School No Elementary PK 05 2020 spring grade_2 76 13 17 0   1       0 4   56 55                       111 76 13 17 0   1       0 4   56 55                 111
314241 GA     school 1301350 634   Coffee County 130135002306 100 Indian Creek Elementary   Regular School No Elementary PK 05 2020 spring grade_3 75 10 23 0   0       0 6   57 57                       114 75 10 23 0   0       0 6   57 57                 114
314249 GA     school 1301350 634   Coffee County 130135002306 100 Indian Creek Elementary   Regular School No Elementary PK 05 2020 spring grade_4 73 14 13 0   1       0 4   53 52                       105 73 14 13 0   1       0 4   53 52                 105
314257 GA     school 1301350 634   Coffee County 130135002306 100 Indian Creek Elementary   Regular School No Elementary PK 05 2020 spring grade_5 57 24 24 0   5       0 3   50 63                       113 57 24 24 0   5       0 3   50 63                 113
314271 GA     school 1301350 634   Coffee County 130135002306 100 Indian Creek Elementary   Regular School No Elementary PK 05 2020 spring kindergarten 68 22 22 0   0       0 6   62 56                       118 68 22 22 0   0       0 6   62 56                 118
314282 GA     school 1301350 634   Coffee County 130135002306 100 Indian Creek Elementary   Regular School No Elementary PK 05 2020 spring pk_12_total 462 130 151 0   9       0 31   394 389                       783 462 130 151 0   9       0 31   394 389                 783
314291 GA     school 1301350 634   Coffee County 130135002306 100 Indian Creek Elementary   Regular School No Elementary PK 05 2020 spring pre_kindergarten 62 31 28 0   0       0 4   63 62                       125 62 31 28 0   0       0 4   63 62                 125
314998 GA     school 1301740 644   DeKalb County 130174002308 100 Narvie Harris Elementary School   Regular School No Elementary PK 05 2020 spring grade_1 0 101 1 0   0       0 1   52 51                       103 0 101 1 0   0       0 1   52 51                 103
315158 GA     school 1301740 644   DeKalb County 130174002308 100 Narvie Harris Elementary School   Regular School No Elementary PK 05 2020 spring grade_2 0 114 4 0   0       0 0   61 57                       118 0 114 4 0   0       0 0   61 57                 118
315239 GA     school 1301740 644   DeKalb County 130174002308 100 Narvie Harris Elementary School   Regular School No Elementary PK 05 2020 spring grade_3 0 110 2 1   1       0 2   60 56                       116 0 110 2 1   1       0 2   60 56                 116
315323 GA     school 1301740 644   DeKalb County 130174002308 100 Narvie Harris Elementary School   Regular School No Elementary PK 05 2020 spring grade_4 1 103 4 0   0       0 0   55 53                       108 1 103 4 0   0       0 0   55 53                 108
315408 GA     school 1301740 644   DeKalb County 130174002308 100 Narvie Harris Elementary School   Regular School No Elementary PK 05 2020 spring grade_5 0 117 2 0   0       0 1   61 59                       120 0 117 2 0   0       0 1   61 59                 120
315612 GA     school 1301740 644   DeKalb County 130174002308 100 Narvie Harris Elementary School   Regular School No Elementary PK 05 2020 spring kindergarten 1 95 2 0   0       0 0   41 57                       98 1 95 2 0   0       0 0   41 57                 98
315725 GA     school 1301740 644   DeKalb County 130174002308 100 Narvie Harris Elementary School   Regular School No Elementary PK 05 2020 spring pk_12_total 2 681 16 1   1       0 4   353 352                       705 2 681 16 1   1       0 4   353 352                 705
315818 GA     school 1301740 644   DeKalb County 130174002308 100 Narvie Harris Elementary School   Regular School No Elementary PK 05 2020 spring pre_kindergarten 0 41 1 0   0       0 0   23 19                       42 0 41 1 0   0       0 0   23 19                 42
316066 GA     school 1301860 648   Douglas County 130186002317 100 Chapel Hill High School   Regular School No High 09 12 2020 spring grade_10 72 240 45 1   6       1 22   202 185                       387 72 240 45 1   6       1 22   202 185                 387
316072 GA     school 1301860 648   Douglas County 130186002317 100 Chapel Hill High School   Regular School No High 09 12 2020 spring grade_11 89 194 39 0   7       0 15   176 168                       344 89 194 39 0   7       0 15   176 168                 344
316078 GA     school 1301860 648   Douglas County 130186002317 100 Chapel Hill High School   Regular School No High 09 12 2020 spring grade_12 63 197 41 0   6       1 11   149 170                       319 63 197 41 0   6       1 11   149 170                 319
316201 GA     school 1301860 648   Douglas County 130186002317 100 Chapel Hill High School   Regular School No High 09 12 2020 spring grade_9 66 205 49 1   3       1 21   177 169                       346 66 205 49 1   3       1 21   177 169                 346
316236 GA     school 1301860 648   Douglas County 130186002317 100 Chapel Hill High School   Regular School No High 09 12 2020 spring pk_12_total 290 836 174 2   22       3 69   704 692                       1396 290 836 174 2   22       3 69   704 692                 1396
316411 GA     school 1302040 653   Emanuel County 130204000908 100 Twin City Elementary School   Regular School No Elementary PK 05 2020 spring grade_1 49 28 5 0   0       0 0   38 44                       82 49 28 5 0   0       0 0   38 44                 82
316419 GA     school 1302040 653   Emanuel County 130204000908 100 Twin City Elementary School   Regular School No Elementary PK 05 2020 spring grade_2 37 20 5 0   1       0 2   36 29                       65 37 20 5 0   1       0 2   36 29                 65
316421 GA     school 1302040 653   Emanuel County 130204000908 100 Twin City Elementary School   Regular School No Elementary PK 05 2020 spring grade_3 48 24 4 0   0       0 2   42 36                       78 48 24 4 0   0       0 2   42 36                 78
316423 GA     school 1302040 653   Emanuel County 130204000908 100 Twin City Elementary School   Regular School No Elementary PK 05 2020 spring grade_4 64 20 6 0   0       0 1   44 47                       91 64 20 6 0   0       0 1   44 47                 91
316425 GA     school 1302040 653   Emanuel County 130204000908 100 Twin City Elementary School   Regular School No Elementary PK 05 2020 spring grade_5 61 33 3 0   0       0 3   53 47                       100 61 33 3 0   0       0 3   53 47                 100
316435 GA     school 1302040 653   Emanuel County 130204000908 100 Twin City Elementary School   Regular School No Elementary PK 05 2020 spring kindergarten 66 21 4 0   0       0 4   54 41                       95 66 21 4 0   0       0 4   54 41                 95
316441 GA     school 1302040 653   Emanuel County 130204000908 100 Twin City Elementary School   Regular School No Elementary PK 05 2020 spring pk_12_total 366 164 31 0   1       0 15   297 280                       577 366 164 31 0   1       0 15   297 280                 577
316443 GA     school 1302040 653   Emanuel County 130204000908 100 Twin City Elementary School   Regular School No Elementary PK 05 2020 spring pre_kindergarten 41 18 4 0   0       0 3   30 36                       66 41 18 4 0   0       0 3   30 36                 66
316768 GA     school 1302220 658   Forsyth County 130222002320 100 Settles Bridge Elementary School   Regular School No Elementary PK 05 2020 spring grade_1 49 10 15 2   73       0 9   88 70                       158 49 10 15 2   73       0 9   88 70                 158
316809 GA     school 1302220 658   Forsyth County 130222002320 100 Settles Bridge Elementary School   Regular School No Elementary PK 05 2020 spring grade_2 47 10 5 1   89       0 6   72 86                       158 47 10 5 1   89       0 6   72 86                 158
316830 GA     school 1302220 658   Forsyth County 130222002320 100 Settles Bridge Elementary School   Regular School No Elementary PK 05 2020 spring grade_3 52 15 10 1   109       0 6   92 101                       193 52 15 10 1   109       0 6   92 101                 193
316851 GA     school 1302220 658   Forsyth County 130222002320 100 Settles Bridge Elementary School   Regular School No Elementary PK 05 2020 spring grade_4 64 9 17 0   105       0 8   97 106                       203 64 9 17 0   105       0 8   97 106                 203
316872 GA     school 1302220 658   Forsyth County 130222002320 100 Settles Bridge Elementary School   Regular School No Elementary PK 05 2020 spring grade_5 57 17 13 2   95       0 6   106 84                       190 57 17 13 2   95       0 6   106 84                 190
316930 GA     school 1302220 658   Forsyth County 130222002320 100 Settles Bridge Elementary School   Regular School No Elementary PK 05 2020 spring kindergarten 35 11 6 1   54       0 3   47 63                       110 35 11 6 1   54       0 3   47 63                 110
316964 GA     school 1302220 658   Forsyth County 130222002320 100 Settles Bridge Elementary School   Regular School No Elementary PK 05 2020 spring pk_12_total 312 72 68 7   528       0 40   513 514                       1027 312 72 68 7   528       0 40   513 514                 1027
316989 GA     school 1302220 658   Forsyth County 130222002320 100 Settles Bridge Elementary School   Regular School No Elementary PK 05 2020 spring pre_kindergarten 8 0 2 0   3       0 2   11 4                       15 8 0 2 0   3       0 2   11 4                 15
317084 GA     school 1302280 660   Fulton County 130228002321 100 Summit Hill Elementary   Regular School No Elementary PK 05 2020 spring grade_1 95 11 5 0   9       0 5   71 54                       125 95 11 5 0   9       0 5   71 54                 125
317209 GA     school 1302280 660   Fulton County 130228002321 100 Summit Hill Elementary   Regular School No Elementary PK 05 2020 spring grade_2 88 7 4 0   7       0 9   54 61                       115 88 7 4 0   7       0 9   54 61                 115
317274 GA     school 1302280 660   Fulton County 130228002321 100 Summit Hill Elementary   Regular School No Elementary PK 05 2020 spring grade_3 91 16 5 0   4       0 4   68 52                       120 91 16 5 0   4       0 4   68 52                 120
317338 GA     school 1302280 660   Fulton County 130228002321 100 Summit Hill Elementary   Regular School No Elementary PK 05 2020 spring grade_4 81 7 10 0   16       0 7   56 65                       121 81 7 10 0   16       0 7   56 65                 121
317404 GA     school 1302280 660   Fulton County 130228002321 100 Summit Hill Elementary   Regular School No Elementary PK 05 2020 spring grade_5 109 7 9 0   8       1 5   67 72                       139 109 7 9 0   8       1 5   67 72                 139
317570 GA     school 1302280 660   Fulton County 130228002321 100 Summit Hill Elementary   Regular School No Elementary PK 05 2020 spring kindergarten 73 4 5 0   0       0 7   45 44                       89 73 4 5 0   0       0 7   45 44                 89
317671 GA     school 1302280 660   Fulton County 130228002321 100 Summit Hill Elementary   Regular School No Elementary PK 05 2020 spring pk_12_total 544 53 39 0   45       1 38   370 350                       720 544 53 39 0   45       1 38   370 350                 720
317736 GA     school 1302280 660   Fulton County 130228002321 100 Summit Hill Elementary   Regular School No Elementary PK 05 2020 spring pre_kindergarten 7 1 1 0   1       0 1   9 2                       11 7 1 1 0   1       0 1   9 2                 11
318121 GA     school 1302550 667   Gwinnett County 130255002322 100 Rock Springs Elementary School   Regular School No Elementary PK 05 2020 spring grade_1 28 43 32 1   25       0 16   73 72                       145 28 43 32 1   25       0 16   73 72                 145
318287 GA     school 1302550 667   Gwinnett County 130255002322 100 Rock Springs Elementary School   Regular School No Elementary PK 05 2020 spring grade_2 23 34 31 1   16       1 7   61 52                       113 23 34 31 1   16       1 7   61 52                 113
318370 GA     school 1302550 667   Gwinnett County 130255002322 100 Rock Springs Elementary School   Regular School No Elementary PK 05 2020 spring grade_3 30 43 39 0   17       0 8   79 58                       137 30 43 39 0   17       0 8   79 58                 137
318454 GA     school 1302550 667   Gwinnett County 130255002322 100 Rock Springs Elementary School   Regular School No Elementary PK 05 2020 spring grade_4 30 37 42 1   13       1 11   56 79                       135 30 37 42 1   13       1 11   56 79                 135
318538 GA     school 1302550 667   Gwinnett County 130255002322 100 Rock Springs Elementary School   Regular School No Elementary PK 05 2020 spring grade_5 28 45 44 1   14       0 7   68 71                       139 28 45 44 1   14       0 7   68 71                 139
318752 GA     school 1302550 667   Gwinnett County 130255002322 100 Rock Springs Elementary School   Regular School No Elementary PK 05 2020 spring kindergarten 27 35 26 1   21       0 13   46 77                       123 27 35 26 1   21       0 13   46 77                 123
318883 GA     school 1302550 667   Gwinnett County 130255002322 100 Rock Springs Elementary School   Regular School No Elementary PK 05 2020 spring pk_12_total 168 243 221 5   107       2 63   394 415                       809 168 243 221 5   107       2 63   394 415                 809
318972 GA     school 1302550 667   Gwinnett County 130255002322 100 Rock Springs Elementary School   Regular School No Elementary PK 05 2020 spring pre_kindergarten 2 6 7 0   1       0 1   11 6                       17 2 6 7 0   1       0 1   11 6                 17
319206 GA     school 1302610 669   Hall County 130261002326 100 C. W. Davis Middle School   Regular School No Middle 06 08 2020 spring grade_6 182 17 62 0   5       0 5   163 108                       271 182 17 62 0   5       0 5   163 108                 271
319214 GA     school 1302610 669   Hall County 130261002326 100 C. W. Davis Middle School   Regular School No Middle 06 08 2020 spring grade_7 130 15 97 0   3       0 15   129 131                       260 130 15 97 0   3       0 15   129 131                 260
319223 GA     school 1302610 669   Hall County 130261002326 100 C. W. Davis Middle School   Regular School No Middle 06 08 2020 spring grade_8 185 22 87 0   3       0 20   162 155                       317 185 22 87 0   3       0 20   162 155                 317
319261 GA     school 1302610 669   Hall County 130261002326 100 C. W. Davis Middle School   Regular School No Middle 06 08 2020 spring pk_12_total 497 54 246 0   11       0 40   454 394                       848 497 54 246 0   11       0 40   454 394                 848
319488 GA     school 1302820 675   Henry County 130282002328 100 Ola Elementary School   Regular School No Elementary PK 05 2020 spring grade_1 88 38 22 0   5       0 4   77 80                       157 88 38 22 0   5       0 4   77 80                 157
319548 GA     school 1302820 675   Henry County 130282002328 100 Ola Elementary School   Regular School No Elementary PK 05 2020 spring grade_2 93 45 11 1   0       1 7   67 91                       158 93 45 11 1   0       1 7   67 91                 158

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