latimes_county_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_county_totals
559 rows where county = "San Diego" sorted by new_deaths
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 ▼ |
---|---|---|---|---|---|---|---|---|
6011 | 6011 | 2021-05-22 | San Diego | 73 | 279613 | 3747 | 60 | -1 |
95 | 95 | 2021-09-01 | San Diego | 73 | 334377 | 3888 | 0 | 0 |
269 | 269 | 2021-08-29 | San Diego | 73 | 331330 | 3880 | 0 | 0 |
501 | 501 | 2021-08-25 | San Diego | 73 | 325823 | 3851 | 0 | 0 |
617 | 617 | 2021-08-23 | San Diego | 73 | 324537 | 3848 | 1917 | 0 |
733 | 733 | 2021-08-21 | San Diego | 73 | 321102 | 3846 | 0 | 0 |
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 |
1197 | 1197 | 2021-08-13 | San Diego | 73 | 312294 | 3821 | 1698 | 0 |
1429 | 1429 | 2021-08-09 | San Diego | 73 | 306855 | 3811 | 872 | 0 |
1487 | 1487 | 2021-08-08 | San Diego | 73 | 305983 | 3811 | 1009 | 0 |
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 |
2241 | 2241 | 2021-07-26 | San Diego | 73 | 292688 | 3793 | 2063 | 0 |
2299 | 2299 | 2021-07-25 | San Diego | 73 | 290625 | 3793 | 0 | 0 |
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 |
2995 | 2995 | 2021-07-13 | San Diego | 73 | 284996 | 3785 | 349 | 0 |
3111 | 3111 | 2021-07-11 | San Diego | 73 | 283818 | 3784 | 0 | 0 |
3169 | 3169 | 2021-07-10 | San Diego | 73 | 283818 | 3784 | 0 | 0 |
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 |
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 |
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 |
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 |
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 |
5953 | 5953 | 2021-05-23 | San Diego | 73 | 279689 | 3747 | 76 | 0 |
6069 | 6069 | 2021-05-21 | San Diego | 73 | 279553 | 3748 | 64 | 0 |
6243 | 6243 | 2021-05-18 | San Diego | 73 | 279253 | 3742 | 108 | 0 |
6301 | 6301 | 2021-05-17 | San Diego | 73 | 279145 | 3742 | 47 | 0 |
6533 | 6533 | 2021-05-13 | San Diego | 73 | 278591 | 3729 | 190 | 0 |
6649 | 6649 | 2021-05-11 | San Diego | 73 | 278307 | 3725 | 125 | 0 |
6707 | 6707 | 2021-05-10 | San Diego | 73 | 278182 | 3725 | 233 | 0 |
6765 | 6765 | 2021-05-09 | San Diego | 73 | 277949 | 3725 | 190 | 0 |
6939 | 6939 | 2021-05-06 | San Diego | 73 | 277323 | 3716 | 226 | 0 |
7113 | 7113 | 2021-05-03 | San Diego | 73 | 276692 | 3712 | 172 | 0 |
7461 | 7461 | 2021-04-27 | San Diego | 73 | 275684 | 3692 | 144 | 0 |
7519 | 7519 | 2021-04-26 | San Diego | 73 | 275540 | 3692 | 129 | 0 |
7693 | 7693 | 2021-04-23 | San Diego | 73 | 275251 | 3684 | 0 | 0 |
7867 | 7867 | 2021-04-20 | San Diego | 73 | 275251 | 3674 | 139 | 0 |
7925 | 7925 | 2021-04-19 | San Diego | 73 | 275112 | 3674 | 152 | 0 |
7983 | 7983 | 2021-04-18 | San Diego | 73 | 274960 | 3674 | 149 | 0 |
8331 | 8331 | 2021-04-12 | San Diego | 73 | 273430 | 3621 | 144 | 0 |
8737 | 8737 | 2021-04-05 | San Diego | 73 | 271654 | 3583 | 127 | 0 |
8969 | 8969 | 2021-04-01 | San Diego | 73 | 270539 | 3555 | 252 | 0 |
9027 | 9027 | 2021-03-31 | San Diego | 73 | 270287 | 3555 | 290 | 0 |
9143 | 9143 | 2021-03-29 | San Diego | 73 | 269770 | 3547 | 290 | 0 |
9549 | 9549 | 2021-03-22 | San Diego | 73 | 267917 | 3494 | 189 | 0 |
9665 | 9665 | 2021-03-20 | San Diego | 73 | 267536 | 3491 | 359 | 0 |
9955 | 9955 | 2021-03-15 | San Diego | 73 | 265649 | 3452 | 178 | 0 |
10129 | 10129 | 2021-03-12 | San Diego | 73 | 264527 | 3422 | 0 | 0 |
10361 | 10361 | 2021-03-08 | San Diego | 73 | 263275 | 3390 | 307 | 0 |
10767 | 10767 | 2021-03-01 | San Diego | 73 | 260625 | 3303 | 269 | 0 |
11173 | 11173 | 2021-02-22 | San Diego | 73 | 257351 | 3189 | 321 | 0 |
11579 | 11579 | 2021-02-15 | San Diego | 73 | 252943 | 3037 | 693 | 0 |
11985 | 11985 | 2021-02-08 | San Diego | 73 | 247262 | 2821 | 698 | 0 |
12391 | 12391 | 2021-02-01 | San Diego | 73 | 239124 | 2619 | 1082 | 0 |
12797 | 12797 | 2021-01-25 | San Diego | 73 | 228632 | 2375 | 1437 | 0 |
13203 | 13203 | 2021-01-18 | San Diego | 73 | 214337 | 2103 | 2550 | 0 |
13609 | 13609 | 2021-01-11 | San Diego | 73 | 194795 | 1857 | 2907 | 0 |
14073 | 14073 | 2021-01-03 | San Diego | 73 | 168020 | 1592 | 3520 | 0 |
14131 | 14131 | 2021-01-02 | San Diego | 73 | 164500 | 1592 | 4427 | 0 |
14479 | 14479 | 2020-12-27 | San Diego | 73 | 145779 | 1402 | 3132 | 0 |
14537 | 14537 | 2020-12-26 | San Diego | 73 | 142647 | 1402 | 2686 | 0 |
14885 | 14885 | 2020-12-20 | San Diego | 73 | 126465 | 1280 | 3493 | 0 |
15233 | 15233 | 2020-12-14 | San Diego | 73 | 109578 | 1162 | 2206 | 0 |
15639 | 15639 | 2020-12-07 | San Diego | 73 | 94169 | 1062 | 1998 | 0 |
16045 | 16045 | 2020-11-30 | San Diego | 73 | 82043 | 997 | 959 | 0 |
16103 | 16103 | 2020-11-29 | San Diego | 73 | 81084 | 997 | 1066 | 0 |
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 );