latimes_agency_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_agency_totals
559 rows where agency = "San Diego" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | agency | county | fips | date ▲ | confirmed_cases | deaths | did_not_update |
---|---|---|---|---|---|---|---|---|
6140 | 6140 | San Diego | San Diego | 73 | 2021-05-25 | 279785 | 3753 | |
6201 | 6201 | San Diego | San Diego | 73 | 2021-05-24 | 279714 | 3749 | |
6262 | 6262 | San Diego | San Diego | 73 | 2021-05-23 | 279689 | 3747 | |
6323 | 6323 | San Diego | San Diego | 73 | 2021-05-22 | 279613 | 3747 | |
6384 | 6384 | San Diego | San Diego | 73 | 2021-05-21 | 279553 | 3748 | |
6445 | 6445 | San Diego | San Diego | 73 | 2021-05-20 | 279489 | 3748 | |
6506 | 6506 | San Diego | San Diego | 73 | 2021-05-19 | 279344 | 3746 | |
6567 | 6567 | San Diego | San Diego | 73 | 2021-05-18 | 279253 | 3742 | |
6628 | 6628 | San Diego | San Diego | 73 | 2021-05-17 | 279145 | 3742 | |
6689 | 6689 | San Diego | San Diego | 73 | 2021-05-16 | 279098 | 3742 | |
6750 | 6750 | San Diego | San Diego | 73 | 2021-05-15 | 278990 | 3737 | |
6811 | 6811 | San Diego | San Diego | 73 | 2021-05-14 | 278852 | 3732 | |
6872 | 6872 | San Diego | San Diego | 73 | 2021-05-13 | 278591 | 3729 | |
6933 | 6933 | San Diego | San Diego | 73 | 2021-05-12 | 278401 | 3729 | |
6994 | 6994 | San Diego | San Diego | 73 | 2021-05-11 | 278307 | 3725 | |
7055 | 7055 | San Diego | San Diego | 73 | 2021-05-10 | 278182 | 3725 | |
7116 | 7116 | San Diego | San Diego | 73 | 2021-05-09 | 277949 | 3725 | |
7177 | 7177 | San Diego | San Diego | 73 | 2021-05-08 | 277759 | 3725 | |
7238 | 7238 | San Diego | San Diego | 73 | 2021-05-07 | 277533 | 3718 | |
7299 | 7299 | San Diego | San Diego | 73 | 2021-05-06 | 277323 | 3716 | |
7360 | 7360 | San Diego | San Diego | 73 | 2021-05-05 | 277097 | 3716 | |
7421 | 7421 | San Diego | San Diego | 73 | 2021-05-04 | 276878 | 3713 | |
7482 | 7482 | San Diego | San Diego | 73 | 2021-05-03 | 276692 | 3712 | |
7543 | 7543 | San Diego | San Diego | 73 | 2021-05-02 | 276520 | 3712 | |
7604 | 7604 | San Diego | San Diego | 73 | 2021-05-01 | 276366 | 3706 | |
7665 | 7665 | San Diego | San Diego | 73 | 2021-04-30 | 276156 | 3702 | |
7726 | 7726 | San Diego | San Diego | 73 | 2021-04-29 | 275960 | 3700 | |
7787 | 7787 | San Diego | San Diego | 73 | 2021-04-28 | 275820 | 3698 | |
7848 | 7848 | San Diego | San Diego | 73 | 2021-04-27 | 275684 | 3692 | |
7909 | 7909 | San Diego | San Diego | 73 | 2021-04-26 | 275540 | 3692 | |
7970 | 7970 | San Diego | San Diego | 73 | 2021-04-25 | 275411 | 3692 | |
8031 | 8031 | San Diego | San Diego | 73 | 2021-04-24 | 275251 | 3688 | |
8092 | 8092 | San Diego | San Diego | 73 | 2021-04-23 | 275251 | 3684 | |
8153 | 8153 | San Diego | San Diego | 73 | 2021-04-22 | 275251 | 3684 | |
8214 | 8214 | San Diego | San Diego | 73 | 2021-04-21 | 275251 | 3681 | |
8275 | 8275 | San Diego | San Diego | 73 | 2021-04-20 | 275251 | 3674 | |
8336 | 8336 | San Diego | San Diego | 73 | 2021-04-19 | 275112 | 3674 | |
8397 | 8397 | San Diego | San Diego | 73 | 2021-04-18 | 274960 | 3674 | |
8458 | 8458 | San Diego | San Diego | 73 | 2021-04-17 | 274811 | 3674 | |
8519 | 8519 | San Diego | San Diego | 73 | 2021-04-16 | 274566 | 3662 | |
8580 | 8580 | San Diego | San Diego | 73 | 2021-04-15 | 274249 | 3653 | |
8641 | 8641 | San Diego | San Diego | 73 | 2021-04-14 | 273968 | 3648 | |
8702 | 8702 | San Diego | San Diego | 73 | 2021-04-13 | 273708 | 3623 | |
8763 | 8763 | San Diego | San Diego | 73 | 2021-04-12 | 273430 | 3621 | |
8824 | 8824 | San Diego | San Diego | 73 | 2021-04-11 | 273286 | 3621 | |
8885 | 8885 | San Diego | San Diego | 73 | 2021-04-10 | 273057 | 3613 | |
8946 | 8946 | San Diego | San Diego | 73 | 2021-04-09 | 272696 | 3600 | |
9007 | 9007 | San Diego | San Diego | 73 | 2021-04-08 | 272494 | 3592 | |
9068 | 9068 | San Diego | San Diego | 73 | 2021-04-07 | 272194 | 3588 | |
9129 | 9129 | San Diego | San Diego | 73 | 2021-04-06 | 271866 | 3585 | |
9190 | 9190 | San Diego | San Diego | 73 | 2021-04-05 | 271654 | 3583 | |
9251 | 9251 | San Diego | San Diego | 73 | 2021-04-04 | 271527 | 3583 | |
9312 | 9312 | San Diego | San Diego | 73 | 2021-04-03 | 271334 | 3571 | |
9373 | 9373 | San Diego | San Diego | 73 | 2021-04-02 | 271035 | 3568 | |
9434 | 9434 | San Diego | San Diego | 73 | 2021-04-01 | 270539 | 3555 | |
9495 | 9495 | San Diego | San Diego | 73 | 2021-03-31 | 270287 | 3555 | |
9556 | 9556 | San Diego | San Diego | 73 | 2021-03-30 | 269997 | 3555 | |
9617 | 9617 | San Diego | San Diego | 73 | 2021-03-29 | 269770 | 3547 | |
9678 | 9678 | San Diego | San Diego | 73 | 2021-03-28 | 269480 | 3547 | |
9739 | 9739 | San Diego | San Diego | 73 | 2021-03-27 | 269275 | 3540 | |
9800 | 9800 | San Diego | San Diego | 73 | 2021-03-26 | 269049 | 3525 | |
9861 | 9861 | San Diego | San Diego | 73 | 2021-03-25 | 268627 | 3520 | |
9922 | 9922 | San Diego | San Diego | 73 | 2021-03-24 | 268417 | 3509 | |
9983 | 9983 | San Diego | San Diego | 73 | 2021-03-23 | 268160 | 3498 | |
10044 | 10044 | San Diego | San Diego | 73 | 2021-03-22 | 267917 | 3494 | |
10105 | 10105 | San Diego | San Diego | 73 | 2021-03-21 | 267728 | 3494 | |
10166 | 10166 | San Diego | San Diego | 73 | 2021-03-20 | 267536 | 3491 | |
10227 | 10227 | San Diego | San Diego | 73 | 2021-03-19 | 267177 | 3491 | |
10288 | 10288 | San Diego | San Diego | 73 | 2021-03-18 | 266756 | 3478 | |
10349 | 10349 | San Diego | San Diego | 73 | 2021-03-17 | 266317 | 3470 | |
10410 | 10410 | San Diego | San Diego | 73 | 2021-03-16 | 265906 | 3462 | |
10471 | 10471 | San Diego | San Diego | 73 | 2021-03-15 | 265649 | 3452 | |
10532 | 10532 | San Diego | San Diego | 73 | 2021-03-14 | 265471 | 3452 | |
10593 | 10593 | San Diego | San Diego | 73 | 2021-03-13 | 265273 | 3444 | |
10654 | 10654 | San Diego | San Diego | 73 | 2021-03-12 | 264527 | 3422 | |
10715 | 10715 | San Diego | San Diego | 73 | 2021-03-11 | 264527 | 3422 | |
10776 | 10776 | San Diego | San Diego | 73 | 2021-03-10 | 264097 | 3413 | |
10837 | 10837 | San Diego | San Diego | 73 | 2021-03-09 | 263748 | 3405 | |
10898 | 10898 | San Diego | San Diego | 73 | 2021-03-08 | 263275 | 3390 | |
10959 | 10959 | San Diego | San Diego | 73 | 2021-03-07 | 262968 | 3390 | |
11020 | 11020 | San Diego | San Diego | 73 | 2021-03-06 | 262781 | 3385 | |
11081 | 11081 | San Diego | San Diego | 73 | 2021-03-05 | 262360 | 3371 | |
11142 | 11142 | San Diego | San Diego | 73 | 2021-03-04 | 261861 | 3359 | |
11203 | 11203 | San Diego | San Diego | 73 | 2021-03-03 | 261353 | 3342 | |
11264 | 11264 | San Diego | San Diego | 73 | 2021-03-02 | 261001 | 3317 | |
11325 | 11325 | San Diego | San Diego | 73 | 2021-03-01 | 260625 | 3303 | |
11386 | 11386 | San Diego | San Diego | 73 | 2021-02-28 | 260356 | 3303 | |
11447 | 11447 | San Diego | San Diego | 73 | 2021-02-27 | 260094 | 3284 | |
11508 | 11508 | San Diego | San Diego | 73 | 2021-02-26 | 259644 | 3271 | |
11569 | 11569 | San Diego | San Diego | 73 | 2021-02-25 | 258982 | 3260 | |
11630 | 11630 | San Diego | San Diego | 73 | 2021-02-24 | 258463 | 3230 | |
11691 | 11691 | San Diego | San Diego | 73 | 2021-02-23 | 257805 | 3218 | |
11752 | 11752 | San Diego | San Diego | 73 | 2021-02-22 | 257351 | 3189 | |
11813 | 11813 | San Diego | San Diego | 73 | 2021-02-21 | 257030 | 3189 | |
11874 | 11874 | San Diego | San Diego | 73 | 2021-02-20 | 256513 | 3188 | |
11935 | 11935 | San Diego | San Diego | 73 | 2021-02-19 | 255802 | 3169 | |
11996 | 11996 | San Diego | San Diego | 73 | 2021-02-18 | 254990 | 3135 | |
12057 | 12057 | San Diego | San Diego | 73 | 2021-02-17 | 254180 | 3099 | |
12118 | 12118 | San Diego | San Diego | 73 | 2021-02-16 | 253641 | 3042 | |
12179 | 12179 | San Diego | San Diego | 73 | 2021-02-15 | 252943 | 3037 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [latimes_agency_totals] ( [agency] TEXT, [county] TEXT, [fips] INTEGER, [date] TEXT, [confirmed_cases] INTEGER, [deaths] INTEGER, [did_not_update] TEXT );