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 |
---|---|---|---|---|---|---|---|---|---|
1040256 | 1040256 | Campbell | Campbell | 2020-09-25 | Santa Clara | 85 | 348 | 42470 | |
1040257 | 1040257 | Cupertino | Cupertino | 2020-09-25 | Santa Clara | 85 | 116 | 60614 | |
1040258 | 1040258 | Gilroy | Gilroy | 2020-09-25 | Santa Clara | 85 | 1505 | 55525 | |
1040259 | 1040259 | Los Altos | Los Altos | 2020-09-25 | Santa Clara | 85 | 121 | 30588 | |
1040260 | 1040260 | Los Altos Hills | Los Altos Hills | 2020-09-25 | Santa Clara | 85 | 33 | 8517 | |
1040261 | 1040261 | Los Gatos | Los Gatos | 2020-09-25 | Santa Clara | 85 | 169 | 30922 | |
1040262 | 1040262 | Milpitas | Milpitas | 2020-09-25 | Santa Clara | 85 | 536 | 77457 | |
1040263 | 1040263 | Monte Sereno | Monte Sereno | 2020-09-25 | Santa Clara | 85 | 19 | 3492 | |
1040264 | 1040264 | Morgan Hill | Morgan Hill | 2020-09-25 | Santa Clara | 85 | 607 | 43876 | |
1040265 | 1040265 | Mountain View | Mountain View | 2020-09-25 | Santa Clara | 85 | 562 | 80993 | |
1040266 | 1040266 | Palo Alto | Palo Alto | 2020-09-25 | Santa Clara | 85 | 293 | 67019 | |
1040267 | 1040267 | San Jose | San Jose | 2020-09-25 | Santa Clara | 85 | 13740 | 1026658 | |
1040268 | 1040268 | Santa Clara | Santa Clara | 2020-09-25 | Santa Clara | 85 | 956 | 126209 | |
1040269 | 1040269 | Saratoga | Saratoga | 2020-09-25 | Santa Clara | 85 | 107 | 30886 | |
1040270 | 1040270 | Sunnyvale | Sunnyvale | 2020-09-25 | Santa Clara | 85 | 946 | 152323 | |
1041448 | 1041448 | Campbell | Campbell | 2020-09-24 | Santa Clara | 85 | 346 | 42470 | |
1041449 | 1041449 | Cupertino | Cupertino | 2020-09-24 | Santa Clara | 85 | 115 | 60614 | |
1041450 | 1041450 | Gilroy | Gilroy | 2020-09-24 | Santa Clara | 85 | 1498 | 55525 | |
1041451 | 1041451 | Los Altos | Los Altos | 2020-09-24 | Santa Clara | 85 | 120 | 30588 | |
1041452 | 1041452 | Los Altos Hills | Los Altos Hills | 2020-09-24 | Santa Clara | 85 | 33 | 8517 | |
1041453 | 1041453 | Los Gatos | Los Gatos | 2020-09-24 | Santa Clara | 85 | 169 | 30922 | |
1041454 | 1041454 | Milpitas | Milpitas | 2020-09-24 | Santa Clara | 85 | 534 | 77457 | |
1041455 | 1041455 | Monte Sereno | Monte Sereno | 2020-09-24 | Santa Clara | 85 | 19 | 3492 | |
1041456 | 1041456 | Morgan Hill | Morgan Hill | 2020-09-24 | Santa Clara | 85 | 602 | 43876 | |
1041457 | 1041457 | Mountain View | Mountain View | 2020-09-24 | Santa Clara | 85 | 560 | 80993 | |
1041458 | 1041458 | Palo Alto | Palo Alto | 2020-09-24 | Santa Clara | 85 | 291 | 67019 | |
1041459 | 1041459 | San Jose | San Jose | 2020-09-24 | Santa Clara | 85 | 13664 | 1026658 | |
1041460 | 1041460 | Santa Clara | Santa Clara | 2020-09-24 | Santa Clara | 85 | 952 | 126209 | |
1041461 | 1041461 | Saratoga | Saratoga | 2020-09-24 | Santa Clara | 85 | 107 | 30886 | |
1041462 | 1041462 | Sunnyvale | Sunnyvale | 2020-09-24 | Santa Clara | 85 | 936 | 152323 | |
1042640 | 1042640 | Campbell | Campbell | 2020-09-23 | Santa Clara | 85 | 345 | 42470 | |
1042641 | 1042641 | Cupertino | Cupertino | 2020-09-23 | Santa Clara | 85 | 112 | 60614 | |
1042642 | 1042642 | Gilroy | Gilroy | 2020-09-23 | Santa Clara | 85 | 1480 | 55525 | |
1042643 | 1042643 | Los Altos | Los Altos | 2020-09-23 | Santa Clara | 85 | 119 | 30588 | |
1042644 | 1042644 | Los Altos Hills | Los Altos Hills | 2020-09-23 | Santa Clara | 85 | 31 | 8517 | |
1042645 | 1042645 | Los Gatos | Los Gatos | 2020-09-23 | Santa Clara | 85 | 166 | 30922 | |
1042646 | 1042646 | Milpitas | Milpitas | 2020-09-23 | Santa Clara | 85 | 529 | 77457 | |
1042647 | 1042647 | Monte Sereno | Monte Sereno | 2020-09-23 | Santa Clara | 85 | 19 | 3492 | |
1042648 | 1042648 | Morgan Hill | Morgan Hill | 2020-09-23 | Santa Clara | 85 | 594 | 43876 | |
1042649 | 1042649 | Mountain View | Mountain View | 2020-09-23 | Santa Clara | 85 | 553 | 80993 | |
1042650 | 1042650 | Palo Alto | Palo Alto | 2020-09-23 | Santa Clara | 85 | 285 | 67019 | |
1042651 | 1042651 | San Jose | San Jose | 2020-09-23 | Santa Clara | 85 | 13550 | 1026658 | |
1042652 | 1042652 | Santa Clara | Santa Clara | 2020-09-23 | Santa Clara | 85 | 943 | 126209 | |
1042653 | 1042653 | Saratoga | Saratoga | 2020-09-23 | Santa Clara | 85 | 107 | 30886 | |
1042654 | 1042654 | Sunnyvale | Sunnyvale | 2020-09-23 | Santa Clara | 85 | 925 | 152323 | |
1043832 | 1043832 | Campbell | Campbell | 2020-09-22 | Santa Clara | 85 | 345 | 42470 | |
1043833 | 1043833 | Cupertino | Cupertino | 2020-09-22 | Santa Clara | 85 | 112 | 60614 | |
1043834 | 1043834 | Gilroy | Gilroy | 2020-09-22 | Santa Clara | 85 | 1480 | 55525 | |
1043835 | 1043835 | Los Altos | Los Altos | 2020-09-22 | Santa Clara | 85 | 119 | 30588 | |
1043836 | 1043836 | Los Altos Hills | Los Altos Hills | 2020-09-22 | Santa Clara | 85 | 31 | 8517 | |
1043837 | 1043837 | Los Gatos | Los Gatos | 2020-09-22 | Santa Clara | 85 | 166 | 30922 | |
1043838 | 1043838 | Milpitas | Milpitas | 2020-09-22 | Santa Clara | 85 | 529 | 77457 | |
1043839 | 1043839 | Monte Sereno | Monte Sereno | 2020-09-22 | Santa Clara | 85 | 19 | 3492 | |
1043840 | 1043840 | Morgan Hill | Morgan Hill | 2020-09-22 | Santa Clara | 85 | 594 | 43876 | |
1043841 | 1043841 | Mountain View | Mountain View | 2020-09-22 | Santa Clara | 85 | 553 | 80993 | |
1043842 | 1043842 | Palo Alto | Palo Alto | 2020-09-22 | Santa Clara | 85 | 285 | 67019 | |
1043843 | 1043843 | San Jose | San Jose | 2020-09-22 | Santa Clara | 85 | 13550 | 1026658 | |
1043844 | 1043844 | Santa Clara | Santa Clara | 2020-09-22 | Santa Clara | 85 | 943 | 126209 | |
1043845 | 1043845 | Saratoga | Saratoga | 2020-09-22 | Santa Clara | 85 | 107 | 30886 | |
1043846 | 1043846 | Sunnyvale | Sunnyvale | 2020-09-22 | Santa Clara | 85 | 925 | 152323 | |
1045024 | 1045024 | Campbell | Campbell | 2020-09-21 | Santa Clara | 85 | 344 | 42470 | |
1045025 | 1045025 | Cupertino | Cupertino | 2020-09-21 | Santa Clara | 85 | 112 | 60614 | |
1045026 | 1045026 | Gilroy | Gilroy | 2020-09-21 | Santa Clara | 85 | 1474 | 55525 | |
1045027 | 1045027 | Los Altos | Los Altos | 2020-09-21 | Santa Clara | 85 | 119 | 30588 | |
1045028 | 1045028 | Los Altos Hills | Los Altos Hills | 2020-09-21 | Santa Clara | 85 | 31 | 8517 | |
1045029 | 1045029 | Los Gatos | Los Gatos | 2020-09-21 | Santa Clara | 85 | 166 | 30922 | |
1045030 | 1045030 | Milpitas | Milpitas | 2020-09-21 | Santa Clara | 85 | 524 | 77457 | |
1045031 | 1045031 | Monte Sereno | Monte Sereno | 2020-09-21 | Santa Clara | 85 | 19 | 3492 | |
1045032 | 1045032 | Morgan Hill | Morgan Hill | 2020-09-21 | Santa Clara | 85 | 592 | 43876 | |
1045033 | 1045033 | Mountain View | Mountain View | 2020-09-21 | Santa Clara | 85 | 551 | 80993 | |
1045034 | 1045034 | Palo Alto | Palo Alto | 2020-09-21 | Santa Clara | 85 | 284 | 67019 | |
1045035 | 1045035 | San Jose | San Jose | 2020-09-21 | Santa Clara | 85 | 13502 | 1026658 | |
1045036 | 1045036 | Santa Clara | Santa Clara | 2020-09-21 | Santa Clara | 85 | 937 | 126209 | |
1045037 | 1045037 | Saratoga | Saratoga | 2020-09-21 | Santa Clara | 85 | 107 | 30886 | |
1045038 | 1045038 | Sunnyvale | Sunnyvale | 2020-09-21 | Santa Clara | 85 | 917 | 152323 | |
1046216 | 1046216 | Campbell | Campbell | 2020-09-20 | Santa Clara | 85 | 338 | 42470 | |
1046217 | 1046217 | Cupertino | Cupertino | 2020-09-20 | Santa Clara | 85 | 113 | 60614 | |
1046218 | 1046218 | Gilroy | Gilroy | 2020-09-20 | Santa Clara | 85 | 1465 | 55525 | |
1046219 | 1046219 | Los Altos | Los Altos | 2020-09-20 | Santa Clara | 85 | 117 | 30588 | |
1046220 | 1046220 | Los Altos Hills | Los Altos Hills | 2020-09-20 | Santa Clara | 85 | 31 | 8517 | |
1046221 | 1046221 | Los Gatos | Los Gatos | 2020-09-20 | Santa Clara | 85 | 166 | 30922 | |
1046222 | 1046222 | Milpitas | Milpitas | 2020-09-20 | Santa Clara | 85 | 520 | 77457 | |
1046223 | 1046223 | Monte Sereno | Monte Sereno | 2020-09-20 | Santa Clara | 85 | 19 | 3492 | |
1046224 | 1046224 | Morgan Hill | Morgan Hill | 2020-09-20 | Santa Clara | 85 | 591 | 43876 | |
1046225 | 1046225 | Mountain View | Mountain View | 2020-09-20 | Santa Clara | 85 | 549 | 80993 | |
1046226 | 1046226 | Palo Alto | Palo Alto | 2020-09-20 | Santa Clara | 85 | 281 | 67019 | |
1046227 | 1046227 | San Jose | San Jose | 2020-09-20 | Santa Clara | 85 | 13438 | 1026658 | |
1046228 | 1046228 | Santa Clara | Santa Clara | 2020-09-20 | Santa Clara | 85 | 931 | 126209 | |
1046229 | 1046229 | Saratoga | Saratoga | 2020-09-20 | Santa Clara | 85 | 107 | 30886 | |
1046230 | 1046230 | Sunnyvale | Sunnyvale | 2020-09-20 | Santa Clara | 85 | 915 | 152323 | |
1047408 | 1047408 | Campbell | Campbell | 2020-09-19 | Santa Clara | 85 | 335 | 42470 | |
1047409 | 1047409 | Cupertino | Cupertino | 2020-09-19 | Santa Clara | 85 | 111 | 60614 | |
1047410 | 1047410 | Gilroy | Gilroy | 2020-09-19 | Santa Clara | 85 | 1441 | 55525 | |
1047411 | 1047411 | Los Altos | Los Altos | 2020-09-19 | Santa Clara | 85 | 117 | 30588 | |
1047412 | 1047412 | Los Altos Hills | Los Altos Hills | 2020-09-19 | Santa Clara | 85 | 31 | 8517 | |
1047413 | 1047413 | Los Gatos | Los Gatos | 2020-09-19 | Santa Clara | 85 | 163 | 30922 | |
1047414 | 1047414 | Milpitas | Milpitas | 2020-09-19 | Santa Clara | 85 | 516 | 77457 | |
1047415 | 1047415 | Monte Sereno | Monte Sereno | 2020-09-19 | Santa Clara | 85 | 19 | 3492 | |
1047416 | 1047416 | Morgan Hill | Morgan Hill | 2020-09-19 | Santa Clara | 85 | 588 | 43876 | |
1047417 | 1047417 | Mountain View | Mountain View | 2020-09-19 | Santa Clara | 85 | 547 | 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 );