latimes_county_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_county_totals
539 rows where county = "Amador" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
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 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [latimes_county_totals] ( [date] TEXT, [county] TEXT, [fips] INTEGER, [confirmed_cases] INTEGER, [deaths] INTEGER, [new_confirmed_cases] INTEGER, [new_deaths] INTEGER );