latimes_county_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_county_totals
559 rows where fips = 9 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | fips | confirmed_cases | deaths | new_confirmed_cases | new_deaths |
---|---|---|---|---|---|---|---|---|
5805 | 5805 | 2021-05-25 | Calaveras | 9 | 2161 | 56 | 2 | 0 |
5863 | 5863 | 2021-05-24 | Calaveras | 9 | 2159 | 56 | 8 | 1 |
5921 | 5921 | 2021-05-23 | Calaveras | 9 | 2151 | 55 | 0 | 0 |
5979 | 5979 | 2021-05-22 | Calaveras | 9 | 2151 | 55 | 0 | 0 |
6037 | 6037 | 2021-05-21 | Calaveras | 9 | 2151 | 55 | 1 | 0 |
6095 | 6095 | 2021-05-20 | Calaveras | 9 | 2150 | 55 | 2 | 0 |
6153 | 6153 | 2021-05-19 | Calaveras | 9 | 2148 | 55 | 3 | 0 |
6211 | 6211 | 2021-05-18 | Calaveras | 9 | 2145 | 55 | 2 | 0 |
6269 | 6269 | 2021-05-17 | Calaveras | 9 | 2143 | 55 | 7 | 1 |
6327 | 6327 | 2021-05-16 | Calaveras | 9 | 2136 | 54 | 0 | 0 |
6385 | 6385 | 2021-05-15 | Calaveras | 9 | 2136 | 54 | 0 | 0 |
6443 | 6443 | 2021-05-14 | Calaveras | 9 | 2136 | 54 | 6 | 0 |
6501 | 6501 | 2021-05-13 | Calaveras | 9 | 2130 | 54 | 1 | 0 |
6559 | 6559 | 2021-05-12 | Calaveras | 9 | 2129 | 54 | 0 | 0 |
6617 | 6617 | 2021-05-11 | Calaveras | 9 | 2129 | 54 | 4 | 1 |
6675 | 6675 | 2021-05-10 | Calaveras | 9 | 2125 | 53 | 4 | 0 |
6733 | 6733 | 2021-05-09 | Calaveras | 9 | 2121 | 53 | 0 | 0 |
6791 | 6791 | 2021-05-08 | Calaveras | 9 | 2121 | 53 | 0 | 0 |
6849 | 6849 | 2021-05-07 | Calaveras | 9 | 2121 | 53 | 5 | 0 |
6907 | 6907 | 2021-05-06 | Calaveras | 9 | 2116 | 53 | 5 | 0 |
6965 | 6965 | 2021-05-05 | Calaveras | 9 | 2111 | 53 | 3 | 0 |
7023 | 7023 | 2021-05-04 | Calaveras | 9 | 2108 | 53 | 9 | 1 |
7081 | 7081 | 2021-05-03 | Calaveras | 9 | 2099 | 52 | 4 | 0 |
7139 | 7139 | 2021-05-02 | Calaveras | 9 | 2095 | 52 | 0 | 0 |
7197 | 7197 | 2021-05-01 | Calaveras | 9 | 2095 | 52 | 0 | 0 |
7255 | 7255 | 2021-04-30 | Calaveras | 9 | 2095 | 52 | 5 | 0 |
7313 | 7313 | 2021-04-29 | Calaveras | 9 | 2090 | 52 | 4 | 0 |
7371 | 7371 | 2021-04-28 | Calaveras | 9 | 2086 | 52 | 3 | 0 |
7429 | 7429 | 2021-04-27 | Calaveras | 9 | 2083 | 52 | 8 | 0 |
7487 | 7487 | 2021-04-26 | Calaveras | 9 | 2075 | 52 | 5 | 0 |
7545 | 7545 | 2021-04-25 | Calaveras | 9 | 2070 | 52 | 0 | 0 |
7603 | 7603 | 2021-04-24 | Calaveras | 9 | 2070 | 52 | 0 | 0 |
7661 | 7661 | 2021-04-23 | Calaveras | 9 | 2070 | 52 | 4 | 0 |
7719 | 7719 | 2021-04-22 | Calaveras | 9 | 2066 | 52 | 2 | 0 |
7777 | 7777 | 2021-04-21 | Calaveras | 9 | 2064 | 52 | 2 | 0 |
7835 | 7835 | 2021-04-20 | Calaveras | 9 | 2062 | 52 | 2 | 1 |
7893 | 7893 | 2021-04-19 | Calaveras | 9 | 2060 | 51 | 5 | 0 |
7951 | 7951 | 2021-04-18 | Calaveras | 9 | 2055 | 51 | 0 | 0 |
8009 | 8009 | 2021-04-17 | Calaveras | 9 | 2055 | 51 | 0 | 0 |
8067 | 8067 | 2021-04-16 | Calaveras | 9 | 2055 | 51 | 5 | 0 |
8125 | 8125 | 2021-04-15 | Calaveras | 9 | 2050 | 51 | 2 | 0 |
8183 | 8183 | 2021-04-14 | Calaveras | 9 | 2048 | 51 | 3 | 0 |
8241 | 8241 | 2021-04-13 | Calaveras | 9 | 2045 | 51 | 4 | 0 |
8299 | 8299 | 2021-04-12 | Calaveras | 9 | 2041 | 51 | 5 | 0 |
8357 | 8357 | 2021-04-11 | Calaveras | 9 | 2036 | 51 | 0 | 0 |
8415 | 8415 | 2021-04-10 | Calaveras | 9 | 2036 | 51 | 0 | 0 |
8473 | 8473 | 2021-04-09 | Calaveras | 9 | 2036 | 51 | 3 | 0 |
8531 | 8531 | 2021-04-08 | Calaveras | 9 | 2033 | 51 | 1 | 0 |
8589 | 8589 | 2021-04-07 | Calaveras | 9 | 2032 | 51 | 3 | 0 |
8647 | 8647 | 2021-04-06 | Calaveras | 9 | 2029 | 51 | 6 | 0 |
8705 | 8705 | 2021-04-05 | Calaveras | 9 | 2023 | 51 | 5 | 0 |
8763 | 8763 | 2021-04-04 | Calaveras | 9 | 2018 | 51 | 0 | 0 |
8821 | 8821 | 2021-04-03 | Calaveras | 9 | 2018 | 51 | 0 | 0 |
8879 | 8879 | 2021-04-02 | Calaveras | 9 | 2018 | 51 | 5 | 0 |
8937 | 8937 | 2021-04-01 | Calaveras | 9 | 2013 | 51 | 2 | 0 |
8995 | 8995 | 2021-03-31 | Calaveras | 9 | 2011 | 51 | 2 | 0 |
9053 | 9053 | 2021-03-30 | Calaveras | 9 | 2009 | 51 | 3 | 0 |
9111 | 9111 | 2021-03-29 | Calaveras | 9 | 2006 | 51 | 11 | 0 |
9169 | 9169 | 2021-03-28 | Calaveras | 9 | 1995 | 51 | 0 | 0 |
9227 | 9227 | 2021-03-27 | Calaveras | 9 | 1995 | 51 | 0 | 0 |
9285 | 9285 | 2021-03-26 | Calaveras | 9 | 1995 | 51 | 4 | 0 |
9343 | 9343 | 2021-03-25 | Calaveras | 9 | 1991 | 51 | 8 | 0 |
9401 | 9401 | 2021-03-24 | Calaveras | 9 | 1983 | 51 | 4 | 0 |
9459 | 9459 | 2021-03-23 | Calaveras | 9 | 1979 | 51 | 7 | 0 |
9517 | 9517 | 2021-03-22 | Calaveras | 9 | 1972 | 51 | 4 | 1 |
9575 | 9575 | 2021-03-21 | Calaveras | 9 | 1968 | 50 | 0 | 0 |
9633 | 9633 | 2021-03-20 | Calaveras | 9 | 1968 | 50 | 0 | 0 |
9691 | 9691 | 2021-03-19 | Calaveras | 9 | 1968 | 50 | 5 | 0 |
9749 | 9749 | 2021-03-18 | Calaveras | 9 | 1963 | 50 | 5 | 0 |
9807 | 9807 | 2021-03-17 | Calaveras | 9 | 1958 | 50 | 7 | 0 |
9865 | 9865 | 2021-03-16 | Calaveras | 9 | 1951 | 50 | 5 | 0 |
9923 | 9923 | 2021-03-15 | Calaveras | 9 | 1946 | 50 | 2 | 0 |
9981 | 9981 | 2021-03-14 | Calaveras | 9 | 1944 | 50 | 0 | 0 |
10039 | 10039 | 2021-03-13 | Calaveras | 9 | 1944 | 50 | 0 | 0 |
10097 | 10097 | 2021-03-12 | Calaveras | 9 | 1944 | 50 | 3 | 0 |
10155 | 10155 | 2021-03-11 | Calaveras | 9 | 1941 | 50 | 0 | 0 |
10213 | 10213 | 2021-03-10 | Calaveras | 9 | 1941 | 50 | 7 | 1 |
10271 | 10271 | 2021-03-09 | Calaveras | 9 | 1934 | 49 | 1 | 0 |
10329 | 10329 | 2021-03-08 | Calaveras | 9 | 1933 | 49 | 5 | 0 |
10387 | 10387 | 2021-03-07 | Calaveras | 9 | 1928 | 49 | 0 | 0 |
10445 | 10445 | 2021-03-06 | Calaveras | 9 | 1928 | 49 | 0 | 0 |
10503 | 10503 | 2021-03-05 | Calaveras | 9 | 1928 | 49 | 6 | 0 |
10561 | 10561 | 2021-03-04 | Calaveras | 9 | 1922 | 49 | 4 | 0 |
10619 | 10619 | 2021-03-03 | Calaveras | 9 | 1918 | 49 | 7 | 0 |
10677 | 10677 | 2021-03-02 | Calaveras | 9 | 1911 | 49 | 1 | 0 |
10735 | 10735 | 2021-03-01 | Calaveras | 9 | 1910 | 49 | 5 | 2 |
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 |
10967 | 10967 | 2021-02-25 | Calaveras | 9 | 1905 | 47 | 1 | 0 |
11025 | 11025 | 2021-02-24 | Calaveras | 9 | 1904 | 47 | 2 | 22 |
11083 | 11083 | 2021-02-23 | Calaveras | 9 | 1902 | 25 | 1 | 0 |
11141 | 11141 | 2021-02-22 | Calaveras | 9 | 1901 | 25 | 3 | 0 |
11199 | 11199 | 2021-02-21 | Calaveras | 9 | 1898 | 25 | 0 | 0 |
11257 | 11257 | 2021-02-20 | Calaveras | 9 | 1898 | 25 | 0 | 0 |
11315 | 11315 | 2021-02-19 | Calaveras | 9 | 1898 | 25 | 2 | 0 |
11373 | 11373 | 2021-02-18 | Calaveras | 9 | 1896 | 25 | 0 | 0 |
11431 | 11431 | 2021-02-17 | Calaveras | 9 | 1896 | 25 | 60 | 0 |
11489 | 11489 | 2021-02-16 | Calaveras | 9 | 1836 | 25 | 11 | 0 |
11547 | 11547 | 2021-02-15 | Calaveras | 9 | 1825 | 25 | 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 );