latimes_county_totals
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
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: confirmed_cases, deaths, new_deaths, date (date)
new_confirmed_cases 404 ✖
- 0 43
- 108 5
- 117 5
- 71 4
- 96 4
- 1 3
- 58 3
- 76 3
- 83 3
- 110 3
- 120 3
- 124 3
- 131 3
- 132 3
- 139 3
- 140 3
- 210 3
- 226 3
- 263 3
- 269 3
- 278 3
- 290 3
- 9 2
- 25 2
- 43 2
- 50 2
- 51 2
- 55 2
- 57 2
- 65 2
- 68 2
- 73 2
- 82 2
- 84 2
- 85 2
- 98 2
- 101 2
- 111 2
- 114 2
- 125 2
- 126 2
- 142 2
- 143 2
- 144 2
- 145 2
- 152 2
- 161 2
- 174 2
- 187 2
- 190 2
- 195 2
- 198 2
- 202 2
- 228 2
- 233 2
- 236 2
- 257 2
- 264 2
- 265 2
- 267 2
- 279 2
- 282 2
- 284 2
- 291 2
- 304 2
- 306 2
- 307 2
- 317 2
- 330 2
- 348 2
- 349 2
- 352 2
- 358 2
- 361 2
- 401 2
- 409 2
- 421 2
- 430 2
- 453 2
- 473 2
- 498 2
- 508 2
- 539 2
- 568 2
- 698 2
- 810 2
- 1168 2
- 2 1
- 5 1
- 6 1
- 11 1
- 12 1
- 13 1
- 18 1
- 30 1
- 31 1
- 35 1
- 42 1
- 45 1
- 47 1
- 48 1
- 54 1
- 59 1
- 60 1
- 61 1
- 62 1
- 64 1
- 67 1
- 74 1
- 75 1
- 77 1
- 78 1
- 80 1
- 91 1
- 92 1
- 93 1
- 94 1
- 97 1
- 100 1
- 104 1
- 106 1
- 109 1
- 113 1
- 115 1
- 116 1
- 118 1
- 119 1
- 127 1
- 129 1
- 134 1
- 136 1
- 137 1
- 138 1
- 146 1
- 147 1
- 149 1
- 150 1
- 154 1
- 159 1
- 160 1
- 165 1
- 170 1
- 171 1
- 172 1
- 173 1
- 175 1
- 178 1
- 182 1
- 183 1
- 184 1
- 186 1
- 189 1
- 192 1
- 193 1
- 196 1
- 200 1
- 201 1
- 205 1
- 208 1
- 212 1
- 214 1
- 219 1
- 222 1
- 224 1
- 227 1
- 229 1
- 232 1
- 235 1
- 238 1
- 240 1
- 242 1
- 243 1
- 245 1
- 247 1
- 250 1
- 251 1
- 252 1
- 253 1
- 258 1
- 260 1
- 261 1
- 262 1
- 266 1
- 272 1
- 274 1
- 277 1
- 281 1
- 283 1
- 285 1
- 286 1
- 293 1
- 294 1
- 299 1
- 300 1
- 302 1
- 303 1
- 305 1
- 308 1
- 310 1
- 311 1
- 320 1
- 321 1
- 325 1
- 328 1
- 332 1
- 334 1
- 335 1
- 337 1
- 343 1
- 354 1
- 357 1
- 359 1
- 360 1
- 373 1
- 376 1
- 380 1
- 381 1
- 385 1
- 386 1
- 388 1
- 404 1
- 405 1
- 406 1
- 408 1
- 411 1
- 417 1
- 419 1
- 422 1
- 427 1
- 429 1
- 436 1
- 439 1
- 440 1
- 443 1
- 445 1
- 450 1
- 454 1
- 461 1
- 471 1
- 474 1
- 480 1
- 483 1
- 489 1
- 490 1
- 496 1
- 497 1
- 499 1
- 501 1
- 513 1
- 514 1
- 517 1
- 519 1
- 523 1
- 529 1
- 530 1
- 540 1
- 551 1
- 558 1
- 559 1
- 560 1
- 578 1
- 584 1
- 587 1
- 589 1
- 603 1
- 611 1
- 625 1
- 634 1
- 652 1
- 658 1
- 662 1
- 686 1
- 693 1
- 711 1
- 718 1
- 720 1
- 736 1
- 746 1
- 768 1
- 776 1
- 789 1
- 794 1
- 812 1
- 817 1
- 829 1
- 833 1
- 872 1
- 878 1
- 881 1
- 891 1
- 899 1
- 911 1
- 922 1
- 925 1
- 926 1
- 939 1
- 944 1
- 959 1
- 968 1
- 1009 1
- 1019 1
- 1030 1
- 1066 1
- 1082 1
- 1087 1
- 1091 1
- 1094 1
- 1113 1
- 1118 1
- 1120 1
- 1167 1
- 1176 1
- 1190 1
- 1217 1
- 1230 1
- 1258 1
- 1265 1
- 1274 1
- 1276 1
- 1281 1
- 1283 1
- 1286 1
- 1291 1
- 1295 1
- 1366 1
- 1378 1
- 1408 1
- 1415 1
- 1430 1
- 1433 1
- 1434 1
- 1437 1
- 1453 1
- 1471 1
- 1478 1
- 1489 1
- 1504 1
- 1518 1
- 1520 1
- 1546 1
- 1598 1
- 1637 1
- 1670 1
- 1681 1
- 1698 1
- 1703 1
- 1710 1
- 1720 1
- 1751 1
- 1759 1
- 1814 1
- 1859 1
- 1863 1
- 1886 1
- 1890 1
- 1917 1
- 1998 1
- 2039 1
- 2050 1
- 2063 1
- 2104 1
- 2128 1
- 2206 1
- 2259 1
- 2287 1
- 2381 1
- 2416 1
- 2448 1
- 2453 1
- 2490 1
- 2498 1
- 2509 1
- 2534 1
- 2550 1
- 2595 1
- 2598 1
- 2604 1
- 2686 1
- 2695 1
- 2807 1
- 2847 1
- 2854 1
- 2867 1
- 2907 1
- 2980 1
- 3006 1
- 3013 1
- 3027 1
- 3083 1
- 3132 1
- 3252 1
- 3261 1
- 3288 1
- 3493 1
- 3520 1
- 3524 1
- 3538 1
- 3611 1
- 3815 1
- 3850 1
- 4427 1
- 4478 1
- 4550 1
- - 1
fips 1
- 73 · 559 ✖
county 1
- San Diego 559
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 |
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 );