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

This data as json, yaml, copyable, CSV (advanced)

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

fips

  • 31 · 1,223 ✖

county

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