latimes_agency_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_agency_totals

555 rows where fips = 19 sorted by fips

✎ View and edit SQL

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

Suggested facets: date (date)

fips 1

  • 19 · 555 ✖

county 1

agency 1

Link rowid agency county fips ▼ date confirmed_cases deaths did_not_update
11 11 Fresno Fresno 19 2021-09-02 117492 1801  
72 72 Fresno Fresno 19 2021-09-01 117155 1801  
133 133 Fresno Fresno 19 2021-08-31 115867 1792  
194 194 Fresno Fresno 19 2021-08-30 115502 1792  
255 255 Fresno Fresno 19 2021-08-29 115079 1792  
316 316 Fresno Fresno 19 2021-08-28 114481 1774  
377 377 Fresno Fresno 19 2021-08-27 113854 1770  
438 438 Fresno Fresno 19 2021-08-26 113384 1761  
499 499 Fresno Fresno 19 2021-08-25 113024 1761  
560 560 Fresno Fresno 19 2021-08-24 112445 1759  
621 621 Fresno Fresno 19 2021-08-23 112057 1759  
682 682 Fresno Fresno 19 2021-08-22 111765 1759  
743 743 Fresno Fresno 19 2021-08-21 111315 1759  
804 804 Fresno Fresno 19 2021-08-20 110947 1759  
865 865 Fresno Fresno 19 2021-08-19 110523 1759  
926 926 Fresno Fresno 19 2021-08-18 110263 1755  
987 987 Fresno Fresno 19 2021-08-17 109623 1753  
1048 1048 Fresno Fresno 19 2021-08-16 109382 1753  
1109 1109 Fresno Fresno 19 2021-08-15 109056 1753  
1170 1170 Fresno Fresno 19 2021-08-14 108638 1753  
1231 1231 Fresno Fresno 19 2021-08-13 108193 1753  
1292 1292 Fresno Fresno 19 2021-08-12 107773 1751  
1353 1353 Fresno Fresno 19 2021-08-11 107616 1747  
1414 1414 Fresno Fresno 19 2021-08-10 107310 1747  
1475 1475 Fresno Fresno 19 2021-08-09 107078 1747  
1536 1536 Fresno Fresno 19 2021-08-08 106861 1747  
1597 1597 Fresno Fresno 19 2021-08-07 106542 1747  
1658 1658 Fresno Fresno 19 2021-08-06 106219 1747  
1719 1719 Fresno Fresno 19 2021-08-05 105899 1747  
1780 1780 Fresno Fresno 19 2021-08-04 105732 1746  
1841 1841 Fresno Fresno 19 2021-08-03 105471 1746  
1902 1902 Fresno Fresno 19 2021-08-02 105339 1746  
1963 1963 Fresno Fresno 19 2021-08-01 104639 1746 TRUE
2024 2024 Fresno Fresno 19 2021-07-31 104639 1746 TRUE
2085 2085 Fresno Fresno 19 2021-07-30 104639 1746  
2146 2146 Fresno Fresno 19 2021-07-29 104458 1746  
2207 2207 Fresno Fresno 19 2021-07-28 104288 1746  
2268 2268 Fresno Fresno 19 2021-07-27 104143 1742  
2329 2329 Fresno Fresno 19 2021-07-26 104019 1742  
2390 2390 Fresno Fresno 19 2021-07-25 103637 1736 TRUE
2451 2451 Fresno Fresno 19 2021-07-24 103637 1736 TRUE
2512 2512 Fresno Fresno 19 2021-07-23 103637 1736  
2573 2573 Fresno Fresno 19 2021-07-22 103504 1736  
2634 2634 Fresno Fresno 19 2021-07-21 103438 1736  
2695 2695 Fresno Fresno 19 2021-07-20 103350 1731  
2756 2756 Fresno Fresno 19 2021-07-19 103298 1731  
2817 2817 Fresno Fresno 19 2021-07-18 103055 1730 TRUE
2878 2878 Fresno Fresno 19 2021-07-17 103055 1730 TRUE
2939 2939 Fresno Fresno 19 2021-07-16 103055 1730  
3000 3000 Fresno Fresno 19 2021-07-15 102966 1730  
3061 3061 Fresno Fresno 19 2021-07-14 102909 1730  
3122 3122 Fresno Fresno 19 2021-07-13 102853 1730  
3183 3183 Fresno Fresno 19 2021-07-12 102813 1730  
3244 3244 Fresno Fresno 19 2021-07-11 102811 1730 TRUE
3305 3305 Fresno Fresno 19 2021-07-10 102811 1730 TRUE
3366 3366 Fresno Fresno 19 2021-07-09 102805 1730  
3427 3427 Fresno Fresno 19 2021-07-08 102777 1727 TRUE
3488 3488 Fresno Fresno 19 2021-07-07 102746 1727 TRUE
3549 3549 Fresno Fresno 19 2021-07-06 102713 1727 TRUE
3610 3610 Fresno Fresno 19 2021-07-05 102682 1727 TRUE
3671 3671 Fresno Fresno 19 2021-07-04 102659 1727  
3732 3732 Fresno Fresno 19 2021-07-03 102643 1727  
3793 3793 Fresno Fresno 19 2021-07-02 102615 1727 TRUE
3854 3854 Fresno Fresno 19 2021-07-01 102583 1727  
3915 3915 Fresno Fresno 19 2021-06-30 102554 1727 TRUE
3976 3976 Fresno Fresno 19 2021-06-29 102524 1727  
4037 4037 Fresno Fresno 19 2021-06-28 102498 1727  
4098 4098 Fresno Fresno 19 2021-06-27 102471 1727  
4159 4159 Fresno Fresno 19 2021-06-26 102456 1727 TRUE
4220 4220 Fresno Fresno 19 2021-06-25 102442 1727  
4281 4281 Fresno Fresno 19 2021-06-24 102424 1724  
4342 4342 Fresno Fresno 19 2021-06-23 102395 1724  
4403 4403 Fresno Fresno 19 2021-06-22 102378 1724  
4464 4464 Fresno Fresno 19 2021-06-21 102358 1724  
4525 4525 Fresno Fresno 19 2021-06-20 102320 1724  
4586 4586 Fresno Fresno 19 2021-06-19 102306 1722  
4647 4647 Fresno Fresno 19 2021-06-18 102290 1722 TRUE
4708 4708 Fresno Fresno 19 2021-06-17 102265 1722  
4769 4769 Fresno Fresno 19 2021-06-16 102235 1722  
4830 4830 Fresno Fresno 19 2021-06-15 102209 1719  
4891 4891 Fresno Fresno 19 2021-06-14 102187 1719 TRUE
4952 4952 Fresno Fresno 19 2021-06-13 102159 1719  
5013 5013 Fresno Fresno 19 2021-06-12 102149 1717 TRUE
5074 5074 Fresno Fresno 19 2021-06-11 102132 1717  
5135 5135 Fresno Fresno 19 2021-06-10 102106 1717  
5196 5196 Fresno Fresno 19 2021-06-09 102088 1717  
5257 5257 Fresno Fresno 19 2021-06-08 102063 1717  
5318 5318 Fresno Fresno 19 2021-06-07 102037 1717  
5379 5379 Fresno Fresno 19 2021-06-06 102004 1717  
5440 5440 Fresno Fresno 19 2021-06-05 101995 1712  
5501 5501 Fresno Fresno 19 2021-06-04 101979 1709  
5562 5562 Fresno Fresno 19 2021-06-03 101963 1707  
5623 5623 Fresno Fresno 19 2021-06-02 101940 1706  
5684 5684 Fresno Fresno 19 2021-06-01 101921 1706  
5745 5745 Fresno Fresno 19 2021-05-31 101885 1705 TRUE
5806 5806 Fresno Fresno 19 2021-05-30 101867 1705  
5867 5867 Fresno Fresno 19 2021-05-29 101855 1704 TRUE
5928 5928 Fresno Fresno 19 2021-05-28 101841 1704  
5989 5989 Fresno Fresno 19 2021-05-27 101824 1702  
6050 6050 Fresno Fresno 19 2021-05-26 101793 1701  

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [latimes_agency_totals] (
   [agency] TEXT,
   [county] TEXT,
   [fips] INTEGER,
   [date] TEXT,
   [confirmed_cases] INTEGER,
   [deaths] INTEGER,
   [did_not_update] TEXT
);