latimes_county_totals
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 new_confirmed_cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: new_deaths, date (date)
Link | rowid | date | county | fips | confirmed_cases | deaths | new_confirmed_cases ▼ | new_deaths |
---|---|---|---|---|---|---|---|---|
235 | 235 | 2021-08-29 | Amador | 5 | 4454 | 53 | 0 | 0 |
699 | 699 | 2021-08-21 | Amador | 5 | 4283 | 50 | 0 | 0 |
873 | 873 | 2021-08-18 | Amador | 5 | 4215 | 50 | 0 | 0 |
1047 | 1047 | 2021-08-15 | Amador | 5 | 4130 | 49 | 0 | 0 |
1105 | 1105 | 2021-08-14 | Amador | 5 | 4130 | 49 | 0 | 0 |
1279 | 1279 | 2021-08-11 | Amador | 5 | 4067 | 49 | 0 | 0 |
1569 | 1569 | 2021-08-06 | Amador | 5 | 3961 | 48 | 0 | 0 |
1743 | 1743 | 2021-08-03 | Amador | 5 | 3899 | 48 | 0 | 0 |
1859 | 1859 | 2021-08-01 | Amador | 5 | 3873 | 48 | 0 | 0 |
1975 | 1975 | 2021-07-30 | Amador | 5 | 3832 | 48 | 0 | 0 |
2033 | 2033 | 2021-07-29 | Amador | 5 | 3832 | 48 | 0 | 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 |
2439 | 2439 | 2021-07-22 | Amador | 5 | 3774 | 48 | 0 | 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 |
2845 | 2845 | 2021-07-15 | Amador | 5 | 3751 | 48 | 0 | 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 |
3251 | 3251 | 2021-07-08 | Amador | 5 | 3738 | 47 | 0 | 0 |
3309 | 3309 | 2021-07-07 | Amador | 5 | 3738 | 47 | 0 | 0 |
3425 | 3425 | 2021-07-05 | Amador | 5 | 3732 | 47 | 0 | 0 |
3483 | 3483 | 2021-07-04 | Amador | 5 | 3732 | 47 | 0 | 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 |
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 |
4063 | 4063 | 2021-06-24 | Amador | 5 | 3710 | 47 | 0 | 0 |
4121 | 4121 | 2021-06-23 | Amador | 5 | 3710 | 47 | 0 | 0 |
4237 | 4237 | 2021-06-21 | Amador | 5 | 3703 | 47 | 0 | 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 |
4759 | 4759 | 2021-06-12 | Amador | 5 | 3677 | 47 | 0 | 0 |
4817 | 4817 | 2021-06-11 | Amador | 5 | 3677 | 47 | 0 | 0 |
4991 | 4991 | 2021-06-08 | Amador | 5 | 3666 | 47 | 0 | 0 |
5049 | 5049 | 2021-06-07 | Amador | 5 | 3666 | 47 | 0 | 0 |
5165 | 5165 | 2021-06-05 | Amador | 5 | 3659 | 47 | 0 | 0 |
5339 | 5339 | 2021-06-02 | Amador | 5 | 3652 | 47 | 0 | 0 |
5455 | 5455 | 2021-05-31 | Amador | 5 | 3649 | 47 | 0 | 0 |
5513 | 5513 | 2021-05-30 | Amador | 5 | 3649 | 47 | 0 | 0 |
5687 | 5687 | 2021-05-27 | Amador | 5 | 3643 | 47 | 0 | 0 |
5745 | 5745 | 2021-05-26 | Amador | 5 | 3643 | 47 | 0 | 0 |
5919 | 5919 | 2021-05-23 | Amador | 5 | 3636 | 47 | 0 | 0 |
5977 | 5977 | 2021-05-22 | Amador | 5 | 3636 | 47 | 0 | 0 |
6093 | 6093 | 2021-05-20 | Amador | 5 | 3633 | 47 | 0 | 0 |
6151 | 6151 | 2021-05-19 | Amador | 5 | 3633 | 47 | 0 | 0 |
6267 | 6267 | 2021-05-17 | Amador | 5 | 3631 | 47 | 0 | 0 |
6325 | 6325 | 2021-05-16 | Amador | 5 | 3631 | 47 | 0 | 0 |
6383 | 6383 | 2021-05-15 | Amador | 5 | 3631 | 47 | 0 | 0 |
6499 | 6499 | 2021-05-13 | Amador | 5 | 3623 | 47 | 0 | 0 |
6557 | 6557 | 2021-05-12 | Amador | 5 | 3623 | 47 | 0 | 0 |
6673 | 6673 | 2021-05-10 | Amador | 5 | 3617 | 47 | 0 | 0 |
6731 | 6731 | 2021-05-09 | Amador | 5 | 3617 | 47 | 0 | 0 |
6789 | 6789 | 2021-05-08 | Amador | 5 | 3617 | 47 | 0 | 0 |
6847 | 6847 | 2021-05-07 | Amador | 5 | 3617 | 47 | 0 | 0 |
6905 | 6905 | 2021-05-06 | Amador | 5 | 3617 | 47 | 0 | 0 |
6963 | 6963 | 2021-05-05 | Amador | 5 | 3617 | 47 | 0 | 0 |
7137 | 7137 | 2021-05-02 | Amador | 5 | 3615 | 47 | 0 | 0 |
7195 | 7195 | 2021-05-01 | Amador | 5 | 3615 | 47 | 0 | 0 |
7253 | 7253 | 2021-04-30 | Amador | 5 | 3615 | 47 | 0 | 0 |
8007 | 8007 | 2021-04-17 | Amador | 5 | 3589 | 46 | 0 | 0 |
8239 | 8239 | 2021-04-13 | Amador | 5 | 3576 | 46 | 0 | 0 |
8413 | 8413 | 2021-04-10 | Amador | 5 | 3569 | 46 | 0 | 0 |
8819 | 8819 | 2021-04-03 | Amador | 5 | 3539 | 45 | 0 | 0 |
8935 | 8935 | 2021-04-01 | Amador | 5 | 3522 | 45 | 0 | 0 |
9167 | 9167 | 2021-03-28 | Amador | 5 | 3502 | 45 | 0 | 0 |
9225 | 9225 | 2021-03-27 | Amador | 5 | 3502 | 45 | 0 | 0 |
9631 | 9631 | 2021-03-20 | Amador | 5 | 3484 | 44 | 0 | 0 |
10037 | 10037 | 2021-03-13 | Amador | 5 | 3471 | 44 | 0 | 0 |
10385 | 10385 | 2021-03-07 | Amador | 5 | 3455 | 41 | 0 | 0 |
10443 | 10443 | 2021-03-06 | Amador | 5 | 3455 | 41 | 0 | 0 |
11255 | 11255 | 2021-02-20 | Amador | 5 | 3376 | 39 | 0 | 0 |
16475 | 16475 | 2020-11-22 | Amador | 5 | 413 | 15 | 0 | 0 |
16533 | 16533 | 2020-11-21 | Amador | 5 | 413 | 15 | 0 | 0 |
16881 | 16881 | 2020-11-15 | Amador | 5 | 368 | 15 | 0 | 0 |
16939 | 16939 | 2020-11-14 | Amador | 5 | 368 | 15 | 0 | 0 |
17113 | 17113 | 2020-11-11 | Amador | 5 | 353 | 15 | 0 | 0 |
17287 | 17287 | 2020-11-08 | Amador | 5 | 338 | 15 | 0 | 0 |
17345 | 17345 | 2020-11-07 | Amador | 5 | 338 | 15 | 0 | 0 |
17519 | 17519 | 2020-11-04 | Amador | 5 | 326 | 15 | 0 | 0 |
17693 | 17693 | 2020-11-01 | Amador | 5 | 311 | 15 | 0 | 0 |
17751 | 17751 | 2020-10-31 | Amador | 5 | 311 | 15 | 0 | 0 |
18099 | 18099 | 2020-10-25 | Amador | 5 | 291 | 15 | 0 | 0 |
18157 | 18157 | 2020-10-24 | Amador | 5 | 291 | 15 | 0 | 0 |
18331 | 18331 | 2020-10-21 | Amador | 5 | 276 | 15 | 0 | 0 |
18389 | 18389 | 2020-10-20 | Amador | 5 | 276 | 15 | 0 | 0 |
18505 | 18505 | 2020-10-18 | Amador | 5 | 272 | 15 | 0 | 0 |
18563 | 18563 | 2020-10-17 | Amador | 5 | 272 | 15 | 0 | 0 |
18621 | 18621 | 2020-10-16 | Amador | 5 | 272 | 15 | 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 );