latimes_county_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_county_totals
586 rows where fips = 85 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 1
- 85 · 486 ✖
county 1
- Santa Clara 486
Link | rowid | date ▲ | county | fips | confirmed_cases | deaths | new_confirmed_cases | new_deaths |
---|---|---|---|---|---|---|---|---|
5843 | 5843 | 2021-05-25 | Santa Clara | 85 | 118253 | 1689 | 32 | 0 |
5901 | 5901 | 2021-05-24 | Santa Clara | 85 | 118221 | 1689 | 24 | 0 |
5959 | 5959 | 2021-05-23 | Santa Clara | 85 | 118197 | 1689 | 17 | 0 |
6017 | 6017 | 2021-05-22 | Santa Clara | 85 | 118180 | 1689 | 28 | 1 |
6075 | 6075 | 2021-05-21 | Santa Clara | 85 | 118152 | 1688 | 20 | 0 |
6133 | 6133 | 2021-05-20 | Santa Clara | 85 | 118132 | 1688 | 46 | 0 |
6191 | 6191 | 2021-05-19 | Santa Clara | 85 | 118086 | 1688 | 27 | 0 |
6249 | 6249 | 2021-05-18 | Santa Clara | 85 | 118059 | 1688 | 40 | 0 |
6307 | 6307 | 2021-05-17 | Santa Clara | 85 | 118019 | 1688 | 28 | 0 |
6365 | 6365 | 2021-05-16 | Santa Clara | 85 | 117991 | 1688 | 28 | 1 |
6423 | 6423 | 2021-05-15 | Santa Clara | 85 | 117963 | 1687 | 23 | 0 |
6481 | 6481 | 2021-05-14 | Santa Clara | 85 | 117940 | 1687 | 44 | 1 |
6539 | 6539 | 2021-05-13 | Santa Clara | 85 | 117896 | 1686 | 58 | 0 |
6597 | 6597 | 2021-05-12 | Santa Clara | 85 | 117838 | 1686 | 51 | 0 |
6655 | 6655 | 2021-05-11 | Santa Clara | 85 | 117787 | 1686 | 70 | 0 |
6713 | 6713 | 2021-05-10 | Santa Clara | 85 | 117717 | 1686 | 41 | 0 |
6771 | 6771 | 2021-05-09 | Santa Clara | 85 | 117676 | 1686 | 27 | 0 |
6829 | 6829 | 2021-05-08 | Santa Clara | 85 | 117649 | 1686 | 26 | 1 |
6887 | 6887 | 2021-05-07 | Santa Clara | 85 | 117623 | 1685 | 53 | 2 |
6945 | 6945 | 2021-05-06 | Santa Clara | 85 | 117570 | 1683 | 45 | 1 |
7003 | 7003 | 2021-05-05 | Santa Clara | 85 | 117525 | 1682 | 70 | 1 |
7061 | 7061 | 2021-05-04 | Santa Clara | 85 | 117455 | 1681 | 85 | 1 |
7119 | 7119 | 2021-05-03 | Santa Clara | 85 | 117370 | 1680 | 72 | 0 |
7177 | 7177 | 2021-05-02 | Santa Clara | 85 | 117298 | 1680 | 48 | 0 |
7235 | 7235 | 2021-05-01 | Santa Clara | 85 | 117250 | 1680 | 48 | 0 |
7293 | 7293 | 2021-04-30 | Santa Clara | 85 | 117202 | 1680 | 65 | 3 |
7351 | 7351 | 2021-04-29 | Santa Clara | 85 | 117137 | 1677 | 82 | 1 |
7409 | 7409 | 2021-04-28 | Santa Clara | 85 | 117055 | 1676 | 62 | 0 |
7467 | 7467 | 2021-04-27 | Santa Clara | 85 | 116993 | 1676 | 107 | 0 |
7525 | 7525 | 2021-04-26 | Santa Clara | 85 | 116886 | 1676 | 75 | 2 |
7583 | 7583 | 2021-04-25 | Santa Clara | 85 | 116811 | 1674 | 51 | 0 |
7641 | 7641 | 2021-04-24 | Santa Clara | 85 | 116760 | 1674 | 62 | 0 |
7699 | 7699 | 2021-04-23 | Santa Clara | 85 | 116698 | 1674 | 95 | 1 |
7757 | 7757 | 2021-04-22 | Santa Clara | 85 | 116603 | 1673 | 79 | 0 |
7815 | 7815 | 2021-04-21 | Santa Clara | 85 | 116524 | 1673 | 122 | 1 |
7873 | 7873 | 2021-04-20 | Santa Clara | 85 | 116402 | 1672 | 124 | 0 |
7931 | 7931 | 2021-04-19 | Santa Clara | 85 | 116278 | 1672 | 134 | 0 |
7989 | 7989 | 2021-04-18 | Santa Clara | 85 | 116144 | 1672 | 80 | 1 |
8047 | 8047 | 2021-04-17 | Santa Clara | 85 | 116064 | 1671 | 94 | 1 |
8105 | 8105 | 2021-04-16 | Santa Clara | 85 | 115970 | 1670 | 115 | 1 |
8163 | 8163 | 2021-04-15 | Santa Clara | 85 | 115855 | 1669 | 141 | 0 |
8221 | 8221 | 2021-04-14 | Santa Clara | 85 | 115714 | 1669 | 149 | 0 |
8279 | 8279 | 2021-04-13 | Santa Clara | 85 | 115565 | 1669 | 120 | 0 |
8337 | 8337 | 2021-04-12 | Santa Clara | 85 | 115445 | 1669 | 143 | 1 |
8395 | 8395 | 2021-04-11 | Santa Clara | 85 | 115302 | 1668 | 65 | 1 |
8453 | 8453 | 2021-04-10 | Santa Clara | 85 | 115237 | 1667 | 100 | 0 |
8511 | 8511 | 2021-04-09 | Santa Clara | 85 | 115137 | 1667 | 132 | 2 |
8569 | 8569 | 2021-04-08 | Santa Clara | 85 | 115005 | 1665 | 159 | 2 |
8627 | 8627 | 2021-04-07 | Santa Clara | 85 | 114846 | 1663 | 170 | 1 |
8685 | 8685 | 2021-04-06 | Santa Clara | 85 | 114676 | 1662 | 167 | 1 |
8743 | 8743 | 2021-04-05 | Santa Clara | 85 | 114509 | 1661 | 197 | 1 |
8801 | 8801 | 2021-04-04 | Santa Clara | 85 | 114312 | 1660 | 58 | 5 |
8859 | 8859 | 2021-04-03 | Santa Clara | 85 | 114254 | 1655 | 72 | 2 |
8917 | 8917 | 2021-04-02 | Santa Clara | 85 | 114182 | 1653 | 103 | 0 |
8975 | 8975 | 2021-04-01 | Santa Clara | 85 | 114079 | 1653 | 124 | 0 |
9033 | 9033 | 2021-03-31 | Santa Clara | 85 | 113955 | 1653 | 144 | 0 |
9091 | 9091 | 2021-03-30 | Santa Clara | 85 | 113811 | 1653 | 92 | 2 |
9149 | 9149 | 2021-03-29 | Santa Clara | 85 | 113719 | 1651 | 116 | 2 |
9207 | 9207 | 2021-03-28 | Santa Clara | 85 | 113603 | 1649 | 66 | 1 |
9265 | 9265 | 2021-03-27 | Santa Clara | 85 | 113537 | 1648 | 67 | 0 |
9323 | 9323 | 2021-03-26 | Santa Clara | 85 | 113470 | 1648 | 127 | 1 |
9381 | 9381 | 2021-03-25 | Santa Clara | 85 | 113343 | 1647 | 134 | 3 |
9439 | 9439 | 2021-03-24 | Santa Clara | 85 | 113209 | 1644 | 125 | 1 |
9497 | 9497 | 2021-03-23 | Santa Clara | 85 | 113084 | 1643 | 119 | 2 |
9555 | 9555 | 2021-03-22 | Santa Clara | 85 | 112965 | 1641 | 112 | 3 |
9613 | 9613 | 2021-03-21 | Santa Clara | 85 | 112853 | 1638 | 75 | 1 |
9671 | 9671 | 2021-03-20 | Santa Clara | 85 | 112778 | 1637 | 67 | 1 |
9729 | 9729 | 2021-03-19 | Santa Clara | 85 | 112711 | 1636 | 114 | 2 |
9787 | 9787 | 2021-03-18 | Santa Clara | 85 | 112597 | 1634 | 107 | 3 |
9845 | 9845 | 2021-03-17 | Santa Clara | 85 | 112490 | 1631 | 152 | 2 |
9903 | 9903 | 2021-03-16 | Santa Clara | 85 | 112338 | 1629 | 117 | 0 |
9961 | 9961 | 2021-03-15 | Santa Clara | 85 | 112221 | 1629 | 136 | 1 |
10019 | 10019 | 2021-03-14 | Santa Clara | 85 | 112085 | 1628 | 66 | 1 |
10077 | 10077 | 2021-03-13 | Santa Clara | 85 | 112019 | 1627 | 95 | 1 |
10135 | 10135 | 2021-03-12 | Santa Clara | 85 | 111924 | 1626 | 113 | 4 |
10193 | 10193 | 2021-03-11 | Santa Clara | 85 | 111811 | 1622 | 120 | 4 |
10251 | 10251 | 2021-03-10 | Santa Clara | 85 | 111691 | 1618 | 135 | 4 |
10309 | 10309 | 2021-03-09 | Santa Clara | 85 | 111556 | 1614 | 151 | 3 |
10367 | 10367 | 2021-03-08 | Santa Clara | 85 | 111405 | 1611 | 168 | 3 |
10425 | 10425 | 2021-03-07 | Santa Clara | 85 | 111237 | 1608 | 78 | 1 |
10483 | 10483 | 2021-03-06 | Santa Clara | 85 | 111159 | 1607 | 87 | 2 |
10541 | 10541 | 2021-03-05 | Santa Clara | 85 | 111072 | 1605 | 154 | 4 |
10599 | 10599 | 2021-03-04 | Santa Clara | 85 | 110918 | 1601 | 163 | 3 |
10657 | 10657 | 2021-03-03 | Santa Clara | 85 | 110755 | 1598 | 194 | 1 |
10715 | 10715 | 2021-03-02 | Santa Clara | 85 | 110561 | 1597 | 182 | 2 |
10773 | 10773 | 2021-03-01 | Santa Clara | 85 | 110379 | 1595 | 203 | 4 |
10831 | 10831 | 2021-02-28 | Santa Clara | 85 | 110176 | 1591 | 123 | 2 |
10889 | 10889 | 2021-02-27 | Santa Clara | 85 | 110053 | 1589 | 134 | 4 |
10947 | 10947 | 2021-02-26 | Santa Clara | 85 | 109919 | 1585 | 157 | 8 |
11005 | 11005 | 2021-02-25 | Santa Clara | 85 | 109762 | 1577 | 165 | 3 |
11063 | 11063 | 2021-02-24 | Santa Clara | 85 | 109597 | 1574 | 260 | 2 |
11121 | 11121 | 2021-02-23 | Santa Clara | 85 | 109337 | 1572 | 218 | 6 |
11179 | 11179 | 2021-02-22 | Santa Clara | 85 | 109119 | 1566 | 263 | 4 |
11237 | 11237 | 2021-02-21 | Santa Clara | 85 | 108856 | 1562 | 165 | 5 |
11295 | 11295 | 2021-02-20 | Santa Clara | 85 | 108691 | 1557 | 175 | 7 |
11353 | 11353 | 2021-02-19 | Santa Clara | 85 | 108516 | 1550 | 232 | 5 |
11411 | 11411 | 2021-02-18 | Santa Clara | 85 | 108284 | 1545 | 272 | 5 |
11469 | 11469 | 2021-02-17 | Santa Clara | 85 | 108012 | 1540 | 264 | 9 |
11527 | 11527 | 2021-02-16 | Santa Clara | 85 | 107748 | 1531 | 241 | 4 |
11585 | 11585 | 2021-02-15 | Santa Clara | 85 | 107507 | 1527 | 187 | 8 |
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 );