latimes_county_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_county_totals
520 rows where county = "Tehama" 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 |
---|---|---|---|---|---|---|---|---|
52 | 52 | 2021-09-02 | Tehama | 103 | 7143 | 72 | 75 | 0 |
110 | 110 | 2021-09-01 | Tehama | 103 | 7068 | 72 | 92 | 0 |
168 | 168 | 2021-08-31 | Tehama | 103 | 6976 | 72 | 112 | 1 |
226 | 226 | 2021-08-30 | Tehama | 103 | 6864 | 71 | 0 | 0 |
284 | 284 | 2021-08-29 | Tehama | 103 | 6864 | 71 | 0 | 0 |
342 | 342 | 2021-08-28 | Tehama | 103 | 6864 | 71 | 77 | 3 |
400 | 400 | 2021-08-27 | Tehama | 103 | 6787 | 68 | 105 | 0 |
458 | 458 | 2021-08-26 | Tehama | 103 | 6682 | 68 | 39 | 1 |
516 | 516 | 2021-08-25 | Tehama | 103 | 6643 | 67 | 38 | 0 |
574 | 574 | 2021-08-24 | Tehama | 103 | 6605 | 67 | 102 | 1 |
632 | 632 | 2021-08-23 | Tehama | 103 | 6503 | 66 | 0 | 0 |
690 | 690 | 2021-08-22 | Tehama | 103 | 6503 | 66 | 0 | 0 |
748 | 748 | 2021-08-21 | Tehama | 103 | 6503 | 66 | 45 | 0 |
806 | 806 | 2021-08-20 | Tehama | 103 | 6458 | 66 | 54 | 0 |
864 | 864 | 2021-08-19 | Tehama | 103 | 6404 | 66 | 190 | 0 |
922 | 922 | 2021-08-18 | Tehama | 103 | 6214 | 66 | 0 | 0 |
980 | 980 | 2021-08-17 | Tehama | 103 | 6214 | 66 | 0 | 0 |
1038 | 1038 | 2021-08-16 | Tehama | 103 | 6214 | 66 | 0 | 0 |
1096 | 1096 | 2021-08-15 | Tehama | 103 | 6214 | 66 | 0 | 0 |
1154 | 1154 | 2021-08-14 | Tehama | 103 | 6214 | 66 | 55 | 0 |
1212 | 1212 | 2021-08-13 | Tehama | 103 | 6159 | 66 | 44 | 0 |
1270 | 1270 | 2021-08-12 | Tehama | 103 | 6115 | 66 | 19 | 0 |
1328 | 1328 | 2021-08-11 | Tehama | 103 | 6096 | 66 | 23 | 0 |
1386 | 1386 | 2021-08-10 | Tehama | 103 | 6073 | 66 | 0 | 0 |
1444 | 1444 | 2021-08-09 | Tehama | 103 | 6073 | 66 | 57 | 0 |
1502 | 1502 | 2021-08-08 | Tehama | 103 | 6016 | 66 | 0 | 0 |
1560 | 1560 | 2021-08-07 | Tehama | 103 | 6016 | 66 | 30 | 0 |
1618 | 1618 | 2021-08-06 | Tehama | 103 | 5986 | 66 | 29 | 0 |
1676 | 1676 | 2021-08-05 | Tehama | 103 | 5957 | 66 | 15 | 0 |
1734 | 1734 | 2021-08-04 | Tehama | 103 | 5942 | 66 | 15 | 0 |
1792 | 1792 | 2021-08-03 | Tehama | 103 | 5927 | 66 | 35 | 0 |
1850 | 1850 | 2021-08-02 | Tehama | 103 | 5892 | 66 | 0 | 0 |
1908 | 1908 | 2021-08-01 | Tehama | 103 | 5892 | 66 | 0 | 0 |
1966 | 1966 | 2021-07-31 | Tehama | 103 | 5892 | 66 | 12 | 0 |
2024 | 2024 | 2021-07-30 | Tehama | 103 | 5880 | 66 | 0 | 0 |
2082 | 2082 | 2021-07-29 | Tehama | 103 | 5880 | 66 | 16 | 0 |
2140 | 2140 | 2021-07-28 | Tehama | 103 | 5864 | 66 | 28 | 0 |
2198 | 2198 | 2021-07-27 | Tehama | 103 | 5836 | 66 | 0 | 0 |
2256 | 2256 | 2021-07-26 | Tehama | 103 | 5836 | 66 | 4 | 0 |
2314 | 2314 | 2021-07-25 | Tehama | 103 | 5832 | 66 | 0 | 0 |
2372 | 2372 | 2021-07-24 | Tehama | 103 | 5832 | 66 | 8 | 0 |
2430 | 2430 | 2021-07-23 | Tehama | 103 | 5824 | 66 | 9 | 0 |
2488 | 2488 | 2021-07-22 | Tehama | 103 | 5815 | 66 | 4 | 0 |
2546 | 2546 | 2021-07-21 | Tehama | 103 | 5811 | 66 | 6 | 0 |
2604 | 2604 | 2021-07-20 | Tehama | 103 | 5805 | 66 | 5 | 0 |
2662 | 2662 | 2021-07-19 | Tehama | 103 | 5800 | 66 | 0 | 0 |
2720 | 2720 | 2021-07-18 | Tehama | 103 | 5800 | 66 | 0 | 0 |
2778 | 2778 | 2021-07-17 | Tehama | 103 | 5800 | 66 | 2 | 4 |
2836 | 2836 | 2021-07-16 | Tehama | 103 | 5798 | 62 | 6 | 1 |
2894 | 2894 | 2021-07-15 | Tehama | 103 | 5792 | 61 | 1 | 0 |
2952 | 2952 | 2021-07-14 | Tehama | 103 | 5791 | 61 | 9 | 1 |
3010 | 3010 | 2021-07-13 | Tehama | 103 | 5782 | 60 | 5 | 1 |
3068 | 3068 | 2021-07-12 | Tehama | 103 | 5777 | 59 | 0 | 0 |
3126 | 3126 | 2021-07-11 | Tehama | 103 | 5777 | 59 | 0 | 0 |
3184 | 3184 | 2021-07-10 | Tehama | 103 | 5777 | 59 | 3 | 0 |
3242 | 3242 | 2021-07-09 | Tehama | 103 | 5774 | 59 | 3 | 0 |
3300 | 3300 | 2021-07-08 | Tehama | 103 | 5771 | 59 | 5 | 0 |
3358 | 3358 | 2021-07-07 | Tehama | 103 | 5766 | 59 | 4 | 0 |
3416 | 3416 | 2021-07-06 | Tehama | 103 | 5762 | 59 | 0 | 0 |
3474 | 3474 | 2021-07-05 | Tehama | 103 | 5762 | 59 | 0 | 0 |
3532 | 3532 | 2021-07-04 | Tehama | 103 | 5762 | 59 | 0 | 0 |
3590 | 3590 | 2021-07-03 | Tehama | 103 | 5762 | 59 | 4 | 0 |
3648 | 3648 | 2021-07-02 | Tehama | 103 | 5758 | 59 | 1 | 0 |
3706 | 3706 | 2021-07-01 | Tehama | 103 | 5757 | 59 | 1 | 0 |
3764 | 3764 | 2021-06-30 | Tehama | 103 | 5756 | 59 | 5 | 0 |
3822 | 3822 | 2021-06-29 | Tehama | 103 | 5751 | 59 | 1 | 0 |
3880 | 3880 | 2021-06-28 | Tehama | 103 | 5750 | 59 | 0 | 0 |
3938 | 3938 | 2021-06-27 | Tehama | 103 | 5750 | 59 | 0 | 0 |
3996 | 3996 | 2021-06-26 | Tehama | 103 | 5750 | 59 | 7 | 0 |
4054 | 4054 | 2021-06-25 | Tehama | 103 | 5743 | 59 | 1 | 0 |
4112 | 4112 | 2021-06-24 | Tehama | 103 | 5742 | 59 | 0 | 0 |
4170 | 4170 | 2021-06-23 | Tehama | 103 | 5742 | 59 | 7 | 0 |
4228 | 4228 | 2021-06-22 | Tehama | 103 | 5735 | 59 | 0 | 0 |
4286 | 4286 | 2021-06-21 | Tehama | 103 | 5735 | 59 | 1 | 0 |
4344 | 4344 | 2021-06-20 | Tehama | 103 | 5734 | 59 | 0 | 0 |
4402 | 4402 | 2021-06-19 | Tehama | 103 | 5734 | 59 | 3 | 0 |
4460 | 4460 | 2021-06-18 | Tehama | 103 | 5731 | 59 | 4 | 0 |
4518 | 4518 | 2021-06-17 | Tehama | 103 | 5727 | 59 | 3 | 0 |
4576 | 4576 | 2021-06-16 | Tehama | 103 | 5724 | 59 | 0 | 0 |
4634 | 4634 | 2021-06-15 | Tehama | 103 | 5724 | 59 | 0 | 0 |
4692 | 4692 | 2021-06-14 | Tehama | 103 | 5724 | 59 | 8 | 0 |
4750 | 4750 | 2021-06-13 | Tehama | 103 | 5716 | 59 | 0 | 0 |
4808 | 4808 | 2021-06-12 | Tehama | 103 | 5716 | 59 | 3 | 0 |
4866 | 4866 | 2021-06-11 | Tehama | 103 | 5713 | 59 | 2 | 0 |
4924 | 4924 | 2021-06-10 | Tehama | 103 | 5711 | 59 | 3 | 0 |
4982 | 4982 | 2021-06-09 | Tehama | 103 | 5708 | 59 | 0 | 0 |
5040 | 5040 | 2021-06-08 | Tehama | 103 | 5708 | 59 | 0 | 0 |
5098 | 5098 | 2021-06-07 | Tehama | 103 | 5708 | 59 | 1 | 0 |
5156 | 5156 | 2021-06-06 | Tehama | 103 | 5707 | 59 | 0 | 0 |
5214 | 5214 | 2021-06-05 | Tehama | 103 | 5707 | 59 | 3 | 0 |
5272 | 5272 | 2021-06-04 | Tehama | 103 | 5704 | 59 | 7 | 0 |
5330 | 5330 | 2021-06-03 | Tehama | 103 | 5697 | 59 | 5 | 0 |
5388 | 5388 | 2021-06-02 | Tehama | 103 | 5692 | 59 | 0 | 0 |
5446 | 5446 | 2021-06-01 | Tehama | 103 | 5692 | 59 | 14 | 0 |
5504 | 5504 | 2021-05-31 | Tehama | 103 | 5678 | 59 | 0 | 0 |
5562 | 5562 | 2021-05-30 | Tehama | 103 | 5678 | 59 | 0 | 0 |
5620 | 5620 | 2021-05-29 | Tehama | 103 | 5678 | 59 | 0 | 0 |
5678 | 5678 | 2021-05-28 | Tehama | 103 | 5678 | 59 | 4 | 0 |
5736 | 5736 | 2021-05-27 | Tehama | 103 | 5674 | 59 | 18 | 0 |
5794 | 5794 | 2021-05-26 | Tehama | 103 | 5656 | 59 | 8 | 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 );