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,133 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 ▲
2021-01-24 Crowley Colorado 8025 1764 14 6061 2309 291041
2021-01-24 Dewey South Dakota 46041 1384 18 5892 3054 234894
2021-01-24 Bent Colorado 8011 1283 20 5577 3586 230051
2021-01-24 Lincoln Arkansas 5079 2996 35 13024 2687 230036
2021-01-24 Chattahoochee Georgia 13053 2483 3 10907 275 227651
2021-01-24 Lake Tennessee 47095 1584 21 7016 2993 225769
2021-01-24 Norton Kansas 20137 1198 27 5361 5036 223465
2021-01-24 Bon Homme South Dakota 46009 1502 23 6901 3332 217649
2021-01-24 Buffalo South Dakota 46017 416 12 1962 6116 212028
2021-01-24 Trousdale Tennessee 47169 2307 16 11284 1417 204448
2021-01-24 Buena Vista Iowa 19021 3963 30 19620 1529 201987
2021-01-24 Ellsworth Kansas 20053 1151 4 6102 655 188626
2021-01-24 Dakota Nebraska 31043 3762 67 20026 3345 187855
2021-01-24 Eddy North Dakota 38027 426 6 2287 2623 186270
2021-01-24 Alfalfa Oklahoma 40003 1062 5 5702 876 186250
2021-01-24 Jackson Arkansas 5067 3028 30 16719 1794 181111
2021-01-24 Lafayette Florida 12067 1515 23 8422 2730 179886
2021-01-24 Lee Arkansas 5077 1587 30 8857 3387 179180
2021-01-24 Childress Texas 48075 1293 13 7306 1779 176977
2021-01-24 Seward Kansas 20175 3731 28 21428 1306 174117
2021-01-24 Nobles Minnesota 27105 3746 47 21629 2173 173193
2021-01-24 Bethel Census Area Alaska 2050 3182 14 18386 761 173066
2021-01-24 Hale Texas 48189 5774 140 33406 4190 172843
2021-01-24 Lassen California 6035 5269 16 30573 523 172341
2021-01-24 Menominee Wisconsin 55078 784 11 4556 2414 172080
2021-01-24 Forest Pennsylvania 42053 1247 12 7247 1655 172071
2021-01-24 Pawnee Kansas 20145 1094 8 6414 1247 170564
2021-01-24 Luce Michigan 26095 1058 1 6229 160 169850
2021-01-24 Foster North Dakota 38031 544 19 3210 5919 169470
2021-01-24 Big Horn Montana 30003 2252 69 13319 5180 169081
2021-01-24 Sheridan Kansas 20179 419 0 2521 0 166203
2021-01-24 Texas Oklahoma 40139 3278 20 19983 1000 164039
2021-01-24 Walsh North Dakota 38099 1726 24 10641 2255 162202
2021-01-24 Wayne Tennessee 47181 2704 24 16673 1439 162178
2021-01-24 Aurora South Dakota 46003 444 12 2751 4362 161395
2021-01-24 Ford Kansas 20057 5424 10 33619 297 161337
2021-01-24 Yuma Arizona 4027 34269 673 213787 3147 160295
2021-01-24 Finney Kansas 20055 5833 67 36467 1837 159952
2021-01-24 Potter South Dakota 46107 343 3 2153 1393 159312
2021-01-24 Logan Colorado 8075 3567 58 22409 2588 159177
2021-01-24 McKinley New Mexico 35031 11237 404 71367 5660 157453
2021-01-24 Santa Cruz Arizona 4023 7297 140 46498 3010 156931
2021-01-24 Stutsman North Dakota 38093 3224 75 20704 3622 155718
2021-01-24 Lincoln Colorado 8073 886 3 5701 526 155411
2021-01-24 Lyman South Dakota 46085 587 10 3781 2644 155249
2021-01-24 East Carroll Louisiana 22035 1064 20 6861 2915 155079
2021-01-24 Morton North Dakota 38059 4815 93 31364 2965 153519
2021-01-24 Chicot Arkansas 5017 1538 38 10118 3755 152006
2021-01-24 Nelson North Dakota 38063 436 12 2879 4168 151441
2021-01-24 Lee Kentucky 21129 1121 18 7403 2431 151425
2021-01-24 Sioux North Dakota 38085 639 11 4230 2600 151063
2021-01-24 Benson North Dakota 38005 1019 18 6832 2634 149151
2021-01-24 Galax city Virginia 51640 946 38 6347 5987 149046
2021-01-24 Lubbock Texas 48303 46241 671 310569 2160 148891
2021-01-24 Burleigh North Dakota 38015 14159 184 95626 1924 148066
2021-01-24 Dickey North Dakota 38021 721 32 4872 6568 147988
2021-01-24 Cass Illinois 17017 1794 31 12147 2552 147690
2021-01-24 Culberson Texas 48109 320 4 2171 1842 147397
2021-01-24 Maverick Texas 48323 8593 230 58722 3916 146333
2021-01-24 Toole Montana 30101 690 8 4736 1689 145692
2021-01-24 Davison South Dakota 46035 2879 57 19775 2882 145587
2021-01-24 Madison Idaho 16065 5760 21 39907 526 144335
2021-01-24 Rolette North Dakota 38079 2045 28 14176 1975 144257
2021-01-24 Woodward Oklahoma 40153 2905 12 20211 593 143733
2021-01-24 Faulk South Dakota 46049 330 13 2299 5654 143540
2021-01-24 East Feliciana Louisiana 22037 2723 98 19135 5121 142304
2021-01-24 Haywood Tennessee 47075 2455 48 17304 2773 141874
2021-01-24 Val Verde Texas 48465 6946 169 49025 3447 141682
2021-01-24 Colfax Nebraska 31037 1517 20 10709 1867 141656
2021-01-24 Republic Kansas 20157 656 13 4636 2804 141501
2021-01-24 Kearny Kansas 20093 543 9 3838 2344 141479
2021-01-24 Lamb Texas 48279 1823 76 12893 5894 141394
2021-01-24 Imperial California 6025 25581 492 181215 2715 141163
2021-01-24 Lawrence Illinois 17101 2207 30 15678 1913 140770
2021-01-24 Beadle South Dakota 46005 2596 39 18453 2113 140681
2021-01-24 Douglas South Dakota 46043 410 9 2921 3081 140362
2021-01-24 Plymouth Iowa 19149 3532 70 25177 2780 140286
2021-01-24 Scurry Texas 48415 2336 49 16703 2933 139855
2021-01-24 Whitfield Georgia 13313 14604 165 104628 1577 139580
2021-01-24 Crawford Iowa 19047 2347 24 16820 1426 139536
2021-01-24 Crockett Texas 48105 483 14 3464 4041 139434
2021-01-24 Fayette Illinois 17051 2967 53 21336 2484 139060
2021-01-24 Yell Arkansas 5149 2966 59 21341 2764 138981
2021-01-24 Minnehaha South Dakota 46099 26760 300 193134 1553 138556
2021-01-24 Griggs North Dakota 38039 308 2 2231 896 138054
2021-01-24 Nemaha Kansas 20131 1412 50 10231 4887 138011
2021-01-24 Grand Forks North Dakota 38035 9578 72 69451 1036 137910
2021-01-24 Potter Texas 48375 16188 352 117415 2997 137869
2021-01-24 Sanborn South Dakota 46111 323 3 2344 1279 137798
2021-01-24 Clinton Illinois 17027 5174 86 37562 2289 137745
2021-01-24 Wilbarger Texas 48487 1755 46 12769 3602 137442
2021-01-24 Pickett Tennessee 47137 692 20 5048 3961 137083
2021-01-24 Deaf Smith Texas 48117 2541 61 18546 3289 137010
2021-01-24 Golden Valley North Dakota 38033 241 2 1761 1135 136854
2021-01-24 Okfuskee Oklahoma 40107 1637 16 11993 1334 136496
2021-01-24 Webb Texas 48479 37761 592 276652 2139 136492
2021-01-24 Madison Louisiana 22065 1494 28 10951 2556 136425
2021-01-24 Gove Kansas 20063 359 22 2636 8345 136191
2021-01-24 Sevier Arkansas 5133 2312 24 17007 1411 135944
2021-01-24 Gratiot Michigan 26057 5530 98 40711 2407 135835

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;