Data source: Big Local News · About: Big Local

2,494 rows where grade = "grade_5", state = "GA" and year = 2017 sorted by ccd_school_low_grade

View and edit SQL

year

  • 2017 · 2,394

grade

  • grade_5 · 2,394
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
1982191 GA     school 1303270 688   Lee County 130327000206 393 Twin Oaks Elementary   Regular School No Elementary 03 05 2017 fall grade_5 183 50 9 0   6       0 19   130 137                       267 183 50 9 0   6       0 19   130 137                 267
1982705 GA     school 1303780 704   Morgan County 130378002141 191 Morgan County Elementary School   Regular School No Elementary 03 05 2017 fall grade_5 136 58 13 0   6       0 8   110 111                       221 136 58 13 0   6       0 8   110 111                 221
1983297 GA     school 1303960 708   Oconee County 130396001464 1050 Oconee County Elementary School   Regular School No Elementary 03 05 2017 fall grade_5 93 12 13 0   6       0 6   65 65                       130 93 12 13 0   6       0 6   65 65                 130
1983331 GA     school 1303990 709   Oglethorpe County 130399002226 198 Oglethorpe County Elementary School   Regular School No Elementary 03 05 2017 fall grade_5 102 29 22 0   4       0 13   96 74                       170 102 29 22 0   4       0 13   96 74                 170
1983679 GA     school 1304170 714   Pike County 130417001042 101 Pike County Elementary School   Regular School No Elementary 03 05 2017 fall grade_5 212 15 7 0   2       2 4   125 117                       242 212 15 7 0   2       2 4   125 117                 242
1983789 GA     school 1304260 717   Putnam County 130426003867 113 Putnam County Elementary School   Regular School No Elementary 03 05 2017 fall grade_5 118 85 36 0   1       0 8   121 127                       248 118 85 36 0   1       0 8   121 127                 248
1983823 GA     school 1304320 719   Rabun County 130432001519 105 Rabun County Elementary School   Regular School No Elementary 03 06 2017 fall grade_5 112 2 28 0   0       0 1   73 70                       143 112 2 28 0   0       0 1   73 70                 143
1984688 GA     school 1304800 733   Taylor County 130480001649 105 Taylor County Upper Elementary   Regular School No Elementary 03 06 2017 fall grade_5 60 35 1 1   3       0 2   56 46                       102 60 35 1 1   3       0 2   56 46                 102
1984827 GA     school 1305040 738   Toombs County 130504002995 204 Lyons Upper Elementary   Regular School No Elementary 03 05 2017 fall grade_5 75 42 46 0   1       0 6   89 81                       170 75 42 46 0   1       0 6   89 81                 170
1985054 GA     school 1305250 744   Union County 130525002605 103 Union County Elementary School   Regular School No Elementary 03 05 2017 fall grade_5 191 0 9 0   0       0 5   108 97                       205 191 0 9 0   0       0 5   108 97                 205
1985374 GA     school 1305490 750   Washington County 130549001789 4050 Ridge Road Elementary School   Regular School No Elementary 03 05 2017 fall grade_5 88 136 3 1   2       0 13   110 133                       243 88 136 3 1   2       0 13   110 133                 243
1985692 GA     school 1305790 758   Wilkinson County 130579001844 175 Wilkinson County Elementary School   Regular School No Elementary 03 05 2017 fall grade_5 40 66 11 0   0       0 5   63 59                       122 40 66 11 0   0       0 5   63 59                 122
1985713 GA     school 1305850 759   Worth County 130585001854 111 Worth County Elementary School   Regular School No Elementary 03 05 2017 fall grade_5 155 74 8 0   3       0 5   120 125                       245 155 74 8 0   3       0 5   120 125                 245
1986045 GA     school 1300120 761   Atlanta Public Schools 130012000063 513 Miles Elementary School   Regular School No Elementary 03 05 2017 fall grade_5 0 117 5 0   0       0 0   72 50                       122 0 117 5 0   0       0 0   72 50                 122
1986379 GA     school 1300720 765   Calhoun City 130072002216 405 Calhoun Elementary School   Regular School No Elementary 03 05 2017 fall grade_5 159 20 123 0   6       0 12   161 159                       320 159 20 123 0   6       0 12   161 159                 320
1986415 GA     school 1300900 767   Cartersville City 130090002098 191 Cartersville Elementary School   Regular School No Elementary 03 05 2017 fall grade_5 163 71 80 0   5       0 19   172 166                       338 163 71 80 0   5       0 19   172 166                 338
1986648 GA     school 1303030 779   Jefferson City 130303003671 107 Jefferson Academy   Regular School No Elementary 03 05 2017 fall grade_5 193 23 22 0   1       0 11   129 121                       250 193 23 22 0   1       0 11   129 121                 250
1986699 GA     school 1303510 781   Marietta City 130351003480 106 Marietta Center for Advanced Academics   Regular School No Elementary 03 05 2017 fall grade_5 43 22 22 1   10       1 3   59 43                       102 43 22 22 1   10       1 3   59 43                 102
1986923 GA     school 1300241 7830614   State Charter Schools II- Liberty Tech Charter Academy 130024104229 614 Liberty Tech Charter Academy   Regular School Yes Elementary 03 08 2017 fall grade_5 28 12 6 0   0       1 1   25 23                       48 28 12 6 0   0       1 1   25 23                 48
1987023 GA     school 1304540 786   Social Circle City 130454001616 200 Social Circle Elementary School   Regular School No Elementary 03 05 2017 fall grade_5 95 24 7 1   2       0 2   62 69                       131 95 24 7 1   2       0 2   62 69                 131
296851 GA     school 1300420 611   Bibb County 130042003621 307 Price Academy   Special Education School No Elementary 04 08 2017 spring grade_5 5 1 0 0   0       0 0   3 3                       6 5 1 0 0   0       0 0   3 3                 6
297014 GA     school 1300480 613   Brantley County 130048003907 110 Atkinson Elementary School   Regular School No Elementary 04 06 2017 spring grade_5 81 3 0 0   0       0 1   51 34                       85 81 3 0 0   0       0 1   51 34                 85
297016 GA     school 1300480 613   Brantley County 130048000234 294 Nahunta Elementary School   Regular School No Elementary 04 06 2017 spring grade_5 84 2 4 0   0       0 2   48 44                       92 84 2 4 0   0       0 2   48 44                 92
297083 GA     school 1300570 615   Bryan County 130057002368 101 Dr. George Washington Carver Elementary School   Regular School No Elementary 04 05 2017 spring grade_5 221 55 31 1   20       3 17   162 186                       348 221 55 31 1   20       3 17   162 186                 348
297648 GA     school 1300990 624   Charlton County 130099004016 112 Bethune Middle School   Regular School No Elementary 04 08 2017 spring grade_5 55 39 4 0   1       0 7   53 53                       106 55 39 4 0   1       0 7   53 53                 106
300281 GA     school 1301560 640   Crisp County 130156000771 2052 Crisp County Elementary School   Regular School No Elementary 04 05 2017 spring grade_5 86 181 21 2   2       0 8   145 155                       300 86 181 21 2   2       0 8   145 155                 300
300873 GA     school 1301740 644   DeKalb County 130174001999 288 Kittredge Magnet School   Regular School No Elementary 04 06 2017 spring grade_5 99 21 8 0   26       0 6   85 75                       160 99 21 8 0   26       0 6   85 75                 160
300911 GA     school 1301740 644   DeKalb County 130174003750 309 Wadsworth Magnet School for High Achievers   Regular School No Elementary 04 06 2017 spring grade_5 1 63 0 0   3       1 2   33 37                       70 1 63 0 0   3       1 2   33 37                 70
303968 GA     school 1302550 667   Gwinnett County 130255004057 1214 Gwinnett Online Campus   Regular School No Other 04 12 2017 spring grade_5 6 5 4 0   2       0 0   7 10                       17 6 5 4 0   2       0 0   7 10                 17
305075 GA     school 1302820 675   Henry County 130282001209 2552 Smith-Barnes Elementary School   Regular School No Elementary 04 05 2017 spring grade_5 17 84 27 0   3       0 5   69 67                       136 17 84 27 0   3       0 5   69 67                 136
305914 GA     school 1303360 691   Long County 130336004140 214 Walker Elementary School   Regular School No Elementary 04 05 2017 spring grade_5 117 78 46 1   0       0 22   123 141                       264 117 78 46 1   0       0 22   123 141                 264
306125 GA     school 1303570 697   McDuffie County 130357000459 113 Norris Elementary School   Regular School No Elementary 04 05 2017 spring grade_5 64 147 6 0   0       0 8   102 123                       225 64 147 6 0   0       0 8   102 123                 225
307655 GA     school 1304380 721   Richmond County 130438003486 107 Lighthouse Care Center of Augusta   Special Education School No Other 04 11 2017 spring grade_5 0 1 0 0   0       0 0   1 0                       1 0 1 0 0   0       0 0   1 0                 1
308196 GA     school 1304620 729   Sumter County 130462000004 595 Sumter County Intermediate School   Regular School No Elementary 04 06 2017 spring grade_5 22 229 39 1   0       0 6   161 136                       297 22 229 39 1   0       0 6   161 136                 297
308400 GA     school 1304980 737   Tift County 130498001688 5050 Charles Spencer Elementary School   Regular School No Elementary 04 05 2017 spring grade_5 105 112 80 0   5       0 7   161 148                       309 105 112 80 0   5       0 7   161 148                 309
308401 GA     school 1304980 737   Tift County 130498001689 4052 Matt Wilson Elementary School   Regular School No Elementary 04 05 2017 spring grade_5 113 105 26 2   3       0 3   141 111                       252 113 105 26 2   3       0 3   141 111                 252
308687 GA     school 1305280 745   Thomaston-Upson County 130528002199 295 Upson-Lee Elementary School   Regular School No Elementary 04 05 2017 spring grade_5 185 113 20 0   1       0 18   151 186                       337 185 113 20 0   1       0 18   151 186                 337
309282 GA     school 1305760 757   Wilkes County 130576001840 205 Washington-Wilkes Elementary School   Regular School No Elementary 04 05 2017 spring grade_5 44 53 10 0   0       0 4   60 51                       111 44 53 10 0   0       0 4   60 51                 111
309948 GA     school 1300510 763   Bremen City 130051003762 110 Bremen 4th & 5th Grade Academy   Regular School No Elementary 04 05 2017 spring grade_5 150 7 1 1   4       0 2   81 84                       165 150 7 1 1   4       0 2   81 84                 165
310002 GA     school 1300870 766   Carrollton City 130087003474 106 Carrollton Upper Elementary School   Regular School No Elementary 04 06 2017 spring grade_5 149 118 87 1   4       0 18   196 181                       377 149 118 87 1   4       0 18   196 181                 377
310147 GA     school 1301680 773   City Schools of Decatur 130168000795 112 Fifth Avenue Upper Elementary School   Regular School No Elementary 04 05 2017 spring grade_5 276 95 28 0   8       1 21   198 231                       429 276 95 28 0   8       1 21   198 231                 429
1973250 GA     school 1300420 611   Bibb County 130042003621 307 Price Academy   Special Education School No Elementary 04 08 2017 fall grade_5 5 1 0 0   0       0 0   3 3                       6 5 1 0 0   0       0 0   3 3                 6
1973418 GA     school 1300480 613   Brantley County 130048003907 110 Atkinson Elementary School   Regular School No Elementary 04 06 2017 fall grade_5 80 3 0 0   0       0 1   48 36                       84 80 3 0 0   0       0 1   48 36                 84
1973420 GA     school 1300480 613   Brantley County 130048000234 294 Nahunta Elementary School   Regular School No Elementary 04 06 2017 fall grade_5 79 2 4 0   0       0 2   46 41                       87 79 2 4 0   0       0 2   46 41                 87
1973486 GA     school 1300570 615   Bryan County 130057002368 101 Dr. George Washington Carver Elementary School   Regular School No Elementary 04 05 2017 fall grade_5 223 58 29 2   19       3 17   161 190                       351 223 58 29 2   19       3 17   161 190                 351
1974051 GA     school 1300990 624   Charlton County 130099004016 112 Bethune Middle School   Regular School No Elementary 04 08 2017 fall grade_5 57 38 5 0   1       0 7   54 54                       108 57 38 5 0   1       0 7   54 54                 108
1976685 GA     school 1301560 640   Crisp County 130156000771 2052 Crisp County Elementary School   Regular School No Elementary 04 05 2017 fall grade_5 85 186 20 0   2       0 7   143 157                       300 85 186 20 0   2       0 7   143 157                 300
1977275 GA     school 1301740 644   DeKalb County 130174001999 288 Kittredge Magnet School   Regular School No Elementary 04 06 2017 fall grade_5 100 21 8 0   26       0 6   86 75                       161 100 21 8 0   26       0 6   86 75                 161
1977313 GA     school 1301740 644   DeKalb County 130174003750 309 Wadsworth Magnet School for High Achievers   Regular School No Elementary 04 06 2017 fall grade_5 2 66 0 0   3       1 2   35 39                       74 2 66 0 0   3       1 2   35 39                 74
1980365 GA     school 1302550 667   Gwinnett County 130255004057 1214 Gwinnett Online Campus   Regular School No Other 04 12 2017 fall grade_5 8 6 4 0   2       0 0   8 12                       20 8 6 4 0   2       0 0   8 12                 20
1981471 GA     school 1302820 675   Henry County 130282001209 2552 Smith-Barnes Elementary School   Regular School No Elementary 04 05 2017 fall grade_5 15 83 30 0   4       0 6   68 70                       138 15 83 30 0   4       0 6   68 70                 138
1982309 GA     school 1303360 691   Long County 130336004140 214 Walker Elementary School   Regular School No Elementary 04 05 2017 fall grade_5 114 81 45 1   0       0 22   121 142                       263 114 81 45 1   0       0 22   121 142                 263
1982520 GA     school 1303570 697   McDuffie County 130357000459 113 Norris Elementary School   Regular School No Elementary 04 05 2017 fall grade_5 67 153 6 0   0       0 7   105 128                       233 67 153 6 0   0       0 7   105 128                 233
1984046 GA     school 1304380 721   Richmond County 130438003486 107 Lighthouse Care Center of Augusta   Special Education School No Other 04 11 2017 fall grade_5 0 1 0 0   0       0 0   1 0                       1 0 1 0 0   0       0 0   1 0                 1
1984587 GA     school 1304620 729   Sumter County 130462000004 595 Sumter County Intermediate School   Regular School No Elementary 04 06 2017 fall grade_5 24 236 39 1   0       0 6   162 144                       306 24 236 39 1   0       0 6   162 144                 306
1984791 GA     school 1304980 737   Tift County 130498001688 5050 Charles Spencer Elementary School   Regular School No Elementary 04 05 2017 fall grade_5 102 117 84 0   5       0 7   161 154                       315 102 117 84 0   5       0 7   161 154                 315
1984792 GA     school 1304980 737   Tift County 130498001689 4052 Matt Wilson Elementary School   Regular School No Elementary 04 05 2017 fall grade_5 111 106 25 2   3       0 3   141 109                       250 111 106 25 2   3       0 3   141 109                 250
1985079 GA     school 1305280 745   Thomaston-Upson County 130528002199 295 Upson-Lee Elementary School   Regular School No Elementary 04 05 2017 fall grade_5 187 112 20 0   1       0 17   153 184                       337 187 112 20 0   1       0 17   153 184                 337
1985674 GA     school 1305760 757   Wilkes County 130576001840 205 Washington-Wilkes Elementary School   Regular School No Elementary 04 05 2017 fall grade_5 46 54 10 0   0       0 3   60 53                       113 46 54 10 0   0       0 3   60 53                 113
1986343 GA     school 1300510 763   Bremen City 130051003762 110 Bremen 4th & 5th Grade Academy   Regular School No Elementary 04 05 2017 fall grade_5 149 6 1 0   4       1 2   79 84                       163 149 6 1 0   4       1 2   79 84                 163
1986397 GA     school 1300870 766   Carrollton City 130087003474 106 Carrollton Upper Elementary School   Regular School No Elementary 04 06 2017 fall grade_5 156 119 84 1   3       0 17   200 180                       380 156 119 84 1   3       0 17   200 180                 380
1986542 GA     school 1301680 773   City Schools of Decatur 130168000795 112 Fifth Avenue Upper Elementary School   Regular School No Elementary 04 05 2017 fall grade_5 279 94 28 0   7       1 20   200 229                       429 279 94 28 0   7       1 20   200 229                 429
298941 GA     school 1301260 632   Clinch County 130126002106 201 Clinch County Middle School   Regular School No Middle 05 07 2017 spring grade_5 56 35 4 0   1       0 4   61 39                       100 56 35 4 0   1       0 4   61 39                 100
299287 GA     school 1301290 633   Cobb County 130129003679 807 Devereux Ackerman Academy   Special Education School No Other 05 12 2017 spring grade_5 0 1 0 0   0       0 0   1 0                       1 0 1 0 0   0       0 0   1 0                 1
300385 GA     school 1301710 643   Decatur County 130171000613 2052 Hutto Middle School   Regular School No Middle 05 06 2017 spring grade_5 129 196 47 1   0       0 9   201 181                       382 129 196 47 1   0       0 9   201 181                 382
300847 GA     school 1301740 644   DeKalb County 130174003339 705 DeKalb PATH Academy Charter School   Regular School Yes Middle 05 08 2017 spring grade_5 2 10 73 0   6       0 0   34 57                       91 2 10 73 0   6       0 0   34 57                 91
301879 GA     school 1302010 652   Elbert County 130201002871 104 Elbert County Middle School   Regular School No Middle 05 08 2017 spring grade_5 102 83 31 0   1       0 8   107 118                       225 102 83 31 0   1       0 8   107 118                 225
302839 GA     school 1302280 660   Fulton County 130228003651 307 Georgia Baptist Children's Home and Family Ministries   Special Education School No Other 05 11 2017 spring grade_5 0 2 0 0   0       0 0   1 1                       2 0 2 0 0   0       0 0   1 1                 2
302850 GA     school 1302280 660   Fulton County 130228002885 204 KIPP South Fulton Academy School   Regular School Yes Middle 05 08 2017 spring grade_5 1 77 4 0   1       0 3   42 44                       86 1 77 4 0   1       0 3   42 44                 86
303222 GA     school 1302340 661   Gilmer County 130234002038 112 Gilmer Middle school   Regular School No Middle 05 06 2017 spring grade_5 230 1 83 0   5       0 2   159 162                       321 230 1 83 0   5       0 2   159 162                 321
304828 GA     school 1302700 672   Harris County 130270003958 110 Creekside School   Regular School No Middle 05 06 2017 spring grade_5 248 75 26 0   2       0 19   184 186                       370 248 75 26 0   2       0 19   184 186                 370
306235 GA     school 1303690 701   Mitchell County 130369001744 197 Mitchell County Middle School   Regular School No Middle 05 07 2017 spring grade_5 11 98 12 0   0       0 4   70 55                       125 11 98 12 0   0       0 4   70 55                 125
308154 GA     school 1304560 727   Stephens County 130456004209 296 Stephens County Fifth Grade Academy   Regular School No Middle 05 05 2017 spring grade_5 233 32 12 0   4       0 20   145 156                       301 233 32 12 0   4       0 20   145 156                 301
308359 GA     school 1304890 736   Thomas County 130489002147 205 Thomas County Middle School   Regular School No Middle 05 08 2017 spring grade_5 231 141 20 1   4       1 16   208 206                       414 231 141 20 1   4       1 16   208 206                 414
309643 GA     school 1300120 761   Atlanta Public Schools 130012003992 122 KIPP VISION   Regular School Yes Middle 05 08 2017 spring grade_5 0 88 2 0   0       0 0   39 51                       90 0 88 2 0   0       0 0   39 51                 90
309644 GA     school 1300120 761   Atlanta Public Schools 130012003031 605 KIPP West Atlanta Young Scholars Academy   Regular School Yes Middle 05 08 2017 spring grade_5 0 86 1 0   0       0 0   41 46                       87 0 86 1 0   0       0 0   41 46                 87
309647 GA     school 1300120 761   Atlanta Public Schools 130012003823 115 Kipp Strive Academy   Regular School Yes Middle 05 08 2017 spring grade_5 0 78 4 0   0       0 0   48 34                       82 0 78 4 0   0       0 0   48 34                 82
310055 GA     school 1301440 771   Commerce City 130144000623 105 Commerce Middle School   Regular School No Middle 05 08 2017 spring grade_5 74 12 13 0   1       0 7   48 59                       107 74 12 13 0   1       0 7   48 59                 107
310184 GA     school 1301870 774   Dublin City 130187000869 102 Dublin Middle School   Regular School No Middle 05 08 2017 spring grade_5 11 166 2 0   0       0 4   82 101                       183 11 166 2 0   0       0 4   82 101                 183
1975347 GA     school 1301260 632   Clinch County 130126002106 201 Clinch County Middle School   Regular School No Middle 05 07 2017 fall grade_5 56 35 4 0   1       0 4   61 39                       100 56 35 4 0   1       0 4   61 39                 100
1975692 GA     school 1301290 633   Cobb County 130129003679 807 Devereux Ackerman Academy   Special Education School No Other 05 12 2017 fall grade_5 0 1 0 0   0       0 0   0 1                       1 0 1 0 0   0       0 0   0 1                 1
1976789 GA     school 1301710 643   Decatur County 130171000613 2052 Hutto Middle School   Regular School No Middle 05 06 2017 fall grade_5 122 193 48 1   1       0 8   197 176                       373 122 193 48 1   1       0 8   197 176                 373
1977249 GA     school 1301740 644   DeKalb County 130174003339 705 DeKalb PATH Academy Charter School   Regular School Yes Middle 05 08 2017 fall grade_5 2 10 73 0   5       0 0   34 56                       90 2 10 73 0   5       0 0   34 56                 90
1978279 GA     school 1302010 652   Elbert County 130201002871 104 Elbert County Middle School   Regular School No Middle 05 08 2017 fall grade_5 103 83 31 0   1       0 8   108 118                       226 103 83 31 0   1       0 8   108 118                 226
1979238 GA     school 1302280 660   Fulton County 130228003651 307 Georgia Baptist Children's Home and Family Ministries   Special Education School No Other 05 11 2017 fall grade_5 1 0 0 0   0       0 0   1 0                       1 1 0 0 0   0       0 0   1 0                 1
1979249 GA     school 1302280 660   Fulton County 130228002885 204 KIPP South Fulton Academy School   Regular School Yes Middle 05 08 2017 fall grade_5 1 78 4 0   1       0 3   41 46                       87 1 78 4 0   1       0 3   41 46                 87
1979619 GA     school 1302340 661   Gilmer County 130234002038 112 Gilmer Middle school   Regular School No Middle 05 06 2017 fall grade_5 231 1 78 0   5       0 3   155 163                       318 231 1 78 0   5       0 3   155 163                 318
1981224 GA     school 1302700 672   Harris County 130270003958 110 Creekside School   Regular School No Middle 05 06 2017 fall grade_5 252 73 28 0   2       0 19   186 188                       374 252 73 28 0   2       0 19   186 188                 374
1982629 GA     school 1303690 701   Mitchell County 130369001744 197 Mitchell County Middle School   Regular School No Middle 05 07 2017 fall grade_5 9 94 12 0   0       0 4   65 54                       119 9 94 12 0   0       0 4   65 54                 119
1984545 GA     school 1304560 727   Stephens County 130456004209 296 Stephens County Fifth Grade Academy   Regular School No Middle 05 05 2017 fall grade_5 233 30 12 0   4       0 19   144 154                       298 233 30 12 0   4       0 19   144 154                 298
1984750 GA     school 1304890 736   Thomas County 130489002147 205 Thomas County Middle School   Regular School No Middle 05 08 2017 fall grade_5 226 144 18 1   3       1 17   206 204                       410 226 144 18 1   3       1 17   206 204                 410
1986037 GA     school 1300120 761   Atlanta Public Schools 130012003992 122 KIPP VISION   Regular School Yes Middle 05 08 2017 fall grade_5 0 85 1 0   0       0 0   40 46                       86 0 85 1 0   0       0 0   40 46                 86
1986038 GA     school 1300120 761   Atlanta Public Schools 130012003031 605 KIPP West Atlanta Young Scholars Academy   Regular School Yes Middle 05 08 2017 fall grade_5 0 76 1 0   0       0 0   37 40                       77 0 76 1 0   0       0 0   37 40                 77
1986041 GA     school 1300120 761   Atlanta Public Schools 130012003823 115 Kipp Strive Academy   Regular School Yes Middle 05 08 2017 fall grade_5 0 81 4 0   0       0 0   49 36                       85 0 81 4 0   0       0 0   49 36                 85
1986450 GA     school 1301440 771   Commerce City 130144000623 105 Commerce Middle School   Regular School No Middle 05 08 2017 fall grade_5 74 11 14 0   1       0 7   45 62                       107 74 11 14 0   1       0 7   45 62                 107
1986579 GA     school 1301870 774   Dublin City 130187000869 102 Dublin Middle School   Regular School No Middle 05 08 2017 fall grade_5 11 166 2 0   0       0 5   83 101                       184 11 166 2 0   0       0 5   83 101                 184
1987195 GA     school 1300026 891   Department of Juvenile Justice 130002603806 1898 Aaron Cohn Regional Youth Detention Center   Alternative School No Other 05 10 2017 fall grade_5 1 0 0 0   0       0 0   1 0                       1 1 0 0 0   0       0 0   1 0                 1
1987196 GA     school 1300026 891   Department of Juvenile Justice 130002603487 205 Crisp RYDC   Alternative School No Other 05 10 2017 fall grade_5 0 0 0 1   0       0 0   1 0                       1 0 0 0 1   0       0 0   1 0                 1
308358 GA     school 1304890 736   Thomas County 130489004152 115 The Renaissance Center for Academic and Career Development   Regular School No Other 06 12 2017 spring grade_5 0 1 0 0   0       0 0   1 0                       1 0 1 0 0   0       0 0   1 0                 1
308538 GA     school 1300001 741   Troup County 130000103620 207 Ault Academy   Special Education School No Other 06 12 2017 spring grade_5 0 0 1 0   0       0 0   1 0                       1 0 0 1 0   0       0 0   1 0                 1

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