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 |
---|---|---|---|---|---|---|---|---|---|
906589 | 906589 | Campbell | Campbell | 2021-01-13 | Santa Clara | 85 | 1507 | 42470 | |
906590 | 906590 | Cupertino | Cupertino | 2021-01-13 | Santa Clara | 85 | 645 | 60614 | |
906591 | 906591 | Gilroy | Gilroy | 2021-01-13 | Santa Clara | 85 | 5743 | 55525 | |
906592 | 906592 | Los Altos | Los Altos | 2021-01-13 | Santa Clara | 85 | 493 | 30588 | |
906593 | 906593 | Los Altos Hills | Los Altos Hills | 2021-01-13 | Santa Clara | 85 | 159 | 8517 | |
906594 | 906594 | Los Gatos | Los Gatos | 2021-01-13 | Santa Clara | 85 | 840 | 30922 | |
906595 | 906595 | Milpitas | Milpitas | 2021-01-13 | Santa Clara | 85 | 2601 | 77457 | |
906596 | 906596 | Monte Sereno | Monte Sereno | 2021-01-13 | Santa Clara | 85 | 63 | 3492 | |
906597 | 906597 | Morgan Hill | Morgan Hill | 2021-01-13 | Santa Clara | 85 | 2627 | 43876 | |
906598 | 906598 | Mountain View | Mountain View | 2021-01-13 | Santa Clara | 85 | 2173 | 80993 | |
906599 | 906599 | Palo Alto | Palo Alto | 2021-01-13 | Santa Clara | 85 | 1023 | 67019 | |
906600 | 906600 | San Jose | San Jose | 2021-01-13 | Santa Clara | 85 | 57444 | 1026658 | |
906601 | 906601 | Santa Clara | Santa Clara | 2021-01-13 | Santa Clara | 85 | 3761 | 126209 | |
906602 | 906602 | Saratoga | Saratoga | 2021-01-13 | Santa Clara | 85 | 449 | 30886 | |
906603 | 906603 | Sunnyvale | Sunnyvale | 2021-01-13 | Santa Clara | 85 | 3878 | 152323 | |
907865 | 907865 | Campbell | Campbell | 2021-01-12 | Santa Clara | 85 | 1496 | 42470 | |
907866 | 907866 | Cupertino | Cupertino | 2021-01-12 | Santa Clara | 85 | 637 | 60614 | |
907867 | 907867 | Gilroy | Gilroy | 2021-01-12 | Santa Clara | 85 | 5694 | 55525 | |
907868 | 907868 | Los Altos | Los Altos | 2021-01-12 | Santa Clara | 85 | 488 | 30588 | |
907869 | 907869 | Los Altos Hills | Los Altos Hills | 2021-01-12 | Santa Clara | 85 | 158 | 8517 | |
907870 | 907870 | Los Gatos | Los Gatos | 2021-01-12 | Santa Clara | 85 | 832 | 30922 | |
907871 | 907871 | Milpitas | Milpitas | 2021-01-12 | Santa Clara | 85 | 2549 | 77457 | |
907872 | 907872 | Monte Sereno | Monte Sereno | 2021-01-12 | Santa Clara | 85 | 62 | 3492 | |
907873 | 907873 | Morgan Hill | Morgan Hill | 2021-01-12 | Santa Clara | 85 | 2605 | 43876 | |
907874 | 907874 | Mountain View | Mountain View | 2021-01-12 | Santa Clara | 85 | 2137 | 80993 | |
907875 | 907875 | Palo Alto | Palo Alto | 2021-01-12 | Santa Clara | 85 | 1015 | 67019 | |
907876 | 907876 | San Jose | San Jose | 2021-01-12 | Santa Clara | 85 | 56710 | 1026658 | |
907877 | 907877 | Santa Clara | Santa Clara | 2021-01-12 | Santa Clara | 85 | 3702 | 126209 | |
907878 | 907878 | Saratoga | Saratoga | 2021-01-12 | Santa Clara | 85 | 445 | 30886 | |
907879 | 907879 | Sunnyvale | Sunnyvale | 2021-01-12 | Santa Clara | 85 | 3823 | 152323 | |
909141 | 909141 | Campbell | Campbell | 2021-01-11 | Santa Clara | 85 | 1477 | 42470 | |
909142 | 909142 | Cupertino | Cupertino | 2021-01-11 | Santa Clara | 85 | 627 | 60614 | |
909143 | 909143 | Gilroy | Gilroy | 2021-01-11 | Santa Clara | 85 | 5644 | 55525 | |
909144 | 909144 | Los Altos | Los Altos | 2021-01-11 | Santa Clara | 85 | 479 | 30588 | |
909145 | 909145 | Los Altos Hills | Los Altos Hills | 2021-01-11 | Santa Clara | 85 | 154 | 8517 | |
909146 | 909146 | Los Gatos | Los Gatos | 2021-01-11 | Santa Clara | 85 | 823 | 30922 | |
909147 | 909147 | Milpitas | Milpitas | 2021-01-11 | Santa Clara | 85 | 2514 | 77457 | |
909148 | 909148 | Monte Sereno | Monte Sereno | 2021-01-11 | Santa Clara | 85 | 62 | 3492 | |
909149 | 909149 | Morgan Hill | Morgan Hill | 2021-01-11 | Santa Clara | 85 | 2574 | 43876 | |
909150 | 909150 | Mountain View | Mountain View | 2021-01-11 | Santa Clara | 85 | 2110 | 80993 | |
909151 | 909151 | Palo Alto | Palo Alto | 2021-01-11 | Santa Clara | 85 | 999 | 67019 | |
909152 | 909152 | San Jose | San Jose | 2021-01-11 | Santa Clara | 85 | 55880 | 1026658 | |
909153 | 909153 | Santa Clara | Santa Clara | 2021-01-11 | Santa Clara | 85 | 3646 | 126209 | |
909154 | 909154 | Saratoga | Saratoga | 2021-01-11 | Santa Clara | 85 | 435 | 30886 | |
909155 | 909155 | Sunnyvale | Sunnyvale | 2021-01-11 | Santa Clara | 85 | 3763 | 152323 | |
910417 | 910417 | Campbell | Campbell | 2021-01-10 | Santa Clara | 85 | 1463 | 42470 | |
910418 | 910418 | Cupertino | Cupertino | 2021-01-10 | Santa Clara | 85 | 621 | 60614 | |
910419 | 910419 | Gilroy | Gilroy | 2021-01-10 | Santa Clara | 85 | 5556 | 55525 | |
910420 | 910420 | Los Altos | Los Altos | 2021-01-10 | Santa Clara | 85 | 474 | 30588 | |
910421 | 910421 | Los Altos Hills | Los Altos Hills | 2021-01-10 | Santa Clara | 85 | 155 | 8517 | |
910422 | 910422 | Los Gatos | Los Gatos | 2021-01-10 | Santa Clara | 85 | 819 | 30922 | |
910423 | 910423 | Milpitas | Milpitas | 2021-01-10 | Santa Clara | 85 | 2487 | 77457 | |
910424 | 910424 | Monte Sereno | Monte Sereno | 2021-01-10 | Santa Clara | 85 | 62 | 3492 | |
910425 | 910425 | Morgan Hill | Morgan Hill | 2021-01-10 | Santa Clara | 85 | 2536 | 43876 | |
910426 | 910426 | Mountain View | Mountain View | 2021-01-10 | Santa Clara | 85 | 2088 | 80993 | |
910427 | 910427 | Palo Alto | Palo Alto | 2021-01-10 | Santa Clara | 85 | 988 | 67019 | |
910428 | 910428 | San Jose | San Jose | 2021-01-10 | Santa Clara | 85 | 55173 | 1026658 | |
910429 | 910429 | Santa Clara | Santa Clara | 2021-01-10 | Santa Clara | 85 | 3591 | 126209 | |
910430 | 910430 | Saratoga | Saratoga | 2021-01-10 | Santa Clara | 85 | 431 | 30886 | |
910431 | 910431 | Sunnyvale | Sunnyvale | 2021-01-10 | Santa Clara | 85 | 3697 | 152323 | |
911693 | 911693 | Campbell | Campbell | 2021-01-09 | Santa Clara | 85 | 1399 | 42470 | |
911694 | 911694 | Cupertino | Cupertino | 2021-01-09 | Santa Clara | 85 | 607 | 60614 | |
911695 | 911695 | Gilroy | Gilroy | 2021-01-09 | Santa Clara | 85 | 5383 | 55525 | |
911696 | 911696 | Los Altos | Los Altos | 2021-01-09 | Santa Clara | 85 | 470 | 30588 | |
911697 | 911697 | Los Altos Hills | Los Altos Hills | 2021-01-09 | Santa Clara | 85 | 148 | 8517 | |
911698 | 911698 | Los Gatos | Los Gatos | 2021-01-09 | Santa Clara | 85 | 799 | 30922 | |
911699 | 911699 | Milpitas | Milpitas | 2021-01-09 | Santa Clara | 85 | 2387 | 77457 | |
911700 | 911700 | Monte Sereno | Monte Sereno | 2021-01-09 | Santa Clara | 85 | 62 | 3492 | |
911701 | 911701 | Morgan Hill | Morgan Hill | 2021-01-09 | Santa Clara | 85 | 2418 | 43876 | |
911702 | 911702 | Mountain View | Mountain View | 2021-01-09 | Santa Clara | 85 | 2012 | 80993 | |
911703 | 911703 | Palo Alto | Palo Alto | 2021-01-09 | Santa Clara | 85 | 955 | 67019 | |
911704 | 911704 | San Jose | San Jose | 2021-01-09 | Santa Clara | 85 | 53019 | 1026658 | |
911705 | 911705 | Santa Clara | Santa Clara | 2021-01-09 | Santa Clara | 85 | 3460 | 126209 | |
911706 | 911706 | Saratoga | Saratoga | 2021-01-09 | Santa Clara | 85 | 418 | 30886 | |
911707 | 911707 | Sunnyvale | Sunnyvale | 2021-01-09 | Santa Clara | 85 | 3567 | 152323 | |
912969 | 912969 | Campbell | Campbell | 2021-01-08 | Santa Clara | 85 | 1399 | 42470 | |
912970 | 912970 | Cupertino | Cupertino | 2021-01-08 | Santa Clara | 85 | 607 | 60614 | |
912971 | 912971 | Gilroy | Gilroy | 2021-01-08 | Santa Clara | 85 | 5383 | 55525 | |
912972 | 912972 | Los Altos | Los Altos | 2021-01-08 | Santa Clara | 85 | 470 | 30588 | |
912973 | 912973 | Los Altos Hills | Los Altos Hills | 2021-01-08 | Santa Clara | 85 | 148 | 8517 | |
912974 | 912974 | Los Gatos | Los Gatos | 2021-01-08 | Santa Clara | 85 | 799 | 30922 | |
912975 | 912975 | Milpitas | Milpitas | 2021-01-08 | Santa Clara | 85 | 2387 | 77457 | |
912976 | 912976 | Monte Sereno | Monte Sereno | 2021-01-08 | Santa Clara | 85 | 62 | 3492 | |
912977 | 912977 | Morgan Hill | Morgan Hill | 2021-01-08 | Santa Clara | 85 | 2418 | 43876 | |
912978 | 912978 | Mountain View | Mountain View | 2021-01-08 | Santa Clara | 85 | 2012 | 80993 | |
912979 | 912979 | Palo Alto | Palo Alto | 2021-01-08 | Santa Clara | 85 | 955 | 67019 | |
912980 | 912980 | San Jose | San Jose | 2021-01-08 | Santa Clara | 85 | 53019 | 1026658 | |
912981 | 912981 | Santa Clara | Santa Clara | 2021-01-08 | Santa Clara | 85 | 3460 | 126209 | |
912982 | 912982 | Saratoga | Saratoga | 2021-01-08 | Santa Clara | 85 | 418 | 30886 | |
912983 | 912983 | Sunnyvale | Sunnyvale | 2021-01-08 | Santa Clara | 85 | 3567 | 152323 | |
914245 | 914245 | Campbell | Campbell | 2021-01-07 | Santa Clara | 85 | 1361 | 42470 | |
914246 | 914246 | Cupertino | Cupertino | 2021-01-07 | Santa Clara | 85 | 593 | 60614 | |
914247 | 914247 | Gilroy | Gilroy | 2021-01-07 | Santa Clara | 85 | 5284 | 55525 | |
914248 | 914248 | Los Altos | Los Altos | 2021-01-07 | Santa Clara | 85 | 463 | 30588 | |
914249 | 914249 | Los Altos Hills | Los Altos Hills | 2021-01-07 | Santa Clara | 85 | 142 | 8517 | |
914250 | 914250 | Los Gatos | Los Gatos | 2021-01-07 | Santa Clara | 85 | 780 | 30922 | |
914251 | 914251 | Milpitas | Milpitas | 2021-01-07 | Santa Clara | 85 | 2321 | 77457 | |
914252 | 914252 | Monte Sereno | Monte Sereno | 2021-01-07 | Santa Clara | 85 | 61 | 3492 | |
914253 | 914253 | Morgan Hill | Morgan Hill | 2021-01-07 | Santa Clara | 85 | 2366 | 43876 | |
914254 | 914254 | Mountain View | Mountain View | 2021-01-07 | Santa Clara | 85 | 1961 | 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 );