latimes_county_totals

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: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_county_totals

8 rows where county = "San Benito", deaths = 7 and fips = 69 sorted by date descending

✎ View and edit SQL

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

Suggested facets: new_deaths, date (date)

fips 1

county 1

  • San Benito · 8 ✖
Link rowid date ▲ county fips confirmed_cases deaths new_confirmed_cases new_deaths
21553 21553 2020-08-27 San Benito 69 1018 7 20 0
21611 21611 2020-08-26 San Benito 69 998 7 11 0
21669 21669 2020-08-25 San Benito 69 987 7 9 0
21727 21727 2020-08-24 San Benito 69 978 7 8 0
21785 21785 2020-08-23 San Benito 69 970 7 23 0
21843 21843 2020-08-22 San Benito 69 947 7 29 0
21901 21901 2020-08-21 San Benito 69 918 7 16 0
21959 21959 2020-08-20 San Benito 69 902 7 30 2

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [latimes_county_totals] (
   [date] TEXT,
   [county] TEXT,
   [fips] INTEGER,
   [confirmed_cases] INTEGER,
   [deaths] INTEGER,
   [new_confirmed_cases] INTEGER,
   [new_deaths] INTEGER
);