latimes_county_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_county_totals
555 rows where county = "Fresno" sorted by new_deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | fips | confirmed_cases | deaths | new_confirmed_cases | new_deaths ▼ |
---|---|---|---|---|---|---|---|---|
10 | 10 | 2021-09-02 | Fresno | 19 | 117492 | 1801 | 337 | 0 |
126 | 126 | 2021-08-31 | Fresno | 19 | 115867 | 1792 | 365 | 0 |
184 | 184 | 2021-08-30 | Fresno | 19 | 115502 | 1792 | 423 | 0 |
416 | 416 | 2021-08-26 | Fresno | 19 | 113384 | 1761 | 360 | 0 |
532 | 532 | 2021-08-24 | Fresno | 19 | 112445 | 1759 | 388 | 0 |
590 | 590 | 2021-08-23 | Fresno | 19 | 112057 | 1759 | 292 | 0 |
648 | 648 | 2021-08-22 | Fresno | 19 | 111765 | 1759 | 450 | 0 |
706 | 706 | 2021-08-21 | Fresno | 19 | 111315 | 1759 | 368 | 0 |
764 | 764 | 2021-08-20 | Fresno | 19 | 110947 | 1759 | 424 | 0 |
938 | 938 | 2021-08-17 | Fresno | 19 | 109623 | 1753 | 241 | 0 |
996 | 996 | 2021-08-16 | Fresno | 19 | 109382 | 1753 | 326 | 0 |
1054 | 1054 | 2021-08-15 | Fresno | 19 | 109056 | 1753 | 418 | 0 |
1112 | 1112 | 2021-08-14 | Fresno | 19 | 108638 | 1753 | 445 | 0 |
1286 | 1286 | 2021-08-11 | Fresno | 19 | 107616 | 1747 | 306 | 0 |
1344 | 1344 | 2021-08-10 | Fresno | 19 | 107310 | 1747 | 232 | 0 |
1402 | 1402 | 2021-08-09 | Fresno | 19 | 107078 | 1747 | 217 | 0 |
1460 | 1460 | 2021-08-08 | Fresno | 19 | 106861 | 1747 | 319 | 0 |
1518 | 1518 | 2021-08-07 | Fresno | 19 | 106542 | 1747 | 323 | 0 |
1576 | 1576 | 2021-08-06 | Fresno | 19 | 106219 | 1747 | 320 | 0 |
1692 | 1692 | 2021-08-04 | Fresno | 19 | 105732 | 1746 | 261 | 0 |
1750 | 1750 | 2021-08-03 | Fresno | 19 | 105471 | 1746 | 132 | 0 |
1808 | 1808 | 2021-08-02 | Fresno | 19 | 105339 | 1746 | 700 | 0 |
1866 | 1866 | 2021-08-01 | Fresno | 19 | 104639 | 1746 | 0 | 0 |
1924 | 1924 | 2021-07-31 | Fresno | 19 | 104639 | 1746 | 0 | 0 |
1982 | 1982 | 2021-07-30 | Fresno | 19 | 104639 | 1746 | 181 | 0 |
2040 | 2040 | 2021-07-29 | Fresno | 19 | 104458 | 1746 | 170 | 0 |
2156 | 2156 | 2021-07-27 | Fresno | 19 | 104143 | 1742 | 124 | 0 |
2272 | 2272 | 2021-07-25 | Fresno | 19 | 103637 | 1736 | 0 | 0 |
2330 | 2330 | 2021-07-24 | Fresno | 19 | 103637 | 1736 | 0 | 0 |
2388 | 2388 | 2021-07-23 | Fresno | 19 | 103637 | 1736 | 133 | 0 |
2446 | 2446 | 2021-07-22 | Fresno | 19 | 103504 | 1736 | 66 | 0 |
2562 | 2562 | 2021-07-20 | Fresno | 19 | 103350 | 1731 | 52 | 0 |
2678 | 2678 | 2021-07-18 | Fresno | 19 | 103055 | 1730 | 0 | 0 |
2736 | 2736 | 2021-07-17 | Fresno | 19 | 103055 | 1730 | 0 | 0 |
2794 | 2794 | 2021-07-16 | Fresno | 19 | 103055 | 1730 | 89 | 0 |
2852 | 2852 | 2021-07-15 | Fresno | 19 | 102966 | 1730 | 57 | 0 |
2910 | 2910 | 2021-07-14 | Fresno | 19 | 102909 | 1730 | 56 | 0 |
2968 | 2968 | 2021-07-13 | Fresno | 19 | 102853 | 1730 | 40 | 0 |
3026 | 3026 | 2021-07-12 | Fresno | 19 | 102813 | 1730 | 2 | 0 |
3084 | 3084 | 2021-07-11 | Fresno | 19 | 102811 | 1730 | 0 | 0 |
3142 | 3142 | 2021-07-10 | Fresno | 19 | 102811 | 1730 | 6 | 0 |
3258 | 3258 | 2021-07-08 | Fresno | 19 | 102777 | 1727 | 31 | 0 |
3316 | 3316 | 2021-07-07 | Fresno | 19 | 102746 | 1727 | 33 | 0 |
3374 | 3374 | 2021-07-06 | Fresno | 19 | 102713 | 1727 | 31 | 0 |
3432 | 3432 | 2021-07-05 | Fresno | 19 | 102682 | 1727 | 23 | 0 |
3490 | 3490 | 2021-07-04 | Fresno | 19 | 102659 | 1727 | 16 | 0 |
3548 | 3548 | 2021-07-03 | Fresno | 19 | 102643 | 1727 | 28 | 0 |
3606 | 3606 | 2021-07-02 | Fresno | 19 | 102615 | 1727 | 32 | 0 |
3664 | 3664 | 2021-07-01 | Fresno | 19 | 102583 | 1727 | 29 | 0 |
3722 | 3722 | 2021-06-30 | Fresno | 19 | 102554 | 1727 | 30 | 0 |
3780 | 3780 | 2021-06-29 | Fresno | 19 | 102524 | 1727 | 26 | 0 |
3838 | 3838 | 2021-06-28 | Fresno | 19 | 102498 | 1727 | 27 | 0 |
3896 | 3896 | 2021-06-27 | Fresno | 19 | 102471 | 1727 | 15 | 0 |
3954 | 3954 | 2021-06-26 | Fresno | 19 | 102456 | 1727 | 14 | 0 |
4070 | 4070 | 2021-06-24 | Fresno | 19 | 102424 | 1724 | 29 | 0 |
4128 | 4128 | 2021-06-23 | Fresno | 19 | 102395 | 1724 | 17 | 0 |
4186 | 4186 | 2021-06-22 | Fresno | 19 | 102378 | 1724 | 20 | 0 |
4244 | 4244 | 2021-06-21 | Fresno | 19 | 102358 | 1724 | 38 | 0 |
4360 | 4360 | 2021-06-19 | Fresno | 19 | 102306 | 1722 | 16 | 0 |
4418 | 4418 | 2021-06-18 | Fresno | 19 | 102290 | 1722 | 25 | 0 |
4476 | 4476 | 2021-06-17 | Fresno | 19 | 102265 | 1722 | 30 | 0 |
4592 | 4592 | 2021-06-15 | Fresno | 19 | 102209 | 1719 | 22 | 0 |
4650 | 4650 | 2021-06-14 | Fresno | 19 | 102187 | 1719 | 28 | 0 |
4766 | 4766 | 2021-06-12 | Fresno | 19 | 102149 | 1717 | 17 | 0 |
4824 | 4824 | 2021-06-11 | Fresno | 19 | 102132 | 1717 | 26 | 0 |
4882 | 4882 | 2021-06-10 | Fresno | 19 | 102106 | 1717 | 18 | 0 |
4940 | 4940 | 2021-06-09 | Fresno | 19 | 102088 | 1717 | 25 | 0 |
4998 | 4998 | 2021-06-08 | Fresno | 19 | 102063 | 1717 | 26 | 0 |
5056 | 5056 | 2021-06-07 | Fresno | 19 | 102037 | 1717 | 33 | 0 |
5346 | 5346 | 2021-06-02 | Fresno | 19 | 101940 | 1706 | 19 | 0 |
5462 | 5462 | 2021-05-31 | Fresno | 19 | 101885 | 1705 | 18 | 0 |
5578 | 5578 | 2021-05-29 | Fresno | 19 | 101855 | 1704 | 14 | 0 |
5810 | 5810 | 2021-05-25 | Fresno | 19 | 101771 | 1698 | 39 | 0 |
5868 | 5868 | 2021-05-24 | Fresno | 19 | 101732 | 1698 | 44 | 0 |
5926 | 5926 | 2021-05-23 | Fresno | 19 | 101688 | 1698 | 14 | 0 |
6158 | 6158 | 2021-05-19 | Fresno | 19 | 101597 | 1690 | 37 | 0 |
6216 | 6216 | 2021-05-18 | Fresno | 19 | 101560 | 1690 | 43 | 0 |
6274 | 6274 | 2021-05-17 | Fresno | 19 | 101517 | 1690 | 43 | 0 |
6448 | 6448 | 2021-05-14 | Fresno | 19 | 101411 | 1687 | 28 | 0 |
6622 | 6622 | 2021-05-11 | Fresno | 19 | 101292 | 1682 | 31 | 0 |
6680 | 6680 | 2021-05-10 | Fresno | 19 | 101261 | 1682 | 38 | 0 |
6738 | 6738 | 2021-05-09 | Fresno | 19 | 101223 | 1682 | 35 | 0 |
6854 | 6854 | 2021-05-07 | Fresno | 19 | 101156 | 1680 | 41 | 0 |
6970 | 6970 | 2021-05-05 | Fresno | 19 | 101066 | 1677 | 54 | 0 |
7028 | 7028 | 2021-05-04 | Fresno | 19 | 101012 | 1677 | 53 | 0 |
7086 | 7086 | 2021-05-03 | Fresno | 19 | 100959 | 1677 | 71 | 0 |
7434 | 7434 | 2021-04-27 | Fresno | 19 | 100634 | 1662 | 55 | 0 |
7492 | 7492 | 2021-04-26 | Fresno | 19 | 100579 | 1662 | 58 | 0 |
7550 | 7550 | 2021-04-25 | Fresno | 19 | 100521 | 1662 | 31 | 0 |
7840 | 7840 | 2021-04-20 | Fresno | 19 | 100294 | 1646 | 68 | 0 |
7898 | 7898 | 2021-04-19 | Fresno | 19 | 100226 | 1646 | 57 | 0 |
8246 | 8246 | 2021-04-13 | Fresno | 19 | 99894 | 1633 | 61 | 0 |
8362 | 8362 | 2021-04-11 | Fresno | 19 | 99767 | 1630 | 33 | 0 |
8478 | 8478 | 2021-04-09 | Fresno | 19 | 99700 | 1627 | 63 | 0 |
8710 | 8710 | 2021-04-05 | Fresno | 19 | 99426 | 1597 | 74 | 0 |
8768 | 8768 | 2021-04-04 | Fresno | 19 | 99352 | 1597 | 56 | 0 |
8826 | 8826 | 2021-04-03 | Fresno | 19 | 99296 | 1597 | 54 | 0 |
9000 | 9000 | 2021-03-31 | Fresno | 19 | 99101 | 1593 | 64 | 0 |
9116 | 9116 | 2021-03-29 | Fresno | 19 | 98954 | 1592 | 81 | 0 |
9174 | 9174 | 2021-03-28 | Fresno | 19 | 98873 | 1592 | 52 | 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 );