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)
Suggested facets: date (date)
state 1
- Georgia · 159 ✖
date | county | state | fips ▼ | cases | deaths | population | deaths_per_million | cases_per_million |
---|---|---|---|---|---|---|---|---|
2022-05-13 | Appling | Georgia | 13001 | 4833 | 128 | 18386 | 6961 | 262863 |
2022-05-13 | Atkinson | Georgia | 13003 | 2200 | 50 | 8165 | 6123 | 269442 |
2022-05-13 | Bacon | Georgia | 13005 | 3692 | 78 | 11164 | 6986 | 330705 |
2022-05-13 | Baker | Georgia | 13007 | 536 | 15 | 3038 | 4937 | 176431 |
2022-05-13 | Baldwin | Georgia | 13009 | 9574 | 240 | 44890 | 5346 | 213276 |
2022-05-13 | Banks | Georgia | 13011 | 3990 | 94 | 19234 | 4887 | 207445 |
2022-05-13 | Barrow | Georgia | 13013 | 21998 | 256 | 83240 | 3075 | 264271 |
2022-05-13 | Bartow | Georgia | 13015 | 29577 | 447 | 107738 | 4148 | 274527 |
2022-05-13 | Ben Hill | Georgia | 13017 | 4344 | 122 | 16700 | 7305 | 260119 |
2022-05-13 | Berrien | Georgia | 13019 | 4955 | 83 | 19397 | 4279 | 255451 |
2022-05-13 | Bibb | Georgia | 13021 | 37615 | 788 | 153159 | 5144 | 245594 |
2022-05-13 | Bleckley | Georgia | 13023 | 3353 | 100 | 12873 | 7768 | 260467 |
2022-05-13 | Brantley | Georgia | 13025 | 4168 | 109 | 19109 | 5704 | 218117 |
2022-05-13 | Brooks | Georgia | 13027 | 3430 | 86 | 15457 | 5563 | 221905 |
2022-05-13 | Bryan | Georgia | 13029 | 9218 | 91 | 39627 | 2296 | 232619 |
2022-05-13 | Bulloch | Georgia | 13031 | 15429 | 264 | 79608 | 3316 | 193812 |
2022-05-13 | Burke | Georgia | 13033 | 5315 | 110 | 22383 | 4914 | 237456 |
2022-05-13 | Butts | Georgia | 13035 | 6556 | 157 | 24936 | 6296 | 262913 |
2022-05-13 | Calhoun | Georgia | 13037 | 1364 | 22 | 6189 | 3554 | 220391 |
2022-05-13 | Camden | Georgia | 13039 | 11467 | 120 | 54666 | 2195 | 209764 |
2022-05-13 | Candler | Georgia | 13043 | 2194 | 96 | 10803 | 8886 | 203091 |
2022-05-13 | Carroll | Georgia | 13045 | 23863 | 460 | 119992 | 3833 | 198871 |
2022-05-13 | Catoosa | Georgia | 13047 | 14833 | 168 | 67580 | 2485 | 219488 |
2022-05-13 | Charlton | Georgia | 13049 | 3067 | 62 | 13392 | 4629 | 229017 |
2022-05-13 | Chatham | Georgia | 13051 | 64409 | 886 | 289430 | 3061 | 222537 |
2022-05-13 | Chattahoochee | Georgia | 13053 | 7486 | 22 | 10907 | 2017 | 686348 |
2022-05-13 | Chattooga | Georgia | 13055 | 6687 | 134 | 24789 | 5405 | 269756 |
2022-05-13 | Cherokee | Georgia | 13057 | 63811 | 630 | 258773 | 2434 | 246590 |
2022-05-13 | Clarke | Georgia | 13059 | 29898 | 232 | 128331 | 1807 | 232975 |
2022-05-13 | Clay | Georgia | 13061 | 533 | 6 | 2834 | 2117 | 188073 |
2022-05-13 | Clayton | Georgia | 13063 | 64612 | 977 | 292256 | 3342 | 221080 |
2022-05-13 | Clinch | Georgia | 13065 | 2124 | 42 | 6618 | 6346 | 320942 |
2022-05-13 | Cobb | Georgia | 13067 | 176832 | 1819 | 760141 | 2392 | 232630 |
2022-05-13 | Coffee | Georgia | 13069 | 10872 | 282 | 43273 | 6516 | 251242 |
2022-05-13 | Colquitt | Georgia | 13071 | 11752 | 246 | 45600 | 5394 | 257719 |
2022-05-13 | Columbia | Georgia | 13073 | 36344 | 390 | 156714 | 2488 | 231912 |
2022-05-13 | Cook | Georgia | 13075 | 4911 | 76 | 17270 | 4400 | 284365 |
2022-05-13 | Coweta | Georgia | 13077 | 33335 | 491 | 148509 | 3306 | 224464 |
2022-05-13 | Crawford | Georgia | 13079 | 1780 | 55 | 12404 | 4434 | 143502 |
2022-05-13 | Crisp | Georgia | 13081 | 4678 | 137 | 22372 | 6123 | 209100 |
2022-05-13 | Dade | Georgia | 13083 | 3393 | 29 | 16116 | 1799 | 210536 |
2022-05-13 | Dawson | Georgia | 13085 | 6964 | 101 | 26108 | 3868 | 266738 |
2022-05-13 | Decatur | Georgia | 13087 | 7269 | 131 | 26404 | 4961 | 275299 |
2022-05-13 | DeKalb | Georgia | 13089 | 153194 | 1746 | 759297 | 2299 | 201757 |
2022-05-13 | Dodge | Georgia | 13091 | 5244 | 154 | 20605 | 7473 | 254501 |
2022-05-13 | Dooly | Georgia | 13093 | 2383 | 69 | 13390 | 5153 | 177968 |
2022-05-13 | Dougherty | Georgia | 13095 | 19863 | 498 | 87956 | 5661 | 225828 |
2022-05-13 | Douglas | Georgia | 13097 | 35159 | 400 | 146343 | 2733 | 240250 |
2022-05-13 | Early | Georgia | 13099 | 2765 | 62 | 10190 | 6084 | 271344 |
2022-05-13 | Echols | Georgia | 13101 | 937 | 12 | 4006 | 2995 | 233899 |
2022-05-13 | Effingham | Georgia | 13103 | 13314 | 196 | 64296 | 3048 | 207073 |
2022-05-13 | Elbert | Georgia | 13105 | 4558 | 109 | 19194 | 5678 | 237470 |
2022-05-13 | Emanuel | Georgia | 13107 | 5924 | 160 | 22646 | 7065 | 261591 |
2022-05-13 | Evans | Georgia | 13109 | 2370 | 65 | 10654 | 6100 | 222451 |
2022-05-13 | Fannin | Georgia | 13111 | 5141 | 160 | 26188 | 6109 | 196311 |
2022-05-13 | Fayette | Georgia | 13113 | 22818 | 321 | 114421 | 2805 | 199421 |
2022-05-13 | Floyd | Georgia | 13115 | 27468 | 520 | 98498 | 5279 | 278868 |
2022-05-13 | Forsyth | Georgia | 13117 | 56197 | 401 | 244252 | 1641 | 230077 |
2022-05-13 | Franklin | Georgia | 13119 | 5414 | 104 | 23349 | 4454 | 231872 |
2022-05-13 | Fulton | Georgia | 13121 | 222488 | 2343 | 1063937 | 2202 | 209117 |
2022-05-13 | Gilmer | Georgia | 13123 | 6960 | 178 | 31369 | 5674 | 221875 |
2022-05-13 | Glascock | Georgia | 13125 | 610 | 25 | 2971 | 8414 | 205318 |
2022-05-13 | Glynn | Georgia | 13127 | 23341 | 405 | 85292 | 4748 | 273659 |
2022-05-13 | Gordon | Georgia | 13129 | 16793 | 270 | 57963 | 4658 | 289719 |
2022-05-13 | Grady | Georgia | 13131 | 5795 | 113 | 24633 | 4587 | 235253 |
2022-05-13 | Greene | Georgia | 13133 | 3974 | 85 | 18324 | 4638 | 216874 |
2022-05-13 | Gwinnett | Georgia | 13135 | 210364 | 1886 | 936250 | 2014 | 224687 |
2022-05-13 | Habersham | Georgia | 13137 | 10192 | 264 | 45328 | 5824 | 224849 |
2022-05-13 | Hall | Georgia | 13139 | 54571 | 844 | 204441 | 4128 | 266927 |
2022-05-13 | Hancock | Georgia | 13141 | 1587 | 90 | 8457 | 10642 | 187655 |
2022-05-13 | Haralson | Georgia | 13143 | 5452 | 173 | 29792 | 5806 | 183002 |
2022-05-13 | Harris | Georgia | 13145 | 6095 | 113 | 35236 | 3206 | 172976 |
2022-05-13 | Hart | Georgia | 13147 | 4899 | 100 | 26205 | 3816 | 186949 |
2022-05-13 | Heard | Georgia | 13149 | 2181 | 54 | 11923 | 4529 | 182923 |
2022-05-13 | Henry | Georgia | 13151 | 58353 | 688 | 234561 | 2933 | 248775 |
2022-05-13 | Houston | Georgia | 13153 | 39773 | 500 | 157863 | 3167 | 251946 |
2022-05-13 | Irwin | Georgia | 13155 | 1926 | 51 | 9416 | 5416 | 204545 |
2022-05-13 | Jackson | Georgia | 13157 | 21247 | 291 | 72977 | 3987 | 291146 |
2022-05-13 | Jasper | Georgia | 13159 | 3155 | 73 | 14219 | 5133 | 221886 |
2022-05-13 | Jeff Davis | Georgia | 13161 | 3935 | 72 | 15115 | 4763 | 260337 |
2022-05-13 | Jefferson | Georgia | 13163 | 3668 | 113 | 15362 | 7355 | 238770 |
2022-05-13 | Jenkins | Georgia | 13165 | 1504 | 66 | 8676 | 7607 | 173351 |
2022-05-13 | Johnson | Georgia | 13167 | 2258 | 73 | 9643 | 7570 | 234159 |
2022-05-13 | Jones | Georgia | 13169 | 5080 | 109 | 28735 | 3793 | 176787 |
2022-05-13 | Lamar | Georgia | 13171 | 4864 | 113 | 19077 | 5923 | 254966 |
2022-05-13 | Lanier | Georgia | 13173 | 2277 | 25 | 10423 | 2398 | 218459 |
2022-05-13 | Laurens | Georgia | 13175 | 13827 | 299 | 47546 | 6288 | 290813 |
2022-05-13 | Lee | Georgia | 13177 | 7387 | 103 | 29992 | 3434 | 246299 |
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 | Long | Georgia | 13183 | 2801 | 35 | 19559 | 1789 | 143207 |
2022-05-13 | Lowndes | Georgia | 13185 | 31175 | 392 | 117406 | 3338 | 265531 |
2022-05-13 | Lumpkin | Georgia | 13187 | 7258 | 132 | 33610 | 3927 | 215947 |
2022-05-13 | McDuffie | Georgia | 13189 | 5082 | 98 | 21312 | 4598 | 238457 |
2022-05-13 | McIntosh | Georgia | 13191 | 2469 | 37 | 14378 | 2573 | 171720 |
2022-05-13 | Macon | Georgia | 13193 | 2151 | 50 | 12947 | 3861 | 166138 |
2022-05-13 | Madison | Georgia | 13195 | 6950 | 110 | 29880 | 3681 | 232597 |
2022-05-13 | Marion | Georgia | 13197 | 1520 | 50 | 8359 | 5981 | 181839 |
2022-05-13 | Meriwether | Georgia | 13199 | 4487 | 145 | 21167 | 6850 | 211980 |
2022-05-13 | Miller | Georgia | 13201 | 1723 | 30 | 5718 | 5246 | 301329 |
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;