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,825 rows where county = "Santa Clara" 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,825

county 1

  • Santa Clara · 12,825 ✖
Link rowid id name date ▲ county fips confirmed_cases note population
1097 1097 Campbell Campbell 2022-08-11 Santa Clara 85 8521   42470
1098 1098 Cupertino Cupertino 2022-08-11 Santa Clara 85 6892   60614
1099 1099 Gilroy Gilroy 2022-08-11 Santa Clara 85 18411   55525
1100 1100 Los Altos Los Altos 2022-08-11 Santa Clara 85 4123   30588
1101 1101 Los Altos Hills Los Altos Hills 2022-08-11 Santa Clara 85 1059   8517
1102 1102 Los Gatos Los Gatos 2022-08-11 Santa Clara 85 5895   30922
1103 1103 Milpitas Milpitas 2022-08-11 Santa Clara 85 14343   77457
1104 1104 Monte Sereno Monte Sereno 2022-08-11 Santa Clara 85 246   3492
1105 1105 Morgan Hill Morgan Hill 2022-08-11 Santa Clara 85 12004   43876
1106 1106 Mountain View Mountain View 2022-08-11 Santa Clara 85 11821   80993
1107 1107 Palo Alto Palo Alto 2022-08-11 Santa Clara 85 8958   67019
1108 1108 San Jose San Jose 2022-08-11 Santa Clara 85 246196   1026658
1109 1109 Santa Clara Santa Clara 2022-08-11 Santa Clara 85 23077   126209
1110 1110 Saratoga Saratoga 2022-08-11 Santa Clara 85 3815   30886
1111 1111 Sunnyvale Sunnyvale 2022-08-11 Santa Clara 85 22747   152323
2368 2368 Campbell Campbell 2022-08-10 Santa Clara 85 8521   42470
2369 2369 Cupertino Cupertino 2022-08-10 Santa Clara 85 6892   60614
2370 2370 Gilroy Gilroy 2022-08-10 Santa Clara 85 18411   55525
2371 2371 Los Altos Los Altos 2022-08-10 Santa Clara 85 4123   30588
2372 2372 Los Altos Hills Los Altos Hills 2022-08-10 Santa Clara 85 1059   8517
2373 2373 Los Gatos Los Gatos 2022-08-10 Santa Clara 85 5895   30922
2374 2374 Milpitas Milpitas 2022-08-10 Santa Clara 85 14343   77457
2375 2375 Monte Sereno Monte Sereno 2022-08-10 Santa Clara 85 246   3492
2376 2376 Morgan Hill Morgan Hill 2022-08-10 Santa Clara 85 12004   43876
2377 2377 Mountain View Mountain View 2022-08-10 Santa Clara 85 11821   80993
2378 2378 Palo Alto Palo Alto 2022-08-10 Santa Clara 85 8958   67019
2379 2379 San Jose San Jose 2022-08-10 Santa Clara 85 246196   1026658
2380 2380 Santa Clara Santa Clara 2022-08-10 Santa Clara 85 23077   126209
2381 2381 Saratoga Saratoga 2022-08-10 Santa Clara 85 3815   30886
2382 2382 Sunnyvale Sunnyvale 2022-08-10 Santa Clara 85 22747   152323
3639 3639 Campbell Campbell 2022-08-09 Santa Clara 85 8521   42470
3640 3640 Cupertino Cupertino 2022-08-09 Santa Clara 85 6892   60614
3641 3641 Gilroy Gilroy 2022-08-09 Santa Clara 85 18411   55525
3642 3642 Los Altos Los Altos 2022-08-09 Santa Clara 85 4123   30588
3643 3643 Los Altos Hills Los Altos Hills 2022-08-09 Santa Clara 85 1059   8517
3644 3644 Los Gatos Los Gatos 2022-08-09 Santa Clara 85 5895   30922
3645 3645 Milpitas Milpitas 2022-08-09 Santa Clara 85 14343   77457
3646 3646 Monte Sereno Monte Sereno 2022-08-09 Santa Clara 85 246   3492
3647 3647 Morgan Hill Morgan Hill 2022-08-09 Santa Clara 85 12004   43876
3648 3648 Mountain View Mountain View 2022-08-09 Santa Clara 85 11821   80993
3649 3649 Palo Alto Palo Alto 2022-08-09 Santa Clara 85 8958   67019
3650 3650 San Jose San Jose 2022-08-09 Santa Clara 85 246196   1026658
3651 3651 Santa Clara Santa Clara 2022-08-09 Santa Clara 85 23077   126209
3652 3652 Saratoga Saratoga 2022-08-09 Santa Clara 85 3815   30886
3653 3653 Sunnyvale Sunnyvale 2022-08-09 Santa Clara 85 22747   152323
4910 4910 Campbell Campbell 2022-08-08 Santa Clara 85 8521   42470
4911 4911 Cupertino Cupertino 2022-08-08 Santa Clara 85 6892   60614
4912 4912 Gilroy Gilroy 2022-08-08 Santa Clara 85 18411   55525
4913 4913 Los Altos Los Altos 2022-08-08 Santa Clara 85 4123   30588
4914 4914 Los Altos Hills Los Altos Hills 2022-08-08 Santa Clara 85 1059   8517
4915 4915 Los Gatos Los Gatos 2022-08-08 Santa Clara 85 5895   30922
4916 4916 Milpitas Milpitas 2022-08-08 Santa Clara 85 14343   77457
4917 4917 Monte Sereno Monte Sereno 2022-08-08 Santa Clara 85 246   3492
4918 4918 Morgan Hill Morgan Hill 2022-08-08 Santa Clara 85 12004   43876
4919 4919 Mountain View Mountain View 2022-08-08 Santa Clara 85 11821   80993
4920 4920 Palo Alto Palo Alto 2022-08-08 Santa Clara 85 8958   67019
4921 4921 San Jose San Jose 2022-08-08 Santa Clara 85 246196   1026658
4922 4922 Santa Clara Santa Clara 2022-08-08 Santa Clara 85 23077   126209
4923 4923 Saratoga Saratoga 2022-08-08 Santa Clara 85 3815   30886
4924 4924 Sunnyvale Sunnyvale 2022-08-08 Santa Clara 85 22747   152323
6181 6181 Campbell Campbell 2022-08-07 Santa Clara 85 8521   42470
6182 6182 Cupertino Cupertino 2022-08-07 Santa Clara 85 6892   60614
6183 6183 Gilroy Gilroy 2022-08-07 Santa Clara 85 18411   55525
6184 6184 Los Altos Los Altos 2022-08-07 Santa Clara 85 4123   30588
6185 6185 Los Altos Hills Los Altos Hills 2022-08-07 Santa Clara 85 1059   8517
6186 6186 Los Gatos Los Gatos 2022-08-07 Santa Clara 85 5895   30922
6187 6187 Milpitas Milpitas 2022-08-07 Santa Clara 85 14343   77457
6188 6188 Monte Sereno Monte Sereno 2022-08-07 Santa Clara 85 246   3492
6189 6189 Morgan Hill Morgan Hill 2022-08-07 Santa Clara 85 12004   43876
6190 6190 Mountain View Mountain View 2022-08-07 Santa Clara 85 11821   80993
6191 6191 Palo Alto Palo Alto 2022-08-07 Santa Clara 85 8958   67019
6192 6192 San Jose San Jose 2022-08-07 Santa Clara 85 246196   1026658
6193 6193 Santa Clara Santa Clara 2022-08-07 Santa Clara 85 23077   126209
6194 6194 Saratoga Saratoga 2022-08-07 Santa Clara 85 3815   30886
6195 6195 Sunnyvale Sunnyvale 2022-08-07 Santa Clara 85 22747   152323
7452 7452 Campbell Campbell 2022-08-06 Santa Clara 85 8521   42470
7453 7453 Cupertino Cupertino 2022-08-06 Santa Clara 85 6892   60614
7454 7454 Gilroy Gilroy 2022-08-06 Santa Clara 85 18411   55525
7455 7455 Los Altos Los Altos 2022-08-06 Santa Clara 85 4123   30588
7456 7456 Los Altos Hills Los Altos Hills 2022-08-06 Santa Clara 85 1059   8517
7457 7457 Los Gatos Los Gatos 2022-08-06 Santa Clara 85 5895   30922
7458 7458 Milpitas Milpitas 2022-08-06 Santa Clara 85 14343   77457
7459 7459 Monte Sereno Monte Sereno 2022-08-06 Santa Clara 85 246   3492
7460 7460 Morgan Hill Morgan Hill 2022-08-06 Santa Clara 85 12004   43876
7461 7461 Mountain View Mountain View 2022-08-06 Santa Clara 85 11821   80993
7462 7462 Palo Alto Palo Alto 2022-08-06 Santa Clara 85 8958   67019
7463 7463 San Jose San Jose 2022-08-06 Santa Clara 85 246196   1026658
7464 7464 Santa Clara Santa Clara 2022-08-06 Santa Clara 85 23077   126209
7465 7465 Saratoga Saratoga 2022-08-06 Santa Clara 85 3815   30886
7466 7466 Sunnyvale Sunnyvale 2022-08-06 Santa Clara 85 22747   152323
8723 8723 Campbell Campbell 2022-08-05 Santa Clara 85 8521   42470
8724 8724 Cupertino Cupertino 2022-08-05 Santa Clara 85 6892   60614
8725 8725 Gilroy Gilroy 2022-08-05 Santa Clara 85 18411   55525
8726 8726 Los Altos Los Altos 2022-08-05 Santa Clara 85 4123   30588
8727 8727 Los Altos Hills Los Altos Hills 2022-08-05 Santa Clara 85 1059   8517
8728 8728 Los Gatos Los Gatos 2022-08-05 Santa Clara 85 5895   30922
8729 8729 Milpitas Milpitas 2022-08-05 Santa Clara 85 14343   77457
8730 8730 Monte Sereno Monte Sereno 2022-08-05 Santa Clara 85 246   3492
8731 8731 Morgan Hill Morgan Hill 2022-08-05 Santa Clara 85 12004   43876
8732 8732 Mountain View Mountain View 2022-08-05 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 1605.645ms · Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_place_totals