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,130 rows sorted by cases_per_million descending

✎ View and edit SQL

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

date county state fips cases deaths population deaths_per_million cases_per_million ▲
2020-10-21 Lincoln Arkansas 5079 2224 17 13024 1305 170761
2020-10-21 Chattahoochee Georgia 13053 1735 1 10907 91 159072
2020-10-21 Trousdale Tennessee 47169 1744 7 11284 620 154555
2020-10-21 Lafayette Florida 12067 1265 15 8422 1781 150201
2020-10-21 Lake Tennessee 47095 976 3 7016 427 139110
2020-10-21 Dakota Nebraska 31043 2519 46 20026 2297 125786
2020-10-21 Lee Arkansas 5077 1102 18 8857 2032 124421
2020-10-21 Buena Vista Iowa 19021 2213 12 19620 611 112793
2020-10-21 Buffalo South Dakota 46017 213 4 1962 2038 108562
2020-10-21 Chicot Arkansas 5017 1038 22 10118 2174 102589
2020-10-21 Nobles Minnesota 27105 2174 16 21629 739 100513
2020-10-21 Ford Kansas 20057 3313 10 33619 297 98545
2020-10-21 Wayne Tennessee 47181 1569 7 16673 419 94104
2020-10-21 East Feliciana Louisiana 22037 1786 75 19135 3919 93336
2020-10-21 Seward Kansas 20175 1992 7 21428 326 92962
2020-10-21 Bristol Bay Borough Alaska 2060 76 0 836 0 90909
2020-10-21 Big Horn Montana 30003 1205 34 13319 2552 90472
2020-10-21 Texas Oklahoma 40139 1741 10 19983 500 87124
2020-10-21 Norton Kansas 20137 464 10 5361 1865 86551
2020-10-21 East Carroll Louisiana 22035 575 6 6861 874 83807
2020-10-21 Emmons North Dakota 38029 271 8 3241 2468 83616
2020-10-21 Rosebud Montana 30087 737 20 8937 2237 82466
2020-10-21 Colfax Nebraska 31037 877 7 10709 653 81893
2020-10-21 Madison Louisiana 22065 892 8 10951 730 81453
2020-10-21 Stewart Georgia 13259 534 16 6621 2416 80652
2020-10-21 Issaquena Mississippi 28055 106 4 1327 3014 79879
2020-10-21 Faulk South Dakota 46049 182 1 2299 434 79164
2020-10-21 Crawford Iowa 19047 1324 12 16820 713 78715
2020-10-21 Greensville Virginia 51081 887 14 11336 1235 78246
2020-10-21 Jerauld South Dakota 46073 154 6 2013 2980 76502
2020-10-21 Sevier Arkansas 5133 1291 16 17007 940 75909
2020-10-21 Finney Kansas 20055 2761 16 36467 438 75712
2020-10-21 Roosevelt Montana 30085 829 17 11004 1544 75336
2020-10-21 Lowndes Alabama 1085 702 28 9726 2878 72177
2020-10-21 Eddy North Dakota 38027 165 3 2287 1311 72146
2020-10-21 Hale Texas 48189 2407 62 33406 1855 72052
2020-10-21 Hardeman Tennessee 47069 1804 32 25050 1277 72015
2020-10-21 Union Florida 12125 1092 29 15237 1903 71667
2020-10-21 Allen Louisiana 22003 1823 54 25627 2107 71135
2020-10-21 Stark North Dakota 38089 2233 30 31489 952 70913
2020-10-21 Imperial California 6025 12610 335 181215 1848 69585
2020-10-21 Maverick Texas 48323 4084 142 58722 2418 69548
2020-10-21 Haywood Tennessee 47075 1200 26 17304 1502 69348
2020-10-21 Galax city Virginia 51640 434 30 6347 4726 68378
2020-10-21 Gulf Florida 12045 928 15 13639 1099 68040
2020-10-21 Deaf Smith Texas 48117 1259 25 18546 1347 67885
2020-10-21 Benson North Dakota 38005 462 8 6832 1170 67622
2020-10-21 Woodbury Iowa 19193 6896 94 103107 911 66881
2020-10-21 Holmes Mississippi 28051 1137 60 17010 3527 66843
2020-10-21 St. Francis Arkansas 5123 1668 10 24994 400 66736
2020-10-21 Sioux Iowa 19167 2317 14 34855 401 66475
2020-10-21 Gadsden Florida 12039 3033 54 45660 1182 66425
2020-10-21 Taylor Florida 12123 1432 16 21569 741 66391
2020-10-21 Suwannee Florida 12121 2940 78 44417 1756 66190
2020-10-21 Miami-Dade Florida 12086 179643 3572 2716940 1314 66119
2020-10-21 Jackson Florida 12063 3067 83 46414 1788 66079
2020-10-21 Bledsoe Tennessee 47007 994 4 15064 265 65985
2020-10-21 Logan North Dakota 38047 121 0 1850 0 65405
2020-10-21 Clinch Georgia 13065 432 12 6618 1813 65276
2020-10-21 Perry Alabama 1105 581 6 8923 672 65112
2020-10-21 Bolivar Mississippi 28011 1994 77 30628 2514 65103
2020-10-21 Sharkey Mississippi 28125 280 14 4321 3239 64799
2020-10-21 Pawnee Kansas 20145 415 1 6414 155 64702
2020-10-21 Franklin Alabama 1059 2017 31 31362 988 64313
2020-10-21 Franklin Louisiana 22041 1287 44 20015 2198 64301
2020-10-21 Toole Montana 30101 304 6 4736 1266 64189
2020-10-21 Morton North Dakota 38059 2013 48 31364 1530 64181
2020-10-21 Santa Cruz Arizona 4023 2961 65 46498 1397 63680
2020-10-21 McIntosh North Dakota 38051 159 4 2497 1601 63676
2020-10-21 Golden Valley North Dakota 38033 112 0 1761 0 63600
2020-10-21 Potter Texas 48375 7446 96 117415 817 63416
2020-10-21 Liberty Florida 12077 529 10 8354 1197 63322
2020-10-21 Sunflower Mississippi 28133 1588 49 25110 1951 63241
2020-10-21 McKinley New Mexico 35031 4502 261 71367 3657 63082
2020-10-21 Bullock Alabama 1011 637 17 10101 1683 63063
2020-10-21 Hot Spring Arkansas 5059 2123 32 33771 947 62864
2020-10-21 Johnson Tennessee 47091 1115 7 17788 393 62682
2020-10-21 Neshoba Mississippi 28099 1820 111 29118 3812 62504
2020-10-21 Plymouth Iowa 19149 1571 26 25177 1032 62398
2020-10-21 Yuma Arizona 4027 13297 353 213787 1651 62197
2020-10-21 Yell Arkansas 5149 1327 30 21341 1405 62180
2020-10-21 Appling Georgia 13001 1140 35 18386 1903 62003
2020-10-21 Hamilton Florida 12047 890 9 14428 623 61685
2020-10-21 Moore Texas 48341 1289 22 20940 1050 61556
2020-10-21 Gove Kansas 20063 162 10 2636 3793 61456
2020-10-21 Quitman Mississippi 28119 417 6 6792 883 61395
2020-10-21 Burleigh North Dakota 38015 5852 74 95626 773 61196
2020-10-21 Malheur Oregon 41045 1866 34 30571 1112 61038
2020-10-21 Karnes Texas 48255 948 17 15601 1089 60765
2020-10-21 Saline Nebraska 31151 863 2 14224 140 60672
2020-10-21 Echols Georgia 13101 243 2 4006 499 60659
2020-10-21 Franklin city Virginia 51620 482 12 7967 1506 60499
2020-10-21 Jefferson Arkansas 5069 4039 100 66824 1496 60442
2020-10-21 Starr Texas 48427 3879 181 64633 2800 60015
2020-10-21 Dawson Texas 48115 762 15 12728 1178 59868
2020-10-21 Tallahatchie Mississippi 28135 825 25 13809 1810 59743
2020-10-21 Woodward Oklahoma 40153 1206 5 20211 247 59670
2020-10-21 Scurry Texas 48415 995 12 16703 718 59570
2020-10-21 Franklin Florida 12037 722 4 12125 329 59546
2020-10-21 Claiborne Mississippi 28021 534 16 8988 1780 59412

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 1906.196ms · Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette