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

5 rows where fips = 111 and new_deaths = 11 sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

fips 1

county 1

Link rowid date ▲ county fips confirmed_cases deaths new_confirmed_cases new_deaths
11134 11134 2021-02-23 Ventura 111 76715 805 137 11
12352 12352 2021-02-02 Ventura 111 71212 629 413 11
13396 13396 2021-01-15 Ventura 111 57611 412 1763 11
14382 14382 2020-12-29 Ventura 111 37572 255 993 11
14440 14440 2020-12-28 Ventura 111 36579 244 3178 11

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