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 |
---|---|---|---|---|---|---|---|---|---|
558241 | 558241 | Campbell | Campbell | 2021-10-13 | Santa Clara | 85 | 2689 | 42470 | |
558242 | 558242 | Cupertino | Cupertino | 2021-10-13 | Santa Clara | 85 | 1217 | 60614 | |
558243 | 558243 | Gilroy | Gilroy | 2021-10-13 | Santa Clara | 85 | 8712 | 55525 | |
558244 | 558244 | Los Altos | Los Altos | 2021-10-13 | Santa Clara | 85 | 881 | 30588 | |
558245 | 558245 | Los Altos Hills | Los Altos Hills | 2021-10-13 | Santa Clara | 85 | 295 | 8517 | |
558246 | 558246 | Los Gatos | Los Gatos | 2021-10-13 | Santa Clara | 85 | 1623 | 30922 | |
558247 | 558247 | Milpitas | Milpitas | 2021-10-13 | Santa Clara | 85 | 4409 | 77457 | |
558248 | 558248 | Monte Sereno | Monte Sereno | 2021-10-13 | Santa Clara | 85 | 128 | 3492 | |
558249 | 558249 | Morgan Hill | Morgan Hill | 2021-10-13 | Santa Clara | 85 | 4590 | 43876 | |
558250 | 558250 | Mountain View | Mountain View | 2021-10-13 | Santa Clara | 85 | 3730 | 80993 | |
558251 | 558251 | Palo Alto | Palo Alto | 2021-10-13 | Santa Clara | 85 | 1986 | 67019 | |
558252 | 558252 | San Jose | San Jose | 2021-10-13 | Santa Clara | 85 | 92893 | 1026658 | |
558253 | 558253 | Santa Clara | Santa Clara | 2021-10-13 | Santa Clara | 85 | 6938 | 126209 | |
558254 | 558254 | Saratoga | Saratoga | 2021-10-13 | Santa Clara | 85 | 854 | 30886 | |
558255 | 558255 | Sunnyvale | Sunnyvale | 2021-10-13 | Santa Clara | 85 | 6896 | 152323 | |
559517 | 559517 | Campbell | Campbell | 2021-10-12 | Santa Clara | 85 | 2689 | 42470 | |
559518 | 559518 | Cupertino | Cupertino | 2021-10-12 | Santa Clara | 85 | 1217 | 60614 | |
559519 | 559519 | Gilroy | Gilroy | 2021-10-12 | Santa Clara | 85 | 8712 | 55525 | |
559520 | 559520 | Los Altos | Los Altos | 2021-10-12 | Santa Clara | 85 | 881 | 30588 | |
559521 | 559521 | Los Altos Hills | Los Altos Hills | 2021-10-12 | Santa Clara | 85 | 295 | 8517 | |
559522 | 559522 | Los Gatos | Los Gatos | 2021-10-12 | Santa Clara | 85 | 1623 | 30922 | |
559523 | 559523 | Milpitas | Milpitas | 2021-10-12 | Santa Clara | 85 | 4409 | 77457 | |
559524 | 559524 | Monte Sereno | Monte Sereno | 2021-10-12 | Santa Clara | 85 | 128 | 3492 | |
559525 | 559525 | Morgan Hill | Morgan Hill | 2021-10-12 | Santa Clara | 85 | 4590 | 43876 | |
559526 | 559526 | Mountain View | Mountain View | 2021-10-12 | Santa Clara | 85 | 3730 | 80993 | |
559527 | 559527 | Palo Alto | Palo Alto | 2021-10-12 | Santa Clara | 85 | 1986 | 67019 | |
559528 | 559528 | San Jose | San Jose | 2021-10-12 | Santa Clara | 85 | 92893 | 1026658 | |
559529 | 559529 | Santa Clara | Santa Clara | 2021-10-12 | Santa Clara | 85 | 6938 | 126209 | |
559530 | 559530 | Saratoga | Saratoga | 2021-10-12 | Santa Clara | 85 | 854 | 30886 | |
559531 | 559531 | Sunnyvale | Sunnyvale | 2021-10-12 | Santa Clara | 85 | 6896 | 152323 | |
560793 | 560793 | Campbell | Campbell | 2021-10-11 | Santa Clara | 85 | 2689 | 42470 | |
560794 | 560794 | Cupertino | Cupertino | 2021-10-11 | Santa Clara | 85 | 1217 | 60614 | |
560795 | 560795 | Gilroy | Gilroy | 2021-10-11 | Santa Clara | 85 | 8712 | 55525 | |
560796 | 560796 | Los Altos | Los Altos | 2021-10-11 | Santa Clara | 85 | 881 | 30588 | |
560797 | 560797 | Los Altos Hills | Los Altos Hills | 2021-10-11 | Santa Clara | 85 | 295 | 8517 | |
560798 | 560798 | Los Gatos | Los Gatos | 2021-10-11 | Santa Clara | 85 | 1623 | 30922 | |
560799 | 560799 | Milpitas | Milpitas | 2021-10-11 | Santa Clara | 85 | 4409 | 77457 | |
560800 | 560800 | Monte Sereno | Monte Sereno | 2021-10-11 | Santa Clara | 85 | 128 | 3492 | |
560801 | 560801 | Morgan Hill | Morgan Hill | 2021-10-11 | Santa Clara | 85 | 4590 | 43876 | |
560802 | 560802 | Mountain View | Mountain View | 2021-10-11 | Santa Clara | 85 | 3730 | 80993 | |
560803 | 560803 | Palo Alto | Palo Alto | 2021-10-11 | Santa Clara | 85 | 1986 | 67019 | |
560804 | 560804 | San Jose | San Jose | 2021-10-11 | Santa Clara | 85 | 92893 | 1026658 | |
560805 | 560805 | Santa Clara | Santa Clara | 2021-10-11 | Santa Clara | 85 | 6938 | 126209 | |
560806 | 560806 | Saratoga | Saratoga | 2021-10-11 | Santa Clara | 85 | 854 | 30886 | |
560807 | 560807 | Sunnyvale | Sunnyvale | 2021-10-11 | Santa Clara | 85 | 6896 | 152323 | |
562069 | 562069 | Campbell | Campbell | 2021-10-10 | Santa Clara | 85 | 2689 | 42470 | |
562070 | 562070 | Cupertino | Cupertino | 2021-10-10 | Santa Clara | 85 | 1217 | 60614 | |
562071 | 562071 | Gilroy | Gilroy | 2021-10-10 | Santa Clara | 85 | 8712 | 55525 | |
562072 | 562072 | Los Altos | Los Altos | 2021-10-10 | Santa Clara | 85 | 881 | 30588 | |
562073 | 562073 | Los Altos Hills | Los Altos Hills | 2021-10-10 | Santa Clara | 85 | 295 | 8517 | |
562074 | 562074 | Los Gatos | Los Gatos | 2021-10-10 | Santa Clara | 85 | 1623 | 30922 | |
562075 | 562075 | Milpitas | Milpitas | 2021-10-10 | Santa Clara | 85 | 4409 | 77457 | |
562076 | 562076 | Monte Sereno | Monte Sereno | 2021-10-10 | Santa Clara | 85 | 128 | 3492 | |
562077 | 562077 | Morgan Hill | Morgan Hill | 2021-10-10 | Santa Clara | 85 | 4590 | 43876 | |
562078 | 562078 | Mountain View | Mountain View | 2021-10-10 | Santa Clara | 85 | 3730 | 80993 | |
562079 | 562079 | Palo Alto | Palo Alto | 2021-10-10 | Santa Clara | 85 | 1986 | 67019 | |
562080 | 562080 | San Jose | San Jose | 2021-10-10 | Santa Clara | 85 | 92893 | 1026658 | |
562081 | 562081 | Santa Clara | Santa Clara | 2021-10-10 | Santa Clara | 85 | 6938 | 126209 | |
562082 | 562082 | Saratoga | Saratoga | 2021-10-10 | Santa Clara | 85 | 854 | 30886 | |
562083 | 562083 | Sunnyvale | Sunnyvale | 2021-10-10 | Santa Clara | 85 | 6896 | 152323 | |
563345 | 563345 | Campbell | Campbell | 2021-10-09 | Santa Clara | 85 | 2689 | 42470 | |
563346 | 563346 | Cupertino | Cupertino | 2021-10-09 | Santa Clara | 85 | 1217 | 60614 | |
563347 | 563347 | Gilroy | Gilroy | 2021-10-09 | Santa Clara | 85 | 8712 | 55525 | |
563348 | 563348 | Los Altos | Los Altos | 2021-10-09 | Santa Clara | 85 | 881 | 30588 | |
563349 | 563349 | Los Altos Hills | Los Altos Hills | 2021-10-09 | Santa Clara | 85 | 295 | 8517 | |
563350 | 563350 | Los Gatos | Los Gatos | 2021-10-09 | Santa Clara | 85 | 1623 | 30922 | |
563351 | 563351 | Milpitas | Milpitas | 2021-10-09 | Santa Clara | 85 | 4409 | 77457 | |
563352 | 563352 | Monte Sereno | Monte Sereno | 2021-10-09 | Santa Clara | 85 | 128 | 3492 | |
563353 | 563353 | Morgan Hill | Morgan Hill | 2021-10-09 | Santa Clara | 85 | 4590 | 43876 | |
563354 | 563354 | Mountain View | Mountain View | 2021-10-09 | Santa Clara | 85 | 3730 | 80993 | |
563355 | 563355 | Palo Alto | Palo Alto | 2021-10-09 | Santa Clara | 85 | 1986 | 67019 | |
563356 | 563356 | San Jose | San Jose | 2021-10-09 | Santa Clara | 85 | 92893 | 1026658 | |
563357 | 563357 | Santa Clara | Santa Clara | 2021-10-09 | Santa Clara | 85 | 6938 | 126209 | |
563358 | 563358 | Saratoga | Saratoga | 2021-10-09 | Santa Clara | 85 | 854 | 30886 | |
563359 | 563359 | Sunnyvale | Sunnyvale | 2021-10-09 | Santa Clara | 85 | 6896 | 152323 | |
564621 | 564621 | Campbell | Campbell | 2021-10-08 | Santa Clara | 85 | 2689 | 42470 | |
564622 | 564622 | Cupertino | Cupertino | 2021-10-08 | Santa Clara | 85 | 1217 | 60614 | |
564623 | 564623 | Gilroy | Gilroy | 2021-10-08 | Santa Clara | 85 | 8712 | 55525 | |
564624 | 564624 | Los Altos | Los Altos | 2021-10-08 | Santa Clara | 85 | 881 | 30588 | |
564625 | 564625 | Los Altos Hills | Los Altos Hills | 2021-10-08 | Santa Clara | 85 | 295 | 8517 | |
564626 | 564626 | Los Gatos | Los Gatos | 2021-10-08 | Santa Clara | 85 | 1623 | 30922 | |
564627 | 564627 | Milpitas | Milpitas | 2021-10-08 | Santa Clara | 85 | 4409 | 77457 | |
564628 | 564628 | Monte Sereno | Monte Sereno | 2021-10-08 | Santa Clara | 85 | 128 | 3492 | |
564629 | 564629 | Morgan Hill | Morgan Hill | 2021-10-08 | Santa Clara | 85 | 4590 | 43876 | |
564630 | 564630 | Mountain View | Mountain View | 2021-10-08 | Santa Clara | 85 | 3730 | 80993 | |
564631 | 564631 | Palo Alto | Palo Alto | 2021-10-08 | Santa Clara | 85 | 1986 | 67019 | |
564632 | 564632 | San Jose | San Jose | 2021-10-08 | Santa Clara | 85 | 92893 | 1026658 | |
564633 | 564633 | Santa Clara | Santa Clara | 2021-10-08 | Santa Clara | 85 | 6938 | 126209 | |
564634 | 564634 | Saratoga | Saratoga | 2021-10-08 | Santa Clara | 85 | 854 | 30886 | |
564635 | 564635 | Sunnyvale | Sunnyvale | 2021-10-08 | Santa Clara | 85 | 6896 | 152323 | |
565897 | 565897 | Campbell | Campbell | 2021-10-07 | Santa Clara | 85 | 2689 | 42470 | |
565898 | 565898 | Cupertino | Cupertino | 2021-10-07 | Santa Clara | 85 | 1217 | 60614 | |
565899 | 565899 | Gilroy | Gilroy | 2021-10-07 | Santa Clara | 85 | 8712 | 55525 | |
565900 | 565900 | Los Altos | Los Altos | 2021-10-07 | Santa Clara | 85 | 881 | 30588 | |
565901 | 565901 | Los Altos Hills | Los Altos Hills | 2021-10-07 | Santa Clara | 85 | 295 | 8517 | |
565902 | 565902 | Los Gatos | Los Gatos | 2021-10-07 | Santa Clara | 85 | 1623 | 30922 | |
565903 | 565903 | Milpitas | Milpitas | 2021-10-07 | Santa Clara | 85 | 4409 | 77457 | |
565904 | 565904 | Monte Sereno | Monte Sereno | 2021-10-07 | Santa Clara | 85 | 128 | 3492 | |
565905 | 565905 | Morgan Hill | Morgan Hill | 2021-10-07 | Santa Clara | 85 | 4590 | 43876 | |
565906 | 565906 | Mountain View | Mountain View | 2021-10-07 | Santa Clara | 85 | 3730 | 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 );