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

539 rows where fips = 5 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

Link rowid date ▲ county fips confirmed_cases deaths new_confirmed_cases new_deaths
3 3 2021-09-02 Amador 5 4559 53 33 0
61 61 2021-09-01 Amador 5 4526 53 43 0
119 119 2021-08-31 Amador 5 4483 53 18 0
177 177 2021-08-30 Amador 5 4465 53 11 0
235 235 2021-08-29 Amador 5 4454 53 0 0
293 293 2021-08-28 Amador 5 4454 53 42 0
351 351 2021-08-27 Amador 5 4412 53 35 0
409 409 2021-08-26 Amador 5 4377 53 18 0
467 467 2021-08-25 Amador 5 4359 53 17 3
525 525 2021-08-24 Amador 5 4342 50 25 0
583 583 2021-08-23 Amador 5 4317 50 18 0
641 641 2021-08-22 Amador 5 4299 50 16 0
699 699 2021-08-21 Amador 5 4283 50 0 0
757 757 2021-08-20 Amador 5 4283 50 28 0
815 815 2021-08-19 Amador 5 4255 50 40 0
873 873 2021-08-18 Amador 5 4215 50 0 0
931 931 2021-08-17 Amador 5 4215 50 16 0
989 989 2021-08-16 Amador 5 4199 50 69 1
1047 1047 2021-08-15 Amador 5 4130 49 0 0
1105 1105 2021-08-14 Amador 5 4130 49 0 0
1163 1163 2021-08-13 Amador 5 4130 49 22 0
1221 1221 2021-08-12 Amador 5 4108 49 41 0
1279 1279 2021-08-11 Amador 5 4067 49 0 0
1337 1337 2021-08-10 Amador 5 4067 49 10 0
1395 1395 2021-08-09 Amador 5 4057 49 32 1
1453 1453 2021-08-08 Amador 5 4025 48 44 0
1511 1511 2021-08-07 Amador 5 3981 48 20 0
1569 1569 2021-08-06 Amador 5 3961 48 0 0
1627 1627 2021-08-05 Amador 5 3961 48 49 0
1685 1685 2021-08-04 Amador 5 3912 48 13 0
1743 1743 2021-08-03 Amador 5 3899 48 0 0
1801 1801 2021-08-02 Amador 5 3899 48 26 0
1859 1859 2021-08-01 Amador 5 3873 48 0 0
1917 1917 2021-07-31 Amador 5 3873 48 41 0
1975 1975 2021-07-30 Amador 5 3832 48 0 0
2033 2033 2021-07-29 Amador 5 3832 48 0 0
2091 2091 2021-07-28 Amador 5 3832 48 29 0
2149 2149 2021-07-27 Amador 5 3803 48 1 0
2207 2207 2021-07-26 Amador 5 3802 48 0 0
2265 2265 2021-07-25 Amador 5 3802 48 0 0
2323 2323 2021-07-24 Amador 5 3802 48 0 0
2381 2381 2021-07-23 Amador 5 3802 48 28 0
2439 2439 2021-07-22 Amador 5 3774 48 0 0
2497 2497 2021-07-21 Amador 5 3774 48 9 0
2555 2555 2021-07-20 Amador 5 3765 48 0 0
2613 2613 2021-07-19 Amador 5 3765 48 0 0
2671 2671 2021-07-18 Amador 5 3765 48 0 0
2729 2729 2021-07-17 Amador 5 3765 48 0 0
2787 2787 2021-07-16 Amador 5 3765 48 14 0
2845 2845 2021-07-15 Amador 5 3751 48 0 0
2903 2903 2021-07-14 Amador 5 3751 48 4 0
2961 2961 2021-07-13 Amador 5 3747 48 0 0
3019 3019 2021-07-12 Amador 5 3747 48 0 0
3077 3077 2021-07-11 Amador 5 3747 48 0 0
3135 3135 2021-07-10 Amador 5 3747 48 0 0
3193 3193 2021-07-09 Amador 5 3747 48 9 1
3251 3251 2021-07-08 Amador 5 3738 47 0 0
3309 3309 2021-07-07 Amador 5 3738 47 0 0
3367 3367 2021-07-06 Amador 5 3738 47 6 0
3425 3425 2021-07-05 Amador 5 3732 47 0 0
3483 3483 2021-07-04 Amador 5 3732 47 0 0
3541 3541 2021-07-03 Amador 5 3732 47 8 0
3599 3599 2021-07-02 Amador 5 3724 47 0 0
3657 3657 2021-07-01 Amador 5 3724 47 0 0
3715 3715 2021-06-30 Amador 5 3724 47 0 0
3773 3773 2021-06-29 Amador 5 3724 47 10 0
3831 3831 2021-06-28 Amador 5 3714 47 0 0
3889 3889 2021-06-27 Amador 5 3714 47 0 0
3947 3947 2021-06-26 Amador 5 3714 47 0 0
4005 4005 2021-06-25 Amador 5 3714 47 4 0
4063 4063 2021-06-24 Amador 5 3710 47 0 0
4121 4121 2021-06-23 Amador 5 3710 47 0 0
4179 4179 2021-06-22 Amador 5 3710 47 7 0
4237 4237 2021-06-21 Amador 5 3703 47 0 0
4295 4295 2021-06-20 Amador 5 3703 47 18 0
4353 4353 2021-06-19 Amador 5 3685 47 0 0
4411 4411 2021-06-18 Amador 5 3685 47 0 0
4469 4469 2021-06-17 Amador 5 3685 47 0 0
4527 4527 2021-06-16 Amador 5 3685 47 0 0
4585 4585 2021-06-15 Amador 5 3685 47 0 0
4643 4643 2021-06-14 Amador 5 3685 47 0 0
4701 4701 2021-06-13 Amador 5 3685 47 8 0
4759 4759 2021-06-12 Amador 5 3677 47 0 0
4817 4817 2021-06-11 Amador 5 3677 47 0 0
4875 4875 2021-06-10 Amador 5 3677 47 8 0
4933 4933 2021-06-09 Amador 5 3669 47 3 0
4991 4991 2021-06-08 Amador 5 3666 47 0 0
5049 5049 2021-06-07 Amador 5 3666 47 0 0
5107 5107 2021-06-06 Amador 5 3666 47 7 0
5165 5165 2021-06-05 Amador 5 3659 47 0 0
5223 5223 2021-06-04 Amador 5 3659 47 6 0
5281 5281 2021-06-03 Amador 5 3653 47 1 0
5339 5339 2021-06-02 Amador 5 3652 47 0 0
5397 5397 2021-06-01 Amador 5 3652 47 3 0
5455 5455 2021-05-31 Amador 5 3649 47 0 0
5513 5513 2021-05-30 Amador 5 3649 47 0 0
5571 5571 2021-05-29 Amador 5 3649 47 1 0
5629 5629 2021-05-28 Amador 5 3648 47 5 0
5687 5687 2021-05-27 Amador 5 3643 47 0 0
5745 5745 2021-05-26 Amador 5 3643 47 0 0

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