latimes_agency_totals

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

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 date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: did_not_update, date (date)

fips 1

county 1

agency 1

  • Sacramento · 564 ✖
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  
281 281 Sacramento Sacramento 67 2021-08-29 131011 1900 TRUE
342 342 Sacramento Sacramento 67 2021-08-28 131011 1900 TRUE
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  
708 708 Sacramento Sacramento 67 2021-08-22 126643 1843 TRUE
769 769 Sacramento Sacramento 67 2021-08-21 126643 1843 TRUE
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  
1135 1135 Sacramento Sacramento 67 2021-08-15 122403 1812 TRUE
1196 1196 Sacramento Sacramento 67 2021-08-14 122403 1812 TRUE
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  
1562 1562 Sacramento Sacramento 67 2021-08-08 118928 1797 TRUE
1623 1623 Sacramento Sacramento 67 2021-08-07 118928 1797 TRUE
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  
1989 1989 Sacramento Sacramento 67 2021-08-01 115732 1781 TRUE
2050 2050 Sacramento Sacramento 67 2021-07-31 115732 1781 TRUE
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  
2416 2416 Sacramento Sacramento 67 2021-07-25 112896 1770 TRUE
2477 2477 Sacramento Sacramento 67 2021-07-24 112896 1770 TRUE
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  
2843 2843 Sacramento Sacramento 67 2021-07-18 110903 1759 TRUE
2904 2904 Sacramento Sacramento 67 2021-07-17 110903 1759 TRUE
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  
3270 3270 Sacramento Sacramento 67 2021-07-11 109719 1752 TRUE
3331 3331 Sacramento Sacramento 67 2021-07-10 109719 1752 TRUE
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  
3636 3636 Sacramento Sacramento 67 2021-07-05 108828 1745 TRUE
3697 3697 Sacramento Sacramento 67 2021-07-04 108828 1745 TRUE
3758 3758 Sacramento Sacramento 67 2021-07-03 108828 1745 TRUE
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  
4124 4124 Sacramento Sacramento 67 2021-06-27 108085 1738 TRUE
4185 4185 Sacramento Sacramento 67 2021-06-26 108085 1738 TRUE
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  
4551 4551 Sacramento Sacramento 67 2021-06-20 107638 1731 TRUE
4612 4612 Sacramento Sacramento 67 2021-06-19 107638 1731 TRUE
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  
4978 4978 Sacramento Sacramento 67 2021-06-13 107186 1718 TRUE
5039 5039 Sacramento Sacramento 67 2021-06-12 107186 1718 TRUE
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  
5405 5405 Sacramento Sacramento 67 2021-06-06 106714 1716 TRUE
5466 5466 Sacramento Sacramento 67 2021-06-05 106714 1716 TRUE
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  
5771 5771 Sacramento Sacramento 67 2021-05-31 106265 1707 TRUE
5832 5832 Sacramento Sacramento 67 2021-05-30 106265 1707  
5893 5893 Sacramento Sacramento 67 2021-05-29 106265 1707 TRUE
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  

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [latimes_agency_totals] (
   [agency] TEXT,
   [county] TEXT,
   [fips] INTEGER,
   [date] TEXT,
   [confirmed_cases] INTEGER,
   [deaths] INTEGER,
   [did_not_update] TEXT
);