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

3,131 rows sorted by cases_per_million descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

date county state fips cases deaths population deaths_per_million cases_per_million ▲
2022-05-13 Loving Texas 48301 196 1 169 5917 1159763
2022-05-13 Chattahoochee Georgia 13053 7486 22 10907 2017 686348
2022-05-13 Northwest Arctic Borough Alaska 2188 4837 13 7621 1705 634693
2022-05-13 Nome Census Area Alaska 2180 6245 5 10004 499 624250
2022-05-13 Dimmit Texas 48127 5760 51 10124 5037 568945
2022-05-13 Bethel Census Area Alaska 2050 10362 41 18386 2229 563580
2022-05-13 Crowley Colorado 8025 3347 30 6061 4949 552219
2022-05-13 Dewey South Dakota 46041 3139 44 5892 7467 532756
2022-05-13 Jim Hogg Texas 48247 2648 22 5200 4230 509230
2022-05-13 Bent Colorado 8011 2560 47 5577 8427 459028
2022-05-13 North Slope Borough Alaska 2185 4468 11 9832 1118 454434
2022-05-13 Miami-Dade Florida 12086 1209302 10921 2716940 4019 445097
2022-05-13 Menominee Wisconsin 55078 1987 14 4556 3072 436128
2022-05-13 Rolette North Dakota 38079 6121 43 14176 3033 431786
2022-05-13 Teton Wyoming 56039 10074 16 23464 681 429338
2022-05-13 Perry Kentucky 21193 11040 178 25758 6910 428604
2022-05-13 Scott Tennessee 47151 9097 117 22068 5301 412225
2022-05-13 Galax city Virginia 51640 2561 78 6347 12289 403497
2022-05-13 Norton Kansas 20137 2153 37 5361 6901 401604
2022-05-13 Lee Kentucky 21129 2951 52 7403 7024 398622
2022-05-13 Stewart Georgia 13259 2634 35 6621 5286 397825
2022-05-13 Concho Texas 48095 1084 11 2726 4035 397652
2022-05-13 Whitley Kentucky 21235 14412 199 36264 5487 397418
2022-05-13 Uvalde Texas 48463 10600 145 26741 5422 396395
2022-05-13 Morgan Kentucky 21175 5272 28 13309 2103 396122
2022-05-13 Clay Kentucky 21051 7867 92 19901 4622 395306
2022-05-13 Dillingham Census Area Alaska 2070 1932 11 4916 2237 393002
2022-05-13 Lake Tennessee 47095 2749 43 7016 6128 391818
2022-05-13 Powell Kentucky 21197 4782 44 12359 3560 386924
2022-05-13 Lincoln Colorado 8073 2199 9 5701 1578 385721
2022-05-13 Kodiak Island Borough Alaska 2150 4992 12 12998 923 384059
2022-05-13 Lexington city Virginia 51678 2857 40 7446 5372 383695
2022-05-13 East Feliciana Louisiana 22037 7324 170 19135 8884 382754
2022-05-13 Karnes Texas 48255 5968 70 15601 4486 382539
2022-05-13 Cass Illinois 17017 4640 44 12147 3622 381987
2022-05-13 Covington Mississippi 28031 7086 113 18636 6063 380231
2022-05-13 Lincoln Arkansas 5079 4920 68 13024 5221 377764
2022-05-13 Leslie Kentucky 21131 3723 49 9877 4961 376936
2022-05-13 Pitkin Colorado 8097 6676 7 17767 393 375752
2022-05-13 Trousdale Tennessee 47169 4238 45 11284 3987 375576
2022-05-13 Big Horn Montana 30003 4980 96 13319 7207 373901
2022-05-13 Vermilion Illinois 17183 28275 313 75758 4131 373227
2022-05-13 Hall Texas 48191 1102 24 2964 8097 371794
2022-05-13 Stark North Dakota 38089 11683 86 31489 2731 371018
2022-05-13 Luce Michigan 26095 2306 14 6229 2247 370203
2022-05-13 Knox Kentucky 21121 11523 144 31145 4623 369979
2022-05-13 East Carroll Louisiana 22035 2538 38 6861 5538 369916
2022-05-13 Brown Illinois 17009 2430 21 6578 3192 369413
2022-05-13 Taylor Kentucky 21217 9492 124 25769 4811 368349
2022-05-13 Imperial California 6025 66715 916 181215 5054 368153
2022-05-13 Franklin Louisiana 22041 7352 178 20015 8893 367324
2022-05-13 Jackson Arkansas 5067 6135 63 16719 3768 366947
2022-05-13 Burleigh North Dakota 38015 35087 303 95626 3168 366919
2022-05-13 Anchorage Alaska 2020 105418 526 288000 1826 366034
2022-05-13 Caldwell Louisiana 22021 3625 55 9918 5545 365497
2022-05-13 Johnson Illinois 17087 4538 46 12417 3704 365466
2022-05-13 Crockett Tennessee 47033 5199 85 14230 5973 365354
2022-05-13 Neshoba Mississippi 28099 10622 241 29118 8276 364791
2022-05-13 McKinley New Mexico 35031 26007 589 71367 8253 364412
2022-05-13 Pickens South Carolina 45077 46111 632 126884 4980 363410
2022-05-13 Kings California 6031 55429 447 152940 2922 362423
2022-05-13 Childress Texas 48075 2638 33 7306 4516 361073
2022-05-13 Adair Oklahoma 40001 8001 75 22194 3379 360502
2022-05-13 Clay Illinois 17025 4750 74 13184 5612 360285
2022-05-13 Russell Kentucky 21207 6446 87 17923 4854 359649
2022-05-13 Clinton Kentucky 21053 3674 52 10218 5089 359561
2022-05-13 Morton North Dakota 38059 11274 142 31364 4527 359456
2022-05-13 Perry Illinois 17145 7509 106 20916 5067 359007
2022-05-13 Providence Rhode Island 44007 229262 2535 638931 3967 358821
2022-05-13 Santa Cruz Arizona 4023 16683 232 46498 4989 358789
2022-05-13 Obion Tennessee 47131 10786 195 30069 6485 358708
2022-05-13 Haywood Tennessee 47075 6191 102 17304 5894 357778
2022-05-13 Hansford Texas 48195 1929 29 5399 5371 357288
2022-05-13 Owsley Kentucky 21189 1574 27 4415 6115 356511
2022-05-13 Maverick Texas 48323 20872 469 58722 7986 355437
2022-05-13 Gibson Tennessee 47053 17453 260 49133 5291 355219
2022-05-13 Greene Arkansas 5055 16088 173 45325 3816 354947
2022-05-13 Harlan Kentucky 21095 9222 211 26010 8112 354555
2022-05-13 Wolfe Kentucky 21237 2531 28 7157 3912 353639
2022-05-13 Floyd Kentucky 21071 12571 206 35589 5788 353227
2022-05-13 Donley Texas 48129 1153 26 3278 7931 351738
2022-05-13 Lassen California 6035 10751 69 30573 2256 351650
2022-05-13 Pickett Tennessee 47137 1774 36 5048 7131 351426
2022-05-13 Fremont Wyoming 56013 13795 193 39261 4915 351366
2022-05-13 Lyon Kentucky 21143 2881 34 8210 4141 350913
2022-05-13 Boyd Kentucky 21019 16369 177 46718 3788 350378
2022-05-13 Lawrence Illinois 17101 5489 52 15678 3316 350108
2022-05-13 Benton Minnesota 27009 14298 174 40889 4255 349678
2022-05-13 Webster Mississippi 28155 3388 70 9689 7224 349674
2022-05-13 Sevier Arkansas 5133 5943 75 17007 4409 349444
2022-05-13 Gibson Indiana 18051 11742 145 33659 4307 348851
2022-05-13 Montgomery Illinois 17135 9872 111 28414 3906 347434
2022-05-13 Newberry South Carolina 45071 13355 195 38440 5072 347424
2022-05-13 Webb Texas 48479 96110 1036 276652 3744 347403
2022-05-13 Ford Illinois 17053 4496 75 12961 5786 346886
2022-05-13 Logan Illinois 17107 9922 100 28618 3494 346704
2022-05-13 Navajo Arizona 4017 38394 909 110924 8194 346128
2022-05-13 Dorchester South Carolina 45035 56325 496 162809 3046 345957
2022-05-13 Greenup Kentucky 21089 12124 145 35098 4131 345432
2022-05-13 Wyoming West Virginia 54109 7044 116 20394 5687 345395

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;