latest_ny_times_counties_with_populations (view)

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

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

✎ View and edit SQL

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 Chattahoochee Georgia 13053 7486 22 10907 2017 686348
2022-05-13 Stewart Georgia 13259 2634 35 6621 5286 397825
2022-05-13 Bacon Georgia 13005 3692 78 11164 6986 330705
2022-05-13 Whitfield Georgia 13313 34132 439 104628 4195 326222
2022-05-13 Turner Georgia 13287 2569 61 7985 7639 321728
2022-05-13 Clinch Georgia 13065 2124 42 6618 6346 320942
2022-05-13 Miller Georgia 13201 1723 30 5718 5246 301329
2022-05-13 Upson Georgia 13293 7803 235 26320 8928 296466
2022-05-13 Pierce Georgia 13229 5694 130 19465 6678 292525
2022-05-13 Jackson Georgia 13157 21247 291 72977 3987 291146
2022-05-13 Laurens Georgia 13175 13827 299 47546 6288 290813
2022-05-13 Gordon Georgia 13129 16793 270 57963 4658 289719
2022-05-13 Pike Georgia 13231 5473 98 18962 5168 288629
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 Cook Georgia 13075 4911 76 17270 4400 284365
2022-05-13 Ware Georgia 13299 10121 280 35734 7835 283231
2022-05-13 Polk Georgia 13233 11910 193 42613 4529 279492
2022-05-13 Floyd Georgia 13115 27468 520 98498 5279 278868
2022-05-13 Decatur Georgia 13087 7269 131 26404 4961 275299
2022-05-13 Bartow Georgia 13015 29577 447 107738 4148 274527
2022-05-13 Glynn Georgia 13127 23341 405 85292 4748 273659
2022-05-13 Thomas Georgia 13275 12084 210 44451 4724 271849
2022-05-13 Early Georgia 13099 2765 62 10190 6084 271344
2022-05-13 Chattooga Georgia 13055 6687 134 24789 5405 269756
2022-05-13 Atkinson Georgia 13003 2200 50 8165 6123 269442
2022-05-13 Seminole Georgia 13253 2173 30 8090 3708 268603
2022-05-13 Hall Georgia 13139 54571 844 204441 4128 266927
2022-05-13 Dawson Georgia 13085 6964 101 26108 3868 266738
2022-05-13 Lowndes Georgia 13185 31175 392 117406 3338 265531
2022-05-13 Toombs Georgia 13279 7114 202 26830 7528 265150
2022-05-13 Barrow Georgia 13013 21998 256 83240 3075 264271
2022-05-13 Butts Georgia 13035 6556 157 24936 6296 262913
2022-05-13 Appling Georgia 13001 4833 128 18386 6961 262863
2022-05-13 Emanuel Georgia 13107 5924 160 22646 7065 261591
2022-05-13 Wayne Georgia 13305 7817 205 29927 6850 261202
2022-05-13 Bleckley Georgia 13023 3353 100 12873 7768 260467
2022-05-13 Jeff Davis Georgia 13161 3935 72 15115 4763 260337
2022-05-13 Ben Hill Georgia 13017 4344 122 16700 7305 260119
2022-05-13 Colquitt Georgia 13071 11752 246 45600 5394 257719
2022-05-13 Pickens Georgia 13227 8392 167 32591 5124 257494
2022-05-13 Berrien Georgia 13019 4955 83 19397 4279 255451
2022-05-13 Lamar Georgia 13171 4864 113 19077 5923 254966
2022-05-13 Dodge Georgia 13091 5244 154 20605 7473 254501
2022-05-13 Houston Georgia 13153 39773 500 157863 3167 251946
2022-05-13 Coffee Georgia 13069 10872 282 43273 6516 251242
2022-05-13 Wilkinson Georgia 13319 2247 56 8954 6254 250949
2022-05-13 Taylor Georgia 13269 2003 54 8020 6733 249750
2022-05-13 Richmond Georgia 13245 50566 895 202518 4419 249686
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 Lee Georgia 13177 7387 103 29992 3434 246299
2022-05-13 Bibb Georgia 13021 37615 788 153159 5144 245594
2022-05-13 Walker Georgia 13295 17127 244 69761 3497 245509
2022-05-13 Stephens Georgia 13257 6340 159 25925 6133 244551
2022-05-13 Morgan Georgia 13211 4709 70 19276 3631 244293
2022-05-13 Terrell Georgia 13273 2057 67 8531 7853 241120
2022-05-13 Mitchell Georgia 13205 5255 117 21863 5351 240360
2022-05-13 Douglas Georgia 13097 35159 400 146343 2733 240250
2022-05-13 Spalding Georgia 13255 15968 421 66703 6311 239389
2022-05-13 Jefferson Georgia 13163 3668 113 15362 7355 238770
2022-05-13 McDuffie Georgia 13189 5082 98 21312 4598 238457
2022-05-13 Elbert Georgia 13105 4558 109 19194 5678 237470
2022-05-13 Burke Georgia 13033 5315 110 22383 4914 237456
2022-05-13 Treutlen Georgia 13283 1634 61 6901 8839 236777
2022-05-13 Grady Georgia 13131 5795 113 24633 4587 235253
2022-05-13 Johnson Georgia 13167 2258 73 9643 7570 234159
2022-05-13 Echols Georgia 13101 937 12 4006 2995 233899
2022-05-13 Wilcox Georgia 13315 2014 71 8635 8222 233236
2022-05-13 Clarke Georgia 13059 29898 232 128331 1807 232975
2022-05-13 Walton Georgia 13297 22019 434 94593 4588 232776
2022-05-13 Cobb Georgia 13067 176832 1819 760141 2392 232630
2022-05-13 Bryan Georgia 13029 9218 91 39627 2296 232619
2022-05-13 Madison Georgia 13195 6950 110 29880 3681 232597
2022-05-13 Columbia Georgia 13073 36344 390 156714 2488 231912
2022-05-13 Franklin Georgia 13119 5414 104 23349 4454 231872
2022-05-13 Sumter Georgia 13261 6845 170 29524 5758 231845
2022-05-13 Worth Georgia 13321 4677 119 20247 5877 230997
2022-05-13 Forsyth Georgia 13117 56197 401 244252 1641 230077
2022-05-13 Wilkes Georgia 13317 2246 53 9777 5420 229722
2022-05-13 Charlton Georgia 13049 3067 62 13392 4629 229017
2022-05-13 Paulding Georgia 13223 38412 433 168667 2567 227738
2022-05-13 Montgomery Georgia 13209 2082 53 9172 5778 226995
2022-05-13 Peach Georgia 13225 6239 133 27546 4828 226493
2022-05-13 Dougherty Georgia 13095 19863 498 87956 5661 225828
2022-05-13 Habersham Georgia 13137 10192 264 45328 5824 224849
2022-05-13 Gwinnett Georgia 13135 210364 1886 936250 2014 224687
2022-05-13 Coweta Georgia 13077 33335 491 148509 3306 224464
2022-05-13 Schley Georgia 13249 1173 11 5257 2092 223131
2022-05-13 White Georgia 13311 6857 163 30798 5292 222644
2022-05-13 Chatham Georgia 13051 64409 886 289430 3061 222537
2022-05-13 Evans Georgia 13109 2370 65 10654 6100 222451
2022-05-13 Newton Georgia 13217 24799 457 111744 4089 221926
2022-05-13 Brooks Georgia 13027 3430 86 15457 5563 221905
2022-05-13 Jasper Georgia 13159 3155 73 14219 5133 221886
2022-05-13 Gilmer Georgia 13123 6960 178 31369 5674 221875
2022-05-13 Troup Georgia 13285 15503 379 69922 5420 221718
2022-05-13 Clayton Georgia 13063 64612 977 292256 3342 221080
2022-05-13 Calhoun Georgia 13037 1364 22 6189 3554 220391
2022-05-13 Randolph Georgia 13243 1490 48 6778 7081 219828

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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;