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

10 rows where fips = 59 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
8962 8962 2021-04-01 Orange 59 250764 4755 81 11
9426 9426 2021-03-24 Orange 59 249842 4646 82 11
9774 9774 2021-03-18 Orange 59 249181 4522 114 11
16560 16560 2020-11-21 Orange 59 69142 1551 806 11
18300 18300 2020-10-22 Orange 59 57848 1434 213 11
18358 18358 2020-10-21 Orange 59 57635 1423 262 11
20968 20968 2020-09-06 Orange 59 49732 1053 474 11
21142 21142 2020-09-03 Orange 59 48945 1018 0 11
22418 22418 2020-08-12 Orange 59 41823 745 245 11
23984 23984 2020-07-16 Orange 59 27904 466 873 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
);