latimes_agency_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_agency_totals
559 rows where county = "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 |
---|---|---|---|---|---|---|---|---|
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 | |
12240 | 12240 | San Diego | San Diego | 73 | 2021-02-14 | 252250 | 3037 | |
12301 | 12301 | San Diego | San Diego | 73 | 2021-02-13 | 251682 | 3009 | |
12362 | 12362 | San Diego | San Diego | 73 | 2021-02-12 | 250791 | 2979 | |
12423 | 12423 | San Diego | San Diego | 73 | 2021-02-11 | 249974 | 2955 | |
12484 | 12484 | San Diego | San Diego | 73 | 2021-02-10 | 248861 | 2904 | |
12545 | 12545 | San Diego | San Diego | 73 | 2021-02-09 | 248051 | 2853 | |
12606 | 12606 | San Diego | San Diego | 73 | 2021-02-08 | 247262 | 2821 | |
12667 | 12667 | San Diego | San Diego | 73 | 2021-02-07 | 246564 | 2821 | |
12728 | 12728 | San Diego | San Diego | 73 | 2021-02-06 | 245334 | 2812 | |
12789 | 12789 | San Diego | San Diego | 73 | 2021-02-05 | 244069 | 2777 | |
12850 | 12850 | San Diego | San Diego | 73 | 2021-02-04 | 242616 | 2738 | |
12911 | 12911 | San Diego | San Diego | 73 | 2021-02-03 | 241018 | 2683 | |
12972 | 12972 | San Diego | San Diego | 73 | 2021-02-02 | 240050 | 2629 | |
13033 | 13033 | San Diego | San Diego | 73 | 2021-02-01 | 239124 | 2619 | |
13094 | 13094 | San Diego | San Diego | 73 | 2021-01-31 | 238042 | 2619 | |
13155 | 13155 | San Diego | San Diego | 73 | 2021-01-30 | 236768 | 2603 | |
13216 | 13216 | San Diego | San Diego | 73 | 2021-01-29 | 234640 | 2571 | |
13277 | 13277 | San Diego | San Diego | 73 | 2021-01-28 | 232970 | 2534 | |
13338 | 13338 | San Diego | San Diego | 73 | 2021-01-27 | 231481 | 2465 | |
13399 | 13399 | San Diego | San Diego | 73 | 2021-01-26 | 230066 | 2421 | |
13460 | 13460 | San Diego | San Diego | 73 | 2021-01-25 | 228632 | 2375 | |
13521 | 13521 | San Diego | San Diego | 73 | 2021-01-24 | 227195 | 2375 | |
13582 | 13582 | San Diego | San Diego | 73 | 2021-01-23 | 225558 | 2344 | |
13643 | 13643 | San Diego | San Diego | 73 | 2021-01-22 | 222578 | 2301 | |
13704 | 13704 | San Diego | San Diego | 73 | 2021-01-21 | 219731 | 2222 | |
13765 | 13765 | San Diego | San Diego | 73 | 2021-01-20 | 218555 | 2174 | |
13826 | 13826 | San Diego | San Diego | 73 | 2021-01-19 | 216835 | 2109 | |
13887 | 13887 | San Diego | San Diego | 73 | 2021-01-18 | 214337 | 2103 | |
13948 | 13948 | San Diego | San Diego | 73 | 2021-01-17 | 211787 | 2103 | |
14009 | 14009 | San Diego | San Diego | 73 | 2021-01-16 | 209897 | 2065 | |
14070 | 14070 | San Diego | San Diego | 73 | 2021-01-15 | 206870 | 2037 | |
14131 | 14131 | San Diego | San Diego | 73 | 2021-01-14 | 204175 | 2005 | |
14192 | 14192 | San Diego | San Diego | 73 | 2021-01-13 | 201580 | 1952 | |
14253 | 14253 | San Diego | San Diego | 73 | 2021-01-12 | 198319 | 1898 |
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 );