Data source: Big Local News · About: Big Local

204,362 rows where state = "GA" sorted by school_nces_id

View and edit SQL

grade

year

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
12228 GA     school 1300001 741   Troup County 130000100593 191 Gardner-Newman Middle School   Regular School No 2 06 08 2015 fall grade_6 140 146 16 1   9       0 14   163 163                       326 140 146 16 1   9       0 14   163 163                 326
12232 GA     school 1300001 741   Troup County 130000100593 191 Gardner-Newman Middle School   Regular School No 2 06 08 2015 fall grade_7 152 132 14 0   15       0 12   174 151                       325 152 132 14 0   15       0 12   174 151                 325
12236 GA     school 1300001 741   Troup County 130000100593 191 Gardner-Newman Middle School   Regular School No 2 06 08 2015 fall grade_8 142 159 22 1   6       0 14   177 167                       344 142 159 22 1   6       0 14   177 167                 344
12261 GA     school 1300001 741   Troup County 130000100593 191 Gardner-Newman Middle School   Regular School No 2 06 08 2015 fall pk_12_total 434 437 52 2   30       0 40   514 481                       995 434 437 52 2   30       0 40   514 481                 995
930329 GA     school 1300001 741   Troup County 130000100593 191 Gardner-Newman Middle School   Regular School No 2 06 08 2015 spring grade_6 140 142 17 1   9       0 14   160 163                       323 140 142 17 1   9       0 14   160 163                 323
930333 GA     school 1300001 741   Troup County 130000100593 191 Gardner-Newman Middle School   Regular School No 2 06 08 2015 spring grade_7 146 129 15 0   14       0 13   165 152                       317 146 129 15 0   14       0 13   165 152                 317
930337 GA     school 1300001 741   Troup County 130000100593 191 Gardner-Newman Middle School   Regular School No 2 06 08 2015 spring grade_8 148 156 23 1   7       0 14   175 174                       349 148 156 23 1   7       0 14   175 174                 349
930362 GA     school 1300001 741   Troup County 130000100593 191 Gardner-Newman Middle School   Regular School No 2 06 08 2015 spring pk_12_total 434 427 55 2   30       0 41   500 489                       989 434 427 55 2   30       0 41   500 489                 989
1970482 GA     school 1300001 741   Troup County 130000100593 191 Gardner-Newman Middle School   Regular School No 2 06 08 2016 fall grade_6 125 142 16 0   12       1 12   165 143                       308 125 142 16 0   12       1 12   165 143                 308
1970486 GA     school 1300001 741   Troup County 130000100593 191 Gardner-Newman Middle School   Regular School No 2 06 08 2016 fall grade_7 127 140 18 1   10       0 13   152 157                       309 127 140 18 1   10       0 13   152 157                 309
1970490 GA     school 1300001 741   Troup County 130000100593 191 Gardner-Newman Middle School   Regular School No 2 06 08 2016 fall grade_8 134 136 22 0   13       0 13   169 149                       318 134 136 22 0   13       0 13   169 149                 318
1970514 GA     school 1300001 741   Troup County 130000100593 191 Gardner-Newman Middle School   Regular School No 2 06 08 2016 fall pk_12_total 386 418 56 1   35       1 38   486 449                       935 386 418 56 1   35       1 38   486 449                 935
2258506 GA     school 1300001 741   Troup County 130000100593 191 Gardner-Newman Middle School   Regular School No 2 06 08 2016 spring grade_6 124 142 15 0   10       1 12   162 142                       304 124 142 15 0   10       1 12   162 142                 304
2258510 GA     school 1300001 741   Troup County 130000100593 191 Gardner-Newman Middle School   Regular School No 2 06 08 2016 spring grade_7 127 140 20 1   10       0 12   155 155                       310 127 140 20 1   10       0 12   155 155                 310
2258514 GA     school 1300001 741   Troup County 130000100593 191 Gardner-Newman Middle School   Regular School No 2 06 08 2016 spring grade_8 131 135 21 0   12       0 13   167 145                       312 131 135 21 0   12       0 13   167 145                 312
2258538 GA     school 1300001 741   Troup County 130000100593 191 Gardner-Newman Middle School   Regular School No 2 06 08 2016 spring pk_12_total 382 417 56 1   32       1 37   484 442                       926 382 417 56 1   32       1 37   484 442                 926
308552 GA     school 1300001 741   Troup County 130000100593 191 Gardner-Newman Middle School   Regular School No Middle 06 08 2017 spring grade_6 108 156 37 1   9       1 12   181 143                       324 108 156 37 1   9       1 12   181 143                 324
308556 GA     school 1300001 741   Troup County 130000100593 191 Gardner-Newman Middle School   Regular School No Middle 06 08 2017 spring grade_7 120 136 16 1   9       1 10   149 144                       293 120 136 16 1   9       1 10   149 144                 293
308560 GA     school 1300001 741   Troup County 130000100593 191 Gardner-Newman Middle School   Regular School No Middle 06 08 2017 spring grade_8 120 141 24 1   11       0 13   153 157                       310 120 141 24 1   11       0 13   153 157                 310
308584 GA     school 1300001 741   Troup County 130000100593 191 Gardner-Newman Middle School   Regular School No Middle 06 08 2017 spring pk_12_total 348 433 77 3   29       2 35   483 444                       927 348 433 77 3   29       2 35   483 444                 927
1984944 GA     school 1300001 741   Troup County 130000100593 191 Gardner-Newman Middle School   Regular School No Middle 06 08 2017 fall grade_6 120 156 33 1   8       1 11   183 147                       330 120 156 33 1   8       1 11   183 147                 330
1984948 GA     school 1300001 741   Troup County 130000100593 191 Gardner-Newman Middle School   Regular School No Middle 06 08 2017 fall grade_7 115 135 14 1   9       1 9   144 140                       284 115 135 14 1   9       1 9   144 140                 284
1984952 GA     school 1300001 741   Troup County 130000100593 191 Gardner-Newman Middle School   Regular School No Middle 06 08 2017 fall grade_8 122 141 20 1   10       0 13   152 155                       307 122 141 20 1   10       0 13   152 155                 307
1984976 GA     school 1300001 741   Troup County 130000100593 191 Gardner-Newman Middle School   Regular School No Middle 06 08 2017 fall pk_12_total 357 432 67 3   27       2 33   479 442                       921 357 432 67 3   27       2 33   479 442                 921
733269 GA     school 1300001 741   Troup County 130000100593 191 Gardner-Newman Middle School   Regular School No Middle 06 08 2018 spring grade_6 110 157 27 0   7       0 15   151 165                       316 110 157 27 0   7       0 15   151 165                 316
733273 GA     school 1300001 741   Troup County 130000100593 191 Gardner-Newman Middle School   Regular School No Middle 06 08 2018 spring grade_7 101 151 39 1   5       1 11   161 148                       309 101 151 39 1   5       1 11   161 148                 309
733277 GA     school 1300001 741   Troup County 130000100593 191 Gardner-Newman Middle School   Regular School No Middle 06 08 2018 spring grade_8 120 127 18 1   8       2 11   145 142                       287 120 127 18 1   8       2 11   145 142                 287
733301 GA     school 1300001 741   Troup County 130000100593 191 Gardner-Newman Middle School   Regular School No Middle 06 08 2018 spring pk_12_total 331 435 84 2   20       3 37   457 455                       912 331 435 84 2   20       3 37   457 455                 912
1259042 GA     school 1300001 741   Troup County 130000100593 191 Gardner-Newman Middle School   Regular School No Middle 06 08 2018 fall grade_6 111 156 27 0   7       1 14   154 162                       316 111 156 27 0   7       1 14   154 162                 316
1259046 GA     school 1300001 741   Troup County 130000100593 191 Gardner-Newman Middle School   Regular School No Middle 06 08 2018 fall grade_7 102 150 37 1   7       1 13   165 146                       311 102 150 37 1   7       1 13   165 146                 311
1259050 GA     school 1300001 741   Troup County 130000100593 191 Gardner-Newman Middle School   Regular School No Middle 06 08 2018 fall grade_8 120 129 18 1   8       1 12   147 142                       289 120 129 18 1   8       1 12   147 142                 289
1259074 GA     school 1300001 741   Troup County 130000100593 191 Gardner-Newman Middle School   Regular School No Middle 06 08 2018 fall pk_12_total 333 435 82 2   22       3 39   466 450                       916 333 435 82 2   22       3 39   466 450                 916
1273713 GA     school 1300001 741   Troup County 130000100593 191 Gardner-Newman Middle School   Regular School No Middle 06 08 2019 fall grade_6 136 149 40 1   12       1 12   182 169                       351 136 149 40 1   12       1 12   182 169                 351
1273717 GA     school 1300001 741   Troup County 130000100593 191 Gardner-Newman Middle School   Regular School No Middle 06 08 2019 fall grade_7 101 164 22 0   7       0 14   153 155                       308 101 164 22 0   7       0 14   153 155                 308
1273721 GA     school 1300001 741   Troup County 130000100593 191 Gardner-Newman Middle School   Regular School No Middle 06 08 2019 fall grade_8 110 158 38 1   5       1 13   165 161                       326 110 158 38 1   5       1 13   165 161                 326
1273746 GA     school 1300001 741   Troup County 130000100593 191 Gardner-Newman Middle School   Regular School No Middle 06 08 2019 fall pk_12_total 347 471 100 2   24       2 39   500 485                       985 347 471 100 2   24       2 39   500 485                 985
2567904 GA     school 1300001 741   Troup County 130000100593 191 Gardner-Newman Middle School   Regular School No Middle 06 08 2019 spring grade_6 137 150 43 1   14       1 15   184 177                       361 137 150 43 1   14       1 15   184 177                 361
2567908 GA     school 1300001 741   Troup County 130000100593 191 Gardner-Newman Middle School   Regular School No Middle 06 08 2019 spring grade_7 98 165 20 0   6       0 15   151 153                       304 98 165 20 0   6       0 15   151 153                 304
2567912 GA     school 1300001 741   Troup County 130000100593 191 Gardner-Newman Middle School   Regular School No Middle 06 08 2019 spring grade_8 112 157 37 1   5       1 16   162 167                       329 112 157 37 1   5       1 16   162 167                 329
2567937 GA     school 1300001 741   Troup County 130000100593 191 Gardner-Newman Middle School   Regular School No Middle 06 08 2019 spring pk_12_total 347 472 100 2   25       2 46   497 497                       994 347 472 100 2   25       2 46   497 497                 994
323107 GA     school 1300001 741   Troup County 130000100593 191 Gardner-Newman Middle School   Regular School No Middle 06 08 2020 spring grade_6 119 148 39 0   6       1 14   163 164                       327 119 148 39 0   6       1 14   163 164                 327
323112 GA     school 1300001 741   Troup County 130000100593 191 Gardner-Newman Middle School   Regular School No Middle 06 08 2020 spring grade_7 135 145 44 1   10       1 14   179 171                       350 135 145 44 1   10       1 14   179 171                 350
323117 GA     school 1300001 741   Troup County 130000100593 191 Gardner-Newman Middle School   Regular School No Middle 06 08 2020 spring grade_8 95 155 18 1   4       0 15   151 137                       288 95 155 18 1   4       0 15   151 137                 288
323144 GA     school 1300001 741   Troup County 130000100593 191 Gardner-Newman Middle School   Regular School No Middle 06 08 2020 spring pk_12_total 349 448 101 2   20       2 43   493 472                       965 349 448 101 2   20       2 43   493 472                 965
429760 GA     school 1300001 741   Troup County 130000100593 191 Gardner-Newman Middle School   Regular School No Middle 06 08 2020 fall grade_6 113 150 38 1   6       1 14   164 159                       323 113 150 38 1   6       1 14   164 159                 323
429765 GA     school 1300001 741   Troup County 130000100593 191 Gardner-Newman Middle School   Regular School No Middle 06 08 2020 fall grade_7 137 156 46 1   11       1 14   189 177                       366 137 156 46 1   11       1 14   189 177                 366
429770 GA     school 1300001 741   Troup County 130000100593 191 Gardner-Newman Middle School   Regular School No Middle 06 08 2020 fall grade_8 97 169 18 1   5       0 14   157 147                       304 97 169 18 1   5       0 14   157 147                 304
429797 GA     school 1300001 741   Troup County 130000100593 191 Gardner-Newman Middle School   Regular School No Middle 06 08 2020 fall pk_12_total 347 475 102 3   22       2 42   510 483                       993 347 475 102 3   22       2 42   510 483                 993
415037 GA     school 1300001 741   Troup County 130000100593 191 Gardner-Newman Middle School   Regular School No Middle 06 08 2021 fall grade_6 107 167 33 1   12       0 13   157 176                       333 107 167 33 1   12       0 13   157 176                 333
415041 GA     school 1300001 741   Troup County 130000100593 191 Gardner-Newman Middle School   Regular School No Middle 06 08 2021 fall grade_7 116 153 39 0   6       1 16   161 170                       331 116 153 39 0   6       1 16   161 170                 331
415046 GA     school 1300001 741   Troup County 130000100593 191 Gardner-Newman Middle School   Regular School No Middle 06 08 2021 fall grade_8 138 142 43 1   11       1 15   176 175                       351 138 142 43 1   11       1 15   176 175                 351
415073 GA     school 1300001 741   Troup County 130000100593 191 Gardner-Newman Middle School   Regular School No Middle 06 08 2021 fall pk_12_total 361 462 115 2   29       2 44   494 521                       1015 361 462 115 2   29       2 44   494 521                 1015
2272957 GA     school 1300001 741   Troup County 130000100593 191 Gardner-Newman Middle School   Regular School No Middle 06 08 2021 spring grade_6 107 166 33 0   12       0 14   158 174                       332 107 166 33 0   12       0 14   158 174                 332
2272962 GA     school 1300001 741   Troup County 130000100593 191 Gardner-Newman Middle School   Regular School No Middle 06 08 2021 spring grade_7 118 150 38 0   5       1 18   160 170                       330 118 150 38 0   5       1 18   160 170                 330
2272967 GA     school 1300001 741   Troup County 130000100593 191 Gardner-Newman Middle School   Regular School No Middle 06 08 2021 spring grade_8 135 139 44 2   11       1 17   172 177                       349 135 139 44 2   11       1 17   172 177                 349
2272994 GA     school 1300001 741   Troup County 130000100593 191 Gardner-Newman Middle School   Regular School No Middle 06 08 2021 spring pk_12_total 360 455 115 2   28       2 49   490 521                       1011 360 455 115 2   28       2 49   490 521                 1011
12161 GA     school 1300001 741   Troup County 130000100596 194 Hollis Hand Elementary School   Regular School No 1 PK 05 2015 fall grade_1 64 24 15 1   1       0 0   57 48                       105 64 24 15 1   1       0 0   57 48                 105
12184 GA     school 1300001 741   Troup County 130000100596 194 Hollis Hand Elementary School   Regular School No 1 PK 05 2015 fall grade_2 52 18 18 1   5       0 3   50 47                       97 52 18 18 1   5       0 3   50 47                 97
12196 GA     school 1300001 741   Troup County 130000100596 194 Hollis Hand Elementary School   Regular School No 1 PK 05 2015 fall grade_3 53 19 7 1   4       0 4   51 37                       88 53 19 7 1   4       0 4   51 37                 88
12208 GA     school 1300001 741   Troup County 130000100596 194 Hollis Hand Elementary School   Regular School No 1 PK 05 2015 fall grade_4 55 23 11 0   3       1 5   62 36                       98 55 23 11 0   3       1 5   62 36                 98
12220 GA     school 1300001 741   Troup County 130000100596 194 Hollis Hand Elementary School   Regular School No 1 PK 05 2015 fall grade_5 47 11 1 0   1       0 4   35 29                       64 47 11 1 0   1       0 4   35 29                 64
12248 GA     school 1300001 741   Troup County 130000100596 194 Hollis Hand Elementary School   Regular School No 1 PK 05 2015 fall kindergarten 61 26 9 0   0       0 3   49 50                       99 61 26 9 0   0       0 3   49 50                 99
12264 GA     school 1300001 741   Troup County 130000100596 194 Hollis Hand Elementary School   Regular School No 1 PK 05 2015 fall pk_12_total 352 132 65 3   15       1 19   323 264                       587 352 132 65 3   15       1 19   323 264                 587
12279 GA     school 1300001 741   Troup County 130000100596 194 Hollis Hand Elementary School   Regular School No 1 PK 05 2015 fall pre_kindergarten 20 11 4 0   1       0 0   19 17                       36 20 11 4 0   1       0 0   19 17                 36
930262 GA     school 1300001 741   Troup County 130000100596 194 Hollis Hand Elementary School   Regular School No 1 PK 05 2015 spring grade_1 62 21 16 1   1       0 1   53 49                       102 62 21 16 1   1       0 1   53 49                 102
930285 GA     school 1300001 741   Troup County 130000100596 194 Hollis Hand Elementary School   Regular School No 1 PK 05 2015 spring grade_2 51 20 19 1   5       0 4   50 50                       100 51 20 19 1   5       0 4   50 50                 100
930297 GA     school 1300001 741   Troup County 130000100596 194 Hollis Hand Elementary School   Regular School No 1 PK 05 2015 spring grade_3 53 19 7 1   4       0 4   51 37                       88 53 19 7 1   4       0 4   51 37                 88
930309 GA     school 1300001 741   Troup County 130000100596 194 Hollis Hand Elementary School   Regular School No 1 PK 05 2015 spring grade_4 56 25 11 0   3       1 5   60 41                       101 56 25 11 0   3       1 5   60 41                 101
930321 GA     school 1300001 741   Troup County 130000100596 194 Hollis Hand Elementary School   Regular School No 1 PK 05 2015 spring grade_5 50 12 2 0   1       0 4   37 32                       69 50 12 2 0   1       0 4   37 32                 69
930349 GA     school 1300001 741   Troup County 130000100596 194 Hollis Hand Elementary School   Regular School No 1 PK 05 2015 spring kindergarten 58 28 9 0   0       0 4   48 51                       99 58 28 9 0   0       0 4   48 51                 99
930365 GA     school 1300001 741   Troup County 130000100596 194 Hollis Hand Elementary School   Regular School No 1 PK 05 2015 spring pk_12_total 352 140 68 3   15       1 22   324 277                       601 352 140 68 3   15       1 22   324 277                 601
930380 GA     school 1300001 741   Troup County 130000100596 194 Hollis Hand Elementary School   Regular School No 1 PK 05 2015 spring pre_kindergarten 22 15 4 0   1       0 0   25 17                       42 22 15 4 0   1       0 0   25 17                 42
1970420 GA     school 1300001 741   Troup County 130000100596 194 Hollis Hand Elementary School   Regular School No 1 PK 05 2016 fall grade_1 57 15 8 0   1       0 4   44 41                       85 57 15 8 0   1       0 4   44 41                 85
1970443 GA     school 1300001 741   Troup County 130000100596 194 Hollis Hand Elementary School   Regular School No 1 PK 05 2016 fall grade_2 64 15 11 0   1       0 0   49 42                       91 64 15 11 0   1       0 0   49 42                 91
1970454 GA     school 1300001 741   Troup County 130000100596 194 Hollis Hand Elementary School   Regular School No 1 PK 05 2016 fall grade_3 57 19 19 1   5       0 4   56 49                       105 57 19 19 1   5       0 4   56 49                 105
1970465 GA     school 1300001 741   Troup County 130000100596 194 Hollis Hand Elementary School   Regular School No 1 PK 05 2016 fall grade_4 57 17 7 1   3       0 3   52 36                       88 57 17 7 1   3       0 3   52 36                 88
1970476 GA     school 1300001 741   Troup County 130000100596 194 Hollis Hand Elementary School   Regular School No 1 PK 05 2016 fall grade_5 56 26 12 1   3       1 3   64 38                       102 56 26 12 1   3       1 3   64 38                 102
1970502 GA     school 1300001 741   Troup County 130000100596 194 Hollis Hand Elementary School   Regular School No 1 PK 05 2016 fall kindergarten 59 25 9 0   2       0 2   50 47                       97 59 25 9 0   2       0 2   50 47                 97
1970517 GA     school 1300001 741   Troup County 130000100596 194 Hollis Hand Elementary School   Regular School No 1 PK 05 2016 fall pk_12_total 373 127 69 3   17       1 16   337 269                       606 373 127 69 3   17       1 16   337 269                 606
1970531 GA     school 1300001 741   Troup County 130000100596 194 Hollis Hand Elementary School   Regular School No 1 PK 05 2016 fall pre_kindergarten 23 10 3 0   2       0 0   22 16                       38 23 10 3 0   2       0 0   22 16                 38
2258444 GA     school 1300001 741   Troup County 130000100596 194 Hollis Hand Elementary School   Regular School No 1 PK 05 2016 spring grade_1 56 15 8 0   1       0 4   43 41                       84 56 15 8 0   1       0 4   43 41                 84
2258467 GA     school 1300001 741   Troup County 130000100596 194 Hollis Hand Elementary School   Regular School No 1 PK 05 2016 spring grade_2 61 16 10 0   1       0 0   47 41                       88 61 16 10 0   1       0 0   47 41                 88
2258478 GA     school 1300001 741   Troup County 130000100596 194 Hollis Hand Elementary School   Regular School No 1 PK 05 2016 spring grade_3 59 17 19 1   4       0 4   56 48                       104 59 17 19 1   4       0 4   56 48                 104
2258489 GA     school 1300001 741   Troup County 130000100596 194 Hollis Hand Elementary School   Regular School No 1 PK 05 2016 spring grade_4 55 18 7 1   3       0 2   52 34                       86 55 18 7 1   3       0 2   52 34                 86
2258500 GA     school 1300001 741   Troup County 130000100596 194 Hollis Hand Elementary School   Regular School No 1 PK 05 2016 spring grade_5 54 23 12 1   3       0 2   58 37                       95 54 23 12 1   3       0 2   58 37                 95
2258526 GA     school 1300001 741   Troup County 130000100596 194 Hollis Hand Elementary School   Regular School No 1 PK 05 2016 spring kindergarten 58 23 11 0   2       0 2   48 48                       96 58 23 11 0   2       0 2   48 48                 96
2258541 GA     school 1300001 741   Troup County 130000100596 194 Hollis Hand Elementary School   Regular School No 1 PK 05 2016 spring pk_12_total 365 121 70 3   16       0 14   326 263                       589 365 121 70 3   16       0 14   326 263                 589
2258555 GA     school 1300001 741   Troup County 130000100596 194 Hollis Hand Elementary School   Regular School No 1 PK 05 2016 spring pre_kindergarten 22 9 3 0   2       0 0   22 14                       36 22 9 3 0   2       0 0   22 14                 36
308490 GA     school 1300001 741   Troup County 130000100596 194 Hollis Hand Elementary School   Regular School No Elementary PK 05 2017 spring grade_1 60 26 6 0   3       0 1   48 48                       96 60 26 6 0   3       0 1   48 48                 96
308511 GA     school 1300001 741   Troup County 130000100596 194 Hollis Hand Elementary School   Regular School No Elementary PK 05 2017 spring grade_2 56 14 7 0   2       0 5   44 40                       84 56 14 7 0   2       0 5   44 40                 84
308522 GA     school 1300001 741   Troup County 130000100596 194 Hollis Hand Elementary School   Regular School No Elementary PK 05 2017 spring grade_3 62 20 10 0   2       0 0   53 41                       94 62 20 10 0   2       0 0   53 41                 94
308533 GA     school 1300001 741   Troup County 130000100596 194 Hollis Hand Elementary School   Regular School No Elementary PK 05 2017 spring grade_4 64 22 20 1   6       0 3   61 55                       116 64 22 20 1   6       0 3   61 55                 116
308545 GA     school 1300001 741   Troup County 130000100596 194 Hollis Hand Elementary School   Regular School No Elementary PK 05 2017 spring grade_5 61 21 8 0   3       0 2   52 43                       95 61 21 8 0   3       0 2   52 43                 95
308572 GA     school 1300001 741   Troup County 130000100596 194 Hollis Hand Elementary School   Regular School No Elementary PK 05 2017 spring kindergarten 57 18 10 0   2       0 2   52 37                       89 57 18 10 0   2       0 2   52 37                 89
308587 GA     school 1300001 741   Troup County 130000100596 194 Hollis Hand Elementary School   Regular School No Elementary PK 05 2017 spring pk_12_total 374 127 67 1   19       0 13   327 274                       601 374 127 67 1   19       0 13   327 274                 601
308601 GA     school 1300001 741   Troup County 130000100596 194 Hollis Hand Elementary School   Regular School No Elementary PK 05 2017 spring pre_kindergarten 14 6 6 0   1       0 0   17 10                       27 14 6 6 0   1       0 0   17 10                 27
1984881 GA     school 1300001 741   Troup County 130000100596 194 Hollis Hand Elementary School   Regular School No Elementary PK 05 2017 fall grade_1 58 24 9 0   3       0 2   48 48                       96 58 24 9 0   3       0 2   48 48                 96
1984904 GA     school 1300001 741   Troup County 130000100596 194 Hollis Hand Elementary School   Regular School No Elementary PK 05 2017 fall grade_2 55 15 6 0   1       0 5   40 42                       82 55 15 6 0   1       0 5   40 42                 82
1984915 GA     school 1300001 741   Troup County 130000100596 194 Hollis Hand Elementary School   Regular School No Elementary PK 05 2017 fall grade_3 63 19 10 0   2       0 1   52 43                       95 63 19 10 0   2       0 1   52 43                 95
1984926 GA     school 1300001 741   Troup County 130000100596 194 Hollis Hand Elementary School   Regular School No Elementary PK 05 2017 fall grade_4 64 21 20 1   6       0 4   62 54                       116 64 21 20 1   6       0 4   62 54                 116

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