latimes_place_totals

Table actions
⚠️ 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

4,968 rows where fips = 31 sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

fips

  • 31 · 4,968 ✖

county

Link rowid id name date ▲ county fips confirmed_cases note population
246 246 Armona Armona 2021-10-27 Kings 31 871   3795
247 247 Avenal Avenal 2021-10-27 Kings 31 1639   12923
248 248 Corcoran Corcoran 2021-10-27 Kings 31 2795   22301
249 249 Correctional facilities Prisons 2021-10-27 Kings 31 7351    
250 250 Hanford Hanford 2021-10-27 Kings 31 12275   55893
251 251 Kettleman City Kettleman City 2021-10-27 Kings 31 231   1395
252 252 Lemoore Lemoore 2021-10-27 Kings 31 5704   25791
253 253 Other Area Other 2021-10-27 Kings 31 335    
254 254 Stratford Stratford 2021-10-27 Kings 31 267   878
1611 1611 Armona Armona 2021-10-26 Kings 31 869   3795
1612 1612 Avenal Avenal 2021-10-26 Kings 31 1636   12923
1613 1613 Corcoran Corcoran 2021-10-26 Kings 31 2793   22301
1614 1614 Correctional facilities Prisons 2021-10-26 Kings 31 7350    
1615 1615 Hanford Hanford 2021-10-26 Kings 31 12246   55893
1616 1616 Kettleman City Kettleman City 2021-10-26 Kings 31 231   1395
1617 1617 Lemoore Lemoore 2021-10-26 Kings 31 5687   25791
1618 1618 Other Area Other 2021-10-26 Kings 31 334    
1619 1619 Stratford Stratford 2021-10-26 Kings 31 266   878
2976 2976 Armona Armona 2021-10-25 Kings 31 869   3795
2977 2977 Avenal Avenal 2021-10-25 Kings 31 1634   12923
2978 2978 Corcoran Corcoran 2021-10-25 Kings 31 2787   22301
2979 2979 Correctional facilities Prisons 2021-10-25 Kings 31 7350    
2980 2980 Hanford Hanford 2021-10-25 Kings 31 12214   55893
2981 2981 Kettleman City Kettleman City 2021-10-25 Kings 31 231   1395
2982 2982 Lemoore Lemoore 2021-10-25 Kings 31 5677   25791
2983 2983 Other Area Other 2021-10-25 Kings 31 334    
2984 2984 Stratford Stratford 2021-10-25 Kings 31 266   878
4341 4341 Armona Armona 2021-10-24 Kings 31 865   3795
4342 4342 Avenal Avenal 2021-10-24 Kings 31 1632   12923
4343 4343 Corcoran Corcoran 2021-10-24 Kings 31 2761   22301
4344 4344 Correctional facilities Prisons 2021-10-24 Kings 31 7334    
4345 4345 Hanford Hanford 2021-10-24 Kings 31 12058   55893
4346 4346 Kettleman City Kettleman City 2021-10-24 Kings 31 229   1395
4347 4347 Lemoore Lemoore 2021-10-24 Kings 31 5610   25791
4348 4348 Other Area Other 2021-10-24 Kings 31 324    
4349 4349 Stratford Stratford 2021-10-24 Kings 31 264   878
5706 5706 Armona Armona 2021-10-23 Kings 31 865   3795
5707 5707 Avenal Avenal 2021-10-23 Kings 31 1632   12923
5708 5708 Corcoran Corcoran 2021-10-23 Kings 31 2761   22301
5709 5709 Correctional facilities Prisons 2021-10-23 Kings 31 7334    
5710 5710 Hanford Hanford 2021-10-23 Kings 31 12058   55893
5711 5711 Kettleman City Kettleman City 2021-10-23 Kings 31 229   1395
5712 5712 Lemoore Lemoore 2021-10-23 Kings 31 5610   25791
5713 5713 Other Area Other 2021-10-23 Kings 31 324    
5714 5714 Stratford Stratford 2021-10-23 Kings 31 264   878
7071 7071 Armona Armona 2021-10-22 Kings 31 854   3795
7072 7072 Avenal Avenal 2021-10-22 Kings 31 1625   12923
7073 7073 Corcoran Corcoran 2021-10-22 Kings 31 2747   22301
7074 7074 Correctional facilities Prisons 2021-10-22 Kings 31 7315    
7075 7075 Hanford Hanford 2021-10-22 Kings 31 11946   55893
7076 7076 Kettleman City Kettleman City 2021-10-22 Kings 31 229   1395
7077 7077 Lemoore Lemoore 2021-10-22 Kings 31 5551   25791
7078 7078 Other Area Other 2021-10-22 Kings 31 321    
7079 7079 Stratford Stratford 2021-10-22 Kings 31 264   878
8436 8436 Armona Armona 2021-10-21 Kings 31 854   3795
8437 8437 Avenal Avenal 2021-10-21 Kings 31 1625   12923
8438 8438 Corcoran Corcoran 2021-10-21 Kings 31 2747   22301
8439 8439 Correctional facilities Prisons 2021-10-21 Kings 31 7315    
8440 8440 Hanford Hanford 2021-10-21 Kings 31 11946   55893
8441 8441 Kettleman City Kettleman City 2021-10-21 Kings 31 229   1395
8442 8442 Lemoore Lemoore 2021-10-21 Kings 31 5551   25791
8443 8443 Other Area Other 2021-10-21 Kings 31 321    
8444 8444 Stratford Stratford 2021-10-21 Kings 31 264   878
9801 9801 Armona Armona 2021-10-20 Kings 31 854   3795
9802 9802 Avenal Avenal 2021-10-20 Kings 31 1625   12923
9803 9803 Corcoran Corcoran 2021-10-20 Kings 31 2747   22301
9804 9804 Correctional facilities Prisons 2021-10-20 Kings 31 7315    
9805 9805 Hanford Hanford 2021-10-20 Kings 31 11946   55893
9806 9806 Kettleman City Kettleman City 2021-10-20 Kings 31 229   1395
9807 9807 Lemoore Lemoore 2021-10-20 Kings 31 5551   25791
9808 9808 Other Area Other 2021-10-20 Kings 31 321    
9809 9809 Stratford Stratford 2021-10-20 Kings 31 264   878
11166 11166 Armona Armona 2021-10-19 Kings 31 838   3795
11167 11167 Avenal Avenal 2021-10-19 Kings 31 1596   12923
11168 11168 Corcoran Corcoran 2021-10-19 Kings 31 2704   22301
11169 11169 Correctional facilities Prisons 2021-10-19 Kings 31 7234    
11170 11170 Hanford Hanford 2021-10-19 Kings 31 11686   55893
11171 11171 Kettleman City Kettleman City 2021-10-19 Kings 31 217   1395
11172 11172 Lemoore Lemoore 2021-10-19 Kings 31 5444   25791
11173 11173 Other Area Other 2021-10-19 Kings 31 311    
11174 11174 Stratford Stratford 2021-10-19 Kings 31 260   878
12531 12531 Armona Armona 2021-10-18 Kings 31 838   3795
12532 12532 Avenal Avenal 2021-10-18 Kings 31 1596   12923
12533 12533 Corcoran Corcoran 2021-10-18 Kings 31 2704   22301
12534 12534 Correctional facilities Prisons 2021-10-18 Kings 31 7234    
12535 12535 Hanford Hanford 2021-10-18 Kings 31 11686   55893
12536 12536 Kettleman City Kettleman City 2021-10-18 Kings 31 217   1395
12537 12537 Lemoore Lemoore 2021-10-18 Kings 31 5444   25791
12538 12538 Other Area Other 2021-10-18 Kings 31 311    
12539 12539 Stratford Stratford 2021-10-18 Kings 31 260   878
13896 13896 Armona Armona 2021-10-17 Kings 31 838   3795
13897 13897 Avenal Avenal 2021-10-17 Kings 31 1596   12923
13898 13898 Corcoran Corcoran 2021-10-17 Kings 31 2704   22301
13899 13899 Correctional facilities Prisons 2021-10-17 Kings 31 7234    
13900 13900 Hanford Hanford 2021-10-17 Kings 31 11686   55893
13901 13901 Kettleman City Kettleman City 2021-10-17 Kings 31 217   1395
13902 13902 Lemoore Lemoore 2021-10-17 Kings 31 5444   25791
13903 13903 Other Area Other 2021-10-17 Kings 31 311    
13904 13904 Stratford Stratford 2021-10-17 Kings 31 260   878
15261 15261 Armona Armona 2021-10-16 Kings 31 838   3795

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [latimes_place_totals] (
   [id] TEXT,
   [name] TEXT,
   [date] TEXT,
   [county] TEXT,
   [fips] INTEGER,
   [confirmed_cases] INTEGER,
   [note] TEXT,
   [population] TEXT
);