home / covid

Menu
  • GraphQL API

latimes_place_totals

Table actions
  • GraphQL API for 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

10,140 rows where fips = 47 sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

fips 1

  • 47 · 10,140 ✖

county 1

  • Merced 10,140
Link rowid id name date ▲ county fips confirmed_cases note population
236 236 Atwater Atwater 2022-12-30 Merced 47 10520   33647
237 237 Delhi Delhi 2022-12-30 Merced 47 3647   10755
238 238 Dos Palos Dos Palos 2022-12-30 Merced 47 2526   5520
239 239 Gustine Gustine 2022-12-30 Merced 47 1916   5855
240 240 Hilmar Hilmar 2022-12-30 Merced 47 1586   5197
241 241 Le Grand Planada Le Grand Planada 2022-12-30 Merced 47 1646   6243
242 242 Livingston Livingston 2022-12-30 Merced 47 4956   14426
243 243 Los Banos Los Banos 2022-12-30 Merced 47 13944   40075
244 244 Merced Merced 2022-12-30 Merced 47 25831   89459
245 245 Winton Winton 2022-12-30 Merced 47 4059   10613
1064 1064 Atwater Atwater 2022-12-29 Merced 47 10520   33647
1065 1065 Delhi Delhi 2022-12-29 Merced 47 3647   10755
1066 1066 Dos Palos Dos Palos 2022-12-29 Merced 47 2526   5520
1067 1067 Gustine Gustine 2022-12-29 Merced 47 1916   5855
1068 1068 Hilmar Hilmar 2022-12-29 Merced 47 1586   5197
1069 1069 Le Grand Planada Le Grand Planada 2022-12-29 Merced 47 1646   6243
1070 1070 Livingston Livingston 2022-12-29 Merced 47 4956   14426
1071 1071 Los Banos Los Banos 2022-12-29 Merced 47 13944   40075
1072 1072 Merced Merced 2022-12-29 Merced 47 25831   89459
1073 1073 Winton Winton 2022-12-29 Merced 47 4059   10613
2245 2245 Atwater Atwater 2022-12-28 Merced 47 10520   33647
2246 2246 Delhi Delhi 2022-12-28 Merced 47 3647   10755
2247 2247 Dos Palos Dos Palos 2022-12-28 Merced 47 2526   5520
2248 2248 Gustine Gustine 2022-12-28 Merced 47 1916   5855
2249 2249 Hilmar Hilmar 2022-12-28 Merced 47 1586   5197
2250 2250 Le Grand Planada Le Grand Planada 2022-12-28 Merced 47 1646   6243
2251 2251 Livingston Livingston 2022-12-28 Merced 47 4956   14426
2252 2252 Los Banos Los Banos 2022-12-28 Merced 47 13944   40075
2253 2253 Merced Merced 2022-12-28 Merced 47 25831   89459
2254 2254 Winton Winton 2022-12-28 Merced 47 4059   10613
3426 3426 Atwater Atwater 2022-12-27 Merced 47 10520   33647
3427 3427 Delhi Delhi 2022-12-27 Merced 47 3647   10755
3428 3428 Dos Palos Dos Palos 2022-12-27 Merced 47 2526   5520
3429 3429 Gustine Gustine 2022-12-27 Merced 47 1916   5855
3430 3430 Hilmar Hilmar 2022-12-27 Merced 47 1586   5197
3431 3431 Le Grand Planada Le Grand Planada 2022-12-27 Merced 47 1646   6243
3432 3432 Livingston Livingston 2022-12-27 Merced 47 4956   14426
3433 3433 Los Banos Los Banos 2022-12-27 Merced 47 13944   40075
3434 3434 Merced Merced 2022-12-27 Merced 47 25831   89459
3435 3435 Winton Winton 2022-12-27 Merced 47 4059   10613
4607 4607 Atwater Atwater 2022-12-26 Merced 47 10520   33647
4608 4608 Delhi Delhi 2022-12-26 Merced 47 3647   10755
4609 4609 Dos Palos Dos Palos 2022-12-26 Merced 47 2526   5520
4610 4610 Gustine Gustine 2022-12-26 Merced 47 1916   5855
4611 4611 Hilmar Hilmar 2022-12-26 Merced 47 1586   5197
4612 4612 Le Grand Planada Le Grand Planada 2022-12-26 Merced 47 1646   6243
4613 4613 Livingston Livingston 2022-12-26 Merced 47 4956   14426
4614 4614 Los Banos Los Banos 2022-12-26 Merced 47 13944   40075
4615 4615 Merced Merced 2022-12-26 Merced 47 25831   89459
4616 4616 Winton Winton 2022-12-26 Merced 47 4059   10613
5788 5788 Atwater Atwater 2022-12-25 Merced 47 10520   33647
5789 5789 Delhi Delhi 2022-12-25 Merced 47 3647   10755
5790 5790 Dos Palos Dos Palos 2022-12-25 Merced 47 2526   5520
5791 5791 Gustine Gustine 2022-12-25 Merced 47 1916   5855
5792 5792 Hilmar Hilmar 2022-12-25 Merced 47 1586   5197
5793 5793 Le Grand Planada Le Grand Planada 2022-12-25 Merced 47 1646   6243
5794 5794 Livingston Livingston 2022-12-25 Merced 47 4956   14426
5795 5795 Los Banos Los Banos 2022-12-25 Merced 47 13944   40075
5796 5796 Merced Merced 2022-12-25 Merced 47 25831   89459
5797 5797 Winton Winton 2022-12-25 Merced 47 4059   10613
6969 6969 Atwater Atwater 2022-12-24 Merced 47 10520   33647
6970 6970 Delhi Delhi 2022-12-24 Merced 47 3647   10755
6971 6971 Dos Palos Dos Palos 2022-12-24 Merced 47 2526   5520
6972 6972 Gustine Gustine 2022-12-24 Merced 47 1916   5855
6973 6973 Hilmar Hilmar 2022-12-24 Merced 47 1586   5197
6974 6974 Le Grand Planada Le Grand Planada 2022-12-24 Merced 47 1646   6243
6975 6975 Livingston Livingston 2022-12-24 Merced 47 4956   14426
6976 6976 Los Banos Los Banos 2022-12-24 Merced 47 13944   40075
6977 6977 Merced Merced 2022-12-24 Merced 47 25831   89459
6978 6978 Winton Winton 2022-12-24 Merced 47 4059   10613
8150 8150 Atwater Atwater 2022-12-23 Merced 47 10520   33647
8151 8151 Delhi Delhi 2022-12-23 Merced 47 3647   10755
8152 8152 Dos Palos Dos Palos 2022-12-23 Merced 47 2526   5520
8153 8153 Gustine Gustine 2022-12-23 Merced 47 1916   5855
8154 8154 Hilmar Hilmar 2022-12-23 Merced 47 1586   5197
8155 8155 Le Grand Planada Le Grand Planada 2022-12-23 Merced 47 1646   6243
8156 8156 Livingston Livingston 2022-12-23 Merced 47 4956   14426
8157 8157 Los Banos Los Banos 2022-12-23 Merced 47 13944   40075
8158 8158 Merced Merced 2022-12-23 Merced 47 25831   89459
8159 8159 Winton Winton 2022-12-23 Merced 47 4059   10613
9331 9331 Atwater Atwater 2022-12-22 Merced 47 10520   33647
9332 9332 Delhi Delhi 2022-12-22 Merced 47 3647   10755
9333 9333 Dos Palos Dos Palos 2022-12-22 Merced 47 2526   5520
9334 9334 Gustine Gustine 2022-12-22 Merced 47 1916   5855
9335 9335 Hilmar Hilmar 2022-12-22 Merced 47 1586   5197
9336 9336 Le Grand Planada Le Grand Planada 2022-12-22 Merced 47 1646   6243
9337 9337 Livingston Livingston 2022-12-22 Merced 47 4956   14426
9338 9338 Los Banos Los Banos 2022-12-22 Merced 47 13944   40075
9339 9339 Merced Merced 2022-12-22 Merced 47 25831   89459
9340 9340 Winton Winton 2022-12-22 Merced 47 4059   10613
10512 10512 Atwater Atwater 2022-12-21 Merced 47 10520   33647
10513 10513 Delhi Delhi 2022-12-21 Merced 47 3647   10755
10514 10514 Dos Palos Dos Palos 2022-12-21 Merced 47 2526   5520
10515 10515 Gustine Gustine 2022-12-21 Merced 47 1916   5855
10516 10516 Hilmar Hilmar 2022-12-21 Merced 47 1586   5197
10517 10517 Le Grand Planada Le Grand Planada 2022-12-21 Merced 47 1646   6243
10518 10518 Livingston Livingston 2022-12-21 Merced 47 4956   14426
10519 10519 Los Banos Los Banos 2022-12-21 Merced 47 13944   40075
10520 10520 Merced Merced 2022-12-21 Merced 47 25831   89459
10521 10521 Winton Winton 2022-12-21 Merced 47 4059   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
);
Powered by Datasette · Queries took 1288.955ms · Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_place_totals