latest_ny_times_counties_with_populations (view)
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
159 rows where state = "Georgia" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 1
- Georgia · 159 ✖
date | county | state | fips | cases ▼ | deaths | population | deaths_per_million | cases_per_million |
---|---|---|---|---|---|---|---|---|
2022-05-13 | Decatur | Georgia | 13087 | 7269 | 131 | 26404 | 4961 | 275299 |
2022-05-13 | Lee | Georgia | 13177 | 7387 | 103 | 29992 | 3434 | 246299 |
2022-05-13 | Chattahoochee | Georgia | 13053 | 7486 | 22 | 10907 | 2017 | 686348 |
2022-05-13 | Upson | Georgia | 13293 | 7803 | 235 | 26320 | 8928 | 296466 |
2022-05-13 | Wayne | Georgia | 13305 | 7817 | 205 | 29927 | 6850 | 261202 |
2022-05-13 | Pickens | Georgia | 13227 | 8392 | 167 | 32591 | 5124 | 257494 |
2022-05-13 | Oconee | Georgia | 13219 | 8820 | 106 | 40280 | 2631 | 218967 |
2022-05-13 | Bryan | Georgia | 13029 | 9218 | 91 | 39627 | 2296 | 232619 |
2022-05-13 | Baldwin | Georgia | 13009 | 9574 | 240 | 44890 | 5346 | 213276 |
2022-05-13 | Ware | Georgia | 13299 | 10121 | 280 | 35734 | 7835 | 283231 |
2022-05-13 | Habersham | Georgia | 13137 | 10192 | 264 | 45328 | 5824 | 224849 |
2022-05-13 | Coffee | Georgia | 13069 | 10872 | 282 | 43273 | 6516 | 251242 |
2022-05-13 | Camden | Georgia | 13039 | 11467 | 120 | 54666 | 2195 | 209764 |
2022-05-13 | Murray | Georgia | 13213 | 11548 | 188 | 40096 | 4688 | 288008 |
2022-05-13 | Tift | Georgia | 13277 | 11593 | 218 | 40644 | 5363 | 285232 |
2022-05-13 | Colquitt | Georgia | 13071 | 11752 | 246 | 45600 | 5394 | 257719 |
2022-05-13 | Polk | Georgia | 13233 | 11910 | 193 | 42613 | 4529 | 279492 |
2022-05-13 | Thomas | Georgia | 13275 | 12084 | 210 | 44451 | 4724 | 271849 |
2022-05-13 | Liberty | Georgia | 13179 | 12434 | 149 | 61435 | 2425 | 202392 |
2022-05-13 | Effingham | Georgia | 13103 | 13314 | 196 | 64296 | 3048 | 207073 |
2022-05-13 | Laurens | Georgia | 13175 | 13827 | 299 | 47546 | 6288 | 290813 |
2022-05-13 | Catoosa | Georgia | 13047 | 14833 | 168 | 67580 | 2485 | 219488 |
2022-05-13 | Bulloch | Georgia | 13031 | 15429 | 264 | 79608 | 3316 | 193812 |
2022-05-13 | Troup | Georgia | 13285 | 15503 | 379 | 69922 | 5420 | 221718 |
2022-05-13 | Spalding | Georgia | 13255 | 15968 | 421 | 66703 | 6311 | 239389 |
2022-05-13 | Gordon | Georgia | 13129 | 16793 | 270 | 57963 | 4658 | 289719 |
2022-05-13 | Walker | Georgia | 13295 | 17127 | 244 | 69761 | 3497 | 245509 |
2022-05-13 | Rockdale | Georgia | 13247 | 18719 | 321 | 90896 | 3531 | 205938 |
2022-05-13 | Dougherty | Georgia | 13095 | 19863 | 498 | 87956 | 5661 | 225828 |
2022-05-13 | Jackson | Georgia | 13157 | 21247 | 291 | 72977 | 3987 | 291146 |
2022-05-13 | Barrow | Georgia | 13013 | 21998 | 256 | 83240 | 3075 | 264271 |
2022-05-13 | Walton | Georgia | 13297 | 22019 | 434 | 94593 | 4588 | 232776 |
2022-05-13 | Fayette | Georgia | 13113 | 22818 | 321 | 114421 | 2805 | 199421 |
2022-05-13 | Glynn | Georgia | 13127 | 23341 | 405 | 85292 | 4748 | 273659 |
2022-05-13 | Carroll | Georgia | 13045 | 23863 | 460 | 119992 | 3833 | 198871 |
2022-05-13 | Newton | Georgia | 13217 | 24799 | 457 | 111744 | 4089 | 221926 |
2022-05-13 | Floyd | Georgia | 13115 | 27468 | 520 | 98498 | 5279 | 278868 |
2022-05-13 | Bartow | Georgia | 13015 | 29577 | 447 | 107738 | 4148 | 274527 |
2022-05-13 | Clarke | Georgia | 13059 | 29898 | 232 | 128331 | 1807 | 232975 |
2022-05-13 | Lowndes | Georgia | 13185 | 31175 | 392 | 117406 | 3338 | 265531 |
2022-05-13 | Coweta | Georgia | 13077 | 33335 | 491 | 148509 | 3306 | 224464 |
2022-05-13 | Whitfield | Georgia | 13313 | 34132 | 439 | 104628 | 4195 | 326222 |
2022-05-13 | Douglas | Georgia | 13097 | 35159 | 400 | 146343 | 2733 | 240250 |
2022-05-13 | Columbia | Georgia | 13073 | 36344 | 390 | 156714 | 2488 | 231912 |
2022-05-13 | Bibb | Georgia | 13021 | 37615 | 788 | 153159 | 5144 | 245594 |
2022-05-13 | Muscogee | Georgia | 13215 | 38349 | 823 | 195769 | 4203 | 195889 |
2022-05-13 | Paulding | Georgia | 13223 | 38412 | 433 | 168667 | 2567 | 227738 |
2022-05-13 | Houston | Georgia | 13153 | 39773 | 500 | 157863 | 3167 | 251946 |
2022-05-13 | Richmond | Georgia | 13245 | 50566 | 895 | 202518 | 4419 | 249686 |
2022-05-13 | Hall | Georgia | 13139 | 54571 | 844 | 204441 | 4128 | 266927 |
2022-05-13 | Forsyth | Georgia | 13117 | 56197 | 401 | 244252 | 1641 | 230077 |
2022-05-13 | Henry | Georgia | 13151 | 58353 | 688 | 234561 | 2933 | 248775 |
2022-05-13 | Cherokee | Georgia | 13057 | 63811 | 630 | 258773 | 2434 | 246590 |
2022-05-13 | Chatham | Georgia | 13051 | 64409 | 886 | 289430 | 3061 | 222537 |
2022-05-13 | Clayton | Georgia | 13063 | 64612 | 977 | 292256 | 3342 | 221080 |
2022-05-13 | DeKalb | Georgia | 13089 | 153194 | 1746 | 759297 | 2299 | 201757 |
2022-05-13 | Cobb | Georgia | 13067 | 176832 | 1819 | 760141 | 2392 | 232630 |
2022-05-13 | Gwinnett | Georgia | 13135 | 210364 | 1886 | 936250 | 2014 | 224687 |
2022-05-13 | Fulton | Georgia | 13121 | 222488 | 2343 | 1063937 | 2202 | 209117 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW latest_ny_times_counties_with_populations AS select ny_times_us_counties.date, ny_times_us_counties.county, ny_times_us_counties.state, ny_times_us_counties.fips, ny_times_us_counties.cases, ny_times_us_counties.deaths, us_census_county_populations_2019.population, 1000000 * ny_times_us_counties.deaths / us_census_county_populations_2019.population as deaths_per_million, 1000000 * ny_times_us_counties.cases / us_census_county_populations_2019.population as cases_per_million from ny_times_us_counties join us_census_county_populations_2019 on ny_times_us_counties.fips = us_census_county_populations_2019.fips where "date" = ( select max(date) from ny_times_us_counties ) order by deaths_per_million desc;