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,821 rows where place = "Other" sorted by date descending

View and edit SQL

Suggested facets: note, date (date)

fips

place

  • Other · 1,821
Link rowid date ▲ county fips place confirmed_cases note x y
12 2020-10-30 Alameda 1 Other 38      
30 2020-10-30 Butte 7 Other 22      
56 2020-10-30 Contra Costa 13 Other 196      
94 2020-10-30 Fresno 19 Other 238      
178 2020-10-30 Kings 31 Other 75      
738 2020-10-30 Sacramento 67 Other 5023      
896 2020-10-30 San Luis Obispo 79 Other 6      
937 2020-10-30 Santa Cruz 87 Other 33      
949 2020-10-30 Solano 95 Other 25      
959 2020-10-30 Stanislaus 99 Other 3336      
965 2020-10-30 Sutter 101 Other 137      
1023 2020-10-30 Yolo 113 Other 383      
1029 2020-10-30 Yuba 115 Other 75      
1043 2020-10-29 Alameda 1 Other 38      
1061 2020-10-29 Butte 7 Other 22      
1082 2020-10-29 Contra Costa 13 Other 192      
1728 2020-10-29 Sacramento 67 Other 5001      
1886 2020-10-29 San Luis Obispo 79 Other 6      
1959 2020-10-29 Santa Cruz 87 Other 33      
1967 2020-10-29 Solano 95 Other 24      
2028 2020-10-29 Yolo 113 Other 381      
2043 2020-10-28 Alameda 1 Other 38      
2061 2020-10-28 Butte 7 Other 22      
2081 2020-10-28 Contra Costa 13 Other 192      
2173 2020-10-28 Kings 31 Other 70      
2712 2020-10-28 Sacramento 67 Other 4976      
2870 2020-10-28 San Luis Obispo 79 Other 6      
2911 2020-10-28 Santa Cruz 87 Other 33      
2919 2020-10-28 Solano 95 Other 23      
2980 2020-10-28 Yolo 113 Other 378      
2995 2020-10-27 Alameda 1 Other 38      
3013 2020-10-27 Butte 7 Other 22      
3039 2020-10-27 Contra Costa 13 Other 191      
3075 2020-10-27 Fresno 19 Other 238      
3162 2020-10-27 Kings 31 Other 69      
3688 2020-10-27 Sacramento 67 Other 4966      
3846 2020-10-27 San Luis Obispo 79 Other 6      
3887 2020-10-27 Santa Cruz 87 Other 33      
3899 2020-10-27 Solano 95 Other 23      
3956 2020-10-27 Yolo 113 Other 377      
3971 2020-10-26 Alameda 1 Other 38      
3989 2020-10-26 Butte 7 Other 20      
4010 2020-10-26 Contra Costa 13 Other 191      
4095 2020-10-26 Kings 31 Other 70      
4646 2020-10-26 Sacramento 67 Other 4930      
4804 2020-10-26 San Luis Obispo 79 Other 6      
4845 2020-10-26 Santa Cruz 87 Other 33      
4859 2020-10-26 Solano 95 Other 23      
4917 2020-10-26 Yolo 113 Other 376      
4932 2020-10-25 Alameda 1 Other 38      
4957 2020-10-25 Contra Costa 13 Other 191      
5568 2020-10-25 Santa Cruz 87 Other 33      
5600 2020-10-25 Yolo 113 Other 376      
5615 2020-10-24 Alameda 1 Other 38      
5640 2020-10-24 Contra Costa 13 Other 192      
5656 2020-10-24 Kings 31 Other 67      
6166 2020-10-24 Santa Cruz 87 Other 33      
6198 2020-10-24 Yolo 113 Other 372      
6213 2020-10-23 Alameda 1 Other 38      
6231 2020-10-23 Butte 7 Other 20      
6245 2020-10-23 Contra Costa 13 Other 191      
6282 2020-10-23 Fresno 19 Other 238      
6362 2020-10-23 Kings 31 Other 67      
6932 2020-10-23 Sacramento 67 Other 4861      
7089 2020-10-23 San Luis Obispo 79 Other 6      
7162 2020-10-23 Santa Cruz 87 Other 33      
7170 2020-10-23 Solano 95 Other 23      
7250 2020-10-23 Yolo 113 Other 367      
7265 2020-10-22 Alameda 1 Other 38      
7283 2020-10-22 Butte 7 Other 20      
7304 2020-10-22 Contra Costa 13 Other 190      
7396 2020-10-22 Kings 31 Other 67      
7933 2020-10-22 Sacramento 67 Other 4844      
8090 2020-10-22 San Luis Obispo 79 Other 6      
8131 2020-10-22 Santa Cruz 87 Other 32      
8149 2020-10-22 Solano 95 Other 23      
8155 2020-10-22 Sutter 101 Other 135      
8209 2020-10-22 Yolo 113 Other 363      
8215 2020-10-22 Yuba 115 Other 72      
8229 2020-10-21 Alameda 1 Other 37      
8239 2020-10-21 Butte 7 Other 20      
8260 2020-10-21 Contra Costa 13 Other 191      
8349 2020-10-21 Kings 31 Other 68      
8907 2020-10-21 Sacramento 67 Other 4819      
9064 2020-10-21 San Luis Obispo 79 Other 6      
9105 2020-10-21 Santa Cruz 87 Other 32      
9113 2020-10-21 Solano 95 Other 23      
9193 2020-10-21 Yolo 113 Other 363      
9208 2020-10-20 Alameda 1 Other 37      
9218 2020-10-20 Butte 7 Other 19      
9244 2020-10-20 Contra Costa 13 Other 191      
9284 2020-10-20 Fresno 19 Other 238      
9368 2020-10-20 Kings 31 Other 67      
9919 2020-10-20 Sacramento 67 Other 4800      
10075 2020-10-20 San Luis Obispo 79 Other 6      
10113 2020-10-20 Solano 95 Other 23      
10197 2020-10-20 Yolo 113 Other 362      
10212 2020-10-19 Alameda 1 Other 37      
10230 2020-10-19 Butte 7 Other 19      
10251 2020-10-19 Contra Costa 13 Other 191      

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