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 · 8,415 ✖
county 1
- Santa Clara 8,415
Link | rowid | id | name | date ▲ | county | fips | confirmed_cases | note | population |
---|---|---|---|---|---|---|---|---|---|
548033 | 548033 | Campbell | Campbell | 2021-10-21 | Santa Clara | 85 | 2689 | 42470 | |
548034 | 548034 | Cupertino | Cupertino | 2021-10-21 | Santa Clara | 85 | 1217 | 60614 | |
548035 | 548035 | Gilroy | Gilroy | 2021-10-21 | Santa Clara | 85 | 8712 | 55525 | |
548036 | 548036 | Los Altos | Los Altos | 2021-10-21 | Santa Clara | 85 | 881 | 30588 | |
548037 | 548037 | Los Altos Hills | Los Altos Hills | 2021-10-21 | Santa Clara | 85 | 295 | 8517 | |
548038 | 548038 | Los Gatos | Los Gatos | 2021-10-21 | Santa Clara | 85 | 1623 | 30922 | |
548039 | 548039 | Milpitas | Milpitas | 2021-10-21 | Santa Clara | 85 | 4409 | 77457 | |
548040 | 548040 | Monte Sereno | Monte Sereno | 2021-10-21 | Santa Clara | 85 | 128 | 3492 | |
548041 | 548041 | Morgan Hill | Morgan Hill | 2021-10-21 | Santa Clara | 85 | 4590 | 43876 | |
548042 | 548042 | Mountain View | Mountain View | 2021-10-21 | Santa Clara | 85 | 3730 | 80993 | |
548043 | 548043 | Palo Alto | Palo Alto | 2021-10-21 | Santa Clara | 85 | 1986 | 67019 | |
548044 | 548044 | San Jose | San Jose | 2021-10-21 | Santa Clara | 85 | 92893 | 1026658 | |
548045 | 548045 | Santa Clara | Santa Clara | 2021-10-21 | Santa Clara | 85 | 6938 | 126209 | |
548046 | 548046 | Saratoga | Saratoga | 2021-10-21 | Santa Clara | 85 | 854 | 30886 | |
548047 | 548047 | Sunnyvale | Sunnyvale | 2021-10-21 | Santa Clara | 85 | 6896 | 152323 | |
549309 | 549309 | Campbell | Campbell | 2021-10-20 | Santa Clara | 85 | 2689 | 42470 | |
549310 | 549310 | Cupertino | Cupertino | 2021-10-20 | Santa Clara | 85 | 1217 | 60614 | |
549311 | 549311 | Gilroy | Gilroy | 2021-10-20 | Santa Clara | 85 | 8712 | 55525 | |
549312 | 549312 | Los Altos | Los Altos | 2021-10-20 | Santa Clara | 85 | 881 | 30588 | |
549313 | 549313 | Los Altos Hills | Los Altos Hills | 2021-10-20 | Santa Clara | 85 | 295 | 8517 | |
549314 | 549314 | Los Gatos | Los Gatos | 2021-10-20 | Santa Clara | 85 | 1623 | 30922 | |
549315 | 549315 | Milpitas | Milpitas | 2021-10-20 | Santa Clara | 85 | 4409 | 77457 | |
549316 | 549316 | Monte Sereno | Monte Sereno | 2021-10-20 | Santa Clara | 85 | 128 | 3492 | |
549317 | 549317 | Morgan Hill | Morgan Hill | 2021-10-20 | Santa Clara | 85 | 4590 | 43876 | |
549318 | 549318 | Mountain View | Mountain View | 2021-10-20 | Santa Clara | 85 | 3730 | 80993 | |
549319 | 549319 | Palo Alto | Palo Alto | 2021-10-20 | Santa Clara | 85 | 1986 | 67019 | |
549320 | 549320 | San Jose | San Jose | 2021-10-20 | Santa Clara | 85 | 92893 | 1026658 | |
549321 | 549321 | Santa Clara | Santa Clara | 2021-10-20 | Santa Clara | 85 | 6938 | 126209 | |
549322 | 549322 | Saratoga | Saratoga | 2021-10-20 | Santa Clara | 85 | 854 | 30886 | |
549323 | 549323 | Sunnyvale | Sunnyvale | 2021-10-20 | Santa Clara | 85 | 6896 | 152323 | |
550585 | 550585 | Campbell | Campbell | 2021-10-19 | Santa Clara | 85 | 2689 | 42470 | |
550586 | 550586 | Cupertino | Cupertino | 2021-10-19 | Santa Clara | 85 | 1217 | 60614 | |
550587 | 550587 | Gilroy | Gilroy | 2021-10-19 | Santa Clara | 85 | 8712 | 55525 | |
550588 | 550588 | Los Altos | Los Altos | 2021-10-19 | Santa Clara | 85 | 881 | 30588 | |
550589 | 550589 | Los Altos Hills | Los Altos Hills | 2021-10-19 | Santa Clara | 85 | 295 | 8517 | |
550590 | 550590 | Los Gatos | Los Gatos | 2021-10-19 | Santa Clara | 85 | 1623 | 30922 | |
550591 | 550591 | Milpitas | Milpitas | 2021-10-19 | Santa Clara | 85 | 4409 | 77457 | |
550592 | 550592 | Monte Sereno | Monte Sereno | 2021-10-19 | Santa Clara | 85 | 128 | 3492 | |
550593 | 550593 | Morgan Hill | Morgan Hill | 2021-10-19 | Santa Clara | 85 | 4590 | 43876 | |
550594 | 550594 | Mountain View | Mountain View | 2021-10-19 | Santa Clara | 85 | 3730 | 80993 | |
550595 | 550595 | Palo Alto | Palo Alto | 2021-10-19 | Santa Clara | 85 | 1986 | 67019 | |
550596 | 550596 | San Jose | San Jose | 2021-10-19 | Santa Clara | 85 | 92893 | 1026658 | |
550597 | 550597 | Santa Clara | Santa Clara | 2021-10-19 | Santa Clara | 85 | 6938 | 126209 | |
550598 | 550598 | Saratoga | Saratoga | 2021-10-19 | Santa Clara | 85 | 854 | 30886 | |
550599 | 550599 | Sunnyvale | Sunnyvale | 2021-10-19 | Santa Clara | 85 | 6896 | 152323 | |
551861 | 551861 | Campbell | Campbell | 2021-10-18 | Santa Clara | 85 | 2689 | 42470 | |
551862 | 551862 | Cupertino | Cupertino | 2021-10-18 | Santa Clara | 85 | 1217 | 60614 | |
551863 | 551863 | Gilroy | Gilroy | 2021-10-18 | Santa Clara | 85 | 8712 | 55525 | |
551864 | 551864 | Los Altos | Los Altos | 2021-10-18 | Santa Clara | 85 | 881 | 30588 | |
551865 | 551865 | Los Altos Hills | Los Altos Hills | 2021-10-18 | Santa Clara | 85 | 295 | 8517 | |
551866 | 551866 | Los Gatos | Los Gatos | 2021-10-18 | Santa Clara | 85 | 1623 | 30922 | |
551867 | 551867 | Milpitas | Milpitas | 2021-10-18 | Santa Clara | 85 | 4409 | 77457 | |
551868 | 551868 | Monte Sereno | Monte Sereno | 2021-10-18 | Santa Clara | 85 | 128 | 3492 | |
551869 | 551869 | Morgan Hill | Morgan Hill | 2021-10-18 | Santa Clara | 85 | 4590 | 43876 | |
551870 | 551870 | Mountain View | Mountain View | 2021-10-18 | Santa Clara | 85 | 3730 | 80993 | |
551871 | 551871 | Palo Alto | Palo Alto | 2021-10-18 | Santa Clara | 85 | 1986 | 67019 | |
551872 | 551872 | San Jose | San Jose | 2021-10-18 | Santa Clara | 85 | 92893 | 1026658 | |
551873 | 551873 | Santa Clara | Santa Clara | 2021-10-18 | Santa Clara | 85 | 6938 | 126209 | |
551874 | 551874 | Saratoga | Saratoga | 2021-10-18 | Santa Clara | 85 | 854 | 30886 | |
551875 | 551875 | Sunnyvale | Sunnyvale | 2021-10-18 | Santa Clara | 85 | 6896 | 152323 | |
553137 | 553137 | Campbell | Campbell | 2021-10-17 | Santa Clara | 85 | 2689 | 42470 | |
553138 | 553138 | Cupertino | Cupertino | 2021-10-17 | Santa Clara | 85 | 1217 | 60614 | |
553139 | 553139 | Gilroy | Gilroy | 2021-10-17 | Santa Clara | 85 | 8712 | 55525 | |
553140 | 553140 | Los Altos | Los Altos | 2021-10-17 | Santa Clara | 85 | 881 | 30588 | |
553141 | 553141 | Los Altos Hills | Los Altos Hills | 2021-10-17 | Santa Clara | 85 | 295 | 8517 | |
553142 | 553142 | Los Gatos | Los Gatos | 2021-10-17 | Santa Clara | 85 | 1623 | 30922 | |
553143 | 553143 | Milpitas | Milpitas | 2021-10-17 | Santa Clara | 85 | 4409 | 77457 | |
553144 | 553144 | Monte Sereno | Monte Sereno | 2021-10-17 | Santa Clara | 85 | 128 | 3492 | |
553145 | 553145 | Morgan Hill | Morgan Hill | 2021-10-17 | Santa Clara | 85 | 4590 | 43876 | |
553146 | 553146 | Mountain View | Mountain View | 2021-10-17 | Santa Clara | 85 | 3730 | 80993 | |
553147 | 553147 | Palo Alto | Palo Alto | 2021-10-17 | Santa Clara | 85 | 1986 | 67019 | |
553148 | 553148 | San Jose | San Jose | 2021-10-17 | Santa Clara | 85 | 92893 | 1026658 | |
553149 | 553149 | Santa Clara | Santa Clara | 2021-10-17 | Santa Clara | 85 | 6938 | 126209 | |
553150 | 553150 | Saratoga | Saratoga | 2021-10-17 | Santa Clara | 85 | 854 | 30886 | |
553151 | 553151 | Sunnyvale | Sunnyvale | 2021-10-17 | Santa Clara | 85 | 6896 | 152323 | |
554413 | 554413 | Campbell | Campbell | 2021-10-16 | Santa Clara | 85 | 2689 | 42470 | |
554414 | 554414 | Cupertino | Cupertino | 2021-10-16 | Santa Clara | 85 | 1217 | 60614 | |
554415 | 554415 | Gilroy | Gilroy | 2021-10-16 | Santa Clara | 85 | 8712 | 55525 | |
554416 | 554416 | Los Altos | Los Altos | 2021-10-16 | Santa Clara | 85 | 881 | 30588 | |
554417 | 554417 | Los Altos Hills | Los Altos Hills | 2021-10-16 | Santa Clara | 85 | 295 | 8517 | |
554418 | 554418 | Los Gatos | Los Gatos | 2021-10-16 | Santa Clara | 85 | 1623 | 30922 | |
554419 | 554419 | Milpitas | Milpitas | 2021-10-16 | Santa Clara | 85 | 4409 | 77457 | |
554420 | 554420 | Monte Sereno | Monte Sereno | 2021-10-16 | Santa Clara | 85 | 128 | 3492 | |
554421 | 554421 | Morgan Hill | Morgan Hill | 2021-10-16 | Santa Clara | 85 | 4590 | 43876 | |
554422 | 554422 | Mountain View | Mountain View | 2021-10-16 | Santa Clara | 85 | 3730 | 80993 | |
554423 | 554423 | Palo Alto | Palo Alto | 2021-10-16 | Santa Clara | 85 | 1986 | 67019 | |
554424 | 554424 | San Jose | San Jose | 2021-10-16 | Santa Clara | 85 | 92893 | 1026658 | |
554425 | 554425 | Santa Clara | Santa Clara | 2021-10-16 | Santa Clara | 85 | 6938 | 126209 | |
554426 | 554426 | Saratoga | Saratoga | 2021-10-16 | Santa Clara | 85 | 854 | 30886 | |
554427 | 554427 | Sunnyvale | Sunnyvale | 2021-10-16 | Santa Clara | 85 | 6896 | 152323 | |
555689 | 555689 | Campbell | Campbell | 2021-10-15 | Santa Clara | 85 | 2689 | 42470 | |
555690 | 555690 | Cupertino | Cupertino | 2021-10-15 | Santa Clara | 85 | 1217 | 60614 | |
555691 | 555691 | Gilroy | Gilroy | 2021-10-15 | Santa Clara | 85 | 8712 | 55525 | |
555692 | 555692 | Los Altos | Los Altos | 2021-10-15 | Santa Clara | 85 | 881 | 30588 | |
555693 | 555693 | Los Altos Hills | Los Altos Hills | 2021-10-15 | Santa Clara | 85 | 295 | 8517 | |
555694 | 555694 | Los Gatos | Los Gatos | 2021-10-15 | Santa Clara | 85 | 1623 | 30922 | |
555695 | 555695 | Milpitas | Milpitas | 2021-10-15 | Santa Clara | 85 | 4409 | 77457 | |
555696 | 555696 | Monte Sereno | Monte Sereno | 2021-10-15 | Santa Clara | 85 | 128 | 3492 | |
555697 | 555697 | Morgan Hill | Morgan Hill | 2021-10-15 | Santa Clara | 85 | 4590 | 43876 | |
555698 | 555698 | Mountain View | Mountain View | 2021-10-15 | Santa Clara | 85 | 3730 | 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 );