latimes_place_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_place_totals
15 rows where county = "Santa Clara", "date" is on date 2021-01-30 and fips = 85 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | id | name | date ▲ | county | fips | confirmed_cases | note | population |
---|---|---|---|---|---|---|---|---|---|
884897 | 884897 | Campbell | Campbell | 2021-01-30 | Santa Clara | 85 | 1740 | 42470 | |
884898 | 884898 | Cupertino | Cupertino | 2021-01-30 | Santa Clara | 85 | 731 | 60614 | |
884899 | 884899 | Gilroy | Gilroy | 2021-01-30 | Santa Clara | 85 | 6666 | 55525 | |
884900 | 884900 | Los Altos | Los Altos | 2021-01-30 | Santa Clara | 85 | 563 | 30588 | |
884901 | 884901 | Los Altos Hills | Los Altos Hills | 2021-01-30 | Santa Clara | 85 | 175 | 8517 | |
884902 | 884902 | Los Gatos | Los Gatos | 2021-01-30 | Santa Clara | 85 | 978 | 30922 | |
884903 | 884903 | Milpitas | Milpitas | 2021-01-30 | Santa Clara | 85 | 3052 | 77457 | |
884904 | 884904 | Monte Sereno | Monte Sereno | 2021-01-30 | Santa Clara | 85 | 72 | 3492 | |
884905 | 884905 | Morgan Hill | Morgan Hill | 2021-01-30 | Santa Clara | 85 | 3017 | 43876 | |
884906 | 884906 | Mountain View | Mountain View | 2021-01-30 | Santa Clara | 85 | 2532 | 80993 | |
884907 | 884907 | Palo Alto | Palo Alto | 2021-01-30 | Santa Clara | 85 | 1264 | 67019 | |
884908 | 884908 | San Jose | San Jose | 2021-01-30 | Santa Clara | 85 | 67020 | 1026658 | |
884909 | 884909 | Santa Clara | Santa Clara | 2021-01-30 | Santa Clara | 85 | 4478 | 126209 | |
884910 | 884910 | Saratoga | Saratoga | 2021-01-30 | Santa Clara | 85 | 526 | 30886 | |
884911 | 884911 | Sunnyvale | Sunnyvale | 2021-01-30 | Santa Clara | 85 | 4634 | 152323 |
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 );