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

555 rows where fips = 19 sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

fips 1

  • 19 · 555 ✖

county 1

Link rowid date ▲ county fips confirmed_cases deaths new_confirmed_cases new_deaths
10 10 2021-09-02 Fresno 19 117492 1801 337 0
68 68 2021-09-01 Fresno 19 117155 1801 1288 9
126 126 2021-08-31 Fresno 19 115867 1792 365 0
184 184 2021-08-30 Fresno 19 115502 1792 423 0
242 242 2021-08-29 Fresno 19 115079 1792 598 18
300 300 2021-08-28 Fresno 19 114481 1774 627 4
358 358 2021-08-27 Fresno 19 113854 1770 470 9
416 416 2021-08-26 Fresno 19 113384 1761 360 0
474 474 2021-08-25 Fresno 19 113024 1761 579 2
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
822 822 2021-08-19 Fresno 19 110523 1759 260 4
880 880 2021-08-18 Fresno 19 110263 1755 640 2
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
1170 1170 2021-08-13 Fresno 19 108193 1753 420 2
1228 1228 2021-08-12 Fresno 19 107773 1751 157 4
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
1634 1634 2021-08-05 Fresno 19 105899 1747 167 1
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
2098 2098 2021-07-28 Fresno 19 104288 1746 145 4
2156 2156 2021-07-27 Fresno 19 104143 1742 124 0
2214 2214 2021-07-26 Fresno 19 104019 1742 382 6
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
2504 2504 2021-07-21 Fresno 19 103438 1736 88 5
2562 2562 2021-07-20 Fresno 19 103350 1731 52 0
2620 2620 2021-07-19 Fresno 19 103298 1731 243 1
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
3200 3200 2021-07-09 Fresno 19 102805 1730 28 3
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
4012 4012 2021-06-25 Fresno 19 102442 1727 18 3
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
4302 4302 2021-06-20 Fresno 19 102320 1724 14 2
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
4534 4534 2021-06-16 Fresno 19 102235 1722 26 3
4592 4592 2021-06-15 Fresno 19 102209 1719 22 0
4650 4650 2021-06-14 Fresno 19 102187 1719 28 0
4708 4708 2021-06-13 Fresno 19 102159 1719 10 2
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
5114 5114 2021-06-06 Fresno 19 102004 1717 9 5
5172 5172 2021-06-05 Fresno 19 101995 1712 16 3
5230 5230 2021-06-04 Fresno 19 101979 1709 16 2
5288 5288 2021-06-03 Fresno 19 101963 1707 23 1
5346 5346 2021-06-02 Fresno 19 101940 1706 19 0
5404 5404 2021-06-01 Fresno 19 101921 1706 36 1
5462 5462 2021-05-31 Fresno 19 101885 1705 18 0
5520 5520 2021-05-30 Fresno 19 101867 1705 12 1
5578 5578 2021-05-29 Fresno 19 101855 1704 14 0
5636 5636 2021-05-28 Fresno 19 101841 1704 17 2
5694 5694 2021-05-27 Fresno 19 101824 1702 31 1
5752 5752 2021-05-26 Fresno 19 101793 1701 22 3

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
);