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

11 rows where county = "Santa Barbara" and "date" is on date 2022-02-04 sorted by date descending

✎ View and edit SQL

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

fips 1

county 1

  • Santa Barbara · 11 ✖
Link rowid id name date ▲ county fips confirmed_cases note population
413159 413159 Goleta Goleta 2022-02-04 Santa Barbara 83 5248   29852
413160 413160 Goleta Valley & Gaviota Goleta Valley & Gaviota 2022-02-04 Santa Barbara 83 3960   30592
413161 413161 Isla Vista Isla Vista 2022-02-04 Santa Barbara 83 3453   23148
413162 413162 Lompoc Lompoc 2022-02-04 Santa Barbara 83 10218   57266
413163 413163 Lompoc Federal Prison Lompoc Federal Prison 2022-02-04 Santa Barbara 83 1160   0
413164 413164 North County North County 2022-02-04 Santa Barbara 83 2828   10096
413165 413165 Orcutt Orcutt 2022-02-04 Santa Barbara 83 5047   31603
413166 413166 Santa Barbara Santa Barbara 2022-02-04 Santa Barbara 83 15111   92029
413167 413167 Santa Maria Santa Maria 2022-02-04 Santa Barbara 83 23899   99553
413168 413168 Santa Ynez Valley Santa Ynez Valley 2022-02-04 Santa Barbara 83 3005   23022
413169 413169 South County South County 2022-02-04 Santa Barbara 83 3096   26723

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