latimes_agency_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_agency_totals
559 rows where fips = 9 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | agency | county | fips | date ▲ | confirmed_cases | deaths | did_not_update |
---|---|---|---|---|---|---|---|---|
6106 | 6106 | Calaveras | Calaveras | 9 | 2021-05-25 | 2161 | 56 | |
6167 | 6167 | Calaveras | Calaveras | 9 | 2021-05-24 | 2159 | 56 | |
6228 | 6228 | Calaveras | Calaveras | 9 | 2021-05-23 | 2151 | 55 | TRUE |
6289 | 6289 | Calaveras | Calaveras | 9 | 2021-05-22 | 2151 | 55 | TRUE |
6350 | 6350 | Calaveras | Calaveras | 9 | 2021-05-21 | 2151 | 55 | |
6411 | 6411 | Calaveras | Calaveras | 9 | 2021-05-20 | 2150 | 55 | |
6472 | 6472 | Calaveras | Calaveras | 9 | 2021-05-19 | 2148 | 55 | |
6533 | 6533 | Calaveras | Calaveras | 9 | 2021-05-18 | 2145 | 55 | |
6594 | 6594 | Calaveras | Calaveras | 9 | 2021-05-17 | 2143 | 55 | |
6655 | 6655 | Calaveras | Calaveras | 9 | 2021-05-16 | 2136 | 54 | TRUE |
6716 | 6716 | Calaveras | Calaveras | 9 | 2021-05-15 | 2136 | 54 | TRUE |
6777 | 6777 | Calaveras | Calaveras | 9 | 2021-05-14 | 2136 | 54 | |
6838 | 6838 | Calaveras | Calaveras | 9 | 2021-05-13 | 2130 | 54 | |
6899 | 6899 | Calaveras | Calaveras | 9 | 2021-05-12 | 2129 | 54 | |
6960 | 6960 | Calaveras | Calaveras | 9 | 2021-05-11 | 2129 | 54 | |
7021 | 7021 | Calaveras | Calaveras | 9 | 2021-05-10 | 2125 | 53 | |
7082 | 7082 | Calaveras | Calaveras | 9 | 2021-05-09 | 2121 | 53 | TRUE |
7143 | 7143 | Calaveras | Calaveras | 9 | 2021-05-08 | 2121 | 53 | TRUE |
7204 | 7204 | Calaveras | Calaveras | 9 | 2021-05-07 | 2121 | 53 | |
7265 | 7265 | Calaveras | Calaveras | 9 | 2021-05-06 | 2116 | 53 | |
7326 | 7326 | Calaveras | Calaveras | 9 | 2021-05-05 | 2111 | 53 | |
7387 | 7387 | Calaveras | Calaveras | 9 | 2021-05-04 | 2108 | 53 | |
7448 | 7448 | Calaveras | Calaveras | 9 | 2021-05-03 | 2099 | 52 | |
7509 | 7509 | Calaveras | Calaveras | 9 | 2021-05-02 | 2095 | 52 | |
7570 | 7570 | Calaveras | Calaveras | 9 | 2021-05-01 | 2095 | 52 | TRUE |
7631 | 7631 | Calaveras | Calaveras | 9 | 2021-04-30 | 2095 | 52 | |
7692 | 7692 | Calaveras | Calaveras | 9 | 2021-04-29 | 2090 | 52 | |
7753 | 7753 | Calaveras | Calaveras | 9 | 2021-04-28 | 2086 | 52 | |
7814 | 7814 | Calaveras | Calaveras | 9 | 2021-04-27 | 2083 | 52 | |
7875 | 7875 | Calaveras | Calaveras | 9 | 2021-04-26 | 2075 | 52 | |
7936 | 7936 | Calaveras | Calaveras | 9 | 2021-04-25 | 2070 | 52 | |
7997 | 7997 | Calaveras | Calaveras | 9 | 2021-04-24 | 2070 | 52 | TRUE |
8058 | 8058 | Calaveras | Calaveras | 9 | 2021-04-23 | 2070 | 52 | |
8119 | 8119 | Calaveras | Calaveras | 9 | 2021-04-22 | 2066 | 52 | |
8180 | 8180 | Calaveras | Calaveras | 9 | 2021-04-21 | 2064 | 52 | |
8241 | 8241 | Calaveras | Calaveras | 9 | 2021-04-20 | 2062 | 52 | |
8302 | 8302 | Calaveras | Calaveras | 9 | 2021-04-19 | 2060 | 51 | |
8363 | 8363 | Calaveras | Calaveras | 9 | 2021-04-18 | 2055 | 51 | TRUE |
8424 | 8424 | Calaveras | Calaveras | 9 | 2021-04-17 | 2055 | 51 | TRUE |
8485 | 8485 | Calaveras | Calaveras | 9 | 2021-04-16 | 2055 | 51 | |
8546 | 8546 | Calaveras | Calaveras | 9 | 2021-04-15 | 2050 | 51 | |
8607 | 8607 | Calaveras | Calaveras | 9 | 2021-04-14 | 2048 | 51 | |
8668 | 8668 | Calaveras | Calaveras | 9 | 2021-04-13 | 2045 | 51 | |
8729 | 8729 | Calaveras | Calaveras | 9 | 2021-04-12 | 2041 | 51 | |
8790 | 8790 | Calaveras | Calaveras | 9 | 2021-04-11 | 2036 | 51 | TRUE |
8851 | 8851 | Calaveras | Calaveras | 9 | 2021-04-10 | 2036 | 51 | TRUE |
8912 | 8912 | Calaveras | Calaveras | 9 | 2021-04-09 | 2036 | 51 | |
8973 | 8973 | Calaveras | Calaveras | 9 | 2021-04-08 | 2033 | 51 | |
9034 | 9034 | Calaveras | Calaveras | 9 | 2021-04-07 | 2032 | 51 | |
9095 | 9095 | Calaveras | Calaveras | 9 | 2021-04-06 | 2029 | 51 | |
9156 | 9156 | Calaveras | Calaveras | 9 | 2021-04-05 | 2023 | 51 | |
9217 | 9217 | Calaveras | Calaveras | 9 | 2021-04-04 | 2018 | 51 | TRUE |
9278 | 9278 | Calaveras | Calaveras | 9 | 2021-04-03 | 2018 | 51 | TRUE |
9339 | 9339 | Calaveras | Calaveras | 9 | 2021-04-02 | 2018 | 51 | |
9400 | 9400 | Calaveras | Calaveras | 9 | 2021-04-01 | 2013 | 51 | |
9461 | 9461 | Calaveras | Calaveras | 9 | 2021-03-31 | 2011 | 51 | |
9522 | 9522 | Calaveras | Calaveras | 9 | 2021-03-30 | 2009 | 51 | |
9583 | 9583 | Calaveras | Calaveras | 9 | 2021-03-29 | 2006 | 51 | |
9644 | 9644 | Calaveras | Calaveras | 9 | 2021-03-28 | 1995 | 51 | TRUE |
9705 | 9705 | Calaveras | Calaveras | 9 | 2021-03-27 | 1995 | 51 | TRUE |
9766 | 9766 | Calaveras | Calaveras | 9 | 2021-03-26 | 1995 | 51 | |
9827 | 9827 | Calaveras | Calaveras | 9 | 2021-03-25 | 1991 | 51 | |
9888 | 9888 | Calaveras | Calaveras | 9 | 2021-03-24 | 1983 | 51 | |
9949 | 9949 | Calaveras | Calaveras | 9 | 2021-03-23 | 1979 | 51 | |
10010 | 10010 | Calaveras | Calaveras | 9 | 2021-03-22 | 1972 | 51 | |
10071 | 10071 | Calaveras | Calaveras | 9 | 2021-03-21 | 1968 | 50 | TRUE |
10132 | 10132 | Calaveras | Calaveras | 9 | 2021-03-20 | 1968 | 50 | TRUE |
10193 | 10193 | Calaveras | Calaveras | 9 | 2021-03-19 | 1968 | 50 | |
10254 | 10254 | Calaveras | Calaveras | 9 | 2021-03-18 | 1963 | 50 | |
10315 | 10315 | Calaveras | Calaveras | 9 | 2021-03-17 | 1958 | 50 | |
10376 | 10376 | Calaveras | Calaveras | 9 | 2021-03-16 | 1951 | 50 | |
10437 | 10437 | Calaveras | Calaveras | 9 | 2021-03-15 | 1946 | 50 | |
10498 | 10498 | Calaveras | Calaveras | 9 | 2021-03-14 | 1944 | 50 | TRUE |
10559 | 10559 | Calaveras | Calaveras | 9 | 2021-03-13 | 1944 | 50 | TRUE |
10620 | 10620 | Calaveras | Calaveras | 9 | 2021-03-12 | 1944 | 50 | |
10681 | 10681 | Calaveras | Calaveras | 9 | 2021-03-11 | 1941 | 50 | |
10742 | 10742 | Calaveras | Calaveras | 9 | 2021-03-10 | 1941 | 50 | |
10803 | 10803 | Calaveras | Calaveras | 9 | 2021-03-09 | 1934 | 49 | |
10864 | 10864 | Calaveras | Calaveras | 9 | 2021-03-08 | 1933 | 49 | |
10925 | 10925 | Calaveras | Calaveras | 9 | 2021-03-07 | 1928 | 49 | TRUE |
10986 | 10986 | Calaveras | Calaveras | 9 | 2021-03-06 | 1928 | 49 | TRUE |
11047 | 11047 | Calaveras | Calaveras | 9 | 2021-03-05 | 1928 | 49 | |
11108 | 11108 | Calaveras | Calaveras | 9 | 2021-03-04 | 1922 | 49 | |
11169 | 11169 | Calaveras | Calaveras | 9 | 2021-03-03 | 1918 | 49 | |
11230 | 11230 | Calaveras | Calaveras | 9 | 2021-03-02 | 1911 | 49 | |
11291 | 11291 | Calaveras | Calaveras | 9 | 2021-03-01 | 1910 | 49 | |
11352 | 11352 | Calaveras | Calaveras | 9 | 2021-02-28 | 1905 | 47 | TRUE |
11413 | 11413 | Calaveras | Calaveras | 9 | 2021-02-27 | 1905 | 47 | TRUE |
11474 | 11474 | Calaveras | Calaveras | 9 | 2021-02-26 | 1905 | 47 | |
11535 | 11535 | Calaveras | Calaveras | 9 | 2021-02-25 | 1905 | 47 | |
11596 | 11596 | Calaveras | Calaveras | 9 | 2021-02-24 | 1904 | 47 | |
11657 | 11657 | Calaveras | Calaveras | 9 | 2021-02-23 | 1902 | 25 | |
11718 | 11718 | Calaveras | Calaveras | 9 | 2021-02-22 | 1901 | 25 | |
11779 | 11779 | Calaveras | Calaveras | 9 | 2021-02-21 | 1898 | 25 | TRUE |
11840 | 11840 | Calaveras | Calaveras | 9 | 2021-02-20 | 1898 | 25 | TRUE |
11901 | 11901 | Calaveras | Calaveras | 9 | 2021-02-19 | 1898 | 25 | |
11962 | 11962 | Calaveras | Calaveras | 9 | 2021-02-18 | 1896 | 25 | |
12023 | 12023 | Calaveras | Calaveras | 9 | 2021-02-17 | 1896 | 25 | |
12084 | 12084 | Calaveras | Calaveras | 9 | 2021-02-16 | 1836 | 25 | |
12145 | 12145 | Calaveras | Calaveras | 9 | 2021-02-15 | 1825 | 25 | TRUE |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [latimes_agency_totals] ( [agency] TEXT, [county] TEXT, [fips] INTEGER, [date] TEXT, [confirmed_cases] INTEGER, [deaths] INTEGER, [did_not_update] TEXT );