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,706 rows where county = "Santa Clara" sorted by date descending

View and edit SQL

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

fips

  • 85 2,706

county

  • Santa Clara · 2,706
Link rowid date ▲ county fips place confirmed_cases note x y
875 2020-10-23 Santa Clara 85 Campbell 420   -121.955 37.283889
876 2020-10-23 Santa Clara 85 Cupertino 140   -122.031944 37.323056
877 2020-10-23 Santa Clara 85 Gilroy 1671   -121.58 37.011944
878 2020-10-23 Santa Clara 85 Los Altos 131   -122.0975 37.368056
879 2020-10-23 Santa Clara 85 Los Altos Hills 38   -122.1375 37.371389
880 2020-10-23 Santa Clara 85 Los Gatos 198   -121.961667 37.236111
881 2020-10-23 Santa Clara 85 Milpitas 618   -121.895 37.434722
882 2020-10-23 Santa Clara 85 Monte Sereno 19   -121.989444 37.238056
883 2020-10-23 Santa Clara 85 Morgan Hill 656   -121.654444 37.130556
884 2020-10-23 Santa Clara 85 Mountain View 646   -122.081944 37.389444
885 2020-10-23 Santa Clara 85 Palo Alto 324   -122.138056 37.429167
886 2020-10-23 Santa Clara 85 San Jose 15609   -121.9 37.333333
887 2020-10-23 Santa Clara 85 Santa Clara 1128   -121.969167 37.354444
888 2020-10-23 Santa Clara 85 Saratoga 127   -122.019444 37.2725
889 2020-10-23 Santa Clara 85 Sunnyvale 1043   -122.0375 37.371111
1844 2020-10-22 Santa Clara 85 Campbell 416   -121.955 37.283889
1845 2020-10-22 Santa Clara 85 Cupertino 141   -122.031944 37.323056
1846 2020-10-22 Santa Clara 85 Gilroy 1667   -121.58 37.011944
1847 2020-10-22 Santa Clara 85 Los Altos 131   -122.0975 37.368056
1848 2020-10-22 Santa Clara 85 Los Altos Hills 38   -122.1375 37.371389
1849 2020-10-22 Santa Clara 85 Los Gatos 197   -121.961667 37.236111
1850 2020-10-22 Santa Clara 85 Milpitas 616   -121.895 37.434722
1851 2020-10-22 Santa Clara 85 Monte Sereno 19   -121.989444 37.238056
1852 2020-10-22 Santa Clara 85 Morgan Hill 654   -121.654444 37.130556
1853 2020-10-22 Santa Clara 85 Mountain View 643   -122.081944 37.389444
1854 2020-10-22 Santa Clara 85 Palo Alto 322   -122.138056 37.429167
1855 2020-10-22 Santa Clara 85 San Jose 15551   -121.9 37.333333
1856 2020-10-22 Santa Clara 85 Santa Clara 1121   -121.969167 37.354444
1857 2020-10-22 Santa Clara 85 Saratoga 127   -122.019444 37.2725
1858 2020-10-22 Santa Clara 85 Sunnyvale 1041   -122.0375 37.371111
2818 2020-10-21 Santa Clara 85 Campbell 416   -121.955 37.283889
2819 2020-10-21 Santa Clara 85 Cupertino 141   -122.031944 37.323056
2820 2020-10-21 Santa Clara 85 Gilroy 1667   -121.58 37.011944
2821 2020-10-21 Santa Clara 85 Los Altos 131   -122.0975 37.368056
2822 2020-10-21 Santa Clara 85 Los Altos Hills 38   -122.1375 37.371389
2823 2020-10-21 Santa Clara 85 Los Gatos 197   -121.961667 37.236111
2824 2020-10-21 Santa Clara 85 Milpitas 616   -121.895 37.434722
2825 2020-10-21 Santa Clara 85 Monte Sereno 19   -121.989444 37.238056
2826 2020-10-21 Santa Clara 85 Morgan Hill 654   -121.654444 37.130556
2827 2020-10-21 Santa Clara 85 Mountain View 643   -122.081944 37.389444
2828 2020-10-21 Santa Clara 85 Palo Alto 322   -122.138056 37.429167
2829 2020-10-21 Santa Clara 85 San Jose 15551   -121.9 37.333333
2830 2020-10-21 Santa Clara 85 Santa Clara 1121   -121.969167 37.354444
2831 2020-10-21 Santa Clara 85 Saratoga 127   -122.019444 37.2725
2832 2020-10-21 Santa Clara 85 Sunnyvale 1041   -122.0375 37.371111
3829 2020-10-20 Santa Clara 85 Campbell 414   -121.955 37.283889
3830 2020-10-20 Santa Clara 85 Cupertino 140   -122.031944 37.323056
3831 2020-10-20 Santa Clara 85 Gilroy 1659   -121.58 37.011944
3832 2020-10-20 Santa Clara 85 Los Altos 131   -122.0975 37.368056
3833 2020-10-20 Santa Clara 85 Los Altos Hills 38   -122.1375 37.371389
3834 2020-10-20 Santa Clara 85 Los Gatos 199   -121.961667 37.236111
3835 2020-10-20 Santa Clara 85 Milpitas 614   -121.895 37.434722
3836 2020-10-20 Santa Clara 85 Monte Sereno 19   -121.989444 37.238056
3837 2020-10-20 Santa Clara 85 Morgan Hill 653   -121.654444 37.130556
3838 2020-10-20 Santa Clara 85 Mountain View 638   -122.081944 37.389444
3839 2020-10-20 Santa Clara 85 Palo Alto 320   -122.138056 37.429167
3840 2020-10-20 Santa Clara 85 San Jose 15450   -121.9 37.333333
3841 2020-10-20 Santa Clara 85 Santa Clara 1115   -121.969167 37.354444
3842 2020-10-20 Santa Clara 85 Saratoga 126   -122.019444 37.2725
3843 2020-10-20 Santa Clara 85 Sunnyvale 1038   -122.0375 37.371111
4736 2020-10-19 Santa Clara 85 Campbell 411   -121.955 37.283889
4737 2020-10-19 Santa Clara 85 Cupertino 138   -122.031944 37.323056
4738 2020-10-19 Santa Clara 85 Gilroy 1655   -121.58 37.011944
4739 2020-10-19 Santa Clara 85 Los Altos 129   -122.0975 37.368056
4740 2020-10-19 Santa Clara 85 Los Altos Hills 38   -122.1375 37.371389
4741 2020-10-19 Santa Clara 85 Los Gatos 197   -121.961667 37.236111
4742 2020-10-19 Santa Clara 85 Milpitas 614   -121.895 37.434722
4743 2020-10-19 Santa Clara 85 Monte Sereno 19   -121.989444 37.238056
4744 2020-10-19 Santa Clara 85 Morgan Hill 650   -121.654444 37.130556
4745 2020-10-19 Santa Clara 85 Mountain View 633   -122.081944 37.389444
4746 2020-10-19 Santa Clara 85 Palo Alto 320   -122.138056 37.429167
4747 2020-10-19 Santa Clara 85 San Jose 15379   -121.9 37.333333
4748 2020-10-19 Santa Clara 85 Santa Clara 1110   -121.969167 37.354444
4749 2020-10-19 Santa Clara 85 Saratoga 125   -122.019444 37.2725
4750 2020-10-19 Santa Clara 85 Sunnyvale 1032   -122.0375 37.371111
5378 2020-10-18 Santa Clara 85 Campbell 400   -121.955 37.283889
5379 2020-10-18 Santa Clara 85 Cupertino 138   -122.031944 37.323056
5380 2020-10-18 Santa Clara 85 Gilroy 1649   -121.58 37.011944
5381 2020-10-18 Santa Clara 85 Los Altos 128   -122.0975 37.368056
5382 2020-10-18 Santa Clara 85 Los Altos Hills 37   -122.1375 37.371389
5383 2020-10-18 Santa Clara 85 Los Gatos 196   -121.961667 37.236111
5384 2020-10-18 Santa Clara 85 Milpitas 613   -121.895 37.434722
5385 2020-10-18 Santa Clara 85 Monte Sereno 19   -121.989444 37.238056
5386 2020-10-18 Santa Clara 85 Morgan Hill 647   -121.654444 37.130556
5387 2020-10-18 Santa Clara 85 Mountain View 628   -122.081944 37.389444
5388 2020-10-18 Santa Clara 85 Palo Alto 320   -122.138056 37.429167
5389 2020-10-18 Santa Clara 85 San Jose 15305   -121.9 37.333333
5390 2020-10-18 Santa Clara 85 Santa Clara 1099   -121.969167 37.354444
5391 2020-10-18 Santa Clara 85 Saratoga 123   -122.019444 37.2725
5392 2020-10-18 Santa Clara 85 Sunnyvale 1027   -122.0375 37.371111
6059 2020-10-17 Santa Clara 85 Campbell 377   -121.955 37.283889
6060 2020-10-17 Santa Clara 85 Cupertino 137   -122.031944 37.323056
6061 2020-10-17 Santa Clara 85 Gilroy 1643   -121.58 37.011944
6062 2020-10-17 Santa Clara 85 Los Altos 128   -122.0975 37.368056
6063 2020-10-17 Santa Clara 85 Los Altos Hills 37   -122.1375 37.371389
6064 2020-10-17 Santa Clara 85 Los Gatos 193   -121.961667 37.236111
6065 2020-10-17 Santa Clara 85 Milpitas 607   -121.895 37.434722
6066 2020-10-17 Santa Clara 85 Monte Sereno 19   -121.989444 37.238056
6067 2020-10-17 Santa Clara 85 Morgan Hill 642   -121.654444 37.130556
6068 2020-10-17 Santa Clara 85 Mountain View 624   -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 859.421ms · Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_place_totals