latimes_county_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_county_totals

564 rows where county = "Sacramento" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

fips 1

county 1

  • Sacramento · 564 ✖
Link rowid date ▲ county fips confirmed_cases deaths new_confirmed_cases new_deaths
34 34 2021-09-02 Sacramento 67 137854 1941 622 7
92 92 2021-09-01 Sacramento 67 137232 1934 615 11
150 150 2021-08-31 Sacramento 67 136617 1923 3137 16
208 208 2021-08-30 Sacramento 67 133480 1907 2469 7
266 266 2021-08-29 Sacramento 67 131011 1900 0 0
324 324 2021-08-28 Sacramento 67 131011 1900 0 0
382 382 2021-08-27 Sacramento 67 131011 1900 886 8
440 440 2021-08-26 Sacramento 67 130125 1892 833 8
498 498 2021-08-25 Sacramento 67 129292 1884 439 22
556 556 2021-08-24 Sacramento 67 128853 1862 513 9
614 614 2021-08-23 Sacramento 67 128340 1853 1697 10
672 672 2021-08-22 Sacramento 67 126643 1843 0 0
730 730 2021-08-21 Sacramento 67 126643 1843 0 0
788 788 2021-08-20 Sacramento 67 126643 1843 641 4
846 846 2021-08-19 Sacramento 67 126002 1839 1017 5
904 904 2021-08-18 Sacramento 67 124985 1834 381 12
962 962 2021-08-17 Sacramento 67 124604 1822 751 7
1020 1020 2021-08-16 Sacramento 67 123853 1815 1450 3
1078 1078 2021-08-15 Sacramento 67 122403 1812 0 0
1136 1136 2021-08-14 Sacramento 67 122403 1812 0 0
1194 1194 2021-08-13 Sacramento 67 122403 1812 606 3
1252 1252 2021-08-12 Sacramento 67 121797 1809 539 1
1310 1310 2021-08-11 Sacramento 67 121258 1808 421 2
1368 1368 2021-08-10 Sacramento 67 120837 1806 420 6
1426 1426 2021-08-09 Sacramento 67 120417 1800 1489 3
1484 1484 2021-08-08 Sacramento 67 118928 1797 0 0
1542 1542 2021-08-07 Sacramento 67 118928 1797 0 0
1600 1600 2021-08-06 Sacramento 67 118928 1797 421 2
1658 1658 2021-08-05 Sacramento 67 118507 1795 676 5
1716 1716 2021-08-04 Sacramento 67 117831 1790 288 2
1774 1774 2021-08-03 Sacramento 67 117543 1788 417 4
1832 1832 2021-08-02 Sacramento 67 117126 1784 1394 3
1890 1890 2021-08-01 Sacramento 67 115732 1781 0 0
1948 1948 2021-07-31 Sacramento 67 115732 1781 0 0
2006 2006 2021-07-30 Sacramento 67 115732 1781 532 4
2064 2064 2021-07-29 Sacramento 67 115200 1777 548 2
2122 2122 2021-07-28 Sacramento 67 114652 1775 237 0
2180 2180 2021-07-27 Sacramento 67 114415 1775 333 4
2238 2238 2021-07-26 Sacramento 67 114082 1771 1186 1
2296 2296 2021-07-25 Sacramento 67 112896 1770 0 0
2354 2354 2021-07-24 Sacramento 67 112896 1770 0 0
2412 2412 2021-07-23 Sacramento 67 112896 1770 395 4
2470 2470 2021-07-22 Sacramento 67 112501 1766 357 2
2528 2528 2021-07-21 Sacramento 67 112144 1764 260 2
2586 2586 2021-07-20 Sacramento 67 111884 1762 331 0
2644 2644 2021-07-19 Sacramento 67 111553 1762 650 3
2702 2702 2021-07-18 Sacramento 67 110903 1759 0 0
2760 2760 2021-07-17 Sacramento 67 110903 1759 0 0
2818 2818 2021-07-16 Sacramento 67 110903 1759 122 1
2876 2876 2021-07-15 Sacramento 67 110781 1758 142 4
2934 2934 2021-07-14 Sacramento 67 110639 1754 204 0
2992 2992 2021-07-13 Sacramento 67 110435 1754 171 2
3050 3050 2021-07-12 Sacramento 67 110264 1752 545 0
3108 3108 2021-07-11 Sacramento 67 109719 1752 0 0
3166 3166 2021-07-10 Sacramento 67 109719 1752 0 0
3224 3224 2021-07-09 Sacramento 67 109719 1752 202 2
3282 3282 2021-07-08 Sacramento 67 109517 1750 124 2
3340 3340 2021-07-07 Sacramento 67 109393 1748 125 2
3398 3398 2021-07-06 Sacramento 67 109268 1746 440 1
3456 3456 2021-07-05 Sacramento 67 108828 1745 0 0
3514 3514 2021-07-04 Sacramento 67 108828 1745 0 0
3572 3572 2021-07-03 Sacramento 67 108828 1745 0 0
3630 3630 2021-07-02 Sacramento 67 108828 1745 140 2
3688 3688 2021-07-01 Sacramento 67 108688 1743 117 0
3746 3746 2021-06-30 Sacramento 67 108571 1743 66 1
3804 3804 2021-06-29 Sacramento 67 108505 1742 94 2
3862 3862 2021-06-28 Sacramento 67 108411 1740 326 2
3920 3920 2021-06-27 Sacramento 67 108085 1738 0 0
3978 3978 2021-06-26 Sacramento 67 108085 1738 0 0
4036 4036 2021-06-25 Sacramento 67 108085 1738 72 0
4094 4094 2021-06-24 Sacramento 67 108013 1738 100 1
4152 4152 2021-06-23 Sacramento 67 107913 1737 41 0
4210 4210 2021-06-22 Sacramento 67 107872 1737 51 1
4268 4268 2021-06-21 Sacramento 67 107821 1736 183 5
4326 4326 2021-06-20 Sacramento 67 107638 1731 0 0
4384 4384 2021-06-19 Sacramento 67 107638 1731 0 0
4442 4442 2021-06-18 Sacramento 67 107638 1731 78 1
4500 4500 2021-06-17 Sacramento 67 107560 1730 66 4
4558 4558 2021-06-16 Sacramento 67 107494 1726 53 1
4616 4616 2021-06-15 Sacramento 67 107441 1725 46 2
4674 4674 2021-06-14 Sacramento 67 107395 1723 209 5
4732 4732 2021-06-13 Sacramento 67 107186 1718 0 0
4790 4790 2021-06-12 Sacramento 67 107186 1718 0 0
4848 4848 2021-06-11 Sacramento 67 107186 1718 69 2
4906 4906 2021-06-10 Sacramento 67 107117 1716 14 0
4964 4964 2021-06-09 Sacramento 67 107103 1716 73 0
5022 5022 2021-06-08 Sacramento 67 107030 1716 69 0
5080 5080 2021-06-07 Sacramento 67 106961 1716 247 0
5138 5138 2021-06-06 Sacramento 67 106714 1716 0 0
5196 5196 2021-06-05 Sacramento 67 106714 1716 0 0
5254 5254 2021-06-04 Sacramento 67 106714 1716 79 1
5312 5312 2021-06-03 Sacramento 67 106635 1715 65 0
5370 5370 2021-06-02 Sacramento 67 106570 1715 97 6
5428 5428 2021-06-01 Sacramento 67 106473 1709 208 2
5486 5486 2021-05-31 Sacramento 67 106265 1707 0 0
5544 5544 2021-05-30 Sacramento 67 106265 1707 0 0
5602 5602 2021-05-29 Sacramento 67 106265 1707 0 0
5660 5660 2021-05-28 Sacramento 67 106265 1707 112 0
5718 5718 2021-05-27 Sacramento 67 106153 1707 110 5
5776 5776 2021-05-26 Sacramento 67 106043 1702 80 2

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [latimes_county_totals] (
   [date] TEXT,
   [county] TEXT,
   [fips] INTEGER,
   [confirmed_cases] INTEGER,
   [deaths] INTEGER,
   [new_confirmed_cases] INTEGER,
   [new_deaths] INTEGER
);