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 fips = 85 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
date (date) >30 ✖
- 2020-04-09 15
- 2020-04-10 15
- 2020-04-11 15
- 2020-04-12 15
- 2020-04-13 15
- 2020-04-14 15
- 2020-04-15 15
- 2020-04-16 15
- 2020-04-17 15
- 2020-04-18 15
- 2020-04-19 15
- 2020-04-20 15
- 2020-04-21 15
- 2020-04-22 15
- 2020-04-23 15
- 2020-04-24 15
- 2020-04-25 15
- 2020-04-26 15
- 2020-04-27 15
- 2020-04-28 15
- 2020-04-29 15
- 2020-04-30 15
- 2020-05-01 15
- 2020-05-02 15
- 2020-05-03 15
- 2020-05-04 15
- 2020-05-05 15
- 2020-05-06 15
- 2020-05-07 15
- 2020-05-08 15
- …
fips 1
- 85 · 14,840 ✖
county 1
- Santa Clara 14,840
Link | rowid | id | name | date ▲ | county | fips | confirmed_cases | note | population |
---|---|---|---|---|---|---|---|---|---|
7430 | 7430 | Palo Alto | Palo Alto | 2022-12-24 | Santa Clara | 85 | 10432 | 67019 | |
7431 | 7431 | San Jose | San Jose | 2022-12-24 | Santa Clara | 85 | 277669 | 1026658 | |
7432 | 7432 | Santa Clara | Santa Clara | 2022-12-24 | Santa Clara | 85 | 26436 | 126209 | |
7433 | 7433 | Saratoga | Saratoga | 2022-12-24 | Santa Clara | 85 | 4361 | 30886 | |
7434 | 7434 | Sunnyvale | Sunnyvale | 2022-12-24 | Santa Clara | 85 | 26116 | 152323 | |
8601 | 8601 | Campbell | Campbell | 2022-12-23 | Santa Clara | 85 | 9634 | 42470 | |
8602 | 8602 | Cupertino | Cupertino | 2022-12-23 | Santa Clara | 85 | 8162 | 60614 | |
8603 | 8603 | Gilroy | Gilroy | 2022-12-23 | Santa Clara | 85 | 20122 | 55525 | |
8604 | 8604 | Los Altos | Los Altos | 2022-12-23 | Santa Clara | 85 | 4769 | 30588 | |
8605 | 8605 | Los Altos Hills | Los Altos Hills | 2022-12-23 | Santa Clara | 85 | 1198 | 8517 | |
8606 | 8606 | Los Gatos | Los Gatos | 2022-12-23 | Santa Clara | 85 | 6610 | 30922 | |
8607 | 8607 | Milpitas | Milpitas | 2022-12-23 | Santa Clara | 85 | 16701 | 77457 | |
8608 | 8608 | Monte Sereno | Monte Sereno | 2022-12-23 | Santa Clara | 85 | 301 | 3492 | |
8609 | 8609 | Morgan Hill | Morgan Hill | 2022-12-23 | Santa Clara | 85 | 13280 | 43876 | |
8610 | 8610 | Mountain View | Mountain View | 2022-12-23 | Santa Clara | 85 | 13494 | 80993 | |
8611 | 8611 | Palo Alto | Palo Alto | 2022-12-23 | Santa Clara | 85 | 10432 | 67019 | |
8612 | 8612 | San Jose | San Jose | 2022-12-23 | Santa Clara | 85 | 277669 | 1026658 | |
8613 | 8613 | Santa Clara | Santa Clara | 2022-12-23 | Santa Clara | 85 | 26436 | 126209 | |
8614 | 8614 | Saratoga | Saratoga | 2022-12-23 | Santa Clara | 85 | 4361 | 30886 | |
8615 | 8615 | Sunnyvale | Sunnyvale | 2022-12-23 | Santa Clara | 85 | 26116 | 152323 | |
9782 | 9782 | Campbell | Campbell | 2022-12-22 | Santa Clara | 85 | 9634 | 42470 | |
9783 | 9783 | Cupertino | Cupertino | 2022-12-22 | Santa Clara | 85 | 8162 | 60614 | |
9784 | 9784 | Gilroy | Gilroy | 2022-12-22 | Santa Clara | 85 | 20122 | 55525 | |
9785 | 9785 | Los Altos | Los Altos | 2022-12-22 | Santa Clara | 85 | 4769 | 30588 | |
9786 | 9786 | Los Altos Hills | Los Altos Hills | 2022-12-22 | Santa Clara | 85 | 1198 | 8517 | |
9787 | 9787 | Los Gatos | Los Gatos | 2022-12-22 | Santa Clara | 85 | 6610 | 30922 | |
9788 | 9788 | Milpitas | Milpitas | 2022-12-22 | Santa Clara | 85 | 16701 | 77457 | |
9789 | 9789 | Monte Sereno | Monte Sereno | 2022-12-22 | Santa Clara | 85 | 301 | 3492 | |
9790 | 9790 | Morgan Hill | Morgan Hill | 2022-12-22 | Santa Clara | 85 | 13280 | 43876 | |
9791 | 9791 | Mountain View | Mountain View | 2022-12-22 | Santa Clara | 85 | 13494 | 80993 | |
9792 | 9792 | Palo Alto | Palo Alto | 2022-12-22 | Santa Clara | 85 | 10432 | 67019 | |
9793 | 9793 | San Jose | San Jose | 2022-12-22 | Santa Clara | 85 | 277669 | 1026658 | |
9794 | 9794 | Santa Clara | Santa Clara | 2022-12-22 | Santa Clara | 85 | 26436 | 126209 | |
9795 | 9795 | Saratoga | Saratoga | 2022-12-22 | Santa Clara | 85 | 4361 | 30886 | |
9796 | 9796 | Sunnyvale | Sunnyvale | 2022-12-22 | Santa Clara | 85 | 26116 | 152323 | |
10963 | 10963 | Campbell | Campbell | 2022-12-21 | Santa Clara | 85 | 9576 | 42470 | |
10964 | 10964 | Cupertino | Cupertino | 2022-12-21 | Santa Clara | 85 | 8096 | 60614 | |
10965 | 10965 | Gilroy | Gilroy | 2022-12-21 | Santa Clara | 85 | 20012 | 55525 | |
10966 | 10966 | Los Altos | Los Altos | 2022-12-21 | Santa Clara | 85 | 4728 | 30588 | |
10967 | 10967 | Los Altos Hills | Los Altos Hills | 2022-12-21 | Santa Clara | 85 | 1193 | 8517 | |
10968 | 10968 | Los Gatos | Los Gatos | 2022-12-21 | Santa Clara | 85 | 6556 | 30922 | |
10969 | 10969 | Milpitas | Milpitas | 2022-12-21 | Santa Clara | 85 | 16591 | 77457 | |
10970 | 10970 | Monte Sereno | Monte Sereno | 2022-12-21 | Santa Clara | 85 | 299 | 3492 | |
10971 | 10971 | Morgan Hill | Morgan Hill | 2022-12-21 | Santa Clara | 85 | 13196 | 43876 | |
10972 | 10972 | Mountain View | Mountain View | 2022-12-21 | Santa Clara | 85 | 13396 | 80993 | |
10973 | 10973 | Palo Alto | Palo Alto | 2022-12-21 | Santa Clara | 85 | 10377 | 67019 | |
10974 | 10974 | San Jose | San Jose | 2022-12-21 | Santa Clara | 85 | 276076 | 1026658 | |
10975 | 10975 | Santa Clara | Santa Clara | 2022-12-21 | Santa Clara | 85 | 26268 | 126209 | |
10976 | 10976 | Saratoga | Saratoga | 2022-12-21 | Santa Clara | 85 | 4338 | 30886 | |
10977 | 10977 | Sunnyvale | Sunnyvale | 2022-12-21 | Santa Clara | 85 | 25940 | 152323 | |
12144 | 12144 | Campbell | Campbell | 2022-12-20 | Santa Clara | 85 | 9576 | 42470 | |
12145 | 12145 | Cupertino | Cupertino | 2022-12-20 | Santa Clara | 85 | 8096 | 60614 | |
12146 | 12146 | Gilroy | Gilroy | 2022-12-20 | Santa Clara | 85 | 20012 | 55525 | |
12147 | 12147 | Los Altos | Los Altos | 2022-12-20 | Santa Clara | 85 | 4728 | 30588 | |
12148 | 12148 | Los Altos Hills | Los Altos Hills | 2022-12-20 | Santa Clara | 85 | 1193 | 8517 | |
12149 | 12149 | Los Gatos | Los Gatos | 2022-12-20 | Santa Clara | 85 | 6556 | 30922 | |
12150 | 12150 | Milpitas | Milpitas | 2022-12-20 | Santa Clara | 85 | 16591 | 77457 | |
12151 | 12151 | Monte Sereno | Monte Sereno | 2022-12-20 | Santa Clara | 85 | 299 | 3492 | |
12152 | 12152 | Morgan Hill | Morgan Hill | 2022-12-20 | Santa Clara | 85 | 13196 | 43876 | |
12153 | 12153 | Mountain View | Mountain View | 2022-12-20 | Santa Clara | 85 | 13396 | 80993 | |
12154 | 12154 | Palo Alto | Palo Alto | 2022-12-20 | Santa Clara | 85 | 10377 | 67019 | |
12155 | 12155 | San Jose | San Jose | 2022-12-20 | Santa Clara | 85 | 276076 | 1026658 | |
12156 | 12156 | Santa Clara | Santa Clara | 2022-12-20 | Santa Clara | 85 | 26268 | 126209 | |
12157 | 12157 | Saratoga | Saratoga | 2022-12-20 | Santa Clara | 85 | 4338 | 30886 | |
12158 | 12158 | Sunnyvale | Sunnyvale | 2022-12-20 | Santa Clara | 85 | 25940 | 152323 | |
13325 | 13325 | Campbell | Campbell | 2022-12-19 | Santa Clara | 85 | 9576 | 42470 | |
13326 | 13326 | Cupertino | Cupertino | 2022-12-19 | Santa Clara | 85 | 8096 | 60614 | |
13327 | 13327 | Gilroy | Gilroy | 2022-12-19 | Santa Clara | 85 | 20012 | 55525 | |
13328 | 13328 | Los Altos | Los Altos | 2022-12-19 | Santa Clara | 85 | 4728 | 30588 | |
13329 | 13329 | Los Altos Hills | Los Altos Hills | 2022-12-19 | Santa Clara | 85 | 1193 | 8517 | |
13330 | 13330 | Los Gatos | Los Gatos | 2022-12-19 | Santa Clara | 85 | 6556 | 30922 | |
13331 | 13331 | Milpitas | Milpitas | 2022-12-19 | Santa Clara | 85 | 16591 | 77457 | |
13332 | 13332 | Monte Sereno | Monte Sereno | 2022-12-19 | Santa Clara | 85 | 299 | 3492 | |
13333 | 13333 | Morgan Hill | Morgan Hill | 2022-12-19 | Santa Clara | 85 | 13196 | 43876 | |
13334 | 13334 | Mountain View | Mountain View | 2022-12-19 | Santa Clara | 85 | 13396 | 80993 | |
13335 | 13335 | Palo Alto | Palo Alto | 2022-12-19 | Santa Clara | 85 | 10377 | 67019 | |
13336 | 13336 | San Jose | San Jose | 2022-12-19 | Santa Clara | 85 | 276076 | 1026658 | |
13337 | 13337 | Santa Clara | Santa Clara | 2022-12-19 | Santa Clara | 85 | 26268 | 126209 | |
13338 | 13338 | Saratoga | Saratoga | 2022-12-19 | Santa Clara | 85 | 4338 | 30886 | |
13339 | 13339 | Sunnyvale | Sunnyvale | 2022-12-19 | Santa Clara | 85 | 25940 | 152323 | |
14506 | 14506 | Campbell | Campbell | 2022-12-18 | Santa Clara | 85 | 9576 | 42470 | |
14507 | 14507 | Cupertino | Cupertino | 2022-12-18 | Santa Clara | 85 | 8096 | 60614 | |
14508 | 14508 | Gilroy | Gilroy | 2022-12-18 | Santa Clara | 85 | 20012 | 55525 | |
14509 | 14509 | Los Altos | Los Altos | 2022-12-18 | Santa Clara | 85 | 4728 | 30588 | |
14510 | 14510 | Los Altos Hills | Los Altos Hills | 2022-12-18 | Santa Clara | 85 | 1193 | 8517 | |
14511 | 14511 | Los Gatos | Los Gatos | 2022-12-18 | Santa Clara | 85 | 6556 | 30922 | |
14512 | 14512 | Milpitas | Milpitas | 2022-12-18 | Santa Clara | 85 | 16591 | 77457 | |
14513 | 14513 | Monte Sereno | Monte Sereno | 2022-12-18 | Santa Clara | 85 | 299 | 3492 | |
14514 | 14514 | Morgan Hill | Morgan Hill | 2022-12-18 | Santa Clara | 85 | 13196 | 43876 | |
14515 | 14515 | Mountain View | Mountain View | 2022-12-18 | Santa Clara | 85 | 13396 | 80993 | |
14516 | 14516 | Palo Alto | Palo Alto | 2022-12-18 | Santa Clara | 85 | 10377 | 67019 | |
14517 | 14517 | San Jose | San Jose | 2022-12-18 | Santa Clara | 85 | 276076 | 1026658 | |
14518 | 14518 | Santa Clara | Santa Clara | 2022-12-18 | Santa Clara | 85 | 26268 | 126209 | |
14519 | 14519 | Saratoga | Saratoga | 2022-12-18 | Santa Clara | 85 | 4338 | 30886 | |
14520 | 14520 | Sunnyvale | Sunnyvale | 2022-12-18 | Santa Clara | 85 | 25940 | 152323 | |
15687 | 15687 | Campbell | Campbell | 2022-12-17 | Santa Clara | 85 | 9576 | 42470 | |
15688 | 15688 | Cupertino | Cupertino | 2022-12-17 | Santa Clara | 85 | 8096 | 60614 | |
15689 | 15689 | Gilroy | Gilroy | 2022-12-17 | Santa Clara | 85 | 20012 | 55525 | |
15690 | 15690 | Los Altos | Los Altos | 2022-12-17 | Santa Clara | 85 | 4728 | 30588 | |
15691 | 15691 | Los Altos Hills | Los Altos Hills | 2022-12-17 | Santa Clara | 85 | 1193 | 8517 |
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 );