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

6 rows where county = "Los Angeles" 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

  • Los Angeles · 6 ✖
Link rowid date ▲ county fips confirmed_cases deaths new_confirmed_cases new_deaths
2165 2165 2021-07-27 Los Angeles 37 1288090 24643 2127 11
2745 2745 2021-07-17 Los Angeles 37 1266227 24579 1669 11
2977 2977 2021-07-13 Los Angeles 37 1259992 24554 1307 11
4021 4021 2021-06-25 Los Angeles 37 1248764 24468 602 11
5819 5819 2021-05-25 Los Angeles 37 1239127 24186 195 11
6167 6167 2021-05-19 Los Angeles 37 1237910 24117 210 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
);