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

View and edit SQL

Suggested facets: note, x, y, date (date)

fips

  • 31 · 1,223

county

Link rowid date ▲ county fips place confirmed_cases note x y
172 2020-10-30 Kings 31 Armona 177   -119.708728 36.315187
173 2020-10-30 Kings 31 Avenal 434   -120.128876 36.004087
174 2020-10-30 Kings 31 Corcoran 688   -119.560654 36.097923
175 2020-10-30 Kings 31 Hanford 2183   -119.64573 36.327428
176 2020-10-30 Kings 31 Kettleman City 66   -119.960005 36.008623
177 2020-10-30 Kings 31 Lemoore 979   -119.782993 36.300838
178 2020-10-30 Kings 31 Other 75      
179 2020-10-30 Kings 31 Prisons 3793      
180 2020-10-30 Kings 31 Stratford 61   -119.822485 36.189369
1166 2020-10-29 Kings 31 Armona 175   -119.708728 36.315187
1167 2020-10-29 Kings 31 Avenal 433   -120.128876 36.004087
1168 2020-10-29 Kings 31 Corcoran 683   -119.560654 36.097923
1169 2020-10-29 Kings 31 Hanford 2171   -119.64573 36.327428
1170 2020-10-29 Kings 31 Kettleman City 66   -119.960005 36.008623
1171 2020-10-29 Kings 31 Lemoore 969   -119.782993 36.300838
1172 2020-10-29 Kings 31 Other Area 70      
1173 2020-10-29 Kings 31 Prisons 3766      
1174 2020-10-29 Kings 31 Stratford 61   -119.822485 36.189369
2167 2020-10-28 Kings 31 Armona 175   -119.708728 36.315187
2168 2020-10-28 Kings 31 Avenal 433   -120.128876 36.004087
2169 2020-10-28 Kings 31 Corcoran 681   -119.560654 36.097923
2170 2020-10-28 Kings 31 Hanford 2161   -119.64573 36.327428
2171 2020-10-28 Kings 31 Kettleman City 66   -119.960005 36.008623
2172 2020-10-28 Kings 31 Lemoore 965   -119.782993 36.300838
2173 2020-10-28 Kings 31 Other 70      
2174 2020-10-28 Kings 31 Prisons 3766      
2175 2020-10-28 Kings 31 Stratford 61   -119.822485 36.189369
3156 2020-10-27 Kings 31 Armona 175   -119.708728 36.315187
3157 2020-10-27 Kings 31 Avenal 433   -120.128876 36.004087
3158 2020-10-27 Kings 31 Corcoran 681   -119.560654 36.097923
3159 2020-10-27 Kings 31 Hanford 2157   -119.64573 36.327428
3160 2020-10-27 Kings 31 Kettleman City 66   -119.960005 36.008623
3161 2020-10-27 Kings 31 Lemoore 964   -119.782993 36.300838
3162 2020-10-27 Kings 31 Other 69      
3163 2020-10-27 Kings 31 Prisons 3764      
3164 2020-10-27 Kings 31 Stratford 61   -119.822485 36.189369
4089 2020-10-26 Kings 31 Armona 175   -119.708728 36.315187
4090 2020-10-26 Kings 31 Avenal 433   -120.128876 36.004087
4091 2020-10-26 Kings 31 Corcoran 678   -119.560654 36.097923
4092 2020-10-26 Kings 31 Hanford 2150   -119.64573 36.327428
4093 2020-10-26 Kings 31 Kettleman City 66   -119.960005 36.008623
4094 2020-10-26 Kings 31 Lemoore 961   -119.782993 36.300838
4095 2020-10-26 Kings 31 Other 70      
4096 2020-10-26 Kings 31 Prisons 3645      
4097 2020-10-26 Kings 31 Stratford 61   -119.822485 36.189369
5650 2020-10-24 Kings 31 Armona 175   -119.708728 36.315187
5651 2020-10-24 Kings 31 Avenal 433   -120.128876 36.004087
5652 2020-10-24 Kings 31 Corcoran 676   -119.560654 36.097923
5653 2020-10-24 Kings 31 Hanford 2136   -119.64573 36.327428
5654 2020-10-24 Kings 31 Kettleman City 66   -119.960005 36.008623
5655 2020-10-24 Kings 31 Lemoore 955   -119.782993 36.300838
5656 2020-10-24 Kings 31 Other 67      
5657 2020-10-24 Kings 31 Prisons 3674      
5658 2020-10-24 Kings 31 Stratford 61   -119.822485 36.189369
6356 2020-10-23 Kings 31 Armona 175   -119.708728 36.315187
6357 2020-10-23 Kings 31 Avenal 433   -120.128876 36.004087
6358 2020-10-23 Kings 31 Corcoran 674   -119.560654 36.097923
6359 2020-10-23 Kings 31 Hanford 2131   -119.64573 36.327428
6360 2020-10-23 Kings 31 Kettleman City 66   -119.960005 36.008623
6361 2020-10-23 Kings 31 Lemoore 955   -119.782993 36.300838
6362 2020-10-23 Kings 31 Other 67      
6363 2020-10-23 Kings 31 Prisons 3634      
6364 2020-10-23 Kings 31 Stratford 61   -119.822485 36.189369
7390 2020-10-22 Kings 31 Armona 175   -119.708728 36.315187
7391 2020-10-22 Kings 31 Avenal 432   -120.128876 36.004087
7392 2020-10-22 Kings 31 Corcoran 672   -119.560654 36.097923
7393 2020-10-22 Kings 31 Hanford 2120   -119.64573 36.327428
7394 2020-10-22 Kings 31 Kettleman City 66   -119.960005 36.008623
7395 2020-10-22 Kings 31 Lemoore 953   -119.782993 36.300838
7396 2020-10-22 Kings 31 Other 67      
7397 2020-10-22 Kings 31 Prisons 3634      
7398 2020-10-22 Kings 31 Stratford 61   -119.822485 36.189369
8343 2020-10-21 Kings 31 Armona 173   -119.708728 36.315187
8344 2020-10-21 Kings 31 Avenal 430   -120.128876 36.004087
8345 2020-10-21 Kings 31 Corcoran 671   -119.560654 36.097923
8346 2020-10-21 Kings 31 Hanford 2110   -119.64573 36.327428
8347 2020-10-21 Kings 31 Kettleman City 66   -119.960005 36.008623
8348 2020-10-21 Kings 31 Lemoore 951   -119.782993 36.300838
8349 2020-10-21 Kings 31 Other 68      
8350 2020-10-21 Kings 31 Prisons 3634      
8351 2020-10-21 Kings 31 Stratford 61   -119.822485 36.189369
9362 2020-10-20 Kings 31 Armona 173   -119.708728 36.315187
9363 2020-10-20 Kings 31 Avenal 429   -120.128876 36.004087
9364 2020-10-20 Kings 31 Corcoran 671   -119.560654 36.097923
9365 2020-10-20 Kings 31 Hanford 2105   -119.64573 36.327428
9366 2020-10-20 Kings 31 Kettleman City 66   -119.960005 36.008623
9367 2020-10-20 Kings 31 Lemoore 949   -119.782993 36.300838
9368 2020-10-20 Kings 31 Other 67      
9369 2020-10-20 Kings 31 Prisons 3634      
9370 2020-10-20 Kings 31 Stratford 61   -119.822485 36.189369
10340 2020-10-19 Kings 31 Armona 173   -119.708728 36.315187
10341 2020-10-19 Kings 31 Avenal 430   -120.128876 36.004087
10342 2020-10-19 Kings 31 Corcoran 670   -119.560654 36.097923
10343 2020-10-19 Kings 31 Hanford 2103   -119.64573 36.327428
10344 2020-10-19 Kings 31 Kettleman City 66   -119.960005 36.008623
10345 2020-10-19 Kings 31 Lemoore 949   -119.782993 36.300838
10346 2020-10-19 Kings 31 Other 67      
10347 2020-10-19 Kings 31 Prisons 3634      
10348 2020-10-19 Kings 31 Stratford 61   -119.822485 36.189369
11160 2020-10-18 Kings 31 Armona 173   -119.708728 36.315187

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