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" and "date" is on date 2020-05-02 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
1210194 1210194 North Coast North Coast 2020-05-02 Mendocino 45 0   16148
1210195 1210195 North County North County 2020-05-02 Mendocino 45 7   19040
1210196 1210196 South Coast South Coast 2020-05-02 Mendocino 45 1   7693
1210197 1210197 South County South County 2020-05-02 Mendocino 45 0   6904
1210198 1210198 Ukiah Area Ukiah Area 2020-05-02 Mendocino 45 4   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
);