latimes_county_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_county_totals
527 rows where county = "Sutter" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: confirmed_cases, deaths, new_confirmed_cases, new_deaths, date (date)
Link | rowid | date | county | fips ▼ | confirmed_cases | deaths | new_confirmed_cases | new_deaths |
---|---|---|---|---|---|---|---|---|
51 | 51 | 2021-09-02 | Sutter | 101 | 12161 | 124 | 75 | 1 |
109 | 109 | 2021-09-01 | Sutter | 101 | 12086 | 123 | 53 | 2 |
167 | 167 | 2021-08-31 | Sutter | 101 | 12033 | 121 | 72 | 0 |
225 | 225 | 2021-08-30 | Sutter | 101 | 11961 | 121 | 197 | 1 |
283 | 283 | 2021-08-29 | Sutter | 101 | 11764 | 120 | 0 | 0 |
341 | 341 | 2021-08-28 | Sutter | 101 | 11764 | 120 | 0 | 0 |
399 | 399 | 2021-08-27 | Sutter | 101 | 11764 | 120 | 91 | 1 |
457 | 457 | 2021-08-26 | Sutter | 101 | 11673 | 119 | 95 | 0 |
515 | 515 | 2021-08-25 | Sutter | 101 | 11578 | 119 | 59 | 1 |
573 | 573 | 2021-08-24 | Sutter | 101 | 11519 | 118 | 92 | 0 |
631 | 631 | 2021-08-23 | Sutter | 101 | 11427 | 118 | 184 | 1 |
689 | 689 | 2021-08-22 | Sutter | 101 | 11243 | 117 | 0 | 0 |
747 | 747 | 2021-08-21 | Sutter | 101 | 11243 | 117 | 0 | 0 |
805 | 805 | 2021-08-20 | Sutter | 101 | 11243 | 117 | 71 | 0 |
863 | 863 | 2021-08-19 | Sutter | 101 | 11172 | 117 | 78 | 0 |
921 | 921 | 2021-08-18 | Sutter | 101 | 11094 | 117 | 33 | 4 |
979 | 979 | 2021-08-17 | Sutter | 101 | 11061 | 113 | 47 | 0 |
1037 | 1037 | 2021-08-16 | Sutter | 101 | 11014 | 113 | 152 | 0 |
1095 | 1095 | 2021-08-15 | Sutter | 101 | 10862 | 113 | 0 | 0 |
1153 | 1153 | 2021-08-14 | Sutter | 101 | 10862 | 113 | 0 | 0 |
1211 | 1211 | 2021-08-13 | Sutter | 101 | 10862 | 113 | 59 | 1 |
1269 | 1269 | 2021-08-12 | Sutter | 101 | 10803 | 112 | 66 | 0 |
1327 | 1327 | 2021-08-11 | Sutter | 101 | 10737 | 112 | 56 | 0 |
1385 | 1385 | 2021-08-10 | Sutter | 101 | 10681 | 112 | 59 | 0 |
1443 | 1443 | 2021-08-09 | Sutter | 101 | 10622 | 112 | 124 | 0 |
1501 | 1501 | 2021-08-08 | Sutter | 101 | 10498 | 112 | 0 | 0 |
1559 | 1559 | 2021-08-07 | Sutter | 101 | 10498 | 112 | 0 | 0 |
1617 | 1617 | 2021-08-06 | Sutter | 101 | 10498 | 112 | 62 | 0 |
1675 | 1675 | 2021-08-05 | Sutter | 101 | 10436 | 112 | 44 | 1 |
1733 | 1733 | 2021-08-04 | Sutter | 101 | 10392 | 111 | 49 | 0 |
1791 | 1791 | 2021-08-03 | Sutter | 101 | 10343 | 111 | 32 | 0 |
1849 | 1849 | 2021-08-02 | Sutter | 101 | 10311 | 111 | 108 | 0 |
1907 | 1907 | 2021-08-01 | Sutter | 101 | 10203 | 111 | 0 | 0 |
1965 | 1965 | 2021-07-31 | Sutter | 101 | 10203 | 111 | 0 | 0 |
2023 | 2023 | 2021-07-30 | Sutter | 101 | 10203 | 111 | 44 | 0 |
2081 | 2081 | 2021-07-29 | Sutter | 101 | 10159 | 111 | 33 | 0 |
2139 | 2139 | 2021-07-28 | Sutter | 101 | 10126 | 111 | 46 | 0 |
2197 | 2197 | 2021-07-27 | Sutter | 101 | 10080 | 111 | 26 | 0 |
2255 | 2255 | 2021-07-26 | Sutter | 101 | 10054 | 111 | 66 | 1 |
2313 | 2313 | 2021-07-25 | Sutter | 101 | 9988 | 110 | 0 | 0 |
2371 | 2371 | 2021-07-24 | Sutter | 101 | 9988 | 110 | 0 | 0 |
2429 | 2429 | 2021-07-23 | Sutter | 101 | 9988 | 110 | 23 | 0 |
2487 | 2487 | 2021-07-22 | Sutter | 101 | 9965 | 110 | 14 | 0 |
2545 | 2545 | 2021-07-21 | Sutter | 101 | 9951 | 110 | 25 | 2 |
2603 | 2603 | 2021-07-20 | Sutter | 101 | 9926 | 108 | 13 | 0 |
2661 | 2661 | 2021-07-19 | Sutter | 101 | 9913 | 108 | 42 | 0 |
2719 | 2719 | 2021-07-18 | Sutter | 101 | 9871 | 108 | 0 | 0 |
2777 | 2777 | 2021-07-17 | Sutter | 101 | 9871 | 108 | 0 | 0 |
2835 | 2835 | 2021-07-16 | Sutter | 101 | 9871 | 108 | 16 | 0 |
2893 | 2893 | 2021-07-15 | Sutter | 101 | 9855 | 108 | 17 | 0 |
2951 | 2951 | 2021-07-14 | Sutter | 101 | 9838 | 108 | 19 | 0 |
3009 | 3009 | 2021-07-13 | Sutter | 101 | 9819 | 108 | 10 | 0 |
3067 | 3067 | 2021-07-12 | Sutter | 101 | 9809 | 108 | 40 | 0 |
3125 | 3125 | 2021-07-11 | Sutter | 101 | 9769 | 108 | 0 | 0 |
3183 | 3183 | 2021-07-10 | Sutter | 101 | 9769 | 108 | 0 | 0 |
3241 | 3241 | 2021-07-09 | Sutter | 101 | 9769 | 108 | 8 | 0 |
3299 | 3299 | 2021-07-08 | Sutter | 101 | 9761 | 108 | 5 | 0 |
3357 | 3357 | 2021-07-07 | Sutter | 101 | 9756 | 108 | 8 | 0 |
3415 | 3415 | 2021-07-06 | Sutter | 101 | 9748 | 108 | 27 | 0 |
3473 | 3473 | 2021-07-05 | Sutter | 101 | 9721 | 108 | 0 | 0 |
3531 | 3531 | 2021-07-04 | Sutter | 101 | 9721 | 108 | 0 | 0 |
3589 | 3589 | 2021-07-03 | Sutter | 101 | 9721 | 108 | 0 | 0 |
3647 | 3647 | 2021-07-02 | Sutter | 101 | 9721 | 108 | 9 | 0 |
3705 | 3705 | 2021-07-01 | Sutter | 101 | 9712 | 108 | 5 | 0 |
3763 | 3763 | 2021-06-30 | Sutter | 101 | 9707 | 108 | 7 | 0 |
3821 | 3821 | 2021-06-29 | Sutter | 101 | 9700 | 108 | 0 | 1 |
3879 | 3879 | 2021-06-28 | Sutter | 101 | 9700 | 107 | 16 | 0 |
3937 | 3937 | 2021-06-27 | Sutter | 101 | 9684 | 107 | 0 | 0 |
3995 | 3995 | 2021-06-26 | Sutter | 101 | 9684 | 107 | 0 | 0 |
4053 | 4053 | 2021-06-25 | Sutter | 101 | 9684 | 107 | 8 | 0 |
4111 | 4111 | 2021-06-24 | Sutter | 101 | 9676 | 107 | 4 | 1 |
4169 | 4169 | 2021-06-23 | Sutter | 101 | 9672 | 106 | 6 | 0 |
4227 | 4227 | 2021-06-22 | Sutter | 101 | 9666 | 106 | 3 | 0 |
4285 | 4285 | 2021-06-21 | Sutter | 101 | 9663 | 106 | 7 | 0 |
4343 | 4343 | 2021-06-20 | Sutter | 101 | 9656 | 106 | 0 | 0 |
4401 | 4401 | 2021-06-19 | Sutter | 101 | 9656 | 106 | 0 | 0 |
4459 | 4459 | 2021-06-18 | Sutter | 101 | 9656 | 106 | 6 | 0 |
4517 | 4517 | 2021-06-17 | Sutter | 101 | 9650 | 106 | 12 | 0 |
4575 | 4575 | 2021-06-16 | Sutter | 101 | 9638 | 106 | 5 | 0 |
4633 | 4633 | 2021-06-15 | Sutter | 101 | 9633 | 106 | 5 | 0 |
4691 | 4691 | 2021-06-14 | Sutter | 101 | 9628 | 106 | 14 | 0 |
4749 | 4749 | 2021-06-13 | Sutter | 101 | 9614 | 106 | 0 | 0 |
4807 | 4807 | 2021-06-12 | Sutter | 101 | 9614 | 106 | 0 | 0 |
4865 | 4865 | 2021-06-11 | Sutter | 101 | 9614 | 106 | 2 | 0 |
4923 | 4923 | 2021-06-10 | Sutter | 101 | 9612 | 106 | 10 | 0 |
4981 | 4981 | 2021-06-09 | Sutter | 101 | 9602 | 106 | 3 | 0 |
5039 | 5039 | 2021-06-08 | Sutter | 101 | 9599 | 106 | 12 | 0 |
5097 | 5097 | 2021-06-07 | Sutter | 101 | 9587 | 106 | 14 | 0 |
5155 | 5155 | 2021-06-06 | Sutter | 101 | 9573 | 106 | 0 | 0 |
5213 | 5213 | 2021-06-05 | Sutter | 101 | 9573 | 106 | 0 | 0 |
5271 | 5271 | 2021-06-04 | Sutter | 101 | 9573 | 106 | 12 | 0 |
5329 | 5329 | 2021-06-03 | Sutter | 101 | 9561 | 106 | 7 | 0 |
5387 | 5387 | 2021-06-02 | Sutter | 101 | 9554 | 106 | 11 | 0 |
5445 | 5445 | 2021-06-01 | Sutter | 101 | 9543 | 106 | 16 | 0 |
5503 | 5503 | 2021-05-31 | Sutter | 101 | 9527 | 106 | 0 | 0 |
5561 | 5561 | 2021-05-30 | Sutter | 101 | 9527 | 106 | 0 | 0 |
5619 | 5619 | 2021-05-29 | Sutter | 101 | 9527 | 106 | 0 | 0 |
5677 | 5677 | 2021-05-28 | Sutter | 101 | 9527 | 106 | 8 | 0 |
5735 | 5735 | 2021-05-27 | Sutter | 101 | 9519 | 106 | 6 | 0 |
5793 | 5793 | 2021-05-26 | Sutter | 101 | 9513 | 106 | 4 | 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 );