Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_place_totals
This data as json, yaml, copyable, CSV (advanced)
Suggested facets: note, x, y, date (date)
place
fips
county
| Link | rowid | date ▲ | county | fips | place | confirmed_cases | note | x | y |
|---|---|---|---|---|---|---|---|---|---|
| 884 | 884 | 2020-10-27 | Santa Clara | 85 | Campbell | 437 | -121.955 | 37.283889 | |
| 885 | 885 | 2020-10-27 | Santa Clara | 85 | Cupertino | 148 | -122.031944 | 37.323056 | |
| 886 | 886 | 2020-10-27 | Santa Clara | 85 | Gilroy | 1721 | -121.58 | 37.011944 | |
| 887 | 887 | 2020-10-27 | Santa Clara | 85 | Los Altos | 136 | -122.0975 | 37.368056 | |
| 888 | 888 | 2020-10-27 | Santa Clara | 85 | Los Altos Hills | 41 | -122.1375 | 37.371389 | |
| 889 | 889 | 2020-10-27 | Santa Clara | 85 | Los Gatos | 204 | -121.961667 | 37.236111 | |
| 890 | 890 | 2020-10-27 | Santa Clara | 85 | Milpitas | 634 | -121.895 | 37.434722 | |
| 891 | 891 | 2020-10-27 | Santa Clara | 85 | Monte Sereno | 20 | -121.989444 | 37.238056 | |
| 892 | 892 | 2020-10-27 | Santa Clara | 85 | Morgan Hill | 674 | -121.654444 | 37.130556 | |
| 893 | 893 | 2020-10-27 | Santa Clara | 85 | Mountain View | 654 | -122.081944 | 37.389444 | |
| 894 | 894 | 2020-10-27 | Santa Clara | 85 | Palo Alto | 332 | -122.138056 | 37.429167 | |
| 895 | 895 | 2020-10-27 | Santa Clara | 85 | San Jose | 16006 | -121.9 | 37.333333 | |
| 896 | 896 | 2020-10-27 | Santa Clara | 85 | Santa Clara | 1151 | -121.969167 | 37.354444 | |
| 897 | 897 | 2020-10-27 | Santa Clara | 85 | Saratoga | 135 | -122.019444 | 37.2725 | |
| 898 | 898 | 2020-10-27 | Santa Clara | 85 | Sunnyvale | 1065 | -122.0375 | 37.371111 | |
| 1842 | 1842 | 2020-10-26 | Santa Clara | 85 | Campbell | 431 | -121.955 | 37.283889 | |
| 1843 | 1843 | 2020-10-26 | Santa Clara | 85 | Cupertino | 145 | -122.031944 | 37.323056 | |
| 1844 | 1844 | 2020-10-26 | Santa Clara | 85 | Gilroy | 1705 | -121.58 | 37.011944 | |
| 1845 | 1845 | 2020-10-26 | Santa Clara | 85 | Los Altos | 132 | -122.0975 | 37.368056 | |
| 1846 | 1846 | 2020-10-26 | Santa Clara | 85 | Los Altos Hills | 40 | -122.1375 | 37.371389 | |
| 1847 | 1847 | 2020-10-26 | Santa Clara | 85 | Los Gatos | 204 | -121.961667 | 37.236111 | |
| 1848 | 1848 | 2020-10-26 | Santa Clara | 85 | Milpitas | 631 | -121.895 | 37.434722 | |
| 1849 | 1849 | 2020-10-26 | Santa Clara | 85 | Monte Sereno | 20 | -121.989444 | 37.238056 | |
| 1850 | 1850 | 2020-10-26 | Santa Clara | 85 | Morgan Hill | 666 | -121.654444 | 37.130556 | |
| 1851 | 1851 | 2020-10-26 | Santa Clara | 85 | Mountain View | 651 | -122.081944 | 37.389444 | |
| 1852 | 1852 | 2020-10-26 | Santa Clara | 85 | Palo Alto | 330 | -122.138056 | 37.429167 | |
| 1853 | 1853 | 2020-10-26 | Santa Clara | 85 | San Jose | 15899 | -121.9 | 37.333333 | |
| 1854 | 1854 | 2020-10-26 | Santa Clara | 85 | Santa Clara | 1147 | -121.969167 | 37.354444 | |
| 1855 | 1855 | 2020-10-26 | Santa Clara | 85 | Saratoga | 133 | -122.019444 | 37.2725 | |
| 1856 | 1856 | 2020-10-26 | Santa Clara | 85 | Sunnyvale | 1057 | -122.0375 | 37.371111 | |
| 2565 | 2565 | 2020-10-25 | Santa Clara | 85 | Campbell | 426 | -121.955 | 37.283889 | |
| 2566 | 2566 | 2020-10-25 | Santa Clara | 85 | Cupertino | 144 | -122.031944 | 37.323056 | |
| 2567 | 2567 | 2020-10-25 | Santa Clara | 85 | Gilroy | 1697 | -121.58 | 37.011944 | |
| 2568 | 2568 | 2020-10-25 | Santa Clara | 85 | Los Altos | 131 | -122.0975 | 37.368056 | |
| 2569 | 2569 | 2020-10-25 | Santa Clara | 85 | Los Altos Hills | 39 | -122.1375 | 37.371389 | |
| 2570 | 2570 | 2020-10-25 | Santa Clara | 85 | Los Gatos | 205 | -121.961667 | 37.236111 | |
| 2571 | 2571 | 2020-10-25 | Santa Clara | 85 | Milpitas | 628 | -121.895 | 37.434722 | |
| 2572 | 2572 | 2020-10-25 | Santa Clara | 85 | Monte Sereno | 20 | -121.989444 | 37.238056 | |
| 2573 | 2573 | 2020-10-25 | Santa Clara | 85 | Morgan Hill | 662 | -121.654444 | 37.130556 | |
| 2574 | 2574 | 2020-10-25 | Santa Clara | 85 | Mountain View | 648 | -122.081944 | 37.389444 | |
| 2575 | 2575 | 2020-10-25 | Santa Clara | 85 | Palo Alto | 328 | -122.138056 | 37.429167 | |
| 2576 | 2576 | 2020-10-25 | Santa Clara | 85 | San Jose | 15817 | -121.9 | 37.333333 | |
| 2577 | 2577 | 2020-10-25 | Santa Clara | 85 | Santa Clara | 1144 | -121.969167 | 37.354444 | |
| 2578 | 2578 | 2020-10-25 | Santa Clara | 85 | Saratoga | 131 | -122.019444 | 37.2725 | |
| 2579 | 2579 | 2020-10-25 | Santa Clara | 85 | Sunnyvale | 1051 | -122.0375 | 37.371111 | |
| 3163 | 3163 | 2020-10-24 | Santa Clara | 85 | Campbell | 425 | -121.955 | 37.283889 | |
| 3164 | 3164 | 2020-10-24 | Santa Clara | 85 | Cupertino | 143 | -122.031944 | 37.323056 | |
| 3165 | 3165 | 2020-10-24 | Santa Clara | 85 | Gilroy | 1692 | -121.58 | 37.011944 | |
| 3166 | 3166 | 2020-10-24 | Santa Clara | 85 | Los Altos | 132 | -122.0975 | 37.368056 | |
| 3167 | 3167 | 2020-10-24 | Santa Clara | 85 | Los Altos Hills | 38 | -122.1375 | 37.371389 | |
| 3168 | 3168 | 2020-10-24 | Santa Clara | 85 | Los Gatos | 203 | -121.961667 | 37.236111 | |
| 3169 | 3169 | 2020-10-24 | Santa Clara | 85 | Milpitas | 624 | -121.895 | 37.434722 | |
| 3170 | 3170 | 2020-10-24 | Santa Clara | 85 | Monte Sereno | 19 | -121.989444 | 37.238056 | |
| 3171 | 3171 | 2020-10-24 | Santa Clara | 85 | Morgan Hill | 661 | -121.654444 | 37.130556 | |
| 3172 | 3172 | 2020-10-24 | Santa Clara | 85 | Mountain View | 647 | -122.081944 | 37.389444 | |
| 3173 | 3173 | 2020-10-24 | Santa Clara | 85 | Palo Alto | 326 | -122.138056 | 37.429167 | |
| 3174 | 3174 | 2020-10-24 | Santa Clara | 85 | San Jose | 15732 | -121.9 | 37.333333 | |
| 3175 | 3175 | 2020-10-24 | Santa Clara | 85 | Santa Clara | 1137 | -121.969167 | 37.354444 | |
| 3176 | 3176 | 2020-10-24 | Santa Clara | 85 | Saratoga | 129 | -122.019444 | 37.2725 | |
| 3177 | 3177 | 2020-10-24 | Santa Clara | 85 | Sunnyvale | 1048 | -122.0375 | 37.371111 | |
| 4159 | 4159 | 2020-10-23 | Santa Clara | 85 | Campbell | 420 | -121.955 | 37.283889 | |
| 4160 | 4160 | 2020-10-23 | Santa Clara | 85 | Cupertino | 140 | -122.031944 | 37.323056 | |
| 4161 | 4161 | 2020-10-23 | Santa Clara | 85 | Gilroy | 1671 | -121.58 | 37.011944 | |
| 4162 | 4162 | 2020-10-23 | Santa Clara | 85 | Los Altos | 131 | -122.0975 | 37.368056 | |
| 4163 | 4163 | 2020-10-23 | Santa Clara | 85 | Los Altos Hills | 38 | -122.1375 | 37.371389 | |
| 4164 | 4164 | 2020-10-23 | Santa Clara | 85 | Los Gatos | 198 | -121.961667 | 37.236111 | |
| 4165 | 4165 | 2020-10-23 | Santa Clara | 85 | Milpitas | 618 | -121.895 | 37.434722 | |
| 4166 | 4166 | 2020-10-23 | Santa Clara | 85 | Monte Sereno | 19 | -121.989444 | 37.238056 | |
| 4167 | 4167 | 2020-10-23 | Santa Clara | 85 | Morgan Hill | 656 | -121.654444 | 37.130556 | |
| 4168 | 4168 | 2020-10-23 | Santa Clara | 85 | Mountain View | 646 | -122.081944 | 37.389444 | |
| 4169 | 4169 | 2020-10-23 | Santa Clara | 85 | Palo Alto | 324 | -122.138056 | 37.429167 | |
| 4170 | 4170 | 2020-10-23 | Santa Clara | 85 | San Jose | 15609 | -121.9 | 37.333333 | |
| 4171 | 4171 | 2020-10-23 | Santa Clara | 85 | Santa Clara | 1128 | -121.969167 | 37.354444 | |
| 4172 | 4172 | 2020-10-23 | Santa Clara | 85 | Saratoga | 127 | -122.019444 | 37.2725 | |
| 4173 | 4173 | 2020-10-23 | Santa Clara | 85 | Sunnyvale | 1043 | -122.0375 | 37.371111 | |
| 5128 | 5128 | 2020-10-22 | Santa Clara | 85 | Campbell | 416 | -121.955 | 37.283889 | |
| 5129 | 5129 | 2020-10-22 | Santa Clara | 85 | Cupertino | 141 | -122.031944 | 37.323056 | |
| 5130 | 5130 | 2020-10-22 | Santa Clara | 85 | Gilroy | 1667 | -121.58 | 37.011944 | |
| 5131 | 5131 | 2020-10-22 | Santa Clara | 85 | Los Altos | 131 | -122.0975 | 37.368056 | |
| 5132 | 5132 | 2020-10-22 | Santa Clara | 85 | Los Altos Hills | 38 | -122.1375 | 37.371389 | |
| 5133 | 5133 | 2020-10-22 | Santa Clara | 85 | Los Gatos | 197 | -121.961667 | 37.236111 | |
| 5134 | 5134 | 2020-10-22 | Santa Clara | 85 | Milpitas | 616 | -121.895 | 37.434722 | |
| 5135 | 5135 | 2020-10-22 | Santa Clara | 85 | Monte Sereno | 19 | -121.989444 | 37.238056 | |
| 5136 | 5136 | 2020-10-22 | Santa Clara | 85 | Morgan Hill | 654 | -121.654444 | 37.130556 | |
| 5137 | 5137 | 2020-10-22 | Santa Clara | 85 | Mountain View | 643 | -122.081944 | 37.389444 | |
| 5138 | 5138 | 2020-10-22 | Santa Clara | 85 | Palo Alto | 322 | -122.138056 | 37.429167 | |
| 5139 | 5139 | 2020-10-22 | Santa Clara | 85 | San Jose | 15551 | -121.9 | 37.333333 | |
| 5140 | 5140 | 2020-10-22 | Santa Clara | 85 | Santa Clara | 1121 | -121.969167 | 37.354444 | |
| 5141 | 5141 | 2020-10-22 | Santa Clara | 85 | Saratoga | 127 | -122.019444 | 37.2725 | |
| 5142 | 5142 | 2020-10-22 | Santa Clara | 85 | Sunnyvale | 1041 | -122.0375 | 37.371111 | |
| 6102 | 6102 | 2020-10-21 | Santa Clara | 85 | Campbell | 416 | -121.955 | 37.283889 | |
| 6103 | 6103 | 2020-10-21 | Santa Clara | 85 | Cupertino | 141 | -122.031944 | 37.323056 | |
| 6104 | 6104 | 2020-10-21 | Santa Clara | 85 | Gilroy | 1667 | -121.58 | 37.011944 | |
| 6105 | 6105 | 2020-10-21 | Santa Clara | 85 | Los Altos | 131 | -122.0975 | 37.368056 | |
| 6106 | 6106 | 2020-10-21 | Santa Clara | 85 | Los Altos Hills | 38 | -122.1375 | 37.371389 | |
| 6107 | 6107 | 2020-10-21 | Santa Clara | 85 | Los Gatos | 197 | -121.961667 | 37.236111 | |
| 6108 | 6108 | 2020-10-21 | Santa Clara | 85 | Milpitas | 616 | -121.895 | 37.434722 | |
| 6109 | 6109 | 2020-10-21 | Santa Clara | 85 | Monte Sereno | 19 | -121.989444 | 37.238056 | |
| 6110 | 6110 | 2020-10-21 | Santa Clara | 85 | Morgan Hill | 654 | -121.654444 | 37.130556 | |
| 6111 | 6111 | 2020-10-21 | Santa Clara | 85 | Mountain View | 643 | -122.081944 | 37.389444 |
JSON shape: default, array, newline-delimited
CREATE TABLE [latimes_place_totals] ( [date] TEXT, [county] TEXT, [fips] INTEGER, [place] TEXT, [confirmed_cases] INTEGER, [note] TEXT, [x] TEXT, [y] TEXT );