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 = "Tehama", deaths = 4 and fips = 103 sorted by date descending

✎ View and edit SQL

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

Suggested facets: confirmed_cases, new_confirmed_cases, new_deaths, date (date)

fips 1

county 1

  • Tehama · 8 ✖
Link rowid date ▲ county fips confirmed_cases deaths new_confirmed_cases new_deaths
19946 19946 2020-09-24 Tehama 103 532 4 3 0
20004 20004 2020-09-23 Tehama 103 529 4 20 0
20062 20062 2020-09-22 Tehama 103 509 4 20 0
20120 20120 2020-09-21 Tehama 103 489 4 0 0
20178 20178 2020-09-20 Tehama 103 489 4 0 0
20236 20236 2020-09-19 Tehama 103 489 4 6 0
20294 20294 2020-09-18 Tehama 103 483 4 1 0
20352 20352 2020-09-17 Tehama 103 482 4 2 1

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
);