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

✎ View and edit SQL

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

Suggested facets: date (date)

fips

  • 17 · 4,912 ✖

county

Link rowid id name date ▲ county fips confirmed_cases note population
109 109 Camino, Pollock Pines, Kyburz Camino, Pollock Pines, Kyburz 2021-12-07 El Dorado 17 963   13548
110 110 El Dorado Hills El Dorado Hills 2021-12-07 El Dorado 17 3572   42439
111 111 El Dorado, Diamond Springs El Dorado, Diamond Springs 2021-12-07 El Dorado 17 838   9396
112 112 Greater Placerville Area Greater Placerville Area 2021-12-07 El Dorado 17 3139   36508
113 113 North County North County 2021-12-07 El Dorado 17 965   14433
114 114 Shingle Springs, Cameron Park, Rescue Shingle Springs, Cameron Park, Rescue 2021-12-07 El Dorado 17 3055   35294
115 115 South County South County 2021-12-07 El Dorado 17 262   10345
116 116 Tahoe Region Tahoe Region 2021-12-07 El Dorado 17 3854   30275
1434 1434 Camino, Pollock Pines, Kyburz Camino, Pollock Pines, Kyburz 2021-12-06 El Dorado 17 961   13548
1435 1435 El Dorado Hills El Dorado Hills 2021-12-06 El Dorado 17 3567   42439
1436 1436 El Dorado, Diamond Springs El Dorado, Diamond Springs 2021-12-06 El Dorado 17 836   9396
1437 1437 Greater Placerville Area Greater Placerville Area 2021-12-06 El Dorado 17 3138   36508
1438 1438 North County North County 2021-12-06 El Dorado 17 964   14433
1439 1439 Shingle Springs, Cameron Park, Rescue Shingle Springs, Cameron Park, Rescue 2021-12-06 El Dorado 17 3053   35294
1440 1440 South County South County 2021-12-06 El Dorado 17 261   10345
1441 1441 Tahoe Region Tahoe Region 2021-12-06 El Dorado 17 3852   30275
2759 2759 Camino, Pollock Pines, Kyburz Camino, Pollock Pines, Kyburz 2021-12-05 El Dorado 17 952   13548
2760 2760 El Dorado Hills El Dorado Hills 2021-12-05 El Dorado 17 3556   42439
2761 2761 El Dorado, Diamond Springs El Dorado, Diamond Springs 2021-12-05 El Dorado 17 832   9396
2762 2762 Greater Placerville Area Greater Placerville Area 2021-12-05 El Dorado 17 3127   36508
2763 2763 North County North County 2021-12-05 El Dorado 17 961   14433
2764 2764 Shingle Springs, Cameron Park, Rescue Shingle Springs, Cameron Park, Rescue 2021-12-05 El Dorado 17 3040   35294
2765 2765 South County South County 2021-12-05 El Dorado 17 258   10345
2766 2766 Tahoe Region Tahoe Region 2021-12-05 El Dorado 17 3835   30275
4084 4084 Camino, Pollock Pines, Kyburz Camino, Pollock Pines, Kyburz 2021-12-04 El Dorado 17 952   13548
4085 4085 El Dorado Hills El Dorado Hills 2021-12-04 El Dorado 17 3556   42439
4086 4086 El Dorado, Diamond Springs El Dorado, Diamond Springs 2021-12-04 El Dorado 17 832   9396
4087 4087 Greater Placerville Area Greater Placerville Area 2021-12-04 El Dorado 17 3127   36508
4088 4088 North County North County 2021-12-04 El Dorado 17 961   14433
4089 4089 Shingle Springs, Cameron Park, Rescue Shingle Springs, Cameron Park, Rescue 2021-12-04 El Dorado 17 3040   35294
4090 4090 South County South County 2021-12-04 El Dorado 17 258   10345
4091 4091 Tahoe Region Tahoe Region 2021-12-04 El Dorado 17 3835   30275
5409 5409 Camino, Pollock Pines, Kyburz Camino, Pollock Pines, Kyburz 2021-12-03 El Dorado 17 952   13548
5410 5410 El Dorado Hills El Dorado Hills 2021-12-03 El Dorado 17 3556   42439
5411 5411 El Dorado, Diamond Springs El Dorado, Diamond Springs 2021-12-03 El Dorado 17 832   9396
5412 5412 Greater Placerville Area Greater Placerville Area 2021-12-03 El Dorado 17 3127   36508
5413 5413 North County North County 2021-12-03 El Dorado 17 961   14433
5414 5414 Shingle Springs, Cameron Park, Rescue Shingle Springs, Cameron Park, Rescue 2021-12-03 El Dorado 17 3040   35294
5415 5415 South County South County 2021-12-03 El Dorado 17 258   10345
5416 5416 Tahoe Region Tahoe Region 2021-12-03 El Dorado 17 3835   30275
6734 6734 Camino, Pollock Pines, Kyburz Camino, Pollock Pines, Kyburz 2021-12-02 El Dorado 17 949   13548
6735 6735 El Dorado Hills El Dorado Hills 2021-12-02 El Dorado 17 3552   42439
6736 6736 El Dorado, Diamond Springs El Dorado, Diamond Springs 2021-12-02 El Dorado 17 831   9396
6737 6737 Greater Placerville Area Greater Placerville Area 2021-12-02 El Dorado 17 3117   36508
6738 6738 North County North County 2021-12-02 El Dorado 17 958   14433
6739 6739 Shingle Springs, Cameron Park, Rescue Shingle Springs, Cameron Park, Rescue 2021-12-02 El Dorado 17 3027   35294
6740 6740 South County South County 2021-12-02 El Dorado 17 255   10345
6741 6741 Tahoe Region Tahoe Region 2021-12-02 El Dorado 17 3833   30275
8059 8059 Camino, Pollock Pines, Kyburz Camino, Pollock Pines, Kyburz 2021-12-01 El Dorado 17 948   13548
8060 8060 El Dorado Hills El Dorado Hills 2021-12-01 El Dorado 17 3548   42439
8061 8061 El Dorado, Diamond Springs El Dorado, Diamond Springs 2021-12-01 El Dorado 17 828   9396
8062 8062 Greater Placerville Area Greater Placerville Area 2021-12-01 El Dorado 17 3105   36508
8063 8063 North County North County 2021-12-01 El Dorado 17 958   14433
8064 8064 Shingle Springs, Cameron Park, Rescue Shingle Springs, Cameron Park, Rescue 2021-12-01 El Dorado 17 3020   35294
8065 8065 South County South County 2021-12-01 El Dorado 17 254   10345
8066 8066 Tahoe Region Tahoe Region 2021-12-01 El Dorado 17 3825   30275
9384 9384 Camino, Pollock Pines, Kyburz Camino, Pollock Pines, Kyburz 2021-11-30 El Dorado 17 948   13548
9385 9385 El Dorado Hills El Dorado Hills 2021-11-30 El Dorado 17 3544   42439
9386 9386 El Dorado, Diamond Springs El Dorado, Diamond Springs 2021-11-30 El Dorado 17 827   9396
9387 9387 Greater Placerville Area Greater Placerville Area 2021-11-30 El Dorado 17 3099   36508
9388 9388 North County North County 2021-11-30 El Dorado 17 957   14433
9389 9389 Shingle Springs, Cameron Park, Rescue Shingle Springs, Cameron Park, Rescue 2021-11-30 El Dorado 17 3017   35294
9390 9390 South County South County 2021-11-30 El Dorado 17 252   10345
9391 9391 Tahoe Region Tahoe Region 2021-11-30 El Dorado 17 3825   30275
10709 10709 Camino, Pollock Pines, Kyburz Camino, Pollock Pines, Kyburz 2021-11-29 El Dorado 17 948   13548
10710 10710 El Dorado Hills El Dorado Hills 2021-11-29 El Dorado 17 3540   42439
10711 10711 El Dorado, Diamond Springs El Dorado, Diamond Springs 2021-11-29 El Dorado 17 827   9396
10712 10712 Greater Placerville Area Greater Placerville Area 2021-11-29 El Dorado 17 3094   36508
10713 10713 North County North County 2021-11-29 El Dorado 17 955   14433
10714 10714 Shingle Springs, Cameron Park, Rescue Shingle Springs, Cameron Park, Rescue 2021-11-29 El Dorado 17 3010   35294
10715 10715 South County South County 2021-11-29 El Dorado 17 251   10345
10716 10716 Tahoe Region Tahoe Region 2021-11-29 El Dorado 17 3821   30275
12034 12034 Camino, Pollock Pines, Kyburz Camino, Pollock Pines, Kyburz 2021-11-28 El Dorado 17 939   13548
12035 12035 El Dorado Hills El Dorado Hills 2021-11-28 El Dorado 17 3520   42439
12036 12036 El Dorado, Diamond Springs El Dorado, Diamond Springs 2021-11-28 El Dorado 17 822   9396
12037 12037 Greater Placerville Area Greater Placerville Area 2021-11-28 El Dorado 17 3083   36508
12038 12038 North County North County 2021-11-28 El Dorado 17 950   14433
12039 12039 Shingle Springs, Cameron Park, Rescue Shingle Springs, Cameron Park, Rescue 2021-11-28 El Dorado 17 2986   35294
12040 12040 South County South County 2021-11-28 El Dorado 17 249   10345
12041 12041 Tahoe Region Tahoe Region 2021-11-28 El Dorado 17 3798   30275
13359 13359 Camino, Pollock Pines, Kyburz Camino, Pollock Pines, Kyburz 2021-11-27 El Dorado 17 939   13548
13360 13360 El Dorado Hills El Dorado Hills 2021-11-27 El Dorado 17 3520   42439
13361 13361 El Dorado, Diamond Springs El Dorado, Diamond Springs 2021-11-27 El Dorado 17 822   9396
13362 13362 Greater Placerville Area Greater Placerville Area 2021-11-27 El Dorado 17 3083   36508
13363 13363 North County North County 2021-11-27 El Dorado 17 950   14433
13364 13364 Shingle Springs, Cameron Park, Rescue Shingle Springs, Cameron Park, Rescue 2021-11-27 El Dorado 17 2986   35294
13365 13365 South County South County 2021-11-27 El Dorado 17 249   10345
13366 13366 Tahoe Region Tahoe Region 2021-11-27 El Dorado 17 3798   30275
14684 14684 Camino, Pollock Pines, Kyburz Camino, Pollock Pines, Kyburz 2021-11-26 El Dorado 17 939   13548
14685 14685 El Dorado Hills El Dorado Hills 2021-11-26 El Dorado 17 3520   42439
14686 14686 El Dorado, Diamond Springs El Dorado, Diamond Springs 2021-11-26 El Dorado 17 822   9396
14687 14687 Greater Placerville Area Greater Placerville Area 2021-11-26 El Dorado 17 3083   36508
14688 14688 North County North County 2021-11-26 El Dorado 17 950   14433
14689 14689 Shingle Springs, Cameron Park, Rescue Shingle Springs, Cameron Park, Rescue 2021-11-26 El Dorado 17 2986   35294
14690 14690 South County South County 2021-11-26 El Dorado 17 249   10345
14691 14691 Tahoe Region Tahoe Region 2021-11-26 El Dorado 17 3798   30275
16009 16009 Camino, Pollock Pines, Kyburz Camino, Pollock Pines, Kyburz 2021-11-25 El Dorado 17 939   13548
16010 16010 El Dorado Hills El Dorado Hills 2021-11-25 El Dorado 17 3520   42439
16011 16011 El Dorado, Diamond Springs El Dorado, Diamond Springs 2021-11-25 El Dorado 17 822   9396
16012 16012 Greater Placerville Area Greater Placerville Area 2021-11-25 El Dorado 17 3083   36508

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