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

View and edit SQL

Suggested facets: x, y, date (date)

fips

  • 87 1,089

county

  • Santa Cruz · 1,089
Link rowid date ▲ county fips place confirmed_cases note x y
899 2020-10-27 Santa Cruz 87 Aptos 122   -121.9075 36.981389
900 2020-10-27 Santa Cruz 87 Ben Lomond 23   -122.083611 37.082778
901 2020-10-27 Santa Cruz 87 Boulder Creek 23   -122.124444 37.131389
902 2020-10-27 Santa Cruz 87 Capitola 65   -121.9533 36.9752
903 2020-10-27 Santa Cruz 87 Felton 28   -122.055833 37.051389
904 2020-10-27 Santa Cruz 87 Freedom 159   -121.789444 36.940556
905 2020-10-27 Santa Cruz 87 Other 33      
906 2020-10-27 Santa Cruz 87 Santa Cruz 556   -122.0308 36.9741
907 2020-10-27 Santa Cruz 87 Scotts Valley 68   -122.0147 37.0511
908 2020-10-27 Santa Cruz 87 Soquel 66   -121.945556 36.986944
909 2020-10-27 Santa Cruz 87 Watsonville 1600   -121.7569 36.9102
1857 2020-10-26 Santa Cruz 87 Aptos 122   -121.9075 36.981389
1858 2020-10-26 Santa Cruz 87 Ben Lomond 23   -122.083611 37.082778
1859 2020-10-26 Santa Cruz 87 Boulder Creek 23   -122.124444 37.131389
1860 2020-10-26 Santa Cruz 87 Capitola 65   -121.9533 36.9752
1861 2020-10-26 Santa Cruz 87 Felton 28   -122.055833 37.051389
1862 2020-10-26 Santa Cruz 87 Freedom 158   -121.789444 36.940556
1863 2020-10-26 Santa Cruz 87 Other 33      
1864 2020-10-26 Santa Cruz 87 Santa Cruz 551   -122.0308 36.9741
1865 2020-10-26 Santa Cruz 87 Scotts Valley 68   -122.0147 37.0511
1866 2020-10-26 Santa Cruz 87 Soquel 67   -121.945556 36.986944
1867 2020-10-26 Santa Cruz 87 Watsonville 1594   -121.7569 36.9102
2580 2020-10-25 Santa Cruz 87 Aptos 122   -121.9075 36.981389
2581 2020-10-25 Santa Cruz 87 Ben Lomond 22   -122.083611 37.082778
2582 2020-10-25 Santa Cruz 87 Boulder Creek 23   -122.124444 37.131389
2583 2020-10-25 Santa Cruz 87 Capitola 65   -121.9533 36.9752
2584 2020-10-25 Santa Cruz 87 Felton 28   -122.055833 37.051389
2585 2020-10-25 Santa Cruz 87 Freedom 158   -121.789444 36.940556
2586 2020-10-25 Santa Cruz 87 Other 33      
2587 2020-10-25 Santa Cruz 87 Santa Cruz 549   -122.0308 36.9741
2588 2020-10-25 Santa Cruz 87 Scotts Valley 68   -122.0147 37.0511
2589 2020-10-25 Santa Cruz 87 Soquel 67   -121.945556 36.986944
2590 2020-10-25 Santa Cruz 87 Watsonville 1591   -121.7569 36.9102
3178 2020-10-24 Santa Cruz 87 Aptos 121   -121.9075 36.981389
3179 2020-10-24 Santa Cruz 87 Ben Lomond 22   -122.083611 37.082778
3180 2020-10-24 Santa Cruz 87 Boulder Creek 22   -122.124444 37.131389
3181 2020-10-24 Santa Cruz 87 Capitola 65   -121.9533 36.9752
3182 2020-10-24 Santa Cruz 87 Felton 28   -122.055833 37.051389
3183 2020-10-24 Santa Cruz 87 Freedom 157   -121.789444 36.940556
3184 2020-10-24 Santa Cruz 87 Other 33      
3185 2020-10-24 Santa Cruz 87 Santa Cruz 545   -122.0308 36.9741
3186 2020-10-24 Santa Cruz 87 Scotts Valley 68   -122.0147 37.0511
3187 2020-10-24 Santa Cruz 87 Soquel 65   -121.945556 36.986944
3188 2020-10-24 Santa Cruz 87 Watsonville 1585   -121.7569 36.9102
4174 2020-10-23 Santa Cruz 87 Aptos 121   -121.9075 36.981389
4175 2020-10-23 Santa Cruz 87 Ben Lomond 22   -122.083611 37.082778
4176 2020-10-23 Santa Cruz 87 Boulder Creek 22   -122.124444 37.131389
4177 2020-10-23 Santa Cruz 87 Capitola 65   -121.9533 36.9752
4178 2020-10-23 Santa Cruz 87 Felton 28   -122.055833 37.051389
4179 2020-10-23 Santa Cruz 87 Freedom 151   -121.789444 36.940556
4180 2020-10-23 Santa Cruz 87 Other 33      
4181 2020-10-23 Santa Cruz 87 Santa Cruz 540   -122.0308 36.9741
4182 2020-10-23 Santa Cruz 87 Scotts Valley 68   -122.0147 37.0511
4183 2020-10-23 Santa Cruz 87 Soquel 65   -121.945556 36.986944
4184 2020-10-23 Santa Cruz 87 Watsonville 1580   -121.7569 36.9102
5143 2020-10-22 Santa Cruz 87 Aptos 121   -121.9075 36.981389
5144 2020-10-22 Santa Cruz 87 Ben Lomond 22   -122.083611 37.082778
5145 2020-10-22 Santa Cruz 87 Boulder Creek 22   -122.124444 37.131389
5146 2020-10-22 Santa Cruz 87 Capitola 65   -121.9533 36.9752
5147 2020-10-22 Santa Cruz 87 Felton 28   -122.055833 37.051389
5148 2020-10-22 Santa Cruz 87 Freedom 151   -121.789444 36.940556
5149 2020-10-22 Santa Cruz 87 Other 32      
5150 2020-10-22 Santa Cruz 87 Santa Cruz 532   -122.0308 36.9741
5151 2020-10-22 Santa Cruz 87 Scotts Valley 68   -122.0147 37.0511
5152 2020-10-22 Santa Cruz 87 Soquel 65   -121.945556 36.986944
5153 2020-10-22 Santa Cruz 87 Watsonville 1571   -121.7569 36.9102
6117 2020-10-21 Santa Cruz 87 Aptos 121   -121.9075 36.981389
6118 2020-10-21 Santa Cruz 87 Ben Lomond 22   -122.083611 37.082778
6119 2020-10-21 Santa Cruz 87 Boulder Creek 21   -122.124444 37.131389
6120 2020-10-21 Santa Cruz 87 Capitola 65   -121.9533 36.9752
6121 2020-10-21 Santa Cruz 87 Felton 25   -122.055833 37.051389
6122 2020-10-21 Santa Cruz 87 Freedom 150   -121.789444 36.940556
6123 2020-10-21 Santa Cruz 87 Other 32      
6124 2020-10-21 Santa Cruz 87 Santa Cruz 530   -122.0308 36.9741
6125 2020-10-21 Santa Cruz 87 Scotts Valley 68   -122.0147 37.0511
6126 2020-10-21 Santa Cruz 87 Soquel 65   -121.945556 36.986944
6127 2020-10-21 Santa Cruz 87 Watsonville 1570   -121.7569 36.9102
8035 2020-10-19 Santa Cruz 87 Aptos 117   -121.9075 36.981389
8036 2020-10-19 Santa Cruz 87 Ben Lomond 22   -122.083611 37.082778
8037 2020-10-19 Santa Cruz 87 Boulder Creek 21   -122.124444 37.131389
8038 2020-10-19 Santa Cruz 87 Capitola 65   -121.9533 36.9752
8039 2020-10-19 Santa Cruz 87 Felton 26   -122.055833 37.051389
8040 2020-10-19 Santa Cruz 87 Freedom 151   -121.789444 36.940556
8041 2020-10-19 Santa Cruz 87 Other 32      
8042 2020-10-19 Santa Cruz 87 Santa Cruz 517   -122.0308 36.9741
8043 2020-10-19 Santa Cruz 87 Scotts Valley 68   -122.0147 37.0511
8044 2020-10-19 Santa Cruz 87 Soquel 65   -121.945556 36.986944
8045 2020-10-19 Santa Cruz 87 Watsonville 1561   -121.7569 36.9102
8677 2020-10-18 Santa Cruz 87 Aptos 117   -121.9075 36.981389
8678 2020-10-18 Santa Cruz 87 Ben Lomond 22   -122.083611 37.082778
8679 2020-10-18 Santa Cruz 87 Boulder Creek 21   -122.124444 37.131389
8680 2020-10-18 Santa Cruz 87 Capitola 65   -121.9533 36.9752
8681 2020-10-18 Santa Cruz 87 Felton 25   -122.055833 37.051389
8682 2020-10-18 Santa Cruz 87 Freedom 151   -121.789444 36.940556
8683 2020-10-18 Santa Cruz 87 Other 31      
8684 2020-10-18 Santa Cruz 87 Santa Cruz 510   -122.0308 36.9741
8685 2020-10-18 Santa Cruz 87 Scotts Valley 68   -122.0147 37.0511
8686 2020-10-18 Santa Cruz 87 Soquel 65   -121.945556 36.986944
8687 2020-10-18 Santa Cruz 87 Watsonville 1555   -121.7569 36.9102
9358 2020-10-17 Santa Cruz 87 Aptos 117   -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 866.164ms · Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_place_totals