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

12 rows where deaths = 101 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 Taylor Florida 12123 7015 101 21569 4682 325235
2022-05-13 Kenai Peninsula Borough Alaska 2122 18091 101 58708 1720 308152
2022-05-13 DeKalb Tennessee 47041 6288 101 20490 4929 306881
2022-05-13 Clarke Alabama 1025 7154 101 23622 4275 302853
2022-05-13 Codington South Dakota 46029 8474 101 28009 3605 302545
2022-05-13 Hart Kentucky 21099 5428 101 19035 5306 285158
2022-05-13 Blue Earth Minnesota 27013 18332 101 67653 1492 270970
2022-05-13 Anson North Carolina 37007 6567 101 24446 4131 268632
2022-05-13 Dawson Georgia 13085 6964 101 26108 3868 266738
2022-05-13 Elk Pennsylvania 42047 7193 101 29910 3376 240488
2022-05-13 Otsego Michigan 26137 5779 101 24668 4094 234271
2022-05-13 Botetourt Virginia 51023 7607 101 33419 3022 227625

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;