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 |
|---|---|---|---|---|---|---|---|---|---|
| 883 | 883 | 2020-10-30 | San Luis Obispo | 79 | Arroyo Grande | 238 | -120.590725 | 35.118587 | |
| 884 | 884 | 2020-10-30 | San Luis Obispo | 79 | Atascadero | 411 | -120.670726 | 35.489417 | |
| 885 | 885 | 2020-10-30 | San Luis Obispo | 79 | Avila | 9 | -120.720833 | 35.199167 | |
| 886 | 886 | 2020-10-30 | San Luis Obispo | 79 | CMC (inmates) | 294 | -120.698 | 35.325 | |
| 887 | 887 | 2020-10-30 | San Luis Obispo | 79 | Cal Poly (campus residents) | 54 | -120.659819 | 35.301667 | |
| 888 | 888 | 2020-10-30 | San Luis Obispo | 79 | Cambria | 36 | -121.084323 | 35.562844 | |
| 889 | 889 | 2020-10-30 | San Luis Obispo | 79 | Cayucos | 19 | -120.893611 | 35.438333 | |
| 890 | 890 | 2020-10-30 | San Luis Obispo | 79 | Creston | 26 | -120.5238 | 35.5187 | |
| 891 | 891 | 2020-10-30 | San Luis Obispo | 79 | Grover Beach | 172 | -120.621428 | 35.121574 | |
| 892 | 892 | 2020-10-30 | San Luis Obispo | 79 | Los Osos | 65 | -120.837598 | 35.313405 | |
| 893 | 893 | 2020-10-30 | San Luis Obispo | 79 | Morro Bay | 66 | -120.849992 | 35.365944 | |
| 894 | 894 | 2020-10-30 | San Luis Obispo | 79 | Nipomo | 366 | -120.475999 | 35.042755 | |
| 895 | 895 | 2020-10-30 | San Luis Obispo | 79 | Oceano | 143 | -120.611389 | 35.102778 | |
| 896 | 896 | 2020-10-30 | San Luis Obispo | 79 | Other | 6 | |||
| 897 | 897 | 2020-10-30 | San Luis Obispo | 79 | Paso Robles | 1098 | -120.654502 | 35.636876 | |
| 898 | 898 | 2020-10-30 | San Luis Obispo | 79 | Pismo Beach | 69 | -120.648056 | 35.148333 | |
| 899 | 899 | 2020-10-30 | San Luis Obispo | 79 | San Luis Obispo (city) | 827 | -120.659616 | 35.282752 | |
| 900 | 900 | 2020-10-30 | San Luis Obispo | 79 | San Miguel | 156 | -120.695278 | 35.751389 | |
| 901 | 901 | 2020-10-30 | San Luis Obispo | 79 | San Simeon | 6 | -121.189722 | 35.643889 | |
| 902 | 902 | 2020-10-30 | San Luis Obispo | 79 | Santa Margarita | 34 | -120.608056 | 35.389444 | |
| 903 | 903 | 2020-10-30 | San Luis Obispo | 79 | Shandon | 57 | -120.378889 | 35.656111 | |
| 904 | 904 | 2020-10-30 | San Luis Obispo | 79 | Templeton | 145 | -120.706005 | 35.549694 | |
| 1873 | 1873 | 2020-10-29 | San Luis Obispo | 79 | Arroyo Grande | 235 | -120.590725 | 35.118587 | |
| 1874 | 1874 | 2020-10-29 | San Luis Obispo | 79 | Atascadero | 406 | -120.670726 | 35.489417 | |
| 1875 | 1875 | 2020-10-29 | San Luis Obispo | 79 | Avila | 9 | -120.720833 | 35.199167 | |
| 1876 | 1876 | 2020-10-29 | San Luis Obispo | 79 | CMC (inmates) | 294 | -120.698 | 35.325 | |
| 1877 | 1877 | 2020-10-29 | San Luis Obispo | 79 | Cal Poly (campus residents) | 52 | -120.659819 | 35.301667 | |
| 1878 | 1878 | 2020-10-29 | San Luis Obispo | 79 | Cambria | 36 | -121.084323 | 35.562844 | |
| 1879 | 1879 | 2020-10-29 | San Luis Obispo | 79 | Cayucos | 19 | -120.893611 | 35.438333 | |
| 1880 | 1880 | 2020-10-29 | San Luis Obispo | 79 | Creston | 25 | -120.5238 | 35.5187 | |
| 1881 | 1881 | 2020-10-29 | San Luis Obispo | 79 | Grover Beach | 172 | -120.621428 | 35.121574 | |
| 1882 | 1882 | 2020-10-29 | San Luis Obispo | 79 | Los Osos | 65 | -120.837598 | 35.313405 | |
| 1883 | 1883 | 2020-10-29 | San Luis Obispo | 79 | Morro Bay | 67 | -120.849992 | 35.365944 | |
| 1884 | 1884 | 2020-10-29 | San Luis Obispo | 79 | Nipomo | 365 | -120.475999 | 35.042755 | |
| 1885 | 1885 | 2020-10-29 | San Luis Obispo | 79 | Oceano | 139 | -120.611389 | 35.102778 | |
| 1886 | 1886 | 2020-10-29 | San Luis Obispo | 79 | Other | 6 | |||
| 1887 | 1887 | 2020-10-29 | San Luis Obispo | 79 | Paso Robles | 1089 | -120.654502 | 35.636876 | |
| 1888 | 1888 | 2020-10-29 | San Luis Obispo | 79 | Pismo Beach | 68 | -120.648056 | 35.148333 | |
| 1889 | 1889 | 2020-10-29 | San Luis Obispo | 79 | San Luis Obispo (city) | 818 | -120.659616 | 35.282752 | |
| 1890 | 1890 | 2020-10-29 | San Luis Obispo | 79 | San Miguel | 153 | -120.695278 | 35.751389 | |
| 1891 | 1891 | 2020-10-29 | San Luis Obispo | 79 | San Simeon | 6 | -121.189722 | 35.643889 | |
| 1892 | 1892 | 2020-10-29 | San Luis Obispo | 79 | Santa Margarita | 34 | -120.608056 | 35.389444 | |
| 1893 | 1893 | 2020-10-29 | San Luis Obispo | 79 | Shandon | 57 | -120.378889 | 35.656111 | |
| 1894 | 1894 | 2020-10-29 | San Luis Obispo | 79 | Templeton | 145 | -120.706005 | 35.549694 | |
| 2857 | 2857 | 2020-10-28 | San Luis Obispo | 79 | Arroyo Grande | 234 | -120.590725 | 35.118587 | |
| 2858 | 2858 | 2020-10-28 | San Luis Obispo | 79 | Atascadero | 402 | -120.670726 | 35.489417 | |
| 2859 | 2859 | 2020-10-28 | San Luis Obispo | 79 | Avila | 9 | -120.720833 | 35.199167 | |
| 2860 | 2860 | 2020-10-28 | San Luis Obispo | 79 | CMC (inmates) | 294 | -120.698 | 35.325 | |
| 2861 | 2861 | 2020-10-28 | San Luis Obispo | 79 | Cal Poly (campus residents) | 50 | -120.659819 | 35.301667 | |
| 2862 | 2862 | 2020-10-28 | San Luis Obispo | 79 | Cambria | 36 | -121.084323 | 35.562844 | |
| 2863 | 2863 | 2020-10-28 | San Luis Obispo | 79 | Cayucos | 19 | -120.893611 | 35.438333 | |
| 2864 | 2864 | 2020-10-28 | San Luis Obispo | 79 | Creston | 25 | -120.5238 | 35.5187 | |
| 2865 | 2865 | 2020-10-28 | San Luis Obispo | 79 | Grover Beach | 172 | -120.621428 | 35.121574 | |
| 2866 | 2866 | 2020-10-28 | San Luis Obispo | 79 | Los Osos | 64 | -120.837598 | 35.313405 | |
| 2867 | 2867 | 2020-10-28 | San Luis Obispo | 79 | Morro Bay | 67 | -120.849992 | 35.365944 | |
| 2868 | 2868 | 2020-10-28 | San Luis Obispo | 79 | Nipomo | 364 | -120.475999 | 35.042755 | |
| 2869 | 2869 | 2020-10-28 | San Luis Obispo | 79 | Oceano | 139 | -120.611389 | 35.102778 | |
| 2870 | 2870 | 2020-10-28 | San Luis Obispo | 79 | Other | 6 | |||
| 2871 | 2871 | 2020-10-28 | San Luis Obispo | 79 | Paso Robles | 1080 | -120.654502 | 35.636876 | |
| 2872 | 2872 | 2020-10-28 | San Luis Obispo | 79 | Pismo Beach | 66 | -120.648056 | 35.148333 | |
| 2873 | 2873 | 2020-10-28 | San Luis Obispo | 79 | San Luis Obispo (city) | 815 | -120.659616 | 35.282752 | |
| 2874 | 2874 | 2020-10-28 | San Luis Obispo | 79 | San Miguel | 150 | -120.695278 | 35.751389 | |
| 2875 | 2875 | 2020-10-28 | San Luis Obispo | 79 | San Simeon | 6 | -121.189722 | 35.643889 | |
| 2876 | 2876 | 2020-10-28 | San Luis Obispo | 79 | Santa Margarita | 34 | -120.608056 | 35.389444 | |
| 2877 | 2877 | 2020-10-28 | San Luis Obispo | 79 | Shandon | 57 | -120.378889 | 35.656111 | |
| 2878 | 2878 | 2020-10-28 | San Luis Obispo | 79 | Templeton | 144 | -120.706005 | 35.549694 | |
| 3833 | 3833 | 2020-10-27 | San Luis Obispo | 79 | Arroyo Grande | 231 | -120.590725 | 35.118587 | |
| 3834 | 3834 | 2020-10-27 | San Luis Obispo | 79 | Atascadero | 401 | -120.670726 | 35.489417 | |
| 3835 | 3835 | 2020-10-27 | San Luis Obispo | 79 | Avila | 9 | -120.720833 | 35.199167 | |
| 3836 | 3836 | 2020-10-27 | San Luis Obispo | 79 | CMC (inmates) | 294 | -120.698 | 35.325 | |
| 3837 | 3837 | 2020-10-27 | San Luis Obispo | 79 | Cal Poly (campus residents) | 45 | -120.659819 | 35.301667 | |
| 3838 | 3838 | 2020-10-27 | San Luis Obispo | 79 | Cambria | 36 | -121.084323 | 35.562844 | |
| 3839 | 3839 | 2020-10-27 | San Luis Obispo | 79 | Cayucos | 19 | -120.893611 | 35.438333 | |
| 3840 | 3840 | 2020-10-27 | San Luis Obispo | 79 | Creston | 25 | -120.5238 | 35.5187 | |
| 3841 | 3841 | 2020-10-27 | San Luis Obispo | 79 | Grover Beach | 172 | -120.621428 | 35.121574 | |
| 3842 | 3842 | 2020-10-27 | San Luis Obispo | 79 | Los Osos | 65 | -120.837598 | 35.313405 | |
| 3843 | 3843 | 2020-10-27 | San Luis Obispo | 79 | Morro Bay | 67 | -120.849992 | 35.365944 | |
| 3844 | 3844 | 2020-10-27 | San Luis Obispo | 79 | Nipomo | 361 | -120.475999 | 35.042755 | |
| 3845 | 3845 | 2020-10-27 | San Luis Obispo | 79 | Oceano | 137 | -120.611389 | 35.102778 | |
| 3846 | 3846 | 2020-10-27 | San Luis Obispo | 79 | Other | 6 | |||
| 3847 | 3847 | 2020-10-27 | San Luis Obispo | 79 | Paso Robles | 1064 | -120.654502 | 35.636876 | |
| 3848 | 3848 | 2020-10-27 | San Luis Obispo | 79 | Pismo Beach | 66 | -120.648056 | 35.148333 | |
| 3849 | 3849 | 2020-10-27 | San Luis Obispo | 79 | San Luis Obispo (city) | 800 | -120.659616 | 35.282752 | |
| 3850 | 3850 | 2020-10-27 | San Luis Obispo | 79 | San Miguel | 149 | -120.695278 | 35.751389 | |
| 3851 | 3851 | 2020-10-27 | San Luis Obispo | 79 | San Simeon | 6 | -121.189722 | 35.643889 | |
| 3852 | 3852 | 2020-10-27 | San Luis Obispo | 79 | Santa Margarita | 34 | -120.608056 | 35.389444 | |
| 3853 | 3853 | 2020-10-27 | San Luis Obispo | 79 | Shandon | 56 | -120.378889 | 35.656111 | |
| 3854 | 3854 | 2020-10-27 | San Luis Obispo | 79 | Templeton | 143 | -120.706005 | 35.549694 | |
| 4791 | 4791 | 2020-10-26 | San Luis Obispo | 79 | Arroyo Grande | 231 | -120.590725 | 35.118587 | |
| 4792 | 4792 | 2020-10-26 | San Luis Obispo | 79 | Atascadero | 399 | -120.670726 | 35.489417 | |
| 4793 | 4793 | 2020-10-26 | San Luis Obispo | 79 | Avila | 9 | -120.720833 | 35.199167 | |
| 4794 | 4794 | 2020-10-26 | San Luis Obispo | 79 | CMC (inmates) | 294 | -120.698 | 35.325 | |
| 4795 | 4795 | 2020-10-26 | San Luis Obispo | 79 | Cal Poly (campus residents) | 45 | -120.659819 | 35.301667 | |
| 4796 | 4796 | 2020-10-26 | San Luis Obispo | 79 | Cambria | 36 | -121.084323 | 35.562844 | |
| 4797 | 4797 | 2020-10-26 | San Luis Obispo | 79 | Cayucos | 19 | -120.893611 | 35.438333 | |
| 4798 | 4798 | 2020-10-26 | San Luis Obispo | 79 | Creston | 23 | -120.5238 | 35.5187 | |
| 4799 | 4799 | 2020-10-26 | San Luis Obispo | 79 | Grover Beach | 172 | -120.621428 | 35.121574 | |
| 4800 | 4800 | 2020-10-26 | San Luis Obispo | 79 | Los Osos | 65 | -120.837598 | 35.313405 | |
| 4801 | 4801 | 2020-10-26 | San Luis Obispo | 79 | Morro Bay | 67 | -120.849992 | 35.365944 | |
| 4802 | 4802 | 2020-10-26 | San Luis Obispo | 79 | Nipomo | 360 | -120.475999 | 35.042755 |
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 );