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

541 rows where fips = 107 sorted by date descending

✎ View and edit SQL

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

Suggested facets: new_deaths, date (date)

fips 1

  • 107 · 541 ✖

county 1

Link rowid date ▲ county fips confirmed_cases deaths new_confirmed_cases new_deaths
54 54 2021-09-02 Tulare 107 55762 869 472 0
112 112 2021-09-01 Tulare 107 55290 869 139 0
170 170 2021-08-31 Tulare 107 55151 869 628 0
228 228 2021-08-30 Tulare 107 54523 869 508 2
286 286 2021-08-29 Tulare 107 54015 867 0 0
344 344 2021-08-28 Tulare 107 54015 867 0 0
402 402 2021-08-27 Tulare 107 54015 867 96 0
460 460 2021-08-26 Tulare 107 53919 867 328 2
518 518 2021-08-25 Tulare 107 53591 865 462 10
576 576 2021-08-24 Tulare 107 53129 855 100 0
634 634 2021-08-23 Tulare 107 53029 855 414 0
692 692 2021-08-22 Tulare 107 52615 855 0 0
750 750 2021-08-21 Tulare 107 52615 855 0 0
808 808 2021-08-20 Tulare 107 52615 855 111 0
866 866 2021-08-19 Tulare 107 52504 855 162 0
924 924 2021-08-18 Tulare 107 52342 855 340 0
982 982 2021-08-17 Tulare 107 52002 855 39 0
1040 1040 2021-08-16 Tulare 107 51963 855 229 0
1098 1098 2021-08-15 Tulare 107 51734 855 0 0
1156 1156 2021-08-14 Tulare 107 51734 855 0 0
1214 1214 2021-08-13 Tulare 107 51734 855 186 0
1272 1272 2021-08-12 Tulare 107 51548 855 59 1
1330 1330 2021-08-11 Tulare 107 51489 854 99 1
1388 1388 2021-08-10 Tulare 107 51390 853 66 0
1446 1446 2021-08-09 Tulare 107 51324 853 378 0
1504 1504 2021-08-08 Tulare 107 50946 853 0 0
1562 1562 2021-08-07 Tulare 107 50946 853 0 0
1620 1620 2021-08-06 Tulare 107 50946 853 77 0
1678 1678 2021-08-05 Tulare 107 50869 853 70 0
1736 1736 2021-08-04 Tulare 107 50799 853 68 0
1794 1794 2021-08-03 Tulare 107 50731 853 28 0
1852 1852 2021-08-02 Tulare 107 50703 853 425 0
1910 1910 2021-08-01 Tulare 107 50278 853 0 0
1968 1968 2021-07-31 Tulare 107 50278 853 0 0
2026 2026 2021-07-30 Tulare 107 50278 853 0 0
2084 2084 2021-07-29 Tulare 107 50278 853 0 0
2142 2142 2021-07-28 Tulare 107 50278 853 204 0
2200 2200 2021-07-27 Tulare 107 50074 853 0 0
2258 2258 2021-07-26 Tulare 107 50074 853 0 0
2316 2316 2021-07-25 Tulare 107 50074 853 0 0
2374 2374 2021-07-24 Tulare 107 50074 853 0 0
2432 2432 2021-07-23 Tulare 107 50074 853 0 0
2490 2490 2021-07-22 Tulare 107 50074 853 0 0
2548 2548 2021-07-21 Tulare 107 50074 853 110 1
2606 2606 2021-07-20 Tulare 107 49964 852 0 0
2664 2664 2021-07-19 Tulare 107 49964 852 0 0
2722 2722 2021-07-18 Tulare 107 49964 852 0 0
2780 2780 2021-07-17 Tulare 107 49964 852 0 0
2838 2838 2021-07-16 Tulare 107 49964 852 0 0
2896 2896 2021-07-15 Tulare 107 49964 852 0 0
2954 2954 2021-07-14 Tulare 107 49964 852 49 0
3012 3012 2021-07-13 Tulare 107 49915 852 0 0
3070 3070 2021-07-12 Tulare 107 49915 852 0 0
3128 3128 2021-07-11 Tulare 107 49915 852 0 0
3186 3186 2021-07-10 Tulare 107 49915 852 0 0
3244 3244 2021-07-09 Tulare 107 49915 852 0 0
3302 3302 2021-07-08 Tulare 107 49915 852 0 0
3360 3360 2021-07-07 Tulare 107 49915 852 19 2
3418 3418 2021-07-06 Tulare 107 49896 850 0 0
3476 3476 2021-07-05 Tulare 107 49896 850 0 0
3534 3534 2021-07-04 Tulare 107 49896 850 0 0
3592 3592 2021-07-03 Tulare 107 49896 850 0 0
3650 3650 2021-07-02 Tulare 107 49896 850 0 0
3708 3708 2021-07-01 Tulare 107 49896 850 0 0
3766 3766 2021-06-30 Tulare 107 49896 850 73 0
3824 3824 2021-06-29 Tulare 107 49823 850 0 0
3882 3882 2021-06-28 Tulare 107 49823 850 0 0
3940 3940 2021-06-27 Tulare 107 49823 850 0 0
3998 3998 2021-06-26 Tulare 107 49823 850 0 0
4056 4056 2021-06-25 Tulare 107 49823 850 0 0
4114 4114 2021-06-24 Tulare 107 49823 850 14 1
4172 4172 2021-06-23 Tulare 107 49809 849 7 0
4230 4230 2021-06-22 Tulare 107 49802 849 26 0
4288 4288 2021-06-21 Tulare 107 49776 849 0 0
4346 4346 2021-06-20 Tulare 107 49776 849 0 0
4404 4404 2021-06-19 Tulare 107 49776 849 0 0
4462 4462 2021-06-18 Tulare 107 49776 849 0 0
4520 4520 2021-06-17 Tulare 107 49776 849 8 0
4578 4578 2021-06-16 Tulare 107 49768 849 10 0
4636 4636 2021-06-15 Tulare 107 49758 849 0 0
4694 4694 2021-06-14 Tulare 107 49758 849 0 0
4752 4752 2021-06-13 Tulare 107 49758 849 0 0
4810 4810 2021-06-12 Tulare 107 49758 849 0 0
4868 4868 2021-06-11 Tulare 107 49758 849 0 0
4926 4926 2021-06-10 Tulare 107 49758 849 0 0
4984 4984 2021-06-09 Tulare 107 49758 849 0 1
5042 5042 2021-06-08 Tulare 107 49758 848 0 0
5100 5100 2021-06-07 Tulare 107 49758 848 0 1
5158 5158 2021-06-06 Tulare 107 49758 847 0 0
5216 5216 2021-06-05 Tulare 107 49758 847 0 0
5274 5274 2021-06-04 Tulare 107 49758 847 0 1
5332 5332 2021-06-03 Tulare 107 49758 846 0 0
5390 5390 2021-06-02 Tulare 107 49758 846 0 0
5448 5448 2021-06-01 Tulare 107 49758 846 0 0
5506 5506 2021-05-31 Tulare 107 49758 846 0 0
5564 5564 2021-05-30 Tulare 107 49758 846 0 0
5622 5622 2021-05-29 Tulare 107 49758 846 0 0
5680 5680 2021-05-28 Tulare 107 49758 846 0 3
5738 5738 2021-05-27 Tulare 107 49758 843 0 0
5796 5796 2021-05-26 Tulare 107 49758 843 0 1

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