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 |
---|---|---|---|---|---|---|---|---|---|
278615 | 278615 | Campbell | Campbell | 2022-05-21 | Santa Clara | 85 | 6972 | 42470 | |
278616 | 278616 | Cupertino | Cupertino | 2022-05-21 | Santa Clara | 85 | 4947 | 60614 | |
278617 | 278617 | Gilroy | Gilroy | 2022-05-21 | Santa Clara | 85 | 15935 | 55525 | |
278618 | 278618 | Los Altos | Los Altos | 2022-05-21 | Santa Clara | 85 | 3063 | 30588 | |
278619 | 278619 | Los Altos Hills | Los Altos Hills | 2022-05-21 | Santa Clara | 85 | 838 | 8517 | |
278620 | 278620 | Los Gatos | Los Gatos | 2022-05-21 | Santa Clara | 85 | 4831 | 30922 | |
278621 | 278621 | Milpitas | Milpitas | 2022-05-21 | Santa Clara | 85 | 11375 | 77457 | |
278622 | 278622 | Monte Sereno | Monte Sereno | 2022-05-21 | Santa Clara | 85 | 389 | 3492 | |
278623 | 278623 | Morgan Hill | Morgan Hill | 2022-05-21 | Santa Clara | 85 | 10113 | 43876 | |
278624 | 278624 | Mountain View | Mountain View | 2022-05-21 | Santa Clara | 85 | 9393 | 80993 | |
278625 | 278625 | Palo Alto | Palo Alto | 2022-05-21 | Santa Clara | 85 | 6602 | 67019 | |
278626 | 278626 | San Jose | San Jose | 2022-05-21 | Santa Clara | 85 | 203344 | 1026658 | |
278627 | 278627 | Santa Clara | Santa Clara | 2022-05-21 | Santa Clara | 85 | 18579 | 126209 | |
278628 | 278628 | Saratoga | Saratoga | 2022-05-21 | Santa Clara | 85 | 2831 | 30886 | |
278629 | 278629 | Sunnyvale | Sunnyvale | 2022-05-21 | Santa Clara | 85 | 17958 | 152323 | |
279888 | 279888 | Campbell | Campbell | 2022-05-20 | Santa Clara | 85 | 6972 | 42470 | |
279889 | 279889 | Cupertino | Cupertino | 2022-05-20 | Santa Clara | 85 | 4947 | 60614 | |
279890 | 279890 | Gilroy | Gilroy | 2022-05-20 | Santa Clara | 85 | 15935 | 55525 | |
279891 | 279891 | Los Altos | Los Altos | 2022-05-20 | Santa Clara | 85 | 3063 | 30588 | |
279892 | 279892 | Los Altos Hills | Los Altos Hills | 2022-05-20 | Santa Clara | 85 | 838 | 8517 | |
279893 | 279893 | Los Gatos | Los Gatos | 2022-05-20 | Santa Clara | 85 | 4831 | 30922 | |
279894 | 279894 | Milpitas | Milpitas | 2022-05-20 | Santa Clara | 85 | 11375 | 77457 | |
279895 | 279895 | Monte Sereno | Monte Sereno | 2022-05-20 | Santa Clara | 85 | 389 | 3492 | |
279896 | 279896 | Morgan Hill | Morgan Hill | 2022-05-20 | Santa Clara | 85 | 10113 | 43876 | |
279897 | 279897 | Mountain View | Mountain View | 2022-05-20 | Santa Clara | 85 | 9393 | 80993 | |
279898 | 279898 | Palo Alto | Palo Alto | 2022-05-20 | Santa Clara | 85 | 6602 | 67019 | |
279899 | 279899 | San Jose | San Jose | 2022-05-20 | Santa Clara | 85 | 203344 | 1026658 | |
279900 | 279900 | Santa Clara | Santa Clara | 2022-05-20 | Santa Clara | 85 | 18579 | 126209 | |
279901 | 279901 | Saratoga | Saratoga | 2022-05-20 | Santa Clara | 85 | 2831 | 30886 | |
279902 | 279902 | Sunnyvale | Sunnyvale | 2022-05-20 | Santa Clara | 85 | 17958 | 152323 | |
281161 | 281161 | Campbell | Campbell | 2022-05-19 | Santa Clara | 85 | 6972 | 42470 | |
281162 | 281162 | Cupertino | Cupertino | 2022-05-19 | Santa Clara | 85 | 4947 | 60614 | |
281163 | 281163 | Gilroy | Gilroy | 2022-05-19 | Santa Clara | 85 | 15935 | 55525 | |
281164 | 281164 | Los Altos | Los Altos | 2022-05-19 | Santa Clara | 85 | 3063 | 30588 | |
281165 | 281165 | Los Altos Hills | Los Altos Hills | 2022-05-19 | Santa Clara | 85 | 838 | 8517 | |
281166 | 281166 | Los Gatos | Los Gatos | 2022-05-19 | Santa Clara | 85 | 4831 | 30922 | |
281167 | 281167 | Milpitas | Milpitas | 2022-05-19 | Santa Clara | 85 | 11375 | 77457 | |
281168 | 281168 | Monte Sereno | Monte Sereno | 2022-05-19 | Santa Clara | 85 | 389 | 3492 | |
281169 | 281169 | Morgan Hill | Morgan Hill | 2022-05-19 | Santa Clara | 85 | 10113 | 43876 | |
281170 | 281170 | Mountain View | Mountain View | 2022-05-19 | Santa Clara | 85 | 9393 | 80993 | |
281171 | 281171 | Palo Alto | Palo Alto | 2022-05-19 | Santa Clara | 85 | 6602 | 67019 | |
281172 | 281172 | San Jose | San Jose | 2022-05-19 | Santa Clara | 85 | 203344 | 1026658 | |
281173 | 281173 | Santa Clara | Santa Clara | 2022-05-19 | Santa Clara | 85 | 18579 | 126209 | |
281174 | 281174 | Saratoga | Saratoga | 2022-05-19 | Santa Clara | 85 | 2831 | 30886 | |
281175 | 281175 | Sunnyvale | Sunnyvale | 2022-05-19 | Santa Clara | 85 | 17958 | 152323 | |
282434 | 282434 | Campbell | Campbell | 2022-05-18 | Santa Clara | 85 | 6778 | 42470 | |
282435 | 282435 | Cupertino | Cupertino | 2022-05-18 | Santa Clara | 85 | 4786 | 60614 | |
282436 | 282436 | Gilroy | Gilroy | 2022-05-18 | Santa Clara | 85 | 15797 | 55525 | |
282437 | 282437 | Los Altos | Los Altos | 2022-05-18 | Santa Clara | 85 | 2919 | 30588 | |
282438 | 282438 | Los Altos Hills | Los Altos Hills | 2022-05-18 | Santa Clara | 85 | 806 | 8517 | |
282439 | 282439 | Los Gatos | Los Gatos | 2022-05-18 | Santa Clara | 85 | 4699 | 30922 | |
282440 | 282440 | Milpitas | Milpitas | 2022-05-18 | Santa Clara | 85 | 11070 | 77457 | |
282441 | 282441 | Monte Sereno | Monte Sereno | 2022-05-18 | Santa Clara | 85 | 374 | 3492 | |
282442 | 282442 | Morgan Hill | Morgan Hill | 2022-05-18 | Santa Clara | 85 | 9972 | 43876 | |
282443 | 282443 | Mountain View | Mountain View | 2022-05-18 | Santa Clara | 85 | 9116 | 80993 | |
282444 | 282444 | Palo Alto | Palo Alto | 2022-05-18 | Santa Clara | 85 | 6366 | 67019 | |
282445 | 282445 | San Jose | San Jose | 2022-05-18 | Santa Clara | 85 | 199718 | 1026658 | |
282446 | 282446 | Santa Clara | Santa Clara | 2022-05-18 | Santa Clara | 85 | 18137 | 126209 | |
282447 | 282447 | Saratoga | Saratoga | 2022-05-18 | Santa Clara | 85 | 2698 | 30886 | |
282448 | 282448 | Sunnyvale | Sunnyvale | 2022-05-18 | Santa Clara | 85 | 17515 | 152323 | |
283707 | 283707 | Campbell | Campbell | 2022-05-17 | Santa Clara | 85 | 6778 | 42470 | |
283708 | 283708 | Cupertino | Cupertino | 2022-05-17 | Santa Clara | 85 | 4786 | 60614 | |
283709 | 283709 | Gilroy | Gilroy | 2022-05-17 | Santa Clara | 85 | 15797 | 55525 | |
283710 | 283710 | Los Altos | Los Altos | 2022-05-17 | Santa Clara | 85 | 2919 | 30588 | |
283711 | 283711 | Los Altos Hills | Los Altos Hills | 2022-05-17 | Santa Clara | 85 | 806 | 8517 | |
283712 | 283712 | Los Gatos | Los Gatos | 2022-05-17 | Santa Clara | 85 | 4699 | 30922 | |
283713 | 283713 | Milpitas | Milpitas | 2022-05-17 | Santa Clara | 85 | 11070 | 77457 | |
283714 | 283714 | Monte Sereno | Monte Sereno | 2022-05-17 | Santa Clara | 85 | 374 | 3492 | |
283715 | 283715 | Morgan Hill | Morgan Hill | 2022-05-17 | Santa Clara | 85 | 9972 | 43876 | |
283716 | 283716 | Mountain View | Mountain View | 2022-05-17 | Santa Clara | 85 | 9116 | 80993 | |
283717 | 283717 | Palo Alto | Palo Alto | 2022-05-17 | Santa Clara | 85 | 6366 | 67019 | |
283718 | 283718 | San Jose | San Jose | 2022-05-17 | Santa Clara | 85 | 199718 | 1026658 | |
283719 | 283719 | Santa Clara | Santa Clara | 2022-05-17 | Santa Clara | 85 | 18137 | 126209 | |
283720 | 283720 | Saratoga | Saratoga | 2022-05-17 | Santa Clara | 85 | 2698 | 30886 | |
283721 | 283721 | Sunnyvale | Sunnyvale | 2022-05-17 | Santa Clara | 85 | 17515 | 152323 | |
284980 | 284980 | Campbell | Campbell | 2022-05-16 | Santa Clara | 85 | 6778 | 42470 | |
284981 | 284981 | Cupertino | Cupertino | 2022-05-16 | Santa Clara | 85 | 4786 | 60614 | |
284982 | 284982 | Gilroy | Gilroy | 2022-05-16 | Santa Clara | 85 | 15797 | 55525 | |
284983 | 284983 | Los Altos | Los Altos | 2022-05-16 | Santa Clara | 85 | 2919 | 30588 | |
284984 | 284984 | Los Altos Hills | Los Altos Hills | 2022-05-16 | Santa Clara | 85 | 806 | 8517 | |
284985 | 284985 | Los Gatos | Los Gatos | 2022-05-16 | Santa Clara | 85 | 4699 | 30922 | |
284986 | 284986 | Milpitas | Milpitas | 2022-05-16 | Santa Clara | 85 | 11070 | 77457 | |
284987 | 284987 | Monte Sereno | Monte Sereno | 2022-05-16 | Santa Clara | 85 | 374 | 3492 | |
284988 | 284988 | Morgan Hill | Morgan Hill | 2022-05-16 | Santa Clara | 85 | 9972 | 43876 | |
284989 | 284989 | Mountain View | Mountain View | 2022-05-16 | Santa Clara | 85 | 9116 | 80993 | |
284990 | 284990 | Palo Alto | Palo Alto | 2022-05-16 | Santa Clara | 85 | 6366 | 67019 | |
284991 | 284991 | San Jose | San Jose | 2022-05-16 | Santa Clara | 85 | 199718 | 1026658 | |
284992 | 284992 | Santa Clara | Santa Clara | 2022-05-16 | Santa Clara | 85 | 18137 | 126209 | |
284993 | 284993 | Saratoga | Saratoga | 2022-05-16 | Santa Clara | 85 | 2698 | 30886 | |
284994 | 284994 | Sunnyvale | Sunnyvale | 2022-05-16 | Santa Clara | 85 | 17515 | 152323 | |
286253 | 286253 | Campbell | Campbell | 2022-05-15 | Santa Clara | 85 | 6778 | 42470 | |
286254 | 286254 | Cupertino | Cupertino | 2022-05-15 | Santa Clara | 85 | 4786 | 60614 | |
286255 | 286255 | Gilroy | Gilroy | 2022-05-15 | Santa Clara | 85 | 15797 | 55525 | |
286256 | 286256 | Los Altos | Los Altos | 2022-05-15 | Santa Clara | 85 | 2919 | 30588 | |
286257 | 286257 | Los Altos Hills | Los Altos Hills | 2022-05-15 | Santa Clara | 85 | 806 | 8517 | |
286258 | 286258 | Los Gatos | Los Gatos | 2022-05-15 | Santa Clara | 85 | 4699 | 30922 | |
286259 | 286259 | Milpitas | Milpitas | 2022-05-15 | Santa Clara | 85 | 11070 | 77457 | |
286260 | 286260 | Monte Sereno | Monte Sereno | 2022-05-15 | Santa Clara | 85 | 374 | 3492 | |
286261 | 286261 | Morgan Hill | Morgan Hill | 2022-05-15 | Santa Clara | 85 | 9972 | 43876 | |
286262 | 286262 | Mountain View | Mountain View | 2022-05-15 | Santa Clara | 85 | 9116 | 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 );