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 county = "Santa Clara" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | id | name | date ▲ | county | fips | confirmed_cases | note | population |
---|---|---|---|---|---|---|---|---|---|
43150 | 43150 | Campbell | Campbell | 2022-11-24 | Santa Clara | 85 | 9265 | 42470 | |
43151 | 43151 | Cupertino | Cupertino | 2022-11-24 | Santa Clara | 85 | 7819 | 60614 | |
43152 | 43152 | Gilroy | Gilroy | 2022-11-24 | Santa Clara | 85 | 19586 | 55525 | |
43153 | 43153 | Los Altos | Los Altos | 2022-11-24 | Santa Clara | 85 | 4614 | 30588 | |
43154 | 43154 | Los Altos Hills | Los Altos Hills | 2022-11-24 | Santa Clara | 85 | 1170 | 8517 | |
43155 | 43155 | Los Gatos | Los Gatos | 2022-11-24 | Santa Clara | 85 | 6395 | 30922 | |
43156 | 43156 | Milpitas | Milpitas | 2022-11-24 | Santa Clara | 85 | 15641 | 77457 | |
43157 | 43157 | Monte Sereno | Monte Sereno | 2022-11-24 | Santa Clara | 85 | 280 | 3492 | |
43158 | 43158 | Morgan Hill | Morgan Hill | 2022-11-24 | Santa Clara | 85 | 12849 | 43876 | |
43159 | 43159 | Mountain View | Mountain View | 2022-11-24 | Santa Clara | 85 | 12983 | 80993 | |
43160 | 43160 | Palo Alto | Palo Alto | 2022-11-24 | Santa Clara | 85 | 10096 | 67019 | |
43161 | 43161 | San Jose | San Jose | 2022-11-24 | Santa Clara | 85 | 265137 | 1026658 | |
43162 | 43162 | Santa Clara | Santa Clara | 2022-11-24 | Santa Clara | 85 | 25368 | 126209 | |
43163 | 43163 | Saratoga | Saratoga | 2022-11-24 | Santa Clara | 85 | 4201 | 30886 | |
43164 | 43164 | Sunnyvale | Sunnyvale | 2022-11-24 | Santa Clara | 85 | 25047 | 152323 | |
44381 | 44381 | Campbell | Campbell | 2022-11-23 | Santa Clara | 85 | 9265 | 42470 | |
44382 | 44382 | Cupertino | Cupertino | 2022-11-23 | Santa Clara | 85 | 7819 | 60614 | |
44383 | 44383 | Gilroy | Gilroy | 2022-11-23 | Santa Clara | 85 | 19586 | 55525 | |
44384 | 44384 | Los Altos | Los Altos | 2022-11-23 | Santa Clara | 85 | 4614 | 30588 | |
44385 | 44385 | Los Altos Hills | Los Altos Hills | 2022-11-23 | Santa Clara | 85 | 1170 | 8517 | |
44386 | 44386 | Los Gatos | Los Gatos | 2022-11-23 | Santa Clara | 85 | 6395 | 30922 | |
44387 | 44387 | Milpitas | Milpitas | 2022-11-23 | Santa Clara | 85 | 15641 | 77457 | |
44388 | 44388 | Monte Sereno | Monte Sereno | 2022-11-23 | Santa Clara | 85 | 280 | 3492 | |
44389 | 44389 | Morgan Hill | Morgan Hill | 2022-11-23 | Santa Clara | 85 | 12849 | 43876 | |
44390 | 44390 | Mountain View | Mountain View | 2022-11-23 | Santa Clara | 85 | 12983 | 80993 | |
44391 | 44391 | Palo Alto | Palo Alto | 2022-11-23 | Santa Clara | 85 | 10096 | 67019 | |
44392 | 44392 | San Jose | San Jose | 2022-11-23 | Santa Clara | 85 | 265137 | 1026658 | |
44393 | 44393 | Santa Clara | Santa Clara | 2022-11-23 | Santa Clara | 85 | 25368 | 126209 | |
44394 | 44394 | Saratoga | Saratoga | 2022-11-23 | Santa Clara | 85 | 4201 | 30886 | |
44395 | 44395 | Sunnyvale | Sunnyvale | 2022-11-23 | Santa Clara | 85 | 25047 | 152323 | |
45612 | 45612 | Campbell | Campbell | 2022-11-22 | Santa Clara | 85 | 9265 | 42470 | |
45613 | 45613 | Cupertino | Cupertino | 2022-11-22 | Santa Clara | 85 | 7819 | 60614 | |
45614 | 45614 | Gilroy | Gilroy | 2022-11-22 | Santa Clara | 85 | 19586 | 55525 | |
45615 | 45615 | Los Altos | Los Altos | 2022-11-22 | Santa Clara | 85 | 4614 | 30588 | |
45616 | 45616 | Los Altos Hills | Los Altos Hills | 2022-11-22 | Santa Clara | 85 | 1170 | 8517 | |
45617 | 45617 | Los Gatos | Los Gatos | 2022-11-22 | Santa Clara | 85 | 6395 | 30922 | |
45618 | 45618 | Milpitas | Milpitas | 2022-11-22 | Santa Clara | 85 | 15641 | 77457 | |
45619 | 45619 | Monte Sereno | Monte Sereno | 2022-11-22 | Santa Clara | 85 | 280 | 3492 | |
45620 | 45620 | Morgan Hill | Morgan Hill | 2022-11-22 | Santa Clara | 85 | 12849 | 43876 | |
45621 | 45621 | Mountain View | Mountain View | 2022-11-22 | Santa Clara | 85 | 12983 | 80993 | |
45622 | 45622 | Palo Alto | Palo Alto | 2022-11-22 | Santa Clara | 85 | 10096 | 67019 | |
45623 | 45623 | San Jose | San Jose | 2022-11-22 | Santa Clara | 85 | 265137 | 1026658 | |
45624 | 45624 | Santa Clara | Santa Clara | 2022-11-22 | Santa Clara | 85 | 25368 | 126209 | |
45625 | 45625 | Saratoga | Saratoga | 2022-11-22 | Santa Clara | 85 | 4201 | 30886 | |
45626 | 45626 | Sunnyvale | Sunnyvale | 2022-11-22 | Santa Clara | 85 | 25047 | 152323 | |
46843 | 46843 | Campbell | Campbell | 2022-11-21 | Santa Clara | 85 | 9265 | 42470 | |
46844 | 46844 | Cupertino | Cupertino | 2022-11-21 | Santa Clara | 85 | 7819 | 60614 | |
46845 | 46845 | Gilroy | Gilroy | 2022-11-21 | Santa Clara | 85 | 19586 | 55525 | |
46846 | 46846 | Los Altos | Los Altos | 2022-11-21 | Santa Clara | 85 | 4614 | 30588 | |
46847 | 46847 | Los Altos Hills | Los Altos Hills | 2022-11-21 | Santa Clara | 85 | 1170 | 8517 | |
46848 | 46848 | Los Gatos | Los Gatos | 2022-11-21 | Santa Clara | 85 | 6395 | 30922 | |
46849 | 46849 | Milpitas | Milpitas | 2022-11-21 | Santa Clara | 85 | 15641 | 77457 | |
46850 | 46850 | Monte Sereno | Monte Sereno | 2022-11-21 | Santa Clara | 85 | 280 | 3492 | |
46851 | 46851 | Morgan Hill | Morgan Hill | 2022-11-21 | Santa Clara | 85 | 12849 | 43876 | |
46852 | 46852 | Mountain View | Mountain View | 2022-11-21 | Santa Clara | 85 | 12983 | 80993 | |
46853 | 46853 | Palo Alto | Palo Alto | 2022-11-21 | Santa Clara | 85 | 10096 | 67019 | |
46854 | 46854 | San Jose | San Jose | 2022-11-21 | Santa Clara | 85 | 265137 | 1026658 | |
46855 | 46855 | Santa Clara | Santa Clara | 2022-11-21 | Santa Clara | 85 | 25368 | 126209 | |
46856 | 46856 | Saratoga | Saratoga | 2022-11-21 | Santa Clara | 85 | 4201 | 30886 | |
46857 | 46857 | Sunnyvale | Sunnyvale | 2022-11-21 | Santa Clara | 85 | 25047 | 152323 | |
48074 | 48074 | Campbell | Campbell | 2022-11-20 | Santa Clara | 85 | 9168 | 42470 | |
48075 | 48075 | Cupertino | Cupertino | 2022-11-20 | Santa Clara | 85 | 7727 | 60614 | |
48076 | 48076 | Gilroy | Gilroy | 2022-11-20 | Santa Clara | 85 | 19478 | 55525 | |
48077 | 48077 | Los Altos | Los Altos | 2022-11-20 | Santa Clara | 85 | 4551 | 30588 | |
48078 | 48078 | Los Altos Hills | Los Altos Hills | 2022-11-20 | Santa Clara | 85 | 1161 | 8517 | |
48079 | 48079 | Los Gatos | Los Gatos | 2022-11-20 | Santa Clara | 85 | 6339 | 30922 | |
48080 | 48080 | Milpitas | Milpitas | 2022-11-20 | Santa Clara | 85 | 15515 | 77457 | |
48081 | 48081 | Monte Sereno | Monte Sereno | 2022-11-20 | Santa Clara | 85 | 274 | 3492 | |
48082 | 48082 | Morgan Hill | Morgan Hill | 2022-11-20 | Santa Clara | 85 | 12778 | 43876 | |
48083 | 48083 | Mountain View | Mountain View | 2022-11-20 | Santa Clara | 85 | 12862 | 80993 | |
48084 | 48084 | Palo Alto | Palo Alto | 2022-11-20 | Santa Clara | 85 | 9984 | 67019 | |
48085 | 48085 | San Jose | San Jose | 2022-11-20 | Santa Clara | 85 | 263264 | 1026658 | |
48086 | 48086 | Santa Clara | Santa Clara | 2022-11-20 | Santa Clara | 85 | 25117 | 126209 | |
48087 | 48087 | Saratoga | Saratoga | 2022-11-20 | Santa Clara | 85 | 4162 | 30886 | |
48088 | 48088 | Sunnyvale | Sunnyvale | 2022-11-20 | Santa Clara | 85 | 24794 | 152323 | |
49305 | 49305 | Campbell | Campbell | 2022-11-19 | Santa Clara | 85 | 9168 | 42470 | |
49306 | 49306 | Cupertino | Cupertino | 2022-11-19 | Santa Clara | 85 | 7727 | 60614 | |
49307 | 49307 | Gilroy | Gilroy | 2022-11-19 | Santa Clara | 85 | 19478 | 55525 | |
49308 | 49308 | Los Altos | Los Altos | 2022-11-19 | Santa Clara | 85 | 4551 | 30588 | |
49309 | 49309 | Los Altos Hills | Los Altos Hills | 2022-11-19 | Santa Clara | 85 | 1161 | 8517 | |
49310 | 49310 | Los Gatos | Los Gatos | 2022-11-19 | Santa Clara | 85 | 6339 | 30922 | |
49311 | 49311 | Milpitas | Milpitas | 2022-11-19 | Santa Clara | 85 | 15515 | 77457 | |
49312 | 49312 | Monte Sereno | Monte Sereno | 2022-11-19 | Santa Clara | 85 | 274 | 3492 | |
49313 | 49313 | Morgan Hill | Morgan Hill | 2022-11-19 | Santa Clara | 85 | 12778 | 43876 | |
49314 | 49314 | Mountain View | Mountain View | 2022-11-19 | Santa Clara | 85 | 12862 | 80993 | |
49315 | 49315 | Palo Alto | Palo Alto | 2022-11-19 | Santa Clara | 85 | 9984 | 67019 | |
49316 | 49316 | San Jose | San Jose | 2022-11-19 | Santa Clara | 85 | 263264 | 1026658 | |
49317 | 49317 | Santa Clara | Santa Clara | 2022-11-19 | Santa Clara | 85 | 25117 | 126209 | |
49318 | 49318 | Saratoga | Saratoga | 2022-11-19 | Santa Clara | 85 | 4162 | 30886 | |
49319 | 49319 | Sunnyvale | Sunnyvale | 2022-11-19 | Santa Clara | 85 | 24794 | 152323 | |
50536 | 50536 | Campbell | Campbell | 2022-11-18 | Santa Clara | 85 | 9168 | 42470 | |
50537 | 50537 | Cupertino | Cupertino | 2022-11-18 | Santa Clara | 85 | 7727 | 60614 | |
50538 | 50538 | Gilroy | Gilroy | 2022-11-18 | Santa Clara | 85 | 19478 | 55525 | |
50539 | 50539 | Los Altos | Los Altos | 2022-11-18 | Santa Clara | 85 | 4551 | 30588 | |
50540 | 50540 | Los Altos Hills | Los Altos Hills | 2022-11-18 | Santa Clara | 85 | 1161 | 8517 | |
50541 | 50541 | Los Gatos | Los Gatos | 2022-11-18 | Santa Clara | 85 | 6339 | 30922 | |
50542 | 50542 | Milpitas | Milpitas | 2022-11-18 | Santa Clara | 85 | 15515 | 77457 | |
50543 | 50543 | Monte Sereno | Monte Sereno | 2022-11-18 | Santa Clara | 85 | 274 | 3492 | |
50544 | 50544 | Morgan Hill | Morgan Hill | 2022-11-18 | Santa Clara | 85 | 12778 | 43876 | |
50545 | 50545 | Mountain View | Mountain View | 2022-11-18 | Santa Clara | 85 | 12862 | 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 );