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 · 11,495 ✖
county 1
- Santa Clara 11,495
Link | rowid | id | name | date ▲ | county | fips | confirmed_cases | note | population |
---|---|---|---|---|---|---|---|---|---|
286263 | 286263 | Palo Alto | Palo Alto | 2022-05-15 | Santa Clara | 85 | 6366 | 67019 | |
286264 | 286264 | San Jose | San Jose | 2022-05-15 | Santa Clara | 85 | 199718 | 1026658 | |
286265 | 286265 | Santa Clara | Santa Clara | 2022-05-15 | Santa Clara | 85 | 18137 | 126209 | |
286266 | 286266 | Saratoga | Saratoga | 2022-05-15 | Santa Clara | 85 | 2698 | 30886 | |
286267 | 286267 | Sunnyvale | Sunnyvale | 2022-05-15 | Santa Clara | 85 | 17515 | 152323 | |
287526 | 287526 | Campbell | Campbell | 2022-05-14 | Santa Clara | 85 | 6778 | 42470 | |
287527 | 287527 | Cupertino | Cupertino | 2022-05-14 | Santa Clara | 85 | 4786 | 60614 | |
287528 | 287528 | Gilroy | Gilroy | 2022-05-14 | Santa Clara | 85 | 15797 | 55525 | |
287529 | 287529 | Los Altos | Los Altos | 2022-05-14 | Santa Clara | 85 | 2919 | 30588 | |
287530 | 287530 | Los Altos Hills | Los Altos Hills | 2022-05-14 | Santa Clara | 85 | 806 | 8517 | |
287531 | 287531 | Los Gatos | Los Gatos | 2022-05-14 | Santa Clara | 85 | 4699 | 30922 | |
287532 | 287532 | Milpitas | Milpitas | 2022-05-14 | Santa Clara | 85 | 11070 | 77457 | |
287533 | 287533 | Monte Sereno | Monte Sereno | 2022-05-14 | Santa Clara | 85 | 374 | 3492 | |
287534 | 287534 | Morgan Hill | Morgan Hill | 2022-05-14 | Santa Clara | 85 | 9972 | 43876 | |
287535 | 287535 | Mountain View | Mountain View | 2022-05-14 | Santa Clara | 85 | 9116 | 80993 | |
287536 | 287536 | Palo Alto | Palo Alto | 2022-05-14 | Santa Clara | 85 | 6366 | 67019 | |
287537 | 287537 | San Jose | San Jose | 2022-05-14 | Santa Clara | 85 | 199718 | 1026658 | |
287538 | 287538 | Santa Clara | Santa Clara | 2022-05-14 | Santa Clara | 85 | 18137 | 126209 | |
287539 | 287539 | Saratoga | Saratoga | 2022-05-14 | Santa Clara | 85 | 2698 | 30886 | |
287540 | 287540 | Sunnyvale | Sunnyvale | 2022-05-14 | Santa Clara | 85 | 17515 | 152323 | |
288799 | 288799 | Campbell | Campbell | 2022-05-13 | Santa Clara | 85 | 6778 | 42470 | |
288800 | 288800 | Cupertino | Cupertino | 2022-05-13 | Santa Clara | 85 | 4786 | 60614 | |
288801 | 288801 | Gilroy | Gilroy | 2022-05-13 | Santa Clara | 85 | 15797 | 55525 | |
288802 | 288802 | Los Altos | Los Altos | 2022-05-13 | Santa Clara | 85 | 2919 | 30588 | |
288803 | 288803 | Los Altos Hills | Los Altos Hills | 2022-05-13 | Santa Clara | 85 | 806 | 8517 | |
288804 | 288804 | Los Gatos | Los Gatos | 2022-05-13 | Santa Clara | 85 | 4699 | 30922 | |
288805 | 288805 | Milpitas | Milpitas | 2022-05-13 | Santa Clara | 85 | 11070 | 77457 | |
288806 | 288806 | Monte Sereno | Monte Sereno | 2022-05-13 | Santa Clara | 85 | 374 | 3492 | |
288807 | 288807 | Morgan Hill | Morgan Hill | 2022-05-13 | Santa Clara | 85 | 9972 | 43876 | |
288808 | 288808 | Mountain View | Mountain View | 2022-05-13 | Santa Clara | 85 | 9116 | 80993 | |
288809 | 288809 | Palo Alto | Palo Alto | 2022-05-13 | Santa Clara | 85 | 6366 | 67019 | |
288810 | 288810 | San Jose | San Jose | 2022-05-13 | Santa Clara | 85 | 199718 | 1026658 | |
288811 | 288811 | Santa Clara | Santa Clara | 2022-05-13 | Santa Clara | 85 | 18137 | 126209 | |
288812 | 288812 | Saratoga | Saratoga | 2022-05-13 | Santa Clara | 85 | 2698 | 30886 | |
288813 | 288813 | Sunnyvale | Sunnyvale | 2022-05-13 | Santa Clara | 85 | 17515 | 152323 | |
290072 | 290072 | Campbell | Campbell | 2022-05-12 | Santa Clara | 85 | 6663 | 42470 | |
290073 | 290073 | Cupertino | Cupertino | 2022-05-12 | Santa Clara | 85 | 4611 | 60614 | |
290074 | 290074 | Gilroy | Gilroy | 2022-05-12 | Santa Clara | 85 | 15654 | 55525 | |
290075 | 290075 | Los Altos | Los Altos | 2022-05-12 | Santa Clara | 85 | 2815 | 30588 | |
290076 | 290076 | Los Altos Hills | Los Altos Hills | 2022-05-12 | Santa Clara | 85 | 785 | 8517 | |
290077 | 290077 | Los Gatos | Los Gatos | 2022-05-12 | Santa Clara | 85 | 4573 | 30922 | |
290078 | 290078 | Milpitas | Milpitas | 2022-05-12 | Santa Clara | 85 | 10853 | 77457 | |
290079 | 290079 | Monte Sereno | Monte Sereno | 2022-05-12 | Santa Clara | 85 | 369 | 3492 | |
290080 | 290080 | Morgan Hill | Morgan Hill | 2022-05-12 | Santa Clara | 85 | 9835 | 43876 | |
290081 | 290081 | Mountain View | Mountain View | 2022-05-12 | Santa Clara | 85 | 8910 | 80993 | |
290082 | 290082 | Palo Alto | Palo Alto | 2022-05-12 | Santa Clara | 85 | 6161 | 67019 | |
290083 | 290083 | San Jose | San Jose | 2022-05-12 | Santa Clara | 85 | 196991 | 1026658 | |
290084 | 290084 | Santa Clara | Santa Clara | 2022-05-12 | Santa Clara | 85 | 17819 | 126209 | |
290085 | 290085 | Saratoga | Saratoga | 2022-05-12 | Santa Clara | 85 | 2596 | 30886 | |
290086 | 290086 | Sunnyvale | Sunnyvale | 2022-05-12 | Santa Clara | 85 | 17197 | 152323 | |
291345 | 291345 | Campbell | Campbell | 2022-05-11 | Santa Clara | 85 | 6663 | 42470 | |
291346 | 291346 | Cupertino | Cupertino | 2022-05-11 | Santa Clara | 85 | 4611 | 60614 | |
291347 | 291347 | Gilroy | Gilroy | 2022-05-11 | Santa Clara | 85 | 15654 | 55525 | |
291348 | 291348 | Los Altos | Los Altos | 2022-05-11 | Santa Clara | 85 | 2815 | 30588 | |
291349 | 291349 | Los Altos Hills | Los Altos Hills | 2022-05-11 | Santa Clara | 85 | 785 | 8517 | |
291350 | 291350 | Los Gatos | Los Gatos | 2022-05-11 | Santa Clara | 85 | 4573 | 30922 | |
291351 | 291351 | Milpitas | Milpitas | 2022-05-11 | Santa Clara | 85 | 10853 | 77457 | |
291352 | 291352 | Monte Sereno | Monte Sereno | 2022-05-11 | Santa Clara | 85 | 369 | 3492 | |
291353 | 291353 | Morgan Hill | Morgan Hill | 2022-05-11 | Santa Clara | 85 | 9835 | 43876 | |
291354 | 291354 | Mountain View | Mountain View | 2022-05-11 | Santa Clara | 85 | 8910 | 80993 | |
291355 | 291355 | Palo Alto | Palo Alto | 2022-05-11 | Santa Clara | 85 | 6161 | 67019 | |
291356 | 291356 | San Jose | San Jose | 2022-05-11 | Santa Clara | 85 | 196991 | 1026658 | |
291357 | 291357 | Santa Clara | Santa Clara | 2022-05-11 | Santa Clara | 85 | 17819 | 126209 | |
291358 | 291358 | Saratoga | Saratoga | 2022-05-11 | Santa Clara | 85 | 2596 | 30886 | |
291359 | 291359 | Sunnyvale | Sunnyvale | 2022-05-11 | Santa Clara | 85 | 17197 | 152323 | |
292618 | 292618 | Campbell | Campbell | 2022-05-10 | Santa Clara | 85 | 6663 | 42470 | |
292619 | 292619 | Cupertino | Cupertino | 2022-05-10 | Santa Clara | 85 | 4611 | 60614 | |
292620 | 292620 | Gilroy | Gilroy | 2022-05-10 | Santa Clara | 85 | 15654 | 55525 | |
292621 | 292621 | Los Altos | Los Altos | 2022-05-10 | Santa Clara | 85 | 2815 | 30588 | |
292622 | 292622 | Los Altos Hills | Los Altos Hills | 2022-05-10 | Santa Clara | 85 | 785 | 8517 | |
292623 | 292623 | Los Gatos | Los Gatos | 2022-05-10 | Santa Clara | 85 | 4573 | 30922 | |
292624 | 292624 | Milpitas | Milpitas | 2022-05-10 | Santa Clara | 85 | 10853 | 77457 | |
292625 | 292625 | Monte Sereno | Monte Sereno | 2022-05-10 | Santa Clara | 85 | 369 | 3492 | |
292626 | 292626 | Morgan Hill | Morgan Hill | 2022-05-10 | Santa Clara | 85 | 9835 | 43876 | |
292627 | 292627 | Mountain View | Mountain View | 2022-05-10 | Santa Clara | 85 | 8910 | 80993 | |
292628 | 292628 | Palo Alto | Palo Alto | 2022-05-10 | Santa Clara | 85 | 6161 | 67019 | |
292629 | 292629 | San Jose | San Jose | 2022-05-10 | Santa Clara | 85 | 196991 | 1026658 | |
292630 | 292630 | Santa Clara | Santa Clara | 2022-05-10 | Santa Clara | 85 | 17819 | 126209 | |
292631 | 292631 | Saratoga | Saratoga | 2022-05-10 | Santa Clara | 85 | 2596 | 30886 | |
292632 | 292632 | Sunnyvale | Sunnyvale | 2022-05-10 | Santa Clara | 85 | 17197 | 152323 | |
293891 | 293891 | Campbell | Campbell | 2022-05-09 | Santa Clara | 85 | 6663 | 42470 | |
293892 | 293892 | Cupertino | Cupertino | 2022-05-09 | Santa Clara | 85 | 4611 | 60614 | |
293893 | 293893 | Gilroy | Gilroy | 2022-05-09 | Santa Clara | 85 | 15654 | 55525 | |
293894 | 293894 | Los Altos | Los Altos | 2022-05-09 | Santa Clara | 85 | 2815 | 30588 | |
293895 | 293895 | Los Altos Hills | Los Altos Hills | 2022-05-09 | Santa Clara | 85 | 785 | 8517 | |
293896 | 293896 | Los Gatos | Los Gatos | 2022-05-09 | Santa Clara | 85 | 4573 | 30922 | |
293897 | 293897 | Milpitas | Milpitas | 2022-05-09 | Santa Clara | 85 | 10853 | 77457 | |
293898 | 293898 | Monte Sereno | Monte Sereno | 2022-05-09 | Santa Clara | 85 | 369 | 3492 | |
293899 | 293899 | Morgan Hill | Morgan Hill | 2022-05-09 | Santa Clara | 85 | 9835 | 43876 | |
293900 | 293900 | Mountain View | Mountain View | 2022-05-09 | Santa Clara | 85 | 8910 | 80993 | |
293901 | 293901 | Palo Alto | Palo Alto | 2022-05-09 | Santa Clara | 85 | 6161 | 67019 | |
293902 | 293902 | San Jose | San Jose | 2022-05-09 | Santa Clara | 85 | 196991 | 1026658 | |
293903 | 293903 | Santa Clara | Santa Clara | 2022-05-09 | Santa Clara | 85 | 17819 | 126209 | |
293904 | 293904 | Saratoga | Saratoga | 2022-05-09 | Santa Clara | 85 | 2596 | 30886 | |
293905 | 293905 | Sunnyvale | Sunnyvale | 2022-05-09 | Santa Clara | 85 | 17197 | 152323 | |
295164 | 295164 | Campbell | Campbell | 2022-05-08 | Santa Clara | 85 | 6663 | 42470 | |
295165 | 295165 | Cupertino | Cupertino | 2022-05-08 | Santa Clara | 85 | 4611 | 60614 | |
295166 | 295166 | Gilroy | Gilroy | 2022-05-08 | Santa Clara | 85 | 15654 | 55525 | |
295167 | 295167 | Los Altos | Los Altos | 2022-05-08 | Santa Clara | 85 | 2815 | 30588 | |
295168 | 295168 | Los Altos Hills | Los Altos Hills | 2022-05-08 | Santa Clara | 85 | 785 | 8517 |
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 );