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

8 rows where county = "Sacramento", "date" is on date 2020-12-03 and fips = 67 sorted by date descending

✎ View and edit SQL

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

fips 1

county 1

  • Sacramento · 8 ✖
Link rowid id name date ▲ county fips confirmed_cases note population
956878 956878 Citrus Heights Citrus Heights 2020-12-03 Sacramento 67 1761   87061
956879 956879 Elk Grove Elk Grove 2020-12-03 Sacramento 67 4211   168503
956880 956880 Folsom Folsom 2020-12-03 Sacramento 67 1206   77007
956881 956881 Galt Galt 2020-12-03 Sacramento 67 1024   25675
956882 956882 Isleton Isleton 2020-12-03 Sacramento 67 41   583
956883 956883 Rancho Cordova Rancho Cordova 2020-12-03 Sacramento 67 1621   72056
956884 956884 Sacramento Sacramento 2020-12-03 Sacramento 67 22548   495011
956885 956885 Unincorporated Areas Other 2020-12-03 Sacramento 67 7321    

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