Data source: Big Local News · About: Big Local

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

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
296435 GA     school 1300210 605   Baldwin County 130021002347 100 Oak Hill MS   Regular School No Middle 06 08 2017 spring grade_6 96 265 10 0   8       0 11   189 201                       390 96 265 10 0   8       0 11   189 201                 390
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
296437 GA     school 1300210 605   Baldwin County 130021002347 100 Oak Hill MS   Regular School No Middle 06 08 2017 spring grade_8 90 232 8 0   3       0 8   170 171                       341 90 232 8 0   3       0 8   170 171                 341
296448 GA     school 1300210 605   Baldwin County 130021002347 100 Oak Hill MS   Regular School No Middle 06 08 2017 spring pk_12_total 272 762 25 0   15       0 31   554 551                       1105 272 762 25 0   15       0 31   554 551                 1105
297113 GA     school 1300630 616   Bulloch County 130063002296 100 Mill Creek Elementary School   Regular School No Elementary PK 05 2017 spring grade_1 41 47 6 0   5       0 8   49 58                       107 41 47 6 0   5       0 8   49 58                 107
297131 GA     school 1300630 616   Bulloch County 130063002296 100 Mill Creek Elementary School   Regular School No Elementary PK 05 2017 spring grade_2 29 67 5 1   6       0 6   56 58                       114 29 67 5 1   6       0 6   56 58                 114
297140 GA     school 1300630 616   Bulloch County 130063002296 100 Mill Creek Elementary School   Regular School No Elementary PK 05 2017 spring grade_3 36 66 7 0   2       0 5   54 62                       116 36 66 7 0   2       0 5   54 62                 116
297149 GA     school 1300630 616   Bulloch County 130063002296 100 Mill Creek Elementary School   Regular School No Elementary PK 05 2017 spring grade_4 26 65 2 0   1       1 5   55 45                       100 26 65 2 0   1       1 5   55 45                 100
297158 GA     school 1300630 616   Bulloch County 130063002296 100 Mill Creek Elementary School   Regular School No Elementary PK 05 2017 spring grade_5 26 69 4 0   6       0 4   53 56                       109 26 69 4 0   6       0 4   53 56                 109
297182 GA     school 1300630 616   Bulloch County 130063002296 100 Mill Creek Elementary School   Regular School No Elementary PK 05 2017 spring kindergarten 38 82 5 0   3       0 5   60 73                       133 38 82 5 0   3       0 5   60 73                 133
297192 GA     school 1300630 616   Bulloch County 130063002296 100 Mill Creek Elementary School   Regular School No Elementary PK 05 2017 spring pk_12_total 206 424 30 1   25       1 35   344 378                       722 206 424 30 1   25       1 35   344 378                 722
297206 GA     school 1300630 616   Bulloch County 130063002296 100 Mill Creek Elementary School   Regular School No Elementary PK 05 2017 spring pre_kindergarten 10 28 1 0   2       0 2   17 26                       43 10 28 1 0   2       0 2   17 26                 43
297258 GA     school 1300690 618   Butts County 130069002353 100 Henderson Middle School   Regular School No Middle 06 08 2017 spring grade_6 154 88 12 0   1       0 11   133 133                       266 154 88 12 0   1       0 11   133 133                 266
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
297260 GA     school 1300690 618   Butts County 130069002353 100 Henderson Middle School   Regular School No Middle 06 08 2017 spring grade_8 171 78 8 0   0       0 9   133 133                       266 171 78 8 0   0       0 9   133 133                 266
297266 GA     school 1300690 618   Butts County 130069002353 100 Henderson Middle School   Regular School No Middle 06 08 2017 spring pk_12_total 482 249 26 0   2       0 23   391 391                       782 482 249 26 0   2       0 23   391 391                 782
297293 GA     school 1300780 620   Camden County 130078002355 100 Mamie Lou Gross Elementary School   Regular School No Elementary PK 05 2017 spring grade_1 46 14 1 0   0       0 6   33 34                       67 46 14 1 0   0       0 6   33 34                 67
297305 GA     school 1300780 620   Camden County 130078002355 100 Mamie Lou Gross Elementary School   Regular School No Elementary PK 05 2017 spring grade_2 54 30 3 0   0       0 9   49 47                       96 54 30 3 0   0       0 9   49 47                 96
297314 GA     school 1300780 620   Camden County 130078002355 100 Mamie Lou Gross Elementary School   Regular School No Elementary PK 05 2017 spring grade_3 40 34 3 1   0       0 7   47 38                       85 40 34 3 1   0       0 7   47 38                 85
297323 GA     school 1300780 620   Camden County 130078002355 100 Mamie Lou Gross Elementary School   Regular School No Elementary PK 05 2017 spring grade_4 59 28 4 0   0       0 9   46 54                       100 59 28 4 0   0       0 9   46 54                 100
297332 GA     school 1300780 620   Camden County 130078002355 100 Mamie Lou Gross Elementary School   Regular School No Elementary PK 05 2017 spring grade_5 38 18 5 0   0       0 6   32 35                       67 38 18 5 0   0       0 6   32 35                 67
297348 GA     school 1300780 620   Camden County 130078002355 100 Mamie Lou Gross Elementary School   Regular School No Elementary PK 05 2017 spring kindergarten 47 28 4 0   0       0 11   54 36                       90 47 28 4 0   0       0 11   54 36                 90
297359 GA     school 1300780 620   Camden County 130078002355 100 Mamie Lou Gross Elementary School   Regular School No Elementary PK 05 2017 spring pk_12_total 300 161 22 1   0       0 51   281 254                       535 300 161 22 1   0       0 51   281 254                 535
297369 GA     school 1300780 620   Camden County 130078002355 100 Mamie Lou Gross Elementary School   Regular School No Elementary PK 05 2017 spring pre_kindergarten 16 9 2 0   0       0 3   20 10                       30 16 9 2 0   0       0 3   20 10                 30
297401 GA     school 1300840 622   Carroll County 130084002299 100 Sharp Creek Elementary School   Regular School No Elementary PK 05 2017 spring grade_1 55 23 9 1   0       0 7   44 51                       95 55 23 9 1   0       0 7   44 51                 95
297431 GA     school 1300840 622   Carroll County 130084002299 100 Sharp Creek Elementary School   Regular School No Elementary PK 05 2017 spring grade_2 53 21 11 1   0       0 8   49 45                       94 53 21 11 1   0       0 8   49 45                 94
297443 GA     school 1300840 622   Carroll County 130084002299 100 Sharp Creek Elementary School   Regular School No Elementary PK 05 2017 spring grade_3 55 22 16 1   0       0 8   42 60                       102 55 22 16 1   0       0 8   42 60                 102
297455 GA     school 1300840 622   Carroll County 130084002299 100 Sharp Creek Elementary School   Regular School No Elementary PK 05 2017 spring grade_4 54 18 14 1   0       0 5   57 35                       92 54 18 14 1   0       0 5   57 35                 92
297467 GA     school 1300840 622   Carroll County 130084002299 100 Sharp Creek Elementary School   Regular School No Elementary PK 05 2017 spring grade_5 47 18 15 2   0       0 5   49 38                       87 47 18 15 2   0       0 5   49 38                 87
297506 GA     school 1300840 622   Carroll County 130084002299 100 Sharp Creek Elementary School   Regular School No Elementary PK 05 2017 spring kindergarten 53 8 12 0   0       0 4   39 38                       77 53 8 12 0   0       0 4   39 38                 77
297526 GA     school 1300840 622   Carroll County 130084002299 100 Sharp Creek Elementary School   Regular School No Elementary PK 05 2017 spring pk_12_total 342 119 85 6   0       0 40   303 289                       592 342 119 85 6   0       0 40   303 289                 592
297542 GA     school 1300840 622   Carroll County 130084002299 100 Sharp Creek Elementary School   Regular School No Elementary PK 05 2017 spring pre_kindergarten 25 9 8 0   0       0 3   23 22                       45 25 9 8 0   0       0 3   23 22                 45
297550 GA     school 1300930 623   Catoosa County 130093002300 100 Ringgold Primary School   Regular School No Elementary PK 02 2017 spring grade_1 139 6 4 0   1       0 5   76 79                       155 139 6 4 0   1       0 5   76 79                 155
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
297611 GA     school 1300930 623   Catoosa County 130093002300 100 Ringgold Primary School   Regular School No Elementary PK 02 2017 spring kindergarten 145 7 3 0   3       0 6   78 86                       164 145 7 3 0   3       0 6   78 86                 164
297627 GA     school 1300930 623   Catoosa County 130093002300 100 Ringgold Primary School   Regular School No Elementary PK 02 2017 spring pk_12_total 527 14 12 0   9       0 24   302 284                       586 527 14 12 0   9       0 24   302 284                 586
297633 GA     school 1300930 623   Catoosa County 130093002300 100 Ringgold Primary School   Regular School No Elementary PK 02 2017 spring pre_kindergarten 104 1 2 0   2       0 5   68 46                       114 104 1 2 0   2       0 5   68 46                 114
298755 GA     school 1301230 631   Clayton County 130123002304 100 M. D. Roberts Middle School   Regular School No Middle 06 08 2017 spring grade_6 8 254 51 1   16       0 7   158 179                       337 8 254 51 1   16       0 7   158 179                 337
298772 GA     school 1301230 631   Clayton County 130123002304 100 M. D. Roberts Middle School   Regular School No Middle 06 08 2017 spring grade_7 12 232 46 1   20       0 12   124 199                       323 12 232 46 1   20       0 12   124 199                 323
298789 GA     school 1301230 631   Clayton County 130123002304 100 M. D. Roberts Middle School   Regular School No Middle 06 08 2017 spring grade_8 11 224 29 0   15       0 13   129 163                       292 11 224 29 0   15       0 13   129 163                 292
298875 GA     school 1301230 631   Clayton County 130123002304 100 M. D. Roberts Middle School   Regular School No Middle 06 08 2017 spring pk_12_total 31 710 126 2   51       0 32   411 541                       952 31 710 126 2   51       0 32   411 541                 952
299671 GA     school 1301350 634   Coffee County 130135002306 100 Indian Creek Elementary   Regular School No Elementary PK 05 2017 spring grade_1 70 13 18 0   0       0 2   53 50                       103 70 13 18 0   0       0 2   53 50                 103
299686 GA     school 1301350 634   Coffee County 130135002306 100 Indian Creek Elementary   Regular School No Elementary PK 05 2017 spring grade_2 68 26 21 0   4       0 3   60 62                       122 68 26 21 0   4       0 3   60 62                 122
299694 GA     school 1301350 634   Coffee County 130135002306 100 Indian Creek Elementary   Regular School No Elementary PK 05 2017 spring grade_3 86 25 19 0   0       0 2   69 63                       132 86 25 19 0   0       0 2   69 63                 132
299702 GA     school 1301350 634   Coffee County 130135002306 100 Indian Creek Elementary   Regular School No Elementary PK 05 2017 spring grade_4 68 23 14 0   0       0 2   51 56                       107 68 23 14 0   0       0 2   51 56                 107
299710 GA     school 1301350 634   Coffee County 130135002306 100 Indian Creek Elementary   Regular School No Elementary PK 05 2017 spring grade_5 51 15 18 0   1       0 0   46 39                       85 51 15 18 0   1       0 0   46 39                 85
299725 GA     school 1301350 634   Coffee County 130135002306 100 Indian Creek Elementary   Regular School No Elementary PK 05 2017 spring kindergarten 70 12 26 1   0       0 5   54 60                       114 70 12 26 1   0       0 5   54 60                 114
299736 GA     school 1301350 634   Coffee County 130135002306 100 Indian Creek Elementary   Regular School No Elementary PK 05 2017 spring pk_12_total 483 128 135 1   7       0 16   401 369                       770 483 128 135 1   7       0 16   401 369                 770
299745 GA     school 1301350 634   Coffee County 130135002306 100 Indian Creek Elementary   Regular School No Elementary PK 05 2017 spring pre_kindergarten 70 14 19 0   2       0 2   68 39                       107 70 14 19 0   2       0 2   68 39                 107
300467 GA     school 1301740 644   DeKalb County 130174002308 100 Narvie Harris Elementary School   Regular School No Elementary PK 05 2017 spring grade_1 2 119 4 0   0       0 1   60 66                       126 2 119 4 0   0       0 1   60 66                 126
300632 GA     school 1301740 644   DeKalb County 130174002308 100 Narvie Harris Elementary School   Regular School No Elementary PK 05 2017 spring grade_2 0 131 0 0   0       0 1   63 69                       132 0 131 0 0   0       0 1   63 69                 132
300715 GA     school 1301740 644   DeKalb County 130174002308 100 Narvie Harris Elementary School   Regular School No Elementary PK 05 2017 spring grade_3 0 138 1 0   0       0 0   64 75                       139 0 138 1 0   0       0 0   64 75                 139
300799 GA     school 1301740 644   DeKalb County 130174002308 100 Narvie Harris Elementary School   Regular School No Elementary PK 05 2017 spring grade_4 0 135 1 0   0       1 2   67 72                       139 0 135 1 0   0       1 2   67 72                 139
300885 GA     school 1301740 644   DeKalb County 130174002308 100 Narvie Harris Elementary School   Regular School No Elementary PK 05 2017 spring grade_5 0 125 1 0   0       0 2   64 64                       128 0 125 1 0   0       0 2   64 64                 128
301092 GA     school 1301740 644   DeKalb County 130174002308 100 Narvie Harris Elementary School   Regular School No Elementary PK 05 2017 spring kindergarten 0 134 1 0   1       1 2   71 68                       139 0 134 1 0   1       1 2   71 68                 139
301207 GA     school 1301740 644   DeKalb County 130174002308 100 Narvie Harris Elementary School   Regular School No Elementary PK 05 2017 spring pk_12_total 2 823 10 0   1       2 8   413 433                       846 2 823 10 0   1       2 8   413 433                 846
301300 GA     school 1301740 644   DeKalb County 130174002308 100 Narvie Harris Elementary School   Regular School No Elementary PK 05 2017 spring pre_kindergarten 0 41 2 0   0       0 0   24 19                       43 0 41 2 0   0       0 0   24 19                 43
301549 GA     school 1301860 648   Douglas County 130186002317 100 Chapel Hill High School   Regular School No High 09 12 2017 spring grade_10 115 220 36 0   3       0 20   186 208                       394 115 220 36 0   3       0 20   186 208                 394
301555 GA     school 1301860 648   Douglas County 130186002317 100 Chapel Hill High School   Regular School No High 09 12 2017 spring grade_11 101 187 28 0   7       1 16   175 165                       340 101 187 28 0   7       1 16   175 165                 340
301561 GA     school 1301860 648   Douglas County 130186002317 100 Chapel Hill High School   Regular School No High 09 12 2017 spring grade_12 116 155 30 0   2       0 9   145 167                       312 116 155 30 0   2       0 9   145 167                 312
301682 GA     school 1301860 648   Douglas County 130186002317 100 Chapel Hill High School   Regular School No High 09 12 2017 spring grade_9 87 221 47 0   5       1 16   190 187                       377 87 221 47 0   5       1 16   190 187                 377
301717 GA     school 1301860 648   Douglas County 130186002317 100 Chapel Hill High School   Regular School No High 09 12 2017 spring pk_12_total 419 783 141 0   17       2 61   696 727                       1423 419 783 141 0   17       2 61   696 727                 1423
301892 GA     school 1302040 653   Emanuel County 130204000908 100 Twin City Elementary School   Regular School No Elementary PK 05 2017 spring grade_1 62 22 7 0   0       0 1   41 51                       92 62 22 7 0   0       0 1   41 51                 92
301900 GA     school 1302040 653   Emanuel County 130204000908 100 Twin City Elementary School   Regular School No Elementary PK 05 2017 spring grade_2 55 34 1 0   0       0 3   55 38                       93 55 34 1 0   0       0 3   55 38                 93
301902 GA     school 1302040 653   Emanuel County 130204000908 100 Twin City Elementary School   Regular School No Elementary PK 05 2017 spring grade_3 60 22 5 0   1       0 6   46 48                       94 60 22 5 0   1       0 6   46 48                 94
301904 GA     school 1302040 653   Emanuel County 130204000908 100 Twin City Elementary School   Regular School No Elementary PK 05 2017 spring grade_4 63 26 3 0   0       0 2   47 47                       94 63 26 3 0   0       0 2   47 47                 94
301906 GA     school 1302040 653   Emanuel County 130204000908 100 Twin City Elementary School   Regular School No Elementary PK 05 2017 spring grade_5 64 29 0 0   1       0 3   50 47                       97 64 29 0 0   1       0 3   50 47                 97
301916 GA     school 1302040 653   Emanuel County 130204000908 100 Twin City Elementary School   Regular School No Elementary PK 05 2017 spring kindergarten 57 30 8 0   0       0 4   54 45                       99 57 30 8 0   0       0 4   54 45                 99
301922 GA     school 1302040 653   Emanuel County 130204000908 100 Twin City Elementary School   Regular School No Elementary PK 05 2017 spring pk_12_total 392 179 26 0   3       0 22   322 300                       622 392 179 26 0   3       0 22   322 300                 622
301924 GA     school 1302040 653   Emanuel County 130204000908 100 Twin City Elementary School   Regular School No Elementary PK 05 2017 spring pre_kindergarten 31 16 2 0   1       0 3   29 24                       53 31 16 2 0   1       0 3   29 24                 53
302245 GA     school 1302220 658   Forsyth County 130222002320 100 Settles Bridge Elementary School   Regular School No Elementary PK 05 2017 spring grade_1 66 5 13 0   84       0 6   81 93                       174 66 5 13 0   84       0 6   81 93                 174
302284 GA     school 1302220 658   Forsyth County 130222002320 100 Settles Bridge Elementary School   Regular School No Elementary PK 05 2017 spring grade_2 57 15 12 1   68       0 5   90 68                       158 57 15 12 1   68       0 5   90 68                 158
302305 GA     school 1302220 658   Forsyth County 130222002320 100 Settles Bridge Elementary School   Regular School No Elementary PK 05 2017 spring grade_3 85 5 11 1   85       0 10   95 102                       197 85 5 11 1   85       0 10   95 102                 197
302326 GA     school 1302220 658   Forsyth County 130222002320 100 Settles Bridge Elementary School   Regular School No Elementary PK 05 2017 spring grade_4 86 7 17 0   93       0 8   109 102                       211 86 7 17 0   93       0 8   109 102                 211
302347 GA     school 1302220 658   Forsyth County 130222002320 100 Settles Bridge Elementary School   Regular School No Elementary PK 05 2017 spring grade_5 90 4 7 1   98       0 6   109 97                       206 90 4 7 1   98       0 6   109 97                 206
302407 GA     school 1302220 658   Forsyth County 130222002320 100 Settles Bridge Elementary School   Regular School No Elementary PK 05 2017 spring kindergarten 51 13 8 0   72       0 6   68 82                       150 51 13 8 0   72       0 6   68 82                 150
302440 GA     school 1302220 658   Forsyth County 130222002320 100 Settles Bridge Elementary School   Regular School No Elementary PK 05 2017 spring pk_12_total 447 50 69 4   508       0 41   568 551                       1119 447 50 69 4   508       0 41   568 551                 1119
302465 GA     school 1302220 658   Forsyth County 130222002320 100 Settles Bridge Elementary School   Regular School No Elementary PK 05 2017 spring pre_kindergarten 12 1 1 1   8       0 0   16 7                       23 12 1 1 1   8       0 0   16 7                 23
302560 GA     school 1302280 660   Fulton County 130228002321 100 Summit Hill Elementary   Regular School No Elementary PK 05 2017 spring grade_1 72 3 11 0   12       0 4   49 53                       102 72 3 11 0   12       0 4   49 53                 102
302684 GA     school 1302280 660   Fulton County 130228002321 100 Summit Hill Elementary   Regular School No Elementary PK 05 2017 spring grade_2 103 4 11 0   5       1 2   63 63                       126 103 4 11 0   5       1 2   63 63                 126
302747 GA     school 1302280 660   Fulton County 130228002321 100 Summit Hill Elementary   Regular School No Elementary PK 05 2017 spring grade_3 85 9 7 0   6       0 4   56 55                       111 85 9 7 0   6       0 4   56 55                 111
302811 GA     school 1302280 660   Fulton County 130228002321 100 Summit Hill Elementary   Regular School No Elementary PK 05 2017 spring grade_4 87 7 7 0   9       0 2   54 58                       112 87 7 7 0   9       0 2   54 58                 112
302876 GA     school 1302280 660   Fulton County 130228002321 100 Summit Hill Elementary   Regular School No Elementary PK 05 2017 spring grade_5 127 13 13 0   10       1 4   88 80                       168 127 13 13 0   10       1 4   88 80                 168
303039 GA     school 1302280 660   Fulton County 130228002321 100 Summit Hill Elementary   Regular School No Elementary PK 05 2017 spring kindergarten 87 12 7 0   5       0 4   60 55                       115 87 12 7 0   5       0 4   60 55                 115
303140 GA     school 1302280 660   Fulton County 130228002321 100 Summit Hill Elementary   Regular School No Elementary PK 05 2017 spring pk_12_total 571 48 56 0   48       2 20   380 365                       745 571 48 56 0   48       2 20   380 365                 745
303205 GA     school 1302280 660   Fulton County 130228002321 100 Summit Hill Elementary   Regular School No Elementary PK 05 2017 spring pre_kindergarten 10 0 0 0   1       0 0   10 1                       11 10 0 0 0   1       0 0   10 1                 11
303594 GA     school 1302550 667   Gwinnett County 130255002322 100 Rock Springs Elementary School   Regular School No Elementary PK 05 2017 spring grade_1 30 36 32 1   15       1 10   53 72                       125 30 36 32 1   15       1 10   53 72                 125
303754 GA     school 1302550 667   Gwinnett County 130255002322 100 Rock Springs Elementary School   Regular School No Elementary PK 05 2017 spring grade_2 34 38 48 0   16       0 6   66 76                       142 34 38 48 0   16       0 6   66 76                 142
303836 GA     school 1302550 667   Gwinnett County 130255002322 100 Rock Springs Elementary School   Regular School No Elementary PK 05 2017 spring grade_3 40 38 49 0   20       0 13   81 79                       160 40 38 49 0   20       0 13   81 79                 160
303920 GA     school 1302550 667   Gwinnett County 130255002322 100 Rock Springs Elementary School   Regular School No Elementary PK 05 2017 spring grade_4 29 44 43 0   18       0 8   78 64                       142 29 44 43 0   18       0 8   78 64                 142
304004 GA     school 1302550 667   Gwinnett County 130255002322 100 Rock Springs Elementary School   Regular School No Elementary PK 05 2017 spring grade_5 39 44 38 0   13       0 5   68 71                       139 39 44 38 0   13       0 5   68 71                 139
304218 GA     school 1302550 667   Gwinnett County 130255002322 100 Rock Springs Elementary School   Regular School No Elementary PK 05 2017 spring kindergarten 35 44 24 0   9       0 7   66 53                       119 35 44 24 0   9       0 7   66 53                 119
304347 GA     school 1302550 667   Gwinnett County 130255002322 100 Rock Springs Elementary School   Regular School No Elementary PK 05 2017 spring pk_12_total 215 254 237 1   93       1 49   430 420                       850 215 254 237 1   93       1 49   430 420                 850
304436 GA     school 1302550 667   Gwinnett County 130255002322 100 Rock Springs Elementary School   Regular School No Elementary PK 05 2017 spring pre_kindergarten 8 10 3 0   2       0 0   18 5                       23 8 10 3 0   2       0 0   18 5                 23
304661 GA     school 1302610 669   Hall County 130261002326 100 C. W. Davis Middle School   Regular School No Middle 06 08 2017 spring grade_6 266 29 95 2   2       0 12   243 163                       406 266 29 95 2   2       0 12   243 163                 406
304669 GA     school 1302610 669   Hall County 130261002326 100 C. W. Davis Middle School   Regular School No Middle 06 08 2017 spring grade_7 261 27 78 0   10       0 10   199 187                       386 261 27 78 0   10       0 10   199 187                 386
304677 GA     school 1302610 669   Hall County 130261002326 100 C. W. Davis Middle School   Regular School No Middle 06 08 2017 spring grade_8 270 29 76 0   7       0 14   196 200                       396 270 29 76 0   7       0 14   196 200                 396
304712 GA     school 1302610 669   Hall County 130261002326 100 C. W. Davis Middle School   Regular School No Middle 06 08 2017 spring pk_12_total 797 85 249 2   19       0 36   638 550                       1188 797 85 249 2   19       0 36   638 550                 1188
304928 GA     school 1302820 675   Henry County 130282002328 100 Ola Elementary School   Regular School No Elementary PK 05 2017 spring grade_1 99 33 7 1   2       0 4   75 71                       146 99 33 7 1   2       0 4   75 71                 146
304988 GA     school 1302820 675   Henry County 130282002328 100 Ola Elementary School   Regular School No Elementary PK 05 2017 spring grade_2 103 40 5 1   3       0 5   75 82                       157 103 40 5 1   3       0 5   75 82                 157

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