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

2,984 rows where fips = 17 sorted by date descending

✎ View and edit SQL

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

fips

  • 17 · 2,984 ✖

county

Link rowid id name date ▲ county fips confirmed_cases note population
109 109 Camino, Pollock Pines, Kyburz Camino, Pollock Pines, Kyburz 2021-04-10 El Dorado 17 513   13548
110 110 El Dorado Hills El Dorado Hills 2021-04-10 El Dorado 17 2077   42439
111 111 El Dorado, Diamond Springs El Dorado, Diamond Springs 2021-04-10 El Dorado 17 432   9396
112 112 Greater Placerville Area Greater Placerville Area 2021-04-10 El Dorado 17 1717   36508
113 113 North County North County 2021-04-10 El Dorado 17 443   14433
114 114 Shingle Springs, Cameron Park, Rescue Shingle Springs, Cameron Park, Rescue 2021-04-10 El Dorado 17 1652   35294
115 115 South County South County 2021-04-10 El Dorado 17 126   10345
116 116 Tahoe Region Tahoe Region 2021-04-10 El Dorado 17 2526   30275
1476 1476 Camino, Pollock Pines, Kyburz Camino, Pollock Pines, Kyburz 2021-04-09 El Dorado 17 513   13548
1477 1477 El Dorado Hills El Dorado Hills 2021-04-09 El Dorado 17 2077   42439
1478 1478 El Dorado, Diamond Springs El Dorado, Diamond Springs 2021-04-09 El Dorado 17 432   9396
1479 1479 Greater Placerville Area Greater Placerville Area 2021-04-09 El Dorado 17 1717   36508
1480 1480 North County North County 2021-04-09 El Dorado 17 443   14433
1481 1481 Shingle Springs, Cameron Park, Rescue Shingle Springs, Cameron Park, Rescue 2021-04-09 El Dorado 17 1652   35294
1482 1482 South County South County 2021-04-09 El Dorado 17 126   10345
1483 1483 Tahoe Region Tahoe Region 2021-04-09 El Dorado 17 2526   30275
2843 2843 Camino, Pollock Pines, Kyburz Camino, Pollock Pines, Kyburz 2021-04-08 El Dorado 17 513   13548
2844 2844 El Dorado Hills El Dorado Hills 2021-04-08 El Dorado 17 2070   42439
2845 2845 El Dorado, Diamond Springs El Dorado, Diamond Springs 2021-04-08 El Dorado 17 432   9396
2846 2846 Greater Placerville Area Greater Placerville Area 2021-04-08 El Dorado 17 1714   36508
2847 2847 North County North County 2021-04-08 El Dorado 17 443   14433
2848 2848 Shingle Springs, Cameron Park, Rescue Shingle Springs, Cameron Park, Rescue 2021-04-08 El Dorado 17 1648   35294
2849 2849 South County South County 2021-04-08 El Dorado 17 125   10345
2850 2850 Tahoe Region Tahoe Region 2021-04-08 El Dorado 17 2523   30275
4213 4213 Camino, Pollock Pines, Kyburz Camino, Pollock Pines, Kyburz 2021-04-07 El Dorado 17 512   13548
4214 4214 El Dorado Hills El Dorado Hills 2021-04-07 El Dorado 17 2062   42439
4215 4215 El Dorado, Diamond Springs El Dorado, Diamond Springs 2021-04-07 El Dorado 17 432   9396
4216 4216 Greater Placerville Area Greater Placerville Area 2021-04-07 El Dorado 17 1711   36508
4217 4217 North County North County 2021-04-07 El Dorado 17 442   14433
4218 4218 Shingle Springs, Cameron Park, Rescue Shingle Springs, Cameron Park, Rescue 2021-04-07 El Dorado 17 1647   35294
4219 4219 South County South County 2021-04-07 El Dorado 17 125   10345
4220 4220 Tahoe Region Tahoe Region 2021-04-07 El Dorado 17 2523   30275
5585 5585 Camino, Pollock Pines, Kyburz Camino, Pollock Pines, Kyburz 2021-04-06 El Dorado 17 512   13548
5586 5586 El Dorado Hills El Dorado Hills 2021-04-06 El Dorado 17 2060   42439
5587 5587 El Dorado, Diamond Springs El Dorado, Diamond Springs 2021-04-06 El Dorado 17 432   9396
5588 5588 Greater Placerville Area Greater Placerville Area 2021-04-06 El Dorado 17 1707   36508
5589 5589 North County North County 2021-04-06 El Dorado 17 440   14433
5590 5590 Shingle Springs, Cameron Park, Rescue Shingle Springs, Cameron Park, Rescue 2021-04-06 El Dorado 17 1646   35294
5591 5591 South County South County 2021-04-06 El Dorado 17 125   10345
5592 5592 Tahoe Region Tahoe Region 2021-04-06 El Dorado 17 2523   30275
6957 6957 Camino, Pollock Pines, Kyburz Camino, Pollock Pines, Kyburz 2021-04-05 El Dorado 17 510   13548
6958 6958 El Dorado Hills El Dorado Hills 2021-04-05 El Dorado 17 2054   42439
6959 6959 El Dorado, Diamond Springs El Dorado, Diamond Springs 2021-04-05 El Dorado 17 432   9396
6960 6960 Greater Placerville Area Greater Placerville Area 2021-04-05 El Dorado 17 1706   36508
6961 6961 North County North County 2021-04-05 El Dorado 17 434   14433
6962 6962 Shingle Springs, Cameron Park, Rescue Shingle Springs, Cameron Park, Rescue 2021-04-05 El Dorado 17 1641   35294
6963 6963 South County South County 2021-04-05 El Dorado 17 125   10345
6964 6964 Tahoe Region Tahoe Region 2021-04-05 El Dorado 17 2519   30275
8333 8333 Camino, Pollock Pines, Kyburz Camino, Pollock Pines, Kyburz 2021-04-04 El Dorado 17 510   13548
8334 8334 El Dorado Hills El Dorado Hills 2021-04-04 El Dorado 17 2044   42439
8335 8335 El Dorado, Diamond Springs El Dorado, Diamond Springs 2021-04-04 El Dorado 17 432   9396
8336 8336 Greater Placerville Area Greater Placerville Area 2021-04-04 El Dorado 17 1700   36508
8337 8337 North County North County 2021-04-04 El Dorado 17 434   14433
8338 8338 Shingle Springs, Cameron Park, Rescue Shingle Springs, Cameron Park, Rescue 2021-04-04 El Dorado 17 1640   35294
8339 8339 South County South County 2021-04-04 El Dorado 17 125   10345
8340 8340 Tahoe Region Tahoe Region 2021-04-04 El Dorado 17 2510   30275
9709 9709 Camino, Pollock Pines, Kyburz Camino, Pollock Pines, Kyburz 2021-04-03 El Dorado 17 510   13548
9710 9710 El Dorado Hills El Dorado Hills 2021-04-03 El Dorado 17 2044   42439
9711 9711 El Dorado, Diamond Springs El Dorado, Diamond Springs 2021-04-03 El Dorado 17 432   9396
9712 9712 Greater Placerville Area Greater Placerville Area 2021-04-03 El Dorado 17 1700   36508
9713 9713 North County North County 2021-04-03 El Dorado 17 434   14433
9714 9714 Shingle Springs, Cameron Park, Rescue Shingle Springs, Cameron Park, Rescue 2021-04-03 El Dorado 17 1640   35294
9715 9715 South County South County 2021-04-03 El Dorado 17 125   10345
9716 9716 Tahoe Region Tahoe Region 2021-04-03 El Dorado 17 2510   30275
11085 11085 Camino, Pollock Pines, Kyburz Camino, Pollock Pines, Kyburz 2021-04-02 El Dorado 17 510   13548
11086 11086 El Dorado Hills El Dorado Hills 2021-04-02 El Dorado 17 2044   42439
11087 11087 El Dorado, Diamond Springs El Dorado, Diamond Springs 2021-04-02 El Dorado 17 432   9396
11088 11088 Greater Placerville Area Greater Placerville Area 2021-04-02 El Dorado 17 1700   36508
11089 11089 North County North County 2021-04-02 El Dorado 17 434   14433
11090 11090 Shingle Springs, Cameron Park, Rescue Shingle Springs, Cameron Park, Rescue 2021-04-02 El Dorado 17 1640   35294
11091 11091 South County South County 2021-04-02 El Dorado 17 125   10345
11092 11092 Tahoe Region Tahoe Region 2021-04-02 El Dorado 17 2510   30275
12465 12465 Camino, Pollock Pines, Kyburz Camino, Pollock Pines, Kyburz 2021-04-01 El Dorado 17 507   13548
12466 12466 El Dorado Hills El Dorado Hills 2021-04-01 El Dorado 17 2033   42439
12467 12467 El Dorado, Diamond Springs El Dorado, Diamond Springs 2021-04-01 El Dorado 17 431   9396
12468 12468 Greater Placerville Area Greater Placerville Area 2021-04-01 El Dorado 17 1696   36508
12469 12469 North County North County 2021-04-01 El Dorado 17 432   14433
12470 12470 Shingle Springs, Cameron Park, Rescue Shingle Springs, Cameron Park, Rescue 2021-04-01 El Dorado 17 1632   35294
12471 12471 South County South County 2021-04-01 El Dorado 17 124   10345
12472 12472 Tahoe Region Tahoe Region 2021-04-01 El Dorado 17 2502   30275
13845 13845 Camino, Pollock Pines, Kyburz Camino, Pollock Pines, Kyburz 2021-03-31 El Dorado 17 506   13548
13846 13846 El Dorado Hills El Dorado Hills 2021-03-31 El Dorado 17 2034   42439
13847 13847 El Dorado, Diamond Springs El Dorado, Diamond Springs 2021-03-31 El Dorado 17 431   9396
13848 13848 Greater Placerville Area Greater Placerville Area 2021-03-31 El Dorado 17 1695   36508
13849 13849 North County North County 2021-03-31 El Dorado 17 432   14433
13850 13850 Shingle Springs, Cameron Park, Rescue Shingle Springs, Cameron Park, Rescue 2021-03-31 El Dorado 17 1630   35294
13851 13851 South County South County 2021-03-31 El Dorado 17 124   10345
13852 13852 Tahoe Region Tahoe Region 2021-03-31 El Dorado 17 2502   30275
15225 15225 Camino, Pollock Pines, Kyburz Camino, Pollock Pines, Kyburz 2021-03-30 El Dorado 17 506   13548
15226 15226 El Dorado Hills El Dorado Hills 2021-03-30 El Dorado 17 2027   42439
15227 15227 El Dorado, Diamond Springs El Dorado, Diamond Springs 2021-03-30 El Dorado 17 431   9396
15228 15228 Greater Placerville Area Greater Placerville Area 2021-03-30 El Dorado 17 1692   36508
15229 15229 North County North County 2021-03-30 El Dorado 17 432   14433
15230 15230 Shingle Springs, Cameron Park, Rescue Shingle Springs, Cameron Park, Rescue 2021-03-30 El Dorado 17 1627   35294
15231 15231 South County South County 2021-03-30 El Dorado 17 124   10345
15232 15232 Tahoe Region Tahoe Region 2021-03-30 El Dorado 17 2501   30275
16605 16605 Camino, Pollock Pines, Kyburz Camino, Pollock Pines, Kyburz 2021-03-29 El Dorado 17 506   13548
16606 16606 El Dorado Hills El Dorado Hills 2021-03-29 El Dorado 17 2027   42439
16607 16607 El Dorado, Diamond Springs El Dorado, Diamond Springs 2021-03-29 El Dorado 17 431   9396
16608 16608 Greater Placerville Area Greater Placerville Area 2021-03-29 El Dorado 17 1691   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
);