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,562 rows where county = "San Luis Obispo" sorted by date descending

View and edit SQL

Suggested facets: x, y, date (date)

fips

  • 79 2,562

county

  • San Luis Obispo · 2,562
Link rowid date ▲ county fips place confirmed_cases note x y
851 2020-10-27 San Luis Obispo 79 Arroyo Grande 231   -120.590725 35.118587
852 2020-10-27 San Luis Obispo 79 Atascadero 401   -120.670726 35.489417
853 2020-10-27 San Luis Obispo 79 Avila 9   -120.720833 35.199167
854 2020-10-27 San Luis Obispo 79 CMC (inmates) 294   -120.698 35.325
855 2020-10-27 San Luis Obispo 79 Cal Poly (campus residents) 45   -120.659819 35.301667
856 2020-10-27 San Luis Obispo 79 Cambria 36   -121.084323 35.562844
857 2020-10-27 San Luis Obispo 79 Cayucos 19   -120.893611 35.438333
858 2020-10-27 San Luis Obispo 79 Creston 25   -120.5238 35.5187
859 2020-10-27 San Luis Obispo 79 Grover Beach 172   -120.621428 35.121574
860 2020-10-27 San Luis Obispo 79 Los Osos 65   -120.837598 35.313405
861 2020-10-27 San Luis Obispo 79 Morro Bay 67   -120.849992 35.365944
862 2020-10-27 San Luis Obispo 79 Nipomo 361   -120.475999 35.042755
863 2020-10-27 San Luis Obispo 79 Oceano 137   -120.611389 35.102778
864 2020-10-27 San Luis Obispo 79 Other 6      
865 2020-10-27 San Luis Obispo 79 Paso Robles 1064   -120.654502 35.636876
866 2020-10-27 San Luis Obispo 79 Pismo Beach 66   -120.648056 35.148333
867 2020-10-27 San Luis Obispo 79 San Luis Obispo (city) 800   -120.659616 35.282752
868 2020-10-27 San Luis Obispo 79 San Miguel 149   -120.695278 35.751389
869 2020-10-27 San Luis Obispo 79 San Simeon 6   -121.189722 35.643889
870 2020-10-27 San Luis Obispo 79 Santa Margarita 34   -120.608056 35.389444
871 2020-10-27 San Luis Obispo 79 Shandon 56   -120.378889 35.656111
872 2020-10-27 San Luis Obispo 79 Templeton 143   -120.706005 35.549694
1809 2020-10-26 San Luis Obispo 79 Arroyo Grande 231   -120.590725 35.118587
1810 2020-10-26 San Luis Obispo 79 Atascadero 399   -120.670726 35.489417
1811 2020-10-26 San Luis Obispo 79 Avila 9   -120.720833 35.199167
1812 2020-10-26 San Luis Obispo 79 CMC (inmates) 294   -120.698 35.325
1813 2020-10-26 San Luis Obispo 79 Cal Poly (campus residents) 45   -120.659819 35.301667
1814 2020-10-26 San Luis Obispo 79 Cambria 36   -121.084323 35.562844
1815 2020-10-26 San Luis Obispo 79 Cayucos 19   -120.893611 35.438333
1816 2020-10-26 San Luis Obispo 79 Creston 23   -120.5238 35.5187
1817 2020-10-26 San Luis Obispo 79 Grover Beach 172   -120.621428 35.121574
1818 2020-10-26 San Luis Obispo 79 Los Osos 65   -120.837598 35.313405
1819 2020-10-26 San Luis Obispo 79 Morro Bay 67   -120.849992 35.365944
1820 2020-10-26 San Luis Obispo 79 Nipomo 360   -120.475999 35.042755
1821 2020-10-26 San Luis Obispo 79 Oceano 136   -120.611389 35.102778
1822 2020-10-26 San Luis Obispo 79 Other 6      
1823 2020-10-26 San Luis Obispo 79 Paso Robles 1060   -120.654502 35.636876
1824 2020-10-26 San Luis Obispo 79 Pismo Beach 66   -120.648056 35.148333
1825 2020-10-26 San Luis Obispo 79 San Luis Obispo (city) 793   -120.659616 35.282752
1826 2020-10-26 San Luis Obispo 79 San Miguel 149   -120.695278 35.751389
1827 2020-10-26 San Luis Obispo 79 San Simeon 6   -121.189722 35.643889
1828 2020-10-26 San Luis Obispo 79 Santa Margarita 33   -120.608056 35.389444
1829 2020-10-26 San Luis Obispo 79 Shandon 56   -120.378889 35.656111
1830 2020-10-26 San Luis Obispo 79 Templeton 143   -120.706005 35.549694
4094 2020-10-23 San Luis Obispo 79 Arroyo Grande 230   -120.590725 35.118587
4095 2020-10-23 San Luis Obispo 79 Atascadero 396   -120.670726 35.489417
4096 2020-10-23 San Luis Obispo 79 Avila 9   -120.720833 35.199167
4097 2020-10-23 San Luis Obispo 79 CMC (inmates) 294   -120.698 35.325
4098 2020-10-23 San Luis Obispo 79 Cal Poly (campus residents) 43   -120.659819 35.301667
4099 2020-10-23 San Luis Obispo 79 Cambria 36   -121.084323 35.562844
4100 2020-10-23 San Luis Obispo 79 Cayucos 17   -120.893611 35.438333
4101 2020-10-23 San Luis Obispo 79 Creston 22   -120.5238 35.5187
4102 2020-10-23 San Luis Obispo 79 Grover Beach 170   -120.621428 35.121574
4103 2020-10-23 San Luis Obispo 79 Los Osos 65   -120.837598 35.313405
4104 2020-10-23 San Luis Obispo 79 Morro Bay 66   -120.849992 35.365944
4105 2020-10-23 San Luis Obispo 79 Nipomo 360   -120.475999 35.042755
4106 2020-10-23 San Luis Obispo 79 Oceano 136   -120.611389 35.102778
4107 2020-10-23 San Luis Obispo 79 Other 6      
4108 2020-10-23 San Luis Obispo 79 Paso Robles 1042   -120.654502 35.636876
4109 2020-10-23 San Luis Obispo 79 Pismo Beach 66   -120.648056 35.148333
4110 2020-10-23 San Luis Obispo 79 San Luis Obispo (city) 791   -120.659616 35.282752
4111 2020-10-23 San Luis Obispo 79 San Miguel 149   -120.695278 35.751389
4112 2020-10-23 San Luis Obispo 79 San Simeon 6   -121.189722 35.643889
4113 2020-10-23 San Luis Obispo 79 Santa Margarita 32   -120.608056 35.389444
4114 2020-10-23 San Luis Obispo 79 Shandon 56   -120.378889 35.656111
4115 2020-10-23 San Luis Obispo 79 Templeton 139   -120.706005 35.549694
5095 2020-10-22 San Luis Obispo 79 Arroyo Grande 229   -120.590725 35.118587
5096 2020-10-22 San Luis Obispo 79 Atascadero 396   -120.670726 35.489417
5097 2020-10-22 San Luis Obispo 79 Avila 9   -120.720833 35.199167
5098 2020-10-22 San Luis Obispo 79 CMC (inmates) 294   -120.698 35.325
5099 2020-10-22 San Luis Obispo 79 Cal Poly (campus residents) 42   -120.659819 35.301667
5100 2020-10-22 San Luis Obispo 79 Cambria 36   -121.084323 35.562844
5101 2020-10-22 San Luis Obispo 79 Cayucos 17   -120.893611 35.438333
5102 2020-10-22 San Luis Obispo 79 Creston 22   -120.5238 35.5187
5103 2020-10-22 San Luis Obispo 79 Grover Beach 170   -120.621428 35.121574
5104 2020-10-22 San Luis Obispo 79 Los Osos 65   -120.837598 35.313405
5105 2020-10-22 San Luis Obispo 79 Morro Bay 65   -120.849992 35.365944
5106 2020-10-22 San Luis Obispo 79 Nipomo 358   -120.475999 35.042755
5107 2020-10-22 San Luis Obispo 79 Oceano 136   -120.611389 35.102778
5108 2020-10-22 San Luis Obispo 79 Other 6      
5109 2020-10-22 San Luis Obispo 79 Paso Robles 1035   -120.654502 35.636876
5110 2020-10-22 San Luis Obispo 79 Pismo Beach 66   -120.648056 35.148333
5111 2020-10-22 San Luis Obispo 79 San Luis Obispo (city) 784   -120.659616 35.282752
5112 2020-10-22 San Luis Obispo 79 San Miguel 149   -120.695278 35.751389
5113 2020-10-22 San Luis Obispo 79 San Simeon 6   -121.189722 35.643889
5114 2020-10-22 San Luis Obispo 79 Santa Margarita 32   -120.608056 35.389444
5115 2020-10-22 San Luis Obispo 79 Shandon 56   -120.378889 35.656111
5116 2020-10-22 San Luis Obispo 79 Templeton 139   -120.706005 35.549694
6069 2020-10-21 San Luis Obispo 79 Arroyo Grande 229   -120.590725 35.118587
6070 2020-10-21 San Luis Obispo 79 Atascadero 396   -120.670726 35.489417
6071 2020-10-21 San Luis Obispo 79 Avila 9   -120.720833 35.199167
6072 2020-10-21 San Luis Obispo 79 CMC (inmates) 294   -120.698 35.325
6073 2020-10-21 San Luis Obispo 79 Cal Poly (campus residents) 41   -120.659819 35.301667
6074 2020-10-21 San Luis Obispo 79 Cambria 36   -121.084323 35.562844
6075 2020-10-21 San Luis Obispo 79 Cayucos 17   -120.893611 35.438333
6076 2020-10-21 San Luis Obispo 79 Creston 22   -120.5238 35.5187
6077 2020-10-21 San Luis Obispo 79 Grover Beach 170   -120.621428 35.121574
6078 2020-10-21 San Luis Obispo 79 Los Osos 63   -120.837598 35.313405
6079 2020-10-21 San Luis Obispo 79 Morro Bay 65   -120.849992 35.365944
6080 2020-10-21 San Luis Obispo 79 Nipomo 358   -120.475999 35.042755

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