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

14,940 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 14,940

county 1

  • Santa Clara · 14,940 ✖
Link rowid id name date ▲ county fips confirmed_cases note population
687 687 Campbell Campbell 2022-12-30 Santa Clara 85 9692   42470
688 688 Cupertino Cupertino 2022-12-30 Santa Clara 85 8212   60614
689 689 Gilroy Gilroy 2022-12-30 Santa Clara 85 20212   55525
690 690 Los Altos Los Altos 2022-12-30 Santa Clara 85 4785   30588
691 691 Los Altos Hills Los Altos Hills 2022-12-30 Santa Clara 85 1206   8517
692 692 Los Gatos Los Gatos 2022-12-30 Santa Clara 85 6652   30922
693 693 Milpitas Milpitas 2022-12-30 Santa Clara 85 16806   77457
694 694 Monte Sereno Monte Sereno 2022-12-30 Santa Clara 85 304   3492
695 695 Morgan Hill Morgan Hill 2022-12-30 Santa Clara 85 13349   43876
696 696 Mountain View Mountain View 2022-12-30 Santa Clara 85 13563   80993
697 697 Palo Alto Palo Alto 2022-12-30 Santa Clara 85 10470   67019
698 698 San Jose San Jose 2022-12-30 Santa Clara 85 279047   1026658
699 699 Santa Clara Santa Clara 2022-12-30 Santa Clara 85 26597   126209
700 700 Saratoga Saratoga 2022-12-30 Santa Clara 85 4390   30886
701 701 Sunnyvale Sunnyvale 2022-12-30 Santa Clara 85 26263   152323
1515 1515 Campbell Campbell 2022-12-29 Santa Clara 85 9692   42470
1516 1516 Cupertino Cupertino 2022-12-29 Santa Clara 85 8212   60614
1517 1517 Gilroy Gilroy 2022-12-29 Santa Clara 85 20212   55525
1518 1518 Los Altos Los Altos 2022-12-29 Santa Clara 85 4785   30588
1519 1519 Los Altos Hills Los Altos Hills 2022-12-29 Santa Clara 85 1206   8517
1520 1520 Los Gatos Los Gatos 2022-12-29 Santa Clara 85 6652   30922
1521 1521 Milpitas Milpitas 2022-12-29 Santa Clara 85 16806   77457
1522 1522 Monte Sereno Monte Sereno 2022-12-29 Santa Clara 85 304   3492
1523 1523 Morgan Hill Morgan Hill 2022-12-29 Santa Clara 85 13349   43876
1524 1524 Mountain View Mountain View 2022-12-29 Santa Clara 85 13563   80993
1525 1525 Palo Alto Palo Alto 2022-12-29 Santa Clara 85 10470   67019
1526 1526 San Jose San Jose 2022-12-29 Santa Clara 85 279047   1026658
1527 1527 Santa Clara Santa Clara 2022-12-29 Santa Clara 85 26597   126209
1528 1528 Saratoga Saratoga 2022-12-29 Santa Clara 85 4390   30886
1529 1529 Sunnyvale Sunnyvale 2022-12-29 Santa Clara 85 26263   152323
2696 2696 Campbell Campbell 2022-12-28 Santa Clara 85 9634   42470
2697 2697 Cupertino Cupertino 2022-12-28 Santa Clara 85 8162   60614
2698 2698 Gilroy Gilroy 2022-12-28 Santa Clara 85 20122   55525
2699 2699 Los Altos Los Altos 2022-12-28 Santa Clara 85 4769   30588
2700 2700 Los Altos Hills Los Altos Hills 2022-12-28 Santa Clara 85 1198   8517
2701 2701 Los Gatos Los Gatos 2022-12-28 Santa Clara 85 6610   30922
2702 2702 Milpitas Milpitas 2022-12-28 Santa Clara 85 16701   77457
2703 2703 Monte Sereno Monte Sereno 2022-12-28 Santa Clara 85 301   3492
2704 2704 Morgan Hill Morgan Hill 2022-12-28 Santa Clara 85 13280   43876
2705 2705 Mountain View Mountain View 2022-12-28 Santa Clara 85 13494   80993
2706 2706 Palo Alto Palo Alto 2022-12-28 Santa Clara 85 10432   67019
2707 2707 San Jose San Jose 2022-12-28 Santa Clara 85 277669   1026658
2708 2708 Santa Clara Santa Clara 2022-12-28 Santa Clara 85 26436   126209
2709 2709 Saratoga Saratoga 2022-12-28 Santa Clara 85 4361   30886
2710 2710 Sunnyvale Sunnyvale 2022-12-28 Santa Clara 85 26116   152323
3877 3877 Campbell Campbell 2022-12-27 Santa Clara 85 9634   42470
3878 3878 Cupertino Cupertino 2022-12-27 Santa Clara 85 8162   60614
3879 3879 Gilroy Gilroy 2022-12-27 Santa Clara 85 20122   55525
3880 3880 Los Altos Los Altos 2022-12-27 Santa Clara 85 4769   30588
3881 3881 Los Altos Hills Los Altos Hills 2022-12-27 Santa Clara 85 1198   8517
3882 3882 Los Gatos Los Gatos 2022-12-27 Santa Clara 85 6610   30922
3883 3883 Milpitas Milpitas 2022-12-27 Santa Clara 85 16701   77457
3884 3884 Monte Sereno Monte Sereno 2022-12-27 Santa Clara 85 301   3492
3885 3885 Morgan Hill Morgan Hill 2022-12-27 Santa Clara 85 13280   43876
3886 3886 Mountain View Mountain View 2022-12-27 Santa Clara 85 13494   80993
3887 3887 Palo Alto Palo Alto 2022-12-27 Santa Clara 85 10432   67019
3888 3888 San Jose San Jose 2022-12-27 Santa Clara 85 277669   1026658
3889 3889 Santa Clara Santa Clara 2022-12-27 Santa Clara 85 26436   126209
3890 3890 Saratoga Saratoga 2022-12-27 Santa Clara 85 4361   30886
3891 3891 Sunnyvale Sunnyvale 2022-12-27 Santa Clara 85 26116   152323
5058 5058 Campbell Campbell 2022-12-26 Santa Clara 85 9634   42470
5059 5059 Cupertino Cupertino 2022-12-26 Santa Clara 85 8162   60614
5060 5060 Gilroy Gilroy 2022-12-26 Santa Clara 85 20122   55525
5061 5061 Los Altos Los Altos 2022-12-26 Santa Clara 85 4769   30588
5062 5062 Los Altos Hills Los Altos Hills 2022-12-26 Santa Clara 85 1198   8517
5063 5063 Los Gatos Los Gatos 2022-12-26 Santa Clara 85 6610   30922
5064 5064 Milpitas Milpitas 2022-12-26 Santa Clara 85 16701   77457
5065 5065 Monte Sereno Monte Sereno 2022-12-26 Santa Clara 85 301   3492
5066 5066 Morgan Hill Morgan Hill 2022-12-26 Santa Clara 85 13280   43876
5067 5067 Mountain View Mountain View 2022-12-26 Santa Clara 85 13494   80993
5068 5068 Palo Alto Palo Alto 2022-12-26 Santa Clara 85 10432   67019
5069 5069 San Jose San Jose 2022-12-26 Santa Clara 85 277669   1026658
5070 5070 Santa Clara Santa Clara 2022-12-26 Santa Clara 85 26436   126209
5071 5071 Saratoga Saratoga 2022-12-26 Santa Clara 85 4361   30886
5072 5072 Sunnyvale Sunnyvale 2022-12-26 Santa Clara 85 26116   152323
6239 6239 Campbell Campbell 2022-12-25 Santa Clara 85 9634   42470
6240 6240 Cupertino Cupertino 2022-12-25 Santa Clara 85 8162   60614
6241 6241 Gilroy Gilroy 2022-12-25 Santa Clara 85 20122   55525
6242 6242 Los Altos Los Altos 2022-12-25 Santa Clara 85 4769   30588
6243 6243 Los Altos Hills Los Altos Hills 2022-12-25 Santa Clara 85 1198   8517
6244 6244 Los Gatos Los Gatos 2022-12-25 Santa Clara 85 6610   30922
6245 6245 Milpitas Milpitas 2022-12-25 Santa Clara 85 16701   77457
6246 6246 Monte Sereno Monte Sereno 2022-12-25 Santa Clara 85 301   3492
6247 6247 Morgan Hill Morgan Hill 2022-12-25 Santa Clara 85 13280   43876
6248 6248 Mountain View Mountain View 2022-12-25 Santa Clara 85 13494   80993
6249 6249 Palo Alto Palo Alto 2022-12-25 Santa Clara 85 10432   67019
6250 6250 San Jose San Jose 2022-12-25 Santa Clara 85 277669   1026658
6251 6251 Santa Clara Santa Clara 2022-12-25 Santa Clara 85 26436   126209
6252 6252 Saratoga Saratoga 2022-12-25 Santa Clara 85 4361   30886
6253 6253 Sunnyvale Sunnyvale 2022-12-25 Santa Clara 85 26116   152323
7420 7420 Campbell Campbell 2022-12-24 Santa Clara 85 9634   42470
7421 7421 Cupertino Cupertino 2022-12-24 Santa Clara 85 8162   60614
7422 7422 Gilroy Gilroy 2022-12-24 Santa Clara 85 20122   55525
7423 7423 Los Altos Los Altos 2022-12-24 Santa Clara 85 4769   30588
7424 7424 Los Altos Hills Los Altos Hills 2022-12-24 Santa Clara 85 1198   8517
7425 7425 Los Gatos Los Gatos 2022-12-24 Santa Clara 85 6610   30922
7426 7426 Milpitas Milpitas 2022-12-24 Santa Clara 85 16701   77457
7427 7427 Monte Sereno Monte Sereno 2022-12-24 Santa Clara 85 301   3492
7428 7428 Morgan Hill Morgan Hill 2022-12-24 Santa Clara 85 13280   43876
7429 7429 Mountain View Mountain View 2022-12-24 Santa Clara 85 13494   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
);