latimes_place_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_place_totals

5 rows where county = "Mendocino", "date" is on date 2020-05-22 and fips = 45 sorted by date descending

✎ View and edit SQL

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

fips 1

county 1

  • Mendocino · 5 ✖
Link rowid id name date ▲ county fips confirmed_cases note population
1187974 1187974 North Coast North Coast 2020-05-22 Mendocino 45 0   16148
1187975 1187975 North County North County 2020-05-22 Mendocino 45 7   19040
1187976 1187976 South Coast South Coast 2020-05-22 Mendocino 45 1   7693
1187977 1187977 South County South County 2020-05-22 Mendocino 45 0   6904
1187978 1187978 Ukiah Area Ukiah Area 2020-05-22 Mendocino 45 13   38134

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [latimes_place_totals] (
   [id] TEXT,
   [name] TEXT,
   [date] TEXT,
   [county] TEXT,
   [fips] INTEGER,
   [confirmed_cases] INTEGER,
   [note] TEXT,
   [population] TEXT
);