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 fips
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 | Mitchell | Georgia | 13205 | 5255 | 117 | 21863 | 5351 | 240360 |
2022-05-13 | Monroe | Georgia | 13207 | 5927 | 174 | 27578 | 6309 | 214917 |
2022-05-13 | Montgomery | Georgia | 13209 | 2082 | 53 | 9172 | 5778 | 226995 |
2022-05-13 | Morgan | Georgia | 13211 | 4709 | 70 | 19276 | 3631 | 244293 |
2022-05-13 | Murray | Georgia | 13213 | 11548 | 188 | 40096 | 4688 | 288008 |
2022-05-13 | Muscogee | Georgia | 13215 | 38349 | 823 | 195769 | 4203 | 195889 |
2022-05-13 | Newton | Georgia | 13217 | 24799 | 457 | 111744 | 4089 | 221926 |
2022-05-13 | Oconee | Georgia | 13219 | 8820 | 106 | 40280 | 2631 | 218967 |
2022-05-13 | Oglethorpe | Georgia | 13221 | 3250 | 58 | 15259 | 3801 | 212989 |
2022-05-13 | Paulding | Georgia | 13223 | 38412 | 433 | 168667 | 2567 | 227738 |
2022-05-13 | Peach | Georgia | 13225 | 6239 | 133 | 27546 | 4828 | 226493 |
2022-05-13 | Pickens | Georgia | 13227 | 8392 | 167 | 32591 | 5124 | 257494 |
2022-05-13 | Pierce | Georgia | 13229 | 5694 | 130 | 19465 | 6678 | 292525 |
2022-05-13 | Pike | Georgia | 13231 | 5473 | 98 | 18962 | 5168 | 288629 |
2022-05-13 | Polk | Georgia | 13233 | 11910 | 193 | 42613 | 4529 | 279492 |
2022-05-13 | Pulaski | Georgia | 13235 | 2180 | 78 | 11137 | 7003 | 195743 |
2022-05-13 | Putnam | Georgia | 13237 | 4528 | 106 | 22119 | 4792 | 204710 |
2022-05-13 | Quitman | Georgia | 13239 | 426 | 4 | 2299 | 1739 | 185297 |
2022-05-13 | Rabun | Georgia | 13241 | 3691 | 99 | 17137 | 5776 | 215381 |
2022-05-13 | Randolph | Georgia | 13243 | 1490 | 48 | 6778 | 7081 | 219828 |
2022-05-13 | Richmond | Georgia | 13245 | 50566 | 895 | 202518 | 4419 | 249686 |
2022-05-13 | Rockdale | Georgia | 13247 | 18719 | 321 | 90896 | 3531 | 205938 |
2022-05-13 | Schley | Georgia | 13249 | 1173 | 11 | 5257 | 2092 | 223131 |
2022-05-13 | Screven | Georgia | 13251 | 2659 | 70 | 13966 | 5012 | 190390 |
2022-05-13 | Seminole | Georgia | 13253 | 2173 | 30 | 8090 | 3708 | 268603 |
2022-05-13 | Spalding | Georgia | 13255 | 15968 | 421 | 66703 | 6311 | 239389 |
2022-05-13 | Stephens | Georgia | 13257 | 6340 | 159 | 25925 | 6133 | 244551 |
2022-05-13 | Stewart | Georgia | 13259 | 2634 | 35 | 6621 | 5286 | 397825 |
2022-05-13 | Sumter | Georgia | 13261 | 6845 | 170 | 29524 | 5758 | 231845 |
2022-05-13 | Talbot | Georgia | 13263 | 1172 | 32 | 6195 | 5165 | 189184 |
2022-05-13 | Taliaferro | Georgia | 13265 | 268 | 3 | 1537 | 1951 | 174365 |
2022-05-13 | Tattnall | Georgia | 13267 | 5119 | 131 | 25286 | 5180 | 202444 |
2022-05-13 | Taylor | Georgia | 13269 | 2003 | 54 | 8020 | 6733 | 249750 |
2022-05-13 | Telfair | Georgia | 13271 | 3101 | 85 | 15860 | 5359 | 195523 |
2022-05-13 | Terrell | Georgia | 13273 | 2057 | 67 | 8531 | 7853 | 241120 |
2022-05-13 | Thomas | Georgia | 13275 | 12084 | 210 | 44451 | 4724 | 271849 |
2022-05-13 | Tift | Georgia | 13277 | 11593 | 218 | 40644 | 5363 | 285232 |
2022-05-13 | Toombs | Georgia | 13279 | 7114 | 202 | 26830 | 7528 | 265150 |
2022-05-13 | Towns | Georgia | 13281 | 2400 | 116 | 12037 | 9636 | 199385 |
2022-05-13 | Treutlen | Georgia | 13283 | 1634 | 61 | 6901 | 8839 | 236777 |
2022-05-13 | Troup | Georgia | 13285 | 15503 | 379 | 69922 | 5420 | 221718 |
2022-05-13 | Turner | Georgia | 13287 | 2569 | 61 | 7985 | 7639 | 321728 |
2022-05-13 | Twiggs | Georgia | 13289 | 1543 | 70 | 8120 | 8620 | 190024 |
2022-05-13 | Union | Georgia | 13291 | 4888 | 159 | 24511 | 6486 | 199420 |
2022-05-13 | Upson | Georgia | 13293 | 7803 | 235 | 26320 | 8928 | 296466 |
2022-05-13 | Walker | Georgia | 13295 | 17127 | 244 | 69761 | 3497 | 245509 |
2022-05-13 | Walton | Georgia | 13297 | 22019 | 434 | 94593 | 4588 | 232776 |
2022-05-13 | Ware | Georgia | 13299 | 10121 | 280 | 35734 | 7835 | 283231 |
2022-05-13 | Warren | Georgia | 13301 | 1064 | 30 | 5254 | 5709 | 202512 |
2022-05-13 | Washington | Georgia | 13303 | 4411 | 137 | 20374 | 6724 | 216501 |
2022-05-13 | Wayne | Georgia | 13305 | 7817 | 205 | 29927 | 6850 | 261202 |
2022-05-13 | Webster | Georgia | 13307 | 439 | 8 | 2607 | 3068 | 168392 |
2022-05-13 | Wheeler | Georgia | 13309 | 1414 | 39 | 7855 | 4964 | 180012 |
2022-05-13 | White | Georgia | 13311 | 6857 | 163 | 30798 | 5292 | 222644 |
2022-05-13 | Whitfield | Georgia | 13313 | 34132 | 439 | 104628 | 4195 | 326222 |
2022-05-13 | Wilcox | Georgia | 13315 | 2014 | 71 | 8635 | 8222 | 233236 |
2022-05-13 | Wilkes | Georgia | 13317 | 2246 | 53 | 9777 | 5420 | 229722 |
2022-05-13 | Wilkinson | Georgia | 13319 | 2247 | 56 | 8954 | 6254 | 250949 |
2022-05-13 | Worth | Georgia | 13321 | 4677 | 119 | 20247 | 5877 | 230997 |
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;