latest_ny_times_counties_with_populations (view)

⚠️ 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

3,106 rows sorted by cases_per_million descending

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

date county state fips cases deaths population deaths_per_million cases_per_million ▲
2020-08-07 Trousdale Tennessee 47169 1582 6 11284 531 140198
2020-08-07 Lake Tennessee 47095 782 0 7016 0 111459
2020-08-07 Lee Arkansas 5077 893 8 8857 903 100824
2020-08-07 Dakota Nebraska 31043 1922 42 20026 2097 95975
2020-08-07 Lincoln Arkansas 5079 1209 11 13024 844 92828
2020-08-07 Buena Vista Iowa 19021 1791 12 19620 611 91284
2020-08-07 Bristol Bay Borough Alaska 2060 68 0 836 0 81339
2020-08-07 Nobles Minnesota 27105 1754 6 21629 277 81094
2020-08-07 East Carroll Louisiana 22035 518 1 6861 145 75499
2020-08-07 Chicot Arkansas 5017 718 8 10118 790 70962
2020-08-07 Chattahoochee Georgia 13053 736 1 10907 91 67479
2020-08-07 Colfax Nebraska 31037 700 4 10709 373 65365
2020-08-07 Ford Kansas 20057 2161 10 33619 297 64279
2020-08-07 Lowndes Alabama 1085 580 26 9726 2673 59633
2020-08-07 Sevier Arkansas 5133 976 10 17007 587 57388
2020-08-07 Santa Cruz Arizona 4023 2651 52 46498 1118 57013
2020-08-07 Seward Kansas 20175 1220 4 21428 186 56934
2020-08-07 McKinley New Mexico 35031 4037 222 71367 3110 56566
2020-08-07 Madison Louisiana 22065 609 6 10951 547 55611
2020-08-07 Buffalo South Dakota 46017 109 3 1962 1529 55555
2020-08-07 Echols Georgia 13101 220 2 4006 499 54917
2020-08-07 Galax city Virginia 51640 348 24 6347 3781 54829
2020-08-07 Yuma Arizona 4027 11461 284 213787 1328 53609
2020-08-07 Imperial California 6025 9629 241 181215 1329 53135
2020-08-07 Texas Oklahoma 40139 1049 7 19983 350 52494
2020-08-07 Perry Alabama 1105 465 4 8923 448 52112
2020-08-07 Holmes Mississippi 28051 873 48 17010 2821 51322
2020-08-07 Moore Texas 48341 1047 13 20940 620 50000
2020-08-07 Yell Arkansas 5149 1062 14 21341 656 49763
2020-08-07 Finney Kansas 20055 1783 10 36467 274 48893
2020-08-07 Allen Louisiana 22003 1245 29 25627 1131 48581
2020-08-07 Navajo Arizona 4017 5352 199 110924 1794 48249
2020-08-07 La Salle Texas 48283 362 2 7520 265 48138
2020-08-07 Miami-Dade Florida 12086 129408 1809 2716940 665 47630
2020-08-07 St. Francis Arkansas 5123 1186 3 24994 120 47451
2020-08-07 Liberty Florida 12077 395 4 8354 478 47282
2020-08-07 Cass Indiana 18017 1777 10 37689 265 47149
2020-08-07 Madison Texas 48313 658 2 14284 140 46065
2020-08-07 Bledsoe Tennessee 47007 690 1 15064 66 45804
2020-08-07 Bullock Alabama 1011 462 12 10101 1188 45738
2020-08-07 Sharkey Mississippi 28125 194 4 4321 925 44897
2020-08-07 Marion Ohio 39101 2919 45 65093 691 44843
2020-08-07 Franklin Louisiana 22041 896 17 20015 849 44766
2020-08-07 Crockett Texas 48105 155 3 3464 866 44745
2020-08-07 Hot Spring Arkansas 5059 1496 11 33771 325 44298
2020-08-07 Claiborne Mississippi 28021 398 13 8988 1446 44281
2020-08-07 Neshoba Mississippi 28099 1284 92 29118 3159 44096
2020-08-07 Apache Arizona 4001 3151 138 71887 1919 43832
2020-08-07 McDonald Missouri 29119 1000 7 22837 306 43788
2020-08-07 Taylor Florida 12123 936 4 21569 185 43395
2020-08-07 Crawford Iowa 19047 726 3 16820 178 43162
2020-08-07 Noxubee Mississippi 28103 448 11 10417 1055 43006
2020-08-07 Yakima Washington 53077 10787 224 250873 892 42997
2020-08-07 Rockland New York 36087 13925 507 325789 1556 42742
2020-08-07 Hamilton Florida 12047 612 4 14428 277 42417
2020-08-07 San Juan Utah 49037 648 25 15308 1633 42330
2020-08-07 Wilcox Alabama 1131 434 10 10373 964 41839
2020-08-07 Saline Nebraska 31151 595 2 14224 140 41830
2020-08-07 Gulf Florida 12045 569 2 13639 146 41718
2020-08-07 Acadia Louisiana 22001 2570 79 62045 1273 41421
2020-08-07 Anderson Texas 48001 2379 10 57735 173 41205
2020-08-07 Hendry Florida 12051 1725 37 42022 880 41049
2020-08-07 Titus Texas 48449 1338 15 32750 458 40854
2020-08-07 Pickaway Ohio 39129 2380 42 58457 718 40713
2020-08-07 Franklin Alabama 1059 1275 20 31362 637 40654
2020-08-07 Dawson Nebraska 31047 956 9 23595 381 40517
2020-08-07 Deaf Smith Texas 48117 750 19 18546 1024 40439
2020-08-07 Grenada Mississippi 28043 838 21 20758 1011 40369
2020-08-07 Greensville Virginia 51081 452 11 11336 970 39872
2020-08-07 Manassas city Virginia 51683 1636 21 41085 511 39819
2020-08-07 Butler Alabama 1013 774 36 19448 1851 39798
2020-08-07 Randolph Georgia 13243 268 26 6778 3835 39539
2020-08-07 Maverick Texas 48323 2321 38 58722 647 39525
2020-08-07 Sunflower Mississippi 28133 992 24 25110 955 39506
2020-08-07 Jackson Florida 12063 1832 37 46414 797 39470
2020-08-07 Walker Texas 48471 2874 41 72971 561 39385
2020-08-07 Gadsden Florida 12039 1780 21 45660 459 38983
2020-08-07 Columbia Florida 12023 2784 14 71686 195 38836
2020-08-07 Stewart Georgia 13259 255 6 6621 906 38513
2020-08-07 Cameron Texas 48061 16290 415 423163 980 38495
2020-08-07 Nueces Texas 48355 13918 229 362294 632 38416
2020-08-07 Starr Texas 48427 2478 64 64633 990 38339
2020-08-07 Bacon Georgia 13005 427 6 11164 537 38247
2020-08-07 Atkinson Georgia 13003 312 2 8165 244 38211
2020-08-07 Victoria Texas 48469 3481 46 92084 499 37802
2020-08-07 Tallahatchie Mississippi 28135 522 10 13809 724 37801
2020-08-07 Dallas Alabama 1047 1403 23 37196 618 37719
2020-08-07 Franklin Washington 53021 3584 49 95222 514 37638
2020-08-07 Hale Texas 48189 1257 31 33406 927 37627
2020-08-07 Iberville Louisiana 22047 1219 47 32511 1445 37495
2020-08-07 Westchester New York 36119 36135 1447 967506 1495 37348
2020-08-07 Wayne Mississippi 28153 753 21 20183 1040 37308
2020-08-07 Quitman Mississippi 28119 252 1 6792 147 37102
2020-08-07 Madison Florida 12079 686 8 18493 432 37095
2020-08-07 Washington Mississippi 28151 1606 40 43909 910 36575
2020-08-07 Wright Iowa 19197 459 1 12562 79 36538
2020-08-07 Hancock Georgia 13141 308 35 8457 4138 36419
2020-08-07 Marshall Iowa 19127 1429 25 39369 635 36297
2020-08-07 Karnes Texas 48255 562 6 15601 384 36023
2020-08-07 Woodbury Iowa 19193 3708 51 103107 494 35962

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;
Powered by Datasette · Query took 1686.274ms · Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette