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

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

Suggested facets: x, y, date (date)

fips

  • 17 · 1,092 ✖

county

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