latimes_place_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_place_totals
14,940 rows where fips = 85 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 1
- 85 · 2,940 ✖
county 1
- Santa Clara 2,940
Link | rowid | id | name | date ▲ | county | fips | confirmed_cases | note | population |
---|---|---|---|---|---|---|---|---|---|
1009222 | 1009222 | Campbell | Campbell | 2020-10-21 | Santa Clara | 85 | 416 | 42470 | |
1009223 | 1009223 | Cupertino | Cupertino | 2020-10-21 | Santa Clara | 85 | 141 | 60614 | |
1009224 | 1009224 | Gilroy | Gilroy | 2020-10-21 | Santa Clara | 85 | 1667 | 55525 | |
1009225 | 1009225 | Los Altos | Los Altos | 2020-10-21 | Santa Clara | 85 | 131 | 30588 | |
1009226 | 1009226 | Los Altos Hills | Los Altos Hills | 2020-10-21 | Santa Clara | 85 | 38 | 8517 | |
1009227 | 1009227 | Los Gatos | Los Gatos | 2020-10-21 | Santa Clara | 85 | 197 | 30922 | |
1009228 | 1009228 | Milpitas | Milpitas | 2020-10-21 | Santa Clara | 85 | 616 | 77457 | |
1009229 | 1009229 | Monte Sereno | Monte Sereno | 2020-10-21 | Santa Clara | 85 | 19 | 3492 | |
1009230 | 1009230 | Morgan Hill | Morgan Hill | 2020-10-21 | Santa Clara | 85 | 654 | 43876 | |
1009231 | 1009231 | Mountain View | Mountain View | 2020-10-21 | Santa Clara | 85 | 643 | 80993 | |
1009232 | 1009232 | Palo Alto | Palo Alto | 2020-10-21 | Santa Clara | 85 | 322 | 67019 | |
1009233 | 1009233 | San Jose | San Jose | 2020-10-21 | Santa Clara | 85 | 15551 | 1026658 | |
1009234 | 1009234 | Santa Clara | Santa Clara | 2020-10-21 | Santa Clara | 85 | 1121 | 126209 | |
1009235 | 1009235 | Saratoga | Saratoga | 2020-10-21 | Santa Clara | 85 | 127 | 30886 | |
1009236 | 1009236 | Sunnyvale | Sunnyvale | 2020-10-21 | Santa Clara | 85 | 1041 | 152323 | |
1010433 | 1010433 | Campbell | Campbell | 2020-10-20 | Santa Clara | 85 | 414 | 42470 | |
1010434 | 1010434 | Cupertino | Cupertino | 2020-10-20 | Santa Clara | 85 | 140 | 60614 | |
1010435 | 1010435 | Gilroy | Gilroy | 2020-10-20 | Santa Clara | 85 | 1659 | 55525 | |
1010436 | 1010436 | Los Altos | Los Altos | 2020-10-20 | Santa Clara | 85 | 131 | 30588 | |
1010437 | 1010437 | Los Altos Hills | Los Altos Hills | 2020-10-20 | Santa Clara | 85 | 38 | 8517 | |
1010438 | 1010438 | Los Gatos | Los Gatos | 2020-10-20 | Santa Clara | 85 | 199 | 30922 | |
1010439 | 1010439 | Milpitas | Milpitas | 2020-10-20 | Santa Clara | 85 | 614 | 77457 | |
1010440 | 1010440 | Monte Sereno | Monte Sereno | 2020-10-20 | Santa Clara | 85 | 19 | 3492 | |
1010441 | 1010441 | Morgan Hill | Morgan Hill | 2020-10-20 | Santa Clara | 85 | 653 | 43876 | |
1010442 | 1010442 | Mountain View | Mountain View | 2020-10-20 | Santa Clara | 85 | 638 | 80993 | |
1010443 | 1010443 | Palo Alto | Palo Alto | 2020-10-20 | Santa Clara | 85 | 320 | 67019 | |
1010444 | 1010444 | San Jose | San Jose | 2020-10-20 | Santa Clara | 85 | 15450 | 1026658 | |
1010445 | 1010445 | Santa Clara | Santa Clara | 2020-10-20 | Santa Clara | 85 | 1115 | 126209 | |
1010446 | 1010446 | Saratoga | Saratoga | 2020-10-20 | Santa Clara | 85 | 126 | 30886 | |
1010447 | 1010447 | Sunnyvale | Sunnyvale | 2020-10-20 | Santa Clara | 85 | 1038 | 152323 | |
1011644 | 1011644 | Campbell | Campbell | 2020-10-19 | Santa Clara | 85 | 411 | 42470 | |
1011645 | 1011645 | Cupertino | Cupertino | 2020-10-19 | Santa Clara | 85 | 138 | 60614 | |
1011646 | 1011646 | Gilroy | Gilroy | 2020-10-19 | Santa Clara | 85 | 1655 | 55525 | |
1011647 | 1011647 | Los Altos | Los Altos | 2020-10-19 | Santa Clara | 85 | 129 | 30588 | |
1011648 | 1011648 | Los Altos Hills | Los Altos Hills | 2020-10-19 | Santa Clara | 85 | 38 | 8517 | |
1011649 | 1011649 | Los Gatos | Los Gatos | 2020-10-19 | Santa Clara | 85 | 197 | 30922 | |
1011650 | 1011650 | Milpitas | Milpitas | 2020-10-19 | Santa Clara | 85 | 614 | 77457 | |
1011651 | 1011651 | Monte Sereno | Monte Sereno | 2020-10-19 | Santa Clara | 85 | 19 | 3492 | |
1011652 | 1011652 | Morgan Hill | Morgan Hill | 2020-10-19 | Santa Clara | 85 | 650 | 43876 | |
1011653 | 1011653 | Mountain View | Mountain View | 2020-10-19 | Santa Clara | 85 | 633 | 80993 | |
1011654 | 1011654 | Palo Alto | Palo Alto | 2020-10-19 | Santa Clara | 85 | 320 | 67019 | |
1011655 | 1011655 | San Jose | San Jose | 2020-10-19 | Santa Clara | 85 | 15379 | 1026658 | |
1011656 | 1011656 | Santa Clara | Santa Clara | 2020-10-19 | Santa Clara | 85 | 1110 | 126209 | |
1011657 | 1011657 | Saratoga | Saratoga | 2020-10-19 | Santa Clara | 85 | 125 | 30886 | |
1011658 | 1011658 | Sunnyvale | Sunnyvale | 2020-10-19 | Santa Clara | 85 | 1032 | 152323 | |
1012840 | 1012840 | Campbell | Campbell | 2020-10-18 | Santa Clara | 85 | 400 | 42470 | |
1012841 | 1012841 | Cupertino | Cupertino | 2020-10-18 | Santa Clara | 85 | 138 | 60614 | |
1012842 | 1012842 | Gilroy | Gilroy | 2020-10-18 | Santa Clara | 85 | 1649 | 55525 | |
1012843 | 1012843 | Los Altos | Los Altos | 2020-10-18 | Santa Clara | 85 | 128 | 30588 | |
1012844 | 1012844 | Los Altos Hills | Los Altos Hills | 2020-10-18 | Santa Clara | 85 | 37 | 8517 | |
1012845 | 1012845 | Los Gatos | Los Gatos | 2020-10-18 | Santa Clara | 85 | 196 | 30922 | |
1012846 | 1012846 | Milpitas | Milpitas | 2020-10-18 | Santa Clara | 85 | 613 | 77457 | |
1012847 | 1012847 | Monte Sereno | Monte Sereno | 2020-10-18 | Santa Clara | 85 | 19 | 3492 | |
1012848 | 1012848 | Morgan Hill | Morgan Hill | 2020-10-18 | Santa Clara | 85 | 647 | 43876 | |
1012849 | 1012849 | Mountain View | Mountain View | 2020-10-18 | Santa Clara | 85 | 628 | 80993 | |
1012850 | 1012850 | Palo Alto | Palo Alto | 2020-10-18 | Santa Clara | 85 | 320 | 67019 | |
1012851 | 1012851 | San Jose | San Jose | 2020-10-18 | Santa Clara | 85 | 15305 | 1026658 | |
1012852 | 1012852 | Santa Clara | Santa Clara | 2020-10-18 | Santa Clara | 85 | 1099 | 126209 | |
1012853 | 1012853 | Saratoga | Saratoga | 2020-10-18 | Santa Clara | 85 | 123 | 30886 | |
1012854 | 1012854 | Sunnyvale | Sunnyvale | 2020-10-18 | Santa Clara | 85 | 1027 | 152323 | |
1014032 | 1014032 | Campbell | Campbell | 2020-10-17 | Santa Clara | 85 | 377 | 42470 | |
1014033 | 1014033 | Cupertino | Cupertino | 2020-10-17 | Santa Clara | 85 | 137 | 60614 | |
1014034 | 1014034 | Gilroy | Gilroy | 2020-10-17 | Santa Clara | 85 | 1643 | 55525 | |
1014035 | 1014035 | Los Altos | Los Altos | 2020-10-17 | Santa Clara | 85 | 128 | 30588 | |
1014036 | 1014036 | Los Altos Hills | Los Altos Hills | 2020-10-17 | Santa Clara | 85 | 37 | 8517 | |
1014037 | 1014037 | Los Gatos | Los Gatos | 2020-10-17 | Santa Clara | 85 | 193 | 30922 | |
1014038 | 1014038 | Milpitas | Milpitas | 2020-10-17 | Santa Clara | 85 | 607 | 77457 | |
1014039 | 1014039 | Monte Sereno | Monte Sereno | 2020-10-17 | Santa Clara | 85 | 19 | 3492 | |
1014040 | 1014040 | Morgan Hill | Morgan Hill | 2020-10-17 | Santa Clara | 85 | 642 | 43876 | |
1014041 | 1014041 | Mountain View | Mountain View | 2020-10-17 | Santa Clara | 85 | 624 | 80993 | |
1014042 | 1014042 | Palo Alto | Palo Alto | 2020-10-17 | Santa Clara | 85 | 316 | 67019 | |
1014043 | 1014043 | San Jose | San Jose | 2020-10-17 | Santa Clara | 85 | 15215 | 1026658 | |
1014044 | 1014044 | Santa Clara | Santa Clara | 2020-10-17 | Santa Clara | 85 | 1085 | 126209 | |
1014045 | 1014045 | Saratoga | Saratoga | 2020-10-17 | Santa Clara | 85 | 123 | 30886 | |
1014046 | 1014046 | Sunnyvale | Sunnyvale | 2020-10-17 | Santa Clara | 85 | 1028 | 152323 | |
1015224 | 1015224 | Campbell | Campbell | 2020-10-16 | Santa Clara | 85 | 377 | 42470 | |
1015225 | 1015225 | Cupertino | Cupertino | 2020-10-16 | Santa Clara | 85 | 137 | 60614 | |
1015226 | 1015226 | Gilroy | Gilroy | 2020-10-16 | Santa Clara | 85 | 1636 | 55525 | |
1015227 | 1015227 | Los Altos | Los Altos | 2020-10-16 | Santa Clara | 85 | 127 | 30588 | |
1015228 | 1015228 | Los Altos Hills | Los Altos Hills | 2020-10-16 | Santa Clara | 85 | 37 | 8517 | |
1015229 | 1015229 | Los Gatos | Los Gatos | 2020-10-16 | Santa Clara | 85 | 192 | 30922 | |
1015230 | 1015230 | Milpitas | Milpitas | 2020-10-16 | Santa Clara | 85 | 605 | 77457 | |
1015231 | 1015231 | Monte Sereno | Monte Sereno | 2020-10-16 | Santa Clara | 85 | 19 | 3492 | |
1015232 | 1015232 | Morgan Hill | Morgan Hill | 2020-10-16 | Santa Clara | 85 | 643 | 43876 | |
1015233 | 1015233 | Mountain View | Mountain View | 2020-10-16 | Santa Clara | 85 | 622 | 80993 | |
1015234 | 1015234 | Palo Alto | Palo Alto | 2020-10-16 | Santa Clara | 85 | 315 | 67019 | |
1015235 | 1015235 | San Jose | San Jose | 2020-10-16 | Santa Clara | 85 | 15168 | 1026658 | |
1015236 | 1015236 | Santa Clara | Santa Clara | 2020-10-16 | Santa Clara | 85 | 1077 | 126209 | |
1015237 | 1015237 | Saratoga | Saratoga | 2020-10-16 | Santa Clara | 85 | 120 | 30886 | |
1015238 | 1015238 | Sunnyvale | Sunnyvale | 2020-10-16 | Santa Clara | 85 | 1022 | 152323 | |
1016416 | 1016416 | Campbell | Campbell | 2020-10-15 | Santa Clara | 85 | 375 | 42470 | |
1016417 | 1016417 | Cupertino | Cupertino | 2020-10-15 | Santa Clara | 85 | 136 | 60614 | |
1016418 | 1016418 | Gilroy | Gilroy | 2020-10-15 | Santa Clara | 85 | 1621 | 55525 | |
1016419 | 1016419 | Los Altos | Los Altos | 2020-10-15 | Santa Clara | 85 | 126 | 30588 | |
1016420 | 1016420 | Los Altos Hills | Los Altos Hills | 2020-10-15 | Santa Clara | 85 | 37 | 8517 | |
1016421 | 1016421 | Los Gatos | Los Gatos | 2020-10-15 | Santa Clara | 85 | 192 | 30922 | |
1016422 | 1016422 | Milpitas | Milpitas | 2020-10-15 | Santa Clara | 85 | 604 | 77457 | |
1016423 | 1016423 | Monte Sereno | Monte Sereno | 2020-10-15 | Santa Clara | 85 | 19 | 3492 | |
1016424 | 1016424 | Morgan Hill | Morgan Hill | 2020-10-15 | Santa Clara | 85 | 643 | 43876 | |
1016425 | 1016425 | Mountain View | Mountain View | 2020-10-15 | Santa Clara | 85 | 621 | 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 );