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_confirmed_cases
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 |
---|---|---|---|---|---|---|---|---|
1866 | 1866 | 2021-08-01 | Fresno | 19 | 104639 | 1746 | 0 | 0 |
1924 | 1924 | 2021-07-31 | Fresno | 19 | 104639 | 1746 | 0 | 0 |
2272 | 2272 | 2021-07-25 | Fresno | 19 | 103637 | 1736 | 0 | 0 |
2330 | 2330 | 2021-07-24 | Fresno | 19 | 103637 | 1736 | 0 | 0 |
2678 | 2678 | 2021-07-18 | Fresno | 19 | 103055 | 1730 | 0 | 0 |
2736 | 2736 | 2021-07-17 | Fresno | 19 | 103055 | 1730 | 0 | 0 |
3084 | 3084 | 2021-07-11 | Fresno | 19 | 102811 | 1730 | 0 | 0 |
30928 | 30928 | 2020-03-06 | Fresno | 19 | 3 | 0 | 0 | 0 |
30952 | 30952 | 2020-03-05 | Fresno | 19 | 3 | 0 | 0 | 0 |
31000 | 31000 | 2020-03-03 | Fresno | 19 | 2 | 0 | 0 | 0 |
31048 | 31048 | 2020-03-01 | Fresno | 19 | 1 | 0 | 0 | 0 |
31072 | 31072 | 2020-02-29 | Fresno | 19 | 1 | 0 | 0 | 0 |
31095 | 31095 | 2020-02-28 | Fresno | 19 | 1 | 0 | 0 | 0 |
31115 | 31115 | 2020-02-27 | Fresno | 19 | 1 | 0 | 0 | 0 |
30828 | 30828 | 2020-03-10 | Fresno | 19 | 8 | 0 | 1 | 0 |
30878 | 30878 | 2020-03-08 | Fresno | 19 | 5 | 0 | 1 | 0 |
30903 | 30903 | 2020-03-07 | Fresno | 19 | 4 | 0 | 1 | 0 |
30976 | 30976 | 2020-03-04 | Fresno | 19 | 3 | 0 | 1 | 0 |
31024 | 31024 | 2020-03-02 | Fresno | 19 | 2 | 0 | 1 | 0 |
3026 | 3026 | 2021-07-12 | Fresno | 19 | 102813 | 1730 | 2 | 0 |
30774 | 30774 | 2020-03-12 | Fresno | 19 | 12 | 0 | 2 | 0 |
30801 | 30801 | 2020-03-11 | Fresno | 19 | 10 | 0 | 2 | 0 |
30853 | 30853 | 2020-03-09 | Fresno | 19 | 7 | 0 | 2 | 0 |
30477 | 30477 | 2020-03-21 | Fresno | 19 | 93 | 0 | 3 | 0 |
30435 | 30435 | 2020-03-22 | Fresno | 19 | 97 | 0 | 4 | 0 |
30718 | 30718 | 2020-03-14 | Fresno | 19 | 24 | 0 | 5 | 0 |
3142 | 3142 | 2021-07-10 | Fresno | 19 | 102811 | 1730 | 6 | 0 |
29448 | 29448 | 2020-04-11 | Fresno | 19 | 418 | 5 | 7 | 0 |
30747 | 30747 | 2020-03-13 | Fresno | 19 | 19 | 0 | 7 | 0 |
30516 | 30516 | 2020-03-20 | Fresno | 19 | 90 | 0 | 8 | 0 |
30687 | 30687 | 2020-03-15 | Fresno | 19 | 32 | 0 | 8 | 0 |
5114 | 5114 | 2021-06-06 | Fresno | 19 | 102004 | 1717 | 9 | 5 |
29766 | 29766 | 2020-04-05 | Fresno | 19 | 306 | 1 | 9 | 0 |
30123 | 30123 | 2020-03-29 | Fresno | 19 | 187 | 0 | 9 | 0 |
30217 | 30217 | 2020-03-27 | Fresno | 19 | 167 | 0 | 9 | 0 |
30551 | 30551 | 2020-03-19 | Fresno | 19 | 82 | 0 | 9 | 0 |
30586 | 30586 | 2020-03-18 | Fresno | 19 | 73 | 0 | 9 | 0 |
4708 | 4708 | 2021-06-13 | Fresno | 19 | 102159 | 1719 | 10 | 2 |
29395 | 29395 | 2020-04-12 | Fresno | 19 | 428 | 5 | 10 | 0 |
30351 | 30351 | 2020-03-24 | Fresno | 19 | 125 | 0 | 10 | 0 |
30170 | 30170 | 2020-03-28 | Fresno | 19 | 178 | 0 | 11 | 0 |
5520 | 5520 | 2021-05-30 | Fresno | 19 | 101867 | 1705 | 12 | 1 |
29819 | 29819 | 2020-04-04 | Fresno | 19 | 297 | 1 | 12 | 0 |
30621 | 30621 | 2020-03-17 | Fresno | 19 | 64 | 0 | 12 | 0 |
3954 | 3954 | 2021-06-26 | Fresno | 19 | 102456 | 1727 | 14 | 0 |
4302 | 4302 | 2021-06-20 | Fresno | 19 | 102320 | 1724 | 14 | 2 |
5578 | 5578 | 2021-05-29 | Fresno | 19 | 101855 | 1704 | 14 | 0 |
5926 | 5926 | 2021-05-23 | Fresno | 19 | 101688 | 1698 | 14 | 0 |
29871 | 29871 | 2020-04-03 | Fresno | 19 | 285 | 1 | 14 | 1 |
3896 | 3896 | 2021-06-27 | Fresno | 19 | 102471 | 1727 | 15 | 0 |
29607 | 29607 | 2020-04-08 | Fresno | 19 | 372 | 3 | 15 | 0 |
30263 | 30263 | 2020-03-26 | Fresno | 19 | 158 | 0 | 15 | 0 |
3490 | 3490 | 2021-07-04 | Fresno | 19 | 102659 | 1727 | 16 | 0 |
4360 | 4360 | 2021-06-19 | Fresno | 19 | 102306 | 1722 | 16 | 0 |
5172 | 5172 | 2021-06-05 | Fresno | 19 | 101995 | 1712 | 16 | 3 |
5230 | 5230 | 2021-06-04 | Fresno | 19 | 101979 | 1709 | 16 | 2 |
4128 | 4128 | 2021-06-23 | Fresno | 19 | 102395 | 1724 | 17 | 0 |
4766 | 4766 | 2021-06-12 | Fresno | 19 | 102149 | 1717 | 17 | 0 |
5636 | 5636 | 2021-05-28 | Fresno | 19 | 101841 | 1704 | 17 | 2 |
29923 | 29923 | 2020-04-02 | Fresno | 19 | 271 | 0 | 17 | 0 |
4012 | 4012 | 2021-06-25 | Fresno | 19 | 102442 | 1727 | 18 | 3 |
4882 | 4882 | 2021-06-10 | Fresno | 19 | 102106 | 1717 | 18 | 0 |
5462 | 5462 | 2021-05-31 | Fresno | 19 | 101885 | 1705 | 18 | 0 |
28256 | 28256 | 2020-05-03 | Fresno | 19 | 1198 | 8 | 18 | 0 |
28918 | 28918 | 2020-04-21 | Fresno | 19 | 649 | 7 | 18 | 0 |
30307 | 30307 | 2020-03-25 | Fresno | 19 | 143 | 0 | 18 | 0 |
30393 | 30393 | 2020-03-23 | Fresno | 19 | 115 | 0 | 18 | 0 |
5346 | 5346 | 2021-06-02 | Fresno | 19 | 101940 | 1706 | 19 | 0 |
28706 | 28706 | 2020-04-25 | Fresno | 19 | 771 | 7 | 19 | 0 |
29554 | 29554 | 2020-04-09 | Fresno | 19 | 391 | 3 | 19 | 0 |
29660 | 29660 | 2020-04-07 | Fresno | 19 | 357 | 3 | 19 | 1 |
4186 | 4186 | 2021-06-22 | Fresno | 19 | 102378 | 1724 | 20 | 0 |
6042 | 6042 | 2021-05-21 | Fresno | 19 | 101646 | 1696 | 20 | 3 |
27038 | 27038 | 2020-05-24 | Fresno | 19 | 2609 | 22 | 20 | 0 |
29024 | 29024 | 2020-04-19 | Fresno | 19 | 595 | 7 | 20 | 0 |
29501 | 29501 | 2020-04-10 | Fresno | 19 | 411 | 5 | 20 | 2 |
30655 | 30655 | 2020-03-16 | Fresno | 19 | 52 | 0 | 20 | 0 |
29974 | 29974 | 2020-04-01 | Fresno | 19 | 254 | 0 | 21 | 0 |
4592 | 4592 | 2021-06-15 | Fresno | 19 | 102209 | 1719 | 22 | 0 |
5752 | 5752 | 2021-05-26 | Fresno | 19 | 101793 | 1701 | 22 | 3 |
29077 | 29077 | 2020-04-18 | Fresno | 19 | 575 | 7 | 22 | 0 |
29236 | 29236 | 2020-04-15 | Fresno | 19 | 501 | 7 | 22 | 0 |
29289 | 29289 | 2020-04-14 | Fresno | 19 | 479 | 7 | 22 | 2 |
30075 | 30075 | 2020-03-30 | Fresno | 19 | 209 | 0 | 22 | 0 |
3432 | 3432 | 2021-07-05 | Fresno | 19 | 102682 | 1727 | 23 | 0 |
5288 | 5288 | 2021-06-03 | Fresno | 19 | 101963 | 1707 | 23 | 1 |
29183 | 29183 | 2020-04-16 | Fresno | 19 | 525 | 7 | 24 | 0 |
30025 | 30025 | 2020-03-31 | Fresno | 19 | 233 | 0 | 24 | 0 |
4418 | 4418 | 2021-06-18 | Fresno | 19 | 102290 | 1722 | 25 | 0 |
4940 | 4940 | 2021-06-09 | Fresno | 19 | 102088 | 1717 | 25 | 0 |
3780 | 3780 | 2021-06-29 | Fresno | 19 | 102524 | 1727 | 26 | 0 |
4534 | 4534 | 2021-06-16 | Fresno | 19 | 102235 | 1722 | 26 | 3 |
4824 | 4824 | 2021-06-11 | Fresno | 19 | 102132 | 1717 | 26 | 0 |
4998 | 4998 | 2021-06-08 | Fresno | 19 | 102063 | 1717 | 26 | 0 |
3838 | 3838 | 2021-06-28 | Fresno | 19 | 102498 | 1727 | 27 | 0 |
28314 | 28314 | 2020-05-02 | Fresno | 19 | 1180 | 8 | 27 | 0 |
3200 | 3200 | 2021-07-09 | Fresno | 19 | 102805 | 1730 | 28 | 3 |
3548 | 3548 | 2021-07-03 | Fresno | 19 | 102643 | 1727 | 28 | 0 |
4650 | 4650 | 2021-06-14 | Fresno | 19 | 102187 | 1719 | 28 | 0 |
5984 | 5984 | 2021-05-22 | Fresno | 19 | 101674 | 1698 | 28 | 2 |
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 );