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

✎ View and edit SQL

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

fips

  • 47 · 3,850 ✖

county

Link rowid id name date ▲ county fips confirmed_cases note population
684 684 Atwater Atwater 2021-04-10 Merced 47 4747   33647
685 685 Delhi Delhi 2021-04-10 Merced 47 1712   10755
686 686 Dos Palos Dos Palos 2021-04-10 Merced 47 953   5520
687 687 Gustine Gustine 2021-04-10 Merced 47 893   5855
688 688 Hilmar Hilmar 2021-04-10 Merced 47 759   5197
689 689 Le Grand Planada Le Grand Planada 2021-04-10 Merced 47 784   6243
690 690 Livingston Livingston 2021-04-10 Merced 47 2380   14426
691 691 Los Banos Los Banos 2021-04-10 Merced 47 5068   40075
692 692 Merced Merced 2021-04-10 Merced 47 11179   89459
693 693 Winton Winton 2021-04-10 Merced 47 1697   10613
2051 2051 Atwater Atwater 2021-04-09 Merced 47 4747   33647
2052 2052 Delhi Delhi 2021-04-09 Merced 47 1712   10755
2053 2053 Dos Palos Dos Palos 2021-04-09 Merced 47 953   5520
2054 2054 Gustine Gustine 2021-04-09 Merced 47 893   5855
2055 2055 Hilmar Hilmar 2021-04-09 Merced 47 759   5197
2056 2056 Le Grand Planada Le Grand Planada 2021-04-09 Merced 47 784   6243
2057 2057 Livingston Livingston 2021-04-09 Merced 47 2380   14426
2058 2058 Los Banos Los Banos 2021-04-09 Merced 47 5068   40075
2059 2059 Merced Merced 2021-04-09 Merced 47 11179   89459
2060 2060 Winton Winton 2021-04-09 Merced 47 1697   10613
3421 3421 Atwater Atwater 2021-04-08 Merced 47 4747   33647
3422 3422 Delhi Delhi 2021-04-08 Merced 47 1711   10755
3423 3423 Dos Palos Dos Palos 2021-04-08 Merced 47 953   5520
3424 3424 Gustine Gustine 2021-04-08 Merced 47 893   5855
3425 3425 Hilmar Hilmar 2021-04-08 Merced 47 759   5197
3426 3426 Le Grand Planada Le Grand Planada 2021-04-08 Merced 47 783   6243
3427 3427 Livingston Livingston 2021-04-08 Merced 47 2377   14426
3428 3428 Los Banos Los Banos 2021-04-08 Merced 47 5067   40075
3429 3429 Merced Merced 2021-04-08 Merced 47 11166   89459
3430 3430 Winton Winton 2021-04-08 Merced 47 1697   10613
4791 4791 Atwater Atwater 2021-04-07 Merced 47 4739   33647
4792 4792 Delhi Delhi 2021-04-07 Merced 47 1709   10755
4793 4793 Dos Palos Dos Palos 2021-04-07 Merced 47 953   5520
4794 4794 Gustine Gustine 2021-04-07 Merced 47 892   5855
4795 4795 Hilmar Hilmar 2021-04-07 Merced 47 758   5197
4796 4796 Le Grand Planada Le Grand Planada 2021-04-07 Merced 47 783   6243
4797 4797 Livingston Livingston 2021-04-07 Merced 47 2376   14426
4798 4798 Los Banos Los Banos 2021-04-07 Merced 47 5065   40075
4799 4799 Merced Merced 2021-04-07 Merced 47 11158   89459
4800 4800 Winton Winton 2021-04-07 Merced 47 1694   10613
6163 6163 Atwater Atwater 2021-04-06 Merced 47 4737   33647
6164 6164 Delhi Delhi 2021-04-06 Merced 47 1707   10755
6165 6165 Dos Palos Dos Palos 2021-04-06 Merced 47 950   5520
6166 6166 Gustine Gustine 2021-04-06 Merced 47 892   5855
6167 6167 Hilmar Hilmar 2021-04-06 Merced 47 758   5197
6168 6168 Le Grand Planada Le Grand Planada 2021-04-06 Merced 47 782   6243
6169 6169 Livingston Livingston 2021-04-06 Merced 47 2375   14426
6170 6170 Los Banos Los Banos 2021-04-06 Merced 47 5060   40075
6171 6171 Merced Merced 2021-04-06 Merced 47 11151   89459
6172 6172 Winton Winton 2021-04-06 Merced 47 1692   10613
7535 7535 Atwater Atwater 2021-04-05 Merced 47 4734   33647
7536 7536 Delhi Delhi 2021-04-05 Merced 47 1705   10755
7537 7537 Dos Palos Dos Palos 2021-04-05 Merced 47 950   5520
7538 7538 Gustine Gustine 2021-04-05 Merced 47 892   5855
7539 7539 Hilmar Hilmar 2021-04-05 Merced 47 758   5197
7540 7540 Le Grand Planada Le Grand Planada 2021-04-05 Merced 47 782   6243
7541 7541 Livingston Livingston 2021-04-05 Merced 47 2371   14426
7542 7542 Los Banos Los Banos 2021-04-05 Merced 47 5057   40075
7543 7543 Merced Merced 2021-04-05 Merced 47 11137   89459
7544 7544 Winton Winton 2021-04-05 Merced 47 1691   10613
8911 8911 Atwater Atwater 2021-04-04 Merced 47 4684   33647
8912 8912 Delhi Delhi 2021-04-04 Merced 47 1696   10755
8913 8913 Dos Palos Dos Palos 2021-04-04 Merced 47 945   5520
8914 8914 Gustine Gustine 2021-04-04 Merced 47 886   5855
8915 8915 Hilmar Hilmar 2021-04-04 Merced 47 754   5197
8916 8916 Le Grand Planada Le Grand Planada 2021-04-04 Merced 47 777   6243
8917 8917 Livingston Livingston 2021-04-04 Merced 47 2353   14426
8918 8918 Los Banos Los Banos 2021-04-04 Merced 47 5041   40075
8919 8919 Merced Merced 2021-04-04 Merced 47 11042   89459
8920 8920 Winton Winton 2021-04-04 Merced 47 1679   10613
10287 10287 Atwater Atwater 2021-04-03 Merced 47 4684   33647
10288 10288 Delhi Delhi 2021-04-03 Merced 47 1696   10755
10289 10289 Dos Palos Dos Palos 2021-04-03 Merced 47 945   5520
10290 10290 Gustine Gustine 2021-04-03 Merced 47 886   5855
10291 10291 Hilmar Hilmar 2021-04-03 Merced 47 754   5197
10292 10292 Le Grand Planada Le Grand Planada 2021-04-03 Merced 47 777   6243
10293 10293 Livingston Livingston 2021-04-03 Merced 47 2353   14426
10294 10294 Los Banos Los Banos 2021-04-03 Merced 47 5041   40075
10295 10295 Merced Merced 2021-04-03 Merced 47 11042   89459
10296 10296 Winton Winton 2021-04-03 Merced 47 1679   10613
11663 11663 Atwater Atwater 2021-04-02 Merced 47 4684   33647
11664 11664 Delhi Delhi 2021-04-02 Merced 47 1696   10755
11665 11665 Dos Palos Dos Palos 2021-04-02 Merced 47 945   5520
11666 11666 Gustine Gustine 2021-04-02 Merced 47 886   5855
11667 11667 Hilmar Hilmar 2021-04-02 Merced 47 754   5197
11668 11668 Le Grand Planada Le Grand Planada 2021-04-02 Merced 47 777   6243
11669 11669 Livingston Livingston 2021-04-02 Merced 47 2353   14426
11670 11670 Los Banos Los Banos 2021-04-02 Merced 47 5041   40075
11671 11671 Merced Merced 2021-04-02 Merced 47 11042   89459
11672 11672 Winton Winton 2021-04-02 Merced 47 1679   10613
13043 13043 Atwater Atwater 2021-04-01 Merced 47 4681   33647
13044 13044 Delhi Delhi 2021-04-01 Merced 47 1693   10755
13045 13045 Dos Palos Dos Palos 2021-04-01 Merced 47 945   5520
13046 13046 Gustine Gustine 2021-04-01 Merced 47 884   5855
13047 13047 Hilmar Hilmar 2021-04-01 Merced 47 754   5197
13048 13048 Le Grand Planada Le Grand Planada 2021-04-01 Merced 47 777   6243
13049 13049 Livingston Livingston 2021-04-01 Merced 47 2349   14426
13050 13050 Los Banos Los Banos 2021-04-01 Merced 47 5038   40075
13051 13051 Merced Merced 2021-04-01 Merced 47 11023   89459
13052 13052 Winton Winton 2021-04-01 Merced 47 1679   10613

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
);