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 |
---|---|---|---|---|---|---|---|---|---|
1014032 | 1014032 | Campbell | Campbell | 2020-10-17 | Santa Clara | 85 | 377 | 42470 | |
1014033 | 1014033 | Cupertino | Cupertino | 2020-10-17 | Santa Clara | 85 | 137 | 60614 | |
1014034 | 1014034 | Gilroy | Gilroy | 2020-10-17 | Santa Clara | 85 | 1643 | 55525 | |
1014035 | 1014035 | Los Altos | Los Altos | 2020-10-17 | Santa Clara | 85 | 128 | 30588 | |
1014036 | 1014036 | Los Altos Hills | Los Altos Hills | 2020-10-17 | Santa Clara | 85 | 37 | 8517 | |
1014037 | 1014037 | Los Gatos | Los Gatos | 2020-10-17 | Santa Clara | 85 | 193 | 30922 | |
1014038 | 1014038 | Milpitas | Milpitas | 2020-10-17 | Santa Clara | 85 | 607 | 77457 | |
1014039 | 1014039 | Monte Sereno | Monte Sereno | 2020-10-17 | Santa Clara | 85 | 19 | 3492 | |
1014040 | 1014040 | Morgan Hill | Morgan Hill | 2020-10-17 | Santa Clara | 85 | 642 | 43876 | |
1014041 | 1014041 | Mountain View | Mountain View | 2020-10-17 | Santa Clara | 85 | 624 | 80993 | |
1014042 | 1014042 | Palo Alto | Palo Alto | 2020-10-17 | Santa Clara | 85 | 316 | 67019 | |
1014043 | 1014043 | San Jose | San Jose | 2020-10-17 | Santa Clara | 85 | 15215 | 1026658 | |
1014044 | 1014044 | Santa Clara | Santa Clara | 2020-10-17 | Santa Clara | 85 | 1085 | 126209 | |
1014045 | 1014045 | Saratoga | Saratoga | 2020-10-17 | Santa Clara | 85 | 123 | 30886 | |
1014046 | 1014046 | Sunnyvale | Sunnyvale | 2020-10-17 | Santa Clara | 85 | 1028 | 152323 | |
1015224 | 1015224 | Campbell | Campbell | 2020-10-16 | Santa Clara | 85 | 377 | 42470 | |
1015225 | 1015225 | Cupertino | Cupertino | 2020-10-16 | Santa Clara | 85 | 137 | 60614 | |
1015226 | 1015226 | Gilroy | Gilroy | 2020-10-16 | Santa Clara | 85 | 1636 | 55525 | |
1015227 | 1015227 | Los Altos | Los Altos | 2020-10-16 | Santa Clara | 85 | 127 | 30588 | |
1015228 | 1015228 | Los Altos Hills | Los Altos Hills | 2020-10-16 | Santa Clara | 85 | 37 | 8517 | |
1015229 | 1015229 | Los Gatos | Los Gatos | 2020-10-16 | Santa Clara | 85 | 192 | 30922 | |
1015230 | 1015230 | Milpitas | Milpitas | 2020-10-16 | Santa Clara | 85 | 605 | 77457 | |
1015231 | 1015231 | Monte Sereno | Monte Sereno | 2020-10-16 | Santa Clara | 85 | 19 | 3492 | |
1015232 | 1015232 | Morgan Hill | Morgan Hill | 2020-10-16 | Santa Clara | 85 | 643 | 43876 | |
1015233 | 1015233 | Mountain View | Mountain View | 2020-10-16 | Santa Clara | 85 | 622 | 80993 | |
1015234 | 1015234 | Palo Alto | Palo Alto | 2020-10-16 | Santa Clara | 85 | 315 | 67019 | |
1015235 | 1015235 | San Jose | San Jose | 2020-10-16 | Santa Clara | 85 | 15168 | 1026658 | |
1015236 | 1015236 | Santa Clara | Santa Clara | 2020-10-16 | Santa Clara | 85 | 1077 | 126209 | |
1015237 | 1015237 | Saratoga | Saratoga | 2020-10-16 | Santa Clara | 85 | 120 | 30886 | |
1015238 | 1015238 | Sunnyvale | Sunnyvale | 2020-10-16 | Santa Clara | 85 | 1022 | 152323 | |
1016416 | 1016416 | Campbell | Campbell | 2020-10-15 | Santa Clara | 85 | 375 | 42470 | |
1016417 | 1016417 | Cupertino | Cupertino | 2020-10-15 | Santa Clara | 85 | 136 | 60614 | |
1016418 | 1016418 | Gilroy | Gilroy | 2020-10-15 | Santa Clara | 85 | 1621 | 55525 | |
1016419 | 1016419 | Los Altos | Los Altos | 2020-10-15 | Santa Clara | 85 | 126 | 30588 | |
1016420 | 1016420 | Los Altos Hills | Los Altos Hills | 2020-10-15 | Santa Clara | 85 | 37 | 8517 | |
1016421 | 1016421 | Los Gatos | Los Gatos | 2020-10-15 | Santa Clara | 85 | 192 | 30922 | |
1016422 | 1016422 | Milpitas | Milpitas | 2020-10-15 | Santa Clara | 85 | 604 | 77457 | |
1016423 | 1016423 | Monte Sereno | Monte Sereno | 2020-10-15 | Santa Clara | 85 | 19 | 3492 | |
1016424 | 1016424 | Morgan Hill | Morgan Hill | 2020-10-15 | Santa Clara | 85 | 643 | 43876 | |
1016425 | 1016425 | Mountain View | Mountain View | 2020-10-15 | Santa Clara | 85 | 621 | 80993 | |
1016426 | 1016426 | Palo Alto | Palo Alto | 2020-10-15 | Santa Clara | 85 | 315 | 67019 | |
1016427 | 1016427 | San Jose | San Jose | 2020-10-15 | Santa Clara | 85 | 15097 | 1026658 | |
1016428 | 1016428 | Santa Clara | Santa Clara | 2020-10-15 | Santa Clara | 85 | 1072 | 126209 | |
1016429 | 1016429 | Saratoga | Saratoga | 2020-10-15 | Santa Clara | 85 | 120 | 30886 | |
1016430 | 1016430 | Sunnyvale | Sunnyvale | 2020-10-15 | Santa Clara | 85 | 1015 | 152323 | |
1017608 | 1017608 | Campbell | Campbell | 2020-10-14 | Santa Clara | 85 | 375 | 42470 | |
1017609 | 1017609 | Cupertino | Cupertino | 2020-10-14 | Santa Clara | 85 | 136 | 60614 | |
1017610 | 1017610 | Gilroy | Gilroy | 2020-10-14 | Santa Clara | 85 | 1619 | 55525 | |
1017611 | 1017611 | Los Altos | Los Altos | 2020-10-14 | Santa Clara | 85 | 126 | 30588 | |
1017612 | 1017612 | Los Altos Hills | Los Altos Hills | 2020-10-14 | Santa Clara | 85 | 37 | 8517 | |
1017613 | 1017613 | Los Gatos | Los Gatos | 2020-10-14 | Santa Clara | 85 | 191 | 30922 | |
1017614 | 1017614 | Milpitas | Milpitas | 2020-10-14 | Santa Clara | 85 | 599 | 77457 | |
1017615 | 1017615 | Monte Sereno | Monte Sereno | 2020-10-14 | Santa Clara | 85 | 19 | 3492 | |
1017616 | 1017616 | Morgan Hill | Morgan Hill | 2020-10-14 | Santa Clara | 85 | 642 | 43876 | |
1017617 | 1017617 | Mountain View | Mountain View | 2020-10-14 | Santa Clara | 85 | 620 | 80993 | |
1017618 | 1017618 | Palo Alto | Palo Alto | 2020-10-14 | Santa Clara | 85 | 314 | 67019 | |
1017619 | 1017619 | San Jose | San Jose | 2020-10-14 | Santa Clara | 85 | 15039 | 1026658 | |
1017620 | 1017620 | Santa Clara | Santa Clara | 2020-10-14 | Santa Clara | 85 | 1069 | 126209 | |
1017621 | 1017621 | Saratoga | Saratoga | 2020-10-14 | Santa Clara | 85 | 120 | 30886 | |
1017622 | 1017622 | Sunnyvale | Sunnyvale | 2020-10-14 | Santa Clara | 85 | 1015 | 152323 | |
1018800 | 1018800 | Campbell | Campbell | 2020-10-13 | Santa Clara | 85 | 373 | 42470 | |
1018801 | 1018801 | Cupertino | Cupertino | 2020-10-13 | Santa Clara | 85 | 136 | 60614 | |
1018802 | 1018802 | Gilroy | Gilroy | 2020-10-13 | Santa Clara | 85 | 1617 | 55525 | |
1018803 | 1018803 | Los Altos | Los Altos | 2020-10-13 | Santa Clara | 85 | 126 | 30588 | |
1018804 | 1018804 | Los Altos Hills | Los Altos Hills | 2020-10-13 | Santa Clara | 85 | 37 | 8517 | |
1018805 | 1018805 | Los Gatos | Los Gatos | 2020-10-13 | Santa Clara | 85 | 191 | 30922 | |
1018806 | 1018806 | Milpitas | Milpitas | 2020-10-13 | Santa Clara | 85 | 597 | 77457 | |
1018807 | 1018807 | Monte Sereno | Monte Sereno | 2020-10-13 | Santa Clara | 85 | 19 | 3492 | |
1018808 | 1018808 | Morgan Hill | Morgan Hill | 2020-10-13 | Santa Clara | 85 | 641 | 43876 | |
1018809 | 1018809 | Mountain View | Mountain View | 2020-10-13 | Santa Clara | 85 | 618 | 80993 | |
1018810 | 1018810 | Palo Alto | Palo Alto | 2020-10-13 | Santa Clara | 85 | 312 | 67019 | |
1018811 | 1018811 | San Jose | San Jose | 2020-10-13 | Santa Clara | 85 | 14994 | 1026658 | |
1018812 | 1018812 | Santa Clara | Santa Clara | 2020-10-13 | Santa Clara | 85 | 1066 | 126209 | |
1018813 | 1018813 | Saratoga | Saratoga | 2020-10-13 | Santa Clara | 85 | 120 | 30886 | |
1018814 | 1018814 | Sunnyvale | Sunnyvale | 2020-10-13 | Santa Clara | 85 | 1011 | 152323 | |
1019992 | 1019992 | Campbell | Campbell | 2020-10-12 | Santa Clara | 85 | 371 | 42470 | |
1019993 | 1019993 | Cupertino | Cupertino | 2020-10-12 | Santa Clara | 85 | 133 | 60614 | |
1019994 | 1019994 | Gilroy | Gilroy | 2020-10-12 | Santa Clara | 85 | 1615 | 55525 | |
1019995 | 1019995 | Los Altos | Los Altos | 2020-10-12 | Santa Clara | 85 | 125 | 30588 | |
1019996 | 1019996 | Los Altos Hills | Los Altos Hills | 2020-10-12 | Santa Clara | 85 | 37 | 8517 | |
1019997 | 1019997 | Los Gatos | Los Gatos | 2020-10-12 | Santa Clara | 85 | 188 | 30922 | |
1019998 | 1019998 | Milpitas | Milpitas | 2020-10-12 | Santa Clara | 85 | 593 | 77457 | |
1019999 | 1019999 | Monte Sereno | Monte Sereno | 2020-10-12 | Santa Clara | 85 | 19 | 3492 | |
1020000 | 1020000 | Morgan Hill | Morgan Hill | 2020-10-12 | Santa Clara | 85 | 639 | 43876 | |
1020001 | 1020001 | Mountain View | Mountain View | 2020-10-12 | Santa Clara | 85 | 615 | 80993 | |
1020002 | 1020002 | Palo Alto | Palo Alto | 2020-10-12 | Santa Clara | 85 | 310 | 67019 | |
1020003 | 1020003 | San Jose | San Jose | 2020-10-12 | Santa Clara | 85 | 14936 | 1026658 | |
1020004 | 1020004 | Santa Clara | Santa Clara | 2020-10-12 | Santa Clara | 85 | 1054 | 126209 | |
1020005 | 1020005 | Saratoga | Saratoga | 2020-10-12 | Santa Clara | 85 | 118 | 30886 | |
1020006 | 1020006 | Sunnyvale | Sunnyvale | 2020-10-12 | Santa Clara | 85 | 1011 | 152323 | |
1021184 | 1021184 | Campbell | Campbell | 2020-10-11 | Santa Clara | 85 | 370 | 42470 | |
1021185 | 1021185 | Cupertino | Cupertino | 2020-10-11 | Santa Clara | 85 | 136 | 60614 | |
1021186 | 1021186 | Gilroy | Gilroy | 2020-10-11 | Santa Clara | 85 | 1609 | 55525 | |
1021187 | 1021187 | Los Altos | Los Altos | 2020-10-11 | Santa Clara | 85 | 124 | 30588 | |
1021188 | 1021188 | Los Altos Hills | Los Altos Hills | 2020-10-11 | Santa Clara | 85 | 37 | 8517 | |
1021189 | 1021189 | Los Gatos | Los Gatos | 2020-10-11 | Santa Clara | 85 | 188 | 30922 | |
1021190 | 1021190 | Milpitas | Milpitas | 2020-10-11 | Santa Clara | 85 | 591 | 77457 | |
1021191 | 1021191 | Monte Sereno | Monte Sereno | 2020-10-11 | Santa Clara | 85 | 19 | 3492 | |
1021192 | 1021192 | Morgan Hill | Morgan Hill | 2020-10-11 | Santa Clara | 85 | 637 | 43876 | |
1021193 | 1021193 | Mountain View | Mountain View | 2020-10-11 | Santa Clara | 85 | 612 | 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 );