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