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

3,168 rows where fips = 31 sorted by date descending

✎ View and edit SQL

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

fips

  • 31 · 3,168 ✖

county

Link rowid id name date ▲ county fips confirmed_cases note population
245 245 Armona Armona 2021-04-10 Kings 31 584   3795
246 246 Avenal Avenal 2021-04-10 Kings 31 1225   12923
247 247 Corcoran Corcoran 2021-04-10 Kings 31 1956   22301
248 248 Correctional facilities Prisons 2021-04-10 Kings 31 7206    
249 249 Hanford Hanford 2021-04-10 Kings 31 7672   55893
250 250 Kettleman City Kettleman City 2021-04-10 Kings 31 166   1395
251 251 Lemoore Lemoore 2021-04-10 Kings 31 3549   25791
252 252 Other Area Other 2021-04-10 Kings 31 210    
253 253 Stratford Stratford 2021-04-10 Kings 31 133   878
1612 1612 Armona Armona 2021-04-09 Kings 31 584   3795
1613 1613 Avenal Avenal 2021-04-09 Kings 31 1225   12923
1614 1614 Corcoran Corcoran 2021-04-09 Kings 31 1955   22301
1615 1615 Correctional facilities Prisons 2021-04-09 Kings 31 7206    
1616 1616 Hanford Hanford 2021-04-09 Kings 31 7666   55893
1617 1617 Kettleman City Kettleman City 2021-04-09 Kings 31 166   1395
1618 1618 Lemoore Lemoore 2021-04-09 Kings 31 3538   25791
1619 1619 Other Area Other 2021-04-09 Kings 31 210    
1620 1620 Stratford Stratford 2021-04-09 Kings 31 133   878
2982 2982 Armona Armona 2021-04-08 Kings 31 584   3795
2983 2983 Avenal Avenal 2021-04-08 Kings 31 1224   12923
2984 2984 Corcoran Corcoran 2021-04-08 Kings 31 1955   22301
2985 2985 Correctional facilities Prisons 2021-04-08 Kings 31 7206    
2986 2986 Hanford Hanford 2021-04-08 Kings 31 7663   55893
2987 2987 Kettleman City Kettleman City 2021-04-08 Kings 31 166   1395
2988 2988 Lemoore Lemoore 2021-04-08 Kings 31 3535   25791
2989 2989 Other Area Other 2021-04-08 Kings 31 210    
2990 2990 Stratford Stratford 2021-04-08 Kings 31 133   878
4352 4352 Armona Armona 2021-04-07 Kings 31 584   3795
4353 4353 Avenal Avenal 2021-04-07 Kings 31 1224   12923
4354 4354 Corcoran Corcoran 2021-04-07 Kings 31 1955   22301
4355 4355 Correctional facilities Prisons 2021-04-07 Kings 31 7206    
4356 4356 Hanford Hanford 2021-04-07 Kings 31 7664   55893
4357 4357 Kettleman City Kettleman City 2021-04-07 Kings 31 166   1395
4358 4358 Lemoore Lemoore 2021-04-07 Kings 31 3535   25791
4359 4359 Other Area Other 2021-04-07 Kings 31 209    
4360 4360 Stratford Stratford 2021-04-07 Kings 31 133   878
5724 5724 Armona Armona 2021-04-06 Kings 31 584   3795
5725 5725 Avenal Avenal 2021-04-06 Kings 31 1224   12923
5726 5726 Corcoran Corcoran 2021-04-06 Kings 31 1955   22301
5727 5727 Correctional facilities Prisons 2021-04-06 Kings 31 7206    
5728 5728 Hanford Hanford 2021-04-06 Kings 31 7664   55893
5729 5729 Kettleman City Kettleman City 2021-04-06 Kings 31 166   1395
5730 5730 Lemoore Lemoore 2021-04-06 Kings 31 3534   25791
5731 5731 Other Area Other 2021-04-06 Kings 31 208    
5732 5732 Stratford Stratford 2021-04-06 Kings 31 133   878
7096 7096 Armona Armona 2021-04-05 Kings 31 584   3795
7097 7097 Avenal Avenal 2021-04-05 Kings 31 1223   12923
7098 7098 Corcoran Corcoran 2021-04-05 Kings 31 1956   22301
7099 7099 Correctional facilities Prisons 2021-04-05 Kings 31 7206    
7100 7100 Hanford Hanford 2021-04-05 Kings 31 7661   55893
7101 7101 Kettleman City Kettleman City 2021-04-05 Kings 31 166   1395
7102 7102 Lemoore Lemoore 2021-04-05 Kings 31 3533   25791
7103 7103 Other Area Other 2021-04-05 Kings 31 208    
7104 7104 Stratford Stratford 2021-04-05 Kings 31 132   878
8472 8472 Armona Armona 2021-04-04 Kings 31 584   3795
8473 8473 Avenal Avenal 2021-04-04 Kings 31 1223   12923
8474 8474 Corcoran Corcoran 2021-04-04 Kings 31 1956   22301
8475 8475 Correctional facilities Prisons 2021-04-04 Kings 31 7206    
8476 8476 Hanford Hanford 2021-04-04 Kings 31 7661   55893
8477 8477 Kettleman City Kettleman City 2021-04-04 Kings 31 166   1395
8478 8478 Lemoore Lemoore 2021-04-04 Kings 31 3533   25791
8479 8479 Other Area Other 2021-04-04 Kings 31 208    
8480 8480 Stratford Stratford 2021-04-04 Kings 31 132   878
9848 9848 Armona Armona 2021-04-03 Kings 31 584   3795
9849 9849 Avenal Avenal 2021-04-03 Kings 31 1222   12923
9850 9850 Corcoran Corcoran 2021-04-03 Kings 31 1956   22301
9851 9851 Correctional facilities Prisons 2021-04-03 Kings 31 7206    
9852 9852 Hanford Hanford 2021-04-03 Kings 31 7659   55893
9853 9853 Kettleman City Kettleman City 2021-04-03 Kings 31 166   1395
9854 9854 Lemoore Lemoore 2021-04-03 Kings 31 3533   25791
9855 9855 Other Area Other 2021-04-03 Kings 31 208    
9856 9856 Stratford Stratford 2021-04-03 Kings 31 132   878
11224 11224 Armona Armona 2021-04-02 Kings 31 584   3795
11225 11225 Avenal Avenal 2021-04-02 Kings 31 1222   12923
11226 11226 Corcoran Corcoran 2021-04-02 Kings 31 1956   22301
11227 11227 Correctional facilities Prisons 2021-04-02 Kings 31 7206    
11228 11228 Hanford Hanford 2021-04-02 Kings 31 7655   55893
11229 11229 Kettleman City Kettleman City 2021-04-02 Kings 31 166   1395
11230 11230 Lemoore Lemoore 2021-04-02 Kings 31 3530   25791
11231 11231 Other Area Other 2021-04-02 Kings 31 208    
11232 11232 Stratford Stratford 2021-04-02 Kings 31 132   878
12604 12604 Armona Armona 2021-04-01 Kings 31 583   3795
12605 12605 Avenal Avenal 2021-04-01 Kings 31 1222   12923
12606 12606 Corcoran Corcoran 2021-04-01 Kings 31 1956   22301
12607 12607 Correctional facilities Prisons 2021-04-01 Kings 31 7206    
12608 12608 Hanford Hanford 2021-04-01 Kings 31 7647   55893
12609 12609 Kettleman City Kettleman City 2021-04-01 Kings 31 166   1395
12610 12610 Lemoore Lemoore 2021-04-01 Kings 31 3530   25791
12611 12611 Other Area Other 2021-04-01 Kings 31 207    
12612 12612 Stratford Stratford 2021-04-01 Kings 31 132   878
13984 13984 Armona Armona 2021-03-31 Kings 31 581   3795
13985 13985 Avenal Avenal 2021-03-31 Kings 31 1215   12923
13986 13986 Corcoran Corcoran 2021-03-31 Kings 31 1948   22301
13987 13987 Correctional facilities Prisons 2021-03-31 Kings 31 7206    
13988 13988 Hanford Hanford 2021-03-31 Kings 31 7616   55893
13989 13989 Kettleman City Kettleman City 2021-03-31 Kings 31 164   1395
13990 13990 Lemoore Lemoore 2021-03-31 Kings 31 3513   25791
13991 13991 Other Area Other 2021-03-31 Kings 31 245    
13992 13992 Stratford Stratford 2021-03-31 Kings 31 132   878
15364 15364 Armona Armona 2021-03-30 Kings 31 581   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
);