latimes_place_totals

⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_place_totals

2,766 rows where fips = 85 sorted by date descending

View and edit SQL

Suggested facets: note, x, y, date (date)

fips

  • 85 · 2,766

county

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

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [latimes_place_totals] (
   [date] TEXT,
   [county] TEXT,
   [fips] INTEGER,
   [place] TEXT,
   [confirmed_cases] INTEGER,
   [note] TEXT,
   [x] TEXT,
   [y] TEXT
);
Powered by Datasette · Query took 900.656ms · Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_place_totals