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,505 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

  • 85 8,505

county

  • Santa Clara · 8,505 ✖
Link rowid id name date ▲ county fips confirmed_cases note population
1210 1210 Campbell Campbell 2021-10-27 Santa Clara 85 2739   42470
1211 1211 Cupertino Cupertino 2021-10-27 Santa Clara 85 1257   60614
1212 1212 Gilroy Gilroy 2021-10-27 Santa Clara 85 8829   55525
1213 1213 Los Altos Los Altos 2021-10-27 Santa Clara 85 904   30588
1214 1214 Los Altos Hills Los Altos Hills 2021-10-27 Santa Clara 85 302   8517
1215 1215 Los Gatos Los Gatos 2021-10-27 Santa Clara 85 1677   30922
1216 1216 Milpitas Milpitas 2021-10-27 Santa Clara 85 4483   77457
1217 1217 Monte Sereno Monte Sereno 2021-10-27 Santa Clara 85 131   3492
1218 1218 Morgan Hill Morgan Hill 2021-10-27 Santa Clara 85 4709   43876
1219 1219 Mountain View Mountain View 2021-10-27 Santa Clara 85 3782   80993
1220 1220 Palo Alto Palo Alto 2021-10-27 Santa Clara 85 2038   67019
1221 1221 San Jose San Jose 2021-10-27 Santa Clara 85 94494   1026658
1222 1222 Santa Clara Santa Clara 2021-10-27 Santa Clara 85 7070   126209
1223 1223 Saratoga Saratoga 2021-10-27 Santa Clara 85 884   30886
1224 1224 Sunnyvale Sunnyvale 2021-10-27 Santa Clara 85 7031   152323
2575 2575 Campbell Campbell 2021-10-26 Santa Clara 85 2739   42470
2576 2576 Cupertino Cupertino 2021-10-26 Santa Clara 85 1257   60614
2577 2577 Gilroy Gilroy 2021-10-26 Santa Clara 85 8829   55525
2578 2578 Los Altos Los Altos 2021-10-26 Santa Clara 85 904   30588
2579 2579 Los Altos Hills Los Altos Hills 2021-10-26 Santa Clara 85 302   8517
2580 2580 Los Gatos Los Gatos 2021-10-26 Santa Clara 85 1677   30922
2581 2581 Milpitas Milpitas 2021-10-26 Santa Clara 85 4483   77457
2582 2582 Monte Sereno Monte Sereno 2021-10-26 Santa Clara 85 131   3492
2583 2583 Morgan Hill Morgan Hill 2021-10-26 Santa Clara 85 4709   43876
2584 2584 Mountain View Mountain View 2021-10-26 Santa Clara 85 3782   80993
2585 2585 Palo Alto Palo Alto 2021-10-26 Santa Clara 85 2038   67019
2586 2586 San Jose San Jose 2021-10-26 Santa Clara 85 94494   1026658
2587 2587 Santa Clara Santa Clara 2021-10-26 Santa Clara 85 7070   126209
2588 2588 Saratoga Saratoga 2021-10-26 Santa Clara 85 884   30886
2589 2589 Sunnyvale Sunnyvale 2021-10-26 Santa Clara 85 7031   152323
3940 3940 Campbell Campbell 2021-10-25 Santa Clara 85 2739   42470
3941 3941 Cupertino Cupertino 2021-10-25 Santa Clara 85 1257   60614
3942 3942 Gilroy Gilroy 2021-10-25 Santa Clara 85 8829   55525
3943 3943 Los Altos Los Altos 2021-10-25 Santa Clara 85 904   30588
3944 3944 Los Altos Hills Los Altos Hills 2021-10-25 Santa Clara 85 302   8517
3945 3945 Los Gatos Los Gatos 2021-10-25 Santa Clara 85 1677   30922
3946 3946 Milpitas Milpitas 2021-10-25 Santa Clara 85 4483   77457
3947 3947 Monte Sereno Monte Sereno 2021-10-25 Santa Clara 85 131   3492
3948 3948 Morgan Hill Morgan Hill 2021-10-25 Santa Clara 85 4709   43876
3949 3949 Mountain View Mountain View 2021-10-25 Santa Clara 85 3782   80993
3950 3950 Palo Alto Palo Alto 2021-10-25 Santa Clara 85 2038   67019
3951 3951 San Jose San Jose 2021-10-25 Santa Clara 85 94494   1026658
3952 3952 Santa Clara Santa Clara 2021-10-25 Santa Clara 85 7070   126209
3953 3953 Saratoga Saratoga 2021-10-25 Santa Clara 85 884   30886
3954 3954 Sunnyvale Sunnyvale 2021-10-25 Santa Clara 85 7031   152323
5305 5305 Campbell Campbell 2021-10-24 Santa Clara 85 2709   42470
5306 5306 Cupertino Cupertino 2021-10-24 Santa Clara 85 1225   60614
5307 5307 Gilroy Gilroy 2021-10-24 Santa Clara 85 8750   55525
5308 5308 Los Altos Los Altos 2021-10-24 Santa Clara 85 892   30588
5309 5309 Los Altos Hills Los Altos Hills 2021-10-24 Santa Clara 85 301   8517
5310 5310 Los Gatos Los Gatos 2021-10-24 Santa Clara 85 1649   30922
5311 5311 Milpitas Milpitas 2021-10-24 Santa Clara 85 4443   77457
5312 5312 Monte Sereno Monte Sereno 2021-10-24 Santa Clara 85 128   3492
5313 5313 Morgan Hill Morgan Hill 2021-10-24 Santa Clara 85 4626   43876
5314 5314 Mountain View Mountain View 2021-10-24 Santa Clara 85 3746   80993
5315 5315 Palo Alto Palo Alto 2021-10-24 Santa Clara 85 2006   67019
5316 5316 San Jose San Jose 2021-10-24 Santa Clara 85 93560   1026658
5317 5317 Santa Clara Santa Clara 2021-10-24 Santa Clara 85 6984   126209
5318 5318 Saratoga Saratoga 2021-10-24 Santa Clara 85 861   30886
5319 5319 Sunnyvale Sunnyvale 2021-10-24 Santa Clara 85 6941   152323
6670 6670 Campbell Campbell 2021-10-23 Santa Clara 85 2709   42470
6671 6671 Cupertino Cupertino 2021-10-23 Santa Clara 85 1225   60614
6672 6672 Gilroy Gilroy 2021-10-23 Santa Clara 85 8750   55525
6673 6673 Los Altos Los Altos 2021-10-23 Santa Clara 85 892   30588
6674 6674 Los Altos Hills Los Altos Hills 2021-10-23 Santa Clara 85 301   8517
6675 6675 Los Gatos Los Gatos 2021-10-23 Santa Clara 85 1649   30922
6676 6676 Milpitas Milpitas 2021-10-23 Santa Clara 85 4443   77457
6677 6677 Monte Sereno Monte Sereno 2021-10-23 Santa Clara 85 128   3492
6678 6678 Morgan Hill Morgan Hill 2021-10-23 Santa Clara 85 4626   43876
6679 6679 Mountain View Mountain View 2021-10-23 Santa Clara 85 3746   80993
6680 6680 Palo Alto Palo Alto 2021-10-23 Santa Clara 85 2006   67019
6681 6681 San Jose San Jose 2021-10-23 Santa Clara 85 93560   1026658
6682 6682 Santa Clara Santa Clara 2021-10-23 Santa Clara 85 6984   126209
6683 6683 Saratoga Saratoga 2021-10-23 Santa Clara 85 861   30886
6684 6684 Sunnyvale Sunnyvale 2021-10-23 Santa Clara 85 6941   152323
8035 8035 Campbell Campbell 2021-10-22 Santa Clara 85 2689   42470
8036 8036 Cupertino Cupertino 2021-10-22 Santa Clara 85 1217   60614
8037 8037 Gilroy Gilroy 2021-10-22 Santa Clara 85 8712   55525
8038 8038 Los Altos Los Altos 2021-10-22 Santa Clara 85 881   30588
8039 8039 Los Altos Hills Los Altos Hills 2021-10-22 Santa Clara 85 295   8517
8040 8040 Los Gatos Los Gatos 2021-10-22 Santa Clara 85 1623   30922
8041 8041 Milpitas Milpitas 2021-10-22 Santa Clara 85 4409   77457
8042 8042 Monte Sereno Monte Sereno 2021-10-22 Santa Clara 85 128   3492
8043 8043 Morgan Hill Morgan Hill 2021-10-22 Santa Clara 85 4590   43876
8044 8044 Mountain View Mountain View 2021-10-22 Santa Clara 85 3730   80993
8045 8045 Palo Alto Palo Alto 2021-10-22 Santa Clara 85 1986   67019
8046 8046 San Jose San Jose 2021-10-22 Santa Clara 85 92893   1026658
8047 8047 Santa Clara Santa Clara 2021-10-22 Santa Clara 85 6938   126209
8048 8048 Saratoga Saratoga 2021-10-22 Santa Clara 85 854   30886
8049 8049 Sunnyvale Sunnyvale 2021-10-22 Santa Clara 85 6896   152323
9400 9400 Campbell Campbell 2021-10-21 Santa Clara 85 2689   42470
9401 9401 Cupertino Cupertino 2021-10-21 Santa Clara 85 1217   60614
9402 9402 Gilroy Gilroy 2021-10-21 Santa Clara 85 8712   55525
9403 9403 Los Altos Los Altos 2021-10-21 Santa Clara 85 881   30588
9404 9404 Los Altos Hills Los Altos Hills 2021-10-21 Santa Clara 85 295   8517
9405 9405 Los Gatos Los Gatos 2021-10-21 Santa Clara 85 1623   30922
9406 9406 Milpitas Milpitas 2021-10-21 Santa Clara 85 4409   77457
9407 9407 Monte Sereno Monte Sereno 2021-10-21 Santa Clara 85 128   3492
9408 9408 Morgan Hill Morgan Hill 2021-10-21 Santa Clara 85 4590   43876
9409 9409 Mountain View Mountain View 2021-10-21 Santa Clara 85 3730   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
);