latimes_county_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_county_totals
559 rows where county = "Calaveras" and fips = 9 sorted by new_confirmed_cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, new_deaths, date (date)
Link | rowid | date | county | fips | confirmed_cases | deaths | new_confirmed_cases ▼ | new_deaths |
---|---|---|---|---|---|---|---|---|
237 | 237 | 2021-08-29 | Calaveras | 9 | 2764 | 61 | 0 | 0 |
295 | 295 | 2021-08-28 | Calaveras | 9 | 2764 | 61 | 0 | 0 |
643 | 643 | 2021-08-22 | Calaveras | 9 | 2636 | 61 | 0 | 0 |
701 | 701 | 2021-08-21 | Calaveras | 9 | 2636 | 61 | 0 | 0 |
1049 | 1049 | 2021-08-15 | Calaveras | 9 | 2537 | 58 | 0 | 0 |
1107 | 1107 | 2021-08-14 | Calaveras | 9 | 2537 | 58 | 0 | 0 |
1455 | 1455 | 2021-08-08 | Calaveras | 9 | 2406 | 58 | 0 | 0 |
1513 | 1513 | 2021-08-07 | Calaveras | 9 | 2406 | 58 | 0 | 0 |
1861 | 1861 | 2021-08-01 | Calaveras | 9 | 2316 | 58 | 0 | 0 |
1919 | 1919 | 2021-07-31 | Calaveras | 9 | 2316 | 58 | 0 | 0 |
2267 | 2267 | 2021-07-25 | Calaveras | 9 | 2281 | 58 | 0 | 0 |
2325 | 2325 | 2021-07-24 | Calaveras | 9 | 2281 | 58 | 0 | 0 |
2615 | 2615 | 2021-07-19 | Calaveras | 9 | 2256 | 58 | 0 | 0 |
2673 | 2673 | 2021-07-18 | Calaveras | 9 | 2256 | 58 | 0 | 0 |
2731 | 2731 | 2021-07-17 | Calaveras | 9 | 2256 | 58 | 0 | 0 |
2963 | 2963 | 2021-07-13 | Calaveras | 9 | 2235 | 58 | 0 | 0 |
3079 | 3079 | 2021-07-11 | Calaveras | 9 | 2233 | 58 | 0 | 0 |
3137 | 3137 | 2021-07-10 | Calaveras | 9 | 2233 | 58 | 0 | 0 |
3427 | 3427 | 2021-07-05 | Calaveras | 9 | 2220 | 56 | 0 | 0 |
3485 | 3485 | 2021-07-04 | Calaveras | 9 | 2220 | 56 | 0 | 0 |
3543 | 3543 | 2021-07-03 | Calaveras | 9 | 2220 | 56 | 0 | 0 |
3891 | 3891 | 2021-06-27 | Calaveras | 9 | 2210 | 56 | 0 | 0 |
3949 | 3949 | 2021-06-26 | Calaveras | 9 | 2210 | 56 | 0 | 0 |
4007 | 4007 | 2021-06-25 | Calaveras | 9 | 2210 | 56 | 0 | 0 |
4297 | 4297 | 2021-06-20 | Calaveras | 9 | 2201 | 56 | 0 | 0 |
4355 | 4355 | 2021-06-19 | Calaveras | 9 | 2201 | 56 | 0 | 0 |
4413 | 4413 | 2021-06-18 | Calaveras | 9 | 2201 | 56 | 0 | 0 |
4471 | 4471 | 2021-06-17 | Calaveras | 9 | 2201 | 56 | 0 | 0 |
4529 | 4529 | 2021-06-16 | Calaveras | 9 | 2201 | 56 | 0 | 0 |
4587 | 4587 | 2021-06-15 | Calaveras | 9 | 2201 | 56 | 0 | 0 |
4703 | 4703 | 2021-06-13 | Calaveras | 9 | 2200 | 56 | 0 | 0 |
4761 | 4761 | 2021-06-12 | Calaveras | 9 | 2200 | 56 | 0 | 0 |
4993 | 4993 | 2021-06-08 | Calaveras | 9 | 2195 | 56 | 0 | 0 |
5109 | 5109 | 2021-06-06 | Calaveras | 9 | 2193 | 56 | 0 | 0 |
5167 | 5167 | 2021-06-05 | Calaveras | 9 | 2193 | 56 | 0 | 0 |
5457 | 5457 | 2021-05-31 | Calaveras | 9 | 2174 | 56 | 0 | 0 |
5515 | 5515 | 2021-05-30 | Calaveras | 9 | 2174 | 56 | 0 | 0 |
5573 | 5573 | 2021-05-29 | Calaveras | 9 | 2174 | 56 | 0 | 0 |
5921 | 5921 | 2021-05-23 | Calaveras | 9 | 2151 | 55 | 0 | 0 |
5979 | 5979 | 2021-05-22 | Calaveras | 9 | 2151 | 55 | 0 | 0 |
6327 | 6327 | 2021-05-16 | Calaveras | 9 | 2136 | 54 | 0 | 0 |
6385 | 6385 | 2021-05-15 | Calaveras | 9 | 2136 | 54 | 0 | 0 |
6559 | 6559 | 2021-05-12 | Calaveras | 9 | 2129 | 54 | 0 | 0 |
6733 | 6733 | 2021-05-09 | Calaveras | 9 | 2121 | 53 | 0 | 0 |
6791 | 6791 | 2021-05-08 | Calaveras | 9 | 2121 | 53 | 0 | 0 |
7139 | 7139 | 2021-05-02 | Calaveras | 9 | 2095 | 52 | 0 | 0 |
7197 | 7197 | 2021-05-01 | Calaveras | 9 | 2095 | 52 | 0 | 0 |
7545 | 7545 | 2021-04-25 | Calaveras | 9 | 2070 | 52 | 0 | 0 |
7603 | 7603 | 2021-04-24 | Calaveras | 9 | 2070 | 52 | 0 | 0 |
7951 | 7951 | 2021-04-18 | Calaveras | 9 | 2055 | 51 | 0 | 0 |
8009 | 8009 | 2021-04-17 | Calaveras | 9 | 2055 | 51 | 0 | 0 |
8357 | 8357 | 2021-04-11 | Calaveras | 9 | 2036 | 51 | 0 | 0 |
8415 | 8415 | 2021-04-10 | Calaveras | 9 | 2036 | 51 | 0 | 0 |
8763 | 8763 | 2021-04-04 | Calaveras | 9 | 2018 | 51 | 0 | 0 |
8821 | 8821 | 2021-04-03 | Calaveras | 9 | 2018 | 51 | 0 | 0 |
9169 | 9169 | 2021-03-28 | Calaveras | 9 | 1995 | 51 | 0 | 0 |
9227 | 9227 | 2021-03-27 | Calaveras | 9 | 1995 | 51 | 0 | 0 |
9575 | 9575 | 2021-03-21 | Calaveras | 9 | 1968 | 50 | 0 | 0 |
9633 | 9633 | 2021-03-20 | Calaveras | 9 | 1968 | 50 | 0 | 0 |
9981 | 9981 | 2021-03-14 | Calaveras | 9 | 1944 | 50 | 0 | 0 |
10039 | 10039 | 2021-03-13 | Calaveras | 9 | 1944 | 50 | 0 | 0 |
10155 | 10155 | 2021-03-11 | Calaveras | 9 | 1941 | 50 | 0 | 0 |
10387 | 10387 | 2021-03-07 | Calaveras | 9 | 1928 | 49 | 0 | 0 |
10445 | 10445 | 2021-03-06 | Calaveras | 9 | 1928 | 49 | 0 | 0 |
10793 | 10793 | 2021-02-28 | Calaveras | 9 | 1905 | 47 | 0 | 0 |
10851 | 10851 | 2021-02-27 | Calaveras | 9 | 1905 | 47 | 0 | 0 |
10909 | 10909 | 2021-02-26 | Calaveras | 9 | 1905 | 47 | 0 | 0 |
11199 | 11199 | 2021-02-21 | Calaveras | 9 | 1898 | 25 | 0 | 0 |
11257 | 11257 | 2021-02-20 | Calaveras | 9 | 1898 | 25 | 0 | 0 |
11373 | 11373 | 2021-02-18 | Calaveras | 9 | 1896 | 25 | 0 | 0 |
11547 | 11547 | 2021-02-15 | Calaveras | 9 | 1825 | 25 | 0 | 0 |
11605 | 11605 | 2021-02-14 | Calaveras | 9 | 1825 | 25 | 0 | 0 |
11663 | 11663 | 2021-02-13 | Calaveras | 9 | 1825 | 25 | 0 | 0 |
12011 | 12011 | 2021-02-07 | Calaveras | 9 | 1777 | 23 | 0 | 0 |
12069 | 12069 | 2021-02-06 | Calaveras | 9 | 1777 | 23 | 0 | 0 |
12417 | 12417 | 2021-01-31 | Calaveras | 9 | 1637 | 23 | 0 | 0 |
12475 | 12475 | 2021-01-30 | Calaveras | 9 | 1637 | 23 | 0 | 0 |
12823 | 12823 | 2021-01-24 | Calaveras | 9 | 1407 | 23 | 0 | 0 |
12881 | 12881 | 2021-01-23 | Calaveras | 9 | 1407 | 23 | 0 | 0 |
13171 | 13171 | 2021-01-18 | Calaveras | 9 | 1240 | 23 | 0 | 0 |
13229 | 13229 | 2021-01-17 | Calaveras | 9 | 1240 | 23 | 0 | 0 |
13287 | 13287 | 2021-01-16 | Calaveras | 9 | 1240 | 23 | 0 | 0 |
13403 | 13403 | 2021-01-14 | Calaveras | 9 | 945 | 22 | 0 | 0 |
13461 | 13461 | 2021-01-13 | Calaveras | 9 | 945 | 22 | 0 | 0 |
13577 | 13577 | 2021-01-11 | Calaveras | 9 | 922 | 22 | 0 | 0 |
13635 | 13635 | 2021-01-10 | Calaveras | 9 | 922 | 22 | 0 | 0 |
13693 | 13693 | 2021-01-09 | Calaveras | 9 | 922 | 22 | 0 | 0 |
13809 | 13809 | 2021-01-07 | Calaveras | 9 | 898 | 22 | 0 | 0 |
13867 | 13867 | 2021-01-06 | Calaveras | 9 | 898 | 22 | 0 | 0 |
13983 | 13983 | 2021-01-04 | Calaveras | 9 | 853 | 22 | 0 | 0 |
14041 | 14041 | 2021-01-03 | Calaveras | 9 | 853 | 22 | 0 | 0 |
14099 | 14099 | 2021-01-02 | Calaveras | 9 | 853 | 22 | 0 | 0 |
14157 | 14157 | 2021-01-01 | Calaveras | 9 | 853 | 22 | 0 | 0 |
14215 | 14215 | 2020-12-31 | Calaveras | 9 | 853 | 22 | 0 | 0 |
14273 | 14273 | 2020-12-30 | Calaveras | 9 | 853 | 22 | 0 | 0 |
14389 | 14389 | 2020-12-28 | Calaveras | 9 | 754 | 22 | 0 | 0 |
14447 | 14447 | 2020-12-27 | Calaveras | 9 | 754 | 22 | 0 | 0 |
14505 | 14505 | 2020-12-26 | Calaveras | 9 | 754 | 22 | 0 | 0 |
14563 | 14563 | 2020-12-25 | Calaveras | 9 | 754 | 22 | 0 | 0 |
14621 | 14621 | 2020-12-24 | Calaveras | 9 | 754 | 22 | 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 );