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

1,122 rows where fips = 87 sorted by date descending

View and edit SQL

Suggested facets: x, y, date (date)

fips

  • 87 · 1,122

county

Link rowid date ▲ county fips place confirmed_cases note x y
931 2020-10-30 Santa Cruz 87 Aptos 127   -121.9075 36.981389
932 2020-10-30 Santa Cruz 87 Ben Lomond 23   -122.083611 37.082778
933 2020-10-30 Santa Cruz 87 Boulder Creek 24   -122.124444 37.131389
934 2020-10-30 Santa Cruz 87 Capitola 67   -121.9533 36.9752
935 2020-10-30 Santa Cruz 87 Felton 28   -122.055833 37.051389
936 2020-10-30 Santa Cruz 87 Freedom 162   -121.789444 36.940556
937 2020-10-30 Santa Cruz 87 Other 33      
938 2020-10-30 Santa Cruz 87 Santa Cruz 574   -122.0308 36.9741
939 2020-10-30 Santa Cruz 87 Scotts Valley 69   -122.0147 37.0511
940 2020-10-30 Santa Cruz 87 Soquel 66   -121.945556 36.986944
941 2020-10-30 Santa Cruz 87 Watsonville 1632   -121.7569 36.9102
1953 2020-10-29 Santa Cruz 87 Aptos 124   -121.9075 36.981389
1954 2020-10-29 Santa Cruz 87 Ben Lomond 23   -122.083611 37.082778
1955 2020-10-29 Santa Cruz 87 Boulder Creek 23   -122.124444 37.131389
1956 2020-10-29 Santa Cruz 87 Capitola 66   -121.9533 36.9752
1957 2020-10-29 Santa Cruz 87 Felton 28   -122.055833 37.051389
1958 2020-10-29 Santa Cruz 87 Freedom 161   -121.789444 36.940556
1959 2020-10-29 Santa Cruz 87 Other 33      
1960 2020-10-29 Santa Cruz 87 Santa Cruz 566   -122.0308 36.9741
1961 2020-10-29 Santa Cruz 87 Scotts Valley 69   -122.0147 37.0511
1962 2020-10-29 Santa Cruz 87 Soquel 66   -121.945556 36.986944
1963 2020-10-29 Santa Cruz 87 Watsonville 1623   -121.7569 36.9102
2905 2020-10-28 Santa Cruz 87 Aptos 122   -121.9075 36.981389
2906 2020-10-28 Santa Cruz 87 Ben Lomond 23   -122.083611 37.082778
2907 2020-10-28 Santa Cruz 87 Boulder Creek 23   -122.124444 37.131389
2908 2020-10-28 Santa Cruz 87 Capitola 65   -121.9533 36.9752
2909 2020-10-28 Santa Cruz 87 Felton 28   -122.055833 37.051389
2910 2020-10-28 Santa Cruz 87 Freedom 161   -121.789444 36.940556
2911 2020-10-28 Santa Cruz 87 Other 33      
2912 2020-10-28 Santa Cruz 87 Santa Cruz 564   -122.0308 36.9741
2913 2020-10-28 Santa Cruz 87 Scotts Valley 68   -122.0147 37.0511
2914 2020-10-28 Santa Cruz 87 Soquel 66   -121.945556 36.986944
2915 2020-10-28 Santa Cruz 87 Watsonville 1615   -121.7569 36.9102
3881 2020-10-27 Santa Cruz 87 Aptos 122   -121.9075 36.981389
3882 2020-10-27 Santa Cruz 87 Ben Lomond 23   -122.083611 37.082778
3883 2020-10-27 Santa Cruz 87 Boulder Creek 23   -122.124444 37.131389
3884 2020-10-27 Santa Cruz 87 Capitola 65   -121.9533 36.9752
3885 2020-10-27 Santa Cruz 87 Felton 28   -122.055833 37.051389
3886 2020-10-27 Santa Cruz 87 Freedom 159   -121.789444 36.940556
3887 2020-10-27 Santa Cruz 87 Other 33      
3888 2020-10-27 Santa Cruz 87 Santa Cruz 556   -122.0308 36.9741
3889 2020-10-27 Santa Cruz 87 Scotts Valley 68   -122.0147 37.0511
3890 2020-10-27 Santa Cruz 87 Soquel 66   -121.945556 36.986944
3891 2020-10-27 Santa Cruz 87 Watsonville 1600   -121.7569 36.9102
4839 2020-10-26 Santa Cruz 87 Aptos 122   -121.9075 36.981389
4840 2020-10-26 Santa Cruz 87 Ben Lomond 23   -122.083611 37.082778
4841 2020-10-26 Santa Cruz 87 Boulder Creek 23   -122.124444 37.131389
4842 2020-10-26 Santa Cruz 87 Capitola 65   -121.9533 36.9752
4843 2020-10-26 Santa Cruz 87 Felton 28   -122.055833 37.051389
4844 2020-10-26 Santa Cruz 87 Freedom 158   -121.789444 36.940556
4845 2020-10-26 Santa Cruz 87 Other 33      
4846 2020-10-26 Santa Cruz 87 Santa Cruz 551   -122.0308 36.9741
4847 2020-10-26 Santa Cruz 87 Scotts Valley 68   -122.0147 37.0511
4848 2020-10-26 Santa Cruz 87 Soquel 67   -121.945556 36.986944
4849 2020-10-26 Santa Cruz 87 Watsonville 1594   -121.7569 36.9102
5562 2020-10-25 Santa Cruz 87 Aptos 122   -121.9075 36.981389
5563 2020-10-25 Santa Cruz 87 Ben Lomond 22   -122.083611 37.082778
5564 2020-10-25 Santa Cruz 87 Boulder Creek 23   -122.124444 37.131389
5565 2020-10-25 Santa Cruz 87 Capitola 65   -121.9533 36.9752
5566 2020-10-25 Santa Cruz 87 Felton 28   -122.055833 37.051389
5567 2020-10-25 Santa Cruz 87 Freedom 158   -121.789444 36.940556
5568 2020-10-25 Santa Cruz 87 Other 33      
5569 2020-10-25 Santa Cruz 87 Santa Cruz 549   -122.0308 36.9741
5570 2020-10-25 Santa Cruz 87 Scotts Valley 68   -122.0147 37.0511
5571 2020-10-25 Santa Cruz 87 Soquel 67   -121.945556 36.986944
5572 2020-10-25 Santa Cruz 87 Watsonville 1591   -121.7569 36.9102
6160 2020-10-24 Santa Cruz 87 Aptos 121   -121.9075 36.981389
6161 2020-10-24 Santa Cruz 87 Ben Lomond 22   -122.083611 37.082778
6162 2020-10-24 Santa Cruz 87 Boulder Creek 22   -122.124444 37.131389
6163 2020-10-24 Santa Cruz 87 Capitola 65   -121.9533 36.9752
6164 2020-10-24 Santa Cruz 87 Felton 28   -122.055833 37.051389
6165 2020-10-24 Santa Cruz 87 Freedom 157   -121.789444 36.940556
6166 2020-10-24 Santa Cruz 87 Other 33      
6167 2020-10-24 Santa Cruz 87 Santa Cruz 545   -122.0308 36.9741
6168 2020-10-24 Santa Cruz 87 Scotts Valley 68   -122.0147 37.0511
6169 2020-10-24 Santa Cruz 87 Soquel 65   -121.945556 36.986944
6170 2020-10-24 Santa Cruz 87 Watsonville 1585   -121.7569 36.9102
7156 2020-10-23 Santa Cruz 87 Aptos 121   -121.9075 36.981389
7157 2020-10-23 Santa Cruz 87 Ben Lomond 22   -122.083611 37.082778
7158 2020-10-23 Santa Cruz 87 Boulder Creek 22   -122.124444 37.131389
7159 2020-10-23 Santa Cruz 87 Capitola 65   -121.9533 36.9752
7160 2020-10-23 Santa Cruz 87 Felton 28   -122.055833 37.051389
7161 2020-10-23 Santa Cruz 87 Freedom 151   -121.789444 36.940556
7162 2020-10-23 Santa Cruz 87 Other 33      
7163 2020-10-23 Santa Cruz 87 Santa Cruz 540   -122.0308 36.9741
7164 2020-10-23 Santa Cruz 87 Scotts Valley 68   -122.0147 37.0511
7165 2020-10-23 Santa Cruz 87 Soquel 65   -121.945556 36.986944
7166 2020-10-23 Santa Cruz 87 Watsonville 1580   -121.7569 36.9102
8125 2020-10-22 Santa Cruz 87 Aptos 121   -121.9075 36.981389
8126 2020-10-22 Santa Cruz 87 Ben Lomond 22   -122.083611 37.082778
8127 2020-10-22 Santa Cruz 87 Boulder Creek 22   -122.124444 37.131389
8128 2020-10-22 Santa Cruz 87 Capitola 65   -121.9533 36.9752
8129 2020-10-22 Santa Cruz 87 Felton 28   -122.055833 37.051389
8130 2020-10-22 Santa Cruz 87 Freedom 151   -121.789444 36.940556
8131 2020-10-22 Santa Cruz 87 Other 32      
8132 2020-10-22 Santa Cruz 87 Santa Cruz 532   -122.0308 36.9741
8133 2020-10-22 Santa Cruz 87 Scotts Valley 68   -122.0147 37.0511
8134 2020-10-22 Santa Cruz 87 Soquel 65   -121.945556 36.986944
8135 2020-10-22 Santa Cruz 87 Watsonville 1571   -121.7569 36.9102
9099 2020-10-21 Santa Cruz 87 Aptos 121   -121.9075 36.981389

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 857.105ms · Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_place_totals