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

559 rows where fips = 73 sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

fips 1

  • 73 · 559 ✖

county 1

Link rowid date ▲ county fips confirmed_cases deaths new_confirmed_cases new_deaths
37 37 2021-09-02 San Diego 73 335302 3908 925 20
95 95 2021-09-01 San Diego 73 334377 3888 0 0
153 153 2021-08-31 San Diego 73 334377 3888 1366 3
211 211 2021-08-30 San Diego 73 333011 3885 1681 5
269 269 2021-08-29 San Diego 73 331330 3880 0 0
327 327 2021-08-28 San Diego 73 331330 3880 1168 3
385 385 2021-08-27 San Diego 73 330162 3877 1886 8
443 443 2021-08-26 San Diego 73 328276 3869 2453 18
501 501 2021-08-25 San Diego 73 325823 3851 0 0
559 559 2021-08-24 San Diego 73 325823 3851 1286 3
617 617 2021-08-23 San Diego 73 324537 3848 1917 0
675 675 2021-08-22 San Diego 73 322620 3848 1518 2
733 733 2021-08-21 San Diego 73 321102 3846 0 0
791 791 2021-08-20 San Diego 73 321102 3846 1520 7
849 849 2021-08-19 San Diego 73 319582 3839 1430 5
907 907 2021-08-18 San Diego 73 318152 3834 1094 10
965 965 2021-08-17 San Diego 73 317058 3824 1710 0
1023 1023 2021-08-16 San Diego 73 315348 3824 1759 0
1081 1081 2021-08-15 San Diego 73 313589 3824 0 0
1139 1139 2021-08-14 San Diego 73 313589 3824 1295 3
1197 1197 2021-08-13 San Diego 73 312294 3821 1698 0
1255 1255 2021-08-12 San Diego 73 310596 3821 1190 3
1313 1313 2021-08-11 San Diego 73 309406 3818 1118 3
1371 1371 2021-08-10 San Diego 73 308288 3815 1433 4
1429 1429 2021-08-09 San Diego 73 306855 3811 872 0
1487 1487 2021-08-08 San Diego 73 305983 3811 1009 0
1545 1545 2021-08-07 San Diego 73 304974 3811 1283 1
1603 1603 2021-08-06 San Diego 73 303691 3810 1471 4
1661 1661 2021-08-05 San Diego 73 302220 3806 1120 1
1719 1719 2021-08-04 San Diego 73 301100 3805 911 2
1777 1777 2021-08-03 San Diego 73 300189 3803 1168 5
1835 1835 2021-08-02 San Diego 73 299021 3798 1019 0
1893 1893 2021-08-01 San Diego 73 298002 3798 776 0
1951 1951 2021-07-31 San Diego 73 297226 3798 881 0
2009 2009 2021-07-30 San Diego 73 296345 3798 1291 0
2067 2067 2021-07-29 San Diego 73 295054 3798 878 0
2125 2125 2021-07-28 San Diego 73 294176 3798 768 0
2183 2183 2021-07-27 San Diego 73 293408 3798 720 5
2241 2241 2021-07-26 San Diego 73 292688 3793 2063 0
2299 2299 2021-07-25 San Diego 73 290625 3793 0 0
2357 2357 2021-07-24 San Diego 73 290625 3793 1258 5
2415 2415 2021-07-23 San Diego 73 289367 3788 686 1
2473 2473 2021-07-22 San Diego 73 288681 3787 0 1
2531 2531 2021-07-21 San Diego 73 288681 3786 473 0
2589 2589 2021-07-20 San Diego 73 288208 3786 514 0
2647 2647 2021-07-19 San Diego 73 287694 3786 1408 0
2705 2705 2021-07-18 San Diego 73 286286 3786 0 0
2763 2763 2021-07-17 San Diego 73 286286 3786 0 0
2821 2821 2021-07-16 San Diego 73 286286 3786 589 0
2879 2879 2021-07-15 San Diego 73 285697 3786 429 0
2937 2937 2021-07-14 San Diego 73 285268 3786 272 1
2995 2995 2021-07-13 San Diego 73 284996 3785 349 0
3053 3053 2021-07-12 San Diego 73 284647 3785 829 1
3111 3111 2021-07-11 San Diego 73 283818 3784 0 0
3169 3169 2021-07-10 San Diego 73 283818 3784 0 0
3227 3227 2021-07-09 San Diego 73 283818 3784 242 1
3285 3285 2021-07-08 San Diego 73 283576 3783 200 1
3343 3343 2021-07-07 San Diego 73 283376 3782 794 2
3401 3401 2021-07-06 San Diego 73 282582 3780 0 0
3459 3459 2021-07-05 San Diego 73 282582 3780 0 0
3517 3517 2021-07-04 San Diego 73 282582 3780 0 0
3575 3575 2021-07-03 San Diego 73 282582 3780 0 0
3633 3633 2021-07-02 San Diego 73 282582 3780 0 0
3691 3691 2021-07-01 San Diego 73 282582 3780 0 0
3749 3749 2021-06-30 San Diego 73 282582 3780 84 0
3807 3807 2021-06-29 San Diego 73 282498 3780 82 0
3865 3865 2021-06-28 San Diego 73 282416 3780 58 0
3923 3923 2021-06-27 San Diego 73 282358 3780 96 0
3981 3981 2021-06-26 San Diego 73 282262 3780 106 1
4039 4039 2021-06-25 San Diego 73 282156 3779 104 1
4097 4097 2021-06-24 San Diego 73 282052 3778 116 1
4155 4155 2021-06-23 San Diego 73 281936 3777 50 6
4213 4213 2021-06-22 San Diego 73 281886 3771 137 0
4271 4271 2021-06-21 San Diego 73 281749 3771 0 0
4329 4329 2021-06-20 San Diego 73 281749 3771 68 0
4387 4387 2021-06-19 San Diego 73 281681 3771 74 0
4445 4445 2021-06-18 San Diego 73 281607 3771 77 1
4503 4503 2021-06-17 San Diego 73 281530 3770 108 0
4561 4561 2021-06-16 San Diego 73 281422 3770 48 0
4619 4619 2021-06-15 San Diego 73 281374 3770 61 0
4677 4677 2021-06-14 San Diego 73 281313 3770 111 0
4735 4735 2021-06-13 San Diego 73 281202 3770 0 0
4793 4793 2021-06-12 San Diego 73 281202 3770 59 2
4851 4851 2021-06-11 San Diego 73 281143 3768 92 2
4909 4909 2021-06-10 San Diego 73 281051 3766 111 1
4967 4967 2021-06-09 San Diego 73 280940 3765 62 1
5025 5025 2021-06-08 San Diego 73 280878 3764 71 0
5083 5083 2021-06-07 San Diego 73 280807 3764 65 0
5141 5141 2021-06-06 San Diego 73 280742 3764 67 0
5199 5199 2021-06-05 San Diego 73 280675 3764 120 1
5257 5257 2021-06-04 San Diego 73 280555 3763 126 2
5315 5315 2021-06-03 San Diego 73 280429 3761 83 1
5373 5373 2021-06-02 San Diego 73 280346 3760 42 4
5431 5431 2021-06-01 San Diego 73 280304 3756 51 0
5489 5489 2021-05-31 San Diego 73 280253 3756 45 0
5547 5547 2021-05-30 San Diego 73 280208 3756 58 0
5605 5605 2021-05-29 San Diego 73 280150 3756 108 0
5663 5663 2021-05-28 San Diego 73 280042 3756 83 0
5721 5721 2021-05-27 San Diego 73 279959 3756 101 1
5779 5779 2021-05-26 San Diego 73 279858 3755 73 2

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