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

1,092 rows where fips = 17 sorted by date descending

View and edit SQL

Suggested facets: x, y, date (date)

fips

  • 17 · 1,092

county

Link rowid date ▲ county fips place confirmed_cases note x y
66 2020-10-30 El Dorado 17 Camino, Pollock Pines, Kyburz 46   -120.586594 38.761292
67 2020-10-30 El Dorado 17 El Dorado Hills 378   -121.082222 38.685833
68 2020-10-30 El Dorado 17 El Dorado, Diamond Springs 40   -120.815 38.694722
69 2020-10-30 El Dorado 17 Greater Placerville Area 156   -120.798611 38.729722
70 2020-10-30 El Dorado 17 North County 36   -120.306071 38.99614
71 2020-10-30 El Dorado 17 Shingle Springs, Cameron Park, Rescue 183   -120.987222 38.668889
72 2020-10-30 El Dorado 17 South County 14   -120.57326 38.581296
73 2020-10-30 El Dorado 17 Tahoe Region 535   -119.977187 38.939926
1093 2020-10-29 El Dorado 17 Camino, Pollock Pines, Kyburz 46   -120.586594 38.761292
1094 2020-10-29 El Dorado 17 El Dorado Hills 374   -121.082222 38.685833
1095 2020-10-29 El Dorado 17 El Dorado, Diamond Springs 39   -120.815 38.694722
1096 2020-10-29 El Dorado 17 Greater Placerville Area 151   -120.798611 38.729722
1097 2020-10-29 El Dorado 17 North County 35   -120.306071 38.99614
1098 2020-10-29 El Dorado 17 Shingle Springs, Cameron Park, Rescue 176   -120.987222 38.668889
1099 2020-10-29 El Dorado 17 South County 14   -120.57326 38.581296
1100 2020-10-29 El Dorado 17 Tahoe Region 533   -119.977187 38.939926
2094 2020-10-28 El Dorado 17 Camino, Pollock Pines, Kyburz 45   -120.586594 38.761292
2095 2020-10-28 El Dorado 17 El Dorado Hills 373   -121.082222 38.685833
2096 2020-10-28 El Dorado 17 El Dorado, Diamond Springs 39   -120.815 38.694722
2097 2020-10-28 El Dorado 17 Greater Placerville Area 150   -120.798611 38.729722
2098 2020-10-28 El Dorado 17 North County 35   -120.306071 38.99614
2099 2020-10-28 El Dorado 17 Shingle Springs, Cameron Park, Rescue 176   -120.987222 38.668889
2100 2020-10-28 El Dorado 17 South County 14   -120.57326 38.581296
2101 2020-10-28 El Dorado 17 Tahoe Region 529   -119.977187 38.939926
3049 2020-10-27 El Dorado 17 Camino, Pollock Pines, Kyburz 45   -120.586594 38.761292
3050 2020-10-27 El Dorado 17 El Dorado Hills 368   -121.082222 38.685833
3051 2020-10-27 El Dorado 17 El Dorado, Diamond Springs 38   -120.815 38.694722
3052 2020-10-27 El Dorado 17 Greater Placerville Area 151   -120.798611 38.729722
3053 2020-10-27 El Dorado 17 North County 36   -120.306071 38.99614
3054 2020-10-27 El Dorado 17 Shingle Springs, Cameron Park, Rescue 176   -120.987222 38.668889
3055 2020-10-27 El Dorado 17 South County 14   -120.57326 38.581296
3056 2020-10-27 El Dorado 17 Tahoe Region 523   -119.977187 38.939926
6255 2020-10-23 El Dorado 17 Camino, Pollock Pines, Kyburz 44   -120.586594 38.761292
6256 2020-10-23 El Dorado 17 El Dorado Hills 356   -121.082222 38.685833
6257 2020-10-23 El Dorado 17 El Dorado, Diamond Springs 37   -120.815 38.694722
6258 2020-10-23 El Dorado 17 Greater Placerville Area 146   -120.798611 38.729722
6259 2020-10-23 El Dorado 17 North County 34   -120.306071 38.99614
6260 2020-10-23 El Dorado 17 Shingle Springs, Cameron Park, Rescue 170   -120.987222 38.668889
6261 2020-10-23 El Dorado 17 South County 14   -120.57326 38.581296
6262 2020-10-23 El Dorado 17 Tahoe Region 514   -119.977187 38.939926
7317 2020-10-22 El Dorado 17 Camino, Pollock Pines, Kyburz 43   -120.586594 38.761292
7318 2020-10-22 El Dorado 17 El Dorado Hills 353   -121.082222 38.685833
7319 2020-10-22 El Dorado 17 El Dorado, Diamond Springs 37   -120.815 38.694722
7320 2020-10-22 El Dorado 17 Greater Placerville Area 145   -120.798611 38.729722
7321 2020-10-22 El Dorado 17 North County 34   -120.306071 38.99614
7322 2020-10-22 El Dorado 17 Shingle Springs, Cameron Park, Rescue 169   -120.987222 38.668889
7323 2020-10-22 El Dorado 17 South County 14   -120.57326 38.581296
7324 2020-10-22 El Dorado 17 Tahoe Region 513   -119.977187 38.939926
8270 2020-10-21 El Dorado 17 Camino, Pollock Pines, Kyburz 42   -120.586594 38.761292
8271 2020-10-21 El Dorado 17 El Dorado Hills 352   -121.082222 38.685833
8272 2020-10-21 El Dorado 17 El Dorado, Diamond Springs 38   -120.815 38.694722
8273 2020-10-21 El Dorado 17 Greater Placerville Area 144   -120.798611 38.729722
8274 2020-10-21 El Dorado 17 North County 34   -120.306071 38.99614
8275 2020-10-21 El Dorado 17 Shingle Springs, Cameron Park, Rescue 169   -120.987222 38.668889
8276 2020-10-21 El Dorado 17 South County 14   -120.57326 38.581296
8277 2020-10-21 El Dorado 17 Tahoe Region 513   -119.977187 38.939926
9257 2020-10-20 El Dorado 17 Camino, Pollock Pines, Kyburz 41   -120.586594 38.761292
9258 2020-10-20 El Dorado 17 El Dorado Hills 350   -121.082222 38.685833
9259 2020-10-20 El Dorado 17 El Dorado, Diamond Springs 36   -120.815 38.694722
9260 2020-10-20 El Dorado 17 Greater Placerville Area 144   -120.798611 38.729722
9261 2020-10-20 El Dorado 17 North County 34   -120.306071 38.99614
9262 2020-10-20 El Dorado 17 Shingle Springs, Cameron Park, Rescue 170   -120.987222 38.668889
9263 2020-10-20 El Dorado 17 South County 14   -120.57326 38.581296
9264 2020-10-20 El Dorado 17 Tahoe Region 513   -119.977187 38.939926
10264 2020-10-19 El Dorado 17 Camino, Pollock Pines, Kyburz 39   -120.586594 38.761292
10265 2020-10-19 El Dorado 17 El Dorado Hills 344   -121.082222 38.685833
10266 2020-10-19 El Dorado 17 El Dorado, Diamond Springs 36   -120.815 38.694722
10267 2020-10-19 El Dorado 17 Greater Placerville Area 143   -120.798611 38.729722
10268 2020-10-19 El Dorado 17 North County 34   -120.306071 38.99614
10269 2020-10-19 El Dorado 17 Shingle Springs, Cameron Park, Rescue 169   -120.987222 38.668889
10270 2020-10-19 El Dorado 17 South County 14   -120.57326 38.581296
10271 2020-10-19 El Dorado 17 Tahoe Region 511   -119.977187 38.939926
12446 2020-10-16 El Dorado 17 Camino, Pollock Pines, Kyburz 38   -120.586594 38.761292
12447 2020-10-16 El Dorado 17 El Dorado Hills 337   -121.082222 38.685833
12448 2020-10-16 El Dorado 17 El Dorado, Diamond Springs 36   -120.815 38.694722
12449 2020-10-16 El Dorado 17 Greater Placerville Area 142   -120.798611 38.729722
12450 2020-10-16 El Dorado 17 North County 34   -120.306071 38.99614
12451 2020-10-16 El Dorado 17 Shingle Springs, Cameron Park, Rescue 168   -120.987222 38.668889
12452 2020-10-16 El Dorado 17 South County 14   -120.57326 38.581296
12453 2020-10-16 El Dorado 17 Tahoe Region 506   -119.977187 38.939926
13425 2020-10-15 El Dorado 17 Cameron Park, Shingle Springs, Rescue 167   -120.987222 38.668889
13426 2020-10-15 El Dorado 17 Camino, Pollock Pines, Kyburz 38   -120.586594 38.761292
13427 2020-10-15 El Dorado 17 Diamond Springs, El Dorado 36   -120.815 38.694722
13428 2020-10-15 El Dorado 17 El Dorado Hills 335   -121.082222 38.685833
13429 2020-10-15 El Dorado 17 Greater Placerville Area 141   -120.798611 38.729722
13430 2020-10-15 El Dorado 17 North County 34   -120.306071 38.99614
13431 2020-10-15 El Dorado 17 South County 14   -120.57326 38.581296
13432 2020-10-15 El Dorado 17 Tahoe Region 506   -119.977187 38.939926
14358 2020-10-14 El Dorado 17 Cameron Park, Shingle Springs, Rescue 166   -120.987222 38.668889
14359 2020-10-14 El Dorado 17 Camino, Pollock Pines, Kyburz 37   -120.586594 38.761292
14360 2020-10-14 El Dorado 17 Diamond Springs, El Dorado 36   -120.815 38.694722
14361 2020-10-14 El Dorado 17 El Dorado Hills 331   -121.082222 38.685833
14362 2020-10-14 El Dorado 17 Greater Placerville Area 140   -120.798611 38.729722
14363 2020-10-14 El Dorado 17 North County 34   -120.306071 38.99614
14364 2020-10-14 El Dorado 17 South County 14   -120.57326 38.581296
14365 2020-10-14 El Dorado 17 Tahoe Region 505   -119.977187 38.939926
15301 2020-10-13 El Dorado 17 Cameron Park, Shingle Springs, Rescue 165   -120.987222 38.668889
15302 2020-10-13 El Dorado 17 Camino, Pollock Pines, Kyburz 37   -120.586594 38.761292
15303 2020-10-13 El Dorado 17 Diamond Springs, El Dorado 36   -120.815 38.694722
15304 2020-10-13 El Dorado 17 El Dorado Hills 331   -121.082222 38.685833

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [latimes_place_totals] (
   [date] TEXT,
   [county] TEXT,
   [fips] INTEGER,
   [place] TEXT,
   [confirmed_cases] INTEGER,
   [note] TEXT,
   [x] TEXT,
   [y] TEXT
);
Powered by Datasette · Query took 838.839ms · Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_place_totals