latimes_county_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_county_totals
516 rows where county = "Lake" sorted by date descending
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 |
---|---|---|---|---|---|---|---|---|
17 | 17 | 2021-09-02 | Lake | 33 | 5396 | 77 | 37 | 3 |
75 | 75 | 2021-09-01 | Lake | 33 | 5359 | 74 | 36 | 0 |
133 | 133 | 2021-08-31 | Lake | 33 | 5323 | 74 | 30 | 0 |
191 | 191 | 2021-08-30 | Lake | 33 | 5293 | 74 | 26 | 0 |
249 | 249 | 2021-08-29 | Lake | 33 | 5267 | 74 | 39 | 0 |
307 | 307 | 2021-08-28 | Lake | 33 | 5228 | 74 | 32 | 0 |
365 | 365 | 2021-08-27 | Lake | 33 | 5196 | 74 | 33 | 0 |
423 | 423 | 2021-08-26 | Lake | 33 | 5163 | 74 | 28 | 2 |
481 | 481 | 2021-08-25 | Lake | 33 | 5135 | 72 | 36 | 3 |
539 | 539 | 2021-08-24 | Lake | 33 | 5099 | 69 | 30 | 0 |
597 | 597 | 2021-08-23 | Lake | 33 | 5069 | 69 | 14 | 0 |
655 | 655 | 2021-08-22 | Lake | 33 | 5055 | 69 | 31 | 0 |
713 | 713 | 2021-08-21 | Lake | 33 | 5024 | 69 | 33 | 0 |
771 | 771 | 2021-08-20 | Lake | 33 | 4991 | 69 | 34 | 0 |
829 | 829 | 2021-08-19 | Lake | 33 | 4957 | 69 | 27 | 1 |
887 | 887 | 2021-08-18 | Lake | 33 | 4930 | 68 | 32 | 0 |
945 | 945 | 2021-08-17 | Lake | 33 | 4898 | 68 | 12 | 0 |
1003 | 1003 | 2021-08-16 | Lake | 33 | 4886 | 68 | 36 | 0 |
1061 | 1061 | 2021-08-15 | Lake | 33 | 4850 | 68 | 39 | 0 |
1119 | 1119 | 2021-08-14 | Lake | 33 | 4811 | 68 | 37 | 0 |
1177 | 1177 | 2021-08-13 | Lake | 33 | 4774 | 68 | 61 | 0 |
1235 | 1235 | 2021-08-12 | Lake | 33 | 4713 | 68 | 13 | 1 |
1293 | 1293 | 2021-08-11 | Lake | 33 | 4700 | 67 | 30 | 1 |
1351 | 1351 | 2021-08-10 | Lake | 33 | 4670 | 66 | 34 | 0 |
1409 | 1409 | 2021-08-09 | Lake | 33 | 4636 | 66 | 23 | 0 |
1467 | 1467 | 2021-08-08 | Lake | 33 | 4613 | 66 | 56 | 0 |
1525 | 1525 | 2021-08-07 | Lake | 33 | 4557 | 66 | 67 | 0 |
1583 | 1583 | 2021-08-06 | Lake | 33 | 4490 | 66 | 0 | 1 |
1641 | 1641 | 2021-08-05 | Lake | 33 | 4490 | 65 | 196 | 0 |
1699 | 1699 | 2021-08-04 | Lake | 33 | 4294 | 65 | 0 | 0 |
1757 | 1757 | 2021-08-03 | Lake | 33 | 4294 | 65 | 0 | 0 |
1815 | 1815 | 2021-08-02 | Lake | 33 | 4294 | 65 | 56 | 0 |
1873 | 1873 | 2021-08-01 | Lake | 33 | 4238 | 65 | 0 | 0 |
1931 | 1931 | 2021-07-31 | Lake | 33 | 4238 | 65 | 0 | 0 |
1989 | 1989 | 2021-07-30 | Lake | 33 | 4238 | 65 | 0 | 0 |
2047 | 2047 | 2021-07-29 | Lake | 33 | 4238 | 65 | 164 | 0 |
2105 | 2105 | 2021-07-28 | Lake | 33 | 4074 | 65 | 0 | 0 |
2163 | 2163 | 2021-07-27 | Lake | 33 | 4074 | 65 | 0 | 0 |
2221 | 2221 | 2021-07-26 | Lake | 33 | 4074 | 65 | 129 | 1 |
2279 | 2279 | 2021-07-25 | Lake | 33 | 3945 | 64 | 0 | 0 |
2337 | 2337 | 2021-07-24 | Lake | 33 | 3945 | 64 | 0 | 0 |
2395 | 2395 | 2021-07-23 | Lake | 33 | 3945 | 64 | 0 | 0 |
2453 | 2453 | 2021-07-22 | Lake | 33 | 3945 | 64 | 125 | 0 |
2511 | 2511 | 2021-07-21 | Lake | 33 | 3820 | 64 | 0 | 0 |
2569 | 2569 | 2021-07-20 | Lake | 33 | 3820 | 64 | 0 | 0 |
2627 | 2627 | 2021-07-19 | Lake | 33 | 3820 | 64 | 65 | 1 |
2685 | 2685 | 2021-07-18 | Lake | 33 | 3755 | 63 | 0 | 0 |
2743 | 2743 | 2021-07-17 | Lake | 33 | 3755 | 63 | 0 | 0 |
2801 | 2801 | 2021-07-16 | Lake | 33 | 3755 | 63 | 0 | 0 |
2859 | 2859 | 2021-07-15 | Lake | 33 | 3755 | 63 | 63 | 0 |
2917 | 2917 | 2021-07-14 | Lake | 33 | 3692 | 63 | 0 | 0 |
2975 | 2975 | 2021-07-13 | Lake | 33 | 3692 | 63 | 0 | 0 |
3033 | 3033 | 2021-07-12 | Lake | 33 | 3692 | 63 | 38 | 0 |
3091 | 3091 | 2021-07-11 | Lake | 33 | 3654 | 63 | 0 | 0 |
3149 | 3149 | 2021-07-10 | Lake | 33 | 3654 | 63 | 0 | 0 |
3207 | 3207 | 2021-07-09 | Lake | 33 | 3654 | 63 | 0 | 0 |
3265 | 3265 | 2021-07-08 | Lake | 33 | 3654 | 63 | 47 | 1 |
3323 | 3323 | 2021-07-07 | Lake | 33 | 3607 | 62 | 0 | 0 |
3381 | 3381 | 2021-07-06 | Lake | 33 | 3607 | 62 | 7 | 6 |
3439 | 3439 | 2021-07-05 | Lake | 33 | 3600 | 56 | 0 | 0 |
3497 | 3497 | 2021-07-04 | Lake | 33 | 3600 | 56 | 0 | 0 |
3555 | 3555 | 2021-07-03 | Lake | 33 | 3600 | 56 | 0 | 0 |
3613 | 3613 | 2021-07-02 | Lake | 33 | 3600 | 56 | 0 | 0 |
3671 | 3671 | 2021-07-01 | Lake | 33 | 3600 | 56 | 20 | 11 |
3729 | 3729 | 2021-06-30 | Lake | 33 | 3580 | 45 | 0 | 0 |
3787 | 3787 | 2021-06-29 | Lake | 33 | 3580 | 45 | 0 | 0 |
3845 | 3845 | 2021-06-28 | Lake | 33 | 3580 | 45 | 19 | 0 |
3903 | 3903 | 2021-06-27 | Lake | 33 | 3561 | 45 | 0 | 0 |
3961 | 3961 | 2021-06-26 | Lake | 33 | 3561 | 45 | 0 | 0 |
4019 | 4019 | 2021-06-25 | Lake | 33 | 3561 | 45 | 0 | 0 |
4077 | 4077 | 2021-06-24 | Lake | 33 | 3561 | 45 | 8 | 0 |
4135 | 4135 | 2021-06-23 | Lake | 33 | 3553 | 45 | 0 | 0 |
4193 | 4193 | 2021-06-22 | Lake | 33 | 3553 | 45 | 0 | 0 |
4251 | 4251 | 2021-06-21 | Lake | 33 | 3553 | 45 | 0 | 0 |
4309 | 4309 | 2021-06-20 | Lake | 33 | 3553 | 45 | 0 | 0 |
4367 | 4367 | 2021-06-19 | Lake | 33 | 3553 | 45 | 0 | 0 |
4425 | 4425 | 2021-06-18 | Lake | 33 | 3553 | 45 | 0 | 0 |
4483 | 4483 | 2021-06-17 | Lake | 33 | 3553 | 45 | 4 | 0 |
4541 | 4541 | 2021-06-16 | Lake | 33 | 3549 | 45 | 0 | 0 |
4599 | 4599 | 2021-06-15 | Lake | 33 | 3549 | 45 | 0 | 0 |
4657 | 4657 | 2021-06-14 | Lake | 33 | 3549 | 45 | 13 | 0 |
4715 | 4715 | 2021-06-13 | Lake | 33 | 3536 | 45 | 0 | 0 |
4773 | 4773 | 2021-06-12 | Lake | 33 | 3536 | 45 | 0 | 0 |
4831 | 4831 | 2021-06-11 | Lake | 33 | 3536 | 45 | 0 | 0 |
4889 | 4889 | 2021-06-10 | Lake | 33 | 3536 | 45 | 12 | 0 |
4947 | 4947 | 2021-06-09 | Lake | 33 | 3524 | 45 | 0 | 0 |
5005 | 5005 | 2021-06-08 | Lake | 33 | 3524 | 45 | 0 | 0 |
5063 | 5063 | 2021-06-07 | Lake | 33 | 3524 | 45 | 16 | 0 |
5121 | 5121 | 2021-06-06 | Lake | 33 | 3508 | 45 | 0 | 0 |
5179 | 5179 | 2021-06-05 | Lake | 33 | 3508 | 45 | 0 | 0 |
5237 | 5237 | 2021-06-04 | Lake | 33 | 3508 | 45 | 0 | 0 |
5295 | 5295 | 2021-06-03 | Lake | 33 | 3508 | 45 | 10 | 0 |
5353 | 5353 | 2021-06-02 | Lake | 33 | 3498 | 45 | 0 | 0 |
5411 | 5411 | 2021-06-01 | Lake | 33 | 3498 | 45 | 6 | 2 |
5469 | 5469 | 2021-05-31 | Lake | 33 | 3492 | 43 | 0 | 0 |
5527 | 5527 | 2021-05-30 | Lake | 33 | 3492 | 43 | 0 | 0 |
5585 | 5585 | 2021-05-29 | Lake | 33 | 3492 | 43 | 0 | 0 |
5643 | 5643 | 2021-05-28 | Lake | 33 | 3492 | 43 | 0 | 0 |
5701 | 5701 | 2021-05-27 | Lake | 33 | 3492 | 43 | 0 | 0 |
5759 | 5759 | 2021-05-26 | Lake | 33 | 3492 | 43 | 1 | 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 );