latimes_county_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_county_totals
527 rows where fips = 101 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | fips | confirmed_cases | deaths | new_confirmed_cases | new_deaths |
---|---|---|---|---|---|---|---|---|
18089 | 18089 | 2020-10-26 | Sutter | 101 | 1865 | 12 | 28 | 0 |
18147 | 18147 | 2020-10-25 | Sutter | 101 | 1837 | 12 | 0 | 0 |
18205 | 18205 | 2020-10-24 | Sutter | 101 | 1837 | 12 | 0 | 0 |
18263 | 18263 | 2020-10-23 | Sutter | 101 | 1837 | 12 | 0 | 0 |
18321 | 18321 | 2020-10-22 | Sutter | 101 | 1837 | 12 | 7 | 0 |
18379 | 18379 | 2020-10-21 | Sutter | 101 | 1830 | 12 | 9 | 0 |
18437 | 18437 | 2020-10-20 | Sutter | 101 | 1821 | 12 | 2 | 0 |
18495 | 18495 | 2020-10-19 | Sutter | 101 | 1819 | 12 | 23 | 0 |
18553 | 18553 | 2020-10-18 | Sutter | 101 | 1796 | 12 | 0 | 0 |
18611 | 18611 | 2020-10-17 | Sutter | 101 | 1796 | 12 | 0 | 0 |
18669 | 18669 | 2020-10-16 | Sutter | 101 | 1796 | 12 | 3 | 0 |
18727 | 18727 | 2020-10-15 | Sutter | 101 | 1793 | 12 | 8 | 0 |
18785 | 18785 | 2020-10-14 | Sutter | 101 | 1785 | 12 | 0 | 0 |
18843 | 18843 | 2020-10-13 | Sutter | 101 | 1785 | 12 | 3 | 0 |
18901 | 18901 | 2020-10-12 | Sutter | 101 | 1782 | 12 | 7 | 0 |
18959 | 18959 | 2020-10-11 | Sutter | 101 | 1775 | 12 | 0 | 0 |
19017 | 19017 | 2020-10-10 | Sutter | 101 | 1775 | 12 | 0 | 0 |
19075 | 19075 | 2020-10-09 | Sutter | 101 | 1775 | 12 | 4 | 0 |
19133 | 19133 | 2020-10-08 | Sutter | 101 | 1771 | 12 | 1 | 0 |
19191 | 19191 | 2020-10-07 | Sutter | 101 | 1770 | 12 | 3 | 0 |
19249 | 19249 | 2020-10-06 | Sutter | 101 | 1767 | 12 | 4 | 0 |
19307 | 19307 | 2020-10-05 | Sutter | 101 | 1763 | 12 | 15 | 1 |
19365 | 19365 | 2020-10-04 | Sutter | 101 | 1748 | 11 | 0 | 0 |
19423 | 19423 | 2020-10-03 | Sutter | 101 | 1748 | 11 | 0 | 0 |
19481 | 19481 | 2020-10-02 | Sutter | 101 | 1748 | 11 | 15 | 0 |
19539 | 19539 | 2020-10-01 | Sutter | 101 | 1733 | 11 | 7 | 0 |
19597 | 19597 | 2020-09-30 | Sutter | 101 | 1726 | 11 | 6 | 0 |
19655 | 19655 | 2020-09-29 | Sutter | 101 | 1720 | 11 | 3 | 0 |
19713 | 19713 | 2020-09-28 | Sutter | 101 | 1717 | 11 | 12 | 0 |
19771 | 19771 | 2020-09-27 | Sutter | 101 | 1705 | 11 | 0 | 0 |
19829 | 19829 | 2020-09-26 | Sutter | 101 | 1705 | 11 | 0 | 0 |
19887 | 19887 | 2020-09-25 | Sutter | 101 | 1705 | 11 | 9 | 0 |
19945 | 19945 | 2020-09-24 | Sutter | 101 | 1696 | 11 | 7 | 0 |
20003 | 20003 | 2020-09-23 | Sutter | 101 | 1689 | 11 | 3 | 1 |
20061 | 20061 | 2020-09-22 | Sutter | 101 | 1686 | 10 | 7 | 0 |
20119 | 20119 | 2020-09-21 | Sutter | 101 | 1679 | 10 | 37 | 0 |
20177 | 20177 | 2020-09-20 | Sutter | 101 | 1642 | 10 | 0 | 0 |
20235 | 20235 | 2020-09-19 | Sutter | 101 | 1642 | 10 | 0 | 0 |
20293 | 20293 | 2020-09-18 | Sutter | 101 | 1642 | 10 | 11 | 0 |
20351 | 20351 | 2020-09-17 | Sutter | 101 | 1631 | 10 | 10 | 0 |
20409 | 20409 | 2020-09-16 | Sutter | 101 | 1621 | 10 | 13 | 0 |
20467 | 20467 | 2020-09-15 | Sutter | 101 | 1608 | 10 | 9 | 0 |
20525 | 20525 | 2020-09-14 | Sutter | 101 | 1599 | 10 | 35 | 0 |
20583 | 20583 | 2020-09-13 | Sutter | 101 | 1564 | 10 | 0 | 0 |
20641 | 20641 | 2020-09-12 | Sutter | 101 | 1564 | 10 | 0 | 0 |
20699 | 20699 | 2020-09-11 | Sutter | 101 | 1564 | 10 | 22 | 0 |
20757 | 20757 | 2020-09-10 | Sutter | 101 | 1542 | 10 | 12 | 0 |
20815 | 20815 | 2020-09-09 | Sutter | 101 | 1530 | 10 | 4 | 0 |
20873 | 20873 | 2020-09-08 | Sutter | 101 | 1526 | 10 | 61 | 0 |
20931 | 20931 | 2020-09-07 | Sutter | 101 | 1465 | 10 | 0 | 0 |
20989 | 20989 | 2020-09-06 | Sutter | 101 | 1465 | 10 | 0 | 0 |
21047 | 21047 | 2020-09-05 | Sutter | 101 | 1465 | 10 | 0 | 0 |
21105 | 21105 | 2020-09-04 | Sutter | 101 | 1465 | 10 | 4 | 0 |
21163 | 21163 | 2020-09-03 | Sutter | 101 | 1461 | 10 | 25 | 0 |
21221 | 21221 | 2020-09-02 | Sutter | 101 | 1436 | 10 | 0 | 0 |
21279 | 21279 | 2020-09-01 | Sutter | 101 | 1436 | 10 | 27 | 0 |
21337 | 21337 | 2020-08-31 | Sutter | 101 | 1409 | 10 | 9 | 0 |
21395 | 21395 | 2020-08-30 | Sutter | 101 | 1400 | 10 | 32 | 0 |
21453 | 21453 | 2020-08-29 | Sutter | 101 | 1368 | 10 | 0 | 0 |
21511 | 21511 | 2020-08-28 | Sutter | 101 | 1368 | 10 | 21 | 0 |
21569 | 21569 | 2020-08-27 | Sutter | 101 | 1347 | 10 | 22 | 2 |
21627 | 21627 | 2020-08-26 | Sutter | 101 | 1325 | 8 | 13 | 0 |
21685 | 21685 | 2020-08-25 | Sutter | 101 | 1312 | 8 | 29 | 0 |
21743 | 21743 | 2020-08-24 | Sutter | 101 | 1283 | 8 | 23 | 0 |
21801 | 21801 | 2020-08-23 | Sutter | 101 | 1260 | 8 | 37 | 1 |
21859 | 21859 | 2020-08-22 | Sutter | 101 | 1223 | 7 | 0 | 0 |
21917 | 21917 | 2020-08-21 | Sutter | 101 | 1223 | 7 | 10 | 0 |
21975 | 21975 | 2020-08-20 | Sutter | 101 | 1213 | 7 | 27 | 0 |
22033 | 22033 | 2020-08-19 | Sutter | 101 | 1186 | 7 | 8 | 0 |
22091 | 22091 | 2020-08-18 | Sutter | 101 | 1178 | 7 | 21 | 0 |
22149 | 22149 | 2020-08-17 | Sutter | 101 | 1157 | 7 | 20 | 0 |
22207 | 22207 | 2020-08-16 | Sutter | 101 | 1137 | 7 | 43 | 0 |
22265 | 22265 | 2020-08-15 | Sutter | 101 | 1094 | 7 | 3 | 0 |
22323 | 22323 | 2020-08-14 | Sutter | 101 | 1091 | 7 | 21 | 0 |
22381 | 22381 | 2020-08-13 | Sutter | 101 | 1070 | 7 | 29 | 0 |
22439 | 22439 | 2020-08-12 | Sutter | 101 | 1041 | 7 | 22 | 0 |
22497 | 22497 | 2020-08-11 | Sutter | 101 | 1019 | 7 | 23 | 0 |
22555 | 22555 | 2020-08-10 | Sutter | 101 | 996 | 7 | 44 | 0 |
22613 | 22613 | 2020-08-09 | Sutter | 101 | 952 | 7 | 10 | 0 |
22671 | 22671 | 2020-08-08 | Sutter | 101 | 942 | 7 | 21 | 0 |
22729 | 22729 | 2020-08-07 | Sutter | 101 | 921 | 7 | 28 | 1 |
22787 | 22787 | 2020-08-06 | Sutter | 101 | 893 | 6 | 12 | 0 |
22845 | 22845 | 2020-08-05 | Sutter | 101 | 881 | 6 | 41 | 0 |
22903 | 22903 | 2020-08-04 | Sutter | 101 | 840 | 6 | 28 | 0 |
22961 | 22961 | 2020-08-03 | Sutter | 101 | 812 | 6 | 17 | 0 |
23019 | 23019 | 2020-08-02 | Sutter | 101 | 795 | 6 | 9 | 0 |
23077 | 23077 | 2020-08-01 | Sutter | 101 | 786 | 6 | 18 | 0 |
23135 | 23135 | 2020-07-31 | Sutter | 101 | 768 | 6 | 13 | 0 |
23193 | 23193 | 2020-07-30 | Sutter | 101 | 755 | 6 | 24 | 0 |
23251 | 23251 | 2020-07-29 | Sutter | 101 | 731 | 6 | 30 | 0 |
23309 | 23309 | 2020-07-28 | Sutter | 101 | 701 | 6 | 31 | 0 |
23367 | 23367 | 2020-07-27 | Sutter | 101 | 670 | 6 | 23 | 2 |
23425 | 23425 | 2020-07-26 | Sutter | 101 | 647 | 4 | 10 | 0 |
23483 | 23483 | 2020-07-25 | Sutter | 101 | 637 | 4 | 22 | 0 |
23541 | 23541 | 2020-07-24 | Sutter | 101 | 615 | 4 | 14 | 0 |
23599 | 23599 | 2020-07-23 | Sutter | 101 | 601 | 4 | 34 | 0 |
23657 | 23657 | 2020-07-22 | Sutter | 101 | 567 | 4 | 14 | 0 |
23715 | 23715 | 2020-07-21 | Sutter | 101 | 553 | 4 | 14 | 0 |
23773 | 23773 | 2020-07-20 | Sutter | 101 | 539 | 4 | 19 | 0 |
23831 | 23831 | 2020-07-19 | Sutter | 101 | 520 | 4 | 18 | 0 |
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 );