home / covid

Menu
  • GraphQL API

latimes_place_totals

Table actions
  • GraphQL API for latimes_place_totals
⚠️ 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

12,930 rows where fips = 85 sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

fips 1

  • 85 · 12,930 ✖

county 1

  • Santa Clara 12,930
Link rowid id name date ▲ county fips confirmed_cases note population
2320 2320 Campbell Campbell 2022-08-18 Santa Clara 85 8521   42470
2321 2321 Cupertino Cupertino 2022-08-18 Santa Clara 85 6892   60614
2322 2322 Gilroy Gilroy 2022-08-18 Santa Clara 85 18411   55525
2323 2323 Los Altos Los Altos 2022-08-18 Santa Clara 85 4123   30588
2324 2324 Los Altos Hills Los Altos Hills 2022-08-18 Santa Clara 85 1059   8517
2325 2325 Los Gatos Los Gatos 2022-08-18 Santa Clara 85 5895   30922
2326 2326 Milpitas Milpitas 2022-08-18 Santa Clara 85 14343   77457
2327 2327 Monte Sereno Monte Sereno 2022-08-18 Santa Clara 85 246   3492
2328 2328 Morgan Hill Morgan Hill 2022-08-18 Santa Clara 85 12004   43876
2329 2329 Mountain View Mountain View 2022-08-18 Santa Clara 85 11821   80993
2330 2330 Palo Alto Palo Alto 2022-08-18 Santa Clara 85 8958   67019
2331 2331 San Jose San Jose 2022-08-18 Santa Clara 85 246196   1026658
2332 2332 Santa Clara Santa Clara 2022-08-18 Santa Clara 85 23077   126209
2333 2333 Saratoga Saratoga 2022-08-18 Santa Clara 85 3815   30886
2334 2334 Sunnyvale Sunnyvale 2022-08-18 Santa Clara 85 22747   152323
3558 3558 Campbell Campbell 2022-08-17 Santa Clara 85 8521   42470
3559 3559 Cupertino Cupertino 2022-08-17 Santa Clara 85 6892   60614
3560 3560 Gilroy Gilroy 2022-08-17 Santa Clara 85 18411   55525
3561 3561 Los Altos Los Altos 2022-08-17 Santa Clara 85 4123   30588
3562 3562 Los Altos Hills Los Altos Hills 2022-08-17 Santa Clara 85 1059   8517
3563 3563 Los Gatos Los Gatos 2022-08-17 Santa Clara 85 5895   30922
3564 3564 Milpitas Milpitas 2022-08-17 Santa Clara 85 14343   77457
3565 3565 Monte Sereno Monte Sereno 2022-08-17 Santa Clara 85 246   3492
3566 3566 Morgan Hill Morgan Hill 2022-08-17 Santa Clara 85 12004   43876
3567 3567 Mountain View Mountain View 2022-08-17 Santa Clara 85 11821   80993
3568 3568 Palo Alto Palo Alto 2022-08-17 Santa Clara 85 8958   67019
3569 3569 San Jose San Jose 2022-08-17 Santa Clara 85 246196   1026658
3570 3570 Santa Clara Santa Clara 2022-08-17 Santa Clara 85 23077   126209
3571 3571 Saratoga Saratoga 2022-08-17 Santa Clara 85 3815   30886
3572 3572 Sunnyvale Sunnyvale 2022-08-17 Santa Clara 85 22747   152323
4796 4796 Campbell Campbell 2022-08-16 Santa Clara 85 8521   42470
4797 4797 Cupertino Cupertino 2022-08-16 Santa Clara 85 6892   60614
4798 4798 Gilroy Gilroy 2022-08-16 Santa Clara 85 18411   55525
4799 4799 Los Altos Los Altos 2022-08-16 Santa Clara 85 4123   30588
4800 4800 Los Altos Hills Los Altos Hills 2022-08-16 Santa Clara 85 1059   8517
4801 4801 Los Gatos Los Gatos 2022-08-16 Santa Clara 85 5895   30922
4802 4802 Milpitas Milpitas 2022-08-16 Santa Clara 85 14343   77457
4803 4803 Monte Sereno Monte Sereno 2022-08-16 Santa Clara 85 246   3492
4804 4804 Morgan Hill Morgan Hill 2022-08-16 Santa Clara 85 12004   43876
4805 4805 Mountain View Mountain View 2022-08-16 Santa Clara 85 11821   80993
4806 4806 Palo Alto Palo Alto 2022-08-16 Santa Clara 85 8958   67019
4807 4807 San Jose San Jose 2022-08-16 Santa Clara 85 246196   1026658
4808 4808 Santa Clara Santa Clara 2022-08-16 Santa Clara 85 23077   126209
4809 4809 Saratoga Saratoga 2022-08-16 Santa Clara 85 3815   30886
4810 4810 Sunnyvale Sunnyvale 2022-08-16 Santa Clara 85 22747   152323
6066 6066 Campbell Campbell 2022-08-15 Santa Clara 85 8521   42470
6067 6067 Cupertino Cupertino 2022-08-15 Santa Clara 85 6892   60614
6068 6068 Gilroy Gilroy 2022-08-15 Santa Clara 85 18411   55525
6069 6069 Los Altos Los Altos 2022-08-15 Santa Clara 85 4123   30588
6070 6070 Los Altos Hills Los Altos Hills 2022-08-15 Santa Clara 85 1059   8517
6071 6071 Los Gatos Los Gatos 2022-08-15 Santa Clara 85 5895   30922
6072 6072 Milpitas Milpitas 2022-08-15 Santa Clara 85 14343   77457
6073 6073 Monte Sereno Monte Sereno 2022-08-15 Santa Clara 85 246   3492
6074 6074 Morgan Hill Morgan Hill 2022-08-15 Santa Clara 85 12004   43876
6075 6075 Mountain View Mountain View 2022-08-15 Santa Clara 85 11821   80993
6076 6076 Palo Alto Palo Alto 2022-08-15 Santa Clara 85 8958   67019
6077 6077 San Jose San Jose 2022-08-15 Santa Clara 85 246196   1026658
6078 6078 Santa Clara Santa Clara 2022-08-15 Santa Clara 85 23077   126209
6079 6079 Saratoga Saratoga 2022-08-15 Santa Clara 85 3815   30886
6080 6080 Sunnyvale Sunnyvale 2022-08-15 Santa Clara 85 22747   152323
7336 7336 Campbell Campbell 2022-08-14 Santa Clara 85 8521   42470
7337 7337 Cupertino Cupertino 2022-08-14 Santa Clara 85 6892   60614
7338 7338 Gilroy Gilroy 2022-08-14 Santa Clara 85 18411   55525
7339 7339 Los Altos Los Altos 2022-08-14 Santa Clara 85 4123   30588
7340 7340 Los Altos Hills Los Altos Hills 2022-08-14 Santa Clara 85 1059   8517
7341 7341 Los Gatos Los Gatos 2022-08-14 Santa Clara 85 5895   30922
7342 7342 Milpitas Milpitas 2022-08-14 Santa Clara 85 14343   77457
7343 7343 Monte Sereno Monte Sereno 2022-08-14 Santa Clara 85 246   3492
7344 7344 Morgan Hill Morgan Hill 2022-08-14 Santa Clara 85 12004   43876
7345 7345 Mountain View Mountain View 2022-08-14 Santa Clara 85 11821   80993
7346 7346 Palo Alto Palo Alto 2022-08-14 Santa Clara 85 8958   67019
7347 7347 San Jose San Jose 2022-08-14 Santa Clara 85 246196   1026658
7348 7348 Santa Clara Santa Clara 2022-08-14 Santa Clara 85 23077   126209
7349 7349 Saratoga Saratoga 2022-08-14 Santa Clara 85 3815   30886
7350 7350 Sunnyvale Sunnyvale 2022-08-14 Santa Clara 85 22747   152323
8606 8606 Campbell Campbell 2022-08-13 Santa Clara 85 8521   42470
8607 8607 Cupertino Cupertino 2022-08-13 Santa Clara 85 6892   60614
8608 8608 Gilroy Gilroy 2022-08-13 Santa Clara 85 18411   55525
8609 8609 Los Altos Los Altos 2022-08-13 Santa Clara 85 4123   30588
8610 8610 Los Altos Hills Los Altos Hills 2022-08-13 Santa Clara 85 1059   8517
8611 8611 Los Gatos Los Gatos 2022-08-13 Santa Clara 85 5895   30922
8612 8612 Milpitas Milpitas 2022-08-13 Santa Clara 85 14343   77457
8613 8613 Monte Sereno Monte Sereno 2022-08-13 Santa Clara 85 246   3492
8614 8614 Morgan Hill Morgan Hill 2022-08-13 Santa Clara 85 12004   43876
8615 8615 Mountain View Mountain View 2022-08-13 Santa Clara 85 11821   80993
8616 8616 Palo Alto Palo Alto 2022-08-13 Santa Clara 85 8958   67019
8617 8617 San Jose San Jose 2022-08-13 Santa Clara 85 246196   1026658
8618 8618 Santa Clara Santa Clara 2022-08-13 Santa Clara 85 23077   126209
8619 8619 Saratoga Saratoga 2022-08-13 Santa Clara 85 3815   30886
8620 8620 Sunnyvale Sunnyvale 2022-08-13 Santa Clara 85 22747   152323
9876 9876 Campbell Campbell 2022-08-12 Santa Clara 85 8521   42470
9877 9877 Cupertino Cupertino 2022-08-12 Santa Clara 85 6892   60614
9878 9878 Gilroy Gilroy 2022-08-12 Santa Clara 85 18411   55525
9879 9879 Los Altos Los Altos 2022-08-12 Santa Clara 85 4123   30588
9880 9880 Los Altos Hills Los Altos Hills 2022-08-12 Santa Clara 85 1059   8517
9881 9881 Los Gatos Los Gatos 2022-08-12 Santa Clara 85 5895   30922
9882 9882 Milpitas Milpitas 2022-08-12 Santa Clara 85 14343   77457
9883 9883 Monte Sereno Monte Sereno 2022-08-12 Santa Clara 85 246   3492
9884 9884 Morgan Hill Morgan Hill 2022-08-12 Santa Clara 85 12004   43876
9885 9885 Mountain View Mountain View 2022-08-12 Santa Clara 85 11821   80993

Next page

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
);
Powered by Datasette · Queries took 1269.315ms · Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_place_totals