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

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

✎ View and edit SQL

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

fips

  • 85 5,505

county

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