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" and "date" is on date 2021-02-05 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | id | name | date ▲ | county | fips | confirmed_cases | note | population |
---|---|---|---|---|---|---|---|---|---|
877241 | 877241 | Campbell | Campbell | 2021-02-05 | Santa Clara | 85 | 1803 | 42470 | |
877242 | 877242 | Cupertino | Cupertino | 2021-02-05 | Santa Clara | 85 | 759 | 60614 | |
877243 | 877243 | Gilroy | Gilroy | 2021-02-05 | Santa Clara | 85 | 6829 | 55525 | |
877244 | 877244 | Los Altos | Los Altos | 2021-02-05 | Santa Clara | 85 | 582 | 30588 | |
877245 | 877245 | Los Altos Hills | Los Altos Hills | 2021-02-05 | Santa Clara | 85 | 180 | 8517 | |
877246 | 877246 | Los Gatos | Los Gatos | 2021-02-05 | Santa Clara | 85 | 1011 | 30922 | |
877247 | 877247 | Milpitas | Milpitas | 2021-02-05 | Santa Clara | 85 | 3129 | 77457 | |
877248 | 877248 | Monte Sereno | Monte Sereno | 2021-02-05 | Santa Clara | 85 | 74 | 3492 | |
877249 | 877249 | Morgan Hill | Morgan Hill | 2021-02-05 | Santa Clara | 85 | 3134 | 43876 | |
877250 | 877250 | Mountain View | Mountain View | 2021-02-05 | Santa Clara | 85 | 2623 | 80993 | |
877251 | 877251 | Palo Alto | Palo Alto | 2021-02-05 | Santa Clara | 85 | 1297 | 67019 | |
877252 | 877252 | San Jose | San Jose | 2021-02-05 | Santa Clara | 85 | 68616 | 1026658 | |
877253 | 877253 | Santa Clara | Santa Clara | 2021-02-05 | Santa Clara | 85 | 4615 | 126209 | |
877254 | 877254 | Saratoga | Saratoga | 2021-02-05 | Santa Clara | 85 | 539 | 30886 | |
877255 | 877255 | Sunnyvale | Sunnyvale | 2021-02-05 | Santa Clara | 85 | 4780 | 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 );