latimes_place_totals
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
This data as json, yaml, Notebook, copyable, CSV (advanced)
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 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [latimes_place_totals] ( [id] TEXT, [name] TEXT, [date] TEXT, [county] TEXT, [fips] INTEGER, [confirmed_cases] INTEGER, [note] TEXT, [population] TEXT );