latimes_agency_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_agency_totals
564 rows where agency = "Sacramento" sorted by did_not_update
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: did_not_update, date (date)
Link | rowid | agency | county | fips | date | confirmed_cases | deaths | did_not_update ▼ |
---|---|---|---|---|---|---|---|---|
37 | 37 | Sacramento | Sacramento | 67 | 2021-09-02 | 137854 | 1941 | |
98 | 98 | Sacramento | Sacramento | 67 | 2021-09-01 | 137232 | 1934 | |
159 | 159 | Sacramento | Sacramento | 67 | 2021-08-31 | 136617 | 1923 | |
220 | 220 | Sacramento | Sacramento | 67 | 2021-08-30 | 133480 | 1907 | |
403 | 403 | Sacramento | Sacramento | 67 | 2021-08-27 | 131011 | 1900 | |
464 | 464 | Sacramento | Sacramento | 67 | 2021-08-26 | 130125 | 1892 | |
525 | 525 | Sacramento | Sacramento | 67 | 2021-08-25 | 129292 | 1884 | |
586 | 586 | Sacramento | Sacramento | 67 | 2021-08-24 | 128853 | 1862 | |
647 | 647 | Sacramento | Sacramento | 67 | 2021-08-23 | 128340 | 1853 | |
830 | 830 | Sacramento | Sacramento | 67 | 2021-08-20 | 126643 | 1843 | |
891 | 891 | Sacramento | Sacramento | 67 | 2021-08-19 | 126002 | 1839 | |
952 | 952 | Sacramento | Sacramento | 67 | 2021-08-18 | 124985 | 1834 | |
1013 | 1013 | Sacramento | Sacramento | 67 | 2021-08-17 | 124604 | 1822 | |
1074 | 1074 | Sacramento | Sacramento | 67 | 2021-08-16 | 123853 | 1815 | |
1257 | 1257 | Sacramento | Sacramento | 67 | 2021-08-13 | 122403 | 1812 | |
1318 | 1318 | Sacramento | Sacramento | 67 | 2021-08-12 | 121797 | 1809 | |
1379 | 1379 | Sacramento | Sacramento | 67 | 2021-08-11 | 121258 | 1808 | |
1440 | 1440 | Sacramento | Sacramento | 67 | 2021-08-10 | 120837 | 1806 | |
1501 | 1501 | Sacramento | Sacramento | 67 | 2021-08-09 | 120417 | 1800 | |
1684 | 1684 | Sacramento | Sacramento | 67 | 2021-08-06 | 118928 | 1797 | |
1745 | 1745 | Sacramento | Sacramento | 67 | 2021-08-05 | 118507 | 1795 | |
1806 | 1806 | Sacramento | Sacramento | 67 | 2021-08-04 | 117831 | 1790 | |
1867 | 1867 | Sacramento | Sacramento | 67 | 2021-08-03 | 117543 | 1788 | |
1928 | 1928 | Sacramento | Sacramento | 67 | 2021-08-02 | 117126 | 1784 | |
2111 | 2111 | Sacramento | Sacramento | 67 | 2021-07-30 | 115732 | 1781 | |
2172 | 2172 | Sacramento | Sacramento | 67 | 2021-07-29 | 115200 | 1777 | |
2233 | 2233 | Sacramento | Sacramento | 67 | 2021-07-28 | 114652 | 1775 | |
2294 | 2294 | Sacramento | Sacramento | 67 | 2021-07-27 | 114415 | 1775 | |
2355 | 2355 | Sacramento | Sacramento | 67 | 2021-07-26 | 114082 | 1771 | |
2538 | 2538 | Sacramento | Sacramento | 67 | 2021-07-23 | 112896 | 1770 | |
2599 | 2599 | Sacramento | Sacramento | 67 | 2021-07-22 | 112501 | 1766 | |
2660 | 2660 | Sacramento | Sacramento | 67 | 2021-07-21 | 112144 | 1764 | |
2721 | 2721 | Sacramento | Sacramento | 67 | 2021-07-20 | 111884 | 1762 | |
2782 | 2782 | Sacramento | Sacramento | 67 | 2021-07-19 | 111553 | 1762 | |
2965 | 2965 | Sacramento | Sacramento | 67 | 2021-07-16 | 110903 | 1759 | |
3026 | 3026 | Sacramento | Sacramento | 67 | 2021-07-15 | 110781 | 1758 | |
3087 | 3087 | Sacramento | Sacramento | 67 | 2021-07-14 | 110639 | 1754 | |
3148 | 3148 | Sacramento | Sacramento | 67 | 2021-07-13 | 110435 | 1754 | |
3209 | 3209 | Sacramento | Sacramento | 67 | 2021-07-12 | 110264 | 1752 | |
3392 | 3392 | Sacramento | Sacramento | 67 | 2021-07-09 | 109719 | 1752 | |
3453 | 3453 | Sacramento | Sacramento | 67 | 2021-07-08 | 109517 | 1750 | |
3514 | 3514 | Sacramento | Sacramento | 67 | 2021-07-07 | 109393 | 1748 | |
3575 | 3575 | Sacramento | Sacramento | 67 | 2021-07-06 | 109268 | 1746 | |
3819 | 3819 | Sacramento | Sacramento | 67 | 2021-07-02 | 108828 | 1745 | |
3880 | 3880 | Sacramento | Sacramento | 67 | 2021-07-01 | 108688 | 1743 | |
3941 | 3941 | Sacramento | Sacramento | 67 | 2021-06-30 | 108571 | 1743 | |
4002 | 4002 | Sacramento | Sacramento | 67 | 2021-06-29 | 108505 | 1742 | |
4063 | 4063 | Sacramento | Sacramento | 67 | 2021-06-28 | 108411 | 1740 | |
4246 | 4246 | Sacramento | Sacramento | 67 | 2021-06-25 | 108085 | 1738 | |
4307 | 4307 | Sacramento | Sacramento | 67 | 2021-06-24 | 108013 | 1738 | |
4368 | 4368 | Sacramento | Sacramento | 67 | 2021-06-23 | 107913 | 1737 | |
4429 | 4429 | Sacramento | Sacramento | 67 | 2021-06-22 | 107872 | 1737 | |
4490 | 4490 | Sacramento | Sacramento | 67 | 2021-06-21 | 107821 | 1736 | |
4673 | 4673 | Sacramento | Sacramento | 67 | 2021-06-18 | 107638 | 1731 | |
4734 | 4734 | Sacramento | Sacramento | 67 | 2021-06-17 | 107560 | 1730 | |
4795 | 4795 | Sacramento | Sacramento | 67 | 2021-06-16 | 107494 | 1726 | |
4856 | 4856 | Sacramento | Sacramento | 67 | 2021-06-15 | 107441 | 1725 | |
4917 | 4917 | Sacramento | Sacramento | 67 | 2021-06-14 | 107395 | 1723 | |
5100 | 5100 | Sacramento | Sacramento | 67 | 2021-06-11 | 107186 | 1718 | |
5161 | 5161 | Sacramento | Sacramento | 67 | 2021-06-10 | 107117 | 1716 | |
5222 | 5222 | Sacramento | Sacramento | 67 | 2021-06-09 | 107103 | 1716 | |
5283 | 5283 | Sacramento | Sacramento | 67 | 2021-06-08 | 107030 | 1716 | |
5344 | 5344 | Sacramento | Sacramento | 67 | 2021-06-07 | 106961 | 1716 | |
5527 | 5527 | Sacramento | Sacramento | 67 | 2021-06-04 | 106714 | 1716 | |
5588 | 5588 | Sacramento | Sacramento | 67 | 2021-06-03 | 106635 | 1715 | |
5649 | 5649 | Sacramento | Sacramento | 67 | 2021-06-02 | 106570 | 1715 | |
5710 | 5710 | Sacramento | Sacramento | 67 | 2021-06-01 | 106473 | 1709 | |
5832 | 5832 | Sacramento | Sacramento | 67 | 2021-05-30 | 106265 | 1707 | |
5954 | 5954 | Sacramento | Sacramento | 67 | 2021-05-28 | 106265 | 1707 | |
6015 | 6015 | Sacramento | Sacramento | 67 | 2021-05-27 | 106153 | 1707 | |
6076 | 6076 | Sacramento | Sacramento | 67 | 2021-05-26 | 106043 | 1702 | |
6137 | 6137 | Sacramento | Sacramento | 67 | 2021-05-25 | 105963 | 1700 | |
6198 | 6198 | Sacramento | Sacramento | 67 | 2021-05-24 | 105845 | 1699 | |
6381 | 6381 | Sacramento | Sacramento | 67 | 2021-05-21 | 105604 | 1698 | |
6442 | 6442 | Sacramento | Sacramento | 67 | 2021-05-20 | 105540 | 1695 | |
6503 | 6503 | Sacramento | Sacramento | 67 | 2021-05-19 | 105374 | 1693 | |
6564 | 6564 | Sacramento | Sacramento | 67 | 2021-05-18 | 105234 | 1693 | |
6625 | 6625 | Sacramento | Sacramento | 67 | 2021-05-17 | 105164 | 1693 | |
6808 | 6808 | Sacramento | Sacramento | 67 | 2021-05-14 | 104958 | 1691 | |
6869 | 6869 | Sacramento | Sacramento | 67 | 2021-05-13 | 104840 | 1686 | |
6930 | 6930 | Sacramento | Sacramento | 67 | 2021-05-12 | 104720 | 1682 | |
6991 | 6991 | Sacramento | Sacramento | 67 | 2021-05-11 | 104610 | 1678 | |
7052 | 7052 | Sacramento | Sacramento | 67 | 2021-05-10 | 104491 | 1676 | |
7113 | 7113 | Sacramento | Sacramento | 67 | 2021-05-09 | 104176 | 1672 | |
7235 | 7235 | Sacramento | Sacramento | 67 | 2021-05-07 | 104176 | 1672 | |
7296 | 7296 | Sacramento | Sacramento | 67 | 2021-05-06 | 104058 | 1670 | |
7357 | 7357 | Sacramento | Sacramento | 67 | 2021-05-05 | 103595 | 1667 | |
7418 | 7418 | Sacramento | Sacramento | 67 | 2021-05-04 | 103498 | 1666 | |
7479 | 7479 | Sacramento | Sacramento | 67 | 2021-05-03 | 103386 | 1665 | |
7662 | 7662 | Sacramento | Sacramento | 67 | 2021-04-30 | 102959 | 1663 | |
7723 | 7723 | Sacramento | Sacramento | 67 | 2021-04-29 | 102793 | 1663 | |
7784 | 7784 | Sacramento | Sacramento | 67 | 2021-04-28 | 102683 | 1662 | |
7845 | 7845 | Sacramento | Sacramento | 67 | 2021-04-27 | 102614 | 1659 | |
7906 | 7906 | Sacramento | Sacramento | 67 | 2021-04-26 | 102486 | 1657 | |
8089 | 8089 | Sacramento | Sacramento | 67 | 2021-04-23 | 102071 | 1654 | |
8150 | 8150 | Sacramento | Sacramento | 67 | 2021-04-22 | 101906 | 1653 | |
8211 | 8211 | Sacramento | Sacramento | 67 | 2021-04-21 | 101787 | 1651 | |
8272 | 8272 | Sacramento | Sacramento | 67 | 2021-04-20 | 101665 | 1647 | |
8333 | 8333 | Sacramento | Sacramento | 67 | 2021-04-19 | 101511 | 1646 | |
8516 | 8516 | Sacramento | Sacramento | 67 | 2021-04-16 | 101058 | 1646 |
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 );