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,628 rows where fips = 79 sorted by date descending

View and edit SQL

Suggested facets: x, y, date (date)

fips

  • 79 · 2,628

county

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