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_per_million descending
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 | Catoosa | Georgia | 13047 | 14833 | 168 | 67580 | 2485 | 219488 |
2022-05-13 | Oconee | Georgia | 13219 | 8820 | 106 | 40280 | 2631 | 218967 |
2022-05-13 | Lanier | Georgia | 13173 | 2277 | 25 | 10423 | 2398 | 218459 |
2022-05-13 | Brantley | Georgia | 13025 | 4168 | 109 | 19109 | 5704 | 218117 |
2022-05-13 | Greene | Georgia | 13133 | 3974 | 85 | 18324 | 4638 | 216874 |
2022-05-13 | Washington | Georgia | 13303 | 4411 | 137 | 20374 | 6724 | 216501 |
2022-05-13 | Lumpkin | Georgia | 13187 | 7258 | 132 | 33610 | 3927 | 215947 |
2022-05-13 | Rabun | Georgia | 13241 | 3691 | 99 | 17137 | 5776 | 215381 |
2022-05-13 | Monroe | Georgia | 13207 | 5927 | 174 | 27578 | 6309 | 214917 |
2022-05-13 | Baldwin | Georgia | 13009 | 9574 | 240 | 44890 | 5346 | 213276 |
2022-05-13 | Oglethorpe | Georgia | 13221 | 3250 | 58 | 15259 | 3801 | 212989 |
2022-05-13 | Meriwether | Georgia | 13199 | 4487 | 145 | 21167 | 6850 | 211980 |
2022-05-13 | Dade | Georgia | 13083 | 3393 | 29 | 16116 | 1799 | 210536 |
2022-05-13 | Camden | Georgia | 13039 | 11467 | 120 | 54666 | 2195 | 209764 |
2022-05-13 | Fulton | Georgia | 13121 | 222488 | 2343 | 1063937 | 2202 | 209117 |
2022-05-13 | Crisp | Georgia | 13081 | 4678 | 137 | 22372 | 6123 | 209100 |
2022-05-13 | Banks | Georgia | 13011 | 3990 | 94 | 19234 | 4887 | 207445 |
2022-05-13 | Effingham | Georgia | 13103 | 13314 | 196 | 64296 | 3048 | 207073 |
2022-05-13 | Rockdale | Georgia | 13247 | 18719 | 321 | 90896 | 3531 | 205938 |
2022-05-13 | Glascock | Georgia | 13125 | 610 | 25 | 2971 | 8414 | 205318 |
2022-05-13 | Putnam | Georgia | 13237 | 4528 | 106 | 22119 | 4792 | 204710 |
2022-05-13 | Irwin | Georgia | 13155 | 1926 | 51 | 9416 | 5416 | 204545 |
2022-05-13 | Candler | Georgia | 13043 | 2194 | 96 | 10803 | 8886 | 203091 |
2022-05-13 | Warren | Georgia | 13301 | 1064 | 30 | 5254 | 5709 | 202512 |
2022-05-13 | Tattnall | Georgia | 13267 | 5119 | 131 | 25286 | 5180 | 202444 |
2022-05-13 | Liberty | Georgia | 13179 | 12434 | 149 | 61435 | 2425 | 202392 |
2022-05-13 | Lincoln | Georgia | 13181 | 1601 | 35 | 7921 | 4418 | 202120 |
2022-05-13 | DeKalb | Georgia | 13089 | 153194 | 1746 | 759297 | 2299 | 201757 |
2022-05-13 | Fayette | Georgia | 13113 | 22818 | 321 | 114421 | 2805 | 199421 |
2022-05-13 | Union | Georgia | 13291 | 4888 | 159 | 24511 | 6486 | 199420 |
2022-05-13 | Towns | Georgia | 13281 | 2400 | 116 | 12037 | 9636 | 199385 |
2022-05-13 | Carroll | Georgia | 13045 | 23863 | 460 | 119992 | 3833 | 198871 |
2022-05-13 | Fannin | Georgia | 13111 | 5141 | 160 | 26188 | 6109 | 196311 |
2022-05-13 | Muscogee | Georgia | 13215 | 38349 | 823 | 195769 | 4203 | 195889 |
2022-05-13 | Pulaski | Georgia | 13235 | 2180 | 78 | 11137 | 7003 | 195743 |
2022-05-13 | Telfair | Georgia | 13271 | 3101 | 85 | 15860 | 5359 | 195523 |
2022-05-13 | Bulloch | Georgia | 13031 | 15429 | 264 | 79608 | 3316 | 193812 |
2022-05-13 | Screven | Georgia | 13251 | 2659 | 70 | 13966 | 5012 | 190390 |
2022-05-13 | Twiggs | Georgia | 13289 | 1543 | 70 | 8120 | 8620 | 190024 |
2022-05-13 | Talbot | Georgia | 13263 | 1172 | 32 | 6195 | 5165 | 189184 |
2022-05-13 | Clay | Georgia | 13061 | 533 | 6 | 2834 | 2117 | 188073 |
2022-05-13 | Hancock | Georgia | 13141 | 1587 | 90 | 8457 | 10642 | 187655 |
2022-05-13 | Hart | Georgia | 13147 | 4899 | 100 | 26205 | 3816 | 186949 |
2022-05-13 | Quitman | Georgia | 13239 | 426 | 4 | 2299 | 1739 | 185297 |
2022-05-13 | Haralson | Georgia | 13143 | 5452 | 173 | 29792 | 5806 | 183002 |
2022-05-13 | Heard | Georgia | 13149 | 2181 | 54 | 11923 | 4529 | 182923 |
2022-05-13 | Marion | Georgia | 13197 | 1520 | 50 | 8359 | 5981 | 181839 |
2022-05-13 | Wheeler | Georgia | 13309 | 1414 | 39 | 7855 | 4964 | 180012 |
2022-05-13 | Dooly | Georgia | 13093 | 2383 | 69 | 13390 | 5153 | 177968 |
2022-05-13 | Jones | Georgia | 13169 | 5080 | 109 | 28735 | 3793 | 176787 |
2022-05-13 | Baker | Georgia | 13007 | 536 | 15 | 3038 | 4937 | 176431 |
2022-05-13 | Taliaferro | Georgia | 13265 | 268 | 3 | 1537 | 1951 | 174365 |
2022-05-13 | Jenkins | Georgia | 13165 | 1504 | 66 | 8676 | 7607 | 173351 |
2022-05-13 | Harris | Georgia | 13145 | 6095 | 113 | 35236 | 3206 | 172976 |
2022-05-13 | McIntosh | Georgia | 13191 | 2469 | 37 | 14378 | 2573 | 171720 |
2022-05-13 | Webster | Georgia | 13307 | 439 | 8 | 2607 | 3068 | 168392 |
2022-05-13 | Macon | Georgia | 13193 | 2151 | 50 | 12947 | 3861 | 166138 |
2022-05-13 | Crawford | Georgia | 13079 | 1780 | 55 | 12404 | 4434 | 143502 |
2022-05-13 | Long | Georgia | 13183 | 2801 | 35 | 19559 | 1789 | 143207 |
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;