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

15 rows where county = "Santa Clara", "date" is on date 2021-09-13 and fips = 85 sorted by date descending

✎ View and edit SQL

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

fips 1

county 1

  • Santa Clara · 15 ✖
Link rowid id name date ▲ county fips confirmed_cases note population
596521 596521 Campbell Campbell 2021-09-13 Santa Clara 85 2599   42470
596522 596522 Cupertino Cupertino 2021-09-13 Santa Clara 85 1139   60614
596523 596523 Gilroy Gilroy 2021-09-13 Santa Clara 85 8461   55525
596524 596524 Los Altos Los Altos 2021-09-13 Santa Clara 85 828   30588
596525 596525 Los Altos Hills Los Altos Hills 2021-09-13 Santa Clara 85 278   8517
596526 596526 Los Gatos Los Gatos 2021-09-13 Santa Clara 85 1546   30922
596527 596527 Milpitas Milpitas 2021-09-13 Santa Clara 85 4264   77457
596528 596528 Monte Sereno Monte Sereno 2021-09-13 Santa Clara 85 124   3492
596529 596529 Morgan Hill Morgan Hill 2021-09-13 Santa Clara 85 4414   43876
596530 596530 Mountain View Mountain View 2021-09-13 Santa Clara 85 3608   80993
596531 596531 Palo Alto Palo Alto 2021-09-13 Santa Clara 85 1907   67019
596532 596532 San Jose San Jose 2021-09-13 Santa Clara 85 89701   1026658
596533 596533 Santa Clara Santa Clara 2021-09-13 Santa Clara 85 6648   126209
596534 596534 Saratoga Saratoga 2021-09-13 Santa Clara 85 810   30886
596535 596535 Sunnyvale Sunnyvale 2021-09-13 Santa Clara 85 6622   152323

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