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 ▲
2021-10-26 Chattahoochee Georgia 13053 5913 19 10907 1742 542128
2021-10-26 Crowley Colorado 8025 2382 23 6061 3794 393004
2021-10-26 Dimmit Texas 48127 3778 45 10124 4444 373172
2021-10-26 Bethel Census Area Alaska 2050 5886 27 18386 1468 320134
2021-10-26 Dewey South Dakota 46041 1838 31 5892 5261 311948
2021-10-26 Bent Colorado 8011 1725 27 5577 4841 309306
2021-10-26 Lake Tennessee 47095 2019 31 7016 4418 287770
2021-10-26 Lincoln Arkansas 5079 3646 57 13024 4376 279944
2021-10-26 Trousdale Tennessee 47169 3155 26 11284 2304 279599
2021-10-26 North Slope Borough Alaska 2185 2630 6 9832 610 267493
2021-10-26 Norton Kansas 20137 1410 30 5361 5595 263010
2021-10-26 Lafayette Florida 12067 2208 35 8422 4155 262170
2021-10-26 Karnes Texas 48255 4039 56 15601 3589 258893
2021-10-26 Concho Texas 48095 702 10 2726 3668 257520
2021-10-26 Clay Kentucky 21051 5106 58 19901 2914 256570
2021-10-26 Jackson Arkansas 5067 4267 42 16719 2512 255218
2021-10-26 Luce Michigan 26095 1579 6 6229 963 253491
2021-10-26 Buena Vista Iowa 19021 4919 46 19620 2344 250713
2021-10-26 Stark North Dakota 38089 7788 65 31489 2064 247324
2021-10-26 Lassen California 6035 7543 50 30573 1635 246720
2021-10-26 Miami-Dade Florida 12086 670019 8876 2716940 3266 246607
2021-10-26 Whitley Kentucky 21235 8892 86 36264 2371 245201
2021-10-26 Wayne Tennessee 47181 4034 39 16673 2339 241948
2021-10-26 Galax city Virginia 51640 1510 62 6347 9768 237907
2021-10-26 Perry Kentucky 21193 6112 88 25758 3416 237285
2021-10-26 Lyon Kentucky 21143 1947 26 8210 3166 237149
2021-10-26 Scott Tennessee 47151 5231 60 22068 2718 237040
2021-10-26 Bon Homme South Dakota 46009 1634 29 6901 4202 236777
2021-10-26 Lee Arkansas 5077 2097 48 8857 5419 236761
2021-10-26 Uvalde Texas 48463 6324 108 26741 4038 236490
2021-10-26 Hale Texas 48189 7894 187 33406 5597 236304
2021-10-26 Crockett Tennessee 47033 3352 62 14230 4356 235558
2021-10-26 Morton North Dakota 38059 7353 115 31364 3666 234440
2021-10-26 Lee Kentucky 21129 1735 31 7403 4187 234364
2021-10-26 East Feliciana Louisiana 22037 4482 144 19135 7525 234230
2021-10-26 Franklin Louisiana 22041 4676 137 20015 6844 233624
2021-10-26 Eddy North Dakota 38027 534 6 2287 2623 233493
2021-10-26 Dakota Nebraska 31043 4663 82 20026 4094 232847
2021-10-26 East Carroll Louisiana 22035 1593 30 6861 4372 232181
2021-10-26 Bledsoe Tennessee 47007 3485 18 15064 1194 231346
2021-10-26 Lamb Texas 48279 2980 88 12893 6825 231133
2021-10-26 Lincoln Colorado 8073 1317 8 5701 1403 231012
2021-10-26 Burleigh North Dakota 38015 22060 236 95626 2467 230690
2021-10-26 Covington Mississippi 28031 4298 94 18636 5044 230628
2021-10-26 Knox Kentucky 21121 7166 53 31145 1701 230085
2021-10-26 Buffalo South Dakota 46017 450 14 1962 7135 229357
2021-10-26 Pawnee Kansas 20145 1468 15 6414 2338 228874
2021-10-26 Stewart Georgia 13259 1515 28 6621 4228 228817
2021-10-26 Neshoba Mississippi 28099 6656 206 29118 7074 228587
2021-10-26 Owsley Kentucky 21189 1008 15 4415 3397 228312
2021-10-26 Sevier Arkansas 5133 3881 50 17007 2939 228200
2021-10-26 Bacon Georgia 13005 2545 61 11164 5463 227964
2021-10-26 Ellsworth Kansas 20053 1391 28 6102 4588 227958
2021-10-26 Alfalfa Oklahoma 40003 1299 7 5702 1227 227814
2021-10-26 Big Horn Montana 30003 3016 82 13319 6156 226443
2021-10-26 Northwest Arctic Borough Alaska 2188 1718 7 7621 918 225429
2021-10-26 Hot Spring Arkansas 5059 7608 105 33771 3109 225282
2021-10-26 Crockett Texas 48105 780 16 3464 4618 225173
2021-10-26 Green Kentucky 21087 2461 34 10941 3107 224933
2021-10-26 Clinch Georgia 13065 1488 35 6618 5288 224841
2021-10-26 Hardee Florida 12049 6054 100 26937 3712 224746
2021-10-26 Caldwell Louisiana 22021 2227 38 9918 3831 224541
2021-10-26 Nobles Minnesota 27105 4849 52 21629 2404 224189
2021-10-26 Houston Tennessee 47083 1834 44 8201 5365 223631
2021-10-26 Fremont Wyoming 56013 8748 123 39261 3132 222816
2021-10-26 Bell Kentucky 21013 5799 94 26032 3610 222764
2021-10-26 Willacy Texas 48489 4743 110 21358 5150 222071
2021-10-26 Macon Tennessee 47111 5459 93 24602 3780 221892
2021-10-26 Greene Arkansas 5055 10036 122 45325 2691 221423
2021-10-26 Reeves Texas 48389 3531 53 15976 3317 221019
2021-10-26 Moore Tennessee 47127 1431 22 6488 3390 220561
2021-10-26 Teton Wyoming 56039 5164 14 23464 596 220081
2021-10-26 Haywood Tennessee 47075 3806 76 17304 4392 219949
2021-10-26 Obion Tennessee 47131 6611 110 30069 3658 219860
2021-10-26 Cass Illinois 17017 2669 40 12147 3292 219725
2021-10-26 Leslie Kentucky 21131 2168 18 9877 1822 219499
2021-10-26 Seward Kansas 20175 4703 47 21428 2193 219479
2021-10-26 Taylor Kentucky 21217 5655 82 25769 3182 219449
2021-10-26 Pickens South Carolina 45077 27728 460 126884 3625 218530
2021-10-26 Adair Oklahoma 40001 4850 61 22194 2748 218527
2021-10-26 Forest Pennsylvania 42053 1583 24 7247 3311 218435
2021-10-26 Wayne Mississippi 28153 4407 72 20183 3567 218352
2021-10-26 Liberty Florida 12077 1823 19 8354 2274 218218
2021-10-26 Pierce Georgia 13229 4245 102 19465 5240 218083
2021-10-26 Kings California 6031 33325 335 152940 2190 217895
2021-10-26 Yell Arkansas 5149 4646 78 21341 3654 217703
2021-10-26 Washakie Wyoming 56043 1699 35 7805 4484 217680
2021-10-26 Gulf Florida 12045 2967 63 13639 4619 217537
2021-10-26 Clinton Kentucky 21053 2222 35 10218 3425 217459
2021-10-26 Maverick Texas 48323 12760 404 58722 6879 217295
2021-10-26 Dyer Tennessee 47045 8072 145 37159 3902 217228
2021-10-26 Jackson Florida 12063 10070 212 46414 4567 216960
2021-10-26 Gibson Tennessee 47053 10640 189 49133 3846 216555
2021-10-26 Whitfield Georgia 13313 22643 335 104628 3201 216414
2021-10-26 McCreary Kentucky 21147 3729 55 17231 3191 216412
2021-10-26 Lawrence Tennessee 47099 9527 121 44142 2741 215826
2021-10-26 Russell Kentucky 21207 3868 61 17923 3403 215812
2021-10-26 Hardin Tennessee 47071 5527 81 25652 3157 215460
2021-10-26 Val Verde Texas 48465 10558 250 49025 5099 215359
2021-10-26 Childress Texas 48075 1573 21 7306 2874 215302

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;