latimes_agency_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_agency_totals
586 rows where agency = "Santa Clara" 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 |
---|---|---|---|---|---|---|---|---|
6146 | 6146 | Santa Clara | Santa Clara | 85 | 2021-05-25 | 118253 | 1689 | |
6207 | 6207 | Santa Clara | Santa Clara | 85 | 2021-05-24 | 118221 | 1689 | |
6268 | 6268 | Santa Clara | Santa Clara | 85 | 2021-05-23 | 118197 | 1689 | |
6329 | 6329 | Santa Clara | Santa Clara | 85 | 2021-05-22 | 118180 | 1689 | |
6390 | 6390 | Santa Clara | Santa Clara | 85 | 2021-05-21 | 118152 | 1688 | |
6451 | 6451 | Santa Clara | Santa Clara | 85 | 2021-05-20 | 118132 | 1688 | |
6512 | 6512 | Santa Clara | Santa Clara | 85 | 2021-05-19 | 118086 | 1688 | |
6573 | 6573 | Santa Clara | Santa Clara | 85 | 2021-05-18 | 118059 | 1688 | |
6634 | 6634 | Santa Clara | Santa Clara | 85 | 2021-05-17 | 118019 | 1688 | |
6695 | 6695 | Santa Clara | Santa Clara | 85 | 2021-05-16 | 117991 | 1688 | |
6756 | 6756 | Santa Clara | Santa Clara | 85 | 2021-05-15 | 117963 | 1687 | |
6817 | 6817 | Santa Clara | Santa Clara | 85 | 2021-05-14 | 117940 | 1687 | |
6878 | 6878 | Santa Clara | Santa Clara | 85 | 2021-05-13 | 117896 | 1686 | |
6939 | 6939 | Santa Clara | Santa Clara | 85 | 2021-05-12 | 117838 | 1686 | |
7000 | 7000 | Santa Clara | Santa Clara | 85 | 2021-05-11 | 117787 | 1686 | |
7061 | 7061 | Santa Clara | Santa Clara | 85 | 2021-05-10 | 117717 | 1686 | |
7122 | 7122 | Santa Clara | Santa Clara | 85 | 2021-05-09 | 117676 | 1686 | |
7183 | 7183 | Santa Clara | Santa Clara | 85 | 2021-05-08 | 117649 | 1686 | |
7244 | 7244 | Santa Clara | Santa Clara | 85 | 2021-05-07 | 117623 | 1685 | |
7305 | 7305 | Santa Clara | Santa Clara | 85 | 2021-05-06 | 117570 | 1683 | |
7366 | 7366 | Santa Clara | Santa Clara | 85 | 2021-05-05 | 117525 | 1682 | |
7427 | 7427 | Santa Clara | Santa Clara | 85 | 2021-05-04 | 117455 | 1681 | |
7488 | 7488 | Santa Clara | Santa Clara | 85 | 2021-05-03 | 117370 | 1680 | |
7549 | 7549 | Santa Clara | Santa Clara | 85 | 2021-05-02 | 117298 | 1680 | |
7610 | 7610 | Santa Clara | Santa Clara | 85 | 2021-05-01 | 117250 | 1680 | |
7671 | 7671 | Santa Clara | Santa Clara | 85 | 2021-04-30 | 117202 | 1680 | |
7732 | 7732 | Santa Clara | Santa Clara | 85 | 2021-04-29 | 117137 | 1677 | |
7793 | 7793 | Santa Clara | Santa Clara | 85 | 2021-04-28 | 117055 | 1676 | |
7854 | 7854 | Santa Clara | Santa Clara | 85 | 2021-04-27 | 116993 | 1676 | |
7915 | 7915 | Santa Clara | Santa Clara | 85 | 2021-04-26 | 116886 | 1676 | |
7976 | 7976 | Santa Clara | Santa Clara | 85 | 2021-04-25 | 116811 | 1674 | |
8037 | 8037 | Santa Clara | Santa Clara | 85 | 2021-04-24 | 116760 | 1674 | |
8098 | 8098 | Santa Clara | Santa Clara | 85 | 2021-04-23 | 116698 | 1674 | |
8159 | 8159 | Santa Clara | Santa Clara | 85 | 2021-04-22 | 116603 | 1673 | |
8220 | 8220 | Santa Clara | Santa Clara | 85 | 2021-04-21 | 116524 | 1673 | |
8281 | 8281 | Santa Clara | Santa Clara | 85 | 2021-04-20 | 116402 | 1672 | |
8342 | 8342 | Santa Clara | Santa Clara | 85 | 2021-04-19 | 116278 | 1672 | |
8403 | 8403 | Santa Clara | Santa Clara | 85 | 2021-04-18 | 116144 | 1672 | |
8464 | 8464 | Santa Clara | Santa Clara | 85 | 2021-04-17 | 116064 | 1671 | |
8525 | 8525 | Santa Clara | Santa Clara | 85 | 2021-04-16 | 115970 | 1670 | |
8586 | 8586 | Santa Clara | Santa Clara | 85 | 2021-04-15 | 115855 | 1669 | |
8647 | 8647 | Santa Clara | Santa Clara | 85 | 2021-04-14 | 115714 | 1669 | |
8708 | 8708 | Santa Clara | Santa Clara | 85 | 2021-04-13 | 115565 | 1669 | |
8769 | 8769 | Santa Clara | Santa Clara | 85 | 2021-04-12 | 115445 | 1669 | |
8830 | 8830 | Santa Clara | Santa Clara | 85 | 2021-04-11 | 115302 | 1668 | |
8891 | 8891 | Santa Clara | Santa Clara | 85 | 2021-04-10 | 115237 | 1667 | |
8952 | 8952 | Santa Clara | Santa Clara | 85 | 2021-04-09 | 115137 | 1667 | |
9013 | 9013 | Santa Clara | Santa Clara | 85 | 2021-04-08 | 115005 | 1665 | |
9074 | 9074 | Santa Clara | Santa Clara | 85 | 2021-04-07 | 114846 | 1663 | |
9135 | 9135 | Santa Clara | Santa Clara | 85 | 2021-04-06 | 114676 | 1662 | |
9196 | 9196 | Santa Clara | Santa Clara | 85 | 2021-04-05 | 114509 | 1661 | |
9257 | 9257 | Santa Clara | Santa Clara | 85 | 2021-04-04 | 114312 | 1660 | |
9318 | 9318 | Santa Clara | Santa Clara | 85 | 2021-04-03 | 114254 | 1655 | |
9379 | 9379 | Santa Clara | Santa Clara | 85 | 2021-04-02 | 114182 | 1653 | |
9440 | 9440 | Santa Clara | Santa Clara | 85 | 2021-04-01 | 114079 | 1653 | |
9501 | 9501 | Santa Clara | Santa Clara | 85 | 2021-03-31 | 113955 | 1653 | |
9562 | 9562 | Santa Clara | Santa Clara | 85 | 2021-03-30 | 113811 | 1653 | |
9623 | 9623 | Santa Clara | Santa Clara | 85 | 2021-03-29 | 113719 | 1651 | |
9684 | 9684 | Santa Clara | Santa Clara | 85 | 2021-03-28 | 113603 | 1649 | |
9745 | 9745 | Santa Clara | Santa Clara | 85 | 2021-03-27 | 113537 | 1648 | |
9806 | 9806 | Santa Clara | Santa Clara | 85 | 2021-03-26 | 113470 | 1648 | |
9867 | 9867 | Santa Clara | Santa Clara | 85 | 2021-03-25 | 113343 | 1647 | |
9928 | 9928 | Santa Clara | Santa Clara | 85 | 2021-03-24 | 113209 | 1644 | |
9989 | 9989 | Santa Clara | Santa Clara | 85 | 2021-03-23 | 113084 | 1643 | |
10050 | 10050 | Santa Clara | Santa Clara | 85 | 2021-03-22 | 112965 | 1641 | |
10111 | 10111 | Santa Clara | Santa Clara | 85 | 2021-03-21 | 112853 | 1638 | |
10172 | 10172 | Santa Clara | Santa Clara | 85 | 2021-03-20 | 112778 | 1637 | |
10233 | 10233 | Santa Clara | Santa Clara | 85 | 2021-03-19 | 112711 | 1636 | |
10294 | 10294 | Santa Clara | Santa Clara | 85 | 2021-03-18 | 112597 | 1634 | |
10355 | 10355 | Santa Clara | Santa Clara | 85 | 2021-03-17 | 112490 | 1631 | |
10416 | 10416 | Santa Clara | Santa Clara | 85 | 2021-03-16 | 112338 | 1629 | |
10477 | 10477 | Santa Clara | Santa Clara | 85 | 2021-03-15 | 112221 | 1629 | |
10538 | 10538 | Santa Clara | Santa Clara | 85 | 2021-03-14 | 112085 | 1628 | |
10599 | 10599 | Santa Clara | Santa Clara | 85 | 2021-03-13 | 112019 | 1627 | |
10660 | 10660 | Santa Clara | Santa Clara | 85 | 2021-03-12 | 111924 | 1626 | |
10721 | 10721 | Santa Clara | Santa Clara | 85 | 2021-03-11 | 111811 | 1622 | |
10782 | 10782 | Santa Clara | Santa Clara | 85 | 2021-03-10 | 111691 | 1618 | |
10843 | 10843 | Santa Clara | Santa Clara | 85 | 2021-03-09 | 111556 | 1614 | |
10904 | 10904 | Santa Clara | Santa Clara | 85 | 2021-03-08 | 111405 | 1611 | |
10965 | 10965 | Santa Clara | Santa Clara | 85 | 2021-03-07 | 111237 | 1608 | |
11026 | 11026 | Santa Clara | Santa Clara | 85 | 2021-03-06 | 111159 | 1607 | |
11087 | 11087 | Santa Clara | Santa Clara | 85 | 2021-03-05 | 111072 | 1605 | |
11148 | 11148 | Santa Clara | Santa Clara | 85 | 2021-03-04 | 110918 | 1601 | |
11209 | 11209 | Santa Clara | Santa Clara | 85 | 2021-03-03 | 110755 | 1598 | |
11270 | 11270 | Santa Clara | Santa Clara | 85 | 2021-03-02 | 110561 | 1597 | |
11331 | 11331 | Santa Clara | Santa Clara | 85 | 2021-03-01 | 110379 | 1595 | |
11392 | 11392 | Santa Clara | Santa Clara | 85 | 2021-02-28 | 110176 | 1591 | |
11453 | 11453 | Santa Clara | Santa Clara | 85 | 2021-02-27 | 110053 | 1589 | |
11514 | 11514 | Santa Clara | Santa Clara | 85 | 2021-02-26 | 109919 | 1585 | |
11575 | 11575 | Santa Clara | Santa Clara | 85 | 2021-02-25 | 109762 | 1577 | |
11636 | 11636 | Santa Clara | Santa Clara | 85 | 2021-02-24 | 109597 | 1574 | TRUE |
11697 | 11697 | Santa Clara | Santa Clara | 85 | 2021-02-23 | 109337 | 1572 | |
11758 | 11758 | Santa Clara | Santa Clara | 85 | 2021-02-22 | 109119 | 1566 | |
11819 | 11819 | Santa Clara | Santa Clara | 85 | 2021-02-21 | 108856 | 1562 | |
11880 | 11880 | Santa Clara | Santa Clara | 85 | 2021-02-20 | 108691 | 1557 | |
11941 | 11941 | Santa Clara | Santa Clara | 85 | 2021-02-19 | 108516 | 1550 | |
12002 | 12002 | Santa Clara | Santa Clara | 85 | 2021-02-18 | 108284 | 1545 | |
12063 | 12063 | Santa Clara | Santa Clara | 85 | 2021-02-17 | 108012 | 1540 | |
12124 | 12124 | Santa Clara | Santa Clara | 85 | 2021-02-16 | 107748 | 1531 | |
12185 | 12185 | Santa Clara | Santa Clara | 85 | 2021-02-15 | 107507 | 1527 |
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 );