latimes_county_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_county_totals

559 rows where county = "Placer" sorted by date descending

✎ View and edit SQL

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

Suggested facets: new_deaths, date (date)

fips 1

county 1

  • Placer · 559 ✖
Link rowid date ▲ county fips confirmed_cases deaths new_confirmed_cases new_deaths
31 31 2021-09-02 Placer 61 31104 331 308 5
89 89 2021-09-01 Placer 61 30796 326 0 0
147 147 2021-08-31 Placer 61 30796 326 1848 10
205 205 2021-08-30 Placer 61 28948 316 0 0
263 263 2021-08-29 Placer 61 28948 316 0 0
321 321 2021-08-28 Placer 61 28948 316 0 0
379 379 2021-08-27 Placer 61 28948 316 0 0
437 437 2021-08-26 Placer 61 28948 316 283 0
495 495 2021-08-25 Placer 61 28665 316 0 0
553 553 2021-08-24 Placer 61 28665 316 657 3
611 611 2021-08-23 Placer 61 28008 313 0 0
669 669 2021-08-22 Placer 61 28008 313 0 0
727 727 2021-08-21 Placer 61 28008 313 0 0
785 785 2021-08-20 Placer 61 28008 313 0 0
843 843 2021-08-19 Placer 61 28008 313 317 1
901 901 2021-08-18 Placer 61 27691 312 0 0
959 959 2021-08-17 Placer 61 27691 312 786 4
1017 1017 2021-08-16 Placer 61 26905 308 0 0
1075 1075 2021-08-15 Placer 61 26905 308 0 0
1133 1133 2021-08-14 Placer 61 26905 308 0 0
1191 1191 2021-08-13 Placer 61 26905 308 0 0
1249 1249 2021-08-12 Placer 61 26905 308 296 1
1307 1307 2021-08-11 Placer 61 26609 307 0 0
1365 1365 2021-08-10 Placer 61 26609 307 605 0
1423 1423 2021-08-09 Placer 61 26004 307 0 0
1481 1481 2021-08-08 Placer 61 26004 307 0 0
1539 1539 2021-08-07 Placer 61 26004 307 0 0
1597 1597 2021-08-06 Placer 61 26004 307 0 0
1655 1655 2021-08-05 Placer 61 26004 307 445 0
1713 1713 2021-08-04 Placer 61 25559 307 0 0
1771 1771 2021-08-03 Placer 61 25559 307 413 0
1829 1829 2021-08-02 Placer 61 25146 307 0 0
1887 1887 2021-08-01 Placer 61 25146 307 0 0
1945 1945 2021-07-31 Placer 61 25146 307 0 0
2003 2003 2021-07-30 Placer 61 25146 307 0 0
2061 2061 2021-07-29 Placer 61 25146 307 191 0
2119 2119 2021-07-28 Placer 61 24955 307 0 0
2177 2177 2021-07-27 Placer 61 24955 307 472 3
2235 2235 2021-07-26 Placer 61 24483 304 0 0
2293 2293 2021-07-25 Placer 61 24483 304 0 0
2351 2351 2021-07-24 Placer 61 24483 304 0 0
2409 2409 2021-07-23 Placer 61 24483 304 0 0
2467 2467 2021-07-22 Placer 61 24483 304 0 0
2525 2525 2021-07-21 Placer 61 24483 304 307 0
2583 2583 2021-07-20 Placer 61 24176 304 0 0
2641 2641 2021-07-19 Placer 61 24176 304 0 0
2699 2699 2021-07-18 Placer 61 24176 304 0 0
2757 2757 2021-07-17 Placer 61 24176 304 0 0
2815 2815 2021-07-16 Placer 61 24176 304 0 0
2873 2873 2021-07-15 Placer 61 24176 304 0 0
2931 2931 2021-07-14 Placer 61 24176 304 233 1
2989 2989 2021-07-13 Placer 61 23943 303 0 0
3047 3047 2021-07-12 Placer 61 23943 303 0 0
3105 3105 2021-07-11 Placer 61 23943 303 0 0
3163 3163 2021-07-10 Placer 61 23943 303 0 0
3221 3221 2021-07-09 Placer 61 23943 303 0 0
3279 3279 2021-07-08 Placer 61 23943 303 0 0
3337 3337 2021-07-07 Placer 61 23943 303 97 3
3395 3395 2021-07-06 Placer 61 23846 300 0 0
3453 3453 2021-07-05 Placer 61 23846 300 0 0
3511 3511 2021-07-04 Placer 61 23846 300 0 0
3569 3569 2021-07-03 Placer 61 23846 300 0 0
3627 3627 2021-07-02 Placer 61 23846 300 53 0
3685 3685 2021-07-01 Placer 61 23793 300 38 0
3743 3743 2021-06-30 Placer 61 23755 300 29 0
3801 3801 2021-06-29 Placer 61 23726 300 0 0
3859 3859 2021-06-28 Placer 61 23726 300 53 0
3917 3917 2021-06-27 Placer 61 23673 300 0 0
3975 3975 2021-06-26 Placer 61 23673 300 0 0
4033 4033 2021-06-25 Placer 61 23673 300 40 0
4091 4091 2021-06-24 Placer 61 23633 300 0 0
4149 4149 2021-06-23 Placer 61 23633 300 29 0
4207 4207 2021-06-22 Placer 61 23604 300 15 1
4265 4265 2021-06-21 Placer 61 23589 299 71 0
4323 4323 2021-06-20 Placer 61 23518 299 0 0
4381 4381 2021-06-19 Placer 61 23518 299 0 0
4439 4439 2021-06-18 Placer 61 23518 299 41 0
4497 4497 2021-06-17 Placer 61 23477 299 39 0
4555 4555 2021-06-16 Placer 61 23438 299 28 0
4613 4613 2021-06-15 Placer 61 23410 299 27 0
4671 4671 2021-06-14 Placer 61 23383 299 45 1
4729 4729 2021-06-13 Placer 61 23338 298 0 0
4787 4787 2021-06-12 Placer 61 23338 298 0 0
4845 4845 2021-06-11 Placer 61 23338 298 33 1
4903 4903 2021-06-10 Placer 61 23305 297 48 0
4961 4961 2021-06-09 Placer 61 23257 297 29 0
5019 5019 2021-06-08 Placer 61 23228 297 32 0
5077 5077 2021-06-07 Placer 61 23196 297 69 0
5135 5135 2021-06-06 Placer 61 23127 297 0 0
5193 5193 2021-06-05 Placer 61 23127 297 0 0
5251 5251 2021-06-04 Placer 61 23127 297 9 0
5309 5309 2021-06-03 Placer 61 23118 297 43 0
5367 5367 2021-06-02 Placer 61 23075 297 33 0
5425 5425 2021-06-01 Placer 61 23042 297 38 0
5483 5483 2021-05-31 Placer 61 23004 297 0 0
5541 5541 2021-05-30 Placer 61 23004 297 0 0
5599 5599 2021-05-29 Placer 61 23004 297 0 0
5657 5657 2021-05-28 Placer 61 23004 297 21 1
5715 5715 2021-05-27 Placer 61 22983 296 27 0
5773 5773 2021-05-26 Placer 61 22956 296 14 1

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [latimes_county_totals] (
   [date] TEXT,
   [county] TEXT,
   [fips] INTEGER,
   [confirmed_cases] INTEGER,
   [deaths] INTEGER,
   [new_confirmed_cases] INTEGER,
   [new_deaths] INTEGER
);