⚠️ 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

5,505 rows where county = "Santa Clara" sorted by date descending

View and edit SQL

fips

  • 85 5,505

county

  • Santa Clara · 5,505
Link rowid id name date ▲ county fips confirmed_cases note population
1212 Campbell Campbell 2021-04-10 Santa Clara 85 1999   42470
1213 Cupertino Cupertino 2021-04-10 Santa Clara 85 865   60614
1214 Gilroy Gilroy 2021-04-10 Santa Clara 85 7466   55525
1215 Los Altos Los Altos 2021-04-10 Santa Clara 85 650   30588
1216 Los Altos Hills Los Altos Hills 2021-04-10 Santa Clara 85 225   8517
1217 Los Gatos Los Gatos 2021-04-10 Santa Clara 85 1180   30922
1218 Milpitas Milpitas 2021-04-10 Santa Clara 85 3517   77457
1219 Monte Sereno Monte Sereno 2021-04-10 Santa Clara 85 91   3492
1220 Morgan Hill Morgan Hill 2021-04-10 Santa Clara 85 3546   43876
1221 Mountain View Mountain View 2021-04-10 Santa Clara 85 2955   80993
1222 Palo Alto Palo Alto 2021-04-10 Santa Clara 85 1445   67019
1223 San Jose San Jose 2021-04-10 Santa Clara 85 76044   1026658
1224 Santa Clara Santa Clara 2021-04-10 Santa Clara 85 5345   126209
1225 Saratoga Saratoga 2021-04-10 Santa Clara 85 624   30886
1226 Sunnyvale Sunnyvale 2021-04-10 Santa Clara 85 5398   152323
2579 Campbell Campbell 2021-04-09 Santa Clara 85 1999   42470
2580 Cupertino Cupertino 2021-04-09 Santa Clara 85 865   60614
2581 Gilroy Gilroy 2021-04-09 Santa Clara 85 7466   55525
2582 Los Altos Los Altos 2021-04-09 Santa Clara 85 650   30588
2583 Los Altos Hills Los Altos Hills 2021-04-09 Santa Clara 85 225   8517
2584 Los Gatos Los Gatos 2021-04-09 Santa Clara 85 1180   30922
2585 Milpitas Milpitas 2021-04-09 Santa Clara 85 3517   77457
2586 Monte Sereno Monte Sereno 2021-04-09 Santa Clara 85 91   3492
2587 Morgan Hill Morgan Hill 2021-04-09 Santa Clara 85 3546   43876
2588 Mountain View Mountain View 2021-04-09 Santa Clara 85 2955   80993
2589 Palo Alto Palo Alto 2021-04-09 Santa Clara 85 1445   67019
2590 San Jose San Jose 2021-04-09 Santa Clara 85 76044   1026658
2591 Santa Clara Santa Clara 2021-04-09 Santa Clara 85 5345   126209
2592 Saratoga Saratoga 2021-04-09 Santa Clara 85 624   30886
2593 Sunnyvale Sunnyvale 2021-04-09 Santa Clara 85 5398   152323
3949 Campbell Campbell 2021-04-08 Santa Clara 85 1973   42470
3950 Cupertino Cupertino 2021-04-08 Santa Clara 85 847   60614
3951 Gilroy Gilroy 2021-04-08 Santa Clara 85 7444   55525
3952 Los Altos Los Altos 2021-04-08 Santa Clara 85 649   30588
3953 Los Altos Hills Los Altos Hills 2021-04-08 Santa Clara 85 220   8517
3954 Los Gatos Los Gatos 2021-04-08 Santa Clara 85 1162   30922
3955 Milpitas Milpitas 2021-04-08 Santa Clara 85 3474   77457
3956 Monte Sereno Monte Sereno 2021-04-08 Santa Clara 85 87   3492
3957 Morgan Hill Morgan Hill 2021-04-08 Santa Clara 85 3523   43876
3958 Mountain View Mountain View 2021-04-08 Santa Clara 85 2933   80993
3959 Palo Alto Palo Alto 2021-04-08 Santa Clara 85 1434   67019
3960 San Jose San Jose 2021-04-08 Santa Clara 85 75540   1026658
3961 Santa Clara Santa Clara 2021-04-08 Santa Clara 85 5230   126209
3962 Saratoga Saratoga 2021-04-08 Santa Clara 85 613   30886
3963 Sunnyvale Sunnyvale 2021-04-08 Santa Clara 85 5355   152323
5319 Campbell Campbell 2021-04-07 Santa Clara 85 1973   42470
5320 Cupertino Cupertino 2021-04-07 Santa Clara 85 847   60614
5321 Gilroy Gilroy 2021-04-07 Santa Clara 85 7444   55525
5322 Los Altos Los Altos 2021-04-07 Santa Clara 85 649   30588
5323 Los Altos Hills Los Altos Hills 2021-04-07 Santa Clara 85 220   8517
5324 Los Gatos Los Gatos 2021-04-07 Santa Clara 85 1162   30922
5325 Milpitas Milpitas 2021-04-07 Santa Clara 85 3474   77457
5326 Monte Sereno Monte Sereno 2021-04-07 Santa Clara 85 87   3492
5327 Morgan Hill Morgan Hill 2021-04-07 Santa Clara 85 3523   43876
5328 Mountain View Mountain View 2021-04-07 Santa Clara 85 2933   80993
5329 Palo Alto Palo Alto 2021-04-07 Santa Clara 85 1434   67019
5330 San Jose San Jose 2021-04-07 Santa Clara 85 75540   1026658
5331 Santa Clara Santa Clara 2021-04-07 Santa Clara 85 5230   126209
5332 Saratoga Saratoga 2021-04-07 Santa Clara 85 613   30886
5333 Sunnyvale Sunnyvale 2021-04-07 Santa Clara 85 5355   152323
6691 Campbell Campbell 2021-04-06 Santa Clara 85 1973   42470
6692 Cupertino Cupertino 2021-04-06 Santa Clara 85 847   60614
6693 Gilroy Gilroy 2021-04-06 Santa Clara 85 7444   55525
6694 Los Altos Los Altos 2021-04-06 Santa Clara 85 649   30588
6695 Los Altos Hills Los Altos Hills 2021-04-06 Santa Clara 85 220   8517
6696 Los Gatos Los Gatos 2021-04-06 Santa Clara 85 1162   30922
6697 Milpitas Milpitas 2021-04-06 Santa Clara 85 3474   77457
6698 Monte Sereno Monte Sereno 2021-04-06 Santa Clara 85 87   3492
6699 Morgan Hill Morgan Hill 2021-04-06 Santa Clara 85 3523   43876
6700 Mountain View Mountain View 2021-04-06 Santa Clara 85 2933   80993
6701 Palo Alto Palo Alto 2021-04-06 Santa Clara 85 1434   67019
6702 San Jose San Jose 2021-04-06 Santa Clara 85 75540   1026658
6703 Santa Clara Santa Clara 2021-04-06 Santa Clara 85 5230   126209
6704 Saratoga Saratoga 2021-04-06 Santa Clara 85 613   30886
6705 Sunnyvale Sunnyvale 2021-04-06 Santa Clara 85 5355   152323
8067 Campbell Campbell 2021-04-05 Santa Clara 85 1973   42470
8068 Cupertino Cupertino 2021-04-05 Santa Clara 85 847   60614
8069 Gilroy Gilroy 2021-04-05 Santa Clara 85 7444   55525
8070 Los Altos Los Altos 2021-04-05 Santa Clara 85 649   30588
8071 Los Altos Hills Los Altos Hills 2021-04-05 Santa Clara 85 220   8517
8072 Los Gatos Los Gatos 2021-04-05 Santa Clara 85 1162   30922
8073 Milpitas Milpitas 2021-04-05 Santa Clara 85 3474   77457
8074 Monte Sereno Monte Sereno 2021-04-05 Santa Clara 85 87   3492
8075 Morgan Hill Morgan Hill 2021-04-05 Santa Clara 85 3523   43876
8076 Mountain View Mountain View 2021-04-05 Santa Clara 85 2933   80993
8077 Palo Alto Palo Alto 2021-04-05 Santa Clara 85 1434   67019
8078 San Jose San Jose 2021-04-05 Santa Clara 85 75540   1026658
8079 Santa Clara Santa Clara 2021-04-05 Santa Clara 85 5230   126209
8080 Saratoga Saratoga 2021-04-05 Santa Clara 85 613   30886
8081 Sunnyvale Sunnyvale 2021-04-05 Santa Clara 85 5355   152323
9443 Campbell Campbell 2021-04-04 Santa Clara 85 1973   42470
9444 Cupertino Cupertino 2021-04-04 Santa Clara 85 847   60614
9445 Gilroy Gilroy 2021-04-04 Santa Clara 85 7444   55525
9446 Los Altos Los Altos 2021-04-04 Santa Clara 85 649   30588
9447 Los Altos Hills Los Altos Hills 2021-04-04 Santa Clara 85 220   8517
9448 Los Gatos Los Gatos 2021-04-04 Santa Clara 85 1162   30922
9449 Milpitas Milpitas 2021-04-04 Santa Clara 85 3474   77457
9450 Monte Sereno Monte Sereno 2021-04-04 Santa Clara 85 87   3492
9451 Morgan Hill Morgan Hill 2021-04-04 Santa Clara 85 3523   43876
9452 Mountain View Mountain View 2021-04-04 Santa Clara 85 2933   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
);